Debt Snowball Worksheet: Free Simple Template to Plan Your Payoff

A debt snowball worksheet is useful when you want to organize the plan before automating it. You do not need formulas to get started. You need a complete debt list, a consistent monthly debt budget, and a clear payoff order.

Use the worksheet below on paper, in Notes, or in any spreadsheet app.

Simple debt snowball worksheet

Debt	Current Balance	APR (%)	Minimum Payment	Snowball Order	Monthly Target
Debt 1
Debt 2
Debt 3
Debt 4
Debt 5

Then add three totals beneath it:

• Total debt: sum of all current balances
• Total minimum payments: sum of all required minimums
• Extra monthly payment: the additional amount you plan to put toward debt

Your monthly debt budget is:

Total minimum payments + extra monthly payment

That fixed monthly budget is the cleanest way to compare payoff methods because Snowball and Avalanche are then competing over ordering, not different amounts of money.

How to assign Snowball order

Rank the debts from smallest balance to largest balance.

The smallest balance is Snowball Order 1. The next-smallest balance is 2, and so on.

Continue making the required payment on every debt. Direct the extra portion of your monthly debt budget to the smallest target balance. When that debt is paid off, roll the amount you were paying toward it into the next target.

That account-closure sequence is the core of the Debt Snowball method.

Example worksheet

Suppose your debts look like this:

Debt	Balance	APR	Minimum	Snowball Order
Store Card	$2,500	8.9%	$100	1
Credit Card	$8,000	24.9%	$240	2
Car Loan	$15,000	6.5%	$350	3

If you add $200 per month above the required minimums, your monthly debt budget is:

$100 + $240 + $350 + $200 = $890

The Snowball method keeps that $890 debt budget constant and redirects payments as accounts are eliminated.

These numbers are illustrative only; they are not intended to represent typical balances, rates, or payments.

If you want the exact payoff date, interest total, and month-by-month balances for this example, use the Debt Snowball Calculator.

Worksheet vs. spreadsheet vs. calculator

These tools solve different jobs.

Use a worksheet when you want to organize

A worksheet is best for:

• gathering balances and APRs
• confirming minimum payments
• deciding your extra monthly payment
• writing down the Snowball order
• discussing the plan with a spouse or partner

It is deliberately simple and does not try to calculate an amortization schedule.

Use the workbook when you want to track

The free DebtSnowball.org payoff workbook adds:

• automatic Snowball and Avalanche ordering
• monthly balance tracking
• a progress dashboard
• a reusable file you can update over time

The workbook is designed with conservative spreadsheet features for compatibility across Excel, Apple Numbers, and Google Sheets import.

Use the calculator when you want to forecast

The Debt Snowball Calculator models the payoff month by month and shows:

• projected debt-free date
• total interest
• Snowball payoff order
• Avalanche payoff order
• Snowball vs. Avalanche interest difference
• detailed payoff timelines

That distinction matters: worksheet = organize, workbook = track, calculator = forecast.

Why DebtSnowball.org defaults to Snowball

DebtSnowball.org is built around the smallest-balance-first method, so Snowball is the default experience on this site. Avalanche remains available as the interest-priority benchmark.

When the same monthly debt budget is used, targeting a higher-APR balance earlier can reduce interest relative to leaving that balance outstanding longer. Whether that difference is material depends on your actual balances, APRs, and payment amount.

The Snowball vs. Avalanche comparison shows both schedules side by side so you can make the tradeoff with your own numbers instead of relying on a general claim about which method is better.

What should not automatically go on this worksheet

Do not treat every financial obligation as an ordinary amortizing debt just because there is a balance.

Before entering an account, confirm the balance and repayment terms—especially for:

• debt in collections or settlement negotiations
• federal student loans with program-specific repayment options
• medical bills that may still be disputed or eligible for assistance
• payday loans or other products where fees and renewals may not reduce principal normally
• secured debts where collateral or payoff terms matter

For federal student loans, compare the current repayment options your loans are eligible for before deciding whether to accelerate a specific loan. Federal Student Aid provides a current repayment-plan comparison tool.

The calculator and worksheet are planning tools. They do not replace the actual terms set by your lender, servicer, creditor, or applicable program.

Start with the worksheet, then model the plan

If you are still collecting your numbers, use the table above first. Once you have current balances, APRs, minimum payments, and an extra-payment amount, enter those same numbers into the Debt Snowball Calculator to see the full payoff plan.

If you prefer to keep a file and update it month by month, download the free Debt Snowball payoff workbook.