====== Trésorerie - Tableau 2019 ======
Ce tableau présente mois par mois les dépenses et recettes en date de valeur pour l'année 2019.
Il est complémentaire des [[wiki:finances:comptes_2019|]].\\
Il reprend le contenu des tableaux : [[wiki:finances:depensesrecettesmois_2019|]].
^ ~~=label(solde)~~Solde précedent | 15155.89 |
{{tablelayout?rowsHeaderSource=Auto}}
^ ~~=label(tresorerie)~~Recettes ^ 01 ^ 02 ^ 03 ^ 04 ^ 05 ^ 06 ^ 07 ^ 08 ^ 09 ^ 10 ^ 11 ^ 12 ^ Total ^
| Cotisations | 210.00 | 285.00 | 155 | 85 | 165 | 65.00 | 10.00 | 0 | 212 | 91 | 385 | 50 | ~~=sum(range(1,row(),col()-1,row()))~~ |
| Dons | 12.66 | 37.80 | 42.47 | 46.14 | 3.70 | 95.38 | 36.00 | 0 | 13.95 | 8.80 | 2.67 | 603.18 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Subventions | 0.00 | 3000 | 0 | 10000 | 4931.97 | 0 | 4418.03 | 0 | 15853.60 | 0 | 0 | 4000 | ~~=sum(range(1,row(),col()-1,row()))~~ |
| Ventes Comptoir | 381.50 | 438.00 | 521.50 | 603 | 432.50 | 366.50 | 432.00 | 7.00 | 378.50 | 549 | 468.30 | 685.47 | ~~=sum(range(1,row(),col()-1,row()))~~ |
| Prestations - Produits financiers | 42.57 | 0 | 0 | 0 | 0 | 34.50 | 0 | 0 | 0 | 0 | 17 | 54.25 | ~~=sum(range(1,row(),col()-1,row()))~~ |
^ Total Recettes ^ ~~=sum(c1r1:c1r5)~~ ^ ~~=sum(c2r1:c2r5)~~ ^ ~~=sum(c3r1:c3r5)~~ ^ ~~=sum(c4r1:c4r5)~~ ^ ~~=sum(c5r1:c5r5)~~ ^ ~~=sum(c6r1:c6r5)~~ ^ ~~=sum(c7r1:c7r5)~~ ^ ~~=sum(c8r1:c8r5)~~ ^ ~~=sum(c9r1:c9r5)~~ ^ ~~=sum(c10r1:c10r5)~~ ^ ~~=sum(c11r1:c11r5)~~ ^ ~~=round(sum(c12r1:c12r5);2)~~ ^ ~~=round(sum(range(col(),1,col(),row()-1));2)~~ ^
^ Dépenses ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
| Achats Comptoir | 62.59 | 83.27 | 80.30 | 30.42 | 519.41 | 348.71 | 152.05 | 0 | 293.51 | -30.05 | 115.25 | 122.73 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Achats Fournitures | 74.00 | 63.92 | 233.32 | 22.97 | 36.03 | 155.45 | 8.30 | 0 | 152.85 | 102.45 | 1933.19 | 87.68 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Achats Matériel | 83.60 | 1153.32 | 178.20 | 0 | 357.75 | 98.32 | 1485.90 | 0 | 0 | 0 | 0 | 1462.80 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Achats Services Local | 98.99 | 281.20 | 40.37 | 257.63 | 0 | 0 | 0 | 0 | 600.44 | 0 | 157.33 | 333.85 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Assurances | 348.38 | 0 | 0 | 0 | 0 | 54.38 | 0 | 0 | 0 | 0 | 0 | 0 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Communication | 37.79 | 37.79 | 37.79 | 37.79 | 50.11 | 37.79 | 37.79 | 72.47 | 109.79 | 37.79 | 37.79 | 37.79 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Emploi | 2839.11 | 2435.16 | 2306.15 | 2797.23 | 2146.17 | 2227.91 | 2819.49 | 2334.91 | 2281.41 | 2817.33 | 2252.51 | 2143.36 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
| Frais Bancaires - impots | 18.92 | 19.13 | 20.18 | 18.92 | 19.34 | 19.76 | 19.34 | 19.76 | 19.13 | 19.97 | ~~=round(19.34+3267.78;2)~~ | 20.43 | ~~=round(sum(range(1,row(),col()-1,row()));2)~~ |
^ Total Dépenses ^ ~~=sum(c1r8:c1r15)~~ ^ ~~=round(sum(c2r8:c2r15);2)~~ ^ ~~=round(sum(c3r8:c3r15);2)~~ ^ ~~=round(sum(c4r8:c4r15);2)~~ ^ ~~=round(sum(c5r8:c5r15);2)~~ ^ ~~=round(sum(c6r8:c6r15);2)~~ ^ ~~=sum(c7r8:c7r15)~~ ^ ~~=sum(c8r8:c8r15)~~ ^ ~~=sum(c9r8:c9r15)~~ ^ ~~=sum(c10r8:c10r15)~~ ^ ~~=sum(c11r8:c11r15)~~ ^ ~~=round(sum(c12r8:c12r15);2)~~ ^ ~~=round(sum(c13r8:c13r15);2)~~ ^
| Balance Mensuelle | ~~=c1r6-c1r16~~ | ~~=round(c2r6-c2r16;2)~~ | ~~=round(c3r6-c3r16;2)~~ | ~~=round(c4r6-c4r16;2)~~ | ~~=round(c5r6-c5r16;2)~~ | ~~=round(c6r6-c6r16;2)~~ | ~~=round(c7r6-c7r16;2)~~ | ~~=c8r6-c8r16~~ | ~~=round(c9r6-c9r16;2)~~ | ~~=round(c10r6-c10r16;2)~~ | ~~=round(c11r6-c11r16;2)~~ | ~~=round(c12r6-c12r16;2)~~ | ~~=round(cell(col(),6)-cell(col(),16);2)~~ |
| Solde fin de mois | ~~=solde.r0c1+cell(col(),17)~~ | ~~=round(c1r18+c2r17;2)~~ | ~~=round(c2r18+c3r17;2)~~ | ~~=round(c3r18+c4r17;2)~~ | ~~=round(c4r18+c5r17;2)~~ | ~~=round(c5r18+c6r17;2)~~ | ~~=round(c6r18+c7r17;2)~~ | ~~=round(c7r18+c8r17;2)~~ | ~~=round(c8r18+c9r17;2)~~ | ~~=round(c9r18+c10r17;2)~~ | ~~=round(c10r18+c11r17;2)~~ | ~~=round(c11r18+c12r17;2)~~ ^ ^
~~SNIPPET_O1777475282~~wiki:snippets:retourner_aux_sommaires~~
/* Bloc à utiliser au niveau R+3 */
====== Retourner aux sommaires ======
/* lien vers les sommaires des catégories supérieure */
[[:]] - [[..:]] - [[.:]]
~~SNIPPET_C~~wiki:snippets:retourner_aux_sommaires~~