Guide
Last updated: 5 November 2026. This guide shows you how to build and use a debt snowball spreadsheet, with a free template and a worked example on real debts. It is educational content, not financial advice. For personal decisions, consider a licensed financial advisor or a nonprofit credit counselor.
A debt snowball spreadsheet is a simple table that runs your debt snowball plan on one page. You list every debt from smallest balance to largest, with the balance, the APR and the minimum payment for each one. Then you track the plan month by month: minimums on everything, every extra dollar aimed at the smallest debt, and the freed payment rolling forward the moment a debt dies. That is the whole tool. No app, no account, no subscription. Just your debts, your numbers, and a plan you can see.
Why a spreadsheet instead of an app? Three reasons. First, it is yours. The file lives on your computer, not on someone else's server, and nobody can change the features or start charging for it. Second, it is honest. You type the numbers yourself, so you actually look at them, and looking at them is half the battle. Third, it is flexible. Add a column, change a payment, model a windfall. An app gives you its workflow. A spreadsheet gives you yours.
Start with the template below instead of a blank sheet. It has the columns already set up and the example debts from our snowball calculator filled in, so you can see how a finished plan looks before you replace the example with your own numbers.
The file is a plain CSV, which opens in Excel, Google Sheets and LibreOffice. There is nothing to install and no signup. Save a copy with your own name, then replace the example rows with your real debts.
Every column earns its place. If a column does not change a decision, it does not belong in the sheet.
| Column | What to put in it |
|---|---|
| Debt | The name of the debt, exactly as it appears on your statement |
| Balance | What you owe right now, copied from the statement |
| APR | The annual rate from the statement, not from memory |
| Minimum Payment | The smallest payment the lender accepts each month |
| Extra Payment | Any amount above the minimums, aimed at the target debt only |
| Payoff Month | The month this debt hits zero in your plan |
| Interest Paid | The total interest this debt costs before it dies |
The first four columns are facts from your statements. The last three are the plan. Keep the facts exact and the plan honest, and the spreadsheet will tell you the truth about your timeline every time you open it.
Step one: gather the statements. One statement per debt. You need the balance, the APR and the minimum payment for each one. Copy the APR from the statement. Most people misremember their rates by several points, and a wrong rate makes the whole plan fiction.
Step two: list the debts smallest balance first. This is the snowball order. The smallest balance sits at the top, because it is the first target. Do not sort by APR. Sorting by APR is the avalanche method, which is a fine method, but it is a different spreadsheet. If you want the avalanche order, read our snowball vs avalanche guide and sort by APR instead.
Step three: add up the minimums. Total the Minimum Payment column. That total is your floor: the amount that must leave your account every month no matter what. On the example debts below, the minimums add up to $365.
Step four: choose your extra payment. This is the amount above all minimums that attacks the target debt. Start with what you can sustain every month, even $50. The extra payment is the engine of the whole plan, so be realistic: a $200 extra you actually pay beats a $500 extra you abandon in month two.
Step five: write down the payoff order and the dates. Run the numbers through our debt snowball calculator once, then copy the payoff month and the interest for each debt into the sheet. Now the spreadsheet is not a wish list. It is a dated plan with a finish line.
Once a month, after every payment clears, update the Balance column with the new balances from your statements or your lender apps. Pay the minimum on every debt, then send the extra payment to the debt at the top of the list, the smallest one still alive. When a debt hits zero, delete its row or mark it paid, and add its minimum payment to the extra payment for the next debt. That roll is the snowball: each payoff makes the next payment bigger, which makes the next payoff come sooner.
Do not skip the monthly update. A spreadsheet you never open is decoration. The update takes five minutes, and it is the moment the plan becomes real again each month. Watching a balance fall by hundreds instead of by the minimum is the cheapest motivation in personal finance, and it is the reason the spreadsheet works: progress you can see beats progress you have to take on faith.
If a month goes wrong, a surprise bill or a smaller paycheck, update the sheet anyway. Record the real payment, not the planned one, and let the payoff months shift. A plan that absorbs a bad month and keeps going is a good plan. A plan that pretends bad months do not happen is a fantasy that collapses at the first surprise.
These are the debts prefilled in our snowball calculator: a $1,200 store card at 18.99% with a $35 minimum, a $4,800 Visa at 24.99% with a $120 minimum, and a $9,500 personal loan at 11.99% with a $210 minimum. Total debt is $15,500. Total minimums are $365. Add a $200 extra payment and the plan sends $565 a month at the debts in snowball order.
The store card dies first, in month 6, having cost $61.57 in interest. Its $35 minimum then rolls into the attack on the Visa, which dies in month 21, having cost $1,381.76 in interest. The Visa minimum of $120 rolls forward too, and the personal loan dies in month 34, having cost $2,219.17 in interest. Total interest is $3,662.50 and the total paid is $19,162.50. Debt free in 2 years and 10 months.
Now the comparison your spreadsheet makes obvious. Pay only the minimums on the same debts and it takes 5 years and 7 months with $8,744.54 in interest. The snowball saves $5,082.04 and 2 years and 9 months. Same debts, same income, same borrower. The only difference is a fixed $200 extra and a plan that aims it properly. Put both timelines in your spreadsheet, side by side, and look at them whenever motivation dips. That gap is what the $200 buys.
Use the two tools together, each for what it does best. The debt snowball calculator does the math: it simulates the payoff month by month, rolls the freed payments forward, and gives you the exact payoff month and interest for every debt. The spreadsheet does the tracking: it holds your live balances, records what you actually paid, and shows the plan moving in real life. Run the calculator when the plan changes, a new extra payment, a paid off debt, a windfall, and update the spreadsheet every month with what really happened. The calculator predicts. The spreadsheet remembers.
Sorting by APR instead of balance. That is the avalanche, not the snowball. It is a valid method, but if your sheet says snowball and sorts by APR, the plan and the label disagree, and you will second guess the order every month. Pick one method and sort for it.
Forgetting the roll. The most common error. A debt dies, and the freed minimum never gets added to the extra payment. The plan then crawls at the original extra instead of accelerating. Every payoff should make the next payment bigger. If your sheet does not show that, the roll is missing.
Not updating the balances. Stale balances make the payoff months fiction. Five minutes a month keeps the sheet honest. Set a recurring reminder for the day after your payments clear.
Adding new charges. Every new dollar on a card is a dollar the snowball has to melt later. The spreadsheet cannot fix spending. It can only show you, in plain numbers, what the new charges cost in months. Freeze the cards until the plan is done, and read the minimum payment trap if you want to see what minimum only payments do to a balance over decades.
Splitting the extra across all debts. Ten dollars extra on five debts feels fair and achieves nothing fast. Aim every extra dollar at one target until it dies. The spreadsheet makes this visible: one payoff month falls fast, the others wait their turn, and that is exactly how it should look.
Every figure in this guide comes from the same month by month simulation our calculators use, and every result is an estimate for education only, not financial advice. Real life includes fees, rate changes and missed payments, which the simplified math leaves out. Use the spreadsheet to plan, then check your real statements every month and adjust. If you want the full payoff playbook around the spreadsheet, read how to get out of credit card debt and how to become debt free.
It is a simple table that runs your debt snowball plan: every debt listed smallest balance first, with balance, APR and minimum payment, tracked month by month. You pay minimums on everything, aim every extra dollar at the smallest debt, and roll each freed payment into the next debt when one dies.
Yes. The free CSV template on this page opens in Excel, Google Sheets and LibreOffice, with no signup and nothing to install. It comes prefilled with the example debts from our snowball calculator so you can see a finished plan, then replace the example rows with your own numbers.
By balance, smallest first, for the snowball method. That order delivers the fastest first win, which keeps people going. Sorting by APR highest first is the avalanche method, which costs less in interest. Both work. Pick one, sort for it, and stop switching.
Once a month, after every payment clears. Update each balance from your statements, mark any debt that hit zero, and roll its minimum payment into the extra payment for the next debt. The update takes about five minutes and it is what keeps the payoff months honest.
Yes. The columns are identical. Just sort the debts by APR highest first instead of by balance smallest first, and aim the extra payment at the highest APR debt. Our avalanche calculator will give you the payoff months and interest for that order.
Then the spreadsheet shows you the slow road honestly, which is still useful: on the example debts, minimums only take 5 years and 7 months and cost $8,744.54 in interest. Even $25 or $50 extra bends that curve. Record the real payments, keep the sheet updated, and raise the extra whenever income allows.