Interactive Brokers 1099-B Import to TurboTax: Flex Queries, Activity Statements & What Actually Works

Interactive Brokers is the broker of choice for active traders and international investors, and the tax reporting is a direct reflection of that — powerful, thorough, and utterly confusing for anyone who isn't running a trading desk. There's an Activity Statement, a Form 1099, a Flex Query system, and a third-party data share setting buried deep in Client Portal. None of them map cleanly to TurboTax's import flow.

If you've been trying to get your IBKR 1099-B into TurboTax and ending up with "no data found" or a partial import that only pulls sales but not cost basis, you're not alone. This guide walks through the IBKR tax document maze and the four realistic paths to a clean TurboTax entry.

The IBKR Tax Document Maze

Interactive Brokers issues several different documents, and they're not interchangeable:

1. Form 1099 (Consolidated) — the official tax form sent to you and to the IRS. This is what you need for filing. It's a PDF available in Client Portal under Reports → Tax → Tax Forms around mid-February.

2. Activity Statement — a detailed record of every trade, dividend, interest payment, and fee for the year. Far more information than the 1099, but not an IRS form — it's a supporting document you use for your own records. Available year-round.

3. Flex Query output — a custom-generated report you build yourself, selecting exactly which fields you want. Used by active traders and accountants for bulk data export. Can be delivered in XML, CSV, or HTML.

4. Third-Party Data Share — a setting that lets TurboTax (or similar) connect directly to IBKR via API to pull the 1099 data automatically. This is the "clean" path when it works.

Most TurboTax-related import problems come from trying to use one of these when another is required.

Enabling Third-Party Access in Client Portal

Before TurboTax can import directly from IBKR, you need to enable the third-party access permission in your IBKR account:

1. Log into Client Portal at interactivebrokers.com
2. Go to User Settings → Two-Factor Authentication → Third Party Services
3. Find TurboTax in the list
4. Click Enable and follow the consent flow
5. Return to TurboTax and retry the import

Common error: "No data to upload" or "Unable to retrieve tax information" even after enabling. Usually this means your 1099 hasn't been finalized yet (IBKR often releases 1099s later than retail brokers — mid-to-late February), or the third-party permission didn't fully sync. Wait 24 hours and retry.

Why TurboTax Imports Sales But Not Cost Basis

A specific IBKR-TurboTax bug that many users have reported: the import pulls sale transactions but cost basis comes through as $0 or blank on every row. TurboTax then calculates the capital gain as the full proceeds.

Root cause: IBKR's data export for TurboTax sends cost basis in a field that TurboTax's parser sometimes ignores, depending on the account type and the timing of the import.

The workaround:

1. After the import, don't try to fix each row individually
2. Delete the imported 1099-B
3. Use the Flex Query or PDF-to-CSV path instead (below)

Using a Flex Query for a Clean CSV

This is the method IBKR power users rely on:

1. In Client Portal, go to Reports → Flex Queries → Create Flex Query
2. Set the query type to Activity Flex Query
3. Under Sections, check Trades and Transaction Taxes
4. Under Configure Trades, select these fields:
   • Symbol, Description
   • Date/Time (Open and Close)
   • Proceeds, Cost Basis
   • Short/Long Term flag
   • Wash Sale Loss Disallowed
5. Set Format to CSV and Period to the tax year
6. Save and run the query; download the CSV

The resulting CSV has all the fields you need. You'll probably need to reformat the columns to match TurboTax or TaxAct's expected layout — see our TaxAct CSV format guide for the column order TaxAct wants. For TurboTax, the expected format is slightly different but similar.

PDF-to-CSV Fallback for the Official 1099-B

If building a Flex Query feels like too much work, the simpler alternative:

1. Download your IBKR Consolidated 1099 PDF from Client Portal → Reports → Tax → Tax Forms
2. Upload the PDF to a 1099-B converter
3. Download the CSV (or TXF for TurboTax Desktop)
4. Import into TurboTax

This gets you the same data as a Flex Query for 80% of users with less configuration. The Flex Query approach is better if you need specific fields that aren't on the consolidated 1099 (for instance, detailed transaction-level data for a high-frequency trading year).

Handling 10,000+ Transactions

High-volume IBKR traders routinely have 5,000-50,000 transactions per year. At those scales:

• TurboTax Online caps at around 3,000-4,000 transactions per 1099-B entry. Beyond that it gets slow and sometimes rejects the import entirely.
• TurboTax Desktop handles more but slows down dramatically above 5,000 rows.
• TXF file import scales best — we've seen successful imports of 15,000+ rows.
• Summary entry (per category totals) scales to any number but loses per-transaction detail.

For a very high-volume year, the practical path is often:

1. Use summary totals for the bulk of covered-basis transactions (Box A, Box D) without adjustments
2. Enter wash sale and other adjusted transactions individually
3. Mail Form 8453 with the detailed statement if required

See our guides on handling large 1099-B transaction counts and summary totals in TurboTax.

FAQ

When does IBKR release the 1099?

IBKR typically releases the Consolidated 1099 mid-to-late February, sometimes as late as early March if there are corrections. This is later than most retail brokers. Don't try to import before the form is finalized — you'll get errors.

Can I use the IBKR Activity Statement instead of the 1099?

The Activity Statement is a reporting tool, not a tax form. The IRS receives the 1099, not the Activity Statement. File based on the 1099; use the Activity Statement for reconciliation only.

What about futures and Section 1256 contracts?

Futures and most broad-based index options are Section 1256 contracts, which get 60/40 long/short-term treatment and go on Form 6781, not Form 8949. IBKR reports them separately on the 1099. TurboTax handles them in a different section of the return.

I traded on IBKR Lite vs IBKR Pro — does it matter for taxes?

No. Both generate the same 1099 format. The difference is only in execution routing and commission structure, not tax reporting.

Does IBKR support direct import to TaxAct or H&R Block?

Limited. IBKR's direct integration is strongest with TurboTax. TaxAct supports IBKR as a data source but with more restrictions. H&R Block's IBKR import is the least reliable of the three. For all three, the PDF-to-CSV fallback is the most dependable path.

What's the difference between IBKR and Interactive Brokers?

Same company — Interactive Brokers is the full name, IBKR is the common abbreviation.

Bottom Line

Interactive Brokers' tax reporting is thorough but the direct TurboTax integration is spotty — especially for cost basis. The reliable paths are (1) Flex Query to CSV for power users who want detailed control, (2) PDF of the Consolidated 1099 through a converter for everyone else, or (3) summary totals for high-volume years where individual entry isn't practical.

Whichever method you use, wait until IBKR releases the final 1099 (mid-to-late February) before importing, and verify the totals against the 1099 summary page before filing.

---

IBKR's tax documents giving you grief? Convert your IBKR 1099 PDF free — upload the consolidated form, download TXF or CSV in seconds, and import into TurboTax Desktop or TaxAct without building a flex query. Scales to 10,000+ transaction years.