Debt Payoff Tracker
A debt payoff spreadsheet that compares the snowball and avalanche methods. Enter your debts and the extra amount you can pay each month, and it shows your debt-free date, total interest and a month-by-month schedule for each method.
What's included
- A My Debts tab for up to 15 debts with balance, APR and minimum payment, plus your extra payment, start month and chosen method
- Snowball and avalanche plan tabs with the payment and balance for every debt, every month, for up to 30 years
- A comparison of both methods against paying only the minimums: debt-free date, months, total interest and interest saved
- A balance tracker for logging your real statement balances each month for 5 years, with a progress chart
- A dashboard with the payoff order, a projected balance chart and how much you have paid off so far
- An Instructions tab and a 2-page Quick Start Guide (PDF)
Files
- Debt Payoff Tracker.xlsx, with fictional sample debts filled in
- Quick Start Guide.pdf
You get them in one zip file, Debt Payoff Tracker.zip.
Good to know
Works in Excel 2016 or later and Microsoft 365 on Windows or Mac, and in Google Sheets on a computer, phone or tablet. There are no macros or add-ins. To use it in Google Sheets, upload the .xlsx to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
The plan and dashboard tabs are protected without a password, so you can unlock them if you want to change something.
This is a digital download, so nothing is shipped. You can download the files from your Etsy Purchases page (or the Payhip link) right after you buy. Sample names and figures are fictional.
License (single person / single business): for use by one person, or one business and its own staff. You may edit it and make copies for your own use. You may not resell, share, give away or redistribute the files, or use one purchase for more than one person or business.
Questions? Email Bengopoyan1@gmail.com. More templates: etsy.com/shop/KeelAndCharter and payhip.com/KeelandCharter
This tracker is a planning tool, not financial advice. Interest is estimated monthly; your lender's figures may differ slightly. Always pay at least every minimum on time.
Disclaimer: This template is an organizational tool, not financial advice. Results depend on the numbers you enter; check important decisions with a qualified professional.
Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.