Entity Bank Details Bundle Import/Export (NetSuite)

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 true 358,358 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 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 true 238,238,240 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 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