Creating matching rules with CR Reconciliation Center

Perform these steps only if you use CR Reconciliation Center functionality to import, match, and reconcile bank statements. Use this function to create matching rules. Before you start creating rules, ensure you have planned and mapped out all of your rules.

  1. Select Check Reconciliation > Setup > Reconciliation Rules.
  2. Click New.
  3. Specify this required information:
    Bank #
    Select the bank number that the rule applies to.
    Rule Name
    Specify a descriptive rule name; for example, Check1.
    Match Text 1
    Specify text to identify the transaction type within the description of the imported bank statement.
    Transaction Type
    Select the transaction type.
  4. Click Save.
  5. In the General section, optionally specify this information:
    Seq #
    Specify a user-defined sequence number. This is the order sequence that the rule is applied. Lower numbers are applied first by the system. If blank, the rule is applied in alphabetical order.
    Check Column
    Specify in which column the check number can be found by the system.
    Check Position
    The check number may be embedded in a column other than Check Number. If so, you can specify a position within the column that the check number can be found. For example, if the Description field value is “Check # 123”, then the starting position of the check number is 9. You can specify up to two digits.
    Reference
    Use for a transaction type that is not already in the system, such as a Charge. Specify a default reference value for manual bank transactions created from this rule. For example, Misc. Fees.
    Use File Reference
    Use for a transaction type that is not already in the system, such as a Charge. Select this option to use the value specified in the Reference column of the imported file.
    Offset Bank
    Use for a transaction type that is not already in the system, such as a Transfer In/Out. If the transaction moves money to another bank, select that bank.
    Note: The SA Currency Setup Currency Code value for the bank is shown on the banner. The Currency Code value for the Offset Bank is displayed next to this field.
    GL Account
    Use for a transaction type that is not already in the system, such as a Charge. This is the GL Account # to offset the bank GL posting for the reconciliation bank. If a GL Account # is specified in the CR Bank Setup record, that number is displayed by default.
    Offset Type
    Field is only available if an Offset Bank was selected. Select a transaction type for the offset. Available values vary depending upon the value in the Transaction Type field.
    Match Type
    Select And or Or. If you are specifying match text in Match Text 2-5 fields, select And to match all the strings specified. Select Or to match at least one of the specified strings.
    Match Text 2-5
    Specify additional text to identify the transaction type within the description of the imported bank statement.
  6. Click Save.