=== A1 CLIENTS 2026 mois/type/statut ===
{"mois":"2026-01","type":"0","fk_statut":"1","nb":"1","ht":"141.38","tva":"28.27","ttc":"169.65"}
{"mois":"2026-01","type":"0","fk_statut":"2","nb":"11","ht":"7117.44","tva":"1423.55","ttc":"8540.99"}
{"mois":"2026-02","type":"0","fk_statut":"2","nb":"16","ht":"19399.62","tva":"3879.91","ttc":"23279.53"}
{"mois":"2026-03","type":"0","fk_statut":"2","nb":"23","ht":"24304.11","tva":"4860.85","ttc":"29164.96"}
{"mois":"2026-04","type":"0","fk_statut":"1","nb":"1","ht":"218.53","tva":"43.7","ttc":"262.23"}
{"mois":"2026-04","type":"0","fk_statut":"2","nb":"42","ht":"26261.63","tva":"5252.41","ttc":"31514.04"}
{"mois":"2026-05","type":"0","fk_statut":"1","nb":"1","ht":"215.76","tva":"43.15","ttc":"258.91"}
{"mois":"2026-05","type":"0","fk_statut":"2","nb":"31","ht":"34536.02","tva":"6217.58","ttc":"40753.6"}
{"mois":"2026-06","type":"0","fk_statut":"1","nb":"1","ht":"1152","tva":"230.4","ttc":"1382.4"}
{"mois":"2026-06","type":"0","fk_statut":"2","nb":"27","ht":"25277.85","tva":"5055.61","ttc":"30333.46"}
{"mois":"2026-07","type":"0","fk_statut":"1","nb":"5","ht":"1271.85","tva":"254.34","ttc":"1526.19"}
{"mois":"2026-07","type":"0","fk_statut":"2","nb":"37","ht":"31209.58","tva":"6241.83","ttc":"37451.41"}
{"mois":"2026-08","type":"0","fk_statut":"0","nb":"2","ht":"931.93","tva":"186.4","ttc":"1118.33"}
{"mois":"2026-08","type":"0","fk_statut":"1","nb":"7","ht":"5335.64","tva":"1067.13","ttc":"6402.77"}
{"mois":"2026-08","type":"0","fk_statut":"2","nb":"37","ht":"26556.8","tva":"5311.33","ttc":"31868.13"}
{"mois":"2026-09","type":"0","fk_statut":"1","nb":"10","ht":"5348.69","tva":"1069.75","ttc":"6418.44"}
{"mois":"2026-09","type":"0","fk_statut":"2","nb":"16","ht":"18217.82","tva":"3643.55","ttc":"21861.37"}
{"mois":"2026-10","type":"0","fk_statut":"1","nb":"9","ht":"16793.01","tva":"3358.58","ttc":"20151.59"}
-- 18 lignes

=== A2 CLIENTS 2026 ecart entete/lignes ===
-- 0 lignes

=== B1 FOURN 2026 mois/type/statut ===
{"mois":"2026-01","type":"0","fk_statut":"2","nb":"14","ht":"22804.76","tva":"4553.74","ttc":"27358.5"}
{"mois":"2026-02","type":"0","fk_statut":"2","nb":"18","ht":"9410.35","tva":"1853.09","ttc":"11263.44"}
{"mois":"2026-02","type":"0","fk_statut":"3","nb":"2","ht":"44.98","tva":"0","ttc":"44.98"}
{"mois":"2026-03","type":"0","fk_statut":"2","nb":"31","ht":"43059.04","tva":"6345.38","ttc":"49404.42"}
{"mois":"2026-04","type":"0","fk_statut":"2","nb":"27","ht":"11136.24","tva":"2180.58","ttc":"13316.82"}
{"mois":"2026-05","type":"0","fk_statut":"1","nb":"1","ht":"425","tva":"60.01","ttc":"485.01"}
{"mois":"2026-05","type":"0","fk_statut":"2","nb":"32","ht":"48991.49","tva":"7652.05","ttc":"56643.54"}
{"mois":"2026-05","type":"0","fk_statut":"3","nb":"2","ht":"4004","tva":"308","ttc":"4312"}
{"mois":"2026-06","type":"0","fk_statut":"1","nb":"1","ht":"96.2","tva":"19.24","ttc":"115.44"}
{"mois":"2026-06","type":"0","fk_statut":"2","nb":"34","ht":"40658.32","tva":"6594.59","ttc":"47252.91"}
{"mois":"2026-07","type":"0","fk_statut":"2","nb":"38","ht":"26416.03","tva":"4720.17","ttc":"31136.2"}
{"mois":"2026-07","type":"0","fk_statut":"3","nb":"6","ht":"756.53","tva":"144.81","ttc":"901.34"}
{"mois":"2026-08","type":"0","fk_statut":"2","nb":"26","ht":"15032.99","tva":"2311.04","ttc":"17344.03"}
{"mois":"2026-08","type":"0","fk_statut":"3","nb":"2","ht":"1482.45","tva":"296.48","ttc":"1778.93"}
{"mois":"2026-09","type":"0","fk_statut":"1","nb":"6","ht":"9385.85","tva":"1877.17","ttc":"11263.02"}
{"mois":"2026-09","type":"0","fk_statut":"2","nb":"8","ht":"7162.56","tva":"1294.23","ttc":"8456.79"}
{"mois":"2026-10","type":"0","fk_statut":"1","nb":"4","ht":"6695.36","tva":"1339.06","ttc":"8034.42"}
{"mois":"2026-10","type":"0","fk_statut":"2","nb":"4","ht":"4393.37","tva":"338.67","ttc":"4732.04"}
-- 18 lignes

=== B2 FOURN 2026 ecart entete/lignes ===
-- 0 lignes

=== C1 CLIENTS 2026 distribution taux (val.) ===
{"tva_tx":"0.0000","vat_src_code":"","nb":"42","ht":"3448","tva":"0"}
{"tva_tx":"20.0000","vat_src_code":"","nb":"1194","ht":"239909.73","tva":"47981.94"}
-- 2 lignes

=== C2 FOURN 2026 distribution taux (val.) ===
{"tva_tx":"0.0000","vat_src_code":"","nb":"50","ht":"39550.98","tva":"0"}
{"tva_tx":"6.3200","vat_src_code":"","nb":"1","ht":"52.67","tva":"3.33"}
{"tva_tx":"8.3100","vat_src_code":"","nb":"1","ht":"49.31","tva":"4.1"}
{"tva_tx":"10.0000","vat_src_code":"","nb":"18","ht":"1047.09","tva":"104.73"}
{"tva_tx":"14.1200","vat_src_code":"","nb":"1","ht":"425","tva":"60.01"}
{"tva_tx":"20.0000","vat_src_code":"","nb":"268","ht":"204523.26","tva":"40904.6"}
{"tva_tx":"323.3800","vat_src_code":"","nb":"1","ht":"19.25","tva":"62.25"}
-- 7 lignes

=== D1 CLIENTS lignes total_tva incoherent ===
-- 0 lignes

=== D2 FOURN lignes tva incoherent ===
-- 0 lignes

=== E1 payment_various TOUS ===
{"rowid":"1","ref":null,"datep":"2026-01-06","datev":"2026-01-06","sens":"0","amount":"61.15","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"286"}
{"rowid":"9","ref":null,"datep":"2026-01-06","datev":"2026-01-06","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"294"}
{"rowid":"26","ref":null,"datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"80.46","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"319"}
{"rowid":"27","ref":null,"datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"320"}
{"rowid":"28","ref":null,"datep":"2026-01-07","datev":"2026-01-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"321"}
{"rowid":"69","ref":null,"datep":"2026-01-09","datev":"2026-01-09","sens":"0","amount":"225.84","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","fk_bank":"404"}
{"rowid":"70","ref":null,"datep":"2026-01-12","datev":"2026-01-12","sens":"0","amount":"1334.74","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","fk_bank":"405"}
{"rowid":"71","ref":null,"datep":"2026-01-12","datev":"2026-01-12","sens":"0","amount":"2688","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","fk_bank":"406"}
{"rowid":"72","ref":null,"datep":"2026-01-14","datev":"2026-01-14","sens":"0","amount":"16.75","accountancy_code":"471","subledger_account":"","label":"Acompte HTC — annulé le jour même (1\/2)","fk_bank":"407"}
{"rowid":"73","ref":null,"datep":"2026-01-14","datev":"2026-01-14","sens":"1","amount":"16.75","accountancy_code":"471","subledger_account":"","label":"Annulation acompte HTC (1\/2)","fk_bank":"408"}
{"rowid":"74","ref":null,"datep":"2026-01-14","datev":"2026-01-14","sens":"1","amount":"16.75","accountancy_code":"471","subledger_account":"","label":"Annulation acompte HTC (2\/2)","fk_bank":"409"}
{"rowid":"104","ref":null,"datep":"2026-01-14","datev":"2026-01-14","sens":"0","amount":"16.75","accountancy_code":"471","subledger_account":"","label":"Acompte HTC - tentative annulee (3e debit du releve)","fk_bank":"440"}
{"rowid":"29","ref":null,"datep":"2026-01-15","datev":"2026-01-15","sens":"0","amount":"20.9","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"322"}
{"rowid":"30","ref":null,"datep":"2026-01-23","datev":"2026-01-23","sens":"0","amount":"60","accountancy_code":"471","subledger_account":"","label":"Crédit-bail — acte de gestion à identifier","fk_bank":"323"}
{"rowid":"17","ref":null,"datep":"2026-01-28","datev":"2026-01-28","sens":"0","amount":"7014","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de décembre 2025 — solde la dette d'ouverture","fk_bank":"309"}
{"rowid":"10","ref":null,"datep":"2026-02-04","datev":"2026-02-04","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"295"}
{"rowid":"2","ref":null,"datep":"2026-02-05","datev":"2026-02-05","sens":"0","amount":"59.84","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"287"}
{"rowid":"31","ref":null,"datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"80.46","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"324"}
{"rowid":"32","ref":null,"datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"325"}
{"rowid":"33","ref":null,"datep":"2026-02-09","datev":"2026-02-09","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"326"}
{"rowid":"34","ref":null,"datep":"2026-02-17","datev":"2026-02-17","sens":"1","amount":"54","accountancy_code":"471","subledger_account":"","label":"Crédit-bail — acte de gestion à identifier","fk_bank":"327"}
{"rowid":"35","ref":null,"datep":"2026-02-17","datev":"2026-02-17","sens":"0","amount":"20.9","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"328"}
{"rowid":"75","ref":null,"datep":"2026-02-17","datev":"2026-02-17","sens":"0","amount":"5.99","accountancy_code":"471","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"410"}
{"rowid":"76","ref":null,"datep":"2026-02-19","datev":"2026-02-19","sens":"0","amount":"44.98","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_bank":"411"}
{"rowid":"18","ref":null,"datep":"2026-02-25","datev":"2026-02-25","sens":"1","amount":"3115","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_bank":"310"}
{"rowid":"11","ref":null,"datep":"2026-03-04","datev":"2026-03-04","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"296"}
{"rowid":"3","ref":null,"datep":"2026-03-05","datev":"2026-03-05","sens":"0","amount":"58.52","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"288"}
{"rowid":"36","ref":null,"datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"80.46","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"329"}
{"rowid":"37","ref":null,"datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"330"}
{"rowid":"38","ref":null,"datep":"2026-03-09","datev":"2026-03-09","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"331"}
{"rowid":"39","ref":null,"datep":"2026-03-17","datev":"2026-03-17","sens":"0","amount":"20.9","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"332"}
{"rowid":"77","ref":null,"datep":"2026-03-17","datev":"2026-03-17","sens":"0","amount":"5.99","accountancy_code":"471","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"412"}
{"rowid":"19","ref":null,"datep":"2026-03-25","datev":"2026-03-25","sens":"0","amount":"2367","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de mars 2026","fk_bank":"311"}
{"rowid":"12","ref":null,"datep":"2026-04-03","datev":"2026-04-03","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"297"}
{"rowid":"40","ref":null,"datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"80.46","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"333"}
{"rowid":"41","ref":null,"datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"334"}
{"rowid":"42","ref":null,"datep":"2026-04-07","datev":"2026-04-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"335"}
{"rowid":"4","ref":null,"datep":"2026-04-08","datev":"2026-04-08","sens":"0","amount":"57.2","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"289"}
{"rowid":"78","ref":null,"datep":"2026-04-08","datev":"2026-04-08","sens":"0","amount":"132.8","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-03 — services bancaires","fk_bank":"413"}
{"rowid":"79","ref":null,"datep":"2026-04-14","datev":"2026-04-14","sens":"0","amount":"147.76","accountancy_code":"6061","subledger_account":"","label":"Carburant — Leclerc station (TVA non récupérée faute de pièce)","fk_bank":"414"}
{"rowid":"43","ref":null,"datep":"2026-04-15","datev":"2026-04-15","sens":"0","amount":"22","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"336"}
{"rowid":"80","ref":null,"datep":"2026-04-17","datev":"2026-04-17","sens":"0","amount":"5.99","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"415"}
{"rowid":"20","ref":null,"datep":"2026-04-30","datev":"2026-04-30","sens":"1","amount":"4808","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_bank":"312"}
{"rowid":"81","ref":null,"datep":"2026-05-04","datev":"2026-05-04","sens":"0","amount":"37.73","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Négo Achat C+ (TVA non récupérée faute de pièce)","fk_bank":"416"}
{"rowid":"5","ref":null,"datep":"2026-05-05","datev":"2026-05-05","sens":"0","amount":"55.88","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"290"}
{"rowid":"13","ref":null,"datep":"2026-05-06","datev":"2026-05-06","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"298"}
{"rowid":"44","ref":null,"datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"80.46","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"337"}
{"rowid":"45","ref":null,"datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"338"}
{"rowid":"46","ref":null,"datep":"2026-05-07","datev":"2026-05-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"339"}
{"rowid":"82","ref":null,"datep":"2026-05-12","datev":"2026-05-12","sens":"0","amount":"253.43","accountancy_code":"471","subledger_account":"","label":"Achat Verpakgigant — remboursé le 15\/05","fk_bank":"417"}
{"rowid":"21","ref":null,"datep":"2026-05-15","datev":"2026-05-15","sens":"0","amount":"4385","accountancy_code":"444","subledger_account":"","label":"Impôt sur les sociétés — solde la dette d'ouverture","fk_bank":"313"}
{"rowid":"83","ref":null,"datep":"2026-05-15","datev":"2026-05-15","sens":"1","amount":"253.43","accountancy_code":"471","subledger_account":"","label":"Remboursement Verpakgigant","fk_bank":"418"}
{"rowid":"47","ref":null,"datep":"2026-05-16","datev":"2026-05-16","sens":"0","amount":"22","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"340"}
{"rowid":"48","ref":null,"datep":"2026-05-18","datev":"2026-05-18","sens":"1","amount":"118.8","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_bank":"341"}
{"rowid":"84","ref":null,"datep":"2026-05-18","datev":"2026-05-18","sens":"0","amount":"5.99","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"419"}
{"rowid":"68","ref":null,"datep":"2026-05-19","datev":"2026-05-19","sens":"0","amount":"550","accountancy_code":"471","subledger_account":"","label":"Virement notaire du 19\/05 — part non justifiée","fk_bank":"370"}
{"rowid":"85","ref":null,"datep":"2026-05-20","datev":"2026-05-20","sens":"0","amount":"31.7","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Delvia (TVA non récupérée faute de pièce)","fk_bank":"420"}
{"rowid":"86","ref":null,"datep":"2026-05-26","datev":"2026-05-26","sens":"0","amount":"1795.2","accountancy_code":"4091","subledger_account":"","label":"Acompte KDI sur proforma 9011595061","fk_bank":"421"}
{"rowid":"87","ref":null,"datep":"2026-05-26","datev":"2026-05-26","sens":"0","amount":"143.8","accountancy_code":"6061","subledger_account":"","label":"Carburant — Relais Bretteville (TVA non récupérée faute de pièce)","fk_bank":"422"}
{"rowid":"22","ref":null,"datep":"2026-05-28","datev":"2026-05-28","sens":"0","amount":"1272","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de mai 2026","fk_bank":"314"}
{"rowid":"88","ref":null,"datep":"2026-05-28","datev":"2026-05-28","sens":"0","amount":"7.3","accountancy_code":"6251","subledger_account":"","label":"Péage — SAPN","fk_bank":"423"}
{"rowid":"49","ref":null,"datep":"2026-05-29","datev":"2026-05-29","sens":"1","amount":"500","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_bank":"342"}
{"rowid":"50","ref":null,"datep":"2026-05-30","datev":"2026-05-30","sens":"0","amount":"500","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_bank":"343"}
{"rowid":"14","ref":null,"datep":"2026-06-03","datev":"2026-06-03","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"299"}
{"rowid":"6","ref":null,"datep":"2026-06-05","datev":"2026-06-05","sens":"0","amount":"54.55","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"291"}
{"rowid":"52","ref":null,"datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"80.45","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"345"}
{"rowid":"53","ref":null,"datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"346"}
{"rowid":"54","ref":null,"datep":"2026-06-08","datev":"2026-06-08","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"347"}
{"rowid":"89","ref":null,"datep":"2026-06-09","datev":"2026-06-09","sens":"0","amount":"68.35","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-05 — services bancaires","fk_bank":"424"}
{"rowid":"55","ref":null,"datep":"2026-06-16","datev":"2026-06-16","sens":"0","amount":"22","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"348"}
{"rowid":"23","ref":null,"datep":"2026-06-17","datev":"2026-06-17","sens":"0","amount":"1096","accountancy_code":"444","subledger_account":"","label":"Acompte d'impôt sur les sociétés 2026","fk_bank":"315"}
{"rowid":"90","ref":null,"datep":"2026-06-17","datev":"2026-06-17","sens":"0","amount":"5.99","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"425"}
{"rowid":"56","ref":null,"datep":"2026-06-23","datev":"2026-06-23","sens":"1","amount":"590.4","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_bank":"349"}
{"rowid":"57","ref":null,"datep":"2026-06-23","datev":"2026-06-23","sens":"1","amount":"10000","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_bank":"350"}
{"rowid":"24","ref":null,"datep":"2026-06-24","datev":"2026-06-24","sens":"0","amount":"3","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de juin 2026","fk_bank":"316"}
{"rowid":"15","ref":null,"datep":"2026-07-03","datev":"2026-07-03","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"300"}
{"rowid":"91","ref":null,"datep":"2026-07-03","datev":"2026-07-03","sens":"0","amount":"35.01","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_bank":"426"}
{"rowid":"92","ref":null,"datep":"2026-07-03","datev":"2026-07-03","sens":"0","amount":"10.72","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_bank":"427"}
{"rowid":"7","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"53.21","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"292"}
{"rowid":"58","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"106.62","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"351"}
{"rowid":"59","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"352"}
{"rowid":"60","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"57.53","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"353"}
{"rowid":"61","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"354"}
{"rowid":"93","ref":null,"datep":"2026-07-07","datev":"2026-07-07","sens":"0","amount":"68.35","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-06 — services bancaires","fk_bank":"428"}
{"rowid":"62","ref":null,"datep":"2026-07-16","datev":"2026-07-16","sens":"0","amount":"22","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_bank":"355"}
{"rowid":"94","ref":null,"datep":"2026-07-16","datev":"2026-07-16","sens":"0","amount":"12","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)","fk_bank":"429"}
{"rowid":"95","ref":null,"datep":"2026-07-17","datev":"2026-07-17","sens":"0","amount":"5.99","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_bank":"430"}
{"rowid":"96","ref":null,"datep":"2026-07-21","datev":"2026-07-21","sens":"0","amount":"225.77","accountancy_code":"6354","subledger_account":"","label":"Redevance INPI — dépôt\/renouvellement de marque","fk_bank":"431"}
{"rowid":"97","ref":null,"datep":"2026-07-27","datev":"2026-07-27","sens":"1","amount":"26.4","accountancy_code":"4091","subledger_account":"","label":"Avoir KDI reçu — remboursement client 3813883","fk_bank":"432"}
{"rowid":"25","ref":null,"datep":"2026-07-30","datev":"2026-07-30","sens":"1","amount":"2194","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_bank":"317"}
{"rowid":"63","ref":null,"datep":"2026-07-31","datev":"2026-07-31","sens":"0","amount":"1627.13","accountancy_code":"641","subledger_account":"","label":"Salaire net","fk_bank":"356"}
{"rowid":"105","ref":null,"datep":"2026-07-31","datev":"2026-07-31","sens":"1","amount":"32.57","accountancy_code":"6354","subledger_account":"","label":"Avoir carte INPI VADS du 30\/07 — remboursement de la redevance de marque","fk_bank":"453"}
{"rowid":"8","ref":null,"datep":"2026-08-05","datev":"2026-08-05","sens":"0","amount":"51.87","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"293"}
{"rowid":"16","ref":null,"datep":"2026-08-05","datev":"2026-08-05","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"301"}
{"rowid":"102","ref":null,"datep":"2026-08-06","datev":"2026-08-06","sens":"0","amount":"280.9","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)","fk_bank":"437"}
{"rowid":"64","ref":null,"datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"130.01","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"357"}
{"rowid":"65","ref":null,"datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"358"}
{"rowid":"66","ref":null,"datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"57.53","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"359"}
{"rowid":"67","ref":null,"datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"360"}
{"rowid":"103","ref":null,"datep":"2026-08-07","datev":"2026-08-07","sens":"0","amount":"59.3","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-07 — services bancaires","fk_bank":"438"}
{"rowid":"113","ref":null,"datep":"2026-08-14","datev":"2026-08-14","sens":"0","amount":"31.4","accountancy_code":"627","subledger_account":"","label":"Frais bancaires — cotisation Compte à composer Pro","fk_bank":"485"}
{"rowid":"118","ref":null,"datep":"2026-08-26","datev":"2026-08-26","sens":"0","amount":"3617","accountancy_code":"44551","subledger_account":"","label":"DGFiP TVA","fk_bank":"521"}
{"rowid":"107","ref":null,"datep":"2026-09-02","datev":"2026-09-02","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_bank":"479"}
{"rowid":"106","ref":null,"datep":"2026-09-05","datev":"2026-09-05","sens":"0","amount":"50.52","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_bank":"478"}
{"rowid":"108","ref":null,"datep":"2026-09-07","datev":"2026-09-07","sens":"0","amount":"130.01","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"480"}
{"rowid":"109","ref":null,"datep":"2026-09-07","datev":"2026-09-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"481"}
{"rowid":"110","ref":null,"datep":"2026-09-07","datev":"2026-09-07","sens":"0","amount":"57.53","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"482"}
{"rowid":"111","ref":null,"datep":"2026-09-07","datev":"2026-09-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_bank":"483"}
{"rowid":"114","ref":null,"datep":"2026-09-14","datev":"2026-09-14","sens":"0","amount":"31.4","accountancy_code":"627","subledger_account":"","label":"Frais bancaires — cotisation Compte à composer Pro","fk_bank":"486"}
{"rowid":"119","ref":null,"datep":"2026-09-16","datev":"2026-09-16","sens":"0","amount":"1096","accountancy_code":"444","subledger_account":"","label":"DGFiP IS","fk_bank":"522"}
{"rowid":"112","ref":null,"datep":"2026-09-29","datev":"2026-09-29","sens":"0","amount":"5550","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de septembre 2026 — TVA1-092026","fk_bank":"484"}
{"rowid":"115","ref":null,"datep":"2026-10-02","datev":"2026-10-02","sens":"0","amount":"18.3","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur CAAE","fk_bank":"517"}
{"rowid":"116","ref":null,"datep":"2026-10-05","datev":"2026-10-05","sens":"0","amount":"49.17","accountancy_code":"6611","subledger_account":"","label":"Prêt, intérêts","fk_bank":"518"}
{"rowid":"120","ref":null,"datep":"2026-10-07","datev":"2026-10-07","sens":"0","amount":"130.01","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_bank":"523"}
{"rowid":"121","ref":null,"datep":"2026-10-07","datev":"2026-10-07","sens":"0","amount":"78.89","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_bank":"524"}
{"rowid":"122","ref":null,"datep":"2026-10-07","datev":"2026-10-07","sens":"0","amount":"57.53","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_bank":"525"}
{"rowid":"123","ref":null,"datep":"2026-10-07","datev":"2026-10-07","sens":"0","amount":"11.38","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_bank":"526"}
{"rowid":"117","ref":null,"datep":"2026-10-14","datev":"2026-10-14","sens":"0","amount":"31.4","accountancy_code":"627","subledger_account":"","label":"Cotisation du compte CA","fk_bank":"520"}
-- 118 lignes

=== E2 COLS llx_tva ===
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"tms","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}
{"Field":"datec","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"datep","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"datev","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"amount","Type":"double(24,8)","Null":"NO","Key":"","Default":"0.00000000","Extra":""}
{"Field":"fk_typepayment","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"num_payment","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"label","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"entity","Type":"int","Null":"NO","Key":"","Default":"1","Extra":""}
{"Field":"note","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"paye","Type":"smallint","Null":"NO","Key":"","Default":"0","Extra":""}
{"Field":"fk_account","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_creat","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_modif","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"import_key","Type":"varchar(14)","Null":"YES","Key":"","Default":null,"Extra":""}
-- 16 lignes

=== E3 COLS llx_payment_vat ===
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"fk_tva","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"datec","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"tms","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}
{"Field":"datep","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"amount","Type":"double(24,8)","Null":"YES","Key":"","Default":"0.00000000","Extra":""}
{"Field":"fk_typepaiement","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"num_paiement","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"note","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_bank","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_creat","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_modif","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
-- 12 lignes