Skip to content

Charles Schwab

ShareCalc imports the transaction history of a Schwab brokerage account, exported as CSV or JSON. Both contain the same information so use whichever you prefer.

Export and import

  1. Sign in at schwab.com and open Accounts, then History.
  2. Choose the brokerage account and show its transactions.
  3. Choose the date range. Use Custom to set exact dates.
  4. Select Export and choose CSV or JSON.

Schwab keeps only the last few years of transactions online. For earlier activity, use your statements and add it manually or with a ShareCalc CSV.

Export all transactions since the account opened. Use non-overlapping date ranges: Schwab supplies no transaction IDs. See duplicate handling.

Add the file to an import and leave the format set to Auto-detect, or select Charles Schwab. The export doesn't name the account in a form ShareCalc reads, so the import asks which account to use.

Coverage

All amounts are in US dollars. Dates are the date a transaction took effect: where Schwab writes "06/14/2024 as of 06/12/2024", the transaction is dated 12 June.

  • Buys and sells, including dividend reinvestments, with fees and commission.
  • Option trades, expiries, assignments and exercises.
  • Dividends, including funds' capital gain distributions, with any US tax withheld.
  • Interest on your cash, with any US tax withheld.
  • Deposits, withdrawals and account fees.
  • Stock splits, reverse splits and spin-offs.
  • Cash mergers, as sales for cash.
  • Cash paid for fractional shares, as capital distributions.

Cancelled trades and reversed transfers are omitted when ShareCalc can match them to their originals. Journal entries are skipped. Import Messages lists these entries and anything else that couldn't be imported.

Not imported

  • Equity awards. Exports from equity awards accounts aren't recognised. Shares vesting in a brokerage account (Stock Plan Activity) aren't imported: add them manually at their market value on the vest date.
  • Transfers of shares. Entries labelled Security Transfer aren't imported. Add them manually with their cost from the other account.

Checks and fixes

Review Import Messages and follow the shared checks.

  • Stock splits. The row gives the shares added or removed, but not the ratio. Enter it on the transaction from the company's announcement.
  • Spin-offs. Open the transaction in Transactions and choose the company the new shares came from.
  • Several dividends on one day. If ShareCalc can't tell which dividend the withheld tax belongs to, it imports all the dividends without tax and reports the tax rows. Add the tax to the correct dividends in Transactions.
  • Corrections. A Div Adjustment, IRS Withhold Adj or Adjustment doesn't say which transaction it corrects, so it isn't imported. Find that transaction and adjust it.
  • Cash mergers. ShareCalc imports these as a sale for cash. If the merger also involved receiving shares, check the whole transaction against the merger terms and correct it manually.
  • Cash in lieu. Check any payment for fractional shares that ShareCalc couldn't link to a split or spin-off. Import Messages identifies these payments.
  • Option assignments and exercises. The option and underlying share trade must appear next to each other in the export. If ShareCalc can't pair them, check Import Messages and add the missing transaction manually.
  • New shares in Assets. New shares and funds are added as Unclassified.

A trade's amount doesn't match. ShareCalc uses the exported Amount and warns if it doesn't match the quantity and price. Compare the trade with its confirmation.

The exported file is empty. Schwab may not export a long period with many transactions. Export shorter periods and add the files to one import.

Back to Importing Data