Google Debt Snowball Spreadsheet: Build One in Sheets

Yes. You can build a debt snowball spreadsheet in Google Sheets by listing each debt, sorting debts from the smallest balance to the largest, and using formulas to calculate interest, minimum payments, extra payments, and ending balances. The simple template below tracks one month at a time; update balances and the snowball target each month so the extra payment moves to the next debt as balances reach zero.

What a debt snowball spreadsheet does

The debt snowball method directs minimum payments to all debts and puts any extra payment toward the debt with the smallest current balance. When that debt is paid off, its payment amount is added to the payment aimed at the next-smallest balance. The growing payment is sometimes called the snowball. The method prioritizes quick account payoffs, rather than choosing a debt based on its interest rate.

A spreadsheet makes the plan visible: it can show how much goes to each account, estimate the interest added during a month, and record the remaining balance. It is a planning tool, not a promise about the payoff date. Actual interest and minimum payments depend on lender terms, payment timing, fees, and how the lender calculates interest.

Set up the Google Sheets template

Open a blank Google Sheet and put these headings in row 1: Debt, Balance, APR, Minimum, Interest, Minimum paid, Extra paid, Ending balance. Use rows 2 onward for accounts, with one debt per row. Put the extra amount you can allocate each month in J1 and its value in J2. For example, enter Extra budget in J1 and 200 in J2. That value is additional to the minimum payments in column D.

Enter balances and minimum payments as positive amounts. Enter APR as a percentage, such as 12% rather than 12. Format the APR column as a percentage with Format > Number > Percent. If lenders quote different minimum-payment rules, use the actual minimum shown on the latest statement rather than trying to infer it from the balance.

Column A: debt or account name.
Column B: current balance before this month’s payment.
Column C: annual percentage rate (APR), entered as a percentage.
Column D: scheduled minimum payment.
Columns E through H: calculated interest, minimum paid, extra paid, and ending balance.

For easier reading, keep the headings visible while scrolling with View > Freeze > 1 row. You can also format columns B and D through H as currency using Format > Number > Currency. Google Sheets menus can change over time, but these are standard browser menu paths. On Excel, the comparable number-format and freeze-pane controls are on the Home and View tabs.

Calculate interest and payments

This example uses a simple monthly estimate: balance multiplied by one plus APR divided by 12. With balances in B2:B20, APRs in C2:C20, and interest estimates in E2:E20, enter this in E2 and fill it down:

With the current balance in B2 and annual APR in C2, calculate one month of estimated interest with =B2*C2/12. For a $500 balance at 12% APR, the estimated interest is $5.

This is a rough monthly estimate, not necessarily the lender’s exact interest calculation. Many accounts accrue interest daily, and the result can vary with the billing-cycle length, transaction dates, and payment dates. For a closer forecast, check the lender’s method and use the statement’s actual interest charge when reconciling the sheet.

With estimated interest in E2 and the starting balance in B2, calculate the amount before payments in F2 with =B2+E2. For the $500 example, F2 is $505. Add a heading called Amount before payment in F1, shifting the later headings one column right if needed; the formulas below assume that layout.

To keep the layout simple and consistent, use these final columns: A Debt, B Balance, C APR, D Minimum, E Interest, F Amount before payment, G Minimum paid, H Extra paid, and I Ending balance. Put the extra budget in J2. With the amount before payment in F2 and scheduled minimum in D2, calculate the minimum actually applied in G2 with =MIN(F2,D2). For the example, the result is $35 if the scheduled minimum is $35.

Allocate the snowball payment

Sort the debt rows by current balance from smallest to largest before allocating the extra amount. In Google Sheets, select the debt table and use Data > Sort range; if the selection includes headings, indicate that the range has a header row, then sort by Balance from A to Z. Check the result after each update, because the order can change as balances fall. Do not sort only one column: that would detach account names from their balances.

With the first debt’s remaining amount after its minimum in F2-G2 and the extra budget in J2, calculate its extra payment in H2 with =MIN(MAX(0,F2-G2),$J$2). This limits the extra payment to both the available budget and the balance left after the minimum. With the example debt at $505 before payment, $35 minimum, and $200 extra budget, H2 is $200.

With debts sorted from smallest balance upward, calculate the next debt’s extra payment in H3 with =MIN(MAX(0,F3-G3),MAX(0,$J$2-SUM($H$2:H2))). Fill this formula down the remaining rows. It gives the next debt only the extra budget left after prior rows have received their extra payments. Thus, if the first debt has only $100 left after its minimum, the next debt can receive the remaining $100 of the $200 extra budget.

With amount before payment in F2, minimum paid in G2, and extra paid in H2, calculate the ending balance in I2 with =MAX(0,F2-G2-H2) and fill down. In the example, the first account ends at $270: $505 accrued balance minus $35 minimum and $200 extra. The other debts receive their minimums, plus any extra budget remaining after earlier accounts are handled.

Example with several debts

Suppose a person tracks three illustrative accounts: a $500 balance at 12% APR with a $35 minimum, a $1,200 balance at 18% APR with a $50 minimum, and a $3,000 balance at 9% APR with a $90 minimum. The extra budget is $200. These figures are examples only, not recommended payments.

The estimated monthly interest is $5, $18, and $22.50 respectively, using APR divided by 12. After estimated interest, the balances are $505, $1,218, and $3,022.50. The minimums total $175, so the planned outflow is $375 for this simple scenario: $175 in minimums plus $200 extra. The smallest debt receives its $35 minimum and the full $200 extra, leaving an estimated $270. The other accounts receive their scheduled minimums, leaving estimated balances of $1,168 and $2,932.50.

After entering updated statement balances for the next month, sort the rows again. Continue directing the extra amount to the smallest unpaid balance. When an account is paid off, its former minimum can be added to the recurring extra budget, if the overall monthly amount available for debt payments stays the same. Confirm the next account’s current minimum and adjust the budget and inputs to reflect real statements.

What the sheet does not model automatically

This template is a monthly tracker, not a full amortization engine. It estimates interest at a monthly rate and uses minimum amounts that you enter. It does not know when a payment posts, whether a promotional rate ends, how a lender changes its minimum, or whether new purchases or fees have been added. It also does not automatically move a former minimum into J2; the user updates the extra budget and current debt order after checking statements.

In the example formulas, if a debt’s balance before payment is smaller than its scheduled minimum, the minimum paid is capped at the balance. Any unused portion of that minimum is not redirected automatically to another account during the same month. Likewise, the formula spreads the extra budget across rows in order, but it cannot account for lender-specific payment restrictions. For accurate cash-flow planning, compare the calculated amounts with each account’s required payment and statement.

To avoid circular references, enter each new month’s actual starting balances as values in column B. Do not make B refer to the prior month’s ending balance while also altering the same cells to record new statements. A separate monthly tab or a dated history table can preserve old estimates, while column B on the active tab reflects the latest verified balances.

Snowball versus avalanche

The snowball orders debts by balance; the debt avalanche directs extra money to the highest interest rate first. If rates and other details were otherwise identical, paying a higher-rate balance sooner generally reduces interest more effectively. But the strategies can feel different: the snowball may produce an early account payoff, while the avalanche focuses on the rate order. The spreadsheet can support either approach by changing the sort rule; for an avalanche, sort by APR from highest to lowest instead of by balance.

Neither ordering makes the minimum payment optional. Keep required payments current across accounts, and use the method as a way to decide where the additional amount goes. A practical comparison is to create a duplicate tab, use the same starting balances, APRs, minimums, and extra budget in both, then compare the projected results. Because this template uses simplified monthly interest, treat any difference as an estimate and verify real costs against statements or lender information.

Common mistakes and useful checks

Mixing APR formats: Enter 18% or 0.18, not 18, if the cell is not percentage-formatted. Otherwise the interest estimate can be dramatically too high.
Sorting one column alone: Always sort the complete table range so balances stay matched to their debts and rates.
Forgetting to update the order: Re-sort after balances change, particularly when two accounts are close in size.
Counting the extra twice: J2 is additional to the sum of minimum payments. If your chosen monthly budget is a total that already includes minimums, calculate the extra as total budget minus minimums first.
Ignoring fees or new charges: Add them to the balance or use the current statement balance so the tracker does not understate what is owed.
Treating estimates as lender figures: Replace estimates with posted amounts and check due dates and required payments directly with each lender.

You can add a paid-off status column or apply conditional formatting to ending balances equal to zero, but the core tracker does not require either feature. In Google Sheets, conditional formatting is under Format > Conditional formatting. Keep the sheet private if it contains account names or financial information, and avoid recording full account numbers, passwords, or security answers.

Frequently Asked Questions

Is there a free Google Sheets debt snowball template?
Google Sheets users may find templates through Google’s template gallery or third-party sites, but template availability and terms can change. You can also create the basic tracker above in a blank sheet. Review a copied template’s formulas and sharing settings before entering personal financial information.

Can Google Sheets calculate the payoff date?
A month-by-month forecast can estimate a payoff date if it models payments, interest, and changing minimums consistently. The simple tracker here does not calculate a reliable date by itself; it records one month at a time. Actual payoff timing can differ because of daily interest, fees, payment timing, or changing account terms.

Should I use the snowball or avalanche method?
The snowball targets the smallest balance first, while the avalanche targets the highest rate first. The choice depends on the approach you want to follow and the details of your accounts. Compare both using the same balances, rates, minimums, and monthly budget, and verify estimates with lender information.

Does the snowball formula include interest?
Yes, the sample adds a simple monthly interest estimate before subtracting payments. It uses APR divided by 12, so it may not match a lender’s daily-interest calculation or statement exactly. Use actual posted interest to reconcile the tracker.

Can I use this spreadsheet in Excel?
Yes. The formulas shown use common spreadsheet functions and are also valid in current Excel. Menu names differ: the sorting and number-format tools are on Excel’s ribbon rather than Google Sheets’ browser menus. The article’s setup instructions describe Google Sheets.

Costs and financial-information safety

Google Sheets is available in a web browser through a Google account; account and Workspace features, storage, or organizational policies can vary. Do not assume a third-party template is free or safe without checking its source and terms. A spreadsheet can help organize information, but it is not financial, tax, investment, or legal advice. Verify interest, minimums, fees, and payment instructions with the lender, and consult a qualified professional if you need advice about your circumstances.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.