Interactive Brokers Capital Gains Tax Calculator UK

    How to upload an IBKR Flex Query CSV and prepare UK CGT figures.

    Updated 13 May 20264 min read

    Interactive Brokers is widely used by UK investors who trade US shares, ETFs, options and multi-currency portfolios. If you hold investments outside an ISA or SIPP, profits from disposals may need to be reported for UK capital gains tax. FiscalFox reads Interactive Brokers Flex Query CSV files, converts supported non-GBP trades to sterling using the IBKR FX rate table, applies HMRC share matching rules, and handles common listed option close-outs, expiries and matched exercise or assignment rows.

    How to export your Interactive Brokers Flex Query

    Export a Flex Query CSV rather than a portfolio summary. The file must include both trade rows and the FX rate table; otherwise non-GBP trades cannot be converted to sterling for HMRC. Activity Statement CSVs can also work when they include the Trades section, option lifecycle codes and Forex trades.

    1. Sign in to Interactive Brokers Client Portal.
    2. Open the reporting area and create or run a Flex Query.
    3. Include the Trades section with executions for the full period you need.
    4. Include the FX rate table with Date/Time, FromCurrency, ToCurrency and Rate.
    5. Set the date range wide enough to cover your complete taxable trading history up to the end of the tax year. A full history helps FiscalFox build accurate Section 104 pools.
    6. Export as CSV and upload it to FiscalFox using the Interactive Brokers option.

    Use the Flex Query with FX rates

    Activity Statement CSVs can show trade proceeds, but they must include usable GBP conversion data, such as the FX rate table or Forex trade rows. FiscalFox rejects Interactive Brokers files without conversion data rather than guessing exchange rates.

    Once the CSV is ready, go to your FiscalFox dashboard, select Interactive Brokers, and upload the file. FiscalFox processes the export in your browser and keeps the raw file off our servers.

    File format details

    FiscalFox recognises Interactive Brokers Flex Query trade rows with columns such as:

    • ClientAccountID -- the IBKR account identifier
    • Symbol and Description -- the traded instrument
    • AssetClass -- for example STK for shares or OPT for options
    • CurrencyPrimary -- the trade currency, such as USD or GBP
    • Buy/Sell, Quantity, TradePrice and TradeMoney -- the core trade economics
    • Proceeds, IBCommission and Multiplier -- used where available to calculate totals and fees

    The parser also reads the Flex Query FX table, or Activity Statement Forex rows where present, so USD and other non-GBP trades can be converted to sterling on the correct date. If the upload has no review queue after calculation, the share, ETF and automated listed-option SA108 figures are designed to be HMRC-ready.

    How FiscalFox processes IBKR data

    1. Stocks and ETFs are imported as share transactions and matched using the same-day rule, 30-day rule and Section 104 pooling.
    2. Fees and commissions are converted to GBP and included as allowable costs where relevant.
    3. Options are kept separate from shares. FiscalFox automates buy-to-sell close-outs, written option buy-backs, expiries, and matched exercise or assignment into the underlying stock trade.
    4. Open written options are shown as review items because a later exercise or assignment can change how the premium is reported.
    5. Cash and FX-only rows are ignored for standard share CGT calculations.

    For example, if IBKR reports a GOOG share trade at USD 344.90, FiscalFox imports the share transaction using the GBP FX rate from the file. A separate GOOG option premium, such as a USD 473 option contract row, is treated as an option instrument rather than as the GOOG share price.

    Common Interactive Brokers upload issues

    Missing GBP FX rates

    If your file contains USD trades but no GBP FX table, FiscalFox will ask you to export a Flex Query with Date/Time, FromCurrency, ToCurrency and Rate. This is deliberate: UK tax figures should not depend on guessed or stale exchange rates.

    Options and derivatives

    Interactive Brokers is popular with active traders, so exports may include options, futures, forex and other instruments. FiscalFox handles listed stock option close-outs, expiries and matched exercise or assignment rows. Treat an SA108 that contains review items as a draft until those positions have been checked.

    Incomplete date ranges

    A tax-year-only export may not include earlier purchases that still sit in your Section 104 pool. For accurate calculations, include your full history for any securities sold during the tax year.

    Supported transaction types

    IBKR Row TypeHow FiscalFox Uses It
    STK buyAdds shares to the relevant Section 104 pool in GBP
    STK sellCreates a disposal matched under HMRC share matching rules
    OPT buy / sellProcesses listed option close-outs and expiries; folds matched exercise or assignment premiums into the underlying stock trade
    FX rate tableConverts proceeds, costs and commissions to GBP

    If your Interactive Brokers export still looks wrong after using the Flex Query format, contact support with the file type and the transaction you are checking. For complex options, derivatives or tax residency questions, review the output with a qualified tax adviser before filing.

    Ready to calculate your capital gains?

    Upload your broker CSV files and get HMRC-ready reports in minutes. Start free — no credit card required.