PricingAPIDocsAbout
Log In

Convert RBC statements to Excel or CSV

An RBC statement prints the date once per day and the balance once at the end of it, which is easy to read and awkward to sort. Upload the PDF here and every transaction comes back as its own dated row, as a CSV or a spending report.

Drop your bank statement PDF here, or choose it

PDF, up to 10 MB. Nothing is stored.

Where to find your RBC statement PDF

  1. Sign in to RBC Online Banking or open the RBC Mobile app.
  2. From Accounts Summary, select Statements/Documents. In the app, tap More, then Statements.
  3. Choose the account and statement period, then download the PDF.

How RBC statements are read

One date and one balance per day

Amounts sit under Withdrawals ($) or Deposits ($), the date is printed only on the first transaction of a day and the balance only after the last. The converter gives every row its own date and sign, and never reads a daily balance as a transaction.

Card credits are negative amounts

On an RBC credit card statement any negative amount is a payment, a refund or a credit, and an instalment plan purchase has a ^ before its description. Payments come out as card repayments and refunds as money back, so neither is counted as income or spending.

Parse RBC statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

{
  "object": "document",
  "issuer": {
    "name": "RBC",
    "domain": "rbcroyalbank.com"
  },
  "currency": "CAD",
  "period": {
    "year": 2026,
    "month": 8
  },
  "accounts": [
    {
      "type": "bank",
      "last4": "6218",
      "primary": true,
      "totals": {
        "credits": 2635,
        "debits": 538.37
      },
      "transactions": [
        {
          "date": "2026-08-01",
          "description": "Payroll Deposit FABRIKAM INC",
          "amount": 2635,
          "direction": "credit",
          "category": "income"
        },
        {
          "date": "2026-08-04",
          "description": "Contactless Interac purchase - 4417 METRO 612",
          "amount": 58.37,
          "direction": "debit",
          "category": "groceries"
        },
        {
          "date": "2026-08-08",
          "description": "Online Banking payment - 7361 RBC MASTERCARD",
          "amount": 480,
          "direction": "debit",
          "category": "card_repayment"
        }
      ]
    }
  ],
  "verification": {
    "reconciled": true,
    "issues": []
  }
}
Get an API keyRead the quickstart

Statements from other banks

Scotiabank

TD

BMO

CIBC

Tangerine

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Bank Statement to ExcelBank Statement to QuickBooksBank Statement to OFXBank Statement to JSON

Three simple steps

01

Download your RBC PDF

Sign in to RBC Online Banking or open the RBC Mobile app. From Accounts Summary, select Statements/Documents. In the app, tap More, then Statements. Choose the account and statement period, then download the PDF.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in under a minute and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your statement for a spending score, category breakdown and honest AI feedback.

Get Started Free