Quick answer: A debt snowball spreadsheet is a simple table that lists your debts from smallest balance to largest, then tracks each month’s payment, interest and new balance. You can build one free in Google Sheets or Excel with about eight columns and four basic formulas. Set it up once, update it monthly, and you’ll see exactly when each debt disappears.
Key takeaways
- Sort debts smallest balance first; pay minimums on all, then throw every extra dollar at the smallest.
- You need only a few columns: name, balance, APR, minimum payment, monthly interest, payment and new balance.
- Four formulas do all the work: interest, payment, new balance and “rolled-over” minimums.
- Update it once a month with your real numbers so the plan stays honest.
The snowball method is popular because quick wins build momentum. A spreadsheet turns that momentum into a visible, trackable plan. Below is the full setup, with every formula explained in plain words and a sample table you can copy.
Want the plan built for you instead? Request free options to lower your interest rate using the form on this page, then come back and plug the new rates into your sheet.
How the debt snowball works (30-second version)
The snowball is one of several approaches covered in our debt payoff plans guide. Here is the whole method:
- List every debt from the smallest balance to the largest, ignoring interest rate.
- Pay the minimum on everything except the smallest debt.
- Put all extra money toward the smallest debt until it’s gone.
- Roll that payment into the next-smallest debt. Repeat.
The math tradeoff: the snowball can cost a bit more interest than the debt avalanche method, which targets the highest rate first. In exchange, you eliminate accounts sooner, and many people stick with a plan that gives early wins.
Debt snowball spreadsheet columns: what to build
Open a blank Google Sheet or Excel workbook. Make a tab called Debts and set up these columns in row 1:
- A: Debt name (for example, Store Card, Visa, Car Loan).
- B: Starting balance (what you owe today).
- C: APR (the annual interest rate, entered as a percentage like 24.99%).
- D: Minimum payment (the required monthly amount).
- E: Monthly interest (a formula, explained below).
- F: Payment this month (minimum, plus any extra for the target debt).
- G: New balance (a formula).
- H: Payoff order (1 for the smallest balance, 2 for the next, and so on).
Then add a small input area above or beside the table with two cells: Total monthly budget for debt (every dollar you can send to debt, minimums included) and Month number.
Pull your balances and rates from your latest statements, not from memory. Rates matter even in a snowball, because they determine how fast each balance shrinks.
Pro tip: Color the target debt’s row yellow. When it hits zero, turn it green and move the yellow to the next row. It’s a small ritual that keeps you motivated.
The formulas, explained in plain words
Assume your first debt is in row 2. Here is what to type and what it actually does.
Monthly interest (column E)
Formula: =B2*(C2/12)
In words: take the balance and multiply it by one-twelfth of the annual rate. A $1,000 balance at 24% APR costs about $20 in interest this month. Card issuers actually calculate interest daily, so treat this as a close estimate.
Payment this month (column F)
For every debt that is not your target, the payment is just the minimum: =MIN(D3,B3+E3). The MIN part stops you from paying more than you owe on the last month.
For the target debt (smallest balance), it gets everything left over: =MIN(B2+E2, TotalBudget - SUM(minimums of all other debts)). In words: pay the lesser of what you owe, or your whole budget minus the minimums on everything else.
New balance (column G)
Formula: =B2+E2-F2
In words: old balance, plus this month’s interest, minus what you paid. That result becomes next month’s starting balance.
Payoff order (column H)
Formula: =RANK(B2,$B$2:$B$6,1)
In words: rank each balance from smallest (1) to largest. The 1 at the end tells the sheet to sort ascending. Adjust the range to fit your number of debts.
The snowball isn’t about the cheapest path; it’s about the path you will actually finish.
Sample filled-in snowball table
Here is a hypothetical example. These numbers are made up for illustration. Assume a total debt budget of $700 per month.
- Store card: $450 balance, 26.99% APR, $25 minimum, payoff order 1
- Medical bill plan: $1,200 balance, 0% APR, $50 minimum, payoff order 2
- Credit card: $3,800 balance, 22.99% APR, $95 minimum, payoff order 3
- Car loan: $9,500 balance, 7.5% APR, $310 minimum, payoff order 4
Minimums on the three non-target debts total $455 ($50 + $95 + $310), so the store card gets $700 minus $455, or $245, in month one.
Month one on the store card: interest is about $10.12 ($450 × 26.99% ÷ 12). Payment is $245. New balance: $450 + $10.12 − $245 = $215.12. In month two, the card is paid off with roughly $220, and the leftover rolls into the medical plan.
That’s the snowball in action: one account gone in two months, and the freed-up $25 minimum joins the pile.
Keeping the sheet honest month after month
A spreadsheet is only useful if it matches reality. Build in a short monthly routine:
- Copy the new balance column into next month’s starting balance (or add a new row block for each month).
- Check statements and replace estimates with actual balances.
- Update the budget cell if your income or expenses changed.
- Mark paid-off debts and recheck which debt is now the target.
- Add windfalls such as tax refunds or side income to that month’s budget cell.
Prefer something visual? Our free debt payoff tracker printables pair nicely with a spreadsheet, and the Debt Burn-Down Calculator will check your payoff date without any formulas at all. Compare its answer to your sheet to catch typos.
Every dollar freed by a paid-off minimum is a dollar that attacks the next balance.
Ways to speed up your snowball
Once the sheet works, use it to test “what if” scenarios. Change the budget cell and watch the payoff date move.
- Lower your interest rate. A 0% balance transfer or a consolidation loan can cut the interest column dramatically. Just model the transfer fee and the promo end date in your sheet. Our step-by-step on how to do a balance transfer covers the details.
- Add small extras. Even $50 a month changes the timeline; the sheet shows how much.
- Try a short challenge. A 30-day no-spend challenge can generate a lump sum to drop into month one.
- Plan for the big picture. Our burn-down plan walks through finding extra cash in your budget. For ideas on tracking your progress, see our debt snowball worksheet guide.
Lowering rates is often the single biggest lever. If you’d like to see what’s available for your situation, request free rate-lowering options using the form on this page. It’s free and there’s no obligation.
Debt snowball spreadsheet FAQ
Do I need Excel, or will Google Sheets work?
Google Sheets works fine and is free. Every formula above (MIN, RANK, SUM and basic arithmetic) works the same in both programs.
Should the snowball include my mortgage?
Most people leave the mortgage out and keep making its regular payment, then tackle it later. If you want to include it, see our guide on paying off your mortgage early first.
What if a debt has a 0% promotional rate?
Enter 0% in the APR column, but add a note with the date the promo ends. After that date, update the APR to the regular rate so the sheet doesn’t understate your interest.
Is the snowball better than the avalanche?
The avalanche usually saves more interest; the snowball often keeps people motivated longer. You can build both in one workbook and compare the total interest and payoff dates. This is general education, not personalized financial advice, so consider speaking with a qualified nonprofit credit counselor or financial professional about your situation.
See free options to lower your interest rate
A partner will review your situation and share free, no-obligation options so you can plug better rates into your snowball.
