Setting Up Company Bank Records in the U.S.
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 the U.S.:
-
Go to Payments > Setup > 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 either ACH-CCD/PPD or ACH-CTX (Free Text).
Cash Concentration and Disbursement (CCD) and Prearranged Payments and Deposits (PPD) are the payment file formats primarily used for business-to-business transactions and payments to consumers, respectively.
Corporate Trade Exchange (CTX) is a payment file format used by corporations and government agencies to pay their trading partners.
DD Template
Select ACH-PPD.
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 subtab. The fields displayed are dependent on the EFT format selected.
Field
Description
Immediate Origin
Enter the 10-digit company Id assigned by your bank. This is usually one digit followed by your company's tax Id.
Routing Number
Enter the bank's transit routing number.
Account Number
Enter your company's bank account number.
Immediate Destination Name
Enter the name of the bank's site where the payment will be processed.
Company ID
Enter the 10-digit company number assigned by your bank. This is usually one digit followed by your company's tax Id.
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.
-
Complete the fields on the DD Template Details subtab.
Field
Description
Immediate Origin
Enter your company's 10-digit number assigned by the bank.
Routing Number
Enter the bank's transit routing number.
Account Number
Enter your company's bank account number.
Immediate Destination Name
Enter the name of the bank's site where the payment will be processed.
Create Balanced Files
Check this box to include a contra record line in the payment file to create a balanced file. Check whether your bank requires this for EFT transactions.
Company ID
Enter your company's tax Id or the company number assigned by your bank.
Bank Account Type
Select Checking or Savings to indicate the bank account type.
Add Pad Blocks
Check this box to add lines with "9" characters at the end of the payment file when the total number of records is not a multiple of 10. Check whether your bank requires this option for EFT transactions.
-
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.