Updating Vendors via CSV (Intacct)

the plugin allows users to update their vendor payment information in bulk via csv without having to manually change each record you can use this procedure to edit existing vendor records, to add additonal line items to existing vendors and to create new vendor records keep in mind that information stored inside native intacct cannot be updated in the plugin functionality this functionality has two parts export, to export all the current records, and import, to change all the vendors needing a change fispan strongly recommends exporting first before importing this will confirm that the csv file is structured correctly since the row structure is different for each data type as long as the id fields have not been modified or changed, you will be able to re import the same data multiple times to update existing rows step 1 navigate to the payment methods page from anywhere in intacct, you can navigate to the payment methods page click on your plugin and then payment methods to begin the export and import process step 2 export click export by hitting export, a csv export of all vendors is directly triggered this csv is structured to facilitate the importing process, so please do not modify any of the columns’ structures the import from intacct triggers a minimum of one row of data there are three different data types bank account each vendor with a bank account creates a row with a data type of bank account , allowing you to modify the vendor’s bank account address each vendor with an address record creates a row with a data type of address , allowing you to modify the vendor’s address email each vendorwith an address record creates a row with a data type of email , allowing you to modify the vendor’s email we suggest saving a copy of this file or your records and to provide an easy way to import back the original file if necessary! step 3 import once you have exported the existing vendor bank information, create the import file with your revised vendor bank information by editing the data and creating new rows if you are adding new vendors do not remove any of the column headers or add additonal columns, otherwise, the import will fail prepare the file for import each of the three data types require 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 preventing a successful import bank account to add a new bank account, add a row and enter bank account in the data type column do not fill in the email or address fields and fill in the other columns following the guidance from the table below address to add a new address, add a row and enter address in the data type column do not fill in the bank account or email fields and fill in the other columns following the guidance from the table below email to add a new email , add a row and enter email in the data type column do not fill in the bank account or address fields and fill in the other columns following the guidance from the table below 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 populating the csv table you need to use specific default payment method code values for each of the payment rail types since only one entry per vendor can be the default account with a default payment method, there any rules for which payment method is compatible with each data type here is a complete list showing which payment rail types are supported by each data type use only the payment rails supported by your bank plugin for this specific vendor navigate to plugin → payment methods and check in the table which payment methods are listed for a vendor 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 domestic bank account enables to change the vendor’s domestic bank account fill in all columns needed but do not fill in default payment method and email addresses email enables to change the vendor’s international bank account fill in all columns needed but do not fill in default payment method and email addresses id internal id leave empty if adding a new payment method do not modify value if modifying existing payment information erp vendor id intacct vendor id do not modify, protects against duplicate records vendor name intacct vendor name is default account y/n can only have one default (y) per vendor all others must be n default payment method please confirm that they are in capital letter 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 if you would like to add some payment methods to the plugin, please contact your banker is editable y/n for any new lines, please enter in "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 this field accepts upper, lower, and mixed case values please enter in the iso alpha 2 country codes format the import will error if user enters full country name, i e new zealand currency currency codes https //www iban com/currency codes please enter currency following the currency code list this field accepts upper, lower, and mixed case values account type checking or savings 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 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 importing the file once the file is ready, select the import button attach the file that is ready to import and enter one valid email address to receive a status update you are not able to modify this email address after clicking import , so be sure to add the correct one once the file has been uploaded, a checkmark will appear wait a few minutes to get a status update via 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 1 import is successful! 2 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 can 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 is updated 3 import was not successful this may be caused by internet issues or if the file format is not respected please check your internet connection, refresh the page to try again, or contact support if it still does not work example of import this file shows an example of what the import file can look like for one hypothetical vendor on the payment method page, when you select the vendor, it shows the bank account has been added when you open up the bank account, you can see the values match the import potential errors errors explanation solutioning data type must be default payment method or domestic bank account or international bank account data type was not filled in always include a data type, this is a mandatory field vendor id must be filled in vendor id was not filled in always include a 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 addresses format was not respected follow the following format something\@email com you would like to add multiple email addresses, confirm they are comma separated like so email1\@email com , email2\@email com both country and currency must be filled in country and currency both needs 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