{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Menú","ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC","TARIFA 2020"],"not_rendered":{"images":1,"macros":1,"external_links":2,"defined_names":111,"comments":12},"read":"whole","date_system":"1900"}

{"sheet":"Menú","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,0,0,1],[0,3,0,9],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["DETERMIANCION PAGOS PROVISIONALES ISR E IVA PERSONA FISICA POR ARRENDAMIENTO 2020",null,null,"DETERMIANCION PAGOS PROVISIONALES ISR E IVA PERSONA FISICA POR ARRENDAMIENTO 2020"]
["CAFICON"]
["Enero"]
["Febrero"]
["Marzo"]
["Abril"]
["Mayo"]
["Junio"]
["Julio"]
["Agosto"]
["Septiembre"]
["Octubre"]
["Noviembre"]
["Diciembre"]

{"sheet":"ENE","index":1,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,"NOMBRE CONTRIBUYENTE"]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. ENERO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"H6*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"H7*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL ENERO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO ENERO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. ENERO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"FEB","index":2,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. FEBRERO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL FEBRERO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO FEBRERO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. FEBRERO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"MAR","index":3,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. MARZO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL MARZO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO MARZO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. MARZO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"ABR","index":4,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. ABRIL 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL ABRIL",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO ABRIL 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. ABRIL 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"MAY","index":5,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. MAYO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL MAYO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO MAYO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. MAYO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"JUN","index":6,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. JUNIO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL JUNIO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO JUNIO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. JUNIO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"JUL","index":7,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. JULIO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL JULIO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO JULIO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. JULIO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"AGO","index":8,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. AGOSTO 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL AGOSTO",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO AGOSTO 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. AGOSTO 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"SEP","index":9,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. SEPTIEMBRE 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL SEPTIEMBRE",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO SEPTIEMBRE 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. SEPTIEMBRE 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"OCT","index":10,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. OCTUBRE 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL OCTUBRE",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO OCTUBRE 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. OCTUBRE 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"NOV","index":11,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. NOVIEMBRE 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL NOVIEMBRE",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO NOVIEMBRE 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. NOVIEMBRE 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"DIC","index":12,"n_rows":54,"n_cols":12,"rows_kept":54,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Menú",null,null,{"$f":"ENE!E1","v":"NOMBRE CONTRIBUYENTE"}]
[null,"CAFICON",null,null,"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. DICIEMBRE 2020"]
[null,"Enero"]
[null,"Febrero",{"$nulls":3},"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","RET. ISR","RET. IVA","   TOTAL"]
[null,"Marzo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"H5*0.16","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.1","v":{"v":0,"d":"0.00"}},{"$f":"H5*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:I5)-J5-K5","v":{"v":0,"d":"0.00"}}]
[null,"Abril",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Mayo",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Junio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Julio",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Agosto",{"$nulls":3},"00:00:00",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Septiembre"]
[null,"Octubre",{"$nulls":3},"TOTAL DICIEMBRE",null,{"$f":"SUM(H5:H10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L10)","v":{"v":0,"d":"0.00"}}]
[null,"Noviembre",{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[null,"Diciembre"]
[{"$nulls":4},{"$f":"E1","v":"NOMBRE CONTRIBUYENTE"}]
[{"$nulls":4},"CALCULO DEL PAGO PROVISIONAL I.S.R. ARRENDAMIENTO DICIEMBRE 2020"]
[]
[{"$nulls":7},"INGRESOS","%DEDUCC.","DEDUCC.","RETENCION"]
[]
[{"$nulls":5},"TOTALES",null,{"$f":"+H12","v":{"v":0,"d":"0.00"}},0.35,{"$f":"+H20*0.35","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"DEDUCCION POR PAGO DEL PREDIAL",{"$nulls":4},{"$f":"J54","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"INGRESOS GRAVADOS DEL MES",{"$nulls":4},{"$f":"H20","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"DEDUCCIONES AUTORIZADAS",{"$nulls":4},{"$f":"J20+J23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"BASE GRAVABLE",{"$nulls":4},{"$f":"+J25-J26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+J28-J29","v":{"$error":"#N/A"}}]
[{"$nulls":4}," POR CIENTO S/EXCED. LIM.INF.",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+J31*J32","v":{"$error":"#N/A"}}]
[{"$nulls":4},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(J28,'TARIFA 2020'!A5:D15,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"IMPUESTO CAUSADO ",{"$nulls":4},{"$f":"SUM(J34:J35)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"MENOS RETENCIONES",{"$nulls":4},{"$f":"K20","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"PAGO PROVISIONAL I.S.R.",{"$nulls":4},{"$f":"J37-J39","v":{"$error":"#N/A"}}]
[]
[{"$nulls":4},"I.V.A. TRASLADADO",null,null,{"$f":"I12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. ACREDITABLE",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"I.V.A. RETENIDO",null,null,{"$f":"K12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"I.V.A. POR PAGAR",null,null,{"$f":"H43-H45-H44","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"ANALISIS DE INGRESOS POR ARRENDAMIENTO PAGO PROV. DICIEMBRE 2020"]
[]
[{"$nulls":4},"TOTAL DEL PAGO DEL PREDIAL",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":4},"ENTRE NUMERO DE MESES DEL EJERCICIO",{"$nulls":4},{"$f":"J51/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"POR NUMERO DE MESES DEL PERIODO AL "]
[{"$nulls":4},"QUE CORRESPONDE EL PAGO",{"$nulls":4},{"$f":"J52*1","v":{"v":0,"d":"0.00"}}]

{"sheet":"TARIFA 2020","index":13,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[0,0,0,3]]}
["Tarifa aplicable para el cálculo de los pagos provisionales mensuales correspondientes a 2020, que efectúen los contribuyentes a que se refiere el Capítulo III, del Título IV de la Ley del Impuesto sobre la Renta, que obtengan ingresos por arrendamiento y en general por el otorgamiento del uso o goce temporal de bienes inmuebles."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,7735,0,{"v":0.0192,"d":"1.92%"}]
[7735.01,{"v":65651.07,"d":"65,651.07"},148.51,{"v":0.064,"d":"6.40%"}]
[{"v":65651.08,"d":"65,651.08"},{"v":115375.9,"d":"115,375.90"},3855.14,{"v":0.1088,"d":"10.88%"}]
[{"v":115375.91,"d":"115,375.91"},{"v":134119.41,"d":"134,119.41"},9265.2,{"v":0.16,"d":"16%"}]
[{"v":134119.42,"d":"134,119.42"},{"v":160577.65,"d":"160,577.65"},12264.16,{"v":0.1792,"d":"17.92%"}]
[{"v":160577.66,"d":"160,577.66"},{"v":323862,"d":"323,862.00"},{"v":17005.47,"d":"17,005.47"},{"v":0.2136,"d":"21.36%"}]
[{"v":323862.01,"d":"323,862.01"},{"v":510451,"d":"510,451.00"},{"v":51883.01,"d":"51,883.01"},{"v":0.2352,"d":"23.52%"}]
[{"v":510451.01,"d":"510,451.01"},{"v":974535.03,"d":"974,535.03"},{"v":95768.74,"d":"95,768.74"},{"v":0.3,"d":"30%"}]
[{"v":974535.04,"d":"974,535.04"},{"v":1299380.04,"d":"1,299,380.04"},{"v":234993.95,"d":"234,993.95"},{"v":0.32,"d":"32%"}]
[{"v":1299380.05,"d":"1,299,380.05"},{"v":3898140.12,"d":"3,898,140.12"},{"v":338944.34,"d":"338,944.34"},{"v":0.34,"d":"34%"}]
[{"v":3898140.13,"d":"3,898,140.13"},"En adelante",{"v":1222522.76,"d":"1,222,522.76"},{"v":0.35,"d":"35%"}]