Payment reconciliation
Payment reconciliation is the process of checking every payment in a merchant’s own records against what each payment provider reported and finally booked. Each payment ends in a named outcome: matched, different in money, different in facts, or nothing to reconcile against. Its purpose is to find money that is missing, wrong or unverifiable.
How it works
Payment reconciliation starts by putting every source into one form. The merchant log, the provider callbacks and the provider statements all use different fields, statuses and units. After normalisation, each payment is joined across sources on every key the provider uses. Then each pair is compared on amount, currency and final status. Illustrative, synthetic example:
PAY-1A2B Provider A CUR-1 log: 500 success statement: 500 settled -> matched
PAY-1A2C Provider A CUR-1 log: 500 success statement: 50 settled -> differs in money
PAY-1A2D Provider B CUR-2 log: declined statement: settled -> differs in facts
PAY-1A2E Provider C CUR-3 log: success no statement -> nothing to reconcile against
Why it matters
Payment reconciliation is the only way to know that the money a merchant expects is the money it will receive. With dozens of providers, each with its own formats, gaps hide easily. On one anonymised merchant day, by share of turnover in the reconciliation scope: 75.9% matched, 12.6% awaited a statement, 0.1% differed in money, 1.3% differed in facts and 10.1% had nothing to reconcile against. That day produced 809 discrepancies to review. Payments awaiting a statement are not discrepancies. They stay open until the provider’s statement covers their hour. Naming each outcome separately keeps false claims out and real gaps visible.
How to spot it
- Ask what share of payments your process confirms against a statement, not only finds.
- Check whether “not found” is split into awaiting, missing and unverifiable.
- Pick one provider and trace ten payments through log, callback and statement.
Related terms
Three-way reconciliation · Two-way reconciliation · Match rate · Discrepancy queue · Multi-provider reconciliation guide
Try it on one day of your data
One day of your data, reconciled, and the report stays with you whether or not you continue.
Updated