RBC Bank Statement to Excel: A Canadian Guide

TL;DR To get an RBC Royal Bank statement into Excel, save the eStatement PDFs for every period you need, convert them so each transaction is one row, and create one signed Amount column from the withdrawals and deposits columns. Check the date format, because Canadian files can arrive in either day-first or month-first form depending on where they came from. Then prove that the opening balance plus all activity equals the closing balance before you categorize, import into accounting software, or hand the file to your accountant. Use the online banking download for quick recent checks and the statements for anything formal.

RBC is one of Canada's largest banks, so a lot of Canadians end up with the same task at some point: turning RBC statements into a spreadsheet. Self-employed people need figures for their T2125. Small business owners want clean records for their bookkeeper. Landlords want rental income and expenses in one place. Couples want to build a household budget. Executors need a record of an estate's accounts.

This guide covers where to get the data, what a typical statement looks like, how to convert it, how to fix the formatting issues that come up most often, how to prove the result is complete, and what to do with it afterwards. Online banking screens change, so we describe them generally instead of giving click-paths that may be out of date.

Download or eStatement?

Online banking usually gives you two ways to get transactions out.

A transaction download exports recent activity as a file, commonly CSV or a format for personal finance or accounting software. It's quick and fine for recent questions. The limitations: downloads usually cover a recent window, may include or exclude pending items differently from the statement, and don't carry a statement period's official opening and closing balances.

eStatements are the bank's formal record. Each covers a defined period, shows the opening and closing balance, and lists every transaction posted in between. When a lender, landlord, accountant or the CRA asks for bank statements, this is what they mean, and statements usually reach further back than downloads.

If you're reconciling, catching up on bookkeeping or showing your numbers to someone else, use statements. Save each one with a consistent name such as rbc-chequing-2026-03.pdf and rbc-visa-2026-03.pdf. If you need periods that online banking no longer shows, our guide to getting old bank statements covers the usual routes.

What an RBC statement usually looks like

Personal chequing and savings statements typically include:

• Header: account holder, account number (often partly masked), transit or branch details, and the statement period.
• Summary: opening balance, total deposits, total withdrawals and closing balance.
• Transaction list: date, description, withdrawals, deposits and a balance column.

Business account statements follow a similar idea but may include fee summaries or more detail on deposits.

A few features matter for conversion:

Separate withdrawal and deposit columns. You'll want to combine them into one signed amount.

Short dates. Transaction lines often show a short date such as "03 Mar" without the year. The year comes from the statement period.

A balance that may not appear on every line. Some statements show the balance after each transaction, others only at the end of the day. Either is useful for checking.

Wrapped descriptions. E-transfers, bill payments and some card purchases can have descriptions that spill onto a second line in the PDF. A good conversion keeps them with the amount.

Converting an RBC statement

Copy and paste

For one short page, select the text in a PDF viewer and paste into Excel. Expect columns to shift, wrapped descriptions to become separate rows, and amounts to arrive as text. Fine for a page; slow for a year.

Power Query

Power Query in Excel for Windows can import tables from PDF files. It often works well on clearly gridded statements. You'll still need to remove repeated headers, fill in the year, combine the money columns and set the data types. Our Power Query bank statement guide walks through it.

A statement converter

SheetStatement reads the PDF, keeps dates and descriptions on one row, combines withdrawals and deposits into a signed amount, and checks the opening balance plus activity against the closing balance before export. You can download Excel or CSV, or files ready for QuickBooks and Xero. The free plan includes 3 pages a month. Starter ($9), Pro ($19) and Business ($39) monthly plans cover more volume.

Aim for this layout:

The figures are illustrative. Use the numbers from your own statement.

Step 1: get the dates right

Canada is a mixed environment for date formats. You'll see year-month-day (2026-03-05), day-month-year (05/03/2026) and month-day-year (03/05/2026), depending on the software and settings involved. That's why Canadian spreadsheets are prone to silent date errors.

Some practical rules:

• Prefer ISO dates (YYYY-MM-DD) in your working file. They sort correctly as text, they're unambiguous, and most software reads them.
• Know where your dates came from. If you converted from PDF, the statement shows the order. If you used a download, open the file in a text editor to see the raw values before Excel reformats them.
• Fill in the year. If the statement shows "05 Mar", build a real date using the statement year:

=DATEVALUE(A2 & " " & StatementYear)

That works in most English-language Excel setups. If it doesn't on yours, split the day and month and use DATE(year, month, day) with a lookup for the month name.

• Watch December-to-January statements. January lines belong to the following year.

Our guide to fixing bank statement dates in Excel has more formulas for awkward cases. Check by sorting oldest to newest: the first and last dates should sit inside the statement period.

Step 2: one signed amount

Create a single Amount column, deposits positive and withdrawals negative:

=N(D2) - N(C2)

where C is withdrawals and D is deposits. N() treats blank cells as zero. If amounts arrived as text with dollar signs or commas, convert them first:

=NUMBERVALUE(SUBSTITUTE(C2,"$",""), ".", ",")

If your Excel uses a French-Canadian locale, the decimal and thousands separators may be the other way around, so set them explicitly in NUMBERVALUE. Our guide to separating debit and credit columns covers going in either direction.

Step 3: prove each statement balances

Turn the data into an Excel table named Tx and check:

=ROUND(OpeningBalance + SUM(Tx[Amount]) - ClosingBalance, 2)

The result should be exactly 0. If not:

• Equal to one transaction: a missing row, often the first or last line of a page.
• Twice a transaction: a wrong sign.
• A round number: a misread digit, more common on scans.
• Matches the "opening balance" amount: the opening balance line was included as a transaction. Exclude it.

If the statement prints a balance on each line, you can locate the exact row where an error begins by recalculating the balance and comparing it with the printed one. Our running balance formula guide explains how, and the free balance checker is quick for totals.

Step 4: combine a full year

Append every month into one table with Statement and Account columns. Then:

1. Balance each statement first.
2. Check the joins. Each closing balance should equal the next opening balance:

=IF(ROUND(B3 - C2, 2) = 0, "OK", "Gap")

3. Tag transfers between your own accounts, such as chequing to savings or chequing to a credit card payment, so they don't inflate income or spending.

See combining multiple bank statements in Excel for a folder-based Power Query approach.

RBC credit card statements

Credit card statements work the opposite way to bank accounts: purchases increase the balance owed and payments reduce it. When you convert a card statement, pick one convention. For spending analysis, it's simplest to show purchases as negative and payments and credits as positive, matching your chequing data, so both fit in one table.

The balance check becomes: previous balance plus purchases, interest and fees, minus payments and credits, equals the new balance. Card statements may also list foreign currency purchases with the original amount and rate in the description; record the Canadian dollar amount that was charged.

Our credit card statement converter page explains how SheetStatement handles card statements, and our credit card reconciliation template helps match card activity to receipts.

A worked example: a self-employed consultant

A self-employed IT consultant in Ontario uses one RBC chequing account and one RBC credit card for business and personal spending. She wants clean figures for her accountant at tax time. For individuals in Canada, the tax year generally follows the calendar year, which makes this simpler than in some countries.

1. Collect. She saves twelve chequing statements and twelve credit card statements for the year.
2. Convert. Each becomes a table. She fills in years for the short dates and switches everything to ISO format.
3. Signed amounts. Chequing gets deposits minus withdrawals. The card gets payments and credits minus purchases.
4. Balance. Twenty-three statements balance immediately. One card statement is out by twice the value of a refund. The refund had been read as a purchase. Fixing the sign clears it.
5. Tag transfers. Card payments from chequing are tagged as transfers on both sides.
6. Categorize. Client payments, software, equipment, home office, phone, professional fees, meals, travel and personal. A keyword lookup handles most rows; see Excel formulas to categorize transactions.
7. Summarize. A pivot table by category and month, with notes on a few large items.

She gives her accountant the original PDFs, the workbook and her notes. That's general information about organizing records, not tax advice; your accountant or CRA guidance will tell you what applies to you. For more on what preparers usually ask for, see bank statements for tax preparation.

Using RBC data in accounting software

QuickBooks Online

QuickBooks Online accepts CSV uploads for bank and credit card accounts, with either a single amount column or separate columns. See importing a bank statement into QuickBooks Online, and QuickBooks Online CSV import errors if the upload is rejected.

Xero

Xero accepts CSV statement imports. Our Xero CSV import format guide shows the layout, and Xero import errors covers common problems.

Wave and others

Wave, Sage, Zoho Books and similar tools accept CSV files with their own column expectations. See importing into Wave for one example. The essentials don't change: one row per transaction, unambiguous dates, and a clear sign convention.

Avoid duplicates

If you also have a direct bank feed, importing statements for the same period creates duplicates. Import statements only to fill gaps the feed missed, and check for overlap first. Our guide to duplicate transactions after import explains how to clean them up.

Business account statements

RBC business statements raise a few extra questions:

• Monthly fees may appear as a single line or as several. Categorize them as bank charges.
• Merchant deposits from card terminals or online payment providers often arrive as net daily totals. The statement shows what landed, not gross sales, so you'll need the provider's reports to split out fees.
• Sales tax isn't visible on a bank statement. If you're registered for GST/HST, you'll need invoices and receipts to separate tax from the net amount.
• Loan payments combine principal and interest. Split them using the lender's schedule.

Our month-end close checklist helps turn this into a routine.

Savings accounts and interest

Savings accounts are usually simpler than chequing: fewer transactions, mostly transfers in and out, and an interest line at the end of each period. Convert them the same way and run the same balance check. Two things are worth doing while you're there.

First, tag the interest lines with their own category. Interest earned is generally something your accountant will ask about, and having it as a single total for the year saves them hunting through statements. Your bank may also issue a separate tax slip for interest; compare the two and note any difference, which is usually a timing question about which period the interest was credited in.

Second, make sure transfers between savings and chequing are tagged on both sides. If you move $1,000 from chequing to savings in March and back again in June, that's four rows across two accounts, none of which is income or spending.

Statements for a mortgage, rental or loan application

Lenders and landlords generally want the original PDFs, not a spreadsheet, so send the statements exactly as the bank issued them. The spreadsheet is still worth building for your own preparation. Filter for deposits above a threshold you choose and write a one-line explanation beside each one: a bonus, a gift from a parent, a transfer from your own savings, the sale of a car. Then total your regular monthly outgoings so you know what an underwriter will see. Our guides to bank statements for a mortgage application and bank statements for a rental application explain what's commonly reviewed.

Troubleshooting

Dates in the wrong month. Day and month were swapped. Re-import with the right format, or rebuild the dates from text.

Amounts won't sum. They're text. Strip symbols and spaces, or use NUMBERVALUE. See cleaning bank statement data.

Repeated headers mid-table. Each PDF page repeats the column headings. Filter them out.

A year doesn't balance even though each month does. A missing or duplicated statement. Check the joins.

Odd numbers from a scanned statement. Scans are harder to read than digital PDFs. Our guide to scanned statement accuracy explains what to check.

Other banks

The same steps apply to other North American banks. See our guides for TD Bank statements to Excel and HSBC statements to Excel, or browse the banks directory.

Convert an RBC statement

Upload an RBC statement PDF to SheetStatement, review the rows and the balance check, and download Excel, CSV, QuickBooks or Xero files. The free plan includes 3 pages a month, enough to test it on a real statement.

FAQ

Can I download RBC transactions as a CSV?

Online banking usually offers a download of recent transactions. For complete statement periods, older months or official balances, convert the eStatement PDFs.

Why are some of my dates wrong?

Day and month have probably been swapped. Canadian files can use different date orders. Check the raw values, then convert using the correct order, and prefer YYYY-MM-DD in your working file.

How do I combine withdrawals and deposits?

Create a column equal to deposits minus withdrawals, using N() so blanks count as zero. Deposits become positive and withdrawals negative.

How do I know nothing is missing?

Opening balance plus the sum of all amounts should equal the closing balance. For a full year, each closing balance should also equal the next opening balance.

Does this work for RBC credit card statements?

Yes. Pick a sign convention, convert, and check the previous balance plus activity against the new balance.

Can I use the spreadsheet for my tax return?

It's a useful working file, and many accountants welcome one alongside the original PDFs. This is general information, not tax advice; check with your accountant or CRA guidance.

Is it safe to upload statements?

See the security page for how SheetStatement processes and stores files, and review any service's policy before uploading financial documents.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.