{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["cpte Resultats 2023","cpte Resultats 2024","PREVISIONNEL","BILAN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"cpte Resultats 2023","index":0,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[63,2,64,2],[60,1,61,4],[58,1,58,3],[1,1,2,4],[6,1,6,2],[6,3,6,4],[55,1,55,2],[56,1,56,2],[56,3,57,4],[55,3,55,4],[51,1,51,4],[52,1,54,4],[3,2,3,4],[4,1,4,4],[5,1,5,4]]}
[]
[null,"2023 - Compte de résultats de l'Association "]
[]
[null,"Nom de l'Association :"]
[null,"                                                                    Exercice                                                                                                                                            "]
[null,"Date de début :                /       / 202                          Date de fin :            /        / 202"]
[null,"Charges directes ",null,"Ressources directes "]
[null,"Catégories","Montants","Catégories","Montants"]
[null,"60- Achats ",{"$f":"SUM(C10:C14)","v":0},"70- Ventes de produits finis, de marchandises, de prestations de services ",{"$f":"SUM(E10:E14)","v":0}]
[null,"Achats matières et fournitures ",null,"Ventes de produits, de marchandises"]
[null,null,null,"Billetterie manifestation"]
[null,"Buvette/club House",null,"Produits activités ( buvette / tombola)"]
[null,"Autres fournitures ",null,"Ventes équipements / matériel"]
[null,"Prestations de service",null,"Prestation de service "]
[null,"61- Services extérieurs ",{"$f":"SUM(C16:C20)","v":0},"74- Subventions d'exploitation ",{"$f":"SUM(E16:E31)-E23","v":0}]
[null,"Loyer",null,"Etat  (A.N.S et autres)"]
[null,"Locations (bus, autre)",null,"Région"]
[null,"Entretien et réparation",null,"Département"]
[null,"Assurance",null,"Intercommunalité (MEL)"]
[null,"Frais de documentation ",null,"Agences  de services et de paiement (emplois aidés)"]
[null,"62- Autres services extérieurs ",{"$f":"SUM(C22:C25)","v":0}]
[null,"Rémunérations intermédiaires et honoraires ",null,"Commune"]
[null,"Publicité, publication, communication",null,"dont subventions OMS"]
[null,"Déplacements, missions",null,"Organismes sociaux"]
[null,"Services bancaires, autres (frais postaux, télécommunication)",null,"Fonds européens"]
[null,null,null,"Autres établissements publics"]
[null,null,null,"Aides privées"]
[null,"63- Impôts et taxes ",{"$f":"SUM(C29:C31)","v":0}]
[null,"Impôts et taxes sur rémunération, "]
[null,"Autres impôts et taxes"]
[]
[null,"64- Charges de personnel ",{"$f":"SUM(C33:C35)","v":0},"75- Autres produits de gestion courante ",{"$f":"SUM(E33:E40)","v":0}]
[null,"Rémunération des personnels",null,"Cotisations "]
[null,"Charges sociales",null,"Dons manuels, legs,…"]
[null,"Autres charges de personnel",null,"Aides non imposables / personnes handicapées "]
[]
[null,"65- Autres charges de gestion courante ",{"$f":"SUM(C38:C40)","v":0}]
[]
[]
[]
[null,"66- Charges financières",{"$f":"SUM(C42:C43)","v":0},"76- Produits financiers ",{"$f":"SUM(E42:E44)","v":0}]
[null,"Intérêts des emprunts et dettes /Agios",null,"Produits financiers"]
[null,"Autres  "]
[]
[null,"67- Charges exceptionnelles ",{"$f":"SUM(C46:C47)","v":0},"77- Produits exceptionnels \t",{"$f":"SUM(E46:E47)","v":0}]
[]
[]
[null,"68- Dotations aux amortissements"]
[]
[null,"Total des charges ",{"$f":"SUM(C48,C45,C41,C37,C32,C28,C21,C15,C9)","v":0},"Total des produits",{"$f":"+E45+E41+E32+E15+E9","v":0}]
[]
[null,"Situation financière de l'association"]
[null,"Pour la période    du        /        /   202                 au        /        /   202   "]
[]
[]
[null,"Recettes                                                                                  ",null,"Dépenses :"]
[null,{"$f":"E50","v":0},null,{"$f":"C50","v":0}]
[]
[null,"Le résultat est :"]
[null,null,{"$f":"IF(B57>D57,B57-D57,D57-B57)","v":0}]
[null,"DOCUMENT  SERVANT POUR LE CONTROLE – A REMPLIR OBLIGATOIREMENT ET CORRECTEMENT"]
[]
[]
[null,"SIGNATURE DU (DE LA) PRESIDENT(E)","Certifié\nConforme","SIGNATURE DU (DE LA) TRESORIER(E)"]
[]
[]
[null,null,null,null,"Page 8"]

{"sheet":"cpte Resultats 2024","index":1,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[58,1,58,3],[60,1,61,4],[51,1,51,4],[52,1,54,4],[55,1,55,2],[55,3,55,4],[56,1,56,2],[56,3,57,4],[1,1,2,4],[3,2,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,2],[6,3,6,4]]}
[]
[null,"2024 - 1er Semestre - Compte de résultats de l'association "]
[]
[null,"Nom de l'association :"]
[null,"                                                                    Exercice                                                                                                                                            "]
[null,"Date de début :               /       / 202                          Date de fin :           /       / 202"]
[null,"Charges directes ",null,"Ressources directes "]
[null,"Catégories","Montants","Catégories","Montants"]
[null,"60- Achats ",{"$f":"SUM(C10:C14)","v":0},"70- Ventes de produits finis, de marchandises, de prestations de services ",{"$f":"SUM(E10:E14)","v":0}]
[null,"Achats matières et fournitures ",null,"Ventes de produits, de marchandises"]
[null,null,null,"Billetterie manifestation"]
[null,"Buvette/club House",null,"Produits activités ( buvette / tombola)"]
[null,"Autres fournitures ",null,"Ventes équipements / matériel"]
[null,"Prestations de service",null,"Prestation de service "]
[null,"61- Services extérieurs ",{"$f":"SUM(C16:C20)","v":0},"74- Subventions d'exploitation ",{"$f":"SUM(E16:E31)-E23","v":0}]
[null,"Loyer",null,"Etat  (A.N.S et autres)"]
[null,"Locations (bus, autre)",null,"Région"]
[null,"Entretien et réparation",null,"Département"]
[null,"Assurance",null,"Intercommunalité (MEL)"]
[null,"Frais de documentation ",null,"Agences  de services et de paiement (emplois aidés)"]
[null,"62- Autres services extérieurs ",{"$f":"SUM(C22:C27)","v":0}]
[null,"Rémunérations intermédiaires et honoraires ",null,"Commune"]
[null,"Publicité, publication, communication",null,"dont subventions OMS"]
[null,"Déplacements, missions",null,"Organismes sociaux"]
[null,"Services bancaires, autres (frais postaux, télécommunication)",null,"Fonds européens"]
[null,null,null,"Autres établissements publics"]
[]
[null,"63- Impôts et taxes ",{"$f":"SUM(C29:C31)","v":0},"Aides privées"]
[null,"Impôts et taxes sur rémunération, "]
[null,"Autres impôts et taxes"]
[]
[null,"64- Charges de personnel ",{"$f":"SUM(C33:C36)","v":0},"75- Autres produits de gestion courante ",{"$f":"SUM(E33:E40)","v":0}]
[null,"Rémunération des personnels",null,"Cotisations "]
[null,"Charges sociales",null,"Dons manuels, legs,…"]
[null,"Autres charges de personnel",null,"Aides non imposables / personnes handicapées "]
[]
[null,"65- Autres charges de gestion courante ",{"$f":"SUM(C38:C40)","v":0}]
[]
[]
[]
[null,"66- Charges financières",{"$f":"SUM(C42:C45)","v":0},"76- Produits financiers ",{"$f":"SUM(E42:E45)","v":0}]
[null,"Intérêts des emprunts et dettes /Agios",null,"Produits financiers"]
[null,"Autres  "]
[]
[]
[null,"67- Charges exceptionnelles ",{"$f":"SUM(C47)","v":0},"77- Produits exceptionnels \t",{"$f":"E47","v":0}]
[]
[null,"68- Dotations aux amortissements"]
[]
[null,"Total des charges ",{"$f":"SUM(C48,C46,C41,C37,C32,C28,C21,C15,C9)","v":0},"Total des produits",{"$f":"+E46+E41+E32+E15+E9-E23","v":0}]
[]
[null,"Situation financière de l'association"]
[null,"Pour la période    du        /        /   202                 au        /        /   202   "]
[]
[]
[null,"Recettes                                                                                  ",null,"Dépenses :"]
[null,{"$f":"E50","v":0},null,{"$f":"C50","v":0}]
[]
[null,"Le résultat est :"]
[null,null,{"$f":"IF(B57>D57,B57-D57,D57-B57)","v":0}]
[null,"DOCUMENT  SERVANT POUR LE CONTROLE – A REMPLIR OBLIGATOIREMENT ET CORRECTEMENT"]
[]
[]
[null,"SIGNATURE DU (DE LA) PRESIDENT(E)",null,"SIGNATURE DU (DE LA) TRESORIER(E)"]
[null,"Précédée de la mention «Certifié conforme »","Certifié\nconforme"]
[]
[null,null,null,null,"Page 8"]

{"sheet":"PREVISIONNEL","index":2,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[54,1,57,1],[54,3,57,3],[53,2,57,2],[1,1,2,4],[6,1,6,2],[6,3,6,4],[3,2,3,4],[4,1,4,4],[5,1,5,4]]}
[]
[null,"2025 - Compte Prévisionnel de l'association "]
[]
[null,{"$f":"'cpte Resultats 2023'!B4","v":"Nom de l'Association :"}]
[null,"                                                                    Exercice                                                                                                                                            "]
[null,"Date de début :               /       / 202                          Date de fin :           /       / 202"]
[null,"Charges directes ",null,"Ressources directes "]
[null,"Catégories","Montants","Catégories","Montants"]
[null,"60- Achats ",{"$f":"+C10+C12+C13+C15","v":0},"70- Ventes de produits finis, de marchandises, de prestations de services ",{"$f":"+E10+E11+E12+E13","v":0}]
[null,"Achats matières et fournitures ",null,"Publicité / Sponsor"]
[null,null,null,"Billetterie manifestation"]
[null,"Buvette/club House",null,"Produits activités ( buvette / tombola)"]
[null,"Autres fournitures ",null,"Ventes équipements / matériel"]
[]
[null,"Prestations de service",null,"Prestation de service "]
[null,"61- Services extérieurs ",{"$f":"SUM(C17:C24)","v":0},"74- Subventions d'exploitation ",{"$f":"+E17+E18+E20+E22+E24+E26+E28+E30+E32+E34","v":0}]
[null,"Loyer",null,"Etat  (A.N.S et autres)"]
[null,"Locations (bus, autre)",null,"Région"]
[null,"Entretien et réparation"]
[null,null,null,"Département"]
[null,"Assurance"]
[null,null,null,"Intercommunalité (MEL)"]
[null,"Frais de documentation "]
[null,null,null,"Agences  de services et de paiement (emplois aidés)"]
[null,"62- Autres services extérieurs ",{"$f":"SUM(C26:C29)","v":0}]
[null,"Rémunérations intermédiaires et honoraires ",null,"Commune"]
[null,"Publicité, publication, communication",null,"dont subventions OMS"]
[null,"Déplacements, missions",null,"Organismes sociaux"]
[null,"Services bancaires, frais postaux, télécommunication"]
[null,null,null,"Fonds européens"]
[]
[null,null,null,"Autres établissements publics"]
[null,"63- Impôts et taxes ",{"$f":"SUM(C34:C36)","v":0}]
[null,"Impôts et taxes sur rémunération, ",null,"Aides privées"]
[null,"Autres impôts et taxes"]
[]
[null,"64- Charges de personnel ",{"$f":"SUM(C38:C41)","v":0},"75- Autres produits de gestion courante ",{"$f":"SUM(E38:E40)","v":0}]
[null,"Rémunération des personnels",null,"Cotisations "]
[null,"Charges sociales",null,"Dons manuels, legs,…"]
[null,"Vacations entraîneurs non salariés",null,"Aides non imposables / personnes handicapées "]
[null,"Autres charges de personnel"]
[]
[null,"65- Autres charges de gestion courante ",{"$f":"SUM(C44:C48)","v":0},"76- Produits financiers ",{"$f":"SUM(E44:E50)","v":0}]
[null,"Affiliation fédérale",null,"Produits financiers"]
[null,"Affiliation autre (OMS/Maison Association)"]
[null,"Licences"]
[null,"Droits d'engagement"]
[null,"Aides non imposables / personnes handicapées"]
[null,"66- Charges financières",{"$f":"SUM(C50)","v":0}]
[null,"Intérêts des emprunts et dettes /Agios"]
[null,"67- Charges exceptionnelles ",{"$f":"SUM(C52)","v":0},"77- Produits exceptionnels \t",{"$f":"E52","v":0}]
[]
[null,"Total des charges ",{"$f":"SUM(C51,C49,C43,C37,C33,C25,C16,C9)","v":0},"Total des produits",{"$f":"SUM(E9,E16,E37,E43,E51)","v":0}]
[null,"SIGNATURE DU (DE LA) PRESIDENT(E)","Certifié\nconforme","SIGNATURE DU (DE LA) TRESORIER(E)"]
[]
[]
[]
[]
[]
[null,"v  Le compte prévisionnel doit être équilibré",null,null,"Page 9"]

{"sheet":"BILAN","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,1,3,4],[0,1,0,4],[1,2,1,4],[20,1,24,1],[20,2,20,3],[21,2,21,3],[20,4,21,4],[22,2,22,3],[23,2,23,3],[24,2,24,3],[16,1,16,3],[16,4,17,4],[17,1,17,3],[18,1,18,3],[19,1,19,3],[18,4,19,4],[30,3,30,4],[5,1,7,2],[8,1,8,3],[9,1,9,3],[14,1,14,3],[14,4,15,4],[15,1,15,3],[28,1,28,2],[8,4,13,4],[29,3,29,4],[25,1,25,3],[26,1,26,3],[25,4,26,4]]}
[null,"BUDGET DE L’ASSOCIATION (BILAN)"]
[null,"nom Association"]
[]
[null,"Les informations ci-dessous doivent être obligatoirement renseignées par l’association :"]
[]
[null,"L’exercice comptable, période sur laquelle sont établis les comptes, dure douze mois",null,"Date de début de l’exercice : ","Date de fin de l’exercice :"]
[]
[null,null,null,"  /  /202","  /  /202"]
[null,"Montant des disponibilités à la fin de l’exercice :",null,null,2]
[null,"Les disponibilités concernent à la fois la trésorerie à la fin de l’exercice mais aussi le cas échéant les fonds placés sur des comptes d’épargne et autres types de placements réalisés au nom de l’association"]
[null,null,"compte 1 :"]
[null,null,"compte 2 :"]
[null,null,"livret :"]
[null,null,"caisse :"]
[null,"Montant des créances à la fin de l’exercice :",null,null,4]
[null,"Le montant des créances s’établit en additionnant les factures établies par l’association pour des prestations se rattachant à l’exercice mais non recouvertes, les cotisations et les subventions rattachées à l’exercice que l’association va recevoir de façon certaine"]
[null,"Montant des dettes à la fin de l’exercice : ",null,null,9]
[null,"Le montant des dettes s’établit en additionnant les emprunts (bancaires ou autres) non encore remboursés, les factures occasionnées par l’activité de l’association lors de l’exercice non encore acquittées ou encaissées, les dettes sociales et fiscales"]
[null,"Total des produits :."]
[null,"Ensemble des recettes de l’association rattachées à l’exercice"]
[null,"Dont  ","Montant des ressources propres : "]
[null,null,"Cotisations, chiffres d’affaire, adhésions, produits financiers…"]
[null,null,"Montant des dons, subventions privées, mécénat, parrainage : "]
[null,null,"Montant des subventions publiques :"]
[null,null,"Dont montant subvention Ville :"]
[null,"Total des charges : "]
[null,"(Ensemble des dépenses de l’association rattachées à l’exercice)"]
[]
[null,"Certifié conforme, "]
[null,"le",{"$f":"TODAY()","v":"2024-07-10"},"Signature du (de la) Président(e) ",null,"   "]
[]
[]
[]
[]
[null,null,null,null,"PAGE 10"]