Cash Mgmt - Reconciliation Date Tolerance issue with One to Many matching
Issue with Matching Rules occurs, matching a very old unreconciled system transaction to a current bank statement transaction even though tolerance rule for date is set to 1/1 (before/after)
I have isolated my matching rules and identifed the below matching rule as the one causing the issue.
With this rule, setup as One to Many, grouping by Payment File Identifier, and matching on Amount, it will pick up single Payables system transactions which are unreconciled and match them to my statement, in this case the transaction is from 2022, and the statement is from 2024.
To resolve that, I added a Tolerance rule, for Date, with a +/-1 to eliminate such matches, but even with the Tolerance Rule in place, it still matches.
0