Format 1007 file for Colombia configuration

This article explains how to configure and issue a file in 1007 format. This format records for each third party the income received by a natural or legal person during the taxable year including both operating and nonoperating income.

Prerequisites

Before generating and printing the report, complete the following prerequisites:

• The country/region of the legal entity's address is Colombia.
• Enable the country/region-specific Latin American (LATAM) feature for Colombia and the general LATAM feature.
• Download the specific report configurations from the Dataverse configuration repository:

• 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 applications

1. Go to Organization administration > Setup > LATAM > Tax application and create a new record.
2. In the Tax application Id field, enter 1007.
3. Go to Organization administration > Global address book > Addresses > Address setup > Country/region.
4. Select Colombia and go to LATAM > Tax application.
5. Create a new record.
6. In the Tax application Id field, select 1007.
7. In the Tax application code field, enter the country code according to the Colombian normative.
8. Go to Organization Administration > Setup > LATAM > Tax ID type.
9. On the top menu, go to Tax application and create a new record.
10. In the Tax application Id field, select 1007.
11. In the Tax application code field, enter the tax ID code according to the Colombian normative.

For more information, see Tax application for Latin America.

Configure application-specific parameters for format 1007

Lookups and conditions are designed so you can select the combination of document classifications and tax codes used in transactions.

After you meet the prerequisites and configure the tax application codes, follow these steps for both formats:

1. Go to Organization administration > Workspaces > Electronic reporting and select Reporting configuration.
2. On the left, select LTM Tax Report > File format 1007.
3. On the Action Pane, select Configurations > Application specific parameters > Setup.
4. In the Lookups section, select InvoiceAndCreditNoteIsApplicable and follow these steps.
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Yes.
   3. In the Document classification id. field, select a document class used for purchase invoices that contain VAT.
5. In the Lookups section, select MainAccountGroups and follow these steps.
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Yes.
   3. In the Document classification id. field, select a document class used in company transactions.
6. In the Lookups section, select TaxType and then follow these steps:
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Generated tax.
   3. In the Tax code field, select a value that represents the VAT generated in sales.
   4. Select Add.
   5. In the Lookup result field, select Tax refund.
   6. In the Tax code field, select an option that represents the VAT returns in purchase returns.
7. In the Lookups section, select ApplicableInvoice and then follow these steps:
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Yes.
   3. In the Document classification id. field, select a document class used for purchase invoices.

Issue a format 1007 file for XML and Excel output

1. Go to Tax > Inquiries and reports > LATAM > Tax reporting.
2. In the Format mapping field, select File format 1007 for the XML output or File format 1007 (Excel) for the Excel output.
3. For the XML output only, enter 1007 in the Tax application ID field.
4. Select a date range.
5. Select OK.