How to Upload Interactive Brokers CSV/XML Files (Flex)

When to Use Manual Upload

Use manual upload if you:

• Prefer not to use auto-sync
• Need to import historical data
• Want control over what gets imported

---

Supported File Types

Format	Extension	Notes
Flex XML	.xml	Recommended — most complete data
Flex CSV	.csv	Standard Flex export format

---

Step 1: Download Your Flex Report

1. Log in to IBKR Account Management
2. Go to Reports → Flex Queries
3. Select or create a Trade Confirmation query
4. Click Run and select your date range
5. Choose format: XML or CSV
6. Click Download and save the file

---

Step 2: Upload to TradeRonin

If You Don't Have an IBKR Account Yet

1. Go to Settings → Accounts
2. Click "+ Add Account"
3. Select "Broker (CSV Upload)"
4. Choose Interactive Brokers
5. Complete account setup
6. Click "Upload CSV" and select your file

If You Already Have an IBKR Account

1. Go to Settings → Accounts
2. Click on your IBKR account
3. Click "Upload CSV"
4. Select your file and confirm

---

What Gets Imported

Data	Included
Stocks	✅ Yes
Options	✅ Yes
Futures	✅ Yes
Forex	✅ Yes
Execution prices & times	✅ Yes
Commissions	✅ Yes
Order/Execution IDs	✅ Yes

---

Required CSV Columns

For CSV uploads, TradeRonin requires:

• Symbol — Ticker symbol
• Date/Time — Execution timestamp
• Quantity — Number of shares/contracts
• T. Price — Trade price
• Buy/Sell — Direction

Optional but recommended:

• Comm/Fee, Execution ID, Asset Category, Open/Close Indicator

---

Deduplication

TradeRonin uses IBKR's Execution ID to prevent duplicates:

• ✅ Safe to re-upload the same file
• ✅ Safe to upload overlapping date ranges
• ✅ Existing trades won't be duplicated

---

Troubleshooting

"File Format Not Recognized"

• Ensure file extension is .xml or .csv
• Try downloading a fresh copy from IBKR

"No Trades Found"

• Verify the file contains trade data (not just positions)
• Check that the Flex Query includes the Trades section

"All Trades Skipped"

• These trades are already imported
• TradeRonin prevents duplicate imports automatically

---

Related Articles

• Set Up IBKR Auto-Sync
• Generic CSV Upload