Xero bank lines, matched in bulk.
Every statement line from every Canadian account matched at once, by the rules you described.
What comes in from Xero
- Invoices and bills
Number, contact, amount, currency and tax, for what you sell and what you buy.
- Payments
What has been applied to each invoice or bill, and from which account.
- Bank statement lines
The lines your banks send to Xero, in CAD and USD, waiting to be reconciled.
Why it won’t match on its own
One line at a time
Xero asks about each statement line on its own. A busy month of e-Transfers is hundreds of clicks.
USD bills, CAD bank
A US supplier’s bill paid from a Canadian account converts on the day, and the amounts never agree.
Payouts cover many invoices
A Stripe or Moneris deposit pays dozens of invoices minus fees, which Xero leaves you to split.
One rule, in plain words
Match Xero USD bills to RBC debits in Canadian dollars at the day’s published rate.
bill × day’s rate = debit187 matched
The spread stays on each match. Bills paid twice, or paid but never entered, are what stays open.
What Numerics works out
Numerics counts what the bank shows and the books don’t, account by account, before month end gets close.
You go run your business.
Bring a month of Xero records to the call. You’ll see them matched before it ends.