Debt Snowball Spreadsheet: Build a Payoff Tracker in Excel

Build a debt snowball spreadsheet in Excel by listing each debt from smallest to largest balance, setting a monthly payment budget, and tracking interest, payments, and new balances month by month. The formulas below estimate interest and cap payments at the amount owed; you enter the planned payment amounts so you can direct the extra toward the smallest debt and roll freed-up payments to the next one.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The steps also work in Excel for Mac; menu names are generally the same, though some ribbon controls may be arranged differently.
A recent statement for each debt, including its current balance, APR, minimum payment, and due date.
Your planned extra monthly debt payment and, ideally, a few minutes each month to update balances and statement interest.

Use the lender’s current figures rather than estimates from memory. This spreadsheet is a planning tool, not financial, tax, investment, or legal advice. Confirm payment rules and interest calculations with each lender, or consult a qualified professional about your circumstances.

Step-by-Step

Create a debt inventory. Start a blank workbook and rename the first sheet Debt Plan. In A4:E4, enter Debt, Current balance, APR, Minimum payment, and Snowball order. Enter one debt per row starting in row 5. Put APRs in a consistent format, such as 18% rather than 18. Put the debt with the smallest balance first, then sort the remaining debts from smallest to largest. Give them order numbers 1, 2, 3, and so on. Keep each lender’s minimum payment in the inventory even if it is not the target for extra payments.
Format and check the inventory. Select A4:E7, or the full range of your list, and choose Home > Format as Table. Check that My table has headers is selected. Excel for Mac has the same command on the Home tab. Format balances and minimums as Currency and APR as Percentage using Home > Number. Confirm that every balance is positive, each APR is a percentage, and the order numbers match the ascending balances. If two debts have the same balance, choose either order and keep it consistent.
Set the monthly budget. Put Extra payment in K2 and enter the amount you can add above the combined minimums in K3. Put Total monthly debt budget in J4 and the total in K4. With minimum payments in D5:D7 and the extra payment in K3, enter this formula in K4: =SUM(D5:D7)+K3. If the minimums are $75, $60, and $45, and K3 is $120, K4 returns $300. This is the planned total for all debts each month, not $300 for each debt. If you add more debts, expand the SUM range to include every minimum payment.
Make a payment ledger. In A11:I11, add these headings: Month, Debt, Opening balance, APR, Minimum, Planned payment, Interest, Actual payment, Closing balance. Use one row per debt per month. For the first month, the three debts go in rows 12–14 in snowball order. Fill in the month, debt name, opening balance, APR, and minimum from your inventory. You can copy APR and minimum figures into the ledger so each month’s record remains understandable if the inventory later changes.
Calculate estimated monthly interest. In G12, with the opening balance in C12 and APR in D12, enter =C12*D12/12. For an opening balance of $1,200 at 18% APR, this returns $18 for one month. Copy the formula down the ledger, adjusting row references as needed. It assumes a simple monthly estimate based on APR divided by 12; lenders may calculate interest daily or use different timing, so reconcile this estimate with the statement.
Enter planned payments in snowball order. Fill column F with the amount you intend to send to each debt that month. Pay at least the required minimum on every active debt, then direct the remaining budget to the first debt in the ordered list. For example, with a $300 budget and minimums of $75, $60, and $45, put $195 toward the first debt, $60 toward the second, and $45 toward the third, provided the first debt is not already paid off. If the target needs less than the planned amount to clear it, move the leftover to the next debt instead. The planned payments should total no more than the monthly budget, and normally total the full budget while debts remain.
Cap payments and calculate new balances. In H12, with the planned payment in F12, opening balance in C12, and estimated interest in G12, enter =MIN(F12,C12+G12). It returns the lesser of the planned payment and the amount owed, so it will not show a payment larger than the balance plus estimated interest. In I12, with those same cells and actual payment in H12, enter =MAX(0,C12+G12-H12). If the opening balance is $1,200, interest is $18, and actual payment is $195, this returns a $1,023 closing balance. Copy both formulas down the ledger.
Start the next month with the previous closing balances. Add three new rows for the next month. Link each opening balance to the corresponding prior-month closing balance: for example, if the first month is in rows 12–14 and the next month is in rows 15–17, enter =I12 in C15, =I13 in C16, and =I14 in C17. Update each row’s month and plan the payments again. When a balance reaches zero, set its planned payment to zero and roll the amount that had gone to it into the next unpaid debt, while still meeting all active minimums.
Add a simple progress check. In J11, label a column Monthly planned total, and in J12 enter =SUM(F12:F14) for the three first-month planned payments. The example allocation of $195, $60, and $45 returns $300. Compare this result with the budget in K4 each month. Expand the range for months with more debts. You can also format closing balances as Currency and use Home > Conditional Formatting > Highlight Cells Rules > Less Than to highlight zero balances; enter 1 as the threshold. On Mac, use the same Conditional Formatting controls on the Home tab.
Review and save the plan. Before relying on a month’s planned amounts, verify that the sum of active minimums is covered, the extra goes to the lowest-balance unpaid debt, and total planned payments stay within the budget. Save the workbook with a clear name and update it after payments post, using actual statement balances and interest where available. A forecast is not a substitute for checking that payments reached lenders on time.

Common Mistakes

Ordering by APR instead of balance: The snowball method targets the smallest balance first. If you prefer to prioritize the highest APR, that is a different payoff approach; do not mix the two without changing your stated plan.
Forgetting minimums on other debts: The target gets the extra, not the whole budget. Keep making at least the required minimum on every active account to avoid treating the snowball as permission to skip a payment.
Leaving a paid-off debt in the allocation: Once a debt is cleared, do not keep assigning its minimum to a zero balance. Move that amount to the next unpaid debt and check that the planned total still matches the budget.
Assuming the interest formula exactly matches a statement: The monthly estimate may differ because a lender can calculate interest daily, apply payments on different dates, or include fees. Replace estimates with statement figures when possible.
Counting the extra twice: The total budget is all minimums plus the extra amount. Do not add the extra again to the target payment after you have already included it in the planned total.

Tips

Keep the original inventory and monthly history instead of overwriting old rows. The ledger makes it easier to spot a missed payment, unexpected fee, or balance change.
Use actual payment amounts and statement balances to update the next month. If a lender’s posted balance differs from the estimate, use the posted figure as the new starting balance and investigate the difference.
Set a calendar reminder before due dates to check each minimum payment and confirm your extra payment. Payment posting dates can affect interest and the reported balance.
Use one consistent currency format and enter APRs as percentages. If you enter 18 instead of 18%, Excel treats it as 1,800% in calculations.
Keep the spreadsheet private and store it somewhere secure. It contains sensitive information about your finances; account passwords and full account numbers do not belong in the workbook.

Troubleshooting

The closing balance becomes negative: Check that the closing-balance formula uses MAX with zero as its first argument and that the actual payment is capped by the amount owed. The formulas above should never return a negative closing balance.

The total payment is higher than expected: Add the planned payments for the month and compare them with K4. Check whether you included the extra payment twice or kept a minimum payment assigned to a debt that is already paid off.

The balance rises despite a payment: Compare the payment with interest and any fees shown by the lender. If the payment is smaller than interest and charges, the balance may grow. Enter the statement’s actual balance and ask the lender to explain any fee or calculation you cannot reconcile.

A formula displays as text or does not calculate: Make sure the cell is formatted as General or Number, begin the entry with an equals sign, and check that the cell does not contain a leading apostrophe. Excel for Windows and Mac both use commas between function arguments in the formulas shown here.

The snowball order stops making sense after a balance changes: Re-sort unpaid debts by their current balances at the start of a new plan, or keep the original order if you are following a fixed sequence. If you change the order, record the new order clearly and continue meeting all minimum payments.

Frequently Asked Questions

Should I list debts from smallest balance or highest interest rate?
The debt snowball lists debts from smallest balance to largest and directs extra money to the smallest unpaid balance. Highest-interest-first is a separate strategy. Choose the approach you intend to follow and label the order so the ledger stays consistent.

Does the spreadsheet calculate the exact payoff date?
Not by itself. The ledger estimates monthly interest and depends on your planned payments and statement updates. Actual payoff timing can differ because of daily interest, fees, payment dates, and lender rules. Ask the lender for a payoff quote when you need an exact amount.

What should I do when I pay off the first debt?
Enter its actual zero balance, stop assigning it a payment, and add the freed-up amount to the next smallest unpaid debt. Keep the overall monthly budget steady if you can, and continue paying minimums on all remaining debts.

Can I use this spreadsheet if my income changes?
Yes. Update the extra payment and total budget for the amount you can actually commit that month, then revise the planned payments. Avoid entering a payment plan that exceeds available funds or misses a required minimum.

Why does Excel show a different balance from my lender?
The sheet uses an approximate monthly interest calculation, while a lender may use daily balances, different posting dates, fees, or other account-specific terms. Use the lender’s posted figures for your next opening balance and check the account agreement or contact the lender about the difference.

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.