BusinessPlanHub

Free Balance Sheet Template for Excel

A balance sheet template is an Excel sheet that lists what your business owns and owes on a given date. This one is free, covers an opening balance plus twelve month-ends, and tells you when it does not balance.

Download the free template Arrange a free call

Free · Excel (.xlsx) · Works in Google Sheets · Includes a filled-in example

What is a balance sheet?

A balance sheet is a snapshot of what a business owns, what it owes and what is left for the owner on one date. It always follows one equation: assets equal liabilities plus equity.

It is also called a statement of financial position. Where the profit and loss statement covers a stretch of time, the balance sheet freezes a single day, usually a month-end.

What is in this balance sheet template?

The file has three sheets: How to use, Balance sheet and Example. The Balance sheet sheet has an Opening column plus twelve month-end columns.

SectionRowsWhat it shows
Current assetsCash, accounts receivable, inventory, prepaid expenses, otherWhat you own or are owed that turns into cash within a year
Long-term assetsProperty and equipment at cost, accumulated depreciation, otherWhat you keep for more than a year
Current liabilitiesAccounts payable, accrued expenses, sales tax, income tax, short-term debt, credit cardsWhat you owe within a year
Long-term liabilitiesLong-term loans, otherWhat you owe beyond a year
EquityOwner’s capital, retained earnings, profit for the year to date, less draws or dividendsThe owner’s stake
CheckAssets minus liabilities and equityMust be 0, and shows red if not
RatiosCurrent ratio, debt to equity, working capitalThe first numbers many lenders calculate

The Example sheet uses a made-up café. Its profit-to-date line matches the café’s profit and loss example, so you can see how the two statements connect. The figures are invented.

How do you fill in a balance sheet template?

You fill in the Opening column first, then one column at the end of each month.

  1. Type your business name and the month your year starts.
  2. Fill the Opening column with balances on the first day of the year.
  3. At each month-end, enter assets and liabilities from your bank statements and books.
  4. Enter profit for the year to date from your profit and loss statement.
  5. Read the check row. It must show 0 and Yes in every column.
  6. Read the three ratios at the bottom.

Enter accumulated depreciation as a positive number. The sheet subtracts it for you.

What does a lender or investor check on a balance sheet?

They check how much you owe, how soon it is due and whether your short-term assets can cover it. The ratios on this sheet are simple arithmetic on those questions.

  • Current ratio: current assets divided by current liabilities. A result below 1 means short-term bills exceed short-term assets.
  • Debt to equity: total liabilities divided by equity. It shows how much of the business is funded by borrowing rather than by the owner.
  • Working capital: current assets minus current liabilities. It is the cushion available for day-to-day running.

Many lenders look at these three. Each lender sets its own comfort level, so treat any number you read online as a rough guide, not a rule. Our guide to what SBA lenders look for in a business plan explains how a lender reads the whole package.

Profit from the P&L feeds equity, and cash from the cash flow forecast feeds the cash line. If either is wrong, the check row will not reach zero.

Closing cash on your cash flow forecast should match the cash and bank balances line for the same month. Net profit from the P&L accumulates into profit for the year to date. Together the three statements tell one story from three angles. The hub page explains the order to build them.

What are the common mistakes on a balance sheet?

Most balance sheets fail the check for a small, boring reason.

  • Profit does not match the P&L. This is the most common cause of a check that will not clear.
  • Depreciation entered as a negative. It goes in as a positive number and the sheet subtracts it.
  • Loan repayments in the wrong place. Split the part due within a year from the rest.
  • Forcing the balance. Never plug the difference into “other”. A forced balance hides the error you needed to find.
  • Mixing dates. Every figure must be from the same day.

What do we think the balance sheet is for?

We think it is the most skipped statement and the one that explains the most. A P&L can look healthy while the balance sheet shows a business borrowed to the limit, with customers slow to pay.

Our view is blunt: if you cannot make the check row show zero, you do not yet understand where your money is. That is useful to learn before a lender finds out for you. Fix the sheet, not the number.

For a full five-year projection with all three statements linked, see our financial model templates. For help presenting these figures in a plan, start with the business plan template or our financial forecasts service, and browse more free tools in the resources hub.

Get the file

Free. Enter your details and the download opens on this page.

Want to talk it through?

Arrange a free 30-minute call with BusinessPlanHub. Bring your plan, your forecast or the question you are stuck on.

Arrange a call →

Balance sheet template: common questions

What does it mean when the balance sheet check is not zero?

It means assets do not equal liabilities plus equity, so a figure is missing or in the wrong place. The usual cause is profit for the year to date not matching your profit and loss statement.

Do I need an opening balance for a brand-new business?

Yes, but it is short. A new business usually has only cash, any equipment bought, any loan and the owner's capital.

Where does the profit figure come from?

From your profit and loss statement. Enter profit for the year to date each month, and the balance sheet picks it up as part of equity.

Is a balance sheet the same as a statement of financial position?

Yes. Both names describe the same report, a snapshot of assets, liabilities and equity on one date.

Are the Example sheet figures real benchmarks?

No. They belong to a made-up café and exist so you can see the sheet filled in. Do not use them as targets.