Previous Topic

Next Topic

Book Contents

Book Index

CB Bank Reconciliation - Match All

Matching for each Statement transaction is done as follows:

  1. All Unreconciled transactions with the same Amount as the Statement transaction are candidates for a match. Candidate transactions are scored on the best match, by matching on, Particulars, Reference, Other Party and Comment. Date may also be considered for match scoring subject to your CB Settings for Match on Date for Deposits and Match on Date for Withdrawals.
  2. The match with the highest score is matched.
  3. If more than one transaction matches with the same highest score, the Action field is set to Ambiguous?. If more than one Statement Line matches to one Unreconciled Line, the Action fields of the Statements Lines are set to Ambiguous?. If a transaction matches only on Amount, or only on Amount and Date if not matching on date the Action field shows Amount?. If a transaction matches but is in the future relative to the Statement Period the Action field shows Future? Click Find Unmatched (Ctrl+F) to find potential matching Unreconciled transactions.
  4. If the transaction is not matched, matching looks for a "contains" match using CB Rules. If the text from the rule is found in the transaction, it will be matched. If more than one matching rule is found (that is, more than one rule which would give the same result if applied), the first will be matched. If conflicting rules are found, the Action field will be set to Rules?. Click ActionRule Add/Edit Rule (Ctrl+R) and select the rule to use from CB Select Rule.

Leading zeros in the Statement grid Reference field are ignored during matching.

Hint: If unreconciled items are on the Statement grid after automatic matching, click Next Unmatched (Alt+Down) on the Statement grid to locate unmatched items. Use Find Unmatched (Ctrl+F) to locate Unreconciled transactions with the same amount or reference as the unmatched item.

You can edit unmatched lines. For example, if the reference for an electronic transaction on the imported statement does not match what you entered, change the Reference on the Statement grid, then match again. If you entered two transactions in CB, that come through as a single line on the imported statement, edit the line to reflect one of the transactions, and add another line to match or select Insert > Split Line for a wizard to do this.