AI and MCP

Worked example: AI analyses a month of statements, start to finish

A fictional walkthrough of using an AI assistant on one month of bank statement: prepare the CSV, mask details, categorise, total and check the balance.

Editorial illustration for Worked example: AI analyses a month of statements, start to finish

To have an AI assistant analyse a month of bank statement, prepare a clean CSV, mask personal details, ask it to categorise and total by category, then check its total against your statement's closing balance before asking for insights. This walkthrough follows a fictional October, with made-up numbers, from the first export to the corrections you record.

Step 1: prepare a clean file

Our fictional account opened October at 50,000 rupees. After export and tidying, the file has twelve rows, one header row, dates in year-month-day form, debits negative and credits positive.

datedescriptionamount
2026-10-01Salary credit80000
2026-10-02Rent to landlord-18000
2026-10-04Supermarket-3250
2026-10-06Electricity bill-1860
2026-10-08Food delivery-640
2026-10-10Fuel station-2000
2026-10-12Mobile recharge-599
2026-10-14Streaming plan-199
2026-10-17Cafe-420
2026-10-20Vegetable vendor-1150
2026-10-24Cab ride-380
2026-10-28Pharmacy-730

Step 2: mask what the assistant does not need

  • Replace the landlord's name with 'Rent' and remove any account or reference numbers from descriptions.
  • Delete balance columns from the file, and give the opening and closing balance in your message instead.
  • Remove the header block of the bank's PDF that carries your name and address, if you copied it in.

Step 3: ask it to categorise and total

A clear request: 'Categorise each row as one of Rent, Groceries, Bills, Subscriptions, Food and Dining, Transport, Health or Income. Show a table of totals by category and list the rows in each.' Asking for the rows lets you check.

CategoryRowsTotal
RentRent18,000
GroceriesSupermarket, vegetable vendor4,400
BillsElectricity, mobile recharge2,459
SubscriptionsStreaming plan199
Food and DiningFood delivery, cafe1,060
TransportFuel, cab2,380
HealthPharmacy730

Step 4: how do you check that the totals are right?

  1. Add the debits: 18,000 + 4,400 + 2,459 + 199 + 1,060 + 2,380 + 730 = 29,228.
  2. Compute the closing balance: 50,000 + 80,000 - 29,228 = 100,772 rupees.
  3. Compare with the closing balance on your statement. If they match, the assistant did not drop or invent a row.
  4. If they differ, ask it to list every row it counted, and find the missing or doubled one.

Step 5: ask for insights, then record corrections

Now ask something useful: 'Which categories are the largest as a share of my debits?' Rent is 18,000 of 29,228, about 62 percent, and groceries are 4,400, about 15 percent. Then ask what you would want to know, such as whether any rows look like they belong elsewhere. The assistant might suggest that the vegetable vendor and the supermarket be merged into one Groceries line, which you accept, or that the cab ride was for work, which only you know.

What if the assistant gets a row wrong?

It will, sometimes. In our fictional month, it might call the pharmacy bill Shopping, or put the cab ride under Food because it was near a cafe payment. Correct the row, ask it to recompute totals, and re-run the balance check. If the same mistake keeps coming back, give it a rule in plain words, such as 'any payment to a pharmacy is Health'.

What would you do differently next month?

Reuse the same prompt and category list, so the answers are comparable. Add a line for any new merchant, and save the corrected categories somewhere permanent, such as a rules list in your tracker, so you do not retype them.

Where does a tracker fit into this?

Doing this by hand each month is workable but repetitive. SpendixAI imports statements as PDF, CSV or Excel with rows reviewed before saving, and your corrections become history for next time. If you connect an assistant, you choose its scope and can start read-only.

Whatever route you use, the check in step 4 is the part to keep: no analysis is finished until its total matches your balance.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports