For a two-wheeler loan, the number of EMIs left is the tenure minus the instalments that have actually cleared. Take the tenure and first EMI month from your sanction letter, count the cleared debits in your bank statement, and subtract. Then confirm the figure with the lender, because a missed debit or a revised schedule will change it.
What do you need in front of you?
- The sanction or loan agreement letter: tenure in months, EMI amount, first EMI date.
- Your bank statement for the account that pays the EMI.
- The lender's loan statement or app screen, if you can reach it.
A worked example with dates
Say the tenure is 36 months and the first EMI was in February 2025. The last scheduled EMI is then January 2028, since February 2025 plus 35 further months lands there. It is now November 2026.
- EMIs from February to December 2025: 11.
- EMIs from January to November 2026: 11.
- Cleared so far: 11 + 11 = 22.
- Left: 36 − 22 = 14, running from December 2026 to January 2028.
- Cross-check by months: December 2026 is 1, the twelve months of 2027 are 12, January 2028 is 1; that is 14 as well.
If your statement shows only 21 debits, one instalment is missing, and you need to find out whether it was missed, bounced or paid some other way before assuming 14.
How can a spreadsheet do the count?
Put the first EMI date in B1 and the tenure in B2, and use these. The first returns months elapsed counting this month; the second subtracts them from the tenure.
- Months elapsed: =DATEDIF(B1, TODAY(), "m") + 1
- EMIs left: =B2 - (DATEDIF(B1, TODAY(), "m") + 1)
- Last EMI date: =EDATE(B1, B2 - 1)
These assume every instalment cleared on schedule, so verify them against the debit count. Use them as a quick check, not as a replacement for the lender's schedule. Check whether the current month's instalment has already been debited before you read the result.
Why is the lender's count sometimes different?
| Reason | Effect on EMIs left |
|---|---|
| A part-payment or foreclosure payment | Fewer left, or a smaller EMI |
| A bounced or missed instalment | More left than the calendar suggests |
| A change in the rate | Tenure or EMI may change |
| A restructure or moratorium | Tenure extended |
What should you ask for when the loan ends?
Closing is more than the last debit. Ask the lender what documents they issue when the loan is cleared, such as a closure or no-dues letter, and how the lender's name gets removed from the vehicle's registration records. The steps and timelines depend on the lender and on your state's transport office, so ask and note the answer with a date. Keep the closure letter along with your insurance and registration papers.
How can SpendixAI help?
Importing the paying account's statement into SpendixAI and filtering to the lender's name gives you a clean list of EMI debits to count, with each transaction attached to the account it came from. It does not hold your loan terms, so keep the tenure and schedule in your own note.
What if you missed an instalment along the way?
Then the clean calendar count no longer holds. A missed or bounced EMI is usually cleared later, so your debit count may show the same number of cleared payments as the months that passed, while the lender's schedule still shows the older date. Ask the lender for a statement of account and look at the line for each month. Note the amount, the date it finally cleared and any charge, and record it against the month it was meant for.
A quick list
- Tenure and first EMI month noted from the agreement.
- Cleared debits counted from the statement.
- Left = tenure minus cleared.
- Lender's number requested and compared.
- Closure documents on your list for the last month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


