Variance and Performance Analysis prompts for Financial Analyst
Ready-to-use AI prompts for variance and performance analysis — written for Financial Analyst and easy to paste into ChatGPT, Claude or Gemini.
When you need variance and performance analysis done, these financial analyst prompts give you a fill-in-the-blanks starting point covering variance, fp&a, budget. Fill in fields like data, period, context and paste the result into ChatGPT, Claude, or Gemini.
Explain variances to management
You are an FP&A analyst. Data:
<data>
[data]
</data>
Period: [period]. Business context: [context].
Identify material variances using both dollar and percentage thresholds (state the thresholds). For each, decompose the variance into its drivers — volume, price/rate, mix, timing, and one-off items — with the arithmetic shown.
Write management commentary: one sentence per variance stating what happened, why, and whether it repeats. Separate what the numbers prove from what the operational context suggests. List the variances you cannot explain from the data and exactly what you need to explain them. Flag any that indicate a forecast revision is required.
Build a forecast update
Act as a forecasting analyst updating the outlook. Prior forecast: [prior forecast]. Actuals to date: [actuals to date]. What has changed: [what changed]. Remaining period: [remaining period].
Produce a revised forecast: the run-rate implied by actuals, the specific assumption changes with their basis, the revised full-period number, and the bridge from the old forecast to the new one showing each driver's contribution.
Give a base, upside, and downside case with the conditions that produce each — not arbitrary percentage bands. State which changes are structural versus timing. Then name the single item most likely to move the number again before period end, and what leading indicator would give us early warning.
Investigate an unexpected number
You are an analyst investigating a surprise. The number: [the number]. Data available: [data available]. Business context: [context].
Before assuming a business explanation, work through the boring causes first: a data or ETL issue, a definition change, a period cutoff, a duplicated or missing feed, a one-off transaction, or a reclassification. Say how to check each in under an hour.
Then, if the number is real, give the business hypotheses ranked by how much of the gap each could explain, with the cut of the data that would test it (by segment, product, region, cohort, channel).
End with the order I should investigate in, and the point at which I should escalate rather than keep digging.
How to use this prompt
Fill in the blanks. Type your details into each highlighted field of this variance and performance analysis prompt — fields like data, period, context — and it rewrites itself live.
Copy the prompt. Press Copy prompt to put the finished variance and performance analysis prompt on your clipboard.
Paste into your AI model. Paste it into ChatGPT, Claude, Gemini, or any chat LLM to get your variance and performance analysis result.
Review and iterate. Read the response as a financial analyst would, then adjust fields like data, period, context and re-run to sharpen it.
Fill-in fields explained
data
actuals, budget, prior year by line item, with volumes and rates where available
period
Your period.
context
what happened operationally — headcount changes, pricing moves, one-offs, seasonality
prior forecast
figures and assumptions
actuals to date
YTD figures
what changed
operational and market changes
remaining period
months left
the number
metric, expected value, actual value, period
data available
what you can see
Frequently asked
Which AI models does the Variance and Performance Analysis prompt work with?
The Variance and Performance Analysis prompts for Financial Analyst are plain-text and model-agnostic — paste them into ChatGPT (GPT-4o), Claude, Gemini, Llama, or any other chat model.
How do I customize the Variance and Performance Analysis prompt for my own use?
Fill in the 9 labelled fields (data, period, context, …) before copying, or edit the [bracketed] text after you paste.
Are the Variance and Performance Analysis prompts for Financial Analyst free to use?
Yes. Every Variance and Performance Analysis prompt here is free to copy and reuse, including for commercial and client work, with no sign-up.