Debt Payoff Tracker Template for Google Sheets (Free, 2026)

Debt feels worse when you can't see it. Statements arrive on different days, balances live in different apps, and the only number you ever look at is the total — which never seems to move. A debt payoff tracker in Google Sheets fixes that: every balance, rate, and minimum in one table, a clear payoff order, and a single date that tells you when you'll be free. This guide walks through building one, choosing a method, and keeping it current so the plan actually works.

What a debt payoff tracker actually is

A debt payoff tracker has three moving parts:

1. The debts — every balance you owe, with its interest rate and minimum payment.
2. The plan — how much extra you can put toward debt each month, on top of the minimums.
3. The projection — the month you'll hit zero, given the order you pay things off.

Everything else is presentation. When the tracker adds up your balances, you see the real total. When it applies your extra payment to one debt at a time, you get the single most motivating number in personal finance: the date you become debt-free — and you watch it move closer every month.

The reason a spreadsheet beats a generic app for this is control and clarity. You decide the order, you see exactly how the math works, and the file lives in your own Google Drive. There's no subscription standing between you and your own payoff plan.

Why Google Sheets is the best home for it

You can track debt on paper, in a banking app, or in a dedicated payoff app. Google Sheets hits the sweet spot:

• Free and cloud-based. No license, and it auto-saves so you never lose your plan.
• Works everywhere. Update a balance on your laptop or check the debt-free date on your phone.
• Easy to share. A partner can see and edit the same payoff plan in real time.
• Automatable. It connects to Avery, which keeps your balances and payments current so the projected date stays accurate without manual updates.

That last point is the difference between a tracker you fill in once and one that still works in month six. More on that below.

How to make a debt payoff tracker in Google Sheets (step by step)

You can build one from scratch, but starting from a template means the formulas already work. Here's the full process either way.

Step 1: List every debt

Make a row for each debt and capture four things: the name (Visa, car loan, student loan), the current balance, the interest rate (APR), and the minimum payment. Pull these straight from your most recent statements.

Resist the urge to skip the small ones or the awkward ones. The whole point is to see everything in one place. Buy-now-pay-later, the $400 medical bill, the loan from a family member — all of it goes on the list.

Step 2: Total it up

Add a =SUM() under your balance column to see the real total owed, and another under the minimums to see how much debt costs you every month before you've made a dent. This number is uncomfortable, which is the point — it's the baseline the rest of the plan beats.

Step 3: Set your extra monthly payment

The minimums keep you afloat; the extra payment is what actually gets you out. Look at your budget and decide how much more you can put toward debt each month — even $100 changes the picture dramatically over time. Put that number in a single cell so the projection can use it.

If you don't know how much you can free up, that's a budgeting problem, not a debt problem. Build a monthly budget first, find the gap, and bring it back here.

Step 4: Choose a payoff order

This is where snowball and avalanche come in (full breakdown below). In short:

• Snowball — order your debts smallest balance to largest. Pay minimums on everything, throw the extra at the smallest, and roll its payment forward when it's gone.
• Avalanche — order your debts highest interest rate to lowest. Same mechanics, but you attack the most expensive debt first.

Set the order field and the tracker projects your debt-free date and total interest for that choice.

Step 5: Track progress weekly

A payoff plan only works if you look at it. Put a recurring 10 minutes on your calendar — payday works well — to update each balance and log your payments. The debt-free date will inch closer, and that visible progress is the thing that keeps most people going when the early months feel slow.

Debt snowball vs avalanche

This is the decision that trips people up, so here's the honest version of both.

The debt snowball

You order debts from smallest balance to largest, ignoring interest rates. You pay the minimum on everything and put every extra dollar toward the smallest debt until it's gone. Then you take that debt's old payment and roll it onto the next-smallest — the payment "snowballs" and gets bigger with each debt you clear.

The advantage is psychological. Clearing a whole debt early feels like a win, and that momentum keeps people in the game. The downside is cost: if a small balance has a low rate while a big balance is at 24% APR, you pay more interest by ignoring the rate.

The debt avalanche

You order debts from highest interest rate to lowest, ignoring balances. Same mechanics — minimums on everything, extra toward the top of the list, roll payments forward as debts clear — but you attack the most expensive debt first.

The advantage is math. Avalanche always pays the least total interest and usually gets you debt-free soonest. The downside is patience: if your highest-rate debt is also your largest, it can take a while before you fully clear anything, and some people lose steam waiting for that first win.

How to choose

The tracker shows you both outcomes for your numbers — the debt-free date and total interest under each method — so the trade-off isn't abstract. If the interest difference is small, take the snowball for the motivation. If avalanche saves a meaningful amount, the discipline pays for itself. And if you're not sure you'll stick with either, start with snowball: the research-backed reason it works is that finishing things keeps people going, and a plan you follow beats a perfect plan you quit.

You can always switch. Change the order field partway through and the tracker recalculates instantly.

Keeping the tracker current (the part that matters)

Here's the uncomfortable truth about every debt payoff tracker: the projection is only as good as the balances behind it. The day those balances go stale, the debt-free date becomes fiction — and once people stop trusting the date, they stop opening the sheet.

Manual updating is the culprit. Logging into five accounts to copy five balances every week is exactly the kind of chore that gets skipped during a busy month, which is when you most need to see the plan.

That's the problem Avery solves. Connect your accounts with a read-only link and Avery:

• Keeps your balances current automatically, so the total owed is always real.
• Imports your payments as they happen, so progress reflects what you've actually paid.
• Keeps the projection live, so the debt-free date is accurate every time you open the sheet.

You go from "look up and type five balances" to "glance at the date and keep going." The tracker stays current, which means you keep using it — and a debt tracker you keep using is the one that gets you out.

For quick answers to specific setup and method questions, see the debt payoff tracker template and the debt payoff tracker Q&A.

Related templates and guides

• Debt Payoff Tracker template — the free Google Sheet this guide is built around.
• Debt payoff tracker Q&A — quick answers to the most common method and tracking questions.
• Monthly Budget template — find the extra money to throw at debt each month.
• Budget Spreadsheet template — a flexible budget to pair with your payoff plan.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• Browse all free templates — the full Avery library.

A debt payoff tracker gives you a plan; automation keeps it honest. Start with the free template, pick a method you'll actually follow, and let Avery keep the balances current so the debt-free date is still true in month six — and closer than ever.