Log in to the Inversis portal with your MyInvestor credentials, open Investments → Funds, Securities or ETF → Transaction search, filter the dates and download the XLS. Upload it to Aurio from Net worth → Import choosing MyInvestor: Aurio recognises subscriptions, redemptions and fund transfers.
How to download your MyInvestor statement
- Log in to the Inversis portal (inversis.com/cbmyinvestor) with your MyInvestor credentials.
- Investments → Funds/Securities/ETF → Transaction search.
- Filter the dates and download the XLS.
Online banking menus change from time to time. If you cannot find an option, check the official MyInvestor help.
Which format to choose for Aurio
Recommended format: Excel (XLS). Formats MyInvestor offers: Excel (XLS), PDF.
The Inversis “XLS” is actually a table with a two-level header (trade and settlement dates, operation type, ISIN, units, price and net amount). Aurio reads it as it is, without opening it in Excel. In Aurio, MyInvestor is marked as beta: the format is tested with sample files, and if yours does not load you can write to us.
We tested this format with a synthetic sample file (no real data) that mirrors the columns of the MyInvestor statement. If MyInvestor changes its file layout and something looks off, the review will show you before anything is saved.
What Aurio does when you import
- You review the detected operations (buys, sells and, depending on the file, dividends or fees) before saving them.
- If you re-import the same file, operations that were already there are not duplicated.
- The operations feed your net worth, the average price of each position and the indicative FIFO capital gains calculation.
- Importing broker files is part of Aurio Premium.
Already have an account? Import your trades in Net worth.
Which documents should you prepare before importing?
Prepare the MyInvestor file described in the steps above and check its date range. A summary of the current portfolio value is different from a trading history: it may list quantities without showing when you bought them, what they cost or which fees you paid. Keep the original download. If the provider offers several reports, use the one in the Aurio recipe; do not combine sheets from different reports into a new file to try to make them fit. If you transferred securities from another provider, also gather its original records: the destination report may not contain all earlier purchases. Start any discrepancy check by identifying which document is missing and which period it covers. Do not infer a purchase date or historical cost from the current balance; identical holdings today can result from very different purchases.
What should you check for each instrument?
Compare the name, security identifier, quantity and cost with the broker document. A ticker alone can be ambiguous: different exchanges or products may use similar names. If the file includes an ISIN, use it for your check. Keep shares, funds and cryptocurrencies separate; a shared abbreviation does not make them the same asset. Resolve any row you cannot identify confidently before accepting the result. A current market quote does not establish the price you originally paid for the holding.
Why can current value differ from acquisition cost?
Acquisition cost and current valuation answer different questions. The first records what you paid; the second depends on a market quote and its date. Fees, currency, partial sales and transfers of securities may also matter. A holding transferred from another provider may require historical cost information absent from the current report. Do not replace that cost with today’s market quote simply to remove a discrepancy: you would lose the purchase reference. Keep the broker documents that explain the difference.
How do you avoid counting an investment twice?
A transfer from your bank to a broker moves cash; a security purchase changes an asset holding. If you have recorded bank transactions and then import broker history, check what each record represents before adding positions. A current holding is also different from a new purchase. Check whether the instrument already exists and compare the proposal with the history you retain. If Aurio blocks an overlap, resolve its cause instead of changing names to force the import to go through.
What should you check after saving?
Open net worth and compare quantities and costs with the report you just imported. Review cash left with the broker separately from securities: they are different assets. Before repeating an upload, check what was saved so the same operations are not added again. Importing organises the available information; it does not itself confirm the tax treatment or replace broker certificates. Keep those documents for later checks, especially where a position has moved between providers or its historical cost needs further explanation.
Frequently asked questions
Why the Inversis portal and not the MyInvestor website?
The per-product transaction search with XLS download is on the Inversis portal, which you access with the same MyInvestor credentials.
Does Aurio understand fund-to-fund transfers?
Yes: it recognises transfer subscriptions and redemptions as transfers rather than a sale and a purchase, keeping the cost of your units. Check them in the review before saving.
Do I need to open the file in Excel before uploading it?
No, and it is better not to re-save it: upload it exactly as the portal downloads it.
MyInvestor is a trademark of its owner. Aurio has no commercial relationship with MyInvestor: this guide is an independent tutorial to help you export your own data.
