From one order to lines per VAT rate
To the customer, an order is one amount. In the books it has to become lines that each carry one VAT rate, because your VAT return reports turnover and VAT per rate. An order with a shirt at 21% and a book at 9% needs at least two product lines, a shipping line, and a discount that lands on the right lines.
Take an order in euros with prices including VAT. A shirt of €60.50 at 21% is €50.00 net plus €10.50 VAT. A book of €21.80 at 9% is €20.00 net plus €1.80 VAT. The customer used a 10% discount code and paid €4.95 shipping, which in this example the shop taxed at 21%.
After the discount, the shirt line is €45.00 net with €9.45 VAT and the book line is €18.00 net with €1.62 VAT. Shipping is €4.09 net with €0.86 VAT. Together that is €79.02, exactly what the customer paid, and the VAT splits into €10.31 at 21% and €1.62 at 9%.
That last check is the one that matters most. The invoice in your books should add up to what the customer paid. If it does not, find the reason before you book, because the difference will otherwise end up in your VAT or on the debtor.
Discounts and shipping in a mixed-rate order
A discount can be recorded per order line or as one amount for the whole order. One amount for the whole order cannot go into a VAT return as it is: it has to be split over the rates first. Shopify gives each line its share of the discount, and that per-line share is what you want in the books.
Integrator follows that approach. The Shopify to Exact Online integration books the net value of each line after its allocated discount. The Shopify to Moneybird integration maps the discount of each order line by default. If a mapping gives one discount for the whole order and the order has products at more than one rate, Moneybird bookings stop for you to book by hand.
Shipping gets its own line with its own VAT rate. In Moneybird the shipping line needs a rate, and a mixed-rate order without one stops. In Exact Online shipping is booked on a separate sales item that must already exist in your administration. Shopify orders where it is unclear how the shipping VAT was allocated also stop for review.
How VAT on shipping should be charged in a mixed order is a tax question for your shop's settings. Agree it with your tax adviser and check that the webshop charges it that way, because the books can only follow what the webshop recorded.
Booking a refund: credit invoice or reversal
There are two ways to handle a refund. You can change or delete the original invoice, or you can leave it alone and book a credit invoice: a separate document with negative amounts for what was returned, dated when the refund happened. A credit invoice keeps a clear trail and does not change a period whose VAT return may already be filed.
Integrator books refunds as credit invoices, one per refund, in both Moneybird and Exact Online. It does not delete or change invoices that already exist. Each credit carries the refunded lines with their own VAT rate, and refunded shipping is included. In Exact Online partial, full and later refunds each get their own credit invoice, and discounts are taken into account.
Sending the same order again does not create a second invoice or credit invoice. In Moneybird the credit invoice is booked to the contact of the original invoice. In Exact Online invoices and credits stay open, so you settle and match them in Exact yourself.
Other changes to an order after it was booked, such as an edited address or a changed line, are not followed. With the Exact Online integration, do not rewrite booked invoice lines by hand before later refunds are booked: a manual change to the lines that keeps the totals the same is not detected.
Where a difference of one cent comes from
VAT is a percentage, and amounts in euros have two decimals, so somewhere a number gets rounded. The result depends on where. Three items at €1.99 including 21% VAT give €1.04 VAT when you calculate on the line total of €5.97, but €1.05 when you round the VAT per item and add it up.
The same thing happens when prices including VAT are converted to net amounts, when an order discount is split over lines at different rates, and when a partial refund is typed in by hand as an amount rather than chosen per product. In a mixed-rate order, a hand-typed refund amount cannot be tied to one rate at all without someone deciding how to split it.
The safe rule is to compare with the webshop's own totals rather than recalculating. Integrator checks that a Shopify order adds up to Shopify's total and refunded total, that the invoice adds up to what the customer paid, and that a credit invoice adds up to the amount returned. When amounts cannot be reconciled without guessing, the order stops for review instead of being booked with a correction nobody chose.
Orders that stop for a person to book
Some orders are better booked by a person, because the data does not say clearly which VAT rate or amount belongs where. In Integrator these orders stop with an explanation, and the other orders keep going. You book the stopped order by hand and mark the problem as solved, or fix the cause and send it again.
The cases below come from the Shopify, Moneybird and Exact Online integrations. Most of them are not errors in your shop: they are situations where an automatic booking would have to guess.
- A refund in a mixed-rate order that returned more or less than the products in it, for example shipping or an amount typed in by hand.
- A credit invoice whose refunded lines and VAT do not add up to the amount returned to the customer.
- An invoice that does not add up to what the customer paid, often because of a gift card or a change made by hand in Shopify.
- Shopify orders with tips, duties or additional fees, refunds that are not settled yet, and refund duties or adjustments.
- In Moneybird: a refund with more than 50 lines or one that refers to a product no longer on the order, an order with more than 10 refunds, or a refunded total in Shopify that differs from its refunds.
- In Moneybird: an order whose VAT percentage or customer country has no active sales tax rate, or where more than one active rate has the same percentage, such as 0%, reverse charge and export.
- In Exact Online: a missing or ambiguous VAT code, incomplete refund amounts, or orders in a currency other than euros.
Moneybird and Exact Online side by side
Both integrations book VAT per line, shipping, discounts and one credit invoice per refund, and both check every 15 minutes or when you press Run now. They differ in what happens after booking and in what must already exist in your administration. Both are in beta, and the Exact Online integration is an opt-in beta that should be tested in an Exact test administration before live use.
- Moneybird: paid Shopify orders become external sales invoices. Moneybird keeps them for your books and does not email them to your customers.
- Moneybird: the invoice is marked paid with the payment date and amount.
- Moneybird: tax rates must be active under Instellingen, Btw-tarieven. Moneybird limits how many requests apps can make, so a large backlog is booked in batches.
- Exact Online: invoices and credits are created as open documents. They are not marked paid, not finalised and not emailed. Payments and matching credits to invoices happen in Exact.
- Exact Online: existing sales items and VAT codes are used, including a shipping item when shipping is charged. VAT codes live under Stamgegevens, Btw-codes.
- Exact Online: VAT codes are matched by rate and country. A foreign order does not quietly get a Dutch code just because the percentage is the same.
Before you connect, and when an order stops
Test with your own awkward orders before anything is booked. With Integrator, a dry run reads up to 20 recent orders with real data and shows what would be written, without writing anything.
- Check that every VAT rate your shop uses exists and is active in your accounting system, including 0% for exports or reverse charge, and that it is clear which one applies.
- In Exact Online, make sure each product has a matching sales item and that a shipping item exists.
- Pick test orders with both rates, a discount code, paid shipping, a partial refund and a full refund, and compare each result line by line with the webshop.
- When an order stops, read the explanation first. Book it by hand and mark it solved, or fix the cause and send it again: a resend does not create a duplicate.
- If Exact Online could not confirm whether an invoice or credit was created, look it up in Exact before you retry.
- Do not delete or rewrite booked invoices to clear a warning. Book the difference with a credit invoice instead.
