Upload any Vanguard statement PDF — Vanguard Brokerage, Roth IRA, Traditional IRA, SEP IRA, 529 College Savings, plus year-end consolidated 1099s — and get a clean Excel file with holdings, transactions, dividends, and realized gains/losses on separate sheets.
Convert your Vanguard statement — free
Vanguard statements group activity by fund (VTI, VTSAX, VFIAX, etc.) rather than chronologically — each fund gets its own holdings + transactions block on a separate page. Generic PDF tools that scan top-to-bottom either fragment each fund block as orphan tables or merge them in a way that loses the fund attribution. Multi-account households (taxable + Roth IRA + Traditional IRA + 529) compound the problem with multiple ledgers per statement.
Vanguard's year-end consolidated 1099 (separate from monthly statements) follows the same per-fund structure — qualified vs ordinary dividends per fund, capital gain distributions per fund, return of capital per fund. Tax preparers retyping per-fund tax detail across multiple holdings spend hours per Vanguard client during busy season.
PDFExcel reads Vanguard's per-fund structure automatically. Holdings extract with fund symbol, fund name, shares, market value, and cost basis — each fund as its own row. Transactions extract with fund attribution preserved. Dividends extract per fund with payment date, amount, and tax classification (qualified / ordinary / return of capital). Realized G&L extracts with short-term vs long-term split — Schedule D-ready.
Multi-account households split per account type (Brokerage / Roth / Traditional / SEP / 529) with each account's data on its own sheet. Year-end consolidated 1099s reconcile across 1099-DIV / 1099-B sections. Pair with 1099 extraction for cross-broker tax-prep consolidation alongside Schwab and Fidelity 1099s.
The model knows that Vanguard's fund-family-first organization keeps per-fund attribution intact — and that VTI is an ETF (taxable account events) while VTSAX is its mutual-fund equivalent (similar tax events but different distribution patterns). Trained on real Vanguard statements.
Most brokerage-statement tools focus on advisor-managed Schwab and Fidelity accounts. Vanguard is heavily DIY-investor — and the per-fund organization breaks tools that assume chronological transactions.
Per-fund attribution preserved. Account type tagged so taxable Brokerage and Roth IRA holdings stay distinguishable for tax prep.
| # | Fund | Account | Shares | Cost Basis | Market Value | Unrealized G/L |
|---|---|---|---|---|---|---|
| 1 | VTSAX (Total Stock Market Idx Adm) | Brokerage | 284.182 | $28,420.10 | $42,180.40 | $13,760.30 |
| 2 | VTSAX (Total Stock Market Idx Adm) | Roth IRA | 184.420 | $18,200.00 | $27,360.40 | $9,160.40 |
| 3 | VTIAX (Total Intl Stock Idx Adm) | Roth IRA | 212.840 | $22,140.00 | $26,210.20 | $4,070.20 |
| 4 | VBTLX (Total Bond Market Idx Adm) | Traditional IRA | 148.200 | $14,810.00 | $15,420.40 | $610.40 |
| 5 | VTI (Total Stock Market ETF) | Brokerage | 62.000 | $11,840.00 | $15,280.00 | $3,440.00 |
| 6 | VFIFX (Target Retirement 2050) | 529 | 84.420 | $3,420.00 | $4,180.20 | $760.20 |
DIY index investors tracking household-level Vanguard portfolios, tax preparers handling Vanguard clients, family offices managing multi-account households, fee-only advisors with self-directed Vanguard clients.
Manages 4 Vanguard accounts (taxable + Roth + Traditional + 529). Convert year-end consolidated 1099 + holdings statement, build a household-level allocation worksheet for next-year contribution planning.
HNW client with Vanguard taxable + Roth + Traditional. Convert all three statements, pull only taxable Brokerage realized G&L for Schedule D — IRA realized gains correctly excluded.
Manages allocation across 30 self-directed Vanguard clients. Quarterly statement review pulls Holdings sheet per client, builds household-level reports for the firm's portfolio-tracking system.
Yes. Vanguard organizes statements by fund family rather than chronologically; each fund gets its own holdings + transactions + dividends block. PDFExcel keeps the fund attribution intact across all sections.
Yes. Multi-account households split per account type into separate sheets. Taxable Brokerage realized gains stay distinguishable from IRA realized gains (which aren't reportable on Schedule D).
Yes. The 1099-DIV (qualified vs ordinary dividends per fund, return of capital) and 1099-B (realized G&L per fund) sections each extract as their own sheet. See 1099 extraction for cross-broker consolidation.
Yes. Vanguard 529 statements (offered through state plans like NV529, NY529) extract with the same workflow. Account Type column tags them as 529 so you don't accidentally treat 529 events as taxable.
10 documents per month, free, forever. Most DIY indexers (1-4 accounts, 4 statements per year) fit easily in the free tier. Plans from $69/month for 50 documents — for tax preparers handling busy-season Vanguard volume.