Importing from Interactive Brokers
Export your IBKR Activity Statement as CSV and import it to automatically build your transaction history.
Last reviewed
Exporting your data from IBKR
Interactive Brokers offers two methods for exporting your transaction data: Activity Statements and Flex Queries. Use the Activity statement. That is the layout our fast IBKR reader recognises, because it carries the DataDiscriminator, Asset Category, Symbol and T. Price headings the reader looks for.
Method 1: Activity statements (recommended)
- Sign in to the client portal at portal.interactivebrokers.com
- Navigate to Performance & Reports → Statements
- Select “Activity” as the statement type
- Choose your desired period (Daily, monthly, or annual)
- Set the format to CSV
- Click “Run” to generate and download the statement
Method 2: Flex queries (custom fields)
- Sign in to the client portal at portal.interactivebrokers.com
- Navigate to Performance & Reports → Flex Queries
- Click “Create” to set up a new Flex Query (or use an existing one)
- Under Sections, ensure “Trades” is selected; add “Cash Transactions” to bring in dividends and withholding tax
- Set the output format to XML (recommended) or CSV, and choose your date range
- Run the query and download the resulting file
A Flex Query saved as XML is read without AI by a dedicated Flex reader, whichever fields you chose, and gives the same transactions as the Activity Statement for the same period. Cash movements such as deposits, interest and fees, and the Open Positions section, are set aside and listed at review rather than imported.
A Flex Query saved as CSV is recognised from its column headings, so one that keeps the same Trades headings as the Activity Statement is read in the same way; one that renames them is read by our document extraction system instead, which is slower and worth a closer look during review.
Supported formats and columns
The import wizard recognises Interactive Brokers exports in CSV format by these column headings: asset category, datadiscriminator, symbol, t. price. The default currency is USD.
Recognised transaction types
dividends: recorded as Dividendsplit: recorded as Stock splitspinoff: recorded as Spin-offmerged,acquisition: recorded as Merger
Costs
comm/fee: recorded as Brokerage Commissioncommission: recorded as Brokerage Commission
Rows set aside
Some rows are recognised but not imported. The review step lists each one and why:
- Unrecognised action — not imported
- Cash transaction — not currently imported
- Date could not be read — not imported
- Unsupported product — only share dealing is imported
- Withholding tax with no matching dividend on the same date — not imported
- A number on this row could not be read — check it and add it by hand
The fast reader recognises the IBKR Activity Statement CSV from its Trades section headings. The DataDiscriminator column marks which rows hold trade data rather than section headings or totals, and each trade keeps the currency IBKR reports it in.
What the CSV reader imports
IBKR does not print a buy or sell column in the Trades section. Direction comes from the sign of the quantity, so a positive quantity is read as a purchase and a negative one as a sale. Dates are read in year-month-day form, with or without a time.
Besides trades, the reader imports the Dividends, Withholding tax, Interest (bond coupons only) and Corporate actions sections. Withholding tax is attached to the dividend or bond coupon it was deducted from (same date, security, currency and sub-account); tax with no matching income is set aside. Corporate actions cover forward and reverse splits, spin-offs, stock and cash mergers or acquisitions, and bonds repaid at maturity or called early; a spin-off is held for your review because IBKR prints no cost allocation. Bond and Treasury bill trades are imported, along with their coupons and the accrued interest bought or sold with them. Recognised ADR and market data fees are captured as account charges; other interest and fee lines are set aside as cash transactions. Only share, ETF, fund and bond trades are imported: currency conversions are set aside as cash transactions, and options, futures and other products as unsupported products. Set-aside rows are listed under “View skipped” in the review step.
PDF statement support
IBKR Activity Statements can also be downloaded in PDF format. The import wizard supports PDF extraction using our self-hosted document processing system. Your financial documents never leave our servers without your approval. However, CSV is recommended for the most accurate and fastest import.
Step-by-step import
Once you have your IBKR CSV or PDF file ready, follow these steps to import it:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drop your file on the upload area or click to browse; the upload starts as soon as you choose the file. CSV is available on every plan; PDF needs a plan that includes PDF import
- The system detects the IBKR format from the column headings and reads your transactions
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (unrecognised symbols, multi-currency entries, or low-confidence rows)
- Confirm the import (the button shows how many rows will be created, for example “Confirm 12 transactions”) to create your transaction records
Screenshot, for illustration only




Cost line-item extraction
IBKR reports one combined Comm/Fee figure per trade in the Trades section, so that figure is recorded as a single brokerage commission cost on the transaction. No manual entry is required for it. IBKR does not break the regulatory components out row by row in the CSV, so they cannot be itemised separately here; the PDF statement carries the fuller breakdown.
Common issues
Multi-currency accounts
IBKR accounts often hold positions in multiple currencies. The reader keeps the currency recorded against each trade rather than converting it, so a US dollar trade stays in dollars. Currency conversion rows in the Trades section carry a pair such as EUR.USD in the Symbol column. These are cash movements, not a holding in a security, so they are set aside as cash transactions and listed under “View skipped”.
Composite exchange symbols
IBKR sometimes prints a symbol with an exchange attached, such as AAPL.NASDAQ rather than plain AAPL. The symbol is taken from the statement as written, so a composite one may not match automatically. Where that happens the row is flagged as unresolved and you can pick the correct security during review.
Options contract notation
IBKR options use the Options Clearing Corporation format, which packs the underlying symbol, expiry date, call or put indicator, and strike price into one string, such as AAPL 231215C00190000. Options, futures and other non-share products are not imported: they are set aside as unsupported products and listed under “View skipped”.
Multiple sub-accounts in one statement
If you manage several sub-accounts under a single IBKR sign-in, the Activity Statement can contain transactions from all of them combined. Where the file has an Account column (an Activity Statement) or a ClientAccountID column (a Flex Query), each row is kept against the sub-account named there, so the accounts are told apart.
Before you import
Dedicated reader: Interactive Brokers files are read by a reader built for their layout, without AI.
These parts of the Statement import guide apply to every broker:
- Which files work: file types, size limit and plans
- Which statement to download: history, holdings or both
- Password-protected files: what we ask for and what we keep
- Number and date formats: decimal commas and day-first dates
- Currencies: base currency, statement rates, pence
- Checking your import: totals, holdings differences, gaps and duplicates
- Undoing an import: removing what one file added
- Fixing problems: what each import message means
Related pages
- Statement import overview: General guide for all supported brokers
- Portfolio transactions: Managing and editing your transaction history
- Portfolio overview: Understanding your portfolio dashboard
Can’t find what you’re looking for?
Our support team is here to help. Contact us and we’ll get back to you as soon as possible.
Contact us
