DocuClipper logo
Back to blog

How To Convert an Edward Jones Statement to Excel

By DocuClipper Editorial Team, Financial document automation specialists
5 min read

Edward Jones brokerage statements use a household cover page with an Overview of Accounts table that rolls up to a Total Portfolio Value. This guide shows how to convert that PDF into a clean Excel workbook with one row per sub-account and a household summary.

Edward Jones brokerage statements use a distinctive household-first layout. The cover page shows a Total Portfolio Value $X figure across the top, followed by an Overview of Accounts table that lists each sub-account (taxable, IRA, Roth, trust) with its current value. Per-account detail sections then follow, each starting with Account Holder(s), Account Number NNN-NNNNN-N-N, and an Account Value $X figure.

This guide walks through converting an Edward Jones PDF into an Excel workbook with DocuClipper's brokerage statement converter. Every statement is checked against its printed Total Portfolio Value, on both multi-account household statements and single-account statements.

Drag & Drop Brokerage Statement Here

or

No file selected yet.

While you are here

Extract every transaction from any bank PDF

Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.

What gets extracted from an Edward Jones statement

DocuClipper maps each Edward Jones block to its own Excel sheet:

Edward Jones sectionExcel sheetWhat's in it
Overview of Accounts (multi-account cover)HoldingsOne row per sub-account: account label, holder name, account number (NNN-NNNNN-N-N format), prior value, current value
Total Portfolio ValueSummaryHousehold ending value, beginning value (1 Month Ago), change this period
Account Value (single-account)SummarySingle-account ending value when no household cover is present
Statement PeriodSummaryStatement period start and end (from the Statement Period or Statement Date header)

Each Holdings row carries the sub-account number (672-15795-1-1 format) so multi-account households can be filtered by account in Excel.

What's specific about Edward Jones statements

Account number format NNN-NNNNN-N-N. Edward Jones uses a four-segment account number. DocuClipper recognizes both Account Number 672-15795-1-1 and bare 672-15795-1-1 formats from the cover.

Two statement variants. Multi-account portfolio statements include a household cover with Total Portfolio Value and Overview of Accounts. Single-account statements have no household cover and use Account Value, Total Account Value, or Ending Value as the period-end figure.

Financial Advisor and Holder Name on the cover. Edward Jones prints Portfolio for <Name> (multi-account) or Account Holder(s) <Name> (single-account) on the cover, plus Financial Advisor <Name>, <phone>. DocuClipper captures both into the Summary sheet so household-level reports can group by advisor.

Three period formats. Period text varies between Nov 30 - Dec 31, 2019 (cross-month, abbreviated), Jan 1 - Jan 27, 2023 (same-year cross-month), and January 1 - January 27, 2023 (full month names). DocuClipper handles all three and normalizes to ISO dates.

Account types from the cover. Roth IRA, Rollover IRA, Traditional IRA, SEP IRA, and Living Trust account types are detected from the cover or per-account section header and shown as the account type in the Summary sheet. "Individual Retirement Account" is also recognized and shown as a Traditional IRA.

Consolidated 1099 Tax Statements are rejected. Edward Jones 1099 forms carry the same edwardjones.com domain but are tax forms, not portfolio statements. DocuClipper recognizes them as tax forms and keeps them out of your brokerage results.

Step-by-step: converting an Edward Jones statement to Excel

  1. Open DocuClipper and click the Brokerage Statement upload card on the Tools page.
  2. Drop your Edward Jones PDF onto the upload area. Both digital downloads and scanned/photographed mailed copies work. Multi-account household statements and single-account statements are both supported.
  3. Wait for extraction. A typical monthly Edward Jones household statement processes in under a minute. DocuClipper recognizes the layout on its own.
  4. Review the Holdings sheet. For multi-account statements, one row per sub-account from the Overview of Accounts table. For single-account statements, one aggregate row equal to the Account Value.
  5. Click Export → Excel to download the workbook with Holdings, Activity, Income, and Summary on separate sheets.

Put it into practice

Manual copy-paste is where errors begin

Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.

How the totals are checked

Every statement is checked against its printed balances. On a household statement, the sub-account values in the Overview of Accounts have to add up to the Total Portfolio Value on the cover; on a single-account statement, the figure is the Account Value. Continuation pages that repeat a sub-account row are counted once. Anything that doesn't tie out is flagged before export, so you know exactly which statement to look at.

Frequently asked questions

Does this work with Edward Jones household statements covering multiple accounts?

Yes. Multi-account portfolio statements (with the Overview of Accounts table on the cover) extract with one Holdings row per sub-account. Each row carries the account number and holder name so the workbook can be filtered or split per account.

Will it pull individual security positions or just per-account totals?

Today the Holdings sheet shows one row per sub-account from the Overview of Accounts, and those rows tie out to the printed Total Portfolio Value. Per-security rows (Cash, Mutual Funds, Stocks, Bonds within each account section) is on the roadmap; for that level of detail today, contact us.

Does it handle Edward Jones IRAs and trust accounts?

Yes. Roth IRA, Rollover IRA, Traditional IRA, SEP IRA, and Living Trust accounts are recognized from the cover or per-account section header and shown as the account type in the Summary sheet so retirement and taxable accounts can be filtered separately.

What about Edward Jones 1099 Tax Statements?

DocuClipper recognizes Consolidated 1099 Tax Statements as tax forms and keeps them out of your brokerage results, because they share the edwardjones.com domain but have no portfolio sections. Tax-form extraction is a separate workflow handled by the tax form data extraction product.

Can I batch multiple Edward Jones statements?

Yes. Upload twelve monthly Edward Jones PDFs in one batch and DocuClipper produces one workbook per statement, or merges them into an annual workbook for portfolio-review and tax-prep work. Multi-account households and single-account statements can be mixed in the same batch.

What's the difference between "Total Portfolio Value" and "Account Value"?

Total Portfolio Value is the household-level total across all sub-accounts on a multi-account statement. Account Value is the single-account ending value on a single-account statement. DocuClipper uses the right one for each statement, and both land in the same ending value column of the Summary sheet.


Next step

Upload your first statement free

No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.

Try DocuClipper free

Automate your financial document workflows

Extract data from bank statements, invoices, and receipts with 99.9% accuracy. Export to Excel, QuickBooks, or Xero in seconds.

Start free trial14-day free trial · No credit card required