What is a Payment Reconciliation?

What Is Payment Reconciliation?

Payment reconciliation is the process of matching transaction records across different systems to confirm that payments have been processed correctly, fees have been deducted accurately, and the right amounts have been deposited into the merchant's account. It is essentially the financial health check that ensures what you sold matches what you were paid.

For any business that accepts card payments, reconciliation is not optional -- it is a fundamental part of financial management. Without it, discrepancies go unnoticed, revenue leaks accumulate, and the business has no reliable picture of its cash position.

Why Reconciliation Is Necessary

A single card transaction involves multiple parties, each maintaining their own records: the merchant's point-of-sale or payment system, the payment gateway, the payment processor, the acquiring bank, the card network, and the issuing bank. At every handoff, there is potential for discrepancies.

Common sources of discrepancy include:

• Timing differences -- A transaction authorised on one day may settle on another, creating apparent mismatches between sales records and bank deposits.
• Fee deductions -- Interchange fees, processing fees, scheme fees, and any other charges are deducted at various stages, so the deposited amount rarely matches the gross sale amount.
• Refunds and chargebacks -- Returns, partial refunds, and disputed transactions reduce the settlement amount and must be matched to the original transactions.
• Currency conversion -- For businesses accepting international payments, exchange rates and conversion fees add another layer of complexity.
• Failed or declined transactions -- Transactions that were attempted but did not complete can create phantom records in some systems.

The Reconciliation Process

Payment reconciliation typically involves comparing three sets of records:

• Internal sales records -- What the business recorded as sales through its payment system, virtual terminal, or order management system.
• Processor/gateway reports -- What the payment processor or gateway recorded as successfully processed transactions, including fees and adjustments.
• Bank statements -- What actually appeared as deposits in the merchant's bank account.

The process works by matching transactions across these three sources using unique identifiers such as transaction IDs, authorisation codes, or merchant reference numbers. Any transaction that does not match across all three sources is flagged for investigation.

Manual vs Automated Reconciliation

Small businesses with a handful of daily transactions can sometimes manage reconciliation manually using spreadsheets. But as transaction volumes grow, manual reconciliation becomes impractical and error-prone.

• Manual reconciliation -- Suitable for very low volumes. Involves downloading reports from each source and comparing them line by line. Time-consuming and vulnerable to human error.
• Semi-automated -- Using accounting software or spreadsheet tools that can import data from multiple sources and perform matching rules automatically, flagging exceptions for manual review.
• Fully automated -- Enterprise reconciliation platforms that ingest data from payment processors, banks, and internal systems in real time, performing continuous matching and alerting staff only when discrepancies are found.

Reconciliation and Telephone Payments

Businesses that accept payments through multiple channels -- online, in-person, and over the phone -- face additional reconciliation complexity. Each channel may use different payment systems, different processors, or different reporting formats.

Telephone payments can be particularly challenging to reconcile because they may be processed through a different gateway or virtual terminal than other channels. Consistent transaction referencing is crucial -- every phone payment needs a clear, unique reference that can be traced through the payment processor's reports and matched against bank deposits.

For contact centres handling high volumes of phone payments, reconciliation also serves as a fraud control mechanism. Discrepancies between the number of payments agents report and the number that actually settle can indicate process issues or, in rare cases, internal fraud.

Best Practices for Payment Reconciliation

• Reconcile daily -- Do not let discrepancies accumulate. Daily reconciliation catches problems early when they are easier to resolve.
• Use consistent references -- Ensure every transaction has a unique reference that is recorded consistently across all systems.
• Account for timing -- Understand your settlement cycle and do not flag timing differences as errors. A transaction authorised on Friday and settled on Monday is normal, not a discrepancy.
• Track fees separately -- Maintain clear records of all fee categories so you can verify that fee deductions match your processor agreement.
• Investigate exceptions promptly -- Unresolved discrepancies can indicate chargebacks, processing errors, or system issues. Investigate them quickly.

Reconciliation Tools and Technology

The reconciliation technology landscape ranges from basic spreadsheet-based matching to sophisticated enterprise platforms. For small businesses, accounting software like Xero or QuickBooks can import bank feeds and match them against invoices and payment records, flagging unmatched items for review.

Larger businesses handling thousands of daily transactions typically use dedicated reconciliation platforms that automate the entire process. These tools ingest data from multiple sources -- payment gateways, processors, bank accounts, and internal order systems -- and apply matching rules to identify discrepancies automatically. Staff only need to investigate the exceptions, rather than reviewing every transaction manually.

Multi-Channel Reconciliation Challenges

Businesses accepting payments through multiple channels -- website, in-store terminals, telephone, and payment links -- face the most complex reconciliation scenarios. Each channel may use different payment processors, generate different reporting formats, and settle on different schedules.

The key to managing this complexity is standardisation. Using consistent transaction references across all channels, consolidating processor reports into a single view, and aligning settlement schedules where possible all help reduce reconciliation friction. Businesses that process significant telephone payment volumes should ensure their phone payment system generates references that are compatible with and traceable through their primary reconciliation workflow.