Universal Data Reconciliation Checker

Schema & Settings

This session's fields, in order. Every field is auto-checked (included in the crosscheck) by default. Rename a field, mark the one Key/ID column used to match records, set its Type for smarter comparison, or untick a field to leave it out of the crosscheck — and tick it again any time to bring it back in. Changes apply to Working Data and Master File alike.

The Key/ID field is used only to match rows between files — it's never compared or auto-corrected. Deleting a field removes it from every record. Field Type controls comparison: Number and Date fields tolerate formatting differences (e.g. "1,000" = "1000", "3/4/2026" = "2026-03-04") that don't change the underlying value; Text fields compare literal (spacing-trimmed) characters.

Import CSV

Any column headers work. Known fields are auto-matched by name; unrecognized columns are added as new fields and auto-checked as soon as both sides carry data. Review the mapping and sample rows before importing.

Merge Duplicate Keys

Pick which row to keep for each duplicated key; the others are deleted.

Row Comparison

Every field, aligned side-by-side, with character-level differences highlighted.

Export Builder

Pick which rows and columns go out, put them in the exact sequence you want, choose a print style, then generate a ready-to-share Print/PDF, Word, or Excel file.

Data Quality Rules

Define per-field checks that run independently of the Master File crosscheck — useful for catching blanks or malformed values in either file.