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
- Fill in your business name and the “as at” date, usually your year-end.
- Enter balances from your bookkeeping as at that exact date. Your bank balance should come from a reconciled account, not a guess.
- Enter accumulated amortization, and drawings or dividends, as negative numbers.
- Enter net profit for the year from your profit and loss statement.
- 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
- CRA: preparing your financial statements using GIFI
- CRA: definitions for GST/HST
- CRA: where to keep your records and for how long
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