Book · Julian R. Sterling

The Income Tax Provision Handbook

A Practitioner's Guide to ASC 740: Current and Deferred Taxes, Valuation Allowances, Uncertain Tax Positions, the Rate Reconciliation and the Quarterly Provision

About the book

Cover of The Income Tax Provision Handbook

January 2025. A senior tax manager takes over the income tax provision of a publicly held US maker of industrial pumps and valves, with a US subsidiary that files on its own in two states and a sales subsidiary in Europe. In the first year a new tax law is enacted in July, the rate reconciliation moves to the eight categories of ASU 2023-09, total income tax expense comes to $25,450,600 on pre-tax income of $108,000,000, and the subsidiary's state loss carryforwards sit under a full valuation allowance of $1,730,100. This book shows the arithmetic behind each of those figures, and the file that supports them.

The Income Tax Provision Handbook is a practitioner's guide to ASC 740, seen from the desk of the person who prepares the provision: pre-tax income to taxable income and the current provision; the balance sheet approach, the tax balance sheet and the deferred tax rollforward; valuation allowances, the four sources of taxable income and the weighing of evidence; uncertain tax positions, the cumulative probability table, interest and penalties; the effective tax rate reconciliation and the income tax note; the quarterly provision on an estimated annual effective tax rate; the return-to-provision true-up; a new tax law at enactment; and the controls, the close calendar and the auditor's review. One fictional company is followed over two years, and every number comes from one model; the rules are dated as read in November 2026.

What the record shows: why the deferred tax expense must tie to the movement of the tax balance sheet before anyone reads the rate; why a cumulative loss over three years weighs more than a projection; why a measured benefit is the largest amount above 50 percent of cumulative probability; why a valuation allowance release is a discrete item of the quarter and not part of the annual rate; why a return-to-provision on a timing difference moves current and deferred tax and leaves the total unchanged; and why a law enacted in July is booked in the third quarter.

The model is supplied, not described: five companion workbooks rebuild the case by live formula, each with a Checks tab.

What you will be able to do:

Sixteen chapters in four parts and four appendices: a guide to the workbooks with five exercises, eight working check-lists, twenty questions for interviews and reviews, and a glossary of forty-one terms.

Written for tax seniors and managers who prepare the provision in a company or an advisory firm, tax directors of midsize US companies, controllers and chief accounting officers who review it, auditors who test it, and candidates preparing for a provision role. Nothing here decides how a particular company should account for or file its income taxes, or what its rate should be. The case, its company, its people and its places are fictional, and its figures are teaching assumptions, not market norms; the rules are dated as of November 2026. This book is for education only. It is not legal, tax, accounting, audit or investment advice. Part of The Private Markets Career Guides.

How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.

What is inside

The companion files

Five workbooks follow Brenlow Fluid Systems, Inc., the fictional company of the case, across two years: the current tax and the rate reconciliation, the deferred tax balances and their rollforward, the valuation allowance decision, the uncertain positions and their interest, the quarters and the true-up. Each keeps the case’s figures in blue input cells on an Inputs tab that you overwrite with your own, returns 0 for any ratio whose divisor is 0, and ends with a Checks tab. A toolkit holds the check-lists of Appendix B in editable form.

The five workbooks, the toolkit and the read-me, in one archive144 KB

The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in any spreadsheet program that reads .xlsx files.

Free template

A simplified copy of the first two workbooks for one year: current tax from pre-tax income, the deferred tax rollforward by category, and the rate reconciliation in the categories of ASU 2023-09, in dollars and in percent, with a Checks tab. Get the free income tax provision template.

Three numbers to reproduce first

Current tax$62,320,000 x 21.00 percent = $13,087,200, and $13,087,200 - $2,400,000 + $300,000 = $10,987,200: Brenlow’s federal current tax expense of 2025
The rollforward-(-$33,200,000) x 24.95 percent = $8,283,400 of deferred tax expense, and -$4,041,900 + (-$8,283,400) = -$12,325,300
The allowance$16,200,000 x 4.74 percent = $767,880 released under option (b), leaving $1,531,020 - $767,880 = $763,140

The files are provided as they are, without warranty of any kind. The model is illustrative: Brenlow Fluid Systems, Inc., its subsidiaries and its people are fictional; the income, differences, rates, probabilities, projections and effects are the book’s assumptions, not market norms or the record of any real company, and no effective tax rate in them is a goal. The workbooks compute; they make no judgment on evidence, recognition or measurement, decide no filing position, and promise no tax or accounting result. Not legal, tax, accounting, audit or investment advice.

Read first

To read: How do you decide whether a deferred tax asset needs a valuation allowance?

To read: How do you build the effective tax rate reconciliation under ASU 2023-09?

To read: How does the quarterly tax provision work under the annual effective tax rate method?

Also by Julian R. Sterling