A1:G14fxIFERROR INDEX MATCH MAX MIN NPER RANK ROUNDUP SUM
Debt Payoff Tracker — the first rows of the actual spreadsheet
Debt Payoff Tracker
The opening rows of the file you get — sample data included, not a mock-up.

Finance template

Debt Payoff Tracker

Snowball ordering with months-to-clear and the true interest cost of paying minimums.

$12one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No signup, no watermark
23
live formulas, each one recalculated and checked
7
columns: Debt, Balance, APR, Min payment, Months to clear, Interest cost, Priority
5
figures worked out for you

Someone clearing cards or loans — usually looking for this when several debts at different rates and no clear order to pay them.

Need more than one? All 11 Finance templates for $39 — $176 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 23 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Debt Payoff Tracker template

Listing every debt in one place is the first step to getting rid of them. This Excel debt payoff tracker takes each balance, APR and minimum payment, and works out how many months each debt takes to clear and how much interest it costs if you only pay the minimum.

It orders your debts snowball-style, smallest balance first, and names both the debt to clear first and your highest-APR debt.

Good for

  • →Seeing the full cost of credit cards and loans in one table
  • →Choosing which debt to tackle first
  • →Understanding how long minimum payments keep you in debt

What it works out for you

Plan

  • →Clear this one first
  • →Highest APR debt
  • →Total owed
  • →Interest if minimums only
  • →Longest payoff (months)

What is inside the Debt Payoff Tracker template

The table has 7 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Debt
  • →Balance
  • →APR
  • →Min payment
  • →Months to clear
  • →Interest cost
  • →Priority

How to use the Debt Payoff Tracker in Excel

List every debt. Clear the smallest balance first, then roll its payment into the next — that is the snowball. Months to clear assumes you keep paying the minimum only.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

IFERRORINDEXMATCHMAXMINNPERRANKROUNDUPSUM

Questions about the Debt Payoff Tracker

What is the debt snowball method?

You pay the minimum on everything, put any extra towards the smallest balance, and once it is cleared roll that payment into the next smallest. The priority column orders debts this way.

Should I pay off the highest interest rate first instead?

Clearing the highest APR first — the avalanche method — usually costs less interest, while the snowball clears individual debts sooner. The tracker names both so you can choose.

How are months to clear worked out?

With Excel's NPER function, using each debt's balance, APR and minimum payment. It assumes you pay only the minimum and borrow nothing new.

What you get with the Debt Payoff Tracker

  • ✓23 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print on one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Debt Payoff Tracker for $12

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 11 Finance templates for $39, or all 66 for $99.

More finance templates

See all Finance →