Excel working papers

T2, T5013 and tax provision workbooks that make review easier.

Document and support the tax return in Excel. Linked schedules make figures easier to trace, and built-in checks flag items for review.

For accounting firms and in-house tax teams.

Save time
694 fields to Taxprep
Type less
17% of the cells entered
Better control
1,180 checks on one tab
Standard
180 tabs in the numbered groups

Measured on the T2 2025 sample workbook (fictional data).

How the information flows
Prior-year figuresPrevious return or closing balances
Current-year recordsTrial balance and source documents
Manual entry
Copilot assistanceCopilot access in Excel required
MBTT Structured Excel WorkbookLinked schedules · Review checks
Tax preparation software
Financial Statement (Tax Provision)

Tax returns are prepared and filed in tax software. See supported transfers

Built by Maxime Blais, CPA

Québec CPA, master’s degree in tax law. About the author · LinkedIn

Read the workbook standard

TaxWorkbooks is an independent initiative, separate from the author’s employment and unaffiliated with the author’s employer. Workbook templates and basic product support only; no tax advice, return preparation or engagement review.

From last year’s return to a signed-off file

Every template follows the same documentation process, with a few differences specific to each form. Choose a template to walk through its main steps in the actual worksheet layout (fictional data).

    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.

    Built against production failure modes

    Three filing traps caught before Taxprep import

    17% entered · 83% linked & calculated (T2)

    Carryover errors & hardcoded totals

    Opening balances pull into Group 2 from the prior-year Taxprep export. 11,359 formulas compute schedules from 2,638 clearly marked input cells, keeping manual transcription out of tax software.

    1,180 T2 checks · 199 T5013 checks

    Unreconciled schedules at sign-off

    Dedicated reconciliation tabs verify net income, GIFI balance-sheet continuity, CCA pools, and slip totals side by side. Built-in ERROR, WARN, and INFO tests surface discrepancies on one summary tab prior to file approval.

    694 mapped T2 Taxprep lines

    Opaque mapping & unreviewed overrides

    Reviewers inspect exact Taxprep field codes in plain text alongside explicit source links and unlocked formulas. No locked sheets or hidden macros sit between source data and the final Import sheet.

    Every workbook follows the same five-group architecture, cell color roles, unlocked formulas, and open VBA conventions.

    Read the workbook standard →

    Licence tiers

    One tax-year edition per workbook. Each other workbook shows its price on its own page.

    No sales tax is charged. Prices in Canadian dollars. Full licence

    Practical questions

    Workbook support and product enquiries: Contact and support

    Which version of Excel is required?

    Built for Excel 2021 and Microsoft 365 on Windows and Mac. Each edition is tested natively on both before release.

    What language are the workbooks?

    Product and legal information is available in English and French. Current workbook demonstrations and detailed guides are in English; French workbook conversion is planned for FY2027. Language and compatibility must be checked for the exact edition before purchase.

    What does the licence cover?

    The in-house licence covers one entity and its corporate group. Practice and enterprise licences have different scopes; a quote is sent by email. Full terms are set out in the licence.

    Does the workbook file the return?

    No. The workbook supports calculations and documentation. Data transfer and filing follow the procedures of the appropriate tax-preparation software.

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

    The macros act on the local file only: tab filtering, row resizing and the Import CSV, where a workbook offers them. The T4 / RL-1 workbook can also start a separately installed local reviewer companion on request. 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. The conventions are explained in the workbook.

    How is an edition obtained?

    Online, from the workbook’s page. Its Buy button opens Stripe’s payment page, the contract documents are at the foot of the page, and the workbook follows by email. Samples can be reviewed now.

    The author1

    Maxime Blais, CPA

    Maxime Blais is a Québec CPA with a master’s degree in tax law. His career began in public accounting, continued in consolidated tax reporting for a listed group and in tax management at a firm, and now covers Canadian and U.S. tax planning, fund and transaction structuring, compliance and financial reporting. The catalogue follows that path: partnership and corporate returns, tax provisions, foreign-affiliate and information-return filings, and the slips that firms prepare in volume. He has automated high-volume form preparation, and the workbooks carry that approach: formulas, checks and notes left in plain text that a reviewer, next year’s preparer or an AI assistant can read.

    Areas of expertise
    Corporate tax · Partnership tax · Tax provisions · International and Canada–U.S. tax · Consolidated tax reporting · Automation of tax work

    The offering is limited to workbook templates and basic product support. Tax advice, return preparation and engagement review services are not offered.

    1 TaxWorkbooks is an independent initiative, separate from the author’s employment and unaffiliated with the author’s employer.