{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["F220"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"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":"F220","index":0,"n_rows":80,"n_cols":42,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,9,2,31],[29,28,29,37],[30,28,30,37],[37,28,37,37],[79,0,79,37],[69,1,69,7],[69,8,69,30],[69,31,69,37],[70,1,70,7],[70,8,70,30],[65,0,65,37],[66,31,66,37],[70,31,70,37],[67,31,67,37],[68,1,68,7],[68,8,68,30],[68,31,68,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],[63,1,63,30],[63,31,63,37],[64,32,64,37],[55,1,55,30],[55,31,55,37],[56,1,56,30],[56,31,56,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],[50,25,50,30],[50,32,50,37],[51,25,51,30],[51,32,51,37],[52,25,52,30],[52,32,52,37],[53,25,53,30],[53,32,53,37],[54,32,54,37],[46,0,46,23],[46,24,46,30],[46,31,46,37],[43,0,44,28],[47,25,47,30],[47,32,47,37],[48,25,48,30],[48,32,48,37],[49,25,49,30],[49,32,49,37],[36,28,36,37],[39,28,39,37],[40,28,40,37],[45,0,45,37],[35,28,35,37],[38,28,38,37],[41,28,41,37],[40,0,40,26],[41,0,41,26],[32,28,32,37],[33,0,33,26],[33,27,33,37],[21,28,21,37],[34,28,34,37],[25,28,25,37],[26,28,26,37],[27,28,27,37],[28,28,28,37],[18,31,18,37],[17,35,17,37],[19,0,19,26],[19,27,19,37],[20,28,20,37],[22,28,22,37],[23,28,23,37],[24,28,24,37],[31,28,31,37],[15,29,15,33],[15,34,15,37],[16,0,16,15],[16,16,16,22],[16,33,16,34],[16,35,16,37],[17,23,17,32],[17,17,17,20],[17,4,17,7],[17,11,17,14],[67,0,67,5],[66,6,66,12],[67,6,67,12],[66,13,66,30],[67,13,67,30],[9,39,11,40],[9,3,9,13],[4,28,4,36],[7,0,11,0],[9,16,9,21],[9,22,9,27],[9,28,9,32],[9,33,9,37],[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],[15,18,15,22],[15,23,15,28]]}
[null,null,null,null,null,null,null,null,null,"Certificado de Ingresos y Retenciones por Rentas de Trabajo y de Pensiones\nAño gravable 2020"]
[]
[]
[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,"Esta es una versión para diligenciamiento manual de cada dato del certificado"]
["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," ",1]
[]
[]
["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,9009090,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,"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,"EMPRESA DE EJEMPLO",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,26254222,null,null,null,null,null,null,null,null,null,null,null,"DUSSAN",null,null,null,null,null,null,null,null,null,null,"GUILLERMO",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,"2020-01-01",null,null,null,null,"31. A:",null,"2020-12-31",null,null,null,null,null,"2021-03-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"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,null,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]
["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}]
["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}]
["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]
["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]
["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]
["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]
["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]
["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]
["Cesantías e intereses de cesantías efectivamente pagadas en el periodo",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]
["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,47]
["Total de ingresos brutos (Sume casillas 36 a 47)",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":"+AB32+1","v":48},{"$f":"SUM(AC21:AL32)","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,49]
["  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,50]
["  Cotizaciones voluntarias al régime 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,51]
["  Aportes voluntarios al impuesto solidario por COVID 19",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]
["   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]
["  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]
["  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]
["  Retenciones por aportes obligatorios al impuesto solidario por COVID 19",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,56]
["  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 57 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 56"]
["  Arrendamientos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0,null,null,null,null,null,64,0]
["  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,58,0,null,null,null,null,null,65,0]
["  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,59,0,null,null,null,null,null,66,0]
["  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,60,0,null,null,null,null,null,67,0]
["  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,61,0,null,null,null,null,null,68,0]
["  Otros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0,null,null,null,null,null,69,0]
["  Totales: (Valor recibido: Sume casillas 57 a 62), (Valor retenido: Sume 64 a 69)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,{"$f":"SUM(Z48:AE53)","v":0},null,null,null,null,null,70,{"$f":"SUM(AG48:AL53)","v":0}]
["  Total retenciones año gravable 2020 (Sume casillas 55 + 56+ 70)",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,71,{"$f":"+AC41+AC42+AG54","v":0}]
["Ítem","72.  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," 73. Valor Patrimonial"]
[1]
[2]
[3]
[4]
[5," "]
[6]
[7]
[8]
["  Deudas vigentes a 31 de Diciembre de 2020",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,74]
["Identificación del dependiente económico de acuerdo al parágrafo 2 del artículo 387 del Estatuto Tributario"]
["75. Tipo de documento",null,null,null,null,null,"76. No. Documento",null,null,null,null,null,null,"77. Apellidos y Nombres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"78. 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)."]