You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!