{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["importar","F350","Anexo","Vencimientos","Datos","Anexo 2","Instructivo","Tablas","1","2","Formulas"],"not_rendered":{"images":5,"macros":1,"external_links":1,"defined_names":17,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"importar","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"F350","index":1,"n_rows":62,"n_cols":62,"rows_kept":62,"merged":[[1,11,3,38],[1,39,3,44],[1,45,3,51],[6,17,6,24],[7,2,7,24],[10,1,14,1],[11,17,11,25],[11,26,11,33],[11,34,11,41],[11,42,11,51],[12,17,12,25],[12,26,12,33],[12,34,12,41],[12,42,12,51],[13,48,13,51],[14,2,14,47],[14,48,14,49],[14,50,14,51],[15,1,15,7],[15,9,15,11],[15,12,15,13],[15,15,15,21],[15,22,15,27],[15,28,15,39],[15,40,15,45],[15,46,15,48],[15,49,15,51],[16,1,16,26],[16,27,16,40],[16,41,16,51],[17,1,17,26],[17,28,17,40],[17,42,17,51],[18,1,18,26],[18,28,18,40],[18,42,18,51],[19,1,19,26],[19,28,19,40],[19,42,19,51],[20,1,20,26],[20,28,20,40],[20,42,20,51],[21,1,21,26],[21,28,21,40],[21,42,21,51],[22,1,22,26],[22,28,22,40],[22,42,22,51],[23,1,23,26],[23,28,23,40],[23,42,23,51],[24,1,24,26],[24,28,24,40],[24,42,24,51],[25,1,25,26],[25,28,25,40],[25,42,25,51],[26,1,26,26],[26,28,26,40],[26,42,26,51],[27,1,27,26],[27,28,27,40],[27,42,27,51],[28,1,28,26],[28,28,28,40],[28,42,28,51],[29,1,29,26],[29,28,29,40],[29,42,29,51],[30,1,30,26],[30,28,30,40],[30,42,30,51],[31,1,31,26],[31,28,31,40],[31,42,31,51],[32,1,39,1],[32,2,32,26],[32,28,32,40],[32,42,32,51],[33,2,33,26],[33,28,33,40],[33,42,33,51],[34,2,34,26],[34,28,34,40],[34,42,34,51],[35,2,35,26],[35,28,35,40],[35,42,35,51],[36,2,36,26],[36,28,36,40],[36,42,36,51],[37,2,37,26],[37,28,37,40],[37,42,37,51],[38,2,38,26],[38,28,38,40],[38,42,38,51],[39,2,39,26],[39,28,39,40],[39,42,39,51],[40,1,40,26],[40,28,40,40],[40,42,40,51],[41,1,41,26],[41,28,41,40],[41,42,41,51],[42,1,42,40],[42,42,42,51],[43,1,43,40],[43,42,43,51],[44,1,44,51],[45,1,48,1],[45,2,45,40],[45,42,45,51],[46,2,46,40],[46,42,46,51],[47,2,47,40],[47,42,47,51],[48,2,48,40],[48,42,48,51],[49,1,49,40],[49,42,49,51],[50,1,50,40],[50,42,50,51],[51,1,53,1],[51,2,51,40],[51,42,51,51],[52,2,52,40],[52,42,52,51],[53,2,53,40],[53,42,53,51],[54,1,54,20],[54,21,54,51],[55,16,55,31],[56,16,56,31],[56,32,56,39],[56,41,56,50],[58,32,61,51],[60,16,60,31],[61,1,61,6],[61,9,61,14],[61,16,61,31]]}
[]
[{"$nulls":11},"Declaración Retenciones en la Fuente",{"$nulls":27},"Privada"]
[]
[]
[null,"1. Año",null,null,2,0,2,2,{"$nulls":12},"3. Período",null,null,{"$f":"IFERROR(MID(VLOOKUP(Datos!seleccion,Tablas!I3:J14,2,FALSE),1,1),0)","v":0},{"$f":"IFERROR(MID(VLOOKUP(Datos!seleccion,Tablas!I3:J14,2,FALSE),2,1),0)","v":0},{"$nulls":30},1]
[null,"Espacio reservado para la DIAN",{"$nulls":25},"4. Número de Formulario"]
[]
[]
[]
[]
[null,"Datos del\ndeclarante","5. Número de  Identificación Tributaria (NIT)",{"$nulls":13},"6. DV","7. Primer apellido",{"$nulls":8},"8. Segundo apellido",{"$nulls":7},"9. Primer nombre",{"$nulls":7},"10. Otros nombres"]
[null,null,{"$f":"MID(Datos!$E$10,1,1)","v":""},{"$f":"MID(Datos!$E$10,2,1)","v":""},{"$f":"MID(Datos!$E$10,3,1)","v":""},{"$f":"MID(Datos!$E$10,4,1)","v":""},{"$f":"MID(Datos!$E$10,5,1)","v":""},{"$f":"MID(Datos!$E$10,6,1)","v":""},{"$f":"MID(Datos!$E$10,7,1)","v":""},{"$f":"MID(Datos!$E$10,8,1)","v":""},{"$f":"MID(Datos!$E$10,9,1)","v":""},{"$f":"MID(Datos!$E$10,10,1)","v":""},{"$f":"MID(Datos!$E$10,11,1)","v":""},{"$f":"MID(Datos!$E$10,12,1)","v":""},{"$f":"MID(Datos!$E$10,13,1)","v":""},{"$f":"MID(Datos!$E$10,14,1)","v":""},{"$f":"IF(Datos!H10=0,\"\",Datos!H10)","v":""},{"$f":"IF(Datos!E12=\"Persona natural\",IF(Datos!E14=0,\"\",Datos!E14),\"\")","v":""},{"$nulls":8},{"$f":"IF(Datos!E12=\"Persona natural\",IF(Datos!J14=0,\"\",Datos!J14),\"\")","v":""},{"$nulls":7},{"$f":"IF(Datos!E12=\"Persona natural\",IF(Datos!E16=0,\"\",Datos!E16),\"\")","v":""},{"$nulls":7},{"$f":"IF(Datos!E12=\"Persona natural\",IF(Datos!J16=0,\"\",Datos!J16),\"\")","v":""}]
[]
[null,null,"11.  Razón Social",{"$nulls":45},"12. Cód. Dirección Seccional."]
[null,null,{"$f":"IF(Datos!E12=\"Persona jurídica o sociedad de hecho\",IF(Datos!E18=0,\"\",Datos!E18),\"\")","v":""},{"$nulls":45},{"$f":"MID(Datos!L20,1,1)","v":"0"},null,{"$f":"MID(Datos!L20,2,1)","v":"0"}]
[null,"Si es una corrección Indique:",{"$nulls":7},"25. Cód.",null,null,{"$f":"IF(Datos!E23=\"\",\"\",Datos!E23)","v":""},null,null,"26. No. Formulario anterior",{"$nulls":6},{"$f":"IF(Datos!J23=\"\",\"\",Datos!J23)","v":""},{"$nulls":5},"98. Autorretenedores personas jurídicas exonerados de aportes (Art. 114-1 E.T.). ",{"$nulls":17},"99.Tarifa"]
[null,"Concepto",{"$nulls":25},"Base sujeta a retención para pagos o abonos en cuenta",{"$nulls":13},"Retenciones a título de renta"]
[null,"Rentas de trabajo",{"$nulls":25},27,{"$f":"ROUND(IF(AB18<>\"\",IFERROR(VLOOKUP(AB18,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},52,{"$f":"ROUND(IF(AB18<>\"\",IFERROR(VLOOKUP(AB18,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Rentas de pensiones",{"$nulls":25},{"$f":"AB18+1","v":28},{"$f":"ROUND(IF(AB19<>\"\",IFERROR(VLOOKUP(AB19,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},53,{"$f":"ROUND(IF(AB19<>\"\",IFERROR(VLOOKUP(AB19,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Honorarios",{"$nulls":25},29,{"$f":"ROUND(IF(AB20<>\"\",IFERROR(VLOOKUP(AB20,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},54,{"$f":"ROUND(IF(AB20<>\"\",IFERROR(VLOOKUP(AB20,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Comisiones",{"$nulls":25},30,{"$f":"ROUND(IF(AB21<>\"\",IFERROR(VLOOKUP(AB21,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},55,{"$f":"ROUND(IF(AB21<>\"\",IFERROR(VLOOKUP(AB21,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Servicios",{"$nulls":25},31,{"$f":"ROUND(IF(AB22<>\"\",IFERROR(VLOOKUP(AB22,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},56,{"$f":"ROUND(IF(AB22<>\"\",IFERROR(VLOOKUP(AB22,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Rendimientos financieros e intereses",{"$nulls":25},32,{"$f":"ROUND(IF(AB23<>\"\",IFERROR(VLOOKUP(AB23,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},57,{"$f":"ROUND(IF(AB23<>\"\",IFERROR(VLOOKUP(AB23,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Arrendamientos (Muebles e inmuebles)",{"$nulls":25},33,{"$f":"ROUND(IF(AB24<>\"\",IFERROR(VLOOKUP(AB24,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},58,{"$f":"ROUND(IF(AB24<>\"\",IFERROR(VLOOKUP(AB24,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Regalias y explotación de la propiedad intelectual",{"$nulls":25},34,{"$f":"ROUND(IF(AB25<>\"\",IFERROR(VLOOKUP(AB25,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},59,{"$f":"ROUND(IF(AB25<>\"\",IFERROR(VLOOKUP(AB25,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Dividendos y participaciones",{"$nulls":25},35,{"$f":"ROUND(IF(AB26<>\"\",IFERROR(VLOOKUP(AB26,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},60,{"$f":"ROUND(IF(AB26<>\"\",IFERROR(VLOOKUP(AB26,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Compras",{"$nulls":25},36,{"$f":"ROUND(IF(AB27<>\"\",IFERROR(VLOOKUP(AB27,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},61,{"$f":"ROUND(IF(AB27<>\"\",IFERROR(VLOOKUP(AB27,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Transacciones con tarjetas débito y crédito",{"$nulls":25},37,{"$f":"ROUND(IF(AB28<>\"\",IFERROR(VLOOKUP(AB28,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},62,{"$f":"ROUND(IF(AB28<>\"\",IFERROR(VLOOKUP(AB28,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Contratos de Construcción",{"$nulls":25},38,{"$f":"ROUND(IF(AB29<>\"\",IFERROR(VLOOKUP(AB29,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},63,{"$f":"ROUND(IF(AB29<>\"\",IFERROR(VLOOKUP(AB29,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Enajenación de activos fijos de personas naturales ante notarios y autoridades de tránsito",{"$nulls":25},39,{"$f":"ROUND(IF(AB30<>\"\",IFERROR(VLOOKUP(AB30,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},64,{"$f":"ROUND(IF(AB30<>\"\",IFERROR(VLOOKUP(AB30,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Loterias, rifas apuestas y similares",{"$nulls":25},{"$f":"AB30+1","v":40},{"$f":"ROUND(IF(AB31<>\"\",IFERROR(VLOOKUP(AB31,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},65,{"$f":"ROUND(IF(AB31<>\"\",IFERROR(VLOOKUP(AB31,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Otros pagos sujetos a retención",{"$nulls":25},41,{"$f":"ROUND(IF(AB32<>\"\",IFERROR(VLOOKUP(AB32,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},66,{"$f":"ROUND(IF(AB32<>\"\",IFERROR(VLOOKUP(AB32,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Autorretenciones","Contribuyentes exonerados de aportes  (Art. 114 -1  E.T.)",{"$nulls":24},42,{"$f":"ROUND(IF(AB33<>\"\",IFERROR(VLOOKUP(AB33,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},67,{"$f":"ROUND(IF(AB33<>\"\",IFERROR(VLOOKUP(AB33,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Ventas",{"$nulls":24},43,{"$f":"ROUND(IF(AB34<>\"\",IFERROR(VLOOKUP(AB34,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},68,{"$f":"ROUND(IF(AB34<>\"\",IFERROR(VLOOKUP(AB34,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Honorarios",{"$nulls":24},44,{"$f":"ROUND(IF(AB35<>\"\",IFERROR(VLOOKUP(AB35,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},69,{"$f":"ROUND(IF(AB35<>\"\",IFERROR(VLOOKUP(AB35,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Comisiones",{"$nulls":24},45,{"$f":"ROUND(IF(AB36<>\"\",IFERROR(VLOOKUP(AB36,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},70,{"$f":"ROUND(IF(AB36<>\"\",IFERROR(VLOOKUP(AB36,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Servicios",{"$nulls":24},46,{"$f":"ROUND(IF(AB37<>\"\",IFERROR(VLOOKUP(AB37,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},71,{"$f":"ROUND(IF(AB37<>\"\",IFERROR(VLOOKUP(AB37,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Rendimientos financieros",{"$nulls":24},47,{"$f":"ROUND(IF(AB38<>\"\",IFERROR(VLOOKUP(AB38,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},72,{"$f":"ROUND(IF(AB38<>\"\",IFERROR(VLOOKUP(AB38,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Pagos mensuales provisionales de carácter voluntario (hidrocarburos y demás productos mineros)",{"$nulls":24},48,{"$f":"ROUND(IF(AB39<>\"\",IFERROR(VLOOKUP(AB39,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},73,{"$f":"ROUND(IF(AB39<>\"\",IFERROR(VLOOKUP(AB39,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Otros conceptos",{"$nulls":24},49,{"$f":"ROUND(IF(AB40<>\"\",IFERROR(VLOOKUP(AB40,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},74,{"$f":"ROUND(IF(AB40<>\"\",IFERROR(VLOOKUP(AB40,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Pagos o abonos en cuenta al exterior a paises sin convenio",{"$nulls":25},50,{"$f":"ROUND(IF(AB41<>\"\",IFERROR(VLOOKUP(AB41,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},75,{"$f":"ROUND(IF(AB41<>\"\",IFERROR(VLOOKUP(AB41,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Pagos o abonos en cuenta al exterior a paises con convenio vigente",{"$nulls":25},51,{"$f":"ROUND(IF(AB42<>\"\",IFERROR(VLOOKUP(AB42,importar!$A$2:'importar'!$B$35,2,FALSE),0),0),-3)","v":0},{"$nulls":12},76,{"$f":"ROUND(IF(AB42<>\"\",IFERROR(VLOOKUP(AB42,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas.",{"$nulls":39},77,{"$f":"ROUND(IF(AP43<>\"\",IFERROR(VLOOKUP(AP43,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Total retenciones renta y complementarios (Sume casillas 52 a 76 y reste casilla 77)",{"$nulls":39},78,{"$f":"SUM(AQ18:AZ42)-AQ43","v":0}]
[null,"Retenciones practicadas por otros impuestos"]
[null,"A título de IVA","A responsables del impuesto sobre las ventas",{"$nulls":38},79,{"$f":"ROUND(IF(AP46<>\"\",IFERROR(VLOOKUP(AP46,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Practicadas por servicios a no residentes o no domiciliados",{"$nulls":38},80,{"$f":"ROUND(IF(AP47<>\"\",IFERROR(VLOOKUP(AP47,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas",{"$nulls":38},81,{"$f":"ROUND(IF(AP48<>\"\",IFERROR(VLOOKUP(AP48,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0},{"$nulls":18},"                 "]
[null,null,"Total retenciones I.V.A. (Sume 79 a 80 y reste 81)",{"$nulls":38},82,{"$f":"SUM(AQ46:AZ47)-AQ48","v":0},{"$nulls":15},"                 "]
[null,"Retenciones Impuesto de timbre nacional",{"$nulls":39},83,{"$f":"ROUND(IF(AP50<>\"\",IFERROR(VLOOKUP(AP50,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0},{"$nulls":18},"      "]
[null,"Retenciones contribución laudos arbitrales ",{"$nulls":39},84,{"$f":"ROUND(IF(AP51<>\"\",IFERROR(VLOOKUP(AP51,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,"Total","Total Retenciones (78 + 82 + 83 + 84)",{"$nulls":38},85,{"$f":"+AQ44+AQ49+AQ50+AQ51","v":0}]
[null,null,"Sanciones",{"$nulls":38},86,{"$f":"ROUND(IF(AP53<>\"\",IFERROR(VLOOKUP(AP53,importar!$A$2:'importar'!$C$35,3,FALSE),0),0),-3)","v":0}]
[null,null,"Total retenciones más sanciones (85 + 86)",{"$nulls":38},87,{"$f":"AQ52+AQ53","v":0}]
[null,"88. No. Identificación signatario",{"$nulls":19},"89. DV"]
[null,"981.Cód. Representación",{"$nulls":6},{"$f":"+MID(Datos!L31,1,1)","v":""},{"$f":"+MID(Datos!L31,2,1)","v":""},{"$nulls":6},"997. Espacio exclusivo para el Sello de la entidad recaudadora"]
[null,"Firma del declarante o de quien lo representa",{"$nulls":14},"(Fecha efectiva de la transacción)",{"$nulls":15}," 980. Pago Total",{"$nulls":7},"$  ",{"$f":"+AQ54","v":0}]
[]
[null,"982. Código Contador o Revisor Fiscal",{"$nulls":10},{"$f":"IF(Datos!E33=0,\"\",Datos!E33)","v":""},{"$nulls":19},"996. Espacio para el número interno de la DIAN / Adhesivo"]
[null,"Firma Contador o Revisor Fiscal.              994. Con salvedades",{"$nulls":12},{"$f":"IF(Datos!E35=\"Sí\",\"X\",\"\")","v":""},{"$nulls":9}," "]
[{"$nulls":16},"Coloque el timbre de la máquina"]
[null,"983. No. Tarjeta profesional ",{"$nulls":7},{"$f":"IF(Datos!J33=0,\"\",Datos!J33)","v":""},{"$nulls":6},"registradora al dorso de este formulario"]

{"sheet":"Anexo","index":2,"n_rows":200,"n_cols":11,"rows_kept":200,"merged":[[0,1,1,1],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,0,9],[0,10,1,10],[3,1,7,1],[3,3,7,3],[3,4,6,4],[9,1,13,1],[9,3,13,3],[9,4,12,4],[15,1,19,1],[15,3,19,3],[15,4,18,4],[21,1,25,1],[21,3,25,3],[21,4,24,4],[27,1,31,1],[27,3,31,3],[27,4,30,4],[33,1,37,1],[33,3,37,3],[33,4,36,4],[39,1,43,1],[39,3,43,3],[39,4,42,4],[45,1,49,1],[45,3,49,3],[45,4,48,4],[51,1,55,1],[51,3,55,3],[51,4,54,4],[57,1,61,1],[57,3,61,3],[57,4,60,4],[63,1,67,1],[63,3,67,3],[63,4,66,4],[69,1,73,1],[69,3,73,3],[69,4,72,4],[75,1,79,1],[75,3,79,3],[75,4,78,4],[81,1,85,1],[81,3,85,3],[81,4,84,4],[87,1,91,1],[87,3,91,3],[87,4,90,4],[93,3,94,4],[95,1,99,1],[95,3,99,3],[95,4,98,4],[101,1,105,1],[101,3,105,3],[101,4,104,4],[107,1,111,1],[107,3,111,3],[107,4,110,4],[113,1,117,1],[113,3,117,3],[113,4,116,4],[119,1,123,1],[119,3,123,3],[119,4,122,4],[125,1,129,1],[125,3,129,3],[125,4,128,4],[131,1,135,1],[131,3,135,3],[131,4,134,4],[137,1,141,1],[137,3,141,3],[137,4,140,4],[144,1,148,1],[144,3,148,3],[144,4,147,4],[150,1,154,1],[150,3,154,3],[150,4,153,4],[156,1,160,1],[156,3,160,3],[156,4,159,4],[162,3,163,4],[164,1,168,1],[164,3,168,3],[164,4,167,4],[170,1,174,1],[170,3,174,3],[170,4,173,4],[176,1,180,1],[176,3,180,3],[176,4,179,4],[183,1,187,1],[183,3,187,3],[183,4,186,4],[189,1,193,1],[189,3,193,3],[189,4,192,4],[195,1,199,1],[195,3,199,3],[195,4,198,4]]}
[null,"Renglón",null,"Renglón","Concepto","Código\ncuenta contable","Nombre del beneficiario del pago o abono en cuenta","NIT","Retención en la fuente a título de renta, IVA, Timbre e INC",null,"Devolución de retenciones de períodos anteriores"]
[{"$nulls":8},"Base sujeta a retención para pagos o abonos en cuenta","Retenciones a título de renta"]
[]
[null,27,null,52,"Rentas de trabajo",{"$nulls":3},4800000,270000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I4:I7)","v":4800000},{"$f":"SUM(J4:J7)","v":270000}]
[]
[null,28,null,53,"Rentas de pensiones"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I10:I13)","v":0},{"$f":"SUM(J10:J13)","v":0}]
[]
[null,29,null,54,"Honorarios"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I16:I19)","v":0},{"$f":"SUM(J16:J19)","v":0}]
[]
[null,30,null,55,"Comisiones"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I22:I25)","v":0},{"$f":"SUM(J22:J25)","v":0}]
[]
[null,31,null,56,"Servicios",{"$nulls":3},3015200,172000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I28:I31)","v":3015200},{"$f":"SUM(J28:J31)","v":172000}]
[]
[null,32,null,57,"Rendimientos financieros e intereses"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I34:I37)","v":0},{"$f":"SUM(J34:J37)","v":0}]
[]
[null,33,null,58,"Arrendamientos (Muebles e inmuebles)",{"$nulls":3},500000,20000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I40:I43)","v":500000},{"$f":"SUM(J40:J43)","v":20000}]
[]
[null,34,null,59,"Regalias y explotación de la propiedad intelectual"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I46:I49)","v":0},{"$f":"SUM(J46:J49)","v":0}]
[]
[null,35,null,60,"Dividendos y participaciones"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I52:I55)","v":0},{"$f":"SUM(J52:J55)","v":0}]
[]
[null,36,null,61,"Compras",{"$nulls":3},6000000,126000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I58:I61)","v":6000000},{"$f":"SUM(J58:J61)","v":126000}]
[]
[null,37,null,62,"Transacciones con tarjetas débito y crédito"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I64:I67)","v":0},{"$f":"SUM(J64:J67)","v":0}]
[]
[null,38,null,63,"Contratos de Construcción"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I70:I73)","v":0},{"$f":"SUM(J70:J73)","v":0}]
[]
[null,39,null,64,"Enajenación de activos fijos de personas naturales ante notarios y autoridades de tránsito"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I76:I79)","v":0},{"$f":"SUM(J76:J79)","v":0}]
[]
[null,40,null,65,"Loterias, rifas, apuestas y similares"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I82:I85)","v":0},{"$f":"SUM(J82:J85)","v":0}]
[]
[null,41,null,66,"Otros pagos sujetos a retención"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I88:I91)","v":0},{"$f":"SUM(J88:J91)","v":0}]
[]
[{"$nulls":3},"AUTORRETENCIONES"]
[]
[null,42,null,67,"Contribuyentes exonerados de aportes  (artículo 114 -1 del  ET)",{"$nulls":3},2000000,50000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I96:I99)","v":2000000},{"$f":"SUM(J96:J99)","v":50000}]
[]
[null,43,null,68,"Ventas"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I102:I105)","v":0},{"$f":"SUM(J102:J105)","v":0}]
[]
[null,44,null,69,"Honorarios"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I108:I111)","v":0},{"$f":"SUM(J108:J111)","v":0}]
[]
[null,45,null,70,"Comisiones"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I114:I117)","v":0},{"$f":"SUM(J114:J117)","v":0}]
[]
[null,46,null,71,"Servicios"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I120:I123)","v":0},{"$f":"SUM(J120:J123)","v":0}]
[]
[null,47,null,72,"Rendimientos financieros"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I126:I129)","v":0},{"$f":"SUM(J126:J129)","v":0}]
[]
[null,48,null,73,"Pagos mensuales provisionales de carácter voluntario (hidrocarburos y demás productos mineros)"]
[]
[]
[]
[{"$nulls":8},{"$f":"SUM(I132:I135)","v":0},{"$f":"SUM(J132:J135)","v":0}]
[]
[null,49,null,74,"Otros conceptos"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I138:I141)","v":0},{"$f":"SUM(J138:J141)","v":0}]
[]
[]
[null,50,null,75,"Pagos o abonos en cuenta al exterior a países sin convenio"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I145:I148)","v":0},{"$f":"SUM(J145:J148)","v":0}]
[]
[null,51,null,76,"Pagos o abonos en cuenta al exterior a países con convenio vigente"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":3},{"$f":"SUM(I151:I154)","v":0},{"$f":"SUM(J151:J154)","v":0}]
[]
[{"$nulls":3},77,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas",{"$nulls":4},300000]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J157:J160)","v":300000}]
[]
[{"$nulls":3},"A TÍTULO DE IVA"]
[]
[{"$nulls":3},79,"A responsables del impuesto sobre las ventas",{"$nulls":4},142500]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J165:J168)","v":142500}]
[]
[{"$nulls":3},80,"Retención de IVA - Practicadas por servicios a no residentes o no domiciliados"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J171:J174)","v":0}]
[]
[{"$nulls":3},81,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J177:J180)","v":0}]
[]
[]
[{"$nulls":3},83,"Retenciones impuesto de timbre nacional"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J184:J187)","v":0}]
[]
[{"$nulls":3},84,"Retenciones contribución laudos arbitrales"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J190:J193)","v":0}]
[]
[{"$nulls":3},86,"Sanciones"]
[]
[]
[]
[{"$nulls":4},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(J196:J199)","v":0}]

{"sheet":"Vencimientos","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,6,0],[5,1,5,12],[18,0,19,12]]}
["Retención en la fuente y autorretención del impuesto de renta y complementarios"]
["Declaración y pago mensual 2023"]
[]
[]
["Último dígito del NIT","Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"Plazo máximo para consignar en 2023"]
[null,"Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic","Ene 2024"]
[1,7,7,10,9,7,7,9,7,10,8,11,10]
[2,8,8,11,10,8,10,10,8,11,9,12,11]
[3,9,9,12,11,9,11,11,11,12,10,13,12]
[4,10,10,13,12,13,12,14,12,13,14,14,15]
[5,13,13,14,15,14,13,15,13,17,15,15,16]
[6,14,14,17,16,15,14,16,14,18,16,18,17]
[7,15,15,18,17,16,17,17,15,19,17,19,18]
[8,16,16,19,18,20,18,18,18,20,20,20,19]
[9,17,17,20,19,21,19,22,19,23,21,21,22]
[0,20,21,21,23,22,21,23,20,24,22,22,23]
[]
["*Estos plazos aplican para la declaración y pago de retención en la fuente y/o autorretención del impuesto de renta y complementario, impuesto de timbre, IVA y contribución por laudos arbitrales."]

{"sheet":"Datos","index":4,"n_rows":35,"n_cols":12,"rows_kept":35,"merged":[[0,0,1,12],[7,0,7,12],[11,1,11,2],[11,4,11,6],[13,1,13,2],[15,1,15,2],[17,1,17,2],[17,4,17,9],[18,1,18,3],[19,4,19,9],[20,1,21,3],[24,0,24,12],[26,0,26,3],[28,0,28,12],[30,1,30,3],[30,4,30,9],[34,1,34,2]]}
["DATOS INICIALES"]
[]
[]
[null,null,"1. Año",null,2022]
[]
[null,null,"3. Período"]
[]
["DATOS DEL DECLARANTE"]
[]
[null,null,"5. NIT",{"$nulls":3},"6. DV",{"$f":"IF(Formulas!A2=0,0,IF(Formulas!A2=1,1,11-Formulas!A2))","v":0}]
[]
[null,"Tipo de agente"]
[]
[null," 7. Primer apellido",{"$nulls":4}," 8. Segundo apellido"]
[]
[null," 9. Primer nombre",{"$nulls":4}," 10. Otros nombres"]
[]
[null,"11. Razón social"]
[]
[null,"12. Cód. Direccíon Seccional",null,null,"Nivel Central",{"$nulls":6},{"$f":"IFERROR(VLOOKUP(E20,Tablas!C16:D67,2,FALSE),\"\")","v":"00"}]
[null,"Si es una corrección indique"]
[]
[null,"25. Código",{"$nulls":4},"26. No. Formulario anterior"]
[]
["DATOS DEL SIGNATARIO"]
[]
["89. No. Identificación signatario",{"$nulls":5},"90. DV",{"$f":"IF(Formulas!A3=0,0,IF(Formulas!A3=1,1,11-Formulas!A3))","v":0}]
[]
["SECCIÓN FIRMAS"]
[]
[null,"981. Código representación",{"$nulls":9},{"$f":"IFERROR(IF(E12=\"Persona natural\",VLOOKUP(E31,Tablas!I18:J41,2,FALSE),IF(E12=\"Persona jurídica o sociedad de hecho\",VLOOKUP(E31,Tablas!K18:L38,2,FALSE),\"\")),\"\")","v":""}]
[]
[null,"982. Código",{"$nulls":4},"983. No. Tarjeta profesional"]
[]
[null,"994. Con salvedades"]

{"sheet":"Anexo 2","index":5,"n_rows":63,"n_cols":74,"rows_kept":63,"merged":[[1,1,4,15],[1,16,4,52],[1,53,3,58],[1,59,3,62],[1,63,4,77],[4,53,4,58],[4,59,4,62],[5,1,5,40],[5,57,5,59],[5,61,5,70],[12,5,12,40],[12,49,12,77],[13,2,13,12],[13,13,13,21],[13,22,13,37],[13,38,13,41],[13,42,13,57],[13,58,13,66],[13,67,13,77],[14,2,14,12],[14,13,14,21],[14,22,14,37],[14,38,14,41],[14,42,14,57],[14,58,14,66],[14,67,14,77],[15,2,15,12],[15,13,15,21],[15,22,15,37],[15,38,15,41],[15,42,15,57],[15,58,15,66],[15,67,15,77],[16,2,16,12],[16,13,16,21],[16,22,16,37],[16,38,16,41],[16,42,16,57],[16,58,16,66],[16,67,16,77],[17,2,17,12],[17,13,17,21],[17,22,17,37],[17,38,17,41],[17,42,17,57],[17,58,17,66],[17,67,17,77],[18,2,18,12],[18,13,18,21],[18,22,18,37],[18,38,18,41],[18,42,18,57],[18,58,18,66],[18,67,18,77],[19,2,19,12],[19,13,19,21],[19,22,19,37],[19,38,19,41],[19,42,19,57],[19,58,19,66],[19,67,19,77],[20,2,20,12],[20,13,20,21],[20,22,20,37],[20,38,20,41],[20,42,20,57],[20,58,20,66],[20,67,20,77],[21,2,21,12],[21,13,21,21],[21,22,21,37],[21,38,21,41],[21,42,21,57],[21,58,21,66],[21,67,21,77],[22,2,22,12],[22,13,22,21],[22,22,22,37],[22,38,22,41],[22,42,22,57],[22,58,22,66],[22,67,22,77],[23,2,23,12],[23,13,23,21],[23,22,23,37],[23,38,23,41],[23,42,23,57],[23,58,23,66],[23,67,23,77],[24,2,24,12],[24,13,24,21],[24,22,24,37],[24,38,24,41],[24,42,24,57],[24,58,24,66],[24,67,24,77],[25,2,25,12],[25,13,25,21],[25,22,25,37],[25,38,25,41],[25,42,25,57],[25,58,25,66],[25,67,25,77],[26,2,26,12],[26,13,26,21],[26,22,26,37],[26,38,26,41],[26,42,26,57],[26,58,26,66],[26,67,26,77],[27,2,27,12],[27,13,27,21],[27,22,27,37],[27,38,27,41],[27,42,27,57],[27,58,27,66],[27,67,27,77],[28,2,28,12],[28,13,28,21],[28,22,28,37],[28,38,28,41],[28,42,28,57],[28,58,28,66],[28,67,28,77],[29,2,29,12],[29,13,29,21],[29,22,29,37],[29,38,29,41],[29,42,29,57],[29,58,29,66],[29,67,29,77],[30,2,30,12],[30,13,30,21],[30,22,30,37],[30,38,30,41],[30,42,30,57],[30,58,30,66],[30,67,30,77],[31,2,31,12],[31,13,31,21],[31,22,31,37],[31,38,31,41],[31,42,31,57],[31,58,31,66],[31,67,31,77],[32,2,32,12],[32,13,32,21],[32,22,32,37],[32,38,32,41],[32,42,32,57],[32,58,32,66],[32,67,32,77],[33,2,33,12],[33,13,33,21],[33,22,33,37],[33,38,33,41],[33,42,33,57],[33,58,33,66],[33,67,33,77],[34,2,34,12],[34,13,34,21],[34,22,34,37],[34,38,34,41],[34,42,34,57],[34,58,34,66],[34,67,34,77],[35,2,35,12],[35,13,35,21],[35,22,35,37],[35,38,35,41],[35,42,35,57],[35,58,35,66],[35,67,35,77],[36,2,36,12],[36,13,36,21],[36,22,36,37],[36,38,36,41],[36,42,36,57],[36,58,36,66],[36,67,36,77],[37,2,37,12],[37,13,37,21],[37,22,37,37],[37,38,37,41],[37,42,37,57],[37,58,37,66],[37,67,37,77],[38,2,38,12],[38,13,38,21],[38,22,38,37],[38,38,38,41],[38,42,38,57],[38,58,38,66],[38,67,38,77],[39,2,39,12],[39,13,39,21],[39,22,39,37],[39,38,39,41],[39,42,39,57],[39,58,39,66],[39,67,39,77],[40,2,40,12],[40,13,40,21],[40,22,40,37],[40,38,40,41],[40,42,40,57],[40,58,40,66],[40,67,40,77],[41,2,41,12],[41,13,41,21],[41,22,41,37],[41,38,41,41],[41,42,41,57],[41,58,41,66],[41,67,41,77],[42,2,42,12],[42,13,42,21],[42,22,42,37],[42,38,42,41],[42,42,42,57],[42,58,42,66],[42,67,42,77],[43,2,43,12],[43,13,43,21],[43,22,43,37],[43,38,43,41],[43,42,43,57],[43,58,43,66],[43,67,43,77],[44,2,44,12],[44,13,44,21],[44,22,44,37],[44,38,44,41],[44,42,44,57],[44,58,44,66],[44,67,44,77],[45,2,45,12],[45,13,45,21],[45,22,45,37],[45,38,45,41],[45,42,45,57],[45,58,45,66],[45,67,45,77],[46,2,46,12],[46,13,46,21],[46,22,46,37],[46,38,46,41],[46,42,46,57],[46,58,46,66],[46,67,46,77],[47,2,47,12],[47,13,47,21],[47,22,47,37],[47,38,47,41],[47,42,47,57],[47,58,47,66],[47,67,47,77],[48,2,48,12],[48,13,48,21],[48,22,48,37],[48,38,48,41],[48,42,48,57],[48,58,48,66],[48,67,48,77],[49,2,49,12],[49,13,49,21],[49,22,49,37],[49,38,49,41],[49,42,49,57],[49,58,49,66],[49,67,49,77],[50,2,50,12],[50,13,50,21],[50,22,50,37],[50,38,50,41],[50,42,50,57],[50,58,50,66],[50,67,50,77],[51,2,51,12],[51,13,51,21],[51,22,51,37],[51,38,51,41],[51,42,51,57],[51,58,51,66],[51,67,51,77],[52,2,52,12],[52,13,52,21],[52,22,52,37],[52,38,52,41],[52,42,52,57],[52,58,52,66],[52,67,52,77],[53,2,53,12],[53,13,53,21],[53,22,53,37],[53,38,53,41],[53,42,53,57],[53,58,53,66],[53,67,53,77],[54,2,54,12],[54,13,54,21],[54,22,54,37],[54,38,54,41],[54,42,54,57],[54,58,54,66],[54,67,54,77],[55,2,55,12],[55,13,55,21],[55,22,55,37],[55,38,55,41],[55,42,55,57],[55,58,55,66],[55,67,55,77],[56,2,56,12],[56,13,56,21],[56,22,56,37],[56,38,56,41],[56,42,56,57],[56,58,56,66],[56,67,56,77],[57,2,57,12],[57,13,57,21],[57,22,57,37],[57,38,57,41],[57,42,57,57],[57,58,57,66],[57,67,57,77],[58,2,58,12],[58,13,58,21],[58,22,58,37],[58,38,58,41],[58,42,58,57],[58,58,58,66],[58,67,58,77],[59,2,59,12],[59,13,59,21],[59,22,59,37],[59,38,59,41],[59,42,59,57],[59,58,59,66],[59,67,59,77],[60,2,60,12],[60,13,60,21],[60,22,60,37],[60,38,60,41],[60,42,60,57],[60,58,60,66],[60,67,60,77],[61,2,61,12],[61,13,61,21],[61,22,61,37],[61,38,61,41],[61,42,61,57],[61,58,61,66],[61,67,61,77],[62,2,62,12],[62,13,62,21],[62,22,62,37],[62,38,62,41],[62,42,62,57],[62,58,62,66],[62,67,62,77],[64,1,65,15],[64,16,65,51],[64,53,65,58],[64,59,65,62],[64,63,65,77]]}
[]
[{"$nulls":16},"Declaración de Retenciones en la Fuente "]
[]
[]
[]
[{"$nulls":52},"Página",{"$nulls":7},"de",{"$nulls":12},"Hoja 2"]
[null,"Espacio reservado para la DIAN",{"$nulls":39},"4. Número de formulario"]
[]
[]
[]
[]
[{"$nulls":8},1,{"$nulls":9},2,null,3,3,{"$nulls":12},4,{"$nulls":13},6]
[]
[null,null,"90. A paises",{"$nulls":10},"91.\nConcepto de \npago",{"$nulls":8},"92. País",{"$nulls":15},"Cód",{"$nulls":3},"93. Base",{"$nulls":15},"94.Tarifa (%)",{"$nulls":8},"95. Valor retención"]
[null,1]
[null,{"$f":"+B15+1","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[{"$f":"+B51","v":37},38]
[{"$f":"+S51","v":0},39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]

{"sheet":"Instructivo","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Tablas","index":7,"n_rows":70,"n_cols":12,"rows_kept":70,"hidden":true,"merged":[[1,8,1,9],[15,2,15,3],[15,8,15,11],[16,8,16,9],[16,10,16,11]]}
[]
[{"$nulls":8},"Periodo"]
[{"$nulls":8},"Enero","01"]
[{"$nulls":8},"Febrero","02"]
[{"$nulls":8},"Marzo","03"]
[{"$nulls":8},"Abril","04"]
[{"$nulls":8},"Mayo","05"]
[{"$nulls":8},"Junio","06"]
[{"$nulls":8},"Julio","07"]
[{"$nulls":8},"Agosto","08"]
[{"$nulls":8},"Septiembre","09"]
[{"$nulls":8},"Octubre",10]
[null,null,"Persona natural",{"$nulls":3},"Código",null,"Noviembre",11]
[null,null,"Persona jurídica o sociedad de hecho",{"$nulls":3},1,null,"Diciembre",12]
[{"$nulls":6},2]
[null,null,"Cód Dirección Seccional",{"$nulls":3},3,null,"Cód representación"]
[null,null,"Nivel Central","00",null,null,4,null,"Persona natural",null,"Persona jurídica o sociedad de hecho"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Armenia","01",{"$nulls":4}," Administrador judicial","01"," Administrador judicial","01"]
[null,null,"Dirección Seccional de Impuestos de Barranquilla","02",null,null,"Código C o RF",null," Administrador privado","02"," Administrador privado","02"]
[null,null,"Dirección Seccional de Aduanas de Bogotá","03",null,null,1,null," Agente exclusivo de negocios en colombia","03"," Agente exclusivo de negocios en colombia","03"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Bucaramanga","04",null,null,2,null," Agente oficioso","04"," Agente oficioso","04"]
[null,null,"Dirección Seccional de Impuestos de Cali","05",{"$nulls":4}," Albacea","05"," Apoderado especial","06"]
[null,null,"Dirección Seccional de Impuestos de Cartagena","06",null,null,"Salvedad",null," Apoderado especial","06"," Apoderado general","07"]
[null,null,"Dirección Seccional de Impuestos de Cúcuta","07",null,null,"Sí",null," Apoderado general","07"," Comunero","09"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Girardot","08",null,null,"No",null," Asignatario","08"," Factor","12"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Ibagué","09",{"$nulls":4}," Comunero","09"," Funcionario delegado para cumplir deberes formales","13"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Manizales",10,{"$nulls":4}," Curador","10"," Liquidador","15"]
[null,null,"Dirección Seccional de Impuestos de Medellín",11,{"$nulls":4}," Donatario","11"," Mandatario","16"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Montería",12,{"$nulls":4}," Factor","12"," Representante legal principal","18"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Neiva",13,{"$nulls":4}," Heredero con administración de bienes","14"," Representante legal suplente","19"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Pasto",14,{"$nulls":4}," Liquidador","15"," Síndico","20"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Palmira",15,{"$nulls":4}," Mandatario","16","Representante aduanero",22]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Pereira",16,{"$nulls":4}," Padre","17","Liquidador suplente",23]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Popayán",17,{"$nulls":4}," Tutor","21","Depositario Provisional",24]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Quibdó",18,{"$nulls":4},"Representante aduanero",22,"Agente Interventor",25]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Santa Marta",19,{"$nulls":4},"Liquidador suplente",23,"Agente de Aduanas",26]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Tunja",20,{"$nulls":4},"Depositario Provisional",24,"Funcionario delegado para cumplir funciones OEA",27]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Tuluá",21,{"$nulls":4},"Agente Interventor",25,"Representante legal empresa receptora inversión extranjera",30]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Villavicencio",22,{"$nulls":4},"Heredero designado",28]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Sincelejo",23,{"$nulls":4},"Persona Natural sin residencia en Colombia con EP",29]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Valledupar",24,{"$nulls":4},"Representante legal empresa receptora inversión extranjera",30]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Riohacha",25]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Sogamoso",26]
[null,null,"Dirección Seccional de Impuestos y Aduanas de San Andrés",27,{"$nulls":4},"90. A paises"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Florencia",28,{"$nulls":4},"SIN CONVENIO"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Barrancabermeja",29,{"$nulls":4},"CON CONVENIO"]
[null,null,"Dirección Seccional de Impuestos de Grandes Contribuyentes",31]
[null,null,"Dirección Seccional de Impuestos de Bogotá",32,{"$nulls":4},"91.\nConcepto de \npago"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Arauca",34,{"$nulls":4},"SIN CONVENIO"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Buenaventura",35,{"$nulls":4},"01.   Enajenación de activos fijos y otras retenciones"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Cartago",36,{"$nulls":4},"02.   Dividendos y participaciones"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Ipiales",37,{"$nulls":4},"03.   Rendimientos financieros"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Leticia",38,{"$nulls":4},"04.   Pagos por explotación de intangibles"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Maicao",39,{"$nulls":4},"05.   Servicios"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Tumaco",40,{"$nulls":4},"06.   Servicios técnicos, asistencia técnica, consultoría"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Urabá",41,{"$nulls":4},"CON CONVENIO"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Puerto Carreño",42,{"$nulls":4},"01.   Rentas Inmobiliarias"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Inírida",43,{"$nulls":4},"02.   Dividendos y participaciones"]
[null,null,"Dirección Seccional de Impuestos y Aduanas de Yopal",44,{"$nulls":4},"03.   Intereses"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas Mitú",45,{"$nulls":4},"04.   Regalías"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Puerto Asís",46,{"$nulls":4},"05.   Ganancias de capital"]
[null,null,"Dirección Seccional de Aduanas de Cartagena",48,{"$nulls":4},"06.   Rentas de trabajo"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de San José de Guaviare",78,{"$nulls":4},"07.   Honorarios de directores"]
[null,null,"Dirección Seccional Delegada de Impuestos y Aduanas de Pamplona",86,{"$nulls":4},"08.   Artistas y deportistas"]
[null,null,"Dirección Seccional de Aduanas de Barranquilla",87,{"$nulls":4},"09.   Pensiones"]
[null,null,"Dirección Seccional de Aduanas de Cali",88,{"$nulls":4},"10.   Funciones públicas"]
[null,null,"Dirección Seccional de Aduanas de Cúcuta",89,{"$nulls":4},"11.   Estudiantes"]
[null,null,"Dirección Seccional de Aduanas de Medellín",90,{"$nulls":4},"12.   Servicios"]
[{"$nulls":8},"13.   Servicios técnicos, asistencia técnica, consultoría"]
[{"$nulls":8},"14.   Otras rentas"]

{"sheet":"1","index":8,"n_rows":22,"n_cols":4,"rows_kept":22,"hidden":true,"merged":[[5,0,8,3],[26,0,26,8],[27,0,27,8]]}
[]
[]
[]
[]
[]
["Material relacionado"]
[]
[]
[]
["Concepto","Cuantía en UVT","Cuantía en pesos","Tarifa"]
["Ingresos originados en una relación laboral o legal y reglamentaria (personas naturales declarantes o no de renta).","> 95 UVT","> 3.610.000","Ver tabla del artículo 383 del ET."]
["Honorarios y compensación de servicios personales por personas naturales que manifiestan que no han subcontratado dos o más personas.","> 95 UVT","> 3.610.000","Ver tabla del artículo 383 del ET."]
["Servicios de aseo y vigilancia (la base será el 100 % del AIU, siempre que sea mayor o igual a 4 UVT).","≥ 4 UVT","≥ 152.000",{"v":0.02,"d":"2.00%"}]
["Servicios de hoteles, restaurantes y hospedajes para obligados a declarar renta.","≥ 4","≥ 152.000",{"v":0.035,"d":"3.50%"}]
["Servicios de transporte nacional de carga.","≥ 4 UVT","≥ 152.000",{"v":0.01,"d":"1.00%"}]
["Servicios de transporte terrestre nacional de pasajeros.","≥ 27","≥ 1.026.000",{"v":0.035,"d":"3.50%"}]
["Servicio de transporte aéreo y marítimo de pasajeros.","≥ 4 UVT","≥ 152.000",{"v":0.01,"d":"1.00%"}]
["Servicios en general cuando el beneficiario del pago o abono es persona jurídica, asimilada o persona natural obligada a declarar renta.","≥ 4 UVT","≥ 152.000",{"v":0.04,"d":"4.00%"}]
["Servicios en general cuando el beneficiario del pago o abono es persona natural no obligada a declarar renta.","≥ 4 UVT","≥ 152.000","4% o 6%"]
["Servicios temporales de empleo (la base será el 100 % del AIU, siempre que sea mayor o igual a 4 UVT).","≥ 4 UVT","≥ 152.000",{"v":0.01,"d":"1.00%"}]
["Servicios integrales de salud prestados por una IPS.","≥ 4 UVT","≥ 152.000",{"v":0.02,"d":"2.00%"}]
["Servicios de licenciamiento y derechos de uso de software a obligados a declarar renta.","No aplica","> 0",{"v":0.035,"d":"3.50%"}]

{"sheet":"2","index":9,"n_rows":23,"n_cols":4,"rows_kept":23,"hidden":true,"merged":[[5,0,8,3],[26,0,26,8],[27,0,27,8]]}
[]
[]
[]
[]
[]
["Material relacionado"]
[]
[]
[]
["Contenido","Cuantía en UVT","Cuantía en pesos","Tarifa"]
["Compras en general para obligados a declarar renta.","≥ 27 UVT","≥ 1.026.000",{"v":0.025,"d":"2.50%"}]
["Compras en general para no obligados a declarar renta.","≥ 27 UVT","≥ 1.026.000",{"v":0.035,"d":"3.50%"}]
["Compra de café pergamino o cereza.","> 160 UVT","> 6.081.000",{"v":0.005,"d":"0.50%"}]
["Compras con tarjetas débito o crédito.","No aplica","> 0",{"v":0.015,"d":"1.50%"}]
["Compra de productos agrícolas o pecuarios sin procesamiento industrial.","> 92 UVT","> 3.496.000",{"v":0.015,"d":"1.50%"}]
["Compra de bienes y productos agrícolas o pecuarios con procesamiento industrial, llevada a cabo por personas jurídicas, sociedades de hecho y personas naturales agentes retenedores (vendedor obligado a declarar).","≥ 27 UVT","≥ 1.026.000",{"v":0.025,"d":"2.50%"}]
["Compra de bienes y productos agrícolas o pecuarios con procesamiento industrial, llevada a cabo por personas jurídicas, sociedades de hecho y personas naturales agentes retenedores (vendedor no obligado a declarar).","≥ 27 UVT","≥ 1.026.000",{"v":0.035,"d":"3.50%"}]
["Adquisición de bienes raíces para uso de vivienda de habitación por las primeras 20.000 UVT.","Hasta 20.000 UVT","≤ 760.080.000",{"v":0.01,"d":"1.00%"}]
["Adquisición de bienes raíces para uso de vivienda de habitación, cuando exceda las 20.000 UVT (al excedente se le aplicará la tarifa aquí señalada).","Más de 20.000 UVT","> 760.080.000",{"v":0.025,"d":"2.50%"}]
["Adquisición de bienes raíces para uso diferente a vivienda de habitación, si el vendedor es persona jurídica, sociedad de hecho o persona natural declarante, de acuerdo con lo establecido en el artículo 368-2 del ET.","≥ 27 UVT","≥ 1.026.000",{"v":0.025,"d":"2.50%"}]
["Adquisición de vehículos.","≥ 27 UVT","≥ 1.026.000",{"v":0.01,"d":"1.00%"}]
["Compra de combustibles derivados del petróleo.","No aplica","> 0",{"v":1E-3,"d":"0.10%"}]
["Enajenación de bienes raíces por parte de personas jurídicas.","≥ 27 UVT","≥ 980.000","1% 0 2,5%"]

{"sheet":"Formulas","index":10,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
[]
[{"$f":"MOD((VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),15,1))*3+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),14,1))*7+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),13,1))*13+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),12,1))*17+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),11,1))*19+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),10,1))*23+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),9,1))*29+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),8,1))*37+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),7,1))*41+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),6,1))*43+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),5,1))*47+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),4,1))*53+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),3,1))*59+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),2,1))*67+VALUE(MID(TEXT(Datos!E10,\"000000000000000\"),1,1))*71),11)","v":0}]
[{"$f":"MOD((VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),15,1))*3+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),14,1))*7+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),13,1))*13+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),12,1))*17+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),11,1))*19+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),10,1))*23+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),9,1))*29+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),8,1))*37+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),7,1))*41+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),6,1))*43+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),5,1))*47+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),4,1))*53+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),3,1))*59+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),2,1))*67+VALUE(MID(TEXT(Datos!E27,\"000000000000000\"),1,1))*71),11)","v":0}]