Audience: External | ZoneCapture Admins
This article explains how to bulk upload AP Payment Beneficiary Bank Account data into NetSuite using the native CSV Import Assistant, covering 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
- Download the AP Payment Beneficiary Bank Account — CSV Upload template attached to this article and populate it with your vendors' Beneficiary Bank Account data using the field guidance in the table below.
- Save the completed file in CSV format, then proceed to Step 2.
Important: All fields marked as Required: Yes in the table below must be populated. Ensure all values entered in the CSV file match the corresponding names configured in NetSuite exactly.
| 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 used for the bank account. Available options: 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. Required when Account Number Type is set to IBAN. | DEUTDEFF |
| Transit Code Type | Conditional | Enter the transit or routing code type used by the bank. Available values: ABA/Routing Number, Bank Code, BSB, IFSC, Other Number, Sort Code, and Transit & Institution Number. Required when Account Number Type is set to Account Number. | Sort Code |
| Transit Code | Conditional | Enter the transit code that corresponds to the selected Transit Code Type. | 26073150 |
| Vendor Name | Yes | Automatically populated based on the selected vendor. If the vendor has multiple bank accounts, enter a unique, easily identifiable name for this account. | Zone&Co Netherlands EUR Account |
| Vendor Street | Yes | The street name of the vendor's address. | Test Street |
| Vendor Building Number/Name | Yes | The building number and/or name of the vendor's address. | 2A |
| Vendor Town | Yes | The town of the vendor's address. | Utrecht |
| Vendor City | Yes | The city of the vendor's address. | De Meern |
| Vendor Postal Code | No | The vendor's postal code. Required for the following countries: USA, Canada, Malaysia, New Zealand, Australia, and Philippines. | 3446 BW |
| Vendor State | Conditional | The vendor's state. Required for US and Canadian addresses only. Leave blank for all other jurisdictions. | |
| Vendor Country | Yes | The vendor's country. | Netherlands |
Step 2: Upload the CSV file
- Log in to NetSuite as an Administrator or a role with the Import CSV File permission.
- Navigate to Setup > Import/Export > Import CSV Records to launch the Import Assistant.
- On the Scan & Upload CSV File page, set the following values:
- Import Type: Custom Records
- Record Type: AP Payment Beneficiary Bank Account
- CSV Column Delimiter: Comma
- Select your completed CSV file, then click Next.
- On the Import Options page, set the Data Handling field:
- Select Add when adding new vendor bank data.
- Select Update/Add or Update when modifying existing records.
- Select Show Advanced Options and confirm the following checkboxes are selected, then click Next:
- Validate Mandatory Custom Fields
- Run Server SuiteScript and Trigger Workflows
- On the Field Mapping page, confirm all CSV columns are mapped to the corresponding fields under AP Payment Beneficiary Bank Account, then click Next.
- On the Save Mapping & Start Import page, enter a name for the import, then click Save & Run. Saving the mapping allows easy reuse for future imports of this record type.
- Navigate to Setup > Import/Export > View CSV Import Status and confirm the import shows a Complete status with all records imported successfully.
- Verify that the imported Beneficiary Bank Account records are linked to the correct vendor records. Open a Vendor record, then navigate to the ZoneCapture subtab > AP Payment Automation > Beneficiary Bank Account list.
Important: Once the CSV data is successfully uploaded, it is automatically sent to TransferMate for validation. If any record fails validation, an error message with the reason is displayed directly on the affected AP Payment Beneficiary Bank Account record. To resolve the error, open the record, click Edit, correct the invalid field, and click Save. The record will then be successfully created in TransferMate and a success message will be displayed.