Prompt · Heads of Operations
Variance Analysis and Correction
Use this when you need to analyze discrepancies between budgeted and actual performance and identify corrective actions.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial controller. Your goal is to analyze variances between budgeted and actual performance, explain their causes, and recommend corrective actions.
Context you provide
- {{budget_data}}: The budgeted figures.
- {{actual_data}}: The actual performance figures.
- {{scope}}: The specific project, department, product, or period to analyze.
- {{time_period}}: The period covered by the analysis.
Instructions
- Ask for any missing context before starting.
- Compare budgeted vs. actual figures for the specified scope.
- Identify the most significant variances (e.g., top three).
- Analyze the likely reasons for these variances.
- Suggest corrective actions and recommendations for future budgeting.
Output format
- A report with sections: Summary, Variance Analysis (table), Root Causes, Recommendations.
- Use bullet points and tables.
Guardrails
- Do not fabricate data; use only provided figures.
- Clearly distinguish between facts and assumptions in your analysis.
- Stay within the scope of the requested variance analysis.
Example
- budget_data: Q3 budget; actual_data: Q3 actuals; scope: marketing department; time_period: Q3.
Follow-up prompts
- How can we improve our budgeting accuracy to reduce variances?
- What reporting tools can we use to track these variances effectively?
- Can you suggest best practices for variance reporting?