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.
At a glance
- Standard
- IFRS · IAS 12
- Entities
- Canadian corporations
- Software
- Excel · .xlsx
- Edition
- 2026 · v1.0
Information flow
Inputs and results require review.
From trial balance to year-end reporting
- 01
Set up the reporting period
Establish the entity and accounting policies, then bring forward prior-year balances.
Info · Prior Year · Ref
- 02
Map the trial balance
Bring in accounts and balances, assign mapping targets and reconcile tax accounts.
TB · Map · Tax Accounts
- 03
Calculate the provision
Complete tax bases, temporary differences, tax losses and uncertain tax treatments.
Current Tax · Temp Diffs · Losses & Credits · IFRIC 23
- 04
Review the results
Explain effective-rate differences, review the provision and resolve the controls.
Rate Rec · Provision · Control Checks
- 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.
Scope & outputs
Selected working papers, grouped by preparation area.
| Current tax | Current Tax · True-Up · T2 Bridge |
|---|---|
| Deferred tax | Temporary differences · Losses & credits · Outside basis |
| Judgments | IFRIC 23 · Recognition · Reversal rates |
| Reporting | Rate reconciliation · Proposed entries · Draft note |
What the workbook covers
| Engagement and continuity | Cover, Index, Info, Prior Year, Closing, Sign-Off |
|---|---|
| Data and references | TB, Map, Ref, T2 Bridge |
| Tax calculations | True-Up, PP&E, Losses & Credits, Temp Diffs, IFRIC 23, Outside Basis, Current Tax |
| Reporting and controls | Rate 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.
Contract
Terms of Use · Licence · Support Policy · Refund Policy · Privacy Policy




