TD Canada Trust Statement to Excel Converter

ClearlyLedger converts TD Canada Trust (Canada) PDF statements into clean Excel and CSV files. This guide covers the common TD pdf layout, MMM DD dates and CAD amounts. Exports are released only when verification checks pass. Most TD statements (3–12 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-08-07

Read the TD source layout correctly

Printed structure: PDF with Date, Description, Debit, Credit, Balance

Date notation: MMM DD. Money notation: C$ CAD. Observed statement size: 3–12 pages.

Amounts use a period decimal; bilingual (EN/FR) narrations are preserved verbatim.

Fields and row patterns found in TD Canada Trust PDFs

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • TD checkpoint 1: Date omits year — must be inferred from statement period header
  • TD checkpoint 2: Interac e-Transfer entries include sender/receiver name
  • TD checkpoint 3: Pre-authorized debit (PAD) entries include company name and authorization number
  • TD checkpoint 4: Statement covers 28–31 days; year boundary requires special handling

Review the TD extraction

A typical TD Canada Trust file runs 3–12 pages. Confirm its MMM DD dates, CAD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Date omits year — must be inferred from statement period header. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the TD Canada Trust PDF.
  2. Inspect the documented TD row patterns.
  3. Reconcile the CAD transaction math.
  4. Download verified TD Excel or CSV data.

Use the TD output in Canada

Excel suits source-document review and coding. CSV suits mapped imports into QuickBooks Online, Xero, Sage 50 Canada or Wave. Those routes preserve the MMM DD interpretation and CAD values established from the TD Canada Trust source.

TD privacy and retention

The TD PDF is processed in memory and deleted after conversion. The TD transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around Canada's PIPEDA for Canada account holders.

TD conversion FAQ

Which TD statement layouts can ClearlyLedger convert?

TD Canada Trust statements typically arrive as PDF with Date, Description, Debit, Credit, Balance. ClearlyLedger's TD profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle TD-specific quirks?

This guide highlights common TD statement characteristics — for example: Date omits year — must be inferred from statement period header. The conversion is released only after its verification checks pass.

Can I import a converted TD statement into QuickBooks Online?

Yes. Export to CSV and import into QuickBooks Online, Xero, Sage 50 Canada or any tool that accepts a transaction file. The MMM DD dates and CAD amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free