Skip to content

Data validation report ​

Template: Enter aggregate metrics rather than personal or sensitive row-level values.

FieldValue
Dataset / batch ID[Identifier]
Source / target[Systems]
Run date[YYYY-MM-DD]
Mapping / rule version[Version]
Validator[Name or system]

1. Results summary ​

MetricResult
Total input records[Count]
Passed records[Count]
Warning records[Count]
Rejected records[Count]
Duplicate records[Count]
Required-field completeness[Percent]

Reconciliation check: [Explain whether totals balance; warning categories may overlap.]

2. Rules tested ​

Rule IDField / scopeExpected conditionSeverityFailures
[VAL-01][Record ID][Unique and nonblank][Error][Count]
[VAL-02][Date field][Valid YYYY-MM-DD][Warning][Count]

3. Exceptions and corrective actions ​

IssueAffected countOwnerResolutionStatus
[Missing ID][Count][Role][Remap / request source correction][Open]

4. Release decision ​

  • [ ] Critical validation failures resolved or documented
  • [ ] Sample transformed output inspected
  • [ ] Totals reconciled against source
  • [ ] Approved exception list retained in secure location
  • [ ] Destination import test completed

Decision: [Ready / Ready with approved exceptions / Not ready]

Approved by: [Name and date]

Smarter Data | Stronger HR | Seamless Payroll