Electronic Bank Payments & Advanced Electronic Bank Payments

By - October 25, 2018

Electronic Bank Payments SuiteApp (EBP) enables you to process bank payments of vendor bills, employee expenses, partner and employee commissions, and customer refunds as well as receive bank payments from customers. Payment files will be generated and can be imported to your bank’s payment software or submitted electronically to your bank for processing. With EBP you can generate a file to electronically send to the bank to cross-verify checks. EBP extends the processing capabilities of Electronic Fund Transfers (EFT). Features such as Terms, Early Payment Discounts, and Credit Application are supported by EBP that are not supported by EFT.

 

Availability:

EBP SuiteApp enables companies and their subsidiaries to send payment to vendors, employees, and customers (refunds) or receive payments from customers located within their country of operations.

Advanced EBP SuiteApp enables companies and their subsidiaries to do everything EBP SuiteApp does but across the different support countries.

 

Limitations of EBP:

  • 5,000 open payment transactions for bills, invoices, or customer refunds can be processed at one time.
  • 10,000 open transactions can be processed per vendor, customer, partner, and employee. If this limit is surpassed only 10,000 will be included for EBP and the rest will be marked incomplete.
  • Processing through EBP overrides default payment methods that have been set on entity records, this prevents multiple payment processing.
  • EMP does NOT transmit payment files to the banks, Contact your bank for information about transmitting payment files using their EFT system.

 

Setting up EBP:

  1. Prerequisites
    1. Enable the following features prior to installing EBP.
      1. Item Options
      2. Custom Records
      3. Client SuiteScript
      4. Server SuiteScript
      5. Accounting Periods
      6. Advanced PDF/HTML Templates
  2. Installing EMP SuiteApp
    1. Bundle name: Electronic Bank Payments
    2. Bundle ID: 244403
    3. Location: Production
    4. Availability: Public
    5. Source Account: 5103995
      1. Key Points
        1. Highly encouraged to update EBP every month to get the latest version in sandbox.
  3. Installing Advanced EBP
    1. Bundle name: Advanced Electronic Bank Payments
    2. Bundle ID: 21147
    3. Location: Production
    4. Availability: Shared
    5. Source Account: 3525954
      1. Key Points
        1. Install EBP prior to installing Advanced EBP
        2. Global payments support may result in additional charges. Contact your NS rep for more info.
        3. Update sandbox every month if Advanced EBP is installed in the sandbox account to continue to use non-native formats and advanced features
  4. Installing the bundle
    1. Customization > SuiteBundler> Search & Install Bundles (Administrator), then choose the bundle you want to install. Either (244403 or 21147)
    2. Review the Preview Bundle Install Page
    3. Click the Install Bundle button
    4. Customization > SuiteBundler> Search & Install Bundles (Administrator), List
    5. Find the bundle you just installed
    6. Look at the Status and do not install another bundle until there is a green check mark in the status column.
  5. Setting Up Roles & Permissions
    1. The Custom EFT role is added to your account after installing EBP.
    2. Assign this role to employees or customize this role and then assign to employees.
      1. OneWorld: Access to subsidiaries to process their bill payments must be granted. To do this go to Custom role record, select both primary & secondary subsidiaries to allow access to their company bank details and other information that custom role can use for EBP transactions.
  6. Differences when bundle is installed
    1. Custom EFT role is added
    2. Payments tab is added

Setting up YOUR Bank Details

  1. Payments>Setup>Bank Details>New
  2.  Enter:
    1. Name
    2. GL Bank Account
    3. Legal Name
    4. Print Company Name
    5. EFT Template (Optional)-File format used for processing bills, expenses, commissions, or customer refunds. See section in this article titled “Supported Payment Formats”
    6. DD Template (Optional)- File format used for processing payments from customers. See section in this article titled “Supported Payment Formats”
    7. Positive Pay Template (Optional)- File format used to generate a list of issued checks from this bank account. See section in this article titled “Supported Payment Formats”
    8. Click Save
  3.  Scroll down to EFT Template Details (ACH – CCD/PPD)
  4.  Enter:
    1. Immediate Origin- Company TAX ID or 10-digit Number assigned by the bank to identify your company’s ACH files.
    2. Routing Number- 9 digit routing number
    3. Account Number- Company’s bank account number from bank.
    4. Immediate Destination Name- Name of the bank site where the payment will be processed.
    5. Company ID- Company Tax ID or company number assigned by your bank.
    6. Bank Account Type- Checking or Saving (Optional)
    7. Click Process Bills Automatically box
  5.  Click on DD Template Details (ACH – PPD)
    1. Immediate Origin- Company TAX ID or 10-digit Number assigned by the bank to identify your company’s ACH files.
    2. Routing Number- 9 digit routing number
    3. Account Number- Company’s bank account number from bank.
    4. Immediate Destination Name- Name of the bank site where the payment will be processed.
    5. Company ID- Company Tax ID or company number assigned by your bank.
    6. Bank Account Type- Checking or Saving (Optional)
  6.  Click Positive Pay Template Details (SVB –CDA)
    1. Immediate Origin- Company TAX ID or 10-digit Number assigned by the bank to identify your company’s ACH files.
    2. Routing Number- 9 digit routing number
    3. Account Number- Company’s bank account number from bank.
    4. Immediate Destination Name- Name of the bank site where the payment will be processed.
    5. Company ID- Company Tax ID or company number assigned by your bank.
    6. Bank Account Type- Checking or Saving (Optional)
  7.  Click Save

Setting up VENDOR Bank Details

  1. Lists> Relationships> Vendors
  2. Click “edit” Vendor or create new Vendor.
  3. Click Bank Payment Details
  4. Click the check box EFT Bill Payment
  5. Click Save As
  6. Click New Entity Bank Details
  7.  Enter:
    1. Payment File Format
    2. Type
    3. Bank Account Number
    4. Bank Number
    5. Bank Account Type
    6. Save

Importing Vendor Bank Details

  1. Setup> Imports/Exports> Import CSV Records
  2. Scan & Upload CSV File Page
    1. Import Type=Customer Records
    2. Record Type= Entity Bank Details
    3. Upload the file
    4. Click Next
  3. Import Options Page
    1. Data Handling= Add (Update when Updating Entity Bank Details records)
    2. IMPORTANT: On Advanced Options section:
    3. Custom Form=Standard Entity Bank Details Form
      1. Run server SuiteScript and Trigger Workflows=True
    4.  Click Next
  4.  Field Mapping Page
  5. Your fields < > NetSuite Fields
    1. Bank Account Number = Entity Bank Details : Bank Account Number
    2. Bank Account Type = Entity Bank Details : Bank Account Type
    3. Bank Number(Routing Number) = Entity Bank Details : Bank Number
    4. Type(Checking or Saving) = Entity Bank Details : Type (Req)
    5. Payment File Format(ACH – CCD/PPD)= Entity Bank Details : Payment File Format (Req)
    6. Internal ID = Entity Bank Details :  Parent Vendor

**Click the pencil icon to the left of the Internal ID                           and in the Choose Reference Type to Internal ID

    1. Click Next
    2. Save & Run

Pay Vendors:

  1. Payments>Payment Processing>Bill Payment Processing
  2. Enter:
    1. Bank Account
    2. AP Account Pay out of
    3. Date that it will be process on (Bank)
    4. EFT File Reference Note
    5. Select bills to pay
    6. Click Submit
  3. Payment File that you can download and import to your bank
    1. You will be redirected to the Payment file Administration page.
      1. Can also navigate to this page by Payment>Payment Processing>Payment File Administration. This will show any file that has previously generated.
    2. There will be a “download” button that will download the file.
      1. If this the File Reference has not appeared click the Refresh button.

Invoice Payment:

  1. Payments>Payment Processing>Invoice Payment Processing
  2. Enter:
    1. Bank Account
    2. A/R Account
    3. DD File Reference Note
    4. Select Transaction/s to pay
    5. Submit

Positive Pay:

  1. Payments>Cheques>Positive Pay format
    1. Works specifically on checks you cut from your bank account.
    2. Pick your bank account
    3. Identify the date the last check run happened.
    4. Submit this form
    5. Text File will be generated and you can import this file into your bank.
  2. Payment File that you can download and import to your bank
    1. You will be redirected to the Payment file Administration page.
      1. Can also navigate to this page by Payment>Payment Processing>Payment File Administration. This will show any file that has previously generated.
    2. There will be a “download” button that will download the file.
      1. If this the File Reference has not appeared click the Refresh button.

Supported Payment Formats:

The following tables and lists show the EFT, Direct Debit transactions, and Positive Pay service supported by EBP:

 

EFT
Country EFT Format
Austria SEPA (Austria) Pain.001.001.02
SEPA Credit Transfer (Austria)
SEPA Credit Transfer (HSBC)
Australia ABA
ANZ (ANZ Bank)
ASB (ASB Bank)
BNZ (Bank of New Zealand)
DeskBank (WestPac Bank)
Belgium CIRI – FBF
SEPA Credit Transfer (Belgium)
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (HSBC)
Brazil CNAB240
Canada ACH CCD/PPD (NACHA)
ACH – CTX (Free Text) (NACHA)
CPA – 005 (Royal Bank of Canada)
PNC ActivePay (PNC Bank)
Czech Republic ABO
SEPA Credit Transfer (HSBC)
France CFONB
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (France)
SEPA Credit Transfer (HSBC)
Germany DTAUS
DTAZV
SEPA Credit Transfer (Germany)
SEPA Credit Transfer (Austria)
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (HSBC)
Hong Kong HSBC ISO 20022
Hungary RaiffeisenDomestic Transfer (Raiffeisen Bank)
Ireland BACS – Bank of Ireland
SEPA Credit Transfer (Bank of Ireland)
SEPA Credit Transfer (HSBC)
Isle of Man BACSTEL – IP
Italy CBI Payments
SEPA Credit Transfer (CBI)
SEPA Credit Transfer (HSBC)
Japan Zengin
Luxembourg ABBL VIR 2000
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (Luxembourg)
SEPA Credit Transfer (HSBC)
Netherlands Equens – Clieop
Equens – Clieop (ING Bank)
SEPA Credit Transfer (ABN AMRO and Rabobank Bank)
SEPA Credit Transfer (Netherlands)
SEPA Credit Transfer (HSBC)
New Zealand ABA
ANZ (ANZ Bank)
ASB (ASB Bank)
BNZ (Bank of New Zealand)
DeskBank (WestPac Bank)
Singapore HSBC ISO 20022
Interbank GIRO (JP Morgan)
DBS – IDEAL (DBS Bank)
UoB – BIB-IBG (United Overseas Bank)
South Africa Standard Bank
Spain AEB – Norma 34
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (HSBC)
Sweden Bankgiro (SEB)
Plusgiro (SEB)
SEPA Credit Transfer (SEB)
UK BACS (HSBC)
BACS – Albany ALBACS-IP (Albany ePay Bureau, Barclays Bank, and Lloyds Bank)
Note
 
Same as BACS Multiple Fixed Length format Lloyds Bank.
 
BACSTEL – IP (NatWest Bank)
BACS – Bos (Bank of Scotland)
BACS – Bank of Ireland
SEPA Credit Transfer (ABN AMRO Bank)
SEPA Credit Transfer (HSBC)
US ACH CCD/PPD (NACHA)
ACH – CTX (Free Text) (NACHA)
CPA – 005 (Royal Bank of Canada)
PNC ActivePay (PNC Bank)
Direct Debit
Country Direct Debit Format
Australia ABA DD
Germany DTAUS DD
SEPA Direct Debit (Germany)
Italy CBI Collections
SEPA Direct Debit (CBI)
Netherlands SEPA Direct Debit (ABN AMRO)
Singapore DBS – IDEAL DD (DBS Bank)
UoB – BIB-IBG DD (United Overseas Bank)
UK BACS DD (HSBC)
US ACH – PPD (NACHA)
Positive Pay
Country
BoA/ML (Bank of America Merrill Lynch)
RBC (Royal Bank of Canada
SVB – CDA (Silicon Valley Bank – Controlled Disbursement Accounts)
Global Payment Format
Barclays MT103
J.P. Morgan Freeform GMT

Payment File Administraion/How EBP works:

  1. Bank would accept and execute payment
  2. NS marks these records as paid and created bill payment records
  3. Email Payment notification-Send emails to vendors that we have paid them
    1. Subject
    2. Notes/Message
    3. Pick Vendors to send to
  4. It identifies Email notificaitons that have been sent out.
  5. Right click bill payment
  6. On bill payment stores that you sent this message to the vendor.

 

Sources:

https://netsuite.custhelp.com/app/answers/detail/a_id/21729/kw/electronic%20bank%20payments

https://netsuite.custhelp.com/app/answers/detail/a_id/35023

https://netsuite.custhelp.com/app/answers/detail/a_id/7567/related/1

https://netsuite.custhelp.com/app/answers/detail/a_id/7541/related/1

Receive Posts by Email

Subscribe and receive notifications of new posts by email.