To track several EMIs in one sheet, make one row per loan with seven columns: lender, loan type, EMI amount, due date, debit account, months left and last EMI month. A total at the bottom then gives your monthly commitment in a single number. It takes about ten minutes to build and saves you from guessing what leaves your account each month.
Which columns should the sheet have?
| Column | What to enter | Why it matters |
|---|---|---|
| Lender | Bank or finance company name | So you can match it to the statement narration |
| Loan type | Home, car, personal, phone, card EMI | Lets you total by type |
| EMI amount (₹) | The instalment you pay | Feeds the monthly total |
| Due date | Day of month, such as 5 | Shows when the balance dips |
| Debit account | Which bank account is debited | Tells you which account needs the buffer |
| Months left | From the lender's latest statement | Drives the end date |
| Last EMI month | For example Mar 2029 | Shows when the burden drops |
Take the months left and the EMI amount from your lender's own statement or app, not from memory. If your sheet and the lender disagree, the lender's schedule is the one that matters, but note the difference and ask.
What does it look like with five invented loans?
Here is a hypothetical household, with months left counted from March 2026. Names and numbers are made up.
| Lender | Type | EMI (₹) | Due | Account | Months left | Last EMI |
|---|---|---|---|---|---|---|
| Lender A | Home loan | 24,500 | 5 | Salary a/c | 162 | Sep 2039 |
| Lender B | Two-wheeler | 3,900 | 10 | Salary a/c | 14 | May 2027 |
| Lender C | Phone EMI | 2,750 | 12 | Credit card | 6 | Sep 2026 |
| Lender D | Personal loan | 6,200 | 15 | Salary a/c | 21 | Dec 2027 |
| Lender E | Gold loan | 4,000 | 28 | Savings a/c | 9 | Dec 2026 |
Total: 24,500 + 3,900 + 2,750 + 6,200 + 4,000 = ₹41,350 a month.
How do I make the total and end dates update by themselves?
Put the header in row 1 and the loans in rows 2 to 6, with loan type in column B, EMI amounts in column C, due day in column D and months left in column F. In Excel or Google Sheets, these work the same way:
- Monthly total: =SUM(C2:C6)
- Number of loans still running: =COUNTIF(F2:F6, ">0")
- EMI total for one loan type: =SUMIF(B2:B6, "Home loan", C2:C6)
- Last EMI month from today: =EDATE(TODAY(), F2) (format the cell as a date; the result is the month the loan should end)
- Next due date this month: =DATE(YEAR(TODAY()), MONTH(TODAY()), D2)
If you want only the loans that are still live, use =SUMIF(F2:F6, ">0", C2:C6). When a loan ends, change months left to 0 and the total drops automatically.
What should I do with the monthly total?
Compare ₹41,350 with your take-home pay each month, and look at which days of the month the money leaves. An EMI is a fixed claim on your income, so knowing the total tells you how much room is left for everything else. In our invented household, four of the five EMIs fall on or before the 15th, so the main account needs a buffer after payday.
A small extra column worth adding is Notes. Use it for things the numbers cannot hold: 'prepaid ₹50,000 in Oct, EMI unchanged, tenure shortened', 'rate reset in July', 'card EMI, ends with the statement after the 6th instalment'. Six months later, that single line saves a phone call to the lender and keeps your months-left figure trustworthy.
When does a sheet stop being enough?
A sheet is fine for the list of loans. What it cannot do is check that each EMI actually left your account on time. If you import statements into SpendixAI, you can see each debit against the account it came from, and compare them with your list. Until then, a monthly glance at the statement works.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
