How To Convert an Edward Jones Statement to Excel
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.
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 section | Excel sheet | What's in it |
|---|---|---|
| Overview of Accounts (multi-account cover) | Holdings | One row per sub-account: account label, holder name, account number (NNN-NNNNN-N-N format), prior value, current value |
| Total Portfolio Value | Summary | Household ending value, beginning value (1 Month Ago), change this period |
| Account Value (single-account) | Summary | Single-account ending value when no household cover is present |
| Statement Period | Summary | Statement 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
- Open DocuClipper and click the Brokerage Statement upload card on the Tools page.
- 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.
- Wait for extraction. A typical monthly Edward Jones household statement processes in under a minute. DocuClipper recognizes the layout on its own.
- 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.
- 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.
Related Articles
- Brokerage Statement Converter
- Brokerage Statement to Excel
- Best Brokerage Statement Converter Software
- How to Convert a Schwab Brokerage Statement to Excel
- How to Convert a Fidelity Brokerage Statement to Excel
- How to Convert a Merrill Lynch Statement to Excel
- How to Convert a Wells Fargo Advisors Statement to Excel
- How to Convert a Raymond James Statement to Excel
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.