Four-Way Reconciliation

Overview

Four-way reconciliation compares four related sources for the same financial activity, such as orders or invoices, payment-provider transactions, settlement or bank records, and general-ledger postings. The exact four sources should be named for the implementation. Automated matches need transparent rules and tolerances.

For Four-Way Reconciliation, reliable use requires stable references, balanced postings, currency-aware amounts, booking and value dates, documented account mappings, cutoff discipline, and evidence linking operational events to the general ledger. The operational record should capture source record, counterpart record, matching rule, cutoff, amount, currency or asset, exception reason, and resolution evidence for Four-Way Reconciliation, including the handoff to Three-Way Reconciliation . The operating record should identify the source population, counterpart data, matching rule, cutoff, amount or value, tolerance, exception reason, owner, and resolution evidence.

Four-Way Reconciliation should remain distinct from Three-Way Reconciliation and Reconciliation, because each can represent a different stage, record, control, or financial outcome.

The failure model should include unbalanced postings, wrong accounts, stale exchange rates, duplicate events, missing fees, cutoff mismatches, unexplained suspense, manual changes without evidence, and reconciliation that forces totals to match without finding the cause. 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.

For Four-Way Reconciliation, controls should use approved account mappings, immutable source references, balanced entries, period locks, currency-level reconciliation, and segregation of duties. 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.