Getting Started

How to Write Down All Your Debt: A Complete Worksheet Guide

Most people with debt have never added it all up in one place. Not because they can't — because it feels safer not to. This guide walks you through exactly how to build your debt inventory, and why doing it changes everything.

Why most people avoid this — and why you shouldn't

There's a specific kind of avoidance that comes with debt: not opening statements, not logging into accounts, estimating rather than knowing. It's not laziness. It's a protective mechanism. If you don't know the full number, you don't have to fully feel it.

The problem is that avoidance keeps the debt invisible — and invisible debt behaves like it's growing (because often it is, with interest accruing daily). The moment you write it all down, it becomes a fixed, known problem instead of a vague ongoing dread. Fixed problems are solvable. Vague dread is not.

Research consistently shows that people who write down their financial goals and debts are significantly more likely to take action and make progress than those who keep the information only in their heads.

Every type of debt to include

A complete debt worksheet captures every liability — not just the obvious ones. Use this list to make sure nothing is missed:

Credit cards
Include store cards and retail accounts. Check for multiple cards on the same account.
Personal loans
Bank loans, credit union loans, and online lender loans. Check whether the rate is fixed or variable.
Medical debt
Often overlooked. Check your credit report — many medical debts in collections appear there first.
Buy Now Pay Later
Klarna, Afterpay, Affirm balances. These are real debt and often deferred-interest, not zero-interest.
Student loans
Federal and private separately. Log each loan individually — they often have different rates and terms.
Payday loans
Highest-priority debt due to extreme APRs. Often not on credit reports but still need to be resolved.
Overdrafts
Bank overdraft balances and overdraft credit lines. Include any fees already charged.
Informal debts
Money owed to family or friends. These belong on the list — they carry their own emotional weight.

What to record for each debt

For every account, you need five data points to make strategic decisions:

Debt inventory columns
CreditorBalance ($)APR (%)Min paymentAccount status
Chase Sapphire$4,20024.99%$84Current
Discover it$1,75019.74%$35Current
Medical – City$8900%$45Payment plan

The account status column matters: "current," "past due," "in collections," or "charged off" all require different next steps. A debt in collections, for example, needs a different strategy than a current credit card balance.

Step-by-step: how to build your worksheet in 20 minutes

Step 1
Pull your free credit report
Go to AnnualCreditReport.com — the only federally authorized free credit report site — and download reports from all three bureaus (Equifax, Experian, TransUnion). This is your master list of every account a lender has reported. It catches debts you may have forgotten or not received statements for.
Step 2
Log into every account
For each account on your credit report (and any not on it), log in and record the current balance, interest rate, and minimum payment. Do this in a single sitting if you can — momentum matters here. Don't skip accounts because the number feels bad.
Step 3
Add debts not on the credit report
Informal debts, payday loans, some medical debts, and overdrafts often don't appear on credit reports. Add these manually. The worksheet only works if it's complete.
Step 4
Calculate your total
Add everything up. This number — the real number — is the one most people have been avoiding. Writing it down is the moment the debt changes from a feeling into a problem with a size. Problems with a size can be solved.
Step 5
Sort by interest rate
Re-order your list from highest APR to lowest. This is your priority order — the mathematically optimal sequence for paying off debt and minimizing total interest. The highest-rate debt costs you the most every day it exists.

What to do once you have the full picture

Once your inventory is complete, three things become immediately clear: which debt is costing you the most per month, what your total minimum payment obligation is, and whether there are any accounts in a dangerous status (late, in collections, or about to be charged off) that need immediate attention.

Accounts that are current but high-rate are candidates for interest rate reduction calls — a straightforward ask many people never make. Accounts already in collections have different options, including settlement. Knowing the status of each account is what makes a plan possible.

One number to focus on first: Your total minimum payment. This is the floor of what you owe every month regardless of what else happens. Knowing this number — clearly, exactly — is a fundamental shift in financial clarity.

Common mistakes when building a debt worksheet

Skip the blank page — get a structured worksheet that does the thinking for you

The Debt Confessional Worksheet is a fillable PDF designed specifically for this process — every field you need, in the right order, with prompts that help you find every account and calculate your real total.

Get the worksheet — $9 →
Instant PDF download · Fillable on any device · 7-day refund