Home › Personal Finance › Debt Payoff Tracker Spreadsheet (Snowball & Avalanche)

The Debt Payoff Planner debt snowball and avalanche spreadsheet for Excel and Google Sheets, with room for 50 debts. A dashboard preview shows total debt, debt-free date, total interest and interest saved, with labels for Snowball, Avalanche, Custom order, Interest saved and Debt-free date.

Debt Payoff Tracker Spreadsheet (Snowball & Avalanche)

A debt payoff plan is easier to follow when you can see where it ends. The Debt Payoff Planner takes your debts, your minimum payments and an extra monthly amount, and shows a debt-free date and the interest you would pay.

Choose snowball (smallest balance first), avalanche (highest rate first) or your own order. The sheet compares them side by side with paying only the minimums, and builds a month-by-month plan in which each cleared debt rolls its payment over to the next.

It is a digital download for Excel and Google Sheets, with room for up to 50 debts.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Up to 50 debts with type, balance, APR and minimum payment
Snowball, avalanche, custom order and minimums only, compared side by side
Debt-free date, total interest and interest saved for each strategy
A month-by-month payoff plan for up to 30 years
One-off extra payments such as a tax refund or a bonus
A progress log with a chart of your balance falling

Who it's for

Anyone with credit cards, loans or other debts to pay down
People deciding between the snowball and avalanche methods
Anyone who wants to see the effect of an extra monthly payment

How it works

Choose a strategy and type your extra monthly payment on Start Here.
List your debts with balance, APR and minimum payment.
Add one-off extra payments if you expect any.
Follow the Dashboard and the Payoff Plan, and update your balances as they change.

See inside

Debt payoff dashboard with 8 summary tiles and charts for total debt over time by strategy, total interest by strategy, debt by type and months to pay off each debt, plus a strategy comparison table and the focus debt for the extra payment.

Strategy comparison table showing the debt-free date, total interest and interest saved for Minimums only, Snowball, Avalanche and Custom, next to charts of total interest by strategy and debt by type, and the focus debt that gets the extra payment first.

Debts tab listing debts with type, balance, APR and minimum payment, plus a data check, payoff order, debt-free month, interest to pay and the date each debt would be paid with minimum payments only.

Payoff Plan tab with a month-by-month table showing the payment date, total paid, interest, amount toward the balance, balance after, debts left, the debt cleared that month and cumulative interest.

Extra Payments tab for one-off payments such as a tax refund or bonus, above the Progress tab with a table of total debt over time, how much is paid off so far and a line chart of the balance falling.

Start Here tab with strategy dropdown, extra monthly payment and first payment month, a short explanation of how the payoff plan works, seven setup steps, a color code and a list of the tabs.

List of the 6 tabs included in The Debt Payoff Planner and three steps: download, add your debts and extra payment, then follow your payoff plan. No macros, no subscription, for your own use, digital download.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files and do not sync.

Does it give financial advice?

No. It is a planning tool. Results depend on the numbers you enter, so confirm balances, rates and payments with your lenders.

Which strategy is better?

Avalanche usually has the lowest interest cost and snowball clears small debts first. The comparison table shows both for your own numbers.

Is there an example file?

Yes. A second Excel file is filled with example data, so you can see how everything works before using your own numbers.