Compare the annual payroll register with the T4 slip and Summary totals, then tie the Summary to CRA remittances for the same account and calendar year. The Excel workbook separates differences in individual boxes from differences in cash paid.
Use CAD amounts for one calendar year from 2024 onward. Keep employee names and identifiers in your approved payroll records.
The workbook shows T4 less register for each row and line 80 less line 82 for the account. A missing input keeps the review open. Enter zero when your source confirms that amount is zero.
Use Account tie-out for your records and Worked example to see a difference that survives a cash match.
A fictional employer's register shows $15,500 in income tax deducted. The draft T4 slips total $15,400 in Box 22. Other rows match. The employee and employer CPP, CPP2 and EI amounts total $10,880, so the draft Summary reports $26,280 on line 80.
Keep the filing review open and trace the Box 22 difference to payroll adjustments or the slip export. Verify which source needs correction. If the draft tax total increases by $100 and credited payments stay the same, the difference becomes $100 to investigate.
Use the applicable employee and employer CPP, CPP2 and EI amounts plus income tax deducted. For 2024 and later, add Summary lines 16A and 27A when applicable. Employment income, insurable and pensionable earnings, and slip count are separate tie-outs. Confirm the mapping for your year in the CRA T4 Slip and Summary guide.
Check account, year, timing and transfers before recording a correction. A positive line 80 less line 82 difference points to line 86. A negative difference calls for review of line 84 and the CRA conditions, including whether another return applies to that account. Use the CRA Summary guidance to confirm the treatment.
This is a federal reconciliation for standard CPP, CPP2, EI and income tax. Route Québec provincial deductions, QPP, QPIP, amended filings, transfers and other special cases to a separate review. Preserve the reports, difference explanation, correction evidence and reviewer sign-off. The workbook rounds comparisons to cents and uses whole numbers for slip counts.
Disclaimer: This workbook supports a standard federal T4 and CRA remittance reconciliation. It does not calculate individual deductions, prepare a filing, or resolve special cases. 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.