Variance Analysis Skill
Automates budget-vs-actual variance analysis with driver decomposition and an FP&A narrative.
Before & after
Same prompt, same agent — the only difference is the skill.
To understand your EBITDA miss, you'll want to analyze the variance between budget and actuals across your key line items. Start by comparing: - Revenue vs. budget - Cost of goods sold - Operating expenses (payroll, marketing, G&A) For each line, calculate the variance and identify which had the biggest impact. Revenue misses often come from lower volume or pricing, while expense overruns can come from unplanned hires or one-time costs. Once you know where the variance is concentrated, you can dig into the drivers. Do you have the budget-vs-actual numbers available?
EBITDA BRIDGE — Q3 Budget vs Actual Materiality filter: variances over $25K or 5% shown; rest rolled to Other. Budget EBITDA .......................... $1,840K ─────────────────────────────────────────────── Revenue — volume −$310K ← the story is here Revenue — price +$140K Revenue — mix − $60K COGS — volume-driven +$180K (flows with the volume miss) Payroll — headcount −$220K Payroll — timing + $90K Marketing − $70K Other (below threshold) − $30K ─────────────────────────────────────────────── Actual EBITDA .......................... $1,600K miss: $240K WHAT THE DECOMPOSITION SAYS THAT THE TOTAL HIDES The $240K miss is NOT a spending problem. It's a volume problem partly masked by good pricing. Revenue: you lost $310K on volume but clawed $140K back on price — you held or raised prices into a soft quarter. Net revenue driver is −$230K, and it's demand, not discounting. Payroll: −$220K headcount looks like an overrun, but +$90K of timing says planned hires landed early, not that you overspent on comp. Net −$130K, and it's a phasing issue that reverses. COGS +$180K is favorable and mechanical — you sold less, so you spent less to make it. Not a win, just the other side of the volume miss. THE ONE SENTENCE FOR THE BOARD "We missed by $240K driven almost entirely by lower volume ($230K net of a favorable pricing offset); the payroll variance is early hiring timing that normalizes in Q4, not a structural cost overrun." WHERE TO LOOK NEXT The volume miss. Price held, so this isn't a competitiveness problem — it's pipeline or seasonality. Pull the volume variance by product line and I'll tell you if it's concentrated or broad.
About this skill
name: variance-analysis-finance description: Use when Automates budget-vs-actual variance analysis with driver decomposition and an FP&A narrative.
Variance Analysis Skill
Reconciles actuals to budget, filters for materiality, decomposes revenue into price/volume/mix and payroll into headcount/timing, builds an EBITDA bridge, and writes executive-ready commentary, turning a multi-day FP&A task into minutes.
What you get
- Available in the official finance plugin
- outputs an executive variance package.
Customize your output
- Point it at your own workbooks/datasets and adapt the output structure to your reporting standards.
Example output
An EBITDA bridge and driver breakdown with leadership commentary.
Best for
FP&A analysts, controllers, and CFOs.
SKILL.md preview
---
name: variance-analysis-finance
description: Use this skill when an FP&A team needs budget-vs-actual variance analysis with driver decomposition and executive-ready narrative commentary.
version: 1.0.0
category: Finance / FP&A
author: AgentVolt
license: proprietary
tags:
- finance
- fp-a
- flagship
---
# Variance Analysis Skill
Reconciles actuals to budget, decomposes material variance drivers, and writes the executive narrative — turning a multi-day FP&A task into minutes.
## When to use
… (sign up to view the full skill)More finance skills
View all Finance skills →Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.
Personal Finance Q&A
Ask any personal-finance question and get a plain-English answer tailored to your bracket, timeline, and risk appetite.
Earnings Report Analyzer
Paste a 10-K, 10-Q, or earnings call transcript — get the numbers that matter, the narrative changes, and what the CFO tried to bury.
Investment Memo Writer
Drafts a structured investment or deal memo from your inputs.