Colombia

Colombia is now available as a country in LN.

You can activate the Colombian country localization in the Implemented Software Components (tccom0500m000) session.

To comply with the tax regulations and follow the codifications required by the tax authority DIAN (Dirección de Impuestos y Aduanas Nacionales, National Directorate of Taxes and Customs), the Colombian localization includes country-specific master data, withholding tax processing, and various reports.

Withholding tax calculation

If the Calculate Withholdings check box is selected for the transaction type in the Transaction Types – Fiscal Data Colombia (lpcol1100m000) session, you can calculate and post withholding tax for Colombia. In the sessions that are used to insert financial transactions, you can click Documents with Colombia Withholding Tax to start the Documents with Colombia Withholding Tax (lpcol2102m000) session. This session calculates the withholding taxes in test mode, taking into account the withholding setup specified for the business partner in the Business Partners – Fiscal Information Colombia (lpcol0108m900) session.

For purchase invoices and sales invoices, the control-account posting is reduced by the withholding amount. The purchase invoice matching process considers the withholding amount.

This functionality is also used by Sales Orders and Manual Sales, through the Colombia Sales Order Tax Data (lpcol3100m000) and Colombia Manual Sales Invoice Tax Data (lpcol3110s000) sessions.

Withholding certificates

The periodic and annual withholding certificates can be printed with these sessions:

  • Periodic Withholding Certificates (lpcol2408m000)
  • Annual Withholding Certificates (lpcol2408m001)

In accordance with the dispositions of DIAN, withholding certificates are requested by customers and suppliers in Colombia to confirm the withholdings applied to them in purchase or sales transactions. The certificates can be printed annually, monthly, or as required by law. These certificates are available:

  • Withholding at the Source (income Tax) certificate
  • Withholding ICA (Impuesto de Industria y Comercio, Industry and Trade Tax) certificate
  • Withholding VAT certificate

Inquiries

With these inquiry sessions, you can view the withholdings from accounts payable and accounts receivable:

  • Outstanding Supplier Invoices – Header Tax (lpcol2506m000)
  • Outstanding Supplier Invoices – Line Tax (lpcol2507m000)
  • Outstanding Customer Invoices (lpcol2509m000)

Legal reporting

In accordance with the national rules and principles required by the Colombian authorities, legal reporting sessions are available to produce the books for recording the economic facts.

These books are available:

  • General Ledger and Balance Book: This book includes the summary of all transactions for each ledger account, including the previous balance, its debit and credit movements, and the final balance. The report can be printed from the Print Chart of Account – Additional Data Colombia (lpcol0411m001) session.
  • Inventories and Balance Book: This book includes the ledger accounts' closing balance. Only ledger accounts with sublevel 0 are included. You can print the report from the Print Chart of Account – Additional Data Colombia (lpcol0411m001) session.
  • Journal Book: This book records general ledger transactions in chronological order, individually or through global summaries. You can print the report from the Print Journal Book (lpcol1406m000) session.

Legal forms

For business partners who have the VAT Regime field set to Simplified in the Business Partner – Fiscal Information Colombia (lpcol0108m900) session, the legal form Equivalent Purchase Invoice can be generated in the Print Equivalent Purchase Invoices (lpcol2400m100) session.

Auxiliary reporting

Several auxiliary reporting sessions are also available. You can, for example, print the withholding details and analysis, the ICA auxiliary, the sales list, the business partner balances, the general ledger transactions, and the list of business partners which do not have fiscal information for Colombia.

These sessions are supported for auxiliary reporting:

  • Print Withholding Details per Purchase Invoice (lpcol2406m900)
  • Print Withholding Details per Sales Invoice (lpcol2409m900)
  • Print Withholding Analysis (lpcol2405m900)
  • Print Withholding Analysis by Account (lpcol2405m900)
  • Print VAT Analysis – Purchase/Sales (lpcol1410m000)
  • Print ICA Auxiliary (lpcol1406m002)
  • Print Sales by City (lpcol3405m003)
  • Print Business Partner Balances (lpcol2410m000)
  • Print General Ledger Transactions (lpcol1406m004)
  • Print Business Partners without Fiscal Information Colombia (lpcol1400m000)

Utilities

It is required to structure information by a business partner's tax identification. Consequently, to update the opening balances and the accounting movements, these utility sessions are available:

  • Initialize Business Partners Opening Balance (lpcol2210m000)
  • Rebuild Business Partner Ledger Movements (lpcol2210m001)

Master data

In the Master Data menu of the Colombian localization, these sessions are available:

  • Billing resolution (lpcol0180m000) - Used to register the invoicing resolutions assigned to each company by the tax authority DIAN.
  • Equivalent Purchase Invoice Configuration (lpcol0185m000) - Used to store the authorization to issue equivalent purchase invoices.
  • Withholding Certificates Configuration (lpcol0180m000) - Used to include the fiscal data that refers to the different withholding types.

In relation to configuration details and DIAN codifications, the Withholding Manager subfolder includes these sessions:

  • City DIAN Codes (lpcol0101m000)
  • Country DIAN Codes (lpcol0112m000)
  • Commercial Activities (lpcol0102m000)
  • Effective ICA Rates (lpcol0103m000), by city and commercial activity
  • Companies – Fiscal Parameters (lpcol0100m000), by financial company
  • Withholding Tax Codes (lpcol0104m000), where the linked concept type can be specified
  • Tax Regimes (lpcol0106m000)
  • Tax Codes by Country – Additional Data Colombia (lpcol0110m000)
  • Chart of Accounts – Additional Data Colombia (lpcol0111m000)
  • Transaction Types – Fiscal Data Colombia (lpcol1100m000)

Magnetic Media

The Colombian Tax Authority DIAN (Dirección de Impuestos y Aduanas Nacionales) requires that companies, public institutions, and natural persons report their annual financial operations by business partner through the Magnetic Media scheme, also called Exogenous Information.

For the Colombian localization, the required data can be generated in these legal reports, as defined in the Colombian Resolution number 000124 and its annexes:

  • Format 1001 – Expenses and related VAT and withholdings
  • Format 1003 – Withholding tax charged at source by the customers
  • Format 1005 – Deductible VAT from Purchases and returned Sales
  • Format 1006 – Generated VAT from Sales and returned Purchases
  • Format 1007 – Gross Revenues
  • Format 1008 – Accounts Receivable Balances as of December 31st
  • Format 1009 – Accounts Payable Balances as of December 31st

These steps are completed in the process:

  1. Master data configuration
    • In the DIAN Report Formats (lpcol4120m000) session, the predefined Magnetic Media format codes are initiated by the Generate Supported Report Formats action.
    • In the Concepts by DIAN Report Format (lpcol4121m000) session, you configure the relationship between a format and the concepts, which are minor groupings or subgrouping of information specified in the Magnetic Media resolution. The available parametrization enables you to specify these relationships as indicated in the resolution.
    • In the Accounts by Report Format and Concept (lpcol4122m000) session, the accounts are assigned to each format and concept.
    • In the Transaction Types to Report (lpcol4124m000) session, you specify if the transaction types created in LN must be reported on Magnetic Media.
    • In the DIAN Report Format Fields (lpcol4126m000) session, the information fields of the partner and the values to be extracted are configured, including the identification document type, number, and other details.
    • In the Country DIAN Codes (lpcol0112m000) session, the country codes that are defined by DIAN are assigned.
  2. Magnetic media process
    • The Generate Magnetic Medium Transactions (lpcol4430m000) session extracts the accounting and withholding tax information.
    • The Generate Supplier Balances (lpcol4430m001) session extracts the information for the balances of the supplier documents from the Accounts Payable module. The Generate Customer Balances (lpcol4430m002) session extracts the information for the balances of the customer documents from the Accounts Receivable module. For both sessions, an additional report is generated listing the omitted documents.
    • The Classify Transactions According Minimum Value to Report (lpcol4430m003) session classifies the summed amount by Year, Partner, Format, and Concept, based on the definition of the minimum value to report. It also updates the status of the record.
    • The Generate Magnetic Medium Details (lpcol4235m000) session consolidates the information by Year, Partner, Format, and Concept and populates the partner's information fields such as address, country, and municipality. Additionally, it changes the company name or name of the partners with smaller amounts, as required by the Colombian Authorities. For example, tax identification: 22222222222, company name CUANTÍAS MENORES.
    Note: These sessions must be run when no financial transactions are being inserted in LN by users.
  3. Validation of the generated data
    • The Transactions Magnetic Media (lpcol4530m000) session allows a detailed query of the extracted transactions.
    • From the Generate Magnetic Media Transactions (lpcol4430m000) session, you can download and review the information from Magnetic Media in Microsoft Excel before uploading it to the DIAN.
  4. DIAN applications

    The DIAN application Tax Prevalidador (Prevalidador Tributario in Spanish) can be used to convert the extracted data into XML files, which are flat files that are required for the transmission of the information through the application on the DIAN web page.

    The DIAN application MUISCA (Single Model of Entry, Service, and Automated Control) can be used for registering the files corresponding to Magnetic Media. Within the DIAN application, the files are placed in the taxpayer's inbox. The request to send the files can be filled out and the files can be sent.