How to Read a Brokerage Statement: Holdings, Activity, Gains and Fees Explained

Brokerage statements pack a lot into a few pages: what you own, what it is worth, what you bought and sold, the income you received, the fees you paid and how much the account changed in value. Many investors look only at the ending value. Reading the rest takes a few minutes and tells you whether your investments are doing what you expect, whether you are paying more in fees than you thought, and what you will need at tax time.

This guide walks through each section of a typical brokerage statement, using US terminology where it differs but applying broadly to investment platforms in most countries. It also covers how to get statement data into a spreadsheet for analysis or accounting.

What a brokerage statement is

A brokerage statement is a periodic report from your broker or investment platform covering an investment account, such as a general investment account, an individual retirement account, a pension wrapper or an ISA. Statements are usually monthly when there is activity and at least quarterly otherwise. Brokers also issue separate trade confirmations for each trade and annual tax documents.

Unlike a bank statement, which tracks one balance of cash, a brokerage statement tracks many assets at once, each with its own quantity and price, plus a cash balance. That is why it has more sections.

Section 1: Account information

The first page shows the account holder, account number, account type, statement period and the broker's contact details. For joint, trust or business accounts, check the registration is correct. Many statements also show a financial adviser's details if one is assigned.

Section 2: Account summary or value overview

The summary reconciles the account's value from the beginning to the end of the period. A typical layout:

Line	Example
Beginning account value	84,250.00
Deposits and contributions	2,000.00
Withdrawals and distributions	-500.00
Dividends and interest	312.40
Fees and charges	-45.00
Change in market value	1,893.60
Ending account value	87,911.00

The arithmetic: 84,250.00 + 2,000.00 - 500.00 + 312.40 - 45.00 + 1,893.60 = 87,911.00.

Note that the change in account value (3,661.00 here) is not your investment return. About 1,500 of it, roughly two-fifths, came from your own deposit net of a withdrawal. The change in market value plus income minus fees (2,161.00) is closer to what the investments earned. Brokers often show a separate performance or rate of return figure calculated with methods that adjust for the timing of deposits; use that when comparing performance.

Section 3: Asset allocation

A chart or table showing how the account is split across asset classes: cash, equities, fixed income, funds, alternatives, sometimes by region or sector. Compare it with your intended allocation, and note whether cash is building up unintentionally, which often happens when dividends are not reinvested. Strong markets in one asset class can push the allocation away from your target over time, which is a common trigger for rebalancing.

Section 4: Holdings or positions

The holdings table lists everything the account owned at the end of the period:

Column	Meaning
Symbol / description	The investment's ticker and name
Quantity	Number of shares or units held
Price	Market price per unit at the statement date
Market value	Quantity multiplied by price
Cost basis	What you paid, including some purchase costs, adjusted for certain events
Unrealised gain or loss	Market value minus cost basis
Estimated annual income	Projected dividends or interest based on recent payments
Yield	Estimated annual income divided by market value

Cost basis

Cost basis is the most important figure for tax purposes. When you sell, your taxable gain or loss is generally the sale proceeds minus the cost basis. Basis is adjusted for events such as reinvested dividends (which add new purchases), stock splits (which change the number of shares but not total basis), return of capital distributions and certain corporate actions.

Some statements show basis for each purchase lot separately. That matters because when you sell part of a position, the lots you choose (or the broker's default method, such as first in, first out) determine the gain.

If basis shows as "not available" or "not covered", the broker may not have the purchase information, typically for older holdings or assets transferred from another broker. Keep your own records of what you paid; our guide to how long to keep bank and brokerage statements explains why these records need to be kept until well after you sell.

Unrealised vs realised gains

Unrealised gains and losses are paper changes on investments you still hold. They are not usually taxed until you sell. Realised gains and losses arise when you sell, and they appear in the activity section and on annual tax documents. In tax-advantaged accounts such as retirement accounts or ISAs, gains are generally not taxed in the same way, but the figures still show performance.

Section 5: Activity or transaction history

The activity section lists everything that happened during the period. Typical transaction types:

Type	What it means
Buy / purchase	Shares bought, with quantity, price, commission and total cost
Sell / sale	Shares sold, with proceeds; some statements show realised gain or loss
Dividend	Cash income from a stock or fund
Reinvested dividend	Dividend used to buy more shares automatically
Interest	Interest on cash balances or bonds
Capital gain distribution	Payout from a fund that realised gains internally
Deposit / contribution	Money added to the account
Withdrawal / distribution	Money taken out
Transfer in / out	Assets or cash moved between accounts or brokers
Fee	Account fees, advisory fees, transaction fees, foreign tax withheld
Corporate action	Splits, mergers, spin-offs, name changes
Sweep	Cash moved automatically into or out of a money market fund or bank deposit

Trade date vs settlement date

Trades show a trade date (when the order executed) and a settlement date (when cash and securities were exchanged). In the US, most stock trades settle one business day after the trade date. A trade made on the last day of a month can appear on the statement with a settlement date in the next month. Taxes generally follow the trade date for most sales, but check the rules for your country and situation.

Sweep activity

Many brokers sweep uninvested cash into a money market fund or bank deposit program. This can generate many small sweep entries. They are movements within the account, not income or expenses, and can be ignored when analysing cash flows, but the interest they earn is real income.

Section 6: Income summary

A summary of dividends, interest and distributions received during the period and year to date, sometimes split into taxable and tax-exempt categories, and qualified and non-qualified dividends in the US. These figures are estimates during the year; the annual tax documents are authoritative.

Section 7: Realised gains and losses

Some statements include a year-to-date summary of realised short-term and long-term gains and losses from sales. In the US, short-term generally means investments held for one year or less and long-term means more than one year, with different tax rates. Use these figures for planning, such as deciding whether to harvest losses before year-end, but rely on the annual tax forms for filing.

Section 8: Fees and costs

Fees can appear in several places: as separate fee transactions in the activity section, as commissions included in trade amounts, as advisory fees billed quarterly, or within funds as expense ratios that never appear on the statement because they are deducted inside the fund's price.

Add up visible fees for the year and compare them with the account value. An advisory fee of 1% a year on a 100,000 account is 1,000, every year, before fund expenses. Over long periods, fees have a large effect on outcomes, so they deserve attention.

Section 9: Margin and borrowing

If the account allows margin borrowing, the statement shows the margin balance, interest charged and maintenance requirements. A negative cash balance in a margin account is a loan from the broker. Watch margin interest carefully; it can be higher than other forms of borrowing.

Section 10: Disclosures

The final pages contain legal disclosures, including how prices are determined, information about investor protection schemes (such as SIPC coverage in the US, or the FSCS in the UK for eligible investment firms), how to report errors and the broker's contact information for complaints. Read them once for each broker you use.

Worked example: reading an activity section

Here is a simplified month of activity in a taxable account:

Trade date	Settle date	Type	Description	Quantity	Amount
02 Mar	02 Mar	Deposit	Transfer from bank		2,000.00
05 Mar	06 Mar	Buy	Broad market index fund	12.5	-1,503.75
14 Mar	14 Mar	Dividend	Dividend equity fund		142.10
14 Mar	14 Mar	Reinvest	Dividend equity fund	3.218	-142.10
20 Mar	21 Mar	Sell	Individual stock	-20	1,236.40
25 Mar	25 Mar	Withdrawal	Transfer to bank		-500.00
31 Mar	31 Mar	Fee	Quarterly advisory fee		-45.00
31 Mar	31 Mar	Interest	Cash sweep interest		3.42

What it tells you:

• Net external cash flow is 1,500.00 (deposit minus withdrawal). This is the money you added, not a return.
• The dividend of 142.10 is income, and because it was reinvested, it also bought 3.218 more units and increased cost basis by 142.10. In a taxable account, the dividend is generally taxable even though no cash reached you.
• The sale produced 1,236.40 of proceeds. The realised gain or loss depends on the cost basis of the 20 shares sold, which appears in the realised gains section or on the trade confirmation.
• Fees and interest are small but recurring; over a year the advisory fee alone is about 180.
• The cash balance changed by the sum of all amounts: 2,000.00 - 1,503.75 + 142.10 - 142.10 + 1,236.40 - 500.00 - 45.00 + 3.42 = 1,191.07.

Checking that the change in cash matches the statement's beginning and ending cash balances is a quick way to confirm you have read, or extracted, the activity correctly.

How statements differ by account type

• Taxable accounts report dividends, interest and realised gains for tax and show cost basis prominently.
• Retirement accounts focus on contributions, distributions and sometimes required withdrawals; gains are generally not taxed annually, so cost basis is less prominent, although records of after-tax contributions can matter.
• Tax-advantaged savings wrappers such as ISAs show subscriptions against annual allowances.
• Managed or advisory accounts show advisory fees and performance against benchmarks.
• Employer share plans show vesting, grants and shares sold to cover tax, which have their own basis rules.

What to check on every statement

1. Ending value and allocation are in line with expectations.
2. Every trade matches what you instructed, at the price and quantity on your trade confirmation.
3. Deposits and withdrawals match your bank statements. See the guide to reading a bank statement.
4. Dividends and interest arrived as expected.
5. Fees are what you agreed.
6. Cost basis is shown for holdings, and you have your own records where it is missing.
7. No unrecognised activity, especially withdrawals or transfers out. Report anything suspicious to the broker immediately.
8. Contact details and beneficiaries are current, particularly after a move, marriage or bereavement; statements are often the only regular reminder to check them.

Getting brokerage data into a spreadsheet

Investors, accountants and forensic analysts often need brokerage data in Excel: for portfolio analysis, for bookkeeping in a company that holds investments, for estate and divorce work, or for reconstructing cost basis.

What to extract

• Activity table for cash flows, income, fees and trades. This is what you need for accounting or tracing funds.
• Holdings table for positions, values and cost basis at period end. This is what you need for portfolio reviews and net worth statements.

Keep them as separate tables; they answer different questions. If you combine several accounts or brokers, add Account and Broker columns so each row can be traced back to its source statement, which is essential for estate, divorce and audit work.

How to extract it

• Broker downloads. Most brokers offer CSV exports of activity and positions for recent periods.
• PDF statements. For older periods, closed accounts or third-party statements, convert the PDF. Our brokerage statement to Excel converter handles activity and holdings tables, and our bank directory includes notes for brokers such as Fidelity, Charles Schwab, Vanguard, Morgan Stanley, Merrill, E*TRADE, Robinhood, Interactive Brokers, Edward Jones, Raymond James and Wells Fargo Advisors.

Verifying brokerage extractions

Brokerage statements do not usually print a running cash balance per row, so verification uses the summary instead: beginning cash plus all cash activity should equal ending cash, and the sum of holdings' market values plus cash should equal the ending account value. Check both.

Choosing a brokerage statement converter

If you convert brokerage statements regularly, look for:

• Separate extraction of activity and holdings tables.
• Correct handling of quantities with decimals (fractional shares, fund units).
• Recognition of transaction types (buy, sell, dividend, reinvestment, fee).
• Verification against summary totals.
• Excel and CSV exports with consistent columns across brokers.
• Strong security, as investment statements reveal net worth.

The broader buying criteria in our best bank statement converter guide apply here too.

Frequently asked questions

What is the difference between market value and cost basis?

Market value is what your holdings are worth at current prices. Cost basis is what you paid for them, adjusted for events like reinvested dividends and splits. The difference is your unrealised gain or loss.

Why did my account value go up even though the market fell?

Probably because you added money. The change in account value includes deposits and withdrawals. Look at the change in market value line, or the broker's performance figure, to see how the investments themselves performed.

What does "cost basis not available" mean?

The broker does not have purchase information for that holding, often because it was bought long ago or transferred from another broker. You will need your own records, such as old trade confirmations or statements, to calculate gains when you sell.

Are reinvested dividends taxable?

In taxable accounts, dividends are generally taxable in the year they are paid even if they are reinvested. Each reinvestment also adds to your cost basis. Tax rules vary by country and account type, so confirm with a tax adviser.

How long should I keep brokerage statements?

Keep records showing purchases until you sell the investment and the tax review period for that year has passed. Annual statements and tax forms should be kept for the standard review period. See how long to keep bank statements.

Can I convert a brokerage statement PDF to Excel?

Yes. Use a converter that understands brokerage layouts and extracts activity and holdings into separate tables, then verify totals against the statement summary. Our brokerage statement to Excel tool does this.

Summary

Read a brokerage statement from the top down: the summary tells you how the value changed and why, the holdings show what you own and what you paid, and the activity explains every movement. Separate your own deposits from investment performance, keep an eye on fees and keep cost basis records safe. When you need the data in a spreadsheet, convert your statements free and verify them against the summary totals.