Wix orders and Xero don’t match: 9 common causes and fixes

By Kayabyte

Short answer: when your Wix Stores sales and your Xero books disagree, the cause is almost always one of a few things: an order that never reached Xero, an order that reached it twice, tax or tax-inclusive prices set up differently, refunds and cancellations that were missed, payment fees, or dates and currencies. Work through the list below with one month’s orders and you will usually find the gap in under an hour. It applies whether you enter orders by hand, import a CSV, use an automation tool or an order sync app.

Before you start: compare the right numbers

Pick one closed month. In Wix, open Sales > Orders, filter by that month and export the orders to CSV. In Xero, run a sales report such as Receivable Invoice Summary or Sales by Item for the same dates. Compare three things: the number of orders, the total including tax, and the tax total. Which of the three is off tells you where to look.

1. Orders missing in Xero

The number of invoices is lower than the number of paid orders.

• Automation runs that failed. Zapier and Make stop a run on an error (a missing contact, an unknown tax rate, Xero being busy) and the order is simply skipped. Check the run history for errors in that month.
• Orders paid later. Orders paid offline, by invoice or in parts are often created as unpaid first. A tool that only reacts to “new order” never sees the payment.
• Disconnected Xero access. Xero access tokens expire when nobody reconnects them, and a tool can stop quietly. Check that the connection is still active.
• A plan or usage limit. Some tools hold orders when the monthly limit is reached.

Fix: list the order numbers in both places side by side and send the missing ones again from the tool, or enter them by hand.

2. The same order in Xero twice

The invoice count is higher than the order count, or one customer has two identical invoices.

• An automation was retried by hand after a partial failure.
• Orders were imported by CSV and also synced by a tool.
• Two tools are connected at the same time (a common leftover after switching).

Fix: void the duplicate invoice in Xero (or delete it if it is still a draft), remove the payment from it first if there is one, and disconnect the tool you no longer use.

3. The tax total is off

Usually a set-up difference, not a rounding problem:

• A Wix tax rate has no matching Xero tax rate, so the line used a default rate (often “Tax Exempt” or the standard rate).
• Prices on the store include tax, but invoices were created tax-exclusive, so Xero adds the tax again on top.
• Shipping is taxed in the store but not on the invoice, or the other way round.

Fix: match each tax your store charges to a Xero tax rate once (see Wix Stores VAT, GST and sales tax in Xero), set invoices to the same “tax inclusive” or “tax exclusive” setting as the store, and correct the affected invoices.

4. Totals off by small amounts

A few cents per order usually means tax was recalculated in Xero instead of copied from the order. Xero rounds per line or per invoice depending on your settings; Wix rounds its own way. The safest invoices carry the exact tax the store charged, so totals match to the cent.

5. Refunds that never reached Xero

Revenue in Xero is higher than in Wix. A refund in Wix needs a credit note in Xero, allocated to the invoice, and a refund payment from the bank or clearing account. Many automations only handle new orders, so refunds have to be entered by hand.

6. Cancelled orders still counted

An order that was cancelled before payment should be voided in Xero. An order cancelled after payment needs a credit note when the money goes back. Check the cancelled orders of the month in Wix against Xero.

7. Payment fees and payouts

Your bank receives less than the sales total, because payment fees are taken before each payout. This is not an error in the sales: record the fees when you reconcile each payout (see How to reconcile Wix Payments payouts in Xero). Wix does not share processor fees and payout batches with every app, so check where your tool gets them, if it shows them at all.

8. Dates and time zones

An order placed just before midnight can land in different days, or months, in each system: the store uses the site’s time zone, while a tool or CSV may use UTC. If only the first or last day of the month disagrees, this is the cause, and the totals of the two months together will match.

9. Currencies

An order in another currency than your Xero base currency needs that currency turned on in Xero, and Xero converts it at its own rate for that day. Reports in your base currency will then differ slightly from the store’s own conversion. That is expected; it is not a lost sale.

A quick monthly check

1. Count paid orders in Wix and invoices in Xero for the month.
2. Compare totals including tax, then tax alone.
3. List refunds and cancellations in Wix and find each in Xero.
4. Reconcile the payouts in the bank feed; the difference is fees.
5. Look at the first and last day of the month for date differences.

Where Accounting Sync for Stores fits

Accounting Sync for Stores is our app, so read this part with that in mind. It sends each paid Wix Stores order to Xero as an invoice with the payment applied, using the tax amounts the store actually charged, so totals match to the cent. Refunds become credit notes with the refund payment, unpaid cancelled orders are voided, and each order is sent only once: retries after a Xero error cannot create a second invoice. Orders it could not send stay in the Sync log with a plain reason (for example a tax that is not matched yet, or a locked period) and a Retry button, and a daily check looks for orders that were missed. You can also ask Aria, the AI assistant in your Wix dashboard, “Which orders need my attention?”. It does not sync payment fees or payouts. Plans start at $6 a month with a 14-day trial, and you can try it with Xero’s Demo Company first.

More: connect Wix Stores to Xero, Wix and Xero integration apps compared.