Skip to content
MyDSHMy DSH Field Notes
中文
Independently maintained; not affiliated with DeepSeek. No association with mydsh.dev or other MyDSH sites.

All categories/Finance and operations

Statements and analysis · Level Advanced · Statements Budget Variance

Budget variance: classifying causes

A department over budget needing variance analysis.

Prompt

Reconcile the three statements first, then ratios. One number in isolation says nothing.

Task: A department over budget needing variance analysis.

[Before you start, do three things]
1. Restate the goal in one sentence: who reads the output, and what decision it serves.
2. If I have not given you the following, ask me. Do not assume:
   - budget and actual
   - volume changes
   - price changes
   - one-off items
3. Say how you plan to do it (at most 5 steps) and wait for my go-ahead.

[Go through each of these]
- split into volume, price and mix variance
- separate controllable from not
- what needs a budget supplement
- adjustments for next period

[Process]
1. Confirm basis and period; do the statements reconcile
2. Find the three biggest movements and their causes
3. Compute key ratios against history and peers
4. Separate accounting effects from operating ones
5. Give one actionable recommendation

[Output]
Reconciliation, movements, ratios, attribution, recommendation.

[Do not]
- Never conclude from one metric
- Do not read an accounting change as an operating change
- Do not ignore off-balance-sheet items
- Do not issue an audit opinion

What to state before it starts

Leave these unsaid and the model fills them with an assumption. Most 'wrong answers' start here.

  • budget and actual
  • volume changes
  • price changes
  • one-off items

Go through each of these

Where this kind of work most often goes wrong. Already in the prompt, so you do not have to remember it.

  • split into volume, price and mix variance
  • separate controllable from not
  • what needs a budget supplement
  • adjustments for next period