ANS-1502 · CSV IMPORT & DATA MIGRATION
How to Import Customer Deposits into NetSuite?
Explore various methods for bringing customer deposit records into NetSuite, including manual entry, payment imports, journal entries, and scripting.
Short answer
Customer deposits can be imported into NetSuite through several methods: manual creation, importing as unapplied customer payments, utilizing journal entries, or employing a custom script. Each approach offers different levels of automation and accounting implications, requiring careful consideration of your specific integration needs.
Scenario
Organizations often need to migrate or regularly import customer deposit records into NetSuite. This requirement arises during initial system implementation, data migration from legacy systems, or ongoing integration processes. Understanding the available methods for importing these transactions is crucial for maintaining accurate financial records and operational efficiency.
Solution
Manual Creation: Customer deposits can be created individually within NetSuite through the user interface.n
Import as Unapplied Customer Payments: Customer deposits can be imported as customer payments that are not applied to any specific invoice. Depending on the legacy system's accounting treatment, it may be necessary to specify a particular A/R account for these imported payments.n
Import as Journal Entries: When importing customer deposits as Journal Entries, ensure the Customer is tagged in the Name column. For the initial recording of a customer deposit, it is generally recommended to hit a liability account, as customer deposits represent a liability until applied to an invoice. This approach allows the Journal Entry to be visible and applicable on subsequent customer payments.n
Script: A file can be loaded to the File Cabinet, and a custom script can be utilized to create the customer deposits automatically. Specific script details and availability may vary.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support