The Entity Bank Details [EBD] bundle, in combination with the standard NetSuite vendor record, will store all information required to submit payments via the bundle.  This imported vendor and employee data can be viewed after the installation by going to 

Setup → Entity Bank Details → Overview

Importing and exporting EBD records on either the Entity or Employee tabs work exactly the same. The only difference is on the Vendor tab where there is a small section where end users who have NetSuite’s Electronic Bank Payments bundle installed can export data to re-upload into EBD.

These instructions are the same for importing Vendor or Employee data.

 to download a blank CSV template, then use this CSV to fill out Bank Details for bulk upload.

 section of this page for a table containing all formatting requirements for the CSV file.

In the same Import/Export screen, upload the formatted CSV document.

Confirm successful upload by checking the 

to ensure all records uploaded successfully.

 of the vendor record to ensure all information is correctly updated.

These instructions are the same for exporting Vendor or Employee data.

 button to trigger a CSV download of all records kept in EBD. The table will display a history of all exports created, alongside timestamps and buttons to download each of these files.

“Export Logs” contains more information about the export files generated. This can be found under the “Execution Log” tab. For each line item, it will report who initiated the export, the number of records exported in the one file, as well as the file name for that particular export.

Updating Existing EBD Records Using Import/Export

Users can bulk edit a number of existing Entity Bank Details (EBD) records using the Import/Export feature.

 section on how to export a CSV file of existing EBD records. 

Please note that this Export CSV file contains an ID column that is not present on the blank CSV import template. Using the blank CSV import template instead of the export CSV file will create new records and may result in unwanted duplicate bank detail records.

In the application of your choice (Microsoft Excel, Numbers, etc.) please make edits to the existing data in the exported CSV file. Ensure the ID column on the far left remains untouched.

You may also add new records in by adding them as a new row to your CSV.

After making edits to the previously exported file, you may now import the CSV file back into the Entity Bank Details bundle. Either select a CSV file to upload, or drag-and-drop one into the Import Data section of the Import/Export page.

Transferring Bank Details from Electronic Bank Payments bundle

Without the Entity Bank Details bundle, users are only able to make ACH and CPA payments through the bank plugin using information stored in NetSuite's Electronic Bank Payments bundle. 

Once the Entity Bank Details bundle is installed, the Electronic Bank Payments bundle will no longer be used to grab payment information for bill payments made through the plugin. The Entity Bank Details bundle provides the ability to transfer ACH and CPA vendor banking information from the Electronic Bank Payments bundle to the Entity Bank Details bundle via CSV. 

ACH and CPA banking information stored in the following default Payment File Formats are supported:

Transferring ACH and CPA banking information that is stored in custom Payment File Formats is unsupported.

To quickly transfer information across bundles, follow the steps below.

Click to show Electronic Bank Payments export.

 This will generate a CSV file(s) dependent on the “Number of Entries for Each File” set below. For example — if you have 1100 records and set the number of entries to 200, the bundle will generate five CSVs containing 200 records and one CSV containing 100 records.

or drag and drop the CSV file(s) into the Import Data box.

Wait a few moments for the import to complete. Once complete, select 

You can also check the following places to confirm bank details have been saved:

This document provides an overview of the absence of content or information to be summarized.

Viewing Entity Bank Details

Entity Bank Details Bundle Import/Export

BusinessDays

YourBank

MyBank

Entity Bank Details Approvals

Commerce Bank

Welcome

Untitled

Pre-Onboarding Checklist (NetSuite)

Installation and Set-up

Post-Onboarding Checklist (NetSuite)

Configuration

Entity Bank Details