How to use this balance sheet template
Type your figures straight into the table above. Each section already has the line items a typical small business needs; rename any label, add rows for accounts we did not anticipate, and delete the ones you do not use. The section totals, the accounting-equation check, and the ratios update as you type, and your entries stay in your browser between visits.
When it balances, click Download Excel to get a formatted .xlsx file. Every subtotal, total, and ratio in the file is a live formula, so you can hand it to a bookkeeper or lender and keep editing it in Excel, Google Sheets, or Numbers. The CSV export is a plain data dump for people who prefer to build their own layout.
A few entry rules that trip people up:
- Enter accumulated depreciation as a negative number under non-current assets. It reduces the book value of your equipment.
- The current portion of a long-term loan (the principal you will repay in the next 12 months) belongs under current liabilities. The remainder goes under long-term liabilities.
- Retained earnings is cumulative profit that has stayed in the business: all prior net income minus all owner draws or dividends. If you do not know it, it is the number that makes the sheet balance once every real asset and liability is in.
What a balance sheet shows
A balance sheet is a photograph of your business's financial position on one specific day. It answers three questions: what does the business own, what does it owe, and how much of it belongs to the owner? Unlike a profit and loss statement, which covers a stretch of time, the balance sheet has a single date on it, typically the last day of a month, quarter, or fiscal year.
That single-day nature is why it is so useful to lenders and buyers. A P&L can look healthy while the business quietly borrows to stay afloat; the balance sheet exposes the growing debt. It also shows liquidity, meaning whether there is enough cash and near-cash to cover the bills coming due.
The accounting equation
Every balance sheet obeys one identity:
Assets = Liabilities + Owner's Equity
Everything the business owns was paid for either with borrowed money (liabilities) or with the owner's money and reinvested profits (equity). If the two sides do not match, the sheet is wrong, not the equation. The green/red indicator above compares the totals and shows the exact difference so you can find the missing entry.
In the sample data, Maple Street Bakery has $93,800 of assets, financed by $57,800 of liabilities and $36,000 of equity. $57,800 + $36,000 = $93,800, so it balances.
Current assets
Current assets are cash and anything you expect to convert to cash within a year, listed from most to least liquid:
| Line item | What goes here | Bakery example |
|---|---|---|
| Cash and bank accounts | Checking, savings, petty cash, PayPal/Stripe balances | $24,500 |
| Accounts receivable | Invoices sent but not yet paid by customers | $8,200 |
| Inventory | Raw ingredients, packaging, finished goods at cost | $6,300 |
| Prepaid expenses | Insurance or rent paid in advance for future months | $1,800 |
Total current assets: $40,800. Record inventory at what it cost you, not what you will sell it for.
Non-current assets
Non-current (fixed or long-term) assets are things you will use for more than a year: equipment, vehicles, furniture, buildings, leasehold improvements, and deposits you will eventually get back. They are recorded at purchase cost and reduced by accumulated depreciation, which spreads the cost over the asset's useful life.
| Line item | Bakery example |
|---|---|
| Equipment and fixtures (ovens, mixers, display cases) | $38,000 |
| Less: accumulated depreciation | −$9,500 |
| Delivery vehicle | $22,000 |
| Security deposits (lease) | $2,500 |
Total non-current assets: $53,000, and total assets: $40,800 + $53,000 = $93,800.
Current liabilities
Current liabilities are debts due within 12 months:
- Accounts payable: supplier bills you have received but not yet paid ($5,400).
- Credit card balances ($2,100).
- Sales tax payable and payroll taxes withheld but not yet remitted ($1,300). This money was never yours; it belongs to the state or the IRS.
- Current portion of long-term debt: the principal due in the next year on any loan ($6,000).
- Accrued wages, customer deposits, and unearned revenue also belong here if you have them.
Total current liabilities: $14,800.
Long-term liabilities
Loans and obligations due more than a year out, net of the current portion you already listed above. For the bakery that is the non-current balance of an SBA 7(a) loan ($31,000) and a vehicle loan ($12,000), for $43,000 in long-term liabilities and $57,800 in total liabilities.
Owner's equity
Equity is what would be left for the owner if every asset were sold at book value and every debt repaid. For a sole proprietorship or single-member LLC it usually has two lines:
- Owner's capital contributions: money and property the owner put in ($25,000).
- Retained earnings: cumulative profits kept in the business ($11,000). Net income from each year's P&L increases this; owner draws decrease it.
Corporations show common stock, additional paid-in capital, and retained earnings instead, but the logic is the same. Total equity: $36,000.
How to read a balance sheet: three ratios
Lenders, landlords, and potential buyers rarely read the sheet line by line. They compute a handful of ratios, and you should too.
Working capital
Working capital = Current assets − Current liabilities
$40,800 − $14,800 = $26,000. This is the cushion you have to run the business for the next year without new borrowing. Negative working capital means bills due soon exceed the cash you will have to pay them.
Current ratio
Current ratio = Current assets ÷ Current liabilities
$40,800 ÷ $14,800 = 2.76. Above 1.0 you can cover short-term debts; 1.5 to 2.0 is a common lender comfort zone. Very high ratios (4+) can mean cash is sitting idle or inventory is piling up.
Debt-to-equity
Debt-to-equity = Total liabilities ÷ Total equity
$57,800 ÷ $36,000 = 1.61. This measures how leveraged you are. Many small-business lenders want to see this below 2.0 to 3.0, though capital-intensive trades run higher. A rising trend over several balance sheets is a warning sign even if the level looks fine.
| Ratio | Bakery | Watch out below/above |
|---|---|---|
| Working capital | $26,000 | Below $0 |
| Current ratio | 2.76 | Below 1.0 |
| Debt-to-equity | 1.61 | Above ~2.5 for most service businesses |
Balance sheet vs. P&L vs. cash flow statement
The three core financial statements answer different questions and are linked:
| Statement | Question it answers | Time frame | Key line |
|---|---|---|---|
| Balance sheet | What do we own and owe right now? | One date | Total equity |
| Profit and loss | Did we make money? | A period | Net income |
| Cash flow statement | Where did the cash go? | A period | Change in cash |
Net income from the P&L flows into retained earnings on the balance sheet. The change in the cash line between two balance sheets is what the cash flow statement explains. If you only keep one, keep the P&L for taxes; if you want to understand whether the business is getting stronger, you need the balance sheet as well. Our profit and loss template uses the same download format so the two files sit side by side.
Common balance sheet mistakes
- Forgetting a liability. Credit cards, the sales tax you collected, a loan from a family member, and the current portion of long-term debt are the usual omissions. Each one makes assets look over-financed by equity.
- Valuing assets at market price. Book value is cost minus depreciation. Your $22,000 van is not a $30,000 asset because a dealer would pay that.
- Skipping depreciation. Equipment bought five years ago is not still worth its purchase price on the books.
- Mixing personal and business. Your personal car and home mortgage do not belong here unless the business owns them.
- Not updating retained earnings. If the sheet balanced last year and does not this year, the difference is almost always this year's net income minus draws.
- Confusing cash with profit. A big cash balance right after taking a loan is not equity. It is matched by a liability.
When lenders and others ask for a balance sheet
Expect to produce a balance sheet when you:
- Apply for a term loan or line of credit. SBA lenders typically want year-end balance sheets for the last two to three years plus an interim one no more than 90 days old; see what else they look at in our SBA loan calculator and business loan calculator.
- Sign a commercial lease. Landlords use it to judge whether you can cover rent through a slow season.
- Bring on a partner or investor, or sell the business. Equity and working capital drive the valuation conversation.
- File taxes as a partnership or S corporation. Schedule L on Form 1065 and Form 1120-S is a balance sheet, required once total receipts or assets pass IRS thresholds.
Preparing one quarterly, even when nobody is asking, means you are never scrambling to reconstruct twelve months of records under a deadline. Pair it with the expense tracker so your liabilities and prepaid items are already categorised when the quarter ends.