Import

Import an Interactive Brokers activity statement.

Download your Interactive Brokers activity statement as a CSV, give it to your AI, and Worthbase records the trades, commissions and dividends, then works out cost basis and capital gains.

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/Fee and Currency. Sells have a negative quantity, and commissions are negative.
  • Only the fills. The DataDiscriminator column marks each row as Order, Trade or ClosedLot. 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 Dividends section, 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.

Keep demo records separate. Use an empty Worthbase workspace named “IBKR demo”, with USD as its base currency and one owner at 100%. Don't add the sample to your real portfolio. A Worthbase trial or subscription and a connected AI app are required; reading this example and downloading the CSV are free.
Trade rows to keep; all amounts are USD.
DateActionUnitsPriceFee
10 Jan 2024Buy10$100.00$1.00
12 Jun 2024Buy5$120.00$1.00
15 Oct 2024Sell12$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.

First buy cost = 10 × $100.00 + $1.00 = $1,001.00 Second buy cost = 5 × $120.00 + $1.00 = $601.00 FIFO cost of 12 sold = $1,001.00 + 2/5 × $601.00 = $1,241.40 Net sale proceeds = 12 × $150.00 − $2.00 = $1,798.00 Realised gain = $1,798.00 − $1,241.40 = $556.60 Remaining holding = 3 shares; cost basis $360.60

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.

Let your AI keep the books.

Worthbase tracks everything your household owns and owes, prices it daily and does every calculation exactly. Connect it to Claude or ChatGPT in two minutes.

by Sanjay