BROKERAGE STATEMENTS TO EXCEL
To convert a brokerage or investment statement PDF to Excel, upload it to ZeraBooks Convert, the bank statement converter that also reads brokerage statements. It reads each account’s beginning and ending value, every holding with quantity, price and market value, and the cash activity, then proves them against the statement’s own figures to the cent. Download one workbook with Summary, Holdings and Activity sheets, or CSV.
7-day free trial · 1,000 pages a month from $79/month billed annually
FOUR PROOFS
Whenever the statement prints the figures to check against, every one must match to the cent.
Beginning value plus activity and market change equals ending value.
The positions add up to the total holdings printed.
Quantity times price equals market value, for every holding.
Opening cash plus cash activity equals closing cash.
Try it on your own documents. One-week free trial, both apps included.
WHAT YOU GET
ONE WORKBOOK
Excel gives you one workbook with a tab per table: the account summary with beginning value, deposits, withdrawals, dividends and interest, fees and ending value; every holding with symbol, description, quantity, price and market value; and every cash transaction. CSV gives a file per table in one ZIP.
How Convert reads investment statementsSTEP BY STEP
From your brokerage or retirement account’s documents page.
Click Upload statements or drop the PDF on the page.
Proven means the account value, holdings, prices and cash all tie to the cent.
Excel gives one workbook with three tabs; CSV gives three files in a ZIP.
Upload the PDF on the Investments page of ZeraBooks Convert, check that it’s Proven, then click Download and choose Excel for a workbook with Summary, Holdings and Activity tabs. For bank and card statements, see how to convert a bank statement to Excel.
Convert reads brokerage and retirement statements as PDFs you download from the provider, and proves each account against the statement’s own figures. Try your statement during the free trial. Paying the account from a checkbook too? Scanned checks go through the check converter, with payee and memo on each row.
Yes. Each investment account on the statement gets its own section and its own proofs.
Convert extracts what the statement prints: values, holdings and cash activity. It isn’t a tax-lot or cost-basis calculator; use your provider’s tax documents for filing. Keeping books for clients? See ZeraBooks accounting software for accountants.
ONE-WEEK FREE TRIAL
Then 1,000 pages a month from $79 a month billed annually; see ZeraBooks pricing. Want to keep the books in ZeraBooks too? AI bookkeeping in the General Ledger is included.
Last updated October 1, 2026 · Written by Damin Mutti, founder of ZeraBooks