Skip to content
← TemplatesPersonal finance

Free Loan & Debt Tracker (Excel) — real repayments + payoff order

Juggling a SACCO loan, a bank loan and a Fuliza balance is how interest quietly eats you. This free tracker puts them in one place: enter each loan's principal, interest rate and term, and it works out the real monthly payment, the total interest you'll pay, what's left, and — most useful — which debt to attack first to save the most money.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Real reducing-balance monthly payment (matches your statement)
  • Total interest and what's left, per loan
  • Avalanche 'which to clear first' priority ranking
  • Repayment log with progress bars
  • Dashboard: total owed, monthly burden, interest, repaid

The tabs

  • Start Here (guide)
  • Loans
  • Repayments
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

The monthly payment is the standard reducing-balance amount — the same maths a bank or SACCO uses — so it matches your statement. Log repayments and the 'left to pay' and progress bar update. The Priority column ranks your loans by interest rate, so clearing the highest-rate one first (the 'avalanche' method) costs you the least in interest overall.

The Dashboard shows your total debt, your monthly repayment burden, total interest and how much you've cleared. It opens in Excel or Google Sheets and keeps the formulas locked so the numbers stay honest.

Budgeting to clear these faster? Our free budget planner and debt-payoff calculator help you set a realistic timeline.

Do it online instead

Plan your payoff with our free calculator

Open the free tool →

Frequently asked questions

Is the monthly payment accurate?

Yes — it's the standard reducing-balance (amortising) payment, the same formula banks and SACCOs use, so it matches what appears on your loan statement. Interest-free debts are handled too (principal ÷ term).

Which debt should I clear first?

The Priority column ranks your loans by interest rate. Clearing the highest-rate loan first — the 'avalanche' method — minimises the total interest you pay across all your debts.

Can I track several loans at once?

Yes. Add every loan — bank, SACCO, mobile, family — and the dashboard totals your whole debt position and monthly repayment burden.