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)

  1. Sign in to the client portal at portal.interactivebrokers.com
  2. Navigate to Performance & Reports → Statements
  3. Select “Activity” as the statement type
  4. Choose your desired period (Daily, monthly, or annual)
  5. Set the format to CSV
  6. Click “Run” to generate and download the statement

Method 2: Flex queries (custom fields)

  1. Sign in to the client portal at portal.interactivebrokers.com
  2. Navigate to Performance & Reports → Flex Queries
  3. Click “Create” to set up a new Flex Query (or use an existing one)
  4. Under Sections, ensure “Trades” is selected; add “Cash Transactions” to bring in dividends and withholding tax
  5. Set the output format to XML (recommended) or CSV, and choose your date range
  6. 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.

Download the Activity Statement unless you have a specific reason not to. It is the quickest and most accurate route, and it needs no configuration.

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 Dividend
  • split: recorded as Stock split
  • spinoff: recorded as Spin-off
  • merged, acquisition: recorded as Merger

Costs

  • comm/fee: recorded as Brokerage Commission
  • commission: 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:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. 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
  3. The system detects the IBKR format from the column headings and reads your transactions
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (unrecognised symbols, multi-currency entries, or low-confidence rows)
  6. 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

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
IBKR Activity Statements contain multiple sections (trades, dividends, fees, interest). The CSV reader picks out the Trades, Dividends, Withholding Tax and Corporate Actions sections for you, so you do not need to pre-process or edit the file before uploading.

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.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

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:

Related pages

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

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.