Table Reconciliation
Full instructions and common questions
Table Reconciliation
Reconcile counts, totals and differences by a shared order or business key. Identify left-only, right-only, amount and row-count exceptions, review grouped duplicate keys, set absolute tolerance and export a complete CSV report.
How to use
- Choose one CSV, TSV, JSON or XLSX file and worksheet on each side, or load the reconciliation example.
- Select a shared business key and amount field, then set an absolute tolerance in the same units as the amount.
- Reconcile and inspect differences, row counts and duplicate-key notes. Difference means right minus left; duplicate records require business review.
- Disable “Show exceptions only” to inspect every key and export the complete report. Saved rules retain fields and tolerance; verify mappings when restoring them.
Try an example
In the sample, 001 matches. For 002, left amounts 50+20 compare with right 70.01: within 0.02 tolerance, but row counts differ. 003 is left-only and 004 right-only. Leading zeros remain intact.
Limits and privacy
One file per side, up to 20 MB. Keys cannot be blank; missing or nonnumeric amounts are flagged as invalid. Duplicate-key values are grouped with review notes. Results do not certify accounting agreement, duplicate payment or transaction authenticity. Align currencies and units first.
Common questions
Why is an item exceptional despite being within tolerance?
Its row counts may differ. Counts are checked alongside totals so similar amounts do not hide missing or repeated records.
Does export include only the visible exceptions?
No. The complete report includes every business key; the exceptions checkbox changes the preview only.