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. Access Treasury Administrator > Cash Setup > Bank Reconciliation Setup > Reconciliation Match Rules.
  2. From the Actions menu, select Create.

    Use the following guidelines to enter field values:

    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.

    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.

    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.