Free Debt Snowball Spreadsheet for Google Sheets: Setup

Yes. You can make a free debt snowball spreadsheet in Google Sheets by listing each debt, its current balance, interest rate, and minimum payment, then directing any money above the minimums to the smallest balance. The setup below uses ordinary Sheets formulas to rank debts, total your minimums, and estimate balances after planned payments; update it each month using current lender information.

What a debt snowball spreadsheet does

The debt snowball is a repayment approach in which you pay at least the required minimum on each debt and put available extra money toward the debt with the smallest balance. After that debt is paid off, you redirect the amount you had been paying on it toward the next-smallest balance. The growing payment can make progress visible, which is one reason people find the method motivating.

A spreadsheet is a tracking and planning tool, not a lender statement or a guarantee of when a debt will be paid. Balances change with interest, fees, payment timing, and new charges. Your sheet is most useful when you enter updated figures regularly and compare them with account statements.

Set up the free Google Sheets template

In a browser, open Google Sheets and create a blank spreadsheet. In row 1, add these headings: A Debt, B Current balance, C APR, D Minimum payment, E Snowball rank, F Planned payment, G Balance after planned payment, and H Approximate monthly interest. Use rows 2 through 20 for debts; fewer debts are fine, and you can extend the formulas and ranges if you need more rows.

Enter balances and minimum payments as numbers, and enter APRs as percentages—for example, type 24% rather than 24. Keep the debt names in column A. Column F is an amount you choose for the month, while the formulas in G and H provide estimates. For an at-a-glance order, rank 1 should be the smallest balance.

With debt names in A2:A20 and balances in B2:B20, enter this in E2 and fill it down through E20 to rank nonblank debts from smallest balance upward, breaking ties by their order in the sheet: =IF(A2="","",COUNTIFS($B$2:$B$20,"<"&B2,$A$2:$A$20,"<>")+COUNTIFS($B$2:B2,B2,$A$2:A2,"<>")). For balances of $600, $1,800, and $4,200 in rows 2–4, the results are 1, 2, and 3. If two debts have the same balance, the earlier row gets the earlier rank.

Add a monthly budget and calculate the extra

Put a label such as Total debt budget in J2 and enter the total amount you plan to pay toward these debts during the month in K2. Put Minimums total in J3 and Extra above minimums in J4. These totals help you see how much of the monthly budget is already committed before assigning extra to the snowball target.

With minimum payments in D2:D20, enter this in K3 to total the listed minimums: =SUM(D2:D20). If the minimums are $30, $55, and $120, the result is $205. With the total monthly debt budget in K2 and the minimums total in K3, enter this in K4: =MAX(0,K2-K3). If K2 is $300 and K3 is $205, the extra is $95. If your budget is below the total minimums, the formula displays zero extra; it does not resolve a shortfall, so check your obligations and contact lenders or a qualified professional if you need help.

With current balances in B2:B20 and the payments you plan to enter in F2:F20, put this in G2 and fill it down: =MAX(0,B2-F2). If B2 is $600 and F2 is $125, G2 returns $475 before any new interest, fees, or other account activity. With balances in B2:B20 and APR percentages in C2:C20, put this in H2 and fill down for a rough one-month interest illustration: =B2*C2/12. For a $600 balance at 24% APR, it returns $12. This simple estimate assumes a constant balance and does not reproduce a lender’s daily-balance calculation.

Work through a concrete snowball example

Suppose the sheet contains a card with a $600 balance, 24% APR, and a $30 minimum; another card with a $1,800 balance, 18% APR, and a $55 minimum; and a loan with a $4,200 balance, 9% APR, and a $120 minimum. The minimums add to $205. If the monthly debt budget is $300, there is $95 above those minimums, so the smallest debt receives its $30 minimum plus the $95 extra.

Smallest balance: plan a $125 payment ($30 minimum plus $95 extra).
Second balance: plan a $55 payment, its minimum.
Largest balance: plan a $120 payment, its minimum.

The planned payments total $300. The before-interest estimates in column G are $475, $1,745, and $4,080, respectively. Column H would show approximate one-month interest of $12, $27, and $31.50 using the simplified formula. These figures are illustrations, not exact statement projections: interest may accrue daily, and payment dates, fees, and account terms affect the actual balance. When the first debt is paid off, update the balances and minimums, then direct the freed payment and any remaining extra to the new smallest balance.

Update payments without double-counting

For a simple monthly tracker, treat column B as the latest balance from each lender and column F as the payment you plan for the current month. After the payment posts, use the new account balance as the next month’s column B value. Do not keep subtracting old planned payments from the same starting balance each month: that would count payments more than once. You can duplicate a monthly tab if you want a history, but label each tab with its month and avoid treating an old estimate as a current balance.

Keep payment dates and due dates in extra columns if they help you avoid missed payments. A planned payment in a spreadsheet does not submit money to a lender. Schedule or make payments through the lender’s approved payment method, and confirm that each payment is credited as intended. If a lender’s required minimum changes, update column D before calculating the next month’s extra.

Snowball versus avalanche and other comparisons

The snowball orders debts by balance, not by interest rate. The debt avalanche instead directs extra money to the debt with the highest interest rate while minimums are paid on the others. Depending on rates, balances, fees, and payment behavior, the avalanche can reduce interest costs compared with a snowball plan, while the snowball may produce an earlier account payoff. Neither method can be declared best for every person from a spreadsheet alone.

You can compare the two approaches in the same sheet by adding a separate priority column: rank balances from smallest to largest for the snowball, and rank APRs from highest to lowest for the avalanche. Keep the minimum payments and overall budget the same when comparing plans. A realistic payoff estimate requires more than the snapshot formulas above: interest timing, payment dates, changing minimums, and any new charges matter. Check actual account terms and consider qualified, individual guidance if you need help choosing.

Common spreadsheet problems and checks

APR entered as a whole number: Enter 24% or 0.24, not 24, or the interest estimate will be far too large.
Blank rows included in the debt list: Leave the debt name blank for unused rows. The rank formula suppresses ranks for those rows.
Minimums exceed the budget: The extra formula returns zero, but the budget still does not cover all minimums. Do not assume the sheet has solved that problem.
Balance does not match the estimate: Interest, fees, payment posting, or new spending can explain the difference. Use the lender’s current balance rather than forcing the sheet to match a rough calculation.
Payment assigned to the wrong debt: Check the rank and confirm that the extra is going to the smallest eligible balance. If balances tie, use the tie order that makes sense to you and keep it consistent.

Google Sheets recalculates formulas when their inputs change, but it cannot verify that the numbers you entered are accurate. Review formulas after inserting or deleting rows, especially if you extend beyond row 20, and check that totals include every debt. You can use Format > Conditional formatting to highlight rank 1 or a zero balance; that changes the display, not the calculation.

Cost, privacy, and template safety

A basic tracker can be created in Google Sheets without paying for a template. Some third-party sites offer downloadable or copyable templates, but check whether they charge, request personal information, or ask you to authorize access to a Google account. A debt tracker usually does not need your bank password, account login, or Social Security number. Avoid entering sensitive account credentials in spreadsheet cells.

For a private sheet, review its sharing settings and avoid setting access to anyone with the link unless you deliberately want link-based access. If you copy a template, inspect its formulas, add-ons, and requested permissions before using it. A plain spreadsheet with balances, rates, and minimums is enough for the basic method; connecting financial accounts is not required.

Frequently Asked Questions

Is there a free debt snowball spreadsheet for Google Sheets?
Yes. You can build one in a blank Google Sheet using the columns and formulas above. A basic tracker does not require a paid template or an add-on.

Does Google Sheets have a built-in debt snowball template?
Google Sheets includes templates and lets users copy templates, but availability can vary. You can create the tracker yourself in a blank sheet, or review any third-party template’s formulas, costs, and access requests before copying it.

Should the smallest debt or highest-interest debt come first?
The snowball method targets the smallest balance; the avalanche method targets the highest interest rate. The approaches prioritize different things. Compare the actual rates and terms, and choose a plan you can follow consistently.

Does the balance-after-payment formula include interest?
No. =MAX(0,B2-F2) subtracts the planned payment from the current balance and floors the estimate at zero. It does not add interest or fees. The separate APR calculation is only a rough monthly illustration, not an exact lender calculation.

Can I use this sheet for Excel too?
The basic layout and these common formulas also work in current Excel versions, although menus and sharing features differ. This setup is written for Google Sheets in a web browser; Google Sheets menu paths such as Format > Conditional formatting are not Excel ribbon paths.

When a spreadsheet is not enough

A spreadsheet can organize a plan, but it cannot change loan terms, make payments, or determine which approach is suitable for your circumstances. Verify balances, APRs, minimums, fees, and payment dates with each lender. If you are behind, cannot meet required payments, or are unsure how a contract works, seek help from a qualified financial professional or a reputable nonprofit credit counseling organization. This example is educational, not financial, tax, investment, or legal advice.

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.