How to Convert a Brokerage Statement to Excel: Schwab, Fidelity, Vanguard

You have a brokerage account (Schwab, Fidelity, Vanguard, or another). You need to convert the statement to Excel.

This page is the brokerage statement conversion guide. It covers the PDF download, the multiple sections, the realized gains report, the wash sale rule, the dividend reinvestment, and the conversion step-by-step. The details are below.

Brokerage statements are PDF, often with multiple sections. The transaction history is sometimes available as CSV. The realized gains report is a separate file, usually PDF. The tax form (1099-B) is a separate PDF, issued at the end of the tax year.

The PDF is the official document. The CSV is the raw transaction data. The conversion handles both. The challenge is the wash sale rule, the dividend reinvestment, and the cost basis adjustments.

PayPal statements have three columns most bank statements do not: Gross, Fee, Net. The conversion must preserve all three. Recording only the Net amount loses the fee data. Recording only the Gross amount overstates the revenue. The CSV handles all three. The PDF requires extra work to extract the fee structure.

Brokerage accounts are one of 5 non-bank sources covered in our other statements conversion guide, which maps the download flow for each. The conversion step is similar to a bank statement, with extra handling for gains, dividends, and wash sales.

What Brokerages Actually Give You

Brokerage statements are PDF, often with multiple sections. The exact sections depend on the brokerage, but the common sections are: Account Summary, Transaction History, Realized Gains/Losses, Dividend and Interest Income, Asset Allocation.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

The PDF is the official monthly document. The PDF is what the brokerage mails or makes available online. The format is consistent across brokerages but the layout differs. The PDF is 5 to 30 pages depending on the volume of transactions.

The CSV download is available for the Transaction History section. The CSV is downloadable from the brokerage account under “Reports” or “Tax Statements.” The CSV has the trade history: Date, Symbol, Action (Buy/Sell/Dividend), Quantity, Price, Commission, Amount.

The realized gains report is a separate PDF or CSV. The report has Date, Symbol, Proceeds, Cost Basis, Gain/Loss, Term (Short/Long). The report is the source of truth for the tax form (1099-B). The 1099-B is a separate PDF, issued at the end of the tax year.

Schwab vs Fidelity vs Vanguard

Schwab, Fidelity, and Vanguard are the 3 largest US brokerages. Each has its own statement format, its own CSV export, and its own tax form. The differences matter for the conversion.

Schwab is the largest brokerage by client assets. The PDF has the standard sections. The CSV is downloadable under “Reports” → “Transaction History.” The realized gains report is a separate PDF. The 1099-B is a PDF, issued in February for the prior tax year. Schwab has the cleanest export of the three.

Fidelity is the second largest. The PDF has the standard sections. The CSV is downloadable under “Accounts” → “History.” The realized gains report is a separate PDF. The 1099-B is a PDF, issued in February. Fidelity’s CSV has more columns than Schwab’s (Cost Basis, Term, Holding Period).

Vanguard is the third largest. The PDF has the standard sections. The CSV is downloadable under “My Accounts” → “History.” The realized gains report is a separate PDF. The 1099-B is a PDF, issued in February. Vanguard’s export is similar to Fidelity’s.

For most US-based brokerage users, Schwab is the default because of the clean export. Fidelity is a good alternative for more active traders. Vanguard is the choice for low-cost index fund investors.

The Wash Sale Rule and Cost Basis Adjustments

The wash sale rule is an IRS rule that disallows a loss on a sale of a security if you buy a substantially identical security within 30 days before or after the sale. The disallowed loss is added to the cost basis of the replacement security.

For example, you sell 100 shares of AAPL at a $1,000 loss. You buy 100 shares of AAPL 14 days later. The $1,000 loss is disallowed. The $1,000 is added to the cost basis of the new shares. When you sell the new shares, the $1,000 reduces the gain or increases the loss.

The brokerage tracks wash sales automatically. The realized gains report has a “Wash Sale” column or footnote. The disallowed loss is shown as a separate line item. The 1099-B summarizes the wash sales for the tax year.

For most brokerage users, the wash sale rule is a passive concern. The brokerage handles the tracking. The conversion just imports the realized gains report with the wash sales already accounted for.

Dividend reinvestment is another automatic feature. When a dividend is paid, the brokerage uses the dividend to buy more shares. The dividend is taxable income. The new shares have a cost basis equal to the dividend amount. The brokerage tracks the cost basis for the new shares. The conversion imports the reinvestment as two transactions: the dividend income and the share purchase.

How to Download a Brokerage Statement Step by Step

The PDF download is in the “Statements” section. The CSV download is in the “Activity” section. Here is the click-by-click flow for each.

The PDF download is in the “Statements” or “Documents” section. The CSV download is in the “Reports” or “History” section. Here is the click-by-click flow for Schwab, the most common US brokerage.

1. Log into Schwab with your Username and Password.
2. Click “Accounts” → “Statements” or “Documents.”
3. Select the statement month. The PDF downloads to your default downloads folder.
4. For the Transaction History CSV, click “Reports” → “Transaction History.” Set the date range. Click “Download CSV.”
5. For the Realized Gains report, click “Reports” → “Realized Gains.” Set the date range. Click “Download.”
6. Save the files to your computer.

For Fidelity, the click-by-click is similar. Click “Accounts” → “History” for the CSV. Click “Accounts” → “Tax Forms” for the 1099-B.

For Vanguard, click “My Accounts” → “History” for the CSV. Click “My Accounts” → “Tax Forms” for the 1099-B.

For most users, three files are needed: the Statement PDF, the Transaction History CSV, and the Realized Gains PDF. The 1099-B is issued in February and is the official tax form.

How to Convert Brokerage PDF to Excel

The brokerage PDF has multiple sections, which makes the conversion more complex than a bank statement. The converter needs to recognize the section breaks and extract the right tables from each section.

A good converter reads the brokerage PDF and produces multiple Excel sheets: Account Summary, Transaction History, Realized Gains, Dividends. Each sheet has the right columns for that section. The conversion takes 10 to 30 seconds per statement. The output is clean. You can open it in Excel and start working with the data immediately.

For the broader conversion workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check and the 3 things to do after every conversion. The brokerage-specific challenge is the multi-section structure. The validation check should include a sample transaction from each section to confirm the right columns were extracted.

Converting Brokerage CSV to Excel

The brokerage CSV is already in spreadsheet format. The conversion is mostly a rename. Open the CSV in Excel, save as XLSX, and add the Source and Category columns.

For most brokerage users, the conversion is 5 minutes: open the Transaction History CSV, save as XLSX; open the Realized Gains CSV (if separate), save as XLSX. Combine the two files in Excel. The combined file has the trade-by-trade detail and the gains summary.

For the broader conversion workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check and the 3 things to do after every conversion. The brokerage-specific challenge is matching the trade to the gain, which requires both files to be combined.

The 2am Test for Brokerage Conversions

If you are converting a brokerage statement at 2am because the tax deadline is tomorrow, here is the flow that works.

1. Log into Schwab (or your brokerage). Click “Accounts” → “Statements.”
2. Download the Statement PDF for the tax year.
3. Click “Reports” → “Transaction History.” Set the date range. Click “Download CSV.”
4. Click “Reports” → “Realized Gains.” Set the date range. Click “Download.”
5. Open the CSV in Excel. Save as XLSX.
6. Open the Realized Gains PDF in a converter. Save as XLSX.
7. Verify the first 5 transactions: Date, Symbol, Action, Quantity, Price. The Quantity times the Price should equal the trade value.
8. Add a “Source” column. Mark every row as “Schwab.” This helps with the consolidation across all sources.
9. Add a “Category” column. Mark each transaction as Buy, Sell, Dividend, or Transfer based on the Action column.

If the conversion produces a file where the Quantity times the Price does not equal the trade value, the conversion is wrong. Re-check the column alignment. The brokerage-specific challenge is matching the trade to the gain, which requires both files to be combined.

What to Do With Multiple Brokerage Accounts

If you have multiple brokerage accounts (Schwab, Fidelity, Vanguard, plus IRAs at each), each account has its own statement, its own download, and its own conversion. The workflow is similar for each: download the Statement PDF and the Transaction History CSV, convert to XLSX, add the Source and Category columns.

The challenge is matching the transactions across accounts. A transfer from a taxable account to an IRA is a transfer, not a sale. The cost basis has to be tracked. The fix: keep a separate log of transfers. Add the transfer as a line item in the consolidated file with a $0 gain.

For users managing many brokerage accounts, the combined approach is essential for tracking total dividends, interest, and realized gains for tax reporting. The CSVs have different column structures across brokerages (Schwab, Fidelity, Vanguard each have their own).

The fix: standardize the columns (Date, Symbol, Action, Quantity, Price, Commission) before combining. Add a “Brokerage” column to identify which brokerage each trade came from. Our batch conversion guide covers the desktop converter setup that handles 100+ statements efficiently.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

How Brokerage Statements Compare to Bank, PayPal, and Crypto Statements

Brokerage statements, crypto statements, PayPal statements, and bank statements are all similar in structure but differ in the columns. A bank statement has Date, Description, Amount. A PayPal statement has Date, Description, Gross, Fee, Net. A crypto statement has Date, Asset, Quantity, Price, Fee. A brokerage statement has Date, Symbol, Action, Quantity, Price, Commission.

For accounting purposes, each statement is a separate account. The bank statement shows what hit the bank account. The brokerage statement shows what happened in the brokerage. The two are linked by transfers (ACH from bank to brokerage, distributions from brokerage to bank), which appear on the relevant statements.

The transfer is a “Transfer” in the accounting category, not “Income,” “Expense,” or “Buy/Sell.” If you record a transfer as a sale, you create a taxable event. The fix: mark transfers as “Transfer” in the Category column. The bank statement and the brokerage statement both show transfers, and the totals should match when you exclude transfers.

Brokerage accounts are one of 5 non-bank sources covered in our other statements conversion guide, which maps the download flow for each. For a broader view across all US banking entities, our bank-statement-converter guide covers the major banks, credit cards, and credit unions in one map.

The conversion step is the same regardless of whether the statement comes from a bank, PayPal, or a crypto exchange. The differences are in the column structure and the category handling. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.