Free Debt Snowball Spreadsheet Template: Set It Up and Use It
A free debt snowball spreadsheet is a simple table that lists your debts from the smallest balance to the largest. It sends every extra dollar to the smallest one until it is gone, then rolls that payment into the next. Below I show the columns a good template needs, how to build one in any spreadsheet program, and a worked example with the math shown.
What a debt snowball spreadsheet actually does
The debt snowball is a payoff order, not a new loan or a product. You keep paying the minimum on every debt, and you put any extra money toward the debt with the smallest balance. When that debt hits zero, its old payment joins the extra money and moves on to the next smallest balance. The payment grows as it rolls, like a snowball rolling downhill.
A spreadsheet helps because it keeps the order, the payments and the balances in one place. You can see each month what goes where and which debt is next. If you want the full background on why people choose this order, our guide to how the debt snowball method works covers it in more detail.
- It shows your total debt and total minimum payments at a glance.
- It tells you which single debt gets the extra money this month.
- It gives you a record of progress, which many people find motivating.
The columns a debt snowball spreadsheet template needs
You do not need anything fancy. A working debt snowball spreadsheet template only needs a handful of columns, one row per debt, sorted by balance from smallest to largest.
| Column | What goes in it |
|---|---|
| Debt name | A short label, such as "Store card" or "Car loan" |
| Balance | What you owe today, from your latest statement |
| Interest rate (APR) | The yearly rate on the statement |
| Minimum payment | The lowest amount the lender requires each month |
| This month's payment | The minimum, plus the extra if this debt is first in line |
| Interest this month | Balance times APR, divided by 12 (a close estimate) |
| New balance | Balance plus interest, minus this month's payment |
The interest column is an estimate. Card issuers usually figure interest on your average daily balance, so your statement can differ by a little. That is fine for planning.
How to set up an excel snowball debt spreadsheet
An excel snowball debt spreadsheet works the same way in any spreadsheet program. Here is the setup in plain steps.
- Gather your latest statements so the balances, rates and minimums are current.
- Enter one debt per row and sort the rows by balance, smallest at the top.
- Decide your total monthly debt budget, the amount you can put toward all debts combined.
- Subtract the total of all minimums from that budget. What is left is your extra amount.
- Add the extra amount to the payment of the top row only.
- Copy the table for the next month, carrying each new balance forward.
- When the top debt reaches zero, add its whole payment to the next row's payment.
If you would rather not start from scratch, download our free debt payoff spreadsheet for Excel. You list each debt with its balance, APR and monthly payment, and it calculates this month's interest, months to pay off and the snowball order, with a payment log sheet for each month. It also works when uploaded to Google Sheets. To skip formulas entirely, the site has a debt snowball calculator you can use that does the month by month math for you. You can also print our debt snowball worksheet or another of our printable debt payoff worksheets and track it by hand.
A worked example with the math shown
Example: Say you have three debts and $300 a month to put toward all of them. These numbers are made up to keep the math simple.
- Debt A: $500 balance, 20% APR, $25 minimum
- Debt B: $2,000 balance, 18% APR, $60 minimum
- Debt C: $5,000 balance, 10% APR, $100 minimum
Minimums add up to $25 + $60 + $100 = $185. Your extra amount is $300 minus $185 = $115. Debt A has the smallest balance, so it gets $25 + $115 = $140 this month.
Month 1 interest on Debt A: $500 × 20% ÷ 12 = about $8.33. New balance: $500 + $8.33 minus $140 = $368.33.
Month 2: $368.33 × 20% ÷ 12 = about $6.14 in interest, so $368.33 + $6.14 minus $140 = $234.47. Month 3 brings it to about $98.38. In month 4, about $100.02 pays off Debt A, leaving roughly $39.98 of that month's planned $140 payment available for Debt B, assuming the lender permits the payment and the schedule allows it.
Starting the following month, the $140 previously budgeted for Debt A rolls into Debt B. Debt B then gets its own $60 plus $140 = $200 a month; any unused amount from Debt A's final payment can also go toward Debt B in the payoff month. When Debt B is gone, that $200 joins Debt C's $100, so Debt C gets the full $300. The total you pay each month never changed. Only where it goes changed.
Spreadsheet, calculator or dashboard: the trade offs
A spreadsheet gives you full control and costs nothing beyond the program you already have. The trade off is upkeep: you enter every balance, copy every month and fix any broken formula yourself. A calculator does the math instantly but usually does not save your month to month history. If you are weighing the snowball against paying the highest rate first, the snowball versus avalanche comparison calculator shows both orders side by side.
A third option is the site's own Clearora™ Debt Payoff Dashboard. It is an online dashboard with tabs for credit cards, balance transfers, car loans, personal loans and mortgages, plus a save and load feature so you can come back to your numbers. It comes with a manual, a video and a private Skool community called Get Out of Debt Club. You can read what is included on the Clearora dashboard and community page. It is one choice among several; the spreadsheet and calculators here do the core snowball math too. You can see every tool we offer on the main debt payoff tools page.
Common mistakes when using an excel debt snowball template
An excel debt snowball template is only as good as the numbers in it. These are the slips I see most often.
- Old balances. Update from real statements each month, not from memory.
- Forgetting new charges. If you keep using a card, its balance in the sheet will be lower than the real one.
- Dropping the rolled payment. When a debt is paid off, its payment has to move to the next debt, or the snowball stops growing.
- Missing a minimum. The extra goes to one debt, but every other debt still needs its minimum on time.
- Treating estimates as exact. The sheet's interest is close, not perfect. Your statement is the final word.
FAQ
Do I need Excel to use a debt snowball spreadsheet?
No. The same columns and formulas work in any spreadsheet program, and you can also track the snowball on paper or with one of the site's calculators.
Why order debts by balance instead of interest rate?
The snowball puts the smallest balance first so you see debts disappear sooner, which some people find easier to stick with. Ordering by highest rate first, called the avalanche, usually costs less in interest. Both are valid; it is a trade off between motivation and total interest.
What if I cannot cover all my minimum payments?
The snowball assumes every minimum gets paid. If that is not possible, the spreadsheet will show the gap clearly. The CFPB (consumerfinance.gov) has plain information about talking with creditors and about debt help options.
How often should the spreadsheet be updated?
Many people update it once a month, right after statements arrive. That keeps the balances real and shows when it is time to roll a payment to the next debt.