Entity Bank Details Bundle Import/Export

notice all entity bank details for both vendors and employees alongside all history logs are stored in your netsuite environment please ensure you are regularly exporting your entity bank detail records and your history logs to prevent any potential loss, such as through uninstallation of the bundle the entity bank details \[ebd] bundle, in combination with the standard netsuite vendor record, will store all information required to submit payments via the bundle this imported vendor and employee data can be viewed after the installation by going to setup → entity bank details → overview importing and exporting ebd records on either the entity or employee tabs work exactly the same the only difference is on the vendor tab where there is a small section where end users who have netsuite’s electronic bank payments bundle installed can export data to re upload into ebd import instructions these instructions are the same for importing vendor or employee data step 1 go to the import/export tab go to setup → entity bank details → import/export step 2 import csv template select template to download a blank csv template, then use this csv to fill out bank details for bulk upload note this is to be used to create new records only to update existing records please use the export csv feature as existing records have an id column that is not present in the blank csv template step 3 format and fill out csv please see the field requirements for csv section of this page for a table containing all formatting requirements for the csv file note confirm that you use the iban country code (e g ca) have leading zeroes in your data? apostrophes ' in front of any leading zeroes or formatting cells with as "plain text" will keep leading zeroes in microsoft excel or google sheets, but not apple numbers step 4 upload the formatted csv in the same import/export screen, upload the formatted csv document confirm successful upload by checking the import logs to ensure all records uploaded successfully select import logs → execution logs to confirm import completion step 5 check information prior to sending payments, check the entity bank details tab of the vendor record to ensure all information is correctly updated export instructions these instructions are the same for exporting vendor or employee data step 1 go to the import/export tab go to setup → entity bank details → import/export step 2 export csv template click on the generate export file button to trigger a csv download of all records kept in ebd the table will display a history of all exports created, alongside timestamps and buttons to download each of these files “export logs” contains more information about the export files generated this can be found under the “execution log” tab for each line item, it will report who initiated the export, the number of records exported in the one file, as well as the file name for that particular export updating existing ebd records using import/export users can bulk edit a number of existing entity bank details (ebd) records using the import/export feature step 1 export csv file follow instructions above in the export instructions section on how to export a csv file of existing ebd records please note that this export csv file contains an id column that is not present on the blank csv import template using the blank csv import template instead of the export csv file will create new records and may result in unwanted duplicate bank detail records step 2 make edits to the csv in the application of your choice (microsoft excel, numbers, etc ) please make edits to the existing data in the exported csv file ensure the id column on the far left remains untouched you may also add new records in by adding them as a new row to your csv step 3 import the edited export file after making edits to the previously exported file, you may now import the csv file back into the entity bank details bundle either select a csv file to upload, or drag and drop one into the import data section of the import/export page nuances/exceptions 459,334 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type field requirements for csv 277,247,269 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type ensure any data with leading zeroes are preceeded with an apostrophe ' or formatted as "plain text" in microsoft excel or google sheets transferring bank details from electronic bank payments bundle without the entity bank details bundle, users are only able to make ach and cpa payments through the bank plugin using information stored in netsuite's electronic bank payments bundle once the entity bank details bundle is installed, the electronic bank payments bundle will no longer be used to grab payment information for bill payments made through the plugin the entity bank details bundle provides the ability to transfer ach and cpa vendor banking information from the electronic bank payments bundle to the entity bank details bundle via csv ach and cpa banking information stored in the following default payment file formats are supported ach ccd/ppd ach ctx (free text) cpa 005 transferring ach and cpa banking information that is stored in custom payment file formats is unsupported to quickly transfer information across bundles, follow the steps below step 1 go to the import/export tab go to set up → entity bank details → import/export step 2 generate csv(s) select click to show electronic bank payments export select generate csv file this will generate a csv file(s) dependent on the “number of entries for each file” set below for example — if you have 1100 records and set the number of entries to 200, the bundle will generate five csvs containing 200 records and one csv containing 100 records note netsuite limits the amount of records that can be pulled per file please set the number of entries for each file accordingly note the "generate data from electronic bank payments bundle" can only extract ach and cpa payment details any additional payment details must be transferred into the entity bank details bundle either via manual entry or using the import feature step 3 import csv(s) select select a csv file… or drag and drop the csv file(s) into the import data box then, select import wait a few moments for the import to complete once complete, select import logs → execution logs to confirm import completion you can also check the following places to confirm bank details have been saved entity bank details tab on the vendor or employee record entity bank details overview page entity bank details history page