{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["PORTADA","MENU","IVA","FACTOR","PREOPERATIVO","FACTORPIA","FIVA","ART5B","INPC","DIOT","PAIS","DPIVA","DATOS"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":11,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PORTADA","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,29,9]]}

{"sheet":"MENU","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Tema","Hoja"]
[null,"Ejemplo determinación del IVA","IVA"]
[null,"Determinación del factor de prorrateo articulo 5 y 5-A LIVA","FACTOR"]
[null,"Factor de prorrateo articulo 5-B y contribuyentes que inicien actividades","FACTORPIA"]
[null,"Formato IVA","FIVA"]
[null,"Fundamento 5-B inicio de actividades","ART5B"]
[null,"Tabla INPC","INPC"]
[null,"Archivo TXT para DIOT","DIOT"]
[null,"Paises para DIOT","PAIS"]
[null,"DPIVA","DPIVA"]

{"sheet":"IVA","index":2,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,6,1,7]]}
[]
[null,null,null,"Las celdas de color",null,null,"contienen formulas"]
[]
[null,"Determinación de los pagos mensuales de IVA del ejercicio 2020"]
[]
[null,"No. de cuenta","Cuenta","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Acumulado"]
[null,null,"Base IVA exentos",null,null,null,null,"","","","","","","","",{"$f":"SUM(D7:O7)","v":0}]
[null,null,"Base IVA 0%",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0}]
[null,null,"Base IVA 8% frontera norte"]
[null,null,"Base IVA 16%",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Suma base IVA",{"$f":"SUM(D7:D10)","v":0},{"$f":"SUM(E7:E10)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:O11)","v":0}]
[null,null,"Suma base IVA 16%",{"$f":"D10","v":0},{"$f":"E10","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D12:O12)","v":0}]
[null,"Más","IEPS causado"]
[null,"Igual","Total base IVA 16%",{"$f":"D12+D13","v":0},{"$f":"E12+E13","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D14:O14)","v":0}]
[]
[null,null,"IVA TRASLADADO COBRADO",{"$f":"IFERROR(D12*0.16,0)","v":0},{"$f":"IFERROR(E12*0.16,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D16:O16)","v":0}]
[]
[null,null,"IVA ACREDITABLE PAGADO"]
[null,null,"IVA ACREDITABLE DE IMPORTACION"]
[]
[]
[null,"Igual","Saldo a favor",{"$f":"IFERROR(IF((D18+D19)>D16,SUM(D18:D19)-D16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF((E18+E19)>E16,SUM(E18:E19)-E16,\"\"),\"\")","v":""},"","","","","","","","","",{"$f":"IFERROR(IF((O18+O19)>O16,SUM(O18:O19)-O16,\"\"),\"\")","v":""},{"$f":"SUM(D22:O22)","v":0}]
[null,"Igual","Saldo a cargo",{"$f":"IFERROR(IF(D16>=SUM(D18:D19),D16-SUM(D18:D19),\"\"),\"\")","v":0},{"$f":"IFERROR(IF(E16>=SUM(E18:E19),E16-SUM(E18:E19),\"\"),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Menos:","Acreditamiento saldo a favor",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Igual:","IVA por pagar",{"$f":"IFERROR(D23-D24,\"\")","v":0},{"$f":"IFERROR(E23-E24,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"FACTOR","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,8,7,8],[20,1,20,3],[1,1,1,2],[6,1,6,2],[16,3,17,3],[14,1,14,3]]}
[]
[null,"Determinación del factor de prorrateo articulo 5 y 5-A LIVA"]
[]
[null,"Año de ajuste",2020]
[null,"Mes de ajuste","Febrero"]
[]
[null,"Datos del activo",null,null,null,"(1)","Total de actividades gravadas",null,{"$f":"IFERROR(H7/H8,0)","v":0}]
[null,"Descripción","maquinaria",null,null,null,"Total de actividades gravadas y exentas"]
[null,"Fecha de adquisición"]
[null,"MOI"]
[null,"% de deducción"]
[null,"IVA acreditable pagado",{"$f":"C10*0.16","v":0}]
[null,"Factor de prorrateo del año y mes de acreditamiento del IVA",{"$f":"I7","v":0},"(1)"]
[]
[null,{"$f":"\"Determinación del factor de prorrateo del mes de \" & C5 & \" de \"& C4","v":"Determinación del factor de prorrateo del mes de Febrero de 2020"}]
[]
[null,"Total de actividades gravadas",null,{"$f":"IFERROR(C17/C18,0)","v":0}]
[null,"Total de actividades gravadas y exentas"]
[]
[]
[null,"Determinación del ajuste"]
[]
[null,null,{"$f":"IFERROR(PROPER(TEXT(C9,\"MMMM\")) & \" \" & YEAR(C9),\"\")","v":"Enero 1900"}]
[null,{"$f":"IF(C8<>\"\",C8,\"No a capturado los datos\")","v":"maquinaria"},{"$f":"IF(C10<>\"\",C10,\"\")","v":""}]
[null,{"$f":"IF(C12<>\"\",B12,\"No a capturado los datos\")","v":"IVA acreditable pagado"},{"$f":"IF(C12<>\"\",C12,\"\")","v":0}]
[]
[null,{"$f":"IF(C13<>\"\",B13,\"No a capturado los datos\")","v":"Factor de prorrateo del año y mes de acreditamiento del IVA"},{"$f":"IF(C13<>\"\",C13,\"\")","v":0},"(1)"]
[]
[null,{"$f":"IF(C27<>\"\",\"IVA acreditaple en proporción\")","v":"IVA acreditaple en proporción"},{"$f":"IFERROR(C25*C27,\"\")","v":0}]
[]
[null,null,null,null,{"$f":"C5&\" \" &C4","v":"Febrero 2020"}]
[]
[null,{"$f":"B25","v":"IVA acreditable pagado"},{"$f":"C25","v":0},null,{"$f":"C25","v":0}]
["(X)","% máximo de depreciación para ISR",{"$f":"C11","v":0},null,{"$f":"C34","v":0}]
["(=)","Monto obtenido inciso a)",{"$f":"IFERROR(C33*C34,\"\")","v":0},null,{"$f":"IFERROR(E33*E34,\"\")","v":0}]
[null,"Entre;",12,null,12]
["(=)","Resultado inciso b)",{"$f":"IFERROR(C35/C36,\"\")","v":0},null,{"$f":"IFERROR(E35/E36,\"\")","v":0}]
["(x)","Proporción de acreditamiento aplicada",{"$f":"C27","v":0},"(1)",{"$f":"IF(OR((C27-D17)>0.03,(D17-C27)>0.03),D17,0)","v":0}]
["(=)","Moto determinado inciso c)",{"$f":"IFERROR(C37*C38,\"\")","v":0}]
[null,"MONTO DETERMINADO INCISO d)",null,null,{"$f":"IFERROR(E37*E38,\"\")","v":0}]
[]
[]
[null,"IVA a reintegrarse derivado del ajuste"]
[null,{"$f":"B39","v":"Moto determinado inciso c)"},null,{"$f":"IF(C38>E38,C39,\"\")","v":""}]
["(-)","Monto determinado inciso d)",null,{"$f":"IF(C38>E38,E40,\"\")","v":""}]
["(=)","IVA a reintegrarse",null,{"$f":"IFERROR(D44-D45,\"\")","v":""}]
["(x)","Factor de actualización",null,{"$f":"IFERROR(IF((C48/C49)<1,1,TRUNC(C48/C49,4)),\"\")","v":""}]
[null,{"$f":"\"INPC \" & C5 & \" \"&C4","v":"INPC Febrero 2020"},{"$f":"IFERROR(IF(D44<>\"\",INDEX(TINPC,MATCH(C4,INPCA,0),MATCH(C5,INPCM,0)),\"\"),\"\")","v":""}]
[null,{"$f":"\"INPC \" & PROPER(TEXT(C9,\"MMMM\")) & \" \" & YEAR(C9)","v":"INPC Enero 1900"},{"$f":"IFERROR(IF(D44<>\"\",INDEX(TINPC,MATCH(YEAR(C9),INPCA,0),MATCH(PROPER(TEXT(C9,\"MMMM\")),INPCM,0)),\"\"),\"\")","v":""}]
[null,"IVA a reintegrarse actualizado (fracción I)",null,{"$f":"IFERROR(D46*D47,\"\")","v":""}]
[]
[]
[null,"IVA acreditable derivado del ajuste"]
[null,"Monto determinado inciso d)",null,{"$f":"IF(E38>C38,E40,\"\")","v":""}]
["(-)",{"$f":"B50","v":"IVA a reintegrarse actualizado (fracción I)"},null,{"$f":"IF(E38>C38,C39,\"\")","v":""}]
["(=)","IVA a acreditarse",null,{"$f":"IFERROR(D54-D55,\"\")","v":""}]
["(x)","Factor de actualización",null,{"$f":"IFERROR(IF((C58/C59)<1,1,TRUNC(C58/C59,4)),\"\")","v":""}]
[null,{"$f":"\"INPC \" & C5 & \" \"&C4","v":"INPC Febrero 2020"},{"$f":"IFERROR(IF(D54<>\"\",INDEX(TINPC,MATCH(C4,INPCA,0),MATCH(C5,INPCM,0)),\"\"),\"\")","v":""}]
[null,{"$f":"\"INPC \" & PROPER(TEXT(C9,\"MMMM\")) & \" \" & YEAR(C9)","v":"INPC Enero 1900"},{"$f":"IFERROR(IF(D54<>\"\",INDEX(TINPC,MATCH(YEAR(C9),INPCA,0),MATCH(PROPER(TEXT(C9,\"MMMM\")),INPCM,0)),\"\"),\"\")","v":""}]
[null,"IVA a acreditarse actualizado (fracción II)",null,{"$f":"IFERROR(D56*D57,\"\")","v":""}]

{"sheet":"PREOPERATIVO","index":4,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,2,3,3],[3,4,3,5],[3,7,3,8],[32,5,33,5],[27,5,28,5]]}
[]
[null,"Solo capture las celdas en color"]
[]
[null,null,"Inicial",null,"Final",null,null,"Inicio actividades"]
[null,null,"Mes","Año","Mes","Año",null,"Mes","Año"]
[null,"Periodo preoperativo"]
[]
[]
[null,"Relación de erogaciones en periodo preoperativo"]
[]
[null,"Año","Mes","Importe","IVA pagado","Proporción aplicada","IVA acreditable","INPC inicio actividades","INPC mes en que se pago el IVA","Factor de actualizaciòn","IVA acreditable actualizado","Actualización"]
[null,{"$f":"IF(C12<>\"\",IF(VLOOKUP($C$6,MESESP,2,FALSE)>VLOOKUP(C12,MESESP,2,FALSE),$F$6,$D$6),\"\")","v":""},{"$f":"IF(C6<>\"\",C6,\"\")","v":""},null,null,{"$f":"IF(B12<>\"\",$F$28,\"\")","v":""},{"$f":"IF(D12<>\"\",E12*F12,\"\")","v":""},{"$f":"IF(B12<>\"\",IFERROR(INDEX(TINPC,MATCH($I$6,INPCA,0),MATCH($H$6,INPCM,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C12=\"Enero\",INDEX(TINPC,MATCH(B12-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B12,INPCA,0),MATCH(C12,INPCM,0))),\"\")","v":""},{"$f":"IFERROR(IF((H12/I12)<1,1,TRUNC(H12/I12,4)),\"\")","v":""},{"$f":"IF(B12<>\"\",IFERROR(G12*J12,\"\"),\"\")","v":""},{"$f":"IF(B12<>\"\",IFERROR(K12-E12,\"\"),\"\")","v":""}]
[null,"",{"$f":"IFERROR(IF(AND(C12<>\"\",PROPER(TEXT(DATE($D$6,VLOOKUP(C12,MESESP,2,FALSE)+1,1),\"MMMM\"))<>PROPER(TEXT(DATE($D$6,VLOOKUP($E$6,MESESP,2,FALSE)+1,1),\"MMMM\"))),PROPER(TEXT(DATE($D$6,VLOOKUP(C12,MESESP,2,FALSE)+1,1),\"MMMM\")),\"\"),\"\")","v":""},null,null,{"$f":"IF(B13<>\"\",$F$28,\"\")","v":""},{"$f":"IF(D13<>\"\",E13*F13,\"\")","v":""},"",{"$f":"IFERROR(IF(C13=\"Enero\",INDEX(TINPC,MATCH(B13-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B13,INPCA,0),MATCH(C13,INPCM,0))),\"\")","v":""},{"$f":"IFERROR(IF((H13/I13)<1,1,TRUNC(H13/I13,4)),\"\")","v":""},{"$f":"IF(B13<>\"\",IFERROR(G13*J13,\"\"),\"\")","v":""},{"$f":"IF(B13<>\"\",IFERROR(K13-E13,\"\"),\"\")","v":""}]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C14=\"Enero\",INDEX(TINPC,MATCH(B14-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B14,INPCA,0),MATCH(C14,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C15=\"Enero\",INDEX(TINPC,MATCH(B15-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B15,INPCA,0),MATCH(C15,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C16=\"Enero\",INDEX(TINPC,MATCH(B16-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B16,INPCA,0),MATCH(C16,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C17=\"Enero\",INDEX(TINPC,MATCH(B17-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B17,INPCA,0),MATCH(C17,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C18=\"Enero\",INDEX(TINPC,MATCH(B18-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B18,INPCA,0),MATCH(C18,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C19=\"Enero\",INDEX(TINPC,MATCH(B19-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B19,INPCA,0),MATCH(C19,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"","","",{"$f":"IFERROR(IF(C20=\"Enero\",INDEX(TINPC,MATCH(B20-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B20,INPCA,0),MATCH(C20,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"",null,"",{"$f":"IFERROR(IF(C21=\"Enero\",INDEX(TINPC,MATCH(B21-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B21,INPCA,0),MATCH(C21,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,"",null,"",{"$f":"IFERROR(IF(C22=\"Enero\",INDEX(TINPC,MATCH(B22-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B22,INPCA,0),MATCH(C22,INPCM,0))),\"\")","v":""},"","",""]
[null,"","",null,null,null,null,"",{"$f":"IFERROR(IF(C23=\"Enero\",INDEX(TINPC,MATCH(B23-1,INPCA,0),MATCH(\"Diciembre\",INPCM,0)),INDEX(TINPC,MATCH(B23,INPCA,0),MATCH(C23,INPCM,0))),\"\")","v":""},"",{"$f":"IF(B23<>\"\",IFERROR(#REF!*J23,\"\"),\"\")","v":""},""]
[null,"Total",{"$f":"IFERROR(IF(AND(C23<>\"\",PROPER(TEXT(DATE($D$6,VLOOKUP(C23,MESESP,2,FALSE)+1,1),\"MMMM\"))<>$E$6),PROPER(TEXT(DATE($D$6,VLOOKUP(C23,MESESP,2,FALSE)+1,1),\"MMMM\")),\"\"),\"\")","v":""},null,{"$f":"SUM(E12:E23)","v":0},null,null,null,null,null,{"$f":"SUM(K12:K23)","v":0},0]
[]
[null,"Proporción determinada en el inicio de actividades"]
[]
[null,"Total de actividades gravadas en el periodo de inicio de actividades",null,null,null,{"$f":"IFERROR(E28/E29,0)","v":0}]
[null,"Total de actividades gravadas + exentas del periodo de inicio de actividedes"]
[]
[null,"Ajuste doceavo mes contado apartir del mes posterior siguiente al de inicio de actividades"]
[]
[null,"Total de actividades gravadas del periodo de ajuste",null,null,null,{"$f":"IFERROR(E33/E34,0)","v":0}]
[null,"Total de actividades gravadas y exentas del periodo de ajuste"]
[]
[]
[]
[]
[null,"Año","Mes en que se acredito o solicito la devoluciòn","IVA acreditado","IVA que se debió acreditar","IVA a reintegrar derivado del ajuste","IVA a acreditar derivado del ajuste","INPC en que se acredito o solicito la devolución","INPC del mes en que se presenta la declaraciòn del ajuste","Factor de actualizaciòn","IVA a reintegrar derivado del ajuste actualizado","IVA a acreditar derivado del ajues actualizado"]
[null,null,null,null,{"$f":"K24*F33","v":0},{"$f":"IF(B40<>\"\",IF(D40>E40,D40-E40,\"\"),\"\")","v":""},{"$f":"IF(B40<>\"\",IF(D40<E40,D40-E40,\"\"),\"\")","v":""},{"$f":"IFERROR(INDEX(TINPC,MATCH(B40,INPCA,0),MATCH(C40,INPCM,0)),\"\")","v":""},null,{"$f":"IFERROR(IF((I40/H40)<1,1,TRUNC(I40/H40,4)),\"\")","v":""},{"$f":"IFERROR(IF(F40<>\"\",F40*J40,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G40<>\"\",G40*J40,\"\"),\"\")","v":""}]

{"sheet":"FACTORPIA","index":5,"n_rows":114,"n_cols":12,"rows_kept":114,"cut":false,"hidden":false,"merged":[[79,1,79,3],[91,11,92,11],[96,1,96,2],[106,1,106,2],[5,3,5,7],[20,3,20,7],[52,2,52,3],[69,1,69,2],[67,1,67,2]]}
[]
[null,null,"Factor de prorrateo articulo 5-B contribuyentes que inicien actividades"]
[]
[null,null,"Año de inicio de actividades",2020]
[]
[null,null,null,"Actividades"]
[null,"Mes de inicio de actividades","Mes año de inicio de actividades","Al 0%","Al 16%","Total gravadas","Exentas","Total G+E"]
[null,null,"Enero",null,null,{"$f":"IFERROR(SUM(D8:E8),\"\")","v":0},null,{"$f":"SUMIF(F8:G8,\">0\")","v":0},{"$f":"IF(COUNTA($B$8:B8)=1,1+IF(I7<>\"\",I7,0),\"\")","v":""}]
[null,null,"Febrero",null,null,{"$f":"IFERROR(SUM(D9:E9),\"\")","v":0},null,{"$f":"SUMIF(F9:G9,\">0\")","v":0},{"$f":"IF(COUNTA($B$8:B9)=1,1+IF(I8<>\"\",I8,0),\"\")","v":""}]
[null,null,"Marzo",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B10)=1,1+IF(I9<>\"\",I9,0),\"\")","v":""}]
[null,null,"Abril",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B11)=1,1+IF(I10<>\"\",I10,0),\"\")","v":""}]
[null,null,"Mayo",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B12)=1,1+IF(I11<>\"\",I11,0),\"\")","v":""}]
[null,null,"Junio",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B13)=1,1+IF(I12<>\"\",I12,0),\"\")","v":""}]
[null,null,"Julio",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B14)=1,1+IF(I13<>\"\",I13,0),\"\")","v":""}]
[null,null,"Agosto",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B15)=1,1+IF(I14<>\"\",I14,0),\"\")","v":""}]
[null,null,"Septiembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B16)=1,1+IF(I15<>\"\",I15,0),\"\")","v":""}]
[null,null,"Octubre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B17)=1,1+IF(I16<>\"\",I16,0),\"\")","v":""}]
[null,null,"Noviembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B18)=1,1+IF(I17<>\"\",I17,0),\"\")","v":""}]
[null,null,"Diciembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B19)=1,1+IF(I18<>\"\",I18,0),\"\")","v":""}]
[]
[null,null,null,"Actividades"]
[null,null,"Mes año siguiente de inicio de actividades","Al 0%","Al 16%","Total gravadas","Exentas","Total G+E"]
[null,null,"Enero",null,null,{"$f":"IFERROR(SUM(D23:E23),\"\")","v":0},null,{"$f":"SUMIF(F23:G23,\">0\")","v":0},{"$f":"IF(COUNTA($B$8:B23)=1,1+IF(I19<>\"\",I19,0),\"\")","v":""}]
[null,null,"Febrero",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B24)=1,1+IF(I23<>\"\",I23,0),\"\")","v":""}]
[null,null,"Marzo",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B25)=1,1+IF(I24<>\"\",I24,0),\"\")","v":""}]
[null,null,"Abril",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B26)=1,1+IF(I25<>\"\",I25,0),\"\")","v":""}]
[null,null,"Mayo",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B27)=1,1+IF(I26<>\"\",I26,0),\"\")","v":""}]
[null,null,"Junio",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B28)=1,1+IF(I27<>\"\",I27,0),\"\")","v":""}]
[null,null,"Julio",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B29)=1,1+IF(I28<>\"\",I28,0),\"\")","v":""}]
[null,null,"Agosto",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B30)=1,1+IF(I29<>\"\",I29,0),\"\")","v":""}]
[null,null,"Septiembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B31)=1,1+IF(I30<>\"\",I30,0),\"\")","v":""}]
[null,null,"Octubre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B32)=1,1+IF(I31<>\"\",I31,0),\"\")","v":""}]
[null,null,"Noviembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B33)=1,1+IF(I32<>\"\",I32,0),\"\")","v":""}]
[null,null,"Diciembre",null,null,0,null,0,{"$f":"IF(COUNTA($B$8:B34)=1,1+IF(I33<>\"\",I33,0),\"\")","v":""}]
[]
[]
[]
[null,null,"Factor de prorrateo para compras y gastos "]
[]
[null,"Año de inicio","Mes del año de inicio de actividades","Factor"]
[null,{"$f":"IF($D$4<>\"\",$D$4,\"\")","v":2020},"Enero",{"$f":"IFERROR(TRUNC(SUM($F$8:F8)/SUM($H$8:H8),4),\"\")","v":""}]
[null,{"$f":"IF($D$4<>\"\",$D$4,\"\")","v":2020},"Febrero",{"$f":"IFERROR(TRUNC(SUM($F$8:F9)/SUM($H$8:H9),4),\"\")","v":""}]
[null,2020,"Marzo",{"$f":"IFERROR(TRUNC(SUM($F$8:F10)/SUM($H$8:H10),4),\"\")","v":""}]
[null,2020,"Abril",{"$f":"IFERROR(TRUNC(SUM($F$8:F11)/SUM($H$8:H11),4),\"\")","v":""}]
[null,2020,"Mayo",{"$f":"IFERROR(TRUNC(SUM($F$8:F12)/SUM($H$8:H12),4),\"\")","v":""}]
[null,2020,"Junio",{"$f":"IFERROR(TRUNC(SUM($F$8:F13)/SUM($H$8:H13),4),\"\")","v":""}]
[null,2020,"Julio",{"$f":"IFERROR(TRUNC(SUM($F$8:F14)/SUM($H$8:H14),4),\"\")","v":""}]
[null,2020,"Agosto",{"$f":"IFERROR(TRUNC(SUM($F$8:F15)/SUM($H$8:H15),4),\"\")","v":""}]
[null,2020,"Septiembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F16)/SUM($H$8:H16),4),\"\")","v":""}]
[null,2020,"Octubre",{"$f":"IFERROR(TRUNC(SUM($F$8:F17)/SUM($H$8:H17),4),\"\")","v":""}]
[null,2020,"Noviembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F18)/SUM($H$8:H18),4),\"\")","v":""}]
[null,2020,"Diciembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F19)/SUM($H$8:H19),4),\"\")","v":""}]
[null,"Año de inicio","Mes año siguiente de inicio de actividades"]
[null,{"$f":"IF($D$4<>\"\",$D$4+1,\"\")","v":2021},"Enero",{"$f":"IFERROR(TRUNC(SUM($F$8:F23)/SUM($H$8:H23),4),\"\")","v":""}]
[null,{"$f":"IF($D$4<>\"\",$D$4+1,\"\")","v":2021},"Febrero",{"$f":"IFERROR(TRUNC(SUM($F$8:F24)/SUM($H$8:H24),4),\"\")","v":""}]
[null,2021,"Marzo",{"$f":"IFERROR(TRUNC(SUM($F$8:F25)/SUM($H$8:H25),4),\"\")","v":""}]
[null,2021,"Abril",{"$f":"IFERROR(TRUNC(SUM($F$8:F26)/SUM($H$8:H26),4),\"\")","v":""}]
[null,2021,"Mayo",{"$f":"IFERROR(TRUNC(SUM($F$8:F27)/SUM($H$8:H27),4),\"\")","v":""}]
[null,2021,"Junio",{"$f":"IFERROR(TRUNC(SUM($F$8:F28)/SUM($H$8:H28),4),\"\")","v":""}]
[null,2021,"Julio",{"$f":"IFERROR(TRUNC(SUM($F$8:F29)/SUM($H$8:H29),4),\"\")","v":""}]
[null,2021,"Agosto",{"$f":"IFERROR(TRUNC(SUM($F$8:F30)/SUM($H$8:H30),4),\"\")","v":""}]
[null,2021,"Septiembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F31)/SUM($H$8:H31),4),\"\")","v":""}]
[null,2021,"Octubre",{"$f":"IFERROR(TRUNC(SUM($F$8:F32)/SUM($H$8:H32),4),\"\")","v":""}]
[null,2021,"Noviembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F33)/SUM($H$8:H33),4),\"\")","v":""}]
[null,2021,"Diciembre",{"$f":"IFERROR(TRUNC(SUM($F$8:F34)/SUM($H$8:H34),4),\"\")","v":""}]
[]
[]
[null,"Ajuste doceavo mes solo para inversiones"]
[]
[null,"Datos del activo"]
[null,"Descripción"]
[null,"Fecha de adquisición"]
[null,"MOI"]
[null,"% de deducción"]
[null,"IVA acreditable pagado"]
[null,"Factor prorrateo"]
[]
[]
[]
[null,"Determinación del ajuste"]
[]
[null,null,{"$f":"IFERROR(PROPER(TEXT(C68,\"MMMM\")) & \" \" & YEAR(C68),\"\")","v":"Enero 1900"}]
[null,{"$f":"IF(C71<>\"\",C71,\"No a capturado los datos\")","v":"No a capturado los datos"},{"$f":"IF(C73<>\"\",C73,\"\")","v":""}]
[null,{"$f":"IF(C75<>\"\",B75,\"No a capturado los datos\")","v":"No a capturado los datos"},{"$f":"IF(C75<>\"\",C75,\"\")","v":""}]
[]
[null,{"$f":"IF(B76<>\"\",B76,\"No a capturado los datos\")","v":"Factor prorrateo"},{"$f":"IF(C76<>\"\",C76,\"\")","v":""}]
[]
[null,{"$f":"IF(C86<>\"\",\"IVA acreditaple en proporción\",\"\")","v":""},{"$f":"IFERROR(C84*C86,\"\")","v":""}]
[]
[null,null,"IVA acreditable aplicado de adquisición",null,"IVA acreditable en el mes de ajuste"]
[null,null,null,null,null,null,"(1)"]
[null,{"$f":"B84","v":"No a capturado los datos"},{"$f":"C84","v":""},null,{"$f":"C84","v":""},null,"Total de actividades gravadas del periodo de ajuste",null,null,null,{"$f":"SUMIFS(F8:F34,I8:I34,\">=1\",I8:I34,\"<=12\")","v":0},{"$f":"IFERROR(K92/K93,0)","v":0}]
["(X)","Factor de prorrateo",{"$f":"IFERROR(C86,\"\")","v":""},null,{"$f":"L92","v":0},"(1)","Total de actividades gravadas y exentas del periodo de ajuste",null,null,null,{"$f":"SUMIFS(H8:H34,I8:I34,\">=1\",I8:I34,\"<=12\")","v":0}]
["(=)","IVA que se acredito",{"$f":"IFERROR(C92*C93,\"\")","v":""},null,{"$f":"IFERROR(E92*E93,\"\")","v":""}]
[]
[]
[null,"IVA a reintegrarse derivado del ajuste (solo cuando varie en + 3%)"]
[null,"IVA acreditable en la fecha de adquisición",null,{"$f":"IFERROR(IF((C93-E93)>3%,C94,\"\"),\"\")","v":""}]
["(-)","IVA que se debio acreditar en el periodo del ajuste",null,{"$f":"IF(D98<>\"\",E94,\"\")","v":""}]
["(=)","IVA a reintegrarse",null,{"$f":"IFERROR(D98-D99,\"\")","v":""}]
["(x)","Factor de actualización",null,{"$f":"IFERROR(IF((C102/C103)<1,1,TRUNC(C102/C103,4)),\"\")","v":""}]
[null,{"$f":"IFERROR(\"INPC \" &VLOOKUP(11,CHOOSE({2,1},MESAJUSTE,AJUSTE),2,FALSE) & \" \"&D4+1,\"\")","v":""},{"$f":"IFERROR(IF(D100<>\"\",INDEX(TINPC,MATCH(D4+1,INPCA,0),MATCH(VLOOKUP(11,CHOOSE({2,1},MESAJUSTE,AJUSTE),2,FALSE),INPCM,0)),\"\"),\"\")","v":""}]
[null,{"$f":"\"INPC \" & PROPER(TEXT(C72,\"MMMM\")) & \" \" & YEAR(C72)","v":"INPC Enero 1900"},{"$f":"IFERROR(IF(D100<>\"\",INDEX(TINPC,MATCH(D4+1,INPCA,0),MATCH(PROPER(TEXT(C72,\"MMMM\")),INPCM,0)),\"\"),\"\")","v":""}]
[null,"IVA a reintegrarse actualizado (fracción I)",null,{"$f":"IFERROR(D100*D101,\"\")","v":""}]
[]
[]
[null,"IVA acreditable derivado del ajuste (solo cuando varie en + 3%)"]
[null,"IVA acreditable en la fecha de adquisición",null,{"$f":"IFERROR(IF((E93-C93)>3%,C94,\"\"),\"\")","v":""}]
["(-)","IVA que se debio acreditar en el periodo del ajuste",null,{"$f":"IF(D108<>\"\",E104,\"\")","v":""}]
["(=)","IVA a acreditarse",null,{"$f":"IFERROR(D108-D109,\"\")","v":""}]
["(x)","Factor de actualización",null,{"$f":"IFERROR(IF((C112/C113)<1,1,TRUNC(C112/C113,4)),\"\")","v":""}]
[null,{"$f":"IFERROR(\"INPC \" &VLOOKUP(11,CHOOSE({2,1},MESAJUSTE,AJUSTE),2,FALSE) & \" \"&D4+1,\"\")","v":""},{"$f":"IFERROR(IF(D110<>\"\",INDEX(TINPC,MATCH(D4+1,INPCA,0),MATCH(VLOOKUP(11,CHOOSE({2,1},MESAJUSTE,AJUSTE),2,FALSE),INPCM,0)),\"\"),\"\")","v":""}]
[null,{"$f":"\"INPC \" & PROPER(TEXT(C72,\"MMMM\")) & \" \" & YEAR(C72)","v":"INPC Enero 1900"},{"$f":"IFERROR(IF(D110<>\"\",INDEX(TINPC,MATCH(D4+1,INPCA,0),MATCH(PROPER(TEXT(C72,\"MMMM\")),INPCM,0)),\"\"),\"\")","v":""}]
[null,"IVA a acreditarse actualizado (fracción II)",null,{"$f":"IFERROR(D110*D111,\"\")","v":""}]

{"sheet":"FIVA","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ART5B","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INPC","index":8,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tabla INPC nueva Base 2Q Julio 2018 = 100"]
[]
[null,"Año","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Año"]
[null,2020,106.447,106.889,106.83799999999999,105.755]
[null,2019,103.108,103.07899999999999,103.476,103.53100000000001,103.233,103.29900000000001,103.687,103.67,103.94199999999999,104.503,105.346,105.934,2019]
[null,2018,98.795000000000002,99.171374,99.492157000000006,99.154847000000004,98.994079999999997,99.376464999999996,99.909000000000006,100.492,100.917,101.44,102.303,103.02,2018]
[null,2017,93.603881999999999,94.144779999999997,94.722488999999996,94.838932999999997,94.725493999999998,94.963639999999998,95.322736000000006,95.793768,96.093514999999996,96.698268999999996,97.695173999999994,98.272882999999993,2017]
[null,2016,89.386381,89.777781000000004,89.910000999999994,89.625277999999994,89.225615000000005,89.324027999999998,89.556914000000006,89.809332999999995,90.357743999999997,90.906154000000001,91.616833999999997,92.039034999999998,2016]
[null,2015,87.110102999999995,87.275377000000006,87.630717000000004,87.403840000000002,86.967365999999998,87.113107999999997,87.240819999999999,87.424875,87.752419000000003,88.203918999999999,88.685468,89.046818000000002,2015]
[null,2014,84.519052000000002,84.733157000000006,84.965292000000005,84.806779000000006,84.535578999999998,84.682072000000005,84.914958999999996,85.219965000000002,85.596339999999998,86.069626,86.763778000000002,87.188984000000005,2014]
[null,2013,80.892781999999997,81.290942999999999,81.887433000000001,81.941523000000004,81.668819999999997,81.619237999999996,81.592192999999995,81.824327999999994,82.132339999999999,82.522987999999998,83.292265,83.770058000000006,2013]
[null,2012,78.343048999999993,78.502313999999998,78.547388999999995,78.300979999999996,78.053819000000004,78.413667000000004,78.853897000000003,79.090540000000004,79.439119000000005,79.841036000000003,80.383437000000001,80.568242999999995,2012]
[null,2011,75.295991000000001,75.578460000000007,75.723450999999997,75.717440999999994,75.159263999999993,75.155507999999998,75.516107000000005,75.635554999999997,75.821112999999997,76.332712000000001,77.158332999999999,77.792384999999996,2011]
[null,2010,72.552046000000004,72.971671000000001,73.489725000000007,73.255565000000004,72.793977999999996,72.771182999999994,72.929190000000006,73.131749999999997,73.515110000000007,73.968925999999996,74.561581000000004,74.930954,2010]
[null,2009,69.456148999999996,69.609493999999998,70.009950000000003,70.254990000000006,70.050358000000003,70.179354000000004,70.370515999999995,70.538883999999996,70.892715999999993,71.107191,71.476045999999997,71.771855000000002,2009]
[null,2008,65.350564000000006,65.544833999999994,66.019891000000001,66.170126999999994,66.098635000000002,66.372168000000002,66.742058999999998,67.127492000000004,67.584935000000002,68.045485999999997,68.818942000000007,69.295552000000001,2008]
[null,2007,63.016207999999999,63.192346999999998,63.329113,63.291294999999998,62.982534000000001,63.058169999999997,63.326005000000002,63.583995999999999,64.077703,64.327404999999999,64.781221000000002,65.049055999999993,2007]
[null,2006,60.603625999999998,60.696357999999996,60.772511999999999,60.861617000000003,60.590674999999997,60.642997999999999,60.809294000000001,61.119608999999997,61.736612000000001,62.006518999999997,62.331856999999999,62.692424000000003,2006]
[null,2005,58.309159999999999,58.503430999999999,58.767121000000003,58.976415000000003,58.828251000000002,58.771782999999999,59.001800000000003,59.072254999999998,59.309005999999997,59.45458,59.882492999999997,60.250312000000001,2005]
[null,2004,55.774317000000003,56.107945000000001,56.298071,56.383032,56.241602999999998,56.331744999999998,56.479390000000002,56.828040999999999,57.297916999999998,57.694747,58.186898999999997,58.307088,2004]
[null,2003,53.525441000000001,53.674121999999997,54.012929999999997,54.105144000000003,53.93056,53.975112000000003,54.053339000000001,54.215490000000003,54.538238,54.738207000000003,55.192542000000003,55.429811000000001,2003]
[null,2002,50.900472000000001,50.867750000000001,51.127948000000004,51.407235,51.511429,51.762585999999999,51.911180999999999,52.108559999999997,52.421984000000002,52.653036,53.078876999999999,53.309930000000001,2002]
[null,2001,48.575476000000002,48.543328000000002,48.850887999999998,49.097309000000003,49.209969999999998,49.326363999999998,49.198202000000002,49.489688000000001,49.950381,50.176135000000002,50.365149000000002,50.434899000000001,2001]
[null,2000,44.93083,45.32938,45.580680999999998,45.840018000000001,46.011378999999998,46.283920000000002,46.464466000000002,46.719785000000002,47.061072000000003,47.385136000000003,47.790287999999997,48.307670999999999,2000]
[null,1999,40.469769999999997,41.013643000000002,41.394683999999998,41.774577000000001,42.025877000000001,42.302005999999999,42.581580000000002,42.821255000000001,43.235017999999997,43.508851,43.895775999999998,44.335515999999998,1999]
[null,1998,34.003923999999998,34.599238,35.004533000000002,35.332042000000001,35.613481,36.034419999999997,36.381878,36.731631999999998,37.327376000000001,37.862268999999998,38.532786000000002,39.472974000000001,1998]
[null,1997,29.498885999999999,29.994598,30.367889000000002,30.695972000000001,30.976119000000001,31.250957,31.523211,31.803502000000002,32.199612999999999,32.456941,32.820042000000001,33.279874999999997,1997]
[null,1996,23.329754000000001,23.874262000000002,24.399826000000001,25.093450000000001,25.550841999999999,25.966902000000001,26.336030999999998,26.686071999999999,27.112750999999999,27.451167999999999,27.867083000000001,28.759336000000001,1996]
[null,1995,15.376991,16.028707000000001,16.973617000000001,18.326132999999999,19.092089999999999,19.698024,20.099588000000001,20.432981000000002,20.855643000000001,21.284762000000001,21.809608000000001,22.520167000000001,1995]
[null,1994,13.950374999999999,14.022124,14.094225,14.163251000000001,14.231681999999999,14.302894999999999,14.366327,14.433287,14.535937000000001,14.612245,14.690360999999999,14.819203999999999,1994]
[null,1993,12.977320000000001,13.083345,13.159594,13.235480000000001,13.311137,13.385797,13.450123,13.522112,13.622261,13.677973,13.738301999999999,13.843055,1993]
[null,1992,11.657778,11.7959,11.915948,12.022171,12.101438,12.183344999999999,12.260272000000001,12.335592,12.442897,12.532494,12.636620000000001,12.816553000000001,1992]
[null,1991,9.8838799999999996,10.056425000000001,10.19984,10.306687999999999,10.407442,10.516648,10.609584,10.683422999999999,10.789849999999999,10.915343,11.186374000000001,11.449680000000001,1991]
[null,1990,7.7760369999999996,7.9521199999999999,8.0923099999999994,8.2154720000000001,8.3588380000000004,8.5429390000000005,8.6987349999999992,8.8469499999999996,8.9730609999999995,9.1020599999999998,9.3437230000000007,9.6382139999999996,1990]
[null,1989,6.349024,6.4351839999999996,6.5049450000000002,6.6022239999999996,6.6930990000000001,6.7743849999999997,6.8421479999999999,6.9073330000000004,6.9733929999999997,7.0765250000000002,7.1758550000000003,7.4180299999999999,1989]
[null,1988,4.7182459999999997,5.111783,5.3735470000000003,5.5389410000000003,5.646109,5.7612920000000001,5.8574570000000001,5.9113429999999996,5.9451390000000002,5.9904859999999998,6.0706540000000002,6.1973159999999998,1988]
[null,1987,1.7044010000000001,1.827386,1.948153,2.1186060000000002,2.2783250000000002,2.443146,2.641022,2.8568720000000001,3.0450810000000001,3.298845,3.560511,4.086392,1987]
[null,1986,0.83409199999999994,0.871174,0.91166700000000001,0.95926299999999998,1.01257,1.0775669999999999,1.1313329999999999,1.2215309999999999,1.2948120000000001,1.368824,1.4613039999999999,1.576735,1986]
[null,1985,0.50271100000000002,0.52359599999999995,0.54388499999999995,0.56062100000000004,0.57390200000000002,0.58827600000000002,0.60876300000000005,0.63537699999999997,0.66075200000000001,0.68585200000000002,0.71749499999999999,0.76634000000000002,1985]
[null,1984,0.31272800000000001,0.32923200000000002,0.343304,0.35815599999999997,0.37003200000000003,0.38342300000000001,0.39599299999999998,0.40724900000000003,0.41937999999999998,0.43403399999999998,0.44892900000000002,0.46799600000000002,1984]
[null,1983,0.18035499999999999,0.19003400000000001,0.19923199999999999,0.21184600000000001,0.22103400000000001,0.229404,0.24074599999999999,0.25009100000000001,0.25778699999999999,0.26634099999999999,0.28198299999999998,0.294047,1983]
[null,1982,8.5865999999999998E-2,8.924E-2,9.2498999999999998E-2,9.7512000000000001E-2,0.102993,0.10795399999999999,0.11351700000000001,0.12625600000000001,0.132995,0.13988999999999999,0.14696300000000001,0.162656,1982]
[null,1981,6.5615000000000007E-2,6.7226999999999995E-2,6.8665000000000004E-2,7.0212999999999998E-2,7.1275000000000005E-2,7.2271000000000002E-2,7.3543999999999998E-2,7.5060000000000002E-2,7.6455999999999996E-2,7.8153E-2,7.9657000000000006E-2,8.1800999999999999E-2,1981]
[null,1980,5.1341999999999999E-2,5.2528999999999999E-2,5.3609999999999998E-2,5.4546999999999998E-2,5.5437E-2,5.6536000000000003E-2,5.8115E-2,5.9318999999999997E-2,5.9977999999999997E-2,6.0886000000000003E-2,6.1941999999999997E-2,6.3566999999999999E-2,1980]
[null,1979,4.2236999999999997E-2,4.2845000000000001E-2,4.3425999999999999E-2,4.3815E-2,4.4388999999999998E-2,4.4880999999999997E-2,4.5425E-2,4.6112E-2,4.6677999999999997E-2,4.7493E-2,4.8104000000000001E-2,4.8956E-2,1979]
[null,1978,3.5892E-2,3.6408000000000003E-2,3.6787E-2,3.7196E-2,3.7560000000000003E-2,3.8077E-2,3.8723E-2,3.9108999999999998E-2,3.9555E-2,4.0034E-2,4.0446000000000003E-2,4.0788999999999999E-2,1978]
[null,1977,3.0027000000000002E-2,3.0689999999999999E-2,3.1224999999999999E-2,3.1697000000000003E-2,3.1975999999999997E-2,3.2368000000000001E-2,3.2733999999999999E-2,3.3404999999999997E-2,3.3998E-2,3.4257999999999997E-2,3.4632000000000003E-2,3.5111999999999997E-2,1977]
[null,1976,2.3318999999999999E-2,2.3754999999999998E-2,2.3987999999999999E-2,2.4156E-2,2.4324999999999999E-2,2.4423E-2,2.4629000000000002E-2,2.4865000000000002E-2,2.5713E-2,2.7161000000000001E-2,2.8388E-2,2.9100000000000001E-2,1976]
[null,1975,2.0816000000000001E-2,2.0931000000000002E-2,2.1062999999999998E-2,2.1240999999999999E-2,2.1524999999999999E-2,2.1891000000000001E-2,2.2065999999999999E-2,2.2256999999999999E-2,2.2419000000000001E-2,2.2533999999999998E-2,2.2692E-2,2.2877000000000002E-2,1975]

{"sheet":"DIOT","index":9,"n_rows":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,22],[5,1,5,4],[5,5,5,6],[6,1,6,4]]}
[]
[null,{"$f":"COUNTA(B11:B65000)","v":0}]
[]
[null,null,null,"Mes a generar",null,"Año a generar"]
[]
[]
[]
[null,"Campo 1","Campo 2","Campo 3","Campo 4","Campo 5","Campo 6","Campo 7","Campo 8","Campo 9","Campo 10","Campo 11","Campo 12","Campo 13","Campo 14","Campo 15","Campo 16","Campo 17","Campo 18","Campo 19","Campo 20","Campo 21","Campo 22"]
[null,1,2,3,4,5,6,7,8,null,9,10,null,11,12,13,14,15,16,17,18,19,20]
[null,"Tipo de Tercero","Tipo de Operación","RFC","                                                          Número de ID Fiscal","Nombre del Extranjero","País de de residencia","Nacionalidad","Valor de los actos o actividades pagados a la tasa del 15%  ó 16% de IVA","Valor de los actos o actividades pagados a la tasa del 15% de IVA","Monto del IVA pagado no acreditable a la tasa del 15% ó 16% (correspondiente en la proporcion de las deducciones autorizadas)","Valor de los actos o actividades pagados a la tasa del 10%  u 11%de IVA","Valor de los actos o actividades pagados a la tasa del 10% de IVA","Monto del IVA pagado no acreditable a la tasa del 10% u 11% (correspondiente en la proporcion de las deducciones autorizadas)","Valor de los actos o actividades pagados en la importación de bienes y servicios a la tasa del 15% ó 16%de IVA","Monto del IVA pagado no acreditable por la importación a la tasa del 15% ó 16% (correspondiente en la proporcion de las deducciones autorizadas)","Valor de los actos o actividades pagados en la importación de bienes y servicios a la tasa del 10% u 11% de IVA","Monto del IVA pagado no acreditable por la importación a la tasa del 10% u 11% (Correspondiente en la proporcion de las deducciones autorizadas)","Valor de los actos o actividades pagados en la importación de bienes y servicios por los que no se pagará el IVA (Exentos)","Valor de los demás actos o actividades pagados a la tasa del 0% de IVA","Valor de los actos o actividades pagados por los que no se pagará el IVA (Exentos)","IVA Retenido por el contribuyente","IVA correspondiente a las devoluciones, descuentos y bonificaciones sobre compras",null,{"$f":"COUNTA(B11:B5000)","v":0}]

{"sheet":"PAIS","index":10,"n_rows":248,"n_cols":3,"rows_kept":248,"cut":false,"hidden":false,"merged":[[0,1,5,2]]}
[]
[]
[]
[]
[]
[]
[null,"Valor","Descripción"]
[null,0,"  "]
[null,"AD","AD - Principado de Andorra"]
[null,"AE","AE - Emiratos Arabes Unidos"]
[null,"AF","AF - Afganistán"]
[null,"AG","AG - Antigua y Bermuda"]
[null,"AI","AI - Isla Anguilla"]
[null,"AL","AL - República de Albania"]
[null,"AN","AN - Antillas Neerlandesas"]
[null,"AO","AO - República de Angola"]
[null,"AQ","AQ - Antártica"]
[null,"AR","AR - Argentina"]
[null,"AS","AS - Samoa Americana"]
[null,"AT","AT - Austria"]
[null,"AU","AU - Australia"]
[null,"AW","AW - Aruba"]
[null,"AX","AX - Ascensión"]
[null,"AZ","AZ - Islas Azores"]
[null,"BB","BB - Barbados"]
[null,"BD","BD - Bangladesh"]
[null,"BE","BE - Bélgica"]
[null,"BF","BF - Burkina Faso"]
[null,"BG","BG - Bulgaria"]
[null,"BH","BH - Estado de Bahrein"]
[null,"BI","BI - Burundi"]
[null,"BJ","BJ - Benin"]
[null,"BL","BL - Belice"]
[null,"BM","BM - Bermudas"]
[null,"BN","BN - Brunei Darussalam"]
[null,"BO","BO - Bolivia"]
[null,"BR","BR - Brasil"]
[null,"BS","BS - Commonwealth de las Bahamas"]
[null,"BT","BT - Buthan"]
[null,"BU","BU - Burma"]
[null,"BV","BV - Isla Bouvet"]
[null,"BW","BW - Botswana"]
[null,"BY","BY - Bielorrusia"]
[null,"CA","CA - Canadá"]
[null,"CC","CC - Isla de Cocos o Kelling"]
[null,"CD","CD - Islas Canarias"]
[null,"CE","CE - Isla de Christmas"]
[null,"CF","CF - República Centro Africana"]
[null,"CG","CG - Congo"]
[null,"CH","CH - Suiza"]
[null,"CI","CI - Costa de Marfil"]
[null,"CK","CK - Islas Cook"]
[null,"CL","CL - Chile"]
[null,"CM","CM - Camerún"]
[null,"CN","CN - China"]
[null,"CO","CO - Colombia"]
[null,"CP","CP - Campione D'Italia"]
[null,"CR","CR - República de Costa Rica"]
[null,"CS","CS - República Checa y República Eslovaca"]
[null,"CU","CU - Cuba"]
[null,"CV","CV - República de Cabo Verde"]
[null,"CX","CX - Isla de Navidad"]
[null,"CY","CY - República de Chipre"]
[null,"DD","DD - Alemania"]
[null,"DJ","DJ - República de Djibouti"]
[null,"DK","DK - Dinamarca"]
[null,"DM","DM - República Dominicana"]
[null,"DN","DN - Commonwealth de Dominica"]
[null,"DZ","DZ - Argelia"]
[null,"EC","EC - Ecuador"]
[null,"EG","EG - Egipto"]
[null,"EH","EH - Sahara del Oeste"]
[null,"EO","EO - Estado Independiente de Samoa Occidental"]
[null,"ES","ES - España"]
[null,"ET","ET - Etiopía"]
[null,"FI","FI - Finlandia"]
[null,"FJ","FJ - Fiji"]
[null,"FK","FK - Islas Malvinas"]
[null,"FM","FM - Micronesia"]
[null,"FO","FO - Islas Faroe"]
[null,"FR","FR - Francia"]
[null,"GA","GA - Gabón"]
[null,"GB","GB - Gran Bretaña (Reino Unido)"]
[null,"GD","GD - Granada"]
[null,"GF","GF - Guyana Francesa"]
[null,"GH","GH - Ghana"]
[null,"GI","GI - Gibraltar"]
[null,"GJ","GJ - Groenlandia"]
[null,"GM","GM - Gambia"]
[null,"GN","GN - Guinea"]
[null,"GP","GP - Guadalupe"]
[null,"GQ","GQ - Guinea Ecuatorial"]
[null,"GR","GR - Grecia"]
[null,"GT","GT - Guatemala"]
[null,"GU","GU - Guam"]
[null,"GW","GW - Guinea Bissau"]
[null,"GY","GY - República de Guyana"]
[null,"GZ","GZ - Islas de Guernesey, Jersey, Alderney, Isla Great Sark, Herm, Little Sark, Berchou, Jethou, Lihou (Islas del Canal)"]
[null,"HK","HK - Hong Kong"]
[null,"HM","HM - Islas Heard and Mc Donald"]
[null,"HN","HN - República de Honduras"]
[null,"HT","HT - Haití"]
[null,"HU","HU - Hungría"]
[null,"ID","ID - Indonesia"]
[null,"IE","IE - Irlanda"]
[null,"IH","IH - Isla del Hombre"]
[null,"IL","IL - Israel"]
[null,"IN","IN - India"]
[null,"IO","IO - Territorio Británico en el Océano Indico"]
[null,"IP","IP - Islas Pacífico"]
[null,"IQ","IQ - Iraq"]
[null,"IR","IR - Irán"]
[null,"IS","IS - Islandia"]
[null,"IT","IT - Italia"]
[null,"JM","JM - Jamaica"]
[null,"JO","JO - Reino Hachemita de Jordania"]
[null,"JP","JP - Japón"]
[null,"KE","KE - Kenia"]
[null,"KH","KH - Campuchea Democrática"]
[null,"KI","KI - Kiribati"]
[null,"KM","KM - Comoros"]
[null,"KN","KN - San Kitts"]
[null,"KP","KP - República Democrática de Corea"]
[null,"KR","KR - República de Corea"]
[null,"KW","KW - Estado de Kuwait"]
[null,"KY","KY - Islas Caimán"]
[null,"LA","LA - República Democrática de Laos"]
[null,"LB","LB - Líbano"]
[null,"LC","LC - Santa Lucía"]
[null,"LI","LI - Principado de Liechtenstein"]
[null,"LK","LK - República Socialista Democrática de Sri Lanka"]
[null,"LN","LN - Labuán"]
[null,"LR","LR - República de Liberia"]
[null,"LS","LS - Lesotho"]
[null,"LU","LU - Gran Ducado de Luxemburgo"]
[null,"LY","LY - Libia"]
[null,"MA","MA - Marruecos"]
[null,"MC","MC - Principado de Mónaco"]
[null,"MD","MD - Madeira"]
[null,"MG","MG - Madagascar"]
[null,"MH","MH - República de las Islas Marshall"]
[null,"ML","ML - Malí"]
[null,"MN","MN - Mongolia"]
[null,"MO","MO - Macao"]
[null,"MP","MP - Islas Marianas del Noreste"]
[null,"MQ","MQ - Martinica"]
[null,"MR","MR - Mauritania"]
[null,"MS","MS - Monserrat"]
[null,"MT","MT - Malta"]
[null,"MU","MU - República de Mauricio"]
[null,"MV","MV - República de Maldivas"]
[null,"MW","MW - Malawi"]
[null,"MY","MY - Malasia "]
[null,"MZ","MZ - Mozambique"]
[null,"NA","NA - República de Namibia"]
[null,"NC","NC - Nueva Caledonia"]
[null,"NE","NE - Níger"]
[null,"NF","NF - Isla de Norfolk"]
[null,"NG","NG - Nigeria"]
[null,"NI","NI - Nicaragua"]
[null,"NL","NL - Holanda"]
[null,"NO","NO - Noruega"]
[null,"NP","NP - Nepal"]
[null,"NR","NR - República de Nauru"]
[null,"NT","NT - Zona Neutral"]
[null,"NU","NU - Niue"]
[null,"NV","NV - Nevis"]
[null,"NZ","NZ - Nueva Zelandia"]
[null,"OM","OM - Sultanía de Omán"]
[null,"PA","PA - República de Panamá"]
[null,"PE","PE - Perú"]
[null,"PF","PF - Polinesia Francesa"]
[null,"PG","PG - Papúa Nueva Guinea"]
[null,"PH","PH - Filipinas"]
[null,"PK","PK - Pakistán"]
[null,"PL","PL - Polonia"]
[null,"PM","PM - Isla de San Pedro y Miguelón"]
[null,"PN","PN - Pitcairn"]
[null,"PR","PR - Estado Libre Asociado de Puerto Rico"]
[null,"PT","PT - Portugal"]
[null,"PU","PU - Patau"]
[null,"PW","PW - Palau"]
[null,"PY","PY - Paraguay"]
[null,"QA","QA - Estado de Quatar"]
[null,"QB","QB - Isla Qeshm"]
[null,"RE","RE - Reunión"]
[null,"RO","RO - Rumania"]
[null,"RW","RW - Rhuanda"]
[null,"SA","SA - Arabia Saudita"]
[null,"SB","SB - Islas Salomón"]
[null,"SC","SC - Seychelles Islas"]
[null,"SD","SD - Sudán"]
[null,"SE","SE - Suecia"]
[null,"SG","SG - Singapur"]
[null,"SH","SH - Santa Elena"]
[null,"SI","SI - Archipiélago de Svalbard"]
[null,"SJ","SJ - Islas Svalbard and Jan Mayen"]
[null,"SK","SK - Sark"]
[null,"SL","SL - Sierra Leona"]
[null,"SM","SM - Serenísima República de San Marino"]
[null,"SN","SN - Senegal"]
[null,"SO","SO - Somalia"]
[null,"SR","SR - Surinam"]
[null,"ST","ST - Sao Tome and Príncipe"]
[null,"SU","SU - Países de la Ex-U.R.S.S., excepto Ucrania y Bielorusia"]
[null,"SV","SV - El Salvador"]
[null,"SW","SW - República de Seychelles"]
[null,"SY","SY - Siria"]
[null,"SZ","SZ - Reino de Swazilandia"]
[null,"TC","TC - Islas Turcas y Caicos"]
[null,"TD","TD - Chad"]
[null,"TF","TF - Territorios Franceses del Sureste"]
[null,"TG","TG - Togo"]
[null,"TH","TH - Thailandia"]
[null,"TK","TK - Tokelau"]
[null,"TN","TN - República de Túnez"]
[null,"TO","TO - Reino de Tonga"]
[null,"TP","TP - Timor Este"]
[null,"TR","TR - Trieste"]
[null,"TS","TS - Tristán Da Cunha"]
[null,"TT","TT - República de Trinidad y Tobago"]
[null,"TU","TU - Turquía"]
[null,"TV","TV - Tuvalu"]
[null,"TW","TW - Taiwán"]
[null,"TZ","TZ - Tanzania"]
[null,"UA","UA - Ucrania"]
[null,"UG","UG - Uganda"]
[null,"UM","UM - Islas menores alejadas de los Estados Unidos"]
[null,"US","US - Estados Unidos de América"]
[null,"UY","UY - República Oriental del Uruguay"]
[null,"VA","VA - El Vaticano"]
[null,"VC","VC - San Vicente y Las Granadinas"]
[null,"VE","VE - Venezuela"]
[null,"VG","VG - Islas Vírgenes Británicas"]
[null,"VI","VI - Islas Vírgenes de Estados Unidos de América"]
[null,"VN","VN - Vietnam"]
[null,"VU","VU - República de Vanuatu"]
[null,"WF","WF - Islas Wallis y Funtuna"]
[null,"XX","XX - Otro"]
[null,"YD","YD - Yemen Democrática"]
[null,"YE","YE - República del Yemen"]
[null,"YU","YU - Países de la Ex-Yugoslavia"]
[null,"ZA","ZA - Sudáfrica"]
[null,"ZC","ZC - Zona Especial Canaria"]
[null,"ZM","ZM - Zambia"]
[null,"ZO","ZO - Zona Libre Ostrava"]
[null,"ZR","ZR - Zaire"]
[null,"ZW","ZW - Zimbawe"]

{"sheet":"DPIVA","index":11,"n_rows":6,"n_cols":79,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Campos DPIVA"]
[]
[null,"Campo 1","Campo 2","Campo 3","Campo 4","Campo 5","Campo 6","Campo 7","Campo 8","Campo 9","Campo 10","Campo 11","Campo 12","Campo 13","Campo 14","Campo 15","Campo 16","Campo 17","Campo 18","Campo 19","Campo 20","Campo 21","Campo 22","Campo 23","Campo 24","Campo 25","Campo 26","Campo 27","Campo 28","Campo 29","Campo 30","Campo 31","Campo 32","Campo 33","Campo 34","Campo 35","Campo 36","Campo 37","Campo 38","Campo 39","Campo 40","Campo 41","Campo 42","Campo 43","Campo 44","Campo 45","Campo 46","Campo 47","Campo 48","Campo 49","Campo 50","Campo 51","Campo 52","Campo 53","Campo 54","Campo 55","Campo 56","Campo 57","Campo 58","Campo 59","Campo 60","Campo 61","Campo 62","Campo 63","Campo 64","Campo 65","Campo 66","Campo 67","Campo 68","Campo 69","Campo 70","Campo 71","Campo 72","Campo 73","Campo 74","Campo 75","Campo 76","Campo 77","Campo 78"]
[null,"Version","Ejercicio","TipoPerid","Periodo","DPIVA","TipoDec","FolioAnt","FechPresAnt","TotOperac","TotActPagTas15o16IVA","TotActPagTas15IVA","TotIVAPagNoAcrTas15o16","TotActPagTas10u11IVA","TotActPagTas10IVA","TotIVAPagNoAcrTas10u11","TotActPagImpBySTas15o16IVA","TotIVAPagNoAcrImpTas15o16","TotActPagImpBySTas10u11IVA","TotIVAPagNoAcrImpTas10u11","TotActPagImpBySNoPagIVA","TotDemActPagTas0IVA","TotActPagNoPagIVA","TotIVARetCont","TotIVADevDescyBonifComp","TotIVATraslContExcImpByS","TotIVAPagImpByS","Datos del proveedor nacional. ProvNacional","TipoOperac","RFCProv","ValActPagTas15o16IVA","ValActPagTas15IVA","MonIVAPagNoAcrTas15o16","ValActPagTas10u11IVA","ValActPagTas10IVA","VersionMonIVAPagNoAcrTas10u11","ValActPagTas0IVA","ValActPagNoIVA","IVARetCont","IVADevDescyBonifComp","Datos del proveedor extranjero.","TipoOperac","RFCProv","NumIDFiscal","NombExtranjero","PaisResidencia","Nacionalidad","ValActPagTas15o16IVA","ValActPagTas15IVA","MonIVAPagNoAcrTas15o16","ValActPagTas10u11IVA","ValActPagTas10IVA","MonIVAPagNoAcrTas10u11","ValActPagImpBySTas15o16IVA","MonIVAPagNoAcrImpTas15o16","ValActPagImpBySTas10u11IVA","MonIVAPagNoAcrImpTas10u11","ValActPagImpBySNoIVA","ValActPagTas0IVA","ValActPagNoIVA","IVARetCont","IVADevDescyBonifComp","Datos del proveedor global.","TipoOperac","ValActPagTas15o16IVA","ValActPagTas15IVA","MonIVAPagNoAcrTas15o16","ValActPagTas10u11IVA","ValActPagTas10IVA","MonIVAPagNoAcrTas10u11","ValActPagImpBySTas15o16IVA","MonIVAPagNoAcrImpTas15o16","ValActPagImpBySTas10u11IVA","MonIVAPagNoAcrImpTas10u11","ValActPagImpBySNoIVA","ValActPagTas0IVA","ValActPagNoIVA","IVARetCont","IVADevDescyBonifComp"]

{"sheet":"DATOS","index":12,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,2010,"Enero",1]
[null,2011,"Febrero",2]
[null,2012,"Marzo",3]
[null,2013,"Abril",4]
[null,2014,"Mayo",5]
[null,2015,"Junio",6]
[null,2016,"Julio",7]
[null,2017,"Agosto",8]
[null,2018,"Septiembre",9]
[null,2019,"Octubre",10]
[null,2020,"Noviembre",11]
[null,null,"Diciembre",12]