NR4Switch template

Back to Non-resident withholding

In development · launch targeted November–December 2026

NR4 · Amounts paid or credited to non-residents

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.

  • Set number of recipients button inserts or deletes rows on every per-recipient tab
  • Monthly remittance register whose total becomes NR4 Summary line 82
  • Treaty reference rates for ten countries shown beside the rate the preparer applies
    Zoom 80%
    fx

    Loading preview…

    Browse every worksheet in the template explorer.

    75%

    Loading preview…

    Visual preview of the fictional sample. No formulas, macros or client data are sent to the browser.

    CRA forms this workbook prepares

    Information slips 2

    • NR4Statement of Amounts Paid or Credited to Non-Residents of Canada
    • NR4SUMReturn of Amounts Paid or Credited to Non-Residents of Canada

    From the Template column of the CRA forms index.

    What the workbook covers

    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.

    • Prior year Export
    • Fill in Questionnaire, Recipients, Withholding, Remittances, NR4 Summary
    • Review Summary, Slip View, Prior Year, Checks
    • Taxprep Import Map, Import
    • Reference Rates, Notes
    Scope boundaries

    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.

    Edition, price and licence

    In-house

    CAD $129

    One entity and its corporate group.

    A 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.