The Auto Reconciliation process is inaccurately reconciling external transactions
Summary:
Reconciliation is not accurate for external transactions when we ran the Auto Reconciliation process.
Content (please ensure you mask any confidential information):
Bank statement lines are reconciled with system transactions based solely on matching amounts. Below is the example.
Ex:
Source | Reference | Date | Amount | Type |
---|---|---|---|---|
Statement | 1234567 | 10-08-2024 | -556.65 | Check |
External | 1239876 | 07-26-2024 | -556.65 | Check |
Below are the configuration settings for matching rules.
Reconciliation Matching Rule: One to One
Rule no. 1: External Date & Type Match for ZBA
Matching Criteria: Amount, Date, & Transaction Type.
Reconciliation Matching Rule: One to One
Rule no. 2: External Reference Match
Matching Criteria: Amount, Reconciliation reference
Kindly help me to understand how it is reconciling inaccurately.