A debt snowball spreadsheet for Google Sheets lists your debts, orders them smallest balance first, rolls each paid-off payment into the next debt, and shows the month you will be debt-free. Here is how the snowball and avalanche methods compare, how the spreadsheet calculates it, and a template that does both.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Snowball: pay the smallest balance first. You clear whole debts sooner, which keeps you motivated.
Avalanche: pay the highest interest rate first. You pay less interest in total.
In both, you pay the minimum on every debt and put all extra money on one target. When it is paid off, its payment rolls to the next one.
Debt name, balance, interest rate (APR) and minimum payment
Method (Snowball or Avalanche) and extra payment per month
First payment month
Output: payoff order, months to pay off each debt, debt-free date, total interest
Credit card: $2,400 at 24.99% APR, $75 minimum
Car loan: $9,800 at 6.9%, $285 minimum
Student loan: $14,500 at 5.5%, $160 minimum
With Snowball and $200 extra a month, the template orders them credit card, car loan, student loan, and shows the debt-free date and total interest. Switch the method to Avalanche and both numbers update, so you can compare in one click.
If a minimum payment does not even cover the monthly interest, the balance grows. The template marks that minimum in red, and shows "Never" if a debt would take more than 30 years.
The debt payoff planner is part of the full bundle: the Irregular Income Budget Bundle adds the "pay yourself a salary" system on top of the monthly budget:
Steady salary: pick "lowest month" (safest), "average month" or a custom amount. It is based on finished months only, so a half-finished month never lowers it.
Buffer and runway: your buffer balance, a buffer goal in months of essential bills, and how many months you could cover with no new income.
Tax set-aside tracker: park a share of every payment (25% by default) and log your estimated tax payments.
Pending invoices: unpaid invoices show on the Dashboard but do not count as income until they arrive.
Bills & subscriptions: monthly, quarterly and yearly bills turned into their true monthly cost, with the next due date.
Sinking funds: how much to save per month to hit each goal on time.
Debt payoff: Snowball or Avalanche, extra payments, your debt-free date and total interest.
13 tabs, blank + demo files, Google Sheets and Excel, one payment of $9.
Get the Irregular Income Budget Bundle for $9 →
The free template includes a Debt category in the monthly budget but not the payoff planner. Get the free budget template or see Sinking Funds Spreadsheet.
Free template: a complete monthly budget. Best if your paycheck is the same every month. Get it free.
Irregular Income Budget Bundle ($9): everything in the free template plus steady salary, buffer, taxes, pending invoices, bills, sinking funds and debt payoff. Best for freelancers and anyone with changing income. See the full bundle.
Your rows copy straight across, so you can start free and upgrade later without retyping anything.
Avalanche costs less interest; Snowball gives faster wins. The best one is the one you will stick with. A spreadsheet lets you compare both.
It applies minimums to all debts and extra money to the target debt, month by month, rolling freed payments to the next debt.
The Irregular Income Budget Bundle's planner handles up to 10 debts.
Yes, and in Excel.
Get the Irregular Income Budget Bundle ($9) →
Download the free budget template (Google Sheets + Excel) →
About this page: written by Abdallah Elsied, who makes the Free Monthly Budget Template (free) and the Irregular Income Budget Bundle ($9), both linked on this page. Last updated October 2026. This is general budgeting information, not financial, tax or legal advice.