Black Friday to Christmas: does your webshop connector keep up with the peak?

4 min read

Black Friday falls on 27 November this year and after that it carries on until Christmas. Five things to check now, so your bookkeeping is correct in January without any catching up.

Illustratie: een winkelmandje met een stijgende pijl, pakketten en een kalender

Black Friday falls on 27 November this year, Cyber Monday on the 30th, and then it is just three weeks until Christmas. Anyone who runs a webshop knows what that means: a large part of the annual turnover comes in over a few weeks, and anything in the administration that was not quite right will truly grind to a halt. Not in November, but in January, when the returns arrive and the accountant asks for the year-end work. So go through these five points now. They will cost you half an hour.

1. Do all orders come in, even on the busiest day?

A connector that sends orders to Exact Online every five minutes notices nothing of a peak: a hundred orders an hour is no different to the connector than ten. What can go wrong lies in the setup. A new product that you created especially for the promotion must exist as an item in Exact; our connector creates it automatically with an item code and price, but check that your variants (size, colour) have their own SKU, otherwise they end up on a single item.

Also check what gets created per order in Exact. On the Financial subscription that is a sales entry, on Invoices a sales invoice, on Trade a sales order with a stock mutation. That is a choice you make before the peak, not after.

2. Does your stock feed back to the shop?

Overselling is the classic Black Friday mistake: the shop keeps selling while the warehouse is empty. If you track your stock in Exact Online, it should go back to your webshop every five minutes. If you also sell through Bol.com, the same applies there: one stock level, all channels reading along.

Test it before the promotion. Set an item to stock 1, sell it in the shop, and see whether it shows as sold out within ten minutes. If not, you now know where things get stuck instead of on 27 November.

3. Will you know later which payout belongs to which order?

This is the check that most entrepreneurs skip, and the one that creates the most work in January. Mollie, Adyen, Stripe, Shopify Payments, PayPal and Bol.com do not pay out per order but in batches, minus their fees. One payout of 4,812 euros can contain 63 orders and 2 refunds. Anyone reconciling that by hand loses a day during the Christmas week.

The reconciliation module does that automatically: the sales go on a suspense account per payment provider, the payout is written off against it, and all you have left to process is the monthly transaction fee invoice from your provider. It costs 17.50 euros per month, regardless of the number of transactions. Switch it on before the peak, because reconciling retroactively is exactly the work you wanted to avoid.

4. How do January's returns enter your administration?

Returns peak two to four weeks after the peak itself. A refund carried out in the shop should end up as a credit note in Exact, connected to the original invoice. Our connectors recognise returns and refunds and create those credit notes. Check now whether that is switched on, and how you want it for a partial return (two of the three items back).

With Bol.com there is something extra: a chargeback or return via Bol is recognised automatically and processed as a credit note, and the batch payment from Bol runs through the same suspense account as above.

5. Are your VAT settings correct per country?

If you sell to consumers in Belgium or Germany for the first time during the peak, the VAT treatment of those orders changes. The connector posts what the shop delivers; whether that is the correct VAT code per country depends on your settings in the shop and in Exact. Check one order per country before the peak begins. A mistake here means you correct hundreds of orders at once in January, and you do not want that.

Benefits and points of attention

A connector removes the retyping and makes the peak invisible in your administration: no backlog, no pile in January. More than 1,000 webshops work this way with Exact Online.

Two things a connector does not solve. A wrong setup only goes wrong faster during the peak, which is why we made this checklist. And the transaction costs of your payment provider remain an invoice you process yourself, one per month. We prefer to mention that in advance rather than have you discover it.

No connector yet?

Installation takes ten minutes, and you can try it for 30 days. Well before 27 November then, even if you start today.

No connector yet? View the webshop connectors for Exact Online →

Frequently asked questions

Yes. The connector transfers orders and stock every five minutes, and the number of orders per hour does not matter for that. Whatever goes wrong during a peak nearly always comes down to the setup: items without their own SKU, stock that does not feed back to the shop, or VAT codes per country that are incorrect.

Keep your stock up to date in Exact Online and let the connector push it back to your webshop and to Bol.com every five minutes. Test it before the sale with an item at stock level 1.

Payment providers pay out in batches, minus costs. The Reconciliation module posts the sales to a suspense account per provider and automatically reconciles the payout against it. You only process the monthly transaction cost invoice yourself. The module costs 17.50 euro per month.

A refund in the shop is recognised and created as a credit note in Exact Online, linked to the original invoice. Check before the peak whether that is switched on and how you want to process partial returns.

Yes. The connector with Exact Online is installed within ten minutes and you can try it free for 30 days. If you start this week, you have plenty of time to carry out the five checks.