(DIAN - Companies) Extraction of income and tax returns from PDF file (Format 110) - Colombia
Lets integrate (DIAN - Companies) Extraction of income and tax returns from PDF file (Format 110) - Colombia in your system. First, get your Apitude API key, then send a POST request to Apitude... And that's it!.
That POST request should return the following
{
"message": "Request processed successfully",
"url": "/api/v1.0/requests/dian-business-tax-files-co/e0606c19-a32d-410f-b2eb-d57a665677bc/",
"request_id": "e0606c19-a32d-410f-b2eb-d57a665677bc"
}
This response will contains a unique request ID that you should poll using a GET as follows
How does the response looks like?
{
"result": {
"data": {
"records": [
{
"costos": {
"code": 63,
"value": 0.0,
"section": "esal"
},
"message": "ok",
"pasivos": {
"code": 42,
"value": 197630000.0,
"section": "patrimonio"
},
"inventarios": {
"code": 36,
"value": 0.0,
"section": "patrimonio"
},
"renta_exenta": {
"code": 78,
"value": 0.0,
"section": "ganancias_ocasionales"
},
"otros_activos": {
"code": 40,
"value": 0.0,
"section": "patrimonio"
},
"renta_liquida": {
"code": 76,
"value": 0.0,
"section": "ganancias_ocasionales"
},
"compensaciones": {
"code": 75,
"value": 0.0,
"section": "ganancias_ocasionales"
},
"otros_ingresos": {
"code": 52,
"value": 26213000.0,
"section": "ingresos"
},
"document_number": "908888881",
"autorretenciones": {
"code": 99,
"value": 0.0,
"section": "sobretasa_instituciones_financieras"
},
"renta_presuntiva": {
"code": 77,
"value": 0.0,
"section": "ganancias_ocasionales"
},
"rentas_gravables": {
"code": 79,
"value": 4053000.0,
"section": "impuesto_sobre_las_rentas_l\u00edquidas_gravables"
},
"tax_records_year": 2019,
"otras_retenciones": {
"code": 100,
"value": 3034000.0,
"section": "liquidacion_privada"
},
"activos_biologicos": {
"code": 38,
"value": 0.0,
"section": "patrimonio"
},
"gastos_financieros": {
"code": 66,
"value": 0.0,
"section": "renta"
},
"activos_intangibles": {
"code": 37,
"value": 0.0,
"section": "patrimonio"
},
"dian_signature_date": "2020-04-15 15:37:26",
"ingresos_financieros": {
"code": 45,
"value": 9052000.0,
"section": "ingresos"
},
"total_ingresos_netos": {
"code": 62,
"value": 173894000.0,
"section": "costos_y_deducciones"
},
"total_ingresos_brutos": {
"code": 53,
"value": 172786000.0,
"section": "ingresos"
},
"descuentos_tributarios": {
"code": 90,
"value": 0.0,
"section": "liquidacion_privada"
},
"impuesto_neto_de_renta": {
"code": 91,
"value": 0.0,
"section": "liquidacion_privada"
},
"renta_liquida_gravable": {
"code": 80,
"value": 0.0,
"section": "impuesto_sobre_las_rentas_l\u00edquidas_gravables"
},
"total_impuesto_a_cargo": {
"code": 94,
"value": 435000.0,
"section": "retenciones"
},
"total_patrimonio_bruto": {
"code": 41,
"value": 322153000.0,
"section": "patrimonio"
},
"gastos_de_administracion": {
"code": 64,
"value": 0.0,
"section": "esal"
},
"total_patrimonio_liquido": {
"code": 43,
"value": 124523000.0,
"section": "patrimonio"
},
"otros_gastos_y_deducciones": {
"code": 67,
"value": 0.0,
"section": "renta"
},
"perdida_liquida_del_ejercicio": {
"code": 74,
"value": 12283000.0,
"section": "renta"
},
"ganancias_ocasionales_gravables": {
"code": 84,
"value": 0.0,
"section": "liquidacion_privada"
},
"gastos_de_distribucion_y_ventas": {
"code": 65,
"value": 0.0,
"section": "renta"
},
"costos_por_ganancias_ocasionales": {
"code": 82,
"value": 0.0,
"section": "impuesto_sobre_las_rentas_l\u00edquidas_gravables"
},
"inversiones_efectuadas_en_el_ano": {
"code": 69,
"value": 0.0,
"section": "renta"
},
"total_costos_y_gastos_deducibles": {
"code": 68,
"value": 76872000.0,
"section": "renta"
},
"impuesto_de_ganancias_ocasionales": {
"code": 92,
"value": 0.0,
"section": "liquidacion_privada"
},
"ingresos_por_ganancias_ocasionales": {
"code": 81,
"value": 0.0,
"section": "impuesto_sobre_las_rentas_l\u00edquidas_gravables"
},
"efectivo_y_equivalentes_al_efectivo": {
"code": 33,
"value": 119175000.0,
"section": "patrimonio"
},
"sobretasa_instituciones_financieras": {
"code": 104,
"value": 0.0,
"section": "liquidacion_privada"
},
"renta_liquida_ordinaria_del_ejercicio": {
"code": 73,
"value": 0.0,
"section": "renta"
},
"renta_por_recuperacion_de_deducciones": {
"code": 71,
"value": 12283000.0,
"section": "renta"
},
"impuesto_sobre_la_renta_liquida_gravable": {
"code": 85,
"value": 4053000.0,
"section": "liquidacion_privada"
},
"ingresos_brutos_de_actividades_ordinarias": {
"code": 44,
"value": 137521000.0,
"section": "ingresos"
},
"total_retenciones_ano_gravable_a_declarar": {
"code": 101,
"value": 0.0,
"section": "liquidacion_privada"
},
"devoluciones_rebajas_y_descuentos_en_ventas": {
"code": 54,
"value": 75764000.0,
"section": "ingresos"
},
"ganancias_ocasionales_no_gravadas_y_exentas": {
"code": 83,
"value": 4053000.0,
"section": "liquidacion_privada"
},
"anticipo_renta_para_el_ano_gravable_siguiente": {
"code": 102,
"value": 3034000.0,
"section": "liquidacion_privada"
},
"anticipo_renta_liquidado_ano_gravable_anterior": {
"code": 97,
"value": 0.0,
"section": "sobretasa_instituciones_financieras"
},
"descuento_efectivo_inversion_obras_por_impuestos": {
"code": 96,
"value": 504000.0,
"section": "liquidacion_privada"
},
"inversiones_e_instrumentos_financieros_derivados": {
"code": 34,
"value": 0.0,
"section": "patrimonio"
},
"total_impuesto_sobre_las_rentas_liquidas_gravables": {
"code": 89,
"value": 0.0,
"section": "liquidacion_privada"
},
"renta_pasiva_-_ece_sin_residencia_fiscal_en_colombia": {
"code": 72,
"value": 0.0,
"section": "renta"
},
"dividendos_yo_participaciones_gravadas_al_75_porciento": {
"code": 50,
"value": 0.0,
"section": "ingresos"
},
"inversiones_liquidadas_de_periodos_gravables_anteriores": {
"code": 70,
"value": 0.0,
"section": "renta"
},
"dividendos_y_o_participaciones_gravadas_a_tarifa_general": {
"code": 51,
"value": 0.0,
"section": "ingresos"
},
"ingresos_no_constitutivos_de_renta_ni_ganancia_ocasional": {
"code": 61,
"value": 0.0,
"section": "costos_y_deducciones"
},
"cuentas_documentos_y_arrendamientos_financieros_por_cobrar": {
"code": 35,
"value": 202978000.0,
"section": "patrimonio"
},
"propiedades_planta_y_equipo_propiedades_de_inversion_y_ancmv": {
"code": 39,
"value": 0.0,
"section": "patrimonio"
},
"anticipo_sobretasa_instituciones_financieras_ano_gravable_anterior": {
"code": 103,
"value": 0.0,
"section": "liquidacion_privada"
},
"anticipo_sobretasa_instituciones_financieras_ano_gravable_siguiente": {
"code": 105,
"value": 0.0,
"section": "liquidacion_privada"
},
"descuento_por_impuestos_pagados_en_el_exterior_por_ganancias_ocasionales": {
"code": 93,
"value": 1088000.0,
"section": "retenciones"
},
"dividendos_y_o_participaciones_gravadas_recibidas_por_sociedades_extrangeras": {
"code": 48,
"value": 0.0,
"section": "ingresos"
},
"dividendos_y_o_participaciones_no_constitutivos_de_renta_ni_ganancia_ocasional": {
"code": 46,
"value": 0.0,
"section": "ingresos"
},
"impuesto_de_dividendos_yo_participaciones_gravadas_a_la_tarifa_del_33_porciento": {
"code": 88,
"value": 4053000.0,
"section": "liquidacion_privada"
},
"impuesto_de_dividendos_yo_participaciones_gravadas_a_la_tarifa_del_75_porciento": {
"code": 86,
"value": 0.0,
"section": "liquidacion_privada"
},
"impuesto_de_dividendos_yo_participaciones_gravadas_a_la_tarifa_del_articulo_240": {
"code": 87,
"value": 0.0,
"section": "liquidacion_privada"
},
"saldo_a_favor_ano_gravable_anterior_sin_solicitud_de_devolucion_yo_compensacion": {
"code": 98,
"value": 0.0,
"section": "sobretasa_instituciones_financieras"
},
"valor_inversion_obras_por_impuestos_hasta_del_50_porciento_del_valor_de_la_casilla_89": {
"code": 95,
"value": 1523000.0,
"section": "retenciones"
},
"dividendos_y_o_participaciones_recibidas_por_chc_de_una_entidad_no_residente_en_colombia": {
"code": 47,
"value": 0.0,
"section": "ingresos"
},
"dividendos_y_o_participaciones_gravadas_recibidas_por_personas_naturales_sin_residencia_fiscal": {
"code": 49,
"value": 0.0,
"section": "ingresos"
}
}
]
},
"error": "",
"end_at": "2021-03-14 19:13:02.001039",
"status": 200,
"message": "successful",
"queried_by": "testUser",
"service_name": "dian-business-tax-records-co"
},
"message": "Request completed"
}
Ok, but what does each field in that JSON means?
The general parts:
message:The message is an Apitude generatedstringwith an informational text about the request.result:The result is contains the main part of the request.result.error:The error is astringgenerated by apitude for the request if everything worked it will be blank.result.message:The message is astringwith two optionssuccessfulorunsuccessfuldepending of how your request finished.result.queried_by:The queried_by field is astringthat lets you know what user started the request.result.end_at:The end_at field is astring formatted datethat lets you know at what time the request ended in Apitude.result.service_name:The service_name field is astringthat echos the service called. For this service it will always bedian-business-tax-files-co.result.status:The status field is aintegerthat represents whether the service returned data from the input sent in the request. It could be one of the following values:200: The service returned response data for the payload that was sent in the creation of the request.404: The service did not returned data for the payload that was sent in the creation of the request.400: The service did not started because your input was invalid.500: Apitude tried to execute your request, however the service Apitude uses to execute your request was down. Please wait some time and try again, Apitude will not charged you for requests with this code.
Depending on the service, you want it to return different codes. For example, if you are checking the user against a security list to whitelist the user you should look for a
404, because a200would mean the user is in fact in the list. Other cases however, like creating objects in the name of a user you want the code to be200, since it will imply the creation was a success.
The data in the response:
Process steps
- The pdf of the Income Statement is received in any of the formats by the Client.
- The client must have requested this document from his client, which must meet the following specifications:
- Document in 110 format downloaded directly from the client's Muisca platform
- Scanned documents or photos of documents are not accepted.
- The Client uploads the Income Tax Declaration document in the Apitude API
- The Apitude API validates that the uploaded document is original and not tampered with in any part. If the document meets the originality requirements, the process continues, otherwise the process ends there.
- The API extracts all the values of each one of the fields of the Income Statement and returns in a JSON each one of the names and the values of each field to the Client.
About this service
This service allows you to process through API the PDF (Format 110) of an income statement from the DIAN system in Colombia (Muisca) and obtain all the data stored in it, while validating the authenticity of the PDF against the DIAN. The process is 100% automatic and safe, there is no human intervention. If the email (Optional) field is sent in the API request, the results will be delivered both in the REST response and via CSV file to the sent email.
Who can you query using this service?:
This service (dian-business-tax-files-co) is available for you to query companies/businesses only.
Get API Access
Services