A payment processor reports one total, and the bank account shows another. The gap is rarely a mystery. It usually comes from fees, timing and refunds that moved through different days, and a plain matching habit explains nearly every difference once it is in place.
This article describes a practical way to match payouts against deposits without a specialist on the team. It is general bookkeeping information rather than tax or accounting advice, so a qualified accountant should review any unusual case. The steps below follow the order that most small teams use at the close of each month.
Why Payouts Rarely Match Sales
A payout is the amount a processor sends after it removes its fees and any refunds or disputes from the period. A sale recorded on the day of purchase will therefore never equal the deposit on the bank statement. The first task is to accept that difference and record it clearly, rather than forcing two numbers to agree.
Start with a short list of the common causes, including processing fees, currency conversion, reserves held back by the processor and payouts that cover several days of sales at once. Keep the list beside the ledger where the bookkeeper can see it. Readers may also want to visit News-Raid.com.
Pulling the Right Reports
Most processors offer a payout report that lists each sale, fee and refund included in a deposit. Download that report for the same period as the bank statement, and save the file under a name that shows the dates it covers. Avoid relying on a summary total, because the line-by-line detail is what makes matching possible.
You can also visit FirstReporter.org for more reading. Ask the bookkeeper to read the guide once with the whole team, so everyone uses the same words for the same columns. Shared vocabulary prevents a lot of wasted meetings later. Keep a printed copy of the report in the same folder, so the team can mark the matching lines as they go.
Matching Fees to Each Sale
Take the first bank deposit and find the matching payout line in the report. Add the fees listed on that line to the sales it covers, then compare the result with the amount that reached the bank. A small leftover usually points to a timing gap, while a large one suggests a missing sale or an unrecorded refund. Note the reason beside each leftover, even when it seems obvious, because that note will help in a later month.
Create one ledger entry per payout instead of one entry per sale, unless the sales are few. Attach the processor report to that entry so anyone can see the working behind it. For a related read on this site, see Building a Digital Archive for Your Family Memories.
Handling Refunds in the Ledger
A refund reduces a payout after the original sale has already been recorded. Treat each refund as its own line, linked to the sale it reverses. That keeps the revenue report honest and avoids unpleasant surprises when the year closes.
Disputes deserve the same care. A disputed amount may be held by the processor until the case is settled, so the ledger should show it as pending rather than lost. Keep the dispute notice with the related entry, and update the status when the processor reports an outcome. Keep the notice in the same folder, and note the date the case was reviewed.
Closing the Month Cleanly
At the end of each month, compare the total of all payouts with the total of all bank deposits for the same period. Every difference should be explained by a listed item, such as a reserve or a currency adjustment. Anything that stays unexplained goes onto a short open list, with a named person beside each entry.
Review the open list at the start of the next month, before new payouts arrive. Clearing older items early stops small gaps from piling up into a problem nobody can trace. A team that repeats this routine for a full year will have a clean record to hand to an accountant. The habit also makes year-end questions far less stressful for everyone involved.
A Routine That Stays Short
A good reconciliation takes less time each month once the steps become familiar. The aim is not perfect accuracy on the first day, but a record that anyone on the team can follow and explain. Keep the report template, the open list and the fee notes together in one folder, and the process will stay manageable even as sales grow. Simple steps repeated patiently beat complicated tools that nobody opens.