How To Convert a Raymond James Statement to Excel
Raymond James brokerage statements (Capital Access, Brokerage, and Advisory accounts) often combine multiple sub-accounts under one household cover. This guide shows how to convert that PDF into a clean Excel workbook with Holdings, Activity, and Summary on separate sheets.
Raymond James brokerage statements come in three product variants (Capital Access, traditional Brokerage, and Advisory accounts) that share a common layout: an Account Summary block with Beginning Balance and Ending Balance rows in a "This Statement / Year to Date" two-column format, followed by per-asset-class Holdings sections (Cash & Cash Alternatives, Equities, Mutual Funds, Exchange-Traded Products, Fixed Income, Alternative Investments, Annuities and Insurance, Options), each footed by a <Section> Total $X line. Combined household statements repeat this structure per sub-account, with each sub-account ending in a Portfolio Total $X line.
This guide walks through converting a Raymond James PDF into an Excel workbook with DocuClipper's brokerage statement converter. On the corpus we tested against, the Raymond James extractor reconciles 11 of 11 statements (100%), with the sum of section totals matching the sum of Portfolio Totals to within $1 across both single-account Capital Access statements and multi-account combined households.
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 a Raymond James statement
Each block of the Raymond James statement maps to its own Excel sheet:
| Raymond James section | Excel sheet | What's in it |
|---|---|---|
| Section Totals (per asset class, per sub-account) | Holdings | Cash & Cash Alternatives Total, Equities Total, Mutual Funds Total, Fixed Income Total, Options Total, Alternative Investments Total, Annuities and Insurance Total |
| Account Summary | Summary | Beginning Balance (this statement and YTD), Ending Balance (this statement and YTD), Portfolio Total per sub-account |
| Asset Allocation | Summary | US Equities, Non-US Equities, Fixed Income, Real Estate & Tangibles, Alternative Investments, Cash & Cash Alternatives (with percent weightings) |
| Income Detail | Income | Total income for the period |
Combined household statements that include multiple sub-accounts (e.g. a joint Capital Access + Roth IRA + Traditional IRA) are split per sub-account in the Holdings sheet, with each row tagged by sub-account index so you can pivot or filter by account in Excel.
What's specific about Raymond James statements
Capital Access vs traditional Brokerage vs Advisory. Capital Access is the "premier" cash-management platform, traditional Brokerage is the standard self-directed account, and Advisory is the fee-based managed-account variant. All three carry "Raymond James" branding and use the same Account Summary + per-section Total structure. DocuClipper reports the variant in the Summary sheet (statementVariant=classic for newer Capital Access layouts with a "Closing Value" header, statementVariant=premium for older "Value This Statement" layouts).
Two account-number formats. Older statements use Account # NNNNNNNN, newer ones use Account No. NNNNNNNN. Both are extracted into the Summary sheet as accountNumber.
Three statement period layouts. Period text on the cover varies between December 29, 2023 to December 31, 2024, May 30 to June 30, 2025 (cross-month), and July 31 to August 29, 2025 (same year, abbreviated). DocuClipper handles all three and normalizes them to ISO YYYY-MM-DD dates for the Summary sheet.
Multi-account combined statements. A single Raymond James PDF can cover multiple sub-accounts (Capital Access combined household). Each sub-account ends in a Portfolio Total $X line. DocuClipper partitions section totals by sub-account boundary so the per-account aggregates roll up correctly to each Portfolio Total, and the household total is the sum across sub-accounts.
Tax forms are rejected at the front door. Raymond James 1099 Composite forms carry the same branding as monthly statements but have no Holdings sections. DocuClipper's detection layer rejects them so they don't get conflated with brokerage statements.
Step-by-step: converting a Raymond James statement to Excel
- Open DocuClipper and click the Brokerage Statement upload card on the Tools page.
- Drop your Raymond James PDF onto the upload area. Both digital downloads from the Client Access portal and scanned/photographed mailed copies work.
- Wait for extraction. A typical monthly Raymond James statement processes in under a minute. Combined household statements with 4-5 sub-accounts may take slightly longer.
- Review the Holdings sheet. Each non-zero
<Section> Totalrow is one row in the sheet, with a sub-account label so multi-account households are easy to filter. - 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 Raymond James extractor works under the hood
DocuClipper uses pdftotext with -layout to preserve column alignment, then runs three parallel passes over the text:
- Find every
Portfolio Total $Xmarker and record its byte offset. These are the sub-account boundaries. - Find every
<Section> Total $Xmarker (Cash & Cash Alternatives, Equities, Mutual Funds, etc.) and record its byte offset. - Bucket section totals by sub-account window. Within each window (between two Portfolio Total markers), de-dup section labels by taking the last occurrence (continuation pages can repeat per-page subtotals; the final per-account total appears closest to the Portfolio Total and is authoritative).
The reconciliation gate is the per-sub-account check: the sum of section totals inside a window must match that window's Portfolio Total within $1. If it does, individual section totals become Holdings rows. If it doesn't, DocuClipper falls back to a single aggregate position per sub-account so the document still reconciles trivially against the household total.
Frequently asked questions
Does this work with Raymond James Capital Access combined statements?
Yes. Combined household statements that include multiple sub-accounts (joint, IRA, trust) extract with each sub-account's Holdings rows tagged separately. The Summary sheet's endingValue is the sum of all Portfolio Totals across the household.
Will it pull individual security positions or just per-section aggregates?
The current Raymond James extractor uses per-asset-class section totals (Equities Total, Mutual Funds Total, Fixed Income Total, etc.) as Holdings rows. That gives a deterministic reconciliation against the printed Portfolio Total. Per-security row extraction with symbol, CUSIP, quantity, and per-position market value is on the roadmap; for that level of detail today, contact us.
What about Raymond James 1099 Composite forms?
DocuClipper rejects 1099 Composite tax forms at the brokerage extractor's detection layer because they carry the same branding but have no Holdings sections. Tax-form extraction is a separate workflow handled by the tax form data extraction product.
Does it handle Raymond James Advisory accounts (fee-based managed)?
Yes. Advisory accounts use the same Account Summary + per-section Total layout as Capital Access and traditional Brokerage. The account type lands in the Summary sheet as accountType=advisor_managed so they can be filtered separately from self-directed accounts in batch conversions.
Can I convert multiple months of Raymond James statements at once?
Yes. Upload a year of monthly Raymond James PDFs and DocuClipper produces one workbook per statement, or merges them into an annual workbook for portfolio-review and tax-prep work. Each statement carries its own period start/end so the month-over-month series is unambiguous.
What if my statement period is "May 30 to June 30, 2025" (cross-month)?
That's a common Raymond James period format. DocuClipper parses both same-year cross-month formats (May 30 to June 30, 2025) and full-date formats (December 29, 2023 to December 31, 2024) and normalizes to ISO dates.
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 an Edward Jones 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.