To categorise a business statement with an AI assistant, paste a small, cleaned extract, give it your category list, ask for a table with a short reason per row, and then check every row yourself. Treat the output as a first draft from a quick junior colleague. It is useful for speed, but it cannot know that a transfer of ₹2,000 was a friend repaying a loan.
What should you remove before pasting anything?
- Your name, address, phone number and email.
- Account numbers, card numbers, IFSC codes and reference numbers.
- Running balances. The AI only needs date, description and amount.
- Names of private individuals in transfer narrations; replace them with person.
- Anything beyond the rows you want categorised. Ten to thirty rows at a time is plenty.
Also check the assistant's own privacy settings and the terms of your plan to see how pasted text may be stored or used. Never paste net-banking details of any kind.
A set of prompts that work
- Setup: I run a small freelance design business in India. I will paste bank statement rows with date, description and amount. Categorise each row using only these categories: software, co-working, travel, learning, marketing, professional fees, internet and phone, client income, personal, unsure.
- Format: Return a table with columns: date, description, amount, category, and a reason in under ten words. Do not change amounts or dates.
- Honesty: If a row is ambiguous, use unsure and say what you would need to know. Do not guess.
- Review: List the three rows you were least sure about and why.
- Consistency: Here are my rules: any description containing the word cloud goes to software. Apply them first.
A small sample
| Row (cleaned) | Amount | AI's likely category | Your check |
|---|---|---|---|
| UPI CLOUDSTORE monthly | ₹650 | Software | Agree |
| UPI COWORKHUB desk | ₹6,000 | Co-working | Agree |
| POS AIRPORT CAB | ₹850 | Travel | Agree, if it was for client work |
| UPI person transfer | ₹2,000 | Unsure | Yours to decide: loan repaid, team payment or personal |
| NEFT credit ACME DESIGNS | ₹45,000 | Client income | Agree, match to invoice |
Five rows, five lines of review. If the AI had called the ₹2,000 transfer a business expense, you would have caught it only because you were checking.
How do you review the AI's choices?
- Add up the AI's table and compare the total with the total of your pasted rows. They must match to the rupee.
- Sort by category and read each group. Wrong rows tend to stand out when grouped.
- Check every unsure and every row above an amount you choose.
- Spot-check a few confident rows against the original statement.
- Keep the final table, with the date you checked it.
How big should each batch be?
Work one month at a time, in batches of a few dozen rows. A long paste invites the assistant to drift: it may rename a category halfway or quietly merge two rows. Paste your category list and rules again at the start of each batch rather than trusting it to remember. If a batch comes back with a category you never listed, discard it and ask again with the list repeated. Say a month has 90 rows; three batches of 30 take a few extra minutes and are far easier to check than one batch of 90.
Can a tracker do this without the pasting?
Pasting works for a one-off. For regular use, SpendixAI imports the statement file directly, categorises in stages (your rules first, then your history, then an AI model only for what remains) and sends that model the cleaned merchant name and an amount band, not your name, account numbers, full statement text or balances. AI can be switched off, capped by a monthly budget, or turned off entirely, and unmatched items are then held for review.
You can also connect Claude or ChatGPT to your workspace through MCP, choosing a scope, starting read-only and disconnecting whenever you like.
A last check
- Did you strip personal and account details?
- Do the AI's totals match your rows?
- Have you reviewed every unsure row?
- Have you saved the final categories somewhere you control?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


