These 14 budget planning prompts help you sort transactions into categories, build a personal, team or project budget, question the assumptions behind each number, and track budget against actuals during the year. They are built to organize and challenge your numbers, not to give financial advice: the model shows its working, flags what it assumed and leaves every decision with you.
How to use these prompts
Each prompt works in ChatGPT, Claude or Gemini. Replace the blanks in double braces, or keep the default after the colon: {{currency:USD}} means US dollars unless you change it.
Bring real numbers. A budget built from "about $2,000 on rent" is a guess with decimals. Export the last 3 to 12 months of spending or last year's actuals, remove account numbers and names, and paste totals by category where you can.
Make the spreadsheet do the math. Several prompts ask for formulas instead of totals. Models can slip on arithmetic across long tables, and a formula is easy to check. If you work in Excel or Google Sheets a lot, the Excel formula prompts go deeper.
Ask it to show its assumptions. OpenAI's prompt guide for everyday work suggests two guardrails for high-stakes output: "Label anything uncertain with (needs verification)" and "Before finishing, list any assumptions you made." Both are built into the prompts below.
Which prompts organize your numbers?
1. Sort transactions into categories
The first step for any budget: turn a messy export into categories you can reason about.
Here is a list of transactions (date, description, amount) with account
numbers removed:
{{transactions}}
Sort each one into these categories: {{categories:housing, utilities, groceries, transport, insurance, subscriptions, eating out, debt payments, savings, other}}.
Return a table with category, monthly total and number of transactions.
List every transaction you weren't sure about separately, with your best
guess and why, instead of forcing it into a category. Don't comment on
whether any spending is good or bad.
2. Separate one-time and recurring costs
The SBA's guide to calculating startup costs suggests organizing expenses into one-time expenses and monthly expenses. The split helps any budget, not just a new business.
Here are the costs for {{scope:our first year of running the business}}:
{{costs}}
Split them into: one-time costs, monthly recurring costs, annual or
irregular costs (convert these to a monthly amount too), and costs that
vary with sales or usage. Show a table per group with totals. Flag any cost
where you can't tell which group it belongs to, and ask me instead of
guessing.
3. Spreadsheet layout with formulas
A structure you paste into a sheet, where every total is a formula you can audit.
Design a budget spreadsheet for {{purpose:a household monthly budget}} in
{{tool:Google Sheets}}.
Categories: {{categories}}
Columns I want: {{columns:budget, actual, difference, percent of income}}
Give me: the sheet layout (which rows and columns hold what), the exact
formula for each calculated cell using cell references, and conditional
formatting rules to highlight categories over budget. Use formulas for
every total. Don't fill in numbers I haven't given you; leave them blank.
Which prompts build a budget?
4. Monthly personal budget from your numbers
Builds a plan from income and spending you already have. The CFPB's Your Money, Your Goals toolkit includes a spending tracker, a bill calendar and a cash flow budget tool if you prefer a paper or PDF worksheet.
Here is my monthly take-home income and my spending by category for the
last {{months:3}} months (in {{currency:USD}}):
{{income_and_spending}}
My goals for the budget: {{goals:build a 3-month emergency fund, stop going over on eating out}}
Draft a monthly budget table: category, average actual, proposed budget,
difference. Show the total of income minus planned spending. Explain each
change in one line, and show the trade-off it creates. Don't recommend
financial products, investments or debt strategies. List the questions I
should answer before committing to this plan.
5. Team or department budget request
For the annual planning spreadsheet that needs a story behind it.
Draft a budget request for {{team:the platform engineering team}} for
{{period:fiscal year 2027}}.
Last year's actuals by line: {{actuals}}
Planned changes (hires, tools, projects): {{changes}}
Company guidance: {{guidance:hold flat except for approved hires}}
Return: a table of each line with last year, proposed and change; one line
of justification per change tied to a goal; the 3 lines most likely to be
questioned and the evidence we'd need for each; and what we would drop
first if asked to cut {{cut:10%}}. Mark every number you estimated.
6. Project budget with a contingency line
For a one-off project: an event, a website rebuild, a renovation.
Build a budget for this project: {{project:rebuilding our marketing site with an agency}}.
Known costs and quotes: {{quotes}}
Timeline: {{timeline:4 months}}
Contingency I want to hold: {{contingency:15%}}
List every cost line grouped by phase, including the ones that are easy to
forget (taxes, fees, internal time, licenses, post-launch fixes). Mark each
line as quoted, estimated or unknown. Show the subtotal, the contingency
amount and the total. List what I need to get a quote for before this
budget is reliable.
7. Monthly cash timing
A yearly total can hide a month when money runs short.
Here is our budget for {{period:the next 12 months}} with expected income
and costs:
{{budget}}
Payment timing I know about: {{timing:customers pay 30 days after invoice, annual software renewals in January, insurance paid quarterly}}
Lay out income and costs month by month with a running cash balance
starting from {{starting_cash}}. Highlight any month where the balance goes
below {{floor:zero}}. Show the formulas or the calculation for each month.
Don't suggest financing options.
Which prompts question the numbers?
8. Assumption audit
Every budget is a stack of assumptions. This prompt writes them down.
Here is a draft budget:
{{budget}}
List every assumption behind it: prices, volumes, growth rates, start dates,
headcount, timing. For each, say where the number seems to come from in my
notes, or mark it "no source". Rank the assumptions by how much the total
changes if each one is wrong by {{error:20%}}. Ask me the 5 questions that
would most improve the budget.
9. Find the missing costs
A second pair of eyes for lines nobody added.
Here is a budget for {{scope:launching a small online store}}:
{{budget}}
What costs are commonly part of a budget like this that are missing here?
Group them as likely missing, possibly missing and probably not relevant.
For each, explain why it might apply. Don't add amounts; I will get real
figures. Ask me about anything that depends on my location or situation.
10. Low, base and high scenarios
Shows how wrong the budget can be before it becomes a problem.
Using this budget:
{{budget}}
And these key drivers with my best guess, a low case and a high case:
{{drivers}}
Build three scenarios: low, base and high. Show the totals for each in a
table and the calculation behind them. Then show which single driver moves
the result most. Keep my numbers; don't invent new drivers without asking.
11. Break-even check
The SBA explains the break-even point in units as fixed costs divided by the sales price per unit minus the variable cost per unit. This prompt runs that check and shows each step.
Run a break-even check with these numbers (in {{currency:USD}}):
Fixed costs per {{period:month}}: {{fixed_costs}}
Sales price per unit: {{price}}
Variable cost per unit: {{variable_cost}}
Expected unit sales per {{period:month}}: {{expected_units}}
Show: the break-even point in units and in sales, the calculation step by
step, how far expected sales are above or below break-even, and how the
break-even point changes if price or variable cost moves by {{change:10%}}.
Point out any number that looks inconsistent with the others.
Which prompts track the budget during the year?
12. Budget versus actual
The monthly check that keeps a budget useful after the planning meeting.
Here is our budget and actual spending for {{period:the first quarter}}:
{{budget_vs_actual}}
For each line: the difference in amount and percent, and whether it is a
timing difference (spent earlier or later than planned) or a real over- or
underspend, based on my notes: {{notes}}. List lines over budget by more
than {{threshold:10%}} first. Ask me about any variance you can't explain
from the notes instead of guessing a reason.
13. Mid-year reforecast
Updates the full-year view without rewriting history.
Original full-year budget: {{budget}}
Actuals to date ({{months_done:6}} months): {{actuals}}
Known changes for the rest of the year: {{changes}}
Produce a reforecast table: line, original budget, actual to date, forecast
for remaining months, new full-year total, difference from original. Show
how you calculated each remaining-months forecast. Separate changes I told
you about from trends you projected, and mark the projections as
assumptions.
14. One-page budget summary for non-finance readers
For the team, a board or a partner who won't open the spreadsheet.
Write a one-page summary of this budget for {{audience:the whole team}}:
{{budget}}
Include: the total and how it compares with last period, where most of the
money goes (top 5 lines), the biggest changes and why, the main risks or
assumptions, and what we'll review and when. Plain language, no jargon,
under {{words:300}} words. Use only numbers from the budget and don't round
in ways that change the story.
Why don't these prompts give financial advice?
Because a model doesn't know your situation and isn't accountable for the outcome. It has never seen your contracts, tax position, debts or obligations unless you paste them, and even then it can misread them. The prompts above ask it to organize, calculate and question, which are jobs where its mistakes are visible and checkable.
Check the numbers yourself. Anthropic's guide to reducing hallucinations recommends giving the model permission to say it doesn't know, and notes that even with those techniques, "Always validate critical information, especially for high-stakes decisions." For a budget, that means checking that totals add up and that no number appeared that you never gave it.
Get qualified help for the big calls. Tax treatment, borrowing, investing and anything with legal consequences belong with an accountant or financial professional. The SBA's own startup costs page, for example, tells readers to talk to their accountant when it is time to file taxes.
Make your favorite one a skill
If you run the same budget versus actual check every month, turn the prompt into a skill with your categories and thresholds built in, so Claude, Claude Code or Codex applies them every time. Paste it into the free SKILL.md generator. For digging into the exported data itself, see the data analysis prompts.
To keep these ready for planning season, save them in Kipt with their blanks, tag them by job (organize, build, question, track) and press Cmd+K to find one. Your library lives as Markdown in a private GitHub repo you own.