For Shopify stores on QuickBooks Online or Xero
Your connector says it synced. Did it?
Missing orders, doubled sales, refunds that never arrived, payouts that won't match the bank. These guides show why each one happens, how to check it by hand in QuickBooks Online or Xero, and how to fix it.
Guides
Written from the problems merchants describe in 1- and 2-star reviews of Shopify accounting connectors. Pick the one that sounds like yours.
Orders that didn't arrive
Payouts and bank deposits
- Shopify payout doesn't match the bank deposit in QuickBooksThe Shopify deposit in your bank feed has nothing to match, or the amount is off.
- Shopify payout doesn't match the bank deposit in XeroShopify deposits won't reconcile in Xero, or invoices show as paid at the wrong amount.
- Shopify Payments fees not recorded in QuickBooks or XeroProcessing fees are missing, so every payout is short by the fee amount.
Orders that arrived wrong
Changed or switched connector
Or check a whole month at once
Books Watchdog is a Shopify app that compares your Shopify orders, refunds and Shopify Payments payouts with one export from QuickBooks Online or Xero, whichever connector posted them.
- Pick a period and upload an export. QuickBooks Transaction List by Date or Xero Account Transactions. The app shows you how.
- Free scan. See how many problems there are and how much money isn't in your books.
- Full report if you want it. Every affected order and payout, what's wrong, how to fix it, and a spreadsheet for your bookkeeper. A one-time charge billed through Shopify.
It looks for:
- orders missing from your books
- orders posted twice
- wrong amounts
- refunds not recorded
- payouts with no matching deposit
- payment fees not recorded
- VAT or sales tax mismatches (when the export includes tax columns)
- orders posted as different transaction types
Read-only. It never changes your store or your books, and your export is deleted straight after the check.