Vanguard → Excel
Convert a Vanguard brokerage statement PDF to Excel
Vanguard statements report activity per fund, so a portfolio of five funds produces five blocks of dated rows in one PDF. They convert into a single sheet you can pivot by fund. Every row is checked against the running balance before you get the file, so the figures reconcile instead of just looking plausible.
3 pages free· then $3 a brokerage statement· no account, no card
All pricing →Convert your Vanguard brokerage statement
3 pages free. No account, no card.
Your file is deleted after processing — we keep no copy. What we do with it.
What you get
Your statement, already reconciled
Left, the text as it comes out of a statement PDF. Right, the sheet you download — same figures, in columns, each one checked against the balance the bank printed.
STATEMENT OF ACCOUNT Page 1 of 3
BALANCE BROUGHT FORWARD 1,250.50
03DEC25 TESCO STORES 4821 GB
42.10- 1,208.40
05DEC25 ACME LTD SALARY
2,400.00 3,608.40
09DEC25 BRITISH GAS DD
118.62- 3,489.78
14DEC25 TFL TRAVEL CH
38.40- 3,451.38
21DEC25 CARD PAYMENT REF 90
560.00- 2,891.38
31DEC25 INTEREST PAID
1.24 2,892.62
BALANCE CARRIED FORWARD 2,892.62
| date | description | amount | balance | checked |
|---|---|---|---|---|
| 2025-12-03 | Tesco Stores 4821 | -42.10 | 1,208.40 | |
| 2025-12-05 | Acme Ltd salary | +2,400.00 | 3,608.40 | |
| 2025-12-09 | British Gas DD | -118.62 | 3,489.78 | |
| 2025-12-14 | TfL travel charge | -38.40 | 3,451.38 | |
| 2025-12-21 | Card payment ref 90 | -560.00 | 2,891.38 | |
| 2025-12-31 | Interest paid | +1.24 | 2,892.62 |
Get the PDF
Where Vanguard keeps your brokerage statement PDF
The exact path through Vanguard.
- 1Log on at vanguard.com.
- 2Select the My Accounts tab, then Statements.
- 3Choose the account and the statement period.
- 4Open and save the PDF — Vanguard delivers documents in PDF only.
Convert it
Turning that PDF into Excel
- 1Download the PDF Take the Vanguard brokerage statement using the steps above.
- 2Upload it here One statement or a multi-page month — the first 3 pages convert free, with no account.
- 3Check the rows, then download You see the extracted rows and the balance check before paying for anything. A ready-to-use .xlsx spreadsheet, with date, description, amount and balance.
In Excel
What the Vanguard file does when you open it
The conversion is half the job. This is the other half.
- 1It opens straight into Excel — no import wizard, no Text to Columns. Amounts are stored as numbers and dates as dates, so =SUM() over the amount column works the moment the file is open, and sorting by date puts the month in order rather than in alphabetical order.
- 2The header row is frozen and filters are switched on, so a 300-row statement stays navigable without setting either up.
- 3A second sheet, Reconciliation, carries the arithmetic: the opening balance, money in, money out, the closing balance printed on the statement, and the difference between that and the rows. It travels with the file, so it is still there when the file reaches a client or an auditor.
- 4Any row the parser could not resolve confidently is shaded amber and scored in a confidence column. Filter that column to review those rows first rather than reading all of them.
Your file
What happens to the brokerage statement you upload
You're handing a financial document to a website you found through a search result. Here is exactly what it does with it.
- Retention
- 60 minutes. Your PDF and the spreadsheet built from it are deleted on a timer, whether you download or not.
- Accounts
- None. No signup, no password, no email required to convert or to pay.
- Where it runs
- One server in London. PDFs are parsed there; the text isn't handed to an outside service.
- If it's wrong
- 14 days, refunded. And you see the extracted rows before you're asked for money.
Questions
Vanguard brokerage statements, specifically
How do I convert a Vanguard brokerage statement to Excel?
Upload your Vanguard brokerage statement PDF, and LedgerLift returns a ready-to-use .xlsx spreadsheet with date, description, amount and balance columns — usually in seconds.
Can I export my Vanguard brokerage statement to Excel?
Yes. Vanguard doesn't export to Excel directly, so download the brokerage statement as a PDF and convert it here — no manual copying.
How do I download my Vanguard brokerage statement as a PDF?
Log on at vanguard.com. Select the My Accounts tab, then Statements. Choose the account and the statement period. Open and save the PDF — Vanguard delivers documents in PDF only. Then upload it here.
What does it cost to convert a Vanguard brokerage statement?
The first 3 pages are free and need no account. Past that it's $3 to unlock the statement you just converted, which also leaves you credit towards the next one. Full pricing.
Is it accurate?
The extracted rows are re-added and compared against the running balance printed on the brokerage statement. If the two agree, the figures are arithmetically sound; any row that can't be resolved confidently is flagged in the preview rather than quietly guessed at.
Is my data secure?
Your PDF is deleted automatically after processing and we keep no copy. There's no account to create, and we never sell, share or train on financial data.
Which Vanguard accounts are supported?
Brokerage, retirement and cash-management Vanguard statements. The dated activity converts; holdings and position tables aren't a ledger and are left alone. Multi-page documents are fine.