What a Balance Sheet Template Is and Who Needs One
A balance sheet is one of the three core financial statements every business produces, alongside the profit and loss statement and the cash flow statement. Unlike the P&L, which covers a period of time, the balance sheet is a snapshot: it shows exactly what your business owns and owes on a single date. That date is typically the last day of a month, quarter, or fiscal year.
The balance sheet template is built on one fundamental equation: Assets = Liabilities + Owner Equity. If these two sides do not match, something is recorded incorrectly. The word 'balance' in the name refers literally to this equation balancing. Small business owners, sole proprietors, freelancers with significant assets, and any business seeking a bank loan or investor funding need to maintain a current balance sheet.
- Shows total assets: what the business owns (cash, receivables, equipment, inventory)
- Shows total liabilities: what the business owes (loans, accounts payable, deferred revenue)
- Shows owner equity: the net value belonging to the owner after liabilities are subtracted
- Provides a snapshot at a specific date, unlike the P&L which covers a time range
- Required for most business loan applications and investor due diligence
Key Sections of a Balance Sheet
The balance sheet is divided into two main sides: assets on one side, and liabilities plus equity on the other. Within assets, items are grouped into current assets (things that will convert to cash within 12 months) and non-current assets (long-term items like equipment and property). The same split applies to liabilities: current liabilities are due within 12 months, and non-current liabilities are longer-term obligations.
Owner equity represents what is left over when you subtract total liabilities from total assets. For a sole proprietor, this is the owner's capital. For a corporation, it includes paid-in capital and retained earnings. A growing, profitable business should show increasing retained earnings over time, which is one of the clearest signals of financial health that a lender or investor looks for.
- Current Assets: cash, accounts receivable (money owed to you), inventory, and prepaid expenses
- Non-Current Assets: equipment, property, vehicles, intangibles like patents or trademarks
- Current Liabilities: accounts payable, short-term loans, and accrued expenses due within 12 months
- Non-Current Liabilities: long-term loans, mortgages, and deferred tax obligations
- Owner Equity: capital contributed plus retained earnings accumulated over time
- The accounting equation: Total Assets must always equal Total Liabilities plus Owner Equity
How to Fill Out This Balance Sheet Template
The free balance sheet template above is designed to be copied into Google Sheets or Excel, where you can enter amounts and use simple SUM and subtraction formulas to calculate the totals automatically. You can also use it in Google Docs or Word if you prefer a document format over a spreadsheet, though the spreadsheet version is more practical for avoiding math errors.
Start with the date at the top. The balance sheet is always 'as of' a specific date, so choose your period-end date (usually the last day of the month or quarter) and stay consistent. Then work through the assets from most liquid (cash) to least liquid (long-term equipment), followed by liabilities from shortest to longest term, and finish with equity.
- Copy the template into Google Sheets or Excel and save it with the period-end date in the filename
- Enter the 'As of' date in the header to identify when this snapshot was taken
- Fill in each Current Assets line: check your bank balances, outstanding invoices, and inventory count
- List Non-Current Assets and subtract accumulated depreciation from equipment to get net book value
- Fill in Current Liabilities: look at outstanding bills, short-term loan balances, and any deferred customer payments
- Add Long-Term Liabilities: remaining balances on business loans or lease obligations beyond 12 months
- Calculate Owner Equity: add capital contributions and retained earnings from prior periods plus current net income
- Verify that Total Assets equals Total Liabilities plus Owner Equity; if not, find and fix the discrepancy
Balance Sheet Template in Excel and Google Sheets
A balance sheet template in Excel is the most common format for small businesses because Excel handles the accounting equation formula natively and makes it easy to compare multiple periods side by side in separate columns or tabs. You can set up conditional formatting to flag instantly if the two sides of the balance sheet are out of balance.
A Google Sheets balance sheet template is the better choice if you want free cloud storage, easy sharing with a bookkeeper or accountant, and no software license cost. The template on this page works in both formats. Simply copy the layout, create a column for amounts, and add SUM formulas for each subtotal row. The final check is a simple formula: if Assets minus (Liabilities plus Equity) equals zero, the sheet balances.
- Google Sheets: free, auto-saves to Drive, shareable link for accountants or lenders
- Excel: powerful conditional formatting, pivot tables, and multi-tab period comparisons
- Word or Google Docs: suitable for simple businesses with very few line items
- PDF: the standard format for submitting to banks, investors, or accountants
Common Balance Sheet Mistakes to Avoid
The most common mistake is forgetting to include accounts receivable as an asset. Money that customers owe you but have not yet paid is a real asset, and leaving it out understates your assets and overstates the appearance of a cash-heavy or cash-poor business. Similarly, if customers have paid you in advance for services not yet delivered, that deferred revenue belongs on the liabilities side, not in revenue.
Another frequent error is not accounting for depreciation. If you bought a vehicle or computer for $10,000 two years ago, it is not worth $10,000 on the balance sheet today. Depreciation reduces the book value of assets over their useful life, and ignoring it overstates total assets. Your accountant can help you set the right depreciation schedule for each asset type.
- Include accounts receivable as a current asset, even if payment is not yet collected
- Record deferred revenue as a liability, not as income, until the service is delivered
- Apply accumulated depreciation to fixed assets to show realistic net book value
- Separate personal and business assets completely to avoid distorting the balance sheet
- Reconcile accounts receivable and accounts payable balances against actual invoices monthly
- Ensure the balance sheet date matches the period covered by your profit and loss statement
Copy-and-paste template
Download .xlsxBALANCE SHEET
Business Name: [YOUR BUSINESS NAME]
As of: [DATE]
Prepared by: [YOUR NAME]
ASSETS
Current Assets
Cash and Cash Equivalents: $[AMOUNT]
Accounts Receivable: $[AMOUNT]
Inventory: $[AMOUNT]
Prepaid Expenses: $[AMOUNT]
Other Current Assets: $[AMOUNT]
Total Current Assets: $[SUBTOTAL]
Non-Current Assets
Property and Equipment (gross): $[AMOUNT]
Less: Accumulated Depreciation: ($[AMOUNT])
Net Property and Equipment: $[AMOUNT]
Intangible Assets: $[AMOUNT]
Other Long-Term Assets: $[AMOUNT]
Total Non-Current Assets: $[SUBTOTAL]
TOTAL ASSETS: $[CURRENT + NON-CURRENT]
LIABILITIES
Current Liabilities
Accounts Payable: $[AMOUNT]
Accrued Expenses: $[AMOUNT]
Short-Term Debt / Current Portion of Long-Term Debt: $[AMOUNT]
Deferred Revenue: $[AMOUNT]
Other Current Liabilities: $[AMOUNT]
Total Current Liabilities: $[SUBTOTAL]
Non-Current Liabilities
Long-Term Debt: $[AMOUNT]
Deferred Tax Liabilities: $[AMOUNT]
Other Long-Term Liabilities: $[AMOUNT]
Total Non-Current Liabilities: $[SUBTOTAL]
TOTAL LIABILITIES: $[CURRENT + NON-CURRENT]
OWNER EQUITY
Owner Capital / Common Stock: $[AMOUNT]
Retained Earnings: $[AMOUNT]
Current Period Net Income: $[AMOUNT]
Total Owner Equity: $[SUBTOTAL]
TOTAL LIABILITIES + OWNER EQUITY: $[MUST EQUAL TOTAL ASSETS]