Convert Fidelity Statement to Excel

Upload any Fidelity statement PDF — Fidelity Brokerage, Roth IRA, Traditional IRA, NetBenefits 401(k), Fidelity Cash Management, plus year-end consolidated 1099s — and get a clean Excel file with holdings, transactions, dividends, and realized gains/losses on separate sheets.

Convert your Fidelity statement — free

Fidelity statements come in many product flavors with different layouts

A typical Fidelity Brokerage statement runs 30-80 pages with separate sections for Account Summary, Holdings (organized by asset class), Transactions, Dividends, Estimated Annual Income, and Realized Gains. NetBenefits 401(k) statements use a different layout entirely — emphasizing contribution sources, vested balance, and fund-level allocation. Cash Management statements look more like bank statements.

Tax preparers handling Fidelity clients see all three product layouts in a single client envelope, plus the year-end consolidated 1099 (separate from monthly statements). Generic PDF tools trained on one layout fail on the others, forcing manual cleanup or per-product workflows.

Every Fidelity product layout, one workflow

PDFExcel reads Fidelity Brokerage, Roth IRA, Traditional IRA, NetBenefits 401(k), and Cash Management statements automatically. Brokerage statements split into Holdings, Transactions, Dividends, and Realized G&L sheets. NetBenefits 401(k) statements extract contribution sources, vested balance, and fund-level allocation as separate fields. Cash Management statements extract through the standard bank-statement workflow.

Year-end consolidated 1099s reconcile across 1099-DIV / 1099-INT / 1099-B / 1099-MISC sections. Drop the export into your tax software, advisor portfolio system, or 401(k) reconciliation worksheet. Pair with 1099 extraction for cross-broker tax-prep consolidation.

Fields you can pull

  • Section / Account Type (Brokerage / IRA / 401(k) / Cash Mgmt)
  • Security Name + Symbol
  • Shares / Quantity
  • Cost Basis
  • Market Value
  • Realized Gain/Loss
  • Dividend Amount + Tax Classification
  • 401(k) Contribution Source (Pre-tax / Roth / Match / After-tax)
  • Vested Balance
  • Fund Allocation %

The model knows the difference between Fidelity Brokerage's Holdings section (taxable) and a NetBenefits 401(k)'s Holdings section (tax-deferred) — and tags account type accordingly so you don't accidentally treat 401(k) realized gains as taxable Schedule D events.

Why tax preparers, advisors, and HR teams pick PDFExcel

Fidelity is the largest U.S. recordkeeper for retirement plans plus a major retail broker. Most tools handle one product line; PDFExcel handles all of them.

  • All Fidelity product layouts. Brokerage, IRA, NetBenefits 401(k), Cash Management — plus consolidated year-end 1099s. Trained on real Fidelity statements across all product lines.
  • Free to start, no credit card. 10 documents free every month. Plans from $69/month for 50 documents.
  • No advisor-portal integration. Works on any client-provided Fidelity PDF. No advisor-managed-only API gates, no per-account configuration.
  • Files deleted after processing. Brokerage and retirement statements are sensitive — files processed in memory and deleted immediately.

How it works

  1. Upload your Fidelity statement. Brokerage, IRA, NetBenefits 401(k), Cash Management, or year-end consolidated 1099. One file or a household batch as a ZIP.
  2. Pick what you need. Holdings + Realized G&L for tax prep, 401(k) Contributions + Vested for retirement reconciliation, Transactions + Dividends for monthly review.
  3. Download by section. Excel workbook with each section as its own sheet. Account Type column distinguishes taxable vs tax-deferred.

What a Fidelity NetBenefits 401(k) statement looks like in Excel

Contribution sources separated, vested balance preserved, fund-level allocation broken out — useful for retirement reconciliation and rollover planning.

# Fund Source Shares Market Value % Allocation Vested
1 FXAIX (S&P 500 Index) Pre-tax 184.20 $32,820.40 32% 100%
2 FXAIX (S&P 500 Index) Employer Match 92.10 $16,410.20 16% 60%
3 FSPSX (International Index) Pre-tax 62.40 $8,420.00 8% 100%
4 FXNAX (US Bond Index) Pre-tax 78.20 $8,140.00 8% 100%
5 FFFFX (Freedom 2050 Target Date) Roth 184.40 $24,180.00 24% 100%
6 Company Stock — TECHWAVE INC Employer Match 84.00 $12,820.00 12% 60%

Built for tax preparers, wealth advisors, and HR retirement teams

Tax preparers handling Fidelity clients across brokerage and retirement, wealth managers tracking household positions, HR retirement teams reconciling NetBenefits against payroll provider data.

A tax preparer in March

HNW client has Fidelity Brokerage + Roth IRA + 401(k). Convert all three statement types as one batch — tax preparer pulls only the taxable Schedule D data from Brokerage, ignores the IRA + 401(k) realized gains (not reportable).

A wealth advisor

Quarterly review for 25 households with Fidelity accounts. Convert each household's statement bundle, build a household-level position summary across taxable + tax-deferred accounts.

An HR retirement plan analyst

Reconciles NetBenefits 401(k) statements against the payroll provider's contribution register. Convert participant statements, validate contribution amounts and source allocation match payroll.

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 NetBenefits 401(k) statements?

Yes. NetBenefits 401(k) statements extract with fund holdings, contribution source breakdown (Pre-tax / Roth / Employer Match / After-tax), vested balance, and fund-level allocation. Useful for retirement reconciliation and rollover planning.

Will it tag taxable vs tax-deferred accounts?

Yes. Account Type column distinguishes Brokerage (taxable) from IRA / 401(k) (tax-deferred) so you don't accidentally pull tax-deferred realized gains into Schedule D when filing taxes.

Does it handle Fidelity consolidated year-end 1099s?

Yes. The 1099-DIV / 1099-INT / 1099-B / 1099-MISC sections each extract as their own sheet. Summary-page numbers reconcile to per-section detail. See 1099 extraction for cross-broker consolidation.

What about Fidelity Cash Management?

Yes. Fidelity Cash Management statements use a more traditional bank-statement layout and extract through the standard bank-statement workflow. Run a household upload that mixes Brokerage + Cash Management — both come back in one workbook.

Is this really free?

10 documents per month, free, forever. Plans from $69/month for 50 documents — most preparers and advisors handling 10-50 Fidelity clients fit Pro at $199/month for 200 documents.

Related guides