Q&A and User Guide (English)

Frequently Asked Questions

Q: How do I download my transaction history?

The official website, mobile, or iPad app does not support direct downloads.

  1. First, log in and go to Menu -> Accounts -> Transaction History (top left corner). Transaction History
  2. Click the download icon in the top left corner and select the CSV format. Download

Q: I only have the most recent four years of transaction history, or I have multiple historical transaction files. Can I still use them?

A. Only have the most recent four years of data Yes, you can use it directly, but the converted data may not be completely accurate. For instructions on how to adjust the data, please refer to this section.

B. Multiple historical transaction files Schwab only provides the most recent four years of transaction data. If your history spans more than four years, you’ll need to download multiple separate files. For example:

  1. 2021-01-01 to 2023-06-30
  2. 2021-07-01 to 2025-07-02

You can use both files directly without modification. During conversion, the system will automatically detect and handle duplicate transactions. There is only one case where transactions may be deleted: when the following five fields are identical — transaction date, stock, transaction type, transaction amount, and quantity — then duplicates will be removed.

Q: What should I do if I only have partial transaction records?

You need to organize your data based on a reference point. The data must meet the following criteria:

  1. For each stock, both buy and sell records must be included.
  2. Starting balance (if not provided, it will be estimated automatically).

Assume your historical data looks like this:

"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"07/27/2021","Sell","X","TDA TRAN - Sold 10 (X) @23.4500","10","$23.45","","$234.50"
"07/23/2021","Sell","X","TDA TRAN - Sold 20 (X) @22.9000","20","$22.90","","$458.00"

A. Method 1: Deletion Approach

  1. Delete incomplete transaction records. For example, if Stock X only has sell records but no buy records, delete all of its sell records.
  2. Add a balance record: This record should be dated 01/25/2021, with the "Action" field marked as "Wire Received" and the "Amount" field showing the balance on that day.
"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"01/25/2021","Wire Received","","TDA TRAN - WIRE INCOMING","","","","$10000.00"

B. Method 2: Addition Approach

Manually add the missing buy/sell transactions including ticker, quantity, price, and total amount.

  1. If Stock X was sold for 30 shares, add a corresponding buy record: Stock X, 30 shares, $20.00 per share, total $600.00.
  2. Add a balance record: This should be dated 01/25/2021, with the "Action" field as "Wire Received" and the "Amount" field showing the balance on that day.
"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"07/27/2021","Sell","X","TDA TRAN - Sold 10 (X) @23.4500","10","$23.45","","$234.50"
"07/23/2021","Sell","X","TDA TRAN - Sold 20 (X) @22.9000","20","$22.90","","$458.00"
"06/01/2021","Buy","X","TDA TRAN - Bought 30 (X)","30","$20.00","","$600.00"
"01/25/2021","Wire Received","","TDA TRAN - WIRE INCOMING","","","","$10000.00"