Business analysis glossary
Data Reconciliation
What it is
Data reconciliation compares data between two sources to confirm they agree, such as record counts, totals and key values after a migration, between two systems that exchange data, or between a report and the source system. Differences are listed and investigated.
Why it matters
Reconciliation is how teams prove that data moved or calculated correctly. Auditors and finance teams rely on it. Analysts design reconciliation rules for migrations and interfaces, decide acceptable tolerances with the business and investigate breaks until the cause is explained.
Example
After the vendor data migration, the analyst reconciles the old and new systems: 5,212 vendors in both, total outstanding payables equal to the paisa and a sample of fifty records compared field by field. Two records differ in the bank account field, and both trace to a known cleansing rule.