RBC Statement to CSV/Excel — QuickBooks & Xero Import
RBC gives customers a broad Statements/Documents hub for bank, card, loan, and investment documents, but those PDFs still need cleanup before they become a reliable accounting import. Exact Statement converts RBC statement PDFs into CSV or Excel while preserving Canadian banking references and balance logic.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Official RBC guidance: Statements/Documents from Accounts Summary · eDocuments stored up to 7 years · at least one previous document is immediately available after switching to eDocuments
Where To Download RBC Statements
RBC is a strong evidence page because it documents both the statement path and how eDocuments are stored over time.
Use Statements/Documents from Accounts Summary
RBC says you access account statements by opening Statements/Documents from the Accounts Summary page in Online Banking.
Multiple document types live in one hub
RBC routes bank, credit card, investment, loan, mortgage, and tax documents through the same document area.
eDocuments store up to 7 years
RBC says eDocuments are available for up to 7 years in Online Banking, while some custom statements only go back 18 months.
At least one previous document is immediate
RBC says once you switch to electronic documents, at least one previous document becomes immediately available in Online Banking.
What Usually Matters In RBC Statements
An RBC page should sound like a Canadian eDocuments page: multi-product, archive-aware, and full of cheque and Interac-style context.
Statements/Documents is broader than a single bank-account page
RBC combines multiple document categories in one place, so source clarity matters during export and cleanup.
Cheque images and references matter
RBC explicitly mentions cheque-image access and statement-context review, which makes reference retention valuable.
Canadian transaction labels differ from U.S. banks
Interac, cheque, transfer, and deposit wording need to stay intelligible after export.
Archive expectations are realistic
A 7-year eDocument window makes RBC a real historical backfill use case, especially for bookkeeping cleanup.
Target import format still requires normalization
RBC document access is strong, but QBO and Xero still need their own signed-amount and description layout.
Protected files need manual unlock
If the PDF is protected, unlock it before upload. Exact Statement does not remove RBC PDF passwords for you.
Common RBC Import Pitfalls
RBC issues usually come from multi-product document access and Canadian payment semantics, not from missing PDFs.
Pulling the wrong document type from Statements/Documents
RBC puts many document families in one hub, so users can easily grab a tax or card document instead of the bank statement they intended.
Assuming every custom document has the same archive depth
RBC says some custom statements only go back 18 months even though eDocuments in general go up to 7 years.
Cheque and Interac context lost during export
That loss makes later audit and client review harder.
Importing raw Canadian statement rows into QBO/Xero
The final file still needs proper sign and schema cleanup for the destination platform.
Preview A Cleaned RBC Export
These sample rows show Canadian current-account behavior with transfer, cheque, and Interac context kept reviewable.
| Date | Amount | Payee | Description | Reference | Transaction Type | Balance | Currency | Account ID |
|---|---|---|---|---|---|---|---|---|
| 10/03/2025 | -980.00 | Client payment | INTERAC E-TRANSFER RECEIVED | INTERAC | Debit | 5411.42 | CAD | ****4431 |
| 11/03/2025 | 1250.00 | Office rent | CHEQUE 108 | 108 | Credit | 4161.42 | CAD | ****4431 |
| 12/03/2025 | 62.40 | Staples | INTERAC PURCHASE STAPLES | INTERAC | Credit | 4099.02 | CAD | ****4431 |
| 12/03/2025 | -16.95 | Fee rebate | MONTHLY FEE REBATE | REBATE | Debit | 4115.97 | CAD | ****4431 |
| 03/13/2025 | 600.00 | CRA | BILL PAYMENT CRA | BILLPAY | Credit | 3515.97 | CAD | ****4431 |
Sample rows for preview only. RBC examples emphasize Canadian payment wording, cheque references, and eDocument review output.
How RBC Fields Map Into Accounting Imports
The cleanup goal is keeping Canadian statement context visible while ending with import-ready accounting columns.
| Field In Statement PDF | Exact Statement Output | QuickBooks Online | Xero CSV |
|---|---|---|---|
| Statement date | Normalized Date | Date | Date |
| Merchant / transfer / Interac text | Payee + Description split | Description | Payee + Description |
| Withdrawal / deposit amount | Signed Amount | Amount or Credit/Debit | Amount + Transaction Type |
| Cheque / transfer ref | Reference | Optional | Reference |
| Running balance | Balance for XLSX review | Not required | Not required |
Sources: RBC access account statement · RBC eDocuments FAQ · Intuit CSV format guide · Xero CSV import guide.
RBC Statement to CSV — Frequently Asked Questions
RBC says you start from the Accounts Summary page and open Statements/Documents to view and download your account documents.
RBC says eDocuments are available for up to 7 years in Online Banking, although some custom statements only go back 18 months.
RBC says at least one of your previous documents becomes immediately available when you switch to electronic documents.
Pulling the wrong document type from the shared Statements/Documents hub or losing cheque and Interac context during export.
Unlock it before upload. Exact Statement does not remove RBC PDF passwords for you.
Need the official help pages? RBC access account statement · RBC eDocuments FAQ · support@exactstatement.com.
Convert Your RBC Statement Now
Upload an RBC statement PDF and export a clean CSV or Excel file for QuickBooks Online, Xero, or Canadian bookkeeping review.