Enter pre-tax income, the nondeductible items, the credits and the movement of each temporary difference, and the file builds current tax, rolls the deferred taxes forward by category, and produces the rate reconciliation in the eight categories of ASU 2023-09, in dollars and in percent. Five sheets, no macros.
The example is the book’s fictional company, Brenlow Fluid Systems, for 2025: consolidated pre-tax income of $108,000,000, current tax of $17,167,200, deferred tax expense of $8,283,400 and total income tax expense of $25,450,600. The reconciliation runs from $22,680,000 at the federal statutory rate of 21.00 percent to an effective tax rate of 23.57 percent, and the Checks sheet confirms that it closes to the dollar.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Brenlow_Income_Tax_Provision_Template.xlsx (16 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is a simplified, one-year copy of the first two of the five workbooks of The Income Tax Provision Handbook. The book follows the same company for two years: the current provision, the tax balance sheet and its rollforward, a valuation allowance decision priced in three options, uncertain tax positions and their interest, the income tax note under ASU 2023-09, the quarters on an estimated annual effective tax rate, the return-to-provision true-up and a new tax law at enactment.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Five sheets. Blue cells on a light blue fill are inputs; black cells are formulas.
| Measure (2025, fictional company) | Value |
|---|---|
| Taxable income before the state tax deduction | $65,600,000 |
| State current tax, at the case rate of 5.00% | $3,280,000 |
| Federal current tax expense, after the research credit and its unrecognized part | $10,987,200 |
| Foreign current tax, at the case rate of 25.00% | $2,900,000 |
| Total current tax expense | $17,167,200 |
| Combined rate on US temporary differences | 24.95% |
| Deferred tax expense on US differences | $8,283,400 |
| Net deferred tax liability at year end (US differences) | $12,325,300 |
| Total income tax expense | $25,450,600 |
| Effective tax rate (a result, not a target) | 23.57% |
The net temporary differences of the year, -$33,200,000, lower taxable income and raise deferred tax expense by the same amount at the combined rate: $33,200,000 x 24.95% = $8,283,400. That is why current tax alone says little about the year. In the reconciliation the 21.00 percent statutory line is followed by state and local income tax, net of federal income tax effect 3.68%, foreign tax effects 0.43%, tax credits -2.22%, changes in valuation allowances -0.07%, nontaxable or nondeductible items 0.47%, changes in unrecognized tax benefits 0.28%, which add up to 23.57 percent. Under the 5 percent threshold of the update, any item of $1,134,000 or more in four of the categories (1.05 percent of pre-tax income) is broken out by nature; here only the research credit passes it.
Yes. It is a companion file of a book. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The Reconciliation sheet lays out the eight categories of the disclosure in their order, in dollars and in percent, and checks that the total equals total income tax expense. Which items reach the 5 percent threshold and have to be broken out by nature remains a review step, explained in the book.
No macros and no circular reference. Inputs are blue cells; everything else is a formula, every ratio returns 0 while its divisor is 0, and a Checks sheet compares the outputs with the figures printed in the book.
You can reuse the structure and replace every input. The company and its figures are fictional teaching assumptions, no effective tax rate in the file is a goal, and nothing here is tax, accounting or audit advice.