Debt

How many EMIs are left on a personal loan? Count them yourself

Forgot how many EMIs remain on your personal loan? Count the debits against the tenure and see how to record each one so the answer is always handy.

Editorial illustration for How many EMIs are left on a personal loan? Count them yourself

Subtract the number of EMI debits you can see on your statement from the total number of instalments in your loan, and you have the number left. For a salaried borrower with an auto-debit, this takes five minutes: find the tenure in your sanction letter, count the EMI rows, subtract. The count tells you how many payments remain, not the amount needed to close the loan today.

What do you need before you count?

  • The tenure in months, from the sanction letter or the loan account summary.
  • The month the first EMI was debited, which may not be the month the loan was disbursed.
  • Your bank statement for the account that pays the EMI.

If you cannot find the tenure, ask the lender for the repayment schedule. Do not guess it from the EMI amount.

Worked example

Say your personal loan has 36 instalments of ₹9,200, and the first debit appeared in a June. Counting EMI rows on the statement, you find 14 debits so far.

ItemWorkingResult
Instalments in totalfrom the sanction letter36
Instalments paiddebits counted14
Instalments left36 minus 1422
Payments still to make22 times ₹9,200₹2,02,400

That ₹2,02,400 is the sum of the remaining instalments. It is not the amount the lender would ask you to pay to close the loan today. That figure depends on the outstanding principal and the lender's closure terms, so ask for a foreclosure statement if you want it.

Why might the count be wrong?

  1. A month with two debits: one EMI and one charge. Count only the EMI.
  2. A failed attempt followed by a successful one. Count only the one that went through.
  3. A skipped month. If a debit never happened, the loan may have been extended, so the end date moves.
  4. A part-prepayment. It can shorten the tenure or reduce the instalment; the lender's statement will say which.
  5. A change in the interest rate on a floating loan, which can change the number of instalments left.

How do you keep the count handy without recounting?

Record every EMI debit under one loan category with the loan name in the description. Then counting is just filtering rows by that category and name. SpendixAI lets you import statements and add expenses by hand, with your own categories, so a category such as EMI and Loan Repayment and a rule for the loan's narration will collect the rows for you. Check each month that exactly one row went in.

How often should you check?

Once a quarter is enough for a stable loan. Put a reminder on a fixed date, count, and write the number left on the loan's description. If you make any prepayment, count again afterwards and ask the lender for the new schedule.

A useful cross-check is the end date. Take the month of the first EMI, add the total number of instalments minus one, and see which month the last payment should fall in. In the example, 36 instalments starting in June end 35 months later. Compare that month with what the lender's schedule shows. If the schedule says a different month, find out why: a skipped debit or a prepayment is the usual reason, and it is better to learn this now than at the final payment.

Quick checklist

  • Tenure from the sanction letter or lender.
  • EMI debits counted from the statement.
  • Charges and failed attempts left out.
  • Remaining payments calculated, then confirmed with the lender.
  • Closure figure requested separately if you plan to prepay.
SPENDIXAI JOURNAL

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

Explore your reports