TD Bank Statement to Excel or CSV: A Practical Guide

TL;DR: Download TD statements as PDFs (or recent activity as a spreadsheet file), convert the PDFs with a statement converter, and verify that the opening balance plus every transaction equals the closing balance. If you deal with both TD Bank in the US and TD Canada Trust, watch date formats, currencies and the different layouts, and keep each account in its own file.

"TD" covers two quite different banking experiences for many of our users. TD Bank operates in the eastern United States, and TD Canada Trust is the Canadian retail bank. They're part of the same group, but the statements, online banking and conventions differ. Cross-border customers, snowbirds and businesses that sell in both countries often have accounts at both, and that's exactly where spreadsheets get confusing.

This guide covers converting TD statements generally, and the cross-border details that matter.

What TD gives you

On both sides of the border, you'll find:

• Monthly statements as PDFs in online banking, typically showing an opening balance, itemized transactions and a closing balance. Business statements often include more detail, such as separate sections or daily balances.
• Transaction downloads for recent activity, in spreadsheet-friendly formats and formats for personal finance or accounting software.

Downloads are fastest for recent months. Statements are the official record and reach further back.

One practical difference between the two countries' banking sites is how downloads are labeled and which formats are offered. Rather than relying on a description that might be out of date, look at the download options for your own account and pick a comma-separated or spreadsheet format for Excel, or the QuickBooks/Quicken-style format if you're going straight into software. Open the result in a text editor once to see its real date format and column order before building anything on top of it.

Getting the statements

In general terms:

1. Sign in to TD online banking (the US or Canadian site, as appropriate) or the app.
2. Open the account.
3. Look for Statements or Statements & Documents (Canadian online banking may use slightly different wording, such as an eStatements area).
4. Choose the period and download.

If you need older statements than are shown, contact the bank for copies.

Name files with the country and currency if you hold accounts in both: td-us-checking-1234-2026-03-USD.pdf, td-ca-chequing-5678-2026-03-CAD.pdf. It sounds fussy until the first time you mix them up.

Converting the PDFs

1. Upload to SheetStatement. Digital PDFs from online banking work best; scans work too.
2. Review the extracted transactions and the balance check.
3. Fix any flagged rows.
4. Export Excel, CSV, or an accounting format.

Our TD Bank page lists tested layouts.

Verify each statement

The rule doesn't change:

opening balance + deposits − withdrawals = closing balance

In Excel, with a signed Amount column, =Opening+SUM(Amount) should equal the closing balance. If the statement prints a running balance, check each line. Our balance checker automates it.

For statements with a daily balance table, compare your running balance at the end of each day with the printed figure. The first day that differs is where the problem is.

Cross-border details

Dates

US statements typically use month/day/year. Canadian statements and software settings vary: many Canadian systems use day/month/year or ISO dates, though some use month/day. Before combining or importing, decide on one format. ISO (2026-03-14) is the safest for a combined workbook.

Check the converted dates for a transaction after the 12th of a month. If 03/14 became 14/03, or March 4 became April 3, you'll see it there.

Currency

A US TD account is in US dollars; a Canadian account in Canadian dollars; and TD Canada Trust also offers US dollar accounts for Canadians. Keep currencies separate:

• Add a Currency column to every row.
• Never sum amounts across currencies without converting.
• If you need a combined view, add a converted column using an exchange rate you document (for example, a monthly average rate from a source you name in the workbook), and keep the original amount.

For bookkeeping, import each currency's account into a matching currency account in your accounting software rather than converting yourself. Software that supports multiple currencies handles the conversion and gains or losses. Ask your accountant how they want cross-border amounts recorded.

Terminology

Canadian statements may say "chequing" and "cheque"; US statements "checking" and "check." Harmless, but if you write categorization rules, include both spellings: a rule for "CHQ" or "CHEQUE" and one for "CHECK."

Transfers between countries

Moving money from a Canadian account to a US account appears as a withdrawal in one currency and a deposit in another, often on different days and with amounts that don't match because of the exchange rate. Tag both sides as Transfer and add a note linking them. In accounting software, a cross-currency transfer is recorded as a transfer between two accounts in different currencies; the difference is handled as an exchange gain or loss according to your accountant's approach.

Building a combined view with exchange rates

If you want one number for "total spending this month" across both countries, you need to convert one currency into the other. A simple, transparent way:

1. Add a Rates sheet with one row per month: Month, Rate (for example, CAD per 1 USD), and Source (where the rate came from, such as your bank's statement rate or a published monthly average you choose).
2. In the transactions table, add a Rate column: =IF([@Currency]="CAD", XLOOKUP([@Month], Rates[Month], Rates[Rate]), 1).
3. Add Amount (USD): =[@Amount]/[@Rate] for CAD rows (or the reverse, depending on how you quote the rate).
4. Build your pivot on the converted column, and keep the original Amount column untouched.

This won't match your accounting software's figures exactly, because software applies its own rates and records exchange differences. That's fine. The combined view is for understanding, not for the books. The important thing is that the method is written down in the workbook, so anyone reading it knows what the numbers mean.

TD credit cards

TD issues credit cards in both countries, and card statements follow the usual structure: previous balance, payments and credits, purchases, interest and fees, new balance. Verify with:

previous balance + purchases + interest + fees − payments − credits = new balance

Card statements also sometimes show foreign currency purchases with the original amount and the converted amount on separate lines. Keep the converted amount (the one you were billed) and drop the informational line if it came through as a separate row. If you see a foreign transaction fee, keep it as its own row. Our credit card statement converter handles these layouts.

A monthly routine for cross-border households

People who split the year between countries often find their finances spread across both. A routine that keeps it manageable:

1. On the same day each month, download every statement from both countries.
2. Convert and verify each one.
3. Paste into a yearly workbook with Account, Country and Currency columns.
4. Tag transfers, including cross-border moves.
5. Update the month's exchange rate on the Rates sheet.
6. Review a pivot by country, category and month.

Seeing spending by country is often eye-opening. It also helps when you're planning how much to move between countries before each season, and it gives your accountant (or accountants, one in each country) clean records to work from. Tax treatment for people with ties to two countries can be complex, so this is an area where professional advice is worth having; the spreadsheet's job is to make sure they have complete information.

Keeping a clean archive

Because cross-border records may be needed by people in two countries, keep the archive simple: one folder per year, with subfolders per country, and within each, the PDFs and the converted files for each account. Put the yearly workbook at the top level. If you ever need to share a set of statements with a lender or an accountant in one country, you can send exactly the right folder without picking through everything.

Formatting for accounting software

• QuickBooks Online: a QBO file or a three-column CSV per account. Make sure each currency's account in QuickBooks is set to the correct currency if you use multicurrency. See our QuickBooks Online import guide.
• QuickBooks Desktop: QBO (Web Connect) files, imported per account. See the Desktop guide.
• Xero: a Xero CSV per account, imported into the correct currency account. See Xero CSV import format.
• Other tools: a clean CSV with Date, Description and signed Amount usually works.

SheetStatement's QuickBooks converter and Xero converter export these formats directly.

Business accounts with many deposits

Businesses that take card payments, e-transfers, checks and wires into a TD business account can have hundreds of deposits a month. A few practices make these statements easier to work with after conversion:

• Separate deposit types. Add a Type column (card processor, e-transfer, cheque/check, wire, cash) using simple keyword rules on the description. A pivot by Type shows how customers pay you, which is useful for deciding which payment methods to encourage.
• Match deposits to invoices. If you invoice customers, add a Reference column and fill in the invoice number for each deposit. Your accounting software does this when you match, but for catch-up work in Excel, a lookup against an invoice list (by amount and approximate date) gets most of the way.
• Watch processor net deposits. Card processor payouts are usually net of fees. If you report gross sales, use the processor's own reports alongside the bank statement.
• Keep cheque images in mind. Business statements sometimes include images of deposited cheques. A converter should skip the images, but if it reads amounts from them, you'll see duplicates. The balance check reveals them immediately.

Cleaning up the data

Once verified:

• Real dates and numbers throughout.
• One signed Amount column.
• A cleaned Payee column next to the original description.
• Categories via a rules table; see Excel formulas for categorizing transactions.
• Account, Country and Currency columns if you're combining.

A worked example

A small business owner sells to customers in both countries. She has a TD Bank checking account in the US and a TD Canada Trust business chequing account in Canada.

For March:

1. She downloads both PDFs and converts them.
2. The US statement balances: opening 14,200.00 USD + transactions = closing 15,980.44 USD.
3. The Canadian statement doesn't: the calculated closing is 3,120.00 CAD lower than the statement says.
4. The running balance check shows the difference starts on March 9. On the PDF, there's a deposit of 3,120.00 on March 9 from a customer. The converter missed it because it sat on the first line of page 2, directly under the repeated page header. She adds it; the statement balances.
5. On March 15, she moved 5,000.00 CAD from Canada to the US account, which arrived on March 16 as a USD deposit of a smaller amount after conversion. Both sides are tagged Transfer with a note.
6. She imports each statement into the matching currency account in her accounting software.

Her accountant later asks about the exchange difference on the transfer. Because both sides are tagged and noted, the answer takes seconds.

Troubleshooting

Dates swapped between day and month. Check the format of each source and standardize.

Amounts in different currencies added together. Add a Currency column and split.

Missing first line on a page. A row under a repeated header was skipped. The running balance check finds it.

Cheque numbers in the description. Extract them to a Reference column for matching: =IFERROR(VALUE(MID([@Description],SEARCH("CHQ",[@Description])+4,6)),"") is a rough starting point; adjust to the actual wording.

Downloads don't match statements. Use the statement period dates for the download, and filter out pending items.

Security

Cross-border statements often contain more personal detail (addresses in two countries, multiple account numbers). Use a converter with encryption and automatic deletion; see our security page. Store the files privately.

Our take

TD statements convert like any others. The extra care is for cross-border customers: keep dates in one format, keep currencies apart, tag transfers between countries, and import each account into a matching currency account. Do that, and two sets of TD statements become one coherent picture.

Troubleshooting TD conversions

US and Canadian statements differ. TD Bank in the US and TD Canada Trust have different statement layouts. Don't assume a template built for one works for the other.

Withdrawals and deposits are in separate columns. Merge them into one signed amount if your destination needs it, or keep both if it accepts two columns.

Daily balance column. Some statements show a balance only at the end of each day rather than on each line. Your running balance will match the statement only at the last transaction of each day. That's expected.

US-dollar accounts held in Canada. Keep USD and CAD accounts in separate tables, each in its own currency. Convert only for summaries, with a stated rate.

Cheque numbers without payees. Add payees from your own records in a notes column.

A second worked example: a snowbird's annual summary

A retired couple splits the year between Canada and the US, with a TD Canada Trust account and a TD Bank account in the US. For their tax preparer, they convert twelve months from each, keep two tables in their own currencies, and tag transfers between them on both sides. A summary sheet shows each account's income and main expense categories, with the exchange rate source noted for the combined view. The preparer gets clean data from both countries without reading 24 statements.

Mini checklist

1. Each account in its own table and currency.
2. Withdrawals and deposits handled consistently.
3. Transfers between your accounts tagged on both sides.
4. Totals checked per statement.
5. PDFs kept for every month.

FAQ

Can I download TD Bank statements as Excel files?

Statements are PDFs. Online banking lets you download recent transactions in spreadsheet-friendly formats. For older periods or official records, convert the PDF statements.

Does this work for TD Canada Trust as well as TD Bank in the US?

Yes. The process is the same: download the PDFs, convert, and verify the balances. Watch date formats and currencies when you combine accounts from both countries.

How do I combine US and Canadian accounts in one spreadsheet?

Add Account and Currency columns, use one date format, and don't add amounts across currencies without a documented conversion. Keep the original amounts.

How should I record transfers between my Canadian and US accounts?

Tag both sides as transfers and note the link between them. In accounting software, record a transfer between accounts in different currencies and ask your accountant how to treat the exchange difference.

Why are my dates wrong after converting?

Different sources may use day/month or month/day order. Check a date after the 12th of a month and standardize the whole file to one format.

Can I import TD statements into QuickBooks or Xero?

Yes. Export each account as a QBO file or a CSV, and import it into the matching account, using the correct currency setting if your software supports multiple currencies.