Debt Snowball Spreadsheet in Google Sheets: How to Make One

Yes—you can make a debt snowball spreadsheet in Google Sheets by listing each debt, sorting by balance from smallest to largest, and directing extra money to the smallest balance while paying minimums on the rest. Google Sheets is the spreadsheet app you need; Google Docs is for text documents, though you can link to a Sheet from a Doc.

Google Docs or Google Sheets?

The phrase debt snowball spreadsheet Google Docs often means a spreadsheet people can open or share through Google Drive. The actual spreadsheet belongs in Google Sheets, Google’s spreadsheet application. A Google Doc can explain your payoff plan, but it is not designed to calculate balances in rows and columns. You can put a link to your Sheet in a Doc if you want a written budget and tracker together.

Google Sheets runs in a web browser and saves changes to Google Drive when you are signed in. You can start with a blank spreadsheet, build a tracker yourself, or copy a template you trust and check its formulas. A template is not automatically correct simply because it is shared online: confirm that balances, rates, minimum payments, and formula references match your accounts before relying on its projections.

How the debt snowball method works

The snowball method orders debts by current balance, from smallest to largest, without using interest rate to decide the order. You continue paying at least the required minimum on every debt. Then you put the extra amount you have chosen for debt repayment toward the smallest balance. When that debt is paid off, you add the payment you had been making on it to the amount going toward the next debt.

For example, suppose you owe $600 on a credit card, $1,800 on another card, and $4,000 on a personal loan. The snowball order is $600, $1,800, then $4,000. If you have $100 extra beyond the minimums, that extra goes to the $600 balance. Once it is cleared, its former minimum payment and the $100 can be redirected to the $1,800 balance, while minimums continue on the other accounts.

This approach can make progress visible because the smallest balance may disappear sooner. It does not necessarily minimize interest: if a larger debt has a much higher rate, paying it first may cost less overall. A spreadsheet helps you see the balances and payment choices; it cannot make the trade-off disappear.

Set up the spreadsheet

Create a new Google Sheet and give it a clear name, such as Debt Snowball Tracker. In the first row, add headings for the information you need to review each month. A practical starting layout is:

A: Debt: A short label, such as Card A or Auto loan.
B: Current balance: The latest balance shown by the lender.
C: APR: The annual percentage rate, entered as a percentage.
D: Minimum payment: The required payment for the current billing period.
E: Snowball order: A number based on current balance, with 1 for the smallest.
F: Extra payment: Extra money assigned to that debt for this period.
G: Planned payment: Minimum plus assigned extra, limited to the amount estimated to clear the balance.
H: Estimated monthly interest: A simplified estimate based on the listed balance and APR.
I: Estimated ending balance: The balance after the estimated interest and planned payment.

Enter one debt per row, beginning in row 2. Sort the debts by balance when setting the snowball order, but do not assume that the order will stay correct forever: update it when balances change, and move the extra payment to the new smallest unpaid balance if that is your chosen method. You can freeze the header with View > Freeze > 1 row so the column names remain visible while you scroll.

Add formulas for a monthly estimate

These formulas make a simple one-month estimate, not a lender’s official payoff calculation. They assume the APR is a nominal annual rate divided evenly across 12 months, and they do not account for daily interest, fees, promotional rates, payment timing, or changing minimums. Enter APR values as percentages, such as 24%, rather than 24.

With the current balance in B2 and the annual rate in C2, enter this in H2 to estimate one month of interest:

=B2*C2/12

With the minimum payment in D2 and the extra assigned to this debt in F2, enter this in G2 to estimate a payment capped at the balance plus estimated interest:

=MIN(B2+H2,D2+F2)

With the balance in B2, interest estimate in H2, and planned payment in G2, enter this in I2 to prevent the estimated ending balance from displaying below zero:

=MAX(0,B2+H2-G2)

Copy the formulas down each debt’s row using the fill handle. The formulas use ordinary Google Sheets functions and syntax. If your spreadsheet locale uses semicolons as formula separators, Sheets may display or require separators that differ from the comma convention used in some locales; the formulas above do not require argument separators.

To calculate an overall total, with planned payments in G2:G4 for three debts, enter this in a summary cell:

=SUM(G2:G4)

That result is the total estimated payment across those rows for the period. Expand the range if you have more debts. Make sure the extra-payment entries in column F add up to the extra amount you actually intend to allocate; the sheet will not know your budget unless you enter that information.

Worked example: assigning the extra payment

Imagine two debts with a $600 balance at 24% APR and a $1,800 balance at 12% APR. Their minimum payments are $40 and $60, respectively, and you have $100 extra for the month. In the sheet, assign order 1 to the $600 debt and put the full $100 extra in its F cell. Put zero extra in the other debt’s row. The snowball method still pays the second debt’s minimum.

For the first debt, the simplified monthly interest estimate is $600 × 24% ÷ 12, or $12. Its planned payment is $40 + $100, or $140, and the estimated ending balance is $600 + $12 − $140, or $472. For the second debt, interest is $1,800 × 12% ÷ 12, or $18; the planned payment is $60, and the estimated ending balance is $1,758. Total planned payments are $200, and the two estimated ending balances add to $2,230.

These figures illustrate the spreadsheet arithmetic, not the exact amounts a lender will post. Actual interest may be calculated daily, and a payment may post on a different date than assumed. Compare the estimate with the next statement, then use the lender’s updated balance as the starting point for the next month.

Update it each month

A useful tracker is one you can maintain without turning every payment into a bookkeeping project. At the start of a new cycle, check each account’s latest balance, APR, and minimum due. Enter the amount you plan to pay, put the extra amount on the current snowball target, and review the estimated ending balances. After payments post, replace the old balance with the lender’s reported balance rather than treating the estimate as a statement.

When a debt is paid off, set its balance to zero and redirect its former payment toward the next target. If the last payment is smaller than the usual planned payment, the MIN formula estimates a capped payment, but confirm the actual payoff amount with the lender because interest or fees can affect it. Keep a dated copy or add a separate month column if you want to compare progress over time; overwriting balances alone does not preserve history.

Snowball versus avalanche in a spreadsheet

The avalanche method generally directs extra payments to the debt with the highest interest rate, while continuing minimums on all debts. The snowball directs extra payments to the smallest balance. You can compare the approaches by keeping the same debt list and monthly extra budget, then changing the target order. The tracker’s monthly estimate can show how balances respond under the assumptions entered, but a simple one-month table does not produce a reliable full payoff date or total-interest comparison by itself.

People sometimes say the snowball is always better because it creates motivation, or that the avalanche is always better because it saves interest. Neither statement fits every person’s priorities. A smaller balance can be satisfying to clear, while a high-rate balance may make interest a more pressing concern. Consider the actual rates, fees, required payments, and your ability to follow the plan. For a complicated situation, ask a qualified financial professional; this spreadsheet is an organizational tool, not financial advice.

Common spreadsheet mistakes

Entering APR as a whole number: If you type 24 instead of 24%, the interest estimate will be far too large. Format the APR cells as percentages and enter the rate accordingly.
Paying less than a required minimum: The sheet only calculates what you enter. Check each lender’s due amount and due date independently.
Putting extra money on several debts by accident: Review column F so the extra-payment budget is assigned as intended, usually to one snowball target at a time.
Leaving a paid-off debt in the target order: Update balances and the order after payoff so the extra payment moves to the next unpaid debt.
Treating estimated interest as exact: The monthly-rate shortcut is an approximation. Statements and lender payoff quotes are the source for the actual amount owed.
Sorting only one column: If you sort balances, sort the full debt table so each balance stays paired with its creditor, rate, and minimum payment.

Sharing, privacy, and cost

Google Sheets can be used in a browser with a Google account, and creating a personal tracker does not require buying a spreadsheet template. Google Workspace plans and account features can vary, but you do not need a paid template to enter balances and use the basic formulas here. A shared file can be convenient for household budgeting, yet debt balances and account details are sensitive information.

Use the Share control to check who can access the file, and avoid setting a link to broad public access for convenience. Do not put full account numbers, passwords, security answers, or other login details in the sheet. If you use a template copied from someone else, inspect its formulas and sharing settings. For offline editing or other spreadsheet programs, check the relevant account and software features rather than assuming every Sheets behavior will transfer exactly.

Frequently Asked Questions

Can I use Google Docs for a debt snowball spreadsheet?

Use Google Sheets for the spreadsheet because it supports cells, formulas, sorting, and tables. A Google Doc can contain notes or a link to the Sheet, but it is not a substitute for a spreadsheet.

Is there a free debt snowball spreadsheet in Google Sheets?

You can build one in a blank Google Sheet with the columns and formulas above. Online templates may also be available, but review their calculations, permissions, and sharing settings before entering personal financial information.

What order should debts go in for the snowball method?

Order them by current balance, smallest first. Continue paying minimums on all debts and direct the extra payment to the smallest unpaid balance. Recheck the order as balances change.

Does the spreadsheet calculate the exact payoff date?

No. The example formulas estimate a single month and simplify interest. Exact payoff timing depends on lender calculations, payment dates, fees, rates, and future payment amounts. Ask the lender for a payoff figure when precision matters.

Should I choose the snowball or avalanche method?

The snowball prioritizes the smallest balance; the avalanche prioritizes the highest interest rate. The best fit depends on your circumstances and priorities. A sheet can organize either approach, but it does not replace individualized financial guidance.

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.