{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Ventes","Achats","Tva","Trésorerie"],"not_rendered":{"charts":5,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Ventes","index":0,"n_rows":23,"n_cols":20,"rows_kept":23,"merged":[[1,1,1,3],[1,6,1,8],[1,10,1,13],[1,14,1,16],[2,1,4,1],[2,2,4,2],[2,3,3,6],[2,7,4,7],[2,8,4,8],[2,10,2,16]]}
[]
[null,"Budget des ventes mensuelles",{"$nulls":4},"Les montants sont exprimés en €",{"$nulls":3},{"$f":"IF(R5>0,\" indiquer le % de ventes par condition de réglement\",\" \")","v":" indiquer le % de ventes par condition de réglement"},{"$nulls":3},"Les montants sont exprimés en €"]
[null,"Mois","Montant \nHT","Répartition des ventes mensuelles \nhors taxe par taux de TVA",{"$nulls":3},"TVA \ncollectée","Montant \nTTC",null,"Conditions de règlement",{"$nulls":6},"Ecart"]
[{"$nulls":10},"Comptant","30 jours","> 30 j <= 60 j","> 60 j <= 90 j","> 90 <= 120 j","> 120 <= 150 j","Total"]
[{"$nulls":3},{"v":0,"d":"Tva 0.0%"},{"v":0.021,"d":"Tva 2.1%"},{"v":0.1,"d":"Tva 10.0%"},{"v":0.2,"d":"Tva 20.0%"},{"$nulls":9},{"$f":"SUM(K5:P5)","v":{"v":0,"d":"0%"}},{"$f":"100%-Q5","v":{"v":1,"d":"100%"}},{"$f":"IF(Q5>100%,\"erreur\",\" \")","v":" "}]
[null,"2019-01-31",{"$nulls":4},{"$f":"C6-D6-E6-F6","v":{"v":0,"d":"0 "}},{"$f":"(D6*$D$5)+(E6*$E$5)+(F6*$F$5)+(G6*$G$5)","v":{"v":0,"d":"0 "}},{"$f":"(D6*(1+$D$5))+(E6*(1+$E$5))+(F6*(1+$F$5))+(G6*(1+$G$5))","v":{"v":0,"d":"0 "}},{"$f":"I6/1000","v":0},{"$f":"I6*$K$5","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$f":"(K6+L7+M8+N9+O10+P11)-I6","v":{"v":0,"d":"0 "}},{"$f":"Q6/1000","v":0},{"$f":"B6","v":"2019-01-31"}]
[null,{"$f":"IF(ISBLANK($B$6),\" \",EOMONTH(B6,1))","v":"2019-02-28"},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I7/1000","v":0},{"v":0,"d":"0 "},{"$f":"I6*$L$5","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"Q7/1000","v":0},"2019-02-28"]
[null,"2019-03-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I8/1000","v":0},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I6*$M$5","v":{"v":0,"d":"0 "}},{"$nulls":3},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-03-31"]
[null,"2019-04-30",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I6*$N$5","v":{"v":0,"d":"0 "}},null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-04-30"]
[null,"2019-05-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I6*$O$5","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-05-31"]
[null,"2019-06-30",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I6*$P$5","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-06-30"]
[null,"2019-07-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-07-31"]
[null,"2019-08-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-08-31"]
[null,"2019-09-30",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-09-30"]
[null,"2019-10-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-10-31"]
[null,"2019-11-30",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-11-30"]
[null,"2019-12-31",{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-12-31"]
[null,"Total",{"$f":"SUM(C6:C17)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,{"$f":"IF(ISBLANK(mois_1),\" \",EOMONTH(T17,1))","v":"2020-01-31"}]
[{"$nulls":12},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-02-29"]
[{"$nulls":13},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-03-31"]
[{"$nulls":14},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-04-30"]
[{"$nulls":15},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-05-31"]
[{"$nulls":10},{"$f":"SUM(K6:K22)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]

{"sheet":"Achats","index":1,"n_rows":23,"n_cols":21,"rows_kept":23,"merged":[[1,1,1,5],[1,11,1,14],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,3,7],[2,8,4,8],[2,9,4,9],[2,11,2,17]]}
[]
[null,"Budget des achats mensuels de matières et marchandises",{"$nulls":9},{"$f":"IF(S5>0,\" indiquer le % des achats par condition de réglement\",\" \")","v":" indiquer le % des achats par condition de réglement"}]
[null,"Mois","Rappel \ndes ventes\n mensuelles \nHT","Achats mensuels\nHT ","Répartition des ventes mensuelles \nhors taxe par taux de TVA",{"$nulls":3},"TVA \ncollectée","Montant \nTTC",null,"Conditions de règlement",{"$nulls":6},"Ecart"]
[{"$nulls":11},"Comptant","30 jours","> 30 j <= 60 j","> 60 j <= 90 j","> 90 <= 120 j","> 120 <= 150 j","Total"]
[{"$nulls":4},{"v":0,"d":"Tva 0.0%"},{"v":0.021,"d":"Tva 2.1%"},{"v":0.1,"d":"Tva 10.0%"},{"v":0.2,"d":"Tva 20.0%"},{"$nulls":9},{"$f":"SUM(L5:Q5)","v":{"v":0,"d":"0%"}},{"$f":"100%-R5","v":{"v":1,"d":"100%"}},{"$f":"IF(R5>100%,\"erreur\",\" \")","v":" "}]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",Ventes!$B$6)","v":"2019-01-31"},{"$f":"Ventes!C6","v":{"v":0,"d":"0 "}},{"$nulls":4},{"$f":"D6-E6-F6-G6","v":{"v":0,"d":"0 "}},{"$f":"(E6*$E$5)+(F6*$F$5)+(G6*$G$5)+(H6*$H$5)","v":{"v":0,"d":"0 "}},{"$f":"(E6*(1+$E$5))+(F6*(1+$F$5))+(G6*(1+$G$5))+(H6*(1+$H$5))","v":{"v":0,"d":"0 "}},{"$f":"J6/1000","v":0},{"$f":"J6*$L$5","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$f":"(L6+M7+N8+O9+P10+Q11)-J6","v":{"v":0,"d":"0 "}},{"$f":"R6/1000","v":0},{"$f":"B6","v":"2019-01-31"}]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B6,1))","v":"2019-02-28"},{"$f":"Ventes!C7","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"$f":"(E7*$E$5)+(F7*$F$5)+(G7*$G$5)+(H7*$H$5)","v":{"v":0,"d":"0 "}},{"$f":"(E7*(1+$E$5))+(F7*(1+$F$5))+(G7*(1+$G$5))+(H7*(1+$H$5))","v":{"v":0,"d":"0 "}},{"$f":"J7/1000","v":0},{"v":0,"d":"0 "},{"$f":"J6*$M$5","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"R7/1000","v":0},{"$f":"B7","v":"2019-02-28"}]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B7,1))","v":"2019-03-31"},{"$f":"Ventes!C8","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"J8/1000","v":0},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"J6*$N$5","v":{"v":0,"d":"0 "}},{"$nulls":3},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-03-31"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B8,1))","v":"2019-04-30"},{"$f":"Ventes!C9","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"J6*$O$5","v":{"v":0,"d":"0 "}},null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-04-30"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B9,1))","v":"2019-05-31"},{"$f":"Ventes!C10","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"J6*$P$5","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-05-31"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B10,1))","v":"2019-06-30"},{"$f":"Ventes!C11","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"J6*$Q$5","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-06-30"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B11,1))","v":"2019-07-31"},{"$f":"Ventes!C12","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-07-31"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B12,1))","v":"2019-08-31"},{"$f":"Ventes!C13","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-08-31"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B13,1))","v":"2019-09-30"},{"$f":"Ventes!C14","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-09-30"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B14,1))","v":"2019-10-31"},{"$f":"Ventes!C15","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-10-31"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B15,1))","v":"2019-11-30"},{"$f":"Ventes!C16","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-11-30"]
[null,{"$f":"IF(ISBLANK(Ventes!$B$6),\" \",EOMONTH(B16,1))","v":"2019-12-31"},{"$f":"Ventes!C17","v":{"v":0,"d":"0 "}},{"$nulls":4},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},0,"2019-12-31"]
[null,"Total",{"$f":"SUM(C6:C17)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,{"$f":"IF(ISBLANK(mois_1),\" \",EOMONTH(U17,1))","v":"2020-01-31"}]
[{"$nulls":13},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-02-29"]
[{"$nulls":14},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-03-31"]
[{"$nulls":15},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-04-30"]
[{"$nulls":16},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,0,"2020-05-31"]
[{"$nulls":11},{"$f":"SUM(L6:L22)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]

{"sheet":"Tva","index":2,"n_rows":21,"n_cols":17,"rows_kept":21}
[]
[null,"Budget de TVA",{"$f":"IF(ISBLANK(mois_1),\" \",mois_1)","v":"2019-01-31"},{"$f":"IF(ISBLANK(mois_1),\" \",EOMONTH(C2,1))","v":"2019-02-28"},"2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","Total"]
[null,"Sur ventes",{"$f":"Ventes!H6","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H7","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H8","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H9","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H10","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H11","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H12","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H13","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H14","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H15","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H16","v":{"v":0,"d":"0 "}},{"$f":"Ventes!H17","v":{"v":0,"d":"0 "}},{"$f":"SUM(C3:N3)","v":{"v":0,"d":"0 "}},{"$f":"IF(O3=tva_collectée,\"ok\",O3-tva_collectée)","v":"ok"}]
[null,"Sur autres produits",{"$nulls":12},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"0 "}}]
[null,"Sur cessions d’actifs",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"TVA collectée",{"$f":"SUM(C3:C5)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D3:D5)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(O3:O5)","v":{"v":0,"d":"0 "}}]
[null,"Sur achats",{"$f":"Achats!I6","v":{"v":0,"d":"0 "}},{"$f":"Achats!I7","v":{"v":0,"d":"0 "}},{"$f":"Achats!I8","v":{"v":0,"d":"0 "}},{"$f":"Achats!I9","v":{"v":0,"d":"0 "}},{"$f":"Achats!I10","v":{"v":0,"d":"0 "}},{"$f":"Achats!I11","v":{"v":0,"d":"0 "}},{"$f":"Achats!I12","v":{"v":0,"d":"0 "}},{"$f":"Achats!I13","v":{"v":0,"d":"0 "}},{"$f":"Achats!I14","v":{"v":0,"d":"0 "}},{"$f":"Achats!I15","v":{"v":0,"d":"0 "}},{"$f":"Achats!I16","v":{"v":0,"d":"0 "}},{"$f":"Achats!I17","v":{"v":0,"d":"0 "}},{"$f":"SUM(C7:N7)","v":{"v":0,"d":"0 "}},{"$f":"IF(O7=tva_déductible,\"ok\",O7-tva_déductible)","v":"ok"}]
[null,"Sur frais généraux",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Sur autres charges",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Sur investissements",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"TVA récupérable ",{"$f":"SUM(C7:C10)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D7:D10)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(O7:O10)","v":{"v":0,"d":"0 "}}]
[null,"Solde mensuel",{"$f":"C6-C11","v":{"v":0,"d":"0 "}},{"$f":"D6-D11","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(C12:N12)","v":{"v":0,"d":"0 "}}]
[null,"TVA à payer",{"$f":"IF(C12>0,C12,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(D12>0,D12,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Crédit de tva",{"$f":"IF(C12<0,-C12,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(D12<0,-D12,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(C14:N14)","v":{"v":0,"d":"0 "}}]
[]
[null,"Crédits de tva cumulés",{"$f":"C14","v":{"v":0,"d":"0 "}},{"$f":"D14+C16-C18-C17","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Imputation du crédit de tva",null,{"$f":"IF(C13<=0,0,IF(C13>C19,C19,C13))","v":{"v":0,"d":"0 "}},{"$f":"IF(D13<=0,0,IF(D13>D19,D19,D13))","v":{"v":0,"d":"0 "}},{"$f":"IF(E13<=0,0,IF(E13>E19,E19,E13))","v":{"v":0,"d":"0 "}},{"$f":"IF(F13<=0,0,IF(F13>F19,F19,F13))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(C17:N17)","v":{"v":0,"d":"0 "}}]
[null,"Remboursement de crédit TVA",{"$nulls":12},{"$f":"SUM(C18:N18)","v":{"v":0,"d":"0 "}}]
[null,"Solde après remboursement de TVA",{"$f":"C14","v":{"v":0,"d":"0 "}},{"$f":"D16-D18-D17","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Paiement de la TVA",null,{"$f":"IF(C12>0,C12,0)","v":{"v":0,"d":"0 "}},{"$f":"IF((D13-D19)<0,0,D13-D19)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(C20:N20)","v":{"v":0,"d":"0 "}},{"$f":"IF((O20-O18)=O12,\"ok\",O20-O18-O12)","v":"ok"},{"$f":"IF(ISERROR(IF(N12=(P20/-1),\"ok\",N12-(P20/-1))),\" \",IF(N12=(P20/-1),\"ok\",N12-(P20/-1)))","v":" "}]
[{"$nulls":15},{"$f":"IF(ISERROR(O20-P20-O18),0,O20-P20-O18)","v":{"v":0,"d":"0 "}},{"$f":"IF(P21=0,\" \",IF(O12=P21,\"ok\",O12-P21))","v":" "}]

{"sheet":"Trésorerie","index":3,"n_rows":40,"n_cols":22,"rows_kept":40,"merged":[[0,1,0,3],[1,1,1,2],[2,1,2,2],[3,1,15,1],[16,1,16,2],[17,1,35,1],[36,1,36,2],[38,1,38,2]]}
[null,{"$f":"IF(ISBLANK(D3),\"Renseigner le solde de trésorerie en début du 1° mois\",\" \")","v":"Renseigner le solde de trésorerie en début du 1° mois"}]
[null,"Budget de trésorerie",null,{"$f":"IF(ISBLANK(mois_1),\" \",mois_1)","v":"2019-01-31"},{"$f":"IF(ISBLANK(mois_1),\" \",EOMONTH(D2,1))","v":"2019-02-28"},"2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30"]
[null,"Solde de trésorerie en début de mois",null,null,{"$f":"D39","v":{"v":0,"d":"0 "}},{"$f":"E39","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"ENCAISSEMENTS","Clients/ventes budgétées",{"$f":"Ventes!Q6","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q7","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q8","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q9","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q10","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q11","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q12","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q13","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q14","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q15","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q16","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q17","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q18","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q19","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q20","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q21","v":{"v":0,"d":"0 "}},{"$f":"Ventes!Q22","v":{"v":0,"d":"0 "}},null,{"$f":"IF(SUM(D4:U4)=ca_ttc,\"ok\",SUM(D4:U4)-ca_ttc)","v":"ok"}]
[null,null,"Clients/ventes antérieures"]
[null,null,"Ajustements éventuels/clients"]
[null,null,"Apport en capital"]
[null,null,"Apport en compte courant"]
[null,null,"Emprunts contractés"]
[null,null,"Encaissements aides & subventions"]
[null,null,"Remboursement de crédit de tva",{"$f":"Tva!C18","v":{"v":0,"d":"0 "}},{"$f":"Tva!D18","v":{"v":0,"d":"0 "}},{"$f":"Tva!E18","v":{"v":0,"d":"0 "}},{"$f":"Tva!F18","v":{"v":0,"d":"0 "}},{"$f":"Tva!G18","v":{"v":0,"d":"0 "}},{"$f":"Tva!H18","v":{"v":0,"d":"0 "}},{"$f":"Tva!I18","v":{"v":0,"d":"0 "}},{"$f":"Tva!J18","v":{"v":0,"d":"0 "}},{"$f":"Tva!K18","v":{"v":0,"d":"0 "}},{"$f":"Tva!L18","v":{"v":0,"d":"0 "}},{"$f":"Tva!M18","v":{"v":0,"d":"0 "}},{"$f":"Tva!N18","v":{"v":0,"d":"0 "}}]
[]
[null,null,"Cession d'actifs"]
[null,null,"Poduits financiers"]
[]
[]
[null,"Total encaissements",null,{"$f":"SUM(D4:D16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(E4:E16)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M4:M16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(N4:N16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O4:O16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(P4:P16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(Q4:Q16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(R4:R16)","v":{"v":0,"d":"0 "}},{"$f":"SUM(S4:S16)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"$f":"SUM(U4:U16)","v":{"v":0,"d":"0 "}}]
[null,"DECAISSEMENTS","Fournisseurs/achats budgétés",{"$f":"Achats!R6","v":{"v":0,"d":"0 "}},{"$f":"Achats!R7","v":{"v":0,"d":"0 "}},{"$f":"Achats!R8","v":{"v":0,"d":"0 "}},{"$f":"Achats!R9","v":{"v":0,"d":"0 "}},{"$f":"Achats!R10","v":{"v":0,"d":"0 "}},{"$f":"Achats!R11","v":{"v":0,"d":"0 "}},{"$f":"Achats!R12","v":{"v":0,"d":"0 "}},{"$f":"Achats!R13","v":{"v":0,"d":"0 "}},{"$f":"Achats!R14","v":{"v":0,"d":"0 "}},{"$f":"Achats!R15","v":{"v":0,"d":"0 "}},{"$f":"Achats!R16","v":{"v":0,"d":"0 "}},{"$f":"Achats!R17","v":{"v":0,"d":"0 "}},{"$f":"Achats!R18","v":{"v":0,"d":"0 "}},{"$f":"Achats!R19","v":{"v":0,"d":"0 "}},{"$f":"Achats!R20","v":{"v":0,"d":"0 "}},{"$f":"Achats!R21","v":{"v":0,"d":"0 "}},{"$f":"Achats!R22","v":{"v":0,"d":"0 "}},null,{"$f":"IF(SUM(D18:U18)=achats_ttc,\"ok\",SUM(D18:U18)-achats_ttc)","v":"ok"}]
[null,null,"Fournisseurs/achats antérieurs"]
[null,null,"Ajustements éventuels/fournisseurs"]
[null,null,"Echéances de crédit-bail TTC"]
[null,null,"Loyers TTC"]
[null,null,"Assurances"]
[null,null,"Fournisseurs autres achats et services"]
[null,null,"Impôts & taxes"]
[null,null,"Impôts sur les sociétés"]
[null,null,"Salaires nets"]
[null,null,"Charges sociales "]
[null,null,"Fournisseurs d'immobilisations"]
[null,null,"Paiement tva",{"$f":"Tva!C20","v":{"v":0,"d":"0 "}},{"$f":"Tva!D20","v":{"v":0,"d":"0 "}},{"$f":"Tva!E20","v":{"v":0,"d":"0 "}},{"$f":"Tva!F20","v":{"v":0,"d":"0 "}},{"$f":"Tva!G20","v":{"v":0,"d":"0 "}},{"$f":"Tva!H20","v":{"v":0,"d":"0 "}},{"$f":"Tva!I20","v":{"v":0,"d":"0 "}},{"$f":"Tva!J20","v":{"v":0,"d":"0 "}},{"$f":"Tva!K20","v":{"v":0,"d":"0 "}},{"$f":"Tva!L20","v":{"v":0,"d":"0 "}},{"$f":"Tva!M20","v":{"v":0,"d":"0 "}},{"$f":"Tva!N20","v":{"v":0,"d":"0 "}}]
[]
[null,null,"Échéances d'emprunts"]
[null,null,"Remboursement compte courants"]
[null,null,"Dividendes"]
[null,null,"Agios et frais bancaires"]
[]
[null,"Total décaissements",null,{"$f":"SUM(D18:D36)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Solde de trésorerie en fin de mois",null,{"$f":"D3+D17-D37","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":3},{"$f":"D39/1000","v":0},{"$f":"E39/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]