RBC Royal Bank provides statements for personal and business chequing, savings and credit card accounts in Canada, and through RBC Bank for US dollar accounts in the United States. RBC Royal Bank N.V. serves the Caribbean, including Curacao, Aruba and Sint Maarten, with its own statement layout. The reviewed statements include RBC Day to Day Banking, RBC Digital Choice Business, RBC Rewards+ Visa, RBC Avion Visa Business and Visa Infinite, a scanned WestJet RBC Mastercard, an RBC Bank Preferred Money Market and an RBC Royal Bank N.V. business account eStatement.
Full name: Royal Bank of Canada
Countries: Canada, Curaçao, United States
Supported statement formats: PDF
Supported destinations: QuickBooks Desktop, QuickBooks Online, Quicken, Xero, CSV/Excel
QuickBooks Online can read a PDF statement itself: Banking, Upload transactions, choose the PDF. Try it first. Use ProperConvert when QuickBooks flags the statement for review, stops before the last page, or the account is not in QuickBooks Online.
For a short statement, type the date, memo, and amount into the destination. Reconcile the result to the closing balance.
Open the PDF statement, review the extracted transactions, choose QuickBooks Online, and save the converted file on your computer.
Choose the posted transaction date, supply a missing year from the statement period, and check statements that cross January.
Remove currency symbols from numeric cells, preserve the decimal separator, and verify debit and credit signs against the running balance.
Keep the payee or customer reference that helps identify the transaction, while avoiding repeated headers and unrelated reference numbers.
The following details were checked against RBC statements from 2015 to 2026: RBC Royal Bank personal chequing (RBC Day to Day Banking) and business (RBC Digital Choice Business) account statements in Canada, RBC Rewards+ Visa, RBC Avion Visa Business and RBC Avion Visa Infinite credit card statements, one scanned WestJet RBC World Elite Mastercard statement, an RBC Bank (US) Preferred Money Market statement, and an RBC Royal Bank N.V. business account eStatement from Curacao in the Dutch Caribbean. RBC uses a different statement system in each of the three regions, and the page says which one each section describes.
29 Dec on personal accounts and 02 Mar on business accounts, no year, and the year comes from "From December 24, 2014 to January 23, 2015" in the header. Credit card rows carry two dates, transaction and posting, as DEC 13 and DEC 15, and the year comes from "STATEMENT FROM DEC 15, 2020 TO JAN 13, 2021". RBC Bank (US) rows carry full dates, 03/04/2020. The Caribbean eStatement carries two four-digit dates per row, book date and value date, as 0112 for 1 December, and the column label switches between (dd/mm) and (mm/dd) from page to page.-$4,198.44. The Caribbean statement signs every amount, -100.00, and adds a DR or CR marker after it.00002-5519970 on personal and 08580 100-955-4 on business statements, next to "Your account number:" or "Account number:". Credit cards print a masked number, 4510 14** **** 1180, one per cardholder. RBC Bank (US) prints the full account number, 000102754025. The Caribbean statement prints account and currency together, 8000009000227992/XCG.A Canadian RBC chequing statement prints the date only on the first transaction of the day and the balance only on the last one. A day with five transactions has one date at the top and one balance at the bottom, and the three rows in between carry only a description and an amount. A converter that requires a date on every row drops most of the month, and one that requires a balance on every row does the same. The date has to carry down and the balance has to be checked once per day: previous balance plus that day's deposits minus that day's withdrawals must equal the printed balance.
Many RBC chequing descriptions take two lines. The first line is the type and reference, Online Banking payment - 9915, and the second line, indented a little to the right, is the payee, VISA - CIBC. The amount and the balance sit on the second line, not the first. A converter that reads the amount from the line with the date finds nothing, and one that treats each line as a row produces a transaction with no amount followed by a transaction with no description. Both lines belong to one transaction and the payee is on the second one.
Business statements add negative balances with a leading minus, -1,443.75, when the account is overdrawn inside the day, and pairs of LOAN CREDIT and LOAN PAYMENT rows that move money between the account and a linked line of credit. The negative balance is a real balance and must not be read as a debit.
Every RBC credit card transaction is followed by a 23-digit reference number on its own line, 74450770349004026415224. It has no date and no amount. A converter that scans for long numbers picks it up as an account number, and one that appends the next line to the description puts a 23-digit number in every memo. It can be dropped or kept as a reference field, but it is not part of the payee.
The first page prints a side panel on the right with "RBC REWARDS POINTS", "CONTACT US", "PAYMENTS & INTEREST RATES" and "CALCULATING YOUR BALANCE" at the same heights as the transaction rows, so DEC 15 DEC 16 PETROCAN-1602 DUNDAS ST E $27.83 and Merchandise Redemption 1-800-769-2512 sit on one visual line. The table has to be cut by column position before rows are grouped. Statements with two cardholders print the transactions in blocks, one per card with activity, headed by the masked number and PRIMARY or CO-APPLICANT, with a "(continued)" heading on the next page, so a row's card comes from the block it is in.
Foreign purchases add a line below the row, Foreign Currency-USD 5.38 Exchange rate-1.381040. The number on that line is not the amount in CAD. The CAD amount is on the row with the dates.
One reviewed Mastercard statement was a scan, and the text from OCR shows what a converter has to survive: the bank name read as Royal Bonk, the transaction date with the space lost, MAR04, the posting date split into MAR and 04 or read as MAR O}, merchant names turned into ALIEXPRESSTåRONTO ON, amounts read as $.46, -$4.61' and -ss.jj•, and the 23-digit reference numbers with letters inside them. The reliable parts are the column positions and the statement summary. A converter has to reject amounts that do not parse instead of guessing, and reconcile the rows it accepts against "NEW BALANCE".
RBC Bank in the United States is a separate bank with its own statement, addressed from Raleigh, North Carolina, and it looks nothing like a Canadian RBC statement. The page starts with "Summary of My Deposit Accounts", lists each account with its full number and balance, and then prints one section per account with an "Account Summary" (Balance Last Statement, Total Debits, Total Credits, Closing Balance) and an "Account Activity" table with Date, Transactions, Debits, Credits and Balance columns. Dates are full, 03/04/2020. Descriptions wrap to two or three lines, Electronic Deposit (ACH) then the originator and ACH Company Name: PAYPAL IAT, with the amount on the first line. The left margin carries rows of ones and zeros, 1010101010101010101010, printed as a mail-processing pattern at the same heights as the transactions near the page bottom. A converter has to ignore that column, and has to keep the "Opening Balance" and "Closing Balance" rows in the activity table separate from the "Balance Last Statement" rows in the summary above it, since both print the same numbers.
RBC Royal Bank N.V. serves the Dutch Caribbean and prints a third layout. Under "TRANSACTION DETAIL" each row has a BOOK DATE and a VALUE DATE as four digits with no separator, 0112, and the column label under the header says (dd/mm) on the first page and (mm/dd) on the following pages of the same statement, while the dates themselves are day first throughout. Amounts are signed and followed by DR or CR. Each transaction takes three to six lines: the type, POS Interbank Debit, the merchant, Original 26/11/2025 with the original transaction date, and a processing note such as VISA DEBIT POS SUPENSE LC. The amount and the balance are on the first line only. The currency is the Caribbean guilder, XCG, named only in the account number, so a converter that assumes USD or CAD for anything called RBC labels the whole file wrong. The "STATEMENT SUMMARY" prints the debit and credit counts in parentheses, ( 95), next to the totals, which is the check for the row count.
Compare the converted transaction count and totals with the statement, then confirm that the calculated final balance equals the printed closing balance.
Yes. If the PDF statement is readable, its age does not prevent conversion. Confirm the year when transaction rows omit it.
No. Convert posted transactions that contribute to the statement balance. Pending or future-dated items should not be mixed into that reconciliation.
Use the destination-specific settings below, then review the file before import. The destination may require particular columns, dates, account identifiers, or sign rules.
A bank PDF can contain searchable text, scanned page images, or a mixture of both. Searchable text still needs layout analysis because transaction descriptions wrap, columns move, and headers or balances repeat at page breaks. A scanned statement adds OCR uncertainty.
A transaction may begin at the bottom of one page and continue on the next. Continuation pages can omit column headings, repeat an opening balance, or insert footer text and legal pages between transaction pages. A conversion should join split rows and exclude repeated page furniture before it writes the output.
On scanned pages, OCR can turn 0 into O, 1 into l, or 5 into S. It can also lose a minus sign or decimal mark, read two columns in the wrong order, or struggle with skewed and faint pages. The running balance is the best check: a damaged amount or missing row breaks the balance sequence.
Yes. Review the OCR result and reconcile every balance movement. Scans with faint printing, rotation, or handwritten marks need more checking than searchable PDFs.
PDF text stores page positions rather than a spreadsheet table. Wrapped descriptions, repeated headers, and visually aligned columns can paste in the wrong order or into the wrong cells.
Try selecting a transaction description in a PDF reader. If individual words can be selected, the page probably contains text. If the whole page behaves like one picture, it requires OCR.
QuickBooks Online imports bank transactions from a file through Banking, Upload transactions. It accepts QBO, QFX and OFX files, which share the OFX structure, and CSV files. Uploaded rows land in the For Review list, where QuickBooks matches them to existing entries and the user adds or excludes them.
Since 2026 the same upload screen also takes a PDF or an image of a statement (JPG, PNG, HEIC). Intuit's AI reads the pages, and a statement it cannot read with confidence is held for a manual review by Intuit staff. If the account is in QuickBooks Online and the statement is a clean PDF, try that first; it costs nothing. A converted file is the better route when the upload flags the statement or stops before the last page, when there are many statements to catch up, when the bookkeeper wants to see and fix every row before it enters the books, or when a client's statement should not be uploaded to a third party.
Settings that matter:
MM/DD/YYYY or DD/MM/YYYY depending on the company settings, digits only, four-digit years.Use OFX, QFX or QBO when the file can be made in that format. It carries the payee, the memo and the check number and gives QuickBooks a transaction ID for duplicate checks. Use CSV when a spreadsheet is the only source and a single description is enough.
The usual causes are a date column QuickBooks cannot read, an amount with a currency symbol or thousands separator, more columns than the three- or four-column layout, or a file over the size limit. Save the file with dates as digits, amounts as plain numbers, and only the needed columns.
The account was chosen during upload. QuickBooks Online does not read the account name from the file. Exclude the rows, delete them from Excluded, and upload again with the right account selected.
In For Review, select the rows, choose Batch actions, Exclude Selected. Open Excluded, select them again, Batch actions, Delete. The rows are gone and the file can be uploaded again.
QuickBooks Online skips rows whose transaction ID it has already seen and, for CSV, rows it reads as duplicates by date, amount and description. Two genuine identical rows on the same day can be dropped from a CSV. Use an OFX-type file with unique IDs for those.
Yes. The 90-day limit applies to a live bank connection, not to a file upload. Any date range can be uploaded from a file.
For one clean statement of an account that is already in QuickBooks Online, the built-in upload is the shortest path, and this page says so. A converter earns its place when the upload flags the statement for review, when a scanned or multi-year statement does not go through, when the account is in QuickBooks Desktop, Quicken, Xero or Sage instead, or when the statement must stay on your computer. The converted file goes through the same Upload transactions screen as a QBO file, with a transaction ID per row, so re-uploading a period does not double it.