About Auto Reconciliation Methods
Account Analysis and Account Analysis with Transaction Matching
This section describes the conditions required for Account Analysis and Account Analysis with Transaction Matching auto reconciliation methods and what is done when the conditions are met.
Table 7-1 Required Conditions for Auto Reconciliation of Account Analysis and Account Analysis with Transaction Matching
Auto Reconciliation Method | Required Conditions | If Auto Reconciliation Succeeds |
---|---|---|
Balance is zero |
|
The reconciliation status is set to Closed. |
Balance is zero and no activity |
|
The reconciliation status is set to Closed. |
No activity |
|
|
Balance is within range |
|
|
Balance is within range and no activity |
|
|
Balance Comparison or Balance Comparison with Transaction Matching
This section describes the conditions required for Balance Comparison or Balance Comparison with Transaction Matching auto reconciliation methods and what is done when the conditions are met.
Table 7-2 Required Conditions for Auto Reconciliation of Balance Comparison or Balance Comparison with Transaction Matching
Auto Reconciliation Method | Required Conditions | If Auto Reconciliation Succeeds |
---|---|---|
Balance is zero |
Note: For Balance Comparison "Balance is zero" the Sub-system balance is not considered. If you would like it considered, you can use a custom rule to evaluate both source and subsystem balances. Alternatively, you can also consider using the "Balance match" condition since that will compare source and subsystem balances to ensure they are equal, or within your desired threshold. |
The reconciliation status is set to Closed |
Balance is zero and no activity |
For Balance Comparison format with No Activity, you can use a custom rule to obtain the correct results. For example, add a custom rule for Auto Submit Reconciliation with filter criteria: Difference (Reporting) equals 0 USD and Period Activity (Reporting) equals 0 USD. |
|
No activity |
For Balance Comparison format with No Activity, you can use a custom rule to obtain the correct results. For example, add a custom rule for Auto Submit Reconciliation with filter criteria. |
|
Balance match (% Tolerance) |
If a balance comparison format is assigned to the profile, then the profile can be enabled for the Balance Comparison where the Balances Match (% Tolerance) auto-reconciliation method. If this method is enabled, then a threshold value can be applied. The threshold percentage is multiplied against the source system balance to calculate a threshold value.
Enter the Match Balance Threshold (Percent) as a whole number between 1 and 100. |
The reconciliation status is set to Closed |
Balances match (# tolerance): |
The difference between the Source System Balance and the Subsystem Balance is less than or equal to a tolerance value; the tolerance value is specified on the profile. Enter the Match Balance Threshold (Number) tolerance amount. |
The reconciliation status is set to Closed |