Reconciliation

What it is

Reconciliation compares independent records and surfaces discrepancies.

When to use it

Detect missing, duplicated, or inconsistent settlements.

Syntax

internal total by currency <-> provider total by currency

Example

SELECT currency, SUM(amount_cents) AS settled_cents
FROM transactions
WHERE status = 'settled' AND settled_at >= ? AND settled_at < ?
GROUP BY currency;
-- Match individual external references as well as totals.

Common mistakes

Equal totals can hide offsetting errors; use stable cutoffs, time zones, and exception review.

Related topics