Debt

Tracking multiple EMIs in one sheet: columns that work

How to track multiple EMIs in one sheet: the seven columns to use, five invented loans filled in, and a monthly total formula that updates as loans end.

Editorial illustration for Tracking multiple EMIs in one sheet: columns that work

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?

ColumnWhat to enterWhy it matters
LenderBank or finance company nameSo you can match it to the statement narration
Loan typeHome, car, personal, phone, card EMILets you total by type
EMI amount (₹)The instalment you payFeeds the monthly total
Due dateDay of month, such as 5Shows when the balance dips
Debit accountWhich bank account is debitedTells you which account needs the buffer
Months leftFrom the lender's latest statementDrives the end date
Last EMI monthFor example Mar 2029Shows 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.

LenderTypeEMI (₹)DueAccountMonths leftLast EMI
Lender AHome loan24,5005Salary a/c162Sep 2039
Lender BTwo-wheeler3,90010Salary a/c14May 2027
Lender CPhone EMI2,75012Credit card6Sep 2026
Lender DPersonal loan6,20015Salary a/c21Dec 2027
Lender EGold loan4,00028Savings a/c9Dec 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports