TD Bank Statement to Excel Converter

Converting TD Bank Statements to Excel

This page covers TD Bank, the US bank with branches along the East Coast from Maine to Florida, and its US dollar checking, savings and business statements. It is the US arm of the Toronto-Dominion group, which also runs TD Canada Trust in Canada. Canadian statements look different and use Canadian dollars; if that is what you have, use the general bank statement converter instead.

TD Bank statements are thorough but awkward to work with in a spreadsheet. Activity is usually grouped by type rather than listed in date order, electronic payment descriptions run long, and only some lines carry a balance. Finlyzers combines the sections into one list with separate debit and credit columns.

How a TD Bank Statement Is Typically Laid Out

Headings vary between account types and have changed over time, but a TD Bank checking statement commonly includes:

• Account summary: the beginning balance, totals for deposits and withdrawals by type, and the ending balance. Interest earned and fees may also be summarised here.
• Daily account activity: transactions grouped into sections such as deposits, electronic deposits, other credits, checks paid, electronic payments and other withdrawals, each with its own subtotal.
• Daily balance summary: the end-of-day balance for each date with activity.

Because individual lines usually do not show a running balance, the converter checks the extracted rows against the totals in the account summary and confirms that the beginning balance plus credits minus debits equals the ending balance.

Reading TD Bank Electronic Payment Descriptions

A lot of the activity on a TD Bank account, especially a business account, arrives as ACH transfers. Their descriptions are built from what the sending company submits, so they often look cryptic. You will commonly see:

• ACH standard entry codes such as CCD (a company-to-company payment, common for card processor settlements and vendor payments) and PPD (a payment to or from a consumer account, common for payroll and personal bills).
• Payment channel labels such as WEB for payments authorised online.
• The company name and sometimes an ID or invoice reference from the sender.

These details are useful when you categorise transactions. A business owner reconciling sales can filter the description column for the card processor's name to pull out every settlement, then match them against sales reports. The converter keeps the full description together in one cell so that filter works.

When You Still Need to Convert the PDF

TD Bank online banking usually lets you download recent activity for an open account. Converting the statement PDF is still the practical route when:

• you need history older than the download covers, such as a complete prior tax year;
• the account has been closed;
• a client or borrower sent you statements as PDFs instead of a download;
• you need figures that tie back exactly to the official monthly statement.

What You Get

• One date-ordered list built from every activity section.
• Separate Debit and Credit columns with positive amounts.
• Check numbers in the Reference column.
• Multi-page and multi-month PDFs processed in one upload.

Typical Uses

Small businesses on the East Coast use converted TD Bank statements to reconcile checking in QuickBooks or Xero, match card processor deposits against sales, and prepare Schedule C figures for a tax return. Households use them for budgeting and to supply transaction history for a mortgage or rental application. Download QBO for QuickBooks, OFX or CSV from the same upload. If you already have a CSV export from TD Bank and need it in QuickBooks, the CSV to QBO converter handles that step. Statements from other US banks are covered in the PNC and Bank of America guides.

Converting a TD credit card statement? Use the credit card converter. For paper statements or scans, try the scanned statement converter.