Skip to main content

Record and import transactions

Preview
Capitalist Analytics is in preview. Sign in with an account that has access to use the workspace.

The transaction ledger drives the portfolio views. A wrong date, market, quantity, or cash entry can affect several pages at once.

Enter a transaction​

Select your portfolio, open Transactions, and choose + Add. Select the transaction type and enter the fields requested for it.

If the editing controls are unavailable, check the selected portfolio. Demo, composite, and shared read-only portfolios cannot be edited like your own portfolio.

For a security transaction, check the market and symbol, date, quantity, price, currency, fees, and taxes. For a cash movement, check its direction and amount. Do not record a deposit as investment income.

Preview an import​

The Import transactions dialog accepts CSV or tab-separated text. It expects a date and a type column; additional fields such as symbol, quantity, price, amount, fees, taxes, currency, market, exchange rate, and notes depend on the transaction.

  1. Select the destination portfolio and open Transactions → Import.
  2. Choose your file or paste CSV or tab-separated text.
  3. Select Check file to preview the interpreted rows.
  4. Read each row and its validation status. Select Back to correct symbols, dates, or units in the source text, then check it again.
  5. When the accepted rows match your statement, select Import N rows. The button shows the number of rows to import.

Use ISO dates such as 2026-04-03 to avoid ambiguity. The importer reads slash-separated dates day first: 03/04/2026 means 3 April, not 4 March.

A preview is a chance to verify interpretation. Check the previewed dates and values when importing a file from a different broker.

Reconcile the outcome​

Compare transaction count, quantities, cash, fees, and tax totals with the original statement. Check both sides of a buy or sell: the security movement and the cash movement.

Before repeating an import, compare it with transactions already recorded. The preview validates rows; do not assume it identifies every duplicate across separate imports. Keep the original source file and the relevant statement.

Corporate actions and income events also affect the record. Use the corresponding workspace views to inspect them instead of hiding a discrepancy with an unexplained deposit.

Continue with portfolio performance.

Last reviewed

Search Capitalist Docs

Search articles, tools, and investing terms.

Popular paths: · ·