Trandence

Interactive Brokers (IBKR) provides comprehensive reporting tools. For the most accurate import into Trandence, we highly recommend generating a custom CSV file using their Flex Queries feature.

Creating a Flex Query

  1. Access the Client Portal at interactivebrokers.com and log in.
  2. From the main menu, navigate to Performance & Reports, then select Flex Queries.
  3. Locate the Trade Confirmation Flex Query section and click the Create (plus icon) button.
  4. Name your query (e.g., “Trandence Export”).
  5. In the Sections area, select Trade Confirmations and check the box to Select All fields (or specifically ensure Account ID, Trade Date, Symbol, Buy/Sell, Quantity, Price, Commission, and Net Cash are included).
  6. Scroll down to the General Configurations and ensure the format is set to CSV.
  7. Save the query.

Exporting Your Data

  1. Return to the Flex Queries page.
  2. Click the Run (Play icon) button next to your newly created query.
  3. Select the desired Date Period (e.g., Last 365 Calendar Days).
  4. Run the report and save the resulting .csv file to your computer.

Import To Trandence

  1. Open Trandence and go to the Trades page.
  2. Click Import Trades and select Upload CSV/TXT.
  3. Choose Interactive Brokers as the broker.
  4. Set CSV Timezone to the timezone used by the broker export. For most US equities workflows, this is America/New_York.
  5. Optionally apply an import preset if you use saved defaults for this account.
  6. Select or drop the exported CSV file.
  7. Review the parsed trades before saving. Confirm symbols, side, open/close times, quantity, prices, commissions, and the session date range.
  8. Use Batch Tags to label the import, for example IBKR Main or IBKR June.
  9. Click Import & Review Summary to save the import and open the post-import summary.

For the full import workflow, including presets, preview validation, multi-session progress, and conflict review, see Importing Trades.

What Trandence Reads

Trandence reads Flex Query order rows with fields such as DataDiscriminator, Symbol, Date/Time, Quantity, T. Price, and Comm/Fee. These fields help identify side, size, price, fees, and execution timing.

Trandence keeps supported US equity symbols, including common share-class formats such as BRK.A and BRK.B, and organizes the imported executions into completed trades for review.

Conflict Handling

If imported rows overlap with trades already in Trandence, use Review Conflicts to compare them before saving. The safest default is Keep Existing, which preserves the trade already in your account.

If you need to replace existing data, delete or correct the existing trades first, then import the file again intentionally. You can review completed imports from Import History.

Sample file: Download a sample IBKR CSV file to see the expected format.

Need Help?

If your file cannot be uploaded, or if the broker has recently changed its export format, contact us at [email protected]. We will help you get the data imported smoothly.