AI and MCP

Can an AI assistant bulk import transactions into an expense tracker?

Forum question answered: can you bulk import transactions through an AI assistant? Numbered steps, a worked example with totals, and where the limit is.

Editorial illustration for Can an AI assistant bulk import transactions into an expense tracker?

The question: 'I have months of expenses in notes and half-finished sheets. Can I hand them to an AI assistant and have it bulk import everything into my tracker?' The honest answer is that the assistant is best used to tidy the data, and the tracker's own import is best used to load it. Mixing up those two jobs is where people lose rows.

What each side is good at

  • The assistant: turning messy text into tidy rows, spotting dates written two ways, and pointing out lines with no amount.
  • The tracker: loading rows in bulk, keeping each one against the right account, flagging possible duplicates and letting you review before saving. In the app that means uploading PDF, CSV or Excel, and checking the rows before they are saved.
  • You: deciding what is real. Neither tool knows whether a note says ₹1,200 for groceries or for something else.

A way to do it that we would trust

  1. Paste your notes into the assistant and ask for a table with four columns: date, description, amount, account. Tell it the year, because dates without one are the commonest trap.
  2. Ask it to flag any line where it had to guess, and to leave out anything it cannot read.
  3. Check the table against your notes, then save it as a CSV or an Excel file.
  4. In the tracker, choose the account before importing, because each transaction keeps its account.
  5. Review the rows on the import screen before you save, and look at the import history for the status.
  6. Run the totals check below.

The totals check, with made-up numbers

Say your diary has eight entries for the month: ₹250, ₹1,200, ₹380, ₹90, ₹2,150, ₹640, ₹75 and ₹410. Adding gives 250 + 1,200 = 1,450, plus 380 = 1,830, plus 90 = 1,920, plus 2,150 = 4,070, plus 640 = 4,710, plus 75 = 4,785, plus 410 = 5,195. Before importing, the assistant's table should show eight rows and ₹5,195. After importing, the tracker should show the same.

If the table says seven rows and ₹5,120, it dropped the ₹75. If the tracker says nine rows, you may have imported twice. The tracker flags possible duplicate imports, but a flag is a prompt to look, not a verdict.

What about letting the assistant write straight into the tracker?

Claude or ChatGPT can be connected to SpendixAI through MCP, with a scope you choose, an option to start read-only and a way to disconnect at any time. Whether a particular connection can add rows in bulk depends on the scope you grant and the tools offered, so test with two or three rows before trusting it with eighty. For a large backlog, the file import with its review step is the safer road.

Mistakes to avoid

  • Skipping the review step because the table looked right.
  • Importing cash and bank entries for the same payment, which doubles it.
  • Forgetting the base currency. In the app it must be chosen before importing and cannot be changed once transactions exist.
  • Not keeping the original file, so you cannot trace a wrong row back.

Rough sizing before you start

Count first. If your notes cover three months at about forty entries a month, that is 3 × 40 = 120 rows. On the Pro plan, which allows 2,000 transactions a month, volume is not the issue, your attention is. Import month by month rather than all 120 at once, so a mistake costs you one batch rather than three.

  • Month one: import, then check the count and the total.
  • Month two: same, and confirm nothing overlaps month one.
  • Month three: same, then open the Possible duplicate charges report, which lists the same amount to the same merchant within two days.

If something is wrong afterwards

Delete the wrong batch's rows and redo it. Deleted transactions sit in a recycle bin for 30 days, so you have room to correct without panic. Then compare the totals again and keep the file you imported, labelled with the month.

SPENDIXAI JOURNAL

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

Explore your reports