Import a broker CSV

Importing a supported Fidelity or Schwab transaction-history export gives an account a trade ledger, cost basis, realized gains, income, and daily value history. CSV support follows the explicit broker format, not a custom institution name.

1. Export the right date range. A complete-history account begins at an explicit $0 opening date. An opening-statement account names the first newer-transaction date; rows on or before its prior-day observation are skipped so the sources cannot double-count. Rows dated before the account's own starting point are left out for the same reason, and the import result says how many. A file that starts much later than the configured boundary warns before import.
2. On Accounts, open the account's Import CSV action and choose the file. The parser identifies the format, stubs unknown tickers instead of dropping rows, and asks for confirmation if the detected broker differs from the account's institution.
3. Review every core-cash change. A candidate requires opposing same-day, equal-value legs between two money-market vehicles. Confirm change makes the pair traceable, zero-value internal movement and records the dated cash-vehicle lineage. Not a core change imports the rows ordinarily and leaves lineage unchanged.
4. Resolve the current answer. If the newest confirmed change conflicts with setup, choose the imported vehicle, keep setup with a later effective date, or leave it unresolved. History still imports; the choice controls today's grouping.
5. Read the cash result. A broker checkpoint produces Cash reconciled or an exact visible difference. Import with warning preserves that discrepancy; it never labels the account reconciled. Exports without a checkpoint say so.
6. Review opening observations and compare with the broker. Missing opening positions or cash remain findable from the Dashboard and Accounts until resolved. Reconcile shares and the one logical cash pool against the broker.

Confirmed old-to-new transfer legs contribute no deposit, withdrawal, purchase, sale, income, lot, or performance flow. Later dividends or corrections from a former vehicle still enter cash without making it current again.

T-bills and CDs in the file are recovered as instruments and appear on Fixed Income.

A purchase whose settlement date the broker leaves blank, as Fidelity does on Treasury bills until settlement posts months later, is dated instead by the core-cash movement that paid for it. Exporting the same period again once that date has filled in gives the same purchase a different date, and the import recognises it as the row you already have rather than adding it a second time. One catch applies to a ledger imported before this version: it holds no record of which of its dates were derived that way. Import the original export once more first. It adds nothing, and the later one then reconciles against it.

Any line the file contains but the import cannot use is listed by reason and line number before you import, including the export's own header and disclaimer text. A file that yields nothing therefore says why instead of reporting a clean import of no rows.

Import history undoes one run, removing the rows only that import stands behind. Rows a later, overlapping import also reported are kept and handed to that import; the Undo count is what will actually be deleted. Import-owned cash periods go with their run unless surviving rows still rest on them. A cash period you manually edited is detached from that disposable import provenance and always survives.