== LOANS == {"rowid":"1","label":"Prêt Crédit Agricole 10003101334 — reprise au 01\/01\/2026","capital":"15987.24000000","datestart":"2026-01-05","dateend":"2029-07-05","rate":"4.59","accountancy_account_capital":"164","accountancy_account_insurance":"616","accountancy_account_interest":"6611","paid":"2"} == PAYMENT_LOAN == {"rowid":"1","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-01-06 00:00:00","amount_capital":"342.77000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"278","fk_typepayment":"3","num_payment":""} {"rowid":"2","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-02-05 00:00:00","amount_capital":"344.08000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"279","fk_typepayment":"3","num_payment":""} {"rowid":"3","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-03-05 00:00:00","amount_capital":"345.40000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"280","fk_typepayment":"3","num_payment":""} {"rowid":"4","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-04-08 00:00:00","amount_capital":"346.72000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"281","fk_typepayment":"3","num_payment":""} {"rowid":"5","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-05-05 00:00:00","amount_capital":"348.04000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"282","fk_typepayment":"3","num_payment":""} {"rowid":"6","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-06-05 00:00:00","amount_capital":"349.37000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"283","fk_typepayment":"3","num_payment":""} {"rowid":"7","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-07-07 00:00:00","amount_capital":"350.71000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"284","fk_typepayment":"3","num_payment":""} {"rowid":"8","fk_loan":"1","datec":"2026-08-09 21:31:37","datep":"2026-08-05 00:00:00","amount_capital":"352.05000000","amount_insurance":"0.00000000","amount_interest":"0.00000000","fk_bank":"285","fk_typepayment":"3","num_payment":""} == PAYMENT_VARIOUS (2026) == {"rowid":"1","datep":"2026-01-06","datev":"2026-01-06","sens":"0","amount":"61.15000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"286"} {"rowid":"9","datep":"2026-01-06","datev":"2026-01-06","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"294"} {"rowid":"28","datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"321"} {"rowid":"27","datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"320"} {"rowid":"26","datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"80.46000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"319"} {"rowid":"29","datep":"2026-01-15","datev":"2026-01-15","sens":"0","amount":"20.90000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"322"} {"rowid":"30","datep":"2026-01-23","datev":"2026-01-23","sens":"0","amount":"60.00000000","label":"Crédit-bail — acte de gestion à identifier","accountancy_code":"471","subledger_account":"","fk_bank":"323"} {"rowid":"17","datep":"2026-01-28","datev":"2026-01-28","sens":"0","amount":"7014.00000000","label":"TVA CA3 de décembre 2025 — solde la dette d'ouverture","accountancy_code":"44551","subledger_account":"","fk_bank":"309"} {"rowid":"10","datep":"2026-02-04","datev":"2026-02-04","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"295"} {"rowid":"2","datep":"2026-02-05","datev":"2026-02-05","sens":"0","amount":"59.84000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"287"} {"rowid":"33","datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"326"} {"rowid":"32","datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"325"} {"rowid":"31","datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"80.46000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"324"} {"rowid":"35","datep":"2026-02-17","datev":"2026-02-17","sens":"0","amount":"20.90000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"328"} {"rowid":"34","datep":"2026-02-17","datev":"2026-02-17","sens":"1","amount":"54.00000000","label":"Crédit-bail — acte de gestion à identifier","accountancy_code":"471","subledger_account":"","fk_bank":"327"} {"rowid":"18","datep":"2026-02-25","datev":"2026-02-25","sens":"1","amount":"3115.00000000","label":"Remboursement DGFiP — crédit de TVA","accountancy_code":"44567","subledger_account":"","fk_bank":"310"} {"rowid":"11","datep":"2026-03-04","datev":"2026-03-04","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"296"} {"rowid":"3","datep":"2026-03-05","datev":"2026-03-05","sens":"0","amount":"58.52000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"288"} {"rowid":"38","datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"331"} {"rowid":"37","datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"330"} {"rowid":"36","datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"80.46000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"329"} {"rowid":"39","datep":"2026-03-17","datev":"2026-03-17","sens":"0","amount":"20.90000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"332"} {"rowid":"19","datep":"2026-03-25","datev":"2026-03-25","sens":"0","amount":"2367.00000000","label":"TVA CA3 de mars 2026","accountancy_code":"44551","subledger_account":"","fk_bank":"311"} {"rowid":"12","datep":"2026-04-03","datev":"2026-04-03","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"297"} {"rowid":"42","datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"335"} {"rowid":"41","datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"334"} {"rowid":"40","datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"80.46000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"333"} {"rowid":"4","datep":"2026-04-08","datev":"2026-04-08","sens":"0","amount":"57.20000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"289"} {"rowid":"43","datep":"2026-04-15","datev":"2026-04-15","sens":"0","amount":"22.00000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"336"} {"rowid":"20","datep":"2026-04-30","datev":"2026-04-30","sens":"1","amount":"4808.00000000","label":"Remboursement DGFiP — crédit de TVA","accountancy_code":"44567","subledger_account":"","fk_bank":"312"} {"rowid":"5","datep":"2026-05-05","datev":"2026-05-05","sens":"0","amount":"55.88000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"290"} {"rowid":"13","datep":"2026-05-06","datev":"2026-05-06","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"298"} {"rowid":"44","datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"80.46000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"337"} {"rowid":"45","datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"338"} {"rowid":"46","datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"339"} {"rowid":"21","datep":"2026-05-15","datev":"2026-05-15","sens":"0","amount":"4385.00000000","label":"Impôt sur les sociétés — solde la dette d'ouverture","accountancy_code":"444","subledger_account":"","fk_bank":"313"} {"rowid":"47","datep":"2026-05-16","datev":"2026-05-16","sens":"0","amount":"22.00000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"340"} {"rowid":"48","datep":"2026-05-18","datev":"2026-05-18","sens":"1","amount":"118.80000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"341"} {"rowid":"68","datep":"2026-05-19","datev":"2026-05-19","sens":"0","amount":"550.00000000","label":"Virement notaire du 19\/05 — part non justifiée","accountancy_code":"471","subledger_account":"","fk_bank":"370"} {"rowid":"22","datep":"2026-05-28","datev":"2026-05-28","sens":"0","amount":"1272.00000000","label":"TVA CA3 de mai 2026","accountancy_code":"44551","subledger_account":"","fk_bank":"314"} {"rowid":"49","datep":"2026-05-29","datev":"2026-05-29","sens":"1","amount":"500.00000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"342"} {"rowid":"51","datep":"2026-05-30","datev":"2026-05-30","sens":"1","amount":"2190.99000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"344"} {"rowid":"50","datep":"2026-05-30","datev":"2026-05-30","sens":"0","amount":"500.00000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"343"} {"rowid":"14","datep":"2026-06-03","datev":"2026-06-03","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"299"} {"rowid":"6","datep":"2026-06-05","datev":"2026-06-05","sens":"0","amount":"54.55000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"291"} {"rowid":"52","datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"80.45000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"345"} {"rowid":"53","datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"346"} {"rowid":"54","datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"347"} {"rowid":"55","datep":"2026-06-16","datev":"2026-06-16","sens":"0","amount":"22.00000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"348"} {"rowid":"23","datep":"2026-06-17","datev":"2026-06-17","sens":"0","amount":"1096.00000000","label":"Acompte d'impôt sur les sociétés 2026","accountancy_code":"444","subledger_account":"","fk_bank":"315"} {"rowid":"56","datep":"2026-06-23","datev":"2026-06-23","sens":"1","amount":"590.40000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"349"} {"rowid":"57","datep":"2026-06-23","datev":"2026-06-23","sens":"1","amount":"10000.00000000","label":"Compte courant d'associé","accountancy_code":"455","subledger_account":"","fk_bank":"350"} {"rowid":"24","datep":"2026-06-24","datev":"2026-06-24","sens":"0","amount":"3.00000000","label":"TVA CA3 de juin 2026","accountancy_code":"44551","subledger_account":"","fk_bank":"316"} {"rowid":"15","datep":"2026-07-03","datev":"2026-07-03","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"300"} {"rowid":"60","datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"57.53000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"353"} {"rowid":"61","datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"354"} {"rowid":"7","datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"53.21000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"292"} {"rowid":"59","datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"352"} {"rowid":"58","datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"106.62000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"351"} {"rowid":"62","datep":"2026-07-16","datev":"2026-07-16","sens":"0","amount":"22.00000000","label":"Frais bancaires","accountancy_code":"627","subledger_account":"","fk_bank":"355"} {"rowid":"25","datep":"2026-07-30","datev":"2026-07-30","sens":"1","amount":"2194.00000000","label":"Remboursement DGFiP — crédit de TVA","accountancy_code":"44567","subledger_account":"","fk_bank":"317"} {"rowid":"63","datep":"2026-07-31","datev":"2026-07-31","sens":"0","amount":"1627.13000000","label":"Salaire net","accountancy_code":"641","subledger_account":"","fk_bank":"356"} {"rowid":"8","datep":"2026-08-05","datev":"2026-08-05","sens":"0","amount":"51.87000000","label":"Remboursement de prêt 10003101334 — intérêts","accountancy_code":"6611","subledger_account":"","fk_bank":"293"} {"rowid":"16","datep":"2026-08-05","datev":"2026-08-05","sens":"0","amount":"18.30000000","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","accountancy_code":"616","subledger_account":"","fk_bank":"301"} {"rowid":"64","datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"130.01000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"357"} {"rowid":"65","datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"78.89000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"358"} {"rowid":"66","datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"57.53000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"359"} {"rowid":"67","datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"11.38000000","label":"Assurance","accountancy_code":"616","subledger_account":"","fk_bank":"360"} == FACTURE_FOURN LIXXBAIL == {"rowid":"436","ref":"SI2601-0200","ref_supplier":"428164BP0-202601","datef":"2026-01-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"437","ref":"SI2602-0201","ref_supplier":"428164BP0-202602","datef":"2026-02-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"438","ref":"SI2603-0202","ref_supplier":"428164BP0-202603","datef":"2026-03-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"439","ref":"SI2604-0203","ref_supplier":"428164BP0-202604","datef":"2026-04-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"440","ref":"SI2605-0204","ref_supplier":"428164BP0-202605","datef":"2026-05-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"441","ref":"SI2606-0205","ref_supplier":"428164BP0-202606","datef":"2026-06-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"442","ref":"SI2607-0206","ref_supplier":"428164BP0-202607","datef":"2026-07-19","total_ht":"1476.20000000","total_tva":"291.94000000","total_ttc":"1768.14000000","paye":"1","fk_statut":"2","nom":"LIXXBAIL (Crédit Agricole Leasing)"} == CONTRAT == {"rowid":"2","ref":"CT2412-0001","statut":"1","nom":"LIXXBAIL (Crédit Agricole Leasing)"} {"rowid":"1","fk_contrat":"2","statut":"4","label":"","description":"Loyer de crédit-bail mobilier — presse plieuse et cisaille JOUANEL\nContrat 428164BP0\/1 : 60 mensualités de 1 459,72 HT, du 19\/12\/2024 au 18\/12\/2029\nCompte 6122 — Crédit bail mobilier","subprice":"1459.72000000","tva_tx":"20.0000","total_ht":"1459.72000000","total_tva":"291.94000000","total_ttc":"1751.66000000"} {"rowid":"2","fk_contrat":"2","statut":"4","label":"","description":"Assurance DPTIA PRO incluse — 16,48 par mois, exonérée de TVA (art. 261 C2 du CGI)\nCompte 616 — Primes d'assurances","subprice":"16.48000000","tva_tx":"0.0000","total_ht":"16.48000000","total_tva":"0.00000000","total_ttc":"16.48000000"}