LedgerBox

Brokerage statement to Excel

Turn a PDF brokerage statement into three spreadsheets: holdings, account activity and realized gains. Every gain is checked against its proceeds and cost basis before you download.

Choose statements First 10 pages free. No card needed.
meridian-8841-2026-q2.pdfSample
CustodianMeridian Securities
AccountIndividual brokerage ••8841
PeriodApr 1 to Jun 30, 2026
Beginning to ending value98,840.20 to 102,362.45
SymbolDescriptionQuantityAcquiredSoldProceedsCost basisGain or lossTerm
ACME Acme Corp common 40 2024-02-14 2026-04-09 5,212.40 3,880.00 1,332.40 Long
INKP Ink + Paper Co 120 2025-11-03 2026-05-02 2,946.00 3,318.60 -372.60 Short
MTMX Meridian Total Market Fund 25.5 2022-06-20 2026-05-28 3,417.51 2,601.00 816.51 Long
PTSI Paper Trail Supplies 60 2026-01-12 2026-06-11 1,489.80 1,236.00 253.80 Short
Total, 4 lots13,065.7111,035.602,030.11
SymbolGain or lossTerm
ACME1,332.40Long
INKP-372.60Short
MTMX816.51Long
PTSI253.80Short
Total2,030.11
Every lot adds up. Proceeds minus cost basis equals the printed gain or loss on all 4 lots, to the cent.Short term -118.80, long term 2,148.91
A sample quarterly statement from a made-up custodian. All three tables come from the same PDF.What is on a brokerage statement

How to convert a brokerage statement to Excel

Use the PDF from your brokerage's document center. Quarterly statements that run many pages are fine.

Upload

Drop the statement PDF, a scan, or a phone photo. Upload up to 20 files at a time, up to 8 MB each.

Check

LedgerBox splits the statement into holdings, activity and realized gains. Each lot's gain is checked against its proceeds and cost basis. A lot that does not match is flagged with the reason.

Download

Download a CSV of every row, a realized gains CSV in Schedule D column order, or JSON. CSV files open in Excel and Google Sheets.

The files you get from a brokerage statement

Brokerage statement to CSV

One CSV with every holding, activity row and realized gain. The first column says which table each row came from, so you can filter it.

Columns include record_type, symbol, description, quantity, price, market_value, cost_basis, trade_date, activity_type, amount, acquired_date, sold_date, proceeds, gain_loss, term

Realized gains CSV for Schedule D

Only the closed lots, in Schedule D column order. Term is the last column, so you can split short term from long term with one filter.

symbol, description, quantity, acquired_date, sold_date, proceeds, cost_basis, gain_loss, term

Brokerage statement to Excel

The CSV files open in Excel, Google Sheets and Numbers. Select many statements and download them as one file. Each row keeps the name of the statement it came from.

CSV export details

JSON and the API

Get every field and row as JSON, with the summary fields: custodian, account name, last 4 of the account number, period, beginning and ending value, and currency.

API and SDK

Every gain is checked against cost basis

A misread digit in a gains table turns into a wrong number on a tax return. LedgerBox checks the statement's own math before you export.

Every lot, to the centProceeds minus cost basis must equal the gain or loss the statement prints. A lot that does not match is flagged, not exported quietly.
Holdings against the ending valueMarket values should add up to the ending value. A small difference is allowed, because accrued interest and pending trades move it.
Dates keep the right yearTrade dates printed without a year get it from the statement period. Acquired dates keep the year printed, even one from years before.
meridian-8841-2026-q2.pdf1 lot to check
SymbolSoldProceedsCost basisGain or loss
ACME2026-04-095,212.403,880.001,332.40
INKP2026-05-022,946.003,318.60-327.60
MTMX2026-05-283,417.512,601.00816.51

Page 6. Proceeds minus cost basis does not equal the gain or loss on this lot.

Statement says-327.60
Proceeds minus basis-372.60
Off by45.00

Who converts brokerage statements

Tax preparers

Turn a client's realized gains into a CSV in Schedule D column order, with short and long term marked on every lot.

LedgerBox for tax preparers

Accountants and bookkeepers

Record dividends, sales and ending values for a client's investment account without typing them from a PDF.

LedgerBox for accountants

Mortgage lenders

Read an applicant's holdings and ending value from the asset statements they send, with the totals checked.

LedgerBox for mortgage lenders

Investors

Put a year of quarterly statements in one spreadsheet to see what you sold, what you hold and what it cost.

Start with 10 free pages

When you do not need a converter

Your brokerage's download

Many brokerages let you download recent activity as a CSV from their website. If the dates you need are there, use that.

Form 1099-B

After the tax year, your brokerage sends a 1099-B with your sales. Some also offer it as a file for tax software.

When a converter helps

Statements that only come as PDF, older quarters, statements from several brokerages, and scans a client sends you.

Is it safe to upload a brokerage statement?

Only the last 4 digitsThe rows and exports carry only the last four digits of the account number.
EncryptedFiles and rows are encrypted in transit and at rest.
AuditedOur security is independently audited by a third party. GDPR applies to all accounts.
Not used for trainingYour statements are not used to train AI models. Files stay in your account until you delete them.
How we protect your data

Brokerage statement converter pricing

10 pagesfree, no card

  • Share LedgerBox with a colleague200 free pages
  • Starter, 60 pages a month$25 a month
  • Pro, from 640 pages a monthfrom $135 a month
See all plans

Brokerage statement questions

How do I convert a brokerage statement to Excel?

Upload the PDF, check the rows LedgerBox finds, and download the CSV. It opens in Excel with holdings, activity and realized gains in their own rows.

Can I get a CSV of my brokerage statement?

Yes. You get one CSV with every row, and a second CSV with only the realized gains. You can also download JSON.

What does LedgerBox pull from a brokerage statement?

The custodian, account name, last 4 of the account number, period, beginning and ending value, and currency. Then three tables: holdings, account activity, and realized gains.

Can I use the realized gains for Schedule D?

The realized gains CSV follows Schedule D column order: description, dates acquired and sold, proceeds, cost basis, and gain or loss. Each lot is marked short or long term.

How do I know the gains are right?

Proceeds minus cost basis must equal the printed gain or loss on every lot, to the cent. A lot that does not match is flagged with its page, so you can fix it before export.

Does it work with my brokerage's statements?

Yes. LedgerBox reads the layout of each statement instead of using a template per brokerage, so statements from any brokerage or custodian convert the same way.

Can it read a scanned statement?

Yes. Scanned PDFs and JPG, PNG and HEIC photos are read with OCR. Rows that are hard to read are flagged for you to check.

Why don't my holdings add up exactly to the ending value?

Accrued interest, pending trades and rounding can move the ending value a little. LedgerBox allows a small difference here, and flags a bigger one.

Can I convert a year of statements at once?

Yes. Upload up to 20 files at a time, then download them as one CSV. Each row keeps the name of the statement it came from.

Is my account number in the export?

Only the last four digits. The extracted rows and every export carry the last four, never the full number. The PDF you upload stays in your account until you delete it.

Convert your first brokerage statement

10 pages free. No card needed.

Choose statements Talk to a human