ANS-1692 · ACCOUNTING & FINANCIAL CONFIGURATION
How to Prevent Duplicate Bank Data Imports in NetSuite
Understanding the NetSuite bank data import process helps avoid redundant entries and ensures data integrity.
Short answer
Duplicate bank data imports in NetSuite typically occur when the 'Update Imported Bank Data' button is manually clicked on the Match Bank Data page, causing a re-import. To prevent this, rely on NetSuite's automatic scheduled updates for importing bank data, allowing the system to process transactions without manual intervention and reducing the risk of redundant entries.
Scenario
Users may encounter duplicate bank transactions after importing bank data into NetSuite. This issue often arises when attempting to refresh bank data, leading to redundant entries appearing on the Match Bank Data page. Understanding the correct procedure for updating imported bank data is crucial to maintain data accuracy.
Solution
Duplicate bank data entries in NetSuite are primarily caused by manually clicking the 'Update Imported Bank Data' button on the Match Bank Data page. This action triggers a full re-import of bank data, which can lead to redundant transactions. To prevent duplicates and ensure data integrity, follow these guidelines:
Avoid manually clicking the 'Update Imported Bank Data' button unless the page explicitly lacks the most recent data update.
Rely on NetSuite's automatic scheduled updates for importing bank data. This method ensures that transactions are imported efficiently and without manual intervention, significantly reducing the risk of creating duplicate entries. Allowing the system to process these updates automatically is the recommended best practice. For the most current information and detailed guidance, users should refer to NetSuite's official documentation.
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support