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 issue result there is no success message in the netsuite environment after importing vendor or employee bank account information using the import feature please check the import logs to ensure that the import was successful records can be created even if they are missing required fields or the field values have an incorrect format please validate the imported records for accuracy in case the same records are imported more than once, duplicate bank records can be created in netsuite for the vendor please check you are importing unique vendor or employee bank accounts with each import for method ‘international’ in the entity bank details tab on the vendor profile in netsuite, please add the method as international wire in the ebd import template please check that all the bank accounts for countries set up for international wires do not have the payment method as domestic is it possible to add additional fields? netsuite doesn’t allow the addition of fields at this time why is the bank balance” and “balance as of” fields in the match bank data page blank despite successful import the system does not pick information regarding your bank balance because of non usage of bank feed this is a netsuite limitation field requirements for csv column name allowable values notes id numeric this is the id number for this specific record this column is not available on the import template as it is system generated vendor (or employee) netsuite vendor id or employee id required can be found in the url of a vendor record or on the ebd overview page label anything required can be vendor + bank details this field is used to differentiate the vendor records when doing mass uploads primary yes/no, y/n, true/false, t/f required t = true, f = false if there are multiple bank details for a single payment method on a single vendor being imported, mark one as t and all others f country 2 letter iso country code required for example "us" for united states of america required field accepts upper, lower, and mixed case values currency 3 letter currency code required for example "usd" for united states dollar required field accepts upper, lower, and mixed case values method domestic, international wire required has to be in the same format as it is case sensitive please use international wire for bank accounts set up for international wire payments please use domestic for us/canada based accounts bankname anything address line1 anything address city anything address stateprovince anything address postalcode anything bic valid bic or swift code for the country and bank accounttype checking, savings field accepts upper, lower, and mixed case values accountnumber valid account number for this bank localbranchcode valid branch code for this bank use this field for bsb codes if country requires it paymentdefaults purposemessage anything paymentdefaults purposecode valid purpose code paymentdefaults paymentisocode valid iso code paymentdefaults paymentcodeword valid payment code paymentdefaults paymentpartytype valid party type p = parent, t = subsidiary, g = group, n = non related paymentdefaults residentialstatus valid residential status bankcode valid bank code for this bank iban two letter country code, followed by two check digits, and up to 35 alphanumeric characters sortcode valid sort code for this bank institutionnumber valid institution number for this bank transitnumber valid transit number for this bank routingnumber valid routing number for this bank 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