Importing Bank Details to NetSuite

This guide outlines how to import bank details from a CSV file into NetSuite.

In order to correctly send payments to Atlar you need to update your bank details to contain some specific information (mainly the Atlar Credit Transfer file format). This can be done in one of two ways:

  • Manual Entry: Perfect for smaller sets of entities to update
  • Bulk Entry: Suitable for larger numbers of entities to configure

The process for both these options are described below!

Manual Entry

To set up bank details for entities such as vendors, customers, or employees, follow these steps:

  1. Navigate to the record for the entity (e.g., Customer, Employee, or Vendor) in NetSuite.
  2. Enable the checkbox EFT BILL PAYMENT. ℹ️ This field might not be visible, if so make sure to select the Custom Form to be Standard Vendor Form which has the field visible!
  3. Locate the Bank Payments Details subtab within the record.
  4. Click New Bank Detail to add a new bank account for the entity.
  5. Under the Payment File Format field, select Atlar (Credit Transfer). This ensures the bank details are compatible with Atlar File Payments (Sometimes there is a warning when setting this field which is okay to just "accept").
  6. Fill in the required bank account information. For the payment schemes abbreviations one can refer to this guide.
  7. Save the record.

Repeat these steps for each entity that requires bank details for payments. This setup ensures that payments to or from these entities are processed correctly using the Atlar-specific file format.

Bulk Entry

If you have a large number of entities to configure, you can use the CSV import method for faster setup:

  1. Download the preformatted spreadsheet template provided by Atlar.
  2. Populate the template with the required bank details for each entity. Ensure all mandatory columns are completed accurately. For the payment schemes abbreviations one can refer to this guide.
  3. Save the populated spreadsheet as a CSV file.
  4. Search for Saved CSV Imports in the NetSuite global search bar.
  5. Locate the import task labeled Atlar - Bank Details Import and click on the name.

At this stage, upload your file and apply any necessary customizations, such as selecting the CSV delimiter. Click Next to proceed through the import options. The field mapping is preconfigured but certain fields needs additional configuration. The Parent ID field is mapped to Vendors by default; if importing bank details for employees, change this mapping to Employees. Make sure that the field Payment File Format is mapped to Atlar (Credit Transfer). This flexibility ensures the import process fits your specific requirements.