To export from Vanguard: log in, open My Accounts → Transaction history → Download, then pick the format, date range and account. Vanguard’s public pages don’t state how far back the download reaches; third-party reports put it at roughly 18 months, with older history viewable on the site and in PDF statements. Our recommendation: one account per file, exported yearly.
Vanguard’s export is straightforward; the catch is that nobody publishes how far back it reaches, so the records you didn’t export in time can be hard to rebuild. 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: not documented by Vanguard; third-party reports say about 18 months for downloads — export yearly and treat PDFs as the archive.
- The rule (ours): one account per file — taxable, traditional IRA and Roth live under different tax rules, and a mixed file is harder to reconcile.
- 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 (third-party reports suggest roughly the last 18 months is available for download)
- Select one account, download; repeat per account (the tool can select several portfolios at once, but separate files are easier to reconcile)
Whatever the download window is, it rolls forward — 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 download window (reported ~18 months) | Older records may be out of download reach | Annual exports going forward; for older years, save the PDF statements as evidence |
| Mixed-account files | Several accounts in one file are harder to reconcile and mix tax wrappers | One account per file — label 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 a limited download window matters
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.
Vanguard’s public pages don’t say. Third-party reports put the download window at roughly 18 months, while older history stays viewable on the site and in PDF statements. Export each account yearly so the question never matters.
A file that mixes taxable, traditional IRA and Roth accounts is hard to reconcile — the accounts live under different tax rules. Export one account at a time and label each file by account and year.
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 — with an 18-month CSV window.
Sources & references
- Vanguard — Technical support: downloading to personal financial software (CSV, Quicken, Money)
- Portseido — Exporting trades from Vanguard (third-party guide: path and portfolio selection)
- Quicken Community — Download Vanguard transactions older than 18 months (third-party; source of the 18-month figure)
- IRS — Topic 409: Capital Gains and Losses
- IRS — Publication 550: Investment Income and Expenses (wash sales)
Last verified: 31 October 2026. This guide covers Vanguard’s US platform (vanguard.com); Vanguard UK is a separate service. The download window is a third-party figure, not a Vanguard statement, and was not reproduced on a live account.
