Key takeaways
- The spreadsheet ranks your debts every month, rolls each paid-off payment into the next one and shows the month each debt reaches $0.
- A Snowball/Avalanche switch lets you compare both orders without retyping anything.
- In our four-debt example, the snowball clears its first debt in month 2 and finishes in month 27, with $2,608.16 of interest.
- Its formulas match our online calculators to the cent for the worked example. A test in our code checks this.
- The one-page printable tracker is for people who would rather color in progress than open a file.
This free debt snowball spreadsheet lists your debts, puts every spare dollar on the smallest balance and rolls each paid-off payment into the next one, month by month, until you reach zero. It works in Excel and Google Sheets, shows the month each debt is paid off, and comes with a one-page printable tracker.
Free, no sign-up or email. The Excel file also opens in Google Sheets, Numbers and LibreOffice: in Google Sheets, choose File › Import › Upload. Excel file 0.3 MB; PDF one page, US Letter.
Nothing to sign up for. The file runs entirely on your computer or in your own Google account, and the example values are hypothetical, ready to be replaced with yours.
How to use the spreadsheet in 5 steps
The file opens on a short “Start here” tab. The work happens on the second tab, “My debts.” Yellow cells are inputs; everything else is a formula, so you can type freely without breaking anything.
- Set your starting month. The first payment is modeled one month later, the same convention our calculators use.
- Enter the extra you can pay each month. This is the amount on top of all your minimums. If you are not sure yet, start with a figure you could repeat in a tight month, not your best month.
- Choose the payoff order. Snowball pays the smallest balance first. Avalanche pays the highest APR first. Switching takes one click, so try both.
- List your debts and read the results. Copy each balance, APR and minimum payment from your latest statement. The “Paid off in month” column and the debt-free month update instantly. The Schedule tab shows every month, debt by debt.
- Track it. Log what you actually pay on the “Payment log” tab. Every few months, replace the balances on “My debts” with fresh statement figures to get an updated forecast.
The monthly budget cell is worth a glance before you move on. It adds your minimums to your extra, and it stays the same every month. That fixed budget is what makes the snowball work: when a debt is paid off, its old minimum does not disappear back into your spending. It moves to the next debt in line.
A worked example: four debts, one budget
Here is the spreadsheet run on four hypothetical debts totalling $14,430, with $200 a month on top of the minimums. The figures come from our payoff engine, the same code behind the online calculators, and the spreadsheet reproduces them to the cent.
| Debt | Balance | APR | Minimum | Snowball payoff | Snowball interest | Avalanche payoff |
|---|---|---|---|---|---|---|
| Dental bill | $480 | 0% | $40 | Month 2 | $0.00 | Month 12 |
| Store card | $1,250 | 27.49% | $40 | Month 7 | $138.53 | Month 6 |
| Visa card | $4,800 | 22.15% | $130 | Month 20 | $1,153.15 | Month 19 |
| Personal loan | $7,900 | 11.5% | $245 | Month 27 | $1,316.48 | Month 26 |
| Total | $14,430 | $455 | Month 27 | $2,608.16 | Month 26 |
The dental bill goes first because it is the smallest, even though it charges no interest. Once it is gone in month 2, its $40 joins the $200 extra and lands on the store card. Each payoff makes the next target’s payment bigger, which is the “snowball” in the name.
Two things stand out. The whole plan takes 27 months, finishing in January 2029. And the order matters less than the commitment: paying only the minimums on each debt, with no rollover, would take 63 months and cost $5,901.07 in interest. The snowball saves $3,292.91 of that and finishes 36 months sooner.
Spreadsheet, calculator or app: which fits?
All three can use the same math. What differs is how much they ask of you and what they remember.
| Spreadsheet | Online calculator | DebtFree app | |
|---|---|---|---|
| Best for | Planning and tracking in one file you control | A quick answer or a what-if | Ongoing tracking with reminders |
| Remembers your numbers | Yes, in your file | No, it resets when you leave | Yes, on your iPhone |
| Logs payments | Yes, manually | No | Yes |
| Reminds you before due dates | No | No | Yes |
| Changes the math | Yes, if you edit formulas | No | No |
If you like seeing every number and want the plan in a file you own, the spreadsheet is a good home for it. If you only need a date, the debt snowball calculator is quicker. If the hard part is remembering to keep going, the DebtFree iPhone app keeps your debts, records payments and reminds you before due dates.
Snowball or avalanche?
The snowball and avalanche differ in one thing: where the extra money goes. Snowball picks the smallest balance; avalanche picks the highest APR. In the example, avalanche finishes in month 26 with $2,536.00 of interest, $72.16 less than the snowball. The snowball’s first win, Dental bill in month 2, comes sooner than the avalanche’s, Store card in month 6. Research on people in a debt program found that closing individual accounts was linked with paying off the whole balance, which is the case for early wins. For the method step by step, see the debt snowball method; for a full comparison, read debt snowball vs. avalanche, or flip the switch in the spreadsheet and see what it does to your own numbers.
Common spreadsheet mistakes
Most homemade debt spreadsheets go wrong in one of three places. This one is built to avoid them, but they are worth knowing if you adapt it or build your own.
Forgetting interest. Subtracting payments from balances without adding interest first makes every date look earlier than it will be. At 22% APR, a $4,800 card collects close to $90 in its first month. Leave that out and the forecast is off by months.
Not rolling payments over. If a paid-off debt’s payment simply vanishes from the plan, you are modeling minimum payments with a head start, not a snowball. The fixed monthly budget in this file prevents that.
Using a minimum that changes. Card issuers usually set the minimum as a small percentage of the balance plus interest, so it falls as you pay. The CFPB explains how minimums work and why paying only the falling minimum takes so long. For planning, enter today’s minimum and keep paying at least that amount. The spreadsheet holds it fixed, which is the more useful habit.
If even the minimums do not fit your budget right now, a spreadsheet will not fix that on its own. The CFPB suggests contacting your lenders early to ask about a lower payment, and considering a reputable nonprofit credit counselor.
The printable tracker
The one-page PDF is for the fridge or the inside of a notebook. It has a thermometer to shade in as your total falls, a short table for your debts in payoff order, and a payment log for the year. Print it on US Letter, fill in your starting total at the top, and mark every $500 or $1,000 paid off. It does not calculate anything, so use the spreadsheet or a calculator for the dates and the PDF to see the progress.
New to planning your payoff? Start with how to pay off debt, step by step, then come back for the file.
Common questions
Is there a free debt snowball spreadsheet for Google Sheets?
Yes. The Excel file on this page works in Google Sheets: upload it to Google Drive and open it with Sheets, or use File › Import. All of its formulas are supported by Google Sheets, Excel, Numbers and LibreOffice.
How do I make a debt snowball spreadsheet myself?
List each debt with its balance, APR and minimum. Each month, add interest (balance × APR ÷ 12), pay every minimum, then send whatever is left of a fixed monthly budget to the smallest balance. When a debt reaches zero, keep the budget the same so its payment moves to the next debt. The step people miss is keeping the budget fixed; without it, nothing rolls over.
What is the difference between a debt snowball spreadsheet and a calculator?
They use the same math. A calculator is faster for a one-off answer. A spreadsheet stays with you: you can update balances each month, log payments and keep notes. The debt snowball calculator is useful for checking the spreadsheet if you change its formulas.
Can I use the spreadsheet for the avalanche method?
Yes. Change Payoff order to Avalanche and the spreadsheet ranks debts by APR instead of balance. In the worked example, avalanche costs $72.16 less interest and finishes in month 26 instead of 27.
Why doesn’t the spreadsheet match my statement exactly?
Lenders often charge interest daily on your average balance, and card minimums usually fall as the balance falls. The spreadsheet charges APR ÷ 12 on each month’s opening balance and holds minimums fixed. Over a few months the difference is small; update your balances from statements now and then to keep the forecast honest.
How many debts does the spreadsheet handle?
Ten debts and 360 months (30 years). If you have more than ten, combine debts with the same APR into one row, or use the online debt payoff calculator, which takes up to 30.
Sources
- CFPB: Debt action plan (Your Money, Your Goals)
- CFPB: What should I do if I can’t pay my credit card bills?
- CFPB: Understanding minimum payments
- Kellogg School of Management: Can fighting small battles help win the war? (Gal and McShane, 2012)
Sources and worked examples are provided so you can check the reasoning. Our editorial process.
Educational information only. Not personalized financial, legal, or tax advice. See our disclaimer.
