About this guide: I'm Lawrence, the writer behind supa.is. Between February and May 2026 I've published 150+ articles on supa.is across crypto and brokerage tooling — including 30+ Interactive Brokers-specific guides (recent examples: IBKR Tax Lots: FIFO, LIFO & Specific ID Guide, IBKR PortfolioAnalyst: Benchmark Your Portfolio, IBKR Tax Planner: Estimate Capital Gains). The most-repeated reader question across that IBKR archive is exactly how to pull an accurate activity statement and realized PnL export, which is why I'm publishing this standardized guide instead of answering one-off.
Note: Steps below are reconstructed from official docs (linked). Verify each step against the current UI before relying on it.
If you trade on Interactive Brokers, you already know that the platform is incredibly powerful but notoriously dense. One of the most common pain points for traders—especially at the end of the tax year or during quarterly portfolio reviews—is figuring out exactly how to pull a clean, accurate activity statement that includes your realized PnL.
Unlike retail-friendly brokers that offer a one-click "Download Tax Report" button, IBKR requires you to navigate its reporting suite. However, once you know where to look, the process is straightforward. In this guide, we will walk you through exporting your activity statement and realized PnL via both the modern Client Portal (web browser) and the classic Trader Workstation (TWS).
Why Your Activity Statement Matters
Your daily statement or account summary won't give you a granular breakdown of realized PnL by asset class, by day, or by currency. The Activity Statement is the definitive record of every trade, deposit, withdrawal, dividend, and fee that has touched your account during a specific period. You'll need it to file your taxes accurately, check if your forex trades offset your equity losses, or dispute a wrong settlement with IBKR support.
Method 1: Exporting via Client Portal (Web Browser)
The Client Portal is IBKR's modern web interface. It's the easiest way to pull reports without installing heavy software.
Step 1: Navigate to the Activity Statement
Log in to your IBKR account at ibkr.com. In the top navigation bar, click on Reports. A dropdown menu will appear. Under the "Statements" section, select Activity Statement.Step 2: Set Your Filters
Once the Activity Statement page loads, set your filters:- Date Range: For tax purposes, select "Year to date" or manually input
01/01/2026to12/31/2026. Adjust the dates if you're checking a specific month. - Account: If you have multiple IBKR accounts (e.g., a USD cash account and a margin account), select the correct one.
- Show/Hide Options: Uncheck "Show commissions" for a clean PnL export, or leave them checked if you want to see the net PnL after fees.
Step 3: Generate and Export
Click the Generate button at the bottom of the screen. IBKR will process the data in a few seconds.Once the report loads, click the Export button in the top-right corner of the table. Select CSV if you plan to import the data into Excel or a tax software like TurboTax, or PDF if you need a printable document for your accountant. The file will download to your local machine.
Like what you're reading? Try it yourself — this link supports ChartedTrader at no cost to you.
Open an IBKR Account →Step 4: Understanding the Realized PnL Columns
When you open the CSV file, the most important columns for your realized PnL are Symbol (the ticker), Action (Buy, Sell, or Exercise), Realized PnL (profit or loss *before* commissions), and Realized PnL (Net) (profit or loss *after* commissions and fees).Pro Tip: If you are tracking your PnL in a spreadsheet, use the "Realized PnL (Net)" column. It gives you the true bottom line of your trading.
Method 2: Exporting via Trader Workstation (TWS)
If you are a power user who relies on TWS, you can pull the exact same report without leaving the desktop application.
Step 1: Open the Activity Statement in TWS
Open TWS and log in. In the top menu bar, click on Reports. A new window will open. In the left-hand sidebar of the Reports window, expand the Statements category and click on Activity Statement.Step 2: Set Your Parameters
Just like the Client Portal, you need to set your parameters: Date Range, Account, and Currency. You can choose to view the PnL in your base currency (e.g., USD) or in the transaction currency. For tax purposes, USD is usually the standard.Step 3: Run and Export the Report
Click the Run Report button. The report will populate in the main window of the Reports tab. To export the data from TWS, right-click anywhere inside the report table, select Export, and choose Export to Excel or Export to PDF.TWS exports are formatted slightly differently than the Client Portal exports, but the data is identical. The "Realized PnL" column is usually labeled clearly, making it easy to copy and paste into your tracking sheet.
Common Issues and How to Fix Them
Even with a straightforward process, IBKR's reporting can throw curveballs. Here are the most common issues traders face when exporting their activity statement, and how to resolve them.
Issue 1: "Report Generation Failed" or Timeout
If you try to generate a report for a very long date range (e.g., 5 years of data) and the system times out, it's because the server is struggling to process the massive dataset. The Fix: Break the date range into smaller chunks. Instead of pulling 5 years at once, pull one year at a time, or even one quarter at a time. Export each chunk to a separate CSV file, and then combine them in Excel.Issue 2: Realized PnL Doesn't Match Your Tax Software
You've exported your PnL, imported it into your tax software, and the numbers don't match. This is a classic headache. The Fix: Check your tax lots. IBKR uses specific identification for tax lots by default in the US, but if you have enabled FIFO or LIFO, the realized PnL will differ. Make sure your tax software is using the same tax lot method as your IBKR account. You can check your tax lot settings in the Client Portal under Settings > Account Settings > Tax Lot Method.Issue 3: Missing Trades in the Activity Statement
You remember making a trade, but it's not showing up in your exported activity statement. The Fix: Check the "Status" filter. By default, the activity statement only shows "Completed" trades. If a trade is still in "Pending" or "Settling" status, it won't appear. You can change the status filter to "All" to see pending trades, but be aware that pending trades do not have a realized PnL yet.Issue 4: Currency Conversion PnL is Confusing
If you trade forex or hold assets in multiple currencies, you'll see "Currency Conversion" lines in your activity statement. These represent the PnL from converting one currency to another (e.g., converting EUR to USD). The Fix: These are legitimate realized PnL events. If you bought EUR/USD and later sold it, the difference is realized PnL. Don't ignore these lines; they are part of your overall tax liability.Once set up, IBKR will automatically generate and email you the CSV file every month. You can then set up an automated workflow in your spreadsheet software to import the data.
Note: Flex Query is a powerful tool, but it requires a bit of setup. If you are new to IBKR, stick to the manual export methods described above until you are comfortable with the platform.
How to Organize Your PnL Data for Taxes
Once you have your exported CSV file, you need to organize it. Here's a simple workflow that works for most traders:
- Import to Excel: Open the CSV file in Excel.
- Filter by Asset Class: Use Excel's filter feature to sort your trades by asset class (Stocks, Options, Forex, Crypto). This makes it easier to spot-check your trades.
- Sum by Month: Create a pivot table to sum your "Realized PnL (Net)" by month. This gives you a quick overview of your performance over the year.
- Calculate Total Realized PnL: At the bottom of your pivot table, sum the total realized PnL for the year. This number is what you'll ultimately report to the IRS (or your local tax authority).
- Automate with Flex Query: If you are a systematic trader or you simply hate clicking through menus every month, you can automate your PnL export using IBKR's Flex Query API. Go to Reports > Flex Web Queries, click Create New Query, name it, select the Activity tab, choose your fields, set the delivery method to File (CSV), and set the frequency to Monthly.
FAQ
How often does IBKR update the Activity Statement?
The activity statement updates in near real-time. Once a trade is executed and settled, it will appear in the activity statement within minutes. However, for end-of-day reporting, it's best to pull the statement after the market close to ensure all trades for the day are included.Can I export my Activity Statement for a specific asset only?
Yes. In the Activity Statement configuration, you can filter by symbol. Simply type the ticker symbol (e.g., AAPL, BTC) in the filter box, and the report will only show trades for that specific asset.Does the Activity Statement include unrealized PnL?
No. The activity statement only includes realized PnL—trades that have been closed. If you want to see your unrealized PnL (the profit or loss on your current open positions), you need to look at your account summary or use the PortfolioAnalyst tool.What should I do if I find an error in my Activity Statement?
If you notice a discrepancy in your realized PnL or a missing trade, contact IBKR support immediately. You can reach them via the chat function in the Client Portal or TWS. Have your account number and the specific details of the trade (date, symbol, order ID) ready before you call.Is the Activity Statement the same as my Tax Center report?
No. The Tax Center is a separate tool designed specifically for tax reporting. It provides pre-filled tax forms (like the 1099-B in the US) and handles wash-sale rules automatically. The Activity Statement is a raw data export that you can use for your own tracking or to feed into third-party tax software.Risk Warning
Risk Warning: Crypto trading involves substantial risk of loss. Never invest more than you can afford to lose. This is not financial advice. Trading stocks, options, forex, and cryptocurrencies carries a high level of risk and may not be suitable for all investors. You should carefully consider your investment objectives, level of experience, and risk appetite before deciding to trade.