By Sanjay Bhagia · Worthbase workflow updated 10 November 2026. Broker export instructions last checked 30 September 2026; use IBKR's linked guide if its menus have changed.
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.
Try an IBKR-format sample before using your own statement
Download the synthetic Activity Statement CSV (about 1 KB). It contains one AAPL holding, two buys and a partial sale, with both Order and Trade rows. The account is named DEMO_ONLY. The prices and dates are invented for this example, not market data or investment advice.
| Date | Action | Units | Price | Fee |
|---|---|---|---|---|
| 10 Jan 2024 | Buy | 10 | $100.00 | $1.00 |
| 12 Jun 2024 | Buy | 5 | $120.00 | $1.00 |
| 15 Oct 2024 | Sell | 12 | $150.00 | $2.00 |
Attach the downloaded file in ChatGPT or Claude, with Worthbase connected, and ask:
In my empty USD workspace "IBKR demo", import this synthetic CSV into a demo brokerage account, owned 100% by me. Use the Trade rows only, not the duplicate Order rows. Use FIFO. Keep the source file and row references. Show the preview and check the closing holding is 3 AAPL shares. Do not save yet.
What should the preview and saved ledger show?
Check for one new holding, two buys and one sell, not six transactions. The original negative sell quantity and commissions become a sale of 12 shares with a $2.00 fee; the fee isn't added to the $1,800.00 gross proceeds.
If the preview is correct, approve Save on the preview card or confirm in the conversation. Then ask Worthbase for the holding's remaining units, cost basis and realised gain. Current value and unrealised gain depend on the price used, so they are not fixed by this sample. It has no dividends, withholding tax, foreign exchange or cash balance; a full household net worth needs those separate balances too.
Ask to import the same file again into the same demo account and owner, keeping its row references. The three trades should be recognised as duplicates, not create another holding or another sale. If the preview disagrees, stop rather than approve; check the selected workspace, account, owner and source references.
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.
Actual statements can use different lot matching, trade currencies or adjusted basis. This example checks the stated FIFO method only; it isn't a promise that every IBKR statement's tax or performance report will match. Worthbase reports gains, not tax owed.
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.