Format 1003 file for Colombia configuration

This article explains the configuration required to issue a format 1003 file. The report shows information about withholding taxes the company incurred during a period and the related entities. This article provides the configuration requirements for issuing the XML and Excel format versions of the file format 1003.

Prerequisites

Before printing the report, ensure the following prerequisites are met:

• The legal entity must have an address in a country/region that is within the Latin American (LATAM) localization.

• Activate the country/region-specific LATAM feature and the general feature.

• Import the following configuration from the Dataverse Configuration Repository:

  • LTM Tax Report
  • LTM Tax Report Mapping
  • File format 1003
  • File format 1003 Excel

Learn more in Import Electronic reporting (ER) configurations from Dataverse.

• Configure the Electronic reporting (ER) parameters. Learn more in Configure the Electronic reporting (ER) framework.

Configure tax application

1. Go to Organization administration > Setup > LATAM > Tax application, and select New to create a tax application record with the code 1003 (for format 1003).
2. Go to Organization administration > Setup > LATAM > Tax ID type, and follow these steps for each record in the list.
3. Select a record, and then select Tax application.
4. On the Tax application page, in the Tax application id field, enter the code used for Colombian format 1003.
5. In the Tax application code field, enter the code for tax IDs according to Colombian regulations.
6. Go to Organization administration > Global address book > Addresses > Address setup. For each record (Country/Region, State, and County), go to LATAM > Tax application to assign the tax application codes according to Colombian regulations.

Configure application-specific parameters for format 1003

Lookups and conditions are designed so that you can select the combination of document classification IDs, tax codes, and ledger accounts used in the transactions shown on the report.

After you meet the previously listed prerequisites, follow these steps.

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

2. In the tree on the left, select LTM Tax Report > File format 1003 or LTM Tax Report > File format 1003 Excel.

3. For each format, on the top menu, select Configurations > Application specific parameters > Setup.

4. In the Lookups section, select the first lookup, ApplicableInvoice. This lookup lets you choose the document classes used to post partner sales transactions.

5. In the Conditions section, select Add, and follow these steps:

   1. In the Lookup result field, select Yes.
   2. In the Document classification ID field, select the appropriate document class (usually sales invoices or debit notes).

6. Select Add again, and then follow these steps:

   1. In the Lookup result field, select No.
   2. In the Document classification ID field, select Blank.

7. Select Add again, and then follow these steps:

   1. In the Lookup result field, select No.
   2. In the Document classification ID field, select Not Blank.

1. In the Lookups section, select Concept.

2. In the Conditions section, select Add, and choose every required concept.

3. For each one, in the Tax code field, choose a tax code that represents the concept.

4. Select Add again, and then follow these steps:

   1. In the Lookup result field, select N/A.
   2. In the Type of tax field, select Blank.

5. Select Add again, and then follow these steps:

   1. In the Lookup result field, select N/A.
   2. In the Type of tax field, select Not Blank.

Run a format 1003 file

1. Go to Tax > Inquiries and reports > LATAM > Tax reporting.
2. In the Format mapping field, select the format mapping File format 1003 or File format 1003 Excel.
3. Select OK.
4. For File format 1003, in Tax application Id, enter the tax application 1003 created for this report.
5. Select OK.
6. Specify a date range.
7. Select OK.