Import an RBC Statement CSV into Fininja

Fininja

Import your RBC statement into Fininja

RBC lets you download transactions for several accounts into a single CSV. Upload that file to Fininja and it will split the rows out, sort them, and hand them back to you for review.

CSV supportedPDF supported

Fininja never asks for your RBC online banking credentials. You export the file and choose what to upload.

This format is covered by Fininja's tests

A real RBC CSV export is part of Fininja's parser test suite, and an automated test covers RBC's column layout - including the two separate description columns.

The layout we test against looks like this:

Account Type, Account Number, Transaction Date, Cheque Number, Description 1, Description 2, CAD$, USD$

RBC splits the merchant across two description columns and can put multiple accounts in one file. Fininja merges the description columns back together so a transaction reads the way you would expect.

How to download your RBC statement

These steps cover RBC chequing, savings and credit card accounts.

  1. Sign in to RBC Online Banking
    Use a desktop browser for the full set of download options.
  2. Find the download transactions area
    RBC provides a download screen that can cover several accounts at once, rather than making you export each account separately.
  3. Choose the accounts and the date range
    Select the chequing, savings or credit card accounts you want, and the period to cover.
  4. Choose the spreadsheet or CSV format
    RBC offers a few file formats, including ones aimed at accounting software. Pick the plain CSV or spreadsheet option.
  5. Upload the file to Fininja
    Review the staged transactions, fix anything that landed in the wrong category, and save.

A note on accuracy: these steps were written from publicly documented flows and have not been verified against RBC Royal Bank's current interface, which changes from time to time. The general path - sign in, open the account, look for the download or statements option - holds up even when a menu moves. If yours looks different, tell us and we will correct this page.

What Fininja does with the file

The file is read, whatever shape it is in
Fininja's importer is format-agnostic. It inspects the file you upload - headers, or no headers at all - and works out which field is the date, which is the description and which is the amount. Once it has seen a layout it remembers the signature, so the next statement in the same format is quicker.
Nothing is saved until you say so
Imported transactions land in a staging area. You look them over, fix anything that was read or categorised wrongly, and only then do they join your transaction history.
Likely duplicates are flagged
Re-importing a period you already loaded is normal - date ranges overlap. Rows that look like something already in your history are marked as potential duplicates in the review step so you can leave them out.
Categorization learns from your corrections
Categories are predicted by a model trained on your own past corrections, not on a generic merchant list. Transactions it cannot place fall back to a usage-capped OpenAI lookup. Every correction you make makes the next import better.

What we do with the data you upload is spelled out in our privacy policy.

RBC import FAQ

My RBC file has more than one account in it. Is that OK?
Yes. RBC's export includes an account type and account number on every row, which is exactly what the sample in Fininja's test suite looks like. Upload it as one file.
Why does the RBC file split the description over two columns?
That is just how RBC exports it - a merchant name in one column and extra detail in another. Fininja merges the two back into a single readable description rather than dropping half of it.
Does this cover RBC credit cards as well as chequing?
Yes. RBC's download screen covers day-to-day accounts and credit cards in the same place and the same file layout, so there is one flow for both.
Does Fininja need my RBC online banking login?
No, and it never asks for one. There is no account linking and no aggregator sitting between you and your bank. You sign in to RBC Royal Bank yourself, download the file, and upload that file to Fininja. Fininja only ever sees the statement you choose to give it.
What happens right after I upload the file?
The importer works out which column or field holds the date, the description and the amount, then puts the resulting transactions in a staging area. Nothing is added to your history until you have looked through them and approved them. Rows that look like something you have already imported are flagged as potential duplicates so you can skip them.
What if a transaction lands in the wrong category?
Change it. Categorization runs on a model trained on your own corrections, so the fix teaches it your habits - the same merchant should land correctly next time. Transactions the model cannot place fall back to a usage-capped OpenAI lookup.
Is importing statements free?
Fininja has a free tier and a $4.99/month premium plan. CSV and PDF statement imports and auto-categorization are part of the premium plan - see the pricing section on the homepage for what each tier includes.

Importing from another bank?

Start with your last RBC statement

Create an account, upload the file, and see your spending sorted - with every transaction still yours to review before it is saved.