Free Business Debt Schedule Template (Excel)
What a business debt schedule is and why lenders ask for one
A business debt schedule lists every debt your company carries — term loans, lines of credit, equipment loans, commercial mortgages, business credit cards — with the current balance, rate, and monthly payment for each.
Lenders and the SBA request this exact schedule as part of a loan application: they need to see your total existing debt load and monthly obligations before extending new credit, and a clean schedule speeds up underwriting.
Keeping the schedule current, rather than rebuilding it from scratch every time you apply for financing, means you can hand it over the same day a lender asks for it.
How to fill in each loan, line of credit, and note
List up to 20 business debts, each with a creditor name, loan type (term loan, line of credit, equipment loan, commercial mortgage, credit card, or other), original amount, interest rate, current balance, and monthly payment.
The loan type dropdown keeps the schedule readable at a glance and matches the categories a lender's underwriter typically asks to see broken out separately.
Update the current balance each month (or whenever you pull a fresh statement) and every downstream calculation on that row updates automatically.
Automatic monthly interest and principal split
For each debt, monthly interest is calculated from the current balance and rate, and monthly principal is what's left of the monthly payment after that interest — so you can see, per debt, how much of what you're paying is actually reducing the balance versus covering interest.
This isn't a full multi-year amortization table; it's a current-month snapshot per debt, which is exactly the figure that matters when you're assembling a debt schedule for a lender or reviewing your monthly obligations.
Because the split recalculates from the numbers you enter, you don't need to build a separate amortization formula for every loan on your books.
Lender-ready summary: total debt service and weighted rate
The summary totals your outstanding debt across every creditor, your total monthly debt service, and the same figure annualized — three numbers a lender's cash flow or debt-service-coverage calculation typically starts with.
A weighted average interest rate across all your debts is also calculated automatically, using each debt's balance to weight its rate — a single number that summarizes your overall cost of debt.
A chart shows balance by creditor, so you (or a lender reviewing the schedule) can see your debt concentration at a glance before digging into individual rows.
How to use it
- List each business debt: creditor, loan type, original amount, interest rate, current balance, and monthly payment.
- Review monthly interest and monthly principal per debt, calculated automatically.
- Check the summary for total outstanding debt, total monthly debt service, and weighted average rate.
- Update balances each month or before a loan application so the schedule stays current.
Download the free Free Business Debt Schedule Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
If you need your debt service categorized alongside the rest of your business expenses for taxes, the paid Bookkeeping template ($19) maps every expense to Schedule C with a quarterly tax set-aside.
See the full versionFrequently asked questions
Can I use this business debt schedule in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the calculations keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Is this the same as a personal debt payoff spreadsheet?
No. This is a business debt schedule for loan applications and lender review. For personal debt with snowball/avalanche payoff ranking, use our free Debt Payoff template instead.
How many debts can I list?
The template ships with 20 rows. Add more rows and copy the formulas down if your business carries more debts.
Does it build a full multi-year amortization table per loan?
No, it calculates the current month's interest/principal split per debt, not a year-by-year amortization schedule. For a full amortization table, you'd need a dedicated loan amortization tool.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.