Save time
164fields to Taxprep
One button writes them to the CSV that Taxprep imports. Of these, 158 carry an amount or an answer and 6 are zeros. Last year’s export, pasted once, loads 133 prior-year fields.
Payroll
From payroll records to reconciled slips. 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.
v2.1 · 2026
| Number of T4 slips | 8 |
|---|---|
| T4 employment income | 471,700 |
| Income tax deducted (federal) | 56,815 |
Inputs and results require review.
Inside the guide
Selected pages from the English user guide. Open an image to zoom. The complete PDF accompanies the purchased workbook. These guide pages and the workbook demonstration show the v2.1 edition.
The inventory includes calculations, manual-entry schedules and references. A listed form or tab does not mean every line is automated. Read the scope and exclusions for functional coverage.
From the Template column of the CRA forms index.
22% entered · 78% formula-derived & rollover
Measured from the sample
T4 / RL-1 sample · fictional data · v2.1 · 2026. Counted from the sample’s cells by the workbook’s own colour legend.
Save time
164fields to Taxprep
One button writes them to the CSV that Taxprep imports. Of these, 158 carry an amount or an answer and 6 are zeros. Last year’s export, pasted once, loads 133 prior-year fields.
Type less
22%of cells entered
Of the colour-coded cells, only the yellow ones are entered; the other 78% are calculated or carried from last year.
Better control
118checks
All on one tab, each stating what it tests and how serious a failure is. The list is worked until no ERROR remains.
84 must clear before filing · 32 to review · 2 notes
Standard and searchable
26tabs in 5 numbered groups
Filed under the same numbered groups, with the same Questionnaire, Checks, Import and Notes tabs, as every workbook previewed here. Labels, checks and notes are plain text in the same places, so next year’s preparer, a reviewer or an AI assistant given the file can search them.
Selected working papers, grouped by preparation area.
| Slips & summaries | T4 · RL-1 · Supported boxes & summaries |
|---|---|
| Benefits | Loans · Insurance · Automobiles · Security options |
| Reconciliation | Contributions · Remittances · General ledger |
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.
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.
CAD $179
One entity and its corporate group.
BuyOne firm preparing returns for external clients.
Request a practice quoteSeveral firms, named in the licence.
Request an enterprise quoteA perpetual licence for the purchased edition. A new tax year is a separate edition. Full licence
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.
Yes. The .xlsm buttons resize the repeated row blocks to the counts entered, hide the tabs marked not applicable (and show them again) and write the Import tab to a CSV file beside the workbook. The edition guide identifies the available buttons. In the v2.1 samples shown here, review controls also refresh status and retain review, export and filing evidence inside the workbook. Build reviewer package requires a saved local file and the separately configured companion for the same edition, explicitly selected by the user. It creates a private/taxworkbooks-review-request-… folder containing request.json (workbook path, edition and local time), then requests a companion launch. A launch request does not create a reviewer package: the user must choose the destination and options, then build it in the companion. Its Python, Tk and platform requirements are described in the scope and review guide. This local handoff does not upload data or file a return; each edition is tested natively on its platform before release.
In this workbook the macros act on the local file only: they resize the repeated row blocks to the counts entered, hide the tabs marked not applicable (and show them again) and write the Import tab to a CSV file beside the workbook. The CSV export uses one system object, WScript.Shell on Windows, only to find the Desktop folder when the CSV cannot be written beside the workbook. The review controls also refresh review status inside the workbook, and Build reviewer package starts the separately installed reviewer companion on the same computer, through cmd.exe on Windows or an AppleScript task on Mac; nothing is uploaded. The macros make no external connection and the VBA project is left open for inspection. A file received by email or downloaded opens in Protected View until it is unblocked (file Properties, Unblock) or placed in a Trusted Location; with macros disabled, every schedule, check and formula still works and only the buttons, the review refresh and the companion launch are inactive.
Sheets are supplied without active protection. Cell lock flags allow protection to be enabled when needed.
Minor corrections to the purchased edition are included under the terms of sale. A new tax year is a separate edition.
Yes, online; the price shown is for the in-house licence. Buy opens Stripe’s payment page, the contract documents are at the foot of this page, and the workbook follows by email.
T4 / RL-1 · In-house licence · CAD $179 · No sales tax is charged.
Français : Conditions d’utilisation · Licence · Politique de soutien · Politique de remboursement · Politique de confidentialité · Télécharger l’ensemble (zip)
English version: Terms of Use · Licence · Support Policy · Refund Policy · Privacy Policy
Sold by Maxime Blais, operating as TaxWorkbooks · [email protected]