Fidelity Statement to Excel

Getting your Fidelity statements, including old ones

Fidelity says you can view up to 10 years of statements online. If you need something older — for an estate, an old cost-basis question, or a tax inquiry about a closed account — Fidelity can mail copies of old account statements to your address of record at no charge. You ask by email, giving the account number and the month and year of each statement you want.

Those mailed copies are paper. Scan or photograph them and upload the images: they go through the same reading as a PDF, with anything uncertain listed for you to check. A flat, evenly lit photo of each page, with the whole table in frame, reads far better than a skewed one.

When you write to Fidelity for old copies, list every month you need in one request rather than one at a time — the account number, then each month and year. For a whole tax year that is twelve lines for a monthly account, or four for a quarterly one.

Fidelity's website also offers account activity you can view and download from your account. Its date-range limits are not documented on a public Fidelity page we could find, and guides written by others disagree, so check the current limit in your own account rather than relying on a number here.

Statements or downloaded activity: which to use

If Fidelity's own activity download covers what you need, it is the cleanest source — it comes straight from Fidelity's records. Statements are the better choice in a few situations:

• The period is older than the online activity covers, but within the 10 years of statements.
• You need the holdings and valuation at a date, not just the transactions — that only exists on the statement.
• The account is closed, or you are working from someone else's paperwork, such as a client's or an estate's.
• You need the document itself as evidence, with the figures exactly as Fidelity printed them.

Retirement and taxable accounts side by side

Many people hold a taxable brokerage account and one or more retirement accounts at Fidelity. Each has its own statement and its own tax treatment, so keep them apart: convert each account's statements separately, or merge them with the account number visible on every Summary sheet. Mixing an IRA's activity into a taxable account's sheet is the quickest way to make a tax check meaningless.

A household's accounts in one place

Families often end up with a handful of Fidelity accounts — a joint brokerage account, an IRA each, a custodial account for a child. Bringing them into one workbook is useful for a net-worth view or a planning meeting, as long as each account stays identifiable.

Merge one account at a time, a year per workbook, and keep the account name or number in the file name. Then, for the overview, copy only the closing holdings from each workbook's last month onto a single summary sheet — a valuation at one date across all accounts — rather than stacking every account's activity together. The activity stays in its own account's workbook, where it means something. When the next year comes, the previous year's closing holdings are the opening point to compare against, so keep each year's summary sheet rather than overwriting it.

How a brokerage statement comes out in Excel

A brokerage statement is not one table but several: a summary, the positions you hold, what happened during the period, and often realised gains or an asset-allocation breakdown. Flattening all of that into one list would mix market values with cash movements. So each table keeps its own sheet and its own columns, named the way the statement names them.

Checking your 1099 against the statements

The year-end tax form is the document your return is built on, and it is usually right. When it is not, or when a figure on it surprises you, the monthly statements are where the answer is. A check that takes an evening:

• Convert every statement for the tax year — all twelve months, or all four quarters — and merge them so each table sits in one sheet across the year.
• On the activity sheet, filter to dividends and total them. Compare with the dividend total on the 1099. A gap is usually a dividend paid in January for the previous year, or one reclassified after year-end.
• Do the same for interest, and for sales: every sale on the 1099 should appear as a sale in the activity, on the same date and for the same proceeds.
• Look for activity with no counterpart on the form — a transfer between your own accounts, a reinvestment, a corporate action — and make sure you know why it is not there.
• Keep the workbook with the return. If a figure is questioned later, the line behind it is one filter away.

Three spreadsheet mistakes with brokerage data

Once brokerage statements are in Excel, the same three mistakes come up again and again. Each one produces numbers that look plausible and are wrong.

Adding up holdings across months. A holdings table is a snapshot: the value of everything at one date. Twelve monthly snapshots stacked in one sheet do not add up to anything — summing them counts the same shares twelve times. Use the last snapshot for a year-end value, and compare snapshots side by side rather than totalling them.

Counting reinvested dividends twice. When a dividend is reinvested, the statement usually shows two lines: the dividend coming in, and a purchase of shares with it. Both are real, but only the dividend is income. Totalling every positive line as income, or every purchase as new money invested, double-counts.

Treating transfers as gains or losses. Money moved from your bank, or between two accounts at the same broker, shows up as activity. It is not income and not a loss — it is the same money in a different place. Filter transfers out before you total anything that is supposed to mean performance or income.

What this does not do

Two limits are worth knowing before you upload. First, there is no QuickBooks, OFX or Xero file for a brokerage statement: those formats describe bank transactions, and a statement full of positions and trades does not map onto them honestly. You get Excel and CSV. Second, the figures are kept as the broker printed them — FlowParse does not compute cost basis, wash sales or tax lots for you. For a tax return, the broker's own 1099 remains the document of record; the converted statements are what you use to check it, analyse it, or hand the detail to an accountant.

It also does not value anything. Market values, prices and gains are whatever the broker printed on the statement date; nothing is refreshed with today's prices, converted between currencies or recalculated. If a figure on the sheet differs from what you see in the broker's app today, the statement is not wrong — it is a record of that date, which is exactly what makes it useful as evidence.