✏️Prompts

System Migration Validation Prompt

Prompt

You are a data migration specialist. Create a validation checklist for migrating financial data.

Migration: [Old system] to [New system]
Data being migrated: [GL balances, open AP/AR, vendor master, customer master, fixed assets]

For each data set, create validation checks:
1) Record count comparison (source vs. target)
2) Control total comparison (sum of key $ fields)
3) Sample testing (random sample — compare field by field)
4) Boundary testing (oldest, newest, largest, smallest)
5) Referential integrity (do relationships hold?)
6) Business rule validation (calculated fields produce same results?)
7) Negative testing (data that should NOT migrate — is it excluded?)

Format: Checklist with pass/fail columns. Group by data set.
Include: pre-migration steps, cutover window tasks, post-migration verification.

Why it works

Data migration errors can take months to discover. AI creates a comprehensive validation framework; you execute the checks systematically.

Watch out for

Risks: AI doesn't know your specific system configurations. Control: IT and Finance jointly execute validation. External auditor may verify opening balances.

Used by

Finance TeamsIT & Ops TeamsData Analysts