Skip to content
TickerScribe

// schwab import

Your Schwab Trading Journal

Journal your Charles Schwab trades without re-typing them. Two exports cover everything: Transactions for your activity, Lot Details for the positions you already own — both recognized the moment you drop them in.

Start Your Free Journal

Two exports in · zero column mapping · 100% free

// how-to-export

From schwab.com to your journal

Four steps, about two minutes.

  1. 01

    Open your transaction history

    On schwab.com, go to Accounts → History, pick the account, and make sure the view is set to Transactions.

  2. 02

    Pick your date range, export

    Choose the period (Schwab caps an export at 10,000 rows — chunk long histories by date range) and click Export to download the CSV.

  3. 03

    Drop the file into the Import Wizard

    Settings → Import Data, drag the file in. It's identified as Schwab automatically — no column mapping, no file cleanup.

  4. 04

    Preview & commit

    See every trade before anything is saved. Duplicates are flagged and skipped, then trades post to the ledger with accurate cost basis.

// auto-detected

The $57.305 problem, solved.

Schwab writes prices most parsers get wrong — $57.305 turns into 57,305 in tools that read three decimals as a thousands separator. TickerScribe reads the export exactly as schwab.com produces it: title row, three-decimal prices, footer and all.

transactions_06012026.csvCharles Schwab · auto-detected
"Transactions for account …208 as of 06/04/2026 10:27 ET"recognized
Date,Action,Symbol,Description,Quantity,Price,Fees & Comm,Amountcolumns mapped
5/28/2026,Buy,CRM,"SALESFORCE INC",2,$268.415,,($536.83)stock · 3-decimal price OK
6/03/2026,Reinvest Shares,HSY,"HERSHEY CO",0.0041,$397.55,,($1.63)fractional reinvest
6/03/2026,Qual Div Reinvest,HSY,"HERSHEY CO",,,,$1.63dividend
6/02/2026,Journal,,"TRANSFER FUNDS FROM SCHWAB BANK",,,,$1,840.00cash · deposit
4/10/2026,Foreign Tax Paid,SHOP,"SHOPIFY INC",,,,($0.34)tax · adjustment
"Transactions Total",,,,,,,"$2,418.37"footer · skipped

The same recognition covers the Lot Details export — each open tax lot becomes an opening position with its real cost basis.

TickerScribe Import Wizard recognizing a Charles Schwab Transactions CSV — 36 rows, identified as Charles Schwab (Transactions), with the Source, Scope, Map, and Preview steps shown

The moment it lands: recognized, every column mapped, ready to preview.

What comes acrossFrom two exports

Stocks

Buys and sells, dividend reinvestments as the fractional lots they are, and journaled shares with their cost basis — quantities down to four decimals.

Options

From the same file, not a second one. Opens pair with closes, an expiration or assignment closes the contract at zero with the reason kept, the shares from an assigned put arrive as a lot marked assigned, and the legs of a spread are grouped as one position instead of filed as unrelated singles.

Dividends, transfers & taxes

Qualified dividends, reinvested dividends, account transfers, and foreign tax withholding all land as cash events — so portfolio value and deployed capital stay accurate.

US money formats, parsed right

Dollar signs, thousands commas, parenthesized negatives — and Schwab's 3-decimal prices like $57.305, which generic parsers turn into 57,305. Here they stay $57.305.

Lot Details for positions you already own

The second Schwab export. Each open tax lot becomes an opening position with its real open date and cost per share — the clean way to backfill holdings that predate your journal.

Safe re-imports

Every trade carries a content fingerprint. Re-running a file, or importing overlapping date ranges, flags duplicates on the preview step and skips them.

One thing the Transactions export can't give you: the account-wide Positions snapshot is a picture of what you hold today, with no dated fills in it, so there are no trades to import from it — upload one and TickerScribe says so instead of leaving you to map it. Files from any other source land through the universal CSV mapper: columns auto-suggested, confirmed once, remembered after.

Two minutes from schwab.com

Your whole Schwab history, in one place

No credit card required. Export your history, drop it in — cost basis intact.

Start Your Free Journal

Frequently Asked Questions

Is TickerScribe really free?
Yes — completely free, no credit card, no trade caps. Import your full Schwab history, journal your trades, and keep ledger-accurate P&L without paying anything.
Which Schwab files does TickerScribe auto-detect?
Two: the Transactions export (Accounts → History → Transactions → Export) for your full activity — trades, dividends, transfers — and the per-holding Lot Details export for backfilling the cost basis of positions you already own. Both are recognized on upload with zero column mapping.
What are 3-decimal prices, and why do they matter?
Schwab sometimes reports prices like $57.305 — three decimals, usually from dividend reinvestments. Generic money parsers misread that as 57,305. TickerScribe parses US money formats correctly — dollar signs, thousands commas, parenthesized negatives, and 3-decimal prices all come across as the numbers they are.
What is the Lot Details export for?
Backfilling positions you already hold. It's a per-symbol cost-basis snapshot — every open lot with its open date, quantity, and cost per share. TickerScribe turns each lot into an opening position, so holdings you bought before you started journaling carry their real cost basis. One caveat: download it fresh from Schwab and import it directly — the stock symbol lives in the file's title row, which Excel strips on re-save. If that happens, TickerScribe tells you exactly what went wrong.
Do Schwab options trades import automatically?
Yes — from the same Transactions export, with no extra step. Opens and closes pair into round trips, expirations and assignments book as closes so the premium lands where it belongs, an assigned put's shares arrive as a lot marked assigned (which is what the wheel view reads), and the legs of a spread are grouped as one position rather than filed as unrelated singles.
Schwab caps exports at 10,000 rows — what about long histories?
Export in date-range chunks and import the files one after another. Every trade carries a content fingerprint, so overlapping ranges are safe — duplicates are flagged on the preview step and skipped.
I place my trades in thinkorswim. Which export do I use?
The thinkorswim one. Schwab owns thinkorswim, but the two platforms write different files and each has its own reader — the Account Statement, Trade Activity and Transaction Ledger exports are covered on the thinkorswim page. Either file is safe to try: the wizard identifies what you dropped in and tells you if it isn't a match, before anything is saved.
More brokersRecognized on sight

// keep exploring

Explore More Features

Options Journal

30+ strategies, rollover chains, Greeks & IV, per-leg P&L.

Stock Journal

Position grouping, cost basis methods, and one-click logging.

Short Selling

A sell that opens the position, a buy-to-cover that closes it, P&L the right way round.

Daily Journal

Notes, plan & reflection, mood, tags, and chart screenshots — per day.

Trade Notes

Notes, tags, and screenshots per trade — and a scoreboard of how each setup performs.

Performance Dashboard

KPIs, cumulative P&L chart, and portfolio overview.

P&L Calendar

Shareable daily P&L heatmap with drill-down.

Trade Analysis

Price ranges, day-of-week P&L, and time-of-day patterns.

Wheel Analysis

Puts, covered calls, and assignments — stitched into cycles with annualized return.