Shopify Payout Reconciliation: How to Match Payouts to Bank Deposits

A Shopify payout almost never equals a day of sales, and that is normal. Shopify groups several orders into one payout, subtracts processing fees, refunds, chargebacks and any reserve it is holding, then deposits the net figure on its own schedule. Reconciling it means naming each of those deductions rather than adjusting your books until the numbers agree. The practical method is a clearing account: sales go in gross, every deduction comes out as its own line, and the payout empties the account down to whatever is still in transit.

Last updated August 2026. The Shopify report behavior described below was checked against Shopify's own Help Center documentation on August 12, 2026. Shopify changes reports, so verify before you build a process on it.

Why doesn't my Shopify payout match my sales?

Because the payout is net and your sales report is gross, and because the two cover different periods. Five things sit between the order and the deposit, and every one of them moves the number.

Processing fees are deducted before the money moves, so you never see them as a bill. If you book only the deposit, revenue is understated by exactly the fees you never recorded, and the expense never reaches the profit and loss at all. Refunds are the second cause, and the most common reason a reconciliation stalls: a refund issued on the 3rd against an order placed on the 28th of last month reduces this month's payout, while your current sales report contains no matching order. Chargebacks do the same thing with worse timing, pulling money back weeks after you recognized the sale, often with a separate fee, and returning it as a third movement if you win the case.

Then there is timing. Shopify pays on a fixed cycle that pays no attention to your month end, so money earned on the last day of a month lands in the next one. Finally, Shopify may hold a reserve against future disputes, particularly on newer stores or long fulfillment windows. That money is yours and it is an asset, but it is not in your bank, and left unrecorded it looks like missing revenue every single month until it releases.

None of those five are errors. Reconciliation is the process of naming each one. If you find yourself entering a balancing figure to make a payout tie, one of the five above is what the figure is made of, and it is worth the ten minutes to find out which.

What is the Shopify payout reconciliation report?

It is the report Shopify gives you for exactly this job, and it is genuinely useful as long as you understand what it is not. It has two parts. The summary shows starting balance, balance changes, account activity before fees, total fees, net amount, total payouts and ending balance. The activity section then breaks that balance activity into sixteen named types plus an "Other" bucket: Charges, Refunds, Disputes, Managed Markets, Adjustments, Shopify Capital, Duties and Taxes, Installments Recovery, Internal Transfers, Fees, Promotions and Credits, Reserves and Holds, Shipping, Shop Cash, Shopify Collective and Payouts.

That list is worth reading slowly, because most stores are aware of maybe five of those categories and are quietly surprised by the rest. Shopify Capital repayments, Shop Cash, Managed Markets and Installments Recovery all move your balance without being a sale or a fee, and each needs somewhere sensible to land in your chart of accounts.

Shopify itself states four caveats about the report, and they matter more than anything a third-party guide will tell you:

One practical limitation: Shopify documents PDF as the export format for the report you are viewing. If you want the underlying activity in a spreadsheet, the payouts and transactions exports are the route people usually take instead.

How do I reconcile Shopify payouts to my bank deposits?

Work from the payout, not from the day. A payout is the only object that exists on both sides of the reconciliation, and once you anchor on it the rest falls out.

Start by recording sales gross into a clearing account rather than posting the net deposit to revenue. Then take one payout at a time. Pull its detail and identify the four components: gross charges, refunds, fees and any adjustment such as a dispute, a reserve movement or a Capital repayment. Post each of those to its own account, so fees land in an expense account and refunds reduce revenue rather than disappearing into a net figure.

Now match the payout total to the bank deposit. This is a one-to-one match on amount and date, and it is the only part of the exercise that should be quick. If the deposit and the payout differ, the difference is a bank-side event such as a returned deposit, not an accounting question.

Finally, look at what is left in the clearing account. At any point in time it should hold exactly the money you have earned but not yet been paid, which is the in-transit balance. If the clearing account carries anything else after every payout is posted, something inside a payout was missed or mapped to the wrong account, and the residual amount usually tells you which one. A stubborn balance that matches a fee total is a mapping problem; one that matches an old order is a refund crossing a period.

Should I use a clearing account for Shopify payouts?

Yes, and it is the single change that fixes most store reconciliations. Without one you are trying to match a net deposit directly against gross sales, which cannot work, so people plug the difference and the books slowly drift. With one, the account gives you a number that means something: the balance is the money Shopify owes you right now.

That balance is also the figure to check at period end. It should agree with what Shopify shows as your outstanding balance, allowing for the three-day reporting delay. When it does, your cut-off is right. If the idea of a clearing account for money that is neither in your bank nor in your customers' hands is new, the distinction between that and a suspense account is worth having straight, because they get used interchangeably and should not be: a clearing account holds money you understand and are waiting for, while a suspense account holds money you do not yet understand.

How do I reconcile Shopify payments in Xero or QuickBooks?

The mechanics are the same in both, and the shape is always sales into clearing, deductions out of clearing, payout to bank. What differs is how the data arrives. Neither ledger breaks a Shopify payout into its parts on its own, so you are choosing between three approaches.

You can do it manually, which is realistic under roughly a hundred orders a month and painful above that. You can use a settlement tool such as A2X or Bookkeep, which reads the Shopify settlement and writes a correctly split summary entry into the ledger for you. Or, at higher volume, you can automate the matching side and keep the posting manual. Sellers running income across several platforms at once, rather than one storefront, often find it easier to keep the income side in a dedicated payout tracker built for multi-platform sellers and reconcile from there, since a per-platform view of what arrived is exactly what the ledger does not give you.

Do I need a tool to reconcile Shopify payouts?

Below about a hundred orders a month, no. The clearing account method above and an hour a month will do it, and a tool mostly adds a subscription. Above that, the manual version stops being viable, because the work scales with orders while your attention does not.

What you buy at that point depends on which problem you actually have, and this is where most buyers pick wrong. Getting a settlement turned into a correct journal entry and proving the cash agrees are two different products. A2X, Synder, Bookkeep and Webgility do the first: they take store activity and put an accurate entry into QuickBooks or Xero. Reconciliation tools do the second: they pair what you were paid against what the bank received and against what the ledger says, then tell you what is unexplained.

We should be direct about our own coverage here, because the honest answer is a limitation. Reconciler has no direct Shopify connector. Shopify payouts reach it on the bank side only, as a single lump deposit, so it can prove the deposit landed and agrees with your ledger, but it cannot split that deposit into orders and fees the way it can for Stripe, PayPal and Square, which connect natively. If splitting the settlement is your problem, a settlement tool is the right purchase and it works perfectly well alongside a reconciliation tool. The full breakdown of which payout sources connect natively and which are bank side only is laid out in our guide to ecommerce payment reconciliation software, along with an honest comparison of six tools and what each publishes as a price.

The month-end checklist

Five checks, in order. Every payout in the period is posted and matched to a bank deposit. Every fee, refund, dispute and adjustment inside those payouts is on its own account rather than netted. The clearing account balance equals the money earned but not yet paid, allowing for the reporting delay. Any reserve Shopify is holding is recorded as an asset rather than ignored. And every other gateway you accept, plus your Shopify subscription fees, is reconciled separately, because the payout report does not contain them.

If all five hold, the store is reconciled and you can say why the deposit differs from the sales, which is the entire point. If you want the wider version of this problem across processors rather than Shopify alone, payment reconciliation software takes each payout shape apart in more detail, and if the books simply will not balance and you cannot find the cause, bank reconciliation not balancing works through the usual suspects in order. For the accounting treatment of money sitting between the sale and the bank, clearing account vs suspense account covers which one to use and why the choice matters at audit.