AI and MCP

Let the spreadsheet do the sums and the AI do the reading

Use a spreadsheet or tracker for exact totals and an AI assistant for reading and explaining, with a worked month review showing who does which job.

Editorial illustration for Let the spreadsheet do the sums and the AI do the reading

Give each tool the job it is good at. A spreadsheet or tracker should do the arithmetic, because it adds the same way every time. An AI assistant should do the reading: explaining a pattern, spotting an odd entry and helping you phrase questions to ask yourself. Mixing the two roles is how people end up with a confident summary and a wrong total.

Why not let the AI do the sums too?

Language models predict text; they do not calculate the way a spreadsheet does. On a short list the answer is often right. On a few hundred rows, they can skip a row, add one twice or round oddly, and the answer still sounds sure of itself. A formula never does that, and you can click the cell to see exactly what it added.

What is the division of labour?

JobBest done byWhy
Totals by category and monthSpreadsheet or trackerRepeatable, can be checked cell by cell
Reading a messy narrationAI assistantGood at interpreting free text
Explaining why a month was highAI assistant, using your totalsGood at summarising patterns in words
Finding duplicates or outliersTracker filters first, then assistantFilters are exact; the assistant suggests what to look at
Drafting questions to ask yourselfAI assistantPrompts reflection, no numbers involved

What does a month review look like with both?

Say you export the month's transactions as a CSV and total them yourself first. Suppose the spreadsheet shows Groceries ₹14,200, Rent ₹18,000, Eating out ₹6,400, Transport ₹3,100 and Other ₹5,300. The sum is 14,200 + 18,000 + 6,400 + 3,100 + 5,300 = ₹47,000. These figures are hypothetical, but the method is the point.

Now you give the assistant the category totals, not the raw rows, and ask: which of these look unusual if last month's Eating out was ₹3,900? It can point out that Eating out rose by ₹2,500 and suggest you check whether a festival or a large group dinner explains it. The numbers it works with are numbers you already verified.

  1. Total by category in the spreadsheet or tracker.
  2. Check that the category totals add up to the statement total.
  3. Share only the totals, with merchant names removed if you prefer, with the assistant.
  4. Ask for patterns, comparisons with last month and questions worth asking.
  5. Verify any number the assistant quotes against your sheet before repeating it.

How do I keep the spreadsheet side simple?

For category totals in Excel or Google Sheets, a SUMIFS formula does the job. With categories in column B and amounts in column C, this adds Groceries: =SUMIFS($C$2:$C$500, $B$2:$B$500, "Groceries"). To add a date window as well, put a start date in E1 and an end date in E2, with dates in column A: =SUMIFS($C$2:$C$500, $B$2:$B$500, "Groceries", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<="&$E$2). The sum range always comes first, then each criteria range followed by its criterion.

One more habit helps: keep a Check cell next to your category totals. If the category totals sit in cells G2 to G8, put =SUM(G2:G8) in G9 and compare it with the total of the whole amount column, =SUM($C$2:$C$500). If the two differ, some rows have a blank or misspelt category, and the SUMIFS formulas have quietly skipped them. Fix that before you show anything to an assistant.

When does a sheet stop being enough?

A sheet is fine until typing categories by hand becomes the chore you avoid. At that point a tracker that imports statements and categorises them for you saves the repeated work. SpendixAI imports statements as PDF, CSV or Excel, lets you review rows before saving, and has reports and CSV downloads, so the totals side can come from there while an assistant helps with the reading.

A last check before you act on any summary

  • Do the category totals add up to the statement total?
  • Did you check at least one number the assistant quoted against your sheet?
  • Did the assistant see only what it needed, not account numbers or personal details?
  • Is the conclusion a question to think about, rather than financial advice to follow blindly?
SPENDIXAI JOURNAL

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

Explore your reports