To reconcile Shopify payouts, export the transactions inside each payout, match every charge to its order, record fees, refunds and adjustments as their own lines, then confirm the payout's net amount equals one credit on the bank statement. Orders paid through other gateways are reconciled separately, because they never pass through a Shopify Payments payout.
What does a Shopify payout contain?
A Shopify payout is one transfer that carries the net of many Shopify Payments transactions. Shopify's help pages describe the payout overview as a breakdown of charges, refunds, adjustments and reserves, with fees deducted from each charge. The bank receives a single figure, so the bank line alone says nothing about which orders it paid.
Think of each payout as a small statement of its own. It opens at zero, adds the net of each card charge, subtracts refunds and any adjustments, and may hold some funds back. What is left is what the bank sees. Reconciling it means proving each of those pieces belongs where you recorded it.
The pieces you will meet
- Charges: customer payments for orders, each with a fee taken out.
- Refunds: money returned to a customer, which reduces the payout it lands in, not the payout of the original order.
- Adjustments: corrections, dispute amounts and dispute fees, and other items Shopify posts against the balance.
- Reserves: funds held back for a period, which reduce a payout now and come back in a later one.
Because refunds and adjustments land in whichever payout is open when they happen, a payout rarely matches any single day's sales.
Exporting Shopify payout transactions for the tie-out
The payout detail you need comes from the Shopify admin, not from the sales reports. According to Shopify's guide to viewing and exporting payout details, you open Finance, then Payouts, select the payout, and choose to export its transactions as a CSV that is emailed to you.
That same page lists the CSV's columns, and they are exactly what a reconciliation needs:
| Shopify CSV column | Use in the reconciliation |
|---|---|
| Transaction Date | When the charge, refund or adjustment happened |
| Type | Separates charges from refunds and adjustments |
| Order | The order number to trace back to the sales report |
| Payout Date | Groups rows into the bank deposit they became |
| Amount | The gross figure for the ledger |
| Fee | The processing cost of that row |
| Net | Amount less fee, which sums to the payout |
Shopify also offers an export of all balance transactions for a date range, from the payments settings. That file is useful at month-end, when you want everything in one place and need to see which transactions had not yet been paid out.
Keep each payout's export with the month's working papers. If the payout is ever questioned, the file shows exactly what the bank credit was made of.
Matching Shopify orders to payout lines
Matching Shopify orders to payout lines means taking each order number in the sales report and finding the charge row that carries it in a payout export. The Order column links the two. An order that paid through Shopify Payments but appears in no payout is either still pending or worth asking Shopify about.
Work from the sales side first. Export the orders for the period with their payment gateway, total and financial status. Filter to orders paid through Shopify Payments. Then look up each order number in the combined payout exports and mark it found.
What is left over usually explains itself
- Orders with no payout row placed in the last day or two of the period are normally still waiting to be paid out.
- Orders with partial payments, such as a deposit taken now and the rest later, appear in more than one payout.
- Orders paid by another gateway never appear, which the next sections cover.
- Charge rows with no matching order are rare, and usually point to an order that was deleted or edited after payment.
A lookup in a spreadsheet does this quickly. Put the payout rows on one sheet, the orders on another, and pull the payout date into the orders sheet by order number. Blanks are your exceptions.
Shopify payout fees, refunds and chargebacks in the ledger
Shopify payout fees, refunds and chargebacks each need their own entry in the ledger, separate from the sale. If you record only the net deposit, revenue is understated by every fee, and a refund disappears into a smaller deposit. Record sales at the gross amount, then post each deduction to its own account.
A clean way to do it is a clearing account for Shopify Payments. Sales post into it at gross. Fees, refunds and adjustments post out of it. Each payout moves its net amount from the clearing account to the bank. When every payout has been recorded, the clearing balance should equal whatever Shopify is still holding for you.
How each deduction is booked
- Fees go to a merchant or processing fee expense account.
- Refunds reduce sales, usually through a returns or refunds account so the gross figure stays visible.
- A chargeback removes the disputed amount from the payout. Move it to a receivable or dispute account until the outcome is known, and book any dispute fee as an expense. Reconciling chargebacks and reversals covers what to do if the dispute is won and the funds come back.
Card terminals and other processors use the same pattern. Reconciling merchant deposits from card sales applies it to batch settlements from a card terminal, where each card brand may pay separately.
Orders paid outside Shopify Payments
Orders paid outside Shopify Payments are settled by whoever took the payment, so they never appear in a Shopify payout. A customer who pays with PayPal is paid out by PayPal. A manual payment, such as a bank transfer or cash on delivery, arrives however the customer sent it. Each needs its own reconciliation.
Split the order export by payment gateway before you start. Each gateway gets its own clearing account and its own tie-out to the bank. If you run a marketplace channel too, its money arrives through its own settlements; Amazon settlement reconciliation for sellers works through how those reports differ from a processor payout.
Cash sales are a separate case. Some shops take cash at markets or pop-up events and enter the orders in Shopify as manual payments. That cash should be counted, deposited or held in a cash fund, and matched to those orders. If it sits in a cash box before it is banked, reconciling petty cash in QuickBooks shows how to keep that fund balanced.
Worked example: one Shopify payout tied to the bank deposit
The example below follows one invented payout from export to bank line. All figures are illustrative; fees are made up and do not reflect any real rate. The payout carries six charges, one refund for an earlier order and one adjustment for a dispute fee.
| Type (example) | Order | Amount | Fee | Net |
|---|---|---|---|---|
| charge | #1041 | 120.00 | 3.78 | 116.22 |
| charge | #1042 | 64.50 | 2.17 | 62.33 |
| charge | #1043 | 249.00 | 7.52 | 241.48 |
| charge | #1044 | 38.00 | 1.40 | 36.60 |
| charge | #1045 | 175.00 | 5.38 | 169.62 |
| charge | #1046 | 92.25 | 2.98 | 89.27 |
| refund | #1038 | -45.00 | 0.00 | -45.00 |
| adjustment | (dispute fee) | -15.00 | 0.00 | -15.00 |
| Payout | 678.75 | 23.23 | 655.52 |
Foot the Amount column and the charges come to 738.75 before the refund and the adjustment take 60.00 off. Foot the Fee column and it comes to 23.23, all of it on charges. As a bridge to the bank, the payout reads:
| Check | Amount |
|---|---|
| Charges at gross | 738.75 |
| Less refund for order #1038 | -45.00 |
| Less dispute fee adjustment | -15.00 |
| Less fees on charges | -23.23 |
| Net payout | 655.52 |
| Bank credit from Shopify on the statement | 655.52 |
The entries are: 738.75 of sales into the clearing account, 45.00 out as a refund, 15.00 out as a dispute fee expense, 23.23 out as processing fees, and 655.52 from clearing to the bank on the day the deposit posts. The clearing account nets to zero for this payout.
Notice what the refund does. Order #1038 was paid out in an earlier payout, so its refund reduces this one. Anyone comparing this payout to the orders placed on its dates would find it 45.00 short and might go looking for a missing order that does not exist. Tracing by row type, not by date, avoids that.
Edge case: Shopify reserves and payouts that go negative
Shopify reserves and negative balances are the edge cases that break a simple payout-equals-deposit check. A reserve holds back part of the funds, so the payout is smaller than its transactions suggest. A large refund or dispute in a quiet period can push the balance below zero, and then money may be taken from the bank instead.
Reserves
Treat reserved funds as an asset, still owed to you, not as a fee. Record the held amount in its own account, such as "Shopify reserve", and move it back to clearing when the release appears in a later payout. At month-end, the reserve account should agree with the reserve balance shown in Shopify. Payment processor reserve accounting covers the release schedule and the monthly check in more detail.
Negative payouts
When refunds and adjustments exceed the charges in a period, the payout can be negative. A processor recovers a negative balance either by netting it against later payouts or by debiting the bank account on file, so check the payouts page to see which happened. A debit from Shopify on the bank statement is then the payout, with its sign reversed. Match it to the payout export exactly as you would a credit.
The mistake to avoid is recording that debit as a fee or an expense. It is a net payout like any other, and the refund and adjustment rows inside it are what belong in the expense and returns accounts.
Why don't Shopify sales and Shopify payouts match for a month?
Shopify sales and Shopify payouts rarely match for a month because they measure different things on different dates. Sales count orders placed in the month across every gateway. Payouts count money transferred in the month, net of fees, refunds and reserves, from Shopify Payments only. A gap is normal; an unexplained gap is not.
A month-end bridge
To explain the difference, build a short bridge from sales to bank deposits:
- Start with total sales for the month from the sales report.
- Subtract orders paid through other gateways and manual payments.
- Subtract Shopify Payments orders from the last days of the month that were paid out in the next month.
- Add orders from the last days of the previous month that were paid out this month.
- Subtract refunds, fees and adjustments inside this month's payouts.
- Subtract any change in reserved funds.
What is left should equal the Shopify credits on the bank statement for the month. If it does not, compare payout by payout until you find the one that differs.
The bank side of the bridge has to be right before any of this is worth doing. PreciseBankFlow checks that each bank statement foots and matches statement lines to your ledger or register, so a missing or duplicated Shopify deposit shows up as an exception instead of hiding inside the month's total. You can see how it reconciles a statement before deciding whether it fits your close.