Small Business Deduction Excel - Free Template

1. Enter each transaction on the input sheet with the date, amount, province, and category. Keep revenue, expenses, and investment income on separate lines so the summary stays readable.
2. Mark whether the item is active business income and whether it is eligible for the SBD. Use the Y/N fields consistently so the summary formulas work.
3. Check the HST rate column before posting the entry. Ontario should show 13%, while Quebec sales may need a different tax treatment because of QST.
4. Review the notes field for items that often need attention at year-end, such as owner-paid expenses, interest income, or recurring subscriptions.
5. Use the summary area to total eligible income and compare it against your corporate records before the T2 filing.
6. If you are updating the sheet monthly, copy the prior month’s tab and clear only the new transaction lines. That keeps your coding consistent and saves time.

If you run an incorporated consulting, trades, or professional services company, this sheet is most useful when invoices are coming in and you need to tag what counts toward the small business deduction. A contractor with 4 employees and $85,000 a month in billings can review each line before month-end instead of waiting until the T2 file is due.

When the work happens

Most owners use it during monthly bookkeeping, right after the bank feed is cleared and before the GST/HST return is prepared. A bookkeeper at a small agency might enter 300 orders a month, while an owner-manager may only have 25 to 40 transactions but still needs the same eligibility test.

What the rows tell you

The sheet lets you separate service revenue from items that do not belong in active business income, such as bank interest or rental income. That matters because one $1,250 interest entry does not get the same treatment as $8,500 of consulting fees.

Why this is useful in practice

You can see the province, HST rate, and notes on the same line, which helps when you are answering questions from the accountant or correcting a miscoded invoice. For a company selling into Ontario and Quebec, that keeps the tax trail clear before year-end.

The federal small business deduction is tied to active business income in a Canadian-controlled private corporation, and the commonly used small business limit is $500,000 of active business income. Once your taxable capital or associated-company limits start to matter, you need the worksheet to show which income belongs in the operating bucket and which does not.

HST and program-account details

If you are registered for GST/HST, you need the RT program account under your BN. Ontario sales generally use 13% HST, while New Brunswick, Nova Scotia, Prince Edward Island, and Newfoundland and Labrador use 15% HST; Quebec sales are handled differently because of QST.

Year-end recordkeeping

The CRA’s six-year record-retention rule means you should keep the source documents behind the worksheet, not just the totals. A line showing $6,200 of web design revenue is useful, but the invoice, deposit record, and tax coding are what protect you later.

Owner-manager planning

This is also the sheet you use when comparing salary and dividends before year-end. If a corporation earns $140,000 of active business income, the classification of each line affects the corporate tax file, the T2 return, and the personal tax planning that follows.

The same year-end review also leads straight into the GST/HST remittance record, where the tax coding behind each sale and payment has to be carried through to the amounts sent to the CRA.

The biggest mistake is putting passive income into the same bucket as active business income. If you add $12,000 of bank interest or rental income to operating revenue, your SBD view becomes misleading and you can overstate what qualifies for the deduction.

Misclassifying taxable items

Another problem is treating every deposit as business income. A $4,500 shareholder loan repayment or a GST refund is not the same as a service sale, and mixing them can distort the monthly total by thousands of dollars.

Ignoring HST on mixed files

When the HST rate is wrong, the ledger does not tie. A Toronto invoice at 13% on $8,500 should show $1,105 of HST, while a Quebec line may need a different tax treatment because of QST; if you post both as identical, your return and cash flow forecast drift apart.

Cost of a sloppy sheet

At year-end, that sloppiness turns into extra bookkeeping hours and a slower file for the accountant. Two or three hours of cleanup is common on a small file; on a busier corporation, it can become a full day of rework before the T2 is ready.

That same cleanup is why employees who tracked mixed costs often need a work expense statement before they can sort out what belongs on the return.

The easiest way to keep this sheet alive is to tie it to one fixed task, not to your general bookkeeping mood. Update it on the same day you do the bank reconciliation or the GST/HST filing, so the work happens 12 times a year instead of being forgotten after two weeks.

Simple habits that stick

• Copy the prior month’s tab and clear only the new transactions.
• Use the same Y/N choices every time so the summary formulas stay clean.
• Review the HST rate before you save the entry, especially for Ontario, Quebec, and Atlantic sales.
• Flag interest, rent, and owner-related items with a note so you do not chase them later.

When spreadsheet control is no longer enough

If you are pushing several hundred invoices a month, or you have multiple related corporations, the sheet will still help with review but not with full transaction processing. At that point, use accounting software for posting and keep this workbook as the SBD check before the T2 and year-end tax planning.