How to Convert an RBC Statement to Excel or QuickBooks

RBC Online Banking and the mobile app show recent activity, but older periods, closed accounts, and prior tax years come down as PDF statements. Here's how to convert an RBC (Royal Bank of Canada) statement PDF into Excel, CSV, or a QuickBooks/Xero-ready file, scanned copies included.

Get your RBC statement PDF

1. Sign in at rbcroyalbank.com (or the RBC Mobile app).
2. Open the account and go to Statements / Documents (eStatements).
3. Choose the statement period and download the PDF. RBC keeps several years of statements online.

RBC business accounts (RBC Business) work the same way.

Convert it

1. Open Convert Bank Statements and drop the RBC PDF in.
2. Every transaction is extracted automatically — no template setup.
3. Check the balance badge: Balanced means opening balance + deposits − withdrawals equals the printed closing balance.
4. Export as Excel, CSV, OFX, or QuickBooks .QBO and import into QuickBooks, Xero, or Wave.

RBC-specific tips

• Older statements are the whole point. Feeds and downloads cover recent activity; anything older is PDF-only — the catch-up scenario this is built for.
• RBC Visa credit-card statements convert with correct charge/payment polarity, so purchases aren't read as deposits.
• Consistent dates. The export keeps one date format so the import doesn't shift transactions.
• Scanned or photographed statements work too; the balance check catches OCR misreads. See the scanned statement guide.

Is it accurate?

Every account is reconciled the way a bookkeeper would check it. If a row breaks the math, it's flagged for review instead of silently exported. Details on our security page.

FAQ

Does this work for RBC Visa statements? Yes — RBC chequing, savings, business, and credit-card statements, digital or scanned.

How far back can I go? As far as your PDFs go. RBC keeps several years online; anything you have as a PDF converts.

Is my data safe? Your PDF is never stored and never used to train AI. See our Privacy Policy.

How much does it cost? 15 free pages on sign-up. Page packs start at $12 and never expire. See pricing.

Convert an RBC statement now →

Related guides

• Convert a Scotiabank statement
• Convert a BMO statement
• Import a bank statement into Wave (CSV or OFX)
• Convert a scanned bank statement (OCR)

---

Not affiliated with or endorsed by RBC. RBC and Royal Bank of Canada are trademarks of Royal Bank of Canada. QuickBooks is a trademark of Intuit Inc.