{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DECLARACION-OTRO-CANTON","DECLARACION 1.5 ACT. TOTALES","CALCULO"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":"DECLARACION-OTRO-CANTON","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[23,0,23,7],[24,0,24,7],[16,0,16,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[22,0,22,7],[8,0,8,1],[9,0,9,1],[0,0,0,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[6,0,6,1],[6,2,6,8],[5,0,5,8],[7,7,7,8],[7,0,7,1],[8,7,8,8],[7,2,7,5],[8,2,8,5],[1,0,1,6],[13,0,15,8],[9,2,9,8],[10,7,10,8],[11,4,11,6],[21,0,21,7],[12,0,12,3],[12,4,12,6],[11,0,11,1],[10,0,10,1],[10,2,10,3],[25,7,33,8],[32,5,32,6],[31,5,31,6],[30,5,30,6],[30,1,30,3],[31,1,31,3],[32,1,32,3],[26,0,27,6],[33,0,33,6],[28,0,28,1],[25,0,25,6]]}
[]
["GOBIERNO AUTÓNOMO DESCENTRALIZADO MUNICIPAL DE\nSAN MIGUEL DE IBARRA",null,null,null,null,null,null,"NRO. FORMULARIO"]
["DIRECCIÓN DE GESTIÓN TRIBUTARIA"]
[]
["DECLARACIÓN DEL IMPUESTO A LA PATENTE MUNICIPAL \nPERSONAS OBLIGADAS A LLEVAR CONTABILIDAD\nOTROS CANTONES"]
[]
["NOMBRE O RAZON SOCIAL:"]
["RUC: ",null,null,null,null,null,"DIRECCIÓN:"]
["ACTIVIDAD ECONÓMICA:",null,null,null,null,null,"CORREO ELECTRONICO:"]
["NOMBRE DEL CONTADOR:"]
["RUC CONTADOR",null,null,null,"Nro. TELF:",null,"CORREO ELECTRÓNICO:"]
["AÑO: ",null,null,"FECHA DE DECLARACIÓN:",null,null,null,"INGRESOS TOTALES:",0]
["INGRESOS CANTON IBARRA:",null,null,null,0,null,null,"PORCENTAJE CANTON IBARRA:",{"$f":"IFERROR(E13/I12,\"-\")","v":"-"}]
["DETERMINACION TRIBUTARIA"]
[]
[]
["A)    TOTAL ACTIVO ",null,null,null,null,null,null,null,0]
["B)    (-) TOTAL PASIVO ",null,null,null,null,null,null,null,0]
["C)    PATRIMONIO BASE IMPONIBLE ",null,null,null,null,null,null,null,{"$f":"+I17-I18","v":0}]
["D)    PORCENTAJE DE INGRESOS IBARRA",null,null,null,null,null,null,null,{"$f":"+I13","v":"-"}]
["E)    BASE IMPONIBLE CANTON IBARRA (C*D)",null,null,null,null,null,null,null,{"$f":"IFERROR(+I19*I20,\"-\")","v":"-"}]
["F)    IMPUESTO A PAGAR (Aplicar Tabla)",null,null,null,null,null,null,null,{"$f":"IFERROR(CALCULO!B19,\"-\")","v":"-"}]
["G)    PAGO PREVIO",null,null,null,null,null,null,null,0]
["H)    INTERÉS EN MORA",null,null,null,null,null,null,null,0]
["I)     TOTAL A PAGAR",null,null,null,null,null,null,null,{"$f":"IFERROR(+I22-I23+I24,\"-\")","v":"-"}]
["Con pleno conocimiento de las penas por ocultamiento o falsedad, declaro que la información contenida en ésta declaración es verídica y correcta.",null,null,null,null,null,null,"\n\nRECIBIDA POR:"]
[]
[]
["REPRESENTANTE:",null,null,null,"CONTADOR:"]
[]
["FIRMA:",null,null,null,"FIRMA:"]
["NOMBRE:",null,null,null,"NOMBRE:"]
["CI:",null,null,null,"CI:"]

{"sheet":"DECLARACION 1.5 ACT. TOTALES","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,3,43,4],[44,3,44,4],[45,0,46,4],[47,0,48,7],[35,1,35,2],[35,3,35,4],[35,5,35,6],[36,0,36,3],[36,5,46,7],[37,0,37,4],[38,0,39,4],[40,0,40,1],[40,2,40,4],[42,3,42,4],[33,1,33,2],[33,3,33,4],[33,5,33,6],[34,1,34,2],[34,3,34,4],[34,5,34,6],[31,1,31,2],[31,3,31,4],[31,5,31,6],[32,1,32,2],[32,3,32,4],[32,5,32,6],[30,1,30,2],[30,3,30,4],[30,5,30,6],[21,1,21,6],[22,1,22,5],[23,1,23,6],[24,4,24,5],[25,1,25,6],[26,1,26,6],[27,1,27,5],[28,0,28,7],[29,1,29,2],[29,3,29,4],[29,5,29,6],[8,0,8,1],[8,2,8,7],[16,1,16,5],[17,1,17,5],[17,7,20,7],[18,1,18,5],[19,1,19,5],[20,1,20,5],[14,1,14,5],[9,0,9,1],[9,2,9,3],[9,5,9,7],[10,0,10,1],[10,2,10,7],[11,0,11,1],[11,2,11,7],[12,0,12,1],[12,6,12,7],[13,0,13,1],[13,3,13,4],[13,5,13,7],[2,0,2,7],[4,0,4,7],[5,0,5,7],[6,4,6,6],[1,0,1,5]]}
[]
["GOBIERNO AUTÓNOMO DESCENTRALIZADO MUNICIPAL DE\nSAN MIGUEL DE IBARRA",null,null,null,null,null,"NRO. FORMULARIO"]
["DIRECCIÓN DE GESTIÓN TRIBUTARIA"]
[]
["DECLARACION DEL IMPUESTO DEL 1.5 POR MIL AL TOTAL DE ACTIVOS"]
[]
[null,"ORIGINAL","SUSTITUTIVA",null,"No. De formulario que sustituye"]
[]
["RAZON SOCIAL:",null,{"$f":"'DECLARACION-OTRO-CANTON'!C7:I7","v":0}]
["RUC:                                                         ",null,{"$f":"'DECLARACION-OTRO-CANTON'!C8","v":0},null,"DIRECCIÓN:",{"$f":"'DECLARACION-OTRO-CANTON'!H8","v":0}]
["ACTIVIDAD ECONOMICA:                                                                                                                                                                      ",null,{"$f":"'DECLARACION-OTRO-CANTON'!C9:F9","v":0}]
["NOMBRE DEL CONTADOR:",null,{"$f":"'DECLARACION-OTRO-CANTON'!C10:I10","v":0}]
["RUC CONTADOR:                                                         ",null,{"$f":"'DECLARACION-OTRO-CANTON'!C11:D11","v":0},"NRO. TELEFONO:",{"$f":"'DECLARACION-OTRO-CANTON'!F11","v":0},"MAIL:",{"$f":"'DECLARACION-OTRO-CANTON'!H11","v":0}]
["AÑO:",null,2016,"TOTAL INGRESOS",null,{"$f":"'DECLARACION-OTRO-CANTON'!E13","v":0}]
["A)","Total de Activos",null,null,null,null,null,{"$f":"'DECLARACION-OTRO-CANTON'!I17","v":0}]
[]
["B)","Menos Deducciones",null,null,null,null,"(1 + 2 + 3 + 4)",{"$f":"SUM(G18:G21)","v":0}]
[null,"1.- Obligaciones hasta un año plazo",null,null,null,null,0]
[null,"2.- Pasivo contingente",null,null,null,null,0]
[null,"3.- Activos Relacionados actividad agropecuaria",null,null,null,null,0]
[null,"4.- Otras Deducciones",null,null,null,null,0]
["C)","Base del Impuesto al 1.5 por mil sobre los activos totales                                                             (A - B)",null,null,null,null,null,{"$f":"+H15-H17","v":0}]
["D)","Alícuota del Impuesto",null,null,null,null,null,1.5E-3]
["E)","Impuesto Causado                                                                                                                            (C x D)",null,null,null,null,null,{"$f":"+H22*H23","v":0}]
["F)","PAGO PREVIO  No. Comprobante:                           ",null,null,"Transferencia Nro."]
["G)","Intereses"]
["H)","Multas (3% del impuesto causado)"]
["I)","IMPUESTO A PAGAR ",null,null,null,null,"(E - F + G + H)",{"$f":"+H24-H25+H26+H27","v":0}]
["REPARTO PROPORCIONAL DEL IMPUESTO DEL 1.5 POR MIL SOBRE LOS ACTIVOS TOTALES"]
["%","CANTÓN ",null,"INGRESOS BRUTOS ANUALES",null,"BASE IMPONIBLE PORCENTUAL",null,"IMPUESTO CAUSADO PARA EL CANTÓN"]
[{"$f":"IFERROR(+D31/$D$36,\"-\")","v":"-"},null,null,0,null,{"$f":"IFERROR(+$H$22*A31,\"-\")","v":"-"},null,{"$f":"IFERROR(+$H$24*A31,\"-\")","v":"-"}]
[{"$f":"IFERROR(+D32/$D$36,\"-\")","v":"-"},null,null,0,null,{"$f":"IFERROR(+$H$22*A32,\"-\")","v":"-"},null,{"$f":"IFERROR(+$H$24*A32,\"-\")","v":"-"}]
[{"$f":"IFERROR(+D33/$D$36,\"-\")","v":"-"},null,null,null,null,{"$f":"IFERROR(+$H$22*A33,\"-\")","v":"-"},null,{"$f":"IFERROR(+$H$24*A33,\"-\")","v":"-"}]
[{"$f":"IFERROR(+D34/$D$36,\"-\")","v":"-"},null,null,null,null,{"$f":"IFERROR(+$H$22*A34,\"-\")","v":"-"},null,{"$f":"IFERROR(+$H$24*A34,\"-\")","v":"-"}]
[{"$f":"IFERROR(+D35/$D$36,\"-\")","v":"-"},null,null,null,null,{"$f":"IFERROR(+$H$22*A35,\"-\")","v":"-"},null,{"$f":"IFERROR(+$H$24*A35,\"-\")","v":"-"}]
[{"$f":"SUM(A31:A35)","v":0},null,null,{"$f":"SUM(D31:E35)","v":0},null,{"$f":"SUM(F31:G35)","v":0},null,{"$f":"SUM(H31:H35)","v":0}]
[null,null,null,null,null,"\nRECIBIDA POR:"]
["Con  pleno conocimiento de las penas por ocultamiento o falsedad, declaro que la información contenida en esta declaración es veridica y correcta."]
[]
[]
["REPRESENTANTE:",null,"CONTADOR:"]
[]
["FIRMA:",null,"FIRMA:"]
["NOMBRE:",{"$f":"'DECLARACION-OTRO-CANTON'!B32:D32","v":0},"NOMBRE:",{"$f":"'DECLARACION-OTRO-CANTON'!F32","v":0}]
["CI:",{"$f":"'DECLARACION-OTRO-CANTON'!B33:D33","v":0},"CI:",{"$f":"'DECLARACION-OTRO-CANTON'!F33","v":0}]

{"sheet":"CALCULO","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Tabla impositiva impuesto a la Patente Municipal"]
[]
["fracción básica","exceso hasta","impuesto fracción básica","impuesto fraccion excedente "]
[0,1000,20,0]
[1000.01,3000,30,1.6000000000000001E-3]
[3000.01,5000,40,2.3E-3]
[5000.01,10000,65,2.5999999999999999E-3]
[10000.01,20000,110,2.8E-3]
[20000.009999999998,40000,190,3.0000000000000001E-3]
[40000.01,70000,280,3.5999999999999999E-3]
[70000.009999999995,100000,350,4.0000000000000001E-3]
[100000.01,200000,610,4.1000000000000003E-3]
[200000.01,500000,1200,4.1999999999999997E-3]
[500000.01,1000000,1900,4.4000000000000003E-3]
[1000000.01,"en adelante",2200,4.4999999999999997E-3]
[]
[]
["PATRIMONIO",{"$f":"'DECLARACION-OTRO-CANTON'!I21","v":"-"}]
["IMP.PAGAR",{"$f":"IF(B18=0,\"\",INDIRECT(\"C\"&SUMPRODUCT(--(A4:A15<=B18),--(B4:B15>=B18),ROW(A4:A15))))+(B18-IF(B18=0,\"\",INDIRECT(\"A\"&SUMPRODUCT(--(A4:A15<=B18),--(B4:B15>=B18),ROW(A4:A15)))))*IF(B18=0,\"\",INDIRECT(\"D\"&SUMPRODUCT(--(A4:A15<=B18),--(B4:B15>=B18),ROW(A4:A15))))","v":{"$error":"#VALUE!"}}]