Books Watchdog

Xero

Shopify orders not syncing to Xero

You only find out at reconciliation: Xero is short a dozen transactions and the connector's log says one item failed. Here's how to find every missing order and get them in.

Updated 11 November 2026

Why orders go missing

Shopify–Xero connectors (Shopify integration by Xero, Xero Sync by Bold, A2X, Synder and others) push orders across in batches. If one order in a batch fails, the rest usually go through and there's no alert. The common causes:

How does your connector post? If it creates one invoice per order, compare order by order (below). If it posts one summary per payout (A2X, for example), compare payouts instead: see Shopify payout doesn't match the deposit in Xero.

Check by hand

1. Compare the totals

  1. In Shopify admin, go to Analytics → Reports and open Finance Summary (filter the list to the Finances category) for last month. Note gross sales, discounts, returns, shipping and taxes.
  2. In Xero, go to Reporting → All reports → Account Transactions. Under Accounts, choose your sales and shipping income accounts, set the same dates, and click Update.
  3. Compare the totals. A whole-order gap means something didn't sync.

2. List the missing orders

  1. In Shopify admin: Orders, filter to last month, then Export → CSV for Excel. Order numbers are in the Name column.
  2. In Xero, export the same Account Transactions report to a spreadsheet (the export button at the bottom of the report). Depending on the connector, the Shopify order number is in the Reference or Description column. If your connector creates invoices, you can also search them in Sales → Invoices by number, reference or date.
  3. In one spreadsheet, put Shopify order numbers in column A and Xero's reference column in column D. In B2 enter =COUNTIF(D:D,"*"&SUBSTITUTE(A2,"#","")&"*") and fill down.
  4. Rows showing 0 are missing from Xero. Rows showing 2 or more need a look for duplicates.

3. Read the connector's log

Open the connector from Apps in Shopify admin and find its sync history or error list. The message names the item or tax rate it couldn't map. Errors that start on one day and never stop mean the connection dropped.

Fix it

  1. Fix the mapping or reconnect Xero in the connector's settings, so new orders stop failing.
  2. Re-sync the missing orders. Use the connector's retry or date-range re-sync. Re-check for duplicates afterwards.
  3. If one won't sync, create it in Xero by hand: Sales → Invoices → New Invoice, with the same lines, shipping and tax as the Shopify order and the order number as the reference. Record the payment against the same account your connector uses for Shopify payments (often a "Shopify clearing" account), so the payout still reconciles.
  4. Reconcile the payout in Accounting → Bank accounts → Reconcile, using Find & Match if there's no suggestion. If it still won't match, see the payout guide.

If you've already filed a GST, VAT or BAS return for the period, ask your accountant before adding sales to it.