Turn a TD Ameritrade PDF statement into a clean Excel (XLSX) or CSV file in seconds. Trades, options, dividends, interest, and cash activity land in labeled columns with recalculated running balances, ready for cost basis, tax history, and reconciliation.
Works with brokerage and retirement statements, including historical pre-2023 TD Ameritrade PDFs. Digital or scanned PDF.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Last updated July 2026
BankXLSX converts a TD Ameritrade PDF statement into a structured Excel (XLSX) or CSV file, separating trades, options, dividends, interest, and cash activity into labeled columns with recalculated running balances. TD Ameritrade accounts moved to Charles Schwab in 2023, but up to 10 years of TD Ameritrade statements and tax documents remain the record for pre-2023 activity. Upload one statement or a full year of those PDFs here and download clean rows in one pass.
Open a TD Ameritrade PDF statement, select a block of transactions, and paste it into Excel. The dates arrive as text Excel will not sort. Share quantities, option details, and prices collide in one cell. Dividends, interest, and cash activity run together. What should take five minutes becomes an hour of re-typing and re-checking.
TD Ameritrade is now Charles Schwab, and while Schwab.com holds up to 10 years of the old statements and tax forms, the pre-2023 PDF is still the record for that activity. When you need cost basis, a full tax history, or reconciliation across those years, the statement PDF is the record you actually have. This converter reads that PDF and hands back a clean spreadsheet in one step.
A single TD Ameritrade statement can combine a brokerage account and a retirement account. The converter separates each activity type so the spreadsheet is actually usable.
Stock, ETF, mutual fund, and options trades, plus dividends and interest, each carry a security name, quantity, price, and amount. Pasted by hand these smear across cells. The converter keeps the description together and puts the dollar amount in its own numeric column so SUM and pivot tables work at once.
TD Ameritrade accounts show deposits, withdrawals, transfers, interest credits, and cash sweep activity. Each line carries a description and a date. The parser tags every line with a transaction type so you can filter for just cash movements or just investment activity.
Note on tax lines: TD Ameritrade statements list dividends, interest, and realized gains and losses on trades. Those land in separate rows tagged DIV, INT, and GAIN so you can total investment income for a return without re-reading the whole document.
Sign in at Schwab.com, open Accounts and then Statements and Tax Forms, and download the old TD Ameritrade monthly or quarterly PDF. Up to 10 years are available. Scanned copies and mailed statements work too.
Drop the file into the upload box at the top of this page. The converter reads the document structure, finds the transaction tables, separates trades from cash activity, and pulls out dates, amounts, and reference numbers. Upload a full year at once if you want.
In under 30 seconds you get a preview, then download as Excel XLSX or CSV. Import it straight into QuickBooks, Xero, or a tax workbook, or open it in Excel or Google Sheets and start building pivot tables.
| Column | What is in there | Why it matters |
|---|---|---|
| Date | Transaction date as MM/DD/YYYY | Excel reads it as a real date, so sorting and date math work |
| Description | Security name or full activity detail | Keeps the detail intact for reconciliation and lookups |
| Type | BUY, SELL, DIV, INT, GAIN, ACH | Filter for just trades, just dividends, or just cash moves |
| Quantity and price | Shares and per-share price on trades | Cost basis and gain calculations without re-keying |
| Amount | Debit or credit as currency | Real numbers, so SUM and AVERAGE work immediately |
| Balance | Running balance after each line | Recalculated and checked against the statement totals |
The converter recomputes the running balance from your transactions and compares it against the statement totals. If a line is missing or a number was misread, you see a warning before you download instead of finding a gap weeks later during reconciliation.
Clients still hold years of old TD Ameritrade PDFs. Convert a full year in one pass, categorize with a Type column, and use pivot tables to total dividends, interest, and gains for the return.
After the Schwab migration, pre-2023 activity lives in old PDFs. Convert them to Excel to rebuild a complete trade and dividend history across the TD Ameritrade years.
Old statements hold the cost basis you still need. Convert several years of statement PDFs at once to rebuild a trade log with quantities, prices, and amounts in clean columns.
Lenders and auditors want searchable records, not PDFs. Hand over an Excel file with formatted dates, amounts, and validated balances so they can filter and sort on their own.
Transfers use SSL encryption, the same standard banks use.
Files are removed from our servers right after processing.
We do not keep your statements or transaction data.
Download the old monthly or quarterly PDF from Schwab.com under Accounts and Statements and Tax Forms, upload it to the converter at the top of this page, and download the result as Excel XLSX or CSV. The whole process takes under a minute per statement.
TD Ameritrade accounts moved to Charles Schwab in 2023. Sign in at Schwab.com and go to Accounts, then Statements and Tax Forms, where up to 10 years of TD Ameritrade statements, trade confirmations, and tax documents are available (Schwab Alliance for advised accounts).
TD Ameritrade accounts were fully migrated to Charles Schwab in 2023, so new activity is on Schwab. Your historical TD Ameritrade PDF statements are still the record for pre-2023 trades, dividends, interest, and cash activity, and this converter turns any of them into clean Excel or CSV.
Yes. Brokerage and retirement statements both convert, including historical pre-2023 PDFs. Trades, options, dividends, interest, and cash activity each get their own tagged rows so you can filter by account or activity type.
Yes. Upload multiple PDFs in one batch. Each is processed separately, and you can download them individually or combine a full year into a single spreadsheet.
Yes. Built-in OCR reads scanned pages and phone photos, with 99%+ accuracy on clear images. For best results, keep the statement flat and well lit so the text is sharp.
Working with statements from more than one firm? Start at the bank statement converter home page, send any PDF straight to a spreadsheet with the PDF bank statement to Excel converter, or convert another brokerage account with the Charles Schwab statement converter or Fidelity statement converter.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
