Introduction: TD Bank US vs. TD Canada Trust
Toronto-Dominion Bank (TD Bank Group) is one of the largest multinational financial conglomerates in North America. Unlike regional US banks, TD operates two major, distinct banking subsidiaries:
- TD Bank, N.A. (America's Most Convenient Bank): Headquartered in Cherry Hill, New Jersey, serving the US East Coast from Maine to Florida. Statements use US banking standards (9-digit ABA routing numbers, USD currency, and US MM/DD date notation).
- TD Canada Trust: Headquartered in Toronto, Ontario, serving consumers and commercial enterprises across Canada. Statements use Canadian Payments Association standards (5-digit transit number, 3-digit financial institution number
004, CAD currency, and bilingual English/French formatting).
Because cross-border businesses, Canadian snowbirds, and multinational corporations frequently maintain accounts on both sides of the border, bookkeepers must handle both statement formats seamlessly.
This guide provides an end-to-end walkthrough of converting both TD Bank US and TD Canada Trust statement PDFs into formatted Excel spreadsheets, CSV files, and QuickBooks Web Connect files.
Anatomy of TD Bank Statements
1. TD Bank US Statement Architecture
TD Bank US statements feature an uncluttered, modern layout with distinct sections for Electronic Payments, Checks, and Daily Balance Summaries:
TD BANK, N.A.
ACCOUNT NUMBER: 1234567890
STATEMENT PERIOD: MAR 01, 2026 - MAR 31, 2026
DAILY ACCOUNT ACTIVITY
Date Description Subtractions Additions Balance
03/02/26 ELECTRONIC DEPOSIT - PAYROLL ACME $4,200.00 $14,250.00
03/05/26 CHECK # 1042 $450.00 $13,800.00
03/08/26 DEBIT PURCHASE: HOME DEPOT # 1204 $112.40 $13,687.60
03/15/26 WIRE TRANSFER OUT REF: INV-9042 $5,000.00 $8,687.60
2. TD Canada Trust Statement Architecture
TD Canada Trust statements are characterized by bilingual headers and Canadian transit codes:
TD CANADA TRUST / BANQUE TD
TRANSIT: 12345 INST: 004 ACCOUNT: 123-4567
STATEMENT DATES: MAR 01, 2026 TO MAR 31, 2026
TRANSACTION DETAILS / DÉTAIL DES OPÉRATIONS
Date Description / Description Withdrawals / Retraits Deposits / Dépôts Balance / Solde
01 MAR OPENING BALANCE / SOLDE AU DÉPART $8,450.00
03 MAR DIRECT DEPOSIT / DÉPÔT DIRECT REVENUE CANADA $1,420.50 $9,870.50
07 MAR PRE-AUTHORIZED DEBIT / DÉBIT PRÉAUTORISÉ ROGERS $142.10 $9,728.40
14 MAR E-TRANSFER SENT / VIREMENT INTERAC ENVOYÉ $500.00 $9,228.40
Technical Challenges When Parsing TD Statements
1. Bilingual Text Noise Removal (Canadian Statements)
On TD Canada Trust statements, column headers and standard transaction descriptions include slash-delimited bilingual translations:
WITHDRAWALS / RETRAITS, BALANCE / SOLDE, INTERAC E-TRANSFER / VIREMENT INTERAC.
- A generic OCR tool outputs the slash-separated text, causing messy, bloated strings in your general ledger.
- An intelligent financial parser strips the secondary language noise, isolating clean vendor names (
Rogers Cable,Revenue Canada) for clean accounting bank rules.
2. Month-Name Date Parsing (01 MAR vs 2026-03-01)
TD Canada Trust statements often print dates as day followed by a 3-letter English/French month abbreviation:
01 MAR, 15 AVR, 22 MAI.
- If simply exported to Excel, Excel may fail to recognize
15 AVR(Avril / April) as a valid calendar date, leading to sorting errors. - The extraction engine detects the statement year from the header block, translates the multilingual month token, and normalizes each row into standard ISO format:
2026-04-15.
3. Check Image Extraction and Check Registers
TD Bank statements frequently include check images on subsequent pages:
- These pages display scanned front-and-back thumbnails of cleared checks.
- A quality converter ignores the embedded image pages and extracts only the verified numeric check register, preventing duplicate rows or optical hallucination errors.
Step-by-Step: Converting TD Statements to Excel
Follow these steps to convert your TD Bank statements into clean spreadsheets:
Step 1: Download Statements from TD EasyWeb or TD Online Banking
- TD Bank US: Log into td.com > Select Account > Statements > Download PDF.
- TD Canada Trust: Log into EasyWeb Internet Banking > Select Account > Statements > Save PDF.
Step 2: Upload to Statement Extract
Navigate to Statement Extract Bank Statement to Excel Converter.
- Drag and drop your TD Bank statement PDF.
- The system automatically identifies whether the statement originates from TD Bank US or TD Canada Trust.
- The parser extracts all transaction lines, cleans descriptions, normalizes dates, and assigns positive/negative signage.
Step 3: Check Mathematical Continuity
The tool validates that: $$\text{Starting Balance} - \text{Total Subtractions} + \text{Total Additions} = \text{Ending Balance}$$ A green confirmation badge guarantees zero omitted rows.
Step 4: Export to Excel, CSV, or QuickBooks
Choose your desired export format:
- Microsoft Excel (.xlsx): Complete with formulas, date formats, and clean numerical columns.
- QuickBooks (.qbo): Formatted for 1-click Web Connect bank feed ingestion into QuickBooks Online or Desktop.
- Xero CSV: Prepared with separated Debit/Credit columns matching Xero's schema.
Summary
Whether managing TD Bank US business accounts or TD Canada Trust personal checking, extracting statement data from PDF into Excel allows accounting teams to eliminate manual data entry. By normalizing cross-border date conventions and bilingual descriptions, you can generate clean, reconciled ledgers in seconds.



