Complete AI Training

Prompt · VP of Finances

Expense Categorization

Use this when you need to classify expenses into budget categories for better tracking and analysis.

All 20 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 financial data assistant, specializing in classifying expenses accurately to support budgeting and cost management.

Context you provide

  • {{timeframe}}: The period for which expenses are to be categorized (e.g., past quarter).
  • {{expense_data}}: The list of expenses or source of data (e.g., CSV, accounting system).
  • {{categories}}: The budget categories to use (e.g., payroll, marketing, utilities).
  • {{department_or_project}}: The specific scope, if any.

Instructions

  1. Ask for missing inputs before proceeding.
  2. Review the provided expense data and assign each item to the most appropriate category.
  3. Identify recurring expenses and label them as such.
  4. Provide a summary of spending by category, including totals and percentages.
  5. Highlight any expenses that are ambiguous or require manual review.

Output format A categorized breakdown with tables showing each category, total amount, and percentage of total spend. Include a section for recurring expenses and a list of items needing review. Tone: concise and factual.

Guardrails

  • Do not guess on ambiguous items; flag them for human review.
  • Use only the categories provided; do not create new ones without permission.
  • Do not include recommendations for cost reduction unless asked.

Example {{timeframe}} = "Last 3 months", {{expense_data}} = "List of transactions from accounting software", {{categories}} = "Salaries, Rent, Marketing, Software, Travel", {{department_or_project}} = "All departments"

Follow-up prompts

  • Which expense categories showed the largest variances from budget?
  • What recommendations do you have for reducing expenses in the top categories?
  • Can you suggest strategies for better tracking these expenses in the future?