To move a brokerage statement to Excel, treat it as two documents in one PDF: a holdings table showing what you own at month end, and an activity list of buys, sells, dividends, fees and cash movements. Put each on its own sheet, store quantities and prices as full-precision numbers, and check that holdings plus cash equal the summary value.
Holdings and activity: the two tables in a brokerage statement
A brokerage statement carries two different kinds of table. The holdings table is a snapshot: one row per security on the closing date. The activity table is a log: one row per event during the period. They have different columns and answer different questions, so they belong on separate sheets in Excel.
What the holdings table holds
A typical holdings section lists, for each position, the security name, a ticker or CUSIP, the quantity held, the closing price, the market value, and often a cost basis and an unrealized gain or loss. Many firms group positions under headings such as Equities, Mutual Funds, Fixed Income and Cash and Sweep. Those group headings are labels, not positions. When they come across as rows with no quantity, move the label into a Category column on each position and delete the heading row.
What the activity table holds
The activity section records what happened: trade date, settlement date in some layouts, a transaction type such as Bought, Sold, Dividend or Fee, the security, quantity, price and net amount. Some firms split activity into blocks such as Trades, Income and Cash Transfers. Stack those blocks into one sheet and keep the block name in its own column, so a filter can bring any of them back.
Pages that are neither
Statements also carry pages that are not tables: disclosures, a margin notice, a message from the firm, a performance chart. Skip them. If your extraction tool lets you choose pages, pick only the holdings and activity pages before you convert. If you are copying by hand, copying a PDF table into Excel without breaking the columns covers how to paste one table at a time and keep its structure.
How do you keep share quantities and prices exact in Excel?
Keep share quantities and prices exact by importing them as numbers with every printed decimal and never rounding the stored value. Fractional shares often print to four or more decimals, and some fund prices do too. Format the cells to show those places, and do any rounding only in a separate display column.
Where precision gets lost
Three things trim decimals without telling you. First, a converter that reads 12.3456 as text and a later "convert to number" step that uses the cell's display format. Second, a CSV opened directly in Excel, where the default General format can show fewer places than the file holds. Third, copying from a PDF viewer that renders 0.004512 as 0.0045 on screen. The stored number in the sheet is what your formulas use, so check it in the formula bar, not the cell.
Quantity times price
Market value on the statement is quantity times closing price, rounded to the cent. Rebuild it in a helper column and compare. A difference of a cent or two is rounding. A larger difference usually means a quantity lost decimals, or a price was read from the wrong row. For a mutual fund with 213.4471 shares at a price of 48.29, the product should land within a cent of the printed value.
CUSIPs and tickers as text
A CUSIP is nine characters and can start with a zero, and some contain letters that Excel might read as scientific notation, such as 12E45. Format the identifier column as Text before you paste or import, so 037833100 does not become 37833100.
Dividends, interest and reinvestment lines on a brokerage statement
Dividends and interest on a brokerage statement are cash income, and a reinvested dividend is two events: income credited, then a purchase of more shares with that cash. Record both rows. If you keep only the purchase, your income total is too low; if you keep only the income, your share count will not match the holdings table.
Reading a reinvestment pair
Firms print reinvestment in different ways. Some show a Dividend line for 18.40 followed by a Reinvestment line buying 0.3812 shares for 18.40. Others print one combined line with both amounts. When it is one line, split it into two rows in Excel, one with type Dividend and a positive cash amount, one with type Buy and a negative cash amount, so cash nets to zero and shares go up.
Qualified, ordinary and foreign tax
Some statements label each dividend as qualified or ordinary, and some show foreign tax withheld on a separate line. Keep those labels as a column. The final classification for tax purposes comes from your year-end tax form, not the monthly statement, so treat the monthly label as provisional.
Interest on cash
Interest on the cash or sweep balance usually appears once a month as a small credit. It is income like a dividend, but it has no security attached. Leave the security column empty for it rather than typing the sweep fund's name, or a pivot table will count it as a position.
Brokerage fees, commissions and sweep transfers
Fees and sweep transfers belong in the activity sheet as their own transaction types. A commission can sit inside a trade's net amount or appear as a separate line, an account fee is a standalone debit, and a sweep transfer moves cash between the core account and a money market fund without changing what you are worth.
Commissions inside a trade
When a trade line shows quantity, price, commission and net amount, keep all four. Net amount for a buy is quantity times price plus commission. For a sell it is quantity times price minus commission and any regulatory fee. Rebuild the net amount in a helper column. If it does not match, a fee column was merged into another one during extraction.
Account and advisory fees
Annual account fees, advisory fees and transfer fees appear as debits with no security. Give them a Fee type. If you track performance, keep them out of the trade rows, because a fee reduces returns without changing any position.
Sweep lines are not income
A cash sweep moves uninvested cash into a bank deposit program or money market fund each day. The statement may print dozens of small Sweep In and Sweep Out lines. They net to nothing in terms of value. Keep them in a separate block, or filter them out of income and spending totals, or they will swamp the activity sheet.
Money moving in and out
Deposits and withdrawals between your bank and the brokerage account are cash transfers, not income or losses. If you pull the same money's trail from another account, for example a payment app, the PayPal statement to Excel guide and the Venmo statement to Excel guide cover how those exports show transfers, so the two sides can be matched.
Does the holdings value tie to the brokerage account summary?
The holdings sheet should tie to the account summary on page one: the sum of every position's market value plus the cash balance equals the ending account value. If it does, no position was dropped. If it is off, the gap usually equals one missing row, or one row read twice.
The worked example
The figures below are sample values for a made-up account, used to show the checks.
Holdings sheet:
| Security | Category | Quantity | Price | Market value |
|---|---|---|---|---|
| Example Index Fund | Mutual Funds | 213.4471 | 48.29 | 10,307.36 |
| Sample Corp | Equities | 40 | 112.15 | 4,486.00 |
| Demo Utilities Inc | Equities | 15.2836 | 61.08 | 933.52 |
| Cash and sweep | Cash | 1,204.18 |
Activity sheet for the same month:
| Date | Type | Security | Quantity | Amount |
|---|---|---|---|---|
| 2026-03-03 | Deposit | 500.00 | ||
| 2026-03-10 | Buy | Sample Corp | 4 | -448.60 |
| 2026-03-15 | Dividend | Demo Utilities Inc | 14.21 | |
| 2026-03-15 | Buy | Demo Utilities Inc | 0.2327 | -14.21 |
| 2026-03-31 | Fee | -10.00 |
Running the checks
- Sum the market value column: 10,307.36 + 4,486.00 + 933.52 + 1,204.18 = 16,931.06. Compare it with the ending value on the summary page.
- Rebuild each market value as quantity times price and compare with the printed figure.
- Sum the activity amounts by type and compare with any period totals the statement prints, such as total dividends or total fees.
- Take last month's quantity for each security, add buys, subtract sells, and compare with this month's quantity.
The fourth check is the one that catches a dropped reinvestment line, because the share count drifts by a small fraction while the dollar totals still look reasonable.
Market movement is not an error
Ending value minus beginning value will not equal net activity, because prices moved. The summary page usually shows a change-in-value line that accounts for that. Tie to that line, not to the activity sum alone.
When a brokerage statement is the wrong source for cost basis
A monthly brokerage statement is the wrong source when you need final cost basis, realized gains or tax figures. The statement shows a snapshot that the firm may adjust later for wash sales, corporate actions or corrected basis. For taxes, use the year-end tax documents; for the exact terms of a single trade, use its confirmation.
Trade confirmations
Each trade normally produces its own confirmation with the execution price, time, commission and settlement date. When a statement shows a trade with an averaged price or a missing fee, the confirmation is the record to trust. The trade confirmation PDF to Excel guide covers pulling those fields into rows you can match to the statement.
Corporate actions
Stock splits, mergers and spin-offs change quantities and basis in ways the monthly statement can show awkwardly, sometimes as a removal of one security and an addition of another with no cash. Do not treat those as a sale and a buy. Mark them with a Corporate Action type and look up the firm's notice for the ratio.
A mistake to avoid: adding months together
Stacking twelve holdings sheets and summing market value gives a meaningless number, because each month counts the same shares again. Stack activity sheets across months, since each event happens once. For holdings, keep one sheet per month-end, or a long table with a Month column, and only compare across months.
What this blog's tool covers
FastBankConvert is built for bank statements: checking, savings and card PDFs turned into Excel, CSV or JSON, with a warning when the balances do not add up. It is not built around brokerage layouts, and it is not open yet. If bank statements are part of the same job, you can get on the list from the get-started page.