A one-page debt progress report lists each loan with its lender, starting balance, current balance, EMI, months left and the next milestone, then totals them at the bottom. Built so that the less number-minded partner can read it in under two minutes, it answers three questions: how much is left, how much have we cleared, and what happens next. Update it once a month from the lender's own statements.
What goes on the page?
Keep to six columns and one line per loan. More than that and the page stops being quick to read.
| Lender or loan | Starting balance (₹) | Current balance (₹) | EMI (₹) | Months left | Next milestone |
|---|---|---|---|---|---|
| Car loan | 6,00,000 | 4,20,000 | 14,500 | 36 | Balance below ₹4,00,000 |
| Personal loan | 2,00,000 | 1,10,000 | 8,000 | 15 | Half the starting balance cleared |
| Card balance | 40,000 | 25,000 | 5,000 | 5 | Card at zero |
| Total | 8,40,000 | 5,55,000 | 27,500 | Longest: 36 | Card cleared first |
The totals are simple sums: 6,00,000 + 2,00,000 + 40,000 = 8,40,000 starting; 4,20,000 + 1,10,000 + 25,000 = 5,55,000 now; and 14,500 + 8,000 + 5,000 = 27,500 a month in EMIs. Cleared so far is 8,40,000 − 5,55,000 = ₹2,85,000, which is about 34 per cent of the starting total.
Which formulas keep it up to date?
If you keep the page in Excel or Google Sheets with headers in row 1 and loans in rows 2 to 4, these cells do the work:
- =SUM(B2:B4) for the total starting balance and =SUM(C2:C4) for the total current balance.
- =B5-C5 for the amount cleared, if the totals are in row 5.
- =1-C5/B5 for the share cleared; format the cell as a percentage.
- =SUM(D2:D4) for the total monthly EMIs.
- =MAX(E2:E4) for the longest remaining time.
Current balances and months left should come from the lender's latest statement or schedule, not from your own subtraction, because interest changes the figures.
How do you make it readable in two minutes?
- Put one sentence at the top: 'We owe ₹5,55,000 and have cleared 34 per cent. Our next milestone is the card at zero.'
- Use plain words in the Next milestone column, not jargon.
- Keep a single column for months left, not an end date and a count.
- Add a line at the bottom: what changes when the next loan is cleared, such as 'We free up ₹5,000 a month'.
- Print it or save it as an image, so it can be seen on a phone.
How often should you update it?
Monthly is enough, on the same day each month, such as the day after the last EMI debits. Spend ten minutes together, update the three current-balance cells and the months-left cells, read the top sentence aloud and move the milestone if one was reached. A report that is always a little out of date gets ignored.
Where can a tracker help?
If you use SpendixAI, importing your statements shows each EMI leaving each account, and a report by category can give a CSV of loan repayments to paste into the page. The lender's statement still supplies balances. The tracker confirms that the EMIs went out; the page tells the story.
Two common mistakes make the page less useful. The first is mixing the starting balance with the sanctioned amount, which can differ; use the balance on the day you begin tracking. The second is leaving out small items such as a card balance, which then reappear later as a surprise. If you are unsure of a figure, write 'to confirm' and fill it in after you have checked the statement.
A quick checklist
- Latest statement or schedule in hand for each loan.
- One line per loan, six columns.
- Totals and the cleared share calculated.
- A top sentence in plain language.
- The date of the next update in your calendar.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

