Tax guide
Brokerage statements to Excel: dividends, trades, withholding taxes
Published on · By StatementScribe · 7 min read
What to know first
Brokerage statements include trades, dividends, interest, and withholding taxes. Here's how to organize them in Excel.
- Start from the original bank PDF and validate period plus balances.
- Convert to Excel or CSV before reconciliation, categorization, or audit support work.
- Use bank guides or the sample-output page when your process depends on one specific format.
Brokerage statements include trades, dividends, interest, and withholding taxes—each with different tax implications. Converting to Excel helps organize 1099 data and track cost basis.
This content is informational only and does not constitute legal, tax, or financial advice.
Brokerage transaction types
- Trades: Buy/sell transactions with cost basis and proceeds
- Dividends: Qualified vs non-qualified, with tax withholding
- Interest: Bond interest, money market interest
- Withholding taxes: Federal and state tax withheld on distributions
- Fees: Trading commissions, account maintenance fees
Reconciliation workflow
- Convert the statement PDF to Excel, preserving all transaction details.
- Separate income items (dividends, interest) from capital transactions (trades).
- Match dividend and interest amounts to 1099 forms for tax reporting.
- Track cost basis for sold securities to calculate capital gains/losses.
Tax preparation tips
- Keep a separate column for qualified vs non-qualified dividends (different tax rates).
- Document cost basis method (FIFO, specific identification, average cost) for each sale.
- Flag wash sale adjustments that may affect capital gains calculations.
- Verify withholding amounts match 1099-B and 1099-DIV forms.
Convert your next statement in under 1 minute
Create a free account, get 10 pages free, and speed up month-end reconciliation.