Debt Snowball Spreadsheet UK: Build One in Excel

How-to basics · Updated November 21, 2026

A UK debt snowball spreadsheet is a simple way to list debts from smallest to largest, keep up with each required minimum payment, and direct any spare repayment money to the smallest balance first. In Excel for Microsoft 365, you can build a useful tracker with a few columns and formulas; treat its interest figures as estimates, not as a substitute for your lenders’ statements.

What the debt snowball method means

The debt snowball is a repayment approach: pay at least the required minimum on every debt, then put the extra amount you have chosen to repay towards the debt with the smallest balance. When that debt is cleared, add the amount previously going to it to the payment for the next-smallest balance. The payment amount is thus redirected, like a snowball gathering momentum.

The method orders debts by balance, not by interest rate. That can mean clearing a small balance early, which some people find encouraging. It does not necessarily minimise interest. If a large debt has a higher rate than a small one, targeting the high-rate balance first may cost less interest, all else being equal. The snowball is a way to organise repayments, not a promise of a particular payoff date or saving.

How to use a snowball spreadsheet

Start by recording debts that you have decided are suitable for this repayment plan, then order them from lowest balance to highest. Keep required payments current on every account, and use only the amount genuinely available after essential costs and required commitments as the extra payment. Each month, check the lenders’ latest figures and update the sheet.

  1. List each debt separately, using its current balance, annual percentage rate (APR) and required minimum payment.
  2. Choose a realistic total monthly amount for these repayments. It must cover all required minimums before any extra is assigned.
  3. Subtract the total minimums from that amount. Put the resulting surplus towards the smallest balance.
  4. After a balance is cleared, redirect the payment amount that had gone to it to the next debt in the chosen order.
  5. Recheck balances, minimums, interest and any fees against current lender information each month.

Do not assume that a spreadsheet payment instruction changes a lender’s direct debit or contractual minimum. Make payments using the lender’s approved method and check the account afterwards.

Set up the workbook in Excel

In a blank worksheet, use row 1 for headings and one row per debt. A practical layout is:

  • A: Debt — a recognisable account label, such as “Card A”. Avoid storing full card numbers or login details.
  • B: Opening balance (£) — the balance at the start of the period you are tracking.
  • C: APR — the annual rate shown by the lender, entered as a percentage, such as 24%.
  • D: Minimum payment (£) — the current required payment, checked against the latest statement or account.
  • E: Planned payment (£) — the payment you intend to make this period, including any snowball extra.
  • F: Estimated interest (£) — a simplified estimate for the period.
  • G: Estimated closing balance (£) — the balance after estimated interest and the planned payment.

Keep the smallest balance at the top if you want to follow the snowball order manually. If you sort the list later, make sure the entire debt rows move together; sorting only the balance column would pair the wrong APR or payment with an account. You can add a new worksheet for each month or copy the previous month’s closing balances into the next period’s opening-balance column.

Excel formulas and a worked example

The following example is illustrative only. Suppose the sheet has three debts in rows 2 to 4: Card A has a £450 balance, 24% APR and £25 minimum; Card B has £1,200, 19% APR and a £40 minimum; Loan C has £3,000, 9% APR and an £85 minimum. Assume, just for the example, that the chosen total repayment is £200 for the month. The minimums total £150 (£25 + £40 + £85), leaving £50 extra. Under the snowball, Card A receives £75, while Card B receives £40 and Loan C £85.

With the opening balances in B2:B4 and annual APR percentages in C2:C4, enter this in F2 to estimate one month of interest, then copy it down: =B2*C2/12. For Card A, the result is £9 (£450 × 24% ÷ 12). The corresponding simple estimates are £19 for Card B and £22.50 for Loan C.

With the opening balance in B2, estimated interest in F2, and planned payment in E2, enter this in G2 and copy it down: =MAX(0,B2+F2-E2). For Card A, the estimate is £384 (£450 + £9 − £75). Card B is estimated at £1,179 (£1,200 + £19 − £40), and Loan C at £2,937.50 (£3,000 + £22.50 − £85). The three estimated closing balances total £4,500.50. That is a simplified illustration, not a lender quote.

To total the three opening balances, with those figures in B2:B4, use =SUM(B2:B4); the result is £4,650. To make the estimate easier to read, format the balance and payment columns as currency and the APR column as percentage using Excel’s number-format controls. The formulas use ordinary Excel functions and work in Microsoft 365 for Windows; the formulas also work in Excel for Mac and Excel for the web, although ribbon placement can vary.

Why the interest estimate may not match your statement

The formula divides annual APR by 12 and applies that monthly rate to the opening balance. It is useful for a rough comparison, but lenders may calculate interest daily, use different statement dates, apply promotional rates, or include fees and payment timing in ways this small model does not capture. APR can also reflect charges beyond the interest rate, so it is not always a direct monthly interest rate.

For a closer month-to-month tracker, enter the actual interest or charges shown on the statement instead of relying on the estimate. Record the actual payment and closing balance once available. If a lender changes a minimum payment, rate or promotional offer, update the relevant fields. The lender’s current terms and account figures take precedence over a spreadsheet projection.

UK considerations before choosing a repayment order

A snowball spreadsheet is most useful after you have made a complete list of what is owed and understood the payment requirements. In the UK, not all bills and debts have the same consequences if missed. Housing costs, council tax, energy bills, court fines and debts secured against an asset can require particular attention; they should not automatically be treated as ordinary unsecured balances in a snowball list. The right order depends on personal circumstances and the consequences of non-payment.

Before assigning extra money to a credit card or personal loan, account for essential household costs and priority commitments. If you are already missing payments, facing enforcement action, or cannot meet essentials and minimums, a repayment spreadsheet alone may not address the problem. Free debt guidance is available from services such as MoneyHelper, StepChange and National Debtline. They can help explain options based on your circumstances. This article is general information, not financial, tax or legal advice; check your real account terms with each lender or speak to a qualified professional or debt adviser.

Snowball versus avalanche

The avalanche method directs extra repayment to the debt with the highest interest rate, while maintaining minimums on the others. When rates and balances are known and payments are made as planned, this ordering can reduce interest compared with prioritising a lower-rate debt. The snowball instead prioritises the smallest balance, which may produce an earlier account payoff and a simpler list sooner.

For example, if the smallest debt is a 10% loan and a much larger card charges 25%, snowballing still targets the loan first. Avalanche targets the card. Neither label changes the need to keep up with required payments or to consider priority bills. A spreadsheet can help compare the orders, but a basic monthly-interest model cannot guarantee a precise total-cost comparison. Use actual lender rates, fees and repayment terms before drawing conclusions.

Common spreadsheet mistakes and limits

  • Forgetting fees or changed rates: add actual charges from statements and revise APRs when terms change.
  • Using the balance from an old statement: balances move with interest, payments and transactions; date each update.
  • Assigning the same extra twice: check that planned payments across all rows do not exceed the monthly amount you can afford.
  • Paying too much to a cleared account: the MAX formula prevents a negative estimated closing balance, but it does not automatically reallocate an overpayment. Adjust planned payments yourself and follow the lender’s payment rules.
  • Mixing debts and bills without considering consequences: separate essential bills and priority commitments from the unsecured debts you are comparing.
  • Treating the forecast as a promise: payment dates, variable rates, minimum-payment rules and lender calculations can change the outcome.

Protect the workbook as you would other personal financial records. Store it somewhere appropriate, limit access on shared devices, and do not put passwords, security answers or full payment-card details in the file. A spreadsheet is not a secure account-management system, and it does not make payments automatically.

Cost and alternatives

You can create this tracker yourself without buying a specialist template. Excel access may depend on your Microsoft 365 plan, while a basic paper list or another spreadsheet tool can also track balances, rates and payments. If you download a template, check that its formulas are visible and understandable, and do not enable macros or provide financial account credentials simply to use a debt tracker.

Other useful options include a lender’s own account tools, a simple monthly budget, or a debt adviser’s help with a wider set of options. A spreadsheet is good for organising figures and showing a possible repayment sequence; it cannot negotiate with lenders, decide whether an arrangement is suitable, or replace personalised advice. Keep the tool as simple as you can reliably update.

Frequently Asked Questions

Is there a free debt snowball spreadsheet for the UK?
You can make one in Excel or another spreadsheet application using the columns and formulas above. If you use a downloaded template, check how it calculates interest, whether it includes fees and whether it asks for unnecessary personal information.

Should I pay the smallest debt or the highest-interest debt first?
The snowball targets the smallest balance; the avalanche targets the highest rate. The first can create an early payoff milestone, while the second may reduce interest in suitable cases. Required payments and priority commitments still matter whichever order you consider.

Does the spreadsheet calculate my exact UK loan interest?
No. The example uses APR divided by 12 and an opening balance. Lenders may calculate interest differently and apply fees or changing rates. Use statements and lender terms for actual figures.

What happens when I pay off the smallest balance?
Confirm the account is cleared with the lender, then redirect the amount you had planned for that debt to the next balance in your chosen order. Continue meeting every other required minimum.

Can I use the formulas in Excel on a Mac or in a browser?
Yes. The formulas shown use standard Excel functions available in Microsoft 365 for Windows, Mac and the web. Some ribbon controls may be arranged differently, but the cell references and calculations are the same.

Related

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.