Convert an RBC Royal Bank Statement to Excel
RBC statement layout, the bilingual English and French statements, and verifying a converted file.
Canadian bank statements bring a specific complication: many are bilingual, with English and French column headers on the same page.
Bilingual headers
An RBC statement may print "Date / Date", "Description / Description", "Withdrawals / Retraits", "Deposits / Dépôts", "Balance / Solde" — two languages in each header cell.
A converter matching header text against a list of expected English words may fail on the combined string, or match the wrong column. Header detection needs to handle the bilingual form, or work from column content rather than header text.
| English | French |
|---|---|
| Withdrawals | Retraits |
| Deposits | Dépôts |
| Balance | Solde |
| Opening balance | Solde d'ouverture |
| Closing balance | Solde de clôture |
| Cheque | Chèque |
Canadian date conventions
Canada uses several date formats in practice — YYYY-MM-DD in official contexts, DD/MM/YYYY in French Canada, MM/DD/YYYY under US influence. All three appear on real statements.
Verifying
Beyond the usual chain and totals checks, confirm the dates fall inside the statement period. Given the date ambiguity, that is the fastest way to catch a wrong reading.
What the RBC export contains
| In the file | What you get |
|---|---|
| RBC's own columns | Every heading as printed, bilingual headings included, in the same order |
| Dates | Exactly as printed. In Canada, where three date orders are in use, that means nothing has been guessed |
| Descriptions | In full, cheque numbers and e-Transfer messages included, with wrapped lines joined into one cell |
| Withdrawals / Retraits and Deposits / Dépôts | Each figure in the column RBC printed it in |
| Balance | Where RBC prints one, and what the Completeness sheet checks the rows against |
Interac e-Transfer rows
Interac e-Transfers carry the counterparty name and often a message the sender typed. Both are more useful than a typical card descriptor, and the message frequently contains an invoice or reference number.
Pending and cancelled e-Transfers can also appear. A transfer sent and then reclaimed produces two rows — a debit and a matching credit — which are both real and must not be deduplicated away.
Frequently asked questions
Are other Canadian banks supported?
The reader works from the table on the page rather than a list of banks, so a statement from any Canadian bank is read the same way. The Completeness sheet tells you whether yours came out right.
Why does my statement show a transfer twice?
Usually a sent-and-reclaimed e-Transfer — one debit, one matching credit. Both are genuine and both should appear.
Will French-only statements convert?
Yes. Column identification does not depend on English header text.
Related posts
- Convert a UOB Bank Statement to Excel
- Convert a Philippine Bank Statement to Excel
- Convert an ADCB Statement to Excel
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.