How To Convert an E*TRADE Brokerage Statement to Excel
E*TRADE brokerage statements cover standard brokerage, Power E*TRADE, IRA, and margin accounts. This guide shows how to convert an E*TRADE PDF statement into a clean Excel workbook with holdings, account activity, and income on separate sheets.
ETRADE statements, formally issued by ETRADE Securities and Morgan Stanley (which acquired E*TRADE in 2020), include brokerage positions, account activity, dividends, interest, and portfolio summary data in a single PDF. A typical monthly statement on an active account can run 15–30 pages depending on trade volume and position count.
Extracting that data manually into Excel takes hours. This guide shows how to convert an E*TRADE PDF into structured Excel data with 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 E*TRADE sections to Excel sheets
| E*TRADE statement section | Excel sheet | Key columns |
|---|---|---|
| Portfolio Summary | Summary | Beginning value, ending value, net change, cash balance, margin balance |
| Positions | Holdings | symbol, security_name, quantity, price, cost_basis, market_value, unrealized_gain_loss, asset_type |
| Account Activity | Activity | date, type (buy/sell/deposit/withdrawal/dividend/margin_interest), symbol, description, quantity, price, amount |
| Dividends & Interest | Income | date, symbol, income_type (ordinary/qualified dividend, interest), amount |
What's different about E*TRADE statement layouts
Morgan Stanley rebrand. Since 2020, some ETRADE statements show "Morgan Stanley" branding on the cover but retain the ETRADE Securities account number and statement layout. DocuClipper recognizes both formats.
Margin account activity. If your account uses margin, E*TRADE breaks out margin interest charges separately. DocuClipper captures these as type=margin_interest rows in the Activity sheet.
Power E*TRADE statements. Power ETRADE (the active-trader platform) produces statements with the same structure as standard ETRADE brokerage. No separate template is needed.
Options positions. E*TRADE includes options positions in the Holdings section with strike, expiration, and contract size. DocuClipper extracts these as rows with asset_type=option alongside equity positions.
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 an E*TRADE PDF statement
- Log in to etrade.com
- Go to Accounts → Documents → Statements
- Select the account and statement date, click the PDF icon to download
- Open DocuClipper, drop the PDF, and click Extract
Combined statements that include multiple E*TRADE accounts (e.g., brokerage + IRA) are supported, each account extracts with its own account number column.
FAQs about E*TRADE statement conversion
Does DocuClipper work with both the old ETRADE and the new Morgan Stanley ETRADE layouts?
Yes. Both the pre-2020 ETRADE format and the post-acquisition Morgan Stanley ETRADE layout are handled without any configuration. The underlying statement structure is similar across both.
Can I convert E*TRADE options activity to Excel?
Yes. E*TRADE includes options positions in Holdings and options trades in Account Activity. DocuClipper extracts both, flagging options rows with asset_type=option and including underlying symbol, strike price, expiration date, and contract count where present on the statement.
What if I have both a brokerage and an IRA at E*TRADE?
E*TRADE often produces separate statements for each account. Upload both PDFs at once, DocuClipper consolidates them into a single workbook with account number and account type as separate columns so you can filter by account in Excel.
Can I convert multiple months of E*TRADE statements at once?
Yes. DocuClipper supports multi-file uploads. Drop all your E*TRADE PDFs and the output is a single Excel file with all months consolidated, one row per position or per transaction.
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 a Merrill Lynch 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.