Import Bank Connect Vendor Recipient Accounts

Overview

This guide outlines how to import multiple Bank Connect vendor recipient accounts into NetSuite by using a CSV file.

This process allows you to efficiently configure vendor payment details in bulk, rather than entering them manually.

Prerequisites

Before proceeding, ensure the following:

  • Vendor records already exist in NetSuite
  • You have access to the Import Assistant in your NetSuite instance
  • You have downloaded the Bank Connect Recipient Account Import template (attached at the bottom of this article)

If vendor records do not yet exist, please

Prepare Your Data File

Use the provided Excel template (Bank Connect Recipient Account Import) to populate recipient account details and save the Excel file.

Required Fields:

Ensure the following fields are completed for each record:

Field Description
Entity * Must match Vendor ID in NetSuite
Name * Unique name for the payment method (e.g., “ACH Operating”)
Payment Type *

Payment type - enter one of the following:

• ACH-CCD
• ACH-PPD
• CTX
• RTP
• Wire
Account Number * Vendor’s account number (ensure preceding zeros are included if applicable)
Routing Number * Vendor’s routing number (ensure preceding zeros are included if applicable)
Account Type *

Enter the closest match from the following options: 

• Checking 
• Savings
Address Line 1 * Vendor’s bank address
City * Vendor’s bank city
Zip Code * Vendor’s bank zip code
State * Vendor’s bank state (e.g., “New York”)
Country * Vendor’s bank country (e.g., “United States”)

Optional Fields

Field Description
Primary Enter “Y” if this is the vendor’s default payment method, or leave blank
Address Line 2 / 3 Additional vendor’s bank address details

Note: Fields marked with * are required.

Save file as CSV

Once all data is populated:

  1. Navigate to File → Save as…
  2. Select file format CSV UTF-8 (Comma delimited) (.csv)

  3. Save the file on your local drive

Upload File in NetSuite

  1. In NetSuite, navigate to Setup → Import/Export → Import CSV Records

  2. On the Scan & Upload CSV File step, select the following:
    • Import Type: “Custom Records”
    • Record Type: “Bank Connect Recipient Account”
    • Character Encoding: “Western (Windows 1252)”
    • CSV Column Delimiter: “Comma”
    • CSV Files: “One File to Upload”
    • Select: Select your CSV file

  1. Once the file is attached, click Next

Select Import Options

  1. Select: Add or Update

  2. Click Next

 

 

Field Mapping

  1. Review and confirm that all CSV fields are correctly mapped to the corresponding Bank Connect fields in NetSuite.
    • Ensure all required fields are mapped
    • Adjust any unmapped fields manually

  2. Compare your mapping with the reference screenshot below.

  3. Click Next

Run Import

  • On the final step, click Run to start import process

Validate Import Results

  1. After submission, navigate to Import Job Status page

  2. Confirm the import completed successfully
    • If errors occur, review error messages
    • Correct the affected rows by repeating import steps above
    • Re-upload only the corrected records.

Bank Connect Recipient Account Import Template