AI prompt to categorise expenses from a bank statement
The prompt
You are a careful bookkeeper for a small business in India. Below are transactions from [month] exported from our bank statement. I removed the account number and names. Sort every line into one of these categories: [Rent, Salaries, Software and subscriptions, Travel, Office supplies, Utilities, Marketing, Bank charges, GST payment, Owner's drawings, Other]. Return a table with columns: Date | Description | Amount (₹) | Category | Confidence (High/Low). Then a second table: Category | Total (₹) | Number of transactions. Rules: do not skip or merge any line. Mark Low confidence when the description is unclear, and do not guess a vendor name. Credits (money in) go in a separate list, not in the expense totals. Check that your totals add up to the sum of all debits and show that check. Transactions: [paste: date, description, amount — one per line]
Replace the parts in [square brackets] before you send it.
How to use it
- Open ChatGPT or Gemini and start a new chat.
- Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
- Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
- Read the final version yourself before you use it. Check every number, date and name.
- Check the totals in your spreadsheet too. The AI shows its working so you can verify it, not so you can skip verifying.
- For more than about 150 lines, paste a month at a time.
Do not paste Aadhaar, PAN, bank details, salaries or anyone's personal data into a public AI tool. Use placeholders and add the real details in your own document.
Example result
A table with every transaction you pasted, each given a category and a High or Low confidence mark, followed by a summary table of totals per category. Unclear lines such as "UPI/8723/PAYMENT" are marked Low so you can check them, money received is listed separately, and the last line shows the AI's check that the category totals equal the sum of all debits.
Described in words: what you get depends on your photo or details, and on the tool.
Variations
Send one of these as your next message in the same chat, or use it to replace the matching line in the prompt.
Your own categories
Use the categories from our chart of accounts instead: [paste the list].For Tally import
Give the result as CSV with columns Date, Ledger, Amount, Narration so I can prepare it for import.
Spot unusual items
List any transaction that looks duplicated, unusually large for its category, or like a personal expense.
More finance and accounts prompts
- ChatGPT prompt for a polite payment reminderA copy-paste ChatGPT prompt for payment reminders that get paid: a polite email and a short WhatsApp message, with firmer versions for 30 and 60 days overdue.
- AI prompt to write a monthly MIS summaryPaste your monthly numbers and get a one-page MIS summary for management: what changed, why, and what needs a decision, with ChatGPT or Gemini.
- AI prompt to explain budget vs actual variancesA copy-paste prompt that calculates budget vs actual variances, flags the ones that matter and drafts a plain explanation for each, in ChatGPT or Gemini.
- AI prompt to get the right Excel formulaDescribe what you need in plain words and get the right Excel or Google Sheets formula, explained part by part, with a test row to check it. Works in ChatGPT and Gemini.