Turn a Vanguard PDF statement into a clean Excel (XLSX) or CSV file in seconds. Trades, dividends, capital gains distributions, reinvestments, contributions, and cash activity land in labeled columns with recalculated running balances, ready for reconciliation, tax prep, and analysis.
Works with brokerage, mutual-fund, IRA, Roth IRA, 401(k), and 529 statements. Digital or scanned PDF.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Last updated July 2026
BankXLSX converts a Vanguard PDF statement into a structured Excel (XLSX) or CSV file, separating trades, dividends, capital gains distributions, reinvestments, contributions, and cash activity into labeled columns with recalculated running balances. Vanguard's own transaction download, under Activity and the Download center, reaches back only about 18 months, so older history lives in the statement PDFs. Upload one statement or several years of PDFs here and download clean rows in one pass.
Open a Vanguard PDF statement, select a block of transactions, and paste it into Excel. The dates arrive as text Excel will not sort. Fund share quantities and prices collide in one cell. Dividends, reinvestments, and cash activity run together. What should take five minutes becomes an hour of re-typing and re-checking.
Vanguard does offer a CSV download, but the Activity and Download center export reaches back only about 18 months, while the monthly and quarterly statement PDF stays available far longer. When you need several years, a full tax history, or a closed account, the PDF is the record you actually have. This converter reads that PDF and hands back a clean spreadsheet in one step.
A single Vanguard statement can combine a brokerage account, a mutual-fund account, and a retirement account. The converter separates each activity type so the spreadsheet is actually usable.
Buys, sells, dividends, capital gains distributions, and reinvestments each carry a fund or security name, quantity, price, and amount. Pasted by hand these smear across cells. The converter keeps the description together and puts the dollar amount in its own numeric column so SUM and pivot tables work at once.
Vanguard IRA, Roth IRA, 401(k), and 529 accounts show contributions, transfers, and cash sweep activity. Each line carries a description and a date. The parser tags every line with a transaction type so you can filter for just contributions, just trades, or just cash movements.
Note on tax lines: Vanguard statements list dividends, capital gains distributions, and interest. Those land in separate rows tagged DIV, GAIN, and INT so you can total investment income for a return without re-reading the whole document.
Sign in at Vanguard.com, open your account, and download the monthly or quarterly statement PDF. Grab as many periods as you need, including years older than the 18-month export window. Scanned copies and mailed statements work too.
Drop the file into the upload box at the top of this page. The converter reads the document structure, finds the transaction tables, separates trades from cash and contribution activity, and pulls out dates, amounts, and reference numbers. Upload several years at once if you want.
In under 30 seconds you get a preview, then download as Excel XLSX or CSV. Import it straight into QuickBooks, Xero, or a tax workbook, or open it in Excel or Google Sheets and start building pivot tables.
| Column | What is in there | Why it matters |
|---|---|---|
| Date | Transaction date as MM/DD/YYYY | Excel reads it as a real date, so sorting and date math work |
| Description | Fund name or full activity detail | Keeps the detail intact for reconciliation and lookups |
| Type | BUY, SELL, DIV, GAIN, INT, CONTRIB | Filter for just trades, just dividends, or just contributions |
| Quantity and price | Shares and per-share price on trades | Cost basis and gain calculations without re-keying |
| Amount | Debit or credit as currency | Real numbers, so SUM and AVERAGE work immediately |
| Balance | Running balance after each line | Recalculated and checked against the statement totals |
The converter recomputes the running balance from your transactions and compares it against the statement totals. If a line is missing or a number was misread, you see a warning before you download instead of finding a gap weeks later during reconciliation.
Clients forward a stack of Vanguard PDFs at tax time. Convert several years in one pass, categorize with a Type column, and use pivot tables to total dividends, capital gains, and interest for the return.
IRA, Roth IRA, 401(k), and 529 accounts run contributions and reinvestments over many years. Export to Excel to track contributions against annual limits and reconcile every reinvested dividend.
The 18-month export cap makes multi-year history painful. Convert several years of statement PDFs at once to rebuild a trade log with quantities, prices, and amounts in clean columns.
Lenders and auditors want searchable records, not PDFs. Hand over an Excel file with formatted dates, amounts, and validated balances so they can filter and sort on their own.
Transfers use SSL encryption, the same standard banks use.
Files are removed from our servers right after processing.
We do not keep your statements or transaction data.
Download the monthly or quarterly PDF from Vanguard.com, upload it to the converter at the top of this page, and download the result as Excel XLSX or CSV. The whole process takes under a minute per statement.
Yes. Vanguard offers its own CSV export through the Activity and Download center, but it reaches back only about 18 months. Converting the statement PDF instead gives you several years, a full tax history, or a closed account in one clean CSV or Excel file.
As far back as you have the PDFs. Vanguard's transaction export is capped near 18 months, but the statement PDFs go back much further, so you can download and convert older periods the online export no longer shows.
Yes. Brokerage, mutual-fund, IRA, Roth IRA, 401(k), and 529 statements all convert. Trades, dividends, capital gains, contributions, and cash activity each get their own tagged rows so you can filter by account or activity type.
Yes. Upload multiple PDFs in one batch. Each is processed separately, and you can download them individually or combine several years into a single spreadsheet.
Yes. Built-in OCR reads scanned pages and phone photos, with 99%+ accuracy on clear images. For best results, keep the statement flat and well lit so the text is sharp.
Working with statements from more than one firm? Start at the bank statement converter home page, send any PDF straight to a spreadsheet with the PDF bank statement to Excel converter, or convert another brokerage account with the Fidelity statement converter or Charles Schwab statement converter.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
