Convert RBC Royal Bank Statements to Xero

Upload your RBC Royal Bank statement PDF to BankStmtConverter.com, and the tool extracts transaction date, description, debits, credits, and running balance into a CSV file formatted for Xero's bank statement import. Download the file and upload it to your Xero bank account's reconciliation screen to match transactions against your invoices and bills.

RBC statements list transactions with posting date, transaction details, withdrawals, deposits, and balance. The converter reads all of these fields from your PDF—whether it's a personal chequing account, business account, or credit card statement—and structures them into columns Xero expects: date, payee/description, reference, debit, and credit amounts.

How do I convert an RBC Royal Bank statement to Xero CSV?

1. Download your RBC statement PDF from RBC Online Banking (Accounts > Account Activity > Download Statements).
2. Go to BankStmtConverter.com and upload the PDF file.
3. The converter extracts all transaction rows, detects column positions for date, description, withdrawals, deposits, and balance.
4. Download the CSV file formatted with headers Xero recognizes.
5. In Xero, navigate to Accounting > Bank Accounts, select your RBC account, click Import, choose the CSV file, and map columns if prompted.
6. Review imported transactions on the reconciliation screen and match them to invoices, bills, or create new transactions.

What data gets extracted from RBC statements?

RBC Royal Bank statements display transactions in a table with posting date (DD/MM/YYYY format in online statements), transaction details (payee name or description), withdrawals (debits), deposits (credits), and a running balance in CAD. The converter captures each of these fields and preserves the original description text, which becomes the payee field in Xero. Transaction amounts are recorded with two decimal precision, and the balance column is used to verify extraction accuracy—the converter checks that the final balance matches the statement's closing balance before generating the CSV.

For business accounts, RBC statements may include cheque numbers or reference codes in the description field. The converter retains this information in the output so you can match cheques and EFT payments in Xero. Credit card statements from RBC follow a similar layout with transaction date, merchant name, and amount, all extracted into the same CSV structure.

Using the CSV file in Xero reconciliation

Xero's bank statement import accepts CSV files with specific column headers: Date, Amount (or separate Spent/Received columns), Payee, Description, and Reference. The converter outputs a file matching this structure, so after upload you immediately see transactions on the reconciliation screen. Each RBC transaction appears as a line item with the posting date, the full description from your statement as the payee, and debit or credit in the appropriate column.

The reconciliation workflow in Xero compares imported statement lines against your coded transactions—invoices you've marked as paid, bills you've entered, or bank rules you've set up. When Xero finds a match (same date, amount, and contact), it suggests the pairing and you click OK to reconcile. For transactions without a match, you create a new spend money or receive money entry, assign a category or contact, and code it directly from the reconciliation screen.

If you maintain bank rules in Xero—such as "if description contains 'SQUARE' then categorize as Sales and assign to revenue account"—Xero applies these automatically to imported RBC transactions. A regular monthly subscription charge from your statement might auto-match to a recurring bill, while one-off payments require manual review. The imported balance from your CSV should align with Xero's calculated balance once all transactions are reconciled, giving you a cross-check against RBC's printed closing balance.

Handling multi-month imports and duplicate detection

If you import overlapping statement periods—say, January's statement followed by a January-February combined statement—Xero's duplicate detection compares date, amount, and description to prevent double-counting. The RBC converter preserves exact description text, which helps Xero identify duplicates. Review the duplicate warnings during import and skip any transactions already reconciled. For a 12-month backlog, import statements in chronological order and reconcile each period before moving to the next to catch discrepancies early.

CSV column mapping in Xero

On first import, Xero may ask you to map CSV columns to its fields. The converter labels columns clearly (Date, Payee, Spent, Received, Balance), so you select each dropdown to match them: Date column to Date, Payee to Payee, Spent to Money Out, Received to Money In. Save the mapping, and Xero remembers it for future RBC imports from this bank account. If your CSV includes a Reference column with cheque numbers, map that to Xero's Reference field so you can trace specific payments later.

Does it work with scanned or photographed RBC statements?

Yes. If you receive paper RBC statements or have older PDFs that are image-based (scanned or photographed pages), the converter uses OCR to read the transaction table. The OCR engine recognizes printed text in standard RBC statement layouts, extracting dates, descriptions, and amounts even when the PDF contains no selectable text. After extraction, the converter sums all debits and credits and compares the result to the opening and closing balances printed on the statement. If the calculated balance matches the statement's closing balance, the data passed OCR verification and the CSV is accurate for Xero import.

For best OCR results, ensure scans are straight and at least 300 DPI. Blurry photos or crooked scans may cause misreads in dollar amounts, though the balance check catches most errors. If a scanned statement fails balance verification, the tool flags the issue and you can re-scan at higher quality or correct the few misread rows manually in the CSV before importing to Xero.

Example: RBC chequing statement converted to Xero CSV

An RBC personal chequing statement for March 2025 shows five transactions. Opening balance: CAD $3,200.00. The statement lists:

• 01/03/2025 — Payroll Deposit — Deposits: $2,450.00 — Balance: $5,650.00
• 03/03/2025 — INTERAC e-Transfer to Jane Doe — Withdrawals: $150.00 — Balance: $5,500.00
• 07/03/2025 — Cheque #1023 — Withdrawals: $890.00 — Balance: $4,610.00
• 15/03/2025 — Pre-Authorized Debit HYDRO ONE — Withdrawals: $125.50 — Balance: $4,484.50
• 28/03/2025 — ATM Withdrawal RBC ATM #4521 — Withdrawals: $100.00 — Balance: $4,384.50

The converter outputs a CSV with Date, Payee, Reference, Spent, Received, Balance columns. In Xero, you import this file to your RBC chequing account. The payroll deposit matches an existing receive money transaction coded to owner's equity. The INTERAC transfer becomes a spend money entry assigned to a contact and drawings account. Cheque #1023 matches a bill payment already entered for a supplier. The Hydro One pre-authorized debit auto-matches a recurring bill via Xero bank rule. The ATM withdrawal is a new spend money transaction you code to owner's drawings. After reconciling all five, Xero shows a statement balance of CAD $4,384.50, matching the RBC closing balance.

Privacy and data security

Your RBC statement PDF is processed on BankStmtConverter.com's server only for the duration of the conversion. The file and generated CSV are deleted from the server immediately after you download the output. No transaction data is stored, logged for analytics, or used to train machine learning models. The conversion happens in isolation, and each upload is treated as a one-time task with no persistent record.

Related tools for RBC Royal Bank statements

If you need RBC statements in other formats, convert them to Excel for pivot tables and SUMIF reconciliation, or to QuickBooks QBO format for direct Web Connect import. For a plain text format compatible with custom scripts, use CSV output. See all supported Canadian banks for conversion options beyond RBC.