How To Convert a Fidelity Brokerage Statement to Excel
Fidelity brokerage statements pack holdings, activity, dividends, and account summary into a single PDF. This guide shows how to turn them into a clean Excel workbook with one sheet per block, no manual keying.
Fidelity statements are dense. A single monthly statement can run 20+ pages and combine taxable brokerage, retirement accounts (IRA, Roth, 401(k)), and Cash Management Account activity in one document. Each account has its own Holdings, Activity, and Income blocks.
Manually copying that into Excel is hours of work and error-prone. This walkthrough shows how to convert a Fidelity brokerage PDF into a structured Excel workbook with DocuClipper's brokerage statement converter, in under a minute.
While you are here
Extract holdings and activity from any broker PDF
Upload a brokerage statement from Fidelity, Schwab, Vanguard, Merrill, E*TRADE, or Robinhood and DocuClipper returns structured tables (positions, buys/sells, dividends) ready to export.
What gets extracted from a Fidelity statement
Fidelity organizes brokerage activity into a handful of consistent blocks. DocuClipper maps each one to its own Excel sheet:
| Fidelity statement section | Excel sheet | Key columns |
|---|---|---|
| Holdings (per account) | Holdings | symbol, security_name, quantity, price, cost_basis, market_value, unrealized_gain_loss, asset_class |
| Activity | Activity | date, type (buy/sell/dividend/interest/transfer), symbol, description, quantity, price, amount |
| Investment Income | Income | date, symbol, income_type (dividend / interest / capital gain), amount |
| Account Summary | Summary | period_start, period_end, starting_value, ending_value, net_change, deposits, withdrawals |
Multi-account statements (e.g. a household statement covering joint brokerage + two IRAs) are split per account in each sheet, with an account_number column so you can pivot or filter by account.
Step 1: Upload the Fidelity PDF
Drop the Fidelity statement onto the upload widget. Both digital downloads from Fidelity.com and scanned/photographed copies of mailed statements work, DocuClipper runs OCR on image PDFs before extraction.
If the statement is password-protected, enter the password (usually the last 4 of your SSN for mailed copies) when prompted.
Step 2: Review the extracted tables
DocuClipper opens a side-by-side view: the original PDF on the left, the extracted tables on the right. Walk the Holdings sheet first, every row should tie back to a position on the Holdings page of the statement. Then check Activity, where buys, sells, dividends, and any transfers between accounts are listed in date order.
For multi-account households, use the account filter to view a single account at a time.
Step 3: Confirm reconciliation
Each account's Summary row carries a reconciled flag. DocuClipper sums the Activity rows for the period (deposits + dividends + interest – withdrawals + change in market value) and compares to the printed ending balance. If the figures match, the row is marked reconciled. If not, the discrepancy is highlighted so you can investigate before exporting.
Put it into practice
Manually copying brokerage data creates reconciliation errors
Cost basis, market value, realized gains: these numbers compound errors when retyped. DocuClipper extracts them directly from the statement so holdings and activity tie out the first time.
Step 4: Export the Excel workbook
Click Export → Excel to download an .xlsx workbook with up to four sheets (Holdings, Activity, Income, Summary). Empty sheets are omitted, for example, an account with no income that period won't have an Income tab.
If you prefer flat files, each sheet is also available as a separate CSV download. JSON is available for programmatic workflows via the DocuClipper API.
Common Fidelity edge cases
- Cash Management Account (CMA) lines: these blend banking and brokerage. CMA debits and credits land in the Activity sheet as type
cma_debit/cma_creditso you can filter them out of trading-only views. - Mutual fund "Reinvested Dividend" lines: these appear as both an Income row (the dividend) and an Activity row (the reinvested purchase), matching how Fidelity prints them.
- Margin interest and fees: extracted into Activity with type
interest_chargeorfeeso they don't get conflated with investment income. - Combined household statements: every row carries the source account number, so you can split into per-account workbooks if you need to share with a client.
Frequently asked questions
Does this work with old paper Fidelity statements?
Yes. Mailed statements and scanned copies are extracted via OCR. Image quality matters at the margins (dim or skewed scans extract less cleanly), but a flat scan or sharp phone photo works.
Will it pull cost basis from the Holdings page?
Yes, when the statement prints cost basis on the Holdings page (typical for taxable brokerage accounts). Retirement accounts often omit cost basis, in which case the column is blank.
Can I batch a year of monthly statements?
Yes. Upload twelve monthly Fidelity PDFs in one batch and DocuClipper produces one workbook per statement, or you can merge them into an annual workbook for portfolio-review work.
What about a 1099-B?
Different document. The brokerage statement is the monthly/quarterly account statement (holdings + activity). The 1099-B is a year-end tax form covering realized sales. DocuClipper currently extracts the brokerage statement; 1099-B import is a separate workflow we don't yet provide.
What if my account is at Fidelity Charitable or Fidelity Personal Trust?
Those use slightly different statement templates. Auto-detection covers the standard Fidelity brokerage and IRA formats today; less-common Fidelity entities may fall back to a generic extraction. If you hit one, contact us and we'll add the template.
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 Fidelity Cash Management Statement to Excel
- How to Convert a Vanguard Brokerage Statement to Excel
- How to Convert a Merrill Lynch Statement to Excel
- How to Convert an E*TRADE Statement to Excel
- How to Convert a Robinhood Statement to Excel
- How to Convert an Interactive Brokers Statement to Excel
Next step
Convert your brokerage statement: free 14-day trial
Upload any PDF brokerage statement and download Holdings, Activity, and Income in a clean Excel workbook. No credit card required.