note500

How to import Charles Schwab trades into a trading journal

Two minutes from Schwab's History page to a filled-in journal: export your transactions as CSV, drop the file into note500, and your fills are paired into round-trip trades automatically — options, deposits and fees included.

Step 1 — Export your transactions from Schwab

  1. Log in at schwab.com and open Accounts → History.
  2. Select the account you want to journal and set the date range (start with everything you want in the journal — you can re-import later date ranges any time).
  3. Click Export (top-right of the transactions table) and choose CSV. You'll get a file like XXXX123_Transactions_2026-07-30.csv.

The export contains a row per transaction — trades, dividends, transfers — with columns like Date, Action, Symbol, Quantity, Price, Fees & Comm, Amount. Don't edit the file; note500 reads it as-is.

Step 2 — Import into note500

  1. In note500, open the Data tab (Import / Export).
  2. On the Import trades card, choose which account to import into.
  3. Leave Broker format on Auto-detect — Schwab's export is recognized by its column headers. (If a file is ever detected as the wrong broker, pick Charles Schwab here to force it.)
  4. Click ⬆ CSV and select the downloaded file.

note500 then pairs your buy and sell fills into round-trip trades, parses option contracts from Schwab's symbol format (e.g. SPXW 05/21/2026 7450.00 C becomes a dated SPXW call with the right multiplier), records deposits and withdrawals as cash flows so your balance history is right, and books fees.

By default imported trades are added next to whatever is already logged. The "Overwrite existing days" checkbox replaces the days present in your file instead — export a backup first if you use it.

Prefer zero clicks? Connect Schwab directly

On paid plans, note500 can also sync Schwab automatically through a read-only connection (via SnapTrade): new fills import on their own, open positions appear with live marks, and your account balance is captured at every sync. The connection cannot place trades or move money — it can only read. File import remains available on the Plus and Ultimate plans for back-filling history or for accounts you'd rather not connect.

What you get once your trades are in

Import your Schwab history →

Also works with Fidelity, E*TRADE, TD Ameritrade, Tastytrade, Interactive Brokers, Webull and Robinhood exports — same Data tab, same auto-detection.