How To Convert a Merrill Lynch Brokerage Statement to Excel
Merrill Lynch brokerage statements combine full-service brokerage and Merrill Edge self-directed accounts into one dense PDF. This guide shows how to convert a Merrill Lynch statement to Excel with holdings, activity, and income on separate sheets.
Merrill Lynch statements, whether from a full-service advisor account or a Merrill Edge self-directed account, pack a lot of data into a single PDF: Portfolio Summary, asset allocation, individual position detail, transaction activity, and income and dividend history. A quarterly statement on a diversified household account can easily run 40+ pages.
Copying that data manually into Excel is slow and error-prone. This guide walks through converting a Merrill Lynch PDF into a structured Excel workbook using DocuClipper's brokerage statement converter.
While you are here
Extract holdings and activity from any broker PDF
Upload a brokerage statement from Fidelity, Schwab, Vanguard, Merrill, E*TRADE, or Robinhood and DocuClipper returns structured tables (positions, buys/sells, dividends) ready to export.
How DocuClipper maps Merrill Lynch sections to Excel sheets
| Merrill statement section | Excel sheet | Key columns |
|---|---|---|
| Portfolio Summary | Summary | Beginning value, net change, ending value, cash, unrealized gain/loss |
| Positions (per account) | Holdings | symbol, security_name, quantity, price, cost_basis, market_value, unrealized_gain_loss, asset_class |
| Account Activity | Activity | date, type (buy/sell/deposit/withdrawal/dividend/fee), symbol, description, quantity, price, amount |
| Income & Dividends | Income | date, symbol, income_type (ordinary/qualified dividend, interest, cap gain), amount |
What's different about Merrill Lynch statement layouts
Merrill combines full-service brokerage and Merrill Edge self-directed accounts under one login and often produces combined household statements. A few things to know:
Multiple account types in one PDF. A single Merrill PDF may include a full-service brokerage account, a Merrill Edge account, and an IRA. DocuClipper separates each account into its own section so Activity rows carry an account_number column.
Separate fee detail. Merrill breaks out advisory fees, platform fees, and transaction commissions in an Expenses section. DocuClipper extracts this as fee rows in the Activity sheet with a type=fee label.
Asset allocation breakdown. Merrill includes an asset allocation summary (Equity/Fixed Income/Cash/Other split). DocuClipper captures this in the Summary sheet alongside the portfolio totals.
Put it into practice
Manually copying brokerage data creates reconciliation errors
Cost basis, market value, realized gains: these numbers compound errors when retyped. DocuClipper extracts them directly from the statement so holdings and activity tie out the first time.
How to download a Merrill Lynch PDF statement
- Log in to merrilledge.com or the MyMerrill portal
- Go to Accounts → Statements & Documents
- Select the account and statement period, click Download
- Open DocuClipper, drop the PDF, and click Extract
Combined household statements (which Merrill calls "combined" or "household" statements) are supported, all accounts extract in one pass.
FAQs about Merrill Lynch statement conversion
Does DocuClipper work with both Merrill Lynch and Merrill Edge statements?
Yes. Both full-service Merrill Lynch advisor accounts and Merrill Edge self-directed accounts use the same statement layout family. DocuClipper handles both. If you have a combined household statement that includes multiple account types, all accounts extract into the same workbook with a column distinguishing each account number.
What if my Merrill statement shows only a subset of my positions?
Merrill's standard statement includes all positions. If you only see a subset, double-check that you downloaded the full "Combined Monthly Statement" rather than a trade confirmation or account summary notice. Trade confirmations are separate one-page PDFs that are not monthly statements.
Can I convert multiple months of Merrill statements at once?
Yes. DocuClipper supports multi-file uploads. Drop all your Merrill PDFs into one batch and DocuClipper consolidates all extracted data, one row per position or per transaction, into a single Excel file covering the full date range.
Does DocuClipper support scanned Merrill Lynch statements?
Yes. Both digital (downloaded) PDFs and scanned paper statements are supported. Scanned statements go through OCR before extraction. Digital PDFs produce cleaner output since no OCR step is needed, but both routes produce exportable structured data.
How far back can I get Merrill Lynch statements?
Merrill typically provides 7 years of statement history through MyMerrill. For older statements, contact your Merrill advisor or Merrill's Client Service team to request a printed or digital copy.
Related Articles
- Brokerage Statement Converter
- Brokerage Statement to Excel
- Best Brokerage Statement Converter Software
- How to Convert a Fidelity Brokerage Statement to Excel
- How to Convert a Schwab Brokerage Statement to Excel
- How to Convert a Vanguard Brokerage Statement to Excel
- How to Convert an E*TRADE Statement to Excel
- How to Convert a Robinhood Statement to Excel
- How to Convert an Interactive Brokers Statement to Excel
Next step
Convert your brokerage statement: free 14-day trial
Upload any PDF brokerage statement and download Holdings, Activity, and Income in a clean Excel workbook. No credit card required.