Debt Payoff Tracker Spreadsheet 2027: Snowball vs Avalanche Calculator, Debt Payoff Planner, Excel and Google Sheets

List your debts once and see two month-by-month payoff plans side by side: snowball (smallest balance first) and avalanche (highest interest rate first).

SAVE WITH THE BUNDLE: this file is also in the 2027 Money Bundle, $15 for all 6 spreadsheets ($37 if bought one by one, so you save $22): https://payhip.com/b/lr2gf

What's inside:

- Debts: up to 10 debts with balance, APR and minimum payment. It shows each debt's payoff order for both methods and its interest this month, and it flags a minimum payment that doesn't cover the interest.

- Settings: the extra amount you can add each month, your first payment month, and which method you're following.

- Snowball and Avalanche tabs: up to 20 years month by month. Each month, every debt gets its minimum, and the extra (plus the minimums freed up by paid-off debts) goes to the debt at the front of the line.

- Compare: months until debt-free, the debt-free month, total interest and total paid for each method, plus the difference. It also shows each debt's payoff month and a "Pay this month" list for the method you picked.

- Payment Log: record the payments you actually make. Each debt shows the total you've logged.

- Instructions tab first, dropdowns, locked formula cells and a layout designed for small screens.

Who it's for: Anyone paying down credit cards, loans or medical bills who wants a plan and a payoff date to aim for, and wants to see what each method costs in interest with their own numbers.

Estimates only. Interest is figured once a month from the APR you type in. Real lenders may compute interest daily, add fees or change rates, so your statements are the final word. Not financial advice. The file only does math on the numbers you type in.

Everything is typed in by hand. There is no live data and no account connection. The sample data is made up, so you can delete it and enter your own.

Format: one .xlsx file. Open it in Excel, or upload it to Google Sheets. It uses only standard formulas that both support. No macros, no add-ons, no links to other files.

Delivery: instant download after checkout. The download link is also in your receipt email.

Questions or a problem with the file? Use this store's Contact page, or email the address in your receipt. If the file doesn't work for you, we'll fix it or refund you.

License: personal use. Use it for yourself. Please don't resell, share or re-upload the file.

Built and tested with AI assistance.