Fix guide
Shopify payout doesn't match the QuickBooks deposit
A payout landed in your bank feed and the number in QuickBooks doesn't agree with what Shopify says it paid you - or the deposit matches Shopify's payout report but refuses to reconcile against the sales your sync posted.
These are two different mismatches with different causes. The first (payout report vs. bank deposit) is usually a recording problem in QBO. The second (payout vs. posted sales) is structural: a payout is gross sales minus processing fees minus refunds, batched across several days - it will never equal any day's sales on its own. The good news is that every payout is traceable to the penny, because Shopify publishes exactly which orders, refunds, and fees are inside it.
This guide walks the trace for one payout. If the same class of difference shows up payout after payout, the cause is upstream - orders or refunds your sync recorded wrongly or not at all.
The symptoms
- The deposit in the QBO bank feed differs from the payout amount shown in Shopify's payout report
- The payout matches the bank, but won't reconcile against the sales transactions in QBO
- A clearing account balance that grows a little with every payout instead of returning to zero
- Differences that are always the same direction - QBO consistently higher or consistently lower
Why it happens
Fees and refunds inside the payout
Shopify deducts processing fees and any refunds issued during the period before paying out. If QBO records the payout as pure sales income - no fee expense line, no refund reduction - the deposit can't match the sales it represents. The difference is exactly the fees plus refunds in that payout.
Batching across days and period boundaries
One payout typically bundles several days of orders, settled on Shopify's schedule for your region and payment methods. Near a month boundary, orders from one month legitimately land in the next month's deposit. That's timing, not error - but it makes naive day-by-day matching impossible.
Upstream sync errors surfacing downstream
If your sync missed an order, duplicated one, or posted a wrong amount, the payout containing that order won't tie out no matter how carefully you record fees. A payout mismatch is often the first visible symptom of a per-order problem that happened days earlier.
Free tool for this
Work a single payout back to gross sales, fees, refunds and adjustments, line by line. Open the Shopify payout calculator.
How to check and fix it by hand
- 01
Open the specific payout in Shopify
In Shopify admin, Finance → Payouts, open the payout matching the bank deposit's date and amount. Shopify lists every order, refund, fee, and adjustment inside it - this is your ground truth for the trace.
- 02
Verify the deposit equals gross minus fees minus refunds
Add up the payout's order totals, subtract its fees and refunds, and compare to the bank deposit. If these agree, Shopify and your bank are fine - the mismatch lives in how QBO recorded it.
- 03
Check what QBO posted for the same orders
Find each order from the payout in QBO. Missing orders, duplicated orders, or amount differences here explain a payout that won't tie out. If the orders all match, check whether the payout entry itself booked fees to an expense account or silently netted them into income.
- 04
Fix the pattern, not just the payout
One payout traced tells you the mechanism; if it's fees, fix how payouts are recorded going forward (see our payout reconciliation guide for the clearing-account method). If it's missing or duplicated orders, the same problem is likely in other payouts too - run the comparison across a longer window rather than trusting the next payout to behave.
Common questions
- Why is my Shopify payout different from my sales in QuickBooks?
- Payouts are gross sales minus processing fees minus refunds, batched across multiple days - they never equal a day's sales by design. If the gap is more than fees and refunds explain, orders are missing, duplicated, or mis-stated upstream.
- How do I trace one payout to the penny?
- Open the payout in Shopify (Finance → Payouts) - it lists every order, refund, fee, and adjustment inside it. Check that gross minus fees minus refunds equals the bank deposit, then check that each listed order exists once in QBO at the right amount.
- Can LedgerClear do this trace for me?
- LedgerClear's free scan diffs the order-level side - missing, duplicated, and mis-stated orders and refunds between Shopify and QBO - which is what makes payouts explainable when they won't tie out. It's read-only and tiers each finding by confidence so settlement timing isn't miscounted as a discrepancy.
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.