PDF2TEXT
Try a statement free

Convert RBC Royal Bank statements to Excel or CSV

RBC keeps up to seven years of archived eStatements, so the statement you need is usually a few clicks away. The trouble starts when you copy the activity out: no year on the dates, descriptions spilling onto extra lines, and a minus sign that moves around. Here is how an RBC Royal Bank statement converts, quirk by quirk.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your RBC Royal Bank statement into Excel

  1. Download the PDF statement from RBC Royal Bank online banking

    • Sign in to RBC Online Banking.
    • From the Accounts Summary page, select Statements/Documents at the top right side.
    • On the Account Documents page, follow the instructions to download the statement.
    • Save the statement for the period you need as a PDF.
    Go to RBC Royal Bank Online Banking

  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your RBC Royal Bank statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · CAD
Sample bank statement rows with made-up data, amounts in CAD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about RBC Royal Bank statements

Two money columns, one balance per day

RBC's sample eStatement uses the columns Date, Description, Withdrawals ($), Deposits ($) and Balance ($). The two money columns become one signed amount. The balance appears only on the last line of each day, so don't expect one on every row; what matters is that the rows carry the opening balance to the closing one, and that's what gets checked.

Dates like 15 Mar, no year

Each transaction shows a day and a month, and the year lives in the statement period. The converter borrows it from there, including for statements that straddle New Year, and writes every date as YYYY-MM-DD so a year of statements sorts in order.

Merchant and location on separate lines

Many descriptions take two or three lines, with the merchant first and the location below. Treated as separate rows, they leave you with blank amounts and broken totals. They are merged back into one description per transaction.

-$125.67 or $-125.67

The minus sign doesn't always sit in the same place relative to the dollar sign. Both forms are read as the same negative number, the dollar sign is removed, and the amount lands in one numeric column with deposits positive.

Output and review

From RBC Royal Bank PDF to your books

Accounting tip

RBC's Download Transactions suits recent activity in spreadsheet software. For statement periods, upload the converted CSV to QuickBooks Online or Xero, confirming the column mapping, or import it into Sage Accounting. Reconcile each period to RBC's closing balance.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

RBC Royal Bank statement questions

Can I convert an RBC credit card statement?
Yes. Online, RBC shows your last six credit card statements, with older periods available from a dropdown. A card statement lists purchases, payments and interest, and the output keeps purchases and payments on opposite signs. Check the total against the new balance before importing.
Do statements for an RBC US dollar account convert?
Yes. The US Personal Account has eStatements with seven-year archiving, and each RBC account gets its own eStatement, so the USD account arrives as a separate file. The figures remain in US dollars, so give that account its own USD register in your books.
My statement is older than seven years. What now?
It won't be in online banking, so ask RBC for a copy or use a paper statement you kept. A clear scan converts like a downloaded PDF. Look at the balance comparison afterwards, since faded print is where scans usually go wrong.
Can I import converted RBC Royal Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your RBC Royal Bank statement to Excel

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

More Bank Statement Converters

View all 98 bank pages

Canada

Next steps

pdf2text is independent and not affiliated with or endorsed by RBC Royal Bank.