When a couple has more than one loan, the fastest way to answer how many EMIs are left is one small table: loan, total instalments, paid, left, instalment amount and remaining payments. Update it once a quarter from the statements. Two people looking at the same table argue less than two people trying to remember.
What goes in the table?
| Loan | Total | Paid | Left | EMI | Remaining payments |
|---|---|---|---|---|---|
| Car loan | 60 | 31 | 29 | ₹14,800 | ₹4,29,200 |
| Personal loan | 24 | 10 | 14 | ₹6,500 | ₹91,000 |
| Together | both | both | both | ₹21,300 | ₹5,20,200 |
Check the arithmetic: 60 minus 31 is 29 and 29 times 14,800 is 4,29,200. 24 minus 10 is 14 and 14 times 6,500 is 91,000. Monthly outgo is 14,800 plus 6,500, which is 21,300, and the two remaining totals add to 5,20,200. These numbers are hypothetical.
Where does each number come from?
- Total: sanction letter or loan agreement.
- Paid: count the successful EMI debits in the statement of the account that pays the loan.
- Left: total minus paid.
- EMI: the debit amount shown on the statement.
- Remaining payments: left times EMI. This is the sum of future instalments, not a closure figure.
Whose statement do you count?
The one that holds the debit. If the car loan is paid from the joint account and the personal loan from one partner's salary account, you need two statements. Contributions from the other partner are transfers, not additional payments, so do not count a top-up as an instalment.
How does this connect with your expense records?
If every EMI debit is recorded under one loan category, with the loan name in the description, counting paid instalments becomes a filter, not a search. SpendixAI keeps each transaction with its account, lets you build your own categories and allows hand entries as well as imported statements that you review before saving. For the progress itself, keep the table above. Budgets, bills and savings goals are also available on Pro if you want to plan the monthly outgo.
When does the table need a lender's input?
- If either of you made a prepayment, ask for the new schedule.
- If the interest rate on a floating loan changed, the instalment count or amount may have moved.
- If a debit failed, check whether the instalment was credited later.
- If the table and the lender disagree by even one instalment, ask for a statement of account.
How prepayments, rate changes and charges work differs between lenders, so confirm the current position in your loan agreement or with your lender rather than assuming.
Add a column for the month each loan should end, and a second table once a year that lists what your monthly outgo will be after each loan closes. In the example, when the personal loan ends in 14 months the outgo falls from ₹21,300 to ₹14,800, a difference of ₹6,500. Seeing that date in writing helps you decide together what to do with the freed-up amount, whether that is savings, a larger buffer or an early closure of the next loan. Keep the table next to the loan documents, so that anyone in the household can find the numbers if one of you is unavailable, and note the lender's contact route beside each loan for quick questions.
A shared quarterly routine
- Sit together for fifteen minutes with the latest statements.
- Count paid instalments for each loan.
- Update the table.
- Note the month in which each loan should end.
- Decide whether any extra payment is worth asking the lender about.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


