No Auto-Sync? How to Import Your Portfolio by CSV or Manually

Published June 19, 2026 · 7 min read · By the WealthWise team · Updated June 20, 2026

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.

Why a Single View of Every Account Matters

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.

Two Ways to Add Holdings Without Auto-Sync

Option 1: CSV Import

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:

• Log into your brokerage and find the "Account statements," "Reports," or "Export" section.
• Choose a holdings or positions export (not a transaction history, unless that's all that's available).
• Download the CSV file to your device.
• In WealthWise, navigate to your portfolio, click Import, and upload the file.
• Map the columns if prompted — typically ticker, quantity, average cost, and account type.
• Review and confirm the imported positions.

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.

Option 2: Manual Entry

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:

• Go to the portfolio where you want to add the holding (or create a new one for the account).
• Click Add position and search by ticker or company name.
• Enter your quantity and average cost per share (your ACB per unit).
• Assign it to the correct account type (TFSA, RRSP, non-registered, etc.).
• Save. WealthWise immediately pulls the current price and calculates your unrealized gain/loss.

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.

Consolidating Multiple Brokers: The Real Use Case

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:

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.

What WealthWise Does With Your Holdings After Import

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.

Dividend Suite

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.

Sector and Geographic Exposure

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.

Concentration and Risk Score

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.

Benchmark Comparison

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.

Tips for a Clean Import

• Use account-type portfolios: Create separate portfolios in WealthWise for each account type (TFSA, RRSP, non-registered). This keeps the tax analysis clean and mirrors how your actual accounts are structured.
• Enter your real ACB: For tax purposes, your adjusted cost base matters. Take a moment to enter your correct average cost per share — especially for accounts where you've been contributing for years. If you're not sure, your brokerage's realized gains report or a tool like ACB tracking resources can help you reconstruct it.
• Match the ticker exactly: Canadian and US versions of the same ETF have different tickers (e.g., VFV vs. VOO). Make sure you're entering the Canadian-listed ticker if that's what you hold, so the currency and dividend data are correct.
• Update after significant trades: A manual portfolio is only as current as your last update. Building a habit of updating after each buy/sell keeps your analysis meaningful.
• Don't forget currency positions: If you hold USD cash in a margin or registered account, you can add it as a position so it's reflected in your total.

When to Use CSV vs. Manual Entry

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.

Getting Started

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.

Frequently asked questions

Which Canadian brokerages can I import by CSV into WealthWise?

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.

Does WealthWise support manual entry for US stocks and ETFs held in Canadian accounts?

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.

How often do I need to update a manually entered portfolio?

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.

Can I mix auto-synced accounts and manually entered accounts in the same WealthWise dashboard?

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.

Is WealthWise free for CSV import and manual entry?

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.