Convert RBC Bank Statements to CSV
Have an RBC statement saved as a PDF? StatementCSV is designed for digital PDF statements downloaded from RBC. It extracts the transaction rows from your chequing, savings, or credit card statement so you can review them and download a clean CSV. StatementCSV is an independent tool and is not affiliated with or endorsed by RBC.
No bank login. Not used for marketing.
How to convert an RBC statement to CSV
There is nothing to install, and you never sign in to RBC through this tool.
- 1
Save your RBC statement as PDF
In RBC Online Banking, open the statement you want and download the PDF version.
- 2
Upload it here
Drop the PDF in and review the dates, descriptions, and amounts we pull out.
- 3
Download your CSV
Grab the finished file and open it in Excel, Google Sheets, or your bookkeeping app.
What columns are included
The export is designed to mirror the way RBC lays out its statements.
Date
The transaction date for each posted item, in a uniform format.
Description
The RBC transaction details, joined back together when they wrap.
Withdrawals & deposits
Debit and credit amounts kept in their own columns.
Balance
The running account balance where the statement lists one.
Example RBC conversion (sample data)
| Date | Description | Debit | Credit | Amount | Balance |
|---|---|---|---|---|---|
| 2024-05-02 | Payroll Deposit | — | 2,200.00 | 2,200.00 | 4,200.00 |
| 2024-05-03 | Grocery Mart #214 | 84.20 | — | -84.20 | 4,115.80 |
| 2024-05-05 | Coffee Roasters | 5.75 | — | -5.75 | 4,110.05 |
| 2024-05-07 | Hydro One Pre-Auth | 142.50 | — | -142.50 | 3,967.55 |
| 2024-05-09 | e-Transfer Received | — | 300.00 | 300.00 | 4,267.55 |
Example data — your RBC statement produces its own rows. Review before export.
Why convert an RBC PDF to CSV?
RBC gives you a clear PDF to read, but it is awkward when you need to do anything with the numbers. Tallying interest, separating business spending, or importing into accounting software all want columns, not a printout.
A CSV lets you sort an RBC statement by date or amount, filter for a single payee, and feed the data straight into QuickBooks, Xero, or Wave. For tax season, you can stack several months into one file and total your deductible expenses in a few clicks.
Parser-first extraction with guided AI verification helps make sense of RBC's wrapped descriptions and split debit and credit columns, while balance checks compare the totals against the statement so you can review highlighted rows before you export.
Example RBC export
Date,Description,Withdrawals,Deposits,Balance 2024-06-01,Opening Balance,,,2100.00 2024-06-03,Interac Purchase - Grocer,52.10,,2047.90 2024-06-05,Payroll Deposit,,1850.00,3897.90
Common RBC statement formatting issues
A few quirks show up often in RBC PDFs. The converter is designed to handle them, and you review the result before export.
Wrapped descriptions
Long Interac and bill-payment details often span two lines. The parser is designed to rejoin them into one row.
Separate debit and credit columns
RBC splits withdrawals and deposits. The converter is designed to keep them apart rather than guess a single signed amount.
Opening and closing balances
Summary balance lines are treated as context, so they are kept distinct from regular transactions.
Your statement is used only to create your conversion
You never connect your RBC account or share your online banking login — you only upload the statement PDF. Your statement is processed to create your spreadsheet file and is not sold or used for marketing or ads. When guided AI verification is used, it works from rendered statement images, not your original PDF.
No bank login. Not used for marketing.
RBC conversion FAQ
- Do I need to connect my bank account?
- No. You never connect a bank account or share online banking credentials. You only upload the PDF statement you already have, which keeps your login details private.
- What columns are included in the CSV?
- A typical export includes the transaction date, description, and amount, with separate debit and credit or a signed amount column where the statement supports it. A running balance is included when the statement lists one.
- What are balance checks?
- A balance check compares the transactions we extract against the opening and closing balances printed on your statement. When the running total does not line up, we flag it so you can spot a missing or misread transaction before you export. It is a sanity check to help catch errors, not a guarantee of perfect accuracy or any kind of financial advice.
- Are scanned statements supported?
- Scanned bank statement support is not available yet. The converter currently works best with digital PDF statements where the transaction text is selectable.
Banking with TD too? See the TD statement to CSV guide, or the general PDF to CSV walkthrough.
Convert your RBC statement now
Upload a PDF, review the transactions, and download a clean CSV.