RBC statement to Excel: convert any Royal Bank PDF in 60 seconds

If you bank with Royal Bank of Canada and you're tired of retyping every line off your PDF statement into Excel, this is the lazy way to do it. Drop the PDF on Balancely and you get back a reconciled, four-sheet workbook in under a minute — Summary, All Transactions, Vendor Summary, and Categories. No regex template per statement layout, no manual sign cleanup, no copy-paste.

Balancely is built specifically for Canadian statements. RBC is one of the issuers we test against on every release. Here's how it works for RBC customers and what you can do with the output.

The 60-second flow

1. Sign up at balancely.ca/signup (free, no credit card).
2. Hit Convert, pick Credit card or Bank, drag your PDF onto the dropzone.
3. Wait 30–90 seconds while Statement AI reads every transaction.
4. Spot-check the preview tabs. Categories auto-fill from any rules you've saved previously.
5. Click Download ▼ and pick a format — Excel (.xlsx), CSV, or QuickBooks (.qbo).

That's it. The workbook lands in your downloads folder; the job appears in your history for 30 days (free), one year (Pro), or seven years (Business).

What RBC statement types we handle

• RBC Avion Visa Infinite, Visa Infinite Privilege, and the Avion Premier line
• RBC Cash Back Mastercard and Cash Back Preferred World Elite
• RBC ION Visa, Westjet World Elite Mastercard, British Airways Visa Infinite
• RBC Day-to-Day Banking, Signature No Limit Banking, and Royal Bank US Personal accounts
• Business credit card and chequing statements for sole proprietors and small corporations

If your specific product isn't listed, try it anyway. Statement AI handles arbitrary Canadian PDF layouts with the same engine and reconciler. If reconciliation fails, the workbook ships with an amber “check totals” flag so you know to double-check before forwarding to your accountant.

The four sheets, and what to expect

Summary

One row per statement. Opening balance, payments, returns, purchases & fees, interest, new balance, minimum payment, period dates, reconciled status. For credit-card statements, every cell renders as a negative outflow — summing the column equals the change in balance, which is what your bookkeeper expects. For bank statements, canonical signs are preserved. See the three-sheet workbook explainer for the full design rationale.

All Transactions

Every transaction across every uploaded PDF, sortable and filterable. Date, type (PURCHASE/PAYMENT/RETURN/FEE/INTEREST/CASH_ADVANCE), description, category, signed amount, FX note where present. Foreign-currency line continuations are folded back onto the parent transaction so RBC statements that span CAD and USD reconcile cleanly.

Vendor Summary

Top vendors by absolute spend. Description text gets lightly normalized (first 40 chars, uppercased) so “UBER EATS HELP.UBER.” and “UBER EATS HELP.UBER.COM” roll up together instead of fighting for column inches.

Categories

Aggregated by your saved vendor → category rules. The 14 default categories are tuned for Canadian freelancers — Meals (50% deductible), Vehicle & Fuel, Office Supplies, Software & Subscriptions, Professional Services, and more. Tag a Petro-Canada transaction once, and every future RBC statement auto-categorizes it. Manage rules at /dashboard/categories.

RBC layout quirks Balancely handles

• Foreign-currency continuation lines ("90.00 USD @ 1.4276 USD/CAD") fold back onto the parent transaction instead of becoming a phantom second row.
• The per-cardholder breakdown section RBC prints at the bottom of household statements is recognized as a duplicate and skipped — no double-counting.
• Returns flagged with "CR" suffix and accounting-parentheses negatives both parse to the canonical negative sign.
• Statements that span a year boundary (December → January period) get correct ISO dates without manual help.
• Account suffix is taken from the masked card-number line; works whether RBC printed the last 4, last 6, or the full 16 digits.

Exporting straight to QuickBooks

Instead of Excel, click Download ▼ → QuickBooks (.qbo) on the preview. The file is OFX 2.x Web Connect — QuickBooks Desktop and Online both accept it directly. Your category from the saved rules lands in the QuickBooks Memo field on each transaction, which is the cleanest way to surface bookkeeping context without remapping to QuickBooks' own category system.

Bookkeepers who reconcile multiple RBC accounts for clients can use the same flow per account: one PDF per upload, one .qbo per statement. Multi-statement batches export as a zipped bundle so your import workflow is one click.

Privacy and what Balancely keeps

Your PDF is processed in memory and discarded the moment the workbook is built. We don't archive RBC statements. The audit row that lands in our Postgres database contains the filename, the document type, parser confidence, reconciliation result, and a few summary totals — no individual transactions. See the security page for the full posture.

Start with one statement

The free tier gets you two conversions to start — one credit-card and one bank statement. Pro is $9.99/month for 25 PDF conversions a month; Business is $19.99/month for 60. Prices in USD. No credit card to start.

Create an account and drop your RBC statement on the dashboard. The workbook should land in your downloads folder before you finish your coffee.