SkatteguruSkatteguru2.6 Beta
How It WorksPricingFAQHelpNews
Start For Free

Product

  • Pricing
  • News
  • Reviews

Contact

  • Help Center
  • Contact Us
  • Report an Issue
  • Follow on X

Legal

  • Terms of Service
  • Privacy Policy
  • Cookie Policy
  • Cookie Settings
© 2026 Skatteguru
    1. Home
    2. Help Center
    3. Import
    4. Ibkr Csv
    Interactive Brokers

    Export CSV from Interactive Brokers (IBKR)

    Last updated: May 18, 2026

    Beta Status

    The IBKR CSV parser is currently in early Beta. We have a limited number of test samples so far, so some imports may not work as expected. If you run into issues, please reach out—your feedback helps us improve coverage quickly.

    IBKR offers several ways to export your transaction data. The best option depends on what you need:

    GoalMethodNotes
    Stock/option trades onlyTrade Confirmation Flex QueryCleanest data — recommended
    Trades + dividends + fees + corporate actionsActivity Flex QueryMore comprehensive
    Quick overviewActivity StatementSectioned format, less reliable for import

    Method 1: Trade Confirmation Flex Query (Recommended)

    This produces the cleanest, most consistent trade data and works best with Skatteguru’s parser.

    1

    Log in to IBKR Client Portal

    Go to interactivebrokers.com and log in.
    2

    Navigate to Flex Queries

    Go to Performance & Reports → Flex Queries.
    3

    Create a new query

    In the Trade Confirmation Flex Query section, click the + icon to create a new query. Name it, for example, Skatteguru – Trades.
    4

    Configure the query

    Set the following:

    • Format: CSV
    • Include these fields:

    Date/Time

    Execution date and time

    Symbol

    Ticker symbol

    Quantity

    Number of shares

    Price (Fill Price)

    Price per share

    Commission / Fee

    Transaction fees

    Side (Buy/Sell)

    Transaction direction

    Description

    Security description

    Currency

    Transaction currency

    5

    Save and run the query

    Click Continue → review → Create. Then find your saved query, click the Run icon, select your date range, make sure format is still CSV, and download the file.
    6

    Upload to Skatteguru

    Upload the CSV file(s) to Skatteguru to start processing your transaction data.

    Method 2: Activity Flex Query (Full Transaction History)

    Use this when you want trades, dividends, corporate actions, and cash movements in one file.

    1

    Navigate to Flex Queries

    Go to Performance & Reports → Flex Queries.
    2

    Create a new Activity Flex Query

    In the Activity Flex Query section, click the + icon. Name it, for example, Full Transactions Export.
    3

    Select sections and fields

    Include these sections:

    • Trades
    • Cash Transactions
    • Transaction Fees
    • Corporate Actions (optional)

    For each section, include fields for: Date/Time, Symbol, Quantity, Price, Amount/Proceeds, Commission/Fee, Description, Type/Side, and Currency.

    4

    Set format and save

    In Delivery Configuration, set Format to CSV. Click Continue → Create.
    5

    Run and download

    Run the query as in Method 1, selecting your date range.

    Cash Transactions Are Fine to Include

    Skatteguru’s parser will ignore pure cash rows that don’t have a symbol, so including both Trades and Cash Transactions in one export works without issues.

    Method 3: Activity Statement (Quick but Not Ideal)

    For a fast overview, you can download an Activity Statement:

    1

    Navigate to Statements

    Go to Performance & Reports → Statements.
    2

    Generate the statement

    Choose Activity, select the period, set format to CSV, and download.

    Limitation

    Activity Statements use a sectioned format that is less consistent and may require extra cleanup. Use Method 1 or 2 whenever possible.

    Tips for Best Results

    • Date range: IBKR may limit large exports. If you have a long history, export one year at a time and upload each file separately.
    • Multiple accounts: Use the account selector when creating your query to choose the right account.
    • Always choose CSV: Do not use XML or Text format.
    • Verify before uploading: Open the CSV in a spreadsheet app and check that it has clear columns for Date, Symbol, Quantity, and transaction type.

    Currency Handling

    IBKR transactions can be in multiple currencies (USD, EUR, SEK, etc.). Skatteguru will automatically convert values to SEK using exchange rates from Riksbanken (the Swedish Central Bank) for the appropriate dates.

    Missing transactions?

    If your IBKR export is missing transactions (for example, stock splits, mergers, or other corporate actions), you can add them manually using our custom CSV format. See our CSV format instructions for details on how to add any type of transaction.
    Skatteguru mascot

    We're Here to Help

    Have questions or feedback? We'd love to hear from you. Get in touch.