A car loan EMI tracker has two jobs: confirm that the schedule your lender gave you is arithmetically sound, and record each payment so you can see the outstanding balance fall. The PMT function in Excel or Google Sheets does the first, and a simple log does the second. You do not need a bank login for either.
Step one: check the EMI with PMT
In a sheet, put the loan amount in B1, the yearly interest rate in B2 and the number of months in B3. Then enter:
=PMT(B2/12, B3, -B1)
The minus sign in front of B1 makes the result positive. Take a hypothetical loan: ₹5,00,000 at 9 percent a year over 60 months. The formula returns about ₹10,379. Your own loan figures are in your loan agreement or sanction letter; use those, and expect small rounding differences from your lender's number.
Step two: see how interest and principal split
Each month, interest is the outstanding balance times the yearly rate divided by twelve. The rest of the EMI reduces the balance. For the first three months of the example:
| Month | Interest | Principal repaid | Balance after |
|---|---|---|---|
| 1 | ₹3,750 | ₹6,629 | ₹4,93,371 |
| 2 | ₹3,700 | ₹6,679 | ₹4,86,692 |
| 3 | ₹3,650 | ₹6,729 | ₹4,79,963 |
Check month 1: 5,00,000 x 0.09 / 12 = 3,750, and 10,379 - 3,750 = 6,629, leaving 4,93,371. Month 2 interest is 4,93,371 x 0.0075 = about 3,700. Over 60 payments the total is about ₹6,22,740, so interest is about ₹1,22,740 on this hypothetical loan.
Step three: record what actually happened
Add a log with the columns Due date, Paid date, Amount paid and Balance per lender. Fill it from your statement, not from memory. If the paid amount is not the EMI amount, or the paid date is later than the due date, write why. This log is the thing you will want if a charge ever looks wrong.
What should you do when a payment fails?
- Find the charge in your loan agreement or in the lender's schedule of charges; do not trust a forum figure.
- Check your statement to see whether the failed debit and any charge appear.
- Record the date, the reason and the amount in your log.
- Ask the lender how the missed instalment is treated in your schedule, and write the answer down.
- Fix the cause: a low balance before the due date is the usual one, so move money a day early.
This article cannot tell you bounce charges or what a missed payment does to a credit record. Those depend on your agreement and the lender.
Keep your lender's contact details and the loan account reference in the same sheet. When you call about anything, write down the date, the name of the person and what they said. That small habit has resolved more disputes than any formula, because it turns a vague memory into a record.
How does this sit with the rest of your money?
An EMI is a fixed bill with a known date. In SpendixAI, Pro includes bills, and the EMI row will show on your statement upload against the account it left, so you can see it next to your other spending. The PMT check and the balance log remain a small sheet of your own.
A short checklist
- Loan amount, rate and term copied from the agreement.
- EMI checked with PMT.
- Payment log started from the first instalment.
- Reminder one day before every due date.
- Annual comparison with the lender's statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


