Convert E*TRADE Statement to Excel

Upload any E*TRADE (Morgan Stanley) statement PDF — Brokerage, Roth IRA, Traditional IRA, Stock Plan (ESPP / RSU / employer-stock awards), plus year-end consolidated 1099s — and get a clean Excel file with holdings, transactions, dividends, realized gains/losses, and stock-plan vesting events on separate sheets.

Convert your E*TRADE statement — free

E*TRADE Stock Plan accounts add a layer most tools can't handle

E*TRADE merged with Morgan Stanley but most users still hold accounts on the E*TRADE platform. Beyond standard Brokerage and IRA accounts, E*TRADE is the dominant employer stock-plan recordkeeper in the U.S. — RSU vesting events, ESPP purchase events, ISO exercises, NQSO exercises all generate complex tax events that need to flow into Schedule D and W-2 reconciliation.

RSU vesting creates a tax event on the day of vest (ordinary income at vest-day FMV) plus a cost basis for future capital-gain calculation when the RSU is sold. ESPP purchases add the disqualifying-disposition vs qualifying-disposition complication. Generic PDF tools either miss the stock-plan section entirely or extract it but lose the tax-relevant fields.

Built for E*TRADE Brokerage + IRA + Stock Plan workflows

PDFExcel reads E*TRADE Brokerage and IRA statements with the standard workflow — holdings, transactions, dividends, realized G&L on separate sheets. Stock Plan (ESPP / RSU / ISO / NQSO) statements extract with vest date, vest-day FMV, shares vested, ordinary income at vest, sold-to-cover shares (when same-day-sale), and cost basis for retained shares.

Year-end consolidated 1099s reconcile across 1099-DIV / 1099-B sections plus a Stock Plan supplemental schedule. Pair with W-2 extraction to reconcile RSU ordinary income reported in Box 1 against the stock-plan supplemental schedule. Built-in OCR handles scanned statements automatically.

Fields you can pull

  • Account Type (Brokerage / IRA / Stock Plan ESPP / Stock Plan RSU)
  • Security Name + Symbol
  • Vest Date / Purchase Date / Trade Date
  • Shares
  • Vest-Day FMV (RSU)
  • Purchase Price + Discount (ESPP)
  • Cost Basis (Adjusted for Stock Plan)
  • Realized Gain/Loss
  • Ordinary Income (Stock Plan)

The model knows that an RSU vest creates ordinary income at FMV on vest date AND establishes cost basis for future capital-gain calculation — and that ESPP purchases need both purchase price and FMV-on-purchase preserved for the qualifying-vs-disqualifying disposition test.

Why preparers and equity-comp clients pick PDFExcel for E*TRADE

E*TRADE is the dominant employer stock-plan recordkeeper. Most tools handle generic brokerage statements but miss the stock-plan-specific fields critical for accurate tax filing.

  • Knows ESPP, RSU, ISO, NQSO. Stock Plan supplemental schedules extract with vest dates, FMV, ordinary income, and adjusted cost basis. Trained on real E*TRADE Stock Plan statements.
  • Free to start, no credit card. 10 documents free every month. Plans from $69/month for 50 documents — most equity-comp clients fit Starter or Pro.
  • No employer-portal integration. Works on any client-provided E*TRADE PDF — no employer-managed-only API gates.
  • Files deleted after processing. Stock-plan documents are extremely sensitive (employer compensation data) — files processed in memory and deleted immediately.

How it works

  1. Upload your E*TRADE statement. Brokerage, IRA, Stock Plan (ESPP / RSU / ISO / NQSO), or year-end consolidated 1099 + Stock Plan supplemental. One file or a household batch as a ZIP.
  2. Pick what you need. Holdings + Realized G&L for tax prep, Stock Plan vesting + ESPP for equity-comp tax reconciliation, Transactions + Dividends for monthly review.
  3. Download by section. Excel workbook with each section + Stock Plan as separate sheets. Drop into your tax software or W-2 reconciliation worksheet.

What an E*TRADE Stock Plan RSU vesting schedule looks like in Excel

Each vest event with vest-day FMV, shares vested, sold-to-cover, and adjusted cost basis for retained shares — Schedule D + W-2 reconciliation ready.

# Vest Date Symbol Shares Vested Vest FMV Sold-to-Cover Retained Adj Basis
1 02/15/2024 TECH 184 $284.20 82 102 $28,988.40
2 05/15/2024 TECH 184 $310.40 85 99 $30,729.60
3 08/15/2024 TECH 184 $268.80 78 106 $28,492.80
4 11/15/2024 TECH 184 $298.40 82 102 $30,436.80

Built for equity-comp employees and their tax preparers

Tech employees with RSU and ESPP at companies on E*TRADE, tax preparers handling equity-comp client returns, family-office tax teams reconciling W-2 ordinary income to Stock Plan supplemental.

A tech employee with RSUs

4 RSU vests per year. Convert year-end Stock Plan supplemental, build per-vest cost-basis worksheet for retained-share Schedule D when shares are eventually sold.

A tax preparer with equity-comp clients

10 clients at the same large tech employer, each with RSU + ESPP. Convert all 10 stock-plan supplementals as one batch, reconcile RSU ordinary income to W-2 Box 1 in 30 minutes per client vs 3 hours of typing.

A family office with founder clients

Founder client took NQSO exercise during liquidity event. Convert E*TRADE statement showing exercise event with FMV, exercise price, and ordinary income — feeds into the founder's Schedule D and AMT preference calculation.

Pricing

  • Free — 10 documents / month, no credit card
  • Starter $69/mo — 50 documents, $1.50 per extra
  • Pro $199/mo — 200 documents, $0.99 per extra
  • Business $699/mo — 1,000 documents, $0.59 per extra

Frequently asked questions

Does it handle RSU vesting events with adjusted cost basis?

Yes. RSU vest events extract with vest date, shares vested, vest-day FMV, sold-to-cover shares (when applicable), retained shares, and the adjusted cost basis for retained shares. Critical for accurate Schedule D filing when retained shares are eventually sold.

What about ESPP qualifying-vs-disqualifying disposition?

Yes. ESPP purchases extract with offering-period start date, purchase date, purchase price, FMV-on-purchase, and discount amount. The qualifying-vs-disqualifying test depends on holding period — we provide the input data; the test still happens in your tax-prep workflow.

Will it reconcile RSU ordinary income against W-2 Box 1?

We export both pieces — Stock Plan supplemental shows RSU ordinary income at vest, W-2 extraction shows Box 1 wages. Reconciliation happens in your worksheet — the two numbers should agree (employer should have included RSU ordinary income in W-2 wages).

Does it work on Morgan Stanley-merged statements?

Yes. Post-merger, some accounts moved to Morgan Stanley wealth platforms while others remain on E*TRADE. The model reads both layouts. Stock Plan accounts predominantly stay on E*TRADE.

Is this really free?

10 documents per month, free, forever. Plans from $69/month for 50 documents — most equity-comp clients fit Starter; preparers handling 10+ tech-employee clients fit Pro.

Related guides