Book Consultation

Gondaliya CPA

Gondaliya CPA Professional Corporation logo
100% Canadian Owned badge
Menu
Free Template · Excel · Canadian Small Business 2026

Free Small Business Bookkeeping Template (Excel)

A ready-to-use Excel bookkeeping template for Canadian businesses. Record income and expenses on one sheet and watch your monthly profit and HST position calculate automatically. Built by a licensed CPA, with drop-down categories, an HST tracker and a profit-and-loss summary already wired in.

Free to download and use. This template is a practical bookkeeping tool, not tax or accounting advice. Your filing obligations and HST registration depend on your own situation. Please reach out and we are glad to help as your CPA.
Free Download

Get the Bookkeeping Template (Excel)

Enter your email and we will send you the editable Excel workbook right away. Five sheets, drop-down categories, automatic monthly profit and an HST tracker. No cost, no obligation.

Download the Free Template

What This Page Covers

1. What This Bookkeeping Template Does 2. What's Inside the Workbook 3. How to Use It, Step by Step 4. Why Bookkeeping Matters for Your Corporation 5. Common Bookkeeping Mistakes to Avoid 6. When to Hand It to a CPA 7. Download the Free Template 8. Frequently Asked Questions

1. What This Bookkeeping Template Does

This is a simple, practical Excel workbook for keeping your business books in order without accounting software. You enter each sale and expense on one sheet, and the rest of the workbook does the maths: it sorts your income and expenses by month, calculates your profit, and tracks the HST you have collected against the HST you have paid.

It is built for the owner who wants clean books they actually understand, not a complicated system. Everything you type goes in clearly marked blue cells. Every total is a formula that updates the moment you enter a row, so you always know where the business stands.

Clean books save you money at tax time. When your bookkeeping is current and accurate, preparing your year-end and your corporate return is faster and cheaper. When it is a shoebox of receipts, the books have to be rebuilt first, which costs more. This template keeps you on the right side of that line. Know Your Exact Fee →

2. What's Inside the Workbook

The template has five sheets that work together. You only ever type on one of them.

SheetWhat It Is For
Start HerePlain-language instructions, the colour rule, and what each sheet does.
TransactionsYour ledger and the only sheet you type on. One row per sale or expense, with drop-down categories and an automatic total.
Monthly SummaryIncome, expenses and net profit by month, plus a full-year breakdown of expenses by category, all calculated automatically.
HST TrackerHST collected on sales versus HST paid on expenses, by quarter, so you can see your net position before you file.
CategoriesThe income and expense category lists that feed the drop-downs. Edit them to match your business.

The colour rule keeps it simple. Type only in the blue cells. Black cells are formulas that calculate for you, and you never overwrite them. That one rule is the whole system; follow it and the workbook keeps itself accurate.

3. How to Use It, Step by Step

You can be up and running in a few minutes. Here is the order of operations.

StepWhat to Do
1. Delete the sample rowsThe Transactions sheet opens with five example rows so you can see how it works. Delete them and start fresh.
2. Enter each transactionOne row per sale or expense: date, type, category from the drop-down, a short description, the pre-tax amount and the HST.
3. Keep amount and HST separatePut the pre-tax amount in one column and the HST in the next. This keeps your filing clean and your profit accurate.
4. Read your numbersOpen the Monthly Summary and HST Tracker any time. They update automatically; you never type on them.
5. Set the yearEach summary sheet has one yellow year cell. Change it to roll the reports to a new year.
6. Send it to us at year-endWhen it is time to file, send us the workbook. Clean books mean a faster, more affordable return.

Record transactions as they happen, not at year-end. The single biggest reason books fall apart is leaving everything to the last minute. A few minutes each week keeps the workbook current, your HST visible, and your year-end painless. If you are already behind, we can catch you up. Catch-Up Bookkeeping →

4. Why Bookkeeping Matters for Your Corporation

Bookkeeping is not optional paperwork. For a Canadian corporation it is the foundation of every filing you make, and the law requires you to keep proper records.

ReasonWhy It Matters
It is legally requiredCanadian businesses must keep adequate books and records, and retain them for at least six years from the end of the tax year they relate to.
It feeds your T2 and HSTYour corporate return and HST filings are built directly from your books. No clean books, no accurate filing.
It protects every deductionA legitimate expense you cannot support with a record can be denied. Good books capture the deductions you are entitled to.
It keeps you audit-readyIf the CRA reviews you, organized records make it routine. Weak records turn a review into a problem.
It shows if you are profitableYou cannot manage what you do not measure. The summary tells you, month by month, whether the business is making money.
It supports financingLenders want current figures. Books that are up to date make credit and renewals far easier.

Bookkeeping is where your financial statements and tax return begin. The numbers on your year-end statements and your T2 come straight out of your books. That is why getting the bookkeeping right, even in a simple template like this, pays off all the way down the line. Bookkeeping Services →

5. Common Bookkeeping Mistakes to Avoid

The same handful of errors cause most of the bookkeeping problems we see. This template is designed to steer you away from them, but they are worth knowing.

MistakeWhy It Hurts
Mixing business and personalRunning personal spending through the business muddies the books and invites CRA questions. Keep a separate business account.
Leaving it all to year-endA year of receipts dumped in March is slow and costly to reconstruct, and deductions get missed.
Not separating HSTLumping HST into the expense amount distorts your profit and complicates your filing. Always record it separately.
No receipts keptAn entry with no supporting receipt can be denied on review. Keep the document behind every line.
Guessing categoriesInconsistent categories make the summary meaningless. Use the drop-down list and stay consistent.
Never reconciling to the bankIf the books do not match the bank, something is missing or double-counted. Compare regularly.

A template is only as good as the habit behind it. The workbook does the maths, but it cannot enter the transactions for you or keep your receipts. Treat it as a weekly five-minute routine and it will keep your business clean and your year-end cheap. Fall behind and even the best template cannot save the time.

6. When to Hand It to a CPA

This template will carry many small businesses comfortably. There are points, though, where bringing in a CPA saves you money and risk rather than costing you.

SituationWhy a CPA Helps
Year-end and your T2Your corporate return, financial statements and the GIFI should be prepared by a CPA from your books.
HST filingWe confirm your filing frequency, method and input tax credits so the remittance is right.
PayrollSource deductions, T4s and remittances have strict rules and deadlines that are easy to get wrong.
You have fallen behindIf the books are months or years out of date, we reconstruct and reconcile them before filing.
Growth or complexityAs transactions, staff or accounts grow, software and a CPA become worth the move.
A CRA letter arrivesIf the CRA reviews or queries you, organized books plus CPA representation make it manageable.

We work on fixed flat fees, no hourly billing. Whether you need the year-end done, HST filed, or the books caught up, you know the price up front. Most AFFORDABLE CPA for business clients in Canada. Book a free consultation →

Free Download

Download the Bookkeeping Template

Enter your email and we will send you the editable Excel workbook, ready to use, with drop-down categories, an automatic monthly profit summary and an HST tracker built in. Free, with no obligation.

Get the Free Template

Frequently Asked Questions

Is this bookkeeping template really free?
Yes. The template is completely free to download and use. Enter your email and we send you the editable Excel workbook at no cost and with no obligation. It is a genuine resource, not a trial or a paywall.
What format is the template?
An editable Microsoft Excel workbook (.xlsx). It opens in Excel and in free alternatives like Google Sheets or LibreOffice, though the formulas and drop-downs work best in Excel.
Do I need accounting software to use it?
No. That is the point. The template is a self-contained workbook for businesses that want clean books without paying for software. As your business grows, moving to accounting software becomes worthwhile, and we can help you make that transition.
Is this tax or accounting advice?
No. It is a practical bookkeeping tool. Your filing obligations, HST registration and tax treatment depend on your own situation. We are glad to advise on those as your CPA, but the template itself is an educational resource, not advice.
How do I start using it?
Open the workbook, read the Start Here sheet, delete the five sample rows on the Transactions sheet, and begin entering your own transactions in the blue cells. The summary and HST sheets update automatically as you type.
Which cells do I type in?
Only the blue cells, which are all on the Transactions sheet plus the yellow year cell on each summary. Black cells are formulas that calculate for you. The colour rule keeps the workbook accurate, so never overwrite a black cell.
Does it calculate my profit automatically?
Yes. The Monthly Summary sheet shows income, expenses and net profit by month, plus a full-year breakdown of expenses by category. It all calculates from your Transactions entries with no input from you.
Does it track HST?
Yes. The HST Tracker shows HST collected on sales against HST paid on expenses, by quarter, with a net position and year total. It helps you see what you may owe or be refunded before you file, as long as you record HST in its own column.
Why do I keep the amount and HST in separate columns?
So your profit and your HST are both accurate. The pre-tax amount drives your income and expense totals; the HST drives the tracker. Lumping them together distorts your profit and makes your HST filing harder. Keep them apart.
Can I add or change the categories?
Yes. The Categories sheet holds the income and expense lists that feed the drop-downs. Edit them to match your business, and the drop-downs on the Transactions sheet update to match. Stay consistent so your summary stays meaningful.
How many transactions can it hold?
The Transactions sheet comes with several hundred pre-formatted rows, which is plenty for most small businesses for a year. If you need more, you can extend the sheet, and at higher transaction volumes accounting software starts to make sense.
Can I use it for more than one year?
Yes. Each summary sheet has a year cell you change to roll the reports forward. Many owners keep a separate copy of the workbook per fiscal year, which keeps each year's records clean and self-contained.
Is bookkeeping legally required for my corporation?
Yes. Canadian businesses must keep adequate books and records and retain them for at least six years from the end of the tax year they relate to. This template helps you meet that obligation in an organized way.
Will clean books really lower my accounting fees?
Yes. When your books are current and accurate, your year-end and corporate return are faster to prepare, which keeps the cost down. When the books are a backlog, they must be rebuilt first, which adds time and fee. Good bookkeeping pays for itself.
What if I have already fallen behind?
It is fixable. You can use the template to catch up yourself, or we can reconstruct and reconcile the backlog and bring your books current before filing. The sooner it is done, the lower the cost and the smaller the risk. Catch-Up Bookkeeping →
Should I keep my receipts as well?
Yes, always. The template records the transactions, but you must keep the receipts and invoices behind them. On a CRA review, an entry without a supporting document can be denied. Store your receipts, digital or paper, alongside the workbook.
Can I use it if I am not HST registered?
Yes. If you are not registered, simply leave the HST column blank and the tracker stays at zero. The income, expense and profit summaries work exactly the same. When you cross the registration threshold, the HST tracking is ready for you.
Does it work for a sole proprietor too?
Yes. Although we serve incorporated businesses, the template works for any small business that needs to track income, expenses and HST. The bookkeeping fundamentals are the same whether you are incorporated or a sole proprietor.
Will you file my taxes from this template?
We can. Send us the completed workbook at year-end and we prepare your financial statements and corporate return from it, on a fixed flat fee. Clean books in this format make that work efficient and affordable.
Can the template handle payroll?
It is not a payroll system. You can record wages paid as an expense, but source deductions, T4s and remittances have their own rules and deadlines. We handle payroll as a separate service when you need it.
How often should I update the books?
Weekly is ideal. A few minutes each week keeps the workbook current, your HST visible and your year-end painless. The worst approach is leaving everything to the last minute, which is how books fall apart and deductions get lost.
Does it reconcile to my bank account?
Not automatically. You should compare your recorded transactions to your bank statements regularly to make sure nothing is missing or double-counted. The template gives you the ledger; reconciling it to the bank is a habit worth keeping.
Can two people use the same workbook?
You can share the file, but only one person should edit it at a time to avoid overwriting each other's entries. For multi-user, real-time bookkeeping, cloud accounting software is the better fit, and we can help you set it up.
Will my email be kept private?
Yes. We use your email to send the template and occasional relevant updates. We do not sell or share it, and you can unsubscribe any time. You are also welcome to reach out directly with any question about your business.
What is the GIFI and does this template produce it?
The GIFI is the standardized format the CRA uses to capture your financial statement figures on the T2. This template does not produce the GIFI directly, but its clean income and expense totals are exactly what a CPA needs to prepare it for your return.
Can I use it on a Mac?
Yes. The workbook opens in Excel for Mac and works the same way. It also opens in Google Sheets and LibreOffice, though for the drop-downs and formulas to behave exactly as designed, Excel is recommended.
Does the template separate income and expenses for me?
Yes. You tag each row as Income or Expense from the drop-down, and the summary sorts them automatically into totals, profit and the category breakdown. You do not have to build any reports yourself; the tagging does it.
What if I make a mistake in a row?
Just correct the blue cell and every total updates instantly. Because the summaries are formulas, fixing an entry fixes the reports automatically. There is nothing to recalculate by hand.
Is this enough on its own for my corporate taxes?
It is an excellent foundation, but the corporate return, financial statements and HST filing should be prepared by a CPA from these books. The template keeps the records the CPA needs; the filing is the professional step on top of it.
How do I get help setting up my bookkeeping properly?
Book a free consultation. We will look at your business, set you up with the right bookkeeping approach, and handle the year-end and filings on fixed flat fees. Most AFFORDABLE CPA for business clients in Canada. Book a free consultation →

Keep Clean Books, File With Confidence

We handle bookkeeping, HST and year-end corporate returns on fixed flat fees, and we will tell you honestly what you need. Most AFFORDABLE CPA for business clients in Canada.

Book Free Consultation
Scroll to Top