BorderFolio/Broker statement import
Importing a broker statement
Last reviewed 24 August 2026
Upload a broker statement as a PDF, CSV, plain-text file, screenshot or photo. BorderFolio extracts positions, purchases, dividends and the commissions stated on each trade, shows everything for review, and skips transactions it has already imported. Nothing is added to the portfolio until you confirm. No broker credentials are involved at any point.
Can BorderFolio import an Interactive Brokers statement?
Yes. Upload an IBKR Activity Statement in PDF or CSV format. BorderFolio extracts positions, purchases, dividends and explicit broker fees, lets you review them, and skips previously imported transactions.
A multi-month activity statement is the fastest way to start: a single Jan–Aug export produces current holdings and the contribution history behind them, so the portfolio arrives with months of record instead of starting from today.
Which formats can be uploaded?
| Format | Typical source | Notes |
|---|---|---|
| Broker activity or monthly statement | Multi-page and multi-month statements are read as one document. | |
| CSV | Broker trade or position export | Column layouts differ per broker; the review screen is where you confirm the mapping was right. |
| Plain text | Copy-pasted statement or transaction list | Useful when a broker offers no export at all. |
| Screenshot / photo | Mobile broker app | Good for holdings; a screenshot rarely contains full transaction history. |
There is no supported-broker list to check against — the extractor reads the document, not an API. Free accounts get 3 document imports a month, Pro is unlimited.
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.
What happens when statements overlap?
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.
What does the portfolio look like after an import?
Beyond current holdings, the imported history is used to reconstruct the months the statement covers: contributions grouped by month, dividends received in those months, and a monthly snapshot for each one. That is what makes the contribution record and the split between deposited capital and market growth meaningful from day one rather than after a year of use.
See how contributions are tracked and how contributions are separated from market growth.
What import does not do
- It does not connect to your broker, hold credentials, or place trades.
- It does not import individual bonds, notes or treasuries. Their prices are quoted per 100 of face value and they carry coupons rather than dividends, so reading them as shares would misstate both the position and the money put in. Rows like these are listed as not imported in the review screen. Bond funds — an ETF, ETN or mutual fund with a ticker — are imported normally.
- It does not invent costs a statement does not show — fund expense ratios and FX spreads are not estimated.
- It does not treat extraction as authoritative: every import passes through a review screen you confirm.