ANS-1784 · ACCOUNTING & FINANCIAL CONFIGURATION
How to Handle Large Transaction Sets in NetSuite Bank Reconciliation
Utilize date filters and transaction exclusion features to efficiently process high volumes of bank data within NetSuite's reconciliation tools.
Short answer
To manage large transaction volumes on NetSuite's bank reconciliation pages, use the 'Start Date' field to filter out older, legacy transactions. Additionally, it is recommended to exclude or clear these legacy transactions from the reconciliation process entirely, preventing them from cluttering current reconciliation screens and improving performance.
Scenario
Users may encounter performance issues or difficulty navigating NetSuite's bank reconciliation pages when dealing with a high volume of historical transactions. This often occurs when the system attempts to load an extensive list of records, potentially impacting the efficiency of the reconciliation process.
Solution
To effectively manage large transaction sets and improve performance on NetSuite's reconciliation pages, follow these steps:
Utilize the 'Start Date' field available on reconciliation screens, such as the 'Match Bank Data' or 'Reconcile Account Statement' pages, to filter out older, legacy transactions. This narrows the scope of transactions displayed, making the current reconciliation process more manageable.
It is recommended to exclude or clear these legacy transactions from the reconciliation process. This action prevents them from continuously appearing on current reconciliation screens, thereby streamlining future reconciliation efforts and enhancing system performance.
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support