=== 1 TVA sur encaissements clients 2026 ===
{"mois":"2026-01","nb":"13","encaisse_ttc":"7797.85","tva_sur_encaissement":"1299.65"}
{"mois":"2026-02","nb":"21","encaisse_ttc":"23875.69","tva_sur_encaissement":"3979.24"}
{"mois":"2026-03","nb":"11","encaisse_ttc":"7852.37","tva_sur_encaissement":"1308.75"}
{"mois":"2026-04","nb":"27","encaisse_ttc":"21023.84","tva_sur_encaissement":"3504.05"}
{"mois":"2026-05","nb":"27","encaisse_ttc":"40285.76","tva_sur_encaissement":"6550.27"}
{"mois":"2026-06","nb":"31","encaisse_ttc":"31048.97","tva_sur_encaissement":"4764.21"}
{"mois":"2026-07","nb":"42","encaisse_ttc":"50526.4","tva_sur_encaissement":"8421.04"}
{"mois":"2026-08","nb":"41","encaisse_ttc":"31215.25","tva_sur_encaissement":"5202.53"}
{"mois":"2026-09","nb":"35","encaisse_ttc":"36660.11","tva_sur_encaissement":"6109.97"}
{"mois":"2026-10","nb":"13","encaisse_ttc":"15525.79","tva_sur_encaissement":"2587.63"}
-- 10 lignes

=== 2 TVA sur decaissements fourn 2026 ===
{"mois":"2026-01","nb":"12","paye_ttc":"27148.5","tva_sur_decaissement":"4518.74"}
{"mois":"2026-02","nb":"11","paye_ttc":"4551.99","tva_sur_decaissement":"734.52"}
{"mois":"2026-03","nb":"25","paye_ttc":"18152.37","tva_sur_decaissement":"1631.7"}
{"mois":"2026-04","nb":"32","paye_ttc":"22261.82","tva_sur_decaissement":"3176.42"}
{"mois":"2026-05","nb":"30","paye_ttc":"47549.58","tva_sur_decaissement":"6136.39"}
{"mois":"2026-06","nb":"24","paye_ttc":"31576.6","tva_sur_decaissement":"4409.37"}
{"mois":"2026-07","nb":"39","paye_ttc":"49101.12","tva_sur_decaissement":"7286.8"}
{"mois":"2026-08","nb":"29","paye_ttc":"39370.5","tva_sur_decaissement":"5986.17"}
{"mois":"2026-09","nb":"18","paye_ttc":"15705.03","tva_sur_decaissement":"2498.23"}
{"mois":"2026-10","nb":"7","paye_ttc":"9698.36","tva_sur_decaissement":"1166.39"}
-- 10 lignes

=== 3 CLIENTS 2026 biens(0)/services(1) ===
{"product_type":"0","nb":"1163","ht":"231682.11","tva":"45646.82"}
{"product_type":"1","nb":"33","ht":"11675.62","tva":"2335.12"}
{"product_type":"9","nb":"40","ht":"0","tva":"0"}
-- 3 lignes

=== 4 CLIENTS abandonnees ===
{"rowid":"25","ref":"FA2508-0021","datef":"2025-08-09","fk_statut":"3","close_code":"abandon","close_note":null,"nom":"Kerimov Nathan","ht":"495.6","tva":"99.12","ttc":"594.72"}
{"rowid":"34","ref":"FA2509-0028","datef":"2025-09-02","fk_statut":"3","close_code":"abandon","close_note":null,"nom":"Normandie Biologi'K Construction","ht":"64746.26","tva":"12949.25","ttc":"77695.51"}
-- 2 lignes

=== 5 detail factures a taux aberrant + reference import ===
{"ref":"SI2603-0166","ref_supplier":"03\/16","datef":"2026-03-31","ht":"52.67","tva":"3.33","ttc":"56","rowid":"650","tva_tx":"6.3200","l_ht":"52.67","l_tva":"3.33","l_ttc":"56","descr":"TRANSPORT SUR VENTE"}
{"ref":"SI2604-0064","ref_supplier":"04\/13","datef":"2026-04-25","ht":"49.31","tva":"4.1","ttc":"53.41","rowid":"531","tva_tx":"8.3100","l_ht":"49.31","l_tva":"4.1","l_ttc":"53.41","descr":"VOYAGES ET DEPLACEMENTS"}
{"ref":"SI2604-0209","ref_supplier":"CAS1894859","datef":"2026-04-08","ht":"31.67","tva":"3.33","ttc":"35","rowid":"498","tva_tx":"0.0000","l_ht":"0","l_tva":"0","l_ttc":"0","descr":"Autres Taxes"}
{"ref":"SI2604-0209","ref_supplier":"CAS1894859","datef":"2026-04-08","ht":"31.67","tva":"3.33","ttc":"35","rowid":"499","tva_tx":"0.0000","l_ht":"15","l_tva":"0","l_ttc":"15","descr":"Droits de Douane"}
{"ref":"SI2604-0209","ref_supplier":"CAS1894859","datef":"2026-04-08","ht":"31.67","tva":"3.33","ttc":"35","rowid":"500","tva_tx":"0.0000","l_ht":"0","l_tva":"0","l_ttc":"0","descr":"TVA à l'importation"}
{"ref":"SI2604-0209","ref_supplier":"CAS1894859","datef":"2026-04-08","ht":"31.67","tva":"3.33","ttc":"35","rowid":"501","tva_tx":"20.0000","l_ht":"16.67","l_tva":"3.33","l_ttc":"20","descr":"Frais additionnels de dédouanement (Montant Total des Surcharges)"}
{"ref":"SI2605-0154","ref_supplier":"05\/21","datef":"2026-05-21","ht":"425","tva":"60.01","ttc":"485.01","rowid":"623","tva_tx":"14.1200","l_ht":"425","l_tva":"60.01","l_ttc":"485.01","descr":"HONORAIRES JURIDIQUES"}
{"ref":"SI2606-0195","ref_supplier":"06\/06","datef":"2026-06-05","ht":"19.25","tva":"62.25","ttc":"81.5","rowid":"716","tva_tx":"323.3800","l_ht":"19.25","l_tva":"62.25","l_ttc":"81.5","descr":"FRAIS IMPORT MARCHANDISES"}
-- 8 lignes

=== 6 fourn par statut ===
{"fk_statut":"2","nb":"232","ht":"229065.15","tva":"37843.54"}
{"fk_statut":"3","nb":"12","ht":"6287.96","tva":"749.29"}
{"fk_statut":"1","nb":"12","ht":"16602.41","tva":"3295.48"}
-- 3 lignes

=== 7 payment_various par compte ===
{"accountancy_code":"401","net":"4272.54000000","nb":"7"}
{"accountancy_code":"4091","net":"1768.80000000","nb":"2"}
{"accountancy_code":"444","net":"6577.00000000","nb":"3"}
{"accountancy_code":"44551","net":"19823.00000000","nb":"6"}
{"accountancy_code":"44567","net":"-10117.00000000","nb":"3"}
{"accountancy_code":"455","net":"-10709.20000000","nb":"5"}
{"accountancy_code":"471","net":"567.98000000","nb":"11"}
{"accountancy_code":"6061","net":"291.56000000","nb":"2"}
{"accountancy_code":"6063","net":"362.33000000","nb":"4"}
{"accountancy_code":"6064","net":"90.71000000","nb":"3"}
{"accountancy_code":"616","net":"2295.22000000","nb":"44"}
{"accountancy_code":"6251","net":"7.30000000","nb":"1"}
{"accountancy_code":"627","net":"573.70000000","nb":"14"}
{"accountancy_code":"6354","net":"193.20000000","nb":"2"}
{"accountancy_code":"641","net":"1627.13000000","nb":"1"}
{"accountancy_code":"6611","net":"551.91000000","nb":"10"}
-- 16 lignes

=== 8 fourn validees NON payees ===
{"ref":"SI2605-0154","ref_supplier":"05\/21","datef":"2026-05-21","nom":"NOTAIRE","ht":"425","tva":"60.01","ttc":"485.01"}
{"ref":"SI2606-0124","ref_supplier":"06\/26","datef":"2026-06-29","nom":"NLJ","ht":"96.2","tva":"19.24","ttc":"115.44"}
{"ref":"SI2609-0260","ref_supplier":"00270001549","datef":"2026-09-08","nom":"TACHER ACOGEX","ht":"43.2","tva":"8.64","ttc":"51.84"}
{"ref":"SI2609-0272","ref_supplier":"F267303","datef":"2026-09-09","nom":"Sellerie Thomas","ht":"279","tva":"55.8","ttc":"334.8"}
{"ref":"SI2609-0263","ref_supplier":"4335826593","datef":"2026-09-24","nom":"Würth France SAS","ht":"49.8","tva":"9.96","ttc":"59.76"}
{"ref":"SI2609-0264","ref_supplier":"26029293","datef":"2026-09-30","nom":"ALMET PARIS","ht":"5582.95","tva":"1116.59","ttc":"6699.54"}
{"ref":"SI2609-0270","ref_supplier":"VEN739486","datef":"2026-09-30","nom":"MULTILAQUE","ht":"2931","tva":"586.2","ttc":"3517.2"}
{"ref":"SI2609-0271","ref_supplier":"FA-26000913","datef":"2026-09-30","nom":"Fondation LES ATELIERS DU MOULIN A VENT - ESAT DE LA FONDATION RICHARD","ht":"499.9","tva":"99.98","ttc":"599.88"}
{"ref":"SI2610-0269","ref_supplier":"26029841","datef":"2026-10-07","nom":"ALMET PARIS","ht":"692.13","tva":"138.42","ttc":"830.55"}
{"ref":"SI2610-0297","ref_supplier":"26030416","datef":"2026-10-14","nom":"ALMET PARIS","ht":"2568.2","tva":"513.64","ttc":"3081.84"}
{"ref":"SI2610-0298","ref_supplier":"26030415","datef":"2026-10-14","nom":"ALMET PARIS","ht":"1653.03","tva":"330.6","ttc":"1983.63"}
{"ref":"SI2610-0301","ref_supplier":"F267440","datef":"2026-10-20","nom":"Sellerie Thomas","ht":"1782","tva":"356.4","ttc":"2138.4"}
-- 12 lignes

=== 9 clients 2026 validees non payees ===
{"nb":"35","ht":"30476.86","tva":"6095.32","ttc":"36572.18"}
-- 1 lignes