Free Excel templates

A free income tax provision template in Excel, with a worked case

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.

Get the template

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.

The book behind this model

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

What is in the file

Five sheets. Blue cells on a light blue fill are inputs; black cells are formulas.

Read me
What the file does, the order of the work, how to replace the example with your own year, and where the full workbooks are.
Current Tax
From domestic and foreign pre-tax income, the nondeductible items, the net temporary differences of the year (read from the Rollforward sheet) and the research credit with its unrecognized part, to state, federal and foreign current tax. It also gives the combined rate on US temporary differences and the state rate net of the federal benefit.
Rollforward
One row per category of temporary difference: the opening deferred balance (asset positive, liability negative), the movement of the gross difference, the deferred movement at the combined rate and the closing balance, with a tie-out of the change in the net balance against the deferred tax expense.
Reconciliation
The federal statutory rate line and the eight categories of the disclosure, in dollars and in percent, a few inputs for the items the template cannot derive, total income tax expense, the effective tax rate and a closing check that must be zero.
Checks
Each output set against the figure printed in the book, then structural checks: the reconciliation closes, the rollforward ties, no error value.

What the worked case shows

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 differences24.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.

How to use it on your own year

  1. On Current Tax, overwrite the example with your pre-tax income by country, your nondeductible items, your credits and the unrecognized part your uncertain-position analysis gives, and your rates.
  2. On Rollforward, enter each category’s opening deferred balance and the movement of its gross difference for the year. Keep one row per category so the tie-out stays readable.
  3. On Reconciliation, fill the few inputs the file cannot derive (state loss carryforwards used, changes in valuation allowances, enacted law changes, cross-border effects), then read the closing line: it must be zero.
  4. Keep the Checks sheet: once you change an input the comparison with the book stops matching, which is expected; the structural checks still have to pass.

Questions people ask about it

Is this income tax provision template really free?

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.

Does it follow ASU 2023-09?

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.

Does it use macros?

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.

Can I use it for a real provision?

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.

Related reading