{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Menú","IVA"],"not_rendered":{"images":1,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Menú","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"merged":[[0,1,0,7]]}
[null,"DETERMINACION PAGOS PROVISIONALES ISR E IVA PERSONA FISICA (HONORARIOS) 2020"]

{"sheet":"IVA","index":1,"n_rows":57,"n_cols":14,"rows_kept":57,"merged":[[1,0,1,13],[2,0,2,13],[3,0,3,13]]}
[]
["EMPRESA X, S.A. DE C.V."]
["CONTABILIDAD 2021"]
["DETERMINACION DEL IMPUESTO AL VALOR AGREGADO"]
[]
[{"$nulls":13},"TOTAL"]
["CONCEPTO","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","DE ENERO"]
[{"$nulls":13},"A DICIEMB."]
[]
["INGRESOS TASA 0%"]
["INGRESOS TASA 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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B11:M11)","v":{"v":0,"d":"0.00"}}]
[]
["TOTAL INGRESOS TASA 0%",{"$f":"SUM(B11:B12)","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["TOTAL DE INGRESOS COBRADOS GRAVADOS",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B15:M15)","v":{"v":0,"d":"0.00"}}]
["menos:"]
["INGRESOS COBRADOS AL 15%",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["igual:"]
[]
["INGRESOS TASA 16%"]
["INGRESOS TASA 16%",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B21:M21)","v":{"v":0,"d":"0.00"}}]
[]
["TOTAL INGRESOS TASA 16%",{"$f":"SUM(B21:B22)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C21:C22)","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["INGRESOS NETOS AL 16%",{"$f":"+B23","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B25:M25)","v":{"v":0,"d":"0.00"}}]
["igual:"]
["BASE PARA IVA AL 16%",{"$f":"+B25","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B27:M27)","v":{"v":0,"d":"0.00"}}]
["por:"]
["TASA DEL 16%",{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"},{"v":0.16,"d":"16%"}]
["igual:"]
["IVA TRASLADADO AL 16%",{"$f":"+B27*B29","v":{"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"},{"v":0,"d":"0.00"},{"$f":"+H25*H29","v":{"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"},{"v":0,"d":"0.00"},{"$f":"SUM(B31:M31)","v":{"v":0,"d":"0.00"}}]
[]
["BASE PARA IVA AL 15%",{"$f":"+B17","v":{"v":0,"d":"0.00"}},{"$f":"+C17","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"$f":"SUM(B33:M33)","v":{"v":0,"d":"0.00"}}]
["por:"]
["TASA DEL 15%",{"v":0.15,"d":"15%"},{"$nulls":11},{"v":0.15,"d":"15%"}]
["igual:"]
["IVA TRASLADADO AL 15%",{"$f":"+B33*B35","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"$f":"SUM(B37:M37)","v":{"v":0,"d":"0.00"}}]
[]
["TOTAL DE IVA TRASLADADO",{"$f":"+B37+B31","v":{"v":0,"d":"0.00"}},{"$f":"+C37+C31","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["IVA TRASLADADO EMPRESA",{"$nulls":12},{"$f":"SUM(B41:M41)","v":{"v":0,"d":"0.00"}}]
["DIF",{"$f":"+B39-B41","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B42:M42)","v":{"v":0,"d":"0.00"}}]
["BASE",{"$f":"+B42/0.15","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B43:M43)","v":{"v":0,"d":"0.00"}}]
["menos:"]
["IVA ACREDITABLE",{"$f":"SUM(B46:B47)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C46:C47)","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"$f":"SUM(B45:M45)","v":{"v":0,"d":"0.00"}}]
["IVA ACREDITABLE DEL MES",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B46:M46)","v":{"v":0,"d":"0.00"}}]
["IVA A FAVOR DE 2019",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B47:M47)","v":{"v":0,"d":"0.00"}}]
["menos:"]
["DEVOLUCIONES COMPENSACIONES",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B49:M49)","v":{"v":0,"d":"0.00"}}]
["igual:"]
["IVA POR PAGAR",{"$f":"+B39-B45+B49","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["menos:"]
["IVA PAGADO",{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(B53:M53)","v":{"v":0,"d":"0.00"}}]
["igual:"]
["DIFERENCIA MENSUAL",{"$f":"+B51-B53","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["igual:"]
["DIFERENCIA ACUMULADA",{"$f":"+B55","v":{"v":0,"d":"0.00"}},{"$f":"+B57+C55","v":{"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"},{"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"},{"v":0,"d":"0.00"},{"$f":"+M57","v":{"v":0,"d":"0.00"}}]