NetSuite Admin Tip | Improve Bank Reconciliation Matching with the new 3-Day Rule
Bank transactions and General Ledger transactions do not always carry the exact same date. Processing times, bank posting schedules, weekends, and other timing differences can cause a transaction to appear in NetSuite a few days apart from its corresponding bank transaction.
To help improve automatic matching while keeping the criteria precise, NetSuite introduces the new reconciliation rule: Match on Amount when Date is within 3 Previous Days.
How the Rule Works
The rule looks for a General Ledger transaction with the same amount as the imported bank transaction. For the transactions to match, the General Ledger transaction date must either:
- Be the same date as the imported bank transaction, or
- Fall within the three previous days of the imported bank transaction date.
For example, if an imported bank transaction is dated August 10, the rule can look for a transaction with the same amount dated from August 7 through August 10.
This narrower date range can help NetSuite identify likely matches without immediately relying on a much broader matching window.
Why Rule Order Matters
The 3-day rule runs before the broader 90-day amount/date reconciliation rule. This ordering is important because NetSuite evaluates the more specific matching criteria first.
By attempting the narrower match first, NetSuite has a better opportunity to associate an imported bank transaction with the most relevant General Ledger transaction before considering candidates across a wider date range.
Admin insight: When reviewing reconciliation results, remember that matching is not only about which rules are active—the specificity and evaluation order of the rules can also affect which transactions are matched.
Configuration
The Match on Amount when Date is within 3 Previous Days rule is system-defined, so administrators do not need to create or configure the rule manually.
If the rule does not suit your organization's reconciliation process, it can be inactivated by navigating to the Reconciliation Rules page and clearing its Active checkbox.
Before inactivating it, consider whether normal differences between GL and bank transaction dates commonly fall within a few days. Keeping the rule active may be particularly useful when small posting-date differences are expected as part of regular transaction processing.
Why This Rule Is Useful
Matching solely on an amount across a long period can introduce ambiguity, particularly when an account contains several transactions for identical amounts. A narrower date window provides additional context for determining which transaction is the more likely match.
For example, suppose several $500 transactions occur during a 90-day period. An imported $500 bank transaction could potentially correspond to several GL entries if only the amount and broad date range are considered. Restricting the initial search to the same date or three previous days can significantly narrow the candidate set.
This approach helps:
- Reduce ambiguity when transactions have identical amounts.
- Improve automatic match accuracy by prioritizing transactions occurring close to the bank transaction date.
- Reduce manual reconciliation effort by allowing likely matches to be identified earlier.
- Provide value without additional setup, since the rule is already system-defined.
Related SuiteAnswer: 96560 | System Reconciliation Rules
Related Community Discussion: NetSuite Admin Tip | Reconciliation Rules Hierarchy
We’re eager to hear your feedback! Share your insights or experiences in the comments or start a discussion in the NetSuite Admin Corner. Let’s keep the learning going!
