When to use Compare & reconcile data?
Central workspace for two CSV/Excel files: compare versions, enrich A with B, or reconcile records despite differences. Reconcile remains free for exact/fuzzy keys and adds Pro multi-criteria rules, ambiguity handling, 1→N/N→1 and reports.
- Compare two extracts then enrich the new version without reloading files
- Reconcile invoices and payments with amount/date tolerances
- Review two reference datasets and clearly document exceptions