TD Bank Statement to Excel Converter

We could not find a definition of "IO" in anything TD Bank publishes — not on its Online Banking pages, not in its guide to reading a bank statement — and we will not guess one. A two-letter code can be a TD transaction type, part of a merchant's or payer's name cut short by the description field, or a code from a different bank altogether. The same letters mean different things on different statements, so a meaning copied from a forum can be confidently wrong.

Here is how to pin it down for your own line. Read the whole description, not just the code: the payee, the reference and the amount usually say more than the abbreviation. Match the date and amount against what you know — a payroll deposit, a transfer you made, a bill. Check which bank issued the statement: the letters "TD" appear in other banks' codes too, so a "TD IO" line is not necessarily from TD Bank. If it is a TD statement and the line is still unclear, ask TD directly; TD's Online Banking page lists 1-888-751-9000.

Converting the statement helps with the matching, not the meaning: once every line is a row, you can filter all lines that carry the same code and see what they have in common — the same counterparty, the same weekday, the same amount — which is often the fastest way to recognise a recurring transaction.

TD's own guide to bank statements walks through the parts most US statements share, while noting that layouts vary by bank: an account summary with the starting balance, total deposits and credits, total withdrawals and debits and the ending balance; account information with your name, account number and statement period; a chronological transaction history with dates, descriptions, check numbers and amounts, sometimes with a running balance; a fees section; a check summary or check images; and interest earned, where TD notes that the year-to-date figure on a December statement previews your 1099-INT.

TD's guide also suggests the order to read it in: confirm the statement period, check that the beginning balance matches last month's ending balance, scan withdrawals for unfamiliar merchants and tiny "micro-charges", confirm deposits arrived in full, and review fees. Among the abbreviations it uses are POS, for point-of-sale purchases made with a card, and NSF, as in overdraft and NSF (non-sufficient funds) fees; ATM needs no explanation.

The balance checks in that list are exactly what FlowParse automates: beginning balance plus every transaction must equal the ending balance, and each converted statement must start where the previous one ended. A broken chain shows you the missing month or the misread line before the numbers go anywhere.

TD's Online Banking page says you can download your TD Bank account information directly to Quicken or QuickBooks, with balances and transaction history for checking, savings and money market accounts. For day-to-day bookkeeping that keeps software up to date, that connection is the natural tool.

The statement PDF earns its place in other moments: when an accountant closes a past year and wants the figures tied to the bank's own statements, when a lender wants statements rather than a software report, when an account is one TD doesn't deliver electronically, or when you are rebuilding months that were never synced. Converted, those statements export as a QBO file for QuickBooks, a CSV for Xero, or an Excel workbook — each one proved against its printed balances. The free plan covers 10 pages a month.

Before a TD statement is called reconciled, FlowParse takes the beginning balance, adds every signed row and compares the result with the ending balance. Where a daily balance is printed, each row is checked against it too.

If a check was skipped or a deposit read with the wrong sign, the totals stop meeting, and the preview shows the gap — before the file reaches QuickBooks.

TD Online Banking includes Bill Pay and Zelle. On the statement, Zelle payments and Bill Pay disbursements appear among the debits with their own descriptions.

Converted, those lines filter in one step: every Zelle payment to a contractor, every Bill Pay to a utility. For a landlord or a small business, that's half the year's expense list.

Where a TD statement prints check numbers, FlowParse keeps each one in its own column.

Sort by number after conversion and gaps appear — checks written but not yet cleared, or voided — ready to match against the register.

TD Bank serves small businesses along the East Coast. Their bookkeeping is usually QuickBooks, and the bank reconciliation needs statements that tie to the ledger.

The QBO file imports into QuickBooks Online and Desktop as bank transactions; each statement has already been proved against TD's own balances, so a reconciliation difference points at the books.

Smart Merge takes up to 100 PDFs and lays them out in date order. It checks the chain: each ending balance must be the next beginning balance.

A missing month breaks the chain at exactly that point, and with seven years online, the missing statement is usually one download away.

A landlord with three units in New Jersey collects rent into a TD checking account and pays contractors by Zelle. For Schedule E she needs the year's rents and repairs. The figures here are an illustration.

She downloads twelve statements and uploads them. FlowParse returns one proved workbook; rents filter by tenant, Zelle payments by contractor, and the tax preparer gets a CSV.

Check coverage: every month present, each ending balance equal to the next beginning balance. Check the window: anything older than seven years must come from saved PDFs or paper. Check reconciliation: every statement proved before its totals are used.

Keep the PDFs. The spreadsheet is a working copy.

The IRS generally asks you to keep records behind a return for three years after filing, longer in some cases. TD's seven years online covers that while you bank with TD.

If you move banks, download the statements first — your own folder outlasts the relationship.

The TD Mobile Banking App deposits checks by photo. On the statement, a mobile deposit appears as a credit like any other deposit.

Converted, deposits sort by amount and date, so you can match each one with the check image you kept and with the invoice it paid.

TD savings and money market statements carry deposits, withdrawals and interest. Merged with checking, transfers between them pair up and can be excluded.

Interest lines filter out for the year — the figure to compare with the 1099-INT.

Because TD sends paper by default, many customers have paper statements for periods they never downloaded. Scanned flat, they convert through OCR and are proved against their printed balances.

A misread digit shows up as a balance that doesn't close.

TD Bank is TD's US bank; TD Canada Trust is its Canadian counterpart, with its own online banking and statements. Cross-border customers often hold both.

Both convert, and Smart Merge keeps each statement's currency on every row, so US and Canadian dollars never mix in one total.

The QBO file imports into QuickBooks as bank transactions with the description and check number on each line; the CSV carries the same columns for Xero or a spreadsheet.

Each statement was proved against TD's own balances first, so a difference in your reconciliation points at the bookkeeping, not the conversion.

If you'd rather not receive paper statements, TD lets you change the setting in Online Banking or the mobile app at any time. Online statements keep coming either way.

Going paperless makes a monthly download habit more important — the PDF becomes the only copy you hold yourself.

TD's online archive of notices starts later than its statements: notices issued on or after March 2015. Overdraft notices, change-of-terms letters and similar documents from before then exist only on paper.

If a dispute turns on an old notice, the statement from the same month is still the best evidence of what actually happened on the account — and converted, it shows the exact transactions the notice was about.

Picking statements by account and date in TD Online Banking makes it easy to fetch one month at a time. For a full year, download each month in turn and keep the original file names.

FlowParse reads the dates from the statements themselves, so even if the files are named inconsistently, Smart Merge puts the rows in the right order and the chain check confirms nothing is missing between them.

TD Online Banking includes TD Alerts for balances and transactions. Alerts are useful in the moment, but they aren't a record you can hand to anyone.

The monthly statement is. Converted, it gives you the same transactions the alerts told you about, in order, with a balance proof behind them.