Balance sheet template

Assets, liabilities and equity in one sheet, with a check cell that tells you if something is off.

Tally the receipt with a download arrow

Download the template (.xlsx)

A balance sheet shows what your business owns, what it owes and what’s left for the owners on a single date. This free balance sheet template in Excel totals assets, liabilities and equity for you, and a check cell shows whether the two sides agree.

What’s in the template

The sheet rests on one equation: assets equal liabilities plus equity.

Section What it covers Examples
Assets What the business owns Cash, receivables, inventory, equipment
Liabilities What the business owes Payables, credit cards, GST/HST, loans
Equity The owners’ share Capital, retained earnings, this year’s profit

Assets and liabilities are split into current and long-term. Current generally means due or expected to turn into cash within a year. There are two columns, this year and last year, so you can compare them. Each works on its own, so leave last year blank if this is your first one.

How to use it

  1. Fill in your business name and the “as at” date, usually your year-end.
  2. Enter balances from your bookkeeping as at that exact date. Your bank balance should come from a reconciled account, not a guess.
  3. Enter accumulated amortization, and drawings or dividends, as negative numbers.
  4. Enter net profit for the year from your profit and loss statement.
  5. Look at the check cell at the bottom.

The check cell

The check cell subtracts total liabilities and equity from total assets. The result should be 0.00, and the line below it will read “Balances”. If it reads “Does not balance”, the figure shows how far out you are.

That amount is a clue. If it matches a number on the sheet, you may have missed that line. If it’s double a number, that line probably has the wrong sign.

A zero means the two sides agree. It doesn’t prove each number is right. Two errors can cancel out, and an amount in the wrong account still balances.

What belongs under GST/HST payable

Use one line for the net amount: the GST/HST you collected minus your input tax credits. An input tax credit is the credit a registrant claims to recover GST/HST paid on purchases used in its business. If you’ve overpaid and are due a refund, the amount shows as a negative here, or you can move it to assets. Our chart of accounts template keeps the two sides in separate accounts, so the net figure is easy to work out.

Common mistakes

  • Mixing dates. Every balance must be as at the same day. A bank balance from today and receivables from last month won’t agree.
  • Forgetting the current year’s profit. Equity needs retained earnings at the start of the year plus this year’s profit, less anything paid out.
  • Treating the shareholder loan as equity. Money moved between a corporation and its owner goes on its own line. In this template it’s under long-term liabilities. Depending on the direction, it can be an asset instead, and it can have tax consequences, so ask a professional if the balance is large.
  • Leaving out what’s owed to CRA. Sales tax, payroll deductions and income tax payable are all liabilities until they’re paid.
  • Listing equipment at today’s value. Book equipment at cost, then show the wear to date in accumulated amortization. CRA’s tax version is capital cost allowance, which is a separate calculation.
  • Rounding to force a balance. A plug figure hides the error, and it will surface again next year.

Keep the finished statement and what supports it. CRA says records must be kept for six years from the end of the last tax year they relate to.

Sources

Behind on the numbers this sheet needs? Our catch-up bookkeeping can get them current.

General information, checked November 2026. Rules change, and your situation may differ.

Want help with this?

Tell us what you’re working on and where you need help. Choose an email reply or a callback.

Ask about this guide

Questions

What does a balance sheet show?

It shows what a business owns, what it owes and what's left for the owners on one specific date.

Why doesn't my balance sheet balance?

Usually a figure is missing, entered with the wrong sign, or taken from a different date. Check that drawings, dividends and accumulated amortization are negative, and that net profit matches your profit and loss statement.

How is a balance sheet different from a profit and loss statement?

A balance sheet is a snapshot of one date. A profit and loss statement covers a period, such as a month or a year.

Do corporations report a balance sheet to CRA?

Corporate balance sheet items are reported with GIFI codes, CRA's standard codes for financial statement items. CRA lists Schedule 100 for balance sheet information.

Keep reading

Have a question about your situation?

Send us an inquiry. You can choose an email reply or a callback.

Book a call