{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["TARIFAS IMPUESTO","Consolidado Impuesto","TARIFAS ANTICIPO","Consolidado anticipo","TARIFAS ICA","TARIFAS IMPUESTO (2)","Simulador","Grupo de actividades","T1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TARIFAS IMPUESTO","index":0,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":true,"merged":[[6,3,6,8],[35,3,40,8],[25,3,25,6],[42,3,42,6],[52,3,57,8],[59,9,60,9],[59,3,59,6],[8,7,9,7],[25,7,26,7],[42,7,43,7],[59,7,60,7],[8,3,8,6],[18,3,23,8],[59,8,60,8]]}
[]
[null,null,null,"REGIMEN SIMPLE DE TRIBUTACIÓN"]
[null,null,null,"TARIFAS"]
[]
[]
[]
[null,null,null,"1. Tiendas pequeñas, mini-mercados y micro-mercados y peluquerías"]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,{"$f":"IF(AND(#REF!>F12,#REF!<G12),H12,0)","v":{"$error":"#REF!"}},null,0,6000,{"$f":"+D11*$E$16","v":0},{"$f":"+E11*$E$16","v":205620000},0.02]
[null,{"$f":"IF(AND(#REF!>F13,#REF!<G13),H13,0)","v":{"$error":"#REF!"}},null,6000,15000,{"$f":"+D12*$E$16","v":205620000},{"$f":"+E12*$E$16","v":514050000},2.8000000000000001E-2]
[null,{"$f":"IF(AND(#REF!>F14,#REF!<G14),H14,0)","v":{"$error":"#REF!"}},null,15000,30000,514050000,1028100000,8.1000000000000003E-2]
[null,{"$f":"SUM(B11:B13)","v":{"$error":"#REF!"}},null,30000,80000,1028100000,2741600000,0.11600000000000001]
[]
[null,null,null,"UVT 2019",34270]
[]
[]
[null,null,null,"2. Actividades comerciales al por mayor y detal; servicios técnicos y mecánicos en los que predomina el factor material sobre el intelectual, los electricistas, los albañiles, los servicios de construcción y los talleres mecánicos de vehículos y electrodomésticos; actividades industriales, incluidas las de agro-industria, mini- industria y micro-industria; actividades de telecomunicaciones y las demás actividades no incluidas en los siguientes numerales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,6000,{"$f":"+D28*$E$33","v":0},{"$f":"+E28*$E$33","v":205620000},1.7999999999999999E-2]
[null,null,null,6000,15000,{"$f":"+D29*$E$33","v":205620000},{"$f":"+E29*$E$33","v":514050000},2.1999999999999999E-2]
[null,null,null,15000,30000,514050000,1028100000,3.9E-2]
[null,null,null,30000,80000,1028100000,2741600000,5.3999999999999999E-2]
[]
[null,null,null,"UVT 2019",{"$f":"+E16","v":34270}]
[]
[]
[null,null,null,"3. Servicios profesionales, de consultoría y científicos en los que predomine el factor intelectual sobre el material, incluidos los servicios de profesiones liberales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,6000,{"$f":"+D45*$E$33","v":0},{"$f":"+E45*$E$33","v":205620000},4.9000000000000002E-2]
[null,null,null,6000,15000,{"$f":"+D46*$E$33","v":205620000},{"$f":"+E46*$E$33","v":514050000},5.2999999999999999E-2,null," "]
[null,null,null,15000,30000,514050000,1028100000,7.0000000000000007E-2]
[null,null,null,30000,80000,1028100000,2741600000,8.5000000000000006E-2]
[]
[null,null,null,"UVT 2019",{"$f":"+E33","v":34270}]
[]
[]
[null,null,null,"4. Actividades de expendio de comidas y bebidas, y actividades de transporte."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada","Tarifa impuesto al consumo","Total tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,6000,{"$f":"+D62*$E$33","v":0},{"$f":"+E62*$E$33","v":205620000},3.4000000000000002E-2,0.08,{"$f":"+H62+I62","v":0.114},null,null,{"$f":"+E63/6","v":2500}]
[null,null,null,6000,15000,{"$f":"+D63*$E$33","v":205620000},{"$f":"+E63*$E$33","v":514050000},3.7999999999999999E-2,0.08,{"$f":"+H63+I63","v":0.11799999999999999},null,null,{"$f":"+E64/6","v":5000}]
[null,null,null,15000,30000,514050000,1028100000,5.5E-2,0.08,0.13500000000000001,null,null,13333.333333333334]
[null,null,null,30000,80000,1028100000,2741600000,7.0000000000000007E-2,0.08,0.15000000000000002,null,null,0]
[]
[null,null,null,"UVT 2019",{"$f":"+E50","v":34270}]

{"sheet":"Consolidado Impuesto","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,1,4,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[]
[]
[]
[]
[null,"Ingresos Brutos anuales",null,null,null,"Tarifa actividades 1","Tarifa actividades 2","Tarifa actividades 3","Tarifa actividades 4"]
[null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,0,6000,{"$f":"+B7*$E$12","v":0},205620000,0.02,1.7999999999999999E-2,4.9000000000000002E-2,3.4000000000000002E-2]
[null,6000,15000,205620000,514050000,2.8000000000000001E-2,2.1999999999999999E-2,5.2999999999999999E-2,3.7999999999999999E-2]
[null,15000,30000,514050000,1028100000,8.1000000000000003E-2,3.9E-2,7.0000000000000007E-2,5.5E-2]
[null,30000,80000,1028100000,2741600000,0.11600000000000001,5.3999999999999999E-2,8.5000000000000006E-2,7.0000000000000007E-2]
[]
[null,null,null,"UVT 2019",34270]

{"sheet":"TARIFAS ANTICIPO","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":true,"merged":[[6,3,6,8],[8,3,8,6],[8,7,9,7],[18,3,23,8],[25,3,25,6],[25,7,26,7],[59,9,60,9],[35,3,40,8],[42,3,42,6],[42,7,43,7],[52,3,57,8],[59,3,59,6],[59,7,60,7],[59,8,60,8]]}
[]
[null,null,null,"REGIMEN SIMPLE DE TRIBUTACIÓN"]
[null,null,null,"TARIFAS"]
[]
[]
[]
[null,null,null,"1. Tiendas pequeñas, mini-mercados y micro-mercados y peluquerías"]
[]
[null,null,null,"Ingresos Brutos Bimestrales",null,null,null,"Tarifa simple consolidada bimestral"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,{"$f":"IF(AND(#REF!>F12,#REF!<G12),H12,0)","v":{"$error":"#REF!"}},null,0,1000,{"$f":"+D11*$E$16","v":0},{"$f":"+E11*$E$16","v":34270000},0.02]
[null,{"$f":"IF(AND(#REF!>F13,#REF!<G13),H13,0)","v":{"$error":"#REF!"}},null,1000,2500,{"$f":"+D12*$E$16","v":34270000},85675000,2.8000000000000001E-2]
[null,{"$f":"IF(AND(#REF!>F14,#REF!<G14),H14,0)","v":{"$error":"#REF!"}},null,2500,5000,85675000,171350000,8.1000000000000003E-2]
[null,{"$f":"SUM(B11:B13)","v":{"$error":"#REF!"}},null,5000,13334,171350000,456956180,0.11600000000000001]
[]
[null,null,null,"UVT 2019",34270]
[]
[]
[null,null,null,"2. Actividades comerciales al por mayor y detal; servicios técnicos y mecánicos en los que predomina el factor material sobre el intelectual, los electricistas, los albañiles, los servicios de construcción y los talleres mecánicos de vehículos y electrodomésticos; actividades industriales, incluidas las de agro-industria, mini- industria y micro-industria; actividades de telecomunicaciones y las demás actividades no incluidas en los siguientes numerales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,1000,{"$f":"+D28*$E$33","v":0},{"$f":"+E28*$E$33","v":34270000},1.7999999999999999E-2]
[null,null,null,1000,2500,{"$f":"+D29*$E$33","v":34270000},85675000,2.1999999999999999E-2]
[null,null,null,2500,5000,85675000,171350000,3.9E-2]
[null,null,null,5000,13334,171350000,456956180,5.3999999999999999E-2]
[]
[null,null,null,"UVT 2019",{"$f":"+E16","v":34270}]
[]
[]
[null,null,null,"3. Servicios profesionales, de consultoría y científicos en los que predomine el factor intelectual sobre el material, incluidos los servicios de profesiones liberales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,1000,{"$f":"+D45*$E$33","v":0},{"$f":"+E45*$E$33","v":34270000},4.9000000000000002E-2]
[null,null,null,1000,2500,{"$f":"+D46*$E$33","v":34270000},85675000,5.2999999999999999E-2]
[null,null,null,2500,5000,85675000,171350000,7.0000000000000007E-2]
[null,null,null,5000,13334,171350000,456956180,8.5000000000000006E-2]
[]
[null,null,null,"UVT 2019",{"$f":"+E33","v":34270}]
[]
[]
[null,null,null,"4. Actividades de expendio de comidas y bebidas, y actividades de transporte."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ingresos Brutos anuales",null,null,null,"Tarifa simple consolidada","Tarifa impuesto al consumo","Total tarifa simple consolidada"]
[null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,null,0,1000,{"$f":"+D62*$E$33","v":0},{"$f":"+E62*$E$33","v":34270000},3.4000000000000002E-2,0.08,{"$f":"+H62+I62","v":0.114}]
[null,null,null,1000,2500,{"$f":"+D63*$E$33","v":34270000},85675000,3.7999999999999999E-2,0.08,{"$f":"+H63+I63","v":0.11799999999999999}]
[null,null,null,2500,5000,85675000,171350000,5.5E-2,0.08,0.13500000000000001]
[null,null,null,5000,13334,171350000,456956180,7.0000000000000007E-2,0.08,0.15000000000000002]
[]
[null,null,null,"UVT 2019",{"$f":"+E50","v":34270}]

{"sheet":"Consolidado anticipo","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,1,4,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[]
[]
[]
[]
[null,"Ingresos Brutos bimestrales",null,null,null,"Tarifa actividades 1","Tarifa actividades 2","Tarifa actividades 3","Tarifa actividades 4"]
[null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,0,1000,{"$f":"+B7*$E$12","v":0},34270000,0.02,1.7999999999999999E-2,4.9000000000000002E-2,3.4000000000000002E-2]
[null,1000,2500,34270000,85675000,2.8000000000000001E-2,2.1999999999999999E-2,5.2999999999999999E-2,3.7999999999999999E-2]
[null,2500,5000,85675000,171350000,8.1000000000000003E-2,3.9E-2,7.0000000000000007E-2,5.5E-2]
[null,5000,13334,171350000,456956180,0.11600000000000001,5.3999999999999999E-2,8.5000000000000006E-2,7.0000000000000007E-2]
[]
[null,null,null,"UVT 2019",34270]

{"sheet":"TARIFAS ICA","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"BOGOTÁ"]
[null,null,"Tarifa por Mil"]
[null,null,4.1399999999999997]
[null,null,6.9]
[null,null,9.66]
[null,null,11.04]
[null,null,13.8]

{"sheet":"TARIFAS IMPUESTO (2)","index":5,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":true,"merged":[[63,2,63,5],[6,2,11,14],[13,2,13,5],[14,17,15,17],[14,18,15,18],[30,2,35,14],[37,2,37,5],[56,2,61,14]]}
[]
[null,null,"REGIMEN SIMPLE DE TRIBUTACIÓN"]
[null,null,"TARIFAS"]
[]
[]
[]
[null,null,"1. Actividades comerciales al por mayor y detal, incluidas las tiendas de barrio, mini-mercados y micro-mercados; servicios técnicos y mecánicos en los que predomina el factor material sobre el intelectual, incluidos las peluquerías, los electricistas, los albañiles, los servicios de construcción y los talleres mecánicos de vehículos y electrodomésticos; actividades industriales, incluidas las de agro-industria, mini-industria y micro-industria; y las demás actividades no incluidas en los siguientes numerales: "]
[]
[]
[]
[]
[]
[]
[null,null,"INGRESOS BRUTOS ANUALES"]
[null,null,"IGUAL O SUPERIOR","INFERIOR","IGUAL O SUPERIOR","INFERIOR","TARIFA",null,null,null,null,null,null,null,null,null,null,"Servicios profesinales","Restaurantes, bar"]
[null,{"$f":"IF(AND($K$16>E17,$K$16<F17),G17,0)","v":0},"UVT","UVT","$","$","%",null,"INGRESOS",null,500000000,"Margen neto",null,0.1]
[null,{"$f":"IF(AND($K$16>E18,$K$16<F18),G18,0)","v":0},1400,6000,{"$f":"+C17*$D$22","v":46418400},{"$f":"+D17*$D$22","v":198936000},2.5999999999999999E-2,null,"RENTA LIQUIDA",null,{"$f":"+K16*N16","v":50000000},"Margen real",null,{"$f":"+K17/K16","v":0.1},null,null,null,5.6000000000000001E-2,0.111]
[null,{"$f":"IF(AND($K$16>E19,$K$16<F19),G19,0)","v":4.1000000000000002E-2},6000,15000,{"$f":"+C18*$D$22","v":198936000},497340000,3.1E-2,null,"IMPUESTO RENTA",0.33,{"$f":"+K17*J18","v":16500000},null,null,null,null,null,null,6.6000000000000003E-2,0.11600000000000001]
[null,{"$f":"IF(AND($K$16>E20,$K$16<F20),G20,0)","v":0},15000,30000,497340000,994680000,4.1000000000000002E-2,null,"ICA + AVISOS Y T",0.01,{"$f":"+K16*J19","v":5000000},null,null,null,null,null,null,7.5999999999999998E-2,0.121]
[null,{"$f":"SUM(B16:B19)","v":4.1000000000000002E-2},30000,80000,994680000,2652480000,5.6000000000000001E-2,null,"IPOCONSUMO",0,{"$f":"+K16*J20","v":0},null,null,null,null,null,null,9.6000000000000002E-2,0.13600000000000001]
[null,null,null,null,null,null,null,null,"TOTAL IMPUESTO",null,{"$f":"+K18+K19+K20","v":21500000}]
[null,null,"UVT 2019",33156]
[]
[]
[null,null,null,null,null,null,null,null,"IMPUESTO SIMPLE",{"$f":"+B20","v":4.1000000000000002E-2},{"$f":"+K16*J25","v":20500000},{"$f":"IF(K20>0,\"Modificque la tarifa de acuerdo a la tabla\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Diferencia",null,{"$f":"+K25-K21","v":-1000000}]
[]
[]
[]
[null,null,"2. Servicios profesionales, de consultoría y científicos en los que predomine el factor intelectual sobre el material, incluidos los servicios de profesiones liberales:"]
[]
[]
[]
[]
[]
[]
[null,null,"INGRESOS BRUTOS ANUALES"]
[null,null,"IGUAL O SUPERIOR","INFERIOR","IGUAL O SUPERIOR","INFERIOR","TARIFA"]
[null,null,"UVT","UVT","$","$","%"]
[null,null,1400,6000,{"$f":"+C41*$D$22","v":46418400},{"$f":"+D41*$D$22","v":198936000},5.6000000000000001E-2]
[null,null,6000,15000,{"$f":"+C42*$D$22","v":198936000},497340000,6.6000000000000003E-2]
[null,null,15000,30000,497340000,994680000,7.5999999999999998E-2]
[null,null,30000,80000,994680000,2652480000,9.6000000000000002E-2]
[]
[null,null,"UVT 2019",34270]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3. Servicio de restaurante, incluidos los servicios de cafetería, bar y “catering”:"]
[]
[]
[]
[]
[]
[]
[null,null,"INGRESOS BRUTOS ANUALES"]
[null,null,"IGUAL O SUPERIOR","INFERIOR","IGUAL O SUPERIOR","INFERIOR","TARIFA"]
[null,null,"UVT","UVT","$","$","%"]
[null,null,1400,6000,{"$f":"+C67*$D$22","v":46418400},{"$f":"+D67*$D$22","v":198936000},0.111]
[null,null,6000,15000,{"$f":"+C68*$D$22","v":198936000},497340000,0.11600000000000001]
[null,null,15000,30000,497340000,994680000,0.121]
[null,null,30000,80000,994680000,2652480000,0.13600000000000001]
[]
[null,null,"UVT 2019",34270]

{"sheet":"Simulador","index":6,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[44,3,44,5],[1,4,4,8],[18,3,22,8],[13,14,13,15],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,1,25,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9]]}
[]
[null,null,null,null,"SIMULADOR IMPUESTO UNIFICADO BAJO EL RÉGIMEN SIMPLE DE TRIBUTACIÓN - SIMPLE"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Categoria","T1",null,"Impuesto renta",0.33,{"$f":"+E12*H9","v":990000}]
[null,null,null,"Ingresos anuales",30000000,null,"ICA (x mil)",9.66,{"$f":"+E10*H10/1000","v":289800}]
[null,null,null,"Margen  %",0.1,null,"Avisos y tableros",0.15,{"$f":"+I10*H11","v":43470}]
[null,null,null,"Renta líquida",{"$f":"+E10*E11","v":3000000},null,"TOTAL IMPUESTO REGIMEN ORDINARIO",null,{"$f":"SUM(I9:I11)","v":1323270}]
[null,null,null,"Margen utilizado",{"$f":"IFERROR(+E12/E10,0)","v":0.1},null,null,null,null,null,null,null,null,null,"Diferencia",{"$f":"+I17-I12","v":-723270}]
[null,null,null,"Valor UVT",34270,null,"Impuesto Simple ",{"$f":"VLOOKUP(E9,D37:E40,2,0)","v":0.02},{"$f":"+E10*H14","v":600000},null,null,null,null,null,{"$f":"IF(P13<0,\"Es conveniente\",\"No es conveniente\")","v":"Es conveniente"}]
[null,null,null,null,null,null,"Descuento tributario Ap. Pensión",null,{"$f":"IF(E10>E31,0,-F47)","v":0}]
[null,null,null,null,null,null,"Descuento tributario TC, TD ..",null,{"$f":"IF(E10>E31,0,-F50)","v":0}]
[null,null,null,null,null,null,"Total impuesto SIMPLE",null,{"$f":"IF((I14+I15+I16)<0,0,(I14+I15+I16))","v":600000}]
[]
[null,null,null,{"$f":"VLOOKUP(E9,'Grupo de actividades'!$D$37:$E$40,2,0)","v":"1. Tiendas pequeñas, mini-mercados y micro-mercados y peluquerías"}]
[]
[]
[]
[]
[]
[]
[null,"Ingresos Brutos anuales",null,null,null,"Tarifa actividades 1","Tarifa actividades 2","Tarifa actividades 3","Tarifa actividades 4","T1","T2","T3","T4"]
[null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,0,6000,{"$f":"+B28*$E$33","v":0},205620000,0.02,1.7999999999999999E-2,4.9000000000000002E-2,3.4000000000000002E-2,{"$f":"IF(AND($E$10>=D28,$E$10<E28),F28,0)","v":0.02},{"$f":"IF(AND($E$10>=D28,$E$10<E28),G28,0)","v":1.7999999999999999E-2},{"$f":"IF(AND($E$10>=D28,$E$10<E28),H28,0)","v":4.9000000000000002E-2},{"$f":"IF(AND($E$10>=D28,$E$10<E28),I28,0)","v":3.4000000000000002E-2}]
[null,6000,15000,205620000,514050000,2.8000000000000001E-2,2.1999999999999999E-2,5.2999999999999999E-2,3.7999999999999999E-2,{"$f":"IF(AND($E$10>=D29,$E$10<E29),F29,0)","v":0},{"$f":"IF(AND($E$10>=D29,$E$10<E29),G29,0)","v":0},{"$f":"IF(AND($E$10>=D29,$E$10<E29),H29,0)","v":0},{"$f":"IF(AND($E$10>=D29,$E$10<E29),I29,0)","v":0}]
[null,15000,30000,514050000,1028100000,8.1000000000000003E-2,3.9E-2,7.0000000000000007E-2,5.5E-2,0,0,0,0]
[null,30000,80000,1028100000,2741600000,0.11600000000000001,5.3999999999999999E-2,8.5000000000000006E-2,7.0000000000000007E-2,0,0,0,0]
[null,null,null,null,null,{"$f":"+J32","v":0.02},{"$f":"+K32","v":1.7999999999999999E-2},{"$f":"+L32","v":4.9000000000000002E-2},{"$f":"+M32","v":3.4000000000000002E-2},{"$f":"SUM(J28:J31)","v":0.02},{"$f":"SUM(K28:K31)","v":1.7999999999999999E-2},4.9000000000000002E-2,3.4000000000000002E-2]
[null,null,null,"UVT 2019",34270]
[]
[]
[]
[null,null,null,"T1",{"$f":"+J32","v":0.02}]
[null,null,null,"T2",{"$f":"+K32","v":1.7999999999999999E-2}]
[null,null,null,"T3",{"$f":"+L32","v":4.9000000000000002E-2}]
[null,null,null,"T4",{"$f":"+M32","v":3.4000000000000002E-2}]
[]
[]
[]
[]
[null,null,null,"Descuentos tributarios"]
[null,null,null,"Pago de salarios"]
[null,null,null,"Aporte pensión por parte del empleador",null,{"$f":"+F46*12%","v":0},null,"Diseño: William Dussán Salazar"]
[null,null,null,null,null,null,null,"www.consultorcontable.com"]
[null,null,null,"Ingresos recaudados por medios electrónicos"]
[null,null,null,"Descuento tributario 0.5% del ingreso",null,{"$f":"+F49*0.5/100","v":0}]

{"sheet":"Grupo de actividades","index":7,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[18,3,23,8],[25,3,30,8],[9,3,9,8],[11,3,16,8]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"REGIMEN SIMPLE DE TRIBUTACIÓN"]
[null,null,null,null,null,null,"Grupo de Actividades"]
[]
[]
[]
[null,null,null,"1. Tiendas pequeñas, mini-mercados y micro-mercados y peluquerías"]
[]
[null,null,null,"2. Actividades comerciales al por mayor y detal; servicios técnicos y mecánicos en los que predomina el factor material sobre el intelectual, los electricistas, los albañiles, los servicios de construcción y los talleres mecánicos de vehículos y electrodomésticos; actividades industriales, incluidas las de agro-industria, mini- industria y micro-industria; actividades de telecomunicaciones y las demás actividades no incluidas en los siguientes numerales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"3. Servicios profesionales, de consultoría y científicos en los que predomine el factor intelectual sobre el material, incluidos los servicios de profesiones liberales:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"4. Actividades de expendio de comidas y bebidas, y actividades de transporte."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"T1","1. Tiendas pequeñas, mini-mercados y micro-mercados y peluquerías"]
[null,null,null,"T2","2. Actividades comerciales al por mayor y detal; servicios técnicos y mecánicos en los que predomina el factor material sobre el intelectual, los electricistas, los albañiles, los servicios de construcción y los talleres mecánicos de vehículos y electrodomésticos; actividades industriales, incluidas las de agro-industria, mini- industria y micro-industria; actividades de telecomunicaciones y las demás actividades no incluidas en los siguientes numerales:"]
[null,null,null,"T3","3. Servicios profesionales, de consultoría y científicos en los que predomine el factor intelectual "]
[null,null,null,"T4","4. Actividades de expendio de comidas y bebidas, y actividades de transporte."]

{"sheet":"T1","index":8,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,11,1,12]]}
[null,null,"ANALISIS IVA EN TIENDAS, MICRO MERCADOS, MINI MERCADOS"]
[null,null,null,null,null,null,null,null,null,"Ingresos Brutos anuales",null,"Ingresos Brutos anuales",null,"Tarifa actividades 1"]
[null,null,"Compra",null,100000,null,null,null,null,"Igual o superior (UVT)","Inferior (UVT)","Igual o superior ($)","Inferior ($)"]
[null,null,"Iva",null,{"$f":"+E3*0.19","v":19000},null,null,null,null,0,6000,0,205620000,0.02]
[null,null,"Total",null,{"$f":"+E3+E4","v":119000},null,null,null,null,6000,15000,205620000,514050000,2.8000000000000001E-2]
[null,null,null,null,null,null,null,null,null,15000,30000,514050000,1028100000,8.1000000000000003E-2]
[null,null,"Utilidad",0.1,{"$f":"+E3*D7","v":10000},null,null,null,null,30000,80000,1028100000,2741600000,0.11600000000000001]
[]
[null,null,"Precio venta",null,{"$f":"+E3+E7","v":110000}]
[null,null,"Iva",null,{"$f":"+E9*0.19","v":20900}]
[null,null,"Total consumidor",null,{"$f":"+E9+E10","v":130900}]
[]
[]
[null,null,"Iva a pagar a DIAN",null,{"$f":"+E10-E4","v":1900}]
[]
[]
[null,null,"EN SIMPLE"]
[]
[null,null,"Ingresos producto de venta",null,{"$f":"+E11","v":130900}]
[]
[null,null,"Utilidad",null,{"$f":"+E11-E5","v":11900}]
[]
[null,null,"Mayor dinero ",null,{"$f":"+E21-E7","v":1900}]
[]
[null,null,"Mayor margen",null,{"$f":"+E23/E19","v":1.4514896867838044E-2}]