Electronic Invoicing for Colombia

NetSuite provides localized features to meet Colombia's invoicing requirements. Colombia Electronic Invoicing features are included in the Colombia Localization SuiteApp. For information, read the following topics:

Colombia Electronic Invoicing Overview

In Colombia, taxpayers are required to use electronic invoicing for all business transactions. Electronic invoicing in Colombia is called CUFE (Unique Electronic Invoicing Code) and it must follow a specific format set by the DIAN.

The Colombia Localization SuiteApp lets you generate and process outbound and inbound e-documents to comply with CUFE in Colombia.

Here are the transaction types you can use with outbound and inbound Colombia Electronic Invoicing:

Outbound

Inbound

Sales invoice

Cash Sale

Credit Memo

The XML e-documents generated from the supported transactions need DIAN certification as a prior step to being sent to customers.

In Colombia, technological service providers (certification providers authorized by the DIAN) handle all the communications between NetSuite and the Colombian tax authorities for certification.

After DIAN approves and stamps CUFE, the technological service provider sends the certified CUFE back to NetSuite.

The Colombia Localization SuiteApp includes integration with the following pre-configured Colombian technological service providers:

The SuiteApp also includes default e-document packages containing sending methods for certification and XML e-document templates, so can integrate with the technological service providers.

Package

Certification Sending Method

Template Name

Dispapeles E-document Package

Dispapeles Sending Method

  • Dispapeles national sales invoice template

  • Dispapeles export sales invoice template

  • Dispapeles national Debit Memo template

  • Dispapeles export Debit Memo template

  • Dispapeles national Credit Memo template

  • Dispapeles export Credit Memo template

Facture E-document Package

Facture Sending Method

  • Facture national sales invoice template

  • Facture export sales invoice template

  • Facture national Debit Memo template

  • Facture export Debit Memo template

  • Facture national Credit Memo template

  • Facture export Credit Memo template

Gosocket E-documents Package

Gosocket Sending Method

  • Gosocket national sales invoice template

  • Gosocket export sales invoice template

  • Gosocket national Debit Memo template

  • Gosocket export Debit Memo template

  • Gosocket national Credit Memo template

  • Gosocket export Credit Memo template

The templates included in the SuiteApp are adapted to the specific format used by the technological service provider to fulfill DIAN standards.

Colombia Electronic Invoicing Administrator Guide

Important:

To use the Colombia Electronic Invoice feature, first install and set up the Electronic Invoicing SuiteApp, which provides the framework for generating electronic sales invoices and supports the e-document certification process. See Electronic Invoicing Administrator Guide.

The Colombia Localization SuiteApp includes default e-document packages, e-document templates, and e-document certification sending methods for using electronic invoicing in Colombia. For an overview of these components, see Colombia Electronic Invoicing Overview.

First, the administrator should install the Electronic Invoicing SuiteApp, then the Colombia Localization SuiteApp. This adds the localized packages, certification sending methods, and templates to the Electronic Invoicing SuiteApp and they're automatically installed for the user. You can check the installation status on the Colombia Localization Components page. For more information, see Viewing Colombia Localization Component Installation Status.

To create new packages, templates and sending methods, see Creating E-Document Packages, Creating E-Document Templates and Creating E-Document Sending Methods

The sending method for sending certified e-document files to the customer (XML and PDF) must be manually created. For more information, see Setting Up an Email Sending Method for E-Documents.

You can restrict the editing of transactions based on the e-document status selected on an outbound e-document template record. For more information, see Creating E-Document Templates.

After installing the Colombia Localization SuiteApp, the account administrator needs to set up the technological service provider's credentials and other settings. This is a one-time setup to enable the provider and store their credentials in NetSuite. Each one provides user credentials (for example, username and password) for their test or production web services.

Colombia Electronic Invoicing User Guide

The Colombia Localization SuiteApp gives you custom forms with Colombia-specific fields to help you meet tax and government requirements in Colombia. For more information about Colombia custom forms and fields, see Colombia Localization Custom Forms and Colombia Localization Custom Fields.

To see which transactions are supported by the Colombia Electronic Invoicing feature, see Colombia Electronic Invoicing Overview.

Electronic Invoicing Field Mapping

To use electronic invoicing in Colombia, you should map some DIAN fields to values set up in the account. These values are associated to measurement units, payment methods, tax codes, currencies, and discount codes.

To map electronic invoicing fields for Colombia:

  1. Go to Setup > Colombia Localization > Colombia Fields Mapping.

  2. From the Category field, select the data category you want to map:

    • Payment method: map the payment methods recorded in the account to the codes defined by the DIAN. Select the value that applies and click Save.

    • Unit of Measurement: map the unit of measurement type to the corresponding value defined by the DIAN. Select the unit of measurement category and the unit type that requires mapping. The units applicable to this measurement unit type are displayed. Select the value that applies and click Save.

    • Discount codes: map discount items per subsidiary to discount defined by the DIAN. Select the subsidiary the discount item belongs to and assign the corresponding discount code.

    • Tax codes:

      • From the Mapping Type field, select DIAN codes if you want to map tax codes to the codes defined by the DIAN. Map tax codes to the DIAN-specific codes and click Save.

      • From the Mapping Type field, select Tax information, if you want to indicate information about withholding types (withholding or self-withholding) and withholding category (IVA, etc.) for each tax code.

    • Currency: map the currency codes to their corresponding currencies. For instance, CO_PESO for pesos and US_DOLLAR for dollars.

Colombia Localization and API Secrets

To keep the keys and passwords delivered by the technological service provider safe, you'll need to set up API keys.

To set up API keys for Colombia:

  1. Go to Setup > Company > API Secrets.

  2. Click Create New.

  3. Fill in the key information as your technological service provider tells you:

    • Gosocket: Build the key by joining the user and password with a colon (user:password). The resulting value should be translated to base64. You can use a web page (base64encode) or ask your tech team for advice. Fulfill the ID (custsecret) set up by the application in the User field of the CO Electronic invoicing setup page.

    • Dispapeles: Create a secret API value for the user and a secret API value for the password. Fulfill the ID (custsecret) set up by the application in the User and Password fields on the CO Electronic invoicing setup page.

    • Facture: Create a secret API value for the user and a secret API value for the password. Fulfill the ID (custsecret) set up by the application in the User and Password fields on the CO Electronic invoicing setup page.

For more information about the API secrets module, see Secrets Management.

Electronic Invoicing Setup

To use electronic invoicing in Colombia, you must have the Electronic Invoicing bundle (436209) installed. Also, you should have mapped the fields described in the mapping section and have registered the records associated to the DIAN resolutions. Additionally, you must perform the electronic invoicing setup.

To set up electronic invoicing for Colombia:

  1. Go to Setup > Colombia Localization > Electronic Invoicing Setup.

  2. Click New Electronic Invoicing Setup.

  3. Fill in the setup according to what the technological service provider delivered, as well as the organization’s preferences. This configuration must be performed per subsidiary.

    You must fill in the information related to the service connection, the PDF’s predetermined languages. On the tabs, you can find predetermined information for the PDF generation per each of the transactions supported.

  4. Click Save. The setup must be unique per subsidiary. If you attempt to generate two setups per subsidiary, the system won't allow it.

Electronic Invoicing Numbering Setup

To set up the different DIAN resolutions on each of the documents, make sure that the A/R Clerk role is authorized for the customized CO Resolution/Authorization record.

To set up electronic invoicing numbering for Colombia:

  1. Go to Setup > Colombia Localization > E. Invoicing Numerations > New.

  2. In the Name field, enter the name of the resolution corresponding to the transaction.

  3. From the Transaction category list, select Sale Transactions or Purchase Transactions.

  4. From the Subsidiary list, select the subsidiary corresponding to the numbering.

  5. In the Prefix field, enter the prefixes corresponding to the numbering.

  6. In the Resolution Number field, enter the DIAN’s authorized resolution number.

  7. In the Initial Number and Final Number fields, enter the number range authorized by DIAN.

  8. In the Validity Start Date and Validity End Date fields, enter the DIAN’s authorized dates for the resolution.

  9. In the Current Number field, enter the number the transaction should start with.

  10. From the Transaction type list, select the types of transaction that apply to this numbering.

  11. Check the Contingency box if the numbering corresponds to a contingency numbering.

  12. In field Point of Sale field, enter the point of sale associated to the resolution.

  13. In the Technical Key field, enter the technical key associated to the resolution.

Generating Manual Invoicing

You can create an Invoice by going to Transactions > Sales > Create Invoices (Administrator).

To generate manual invoicing for Colombia:

  1. Fill the required information in the Invoice transaction form.

    Notice the E-document subtab, related to NetSuite´s Electronic Invoicing module and the CUFE Information subtab, which contains the necessary information for electronic invoicing in Colombia.

  2. On the CUFE Information subtab, complete the fields required by the DIAN:

    • DIAN Resolution

    • DIAN Payment Method (if applicable)

    • DIAN Transaction Type

    • DIAN Operation Type

    • DIAN Service Date

  3. On the E-document subtab, enter the required information:

    • The XML template that you want to use depending on the type of transaction, regardless of whether it's foreign trade or not.

    • The available sending method for certification.

    • Follow the Electronic Invoicing guidelines described in Electronic Invoicing User Guide.

    • When you've entered all required information, click Save.

  4. Click Generate Electronic Document, as described on the electronic invoicing section.

  5. If the generation fails, click the E-document subtab and check the generation error details on the E-Document Audit Trail. You must first fix the errors before you can regenerate the e-document.

  6. After the document is generated, click Certify E-Document, as described on the electronic invoicing section.

  7. If the certification fails, check the error details on the E-Document Audit Trail log, to see both the technological service provider and the DIAN status.

  8. The E-Document Status field on the E-Document subtab also indicates the status of the certification process. If the document is successfully certified, the status changes change to Certification in progress and the automatic PDF process provides the certified documents.

Massive Invoicing

Go to Transactions > Sales > CO Massive E. Invoicing

Select the information you need to filter transactions. If you want to use different criteria, select the fields you want and click Filter or check the Send Without Selecting box.

When you click Filter, the transactions that match your criteria appear. Check the Select box at the start of the list and click Send Process.

If you've checked the Send Without Selecting box, click the Send Process and the massive process page appears.

When the process is run, the status appears as Completed or Completed Without Errors. If the process finishes with detail errors, you can see them at transaction line level so that you can fix them and stamp the transaction manually.

Colombia Electronic Invoicing Special Cases

General Notices