Income and investing
Investment Portfolio Tracker (Canada)
Investment tracker spreadsheet for Canadian investors with several accounts. Log each statement line once and see holdings, adjusted cost base (ACB), income, contributions and tax records for every TFSA, RRSP, FHSA, non-registered, crypto and cash account, at any brokerage.
C$14CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- Dashboard: total value, holdings at market, ACB, unrealized and realized gains, distributions, interest, withholding tax, fees, contributions, accounts at a glance and two charts
- Adjusted cost base (average cost, per account): buys with fees, sells, return of capital, reinvested distributions, stock splits and crypto fees. Units held, ACB per unit and realized gain or loss for every holding
- Market value and total return per holding from the prices you enter, with USD to CAD conversion
- Income by month and by year: distributions by account, interest, foreign withholding tax and fees
- Tax records for you and your tax preparer: taxable distributions split into return of capital and the rest, realized capital gains by account and year, a set-aside estimate, and TFSA, FHSA and RRSP contribution tracking with estimated room
- Cash flow: money moved into and out of each account by month
- Up to 12 accounts, 600 transactions and 400 trade-ledger rows. Pick the first year shown and the yearly tables cover it and the next two
How it works
- Type each statement line on the Transactions tab with a simple type code (BUY, SELL, DIV, INT, ROC, SPLIT and more) from a drop-down
- Rows that change a holding also get a Trade Ledger row: type the holding's block number and the transaction number, and the ACB maths happens there
- Prices are typed in on the Prices tab (no live quotes), so update them whenever you want fresh market values
What you get
- XLSXInvestment-Portfolio-Tracker.xlsx, filled with invented sample accounts and trades so you can see every tab working. Type your own data over it, or clear the blue input cells to start fresh
- PDFQuick-start guide (PDF)
Please note
A tracking and record-keeping tool, not investment, tax or legal advice. ACB uses the average-cost method per account; superficial-loss rules, identical-property pooling across accounts, foreign tax credits and provincial tax are not modelled. Contribution limits and tax rates in the file are editable sample values, so confirm your room in your government online account and use your tax slips for filing. For personal use; please don't resell or share the file.
Disclaimer
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
