Convert TD Bank Statements to Excel and CSV

Why a TD Bank statement is hard to convert

The number alone does not always say whether a row is a payment or a paycheck. A bill payment of ninety dollars and a deposit of ninety dollars can look alike in the amount column. Context on the page tells them apart, and a converter that reads one line at a time never sees that context.

Outgoing money comes in several kinds. A bill payment, a cash withdrawal and a monthly fee are each listed on their own. A converter that recognizes only one kind will file the others as income, and your monthly total will be far too high.

A row does not always spell out its year. If a tool ignores the rest of the page, Excel fills in the current year, and a statement that spans the end of a year ends up with a wrong year on some rows.

Paper checks are the odd rows. A check line can hold little more than a number and an amount, which makes it easy to lose when a converter expects words in every row.

About TD Bank statements

• TD Bank offers statements as PDFs through online banking, and it also mails paper statements. Customers who keep paper copies often scan them, and a scan needs OCR before any text can be read.
• Personal and business checking accounts each get a monthly statement. People who need a full year end up with twelve files.
• The usual reasons to move one into a spreadsheet are bookkeeping, tax preparation, and proof of deposits for a lease or a loan.

How we convert it

• Money in is positive. Payments, withdrawals and fees are negative.
• Dates are returned with the full year, even when the rows themselves do not carry one.
• The second line of a wrapped description is not counted as a separate transaction.
• Scanned pages are read with OCR, and sideways pages are turned upright.
• A Balance column appears only if the file prints one. We never calculate or guess a balance.

Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.

The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.

What people do with the file

Monthly bookkeeping. Convert each statement when it arrives, paste the rows into a running workbook, and load the same CSV into QuickBooks. Because payments are already negative, the import needs no cleanup.

Cash flow for a small business. Add a month column, build a pivot table, and see which weeks carried the most deposits and which carried the most bills.

Paperwork for a landlord or lender. A single sheet with a full date on every row is easier to send than a stack of PDFs, and the reader can total the deposits in one formula.

Good to know

• Scans can contain OCR digit errors. Compare totals with the statement.
• TD Bank credit card and business account statements may be laid out differently from the checking statement described here.

Questions