CapitelistHelp Center

Connectivity guide

Step-by-step guide

Import a Broker Statement

Use AI Import for broker statements when you have many listed positions or want source-backed portfolio rows.

Start from Assets and use Import statement when your first evidence is a broker file.

Before you start

Use this workflow when your source is a broker statement, custodian export or screenshot that lists public-market holdings. The import is a drafting tool: it reads visible values and prepares editable rows, but the statement remains the source of truth until you check every row.

The statement shows ticker or fund name, quantity, market value, currency and statement date.
You know whether cash balances should be imported as cash or excluded from the holdings import.
The target portfolio is selected before upload.
Existing public-market holdings have been checked so duplicates can be identified.

Detailed steps

01

Open Assets and start an import

Go to Assets from the left navigation. If the portfolio is empty, use the Import statement button in the onboarding panel. If the portfolio already has assets, use Add Capital Item and choose the import route from there. Confirm the portfolio name in the header before continuing.

Start from Assets and use Import statement when your first evidence is a broker file.
02

Choose Public Markets > Import Holdings

Select Public Markets when the file contains listed securities such as stocks, ETFs, mutual funds, bonds or broker model portfolios. Use Import Holdings for bulk import. Use Stock & Fund Ticker instead when you only need to add one holding manually.

Choose Public Markets, then Import Holdings when the statement contains stocks, ETFs, funds or bonds.
03

Upload the broker PDF, CSV or screenshot

Upload the clearest source available. Prefer CSV or PDF when they include all columns. Screenshots are acceptable only when ticker, quantity, value and currency are visible. Do not upload pages that hide units, account ownership or currency, because the review table cannot fix missing source evidence.

Upload the broker PDF, CSV or screenshot from the dedicated Stocks & fund holdings AI Import modal.
04

Wait for extraction and open the editable preview

Capitelist reads the file and drafts rows before anything is added to the Capital Map. Wait for the AI Import preview and use the Review rows and capital-items counters to understand what will be considered for import. If extraction fails or the preview is obviously incomplete, rescan or use manual entry for the affected holdings.

The editable preview appears before anything is committed, with included rows, row counts and an import button.
05

Check item, location, invested amount, value, currency and confidence

Review each row against the statement. Item on file identifies the holding; Portfolio location / account should stay Public markets for listed securities; Amount invested is the cost basis when available; Value and Currency drive the current net-worth effect; confidence and source row show where to slow down. Fix obvious parsing issues before import.

Review each row against the source statement: include status, holding name, type, liquidity, cost basis, value and currency.
06

Exclude duplicates and rows that should not become holdings

Clear the include checkbox for any row that already exists in the portfolio, represents cash that should be captured under Cash, is only a subtotal, or lacks enough evidence. Excluded rows remain visible, while the import button updates to the number of rows that will actually be committed.

Excluded rows stay visible for audit while the import count updates to the remaining reviewed rows.
07

Commit only the reviewed import count

Use the Import capital items button only after the remaining count matches the rows you want in the portfolio. Importing creates portfolio records and can affect Net Worth, Capital Review, Forecast, exports and share links. Leave uncertain rows out and document them as follow-up review items.

Commit only the reviewed count that should become portfolio records.
08

Open Assets and inspect the imported positions

After commit, return to Assets and inspect the Public Markets table. Check the source label, institution, value, currency and any Capital Review warnings. If totals changed unexpectedly, compare the imported rows against the original statement before relying on the dashboard.

After commit, verify the imported public-market rows, institution, invested amount, value and gain/loss.

Field guide

Source file

Broker PDF, CSV or screenshot used as evidence.

Prefer files that show ticker or fund name, units, value, currency and statement date.
Item on file

The extracted holding name shown in the review table.

Match it to the statement and avoid importing subtotal or header rows.
Portfolio location / account

The asset category and liquidity treatment that Capitelist will apply.

Keep listed securities as Public markets unless the statement row is not a public holding.
Amount invested

Cost basis or original amount invested when the source provides it.

Leave uncertain cost basis for follow-up instead of inventing a clean figure.
Value

Current row value that will affect portfolio totals.

Verify whether the broker value includes accrued income, pending cash or converted values.
Currency

Native currency of the imported row.

Do not manually convert unless the source already reports the converted value.
Confidence / source row

Extraction quality and the row where Capitelist found the evidence.

Low confidence or surprising row numbers require manual verification or exclusion.

Decision rules

What it adds

  • Speeds up onboarding of broker portfolios with many positions.
  • Keeps a review step between extraction and portfolio creation.
  • Improves valuation metadata when tickers, quantities and currencies are captured.

What it does not do

  • AI Import is not a live brokerage connection.
  • Extraction can miss columns, confuse signs or duplicate positions.
  • Some instruments may require manual classification after commit.

Common mistakes

What to check

  • Check whether cash balances in the broker statement were imported separately from securities.
  • Verify statement date and currency before using the values in Capital Review.
  • Do not commit positions from screenshots that hide units or currency.
  • Use the original statement as the source of truth when the extraction looks wrong.

Importing subtotals, cash lines or statement headers as if they were holdings.

Committing rows with hidden currency or missing quantity from a screenshot.

Creating duplicate holdings because the same broker account was already tracked manually.

Treating AI confidence as verification instead of a prompt to review the row.

After you save

  • Open Assets > Investments and check the Public Markets table.
  • Open Capital Review and resolve new warnings caused by the import.
  • Compare Net Worth against the broker statement total.
  • Attach or retain the source statement so the imported values remain auditable.

Keep reading