{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Devis","Facture","Clients","JANVIER","FEVRIER","MARS","AVRIL","MAI","JUIN","JUILLET","AOUT","SEPTEMBRE","OCTOBRE","NOVEMBRE","DECEMBRE","RECAPITULATIF","Suivi CA","Explications","Fonc. logiciel"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Devis","index":0,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,0,41,6],[42,0,42,6],[7,4,7,6],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[11,5,11,6],[7,0,7,1],[29,0,29,3],[30,0,30,3],[31,0,31,3],[12,0,12,2],[13,0,13,2],[8,4,8,6],[9,4,9,6],[15,1,15,3],[27,0,27,3],[28,0,28,3],[9,0,9,2],[10,0,10,2],[11,0,11,2],[35,0,35,3],[36,0,36,3],[37,0,37,3],[32,0,32,3],[33,0,33,3]]}
[]
[]
[]
[]
[]
[]
[]
["N° de Devis:D2020-",null,10]
[]
["Client:",null,null,null,"Site Internet"]
[]
[null,null,null,null,"Date :",{"$f":"TODAY()","v":"2020-03-10"}]
[]
[]
[]
[null,"Désignation ",null,null,"Qté","Prix / U","Total Euros"]
[null,null,null,null,null,null,{"$f":"IF(E17=\"\",\"\",E17*F17)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Bon pour accord ",null,null,null,null,null,""]
["Fait le",null,null,null,null,null,""]
["Signature",null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,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 Total",null,null,{"$f":"SUM(G17:G34)","v":0}]
["Durée de validité de l'offre : 1 mois"]
["Délai de réalisation : 3 semaines"]
[]
[]
[null,null,null,"TVA non applicable, art.293-B du CGI"]
[]
["MoustiK & K-cahuète - 4 Lotissement Terrefort - 33750 BARON - N° de siret : "]
["Mail: moustiketkcahuete@gmail.com         Tél : "]

{"sheet":"Facture","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,42,6],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[41,0,41,6],[28,0,28,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[16,0,16,3],[7,0,7,1],[7,4,7,6],[8,4,8,6],[9,0,9,2],[9,4,9,6],[10,0,10,2],[11,0,11,2],[11,5,11,6],[12,0,12,2],[13,0,13,2],[15,1,15,3]]}
[]
[]
[]
[]
[]
[]
[]
["N° de facture :",null,20200013]
[]
["Client:",null,null,null,"              Site Internet"]
["Mme DEL SAZ Marie-Antoinette"]
["2 le Tillac Nord",null,null,null,"Date :",{"$f":"TODAY()","v":"2020-03-10"}]
["33490 SAINT MARTIAL"]
["Tél : 06 85 74 65 72"]
[]
[null,"Désignation ",null,null,"Qté","Prix / U","Total Euros"]
[]
[null,null,null,null,null,null,{"$f":"IF(E18=\"\",\"\",E18*F18)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,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 Total",null,null,{"$f":"SUM(G17:G34)","v":0}]
[null,null,null,"Acompte"]
[null,null,null,"Reste dû",null,null,{"$f":"G35-G36","v":0}]
["Mode de règlement :",null,"Chèque"]
["Date :",null,"2019-02-20"]
[null,null,null,"TVA non applicable, art.293-B du CGI"]
[]
["MoustiK & K-cahuète - 4 Lotissement Terrefort - 33750 BARON - N° de siret : "]
["Mail: moustiketkcahuete@gmail.com         Tél : "]

{"sheet":"Clients","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Civilité","Prénom","Nom","Adresse ","code Postal","Ville","N° Téléphone","e-mail","N° TVA"]
["Mme","Marie-Antoinette","DEL SAZ","2 le Tillac Nord",33490,"SAINT MARTIAL",685746572,"toinette.delsaz@sfr.fr"]

{"sheet":"JANVIER","index":3,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","JANVIER"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. De l'Achat","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"FEVRIER","index":4,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","FEVRIER"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"MARS","index":5,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","MARS"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"AVRIL","index":6,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","AVRIL"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"MAI","index":7,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","MAI"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"JUIN","index":8,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","JUIN"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"JUILLET","index":9,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","JUILLET"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"AOUT","index":10,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","AOUT"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"SEPTEMBRE","index":11,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","SEPTEMBRE"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date",null,"Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"OCTOBRE","index":12,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","OCTOBRE"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"NOVEMBRE","index":13,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","OCTOBRE"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"DECEMBRE","index":14,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ANNEE :",2020,null,"Pour les recettes","Nature = Sac à dos, Doudou, etc…",null,null,"Pour les achats ","Réf de l'Achat = Facture, ticket de caisse, Note,…."]
[null,null,null,null,null,null,null,"Mode d'encaissement = Chèque, espèces, virement",null,null,null,"Mode de Paiement = Espèces, chèques,virement, etc…"]
[null,null,null,"MOIS :","OCTOBRE"]
[]
["Livre chronologique des recettes",null,null,null,null,null,null,null,"Registre des achats et autres dépenses"]
[]
["Date","N° de Facture","Réf. de la pièce","Client","Nature","Montant","Mode d’encaissement",null,"Date","Réf. de la pièce","Fournisseur, désignation","Nature","Montant","Mode de paiement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(F8:F109)","v":0},null,null,null,null,null,"TOTAL DU MOIS",{"$f":"SUM(M8:M109)","v":0}]
[]
[null,null,null,null,"SOLDE DU MOIS",{"$f":"+F111-M111","v":0}]

{"sheet":"RECAPITULATIF","index":15,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[17,11,17,12],[17,8,17,10]]}
["Récapitulatif",null,"Les données de ce feuillet sont mises à jour automatiquement",null,null,null,null,null,"Résultat Mensuel"]
[]
["MOIS","Recettes","Dépenses","Solde mois","Trésorerie",null,"MOIS","Solde  mois","Charges","F.Bancaires","Assurances","Bénéfice Net"]
["JANVIER",{"$f":"JANVIER!$F$111","v":0},{"$f":"JANVIER!$M$111","v":0},{"$f":"B4-C4","v":0},{"$f":"D4","v":0},null,"JANVIER",{"$f":"D4","v":0},{"$f":"H4*24.8%","v":0},10,10,{"$f":"H4-SUM(I4:K4)","v":-20}]
["FEVRIER",{"$f":"FEVRIER!$F$111","v":0},{"$f":"FEVRIER!$M$111","v":0},{"$f":"B5-C5","v":0},{"$f":"E4+D5","v":0},null,"FEVRIER",{"$f":"D5","v":0},{"$f":"H5*24.8%","v":0},10,10,-20]
["MARS",{"$f":"MARS!$F$111","v":0},{"$f":"MARS!$M$111","v":0},0,{"$f":"E5+D6","v":0},null,"MARS",0,0,10,10,-20]
["AVRIL",{"$f":"AVRIL!$F$111","v":0},{"$f":"AVRIL!$M$111","v":0},0,0,null,"AVRIL",0,0,10,10,-20]
["MAI",{"$f":"MAI!$F$111","v":0},{"$f":"MAI!$M$111","v":0},0,0,null,"MAI",0,0,10,10,-20]
["JUIN",{"$f":"JUIN!$F$111","v":0},{"$f":"JUIN!$M$111","v":0},0,0,null,"JUIN",0,0,10,10,-20]
["JUILLET",{"$f":"JUILLET!$F$111","v":0},{"$f":"JUILLET!$M$111","v":0},0,0,null,"JUILLET",0,0,10,10,-20]
["AOUT",{"$f":"AOUT!$F$111","v":0},{"$f":"AOUT!$M$111","v":0},0,0,null,"AOUT",0,0,10,10,-20]
["SEPTEMBRE",{"$f":"SEPTEMBRE!$F$111","v":0},{"$f":"SEPTEMBRE!$M$111","v":0},0,0,null,"SEPTEMBRE",0,0,10,10,-20]
["OCTOBRE",{"$f":"OCTOBRE!$F$111","v":0},{"$f":"OCTOBRE!$M$111","v":0},0,0,null,"OCTOBRE",0,0,10,10,-20]
["NOVEMBRE",{"$f":"NOVEMBRE!$F$111","v":0},{"$f":"NOVEMBRE!$M$111","v":0},0,0,null,"NOVEMBRE",0,0,10,10,-20]
["DECEMBRE",{"$f":"DECEMBRE!$F$111","v":0},{"$f":"DECEMBRE!$M$111","v":0},0,{"$f":"E14+D15","v":0},null,"DECEMBRE",0,0,10,10,-20]
[]
["TOTAUX",{"$f":"SUM(B4:B15)","v":0},{"$f":"SUM(C4:C15)","v":0},null,null,null,"TOTAUX",{"$f":"SUM(H4:H15)","v":0},{"$f":"SUM(I4:I15)","v":0}]
["SOLDE ANNEE",{"$f":"+B17-C17","v":0},null,null,null,null,"SOLDE ANNEE",{"$f":"+H17-I17","v":0},"                   TOTAL TRESORERIE/Exercice",null,null,{"$f":"SUM(L4:L15)","v":-240}]
[null,null,"Départ Activité au20/03/20 = 57644 € de CA"]
[null,null,"Sur année complète = 72500 €"]
["Graphique des recettes et achats par mois :",null,null,null,null,null,"Graphique Résultat Mensuel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graphique de trésorerie :"]

{"sheet":"Suivi CA","index":16,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,2,12]]}
[]
[]
["                       Suivi de Chiffre d'affaire MoustiK et K- cahuète 2020"]
[]
[]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13"]
["Nombre de","Chiffre d'affaires","Charges sociales","Impôts libératoires","Taxe pour la","Cotisation à la","Montant total des","Résultat avant ",null,"Frais ","Frais ",null,"Reste net"]
["Clients","cumulé","Cumulées","cumulés","Formation cumulée","chambre des métiers","prélèvements","charges",null,"bancaire","d'assurances"]
["1,00",100,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":22},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":1.7000000000000002},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":0.3},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":0.48},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":24.48},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":75.52},null,10,10,null,{"$f":"H9-J9-K9","v":55.519999999999996}]
["2,00",200,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":44},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":3.4000000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":0.6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":0.96},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":48.96},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":151.04},null,10,10,null,{"$f":"H10-J10-K10","v":131.04}]
["3,00",300,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":66},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":5.1000000000000005},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":0.9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":1.44},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":73.44},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":226.56},null,10,10,null,206.56]
["4,00",400,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":88},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":6.8000000000000007},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":1.2},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":1.92},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":97.92},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":302.08},null,10,10,null,282.08]
["5,00",500,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":110},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":8.5},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":1.5},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":2.4},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":122.4},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":377.6},null,10,10,null,357.6]
["6,00",600,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":132},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":10.200000000000001},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":1.8},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":2.88},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":146.88},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":453.12},null,10,10,null,433.12]
["7,00",700,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":154},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":11.9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":2.1},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":3.36},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":171.36},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":528.64},null,10,10,null,508.64]
["8,00",800,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":176},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":13.600000000000001},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":2.4},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":3.84},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":195.84},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":604.16},null,10,10,null,584.16]
["9,00",900,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":198},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":15.3},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":2.7},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":4.3199999999999994},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":220.32},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":679.68000000000006},null,10,10,null,659.68000000000006]
["10,00",1000,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":220},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":17},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":3},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":4.8},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":244.8},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":755.2},null,10,10,null,735.2]
["11,00",1100,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":242},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":18.700000000000003},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":3.3000000000000003},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":5.2799999999999994},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":269.27999999999997},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":830.72},null,10,10,null,810.72]
["12,00",1200,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":264},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":20.400000000000002},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":3.6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":5.76},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":293.76},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":906.24},null,10,10,null,886.24]
["13,00",1300,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":286},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":22.1},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":3.9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":6.2399999999999993},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":318.24},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":981.76},null,10,10,null,961.76]
["14,00",1400,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":308},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":23.8},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":4.2},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":6.72},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":342.72},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1057.28},null,10,10,null,1037.28]
["15,00",1500,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":330},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":25.500000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":4.5},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":7.1999999999999993},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":367.2},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1132.8},null,10,10,null,1112.8]
["16,00",1600,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":352},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":27.200000000000003},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":4.8},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":7.68},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":391.68},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1208.32},null,10,10,null,1188.32]
["17,00",1700,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":374},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":28.900000000000002},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":5.1000000000000005},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":8.16},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":416.16},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1283.8399999999999},null,10,10,null,1263.8399999999999]
["18,00",1800,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":396},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":30.6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":5.4},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":8.6399999999999988},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":440.64},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1359.3600000000001},null,10,10,null,1339.3600000000001]
["19,00",1900,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":418},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":32.300000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":5.7},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":9.1199999999999992},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":465.12},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1434.88},null,10,10,null,1414.88]
["20,00",2000,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":440},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":34},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":9.6},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":489.6},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1510.4},null,10,10,null,1490.4]
["21,00",2100,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":462},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":35.700000000000003},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":6.3},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":10.079999999999998},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":514.08000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1585.92},null,10,10,null,1565.92]
["22,00",2200,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":484},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":37.400000000000006},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":6.6000000000000005},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":10.559999999999999},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":538.55999999999995},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1661.44},null,10,10,null,1641.44]
["23,00",2300,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":506},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":39.1},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":6.9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":11.04},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":563.04},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1736.96},null,10,10,null,1716.96]
["24,00",2400,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":528},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":40.800000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":7.2},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":11.52},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":587.52},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1812.48},null,10,10,null,1792.48]
["25,00",2500,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":550},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":42.5},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":7.5},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":11.999999999999998},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":612},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1888},null,10,10,null,1868]
["26,00",2600,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":572},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":44.2},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":7.8},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":12.479999999999999},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":636.48},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":1963.52},null,10,10,null,1943.52]
["27,00",2700,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":594},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":45.900000000000006},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":8.1},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":12.959999999999999},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":660.96},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2039.04},null,10,10,null,2019.04]
["28,00",2800,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":616},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":47.6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":8.4},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":13.44},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":685.44},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2114.56},null,10,10,null,2094.56]
["29,00",2900,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":638},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":49.300000000000004},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":8.7000000000000011},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":13.919999999999998},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":709.92},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2190.08},null,10,10,null,2170.08]
["30,00",3000,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":660},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":51.000000000000007},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":14.399999999999999},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":734.4},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2265.6},null,10,10,null,2245.6]
["31,00",3100,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":682},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":52.7},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":9.3000000000000007},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":14.879999999999999},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":758.88},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2341.12},null,10,10,null,2321.12]
["32,00",3200,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":704},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":54.400000000000006},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":9.6},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":15.36},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":783.36},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2416.64},null,10,10,null,2396.64]
["33,00",3300,{"$f":"Tableau4[[#This Row],[Colonne2]]*0.22","v":726},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.017","v":56.1},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.003","v":9.9},{"$f":"Tableau4[[#This Row],[Colonne2]]*0.0048","v":15.839999999999998},{"$f":"SUM(Tableau4[[#This Row],[Colonne3]:[Colonne6]])","v":807.84},{"$f":"Tableau4[[#This Row],[Colonne2]]-Tableau4[[#This Row],[Colonne7]]","v":2492.16},null,10,10,null,2472.16]

{"sheet":"Explications","index":17,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,0,10,7],[0,0,0,3],[2,0,2,7],[4,0,4,6],[7,0,7,7],[8,0,8,6],[23,0,23,7],[25,0,25,7],[27,0,27,7],[12,0,12,7],[13,0,13,7],[15,0,15,7],[16,0,16,7],[18,0,18,7],[20,0,20,7]]}
["Livre des recettes-dépenses pour le micro-entrepreneur"]
[]
["Les Chambres de Commerce et d'Industrie ont conçu un outil pratique et simple pour vous aider à suivre l'évolution de votre chiffre d'affaires tout au long de l'année. "]
[]
["Vous pouvez utiliser ce modèle de deux façons différentes :\n- vous imprimez les pages et vous les complétez manuellement\n- vous le remplissez directement sur Excel et les calculs sont automatiques."]
[]
["Le livre des recettes"]
["Pour bien le compléter vous devez d'abord définir le montant de votre plafond maximum de chiffre d'affaires à ne pas dépasser. Pour cela, consultez le site des CCI pour savoir de quel seuil relève votre activité : "]
["http://www.cci.fr/web/auto-entrepreneur/chiffre-d-affaires-micro-entrepreneur"]
[]
["En fonction de votre activité, vous utiliserez l'onglet :\n- Activité principale : si vous n'exercez qu'une seule activité\n- Activité principale et activité secondaire : si vous exercez une activité mixte. "]
[]
["Si vous avez démarré votre activité en cours d'année vous devez ABSOLUMENT calculé votre plafond au prorata temporis. Calculez votre seuil de chiffre d'affaires de la 1ère année avec le calculateur de l'APCE :"]
["http://www.apce.com/apce3/auto-entrepreneur/index.php?&rub=&rubID=1&page=10550"]
[]
["Pour chaque vente, vous devez indiquer :\n- la date\n- la référence de la pièce (numéro de facture, devis, ticket de caisse, etc.)\n- le mode d'encaissement (espèces, chèque, carte bleue)\n- le montant de la vente"]
["Le tableau calculera alors automatiquement votre chiffre d'affaires du mois et votre chiffre d'affaires total de l'année. \n\nSi vous avez une activité mixte, le calcul se fait automatiquement dans chaque onglet (\"activité principale\" et \"activité secondaire\") ainsi que dans l'onglet \"mixte\". Cet onglet vous permet de suivre la part de chiffre d'affaires à ne pas dépasser pour chacune des activité."]
[]
["Il existe alors trois cas possibles :\n- la case \"total année\" est verte : tout va bien, votre chiffre d'affaires est inférieur au seuil maximal\n- la case \"total année\" est orange : attention votre chiffre d'affaires est proche du plafond (à 20%)\n- la case \"total année\" est rouge : vous avez atteint voire dépassé le seuil de chiffre d'affaires, contactez au plus vite votre CCI pour ne pas dépasser la marge de tolérance ou changer de régime."]
[]
["Ces tableaux vous aideront à connaître votre chiffre d'affaires. \n\nRappelons que c'est sur ce montant que vous paierez votre impôt et vos cotisations sociales. Ce n'est pas ce qui restera dans votre poche ! \n\nVous devez bien garder en tête que ce que vous allez réellement gagner est égal à :\n     Chiffre d'affaires - dépenses - impôt - cotisations sociales\n\nLe chiffre d'affaires est la somme des ventes que vous avez effectuées et qui vous ont été payées et correspond au montant que vous devez déclarer à la fin du mois ou du trimestre et lors de votre déclaration d'impôt sur le revenu."]
[]
["Le livre des dépenses"]
["Vous devrez également remplir l'onglet \"registre achat\" qui va servir à lister l'ensemble de vos dépenses liées à l'auto-entreprise."]
[]
["N'oubliez pas de s'incrire dans ce livre, TOUTES vos dépenses (assurances, achats, abonnements de transport…) y compris vos costisations sociales et, éventuellement, votre impôt."]
[]
["Si vous saisissez toutes vos dépenses et toutes vos recettes, la différence des deux vous donnera l'argent que votre activité vous générera réellement."]

{"sheet":"Fonc. logiciel","index":18,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Pour démarrer cliquer sur le bouton Options."]
[null,"Choisir activer ce contenu"]
[]
[null,"Pour Fermer le fichier penser à enregistrer avant."]
[]
[]
[]
[]
[null,"Pour la nouvelle Facture, cliquer sur le bouton N° de Facture"]
[null,"Le numéro changera automatiquement"]
[]
[null,"La date se mettra à jour automatiquement"]
[]
[null,"Rentrer le client et son adresse + téléphone et saisir les renseignements dans "]
[null,"l'onglet clients."]
[null,"Remplir les éléments de la facture, dans l'onglet Factures "]
[]
[null,"Remplir les éléments de l'onglet du mois pour les Achats et les ventes"]
[null,"( Classer dans un classeur les Factures des achats et dans un autres les"]
[null,"Ventes copies des Factures )"]
[]
[null,"Pour imprimer les factures ou devis il faudra cliquer sur le bouton Imprimante"]
[null,"des onglets Devis ou Factures"]
[]
[null,"Pour le changement d'exercice il faudra au 01/01/2021 Modifier le numèro à coté "]
[null," de N° de Facture en mettant 20210001"]