Small-business bookkeeping has a familiar failure mode: you mean to reconcile monthly, life intervenes, and suddenly you are staring at eleven months of untouched statements with year-end approaching. If those statements are TD Bank Canada PDFs with password protection, the backlog feels even worse — every file needs unlocking before it can even be read, let alone converted. This guide is the catch-up playbook for TD Bank Canada statement PDF to Excel conversion: where the password comes from, how to pull a full year from EasyWeb efficiently, unlocking the batch in one pass, stitching everything into a single master spreadsheet, and building a monthly routine so you never fall this far behind again.
Where a TD Bank Canada PDF password actually comes from
TD applies passwords to statements sent by email, and the format is described in the covering message — typically built from your personal details such as your date of birth, sometimes combined with part of your name. Statements you download yourself from EasyWeb or the TD app usually arrive without a password, which is worth knowing before you go password-hunting: the fastest fix for a locked file is often just re-downloading it from EasyWeb. Business owners should note the usual trap — the password is derived from the personal details of the individual associated with the account, not the business name, the trade name, or the account number. And if multiple people in the business download statements, each person's downloads may carry passwords built from different details, so standardize on one person's downloads for the whole year to keep the unlock step simple. The general mechanics are covered in our password-removal guide.
Step 1: Pull a year's worth of statements from EasyWeb efficiently
Log in to EasyWeb, open the account, and head to the statements or documents section. Download month by month for the full year — do not skip months you think were quiet, because a missing month breaks the continuity your books need, and "quiet" months have a way of containing the one transaction you needed. Download every account the business uses: the main operating account, any savings or reserve accounts, and business credit cards if they are part of the picture. Name files as you go — td-business-2026-01.pdf through td-business-2026-12.pdf — in a single folder for the year. This naming discipline feels fussy for about ninety seconds and then pays for itself every time you need "the March one." While you are in EasyWeb, grab the current year's statements too, so next month's routine starts from a complete set rather than another archaeological dig.
Step 2: Unlock the batch in one pass
Do all the unlocking in a single sitting, assembly-line style. Open each PDF in your browser, enter the password, press Ctrl+P, and save as a new PDF in the same folder — I use the same filename with -unlocked appended, then delete the locked originals once everything is converted, so there is never confusion about which copy is current. If a particular month's password will not work, do not let it stall the batch: re-download that month from EasyWeb (which usually arrives unlocked) and keep moving. The whole unlock pass for twelve months should take under fifteen minutes once you know the format. Keep this work on your own computer — uploading a year's worth of business banking to a random unlocking site is exactly the kind of shortcut our data-security best practices warn against, and the browser method needs no third party at all.
Step 3: Stitch twelve months into one master spreadsheet
Upload each unlocked PDF to ConvertStatement's TD Bank Canada converter and download the Excel files. TD statements are generally well structured for conversion, but verify each month as you go: dates continuous, amounts correctly signed, opening balance matching the PDF. Then build the master sheet: paste every month's data rows under the first month's headers, keeping column order identical, and add the columns that make it a bookkeeping file — Category, Vendor, and Tax note. Now do the catch-up categorization in one focused session. It is tedious, but it is also the session that recovers the year: with everything categorized, you can see total revenue, total expenses by category, and the figures your tax preparer needs. Sort by amount descending and review the largest fifty transactions personally — in a catch-up year, the big items are where errors and surprises hide. When the sheet is complete, reconcile it against your records and the PDFs before it goes anywhere near a tax filing. For CSV output that drops straight into accounting software, see our CSV conversion guide.
Step 4: Build a monthly routine so this never happens again
The catch-up is the painful part; the maintenance is trivial. Put a recurring thirty-minute block on your calendar for the first week of each month: download the new statement from EasyWeb, unlock it if needed, convert it, paste the rows into the master sheet, and categorize while the transactions are still fresh in your memory. Thirty minutes monthly beats a lost weekend annually, every time. Keep the master spreadsheet in a backed-up location with a password on the file itself, and keep one clean archive of the year's PDFs alongside it. Future you — the one closing the year in an afternoon instead of a month — will be grateful.
Frequently asked questions
What is the password on a TD Bank Canada statement PDF?
It is based on your personal details and stated in the covering email. Statements downloaded directly from EasyWeb or the TD app usually have no password, so re-downloading is often the fastest fix.
Can I convert all twelve months in one upload?
Convert each PDF separately, then merge the Excel outputs into one master sheet as described above. Identical column order across months makes the merge a clean copy-paste.
What if two statements cover overlapping dates?
Delete the overlapping rows from one of them before merging. Duplicates from overlapping periods are the most common cause of books that will not reconcile.
How do I handle transfers between my own TD accounts?
Record each transfer once and do not categorize it as income or expense — it is your own money moving. Make sure both sides of every transfer are present in the master sheet.
A year of neglected bookkeeping feels overwhelming until you break it into the assembly line: download, unlock, convert, merge, categorize. Start the line today with ConvertStatement — free for your first files — and turn this year's scramble into next year's thirty-minute routine.