How To Convert a Morgan Stanley Statement to Excel
Morgan Stanley CLIENT STATEMENT documents (Wealth Management, Smith Barney, and post-acquisition E*TRADE) use a HOLDINGS table with per-asset-class aggregate rows. This guide shows how to convert that PDF into a clean Excel workbook with Holdings, Activity, and Summary on separate sheets.
Morgan Stanley brokerage statements use the same underlying CLIENT STATEMENT layout across multiple sub-brands: Morgan Stanley Wealth Management, Morgan Stanley Smith Barney LLC, and post-acquisition ETRADE accounts (ETRADE was acquired by Morgan Stanley in 2020). All three carry "Morgan Stanley" branding on the cover, a For the Period header with a date range, a Beginning Total Value and Ending Total Value row, and a HOLDINGS table organized by asset class.
This guide walks through converting a Morgan Stanley PDF into an Excel workbook with DocuClipper's brokerage statement converter. DocuClipper routes Morgan Stanley statements through the same extractor as post-acquisition ETRADE statements (the layouts converge), and on the combined corpus the extractor reconciles 46 of 49 statements (94%). The 3 unreconciled cases are: 2 tiny ~$120 ETRADE accounts where a DD-symbol fuses to the description (a known edge case being tracked), and 1 Morgan Stanley statement where the source itself has a $5.40 rounding discrepancy on a $1.49M total.
While you are here
Extract every transaction from any bank PDF
Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.
What gets extracted from a Morgan Stanley statement
DocuClipper maps each block of the Morgan Stanley CLIENT STATEMENT to its own Excel sheet:
| Morgan Stanley section | Excel sheet | What's in it |
|---|---|---|
| HOLDINGS (per-asset-class aggregate rows) | Holdings | Cash / BDP / MMFs, Stocks, Mutual Funds, Bonds, Options, Exchange-Traded Funds, Closed-End Funds, Fixed Income, Alternatives, Preferred Securities, Structured Investments, Annuities, Unit Investment Trusts |
| Beginning Total Value / Ending Total Value | Summary | Beginning value (as of period start), ending value (as of period end), change this period |
| TOTAL VALUE OF YOUR ACCOUNT (older single-period layouts) | Summary | End-of-period total when only ending value is printed |
| For the Period | Summary | Statement period start and end (parsed from For the Period April 1- June 30, 2025 headers) |
What's specific about Morgan Stanley statements
Three sub-brands, one layout. Morgan Stanley Wealth Management, Morgan Stanley Smith Barney LLC, and post-acquisition E*TRADE statements all use the CLIENT STATEMENT template with the HOLDINGS table. DocuClipper auto-routes all three through the same extractor and reports the variant in the Summary sheet.
Post-acquisition E*TRADE positioning. Since the 2020 Morgan Stanley acquisition, some ETRADE statements show "ETRADE is a business of Morgan Stanley" branding and use the new CLIENT STATEMENT layout. Others retain the legacy ETRADE Securities ACCOUNT HOLDINGS layout. DocuClipper detects which variant you have based on cover branding and routes to the right parser. If you specifically have a legacy ETRADE statement with the ACCOUNT HOLDINGS section, see the E*TRADE statement to Excel walkthrough.
Per-asset-class aggregate rows reconcile to TOTAL VALUE. The HOLDINGS table prints rows like STOCKS 96.43% ... $1,845,947.55 ... and CASH, BDP, AND MMFs 3.57% ... $68,436.83 ..., which sum to the printed Ending Total Value (or TOTAL VALUE OF YOUR ACCOUNT on older layouts). DocuClipper uses these aggregate rows as Holdings positions, which gives a deterministic reconciliation gate without per-security row parsing.
Negative cash and FX values preserved. Morgan Stanley wraps negative values in parentheses (e.g. margin debit balances or foreign-exchange losses appear as $(1,234.56)). DocuClipper preserves the sign through parseMoney so the Holdings sheet shows actual debit positions rather than dropping or absolute-valuing them.
Account types from the cover. IRA - ROTH, IRA - ROLLOVER, IRA - CONTRIBUTORY (Traditional), SEP IRA, INDIVIDUAL, and TRUST account types are detected from the Account Type: line on page 1 and reported in the Summary sheet as accountType=roth_ira, traditional_ira, etc.
Period format For the Period April 1- June 30, 2025. Morgan Stanley uses a compact same-year period format. DocuClipper parses both the cross-month variant (April 1- June 30, 2025) and the same-month variant (December 1-31, 2023) and normalizes to ISO dates.
Step-by-step: converting a Morgan Stanley statement to Excel
- Open DocuClipper and click the Brokerage Statement upload card on the Tools page.
- Drop your Morgan Stanley PDF onto the upload area. Wealth Management, Smith Barney, and post-acquisition E*TRADE-branded CLIENT STATEMENT documents all work. Scanned mailed copies go through OCR first.
- Wait for extraction. A typical monthly or quarterly Morgan Stanley statement processes in under a minute. DocuClipper auto-detects the variant.
- Review the Holdings sheet. Each non-zero asset-class aggregate row from the HOLDINGS table is one row.
- Click Export → Excel to download the workbook with Holdings, Activity, Income, and Summary on separate sheets.
Put it into practice
Manual copy-paste is where errors begin
Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.
How the Morgan Stanley extractor works under the hood
DocuClipper uses pdftotext with -layout to preserve the column alignment of the HOLDINGS table, then anchors per-asset-class rows by label (CASH, BDP, AND MMFs, STOCKS, MUTUAL FUNDS, BONDS, OPTIONS, EXCHANGE TRADED FUNDS, EXCHANGE-TRADED & CLOSED-END FUNDS, FIXED INCOME, ALTERNATIVES, PREFERRED SECURITIES, STRUCTURED INVESTMENTS, SAVINGS AND TIME DEPOSITS, ANNUITIES, UNIT INVESTMENT TRUSTS).
The HOLDINGS row format includes multiple money columns (Total Cost, Market Value, realized/unrealized gain, Estimated Annual Income). DocuClipper picks the Market Value column based on token order: 1 token means Market Value only, 2 tokens means [Market Value, EAI] (take first), 3+ tokens means [Total Cost, Market Value, ...realized/unrealized..., EAI] (take second). Negative values wrapped in parens are preserved with their sign.
The reconciliation gate is the printed Ending Total Value (or TOTAL VALUE OF YOUR ACCOUNT on older single-period layouts). If the sum of per-asset-class market values doesn't match within $1, the document is flagged unreconciled. Rows labeled TOTAL VALUE or TOTAL ALLOCATION are explicitly skipped so the grand-total row doesn't double-count.
Frequently asked questions
Does this work for both Morgan Stanley Wealth Management and post-acquisition E*TRADE statements?
Yes. Both Wealth Management Smith Barney CLIENT STATEMENT documents and post-acquisition ETRADE statements that use the new CLIENT STATEMENT layout are routed through the same Morgan Stanley extractor. DocuClipper auto-detects the variant from the cover branding. If you have a legacy ETRADE statement with the older ACCOUNT HOLDINGS section, see the E*TRADE statement to Excel walkthrough.
Will it pull individual security positions or just per-asset-class aggregates?
The current Morgan Stanley extractor uses per-asset-class aggregate rows (STOCKS, MUTUAL FUNDS, BONDS, CASH, etc.) as Holdings positions. That gives a deterministic reconciliation against the Ending Total Value. Per-security row extraction (CUSIP, ticker, quantity, price per holding) is on the roadmap; for that level of detail today, contact us.
Does it handle Morgan Stanley IRAs and trust accounts?
Yes. IRA - ROTH, IRA - ROLLOVER, IRA - CONTRIBUTORY (Traditional), SEP IRA, and TRUST accounts are recognized from the Account Type: line on the cover and reported as accountType in the Summary sheet so retirement and taxable accounts can be filtered separately.
What about negative cash balances or margin debit positions?
Morgan Stanley prints negative values in parentheses ($(1,234.56)). DocuClipper preserves the sign so margin debit balances and foreign-exchange losses land in the Holdings sheet as negative numbers rather than being dropped or absolute-valued.
Can I batch a year of monthly Morgan Stanley statements?
Yes. Upload twelve monthly Morgan Stanley PDFs and DocuClipper produces one workbook per statement, or merges them into an annual workbook for portfolio-review and tax-prep work. Multiple sub-brand variants (Wealth Management, Smith Barney, post-acquisition E*TRADE) can be mixed in the same batch.
What's the relationship between Morgan Stanley and E*TRADE statements?
Morgan Stanley acquired ETRADE in 2020. After the acquisition, some ETRADE statements migrated to the Morgan Stanley CLIENT STATEMENT layout while others kept the legacy E*TRADE format. DocuClipper detects which layout you have based on cover branding and routes appropriately. The output Excel workbook uses the same column structure for both, so cross-period comparisons work even if the underlying layout changed mid-year.
Why is the reliability rate 94% instead of 100% for Morgan Stanley?
Morgan Stanley shares the extractor with post-acquisition ETRADE because the layouts converge. The combined corpus of 49 statements reconciles 46 (94%). The 3 misses are: 2 tiny ~$120 ETRADE accounts with a known DD-symbol-fused-to-description edge case, and 1 Morgan Stanley statement where the source PDF has a $5.40 rounding discrepancy on a $1.49M total (the source itself doesn't reconcile). Across pure Morgan Stanley wealth-management documents, reconciliation is essentially clean.
Related Articles
- Brokerage Statement Converter
- Brokerage Statement to Excel
- Best Brokerage Statement Converter Software
- How to Convert an E*TRADE Statement to Excel
- How to Convert a Schwab Brokerage Statement to Excel
- How to Convert a Fidelity Brokerage Statement to Excel
- How to Convert a Merrill Lynch Statement to Excel
- How to Convert a Wells Fargo Advisors Statement to Excel
- How to Convert a Raymond James Statement to Excel
- How to Convert an Edward Jones Statement to Excel
Next step
Upload your first statement free
No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.