Creating reconciliation match rules

Use reconciliation match rules to define how the bank statement lines and system transactions are identified and matched. Rules apply to both cash ledger and non-cash ledger transactions. Rules are applied after the bank statement and the bank statement lines are created from the bank statement interface.

Reconciliation match rules must be active to use them. See Creating Cash accounts.

  1. Select Bank Reconciliation Match Rules.
  2. Click Create.
  3. Specify a code and description.
  4. Specify this information:
    Statement Rule
    Specify the conditions to use to select the bank statement lines. Conditions can evaluate any field in the BankStatementReconciliation business class and can be joined using logical operators. Literal values can be verified by placing the value in quotes. Wrap the value in asterisks to search for the value anywhere in the field values.
    Statement Line Match Field
    Specify the text variables or values, or both, if the Statement Rule is selected.

    If a text variable replacement is used, then the Variable Source On Statement field is available. Valid options are Related Reference , Bank Reference, and Text Reference. This is the value to substitute from the bank statement line.

    If the text variable replacement is a user-defined field, specify {lpl:UserDefinedField}. To reference the related fields, use this syntax format: {lpl:XXX.UserDefinedField}, where XXX is the key field. This syntax is case sensitive and the key fields are generally lower case. For example, {lpl:CashLedgerTransaction.UserDefinedField}.

    ​

    Remove Leading Zeros
    Select this check box to remove leading zeros. Removing leading zeros can help to align the values for the line match field if only one of the fields contain leading zeros.
    Remove Alpha Characters
    Select this check box to remove alpha characters from the variable that is used for the transaction number.
    Remove Character String
    Select this check box and specify a character string to remove.
    Remove Character String And Preceding Characters
    Select this check box and specify the character string to remove. All preceding characters are also removed.
    Remove Character String And Subsequent Characters
    Select this check box and specify the character string to remove. All subsequent characters are also removed.
    System Rule
    Specify the custom group to use to select the cash ledger transactions or the non-cash ledger transactions. The System Line Match Field value is applied to the transactions.
    Note:  The custom group must include the DebitCreditIndicator field if Reconcile by Amount is selected.

    For information about custom groups, see Creating custom groups in Reconciliation Management.

    System Line Match Field
    Specify the text variables or values, or both, if the System Rule is selected. For text variable replacement, see the Statement Line Match Field information.
    Remove Leading Zeros
    Select this check box to remove leading zeros. Removing leading zeros can help align the values for the line match field if only one of the fields contain leading zeros.
    Remove Alpha Characters
    Select this check box to remove alpha characters from the variable that is used for the transaction number.
    Remove Character String
    Select this check box and specify a character string to remove.
    Remove Character String And Preceding Characters
    Select this check box and specify the character string to remove. All preceding characters are also removed.
    Remove Character String And Subsequent Characters
    Select this check box and specify the character string to remove. All subsequent characters are also removed.
  5. In the Additional Options section, specify this information:
    Reconcile By Amount
    If this check box is selected, the Reconcile By Amount Type field is displayed.
    Reconcile By Amount Type
    Select whether to reconcile the debit or credit transactions. This option is valid for all match types. Tolerances are not available when Reconcile By Amount is used.
    Match Type
    Specify the match type. For example, one to one indicates one bank statement line to one system side transaction.
    Tolerance Percent
    Specify the percent that can be exceeded.
    Tolerance Amount
    Specify the amount that can be exceeded.
    Use Day Lag
    Select this check box to use day lag. If you select this option, then the Day Lag and Future Day fields become available.
    Note: Transactions dates must be the same date as the statement date when Day Lag and Future Day are not defined.
    Day Lag
    Specify the number of days in the past.
    Future Day
    Specify the number of days in the future.
  6. Click Save.