💳 transactions
v1
RBC Chequing Account
Template for RBC chequing account CSV exports.
Where to export
Institution
RBC
Export path
Log In -> Select Account -> Download -> CSV
Export Instructions
RBC Chequing Account CSV (v1)
Best for
RBC chequing account exports with these columns:
Account TypeAccount NumberTransaction DateCheque NumberDescription 1Description 2CAD$USD$
How to export
- Log into RBC Online Banking
- Select the account you want to export
- Click Download
- Choose CSV
Notes
- The template imports
Transaction Date,Description 1, andCAD$. - RBC exports use bank-style signs: negative values are money out and positive values are money in.
- SpendSeer negates imported amounts for this template so outgoing transactions align with expense-style amounts. Inflow rows such as payroll, autodeposit transfers, and interest are then categorized separately in preview.
Account Number,Cheque Number,Description 2, andUSD$are ignored by this version.- If your export uses
USD$or you want to use another source column, you can still import this template as a starting point and then adjust the mapping in SpendSeer before completing the import.
Column mapping
| Your CSV column | SpendSeer field | |
|---|---|---|
CAD$ | → | Amount |
Transaction Date | → | Date |
Description 1 | → | Description |
Tip: No source category column is mapped. SpendSeer category rules classify transactions from description by default.
Example CSV
Download| Account Type | Account Number | Transaction Date | Cheque Number | Description 1 | Description 2 | CAD$ | USD$ |
| Chequing | 01234-5678901 | 2/10/2026 | 001234 | MOBILE CHEQUE DEPOSIT - 1234 | empty | 215.42 | empty |
| Chequing | 01234-5678901 | 2/10/2026 | empty | E-TRANSFER SENT SAVINGS TRANSFER A1B2C3 | empty | -187.65 | empty |
| Chequing | 01234-5678901 | 2/13/2026 | empty | PAYROLL DEPOSIT EMPLOYER INC. | empty | 5842.18 | empty |
| Chequing | 01234-5678901 | 2/16/2026 | empty | AUTO INSURANCE INSURANCE CO. | empty | -263.91 | empty |
| Chequing | 01234-5678901 | 2/17/2026 | empty | LOAN PAYMENT | empty | -2198.44 | empty |
| Chequing | 01234-5678901 | 2/23/2026 | empty | ONLINE BANKING TRANSFER - 4791 | empty | 16.82 | empty |
| Chequing | 01234-5678901 | 2/27/2026 | empty | MISC PAYMENT CREDIT CARD PYMT | empty | -1462.3 | empty |
| Chequing | 01234-5678901 | 2/27/2026 | empty | PAYROLL DEPOSIT EMPLOYER INC. | empty | 5860.77 | empty |
| Chequing | 01234-5678901 | 3/2/2026 | empty | E-TRANSFER - AUTODEPOSIT CONTACT NAME ZXCV123 | empty | 1425 | empty |
| Chequing | 01234-5678901 | 3/2/2026 | empty | MORTGAGE PAYMENT | empty | -2840.12 | empty |
| Chequing | 01234-5678901 | 3/5/2026 | empty | DEPOSIT INTEREST | empty | 0.41 | empty |
| Chequing | 01234-5678901 | 3/9/2026 | empty | MONTHLY FEE | empty | -4.5 | empty |