Interactive Brokers import guide

Import Interactive Brokers trades into your journal

Interactive Brokers exports executions through Flex Queries. Export one as CSV, map its columns once in the import preview, and TradeJournal.dev matches your executions into positions FIFO, net of commissions.

  1. 1

    Open Flex Queries

    In IBKR Account Management, go to Performance & Reports → Flex Queries.

  2. 2

    Create a Trade Confirmation Flex Query

    Create a new Trade Confirmation Flex Query. Include the Executions / Trades section with fields: symbol, date/time, buy/sell, quantity, price, and commission.

  3. 3

    Set the date range and run

    Choose the date range you want to analyze and run the query. Export the result to CSV.

  4. 4

    Upload to TradeJournal.dev

    Sign in (free), open Trades → Add trades, and drop the CSV. TradeJournal.dev recognises the Interactive Brokers Flex Query and Activity Statement export and reads its dates, sides and fees itself, so there's nothing to map. Rows already in your account are skipped, so re-importing an overlapping range is safe. IBKR's negative commission amounts are counted as costs.

IBKR menu names shift between Client Portal and the classic Account Management; look for "Flex Queries" under reports. Stocks and ETFs only for now: option rows are not imported. As of 2026.