Free Debt Payoff Spreadsheet Template for Excel
A free debt payoff spreadsheet is a simple file that lists every debt you owe. Each month it adds interest to each balance, takes away your payment and shows when each balance reaches zero. Our free debt payoff spreadsheet (.xlsx) opens in Excel, or you can upload it to Google Sheets, and no account is needed. You only type in balances, interest rates and payments, and this guide walks through each column, the math behind it and how to read what it tells you.
What a debt payoff spreadsheet actually does
A debt payoff spreadsheet does three things. First, it puts all your debts in one place, so you can see the whole picture. Second, it estimates how much interest each debt adds every month. Third, it projects a payoff month for each debt based on what you pay.
The useful part is the "what if" view. Change one payment, and every payoff month below it updates. That lets you test ideas before you commit any money to them. If you want to compare it with our other trackers and worksheets, you can browse all of our debt payoff tools in one place.
- It is a planning tool, not a statement from your lender.
- It works best when you update it once a month with your real balances.
- It is only as accurate as the numbers you type in.
The columns in the Excel debt payoff template
Every row in the Excel debt payoff template is one debt. These are the columns a full payoff plan uses. In our free file, the "My debts" sheet takes the debt, balance, APR and monthly payment and works out this month's interest, months to pay off, snowball order and avalanche order, and a "Payment log" sheet records each month's debt, starting balance, payment, interest charged and ending balance.
The table below illustrates columns a more detailed month-by-month payoff spreadsheet can use; not every column is automatically calculated in our free download.
| Column | You type it or the sheet works it out | What it means |
|---|---|---|
| Debt name | You type it | A nickname, like "Card A" or "Car loan" |
| Balance | You type it | What you owe today, from your latest statement |
| Interest rate (APR) | You type it | The yearly rate shown on your statement |
| Minimum payment | You type it | The smallest payment due each month |
| Monthly interest | The sheet | Balance times APR, divided by 12 |
| Payment this month | In a month-by-month model | The minimum, plus any extra if this is the target debt |
| New balance | In a month-by-month model | Old balance plus interest minus payment |
| Payoff month | In a month-by-month model | The first month the balance reaches zero |
The monthly interest column is a simplified estimate. Most credit cards charge interest on your average daily balance, so the real number can be a little different. If you want the details, read our guide on how credit card interest is calculated.
How to fill in the spreadsheet
- Gather your latest statements for every debt: credit cards, car loans, personal loans, student loans and anything else with a balance.
- Enter one debt per row with its balance, APR and minimum payment.
- For a payoff plan, work out your total monthly debt budget, including minimum payments and any extra.
- Subtract the total minimum payments to find the amount available for extra payments.
- Choose which debt receives the extra; when that debt is paid off, you can redirect its planned payment to the next debt. Use the payment log to record what you actually paid.
- Once a month, replace the balances with the real ones from your statements so the projection stays honest.
Worked example: one month on the sheet
Example: these are made up round numbers, only to show the math.
Say you have three debts and a total debt budget of $500 a month:
- Card A: $1,000 balance, 24% APR, $40 minimum
- Card B: $3,000 balance, 18% APR, $90 minimum
- Car loan: $6,000 balance, 6% APR, $200 minimum
The minimums add up to $40 + $90 + $200 = $330. Your budget is $500, so the extra is $500 minus $330 = $170. In this example the extra goes to Card A, so Card A gets $40 + $170 = $210.
Month 1 on the spreadsheet:
- Card A interest: $1,000 × 0.24 ÷ 12 = $20. New balance: $1,000 plus $20 minus $210 = $810.
- Card B interest: $3,000 × 0.18 ÷ 12 = $45. New balance: $3,000 plus $45 minus $90 = $2,955.
- Car loan interest: $6,000 × 0.06 ÷ 12 = $30. New balance: $6,000 plus $30 minus $200 = $5,830.
Total interest that month: $20 + $45 + $30 = $95. Repeat the same math each month and Card A reaches zero in month 6. From then on, its $210 rolls to Card B, so Card B gets $90 + $210 = $300 a month. That rollover is the whole idea behind a debt payoff plan, and the spreadsheet simply shows it month by month.
Choosing which debt gets the extra
The spreadsheet does not decide your order for you. The two common approaches are:
- Snowball: smallest balance first. You see a debt disappear sooner, which some people find motivating.
- Avalanche: highest interest rate first. This usually means less total interest paid, but the first payoff can take longer.
In the example above, Card A is both the smallest balance and the highest rate, so both approaches pick it. Real lists are often messier. To see the trade off with your own numbers, you can compare snowball and avalanche payoff orders in our free calculator. If you already know you prefer the smallest balance first, you can also build a snowball version of the spreadsheet with our instructions, or start from the snowball order our free .xlsx already works out.
When a spreadsheet is not enough
A debt payoff Excel spreadsheet is great for a short list of simple debts. It gets harder when you add a 0% balance transfer with a fee and an end date, a car loan with its own schedule, or a mortgage. Formulas can break when you add rows, and it is easy to overwrite a cell by mistake.
Our free calculators and worksheets cover most of these situations one at a time. As another option, the site also offers the Clearora™ Debt Payoff Dashboard. It is an online dashboard with tabs for credit cards, balance transfers, car loans, personal loans and mortgages, plus a save and load feature so you can come back to your plan. It comes with a manual, a video and a private Skool community called Get Out of Debt Club. You can see what the dashboard includes and decide whether it fits how you like to work.
FAQ
Is the debt payoff spreadsheet free?
Yes. The free debt payoff spreadsheet is one of the site's free downloads, along with our free calculators. You do not need an account to use it.
Why is my spreadsheet payoff date different from my lender's?
The spreadsheet uses a simple monthly interest estimate. Lenders often use daily balances, and fees, late payments, new purchases or rate changes all shift the real numbers. Updating your balances from each statement once a month keeps the projection close.
Can I add car loans and student loans to the sheet?
Yes, any debt with a balance, a rate and a monthly payment fits on a row. Student loans on an income driven plan can have payments that change, so check your current payment and plan details on studentaid.gov, the official source, before you enter them.
Is a spreadsheet or a calculator better?
They do different jobs. A calculator gives a quick answer for one scenario, while a spreadsheet lets you keep a running record and update it every month. Many people use a calculator to test an idea, then track their real progress in the spreadsheet.