Importing from Charles Schwab

Export your Schwab transaction history as a CSV file and import it to automatically populate your portfolio.

Last reviewed

Exporting your data from Schwab

Charles Schwab allows you to download your transaction history as a CSV file directly from their website. Follow these steps to export your data:

  1. Sign in to your Charles Schwab account at schwab.com
  2. Navigate to Accounts → History
  3. Select the date range you wish to export
  4. Choose the account if you have multiple accounts
  5. Use the export option to download the history as a CSV file
  6. Save the CSV file to your computer
For the most complete import, select the widest date range available. You can always import multiple files if your history spans more than the maximum export period.

Supported formats and columns

The import wizard recognises Charles Schwab exports in CSV format by these column headings: action, amount, date, price, quantity, symbol. The default currency is USD.

Recognised transaction types

  • buy, reinvest shares: recorded as Buy
  • sell: recorded as Sell
  • reinvest dividend, qualified dividend, cash dividend, special qual dividend, non-qualified div, long term cap gain, short term cap gain: recorded as Dividend
  • stock split: recorded as Stock split
  • stock merger, cash merger, mandatory reorg exc: recorded as Merger
  • journal, journaled shares, wire funds received, moneylink transfer: recorded as Transfer in
  • wire funds: recorded as Transfer out

Costs

  • fees & comm: recorded as Brokerage Commission
  • fees: recorded as Brokerage Commission

Rows set aside

Some rows are recognised but not imported. The review step lists each one and why:

  • Unrecognised action — not imported
  • Cash transaction — not currently imported
  • Date could not be read — not imported
  • A number on this row could not be read — check it and add it by hand

Schwab writes the Date column in US order, as month/day/year, and the wizard reads it that way (a year-month-day date is also accepted). All amounts are recorded in US dollars.

Cash movements are set aside rather than imported, because your cash balance is not tracked from statements. A Journal, Wire Funds Received, MoneyLink Transfer or Wire Funds row that carries no symbol is set aside as a cash transaction; one that names a security is read as a transfer of that security. Bank interest and any Action value the wizard does not recognise are set aside too. The review step lists every row it left out and why, so nothing disappears without being shown to you.

Step-by-step import

Once you have your Schwab CSV file ready, follow these steps to import it:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. Drop your Schwab CSV on the upload area or click to browse; the upload starts as soon as you choose the file
  3. The system detects the Schwab format from the column headings and reads your transactions
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (unrecognised symbols or low-confidence entries)
  6. Confirm the import (the button shows how many rows will be created, for example “Confirm 12 transactions”) to create your transaction records

Screenshot, for illustration only

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
Schwab CSV files typically have a summary row at the bottom labelled “Transactions Total”. The import wizard automatically ignores this row, so you do not need to remove it manually.

Cost line-item extraction

The Schwab CSV reports a single combined Fees & comm figure per trade rather than a breakdown, so that figure is recorded as one brokerage commission cost on the transaction. No manual entry is required for it. Schwab does not itemise the regulatory components, such as the SEC fee and FINRA trading activity fee, in the CSV, so they cannot be shown separately here.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

Common issues

File encoding errors

The reader expects UTF-8 and a comma as the column separator. If you have opened the export in a spreadsheet and saved it again, save it back as a comma-separated UTF-8 CSV rather than a regional variant, or the CSV reader will not be able to read it.

Missing symbols for money market funds

Schwab money market fund transactions (e.g. SWVXX) may appear without a symbol in some export formats. A row with a recognised action but no symbol is treated as a cash movement and set aside, so it is listed under “View skipped” rather than imported.

Reinvested dividends appear twice

Schwab reports a dividend reinvestment as two rows: Reinvest dividend for the cash and Reinvest shares for the shares bought with it. The first is read as a dividend and the second as a purchase, so both appear in review and both are meant to be kept: together they record the income and the shares it bought. They are not duplicates of one another.

Accounts migrated from TD Ameritrade

There is no separate reader for the old TD Ameritrade export. Once your account has moved across, download the history from Schwab so the file carries the Schwab column headings. An older TD Ameritrade file will not be recognised, and will fall back to our document extraction system instead of the fast CSV reader.

Data security

Your uploaded files are processed using our self-hosted document processing system. Your financial data never leaves our servers without your approval and is not shared with any third-party services. The file itself is kept in your document vault so you can open the original statement alongside the imported rows, and you can delete it from there whenever you wish.

Before you import

Dedicated reader: Charles Schwab files are read by a reader built for their layout, without AI.

These parts of the Statement import guide apply to every broker:

Related pages

Can’t find what you’re looking for?

Our support team is here to help. Contact us and we’ll get back to you as soon as possible.

Contact us

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.