An EMI tracker is a short register with one row per loan: lender, amount borrowed, instalment, debit date, start and end dates, and balance. Fill it from your loan documents, check the instalment with a formula, and update the balance every quarter against the lender's statement.
What fields should the register have?
- Lender and loan type, such as car or personal.
- Amount borrowed and the date it was disbursed.
- Instalment amount and the monthly debit date.
- Interest rate as printed in the agreement, and whether it is fixed or floating.
- Number of instalments and the date of the last one.
- Instalments paid so far and outstanding balance per the lender.
- Charges you have paid, such as processing or part-payment fees.
Copy these from your sanction letter and the lender's app. Do not rely on memory.
How do I check the instalment with a formula?
In Excel or Google Sheets, PMT calculates a fixed instalment: =PMT(rate/12, months, -loan). The rate is the annual rate as a decimal, so 12 per cent is 0.12. Say you hold a made-up loan of ₹5,00,000 at 12 per cent a year for 24 months. =PMT(0.12/12, 24, -500000) returns about ₹23,537. If your actual instalment differs by a lot, a fee, a different rate or a different tenure may apply, and the agreement will say which.
How do I check the balance after a few payments?
In the same example, interest in month one is about 1 per cent of ₹5,00,000, which is ₹5,000, so about ₹18,537 of the first instalment reduces what you owe. After six instalments the outstanding balance is about ₹3,85,958. In a sheet, =FV(0.12/12, 6, 23537, -500000) returns the balance as a positive number, because the loan is entered as a negative present value and the instalments as positive. Compare it with the lender's figure: a small difference is normal because of rounding, but a large one deserves a question.
| Item | Made-up value |
|---|---|
| Borrowed | ₹5,00,000 |
| Instalment | about ₹23,537 |
| Paid in 24 months | about ₹5,64,900 |
| Interest over the term | about ₹64,900 |
The 24 payments of ₹23,537 come to about ₹5,64,900, so interest is roughly ₹64,900. These figures are only an illustration of the arithmetic.
What about an app instead of a sheet?
An app is easier if you want reminders and a tidy view. Before choosing one, check that it lets you enter the real instalment and date, shows the outstanding balance, lets you edit a row when the rate changes and exports your data. SpendixAI is an expense tracker, not a loan-schedule tool: it can categorise EMI debits from your statements, keep bills and set budgets on its Pro plan, but the repayment schedule itself stays in your sheet.
Which loans should go in the register?
Every loan with a fixed monthly debit, including small ones. A ₹2,000 gadget instalment is easy to forget until the month it lands on top of rent. Add card instalment plans too, since they appear on the card bill rather than as a separate loan debit. If you are unsure whether something is a loan, ask whether it has an end date and a fixed amount; if so, it belongs in the register.
How do I record a rate change or part-payment?
Add a dated note in the row: new rate, new instalment or new end date, taken from the lender's notice or statement. Keep the old values in a second line so the history stays visible. When you part-pay, log the amount and then read the lender's new outstanding balance instead of recomputing it, because the lender's treatment of the payment decides the result.
Quarterly routine
- Compare the sheet's balance with the lender's statement.
- Record any prepayment and ask how it was applied.
- Update the rate and instalment if the lender notified a change.
- Check the final date is still right.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


