Three-Way Reconciliation

Overview

Three-way reconciliation compares three independent but related data sets to confirm that a financial process is complete and accurate. In payments, common combinations include order or invoice records, processor transactions, and bank or settlement entries. An order without a payment may be unpaid, a provider payment without a bank entry may be unsettled, and a bank entry without a known transaction may be unidentified cash.

Records are matched using stable identifiers, amount, currency or asset, date, customer or merchant, and provider references. The process should support one-to-many and many-to-one relationships, such as one settlement deposit covering many transactions. Risk analysis should cover missing records, false matches, wrong cutoffs, inconsistent currencies, hidden exceptions, and unsupported manual corrections. The operating record should identify the source population, counterpart data, matching rule, cutoff, amount or value, tolerance, exception reason, owner, and resolution evidence.

Three-Way Reconciliation should remain distinct from Four-Way Reconciliation and Reconciliation, because each can represent a different stage, record, control, or financial outcome. Matching only aggregate totals is not sufficient.

Exceptions reveal different problems depending on which source is missing or disagrees. Important failure modes include missing records, duplicate matches, timing differences, hidden fees, currency mismatches, stale files, and adjustments that force balances to agree without explaining the cause.

Controls should keep original source records immutable, use stable match keys, explain many-to-one or one-to-many relationships, and route unresolved differences to an aged exception queue. For Three-Way Reconciliation, the authoritative record and completion rule should be documented before any irreversible operational, customer, or accounting action is released.