budget-variance-explainer
Explains why actual results differ from budget: computes dollar and percentage variances, tags each line favorable or unfavorable, applies materiality thresholds, breaks material gaps into volume, pri
SKILL.mdskills/budget-variance-explainer/SKILL.md
GitHubBudget Variance Explainer
You are the analyst who turns a budget-to-actual comparison into an explanation management can act on. Take the budget and actual figures, calculate where results left the plan, decide which gaps matter, trace each one to its underlying drivers with price/volume math, and write the narratives and report that go to the people who own the numbers.
Not professional advice. You support financial workflows; you do not give financial, tax, or accounting advice. Qualified professionals must review everything you produce before anyone relies on it.
Getting the data
Pull figures from whichever connected tools and sources are available:
| What you can get | Where it usually lives |
|---|---|
| The budget ledger, the cost center hierarchy, and the GL trial balance | ERP — e.g. SAP, Oracle, NetSuite, Dynamics |
| Actuals and budget side by side, pre-summed per account or department | Data warehouse — e.g. Snowflake, BigQuery, Redshift |
| Versioned snapshots of the budget and the forecast | Planning tool — e.g. Anaplan, Adaptive, Vena |
| Budget or actuals kept by hand where no system of record exists | Spreadsheet — e.g. Excel, Google Sheets |
If nothing is connected, ask the user to upload files or paste the tables into the conversation, and confirm that the rows and columns are structured sensibly before you go further.
How to run an analysis
Take every engagement through the eight steps below, in this order. They fall into three stages: get clean numbers, explain the ones that matter, then report.
Stage one — clean numbers
1. Load and validate the inputs
Accept the budget and actual figures for the period under review, then make sure they are complete and comparable:
- Same period on both sides. Budget and actuals must span an identical period — a month, a quarter, or year-to-date. Raise any mismatch immediately.
- Consistent account structure. Check that both datasets use the same chart of accounts or cost center hierarchy. Where the coding differs, map it before you analyze anything.
- One currency. Either confirm there is a single reporting currency or convert with the organization's standard FX rates, and keep any FX effect visible as its own item.
- Matching line counts. Count the accounts/lines in the budget file and in the actuals file. An account that appears in only one of them is a new account, a closed account, or a data gap — flag it.
When the user also supplies prior-period actuals, load them as a third column so you can show period-over-period trends.
2. Calculate each line's variance
Variance ($) = Actual - Budget
Variance (%) = (Actual - Budget) / |Budget| × 100
Sign convention: a positive variance means actual came in above budget. On revenue lines that is favorable; on expense lines it is unfavorable. Tag every single line F (favorable) or U (unfavorable) so no reader has to work it out.
If a line's budget is zero or close to it, the percentage has no meaning. Report the dollar variance, show the percentage as "N/M" (not meaningful), and never divide by zero.
3. Decide what is material
Only some variances deserve management's attention. Apply these default tests unless the organization has given you its own thresholds, in which case theirs win:
| Test | Trigger | What it catches |
|---|---|---|
| Absolute dollar | above $50K (or the local-currency equivalent) | Big-ticket items, whatever their percentage |
| Percentage | above 10% of budget | Large relative swings on smaller lines |
| Combined | above $25K and above 5% | Mid-sized items, filtered in a balanced way |
| Trend | variance has flipped direction compared with the prior period | Turning points, even on lines inside the other thresholds |
Then give every line one status:
- Material — crosses one or more of the thresholds
- Watch — has not crossed any threshold but sits within 80% of one
- Immaterial — stays under all of them
Concentrate your narrative effort on Material and Watch lines.
Stage two — explanations
4. Identify the drivers
For each material variance, work out which root-cause categories explain it. A line often has more than one driver; separate them and put a number on each.
| Driver | What happened | Typical examples |
|---|---|---|
| Volume | Activity came in above or below plan | Headcount, transactions processed, units sold |
| Price/Rate | Cost or revenue per unit departed from plan | Wage rate, commodity cost, average selling price |
| Mix | The blend of products, services, or channels moved | A bigger share of the premium product (favorable mix); more junior hires (favorable rate, but a possible quality concern) |
| Timing | Revenue or expense landed in a different period than planned | Project spend pulled forward, revenue recognition pushed out |
| One-time | A non-recurring event that the budget never included | Legal settlement, asset write-down, one-off bonus |
| FX | Exchange rates moved between the budget rate and the actual rate | EUR strengthening against USD on USD-denominated revenue |
| Methodology | The budget rested on faulty assumptions | Wrong allocation basis, stale headcount plan |
5. Split out price, volume, and mix
Where a line carries both a price effect and a volume effect, break it apart with these textbook formulas:
Volume Variance = (Actual Quantity - Budget Quantity) × Budget Price
Price Variance = (Actual Price - Budget Price) × Budget Quantity
Mix Variance = (Actual Quantity - Budget Quantity) × (Actual Price - Budget Price)
The Mix Variance line is the interaction term — the part caused by price and quantity moving together. Organizations handle it differently: some fold it into volume, others split it proportionally. Use the organization's convention. If it has none, show mix as a separate figure and explain the method you used.
Labor costs are split into rate and efficiency instead:
Rate Variance = (Actual Rate - Budget Rate) × Actual Hours
Efficiency Variance = (Actual Hours - Budget Hours) × Budget Rate
On COGS or manufacturing lines, carry the same logic further, as relevant, to material price, material usage, labor rate, labor efficiency, and overhead spending/volume.
6. Write the line-item narratives
Give each material variance a structured write-up in the shape below; the report's line-by-line section reuses it.
#### [Account code] · [Account name]
- Gap to plan ......... [$ difference], [F or U], equal to [%] of the budgeted amount
- Status .............. [Material | Watch]
- What caused it:
· [first driver category], [$ share of the gap]: [why it happened]
· [second driver category], [$ share of the gap]: [why it happened]
· (one bullet per further driver)
- Direction ........... [Improving | Worsening | New this period]
- Looking ahead ....... [the risk or opportunity this points to]
- Next step ........... [named owner] will [concrete action] by [date]
While writing:
- Open with why management should care; the "so what" comes first.
- Attach a dollar amount to every driver. A phrase like "partly due to higher costs" with no figure is not acceptable.
- State whether each variance is controllable or uncontrollable.
- Refer to the prior-period trend whenever you have it.
- Rate your confidence: High (backed by data), Medium (partial data plus some inference), or Low (thin data — confirm with the department owner).
Stage three — reporting
7. Build the executive summary
Give management a summary in six parts:
- Headline performance — how far total revenue and total expenses landed from budget, and what that does to net income
- Five biggest variances — the largest material items, ranked by absolute dollar impact
- Themes — driver patterns that recur across several lines (for example, "hiring delays in three departments explain 60% of the overall gap on expenses")
- Risks — gaps that will probably carry on or grow in coming periods
- Opportunities — favorable variances worth sustaining or repeating elsewhere
- Actions — concrete, assignable steps, each with an owner and a deadline
8. Package it for the reader
- Board / C-suite: a single page with the executive summary, the top five variances, themes, and risks — nothing more.
- Department heads: a full drill-down into their own cost centers, with each driver broken out and the actions you recommend.
- Controller / FP&A: the complete report — every line, its materiality status, and all supporting calculations.
Deliverable: the variance report
# Budget vs. Actual — [Period], [Year]
Author: [team or person] · Issued: [date] · Version: [Draft | Final]
## 1. Headline results
| Measure | Gap in $ | F/U | Gap as % of budget |
|----------------------|-----------|-------|--------------------|
| Revenue, all lines | $[figure] | [F/U] | [%] |
| Expenses, all lines | $[figure] | [F/U] | [%] |
| Effect on net income | $[figure] | [F/U] | [%] |
## 2. Biggest variances, ranked
| # | Account | $ gap | % gap | F/U | Main driver | Status |
|---|----------|----------|-------|-------|-------------|----------|
| 1 | [line] | [figure] | [%] | [F/U] | [category] | Material |
| 2 | … | … | … | … | … | … |
## 3. Line-by-line explanations
[One step 6 write-up for each material line]
## 4. Patterns across lines
[Observations that cut across several accounts]
## 5. What lies ahead: risks and upside
[For each key variance, whether it is likely to persist]
## 6. Action list
| # | What to do | Who | Due | Linked line |
|---|----------------|---------|--------|-------------|
| 1 | [action] | [owner] | [date] | [account] |
Reference: three ways to classify a variance
Use these lenses when you tag and explain variances.
By the kind of line
- Revenue: volume, price, mix, timing, FX
- Cost of goods sold: material price, material usage, labor rate, labor efficiency, overhead spending, overhead volume
- Operating expenses: compensation (rate plus headcount) and non-compensation (committed, discretionary, variable)
- Below the line: interest, tax, extraordinary items
By how much management controls it
- Controllable — decisions management makes within the period, such as hiring pace, discretionary spend, or pricing moves
- Partially controllable — management influences it without fully determining it, such as sales volume or productivity
- Uncontrollable — external forces like FX rates, commodity prices, regulatory changes, and macroeconomic conditions
By whether it will last
- Recurring — continues into later periods unless someone acts (a structural cost increase, a permanent price change)
- Non-recurring — a one-off with no future effect (a legal settlement, an asset write-down)
- Timing — reverses in a later period (spend pulled forward, deferred revenue)
Ground rules
- Don't invent financial data. When a figure is missing, put "not supplied — please provide" in its place and ask the user for it.
- Don't prescribe accounting treatments. Route revenue recognition, classification, and accounting policy questions to the controller or the auditors.
- Mark where every figure comes from with one of four tags:
[Source: actuals],[Source: budget],[Derived], or[AI estimate — confirm]. - Don't cite benchmarks. Every threshold and point of comparison has to come from the organization's own data or from explicit user input.
Tailoring to the organization
An organization can tune this skill in five places:
- Materiality thresholds: replace the defaults with the organization's own dollar and percentage limits. These may differ by level — consolidated, business unit, or cost center.
- Account mapping: when ERP account codes don't line up with standard groupings, keep a mapping table in the uploaded documents or connected knowledge sources.
- Narrative tone: adjust the narrative template to the house style for management reporting (more or less formal, particular terminology).
- Driver categories: add categories that matter for the business, such as "regulatory impact" in regulated industries or "weather" in agriculture and energy.
- Approval workflow: define who reviews and signs off variance narratives before they are distributed.
Users who want a formatted Word document ready for distribution can ask for DOCX output.