To export from Vanguard: log in, open My Accounts → Transaction history → Download, then pick the format, date range and — important — one account at a time. The CSV window reaches back 18 months; older history is still there, but only as PDF (up to ~10 years). Multi-account pulls are the known way to end up with a scrambled file.
By US broker standards, Vanguard’s export is generous — 18 months beats the typical 90-day window several times over. The catch arrives in year three, when you need history the CSV no longer covers. Here’s the exact flow, the one-account rule, and the PDF fallback that saves old records.
Key Takeaways
- Export path: My Accounts → Transaction history → Download → format + range + account.
- The window: CSV reaches back 18 months — generous, but not an archive. PDFs go back ~10 years.
- The rule: export one account at a time — multi-account pulls are known to mangle the file.
- The formats: CSV for spreadsheets; OFX/QFX exist separately for Quicken (the CSV won’t import there).
Where is the CSV export in Vanguard?
In Transaction history’s download option — Vanguard’s Download Center. The steps, on the website:
- Log in at vanguard.com and open My Accounts → Transaction history.
- Choose Download and pick CSV as the format (OFX/QFX are for Quicken-type software, not spreadsheets).
- Set the date range — anything within the last 18 months works.
- Select one account, download, and repeat per account — taxable, traditional IRA and Roth each get their own file.
The 18-month window quietly rolls forward every day — history doesn’t wait for tax season. Export each account once a year, right after year-end, and the window never catches you. Keeping accounts in separate files is a feature, not a chore: taxable, traditional IRA and Roth live in different tax universes anyway.
The 3 things that trip people up
| Trap | What happens | Fix |
|---|---|---|
| The 18-month CSV window | Year-three records are out of CSV reach | Annual exports going forward; for older years, download the PDF history (~10 years) as evidence |
| Multi-account pulls | Combined exports are known to arrive scrambled | One account per file, always — label files by account and year |
| Wrong format for the job | The CSV won’t import into Quicken; OFX won’t open cleanly in Sheets | CSV for spreadsheets and trackers; OFX/QFX only for Quicken-type software |
What’s in the file — and what to watch
One row per event — trades, dividends, capital-gains distributions, contributions and exchanges — with dates, funds/tickers, quantities, prices and amounts. Vanguard-specific habits: mutual-fund investors will see exchanges (sell one fund, buy another) as paired rows — keep both, they’re two taxable ends of one decision; and don’t round fractional quantities, which mutual funds produce on almost every row.
Isn’t my 1099 enough for taxes?
For filing, mostly yes. For proving, no. Vanguard’s consolidated 1099 covers what Vanguard knows for that year — but positions transferred in with older basis, wash sales that span brokers, and any question the IRS asks years later are yours to substantiate. Your exports are that evidence trail — which is exactly why the 18-month window deserves an annual ritual rather than a deadline scramble.
Using more than one platform? Our free US broker export cheat-sheet covers the export path, format and trap for 8 US platforms on one page. For the walkthroughs: Fidelity (90-day cap), Schwab (silent row limit) and Robinhood (generate-and-wait).
Keep every year’s export permanently. Broker interfaces, windows and formats change without notice — your saved files are the record that survives. This guide covers Vanguard’s US platform (vanguard.com); Vanguard UK is a separate service with a different export flow. Avex AI provides software and educational content, not investment or tax advice. Avex AI is not affiliated with or endorsed by Vanguard.
18 months — a rolling window, not an archive. Older history remains viewable and downloadable as PDF for roughly 10 years, which works as evidence but not as spreadsheet data. Annual exports keep you ahead of the window.
Combined pulls across accounts are a known weak spot of the download tool. Export one account at a time — you also want taxable, traditional IRA and Roth in separate files anyway, since they live under different tax rules.
CSV for spreadsheets and portfolio trackers. OFX/QFX exist for Quicken-type software and won’t open cleanly as tables — and the reverse is also true: the CSV won’t import into Quicken.
Yes — dividends, capital-gains distributions, contributions and exchanges appear as typed rows alongside trades. Exchanges arrive as paired rows (a sale and a purchase); keep both.
The 1099 covers filing for that broker and that year. Transferred cost basis, cross-broker wash sales and any later IRS questions need your own records — and with an 18-month CSV window, records you didn’t export on time can be hard to rebuild.
