Export Interactive Brokers trade history for Journalit with an IBKR Flex Query CSV. This guide shows the exact Flex Query type, section choices, and file format to use so the export matches the importer.
Bottom line
Use an IBKR Flex Query for trade history with the Trade Confirmation
section, select Orders, keep Executions off, and export
as CSV with the required date and time formats.
Create a Flex Query once, save it, and reuse it whenever you need another export.
Run the saved query with a date range whenever you want a fresh CSV for Journalit.
IBKR's Orders output matches the importer. Executions and other report shapes do not.
Date, time, and separator choices are not cosmetic here. They decide whether the CSV parses cleanly.
Most common mistake
If you export the wrong section, especially Executions, the file may
still look valid in a spreadsheet but it will not match the structure Journalit
expects.
Sign in to the IBKR Client Portal, then go to Performance & Reports → Reports → Flex Queries.
Click the blue plus icon next to Trade Confirmation Flex Query, then give the query a clear name such as Journalit Export.
Under Sections:
Trade ConfirmationOrdersExecutionsThis is the critical compatibility step. If Executions is selected instead of Orders, start over and fix the query before exporting.
Use these exact options:
CSV
yyyyMMdd
HHmmss
semi-colon
These values ensure timestamps land in a format Journalit can parse consistently.
Review the settings, click Create, and confirm the query now appears in your Flex Query list.
Once the query exists, exports are straightforward.
Go back to Performance & Reports → Flex Queries and find the saved query you created earlier.
Click the blue arrow button next to the query, choose CSV, set the date range you want, and run the report.
Download the file and import that original export into Journalit. Do not rename columns, resave it through a spreadsheet, or change delimiters unless you are deliberately troubleshooting.
In Journalit, open Trade Import, choose Interactive Brokers, and upload the CSV.
Journalit then checks the file and shows a preview before anything is added: how many trades it found, possible duplicates, and any rows it skipped, with the reason.
Importing is a Pro feature
With a free Journalit account you can upload this file and preview every trade before anything is written to your journal. Adding the trades needs Pro. Follow the upload, review and import steps, or see what Trade Import supports.
If you want to sanity-check the file before importing, these are the strongest signs that the export is correct.
Look for a DateTime-style value such as 20240315;143025, with the date and time separated by a semi-colon.
Common columns include DateTime, TradePrice, IBCommission, Buy/Sell, Quantity, and Symbol.
The first row should contain field names, not trade data. Missing headers usually means the export settings were wrong.
If the file has already been opened and resaved in Excel or Numbers, validate that timestamps, separators, and leading zeros were preserved.
See the supported broker table, import paths, and validation checklist before importing this export into Journalit.
Continue to the Trade Import guide to map, preview, and import your export into Journalit.
Need another platform as well. Return to the broker export hub.