Personal finance

Free Debt Payoff Tracker Spreadsheet

List balances, rates, and minimums; track avalanche or snowball progress.

What this is

List every debt with balance, APR, and minimum payment, then focus extra payments using avalanche (highest APR) or snowball (smallest balance). The goal is a single source of truth for payoff order.

Best for

  • People juggling cards, loans, and BNPL
  • Anyone choosing between avalanche and snowball methods
  • Couples aligning on which debt dies first

What’s included

  • Balance, APR, minimum, and extra payment columns
  • Method and status fields
  • Sample mixed-rate debts to replace with yours

Preview

Debt nameBalanceAPR %Minimum paymentExtra paymentMethodStatus
Card A240022.975150AvalancheActive
Card B90019.9350AvalancheActive
Student loan110005.21200AvalancheActive
Car loan68007.12100AvalancheActive
BNPL phone3200800AvalancheActive
Old store card024.000AvalanchePaid

How to use

  1. List every debt with balance, APR, and minimum payment.
  2. Pick Avalanche (highest APR first) or Snowball (smallest balance first).
  3. Put Extra payment on the target debt; keep minimums on the rest.

Tips

  • Always pay minimums on every debt; park Extra payment on one target only.
  • Re-sort after a rate change or balance transfer.
  • Celebrate closed debts by moving them to Status = Paid and freezing the row.

FAQ

Avalanche or snowball?

Avalanche usually costs less interest. Snowball can feel faster psychologically. Pick one and stick to it for 90 days.