This article explains how to bulk upload AP Payment Beneficiary Bank Account data into NetSuite using the native CSV Import Assistant, detailing the upload setup, field mapping, and the automated TransferMate validation process that follows.
Note: Clicking on the images within this guide will enlarge them for better viewing.
Step 1: Prepare the CSV file
- Populate the attached AP Payment Beneficiary Bank Account - CSV Upload template (attached below) with your vendors' Beneficiary Bank Account data using the guidance provided in the table below.
- Once completed, save the file in a CSV format and proceed to Step 2.
Important Notes:
- All fields marked as required in the table must be populated in the CSV file.
- Ensure that values entered in the CSV file match the corresponding names configured in NetSuite.
| Field | Required | Description | Example |
| Vendor | Yes | NetSuite Vendor Name. | Zone&Co |
| Subsidiary | Yes | Subsidiary associated with the Beneficiary Bank Account. | Netherlands |
| Currency | Yes | Currency of the Beneficiary Bank Account. | EUR |
| Bank Country | Yes | Country where the beneficiary’s bank is located. | Netherlands |
| Beneficiary Type | No | Enter whether the beneficiary is an Individual or a Corporate entity. | Corporate |
| Account Number Type | Yes | Enter the type of account identifier being used for the bank account. Available options include IBAN or Account Number. | Account Number |
| Account Number | Yes | Enter the beneficiary’s bank account number or IBAN. | 123456789 |
| SWIFT | Conditional | Enter the SWIFT/BIC code if known. This field is required when the Account Number Type is set to IBAN. | DEUTDEFF |
| Transit Code Type | Conditional | Enter the type of transit or routing code used by the bank. Available values include: ABA/Routing Number, Bank Code, BSB, IFSC, Other Number, Sort Code, and Transit & Institution Number. This field is required when the Account Number Type is set to Account Number. | Sort Code |
| Transit Code | Conditional | Transit code based on the selected transit code type. | 26073150 |
| Vendor Name | Yes | The Vendor Name will automatically populate based on the selected Vendor. If the Vendor has multiple bank accounts, enter a unique and easily identifiable name for this account. | Zone& Co Netherlands EUR Account |
| Vendor Street | Yes | The name of the street where the vendor resides. | Test Street |
| Vendor Building Number/Name | Yes | The building number and/or name where the vendor resides. | 2A |
| Vendor Town | Yes | The name of the town where the vendor resides. | Utrecht |
| Vendor City | Yes | The name of the city where the vendor resides. | De Meern |
| Vendor Postal Code | No | The postal code of the vendor. This field is mandatory for the following countries: USA, Canada, Malaysia, NZ, Australia and Philippines. | 3446 BW |
| Vendor State | Conditional | The appropriate state of the vendor in US and Canadian jurisdictions. For all other jurisdictions, leave blank. | |
| Vendor Country | Yes | Country of the Vendor. | Netherlands |
Step 2: Upload the CSV file
- On NetSuite, log in as an Administrator or another role with the "Import CSV File" permission.
- Navigate to Setup > Import/Export > Import CSV records. This will launch the Import Assistant.
- On the Scan & Upload CSV File page, select the following values:
- Import Type = Custom Records
- Record Type = AP Payment Beneficiary Bank Account
- CSV Column Delimiter = Comma
- Select the file to be uploaded, then click Next.
- On the Import Options page, select Data Handling = Add (when adding new vendor bank data) or Update/Add or Update depending on what you wish to do.
Show Advanced Options and ensure the following are enabled, then click Next.
- Validate Mandatory Custom Fields
- Run Server SuiteScript and Trigger Workflows
On the Field Mapping page, ensure that the csv fields are all mapped to the corresponding NetSuite fields under AP Payment Beneficiary Bank Account, then click Next.
On the Save mapping & Start Import page, enter a name for your import, then click Save & Run. This will allow easy access to selected fields for future imports of data related to this record.
Go to Setup > Import/Export > View CSV Import Status to confirm that the Import has a Complete status and that all records were imported successfully.
The AP Payment Beneficiary Bank Accounts data imported will be now be linked to the relevant Vendor records specified within the csv import. To check, open a Vendor record, then navigate to ZoneCapture subtab > AP Payment Automation > Beneficiary Bank Account list.
TransferMate Validation: Once the AP Payment Beneficiary bank account csv data is successfully uploaded and created, the data is automatically sent to TransferMate to be validated. If any data fails TransferMate validation, the AP Payment Beneficiary Bank Account record will display an error message with the reason why the data validation failed.
If this happens, Edit the record, update the failed data/field with the correct information, and click Save. The beneficiary bank account will be successfully created in TransferMate and a Success message will be displayed.