Budget and tracker spreadsheets · Ink and Index
List your debts, choose a method and an extra monthly payment. The workbook estimates when each debt is paid off and how much interest you pay.
$5.99 on Etsy · instant download · sold by Ink and Index
Works in Excel and Google Sheets. A blank copy and an example-filled copy are included.
The Debt Payoff Spreadsheet is a workbook for up to 10 debts that works out, month by month, when each debt is paid off, when you are debt free and how much interest you pay. You choose the snowball method (smallest balance first), the avalanche method (highest interest rate first) or your own order, plus an extra monthly payment. It also shows what the same debts would cost if you paid only the minimums. It comes as a blank and an example-filled workbook with a 4-page guide for Excel and Google Sheets.
- Snowball, avalanche or your own order, with every minimum paid first
- The debt-free month, total interest and the interest and months you save against minimums only
- A monthly check-in that shows whether your real balance is ahead of or behind the plan
- 10
- debts
- 120
- months in the schedule
- 3
- payoff methods
- 36
- months of check-ins
Why a Debt Plan Needs an Estimated Date, Not Just a Total
A total balance tells you how bad it is. It does not tell you which debt to attack first, or when you will be done.
- You pay a little extra on whichever bill is due and see no change.
- You cannot tell whether the snowball or the avalanche costs less on your debts.
- A calculator gives one number and no month-by-month plan.
- When a debt clears, the money it freed drifts into the rest of the budget.
- You never find out whether you are ahead of plan or behind it.
Six Parts of the Debt Payoff Workbook
Pick a part to see it. You type only in the cells with blue text on yellow, and every other number is a formula.
Part 1 of 6 · the Dashboard
Your estimated debt-free month
- Months until debt free and the debt-free month
- Total interest and total paid
- Interest and months you save against minimums only
Part 2 of 6 · the Debts tab
Your debts
- Up to 10 debts: name, balance, yearly rate and minimum payment
- Your extra monthly payment, the method and the start month
- Amounts show no currency symbol
Part 3 of 6 · the line chart
Plan against minimums only
- Total debt over time with your plan
- The same debts paying only the minimums
- A bar chart of interest by debt
Part 4 of 6 · each debt in turn
Payoff order, month and interest
- Which debt is cleared first and when
- The month, date and interest for each debt
- When one clears, its payment rolls into the next
Part 5 of 6 · the Check-in tab
Plan against real life
- Type your real total balance each month
- See whether you are ahead of or behind the plan
- 36 months of check-ins
Part 6 of 6 · you choose the order
Snowball, avalanche or custom
- Snowball: smallest balance first
- Avalanche: highest interest rate first
- Custom order: type 1, 2, 3 for the order you want
$5.99 on Etsy · instant download · sold by Ink and Index
Read the guide first
1 / 5
How to Build a Payoff Plan in Five Steps
Keep your latest statements to hand.
-
Gather your debts
Find each balance, yearly interest rate and minimum payment.
-
Type them on the Debts tab
Add each debt once, then your extra monthly payment and the month you start.
-
Choose a method
Snowball, avalanche or a custom order. Every method pays every minimum, and spare money goes to the first debt in the order.
-
Read the Dashboard
See the debt-free month, total interest, and what you save against paying only the minimums.
-
Check in each month
Type your real total balance on the Check-in tab and see whether you are ahead or behind.
What Is Inside the Debt Payoff Spreadsheet
- Start Here and Debts
- Plain steps, how the maths works, a color key and the limits, then up to 10 debts with your extra payment, the method and the start month.
- A Dashboard
- Months until debt free, the debt-free month, total interest, total paid, the interest and months saved, a payoff order and two charts.
- A Check-in tab
- Type your real balance each month for 36 months and see whether you are ahead or behind.
- Schedule and Compare tabs
- The month-by-month working behind the Dashboard for 120 months, formulas only.
- Three methods
- Snowball, avalanche or a custom order. When a debt is cleared, its payment rolls into the next.
- A blank and an example workbook
- The example has five invented debts so you can see how it works.
Debt payoff or budget spreadsheet?
| Compare | Debt Payoff | Annual Budget |
|---|---|---|
| Answers | When will I be debt free? | Where did the money go? |
| You enter | Up to 10 debts once | Every income and expense |
| Looks ahead | 120 months | A single year |
| Page | You are here | Annual Budget |
Where to buy, and what each store sells
| Store | Price | Includes | Buy |
|---|---|---|---|
| Etsy | $5.99 | Blank and example-filled .xlsx workbooks and a 4-page guide for Excel and Google Sheets | Buy on Etsy |
Prices checked 23 October 2026. Each store shows its own refund terms at checkout.
Limits and Honesty
Interest is the balance times the yearly rate divided by 12, rounded to the cent, and payments are assumed to land at the end of each month. A debt that is not cleared within 120 months shows 'Over 10 years'. Fixed loan schedules, interest charged daily, late fees, promotional rates that change and balance transfers are not modelled.
Lenders round and time interest differently, so treat the dates and totals as a close estimate and compare them with your statements. It is a planning tool, not financial, credit, tax or legal advice. If you are struggling with debt, a non-profit credit counselling service in your country can help.
AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The workbook's results were checked against an independent calculation of the example data. Personal use. Please do not resell, share or upload the files.
What You Download
Three files: a blank workbook, an example-filled workbook with five invented debts and a 4-page read-me guide. It uses ordinary formulas and no macros.
- 3
- files
- 10
- debts
- 0
- macros
No bank connection, no reminders and no budget or net worth tabs.
Debt Payoff Spreadsheet: Frequently Asked Questions
What is the Debt Payoff Spreadsheet?
A workbook that takes up to 10 debts, a method and an extra monthly payment and works out when each debt is paid off, when you are debt free and how much interest you pay.
What is the difference between snowball and avalanche?
Snowball pays the smallest balance first. Avalanche pays the highest interest rate first. The workbook also takes a custom order. Every method pays every minimum, and the spare money goes to the first debt in the order.
Does it work in Google Sheets?
It uses ordinary formulas and no macros, so it runs in Excel and in Google Sheets. In Google Sheets, use the link in the PDF guide to make your own copy, or upload the .xlsx to Google Drive, open it and choose File, Save as Google Sheets. Formulas, dropdowns and colors usually carry across, but chart styling can change a little, so check the main tabs after you import.
How accurate are the dates?
Close, not exact. Lenders round and time interest differently, so compare the dates and totals with your statements.
What does it not model?
Fixed loan schedules, interest charged daily, late fees, promotional rates that change and balance transfers.
What are the limits?
10 debts and 120 months. A debt not cleared within 120 months shows 'Over 10 years'.
What do I get when I buy it?
Three files: a blank workbook, an example workbook with five invented debts and a 4-page guide.
How much does it cost, and where can I buy it?
As of 23 October 2026 it costs $5.99 on Etsy. The table above shows what the store sells.
More questions
Does it include a budget?
No. For one, see the Annual Budget Spreadsheet.
Is it financial advice?
No. It is a planning tool, not financial, credit, tax or legal advice. If you are struggling with debt, a non-profit credit counselling service in your country can help.
Does it work in any currency?
Yes. Amounts show no currency symbol.
Was AI used to make it?
AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The workbook's results were checked against an independent calculation of the example data.
Can I share it?
Personal use. Please do not resell, share or upload the files.
What if a file will not open?
Email the address on the contact page. If a file will not open or is not what the listing describes, it gets fixed or replaced.
Put an Estimated Date on Debt Free
List your debts, pick a method and read the Dashboard. The spreadsheet is an instant download. To budget the extra payment, see the Annual Budget Spreadsheet.
$5.99 on Etsy · instant download · sold by Ink and Index
Sharing money with a partner? The Couples Budget Spreadsheet splits costs and settles up.