NetCash CSV Upload Bank Transactions

OVERVIEW 

Some banks do not allow Third Party Providers to integrate with their systems and pull financial information. If this is the case, the bank information must be imported into the system using the native NetSuite CSV import. 

To upload bank transactions for manual bank connections, reference the  tab "Bank Transaction" in the NetCash Manual Connection Template for a list of the fields. Depending on system setup, additional fields may need to be added to perform a successful upload. 

 STEP BY STEP PROCESS 

• Navigate to Setup > Import/Export > Import CSV Records
• With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetCash Bank Transaction
• Under the CSV files section, click on the Select button and upload the saved .csv file. View full size
• Select Next to progress to the Step 2 Import Options
• Within the Import Options section, make sure Add is selected and "Run Server SuiteScripts and Trigger Workflows" is checked View full size
• Select Next to progress to the Step 4 Field Mapping (Step 3 File Mapping is not applicable in this upload)
• Note that NetSuite tries to directly map all the fields it can recognize. When fields are not recognized, they must be manually matched between the .csv upload file and NetSuite fields. Ensure that all required fields are properly mapped. View full size
• If the fields are mapped correctly and the field contents match the field values in NetSuite, select Next to progress to the Step 5 Save Mapping & Start Import
• If this is the first upload, save the mapping name and select Save & Run View full size
• Navigating to Setup > Import/Export > View CSV Import Status the status of the upload will show
• If configured correctly the upload will show complete and the bank transaction will be available to view in NetSuite View full size
• In the event of a failed upload, review the logs for the specific reasons for the failed load and repeat the steps above