Shopify QuickBooks Reconciliation: Why the Payout Never Matches the Sales

The deposit Shopify drops in your bank never matches the sales it came from. Strip out the processing fees, the refunds you issued, the chargebacks, the gift cards that aren't revenue at all, and the orders that straddled month-end — and one clean number in QuickBooks has to be un-bundled back into five. Do it by hand and month-end reconciliation eats an afternoon you don't have, on the week the books are already due. Here's how the un-bundling actually works, step by step — and the one Slack message that does it for you: Sterling drafts the correcting entries and waits for your go before a single one posts to your books.

Why the deposit never matches the sales

Shopify Payments doesn't wire you each order as it happens. It batches a day or two of orders, subtracts its cut, and pays the net in a lump. That lump lands in your bank as a single deposit — say $4,213.67 — while the orders behind it added up to $4,850 in gross sales. QuickBooks sees the $4,213.67. It has no idea that number is really gross sales minus fees minus a refund minus one chargeback, with a gift-card sale mixed in that isn't revenue at all.

Reconciliation is the job of turning that one net number back into the parts that made it — and proving each part lands in the right place in your books. Get it wrong and your revenue is overstated, your fees are invisible, your sales tax is off, and you're paying yourself on numbers that were never true. One owner learned that the expensive way: "It's impossible to make a good decision if you have bad information." (r/smallbusiness)

The five things hiding inside one payout

Every Shopify payout is a small pile of things QuickBooks needs to see separately. Miss one and the deposit won't tie out.

• Processing fees. Shopify Payments skims roughly 2.9% + 30¢ off each transaction before the payout ever leaves. That fee is a real expense — but it never appears as a line in your bank; it's already subtracted. Book the net as revenue and you've quietly hidden thousands of dollars of card fees a year.
• Refunds and chargebacks. A refund you issued mid-period comes straight out of the payout, sometimes in a different payout than the original sale. A chargeback pulls the money back and often adds a dispute fee on top. Both shrink the deposit below what the orders say you sold.
• Gift cards. Selling a gift card brings in cash but isn't revenue — it's a liability you owe until someone redeems it. Redeeming one is revenue but brings in no new cash. So gift cards inflate deposits without matching sales, then create sales without matching deposits. They break reconciliation from both sides.
• Sales tax. The tax you collected is money you're holding for the state, not income. It rides inside the same deposit and has to be split back out to a liability account, or you'll overstate revenue and under-fund the tax you owe.
• Timing. A sale on the 31st can pay out on the 2nd. Payout windows don't respect your accounting calendar, so nearly every month has orders that landed in one period and paid out in the next — the single most common reason a month "won't tie."

Do the reconciliation by hand: the steps

The manual version works with nothing but Shopify, QuickBooks, and patience. Here's the order that keeps you from chasing your own tail.

1. List the month's payouts. Pull every payout that hit the bank during the month from Shopify's Payouts report — not the orders, the payouts. That's what your bank statement shows, so that's what has to match. 2. Un-bundle each payout. For every payout, break the net back into gross sales, refunds, chargebacks, and fees. Shopify's payout detail gives you the components; the sum of them, netted, has to equal the deposit. 3. Match each deposit to the bank. Tie each un-bundled payout to the matching line on your bank feed in QuickBooks. This is where timing bites — a late-month sale's payout shows up on next month's statement. 4. Split out what isn't revenue. Move sales tax to its liability account. Move gift-card sales to deferred revenue, and recognize gift-card redemptions as revenue with no cash attached. This is the step most Shopify stores skip, and it's why their books slowly drift. 5. Book the fees. Record the processing fees you subtracted in step 2 as an expense, so your margin reflects what the card networks actually cost you. 6. Find what doesn't tie. Whatever's left over — a deposit that's $40 short, a payout with no matching order, a refund that never got booked — is the discrepancy. That's the part worth a human's attention, and it's usually the last hour of the afternoon.

Here's the same map in one view — what's inside a payout, and where each piece belongs.

The honest problem with the manual version

The steps above are real bookkeeping, and plenty of owners do them by hand every month. But by hand it's the better part of an afternoon, across two systems, on the exact week your close is due — matching payouts to deposits, splitting tax and gift cards out, hunting the one deposit that's $40 short. And the cost of not doing it compounds quietly, in the background, until it's a real number. One owner did that math out loud: "QuickBooks or some other fully automated transaction tracking tool would have saved me literally six figures." (r/smallbusiness) Untracked, un-reconciled data doesn't stay free. It just bills you later.

Pasting your payout export into ChatGPT doesn't close the gap either. It'll explain what reconciliation means and how you could categorize a gift card — but you're still the one logging into Shopify to pull the payouts, still the one keying entries into QuickBooks. "it becomes a slightly smarter Google. Because it doesn't DO anything" (Sterling vs. ChatGPT). You wanted the month reconciled. You got more homework.

The delegated version: one Slack message

Here's the same job as a scenario. It's the first of the month, the close is due, and instead of blocking out the afternoon you type this once:

A few minutes later, the thread has the month worked in order:

• Every payout un-bundled. Each deposit broken back into its parts and tied to the matching bank line — the reconciliation done, not described.
• The discrepancies flagged, not buried. The three deposits that don't tie, the late-month order that paid out this period, the dispute fee nobody booked — pulled to the top with the amount and the likely cause, instead of hiding in a 400-row export.
• Tax and gift cards separated. Sales tax moved to its liability account, gift-card sales held as deferred revenue, redemptions recognized without phantom cash — the step the manual version tends to skip.
• The corrections drafted. The journal entries that would make the month tie, written and waiting in the thread for your go — not added to your list of things to do.

Then the part that matters if a tool has burned you before. The work just happens — pulling the payouts, matching the deposits, building the reconciliation, drafting the entries — no ceremony, no permission prompt on every step. What Sterling won't do on its own is post. Because these corrections are ones it recommended, it holds each one and waits for your go — a plain reply in the thread ("say go and I'll post them"), not a button to hunt for. Say go and the entry posts; every post lands in the audit log with a timestamp. Sterling does everything up to the send. The send is yours.

A skeptical owner once wrote the acceptance test for this whole category: "if there's no exception queue, audit log, and big red pause button, it's not automation, it's just a faster way to lose money." (r/automation) That's the design: the whole job runs in a Slack thread you can watch in real time, every entry Sterling posts lands in the audit log with a timestamp, anything that changes your books waits for your go, and pause and cancel are buttons on the dashboard. Your books, your ledger, your entries — nothing posts to QuickBooks without your go.

What the delegated version costs

$50 a month gets your whole team a coworker — 20,000 credits that cover the jobs you actually delegate: the month-end reconciliation, the weekly audit, the campaign drafts. Unlimited seats, no per-seat charges. Run low and Sterling pings you in Slack at 80%, before it matters; a top-up is $25 for 10,000 credits, decided by you, not discovered on an invoice. If credits run out, Sterling pauses and tells you — it never surprise-bills you.

Month-end is the best first test precisely because you already know what the manual version costs you: the afternoon, and the six-figure quote above from the owner who skipped it too long. Hand one month's reconciliation to Sterling instead. Your first 20,000 credits are free, and they run on your real Shopify and QuickBooks, not a demo store. Then put the weekly Shopify + Klaviyo audit on a schedule too, and stop meeting your own numbers for the first time at close.

Reconcile My First Month Free

Frequently Asked Questions