Debt Snowball Spreadsheet for ADHD: Build One in Google Sheets
If you have ADHD and a handful of debts, the hard part is rarely the maths. It is the pile: five balances, five due dates, and no clear answer to "what do I pay first?" A debt snowball spreadsheet fixes exactly that. It gives you one target at a time and shows the progress, so you are not holding the whole plan in your head.
This guide shows you how to build one in Google Sheets in about 20 minutes. You will get the columns, three copy-paste formulas, a worked example, and a few ADHD-friendly tweaks. This is general information, not financial advice.
What the debt snowball method is (and what it ignores)
The debt snowball has four steps:
- List every debt with its current balance and minimum payment.
- Pay the minimum on all of them.
- Put every spare dollar on the smallest balance until it is gone.
- Roll that whole payment onto the next-smallest debt, and repeat.
The payment grows with every debt you clear, which is where the "snowball" name comes from. One thing the method deliberately ignores is the interest rate. It orders debts by balance, not by cost. That is its strength for motivation and its weakness for total interest, and we come back to that below.
A worked example (interest left out to keep it simple)
Say you have three debts and can put an extra $100 a month on top of the minimums:
| Debt | Balance | Minimum |
|---|---|---|
| Store card | $320 | $25 |
| Medical bill | $850 | $40 |
| Credit card | $2,400 | $75 |
Your total monthly debt payment is the minimums ($140) plus the extra ($100) = $240, and it never changes. Only where it goes changes:
| When | What happens |
|---|---|
| Months 1–3 | $125 a month goes to the store card (its $25 minimum plus the $100 extra). It is cleared in month 3. |
| Months 4–8 | The store card's payment rolls over: about $165 a month now goes to the medical bill. It is cleared in month 8. |
| Months 9–15 | All $240 a month goes to the credit card. You are debt-free in month 15. |
The totals work out because any leftover in the month a debt is cleared flows straight to the next one. In real life interest makes balances a little larger, so the timeline stretches. That is why the sheet below asks you to enter your real balance each month instead of predicting it.
Why the snowball suits many ADHD brains (and when it does not)
The snowball works with a few things that are often hard with ADHD:
- One target. You never choose between five debts. The sheet names one.
- Fast, visible wins. The smallest debt disappears first, which gives you a reason to keep going.
- No rates to compare. Fewer numbers means less to avoid.
Build your debt snowball spreadsheet in Google Sheets
Step 1: Set up the columns
In a new sheet, put these headers in row 1 and list one debt per row, starting in row 2 (room for 10 debts in rows 2–11):
| Column | Header | What you type |
|---|---|---|
| A | Debt | Name, for example "Store card" |
| B | Starting balance | What you owed on day one |
| C | Current balance | Update monthly from your statement |
| D | Minimum payment | From your statement |
| E | Order | Formula (Step 2) |
| F | % paid | Formula (Step 4) |
Put two settings above or beside the table: Total monthly debt payment in cell I2 (minimums plus your extra) and the label "Focus debt" in I4.
Step 2: Rank the debts by balance
Paste this into E2 and drag it down to E11. It gives the smallest open balance a 1, the next a 2, and so on. Paid-off debts (balance 0) and empty rows show nothing, and tied balances still get different numbers.
=IF(C2>0, COUNTIFS($C$2:$C$11,">0",$C$2:$C$11,"<"&C2) + COUNTIF($C$2:C2,C2), "")Step 3: Show the one debt to focus on
In I5 (under "Focus debt"), paste:
=IFERROR(INDEX($A$2:$A$11, MATCH(1,$E$2:$E$11,0)), "All paid off!")This is the single most useful cell in the sheet. Make the font big.
Step 4: Calculate how much to pay on it this month
In I7, paste the formula below. It takes your total monthly payment and subtracts the minimums of all the other open debts, so everything left goes to the focus debt. That is the snowball.
=IFERROR(I2 - (SUMIF($C$2:$C$11,">0",$D$2:$D$11) - INDEX($D$2:$D$11, MATCH(1,$E$2:$E$11,0))), "")With the example above, this returns $125 at first and $165 after the store card is cleared, matching the table. For the "% paid" column, paste this into F2 and drag down:
=IF(B2>0, MAX(0, 1 - C2/B2), "")Format column F as a percentage.
Step 5: Make the focus row impossible to miss
Select A2:F11, go to Format → Conditional formatting, choose "Custom formula is", and enter =$E2=1. Pick a bright fill colour. Whichever debt is next lights up automatically.
Step 6: Update it once a month
Each month, type your new balances from your statements into column C. Type 0 when a debt is paid off, and the order, focus debt and payment all update on their own. Because you are entering real balances, any interest charged is already included.
ADHD-friendly tweaks that make it stick
- Automate the minimums. A missed minimum costs far more than anything the snowball saves. Set autopay for every minimum and use the sheet only for the extra.
- One fixed check-in. Pick one day a month, such as the day after your payday, and set a recurring calendar reminder. Five minutes is enough.
- Show the win. Put a "debts cleared" counter next to the focus debt. Seeing "2 of 5" feels better than staring at a total.
- Keep it to one tab. The more tabs, the more reasons to put it off.
- Treat a missed month as data, not failure. Update the balances and carry on.
For more systems built around low effort, read ADHD Budgeting: 7 Systems That Work When Traditional Budgets Fail. If you need a budget to fund the extra payment, see how to make a budget in Google Sheets.
What about interest?
This sheet does not forecast interest, on purpose. It keeps the setup short and the numbers honest, because you always type the real balance. The trade-off is that it cannot tell you a payoff date or how much interest you will pay. If those numbers matter to you, or if you have a debt with a very high rate, use a calculator that models interest as well, or ask a nonprofit credit counsellor.
Want it ready-made instead?
The ADHD Budget Planner for Google Sheets and Excel includes a simple Debt Payoff tab, a safe-to-spend number and a bill calendar, with no subscription.
Frequently asked questions
What is a debt snowball spreadsheet?
It is a sheet that lists every debt with its balance and minimum payment, sorts them from smallest to largest, and shows which debt to pay extra on this month. When one debt is cleared, its payment rolls into the next.
Is the debt snowball a good method for ADHD?
Many people with ADHD find it easier to stick with because there is one clear target and early wins that are easy to see. The best method is the one you will keep using, and it is worth checking your highest interest rates before you commit.
Does the debt snowball save as much money as the avalanche?
Usually not. The avalanche targets the highest interest rate first and typically costs less in interest overall. The snowball trades some of that saving for motivation. If one debt has a very high rate, consider paying it first or speak with a nonprofit credit counsellor.
Can I build a debt snowball spreadsheet in Google Sheets for free?
Yes. You need a few columns and three formulas: one to rank the debts, one to name the focus debt, and one to calculate this month's payment on it. All three are above.
Do I need to include interest?
Not for this simple version. If you type the real balance from your statement each month, interest is already in that number, so the sheet tracks what is actually happening instead of forecasting it.