Brokerage statement converter
Convert brokerage statements to Excel
Extract cash activity, dividends, interest, transfers and trades from brokerage statements (Fidelity, Schwab, Vanguard, Morgan Stanley and more) into Excel or CSV.
Last updated
Quick answer
Brokerage statements mix holdings, performance and activity. We extract the activity — deposits, withdrawals, dividends, interest, fees, buys and sells — as one row per transaction with dates and amounts, so you can reconcile cash and record income in your books.
How to do it
- 1
Upload the brokerage statement PDF.
- 2
Review the extracted cash and investment activity.
- 3
Download Excel or CSV.
What gets extracted
- Dividends and interest (including reinvested dividends)
- Deposits, withdrawals and transfers
- Buys and sells with the settlement amount
- Fees and margin interest
- Money market / sweep activity
What brokerage conversion is for
Bookkeepers use it to record investment income and reconcile the cash sweep; tax preparers use it to cross-check 1099 figures; forensic accountants use it to trace transfers between bank and investment accounts. For tax lots and cost basis, rely on your broker's realized gain/loss reports.
Works with statements from
Any bank or card issuer. Notes for popular institutions:
Frequently asked questions
Can it read holdings tables?
The converter focuses on transactions and cash activity. Holdings tables (positions and market values) are not exported.
Do brokerage statements reconcile like bank statements?
Market values change with prices, so we reconcile the cash/core position when the statement prints its opening and closing cash balances; otherwise the result is marked unverifiable rather than guessed.
Convert your first statement in under a minute
20 free pages every month. No credit card. Every export format included.