RBC statement PDF to Excel: CAD, USD, and bilingual labels

RBC (Royal Bank of Canada) sends statements as PDFs only. If you want the rows in Excel for bookkeeping or a tax return, the PDF has to be converted. Here is the workflow for CAD and USD accounts, bilingual statements, and Avion or Cash Back cards.

Why this is annoying (the manual way)

Open an RBC PDF, drag-select rows, paste into Excel. The transit and account number from the header drop into the first data row. Dates come out as YYYY-MM-DD on newer statements and MM/DD on legacy ones, so a year of files gives you mixed formats. On a French statement the column labels read Date, Description, Débit, Crédit, Solde, and a US-built tool either fails or relabels everything in English in the wrong order. Cleanup runs 15 to 25 minutes per file.

The 30-second method with Bank2XL

Bank2XL is a Chrome extension. One drag, one click.

1. Install Bank2XL from the Chrome Web Store at bank2xl.app
2. Download the PDF from RBC Online Banking or the credit card portal
3. Click the toolbar icon
4. Drag the statement onto the drop zone
5. Click "Convert to Excel" and download the .xlsx or .csv

Free during beta: 10 statements a day, no signup. A typical RBC PDF converts in 25 to 45 seconds.

What about RBC format quirks

RBC statements have a few things US-built converters do not expect:

• CAD is the primary currency, but RBC also offers USD-denominated accounts for Canadian residents and RBC Bank US accounts. Each row keeps its real currency in the Currency column instead of being treated as USD by default.
• RBC issues statements in English and French. French column labels read Date, Description, Débit, Crédit, Solde. Bank2XL keeps labels in the language they appear in (we do not relabel Débit to Debit), so the output matches the source.
• Account identification uses a 5-digit transit number plus a 7-digit account number, not a US 9-digit routing number. Both go into account metadata.
• Date format varies by statement era. Newer statements use YYYY-MM-DD (ISO); older ones use MM/DD/YYYY. Bank2XL detects the format from the header rather than assuming.
• RBC credit cards (Avion, Cash Back, WestJet, ION) print Statement Period and Payment Due as separate header dates. Those go into account metadata, not into a transaction row.

When to use the alternatives

• Manual copy-paste. Fine for one statement. Tedious across a year, and the bilingual case usually means re-doing column headers by hand.
• Adobe Acrobat Pro Export to Excel. Workable on English PDFs with cleanup. French statements often need column headers retyped.
• Template-based converters. Accurate if the template matches your exact card or account type. Avion and WestJet layouts were refreshed in 2024 and template tools needed updates. We work without per-bank rules, so layout changes do not break extraction.

FAQ

Is the upload secure? My statement has my transit and account number. The PDF goes to the extraction backend over HTTPS. We process files in memory, auto-delete within 24 hours, and you can opt out in Settings. Details at /data-retention.html. Account numbers are masked in the output by default, and we do not train AI on your content or share it.

Does it work on French statements? Yes. The column labels stay as Débit, Crédit, Solde so the output matches your source. Transactions extract the same way as on English statements.

What about RBC credit cards (Avion, Cash Back, WestJet)? Same workflow. Card statements use a different layout from chequing accounts, with a Payment Due section and reverse-polarity balance. Bank2XL detects the statement type and applies the right logic.

Get started

Install Bank2XL from the Chrome Web Store at bank2xl.app. Free during beta: 10 statements a day, no signup. Drop an RBC PDF, click Convert, get an Excel file with the right currency per row and labels in their original language.

← Back to all guides