How to Export a TD Bank Statement to Excel

You have a TD Bank account. You need 24 months of history for a tax filing.

This page is the TD Bank export guide. It covers the US portal’s 2 download options (PDF and OFX), the Canadian portal’s CSV option, the cross-border consideration for users with both, and how to convert the PDFs if you need older history than the OFX covers.

TD Bank US gives you 84 months of monthly PDF statements and 18 months of combined OFX download. The OFX is the right path for QuickBooks users. The PDF is the fallback for anything older than 18 months. There is no CSV export for US accounts.

TD Canada Trust accounts use a separate portal at tdcanadatrust.com. The Canadian portal gives you a clean CSV that opens directly in Excel, plus PDF statements. The CSV is more user-friendly than the US OFX path.

If you have a US/Canada cross-border relationship with TD, you will need to log into two different portals. The export flows are different. The column structures are different. Combine the two files in Excel manually after export.

What TD Bank US Actually Gives You

TD Bank’s US online portal at tdbank.com gives personal account holders 2 export options.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

• Monthly PDF Statements going back 84 months (7 years). One PDF per month per account. The PDF has the standard TD Bank branding, the account summary, and the transaction list.
• Combined OFX Download going back 18 months. This is the cleanest export. The file is a single OFX with all transactions for the date range. It opens in QuickBooks, Xero, and most accounting software. A converter that handles OFX can also turn it into an Excel file.

There is no CSV export for US accounts. The OFX is the data file. The PDF is the official statement for lenders and auditors.

There is no combined statement feature. Each account is downloaded separately. The 18-month OFX limit applies per account. The 84-month PDF limit applies per account. This is one of 10 banks covered in our US bank export guide.

How to Download TD Bank US OFX Step by Step

The OFX export is the cleanest path. Here is the click-by-click flow.

1. Log into tdbank.com with your User ID and Password.
2. Click on the account you want the statement for.
3. Click “Account Activity” in the navigation.
4. Set the date range. The maximum is 18 months.
5. Click the “Download” button.
6. Choose “OFX” from the format dropdown.
7. Click “Download” again. The file saves to your default downloads folder.

The file is named something like td_activity_2024-07-15_to_2026-01-15.ofx. Open it in QuickBooks or convert it through a tool that handles OFX.

I learned this the hard way the first time a TD Bank client needed 24 months of history for an audit. I downloaded 24 PDFs. Then I found the OFX export, which would have given me 18 months in one file. The remaining 6 months needed the PDF route.

The lesson: always check the OFX first, fall back to PDF only when you need older history.

How to Download TD Bank US PDF Step by Step

The PDF export is in the “Statements” section. Here is the click-by-click flow.

1. Log into tdbank.com.
2. Click on the account.
3. Click “Statements” in the navigation.
4. You will see a list of monthly statements going back 84 months.
5. Click the statement you want. The PDF opens in your browser.
6. Save the PDF (Ctrl+S or File > Save).

The PDF is one file per month per account. For 84 months of history across 2 accounts, you are downloading 168 files. The PDF is well-formatted and a converter that handles TD Bank’s standard layout will extract the transactions cleanly.

The 18-Month OFX Limit (and How to Work Around It)

TD Bank’s OFX export is capped at 18 months. If you need 24 months, the extra 6 months need the PDF route. The workflow is:

1. Download the OFX for the last 18 months. Convert it. Save.
2. Download the PDFs for the 6 months before that. Convert each one. Save as separate sheets in the same workbook.
3. Combine in Excel or Google Sheets. The columns are the same across OFX and PDF conversions, so this is a simple append.

For most users, 18 months is enough. The 18-month limit is a TD Bank portal limit. Older data exists in TD Bank’s archives. Getting it requires the PDF route or a phone call to customer service.

TD Canada Trust: A Different Portal

If you have a TD Canada Trust account (in Canada), the export flow goes through a completely separate portal at tdcanadatrust.com. The login is different, the menus are different, and the export options are different.

TD Canada Trust gives you 2 main export options:

• Monthly PDF Statements going back 7 years. Same as the US portal.
• Combined CSV Download going back 18 months. This is the unique feature. The Canadian portal gives you a clean CSV with Date, Description, Amount, and Balance as separate columns. The CSV opens directly in Excel without conversion.

For Canadian TD customers, the CSV is the cleanest path. For US TD customers, the OFX is the cleanest path. If you have both, you are dealing with two different file formats that need to be handled separately.

Cross-Border US/Canada Customers

If you have both a TD Bank US account and a TD Canada Trust account, the export flow is split across two portals. You will need to log into each portal separately and run the export for each account.

The US side gives you OFX files. The Canadian side gives you CSV files. The column structures are different, so combining the two requires manual mapping in Excel. Add a “Country” column to identify which side each transaction came from.

For users with multiple accounts on both sides, the combined approach is essential. Most accounting software cannot directly import from both portals. The workaround is to convert the OFX files to CSV (using a converter), then combine all the CSV files in Excel with manual column mapping.

For users who primarily do US business and have a Canadian account as a secondary holding, the US portal’s OFX is the primary path. The Canadian CSV is a secondary export that gets added to the main US file.

TD Bank Regional Coverage

TD Bank is a regional bank with the strongest presence on the East Coast of the United States. The states with the most branches are Maine, Massachusetts, New York, New Jersey, Pennsylvania, Maryland, Virginia, North Carolina, South Carolina, Georgia, and Florida.

The export flow is consistent across regions, so this guide applies whether you bank in Maine, New York, or Florida. There is no regional difference in the export options.

TD Bank also operates in Canada as TD Canada Trust (separate entity). The two entities share branding but have completely separate online systems.

How to Convert TD Bank OFX to Excel

OFX is a structured data file. A converter that handles OFX will read the file and produce a clean Excel file with the transactions.

The output has Date, Description, Amount, and Balance as separate columns. For credit cards, there is an additional column for the merchant category code. The date format is YYYY-MM-DD. The amount format is positive for deposits, negative for withdrawals.

The conversion takes 5 to 10 seconds per file. The output is clean. You can open it in Excel or Google Sheets and start working with the data immediately. For QuickBooks users, the OFX is the cleanest path. Our QuickBooks conversion guide covers the import dance.

How to Convert TD Bank PDF to Excel

PDF is harder. The transactions are in a 4-column table inside the PDF. A converter needs to recognize that table, extract the rows, and write them as a spreadsheet.

TD Bank’s PDF layout is standard. Most modern converters handle it. The 2am test: if the converter does not produce a clean Excel file on the first try, try a different one. A good converter should handle TD Bank’s PDF on the first try. For the broader workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check.

The output for a PDF conversion has the same columns as the OFX output: Date, Description, Amount, Balance. The date format may be MM/DD/YYYY instead of YYYY-MM-DD. Check the format and convert it in Excel if needed.

The 2am Test for TD Bank Conversions

If you are converting TD Bank statements at 2am, here is the flow that works.

1. Open tdbank.com. Log in.
2. Click the account. Click “Account Activity”. Set the date range. Click “Download”.
3. Choose OFX. Click Download.
4. If you need more than 18 months, click “Statements” instead. Download PDFs for the older months.
5. Open the OFX file in a converter. Save the output as one sheet.
6. Open each PDF in a converter. Save the output as separate sheets in the same workbook.
7. Combine the sheets in Excel or Google Sheets.

If the converter gives you a file with merged cells, broken dates, or chopped descriptions, the converter is not handling TD Bank’s format correctly. Try a different converter. The OFX format is standard, not custom. A good converter should produce clean output every time.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

What to Do With Multiple TD Bank Accounts

If you have multiple TD Bank accounts (checking, savings, money market) and need them all in one file, the workflow is the same as for a single account: download the OFX for each, convert each, combine in Excel.

TD Bank does not offer a combined statement feature. Each account is downloaded separately. The 18-month OFX limit applies per account.

For cross-border customers with both US and Canadian accounts, the workflow is more complex. The US and Canadian portals are separate, the export formats are different (OFX vs CSV), and the column structures are different. The combined file requires manual column mapping in Excel. Our batch conversion guide covers the desktop converter setup for multi-portal scenarios.

For a deeper look at the conversion step, see our general guide to converting bank statements to Excel. For QuickBooks users, see our QuickBooks-specific conversion guide. If you have multiple banks to convert at once, see our batch conversion guide. For the full map of which bank gives what, see our US bank export guide. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.