How to Convert Fidelity Statements to Excel

Quick Answer: To convert a Fidelity statement to Excel or CSV, download your PDF from the Fidelity portal's Statements section, then upload it to QuickBankConvert. QuickBankConvert parses the Fidelity PDF layout and delivers a clean spreadsheet with all transactions — buys, sells, dividends, and transfers — in seconds.

Fidelity Export Options Overview

Fidelity Investments is one of the largest and most feature-rich brokerage platforms in the United States, serving retail investors, retirement savers, and institutional clients. Fidelity offers a relatively strong set of data export tools compared to some competitors, but gaps remain for users who need comprehensive, archive-quality spreadsheet exports.

Here is what Fidelity currently offers:

• Activity & Orders CSV download: From the web platform, you can filter activity by date range, account, and transaction type, then download as CSV. This is useful for recent activity but has a rolling window limitation.
• Monthly and quarterly PDF statements: Fidelity generates formal PDF statements that are more complete than the activity CSV, especially for consolidated household statements.
• OFX/QFX export: Fidelity supports OFX/QFX export from the Account Activity page, useful for importing into Quicken or QuickBooks.
• Tax documents: Fidelity's 1099-B and 1099-DIV are available as PDFs and are authoritative for tax purposes, but not structured for spreadsheet analysis.

For users who need a complete, period-accurate transaction spreadsheet — particularly from formal PDF statements — QuickBankConvert provides the most reliable path.

How to Download a Fidelity Statement

From the Fidelity Web Portal

1. Log in at fidelity.com.
2. Navigate to Accounts & Trade → Portfolio or select a specific account.
3. Click Statements from the account menu (or go to Documents in the top navigation).
4. Under Account Statements, select the period you need.
5. Click the statement to download the PDF.
6. Save the PDF to your computer.

Using the Activity CSV Export (Alternative)

1. Navigate to Accounts & Trade → Activity & Orders.
2. Filter by account and date range.
3. Click the Download icon and select CSV.
4. This produces a transaction CSV that can be opened directly in Excel.

Note: The Activity CSV may not capture all transaction types (e.g., distributions from funds, certain corporate actions). When in doubt, use the official PDF statement as the source of truth.

Converting Fidelity Statements with QuickBankConvert

For PDF-based conversion:

1. Open [QuickBankConvert](/) in your browser.
2. Upload the Fidelity PDF: Drag the file onto the upload area.
3. Review the preview: Verify that trade dates, settlement dates, security names, and amounts are correctly extracted.
4. Choose your output: CSV for importing elsewhere; Excel for direct analysis.
5. Download: Click Export and save.

Processing is entirely local — no Fidelity data is sent to any external service.

Fidelity Statement Format Quirks

Multi-Account Household Statements

Fidelity often produces a single consolidated statement covering all accounts in a household (individual brokerage, Roth IRA, Traditional IRA, 529, CMA). The PDF has distinct sections for each account. QuickBankConvert extracts transactions from all sections — use the account identifier in the Description column to filter by account type.

Trade Date vs. Settlement Date

Fidelity statements may show both trade date and settlement date for each transaction. Review the Date column in the output — QuickBankConvert uses the primary date shown in the transaction table, which is typically trade date.

Cash Management Account (CMA) Transactions

Fidelity's Cash Management Account (a checking-equivalent brokerage feature) generates transactions like ATM withdrawals, debit card purchases, and bill payments mixed in with investment transactions. These will appear as standard rows in the converted output.

Dividend and Interest Income

Dividends, qualified dividends, interest income, and capital gain distributions each appear as separate rows with descriptive labels. For tax purposes, these classifications matter. Review and categorize them in your spreadsheet.

Option Transactions

Options (buy to open, sell to close, etc.) appear with full contract notation. They will be preserved as-is in the Description column.

Conversion Method Comparison

QuickBankConvert provides the most comprehensive extraction from Fidelity's PDF statement format.

Using Fidelity Data in Excel

Tax preparation: Combine Fidelity transaction data with your 1099-B and 1099-DIV to build a complete Schedule D worksheet. Use VLOOKUP to match sales to purchases for cost basis verification.

Portfolio analysis: Calculate your total invested amount, average cost basis per fund or stock, and unrealized gain/loss over time using SUMIF and pivot tables.

Retirement contribution tracking: For IRA accounts, maintain a spreadsheet tracking annual contributions against IRS limits. This is especially important for backdoor Roth conversions, which require documentation of after-tax contributions.

Dividend income tracking: Build a monthly dividend income tracker from converted statements. Use a pivot table to show income by security and by month — useful for income-focused investors and for tax planning.

Callout — For Fidelity Solo 401(k) or SEP IRA Holders: Self-employed investors using Fidelity for a Solo 401(k) or SEP IRA need careful contribution tracking. A spreadsheet of all contributions, withdrawals, and rollovers — built from converted PDF statements — provides the documentation trail your CPA needs at tax time.

Tips for Clean Fidelity Exports

• Use the period statement, not just the activity CSV: The formal PDF statement is more complete and authoritative than the activity export for certain transaction types.
• Download one account at a time: Consolidated household PDFs work, but single-account PDFs produce cleaner, more easily filtered output.
• Note trade vs. settlement dates: For tax purposes, the settlement date matters for determining the tax year of short-term trades near year-end. Verify which date column applies.
• Verify capital gain distribution rows: These can be easy to miss in a long statement. After conversion, search the Description column for "Capital Gain" to ensure all distributions are captured.

Callout — For Fidelity ZERO Fund Investors: If you invest primarily in Fidelity's ZERO expense ratio funds (FZROX, FZILX, etc.), your transaction history will be relatively simple — periodic purchases and dividend reinvestments. The converted spreadsheet will be clean and easy to work with for annual portfolio reviews.

Visit QuickBankConvert to convert your Fidelity statement to Excel today.