Auto-Match Reconciliation Rules for Date Not Working in Match Bank Data

User created Auto-Match Reconciliation Rules to match Imported Transactions to NetSuite Transactions with same Check Number and with Date within 3 previous days. When running the rule in Match Bank Data, the transactions are not automatically matched.

Solution

User needs to rearrange the Date condition of the rule:

1. Navigate to Transactions > Bank > Reconciliation Rules

2. Click the Matching Rule created

3. Go to Conditions tab

4. Update the Date condition to the following sequence:

Transaction Type = All NetSuite

Primary Field = Date

Within x Previous Days = 3

Transaction Type = All Imported

Primary Field = Date

5. Click Save

Leave a comment

Your email address will not be published. Required fields are marked *