Document Guide

Convert Interactive Brokers Statements to Excel

Upload your Interactive Brokers PDF statement and get structured Excel or CSV output with trades, dividends, and cash balances split into usable rows.

Interactive Brokers' Activity Statement PDF packs multiple asset classes and currencies into one document — NAV summary, open positions, trades, cash report, dividends, and withholding tax all in separate sections with their own column layouts. Generic PDF table extractors typically grab one section and mangle the rest, especially when options symbols like 'AAPL 21JUN24 180 C' or per-currency subtotals (USD, EUR, HKD) are involved. pdfexcel.ai reads the statement by field context rather than fixed table coordinates, so it can pull specific sections — Trades, Dividends, Cash Report — into a clean Excel or CSV file with one row per transaction, without requiring you to set up IBKR's Flex Query API first.

Who This Is For

  • Active traders who need trade history in Excel for P/L tracking or tax prep
  • Bookkeepers and accountants reconciling client brokerage activity across currencies
  • RIAs and small advisors consolidating multiple client Activity Statements
  • Anyone who only has the monthly PDF statement and hasn't configured Flex Query

When This Is Relevant

  • Preparing Schedule D / Form 8949 data from a year's worth of monthly statements
  • Month-end reconciliation of cash balances across multiple currency subaccounts
  • Building a running trade log in Excel without re-typing every fill
  • Converting an old scanned or emailed statement PDF when the original CSV export wasn't saved

Supported Inputs

  • Digital PDF Activity Statements downloaded from Client Portal
  • Scanned PDF statements (e.g., forwarded or printed-then-scanned copies)
  • Photos or screenshots of statement pages (PNG/JPEG)
  • Multi-page annual or monthly statement PDFs

Expected Outputs

  • Excel (.xlsx) file with one row per trade, dividend, or cash entry
  • CSV file suitable for import into accounting software or Excel pivot tables

Common Challenges

  • IBKR Activity Statements combine NAV Summary, Open Positions, Trades, Cash Report, and Dividends in one PDF — a naive extractor grabs only the first table it finds and drops the rest
  • Multi-currency accounts show a 'Base Currency Summary' plus separate subtotals per currency (e.g., USD, EUR, HKD); merging these without distinguishing currency codes corrupts totals
  • Options and futures rows use compound symbols like 'AAPL 21JUN24 180 C' or 'ESZ4' that break simple column-splitting logic built for plain stock tickers
  • IBKR's Flex Query CSV export exists and is more granular, but it requires enabling API access and building a query template — most users searching for this only have the PDF

How It Works

  1. Upload the Activity Statement PDF (digital or scanned) or a photo of the pages
  2. Select which sections you need — e.g., Trades, Dividends, Cash Report, or Open Positions
  3. The AI extracts fields like Symbol, Quantity, T. Price, Proceeds, Comm/Fee, Realized P/L, and Currency into rows
  4. Download the result as Excel or CSV and review before importing into your tax or bookkeeping tool

Why PDFexcel.ai

  • Extracts specific statement sections instead of dumping every table into one messy sheet
  • OCR handles scanned or photographed statements when you don't have the original digital PDF
  • Custom field selection lets you pull just the columns you need (e.g., Symbol, Quantity, Realized P/L) without manual cleanup
  • Batch processing converts twelve monthly statements at once instead of one file at a time

Limitations

  • Statements with heavily nested Trade Summary tables broken out by currency and asset class may need a manual review pass to confirm subtotal rows weren't mixed with detail rows
  • User-customized Trader Workstation statement layouts (non-default column sets) may require you to adjust the field selection since the layout differs from IBKR's standard template
  • Faint or low-resolution scans of older statements reduce OCR accuracy on small print like option strike dates
  • This tool reads the PDF as printed — it does not connect to IBKR's Flex Query API, so it won't pull data you haven't already downloaded as a statement

Example Use Cases

  • An investor exports 12 months of Activity Statements into Excel to build a full-year trade log for tax filing
  • A bookkeeper converts a client's IBKR PDF statement to CSV and imports the Cash Report section into their reconciliation spreadsheet
  • An RIA batch-converts quarterly statements for 15 client accounts to check realized P/L across multiple currencies
  • A trader photographs a printed statement received by mail and converts it to Excel since the original PDF wasn't saved

Frequently Asked Questions

Is this the same as using Interactive Brokers' Flex Query CSV export?

No. Flex Query is IBKR's own API-based export and gives more granular control, but it requires enabling API access in Client Portal and building a query template. This tool instead reads the PDF Activity Statement you already have (or a scan of it) and converts it to Excel/CSV — useful if you never set up Flex Query or only received a PDF copy.

Can it handle the multi-currency sections in my statement?

Yes, within limits. The AI reads currency labels like USD, EUR, and HKD as they appear next to each subtotal, but complex statements with many currency subaccounts and nested summaries may need a quick manual check to confirm rows weren't merged across currencies.

Will options and futures symbols extract correctly?

In most cases yes — compound symbols like 'AAPL 21JUN24 180 C' or futures codes like 'ESZ4' are extracted as a single field since the AI reads context rather than splitting on fixed character positions. Very unusual or truncated symbol formats may still need a manual review.

What if my statement is a scanned copy, not the original PDF download?

Scanned and photographed statements are supported through OCR. Accuracy depends on scan quality — a clear, straight scan works well, but skewed pages or low-resolution photos of small print (like strike prices) can reduce accuracy, so review the output before using it for tax filing.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources