Convert a TD Bank Statement PDF to Excel
TD Bank statement layout, the daily balance summary to exclude, and verifying your converted file against the printed totals.
TD Bank statements combine a sectioned transaction layout with a daily balance summary — two things that each need specific handling.
The sections
TD splits activity into electronic deposits, other credits, electronic payments, checks paid, and service charges. Each carries a subtotal at its end, and each determines whether its rows are debits or credits.
The subtotal rows are the usual trap: they sit in transaction columns and carry no date, which is exactly what identifies them as summary data rather than transactions.
The daily balance summary
Like PNC and Wells Fargo, TD prints a daily balance block. Same issue, same fix: it lists dates and balances with no debits or credits, and belongs excluded from the transaction list.
Getting one chronological list
What you almost always want from a US statement is a single date-sorted table with proper debit and credit columns — not five disconnected blocks. That means detecting each section, applying its direction, extracting its rows, discarding its subtotal, and merging the result.
- Upload the full statement Section headings are what determine direction, so keep the file intact.
- Check the section subtotals Each section's extracted rows should sum to its printed subtotal.
- Check the four summary figures Beginning balance, deposits, withdrawals, ending balance.
- Sort by date if you want one timeline The rows come out in printed order, section by section. Sort by the date column for a single chronological list.
What the TD export contains
| In the file | What you get |
|---|---|
| TD's own columns | Every heading as printed, in the same order |
| Row order | As printed, so each section's rows stay together under it |
| Dates | Exactly as printed, with nothing reformatted |
| Descriptions | In full, with continuation lines joined into one cell |
| Amounts | As printed, unsigned where TD prints them unsigned |
| A Completeness sheet | The rows checked against the statement's own totals where it prints them, and against a balance where the layout prints one |
Why the section is worth a column
The converted file does not add a section column, but the rows stay in printed order, so adding one is a fill-down from where each section starts on the PDF. It is worth the minute: it lets you separate categories of activity that are genuinely different — electronic payments versus cheques versus service charges — and it is what tells you which way an unsigned amount moved.
Filtering to the service charge section, for instance, gives the complete set of fees for the period in one step — a question that is tedious to answer from the PDF and immediate from the spreadsheet. For QuickBooks, the QBO download needs a signed amount on every row, and TD prints its amounts unsigned under section headings that the QBO file cannot yet read as directions. For TD, download the CSV and map deposits and withdrawals yourself, or check the signs in QuickBooks before accepting.
Frequently asked questions
Does this work for TD Canada Trust statements?
TD Canada Trust prints a different layout from TD Bank US. Both are read as printed, each with its own columns.
How do I total my fees for the period?
Add a section column filled down from where each section starts, then filter to the service charge section. The rows stay in printed order, which is what makes the fill-down work.
Are TD business statements supported?
Yes, including the additional fee and analysis sections.
Related posts
- Convert an M&T Bank Statement to Excel
- Convert a PNC Bank Statement to Excel
- Convert a Huntington Bank Statement to Excel
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.