Convert RBC statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Sage 50, Excel files from the PDF.
RBC eStatement PDFs open without a password. On an account page in Online Banking there is a Download link above the transaction table.
Drop your RBC statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in CAD.
Last updated
How to download a RBC statement as a PDF
- Sign in to RBC Online Banking. From the Accounts Summary page, select Statements/Documents at the top right.
- Under Your Documents on the left, choose Account Documents. Business clients land on the Account Balances page first and see Account Documents and Fee Statements here.
- Use the dropdowns to pick the account and the statement period. Only accounts set to electronic delivery are listed.
- Select the statement and it opens as a PDF. Save it with the download icon in the viewer.
- In the RBC Mobile app: tap More in the bottom bar, then Statements under Services, then the account and the month.
Then drop the file above; several months of RBC statements at once come back as one workbook.
Is the RBC PDF password-protected?
RBC eStatement PDFs open without a password. There is nothing to strip before uploading.
What RBC statements look like
Date, Description, Withdrawals ($), Deposits ($), Balance ($) with an opening and closing balance line.
A monthly RBC chequing statement runs two to four pages for a personal account and often six or more for a small business with cheques, because RBC appends a page of cheque images at the end. Columns are Date, Description, Withdrawals ($), Deposits ($) and Balance ($), with an Opening Balance line at the top and a Closing Balance at the bottom of the table. Dates are shown as day and short month with no year, so the statement period in the header is what fixes the year. Cheques appear as "Cheque - 0123" with the number, e-Transfers as "e-Transfer sent" or "e-Transfer - Autodeposit", and the monthly fee sits on its own line near month end. A US dollar account gets its own statement, and the amounts on it are in USD even though the layout looks identical.
Why not use RBC's own export?
On an account page in Online Banking there is a Download link above the transaction table. It offers a CSV plus Quicken and Microsoft Money formats for accounting software, but only for recent activity, which is a problem when the file you actually need is last March. The download also carries no opening or closing balance and no running balance, so there is nothing to tie the rows to. eStatements go back up to 7 years, so for anything older than the current quarter, or for a period you want to reconcile properly, the PDF is the right source.
Where RBC statements trip up converters
- Cheque images pages at the end are ignored; only the transaction table is read.
Which software RBC customers import into
RBC customers most often import into QuickBooks Online, Sage 50, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
RBC questions
My RBC statement has cheque images on the last pages. Do those end up in the spreadsheet?
No. Only the transaction table is read, so the image pages are skipped. The cheque number still comes through from the description line in the table, which is where you want it for matching against your cheque register.
Can I get more than the last few months from the RBC transaction download instead of converting PDFs?
Not in any useful way. The Download option on the account page is built for feeding accounting software with recent activity and does not reach back the way the eStatement archive does. For a full fiscal year, downloading the twelve PDFs and converting them is faster than fighting the date picker, and you get the balances to check against.
Does an RBC business account statement convert the same way as a personal one?
Yes. The table layout is the same set of columns. The differences are volume, more cheque and image pages, and that business clients reach the archive from the Account Balances page rather than Accounts Summary. Business Fee Statements are a separate document and are not bank statements, so leave those out of the batch.
How do I convert a RBC statement PDF to Excel?
Download it from RBC using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many RBC statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.