Cash activity records that are in exact agreement on the key values but do not have transaction dates and amounts within the specified match tolerances are not reconciled. They remain unmatched and stay available for future match consideration.
Define the Out-of-Balance Tolerances
You need to establish the field tolerances for out of balance conditions on matching cash activity. You can define field tolerances for the fields reconciled in your workflow using several approaches:
- Direct Approach. You can edit the runmatch_db2.xml rule in the cash match stream to configure specific tolerance amounts for each available reconciliation field. You must use the Message Center Editor to apply these edits.
- Indirect Approach. You can create tolerance rules using the Cash Recon console to apply to the cash recon event panels. You can then run the panels manually or from within the cash match stream.
When using work table mode of comparison to reconcile cash activity records, you can reconcile to specified tolerances using these fields:
- Transaction Amount
- Transaction Amount Local
- Transaction Units
When using the data warehouse modes of comparison, including the negative-signed options to roll up reconciliation to the security level, you can reconcile these fields to specified tolerances:
- Transaction Amount
- Transaction Amount Local
- Transaction Units
- User Float1 through User Float6
You can also reconcile these fields for equality:
- User Char1 through User Char6
Tolerances are applied as a +/- absolute amounts that classify the difference, if any, between matched cash activity as in balance, out of balance within tolerance, and out of balance.
Define Tolerance Rules
You can define tolerance rules to use with Run Match Now rules and recon event panels to apply custom tolerance checks to a segment of your data, prior to the default reconciliation. For example, you can use a tolerance rule to reconcile specific entities and securities types for different tolerances than the default Run Match Now rules and recon event panels.
Any special tolerance check for a field must use the same type as used by default processing for that field. For example, you must not apply percentage checks using a tolerance rule when the default rule applies amount checks for the same field.
To define a Cash Activity tolerance rule:
- In the Cash Recon console, click Tolerance Rules.
You see the Tolerance Rules pane with the current list of tolerance rules and the Tolerance Rule Detail pane with the list of details for the rule selected. - Right click New Rule.
You see the Add New Rule dialog box. - In the Rule Name text box, enter the name of the new rule.
- Specify whether you want the rule inactive or available for use.
Options include:
– Is Active (Default). The rule is available for use. - Click OK to save the rule.
You see the Tolerance Rules pane with the refreshed list of rules. - Select the rule from the list.
- In the Tolerance Rule Details pane, select and right click Add Rule Condition.
You see the New Rule Details dialog box. - Click the Data Field drop down and select the database and column values used to qualify the selection of exceptions, including database filter logic using Boolean operators.
- Click the Field Name drop down and select the field to reconcile.
In the Value text box, enter the tolerance that you want to apply. For amount differences, enter the arithmetic value. For percentage differences, enter the percent value in one-hundredths.
NOTE: You can enter values with 2-digit or 12-digit precision, depending on the setting of the Low/High Precision Switch (tag 7003) indicator in the default rule.- Click the Type drop down and select the type of tolerance check.
Options include:
– Value (Default). Specifies that amount differences are tolerance checked.
– Percent. Specifies that percentage differences are tolerance checked. - Repeat Step 8 to Step 11 to define additional conditions, as required.
- When complete, click OK.
You see the new rule detail displayed in the Tolerance Rule Detail pane.
Add Comment