How To Convert a TD Ameritrade Statement to Excel
TD Ameritrade brokerage statements (now legacy after the Schwab acquisition) ship in two distinct layouts: advisor-managed monthly statements and self-directed Portfolio Summary statements. This guide shows how to convert either format to Excel without manual keying.
TD Ameritrade brokerage statements still circulate in the wild even though Schwab completed the TDA acquisition and migrated client accounts onto the Schwab platform. Pre-migration TDA statements remain the document of record for any reconciliation, tax-prep, or audit work covering the period before the account moved over. They ship in two distinct layouts:
- Premium / self-directed: the standard "Portfolio Summary" statement for retail self-directed accounts. Six-column table with rows for Cash, Insrd Dep Acct (IDA), Money Market, Stocks, Mutual Funds, Fixed Income, and Options, footed by a Total row.
- Classic / advisor-managed: "ACCOUNT SUMMARY" + "Total Account Value:" + per-section "SUMMARY OF HOLDINGS" rows for advisor-managed accounts cleared through TD Ameritrade Institutional.
This guide walks through converting either format to Excel with DocuClipper's brokerage statement converter. On the corpus we tested against, the TDA extractor reconciles 14 of 14 statements (100%), with the sum of per-asset-class positions matching the printed Total Account Value to within $1 across both variants.
While you are here
Extract every transaction from any bank PDF
Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.
What gets extracted from a TD Ameritrade statement
DocuClipper maps each TDA section to its own Excel sheet:
| TDA statement section | Excel sheet | What's in it |
|---|---|---|
| Portfolio Summary (premium) or SUMMARY OF HOLDINGS (classic) | Holdings | Per-asset-class market value (Cash / IDA / Money Market / Stocks / Mutual Funds / Fixed Income / Options) |
| Portfolio Summary Total row or Total Account Value | Summary | Beginning value, ending value, change this period |
| Cash Activity Summary (premium) or BEGINNING/ENDING VALUE table (classic) | Summary | Funds Deposited, Funds Disbursed, Withdrawals from Account |
| Income Summary Detail | Income | Dividends and Interest (period and YTD), IDA Interest |
For advisor-managed statements, DocuClipper also captures the advisor firm name from the "YOUR INDEPENDENT ADVISOR" line on the cover, so multi-advisor batches can be filtered by RIA in Excel.
What's specific about TD Ameritrade statements
Two distinct layouts in the wild. Self-directed retail accounts use the Portfolio Summary table layout; advisor-managed accounts use the ACCOUNT SUMMARY + Total Account Value layout. DocuClipper auto-detects which one you uploaded and routes to the right parser. The variant is reported in the Summary sheet as statementVariant=premium (self-directed) or classic (advisor-managed).
TDA legacy and Schwab references on the same page. Post-acquisition TDA statements often reference "Charles Schwab Bank" as the IDA (Insured Deposit Account) Program Bank, even though the brokerage statement layout itself is still TDA's. DocuClipper detects the document as TDA first based on the TD AMERITRADE branding on the cover, so the Schwab IDA disclosure footer doesn't cause misrouting. If you have a true post-migration Schwab statement (using the Schwab template, no TDA branding), see the Schwab statement to Excel walkthrough.
Two period formats. TDA prints either Reporting Period: July 1 - 31, 2023 (advisor-managed) or 06/01/22 - 06/30/22 (self-directed). DocuClipper handles both and normalizes to ISO dates on the Summary sheet.
Account number format NNN-NNNNNN. TDA account numbers are nine digits split by a hyphen (869-823477). DocuClipper extracts both Statement for Account # NNN-NNNNNN and Account NNN-NNNNNN formats from the cover.
Account types from the cover line. ROTH IRA, ROLLOVER IRA, TRADITIONAL IRA, SEP IRA, INDIVIDUAL, and TRUST account types are detected from the upper-case account-name line on page 1 and reported in the Summary sheet as accountType=roth_ira, traditional_ira, etc.
Tax forms are rejected. TDA Consolidated Form 1099 and standalone 1099-B / 1099-DIV / 1099-INT pages carry TDA branding but are not monthly statements. DocuClipper's detection layer rejects them so they don't get conflated with brokerage extracts.
Step-by-step: converting a TDA statement to Excel
- Open DocuClipper and click the Brokerage Statement upload card on the Tools page.
- Drop your TD Ameritrade PDF onto the upload area. Both pre-migration TDA self-directed statements and TDA Institutional advisor-managed statements work. Scanned mailed copies go through OCR first.
- Wait for extraction. DocuClipper auto-detects the variant (Portfolio Summary vs ACCOUNT SUMMARY) and routes to the right parser. A typical monthly TDA statement processes in under a minute.
- Review the Holdings sheet. Each non-zero asset-class row from the Portfolio Summary or SUMMARY OF HOLDINGS table is one row.
- Click Export → Excel to download the workbook.
Put it into practice
Manual copy-paste is where errors begin
Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.
How the TDA extractor works under the hood
DocuClipper uses pdftotext with -layout to preserve the six-column Portfolio Summary table (Investment / Current Value / Prior Value / Period Change / % Change / Estimated Income / Yield) or the three-column SUMMARY OF HOLDINGS table (Asset Class / Value / % of Account). Anchored regex captures the asset-class label and the relevant money tokens for each row.
The reconciliation gate is the printed Total Account Value (advisor-managed) or the Total row at the bottom of the Portfolio Summary (self-directed). If the sum of per-asset-class current values doesn't match within $1, the document is flagged unreconciled.
For documents where per-asset-class extraction comes up empty (rare, but happens on highly customized RIA-built variants), DocuClipper falls back to emitting a single aggregate "Account Total" position equal to the printed ending value so the Summary sheet still reconciles trivially.
Frequently asked questions
Does this work for TDA statements after the Schwab acquisition?
Yes for any pre-migration TDA statement (which still uses the TD AMERITRADE template). Once your account migrated to the Schwab platform, your statements switched to the Schwab template, which is handled by the Schwab statement to Excel workflow. DocuClipper auto-detects which format you have based on the cover branding.
What about TDA Institutional advisor-managed statements?
Yes. Advisor-managed statements use the "ACCOUNT SUMMARY" + "Total Account Value:" layout. DocuClipper detects this as statementVariant=classic and routes to the parser that reads the SUMMARY OF HOLDINGS table. The advisor firm name (from the "YOUR INDEPENDENT ADVISOR" line on the cover) lands in the Summary sheet as advisorFirm so multi-RIA batches can be filtered.
Can I extract the IDA Program Bank balance separately from the cash position?
The IDA (Insured Deposit Account) Program Bank balance lands in the Holdings sheet as a cash row labeled Insrd Dep Acct (IDA). Money Market sweep balances appear separately as money_market rows. Both reconcile against the Total Account Value.
Does it pull individual security positions?
The current TDA extractor uses per-asset-class aggregate rows (Stocks, Mutual Funds, Fixed Income, Options, etc.) as Holdings positions. That gives a deterministic reconciliation against the Total Account Value. Per-security row extraction with CUSIP and ticker is on the roadmap; for that level of detail today, contact us.
What about Consolidated 1099 forms?
DocuClipper rejects TDA Consolidated 1099 / 1099-B / 1099-DIV / 1099-INT pages at the brokerage extractor's detection layer. Tax-form extraction is a separate workflow handled by the tax form data extraction product.
Can I convert pre-migration TDA statements alongside post-migration Schwab statements in the same batch?
Yes. Upload mixed batches of TDA and Schwab PDFs together. DocuClipper detects each document's broker independently and routes to the right extractor. The Summary sheet carries custodianName (TD Ameritrade Clearing, Inc. vs Charles Schwab & Co., Inc.) so you can filter by custodian in Excel after exporting.
Related Articles
- Brokerage Statement Converter
- Brokerage Statement to Excel
- Best Brokerage Statement Converter Software
- How to Convert a Schwab Brokerage Statement to Excel
- How to Convert a Fidelity Brokerage Statement to Excel
- How to Convert a Merrill Lynch Statement to Excel
- How to Convert a Wells Fargo Advisors Statement to Excel
- How to Convert a Raymond James Statement to Excel
Next step
Upload your first statement free
No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.