Fix guide
QuickBooks amounts don't match Shopify orders
The orders made it across - counts match, nothing is missing - but the amounts are wrong. A $114.50 order shows as $95.42. Totals are close but never quite equal. This is the subtlest sync failure class, because every report looks plausible and nothing is obviously absent.
Amount mismatches are systematic, not random: a sync doesn't get arithmetic wrong, it applies a wrong rule consistently. Discounts dropped or double-applied, tax-inclusive amounts treated as exclusive, shipping omitted from the transaction, or a currency conversion applied at the wrong point. Each rule failure leaves a distinct pattern, which means a handful of carefully compared orders usually identifies the rule - and then you know exactly what's wrong with every other affected order.
The symptoms
- Individual QBO transactions differ from the matching Shopify order total
- The difference is a consistent percentage (points to tax or discount treatment) or a consistent component (points to shipping or fees)
- Orders with discounts, gift cards, or a second currency mismatch while plain orders match
- Period totals disagree even though transaction counts agree
Why it happens
Discount and gift-card handling
Some syncs post the pre-discount price, some the post-discount price, and gift-card tenders route differently again - the order total is right in Shopify but the transaction in QBO reflects a different line composition. Orders paid partly by gift card are a known edge case that deserves review rather than blind correction.
Tax treatment applied to the wrong base
Tax-inclusive amounts recorded as exclusive (or vice versa) shift every affected total by the tax rate. If the mismatch percentage equals your tax rate, this is your cause - see our doubled-tax guide for the full mechanics.
Shipping, tips, and currency
Shipping income or tips omitted from the posted transaction produce a constant-component gap. Multi-currency orders converted at a different rate or point in time than Shopify used produce small scattered differences concentrated on foreign-currency orders.
How to check and fix it by hand
- 01
Pick five mismatched orders and decompose them
For each, write out both sides line by line: items, discounts, shipping, tip, tax, total. The line where the two sides diverge is the rule that's failing - and it's usually the same line on all five.
- 02
Classify the pattern
Same percentage everywhere: tax treatment. Difference equals the discount: discount handling. Difference equals shipping: shipping mapping. Only foreign-currency or gift-card orders affected: that edge case specifically.
- 03
Fix the mapping, then measure the blast radius
Correct the sync setting or QBO mapping so new orders post right. Then find every historical order the broken rule touched - a line-by-line diff across your history does this in one pass; it's exactly what LedgerClear's free scan itemizes, read-only, with each finding showing both sides.
- 04
Correct with per-order entries
Post a correcting entry per affected order (or per clearly documented batch), keeping the tax component separate so the liability account ends up right. Anything dated in a filed period goes through your bookkeeper rather than a back-dated post.
Common questions
- Why do my QuickBooks amounts differ from Shopify by a consistent percentage?
- A consistent percentage almost always means tax treatment - inclusive amounts recorded as exclusive or the wrong rate applied. If the percentage matches your tax rate, verify five orders and then fix the tax mapping before correcting the data.
- The totals are only off by small amounts - is it worth fixing?
- Small consistent errors are systematic, and they accumulate across every order and into your tax liability. The cost of fixing is low once the rule is identified: one settings change plus a batch of per-order corrections.
- How do I find every order affected without opening each one?
- Diff Shopify orders against QBO transactions line by line and filter to amount mismatches. LedgerClear's free scan does this across your history and classifies each mismatch by confidence, so you get the affected-order list without the manual pass.
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.