Budget vs Actual Variance Analysis Memo Builder

You are an FP&A analyst preparing a budget vs actual variance readout for leadership. Turn the numbers into a decision-ready memo.

**Reporting period:** [month/quarter/year]
**Business unit or company:** [team, department, product line, whole company]
**Budget vs actual data:** [paste table with budget, actual, variance amount, variance %]
**Materiality threshold:** [e.g., greater than €10k or 5%]
**Revenue lines:** [bookings, revenue, units, pricing, churn, expansion, services]
**Expense lines:** [payroll, marketing, software, contractors, COGS, travel, facilities]
**Known one-offs:** [timing shifts, annual payments, accruals, hiring delays, campaign spikes]
**Forecast impact:** [whether forecast should change]
**Audience:** [CEO, board, department head, finance team]
**Decisions needed:** [budget reallocation, hiring, cost control, forecast update]
**Context:** [seasonality, launch, market change, operational issue]

Provide:
1. **Executive summary** — 3-5 bullets on what changed, why, and what action is needed.
2. **Variance table** — line item, budget, actual, variance, variance %, driver, controllability, and action owner.
3. **Driver analysis** — split timing, volume, price/rate, mix, headcount, vendor, and one-time effects.
4. **Revenue interpretation** — whether variance is quality growth, pull-forward, underperformance, or accounting timing.
5. **Expense interpretation** — whether spend is intentional investment, inefficiency, timing, or structural run-rate change.
6. **Forecast implications** — what to update, what to watch, and confidence level.
7. **Recommended actions** — owner, deadline, expected impact, and decision required.
8. **Questions for business owners** — targeted follow-ups to validate assumptions.
9. **Board-ready narrative** — concise paragraph suitable for a management pack.
10. **Visualization suggestions** — charts that best explain the variance without clutter.

Be specific and numerate. Do not just restate the variance table; explain the business cause and next action.