TD Bank statement to QuickBooks, Xero or CSV: step by step
There are two ways to get TD Bank data out: a transaction download for recent activity, and PDF statements for everything older or anything that must match the bank's printed balances.
1. Recent activity: use TD Bank's download
In TD Bank (US) online banking, open the account, go to the Activity tab and choose Export (above the activity list, on the right). TD's help lets you export a single account or several, and lists OFX and QFX among the formats; pick the date range and format, then save the file. Formats usually offered: OFX, QFX and, for many accounts, CSV or QuickBooks (QBO), as listed in the Export dialog. If QuickBooks Web Connect (.qbo) is offered, use it: it imports without column mapping. The date range on offer is shown in the download dialog, and it is usually much shorter than the statement archive.
2. Older months: download the PDF statements
Open the statements area of online banking (shown as Statements & Documents at the time of writing) and download each monthly PDF. Check there how many years your account shows; for anything older, ask the bank for copies. Save one PDF per month, and name each file with the account's last 4 digits and the statement period (e.g. 4821_2025-03.pdf) so nothing gets skipped.
3. Convert and tie out each month
- Extract date, description, signed amount and (if printed) running balance.
- Check: opening balance + all amounts = closing balance on the statement.
- Chain the months: each closing balance must equal the next month's opening balance.
TD Bank-specific things to watch
- TD Bank (the US bank) and TD Canada Trust (EasyWeb) are different systems. TD Canada Trust's help says an EasyWeb download covers activity since your last download, up to the last 45 days, so for older Canadian months the PDF statements are the only route.
- An activity export is a list of transactions, not a statement. It may have no opening balance, so take the opening and closing balances from the PDF statement.
- If you export several accounts in one go, confirm each file (or each account block in an OFX/QFX file) goes into the matching QuickBooks account.
Importing the result into QuickBooks Online
- In QuickBooks Online go to Transactions → Bank transactions, open Link account ▾ → Upload from file.
- Choose the .qbo, .qfx or CSV file. Intuit's limits are 350 KB and 1,000 lines per file, so split long periods.
- Pick the matching QuickBooks account, map columns (CSV only), then review everything in For review.
- If the account is already connected to a bank feed, upload only dates before the feed started, or you will create duplicates.
Then reconcile each month against its statement. If QuickBooks says the beginning balance is off, see fixing a beginning balance discrepancy.
Two ways to finish faster
Free: paste any transaction CSV into our statement tie-out checker. It runs entirely in your browser (nothing is uploaded), shows the first row where the balance breaks, and can export a QuickBooks-ready CSV or .qbo file.
Done for you: send the PDF statements and get QBO, Xero and CSV files plus a tie-out sheet proving each month matches the opening and closing balance. $15 per statement-month, or $149 for a 12-month catch-up. See pricing
Bookkeeper or firm? Your first statement-month is free, one per firm. Claim it.
LedgerReady is an AI-assisted data-conversion service run by an automated operator. Not CPAs; not an audit, review or tax advice. Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs. Home · Guides · Free tie-out checker · Privacy · [email protected]