Drop in any brokerage statement PDF — Charles Schwab, Fidelity, Vanguard, E*TRADE / Morgan Stanley, Merrill, TD Ameritrade, Interactive Brokers, Robinhood — and get a clean Excel file with holdings, transactions, dividends, and realized gains/losses on separate sheets. Year-end consolidated 1099s reconcile across DIV / INT / B / MISC sections.
Convert your first statement — free
Schwab organizes by section. Fidelity has different layouts per product (Brokerage / IRA / NetBenefits 401(k) / Cash Management). Vanguard organizes by fund family. E*TRADE adds Stock Plan supplemental schedules for RSU and ESPP. Robinhood mixes stock + options + crypto. Merrill cash management looks like a bank statement. Generic PDF tools handle one layout and break on the others.
Tax preparers handling diversified clients see all six in a single envelope during busy season. Wealth advisors building household-level portfolio reports pull statements from multiple custodians. DIY investors tracking taxable + IRA + 401(k) across providers face the same retyping wall every quarter.
PDFExcel reads Schwab, Fidelity, Vanguard, E*TRADE / Morgan Stanley, Robinhood, Merrill, TD Ameritrade, Interactive Brokers, and most regional broker-dealer statements with the same workflow. Holdings, transactions, dividends, and realized G&L extract as separate sheets with consistent column structure across brokers — making cross-custodian household reports practical.
Account type (Brokerage / IRA / Roth IRA / 401(k) / 529 / Stock Plan) tags every row so taxable Schedule D events stay distinguishable from tax-deferred IRA events. Year-end consolidated 1099s reconcile across DIV / INT / B / MISC sections. Pair with 1099 extraction for cross-broker tax-prep consolidation.
The model knows custodian-specific layout quirks (Schwab section structure, Fidelity multi-product, Vanguard per-fund, E*TRADE Stock Plan, Robinhood options) — and normalizes them into a consistent column structure so cross-broker household reports work.
Most brokerage tools either need a custodian-specific API integration (advisor-managed only) or charge per-page at multi-account-household scale. PDFExcel reads any client-provided PDF directly.
Custodian + account type tagged on every row. Cross-custodian aggregation works — pivot by symbol to see total household exposure regardless of where it's held.
| # | Custodian | Account | Symbol | Shares | Cost Basis | Market Value |
|---|---|---|---|---|---|---|
| 1 | Schwab | Brokerage | AAPL | 200 | $27,640.00 | $46,280.00 |
| 2 | Fidelity | Roth IRA | AAPL | 150 | $20,730.00 | $34,710.00 |
| 3 | Vanguard | Brokerage | VTSAX | 284.182 | $28,420.10 | $42,180.40 |
| 4 | E*TRADE | Stock Plan RSU | TECH | 409 | $118,647.60 | $124,148.00 |
| 5 | Robinhood | Brokerage | BTC | 0.42 | $24,800.00 | $28,420.00 |
CPAs handling high-net-worth individual returns with diversified custodians, wealth managers building household-level reports, family offices tracking multi-generation portfolios, DIY investors managing across brokers.
Client has 7 accounts across Schwab + Fidelity + Vanguard + Robinhood. Convert all year-end statements as one batch, build a single Schedule D / Form 8949 entry workbook covering every taxable event across custodians.
Quarterly review for 30 households across multiple custodians. Convert each household's statement bundle, build a consolidated household-level position view that the firm's portfolio system can ingest.
Holds at Schwab + Fidelity + Vanguard for diversification. Quarterly conversion + pivot in Excel reveals true asset-allocation across custodians (one symbol can show up in three places).
Yes — Schwab, Fidelity, Vanguard, E*TRADE / Morgan Stanley, Merrill, TD Ameritrade, Interactive Brokers, Robinhood, plus most regional broker-dealers. Each custodian has its own dedicated page with custodian-specific guidance, but the unified pillar workflow handles them all consistently.
Yes. Custodian and Account Type columns tag every row so cross-custodian aggregation works. A symbol held at Schwab Brokerage + Fidelity Roth IRA + Vanguard 529 shows up as 3 rows pivot-able to one household-level position.
Yes — most heavily on E*TRADE (the dominant employer stock-plan recordkeeper). Stock Plan supplemental schedules extract with vest dates, FMV, ordinary income, and adjusted cost basis.
Yes. Each custodian's consolidated 1099 (1099-DIV / 1099-INT / 1099-B / 1099-MISC) extracts as separate sheets. Run a tax-season batch upload mixing 1099s from 4 custodians — one workbook back with everything reconcilable.
10 documents per month, free, forever. Plans from $69/month for 50 documents — most DIY investors fit Starter; preparers and advisors handling 10-50 client portfolios fit Pro at $199/month for 200 documents.