{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Page 1","Page 2 -3","Page 4","Page 5","Page 6","Page 7","Page 8","Page 9","Page 10","Page 11","Page 12","Feuil9","Feuil7","Budget"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Page 1","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,7,3,11],[8,4,8,6],[11,0,11,11],[49,7,49,11],[45,7,45,11],[13,0,13,4],[13,7,13,11],[5,7,5,11],[7,7,7,11],[27,7,27,11],[28,7,28,11],[29,7,29,11],[33,7,33,11],[34,7,34,11],[38,7,38,11],[39,7,39,11],[40,7,40,11],[41,7,41,11]]}
[]
[]
[]
[null,null,null,null,null,null,null,"Réservé à l'Evêché"]
["FABRIQUE D'EGLISE DE ",null,"......................................"]
[null,null,null,null,null,null,null,"Code Paroisse"]
["ARCHIPRETRE DE ",null,"………………………...………………………………………."]
[null,null,null,null,null,null,null,"Code Archiprêtré"]
["Paroisse gestionnaire :",null,"        Oui   ","        Non"]
["Utilise le logiciel paroisse :",null,"        Oui   ","        Non"]
[]
["Composition du Conseil de Fabrique - de Gestion"]
[]
["NOM - Prénom",null,null,null,null,"Date d'entrée           au conseil","Début Mandat        En cours","Fin Mandat                 En cours"]
[]
["MEMBRE DE DROIT DU BUREAU ET DU CONSEIL DE FABRIQUE"]
[]
["M.",null,null,null,"Prêtre"]
[]
["MEMBRE (S) DE DROIT DU CONSEIL DE FABRIQUE"]
[]
["M.","………………………...…………",null,null,"Maire"]
["M.","………………………...…………",null,null,"Maire de l'annexe"]
[]
["MEMBRES DU BUREAU"]
["(Leur mandat doit être renouvelé tous les ans)"]
[]
["1 M.","………………………...…………",null,null,"Président","..................................","..................................",{"$f":"IF(G28=\"..................................\",\"..................................\",G28+6)","v":".................................."}]
["2 M.","………………………...…………",null,null,"Secrétaire","..................................","..................................",{"$f":"IF(G29=\"..................................\",\"..................................\",G29+6)","v":".................................."}]
["3 M.","………………………...…………",null,null,"Trésorier","..................................","..................................",{"$f":"IF(G30=\"..................................\",\"..................................\",G30+6)","v":".................................."}]
[]
["AUTRES MEMBRES DU CONSEIL DE FABRIQUE"]
[]
["4 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G34=\"..................................\",\"..................................\",G34+6)","v":".................................."}]
["5 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G35=\"..................................\",\"..................................\",G35+6)","v":".................................."}]
[]
["Pour les paroisses de plus de 5 000 habitants"]
[]
["6 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G39=\"..................................\",\"..................................\",G39+6)","v":".................................."}]
["7 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G40=\"..................................\",\"..................................\",G40+6)","v":".................................."}]
["8 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G41=\"..................................\",\"..................................\",G41+6)","v":".................................."}]
["9 M.","………………………...…………",null,null,"Membre","..................................","..................................",{"$f":"IF(G42=\"..................................\",\"..................................\",G42+6)","v":".................................."}]
[]
[]
["Adresse du Président :",null,"………………………...…………………………………………………….…"]
[null,"Tél :","………………………...…………………………………………………….…",null,null,null,null,"Code Postal"]
[null,"E-mail :","………………………...…………………………………………………….…"]
[]
["Adresse du Trésorier :",null,"………………………...…………………………………………………….…"]
[null,"Tél : ","………………………...…………………………………………………….…",null,null,null,null,"Code Postal"]
[null,"E-mail :","………………………...…………………………………………………….…"]

{"sheet":"Page 2 -3","index":1,"n_rows":107,"n_cols":7,"rows_kept":107,"cut":false,"hidden":false,"merged":[[105,0,105,1],[6,0,7,2],[61,0,62,2]]}
[]
["NOM DE LA PAROISSE : ................................................",null,null,null,null,null,"2"]
[]
["COMPTE DE GESTION ANNEE 2018"]
["CHARGES"]
[]
["DEBIT : CHARGES",null,null,"Allouées au","CHARGES 2018",null,"Prévisions 2019"]
[null,null,null,"budget en Euros","en Euros","cts","en Euros"]
[null,6011,"Pain et vin","..................................","............................","........","............................."]
[null,6013,"Cire, bougies","..................................","............................","........","............................."]
[null,6018,"Articles divers","..................................","............................","........","............................."]
[null,6030,"Variation de stocks","..................................","............................","........","............................."]
[null,6050,"Achat de cierges pour la vente","..................................","............................","........","............................."]
[null,6061,"Combustibles","..................................","............................","........","............................."]
[null,6062,"Eau, gaz, électricité","..................................","............................","........","............................."]
[null,6063,"Fournitures d'entretien et petit équipement","..................................","............................","........","............................."]
[null,6065,"Fournitures administratives et fournitures de bureau","..................................","............................","........","............................."]
[null,6067,"Fleurs","..................................","............................","........","............................."]
[null,6068,"Autres matières et fournitures","..................................","............................","........","............................."]
[]
["60 Achats : Total",null,null,{"$f":"IF(SUM(D9:D19)<>0,SUM(D9:D19),\"\")","v":""},{"$f":"IF(SUM(E9:E19)<>0,SUM(E9:E19),\"\")","v":""},null,{"$f":"IF(SUM(G9:G19)<>0,SUM(G9:G19),\"\")","v":""}]
[]
[null,6130,"Locations","..................................","............................","........","............................."]
[null,6140,"Charges locatives","..................................","............................","........","............................."]
[null,6152,"Entretien et réparation sur biens immobiliers","..................................","............................","........","............................."]
[null,6153,"Entretien et réparation sur biens mobiliers","..................................","............................","........","............................."]
[null,6156,"Maintenance","..................................","............................","........","............................."]
[null,6161,"Multirisques","..................................","............................","........","............................."]
[null,6162,"Assurance obligatoire dommage-construction","..................................","............................","........","............................."]
[null,6168,"Autres assurances","..................................","............................","........","............................."]
[null,6181,"Documentation générale","..................................","............................","........","............................."]
[null,6183,"Documentation technique","..................................","............................","........","............................."]
["61 Services extérieurs : Total",null,null,{"$f":"IF(SUM(D23:D32)<>0,SUM(D23:D32),\"\")","v":""},{"$f":"IF(SUM(E23:E32)<>0,SUM(E23:E32),\"\")","v":""},null,{"$f":"IF(SUM(G23:G32)<>0,SUM(G23:G32),\"\")","v":""}]
[]
[null,6222,"Vacations","..................................","............................","........","............................."]
[null,6226,"Honoraires","..................................","............................","........","............................."]
[null,6227,"Frais d'actes et de contentieux","..................................","............................","........","............................."]
[null,6231,"Pourboires","..................................","............................","........","............................."]
[null,6237,"Dons","..................................","............................","........","............................."]
[null,6238,"Publications, annonces et insertions","..................................","............................","........","............................."]
[null,6251,"Déplacements","..................................","............................","........","............................."]
[null,6252,"Missions","..................................","............................","........","............................."]
[null,6253,"Réceptions","..................................","............................","........","............................."]
[null,6260,"Frais postaux et frais de télécommunications","..................................","............................","........","............................."]
[null,6270,"Services bancaires","..................................","............................","........","............................."]
[null,6281,"Cotisations, adhésions","..................................","............................","........","............................."]
[null,6284,"Formation pastorale et catéchétique","..................................","............................","........","............................."]
["62 Autres services extérieurs : Total",null,null,{"$f":"IF(SUM(D35:D47)<>0,SUM(D35:D47),\"\")","v":""},{"$f":"IF(SUM(E35:E47)<>0,SUM(E35:E47),\"\")","v":""},null,{"$f":"IF(SUM(G35:G47)<>0,SUM(G35:G47),\"\")","v":""}]
[]
[null,6310,"Taxes sur rénumérations","..................................","............................","........","............................."]
[null,6350,"Autres impôts et taxes","..................................","............................","........","............................."]
["63 Impôts et taxes : Total",null,null,{"$f":"IF(SUM(D50:D51)<>0,SUM(D50:D51),\"\")","v":""},{"$f":"IF(SUM(E50:E51)<>0,SUM(E50:E51),\"\")","v":""},null,{"$f":"IF(SUM(G50:G51)<>0,SUM(G50:G51),\"\")","v":""}]
[]
[]
[]
[]
["NOM DE LA PAROISSE : ................................................",null,null,null,null,null,"3"]
[]
["COMPTE DE GESTION ANNEE 2018"]
["CHARGES"]
[]
["DEBIT : CHARGES",null,null,"Allouées au","CHARGES 2018",null,"Prévisions 2019"]
[null,null,null,"budget en Euros","en Euros","cts","en Euros"]
[null,6411,"Salaires bruts","..................................","............................","........","............................."]
[null,6413,"Primes et gratifications","..................................","............................","........","............................."]
[null,6414,"Indemnités et avantages divers","..................................","............................","........","............................."]
[null,6451,"Cotisations à l'URSSAF","..................................","............................","........","............................."]
[null,6453,"Cotisations aux caisses de retraite","..................................","............................","........","............................."]
[null,6454,"Cotisations Pôle Emploi","..................................","............................","........","............................."]
[null,6480,"Autres charges de personnel","..................................","............................","........","............................."]
["64 Charges de personnel : Total",null,null,{"$f":"IF(SUM(D64:D70)<>0,SUM(D64:D70),\"\")","v":""},{"$f":"IF(SUM(E64:E70)<>0,SUM(E64:E70),\"\")","v":""},null,{"$f":"IF(SUM(G64:G70)<>0,SUM(G64:G70),\"\")","v":""}]
[]
[null,6541,"Kermesses","..................................","............................","........","............................."]
[null,6548,"Autres manifestations paroissiales","..................................","............................","........","............................."]
[null,6560,"Autres charges de gestion courante","..................................","............................","........","............................."]
[null,6576,"Soutiens et offrandes","..................................","............................","........","............................."]
[null,6577,"Messes de fondation","..................................","............................","........","............................."]
[null,6578,"Contributions diverses","..................................","............................","........","............................."]
["65 Autres charges de gestion courante : Total",null,null,{"$f":"IF(SUM(D73:D78)<>0,SUM(D73:D78),\"\")","v":""},{"$f":"IF(SUM(E73:E78)<>0,SUM(E73:E78),\"\")","v":""},null,{"$f":"IF(SUM(G73:G78)<>0,SUM(G73:G78),\"\")","v":""}]
[]
[null,6611,"Intérêts des emprunts","..................................","............................","........","............................."]
[null,6616,"Intérêts bancaires","..................................","............................","........","............................."]
[null,6640,"Charges sur valeurs mobilières de placement","..................................","............................","........","............................."]
["66 Charges financières : Total",null,null,{"$f":"IF(SUM(D81:D83)<>0,SUM(D81:D83),\"\")","v":""},{"$f":"IF(SUM(E81:E83)<>0,SUM(E81:E83),\"\")","v":""},null,{"$f":"IF(SUM(G81:G83)<>0,SUM(G81:G83),\"\")","v":""}]
[]
[null,6712,"Pénalités, amendes fiscales","..................................","............................","........","............................."]
[null,6713,"Libéralités","..................................","............................","........","............................."]
[null,6715,"Subventions accordées","..................................","............................","........","............................."]
[null,6718,"Autres charges exceptionnelles sur opérations de gestion","..................................","............................","........","............................."]
[null,6751,"Cessions d'immeubles","..................................","............................","........","............................."]
[null,6752,"Cessions de mobiliers","..................................","............................","........","............................."]
[null,6780,"Autres charges exceptionnelles","..................................","............................","........","............................."]
["67 Charges exceptionnelles : Total",null,null,{"$f":"IF(SUM(D86:D92)<>0,SUM(D86:D92),\"\")","v":""},{"$f":"IF(SUM(E86:E92)<>0,SUM(E86:E92),\"\")","v":""},null,{"$f":"IF(SUM(G86:G92)<>0,SUM(G86:G92),\"\")","v":""}]
[]
[null,6811,"Dotations aux amortissements sur immobilisations corporelles","..................................","............................","........","............................."]
[null,6812,"Dotations aux amortissements des charges d'exploitation à répartir","..................................","............................","........","............................."]
[null,6815,"Dotations aux provisions","..................................","............................","........","............................."]
[null,6866,"Dépréciations des valeurs mobilières de placement","..................................","............................","........","............................."]
["68 Dotations aux amortissements et provisions : Total",null,null,{"$f":"IF(SUM(D95:D98)<>0,SUM(D95:D98),\"\")","v":""},{"$f":"IF(SUM(E95:E98)<>0,SUM(E95:E98),\"\")","v":""},null,{"$f":"IF(SUM(G95:G98)<>0,SUM(G95:G98),\"\")","v":""}]
[]
[null,6950,"Impôts sur les sociétés des personnes morales non lucratives","..................................","............................","........","............................."]
["69 Impôts sur les bénéfices : Total",null,null,{"$f":"IF(SUM(D101:D101)<>0,SUM(D101:D101),\"\")","v":""},{"$f":"IF(SUM(E101:E101)<>0,SUM(E101:E101),\"\")","v":""},null,{"$f":"IF(SUM(G101:G101)<>0,SUM(G101:G101),\"\")","v":""}]
[]
[]
[null,null,"TOTAL DES CHARGES",{"$f":"IF(SUM(D21,D33,D48,D52,D71,D79,D84,D93,D99,D102)<>0,SUM(D21,D33,D48,D52,D71,D79,D84,D93,D99,D102),\"…………………….....\")","v":"……………………....."},{"$f":"IF(SUM(E21,E33,E48,E52,E71,E79,E84,E93,E99,E102)<>0,SUM(E21,E33,E48,E52,E71,E79,E84,E93,E99,E102),\"…………………….\")","v":"……………………."},"........",{"$f":"IF(SUM(G21,G33,G48,G52,G71,G79,G84,G93,G99,G102)<>0,SUM(G21,G33,G48,G52,G71,G79,G84,G93,G99,G102),\"…………………….\")","v":"……………………."}]
[1200,null,"Excédent de l'exercice : Total",{"$f":"IF(D105=\"…………………….....\",\"…………………….....\",IF('Page 4'!D49=\"…………………….....\",\"…………………….....\",IF(D105-'Page 4'!D49<0,'Page 4'!D49-'Page 2 -3'!D105,\"…………………….....\")))","v":"……………………....."},{"$f":"IF(E105=\"…………………….\",\"…………………….\",IF('Page 4'!E49=\"…………………….\",\"…………………….\",IF(E105-'Page 4'!E49<0,'Page 4'!E49-'Page 2 -3'!E105,\"…………………….\")))","v":"……………………."},"........",{"$f":"IF(G105=\"…………………….\",\"…………………….\",IF('Page 4'!G49=\"…………………….\",\"…………………….\",IF(G105-'Page 4'!G49<0,'Page 4'!G49-'Page 2 -3'!G105,\"…………………….\")))","v":"……………………."}]
[null,null,"TOTAL GENERAL",{"$f":"IF(D105<>0,IF(D106=\"…………………….....\",D105,D105+D106),\"…………………….....\")","v":"……………………....."},{"$f":"IF(E105<>0,IF(E106=\"…………………….\",E105,E105+E106),\"…………………….\")","v":"……………………."},"........",{"$f":"IF(G105<>0,IF(G106=\"…………………….\",G105,G105+G106),\"…………………….\")","v":"……………………."}]

{"sheet":"Page 4","index":2,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,4,6,5],[49,0,49,1],[6,0,7,2],[20,0,20,2],[43,0,43,2]]}
[]
["NOM DE LA PAROISSE : ................................................",null,null,null,null,null,"4"]
[]
["COMPTES DE GESTION ANNEE 2018"]
["PRODUITS"]
[]
["CREDIT : PRODUITS",null,null,"Allouées au","PRODUITS 2018",null,"Prévisions 2019"]
[null,null,null,"budget en Euros","en Euros","cts","en Euros"]
[null,7011,"Quêtes ordinaires","...................................","............................","........","............................"]
[null,7012,"Quêtes des mariages et enterrements (2/3)","...................................","............................","........","............................"]
[null,7018,"Quêtes pour le chauffage","...................................","............................","........","............................"]
[null,7019,"Quêtes particulières","...................................","............................","........","............................"]
[null,7021,"Produits des troncs","...................................","............................","........","............................"]
[null,7022,"Produits des dons manuels","...................................","............................","........","............................"]
[null,7030,"Droit de la Fabrique","...................................","............................","........","............................"]
[null,7050,"Produits des cierges","...................................","............................","........","............................"]
[null,7080,"Autres produits","...................................","............................","........","............................"]
["70 Recettes ordinaires : Total",null,null,{"$f":"IF(SUM(D9:D17)<>0,SUM(D9:D17),\"\")","v":""},{"$f":"IF(SUM(E9:E17)<>0,SUM(E9:E17),\"\")","v":""},null,{"$f":"IF(SUM(G9:G17)<>0,SUM(G9:G17),\"\")","v":""}]
[]
[null,7400,"Subventions d'exploitation","...................................","............................","........","............................"]
["74 Subventions diverses :Total",null,null,{"$f":"IF(SUM(D20:D20)<>0,SUM(D20:D20),\"\")","v":""},{"$f":"IF(SUM(E20:E20)<>0,SUM(E20:E20),\"\")","v":""},null,{"$f":"IF(SUM(G20:G20)<>0,SUM(G20:G20),\"\")","v":""}]
[]
[null,7500,"Loyers bâtiments","...................................","............................","........","............................"]
[null,7510,"Locations de terrains","...................................","............................","........","............................"]
[null,7520,"Indemnités d'occupation (Presbytère)","...................................","............................","........","............................"]
[null,7541,"Kermesses","...................................","............................","........","............................"]
[null,7548,"Autres manifestations paroissiales","...................................","............................","........","............................"]
[null,7560,"Autres produits de gestion courante","...................................","............................","........","............................"]
[null,7570,"Cotisations, adhésions","...................................","............................","........","............................"]
["75 Autres produits de gestion courante : Total",null,null,{"$f":"IF(SUM(D23:D29)<>0,SUM(D23:D29),\"\")","v":""},{"$f":"IF(SUM(E23:E29)<>0,SUM(E23:E29),\"\")","v":""},null,{"$f":"IF(SUM(G23:G29)<>0,SUM(G23:G29),\"\")","v":""}]
[]
[null,7640,"Revenus des valeurs mobilières de placement","...................................","............................","........","............................"]
[null,7680,"Autres produits financiers","...................................","............................","........","............................"]
["76 Produits financiers : Total",null,null,{"$f":"IF(SUM(D32:D33)<>0,SUM(D32:D33),\"\")","v":""},{"$f":"IF(SUM(E32:E33)<>0,SUM(E32:E33),\"\")","v":""},null,{"$f":"IF(SUM(G32:G33)<>0,SUM(G32:G33),\"\")","v":""}]
[]
[null,7713,"Libéralités perçues","...................................","............................","........","............................"]
[null,7718,"Autres produits exceptionnels sur opération de gestion","...................................","............................","........","............................"]
[null,7751,"Cessions d'immeubles","...................................","............................","........","............................"]
[null,7752,"Cessions de mobiliers","...................................","............................","........","............................"]
[null,7780,"Autres produits exceptionnels","...................................","............................","........","............................"]
["77 Produits exceptionnels : Total",null,null,{"$f":"IF(SUM(D36:D40)<>0,SUM(D36:D40),\"\")","v":""},{"$f":"IF(SUM(E36:E40)<>0,SUM(E36:E40),\"\")","v":""},null,{"$f":"IF(SUM(G36:G40)<>0,SUM(G36:G40),\"\")","v":""}]
[]
[null,7800,"Reprises sur amortissements et provisions","...................................","............................","........","............................"]
["78 Reprises sur amortissements et provisions : Total",null,null,{"$f":"IF(SUM(D43:D43)<>0,SUM(D43:D43),\"\")","v":""},{"$f":"IF(SUM(E43:E43)<>0,SUM(E43:E43),\"\")","v":""},null,{"$f":"IF(SUM(G43:G43)<>0,SUM(G43:G43),\"\")","v":""}]
[]
[null,7910,"Transfert de charges exceptionnelles","...................................","............................","........","............................"]
["79 Transfert de charges : Total",null,null,{"$f":"IF(SUM(D46:D46)<>0,SUM(D46:D46),\"\")","v":""},{"$f":"IF(SUM(E46:E46)<>0,SUM(E46:E46),\"\")","v":""},null,{"$f":"IF(SUM(G46:G46)<>0,SUM(G46:G46),\"\")","v":""}]
[]
[null,null,"TOTAL DES PRODUITS",{"$f":"IF(SUM(D47,D44,D41,D34,D30,D21,D18)<>0,SUM(D47,D44,D41,D34,D30,D21,D18),\"…………………….....\")","v":"……………………....."},{"$f":"IF(SUM(E47,E44,E41,E34,E30,E21,E18)<>0,SUM(E47,E44,E41,E34,E30,E21,E18),\"…………………….\")","v":"……………………."},"........",{"$f":"IF(SUM(G47,G44,G41,G34,G30,G21,G18)<>0,SUM(G47,G44,G41,G34,G30,G21,G18),\"………………....\")","v":"………………...."}]
[1290,null,"Déficit de l'exercice : Total",{"$f":"IF(D49=\"…………………….....\",\"…………………….....\",IF('Page 2 -3'!D105=\"…………………….....\",\"…………………….....\",IF(D49-'Page 2 -3'!D105<0,'Page 2 -3'!D105-'Page 4'!D49,\"…………………….....\")))","v":"……………………....."},{"$f":"IF(E49=\"…………………….\",\"…………………….\",IF('Page 2 -3'!E105=\"…………………….\",\"…………………….\",IF(E49-'Page 2 -3'!E105<0,'Page 2 -3'!E105-'Page 4'!E49,\"…………………….\")))","v":"……………………."},"........",{"$f":"IF(G49=\"………………....\",\"…………..….....\",IF('Page 2 -3'!G105=\"…………………….\",\"…………………….\",IF(G49-'Page 2 -3'!G105<0,'Page 2 -3'!G105-'Page 4'!G49,\"…………..….....\")))","v":"…………..…....."}]
[null,null,"TOTAL GENERAL",{"$f":"IF(D49<>0,IF(D50=\"…………………….....\",D49,D49+D50),\"…………………….....\")","v":"……………………....."},{"$f":"IF(E49<>0,IF(E50=\"…………………….\",E49,E49+E50),\"…………………….\")","v":"……………………."},"........",{"$f":"IF(G49<>0,IF(G50=\"…………..….....\",G49,G49+G50),\"…………..….....\")","v":"………………...."}]

{"sheet":"Page 5","index":3,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,0,3,8],[5,0,5,8],[7,0,7,8]]}
[]
[null,null,null,null,null,null,null,null,"5"]
[]
["COMMENTAIRES DU TRESORIER"]
[]
["DU CONSEIL DE FABRIQUE"]
[]
["SUR LA GESTION COMPTABLE"]
[]
[]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
["....................................................................................................................................................…...........................…"]
[]
[]
[]
[]
[]
[null,null,null,"A ……………………………………………, le …………………………."]

{"sheet":"Page 6","index":4,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,3,5,4],[5,7,5,8],[5,0,6,2],[5,5,6,6]]}
[]
["NOM DE LA PAROISSE : ................................................",null,null,null,null,null,null,null,"6"]
[]
["ACTIF",null,null,null,null,null,null,null,"BILAN  AU"]
[]
["ACTIF",null,null,"MONTANT BRUT",null,"Compte 28 amortissement et provision",null,"MONTANT NET "]
[null,null,null,"en Euros","Cts",null,null,"en Euros","Cts"]
["COMPTES D'IMMOBILISATIONS"]
[null,2110,"Terrains (non amortissables)","............................","........","............................","........",{"$f":"IF(SUM(D9,F9)<>0,SUM(D9,F9),\"………………\")","v":"………………"},"........"]
[null,2120,"Agencements et aménagements de terrains","............................","........","............................","........",{"$f":"IF(SUM(D10,F10)<>0,SUM(D10,F10),\"………………\")","v":"………………"},"........"]
[null,2131,"Constructions - Eglise, Chapelle","............................","........","............................","........","………………","........"]
[null,2132,"Constructions - Presbytère","............................","........","............................","........","………………","........"]
[null,2133,"Constructions - Autres ensembles immobiliers","............................","........","............................","........","………………","........"]
[null,2140,"Constructions sur sol d'autrui","............................","........","............................","........","………………","........"]
[null,2181,"Installations générales, agencements","............................","........","............................","........","………………","........"]
[null,2183,"Matériel de bureau et matériel informatique","............................","........","............................","........","………………","........"]
[null,2184,"Mobilier","............................","........","............................","........","………………","........"]
[null,2300,"Immobilisations corporelles en cours","............................","........","............................","........","………………","........"]
[null,2740,"Prêts","............................","........","............................","........","………………","........"]
[null,2750,"Dépôts et cautionnements versés","............................","........","............................","........","………………","........"]
[null,null,"TOTAL DE L'ACTIF 1",{"$f":"IF(SUM(D9:D20)<>0,SUM(D9:D20),\"\")","v":""},null,{"$f":"IF(SUM(F9:F20)<>0,SUM(F9:F20),\"\")","v":""},null,{"$f":"IF(SUM(H9:H20)<>0,SUM(H9:H20),\"\")","v":""}]
["COMPTES DE STOCKS"]
[null,3100,"Fournitures","............................","........",null,null,{"$f":"IF(SUM(D23,F23)<>0,SUM(D23,F23),\"………………\")","v":"………………"},"........"]
[null,3200,"Autres approvisionnements","............................","........",null,null,"………………","........"]
["DEBITEURS ET CREDITEURS DIVERS"]
[null,4620,"Créances sur cessions d'immobilisations","............................","........",null,null,"………………","........"]
[null,4675,"Débiteurs divers","............................","........",null,null,"………………","........"]
[null,4687,"Produits à recevoir","............................","........",null,null,"………………","........"]
["COMPTES DE REGULARISATION"]
[null,4810,"Charges à répartir sur plusieurs exercices","............................","........",null,null,"………………","........"]
[null,4860,"Charges constatées d'avance","............................","........",null,null,"………………","........"]
["COMPTES FINANCIERS"]
[null,5060,"Obligations","............................","........",null,null,"………………","........"]
[null,5070,"Bons du trésor et bons de caisse à court terme","............................","........",null,null,"………………","........"]
[null,5080,"Autres valeurs mobilières","............................","........",null,null,"………………","........"]
[null,5140,"La Banque Postale","............................","........",null,null,"………………","........"]
[null,5150,"Comptes de dépôts de fonds au trésor public","............................","........",null,null,"………………","........"]
[null,5171,"Caisse d'Epargne","............................","........",null,null,"………………","........"]
[null,5172,"Crédit Lyonnais","............................","........",null,null,"………………","........"]
[null,5173,"Crédit Mutuel","............................","........",null,null,"………………","........"]
[null,5174,"Crédit Agricole","............................","........",null,null,"………………","........"]
[null,5175,"Société Générale","............................","........",null,null,"………………","........"]
[null,5176,"Banque Populaire","............................","........",null,null,"………………","........"]
[null,5177,"BNP PARIBAS","............................","........",null,null,"………………","........"]
[null,5178,"CIC","............................","........",null,null,"………………","........"]
[null,5179,"Autres banques","............................","........",null,null,"………………","........"]
[null,5300,"Caisse","............................","........",null,null,"………………","........"]
[null,5800,"Virements internes","............................","........",null,null,"………………","........"]
[null,null,"TOTAL DE L'ACTIF 2",{"$f":"IF(SUM(D23:D48)<>0,SUM(D23:D48),\"\")","v":""},null,null,null,{"$f":"IF(SUM(H23:H48)<>0,SUM(H23:H48),\"\")","v":""}]
[null,null,"TOTAL GENERAL",{"$f":"IF(SUM(D49,D21)<>0,SUM(D49,D21),\"………….…...\")","v":"………….…..."},"……",null,null,{"$f":"IF(SUM(H49,H21)<>0,SUM(H49,H21),\"…………...….\")","v":"…………...…."},"......"]
[null,null,"(actif net 1 + actif net 2)"]

{"sheet":"Page 7","index":5,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,5,5,6],[3,5,3,6],[5,0,6,2]]}
[]
[null,null,null,null,null,null,"7"]
[]
["31 DECEMBRE 2018",null,null,null,null,"PASSIF"]
[]
["PASSIF",null,null,null,null,"MONTANT TOTAL"]
[null,null,null,"en Euros","Cts","en Euros","Cts"]
["CAPITAUX PROPRES"]
[null,1021,"Valeur du patrimoine","............................","........"]
[null,1023,"Subventions d'investissements non renouvelables","............................","........"]
[null,1026,"Legs, dons","............................","........"]
[null,1063,"Réserves contractuelles","............................","........"]
[null,1068,"Autres réserves","............................","........"]
[null,1100,"Report à nouveau - solde créditeur","............................","........"]
[null,1190,"Report à nouveau - solde débiteur","............................","........"]
[null,1200,"Résultat de l'exercice : Excédent",{"$f":"IF('Page 2 -3'!E106=\"…………………….\",\"…………………….\",'Page 2 -3'!E106)","v":"……………………."},"........"]
[null,1290,"Résultat de l'exercice : Déficit",{"$f":"IF('Page 4'!E50=\"…………………….\",\"…………………….\",'Page 4'!E50*(-1))","v":"……………………."},"........"]
[null,null,"Situation nette",null,null,{"$f":"IF(SUM(D9:D17)<>0,SUM(D9:D17),\"……………….…......\")","v":"……………….…......"},"........"]
[]
[]
["PROVISIONS"]
[null,1510,"Provisions pour risques et charges",null,null,"............................","........"]
[null,1570,"Provisions pour grosses réparations",null,null,"............................","........"]
["EMPRUNTS"]
[null,1640,"Emprunts auprès des établissements de crédit",null,null,"............................","........"]
[null,1680,"Autres emprunts",null,null,"............................","........"]
["AUTRES DETTES"]
[null,1691,"Dépôts et cautionnements reçus",null,null,"............................","........"]
[null,1692,"Autres",null,null,"............................","........"]
["FOURNISSEURS ET COMPTES RATTACHES"]
[null,4010,"Fournisseurs - Achats de biens et prestations de services",null,null,"............................","........"]
[null,4021,"Quêtes impérées",null,null,"............................","........"]
[null,4022,"1/3 Quêtes mariages - enterrements",null,null,"............................","........"]
[null,4023,"Autres quêtes à reverser",null,null,"............................","........"]
["PERSONNEL ET ORGANISMES SOCIAUX"]
[null,4210,"Personnel - rénumérations dues",null,null,"............................","........"]
[null,4310,"Sécurité sociale",null,null,"............................","........"]
[null,4370,"Autres organismes sociaux",null,null,"............................","........"]
["ETAT ET AUTRES COLLECTIVITES PUBLIQUES"]
[null,4470,"Impôts, taxes et versement assimilés",null,null,"............................","........"]
["DEBITEURS ET CREDITEURS DIVERS"]
[null,4670,"Créditeurs divers",null,null,"............................","........"]
[null,4686,"Charges à payer",null,null,"............................","........"]
["COMPTES DE REGULARISATION"]
[null,4870,"Produits constatés d'avance",null,null,"............................","........"]
[null,5900,"Provisions pour dépréciation des valeurs mobilières de placement",null,null,"............................","........"]
[]
[]
[null,null,"TOTAL GENERAL",null,null,{"$f":"IF(SUM(F18:F46)<>0,SUM(F18:F46),\"…………………………\")","v":"…………………………"},"......"]

{"sheet":"Page 8","index":6,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,0,8,4],[10,0,10,4],[12,0,12,4]]}
[]
[null,null,null,null,"8"]
[]
["DETAIL DES COMPTES FINANCIERS"]
["AU 31 DECEMBRE 2018"]
[]
[]
[]
["Les sommes inscrites à la page 6 aux comptes 514, 515 et 517 doivent correspondre aux soldes des derniers extraits bancaires de l'exercice."]
[]
["La somme inscrite au compte 5300 caisse doit correspondre au solde du compte caisse tenu par la fabrique et à l'avoir en argent liquide détenu par la fabrique en fin d'exercice.                             "]
[]
["Les extraits des comptes (et les livrets bancaires s'il y a lieu), ainsi que le compte caisse, doivent être présentés, à l'appui, par le trésorier aux membres du conseil de fabrique."]
[]
["Les références et les soldes de ces divers comptes sont à indiquer ci-dessous."]
[]
[]
["COMPTES DE TRESORERIE"]
[]
[]
["N° du compte","Nature du compte","Nom de la banque","Date de l'extrait","Solde"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Solde du compte caisse au 31.12.2018 (Espèces en caisse)"]
[]
[null,null,null,"CUMUL DES COMPTES DE TRESORERIE"]
[]
[]
["TITRES DE PLACEMENT"]
[]
["Date d'Achat","Nombre de Titres","Dénomination des Titres","Prix d'Achat Unitaire + Frais","Valeur Nette Comptable                                     (Nombre Titres x (Prix d'Achat Unitaire + Frais))"]
[]
[]
[]
[]
[]
[]
[null,null,null,"CUMUL DES TITRES DE PLACEMENT"]

{"sheet":"Page 9","index":7,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,3,15,4],[18,5,18,7],[21,3,21,4],[21,5,21,7],[19,5,19,7],[15,5,15,7],[18,3,18,4],[3,0,3,7],[4,0,4,7],[12,3,12,4],[12,5,12,7],[14,5,14,7],[14,3,14,4],[25,0,25,7],[22,5,22,7],[16,5,16,7],[17,5,17,7],[22,3,22,4],[19,3,19,4],[20,5,20,7],[20,3,20,4]]}
[]
[null,null,null,null,null,null,null,"9"]
[]
["DETAIL DES VALEURS MOBILIERES DE PLACEMENT"]
["AU 31 DECEMBRE 2018"]
[]
[]
[]
["VALEUR :","En Euros"]
[]
["Achat : Détail des achats de l'année"]
[]
["Date","Dénomination des Titres","Nombre de Titres","Prix d'Achat Unitaire + Frais",null,"Valeur Nette Comptable                                      (Compte 508)                                                                         (Nombre de Titres x (Prix d'achat unitaire + Frais))"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vente : Evaluation de la Plus ou Moins Value Réelle au moment de la cession"]
["Si le Prix de Vente Unitaire est supérieur au Prix d'Achat Unitaire, on enregistre une Plus-Value ; dans le cas contraire, on enregistre une Moins-Value."]
[]
["Date","Dénomination des Titres","Nombre de Titres","Prix d'Achat Unitaire","Prix de Vente Unitaire","Valeur Nette Comptable       (Nombre de Titres x Prix Vente Unitaire)","Plus-Value (Compte 764) (Prix de Vente Unitaire - Prix d'achat unitaire x Nombre de Titres)","Moins-Value (Compte 664) (Prix d'achat Unitaire - Prix Vente Unitaire x Nombre de Titres)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL"]

{"sheet":"Page 10","index":8,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[17,0,17,2],[3,0,3,3],[5,0,5,3],[6,0,6,3],[9,0,11,3]]}
[]
["NOM DE LA PAROISSE : ................................................",null,null,"10"]
[]
["PROCES VERBAL"]
[]
["DE LA SEANCE DU CONSEIL DE FABRIQUE"]
["STATUANT SUR LES COMPTES DE L'EXERCICE 2018"]
[]
[]
["Nous, membres du conseil de fabrique soussignés, certifions exacts les présents comptes de gestion, le bilan et les prévisions pour la nouvelle année et attestons avoir vérifié que les valeurs disponibles qui figurent au bilan sont conformes aux extraits des banques et au solde du compte caisse au 31/12/2018."]
[]
[]
[]
[]
[null,"Fait et signé par les membres présents en séance, le ................................................."]
[]
[]
["NOM - Prénom",null,null,"Signatures"]
[]
["MEMBRE DE DROIT DU BUREAU ET DU CONSEIL DE FABRIQUE"]
[]
["M.",{"$f":"'Page 1'!B18","v":0},"Prêtre","..........................................…........…"]
[]
["MEMBRE (S) DE DROIT DU CONSEIL DE FABRIQUE"]
[]
["M.",{"$f":"'Page 1'!B22","v":"………………………...…………"},"Maire","..........................................…........…"]
["M.",{"$f":"'Page 1'!B23","v":"………………………...…………"},"Maire de l'annexe","..........................................…........…"]
[]
[]
["MEMBRES DU BUREAU"]
[]
["1 M.",{"$f":"'Page 1'!B28","v":"………………………...…………"},"Président","..........................................…........…"]
["2 M.",{"$f":"'Page 1'!B29","v":"………………………...…………"},"Secrétaire","..........................................…........…"]
["3 M.",{"$f":"'Page 1'!B30","v":"………………………...…………"},"Trésorier","..........................................…........…"]
[]
["AUTRES MEMBRES DU CONSEIL DE FABRIQUE"]
[]
["4 M.",{"$f":"'Page 1'!B34","v":"………………………...…………"},"Membre","..........................................…........…"]
["5 M.",{"$f":"'Page 1'!B35","v":"………………………...…………"},"Membre","..........................................…........…"]
[]
["Pour les paroisses de plus de 5 000 habitants"]
[]
["6 M.",{"$f":"'Page 1'!B39","v":"………………………...…………"},"Membre","..........................................…........…"]
["7 M.",{"$f":"'Page 1'!B40","v":"………………………...…………"},"Membre","..........................................…........…"]
["8 M.",{"$f":"'Page 1'!B41","v":"………………………...…………"},"Membre","..........................................…........…"]
["9 M.",{"$f":"'Page 1'!B42","v":"………………………...…………"},"Membre","..........................................…........…"]

{"sheet":"Page 11","index":9,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,0,3,4],[5,3,5,4],[5,0,5,2],[28,0,28,4],[34,0,34,2],[9,3,9,4],[15,3,15,4],[21,3,21,4],[29,0,29,4],[31,0,31,4],[32,0,32,4]]}
[]
["NOM DE LA PAROISSE : ................................................",null,null,null,11]
[]
["SITUATION DU BUREAU DE LA FABRIQUE POUR L'ANNEE 2019"]
[]
["NOM - Prénom",null,null,"Signatures"]
[]
["(Leur mandat doit être renouvelé tous les ans)"]
[]
["1 M.","………………………...…………","Président","………………………...…………"]
["Adresse :","………………………...…………"]
[null,"………………………...…………"]
["Tél :","………………………...…………"]
["E-mail :","………………………...…………"]
[]
["2 M.","………………………...…………","Secrétaire","………………………...…………"]
["Adresse :","………………………...…………"]
[null,"………………………...…………"]
["Tél :","………………………...…………"]
["E-mail :","………………………...…………"]
[]
["3 M.","………………………...…………","Trésorier","………………………...…………"]
["Adresse :","………………………...…………"]
[null,"………………………...…………"]
["Tél :","………………………...…………"]
["E-mail :","………………………...…………"]
[]
[]
["NOM DES PERSONNES ENTRANT AU CONSEIL DE FABRIQUE"]
["A compléter dans le cas de nomination de nouveaux conseillers"]
[]
["Veuillez joindre deux exemplaires d'extraits du registre des délibérations pour approbation"]
["(avec les coordonnées complètes des nouveaux membres : nom ; prénom ; adresse ; téléphone …)"]
[]
["NOM - Prénom",null,null,"Date de l'élection","Mandat de conseiller à renouveler en"]
[]
["(Les membres entrants reprennent le mandat des membres sortants)"]
["1 M.","………………………...…………",null,"...........……….........…...…","...........……….........…...…"]
["Adresse :","………………………...…………"]
["En remplacement de :","………………………...…………"]
["2 M.","………………………...…………",null,"...........……….........…...…","...........……….........…...…"]
["Adresse :","………………………...…………"]
["En remplacement de :","………………………...…………"]
["3 M.","………………………...…………",null,"...........……….........…...…","...........……….........…...…"]
["Adresse :","………………………...…………"]
["En remplacement de :","………………………...…………"]
["4 M.","………………………...…………",null,"...........……….........…...…","...........……….........…...…"]
["Adresse :","………………………...…………"]
["En remplacement de :","………………………...…………"]

{"sheet":"Page 12","index":10,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[20,0,20,4],[18,0,18,4],[19,0,19,4],[3,0,3,4],[5,0,5,4],[4,0,4,4],[7,0,7,4],[21,0,21,4],[42,2,42,3],[41,2,41,3],[23,0,23,4],[39,2,39,3],[40,2,40,3]]}
[]
[null,null,null,null,"12"]
[]
["INFORMATIONS COMPLEMENTAIRES A JOINDRE "]
["AVEC L'ETAT ANNUEL DES COMPTES 2018"]
[]
[]
["Dans un souci de simplification et de gain de temps pour l'approbation des comptes, nous vous demandons de nous envoyer, en deux exemplaires, l'état annuel des comptes 2018 approuvé par le conseil de fabrique avant le                      02 avril 2018, et de joindre les documents ci-dessous :"]
[]
["#","Les Tableaux des amortissements des immobilisations"]
[]
["#","Le Tableau des emprunts"]
[]
["#","La Copie des extraits d'achats et de cessions des titres de placement"]
[]
["#","La Copie des extraits bancaires au 31 décembre de l'année N"]
[]
[]
["Les informations portées sur l'état annuel des comptes sont obligatoires. Elles font l’objet d’un traitement informatisé destiné à la gestion administrative et financière des paroisses catholiques de Moselle. Les destinataires des données sont l'évêque, les vicaires généraux, les prêtres, l'ensemble du personnel et des services du diocèse de Metz. Conformément à la loi \"informatique et libertés\" du 6 janvier 1978 modifiée, vous bénéficiez d’un droit d’accès et de rectification aux informations qui vous concernent. Si vous souhaitez exercer ce droit et obtenir communication des informations vous concernant, veuillez vous adresser au bureau des affaires paroissiales à l’évêché de Metz.\n"]
[]
[]
[]
[]
["OBSERVATIONS DE L'EVECHE"]
[]
[]
["....................................................................................................................................................….....................................…"]
[]
["....................................................................................................................................................….....................................…"]
[]
["....................................................................................................................................................….....................................…"]
[]
["....................................................................................................................................................….....................................…"]
[]
["....................................................................................................................................................….....................................…"]
[]
["....................................................................................................................................................….....................................…"]
[]
[]
[null,null,"Approbation :"]
[null,null,"de l'état annuel des comptes,"]
[null,null,"du budget prévisionnel,  "]
[null,null,"et du nouveau conseil de fabrique."]
[]
[null,null,"Vu à Metz, le ........................................................"]
[]
[]
[null,null,null,"Pour Monseigneur l'Evêque"]
[null,null,null,"Le Réviseur des Fabriques"]

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

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

{"sheet":"Budget","index":13,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[2]