Debt Snowball Spreadsheet for Google Sheets: Setup & Formulas

Yes. A debt snowball spreadsheet for Google Sheets can rank debts by current balance, apply minimum payments to every account, then direct the rest of a fixed monthly budget to the smallest balance. Set up the columns below and use the formulas to estimate monthly interest, payments, and remaining balances; update the balances each month using your statements.

What the debt snowball method does

The debt snowball is a repayment approach that orders debts from the smallest balance to the largest, without using interest rate to set the order. You make at least the required minimum payment on each debt and put any extra money toward the smallest one. When it is paid off, you redirect the amount you had been paying on it to the next debt. That growing payment is the “snowball.”

The method is often chosen because paying off an account creates a visible milestone. It is not necessarily the method that minimizes interest: if a large-balance debt has a much higher rate, paying it later can cost more than prioritizing the highest rate. A spreadsheet makes the balance order and the trade-off easier to see, but it cannot change the terms of your accounts.

Set up the sheet

In a blank Google Sheets file, use row 1 for these headings. Put one debt on each row, starting in row 2. The example formulas below allow for debts in rows 2 through 20; change those endpoints if your list is longer or shorter.

A: Debt: a card, loan, or other account name.
B: Opening balance: the balance at the start of the period.
C: APR: enter the annual percentage rate as a percentage, such as 24%.
D: Minimum due: the required payment for this period.
E: Estimated interest: calculated from balance and APR.
F: Planned minimum: the minimum capped at the amount owed, including estimated interest.
G: Extra snowball: the share of your extra budget directed to this row.
H: Total payment: planned minimum plus extra.
I: Estimated closing balance: the balance after estimated interest and payment.

Enter your total debt-payment budget for the month in K1, and label K1 or J1 clearly so you remember what it represents. Sort the debt rows by opening balance, smallest to largest. The order matters: the first unpaid debt receives extra money before the rows below it. Keep a separate copy of the original balances or use a new monthly tab if you want to preserve a history.

Enter the formulas

With the opening balance in B2 and APR in C2, enter this in E2 to estimate one month of interest, rounded to cents:

=ROUND(B2*C2/12,2)

With the minimum due in D2, opening balance in B2, and estimated interest in E2, enter this in F2. It prevents the planned minimum from exceeding the estimated amount owed:

=MIN(D2,B2+E2)

For the first debt row, with the monthly budget in K1 and planned minimums in F2:F20, enter this in G2. It calculates the budget left after minimums, limited to the first debt’s remaining amount after its minimum:

=MIN(MAX(0,$K$1-SUM($F$2:$F$20)),MAX(0,B2+E2-F2))

For the next debt, enter this in G3, then fill the formula down through G20. The formula subtracts extra payments already assigned to earlier rows, so the snowball moves down the balance-ordered list only when a debt’s available amount is covered:

=MIN(MAX(0,$K$1-SUM($F$2:$F$20)-SUM($G$2:G2)),MAX(0,B3+E3-F3))

With planned minimum in F2 and extra payment in G2, enter this in H2 and fill down:

=F2+G2

With opening balance in B2, interest in E2, and total payment in H2, enter this in I2 and fill down:

=MAX(0,B2+E2-H2)

For a quick budget check, with planned payments in H2:H20, enter this in a summary cell such as K2:

=SUM(H2:H20)

If K2 is above K1, the entered budget is below the sum of the required minimums. The formulas do not reduce minimum payments to fit a smaller budget, so treat that mismatch as a prompt to check your figures and contact creditors or a qualified professional about your options.

Worked example: how the allocation behaves

Suppose the sorted list has three debts: Card A with a $500 balance, 24% APR, and $35 minimum; Card B with a $1,500 balance, 18% APR, and $60 minimum; and Loan C with a $3,000 balance, 12% APR, and $100 minimum. Set the monthly budget in K1 to $300. These figures are illustrative, not a payoff quote.

The formulas estimate interest of $10 on Card A, $22.50 on Card B, and $30 on Loan C. The planned minimums total $195, leaving $105 for extra payments. Since Card A is first, its total payment is $140 ($35 plus $105). Card B and Loan C receive their $60 and $100 minimums. Estimated closing balances are $370, $1,462.50, and $2,930 respectively. The payments total $300, and the closing balances total $4,762.50; that is $5,000 of opening debt plus $62.50 interest minus $300 paid.

In the next period, use current statement balances as the new opening balances and enter the new minimum amounts. As Card A gets close to zero, the extra allocation is capped at what remains owed, and any unused extra passes to the next debt in the list. When Card A is fully paid, its required minimum will also be zero or no longer apply, depending on the account and timing. The budget that is no longer needed for that payment becomes available to the remaining debts through the same calculation.

Use it month by month

This is a one-period calculator, not a complete automated amortization schedule. At the beginning of each cycle, check the latest balances, APRs, minimums, payment due dates, and planned budget. Review the estimated payments, make payments through your lender’s normal channels, and then record what actually happened. For the next cycle, use new opening balances and minimums rather than assuming the estimate exactly matches the account statement.

Enter or update balances, APRs, and minimums from current account information.
Sort the debts from smallest current balance to largest.
Set K1 to the total amount you intend to pay across the listed debts for that period.
Check that the payment total and individual amounts are feasible, then make payments according to each lender’s instructions.
Record actual payments and statement balances. Investigate differences rather than carrying an inaccurate estimate forward.

If you want a record of progress, duplicate the tab for each month or keep a separate history table with dates and actual balances. A snapshot approach is deliberately easier to maintain than a long formula-driven forecast, but it requires monthly updates and will not automatically know when a lender changes a minimum or posts a fee.

Google Sheets sorting and visual checks

To reorder the list after updating balances, select the full debt table and use Data > Sort range, choosing the balance column in ascending order. Include the entire row range so names, rates, and minimums stay attached to the right balances, and identify the header row if the sort dialog offers that option. Sorting only column B would scramble the data.

To highlight debts with an estimated zero balance, select I2:I20 and choose Format > Conditional formatting. Set a rule for cells equal to 0 and choose a fill color. This is a visual cue to verify the account’s actual payoff status; it is not confirmation from the lender that the debt is closed or that no residual interest remains.

Accuracy limits and common mistakes

The interest formula uses a simple monthly estimate: opening balance multiplied by APR divided by 12. Many revolving accounts calculate interest using daily balances, and loans can have different accrual methods, payment timing, fees, or promotional terms. As a result, the spreadsheet’s interest and closing balance can differ from a statement. Check the actual terms with each lender and use statement figures for decisions. The sheet is for organizing estimates, not financial, tax, investment, or legal advice; consult a qualified professional when you need advice about your circumstances.

Forgetting to sort: the snowball formula follows row order, not the values in the balance column. Re-sort after balances change.
Entering APR as a whole number: enter 24% or 0.24, not 24, for a 24% APR.
Leaving out a debt: an omitted minimum makes the available extra look larger than it really is. Include all debts you intend to budget for.
Using the wrong budget: K1 should be the total payment budget for the listed debts, not the extra payment alone.
Relying on a predicted minimum: minimum-payment rules vary. Enter the amount actually required for the period, not a guess from a prior month.
Paying only what the estimate shows: confirm due amounts and payment posting with the lender, especially near payoff.

Snowball versus avalanche

The avalanche method sends extra money to the debt with the highest APR while paying minimums on the others. It can reduce interest in many cases when rates and other terms are comparable, while the snowball prioritizes early balance payoffs. The approaches can point to different first debts: in the example, the snowball starts with Card A because its $500 balance is smallest, while an avalanche would start with Card A too because it also has the highest APR. If Card B instead had the highest rate, the methods would choose different targets.

You can compare the approaches in Sheets by making a second copy of the tab and sorting that copy by APR from highest to lowest. Keep the same payment budget and inputs so the comparison is meaningful. The one-month sheet can show how each method allocates this period’s payments; it does not by itself calculate a reliable total payoff date or total interest over the life of each plan. A full comparison needs repeated periods, accurate lender rules, and updated balances.

Frequently Asked Questions

Does Google Sheets have a debt snowball template?

Google Sheets may offer templates in its template gallery, but the availability and contents can change. The layout and formulas above let you build a basic tracker directly in a blank sheet without relying on a particular template.

Should I sort debts by balance or interest rate?

For a debt snowball, sort by current balance from smallest to largest. Sorting by APR instead follows the debt avalanche method. Keep the distinction clear because the extra-payment formula follows the row order.

Can the spreadsheet predict when I will be debt-free?

This one-period tracker does not give a dependable payoff date. A forecast would need to project every payment period and account for actual interest calculations, changing minimums, fees, and payment dates. Treat any date based on simplified monthly interest as an estimate, not a lender promise.

What if my payment budget is less than all the minimums?

The example formulas still calculate the minimums and set extra payments to zero, so planned payments may exceed your budget. Do not silently reduce a required payment in the sheet and assume the account is current. Check the actual obligations and contact the lenders or a qualified professional about possible next steps.

Can I use this spreadsheet for loans as well as credit cards?

You can list different debts together for budgeting, but interest and payment rules may differ by product. Enter the lender’s required payment and treat the monthly interest calculation as an estimate; check the loan agreement and current statement for the correct terms.

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.