This article explains a scenario where transactions were not automatically matched during bank reconciliation previously, and clarifies that the functionality is now working as intended after an Enhancement request.
Previously, while performing bank reconciliation, a transaction dated March 5, 2025 was not automatically matched after running reconciliation rules under Transactions > Bank > Match Bank Data. Upon review, it was found that the bank data was imported on March 7, 2025, while the corresponding journal entry was only created and approved on April 7, 2025.
Before, this sequence is critical because reconciliation rules in NetSuite follow a specific processing order. For reconciliation rules to work correctly, NetSuite requires the following hierarchy:
- Reconciliation rules must be configured
- The related NetSuite transaction must already be created and approved
- Bank data must then be imported
If this order is not followed, particularly when bank data is imported before the NetSuite transaction is created and approved, the reconciliation rules will not apply to those transactions. This is expected and standard system behavior.
This has been identified before as a system limitation and an enhancement request has been filed to address this gap: Enhancement #616565 – Run Reconciliation Rules on Previous Imports. Currently, NetSuite now support re-running reconciliation rules on previously imported bank data.
The behavior initially observed has now been corrected, and reconciliation rules are functioning as expected. With the latest update, users are now able to rerun reconciliation rules on previous import. This increase efficiency of the bank reconciliation process and the users benefit from more automation, as the automatic reconciliation is extended across multiple imports which previously had to be manually matched.
The completed enhancement request now includes the following features:
- The confirmation dialog now includes start and end date fields, so you can control which imports are eligible for processing.
- Only one reconciliation rules process can be in progress for a given account at a time, but you can run rules for different accounts simultaneously.
- A notification appears to indicate the process has started. The message includes a Track your status link, which you can click to view the processing status. All active system and user reconciliation rules run against transactions that have been imported during the date range you specified. Also, the built-in rule for matching in–transit payments is run. (Automated cash application rules are not triggered by this process.)
You may refer to SuiteAnswer 95132 | Manually Running Reconciliation Rules for additonal reading.