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. On the corpus we tested against, the Edward Jones extractor reconciles 8 of 8 statements (100%), with the sum of per-sub-account values matching the printed Total Portfolio Value to within $1 across 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 (parsed from Statement Period Mmm DD - Mmm DD, YYYY or Statement Date headers) |
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 (statementVariant=premium) include a household cover with Total Portfolio Value and Overview of Accounts. Single-account statements (statementVariant=classic) 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 (holderName, advisorFirm) 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 reported in the Summary sheet as accountType=roth_ira, traditional_ira, etc. "Individual Retirement Account" is also recognized and treated as 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's detection layer rejects them at the brokerage extractor's front door so they don't get conflated.
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 auto-detects the variant.
- 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 Edward Jones extractor works under the hood
DocuClipper uses pdftotext with -layout to preserve the Overview of Accounts table layout. The cover page in pdftotext output often interleaves sidebar marketing copy with the cover figures, so DocuClipper anchors the Total Portfolio Value extraction on a dollar amount appearing on its own indented line within 1500 characters of the Total Portfolio Value label, with a fallback to inline-format documents.
Per-sub-account rows in the Overview of Accounts table follow a stable shape: <Label> <Holder Name> <Account # NNN-NNNNN-N-N> $<Prior> $<Current>. DocuClipper deduplicates by account number (continuation pages can repeat the same row) and validates that the sum of current-value columns matches the printed Total Portfolio Value within $1. If it doesn't, the extractor falls back to a single aggregate household position equal to the Total Portfolio Value, so the document still reconciles trivially.
For single-account statements (no household cover), DocuClipper emits one aggregate position labeled with the holder name and account number, equal to the Account Value.
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?
The current Edward Jones extractor uses per-sub-account totals from the Overview of Accounts as Holdings rows. That gives a deterministic reconciliation against the printed Total Portfolio Value. Per-security row extraction (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 reported as accountType in the Summary sheet so retirement and taxable accounts can be filtered separately.
What about Edward Jones 1099 Tax Statements?
DocuClipper rejects Consolidated 1099 Tax Statements at the brokerage extractor's detection layer 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 picks the right one based on which variant it detects, and both land in the Summary sheet's endingValue field for downstream consistency.
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.