Post-Mortem Budget Variance and Forecast Bias Review

Review budget and forecast performance after period close to identify recurring bias, assumption failure, timing error, data issues, and process improvements.

Professional Prompt Template

Post-Mortem Budget Variance and Forecast Bias Review

Review budget and forecast performance after period close to identify recurring bias, assumption failure, timing error, data issues, and process improvements.

Best suited for: ChatGPT Claude Gemini
💬
Ready to Use

Complete Prompt

🪄 Prompt Playground

This prompt has variables that can be replaced with your own information. Copy and use it with your preferred LLM, or try it out in the LearnerBox Prompt Playground.

Act as a senior FP&A professional specializing in forecast accuracy and planning-process improvement.

Conduct a post-mortem review of the budget and forecast using the information provided below.

Organization:
{{organization_name}}

Review period:
{{review_period}}

Budget and forecast versions:
{{forecast_versions}}

Actual results:
{{actual_results}}

Assumptions and management commentary:
{{assumptions_commentary}}

Known events and data issues:
{{events_data_issues}}

Analysis requirements:

1. Confirm that actuals and forecast versions use consistent scope, currency, accounting definitions, and periods.
2. Calculate forecast error by:
   - revenue;
   - volume;
   - price;
   - mix;
   - gross margin;
   - OPEX;
   - headcount;
   - capital expenditure;
   - working capital;
   - cash flow; and
   - other material drivers.
3. Calculate, where sufficient data is available:
   - absolute error;
   - percentage error;
   - mean absolute percentage error;
   - weighted absolute percentage error;
   - forecast bias;
   - variance by horizon;
   - variance by owner; and
   - variance by business unit.
4. Separate errors into:
   - assumption error;
   - model error;
   - timing error;
   - execution variance;
   - external event;
   - data-quality issue;
   - scope change;
   - accounting reclassification; and
   - unexplained residual.
5. Identify systematic optimism, conservatism, sandbagging, late recognition, and repeated blind spots.
6. Compare forecast accuracy across versions and lead times.
7. Identify which assumptions were leading indicators and which were lagging or unreliable.
8. Review whether management overrides improved or reduced accuracy.
9. Develop a root-cause register showing:
   - variance;
   - owner;
   - cause;
   - evidence;
   - controllability;
   - corrective action;
   - due date; and
   - expected benefit.
10. Recommend improvements to:
    - data;
    - driver selection;
    - modeling;
    - governance;
    - review cadence;
    - challenge sessions;
    - ownership;
    - scenario planning; and
    - forecast communication.
11. Do not infer intentional manipulation without evidence.
12. Do not invent actuals, forecast versions, causes, or owner accountability.
13. Distinguish genuine uncertainty from avoidable process failure.

Present the result as:
{{output_format}}

Include:
- executive accuracy assessment;
- forecast-version comparison;
- error metrics;
- variance bridge;
- bias analysis;
- root-cause classification;
- owner and business-unit comparison;
- management-override assessment;
- recurring blind spots;
- corrective-action register;
- process-improvement recommendations; and
- priorities for the next forecast cycle.
Personalize the Template

Customization Variables

Replace each variable shown in double curly brackets with accurate information from your own professional context.

{{organization_name}}

Organization Name

Required

Example: Example: Vertex Distribution Group

Enter the organization, region, or business unit being reviewed.

{{review_period}}

Review Period

Required

Example: Example: FY2026

Specify the period for which forecast accuracy is being assessed.

{{forecast_versions}}

Budget and Forecast Versions

Required

Example: Paste original budget, quarterly forecasts, monthly forecasts, and relevant driver assumptions.

Include version dates and forecast horizons.

{{actual_results}}

Actual Results

Required

Example: Paste actual financial and operational results using the same dimensions as the forecasts.

Actuals must be comparable with the forecast versions.

{{assumptions_commentary}}

Assumptions and Management Commentary

Optional

Example: Provide major assumptions, management overrides, explanations, and confidence levels.

This allows review of both model assumptions and management judgment.

{{events_data_issues}}

Known Events and Data Issues

Optional

Example: List unexpected events, scope changes, accounting reclassifications, and data-quality problems.

Known events should be separated from avoidable planning errors.

{{output_format}}

Output Format

Required

Choose the format required for analysis, management review, or process redesign.

Detailed forecast accuracy review Executive post-mortem briefing Forecast bias dashboard specification Planning-process improvement report
What the AI Should Produce

Expected Output

🎯

A rigorous forecast post-mortem containing error metrics, variance bridges, bias analysis, root causes, owner comparisons, management-override assessment, corrective actions, and priorities for improving the next planning cycle.

💡 Important: The quality of the result depends on the completeness, accuracy, and relevance of the information supplied to the AI.
Prompt Profile

Prompt Characteristics

These characteristics describe the type of thinking, customization, and output structure involved in using this prompt effectively.

🧠 Reasoning Depth Advanced
💡 Creativity Moderate
🛠 Customization High
📚 Output Structure Highly Structured
🎓 Experience Level Advanced
Learn Why It Works

Prompt Anatomy

This breakdown explains how the prompt’s major components work together to guide the AI toward a useful, reliable, and well-structured response.

💼

Role

Positions the AI as an FP&A specialist in forecast accuracy and process improvement.

📄

Context

Combines forecast versions, actual results, assumptions, commentary, events, and data issues.

🎯

Task

Requires measurement of forecast error, bias, root causes, and planning-process weaknesses.

🛡️

Constraints

Prevents unsupported allegations, invented causes, and confusion between uncertainty and process failure.

📚

Output Structure

Requires metrics, bridges, bias analysis, root causes, actions, and next-cycle priorities.

🔑

Input Variables

Organization, review period, forecast versions, actuals, assumptions, events, data issues, and output format.

Improve the Result

Customization Tips

  1. Include every major forecast version with its issue date and horizon.
  2. Use operational drivers as well as financial outcomes to identify root causes.
  3. Separate forecast uncertainty from controllable process failures.
  4. Compare management overrides with model-only forecasts where possible.
  5. Track corrective actions into the next forecast cycle so the review changes behavior rather than merely documenting error.
🛡️
Responsible Professional Use

Review Before Applying the Output

AI-generated responses can contain errors, omissions, unsupported assumptions, outdated information, or recommendations that do not reflect your jurisdiction or professional context.

Verify calculations, evidence, regulations, standards, policies, and professional recommendations before relying on the result. The qualified professional remains responsible for the final decision.

Continue Exploring

More Budgeting & Forecasting Prompts

Return to the specialization page to explore additional professional workflows and prompt templates.

Ready to Put This Prompt to Work?

Customize the template for your professional context or open it directly in the Prompt Playground for guided AI practice.