Annual Budget & Variance Explainer
Build an operating budget for the year from last year's numbers, then explain in plain words where actual results differ from it and what to do about the biggest gaps.
budget · variance · financial planning · forecast · small business finance · reporting
Export last year's profit and loss by month from your accounting tool and paste it whole. A budget built from real months beats one built from annual totals.
How to use this prompt
- Pick your AI model. Choose the tab for Claude, ChatGPT, Gemini or Copilot. Each variant is tuned for that model.
- Copy the full prompt. Click Copy Full Prompt to copy the text to your clipboard.
- Paste into your AI tool. Open your chosen model and paste the prompt into a new chat.
- Replace the [placeholders]. Swap any bracketed fields for your company name, audience, product or tone.
- Run and refine. Review the output. If anything is off, ask the AI to tighten tone, length or format.
Prompt Variants by Model
<last_full_year>
[PASTE THE LAST FULL YEAR'S INCOME AND EXPENSES, BY MONTH IF YOU HAVE IT]
</last_full_year>
<budget_year_so_far>
[PASTE ACTUAL RESULTS SO FAR IN THE BUDGET YEAR, BY MONTH, or NONE]
</budget_year_so_far>
Act as a fractional CFO for a small business. Build an operating budget for the year from the numbers above, and explain where actual results differ from it.
Business [TYPE] · budget year [YEAR] · revenue target [AMOUNT, or "HELP ME SET ONE"] · planned changes [HIRES, PRICE CHANGES, NEW COSTS, WITH DATES] · seasonality [BUSY AND SLOW MONTHS] · fixed commitments [RENT, LOANS, CONTRACTS] · what worries me [ONE LINE]
Deliver (compute every total and difference, don't estimate them):
1. Budget table by month: revenue, cost of sales, each expense category as my data names it, net, with a year total
2. The assumption behind each line, one sentence each, marked "from your data" or "assumed", so I can see which lines are fact and which are guesses
3. Variance table for the months with actuals: budget, actual, and the difference as an amount and a percent
4. The three largest variances in plain words: what moved, whether it looks like timing or a lasting change, and what to do about it
5. A one-page summary I can hand to a partner or a banker, which also answers what worries me
If my numbers are yearly totals only, spread them across the months using the seasonality I gave and mark the spread "assumed". If I asked for help with the revenue target, propose one from last year's total and my planned changes, and show the arithmetic. If I pasted no actuals for the budget year, write "no actuals yet" under 3 and 4 and show how the variance table will read once I have a month of numbers.
Success means every budget line traces to a pasted number or a labeled assumption, each planned change lands in the month I gave, the months add up to the year total, and each variance explanation names a cause I can check.
Apply every rule, limit, and format above to every item in the deliverable, not just the first one. Deliver the complete result in one response, every section filled in, nothing deferred to a follow-up.
If a required input is missing, ask for it once before starting; otherwise proceed and label any assumption you made.Notes: R54 build; tuned to vendor prompting guidance
Frequently Asked Questions
What does the Annual Budget & Variance Explainer prompt do?
Build an operating budget for the year from last year's numbers, then explain in plain words where actual results differ from it and what to do about the biggest gaps.
Which AI models is this prompt written for?
Claude, ChatGPT, Gemini and Copilot. Each one gets its own version up top, written the way that vendor says to prompt its own model. Pick the tab that matches yours.
Do I need a paid AI account to use this prompt?
No. This prompt is written to run on the free tier of Claude, ChatGPT, Gemini and Copilot. Paid tiers simply give you longer context windows and faster responses.
Can I customize this prompt for my business?
Yes. Any text inside square brackets is a placeholder you replace with your own business details, such as company name, audience, product or tone. You can also ask the AI to adjust format, length or style after the first output.
When was this prompt last checked?
The date is on each version up top. We check every prompt in full every month, and when a major new model lands we rewrite the prompt for it. One glance tells you how current it is before you paste.
Works with
More in Finance & Strategy
13-Week Cash Flow Forecast Builder
Generate a week-by-week 13-week cash flow forecast template from your current bank balance,…
SWOT-to-Strategy Action Plan
Conduct a structured SWOT analysis for your business, then use chain-of-thought reasoning to…
Dynamic Pricing Strategy Modeler
Build a pricing analysis workflow that ingests your product catalog, cost structure, competitor…