A balance sheet template is a ready-made spreadsheet that shows what your business owns (assets), what it owes (liabilities) and the owners' stake (equity) on a specific date. Download the free Excel template below: enter your account balances and it totals each section, checks that assets equal liabilities plus equity, and calculates working capital, current ratio, quick ratio and debt-to-equity.
- Current and non-current assets, with accumulated depreciation
- Current and long-term liabilities, including line of credit and current portion of debt
- Owner's equity: capital, paid-in capital, retained earnings and draws
- Current period and prior period side by side
- Balance check that flags any difference between assets and liabilities plus equity
- Working capital, current ratio, quick ratio and debt-to-equity
- A filled-in example sheet to follow
What Is a Balance Sheet?
A balance sheet, also called a statement of financial position, is a snapshot of a business's finances on one date, such as the last day of the month or fiscal year. It is one of the three core financial statements, alongside the profit and loss statement and the cash flow statement.
Every balance sheet follows one equation:
Assets = Liabilities + Owner's Equity
If the two sides don't match, something is missing or misclassified. That is why the template includes a built-in balance check.
What to Include in a Balance Sheet
The template uses a classified format, which splits assets and liabilities into current (due or usable within 12 months) and non-current. Lenders and investors expect this layout because it shows liquidity at a glance.
- Current assets: cash and cash equivalents, accounts receivable, inventory, prepaid expenses and other short-term assets.
- Non-current assets: property, plant and equipment (less accumulated depreciation), intangible assets, long-term investments and other long-term assets.
- Current liabilities: accounts payable, accrued expenses, short-term debt and line of credit balances, the current portion of long-term debt, deferred revenue and other short-term obligations.
- Long-term liabilities: long-term loans, deferred tax liabilities and other obligations due after 12 months.
- Owner's equity: owner's capital or common stock, additional paid-in capital, retained earnings, less owner draws or distributions.
How to Fill Out the Balance Sheet Template
- Enter your company name and the period-end dates for the current and prior periods.
- Pull balances from your accounting software (QuickBooks, Xero or your general ledger) as of the period-end date. Use ending balances, not monthly activity.
- Enter assets. Type accumulated depreciation as a negative number so it reduces the value of your equipment.
- Enter liabilities. Put your line of credit balance and any loan principal due in the next 12 months under current liabilities.
- Enter equity. Enter owner draws or distributions as a negative number.
- Check the status row. It should read "Balanced". If it shows "Off by $X", look for a missing account or an entry in the wrong section.
- Review the ratios at the bottom and compare them with the prior period.
Balance Sheet Example
Here is the condensed example from the template's Example sheet for a small importer, Acme Imports LLC:
| Line item | May 31, 2026 | May 31, 2025 |
|---|---|---|
| Cash and cash equivalents | $85,000 | $60,000 |
| Accounts receivable | $120,000 | $100,000 |
| Inventory | $95,000 | $80,000 |
| Total current assets | $310,000 | $248,000 |
| Total non-current assets | $120,000 | $125,000 |
| Total assets | $430,000 | $373,000 |
| Total current liabilities | $145,000 | $120,000 |
| Total long-term liabilities | $65,000 | $77,000 |
| Total liabilities | $210,000 | $197,000 |
| Total owner's equity | $220,000 | $176,000 |
| Total liabilities and equity | $430,000 | $373,000 |
Total assets of $430,000 equal total liabilities and equity of $430,000, so the balance sheet balances.
Balance Sheet Ratios the Template Calculates
| Ratio | Formula | Example (2026) | What it tells you |
|---|---|---|---|
| Working capital | Current assets − current liabilities | $165,000 | Cushion available to run day-to-day operations |
| Current ratio | Current assets ÷ current liabilities | 2.14 | Ability to cover short-term obligations |
| Quick ratio | (Cash + receivables) ÷ current liabilities | 1.41 | Liquidity without relying on selling inventory |
| Debt-to-equity | Total liabilities ÷ total equity | 0.95 | How much the business relies on borrowed money |
In the example, working capital grew from $128,000 to $165,000 and debt-to-equity improved from 1.12 to 0.95, a stronger position when applying for working capital.
Common Balance Sheet Mistakes
- Mixing up dates. Every figure must be a balance as of the same date.
- Positive contra accounts. Accumulated depreciation and owner draws reduce totals, so enter them as negatives.
- Stale retained earnings. Retained earnings should include net income from your latest profit and loss statement, less distributions.
- Classifying all debt as long-term. Loan principal due within 12 months belongs in current liabilities, which changes your current ratio.
- Listing personal assets. Keep owner's personal property and accounts off the business balance sheet.
What Your Balance Sheet Says About Cash Flow
A business can show profit and still run short of cash when money is tied up in receivables and inventory. If accounts receivable and inventory are growing faster than cash, your balance sheet is showing a working capital gap. Track it alongside a 13-week cash flow forecast and the cash conversion cycle.
Is cash tied up in receivables or inventory? Drip Capital offers collateral-free working capital of up to $3M, with funds in 24–48 hours and 30–90 day repayment terms. Check your eligibility
Frequently Asked Questions
What is a balance sheet template?
A balance sheet template is a pre-built spreadsheet that lists a company's assets, liabilities and owner's equity on a specific date and calculates the totals for you. A good template also checks that total assets equal total liabilities plus equity.
What are the three main parts of a balance sheet?
Assets (what the business owns), liabilities (what it owes) and owner's equity (the owners' stake). They always follow the accounting equation: assets = liabilities + equity.
Why doesn't my balance sheet balance?
The most common causes are a missing account, an amount entered in the wrong section, accumulated depreciation or owner draws entered as positive numbers, or retained earnings that have not been updated with the latest net income.
How often should a small business prepare a balance sheet?
At least at the end of every quarter and fiscal year. Many businesses review one monthly alongside the profit and loss statement, and lenders usually ask for the most recent month-end or year-end balance sheet.
What is a good current ratio for a small business?
A current ratio above 1.0 means current assets cover current liabilities. Many lenders consider roughly 1.5 to 2.0 comfortable, but the right level depends on your industry and how quickly you turn inventory and receivables into cash.
