Portfolio Software for Financial Advisors in Canada: Registered Accounts, T1135 and US Withholding
Published by 
Steffan Kharmaaiarvi, founder
A Canadian client's portfolio is rarely one account. It is an RRSP, a TFSA, a taxable account holding US-listed ETFs, perhaps a US IRA, and often a plan to retire elsewhere. Canadian tax treats each differently. This note is for independent advisors and small firms in Canada: the questions a Canadian review raises, what Borderfolio for Advisors screens, a worked example and where it stops. Every figure it produces is a screening estimate for professional review, not tax advice.
Who it is for
Independent advisors and boutique firms in Canada whose clients hold investments across registered and non-registered accounts, at more than one broker, in Canadian and US dollars. It fits best where clients arrived from abroad, plan to leave, or are US citizens. Borderfolio sits beside your existing systems: it is not a CRM, custody platform or consolidation-and-billing system, and it never recommends or trades.
The questions a Canadian review raises
- Where does the 15% US withholding fall? It depends on the account and on the fund's structure, not only on whether a holding is "American".
- Is a T1135 due? The test runs on cost rather than value, outside registered plans, at each purchase's exchange rate.
- Is the adjusted cost base right? Return of capital, reinvested distributions and superficial losses all move it.
- What did the client own on arrival? A new resident is deemed to acquire their property at fair market value on that day.
- What happens if they leave? Departure tax, Part XIII withholding on Canadian income afterwards, and the forms for both.
- How large is the US estate exposure, once the Canada–US treaty is applied?
What Borderfolio screens for a Canadian resident
Each item is a finding on the Cross-Border tab with its source and limits. Canada is covered in depth; see countries and coverage.
- Registered accounts as wrappers. Mark an account as an RRSP/RRIF, LIRA, LIF, TFSA, FHSA, RESP or RDSP and every calculation uses that plan's rates. See tax wrappers.
- Canadian dividends at home. The top-bracket tax on eligible Canadian dividends against foreign dividends and interest, province by province, from the federal gross-up and dividend tax credit and each province's credit, beside the client's own Canadian and foreign dividends. See cross-border findings.
- US withholding by account and fund structure. A US-listed fund or share in an RRSP or RRIF is exempt under Article XXI(2) of the treaty; in a TFSA or FHSA the 15% is lost; in a taxable account it is credited. A Canadian-listed ETF reaches US shares through US ETFs, so 15% is taken inside the fund in every account and recovered only in a taxable account, through the T3 slip. An Irish fund's withholding is recovered nowhere. That an RRSP's exemption does not reach a Canadian fund is a reading of the treaty, and the finding labels it so (cross-border findings; background in US vs Irish-domiciled ETFs).
- T1135. The cost of non-Canadian holdings outside registered accounts against CAD 100,000, with the simplified method below CAD 250,000. Cost is the adjusted cost base from confirmed transactions, each purchase at its own date's exchange rate. See Form T1135 for Canadian advisers.
- Adjusted cost base. The average cost of identical properties, from confirmed transactions. For catalogued Canadian ETFs (iShares XEQT, XAW, XUU, XUS, XSP, XIC; Vanguard VEQT, VFV, VXC, VCN) it includes return of capital and reinvested distributions from the issuers' annual tax breakdowns. The superficial-loss rule (30 days, section 54) is applied to the client's own trades.
- Values on arrival. For a client who became resident, the holdings held that day are listed; you enter each value from the statement for that date, and it becomes the cost in every screen.
- Departure tax on a planned move. Holdings in taxable accounts are taken as sold at market value: the deemed gain, the taxable half, and the filings: T1243, T1161 above CAD 25,000, and the optional T1244 deferral with security above CAD 16,500 of federal tax. Registered plans are left out, and property owned on arrival is excluded after a stay of 60 months or less. See relocation planning and planning a client's relocation.
- Canadian withholding after leaving. Part XIII rates under the destination's treaty on Canadian dividends, RRSP/RRIF payments and fund capital-gains distributions (15%), with NR301, NR4 and the section 217 election.
- US estate tax under the treaty. The USD 1.2 million small-estate rule and the pro-rated unified credit, using the total wealth on file. See US estate tax for Canadian residents.
- US citizens in Canada. Cost in CAD and USD side by side, a PFIC screen, FBAR and Form 8938 thresholds, and US retirement accounts: a traditional IRA is a foreign retirement arrangement, and a Roth IRA needs a one-time treaty election by the filing due date of the year residence started. See portfolio software for advisors to US citizens abroad.
A worked example
Illustrative round figures, not a real client. A Canadian resident holds US equity in four places, and each position pays CAD 1,000 of US-source dividends a year:
| Holding | Account | US withholding | What happens to it |
|---|---|---|---|
| US-listed S&P 500 ETF | RRSP | CAD 0 | Exempt under the treaty |
| US-listed S&P 500 ETF | TFSA | CAD 150 | Lost |
| US-listed S&P 500 ETF | Non-registered | CAD 150 | Credited against Canadian tax |
| Canadian-listed ETF holding US ETFs | RRSP | CAD 150 | Taken inside the fund, lost (a reading of the treaty) |
- Lost each year: CAD 300, in the TFSA and through the Canadian-listed fund in the RRSP. Credited: CAD 150, in the taxable account.
- Same exposure, three outcomes. Whether to change which account holds what depends on contribution room and the client's plans; that judgement stays with you.
- T1135 on the same file. If the non-registered ETF cost USD 60,000 at 1.30 CAD per USD, that is CAD 78,000, below CAD 100,000; the registered holdings do not count.
What it does not do
- It prepares no returns or forms (T1135, T1243, T1161, NR301), and it does not compute the departure tax itself, which depends on the client's marginal rate.
- Values on arrival are your entry from the statement; they are never inferred.
- Superficial losses caused by purchases of an affiliated person, such as a spouse, are not on file. A Canadian ETF outside the catalogue is named, and its ACB excludes return of capital and reinvested distributions.
- Bank accounts and property outside the accounts on file do not enter the T1135 total.
- US tax for US citizens (returns, PFIC elections, state tax) is not computed.
- It does not recommend, rebalance or trade. The cross-border documentation lists every limit.
How it fits beside your existing systems
Borderfolio for Advisors is a cross-border intelligence layer, not a replacement for your CRM, platform, back office or planning software. Client data reaches it in two ways today. Brokerage statements are uploaded as PDF, CSV, XLSX or images: exports from 15 brokers are read by format-specific parsers, other statements go through an extraction model, and every import is reviewed before anything is confirmed (importing statements). Accounts at Interactive Brokers (Flex) and Freedom24 can instead be connected to the broker's read-only API; synced holdings land unconfirmed and go through the same review (connect a broker). Connections to adviser systems such as Intelliflo and NDEX are in development and are not live.
Your CRM and planning software stay where they are; Borderfolio adds the cross-border review, current-versus-proposed scenarios that never change actual holdings, and a client-ready PDF built from a stored snapshot.
Frequently asked questions
Does Borderfolio treat RRSPs, TFSAs and FHSAs differently?
Yes. Each is a tax wrapper set on the account. US-listed holdings in an RRSP or RRIF are exempt from US withholding under the treaty; in a TFSA or FHSA the 15% is lost. Registered accounts are left out of the T1135 test and of departure tax.
How does it calculate the adjusted cost base?
From confirmed transactions, using the average cost of identical properties with each purchase at its own date's exchange rate. For ten catalogued Canadian ETFs it adds return of capital and reinvested distributions from the issuers' annual tax breakdowns, and it applies the 30-day superficial-loss rule to the client's own trades.
Can it estimate departure tax?
It shows the deemed gain on holdings in taxable accounts, the half that is taxable and the forms to file (T1243, T1161, T1244). The tax itself depends on the marginal rate and is not computed.
Is this tax advice?
No. Every figure is a screening estimate for an advisor's professional review, shown with its assumptions and sources.