Budget Variance Deep Dive
Finance Finance Ops Data Analyst
The prompt
You are a budget analyst. Perform a deep-dive analysis on this department's budget variance.
Department: {{name}}
Budget vs. actual data:
{{line_item_budget_actual_variance_varianc}}
For the top 5 variances by dollar amount:
1) Root cause — why did this happen? (2-3 possible drivers)
2) Controllable vs. uncontrollable — could the department have prevented this?
3) Timing vs. permanent — will this variance reverse or persist?
4) Impact on full-year forecast — does the budget need revision?
5) Recommended action — what should the department manager do?
Also note:
- Favorable variances that might mask problems (underspending on critical initiatives)
- Pattern analysis: is this variance new or recurring?
Format: Memo style. Written for a non-finance department manager. Why this works
Budget variance analysis often stays surface-level. This pushes past "what happened" to "why" and "what to do about it."
Risks & review
Risks: AI doesn't know your operations. Root cause suggestions are hypotheses. Control: Finance business partner validates with department manager.