Free Debt Payoff Spreadsheet for Excel and Google Sheets
This free debt payoff spreadsheet plans a debt snowball, a debt avalanche or your own payoff order for up to 15 debts. It shows each debt’s payoff month, your debt-free month, total interest and a month-by-month schedule. It opens in Excel and Google Sheets, has no macros, and needs no email address to download.
If you’d rather skip the setup, run your numbers in the debt payoff calculator first, then export your plan to a CSV file with your own debts already filled in.
No email, no macros. Opens in Excel and Google Sheets.
Already entered your debts in the debt payoff calculator? Its CSV export gives you a file with your own plan filled in.
| Tab | What it does |
|---|---|
| Instructions | How to fill it in and the rules the math follows |
| Debts | You type each debt: name, balance, APR, minimum |
| Plan | You pick the order and extra payment; it shows payoff months and totals |
| Schedule | Payment, interest and balance for every debt, month by month |
| Tracker | You log what you actually paid, with running totals |
| Debt | Balance | APR | Minimum | Payoff order | Paid off in month | Interest paid |
|---|---|---|---|---|---|---|
| Store card | $1,200.00 | 17.99% | $35.00 | 2 | 18 | $271.84 |
| Visa | $4,800.00 | 27.99% | $120.00 | 1 | 16 | $984.18 |
| Personal loan | $9,500.00 | 11.5% | $250.00 | 3 | 29 | $1,741.41 |
| Total | $15,500.00 | $405.00 | 29 | $2,997.43 |
What’s in the workbook
The workbook has five tabs. You type into two of them (Debts and Tracker) and make one choice on a third (Plan). The formulas do the rest.
Instructions
A short guide to the workbook: which cells to fill in, what each tab shows, and the rules the math follows.
Debts
List up to 15 debts, one per row. Each row takes four inputs:
- Name: anything that tells you which debt it is, like “Visa” or “Car loan”
- Balance: what you owe today
- APR: the annual percentage rate from your statement
- Minimum payment: the required monthly payment
Credit cards, car loans, personal loans, medical bills and student loans all fit. Leave unused rows blank.
Plan
This is where you choose the strategy and see the results. Pick one of three payoff orders:
- Snowball: smallest balance first
- Avalanche: highest APR first
- Your own order: you number the debts in the order you want to pay them
Then enter your extra monthly payment, the amount you can pay above all your minimums combined. The Plan tab shows the month each debt is paid off, the month you become debt-free and the total interest you pay. Change the strategy or the extra payment and every result updates.
Schedule
The month-by-month view: for every month and every debt, the payment, the interest charged and the balance left. This is the tab to look at when you want to know exactly where next month’s money goes.
Tracker
Plans drift. The Tracker tab is where you log what you paid each month, so you can compare real payments with the schedule. If you paid extra one month, or had to skip the extra, you’ll see it here.
How the math works
The spreadsheet uses the same rules as every calculator on this site:
- The monthly interest rate is the APR divided by 12.
- Each month, interest is added to each balance and rounded to the cent.
- Every debt gets its minimum payment. The extra payment goes to the target debt, the one at the top of your chosen order.
- Your total monthly budget stays fixed. When a debt is paid off, its minimum rolls over to the next target, so the payment aimed at that debt grows.
- The final payment on each debt is exactly what’s left, including that month’s interest.
With the same inputs, the spreadsheet and the debt snowball calculator should agree. Card issuers usually charge a daily rate on your average daily balance, so real statements can differ by a few dollars. The methodology page covers every rule in detail.
Here is what the strategy choice can mean. Take a store card with $1,200 at 17.99% (minimum $35), a Visa with $4,800 at 27.99% (minimum $120) and a personal loan of $9,500 at 11.5% (minimum $250), plus $250 extra a month. The snowball finishes in 2 years, 5 months with $3,164.65 in interest. The avalanche finishes in 2 years, 5 months with $2,997.43 in interest. The snowball pays off its first debt in 5 months. The snowball vs avalanche guide explains the trade.
Start with your own debts: export from the planner
Typing debts into a blank sheet is the slowest part. The debt payoff calculator on the homepage can do it for you. Enter your debts there, pick a strategy, and use the CSV export. You get a file with your own debts and your plan, ready to open in Excel or import into Google Sheets.
The planner runs in your browser, and your numbers never leave your device. The CSV is saved straight to your computer.
How to use it in Google Sheets
The workbook is an Excel file, and Google Sheets opens it without changes:
- Download the .xlsx from the button at the top of this page.
- Upload it to Google Drive. In Drive, choose New > File upload and pick the file.
- Open it in Google Sheets. Double-click the file in Drive, then choose File > Save as Google Sheets. That gives you a native Sheets copy where every formula recalculates as you edit.
Already in Sheets? Go to File > Import, upload the .xlsx and choose “Create new spreadsheet.” Google’s help page lists .xlsx among the file types Sheets can import. The same route works for the CSV from the planner.
How it compares with Vertex42’s debt reduction calculator
Vertex42’s debt reduction calculator is a long-running free spreadsheet, and its page reports over 1.4 million downloads. Here is how the two line up, based on Vertex42’s page as of September 2026:
| This spreadsheet | Vertex42 (free version) | |
|---|---|---|
| Price | Free | Free; paid Extended ($9.95) and Pro ($39.95) versions |
| Debts | Up to 15 | Up to 10 (20 or 40 in paid versions) |
| Excel and Google Sheets | Yes | Yes (Excel 2010 or later) |
| Payoff orders | Snowball, avalanche, your own order | Lowest balance first, highest interest first, order entered, custom priority, no snowball |
| Interest method | Balance × APR ÷ 12, rounded to the cent | Balance × APR ÷ 12 (monthly estimate) |
Vertex42 offers more payoff orders, including a minimums-only view, a chart of how the snowball grows, and an “Additional” column for one-off extra payments. Its free version is licensed for personal use only. This spreadsheet adds a Tracker tab for what you actually paid, room for 15 debts in the free file, and a start from the planner’s CSV export. Vertex42 notes that its calculator assumes the minimums you enter stay fixed. Real card minimums shrink as balances fall, so update either spreadsheet with current balances every few months.
FAQ
Does Excel have a debt snowball template?
Microsoft’s Excel template galleries for calculators and financial management, checked in September 2026, list loan, mortgage and amortization templates but no multi-debt snowball planner. This free workbook fills that gap: download the .xlsx, enter up to 15 debts, and choose snowball, avalanche or your own payoff order.
Does Google Sheets have a debt snowball template?
You don’t need a built-in one. Download the free .xlsx from this page, upload it to Google Drive, open it and choose File > Save as Google Sheets. You get the full workbook: Debts, Plan, Schedule and Tracker tabs, with snowball, avalanche and custom payoff orders.
Is there a free debt payoff spreadsheet?
Yes. This workbook is free, needs no email address and has no macros. It handles up to 15 debts, shows each payoff month and total interest, and logs what you actually pay. Vertex42 also offers a free version that lists up to 10 debts, with paid versions for more.
How do I build a debt payoff spreadsheet?
List each debt’s balance, APR and minimum. Each month, add interest (balance times APR divided by 12, rounded to the cent), subtract the minimum, and send your extra payment to the target debt. When a debt hits zero, roll its minimum into the next one. Or download this workbook, which already does it.
Does the spreadsheet work for loans as well as credit cards?
Yes. Any debt with a balance, an APR and a fixed monthly payment fits, including car loans, personal loans and student loans. For a mortgage, the mortgage payoff calculator shows how extra payments change a single long loan, with monthly, yearly and one-time options.