Free Beginner friendly Google Sheets Excel

Debt Snowball Tracker

List all your debts, enter balances and interest rates, and get a complete payoff schedule automatically — month by month, debt by debt. Watch the snowball build in real time.

2,400+ downloads
4.9 / 5 (312 ratings)
Updated June 2026
Debt Snowball Tracker — Finlybox.xlsx
📋 Debts
📅 Schedule
📊 Progress
A B C D E F
1 🏔️ DEBT SNOWBALL TRACKER — Finlybox.com
2 Priority Debt name Balance Rate Min. pay Payoff date
3 1 Credit card A $2,400 24.9% $50 =EDATE(...)
4 2 Credit card B $5,100 19.4% $100 =EDATE(...)
5 3 Car loan $11,200 6.9% $320 =EDATE(...)
6 4 Student loan $28,500 5.5% $280 =EDATE(...)
7
8 Total debt $47,200 $750 Mar 2030
9 💸 Extra monthly payment $200 ⬆️ Change this to see impact

What's included

Debt entry sheet
List up to 20 debts with balance, rate, and minimum payment. Auto-sorts by snowball order.
Month-by-month schedule
Full payoff calendar showing every payment, interest charge, and remaining balance — automatically calculated.
Progress dashboard
Visual chart showing total debt decreasing over time. Update monthly to track your actual progress.
Extra payment simulator
Change one cell to see how an extra $100, $200, or $500/month accelerates your payoff date.
Snowball vs. avalanche comparison
See the interest savings from switching to the avalanche method — decide which strategy fits you.
Print-ready layout
Clean print view for your debt schedule. Post it somewhere visible to stay motivated.

How to use this template

  1. 1
    Copy to your Google Drive
    Click "Copy to Google Sheets" above. This creates your own private copy — your data stays in your Drive, never shared with us.
  2. 2
    Enter your debts on the "Debts" tab
    Type each debt's name, current balance, interest rate, and minimum monthly payment. The template auto-sorts them in snowball order (smallest balance first) — no formulas to write.
  3. 3
    Set your extra monthly payment
    Enter how much extra you can put toward debt each month in the yellow highlighted cell. Even $50 extra makes a meaningful difference — the schedule updates instantly.
  4. 4
    Check your payoff schedule
    Go to the "Schedule" tab to see every single payment, month by month. The "Progress" tab shows a chart of your total debt declining over time.
  5. 5
    Update monthly as you make payments
    Each month, check off completed payments and update balances if they differ from the projection. The schedule automatically recalculates.

Template contents

Sheet / featureWhat it doesIncluded
Debts entry tabEnter up to 20 debts with all details
Snowball payoff scheduleMonth-by-month breakdown through final payoff
Avalanche comparisonSide-by-side interest savings vs. snowball
Progress chartVisual debt reduction over time
Extra payment simulatorChange one cell to model extra payments
Print layoutClean single-page print view of your schedule
Instructions tabStep-by-step setup guide inside the sheet

What is the debt snowball method?

The debt snowball method — popularized by Dave Ramsey — involves paying your smallest balance debt first, regardless of interest rate. Once the smallest debt is paid off, you roll its minimum payment into the next smallest debt, creating a growing "snowball" of payment momentum.

It's not always the mathematically optimal strategy (the avalanche method, which targets highest interest first, saves more money). But for most people, the psychological wins of eliminating debts entirely keep them motivated and on track longer. This template includes both strategies so you can choose what's right for you.

Use our Debt Payoff Priority Calculator to compare snowball vs. avalanche with your specific debts before deciding which method to track.

Pairs with this calculator
Debt Payoff Priority Calculator
Run the numbers first — compare snowball vs. avalanche, see total interest paid, and find your payoff date before filling in the tracker.
Try the calculator →
Get this template free
No email required. Copy directly to your Google Drive or download for Excel.
Copy to Google Sheets Download for Excel (.xlsx)
2,400 downloads No signup
4.9
out of 5
Based on 312 ratings
5★
274
4★
28
3★
7
2★
3
1★
0