Explain budget vs actual variances
A variance report that separates price, volume and mix effects and explains what management should do.
This is a practical, copy-paste process for month-end or quarter-end close.. Use it when you want a clear structure, then add your own details and the linked evidence.
Published by Deepstory Research. Reviewed Sep 2026.
How to use this method
- 1. Copy or downloadCopy the prompt below, or download the method file and attach it to your chat.
- 2. Paste into any AIChatGPT, Claude, Gemini or Copilot. Replace each [PLACEHOLDER] with your details, or let the AI ask you.
- 3. Add evidenceAttach the evidence files listed on this page so the AI works from sourced numbers, not guesses.
The prompt
Paste it as-is. The AI will ask for anything still in [BRACKETS].
# Explain budget vs actual variances Method by Deepstory Research: deepstoryresearch.com/method/variance-analysis-budget-vs-actual You are an FP&A manager preparing the monthly management pack. Follow the method below step by step. Goal: A variance report that separates price, volume and mix effects and explains what management should do. ## My inputs - Budget and actuals: [BUDGET_AND_ACTUALS] (example: attach spreadsheet) - Period: [PERIOD] (example: October 2026) - Materiality threshold: [MATERIALITY_THRESHOLD] (example: 5% or ₹5 lakh) Before you start: if any input above is still in [BRACKETS] or missing, ask me for it in one short numbered list and wait. Do not guess. If I attached files (data, briefs, Deepstory evidence files), treat them as the primary source. ## Steps to follow 1. Compute variance in value and % per line. 2. Filter to material variances. 3. Decompose revenue variance into price, volume and mix; costs into rate and usage where possible. 4. Classify each as timing, one-off or structural. 5. Recommend actions and forecast changes. ## Deliver the output in this structure - Variance table - Bridge from budget to actual - Commentary per material line - Actions & reforecast ## Quality rules - Favourable/unfavourable sign convention stated once and used consistently. - Do not explain a variance with a guess, mark it "needs owner input". - Label every number as FACT (with source and date), ESTIMATE (show the calculation) or ASSUMPTION. - If a Deepstory evidence file is attached, use its figures as the reference values and cite its source references; tag claims that are not from it as [UNVERIFIED]. - End with: the 3 assumptions that matter most, what would change the answer, and the single best next step.
What you need to give the AI
| Input | Placeholder | Example |
|---|---|---|
| Budget and actuals | [BUDGET_AND_ACTUALS] | attach spreadsheet |
| Period | [PERIOD] | October 2026 |
| Materiality threshold | [MATERIALITY_THRESHOLD] | 5% or ₹5 lakh |
Use it when
- Month-end or quarter-end close.
- Results missed plan and leadership wants to know why.
What you get
- Variance table
- Bridge from budget to actual
- Commentary per material line
- Actions & reforecast
The procedure, step by step
Read this before you run it, so you can check the AI actually followed the method.
Compute variance in value and % per line.
Filter to material variances.
Decompose revenue variance into price, volume and mix; costs into rate and usage where possible.
Classify each as timing, one-off or structural.
Recommend actions and forecast changes.
Quality checks built into the prompt
- • Favourable/unfavourable sign convention stated once and used consistently.
- • Do not explain a variance with a guess, mark it "needs owner input".
- • Every number labelled FACT, ESTIMATE or ASSUMPTION; claims outside attached evidence tagged [UNVERIFIED].
Evidence to use with this method
Methods tell the AI how to think. Evidence gives it sourced numbers to think with. Download a context file and attach it with the prompt.
Six-Economy Macro Baseline
A common-country, common-period baseline for real growth, inflation, modeled unemployment and trade exposure across the United States, China, India, Germany, the United Kingdom and Japan.
US Inflation & the Fed
The full 2026 inflation story on one page: the CPI path and category breakdown, the mid-year turn and the still-rising core PCE outlook, and the Fed’s rate response — fed funds, the 10-year Treasury, and the 30-year mortgage.
Private Credit: A $1.2 Trillion Disagreement
Estimates of global private credit AUM differ by more than a trillion dollars. This index shows the spread rather than picking a number.
Run next
Methods that chain well after this one.
Deepstory methods are process guidance for AI tools. Review AI output before relying on it; legal, tax, medical and investment decisions need a qualified professional.