A repayment plan needs a reliable starting list. That list can be surprisingly difficult to assemble when statements arrive on different days, a loan has changed servicers, or the same obligation appears in several places.
A debt inventory is a dated record of what you know, with uncertainties kept visible. It is not a demand to solve every debt in one sitting. Start by gathering information, then separate the work of verifying it from the later decision about repayment priorities.
This guide uses a household worksheet and US consumer resources. Questions about legal responsibility, disputed collections or court documents need appropriate individual advice; a spreadsheet cannot settle them.
Choose a snapshot date and a private storage location
Put “information assembled on” at the top of the worksheet. Also keep a separate balance date for each row. An inventory assembled on Thursday may contain a card statement from Monday and a loan balance checked on Wednesday. Those dates explain later differences.
Store the worksheet somewhere with access limited to the people who need it. Use account nicknames and, if necessary, a short identifier to distinguish similar accounts. There is usually no need for a full account number, password or identity document inside the working table.
Keep supporting statements in a separate folder. Give each file a plain name such as “car-loan-September-statement.” The worksheet can refer to that name without copying sensitive details into every version you share.
Gather records without treating any one list as complete
The CFPB’s debt log tool suggests using bills, statements and credit reports to build an overview. It distinguishes the amount still owed from the payment amount and includes obligations beyond standard loans, such as money borrowed from family.
Use that as a prompt to check the places where your own records live. Look through current lender portals, recent correspondence, your payment calendar and personal agreements. A bank withdrawal can remind you that an account exists, but the withdrawal itself does not establish its remaining balance.
Create an “information needed” list as you go. If you cannot find a current statement, write that down rather than substituting a remembered number. Unknown is more useful than a confident-looking estimate that later drives the wrong calculation.
Give balances and payments different columns
Use one row per distinct obligation. A manageable starting table has these fields:
| Field | What to record |
|---|---|
| Account nickname | A label you can recognize |
| Record source | Statement or portal used |
| Balance and balance date | Amount shown and when it applied |
| Required payment and due date | Current requirement from the account record |
| Rate or terms note | Verified detail, or “needs checking” |
| Status | Current, follow-up needed, or uncertain |
| Next action | One specific verification task |
The balance answers “How much remains on this record?” The payment answers “What is currently required?” Adding the monthly payment to the balance would generally count part of the obligation twice. Likewise, a monthly payment is not a reliable way to infer the remaining balance.
If a displayed balance is not a payoff quote, label it accordingly. Do not promise yourself that sending that exact figure will close the account without checking the lender’s requirements.
Reconcile duplicate records before adding totals
Here is a fictional example. Your folder contains a card statement showing $1,200 and a more recent portal printout showing $1,050 after a $150 payment. These are two records for one card, not debts totaling $2,250.
Keep one account row. Record the newer balance and its date, and retain the older statement as supporting history. Add a note that the difference is explained by the posted payment, assuming no other activity in this simplified example.
A servicer change requires more care. Two company names do not automatically mean two loans, but similar amounts do not prove they are the same loan either. Match the account history and transfer correspondence through a verified channel. Until you can reconcile them, flag the possible duplicate and keep it out of a supposedly definitive total.
Write an unresolved-items count next to any subtotal. “Verified balances: $8,400; two records awaiting reconciliation” communicates more than an unexplained grand total.
Separate ordinary bills from amounts already owed
Your next electricity bill belongs in a spending plan. An unpaid electricity balance from an earlier period may also belong in the debt inventory. The distinction is the recorded obligation, not simply whether the payee is a lender.
Avoid turning every future household expense into debt. For example, an estimated year of groceries is a budget forecast, not a current balance owed. Conversely, do not omit a personal loan just because it does not arrive on a formal monthly statement.
When a payment combines ongoing service charges with an overdue amount, keep a note explaining the components. That prevents the same amount appearing once as a bill and again as a separate repayment when you later build your cash-flow plan.
Put unfamiliar or disputed items in a review section
Do not mix an unrecognized demand into the verified list as though you have accepted responsibility. Record where it came from, when you received it and what needs checking. Keep copies of correspondence and any stated response dates.
Use contact details you independently verify when checking an unfamiliar message. Do not send sensitive information simply because a message contains an amount resembling one in your worksheet. If the issue concerns legal responsibility, an old collection, identity misuse or a formal notice, obtain suitable help before deciding what to say or pay.
The inventory should preserve uncertainty. Labels such as “unrecognized,” “possible duplicate” and “responsibility not established” are useful working notes. They are not legal conclusions, and they do not extend any deadline that may apply.
Check the arithmetic with a small sample first
Suppose your verified rows contain a $900 card balance, a $3,600 loan balance and $250 borrowed from a relative. The verified balance subtotal is $4,750. If their current agreed or required payments are $45, $180 and $25, the payment subtotal is $250.
Those totals describe different things. The $250 is not an extra debt to add to $4,750. Nor does dividing $4,750 by $250 produce a reliable payoff schedule: future interest, fees, changing requirements and payment timing are absent from that simple division.
Check your spreadsheet formulas against this kind of hand calculation before trusting a longer sheet. Then check that totals exclude headings, example rows and items marked unresolved. A worksheet template should never leave demonstration numbers inside your personal total.
Use the inventory to choose the next conversation
Once the list is reliable, review the obligations and your available cash together. The balance size alone does not determine urgency. Our guide to choosing which debt to address when everything feels urgent provides a starting point for that broader review.
If the immediate payments fit your budget, you can compare debt avalanche and debt snowball approaches. If they do not, focus on the shortfall and available support before assigning ambitious extra payments. See the discussion of managing when only minimum payments seem affordable.
Bring the worksheet and source records to any advice appointment. A clear list can make the conversation more productive, while leaving the adviser room to check assumptions and explain options that depend on your circumstances.
Maintain a dated record instead of rebuilding everything
At your next review, update each row from its source and preserve the previous snapshot. Record payments after they post, and explain unexpected changes instead of silently overwriting them. A balance increase might need investigation even if a payment was made.
Choose a review routine you can maintain, such as checking the list alongside monthly statements. Between reviews, add new correspondence to the follow-up folder. The result should be a usable record of known balances, current payment requirements and unresolved questions—not a perfect-looking total built from uncertain inputs.