// 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.

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 $42.605 problem, solved.

Schwab writes prices most parsers get wrong — $42.605 turns into 42,605 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.

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 $42.605, which generic parsers turn into 42,605. Here they stay $42.605.

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.

Trading options at Schwab? Those exports aren't auto-detected yet — they import 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.

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 $42.605 — three decimals, usually from dividend reinvestments. Generic money parsers misread that as 42,605. 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?
Not yet — the auto-detected Schwab exports cover stocks and cash activity. Options exports import through the universal CSV mapper: TickerScribe reads your headers and auto-suggests a match for every column, you confirm once, and the mapping is remembered.
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.