Document Guide

Convert Edward Jones Statements to Excel

Extract holdings, transactions, and advisory fee details from Edward Jones PDF statements into structured Excel or CSV files, without retyping every line.

Edward Jones statements combine an Account Summary, a Holdings section broken out by asset class (Stocks, Mutual Funds, Bonds, Cash), a Transaction Detail section, and a separate Advisory Fee breakdown showing the Annual Rate and Fee This Period for managed accounts. That layout differs from Schwab's or Fidelity's single consolidated table, so generic table-scrapers often merge the wrong columns. pdfexcel.ai reads the PDF using field context rather than fixed column positions, so it can pull holdings, transaction rows, and fee line items into one structured spreadsheet — useful for tracking portfolio value over time, reconciling advisory fees, or feeding data into a personal finance tool.

Who This Is For

  • Investors who want their Edward Jones holdings and transactions in a spreadsheet for personal tracking
  • Bookkeepers or accountants reconciling advisory fees across multiple client accounts
  • Financial advisors compiling multi-account summaries outside the Edward Jones portal
  • Anyone comparing Edward Jones advisory fees against other custodians over several quarters

When This Is Relevant

  • Reviewing quarterly advisory fees (the 'Fee This Period' line) across a full year of statements
  • Building a rolling net worth tracker that needs holdings values pulled from each monthly PDF
  • Preparing year-end summaries before handing records to a tax preparer
  • Migrating historical Edward Jones data into a portfolio tool like Personal Capital or a custom Excel model

Supported Inputs

  • Digital PDF statements downloaded from Edward Jones Online Access
  • Scanned paper copies of Edward Jones statements
  • Photos or screenshots of statement pages (PNG/JPEG)
  • Multi-page statements combining summary, holdings, and transaction sections

Expected Outputs

  • Excel (.xlsx) file with one row per holding or transaction, columns for Account Number, Symbol/CUSIP, Description, Quantity, Price, Market Value, and Unrealized Gain/Loss
  • CSV export suitable for import into Excel, Google Sheets, or accounting software

Common Challenges

  • Advisory fee details appear on a separate page from holdings, and generic extractors sometimes drop the 'Annual Rate' and 'Fee This Period' figures entirely
  • Holdings are grouped by asset class (Stocks, then Mutual Funds, then Bonds) with subtotal rows in between, which can confuse row-by-row scrapers into treating subtotals as transactions
  • Scanned or faxed copies with skewed pages often misalign the Quantity and Price columns — running a basic deskew or rescanning at a straighter angle before upload improves accuracy
  • Multi-line security descriptions (e.g., a bond's full issuer name wrapping to a second line) can get split into separate rows if the tool reads strictly by line position instead of field context

How It Works

  1. Upload one or more Edward Jones statement PDFs (or photos of printed statements) to pdfexcel.ai
  2. The AI identifies statement sections — Account Summary, Holdings by asset class, Transaction Detail, and Advisory Fee — and extracts the fields you need
  3. Review the extracted data in a preview table and adjust field selection if you want fewer or additional columns, such as adding Estimated Annual Income
  4. Export the results as an Excel (.xlsx) file or CSV, with one row per holding, transaction, or fee line depending on your setup

Why PDFexcel.ai

  • Edward Jones' fee and holdings layout is distinct from Schwab, Fidelity, and Vanguard formats — field-context extraction adapts to it instead of relying on a fixed template built for another broker
  • Batch processing handles a full year of monthly or quarterly statements in one run instead of uploading each PDF separately
  • OCR support covers scanned or photographed statements for accounts where paper copies are the only record
  • Custom field selection lets you pull just the Advisory Fee section, just Holdings, or both — instead of a rigid one-size table

Limitations

  • Extraction accuracy depends on PDF and scan quality; blurry photos of paper statements may need manual review of a few rows
  • Very dense multi-page holdings tables with nested subtotals may require a quick check to confirm subtotal rows weren't counted as individual positions
  • Handwritten annotations added to a printed statement (e.g., notes in the margin) are not reliably captured
  • Non-standard or older Edward Jones statement layouts (pre-redesign formats) may need field customization to map correctly

Example Use Cases

  • Pulling 12 months of Edward Jones holdings values into one Excel sheet to chart portfolio growth
  • Extracting Advisory Fee (Fee This Period) rows across quarterly statements to total annual advisory costs
  • Converting a scanned older Edward Jones statement into CSV for import into a personal finance spreadsheet
  • Compiling transaction detail rows (buys, sells, dividends) from several months of statements for a tax preparer

Frequently Asked Questions

Can pdfexcel.ai extract the advisory fee section from an Edward Jones statement?

Yes. The Advisory Fee section (showing Annual Rate and Fee This Period) is typically on a separate page from holdings — pdfexcel.ai identifies it by field context and can extract it as its own row or column set alongside holdings data.

Will the holdings by asset class (Stocks, Mutual Funds, Bonds) stay separated in the spreadsheet?

Yes, the extraction preserves each asset class grouping as it appears in the source PDF, so you can filter or sort by category in Excel rather than getting one flat unsorted list.

What if my Edward Jones statement is a scanned paper copy, not the original PDF?

OCR handles scanned documents and photos, but skewed or low-resolution scans can misalign columns like Quantity and Price. Straightening the page and scanning at a higher resolution before upload improves the result.

Does this replace manually reconciling my Edward Jones account?

No — it converts the PDF into a structured spreadsheet to save data entry time, but you should still review extracted totals against the original statement, especially for complex multi-page holdings tables.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources