Free Excel bookkeeping template for Canadian corporations
A complete bookkeeping system in one Excel workbook. Record your sales, purchases and bank activity, and it builds your ledger, financial statements and GST/HST return for you. You set your own GST or HST rate, so it fits every province and territory.
Three habits, and your books stay clean.
Set up once
Enter your company name, start date, bank accounts and owners on the Setup tab.
Record as you go
Type each sale and each receipt into the blue cells. The ledger and every report update on their own.
Check each month
Enter your statement balances to reconcile the bank. Each quarter, open the GST/HST Return tab and file.
Everything a small corporation needs, on connected tabs.
Built for corporations anywhere in Canada. You set your own GST or HST rate, and the corporate tax rates come filled in for Ontario so you can change them for your province.
Home
Your key numbers at a glance, with links to every tab
Sales
Invoices and client payments
Purchases
Receipts paid by bank, card or an owner
Journal
Transfers, GST/HST and loan payments, corrections
Mileage
Business kilometres in a personal car, at CRA rates
Banking
Match the books to your bank and card statements
Fixed Assets
Equipment and amortization
Tax & Dividends
Corporate tax estimate and dividends
Income Statement
Profit by month, with last year beside it
Balance Sheet
What the company owns and owes
Trial Balance
Every account balance on one date
GST/HST Return
Quarterly lines 101 to 109, ready to copy into your filing
Shareholder Loans
What the company owes each owner
Aged Receivables
Who owes you, and how late
Account Activity
Every transaction in any account
Year-End Close
A step-by-step closing checklist
Checks
Automatic health checks that flag mistakes
Ledger
The full general ledger, built for you
Custom modules and migration, built for your business.
The free workbook covers the core. When your business needs more, 2D Canada adds it on top, so you never have to start over.
Switching from other software? 2D Canada can migrate your books from QuickBooks, Xero, Sage, Wave, FreshBooks, Zoho Books and similar tools, including your chart of accounts, opening balances and history.
- Multi-currency
- Migration from QuickBooks, Xero, Sage, Wave and others
- Provincial sales tax (PST, QST)
- Payroll
- Timekeeping
- Accounts payable and receivable
- Advanced bank reconciliation
- Other year-ends
Enter your email and 2D Canada will send it to you.
Each copy is sent personally, usually within one business day.
Is it really free?
Yes. Enter your email and 2D Canada sends you the workbook, usually within one business day. There is no trial period and nothing to cancel.
Who is it for?
Small Canadian corporations with straightforward books: consultants, contractors, professionals and other owner-run companies who want clean records without paying for bookkeeping software every month.
Can it replace QuickBooks, Xero or Wave?
For a small corporation with simple needs, it can replace QuickBooks and similar software such as Xero, Sage, Wave, FreshBooks and Zoho Books. You record sales, purchases and bank activity, and the workbook builds the ledger, the statements and the GST/HST return. If you have payroll, inventory or several currencies, you will need a custom module or dedicated software.
Can 2D Canada move my books over?
Yes. 2D Canada offers a migration service: your chart of accounts, opening balances and history are moved from your current software into the workbook, so you can switch without starting from zero.
Does it work in my province?
Yes. It is built for corporations anywhere in Canada. You set your own GST or HST rate on the Setup tab. If your province also has a separate provincial sales tax (British Columbia, Saskatchewan, Manitoba or Quebec), 2D Canada can add that as a custom module. The corporate tax rates come filled in for Ontario, and you can change them for your province. The free version assumes a December 31 year-end.
What do I need to use it?
Microsoft Excel and basic comfort typing into a spreadsheet. You only type in the blue cells. Everything else is calculated for you.
Is this tax or accounting advice?
No. It is a record-keeping tool. Have your accountant review your books and file your returns, as you would with any bookkeeping software.
Can it be customized for my business?
Yes. Common add-ons are multi-currency, provincial sales tax, payroll, timekeeping, accounts payable and receivable, and advanced bank reconciliation.