All integrations

Every RBC line, accounted for.

Card deposits, e-Transfers, cheques and pre-authorized debits, each matched to what is behind it.

What comes in from RBC

Why it won’t match on its own

  1. Cheques arrive in bundles

    Several cheques deposited together show as one line, with no payer on it.

  2. Descriptions are short

    An EFT reads “MISC PAYMENT” and a company name cut off, so the invoice it pays isn’t on it.

  3. Money moves between accounts

    Transfers from the USD account to the CAD one appear twice, in two currencies.

One rule, in plain words

Match cheques in QuickBooks to the RBC deposit when a day’s cheques add up to it.

1QuickBooks cheques → RBC depositsApplied
SourceQuickBooks cheques
TargetRBC deposits
Match whensum of cheques = deposit, same day

512 matched

A bundle that comes up short keeps its difference on the match, so a cheque that bounced or was never deposited is easy to find.

What Numerics works out

RBC lines still open at month end, by type
Open on the statement
$9,460
across two accounts
By type
EFTs received$4,820
Pre-authorized debits$3,150
Cheques$1,490

Numerics sizes what the matching left open on the statement, so month end starts with a short list, not a long one.

You go run your business.

Bring a month of RBC records to the call. You’ll see them matched before it ends.