You count orders in Shopify, you count sales receipts in QuickBooks Online, and the numbers don't agree. Some orders simply never arrived in your books.
Before assuming the worst: some of those "missing" orders are payout timing - an order placed on the 31st whose cash lands on the 2nd is not missing, it's in transit. The real problem is the orders that stay missing after settlement.
The symptoms
- Order count in Shopify admin is higher than sales receipt count in QBO for the same date range
- Monthly revenue in QBO is lower than Shopify's analytics for the same month
- Specific orders are findable in Shopify but return nothing when searched in QBO
- Gaps cluster around a date - often the day a sync was migrated, reauthorized, or errored
Why it happens
Sync interruptions and forced migrations
When a sync connector is migrated, reauthorized, or errors out, orders placed during the gap are often never backfilled. Merchants force-migrated between connectors in early 2026 report exactly this class of gap. The orders exist in Shopify; the pipe just never posted them.
Payout-timing masquerading as missing orders
Syncs that post on payout settlement will always trail Shopify by several business days. An order inside that window isn't missing yet. Any check you run needs a settlement grace window before it calls something missing - ours defaults to 5 business days.
Edge-case tenders
Orders paid partly or fully by gift card, and orders in a second currency, route differently through many syncs and sometimes fall out entirely. These deserve review rather than blind re-entry.
How to check and fix it by hand
1. Pick one month and count both sides
In Shopify: Orders, filtered to paid, for the month. In QBO: Sales receipts (or invoices, depending on your sync's posting mode) for the same month. If the counts differ, you have gaps, not a rounding problem.
2. Exclude the settlement window
Ignore anything younger than about five business days. If gaps remain in fully settled weeks, those are real.
3. List the missing orders individually
Match order by order - order name against the reference your sync stamps on each QBO transaction. Every unmatched, settled, paid order needs recording: usually a sales receipt or journal entry crediting income and sales tax and debiting your clearing account.
4. Mind closed periods
If a missing order falls in a period you've already filed taxes for, don't just post it - talk to your bookkeeper about how to record it in the current period. A back-dated post cannot unfile a return.
Common questions
Why are Shopify orders not showing up in QuickBooks?
Most commonly: a sync interruption or migration left a gap that was never backfilled, the orders are still inside the payout settlement window, or an edge-case tender (gift card, multi-currency) fell out of the sync's default path.
How do I find which specific orders are missing?
Match order by order between Shopify's paid-order list and QBO transactions for the same range, after excluding the last ~5 business days for settlement. LedgerClear's free scan does exactly this line-by-line diff, read-only.
Do I need to switch sync tools to fix this?
Not necessarily. The gaps need recording either way, and per-order syncs can gap during a migration or outage. LedgerClear audits per-order syncs today - the official connector and Synder. Summary-posting tools like A2X and Link My Books: auditing support is coming later; LedgerClear runs alongside them without touching their entries.
Originally published at ledgerclear.vercel.app. LedgerClear is an independent auditor for Shopify to QuickBooks Online books: a free read-only scan that diffs your orders against your ledger and tiers every finding by confidence, so payout timing never gets reported as missing money. Not affiliated with Shopify or Intuit, and nothing here is tax advice.
Top comments (0)