Creating match rules for detail reconciliation

Use match rules to determine how to match transactions during the detail reconciliation process. Individual rules must be assigned to a match rule group. You can add an individual match rule to multiple rule groups. Assign the match rule group to a reconciliation account.

  1. Select Detail Reconciliation Match Rules.
  2. Click Create.
  3. Specify this information:
    Detail Reconciliation Match Rule
    Specify a name for the match rule.
    Description
    Provide a description.
  4. In the Interface Parameters section, specify this information:
    Interface Rule
    If a specific custom group is used, then specify the custom group to use to select the reconciliation interface transaction where the value of the line match field is applied.
    Apply To All
    Optionally, select this check box to apply the Interface Line Match Field value to all reconciliation interface lines.
    Line Match Field
    Specify the text variables, the hard-coded values, or both, that determine how the transactions are grouped. To specify a text variable, click the ellipsis and select an option from the list.
  5. In the Global Ledger Parameters section, specify this information:
    Global Ledger Rule
    If a specific custom group is used, then specify the custom group to use to select the Global Ledger transactions for the period, where the value of the line match field is applied.
    Apply To All
    Optionally, select this check box to apply the Global Ledger Line Match Field value to all Global Ledger transactions for the period.
    Line Match Field
    Specify the text variables, the hard-coded values, or both, that determine how the transactions are grouped. To specify a text variable, click the ellipsis and select an option from the list.
  6. To align the data when matching transactions, you can modify the values in the line match fields of each parameter. In the Modification Options section, specify this information:
    Remove Leading Zeros
    Select this check box to remove leading zeros from the Line Match Field value.
    Remove Alpha Characters
    Select this check box to remove all alpha characters from the Line Match Field value.
    Remove Character String
    Select this check box and specify a character string to remove from the Line Match Field value.
    Remove Character String and Preceding Characters
    Select this check box and specify the character string to remove from the Line Match Field value. All preceding characters are also removed.
    Remove Character String and Subsequent Characters
    Select this check box and specify the character string to remove from the Line Match Field value. All subsequent characters are also removed.
  7. In the Reconciliation Options section, specify this information:
    Match Type
    Optionally, to alert the reconciler when the matched transaction does not meet the defined criteria, select a match type:
    • One To One: One Interface transaction to one Global Ledger transaction
    • One To Many: One Interface transaction to many Global Ledger transactions
    • Many To One: Many Interface transactions to one Global Ledger transaction
    • Many To Many: Many Interface transactions to many Global Ledger transactions
    Tolerance Amount
    Specify the tolerance amount. If the difference between the matched transactions are within the tolerance amount, then they are reconciled and a distribution is created to automatically reduce the difference.
    Tolerance Account
    If the tolerance difference is posted in a specific tolerance account, then select the Global Ledger account.
    Tolerance Allocation Code
    Optionally, select an allocation code to create the distributions where the tolerance difference is posted.
  8. Click Save.