Book · Julian R. Sterling
A Practitioner's Guide to ASC 740: Current and Deferred Taxes, Valuation Allowances, Uncertain Tax Positions, the Rate Reconciliation and the Quarterly Provision
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.
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 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.
Chapters 3, 4, 11 and 12
Two years side by side: current tax from pre-tax income in the order of the provision, the deferred lines, total income tax expense, and the rate reconciliation in the eight categories of the disclosure, in dollars and in percent. Tabs: Conventions, Inputs, Current Tax, Reconciliation, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 124 KBChapters 5 and 6
The tax balance sheet by category, asset positive and liability negative, rolled forward at one combined rate and tied to the deferred tax expense. Tabs: Conventions, Inputs, Rollforward, Deferred Expense, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 220 KBChapters 7 and 8
The evidence register, the scheduling of projections and reversals against the losses, three options side by side and two sensitivities. All projections. Tabs: Conventions, Inputs, Evidence, Scheduling, Options, Sensitivities, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 322 KBChapters 9 and 10
One block per uncertain position, the cumulative probability table that measures it, and the interest at the case rate, quarter by quarter. Tabs: Conventions, Inputs, Cumulative Probability, Interest, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 418 KBChapters 13 and 14
The four quarters on an estimated annual effective tax rate with the discrete items kept out, the year-end figures, and the return-to-provision split into current and deferred. Tabs: Conventions, Inputs, Q1, Q2, Q3, Q4, Year-End, True-Up, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 523 KBAppendix B
Year-end provision calendar; Data collection and the differences; The deferred tax rollforward; The valuation allowance, evidence and documentation; Uncertain tax positions, inventory, measurement and review; The rate reconciliation and the ASU 2023-09 disclosures; The quarterly provision; The return-to-provision and the auditor’s review.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me6 KBA 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.
| 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.
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?