What should you download from Interactive Brokers?
An Activity Statement in CSV format. In the Client Portal, go to Performance & Reports → Statements, run the Activity statement, choose a custom date range covering your trades (from your first trade if you want full cost bases) and pick CSV as the format. Menu names change; check IBKR's guide to running a statement if yours looks different.
A Flex Query CSV also works, since your AI reads whatever columns it has, but the activity statement is the format Worthbase's tests cover.
Which columns does Worthbase use?
The activity statement is one file with many sections, each starting with its own header row. The first column names the section (Trades, Dividends, Withholding Tax and so on).
- Trades:
Symbol,Date/Time,Quantity,T. Price,Proceeds,Comm/FeeandCurrency. Sells have a negative quantity, and commissions are negative. - Only the fills. The
DataDiscriminatorcolumn marks each row asOrder,TradeorClosedLot. An order filled on two exchanges appears as one Order row and two Trade rows. Your AI records the Trade rows only; counting the Order rows too would double the holding. SubTotal and Total rows are skipped. - Dividends: recorded gross from the
Dividendssection, with the ticker taken from the description. - Withholding tax: sits in its own section. Worthbase doesn't track it as a separate figure yet; ask your AI to add it as a note on the dividend if you want it kept.
Commissions are added to the cost base of buys and deducted from the proceeds of sells, so the result matches how IBKR reports basis.
What should you ask your AI?
Here's my Interactive Brokers activity statement (CSV) for 2023–2025. Add the trades and dividends to my IBKR account in Worthbase. Use only the Trade rows, not Order or ClosedLot rows. Check the closing positions against the statement and show me the preview before saving.
What does the preview show?
Before anything is saved, Worthbase shows the new holdings it will create, the number of buys, sells and dividends, any rows already recorded (skipped as duplicates), conflicts, warnings such as rounding, the realised gains from the sells and whether the closing positions match the statement. You approve it, or ask your AI to fix something first.
How do you check the import?
Compare two numbers with the statement. First, the open positions: units per symbol should match. Second, realised gains: in Worthbase's tests, the realised gain on a partial sale matches the statement's Realized P/L to the cent. If yours don't match, the usual causes are a missing earlier statement, a corporate action outside the period, or a lot-matching method at IBKR other than FIFO. You can tell Worthbase which lots a sale used.
Questions
Does Worthbase connect to my Interactive Brokers account?
No. Worthbase never asks for broker logins. You download the statement and your AI reads it.
Can I import several years?
Yes. Import one statement per period, oldest first. Rows already recorded are recognised and skipped, so overlapping periods are safe.
My account is in a different base currency. Does that work?
Yes. Each trade keeps its own currency, and Worthbase stores the exchange rate for its date, so values and gains in your household's base currency are right.
Will it calculate my tax?
No. Worthbase gives the realised gain or loss on each sale, in any currency. It doesn't calculate tax; check that with your accountant.
Interactive Brokers is a trademark of its owner; Worthbase isn't affiliated with it.
