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:
- Sign in to your Charles Schwab account at schwab.com
- Navigate to Accounts → History
- Select the date range you wish to export
- Choose the account if you have multiple accounts
- Use the export option to download the history as a CSV file
- Save the CSV file to your computer
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 Buysell: recorded as Sellreinvest dividend,qualified dividend,cash dividend,special qual dividend,non-qualified div,long term cap gain,short term cap gain: recorded as Dividendstock split: recorded as Stock splitstock merger,cash merger,mandatory reorg exc: recorded as Mergerjournal,journaled shares,wire funds received,moneylink transfer: recorded as Transfer inwire funds: recorded as Transfer out
Costs
fees & comm: recorded as Brokerage Commissionfees: 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:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drop your Schwab CSV on the upload area or click to browse; the upload starts as soon as you choose the file
- The system detects the Schwab format from the column headings and reads your transactions
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (unrecognised symbols or low-confidence entries)
- 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




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.
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:
- Which files work: file types, size limit and plans
- Which statement to download: history, holdings or both
- Password-protected files: what we ask for and what we keep
- Number and date formats: decimal commas and day-first dates
- Currencies: base currency, statement rates, pence
- Checking your import: totals, holdings differences, gaps and duplicates
- Undoing an import: removing what one file added
- Fixing problems: what each import message means
Related pages
- Statement import overview: General guide for all supported brokers
- Portfolio transactions: Managing and editing your transaction history
- Portfolio overview: Understanding your portfolio dashboard
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
