Electronic Bank Payments for Colombia

Important:

To use Electronic Bank Payment File Layouts for Colombia, you must install the Electronic Bank Payments SuiteApp, which provides the framework for generating electronic bank payment files. For more information about setting up the Electronic Bank Payments SuiteApp, see Setting Up Electronic Bank Payments.

The Colombia Localization SuiteApp provides some templates to help you generate electronic bank payment files to pay vendor invoices in Colombia.

The administrator should first install the Electronic Bank Payments SuiteApp, followed by the installation of the Colombia Localization SuiteApp. By doing so, the Colombia Localization SuiteApp adds the Electronic Bank Payment file templates to the Electronic Bank Payment SuiteApp. You can view the installation status of these templates on the Colombia Localization Components page. To visualize the Colombia Localization components installation status, go to Setup > Colombia Localization > Localization Components.

For more information about creating electronic bank payment files, see Electronic Bank Payments

The templates provided with the Colombia Localization SuiteApp support payment file formats specified by the major Colombian banks. These are the templates currently delivered:

• Bancolombia

• Banco de Bogotá

• Davivienda

Before you can use a payment file format for Colombia, you must set up the relevant bank details and other information that the system requires. For more information about setting up bank records for your company, subsidiaries, and vendors, see Colombia Payment Formats.

Colombia Payment Formats

The Colombia Localization SuiteApp enhances the Electronic Bank Payments SuiteApp by providing the necessary layouts for generating electronic bank payment files for Colombia.

To set up Electronic Bank Payments for your company, subsidiaries, and vendors in Colombia, read the following topics:

• Setting Up Company Bank Records in Colombia

• Setting Up Bank Records of Vendors in Colombia.

Setting Up Company Bank Records in Colombia

To set up company bank records:

1. Go to Payment > Setup > Company Bank Details > New.

2. 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 are 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, to create one go to Setup > Accounting > Chart of Accounts > New.
   Legal Name	Enter the company’s legal name. This is 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.
   Marked by Default	Check this box if you want the payment transactions for this bank account to be automatically checked when they are displayed in the Invoice Payment Batches list and the Invoice Payments form.
   EFT template	Select the applicable payment file format template to use for Colombia.
   File Cabinet Location	Enter the internal ID of the folder file that you created for storing payment formal 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.

3. Click Save.

4. 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 select 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.

5. Complete the fields on the EFT Template Details subtab:

   Bancolombia, Banco de Bogotá, Davivienda template details	Description
   Código del Banco (Bank Code)	The bank code consists on a two-digit number that distinguishes a bank or its office, as well as its accounts or operations.
   Tipo de Cuenta (Account Type)	Indicate if it is a savings account or a checking account.
   Número de Cuenta (Account Number)	Enter the bank account number.

6. 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 invoices and expenses that are 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. However, the record remains in the system for future reference. Note: If you check the Inactive box for the main batch, the invoices that do not meet search criteria are not included in the payment batch.
   Email Recipient	Select the employee whom the notifications will be sent to when payment batches are created according to the program.

7. Click Add to save the payment batch. You can create more payment batches for the bank account.

8. Click Save to save the company bank details.

If you want to set up an approval routing for this bank account, see Setting Up Approval Routing for Payment Batches.

Setting Up Bank Records of Vendors in Colombia

Set up the bank account records of each vendor to whom you send electronic bank payments. You can set up multiple bank accounts for each vendor.

To set up vendor bank details in Colombia:

1. Go to Lists > Relationships > Vendors.

   For more information about adding a vendor, see Creating a Vendor Record.

2. Click the Edit link next to the name of the vendor.

3. On the Bank Payment Details subtab, check the EFT Invoice Payment box and click Save.

4. Click New Bank Details.

5. Complete the fields on the Bank Details page for Bancolombia, Banco de Bogotá and Davivienda:

   • Name

   • Payment File Format

   • Type

   • Número de Cuenta (Bank Account Number)

   • Código del Banco(Bank Number)

   • Tipo de Cuenta (Account Type)

6. Click Save.

You can also set up bank records of vendors by importing bank details in CSV format into NetSuite by using the Import Assistant. For more information, see Importing Electronic Bank Payments Data.

General Notices