Import Interactive Brokers into Turbobulls
Export Your Data From Interactive Brokers
Two export formats work. Flex Query is the one to use if you are setting this up properly, because you control which sections are included and you can re-run the same query each year.
Option 1: Flex Query (recommended)
Sign in and open Performance & Reports → Flex Queries → Activity Flex Query.
Click the + icon to start a new Flex Query.
Under Sections, enable each of these and leave their default options alone:
- Cash Transactions - select every option except Summary
- Corporate Actions - keep only Details
- Trades - keep only Execution
- Transfers - keep only Transfer
In each of those sections, tick Select All so every column is included.
Set Format to CSV, Date Format to yyyy-MM-dd, and Time Format to HH:mm:ss.
Save the query, then run it from the arrow button next to its row.
Pick your date range and download. IBKR caps each export at one year, so re-run the query once per year you want to import.
Option 2: Default Statement (legacy)
The older one-click export. Still parsed, and useful if you already have CSVs from before you set up a Flex Query.
Import Into Turbobulls
Open the import screen and choose Portfolio transactions, rather than the wallet import.
Pick Interactive Brokers from the broker list, then upload your file. If the file does not match the broker you picked, you get a hint saying what it looks like instead and a button to switch, so a wrong choice here is easy to undo.
Check the preview. Anything Turbobulls could not read is listed with the reason, and rows that duplicate transactions you already have are flagged before anything is written.
Map the brokers if you want to. IBKR settles each transaction against a per-currency cash balance, so the import surfaces them separately as IBKR USD, IBKR EUR and so on. You can map those to broker entities you already track.
Commit. The write is atomic, so either the whole file lands or none of it does. There is no half-imported state to clean up.
What Gets Imported
| From your statement | Becomes |
|---|---|
| Trade executions, positive quantity | Buy |
| Trade executions, negative quantity | Sell |
| Dividends | Dividend, matched to the holding |
| Withholding tax on dividends | Recorded against the dividend |
| Deposits and withdrawals | Cash in and cash out |
| Transfers between currency balances | Cash moves, paired |
| Withholding tax on interest | Broker expense |
Cost basis is kept per lot, so each purchase keeps its own price and date rather than collapsing into a blended average. That matters later for gains, and it is close to impossible to reconstruct once lost.
Known Limitations
Stated plainly, because finding these after an import is worse than knowing first.
- Unsupported asset classes are skipped, with the row and reason shown in the preview rather than silently dropped.
- Dividends that cannot be matched to a holding are skipped and listed. This usually means the description did not contain a recognisable symbol.
- Trade rows missing a date, symbol or direction are skipped, again with the reason.
- Some cash transaction types are skipped. The preview names the type so you can decide whether to add it by hand.
- One year per export. IBKR's limit, not ours. Several years means several files, which import fine one after another because duplicates are flagged.
- This is a file import, not a connection. There is no API link or automatic sync to IBKR, and there will not be: your data is encrypted on your device before it is stored, which makes a background sync impossible rather than merely unbuilt.
Try It With One Year First
Read These Next
Frequently Asked Questions
Q: Flex Query or Activity Statement?
Flex Query, if you are willing to spend five minutes setting it up once. You control which sections are included, the columns are complete, and re-running it each year gives you a consistent file. The Activity Statement is fine for a one-off or for CSVs you already have.Q: Can I import several years?
Yes, as several files. IBKR caps each export at one year, so run the query once per year and import them in any order. The preview flags anything that duplicates transactions already in your account, so overlapping ranges do not double up your holdings.Q: Why does it show IBKR USD and IBKR EUR separately?
Because IBKR settles each transaction against a per-currency cash balance under one account number. Surfacing them separately lets you map each to the broker entity you already track, and keeps the currency side of your history honest. You can map them to a single broker if you would rather.Q: Does it connect to my IBKR account automatically?
No, and it will not. Imports are file-based because your data is encrypted on your device before it reaches us, which means we cannot read it and cannot fetch on your behalf. You download a file and upload it.Q: What if something does not import?
The preview lists every skipped row with the reason before anything is written, so you see it in advance rather than discovering a gap later. Anything genuinely missing can be added by hand, and if the reason looks wrong, send us the case at hello@turbobulls.com.Turbobulls is a tracking and analytics tool, not an investment adviser. Nothing here is investment, tax, or legal advice. Investing involves risk, including loss of principal. Do your own research or consult a licensed professional.
Every Broker in One View
Import Interactive Brokers alongside everything else you hold, with per-lot cost basis and dividends recorded net of the tax withheld.
- A hint that offers to switch if the file does not match the broker you picked
- Import preview marks duplicates, with an atomic commit
- Cost basis per lot, with prices and dates preserved
- 30+ currencies with FX applied on the trade date
- Export on every plan, free included, never paywalled
Get these by email
One useful investing metric, properly explained. Unsubscribe in one click.
Read more
Import XTB into Turbobulls
Export your XTB account history from xStation and import the workbook directly. What comes across, the ZIP and re-save quirks, and what gets skipped.
How to Read Your Brokerage Statement
Which section answers which question, the three places a statement quietly disagrees with reality, and which document you should download and keep.
How to Start Investing With EUR 1,000 (or Less)
The three things that come before your first trade, why costs behave differently at this size, and what a EUR 1,000 portfolio is actually for.