Income Tax Provision Workpaper with the ASU 2023-09 Rate Reconciliation
Supports income tax expense and the tax note: pretax income and current / deferred tax by jurisdiction, the ASU 2023-09 rate reconciliation in amounts and percentages, income taxes paid by jurisdiction, deferred tax and unrecognized tax benefit rollforwards, and the 10-Q estimated annual effective tax rate.
Tab structure
- Instructions
- Setup (with workpaper header and the statutory rate)
- Summary & Tie-out
- Provision – pretax domestic / foreign, current and deferred by federal, state and foreign, effective tax rate, tie to the income statement; 10-Q estimated annual effective tax rate block
- Rate Reconciliation – tax at the statutory rate, the eight ASU 2023-09 categories plus other adjustments, amounts and percentages, the 5% test, states making up the majority of the state category
- Taxes Paid – by jurisdiction and level, federal / state / foreign subtotals, the 5%-of-total jurisdiction test, tie to the supplemental cash flow disclosure
- Deferred & UTB – component rollforward (P&L, OCI, other) to the balance sheet and the deferred provision; unrecognized tax benefits rollforward
- Judgments
- Completeness & Controls
- Open Items
- Sign-offs & Refs
- Tickmarks
- Lists
Built on the common workpaper framework – see the templates overview.
Key checks and flags
- Provision equals the income statement; the reconciliation total equals the provision (10-K)
- Items at or above 5% of tax at the statutory rate are counted until shown separately with nature and jurisdiction (740-10-50-12B)
- Jurisdictions at or above 5% of income taxes paid are flagged for separate disclosure
- Taxes paid tie to the cash flow disclosure; federal + state + foreign = total
- Deferred rollforward ties to the balance sheet and the deferred provision; UTB beginning = last year's ending
- 10-Q: ordinary income × estimated annual rate + discrete items = YTD provision (ASC 740-270)
Who uses it
Tax director and the SEC reporting team preparing the tax note, ETR discussion in MD&A and supplemental cash flow disclosure.
Primary sources
Previews
Rendered from the actual workbook with illustrative sample data ("Example Company, Inc.", period end December 31, 2026). Scroll sideways on small screens.
Rate Reconciliation
Rate Reconciliation tab: ASU 2023-09 categories in amounts and percentages, with the 5% test.
Taxes Paid
Taxes Paid tab: by jurisdiction, with subtotals, the 5% test and the cash flow tie.