How To Convert a Vanguard Brokerage Statement to Excel
Vanguard brokerage statements often span multiple registrations (taxable, IRA, 529) and emphasize fund holdings over individual security trades. This guide shows how to convert a Vanguard PDF into Excel.
Vanguard statements look different from Schwab and Fidelity. They lean heavily on mutual fund holdings (VFIAX, VTSAX, VTI, etc.) rather than individual stock trades, and households often hold multiple registrations, taxable brokerage, Traditional IRA, Roth IRA, and 529, combined into one quarterly statement.
This walkthrough shows how to convert a Vanguard brokerage PDF to Excel with DocuClipper's brokerage statement converter.
While you are here
Extract holdings and activity from any broker PDF
Upload a brokerage statement from Fidelity, Schwab, Vanguard, Merrill, E*TRADE, or Robinhood and DocuClipper returns structured tables (positions, buys/sells, dividends) ready to export.
How DocuClipper maps Vanguard sections to Excel sheets
| Vanguard section | Excel sheet | Key columns |
|---|---|---|
| Account Summary | Summary | Beginning balance, ending balance, change, contributions, withdrawals, distributions |
| Holdings (per registration) | Holdings | Fund / symbol, share_class, quantity, share_price, cost_basis, market_value, asset_class |
| Activity | Activity | date, type (buy / sell / dividend / contribution / withdrawal / reinvest), fund, quantity, price, amount |
| Income & Distributions | Income | date, fund, distribution_type (ordinary div / qualified div / cap gain / interest), amount |
Each row carries account_type (Brokerage, Roth IRA, Traditional IRA, 529 Plan) and registration (e.g. JTWROS, Custodian) so combined household statements can be filtered or split.
Step 1: Upload the Vanguard PDF
Drop the Vanguard statement PDF onto the upload widget. Both digital downloads (from vanguard.com) and scans/photos of mailed paper statements work, image PDFs are OCR'd first.
Vanguard quarterly statements covering multiple registrations land in a single PDF; you don't need to split them before uploading.
Step 2: Review extracted fund holdings
The Holdings sheet is where Vanguard data is densest. For each fund (mutual fund or ETF), DocuClipper extracts:
- Fund identifier: Symbol (e.g.
VTSAX) plus the long fund name (e.g. "Vanguard Total Stock Market Index Fund Admiral Shares"). - Share class: Investor / Admiral / Institutional are tagged in
share_classso you can compare expense ratios or roll up across share classes. - Quantity: Full decimal precision for fractional shares (Vanguard mutual funds always trade fractionally).
- Cost basis: When printed on the statement (taxable brokerage). IRAs and 529s typically omit cost basis.
ETFs (VTI, VOO, etc.) extract the same way as mutual funds, into the same Holdings sheet.
Step 3: Walk the Activity section
Vanguard's Activity covers contributions, withdrawals, dividends (cash or reinvested), capital gains distributions, and any fund switches. DocuClipper preserves the full breakdown:
- Reinvested distributions appear as both an Income row (the distribution) and an Activity row (the reinvested purchase), matching how Vanguard prints them.
- Fund switches (selling VTSAX to buy VTIAX, for example) appear as a sell + buy pair on the same date.
- IRA contributions are tagged with the contribution year (
contribution_year=2025etc.) when Vanguard prints it.
Put it into practice
Manually copying brokerage data creates reconciliation errors
Cost basis, market value, realized gains: these numbers compound errors when retyped. DocuClipper extracts them directly from the statement so holdings and activity tie out the first time.
Step 4: Confirm reconciliation, export
The Summary row carries a reconciled flag, DocuClipper computes period-end as starting balance + contributions + distributions + market change – withdrawals, and compares to Vanguard's printed ending balance. Mismatches are highlighted before export.
Click Export → Excel for a single .xlsx workbook (Holdings, Activity, Income, Summary), or Export → CSV per sheet.
Vanguard-specific notes
- Mutual funds vs ETFs: Both land in the Holdings sheet. The
vehiclecolumn distinguishes them (mutual_fund/etf). - Money market sweep: Vanguard's settlement fund (VMFXX) activity appears in Activity tagged
mmf_sweepso it doesn't get conflated with trades. - 529 plan registrations: Vanguard 529 statements use slightly different column names than the brokerage template; auto-detection routes them through the same pipeline with
account_type=529. - Vanguard PAS (Personal Advisor Services): managed-account statements use the same brokerage template; advisory fees show in Activity with
type=advisory_fee. - Fund expense ratios are not on the brokerage statement and are not extracted (they're in fund prospectuses).
Frequently asked questions
Does it handle Vanguard's old "Mutual Fund Account" format?
Vanguard has been migrating mutual-fund-only accounts to brokerage. Both the legacy mutual-fund-account format and the current brokerage format are detected; the brokerage format is the one most users see today.
Cost basis on IRAs?
Vanguard typically doesn't print cost basis on retirement-account holdings (it's not a tax-relevant figure for IRAs). The Holdings sheet leaves the column blank when the statement omits it.
Can I see contributions by year?
Yes, when Vanguard prints the contribution year (e.g. "2025 contribution") on a deposit line, it's preserved in the contribution_year column. Useful for tracking annual IRA contribution caps.
Combined household statements with multiple registrations?
Supported. Each row is tagged with the account type (Brokerage / Roth IRA / Traditional IRA / 529) and registration. You can filter or split into per-registration workbooks.
Does this convert Vanguard 1099 forms?
No, those are separate tax documents. This converts the monthly/quarterly account statement. For 1099 extraction, see tax form data extraction.
Related Articles
- Brokerage Statement Converter
- Brokerage Statement to Excel
- Best Brokerage Statement Converter Software
- How to Convert a Fidelity Brokerage Statement to Excel
- How to Convert a Schwab Brokerage Statement to Excel
- How to Convert a Merrill Lynch Statement to Excel
- How to Convert an E*TRADE Statement to Excel
- How to Convert a Robinhood Statement to Excel
- How to Convert an Interactive Brokers Statement to Excel
Next step
Convert your brokerage statement: free 14-day trial
Upload any PDF brokerage statement and download Holdings, Activity, and Income in a clean Excel workbook. No credit card required.