A processor deposit often does not equal the sales total shown in your store, booking system or invoices. That difference is not automatically an error. Processors may deduct fees, net refunds, settle transactions on different dates or hold amounts before sending money to the bank. The job is to explain each difference without losing sight of gross sales.
A reliable reconciliation connects three records: the underlying customer transactions, the processor's settlement or payout report, and the bank deposit. If your bookkeeping system posts sales separately, add the general ledger as a fourth record.
Understand the three dates
A customer might buy on Monday, the processor might settle on Tuesday and the bank might receive the payout on Wednesday. A weekend or holiday can add time. Do not force all three records to share the same date. Instead, keep transaction date, settlement date and deposit date as separate fields in your reconciliation.
Start with gross activity, not the net deposit
Export the processor's payout detail, including transaction identifiers. Identify gross sales, customer refunds, processing fees, disputes or chargebacks, reserves and any other adjustments. Compare gross activity with the sales system for the same population of transactions. Confirm whether taxes, tips, gift cards and shipping are included in the processor total and how the sales system treats them.
Some processors net activity from multiple days into one payout, while others split a day's sales into several deposits. Match by payout or settlement identifier where possible, rather than guessing from amount alone.
Bridge the payout to the bank
Use a payout bridge: gross card receipts minus refunds, processor fees, chargebacks and withheld reserves, plus released reserves or other supported adjustments, equals the expected net payout. Compare that expected amount with the actual bank deposit. Investigate every unexplained difference instead of posting it to a miscellaneous account.
For example, suppose a payout contains $4,000 of card receipts, $250 of customer refunds and $110 of processor fees, with no other adjustments. The expected bank deposit is $3,640. The $110 is not a reduction in gross sales merely because it was withheld before deposit. The correct classification of sales, taxes, liabilities and expenses still depends on the business's underlying transactions and accounting policies.
Use a clearing account when timing crosses periods
A processor clearing account can track amounts collected from customers but not yet deposited. Record the processor activity in the appropriate accounts, then clear the balance as payouts reach the bank. The clearing balance should be explainable by unsettled transactions, in-transit payouts and documented adjustments. It should not quietly accumulate old differences.
If your accounting platform imports both sales and bank deposits automatically, confirm the deposit is matched against clearing activity rather than counted as new revenue. Otherwise a successful sale can appear twice.
Treat refunds, disputes and fees separately
Refunds should tie to approved customer adjustments and the processor's refund identifiers. Chargebacks need their own support, including the dispute notice, decision and any fees. A chargeback is not necessarily a permanent loss at the moment it is opened. Review the actual status and settlement before finalizing the accounting treatment.
Fees may be withheld per transaction, charged per payout or billed monthly. Reconcile the processor's monthly statement to fee expense and to any amounts separately debited from the bank. Avoid booking the same fee twice.
Keep a short exception register
For each unresolved item, record the processor, transaction or payout ID, amount, expected date, actual bank date, cause, owner and next action. Review older clearing balances, missing deposits, duplicate imports, refunds without approvals and unexplained fee changes. Escalate unusual activity rather than adjusting it away to make the reconciliation appear complete.
A practical close checklist
- Download detailed sales and processor payout reports for the period.
- Reconcile gross card activity to the sales or billing system.
- Bridge every payout from gross activity to net bank deposit.
- Account for fees, refunds, disputes, reserves and timing differences.
- Match bank deposits to payout IDs and avoid duplicate revenue.
- Reconcile the processor clearing account and assign outstanding exceptions.
Source and scope
The University of Kentucky's merchant-card services guidance describes using processor activity reports to reconcile settlements to ledger deposits and notes that processing and accounting dates can differ. Its institutional system rules are not universal requirements for small businesses; the principles of traceability, reconciliation and documented timing differences are broadly useful.
This is general accounting guidance, not individualized tax, audit or legal advice. Businesses with specialized revenue recognition, marketplace-facilitator sales or multi-currency payouts should adapt the reconciliation to their actual accounting requirements.
When you need someone to own the process
Summer Peaks can manage payout reconciliation, accounts receivable, monthly bookkeeping or a focused cleanup project. Hire us for the accounting work you need without creating a new employee position. All client work stays in the United States. Request a tailored proposal.