Books Watchdog

QuickBooks Online · Xero

Switched connectors? Check what the changeover missed

Your old Shopify connector was retired, its price went up, or you moved to A2X, Synder or another app. The weeks around the switch are where orders go missing, get posted twice, or pick up the wrong tax code. Here's what to check.

Updated 11 November 2026

What goes wrong in a switch

Read enough 1-star connector reviews and the same story repeats: an app that "worked for years" is replaced, repriced or updated overnight, and the books stop adding up. Switching connectors causes four kinds of problem, all at the changeover date:

ProblemHow it happens
A gapThe old app stopped on Monday; the new one was set to start on Wednesday. Orders in between never sync.
An overlapBoth apps ran for a few days, or the new one's start date is before the old one stopped. Those orders are in twice.
A change of posting typeThe old app posted invoices, the new one posts sales receipts, daily summaries or payout summaries. Reports split, and duplicate checks don't catch the overlap because the types differ.
New mappingsThe new app picks its own accounts and tax codes, sometimes an inactive or wrong tax code, or routes sales into the bank feed for manual approval instead of posting them.

Check by hand

  1. Write down the dates: the last day the old connector posted and the first day the new one did. Look at the newest transaction the old app created and the oldest from the new one. In QuickBooks, Settings (gear icon) → Audit log shows which app created each transaction. In Xero, open a transaction and scroll to History and notes at the bottom (click Show history if it's collapsed).
  2. Count orders per day for two weeks either side of the switch. Shopify: Orders, filtered by date, exported. QuickBooks: Reports → Standard reports → Transaction List by Date. Xero: Reporting → All reports → Account Transactions for your sales account. Any day with fewer is a gap, any day with more is an overlap.
  3. Check the posting type. In the QuickBooks report, look at the Transaction Type column; in Xero, whether it's invoices, one summary invoice a day or manual journals. Mixed types around the switch are where duplicates hide.
  4. Check tax codes on a few orders from after the switch. Open them and compare the tax code and amount with the Shopify order. To see them all at once, add the tax amount and tax code columns to the QuickBooks report: Customize → Columns → More Columns (in the older Classic view: Customize → Rows/Columns → Change columns).
  5. Reconcile the first payouts after the switch. If they don't match, the new connector is missing fees, refunds or adjustments: see QuickBooks payouts or Xero payouts.

Fix it

  1. Make sure only one connector is posting. Disconnect the old one from your accounting software, not just from Shopify.
  2. Fill the gap by re-syncing those dates from the new connector (most allow a historical import), then check for duplicates.
  3. Remove the overlap: keep the copy matched to the bank and void or delete the other. Full steps: duplicate sales in QuickBooks.
  4. Fix the tax mapping in the new connector, then correct the orders already posted with the wrong code. If a return already covers them, ask your accountant first.
  5. Pick one posting type and stick to it, so next month's reports compare like with like.