Convert RBC Royal Bank Statements to CSV & Excel

Upload your RBC Royal Bank statement PDF and get a clean CSV or Excel file with every transaction extracted, categorized, and formatted — ready for QuickBooks, Sage, Xero, or any accounting software.

RBC Royal Bank at a Glance

Full Name: Royal Bank of Canada

Country: Canada

Currency: CAD (Canadian Dollar)

Institution Number: 003

Date Format: MMM DD, YYYY or DD/MM/YYYY

Statement Format: PDF with transaction table

About RBC Royal Bank Statements

RBC Royal Bank is Canada's largest bank by market capitalization. Their PDF statements include account details (transit number, account number), a statement period summary with opening and closing balances, and a transaction table with dates, descriptions, withdrawals, deposits, and running balance.

Common RBC account types include RBC Day to Day Banking, RBC Signature No Limit Banking, RBC High Interest eSavings, and various credit card accounts (RBC Avion, RBC Cash Back). StatementKit handles all of them.

RBC Statement Format Details

Dates typically appear as abbreviated month-day format (e.g., "Jan 15" or "15 Jan"). StatementKit converts these to standardised YYYY-MM-DD format.
Transaction descriptions include Interac e-Transfer details, pre-authorized payments, POS purchases with merchant names, and cheque numbers.
Withdrawals and Deposits are in separate columns. StatementKit merges these into a single Amount column with debits as negative values for easy accounting.
Bilingual statements — some RBC statements include French headers or transaction descriptions. StatementKit handles both languages.

Canadian Transaction Types

RBC statements include several Canadian-specific transaction types that StatementKit handles correctly:

Interac e-Transfer — Person-to-person transfers with sender/recipient names and reference numbers.
Pre-Authorized Payments (PAP) — Recurring bill payments for utilities, insurance, subscriptions.
POS Purchases — Point-of-sale debit card transactions with merchant details.
Cheque clearances — With cheque numbers for reconciliation.
Payroll deposits — Direct deposit salary payments with employer references.

How to Convert Your RBC Statement

Download your statement from RBC Online Banking or the RBC Mobile app as a PDF file.
Upload to StatementKit — sign up for free and upload the PDF. No software to install.
Review the extracted data — StatementKit shows you all transactions with dates, descriptions, amounts, and categories.
Download your CSV or Excel file — import directly into QuickBooks, Sage 50, Xero, or Wave.

Frequently Asked Questions

Does it work with all RBC account types?

Yes. StatementKit works with RBC chequing accounts (Day to Day, Signature), savings accounts (High Interest eSavings, TFSA), credit cards (Avion, Cash Back, ION+), and RBC business accounts.

Can I import the CSV into QuickBooks?

Yes. The CSV output is formatted for direct import into QuickBooks Online and QuickBooks Desktop. Dates are standardised to YYYY-MM-DD and amounts are clean numbers.

Does it handle Interac e-Transfer transactions?

Yes. StatementKit correctly parses Interac e-Transfer deposits and sends, preserving the sender/recipient name and reference number in the transaction description.

Can it handle French-language RBC statements?

Yes. StatementKit's AI handles both English and French transaction descriptions, date formats, and banking terminology found in RBC statements.

Is this useful for CRA tax reporting?

Yes. Having your RBC transactions in CSV format makes it easy to categorize expenses for CRA tax filing, GST/HST reporting, and T2 corporate returns.