Document Guide

Convert Merrill Edge Statements to Excel

Extract holdings, cost basis, dividends, and transaction history from Merrill Edge PDF statements into structured spreadsheets — no manual retyping.

Merrill Edge monthly and quarterly statements pack a lot into a dense PDF layout: account summary, realized/unrealized gain-loss tables, dividend and interest income by security, and a cost basis section that splits short-term and long-term lots with acquired dates and adjusted cost basis figures. That layout doesn't map cleanly to a generic table export — merged header rows and multi-line security descriptions (name, CUSIP, and symbol stacked together) often break simple copy-paste or basic PDF table tools. This tool reads the statement page by page and extracts the underlying fields into a structured spreadsheet, so you get one row per holding or transaction instead of a wall of unaligned text.

Who This Is For

  • Individual investors reconciling Merrill Edge cost basis against tax software before filing
  • Bookkeepers and accountants tracking client brokerage activity across multiple statement periods
  • Financial advisors consolidating held-away Merrill Edge accounts into a master portfolio tracker
  • Anyone building a personal net worth or dividend income tracker in Excel or Google Sheets

When This Is Relevant

  • Reconciling year-end cost basis before sending data to a tax preparer
  • Comparing dividend income across several months without opening each PDF separately
  • Merging Merrill Edge holdings with data from another broker for a combined portfolio view
  • Auditing realized gain/loss entries against a separate trade log

Supported Inputs

  • Digital PDF statements downloaded directly from Merrill Edge online
  • Scanned paper statements saved or photographed as PDF, PNG, or JPEG
  • Multi-page statements covering several account sections at once

Expected Outputs

  • Excel (.xlsx) file with one row per holding, lot, or transaction
  • CSV file formatted for import into Excel, Google Sheets, or accounting software

Common Challenges

  • The cost basis table splits each holding into short-term and long-term rows, and the security name/CUSIP/symbol often wraps across two lines — naive copy-paste merges these into one unreadable cell
  • Dividend and Interest Income sections list payments by security but repeat the same header formatting used in the summary tables, which confuses simple table-detection tools that don't distinguish section context
  • Statements with 'Estimated' or 'Not Available' placeholders in the Adjusted Cost Basis column can throw off tools expecting a numeric value in every cell
  • Scanned or photographed statements with slight page skew shift column alignment, causing dollar figures to land under the wrong header — flattening or straightening the scan before upload reduces this issue

How It Works

  1. Download your Merrill Edge statement as a PDF from the Merrill Edge document center, or use a scanned/photographed copy
  2. Upload the file to pdfexcel.ai and select or customize the fields you need — for example Security Description, CUSIP, Quantity, Acquired Date, Cost Basis, and Unrealized Gain/Loss
  3. The AI extracts each table section (holdings, cost basis, dividend income, transactions) and maps it to structured rows
  4. Download the result as .xlsx or .csv, then spot-check a few rows against the original PDF, especially any lots marked 'Various' or 'Estimated' acquired date

Why PDFexcel.ai

  • Handles the multi-line security descriptions common on Merrill Edge cost basis pages instead of merging name, symbol, and CUSIP into one field
  • OCR support covers scanned or photographed statements, not just the clean digital PDF export
  • Custom field selection lets you pull only what you need — for example just Dividend and Interest Income rows — instead of every table on the statement
  • Batch processing handles a full year of monthly statements in one pass instead of uploading each PDF separately

Limitations

  • Accuracy depends on statement clarity — a low-resolution phone photo of a paper statement will extract less reliably than the official PDF download
  • Very dense multi-page cost basis tables with many small lots (partial-share dividend reinvestment, for example) may need a manual review pass to confirm lot-level accuracy
  • Handwritten annotations or notes added to a printed statement won't be read reliably
  • Non-standard statement formats, such as older archived Merrill Lynch layouts before the Merrill Edge rebrand, may require field customization to match the current template

Example Use Cases

  • Exporting 12 months of Merrill Edge statements into one combined Excel workbook to track dividend income trends
  • Pulling the cost basis table into a spreadsheet to cross-check against a tax software import before filing a Schedule D
  • Combining Merrill Edge holdings with statements from another brokerage to build a single portfolio-tracking sheet
  • Extracting realized gain/loss entries to verify against a separate trade log kept in a different tool

Frequently Asked Questions

Can this extract the cost basis section from a Merrill Edge statement, including short-term and long-term lots?

Yes, the tool reads the Cost Basis table and extracts fields like Security Description, Acquired Date, Cost Basis, and Term. Lots marked 'Various' or 'Estimated' are preserved as-is since Merrill Edge itself doesn't always provide an exact date.

Does it separate dividend and interest income by security?

Yes, the Dividend and Interest Income section lists payments per holding, and extraction keeps each security's payment as its own row rather than collapsing them into a summary total.

What if my Merrill Edge statement is a scanned copy instead of the original PDF download?

OCR handles scanned PDFs, PNGs, and JPEGs, but a straight, high-resolution scan works better than a skewed photo — page skew can shift numbers under the wrong column header.

Will this replace manual reconciliation for tax filing?

No, it speeds up data entry significantly but you should still spot-check extracted cost basis figures against the original PDF before filing, especially for lots with adjustments or wash sale disallowed amounts.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources