To know how many EMIs are left, take the total number of instalments in your loan agreement and subtract the debits that actually went through. You can do this from abroad with two documents: the repayment schedule from the lender and a statement of the Indian account that pays the EMI. No call to a branch is needed for the first answer.
Why does it get hard when you live abroad?
Most people who live in India notice the EMI each month because the debit message lands on their own phone. If you earn abroad, the loan often sits in an Indian account that a parent or sibling watches, or that you only look at when you remit money. Months pass, and the question 'how many are left?' turns into guesswork. The answer matters because you may want to plan a lump-sum part payment, or you want to know when your monthly remittance can drop.
What do you need in hand before counting?
- The loan agreement or sanction letter, which states the number of instalments and the EMI amount.
- The repayment schedule, if the lender gave one. It lists every due date in order.
- A statement of the Indian account that the EMI is debited from, covering the months since the first debit.
- Your remittance records, so you can match money sent from abroad to the debits that followed.
Each item answers a different question. The agreement gives the total count, the statement proves what was actually paid, and the remittance record explains where the money came from if a debit bounced.
How do you count paid and remaining instalments?
Take a made-up example. A personal loan has 36 EMIs of ₹15,000 and the first debit was on 5 March 2025. Counting debits on the fifth of each month up to 5 November 2026 gives 10 debits in 2025 (March to December) and 11 in 2026 (January to November), so 21 are paid.
| Item | Working | Result |
|---|---|---|
| Total instalments | From the agreement | 36 |
| Paid so far | 10 in 2025 plus 11 in 2026 | 21 |
| Left | 36 minus 21 | 15 |
| Amount paid in EMIs | 21 x ₹15,000 | ₹3,15,000 |
| Total of remaining EMIs | 15 x ₹15,000 | ₹2,25,000 |
Check the last row: 3,15,000 plus 2,25,000 equals ₹5,40,000, which is 36 x ₹15,000. Note that the remaining total is the sum of future instalments, not the amount you would pay to close the loan today. The closing figure comes from the lender, so ask for a foreclosure statement if you want it.
What if a debit bounced or the date moved?
A bounced debit is not a paid instalment, so do not count it just because money was sent. Look for the matching credit and the matching debit in the statement. If an amount went out twice in one month, for example a bounced debit that was presented again, note both lines and check which instalment each one cleared. Your loan statement from the lender is the final word on the count, and the schedule in your agreement is the reference for due dates.
How do you keep the count updated from another country?
- Create one line per loan: lender, EMI amount, due day, total instalments, first debit date.
- Each month, after the debit lands, add a tick or a date in the 'paid' column.
- Calculate left as total minus paid, and note the month the last EMI falls due.
- Add one reminder in your own calendar a week before the due day, set to your local time and not Indian time.
- Save a screenshot or PDF of the statement each quarter in a folder named for the loan.
A spreadsheet handles this well when you have one or two loans. In Excel or Google Sheets, put total instalments in column C, paid in D, and use =C2-D2 for the number left. If you want the paid count to update itself, keep a list of debit dates in a separate sheet and use =COUNTIF(Debits!$A$2:$A$100,">0").
Where could SpendixAI fit in?
When a spreadsheet stops being enough, SpendixAI lets you upload the Indian account statement as PDF, CSV or Excel and review the rows before saving, so each EMI debit sits next to your other spending. It does not connect to your bank and never asks for net-banking logins, which suits someone managing the account from abroad. Check how your own statement layout imports before relying on it.
A short checklist for your next remittance day
- Count paid debits from the statement, not from memory.
- Write the number left and the date of the final EMI.
- Confirm the account will hold the next EMI before its due day.
- Tell the family member who watches the account what the count is, so you both use the same number.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

