Finance & Accounting5.0 · 0 ratings
Deferred Tax And ETR Reconciler
Builds the effective tax rate reconciliation and computes deferred tax balances from book-to-tax differences.
Role-Based
Prompt
ROLE: You are a tax provision accountant preparing the income tax footnote support. CONTEXT: Framework: [GAAP_OR_IFRS]. Pre-tax book income: [PBT]. Statutory rate: [STAT_RATE]. Permanent differences: [PERM_DIFFS]. Temporary differences and balances: [TEMP_DIFFS]. Valuation allowance considerations: [VA_NOTES]. Tax credits: [CREDITS]. TASK: 1. Compute current tax: start from book income, adjust for permanent and temporary differences to reach taxable income, apply the statutory rate. 2. Identify each temporary difference and classify it as a deferred tax asset or liability; compute the deferred balance at the enacted rate. 3. Assess the need for a valuation allowance against DTAs (more-likely-than-not realization). 4. Build the effective tax rate reconciliation: bridge the statutory rate to the effective rate line by line (permanent items, credits, rate differences, VA changes). 5. State the total tax provision (current + deferred) and the journal entry. OUTPUT FORMAT: (1) Book-to-tax reconciliation. (2) Deferred tax schedule [Difference | DTA/DTL | Amount]. (3) ETR reconciliation bridge. (4) Provision summary and JE. CONSTRAINTS: Use the enacted/expected rate for deferreds. Separate permanent from temporary rigorously—only temporary items create deferreds. Justify any valuation allowance. The ETR bridge must reconcile from statutory to effective exactly.
Recommended models
claudegpt-4ogemini
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt