{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Journal Caisse + KPI"],"read":"whole","date_system":"1900"}

{"sheet":"Journal Caisse + KPI","index":0,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,0,7]]}
["Journal de Caisse avec KPI Automatisés"]
["Date","Catégorie","Description","Mode de Paiement","Recette (€)","Dépense (€)","Solde Cumulé (€)","Commentaires",null,"KPI Comptables"]
["2025-06-01","Vente","Ticket repas","Espèces",150,0,{"$f":"E3-F3","v":null},null,null,"Total Recettes (€)",{"$f":"SUM(E3:E5)","v":null}]
["2025-06-01","Achat","Fournitures","CB",0,45,{"$f":"G3+E4-F4","v":null},null,null,"Total Dépenses (€)",{"$f":"SUM(F3:F5)","v":null}]
["2025-06-02","Dépôt banque","Remise espèces","Espèces",0,100,{"$f":"G4+E5-F5","v":null},null,null,"Solde Final (€)",{"$f":"G5","v":null}]
[{"$nulls":9},"Nombre d'opérations",{"$f":"COUNTA(A3:A5)","v":null}]
[{"$nulls":9},"Recette Moyenne (€)",{"$f":"IF(COUNTA(E3:E5)>0,SUM(E3:E5)/COUNTA(E3:E5),0)","v":null}]