Document Guide

Convert Morgan Stanley Statements to Excel

Extract Holdings, Performance Summary, and Asset Allocation data from Morgan Stanley wealth management PDFs into Excel or CSV — without retyping every position.

Morgan Stanley wealth management statements combine a Holdings table with narrative Performance Summary blocks (Time-Weighted Rate of Return, benchmark comparison) and an Asset Allocation breakdown — a layout that's more complex than a typical bank or brokerage cash statement. This tool uses AI-powered extraction to pull those sections into structured rows in Excel or CSV, so advisors and individual investors can update tracking models or client reports without manually copying figures from a PDF.

Who This Is For

  • Financial advisors and RIAs who need to log client portfolio data into a master tracking spreadsheet each quarter
  • Individual investors maintaining a personal net worth or asset allocation tracker outside Morgan Stanley Online
  • Bookkeepers and accountants reconciling realized gain/loss figures against tax filings
  • Family offices consolidating multiple Morgan Stanley Private Wealth Management accounts into one workbook

When This Is Relevant

  • Quarterly or year-end portfolio performance review when you need Time-Weighted Return and benchmark data outside the PDF
  • Tax season reconciliation of Realized Gain/Loss Summary figures against 1099-B or K-1 documents
  • Migrating holdings data into a third-party portfolio tracker or a custom Excel allocation model
  • Comparing statements across several household accounts that arrive as separate PDFs

Supported Inputs

  • Digital PDF statements downloaded from Morgan Stanley Online
  • Scanned or printed copies of mailed statements
  • PNG or JPEG images and photos of paper statements

Expected Outputs

  • Excel (.xlsx) workbook with one row per holding, plus separated Performance Summary fields
  • CSV export formatted for import into portfolio tracking or accounting tools

Common Challenges

  • The Performance Summary block (Time-Weighted Rate of Return, benchmark comparison) sits as narrative text above the Holdings table — extraction needs to keep these as distinct fields rather than merging them into one blob of text
  • Consolidated statements list multiple account numbers in a single PDF; each account's Holdings table must stay tagged to its own account number instead of collapsing into one long list
  • Asset Allocation is sometimes shown as a pie-chart graphic with percentage labels rather than a text table, which is harder to extract reliably than tabular data
  • Columns like Estimated Annual Income and Current Yield are often small footnoted values that can misalign with adjacent Market Value or Unrealized Gain/Loss columns if the table structure is nested

How It Works

  1. Upload your Morgan Stanley statement PDF (or a scanned image/photo of a printed statement)
  2. The AI identifies and separates sections: Holdings, Performance Summary, Asset Allocation, and Activity
  3. Review the extracted fields and customize which ones you need (e.g., just Holdings and Realized Gain/Loss, skipping narrative commentary)
  4. Export to Excel (.xlsx) or CSV, with one row per holding or line item

Why PDFexcel.ai

  • Handles multi-page nested Holdings by Asset Class tables that generic tools like Adobe Acrobat's row-by-row table export tend to break — Acrobat often loses multi-line security descriptions, while context-aware extraction preserves them
  • Custom field selection lets you pull only the Performance Summary metrics (Time-Weighted Return, benchmark) or only the Holdings table, instead of extracting the entire document as one dump
  • Batch processing supports converting several quarterly statements across multiple accounts at once, useful for RIAs managing a book of client portfolios
  • OCR handles older mailed or scanned Morgan Stanley statements that weren't downloaded as digital PDFs from the portal

Limitations

  • Asset Allocation shown only as a pie-chart graphic (no accompanying percentage table) may not extract cleanly since it's a visual element rather than structured text
  • Long consolidated statements covering 10+ sub-accounts with nested holdings tables may need a manual review pass to confirm rows weren't merged across accounts
  • Handwritten notes or advisor annotations added to a printed statement will not be reliably captured, consistent with limited handwriting recognition versus typed text

Example Use Cases

  • An RIA exports Time-Weighted Return figures from client statements each quarter into a master performance-tracking workbook
  • An individual investor pulls Market Value from the Holdings table monthly to update a personal net worth spreadsheet
  • A bookkeeper cross-checks the Realized Gain/Loss Summary against year-end tax documents before filing
  • A family office consolidates several Morgan Stanley Private Wealth Management account statements into one master Excel file for reporting

Frequently Asked Questions

Can it separate the Performance Summary from the Holdings table?

Yes. The AI identifies the Performance Summary block (Time-Weighted Rate of Return, benchmark comparison) as a distinct field set separate from the Holdings table, so you can export either section on its own or both together in structured rows.

Does this work with a Morgan Stanley consolidated statement covering multiple accounts?

Yes, consolidated PDFs with multiple account numbers can be processed, but on statements with many sub-accounts we recommend reviewing the export to confirm each holding stayed tagged to the correct account number.

What about older Morgan Stanley statements that were only mailed on paper?

Scanned or photographed paper statements are supported through OCR. Clear, well-aligned scans extract most reliably; skewed or low-resolution photos may need a manual check afterward.

Is this different from converting an E*Trade or Schwab brokerage statement?

Yes. Morgan Stanley's wealth management statements include Performance Summary and Asset Allocation blocks not typically found in E*Trade or Schwab statement layouts, so extraction needs to handle those sections in addition to the standard Holdings table.

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