Free Debt Snowball Spreadsheet (Google Sheets & Excel Template, 2026)

Get the Free Debt Snowball Spreadsheet

A free debt snowball spreadsheet for Google Sheets and Excel. Type in your debts, add what extra you can pay each month, and it gives you your payoff order, a month-by-month plan, your debt-free date and the total interest you will pay. One dropdown switches the whole sheet to the debt avalanche so you can compare. No email, no sign-up.

Google Sheets: click the button, then "Make a copy" to save your own editable version. Excel: open the download and enable editing. Works in Excel 2010 or later and in Numbers. Formulas only, no macros.

What's Inside the Template

Four tabs. You only type on the first one.

• Debts. One row per debt: name, balance, APR, minimum payment and type. Plus one cell for your extra monthly payment. It comes pre-filled with three example debts ($18,000 total) that you overwrite with your own. Up to 10 debts.
• Snowball Plan. Your payoff order, the payoff month and date for each debt, total interest, your debt-free date, and a full month-by-month schedule showing which debt gets the extra money and every balance after each payment.
• Avalanche Toggle. A dropdown to switch between Snowball and Avalanche. It also shows both methods side by side: months to debt-free, total interest and the interest the avalanche would save you.
• Progress. A chart of your total balance falling over time, and a checklist where you mark each debt paid off for real.

Every number is a live formula, so when you change a balance, a rate or your extra payment, everything else updates. The two calculation sheets that do the heavy lifting are hidden so the template stays tidy; right-click any tab and choose Unhide if you want to see them.

How to Fill It Out in 5 Minutes

• 1. Gather your statements. For each debt you need today's balance, the APR and the minimum payment. Your lender's app or latest statement has all three.
• 2. Fill in the Debts tab. Overwrite the example rows. Enter APR as a percentage (24%, not 0.24). Leave unused rows blank.
• 3. Enter your extra payment. The amount you can commit on top of all minimums, every month. Not sure? Start with $50 and see what it does to your date, then try $100.
• 4. Check the start month. It defaults to this month. Change it if your plan starts later.
• 5. Open the Snowball Plan tab. Your debt-free date is at the top. The schedule below tells you exactly what to pay on each debt each month.

Then, once a month: log your new balances on the Debts tab and tick off anything you've finished on the Progress tab. Want structure for the first month? Pair the sheet with the free 30-Day Debt Snowball Challenge.

Snowball vs. Avalanche in the Same Sheet

The template ships with three example debts: a $6,000 credit card at 24% APR ($150 minimum), a $3,000 personal loan at 12% ($90 minimum) and a $9,000 car loan at 7% ($250 minimum), with $100 extra a month. Here is what the Avalanche Toggle tab shows for them:

The avalanche saves $520 and a month. The snowball clears the $3,000 loan in month 18, while the avalanche's first full payoff (the credit card) comes in month 34. Both beat minimums-only by roughly a year and $2,000, which is the bigger lesson: the extra $100 matters more than the order. For help choosing, read which method is right for you, or the real-numbers comparison. Our snowball method and avalanche method guides go deeper on each.

The Formulas, Explained

Building a debt snowball spreadsheet in Excel yourself? These are the formulas the template uses. Each month, for each debt:

Interest   = ROUND(StartBalance * APR / 12, 2)
Minimum    = MIN(MinimumPayment, StartBalance + Interest)
Extra      = MAX(0, MIN(StartBalance + Interest - Minimum,
                        Budget - SUM(all minimums this month)
                               - SUM(extra already given to higher-priority debts)))
Payment    = Minimum + Extra
EndBalance = StartBalance + Interest - Payment

Budget is the sum of all your original minimums plus your extra payment, and it stays fixed. That's the snowball: when a debt is paid off, its minimum isn't spent elsewhere, it stays in the budget and flows to the next debt through the Extra line.

Payoff order is a rank. For the snowball, each debt's rank is how many debts have a smaller balance, plus one:

=COUNTIFS(Balances, "<" & ThisBalance, Balances, ">0") + 1

For the avalanche, swap in the APR column with a ">" comparison. The schedule then pulls debts in rank order with INDEX(Names, MATCH(rank, Ranks, 0)), which is what makes the toggle work: changing the dropdown changes which rank column the plan reads.

Payoff month is the first month a balance hits zero, MATCH(0, EndBalances, 0), and the debt-free date is EDATE(StartMonth, PayoffMonth). Total interest is a plain SUM down the interest column. No macros, no scripts, nothing newer than Excel 2010, so it behaves identically in Google Sheets.

5 Ways Debt Spreadsheets Break

We built this template carefully, and we still want to be honest: a spreadsheet is the right tool for planning and a fragile tool for following through. Here is where they usually fall apart.

• 1. Extra payments don't flow through. You pay $60 more than planned one month and the sheet has no idea. Six months later the balances in the sheet and the balances at your lenders don't match, and you stop trusting it. Toffee has you log each payment as you make it, and the plan and debt-free date move right away.
• 2. Rates change. A promotional 0% ends, a variable rate ticks up, a card issuer reprices you. Each one means editing the sheet and re-checking that nothing broke. In Toffee you change the rate on that debt and everything recalculates.
• 3. Balance transfers and new debts. Moving a balance to a new card means deleting one row, adding another and hoping the formulas still cover both. Toffee treats a debt as a thing you add, edit or close, not a row you have to keep intact.
• 4. No reminders. The spreadsheet doesn't know a due date is tomorrow. One late fee and a penalty APR can erase months of extra payments. Toffee reminds you before each due date.
• 5. It's hard to use on a phone, so you stop opening it. Debt payoff is a two or three year habit, and habits live on your phone. Pinching around a 70-column schedule in a mobile browser is not something anyone does in month nine. Toffee's home screen shows your debt-free date, your next target and your progress, and that is the whole point of opening it.

Spreadsheet vs. App: When to Switch

Use the spreadsheet to understand your situation and build the plan. It's free, it's transparent and you can see every formula. Keep using it if you enjoy the monthly update ritual and your debts are stable.

Switch to an app when the plan is set and the job becomes execution: paying on time, logging payments, and staying motivated for a few years. That is what Toffee is built for.

Your plan, on your phone

• Reminders. A nudge before each due date, so a late fee never undoes your extra payment.
• No bank login. You enter balances yourself, so Toffee never asks for your bank credentials.
• Free to download. Unlock Toffee Pro in the app when you're ready; current plans are shown there.
• Snowball and avalanche. Switch any time; your debt-free date updates on the spot.

Download on the App StoreGet it on Google Play

9:41

Toffee

Hey, Terry

Here's your finish line today.

Debt-free date

June 2029

7 months sooner with extra payments

68% paid

Debt calendar

Sep 2026

SUMOTUWETHFRSA3031123456789101112131415161718192021222324252627282930123

Past due Upcoming

Debt breakdown

TOTAL$8,400

Credit Card60%

Auto Loan40%

HomeDebtsPaymentsMore

Debt Snowball Spreadsheet FAQ

How do I do the debt snowball step by step?

List every debt with its balance, APR and minimum payment. Sort them smallest balance to largest. Pay the minimum on every debt, and put every extra dollar on the smallest balance until it hits zero. Then roll that debt's whole payment, minimum plus extra, into the next smallest. Repeat until the last debt is gone. The spreadsheet does everything after the first step for you; the free debt snowball calculator does the same in your browser.

Does the spreadsheet include an amortization schedule?

Yes. The Snowball Plan tab is a month-by-month amortization schedule for all your debts together: interest charged, total payment, every remaining balance and the debt receiving the extra money, for up to 30 years.

Can I use this as a credit card snowball spreadsheet?

Yes. Add each card as its own row. Card minimums usually shrink as the balance falls, so enter today's minimum and keep paying that fixed amount. The sheet assumes fixed payments, which is also what gets you out fastest. If your card balances aren't moving, read why your credit card balance isn't going down.

Snowball vs. avalanche: which is better?

The avalanche always costs less in interest. The snowball gets you a paid-off account sooner, which is what keeps many people going. On the template's example debts the gap is $520 and one month. Use the Avalanche Toggle tab to see your own gap, or run the debt avalanche calculator next to the snowball version. Then pick the one you'll finish.

Is it really free?

Yes. No email form, no sign-up. Make a copy in Google Sheets or download the Excel file and it's yours. If you want the same math without any spreadsheet, our debt payoff calculator is free too, and it can export your plan in the same layout.