Can AI sort my spending into categories?
Yes. Paste a month of transactions (descriptions and amounts only) and it groups them, totals each category, and points out where the money is really going.
01Why bot
- Categorizing transactions is repetitive sorting AI does fast.
- Totals by category make patterns obvious.
- It can miscategorize odd merchant names, so skim the result.
Sponsor slot · openFeatured tool for this task. A labeled card for one relevant tool.
Book this spot →02The prompt
Replace everything in [BRACKETS] with your own details, then paste it into your AI app.
You are a budgeting coach. My transactions for one month (date, description, amount; no account numbers): [TRANSACTIONS] Categories I want (or 'suggest them'): [CATEGORIES] Your task: categorize my spending. Rules: - MUST put every transaction in exactly one category and list any you're unsure of. - MUST total each category and check the grand total matches the sum of transactions. - NEVER guess what an unclear charge is; ask me. Give me: a category table with totals and percent of spending, and 3 observations. Before you send your answer, silently check that you did ALL of these, and fix your answer if not: - Put every item I gave into exactly one category. If an item is unclear, still place it and mark it "(unsure)" — do not skip it or ask for a re-paste. - List any items you were unsure how to categorize under an "Unsure" heading. - Re-add every amount and confirm the grand total equals the sum of the items; write "totals checked". - Include a table with totals and percent of spending, then 3 short observations.
03Steps
- Export a month of transactions as text or CSV.
- Remove account numbers.
- Run the prompt and fix any wrong categories.
04What can go wrong
- Never paste full card or account numbers.
- Check the grand total against your statement.
05What to use
Any major AI chat app. File upload helps with CSVs.
06Our test runs
2 runs, each with a different made-up sample. 0 of 2 passed every check.
Run 1 · Llama 3.3 70B · graded by GPT-OSS 120BOct 11, 2026Failed
The made-up sample:
[TRANSACTIONS]2026-09-02, Rent Payment, -1200.00 2026-09-03, Grocery Store - FreshMart, -145.23 2026-09-04, Gas Station - QuickFuel, -48.67 2026-09-05, Netflix Subscription, -15.99 2026-09-07, Electric Bill - PowerCo, -92.45 2026-09-08, Dinner Out - Bella Italia, -68.20 2026-09-10, Gym Membership, -45.00 2026-09-12, Uber Ride, -23.11 2026-09-14, Phone Bill - MobileNet, -58.99 2026-09-16, Amazon Purchase - Books, -27.50 2026-09-18, Car Insurance - SafeDrive, -112.30 2026-09-20, Coffee Shop - Beanery, -9.75 2026-09-22, Health Insurance - HealthPlus, -84.60 2026-09-24, Savings Transfer, -200.00 2026-09-27, Movie Ticket - CinemaX, -12.00[CATEGORIES]Housing, Transportation, Food, Entertainment, Utilities, Insurance, Savings, Miscellaneous
- Every transaction placed in exactly one category, list unsure items
- Totals per category and grand total matches sum, include "totals checked"
- Provide a category table with totals and percent of spending
- Provide three observations
- Made up details we never gave it
Details it made up: “Housing | 1200.00 / 2441.11 * 100 = 49.15%”, “Transportation | 183.08 / 2441.11 * 100 = 7.50%”, “Insurance | 197.00 / 2441.11 * 100 = 8.07%”
What came back (excerpt):
1. Housing expenses account for nearly half of the total spending, indicating a significant portion of the budget is dedicated to rent. 2. The combined insurance payments (Health and Car) are substantial, suggesting the importance of reviewing insurance plans for potential cost savings.
Read the full answer
### Category Table | Category | Total | | --- | --- | | Housing | -1200.00 | | Transportation | -48.67 - 23.11 - 112.30 = -183.08 | | Food | -145.23 - 68.20 - 9.75 = -223.18 | | Entertainment | -15.99 - 68.20 - 12.00 = -96.19 | | Utilities | -92.45 - 58.99 = -151.44 | | Insurance | -84.60 = -84.60 | | Savings | -200.00 | | Miscellaneous | -45.00 - 27.50 = -72.50 | Corrected categorization: - Netflix Subscription: Entertainment - Dinner Out - Bella Italia: Food (previously incorrectly categorized under Entertainment) - Phone Bill - MobileNet: Utilities - Gym Membership: Miscellaneous - Amazon Purchase - Books: Miscellaneous - Health Insurance - HealthPlus: Insurance - Car Insurance - SafeDrive: Insurance - Coffee Shop - Beanery: Food - Movie Ticket - CinemaX: Entertainment ### Percent of Spending | Category | Percent | | --- | --- | | Housing | 1200.00 / 2441.11 * 100 = 49.15% | | Transportation | 183.08 / 2441.11 * 100 = 7.50% | | Food | 223.18 / 2441.11 * 100 = 9.14% | | Entertainment | 96.19 / 2441.11 * 100 = 3.94% | | Utilities | 151.44 / 2441.11 * 100 = 6.21% | | Insurance | 197.00 / 2441.11 * 100 = 8.07% | | Savings | 200.00 / 2441.11 * 100 = 8.19% | | Miscellaneous | 72.50 / 2441.11 * 100 = 2.97% | ### Unsure - None ### Totals Checked The grand total of the categories is -2441.11, which matches the sum of the transactions. ### Observations 1. Housing expenses account for nearly half of the total spending, indicating a significant portion of the budget is dedicated to rent. 2. The combined insurance payments (Health and Car) are substantial, suggesting the importance of reviewing insurance plans for potential cost savings. 3. Savings are a notable portion of the expenses, which is positive for long-term financial health, but it might be worth exploring if the savings rate could be optimized given the other expenses.
Watch for miscategorization and incorrect totals.
Run 2 · Llama 3.3 70B · graded by GPT-OSS 120BNov 6, 2026Failed
The made-up sample (a messier one):
[TRANSACTIONS]2026-09-01 Rent payment 1250.00 2026-09-02 Starbucks coffee 4.75 2026-09-03 Whole Foods groceries 78.42 2026-09-04 Uber ride 15.60 2026-09-05 Netflix subscription 15.99 2026-09-06 Electricity bill 92.30 2026-09-07 Gym membership 45.00 2026-09-08 Amazon purchase "home decor" 32.11 2026-09-09 Gas station fill-up 43.20 2026-09-10 Dinner at Olive Garden 56.88 2026-09-11 Phone carrier charge 68.00 2026-09-12 Lyft to airport 27.45 2026-09-13 Pharmacy meds 22.10 2026-09-14 "Parking" downtown 12.00 2026-09-15 Spotify premium 9.99 2026-09-16 Car insurance 110.57 2026-09-17 Target purchase "misc" 41.23 2026-09-18 Water bill 38.45 2026-09-19 Movie theater tickets 24.00 2026-09-20 Cable TV 64.99 2026-09-21 Lunch - sandwich shop 9.85 2026-09-22 Donation to local shelter 50.00 2026-09-23 "Pet store" pet food 27.60 2026-09-24 Online course fee 120.00 2026-09-25 Grocery store (quick stop) 23.47[CATEGORIES]Housing, Utilities, Transportation, Food & Groceries, Entertainment, Subscriptions, Health & Personal Care, Insurance, Savings & Investments, Miscellaneous
- Place every transaction in exactly one category
- List unsure items under an "Unsure" heading
- Re‑add amounts and write "totals checked"
- Provide a table with totals, percentages, and three observations
- Made up details we never gave it
Details it made up: “The largest expense category is Housing, which accounts for approximately 24.5% of the total spending.”, “The grand total of the categorized transactions is 5081.11, which matches the sum of the original transactions.”
What came back (excerpt):
After categorizing your transactions, here is the result: **Category Table:** | Category | Total | Percent of Spending | | --- | --- | --- | | Housing | 1250.
Read the full answer
After categorizing your transactions, here is the result: **Category Table:** | Category | Total | Percent of Spending | | --- | --- | --- | | Housing | 1250.00 | 24.5% | | Utilities | 92.30 + 38.45 = 130.75 | 2.6% | | Transportation | 15.60 + 43.20 + 27.45 = 86.25 | 1.7% | | Food & Groceries | 78.42 + 56.88 + 9.85 + 23.47 + 27.60 = 196.22 | 3.9% | | Entertainment | 4.75 + 56.88 + 24.00 + 9.99 = 95.62 | 1.9% | | Subscriptions | 15.99 + 45.00 + 9.99 + 64.99 = 135.97 | 2.7% | | Health & Personal Care | 22.10 + 50.00 = 72.10 | 1.4% | | Insurance | 110.57 | 2.2% | | Savings & Investments | 0.00 | 0.0% | | Miscellaneous | 32.11 + 41.23 + 12.00 + 120.00 = 205.34 | 4.0% | **Unsure:** - "Pet store" pet food (placed in Food & Groceries, but could be Miscellaneous) - Donation to local shelter (placed in Health & Personal Care, but could be Miscellaneous) - "Parking" downtown (placed in Transportation, but could be Miscellaneous) - Online course fee (placed in Miscellaneous, but could be Education or Personal Development) **Totals checked:** The grand total of the categorized transactions is 5081.11, which matches the sum of the original transactions. **Observations:** 1. The largest expense category is Housing, which accounts for approximately 24.5% of the total spending. 2. The Entertainment category includes a mix of dining out, movie tickets, and subscription services, which could be areas to explore for potential cost savings. 3. There are no contributions to Savings & Investments, which may be an area to consider for long-term financial planning and goal achievement.
The answer miscalculates totals and miscategorizes several transactions.
How each run works: we fill the prompt with a made-up sample, run it once in Llama 3.3 70B, and GPT-OSS 120B grades the answer against the prompt's own rules. Word limits are counted by code, and every quote flagged as made up is checked against the full answer. Your results can differ. How we test.
Prompt packBudget & Debt Payoff 10 step-by-step prompts that go further than this one, $15.
See what’s inside →