Import your Interactive Brokers portfolio into Quantic
IBKR has a reader of its own in Quantic: point a Flex Query at trades and dividends and the file imports without a mapping step.
Interactive Brokers is the one broker here with a parser written for it. A Flex Query is IBKR's own configurable statement: you choose which sections to include, save it, and download the same shape every time. Quantic recognises that shape and reads both trades and dividends from it.
That matters most for a multi-currency account. IBKR reports each trade in the currency it was executed in, and Quantic keeps it that way rather than flattening everything into one — dividends stay in the currency they were paid, and conversion happens where it is actually needed, with the rate that applied on the day.
How to import it
-
1
In IBKR Client Portal, open Performance & Reports → Flex Queries and create an Activity Flex Query.
-
2
Include the Trades and Dividends sections, and run it as CSV.
-
3
In Quantic, open Movements (or Dividends) and upload the file.
-
4
If your query has an unusual shape, Quantic falls back to asking what the columns mean rather than guessing.
Options never import — not from IBKR, not from anywhere. Every option position in Quantic is entered by hand, so a Flex Query full of contracts will bring in its stock trades and ignore the rest. If you sell puts and calls, the wheel screener works, but its ledger is yours to maintain.
Key terms
- Cost basis (average cost)
- What you actually paid for the shares you hold, per share — the money you put in, including the commission, spread across your shares. Buying more at a different price moves it; selling doesn't, because selling doesn't change what the shares you kept cost you. It's the baseline your gain, your yield on cost and any future tax calculation are measured against.
- Commission
- What your broker charges to execute a trade. It's small per trade but it's real money, and it counts as part of what the shares cost you — which is why Quantic records the commission on every trade it can read from your statement.
- Withholding tax
- When you own a foreign stock, the company's home country usually skims a percentage off each dividend before it reaches you — say 15% on US shares. Quantic estimates this from where each holding is based and your tax residence, so your income reflects what actually arrives. It's the tax withheld at source only — not any tax your own country adds, nor amounts you can often reclaim or credit back under a tax treaty.
- ECB reference rate
- The euro exchange rates the European Central Bank publishes once each working day. EU tax administrations accept them, which is why Quantic's tax report converts foreign dividends and sales at the rate for their own date rather than at today's rate or your broker's. There is no rate on weekends or holidays, so the report uses the most recent one published before that date and tells you which day it used.
Quantic · Free
Import your statement and see the income
Free, no card, and no broker connection — you upload a file you exported yourself. Or explore a sample portfolio first.
Need more? Pro adds portfolios, options income tracking & more AI. See Pro →