Budget vs. Actuals Reviewer

FP&A analysts and finance managers use this prompt to turn raw budget vs. actuals data into a polished executive-ready management report. It is most valuable at the end of each month or quarter when the finance team needs to quickly explain variances, project the full-year outlook, and assign corrective actions before the board meeting.

You are a senior FP&A analyst preparing a budget vs. actuals review for [COMPANY NAME] covering [PERIOD] (e.g., Q2 2026 or Month 5). The output will be used in an executive management report and reviewed by the CEO and board. All amounts are in [CURRENCY].

Here is the budget vs. actuals data for [PERIOD]:
- Revenue: Budget [REVENUE BUDGET], Actual [REVENUE ACTUAL]
- Cost of Goods Sold / Cost of Revenue: Budget [COGS BUDGET], Actual [COGS ACTUAL]
- Gross Profit: Budget [GROSS PROFIT BUDGET], Actual [GROSS PROFIT ACTUAL]
- Operating Expenses by category: Budget [OPEX BUDGET BY CATEGORY], Actual [OPEX ACTUAL BY CATEGORY]
- EBITDA: Budget [EBITDA BUDGET], Actual [EBITDA ACTUAL]
- Cash position (if relevant): Budget [CASH BUDGET], Actual [CASH ACTUAL]
- Year-to-date figures (budget vs. actual): [YTD BUDGET], [YTD ACTUAL]
- Full-year budget: [FULL YEAR BUDGET]

Perform the following analysis:

1. **Top 5 Variances**
   Identify the five largest budget vs. actual variances by absolute dollar amount. Present them in a table showing: line item, budget, actual, variance ($ and %), and favorable/unfavorable flag.

2. **Executive-Ready Variance Explanations**
   For each of the top 5 variances, write a 2–3 sentence explanation covering: the root cause (not just a description of the number), any one-time vs. recurring nature of the variance, and who owns the corrective action.

3. **Full-Year Projection**
   Based on the YTD trend and [PERIOD] actuals, project the full-year outcome for revenue, gross profit, and EBITDA. State whether the business is trending ahead of, in line with, or behind the full-year budget, and by how much in dollar terms.

4. **Corrective Actions**
   For each unfavorable variance in the top 5, propose one specific corrective action with an owner, timeline, and estimated financial impact if executed.

5. **Management Summary**
   Write a 4–5 sentence executive summary of [PERIOD] financial performance, suitable for the opening paragraph of the board management report. Cover overall performance, the most significant variance, and the full-year outlook.

Prompt Variables

Replace each placeholder with your specific information:

What You'll Get

A top-5 variance table with dollar and percentage variances and favorable/unfavorable flags; root-cause explanations for each variance in 2–3 sentences; a full-year projection for revenue, gross profit, and EBITDA; corrective actions with owners and timelines; and a 4–5 sentence executive summary ready for the board management report.

💡 Pro Tip

When providing OPEX by category, include at least 5–8 line items (headcount, marketing, rent, IT, professional services, etc.) — the more granular the input, the more specific the root-cause analysis. Generic 'total OPEX' inputs produce generic variance explanations that add little value for board-level reporting.

Compatible AI Tools

Related Prompts

Related Resources