If you sell on Shopify, your sales report and your bank balance will rarely agree on the first try. That's normal. The skill is knowing which differences are just timing and which ones need chasing.
This guide walks through how to reconcile Shopify Payments payouts, one payout at a time, so you can match orders to deposits and spot what's missing. It's written for store owners and for the bookkeepers and accountants who close their books.
What "reconciling a Shopify payout" means
A payout is the money Shopify sends to your bank. It isn't a list of your sales. It's the net of many things in a period: customer charges, minus Shopify's fees, minus refunds, plus or minus adjustments, and minus any chargebacks.
Reconciling means proving three links hold:
- Every order marked paid shows up as a charge in some payout.
- Each payout's total equals what actually landed in your bank.
- Anything that doesn't line up has a clear reason: timing, a refund, a fee, a dispute, or a real problem.
Before you start
You need three things for the same period:
- Your Shopify orders (paid ones)
- Your Shopify Payments payout details
- Your bank statement
Work on one payout at a time, not a whole month. A month hides the cause of any difference.
Step 1: Export the payout details
In your Shopify admin, open Finance, then Payouts, and click the date of the payout you want. Click Export, then Export payout transactions.
If you want everything for a period, go to Settings, then Payments, then View payouts, then View Transactions. Click Export, pick your date range and CSV, and choose Export balance transactions. Shopify emails the file to you and the store owner.
The export includes columns such as transaction date, type, order, payout status, payout date, "available on" date, amount, fee and net. Those columns are your raw material.
Step 2: Check the payout's own maths
For the payout you chose, add up the Net column. That total should equal the payout amount Shopify shows. If it doesn't, stop here: something in the export isn't what you think it is, and nothing downstream will tie.
Remember each line is Amount minus Fee equals Net. Fees are taken out before the money reaches you, so your deposit is always smaller than your gross sales.
Step 3: Match the payout to your bank
Look at the payout's date and amount, then find the deposit in your bank statement. They should match in amount. The date can differ by a day or so, depending on your bank.
Also check the status. A payout can be scheduled, deposited, failed or withdrawn. A failed payout means the money didn't reach the account, often because of a bank account or verification issue, and needs fixing before anything else.
Step 4: Match orders to charges
Take the paid orders from your Shopify orders list for the period. For each one, find its order number in the payout exports.
You'll end up with three groups:
- Matched: the order has a charge in a payout. Done.
- Not paid out yet: the order is paid, but its charge is still pending or sits in a future payout. Check the "available on" date. This is usually timing.
- No charge anywhere: the order is marked paid, but you can't find money for it in any payout. Keep these on a list. They're the ones to investigate.
Step 5: Understand the lines that confuse people
- Refunds appear as negative lines and can land in a different payout from the original sale.
- Adjustments cover things that aren't a plain charge.
- Chargebacks and disputes can reduce a payout, and often come with a separate fee.
- Reserves can temporarily hold back part of your funds to cover disputes and refunds.
- Minimum payout thresholds in some countries mean small balances wait until they're big enough.
- Currency: if your payout currency differs from the sale currency, amounts won't look identical.
Step 6: Sort every difference into two buckets
Go through what's left and put each item in one of two groups.
Normal timing: payouts are batched on your schedule (daily, weekly or monthly), and money captured late in the month lands in next month's deposit. Weekends and holidays push things back. Pending charges simply haven't reached a payout yet.
Needs investigating: a failed payout, a chargeback you didn't expect, or an order with no charge anywhere that's well past its expected payout date.
The real skill in reconciliation is separating these two quickly. If you can't tell, keep the item on your "open" list and look again after the next payout.
Step 7: Record it in your books
Once the payout ties, post it so your accounts show gross sales, fees, refunds and the net deposit. Your accountant's chart of accounts decides exactly how. The point is that your deposit in the bank, the payout in Shopify and the entry in your books all say the same thing.
Common questions
Why doesn't my payout match my sales? Because a payout is net of fees, refunds, adjustments and chargebacks, and it covers charges from a particular window, not "this month's sales". Compare payout to payout, not payout to monthly sales.
How long do Shopify payouts take? It depends on your country, your payout schedule and your account. Check Shopify's current payout timing guidance for your region.
What if an order is paid but I can't find the money? First check it isn't just pending. If it's well past its expected date and not in any payout, contact Shopify Payments support with the order number.
Can I do this in a spreadsheet? Yes, for a small store. Paste the payout CSV next to your orders export and match on order number. It gets slow as order volume grows.
Skip the manual matching
Reconciling by hand works, but it's repetitive. Fincile is a Shopify app that does the order-to-payout matching for you and flags what doesn't tie: orders marked paid that never settled, duplicate charges, chargebacks and failed refunds. You can start with a free audit of up to 100 orders by uploading a payout CSV, and export a CSV or PDF report for your accountant.
For stores on Shopify Payments, there is also a payout monitor in beta (invite only) that checks each charge reaches a payout on time and flags payouts that fail or arrive late.
This guide is general information, not accounting or tax advice. Check labels in your own Shopify admin, and confirm your treatment with your accountant.