Balance Sheet Template

A balance sheet is a snapshot of what your business owns, what it owes and the owner's equity at a point in time. This template totals current and long-term assets and liabilities and checks that the sheet balances.

Preview of the Balance Sheet Template

Free download. No sign-up, no email.

Download Excel (.xlsx)6 KB

Formulas built in, just fill the yellow cells
Works in Excel, Google Sheets and LibreOffice
Example numbers show how it works

Who this template is for

Loan applicants
Business plan writers
Owners reviewing financial health

How to fill it in

Pick the date of the balance sheet.
Enter cash, receivables, inventory and other assets.
Enter loans, payables and other liabilities.
Enter owner investment and retained earnings.
Check that the balance check cell shows zero.

What is inside

Sheet: Balance Sheet
Current assets
Cash
Accounts receivable
Inventory
Prepaid expenses
Total current assets
Fixed assets
Equipment
Vehicles
Furniture and fixtures
Less accumulated depreciation
Total fixed assets
TOTAL ASSETS
Current liabilities
Accounts payable
Credit cards
Accrued payroll and taxes
Current portion of long-term debt
Total current liabilities
Long-term liabilities
Bank loans
Owner loans
Total long-term liabilities
TOTAL LIABILITIES
Owner's equity

Writing a full business plan?

Browse 39 free sample plans by industry, each with startup costs and projections.

See sample plans

Frequently asked questions

What is the balance sheet equation?

Assets equal liabilities plus owner's equity.

Does a startup need a balance sheet?

Yes. A projected opening balance sheet shows how startup funds are used and is often requested by lenders.

Is this balance sheet template free to use?

Yes. Download it, edit it and use it for your own business at no cost. No account or email address is required.

Related templates

Sales Forecast Template

Units, prices and revenue by month.

Personal Financial Statement Template

Your personal assets and debts for a lender.

Business Loan Payment Calculator

Monthly payment and amortization schedule.

Startup Business Plan Template

The complete fill-in-the-blank plan.