In-house
CAD $179
One entity and its corporate group.
In development · launch targeted November–December 2026
T4 / RL-1 · Employment income slips and summaries
A T4 and RL-1 working-paper file that takes the payroll report through benefits, contributions and reconciliations to supported slips, summaries and a CSV for Taxprep.
- Set number of employees button inserts or deletes rows on every per-employee tab
- Taxable benefits valued for employee loans, insurance, private health services plans, automobiles and security options
- Remittances and general ledger reconciled to slip income and CRA and Revenu Québec obligations
CRA forms this workbook prepares
From the Template column of the CRA forms index.
What the workbook covers
The 2026 edition prepares T4 and RL-1 slips from one row per employee, with benefits, security options and approved adjustments carried into Slip Totals, and the T4 Summary and RL-1 Summary, including the health services fund, labour standards and WSDRF contributions. Contributions recomputes CPP, CPP2, QPP, QPP2, EI and QPIP as a memo against the amounts withheld, and Slip View, Taxprep Comparison and a Prior Year matched by SIN support review. The workbook ships with 25 employee rows, and the Export Import to CSV button writes the file Taxprep imports.
The 2026 edition: every payroll contribution, employer contribution and benefit rate on Rates is a 2026 figure with its authority and effective date.
- Prior year Export
- Fill in Questionnaire, Employees, Contributions, Benefit Valuation, Benefits, Automobile, Security Options, Adjustments, T4 Summary, RL-1 Summary, GL Reconciliation, Remittances
- Review Summary, Slip Totals, Slip View, Taxprep Comparison, Prior Year, Checks
- Taxprep Import Map, Import
- Reference Rates, Notes
Scope boundaries
The contribution boxes (CPP, CPP2, QPP, QPP2, EI and QPIP, with their earnings bases) carry no import code: Taxprep calculates them, and the workbook compares its memo with Taxprep's figures pasted back. Summary selections answered Yes are not exported; they are completed in Taxprep.
Edition, price and licence
Practice
Pricing on request.
Request practice pricingEnterprise
Pricing on request.
Request enterprise pricingA perpetual licence for the purchased edition. A new tax year is a separate edition. Full licence
Practical questions
Does the workbook file the return?
No. It prepares and documents the figures; filing takes place in the tax software after the CSV import described on the import and export page.
Does the workbook use macros?
Yes. The .xlsm carries the macros behind its buttons: the tab filter, row sizing where the workbook repeats rows, and the Taxprep CSV. They act on the workbook and write only that CSV, beside it. There are no external links.
Are the formulas protected?
Sheets are supplied without active protection. Cell lock flags allow protection to be enabled when needed.
Which updates are included?
Minor corrections to the purchased edition are included under the terms of sale. A new tax year is a separate edition.
Can the workbook be purchased now?
Not yet. Launch is targeted for November–December 2026; the price shown is the planned in-house licence price.