Data migration reconciliation

Validate structured pre- and post-migration exports record by record.

Use Generic Record when you have structured exports from before and after a migration and need to verify which records correspond, what changed and what exists on only one side.

How to use ReconLoom for migration validation

  1. Import.Choose the supported pre-migration and post-migration CSV/XLS/XLSX exports.
  2. Map.Define the identity fields that identify the same business record on each side.
  3. Configure.Select typed comparison fields that should be checked after identity is established.
  4. Reconcile & Review.Inspect exact matches, changed records, conflicts, invalid records and records present on only one side.
  5. Export.Generate the supported local comparison output for further review or evidence.

Record identity

Customer ID, account ID, SKU, employee ID or another key that genuinely represents the same record in both exports.

Comparison fields

Status, category, amount-like text/number fields, dates or other supported typed fields selected deliberately.

Migration evidence

Changed, missing, duplicate/conflict and invalid states stay distinct so they can be investigated.

Related: Generic Record · Inventory reconciliation · All use cases