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 the 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 shown in a share class column so 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 (2025 and so on) 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
Every statement is checked against its printed balances: starting balance + contributions + distributions + market change - withdrawals has to equal Vanguard's printed ending balance, and the Summary row shows whether it does. 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. A column marks each one as a mutual fund or an ETF.
- Money market sweep: Vanguard's settlement fund (VMFXX) activity appears in Activity marked as money market sweep activity so it doesn't get conflated with trades.
- 529 plan registrations: Vanguard 529 statements use slightly different column names than the brokerage template; DocuClipper handles them the same way and marks the account type as 529.
- Vanguard PAS (Personal Advisor Services): managed-account statements use the same brokerage template; advisory fees show in Activity marked as advisory fees.
- 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 a 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.