How to Track Interactive Brokers (IBKR) Portfolio in Freenance 2026 — EU Multi-Currency, Flex Query & FX Conversion

Interactive Brokers is the broker of choice for European investors who need genuine global market access, US listing access at low cost, true multi-currency cash and securities accounts, and institutional-grade execution. The trade-off for that capability is complexity: IBKR's native reports are powerful but assume you already know what you are looking for, the multi-currency cash logic is unforgiving for the casual user, and the tax surface — W-8BEN, US WHT, local-country credits, FX gains on currency conversions — is the most complex of any retail-accessible broker.

If you hold positions at IBKR alongside other brokers, run a multi-currency portfolio (USD positions for an EU-resident investor is the most common case), or coordinate family-member accounts under one Account Manager, Freenance is the consolidated tracker that turns IBKR's raw output into a coherent picture. This tutorial covers the Flex Query setup, the import flow, FX-gain handling, W-8BEN-driven WHT logic, and multi-account aggregation across an IBKR family group.

TL;DR: Set up an IBKR Flex Query for Trades, Cash Transactions, and Open Positions in CSV format on a weekly cadence. Import to Freenance. The tracker handles multi-currency cost basis correctly, surfaces FX gains/losses on currency conversions, tags US WHT at 15% under W-8BEN (or 30% if you do not have one on file), and aggregates parent + child accounts in a family setup. Net result: one consolidated view across IBKR and every other broker. Sign up for Freenance and consolidate your portfolio.

---

Quick Answer

To track an Interactive Brokers (IBKR) portfolio in Freenance, set up an Activity Flex Query in IBKR Account Management covering Trades, Cash Transactions, Open Positions, Statement of Funds, Corporate Actions, and Transaction Taxes in CSV format. Add IBKR as an account in Freenance using the same base currency as your IBKR Base Currency, then import the file. Freenance tracks multi-currency cost basis in both position and base currency, decomposes results into securities P/L and FX P/L, and tags US dividend withholding tax at 15% under W-8BEN (30% if missing or expired). You can aggregate family subaccounts and schedule weekly auto-sync via a Flex Web Service token for one consolidated view.

---

Why IBKR's Native Reports Are Necessary but Not Sufficient

IBKR's reporting suite is the most comprehensive of any retail broker in Europe. Activity Statements, Monthly Statements, Custom Statements, Flex Queries, the Performance Analytics module — the data is all there. So why use a consolidated tracker on top?

• Multi-broker view. IBKR shows what IBKR custodies. If you also hold ETFs at DEGIRO, savings plan at Trade Republic, crypto on Binance, and Polish stocks at a local broker, IBKR cannot show your true allocation.
• Cross-asset view. Real estate, private pension, savings bonds, cash at multiple banks — none of it lives in IBKR.
• FIRE planning. IBKR's Performance Analytics shows historical return. It does not project forward to a target net worth or compute a withdrawal-rate-driven runway.
• Jurisdiction-aware tax report. IBKR produces a generic Annual Report. For Polish, Italian, German, French, or Dutch tax residents, the line-items must be mapped to the local return manually — a non-trivial exercise once US WHT credits, foreign currency lots, and Imposta di Bollo (Italy) or Box 3 deemed return (Netherlands) enter the picture.
• FX-gain visibility. When you convert EUR to USD to buy SPY, hold for two years, sell SPY, and convert USD back to EUR, you have a securities P/L and an FX P/L. IBKR records both but does not present them as a single decision-relevant view.
• Family aggregation. If you run an IBKR Family or Friends-and-Family advisor structure, IBKR aggregates within IBKR — but you usually want the children's or spouse's other-broker accounts in the same picture, which IBKR cannot do.

This is the gap Freenance closes. The IBKR data flows in via Flex Query; the consolidated picture is built on top.

Prerequisites

1. An IBKR account in good standing — single, joint, or Family.
2. A current W-8BEN on file (most EU-resident retail investors filed this at account opening; if not, US dividends are taxed at 30% rather than the treaty rate of typically 15%).
3. A Freenance account — for multi-currency tracking, a paid tier is recommended.
4. Roughly 30-45 minutes for the first Flex Query setup and initial import; ongoing imports take five minutes per week.

Step 1: Configure an IBKR Flex Query

Flex Query is IBKR's machine-readable, customisable export. It is configured in the web Account Management portal, not in TWS.

1. Log in to IBKR Account Management (web).
2. Navigate to Performance & Reports → Flex Queries → Activity Flex Query.
3. Click + to create a new query.
4. Name it: Freenance_Activity.
5. Under Sections, enable:
   • Trades (with all standard sub-fields: Date, Asset Class, Symbol, ISIN, Quantity, Price, Currency, FX Rate to Base, Commission, Realized P/L).
   • Cash Transactions (Dividends, Withholding Tax, Interest, Deposits/Withdrawals).
   • Open Positions (Symbol, ISIN, Quantity, Cost Basis in Position Currency, Cost Basis in Base Currency, Market Value).
   • Statement of Funds (cash currency balances by date).
   • Corporate Actions.
   • Transaction Taxes.
6. Set Format: CSV.
7. Set Period: Last 365 days for the initial run; for ongoing weekly use, change to Last 30 days or Year-to-Date.
8. Save.
9. Click Run to generate the file. Download the CSV.

For the initial historical import, also create an Activity Flex Query with Period = Custom and step backward year by year if your IBKR history exceeds 365 days. IBKR limits a single Flex Query to roughly one year of history.

Step 2: Add IBKR as an Account in Freenance

1. Log in to Freenance.
2. Assets → Add brokerage account → choose Interactive Brokers.
3. Set base currency — typically EUR for EU-resident investors, but use the same currency you set as your IBKR Base Currency to avoid double conversion.
4. Tag tax residency country.
5. Save.

If you operate an IBKR Family group, create one Freenance account per IBKR subaccount and link them to a parent Freenance group so consolidated views aggregate correctly.

Step 3: Import the Flex Query CSV

1. In Freenance, open the IBKR account.
2. Import transactions → Upload CSV → select the Freenance_Activity file.
3. Freenance auto-detects the IBKR Flex format.
4. Review the import preview, paying attention to:
   • Multi-currency trades (USD share, EUR base) — confirm the FX rate to base is being honoured.
   • Dividend lines paired with their WHT line — they should link to the same position.
   • Cash currency conversions — these are explicit Forex trades in IBKR (e.g. selling EUR.USD for the purpose of buying USD-denominated stock) and Freenance records them as FX events with cost basis tracking on the currency lots.
5. Commit the import.

Step 4: Verify the Multi-Currency Cost Basis

For an EU-resident investor holding USD-denominated securities, cost basis must be tracked in both currencies:

• Position currency cost basis (USD): what you paid in USD. This drives IBKR-side P/L.
• Base currency cost basis (EUR): what those USD cost when you bought them. This drives your tax basis for most EU jurisdictions (Poland's PIT-38, Germany's Anlage KAP, Italy's Quadro RT all measure gains in the local currency).

The two diverge whenever EUR/USD moves between purchase and sale. A USD position that was flat in USD terms but where EUR/USD moved from 1.10 to 1.05 in the meantime delivered a positive EUR-denominated gain to the EU-resident investor and is taxable as such.

In Freenance:

1. Open a USD-denominated position.
2. Toggle the cost basis view between Position currency and Base currency.
3. Confirm both numbers are populated and consistent with the Flex Query.
4. The realised-P/L view splits the result into securities P/L (price movement) and FX P/L (currency movement) — this is what most EU tax authorities care about.

For tax-residency setups where FX gains on operational currency holdings are separately taxed (e.g. Germany's old §23 EStG treatment, certain Italian plusvalenze su valute rules), Freenance surfaces these as distinct events.

Step 5: Tag W-8BEN-Driven Withholding Tax

If you filed a W-8BEN at account opening as an EU resident, the US-source dividend WHT rate under most US-EU tax treaties is 15% (rather than the statutory 30%). IBKR applies this automatically and the Flex Query Cash Transactions section labels the lines accordingly.

In Freenance:

• Each WHT row is matched to the corresponding gross dividend.
• The Tax tab on each position shows gross dividend, WHT amount, WHT rate, and the country code (US, NL, etc.).
• The annual tax report aggregates these by jurisdiction so you can claim a foreign-tax credit on your home-country return.

If WHT is being applied at 30% rather than 15%, your W-8BEN is either missing, expired (W-8BEN expires after three calendar years), or rejected. Freenance flags this in the WHT audit view so you can refile.

Step 6: Set Up Family Account Aggregation

IBKR Family (formerly "Friends and Family Advisor") groups multiple individual accounts under one master Account Manager. Each subaccount has its own Flex Query, statements, and tax IDs.

In Freenance:

1. Create a Freenance account for each IBKR subaccount.
2. Link them under a single Freenance group (e.g. Household).
3. Run a Flex Query per subaccount and import each into the corresponding Freenance account.
4. The group-level dashboard aggregates net worth, allocation, and forward projections across the family — while keeping individual tax-residency settings intact.

This is the configuration most useful for spouses with separate tax residencies (e.g. one in Poland, one in Germany), or for parents managing a child's UTMA-equivalent account alongside their own.

Step 7: Schedule the Recurring Import

For ongoing tracking:

1. In IBKR Account Management, the same Flex Query you set up in Step 1 can be triggered via a Flex Web Service token (machine-readable URL).
2. Generate a token under Settings → Account Settings → Reports → Flex Web Service.
3. Add the token to Freenance under the IBKR account settings.
4. Freenance polls weekly, downloads the latest CSV, and merges incremental transactions into your ledger.

This is the closest IBKR offers to a true API sync and works reliably.

Sign up for Freenance and consolidate your portfolio.

A Worked Example: EUR-Resident with USD Positions

Consider a Polish-tax-resident investor with IBKR who:

1. Started with €50,000 in 2022.
2. Converted to USD at the time at roughly 1.10 EUR/USD → $55,000.
3. Bought 200 shares of SPY at $400 each ($80,000 with margin) and 100 shares of MSFT at $300 each ($30,000 with margin) — total invested $110,000 with $55,000 cash equity and $55,000 margin.
4. By May 2026: SPY at $560, MSFT at $440. SPY position worth $112,000; MSFT worth $44,000; gross securities $156,000.
5. Repaid margin: $55,000 plus accrued interest of roughly $5,500 across the period.
6. Net USD equity: $156,000 − $60,500 = $95,500.
7. EUR/USD now at 1.05. Converting back: roughly €91,000.
8. Less the original €50,000: total EUR-denominated gain of €41,000.

The decomposition that matters for the Polish PIT-38 return:

• Securities P/L in USD: $46,000 (SPY appreciation $32,000 plus MSFT appreciation $14,000).
• In EUR at the relevant FX rates: roughly €42,000 of securities gain.
• FX P/L on the USD cash holdings: small negative, because EUR/USD moved against the investor (USD weakened).
• Margin interest cost: $5,500 ≈ €5,000, deductible against gains in some jurisdictions.
• Dividends received and US WHT credit: ~$8,000 dividends, ~$1,200 WHT (15% under W-8BEN), creditable up to 19% on the Polish side.

Without a consolidated tracker, the investor faces this decomposition by hand at tax time. With Freenance, the Flex Query data flows in, the EUR-denominated cost basis is tracked at every transaction, and the realised-gain decomposition is produced as a working figure for PIT-38 section C.

Sign up for Freenance and consolidate your portfolio.

Multi-Currency Cash Visibility

Beyond securities, IBKR clients typically hold cash in three or more currencies simultaneously: EUR for incoming SEPA, USD for buying US stocks, GBP for the occasional UK listing, sometimes PLN for repatriation. IBKR's cash report shows balances by currency but does not present an integrated view of currency exposure.

In Freenance:

• Each cash currency is tracked as a sub-balance under the IBKR account.
• The aggregate FX exposure chart shows what fraction of total net worth is denominated in each currency — including securities denominated in that currency.
• Forward FX hedging or rebalancing decisions become quantifiable: "I am 65% EUR, 25% USD, 10% GBP at gross level; my target is 70/20/10; the rebalance is small enough to ignore" (or not).

This is the kind of view that IBKR's reporting could in principle support but does not present, and that Freenance produces directly from the Flex Query data.

Common Pitfalls

FAQ

What exactly should my IBKR Flex Query include for Freenance?

Enable Trades, Cash Transactions (dividends, WHT, interest, deposits/withdrawals), Open Positions, Statement of Funds, Corporate Actions, and Transaction Taxes. Set format to CSV, name it something obvious like Freenance_Activity, and use a Last 365 days period for the initial run, switching to Last 30 days or Year-to-Date for the recurring weekly pull. For longer history, run the query year by year — IBKR caps a single Flex Query at roughly one calendar year.

How does Freenance handle FX conversions and FX gains on USD positions?

Forex trades in the Flex Query are imported as explicit FX events with cost-basis tracking on each currency lot, separate from the underlying securities. When a USD position is sold, Freenance decomposes the realised result into securities P/L (USD price movement) and FX P/L (EUR/USD movement between purchase and sale) — which matches how most EU tax authorities measure gains in local currency. The two cost-basis views (position currency vs. base currency) on each position let you sanity-check both numbers against the Flex Query.

Can Freenance auto-sync IBKR data weekly via Flex Web Service?

Yes — generate a Flex Web Service token under Settings → Account Settings → Reports → Flex Web Service, paste it into the IBKR account settings in Freenance, and the same Flex Query you configured will be pulled weekly and merged incrementally. This is the closest IBKR offers to an API for retail clients and works reliably for ongoing tracking. Manual CSV upload remains available as a fallback for historical loads or one-off reconciliations.

What happens to my US dividend WHT if my W-8BEN has expired?

US-source dividend WHT silently jumps from the 15% treaty rate to the statutory 30% when W-8BEN is missing, expired (three calendar years), or rejected. Freenance's WHT audit view flags this so you can refile via IBKR Account Management before the next dividend cycle. Historical over-withheld amounts can sometimes be reclaimed, but the practical fix is to keep the form current.

Can Freenance produce a PIT-38 or Anlage KAP working document from IBKR Flex Query data?

Yes — once tax residency is set, the tax report module aggregates IBKR transactions into the jurisdiction's relevant fields (PIT-38 for Poland, Anlage KAP for Germany, Quadro RT for Italy, Box 3 schedule for the Netherlands), including the foreign-tax-credit lines for US WHT under W-8BEN. The output is a working document, not a filed return — you or your tax advisor use it to complete the official forms. This guide is general information and not investment or tax advice; consult a licensed advisor for your specific situation.

Further Reading

• Track all investments in one place — the multi-broker, multi-asset rationale.
• How to monitor your investment portfolio — the broader monitoring framework.
• How to track dividends from ETFs and stocks — dividend cash-flow forecasting in detail.

---

This guide is for general information only and is not investment, tax, or legal advice. Cross-border tax treatment of US-source dividends, FX gains, and derivatives is highly dependent on personal circumstances and on the bilateral tax treaty in force at the time. Consult a licensed tax advisor for your specific situation.