Debt Payoff Tracker for Google Sheets & Excel
See your total debt, log payments, and watch your balances drop month by month with clear visual progress. Track credit cards, loans, and any other debt.
Get this template on EtsyWhat's included
- Track multiple debts in one place
- Visual progress bars for each balance
- Monthly payment logging with running totals
- Total debt overview dashboard
- Interest tracking across all accounts
- Works with Google Sheets and Microsoft Excel
How it works
The spreadsheet has three tabs: Dashboard, Payment Log, and a hidden Data tab for color settings. On the Dashboard, each row represents one debt. Enter the debt name, current balance, APR, minimum payment, payment frequency (monthly, biweekly, weekly, or annually), and pick a color.
Avalanche vs. snowball
A dropdown at the top lets you switch between two payoff strategies. Avalanche ranks debts by highest interest rate first — saves the most money over time. Snowball ranks by smallest balance first — builds momentum with quick wins. The priority column updates automatically when you switch. Not sure which strategy is right for you? Read our guide to snowball vs. avalanche methods or try the debt snowball vs. avalanche calculator to compare payoff timelines side by side.
Tracking payments
Every payment goes in the Payment Log tab: date, which debt, amount, and an optional note. Once saved, the Dashboard updates automatically — paid total, remaining balance, percentage complete, progress bar, and status all recalculate.
What the Dashboard shows
Each debt gets a visual progress bar, a payoff percentage, a priority ranking, and a status (in progress or paid off). The estimated payoff column shows how many periods remain based on your current balance, APR, and payment amount.
Available in dark and light themes
Both themes are functionally identical. Use the toggle above to switch between them.
Save with a bundle
Related articles
Frequently asked questions
Can I track different types of debt?
Yes — credit cards, student loans, car payments, personal loans, medical debt. Any balance with a payment schedule works.
Does it calculate interest?
The tracker logs interest charges as part of your payment history so you can see exactly how much goes to principal vs. interest over time.
How many debts can I track?
The template supports 30+ individual debts — more than enough for most people to track every credit card, loan, and balance in one place.
More spreadsheets
Best SellerBudget Spreadsheet
Track your income and daily expenses with real-time progress indicators that show exactly where you stand each month. Works with Google Sheets and Microsoft Excel.
Couples Budget Spreadsheet
Split bills, track shared and personal expenses, and manage savings together. Built for two incomes, one shared financial picture.
Savings Goals Tracker
Set multiple savings goals, track contributions, and watch your progress toward each one. Perfect for emergency funds, sinking funds, and any savings target.