Free TimeTrex review tool
Trace duplicate-looking time entries before requesting a change. Open the matching review path, compare the source and destination, then prepare an evidence note for the responsible reviewer.
For payroll and timekeeping teams. Bring anonymous record references, the source shift, report or import settings, and the destination result. This tool guides a review; it does not calculate pay or change records.
1 · Choose the closest pattern
Start where the rows first appear twice. You can open more than one path if the evidence changes.
Compare record IDs, report grouping and the layer being displayed. A timecard screen and an export may each show the same source shift; seeing it twice is not evidence that payroll counted it twice.
Check: Trace that source reference into the destination time or payroll result. Is there one represented work duration, or more than one separately included duration?
Review outcome: If the same source is only displayed twice and the destination includes it once, record “repeated display verified.” Keep the report references. Do not remove a source punch to tidy a report.
If you cannot trace the destination, use route 4. If separate destination records represent the same source work twice, use route 3.
Find the parent shift or source duration and the meaning of each child row. Confirm the rows are disjoint duration allocations in the same unit, rather than repeated full-shift display values.
Check: Add only comparable allocation durations and reconcile them to the parent. Check whether payroll uses the parent or the child durations; ensure it is not adding both layers.
Review outcome: If documented child allocations reconcile and the destination represents the source work once, record “allocation reconciled.” Different job labels alone do not prove the split is correct.
If allocations exceed the parent, leave a gap, overlap, or use unclear units, record the mismatch and ask the timekeeping/payroll owner to investigate. Do not silently prorate it.
Compare source record reference, actual work interval, employee reference, import batch and destination record IDs. A repeated-looking timestamp alone is not a sufficient key.
Check: Confirm that both destination records contribute the same source work duration to the result. Rule out legitimate allocations, separate work episodes and different earning-code layers.
Review outcome: When evidence supports duplicated work duration, record “possible duplicate for authorized correction,” list both destination IDs and assign the correction owner. This tool does not delete or approve anything.
Retain the original evidence. After the authorized change, reopen the affected person/period result and verify the intended source work is represented once. Check related allocations and totals again.
Different earning codes can describe different pay components for the same work. Overnight boundaries, time zones and separate work episodes can also produce similar-looking rows.
Check: Identify each row’s unit and meaning before adding hours. Do not add base-hour and premium-hour quantities as if they were automatically distinct work time. Ask the configured pay-rule owner to explain the treatment.
Review outcome: Record “distinct meaning verified” only when the source and destination evidence explains the rows. Otherwise record “unresolved—evidence needed,” with an owner and the specific missing check.
A roster, matching amount or similar name does not establish actual work. Preserve both records while the responsible reviewer resolves the facts. Do not infer zero hours or authorize a pay reduction from an unresolved flag.
Worked comparison · fictional records
Both examples start with one verified source shift of 8.00 work hours. All figures below are illustrative duration hours; no breaks, rates, premiums or pay rules are being calculated.
Two disjoint allocation rows: Job A, 4.00 hours; Job B, 4.00 hours. They share the same source shift.
4.00 + 4.00 = 8.00 h
The destination represents 8.00 work hours once. After verifying the parent/child relationship and destination treatment, use route 2: allocation reconciled.
Two destination records each contribute the same source shift’s full 8.00 work hours. A retry used a second destination ID.
8.00 + 8.00 = 16.00 h
The represented work exceeds the verified source by 8.00 hours. After ruling out distinct meanings, use route 3 and send the evidence for authorized correction.
Sample handoff: Case C-17 · source S-8, 8.00 work hours · destination D-41 and D-57 each include S-8 as 8.00 work hours · same source batch retried · possible duplicate for authorized correction · payroll owner to review the two IDs and verify the affected result after any approved change.
This is a qualitative record-lineage review, not duplicate detection software. It uses no match score or invented tolerance. Equal labels, amounts or timestamps do not establish identity, and a difference does not prove separate work. Stable source and destination references are preferred; if they are unavailable, obtain the responsible owner’s explanation and leave the finding unresolved until supported.
The numerical examples use simple duration sums, with two decimal places shown only for readability. They assume disjoint allocations in A and the same duration counted twice in B. Do not apply those sums across unlike earning codes or use them to determine wages owed.
For covered nonexempt workers in the United States, Department of Labor guidance includes daily and workweek hours among required records and describes complete, accurate timekeeping. See DOL Fact Sheet #21 (revised July 2008; checked November 5, 2026). The four review routes are an independent operational method, not a DOL rule or a complete statement of recordkeeping requirements. Other jurisdictions and pay rules require separate review.
Use the Payroll Import Validation guide when the issue involves a file or retry. Use the Timesheet Correction Policy guide for an authorized correction and audit trail. Keep the investigation note with your internal case reference.
Disclaimer: …
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.