DTR CHECK: catching payroll errors before payday
A repeatable check that compares each employee's DTR against the corrected biometric printout. It lists every mismatch, with the cause and the hours at stake.
Demo built on fake data. No real employees or company records.The problem
Payroll runs on the DTR. The biometric is the true record. When the two disagree, someone gets paid wrong.
I have seen this in real payroll. Two DTR pages were missing from a biometric upload. Fifteen people were affected. They were paid on the next payroll, after an incident report and a lot of follow-up.
Checking page by page is slow and easy to get wrong. So I built a check that does not skip anything.
What I built
I trigger it with two words: DTR CHECK. I give it the DTR and the corrected biometric for one pay period. It returns one report.
- It compares page counts and headcount first. A missing employee shows up here.
- It matches every employee, day by day, on Time In, Time Out and hours.
- It re-adds each daily column and compares it with the printed total.
- It names the cause of each issue, not only the changed total.
- It lists the fix needed before payroll is released.
The test
I made a sample pay period: Oct 11–25, 2026, payday Oct 30. Ten employees, management and staff. I planted six errors and ran the check without looking at the answer key.
| Issue | Employee | What the check found | Hours to fix |
|---|---|---|---|
| Missing employee | E010 | Not in the DTR at all. Biometric shows 10 days. | +81.93 |
| Missing log | E003 | Oct 14: no Time Out. Biometric has 17:09. | +8.13 |
| Missing log | E008 | Oct 20: no Time In. Biometric has 08:04. | +7.93 |
| Time mismatch | E002 | Oct 13: Time Out 17:05 on DTR, 19:10 on biometric. | +2.08 |
| Time mismatch | E005 | Oct 16: Time In 08:45 on DTR, 07:55 on biometric. | +0.83 |
| Total mismatch | E007 | Daily logs match. Printed total is 79.76. Correct total is 81.76. | +2.00 |
Four employees had no issues and were cleared. DTR grand total: 719.53 hrs. Biometric: 822.43 hrs.
Result
All six errors were found. Nothing was flagged by mistake. The report opens with the page-count difference, because that points to the biggest problem.
The last error is the one people miss. Every daily row was right. Only the printed total was wrong. The check re-adds the rows, so it catches this.
What this shows about how I work
Payroll side
- Biometric is the source of truth.
- Checks run before payday, not after.
- Each issue has a cause and a fix.
Systems side
- One trigger phrase, same steps every period.
- Tested on a known answer key.
- Easy to adjust for your cutoffs and rules.
Want this for your payroll?
I can set up a check like this around your cutoffs, your timekeeping files and your approval steps.