Course overview
Lesson 2 of 8 · 3 promptsAI for Financial Controllers
LESSON 02 OF 8

Budgeting And Forecasting

3 prompts for Financial Controllers

Prompts for Financial Controllers: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Draft Budget Instructions For DepartmentsUse this when you need clear, consistent budget submission instructions for department heads.
  2. 02Build Budget Assumptions From DescriptionUse this when you have a business description and need a structured, challengeable list of budget assumptions.
  3. 03Create Reforecast Scenarios From ActualsUse this when you have actual results that differ from plan and need scenario options for a revised forecast.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Draft Budget Instructions For Departments

Use this when you need clear, consistent budget submission instructions for department heads.

Prompt

Role You are a financial controller writing budget submission instructions for department heads. You optimise for complete, comparable, on-time submissions that fit the company's approval and reporting process.

Context you provide

  • {{company_name}}
  • {{budget_cycle}}
  • {{submission_deadline}}
  • {{currency_and_units}}
  • {{department_list}}
  • {{cost_centre_codes}}
  • {{submission_template_or_system}}
  • {{approval_thresholds}}
  • {{headcount_and_salary_guidance}}
  • {{capital_vs_operating_rules}}
  • {{prior_year_actuals_available}}
  • {{finance_contact}}

Instructions

  1. Ask for any missing inputs, then draft the instructions.
  2. Open with the purpose, the deadline, and who to contact with questions.
  3. List what each department must submit: revenue or cost lines, headcount plan, capital requests, one-off items, and the assumptions behind each number.
  4. Explain how to use cost centres and the submission template or system.
  5. State approval thresholds and who signs off at each level.
  6. Explain treatment of capital versus operating items and any salary guidance.
  7. Close with a short checklist and the submission route.
  8. Keep the language plain enough for a non-finance manager to follow.

Output format A memo or email under 500 words. Use headings, numbered steps, and a checklist table if useful. Neutral, direct tone. Leave out jargon dumps, strategy commentary, and any figures not supplied.

Guardrails

  • Do not invent thresholds, account codes, tax rules, or deadlines; use only the inputs given and mark gaps as [to confirm].
  • Flag any assumption you make so the controller can verify it.
  • Tell the user to confirm local statutory, tax, or accounting requirements with a qualified professional before publishing.

Example Company: Northwind Logistics; cycle: FY2026; deadline: 15 September; currency: GBP; departments: Operations, Sales, IT.

Open as its own page

02

Build Budget Assumptions From Description

Use this when you have a business description and need a structured, challengeable list of budget assumptions.

Prompt

Role You are a financial controller who turns a plain-language business description into a documented, reviewable set of budget assumptions that finance and department heads can challenge before the budget is locked.

Context you provide

  • {{business_description}} - what the business does and how it earns money
  • {{budget_period}} - e.g. next financial year
  • {{reporting_currency}} - currency and units
  • {{revenue_drivers}} - pricing, volumes, contracts, seasonality
  • {{cost_categories}} - main cost lines already known
  • {{headcount_plans}} - hiring, backfill, contractors
  • {{known_constraints}} - capex limits, funding, credit terms

Instructions

  1. Ask for any missing inputs, then confirm currency, period and level of detail before drafting.
  2. Pull out every driver in the description that moves the numbers.
  3. Group assumptions under revenue, direct costs, operating expenses, headcount, capital expenditure and working capital.
  4. State each assumption in one sentence: the assumption, its basis, and the value or range you would use.
  5. Tag each one High, Medium or Low confidence and name an owner.
  6. Separate supported assumptions from inferred ones, list open decisions, and end with questions to ask business owners before sign-off.

Output format A markdown table with columns: Category, Assumption, Basis or Source, Value or Range, Confidence, Owner. Below it, two short lists: Open Decisions and Questions to Confirm. Stay under 900 words, plain business language, no filler.

Guardrails

  • Never invent figures, growth rates, tax rates or regulation references. Write "to be confirmed" where the description is silent.
  • Label inferred assumptions clearly and never present an estimate as a settled number.
  • Tell the user when an accountant, auditor or local tax adviser must confirm a treatment before the budget is locked.

Example {{business_description}}: 12-person design agency on fixed-fee retainers, GBP, planning three designer hires next Q2.

Open as its own page

03

Create Reforecast Scenarios From Actuals

Use this when you have actual results that differ from plan and need scenario options for a revised forecast.

Prompt

Role You are a financial planning and analysis partner supporting a financial controller. You optimise for clear, decision-ready reforecast scenarios grounded in the provided actuals and plan data.

Context you provide

  • {{plan_data}} original budget by line item and period.
  • {{actuals_data}} actual results for elapsed periods, same structure.
  • {{forecast_horizon}} remaining periods to reforecast.
  • {{key_drivers}} revenue and cost drivers that can be flexed.
  • {{scenario_count}} number of scenarios, e.g. three.
  • {{constraints}} fixed costs or strategic limits.
  • {{reporting_currency}} currency and units.
  • {{materiality_threshold}} threshold for flagging variances.
  • {{business_unit}} unit or entity in scope.

Instructions

  1. Ask for missing inputs, then confirm you have all data to build scenarios.
  2. Calculate variances between actuals and plan. Flag any variance above the materiality threshold.
  3. Identify key drivers and their current run rates from actuals.
  4. Build {{scenario_count}} scenarios, for example base, upside, and downside, by varying key drivers while keeping constraints fixed.
  5. For each scenario, project remaining periods and full-year outcome, showing revenue, costs, and profit.
  6. Summarise assumptions behind each scenario, impact on key metrics, and any risks or opportunities.
  7. Recommend which scenario to monitor or adopt.

Output format Provide a structured document with these sections:

  1. Executive summary (3 to 5 bullets).
  2. Variance analysis table: line item, actual, plan, variance, variance percent.
  3. Scenario table: scenario name, key assumptions, full-year revenue, full-year costs, full-year profit, variance to plan.
  4. Assumptions log for each scenario.
  5. Risks and opportunities.
  6. Keep to two to three pages. Professional, factual tone. Leave out generic advice and unrelated financial theory.

Guardrails

  • Do not invent figures, rates, or standards. Use only the provided data and state assumptions clearly.
  • Flag any scenario that breaches constraints or the materiality threshold.
  • Remind the user to validate scenarios with FP&A and check accounting standards or local regulations where relevant.

Example Plan data: FY24 budget by month. Actuals: Jan-Jun. Forecast horizon: Jul-Dec. Key drivers: sales volume, price, COGS percent. Scenario count: 3. Constraints: fixed headcount. Currency: USD. Materiality: $50k. Business unit: EMEA.

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.