Every accountant has a story about the client who emailed twelve password-protected PDFs the night before a filing deadline — and every one of those stories ends with a rush fee. If you bank with the Royal Bank of Canada, converting your RBC bank statement PDF to Excel before anything goes to your accountant is one of the cheapest ways to keep your professional fees down and your filings on time. The locked PDFs are the bottleneck: accountants cannot efficiently work with files they cannot open, search, or import. This guide covers unlocking RBC statements, converting them in batches, cleaning up the bilingual descriptions, and reconciling before anything gets filed.
How RBC password-protects its statements
RBC applies passwords to statements delivered by email, and the format is described in the covering message — it is typically derived from your personal details, such as your date of birth, sometimes combined with other identifiers. Statements downloaded directly from RBC Online Banking or the mobile app usually arrive without a password, so if you are staring at a password prompt, check where the file came from first: re-downloading from online banking is often faster than hunting for the password. One RBC-specific wrinkle: if you hold accounts in both English and French interface settings, the covering email describing the password format may itself be bilingual, so read the whole message before assuming the format is missing. And as with every bank, the password is case-sensitive with meaningful leading zeros — details our password-removal guide covers in full.
Step 1: Crack your own password puzzle
Work through this in order and you will almost never need to call anyone. First, find the original email and read the password instructions completely — most people skim, miss the format, and then spend twenty minutes guessing. Second, enter it exactly: copy the name portion letter-for-letter as it appears on your RBC profile, and write dates with all leading zeros. Third, remember that the password follows the details RBC has on file now; if you recently updated your name or corrected your date of birth with the bank, older statements may use the old details while new ones use the new. Fourth, if you are handling statements for a small business account, the password is still derived from a person's details — the authorized individual who requested the statement — not the business name. If three careful attempts fail, stop and re-download the statement from RBC Online Banking instead of hammering guesses into the file. A fresh download is free and usually arrives unlocked.
Step 2: Convert a stack of RBC PDFs in one session
Unlock each PDF with the browser method — open in Chrome or Edge, enter the password, Ctrl+P, save as PDF — and save the unlocked copies into one folder, named consistently: rbc-chequing-2026-01.pdf through rbc-chequing-2026-12.pdf. Then upload them one by one to ConvertStatement's RBC converter and download the Excel files. Work in a single session while the routine is fresh: unlock all twelve, then convert all twelve, then merge. Merging is simple — paste the data rows from each month under the first, keeping column order identical. Before you go further, verify the merge: the row count should roughly match twelve months of activity, dates should run continuously with no gaps, and the closing balance of the merged sheet should equal the closing balance on the December PDF. A broken merge handed to an accountant is worse than no merge at all, because they will bill you for finding it. Our PDF-to-Excel conversion guide has the general verification checklist.
Step 3: Tame the bilingual descriptions for your accountant
RBC transaction descriptions can appear in English or French depending on the merchant and the processing channel — "PAIEMENT FACTURE" one line, "BILL PAYMENT" the next — and sometimes both languages show up for the same payee across months. Your accountant's categorization rules, whether human or software, work best on consistent text. Add a Payee column to your merged sheet and normalize: pick one language per payee and stick with it for the whole year. This is also the moment to expand cryptic descriptions — "POS 847392 TORONTO" means nothing in March, so annotate it now while you can still check the RBC app for what it was. Group recurring items with consistent labels: all twelve months of the same insurance debit should read identically. Accountants consistently say this cleanup is what separates a file they can process in an hour from one that takes a day — and the day gets billed. See bank statement analysis for accountants for what happens on their side of the desk.
Step 4: Reconcile before anything gets filed
With the sheet merged and descriptions normalized, do a final reconciliation pass. Confirm the opening balance matches January's PDF and the closing balance matches December's. Scan for duplicates — a merged sheet built from overlapping statement periods is the classic source of double-counted months. Check that transfers between your own RBC accounts are not categorized as income or expenses; money moving from chequing to savings is not revenue. Only when the sheet ties out should it go to your accountant, and send it through their secure portal, never as a plain email attachment — a full year of banking data is exactly what our data-security best practices are written to protect.
Frequently asked questions
What is the password for an RBC statement PDF?
It is derived from your personal details and stated in the covering email. If you cannot find the email, re-download the statement from RBC Online Banking — those copies typically have no password at all.
Can my accountant work with the locked PDFs directly?
Technically they can open them if you share the password, but they cannot efficiently import, search, or reconcile locked files. An unlocked, converted Excel sheet saves them hours — and saves you fees.
Do I need to convert every account, or just chequing?
Convert every account your accountant needs: chequing, savings, and any business accounts. Transfers between your own accounts must all be present, or the books will not reconcile.
Is it safe to remove the password from my statements?
Yes, for your own files on your own devices. Keep the unlocked versions in a secure folder and share them only through secure channels.
Your accountant will notice the difference immediately: clean Excel instead of locked PDFs, consistent payee names, a sheet that reconciles. Do the unlock-and-convert pass once with ConvertStatement — free for your first files — and turn next year's filing from a scramble into a handoff.