{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ECRITURES","COMPTE_RESULTAT_LIE"],"read":"whole","date_system":"1900"}

{"sheet":"ECRITURES","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
["Date","Réf.","Libellé","Compte","Montant (€)","Type","Centre"]
["01/01/2024","V001","Vente Produits finis",700,50000,"Produit","Production"]
["01/01/2024","V002","Prestations services",704,8000,"Produit","Commercial"]
["03/01/2024","A001","Achats marchandises",600,15000,"Charge","Production"]
["04/01/2024","L001","Loyer siège",613,6000,"Charge","Administration"]
["05/01/2024","S001","Salaires ouvriers",620,20000,"Charge","Production"]
["06/01/2024","S002","Cotisations ONSS",621,5000,"Charge","Production"]
["07/01/2024","AM01","Amortissement machines",630,4000,"Charge","Production"]
["08/01/2024","INT01","Intérêts emprunt",650,1200,"Charge","Administration"]
["09/01/2024","INT02","Intérêts créditeurs",750,300,"Produit","Administration"]

{"sheet":"COMPTE_RESULTAT_LIE","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,0,0,5]]}
["COMPTE DE RÉSULTAT LIÉ AUX ÉCRITURES - STRUCTURE PCMN BELGE"]
["Centre","N° Compte","Rubrique","Montant (€)","Type","Commentaires"]
["Production",700,"Vente produits finis",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,700,ECRITURES!G:G,\"Production\")","v":null},"Produit","PCMN Classe 7"]
["Commercial",704,"Prestations",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,704,ECRITURES!G:G,\"Commercial\")","v":null},"Produit","PCMN Classe 7"]
["Production",600,"Achats",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,600,ECRITURES!G:G,\"Production\")","v":null},"Charge","PCMN Classe 6"]
["Administration",613,"Loyer",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,613,ECRITURES!G:G,\"Administration\")","v":null},"Charge","PCMN Classe 6"]
["Production",620,"Salaires",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,620,ECRITURES!G:G,\"Production\")","v":null},"Charge","PCMN Classe 6"]
["Production",621,"ONSS",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,621,ECRITURES!G:G,\"Production\")","v":null},"Charge","PCMN Classe 6"]
["Production",630,"Amortissements",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,630,ECRITURES!G:G,\"Production\")","v":null},"Charge","PCMN Classe 6"]
["Administration",650,"Intérêts bancaires",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,650,ECRITURES!G:G,\"Administration\")","v":null},"Charge","PCMN Classe 6"]
["Administration",750,"Intérêts créditeurs",{"$f":"SUMIFS(ECRITURES!E:E,ECRITURES!D:D,750,ECRITURES!G:G,\"Administration\")","v":null},"Produit","PCMN Classe 7"]