Matching rules in CR Reconciliation Center

Matching rules are created in CR Reconciliation Rule Setup. Rule matching assigns rules to find the transaction type and then to find bank transactions in the system to match. The final matching is based on the bank transaction. Consider these points when creating rules:

  • Each rule must be unique by bank and rule name. Each rule must have an associated Check Reconciliation transaction type and at least one match text. Transaction types are Check, Charge, Adjustment, Deposit, Interest, Void, Transfer In, Transfer Out. You can create a rule for each applicable transaction type. You can also create multiple rules for a transaction type, but each must have a different rule name.
  • Create rules that are based on typical transactions and terminology contained in your bank statement. If your bank statement spells the transaction type, Check, as Cheque, specify the latter in the match text of your rule. If your bank statement contains transfers to a Zero Balance Account (ZBA), specify ZBA in the match text. If your bank statement contains ACH payments, create a rule for an ACH transaction.
  • If your bank's spreadsheet terminology typically contains multiple types of fees, create a rule for each fee that posts differently to the General Ledger (GL). Assign a sequence number to indicate which rule is applied first, second, third. Because lower numbers are applied first by the system, the first sequence number can be assigned to the most common fee. The last sequence number can be assigned as a catchall. This table shows an example of the structure of each fee rule:
    Rule Name Sequence # Transaction Type Match Type Match Text 1 Match Text 2
    Fee1 301 Charge And fee service
    Fee2 302 Charge And fee NSF
    Fee3 303 Charge And fee
  • For bank records that do not automatically match to a bank transaction, such as a Transfer In/Out, you can define a reference and offset bank or GL Account. This automates the action so you do not have to manually tie the transfer in GL Transaction Entry.
  • Rule creation is influenced by the formatting of the spreadsheet that is imported for each reconciliation. Each spreadsheet must contain columns for transaction date, check number, description, amount, and reference. The Match Text fields in a rule always pulls from values in the Description column.
  • Values in the Match Text field(s) are used by the rule matching process to look for specific words. Values within a word are not matched. You can use an asterisk wildcard (*) to locate a word beginning with specific text. For example, Che* would match to Check, Cheque and Cheese but not Chk or Ca[che]. Case is ignored; check and Check are considered the same. Special characters are also ignored; for example #, &, ".