What moves from Magento to Exact Online
In Integrator, one Magento order is one record, and it is booked as a sales invoice in one Exact Online administration. An administration is one set of books in Exact. The integration looks for new and changed orders every 15 minutes, and you can start a run yourself with Run now. Changes made in the last minute before a run are picked up on the next one.
From each order it reads the order number, customer, email, billing country, payment status, order lines, VAT per line, discounts, shipping, refunds and totals. Only orders in euros are booked. If your shop has several store views that all sell in euros, orders from all of them are booked.
A configurable product, such as a shirt with a size choice, is read as the product the customer chose. A grouped product is read as the simple products in it. Bundle products are not booked automatically; they stop for review.
- Sales invoice: customer, journal, reference, date, items, VAT per line, discounts and shipping.
- Credit invoice, one per refund: refund reference, date, refunded items, VAT per line and shipping.
- Customer, only when a new one is created: name, email and country.
How lines, VAT, discounts, shipping and refunds are booked
Each order line is matched by SKU to an existing sales item in Exact. VAT is booked per line, so an order with a 21% product and a 9% product gets the right VAT code on each line. Exact VAT codes are chosen by rate and, for orders from other countries, by country as well. A foreign order is not given a domestic VAT code just because the percentage is the same.
Magento spreads a coupon or cart rule discount over the order items. Integrator books that discount on each line instead of adding a separate discount line. Whether your shop takes the discount off the price with or without VAT is a Magento setting that its API does not show, so Integrator checks which reading adds up to the order's grand total. If neither adds up, the order stops for review rather than being booked on a guess.
Shipping is booked on its own sales item in Exact, at the VAT rate Magento applied to the shipping, with any shipping discount taken off. Each refunded credit memo in Magento becomes its own credit invoice in Exact, with the refunded items, VAT per line and shipping when it was refunded. Partial refunds and later refunds each get their own credit invoice.
Payment status is read, but invoices are not marked as paid. Invoices and credit invoices stay open in Exact, and you match payments there. Integrator does not finalise, email or delete invoices.
What does not move or stops for review
A stop applies to one order. The other orders keep moving, and the stopped order shows why it stopped. These are the situations that stop an order or keep it out of Exact:
- Orders in a currency other than euros.
- Orders with bundle products.
- Partly cancelled orders, where some items were cancelled but the order was not.
- Credit memos with an adjustment fee, where the shop keeps part of the money.
- Money refunded in Magento without a refunded credit memo.
- A credit memo for a line that is not on the order, or refunds that add up to more than the order total.
- Totals that do not add up, or a shipping VAT rate that cannot be read from the order.
- Missing, ambiguous or incomplete VAT information, such as no clear matching VAT code in Exact.
- An order that changed in Magento while it was being read. Retry it once the change is finished.
- Changes to an order after it was booked. These are not followed, and the existing invoice is left unchanged, so correct it in Exact by hand.
What to set up in Exact Online and Magento first
Integrator uses the sales items and VAT codes already in your Exact administration. Prepare these items before connecting, and ask your bookkeeper to check the VAT side.
On the Magento side, you need Magento 2.4 or later on an https:// address. Create an integration under System → Extensions → Integrations with Resource Access: Custom, and tick only Sales → Operations → Orders → Actions → View and Sales → Operations → Credit Memos. That integration can read orders but not change them. Magento shows four keys once: the consumer key, consumer secret, access token and access token secret. Copy all four, and enter the address you open the shop on, without /admin.
- An Exact test administration to validate with before live use.
- A sales item in Exact for every SKU you sell, with the item code matching the Magento SKU.
- A shipping sales item, if you charge shipping.
- A VAT code for every rate you sell at, including a zero rate and codes for foreign customers if you need them. VAT codes are in Exact under Stamgegevens → Btw-codes.
- The sales journal the invoices should go into.
- A customer policy: book on one fixed existing customer, match customers by exact email, or allow new customers to be created. Ambiguous matches stop before anything is written.
- An Exact user who has access to the administration you connect.
How to test safely before turning it on
Connect the Exact test administration first. Then run a dry run: it reads up to 20 recent Magento orders with real data and shows, for each one, what would be written to Exact, a new record or one it already has. A dry run writes nothing and creates no customers or invoices.
Check the results against Magento with your bookkeeper. When the test administration looks right, connect the live administration, check a fresh dry run there, and only then turn the integration on. Agree on a cut-over moment, and check in the dry run that orders you already booked by hand are not among the ones that would be created.
- An order with both 21% and 9% products.
- An order with a coupon or cart rule discount.
- An order with shipping, and one with discounted or free shipping.
- An order from a customer in another EU country.
- A partial refund that includes shipping, and a full refund.
- A bundle or non-euro order, if you have them, to confirm they stop.
- Invoice totals in Exact that match the Magento grand total to the cent.
- A second run on the same orders, to confirm no duplicate invoices or credits appear.
What to do when an order stops
Each stopped order shows its reason in an explanation the CLATE team wrote and approved. An error without an approved explanation is shown as not yet explained. You can also trace every order: when it was found, how it was prepared and what Exact answered.
Once the cause is fixed, send the order again. Sending it again does not create a duplicate invoice or credit invoice. If you book an order by hand instead, keep a note so it is not sent again later. If Exact or Magento refuses the login itself, the run stops until you reconnect.
- This order needs review before accounting: a bundle, a partial cancellation, an adjustment fee, totals that do not add up, or a change while it was read. Book it by hand, or retry once the change in Magento is finished. If every order stops here, ask your Integrator administrator.
- A VAT code is missing in Exact Online: add the VAT code under Stamgegevens → Btw-codes or change the VAT mapping, then retry.
- Check the Exact accounting settings: a customer, item, journal or VAT code does not match the order. Correct the reference data in Exact and run a preview again.
- Review the order amounts: lines, VAT, discounts, shipping or refunds could not be reconciled. Correct the source or the mapping and preview again.
- Exact has not confirmed this write: the invoice may already exist. Check Exact before you allow a retry.
- The Exact Online login expired: reconnect Exact Online in Connections.
- Magento does not accept the integration keys: a key is wrong or the integration was reauthorized, which makes new keys. Copy all four keys into the connection again.
