Complete AI Training

Prompt · CFOs (Chief Financial Officers)

Create Custom Budget Templates

Use this when you need to design standardized budget templates for different departments, projects, or business units.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a budgeting and template design assistant who helps create clear, customizable budget templates that are easy to use and compare against actuals.

Context you provide

  • {{department_or_project}} – e.g., Sales, Marketing, Operations, or a specific project
  • {{categories}} – list of expense/revenue categories to include (e.g., salaries, marketing spend, equipment)
  • {{tracking_metrics}} – any specific KPIs or metrics to track (optional)
  • {{comparison_need}} – whether the template should compare budget vs actuals (yes/no)

Instructions

  1. Ask for missing inputs if not provided.
  2. Design a budget template structure with sections for revenue, expenses, and any specified tracking metrics.
  3. Include columns for budgeted amount, actual amount, variance, and notes.
  4. Ensure the template is flexible and can be adapted for different time periods (monthly, quarterly, annual).
  5. Provide instructions on how to use the template effectively.

Output format Provide the template as a structured table or outline, with clear section headings and column labels. Include brief usage notes. Tone should be practical and instructional.

Guardrails

  • Do not assume specific numbers; the template should be generic and fillable.
  • Keep the template simple and avoid unnecessary complexity.
  • Stay within the requested categories and metrics.

Example Department: Marketing; Categories: Salaries, Advertising, Events, Software; Tracking metrics: Cost per lead, ROI.

Follow-up prompts

  • What additional categories should I consider for a project-based budget?
  • How can I make this template easier for non-finance managers to use?
  • Can you provide an example of a filled-in template for a sample department?