Your Shopify prices include VAT, as UK/EU pricing usually does. But QuickBooks shows a VAT liability roughly double what you actually collected - and your VAT return is due.
This is one of the most mechanical failures in Shopify→QBO syncing, and merchants on migrated connectors reported it through 2026: the sync takes a VAT-inclusive price and applies VAT again on top, as if the price had been exclusive. The result is tax recorded at roughly twice the true amount, every affected order.
The symptoms
- QBO's VAT liability for the period is roughly 2× what Shopify's tax reports show
- Individual QBO transactions show VAT close to double the VAT on the matching Shopify order
- Transaction totals in QBO exceed what customers actually paid
- Affected orders are the VAT-inclusive ones; export/zero-rated orders look fine
Why it happens
Inclusive prices re-taxed as exclusive
Shopify sends a price with VAT already inside it. If the sync (or the QBO tax-code mapping) treats that price as VAT-exclusive, QBO adds VAT on top - recording both the embedded VAT and a second calculated VAT. The signature is recorded tax at almost exactly 2× actual.
Wrong tax code mapping in QBO
Even a correctly behaving sync posts wrong tax when the QBO tax code it maps to is set to exclusive while the incoming amounts are inclusive. Check the mapping, not just the pipe.
How to check and fix it by hand
1. Verify the 2× signature on real orders
Take five VAT-inclusive orders. For each: Shopify's tax amount vs. the tax on the matching QBO transaction. Values near exactly double confirm the inclusive/exclusive flip; scattered differences point elsewhere.
2. Fix the setting before the data
Correct the tax treatment in your sync's settings or the QBO tax-code mapping first, or every new order keeps compounding the problem.
3. Correct affected orders with reviewable entries
Each affected order needs its excess VAT moved out of the liability account. Per-order correcting entries keep an audit trail your accountant can verify - a single bulk adjustment hides which orders were wrong.
4. Never post into a filed VAT period
If some affected orders fall in a period you've already filed, corrections there are a conversation with your accountant - possibly an adjustment in the current period per HMRC/your jurisdiction's error-correction rules. A back-dated post cannot unfile a return.
Common questions
Why is my VAT doubled in QuickBooks?
Your Shopify prices are VAT-inclusive but the sync or QBO tax mapping is treating them as VAT-exclusive and adding VAT again. Recorded tax lands at roughly 2× actual - a recognizable, per-order-verifiable signature.
How do I check which orders are affected?
Compare Shopify's tax amount to the QBO transaction's tax, order by order. LedgerClear's free scan flags the near-exact-2× pattern automatically and lists every affected order with both sides shown.
Can I fix this if I've already filed the VAT return?
The books can be corrected, but filed periods need your accountant's judgment on where the adjustment goes. Any tool that offers to auto-post corrections into a filed period should worry you - LedgerClear locks those to propose-only.
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)