Convert RBC Royal Bank statement to CSV for Xero — accurate & reconciled

How RBC statements are structured

RBC statements will feel familiar if you have seen a US big-bank statement: an account summary with opening and closing balances, then activity in labeled sections — deposits, withdrawals, and a cheques-paid area — with dates, descriptions, and a single amount column whose direction comes from the section header. Amounts are in Canadian dollars. Two details are worth watching: cheque numbers print beside the amount and need to stay searchable, and Interac e-Transfer descriptions carry sender and reference text that can wrap onto a second line. Our engine assigns debits and credits from the section a row falls in, keeps cheque numbers in the exported description, and merges wrapped e-Transfer lines before export. Reconciliation then runs the standard math: opening balance plus every extracted transaction must equal the closing balance printed in the summary. If the statement's own figures do not line up with what was extracted, the results page reports the exact difference — nothing is rounded away or adjusted quietly. RBC savings and business statements share the same sectioned structure and convert identically.