Preguntas frecuentes
What is the source of your information?
The source of Treid's information is the import and export declarations published monthly by the National Tax and Customs Directorate of Colombia (DIAN). The original information is received and subjected to the most advanced data cleaning processes.
How often is your information updated?
Our information is updated with respect to the periodicity in which DIAN publishes the data, which is usually monthly. However, given the processing carried out by DANE on these data, the information is about a month and a half late with respect to the date of publication. For example, the information published in the month of January will generally be that corresponding to the month of November of the previous year, that of February will be that of December, and so on.
What is a detailed report?
At Treid, our main concern is to provide our clients with high-quality data with which they can make informed and intelligent decisions about foreign trade. For this reason, we have developed advanced data purification and cleaning processes to guarantee the accuracy of the information. Learn about our debugging processes here .
What is a detailed report?
A detailed report is a row-only report that individually displays the records for each import or export declaration.
What is a summary report?
A summary report is a report that groups several records of individual import or export returns and presents the accumulated information according to the selected fields. Treid is the only foreign trade intelligence system whose summary reports are of the pivot or pivot table type.
What is a pivot table?
A pivot table is a data visualization tool that allows you to easily summarize and analyze large amounts of information by simply dragging and dropping the different columns or fields that will make up the report. In addition, pivot tables allow you to expand and collapse the summarized information to deepen the data analysis (drill-down) at different levels of detail.
What are Treid predesigned reports?
The Treid Reports consist of more than 180 reports of imports and exports of a company and its economic sector, created by experts in business intelligence, with all the analysis perspectives so that you obtain in seconds a 360 ° view of the business of any company .
The reports are grouped into folders and subfolders according to the main categories of foreign trade information.
The reports are grouped into four (4) main folders:
COMPANY EXPORTS: Contains all exports (from January 2007 to the last month of information update) made by the company.
SECTOR EXPORTS: Contains all exports (from January 2007 to the last month of information update) made by the company and all companies that share the same ISIC code (International Standard Industrial Classification) that have been supervised by the Superintendency of Companies, as well as competing companies added by the user.
COMPANY IMPORTS: Contains all imports (from January 2007 to the last month of information update) made by the company.
SECTOR IMPORTS: Contains all imports (from January 2007 to the last month of information update) made by the company and all companies that share the same ISIC code (International Standard Industrial Classification) that have been supervised by the Superintendency of Companies, as well as competing companies added by the user.
Treid reports are available for Plus and Pro plans. Learn more about our plans here .
What method of sectorization of companies use?
The sectorization method used by Treid, based on grouping those companies that share the same ISIC code and have been supervised by the Superintendency of Companies, is based on the fact that the companies supervised collect the productive events of the country (Colombia) in 94% of the GDP of the real sector, which seeks to group the most representative companies of each economic sector.
In case your company has not been supervised by the Superintendency of Companies, the sector reports of your Treid Reports will not provide information as your company cannot be sectorized by the system. If this is your case, and you are subscribed to the Plus Plan, to activate these reports go to the section “My Importer Competitors” or “My Exporter Competitors” (as the case may be) and add your competitors, after which, the Aggregated companies will appear in industry reports along with your company so you can perform comparative analysis.
What information fields are available for imports?
Treid is the foreign trade intelligence software that has the most information fields for imports, a total of 133.
FIELD: DESCRIPTION
ID: Unique identifier of each record or statement per month. Generated by DIAN.
Declaration year: Year of presentation of the import declaration before the corresponding customs (YYYY).
Declaration month: Month of presentation of the import declaration before the corresponding customs office (AAAAMM).
Declaration date: Date of presentation of the import declaration before the corresponding customs office (AAAMMDD).
Acceptance date decl: Acceptance date of the statement (YYYMMDD).
Decl Date: Previous Date of the previous declaration. When the declaration presented corresponds to a correction, modification or legalization, the filing date that appears registered in the previous declaration (AAAMMDD) must be entered in this box.
Manifest date: Date of arrival of the merchandise to the national customs territory (AAAMMDD).
Invoice date: Date of the invoice that is presented as a supporting document for the declaration (AAAMMDD).
Quota date: Date of the first import quota (YYYMMDD).
Acceptance No. decl: Declaration acceptance number. Space reserved for the Sectional Directorate or the authorized warehouse or the declarant, as appropriate, in which the acceptance number assigned by the respective customs computer system or the customs authority will be entered.
Pre-printed number: Space determined for the unique number assigned by DIAN to each of the forms.
Declaration type: Type of import declaration.
Document type: Specifies whether the declaration document corresponds to an import registration, a prior license or an annual license.
License No.: Registration approval number or import license issued by the Ministry of Commerce, Industry and Tourism.
Incomex Office: Code of the office, of the Ministry of Commerce, Industry and Tourism, which issued the corresponding import registration or license when applicable.
Previous declaration No .: Number of the previous declaration. When the declaration presented corresponds to a correction, modification or legalization, the number that appears registered in the previous declaration must be entered in this box.
No. decl. export: Number of the export declaration. When the import declaration is preceded by an export declaration, the number of the definitive export declaration recorded on the export form must be indicated.
Bank: Bank where the import declaration payment was made.
Bank branch: Branch of the bank where the import declaration payment was made.
Cashier code: Code of the cashier of the bank where the import declaration payment was made.
Consecutive teller: Consecutive number generated by the teller of the bank where the import declaration was submitted.
Customs declaration: Sectional Directorate of Customs, Taxes and Customs or Delegates, where the merchandise is located or in which the import will be processed if it is an advance declaration.
Customs previous declaration: Customs of previous import declaration. Sectional Directorate of Customs, Taxes and Customs or Delegates of Taxes and Customs where the previous import declaration was presented.
Export Customs: Sectional Directorate of Customs, Taxes and Customs or Delegate of Taxes and Customs in which the export declaration was presented.
Nit Customs agent: NIT of the declarant previously assigned by the DIAN, without the verification digit (DV). Non-resident foreigners, diplomats, diplomatic missions, consular missions and technical missions accredited in Colombia, or subject to the importation of goods, who do not have a NIT must indicate the passport number, identity document number or the document number that accredits The mission.
Customs agent: Name or company name of the authorized declarant, be it the Customs Agency, UAP or ALTEX.
Nit + Agent name: Nit and business name of the declarant authorized to import.
Doc. Repr. Jurídico: Document of the legal representative. Identification number of the person who acts as declarant, either directly or on behalf of a natural or legal person and who signs the declaration.
Legal Representative : Name of the legal representative. Surnames and names of the person who acts as declarant either directly or on behalf of a legal person and who signs the declaration. In the case of Customs Agencies, UAPs or ALTEX, the surnames and names of the person acting as customs representative must be indicated.
Importer Nit: Importer NIT previously assigned by DIAN, without the verification digit (DV). Non-resident foreigners, diplomats, diplomatic missions, consular missions and technical missions accredited in Colombia, or subject to the traveler modality, who lack a NIT must indicate the passport number, identity document number or the document number that accredits mission, as appropriate.
Importer Name: Surname and names or company name of the importer as it appears registered in the RUT. In the case of a non-resident foreigner, diplomat, diplomatic or technical mission or subject to the traveler modality, who do not register in the RUT, the surnames and names or company name appear as they appear on the identity document, passport or document that accredits the mission.
Nit + Importer name: Nit and company name of the importer.
Importing department: Department of the main domicile of the importer.
Importing municipality: Municipality of the main domicile of the importer.
Importer address: Address of the main domicile of the importer.
Importer contact: Telephone number of the main address of the importer as registered in the RUT.
User type: Customs user type.
Custom user code: Customs user code. In the event that the declarant has the status of UAP, ALTEX or Customs Agency, relate the code assigned by DIAN to it. If it does not belong to any of the three (3) previous conditions, you must write X "X". When the permanent customs user (UAP) and the highly exporting user (ALTEX) act through a Customs Agency, the only and exclusive code of the Agency must be registered. The general warehouses of deposit will have two different codes, one of three (3) digits when they act as Customs Agencies and another of five (5) digits when they act as warehouse.
Importer class: Specifies if the importer corresponds to a mixed economy company, if it is a private company or if it is a public entity.
Tariff position: Tariff classification of the merchandise being declared, with the ten (10) digits registered for it in the Colombian customs tariff.
Description pos. aran: Description of the tariff position according to the Colombian customs tariff.
Pos. Aran. + Description + (Unit): Tariff classification of the declared merchandise, with the ten (10) digits registered for it in the customs tariff presented as follows: Code of the position + Description of the position + (unit of measure).
Merchandise description: Detailed description of the imported merchandise. It includes the brand, reference, serials and numbers that identify it, clearly and precisely so that it typifies and distinguishes it. WARNING: for internal information management reasons, the DIAN only presents the first 120 characters of this field.
Commercial unit: Physical unit to which the imported merchandise corresponds.
Merchandise quantity: Total number of physical units of the merchandise contained in the packages corresponding to each declaration.
No. of packages: Number of packages declared.
Packaging: Packaging used to protect imported merchandise.
Gross weight kgms: Weight in kilograms of the goods to be declared, including the weight of the packaging.
Net weight kgms: Weight in kilograms of the merchandise to be declared once the weight of the packaging has been deducted from the gross weight.
Tariff section: Section of the Colombian customs tariff in which the declared merchandise is classified.
Tariff Chapter: Chapter of the Colombian customs tariff in which the declared merchandise is classified.
Tariff heading: Colombia customs tariff heading in which the declared merchandise is classified.
Tariff subheading: Subheading of the Colombian customs tariff in which the declared merchandise is classified.
Macrosector: Economic macrosector to which the imported tariff position corresponds (according to ISIC Rev. 4.0. AC classification).
Sector: Economic sector to which the imported tariff position corresponds (according to ISIC Rev. 4.0. AC classification).
Subsector: Economic sector to which the imported tariff position corresponds (according to the ISIC Rev. 4.0. AC classification).
ISIC- Name: ISIC code and associated description to which the imported product corresponds (according to ISIC Rev. 4.0. AC classification).
Country of origin: Country where imported goods are produced, grown, manufactured, extracted or processed.
Country of origin: Country (or free zone) where the imported merchandise was shipped.
Country of purchase: Country where the importer makes the purchase.
Destination Department: Department of final destination of the imported merchandise.
Entry Municipality: Municipality through which imported merchandise enters the national territory.
Foreign supplier: Name or company name of the person issuing the invoice for the imported good or the document that accredits the operation that gives rise to the import.
Supplier country: Country to which the address of the exporter of the merchandise or supplier abroad corresponds.
Supplier city: Name of the city to which the address of the exporter of the merchandise corresponds, from whom the invoice is issued or the operation that gives rise to the importation is certified.
Supplier address: Address of the exporter or supplier of the merchandise abroad, of whom the invoice is issued or accredits the operation that gives rise to the import.
Supplier contact: Email, website, fax or telephone of the foreign supplier
Mode of transport: Mode of transport used for the introduction of the merchandise to the country.
Carrier: Name or company name of the company that transported the merchandise to the country.
Carrier flag: Nationality of the means of transport used for the introduction of the merchandise to the country.
Manifest No.: Cargo manifest number.
No. doc. transport: Transport document number, which must be listed in the cargo manifest. In the case of transport of consolidated merchandise in a transport document, the number corresponding to the daughter guide or individual transport document that covers the cargo included in the manifest is indicated.
Warehouse: Warehouse in which the merchandise imported into the national territory was stored.
Customs regime: Tax modality or treatment under which the import is carried out.
Invoice No.: Number of the invoice that is presented as a supporting document for the declaration.
USD Quota: This field is filled out only when it is a long-term temporary importation or temporary importation of merchandise under financial leasing. Indicates the value of the fee in dollars of the United States of North America.
No. of installments: Number of installments in which the payment of customs taxes will be made.
Quota periodicity: This field is filled out only when it is a long-term temporary importation or temporary importation of goods under financial leasing.
Payment method: How the imported goods will be paid to the exporter or supplier abroad.
Commercial agreement: Agreement by virtue of which the importer declares a preferential treatment.
Import type: Specifies whether it is a refundable or non-refundable import.
COP exchange rate: Representative exchange rate of the exchange market reported by the Financial Superintendency of Colombia for the last business day of the week prior to which the import declaration is presented and accepted.
CIF USD: CIF value in US dollars of the declared merchandise.
CIF COP: CIF value in Colombian pesos of the declared merchandise.
CIF USD x Unit: CIF value in US dollars per unit of imported merchandise.
CIF USD x Kgm net: CIF value in US dollars per net kilogram of imported merchandise.
FOB USD: FOB value in US dollars (does not include freight, insurance or other expenses) of the declared merchandise.
FOB COP: FOB value in Colombian pesos (does not include freight, insurance or other expenses) of the declared merchandise.
FOB USD x Unit: FOB value in US dollars per unit of imported merchandise.
FOB USD x Kgm: net FOB value in US dollars per net kilogram of imported merchandise.
Freight value USD: Value in American dollars of the transport of the merchandise, which includes the freight and related expenses.
USD Insurance: Value in American dollars of the insurance corresponding to the declared merchandise.
Other expenses USD: Value in US dollars of all the adjustments of article 8 of the Agreement, other than freight and insurance.
Freight sec. I tr. USD: Value in American dollars of the sum of the cost of freight, insurance and other import expenses.
USD adjustments: Sum of the values that must be adjusted (added or subtracted) to the price paid or payable for the declaration, considering the cases that national customs legislation establishes that part of the customs value is not subject to the payment of taxes. customs duties or that due to other events unrelated to the customs value must be added to it. The foregoing, for purposes of calculating the taxable base for the determination of customs taxes.
Customs USD: Value of the declared merchandise, added with the value of freight, insurance and other expenses and with the value of the adjustment, if any.
Tariff percentage: Tariff corresponding to the tariff charge (%).
COP tariff base : Base value to calculate the tariff rate.
Total COP tariff: Total value settled in Colombian pesos of the tariff to be paid for the imported tariff position.
Tariff paid COP: Total amount paid in Colombian pesos of the tariff to be paid for the imported tariff position.
USD tariff: Value of the tariff in US dollars in the case of long-term temporary importation or temporary importation of goods under financial leasing.
VAT percentage: Rate corresponding to VAT (%).
Base VAT COP: Base value to calculate the VAT rate.
Total VAT COP: Total value settled in Colombian pesos of the corresponding VAT to pay with the declaration.
VAT paid COP: Total value paid in Colombian pesos of the corresponding VAT to be paid with the declaration.
VAT USD: Value of VAT in US dollars in the case of a long-term temporary importation or temporary importation of goods under financial leasing.
Safeguard percentage: Percentage of applicable safeguard measures in accordance with current regulations.
Safeguard base COP: Base of applicable safeguard measures in accordance with current regulations.
Total COP safeguard: Total value settled in Colombian pesos of the safeguard measures (if applicable) to be paid with the declaration.
Safeguard paid COP: Total value paid in Colombian pesos of the safeguard measures (if there is any place for it) to be paid with the declaration.
USD Safeguard: Value of the safeguard in American dollars in the case of long-term temporary importation or temporary importation of goods under financial leasing.
Percentage right Comp: Percentage of applicable countervailing duties in accordance with current regulations.
Right base. Comp. COP: Base of applicable countervailing duties in accordance with current regulations.
Total der. comp. COP: Total value settled in Colombian pesos of the countervailing duties (if applicable) to be paid with the declaration.
Right comp: paid in COP Total value paid in Colombian pesos of countervailing duties (if applicable) to be paid with the declaration.
Right comp. USD: Value of countervailing duties in US dollars in the case of long-term temporary importation or temporary importation of merchandise under financial leasing.
Dumping percentage: Percentage of applicable anti-dumping duties in accordance with current regulations.
COP dumping base: Base of applicable antidumping duties in accordance with current regulations.
Total dumping COP: Total value settled in Colombian pesos of the anti-dumping duties (if applicable) to be paid with the declaration.
Dumping paid in COP: Total amount paid in Colombian pesos of anti-dumping duties (if applicable) to be paid with the declaration.
Dumping USD: Value of antidumping duties in US dollars in the case of long-term temporary importation or temporary importation of goods under financial leasing.
Percentage of penalties: Percentage of applicable penalty in accordance with current regulations.
COP sanctions base: Applicable sanction base in accordance with current regulations.
Total COP sanctions: Total value settled in Colombian pesos of the sanctions (if any) to be paid with the declaration.
Penalties paid COP: Total amount paid in Colombian pesos of the penalties (if applicable) to be paid with the declaration.
Redemption percentage : applicable redemption percentage in accordance with current regulations.
COP rescue base: applicable rescue base in accordance with current regulations.
Total COP redemption: Total liquidated value in Colombian pesos of the redemption (if applicable) to be paid with the declaration.
Ransom paid COP: Total amount paid in Colombian pesos of the ransom (if applicable) to be paid with the declaration.
Total settled COP: Total value settled in Colombian pesos to be paid with the declaration.
Total settled USD: Total to be paid in US dollars for the declaration in the case of long-term temporary importation or temporary importation of merchandise under financial leasing.
Previous payments COP: This box must be filled out when payments have been made with previous declarations and / or with Official Receipts of Payment of Customs Taxes and Exchange Sanctions, for the same merchandise that is included in this declaration. Here you must register the total amount previously paid.
Total paid in COP: Total amount paid in Colombian pesos of the total amount to be paid with the declaration.
What information fields are available for exports?
Treid is the foreign trade intelligence software with the most information fields for exports, a total of 68.
FIELD: DESCRIPTION
ID: Unique identifier of each record or statement per month. Generated by DIAN.
Declaration year: Year of the definitive export declaration (YYYY).
Declaration month: Month of the definitive export declaration (YYYYMM).
Declaration date: Date of the final export declaration (YYYYMMDD).
Shipment date: Shipment date (YYYYMM).
Date decl. exp. before: Date of the previous export declaration (YYYYM).
Date decl. imp. before: Date of the previous import declaration (YYYYMM).
Declaration No. exp. def: Final export declaration number.
Declaration type: Specifies if the export declaration is initial, correction or modification.
Of. Min. Commerce: Code of the office of the General Directorate of the Ministry of Commerce, Industry and Tourism, or whoever takes its place.
Shipment authorization number : Shipment authorization number. It corresponds to the number of the permit granted by DIAN for the transfer of the merchandise.
Declaration exp. ant: Previous export declaration. When the form is used to present a correction declaration, or a modification declaration, or when, given the export modality, there is a previous declaration or in any other case, the number of the definitive export declaration must be entered.
No decl. imp. ant: Self- adhesive number of the previous import declaration.
Sun Customs. emb: Customs office for submitting the shipment request.
Customs cert. emb: Customs of shipment certification process.
Nit customs agent: Identification number of the authorized declarant. Non-resident foreigners, diplomats, diplomatic missions, consular missions and technical missions accredited in Colombia, those subject to the household goods regime and travelers who do not have a NIT must indicate the passport number, identity document number or the number that accredits the mission.
Customs agent: Name or business name of the authorized declarant. Indicate the business name of the Permanent Customs User UAP, or the Highly Exporter User ALTEX, or surnames and names or business name of the exporter when performing the operation directly; or the Customs Brokerage Company SIA or attorney-in-fact, as appropriate.
Nit + Agent name: Nit and business name of the declarant authorized to export.
Ident type. exporter: Type of identification of the exporter. It can be of five types: Cédula, NIT, Cédula Extranjería, NUIP and Passport.
Exporter Nit: Exporter identification number, without the verification digit (DV).
Exporter name: Surname and names or company name of the exporter as it appears in the RUT.
Nit + Exporter name: Nit and company name of the exporter.
Exporting municipality: Municipality of the main domicile of the exporter.
Exporter address: Address of the tax domicile of the exporter as it appears in the RUT.
Exporter class: Specifies if the exporter corresponds to a mixed economy company, if it is a private company or if it is a public entity.
User code: Exporting user code. In the event that the declarant has the quality of UAP, ALTEX or SIA, list the code assigned by the DIAN to it.
User type: Customs user type.
Tariff position: Tariff classification of the declared merchandise, with the ten (10) digits registered for it in the Colombian customs tariff.
Description pos. aran: Description of the tariff position according to the Colombian customs tariff.
Pos. Aran. + Description + (Unit) Tariff classification of the declared merchandise, with the ten (10) digits registered for it in the customs tariff presented as follows: Item code + Item description + (unit of measure).
Commercial unit: Measure used to quantify each item corresponding to the tariff position of the exported good.
Merchandise quantity: Quantity of merchandise shipped for each item or tariff position, in terms of the defined unit of measure.
Gross weight kgms: Total gross kilos of the exported tariff position.
Net weight kgms: Total net kilos of the exported tariff position.
Tariff section: Section of the Colombian customs tariff in which the declared merchandise is classified.
Tariff Chapter: Chapter of the Colombian customs tariff in which the declared merchandise is classified.
Tariff heading: Colombia customs tariff heading in which the declared merchandise is classified.
Tariff subheading: Subheading of the Colombian customs tariff in which the declared merchandise is classified.
Macrosector: Economic macrosector to which the exported tariff position corresponds (according to ISIC Rev. 4.0. AC classification).
Sector: Economic sector to which the exported tariff position corresponds (according to ISIC Rev. 4.0. AC classification).
Subsector: Economic sector to which the exported tariff position corresponds (according to the ISIC Rev. 4.0. AC classification).
ISIC: ISIC code and associated description to which the exported product corresponds (according to ISIC Rev. 4.0. AC classification).
Destination country : Name of the country to which the address of the importer of the merchandise or buyer abroad corresponds.
Destination city: Name of the city to which the address of the importer of the merchandise or buyer abroad corresponds.
Origin department: Department where the last phase of the production process of exported goods was grown, elaborated or carried out.
Origin Department : Department from which the exported merchandise was dispatched.
Customs exit: Customs office where the merchandise left abroad.
Foreign customer: Name or company name of the foreign company that bought the merchandise.
Customer address: Address of the foreign company that bought the merchandise.
Transport route: Transport route used for export.
Shipment: Specify whether it was a single shipment, split or with partial loads.
Transport flag: Nationality of the company that carries out the transport of the merchandise.
Tax mode. previous: Previous import modality. It corresponds to the mode under which the import that precedes the export was carried out.
Negotiation currency: Currency with which the export payment was made.
Data code: Code corresponding to the nature of the data recorded in the Export Declaration, according to options D. Definitive upon shipment E. Definitive after shipment P. Provisional.
Special systems: It specifies whether or not the import benefited from Special Systems. It is an incentive to exports that are preceded by temporary importation of capital goods and raw materials, so that the goods produced with these materials have the international market as their final destination.
Exp. In transit: Export in transit. This box must be coded and recorded as follows: S = If the shipment will be made by a different customs office than the one on the shipment authorization. N = If the merchandise is not in transit, to be shipped through a customs office other than that of authorization.
Export mode: Export mode.
Payment method Specifies whether the payment made for the merchandise sales was made with a refund or without a refund.
FOB USD: Total FOB value in US dollars of the exported tariff position.
FOB COP: Total FOB value in Colombian pesos of the exported tariff position.
FOB USD x Merchandise unit: FOB value in US dollars per unit of merchandise exported.
FOB USD x Net Kgm: FOB value in US dollars per net kilogram of exported merchandise.
USD Freight: Value in US dollars of external freight, when applicable, according to the terms of the operation. In case of not being cused, they are filled out with zero.
USD Insurance: Value in US dollars of external insurance, when applicable, according to the terms of the operation. In case of not being cused, they are filled out with zero.
Other expenses USD: Value in American dollars when other expenses are incurred according to the conditions of the operation (containers, packaging, handling, stowage, loading and unloading, etc.). If not caused, they are filled out with zero.
Freight sec. and other USD: Value in US dollars of the sum of the cost of freight, insurance and other export expenses.
National aggregate USD: National aggregate value in US dollars for each item.
What level of detail is available on the information on imported and exported products?
In the import and export declarations there is a box called "description of the merchandise" where the detailed description of the merchandise is placed, which includes the brand, reference, serial numbers and numbers that identify it, clearly and precisely so that typify and single it out. However, in the case of exports, this field is not available in the DIAN databases; and in the case of imports, although it is available given how long this field can be in some declarations (several dozen pages in some cases) the DIAN only captures the first 120 characters of this information, so this It is the maximum level of detail that can be had of the products, in addition to the description of the tariff position in which they are classified.