Update Payment Methods via CSV (NetSuite)

note this page is for users of accounts payable (new) module if you're using old vendor bills or expense reports pages , please refer to the entity bank details bundle import/export (netsuite) docid\ jbopft7s1edbopnomxxop guide instead the plugin allows you to update vendor and employee payment information in bulk through csv files, eliminating the need for manual changes to each individual record you can use this process to edit existing records, to add additional line items to existing records, and to create new records this guide applies to both the vendors tab and the employees tab on the payment methods page keep in mind that information stored inside native netsuite cannot be updated in the plugin how payment methods works the payment methods page displays payment information from two sources synced from netsuite (read only) the plugin automatically syncs bank accounts, addresses, and emails from your native netsuite vendor and employee records you cannot edit synced data in the plugin these records are read only and must be updated in netsuite directly added in payment methods (editable) you can add new payment methods directly in the plugin (via the ui or csv import) plugin added records are fully editable you can edit them as needed how to tell the difference in the csv file, the is editable column shows n = synced from netsuite (read only) y = added in plugin (editable) when to use this feature use the csv import feature to add payment methods for multiple vendors/employees at once (faster than entering one by one) edit existing payment methods that were added in the plugin (update bank accounts, addresses, or emails) add additional payment methods to existing vendors/employees (e g , add a new bank account to supplement netsuite data) note you cannot use csv import to edit data that was synced from native netsuite records to modify synced data, update the vendor/employee record in netsuite directly export from anywhere in netsuite, click on the plugin button and then payment methods select either the vendors tab or the employees tab depending on which records you want to update follow these steps to begin the export and import process navigate to payment methods from anywhere in netsuite, you can navigate to the payment methods page hover on the button, then accounts payable (new) > payment methods select either the vendors tab or the employees tab depending on which records you want to update download template or export existing data option a download a blank template (for new records) use this option if you're adding new payment methods that don't exist in netsuite or the plugin you're starting fresh and have no existing data to edit steps click export vendor template or export employee template (depending on your tab) a blank csv file with the correct column structure will download fill in the template with your vendor/employee payment information continue to step 3 fill the csv table belowclick export vendor template or export employee template option b export existing records (for editing) use this option if you need to update payment methods that were previously added in the plugin (is editable = y) you want to add additional payment methods to vendors/employees who already have some steps click export csv file a csv file containing all your current vendor/employee records will download (both synced and plugin added) edit rows where is editable = y or add new rows as needed do not modify rows where is editable = n (these are synced from netsuite and cannot be changed via csv) continue to step 3 fill the csv table below tip save a copy of the exported file before making changes, so you can easily restore the original if needed important the csv is pre structured for import functionality; do not modfiy the column structures import prepare the file for import once you have exported the file, create the import file containing your revised vendor information by editing the data and adding new rows if you are incorporating new vendors/employees do not remove any of the column headers or add additional columns; otherwise, the import will fail each of the three data types requires specific data fields use the existing records as a guide to which columns require data, and be sure to follow the general rules to avoid errors that prevent a successful import bank account to add a new bank account, add a row and enter bank account in the data type column address to add a new address, add a row and enter address in the data type column email to add a new email, add a row and enter email in the data type column please do not fill in the email or address fields for these columns, and ensure that the other columns are completed according to the guidance provided in the table below note only one line entry per vendor can have the is default account set to y enter the default payment method for the default account address record fill the csv table you need to use specific default payment method code values that correspond to your payment rail types since a vendor can only have one default account with a default payment method, you must ensure the payment method you choose is compatible with the corresponding data type navigate to payment methods and check in the table which payment methods are listed for a vendor here is a complete list showing which payment rail types are supported by each data type use only the payment rails supported by your plugin for this specific vendor csv file table rows data type compatible default payment method(s) for this data type other rules bank account ach ach next day cpa bacs sepa wire eft au wire au eft sg wire sg wire nz eft nz wire za eft za international wire international ach uk fps leave the email and address fields empty address check leave the bank account and email fields empty email vcc leave the bank account and address fields empty csv file table columns column name allowable values (case sensitive) notes data type either address, bank account, email required field for bank account , leave the email and address fields empty for address , leave the bank account and email fields empty for email , leave the email and address fields empty id internal id leave empty if adding a new payment method do not modify the value if modifying existing payment information erp vendor id netsuite vendor/employee internal id required field do not modify this field protects against duplicate records vendor name netsuite vendor/employee name is default account y/n required field can only have one default y per vendor all others must be n default payment method please confirm that they are in capital letters (e g , ach, ach next day, check, international ach, international wire, sepa, vcc) anything from the list of available payment methods to see what is enabled on the vendor, navigate to plugin → payment methods and check in the table which payment methods are listed for that vendor any unsupported payment type will result in the line failing to import if you would like to add some payment methods to the plugin, please contact your bank is editable y/n required field for any new lines, please enter "y" do not modify an "n" and change it to a "y"; doing this may break the import email addresses any email addresses, up to 5 separate each email address with “,” country iso alpha 2 country codes https //www iban com/country codes required field for bank accounts this field accepts upper, lower, and mixed case values please enter the iso alpha 2 country codes format the import will error if the user enters the full country name (i e , new zealand) currency currency codes https //www iban com/currency codes required field for bank accounts please enter the currency following the currency code list this field accepts upper, lower, and mixed case values account type checking or savings required field for bank accounts this field accepts upper, lower, and mixed case values account number vendor's account number institution number vendor's institution number transit number vendor's transit number routing number vendor's routing number bank code iban two letter country code, followed by two check digits, and up to 35 alphanumeric characters bic vendor's bic or swift code for the country and bank bank name anything address line anything address line 2 anything address city anything address state province anything address postal code anything local branch code valid branch code for this bank use this field for bsb codes if the country requires it payment purpose message anything payment purpose code valid purpose code payment payment iso code valid sender country code payment payment codeword valid receiving entity codeword payment payment party type p, t, g, n p = parent, t = subsidiary, g = group, n = non related payment residential status resident, nonresident sort code valid sort code for this bank import csv once the file is ready, select the import csv button attach the file that is ready to import and enter one valid email address to receive a status update note you are not able to modify this email address after clicking import if the email is incorrect, you will not get the status email, but the import will complete once the file has been uploaded, a checkmark will appear you can expect an email with a status update within a few minutes import confirmation email once the import status changes, you will receive an email notification this email notification will let you know if the import has been successful there are 3 options file successfully imported import is successful, but there are line errors in that case, please download the csv attached to the email that lists those errors and submit the file again you may leave the error column in the newly uploaded csv please note that if an error is found in one of the rows, none of the information present in that row will be updated import was not successful this issue may be caused by internet connectivity problems or unsupported file formats please verify your internet connection, refresh the page to attempt again, or contact support if the problem persists import csv example this file shows an example of what the import file can look like for one hypothetical vendor on the payment methods page, when you select the vendor, it shows that the bank account has been added when you open up the bank account, you can see the values match the import potential errors potential errors explanation steps to fix the error data type must be address, bank account, or email data type was not filled in always include a data type, this is a mandatory field erp vendor id must be filled in erp vendor id was not filled in always include a erp vendor id, this is a mandatory field default payment method must be of a valid payment type default payment method was not correctly filled in ensure your account has this payment method enabled email addresses contains email(s) with an invalid email format email address format was not respected follow the following format something\@email com # if you would like to add multiple email addresses, ensure they are comma separated as below email1\@email com # , email2\@email com # both country and currency must be filled in country and currency both need to be filled in country contains invalid country code country code is not valid select a valid country code from this list iso alpha 2 country codes https //www iban com/country codes currency contains an invalid currency code currency code is not valid select a valid currency code from this list currency codes https //www iban com/currency codes