Importing an Interactive Brokers activity statement

Export the widest period, not the last month

This is the one decision that changes what you get. A multi-month Activity Statement is the fastest way to start: a single January-to-August export produces both current holdings and the contribution history behind them, so the portfolio arrives with months of record instead of starting from today.

That matters more here than with most trackers, because the whole point is separating what you contributed from what the market did. A tracker that begins at today's balance can never answer that question about the past — and a valuation nobody recorded cannot be reconstructed later.

What gets extracted

• Positions — ticker, quantity and average price, including fractional quantities. Positions closed during the statement period are not resurrected as holdings.
• Purchases — each buy becomes a contribution, dated, with quantity, price per share and the commission charged on that trade.
• Dividends — payments received during the period, per instrument.
• Statement metadata — broker, period covered and file name, kept so a later upload can be compared against what was already applied.

Anything the extractor reads incorrectly can be edited in review, and holdings can always be added by hand instead.

Uploading the same period twice is safe

Overlapping periods are the normal case — most people re-export the whole year rather than trimming to what is new. Two rules keep that safe:

• Transactions already imported are matched and listed as skipped duplicates in the review, with counts shown before you confirm. Re-uploading the same file adds nothing.
• A statement whose period ends earlier than the last one applied does not silently replace newer position quantities — an older document cannot rewind the portfolio.

Why a document rather than an API connection

There is no supported-broker list to check against, because the extractor reads the document rather than talking to an API. That is a deliberate trade with two sides, and both are worth stating.

What you gain: nobody holds your broker credentials, including us, and there is no integration to break when a broker changes something. What you give up: the portfolio does not update itself, so you upload something roughly once a month rather than watching it refresh.

What the import does not do

• It does not connect to your IBKR account. Only the file you upload is read.
• It does not invent missing history. A period no statement covers is a hole, and the honest response to a hole is to show it rather than interpolate over it.
• It does not reconstruct valuations nobody recorded. Time-weighted return needs a valuation around every external cash flow; where one is missing the figure is labelled an approximation rather than blended into a headline number.
• It is not a tax document. Withholding shown on a statement is used as recorded; the cross-border estimates are informational and are explained in the withholding methodology.