Convert brokerage statements to Excel or CSV
Upload a statement from any custodian and download three clean tables: every holding, every transaction, and every realized gain, each checked before export.
- 3
- Row streams per statement
- ±$0.01
- Per-lot gains check
- Last 4
- Only, of any account number
What comes back · sample
Schema v1
- Custodian
- Meridian Securities
- Account name
- Individual Brokerage
- Account № last 4
- ••8841
- Period start
- Apr 01, 2026
- Period end
- Jun 30, 2026
- Beginning value
- $98,840.20
- Ending value
- $102,362.45
- Currency
- USD
Gains reconciled to basis
Line items CSV · Realized gains CSV
Field names are the LedgerBox extraction schema for brokerage statements, version 1. Sample values are illustrative.
How to convert a brokerage statement
-
Upload the statement
Drag in the PDF from your custodian's document center. Multi-page quarterlies, scans, and consolidated statements are fine, and a single drop takes up to 20 files.
-
We extract three row streams
Holdings, account activity, and realized gains each land in their own table. Positions are checked against the ending value, and proceeds minus cost basis must equal every printed gain, or the lot is flagged with a reason.
-
Download the spreadsheets
A line-item CSV covers all three tables, and a separate realized gains CSV arrives in Schedule D column order with each lot marked short or long term.
Brokerage statement anatomy
A sample quarterly brokerage statement, and how LedgerBox separates the holdings, activity, and realized gain sections during extraction.
Brokerage statement
Meridian Securities
Individual Brokerage ··8841
Period Apr 01 – Jun 30, 2026
Beginning value 98,840.20
Holdings
Activity
Realized gains
The period anchors every trade date
Activity rows often print month and day without the year. LedgerBox resolves trade and settle dates from the statement period, while acquisition dates keep their printed year, even one from years earlier.
Three sections stay three tables
Holdings, account activity, and realized gains never blend into one stream. Each row keeps its own section's columns, so a dividend cannot land among the positions and a closed lot cannot read as a trade.
Every gain is checked against basis
Proceeds minus cost basis must equal the printed gain or loss on every lot, to the cent. A lot that does not reconcile comes back flagged for review instead of exported quietly.
Built for Schedule D
The realized gains export follows the Schedule D column order: description, dates acquired and sold, proceeds, cost basis, and gain or loss, with each lot marked short or long term. Only the last four digits of the account number are ever extracted, so the export is safe to pass around a tax workflow.
Brokerage statement conversion FAQ
How do I convert a brokerage statement PDF to Excel or CSV?
Create a free LedgerBox account, upload the statement, and download the converted files. The free trial includes enough pages to try a full quarterly statement, and no credit card is required.
Which fields are extracted from a brokerage statement?
Eight summary fields: custodian, account name, the last four digits of the account number, period start and end, beginning and ending value, and currency. Plus three row tables: holdings with quantity, price, market value, and cost basis; activity with dates, type, and amount; and realized gains with proceeds, cost basis, gain or loss, and term.
Does it work with statements from my custodian?
Yes. LedgerBox reads the statement itself rather than matching it against custodian-specific templates, so statements from any brokerage, custodian, or fund platform convert the same way.
Can I use the realized gains export for Schedule D?
Yes. The realized gains CSV follows the Schedule D column order with each lot marked short or long term, and every row's gain has already been checked against its proceeds and cost basis before export.
Does it work with scanned statements?
Yes. OCR-backed extraction reads image-based PDFs and scans the same way as digital statements, and any row it cannot read with confidence comes back flagged rather than guessed.
Is my brokerage data secure?
Documents are encrypted in transit and at rest, processed in isolated storage, and never used to train models. You can delete uploaded documents at any time and they are permanently removed.
Ready to convert your brokerage statements?
Upload a statement and download clean holdings, activity, and gains tables in under a minute. No card required.
LedgerBox also reads
- Bank statements Bank and credit account statements with account-period summaries and transaction rows. 15 CSV · ledgerbox_transactions_xlsx · QuickBooks CSV · QBO · Send to QuickBooks
- Invoices Vendor invoices with due dates, totals, tax, counterparty details, and line items. 8 Line items CSV · Send to QuickBooks
- Receipts Point-of-sale and expense receipts with merchant, payment, total, and line item details. 8 Line items CSV · Send to QuickBooks
- PDF tables Tabular source documents that do not fit a specialized financial document type yet. 4 Table CSV
- Pay stubs Payroll pay stubs with employer, employee, pay period, earnings, and deduction lines. 9 Line items CSV
- Purchase orders Buyer-issued purchase orders with supplier, delivery, totals, and ordered line item details. 11 Line items CSV
- W-2 forms IRS Form W-2 wage and tax statements with employer, employee, and per-box wage and withholding amounts. 14 Summary CSV
- 1099 forms IRS Form 1099 information returns (NEC, MISC, INT, DIV, K, B) with payer, recipient, and reported box amounts. 9 Summary CSV · Line items CSV
- Checks Scanned or photographed checks with payee, numeric and written amounts, date, memo, and bank routing details. 9 Summary CSV