SmallBizHandbookSmallBizHandbook

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.

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–54

Quick ratio (acid test)

Dec 31, 2025
—
Dec 31, 2024
—

(Current assets − inventory − prepaid expenses) ÷ current liabilities

Source: SCORE Financial Management Workbook, p. 54

Debt-to-equity

Dec 31, 2025
—
Dec 31, 2024
—

Total liabilities ÷ total equity

Source: SCORE Financial Management Workbook, p. 54

Debt 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

  1. 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.
  2. Cash. Use reconciled bank balances (bank balance minus checks that haven't cleared plus deposits in transit), plus petty cash.
  3. 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.
  4. Property and equipment. List assets at original cost from your fixed-asset or depreciation schedule, then enter total accumulated depreciation on the “Less:” line.
  5. 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.
  6. 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.
  7. 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.

Maple Street Bakery LLC
Balance Sheet
As of December 31, 2025 and 2024
(In U.S. dollars)
Dec 31, 2025
Dec 31, 2024
Assets
Current assets
Cash and cash equivalents34,70038,400
Accounts receivable15,90012,600
Less: Allowance for doubtful accounts(700)(600)
Inventory17,30015,800
Prepaid expenses3,9004,200
Total current assets71,10070,400
Property and equipment
Leasehold improvements48,00048,000
Kitchen equipment, furniture and fixtures140,000128,000
Delivery vans28,00014,000
Less: Accumulated depreciation(79,000)(61,000)
Net property and equipment137,000129,000
Other assets
Security deposits9,0009,000
Total other assets9,0009,000
Total assets217,100208,400
Liabilities and equity
Current liabilities
Accounts payable16,90014,300
Credit cards payable2,4003,100
Accrued wages and payroll taxes7,4006,200
Sales tax payable3,3002,800
Customer deposits and unearned revenue2,6001,500
Current portion of long-term debt14,50014,000
Total current liabilities47,10041,900
Long-term liabilities
Bank term loan, net of current portion63,00077,500
Total long-term liabilities63,00077,500
Total liabilities110,100119,400
Partners' / members' equity
Partners' / members' capital contributed60,00060,000
Undistributed earnings from prior periods29,00021,600
Net income (loss), current period48,00027,400
Less: Distributions to partners / members, current period(30,000)(20,000)
Total equity107,00089,000
Total liabilities and equity217,100208,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

RatioFormulaExampleWhat it tells you
Working capitalCurrent assets − current liabilities$24,000The cushion for paying bills due within a year. Negative working capital is a red flag for lenders.
Current ratioCurrent assets ÷ current liabilities1.51Below 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 liabilities1.06Can you pay current bills without selling inventory? SCORE calls 1:1 “solid.”
Debt-to-equityTotal liabilities ÷ total equity1.03How 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 worthTotal liabilities ÷ (equity − intangible assets)1.03The leverage measure listed in SBA's lending rules. It ignores goodwill and other intangibles a lender can't sell.
Debt ratioTotal liabilities ÷ total assets50.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:

FigureShows up inExample
P&L: net incomeCash flow: first line of operating activities$48,000
P&L: net incomeBalance sheet: equity (current-period net income)$48,000
P&L: depreciationCash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount$18,000
Cash flow: ending cashBalance sheet: cash and cash equivalents$34,700
Cash flow: loan principal repaidBalance sheet: total loan balances fall$91,500 → $77,500
Cash flow: owner distributionsBalance 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?
A balance sheet lists what a business owns (assets), what it owes (liabilities) and the owners' stake (equity) on one specific date. The two sides must match: assets = liabilities + equity. The SEC's beginners' guide uses the same equation. IRS Publication 583 describes it as showing "the assets, liabilities, and your equity in the business on a given date."
How do I make a balance sheet for a small business?
Pick a date, usually the last day of a month, quarter or year. Pull balances as of that date: reconciled bank accounts, unpaid customer invoices, inventory count, equipment cost and accumulated depreciation, unpaid bills, credit cards, payroll and sales taxes owed, and loan balances (split into the part due within 12 months and the rest). Then enter owner contributions, earnings kept from prior periods, this period's net income and owner draws. The template totals each section and tells you whether, and by how much, it is out of balance.
Is there a free balance sheet template in Excel?
Yes. "Download Excel (.xlsx)" saves your filled-in balance sheet as a workbook where every subtotal, total, balance check and ratio is a live formula and the input cells are yellow, so it keeps working as a template. "Blank Excel template" gives you the same workbook with the amounts emptied. No signup or email.
Why doesn't my balance sheet balance?
The most common causes: this period's net income was left out of equity (or counted twice), owner draws were entered as an expense instead of a reduction of equity, a loan payment was entered in full instead of splitting interest (an expense) from principal (a reduction of the loan), a contra account such as accumulated depreciation was entered as an asset, or a figure landed in the wrong date column. The check under the template shows the exact difference for each column. If the difference equals net income, the template points that out.
What's the difference between a balance sheet and a profit and loss statement?
A balance sheet is a snapshot on one date. A profit and loss statement (income statement) covers a period, such as a month or a year, and shows revenue, expenses and profit. They connect through equity: the period's net income increases equity on the balance sheet, and owner draws reduce it. The cash flow statement explains how cash moved between two balance sheet dates.
How often should I prepare a balance sheet?
At least at each fiscal year-end. Many owners prepare one monthly or quarterly alongside their P&L. If you are applying for an SBA 7(a) loan, SBA's rules call for an interim financial statement dated within 120 days of submission, and the submission checklist asks for a current income statement and balance sheet dated as of the same date.
Do sole proprietors need a balance sheet for taxes?
Schedule C (sole proprietors and single-member LLCs) doesn't include a balance sheet, but lenders and investors still ask for one. Partnerships (Form 1065), S corporations (Form 1120-S) and C corporations (Form 1120) report a balance sheet on Schedule L of their returns, and the instructions let smaller entities skip it if they meet certain tests. For example, a C corporation with total receipts and total assets under $250,000 that checks "Yes" on Schedule K, question 13, doesn't have to complete Schedule L.
Should I use tax depreciation or book depreciation?
Many small businesses keep their books on the same basis as their tax return, so accumulated depreciation follows the tax depreciation schedule, including Section 179 and bonus depreciation. That can make equipment look almost fully depreciated soon after purchase. Some lenders prefer statements prepared on a book (GAAP) basis. Ask which basis your lender expects, and label the statement accordingly in the footnote.
How do I enter accumulated depreciation and the allowance for doubtful accounts?
Enter them as positive numbers on their "Less:" lines. The template (and the Excel formulas) subtract them automatically and show them in parentheses on the printed statement.
Is my data stored or shared?
No. Figures are saved only in your own browser (localStorage) so they're there when you come back. Nothing is uploaded. Clearing your browser data, or clicking Reset, removes them.

Official Sources

Figures checked against these sources on 2026-10-03

Related Resources on This Site