What Is Payment Reconciliation? Process and Examples

Payment reconciliation connects what a business sold with what it collected and what reached the bank. It checks that invoices or sales records agree with payment transactions, settlement reports and deposits after fees, refunds and other adjustments are accounted for.

The records rarely match one line at a time. Ten customer payments may arrive as one deposit. A Friday sale may settle after the weekend. A refund can reduce a later payout. Reconciliation explains those differences and identifies the ones that need action.

What payment reconciliation actually compares

Each record answers a different question. A sales report shows the commercial activity. A processor report shows payment activity. A settlement report explains how funds were grouped and adjusted. The bank statement confirms what arrived or left the account.

A payment authorization is not the same as a funded deposit. Check the final transaction status and the settlement or payout record rather than treating every authorization as cash received. Voids, reversals and failed payments can change the picture.

Card networks such as Visa and Mastercard are not interchangeable with your payment processor. The processor or payment provider supplies the transaction and funding reports for your account; the bank provides the deposit record. Use the relevant reports rather than expect a card-network statement to reconcile your merchant deposits.

Payment reconciliation versus bank reconciliation

Payment reconciliation focuses on the path from a customer payment to the associated funding and accounting records. Bank reconciliation compares the bank statement with the cash account in the books, including items beyond merchant payments such as transfers, payroll and bank charges.

The two processes support each other. Explaining a processor deposit makes the bank reconciliation easier, but a balanced bank account alone does not prove that every invoice was paid correctly. An unapplied customer payment or an incorrect allocation can exist even when the cash balance agrees.

A worked example: why sales do not equal the deposit

Suppose a business records five card payments totalling $2,500 on Friday. Four payments totalling $2,000 enter the Friday batch. A $500 payment is captured after the cutoff and belongs to the next batch. A $200 refund from an earlier sale is also included in Friday’s settlement.

For this example, the processor deducts $48 in fees from that batch. All figures are illustrative, in one currency, and are not a Clearly pricing quote. The $200 refund is separate from Friday’s five new payments.

The funding report shows a $1,752 payout that reaches the bank on the next applicable funding day. Match that deposit to the batch, not to a single invoice and not to the full $2,500 sales total. The $500 later-captured payment remains an identified reconciling item until its batch is funded.

In a clearing-account approach, the $2,500 of collections is tracked through the payment clearing account. The $200 refund, $48 fee and $1,752 deposit explain $2,000 of the movement, leaving $500 to match to the later payout. How the sale or invoice is posted depends on the business’s accounting method and existing records; do not record the revenue a second time.

This example assumes net settlement. Some providers deposit gross amounts and collect fees separately. In that case, reconcile the gross deposit and the later fee debit as separate movements. Check the actual agreement and reports before adopting a net-deposit formula.

A practical payment reconciliation process

1. Set a consistent period and collect the records

Choose a daily or other workable review period and use consistent time zones, currencies and cutoff rules. Collect the sales or invoice register, detailed payment report, settlement or payout report, bank activity and any fee, refund or dispute records. Preserve transaction and batch identifiers in exports.

For a multi-location business, identify which merchant accounts feed each bank account. A combined bank deposit can be difficult to trace if reports are split across locations or channels. Check that the report filters cover the same accounts and do not quietly exclude refunds.

2. Match customer balances to successful payments

Check that the amount collected was applied to the correct invoice, order or customer account. Separate partial payments, overpayments and deposits from full settlement of an invoice. A receipt with the right amount but the wrong client reference still needs correction.

Use stable identifiers before relying on amount and date alone. Two clients can pay identical fees on the same day. Match transaction IDs or invoice references where available and retain the supporting record for any manual allocation.

3. Rebuild the settlement total

Group the successful payments by the processor’s batch or payout reference. Account for refunds, fees and any documented holds, reserves, dispute debits or releases. Check which adjustments belong to that payout rather than subtracting every fee visible in the reporting period.

A refund date may differ from the original sale date. Match the refund to its original transaction and to the settlement that carries it. Do not reduce both the original deposit and the later payout for the same refund.

4. Match funding to the bank

Find the bank entry using the payout amount, reference and expected funding window. A bank posting date need not be the sale date or batch date. Weekends, holidays and account-specific funding arrangements can create legitimate timing differences.

Record an expected deposit as outstanding until the bank confirms it. If it is outside the agreed funding window, investigate with the payout reference rather than simply adjusting the books to make them balance.

5. Resolve exceptions and retain an audit trail

Maintain an exception list with the amount, reference, reason, owner and next action. Distinguish a known timing difference from an unexplained shortfall. Correct mistakes with traceable entries and evidence, not an unexplained balancing adjustment.

At close, review older outstanding items and confirm they were subsequently settled or otherwise resolved. For higher-volume operations, assign independent review where practical. Repeated small differences can reveal a mapping problem that deserves a process fix.

Common discrepancies and where to look

The deposit is smaller than sales. Check net fees, refunds, payments captured after cutoff and documented adjustments. Start with the payout report before assuming money is missing.

A payment appears twice. Compare transaction IDs and check imported records, manual entries and bank-feed additions. Two similar lines may represent a payment and its deposit, not two sales.

An invoice is unpaid but money arrived. Look for missing references, a payment applied to another customer, a partial payment or a collection entered outside the invoice workflow.

A refund does not appear where expected. Check its final status and the later settlement period. A request, an approved refund and the resulting movement of funds are different records.

The difference recurs every month. Review report filters, fee billing, currencies and integration mappings. A consistent error often points to a repeated rule rather than an isolated transaction.

Avoid counting bank-feed deposits as new income

A downloaded deposit is evidence of bank activity. It is not automatically a new sale. If the invoice, receipt or payment is already recorded, adding the bank-feed amount to income again can duplicate revenue.

Intuit’s QuickBooks guidance explains matching downloaded transactions to existing records to avoid duplicates. Review the suggested match rather than accept it solely because the amount agrees. For grouped payments, create or identify the appropriate grouped deposit before matching the bank line.

Intuit also describes using Undeposited Funds to group payments. The right workflow depends on the accounting system and payment integration. A clearing account or supported grouping process should preserve gross collections, fees and net funding without recognising the same income twice.

What good reporting and integrations should provide

Useful payment reports make it possible to trace an invoice or order reference to a transaction, then to a payout. Look for searchable identifiers, separate refund entries, fee detail and exports that retain those relationships. Ask to see how a real exception is handled, not only a successful sale.

Clearly’s invoicing and recurring payment options support different collection workflows. For accounting connections such as QuickBooks, confirm the supported version, data flow and treatment of fees and refunds. An integration can reduce re-entry without removing the need to review exceptions.

Automation is valuable when it matches reliably and exposes uncertainty. A spreadsheet can still be useful for a modest-volume business or a documented exception log. Replace manual work when volume or error risk justifies it, not because a tool is automatically better at understanding every adjustment.

Apply the same controls to different businesses

A retailer may reconcile daily terminal batches against till totals. An online business may need order and gateway references. An accounting firm may match tax invoices and monthly bookkeeping fees to client accounts before reconciling the deposit. The sequence is the same even though the source records differ.

For a firm collecting professional fees, see our accountant payment-processing guide and professional-services payment solutions. For businesses needing additional operational help, Clearly’s back-office payment services can be discussed separately from the standard processing setup.