Tax provisions

On request

Tax Provision · IAS 12 Excel working papers

From the trial balance to a documented provision. An Excel workbook for the income tax provision of a Canadian corporation reporting under IFRS. A temporary-difference ledger connects deferred tax calculations to the provision and disclosures.

Inside the templateFictional sample
IAS 12.xlsx

IAS 12 · v1.0 · 2026

Provision: Income tax provision summary, fictional IAS12 workbook example

At a glance

Standard
IFRS · IAS 12
Entities
Canadian corporations
Software
Excel · .xlsx
Edition
2026 · v1.0

Information flow

Information flow
SourcesPrior-year closing balances
SourcesTrial balance & tax information
Tax provision workbookIFRS · IAS 12Current & deferred tax · Reconciliation · Controls
Year-end reportingProposed entries · Draft note

Inputs and results require review.

From trial balance to year-end reporting

  1. 01

    Set up the reporting period

    Establish the entity and accounting policies, then bring forward prior-year balances.

    Info · Prior Year · Ref

  2. 02

    Map the trial balance

    Bring in accounts and balances, assign mapping targets and reconcile tax accounts.

    TB · Map · Tax Accounts

  3. 03

    Calculate the provision

    Complete tax bases, temporary differences, tax losses and uncertain tax treatments.

    Current Tax · Temp Diffs · Losses & Credits · IFRIC 23

  4. 04

    Review the results

    Explain effective-rate differences, review the provision and resolve the controls.

    Rate Rec · Provision · Control Checks

  5. 05

    Prepare the close

    Review proposed entries and tailor the financial-statement note; retain balances for the following year.

    Entries · FS Note · Closing · Sign-Off

See it work

The provision in the workbook

Fictional scenario: Example IFRS Reporter Inc. The PDF includes the provision, rate reconciliation and financial-statement note.

Inside the guide

User guide preview

Selected pages from the English IAS 12 v2.0 Preparer Guide. Open an image to zoom.

IAS 12 v2.0 · English user guide, page 1: Cover
IAS 12 v2.0 · Cover · page 1 of 128
IAS 12 v2.0 · English user guide, page 4: How this workbook works
IAS 12 v2.0 · How this workbook works · page 4 of 128
IAS 12 v2.0 · English user guide, page 105: Journal-entry schedule and checks
IAS 12 v2.0 · Journal-entry schedule and checks · page 105 of 128

Scope & outputs

Selected working papers, grouped by preparation area.

Current taxCurrent Tax · True-Up · T2 Bridge
Deferred taxTemporary differences · Losses & credits · Outside basis
JudgmentsIFRIC 23 · Recognition · Reversal rates
ReportingRate reconciliation · Proposed entries · Draft note

Full inventory & scope →

What the workbook covers

Engagement and continuityCover, Index, Info, Prior Year, Closing, Sign-Off
Data and referencesTB, Map, Ref, T2 Bridge
Tax calculationsTrue-Up, PP&E, Losses & Credits, Temp Diffs, IFRIC 23, Outside Basis, Current Tax
Reporting and controlsRate Rec, Provision, Tax Accounts, Entries, Note, FS Note, Control Checks

Q&A

Limitations

Designed for Canadian corporations applying IFRS; this is not presented as an ASPE or US GAAP template. Deferred-tax asset recognition, uncertain treatments, reversal rates and outside-basis differences require professional judgment. Certain combinations of recognition changes and other-comprehensive-income movements require separate ledger rows; the workbook instructions explain these cases. The draft note and proposed entries must be tailored to the entity. Return filing and tax advisory services are not provided.

Workbook extract