How to Reconcile Payment Processor Payouts

Say your customers paid $10,000 this week, yet only $9,412 landed in the bank. Somewhere in between are fees, refunds, a disputed charge and a payout that arrived a day late. This guide shows you how to reconcile payment processor payouts so every deposit ties back to real sales, with a simple monthly routine and a template you can copy today.

Person holding a payment card in one hand next to a calculator on a desk, checking figures for a business — Card sales and bank deposits rarely match on their own. Reconciliation explains the gap.

Key takeaways

A payout is a net figure: gross sales minus fees, refunds, chargebacks and any reserves, often for sales from several different days.
Record gross sales and every deduction separately. Booking only the net deposit hides your real revenue and your real costs.
A clearing account for each processor is the simplest way to see what is still "in transit" at any moment.
A short weekly check plus a fuller monthly close keeps reconciliation to minutes rather than a painful afternoon.

If you take card or online payments, you probably use a processor such as Stripe, Square, PayPal or Adyen. They make getting paid easy. What they do not do is hand you a deposit that matches your sales report line for line. Each payout bundles many transactions, subtracts costs and follows its own schedule.

That is fine, as long as you can explain it. When you cannot, small problems hide in the gap: a fee you did not expect, a refund issued twice, a dispute you forgot to answer, or sales that never reached the bank at all. Let's set up a routine that catches them.

Why payouts never match your sales

Before you fix anything, it helps to know what normally sits between a sale and a deposit. Almost every difference falls into one of these buckets:

Processing fees: per-transaction fees, percentage fees, and sometimes monthly, currency or payout fees.
Refunds: money returned to customers, which reduces the next payout.
Chargebacks: disputed payments pulled back by the card network process, often with a separate dispute fee.
Reserves or holds: some processors keep back part of your balance for a period, especially for new or higher-risk accounts.
Timing: payouts can arrive one or more business days after the sale, and weekends and bank holidays shift things further.
Currency conversion: sales in one currency, payouts in another, with a conversion rate and possibly a fee in between.
Other deductions: loan repayments taken from payouts, add-on services, or adjustments from earlier periods.

Your processor's dashboard and payout reports list most of these. Your job is to bring them into your books in a way that shows each one clearly.

Common mistake

Recording each bank deposit as "sales." It feels simple, but it understates your revenue, hides your payment costs inside it and makes refunds and chargebacks invisible. It also makes sales tax and VAT reporting harder, because those are usually based on gross sales, not net payouts.

The clearing account method

The cleanest way to reconcile payouts is to give each processor its own clearing account in your bookkeeping. Think of it as a holding pen that represents money the processor owes you.

Here is how it flows:

Record gross sales into the clearing account. When a sale happens, the full amount goes in, with revenue and any sales tax recorded on the other side.
Record fees out of the clearing account. Each fee becomes an expense, usually a "merchant fees" or "payment processing" category.
Record refunds and chargebacks out of the clearing account. These reduce revenue (or go to a contra-revenue account), and dispute fees go to expenses.
Record the payout as a transfer. When money hits your bank, move it from the clearing account to the bank account. It is a transfer, not income.
Check the balance. Whatever remains in the clearing account should equal what the processor still owes you: pending sales, held reserves or balances not yet paid out.

If the clearing balance matches the processor's own "pending" or "available" balance at month end, you are reconciled. If not, the difference tells you exactly how much to go looking for.

Pro tip

Many accounting tools offer direct integrations with major processors that post sales, fees and payouts automatically. They can save hours, but they still need a human check each month. Review how the integration maps fees and refunds before you trust it, and check current features, pricing and privacy policies before connecting.

A worked example with made-up numbers

Example

Sam runs a small online homeware shop. On Monday a payout of $2,846 arrives (all figures are made up). The processor's payout report says it covers sales from Thursday to Sunday. Gross sales were $3,050. Fees were $96. One refund of $80 was issued. One chargeback of $25 was pulled back, with a dispute fee of $3. That gives $3,050 minus $96 minus $80 minus $25 minus $3, which equals $2,846.

In the books, Sam records $3,050 of sales into the clearing account, $99 of fees as expenses, the $80 refund and $25 chargeback as reductions of revenue, and the $2,846 payout as a transfer to the bank. The clearing account for that payout nets to zero. Done.

Notice what Sam can now see that a single "sales: $2,846" entry would hide: a chargeback worth investigating, and a real fee cost to track across the year.

Your monthly reconciliation routine

Once the clearing account is set up, reconciliation becomes a routine rather than a hunt. A light weekly check plus a monthly close works well for most small businesses.

Weekly (10 to 15 minutes)

Match each payout in your bank feed to a payout report from the processor.
Glance at refunds and disputes. Answer any new disputes before the processor's deadline.
Flag any payout that is late, smaller than usual or missing.

Monthly (30 to 60 minutes)

Download the month's payout reports and the balance or transaction summary from each processor.
Compare gross sales in your books with gross sales in the processor's report and in your shop or point of sale system.
Compare fees, refunds and chargebacks line by line against the report totals.
Check the clearing account balance against the processor's ending balance, including any reserve.
Investigate differences above a threshold you set, for example anything over a small fixed amount or any unexplained item at all.
Write a one-line note for each difference and how you resolved it.
Lock the month in your accounting software once everything ties out, if it offers that option.

Open wallet stuffed with paper money, showing cash that has finally arrived after a payout cycle — Reconciliation is how you know the money in your account is all the money you earned.

Payout reconciliation template

Copy these columns into a spreadsheet, one row per payout. The amounts below are made-up examples.

Payout date	Processor	Sales period	Gross sales	Fees	Refunds	Chargebacks and dispute fees	Reserve held or released	Expected payout	Bank deposit	Difference
2 Aug	Processor A	29 Jul to 1 Aug	$3,050	$96	$80	$28	$0	$2,846	$2,846	$0
3 Aug	Processor B	2 Aug	$1,200	$41	$0	$0	$0	$1,159	$1,159	$0
5 Aug	Processor A	2 Aug to 4 Aug	$2,400	$75	$0	$0	$120 held	$2,205	$2,205	$0 (reserve noted)

The "Expected payout" column is a simple formula: gross sales minus fees, refunds and chargebacks, minus any reserve held, plus any reserve released. A nonzero "Difference" is your to-do list.

How to track down differences

When a payout does not match, work through these checks in order. Most gaps are solved in the first three.

Timing: is a sale recorded in your books on one day but included in the following payout? Check the sales period on the payout report.
Missing refunds: did a team member refund a customer through the processor without telling bookkeeping, or the other way round?
Fee changes: did your fee rate, plan or payout schedule change? Check the processor's notices and account settings.
Reserves: is part of the balance held back or newly released?
Currency: was the sale in a different currency, with conversion happening at payout?
Duplicates: did an integration import the same sale or payout twice?
Other sales channels: cash, invoices paid by bank transfer or a second processor can get mixed in if accounts are not kept separate.

Common mistake

Writing off small differences month after month as "rounding." A few dollars here and there can hide a fee you did not agree to or a refund pattern worth knowing about. Investigate once, then decide whether a tolerance is truly appropriate.

Staying ready for the busy season

Late summer is a good time to get this right. As autumn approaches and holiday trading builds, transaction counts can rise quickly, and so do refunds and disputes. A reconciliation habit that works at summer volumes will carry you through the final quarter without a pile of unexplained deposits in January.

A few habits help as volume grows:

One processor, one clearing account. Never mix two processors in the same clearing account.
Consistent categories. Use the same expense category for fees every month so you can compare your payment costs over time.
Clear refund rules. Decide who can issue refunds and how they are logged.
Calendar reminders. Put the monthly close on your calendar for the same working day each month.

A short reminder: this guide is general information about bookkeeping, not accounting or tax advice. If you are unsure how to treat refunds, chargebacks or sales tax in your books, a qualified bookkeeper or accountant can set things up correctly in an hour or two.

Pro tip

Keep a short "payout playbook" document with screenshots of where each report lives in each processor's dashboard. When someone else covers your monthly close, they can follow it without guessing.

Your payout reconciliation checklist

Create a separate clearing account for each payment processor
Record gross sales, fees, refunds and chargebacks separately
Record every payout as a transfer, not as income
Match each payout to its processor report every week
Answer new disputes before the processor's deadline
Reconcile clearing balances to processor balances each month
Log every difference and how you resolved it
Review fee totals quarterly to spot changes early

Frequently asked questions

How often should I reconcile payouts?

A quick weekly match of payouts to reports, plus a full monthly reconciliation, suits most small businesses. If you have high volume or frequent disputes, a short daily check can be worth it.

Do I need a clearing account if I only use one processor?

It is still the clearest method. Even with one processor, the clearing account shows what is still owed to you and makes month end straightforward. Your bookkeeper can set it up quickly.

Where do I find the information I need?

Most processors offer payout reports or balance reports that list every transaction included in each payout. Look in the reports or payouts section of your dashboard, and export them monthly for your records.

Should payment fees be recorded as an expense or deducted from sales?

Many businesses record them as an expense so their gross sales stay visible. Your accountant can confirm the best treatment for your situation and reporting needs.

The bottom line

A payout is a summary, not a sale. When you record gross sales, fees, refunds and chargebacks separately and route everything through a clearing account, every deposit explains itself and any gap stands out at once.

Set up your clearing accounts this week, copy the template, and book a monthly close on your calendar. A little routine now means you head into the busy season with numbers you can actually trust.