Free Balance Sheet Template
Last updated: 2026-10-03
Fill in your small business balance sheet right here, compare it with a prior date, and let the template check that assets equal liabilities plus equity. Then download an Excel file that keeps calculating, or print a clean statement for your lender or accountant.
- Excel with live formulas
- Current vs. prior date with $ and % change
- Balance check
- Ratios explained
- Print-ready PDF
- No signup, nothing uploaded
| Line item | Dec 31, 2025 | Dec 31, 2024 | ||
|---|---|---|---|---|
| Assets | ||||
Current assets | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Total current assets | – | – | ||
Property and equipment | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Net property and equipment | – | – | ||
Other assets | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Total other assets | – | – | ||
| Total assets | – | – | ||
| Liabilities and equity | ||||
Current liabilities | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Total current liabilities | – | – | ||
Long-term liabilities | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Total long-term liabilities | – | – | ||
| Total liabilities | – | – | ||
Owner's equity | ||||
$ | $ | |||
$ | $ | |||
$ | $ | |||
$ | $ | |||
| Total equity | – | – | ||
| Total liabilities and equity | – | – | ||
| Check: assets − (liabilities + equity) — should be 0 | ✓ 0 | ✓ 0 | ||
Saved automatically in this browser only. Nothing is uploaded. Click next to a line to see what belongs there.
Automatic checks
- Enter your figures (or load the example) to run the checks.
Key ratios (per column)
Working capital
- Dec 31, 2025
- —
- Dec 31, 2024
- —
Current assets − current liabilities
Current ratio
- Dec 31, 2025
- —
- Dec 31, 2024
- —
Current assets ÷ current liabilities
Source: SCORE Financial Management Workbook, p. 53–54Quick ratio (acid test)
- Dec 31, 2025
- —
- Dec 31, 2024
- —
(Current assets − inventory − prepaid expenses) ÷ current liabilities
Source: SCORE Financial Management Workbook, p. 54Debt-to-equity
- Dec 31, 2025
- —
- Dec 31, 2024
- —
Total liabilities ÷ total equity
Source: SCORE Financial Management Workbook, p. 54Debt to tangible net worth
- Dec 31, 2025
- —
- Dec 31, 2024
- —
Total liabilities ÷ (total equity − intangible assets)
Source: SBA SOP 50 10 8.1 (effective Oct. 1, 2026)Debt ratio
- Dec 31, 2025
- —
- Dec 31, 2024
- —
Total liabilities ÷ total assets
How to fill in a balance sheet, step by step
- Pick the date. Usually the last day of your fiscal year, quarter or month. Every figure must be the balance on that date. For comparison, use the same date a year earlier.
- Cash. Use reconciled bank balances (bank balance minus checks that haven't cleared plus deposits in transit), plus petty cash.
- Receivables and inventory. Total your unpaid customer invoices (an aging report from your accounting software). Subtract an allowance for invoices you don't expect to collect. Count inventory and value it at cost.
- Property and equipment. List assets at original cost from your fixed-asset or depreciation schedule, then enter total accumulated depreciation on the “Less:” line.
- Liabilities. Unpaid vendor bills, credit card balances, wages and payroll taxes owed, sales tax collected but not yet remitted, and customer deposits. For each loan, put the next 12 months of principal under “Current portion of long-term debt” and the rest under long-term loans. Your loan amortization schedule shows the split.
- Equity. Choose your business type so the wording fits, then enter owner contributions, earnings kept from earlier periods, this period's net income (or click Pull net income from P&L) and this period's draws or distributions.
- Check and fix. If the template says it's out of balance, the difference is shown for each date. Fix it before you send the statement. Don't force it to balance with a plug figure.
Worked example: a small bakery's comparative balance sheet
Maple Street Bakery LLC is a fictional two-member LLC. Its balance sheet below compares December 31, 2025 with December 31, 2024. It ties to the same company's P&L and cash flow statement.
Dec 31, 2025 | Dec 31, 2024 | |||
|---|---|---|---|---|
| Assets | ||||
| Current assets | ||||
| Cash and cash equivalents | 34,700 | 38,400 | ||
| Accounts receivable | 15,900 | 12,600 | ||
| Less: Allowance for doubtful accounts | (700) | (600) | ||
| Inventory | 17,300 | 15,800 | ||
| Prepaid expenses | 3,900 | 4,200 | ||
| Total current assets | 71,100 | 70,400 | ||
| Property and equipment | ||||
| Leasehold improvements | 48,000 | 48,000 | ||
| Kitchen equipment, furniture and fixtures | 140,000 | 128,000 | ||
| Delivery vans | 28,000 | 14,000 | ||
| Less: Accumulated depreciation | (79,000) | (61,000) | ||
| Net property and equipment | 137,000 | 129,000 | ||
| Other assets | ||||
| Security deposits | 9,000 | 9,000 | ||
| Total other assets | 9,000 | 9,000 | ||
| Total assets | 217,100 | 208,400 | ||
| Liabilities and equity | ||||
| Current liabilities | ||||
| Accounts payable | 16,900 | 14,300 | ||
| Credit cards payable | 2,400 | 3,100 | ||
| Accrued wages and payroll taxes | 7,400 | 6,200 | ||
| Sales tax payable | 3,300 | 2,800 | ||
| Customer deposits and unearned revenue | 2,600 | 1,500 | ||
| Current portion of long-term debt | 14,500 | 14,000 | ||
| Total current liabilities | 47,100 | 41,900 | ||
| Long-term liabilities | ||||
| Bank term loan, net of current portion | 63,000 | 77,500 | ||
| Total long-term liabilities | 63,000 | 77,500 | ||
| Total liabilities | 110,100 | 119,400 | ||
| Partners' / members' equity | ||||
| Partners' / members' capital contributed | 60,000 | 60,000 | ||
| Undistributed earnings from prior periods | 29,000 | 21,600 | ||
| Net income (loss), current period | 48,000 | 27,400 | ||
| Less: Distributions to partners / members, current period | (30,000) | (20,000) | ||
| Total equity | 107,000 | 89,000 | ||
| Total liabilities and equity | 217,100 | 208,400 | ||
Fictional company for illustration. Click “Load example” in the template above to explore these figures, then open the other two templates to see the same company's statements.
What it says: total assets are $217,100, funded 50.7% by creditors and the rest by the owners. Working capital is $24,000. The current ratio slipped from 1.68 to 1.51 because current liabilities grew (more unpaid supplier bills, accrued wages and customer deposits) while current assets stayed flat. Cash went to new equipment, loan payments and owner distributions. Debt-to-equity improved from 1.34 to 1.03: the owners kept part of the year's profit in the business while loan principal was paid down. Equity grew from $89,000 to $107,000, which is net income of $48,000 minus $30,000 of distributions.
How to read a balance sheet: the ratios that matter
| Ratio | Formula | Example | What it tells you |
|---|---|---|---|
| Working capital | Current assets − current liabilities | $24,000 | The cushion for paying bills due within a year. Negative working capital is a red flag for lenders. |
| Current ratio | Current assets ÷ current liabilities | 1.51 | Below 1.0, short-term assets don't cover short-term bills. SCORE's workbook calls 2:1 “healthy,” and SBA lenders calculate this ratio. Norms vary by industry. |
| Quick ratio | (Current assets − inventory − prepaid expenses) ÷ current liabilities | 1.06 | Can you pay current bills without selling inventory? SCORE calls 1:1 “solid.” |
| Debt-to-equity | Total liabilities ÷ total equity | 1.03 | How much of the business creditors fund for each $1 the owners fund. The SEC guide uses this definition. SCORE suggests debts ideally shouldn't exceed what owners have invested. |
| Debt to tangible net worth | Total liabilities ÷ (equity − intangible assets) | 1.03 | The leverage measure listed in SBA's lending rules. It ignores goodwill and other intangibles a lender can't sell. |
| Debt ratio | Total liabilities ÷ total assets | 50.7% | The share of assets financed by creditors. SBA notes the acceptable level “varies according to industry.” |
The template calculates each ratio for both dates and explains the result in plain English. The Excel download includes the same ratios as formulas.
Common balance sheet mistakes
- Using the bank's online balance instead of the reconciled balance. Outstanding checks make the online number too high.
- Putting the whole loan under long-term debt. Principal due in the next 12 months is a current liability. Leaving it out makes working capital and the current ratio look better than they are.
- Treating owner draws as an expense (or owner contributions as revenue). Both belong in equity.
- Leaving out this period's profit, the most common reason a homemade balance sheet doesn't balance.
- Listing equipment at today's value. Balance sheets carry assets at cost less accumulated depreciation, not market value.
- Mixing personal and business assets. Your house or personal car goes on a personal financial statement (SBA Form 413), not the business balance sheet, unless the business owns it.
- Forgetting sales tax and payroll taxes that were collected or withheld but not yet paid. That money belongs to the government.
How the balance sheet, P&L and cash flow statement connect
The three statements describe the same business from different angles. The profit and loss statement covers a period: did you make money? The balance sheet is a snapshot at the end of the period: what do you own and owe? The cash flow statement explains why cash changed between two balance sheets. Here's how the example bakery's 2025 figures flow between them:
| Figure | Shows up in | Example |
|---|---|---|
| P&L: net income | Cash flow: first line of operating activities | $48,000 |
| P&L: net income | Balance sheet: equity (current-period net income) | $48,000 |
| P&L: depreciation | Cash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount | $18,000 |
| Cash flow: ending cash | Balance sheet: cash and cash equivalents | $34,700 |
| Cash flow: loan principal repaid | Balance sheet: total loan balances fall | $91,500 → $77,500 |
| Cash flow: owner distributions | Balance sheet: subtracted in equity (never an expense on the P&L) | $30,000 |
The bakery earned $48,000 in 2025, yet its cash fell from $38,400 to $34,700. Operations brought in $66,300, but it spent $26,000 on kitchen equipment and a delivery van, repaid loan principal and paid its owners $30,000. Profit and cash are different things, and you need all three statements to see both.
Shortcut: save your balance sheet (with a prior-date column) and your P&L, then click Build from my balance sheet + P&L on the cash flow template. It calculates every operating, investing and financing line for you.
What banks and SBA lenders ask for
- Three years of history plus a current interim statement. SBA's lending rules for 7(a) loans base repayment analysis, for existing businesses, on “the three most recent years of historical financial information (tax returns or balance sheet with debt schedule and income statement) plus an interim financial statement.” Interim financial statements “must be dated within 120 days of submission to SBA.” (SBA SOP 50 10 8.1, effective Oct. 1, 2026)
- Balance sheet and P&L dated the same day. SBA's 7(a) submission checklist asks for a “Current Income Statement and Balance Sheet – (both must be dated as of the same date within 120 days of submission to SBA).” Set the balance sheet date and the P&L period end to the same date. (SBA 7(a) Loan Submission Checklist, May 2024)
- Ratios lenders calculate. The SOP lists current ratio, debt to tangible net worth and debt service coverage among the benchmark ratios. Debt service coverage is EBITDA divided by required principal and interest payments on all business debt. Standard 7(a) loans need at least 1.15:1 and 7(a) Small Loans at least 1.10:1. The balance sheet and P&L templates calculate all three.
- Projections for new businesses. The checklist asks for “Cash Flow Projections with supporting assumptions which reflect positive cash flow within two years” for all new businesses. SBA's business-plan guidance says that if a business is already established, the plan should include “income statements, balance sheets, and cash flow statements for the last three to five years.” (SBA: Plan your business)
- A personal financial statement from owners. For 7(a) loans, SBA Form 413 is completed by each proprietor, general partner, LLC managing member, owner of 20% or more, and guarantor. That form is separate from the business statements on this page. (SBA Form 413)
Your lender decides the exact document list. SBA's 7(a) page notes the contents of a loan application “vary depending on the size of the loan and the lender's processing method.” Statements you prepare yourself are normally labeled unaudited. Use the footnote field to say so.
Frequently asked questions
What is a balance sheet?
How do I make a balance sheet for a small business?
Is there a free balance sheet template in Excel?
Why doesn't my balance sheet balance?
What's the difference between a balance sheet and a profit and loss statement?
How often should I prepare a balance sheet?
Do sole proprietors need a balance sheet for taxes?
Should I use tax depreciation or book depreciation?
How do I enter accumulated depreciation and the allowance for doubtful accounts?
Is my data stored or shared?
Official Sources
Figures checked against these sources on 2026-10-03- SEC: Beginners' Guide to Financial Statements — assets = liabilities + equity; the three cash flow sections; ratio definitions
- IRS Publication 583, Starting a Business and Keeping Records — income statements, balance sheets and supporting records
- IRS: How long should I keep records? — 3, 6, 7 years or indefinitely depending on the situation
- SBA SOP 50 10 8.1 (effective Oct. 1, 2026) — historical statements, 120-day interim rule, ratio benchmarks, debt service coverage
- SBA 7(a) Loan Submission Checklist (May 2024) — same-date income statement and balance sheet; projections for new businesses
- SBA: Plan your business (financial projections) — 3 to 5 years of statements for established businesses
- SBA Form 413, Personal Financial Statement — form version 05-24, OMB expiration 08/31/2027
- SCORE Financial Management Workbook — current, quick and debt-to-equity ratio guidance (pp. 53–54)
- SBA: 5 things to know about your balance sheet — debt ratio; acceptable level varies by industry
- IRS Instructions for Form 1120 (2025) — Schedule L exception for small corporations
- IRS Instructions for Form 1065 (2025) — Schedule L optional if Schedule B, question 4 is “Yes”
Related Resources on This Site
Helpful guides
- CertificationHUBZone certification guide
- Workers' Compworkers compensation insurance by state
- General Liabilitygeneral liability insurance
- Commercial Autocommercial auto insurance