In the Interactive Brokers Client Portal, create a CSV Flex Query with the Trades and Cash Transactions sections, or download the Activity Statement as CSV. Upload it to Aurio from Net worth → Import choosing Interactive Brokers. Each download covers at most 365 days: for more history, repeat per year.
How to download your Interactive Brokers statement
- Client Portal → Performance & Reports → Flex Queries → new CSV query with date format yyyy-MM-dd.
- Include the Trades and Cash Transactions sections (365 days max per download: repeat per year).
- No-setup alternative: Statements → Activity Statement → CSV, with the account in English.
Online banking menus change from time to time. If you cannot find an option, check the official Interactive Brokers help.
Which format to choose for Aurio
Recommended format: CSV. Formats Interactive Brokers offers: CSV, PDF.
Aurio reads a Flex Query CSV (TradeDate, ISIN, Symbol, Buy/Sell, Quantity, TradePrice, IBCommission…) and also the standard Activity Statement CSV. Use the yyyy-MM-dd date format when you set up the Flex Query.
We tested this format with a synthetic sample file (no real data) that mirrors the columns of the Interactive Brokers statement. If Interactive Brokers 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 Interactive Brokers 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
Flex Query or Activity Statement?
A Flex Query lets you pick exactly the sections and columns, and is the cleanest option. The CSV Activity Statement needs no setup; Aurio reads both.
I have several years of trades. How do I upload them?
Interactive Brokers limits each download to 365 days. Download one file per year and upload them one by one: operations that were already there are not duplicated.
Does Aurio need access to my Interactive Brokers account?
No. Aurio only reads the file you download; it does not connect to your account and cannot trade in it.
Interactive Brokers is a trademark of its owner. Aurio has no commercial relationship with Interactive Brokers: this guide is an independent tutorial to help you export your own data.
