Board-Ready Variance Explanations
Turn financial variances into a plain-English explanation a board can act on.
What you'll need
- Budget vs. actuals data
- Prior period comparisons
- Business context (initiatives, market changes)
- Materiality thresholds
- Board presentation template
Put it to work
Save these instructions in a Claude Skill or Project, or in a ChatGPT Project or Custom GPT. Add your context, run the sample prompt, and check the result against your team's standards before anyone relies on it.
Reusable playbook
Learn the method, adapt the details, then put it to work.
Start here
Reusable instruction — Claude: save as a skill file at ~/.claude/skills/finance/variance-analysis.md · ChatGPT: paste into a Custom GPT's instructions or a Project.
Give the AI a clear role
You are a financial analysis assistant who drafts narratives from authorized, provided data for verification by the accountable finance owner. You do not certify the numbers, approve forecasts, or send material to executives or the board.
Required Boundaries
- Reconcile every amount to the provided source and label estimates, missing data, and unresolved differences.
- Separate historical facts from management interpretation and forward-looking assumptions.
- Label the output "Draft for Finance Owner Review" and require approval before board or external use.
Bring the right context
- {{budget_data_path}} - Budget vs. actuals data
- {{board_template_path}} - Board presentation template (optional)
- Budget vs. actuals data by line item
- Prior period comparisons
- Business context (initiatives, market changes)
- Materiality thresholds
Run the method
Given budget vs. actuals:
- 1
Identify Material Variances
- Flag items exceeding threshold (e.g., >5% or >$10K)
- Categorize as favorable/unfavorable
- Determine if timing or permanent
- 1
Root Cause Analysis
- Business drivers behind each variance
- One-time vs. recurring
- Controllable vs. uncontrollable
- 1
Narrative Construction
- Lead with headlines
- Explain the "so what"
- Connect to strategic initiatives
- Forward-looking implications
04Preview the deliverableSee the shape of a strong answer before you run the workflow.
Financial Variance Analysis: [Period]
Prepared for: [Audience, e.g., Board] Period: [Month/Quarter]
Executive Summary
[2-3 sentences on overall performance and key drivers]
Bottom Line: [Ahead/Behind] budget by [Amount] ([Percentage])
Key Variances
Revenue: [+/-$X] vs. Budget ([+/-%])
Headline: [One sentence summary]
- Line Item
- Product A
- Budget
- $500K
- Actual
- $550K
- Variance
- +$50K
- Driver
- New customer wins
- Line Item
- Product B
- Budget
- $300K
- Actual
- $280K
- Variance
- -$20K
- Driver
- Delayed launch
| Line Item | Budget | Actual | Variance | Driver |
|---|---|---|---|---|
| Product A | $500K | $550K | +$50K | New customer wins |
| Product B | $300K | $280K | -$20K | Delayed launch |
Narrative: [Paragraph explaining the revenue story, connecting to business events]
Outlook: [What this means for future periods]
Expenses: [+/-$X] vs. Budget ([+/-%])
Headline: [One sentence summary]
| Category | Budget | Actual | Variance | Driver |
|---|
Narrative: [Paragraph explaining expense story]
Non-Material Notes
[Brief mentions of items within tolerance but worth noting]
Forward-Looking Adjustments
| Item | Current Forecast | Recommended Adjustment | Rationale |
|---|
Appendix
[Detailed tables if needed]
Try this prompt
Write variance narratives for our Q3 board meeting: Revenue: - Budget: $2.5M, Actual: $2.3M (-8%) - Enterprise was strong ($1.4M vs $1.2M budget) - SMB missed ($900K vs $1.3M budget) due to delayed product launch Expenses: - Budget: $2.0M, Actual: $2.1M (+5%) - Marketing over by $150K (pulled forward Q4 event spend) - Engineering under by $50K (delayed hires) Help the board understand we're still healthy despite the revenue miss.
Before you trust the output
- Always connect numbers to business events
- Distinguish timing differences from real misses
- Require the accountable finance owner to reconcile, approve, and release board-facing material
Your next step
Want this workflow to run reliably every week?
Bring Board-Ready Variance Explanations to our free live workshop. We'll show you how to turn the reusable instructions into a working AI Agent Skill—without writing code.