Brokerage statements to Excel, holdings and activity proven.
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.
One statement, a Roth IRA and an individual account
A fictional couple’s October statement from a made-up brokerage, with two accounts on it. Convert reads each one on its own and proves all four things for both: the Roth IRA goes from $64,800.00 to $66,425.20, its 4 positions add to $66,425.20 and its cash goes from $612.40 to $824.18. The individual account goes from $32,667.64 to $28,129.15 after a $5,000.00 withdrawal, with its cash at $7,549.31. Eight proofs, all to the cent.
The Roth IRA: eight proofs on one statement, all to the cent.The individual account, split out on its own.
WHAT YOU GET
Three tables, ready for analysis.
ONE WORKBOOK
Summary, Holdings and Activity.
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 do I convert a brokerage statement PDF to Excel?+
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.
Can I export Schwab or Fidelity statements 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.
Does it handle statements with several accounts?+
Yes. Each investment account on the statement gets its own section and its own proofs.
Is this for tax reporting?+
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. Our guide to brokerage statement to Excel shows how to check a year of statements against them. Keeping books for clients? See ZeraBooks accounting software for accountants.
Damin founded ZeraBooks in 2025 and still talks to the bookkeepers, firms and owners who use it every week. He writes about what he sees in their statements and ledgers, and every page here is checked against the live product before it goes up.
Convert your first brokerage statement. Free for 7 days.
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. Brokerage statements on a forensic matter? See forensic accounting software.