Entity Bank Details Bundle Import/Export

the entity bank details (ebd) bundle integrates with the standard netsuite vendor record to securely house all necessary information for submitting payments once installed, imported vendor and employee data are accessible via setup → entity bank details → overview learn how to import, export, and update ebd for both vendors and employees in this guide the process for importing and exporting records on the vendor and employee tabs is the same the only difference is on the vendor tab, which offers a specialized export utility for users with netsuite’s electronic bank payments bundle, allowing them to conveniently transfer and re upload data into ebd import entity bank data the process for importing ebd data is the same for both vendor records and employee records go to the import/export tab go to setup → entity bank details → import/export import csv template select template to download a blank csv template use this csv to fill out bank details for bulk upload note use this feature only to create new records to update existing records, you must use the export csv feature, as it includes the necessary id column, which is missing from the blank csv template 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) tip have leading zeroes in your data? apostrophes \['] in front of any leading zeroes or formatting cells as "plain text" will keep leading zeroes in microsoft excel or google sheets, but not apple numbers 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 were uploaded successfully select import logs → execution logs to confirm import completion check information prior to sending payments, check the entity bank details tab of the vendor record to ensure all information is correctly updated important 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 export entity bank data the process for exporting ebd data is the same for both vendor records and employee records go to the import/export tab go to setup → entity bank details → import/export 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 update existing ebd records use the import/export feature to bulk edit existing entity bank details (ebd) for multiple employee and vendor records at once export csv file to update existing entity bank details (ebd) records, you must first export a csv file of those records the exported csv file is crucial because it contains a unique id column this id column is not present in the blank csv import template and is necessary for the system to identify and update existing data make edits to the csv using your preferred application (such as microsoft excel or google sheets), open the exported csv file to make your edits ensure the id column on the far left remains untouched you can also add new records to the list; simply enter them as a new row at the bottom of the csv file the system will assign an id to these new records upon import 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 troubleshooting common import issues issue resolution no success message appears in netsuite after importing entity bank data check the import logs directly to verify the import status records were successfully created, but appear incomplete or inaccurate records can be created even if they are missing required fields or have incorrect formatting validate the imported records for accuracy after every upload duplicate bank records are created for a vendor/employee this happens if the same records are imported more than once ensure you are importing unique vendor or employee bank accounts with each import file the international payment method is incorrectly set or missing when importing, the payment method for all international wire accounts must be entered as international wire in the ebd template additionally, ensure bank accounts for international wire countries are not set to the domestic payment method in the vendor's netsuite profile faqs is it possible to add additional fields? no netsuite does not currently allow the addition of fields to the ebd record why are the bank balance and balance as of fields in the match bank data page blank after a successful import? this is a netsuite limitation the system does not populate bank balance information because it relies on the usage of a bank feed, which is not integrated here field requirements for csv make sure your csv import file follows these requirements important ensure any data with leading zeroes is preceded by an apostrophe ' or formatted as plain text in microsoft excel or google sheets note if you are using payment methods that require mandatory country codes for entity bank details, there may be additional columns that must be included in the import to ensure a successful import, we recommend first manually adding the entity bank details to the erp system then, download the template; it will already display the correct columns needed for entering any remaining details name values description 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 the vendor or employee id can be found in the url of the entity record or on the ebd overview page label anything required this can be entity or bank details this field is used to differentiate the 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 (e g , us, ca, uk) required field accepts upper, lower, and mixed case values currency 3 letter currency code required (e g , usd, cad) 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 {{entitiyaddress}} address city anything {{entitiyaddress}} address stateprovince anything {{entitiyaddress}} address postalcode anything {{entitiyaddress}} 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 the 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 2 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 transferring electronic bank payments data before the entity bank details (ebd) bundle is installed, you are limited to making only ach and cpa payments this is done through the bank plugin, using vendor information stored in netsuite's electronic bank payments (ebp) bundle once ebd is installed, the ebp bundle is no longer used to pull vendor banking data for bill payments instead, ebd becomes the new source of payment information the ebd bundle provides the ability to transfer ach and cpa vendor banking information from the ebp 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 your supported data across bundles, follow the steps below go to the import/export tab go to set up → entity bank details → import/export 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 netsuite limits the number of records that can be pulled per file 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 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 import csv(s) 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 confirm import completion 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