Guide · updated 2026-11-04
Reconciliation: proving nothing was lost
Row counts and totals that show your cleaning kept every record accounted for.
The basic equation
Input rows = clean rows + exception rows + rows filtered by a declared scope rule.
Totals too
Compare sums of amounts before and after, per currency. A join or dedup that changes totals needs an explanation.
Put it in the handoff
A small reconciliation table at the top of your report lets reviewers trust the rest.