Setting Up Company Bank Records in Singapore
You must create company bank records from the Company Bank Details page for accurate validation and field sourcing. NetSuite does not recommend you to create company bank records by using SuiteScript APIs or CSV Imports.
Set up the bank account records that your company or subsidiaries will be using to send and receive electronic bank payments.
To set up company bank details in Singapore:
-
Go to Payments > Setup > Company Bank Details > New.
-
Complete the fields on the New Company Bank Details page.
Field
Description
Name
Enter a name for the bank record.
GL Bank Account
Select the GL account where the processed electronic bank payment transactions will be posted.
Note:The Subsidiary and Currency fields are automatically populated when a GL Bank Account is selected. Subsidiaries are only available in NetSuite OneWorld. If a GL bank account is not available in the dropdown list, go to Setup > Accounting > Manage G/L > Chart of Accounts > New to create one. For more information, see Creating Accounts.
Legal Name
Enter your company's legal name. This will be used in the electronic bank payment files.
Print Company Name
Enter the company name that should appear on email notifications of payment transactions sent to vendors, employees, and customers.
Marked by Default
Check this box if you want the payment transactions for this bank account automatically checked when they are displayed in the Bill Payment Batches list and the Bill Payments form.
EFT Template
Select any of the following Electronic Fund Transfer (EFT) payment file formats to use when making payments through this bank:
-
DBS Singapore Ideal 3.0 Universal File Format Domestic Transfer
-
DBS Singapore Ideal 3.0 Universal File Format International Transfer
-
DBS – IDEAL specifications of DBS Bank Limited
-
UoB – BIB-IBG specifications of United Overseas Bank Limited
-
ISO 20022 of HSBC
-
Citibank Singapore XML Domestic Transfer
-
Citibank Singapore XML International Transfer
-
Citibank Singapore XML GIRO
-
HSBC Singapore pain.001.001.03 Low and High Value Domestic Payments
-
JP Morgan Singapore pain.001.001.03 Low and High Value Domestic Payments
-
OCBC Singapore GIRO and FAST Payments
-
Standard Chartered Bank Singapore iPayment CSV GIRO and Domestic Payments
-
UOB Singapore pain.001.001.03 GIRO, FAST and Domestic Payments
Note:To use international transfer payment formats, you must have an active license for advanced Electronic Bank Payments and you must install the NetSuite SuiteApps License Client SuiteApp in your account. With active license for advanced Electronic Bank Payments, domestic and cross-border templates are available and you can edit the template as needed. If you use the free version of Electronic Bank Payments, only domestic templates are available and you cannot edit the template, but you can edit the PFA output file.
DD Template
Select any of the following Direct Debit (DD) payment file formats to use when receiving payments through this bank:
-
DBS-IDEAL DD
-
UoB – BIB-IBG DD
File Cabinet Location ID
Enter the internal ID of the folder that you created for storing payment format files. For more information, see Creating Folders in the NetSuite File Cabinet.
File Name Prefix
(Optional) Enter a prefix for the file number sequence. The prefix is attached to the beginning of each file number whenever this bank is used in creating a payment file.
-
-
Click Save.
-
Complete the additional bank detail fields.
Field
Description
Department
Select the department for payments made under this bank account.
Class
Select the class for payments made under this bank account.
Location
Select the location for payments made under this bank account.
Note:For each category, you can set up to 50,000 classes, departments or locations. Setting up more than 50,000 for each category may slow down the loading of the dropdown list of categories.
-
Complete the fields on the EFT Template Details (Bank Template Name) subtab. The fields displayed are dependent on the selected EFT Template. The following table lists the common fields displayed, you may disregard those that are not displayed.
Note:The EFT Template Details subtab is not displayed if you did not select a value in the EFT Template field.
Field
Description
Account Number/Bank Account Number
Enter your company's bank account number.
-
For DBS Singapore Ideal 3.0 Universal File Format Domestic Transfer - maximum of 35 digits
-
For DBS Singapore Ideal 3.0 Universal File Format International Transfer - maximum of 35 digits
-
For DBS – IDEAL – 11 digits
-
For UoB – BIB-IBG – 11 digits
-
For HSBC ISO 20022 – 7-12 digits
-
For Citibank Singapore XML Domestic Transfer - maximum of 34 digits
-
For Citibank Singapore XML International Transfer - maximum of 34 digits
-
For Citibank Singapore XML GIRO - maximum of 34 digits
-
For HSBC Singapore pain.001.001.03 Low and High Value Domestic Payments - maximum of 34 digits
-
For JP Morgan Singapore pain.001.001.03 Low and High Value Domestic Payments - maximum of 34 digits
-
For OCBC Singapore GIRO and FAST Payments - maximum of 34 digits
-
For Standard Chartered Bank Singapore iPayment CSV GIRO and Domestic Payments - maximum of 34 digits
-
For UOB Singapore pain.001.001.03 GIRO, FAST and Domestic Payments - maximum of 34 digits
Authorization Code
(For HSBC ISO 20022) Enter the authorization code for your payment files, as provided by the bank. Acceptable values include AUTH, FSUM, and FDET.
Sender's Company ID
Enter the 8-digit number that the bank uses to identify your company.
Bank Number/Bank Code
Enter the 4-digit identification code of your company’s bank.
Customer/EFT ID
(For HSBC ISO 20022) Enter your company’s HSBC Connect ID.
Country
Select the country where your company’s bank is located.
Swift/BIC Code
Enter the Business Identifier Code (BIC), also called SWIFT code, of your company’s bank.
Branch Number
Enter the identification code of the bank branch where your company’s account is maintained (maximum of 3 digits).
Sender’s Name
Enter your company’s legal name.
Process Bills Automatically
Check this box if you want to process payment transactions for this bank account in batches. For more information, see Processing Bills and Expenses in Batches. Leave this box clear if you want to process payment transactions for this bank manually. For more information see, Manually Processing Bills and Expenses.
Accounts Payable
Select the accounts payable register where the payments will be posted.
Hide Transactions
Check this box if you want to hide the transaction lines on the Bill Payment Batches form when processing payments in batches. For more information, see Processing Bills and Expenses.
Note:This feature is available if Process Bills Automatically is enabled or Marked by Default is enabled.
Address
Enter the address of your company’s bank; either structured (Street, Building Number, Postcode, Town, Country SubDivision, Country) or unstructured address, which must exist in the bank's Ordering Party Library.
-
-
Complete the fields on the DD Template Details subtab. The fields displayed are dependent on the DD format selected. The following table lists the common fields displayed, you may disregard those that are not displayed.
Note:The DD Template Details subtab is not displayed if you did not select a value in the DD Template field.
Field
Description
Bank Number
Enter the number that identifies the company's bank.
Branch Number
Enter the number that identifies the bank branch where your company’s account is maintained.
Bank Account Number
Enter your company's bank account number.
Sender's Company ID
Enter the 8-digit number that the bank uses to identify your company.
Process Bills Automatically
Check this box if you want to process payment transactions for this bank account in batches. For more information, see Processing Bills and Expenses in Batches. Leave this box clear if you want to process payment transactions for this bank manually. For more information see, Manually Processing Bills and Expenses.
Hide Transactions
Check this box if you want to hide the transaction lines on the Bill Payment Batches form when processing payments in batches. For more information, see Processing Bills and Expenses.
Note:This feature is available if Process Bills Automatically is enabled or Marked by Default is enabled.
-
If you want to create multiple payment batches for this bank account, complete the fields on the Batch Details subtab.
Field
Description
Batch Details Name
Enter a name for the payment batch.
Saved Search
Select the search criteria to group the bills and expenses that will be included in the payment batch.
Payment Schedule
Select a payment schedule for when the payment batches should be automatically created and submitted for processing. To set up payment schedules, see Setting Schedules for Payment Batches. You can leave this field blank and choose to manually trigger the system to create payment batches by clicking Refresh Batch.
Inactive
Check this box if you want to make a payment batch inactive. When you mark a record as inactive, it is not displayed in lists and dropdown fields. However, the record remains in the system for future reference.
Note:If you check the Inactive box for the main batch, bills that do not meet search criteria will not be included in the payment batch.
Email Recipient
Select the employee to whom a notification should be sent whenever payment batches are created per schedule.
Click Add to save the payment batch. You can create more payment batches for the bank account.
-
Click Save to save the company bank details.
If you want to set up approval routing for this bank account, see Setting Up Approval Routing for Payment Batches.