Debt Payoff Spreadsheet, Snowball and Avalanche Calculator
$7.99
If you don't know which debt to pay first, when you'll be debt free, or whether an extra $100 a month really makes a difference, this answers all three. Enter your debts once and it shows the snowball and avalanche methods side by side, with the payoff date and total interest for each, how much the cheaper method saves, and what an extra payment changes. Then log your real payments each month and watch your balance fall on the Dashboard.
Share
What's inside
- Debt_Payoff_Tracker.xlsx: the blank workbook for your own debts
- Debt_Payoff_Tracker_EXAMPLE.xlsx: the same workbook filled in for a made-up household, so you can see a finished plan before you start
- START_HERE.txt: what to open first and how to open it in Google Sheets
- Start Here: 8 quick steps and a color legend
- Dashboard: total debt, current balance, paid so far, % paid off, debt-free month, months to go, interest saved and ahead or behind, plus 4 charts
- Setup: start month, monthly budget, an optional one-time extra payment, your method and up to 25 debts, with a check that warns if your budget doesn't cover the minimums
- Snowball Plan: smallest balance first, month by month for up to 30 years, with each debt's payoff month
- Avalanche Plan: highest APR first, same layout
- Compare: both methods side by side, payoff order for each debt and the what-if box
- Payment Log: up to 600 real payments, an optional statement balance column, and ahead or behind by month
- Both methods side by side at all times. No dropdown, no guessing.
- Interest saved and months saved, in plain words, for example "Avalanche saves $801 in interest and 1 month."
- A what-if box: type any extra monthly amount and see your new debt-free month for both methods.
- Planned vs actual: log real payments and see if you are ahead or behind your plan.
Who it's for
- People paying off credit cards, car loans, student loans, or medical bills
- Households comparing snowball and avalanche side by side
- Anyone who wants a payment log next to the payoff plan
Before you buy
For planning only. Not financial advice. Results are estimates based on the numbers you enter. Interest is figured monthly as balance times APR divided by 12, so your lender's numbers may differ slightly. Built by ReconciledBooksCo, a small shop run by an experienced accountant. These templates are organizational tools only and are not tax, legal or accounting advice. Check with a qualified professional for your situation.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one household per purchase.
