Debt

Matching EMI debits in your bank statement with your loan list

Reconcile EMI debits in a bank statement with your loan list by matching narration, amount and date, and flag any loan with no debit.

Editorial illustration for Matching EMI debits in your bank statement with your loan list

To match EMI debits with your loan list, take each recurring debit on the statement, compare three things with the list (the lender name in the narration, the exact amount, and the date), and tick the loan it belongs to. Any loan left without a tick is a loan to check. It is a ten-minute job that catches missed, doubled and changed instalments.

What do I need in front of me?

  • Your loan list: lender, EMI amount, due day and debit account.
  • The statement for the same account and the same month.
  • A pen or a spare column to write the match against each debit.

Narrations are the text next to each debit. Their wording differs between banks and even between months, so treat them as clues, and look at your own statement to see how your lenders appear.

What does the matching look like with invented lines?

Here are five recurring debits from an invented statement, matched to a loan list of six loans.

DateNarration (invented)Amount (₹)Matches
5thAUTO DEBIT LENDER A LOAN24,500Home loan, Lender A
10thEMI LENDER B VEHICLE3,900Two-wheeler, Lender B
12thEMI LENDER C2,750Phone EMI, Lender C
15thLENDER D PERSONAL LN6,200Personal loan, Lender D
28thLENDER E GOLD4,000Gold loan, Lender E

The list also holds an education loan with Lender F, due on the 20th for ₹5,300. There is no debit near that date. That is the loan to chase: it may be paid from another account, it may be late or it may have been missed.

How do I handle two loans with the same EMI?

Amount alone can mislead if two loans have the same instalment. Use the date and the lender name first, then the amount. If the narration is vague, note the reference number or the loan account suffix, if your statement shows one, in your list so the match is certain next month.

What should I flag?

  1. A loan on the list with no debit near its due date.
  2. A debit with an amount different from the list.
  3. A recurring debit you cannot place; it may be a loan or a subscription you forgot.
  4. Two debits for the same loan in the same month.
  5. A debit date that has drifted a few days later than usual.

How can a tracker speed this up?

Once you have worked out the narration for a lender, tell your tracker. In SpendixAI you can set your own rules, add merchant aliases, and categorise by sub-category, so that each month's debit for a lender lands under the right loan category. Corrections are remembered as history, so next month needs only a glance. Rows from an uploaded statement are shown for review before they are saved, which gives you the moment to check. It does not link to your lender's records, so the loan list stays your reference.

Do a rough check on the credit-card side too. A card EMI is often charged to the card and shows up on the card statement as a monthly line, not as a bank debit, so you will not find it in the savings account at all. If a loan has no bank debit, look at the card statement before you decide it is missing. Mark in your list which statement each loan appears on, so next month you open the right one.

A monthly routine

  • Upload or open the new statement.
  • Filter for the lender names on your list.
  • Tick each against the due date and amount.
  • Write a note beside any loan without a tick and contact the lender the same day.
  • Update the list if an amount changed.

Doing it monthly keeps the list reliable enough to use when you plan a prepayment or apply for something new.

SPENDIXAI JOURNAL

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

Explore your reports