Dividend Income Tracker for Canada (TFSA, RRSP & Taxable)

Name: Dividend Income Tracker for Canada (TFSA, RRSP & Taxable)
Brand: MyTaxCalculator.ca
SKU: MTC-DIVIDEND-INCOME-TRACKER-CANADA
Availability: InStock

Track dividend stocks and ETFs across your accounts, see yearly and monthly income and yield on cost, and estimate the dividend tax credit.

Free No sign-up, no email, no payment

Download free

MTC_Dividend_Income_Tracker_Canada_2026.xlsx· 21 KB

Opens in Excel, Apple Numbers and Google Sheets (File, then Import).

One-click download
Free, no subscription
Mac, PC & Mobile
100% Private & Offline

Canadian-Specific

Key Features & Capabilities

Designed specifically around Canadian payroll, tax forms, and account structures:

Holdings by account: TFSA, RRSP, FHSA, RESP or non-registered
Eligible, non-eligible and foreign dividends kept apart
Yearly income, monthly average and yield on cost for every holding
Tax estimate for your taxable account: gross-up (38% / 15%) and federal dividend tax credit
Matches the boxes on your T5 slip (24, 25, 26, 10, 11, 12)
Optional payment log with DRIP tracking

Complete Toolkit

What's Inside (4 Components)

Everything you receive immediately upon download:

How to use guide
Holdings (60 rows)
Dividend Log (300 rows)
Tax Estimate (T5 boxes)

Detailed Walkthrough

Know what your portfolio pays you

This free tracker totals your dividend income across every account and shows it per year and per month, with yield on cost for each holding.

How Canadian dividends are taxed

In a non-registered account, Canadian dividends are "grossed up" and then reduced by the dividend tax credit:

Eligible dividends (most TSX companies): grossed up 38%, federal credit 15.0198% of the grossed-up amount.
Non-eligible dividends (mostly private companies): grossed up 15%, federal credit 9.0301%.
Foreign dividends: no gross-up or credit; claim tax withheld as a foreign tax credit.

Dividends in a TFSA or RRSP aren't taxed in Canada, but US dividends in a TFSA lose 15% to US withholding tax. Your province adds its own dividend credit; our free dividend tax calculator includes it.

Target Audience

Who This Template Is For

Dividend investors building passive income

Anyone holding Canadian dividend stocks outside a TFSA or RRSP

Investors comparing yield across accounts

Frequently asked questions

What is the dividend gross-up in Canada?

Eligible dividends are grossed up by 38% and non-eligible dividends by 15%. You report the grossed-up amount, then claim the dividend tax credit.

Are dividends taxed in a TFSA?

Canadian dividends in a TFSA are tax-free. US dividends still have 15% US tax withheld, which you cannot recover in a TFSA.

Does it work in Google Sheets and on a Mac?

Yes. It is an Excel workbook (.xlsx) that opens in Excel for Windows and Mac, Apple Numbers, and Google Sheets (upload it to Drive, then open with Google Sheets). Formulas recalculate as you type.