Save time
722fields to Taxprep
One button writes them to the CSV that Taxprep imports. Of these, 712 carry an amount or an answer and 10 are zeros. Last year’s export, pasted once, loads 87 prior-year fields.
Non-resident withholding
From non-resident payments to reviewed slips. An NR4 working-paper file that takes payments to non-residents through withholding and remittances to supported slips, the summary and a CSV for Taxprep.
v2.0 · 2025
| Description | Current year |
|---|---|
| Materiality, lines 18, 26, 30 — the larger of the floor and the share of line 18 (Rates) | 60,980 |
| Materiality, lines 22, 28, 32, 82 — the larger of the floor and the share of line 22 (Rates) | 9,792 |
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.
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.
9% entered · 91% formula-derived & rollover
Measured from the sample
NR4 sample · fictional data · v2.0 · 2025. Counted from the sample’s cells by the workbook’s own colour legend.
Save time
722fields to Taxprep
One button writes them to the CSV that Taxprep imports. Of these, 712 carry an amount or an answer and 10 are zeros. Last year’s export, pasted once, loads 87 prior-year fields.
Type less
9%of cells entered
Of the colour-coded cells, only the yellow ones are entered; the other 91% are calculated or carried from last year.
Better control
41checks
All on one tab, each stating what it tests and how serious a failure is. The list is worked until no ERROR remains.
17 must clear before filing · 21 to review · 3 notes
Standard and searchable
17tabs 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 & summary | NR4 slips · NR4 Summary |
|---|---|
| Withholding | Payment records · Applied rates · Treaty references |
| Reconciliation | Monthly remittances · Prior-year comparison |
The workbook prepares NR4 slips from one row per slip, with up to two income lines each, and the NR4 Summary, including amounts reported on forms NR601 or NR602. Withholding recomputes each line's tax as a memo from the rate the preparer enters, and Slip View and a Prior Year matched on the box 13 tax identification number support review. The file ships with 25 recipient rows, and the Export Import to CSV button writes the file Taxprep imports.
Values are for the 2025 NR4 season, amounts paid or credited in calendar 2025; another year in box 10 reads WARN.
The workbook determines no Part XIII rate: the convention, the country, the income code and any exemption decide it, so the preparer's rate is recomputed only as a memo and never judged. The treaty table on Rates is reference only and is never enforced.
CAD $129
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 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 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 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.
NR4 · In-house licence · CAD $129 · 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]