Free Balance Sheet Template (+ Tips & Tactics for Finance Savvy)

A balance sheet is one of the three core financial statements every business needs. Together with the income statement and cash flow statement, it gives you — and anyone evaluating your business — a complete picture of where you stand financially.

Download our free balance sheet template for Excel below. Then read on for a clear explanation of what goes into a balance sheet, how to read one, which financial ratios you can calculate from it, and what to watch out for when building yours.

What Is a Balance Sheet?

A balance sheet — also called a statement of financial position — is a financial statement that reports everything a company owns (assets), everything it owes (liabilities), and the remaining value that belongs to its shareholders (equity) at a specific point in time. It gives a financial snapshot of the business on that date: not a period of activity, but a single moment.

The entire balance sheet is built on one equation:

Assets = Liabilities + Equity

This equation must always balance — hence the name. If your total assets don’t equal the sum of your total liabilities and equity, there is an error in the data. Finding and fixing that error is part of the balance sheet review process.

A balance sheet supports company owners, investors, lenders, and other key stakeholders during financial analysis, bookkeeping, and strategic planning. When a bank evaluates a loan application, the balance sheet is one of the first documents they review. When investors assess a business, the balance sheet tells them how leveraged the company is and how much the ownership stake is actually worth.

3 Core Balance Sheet Elements

Assets

An asset is any resource that a company owns or controls and that has economic value. Assets are listed in order of liquidity — how quickly they can be converted into cash. They divide into two categories:

Current assets can be converted into cash within a year. They include:

• Cash and cash equivalents — money in bank accounts and short-term investments
• Accounts receivable — money owed to the business by customers for goods or services already delivered
• Inventory — goods held for sale or raw materials used in production
• Prepaid expenses — costs paid in advance, such as insurance premiums

Non-current assets (also called fixed assets or long-term assets) take longer than a year to convert into cash. They include:

• Property, plant, and equipment (PP&E) — land, buildings, machinery, and vehicles. Note: PP&E is listed at cost minus accumulated depreciation, which appears as a separate line item.
• Intangible assets — patents, trademarks, goodwill, and software that the company owns but that have no physical form
• Long-term investments — holdings in other companies or financial instruments not intended for short-term sale

Liabilities

A liability is anything the company owes to an outside party — suppliers, banks, employees, or government. Like assets, liabilities split into current and non-current:

Current liabilities are due within 12 months:

• Accounts payable — invoices from suppliers that haven’t been paid yet
• Short-term loans and notes payable — borrowings due within the year
• Accrued expenses — costs incurred but not yet paid (wages, utilities, interest)
• Income taxes payable — tax obligations due in the near term

Non-current liabilities are due beyond 12 months:

• Long-term bank loans — debt scheduled for repayment over multiple years
• Bonds payable — formal debt instruments issued to investors
• Pension benefit obligations — future payments owed to employees
• Long-term lease obligations — multi-year lease commitments

Equity

Equity is what’s left for shareholders after all liabilities are subtracted from total assets. It’s the net worth of the business — what the owners actually own, free and clear.

Equity typically includes:

• Share capital — funds invested by shareholders in exchange for ownership
• Retained earnings — cumulative profits that have been kept in the business rather than distributed as dividends. The retained earnings line connects the balance sheet to the income statement: net income from the current period adds to retained earnings; dividends or owner draws reduce it.
• Additional paid-in capital — amounts paid above par value when shares are issued

How the Balance Sheet Connects to Other Financial Statements

The balance sheet doesn’t stand alone. It’s one of three interconnected financial statements:

• The income statement (also called the profit and loss statement) reports revenues and expenses over a period — a month, quarter, or year. The net profit from the income statement flows directly into retained earnings on the balance sheet, updating equity at the end of each reporting period.
• The cash flow statement explains changes in the cash balance shown on the balance sheet. It reconciles net income with actual cash movement by accounting for non-cash items (depreciation), changes in working capital (accounts receivable, inventory, accounts payable), and investing or financing activities.
• The balance sheet shows the result of all that activity at a given point in time. Where the income statement and cash flow statement cover a period, the balance sheet covers a moment.

When you review all three together, you can see not just whether the business is profitable, but whether it’s generating cash, how it’s financing operations, and whether its financial position is strengthening or weakening over time.

Key Financial Ratios You Can Calculate from a Balance Sheet

The numbers on a balance sheet become most useful when you use them to calculate financial ratios. These ratios let you assess the health of the business in specific ways and compare performance across periods or against industry benchmarks.

• Current Ratio = Current Assets ÷ Current Liabilities
  Measures whether the business can cover its short-term obligations with short-term assets. A ratio above 1.0 means current assets exceed current liabilities. Below 1.0 indicates a potential liquidity problem.
• Working Capital = Current Assets − Current Liabilities
  The dollar amount of liquidity available for day-to-day operations. Positive working capital means the business can fund its operations without additional borrowing. Negative working capital is a warning sign.
• Debt-to-Equity Ratio = Total Liabilities ÷ Total Equity
  Shows how much the business is financed by debt versus owner investment. A high ratio signals more financial risk; lenders watch this closely when evaluating loan applications.
• Debt Ratio = Total Liabilities ÷ Total Assets
  Expresses what percentage of assets are financed by debt. A ratio of 0.5 means half the company’s assets are funded by creditors.
• Return on Equity (ROE) = Net Income ÷ Shareholders’ Equity
  Measures how efficiently the business generates profit from owners’ investment. This ratio uses both balance sheet data (equity) and income statement data (net income).

Adding these ratio calculations to your balance sheet template turns it from a reporting document into an analysis tool — one you can use to spot trends, compare periods, and make decisions based on numbers rather than instinct.

How to Create a Balance Sheet

1. Choose a reporting date. A balance sheet reports position at a specific point in time, not over a period. Common reporting dates are the last day of a month, quarter, or fiscal year. For comparative purposes, prepare balance sheets for two periods side by side.
2. List and value all assets. Start with current assets in order of liquidity (cash first, then receivables, then inventory, then prepaid expenses). Then list non-current assets. Record each at its current value — for PP&E, that means cost minus accumulated depreciation. Calculate subtotals for current assets, non-current assets, and total assets.
3. List and value all liabilities. Start with current liabilities (accounts payable, short-term loans, accrued expenses) and follow with non-current liabilities (long-term debt, leases, pensions). Calculate subtotals and total liabilities.
4. Calculate shareholders’ equity. Add share capital and retained earnings. For a simple business, retained earnings equals last period’s retained earnings plus current period net income minus any dividends or owner draws.
5. Verify the equation balances. Total Assets must equal Total Liabilities + Total Equity. If the numbers don’t match, there is a data error somewhere — a missing entry, a duplication, or an incorrect value. Review each line until the equation balances.
6. Reconcile against source records. Cross-check key balances against your general ledger, bank statements, and loan schedules. A balance sheet that balances mathematically but doesn’t reconcile to source records is not reliable.

How to Use Your Balance Sheet

A completed balance sheet supports several types of analysis and decision-making:

• Assess financial health. Calculate the ratios above to understand your liquidity, leverage, and efficiency. Compare current values to previous periods to spot whether the business is improving or deteriorating.
• Support loan applications. Lenders use the balance sheet to assess whether a business can service new debt. A strong current ratio and reasonable debt-to-equity ratio improve the chances of loan approval on favorable terms.
• Report to investors. Investors evaluate equity value and return on equity. A balance sheet showing growing retained earnings and manageable debt signals a well-run business.
• Model financial decisions. Before taking on new debt, making a large purchase, or distributing dividends, model how the transaction would affect your balance sheet. This prevents decisions that look good in isolation but weaken your financial position.
• Compare periods. A single balance sheet is a snapshot. Two balance sheets side by side — this year and last year — show movement. Sudden shifts in cash, receivables, or debt balances reveal trends worth investigating.

Common Balance Sheet Mistakes to Avoid

• Including projections or forecasts. A balance sheet reports historical fact. Projected figures belong in a financial model or forecast, not the balance sheet itself.
• Misclassifying current vs. non-current items. A loan that matures in 18 months is long-term. One that matures in 8 months is current. Getting this wrong distorts liquidity ratios and misleads anyone reading the statement.
• Omitting accumulated depreciation. Fixed assets must be shown at cost minus accumulated depreciation, not at original purchase price. Skipping this overstates the value of non-current assets.
• Not reconciling to source systems. If the cash balance on the balance sheet doesn’t match the bank statement, or the accounts receivable balance doesn’t match the AR ledger, the document can’t be trusted for decision-making or reporting.
• Treating the balance sheet as a one-time exercise. A balance sheet prepared once and never revisited provides limited value. Preparing it consistently — monthly or quarterly — lets you track trends and catch problems before they compound.