Format 1012 file for Colombia configuration

This article explains how to set up and issue a format 1012 file. The format 1012 file includes information about company investments that must be provided to the tax authority.

Prerequisites

Before you print the report, the following prerequisites must be met:

• The address that's set for the legal entity must be in Colombia.

• Enable the country-specific Latin American (LATAM) globalization feature and the general LATAM feature.

• Import the following configurations from the Global repository:

  • LTM Tax Report
  • File format 1012

  For more information, see Download ER configurations from the Global repository of Configuration service.

• Configure Electronic reporting (ER) parameters. For more information, see Configure the Electronic reporting (ER) framework.

• Create a tax application code to use with this report. Learn more in Tax application for Latin America.

Additional configuration

• Set the document id code in the tax application of the country document type of the 3rd party in transactions for this report. Learn more in Tax ID types for Latin America.

• Set the country id code in the tax application for the country address of the 3rd party in transactions for this report.

Configure application-specific parameters

Lookups and conditions are designed so that you can select the combination of document classification IDs and ledger account numbers that's used in transactions that are shown on the report.

Follow these steps to set up the parameters for the report.

1. Go to Organization administration > Workspaces > Electronic reporting, and select Reporting configuration.

2. On the left, select LTM Tax Report deployment > Format 1012.

3. On the Action Pane, select Configurations > Application specific parameters > Setup.

4. In the Lookups section, select the first lookup that refers to the main account group, MainAccountGroup.

5. In the Conditions section, add a line. In the Lookup result field, select one of the following options:

   • 1110 – National bank accounts.
   • 1115 – International bank accounts.
   • 1200 – Treasury bonds.
   • 1201 – Deposit certifies.
   • 1202 – Shares value.
   • 1203 – Fiduciary rights.
   • 1204 – Other investments value.
   • 1205 – Crypto investments value.

   These options represent different concepts for the format 1012 file. You can add as many lines as you require.

6. For each condition that you add, in the Label field, enter the concept number.

7. In the Main account field, select the ledger account that represents the concept.

   Note

   The ledger accounts that are selected in this configuration must be used in the company transactions that are included on the report.

8. In the Lookups section, select the second lookup, PaymentMethodId. This lookup refers to the payment method document class that's used to post transactions for each concept in the MainAccountGroup lookup.

9. In the Conditions section, add a line. In the Lookup result field, select PaymentMethodClass.

10. In the Document classification Id field select the document class used in the transactions that are included in the report.

    Note

    For each Lookup, add two conditions where the Lookup result is N/A for both. The Main account ID for the first condition should be "Blank" and the Main account ID** for the second condition should be "Not blank". 

Issue a format 1012 file

1. Go to Tax > Inquiries and reports > LATAM > Tax reporting.
2. In the Format mapping field, select Format 1012.
3. Select OK.
4. Complete the Tax application Id field with the code created for this report.
5. Select the date range.
6. Select OK.