A Shopify payout almost never matches a day of sales, and that gap is the whole job. The deposit that lands in your bank is gross sales minus refunds, minus Shopify Payments processing fees, minus chargebacks and reserves, adjusted for whatever fell outside the settlement window. Reconciling means rebuilding that arithmetic in your ledger so the bank line clears against something real instead of a plug entry. Six steps get you there, in this order.
Start with the payout schedule, not the sales report
Most reconciliation failures trace back to a mismatch between the period you are looking at and the period Shopify actually settled. Shopify Payments in the United States carries a minimum settlement time of two to five business days, with no minimum payout amount, and payments captured on Friday, Saturday and Sunday are consolidated into a single payout. Shopify’s own payout timing documentation works the example: a charge captured Friday with a three business day settlement processes the following Wednesday, because weekends and holidays do not count as business days.
You also choose the cadence. Shopify offers daily, weekly or monthly payouts, and the choice changes how much work reconciliation is. A daily schedule produces roughly twenty-two deposits a month, each one a small puzzle. A weekly schedule produces four larger ones. Neither is wrong, but a store on daily payouts that reconciles once a month is doing twenty-two reconciliations in one sitting, and that is where errors get buried.
One more timing wrinkle: banks typically take a further one to three business days to post the deposit after Shopify sends it. The date on your Shopify payout report and the date on your bank statement will differ. Reconcile to the Shopify payout date and let the bank date float.
Build the payout equation
Every Shopify payout resolves to the same structure. Write it out once and you can apply it to every deposit for the rest of the year.
Gross sales minus refunds minus processing fees minus chargebacks and disputes plus or minus adjustments equals net payout.
Take a store with a weekly payout covering seven days of orders. Gross sales of $41,280 across 512 orders. Refunds of $1,940 on nineteen returns. Shopify Payments processing fees of $1,183. One disputed charge of $189 held pending review, plus a $15 dispute fee. A prior-week adjustment of $62 released back into this period.
The math: 41,280 minus 1,940 minus 1,183 minus 204 plus 62 equals a net payout of $38,015. That is the number that should hit the bank, and that is the number your journal entry has to produce. If your books credit $41,280 to sales revenue and nothing else, you are $3,265 out and you have no idea which line caused it.
Post the entry with every component on its own account
The mistake that survives longest in small ecommerce books is recording the deposit as revenue. It nets three or four different economic events into one number, so revenue is understated, fees are invisible, and refunds never appear as a contra account. Come tax time nobody can tell whether a shrinking gross margin is a pricing problem or a fee problem.
The entry for the payout above looks like this:
- Debit Bank $38,015
- Debit Refunds and Returns $1,940
- Debit Merchant Processing Fees $1,183
- Debit Chargebacks and Dispute Fees $204
- Credit Sales Revenue $41,280
- Credit Payout Adjustments $62
Five debits and two credits, all of them traceable to a line on the Shopify payout report. Once the chart of accounts holds those buckets, your profit and loss statement starts answering questions instead of raising them.
Handle the timing difference at period end
The last two to five business days of every month sit in limbo. Orders are captured, revenue is earned, and the cash has not moved. Under accrual accounting that revenue belongs to the month it was earned, which means you need a receivable.
Create an account called Shopify Payments Clearing or Undeposited Marketplace Funds. Recognise the sale when the order captures, debiting the clearing account. When the payout lands, debit the bank and credit the clearing account for the same amount, posting fees and refunds along the way. The clearing account balance at month end should equal exactly the payouts in transit. If it does not, you have found a real error rather than a timing artifact.
The IRS explains the underlying rules for choosing and applying an accounting method in Publication 538, and the accrual method is the one that makes ecommerce books mean anything. Cash-basis books on a two to five day settlement lag will misstate every month boundary you have.
Reconcile the clearing account, not just the bank
Bank reconciliation tells you the deposit arrived. It does not tell you the deposit was correct. Run a second reconciliation on the clearing account each month:
- Pull the Shopify payout report for the period and total the net payout column.
- Total the deposits posted to the bank account from Shopify Payments.
- Compare. Any difference is either a payout still in transit or an entry you missed.
- Age anything sitting in the clearing account longer than one payout cycle and find out why.
Stale balances in a clearing account are the single most reliable warning sign in ecommerce books. A $400 residue that never clears is usually a refund posted twice, a chargeback nobody recorded, or a payout that was split across two bank lines.
Where this gets harder
Two things break the clean version above. The first is multiple payment gateways. If you run Shopify Payments alongside PayPal, Klarna or Shop Pay Installments, each gateway settles on its own schedule and produces its own fee structure, and each one needs its own clearing account. Netting them together recreates the original problem at a larger scale.
The second is inventory. The payout equation handles revenue and fees. It says nothing about cost of goods sold, which is where actual margin lives. A store that reconciles payouts perfectly and estimates COGS quarterly still cannot tell you which SKU makes money.
At a few hundred orders a month, a spreadsheet and an hour of discipline gets this done. Past a few thousand, the manual version stops scaling and sellers move to something that posts the settlement breakdown automatically. ConnectBooks is one platform built around this particular problem, syncing Shopify alongside Amazon, Walmart, eBay and TikTok Shop into QuickBooks Online, QuickBooks Desktop Enterprise or Xero with COGS and settlement reconciliation handled at the SKU level. Whether you automate it or not, the underlying discipline is the same: never let a deposit hit revenue directly, and never close a month with an unexplained clearing balance.
A short checklist
- Know your payout cadence and settlement window before you start.
- Rebuild every payout as gross sales minus refunds, fees, chargebacks, plus adjustments.
- Give each component its own general ledger account.
- Use a clearing account so period-end timing differences are visible rather than hidden.
- Reconcile the clearing account monthly and age anything that lingers.
- Run a separate clearing account per payment gateway.
None of this is complicated. It is just unforgiving. The stores that stay reconciled are the ones that do the same six steps every month, and the ones that fall behind are almost always the ones that recorded a deposit as revenue eighteen months ago and never went back.