Corporate & partnership tax

T2 · Corporation income tax return Excel working papers

From source figures to a clearer review. Prior-year Taxprep data, the trial balance and supporting information in one structured workbook for T2, CO-17 and AT1.

Inside the templateFictional sample
T2.xlsm

v3.6 · 2025

Summary

Book net income (GIFI Schedule 125)1,300,000
Net income for income tax purposes (Schedule 1)1,260,000
Taxable income520,000

At a glance

Forms
T2 · 136 CRA forms
Authorities
CRA · Québec CO-17 · Alberta AT1
Software
Excel · Taxprep (CSV)
Edition
2025 tax year · new design

Information flow

Information flow
SourcesPrior-year Taxprep export
SourcesTrial balance & source documents
Manual entry
OptionalCopilot Importation AssistanceMicrosoft License required.Rules guidance
T2 workbookT2 · CO-17 · AT1Linked schedules · Checks · Review notes
TaxprepImport & reconcile

Copilot assistance is optional. Inputs and results require review.

Copilot & the .Rules tab

The .Rules tab describes the workbook’s structure and data-entry conventions. Microsoft Copilot access is separate from the workbook purchase. Copilot-assisted inputs require review.

See it work

    Zoom 80%
    Highlights only cells requiring practitioner input (dimming formulas, links, and prior-year fields).
    fx

    Loading preview…

    Browse every worksheet in the template explorer.

    75%
    Try

    Loading preview…

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

    Inside the guide

    User guide preview

    Selected pages from the English user guide. Open an image to zoom. The complete PDF accompanies the purchased workbook.

    T2 · English user guide, page 1: Cover
    T2 · Cover · page 1 of 29
    T2 · English user guide, page 3: Quick start
    T2 · Quick start · page 3 of 29
    T2 · English user guide, page 12: Diagnostic checks
    T2 · Diagnostic checks · page 12 of 29

    CRA form inventory linked to this 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.

    Corporations 136

    • T2Corporation Income Tax Return
    • T2SHORTT2 Short Return
    • T2SCH100Balance Sheet Information
    • T2SCH101Opening Balance Sheet Information
    • T2SCH125Income Statement Information
    • T2SCH141General Index of Financial Information (GIFI) - Additional Information
    • T2SCH1Net Income (Loss) for Income Tax Purposes
    • T2SCH2Charitable Donations and Gifts
    • T2SCH3Dividends Received, Taxable Dividends Paid, and Part IV Tax Calculation
    • T2SCH4Corporation Loss Continuity and Application
    • T2SCH5Tax Calculation Supplementary - Corporations
    • T2SCH6Summary of Dispositions of Capital Property
    • T2SCH7Aggregate Investment Income and Income Eligible for the Small Business Deduction
    • T2SCH8Capital Cost Allowance (CCA)
    • T2SCH13Continuity of Reserves
    • T2SCH14Miscellaneous Payments to Residents
    • T2SCH15Deferred Income Plans
    • T2SCH16Patronage Dividend Deduction
    • T2SCH18Federal and Provincial or Territorial Capital Gains Refund
    • T2SCH24First-time Filer After Incorporation, Amalgamation or Winding-up of a Subsidiary into a Parent
    • T2SCH27Calculation of Canadian Manufacturing and Processing Profits Deduction
    • T2SCH43Calculation of Parts IV.1 and VI.1 Taxes
    • T2SCH44Non-Arm's Length Transactions
    • T2SCH59Information Return for Non-Qualified Securities
    • T2SCH71Income Inclusion for Corporations that are Members of Single-Tier Partnerships
    • T2SCH72Income Inclusion for Corporations that are Members of Multi-Tier Partnerships
    • T2SCH73Income Inclusion Summary for Corporations that are Members of Partnerships
    • T2SCH88Internet Business Activities
    • T2SCH130Excessive Interest and Financing Expenses Limitation (2023 and later tax years)
    • T2SCH53General Rate Income Pool (GRIP) Calculation
    • T2SCH54Low Rate Income Pool (LRIP) Calculation
    • T2SCH89Request for Capital Dividend Account Balance Verification
    • T2SCH33Taxable Capital Employed in Canada - Large Corporations
    • T2SCH34Taxable Capital Employed in Canada - Financial Institutions
    • T2SCH35Taxable Capital Employed in Canada - Large Insurance Corporations
    • T2SCH38Part VI Tax on Capital of Financial Institutions
    • T2SCH39Agreement Among Related Financial Institutions - Part VI Tax
    • T2SCH45Agreement Respecting Liability for Part VI.1 Tax
    • T2SCH55Part III.1 Tax on Excessive Eligible Dividend Designations
    • T2SCH56Part II.2 Tax on Repurchases of Equity
    • T2SCH67Canada Recovery Dividend
    • T2SCH68Additional Tax on Banks and Life Insurers
    • T2SCH17Credit Union Deductions
    • T2SCH31Investment Tax Credit - Corporations
    • T2SCH42Calculation of Unused Part I Tax Credit
    • T2SCH58Canadian Journalism Labour Tax Credit (2023 and later tax years)
    • T2SCH74Clean Hydrogen Investment Tax Credit
    • T2SCH75Clean Technology Investment Tax Credit
    • T2SCH76Clean Technology Manufacturing Investment Tax Credit
    • T2SCH78Carbon Capture, Utilization, and Storage Investment Tax Credit
    • T2SCH12Resource-Related Deductions
    • T2SCH9Related and Associated Corporations
    • T2SCH11Transactions with Shareholders, Officers or Employees
    • T2SCH23Agreement Among Associated Canadian-Controlled Private Corporations to Allocate the Business Limit
    • T2SCH28Election not to be Associated Through a Third Corporation
    • T2SCH49Agreement Among Associated Canadian-Controlled Private Corporations to Allocate the Expenditure Limit
    • T2SCH50Shareholder Information
    • T2SCH19Non-Resident Shareholder Information
    • T2SCH20Part XIV - Additional Tax on Non-Resident Corporations
    • T2SCH21Federal and Provincial or Territorial Foreign Income Tax Credits and Federal Logging Tax Credit
    • T2SCH22Non-Resident Discretionary Trust
    • T2SCH25Investment in Foreign Affiliates
    • T2SCH29Payments to Non-Residents
    • T2SCH301Newfoundland and Labrador Research and Development Tax Credit
    • T2SCH302Additional Certificate Numbers for the Newfoundland and Labrador Film and Video Industry Tax Credit
    • T2SCH303Newfoundland and Labrador Direct Equity Tax Credit
    • T2SCH304Newfoundland and Labrador Resort Property Investment Tax Credit
    • T2SCH305Newfoundland and Labrador Capital Tax on Financial Institutions
    • T2SCH306Newfoundland and Labrador Capital Tax on Financial Institutions - Agreement among related corporations
    • T2SCH307Newfoundland and Labrador Corporation Tax Calculation
    • T2SCH308Newfoundland and Labrador Venture Capital Tax Credit
    • T2SCH309Additional Certificate Numbers for the Newfoundland and Labrador Interactive Digital Media Tax Credit
    • T2SCH310Newfoundland and Labrador Manufacturing and Processing Investment Tax Credit (2022 and later tax years)
    • T2SCH311Newfoundland and Labrador Green Technology Tax Credit
    • T2SCH321Prince Edward Island Corporate Investment Tax Credit
    • T2SCH322Prince Edward Island Corporation Tax Calculation
    • T2SCH340Nova Scotia Research and Development Tax Credit
    • T2SCH341Nova Scotia Corporate Tax Reduction for New Small Businesses
    • T2SCH346Nova Scotia Corporation Tax Calculation
    • T2SCH347Additional Certificate Numbers for the Nova Scotia Digital Media Tax Credit
    • T2SCH348Additional Certificate Numbers for the Nova Scotia Digital Animation Tax Credit
    • T2SCH349Nova Scotia Innovation Equity Tax Credit (2024 and later tax years)
    • T2SCH350Nova Scotia Venture Capital Tax Credit (2024 and later tax years)
    • T2SCH351Additional Certificate Numbers for the Nova Scotia Capital Investment Tax Credit
    • T2SCH352Nova Scotia Financial Institutions Capital Tax
    • T2SCH353Nova Scotia Financial Institutions Capital Tax - Agreement Among Related Corporations (2021 and later tax years)
    • T2SCH360New Brunswick Research and Development Tax Credit
    • T2SCH366New Brunswick Corporation Tax Calculation
    • T2SCH367New Brunswick Small Business Investor Tax Credit
    • T2SCH380Manitoba Research and Development Tax Credit
    • T2SCH381Manitoba Manufacturing Investment Tax Credit
    • T2SCH383Manitoba Corporation Tax Calculation
    • T2SCH384Manitoba Paid Work Experience Tax Credit
    • T2SCH385Manitoba Odour-Control Tax Credit
    • T2SCH387Manitoba Small Business Venture Capital Tax Credit
    • T2SCH388Manitoba Film and Video Production Tax Credit
    • T2SCH389Manitoba Book Publishing Tax Credit
    • T2SCH394Manitoba Rental Housing Construction Tax Credit
    • T2SCH402Saskatchewan Manufacturing and Processing Investment Tax Credit
    • T2SCH403Saskatchewan Research and Development Tax Credit
    • T2SCH404Saskatchewan Manufacturing and Processing Profits Tax Reduction
    • T2SCH411Saskatchewan Corporation Tax Calculation
    • T2SCH421British Columbia Mining Exploration Tax Credit
    • T2SCH427British Columbia Corporation Tax Calculation
    • T2SCH428British Columbia Training Tax Credit
    • T2SCH429British Columbia Interactive Digital Media Tax Credit
    • T2SCH430British Columbia Shipbuilding and Ship Repair Industry Tax Credit (2019 and later tax years)
    • T2SCH432Additional Certificate Numbers for the British Columbia Clean Buildings Tax Credit (2022 and later tax years)
    • T2SCH440Yukon Manufacturing and Processing Profits Tax Credit
    • T2SCH442Yukon Research and Development Tax Credit
    • T2SCH443Yukon Corporation Tax Calculation
    • T2SCH444Yukon Business Carbon Price Rebate (2024 and later tax years)
    • T2SCH461Northwest Territories Corporation Tax Calculation
    • T2SCH481Nunavut Corporation Tax Calculation
    • T2SCH500Ontario Corporation Tax Calculation
    • T2SCH502Ontario Tax Credit for Manufacturing and Processing
    • T2SCH506Ontario Transitional Tax Debits and Credits
    • T2SCH507Ontario Transitional Tax Debits and Credits Calculation
    • T2SCH508Ontario Research and Development Tax Credit
    • T2SCH510Ontario Corporate Minimum Tax
    • T2SCH511Ontario Corporate Minimum Tax - Total Assets and Revenue for Associated Corporations
    • T2SCH512Ontario Special Additional Tax on Life Insurance Corporations (SAT)
    • T2SCH513Agreement Among Related Life Insurance Corporations (Ontario)
    • T2SCH524Ontario Specialty Types
    • T2SCH525Ontario Political Contributions Tax Credit
    • T2SCH550Ontario Co-operative Education Tax Credit
    • T2SCH554Ontario Computer Animation and Special Effects Tax Credit
    • T2SCH556Ontario Film and Television Tax Credit
    • T2SCH558Ontario Production Services Tax Credit
    • T2SCH560Ontario Interactive Digital Media Tax Credit
    • T2SCH564Ontario Book Publishing Tax Credit
    • T2SCH566Ontario Innovation Tax Credit
    • T2SCH568Ontario Business-Research Institute Tax Credit
    • T2SCH569Ontario Business-Research Institute Tax Credit Contract Information
    • T2SCH570Ontario Regional Opportunities Investment Tax Credit (2025 and later tax years)
    • T2SCH572Ontario Made Manufacturing Investment Tax Credit

    From the Template column of the CRA forms index.

    17% entered · 83% formula-derived & rollover

    Measured from the sample

    What the workbook changes in the file

    T2 sample · fictional data · v3.6 · 2025. Counted from the sample’s cells by the workbook’s own colour legend.

    Save time

    694fields to Taxprep

    One button writes them to the CSV that Taxprep imports. Of these, 183 carry an amount or an answer and 511 are zeros. Last year’s export, pasted once, loads 88 prior-year fields.

    Type less

    17%of cells entered

    Of the colour-coded cells, only the yellow ones are entered; the other 83% are calculated or carried from last year.

    Better control

    1,180checks

    All on one tab, each stating what it tests and how serious a failure is. The list is worked until no ERROR remains.

    667 must clear before filing · 513 to review

    Standard and searchable

    180tabs 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.

    1. 1Prior year
    2. 2Fill in
    3. 3Review
    4. 4Taxprep
    5. 5Reference

    Forms & schedules

    Selected working papers, grouped by preparation area.

    Return & GIFIT2 · Sch. 100, 101, 125, 141
    Income & assetsSch. 1, 2, 3, 4, 6, 7, 8
    Group & limitsSch. 9, 11, 23, 50, 130 (EIFEL)
    ProvincialSch. 5 · Ontario Sch. 500, 510–511
    QuébecCO-17 · CO-17.A.1 · CO-17S.4 · CO-130.A · CO-771
    AlbertaAT1 · Sch. 1, 12, 13, 18, 21

    Full inventory & scope →

    What the workbook covers

    136 CRA forms and schedules — the T2 itself, GIFI, Schedule 1, capital cost allowance, losses, capital, Schedule 130 (EIFEL) and the provincial schedules — plus the Québec CO-17 and Alberta AT1 returns. The Forms covered view lists each one.

    • Prior year Export
    • Fill in Questionnaire, TB, Federal (67 schedule tabs, SCH100 to T661), Provincial (71 schedule tabs, SCH301 to SCH572), Québec (12 schedule tabs, CO-17 to CO-1136), Alberta (15 schedule tabs, AT1 to AT1 SCH29)
    • Review Summary, CCA Control, Taxable Income, Provincial Review, Checks
    • Taxprep Import, Import Check
    • Reference Rates, Notes, .Rules, Disclaimer

    Q&A

    Scope boundaries

    The T661 SR&ED claim and Schedules 91 and 97 are not prepared: the workbook carries only the SR&ED figures Schedule 1 and the Ontario schedules read. The T106 and T1134 have their own workbooks; this edition does not prepare the T1135. The T2 workbook records only whether each applies.

    Edition, price and licence

    In-house

    CAD $329

    One entity and its corporate group.

    Buy

    A perpetual licence for the purchased edition. A new tax year is a separate edition. Full licence

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

    Is the .xlsm safe to open in a firm environment?

    In this workbook the macros act on the local file only: they 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.

    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?

    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.

    Contract

    T2 · In-house licence · CAD $329 · 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]