How to Reconcile a Merchant Payout to a Bank Deposit

Last updated July 2026.

Quick answer: A merchant payout rarely matches your gross sales because the processor subtracts its fees, refunds, and chargebacks before it deposits the net amount into your bank as one lump sum. To reconcile, pull the payout report for a single payout, confirm gross sales minus fees minus refunds minus chargebacks and adjustments equals the payout total, then match that net total to the one deposit line on your bank statement by amount and date. Reconcile one payout at a time, not a whole month at once.

This is the single most common bookkeeping headache for anyone taking card payments. The bank shows a $4,812.47 deposit; your sales dashboard shows $5,300 in sales that day; the two will never agree until you account for what the processor took out. Here is how to make them tie.

Why the payout never equals your sales

Processors like Stripe, Square, PayPal, and Shopify Payments batch a group of transactions and pay you the net. Between your gross sales and the deposit, several things come out:

If you book the bank deposit as revenue, you understate both your real sales and your expenses, and your books will be wrong by the amount of the fees and refunds. The fix is to record the gross sales and each deduction separately, then confirm they net to the deposit.

Step 1: Pull the payout report, not the sales report

In your processor dashboard, open the specific payout (Stripe calls it a payout, Square a transfer or deposit, Shopify a payout). Each payout has its own ID and lists every transaction, fee, and refund included in that batch. This report, not the top-line sales summary, is what you reconcile against. Export it so you can work in a spreadsheet.

Step 2: Confirm the payout math

In the exported report, total the columns: gross sales, minus fees, minus refunds, minus chargebacks and adjustments. That result must equal the payout total the processor reports. If it does, the processor's own numbers are internally consistent and you can trust the net figure. If your processor gives you a formatted PDF payout summary rather than a clean export, convert it to rows first. Our Stripe statement converter, Square statement converter, and Shopify statement converter turn those payout PDFs into gross, fee, and refund columns you can sum in seconds.

Step 3: Match the net payout to the bank deposit

Now find the deposit on your bank statement. It will be one line, usually labeled with the processor's name and often dated one to three business days after the sales. Match it by amount to the net payout total from Step 2. When the two agree to the cent, that payout is reconciled. Converting your bank statement to a spreadsheet makes this matching fast, because you can sort deposits by amount and line them up against your list of payout totals. See our guide to reconciling bank statements for the full workflow.

Step 4: Record it correctly in your books

The clean way to book a payout is: debit your bank for the net deposit, debit an expense account for the processing fees, debit refunds against sales, and credit sales for the gross. That keeps your revenue at gross and your fees visible as a real expense you can deduct. Once the statements are in rows, categorizing those lines is quick, and you can bring the cleaned data into QuickBooks so the deposit, fees, and sales all post to the right accounts. Booking only the net deposit as income is the mistake that quietly deflates your Schedule C and hides deductible fees.

A worked example

Say your Stripe dashboard shows $5,300 in card sales on Friday. The payout report for that batch lists $5,300 gross, minus $158.20 in processing fees, minus $250 for one customer refund, minus a $15 dispute you lost plus its $15 fee. That nets to $5,300 minus $158.20 minus $250 minus $30, or $4,861.80. On Tuesday your bank statement shows a single deposit of $4,861.80 labeled with the processor's name. Match those two figures and the payout is reconciled. In your books you would credit sales $5,300, debit fees $173.20, debit refunds $250, and debit the bank $4,861.80. Notice that the deposit ($4,861.80) is $438.20 smaller than your sales; if you had booked only the deposit as income, that $438.20 of real sales and deductible cost would have vanished from your records.

Why timing throws people off

Sales made on Friday often pay out the following Monday or Tuesday, so a payout batch usually spans transactions from a slightly earlier window than the deposit date. Reconcile by payout batch, not by calendar day, and the timing stops mattering. This is also why a monthly total of sales will not match a monthly total of deposits at the boundaries: a few days of sales at each end fall into a different payout. For a deeper look at that gap, see why ecommerce sales do not match bank deposits.

The bottom line

A merchant payout is your gross sales minus fees, refunds, and chargebacks, deposited as one net lump sum one to three days later. Reconcile one payout at a time: pull the payout report, confirm the math nets to the payout total, match that total to the single bank deposit by amount, then book gross sales and fees separately. Convert the payout PDFs and your bank statement to spreadsheets first and the whole process becomes a sorting exercise instead of a hunt.