Scenario:
If imported bank data is being auto-matched to older NetSuite transactions (e.g., April transactions instead of May), it's likely due to the bank data being imported before the corresponding NetSuite transaction was posted.
Solution:
To prevent this, you can create a Reconciliation Rule that limits matching to transactions within a specific date range.
- Open Reconciliation Rules page.
• NetSuite: Go to Transactions > Bank > Reconciliation Rules.
• NetSuite Next: Open Explore (hamburger icon on the bottom left corner beside the Home button). In the menu, go to Transactions > Bank > Reconciliation Rules.
- Create a New Rule/Rule Name:
- Enter a descriptive Rule Name (e.g., “Limit Matching to Recent Transactions”).
- Go to the Accounts tab. Check the box next to the bank account(s) the rule should apply to.
- Go to the Conditions tab.
- Configure the following settings:
- Transaction Type = All Imported
- Primary Field = Date
- Condition = Within X Previous Days of
- Value = 3
- Transaction Type = All NetSuite
- Compare Field = Date
- Save the Rule.
This rule ensures that imported transactions are only matched to NetSuite transactions posted within the last three days, helping avoid incorrect matches to older entries.
Hope this helped!