These prompts are built for FP&A analysts, FP&A managers, and finance business partners working with general-purpose AI tools. They cover the tasks that account for the largest share of FP&A time: building narratives from data, drafting variance commentary, framing scenarios, challenging assumptions, and preparing management pack content.
Each prompt is a template. Before using any prompt, replace every item in brackets with your specific numbers, account names, business unit context, and period. Generic inputs produce generic outputs. Specific inputs produce first drafts that are genuinely close to final.
Variance Analysis Prompts
Full P&L variance commentary — management accounts
Write variance commentary for the following P&L lines for [month, year]. Use a concise, factual management accounts style — one to three sentences per line, no filler phrases. Format: each line as a separate paragraph starting with the line name.
Revenue: Actual [amount] vs Budget [amount] ([variance amount, percentage])
Gross Profit: Actual [amount] vs Budget [amount] ([variance])
Sales & Marketing: Actual [amount] vs Budget [amount] ([variance])
R&D / Operations: Actual [amount] vs Budget [amount] ([variance])
G&A: Actual [amount] vs Budget [amount] ([variance])
EBITDA: Actual [amount] vs Budget [amount] ([variance])
Known drivers: [paste any context you have — open roles, one-time costs, timing items]
Variance root cause analysis
The [account name] line was [actual amount] versus budget of [budget amount], a [favorable/unfavorable] variance of [amount] or [percentage]. I want to understand the root cause. The following data is available: [paste any supporting data — invoice detail, headcount list, prior period comparison]. Identify the most likely primary driver of this variance, the secondary driver if applicable, and what additional data I would need to confirm the root cause with certainty.
Prior period comparison narrative
Write a prior period comparison narrative for [account or P&L summary] comparing [current period] to [prior period]. Current period: [amount]. Prior period: [amount]. Change: [amount and percentage]. Key structural differences between the two periods: [list anything relevant — acquisitions, headcount changes, one-time items, pricing changes]. The narrative should separate structural changes from timing items and should be suitable for the CFO's monthly review.
Variance bridge explanation
I need to explain a revenue variance bridge from budget to actual for [period]. Starting point (Budget): [amount]. Adjustments: Price effect [amount], Volume effect [amount], Mix effect [amount], Other [amount]. Ending point (Actual): [amount]. Write a clear narrative that walks through each bridge step, explains what drove it, and concludes with a one-sentence summary of the overall performance story.
Forecasting and Planning Prompts
Build a driver-based forecast narrative
I am preparing the [Q/FY] forecast. The key revenue drivers are: [list drivers with assumptions, e.g. New bookings: $X at Y% win rate, Renewals: Z% renewal rate on $A ARR]. The key cost drivers are: [list]. The resulting forecast is Revenue: [amount], Gross Margin: [percentage], EBITDA: [amount]. Draft a forecast narrative that explains the key assumptions, the main uncertainties, and the range of outcomes if the critical assumptions are wrong by plus or minus [percentage].
Rolling forecast update commentary
The rolling forecast has been updated for [period]. Versus the prior forecast, the key changes are: Revenue [change and reason], EBITDA [change and reason], Cash [change and reason]. The assumptions that changed: [list changed assumptions and why they changed]. Draft a one-page rolling forecast update summary that explains what changed, why it changed, and what the implications are for the full-year outlook.
Reforecast trigger analysis
Actual [revenue/EBITDA/cash] for [period] was [actual], versus the forecast of [forecast]. The variance is [amount] or [percentage]. Assess whether this variance is material enough to trigger a full reforecast rather than waiting for the scheduled [monthly/quarterly] update cycle. Consider: Is the variance driven by timing or structural factors? Does it change the full-year implied outcome by more than [threshold]? Are the assumptions underlying the rest of the forecast still valid?
Scenario range framing for leadership
I need to present a forecast range to leadership for [period]. Base case: [revenue, EBITDA]. Upside case: [revenue, EBITDA]. Downside case: [revenue, EBITDA]. The key differences between cases are: [list the one to three drivers that differ across scenarios]. Draft a scenario framing note that explains what each case assumes, what probability weighting I should assign to each, and how leadership should use the range in their decision-making rather than anchoring on a single number.
Budget and Planning Cycle Prompts
Department budget challenge questions
I am reviewing the [department name] budget submission for [year]. Total budget: [amount]. Year-over-year change: [amount and percentage]. Key line items: [list top items]. Generate ten specific, data-grounded questions I should ask the department head to challenge whether the budget is realistic, well-supported, and aligned with the business plan. Questions should be direct and specific, not generic.
Budget submission feedback memo
Draft a budget review feedback memo for [department name]. The submission received was: [summarize]. The issues identified are: [list — e.g. headcount assumptions not supported, cost inflation assumption below company standard, revenue growth above plan without clear driver]. The memo should be constructive, specific about each issue, and request a revised submission addressing the identified points by [date].
Planning assumption stress test
The following planning assumptions are being used for the [year] budget: [list assumptions with values]. Stress test these assumptions by identifying: (1) which two or three are most likely to be wrong, (2) what a realistic adverse scenario looks like for each, and (3) the combined EBITDA impact if all three adverse scenarios occurred simultaneously. Present the findings in a format suitable for a CFO risk review.
Full-year outlook update
Based on the following year-to-date actuals and updated assumptions, project the full-year outcome and compare it to the original budget. YTD actuals [month]: Revenue [amount], EBITDA [amount]. YTD vs budget: [variance]. Updated assumptions for the remainder of the year: [list key changes]. Calculate the implied full-year result and draft a one-paragraph full-year outlook suitable for the board pack.
Management Pack and Reporting Prompts
Management pack introduction page
Write the introduction page for the [month/quarter] management accounts pack. The pack covers [entities/business units]. Period performance summary: Revenue [actual vs budget], EBITDA [actual vs budget], Cash [position]. Key themes this period: [list 2-3]. Key issues requiring management attention: [list]. The introduction should be two to three paragraphs, written for a management team audience — direct, no jargon, focused on what matters.
Business unit performance summary
Write a business unit performance summary for [BU name] for [period]. Revenue: [actual vs budget vs prior year]. Gross Margin: [actual vs budget]. Key OpEx lines: [list with actuals vs budget]. EBITDA: [actual vs budget]. Key drivers of performance: [list]. Issues or risks for management attention: [list]. Format as a one-page summary suitable for the group management accounts, using a professional management commentary tone.
KPI dashboard commentary
Write brief commentary for the following KPI dashboard metrics for [period]. For each metric, write one sentence explaining the movement and whether it is favorable or concerning. Metrics: [list each KPI with current value, prior period value, and target]. Flag any metric where the trend over the trailing three periods suggests a structural issue rather than a one-off movement.
Finance business partner meeting prep brief
Prepare a meeting brief for a finance business partner meeting with [business unit leader name/role] of [BU name] covering [period] performance. Performance summary: [paste key metrics and variances]. Issues to raise: [list]. Questions to ask: [list]. Decisions or approvals needed: [list]. The brief should prepare the FBP to lead a commercial conversation — not just present numbers — and should include suggested talking points for each agenda item.
