General Ledger + Converter in one subscription.

See pricing
Skip to content
  1. Home
  2. Bank statement converter
  3. Investment statement converter

BROKERAGE STATEMENTS TO EXCEL

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.

7-day free trial · 1,000 pages a month from $79/month billed annually

A real run: one brokerage statement, two accounts, each proven. Fictional clients.

FOUR PROOFS

What Convert checks on every investment account

Whenever the statement prints the figures to check against, every one must match to the cent.

  1. 1

    Account value

    Beginning value plus activity and market change equals ending value.

  2. 2

    Holdings

    The positions add up to the total holdings printed.

  3. 3

    Prices

    Quantity times price equals market value, for every holding.

  4. 4

    Cash

    Opening cash plus cash activity equals closing cash.

We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.

A REAL RUN

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 Investments page: the Roth IRA’s beginning value, movements and ending value, proven against the statement.
The Roth IRA: eight proofs on one statement, all to the cent.
The individual account on the same statement, split out with its own values, holdings and cash activity.
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 Convert reads investment statements
Every document type on its own page.

STEP BY STEP

How to convert a brokerage statement PDF to Excel

  1. 1

    Download the statement as PDF

    From your brokerage or retirement account’s documents page.

  2. 2

    Upload it on the Investments page

    Click Upload statements or drop the PDF on the page.

  3. 3

    Check the proofs

    Proven means the account value, holdings, prices and cash all tie to the cent.

  4. 4

    Download Excel or CSV

    Excel gives one workbook with three tabs; CSV gives three files in a ZIP.

QUESTIONS

Investment statement converter: common questions

Ask Damin directly
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 Mutti, founder of ZeraBooks

About the author

Damin Mutti

Founder of ZeraBooks, Vancouver

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.

FREE SETUP + CATCH-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.

Book a call with Damin

Our founder. 30 minutes on Google Meet. Pick a time on the next screen.

About: Have us do your books