Canada Bookkeeping Spreadsheet Template

What a Canada bookkeeping spreadsheet is for

Most small business owners do not need accounting software in their first years, but they do need records that turn into a tax return without a week of sorting receipts in April. The Canada Revenue Agency's Form T2125 asks for your income and your expenses grouped into specific numbered lines, with meals limited to 50%, vehicle and home costs reduced to their business share, and capital purchases kept out of expenses altogether. If your records are organized that way from the first entry, year-end becomes a matter of copying totals.

This workbook is built for that. Every expense you enter is assigned to its T2125 line from a drop-down list, and the deductible amount is worked out as you go, including the 50% meals limit, partial business use, and the right treatment of GST/HST depending on whether you are registered. A vehicle logbook, a home office calculator, a GST/HST return worksheet and a monthly profit view are included, and a summary sheet fills in every T2125 line for you.

When to use it

Use it from the first day of your tax year if you are a sole proprietor: freelancers, consultants, tradespeople, home-based businesses, online sellers and side businesses all report on Form T2125. It works whether or not you are registered for GST/HST, and it handles one business for one calendar year per copy.

It is not designed for incorporated businesses, which file a corporate T2 return and keep full double-entry books, or for businesses carrying significant inventory, payroll or many assets, where accounting software and an accountant are worth the cost. Partnerships can use it to keep the partnership's records but should have an accountant prepare the allocation.

What's inside

The full list of sections and fields in this template, in the order they appear.

1. Start Here

   • Business name
   • Tax year
   • GST/HST registration setting
   • Registration number
   • Reporting period
   • Instructions

2. T2125 Summary

   • Line 8000 adjusted gross sales
   • Line 8230 other income
   • Line 8299 gross income
   • Every Part 4 expense line
   • Line 9936 CCA
   • Line 9368 total expenses
   • Line 9369 net income
   • Line 9945 business-use-of-home with loss limit
   • Uncategorized expense check

3. Income

   • Date
   • Invoice number
   • Customer
   • Description
   • Type
   • Amount before tax
   • GST/HST collected
   • PST collected
   • Total
   • Date paid

4. Expenses

   • Date
   • Vendor
   • Description
   • T2125 category list
   • Amount before tax
   • GST/HST paid
   • PST paid
   • Business-use percentage
   • Payment method
   • Receipt kept
   • Deductible amount with 50% meals limit
   • Input tax credit

5. Vehicle

   • Odometer readings
   • Business kilometres
   • Business-use percentage
   • Vehicle costs
   • Line 9281 deductible amount
   • Business trip log

6. Home Office

   • Workspace and total area
   • Business-use percentage
   • Home costs
   • Business share

7. Assets

   • Date bought
   • Description
   • Likely CCA class
   • Cost
   • GST/HST paid
   • Business use
   • Disposal and proceeds

8. GST-HST

   • Period dates
   • Line 101 sales
   • Line 103 tax collected
   • Lines 104 and 107 adjustments
   • Line 106 input tax credits
   • Line 109 net tax

9. Monthly

   • Income
   • Deductible expenses and profit for each month
   • Year total

10. User Guide

    • Sheet-by-sheet instructions
    • Registration setting
    • Income and expense rules
    • Vehicle and home office
    • GST/HST
    • Year-end checklist
    • Deadlines and record keeping

Preview pages

How to set it up and use it

1. Fill in Start Here. Enter the business name and tax year, and choose whether you are registered for GST/HST. This one setting changes how every expense is calculated.
2. Record every sale on Income. Enter the amount before tax and the GST/HST and PST you charged in their own columns.
3. Record every purchase on Expenses. Choose the T2125 line, enter the amounts from the receipt and set a business-use percentage for anything partly personal.
4. Keep the vehicle log. Record your odometer at the start of the year, log business trips as they happen, and enter vehicle costs on the Vehicle sheet rather than on Expenses.
5. Fill in Home Office once a year. Enter your workspace and total home area and the year's home costs, if you qualify.
6. Put equipment on Assets. Computers, furniture, tools and vehicles go here because they are claimed as capital cost allowance.
7. File GST/HST returns from the GST-HST sheet. Enter the period dates and copy lines 101 to 109 into your return.
8. Watch the Monthly sheet. It shows income, expenses and profit for each month, which helps with setting money aside for tax.
9. Copy the T2125 Summary at year-end. Check that the uncategorized count is zero, add capital cost allowance at line 9936, and transfer the amounts to Form T2125.

Example: a few entries and the summary

A fictional graphic designer in Ontario, registered for GST/HST, records these entries in March and April 2026:

Income: 2026-03-04, invoice 1042, logo package, Sales, $1,000.00 before tax, HST $130.00. Expense: 2026-03-10, client lunch, 8523 Meals and entertainment, $100.00 before tax, HST $13.00. Deductible amount: $50.00. Input tax credit: $13.00. Expense: 2026-04-02, social media ads, 8521 Advertising, $200.00 before tax, HST $26.00. Deductible amount: $200.00. Expense: 2026-04-20, phone plan, 9270 Other expenses, $80.00, business use 50%. Deductible amount: $40.00.

The lunch is halved by the meals rule, the HST on all three purchases is left out of the deductible amounts because the designer claims it back as input tax credits, and the phone plan counts only at its business share. On the T2125 Summary, line 8521 shows $200.00, line 8523 shows $50.00 and line 9270 shows $40.00, and the GST-HST sheet shows $130.00 collected against $39.00 of input tax credits for the period.

Canadian rules to know

These are the federal rules the workbook follows. CRA guide T4002 explains each T2125 line in detail.

• Form T2125. Sole proprietors report business income and expenses on it, using the numbered lines this workbook mirrors (line numbers from the 2025 edition of guide T4002).
• Meals and entertainment. Limited to 50% of the lesser of the amount spent and a reasonable amount, with exceptions such as meals billed to clients.
• Business use. Only the business share of mixed-use expenses, vehicles and homes is deductible; keep a vehicle logbook.
• Business use of home. Allowed when the workspace is your principal place of business, or is used only for business and for meeting clients regularly. It cannot create or increase a loss; the excess carries forward.
• Capital purchases. Claimed as capital cost allowance by class, not as expenses.
• GST/HST. Registrants claim GST/HST paid as input tax credits; small suppliers with $30,000 or less in taxable sales do not have to register.
• Deadlines. Self-employed individuals file by June 15, but any balance owing is due April 30.
• Records. Keep records and receipts for six years from the end of the last tax year they relate to.

Mistakes that cost small businesses at tax time

The most common bookkeeping mistakes are simple and expensive. Meals claimed at 100%, a new laptop written off as an office expense instead of through capital cost allowance, vehicle costs claimed without a logbook, GST/HST counted both as an expense and as an input tax credit, and personal purchases mixed in with business ones are all red flags in a review. Sales recorded with tax included overstate income. The workbook's categories, automatic limits and uncategorized check are there to catch each of these as you go, instead of in April.