Debt Snowball Spreadsheet
Free Template — Download, Print, or Track Online
A debt snowball spreadsheet has one job: keep every debt, its order, and its payoff date in one place you actually look at. Below is the template with the exact columns you need, a free CSV download for Excel or Google Sheets, and a printable version if you prefer paper on the fridge.
No email required. The CSV opens in Excel, Google Sheets, Numbers, and LibreOffice.
The Printable Worksheet
Fill in one row per debt, smallest balance at the top. Leave the payoff columns blank until each debt clears.
| # | Debt name | Balance | APR | Minimum | Target month | Paid off |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| Total minimum payments | ||||||
| Extra payment per month | ||||||
| Total monthly toward debt (never lower this) | ||||||
How to Fill In Each Column
Debt name. Use whatever you actually call it — “Chase card,” “Dr. Patel bill.” Vague labels make the sheet easy to ignore.
Balance. Take it from your most recent statement, not your memory. Use the statement balance, including any interest already assessed.
APR. The snowball does not sort by APR, but you still need it to project interest and to spot a rate high enough to justify switching to the avalanche method.
Minimum payment. Use the required minimum from the statement. Note that credit card minimums decline as the balance drops — the minimum payment calculator shows why that matters so much.
Snowball order. Sort strictly by balance, smallest first, regardless of rate. Number them 1 through N and do not renumber later unless a balance changes materially.
Target and actual payoff month. Get target months from the debt snowball calculator, then fill in the actual month as each debt clears. The gap between the two columns is your early-warning system.
The One Formula People Get Wrong
Within each month, interest is added before the payment is subtracted. Reverse those two steps and your spreadsheet will show a payoff date months earlier than reality.
The second mistake is the rollover. When debt 1 clears, debt 2 does not just get the extra payment — it gets the extra payment plus debt 1's entire minimum. Your total monthly outflow stays flat for the whole plan. That is the mechanism that makes the snowball accelerate, and it is the part hand-built sheets usually miss.
If you would rather not maintain the formulas at all, the debt snowball calculator handles both automatically and gives you month-by-month payoff dates you can copy into the tracking columns. Deciding between methods first? See snowball vs avalanche.
Debt Snowball Spreadsheet FAQ
What columns does a debt snowball spreadsheet need?▼
Seven columns cover everything: debt name, current balance, APR, minimum payment, snowball order, target payoff month, and actual payoff month. Below the debt rows, add three summary lines — total minimums, your extra payment, and total monthly toward debt. That last number is the one that must never go down. Anything beyond these columns tends to add maintenance work without improving the plan.
Is a spreadsheet or a calculator better for the debt snowball?▼
They do different jobs. A calculator builds the schedule instantly and gets the rollover math right, which is where hand-built spreadsheets usually break. A spreadsheet is better for tracking what actually happened each month — the payment you really made, the balance after a surprise charge, the month a debt truly cleared. Build the plan in the calculator, then track it in the spreadsheet.
Does this template work in Excel and Google Sheets?▼
Yes. The download is a plain CSV file, which opens natively in Microsoft Excel, Google Sheets, Apple Numbers, and LibreOffice Calc. In Google Sheets, use File then Import and select the downloaded file. No macros, no add-ons, and nothing to enable.
Why does my spreadsheet math not match the calculator?▼
The most common cause is compounding. Interest accrues on the balance remaining at the time of the payment, so the order of operations within each month matters: add the month's interest first, then subtract the payment. The second most common cause is forgetting to roll the full payment — including the retired debt's minimum — into the next target when a debt clears.
How often should I update the spreadsheet?▼
Once a month, right after you make your payments, using the balances from your statements. More often than that turns into anxious checking without new information. Less often and small errors — a forgotten fee, an interest charge you did not expect — compound quietly until the plan no longer matches reality.