Balance sheet template
A balance sheet shows what your business owns, what it owes and what is left for the owners on one date. This free template lists the usual small business assets and liabilities, adds them up, and checks that assets equal liabilities plus equity, so you can see straight away if something is missing.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | This year end | Last year end |
|---|---|---|
| Current assets | ||
| Cash in bank | $48,200.00 | $31,500.00 |
| Accounts receivable | $22,400.00 | $18,100.00 |
| Inventory | $16,800.00 | $14,200.00 |
| Prepaid expenses | $2,400.00 | $2,000.00 |
| Total current assets | $89,800.00 | $65,800.00 |
| Fixed and other assets | ||
| Equipment and furniture | $38,000.00 | $30,000.00 |
| Vehicles | $42,000.00 | $42,000.00 |
| Less accumulated depreciation (enter as negative) | -$29,500.00 | -$24,000.00 |
| Deposits and other assets | $3,000.00 | $3,000.00 |
| Total fixed and other assets | $53,500.00 | $51,000.00 |
| Total assets | $143,300.00 | $116,800.00 |
| Current liabilities | ||
| Accounts payable | $11,600.00 | $9,800.00 |
| Credit cards | $6,200.00 | $7,400.00 |
| Sales tax payable | $3,100.00 | $2,600.00 |
| Payroll taxes payable | $2,900.00 | $2,500.00 |
| Current part of loans | $9,600.00 | $9,600.00 |
| Total current liabilities | $33,400.00 | $31,900.00 |
| Long-term liabilities | ||
| Loans, less the current part | $28,800.00 | $38,400.00 |
| Loans from owners | $25,000.00 | $10,000.00 |
| Total long-term liabilities | $53,800.00 | $48,400.00 |
| Total liabilities | $87,200.00 | $80,300.00 |
| Equity | ||
| Owner contributions | $25,000.00 | $25,000.00 |
| Owner draws or distributions (enter as negative) | -$42,000.00 | -$36,000.00 |
| Retained earnings from past years | $11,500.00 | -$2,000.00 |
| Net profit this year | $61,600.00 | $49,500.00 |
| Total equity | $56,100.00 | $36,500.00 |
| Total liabilities and equity | $143,300.00 | $116,800.00 |
| Difference (should be 0) | $0.00 | $0.00 |
What is a balance sheet?
A snapshot of the business on one date. Assets are what the business owns: cash, money customers owe you, inventory and equipment. Liabilities are what it owes: bills, cards, sales tax collected, payroll taxes and loans. Equity is the difference, which belongs to the owners. The sheet always balances: assets equal liabilities plus equity.
Why doesn't my balance sheet balance?
Usually one of four things. A loan was set up without its starting balance. Owner draws were booked as expenses. A bank account wasn't reconciled. Or last year's profit wasn't rolled into retained earnings. Fix the cash accounts first, because the rest depends on them. If the books are months behind, catch-up bookkeeping is the faster route.
Who asks for a balance sheet?
Banks and SBA lenders, landlords, buyers of a business and investors. Partnerships and corporations also report a balance sheet on the tax return (Schedule L on Form 1065, 1120-S and 1120) unless they meet the small-business exception. Keep it next to the profit and loss statement, since net profit flows from one to the other.
Sources
General information, not tax advice for your situation.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceWhat is the difference between a balance sheet and a P&L?
The P&L covers a period, like a month or year, and ends in profit. The balance sheet is one date and shows what you own, what you owe and the owners' share.
Where do owner draws go?
In equity, as a negative number. They reduce what the owners have left in the business, but they are not an expense.
Does a sole proprietor need a balance sheet?
Schedule C doesn't ask for one, but lenders often do, and it's the best check that your books are complete.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.