{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cert ing y ret"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":1,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cert ing y ret","index":0,"n_rows":80,"n_cols":42,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,0,79,37],[69,1,69,7],[69,8,69,30],[69,31,69,37],[70,1,70,7],[70,8,70,30],[70,31,70,37],[67,0,67,5],[67,6,67,12],[67,13,67,30],[67,31,67,37],[68,1,68,7],[68,8,68,30],[68,31,68,37],[63,1,63,30],[63,31,63,37],[64,32,64,37],[65,0,65,37],[66,6,66,12],[66,13,66,30],[66,31,66,37],[60,1,60,30],[60,31,60,37],[61,1,61,30],[61,31,61,37],[62,1,62,30],[62,31,62,37],[57,1,57,30],[57,31,57,37],[58,1,58,30],[58,31,58,37],[59,1,59,30],[59,31,59,37],[53,25,53,30],[53,32,53,37],[54,32,54,37],[55,1,55,30],[55,31,55,37],[56,1,56,30],[56,31,56,37],[50,25,50,30],[50,32,50,37],[51,25,51,30],[51,32,51,37],[52,25,52,30],[52,32,52,37],[47,25,47,30],[47,32,47,37],[48,25,48,30],[48,32,48,37],[49,25,49,30],[49,32,49,37],[41,0,41,26],[41,28,41,37],[43,0,44,28],[45,0,45,37],[46,0,46,23],[46,24,46,30],[46,31,46,37],[35,28,35,37],[36,28,36,37],[37,28,37,37],[38,28,38,37],[39,28,39,37],[40,0,40,26],[40,28,40,37],[30,28,30,37],[31,28,31,37],[32,28,32,37],[33,28,33,37],[34,0,34,26],[34,27,34,37],[24,28,24,37],[25,28,25,37],[26,28,26,37],[27,28,27,37],[28,28,28,37],[29,28,29,37],[19,0,19,26],[19,27,19,37],[20,28,20,37],[21,28,21,37],[22,28,22,37],[23,28,23,37],[17,4,17,7],[17,11,17,14],[17,17,17,20],[17,23,17,32],[17,35,17,37],[18,31,18,37],[16,0,16,15],[16,16,16,22],[16,33,16,34],[16,35,16,37],[9,39,11,40],[11,1,11,37],[12,0,15,0],[14,2,14,3],[14,6,14,17],[14,18,14,22],[14,23,14,28],[14,29,14,33],[14,34,14,37],[15,6,15,17],[0,9,2,31],[4,28,4,36],[7,0,11,0],[9,3,9,13],[9,16,9,21],[9,22,9,27],[9,28,9,32],[9,33,9,37],[15,18,15,22],[15,23,15,28],[15,29,15,33],[15,34,15,37]]}
[null,null,null,null,null,null,null,null,null,"Certificado de Ingresos y Retenciones por Rentas de Trabajo y de Pensiones\nAño gravable 2021"]
[]
[]
[]
["Antes de diligenciar este formulario lea cuidadosamente las instrucciones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Número de formulario",null,null,null,null,null," "]
[]
[]
["Retenedor","  5. Número de Identificación Tributaria (NIT):",null,null,null,null,null,null,null,null,null,null,null,"      6. DV.",null,null,"  7. Primer Apellido",null,null,null,null,null,"8. Segundo Apellido",null,null,null,null,null,"9. Primer Nombre",null,null,null,null,"10. Otros Nombres",null,null,null,null,null,null,null,"11.     Registro civil de nacimiento."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.     Tarjeta de identidad."]
[null,null,null,900412051,null,null,null,null,null,null,null,null,null,null,"-",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.     Cédula de ciudadanía."]
[null,"11. Razón Social",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21.     Tarjeta de extranjería."]
[null,"COMERCIALIZADORA DE PRUEBA SA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22.     Cédula de extranjería."]
["Empleado","  24. Cód. Tipo",null,null,null,null,"25. Número de documento de identificación",null,null,null,null,null,null,null,null,null,null,null," Apellidos y nombres ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31.     NIT."]
[null,"de  documento",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41.     Pasaporte."]
[null,null,"13.     Cédula de ciudadanía.",null,null,null,7700089,null,null,null,null,null,null,null,null,null,null,null,"HERNANDEZ",null,null,null,null,null,null,null,null,null,null,"FERNANDA",null,null,null,null,null,null,null,null,null,null,null,"42.     Tipo de documento extranjero."]
[null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,"26. Primer apellido",null,null,null,null,"27 Segundo apellido",null,null,null,null,null,"28. Primer Nombre",null,null,null,null,"29 Otros Nombres"]
["Periodo de la Certificación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  32. Fecha de Expedición",null,null,null,null,null,null,"  33. Lugar donde se practicó la retención",null,null,null,null,null,null,null,null,null,"34 Cód. Dpto.",null,"35. Cód. Ciudad/ Municipio"]
[null,"30. de:",null,null,"2021-01-01",null,null,null,null,"31. A:",null,"2021-01-31",null,null,null,null,null,"2022-02-15",null,null,null,null,null,"Bogotá",null,null,null,null,null,null,null,null,null,null,11,"001",null,null,null,null,null,"Hijo (a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,"Padres"]
["Concepto de los Ingresos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Valor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Esposa (o)"]
["Pagos por salarios o emolumentos eclesiásticos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0,null,null,null,null,null,null,null,null,null,null," ",null,"Compañero (a)"]
["Pagos realizados con bonos electrónicos o de papel de servicio, cheques, tarjetas, vales, etc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0]
["Pagos por honorarios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AB22+1","v":38},0]
["Pagos por servicios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AB23+1","v":39},0]
["Pagos por comisiones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0]
["Pagos por prestaciones sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0]
["Pagos por viáticos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0]
["Pagos por gastos de representación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0]
["Pagos por compensaciones por el trabajo asociado cooperativo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0]
["Otros pagos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0]
["Cesantías e intereses de cesantías efectivamente pagadas al empleado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0]
["Cesantías consignadas al fondo de cesantias",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
["Pensiones de jubilación, vejez o invalidez",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0]
["Total de ingresos brutos (Sume casillas 36 a 48)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AB33+1","v":49},{"$f":"SUM(AC21:AL33)","v":0}]
["Concepto de los aportes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Valor"]
["  Aportes obligatorios por salud a cargo del trabajador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0]
["  Aportes obligatorios a fondos de pensiones y solidaridad pensional a cargo del trabajador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0]
["  Cotizaciones voluntarias al régimen de ahorro individual  con solidaridad -  RAIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0]
["   Aportes voluntarios a fondos de pensiones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0]
["  Aportes a cuentas AFC.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0]
["  Valor de la retención en la fuente por ingresos laborales y de pensiones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["  Nombre del pagador o agente retenedor"]
[]
[]
["Datos a cargo del trabajador o pensionado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desde el renglon 56 en adelante lo diligencia el empleado que no"]
["Concepto de otros ingresos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor recibido",null,null,null,null,null,null,"     Valor retenido",null,null,null,null,null,null,"esté obligado a declarar. El empleador sólo diligencia la información hasta el renglon 55"]
["  Arrendamientos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,null,null,63]
["  Honorarios, comisiones y servicios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,null,null,null,null,null,null,64]
["  Intereses y rendimientos financieros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,null,null,null,null,null,null,65]
["  Enajenación de activos fijos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,null,null,null,null,null,null,66]
["  Loterías, rifas, apuestas y similares",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,67]
["  Otros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,null,null,null,null,null,null,68]
["  Totales: (Valor recibido: Sume casillas 57 a 61), (Valor retenido: Sume 63 a 68)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,{"$f":"SUM(Z48:AE53)","v":0},null,null,null,null,null,69,{"$f":"SUM(AG48:AL53)","v":0}]
["  Total retenciones año gravable 2021 (Sume casillas 55 + 69)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,{"$f":"+AC41+AG54","v":0}]
["Ítem","71.  Identificación de los bienes poseídos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 72. Valor Patrimonial"]
[1]
[2]
[3]
[4]
[5," "]
[6]
[7]
[8]
["  Deudas vigentes a 31 de Diciembre de 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
["Identificación del dependiente económico de acuerdo al parágrafo 2 del artículo 387 del Estatuto Tributario"]
["74. Tipo de documento",null,null,null,null,null,"75. No. Documento",null,null,null,null,null,null,"76. Apellidos y Nombres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"77. Parentesco"]
[]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ","   Firma del trabajador o pensionado"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["NOTA: este certificado sustituye para todos los efectos legales la declaración de Renta y Complementario para el trabajador o pensionado que lo firme.\nPara aquellos trabajadores independientes contribuyentes del impuesto unificado deberán presentar la declaración anual consolidada del Régimen Simple de Tributación (SIMPLE)."]