What a debt book is and why it matters for consolidation
A debt book is a record—on paper, in a spreadsheet, or in an app—where you list every debt you owe, how much, to whom, and what you pay each month. It is not a formal document that creditors require. It is a tool you build for yourself so you can see the full picture of what you owe before you decide whether consolidation makes sense.
When you are considering a consolidation loan, you need to know three things: the total amount you owe across all debts, the interest rates on each one, and how much you are paying monthly right now. A debt book gives you all three at a glance. Without it, you are making a decision based on guesses. With it, you are making a decision based on numbers.
The debt book also becomes your roadmap after consolidation. If you consolidate five debts into one loan, you still need to know what you consolidated and why—especially if something goes wrong with the new loan or if you want to pay it off faster.
Key Takeaways
- A debt book lists every debt you owe, the creditor, the balance, the interest rate, and your monthly payment so you can see the full picture before consolidating.
- You can build a debt book in a spreadsheet, on paper, or using a budgeting app—the format matters less than having the information in one place.
- Comparing the total interest you pay now versus what you would pay under a consolidation loan requires the numbers from your debt book.
- A debt book helps you avoid taking on new debt after consolidation because you can see exactly what you paid off and what remains.
What information goes into a debt book
Start with the basics: the name of the creditor, the type of debt (credit card, car loan, medical bill, personal loan), and the current balance you owe. Then add the interest rate—this is on your statement or you can call and ask. Then add your minimum monthly payment.
If you have multiple cards or accounts with the same creditor, list each one separately. A credit card with a $3,000 balance at 18% and another card with $1,500 at 22% are two different debts, and they behave differently. Lumping them together hides which one is costing you the most.
Add one more column: the date you opened the account or the date you last made a payment. This helps you spot accounts you have forgotten about—a common reason consolidation fails. If you consolidate five debts and then discover a sixth one you forgot, you are back where you started.
| Creditor | Type | Balance | Interest Rate | Monthly Payment | Last Payment Date |
|---|---|---|---|---|---|
| Capital One | Credit Card | $3,200 | 19% | $85 | Jan 2024 |
| Chase | Credit Card | $1,800 | 22% | $50 | Jan 2024 |
| Discover | Personal Loan | $5,000 | 12% | $180 | Jan 2024 |
How to gather the numbers you need
Pull your most recent statement from each creditor. The balance, interest rate, and minimum payment are all on there. If you do not have a recent statement, log into your online account or call the creditor's customer service line. You do not need to explain why you are asking—creditors give this information to anyone who asks.
For credit cards, the interest rate is listed as the APR (annual percentage rate). For loans, it may be called the interest rate or APR. They mean the same thing for your purposes. If you see a range (like "18–24%"), use the rate you are actually paying, which is on your statement.
If you have accounts in collections or accounts you have not paid in months, include them too. These are the debts that hurt your finances the most, and they are the ones consolidation might help with. Do not leave them out because they feel too painful to face.
Using your debt book to compare consolidation scenarios
Once your debt book is complete, you can do the math that matters: what would consolidation actually save you? Take your total balance (add up the "Balance" column) and your total monthly payment (add up the "Monthly Payment" column). Then look at what a consolidation loan would cost.
If a consolidation loan offers you a lower interest rate and a longer repayment period, your monthly payment will drop—but you may pay more in total interest over time. If it offers a lower rate and the same repayment period, you win on both fronts. Your debt book shows you which scenario you are in.
For example: if you owe $10,000 across five debts at an average rate of 18%, paying $250 a month, you are on track to pay roughly $4,000 in interest. A consolidation loan at 12% over the same timeline costs roughly $2,600 in interest—a real saving. But if the consolidation loan stretches the repayment to seven years instead of four, the total interest might be $3,800, which is less saving than it looks.
Keeping your debt book updated after consolidation
After you consolidate, do not throw away your debt book. Update it. Cross out or mark as "consolidated" the debts you paid off with the consolidation loan. Add a new line for the consolidation loan itself, with its balance, interest rate, and monthly payment.
The reason this matters: you need to see what you actually paid off. If you consolidated $10,000 in credit card debt and then run up $3,000 in new charges on those same cards, your debt book will show you that you have not made progress—you have just added to the problem. Many people consolidate and then accumulate new debt without realizing it because they do not track what they consolidated in the first place.
Review your debt book once a month when you pay your bills. It takes five minutes. It keeps you honest about whether consolidation is working the way you planned.
Tools for building and maintaining a debt book
You can use a spreadsheet (Google Sheets or Excel), a notebook, or a budgeting app. The tool does not matter. What matters is that you actually use it and keep it current.
A spreadsheet gives you the most control. You can add columns for notes (like "disputing this charge" or "called to negotiate rate"), sort by interest rate to see which debts cost you the most, and calculate totals automatically. If you are comfortable with spreadsheets, this is the fastest route.
A notebook works if you prefer paper. Write the same columns across the top of a page and update it by hand each month. Some people find this more satisfying and harder to ignore than a digital file.
Budgeting apps like YNAB, Mint, or EveryDollar track your debts as part of a larger budget. If you are already using one of these, your debt information is already there. If you are not, downloading an app just to track debt is probably overkill—a spreadsheet or notebook does the job.
Common mistakes when building a debt book
The first mistake is leaving out debts that feel too shameful or too small to matter. A $200 medical bill in collections and a $50 library fine both affect your finances and your credit. Include everything. The point of a debt book is to see the whole picture, not the parts you are comfortable with.
The second mistake is guessing at interest rates instead of looking them up. You think a credit card is 18%, but it might be 24%. That difference changes whether consolidation makes sense. Spend ten minutes on the phone or online and get the real number.
The third mistake is building the debt book once and never updating it. If you consolidate three debts and then forget to mark them as consolidated, your debt book becomes useless. Set a reminder to update it on the same day each month—the day you pay your bills, for example.
Frequently Asked Questions
Do I have to share my debt book with the consolidation lender?
No. Your debt book is for you. The lender will pull your credit report and ask you to list debts on their process, but they do not need or want your personal spreadsheet. Your debt book is a planning tool, not a document you submit anywhere.
What if I have debts I do not remember opening?
Pull your credit report from AnnualCreditReport.com (the only free official source). It lists every account in your name, including ones you may have forgotten about or ones opened fraudulently. Add all legitimate debts to your book, even if you do not recognize them when ready.
Should I include my mortgage or car loan in my debt book?
Include them if you are considering consolidating them. Most consolidation loans are for unsecured debt (credit cards, personal loans, medical bills), not secured debt (mortgages, car loans). But if you are exploring options, list everything so you see the full picture of what you owe.
How often should I update my debt book?
Once a month, when you pay your bills. It takes five minutes. This keeps you aware of how much progress you are making and catches new debts or changes in interest rates before they become a problem.
Can I use my debt book to negotiate with creditors?
Yes. If you call a creditor to ask for a lower interest rate, having your debt book in front of you shows you are serious and organized. You can say, "I have five debts totaling $12,000. I am consolidating to pay them off faster. Can you lower my rate to keep my business?" Creditors sometimes say yes, especially if you have been paying on time.