{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Instrucciones","ISR","IVA","Enero","Febrero","Marzo","Abril","Mayo","junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"],"not_rendered":{"images":1,"macros":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Instrucciones","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"merged":[[3,0,3,6]]}
[]
["CAFICON"]
[]
["CÉDULAS PARA EL CALCULO DE PAGOS PROVISIONALES DE PERSONAS MORALES"]
[]
["1.- Deberá llenar los campos que estan con color amarillo"]
["2.- Dependiendo del caso deberá agregar o quitar la tasa de recargos "]
["3.- Dependiendo del caso deberá agregar o quitar el factor de actualización"]

{"sheet":"ISR","index":1,"n_rows":50,"n_cols":14,"rows_kept":50,"merged":[[35,0,35,1],[45,0,45,1]]}
[null,"CORTESIA DE LUIS REYES"]
[]
[null,"CÉDULAS PARA EL CALCULO DE PAGOS PROVISIONALES DE PERSONAS MORALES"]
[null,"EMPRESA:","MI EMPRESA, SA DE CV"]
[null,"RFC:"]
[]
[null,"Determinación Cálculo Provisional 2021"]
[null,"CONCEPTO","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
["(+)","Ingresos Propios Gravados 16%"]
["(+)","Ingresos Propios Gravados 8%"]
["(+)","Ingresos Propios Gravados 0%"]
["(+)","Ingresos Propios Exentos"]
["(+)","Ingresos a Favor"]
["(+)","Ganancia Cambiaria"]
["(+)","Recuperación de créditos incobrables"]
["(+)","Anticipo de clientes",0,0,0]
["(=)","Total de Ingresos Nominales del período",{"$f":"+SUM(C9:C16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["(-)","Ajuste por diferencia"]
["(-)","Diferencia por fact. Canceladas"]
[null,"Ingresos Nominales del período (acumulado)",{"$f":"+C17-C18-C19","v":0},{"$f":"+C20+D17","v":0},0,0,0,0,0,0,0,{"$f":"+K20+L17","v":0},{"$f":"+L20+M17","v":0},{"$f":"+M20+N17","v":0}]
["(x)","Coeficiente de Utilidad",0.025,0.025,{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"},{"v":0.025,"d":"0.02500"}]
["(=)","Utilidad Fiscal Previa",{"$f":"+C20*C21","v":0},0,0,0,0,0,0,0,0,{"$f":"+L20*L21","v":0},{"$f":"+M20*M21","v":0},{"$f":"+N20*N21","v":0}]
["(-)","Pérdida Fiscal actualizada de ejercicios \nanteriores pendiente de aplicar"]
["(+)","Inventario Acumulable"]
["(-)","PTU pagada en el ejercicio",{"$nulls":4},0]
["(=)","Utilidad fiscal Base",{"$f":"+C22-C23+C24-C25","v":0},0,0,0,0,0,0,0,0,{"$f":"+L22-L23+L24-L25","v":0},{"$f":"+M22-M23+M24-M25","v":0},{"$f":"+N22-N23+N24-N25","v":0}]
["(x)","Tasa Art. 9 LISR",{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
["(=)","ISR Causado del período",{"$f":"IF(C26<0,0,C26*C27)","v":0},{"$f":"IF(D26<0,0,D26*D27)","v":0},0,0,0,0,0,0,0,{"$f":"IF(L26<0,0,L26*L27)","v":0},{"$f":"IF(M26<0,0,M26*M27)","v":0},{"$f":"IF(N26<0,0,N26*N27)","v":0}]
["(-)","Pagos provisionales anteriores",null,{"$f":"+C29+C31","v":0},{"$f":"+D29+D31","v":0},{"$f":"+E29+E31","v":0},{"$f":"+F29+F31","v":0},0,0,0,0,0,{"$f":"+L29+L31","v":0},{"$f":"+M29+M31","v":0}]
["(-)"]
["(=)","Pago Provisional de ISR a enterar",{"$f":"IF(C28<C29,0,C28-C29)","v":0},{"$f":"IF(D28<D29,0,D28-D29)","v":0},{"$f":"IF(E28<E29,0,E28-E29)","v":0},{"$f":"IF(F28<F29,0,F28-F29)","v":0},0,0,0,0,0,{"$f":"IF(L28<L29,0,L28-L29)","v":0},{"$f":"IF(M28<M29,0,M28-M29)","v":0},{"$f":"IF(N28<N29,0,N28-N29)","v":0}]
[]
[]
[null,"RETENCIONES"]
[null,"CONCEPTO","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
["I.S.R. RETENCIONES POR SALARIOS"]
["(+)","I.S.R. RETENCIONES POR ASIMILADOS"]
["(+)","I.S.R. RETENCION POR SERV. PROFESIONALES"]
["(+)","I.S.R. RETENCION POR ARRENDAMIENTO"]
["(=)","SUMA RETENCIONES I.S.R.",{"$f":"+SUM(C36:C39)","v":0},{"$f":"+SUM(D36:D39)","v":0},0,0,0,0,0,0,0,0,0,0]
["(=)","RETENCIONES A PAGAR",{"$f":"+C40","v":0},{"$f":"+D40","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"SUBSIDIO AL EMPLEO.-"]
[null,"CONCEPTO","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
["Subisdio al Empleo.-",null,0]
[null,"Subsdio al empleo pend. De acreditar periodos ants.",0]
[null,"Subsidio al empleo aplicado a ISR propio",0]
[null,"Subsidio al empleo aplicado contra retenciones a terceros",{"$f":"SUM(Enero!C9:C12)","v":0},{"$f":"Febrero!C8","v":0},{"$f":"Marzo!C9","v":0},{"$f":"SUM(Abril!C8:C12)","v":0},0,0,0,0,0,0,0,0]
["(=)","Saldo Subsidio al empleo pendiente de aplicar",{"$f":"+C46+C47-C49-C48","v":0},{"$f":"+D46+D47-D49-D48","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"IVA","index":2,"n_rows":61,"n_cols":14,"rows_kept":61}
[null,"CORTESIA DE LUIS REYES"]
[]
[null,"CEDULA DETERMINACION IMPUESTO AL VALOR AGREGADO 2020"]
[null,{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"}]
[null,{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "}]
[null,"Determinación definitivo de IVA 2022"]
[]
[null,"CONCEPTO","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[]
[null,"INGRESOS","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,"INGRESOS TASA 16%"]
[null,"INGRESOS TASA 8%"]
[null,"INGRESOS TASA 0%"]
["(=)","TOTAL INGRESOS EFECTIVAMENTE COBRADOS",{"$f":"+SUM(C11:C13)","v":0},{"$f":"+SUM(D11:D13)","v":0},0,0,0,0,0,0,0,0,0,0]
["(=)","SUMA I.V.A. TRASLADADO",{"$f":"((C11*0.16)+(C12*0.08))","v":0},{"$f":"((D11*0.16)+(D12*0.08))","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"RETENCIONES","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
["(+)","I.V.A. RETENCION POR SERV. PROFESIONALES"]
["(+)","I.V.A. RETENCION POR ARRENDAMIENTO"]
["(+)","I.V.A. RETENCION 4% S/FLETES"]
["(=)","SUMA I.V.A. RETENCIONES",{"$f":"+C18+C19+C20","v":0},0,0,0,0,0,0,0,0,{"$f":"+L18+L19+L20","v":0},0,0]
[]
[null,"COMPRAS","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,"COMPRAS 16%"]
[null,"COMPRAS 8%"]
[null,"COMPRAS 0%"]
["(=)","TOTAL DE COMPRAS EFECTIVAMENTE PAGADOS",{"$f":"+SUM(C24:C26)","v":0},{"$f":"+SUM(D24:D26)","v":0},0,0,0,0,0,0,0,0,0,0]
["(=)","SUMA I.V.A. ACREDITABLE",{"$f":"(C24*0.16)+(C25*0.08)","v":0},{"$f":"(D24*0.16)+(D25*0.08)","v":0},0,0,0,0,0,0,0,0,0,0]
["(X)","PORCENTAJE DE ACREDITAMIENTO",{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"}]
["(=)","I.V.A. ACREEDITABLE",{"$f":"+C28*C29","v":0},0,0,0,0,0,0,0,0,{"$f":"+L28*L29","v":0},0,0]
["(+)","IVA ACREDITABLE RETENIDO DEL PERIODO ANTERIOR",null,{"$f":"+C21","v":0},{"$f":"+D21","v":0},0,0,0,0,0,0,0,0,0]
["(-)","IVA RETENIDO DEL PERIODO",{"$f":"C21","v":0},0,0,0,0,0,0,0,0,0,0,0]
["(=)","Total IVA Acreditable",{"$f":"C30+C31-C32","v":0},{"$f":"D30+D31-D32","v":0},0,0,0,0,0,0,0,0,0,0]
["(=)","I.V.A. POR PAGAR (FAVOR)",{"$f":"+C15-C33","v":0},0,0,0,0,0,0,0,0,0,0,0]
["(-)","ACREDITAMIENTO DE I.V.A. SALDO \nA FAVOR"]
["(=)","PAGO DEFINITIVO DE I.V.A.",{"$f":"+C34-C35","v":0},{"$f":"+D34-D35","v":0},0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":24}
[null,"DESPACHO DE CONTADORES DCA"]

{"sheet":"Enero","index":3,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act"]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS ENERO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!C31","v":0},{"$f":"ISR!C46","v":0},{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!C36","v":0},null,{"$f":"+B9-C9","v":0},{"$f":"+D9*$G$1","v":0},{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!C37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!C39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"ISR!C38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!C36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,{"v":0,"d":"0 "}]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"IVA!C21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":7},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Febrero","index":4,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act"]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS FEBRERO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"ISR!D31","v":0},{"$f":"ISR!D46","v":0},{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"ISR!D36","v":0},null,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"ISR!D37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!D39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"ISR!D38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"IVA!D36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"IVA!D21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":7},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Marzo","index":5,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act"]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS MARZO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"ISR!E31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"ISR!E36","v":0},{"$f":"ISR!E46","v":0},{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"ISR!E37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"ISR!E38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"IVA!E36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"IVA!E21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":7},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Abril","index":6,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act"]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS ABRIL 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!F31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!F36","v":0},{"$f":"ISR!E46","v":0},{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!F37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!F38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!F36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!F21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":7},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Mayo","index":7,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act"]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS MAYO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!G31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!G36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!G37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!G38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!G36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!G21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H9:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"junio","index":8,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1.0015]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS JUNIO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!H31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!H36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!H37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!H38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!H36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!H21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Julio","index":9,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1.0021]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS JULIO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!I31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!I36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!I37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!I38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!I36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!I21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Agosto","index":10,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS AGOSTO 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!J31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!J36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!J37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!J38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!J36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!J21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Septiembre","index":11,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS SEPTIEMBRE 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!K31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!K36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!K37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!K38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!K36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!K21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Octubre","index":12,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS OCTUBRE 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!L31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!L36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!L37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!L38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!L36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!L21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Noviembre","index":13,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS NOVIEMBRE 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!M31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!M36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!M37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!L38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!M36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!M21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]

{"sheet":"Diciembre","index":14,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$f":"ISR!B4&\" \"&ISR!C4","v":"EMPRESA: MI EMPRESA, SA DE CV"},{"$nulls":4},"Factor Act",1]
[{"$f":"ISR!B5&\" \"&ISR!C5","v":"RFC: "},{"$nulls":4},"Tasa Recargos",null,"<--- En caso de aplicar recargos colocar 1.13%"]
[]
["IMPUESTOS DICIEMBRE 2022"]
[null,null,"Menos"]
[null,"Impuesto","Subsidio"]
[null,"a Cargo","al Empleo","Diferencia","Actualizacion","Recargos","COMPENSACION","SALDO A PAGAR"]
["IMPUESTO SOBRE LA RENTA.- Personas Morales",{"$f":"+ISR!N31","v":0},null,{"$f":"+B8-C8","v":0},{"$f":"+D8*$G$1","v":0},{"$f":"ROUND(D8+((+D8+E8)*$G$2),0)","v":0},null,{"$f":"+F8-G8","v":0}]
["IMPUESTO SOBRE LA RENTA.- Retención por Salarios",{"$f":"+ISR!N36","v":0},0,{"$f":"+B9-C9","v":0},0,{"$f":"ROUND(D9+((+D9+E9)*$G$2),0)","v":0},null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Asimilados",{"$f":"+ISR!N37","v":0},null,{"$f":"+B10-C10","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Arrendamiento",{"$f":"ISR!E39","v":0},null,{"$f":"+B11-C11","v":0},0,0,null,0]
["IMPUESTO SOBRE LA RENTA.- Retención por Servicios Profesionales",{"$f":"+ISR!N38","v":0},null,{"$f":"+B12-C12","v":0},0,0,null,0]
[{"$nulls":4},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- IVA.-",{"$f":"+IVA!N36","v":0},null,{"$f":"+B14-C14","v":0},0,0,null,0]
["IMPUESTO AL VALOR AGREGADO.- Otras Retenciones",{"$f":"+IVA!N21","v":0},null,{"$f":"+B15-C15","v":0},0,0,null,0]
[{"$nulls":4},"TOTAL FINAL A PAGAR",null,{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
[]
["Solo capturar subsidio, actualizaciòn y recargos"]