{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Menú","ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC","TARIFAS 2021"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":110},"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]]}
["DETERMINACION PAGOS PROVISIONALES ISR E IVA PERSONA FISICA (HONORARIOS)",null,null,"DETERMINACION PAGOS PROVISIONALES ISR E IVA PERSONA FISICA (HONORARIOS) 2020"]
["CAFICON"]
["Enero"]
["Febrero"]
["Marzo"]
["Abril"]
["Mayo"]
["Junio"]
["Julio"]
["Agosto"]
["Septiembre"]
["Octubre"]
["Noviembre"]
["Diciembre"]

{"sheet":"ENE","index":1,"n_rows":100,"n_cols":10,"rows_kept":100,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,"NOMBRE DEL CONTRIBUYENTE"]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE ENERO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F9+G9-H9-I9","v":{"v":0,"d":"0.00"}}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL ENERO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE ENERO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL ENERO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA ENERO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS ",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN ENERO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA ENERO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS ",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN ENERO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA ENERO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"IF(I73<=0,0,VLOOKUP(I73,'TARIFAS 2021'!A5:D15,1))","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"IF(I73<=0,0,VLOOKUP(I73,'TARIFAS 2021'!A5:D15,4))","v":{"v":0,"d":"0.00%"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"IF(I73<=0,0,VLOOKUP(I73,'TARIFAS 2021'!A5:D15,3))","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H92-H93-H94","v":{"v":0,"d":"0.00"}},{"$f":"H96-H98","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H96-H98","v":{"v":0,"d":"0.00"}}]

{"sheet":"FEB","index":2,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE FEBRERO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL FEBRERO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE FEBRERO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL FEBRERO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA FEBRERO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS ENERO",{"$nulls":4},{"$f":"_ENE1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN FEBRERO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA FEBRERO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS ENERO",{"$nulls":4},{"$f":"_ENE2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN FEBRERO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA FEBRERO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A21:D31,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A21:D31,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A21:D31,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_ENE3+_ENE4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"MAR","index":3,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE MARZO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL MARZO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE MARZO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL MARZO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA MARZO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS FEBRERO",{"$nulls":4},{"$f":"_FEB1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN MARZO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA MARZO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS FEBRERO",{"$nulls":4},{"$f":"_FEB2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN MARZO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA MARZO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A37:D47,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A37:D47,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A37:D47,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_FEB3+_FEB4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"ABR","index":4,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE ABRIL 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$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"}]
[{"$nulls":3},"TOTAL ABRIL",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE ABRIL 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL ABRIL",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA ABRIL 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS MARZO",{"$nulls":4},{"$f":"_MAR1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN ABRIL",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA ABRIL",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS MARZO",{"$nulls":4},{"$f":"_MAR2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN ABRIL",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA ABRIL",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A52:D62,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A52:D62,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A52:D62,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_MAR3+_MAR4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"MAY","index":5,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE MAYO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL MAYO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE MAYO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL MAYO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA MAYO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS ABRIL",{"$nulls":4},{"$f":"_ABR1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN MAYO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA MAYO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS ABRIL",{"$nulls":4},{"$f":"_ABR2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN MAYO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA MAYO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A68:D78,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A68:D78,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A68:D78,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_ABR3+_ABR4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"JUN","index":6,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE JUNIO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL JUNIO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE JUNIO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL JUNIO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA JUNIO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS MAYO",{"$nulls":4},{"$f":"_MAY1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN JUNIO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA JUNIO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS MAYO",{"$nulls":4},{"$f":"_MAY2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN JUNIO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA JUNIO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A84:D94,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A84:D94,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A84:D94,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_MAY3+_MAY4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"JUL","index":7,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE JULIO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL JULIO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE JULIO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL JULIO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA JULIO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS JUNIO",{"$nulls":4},{"$f":"_JUN1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN JULIO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA JULIO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS JUNIO",{"$nulls":4},{"$f":"_JUN2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN JULIO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA JULIO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A99:D109,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A99:D109,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A99:D109,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_JUN3+_JUN4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"AGO","index":8,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE AGOSTO 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL AGOSTO",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE AGOSTO 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL AGOSTO",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA AGOSTO 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS JULIO",{"$nulls":4},{"$f":"_JUL1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN AGOSTO",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA AGOSTO",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS JULIO",{"$nulls":4},{"$f":"_JUL2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN AGOSTO",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA AGOSTO",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A115:D125,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A115:D125,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A115:D125,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_JUL3+_JUL4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5+_JUL5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"SEP","index":9,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE SEPTIEMBRE 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",null,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",null,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"00:00:00",null,{"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"}]
["Septiembre",null,null,"00:00:00",null,{"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"}]
["Octubre",null,null,"00:00:00",null,{"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"}]
["Noviembre",null,null,"00:00:00",null,{"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"}]
["Diciembre",null,null,"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL SEPTIEMBRE",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE SEPTIEMBRE 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL SEPTIEMBRE",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA SEPTIEMBRE 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS AGOSTO",{"$nulls":4},{"$f":"_AGO1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN SEPTIEMBRE",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA SEPTIEMBRE",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS AGOSTO",{"$nulls":4},{"$f":"_AGO2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN SEPTIEMBRE",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA SEPTIEMBRE",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A131:D141,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A131:D141,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A131:D141,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_AGO3+_AGO4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5+_JUL5+_AGO5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"OCT","index":10,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE OCTUBRE 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$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"}]
[{"$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"}]
[{"$nulls":3},"TOTAL OCTUBRE",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE OCTUBRE 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL OCTUBRE",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA OCTUBRE 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS SEPTIEMBRE",{"$nulls":4},{"$f":"_SEP1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN OCTUBRE",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA OCTUBRE",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS SEPTIEMBRE",{"$nulls":4},{"$f":"_SEP2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN OCTUBRE",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA OCTUBRE",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A147:D157,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A147:D157,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A147:D157,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_SEP3+_SEP4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5+_JUL5+_AGO5+_SEP5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"NOV","index":11,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE NOVIEMBRE 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",0,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"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"}]
["Septiembre",null,null,"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"}]
["Octubre",null,null,"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"}]
["Noviembre",null,null,"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"}]
["Diciembre",null,null,"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL NOVIEMBRE",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE NOVIEMBRE 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL NOVIEMBRE",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA NOVIEMBRE 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS OCTUBRE",{"$nulls":4},{"$f":"_OCT1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN NOVIEMBRE",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA NOVIEMBRE",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS OCTUBRE",{"$nulls":4},{"$f":"_OCT2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN NOVIEMBRE",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA NOVIEMBRE",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A163:D173,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A163:D173,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A163:D173,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_OCT3+_OCT4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5+_JUL5+_AGO5+_SEP5+_OCT5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"DIC","index":12,"n_rows":101,"n_cols":10,"rows_kept":101,"merged":[[0,0,0,1],[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]]}
["Menú",null,null,{"$f":"ENE!D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
["CAFICON",null,null,"ANALISIS DE INGRESOS POR HONORARIOS DE DICIEMBRE 2020"]
["Enero"]
["Febrero"]
["Marzo",{"$nulls":6},"RETENCION","RETENCION"]
["Abril",null,null,"   FECHA","No.RECIBO","  IMPORTE","   I.V.A.","I.V.A.","I.S.R.","   TOTAL"]
["Mayo"]
["Junio",null,null,"00:00:00",null,{"v":0,"d":"0.00"},{"$f":"F8*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F8*0.1","v":{"v":0,"d":"0.00"}},{"$f":"+F8+G8-H8-I8","v":{"v":0,"d":"0.00"}}]
["Julio",null,null,"00:00:00",null,{"v":0,"d":"0.00"},{"$f":"F9*0.16","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.106667","v":{"v":0,"d":"0.00"}},{"$f":"F9*0.1","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Agosto",null,null,"00:00:00",null,{"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"}]
["Septiembre",null,null,"00:00:00",null,{"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"}]
["Octubre",null,null,"00:00:00",null,{"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"}]
["Noviembre",null,null,"00:00:00",null,{"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"}]
["Diciembre",null,null,"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"00:00:00",null,{"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"}]
[{"$nulls":3},"TOTAL DICIEMBRE",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H8:H16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I8:I16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J8:J16)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"*EN CASO DE NO LLEVAR RETENCIONES PONER \"0\" EN LAS RETENCIONES DE ISR E IVA"]
[]
[]
[]
[]
[]
[{"$nulls":3},"ANALISIS DE EGRESOS DE DICIEMBRE 2020"]
[]
[{"$nulls":3},"GASTOS POR HONORARIOS",null,null,"IMPORTE","  I.V.A.","   TOTAL"]
[{"$nulls":3},"SERVICIOS PROFESIONALES",null,null,{"v":0,"d":"0.00"},{"$f":"G27*0.16","v":{"v":0,"d":"0.00"}},{"$f":"SUM(+G27+H27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"SUELDOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"IMSS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"GASOLINA *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"PAPELERIA Y ART. DE OF.",null,null,{"v":0,"d":"0.00"},{"$f":"G31*0.16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":3},"COMISIONES BANCARIAS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"ARTS LIMPIEZA, OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MANTENIMIENTO EQ. TRANSP.",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TELEFONIA INTERNET",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"MOVIL",null," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"CONSUMOS EN RESTAURANTES",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"VIATICOS",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"SEGURO AUTO",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"LUZ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"RENTA OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G41:H41)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MOBILIARIO Y/O EQPO. OFICINA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G42:H42)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"OTROS GASTOS *agregar IVA",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G43:H43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DICIEMBRE",null,null,{"$f":"SUM(G27:G43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H27:H43)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G44:H44)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"D1","v":"NOMBRE DEL CONTRIBUYENTE"}]
[{"$nulls":3},"CALCULO DEL PAGO PROV. I.S.R. POR HONORARIOS HASTA DICIEMBRE 2020"]
[]
[{"$nulls":3},"INGRESOS ACUMULADOS OBTENIDOS NOVIEMBRE",{"$nulls":4},{"$f":"_NOV1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"INGRESOS OBTENIDOS EN DICIEMBRE",{"$nulls":4},{"$f":"+F17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE INGRESOS HASTA DICIEMBRE",{"$nulls":4},{"$f":"+I65+I66","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS NOVIEMBRE",{"$nulls":4},{"$f":"_NOV2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"DEDUCCIONES AUTORIZADAS EN DICIEMBRE",{"$nulls":4},{"$f":"G44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TOTAL DE DEDUCCIONES HASTA DICIEMBRE",{"$nulls":4},{"$f":"+I69+I70","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"BASE GRAVABLE",{"$nulls":4},{"$f":"+I67-I71","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"LIMITE INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A179:D189,1)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"EXCEDENTE S/LIM.INFERIOR",{"$nulls":4},{"$f":"+I73-I74","v":{"$error":"#N/A"}}]
[{"$nulls":3},"POR % SOBRE LIM. INFERIOR",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A179:D189,4)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO MARGINAL",{"$nulls":4},{"$f":"+I76*I77","v":{"$error":"#N/A"}}]
[{"$nulls":3},"CUOTA FIJA",{"$nulls":4},{"$f":"VLOOKUP(I73,'TARIFAS 2021'!A179:D189,3)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":3},"IMPUESTO CAUSADO I.S.R.",{"$nulls":4},{"$f":"+I79+I80","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES DEL MES",{"$nulls":4},{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"PAGO PROVISIONAL DEL MES",{"$nulls":4},{"$f":"I82-I83","v":{"$error":"#N/A"}}]
[{"$nulls":3},"MENOS RETENCIONES ACUMULADAS",{"$nulls":4},{"$f":"_NOV3+_NOV4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"MENOS PAGOS PROVISIONALES ANTERIORES",{"$nulls":4},{"$f":"_ENE5+_FEB5+_MAR5+_ABR5+_MAY5+_JUN5+_JUL5+_AGO5+_SEP5+_OCT5+_NOV5","v":{"$error":"#N/A"}}]
[{"$nulls":3},"PAGO PROVISIONAL A ENTERAR I.S.R.",{"$nulls":4},{"$f":"I85-I86-I87","v":{"$error":"#N/A"}}]
[{"$nulls":3},"*Si no hay impuesto a cargo, poner \"0\" para que no afecte formulas en los provisionales anteriores."]
[]
[{"$nulls":3},"RETENCIONES",null,{"$f":"+I17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. TRASLADADO ",{"$nulls":3},{"$f":"+G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. RETENIDO",{"$nulls":3},{"$f":"+H17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"I.V.A. ACREDITABLE",{"$nulls":3},{"$f":"+H44","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. POR ENTERAR O A FAVOR",{"$nulls":3},{"$f":"+H93-H94-H95","v":{"v":0,"d":"0.00"}},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"I.V.A. ACRED.FAVOR PERIODO ANTER.",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":3},"*Si hay IVA a Favor colocarlo manualmente en el sig.mes"]
[{"$nulls":3},"TOTAL DE I.V.A. A PAGAR",{"$nulls":3},{"$f":"H97-H99","v":{"v":0,"d":"0.00"}}]

{"sheet":"TARIFAS 2021","index":13,"n_rows":189,"n_cols":4,"rows_kept":189,"hidden":true,"merged":[[0,0,0,3],[16,0,16,3],[32,0,32,3],[47,0,47,3],[63,0,63,3],[79,0,79,3],[94,0,94,3],[110,0,110,3],[126,0,126,3],[142,0,142,3],[158,0,158,3],[174,0,174,3]]}
["6. Tarifa para el pago provisional del mes de enero de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,644.58,0,{"v":0.0192,"d":"1.92%"}]
[644.59,{"v":5470.92,"d":"5,470.92"},12.38,{"v":0.064,"d":"6.40%"}]
[{"v":5470.93,"d":"5,470.93"},{"v":9614.66,"d":"9,614.66"},321.26,{"v":0.1088,"d":"10.88%"}]
[{"v":9614.67,"d":"9,614.67"},{"v":11176.62,"d":"11,176.62"},772.1,{"v":0.16,"d":"16%"}]
[{"v":11176.63,"d":"11,176.63"},{"v":13381.47,"d":"13,381.47"},1022.01,{"v":0.1792,"d":"17.92%"}]
[{"v":13381.48,"d":"13,381.48"},{"v":26988.5,"d":"26,988.50"},{"v":1417.12,"d":"1,417.12"},{"v":0.2136,"d":"21.36%"}]
[{"v":26988.51,"d":"26,988.51"},{"v":42537.58,"d":"42,537.58"},{"v":4323.58,"d":"4,323.58"},{"v":0.2352,"d":"23.52%"}]
[{"v":42537.59,"d":"42,537.59"},{"v":81211.25,"d":"81,211.25"},{"v":7980.73,"d":"7,980.73"},{"v":0.3,"d":"30%"}]
[{"v":81211.26,"d":"81,211.26"},{"v":108281.67,"d":"108,281.67"},{"v":19582.83,"d":"19,582.83"},{"v":0.32,"d":"32%"}]
[{"v":108281.68,"d":"108,281.68"},{"v":324845.01,"d":"324,845.01"},{"v":28245.36,"d":"28,245.36"},{"v":0.34,"d":"34%"}]
[{"v":324845.02,"d":"324,845.02"},"En adelante",{"v":101876.9,"d":"101,876.90"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de febrero de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":1289.16,"d":"1,289.16"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":1289.17,"d":"1,289.17"},{"v":10941.84,"d":"10,941.84"},24.76,{"v":0.064,"d":"6.40%"}]
[{"v":10941.85,"d":"10,941.85"},{"v":19229.32,"d":"19,229.32"},642.52,{"v":0.1088,"d":"10.88%"}]
[{"v":19229.33,"d":"19,229.33"},{"v":22353.24,"d":"22,353.24"},{"v":1544.2,"d":"1,544.20"},{"v":0.16,"d":"16%"}]
[{"v":22353.25,"d":"22,353.25"},{"v":26762.94,"d":"26,762.94"},{"v":2044.02,"d":"2,044.02"},{"v":0.1792,"d":"17.92%"}]
[{"v":26762.95,"d":"26,762.95"},{"v":53977,"d":"53,977.00"},{"v":2834.24,"d":"2,834.24"},{"v":0.2136,"d":"21.36%"}]
[{"v":53977.01,"d":"53,977.01"},{"v":85075.16,"d":"85,075.16"},{"v":8647.16,"d":"8,647.16"},{"v":0.2352,"d":"23.52%"}]
[{"v":85075.17,"d":"85,075.17"},{"v":162422.5,"d":"162,422.50"},{"v":15961.46,"d":"15,961.46"},{"v":0.3,"d":"30%"}]
[{"v":162422.51,"d":"162,422.51"},{"v":216563.34,"d":"216,563.34"},{"v":39165.66,"d":"39,165.66"},{"v":0.32,"d":"32%"}]
[{"v":216563.35,"d":"216,563.35"},{"v":649690.02,"d":"649,690.02"},{"v":56490.72,"d":"56,490.72"},{"v":0.34,"d":"34%"}]
[{"v":649690.03,"d":"649,690.03"},"En adelante",{"v":203753.8,"d":"203,753.80"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de marzo de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":1933.74,"d":"1,933.74"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":1933.75,"d":"1,933.75"},{"v":16412.76,"d":"16,412.76"},37.14,{"v":0.064,"d":"6.40%"}]
[{"v":16412.77,"d":"16,412.77"},{"v":28843.98,"d":"28,843.98"},963.78,{"v":0.1088,"d":"10.88%"}]
[{"v":28843.99,"d":"28,843.99"},{"v":33529.86,"d":"33,529.86"},{"v":2316.3,"d":"2,316.30"},{"v":0.16,"d":"16%"}]
[{"v":33529.87,"d":"33,529.87"},{"v":40144.41,"d":"40,144.41"},{"v":3066.03,"d":"3,066.03"},{"v":0.1792,"d":"17.92%"}]
[{"v":40144.42,"d":"40,144.42"},{"v":80965.5,"d":"80,965.50"},{"v":4251.36,"d":"4,251.36"},{"v":0.2136,"d":"21.36%"}]
[{"v":80965.51,"d":"80,965.51"},{"v":127612.74,"d":"127,612.74"},{"v":12970.74,"d":"12,970.74"},{"v":0.2352,"d":"23.52%"}]
[{"v":127612.75,"d":"127,612.75"},{"v":243633.75,"d":"243,633.75"},{"v":23942.19,"d":"23,942.19"},{"v":0.3,"d":"30%"}]
[{"v":243633.76,"d":"243,633.76"},{"v":324845.01,"d":"324,845.01"},{"v":58748.49,"d":"58,748.49"},{"v":0.32,"d":"32%"}]
[{"v":324845.02,"d":"324,845.02"},{"v":974535.03,"d":"974,535.03"},{"v":84736.08,"d":"84,736.08"},{"v":0.34,"d":"34%"}]
[{"v":974535.04,"d":"974,535.04"},"En adelante",{"v":305630.7,"d":"305,630.70"},{"v":0.35,"d":"35%"}]
["Tarifa para el pago provisional del mes de abril de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":2578.32,"d":"2,578.32"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":2578.33,"d":"2,578.33"},{"v":21883.68,"d":"21,883.68"},49.52,{"v":0.064,"d":"6.40%"}]
[{"v":21883.69,"d":"21,883.69"},{"v":38458.64,"d":"38,458.64"},{"v":1285.04,"d":"1,285.04"},{"v":0.1088,"d":"10.88%"}]
[{"v":38458.65,"d":"38,458.65"},{"v":44706.48,"d":"44,706.48"},{"v":3088.4,"d":"3,088.40"},{"v":0.16,"d":"16%"}]
[{"v":44706.49,"d":"44,706.49"},{"v":53525.88,"d":"53,525.88"},{"v":4088.04,"d":"4,088.04"},{"v":0.1792,"d":"17.92%"}]
[{"v":53525.89,"d":"53,525.89"},{"v":107954,"d":"107,954.00"},{"v":5668.48,"d":"5,668.48"},{"v":0.2136,"d":"21.36%"}]
[{"v":107954.01,"d":"107,954.01"},{"v":170150.32,"d":"170,150.32"},{"v":17294.32,"d":"17,294.32"},{"v":0.2352,"d":"23.52%"}]
[{"v":170150.33,"d":"170,150.33"},{"v":324845,"d":"324,845.00"},{"v":31922.92,"d":"31,922.92"},{"v":0.3,"d":"30%"}]
[{"v":324845.01,"d":"324,845.01"},{"v":433126.68,"d":"433,126.68"},{"v":78331.32,"d":"78,331.32"},{"v":0.32,"d":"32%"}]
[{"v":433126.69,"d":"433,126.69"},{"v":1299380.04,"d":"1,299,380.04"},{"v":112981.44,"d":"112,981.44"},{"v":0.34,"d":"34%"}]
[{"v":1299380.05,"d":"1,299,380.05"},"En adelante",{"v":407507.6,"d":"407,507.60"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de mayo de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":3222.9,"d":"3,222.90"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":3222.91,"d":"3,222.91"},{"v":27354.6,"d":"27,354.60"},61.9,{"v":0.064,"d":"6.40%"}]
[{"v":27354.61,"d":"27,354.61"},{"v":48073.3,"d":"48,073.30"},{"v":1606.3,"d":"1,606.30"},{"v":0.1088,"d":"10.88%"}]
[{"v":48073.31,"d":"48,073.31"},{"v":55883.1,"d":"55,883.10"},{"v":3860.5,"d":"3,860.50"},{"v":0.16,"d":"16%"}]
[{"v":55883.11,"d":"55,883.11"},{"v":66907.35,"d":"66,907.35"},{"v":5110.05,"d":"5,110.05"},{"v":0.1792,"d":"17.92%"}]
[{"v":66907.36,"d":"66,907.36"},{"v":134942.5,"d":"134,942.50"},{"v":7085.6,"d":"7,085.60"},{"v":0.2136,"d":"21.36%"}]
[{"v":134942.51,"d":"134,942.51"},{"v":212687.9,"d":"212,687.90"},{"v":21617.9,"d":"21,617.90"},{"v":0.2352,"d":"23.52%"}]
[{"v":212687.91,"d":"212,687.91"},{"v":406056.25,"d":"406,056.25"},{"v":39903.65,"d":"39,903.65"},{"v":0.3,"d":"30%"}]
[{"v":406056.26,"d":"406,056.26"},{"v":541408.35,"d":"541,408.35"},{"v":97914.15,"d":"97,914.15"},{"v":0.32,"d":"32%"}]
[{"v":541408.36,"d":"541,408.36"},{"v":1624225.05,"d":"1,624,225.05"},{"v":141226.8,"d":"141,226.80"},{"v":0.34,"d":"34%"}]
[{"v":1624225.06,"d":"1,624,225.06"},"En adelante",{"v":509384.5,"d":"509,384.50"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de junio de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":3867.48,"d":"3,867.48"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":3867.49,"d":"3,867.49"},{"v":32825.52,"d":"32,825.52"},74.28,{"v":0.064,"d":"6.40%"}]
[{"v":32825.53,"d":"32,825.53"},{"v":57687.96,"d":"57,687.96"},{"v":1927.56,"d":"1,927.56"},{"v":0.1088,"d":"10.88%"}]
[{"v":57687.97,"d":"57,687.97"},{"v":67059.72,"d":"67,059.72"},{"v":4632.6,"d":"4,632.60"},{"v":0.16,"d":"16%"}]
[{"v":67059.73,"d":"67,059.73"},{"v":80288.82,"d":"80,288.82"},{"v":6132.06,"d":"6,132.06"},{"v":0.1792,"d":"17.92%"}]
[{"v":80288.83,"d":"80,288.83"},{"v":161931,"d":"161,931.00"},{"v":8502.72,"d":"8,502.72"},{"v":0.2136,"d":"21.36%"}]
[{"v":161931.01,"d":"161,931.01"},{"v":255225.48,"d":"255,225.48"},{"v":25941.48,"d":"25,941.48"},{"v":0.2352,"d":"23.52%"}]
[{"v":255225.49,"d":"255,225.49"},{"v":487267.5,"d":"487,267.50"},{"v":47884.38,"d":"47,884.38"},{"v":0.3,"d":"30%"}]
[{"v":487267.51,"d":"487,267.51"},{"v":649690.02,"d":"649,690.02"},{"v":117496.98,"d":"117,496.98"},{"v":0.32,"d":"32%"}]
[{"v":649690.03,"d":"649,690.03"},{"v":1949070.06,"d":"1,949,070.06"},{"v":169472.16,"d":"169,472.16"},{"v":0.34,"d":"34%"}]
[{"v":1949070.07,"d":"1,949,070.07"},"En adelante",{"v":611261.4,"d":"611,261.40"},{"v":0.35,"d":"35%"}]
["Tarifa para el pago provisional del mes de julio de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":4512.06,"d":"4,512.06"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":4512.07,"d":"4,512.07"},{"v":38296.44,"d":"38,296.44"},86.66,{"v":0.064,"d":"6.40%"}]
[{"v":38296.45,"d":"38,296.45"},{"v":67302.62,"d":"67,302.62"},{"v":2248.82,"d":"2,248.82"},{"v":0.1088,"d":"10.88%"}]
[{"v":67302.63,"d":"67,302.63"},{"v":78236.34,"d":"78,236.34"},{"v":5404.7,"d":"5,404.70"},{"v":0.16,"d":"16%"}]
[{"v":78236.35,"d":"78,236.35"},{"v":93670.29,"d":"93,670.29"},{"v":7154.07,"d":"7,154.07"},{"v":0.1792,"d":"17.92%"}]
[{"v":93670.3,"d":"93,670.30"},{"v":188919.5,"d":"188,919.50"},{"v":9919.84,"d":"9,919.84"},{"v":0.2136,"d":"21.36%"}]
[{"v":188919.51,"d":"188,919.51"},{"v":297763.06,"d":"297,763.06"},{"v":30265.06,"d":"30,265.06"},{"v":0.2352,"d":"23.52%"}]
[{"v":297763.07,"d":"297,763.07"},{"v":568478.75,"d":"568,478.75"},{"v":55865.11,"d":"55,865.11"},{"v":0.3,"d":"30%"}]
[{"v":568478.76,"d":"568,478.76"},{"v":757971.69,"d":"757,971.69"},{"v":137079.81,"d":"137,079.81"},{"v":0.32,"d":"32%"}]
[{"v":757971.7,"d":"757,971.70"},{"v":2273915.07,"d":"2,273,915.07"},{"v":197717.52,"d":"197,717.52"},{"v":0.34,"d":"34%"}]
[{"v":2273915.08,"d":"2,273,915.08"},"En adelante",{"v":713138.3,"d":"713,138.30"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de agosto de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":5156.64,"d":"5,156.64"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":5156.65,"d":"5,156.65"},{"v":43767.36,"d":"43,767.36"},99.04,{"v":0.064,"d":"6.40%"}]
[{"v":43767.37,"d":"43,767.37"},{"v":76917.28,"d":"76,917.28"},{"v":2570.08,"d":"2,570.08"},{"v":0.1088,"d":"10.88%"}]
[{"v":76917.29,"d":"76,917.29"},{"v":89412.96,"d":"89,412.96"},{"v":6176.8,"d":"6,176.80"},{"v":0.16,"d":"16%"}]
[{"v":89412.97,"d":"89,412.97"},{"v":107051.76,"d":"107,051.76"},{"v":8176.08,"d":"8,176.08"},{"v":0.1792,"d":"17.92%"}]
[{"v":107051.77,"d":"107,051.77"},{"v":215908,"d":"215,908.00"},{"v":11336.96,"d":"11,336.96"},{"v":0.2136,"d":"21.36%"}]
[{"v":215908.01,"d":"215,908.01"},{"v":340300.64,"d":"340,300.64"},{"v":34588.64,"d":"34,588.64"},{"v":0.2352,"d":"23.52%"}]
[{"v":340300.65,"d":"340,300.65"},{"v":649690,"d":"649,690.00"},{"v":63845.84,"d":"63,845.84"},{"v":0.3,"d":"30%"}]
[{"v":649690.01,"d":"649,690.01"},{"v":866253.36,"d":"866,253.36"},{"v":156662.64,"d":"156,662.64"},{"v":0.32,"d":"32%"}]
[{"v":866253.37,"d":"866,253.37"},{"v":2598760.08,"d":"2,598,760.08"},{"v":225962.88,"d":"225,962.88"},{"v":0.34,"d":"34%"}]
[{"v":2598760.09,"d":"2,598,760.09"},"En adelante",{"v":815015.2,"d":"815,015.20"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de septiembre de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":5801.22,"d":"5,801.22"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":5801.23,"d":"5,801.23"},{"v":49238.28,"d":"49,238.28"},111.42,{"v":0.064,"d":"6.40%"}]
[{"v":49238.29,"d":"49,238.29"},{"v":86531.94,"d":"86,531.94"},{"v":2891.34,"d":"2,891.34"},{"v":0.1088,"d":"10.88%"}]
[{"v":86531.95,"d":"86,531.95"},{"v":100589.58,"d":"100,589.58"},{"v":6948.9,"d":"6,948.90"},{"v":0.16,"d":"16%"}]
[{"v":100589.59,"d":"100,589.59"},{"v":120433.23,"d":"120,433.23"},{"v":9198.09,"d":"9,198.09"},{"v":0.1792,"d":"17.92%"}]
[{"v":120433.24,"d":"120,433.24"},{"v":242896.5,"d":"242,896.50"},{"v":12754.08,"d":"12,754.08"},{"v":0.2136,"d":"21.36%"}]
[{"v":242896.51,"d":"242,896.51"},{"v":382838.22,"d":"382,838.22"},{"v":38912.22,"d":"38,912.22"},{"v":0.2352,"d":"23.52%"}]
[{"v":382838.23,"d":"382,838.23"},{"v":730901.25,"d":"730,901.25"},{"v":71826.57,"d":"71,826.57"},{"v":0.3,"d":"30%"}]
[{"v":730901.26,"d":"730,901.26"},{"v":974535.03,"d":"974,535.03"},{"v":176245.47,"d":"176,245.47"},{"v":0.32,"d":"32%"}]
[{"v":974535.04,"d":"974,535.04"},{"v":2923605.09,"d":"2,923,605.09"},{"v":254208.24,"d":"254,208.24"},{"v":0.34,"d":"34%"}]
[{"v":2923605.1,"d":"2,923,605.10"},"En adelante",{"v":916892.1,"d":"916,892.10"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de octubre de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":6445.8,"d":"6,445.80"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":6445.81,"d":"6,445.81"},{"v":54709.2,"d":"54,709.20"},123.8,{"v":0.064,"d":"6.40%"}]
[{"v":54709.21,"d":"54,709.21"},{"v":96146.6,"d":"96,146.60"},{"v":3212.6,"d":"3,212.60"},{"v":0.1088,"d":"10.88%"}]
[{"v":96146.61,"d":"96,146.61"},{"v":111766.2,"d":"111,766.20"},{"v":7721,"d":"7,721.00"},{"v":0.16,"d":"16%"}]
[{"v":111766.21,"d":"111,766.21"},{"v":133814.7,"d":"133,814.70"},{"v":10220.1,"d":"10,220.10"},{"v":0.1792,"d":"17.92%"}]
[{"v":133814.71,"d":"133,814.71"},{"v":269885,"d":"269,885.00"},{"v":14171.2,"d":"14,171.20"},{"v":0.2136,"d":"21.36%"}]
[{"v":269885.01,"d":"269,885.01"},{"v":425375.8,"d":"425,375.80"},{"v":43235.8,"d":"43,235.80"},{"v":0.2352,"d":"23.52%"}]
[{"v":425375.81,"d":"425,375.81"},{"v":812112.5,"d":"812,112.50"},{"v":79807.3,"d":"79,807.30"},{"v":0.3,"d":"30%"}]
[{"v":812112.51,"d":"812,112.51"},{"v":1082816.7,"d":"1,082,816.70"},{"v":195828.3,"d":"195,828.30"},{"v":0.32,"d":"32%"}]
[{"v":1082816.71,"d":"1,082,816.71"},{"v":3248450.1,"d":"3,248,450.10"},{"v":282453.6,"d":"282,453.60"},{"v":0.34,"d":"34%"}]
[{"v":3248450.11,"d":"3,248,450.11"},"En adelante",{"v":1018769,"d":"1,018,769.00"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de noviembre de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":7090.38,"d":"7,090.38"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":7090.39,"d":"7,090.39"},{"v":60180.12,"d":"60,180.12"},136.18,{"v":0.064,"d":"6.40%"}]
[{"v":60180.13,"d":"60,180.13"},{"v":105761.26,"d":"105,761.26"},{"v":3533.86,"d":"3,533.86"},{"v":0.1088,"d":"10.88%"}]
[{"v":105761.27,"d":"105,761.27"},{"v":122942.82,"d":"122,942.82"},{"v":8493.1,"d":"8,493.10"},{"v":0.16,"d":"16%"}]
[{"v":122942.83,"d":"122,942.83"},{"v":147196.17,"d":"147,196.17"},{"v":11242.11,"d":"11,242.11"},{"v":0.1792,"d":"17.92%"}]
[{"v":147196.18,"d":"147,196.18"},{"v":296873.5,"d":"296,873.50"},{"v":15588.32,"d":"15,588.32"},{"v":0.2136,"d":"21.36%"}]
[{"v":296873.51,"d":"296,873.51"},{"v":467913.38,"d":"467,913.38"},{"v":47559.38,"d":"47,559.38"},{"v":0.2352,"d":"23.52%"}]
[{"v":467913.39,"d":"467,913.39"},{"v":893323.75,"d":"893,323.75"},{"v":87788.03,"d":"87,788.03"},{"v":0.3,"d":"30%"}]
[{"v":893323.76,"d":"893,323.76"},{"v":1191098.37,"d":"1,191,098.37"},{"v":215411.13,"d":"215,411.13"},{"v":0.32,"d":"32%"}]
[{"v":1191098.38,"d":"1,191,098.38"},{"v":3573295.11,"d":"3,573,295.11"},{"v":310698.96,"d":"310,698.96"},{"v":0.34,"d":"34%"}]
[{"v":3573295.12,"d":"3,573,295.12"},"En adelante",{"v":1120645.9,"d":"1,120,645.90"},{"v":0.35,"d":"35%"}]
[]
["Tarifa para el pago provisional del mes de diciembre de 2020, aplicable a los ingresos que perciban los contribuyentes a que se refiere el Capítulo II, Sección I, del Título IV de la Ley del Impuesto sobre la Renta."]
["Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre"]
[{"$nulls":3},"el excedente del límite inferior"]
["$","$","$","%"]
[0.01,{"v":7735,"d":"7,735.00"},0,{"v":0.0192,"d":"1.92%"}]
[{"v":7735.01,"d":"7,735.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"},{"v":3855.14,"d":"3,855.14"},{"v":0.1088,"d":"10.88%"}]
[{"v":115375.91,"d":"115,375.91"},{"v":134119.41,"d":"134,119.41"},{"v":9265.2,"d":"9,265.20"},{"v":0.16,"d":"16%"}]
[{"v":134119.42,"d":"134,119.42"},{"v":160577.65,"d":"160,577.65"},{"v":12264.16,"d":"12,264.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%"}]