Business Debt Schedule: How to Build One Lenders Accept

A business debt schedule is a one-row-per-loan table of every financed obligation your company owes, and lenders use it to total your existing debt service before deciding whether cash flow supports a new loan. Building one takes about an hour if your loan statements are handy, and the entire exercise comes down to three things: list the right debts, fill the columns exactly, and make the total agree with your balance sheet.

The columns lenders ask for

Published lender schedules vary in layout, and they converge on the same fields. This is the set that satisfies almost every template you will be handed:

Two more columns show up specifically on SBA lender templates. A published SBA lender debt schedule from Business Development Corporation adds a government-loan flag asking whether the debt is an EIDL, PPP, 7(a), 504, or other government loan along with the account number, and instructs applicants to list all government loans the business has received "whether still open or now closed." The other is a refinance marker, where an asterisk indicates any debt the new loan will pay off.

Before you start

What you need: the most recent statement for every business loan, line of credit, equipment lease, and business credit card carrying a balance; your interim balance sheet; and the same information for any affiliate business you control.

Time: roughly one hour for a business with five to ten obligations. The reconciliation in Step 6 is what takes the time, not the typing.

Cost: none. Your lender supplies the template.

Step 1 — Set one "as of" date and pull statements to match

Pick the date of your interim balance sheet and use it for everything. Then pull the loan statement closest to that date for each debt.

Mismatched dates across the file are a routine cause of underwriting delays. Pursuit Lending, an SBA lender, lists mismatched dates on interim financial statements among its top delay triggers, noting that your profit-and-loss statement, balance sheet, AR and AP agings, and debt schedules "need to have the same date or date range" so the lender can evaluate a single period.

Done looks like: every statement in front of you shows a balance as of the same month-end.

Common mistake: pulling the current balance from an online amortization calculator. Use the lender's actual statement, which reflects fee roll-ins, deferred interest, and any payment timing your calculator does not model.

Step 2 — List only financed debt

Include term loans, commercial mortgages, equipment loans, vehicle loans, lines of credit, capital leases, business credit cards carrying a revolving balance, merchant cash advances, and shareholder notes.

Exclude the operating liabilities. The Business Development Corporation schedule states the instruction plainly: the form covers "installment debts, notes, lines of credit and mortgages," and applicants are told to "not include accounts payable or accrued liabilities." Payroll liabilities and sales tax payable come off for the same reason. They are operating obligations that your AP aging and balance sheet already report, and folding them in inflates your apparent debt service.

Two edge cases decide themselves once you know the rule. A line of credit with a zero balance still gets a row showing zero, because the lender wants to see the available facility. A capital lease belongs on the schedule because it is a financing arrangement, while a true operating lease for office space generally does not.

Step 3 — Fill every cell, including the ones that do not apply

Blank cells read as unanswered questions and generate follow-up requests. If a revolving card has no maturity date, write N/A. If a payment is deferred to zero, write 0. Both are answers. An empty box is not.

Note whether each rate is fixed or variable. On a schedule with several variable-rate loans, an underwriter modeling a rate move needs to know which rows are exposed, and supplying that upfront saves a round trip.

Step 4 — Add shareholder debt

If you have loaned money to your own company under a formal note with an expectation of repayment, it goes on the schedule. This is written into SBA policy rather than left to lender preference.

Owners leave these off constantly, usually reasoning that money they lent themselves is not real debt. From the underwriter's side it is a claim on the same cash flow as every other row. If the note will not be repaid until after the SBA loan matures, put it on the schedule and ask your lender about standby treatment.

Done looks like: the schedule includes obligations owed to you and to any related party, each with a real balance and payment.

Step 5 — Build separate schedules for affiliates

If you control other entities, each one generally needs its own schedule. SBA cash flow analysis reaches beyond the applicant to affiliates because their obligations touch the same owners and the same cash. One SBA 7(a) loan application instructs applicants to include the debt schedule for affiliate businesses alongside the operating company's, and to make the balance-due column agree with the note balances on the most recent financial statement provided.

If you own the operating company and a separate entity that holds the real estate, expect to produce two schedules.

Step 6 — Reconcile the total to your balance sheet

This is the step that decides whether your schedule gets accepted, and it is where most first drafts fail.

The SBA's own description of Form 2202, the disaster-program equivalent, captures the standard cleanly: the schedule "is a supplement to your balance sheet and should balance to the liabilities presented on that form."

Your schedule total will usually not match the long-term debt line on your balance sheet, and that is correct accounting. Standard balance sheet presentation splits every term loan across two lines. The principal coming due in the next twelve months sits up in current liabilities as the current portion of long-term debt. The rest sits below in long-term debt. Your debt schedule, by contrast, carries the full remaining principal on a single row per loan.

Term loans are not the only complication. A drawn line of credit and a revolving card balance are usually reported as current liabilities in their own right, separate from the current portion of long-term debt, and both belong on your schedule.

The reliable way to reconcile is to work backward from total liabilities:

Debt schedule total = total liabilities − accounts payable − accrued liabilities − taxes payable − deferred revenue and customer deposits

Whatever remains is financed debt, and that is your target number. If your schedule does not hit it, find the missing row or the stale balance before your lender does.

Common mistake: reconciling to the long-term debt line alone, concluding the numbers are off by roughly one year's principal, and "fixing" the schedule by understating balances.

Step 7 — Run your own coverage ratio before you submit

Total the monthly payment column and multiply by twelve. Subtract the annual payments on any debt the new loan will pay off, which is what the refinance asterisk in Step 2 marks. Then add the annual payment on the loan you are requesting. That figure is your pro-forma debt service, and it is the number the lender divides into your cash flow.

Skipping the subtraction is the common error, and it double-counts refinanced debt. SOP 50 10 8 defines debt service as the future required payments after the transaction closes, so a loan being retired at closing does not belong in the total.

SOP 50 10 8 defines operating cash flow as EBITDA and debt service as future required principal and interest on all business debt including the new SBA loan proceeds. The applicant's ratio must reach 1.15 on a historical or projected basis and 1:1 globally. Effective March 1, 2026, 7(a) Small Loans of $350,000 or less carry a lower floor of 1.10:1, per Starfield & Smith's summary of the procedural notice that also sunset the mandatory SBSS minimum for those loans. Many lenders underwrite to 1.25 regardless, because a deal at the floor has no margin.

Running this yourself changes what you do next. A ratio under the floor is a structural problem that no formatting fixes, and the levers are a smaller request, a longer amortization, or paying off a short-maturity obligation first. Our DSCR calculator will do the arithmetic, and how to calculate DSCR walks through the add-backs. To model the new payment before you add it, the SBA loan calculator covers both 7(a) and 504 structures.

What "done" looks like

Your finished schedule has one row per financed obligation, no blank cells, an "as of" date matching your interim balance sheet, a total that equals your balance sheet liabilities less the operating items, separate schedules for any affiliates, and shareholder notes included. You know your pro-forma DSCR before the lender calculates it.

What to do next

The debt schedule is one document in a larger package, and it has a personal-side counterpart. Your business debts go on the debt schedule; your personal debts go on SBA Form 413, the personal financial statement every owner of 20% or more files. Underwriters read them together, and the contingent liabilities section of the 413 is where a personal guarantee on business debt gets disclosed, which is exactly the kind of cross-document consistency that gets checked.

StatementsReady handles that personal side. It generates the Form 413 and personal financial statement from your synced balances so the personal half of the file is consistent and current, while the debt schedule stays with your bookkeeping.

Next steps worth taking in order:

1. Finish the schedule using the columns above, then reconcile it.
2. Work through the rest of the package with 10 documents needed for a business loan, where the debt schedule is item five.
3. Build the personal financial statement that travels with it. See personal financial statement for a business loan for what lenders check, and the SBA Form 413 template to start from a structured layout.
4. If your obligations need sorting before they go on the schedule, types of liabilities covers the current, long-term, and contingent distinction, and Form 413 Section 5 covers contingent liabilities specifically.

For the full application workflow, see our business loan applications use case. More on this topic is in the business lending archive, and SBA 7(a) loan requirements covers the current rule set.

FAQ

What is a business debt schedule?

A business debt schedule is a table listing every financed obligation the business owes, with one row per loan and columns for the creditor, original date and amount, current balance, interest rate, monthly payment, maturity date, and collateral. Lenders use it to total your existing debt service and calculate whether cash flow covers both the current debt and the new loan you are asking for. It is a supporting schedule to the balance sheet, so the balances on it are expected to agree with the liabilities reported there.

What should you not include on a business debt schedule?

Leave off day-to-day operating liabilities: accounts payable to vendors on 30/60/90-day terms, accrued liabilities such as unpaid utilities or rent, payroll liabilities, and statutory obligations like sales and payroll taxes. Lender forms state this directly. One published SBA lender schedule instructs that the form covers installment debts, notes, lines of credit and mortgages, and to not include accounts payable or accrued liabilities. Those items are tracked on your AP aging report and balance sheet, not on the debt schedule.

Is SBA Form 2202 the same as a business debt schedule?

No, and this trips up a lot of applicants. SBA Form 2202, Schedule of Liabilities, belongs to the disaster loan program. The SBA describes it as provided for responding to filing requirements on SBA Form 5, the Disaster Business Loan application. For a 7(a) or 504 loan there is no single universal SBA-numbered debt schedule form; each participating lender supplies its own template. The information requested is substantially the same, so build the schedule once and re-key it into whatever form your lender sends.

Does the SBA require a business debt schedule for a 7(a) loan?

The requirement sits on the lender rather than directly on you, but it reaches you in practice. SOP 50 10 8 states that to perform a complete analysis of debt service, it is important for a lender to obtain a current debt schedule prepared by the applicant, including any shareholder debt. Because the lender cannot complete the credit memo without it, every SBA borrower with existing business debt ends up preparing one.

Do I include shareholder loans on the debt schedule?

Yes, when a formal note exists and repayment is expected. SOP 50 10 8 specifically directs lenders to obtain a debt schedule that includes any shareholder debt, so omitting a loan you made to your own company creates a gap the underwriter will notice. If the balance will not be repaid until after the SBA loan matures, disclose it on the schedule and ask your lender about standby treatment.

Why doesn't my debt schedule total match my balance sheet?

Usually because of how debt is presented. Standard balance sheet formatting splits each term loan into two lines: the principal due within the next twelve months sits in current liabilities as the current portion of long-term debt, and the remainder sits below in long-term debt. Drawn lines of credit and revolving card balances are reported as current liabilities of their own. Your debt schedule lists the full remaining principal on one row per obligation, so reconcile by starting from total liabilities and subtracting accounts payable, accrued liabilities, taxes payable, and deferred revenue. What remains is financed debt and should equal your schedule total.

What DSCR does an SBA lender need after adding the new loan?

Under SOP 50 10 8, the applicant's debt service coverage ratio, calculated as operating cash flow divided by debt service, must be at least 1.15 on a historical or projected basis and at least 1:1 on a global basis. Operating cash flow is defined as EBITDA, and debt service means future principal and interest on all business debt including the new SBA loan proceeds. Effective March 1, 2026, 7(a) Small Loans of $350,000 or less carry a lower 1.10:1 floor. Many lenders underwrite to 1.25 for cushion.