Debt Snowball Worksheet (Free Printable)

Most people who try the debt snowball fail at the same tiny spot. Not the idea, the paperwork. They understand "smallest balance first" perfectly well, then never write it down anywhere, so the plan lives in their head and quietly falls apart by the third month. The fix is almost embarrassingly simple. One sheet of paper with five columns turns a vague intention into something you can look at, update, and finish.

This article shows you the exact worksheet, column by column, and teaches you to build your own for free. No download, no email signup, no PDF to buy. You will recreate a small table on paper, in a free Google Sheet, or in a free Canva file, and by the end you will know how to list your debts in the right order, calculate the rolling snowball payment, and pencil in a real payoff date next to each one. Let's build it.

What the debt snowball worksheet actually does

The debt snowball is a payoff order, not a budget. You keep paying the minimum on every debt so nothing goes late, then you take every spare dollar and pile it onto the smallest balance until it is gone. When that one dies, its whole payment rolls onto the next smallest debt. The payment you attack with keeps growing, which is where the "snowball" name comes from. If you want the full method with all the reasoning behind it, the debt snowball method guide covers it in depth.

The worksheet is the piece that makes the method survive contact with real life. It does three jobs. It fixes your attack order so you never wake up unsure which debt to pay. It shows the rolling payment amount for each stage, so when a debt clears you know exactly what number to throw at the next one. And it holds a payoff date beside every debt, which is the thing that keeps you going when month four feels slow. A method in your head drifts. A method on paper gets finished.

The five columns you need

Your entire worksheet is one table with five columns. That is it. Resist the urge to add ten more. Every extra column is one more thing to maintain, and the reason worksheets get abandoned is that they feel like homework. Here are the five and what each one holds.

Debt. The name of the lender or account. Keep it short and recognizable, like "Store card" or "Medical bill." One row per debt.

Balance. What you currently owe on that account, pulled from your latest statement. This is the number that decides the order, so get it right.

Min payment. The minimum monthly payment the lender requires. You pay this on every debt, every month, no exceptions, so nothing goes into collections while you focus your extra money elsewhere.

Order. The rank in your attack plan, from 1 (smallest balance, paid first) to however many debts you have. You fill this in after you sort by balance.

Rolling payment. The amount you actually throw at that debt when it becomes your target. For debt number 1, it is your extra money plus that debt's own minimum. For every debt after, it grows, because you add the freed-up payments from the debts you already killed.

Here is the empty worksheet, ready to copy onto paper or into a sheet.

Draw five columns, label them exactly like that, and leave yourself a row for each debt plus one spare. The whole plan fits on a single page.

Listing your debts smallest to largest

The snowball lives or dies on the order, so this step matters. Gather every debt you owe. Credit cards, store cards, medical bills, personal loans, car loans, the money you borrowed from your sister. Everything except your mortgage, which is usually handled separately because of its size. Do not leave a debt off because it embarrasses you. A worksheet with a hidden debt is a worksheet that lies to you.

Now write each debt on its own row with its balance and minimum payment. Ignore interest rates completely. This is the part that trips up people who love math, because it feels wrong to pay off a low-balance, low-interest debt before a high-interest monster. But the snowball is built on motivation, not optimization. Killing a small debt fast gives you a real win early, and that win is what keeps you in the game. If you would rather chase interest savings instead, the debt avalanche vs snowball comparison lays out the honest trade-off so you can choose on purpose.

Once every debt is listed, sort the rows from smallest balance to largest. Number them in the Order column, 1 for the smallest, going up. That order is now locked. You do not reshuffle it when a new statement arrives or when you feel like it. You attack in order, top to bottom, one debt at a time.

Calculating the rolling snowball payment

This is the engine, and it is the one calculation people get wrong. Start with two numbers: the total of all your minimum payments, and your extra amount, meaning the spare money above minimums you can commit each month. Be honest about the extra. Promise a number you can hit on a normal month, not your best month ever.

Debt number 1 gets attacked with its own minimum plus your entire extra. Every other debt gets only its minimum for now. When debt 1 is paid off, you do not pocket that money. You roll it forward. Debt 2 now gets its own minimum, plus debt 1's old minimum, plus your extra. When debt 2 dies, all of that rolls onto debt 3. The attack payment gets bigger at every stage while your total monthly outlay stays exactly the same.

A quick example makes it click. Say your minimums add up to $455 and you have $300 extra, so you pay $755 total every month. Here is how the rolling payment grows as each debt clears.

• Debt 1 target payment: its minimum plus $300 extra
• Debt 2 target payment: its minimum plus debt 1's freed minimum plus $300 extra
• Debt 3 target payment: its minimum plus debts 1 and 2's freed minimums plus $300 extra
• Final debt: nearly the full $755, because almost every minimum has rolled in

Your total monthly payment never changes. It stays $755 from start to finish. All that shifts is where the money points, and it points harder every time a debt falls off the list.

A full worked example

Let's fill in a complete worksheet so you can see the whole thing assembled. Imagine four debts, listed smallest to largest, with minimums that total $455. You can put $300 extra toward debt, so your total monthly attack is $755.

Read the rolling payment column from the top. Debt 1, the store card, gets its own $25 minimum plus the $300 extra, so $325 a month. At roughly $325 against a $600 balance, it clears in about two months. First debt dead.

Now that $25 rolls forward. The medical bill gets its $50 minimum plus the freed $25 plus $300 extra, which is $375. Against $1,400, it clears in about four months. Two debts down, and notice the attack payment already grew.

The freed minimums keep stacking. The credit card gets $120 plus $25 plus $50 plus $300, which is $495 a month against $3,900. The car loan, the biggest by far, gets the full $755 once everything ahead of it is gone, because every minimum has now rolled in. A $9,100 balance falls fast under a $755 attack. The whole $15,000 disappears in roughly two years on this plan, and the worksheet showed you the shape of it before you paid a single dollar.

The exact months are not the point. The shape is: each debt gets a bigger payment than the last, and each one falls faster than its balance suggests. To turn these into real payoff dates for your own numbers, run them through a debt payoff calculator and write the dates into that optional sixth column.

Coloring in progress and tracking payoff dates

A worksheet full of numbers works, but you can make it pull you forward. Beside each debt, draw a simple progress bar made of equal boxes, where each box stands for a fixed dollar amount paid off. For a small debt, one box per $100 feels satisfying. For the car loan, one box per $500 keeps the bar from stretching off the page. As you pay, shade the boxes in from one end. A full bar means a dead debt.

On paper, use a marker or a highlighter. In Google Sheets, use the fill-color tool to shade cells. In Canva, drop a row of square shapes and recolor them each month. The tool does not matter. What matters is the visible filling, because a colored box is a small reward your brain actually feels, and those small rewards are what carry you through a two-year plan.

Add the payoff date beside each bar too. Once your calculator gives you an estimate, write "cleared by" and the month next to every debt. Now the worksheet is not just a list, it is a countdown. Watching a colored bar creep toward a real date is far more motivating than staring at a balance that barely moves. For a deeper walkthrough of the color-in idea and a couple of chart layouts, the debt payoff tracker printable post pairs neatly with this worksheet.

How to update it every month

A worksheet you fill in once is a decoration. The ritual of updating it is half the value, so give it a fixed home in your month. Pick a day, ideally payday, and treat it like a small appointment with yourself.

On that day, open your real statements and read the new balances, which already include any interest that accrued. Do not just subtract your payment from last month's number, because that ignores interest and makes the worksheet lie in your favor. Copy the actual current balance into the Balance column for each debt. Then color in your progress bars to match how far each balance has truly dropped.

When a debt hits zero, cross it off and immediately update the Rolling payment for the next target, adding the freed-up minimum. This is the moment the snowball grows, and doing it on the worksheet the same day keeps you from accidentally spending that money. If your extra amount changed because your budget shifted, update it too. Building this ten-minute monthly review into your routine is one of the most reliable ways to save money every month and stay on plan, because the plan only works if you keep looking at it.

Making your own free printable version

You do not need to pay for a template. Here is the honest free path to a printable worksheet you own.

1. Open a blank Google Sheet or Google Doc. Recreate the five-column table exactly as shown above, one row per debt plus a total row.
2. Add progress-bar cells beside each debt, a row of empty cells you will shade with the fill-color tool as you pay.
3. When it looks right, choose File, then Print, then set the destination to "Save as PDF." That gives you a real PDF you made yourself, for free.
4. Print it and pin it somewhere you cannot avoid, like the fridge, or keep the sheet open and update it digitally each payday.
5. Want it prettier? Open free Canva, start a blank A4 layout, add a table and a row of square shapes for the bars, then export to PDF the same way.

That is the whole trick. The worksheet is a layout you control, not a mystery download you have to trust.

Frequently asked questions

Do I ignore interest rates completely on a snowball worksheet?

For the order, yes. The debt snowball sorts strictly by balance, smallest to largest, and ignores APR when deciding what to attack first. That is the whole point, quick wins over interest math. You still record each balance from statements that include interest, so the numbers stay honest, but interest rate does not change your attack order. If saving the most interest matters more to you than momentum, use the avalanche method instead, which sorts by rate.

What if two debts have almost the same balance?

Pay whichever is smaller first, even by a few dollars, because the snowball is about clearing debts fast to build momentum. If they are truly identical, break the tie with the higher interest rate, since clearing that one saves you a little money on the side. It genuinely does not matter much. Pick one, lock the order, and keep moving rather than agonizing over a tie.

Should the mortgage go on the worksheet?

Usually no. Most people leave the mortgage off the snowball because its size would dwarf everything else and stall your momentum for years. Focus the worksheet on consumer debt: credit cards, store cards, medical bills, personal loans, and car loans. Once those are gone and you have built a solid emergency fund, you can decide separately whether to attack the mortgage, but it does not belong in the snowball rows.

How often should I recalculate the rolling payment?

Only when a debt is fully paid off. Between payoffs, your rolling payment for the current target stays the same every month. The moment a debt clears, add its freed-up minimum to the next target's rolling payment and update that cell on your worksheet the same day. Your total monthly outlay never changes, so the only recalculation is shifting the freed money forward each time a debt dies.

What happens to the worksheet if I miss a month?

Nothing breaks. The worksheet is a tool, not a contract. If you miss a payment or fall behind, just pull the current balances at your next update, color the bars to match, and keep going from where you are. The boxes you already shaded stay shaded, and the debts you already cleared stay cleared. One rough month does not erase your progress, and the visible proof of what you have already paid off is exactly what helps you restart.

Start your worksheet this week

The debt snowball is not complicated, and neither is the worksheet that runs it. Five columns, one row per debt, smallest balance at the top. Write your debts down, sort them, figure out the extra you can commit, and pencil in the rolling payment for each stage. Then pick a payday to update it and color in your first box the moment you make a payment. The magic was never in a fancy template. It was in having the plan somewhere you can see it, month after month, until the last balance hits zero. Build your worksheet this week and give the momentum a place to grow.