Not every Canadian broker offers one-click sync — and even when one does, you probably have accounts spread across two or three institutions. WealthWise's CSV import and manual entry features let you pull every account into a single view, so you can track your true total wealth, benchmark your real return against the S&P 500, and run dividend analysis across every holding you own — regardless of where it sits.
The typical Canadian DIY investor doesn't have just one account. There's a TFSA at Wealthsimple Trade, an RRSP that stayed at a bank brokerage, maybe an old employer group plan, and a non-registered account at Questrade opened during the pandemic. Each platform shows you its own slice. None of them shows you the whole picture.
That fragmentation means you can't easily answer questions like: What is my true sector exposure when you add everything together? How much passive dividend income do I actually generate each month across all accounts? Am I overconcentrated in one stock or sector without realizing it? What is my real time-weighted return compared to simply buying XEQT?
WealthWise is designed to be the single consolidation layer on top of whichever brokers you use. For brokers that support it, direct broker sync via SnapTrade gives you read-only, automatic updates. But for every other situation — unsupported broker, exported statement, or a holding you want to enter manually — CSV import and manual entry are the answer.
Most Canadian brokerages let you export a statement or holdings report as a CSV file. The exact menu path varies by platform, but the general steps are:
WealthWise recognizes common Canadian brokerage export formats. If your file uses non-standard column headers, the column-mapping step lets you tell the importer which column is which. You do not need a perfectly formatted file — a few minutes of cleanup in a spreadsheet app is usually enough.
One practical note: CSV imports capture a snapshot in time. Unlike a live sync, they won't update automatically when you buy or sell. The recommended workflow for accounts that don't support auto-sync is to re-export and re-import whenever you make a significant change, or to use manual entry for individual trades as they happen.
Manual entry is the most flexible path. It works for any holding in any currency, including assets that don't appear in standard brokerage exports: private REITs, fractional shares settled oddly, employer stock purchase plan shares, or even a GIC you want to track for completeness.
To add a holding manually in WealthWise:
For Canadian Depositary Receipts (CDRs), WealthWise handles the currency wrinkle correctly — it knows a CDR trades in CAD even though the underlying company reports in USD, which matters for accurate yield calculations and benchmarking.
The power of manual import isn't just entering one forgotten account. It's building a genuinely consolidated view of your entire financial picture. Here is a realistic scenario:
| Account | Broker | Import Method |
|---|---|---|
| TFSA (primary) | Wealthsimple | Auto-sync (SnapTrade) |
| RRSP | RBC Direct Investing | CSV import |
| Non-registered | Questrade | Auto-sync (SnapTrade) |
| Spousal RRSP | TD Direct Investing | CSV import or manual |
| FHSA | Wealthsimple | Auto-sync (SnapTrade) |
Once all five accounts are in WealthWise, every feature runs across the full picture: the dividend calendar shows every payment from every account in one monthly view, the sector breakdown aggregates across all holdings, and the VS S&P 500 benchmark uses your actual blended time-weighted return. You finally see what you actually own, not five disconnected slices.
| Analysis Layer | What It Shows You |
|---|---|
| Dividend Suite | Real yield, yield on cost, projected monthly/annual income, and DRIP equivalent across every holding |
| Sector & Geographic Exposure | Look-through decomposition of ETFs into actual sector and country weights, not just the fund label |
| Concentration & Risk Score | Catches over-concentration spread across multiple accounts, e.g. 40% of net worth in one stock across three accounts |
| Benchmark Comparison | Modified-Dietz time-weighted return vs. the S&P 500, accounting for when money was added |
Adding holdings is just the starting point. Once your positions are in, WealthWise automatically runs several layers of analysis that would take hours to replicate manually in a spreadsheet.
Every holding with a dividend is picked up by the dividend tracker. WealthWise calculates your real yield (not the nominal rate), your yield on cost, your projected monthly and annual income, and your DRIP equivalent. For CDRs specifically, it uses the underlying US dividend converted at the current CAD/USD rate, so your income projections are accurate even for holdings like a CDR on a US blue chip.
For ETFs, WealthWise doesn't just show the fund — it looks through to the underlying holdings and decomposes the sector and geographic exposure. An all-equity ETF like XEQT looks like a single line in your brokerage app, but in WealthWise you see the actual breakdown: what percentage is technology, what percentage is Canadian, what percentage is in emerging markets. This look-through logic runs across all your ETFs simultaneously, so your consolidated sector view reflects your actual exposure, not just the category labels on the fund fact sheets.
Once everything is imported, WealthWise calculates a concentration score across your whole portfolio. This catches situations like having 40% of your net worth in one stock spread across three accounts — something that's invisible when you're looking at each account separately on its own platform.
The VS S&P 500 feature uses Modified-Dietz time-weighted return, which accounts for when you added money. This is the only fair way to compare your real portfolio performance against a benchmark. It only works correctly when all your accounts are represented, which is why consolidation matters for this feature specifically.
CSV import is faster when you have many positions and a clean export from your brokerage. Manual entry is better for one-off additions, accounts with messy exports, or holdings that don't appear in standard brokerage reports. In practice, many investors use both: CSV for the initial setup of a large account, then manual entry for new trades going forward.
If your broker is supported by SnapTrade, the automatic sync is always the easiest long-term option since it updates without any action on your part. You can find the list of supported brokers in the Connect section of WealthWise. For everything else, CSV and manual entry ensure no account gets left out of your analysis.
WealthWise is free. There is no premium tier required to use CSV import or manual entry — these are core features available to every user. If you're coming from a tool like a spreadsheet or another tracker, the CSV import path is the fastest way to migrate your existing data without starting from scratch.
The goal is simple: one accurate, consolidated view of every account you own, with real analysis on top of it — not five separate brokerage apps each showing you a partial picture. Whether you get there through auto-sync, CSV, or manual entry depends on your brokers. But the destination is the same.
Most major Canadian brokerages allow you to export a holdings or positions report as a CSV file, including RBC Direct Investing, TD Direct Investing, Scotia iTRADE, CIBC Investor's Edge, and others. The exact export path varies by platform — look for 'Reports,' 'Statements,' or 'Export' in your account menu. WealthWise supports column mapping, so you can align your file's headers even if they don't match the standard format.
Yes. You can manually add US-listed stocks and ETFs (USD-denominated) held in any Canadian account type. WealthWise handles the currency correctly when calculating your portfolio totals, yield, and benchmark comparisons. For Canadian Depositary Receipts (CDRs), use the Canadian ticker (e.g., ending in .NE) so the platform applies the correct CAD pricing.
WealthWise fetches current market prices automatically, so your unrealized gain/loss is always up to date. What you need to update manually is your position quantity and average cost whenever you buy or sell. Many investors update after each trade, or do a quick CSV re-import once a month to keep everything synchronized.
Absolutely — this is one of the most common setups. You might have your Wealthsimple TFSA connected via auto-sync and your bank brokerage RRSP entered manually or via CSV. All accounts appear together in your consolidated dashboard, and every analysis feature (dividends, sector exposure, benchmark, concentration score) runs across all of them at once.
Yes. CSV import and manual portfolio entry are core features available to all WealthWise users at no cost. There is no premium tier required to consolidate multiple accounts or use the analysis features on manually entered holdings.
Start with WealthWise for free →Educational content. Figures and rules verified against the official sources above; tax amounts change annually.
Wealth