How to Convert TD Ameritrade Statements to CSV

Quick Answer: To convert TD Ameritrade (now Charles Schwab) statements to CSV, upload your PDF to [QuickBankConvert](/) for instant browser-based extraction. The tool handles brokerage account statements including trades, dividends, and cash transactions — no software installation needed.

TD Ameritrade and the Schwab Acquisition

TD Ameritrade was one of the largest online brokerage firms in the United States, founded in 1975 and growing through decades of innovation to serve millions of individual investors. The firm was known for its thinkorswim trading platform, extensive educational resources, and competitive fee structure including commission-free stock trades introduced in 2019.

Charles Schwab announced its acquisition of TD Ameritrade in 2019, and the merger completed in October 2020. The full client account migration — moving all TD Ameritrade accounts to the Schwab platform — completed in May 2023. Former TD Ameritrade clients now access their accounts at schwab.com and use the Schwab mobile app for day-to-day investing.

Despite the migration, many investors still hold historical TD Ameritrade statements for tax records, trade audits, performance analysis, and legal reference. These documents remain legally important for as long as you hold the underlying investments or for up to seven years for tax purposes after selling.

TD Ameritrade statements present unique conversion challenges because they contain multiple data types: brokerage transactions including buy and sell orders, cash transactions such as deposits and withdrawals, dividend and interest payments, margin activity, and option trades — all on the same statement. [QuickBankConvert](/) extracts the transaction data into a clean, analyzable CSV.

Why Convert TD Ameritrade Statements to CSV?

Tax preparation and capital gains calculations: Capital gains calculations require knowing the cost basis, acquisition date, and sale price for every security you sold. While TD Ameritrade (now Schwab) provides Form 1099-B for covered securities, CSV transaction data helps you reconcile, verify, and supplement your tax records. For complex portfolios with many transactions, having all data in a spreadsheet is essential.

Trade analysis and performance review: Reviewing your historical trading patterns — entry and exit prices, holding periods, win/loss ratios, average return per trade — requires data in spreadsheet or database format. PDF statements make this analysis practically impossible. A CSV of your full trading history enables calculations that reveal your actual investment performance beyond the simplified summaries shown in your brokerage portal.

Portfolio performance tracking: Calculating your actual return on investment requires combining dividend income, realized gains and losses, and unrealized position changes. A CSV of your full transaction history is the starting point for building a comprehensive performance attribution model.

Long-term record keeping: Brokerage statement records should be kept for at least seven years for tax purposes, and indefinitely for any securities you still hold (to establish original cost basis). CSV format is more searchable, sortable, and manageable than PDF for large volumes of historical records.

Types of Transactions in TD Ameritrade Statements

TD Ameritrade statements include several distinct transaction types that appear in the CSV output:

Understanding these transaction types is important when categorizing your CSV data for tax purposes. Dividends, for example, are treated differently from capital gains for tax purposes and need to be separated in your analysis.

How to Download TD Ameritrade Statements

For accounts that have been migrated to Schwab:

1. Log into your account at schwab.com using your Schwab credentials.
2. Navigate to Accounts > History and then select Statements.
3. Look for the TD Ameritrade legacy documents section for pre-migration statements.
4. Select the year and account type you need.
5. Download individual monthly or annual statements as PDFs.

If you have access to a legacy TD Ameritrade login, visit tdameritrade.com which may redirect to Schwab but could provide access to historical documents. Annual tax documents (Form 1099) are typically available through the Schwab portal under Tax Documents.

Converting TD Ameritrade PDFs to CSV

Step 1: Prepare Your Statement PDFs

Download the statement PDFs for the period you need. If you are preparing annual taxes, download all 12 monthly statements for the tax year, or look for a consolidated annual statement PDF. Annual statements typically condense the full year of activity into one document and are ideal for tax preparation.

Step 2: Use QuickBankConvert

Open [QuickBankConvert](/) and upload your TD Ameritrade statement PDF. The tool processes the file locally in your browser — your sensitive financial data is never transmitted to any server. The parser handles the multi-section format of brokerage statements and extracts transactions from all relevant sections.

Step 3: Review and Download

The preview shows extracted transactions with date, description, and amount columns. Verify a few rows against your original PDF to confirm accuracy. Then download as CSV for use in your analysis workflow.

Step 4: Combine Multiple Months for Annual Analysis

For annual tax or performance analysis, open all twelve monthly CSV files in Excel, copy all transaction rows from each file into a single master sheet with one header row at the top. This gives you a complete annual transaction register you can sort, filter, and analyze as needed.

Analyzing TD Ameritrade Transaction Data in Excel

Once your data is in CSV form, powerful analysis becomes straightforward.

Pro Tip: Add a "Transaction Type" column and use IF formulas to auto-categorize each row based on keywords in the description. This automates categorization of Buy, Sell, Dividend, and Fee transactions, making it easy to sum each category for tax or performance reporting.

Capital gains calculation: Filter for Buy and Sell transactions for each security. Match sells to their corresponding buys using FIFO (first in, first out) or specific identification method to calculate gain or loss per trade. The CSV format makes this matching process tractable in a way that PDF statements never could.

Dividend income reconciliation: Filter for Dividend and Interest transactions and sum the amounts. Compare to your Form 1099-DIV and 1099-INT to verify completeness. Any discrepancy should be investigated before filing your taxes.

Fee analysis: Filter for Fee transactions to see total fees paid, including advisory fees, wire transfer fees, and any other account charges. This is useful for investors evaluating the true cost of their brokerage relationship.

Options activity tracking: Filter for option trades using keywords like "option," "call," or "put" in the description. Options trades require specific tax treatment and need to be separately identified and categorized.

Tips for Brokerage Statement Conversion

Use annual or quarterly statements when available. Many brokerages offer quarterly or annual summary statements that consolidate months of data into one PDF. This reduces the number of files you need to process.

Keep original PDFs as primary records. CSV files are for analysis; the original PDF statements are the official records. For tax audit purposes, maintain both versions in organized folder structures by account and year.

Consult a tax professional for complex situations. QuickBankConvert extracts transaction data accurately, but does not calculate or verify tax figures. For portfolios with wash sales, foreign income, or complex option strategies, always work with a qualified tax professional.

Visit [QuickBankConvert](/) to start converting your TD Ameritrade or Schwab brokerage statements today and unlock the analytical power of your investment history.

Working With TD Ameritrade Data in Modern Portfolio Analysis

The shift from TD Ameritrade to Charles Schwab has not eliminated the value of historical TD Ameritrade transaction data. In fact, for investors who have held securities across the platform transition, having complete historical transaction records is essential for accurate cost basis tracking and long-term performance analysis.

Cost Basis Continuity

When TD Ameritrade accounts migrated to Schwab, cost basis information for covered securities transferred with the accounts. However, for older securities — those acquired before mandatory cost basis reporting requirements — cost basis may not have transferred correctly or completely. Your historical TD Ameritrade statement CSV provides the transaction-level data needed to reconstruct cost basis from purchase records.

Long-Term Performance Attribution

Investors who have used TD Ameritrade for five or more years have a rich transaction history that, when analyzed in CSV form, reveals long-term patterns: which security types have been most profitable, what average holding periods have been, how dividend income has grown over time, and how total return compares to benchmark indices.

This analysis requires combining multiple years of CSV data into a single master transaction register. Once combined, you can use Excel pivot tables or financial analysis formulas to calculate cumulative returns by security, sector, or time period.

Transitioning Analysis to the Schwab Platform

Going forward, Schwab statements use a similar format that is also supported by [QuickBankConvert](/), allowing you to maintain consistent analytical workflows as you build new transaction history at Schwab. Archive your TD Ameritrade statement PDFs and their corresponding CSVs as a permanent historical record alongside your ongoing Schwab data.

The combination of historical TD Ameritrade data and current Schwab data gives you a complete picture of your investing journey — an asset for long-term financial planning and performance evaluation. Visit [QuickBankConvert](/) to convert both historical and current brokerage statements efficiently.

Schwab Integration: Getting the Most From Your Combined History

Now that your TD Ameritrade account has migrated to Charles Schwab, you have two distinct periods of investment history to manage: the pre-migration TD Ameritrade period and the ongoing Schwab period. Keeping these records organized and accessible in CSV format is essential for comprehensive portfolio analysis and tax accuracy.

Charles Schwab's thinkorswim platform (the same platform that came with the TD Ameritrade acquisition) continues to operate and is available to all Schwab clients. If you were a thinkorswim user at TD Ameritrade, your trading history and settings migrated to the Schwab version of the platform.

For investors who want to analyze their complete trading history — including trades made at TD Ameritrade before the migration — the process is straightforward. Download your historical TD Ameritrade statements from the Schwab portal, convert each one to CSV using [QuickBankConvert](/), and combine them with your ongoing Schwab statements in a master transaction register.

Tax Loss Harvesting With Historical Data

Tax loss harvesting — selling securities at a loss to offset capital gains elsewhere — requires knowing the cost basis and current value of all holdings. Your historical TD Ameritrade CSV data provides the acquisition dates and prices for positions you still hold, which is essential input for identifying harvesting candidates.

Securities held since the TD Ameritrade era with unrealized losses are prime harvesting candidates if you have realized gains to offset. Your combined TD Ameritrade and Schwab CSV history gives you the complete picture needed to make these decisions accurately. Consult a tax advisor before executing any tax loss harvesting strategy to ensure compliance with wash sale rules and other relevant regulations.

Building and maintaining this comprehensive transaction record makes you a more informed investor. Start with [QuickBankConvert](/) to convert your TD Ameritrade statement archive and establish the foundation of your long-term investment record.