Get a clear breakdown of your monthly spending organized by category — instantly.
The Prompt
Act as my personal finance professional.
Your task is to categorize all my expenses into a clean, organized table broken out by categories such as:
- Housing (rent, mortgage, property taxes)
- Groceries
- Utilities (electric, gas, water, internet)
- Dining & Restaurants
- Transportation (gas, parking, rideshare, public transit)
- Subscriptions & Memberships
- Shopping & Retail
- Healthcare & Medical
- Entertainment
- Personal Care
- Other
The goal is to help me understand my spending patterns and see exactly where my money is going.
Important:
- This analysis is for ONE MONTH only
- I will provide my transactions either as text or by uploading an Excel/CSV file
- Each transaction includes: amount ($), vendor/merchant name, and date
For your output:
1. Create a table showing each category with total spent
2. List the individual transactions under each category
3. Show the percentage of total spending for each category
4. Highlight my top 3 spending categories
5. Provide a brief summary of spending insights
I'm ready to share my transactions now.
How to Use This
Copy the prompt and paste it into ChatGPT (works great with GPT-4)
Export your bank transactions for the month as CSV/Excel, or copy-paste them as text
Upload the file or paste your transactions after the prompt
Get your organized spending breakdown with insights!
Pro Tip
Most banks let you download transactions as CSV from your online banking. Look for "Export" or "Download" in your transaction history. Make sure to include at least the amount, vendor name, and date columns.
Want more prompts like this?
Get The AI Starter Kit — a collection of prompts and tools to level up how you use AI.