Interactive Brokers Statement Export: Complete Guide
Interactive Brokers (IB) is one of the most popular brokerages for active traders and investors. This guide shows you how to export and extract data from IB statements.
Types of IB Statements
Activity Statements
- Daily, monthly, or annual summaries
- Include positions, transactions, fees
- Available in PDF or CSV format
Flex Queries
- Customizable data exports
- XML or CSV format
- Programmatic access via API
Tax Documents
- 1099s and other tax forms
- Usually PDF format
- Needed for tax preparation
Method 1: Download PDF Statements
Steps:
- Log into Client Portal at ibkr.com
- Go to Reports > Activity
- Select date range
- Choose PDF format
- Download
Pros: Easy, includes all details Cons: Data locked in PDF, manual extraction needed
Method 2: Flex Query Export
Steps:
- Log into Client Portal
- Go to Reports > Flex Queries
- Create a new query (or use templates)
- Select desired fields
- Run and download as CSV
Pros: Clean data format, customizable Cons: Complex setup, may miss some data
Method 3: Automatic Extraction with BOFFO
Steps:
- Download your IB statement (PDF or Excel)
- Upload to BOFFO
- Get extracted data in seconds
- Export to Excel or analyze online
Pros: Fastest, handles PDF perfectly, automatic security matching Cons: Requires BOFFO account (free trial available)
What Data Can You Extract?
From IB statements, you can extract:
- Positions: All holdings with quantities and market values
- Transactions: Trades, dividends, interest, fees
- Account Info: Balances, margin, cash
- Performance: P&L by position and period
Tips for IB Statement Extraction
- Use monthly statements: More complete than daily
- Include all account types: IRA, margin, etc.
- Check for multiple currencies: IB handles multi-currency well
- Download both PDF and CSV: PDF for records, CSV for data
Common Issues and Solutions
Issue: Statement is too large
Solution: Break into monthly segments
Issue: Missing positions
Solution: Check if positions were transferred out
Issue: Currency confusion
Solution: Use base currency reporting option
Conclusion
Interactive Brokers provides multiple export options. For the easiest extraction of PDF statements, try BOFFO—it's specifically designed for IB statement formats.