Free debt snowball spreadsheet for Google Sheets

If you like keeping your money in a spreadsheet, this free Google Sheets template runs the debt snowball for you. Type in your debts and the extra money you can put toward them, and it works out your payoff order, the month each debt is paid off, your debt-free date, the total interest, and a month-by-month schedule.

Google asks you to sign in, then saves an editable copy to your own Drive. Your copy is private to you; we never see it. Want a look first? Open the read-only template.

How to use it

1. Make your copy with the button above. The template is filled in with an example.
2. Replace the example debts with yours: name, balance, APR and minimum payment, one debt per row, up to 10 debts. Leave unused rows blank.
3. Enter the extra money you can pay each month, on top of all your minimums.
4. Set the first month of your plan. Everything else updates by itself.

What it works out

• Payoff order: smallest balance first, with ties going to the higher interest rate, exactly like the snowball method.
• Your monthly budget: every minimum plus your extra. It stays the same each month, so when a debt is paid off, its payment rolls onto the next one.
• Payoff month for each debt, the month you're debt-free, and the total interest you'll pay.
• A month-by-month schedule showing what's left on every debt, for up to 30 years.

Same math as the calculator

The spreadsheet uses the same rules as our calculator, which are all written down on the how the math works page. Interest is rounded to the cent each month, so over a long plan the total interest can differ from the calculator by a few cents. The payoff order and dates match.

Rather not use a spreadsheet?

The calculator does the same thing with no setup, compares the snowball with the avalanche, and lets you print or email your plan. Build your plan in about a minute. Prefer paper? Get the free printable worksheet.