Fidelity's 90-Day CSV Limit Breaks Tax Season. Here's the Fix.

Fidelity Investments is one of the largest financial services firms in the world, with more than 50 million individual customers and tens of trillions of dollars under administration. A huge share of those customers use Fidelity not just for brokerage and retirement accounts but also the Fidelity Cash Management Account (CMA) as a primary checking replacement - which means Fidelity statements often need to end up in Quicken, QuickBooks, or a tax spreadsheet, and the built-in exports almost never do the job cleanly. This guide covers every method for converting Fidelity PDF statements into CSV, Excel, or QBO, whether you are reconciling a CMA, categorising dividends in a brokerage account, or pulling contribution history out of an IRA.

Can You Download CSV Directly from Fidelity?

Partially, and the limitations catch most people off guard. On the Fidelity website, the Activity & Orders screen lets you download a CSV of recent transactions, but this export is not the same as a monthly statement, and several restrictions make it inadequate for serious accounting work.

• 90-day cap: Many Fidelity account types limit the activity CSV download to a rolling 90 days. If you need a full year for taxes, you are out of luck with the built-in export alone.
• Column layout varies: The CSV columns differ between brokerage, CMA, IRA, and 401(k) exports, which breaks Quicken and QuickBooks rules that expect a consistent schema. Users in Quicken community forums repeatedly flag Fidelity CSVs as "not directly readable" without manual cleanup.
• No CSV from the register view for some accounts: Certain IRA and retirement register views offer only a print-to-PDF option with no equivalent "Export to Excel" button, forcing users to convert the PDF after the fact.
• Activity export is not the statement: The CSV is a live transaction feed, not the official monthly or quarterly statement. Running balances, cost basis figures, and consolidated summaries only appear on the PDF.

The official monthly (for CMA and brokerage) and quarterly (for IRA and 401(k)) statements are always PDFs, and Fidelity keeps up to 10 years of them in the Documents section. For tax prep, audits, mortgage applications, or multi-year reconciliations, those PDFs are where the real data lives, and a converter is the fastest way to get them into a spreadsheet.

Fidelity Statement Formats and Quirks

Fidelity produces very different statement layouts depending on the account type. Knowing the differences up front makes the converted output far cleaner.

Why this matters for your export: Fidelity brokerage statements split activity into separate sections for purchases, sales, dividends, interest, corporate actions, and deposits. If you just copy-paste from the PDF, those sections get flattened into one column and you lose the tax-critical distinction between a long-term capital gain and a dividend. CapyParse detects each section heading and tags every row with its transaction type (for example, Dividend, Buy, Sell, Interest Income) so the output is ready for Schedule B, Schedule D, or QuickBooks categorisation.

Cash Management versus brokerage layout: The Fidelity CMA uses a checking-style layout with a running balance, while brokerage statements do not. CapyParse recognises both and applies the right column set automatically so you do not end up with blank balance columns on a brokerage export.

Convert Fidelity PDF to CSV with CapyParse (Step-by-Step)

Here is how to turn any Fidelity PDF statement into a clean CSV, Excel, or QBO file in under a minute.

Fidelity Brokerage, CMA, and Retirement Accounts

CapyParse handles every Fidelity statement type, not just the Cash Management Account. Here is what to expect with each product.

Fidelity Cash Management (CMA)

The Fidelity CMA is used by millions of customers as a primary checking replacement, which means its statements need to look like bank statements for Quicken and QuickBooks to reconcile properly. CapyParse extracts deposits, withdrawals, debit card purchases, ATM activity, bill pays, check payments, and interest into a single flat transaction list with a running balance, just like a traditional checking export. Debit card descriptions are preserved in full so you can categorise merchant spend without losing memo detail.

Brokerage Accounts

Fidelity brokerage statements include individual taxable accounts, joint accounts, and margin accounts. CapyParse parses each section (Purchases, Sales, Dividends, Interest, Corporate Actions, Other Activity) and tags every row with the correct transaction type. For tax prep, this means long-term and short-term gains, qualified and ordinary dividends, and tax-exempt interest all land in clearly labelled columns rather than a single mixed amount column.

IRA, 401(k), and HSA

Fidelity Roth IRA, Traditional IRA, SEP IRA, 401(k), and HSA quarterly statements use their own format with dedicated sections for contributions, distributions, dividends, and interest. CapyParse extracts each contribution source (employee pre-tax, employer match, Roth, catch-up) as a labelled row so you can reconcile against payroll without manual sorting. This is especially useful for tracking year-to-date contribution limits.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Fidelity statement as a QBO file from CapyParse and import it directly into QuickBooks via Banking > Upload transactions. For CMA statements this is a clean drop-in because the layout matches a standard checking account, and for brokerage statements the QBO preserves section tags. For a full walkthrough of bank imports, see our guide on importing bank statement CSVs into QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. For brokerage and retirement accounts, the Excel export places each statement section on its own sheet, which makes it trivial to build pivot tables for dividend income, net contributions, or cost basis. Running balances are preserved on CMA exports so you can reconcile month by month.

Already have a QBO or OFX file from Fidelity? See our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for Fidelity Conversions

Frequently Asked Questions

Related Articles