financial-variance-narrator
By Agentman
Investigate and explain financial variances to stakeholders in business terms. Provides frameworks for materiality assessment, root cause investigation, and executive communication. Use when analyzing budget vs. actual, month-over-month, or forecast variances.
Accountingv
varianceanalysisbudgetforecastmaterialityexecutive-reportingfinancefluxexplanation
Skill Instructions
# Financial Variance Narrator
## Overview
Every finance team spends significant time explaining "why are we off budget?" The challenge isn't calculating the variance—it's determining what's material, investigating root causes, and translating technical explanations into business insights. This skill provides the framework for variance analysis that drives understanding and action.
## The Variance Communication Problem
```
WHAT FINANCE OFTEN DELIVERS: WHAT STAKEHOLDERS NEED:
───────────────────────────── ──────────────────────
"Revenue was $50K under budget" "We missed revenue because the
Smith deal slipped to next month.
Pipeline remains strong."
"Marketing overspent by 15%" "Marketing pulled forward Q3 spend
for the product launch, which drove
the revenue beat. Net impact positive."
"COGS increased 3%" "Supplier pricing increased. We're
renegotiating contracts. Expect
normalization by Q3."
```
## Variance Analysis Framework
```
┌─────────────────────────────────────────────────────────────────┐
│ VARIANCE ANALYSIS PROCESS │
├─────────────────────────────────────────────────────────────────┤
│ │
│ STEP 1 STEP 2 STEP 3 STEP 4 │
│ ──────── ──────── ──────── ──────── │
│ Calculate Assess Investigate Narrate │
│ Variances Materiality Root Causes & Present │
│ │
│ What's the Is it worth Why did it How do we │
│ difference? explaining? happen? explain it?│
│ │
└─────────────────────────────────────────────────────────────────┘
```
## Step 1: Calculate Variances
### Variance Types
| Comparison | Use Case | Frequency |
|------------|----------|-----------|
| **Actual vs. Budget** | Performance against annual plan | Monthly |
| **Actual vs. Forecast** | Performance against latest expectations | Monthly |
| **Month-over-Month** | Trend analysis | Monthly |
| **Year-over-Year** | Seasonality-adjusted comparison | Monthly/Quarterly |
| **Actual vs. Prior Year** | Growth analysis | Quarterly |
### Variance Calculation
```
BASIC VARIANCE:
Variance ($) = Actual - Budget/Forecast/Prior
PERCENTAGE VARIANCE:
Variance (%) = (Actual - Budget) / Budget × 100
FAVORABLE VS. UNFAVORABLE:
Revenue: Actual > Budget = Favorable (F)
Actual < Budget = Unfavorable (U)
Expenses: Actual < Budget = Favorable (F)
Actual > Budget = Unfavorable (U)
```
### Variance Summary Template
```
VARIANCE SUMMARY
────────────────
Period: [Month/Year]
Comparison: [vs Budget / vs Forecast / vs Prior Month]
┌─────────────────────┬──────────┬──────────┬──────────┬─────────┐
│ Line Item │ Actual │ Compare │ Var ($) │ Var (%) │
├─────────────────────┼──────────┼──────────┼──────────┼─────────┤
│ Revenue │ │ │ │ │
│ Product │ │ │ │ │
│ Services │ │ │ │ │
│ Total Revenue │ │ │ │ │
├─────────────────────┼──────────┼──────────┼──────────┼─────────┤
│ COGS │ │ │ │ │
│ Gross Profit │ │ │ │ │
│ Gross Margin % │ │ │ │ │
├─────────────────────┼──────────┼──────────┼──────────┼─────────┤
│ Operating Expenses │ │ │ │ │
│ Sales & Marketing │ │ │ │ │
│ R&D │ │ │ │ │
│ G&A │ │ │ │ │
│ Total OpEx │ │ │ │ │
├─────────────────────┼──────────┼──────────┼──────────┼─────────┤
│ Operating Income │ │ │ │ │
│ Operating Margin % │ │ │ │ │
└─────────────────────┴──────────┴──────────┴──────────┴─────────┘
```
## Step 2: Assess Materiality
### Materiality Thresholds
```
CUSTOMIZATION REQUIRED:
┌─────────────────────────────────────────────┐
│ Your materiality thresholds: │
│ │
│ ABSOLUTE: │
│ Explain if variance > $________ │
│ │
│ PERCENTAGE: │
│ Explain if variance > ____% │
│ │
│ BOTH REQUIRED (either triggers): │
│ > $________ AND > ____% │
│ │
│ AUTOMATIC EXPLANATION (regardless): │
│ □ Revenue (any material variance) │
│ □ Gross margin │
│ □ Operating income │
│ □ New line items │
│ □ ________________________ │
└─────────────────────────────────────────────┘
```
### Materiality Assessment Matrix
| Variance Size | Impact on Key Metrics | Requires Explanation |
|---------------|----------------------|---------------------|
| Small ($) + Small (%) | No impact | No |
| Small ($) + Large (%) | May distort ratios | Maybe (context) |
| Large ($) + Small (%) | Budget was large | Yes |
| Large ($) + Large (%) | Significant miss | Yes (detailed) |
### Materiality Decision Tree
```
IS VARIANCE MATERIAL?
│
▼
┌────────────────────────────┐
│ Exceeds $ threshold? │
└───────────┬────────────────┘
│ │
YES NO
│ │
▼ ▼
EXPLAIN ┌────────────────────────┐
│ Exceeds % threshold? │
└───────────┬────────────┘
│ │
YES NO
│ │
▼ ▼
EXPLAIN ┌────────────────────────┐
│ Key metric impacted? │
│ (gross margin, etc.) │
└───────────┬────────────┘
│ │
YES NO
│ │
▼ ▼
EXPLAIN NO EXPLANATION
NEEDED
```
## Step 3: Investigate Root Causes
### Root Cause Categories
| Category | Description | Investigation Approach |
|----------|-------------|----------------------|
| **Volume** | Units sold/produced | Compare volume actual vs. plan |
| **Price** | Price per unit | Check pricing, mix |
| **Mix** | Product/customer mix | Analyze composition |
| **Timing** | When recognized | Check period allocation |
| **Rate** | Cost rates | Review contracts, rates |
| **Efficiency** | Productivity | Analyze utilization |
| **One-time** | Non-recurring items | Isolate and explain |
| **Error** | Booking mistake | Correct and explain |
### Revenue Variance Analysis
```
REVENUE VARIANCE DECOMPOSITION
──────────────────────────────
Total Revenue Variance: $________
DECOMPOSE INTO:
1. VOLUME VARIANCE
(Actual Units - Budget Units) × Budget Price
= ________ units × $________ = $________
Why volume differs: _______________________
2. PRICE VARIANCE
(Actual Price - Budget Price) × Actual Units
= $________ × ________ units = $________
Why price differs: _______________________
3. MIX VARIANCE
Impact of product/customer mix shift
= $________
What shifted: _______________________
TOTAL: $________ (should equal total variance)
```
### Expense Variance Analysis
```
EXPENSE VARIANCE DECOMPOSITION
──────────────────────────────
Account: [Account Name]
Total Variance: $________
DECOMPOSE INTO:
1. PLANNED SPENDING SHIFT
Did we intentionally spend more/less?
Amount: $________
Reason: _______________________
2. TIMING DIFFERENCE
Did spending move between periods?
Amount: $________
What period: _______________________
3. RATE/PRICE CHANGE
Did unit costs change?
Amount: $________
Reason: _______________________
4. VOLUME/ACTIVITY CHANGE
Did we do more/less activity?
Amount: $________
Reason: _______________________
5. ONE-TIME/UNUSUAL
Non-recurring items?
Amount: $________
What: _______________________
TOTAL: $________ (should equal total variance)
```
### Investigation Checklist
```
VARIANCE INVESTIGATION CHECKLIST
────────────────────────────────
REVENUE VARIANCES:
□ Check bookings/orders vs. plan
□ Review customer wins/losses
□ Analyze deal slippage
□ Check pricing deviations
□ Review product mix
□ Verify revenue recognition timing
□ Check for one-time items (refunds, credits)
COGS VARIANCES:
□ Check volume impact
□ Review supplier pricing changes
□ Analyze product mix impact
□ Check for scrap/waste issues
□ Review inventory adjustments
□ Check for one-time charges
OPEX VARIANCES:
□ Compare to spending plan
□ Check for timing shifts
□ Review headcount vs. plan
□ Check contractor/consulting spend
□ Review travel and events
□ Identify one-time items
□ Check for accrual adjustments
```
## Step 4: Narrate and Present
### Narrative Structure
```
VARIANCE EXPLANATION STRUCTURE
──────────────────────────────
1. STATE THE VARIANCE (1 sentence)
"[Line item] was [over/under] [budget/forecast/prior] by
[$X] ([X%])."
2. EXPLAIN THE PRIMARY DRIVER (1-2 sentences)
"This was primarily due to [root cause], which
[impacted/contributed] [$X]."
3. PROVIDE CONTEXT (1-2 sentences)
"This [was expected / was unexpected] because [context].
[Business implication]."
4. STATE THE OUTLOOK (1 sentence)
"We expect [this to continue / to normalize / to reverse]
in [timeframe] because [reason]."
```
### Narrative Examples
```
GOOD NARRATIVE:
"Marketing expense was $75K (18%) over budget. This was
primarily due to pulling forward the product launch campaign
from Q3, which contributed $60K. The remaining $15K was
higher event costs than planned. This investment supported
the $200K revenue beat this month. We expect marketing to
be under budget in Q3 due to this timing shift."
---
BAD NARRATIVE:
"Marketing was over budget by $75K."
---
WHY IT'S BAD:
- No root cause
- No context
- No business connection
- No outlook
```
### Executive Summary Format
```
FINANCIAL VARIANCE SUMMARY
──────────────────────────
Period: [Month Year]
HEADLINES:
• [Key takeaway #1 - usually bottom line]
• [Key takeaway #2 - most significant variance]
• [Key takeaway #3 - notable item or outlook]
SUMMARY BY AREA:
REVENUE: [$ vs Budget] ([%])
[1-2 sentence narrative]
GROSS MARGIN: [% actual vs % budget]
[1-2 sentence narrative]
OPERATING EXPENSES: [$ vs Budget] ([%])
[1-2 sentence narrative]
OPERATING INCOME: [$ vs Budget] ([%])
[1-2 sentence narrative]
KEY ITEMS TO WATCH:
• [Item that may impact future periods]
• [Risk or opportunity identified]
```
### Variance Commentary Template
```
VARIANCE COMMENTARY
───────────────────
Line Item: [Name]
Actual: $________ Budget: $________ Variance: $________ (___%)
NARRATIVE:
[Line item] was [favorable/unfavorable] to budget by [$X] ([X%]).
PRIMARY DRIVERS:
1. [Driver #1]: $________ impact
[Explanation]
2. [Driver #2]: $________ impact
[Explanation]
BUSINESS CONTEXT:
[Why this matters / connection to business activities]
OUTLOOK:
[Expected trend going forward]
STATUS: □ Expected □ Unexpected □ One-time □ Ongoing
```
## Presentation Tips
### For Different Audiences
| Audience | Focus | Detail Level | Time |
|----------|-------|--------------|------|
| Board | Key metrics, trends, risks | High-level | 5 min |
| CEO/CFO | Bottom line, major drivers, outlook | Summary + key details | 10-15 min |
| Department Heads | Their area detail | Detailed their area | 15-20 min |
| Accounting Team | All variances | Full detail | As needed |
### Communication Guidelines
```
DO:
✓ Lead with the bottom line
✓ Quantify impacts
✓ Explain business context
✓ Acknowledge surprises
✓ Provide outlook
✓ Connect to actions
DON'T:
✗ Just state numbers without context
✗ Blame other departments
✗ Hide unfavorable news
✗ Over-explain immaterial items
✗ Use accounting jargon
✗ Leave questions unanswered
```
### Handling Questions
```
COMMON QUESTIONS AND PREPARATION:
"Why didn't we see this coming?"
→ Prepare: What was known vs. unknown
"What are we doing about it?"
→ Prepare: Actions being taken
"Will this continue?"
→ Prepare: Outlook with rationale
"Who is responsible?"
→ Prepare: Facts, not blame
"What's the full-year impact?"
→ Prepare: Forecast implications
```
## Variance Tracking Over Time
### Trend Analysis
```
VARIANCE TREND TRACKER
──────────────────────
Line Item: [Name]
┌─────────┬─────────┬─────────┬─────────┬─────────┬─────────┐
│ Month │ Jan │ Feb │ Mar │ Apr │ YTD │
├─────────┼─────────┼─────────┼─────────┼─────────┼─────────┤
│ Actual │ │ │ │ │ │
│ Budget │ │ │ │ │ │
│ Var ($) │ │ │ │ │ │
│ Var (%) │ │ │ │ │ │
├─────────┼─────────┼─────────┼─────────┼─────────┼─────────┤
│ Trend │ ── │ ↑/↓ │ ↑/↓ │ ↑/↓ │ │
└─────────┴─────────┴─────────┴─────────┴─────────┴─────────┘
PATTERN IDENTIFIED:
□ One-time (no trend)
□ Improving
□ Worsening
□ Consistent offset
□ Volatile
IMPLICATIONS:
[What the trend means for forecast/planning]
```
## Resources
### references/
- **variance-investigation-guide.md** — Detailed investigation procedures
- **narrative-examples.md** — Sample variance narratives by line item
- **presentation-templates.md** — Slide templates for variance reviews
### scripts/
- **variance-calculator.py** — Calculates variances and flags material items
- **trend-analyzer.py** — Analyzes variance patterns over time
### assets/
- **variance-analysis-template.xlsx** — Complete variance analysis workbook
- **executive-summary-template.pptx** — Presentation template
- **commentary-template.docx** — Variance commentary documentIncluded Files
- SKILL.md(17.9 KB)
- _archive/skill-package.zip(5.9 KB)
Related Skills
audit-readiness-preparer
Prepare for external audits with organized documentation, anticipated questions, and process readiness. Covers financial statement audits, SOX testing, and interim reviews. Use before audit fieldwork to ensure smooth, efficient audit process.
expense-policy-adjudicator
Apply expense policies to edge cases and approve/deny reimbursement requests consistently. Provides decision frameworks for common gray areas and escalation paths. Customize with your company's specific policy limits and approval thresholds.
month-end-close-orchestrator
Orchestrate the month-end financial close process with checklists, dependencies, timing, and sign-offs. Ensures consistent, timely close with proper controls. Customize with your company's specific accounts, deadlines, and responsibilities.
Ready to use this skill?
Connect this skill to your AI assistant or attach it to your Agentman agents.
Try Now
Or use with Agentman