Import Investment Statement PDFs — Track Your TFSA & RRSP Without a Bank Login
Chequing accounts export CSVs; investment accounts mostly don't. What they do give you, every quarter, is a statement PDF. FlowVista reads that PDF directly — account values, individual holdings, published returns — so your TFSA and RRSP show up as tracked accounts without a bank connection and without retyping anything into a spreadsheet.
Why a PDF, Not a CSV?
Bank accounts have had one-click CSV export for years — it's why budgeting without a bank connection works so well for chequing and credit cards. Investment accounts are different. Brokerages, mutual-fund dealers, and group-plan providers rarely offer a transaction CSV at all; the quarterly statement PDF is the export. It's also, conveniently, the most complete document your institution produces: account type and number, the period, the closing value, every holding with its units and market value, and often the published rates of return.
The usual workaround is a spreadsheet: open the PDF on one screen, retype fund names and balances into columns on the other, once a quarter, forever. FlowVista replaces that step. You drag the statement in, it reads the numbers off the page, you check them, and your portfolio updates — whether the statement is from RBC, Questrade, a Sun Life group plan at work, or somewhere else entirely.
- Your most recent account statement as a digital PDF — the file your institution posts under e-documents or statements, not a scan or photo of a paper copy
- One statement per upload, under 10 MB — a single quarter's statement, not a merged full-year bundle
- A browser — FlowVista is a web app, nothing to install
From Statement PDF to Tracked Portfolio
-
1
Download the Statement From Your Institution
Log in to your institution's website and find your statements — usually under Documents, e-Statements, or Statements & reports — and download the most recent one as a PDF. This is the same file you'd file away for your records; no special export needed.
Use the original digital PDF. FlowVista reads the text inside the file, so a scanned or photographed statement (which is just an image) has nothing to read, and a password-protected PDF can't be opened.
Tip One statement at a time works best. A single quarter's PDF is a few pages; a merged full-year bundle can trip the 10 MB and page-count limits, and each quarter is a separate data point anyway. -
2
Drag the PDF Into FlowVista
Click Upload in the top bar, or drop the file on the dropzone in Settings. FlowVista tells file types apart on its own — a CSV goes to the transaction importer, a PDF goes to the statement reader — so there's one upload entry for everything, and you don't have to think about which importer you need.
The reading happens right there, in your browser. The PDF is read in your browser; the file itself is never stored — only the holdings it lists, once you've reviewed and saved them. The file's name is kept as a label so you can tell imports apart later.
-
3
See What Gets Read Off the Page
A statement is a designed document, not a data file, so FlowVista reads it the way you would — by position on the page, finding the account header, the summary total, and the holdings table. From a statement it recognizes, it pulls:
- The account — type (TFSA, RRSP, FHSA, and so on) and account number
- The period — statement date and the period it covers
- The values — closing total, book cost, and the change over the period where the statement prints them
- The holdings — each fund or security with its name, fund code or ticker, units, unit price, and market value
- Published returns — the personal-rate-of-return figures some statements print, kept as-is
There's a built-in sanity check: the individual holdings are summed and compared against the statement's own stated total. If they don't reconcile, the import is flagged for your review instead of being saved as-is — a mis-read column can't slip through silently.
-
4
Review Every Value Before It Saves
Nothing is saved on trust. After the read, a review screen lists each account found in the statement with every field it read — and every field is editable. Reads the parser is less sure about carry a Please verify badge with the specific reason, so you know exactly where to look. Fix anything that's off, then save. Changed your mind? A saved import can be undone in one click.
Tip A Sun Life group plan statement often bundles several plans — a workplace pension, a group TFSA, a DPSP — in one PDF. FlowVista splits them into separate accounts on the review screen, each with its own value from the statement's own summary page. -
5
See Your Portfolio on Net Worth and Plan
Saved accounts land in two places. The Net Worth page lists each account at its latest statement value, feeding your overall net-worth picture. The Plan page goes deeper: a breakdown of your total invested by account type, and a per-account drill-down into the holdings the statement listed — each fund with its market value, exactly as read and reviewed.
For context, the Plan page can also show a benchmark comparison: your return displayed beside the published performance history of a comparable all-in-one index fund — the trailing and per-calendar-year figures the fund itself publishes, the way a fund-facts sheet presents them. It's context, not a verdict, and not investment advice.
Upload the next quarter's statement when it arrives and the account gains a new dated point — over a few quarters you get a real value history per account. Re-uploading the same quarter updates the existing entry rather than creating a duplicate.
See it with real numbers
Try the Live Plan Demo
No sign-up needed. The interactive demo shows the Plan page with imported investment accounts — allocation, holdings drill-down, and benchmark context — on realistic data, so you can see where your own statements would land before you upload one.
Open the Plan demoWhich Statements Work?
Three formats have dedicated readers, built and checked against real statements: RBC investment statements (including RBC Royal Mutual Funds accounts), Questrade account statements (TFSA, RRSP, FHSA, margin, and cash accounts), and Sun Life group plan statements (the multi-plan workplace PDFs covering pensions, group TFSAs, and DPSPs). These extract the most detail — full holdings tables, book costs, and the published returns where the statement prints them.
Many other institutions' statements work too — try yours. When FlowVista recognizes a document as an investment statement without having a dedicated reader for it, a general-purpose reader takes over: it extracts the account type and closing value, and keeps individual holdings only when their sum checks out against the statement's own total. If the holdings can't be verified, you still get the account and its value — an editable, importable starting point rather than a dead end. And because every import passes through the same review screen, a partial read costs you a few keystrokes, not the whole workflow.
Where Your Statement Actually Goes
Short version: the PDF is read in your browser; the file itself is never stored — only the holdings it lists. The reading happens in the browser tab, before anything is saved. What persists after you hit save is the reviewed data — account type, statement date, values, the holdings list — saved to your private FlowVista account and protected by row-level security so other users can't see it. The statement file's name is kept as a plain-text label (so "tfsa-statement-q2.pdf" is distinguishable from "rrsp-statement-q2.pdf"), but the document itself is gone the moment the tab lets go of it.
And because the whole flow starts with a file you downloaded yourself, there's no bank login anywhere: no credentials entered, no account connection, nothing that could move money. FlowVista sees what the statement says — nothing more.
The Honest Limits
- Digital PDFs only. Scans and photos are images with no text layer to read, and password-protected PDFs can't be opened. Download the original from your institution's site.
- 10 MB and one statement at a time. A single quarterly statement is well under the cap; a merged full-year bundle is the usual way to hit it. Upload quarters individually.
- Detail varies outside the validated three. RBC, Questrade, and Sun Life group plan statements get the deepest extraction. Other institutions' statements go through the general-purpose reader, which favours being right over being complete — sometimes that means a total-only import you top up by hand.
- Statement values are the statement's. An imported value is what your institution printed for that date — a quarterly snapshot, not a live market feed. Corrections happen in the review screen or by re-uploading a fixed statement.
Frequently Asked Questions
Which investment statements can FlowVista read?
RBC investment statements, Questrade account statements, and Sun Life group plan statements have dedicated readers built and checked against real statements. Many other institutions' statements work too through a general-purpose reader that extracts the account type, total value, and — when it can verify them against the stated total — individual holdings. Try yours: every import goes through the same review screen, so a partial read is still a usable, correctable starting point.
Is my statement PDF uploaded or stored?
No. The PDF is read in your browser; the file itself is never stored — only the holdings it lists. What's saved to your private account is the reviewed data: account type, statement date, values, and the holdings list, along with the file's name as a label so you can tell imports apart.
Can I track my TFSA and RRSP without a bank login?
Yes — that's the point of statement import. You never enter your institution's credentials into FlowVista and nothing connects to your accounts. You download the statement yourself and upload it, so FlowVista is view-only by construction: it can show your portfolio, but it can't touch it.
What if FlowVista reads a number wrong?
You'll catch it before it saves. Every parsed field is editable on the review screen, lower-confidence reads are flagged with a "Please verify" badge, and holdings are cross-checked against the statement's stated total — if they don't reconcile, the import is flagged for review rather than saved silently. A saved import can also be undone in one click.
Do scanned or photographed statements work?
No. FlowVista reads the text layer inside a digital PDF, so a scan or photo — which is just an image — has nothing to read, and password-protected PDFs can't be opened. Download the original statement PDF from your institution's website instead; it's available in the same place you'd find e-statements.
How often should I upload a statement?
Whenever a new one arrives — for most investment accounts that's quarterly. Each newer statement adds a new dated point for that account, building the value history over time, and re-uploading the same quarter's statement updates the existing entry rather than duplicating it.
Related Guides
Get started
Ready to import your first statement?
Download this quarter's PDF from your institution, drag it into FlowVista, and review what it read. Free while in beta — no bank linking, and the file itself is never stored.
Open FlowVistaFlowVista is a tracking tool, not an advisor. Benchmark figures are the published performance history of the referenced funds, shown for context — nothing on this page is investment, tax, or financial advice.