How to Import TD Bank Statements into QuickBooks

TD Bank works with QuickBooks through a live bank feed, a downloadable OFX or CSV export, and a PDF statement archive. Here is how to use each one, and what to do when you need data older than the download window.

TD Bank's export options are more flexible than most people realize. Beyond the standard CSV download, TD offers OFX files that feed directly into QuickBooks Desktop without any extra conversion step. But all of TD's download options share the same limitation: they cover a fixed window of recent history. For anything older, the PDF statement is your only source, and that requires a different approach.

Route 1: Live bank feed in QuickBooks Online

The most convenient ongoing setup is connecting TD Bank directly to QuickBooks Online. New transactions pull in automatically, and you categorize them inside QuickBooks at your own pace.

To set up the connection:

• In QuickBooks Online, go to Banking (or Transactions), then click Link account.
• Search for TD Bank and authenticate using your TD Bank online banking credentials.
• QuickBooks will import approximately 90 days of recent history as an initial batch, then sync new activity on an ongoing basis.

Important limitation: the live feed only reaches back to the point where the connection was established. If you connect today and need transactions from six months ago, those will not appear through the feed. Use the export or PDF route below for any historical period.

Route 2: TD Bank OFX export for QuickBooks Desktop

TD Bank's activity download includes an OFX format option, which is the standard Web Connect format that QuickBooks Desktop imports natively. This is the most direct path for QuickBooks Desktop users who need recent TD Bank history without setting up a live feed.

Exporting from TD Bank

• Log into tdbank.com and open the account you want to export.
• Navigate to the account activity or transaction history screen.
• Click the Download or Export button and select a date range.
• Choose OFX as the file format and download.

Importing into QuickBooks Desktop

• In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files.
• Select the OFX file you downloaded from TD Bank.
• QuickBooks will prompt you to select the account to import into - choose the matching ledger account and confirm.
• Review the imported transactions and accept them into your register.

TD Bank's activity download typically covers the past 12 to 18 months. For periods outside that window, the PDF approach below is the right method.

Route 3: CSV import into QuickBooks Online

If you use QuickBooks Online and prefer not to set up a live connection, TD Bank's CSV export is a clean manual alternative.

• From TD Bank's activity screen, choose CSV or Microsoft Excel as the format and download the file.
• In QuickBooks Online, go to Banking, then Upload from file.
• Select the TD Bank account you are importing into and upload the CSV.
• Map the columns: Date, Description, and Amount. TD Bank's CSV uses separate debit and credit columns - QuickBooks Online will guide you through combining them.
• Review the transactions and click Import.

A note on TD Bank's column structure: the CSV download separates debits and credits into two amount columns. When mapping to QuickBooks, treat debit amounts as positive expenses and credit amounts as negative (or income). QuickBooks Online's column mapping step makes this clear.

Route 4: Convert older TD Bank PDF statements and import

For any period outside TD Bank's activity download window, the official PDF statement is the only available data source. Getting that into QuickBooks requires two steps: extracting the transactions from the PDF, then importing the resulting CSV.

Step 1: Download the PDF from TD Bank

• Log into tdbank.com and navigate to the Statements or eStatements section of your account.
• Find the month you need and download the PDF. TD Bank typically keeps several years of statement history available online.
• Save the PDF locally and repeat for each additional month you need.

Step 2: Extract transactions with a local converter

TD Bank PDF statements use a formatted table layout with separate debit and credit columns, a running balance, and page-level headers that do not copy cleanly into a spreadsheet. A dedicated converter reads the TD Bank layout and produces clean, structured rows: one transaction per line, with date, description, and amount.

Quill parses TD Bank statement PDFs locally on your computer. Drop in the file and it extracts every transaction and exports to CSV - ready for QuickBooks import. No upload, no cloud account, no bank login required.

Step 3: Import the CSV into QuickBooks

For QuickBooks Online:

• Go to Banking, then Upload from file.
• Select your TD Bank account, upload the CSV from Quill, and map the Date, Description, and Amount columns.
• Review and confirm the import.

For QuickBooks Desktop, convert the CSV to IIF format using QuickBooks' Import Data tool, or use the manual journal entry route for small batches.

Handling TD Bank credit card statements in QuickBooks

TD Bank credit card statements work differently from checking statements, and there are a few things worth knowing when importing them into QuickBooks:

• Payments to the card appear as credits in the statement. Do not treat them as income - tag them as credit card payment transactions in QuickBooks to keep your books balanced.
• Interest charges and fees show up as separate line items. Assign them to a bank charges or interest expense category rather than lumping them with regular purchases.
• Cash advance fees and any associated interest appear as distinct entries. Keep them separated from the cash advance transaction itself.

For a focused guide on getting your TD Bank statement into spreadsheet format without the QuickBooks step, see our companion guide on converting TD Bank PDF statements to CSV.