AI and MCP

Understand your EMI burden from statements with these AI prompts

Copy-ready AI prompts that pull EMI debits from a bank statement, list them loan by loan and show what share of take-home pay they use.

Editorial illustration for Understand your EMI burden from statements with these AI prompts

To understand your EMI burden from a bank statement with AI, ask it to do three small jobs in order: find the repeating debits, group them by loan, and divide the total by your monthly take-home pay. Give it one job per prompt, check its sums yourself, and you will have a clear EMI list in about ten minutes.

Get the statement ready before you paste anything

An AI assistant only sees what you give it, so tidy the input first. Use three to six months of statement rows so that a one-off debit does not look like a loan. Before pasting, remove your name, account number, address and any balance column. You need only the date, the narration and the debit amount.

Which prompts pull out the EMI debits?

Start with detection. EMIs have a signature: the same amount, on nearly the same date, month after month. Paste your rows and work through these four prompts in order.

  1. Find the EMIs: 'Below are my bank debits for the last four months. List every debit that repeats at the same amount around the same date each month. Show the narration, the amount and the dates it appeared. Do not guess; if you are unsure, put it in a separate list called Maybe.'
  2. Group by loan: 'Merge the repeating debits that belong to the same lender or loan. Give me one line per loan with the monthly amount and how many months you saw it.'
  3. Compare with income: 'My monthly take-home pay is the amount I give next. Add up all the EMIs, then show each EMI and the total as a percentage of that pay, with the arithmetic written out.'
  4. Check the gaps: 'Which months is an expected EMI missing or different? Could that mean a bounced payment, a date shift or a part-prepayment? List the rows you used.'

What does the answer look like for a made-up household?

Say a household has a monthly take-home pay of ₹70,000. Across four months the assistant finds three repeating debits: a car loan, a personal loan and a phone EMI. Your job is to confirm each against the narration on the statement and then check the maths.

LoanMonthly EMIShare of ₹70,000 take-home
Car loan₹12,40017.7%
Personal loan₹6,1008.7%
Phone EMI₹2,5003.6%
All three₹21,00030.0%

The total is ₹12,400 plus ₹6,100 plus ₹2,500, which is ₹21,000. Dividing ₹21,000 by ₹70,000 gives 0.30, so these EMIs take 30 percent of that take-home pay, leaving ₹49,000 for rent, food, school fees, savings and everything else. The figures are invented for the example, not a norm or a target.

How do you catch an AI getting it wrong?

Assistants are good at spotting patterns and uneven at arithmetic, so verify the parts that matter. Ask it to show every row it used, then compare four things yourself.

  • Each EMI amount matches a loan you know about; a recurring gym fee or insurance premium is not an EMI.
  • The total equals the sum of the lines when you add them on a phone calculator.
  • Rows from a part-payment or a one-time foreclosure are not counted as a monthly EMI.
  • Debits made from a card or another account are missing if you only pasted one statement, so run the exercise for each account.

What should you ask after you know the number?

A single percentage is a starting point, not a verdict. Follow up with prompts that turn it into decisions you can make yourself: 'Which EMI ends first, based on the dates I give you?' 'If one EMI is removed, what does the share become?' 'Draft three questions I should ask my lender about the remaining balance.' Keep the questions about your own figures; do not ask the assistant which loan to take or close.

When pasting rows stops being practical

Doing this every quarter by hand gets tiresome. SpendixAI lets you upload statements in PDF, CSV or Excel, review the rows before saving, and keep each transaction against its account, so your EMI debits are already sorted. If you use Claude or ChatGPT, you can connect it through MCP, choose a scope, start read-only and disconnect whenever you like, instead of pasting rows each time.

SPENDIXAI JOURNAL

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

Explore your reports