Payroll Integration Acceptance Test Workbook

Test a payroll import before go-live

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.

Run the acceptance tests

Use the Run tests tab for your observed results. Open Worked example to see how matching totals can hide an error.

Download the Excel workbook

XLSX with six test cases and a filled example. Use synthetic records.

Read the acceptance decision

Hold
A test failed or an input is invalid. Fix it and rerun the affected cases.
Incomplete
At least one test still needs observations or evidence.
Ready for payroll review
All six tests pass. Have the payroll owner review the evidence before deciding whether to go live.

Gather the mapping and the receiving records

  1. Agree on the contract. Record the legal entity and pay group, test environment, currency, closed pay period, field formats, earning-code map and the rule for choosing a rate by work date. Use a synthetic worker crosswalk keyed by entity and worker ID. Keep IDs such as 0007 as text.
  2. Run each case as written. Start each case in a clean test batch, except where a retry or correction references an earlier batch. Record the source transaction IDs before sending and keep the import receipt, rejects and receiving payroll register.
  3. Check more than the batch totals. Tie distinct accepted earning lines by transaction, worker, work date and earning code. Compare the number of accepted rows, decimal hours, gross currency and unresolved rejects for the same test scope. Enter zero for a confirmed absence and leave unknowns blank.
  4. Record proof and close failures. Mark each row Verified or Mismatch after checking the evidence column. Enter an artifact reference, such as a test batch ID and register tab. Assign an owner to each failure and capture the correction and rerun before closing it.

Worked example: the totals match and the test fails

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.

Batch comparison
2 lines, 16.00 hours, USD 352.00 on both sides.
Receiving lines
0011 receives USD 192.00 (+32.00). 0012 receives USD 160.00 (−32.00).
Workbook decision
Hold. Mark T06 Mismatch, trace the receiving worker mapping and rerun the same two rows after correction.
What the six tests cover
  • Identity and format. Verify leading zeroes, decimal hours, earning codes and gross dollars against the receiving lines.
  • Effective dates. Compare a line immediately before a rate change with one on the effective date. The sample uses USD 20.00 then USD 22.00 for four hours each, yielding USD 168.00.
  • Retry. Replay an unchanged batch after a simulated acknowledgement loss. Verify each accepted transaction appears once and totals stay at 2 rows, 15.50 hours and USD 317.50.
  • Reject. Send one unmapped earning code. Confirm one specific open rejection and zero paid rows.
  • Correction. Resubmit the corrected row using the agreed method. Expect one paid line, USD 60.00 gross and zero unresolved rejects for that transaction. Keep the original reject record.
  • Offsetting variance. Compare the two worker lines even when the batch totals match.
Comparison rules and limitations

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.

Found this payroll integration workbook useful? Bookmark and share it.

Facebook
X
LinkedIn
Email
WhatsApp
Print
Illustration of timesheet rows transferring to a payroll register under a magnifying glass

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

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand