What Is a Debt Schedule: Types, Taxes, and Bankruptcy

A debt schedule is a single, organized record of everything you owe, listing each creditor alongside the balance, interest rate, payment amount, and payoff date for every obligation. It functions as a master inventory of your liabilities. Individuals use one to plan repayment and apply for mortgages; businesses use one to monitor loan covenants and calculate coverage ratios; bankruptcy courts require a formal version of it as a sworn filing. The document is only valuable when it is complete and current, so the discipline of building it correctly matters as much as the format you choose.

What Belongs on Each Line

Every entry should carry enough detail that a stranger to your finances could understand the obligation on its own. At minimum, each row needs:

  • Creditor name and account number, matching whatever appears on the statement.
  • Original loan amount at the time of borrowing.
  • Current balance as of the most recent statement.
  • Interest rate, with a note on whether it is fixed or variable; for variable rates, the index and margin.
  • Payment amount and frequency: monthly, quarterly, or otherwise.
  • Maturity date, meaning when the final payment is due.

Secured debts need a description of the collateral. For a mortgage, that means the property address; for a vehicle loan, the year, make, model, and VIN. The value of a secured debt depends on what is backing it, so leaving the collateral off creates problems the moment anyone outside your household looks at the schedule.

Business owners should add a column for personal guarantees. When a principal signs a personal guarantee on a business loan, that individual becomes personally liable if the business cannot pay. Principals are not automatically on the hook for debts of a corporation or LLC absent a separate guarantee.1NCUA Examiner’s Guide. Personal Guarantees Tracking which obligations carry personal exposure is one of the easiest items to overlook and one of the most painful to discover during a downturn.

Types of Debt to Separate

Not every debt behaves the same way, and the categories you use change how you prioritize payments and how outsiders read your position.

Installment Versus Revolving

Installment debt has a fixed number of payments and a defined payoff date. Mortgages, auto loans, and student loans sit here. Revolving debt, like credit cards and lines of credit, has no end date; the balance moves as you borrow and repay, and the minimum shifts with it. Both belong on the schedule, but installment payments are predictable while revolving payments are not, and that distinction matters when you project cash flow.

Secured Versus Unsecured

Secured debts are backed by assets a lender can seize on default. Unsecured debts, including credit cards, medical bills, and most personal loans, have no collateral. Secured creditors are paid first in nearly every scenario involving financial distress, so each entry on your schedule should clearly flag which side of the line it falls on.

Contingent, Unliquidated, and Disputed Obligations

Some debts resist clean categories. A cosigned loan is contingent: liability only arrives if the primary borrower stops paying. An unliquidated debt is one you owe in principle but whose exact dollar amount has not yet been determined, like a pending insurance claim. A disputed debt is one where you and the creditor disagree about whether or how much is owed. These are the easiest items to leave off a schedule because they feel uncertain, which is also why they belong on it. A creditor you forgot about does not forget about you.

Intercompany Loans

Businesses with related entities, or with owner-provided capital, should separately track intercompany loans. A loan from a parent to a subsidiary, or from an owner to the business, remains a liability even though the funds stayed inside the group. The settlement treatment matters: if a parent forgives the loan, it is typically treated as an equity contribution rather than debt repayment, which reshapes the balance sheet.

Where to Pull the Numbers From

The biggest risk in building a schedule is leaving something out. Start with every document that touches a debt, then cross-check.

Loan agreements and promissory notes carry the legal terms: interest rate, payment schedule, late-fee structure, whether interest compounds, and what counts as default. Recent billing statements provide the current balance and minimum payment, but the statement balance and the actual payoff amount usually differ. Payoff figures include daily interest accruing between your last payment and the date you would clear the account, so request a formal payoff quote from the lender when precision matters.

Amortization tables split each payment into principal and interest, showing how much of each dollar actually reduces the balance. Early in a loan, most of each payment is interest; on a 30-year mortgage, the shift toward principal does not become meaningful until years into repayment.

Your credit reports are the safety net. You can pull a free credit report from each of the three major reporting agencies at AnnualCreditReport.com.2Consumer Financial Protection Bureau. How Do I Get a Free Copy of My Credit Reports Pulling all three catches debts you may have overlooked: an old medical bill in collections, a dormant store credit card, or a balance you thought was paid off and was not. Anything on the credit report that is missing from your schedule is a gap worth investigating.

Assembling and Sorting the Schedule

Once the documents are in front of you, the build is straightforward. A spreadsheet handles most situations, with one row per debt and one column per data point. Businesses with dozens of obligations may want dedicated accounting software that pulls directly from bank feeds.

How you sort depends on the purpose. By maturity date, the schedule tells you what is coming due soonest, which helps with cash-flow planning. By interest rate, it tells you where extra payments earn the biggest return. Neither order is wrong; pick one and keep it consistent. Add a totals row that sums current balances and monthly payments. The monthly-payment total is the figure lenders focus on, because it feeds the ratios they use to decide whether to approve new credit.

Flagging Balloon Payments

If any debt carries a large lump-sum payment at maturity, highlight it. Federal lending regulations define a balloon payment as one that exceeds twice the amount of any regular periodic payment during the loan term.3Consumer Financial Protection Bureau. Supplement I to Part 1026 – Official Interpretations A $200,000 balloon due in three years can look manageable on a schedule and still trigger a liquidity crisis if nothing has been set aside. Mark it, note the year, and plan to refinance or accumulate the cash well in advance.

Keeping It Current

A six-month-old debt schedule is worse than no schedule, because it creates false confidence. Reconcile against bank and lender statements at least monthly. Balances fall when you pay and rise when interest accrues; refinancings remove old entries and replace them with new terms.

Events that should trigger an immediate update include refinancing, taking on new debt, paying off a balance, having a credit limit changed, and settling a disputed amount. For a business, add new intercompany loans and guarantees as they arise. The goal is a document you could hand to a lender or accountant at any moment and have it be accurate within a billing cycle.

What Lenders Do With It

A debt schedule is also raw material for the ratios that decide whether you get approved for new borrowing.

Debt-to-Income Ratio for Individuals

When you apply for a mortgage, the lender divides your total monthly debt payments by your gross monthly income to produce your DTI. Most conventional mortgage lenders look for a back-end DTI, which captures all monthly debts rather than only housing, at or below 36%, and many will stretch to 43% for otherwise strong applicants. Your schedule supplies the numerator. Building it before you apply lets you see where you stand and which balances to pay down first.

Debt Service Coverage Ratio for Businesses

The business equivalent is the debt service coverage ratio, or DSCR. The formula divides earnings before interest, taxes, depreciation, and amortization by total annual debt service, meaning principal plus interest for the year. A DSCR of 1.0 means earnings cover payments with nothing left; most commercial lenders require at least 1.20, and many prefer 1.25 or higher. The schedule provides the denominator, and you cannot run the ratio without knowing exactly how much principal and interest comes due across every obligation.

Covenant Compliance

Many commercial loan agreements include financial covenants, such as a maximum debt-to-EBITDA ratio. Breaching a covenant while remaining current on payments is a technical default, and consequences range from the lender demanding concessions to accelerating the full balance. Tracking the ratios on your schedule alongside the balances is how you catch a breach before it happens rather than after.

Tax Events Driven by Your Debt

Several tax rules are triggered by changes to your debts, and missing them can produce an unexpected bill.

Canceled Debt as Taxable Income

When a creditor forgives $600 or more, they must report the cancellation to the IRS on Form 1099-C.4Internal Revenue Service. About Form 1099-C, Cancellation of Debt The forgiven amount is generally treated as taxable income.5Internal Revenue Service. Publication 4681 (2025), Canceled Debts, Foreclosures, Repossessions, and Abandonments This catches people off guard. Negotiating a $15,000 credit card balance down to $9,000 feels like a win until the tax bill arrives on the $6,000 difference.

There are exclusions. Debt discharged in bankruptcy is not included in income. If you were insolvent immediately before the cancellation, meaning total liabilities exceeded the fair market value of total assets, you can exclude the canceled amount up to the extent of your insolvency.6Office of the Law Revision Counsel. 26 U.S. Code 108 – Income From Discharge of Indebtedness A thorough debt schedule makes that insolvency math straightforward because every liability is already in one place. One boundary: the exclusion for canceled mortgage debt on a principal residence expired at the end of 2025, so settlements on underwater mortgages in 2026 no longer qualify.5Internal Revenue Service. Publication 4681 (2025), Canceled Debts, Foreclosures, Repossessions, and Abandonments

Business Interest Deduction Limits

Businesses cannot deduct unlimited interest. The deduction is generally capped at 30% of adjusted taxable income for the year. For tax years beginning after December 31, 2024, the ATI calculation again adds back depreciation, amortization, and depletion, which makes the limit somewhat more generous than it had been.7Internal Revenue Service. Questions and Answers About the Limitation on the Deduction for Business Interest Expense A schedule that totals annual interest expense lets you see whether you are approaching the cap before year-end, while there is still time to plan around it.

If You File for Bankruptcy

In bankruptcy, the debt schedule stops being a voluntary planning tool. Federal law requires every debtor to file a list of creditors, a schedule of assets and liabilities, and a statement of financial affairs.8Office of the Law Revision Counsel. 11 U.S. Code 521 – Debtors Duties The court uses those filings to notify creditors and determine how claims are handled.

How the Court Categorizes Your Debts

Secured debts go on Schedule D.9U.S. Courts. Schedule D: Creditors Who Hold Claims Secured By Property (Individuals) Unsecured debts go on Schedule E/F, which splits them into priority and general tiers.10U.S. Courts. Schedule E/F: Creditors Who Have Unsecured Claims (Individuals) Priority unsecured claims are paid before general unsecured claims and include domestic support obligations such as child support and alimony, certain tax debts, and employee wage claims.11Office of the Law Revision Counsel. 11 U.S. Code 507 – Priorities General unsecured claims, including credit cards, medical bills, and personal loans, fill the remainder and often receive only partial payment or nothing at all.

Each creditor entry needs their name, mailing address, account number, the date the debt was incurred, the nature of the claim, and the amount. Creditors must receive formal notice of the case to satisfy due process, and known creditors who do not receive actual notice may be able to argue their debts survive the discharge.12United States Department of Justice Archives. Civil Resource Manual 64 – Creditors Claims in Bankruptcy Proceedings Leaving a creditor off your schedules does not eliminate the debt and can make it harder to discharge.

Criminal Penalties for False Filings

Bankruptcy schedules are signed under penalty of perjury. Knowingly concealing assets, making a false oath, or filing a fraudulent claim in a bankruptcy case is a federal crime punishable by up to five years in prison.13Office of the Law Revision Counsel. 18 U.S. Code 152 – Concealment of Assets, False Oaths and Claims, Bribery The standard is “knowingly and fraudulently,” so honest mistakes do not typically draw prosecution. But a carelessly assembled schedule can make an honest omission look intentional. If bankruptcy is on the horizon, the time to build an accurate schedule is well before the filing, not during a rushed weekend before the court deadline.