Duplicates are the quiet inverse of missing orders: revenue looks better than reality, and the error compounds into overstated income and overstated sales tax - money you'll remit or pay tax on without having earned it.
They almost always come from retries: a sync error followed by a re-run, a migration overlap where old and new connectors both posted, or a manual re-entry of an order that had actually synced.
The symptoms
- QBO revenue higher than Shopify for the same period
- Two transactions referencing the same order number, often a day apart
- Sales tax liability higher than the tax Shopify actually collected
- Duplicates clustered around a sync outage, retry, or migration date
Why it happens
Retries after errors
A sync that errors mid-batch and re-runs often re-posts transactions that had succeeded the first time. The duplicate usually lands a day later than the original with a different document number.
Migration overlap
During a connector switch, an overlap window where both old and new pipes were active posts everything in it twice.
Manual re-entry
A merchant who believes an order didn't sync enters it by hand; the sync posts it later anyway. Common during exactly the outages that make you distrust the pipe.
How to check and fix it by hand
1. Group QBO transactions by order reference
Most syncs stamp the Shopify order number on each transaction. Any order reference appearing on two or more sales transactions is a duplicate candidate.
2. Confirm against Shopify
Check the order in Shopify: one real order, two QBO postings confirms the duplicate. (Two similar QBO amounts can also be two genuinely separate orders - verify before reversing.)
3. Reverse, don't delete
In closed books especially, deleting history breaks the audit trail your accountant relies on. A reversing entry that backs out the duplicate's revenue and tax keeps history intact and explainable.
4. Correct the tax side too
Each duplicate overstated your sales tax liability as well as revenue. If the duplicate falls in a filed tax period, the correction is propose-only territory - route it through your bookkeeper.
Common questions
Why are Shopify orders showing up twice in QuickBooks?
Sync retries after errors, an overlap window during a connector migration, or manual entry of an order that also synced. Duplicates cluster around outage and migration dates.
Should I delete the duplicate transaction?
Reverse it rather than delete it, especially in reconciled or closed periods - a reversing entry preserves the audit trail. Every correction LedgerClear proposes ships with a ready-made reversing entry for exactly this reason.
How do I find all duplicates, not just the ones I noticed?
Group all QBO sales transactions by their Shopify order reference and flag any reference with more than one posting. LedgerClear's free scan does this across your full history and shows both postings side by side.
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)