Make one row per loan, with the lender, EMI amount, due day, total instalments and instalments paid. Then use a few formulas to total the monthly outflow, find the next due date and count what remains. That gives a salaried person the clear view that three separate loan apps never provide.
What columns should the sheet have?
- A: Loan, such as home, car or personal.
- B: Lender.
- C: EMI amount.
- D: Due day of the month.
- E: Total instalments.
- F: Instalments paid.
- G: Instalments left, which is E minus F.
- H: Next due date.
Add a note column for anything you want to remember, such as the loan number.
What does it look like with numbers?
Say take-home pay is ₹1,05,000. Three loans: a home loan of ₹31,000 due on the 5th with 148 instalments left; a car loan of ₹12,800 due on the 10th with 31 left; a personal loan of ₹6,500 due on the 15th with 9 left.
| Loan | EMI | Due day | Left | EMIs still to be paid in total |
|---|---|---|---|---|
| Home | ₹31,000 | 5th | 148 | ₹45,88,000 |
| Car | ₹12,800 | 10th | 31 | ₹3,96,800 |
| Personal | ₹6,500 | 15th | 9 | ₹58,500 |
| All | ₹50,300 | - | - | - |
The monthly total of ₹50,300 is about 47.9 percent of ₹1,05,000. The last column is the EMI multiplied by instalments left, which is not the amount to close the loan, since the lender's closing figure comes from the lender.
Which formulas do you need?
- Total monthly EMIs: =SUM(C2:C4).
- Instalments left: =E2-F2, copied down.
- Future instalments total: =C2*G2.
- Next due date: =IF(DAY(TODAY())<=D2,DATE(YEAR(TODAY()),MONTH(TODAY()),D2),DATE(YEAR(TODAY()),MONTH(TODAY())+1,D2)).
- Share of take-home pay: =SUM(C2:C4)/B8, where B8 holds take-home pay.
These work in Excel and Google Sheets. The next-due-date formula returns a date, so format the cell as a date.
Which loan ends first, and what does that free up?
Sort the sheet by instalments left. The personal loan ends in nine months, which frees ₹6,500 a month. That does not change the car or home loan, but it tells you when the monthly outflow drops to ₹43,800. Decide in advance where the freed amount goes, or it will vanish into general spending.
How do you handle a loan with a changing EMI?
If a rate change alters the EMI or the number of instalments, edit the row and write the date of the change in the note. Take the new figures from the lender's statement.
Where can SpendixAI help?
When a sheet stops being enough, you can upload each account's statement to SpendixAI, choose the account before importing and review rows before saving, so every EMI debit appears with the rest of your spending. It will not read your SMS or connect to your bank.
What should you do when a new loan comes in?
Add a row before the first EMI is due, with the lender, amount, due day, total instalments and the date of the first debit. Then look at the total line and the share of take-home pay. In the example, adding a ₹4,500 gadget loan takes the monthly total to ₹54,800, which is about 52.2 percent of ₹1,05,000. A change that large should be a conscious decision, not something you notice on the statement. Keep a note of why you took the loan; it helps when you review later.
Keep the sheet somewhere you will actually open, such as a pinned file in your cloud drive, and share the link with a partner or parent if they might need it. Take a screenshot of the sheet each January, so you can see how the list of loans and the monthly total have changed over the year.
A habit to keep
- Update the paid column monthly.
- Check the total against take-home pay.
- Note the date the next loan ends.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

