Beginner

Monthly variance analysis: budget vs actual with bridges

Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.

Perform monthly variance analysis for {period}.

Inputs:
- Actuals P&L: {actuals}
- Budget/forecast P&L: {budget}
- Volume metrics (units, users, hours): {volume_metrics}
- FX rates (if relevant): {fx_rates}
- Known events: {known_events}
- Thresholds: {abs_threshold} and {pct_threshold}

Output:
1) Variance table by line item with flags.
2) Bridge analysis for key lines (revenue, COGS, labor, marketing).
3) Narrative explanations for flagged items (2–4 sentences each).
4) Follow-up questions and owner assignments.

Keep it concise and numbers-first.

Related Prompts

Management Accounting & FP&A

Intermediate

Driver-based budget model template (revenue, headcount, opex)

Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Management Accounting & FP&A

Intermediate

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Management Accounting & FP&A

Beginner

Budget kickoff pack: timeline, owners, templates, instructions

Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.

GPT-5.2 Thinking; GPT-4.1; o3-mini