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.

---

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

Frequently Asked Questions

Does Freenance sync with IBKR via API?

Yes, via the Flex Web Service token — the closest thing to an API that IBKR exposes for retail clients. Once you provide the token, Freenance pulls weekly Flex Query data and merges incremental transactions. There is no need to manually re-download a CSV.

How does Freenance handle IBKR margin loans?

Margin interest paid is imported as a cost event. Margin loan balance is tracked as a liability against the IBKR account in your net-worth view. Tax deductibility of margin interest is jurisdiction-dependent; Freenance tags the cost and you (or your advisor) decide whether it is deductible on your local return.

What about IBKR cryptocurrency holdings?

IBKR offers BTC, ETH, LTC, and BCH via Paxos. These appear in the Flex Query under the Cryptocurrency asset class and import to Freenance the same way as equities. Cost basis is tracked in EUR (or your base currency) and unrealised P/L is calculated accordingly.

Does Freenance handle options and futures?

Equity options import correctly with strike, expiry, and underlying linkage. Futures import as separate contracts with mark-to-market events daily. The tax treatment of derivatives is highly jurisdiction-specific; Freenance produces the raw P/L, and you map it to the appropriate line of your local return.

Can I produce a Polish PIT-38 or German Anlage KAP from IBKR data in Freenance?

Yes — once your tax residency is set, Freenance's tax report module aggregates IBKR transactions into the relevant fields. The output is a working document you (or your tax advisor) use to complete the official return.

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.