Business Debt Schedule: What Lenders Look For

A business debt schedule is a single list of every loan, lease, line of credit and note a company owes, with the creditor, original amount, current balance, interest rate, monthly payment, collateral and maturity for each one. Lenders use it to see the full weight of existing obligations, confirm the borrower can absorb a new payment, and check that what shows on the statements and tax returns actually matches what the borrower says it owes. A clean, accurate schedule speeds a credit decision; a vague or inconsistent one stalls it.

This guide is written for commercial underwriters, credit analysts and funders. It covers what belongs on a debt schedule, the exact fields lenders read, how the schedule feeds debt service coverage, and where it fits in an SBA file.

What is a business debt schedule?

A business debt schedule is a financial summary that lists all of a company's outstanding debts in one place so a lender can see total repayment obligations at a glance. For each debt it shows the type of obligation, the creditor, the original loan amount and date, the present balance, the interest rate, the monthly payment, the collateral securing it, and the maturity date. It is not the same as a balance sheet: the balance sheet shows debt as totals, while the schedule breaks each obligation into its terms so the lender can model cash flow and refinancing risk.

What is included in a business debt schedule?

A business debt schedule includes business loans and notes only: term loans, lines of credit, commercial mortgages, equipment leases, vehicle loans, SBA loans and any other contractual debt the company pays on a schedule. For each line, lenders expect the creditor name, original amount and date, current balance, interest rate, monthly payment, collateral, and maturity date. Personal debt of the owner usually sits on a separate personal financial statement, not the business schedule, unless the analysis is global.

The fields a lender reads on every line:

What do lenders look for in a business debt schedule?

Lenders look first at total monthly debt service, then at the composition and timing of the debt. The headline test is the debt service coverage ratio: most commercial lenders want cash flow of at least 1.25 times total debt payments, including the loan being requested. Beyond that ratio, underwriters read three things from the schedule.

First, debt composition. Secured debt backed by real assets carries less risk than unsecured balances and stacked short-term advances. A schedule full of high-cost merchant cash advances signals cash pressure even if the ratio still pencils. Second, maturity timing. A balloon payment due in 18 months creates refinancing risk the lender inherits, so near-term maturities get scrutiny. Third, consistency. The balances and payments on the schedule have to reconcile to the tax returns, the bank statements and the balance sheet. Mismatches between those three documents are one of the most common causes of underwriting delays.

How does a debt schedule affect underwriting?

The debt schedule sets the denominator of the repayment math. Underwriters add every monthly payment on the schedule to the proposed new payment, then divide cash flow available for debt service by that total to get the global or business DSCR. If the schedule is missing obligations that turn up later in the bank statements, the real ratio is worse than the file shows, and the loan can be mispriced or wrongly approved. That is why analysts cross-check recurring debits in the statements against the listed payments instead of taking the schedule at face value.

Is a business debt schedule required for an SBA loan?

Yes. A business debt schedule is standard documentation for SBA 7(a) and most commercial loan files, and SBA lenders typically also collect Form 2202, the Schedule of Liabilities, for the same purpose. The schedule should list business notes and loans only, with the original amount, monthly payment, interest rate, present balance, maturity and collateral for each, and lenders usually ask for a copy of the note and a recent statement to verify the balance. Incomplete schedules are a frequent reason SBA files get returned for more information.

Business debt schedule vs balance sheet: what is the difference?

A balance sheet reports debt as summary totals at a single point in time, while a business debt schedule breaks each obligation into its terms so the lender can model payments and timing. The balance sheet tells you the company owes, say, 1.2 million dollars in long-term debt; the schedule tells you which six loans make up that figure, what each one costs per month, and when each matures. Underwriters need both: the balance sheet to confirm the totals tie out, and the schedule to calculate debt service and spot refinancing risk.

How do you create a business debt schedule?

Build it as one row per obligation with a column for each field a lender reads. Pull the loan type and creditor from the note, the original amount and date from the loan agreement, and the current balance, rate and payment from the most recent lender statement. Add the collateral and maturity, then total the monthly payment column, since that total is the figure underwriting will use. The fastest way to keep it accurate is to reconcile each listed payment against the recurring debits on the borrower's bank statements so nothing is missed or understated.

How automated analysis builds the schedule for you

Reconciling a debt schedule by hand means reading months of statements line by line to confirm every payment. Lessors run the same check on every full-package deal, which is why equipment finance underwriting software reconciles the recurring debits against the schedule automatically. LenderAnalyzer extracts every transaction from uploaded statements and surfaces recurring debt payments, existing advances and signs of loan stacking automatically, so analysts can match the borrower's stated schedule against what the account actually pays. It also computes cash flow, average daily balance and DSCR inputs, which feeds the same repayment math the schedule supports. The result is a faster, better-documented credit decision, with the converter at the top of this page handling the extraction in minutes.

For teams standardizing this work, our financial spreading software and loan underwriting software pages show how the debt schedule fits the wider spread, and the global cash flow analysis guide covers debt that spans the business and its guarantor.

The bottom line for lenders

A business debt schedule is only as useful as it is accurate. Read every line for payment, collateral and maturity, run total debt service through DSCR with the new loan included, and reconcile the listed payments to the bank statements before you trust the ratio. The schedule that ties cleanly to the statements and tax returns is the one that moves a file to approval; the one that does not is where the real risk usually hides. Many borrowers track equipment leases and contractual debts in spreadsheets, so if you are exporting statement data to verify those payments, a bank statement to Excel converter helps, lease obligations on the schedule can be confirmed against the underlying contracts with lease abstraction software, and once a deal is approved the note and loan agreement can be executed with online document e-signing.