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.
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.
