About Setting Date Tolerance in 1 to 1 and 1 to Many Rules

The date tolerance is the number of days to consider when matching transactions from two data sources.

Transaction Matching considers date tolerance in the most common way of matching transactions, treating the Source (in the GL for example), as available "before" the Bank deposits or Sub System transactions. The Transaction Matching engine anchors on the Source and calculates the range of date values to consider for matching forward from there based on the tolerance values entered in the rule.

The Date tolerance option is available for Date type data source attributes and can be set for:

• Auto Match rules
• Manual match rule
• Default attribute mapping

Date tolerance is very flexible and you can use it to specify matching using a:

• Range of days

  Use the date tolerance in rules to establish a range of days to consider for the matching. In rule creation, these fields are labelled Start and End to indicate the range. The engine provides a lot of flexibility for working with the date tolerance range. Let's say you want to consider transactions for matching between today and one day later. That would be Start and End date of 0 to 1. Another example is to start matching transactions two days from the Source transactions and ending 4 days out. You can also consider one day back (start as -1) to 1 day forward by entering a Start as -1 and End value of +1.

• Specific Date

  Additional precision for the date tolerance is offered by being able to match transactions from one source to transactions in the Sub System on another specific day instead of a range of days. This is accomplished by using the date tolerance values in the Start and End fields as the same value. For example, let's say that you only want to match your Source transactions with the Bank transactions 2 days out. You can enter 2 in the Start field and 2 in the End field to only consider exactly that day for matching.

• Business Calendar instead of a regular calendar in order to eliminate holidays and weekends for consideration in matching.

  By default, Account Reconciliation uses a regular calendar to specify the dates in a date range. You also have the option of using a business calendar when calculating date range in order to eliminate counting days that are work holidays for a company or weekends in calculation of the range for matching. The Use Business Calendar check box is available as an option when creating Date Type attribute rule conditions with tolerance and also for match process default attribute mapping. The business calendar option is available for all rules except Many to Many and is not available for manual matching.

  To use a business calendar, you must specify the work days for your organizational unit as well as a holiday rule containing the list of holidays for that organizational unit. The organizational units are assigned to profiles and the associated business calendar is then used during creation of reconciliations. See Defining Organizational Units in the Setting Up and Configuring Account Reconciliation guide.

Note:

For a particular business date, the system calculates the offset business date. Business day is the unique date from the anchor data source. If business calendar is used, then for each unique date the system figures out the calculated offset date for sub system. In the case of 1 to 1 and 1 to Many (source system anchor) and Many to 1 (Sub system anchor), the anchor date is a single unique date and the system calculates the offset date applying the business calendar on that unique date. Many to Many matching may have multiple dates within the group (source system anchor) and that means there is no unique date to calculate offset date.