How to Convert E*TRADE Statements to CSV

Quick Answer: To convert an ETRADE statement to CSV or Excel, download your monthly or quarterly PDF from the ETRADE portal's Documents section, then upload it to QuickBankConvert. The tool parses E*TRADE's PDF format — including brokerage and bank account transactions — and delivers a clean spreadsheet, usually in under a minute.

What Export Options Does E*TRADE Offer, and What Are Their Limitations?

ETRADE, now operating as ETRADE from Morgan Stanley following the 2020 acquisition, is a major retail brokerage platform known for active traders and options investors. The platform offers several ways to access transaction data:

• Transaction History download: From the web platform, you can export recent activity to CSV. However, this tool has date range limitations and may not capture all transaction types.
• Official PDF statements: Comprehensive monthly or quarterly statements are available from the Documents section. These are the most complete records and are the best source for archival-quality exports.
• OFX/QFX export: E*TRADE supports OFX export for Quicken import from the Account Documents area.
• Tax documents: 1099-B, 1099-DIV, and 1099-INT are available as PDFs during tax season.

For users who need a comprehensive spreadsheet from the official statement — rather than the limited activity export — QuickBankConvert provides reliable PDF-to-CSV conversion.

How to Download an E*TRADE Statement

1. Log in to your E*TRADE account at etrade.com or the Morgan Stanley self-directed investing portal.
2. Navigate to Accounts and select the account you need.
3. Click Documents from the account navigation.
4. Under Account Statements, select the period you want.
5. Click to download the PDF.
6. Save to your computer.

Tip: ETRADE typically stores 7 years of account statements online. If you need statements older than what is shown in the portal, contact ETRADE customer service.

How Do You Convert E*TRADE Statements with QuickBankConvert?

With your E*TRADE PDF ready:

1. Open QuickBankConvert in your browser.
2. Upload the E*TRADE PDF: Drop the file onto the upload area.
3. Check the preview: Verify that transaction dates, security names, quantities, prices, and amounts look correct.
4. Select output format: Choose CSV or Excel.
5. Download your file: Sign in with a free Google account, then click Export and save.

Your statement is uploaded over an encrypted connection and parsed on QuickBankConvert's servers. You never enter your E*TRADE login.

Privacy note: E*TRADE statements contain detailed portfolio and trading history. QuickBankConvert works only from the PDF you upload and never connects to your brokerage account, and you can ask for your files to be deleted through the contact page.

E*TRADE Statement Format Quirks

Separate Brokerage and Bank Sections

If you hold both an ETRADE brokerage account and an ETRADE Bank account, they may appear in separate sections of a combined statement — or as entirely separate PDFs. Review the section headers in your converted spreadsheet to distinguish bank from brokerage transactions.

Options Transaction Notation

Options trades include full contract notation (e.g., "Buy to Open 2 XYZ Jan 19 2024 $150 CALL"). This notation will appear in the Description column as-is. For options analysis, you may want to parse the Description further in Excel.

E*TRADE Pro vs. Standard Platform

ETRADE offers both a standard platform and ETRADE Pro for active traders. Statements from both platforms follow the same format.

Morgan Stanley E*TRADE Branding

Post-acquisition statements carry Morgan Stanley ETRADE branding in the header. The transaction table format is consistent with legacy ETRADE statements.

Commission and Fee Rows

Trade commissions (if applicable) and other account fees appear as separate rows in the statement. These will be captured in the converted output.

Conversion Method Comparison

How Do You Use E*TRADE Data in Excel?

Trade analysis: Calculate your realized gains and losses by matching sell transactions to their corresponding buy transactions using FIFO or specific lot methods. Excel VLOOKUP or INDEX/MATCH can automate this.

Options strategy tracking: If you actively trade options, a converted statement spreadsheet lets you group trades by underlying symbol and strategy type for P&L analysis.

Tax preparation (Schedule D): Use the converted CSV to build a preliminary Schedule D before reviewing your 1099-B. This helps catch discrepancies early.

Dividend tracking: Identify and total all dividend income rows by quarter for tax planning and quarterly estimated payments.

Callout — For Active E*TRADE Options Traders: If you trade dozens of options contracts per month, a converted monthly statement spreadsheet is essential for tracking your positions and calculating P&L. Use Excel's SUMIF function to aggregate realized gains by underlying symbol.

Tips for Accurate Exports

• Download the complete monthly statement: The full PDF provides all transaction types including corporate actions, reinvestments, and fee adjustments — not just trades.
• Verify the total number of transactions: After conversion, compare the row count to the number of transaction lines visible in the PDF to ensure nothing was missed.
• Handle multi-page statements: Active traders may have 20+ pages of transactions per month. The free plan takes statements of up to 10 pages and the paid plans up to 50 or 100 — just verify the row count after conversion.
• Review commission rows: If you made trades subject to commissions, verify that commission rows appear in the output and are attributed to the correct trades.

Callout — For E*TRADE Users Transitioning to Morgan Stanley: If you are consolidating your ETRADE brokerage account into a full Morgan Stanley relationship, converting and archiving your historical ETRADE statements to CSV ensures your full transaction history is preserved in a portable format that is not dependent on portal access.

Visit QuickBankConvert to convert your E*TRADE statement to CSV or Excel now.