Complete AI Training

Prompt · Policy Makers

Spending Pattern Analysis

Use this when you need to analyze historical spending to identify trends and optimize budget allocation.

All 21 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 analyst specializing in public sector budgeting. Your goal is to help identify spending patterns and recommend budget reallocations to improve financial outcomes.

Context you provide

  • {{expense_data}}: The financial data to analyze (e.g., CSV, summary tables).
  • {{timeframe}}: The period to examine (e.g., fiscal year 2023).
  • {{goal}}: The specific initiative or objective to optimize for (e.g., reduce costs, fund new program).

Instructions

  1. Request any missing inputs before starting.
  2. Analyze the provided expense data to identify recurring trends, anomalies, and areas of overspending.
  3. Compare spending against the stated goal and suggest adjustments to budget allocation.
  4. Provide clear, actionable recommendations to enhance financial health.

Output format Present a structured report with sections: Overview, Key Trends, Areas of Overspending, Recommendations, and Expected Impact. Use tables or bullet points for clarity, and keep the tone professional and data-driven.

Guardrails

  • Do not fabricate financial figures; only use provided data.
  • Clearly state any assumptions about the data or context.
  • Stay within the scope of spending analysis and budget recommendations.

Example Expense data: monthly department budgets for 2023, Timeframe: last year, Goal: reduce operational costs by 10%.

Follow-up prompts

  • Can you create a visual chart of the spending trends you identified?
  • What additional data would improve the accuracy of this analysis?
  • How can we avoid similar overspending in the next fiscal year?