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.
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:
- A mapping the connector can't resolve: a new product, a shipping method, a tax rate that doesn't exist in Xero, or a payment gateway (PayPal, gift cards, manual payments) that isn't mapped to an account.
- A broken connection or bank feed. Xero connections expire and need reconnecting. Until someone does, nothing syncs, and the gap may never be back-filled.
- Plan or date limits. Some connectors only sync from a start date, or cap orders per month on cheaper plans.
- Orders edited after the first sync. Upsells, edits and later payments may not follow the original order across.
- A different date. Orders paid days after they were placed, or near midnight, land on another day.
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
- 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.
- 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.
- Compare the totals. A whole-order gap means something didn't sync.
2. List the missing orders
- In Shopify admin: Orders, filter to last month, then Export → CSV for Excel. Order numbers are in the Name column.
- 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.
- 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. - 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
- Fix the mapping or reconnect Xero in the connector's settings, so new orders stop failing.
- Re-sync the missing orders. Use the connector's retry or date-range re-sync. Re-check for duplicates afterwards.
- 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.
- 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.