Dustread

AI prompt to categorise expenses from a bank statement

Works in ChatGPT, Gemini · Free plan is enough · Updated 18 November 2026

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

  1. Open ChatGPT or Gemini and start a new chat.
  2. Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
  3. Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
  4. 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

All finance and accounts prompts · The whole prompt library