Why Shopify payouts reconciliation matters

Shopify payouts reconciliation means matching each Shopify Payments deposit in your bank account to the orders, refunds, fees and adjustments that make it up. It matters because the deposit almost never equals your sales. Shopify pays out in batches, often covering orders from more than one day, and it takes off processing fees, refunds, chargebacks and reserves before the money reaches you. If you don’t reconcile, a gap between “what Shopify says I sold” and “what hit my bank” turns into bad bookkeeping, missed fees, unnoticed chargebacks and a stressful month-end close. If you do reconcile, every deposit has an explanation, and you find problems while you can still fix them.

This guide explains why that gap exists, what it costs to ignore it, and how to reconcile without a spreadsheet. We wrote it while building the Payouts view in Send Invoice, a Shopify app for invoices, receipts and other order documents that also imports your Shopify Payments payouts.

What is a Shopify payout, exactly?

A Shopify payout is a single transfer from Shopify Payments to your bank account. Shopify doesn’t send money for each order separately. It collects your transactions over a payout period and sends them as one amount on your payout schedule, which is daily, weekly or monthly depending on your country and settings.

Each payout moves through a status: scheduled, in transit, paid, and occasionally failed or canceled. A payout can also go the other way. If refunds and chargebacks are larger than your sales in a period, Shopify withdraws the difference from your bank instead of depositing it.

The detail that trips people up is what happens inside a payout. When we built Send Invoice’s payout import, we found that Shopify reports each payout in two layers:

1. A summary, split into buckets: gross charges, charge fees, refunds, refund fees, adjustments and adjustment fees. A few rarer buckets cover reserved funds, retried payouts and advances.
2. Balance transactions, the individual line items. Each one has an amount, a fee and a net figure. Only charges and refunds link to an order. Fees, transfers and system adjustments have no order at all, and a single dispute adjustment can span several orders.

Your bank statement shows neither layer. It shows one line with one number. Reconciliation is how you get from that one number back to the transactions behind it.

Why is my Shopify payout less than my sales?

Your payout is smaller than your sales because Shopify pays out net, not gross. Between the order and the deposit, several things get taken off:

Timing adds to the confusion. A payout issued on Tuesday might include Saturday, Sunday and Monday orders, while Monday’s refund lands in the next one. Comparing “sales for Monday” to “the deposit on Tuesday” will almost never match, even when nothing is wrong.

A worked example

Here’s an illustrative payout for a store that had a normal weekend (it’s the one charted at the top of this post):

The bank shows $4,392.06. Shopify shows $4,860 in sales. The $467.94 difference is completely legitimate, but you’d only know that by opening the payout. Without reconciliation, that gap looks like missing money, or worse, nobody looks at it at all.

Why Shopify payouts reconciliation is important

1. Your books are wrong without it

If your bookkeeper records each bank deposit as revenue, your revenue is understated and your fees disappear, because they were netted off before the money arrived. If they record gross sales from Shopify instead, your bank balance never matches your books. Either way your profit figures are off.

Correct bookkeeping records gross sales, then fees, refunds and chargebacks as separate lines, and the net amount as the deposit. You can only do that if you know what each payout contains.

2. You can’t manage costs you can’t see

Processing fees are one of the biggest costs a Shopify store has, and they’re invisible in a net deposit. Reconciling shows your real fee rate across all payouts. That’s the number you need when deciding whether a Shopify plan upgrade, which lowers your card rates, is worth paying for.

The same goes for refunds and chargebacks. A slow rise in either one is easy to miss when it’s hidden inside larger deposits.

3. Chargebacks have deadlines

When a customer disputes a payment, you have a limited window to submit evidence. A chargeback that shows up only as “this week’s deposit was a bit low” is one you may never contest. Reconciling each payout surfaces every dispute adjustment and the orders it relates to, while you still have time to respond.

4. Failed payouts and missing money get caught

Payouts fail. Bank details change, an account gets closed, or a transfer is rejected. A failed payout means money you think you have isn’t in your account. The same check also catches the rarer case where a payout never arrives. If you only look at the bank, you notice a missing deposit weeks later, if at all.

5. Month-end and tax time stop being a scramble

Accountants reconcile the bank account every month. For a Shopify store, that means explaining every Shopify deposit. If you can hand over a list of payouts with the orders and fees behind each one, the close takes minutes. If you can’t, someone spends hours matching exports, or bills you for doing it.

At tax time the stakes are higher. Gross sales, fees and refunds each need to be reported correctly, and “the total of my deposits” isn’t any of those numbers.

6. It connects your sales records to your cash

Invoices, receipts and credit notes describe what you sold. Payouts describe what you were actually paid. Reconciliation links the two, so when a customer asks about an order or an auditor asks about a deposit, you can follow the money from the invoice all the way to the bank line.

How to reconcile Shopify payouts

The manual way

1. Download your bank statement for the period.
2. In Shopify admin, open Finance → Payouts and find the payout matching each Shopify deposit by date and amount.
3. Open each payout and export or copy its transactions.
4. Match the charges to your orders, and record fees, refunds, chargebacks and adjustments as separate lines in your accounting system.
5. Investigate anything that doesn’t tie out: a missing deposit, a failed payout, or an adjustment you don’t recognise.

This works, but it’s slow, and it gets slower with volume. A store doing a few hundred orders a week has hundreds of transactions to match every month.

With Send Invoice

Send Invoice’s Payouts view imports your Shopify Payments payout history, along with the transactions behind each payout, in the background. Every deposit and withdrawal appears in one list you can filter by issued date, status and transaction type.

Click any payout and you see what made it up: the orders it paid out for, and every refund, adjustment and fee. When your accountant points at a bank line and asks what it is, you can answer in one click. Sync payouts pulls in new deposits as Shopify issues them.

Access is read-only. Send Invoice can see your payouts but can’t change them or move money. Because the same app holds your invoices, receipts and credit notes, you can go from a deposit to an order to the invoice that was sent for it without switching tools.

What to watch for when you reconcile

• Transactions with no payout yet. Recent charges sit in your balance before they’re assigned to a payout. They belong in the next deposit, not a missing one.
• Transactions with no order. Fees, transfers and system adjustments don’t link to any order. That’s expected, but each one still needs a line in your books.
• Disputes spanning several orders. One adjustment can cover more than one order, so check the orders attached to it.
• Negative payouts. A withdrawal from your bank is still a payout and needs reconciling like any other.
• Other payment providers. PayPal and other gateways pay out separately and don’t appear in Shopify Payments payouts. Reconcile them on their own.

FAQ

Related: Shopify payouts, matched to your orders · Why invoice delivery matters · Bulk invoice export