Income Tax Provision Template
One document and four sheets built backward from the rate reconciliation, seeded from last year's filed return instead of its provision estimate.
Free download · No account needed
Rate Reconciliation
[Entity Name] — [Tax Year]
Built first, before the schedules that feed it. Every other page in this pack exists to tie to this one.
| Line | Amount | % of Income |
|---|---|---|
| Tax at the federal statutory rate | — | 21.00% |
| Permanent differences, federal effect | — | — |
| State income tax, net of federal benefit | — | — |
| Credits | — | — |
| Change in the valuation allowance | — | — |
| Total income tax expense / effective rate | — | — |
Five lines, each one a formula once the schedules below exist, except the valuation allowance line.
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.
What's in the pack
Provision Memo
Walks every rate reconciliation line to the schedule that supports it, so a reviewer can trace the statutory-to-effective gap back to its source instead of taking the total on faith. This is the conclusion a CPA year-end package has to agree with before the return is filed.
Rate Reconciliation sheet
Five lines from the statutory rate to the effective rate, each one a formula once the schedules below exist, with the valuation allowance as the one line that is a judgment instead.
Book-Tax Differences sheet
Two permanent items and two temporary items walking pretax book income of 4,200,000 to taxable income of 3,708,000, with the deferred effect named on each temporary line.
Deferred Rollforward sheet
Its own return-to-provision column, isolating the 3,482 gap between last year's provision estimate and what the filed return actually supported, instead of folding it into this year's activity.
Valuation Allowance Analysis
The trailing three-year cumulative income test that flips this allowance from fully reserved to a 150,000 partial release, tied to a specific identified capital gain rather than a forecast.
Built in reverse
The Rate Reconciliation sheet sits first in the folder and the three schedules behind it exist to tie to that one exhibit, not the other way most templates build it.
How it works
- 1
Open in River, or download it
Open the pack in River and let the agent read the trial balance and last year's filed return, or download the blank Word and CSV files with no account.
- 2
Send the trial balance and the return
The trial balance, last year's filed return and the depreciation schedule. If the chart of accounts itself still needs mapping, the trial balance normalizer handles that first.
- 3
Build the schedules that tie to it
Book-tax differences, the deferred rollforward with its return-to-provision column, and the valuation allowance analysis, each one built to match the reconciliation rather than the other way around.
- 4
Check the valuation allowance, every year
The trailing three-year income test gets rebuilt against this year's actual results, since a cumulative loss can flip to cumulative income, or the reverse, well before anyone remembers to check by hand.
Frequently asked questions
Is this template free?
Yes, all of it: one Word document and four CSV sheets, no signup and no card. Edit with AI is a separate, optional path for teams that would rather hand over a trial balance and a filed return than fill sheets in by hand. Every other pack River publishes sits in the template library.
What format are the downloaded files?
One .docx document, the provision memo, plus four .csv sheets: the rate reconciliation, the book-tax differences, the deferred rollforward and the valuation allowance analysis, zipped into one file. They open natively in Word, Pages, Google Docs, Excel, Numbers and Sheets, with nothing to convert.
What does Edit with AI actually do?
It creates a free River account with this exact pack installed privately, ready to read whatever you send: this year's trial balance, last year's filed return, or last year's own workpapers as a starting point. Nothing gets written until you send something, and the schedules stay editable after that.
Why build the rate reconciliation first instead of last?
Because that is the order it gets read in. An auditor or a controller's own reviewer opens the reconciliation before anything else, to see whether the effective rate makes sense. Every number on it should already trace to a schedule, not get derived backward from a total that happens to match.
What if we don't have last year's filed return yet, only the provision estimate?
Say so on the schedule rather than treating the estimate as confirmed. Every beginning balance carries a return-to-provision column for exactly this reason, and it can sit at zero until the return is filed, then get updated with whatever gap the filing actually reveals.
Does this replace a review by our CPA or auditor?
No. It gives them a provision where every line already traces to a schedule, so their review is confirming arithmetic instead of reconstructing it from account balances. If a position this provision supports ever gets challenged, responding to the notice is a separate job that starts from the notice itself, not from this file.
How does this fit with the rest of the year-end close?
It feeds it rather than duplicating it. The year-end close and statement pack drafts the financial statements themselves. This pack produces the income tax line and the deferred tax balances that close's trial balance and statement drafts both need, tied out before the statements get finalized.
Find out which line of your reconciliation is really a judgment call
Download the blank pack as Word and CSV files, or open it in River and have it build your own Rate Reconciliation and Deferred Rollforward from this year's trial balance.
Edit with AI