Document Guide

Convert Raymond James Statements to Excel

Upload your Raymond James advisory PDF — including held-away asset summaries and fee detail — and get a structured Excel or CSV file back in minutes.

Raymond James fee-based advisory statements mix custodied holdings, held-away asset summaries, and multi-tier advisory fee schedules across pages, which makes them harder to parse than a standard discount-brokerage layout. This tool reads the PDF (digital or scanned) and extracts holdings, account values, and fee detail into a row-per-item Excel or CSV file, so you can reconcile portfolios or build a net-worth tracker without retyping every line.

Who This Is For

  • Financial advisors reconciling client account values across quarters
  • RIAs and compliance staff tracking held-away assets alongside custodied holdings
  • Family office bookkeepers consolidating multiple Raymond James accounts into one tracker
  • Individual investors who want their statement data in a spreadsheet for tax or net-worth tracking

When This Is Relevant

  • Quarterly statement season when you need to update a household net-worth or AUM tracker
  • Tax season, reconciling realized gain/loss detail against 1099 forms
  • Compliance reviews requiring a consolidated view of held-away assets (401k, outside annuities) alongside custodied accounts
  • Auditing advisory fee calculations across multiple accounts with different fee schedules

Supported Inputs

  • Digital PDF exports of Raymond James advisory statements
  • Scanned PDF copies of mailed statements
  • PNG or JPEG photos of printed statement pages

Expected Outputs

  • Excel (.xlsx) workbook with one row per holding or transaction
  • CSV file structured for import into portfolio tracking or accounting tools

Common Challenges

  • Held-away asset summaries are listed separately from custodied holdings on the same statement, which can cause double-counting in a net-worth total if the section isn't flagged as a distinct field
  • Consolidated statements covering several account numbers put subtotals mid-page, so extraction can merge rows across accounts unless account number is set as a segmentation field
  • Advisory fee detail (annualized rate, billing period, fee basis) sometimes spans a separate page from the account summary, breaking the link between fee and account if pages are processed independently
  • Older mailed statements that were scanned or faxed can have skewed pages, which shifts column alignment for values like Beginning Value and Ending Value

How It Works

  1. Upload your Raymond James statement PDF (or a photo/scan of it) to pdfexcel.ai
  2. The AI identifies fields such as Account Number, Beginning Value, Ending Value, Net Additions/Withdrawals, and Held Away Assets Summary
  3. Review and customize which fields to extract — useful if you only want custodied holdings, or only the fee detail table
  4. Export the result as an Excel or CSV file, with one row per holding, transaction, or account line

Why PDFexcel.ai

  • Handles the fee-based advisory layout Raymond James uses, including sections for held-away assets that discount-brokerage statement layouts don't have
  • Custom field selection lets you isolate held-away asset summaries from custodied holdings so totals don't overlap
  • Batch processing handles multiple quarters or multiple household accounts in one run instead of one file at a time
  • OCR support means older scanned or photographed statements can still be converted, not just digital exports

Limitations

  • Multi-page nested tables, such as asset allocation broken out by class within each account, may need manual review after export
  • Handwritten notes or annotations added to a printed statement are not reliably captured
  • Statements with non-standard combined household layouts (multiple owners, mixed entity types) may require field customization to separate accounts correctly
  • Heavily redacted account numbers or values will show as missing fields rather than guessed values

Example Use Cases

  • An RIA compiling a compliance report exports held-away asset summaries from several client Raymond James statements into one Excel sheet
  • A family office consolidates quarterly account values from multiple Raymond James accounts into a running net-worth spreadsheet
  • An advisor pulls realized gain/loss detail from a client's annual statement to cross-check against year-end 1099 figures
  • A bookkeeper exports advisory fee detail from quarterly statements to verify fee calculations before importing into a billing tracker

Frequently Asked Questions

Can this extract the held-away assets section separately from my Raymond James custodied holdings?

Yes, you can select Held Away Assets Summary as its own field during extraction so it stays separate from custodied holdings, which helps avoid double-counting in a net-worth calculation.

Does it work on scanned or mailed paper copies of Raymond James statements, not just the digital PDF download?

Yes, OCR is used for scanned PDFs and photos of printed statements. Accuracy depends on how straight and legible the scan is — a skewed or blurry photo may misalign columns like Beginning Value and Ending Value.

What happens with a consolidated statement covering multiple account numbers?

The tool can use Account Number as a segmentation field so subtotals for each account aren't merged into one row, but this depends on account numbers being clearly printed and legible in the source PDF.

Will the advisory fee detail (fee rate, billing period) be linked to the correct account?

It extracts fee detail fields where they appear on the statement, but if the fee table is on a separate page from the account summary, you may want to verify the account-to-fee mapping manually for complex multi-account households.

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