ANS-0740 · CSV IMPORT & DATA MIGRATION
How to Manage Uncleared Checks During NetSuite Bank Reconciliation?
Best practices for handling uncleared checks in NetSuite's bank reconciliation process.
Short answer
For ongoing bank reconciliation in NetSuite, utilize native tools like 'Match Bank Data' and 'Reconcile Account Statement' to manage timing differences. In specific scenarios, such as data migration or for certain adjustments, journal entries debiting and crediting the same bank account can record uncleared checks prior to reconciliation.
Scenario
Organizations migrating financial data from legacy systems like QuickBooks to NetSuite often encounter uncleared checks. These checks, issued but not yet presented to the bank, require proper handling to ensure accurate bank reconciliation and financial reporting within the new NetSuite environment.
Solution
For optimal bank reconciliation in NetSuite, it is recommended to utilize the system's native tools, such as 'Match Bank Data' and 'Reconcile Account Statement', which are designed to efficiently identify and manage timing differences.Alternatively, for specific scenarios like data migration or to make certain adjustments, journal entries can be used. This involves debiting and crediting the same bank account to record uncleared checks, which can then be reconciled within NetSuite. This method is typically employed for initial data setup or specific reconciliation adjustments rather than as a primary ongoing reconciliation process.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support