Steps

  1. Record source and target field meanings, types, transformation rules and approved versions.

  2. Enter comparable totals for the same population and cutoff. Set owner-approved tolerance for each check.

  3. Review calculated differences and failed assertions. Matching totals do not prove all individual records are correct.

  4. Record material exceptions, correction evidence and business disposition. Retain final acceptance separately from test execution.

Synthetic example

Synthetic source balance 1,000,000 and target 999,950 differ by -50 against tolerance 0, so the check fails. A count check of 1,000 against 1,000 passes. Both results are needed; the passing count does not resolve the balance difference.

Scope

The workbook compares supplied totals; it does not query databases or certify migration completeness. Field-level and event tests remain necessary.