T106Switch template

Back to International reporting

In development · launch targeted November–December 2026

T106 · Information return of non-arm's length transactions with non-residents

Organizes the T106 Summary and slips around one row per non-resident, ties Part IV loans and investments to the trial balance, and compares each slip with last year's.

  • One button resizes every per-non-resident tab together, from 2 to 500 rows
  • GL Recon ties intercompany loans and investments on the trial balance to Part IV
  • Last year's Taxprep export drives a prior-year comparison for each non-resident, matched by name
    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

    Corporations 1

    • T106Information Return of Non-Arm's Length Transactions with Non-Residents (2025 and later tax years) T106 Summary Form

    From the Template column of the CRA forms index.

    What the workbook covers

    The Questionnaire covers the T106 Summary (identification, the summary questions, non-monetary or nil consideration and certification) and which slip Parts apply. Non-Residents, Transactions and Balances & Derivatives hold slip Parts II, III and IV to VI on shared rows, one per non-resident, and Slip Totals derives boxes A to I, whose total drives the filing test on Summary. Summary adds a filing calendar and a s.162(7) late-filing estimate, while Slip View, T106 Summary and Prior Year set this year's figures beside last year's.

    • Prior year Export
    • Fill in Questionnaire, Non-Residents, Transactions, Balances & Derivatives, TB, GL Recon
    • Review Summary, Slip Totals, Slip View, T106 Summary, Prior Year, Checks, Sign-Off
    • Taxprep Import Map, Import
    • Reference Rates, Notes
    Scope boundaries

    The workbook does not file the return; it prepares the working papers and a CSV for Taxprep's Import Data. It does not replace contemporaneous transfer-pricing documentation under subsection 247(4); it records only the slip's answer on whether that documentation was prepared or obtained.

    Edition, price and licence

    In-house

    CAD $179

    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.