How to Convert a TD Bank Statement PDF to CSV

TD Bank gives you two paths to get your transaction data into a spreadsheet: a built-in CSV download for recent activity, and a PDF converter for anything older. Here is how to use both.

Getting TD Bank transactions into a spreadsheet is usually straightforward for the past year or so. The problem shows up when you need data from an older period - say, for tax prep covering the previous year or a reconciliation that goes back 18 months. TD's download tool has a cutoff, and the only thing available past that point is the PDF statement. Converting that PDF cleanly requires more than a simple copy-paste.

Method 1: Export a CSV directly from TD Bank online banking

For recent transactions, TD Bank's online portal is the fastest route. No conversion needed - you download a file that is already formatted as a spreadsheet.

Steps to download the CSV

• Log into tdbank.com and navigate to the account you need.
• Click View Activity or open the account's transaction history.
• Look for a Download or Export option - it typically appears near the date filter or at the top of the transaction list.
• Choose CSV or Microsoft Excel as the format and set the date range you need.
• Download the file and open it in Excel, Google Sheets, or Numbers.

The downloaded CSV from TD Bank includes columns for date, description, debit amount, credit amount, and running balance. If you are importing into another tool, you may need to merge the debit and credit columns into a single signed amount column - debits as negative, credits as positive.

TD's activity export generally reaches back 12 to 18 months. The exact window depends on your account type. If you need data older than that, move to the PDF method below.

Method 2: Convert a TD Bank PDF statement to CSV

For periods outside the download window, TD Bank keeps official statement PDFs in the Statements section of online banking - typically covering several years of history. Converting these to CSV takes a few extra steps, but it is reliable and works for any period on record.

Step 1: Download the PDF statement from TD Bank

• Log into tdbank.com and go to the Statements or eStatements section of your account.
• Find the statement period you need and click to download the PDF.
• Save it somewhere easy to find - your desktop or a dedicated folder for financial documents.
• Repeat for each additional statement month you need to cover.

Step 2: Extract the transactions

TD Bank PDF statements are well-formatted but use a multi-column layout with separate debit and credit columns, a running balance, and section headers that break up the transaction table. Copy-pasting into a spreadsheet typically produces a mess: descriptions run together, amounts land in the wrong columns, and the balance column adds noise you do not want.

A dedicated PDF converter reads the structure of the TD Bank statement layout and produces a clean, row-by-row output with the right columns. The result is a CSV where each row is one transaction: date, description, and amount - ready to sort, filter, or import.

Quill parses TD Bank statement PDFs locally on your computer. Drop in the file and it extracts every transaction and lets you export to CSV - no upload, no account connection, no subscription.

Step 3: Clean up and use the CSV

Once you have the CSV, a few quick checks are worth doing before you import it anywhere:

• Check the transaction count. Compare to the number of transactions listed on the original statement to confirm nothing was missed.
• Review amounts. TD Bank statements list debits and credits in separate columns. Most converters will produce signed amounts (debits negative, credits positive). Verify a few rows against the original to confirm the signs are correct.
• Handle pending items. If the statement PDF was downloaded mid-cycle, it may include pending transactions that are later adjusted. For a completed statement, this is not a concern.

TD Bank-specific quirks to know

A few things about TD Bank statement formatting that can trip up conversions:

TD Convenience Checking vs. TD Beyond Checking

TD Bank offers several checking account types. The statement layout is broadly consistent across them, but the header section and account details differ. A converter that recognizes the TD Bank format handles all account types correctly without any manual adjustment.

Monthly fee and interest lines

TD Bank statements include monthly maintenance fees, overdraft charges, and any interest earned as separate line items in the transaction table. These will appear in your CSV as normal rows. For bookkeeping purposes, it is worth tagging them as bank fees or interest income rather than leaving them as general expenses.

TD Bank business account statements

TD Business Checking and TD Business Simple Checking statements follow the same column structure as personal checking, so the same conversion approach works. The statement may include additional sections for service charge summaries or average daily balance calculations - these appear at the end and are not transaction rows, so a good converter ignores them correctly.

Joint accounts

TD Bank joint account statements list all transactions for both account holders in a single transaction table, which is what you want for a complete record. There is no per-holder filtering at the statement level.

When to use which method

A quick reference for choosing the right approach:

• Transactions from the past 12 to 18 months: Use TD Bank's built-in CSV export. It is the fastest path and requires no conversion.
• Older history or a specific statement period: Download the PDF from TD's Statements section and convert it with a local tool.
• Ongoing tracking: The CSV export works well for regular downloads - set a reminder to export monthly if you want to keep a local record in sync with your account.

If you need to get the resulting CSV into QuickBooks, see our companion guide on importing TD Bank statements into QuickBooks.