How to Convert RBC Bank Statements to CSV or Excel

Why Convert RBC Royal Bank Statements?

RBC Royal Bank is Canada's largest bank by market capitalization and serves over 17 million clients. RBC PDF statements are densely formatted, packing transaction data into compact tables that are notoriously difficult to copy-paste into spreadsheets — cell boundaries break, amounts misalign, and descriptions get truncated. Whether you're a business owner reconciling monthly expenses, a freelancer tracking income, or an accountant preparing year-end reports, BankRead's AI parser reads RBC's exact layout and extracts every transaction cleanly, with date, description, and amount mapped to the correct columns.

Understanding the RBC Royal Bank Statement Format

RBC chequing statements use a landscape-oriented PDF with a two-column approach: one column for Withdrawals (debits) and another for Deposits (credits). Each transaction row shows the Date, Description, and Amount. The statement header shows the account number, transit number, statement period, and opening/closing balances. RBC Visa statements use a portrait layout with a single Amount column (negative for charges, positive for payments/credits). Transaction descriptions on RBC statements often include the merchant category code abbreviation and city.

How to Convert with BankRead

Follow these steps to convert your RBC Royal Bank PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your RBC Royal Bank online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your RBC Royal Bank Statement PDF

1. Sign in to RBC Online Banking at royalbank.com with your client card number and password.
2. Click on the account name from your accounts overview page.
3. Select 'Statements & Documents' from the account sidebar navigation.
4. Choose the statement period from the dropdown — RBC stores up to 7 years of eStatements.
5. Click 'View Statement' to open the PDF in your browser, then download/save it.

What Data Gets Extracted

BankRead extracts the following fields from your RBC Royal Bank statement:

• Transaction date (posted date)
• Description / payee (e.g., 'POS PURCHASE — SHOPPERS DRUG MART TORONTO ON')
• Withdrawals (debit amounts in the withdrawals column)
• Deposits (credit amounts in the deposits column)
• Balance after transaction
• AI-assigned category (e.g., Health & Pharmacy, Dining, Transfer)

Export Options

Once your RBC Royal Bank statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for RBC Royal Bank Statements

• RBC's two-column layout (Withdrawals | Deposits) is correctly mapped by BankRead — debits and credits go into the right columns in your CSV/Excel.
• RBC Visa statements use a single-amount column with sign notation. BankRead correctly parses payments (credits) vs. charges (debits).
• Cheque numbers appear in the description field when a cheque clears — BankRead preserves this information.
• Foreign currency transactions show the CAD equivalent on the statement. BankRead extracts the CAD amount and includes the original currency in the description.
• RBC statements may include an 'Account Activity Summary' section — this is not duplicated in the extracted transactions.

Common Issues and Solutions

• RBC's landscape PDF layout sometimes causes issues when printing — if you re-save the PDF, make sure to keep the original orientation for best results.
• Some RBC business accounts use a different statement template with additional columns for reference numbers. BankRead handles both personal and business templates.
• RBC eStatements prior to 2012 may be in image-only PDF format. BankRead automatically detects these and processes them with AI vision. You can also take a photo of a paper RBC statement and upload it directly.

Frequently Asked Questions