Validation checklist

Quality checks before handoff

The final workbook is checked at field, record, and summary levels.

Raw row count reconciles
Raw rows plus intentionally excluded rows equal the delivered total.Duplicate logic reviewed
Each duplicate candidate includes the fields that caused the match.Dates are typed values
Dates sort chronologically and are not stored as decorative text.Contact formats pass
Email and phone formats are consistent or visibly flagged.Controlled values pass
Status and category fields use only approved choices.Manual check completed
At least ten records were compared between raw and cleaned sheets.Formula scan passes
No #REF!, #VALUE!, #DIV/0!, #NAME?, or #N/A errors remain.