
A business debt schedule is a current inventory of financing obligations, showing who owes the money, the balance, payment requirements, maturity, and supporting collateral or guarantees. It helps connect financial statements with the actual cash committed to repayment. Include obligations with daily or weekly payments and identify contingent guarantees separately. Reconcile the schedule to statements and agreements instead of relying only on the loan balances visible in accounting software.
What to know before you start
- Use one clear reporting date and identify balances that are estimates.
- Convert payment frequency for comparison, then retain actual dates in the cash forecast.
- Distinguish principal, payoff amounts, credit limits, and remaining payment totals.
Decide which obligations belong in the schedule
List term loans, revolving credit, equipment obligations, seller financing, business credit balances, and other arrangements that require future cash payments. Ask the financing team how it wants leases, sales-based financing, related-party obligations, and guarantees presented. A product’s marketing name should not cause it to disappear from the business’s repayment picture.
SBA’s financial-terms glossary describes a schedule of liabilities using creditor, amount, dates, balance, payment, status, and security information. Build from that structure, then add the details needed for your particular obligations. Keep a separate section for contingent guarantees so readers can distinguish a potential obligation from a payment currently made by this business.
Identify the legal borrower for each item. If several related companies share ownership, do not merge their balances without showing which entity is liable and which cash account makes the payments.
Capture information that explains both balance and timing
Create one row per agreement, with additional rows when separate draws have different payment schedules. Record the reporting date and source document. For a revolving facility, show the limit, principal outstanding, and current availability as separate fields. An unused commitment is not a current principal balance.
Distinguish the principal balance from a dated payoff quote. Payoff may include accrued interest or other charges, while a sum of remaining installments may include future interest. Label the amount accurately rather than placing all three figures in a column called debt.
- Creditor, legal borrower, agreement identifier, and original funding date.
- Original amount or commitment, current principal, and reporting date.
- Required payment amount, frequency, next due date, and variable-payment rules.
- Maturity, amortization, balloon, and any renewal or extension provisions.
- Collateral, lien information, guarantors, and relevant consent requirements.
- Payment status, payoff source, and unresolved questions.
Reconcile payment frequency with the cash forecast
Hypothetical example: a company has a $2,100 monthly term-loan payment, a currently required $600 monthly line payment, a $900 monthly equipment payment, and a $350 weekly obligation. These are invented payment amounts, not quoted financing terms. The weekly obligation averages $1,516.67 per month using 52 weeks divided by 12 months.
The combined monthly average is approximately $5,116.67. A month containing five weekly payments instead requires $5,350 across the listed obligations: $2,100 plus $600 plus $900 plus $1,750. Using four weeks for every month would understate annual payments on the weekly obligation.
Keep the actual payment dates in the forecast. Monthly averages help compare the overall burden, but a concentrated week can create a shortage even when the average seems affordable. Update variable payments using the agreement and current balance rather than copying the previous month indefinitely.
| Obligation | Illustrative payment | Timing |
|---|---|---|
| Term loan | $2,100 | Monthly |
| Revolving line | $600 currently required | Monthly; future amount may change |
| Equipment obligation | $900 | Monthly |
| Additional financing | $350 | Weekly; 52 assumed payments annually |
Reconcile balances and identify upcoming events
Compare the schedule with the general ledger, lender statements, bank withdrawals, and agreements. Trace unexplained payments to their purpose. Ask your bookkeeper or accountant to help separate principal and interest when the records combine them. Explain differences caused by payment dates or reporting periods.
Add an event calendar for balloons, rate resets, renewal reviews, payoff penalties, and required reporting. A facility with a manageable current payment may still have a large amount due later. Show that event in the cash forecast rather than treating the recurring payment as the full obligation.
For guarantees of another entity’s debt, record the underlying borrower and available supporting documents without automatically adding the entire debt to current monthly payments. The financing team can determine how it treats the exposure. Disclose the relationship rather than making an unsupported underwriting adjustment yourself.
Use the schedule when discussing new financing
Place the proposed obligation beside the current ones and project the combined payment calendar. For a refinance, identify which debts would actually be repaid and which remain. Do not remove a payment merely because you hope to refinance it; use a separate proposed scenario until the transaction occurs.
Keep updated statements and payoff information available through the appropriate secure process. A general inquiry should describe the business need without exposing full account numbers. The detailed schedule can follow when requested.
Bring your debt schedule, cash forecast, and intended use of funds to a capital review with The Mortgage Calculator team. Clear balances and payment timing help the discussion focus on the business’s actual obligations and the purpose of the new request.
Common questions
Should an unused line be listed?
Yes, identify the commitment and show the outstanding principal separately. Existing collateral, fees, guarantees, or restrictions may still matter even when no principal is currently borrowed.
Is a loan statement enough to establish the payoff amount?
Not necessarily. A payoff depends on the date and applicable charges. Obtain the required dated payoff information for an actual closing rather than assuming the statement principal is the full amount due.
Should I omit a loan that the owner pays personally?
No. Identify the legal borrower, actual payer, and any guarantee or reimbursement arrangement. The financing team needs that context to determine the correct analysis and documentation.
Sources & context
Published by Mortgage Calculator Company LLC d/b/a The Mortgage Calculator, NMLS #2377459. This guide is general educational information. Examples are illustrative, and program availability, qualification, and final terms require an individual review.
- SBA: Glossary of business financial terms ↗
- SBA: Borrower information form ↗
- SEC: Financial statements and liabilities ↗
Published November 11, 2026. Reference sources checked for this edition. For a correction or question, contact the company.