# TD Bank Statement to Excel: A Clean Transaction List

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2025-01-09
- Updated: 2025-01-09
- Category: Bank statements to Excel and CSV
- Canonical: https://www.fastbankconvert.com/blog/td-bank-statement-to-excel

> Turn a TD bank statement to Excel: find the PDF statement, merge its deposit and withdrawal sections, and verify the daily balance column.
To convert a TD Bank statement to Excel, download the statement PDF from TD Online Banking, convert it into rows, and merge the separate deposit and withdrawal sections into one list sorted by date. Then total each day's activity and compare it with the statement's daily balance figures, which shows any missing row.

## Downloading TD Bank statements from Online Banking

TD Bank's statements live in Online Banking and the mobile app. The bank's [Online Banking page](https://www.td.com/us/en/personal-banking/online-banking) says you can log in to review, print or download statements at any time, with free online access for up to seven years to statements issued on or after April 2010.

Seven years covers almost any personal need, from a tax question to a long mortgage application. Download each month as its own file and name it with the year and month first, so `td-checking-2025-11.pdf` sorts correctly next to `td-checking-2026-01.pdf`.

TD's own [guide to reading a bank statement](https://www.td.com/us/en/personal-banking/learning/money-management/what-is-a-bank-statement-and-how-to-read-them) describes the common parts of a statement: an account summary with starting balance, totals and ending balance, a transaction history, fees and charges, check images or a check summary, and interest earned. Of those, only the transaction history and any fee or interest lines become rows. The rest are there to check against.

### Before you convert

Open the PDF and try selecting a line of text. If single words highlight, the file has a text layer and will convert accurately. Confirm that the last page reaches the ending balance, and that the file covers a single account. Combined documents should be split by account before any totals are compared.

## Paper TD Bank statements and phone scans

The same Online Banking page notes that customers enrolled in Online Banking also receive paper statements unless they change their statement settings. If a paper copy is all you have, check online first: for any month from April 2010 onward, the PDF is likely available and converts far better than a scan.

### When scanning is the only option

For a statement that is not online, scan it flat and evenly lit. A phone works if you use a scanning mode rather than the plain camera, since scanning apps square the page and boost contrast. The guide to [using your phone as a document scanner](/blog/use-phone-as-document-scanner) covers the settings that matter for text.

A scanned page has no text layer, so every digit is recognized from the image. Expect a few misreads, and rely on the daily balance test later in this post to find them. A misread 6 that became an 8 shows up as a gap of 2, 20 or 0.02, depending on the digit's place, on exactly one day.

## Merging TD Bank deposit and withdrawal sections

If your TD Bank statement lists deposits in one block and withdrawals in another, the PDF is not one table but several. To work with it in Excel, you stack the blocks, record which block each row came from, give withdrawals a minus sign and sort everything by date.

### The steps

1. Convert the statement so every printed transaction becomes one row.
2. Add a Block column. Fill it with a name like Deposits, Withdrawals, Checks or Fees, matching the heading the row sat under.
3. Remove heading rows, column title rows repeated on later pages, and subtotal rows. Keep the subtotals in a side table for checking.
4. Add a signed Amount column: positive for deposit blocks, negative for everything else.
5. Sort by date. Within a date, keep a fixed order, such as deposits first, so the list sorts the same way every time.

### Wrapped descriptions

Electronic payments often print a description over two or three lines, with the amount only on the first. Make sure the extra lines joined the row above instead of becoming rows of their own. A row with a description and no amount, sitting directly under a normal row, is almost always a wrapped line.

## Does the TD Bank daily balance column match your rows?

Where a TD Bank statement prints a daily balance, that figure is the account's balance at the end of each day with activity. It lets you test your sheet one day at a time: the previous day's balance plus that day's signed amounts must equal the printed figure. Any day that fails holds the error.

### A worked test

The rows below are example figures, invented to show the method. The starting balance is 1,500.00.

| Date | Block | Description | Signed amount |
| --- | --- | --- | --- |
| 04/01 | Deposits | EXAMPLE EMPLOYER PAYROLL | 1,820.00 |
| 04/01 | Withdrawals | UTILITY CO AUTOPAY | -142.35 |
| 04/02 | Withdrawals | DEBIT CARD COFFEE SHOP | -6.75 |
| 04/02 | Checks | Check 318 | -400.00 |
| 04/03 | Withdrawals | ONLINE TRANSFER TO SAVINGS | -100.00 |

Make a second table with one row per date. For each date, compute the day's net with `=SUMIFS(D:D, A:A, F2)` where F2 holds the date, and add it to the previous day's computed balance.

| Date | Day's net | Computed balance | Printed daily balance (example) | Difference |
| --- | --- | --- | --- | --- |
| 04/01 | 1,677.65 | 3,177.65 | 3,177.65 | 0.00 |
| 04/02 | -406.75 | 2,770.90 | 2,770.90 | 0.00 |
| 04/03 | -100.00 | 2,670.90 | 2,610.90 | 60.00 |

The first two days tie. On 04/03 the sheet is 60.00 higher than the bank, so the sheet is missing 60.00 of money out on that day. In this example, a 60.00 ATM withdrawal printed at the foot of a page was dropped by the conversion. A gap of twice a row's amount would instead point to a sign flipped on that day, and a gap in the other direction to a row counted twice.

### Why daily is better than monthly

A month-end check only tells you that something is wrong. A daily check tells you which day. On a statement with eighty rows, that turns a long search into a look at four or five lines. For a version of this check that works row by row on any statement, see [the running balance formula in Excel](/blog/bank-statement-running-balance-excel).

## Can several years of TD Bank statements share one workbook?

Yes, several years fit comfortably in one workbook; even a busy account rarely produces more than a few thousand rows a year. Add a Statement column with the period, paste each month below the last, and confirm that each statement's starting balance equals the previous statement's ending balance. That one comparison proves no month is missing.

### Duplicates at the seams

Duplicates appear when two files overlap, for example a statement and an activity download covering the same days. Convert statements only, one per period, and the seams stay clean. If a row looks duplicated, check whether two identical charges are real, such as two equal coffee purchases on one day, before deleting.

### Columns that make a long workbook usable

A multi-year sheet needs a few columns a single month does not. A Year and a Month column, built from the date with `=YEAR()` and `=TEXT(A2,"yyyy-mm")`, let a pivot table total any period in one step. A Statement column holding the file name tells you where to look when a row seems odd. Turn the range into an Excel table with Ctrl+T, so formulas and filters extend automatically as you paste new months below.

Keep the raw converted rows on one tab and any categories, notes or reports on others. When a later statement shows that an earlier conversion was wrong, you can replace one month of raw rows without disturbing everything built on top of it.

### Very long files

If you merged a year of PDFs into a single document before converting, some tools struggle with the length. The guide on [converting a large PDF to Excel](/blog/convert-large-pdf-to-excel) explains page limits and when splitting the file first saves time.

## TD Bank business statements and when to treat them differently

TD Bank business accounts carry the same basic structure as personal ones, but they often include lines that personal statements lack, such as merchant deposit batches, account analysis charges or transfers between related accounts. Those lines still convert normally; they simply need their own Type values.

### Lines to label

Give each unusual line a Type, such as Batch deposit, Analysis fee or Sweep, so totals for sales or bank costs stay meaningful. A card processing deposit is often a net figure after fees, which matters if you report gross sales. The article on [business bank statements in Excel](/blog/business-bank-statement-to-excel) goes through those lines in more depth.

### When not to convert at all

If your bookkeeping system already connects to the account and the books are reconciled, a converted statement adds little except an audit copy. Convert when you need history the connection never imported, or when someone asks for statement evidence in a spreadsheet. A lender or an auditor usually wants the bank's own document, so send the PDF alongside the sheet rather than the sheet alone.

### Doing the conversion

FastBankConvert is getting ready to open and is meant to turn a digital statement like this into rows within seconds, with a warning before download if the balances fail to add up; scanned pages take longer. [Get started](/get-started) to hear when trials begin. Whatever tool you choose, keep the daily balance test as the last step before you rely on the sheet.