TL;DR: Reconciling Shopify Payments with QuickBooks means matching each Shopify payout to the bank deposit it created, then breaking that deposit into gross sales, processing fees, and sales tax separately. The 4-step process: (1) export your Shopify finance summary, (2) match each payout to a QuickBooks deposit, (3) record gross sales, fees, and sales-tax liability as separate lines, (4) flag anything that does not match. The deposit in your bank is net — your books need the gross.
Shopify does not deposit what you sold. It deposits what is left after fees, refunds, and chargebacks, and it bundles several days of orders into one payout. QuickBooks sees a single round-ish deposit hit the bank. Reconciling them means unwrapping that deposit so your books show the full picture — gross revenue, the fees you paid, and the sales tax you owe — instead of one net number.
Here is exactly how to do it.
Why Shopify and QuickBooks seem to disagree
A Shopify payout is a net figure. Before the money reaches your bank, Shopify subtracts:
- Processing fees — typically around 2.9% + $0.30 per online order, depending on your plan
- Refunds issued during the payout period
- Chargebacks and disputes deducted from the batch
On top of that, Shopify batches. A single payout can cover two or three days of orders, and it arrives on a rolling schedule a few business days after the sales happen. So a $4,200 bank deposit might represent:
- $4,500 in gross sales
- Minus $130 in Shopify processing fees
- Minus $170 in a refund issued that period
- Net payout: $4,200
Two more things get lumped in and routinely mis-recorded:
- Sales tax you collected is a liability, not revenue. It belongs in a sales tax payable account because you owe it to the state.
- Gift cards and tips are not income at the moment of sale either — a gift card is deferred revenue until redeemed, and tips are typically a pass-through.
If you book that $4,200 deposit as revenue, you understate sales by $300, miss a fee deduction, and bury your sales tax liability inside income. All three are wrong, and all three matter at tax time.
The 4-Step Reconciliation Process
Step 1: Export your Shopify finance summary
In Shopify admin → Analytics → Reports → Finances summary, pull the period you are reconciling. The payouts report (Settings → Payments → View payouts) breaks each payout into gross sales, fees, refunds, and the net amount transferred. Export it as CSV.
This is your source of truth. Everything you record in QuickBooks should trace back to a line on this report.
Step 2: Match each payout to a QuickBooks bank deposit
In QuickBooks, find the deposits that hit your bank account for the same period. For each Shopify payout in your export, locate the matching deposit. The net payout amount should equal the deposit amount exactly.
Match by payout ID and net amount, not by sales date. Because Shopify batches across days, matching by date creates phantom mismatches.
Step 3: Record gross sales, fees, and sales tax separately
For each matched payout, split the deposit into its parts instead of recording one lump sum:
- Gross sales → Revenue (or split by product/sales income account)
- Shopify processing fees → Merchant Fees / Payment Processing Expense
- Sales tax collected → Sales Tax Payable (a liability, not income)
- Refunds → contra-revenue (Refunds/Returns), reducing gross sales
- Gift cards → deferred revenue liability until redeemed; tips → a pass-through liability
In double-entry terms: debit the bank for the net deposit, debit Merchant Fees for the fees, credit Revenue for gross sales, and credit Sales Tax Payable for the tax. The entry balances back to the net amount that actually landed in the bank.
Step 4: Flag anything that does not match
A payout that does not tie out cleanly usually comes down to one of these:
- Timing differences — a payout initiated but not yet deposited at period end
- Refunds — a refund larger than the day's sales can make a payout smaller than expected, or even negative
- Reserve holds — Shopify is holding a portion of funds temporarily
- Chargebacks — a disputed charge clawed back from the batch
Each needs its own entry. Timing differences clear on their own next period; the rest need a deliberate journal entry so your books stay accurate.
Common mistakes founders make
- Recording the net payout as revenue — understates sales, hides the fee deduction, and quietly buries your sales tax liability inside income
- Ignoring Shopify fees — overstates profit and skips a deductible expense worth roughly 3% of gross sales
- Mixing sales tax into income — inflates revenue and leaves you with no clean record of what you owe the state, which makes filing a guessing game
- Matching by sales date instead of payout — produces mismatches every single time because Shopify batches across days
How to automate this
Doing this by hand every month is exactly the kind of repetitive splitting that software should handle. Prosper connects your accounts, imports your transaction history automatically, and auto-categorizes roughly 80–90% of activity from the merchant name and amount patterns. Instead of breaking down every payout yourself, you review only the exceptions — the unmatched payouts, refunds, and reserve holds that genuinely need a decision. Most founders clear the whole queue in an afternoon. See how it works.
If you are reconciling a different processor, the same logic applies — see our guide on reconciling Stripe and Mercury.
FAQ
Why doesn't my Shopify payout match my Shopify sales total? Shopify Payments deposits a net payout — gross sales minus processing fees, refunds, and chargebacks — and batches multiple orders into a single deposit on a rolling schedule. The payout that lands in your bank is almost never equal to the sales you rang up that day, which is why you have to reconcile the payout report against the deposit rather than matching by sales totals.
Is sales tax collected through Shopify income? No. Sales tax you collect is a liability you owe to the state, not revenue. If you record it as income you will overstate your sales and your profit, and you will owe more income tax than you should. Book it to a sales tax payable account instead.
What is the easiest way to reconcile Shopify with QuickBooks automatically? Connect both accounts to bookkeeping software that understands how Shopify batches payouts. Prosper auto-categorizes the bulk of your transactions and surfaces only the exceptions — unmatched payouts, refunds, or reserve holds — so you review the handful that actually need attention instead of every line.