Drop your RBC statement PDF and download a clean .csv file in under 30 seconds. Runs entirely in your browser — your statement never leaves your device.
Xero expects exactly Date / Amount / Payee / Description in that order, with DD/MM/YYYY dates for UK/AU/NZ tenants or MM/DD/YYYY for US tenants. Our Xero export auto-detects your region and pre-formats the file so Xero's bank-statement import accepts it on the first try.
RBC's own download options (PDF, CSV, QFX, OFX) cover the basics but don't always include Xero CSV. RBC's eStatement PDFs are text-based and include posting date, transaction date, description, debit, credit, and balance. The converter normalises RBC's DD-Mon-YY date format to a sortable ISO date so the export sorts chronologically in Excel without manual fixing.
Sign in at rbcroyalbank.com and pick the account.
Open 'eStatements' from the account menu.
Download the monthly PDF for any period in the last 7 years.
Drop the PDF into convertbank and choose Xero CSV (.csv) as the export format. Download the file — it's ready to import into Xero.
Importing a year of historical transactions into a Xero bank account.
No signup. No upload. Your RBC statement → Xero CSV in under 30 seconds.
Open converter