Every income tax provision template on the market walks the same direction: book-tax differences, then current tax, then deferred tax, then a rate reconciliation at the end that mostly confirms the arithmetic ties. That is backward from how the exhibit gets used. A reviewer, and eventually an auditor, opens the rate reconciliation first, because it is the one page that explains the gap between the statutory rate and whatever rate the company actually posted. Building schedules first and hoping they reconcile later solves the problem in the order nobody reads it.
This pack builds it the other way, for a fictional case: Ashgrove Metal Fabrication, a private, audited manufacturer with 4,200,000 of pretax book income and a research credit. Total tax expense comes to 806,157, a 19.19 percent effective rate against the 21 percent federal statutory rate, and the reconciliation names every point of that gap: permanent differences, state tax, the credit, and a valuation allowance change. The schedules behind it are built to match, including a deferred rollforward seeded from last year's actual filed return rather than last year's provision estimate.
The reconciliation's one line that is not pure arithmetic is the valuation allowance, documented here as a judgment rather than an unexplained number. Ashgrove's allowance sits against a capital loss carryforward, usable only against capital gains under IRC Section 1211(a), with a five-year life under Section 1212(a)(1)(B). This year's partial release ties to the trailing three-year cumulative-loss standard in ASC 740-10-30-23. Ashgrove is not a public business entity, so ASU 2023-09 requires only a qualitative version of this reconciliation, though the pack builds the numbers anyway.
Income Tax Provision Template