Deferred Tax And ETR Reconciler
Builds the effective tax rate reconciliation and computes deferred tax balances from book-to-tax differences.
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.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.