Fix guide
QuickBooks revenue lower than Shopify
Shopify analytics says one revenue number for the month; your QuickBooks P&L says a smaller one. Before anyone panics: part of that difference is usually definitional, and part of it may be real missing money. The job is separating the two.
Definitional differences are innocent: Shopify reports gross sales at order time; your books may record net of refunds at settlement time. Real differences - orders that never posted, refunds recorded on one side only - are findings, and each one is traceable to a specific order.
The symptoms
- Monthly P&L income is consistently a few percent below Shopify's total sales for the month
- The gap varies month to month rather than being one fixed amount
- You can't tie the difference to any single transaction
- The gap appeared or widened after a sync change
Why it happens
Orders missing from QBO entirely
The most direct cause: some orders never posted. Sync interruptions and connector migrations leave gaps that don't backfill themselves. This portion of the gap is real and stays until recorded.
Timing: order date vs. settlement date
Shopify counts an order when it's placed; payout-based syncs post when cash settles days later. At month boundaries this moves real revenue between months. It self-corrects across months but makes any single month look off.
Refunds and fees recorded differently
If Shopify's number is gross sales but your books post net of processing fees - or one side has a refund the other doesn't - the totals diverge by exactly those amounts.
How to check and fix it by hand
- 01
Compare like with like
Pull Shopify gross sales, refunds, and net sales separately for the month. Compare gross to your income account and refunds to your contra-revenue account, not one blended number against another.
- 02
Reconcile order counts before amounts
If order counts differ, find the missing orders first (see our missing-orders guide) - a count gap explains an amount gap faster than any spreadsheet.
- 03
Isolate the month boundary
List orders from the last five business days of the month and check which posted into the next month. That's your timing component; it should roughly offset against the previous month's carry-in.
- 04
Whatever remains is findings
After counts match and timing is accounted for, remaining differences are per-order mismatches: wrong amounts, doubled tax, or unrecorded refunds. Each needs a specific correcting entry - approved by you, not auto-posted.
Common questions
- Why doesn't my QuickBooks revenue match Shopify?
- Some combination of: orders missing from QBO, order-date vs. settlement-date timing at month boundaries, and refunds or fees recorded on one side only. Each has a different fix, which is why lump-sum "plug" entries are the wrong answer.
- Is a small persistent difference normal?
- A difference that fully reverses across adjacent months is usually settlement timing. A difference that accumulates is not normal - it means transactions are missing or mismatched and worth a line-by-line check.
- Can I just post one adjusting entry for the difference?
- You can, but you'd be papering over unknown causes, and if any of the gap is sales tax you'd be misstating a liability. Identify the per-order findings first; then each correcting entry is small, explainable, and reversible.
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.