Upload any Charles Schwab statement PDF — Schwab One brokerage, Schwab IRA, Schwab High Yield Investor Checking, plus year-end consolidated 1099s — and get a clean Excel file with holdings, transactions, dividends, and realized gains/losses on separate sheets.
Convert your Schwab statement — free
A typical Schwab brokerage statement runs 30-60 pages with separate sections for Holdings, Transactions, Dividends Earned, Realized Gains and Losses, Account Summary, Investment Detail by Asset Class, and supplemental notices. Tax preparers pulling year-end 1099 data, wealth managers reviewing client positions, and individual investors tracking cost basis all face the same problem: every section is its own table, on its own page, with its own column structure.
Schwab's year-end consolidated 1099 (separate from the brokerage statement but often arrived together) covers 1099-DIV, 1099-INT, 1099-B, and 1099-MISC sections all in one PDF. The summary page numbers reconcile to per-section detail across 50+ pages.
PDFExcel reads Schwab statements section by section. Holdings extract with security name, symbol, shares, market value, and cost basis. Transactions extract with date, description, amount, security symbol, and shares. Dividends extract per security with payment date, amount, and tax classification. Realized gains/losses extract with acquired date, sold date, basis, and gain/loss — ready for Schedule D / Form 8949.
Year-end consolidated 1099s reconcile from the summary page through the per-section detail (1099-DIV / 1099-INT / 1099-B / 1099-MISC). Drop the export into your tax-software's import or use as a tax-prep checklist. Pair with 1099 extraction to consolidate Schwab data alongside other brokers' 1099s in one workbook.
The model knows that 'Box 1a' on Schwab's consolidated 1099 is ordinary dividends and 'Box 1b' is qualified dividends, that long-term and short-term realized gains belong on separate Schedule D pages, and that wash-sale-adjusted basis appears as a separate disclosure.
Most brokerage-statement tools either need a Schwab API integration (limited to advisor-managed accounts) or charge per-page at advisor scale. PDFExcel reads any Schwab PDF directly — including individual-investor and IRA accounts.
Schedule D-ready format — short-term and long-term separated, wash-sale-adjusted basis preserved.
| # | Security | Shares | Acquired | Sold | Proceeds | Basis | Gain/Loss |
|---|---|---|---|---|---|---|---|
| 1 | AAPL | 100 | 06/15/2022 | 11/14/2024 | $23,140.00 | $13,820.00 | $9,320.00 |
| 2 | MSFT | 50 | 03/22/2023 | 11/14/2024 | $21,180.00 | $13,460.00 | $7,720.00 |
| 3 | TSLA | 25 | 01/12/2024 | 08/22/2024 | $5,210.00 | $6,440.00 | ($1,230.00) |
| 4 | VTI | 120 | 07/05/2021 | 12/02/2024 | $32,460.00 | $27,840.00 | $4,620.00 |
| 5 | NVDA | 10 | 05/18/2024 | 10/03/2024 | $11,840.00 | $8,420.00 | $3,420.00 |
Tax preparers handling individual returns with brokerage activity, wealth managers reviewing client portfolios, family offices tracking household-level positions, individual investors managing personal portfolios.
Client has Schwab brokerage with 40 short-term + 60 long-term realized transactions. Convert the year-end consolidated 1099 → Realized G&L sheet → Schedule D entry done in 20 minutes vs 2 hours of typing.
Quarterly portfolio review for 30 HNW clients on Schwab. Convert each client's statement, extract Holdings sheet, drop into the firm's portfolio-reporting template.
Tracks personal Schwab portfolio for tax-loss harvesting. Converts monthly statements, builds a year-to-date realized-G&L worksheet for harvesting decisions.
Yes. The 1099-DIV / 1099-INT / 1099-B / 1099-MISC sections each extract as their own sheet. Summary-page numbers reconcile to the per-section detail. See 1099 extraction for cross-broker consolidation.
Yes. Cost basis extracts with each realized transaction, and wash-sale-adjusted basis (when present) appears as a separate adjustment column. Important for accurate Schedule D filing.
Yes. Schwab IRA and Roth IRA statements use a similar layout to brokerage statements but tag the account type so you don't accidentally pull IRA realized gains into Schedule D (they're not reportable). The Account Type column distinguishes.
Yes. Schwab Checking statements use a more traditional bank-statement layout and extract through the standard bank-statement workflow alongside brokerage statements in the same upload.
10 documents per month, free, forever. Plans from $69/month for 50 documents — most tax preparers handling 10-50 Schwab clients during busy season fit Pro at $199/month for 200 documents.