How does the debt snowball method work?

You pay the minimum on every debt, then throw all your spare cash at the smallest balance first. When it clears, you roll that payment onto the next-smallest, so the amount you attack with grows like a snowball.

Why does the sheet rank by balance instead of interest rate?

Because this is a snowball tracker: it sorts smallest balance first for fast, motivating wins. If you would rather pay highest interest first (the avalanche method), change both the reference and the order flag — use =IF(B6="","",RANK(C6,$C$6:$C$13,0)) so the highest APR in column C gets order 1. The ,0 makes RANK descending; leaving the ,1 would rank the lowest APR first, the reverse of avalanche.

What does "check inputs" mean in the Months to Payoff column?

It means NPER cannot find a payoff at that row's numbers — the minimum payment is at or below the monthly interest, so the balance never falls. Increase the Min Payment or your Extra monthly payment to fix it.

Are the payoff dates exact?

No — they are estimates. The math assumes a steady rate, fixed payments, and the extra applied only to the order-1 debt, so real results shift with rate changes and timing. Treat the dates as a plan, not a promise.

Can I track more than eight debts?

The table is pre-wired for eight in rows 6–13. To add more, right-click row 13, choose Insert, then copy the formulas in columns E, F, and G down into the new rows so the ranking and dates keep working.

Debt Snowball Tracker Template

Last updated June 2026

The snowball method pays off the smallest balance first — and this free single-sheet .xlsx ranks your debts that way for you. List each one with its balance, APR, and minimum payment, add the extra amount you can pay monthly, and the Snowball sheet estimates months to payoff and a payoff date per debt, with a month-by-month payment tracker built in.

debt-payoff-tracker.xlsx · free · no signup

Download free template

Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).

SHA-256: 9ecdfb74a0245bc2bffea3b3bd50dbcae5b2dbbfb9b25ca69cee31c5bbf9f550

E6=IF(B6="","",RANK(B6,$B$6:$B$13,1))

	A	B	C	D	E	F	G
1	Debt	Balance	APR	Min Payment	Snowball Order	Months to Payoff	Payoff Date
2	Store card	$850.00	26.99%	$35.00	1	4	Nov 2026
3	Credit card	$2,400.00	22.99%	$70.00	2	57	Apr 2031
4	Car loan	$9,800.00	6.49%	$285.00	3	39	Oct 2029
5	Student loan	$14,500.00	5.50%	$160.00	4	118	May 2036

Debt rows from the Snowball sheet. Snowball Order ranks by balance — order 1 is the smallest debt, the one you attack first, and its cell turns ledger-green.

What's inside

Sheets

SnowballThe whole tracker on one sheet: your Start month and Extra monthly payment inputs up top, the ranked debt table, and a 24-month payment tracker below it.

Columns

DebtA name for each balance — one row per card, loan, or line of credit.
BalanceThe current amount owed. This is what the snowball ranking sorts on.
APRThe annual interest rate, entered as a percent. Drives the payoff estimate.
Min PaymentThe minimum due each month. Keeps every debt current while you attack one.
Snowball OrderAuto-ranked smallest balance to largest. Order 1 is your first target and turns ledger-green.
Months to PayoffEstimated months to clear each debt with minimum payments, plus the extra applied to order 1.
Payoff DateThe estimated month you finish, counted forward from your Start month.

Formulas that do the work

=IF(B6="","",RANK(B6,$B$6:$B$13,1))

Snowball Order in column E. RANK(...,1) ranks ascending, so the smallest balance gets order 1 — the snowball method's first target. Copied down rows 6–13.

=IF(B6="","",IFERROR(CEILING(NPER(C6/12,-(D6+IF(E6=1,$B$3,0)),B6),1),"check inputs"))

Months to Payoff in column F. NPER finds the number of monthly periods at the monthly rate C6/12 (the APR divided by 12); the order-1 debt also gets your Extra monthly payment from B3. CEILING(...,1) rounds up to a whole month, and IFERROR shows check inputs when the payment never clears the balance.

=IF(OR(F6="",ISTEXT(F6)),"",EDATE($B$2,F6))

Payoff Date in column G. EDATE returns a serial date that many months forward from your Start month in B2; column G uses the custom number format mmm yyyy (Ctrl+1 → Number → Custom) so it reads as Nov 2026. Blank until the row has a valid month count.

How to use it

Set your start month and extra payment
In B2 enter the month you begin, and in B3 enter the extra you can throw at debt each month beyond the minimums. Both feed the payoff math.
List every debt
Replace the four sample rows with your own — Debt name, Balance, APR, and Min Payment. There is room for eight debts in rows 6–13.
Read the snowball order
Column E ranks your debts smallest balance first and highlights order 1 in green. That green row is the debt your extra payment attacks until it is gone.
Check the payoff estimate
Months to Payoff and Payoff Date fill in automatically. If a row shows check inputs, its APR or Min Payment is too low to ever clear the balance — raise the payment.
Log payments each month
Scroll to the Payment tracker at row 16 and type what you actually paid each debt under its column. The Total in column K sums each month so you can watch the snowball grow.

Compatibility

Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.

The NPER, RANK, and EDATE formulas and the conditional-formatting rule that turns order 1 ledger-green all carry into Google Sheets — open it with File → Import → Upload → Replace spreadsheet, and the estimates recalculate the moment the file finishes importing.

Frequently asked questions

How does the debt snowball method work?: You pay the minimum on every debt, then throw all your spare cash at the smallest balance first. When it clears, you roll that payment onto the next-smallest, so the amount you attack with grows like a snowball.
Why does the sheet rank by balance instead of interest rate?: Because this is a snowball tracker: it sorts smallest balance first for fast, motivating wins. If you would rather pay highest interest first (the avalanche method), change both the reference and the order flag — use =IF(B6="","",RANK(C6,$C$6:$C$13,0)) so the highest APR in column C gets order 1. The ,0 makes RANK descending; leaving the ,1 would rank the lowest APR first, the reverse of avalanche.
What does "check inputs" mean in the Months to Payoff column?: It means NPER cannot find a payoff at that row's numbers — the minimum payment is at or below the monthly interest, so the balance never falls. Increase the Min Payment or your Extra monthly payment to fix it.
Are the payoff dates exact?: No — they are estimates. The math assumes a steady rate, fixed payments, and the extra applied only to the order-1 debt, so real results shift with rate changes and timing. Treat the dates as a plan, not a promise.
Can I track more than eight debts?: The table is pre-wired for eight in rows 6–13. To add more, right-click row 13, choose Insert, then copy the formulas in columns E, F, and G down into the new rows so the ranking and dates keep working.

Related guides

More personal finance templates →