Debt Payoff Worksheet: List Every Debt in One Spot

A debt payoff worksheet is one page with seven columns, filled in once for every debt you owe: Debt name, Balance, Interest rate, Minimum payment, Extra payment, Payoff order, and Estimated payoff date. Where a payoff plan tells you which method to use, this worksheet is where the actual numbers live — the page you fill in once and then update every month as balances move.

Here's how a filled-in row looks, using a $2,200 credit card balance at 18% interest with a $65 minimum payment: Balance $2,200, Rate 18%, Minimum $65, Extra $50, Payoff order 1, Estimated payoff roughly 20 months. That last number comes from adding the extra payment to the minimum and dividing the balance by the combined monthly total, then adjusting up slightly for interest that keeps accruing on the remaining balance each month.

List every debt this way, one row per balance, then rank them in the Payoff order column — smallest balance first if you're using snowball, highest rate first if you're using avalanche. The worksheet doesn't pick the method for you; it just gives every debt a place to live so the comparison is actually possible.

The free Clear Desk Money Reset gives you a weekly plan, spending check, and next-step list to put this into practice.

Filling in the interest rate column accurately

Pull the actual rate from your most recent statement, not what you remember signing up for — rates on cards and some loans shift over time, and a worksheet built on an outdated rate throws off every payoff estimate that follows. If a rate is variable, write the current one and note the date you checked it, so you know when it's due for a recheck.

Estimating a payoff date without a calculator

Divide the balance by your total monthly payment — minimum plus extra — and round up. A $2,200 balance with $115 going toward it monthly (that $65 minimum plus $50 extra) takes about 19 to 22 months, the wider range accounting for interest still building on the balance each month. It won't be exact to the day, but it's close enough to plan around, and it gets more accurate every month you update the worksheet with the real balance.

Updating the worksheet as balances change

Once a month, after payments post, write the new balance in a fresh column or a new copy of the worksheet. Watching the balance column shrink across several months is what turns this from a one-time list into a record of real progress — a worksheet filled in once and never touched again is just a snapshot, not a tool.

What happens once a debt hits zero

Cross that row out, don't erase it — a paid-off row is proof the system worked, and seeing it stay on the page is more motivating than making it disappear. Move that debt's minimum and extra payment amount over to whichever debt is next in the payoff order, so the total dollar amount going toward debt each month never actually drops, it just redirects.

Debts that don't fit the standard columns

Some debts — a loan from a family member, a payment plan with no listed interest rate — don't have a clean APR to write down. For these, leave the rate column blank or write "0%" if that's accurate, and rank them by whichever factor matters most to you: getting the loan off your plate, or the relationship attached to it. The worksheet still works; it just runs on a different priority than the interest math for that one row.

Using the worksheet alongside a payoff method

The worksheet is the numbers; snowball versus avalanche is the strategy for using them. Fill in every column first, then decide the payoff order based on whichever method fits how you stay motivated — seeing a balance disappear fast, or minimizing total interest paid. Either way, the worksheet is what makes the comparison possible in the first place.

Rechecking the numbers after a few months

The estimated payoff date in column seven gets more accurate every time you update the worksheet with a real balance, so treat the first version as a rough draft. After three or four months of actual payments, the pace usually looks a little different than the first estimate — sometimes faster, if extra payments have been consistent, sometimes slower if a month or two only covered the minimum.

Printing one worksheet per debt versus one shared page

For two or three debts, a single shared page with one row per debt is easiest to scan. Past four or five, consider a full page per debt instead, since a single crowded row leaves little room to jot notes about rate changes or missed payments. Either format works — the goal is a worksheet you'll actually keep updating, not one that looks impressive but gets abandoned after month one.