Creating reconciliation match rules

Reconciliation match rules are used for more flexibility in selecting transactions to match and reconcile. The custom groups are user-defined based on attributes in the bank statement line and system side transaction. This affects the cash ledger transaction.

  1. Select Treasury Administrator > Cash Setup > Bank Reconciliation Setup > Reconciliation Match Rules.
  2. From the Actions menu, select Create.
  3. Specify this information:
    Reconciliation Match Rule
    Specify the reconciliation match rule.
    Description
    Specify a description.
    Statement Rule
    Specify the statement rule custom group that selects the bank statement lines and then applies the Line Match Field value.
    System Rule

    Specify the system side rule custom group which selected either the cash ledger transactions or the non cash ledger transactions and applies the Line Match Field value.

    Line Match Field

    Specify the words or text variables to use if the Statement Rule and the System Rule are true.

    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.

    Remove Leading Zeros
    If this check box is selected, then the leading zeros on the transaction number in the bank statement are suppressed. Removing leading zeros makes it easier to match the bank statement transaction number to the transaction number in the system.
    Remove Alpha Characters
    Select this check box to remove alpha characters from the variable that is used for the transaction number.
    Match Type
    Specify the match type. These are the options:
    • One To One: one bank statement line to one system side transaction.
    • One To Many: one bank statement line to many system side transactions.
    • Many To One: many bank statement lines to one system side transaction.
    • Many To Many: many bank statement lines to many system side transactions.
    Use Day Lag
    Select the check box to use day lag. If you select this option, the Day Lag and Future Day fields become available. Day Lag indicates the number of days in the past to include into the reconciliation. Future Day indicates the number of days in the future to include into the reconciliation.
    Note: Transactions must have the same date as the statement date when Day Lag and Future Day are not defined.
    Tolerance Percent or Tolerance Amount
    Specify the percent or amount that accounts are allowed to exceed.