Compare two payroll exports, find unusual changes in gross pay and hours, and create a clear review list before payroll closes.
Free · No sign-up · Browser-based calculationsUse employee reference IDs instead of names or sensitive identifiers. This analyzer does not upload your files or save your entries. The surrounding website may use its own analytics; use only data approved for this environment.
Required columns: employee_id,gross_pay. Optional: total_hours,overtime_hours,department. Column order does not matter. Headers are case-insensitive; spaces and underscores are interchangeable. Other columns are ignored.
One row per employee per period. Combine payroll lines in your approved system first; duplicate IDs are rejected. Match IDs exactly, including leading zeros and letter case. Total hours must include overtime hours. Blank optional hours remain unknown; enter 0 only when confirmed.
Use comma-delimited UTF-8 CSV, a decimal point, and at most two decimal places. Quote fields containing commas. Thousands separators must use groups of three. Negative gross adjustments are accepted; negative hours are rejected. Limit: 1 MB and 5,000 employee rows per period. Remove bank, tax and personal identifiers before import.
These are adjustable review preferences, not legal limits or industry benchmarks. Gross pay is flagged when either the amount or percentage threshold is met. Hours are flagged separately. Zero means flag any nonzero change.
The three contributions reconcile to the total gross change. An ID found in only one export does not establish a hire, termination or payroll error.
| Employee / scope | Previous gross | Current gross | Gross change | Change % | Hours change | OT change | Review signals | Review record |
|---|
Review marks and notes stay in this view until you analyze again, clear data or leave. Export before leaving. A reviewed mark is your note, not payroll approval.
Gross change = current gross − previous gross. For IDs in both periods, percent change = gross change ÷ absolute previous gross × 100. A zero previous gross with a nonzero current gross is shown as “Zero base” and always flagged. Two zero gross values have 0% change.
Gross values are added as integer cents. Missing-period amounts contribute zero to the reconciliation but display as “Absent,” preserving the difference between an absent record and a zero payment. Hours are compared only when both values exist. Overtime must be a subset of total hours when both are provided. Display values are rounded to two decimal places.
Review signals identify items to investigate. They cannot establish correct wages, tax treatment, fraud, compliance or a payroll error. This tool does not calculate net pay, overtime entitlement, tax, contractual rates or currency conversion.
A bonus, overtime increase, adjustment or an ID appearing only in the current export can outweigh unchanged employee pay. The reconciliation separates changes for matched IDs from amounts appearing in only one export.
Compare aligned periods or prepare normalized exports in your approved system. This tool does not adjust for workdays or period length. A normal pay increase can otherwise appear to be an exception.
No. It can reflect an ID mismatch, payroll group, leave, a zero-pay period, a filter or a change in employment. Review the original records before drawing a conclusion.
Connect this review with TimeTrex time and attendance and payroll software to investigate the source records behind a change.
Disclaimer: This analyzer compares user-supplied payroll exports for review purposes only. A flagged change does not establish a payroll error, correct pay, legal compliance or approval. Verify the source records, employee IDs, period scope, currency and applicable rules before making any payroll change. Thresholds are user-defined review preferences. Do not enter sensitive personal, bank or tax identifiers. Export any review notes you need to retain before leaving the page.
Disclaimer: The content provided on this webpage is for informational purposes only and is not intended to be a substitute for professional advice. While we strive to ensure the accuracy and timeliness of the information presented here, the details may change over time or vary in different jurisdictions. Therefore, we do not guarantee the completeness, reliability, or absolute accuracy of this information. The information on this page should not be used as a basis for making legal, financial, or any other key decisions. We strongly advise consulting with a qualified professional or expert in the relevant field for specific advice, guidance, or services. By using this webpage, you acknowledge that the information is offered “as is” and that we are not liable for any errors, omissions, or inaccuracies in the content, nor for any actions taken based on the information provided. We shall not be held liable for any direct, indirect, incidental, consequential, or punitive damages arising out of your access to, use of, or reliance on any content on this page.
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.