David Tellez Senior Consultant

When generating electronic yearly fiscal reports for Colombia the District Magnetic Media is a must for the majority of companies. As of now Only National magnetic media has been partially released but is important to have available as well the electronic reports that build the XML for the "Scretaría de Hacienda Bogota".

The formats to be developed should be 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012 updates to 2024 according to the resolution 1255 from 2022 of the "Secretaría de Hacienda Bogota".

The suggestion is MS to develop all these formats based on the Vendor/customer address criteria to include all transactions performed in Bogota or companies based in Bogotá district.

Colombia companies must issue a "Vendir Equivalent document" for certain vendors that meets requirements and it is not mandatory to issue an invoice.

https://www.dian.gov.co/impuestos/Paginas/Sistema-de-Factura-Electronica/Documento-Soporte-Adquisiciones-No-Obligados.aspx

The suggestion is MS to develop the criteria when a vendor is setup, also controls the total amount per transaction per vendor and also develop the report to be rpintes from PO invoice, Vendor Invoice Journal and General Ledger Journal.

Colombia Invoice format (Beyond the XML-Electronic Invoice), requires certain criteria to be fiscal-legally accepted.

• Invoice should include Invoice resolution legend tied to an editable field that allows to update each time a new resolution is issues by the fiscal authorities, this can be done company bases or POS based or fiscal point based.

• Invoice must add a legend what is the system that is printing the legend + the license that the company has paid.

Here is a quick blog that helps to understand the scope of the requirement

https://www.holded.com/es/guias/facturacion/requisitos-datos-facturas

The suggestion is MS to develop all this field in the standard customer invoice report.

When recording Vendor invoices (as well as payroll), tax withholding is mandatory in the majority of the transactions. Once the year finishes company must issue a Withholding certificate that vendors and employees must use to file their personal taxes (legal requirement).

The suggestion is MS to develop a report that filters by time frame, by vendor that contains the amount of withholdings that have been recorded in the system. A check box should be developed on sales tax code records to identify what are the tax withholdings that are applicable in this report. The legend should also be editable allowing companies to set their own text.

https://www.dian.gov.co/tramitesservicios/Tramites_Impuestos/Autorizaciones/Documents/1.Nombre%20presenta%20e%20infografia%20de%20Certif%20sobre%20situac%20tribut.pdf

MS has developed Electronic reports for Colombia Magnetic media.

But when intercompany transactions are performed these are not included in the LATAM Tables/records hence, they are not included in these reports.

The suggestion is to include intercompany transactions like Customer invoices and vendor invoices to be part of the fiscal reports.

the exclusion of this was confirmed by MS on ticket 2402200040008302