Excel demo
See a tax provision run in Excel
This workbook automates the year-end process for a fictional eight-entity software group in Canada, the US, and the UK. View its diagrams here, or request the workbook and a working session where we run it together.
Explore the workbook in your browser
These diagrams show how the workbook is organized. Each opens in a new tab. To run the Excel workbook itself, request the package and walkthrough below.
8
entities in one consolidated group
3
tax jurisdictions: Canada, the US, and the UK
65
checks that reconcile the workbook on each refresh
2
years of source data to run a year-end cycle
The year-end process
The workbook opens on a completed 2025 example. These steps take it through the next year. You remain responsible for reviewing the results.
- 01
Roll forward
Save the prior-year note, create a backup, and move the schedules to the new period. The workbook warns before overwriting data and checks whether that year has already been rolled forward.
- 02
Import
Bring in the new year's trial balances, tax packages, and supporting files for each jurisdiction. Import checks identify rows that need attention and explain the problem.
- 03
Refresh
Update the calculations in order, including book-to-tax adjustments, capital cost allowance, and deferred tax. The tax note shows the new year alongside the prior year.
- 04
Review
Review the reconciliation checks and compare opening balances with prior-year closings. The status panel shows which jurisdiction packages have arrived and what still needs attention.
See what has run and what needs review
The workbook's status panel shows the current period, the last roll-forward, and outstanding work. It tracks which steps have run and which source packages have been imported.
The consolidation stays marked as partial until the Canadian, US, and UK packages have arrived. Reconciliation checks run on each refresh and explain any failures, so the reviewer can see what needs attention.
How shared calculations work →Request the Excel demo and a walkthrough
Tell us a little about your team. We will reply to arrange a working session and send the package. We run the year-end process together and discuss how the approach could apply to your department. All company data in the example is fictional.
What you receive:
- An Excel workbook (.xlsm) with the automation built in
- Fictional source data for 2025 and 2026, covering Canada, the US, and the UK, plus exchange rates
- The interactive diagrams shown on this page
- Walkthrough instructions and a list of the reconciliation checks
Discuss your own provision process
Tell us how your team prepares the provision and where the recurring work takes time.