How to Reconcile RBC Bank Statements

What you are checking against

A RBC Bank statement typically runs as one dated history — deposits, withdrawals and fees in posting order — with the balance shown per transaction on most layouts. Headquartered in Raleigh, North Carolina, RBC Bank issues every account's statements through the same online banking platform.

Every statement carries its own test inside it. Add the opening balance to the transactions and you must land on the closing balance; walk the running balance and every row must step correctly from the one before. A conversion that passes both tests has earned trust; one that fails gets fixed against the PDF, not imported and hoped for. That is why the check runs before download here — the methodology page sets out the details.

The RBC Bank month-end reconciliation workflow

Let the difference interrogate itself. Before opening anything else, note the size of the gap between the books and the statement. Its size is diagnostic: one transaction, twice one, a round number, or a few cents each point at a different cause.
Convert the month and read its verdict first. The conversion result separates file problems from book problems. A flagged file gets fixed against the PDF; a reconciled file sends the hunt into the books, where it belongs.
Work the flagged rows in order. Fix the first break in the running balance before the second — later breaks are often just echoes of the earliest one.
Reconcile the software with a list, not a force. Close the month in QuickBooks or Xero by listing outstanding items until the remaining difference is exactly those items. Never plug a number to make it agree.
File the evidence trio. Statement, converted file, result — saved together under the month. That is the whole audit trail, and it costs a minute.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Reading one RBC Bank statement closely

One habit separates fast reconciliations from slow ones: read a RBC Bank statement in the order the bank printed it before sorting it any other way. Running balances only make sense in print order, pending items cluster at period boundaries in print order, and the bank's own section subtotals — free checkpoints — exist only in print order. Convert the PDF from Statements & Documents in RBC Bank online banking (website and app), walk it as printed, and let the accounting software do the reordering afterwards.

When a RBC Bank statement does not tie out

A pending card transaction appears on one statement and posts on the next, so both statements are right and the import order is what needs care.
The PDF is a scan and OCR misread a digit. The flagged rows name the expected and printed balances; correct those rows against the image.
A fee or interest line sits in its own section of the statement and was easy to overlook when eyeballing the total — it is a real row and belongs in the books.
A correction or reversal line nets against an earlier transaction. It looks like a duplicate when scanning quickly, but both lines are real and both belong in the file.

The two reconciliations every account needs

An account is only fully proven when two different comparisons agree: the file against the statement (was the data read correctly?) and the books against the file (was it entered and categorized without loss?). Skipping the first makes the second prove the wrong thing beautifully — the software will happily reconcile to a file that misread the statement. Keeping the two checks separate, in that order, is what makes a discrepancy localizable in minutes.

Questions and answers

My RBC Bank statement does not tie out after conversion. What now?

Work the flagged rows first — the check marks exactly where the arithmetic breaks. The causes section on this page lists the usual suspects in order of likelihood.

How often should I reconcile?

Monthly, in step with the statements. Reconciling a year in one sitting is exactly the catch-up scenario the batch converter exists to shorten — and month-by-month chaining is what makes it provable.

What should I keep as evidence a month was reconciled?

The statement PDF, the converted file, and the reconciliation result for that month, filed together. That trio lets anyone re-perform the month later without asking you anything.

My software balance and the statement agree, but I never reconciled. Am I fine?

Not necessarily — two errors can cancel. Agreement of balances is a hint, not a proof; the proof is the transaction-level comparison a reconciliation performs. Convert and check the statements to be sure.

The bank corrected a RBC Bank transaction mid-period. How do I reconcile?

Banks post corrections as their own dated lines — a reversal and a corrected entry, or a single adjustment line. Enter them exactly as printed, in the period they appear, even if the original transaction sits in an earlier month. The statement is the record; reconciling means matching it, and the pair nets to the truth.