Fix guide
Sales tax doubled on Shopify orders in QuickBooks
Your sales tax liability in QuickBooks is meaningfully higher than the tax Shopify actually collected from customers. Left alone, that means remitting tax you never received - real money out the door on a filing you can't easily unwind.
Overstated tax on Shopify→QBO books is almost always mechanical, and the two common mechanisms leave different fingerprints. Tax-inclusive amounts being re-taxed produces tax at close to exactly double on every affected order - merchants on migrated connectors reported exactly this through 2026 with VAT-inclusive pricing, and the same inclusive/exclusive flip can bite any tax-inclusive setup. Duplicated orders produce doubled tax only on the duplicated orders, alongside doubled revenue.
Because the fingerprints differ, a per-order check tells you which problem you have before you touch a single entry.
The symptoms
- QBO's sales tax liability for the period is well above what Shopify's tax reports show was collected
- Individual QBO transactions show tax near exactly 2× the tax on the matching Shopify order
- Revenue is also overstated for the same period (points to duplicates rather than a tax-treatment flip)
- The overstatement started around a sync change, migration, or settings edit
Why it happens
Tax-inclusive amounts taxed again
If your Shopify prices include tax and the sync or the QBO tax-code mapping treats the incoming amount as tax-exclusive, QBO calculates tax on top of a price that already contained it. The signature: recorded tax at almost exactly double, on every tax-inclusive order, with transaction totals exceeding what customers paid.
Duplicated orders doubling everything
An order posted twice carries its tax twice. The signature: doubled tax only on specific orders - the duplicated ones - with revenue doubled on exactly the same orders. See our duplicate-orders guide for where duplicates come from and how to reverse them.
Wrong tax agency or rate mapping
A sync mapped to the wrong QBO tax code can overstate (or understate) tax without a clean 2× signature - differences scatter instead of doubling. This one is a settings check: compare the tax rate on a posted transaction to the rate the order actually charged.
How to check and fix it by hand
- 01
Compare period totals first
Shopify: the tax report for the period. QBO: the sales tax liability report for the same period. The size and consistency of the gap narrows the cause before you look at any single order.
- 02
Sample five orders and read the fingerprint
For five affected orders, compare Shopify's tax amount to the QBO transaction's tax. Near-exact 2× on all of them: inclusive/exclusive flip. Doubled only where the order appears twice in QBO: duplicates. Scattered differences: rate or agency mapping.
- 03
Fix the setting before the data
For the inclusive/exclusive flip, correct the tax treatment in the sync settings or the QBO tax-code mapping first - otherwise every new order adds to the pile. For duplicates, find and reverse each duplicated posting.
- 04
Correct per order, and respect filed periods
Move the excess tax out of the liability account with per-order correcting entries, so your accountant can verify each one against its order. Anything in a period you've already filed for is a bookkeeper conversation - an adjustment in the current period, not a back-dated post.
Common questions
- Why is QuickBooks showing more sales tax than Shopify collected?
- Usually one of two mechanical causes: tax-inclusive amounts being taxed again by the sync or the QBO tax-code mapping (tax lands at ~2× on every affected order), or duplicated orders carrying their tax twice (doubled only on the duplicated orders, with revenue doubled too).
- What happens if I file with the doubled tax?
- You remit tax you never collected. Corrections after filing are still possible but go through your jurisdiction's error-correction process with your accountant's judgment - which is why it's worth verifying the liability against Shopify's tax report before filing, not after.
- How do I find every affected order without checking hundreds by hand?
- The 2× pattern and the duplicate pattern are both detectable in a line-by-line diff of Shopify orders against QBO transactions. LedgerClear's free scan runs that diff read-only and lists each affected order with both sides shown.
LedgerClear doesn’t replace your sync. It audits per-order syncs today - the official connector and Synder. Summary-posting tools like A2X and Link My Books: auditing support is coming later, and LedgerClear runs alongside them without touching their entries. If the right answer for you is switching tools, the scan report is the damage report to migrate with.