TD Canada Trust Statement to Excel Converter

TD adds a detail for cards: a credit card closed with an outstanding balance keeps producing statements until the balance is paid in full, and those statements then stay in the repository for 12 months beyond the payoff date. A card closed with a zero balance drops off after 12 months.

For anyone working out what was paid on a closed card — a debt negotiation, a separation, an estate — those payoff statements are the record. Converted, they show every payment and interest charge in one column, proved against the previous and new balance.

The opening balance plus every signed transaction must equal the closing balance. FlowParse checks that on every TD statement, and checks each row against the running balance where it is printed. A deposit read as a withdrawal, or a line lost where a page breaks, fails at the row where it happened.

Statements that pass are marked reconciled; anything else is shown in the preview with the difference before you download.

TD's retention rules cover business deposit accounts alongside personal ones — 18 months after closing. For a small business changing banks, or a corporation winding down, that is the window to download the old account's statements.

Converted, they give the accountant the closing months of the old account in one sheet, proved against TD's balances, ready to merge with the new bank's statements so the year-end has no hole.

For a T1 return with business or rental income, a T2 corporate return, or a mortgage renewal, Smart Merge takes up to 100 TD PDFs — chequing, savings, line of credit, credit card — and builds one workbook with every transaction in date order, the account and source file on every row, and a check that each closing balance is the next opening balance.

Statements from RBC, Scotiabank, BMO, CIBC or Tangerine can be merged into the same workbook, matched column by column.

Canadian bookkeepers mostly work in QuickBooks Online, Xero or Sage. FlowParse exports a QBO file QuickBooks imports as bank transactions, a CSV for Xero or Sage, and an Excel file for review first.

The description stays whole — the e-Transfer sender, the bill payee — so each line can be matched to an invoice or a receipt, and coded for GST/HST, after import.

Withdrawals and deposits are unsigned columns; pasted into one list, they all become positive. A Canadian date can be printed day-first or month-first depending on the document, and a spreadsheet guesses. A bill payment with a long payee name wraps over two lines and becomes two rows.

FlowParse signs by column, writes unambiguous dates and keeps one transaction per row; the balance proof confirms nothing was split or dropped.

Two partners separating need two years of their TD joint chequing account and each one's credit card to divide expenses. The joint account was closed seven months ago. The figures here are an illustration, not a real couple's.

Still inside the 18-month window, one partner saves the joint account's statements from the repository, adds both cards' statements, and uploads them. FlowParse returns one workbook, each statement proved, each account's chain complete. Filtering by payee shows the mortgage payments, the shared bills and the transfers between accounts; both lawyers get the same sheet, and the PDFs behind it.

Coverage: each closing balance equal to the next opening balance, per account — quiet months included. Closed accounts: saved within their 12- or 18-month window. Reconciled: every statement proved before its totals are used.

And keep the PDFs. The converted file is a working copy; the statement is the record for the CRA, a lender or a court.

Chequing, savings, line of credit, business deposit and credit card statements list transactions between two balances and convert the same way.

Annual mortgage statements, GIC and RSP statements, tax slips and letters are summaries or single figures. Keep them with the file; convert the transaction statements.

The CRA generally expects records supporting a return to be kept for six years from the end of the tax year they relate to. TD's seven-year EasyWeb window covers that while the account is open — but not after it closes, when the window drops to 12 or 18 months.

So keep your own copies. A folder of saved TD PDFs, converted to one proved workbook per year, is both the record the CRA may ask to see and the data your accountant can work with.

TD offers email notifications when your online statements are ready to view. Treat each one as a reminder: open EasyWeb, save the PDF into the account's folder, and move on.

A year of that habit costs twelve minutes and leaves you with complete, original statements no matter what happens to the account later. At year end, one upload turns the folder into a single proved workbook, with nothing missing and nothing retyped.

TD produces monthly statements for personal lines of credit and home equity lines of credit, except in months with a zero opening balance, a zero closing balance and no transactions. When a line of credit is closed, TD keeps its statements for 18 months if you closed it, and for 30 months if TD closed it.

A HELOC statement lists advances, payments and interest between two balances, so it converts like a bank account. Merged with the chequing account that funds it, the payments line up on both sides, and the interest charges sum to the cost of the borrowing for the year.