{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["EDI","DED","CA","FACE 01","FACE 02","FRS-ICE"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":2,"defined_names":11,"comments":2,"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":"EDI","index":0,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,11,0,12],[4,5,4,10],[5,5,5,10],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
[null,null,null,null,null,null,null,null,null,null,null,"Modèle n° ADC082F-15I"]
["RAISON SOCIAL"]
["ID_FISCAL"]
["ANNEE",null,2016]
["PERIODE(Triméstre)",null,"02",null,null,"Relevé de déduction"]
["REGIME(Encais-1)",null,1,null,null,"(Article 112 du Code Général des Impôts)"]
[]
["OR","FACT_NUM","DESIGNATION","M_HT","TVA","M_TTC","IF","LIB_FRSS","ICE_FRS","TAUX","ID_PAIE","DATE_PAIE","DATE_FAC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,{"$f":"SUBTOTAL(109,[M_HT])","v":0},{"$f":"SUBTOTAL(109,[TVA])","v":0},{"$f":"SUBTOTAL(109,[M_TTC])","v":0},null,null,null,null,null,null,{"$f":"SUBTOTAL(103,[DATE_FAC])","v":0},null,null,2017,3]
[null,{"$f":"IF(A30-Tableau5[[#Totals],[DATE_FAC]]=0,\"OK\",\"Vérifier colonne Num_Ordre!\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,2018,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,12]

{"sheet":"DED","index":1,"n_rows":140,"n_cols":13,"rows_kept":140,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,4,6,7],[7,4,8,7],[122,4,122,5],[123,4,123,5],[12,11,12,12],[12,3,12,7],[139,1,139,3],[124,4,124,5],[125,4,125,5],[126,4,126,5],[127,4,127,5],[128,4,128,5],[129,4,129,5],[136,4,136,5],[139,4,139,5],[130,4,130,5],[131,4,131,5],[132,4,132,5],[134,4,134,5],[135,4,135,5],[137,4,137,5],[138,4,138,5]]}
[null,null,null,null,null,null,null,null,null,null,"Modèle n° ADC082F-15I"]
[]
[]
[]
[]
[null,null,null,null,"Relevé de déduction"]
[]
[null,null,null,null,"(Article 112 du Code Général des Impôts)"]
[]
[]
[null,null,null,null,"Triméstre",{"$f":"EDI!C5","v":"02"},"Année",{"$f":"EDI!C4","v":2016}]
[]
["Nom et prénom ou raison sociale :  ",null,null,{"$f":"+EDI!C2","v":0},null,null,null,null,"N° d'identification fiscale : ",null,null,{"$f":"+EDI!C3","v":0}]
["OR","FACT_NUM","DESIGNATION","M_HT","TVA","M_TTC","IF","LIB_FRSS","ICE","TAUX","ID","DATE_PAIE","DATE_FAC"]
[null,null,null,{"$f":"+F15-E15","v":0},{"$f":"+F15/6","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G15, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G15, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G15, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G15, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,{"$f":"+F16-E16","v":0},{"$f":"+F16/6","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G16, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G16, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G16, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G16, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G17, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G17, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G17, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G17, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G18, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G18, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G18, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G18, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
["Total TVA sur Prestation de Sces étrangers à 20%",null,null,{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},0]
[null,null,null,{"$f":"+F20-E20","v":0},{"$f":"+F20/6","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G20, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G20, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G20, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G20, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G21, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G21, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G21, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G21, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G22, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G22, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G22, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G22, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G23, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G23, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G23, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G23, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,null,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G24, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G24, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G24, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G24, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
["Total TVA sur Prestation de services à 20%",null,null,{"$f":"SUM(D20:D24)","v":0},{"$f":"SUM(E20:E24)","v":0},0]
[null,null,null,{"$f":"+F26-E26","v":0},{"$f":"+F26/6","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G26, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G26, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G26, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G26, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G27, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G27, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G27, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G27, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G28, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G28, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G28, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G28, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G29, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G29, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G29, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G29, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G30, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G30, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G30, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G30, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G31, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G31, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G31, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G31, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G32, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G32, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G32, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G32, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G33, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G33, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G33, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G33, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G34, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G34, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G34, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G34, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G35, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G35, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G35, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G35, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G36, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G36, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G36, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G36, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G37, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G37, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G37, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G37, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G38, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G38, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G38, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G38, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G39, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G39, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G39, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G39, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G40, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G40, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G40, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G40, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G41, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G41, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G41, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G41, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G42, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G42, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G42, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G42, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G43, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G43, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G43, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G43, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G44, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G44, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G44, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G44, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G45, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G45, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G45, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G45, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G46, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G46, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G46, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G46, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G47, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G47, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G47, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G47, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,null,null,null,null,null,null,20]
["Total TVA sur ACHAT A l'intérieur à 20%",null,null,{"$f":"SUM(D26:D48)","v":0},{"$f":"SUM(E26:E48)","v":0},0]
[null,null,null,{"$f":"+F50/1.07","v":0},{"$f":"+D50*J50/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G50, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G50, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G50, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G50, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,{"$f":"+F51/1.07","v":0},{"$f":"+D51*J51/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G51, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G51, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G51, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G51, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G52, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G52, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G52, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G52, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G53, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G53, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G53, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G53, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G54, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G54, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G54, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G54, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G55, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G55, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G55, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G55, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G56, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G56, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G56, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G56, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G57, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G57, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G57, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G57, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G58, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G58, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G58, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G58, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G59, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G59, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G59, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G59, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G60, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G60, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G60, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G60, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G61, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G61, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G61, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G61, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
["Total TVA sur ACHAT A l'intérieur à 7%",null,null,{"$f":"SUM(D50:D61)","v":0},{"$f":"SUM(E50:E61)","v":0},0]
[null,null,null,{"$f":"+F63/1.14","v":0},{"$f":"+D63*J63/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G63, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G63, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G63, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G63, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,{"$f":"+F64/1.14","v":0},{"$f":"+D64*J64/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G64, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G64, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G64, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G64, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,{"$f":"+F65/1.14","v":0},{"$f":"+D65*J65/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G65, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G65, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G65, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G65, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G66, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G66, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G66, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G66, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G67, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G67, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G67, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G67, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G68, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G68, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G68, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G68, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G69, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G69, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G69, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G69, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},14]
["Total TVA sur ACHAT A l'intérieur à 14%",null,null,{"$f":"SUM(D63:D69)","v":0},{"$f":"SUM(E63:E69)","v":0},0]
[null,null,null,{"$f":"+E71/0.07","v":0},null,{"$f":"+D71+E71","v":0},null,{"$f":"IF(ISNA(VLOOKUP(G71, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G71, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G71, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G71, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,{"$f":"+E72/0.07","v":0},null,{"$f":"+D72+E72","v":0},null,{"$f":"IF(ISNA(VLOOKUP(G72, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G72, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G72, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G72, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G73, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G73, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G73, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G73, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G74, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G74, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G74, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G74, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G75, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G75, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G75, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G75, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},7]
["Total TVA sur IMPORT  à 07% ",null,null,{"$f":"SUM(D71:D75)","v":0},{"$f":"SUM(E71:E75)","v":0},0]
[null,null,null,{"$f":"+F77-E77","v":0},null,{"$f":"+E77*6","v":0},null,{"$f":"IF(ISNA(VLOOKUP(G77, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G77, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G77, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G77, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,{"$f":"+F78-E78","v":0},null,{"$f":"+E78*6","v":0},null,{"$f":"IF(ISNA(VLOOKUP(G78, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G78, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G78, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G78, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,{"$f":"+F79-E79","v":0},null,{"$f":"+E79*6","v":0},null,{"$f":"IF(ISNA(VLOOKUP(G79, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G79, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G79, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G79, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G80, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G80, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G80, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G80, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G81, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G81, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G81, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G81, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,null,0,null,{"$f":"IF(ISNA(VLOOKUP(G82, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G82, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G82, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G82, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
["Total TVA sur IMPORT  à 20% ",null,null,{"$f":"SUM(D77:D82)","v":0},{"$f":"SUM(E77:E82)","v":0},0]
[null,null,null,{"$f":"+F84-E84","v":0},{"$f":"+F84/6","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G84, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G84, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G84, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G84, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,{"$f":"+F85-E85","v":0},0,null,null,{"$f":"IF(ISNA(VLOOKUP(G85, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G85, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G85, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G85, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
["Total TVA sur LEASING  à 20%",null,null,{"$f":"SUM(D84:D85)","v":0},{"$f":"SUM(E84:E85)","v":0},{"$f":"SUM(F84:F85)","v":0}]
[null,null,null,{"$f":"+F87-E87","v":0},0,null,null,{"$f":"IF(ISNA(VLOOKUP(G87, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G87, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G87, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G87, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G88, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G88, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G88, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G88, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G89, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G89, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G89, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G89, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G90, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G90, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G90, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G90, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
[null,null,null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G91, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G91, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G91, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G91, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},20]
["Total TVA sur IMMOBILISATION à 20%",null,null,{"$f":"SUM(D87:D91)","v":0},{"$f":"SUM(E87:E91)","v":0},0]
[null,null,"FRAIS BANCAIRES",{"$f":"+F93/1.1","v":0},{"$f":"+D93*J93/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G93, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G93, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G93, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G93, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",{"$f":"+F94/1.1","v":0},0,null,null,{"$f":"IF(ISNA(VLOOKUP(G94, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G94, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G94, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G94, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G95, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G95, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G95, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G95, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G96, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G96, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G96, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G96, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G97, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G97, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G97, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G97, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G98, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G98, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G98, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G98, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G99, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G99, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G99, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G99, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G100, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G100, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G100, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G100, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G101, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G101, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G101, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G101, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G102, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G102, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G102, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G102, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G103, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G103, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G103, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G103, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G104, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G104, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G104, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G104, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G105, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G105, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G105, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G105, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G106, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G106, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G106, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G106, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G107, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G107, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G107, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G107, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G108, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G108, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G108, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G108, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G109, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G109, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G109, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G109, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G110, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G110, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G110, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G110, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,"FRAIS BANCAIRES",0,0,null,null,{"$f":"IF(ISNA(VLOOKUP(G111, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G111, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G111, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G111, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
["Total TVA sur commissions bancaires à 10%",null,null,{"$f":"SUM(D93:D111)","v":0},{"$f":"SUM(E93:E111)","v":0},0]
[null,null,null,{"$f":"+F113/1.1","v":0},{"$f":"+D113*J113/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G113, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G113, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G113, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G113, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,null,0,{"$f":"+D114*J114/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G114, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G114, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G114, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G114, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,null,0,{"$f":"+D115*J115/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G115, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G115, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G115, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G115, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,null,0,{"$f":"+D116*J116/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G116, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G116, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G116, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G116, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
[null,null,null,{"$f":"+F117/1.1","v":0},{"$f":"+D117*J117/100","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP(G117, [2]Feuil1!$A$2:$C$338, 2, FALSE)), \"\", (VLOOKUP(G117, [2]Feuil1!$A$2:$C$338, 2, FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(G117, [2]Feuil1!$A$2:$C$338, 3, FALSE)), \"\", (VLOOKUP(G117, [2]Feuil1!$A$2:$C$338, 3, FALSE)))","v":""},10]
["Total TVA /ACHATS à 10%",null,null,{"$f":"SUM(D113:D117)","v":0},{"$f":"SUM(E113:E117)","v":0},0]
[]
[null,"Total général",null,{"$f":"SUM(D19,D112,D92,D86,D76,D70,D62,D49,D25,D83,D118)","v":0},{"$f":"SUM(E19,E112,E92,E86,E76,E70,E62,E49,E25,E83,E118)","v":0},{"$f":"SUM(F19,F112,F92,F86,F76,F70,F62,F49,F25,F83,F118)","v":0}]
[]
[null,"RECAP"]
[null,"Services  Etrangers            ",null,0.2,{"$f":"+E19","v":0}]
[null,"Services                          ",null,0.2,{"$f":"+E25+E86","v":0}]
[null,"Banque                           ",null,0.1,{"$f":"+E112","v":0}]
[null,"Achats ",null,0.1,{"$f":"+E118","v":0}]
[null,"Leasing          ",null,0.2,0]
[null,"Achat local                       ",null,0.2,{"$f":"+E49","v":0}]
[null,"Achat import                    ",null,0.2,{"$f":"+E83","v":0}]
[null,"Achat local                       ",null,0.14000000000000001,{"$f":"+E70","v":0}]
[null,"Achat import                    ",null,7.0000000000000007E-2,{"$f":"+E76","v":0}]
[null,"Achat local                       ",null,7.0000000000000007E-2,{"$f":"+E62","v":0}]
[null,"Immobilisations",null,0.2,{"$f":"+E92","v":0}]
[]
[null,"Total déductions",null,null,{"$f":"SUM(E123:F134)","v":0}]
[null,"Report crédit de TVA"]
[null,"TVA Encaissée ",null,null,{"$f":"+CA!F99","v":0}]
[null,"TVA / Prst Sces à l'étranger",null,null,{"$f":"+CA!F9","v":0}]
[null,"1/5 à déduire chaque Janvier pendant 5 exercices",null,null,0]
[null,{"$f":"IF(E140>0, \"TVA DUE\", \"CREDIT DE  TVA\")","v":"CREDIT DE  TVA"},null,null,{"$f":"ROUNDUP(E137+E138-E135-E136-E139, 0)","v":0}]

{"sheet":"CA","index":2,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[[98,0,98,2],[3,3,3,4],[77,0,77,2],[77,7,77,8],[96,0,96,2],[96,7,96,8],[8,0,8,2],[8,7,8,8],[11,0,11,2],[57,0,57,2],[57,7,57,8]]}
[{"$f":"+EDI!C2","v":0}]
["I.F",{"$f":"+EDI!C3","v":0}]
[]
[null,null,null,"ETAT DES ENCAISSEMENTS TRIMESTRE ",null,{"$f":"EDI!C5","v":"02"},{"$f":"EDI!C4","v":2016}]
[null,null," "]
["Date fre","Numéro fre","CLIENTS","MT HT","TAUX","TVA","TTC","Mode de règlement","Date de règl"]
[null,null,null,{"$f":"+G7/1.2","v":0},0.2,{"$f":"+E7*D7","v":0},0]
[null,null,null,{"$f":"+G8/1.2","v":0},0.2,{"$f":"+E8*D8","v":0},0]
["Prestation Sérvices étrangers",null,null,{"$f":"SUM(D7:D8)","v":0},0.2,{"$f":"SUM(F7:F8)","v":0},{"$f":"SUM(G7:G8)","v":0}]
[null,null,null,{"$f":"+G10/1.2","v":0},0.2,{"$f":"+E10*D10","v":0},0]
[null,null,null,0,0.2,0,0]
["Prestation Sces Local",null,null,{"$f":"SUM(D10:D11)","v":0},0.2,{"$f":"SUM(F10:F11)","v":0},{"$f":"SUM(G10:G11)","v":0}]
[null,null,null,{"$f":"+G13/1.2","v":0},0.2,{"$f":"+D13*E13","v":0}]
[null,null,null,{"$f":"+G14/1.2","v":0},0.2,{"$f":"+D14*E14","v":0}]
[null,null,null,{"$f":"+G15/1.2","v":0},0.2,{"$f":"+D15*E15","v":0}]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,0,0.2,0]
[null,null,null,{"$f":"+G57/1.2","v":0},0.2,0]
["Marchandises/Produits 20%",null,null,{"$f":"SUM(D13:D57)","v":0},0.2,{"$f":"SUM(F13:F57)","v":0},{"$f":"SUM(G13:G57)","v":0}]
[null,null,null,{"$f":"+F59/0.07","v":0},7.0000000000000007E-2,null,{"$f":"+D59+F59","v":0}]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
[null,null,null,0,7.0000000000000007E-2,null,0]
["Marchandises/Produits 7%",null,null,{"$f":"SUM(D59:D77)","v":0},7.0000000000000007E-2,{"$f":"SUM(F59:F77)","v":0},0]
[null,null,null,{"$f":"+G79","v":0},0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
["Marchandises/Produits 0%",null,null,{"$f":"SUM(D79:D96)","v":0},null,{"$f":"SUM(F79:F96)","v":0},0]
[]
["Total ",null,null,{"$f":"+D97+D78+D58+D12+D9","v":0},null,{"$f":"+F97+F78+F58+F12+F9","v":0},{"$f":"+G97+G78+G58+G12+G9","v":0}]

{"sheet":"FACE 01","index":3,"n_rows":146,"n_cols":63,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,50,0,62],[2,14,2,42],[3,16,3,46],[4,16,4,46],[5,16,5,46],[6,21,6,39],[6,49,6,59],[7,20,7,24],[7,27,7,31],[7,32,7,35],[7,49,7,59],[8,0,8,2],[8,3,8,10],[8,18,8,24],[8,38,8,41],[8,49,8,59],[15,0,15,17],[15,18,15,44],[16,16,16,62],[17,9,17,62],[18,30,18,62],[19,0,19,45],[19,49,19,62],[9,27,9,32],[9,33,9,34],[9,35,9,39],[10,0,11,62],[14,12,14,25],[14,43,14,60],[26,42,26,61],[28,42,28,61],[30,42,30,61],[32,42,32,61],[34,42,34,61],[36,1,36,40],[36,41,36,51],[36,52,36,62],[20,4,20,19],[20,23,20,34],[20,39,20,56],[21,1,21,40],[21,41,21,62],[24,42,24,61],[43,1,43,40],[43,42,43,50],[43,53,43,61],[45,1,45,40],[45,42,45,50],[45,53,45,61],[37,1,37,40],[38,42,39,50],[38,53,39,61],[39,1,39,40],[41,1,41,40],[41,42,41,50],[41,53,41,61],[51,1,51,40],[52,1,52,40],[54,1,54,40],[54,42,54,50],[54,53,54,61],[56,1,56,40],[56,42,56,50],[56,53,56,61],[47,1,47,40],[47,42,47,50],[47,53,47,61],[49,1,49,40],[49,42,49,50],[49,53,49,61],[61,1,61,40],[62,1,62,40],[62,42,62,50],[62,53,62,61],[63,1,63,40],[65,1,65,40],[58,1,58,40],[58,42,58,50],[58,53,58,61],[60,1,60,40],[60,42,60,50],[60,53,60,61],[69,1,69,40],[71,1,71,40],[71,42,71,50],[71,53,71,61],[73,1,73,40],[73,42,73,50],[73,53,73,61],[66,1,66,38],[66,42,66,50],[66,53,66,61],[68,1,68,40],[68,42,68,50],[68,53,68,61],[80,1,80,40],[80,42,80,50],[80,53,80,61],[82,1,82,40],[82,42,82,50],[82,53,82,61],[74,1,74,40],[76,1,76,38],[76,42,76,50],[76,53,76,61],[78,1,78,40],[78,42,78,50],[78,53,78,61],[88,1,88,40],[88,42,88,50],[88,53,88,61],[90,1,90,40],[90,42,90,50],[90,53,90,61],[84,1,84,40],[84,42,84,50],[84,53,84,61],[86,1,86,40],[86,42,86,50],[86,53,86,61],[96,1,96,40],[96,42,96,50],[96,53,96,61],[98,1,98,40],[98,42,98,50],[98,53,98,61],[92,1,92,40],[92,42,92,50],[92,53,92,61],[94,1,94,40],[94,42,94,50],[94,53,94,61],[104,1,104,40],[104,42,104,50],[104,53,104,61],[106,1,106,40],[106,42,106,50],[106,53,106,61],[100,1,100,40],[100,42,100,50],[100,53,100,61],[102,1,102,40],[102,42,102,50],[102,53,102,61],[114,1,114,40],[114,42,114,50],[114,53,114,61],[116,1,116,40],[116,42,116,50],[116,53,116,61],[108,1,108,40],[108,42,108,50],[108,53,108,61],[110,1,110,40],[112,1,112,40],[112,42,112,50],[112,53,112,61],[121,1,121,40],[121,42,121,50],[121,53,121,61],[123,1,123,40],[123,42,123,50],[123,53,123,61],[117,1,117,40],[117,42,117,50],[117,53,117,61],[119,1,119,40],[119,42,119,50],[119,53,119,61],[129,1,129,40],[129,42,129,50],[129,53,129,61],[131,1,131,40],[131,42,131,50],[131,53,131,61],[125,1,125,40],[125,42,125,50],[125,53,125,61],[127,1,127,40],[127,42,127,50],[127,53,127,61],[141,1,141,51],[141,53,141,61],[145,60,145,62],[134,53,134,61],[137,1,137,51],[138,0,139,0],[138,1,139,38],[138,42,138,50],[138,53,138,61],[139,42,139,50]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modèle n° : ADC080F-15E"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAXE SUR LA VALEUR AJOUTEE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Déclaration Triméstriel"]
["DRI, DP ou DIP de :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Article 110 du Code Général des Impôts (CGI)"]
["………………………………….."]
["Subdivision : …………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triméstre ",null,null,null,null,{"$f":"+EDI!C5","v":"02"},null,"Année :",null,null,null,null,{"$f":"+EDI!C4","v":2016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fait générateur :",null,null,null,null,null,null,"Débit ",null,null,null,null,null,"Encaissement",null,null,null,null,null,null,"X"]
[]
["IDENTIFICATION DU CONTRIBUABLE"]
[]
[]
[]
["N° d'identification fiscale :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+EDI!C3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C.N.I ou Carte de séjour N° :"]
["Identifiant commun de l'entreprise «ICE» :"]
["Nom,Prénom (s) ou Raison Sociale:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+EDI!C2","v":0}]
["Activité principale :"]
["Adresse du siège social,du principale établissement ou du domicile fiscal:"]
["………………………………………………………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ville :",null,null,"ESSAOUIRA"]
["Téléphone :",null,null,null,"……………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax :",null,null,"…………………………….",null,null,null,null,null,null,null,null,null,null,null,"e-mail:",null,null,null,"………………………………………………………"]
["A"," Ventilation du chiffre d’affaires total Montant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montants"]
[]
[]
[10,"Montant du chiffre d’affaires réalisé y compris les affaires non imposables (HT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ27:BJ35)","v":0}]
[]
[20,"- Opérations situées hors champ d’application de la TVA"]
[]
[30,"- Opérations exonérées sans droit à déduction (art 91du CGI)"]
[]
[40,"- Opérations exonérées avec droit à déduction (art 92 du CGI)"]
[]
[50,"- Opérations faites en suspension de la TVA (art 94 du CGI)"]
[]
[60,"Chiffre d’affaires imposable à répartir (différence : ligne 10 – (20 + 30 +40 +50) (HT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ39:AY132)","v":0}]
[]
["B"," Ventilation du chiffre d’affaires imposable Base imposable (HT) Taxe exigible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Imposable (H.T)",null,null,null,null,null,null,null,null,null,null,"Taxe Exigible"]
[null,"TAUX NORMAL DE 20% AVEC DROIT A DEDUCTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ39*20/100","v":0}]
[80,"-Opérations de production et de distribution"]
[]
[81,"-Prestations de services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+CA!D58","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AQ42*20/100","v":0}]
[]
[82,"-Professions libérales visées à l’article 89-I-12°-(b) du CGI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ44*20/100","v":0}]
[]
[83,"-Opérations de crédit-bail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ46*20/100","v":0}]
[]
[87,"-Opérations d’entreprises de travaux immobiliers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ48*20/100","v":0}]
[]
[102,"-Autres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ50*20/100","v":0}]
[]
[null,"TAUX REDUIT DE 14%"]
[null,"    Avec droit à déduction"]
[]
[84,"- Beurre à l’exclusion du beurre de fabrication artisanale visé à l’article 91 (I-A. 2°)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ55*14/100","v":0}]
[]
[88,"- Opérations de transport de voyageurs et de marchandises",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ57*14/100","v":0}]
[]
[90,"- Energie électrique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ59*14/100","v":0}]
[]
[104,"-Autres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ61*14/100","v":0}]
[null,"     Sans droit à déduction"]
[91,"- Les prestations de services rendues par tout agent démarcheur ou courtier d’assurances à raison des",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ63*14/100","v":0}]
[null,"  contrats apportés par lui à une entreprise d’assurances"]
[]
[null,"TAUX REDUIT DE 10% AVEC DROIT A DEDUCTION"]
[77,"- Les chauffe-eau solaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ67*10/100","v":0}]
[]
[78,"- les aliments destinés à l’alimentation de bétail et des animaux de basse-cour ainsi que les tourteaux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ69*10/100","v":0}]
[null,"servant à leur fabrication à l'exclusion des autres aliments simples"]
[]
[79,"- Les équipements à usage exclusivement agricole",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ72*10/100","v":0}]
[]
[85,"- Les bois en grumes, écorcés ou simplement équarris, le liège à l'état naturel,  les bois de feu en fagots ou ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ74*10/100","v":0}]
[null,"sciés à petite longueur et le charbon de bois"]
[]
["86","- Les engins et filets de pêche destinés aux professionnels de la pèche maritime",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ77*10/100","v":0}]
[]
[89,"- Les prestations de restauration fournies directement par l'entreprise à son personnel salarié ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ79*10/100","v":0}]
[]
[92,"- Opérations de restauration et de logement dans des hôtels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ81*10/100","v":0}]
[]
[93,"- Opérations de restauration fournies par les prestataires de services au personnel salarié des entreprises",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ83*10/100","v":0}]
[]
[94,"- location d'hôtels ou d'ensembles immobiliers à destination touristique.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ85*10/100","v":0}]
[]
[95,"- les opérations de vente de denrées ou de boissons à consommer sur place, réalisées dans les restaurants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ87*10/100","v":0}]
[]
[96,"- Le sel de cuisine (gemme ou marin)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ89*10/100","v":0}]
[]
[97,"- Le riz usiné et les pâtes alimentaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ91*10/100","v":0}]
[]
[98,"- Les huiles fluides alimentaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ93*10/100","v":0}]
[]
[99,"- les transactions relatives aux valeurs mobilières",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ95*10/100","v":0}]
[]
[100,"- Les opérations de banque et de crédit et les commissions de change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ97*10/100","v":0}]
[]
[101,"- Les transactions portant sur les actions et les parts sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ99*10/100","v":0}]
[]
[103,"- Les opérations de vente et de livraison des œuvres et objets d'art",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ101*10/100","v":0}]
[]
[105,"- Les opérations des avocats, interprètes, notaires, adoul, huissiers de justice et vétérinaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ103*10/100","v":0}]
[]
[108,"- Gaz de pétrole et les autres hydrocarbures gazeux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ105*10/100","v":0}]
[]
[109,"- Les Huiles de pétrole ou de schistes, brutes ou raffinées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ107*10/100","v":0}]
[]
[118,"-Autres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ109*10/100","v":0}]
[]
[null,"TAUX REDUIT DE 7% AVEC DROIT A DEDUCTION"]
[]
[106,"- L’eau livrée aux réseaux de distribution publique et les prestations d’assainissement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ113*7/100","v":0}]
[]
[107,"- Location de compteurs d’eau et d’électricité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ115*7/100","v":0}]
[]
[110,"- Produits pharmaceutiques, matières premières et produits entrant dans leurs compositions ainsi que les",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ117*7/100","v":0}]
[null,"  emballages non récupérables de ces produits et matières"]
[]
[111,"- Les fournitures scolaires, produits et matières entrant dans leur composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ120*7/100","v":0}]
[]
[113,"- Sucre raffiné ou aggloméré",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ122*7/100","v":0}]
[]
[114,"- Conserves de sardines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ124*7/100","v":0}]
[]
[115,"- Lait en poudre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ126*7/100","v":0}]
[]
[116,"- Savon de ménage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ128*7/100","v":0}]
[]
[117,"- Voiture économique et produits et matières entrant dans sa fabrication",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ130*7/100","v":0}]
[]
[119,"-Autres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ132*7/100","v":0}]
[]
[]
[120,"Reversement de la TVA à différents titres (cessation, régularisation,….) "]
[]
[]
["C","Opérations réalisées avec des contribuables non résidents (1)    (Article 115 du CGI)  "]
[129,"Opérations réalisées avec des contribuables non résidents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ139*7/100","v":0},null,null,null,null,null,null,null,null,"(2)"]
[]
[]
[130,"TOTAL de la TVA exigible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BB139+BB132+BB130+BB128+BB126+BB124+BB122+BB120+BB117+BB115+BB113+BB135+BB109+BB107+BB105+BB103+BB101+BB99+BB97+BB95+BB93+BB91+BB89+BB87+BB85+BB83+BB81+BB79+BB74+BB72+BB69+BB63+BB61+BB59+BB57+BB55+BB50+BB48+BB46+BB44+BB42+BB39+BB77+BB67)","v":0}]
[]
["(1)","Joindre la liste des contribuables non résidents (annexe n° ADC081F-14I). "]
["(2)","Cette case ne doit être servie que si votre déclaration, ne tenant pas compte de la taxe figurant sur la ligne 129, est débitrice. A défaut, la TVA exigible doit "]
["         être déclarée au niveau de la ligne 204.  "]

{"sheet":"FACE 02","index":4,"n_rows":114,"n_cols":68,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,31,3,41],[1,42,3,45],[1,46,3,56],[4,0,4,2],[4,3,4,27],[5,0,5,2],[5,3,5,27],[6,0,6,2],[6,3,6,27],[1,0,3,2],[1,3,3,27],[1,28,3,30],[13,32,13,40],[13,47,13,55],[9,28,9,30],[10,0,10,2],[10,3,10,27],[10,28,10,30],[10,32,10,40],[10,47,10,55],[6,28,6,30],[6,32,6,40],[6,47,6,55],[8,0,8,2],[8,3,8,27],[8,28,8,30],[8,32,8,40],[8,47,8,55],[14,28,14,30],[15,0,15,2],[15,3,15,27],[15,28,15,30],[16,3,16,27],[16,28,16,30],[12,0,12,2],[12,3,12,27],[13,3,13,27],[13,28,13,30],[19,3,19,27],[19,28,19,30],[20,0,20,2],[20,3,20,27],[20,28,20,30],[20,32,20,40],[16,32,16,40],[16,47,16,55],[17,28,17,30],[18,0,18,2],[18,3,18,27],[18,28,18,30],[18,32,18,40],[18,47,18,55],[23,28,23,30],[24,0,24,2],[24,3,24,27],[24,28,24,30],[24,32,24,40],[24,47,24,55],[20,47,20,55],[21,28,21,30],[22,0,22,2],[22,3,22,27],[22,28,22,30],[22,32,22,40],[22,47,22,55],[27,28,27,30],[28,0,28,2],[28,3,28,27],[28,28,28,30],[28,32,28,40],[28,47,28,55],[25,28,25,30],[26,0,26,2],[26,3,26,27],[26,28,26,30],[26,32,26,40],[26,47,26,55],[31,28,31,30],[32,0,32,2],[32,3,32,27],[32,28,32,30],[32,32,32,40],[32,47,32,55],[29,28,29,30],[30,0,30,2],[30,3,30,27],[30,28,30,30],[30,32,30,40],[30,47,30,55],[35,28,35,30],[36,0,36,2],[36,3,36,27],[36,28,36,30],[36,32,36,40],[36,47,36,55],[33,28,33,30],[34,0,34,2],[34,3,34,27],[34,28,34,30],[34,32,34,40],[34,47,34,55],[40,42,40,45],[40,47,40,55],[41,0,41,2],[41,3,41,27],[37,28,37,30],[38,0,38,2],[38,3,38,27],[38,28,38,30],[38,32,38,40],[38,47,38,55],[42,3,42,27],[42,28,42,30],[43,0,43,2],[43,3,43,27],[43,28,43,30],[43,32,43,40],[40,0,40,2],[40,3,40,27],[40,32,40,40],[46,28,46,30],[47,0,47,2],[47,3,47,27],[47,28,47,30],[47,32,47,40],[47,47,47,55],[43,47,43,55],[44,28,44,30],[45,0,45,2],[45,3,45,27],[45,28,45,30],[45,32,45,40],[45,47,45,55],[50,28,50,30],[51,0,51,2],[51,3,51,27],[51,28,51,30],[51,32,51,40],[51,47,51,55],[48,28,48,30],[49,0,49,2],[49,3,49,27],[49,28,49,30],[49,32,49,40],[49,47,49,55],[54,28,54,30],[55,0,55,2],[55,3,55,27],[55,28,55,30],[55,32,55,40],[55,47,55,55],[52,28,52,30],[53,0,53,2],[53,3,53,27],[53,28,53,30],[53,32,53,40],[53,47,53,55],[58,28,58,30],[58,63,59,73],[59,0,59,2],[59,3,59,27],[59,28,59,30],[59,32,59,40],[59,47,59,55],[56,28,56,30],[57,0,57,2],[57,3,57,27],[57,28,57,30],[57,32,57,40],[57,47,57,55],[57,67,57,77],[65,63,66,73],[67,0,67,2],[67,3,67,45],[67,47,67,55],[67,63,67,73],[69,0,69,2],[69,3,69,45],[69,47,69,55],[61,0,61,2],[61,3,61,27],[61,32,61,40],[61,47,61,55],[61,63,62,73],[63,63,64,73],[64,0,64,2],[64,3,64,45],[64,47,64,55],[69,60,69,63],[83,0,83,56],[84,0,84,27],[84,28,84,56],[85,0,85,27],[85,28,85,56],[86,0,86,13],[86,14,86,27],[86,28,86,41],[86,42,86,56],[78,0,78,56],[79,0,79,56],[80,38,80,44],[80,45,80,46],[80,47,80,55],[81,37,81,56],[71,0,71,2],[71,47,71,55],[73,0,73,2],[73,47,73,55],[75,0,75,2],[75,47,75,55]]}
[]
["C",null,null," Ventilation des déductions ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taux ",null,null,"TVA figurant sur factures\nd'achat ou mémoires",null,null,null,null,null,null,null,null,null,null,"%\nprorata\n(*)",null,null,null,"TVA\nDéductible"]
[]
[]
[null,null,null,"1-ACHATS NON IMMOBILISES"]
[null,null,null,"Prestations de services"]
[140,null,null,"- Prestations de services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,{"$f":"DED!E25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG7","v":0}]
[]
[141,null,null,"- Transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG9","v":0}]
[]
[142,null,null,"- Opération de banque",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,{"$f":"DED!E112","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG11","v":0}]
[]
[143,null,null,"- Hôtels de voyageurs, et ensemble immobilier à destination"]
[null,null,null,"touristique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG14","v":0}]
[]
[144,null,null,"- Les opérations des avocats, interprètes, notaires, adoul,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"huissiers de justice et vétérinaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG17","v":0}]
[]
[153,null,null,"- Autres prestations de services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG19","v":0}]
[null,null,null,"Autres achats non immobilisés"]
[145,null,null,"- Achat à l’importation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,{"$f":"DED!E83","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG21","v":0}]
[]
[146,null,null,"- Achat à l’intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,{"$f":"DED!E49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG23","v":0}]
[]
[147,null,null,"- Achat à l’importation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG25","v":0}]
[]
[148,null,null,"- Achat à l’intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,null,null,{"$f":"DED!E70","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG27","v":0}]
[]
[149,null,null,"- Achat à l’importation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG29","v":0}]
[]
[150,null,null,"- Achat à l’intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,{"$f":"DED!E118","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG31","v":0}]
[]
[151,null,null,"- Achat à l’importation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG33","v":0}]
[]
[152,null,null,"- Achat à l’intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,{"$f":"DED!E62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG35","v":0}]
[]
[155,null,null,"Travaux à façon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG37","v":0}]
[]
[156,null,null,"Sous –traitance ( travaux immobiliers )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG39","v":0}]
[]
[157,null,null,"- Déduction prévue par l'article 125-VII du CGI (1/5 du montant de ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DED!E139","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG41>30000,AG41*AQ41,AG41)","v":0}]
[null,null,null,"la TVA payée au cours du mois de décembre 2013)   "]
[null,null,null,"2-IMMOBILISATIONS"]
[162,null,null,"- Achat à l’importation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG44","v":0}]
[]
[163,null,null,"- Achat à l’intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,{"$f":"DED!E92","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG46","v":0}]
[]
[164,null,null,"- Livraison à soi-même autre que les constructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG48","v":0}]
[]
[165,null,null,"- Installation et pose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG50","v":0}]
[]
[166,null,null,"- Constructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG52","v":0}]
[]
[167,null,null,"- Livraison à soi-même de constructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG54","v":0}]
[]
[168,null,null,"-Autres immobilisations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG56","v":0}]
[]
[169,null,null,"-Autres immobilisations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG58","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('FACE 01'!BB39:BJ139)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV65-AV60","v":0}]
[170,null,null,"- Crédit de la période précédente…………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DED!E136","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG60","v":0}]
[]
[180,null,null,"- Déduction complémentaire de la régularisation du prorata",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG62","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV65-AV60-BP58","v":0}]
[190,null,null," Total de la TVA déductible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV62+AV60+AV58+AV56+AV54+AV52+AV50+AV48+AV46+AV41+AV44+AV39+AV37+AV35+AV33+AV31+AV29+AV27+AV25+AV23+AV21+AV19+AV17+AV14+AV11+AV9+AV7)","v":0}]
[]
[]
[200,null,null,"- TVA due (130 - 190 )……………………………………………………….………………..….………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('FACE 01'!BB39:BJ139)>'FACE 02'!AV65:BD65, ROUNDUP((SUM('FACE 01'!BB39:BJ139)-'FACE 02'!AV65:BD65), 0), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BL64*15%","v":0}]
[]
[201,null,null,"- Crédit à reporter (en rouge ) (190 - 130) ………………………………………….………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BP58<AV65, AV65-BP58, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[]
[202,null,null,"- Réduction de 15% du crédit de la période ((190 - 170) - 130) × 15%…………………………………….............",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BI70=\"oui\", IF(BL64>0, (BL64*15%), \"\"), \"\")","v":""}]
[]
[203,null,null,"- Crédit restant cumulé après réduction de 15% (201- 202)…...………………..…………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BI70=\"Oui\", IF(BL64>0, (BL64-BL68), \"\"), \"\")","v":""}]
[]
[204,null,null,"- Crédit accompagné de paiement y compris la TVA due dans le cadre de l'article 115 du CGI."]
[]
[]
["Les indications figurant sur la présente déclaration ainsi que le relevé détaillé des déductions joints, sont certifiés exacts et conformes. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A………….………..….., le…………….……….…",null,null,null,null,null,null,null,"Le"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNATURE ET CACHET"]
[]
["CADRE RESERVE A LA DIRECTION GENERALE DES IMPOTS"]
["PAIEMENT SPONTANE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAIEMENT EN DIFFERE"]
["RECETTE DE L’ADMINISTRATION FISCALE DE…………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBDIVISION DE……………………………………………………"]
["Détail des droits",null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant",null,null,null,null,null,null,null,null,null,null,null,null,null,"Détail des droits",null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant"]
[]
["TVA principal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TVA principal"]
[]
["Majoration de 15% à 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Majoration de 15% à 100%"]
[]
["Pénalité 10%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pénalité 10%"]
[]
["Majorations de retard 5% et 0,5%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Majorations de retard 5% et 0,5%"]
[]
["Amende de 500 DH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amende de 500 DH"]
[]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[]
["Constaté",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant émis par EP n°…………."]
["F.J.O.n°………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART N°……………………………"]
["Quittance N°…………du ……….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mis en recouvrement le……………"]
["MONTANT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R.A.F de : ……………………….."]
["Différence en différé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["A……………………..le………………..…. CACHET DE LA RECETTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A……………………..le………………..…. CACHET DE LA SUBDIVISION"]
[]
[]
[]
[]
["(*) Pourcentage du prorata des déductions figurant sur la déclaration ADC110F"]
["NB. Conformément aux dispositions de l’article 167 du CGI, la base de calcul de la taxe est arrondie à la dizaine de dirhams supérieure et le montant de chaque"]
["versement est arrondi au dirham supérieur."]

{"sheet":"FRS-ICE","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["I.F","R.S","I.C.E"]
[6501149,"SALIPRO MARRAKECH","001537657000037"]
[2200524,"STE COPRALIM CASA","001533006000096"]
[2500543,"STE MARACI CASA","000083905000097"]
[1066142,"STE ARCADE EQUIPEMENT CASA","000102825000059"]
[6501531,"STE CBGS ESSAOUIRA","001538435000080"]
[2501992,"STE SOFRALIM CASA","000094702000063"]
[3332162,"MAROC TELECOM","001522585000066"]
[74711250,"BOUNAKHLA HADJ LAHCEN ESSAOUIRA","001646253000061"]
[6503751,"MENARA MENAGE MARRAKECH","001530309000068"]
[15195575,"MIZA CONFORT SAFI"]
[1103664,"STE MORO TISSU CASA"]
[1020780,"JESSY DIFFUSION CASA","001530970800047"]
[74719960,"RH AGRI ESSAOUIRA","001167670000044"]
[40126522,"IMARAQ TRADING CASA","000229913000058"]
[1620906,"STE BADRA CASA","001535125000016"]
[2201692,"SANIBATI CASA","001539056000094"]
[2801503,"MATRELEC CASA","001431030000006"]
[2201189,"AQUA IONIQUE CASA","001527804000094"]
[40228206,"OCEDIS MAROC INEZGANE","000054704000011"]
[1001419,"ANCIENS ETAB. R.GEISSMAN&FILS","000102268000063"]
[1900208,"DIVERSEY MAROC","001525252000031"]
[40491121,"GARDA TECH -AGADIR","001449819000013"]
[40486450,"O.N.E.E.P","001591281000011"]