PDF to Excel for Financial Advisors: Convert Brokerage and Custodian Statements
Held away accounts, prior custodian statements, and anything older than the export window all arrive as PDFs. PDFXLSX reads the holdings and transaction tables straight out of the statement and hands back clean Excel in seconds, with share counts, cost basis, and market values kept numeric so the portfolio totals on its own. Drop a statement on the right to see it work.
Your first conversion is free, and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
First conversion is free. Nothing to install.
The short answer
To convert a brokerage or custodian statement to Excel, upload the PDF to a converter that detects the holdings and transaction tables and exports a spreadsheet, instead of retyping symbols, share counts, and cost basis. You get one row per position or trade with quantity, cost basis, market value, and unrealized gain kept numeric, so a portfolio schedule totals and a cost basis reconciliation is a formula rather than a rebuild. Advisors mostly need this for the statements a custodian download cannot give them: held away 401(k) and 529 accounts, statements from a prior custodian after a transfer, and anything older than the roughly 24 month transaction history window most custodians expose online.
Last updated July 2026
Numbers
Stay numeric
Scans
OCR included
Batch
A book of clients at once
XLSX + CSV
Ready for your tracker
Why advisors still convert statement PDFs
Every custodian has an export button, so the obvious question is why an advisor would convert a PDF at all. The answer is that the export button only covers the accounts you custody and the window the platform chooses to keep online. Most custodians show transaction history for roughly the last two years while keeping statement PDFs for about a decade, which means the moment a question reaches back further than that window, the PDF is the only record that exists.
Then there is everything you do not custody. A new client shows up with a 401(k) at a recordkeeper you have no login for, a 529 in another state, an old annuity, and two years of statements from the custodian they just left. None of that is in your portfolio system, and it is exactly the part of the household you are being asked to advise on. Someone types it in, and a mistyped share count quietly changes an allocation chart the client is about to see.
Converting removes the retyping. The engine reads the holdings rows, keeps quantities, cost basis, and market values as real numbers, and returns a sheet where the columns already add. From there you can roll a held away account into the household allocation, tie realized gains back to a 1099-B, or stack twelve monthly statements to see what actually moved. Try it on a real statement at the top of the page.
| Symbol | Shares | Cost basis | Market value |
|---|---|---|---|
| VTI | 1,240.000 | 218,450.00 | 341,062.00 |
| VXUS | 2,810.500 | 154,900.00 | 178,266.00 |
| BND | 3,105.000 | 239,610.00 | 226,665.00 |
| SCHD | 940.000 | 72,380.00 | 81,780.00 |
| Cash | 44,127.00 | 44,127.00 |
Share counts and dollar figures stay numeric, so market value totals, unrealized gain is one formula, and the allocation percentages fall out of the sheet.
Client documents you can convert
The PDFs that show up in an advisor inbox during onboarding, review season, and tax season.
| Source PDF | What you do with it | In Excel you get |
|---|---|---|
| Brokerage and custodian statements | Onboarding a household, building the allocation | One row per position with shares, basis, and value |
| Held away 401(k), 403(b), and 529 statements | Advising on assets you do not custody | Fund lineups and balances you can roll into the household |
| Prior custodian statements after a transfer | Rebuilding history the new platform did not receive | Transaction rows with dates, amounts, and descriptions |
| 1099 composite and 1099-B forms | Tax season reconciliation and cost basis checks | Proceeds and basis columns that total against the summary |
| Alternative investment statements | Tracking capital calls, distributions, and NAV marks | Position rows for holdings your system will not price |
| Annuity and insurance policy statements | Surrender values, riders, and subaccount balances | Subaccount rows instead of a five page printout |
| Performance and fee billing reports | Review prep, fee reconciliation, revenue reporting | Account level rows you can total and sort by household |
Working one account type at a time? The brokerage statement converter covers holdings and trade activity, while the bank statement converter handles the cash side of a household balance sheet.
Built for the way advisory firms work
What matters when the numbers end up in a client deck, a tax return, or a performance report.
Share counts and basis stay numeric
Fractional shares, cost basis, and market value export as real values rather than text, so allocation percentages and unrealized gain calculate in your editable Excel without a cleanup pass first.
Scanned and forwarded statements
Clients photograph a mailed statement or forward a scan from a recordkeeper portal. Built in OCR reads image only PDFs, so the holdings page still lands in a usable grid.
A year of statements in one pass
Rebuilding history means twelve or twenty four monthly PDFs. The batch converter takes them together, so reconstructing an account is one upload rather than an afternoon.
Feeds your planning and tracking tools
Export XLSX for the review deck or CSV when a planning tool, portfolio tracker, or tax package wants a flat import file with one row per position.
Client data stays private
Statements carry account numbers and net worth you cannot let wander. Uploads are encrypted in transit and at rest, processed in isolation, and deleted automatically once the spreadsheet is ready.
Fast enough for the meeting on Thursday
Prospect meetings get scheduled before the paperwork arrives. A statement converts in seconds instead of the half hour it takes to retype, which is the difference between showing a real allocation and showing a rough guess.
How to convert a client statement to Excel
Three steps, no software to install.
Upload the PDF
Drag one statement, or a full year of them, into the box at the top of this page. Digital and scanned PDFs up to 50MB are supported.
It reads the holdings tables
The engine finds the position and activity rows across every page, applies OCR to scans, and keeps symbols, dates, share counts, and dollar amounts in formats Excel understands.
Download and tie it out
Download a clean XLSX or CSV, then check that market value totals to the statement summary before the numbers reach a client deck. Our guide on exporting Schwab holdings to Excel covers when a download beats a conversion.
Who this helps
Anyone whose next task starts with a statement a client emailed over and ends in a spreadsheet somebody is going to make a decision from.
-
RIAs and independent advisors onboarding a household and pulling held away accounts into one allocation before the first review.
-
Client service and operations associates rebuilding transaction history from statements after an account transfer arrives without cost basis.
-
Family offices and wealth managers consolidating alternatives, annuities, and multiple custodians into a single balance sheet each quarter.
-
Tax focused advisors and CPAs checking realized gains and cost basis against a 1099-B at filing time. The tax preparer workflow covers the wider return.
From statement to household allocation
Convert each account statement, stack the positions in one sheet with an account column, then group by asset class and total market value. Because the figures stay numeric, the household allocation is a pivot table rather than a rebuild, and every number still traces back to the statement the client sent.
A statement that runs long? Use the large PDF converter built for documents that run hundreds of pages.
Advisor questions
Upload the PDF to the converter at the top of this page and download an Excel file in seconds. The engine detects the holdings and activity tables, carries them across every page, applies OCR when the statement was scanned, and keeps share counts and dollar columns numeric. You get one row per position or transaction, ready to total and tie back to the statement summary. The brokerage statement converter covers the same workflow in detail.
When the custodian download is available, use it, because a native export is always cleaner than reading a printed page. Conversion is for the gaps: accounts you do not custody and cannot log into, statements from a prior custodian after a transfer, activity older than the transaction history window the platform keeps online, and documents a client simply emails you as a PDF. Those cases are common enough that most advisory firms hit one every week.
Yes, and it is the most common reason advisors convert at all. Recordkeeper statements list the fund lineup, unit balances, and market values in a table like any other statement, so the conversion returns rows you can slot into the household allocation. That turns the part of the balance sheet you have the least visibility into, and are still expected to advise on, into data instead of a printout in a folder.
Scanned statements are fine, because built in OCR reads image only PDFs. Password protected files are not, and no honest converter should claim otherwise: an open password is the encryption key, so the file has to be unlocked first. Open it in any PDF reader with the password the client gave you, save an unlocked copy, then convert that. Our guide on converting a password protected PDF to Excel walks through it.
Treat the spreadsheet as a working file, not as the record. The custodian statement remains the source of truth, so keep the original PDF in the client file and have the converted sheet point back to it. Before anything reaches a client deck or a tax return, check that the market value column totals to the statement summary. That one reconciliation catches almost every extraction problem worth catching.
More ways to convert PDF to Excel
PDF to Excel for Real Estate: Convert Rent Rolls, T12s, and Operating Statements
Convert real estate PDFs to Excel and CSV. Rent rolls, T12 operating statements, and closing statements become clean spreadsheet rows you can underwrite in minutes.
AudiencesPDF to Excel for Accountants: Convert Client Statements and Reports
Convert client bank statements, financial reports, and scanned PDFs to Excel. Numbers stay numeric for reconciliation, month-end close, and QuickBooks import.
AudiencesPDF to Excel for Bookkeepers: Convert Statements and Receipts
Convert client bank statements and receipts from PDF to Excel and CSV. Numbers stay numeric for monthly bookkeeping, categorizing, and QuickBooks or Xero import.
AudiencesPDF to Excel for Finance Teams: Convert Financial Statements and Reports
Convert PDF financial statements and reports to Excel and CSV for your finance team. Numbers stay numeric and drop into models without broken cells or retyping.
Stop retyping client statements
Drop a statement at the top of the page and download a clean Excel or CSV in seconds. Your first conversion is free. For everyday work, start with the PDF to Excel converter or the PDF table extractor.