{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["importar","Datos Básicos","Formulario 350","Formulario 350 (H2)","Sanciones"],"not_rendered":{"images":8,"external_links":24,"defined_names":136},"read":"whole","date_system":"1900"}

{"sheet":"importar","index":0,"n_rows":1,"n_cols":8,"rows_kept":1}
["Renglon1","SumaDeBaseCredito","Renglon2","SumaDeRetencionCredito","Renglon3","BaseCredito2","Renglon4","RetencionCredito2"]

{"sheet":"Datos Básicos","index":1,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[1,1,1,4],[2,1,2,4],[7,1,7,2],[10,1,10,2],[12,1,12,2],[14,1,14,2],[16,1,16,2],[18,1,18,2],[20,1,20,2],[23,1,23,2],[25,1,25,2],[27,1,27,2]]}
[]
[null,"FORMULARIO 350\nAÑO GRAVABLE 2025"]
[null,"Nuevo formulario 350 para retenciones y autorretenciones en la fuente expedido por la Dian"]
[null,"D A T O S   B Á S I C O S"]
[]
[null,"D A T O S   D E L   D E C L A R A N T E "]
[]
[null,"Periodo",null,null,"Agosto"]
[]
[]
[null,"NIT o cédula"]
[]
[null,"Dígito de Verificación (DV)    ",null,null,{"$f":"IF((MOD((VALUE(MID(TEXT(E11,\"000000000000000\"),15,1))*3+VALUE(MID(TEXT(E11,\"000000000000000\"),14,1))*7+VALUE(MID(TEXT(E11,\"000000000000000\"),13,1))*13+VALUE(MID(TEXT(E11,\"000000000000000\"),12,1))*17+VALUE(MID(TEXT(E11,\"000000000000000\"),11,1))*19+VALUE(MID(TEXT(E11,\"000000000000000\"),10,1))*23+VALUE(MID(TEXT(E11,\"000000000000000\"),9,1))*29+VALUE(MID(TEXT(E11,\"000000000000000\"),8,1))*37+VALUE(MID(TEXT(E11,\"000000000000000\"),7,1))*41+VALUE(MID(TEXT(E11,\"000000000000000\"),6,1))*43+VALUE(MID(TEXT(E11,\"000000000000000\"),5,1))*47+VALUE(MID(TEXT(E11,\"000000000000000\"),4,1))*53+VALUE(MID(TEXT(E11,\"000000000000000\"),3,1))*59+VALUE(MID(TEXT(E11,\"000000000000000\"),2,1))*67+VALUE(MID(TEXT(E11,\"000000000000000\"),1,1))*71),11))=0,0,IF((MOD((VALUE(MID(TEXT(E11,\"000000000000000\"),15,1))*3+VALUE(MID(TEXT(E11,\"000000000000000\"),14,1))*7+VALUE(MID(TEXT(E11,\"000000000000000\"),13,1))*13+VALUE(MID(TEXT(E11,\"000000000000000\"),12,1))*17+VALUE(MID(TEXT(E11,\"000000000000000\"),11,1))*19+VALUE(MID(TEXT(E11,\"000000000000000\"),10,1))*23+VALUE(MID(TEXT(E11,\"000000000000000\"),9,1))*29+VALUE(MID(TEXT(E11,\"000000000000000\"),8,1))*37+VALUE(MID(TEXT(E11,\"000000000000000\"),7,1))*41+VALUE(MID(TEXT(E11,\"000000000000000\"),6,1))*43+VALUE(MID(TEXT(E11,\"000000000000000\"),5,1))*47+VALUE(MID(TEXT(E11,\"000000000000000\"),4,1))*53+VALUE(MID(TEXT(E11,\"000000000000000\"),3,1))*59+VALUE(MID(TEXT(E11,\"000000000000000\"),2,1))*67+VALUE(MID(TEXT(E11,\"000000000000000\"),1,1))*71),11))=1,1,11-(MOD((VALUE(MID(TEXT(E11,\"000000000000000\"),15,1))*3+VALUE(MID(TEXT(E11,\"000000000000000\"),14,1))*7+VALUE(MID(TEXT(E11,\"000000000000000\"),13,1))*13+VALUE(MID(TEXT(E11,\"000000000000000\"),12,1))*17+VALUE(MID(TEXT(E11,\"000000000000000\"),11,1))*19+VALUE(MID(TEXT(E11,\"000000000000000\"),10,1))*23+VALUE(MID(TEXT(E11,\"000000000000000\"),9,1))*29+VALUE(MID(TEXT(E11,\"000000000000000\"),8,1))*37+VALUE(MID(TEXT(E11,\"000000000000000\"),7,1))*41+VALUE(MID(TEXT(E11,\"000000000000000\"),6,1))*43+VALUE(MID(TEXT(E11,\"000000000000000\"),5,1))*47+VALUE(MID(TEXT(E11,\"000000000000000\"),4,1))*53+VALUE(MID(TEXT(E11,\"000000000000000\"),3,1))*59+VALUE(MID(TEXT(E11,\"000000000000000\"),2,1))*67+VALUE(MID(TEXT(E11,\"000000000000000\"),1,1))*71),11))))","v":0}]
[]
[null,"Primer apellido"]
[]
[null,"Segundo apellido"]
[]
[null,"Primer nombre"]
[]
[null,"Otros nombres"]
[]
[]
[null,"Razón social"]
[]
[null,"Código actividad económica"]
[]
[null,"Código dirección seccional"]

{"sheet":"Formulario 350","index":2,"n_rows":64,"n_cols":65,"rows_kept":64,"merged":[[1,11,3,41],[1,42,3,47],[1,48,3,54],[6,17,6,24],[7,2,7,24],[10,1,14,1],[11,2,12,15],[11,16,12,16],[11,17,12,25],[11,26,12,35],[11,36,12,44],[11,45,12,54],[13,51,13,54],[14,2,14,50],[14,51,14,52],[14,53,14,54],[15,1,15,7],[15,9,15,11],[15,12,15,13],[15,15,15,21],[15,22,15,27],[15,28,15,42],[15,43,15,48],[15,49,15,51],[15,52,15,54],[16,1,17,14],[16,15,16,34],[16,35,16,54],[17,15,17,24],[17,25,17,34],[17,35,17,44],[17,45,17,54],[18,1,18,14],[18,15,19,34],[18,36,18,44],[18,46,18,54],[19,1,19,14],[19,36,19,44],[19,46,19,54],[20,1,20,14],[20,16,20,24],[20,26,20,34],[20,36,20,44],[20,46,20,54],[21,1,21,14],[21,16,21,24],[21,26,21,34],[21,36,21,44],[21,46,21,54],[22,1,22,14],[22,16,22,24],[22,26,22,34],[22,36,22,44],[22,46,22,54],[23,1,23,14],[23,16,23,24],[23,26,23,34],[23,36,23,44],[23,46,23,54],[24,1,24,14],[24,16,24,24],[24,26,24,34],[24,36,24,44],[24,46,24,54],[25,1,25,14],[25,16,25,24],[25,26,25,34],[25,36,25,44],[25,46,25,54],[26,1,26,14],[26,16,26,24],[26,26,26,34],[26,36,26,44],[26,46,26,54],[27,1,27,14],[27,16,27,24],[27,26,27,34],[27,36,27,44],[27,46,27,54],[28,1,28,14],[28,16,28,24],[28,26,28,34],[28,36,28,44],[28,46,28,54],[29,1,29,14],[29,16,29,24],[29,26,29,34],[29,36,29,44],[29,46,29,54],[30,1,30,14],[30,15,30,34],[30,36,30,44],[30,46,30,54],[31,1,31,14],[31,16,31,24],[31,26,31,34],[31,36,31,44],[31,46,31,54],[32,1,32,14],[32,16,32,24],[32,26,32,34],[32,36,32,44],[32,46,32,54],[33,1,33,14],[33,16,33,24],[33,26,33,34],[33,36,33,44],[33,46,33,54],[34,1,35,1],[34,2,34,14],[34,16,34,24],[34,26,34,34],[34,36,34,44],[34,46,34,54],[35,2,35,14],[35,16,35,24],[35,26,35,34],[35,36,35,44],[35,46,35,54],[36,1,44,1],[36,2,36,14],[36,16,36,24],[36,26,36,34],[36,35,36,54],[37,2,37,14],[37,16,37,24],[37,26,37,34],[37,36,37,44],[37,46,37,54],[38,2,38,14],[38,16,38,24],[38,26,38,34],[38,36,38,44],[38,46,38,54],[39,2,39,14],[39,16,39,24],[39,26,39,34],[39,36,39,44],[39,46,39,54],[40,2,40,14],[40,16,40,24],[40,26,40,34],[40,36,40,44],[40,46,40,54],[41,2,41,14],[41,16,41,24],[41,26,41,34],[41,36,41,44],[41,46,41,54],[42,2,42,14],[42,16,42,24],[42,26,42,34],[42,36,42,44],[42,46,42,54],[43,2,43,14],[43,16,43,24],[43,26,43,34],[43,36,43,44],[43,46,43,54],[44,2,44,14],[44,16,44,24],[44,26,44,34],[44,36,44,44],[44,46,44,54],[45,1,45,44],[45,46,45,54],[46,1,46,44],[46,46,46,54],[47,1,47,54],[48,1,51,1],[48,2,48,44],[48,46,48,54],[49,2,49,44],[49,46,49,54],[50,2,50,44],[50,46,50,54],[51,2,51,44],[51,46,51,54],[52,1,52,44],[52,46,52,54],[53,1,55,1],[53,2,53,44],[53,46,53,54],[54,2,54,44],[54,46,54,54],[55,2,55,44],[55,46,55,54],[56,1,56,20],[56,21,56,54],[57,16,57,33],[58,16,58,33],[58,34,58,42],[58,44,58,53],[60,34,63,54],[62,16,62,33],[63,1,63,6],[63,9,63,14],[63,16,63,33]]}
[]
[{"$nulls":11},"Declaración Retenciones en la Fuente",{"$nulls":30},"Privada"]
[]
[]
[null,"1. Año",null,null,2,0,2,4,{"$nulls":12},"3. Período",null,null,{"$f":"IFERROR(MID(VLOOKUP('Datos Básicos'!E8,[24]Listas!F751:G762,2,FALSE),1,1),0)","v":"0"},{"$f":"IFERROR(MID(VLOOKUP('Datos Básicos'!E8,[24]Listas!F751:G762,2,FALSE),2,1),0)","v":"8"}]
[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":9},"9. Primer nombre",{"$nulls":8},"10. Otros nombres"]
[null,null,{"$f":"+'Datos Básicos'!E11","v":0},{"$nulls":13},{"$f":"+'Datos Básicos'!E13","v":0},{"$f":"+'Datos Básicos'!E15","v":0},{"$nulls":8},{"$f":"+'Datos Básicos'!E17","v":0},{"$nulls":9},{"$f":"+'Datos Básicos'!E19","v":0},{"$nulls":8},{"$f":"+'Datos Básicos'!E21","v":0}]
[]
[null,null,"11.  Razón Social",{"$nulls":48},"12. Cód. Dirección Seccional."]
[null,null,{"$f":"+'Datos Básicos'!E24","v":0},{"$nulls":48},{"$f":"+'Datos Básicos'!E28","v":0}]
[null,"Si es una corrección Indique:",{"$nulls":7},"25. Cód.",{"$nulls":5},"26. No. Formulario anterior",{"$nulls":12},"27. Autorretenedores personas jurídicas exonerados de aportes (Art. 114-1 E.T.). Actividad económica principal.",{"$nulls":14},{"$f":"+'Datos Básicos'!E26","v":{"v":0,"d":"0000"}},{"$nulls":5},"28.Tarifa",null,null,{"$f":"IFERROR(VLOOKUP(AR16,[24]Listas!F:H,3,0),\" \")","v":" "}]
[null,"Concepto",{"$nulls":13},"A personas jurídicas",{"$nulls":19},"A personas naturales"]
[{"$nulls":15},"Base sujeta a retención para pagos o abonos en cuenta",{"$nulls":9},"Retenciones a título de renta",{"$nulls":9},"Base sujeta a retención para pagos o abonos en cuenta",{"$nulls":9},"Retenciones a título de renta"]
[null,"Rentas de trabajo",{"$nulls":33},{"$f":"Z45+1","v":77},{"$f":"ROUND(IF(AJ19<>\"\",IFERROR(VLOOKUP(AJ19,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AJ34+1","v":93},{"$f":"ROUND(IF(AT19<>\"\",IFERROR(VLOOKUP(AT19,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Rentas de pensiones",{"$nulls":33},{"$f":"AJ19+1","v":78},{"$f":"ROUND(IF(AJ20<>\"\",IFERROR(VLOOKUP(AJ20,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AT19+1","v":94},{"$f":"ROUND(IF(AT20<>\"\",IFERROR(VLOOKUP(AT20,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Honorarios",{"$nulls":13},29,{"$f":"ROUND(IF(P21<>\"\",IFERROR(VLOOKUP(P21,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"P34+1","v":42},{"$f":"ROUND(IF(Z21<>\"\",IFERROR(VLOOKUP(Z21,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},79,{"$f":"ROUND(IF(AJ21<>\"\",IFERROR(VLOOKUP(AJ21,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},95,{"$f":"ROUND(IF(AT21<>\"\",IFERROR(VLOOKUP(AT21,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Comisiones",{"$nulls":13},{"$f":"P21+1","v":30},{"$f":"ROUND(IF(P22<>\"\",IFERROR(VLOOKUP(P22,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z21+1","v":43},{"$f":"ROUND(IF(Z22<>\"\",IFERROR(VLOOKUP(Z22,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},80,{"$f":"ROUND(IF(AJ22<>\"\",IFERROR(VLOOKUP(AJ22,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},96,{"$f":"ROUND(IF(AT22<>\"\",IFERROR(VLOOKUP(AT22,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Servicios",{"$nulls":13},31,{"$f":"ROUND(IF(P23<>\"\",IFERROR(VLOOKUP(P23,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},44,{"$f":"ROUND(IF(Z23<>\"\",IFERROR(VLOOKUP(Z23,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},81,{"$f":"ROUND(IF(AJ23<>\"\",IFERROR(VLOOKUP(AJ23,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},97,{"$f":"ROUND(IF(AT23<>\"\",IFERROR(VLOOKUP(AT23,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Rendimientos financieros e intereses",{"$nulls":13},32,{"$f":"ROUND(IF(P24<>\"\",IFERROR(VLOOKUP(P24,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},45,{"$f":"ROUND(IF(Z24<>\"\",IFERROR(VLOOKUP(Z24,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},82,{"$f":"ROUND(IF(AJ24<>\"\",IFERROR(VLOOKUP(AJ24,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},98,{"$f":"ROUND(IF(AT24<>\"\",IFERROR(VLOOKUP(AT24,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Arrendamientos (Muebles e inmuebles)",{"$nulls":13},33,{"$f":"ROUND(IF(P25<>\"\",IFERROR(VLOOKUP(P25,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},46,{"$f":"ROUND(IF(Z25<>\"\",IFERROR(VLOOKUP(Z25,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},83,{"$f":"ROUND(IF(AJ25<>\"\",IFERROR(VLOOKUP(AJ25,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},99,{"$f":"ROUND(IF(AT25<>\"\",IFERROR(VLOOKUP(AT25,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Regalias y explotación de la propiedad intelectual",{"$nulls":13},34,{"$f":"ROUND(IF(P26<>\"\",IFERROR(VLOOKUP(P26,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},47,{"$f":"ROUND(IF(Z26<>\"\",IFERROR(VLOOKUP(Z26,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},84,{"$f":"ROUND(IF(AJ26<>\"\",IFERROR(VLOOKUP(AJ26,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},100,{"$f":"ROUND(IF(AT26<>\"\",IFERROR(VLOOKUP(AT26,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Dividendos y participaciones",{"$nulls":13},35,{"$f":"ROUND(IF(P27<>\"\",IFERROR(VLOOKUP(P27,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},48,{"$f":"ROUND(IF(Z27<>\"\",IFERROR(VLOOKUP(Z27,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},85,{"$f":"ROUND(IF(AJ27<>\"\",IFERROR(VLOOKUP(AJ27,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},101,{"$f":"ROUND(IF(AT27<>\"\",IFERROR(VLOOKUP(AT27,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Compras",{"$nulls":13},36,{"$f":"ROUND(IF(P28<>\"\",IFERROR(VLOOKUP(P28,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},49,{"$f":"ROUND(IF(Z28<>\"\",IFERROR(VLOOKUP(Z28,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},86,{"$f":"ROUND(IF(AJ28<>\"\",IFERROR(VLOOKUP(AJ28,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},102,{"$f":"ROUND(IF(AT28<>\"\",IFERROR(VLOOKUP(AT28,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Transacciones con tarjetas débito y crédito",{"$nulls":13},37,{"$f":"ROUND(IF(P29<>\"\",IFERROR(VLOOKUP(P29,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},50,{"$f":"ROUND(IF(Z29<>\"\",IFERROR(VLOOKUP(Z29,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},87,{"$f":"ROUND(IF(AJ29<>\"\",IFERROR(VLOOKUP(AJ29,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},103,{"$f":"ROUND(IF(AT29<>\"\",IFERROR(VLOOKUP(AT29,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Contratos de construcción",{"$nulls":13},38,{"$f":"ROUND(IF(P30<>\"\",IFERROR(VLOOKUP(P30,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},51,{"$f":"ROUND(IF(Z30<>\"\",IFERROR(VLOOKUP(Z30,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},88,{"$f":"ROUND(IF(AJ30<>\"\",IFERROR(VLOOKUP(AJ30,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},104,{"$f":"ROUND(IF(AT30<>\"\",IFERROR(VLOOKUP(AT30,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Enajenación de activos fijos de personas naturales ante notarios y autoridades de tránsito",{"$nulls":33},89,{"$f":"ROUND(IF(AJ31<>\"\",IFERROR(VLOOKUP(AJ31,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},105,{"$f":"ROUND(IF(AT31<>\"\",IFERROR(VLOOKUP(AT31,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Loterías, rifas apuestas y similares",{"$nulls":13},{"$f":"P30+1","v":39},{"$f":"ROUND(IF(P32<>\"\",IFERROR(VLOOKUP(P32,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z30+1","v":52},{"$f":"ROUND(IF(Z32<>\"\",IFERROR(VLOOKUP(Z32,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},90,{"$f":"ROUND(IF(AJ32<>\"\",IFERROR(VLOOKUP(AJ32,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},106,{"$f":"ROUND(IF(AT32<>\"\",IFERROR(VLOOKUP(AT32,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Hidrocarburos, carbón y demás productos mineros",{"$nulls":13},{"$f":"P32+1","v":40},{"$f":"ROUND(IF(P33<>\"\",IFERROR(VLOOKUP(P33,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z32+1","v":53},{"$f":"ROUND(IF(Z33<>\"\",IFERROR(VLOOKUP(Z33,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},91,{"$f":"ROUND(IF(AJ33<>\"\",IFERROR(VLOOKUP(AJ33,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},107,{"$f":"ROUND(IF(AT33<>\"\",IFERROR(VLOOKUP(AT33,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Otros pagos sujetos a retención",{"$nulls":13},{"$f":"P33+1","v":41},{"$f":"ROUND(IF(P34<>\"\",IFERROR(VLOOKUP(P34,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z33+1","v":54},{"$f":"ROUND(IF(Z34<>\"\",IFERROR(VLOOKUP(Z34,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},92,{"$f":"ROUND(IF(AJ34<>\"\",IFERROR(VLOOKUP(AJ34,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},108,{"$f":"ROUND(IF(AT34<>\"\",IFERROR(VLOOKUP(AT34,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Pagos al exterior","Pagos o abonos en cuenta al exterior a países sin convenio",{"$nulls":12},{"$f":"Z34+1","v":55},{"$f":"ROUND(IF(P35<>\"\",IFERROR(VLOOKUP(P35,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"P36+1","v":57},{"$f":"ROUND(IF(Z35<>\"\",IFERROR(VLOOKUP(Z35,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AT34+1","v":109},{"$f":"ROUND(IF(AJ35<>\"\",IFERROR(VLOOKUP(AJ35,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AJ36+1","v":111},{"$f":"ROUND(IF(AT35<>\"\",IFERROR(VLOOKUP(AT35,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Pagos o abonos en cuenta al exterior a países con convenio vigente",{"$nulls":12},{"$f":"P35+1","v":56},{"$f":"ROUND(IF(P36<>\"\",IFERROR(VLOOKUP(P36,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z35+1","v":58},{"$f":"ROUND(IF(Z36<>\"\",IFERROR(VLOOKUP(Z36,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AJ35+1","v":110},{"$f":"ROUND(IF(AJ36<>\"\",IFERROR(VLOOKUP(AJ36,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AT35+1","v":112},{"$f":"ROUND(IF(AT36<>\"\",IFERROR(VLOOKUP(AT36,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Autorretenciones","Contribuyentes exonerados de aportes (art. 114 -1  E.T.)",{"$nulls":12},{"$f":"Z36+1","v":59},{"$f":"ROUND(IF(P37<>\"\",IFERROR(VLOOKUP(P37,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"P45+1","v":68},{"$f":"ROUND(IF(Z37<>\"\",IFERROR(VLOOKUP(Z37,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Ventas",{"$nulls":12},{"$f":"P37+1","v":60},{"$f":"ROUND(IF(P38<>\"\",IFERROR(VLOOKUP(P38,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"Z37+1","v":69},{"$f":"ROUND(IF(Z38<>\"\",IFERROR(VLOOKUP(Z38,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AT36+1","v":113},{"$f":"ROUND(IF(AJ38<>\"\",IFERROR(VLOOKUP(AJ38,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AJ45+1","v":121},{"$f":"ROUND(IF(AT38<>\"\",IFERROR(VLOOKUP(AT38,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Honorarios",{"$nulls":12},61,{"$f":"ROUND(IF(P39<>\"\",IFERROR(VLOOKUP(P39,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},70,{"$f":"ROUND(IF(Z39<>\"\",IFERROR(VLOOKUP(Z39,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AJ38+1","v":114},{"$f":"ROUND(IF(AJ39<>\"\",IFERROR(VLOOKUP(AJ39,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},{"$f":"AT38+1","v":122},{"$f":"ROUND(IF(AT39<>\"\",IFERROR(VLOOKUP(AT39,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Comisiones",{"$nulls":12},62,{"$f":"ROUND(IF(P40<>\"\",IFERROR(VLOOKUP(P40,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},71,{"$f":"ROUND(IF(Z40<>\"\",IFERROR(VLOOKUP(Z40,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},115,{"$f":"ROUND(IF(AJ40<>\"\",IFERROR(VLOOKUP(AJ40,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},123,{"$f":"ROUND(IF(AT40<>\"\",IFERROR(VLOOKUP(AT40,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Servicios",{"$nulls":12},63,{"$f":"ROUND(IF(P41<>\"\",IFERROR(VLOOKUP(P41,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},72,{"$f":"ROUND(IF(Z41<>\"\",IFERROR(VLOOKUP(Z41,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},116,{"$f":"ROUND(IF(AJ41<>\"\",IFERROR(VLOOKUP(AJ41,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},124,{"$f":"ROUND(IF(AT41<>\"\",IFERROR(VLOOKUP(AT41,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Rendimientos financieros",{"$nulls":12},64,{"$f":"ROUND(IF(P42<>\"\",IFERROR(VLOOKUP(P42,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},73,{"$f":"ROUND(IF(Z42<>\"\",IFERROR(VLOOKUP(Z42,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},117,{"$f":"ROUND(IF(AJ42<>\"\",IFERROR(VLOOKUP(AJ42,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},125,{"$f":"ROUND(IF(AT42<>\"\",IFERROR(VLOOKUP(AT42,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Pagos mensuales provisionales de carácter voluntario (hidrocarburos y demás productos mineros)",{"$nulls":12},65,{"$f":"ROUND(IF(P43<>\"\",IFERROR(VLOOKUP(P43,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},74,{"$f":"ROUND(IF(Z43<>\"\",IFERROR(VLOOKUP(Z43,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},118,{"$f":"ROUND(IF(AJ43<>\"\",IFERROR(VLOOKUP(AJ43,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},126,{"$f":"ROUND(IF(AT43<>\"\",IFERROR(VLOOKUP(AT43,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Exportación de hidrocarburos, carbón y demás productos mineros",{"$nulls":12},66,{"$f":"ROUND(IF(P44<>\"\",IFERROR(VLOOKUP(P44,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},75,{"$f":"ROUND(IF(Z44<>\"\",IFERROR(VLOOKUP(Z44,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},119,{"$f":"ROUND(IF(AJ44<>\"\",IFERROR(VLOOKUP(AJ44,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},127,{"$f":"ROUND(IF(AT44<>\"\",IFERROR(VLOOKUP(AT44,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,null,"Otros conceptos",{"$nulls":12},67,{"$f":"ROUND(IF(P45<>\"\",IFERROR(VLOOKUP(P45,importar!$A$2:'importar'!$B$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},76,{"$f":"ROUND(IF(Z45<>\"\",IFERROR(VLOOKUP(Z45,importar!$C$2:'importar'!$D$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},120,{"$f":"ROUND(IF(AJ45<>\"\",IFERROR(VLOOKUP(AJ45,importar!$E$2:'importar'!$F$100,2,FALSE),0),0),-3)","v":0},{"$nulls":8},128,{"$f":"ROUND(IF(AT45<>\"\",IFERROR(VLOOKUP(AT45,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas.",{"$nulls":43},129,{"$f":"ROUND(IF(AT46<>\"\",IFERROR(VLOOKUP(AT46,importar!$G$2:'importar'!$H$100,2,FALSE),0),0),-3)","v":0}]
[null,"Total retenciones renta y complementario",{"$nulls":43},130,{"$f":"ROUND(SUM(AA21:AI30,AA32:AI45,AU19:BC36,AU38:BC45)-AU46,-3)","v":0}]
[null,"Retenciones practicadas por otros impuestos"]
[null,"A título de IVA","A responsables del impuesto sobre las ventas",{"$nulls":42},{"$f":"AT47+1","v":131},0]
[null,null,"Practicadas por servicios a no residentes o no domiciliados",{"$nulls":42},{"$f":"AT49+1","v":132},0,{"$nulls":17},"                 "]
[null,null,"Menos retenciones practicadas en exceso o indebidas o por operaciones anuladas, rescindidas o resueltas",{"$nulls":42},133,0,{"$nulls":14},"                 "]
[null,null,"Total retenciones IVA",{"$nulls":42},134,{"$f":"ROUND(AU49+AU50-AU51,-3)","v":0},{"$nulls":17},"      "]
[null,"Retenciones impuesto de timbre nacional",{"$nulls":43},135,0]
[null,"Total","Total retenciones",{"$nulls":42},136,{"$f":"ROUND(AU47+AU52+AU53,-3)","v":0}]
[null,null,"Sanciones",{"$nulls":42},137,{"$f":"ROUND(IF(Sanciones!C4=\"SI\",Sanciones!C20,0)+IF(Sanciones!C5=\"SI\",Sanciones!C149,0),-3)","v":0}]
[null,null,"Total retenciones más sanciones",{"$nulls":42},138,{"$f":"ROUND(AU54+AU55,-3)","v":0}]
[null,"139. No. Identificación signatario",{"$nulls":19},"140. DV"]
[null,"981.Cód. Representación",{"$nulls":14},"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":17}," 980. Pago Total",{"$nulls":8},"$  ",{"$f":"+AU56","v":0}]
[]
[null,"982. Código Contador o Revisor Fiscal",{"$nulls":32},"996. Espacio para el número interno de la DIAN / Adhesivo"]
[null,"Firma Contador o Revisor Fiscal.              994. Con salvedades",{"$nulls":22}," "]
[{"$nulls":16},"Coloque el timbre de la máquina"]
[null,"983. No. Tarjeta profesional ",{"$nulls":14},"registradora al dorso de este formulario"]

{"sheet":"Formulario 350 (H2)","index":3,"n_rows":60,"n_cols":65,"rows_kept":60,"merged":[[1,11,3,41],[1,42,3,47],[1,48,3,54],[6,17,6,24],[7,2,7,24],[10,2,10,9],[10,10,10,13],[10,14,10,18],[10,19,10,27],[10,28,10,30],[10,31,10,42],[10,43,10,44],[10,45,10,54],[11,2,11,9],[11,10,11,13],[11,14,11,18],[11,19,11,27],[11,28,11,30],[11,31,11,42],[11,43,11,44],[11,45,11,54],[12,2,12,9],[12,10,12,13],[12,14,12,18],[12,19,12,27],[12,28,12,30],[12,31,12,42],[12,43,12,44],[12,45,12,54],[13,2,13,9],[13,10,13,13],[13,14,13,18],[13,19,13,27],[13,28,13,30],[13,31,13,42],[13,43,13,44],[13,45,13,54],[14,2,14,9],[14,10,14,13],[14,14,14,18],[14,19,14,27],[14,28,14,30],[14,31,14,42],[14,43,14,44],[14,45,14,54],[15,2,15,9],[15,10,15,13],[15,14,15,18],[15,19,15,27],[15,28,15,30],[15,31,15,42],[15,43,15,44],[15,45,15,54],[16,2,16,9],[16,10,16,13],[16,14,16,18],[16,19,16,27],[16,28,16,30],[16,31,16,42],[16,43,16,44],[16,45,16,54],[17,2,17,9],[17,10,17,13],[17,14,17,18],[17,19,17,27],[17,28,17,30],[17,31,17,42],[17,43,17,44],[17,45,17,54],[18,2,18,9],[18,10,18,13],[18,14,18,18],[18,19,18,27],[18,28,18,30],[18,31,18,42],[18,43,18,44],[18,45,18,54],[19,2,19,9],[19,10,19,13],[19,14,19,18],[19,19,19,27],[19,28,19,30],[19,31,19,42],[19,43,19,44],[19,45,19,54],[20,2,20,9],[20,10,20,13],[20,14,20,18],[20,19,20,27],[20,28,20,30],[20,31,20,42],[20,43,20,44],[20,45,20,54],[21,2,21,9],[21,10,21,13],[21,14,21,18],[21,19,21,27],[21,28,21,30],[21,31,21,42],[21,43,21,44],[21,45,21,54],[22,2,22,9],[22,10,22,13],[22,14,22,18],[22,19,22,27],[22,28,22,30],[22,31,22,42],[22,43,22,44],[22,45,22,54],[23,2,23,9],[23,10,23,13],[23,14,23,18],[23,19,23,27],[23,28,23,30],[23,31,23,42],[23,43,23,44],[23,45,23,54],[24,2,24,9],[24,10,24,13],[24,14,24,18],[24,19,24,27],[24,28,24,30],[24,31,24,42],[24,43,24,44],[24,45,24,54],[25,2,25,9],[25,10,25,13],[25,14,25,18],[25,19,25,27],[25,28,25,30],[25,31,25,42],[25,43,25,44],[25,45,25,54],[26,2,26,9],[26,10,26,13],[26,14,26,18],[26,19,26,27],[26,28,26,30],[26,31,26,42],[26,43,26,44],[26,45,26,54],[27,2,27,9],[27,10,27,13],[27,14,27,18],[27,19,27,27],[27,28,27,30],[27,31,27,42],[27,43,27,44],[27,45,27,54],[28,2,28,9],[28,10,28,13],[28,14,28,18],[28,19,28,27],[28,28,28,30],[28,31,28,42],[28,43,28,44],[28,45,28,54],[29,2,29,9],[29,10,29,13],[29,14,29,18],[29,19,29,27],[29,28,29,30],[29,31,29,42],[29,43,29,44],[29,45,29,54],[30,2,30,9],[30,10,30,13],[30,14,30,18],[30,19,30,27],[30,28,30,30],[30,31,30,42],[30,43,30,44],[30,45,30,54],[31,2,31,9],[31,10,31,13],[31,14,31,18],[31,19,31,27],[31,28,31,30],[31,31,31,42],[31,43,31,44],[31,45,31,54],[32,2,32,9],[32,10,32,13],[32,14,32,18],[32,19,32,27],[32,28,32,30],[32,31,32,42],[32,43,32,44],[32,45,32,54],[33,2,33,9],[33,10,33,13],[33,14,33,18],[33,19,33,27],[33,28,33,30],[33,31,33,42],[33,43,33,44],[33,45,33,54],[34,2,34,9],[34,10,34,13],[34,14,34,18],[34,19,34,27],[34,28,34,30],[34,31,34,42],[34,43,34,44],[34,45,34,54],[35,2,35,9],[35,10,35,13],[35,14,35,18],[35,19,35,27],[35,28,35,30],[35,31,35,42],[35,43,35,44],[35,45,35,54],[36,2,36,9],[36,10,36,13],[36,14,36,18],[36,19,36,27],[36,28,36,30],[36,31,36,42],[36,43,36,44],[36,45,36,54],[37,2,37,9],[37,10,37,13],[37,14,37,18],[37,19,37,27],[37,28,37,30],[37,31,37,42],[37,43,37,44],[37,45,37,54],[38,2,38,9],[38,10,38,13],[38,14,38,18],[38,19,38,27],[38,28,38,30],[38,31,38,42],[38,43,38,44],[38,45,38,54],[39,2,39,9],[39,10,39,13],[39,14,39,18],[39,19,39,27],[39,28,39,30],[39,31,39,42],[39,43,39,44],[39,45,39,54],[40,2,40,9],[40,10,40,13],[40,14,40,18],[40,19,40,27],[40,28,40,30],[40,31,40,42],[40,43,40,44],[40,45,40,54],[41,2,41,9],[41,10,41,13],[41,14,41,18],[41,19,41,27],[41,28,41,30],[41,31,41,42],[41,43,41,44],[41,45,41,54],[42,2,42,9],[42,10,42,13],[42,14,42,18],[42,19,42,27],[42,28,42,30],[42,31,42,42],[42,43,42,44],[42,45,42,54],[43,2,43,9],[43,10,43,13],[43,14,43,18],[43,19,43,27],[43,28,43,30],[43,31,43,42],[43,43,43,44],[43,45,43,54],[44,2,44,9],[44,10,44,13],[44,14,44,18],[44,19,44,27],[44,28,44,30],[44,31,44,42],[44,43,44,44],[44,45,44,54],[45,2,45,9],[45,10,45,13],[45,14,45,18],[45,19,45,27],[45,28,45,30],[45,31,45,42],[45,43,45,44],[45,45,45,54],[46,2,46,9],[46,10,46,13],[46,14,46,18],[46,19,46,27],[46,28,46,30],[46,31,46,42],[46,43,46,44],[46,45,46,54],[47,2,47,9],[47,10,47,13],[47,14,47,18],[47,19,47,27],[47,28,47,30],[47,31,47,42],[47,43,47,44],[47,45,47,54],[48,2,48,9],[48,10,48,13],[48,14,48,18],[48,19,48,27],[48,28,48,30],[48,31,48,42],[48,43,48,44],[48,45,48,54],[49,2,49,9],[49,10,49,13],[49,14,49,18],[49,19,49,27],[49,28,49,30],[49,31,49,42],[49,43,49,44],[49,45,49,54],[50,2,50,9],[50,10,50,13],[50,14,50,18],[50,19,50,27],[50,28,50,30],[50,31,50,42],[50,43,50,44],[50,45,50,54],[51,2,51,9],[51,10,51,13],[51,14,51,18],[51,19,51,27],[51,28,51,30],[51,31,51,42],[51,43,51,44],[51,45,51,54],[52,2,52,9],[52,10,52,13],[52,14,52,18],[52,19,52,27],[52,28,52,30],[52,31,52,42],[52,43,52,44],[52,45,52,54],[53,2,53,9],[53,10,53,13],[53,14,53,18],[53,19,53,27],[53,28,53,30],[53,31,53,42],[53,43,53,44],[53,45,53,54],[54,2,54,9],[54,10,54,13],[54,14,54,18],[54,19,54,27],[54,28,54,30],[54,31,54,42],[54,43,54,44],[54,45,54,54],[55,2,55,9],[55,10,55,13],[55,14,55,18],[55,19,55,27],[55,28,55,30],[55,31,55,42],[55,43,55,44],[55,45,55,54],[56,1,59,1],[56,2,56,27],[56,29,56,42],[56,44,56,54],[57,2,57,27],[57,29,57,42],[57,44,57,54],[58,2,58,27],[58,29,58,42],[58,44,58,54],[59,2,59,27],[59,29,59,42],[59,44,59,54]]}
[]
[{"$nulls":11},"Declaración Retenciones en la Fuente",{"$nulls":30},"Privada"]
[]
[]
[]
[null,"Espacio reservado para la DIAN",{"$nulls":25},"4. Número de Formulario"]
[]
[]
[]
[null,"Las celdas coloreadas de azul contienen fórmulas y NO son diligenciables"]
[null,null,"141. A países",{"$nulls":7},"142. Concepto de pago",{"$nulls":3},"143. Tipo de persona",{"$nulls":4},"144. País",{"$nulls":8},"Cód",null,null,"145. Pagos o abonos en cuenta",{"$nulls":11},"146.Tarifa (%)",null,"147. Valor retención"]
[null,1,"CON CONVENIO",{"$nulls":7},"32. Venta y/o servicios por Presencia Económica Significativa - PES",{"$nulls":3},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC12,[24]Listas!F503:G748,2,0),\"\")","v":"BULGARIA"},{"$nulls":8},111,null,null,0,{"$nulls":11},{"v":0,"d":"0%"},null,{"$f":"ROUND(AF12*AR12,-3)","v":0}]
[null,2,"SIN CONVENIO",{"$nulls":7},"15. Venta y/o servicios por Presencia Económica Significativa - PES",{"$nulls":3},"Personas naturales",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC13,[24]Listas!F504:G749,2,0),\"\")","v":"CHILE"},{"$nulls":8},211,null,null,0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,3,"SIN CONVENIO",{"$nulls":7},"15. Venta y/o servicios por Presencia Económica Significativa - PES",{"$nulls":3},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC14,[24]Listas!F505:G750,2,0),\"\")","v":"CIUDAD DEL VATICANO"},{"$nulls":8},159,null,null,0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,4,"CON CONVENIO",{"$nulls":7},"32. Venta y/o servicios por Presencia Económica Significativa - PES",{"$nulls":3},"Personas naturales",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC15,[24]Listas!F506:G751,2,0),\"\")","v":"GRECIA"},{"$nulls":8},301,null,null,0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,5,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC16,[24]Listas!F507:G752,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,6,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC17,[24]Listas!F508:G753,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,7,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC18,[24]Listas!F509:G754,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,8,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC19,[24]Listas!F510:G755,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,9,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC20,[24]Listas!F511:G756,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,10,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC21,[24]Listas!F512:G757,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,11,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC22,[24]Listas!F513:G758,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,12,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC23,[24]Listas!F514:G759,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,13,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC24,[24]Listas!F515:G760,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,14,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC25,[24]Listas!F516:G761,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,15,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC26,[24]Listas!F517:G762,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,16,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC27,[24]Listas!F518:G763,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,17,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC28,[24]Listas!F519:G764,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,18,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC29,[24]Listas!F520:G765,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,19,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC30,[24]Listas!F521:G766,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,20,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC31,[24]Listas!F522:G767,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,21,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC32,[24]Listas!F523:G768,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,22,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC33,[24]Listas!F524:G769,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,23,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC34,[24]Listas!F525:G770,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,24,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC35,[24]Listas!F526:G771,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,25,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC36,[24]Listas!F527:G772,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,26,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC37,[24]Listas!F528:G773,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,27,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC38,[24]Listas!F529:G774,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,28,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC39,[24]Listas!F530:G775,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,29,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC40,[24]Listas!F531:G776,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,30,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC41,[24]Listas!F532:G777,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,31,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC42,[24]Listas!F533:G778,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,32,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC43,[24]Listas!F534:G779,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,33,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC44,[24]Listas!F535:G780,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,34,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC45,[24]Listas!F536:G781,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,35,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC46,[24]Listas!F537:G782,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,36,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC47,[24]Listas!F538:G783,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,37,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC48,[24]Listas!F539:G784,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,38,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC49,[24]Listas!F540:G785,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,39,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC50,[24]Listas!F541:G786,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0,{"$nulls":18},"                 "]
[null,40,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC51,[24]Listas!F542:G787,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0,{"$nulls":15},"                 "]
[null,41,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC52,[24]Listas!F543:G788,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0,{"$nulls":18},"      "]
[null,42,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC53,[24]Listas!F544:G789,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,43,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC54,[24]Listas!F545:G790,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,44,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC55,[24]Listas!F546:G791,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,45,"CON CONVENIO",{"$nulls":11},"Personas jurídicas",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(AC56,[24]Listas!F547:G792,2,0),\"\")","v":""},{"$nulls":11},0,{"$nulls":11},{"v":0,"d":"0%"},null,0]
[null,"Total pagos al exterior","Sin convenio persona jurídica",{"$nulls":25},148,{"$f":"SUMIFS($AF$12:$AF$56,$C$12:$C$56,[24]Listas!B39,$O$12:$O$56,[24]Listas!A39)","v":0},{"$nulls":13},150,{"$f":"SUMIFS($AT$12:$AT$56,$C$12:$C$56,[24]Listas!B39,$O$12:$O$56,[24]Listas!A39)","v":0}]
[null,null,"Sin convenio persona natural",{"$nulls":25},149,{"$f":"SUMIFS($AF$12:$AF$56,$C$12:$C$56,[24]Listas!B39,$O$12:$O$56,[24]Listas!A40)","v":0},{"$nulls":13},151,{"$f":"SUMIFS($AT$12:$AT$56,$C$12:$C$56,[24]Listas!B39,$O$12:$O$56,[24]Listas!A40)","v":0}]
[null,null,"Con convenio persona jurídica",{"$nulls":25},152,{"$f":"SUMIFS($AF$12:$AF$56,$C$12:$C$56,[24]Listas!B40,$O$12:$O$56,[24]Listas!A39)","v":0},{"$nulls":13},154,{"$f":"SUMIFS($AT$12:$AT$56,$C$12:$C$56,[24]Listas!B40,$O$12:$O$56,[24]Listas!A39)","v":0}]
[null,null,"Con convenio persona natural",{"$nulls":25},153,{"$f":"SUMIFS($AF$12:$AF$56,$C$12:$C$56,[24]Listas!B40,$O$12:$O$56,[24]Listas!A40)","v":0},{"$nulls":13},155,{"$f":"SUMIFS($AT$12:$AT$56,$C$12:$C$56,[24]Listas!B40,$O$12:$O$56,[24]Listas!A40)","v":0}]

{"sheet":"Sanciones","index":4,"n_rows":19921,"n_cols":16384,"rows_kept":19921}
[null,"S A N C I O N E S",{"$nulls":618},"x","2025-01-25",{"$nulls":15761},"2021-09-10"]
[{"$nulls":3},{"$f":"IF(B508=1,\"<<Descargue la versión más actualizada de esta herramienta\",\"\")","v":"<<Descargue la versión más actualizada de esta herramienta"},{"$nulls":616},"x"]
[null,"Responder las siguientes preguntas:",{"$nulls":618},"x"]
[null,"¿ Calcula sanción por extemporaneidad?","NO",{"$nulls":617},"x"]
[null,"¿Calcula sanción por corrección?","NO"]
[null,"Liquidación de la sanción por extemporaneidad (Art. 641 y 642 del Estatuto tributario)"]
[]
[null,"Fecha en que venció la declaración","2024-08-12",{"$f":"IF(C8=\"\",\"Digite la información\",\"\")","v":""}]
[null,"Fecha en que va a presentar o presentó la declaración","2024-10-03",{"$f":"IF(C9=\"\",\"Digite la información\",\"\")","v":""}]
[null,"Existe Emplazamiento?","NO",{"$f":"IF(C10=\"\",\"Digite la información\",\"\")","v":""}]
[null,"Impuesto a cargo o retención objeto de la declaración",{"$f":"+'Formulario 350'!AU47","v":{"v":0,"d":"$ 0"}},{"$f":"IF(C11=\"\",\"Digite la información o digite cero\",\"\")","v":""}]
[null,"Ingresos brutos percibidos por el declarante en el período objeto de declaración",{"v":0,"d":"$ 0"},{"$f":"IF(C12=\"\",\"Digite la información o digite cero\",\"\")","v":""}]
[null,"Saldo a favor ",{"v":0,"d":"$ 0"},{"$f":"IF(C13=\"\",\"Digite la información o digite cero\",\"\")","v":""}]
[null,"Patrimonio líquido del año inmediatamente anterior al gravable",{"v":0,"d":"$ 0"},{"$f":"IF(C14=\"\",\"Digite la información o digite cero\",\"\")","v":""}]
[null,"Valor UVT",{"v":47065,"d":"$ 47,065"},{"$f":"IF(C15=\"\",\"Digite la información\",\"\")","v":""}]
[null,"Sanción mínima",{"v":471000,"d":"$ 471,000"},{"$f":"IF(C16=\"\",\"Digite la información\",\"\")","v":""}]
[null,"Mes y/o fracción de mes",{"$f":"IF(C9-C8>0,ROUNDUP((DAYS360(C8,C9))/30,0),0)","v":2}]
[null,"Sanción por extemporaneidad Subtotal",{"$f":"ROUND(C100,-3)","v":{"v":471000,"d":"$ 471,000"}}]
[null,"Aplicación de la reducción de la sanción según el artículo 640 del ET",{"v":0,"d":"0%"}]
[null,"Sanción por extemporaneidad liquidada",{"$f":"MAX(C101:C102)","v":{"v":471000,"d":"$ 471,000"}}]
[]
[null,"¿Aplica la reducción de la sanción según el artículo 93 Ley 2277 de 2022?"]
[null,null,{"$f":"+C16","v":{"v":471000,"d":"$ 471,000"}}]
[null,null,{"$f":"IF(C22=\"\",C20,C20*C22)","v":{"v":471000,"d":"$ 471,000"}}]
[]
[null,"Sanción por extemporaneidad liquidada con reducción art. 93 ley 2277 de 2022",{"$f":"MAX(C23:C24)","v":{"v":471000,"d":"$ 471,000"}},{"$f":"IF(C26=C16,\"Sanción mínima\",\"\")","v":"Sanción mínima"}]
[]
[]
[]
[]
[]
[]
[null,"CALCULOS "]
[]
[null,"Sación por  extemporaneidad "]
[null,"Impuesto a Cargo"]
[null,"SANCIÓN 5% ANTES DE EMPLAZAMIENTO",{"$f":"(C11*C108*C17)","v":0}]
[null,"SANCIÓN 10% DESPUES DE EMPLAZAMIENTO",{"$f":"(C11*C109*C17)","v":0}]
[null,"CALCULO SUBTOTAL",{"$f":"IF(C10=\"si\",C38,C37)","v":0}]
[null,"    LIMITE 100% IMPUESTO A CARGO",{"$f":"+C11","v":0}]
[null,"    LIMITE  200% IMPUESTO A CARGO",{"$f":"+C11*2","v":0}]
[null,"CALCULO SANCIÓN (SUBTOTAL)",{"$f":"IF(C10=\"si\",MIN(C39,C41),MIN(C39:C40))","v":0}]
[]
[null,"Por ingresos"]
[null,"SANCIÓN 0.5% ANTES DE EMPLAZAMIENTO",{"$f":"(C12*C110*C17)","v":0}]
[null,"SANCIÓN 1% DESPUES DE EMPLAZAMIENTO",{"$f":"(C12*C111*C17)","v":0}]
[]
[null,"   LIMITE 5% DE LOS INGRESOS ANTES DE EMPLAZAMIENTO",{"$f":"+C12*C114","v":0}]
[null,"   LIMITE UVT 2500 UVT ANTES DE EMPLAZAMIENTO",{"$f":"C116*C15","v":{"v":117662500,"d":"117,662,500"}}]
[null,"   DOBLE DEL SALDO A FAVOR ANTES DE EMPLAZAMIENTO",{"$f":"+C13*2","v":0}]
[null,"      MENOR ENTRE ESTOS TRES",{"$f":"IF(C50>0,MIN(C48:C50),MIN(C48:C49))","v":0}]
[]
[]
[null,"   LIMITE 10% DE LOS INGRESOS DESPUES DE EMPLAZAMIENTO",{"$f":"+C12*C115","v":0}]
[null,"   LIMITE UVT 5000 UVT DESPUES  DE EMPLAZAMIENTO",{"$f":"C117*C15","v":{"v":235325000,"d":"235,325,000"}}]
[null,"   CUATRO VECES  DEL SALDO A FAVOR DESPUES DE EMPLAZAMIENTO",{"$f":"+C13*4","v":0}]
[null,"      MENOR ENTRE ESTOS TRES",{"$f":"IF(C56>0,MIN(C54:C56),MIN(C54:C55))","v":0}]
[]
[]
[null,"CALCULO SANCIÓN (SUBTOTAL) ANTES DE  EMPLAZAMIENTO",{"$f":"IF(C10=\"no\",C45,0)","v":0}]
[null,"CALCULO SANCIÓN (ANTES DE  EMPLAZAMIENTO",{"$f":"IF(C60>C51,C51,C60)","v":0}]
[]
[null,"CALCULO SANCIÓN (SUBTOTAL) DESPUES DE EMPLAZAMIENTO",{"$f":"IF(C10=\"si\",C46,0)","v":0}]
[null,"CALCULO SANCIÓN DESPUES DE EMPLAZAMIENTO",{"$f":"IF(C63>C57,C57,C63)","v":0}]
[]
[null,"SANCIÓN A APLICAR SUBTOTAL POR INGRESOS",{"$f":"IF(C61>C64,C61,C64)","v":0}]
[]
[null,"Por patrimonio"]
[null,"SANCIÓN 1% ANTES DE EMPLAZAMIENTO",{"$f":"($C$14*C112*$C$17)","v":0}]
[null,"SANCIÓN 2% DESPUES DE EMPLAZAMIENTO",{"$f":"($C$14*C113*$C$17)","v":0}]
[]
[null,"   LIMITE 10% DEL PATRIMONIO ANTES DE EMPLAZAMIENTO",{"$f":"+C14*10%","v":0}]
[null,"   LIMITE UVT 2500 UVT ANTES DE EMPLAZAMIENTO",{"$f":"C116*C15","v":{"v":117662500,"d":"117,662,500"}}]
[null,"   DOBLE DEL SALDO A FAVOR ANTES DE EMPLAZAMIENTO",{"$f":"+C13*2","v":0}]
[null,"      MENOR ENTRE ESTOS TRES",{"$f":"IF(C74>0,MIN(C72:C74),MIN(C72:C73))","v":0}]
[]
[]
[null,"   LIMITE 20% DEL PATRIMONIO DESPUES DE EMPLAZAMIENTO",{"$f":"+C14*0.2","v":0}]
[null,"   LIMITE UVT 5000 UVT DESPUES  DE EMPLAZAMIENTO",{"$f":"C117*C15","v":{"v":235325000,"d":"235,325,000"}}]
[null,"   CUATRO VECES  DEL SALDO A FAVOR DESPUES DE EMPLAZAMIENTO",{"$f":"+C13*4","v":0}]
[null,"      MENOR ENTRE ESTOS TRES",{"$f":"IF(C80>0,MIN(C78:C80),MIN(C78:C79))","v":0}]
[]
[]
[null,"CALCULO SANCIÓN (SUBTOTAL) ANTES DE  EMPLAZAMIENTO",{"$f":"IF(C10=\"no\",C69,0)","v":0}]
[null,"CALCULO SANCIÓN (ANTES DE  EMPLAZAMIENTO",{"$f":"IF(C84>C75,C75,C84)","v":0}]
[]
[null,"CALCULO SANCIÓN (SUBTOTAL) DESPUES DE EMPLAZAMIENTO",{"$f":"IF(C10=\"si\",C70,0)","v":0}]
[null,"CALCULO SANCIÓN DESPUES DE EMPLAZAMIENTO",{"$f":"IF(C87>C81,C81,C87)","v":0}]
[]
[null,"SANCIÓN A APLICAR POR PATRIMONIO SUBTOTAL",{"$f":"IF(C85>C88,C85,C88)","v":0}]
[]
[]
[null,"RESUMEN DE SANCIONES"]
[null,"SANCIÓN MINIMA",{"$f":"+C16","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN POR IMPUESTO A CARGO",{"$f":"IF(C11>0,C42,0)","v":0}]
[null,"SANCIÓN POR INGRESOS",{"$f":"IF(C11=0,C66,0)","v":0}]
[null,"SANCIÓN POR PATRIMONIO",{"$f":"IF(AND(C11=0,AND(C12=0)),C90,0)","v":0}]
[null,"SANCION SUBTOTAL A APLICAR",{"$f":"MAX(C95:C97)","v":0}]
[null,"SANCION ANTES DE APLICACIÓN",{"$f":"IF(C98>C94,C98,C94)","v":{"v":471000,"d":"471,000"}}]
[null,"SANCION A APLICAR SEGÚN DILIGENCIAMIENTO DE FECHAS",{"$f":"IF(C17=0,0,C99)","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN MINIMA",{"$f":"+C16","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN REDUCIDA ART 640",{"$f":"IF(C19=0%,C100,C100*C19)","v":{"v":471000,"d":"471,000"}}]
[]
[]
[]
[null,"CIFRAS Y % CLACULOS SANCIÓN POR EXTEMPORANEIDAD"]
[null,"Sanción por extemporaneidad"]
[null,"     Tarifa por mes o fraccion de mes sin emplazamiento",{"v":0.05,"d":"5%"}]
[null,"     Tarifa por mes o fracción de mes con emplazamiento",{"v":0.1,"d":"10%"}]
[null,"     Tarifa de los ingresos antes de emplazamiento",{"v":0.005,"d":"0.5%"}]
[null,"     Tarifa de los ingresos despues de emplazamiento",{"v":0.01,"d":"1%"}]
[null,"     Tarifa por patrimonio antes de emplezamiento",{"v":0.01,"d":"1%"}]
[null,"     Tarifa por patrimonio despues de emplezamiento",{"v":0.02,"d":"2%"}]
[null,"     Limitante Ingresos antes de emplazamiento",{"v":0.05,"d":"5%"}]
[null,"     Limitante Ingresos despues de emplazamiento",{"v":0.1,"d":"10%"}]
[null,"     Limitante 2500 UVT antes de emplazamiento",{"v":2500,"d":"2,500"}]
[null,"     Limitante 5000 UVT despues de emplazamiento",{"v":5000,"d":"5,000"}]
[null,"     Tarifa limitante ",{"v":0.1,"d":"10%"}]
[null,"     Antes o despuesta de emplazamiento","SI"]
[null,"     Antes o despuesta de emplazamiento","NO"]
[null,"     Aplicación del artículo 640 del ET",{"v":0,"d":"0%"}]
[null,"     Aplicación del artículo 640 del ET",{"v":0.5,"d":"50%"}]
[null,"     Aplicación del artículo 640 del ET",{"v":0.75,"d":"75%"}]
{"$rows_empty":9}
[null,"Liquidación sanción por corrección (Art. 644 del Estatuto tributario)"]
[null,"(Aumento del valor a pagar o disminución del saldo a favor)",{"v":471000,"d":"$ 471,000"}]
[]
[]
[null,"Impuesto a pagar en la declaración inicial",{"v":0,"d":"$ 0"}]
[null,"Impuesto a pagar en la declaración de corrección",{"v":0,"d":"$ 0"}]
[null,"Saldo a favor en la declaración inicial",{"v":0,"d":"$ 0"}]
[null,"Saldo a favor en la declaración de corrección",{"v":0,"d":"$ 0"}]
[{"v":0.4,"d":"40%"},"¿La declaración se corrige después de la notificación de un emplazamiento para corregir o de auto que ordene inspección tributaria y antes que le notifiquen requerimiento especial o pliego de cargos?","NO"]
[{"v":0.2,"d":"20%"},"La declaración inicial se presentó de forma extemporánea?","NO"]
[{"v":0,"d":"0%"},"Fecha de presentación de la declaración inicial"]
[null,"Fecha de vencimiento legal del plazo para declarar de la declaración inicial"]
[null,"Mes y/o fracción de mes",{"$f":"IF(C143-C144>0,ROUNDUP((DAYS360(C144,C143))/30,0),0)","v":0}]
[null,"Sanción mínima",{"$f":"IF(AND(C139>1,C140>C139),0,C134)","v":{"v":471000,"d":"$ 471,000"}}]
[null,"Sanción por corrección Subtotal",{"$f":"ROUND(C173,-3)","v":{"v":471000,"d":"$ 471,000"}}]
[null,"Aplicación de la reducción de la sanción según el artículo 640 del ET",{"v":0,"d":"0%"}]
[null,"Sanción por corrección liquidada",{"$f":"MAX(C174:C175)","v":{"v":471000,"d":"$ 471,000"}}]
[]
[]
[]
[]
[]
[]
[null,"CALCULOS "]
[null,"SANCION POR CORRECCIÓN"]
[null,"DIFERENCIA DEL SALDO A PAGAR",{"$f":"IF(C137<C138,C138-C137+C139,0)","v":0}]
[null,"DIFERENCIA DEL SALDO A FAVOR",{"$f":"IF(C140<C139,C139-C140,0)","v":0}]
[null,"SANCIÓN POR CORRECCION  SALDO A PAGAR",{"$f":"IF(C141=\"NO\",C158*C180,C158*C181)","v":0}]
[null,"SANCIÓN POR CORRECIÓN SALDO A FAVOR",{"$f":"IF(C141=\"NO\",C159*C180,C159*C181)","v":0}]
[null,"SANCION A APLICAR SUBTOTAL",{"$f":"MAX(C160:C161)","v":0}]
[null,"SANCIÓN ADICIONAL CUANDO LA INICIAL ES EXTEMPORANEA SALDO A PAGAR",{"$f":"(C158*5%)*C145","v":0}]
[null,"SANCIÓN ADICIONAL  CUANDO LA INICIAL ES EXTEMPORANEA SALDO A FAVOR",{"$f":"(C159*5%)*C145","v":0}]
[null,"SANCION ADICIONAL A APLICAR SUBTOTAL",{"$f":"MAX(C163:C164)","v":0}]
[null,"SANCION INICIAL MAS ADICIONAL CUANDO INICIAL ES EXTEMPORANEA",{"$f":"IF(C142=\"SI\",(C162+C165),C162)","v":0}]
[null,"LIMITANTE 100% DEL MAYOR VALOR A PAGAR",{"$f":"+C158","v":0}]
[null,"LIMITANTE 100% DEL MENOR SALDO A FAVOR ",{"$f":"+C159","v":0}]
[null,"LIMITANTE SUBTOTAL",{"$f":"MAX(C167:C168)","v":0}]
[null,"SANCIÓN A APLICAR  ANTES DE MINIMA",{"$f":"IF(C166<C169,C166,C169)","v":0}]
[null,"SANCIÓN MINIMA",{"$f":"+C146","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN A DECLARAR",{"$f":"IF(C170<C171,C171,C170)","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN A DECLARAR",{"$f":"+C172","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN MINIMA",{"$f":"+C146","v":{"v":471000,"d":"471,000"}}]
[null,"SANCIÓN REDUCIDA ART 640",{"$f":"IF(C148=0%,C173,C173*C148)","v":{"v":471000,"d":"471,000"}}]
[]
[]
[null,"SANCIONES"]
[null,"Sanción por corrección"]
[null,"     Tarifa sanción por corrección",{"v":0.1,"d":"10%"}]
[null,"     Tarifa sanción por corrección despues de emplazamiento  para corregir o o auto de inspección  tributaria ",{"v":0.2,"d":"20%"}]
[null,"     Tarifa adicional cuando la declaracion inicial de presentó extemporaneamente",{"v":0.05,"d":"5%"}]
[null,"      LISTA","SI"]
[null,"      LISTA","NO"]
[null,"     Aplicación del artículo 640 del ET",{"v":0,"d":"0%"}]
[null,"     Aplicación del artículo 640 del ET",{"v":0.5,"d":"50%"}]
[null,"     Aplicación del artículo 640 del ET",{"v":0.75,"d":"75%"}]
{"$rows_empty":318}
[null,{"$f":"TODAY()","v":"2025-08-21"}]
[null,{"$f":"+WX1","v":"2025-01-25"}]
[null,{"$f":"IF(B506>B507,1,0)","v":1}]
{"$rows_empty":19412}
[{"$nulls":5},"x"]