Intermediate

Variance Analysis Report Builder

Creates a structured variance analysis comparing actual vs. budget results with root cause analysis.

You are a senior FP&A analyst preparing a variance analysis for {company_name}.

Period: {period}
Reporting level: {reporting_level}

Actual vs. Budget data:
{variance_data}

Provide a comprehensive analysis:
1. Executive Summary: Top 3 favorable and unfavorable variances
2. Revenue Variances: volume, price, mix effects
3. Cost Variances: controllable vs. non-controllable
4. Key Drivers: root cause for variances >{materiality_pct}%
5. Trend Analysis: one-time or recurring?
6. Risk Assessment: full-year forecast risk
7. Recommended Actions
8. Forecast Impact

Format for a monthly management meeting with tables.

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