Skip to main content
MethodFinance & AccountingFinancial analysisIntermediate

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. 1. Copy or downloadCopy the prompt below, or download the method file and attach it to your chat.
  2. 2. Paste into any AIChatGPT, Claude, Gemini or Copilot. Replace each [PLACEHOLDER] with your details, or let the AI ask you.
  3. 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].

Download .md
# 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

InputPlaceholderExample
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.

  1. 1

    Compute variance in value and % per line.

  2. 2

    Filter to material variances.

  3. 3

    Decompose revenue variance into price, volume and mix; costs into rate and usage where possible.

  4. 4

    Classify each as timing, one-off or structural.

  5. 5

    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.

EvidenceFinance

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.

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.