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, what you owe on each one, and the terms. It serves as your single source of truth when you are deciding whether consolidation makes sense, comparing loan offers, or straightforward trying to understand your total debt picture before taking action.
If you arrived here from consolidation loans, you already know the basic idea: rolling multiple debts into one payment can lower your interest rate or monthly payment. A debt book is the tool that tells you whether consolidation will actually save you money. Without one, you are making that decision blind.
Most people with multiple debts—credit cards, personal loans, medical bills, car loans—have never written down the full list in one place. They know they owe money, but they do not know the exact total, which debts charge the highest interest, or how long it will take to pay everything off. A debt book fixes that.
Key Takeaways
- A debt book lists every debt you owe, the balance, interest rate, and monthly payment so you can see your full picture at a glance.
- You need this information before you shop for a consolidation loan, because you have to know your total debt and which debts cost you the most in interest.
- A debt book also shows you whether consolidation will actually lower your monthly payment or total interest paid, or just move money around.
- You can keep a debt book on paper, in a spreadsheet, or in a budgeting app—the format matters less than keeping it current.
- Once you consolidate, your debt book becomes a tracking tool to make sure the new loan is performing as promised.
What information goes into a debt book
Start with the basics: the name of each creditor, the current balance, the interest rate (APR), and the minimum monthly payment. If you have a credit card, you need the card name, the balance, the APR, and the minimum payment. If you have a car loan, you need the lender name, the remaining balance, the interest rate, and the monthly payment. Do the same for every debt.
Add a column for the payoff date if you know it—for example, a car loan that ends in 36 months, or a credit card with a promotional 0% APR that expires in 12 months. Add a column for the total interest you will pay if you make only minimum payments. This number is often shocking and is usually the reason people decide to consolidate in the first place.
If you are tracking multiple debts over time, add a date column so you can see how the balances change month to month. This is optional for a first pass, but it becomes useful once you start paying down debt or comparing consolidation offers.
How to build a debt book from scratch
Gather your statements. Pull out your most recent credit card statements, loan documents, medical bill notices, and any other debt paperwork. You need the current balance and interest rate for each one. If you do not have a statement, call the creditor and ask for the balance and APR.
Create a straightforward table with columns: Creditor Name, Current Balance, Interest Rate (APR), Monthly Payment, Payoff Date (if known), and Total Interest Paid (if you can calculate it). Enter each debt on its own row. Add them up. That total is your consolidated debt picture.
If you use a spreadsheet, you can use formulas to calculate total interest. If you use paper, a calculator works fine. The goal is not perfection; it is accuracy. Once you have the list, you can start comparing consolidation offers against it.
Using a debt book to evaluate consolidation offers
When you receive a consolidation loan offer, add it to your debt book as a new row. Enter the loan amount (which should equal your total current debt), the interest rate the lender is offering, the monthly payment, and the loan term. Then calculate what you will pay in total interest over the life of that loan.
Compare that number to what you are currently paying in total interest across all your separate debts. If the consolidation loan costs less in total interest, consolidation saves you money. If it costs more, you are paying for convenience, not savings. Both are valid choices, but you should know which one you are making.
Your debt book also shows you which debts are costing you the most. If you have a credit card at 24% APR and a personal loan at 8%, the credit card is your priority. A consolidation loan that rolls both into a single 12% loan saves you money on the card but costs you more on the loan. Your debt book makes that trade-off visible.
Debt book formats: paper, spreadsheet, or app
Paper works. A single page with your debts listed, balances, and interest rates is enough to start. You can update it by hand each month. The downside is that you have to do the math yourself and you have to remember to update it.
A spreadsheet (Google Sheets, Excel) lets you build formulas that calculate totals and interest automatically. You can sort by interest rate to see which debts cost you the most. You can duplicate the sheet each month to track progress. Most people find this the best balance between simplicity and power.
Budgeting apps like YNAB, EveryDollar, or Mint include debt tracking built in. They sync with your bank and credit card accounts, so balances update automatically. The downside is that they cost money and they require you to connect your accounts. For a straightforward debt book, a spreadsheet is usually enough.
Keeping your debt book current
Update your debt book once a month, ideally when your statements arrive. Change the balance, note any interest rate changes, and update the payoff date if it has shifted. If you made extra payments, note that. If you opened a new credit card or took out a new loan, add it to the list.
A debt book that is three months out of date is almost useless. You will make decisions based on wrong numbers. Set a calendar reminder for the same day each month—the day your credit card statement arrives, for example—and spend five minutes updating the sheet. That five minutes will save you hundreds of dollars in bad consolidation decisions.
Once you consolidate and close your old debts, keep the old debt book. It becomes your before picture. Create a new sheet for your consolidated loan and any remaining debts. Compare the two every six months to make sure the consolidation is performing as promised.
Common mistakes when building a debt book
The biggest mistake is forgetting debts. People remember their credit cards and car loans but forget medical bills in collections, payday loans, or money they borrowed from family. If you are consolidating, you need to know about all of it. Check your credit report (you can get a free one at annualcreditreport.com) to see if there are debts you forgot about.
The second mistake is using the wrong interest rate. Some people use the promotional rate on a credit card instead of the regular APR. Some use the rate they think they have instead of the rate on their statement. Use the number on your most recent statement, not the number you remember.
The third mistake is not including fees. Some loans have origination fees, prepayment penalties, or annual fees. These are real costs. If a consolidation loan has a $500 origination fee, that fee should be part of your total cost calculation. Add a Fees column to your debt book if you have them.
Frequently Asked Questions
Do I need a debt book if I only have one or two debts?
If you have only one debt, you do not need a book—you already know what you owe. If you have two debts and are considering consolidation, a debt book is still useful because it forces you to write down the exact numbers and calculate whether consolidation actually saves money. It takes five minutes and prevents a costly mistake.
What if my interest rates or balances change between when I create the book and when I explore for a consolidation loan?
Update your debt book right before you explore. Lenders will pull your credit report and see your current balances anyway, so your process will be based on current numbers. If your balances have dropped significantly, recalculate whether consolidation still makes sense—you may have paid down enough that consolidation is no longer worth it.
Should I include my mortgage in my debt book?
Only if you are considering consolidating your mortgage into another loan, which is rare. Most debt consolidation focuses on unsecured debts like credit cards and personal loans. If you are just tracking all your debts to understand your financial picture, include it, but do not expect a consolidation loan to cover it.
Can I use my debt book to negotiate with creditors?
Your debt book shows you what you owe and what it costs you, but creditors are not interested in that information. If you want to negotiate a lower interest rate or payment, you will need to contact the creditor directly and make your case. Your debt book is a tool for you to understand your situation, not a document to show them.
What happens to my debt book after I consolidate?
Keep it. Archive the old version so you have a record of what you owed before consolidation. Create a new sheet with your consolidation loan and any debts you did not consolidate. Use the new sheet to track your progress. After a few months, compare the new sheet to the old one to confirm that consolidation is saving you money as promised.