Validating and reconciling migrated data

Proving the migration is complete and correct: counts, totals, samples, reconciliation and sign-off.

In this lesson

Counts, totals and samples
Formal reconciliation
Sign-off and hypercare follow-up

Key points

Counts match source; totals match to the naira; owners sample records
Reconcile AR, AP, stock and trial balance against signed legacy reports
Explain, fix or formally accept every difference
Written sign-off per object; escalate, don't silently fix

Real-world example

Stock value after migration was ₦1.8m below the legacy figure. Reconciliation per warehouse showed one warehouse's costs imported in USD into an NGN field. The fix was a corrected file and a re-import in the mock database, documented in the reconciliation pack the auditor later praised.

Questions and answers

Name three totals to reconcile.

Open AR, open AP, stock value (and trial balance).

What happens to an accepted difference?

It's documented and approved formally.

Read the full lesson, worked example and quiz