Run six synthetic tests in a sandbox. Compare the receiving payroll register with the expected worker IDs, work dates, hours and gross pay, then record which failures still block acceptance.
Use the Run tests tab for your observed results. Open Worked example to see how matching totals can hide an error.
Download the Excel workbookXLSX with six test cases and a filled example. Use synthetic records.
0007 as text.In the synthetic USD run, worker 0011 has 8.00 hours at USD 20.00, so the expected line is USD 160.00. Worker 0012 has 8.00 hours at USD 24.00, so the expected line is USD 192.00.
Use one pay group, one period and one currency per copy. The fictional USD example covers Nov 9–15, 2026. Use a separate CAD run where appropriate. Gross pay means the amount on the accepted earning lines before deductions. Rows and rejects are nonnegative whole counts. Hours are decimal hours and gross is in the stated currency. Normalize both sources to two decimals using the same agreed line-level rounding, then compare exact values. The workbook applies zero variance at that precision. Separate negative adjustments, voids and additional currencies into their own test cases with explicit acceptance rules.
The sample addresses the handoff from approved time to receiving payroll. Review taxes, deductions, net pay, funding and filings separately. Verify formats, retries, correction behavior and effective-date rules in the chosen implementation.
TimeTrex describes API and flat-file approaches in its software integrations overview. See TimeTrex Setup & Support for configuration assistance and ADP Canada’s switching guide for provider transition planning. The test data and acceptance criteria above are illustrative.
Disclaimer: This workbook uses synthetic data to test payroll import behavior. Its sample rates, dates, codes and acceptance checks are for illustration. Confirm your pay rules, mapping, currency and test criteria for the implementation. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.
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.