QuickBooks Online
Shopify orders missing in QuickBooks Online
Sales in QuickBooks are lower than Shopify says, or a customer's order simply isn't there. Here's why connectors skip orders, how to find exactly which ones, and how to put them back.
Why orders go missing
Your connector (the QuickBooks app in Shopify, A2X, Synder, Bold, MyWorks or another) copies orders across on a schedule. When one order fails, most connectors log an error and carry on. Nothing tells you, so you only notice at month end. The usual causes:
- A sync error that nobody saw. A product, tax rate or payment method that isn't mapped to anything in QuickBooks, an inactive tax code, or a customer name that clashes with an existing one. That order fails and the rest go through.
- The connection dropped. The QuickBooks login behind the connector expired or was disconnected. Nothing syncs until someone reconnects, and some connectors don't go back for the gap.
- A start date or plan limit. Connectors only sync from the date you set when you installed them. Some paid plans stop at a number of orders per month.
- The order changed after it synced. Some connectors only send an order when it's created. An edit, upsell or later payment never reaches QuickBooks, so the amount looks missing even though the order is there.
- It's on another day. An order paid near midnight, or paid days after it was placed (bank transfer, cash on delivery, draft orders), can land on a different date in QuickBooks.
First, check how your connector posts. If it posts one sales receipt or invoice per order, compare order by order (below). If it posts one summary per payout or per day (A2X does this, for example), you won't find individual orders in QuickBooks. Compare payout totals instead: see Shopify payout doesn't match the deposit in QuickBooks.
Check by hand
1. Compare the totals first
- In Shopify admin, go to Analytics → Reports and open Finance Summary (filter the list to the Finances category). Set the date range to last month and note gross sales, discounts, returns and taxes.
- In QuickBooks Online, go to Reports → Standard reports and search for Transaction List by Date. Set the same dates.
- If your connector posts sales receipts, click Customize and filter Transaction Type to Sales Receipt (or Invoice, if that's what it posts).
- Compare the number of transactions with the number of paid orders in Shopify, and the totals. A small gap may be refunds or timing; a gap of whole orders means something didn't sync.
2. Find exactly which orders are missing
- In Shopify admin, go to Orders, filter to the same dates, then Export → Current page / All orders matching your search → CSV for Excel. The order number is in the Name column (for example
#1043). - In the QuickBooks report from step 1, click Export/Print → Export to Excel (or Export as CSV). The order number is usually in the Num or Memo/Description column, depending on your connector.
- Put both lists in one spreadsheet. Shopify order numbers in column A, the QuickBooks Num column in column D. In column B, enter
=COUNTIF(D:D,"*"&SUBSTITUTE(A2,"#","")&"*")and fill down. - Every row with 0 is an order that isn't in QuickBooks. Every row with 2 or more may be a duplicate (see duplicate Shopify sales in QuickBooks).
Before you call an order missing, check the day before and after it: search for the order number with the search box at the top of QuickBooks.
3. Look at the connector's log
Open the connector from Apps in Shopify admin and look for a sync history, error log or "failed" tab. The error message tells you which mapping to fix. Look at the dates as well: a run of failures from one day onwards usually means the connection dropped.
Fix it
- Fix the cause first. Map the product, tax rate or payment method the error mentions, or reconnect QuickBooks in the connector's settings. Otherwise new orders keep failing.
- Re-sync the missing orders from the connector. Most have a "retry" or "resync" button on failed orders, or let you re-sync a date range. If you re-sync a range, check afterwards for orders that are now there twice.
- If an order won't sync, enter it by hand: + Create → Sales receipt, with the same date, products, shipping and tax as Shopify, and the Shopify order number in the reference so you can find it later.
- Match the deposit. Once the orders are in, the payout from Shopify should match its deposit in your bank feed. If it doesn't, follow the payout guide.
If the month is already closed, or a sales tax return already covers it, talk to your accountant before adding sales to that period.