===== A. Distribution complete des ecarts banque/paiement =====
ecart=-0.01 | nb=3
ecart=0 | nb=201
(2 lignes)

===== B. Lignes de banque de moins de 0,05 EUR =====
(0 lignes)

===== C. Toutes les lignes de banque AMAZON =====
rowid=174 | dateo=2026-01-06 | amount=-19.49000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 05/01 | rappro=1 | num_releve=202601 | type=payment_supplier | url_id=60
rowid=173 | dateo=2026-01-06 | amount=-133.94000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 05/01 | rappro=1 | num_releve=202601 | type=payment_supplier | url_id=59
rowid=177 | dateo=2026-01-20 | amount=-119.90000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 17/01 | rappro=1 | num_releve=202601 | type=payment_supplier | url_id=63
rowid=179 | dateo=2026-01-30 | amount=-107.25000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON BUSINESS PAYL 29/01 | rappro=1 | num_releve=202601 | type=payment_supplier | url_id=65
rowid=411 | dateo=2026-02-19 | amount=-44.98000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | rappro=1 | num_releve=202602 | type=payment_various | url_id=76
rowid=186 | dateo=2026-04-21 | amount=-236.50000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 20/04 | rappro=1 | num_releve=202604 | type=payment_supplier | url_id=72
rowid=187 | dateo=2026-04-22 | amount=-59.84000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 21/04 | rappro=1 | num_releve=202604 | type=payment_supplier | url_id=73
rowid=254 | dateo=2026-05-04 | amount=-15.82000000 | label=(AgentCompta relevé) Paiement par carte X4074 AMAZON PAYMENTS PAYL 02/05 | rappro=1 | num_releve=202605 | type=payment_supplier | url_id=140
rowid=191 | dateo=2026-05-04 | amount=-14.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 02/05 | rappro=1 | num_releve=202605 | type=payment_supplier | url_id=77
rowid=427 | dateo=2026-07-03 | amount=-10.72000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | rappro=1 | num_releve=202607 | type=payment_various | url_id=92
rowid=426 | dateo=2026-07-03 | amount=-35.01000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | rappro=1 | num_releve=202607 | type=payment_various | url_id=91
rowid=172 | dateo=2026-07-23 | amount=-24.85000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=58
rowid=171 | dateo=2026-07-23 | amount=-189.05000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=57
rowid=170 | dateo=2026-07-23 | amount=-217.55000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=56
rowid=169 | dateo=2026-07-23 | amount=-15.12000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=55
rowid=273 | dateo=2026-07-23 | amount=-15.82000000 | label=(AgentCompta relevé) Paiement par carte X4074 AMAZON PAYMENTS PARI 22/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=159
rowid=163 | dateo=2026-07-29 | amount=-16.62000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=49
rowid=166 | dateo=2026-07-29 | amount=-11.75000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=52
rowid=165 | dateo=2026-07-29 | amount=-40.79000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=51
rowid=164 | dateo=2026-07-29 | amount=-56.59000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=50
rowid=162 | dateo=2026-07-29 | amount=-209.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | rappro=1 | num_releve=202607 | type=payment_supplier | url_id=48
rowid=493 | dateo=2026-08-24 | amount=-35.90000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=227
rowid=494 | dateo=2026-08-24 | amount=-19.17000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 21/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=228
rowid=495 | dateo=2026-08-31 | amount=-44.18000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=229
rowid=496 | dateo=2026-08-31 | amount=-33.32000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=230
rowid=497 | dateo=2026-08-31 | amount=-8.99000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=231
rowid=499 | dateo=2026-08-31 | amount=-19.97000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/08 | rappro=1 | num_releve=202608 | type=payment_supplier | url_id=233
(27 lignes)

===== D. Toutes les factures fournisseur Amazon =====
rowid=120 | ref=SI2601-0034 | ref_supplier=FR6GNUABEI | total_ht=111.61000000 | tva=0.00000000 | total_ttc=133.93000000 | datef=2026-01-05 | paye=1 | fk_statut=2
rowid=179 | ref=SI2601-0040 | ref_supplier=01/09 | total_ht=19.49000000 | tva=0.00000000 | total_ttc=19.49000000 | datef=2026-01-05 | paye=1 | fk_statut=2
rowid=180 | ref=SI2601-0041 | ref_supplier=01/10 | total_ht=99.92000000 | tva=0.00000000 | total_ttc=119.90000000 | datef=2026-01-20 | paye=1 | fk_statut=2
rowid=181 | ref=SI2601-0042 | ref_supplier=01/11 | total_ht=89.37000000 | tva=0.00000000 | total_ttc=107.24000000 | datef=2026-01-29 | paye=1 | fk_statut=2
rowid=183 | ref=SI2602-0044 | ref_supplier=02/12 | total_ht=29.16000000 | tva=0.00000000 | total_ttc=29.16000000 | datef=2026-02-18 | paye=0 | fk_statut=3
rowid=182 | ref=SI2602-0043 | ref_supplier=02/11 | total_ht=15.82000000 | tva=0.00000000 | total_ttc=15.82000000 | datef=2026-02-18 | paye=0 | fk_statut=3
rowid=396 | ref=SI2603-0189 | ref_supplier=03/19 | total_ht=249.17000000 | tva=0.00000000 | total_ttc=299.00000000 | datef=2026-03-13 | paye=1 | fk_statut=2
rowid=397 | ref=SI2604-0190 | ref_supplier=04/11 | total_ht=197.08000000 | tva=0.00000000 | total_ttc=236.50000000 | datef=2026-04-20 | paye=1 | fk_statut=2
rowid=398 | ref=SI2604-0191 | ref_supplier=04/12 | total_ht=49.87000000 | tva=0.00000000 | total_ttc=59.84000000 | datef=2026-04-21 | paye=1 | fk_statut=2
rowid=184 | ref=SI2605-0045 | ref_supplier=05/07 | total_ht=15.82000000 | tva=0.00000000 | total_ttc=15.82000000 | datef=2026-05-02 | paye=1 | fk_statut=2
rowid=185 | ref=SI2605-0046 | ref_supplier=05/08 | total_ht=11.66000000 | tva=0.00000000 | total_ttc=13.99000000 | datef=2026-05-03 | paye=1 | fk_statut=2
rowid=122 | ref=SI2607-0016 | ref_supplier=FR61PACSABEI | total_ht=181.29000000 | tva=0.00000000 | total_ttc=217.55000000 | datef=2026-07-22 | paye=1 | fk_statut=2
rowid=121 | ref=SI2607-0017 | ref_supplier=FR61P3QFABEI | total_ht=157.54000000 | tva=0.00000000 | total_ttc=189.05000000 | datef=2026-07-22 | paye=1 | fk_statut=2
rowid=109 | ref=SI2607-0018 | ref_supplier=FR61PADAABEI | total_ht=20.71000000 | tva=0.00000000 | total_ttc=24.85000000 | datef=2026-07-22 | paye=1 | fk_statut=2
rowid=108 | ref=SI2607-0013 | ref_supplier=FR61PB0VABEI | total_ht=12.60000000 | tva=0.00000000 | total_ttc=15.12000000 | datef=2026-07-23 | paye=1 | fk_statut=2
rowid=186 | ref=SI2607-0047 | ref_supplier=07/19 | total_ht=15.82000000 | tva=0.00000000 | total_ttc=15.82000000 | datef=2026-07-23 | paye=1 | fk_statut=2
rowid=123 | ref=SI2607-0010 | ref_supplier=FR61QY4HABEI | total_ht=9.79000000 | tva=0.00000000 | total_ttc=11.75000000 | datef=2026-07-28 | paye=1 | fk_statut=2
rowid=187 | ref=SI2607-0048 | ref_supplier=07/23 | total_ht=33.99000000 | tva=0.00000000 | total_ttc=40.79000000 | datef=2026-07-28 | paye=1 | fk_statut=2
rowid=104 | ref=SI2607-0011 | ref_supplier=FR61QOZ4ABEI | total_ht=47.16000000 | tva=0.00000000 | total_ttc=56.59000000 | datef=2026-07-28 | paye=1 | fk_statut=2
rowid=105 | ref=SI2607-0009 | ref_supplier=FR61R0BOABEI | total_ht=174.17000000 | tva=0.00000000 | total_ttc=209.00000000 | datef=2026-07-29 | paye=1 | fk_statut=2
rowid=188 | ref=SI2607-0049 | ref_supplier=07/24 | total_ht=16.62000000 | tva=0.00000000 | total_ttc=16.62000000 | datef=2026-07-29 | paye=1 | fk_statut=2
rowid=518 | ref=SI2608-0281 | ref_supplier=FR61SOAUABEI | total_ht=23.55000000 | tva=0.00000000 | total_ttc=28.26000000 | datef=2026-08-04 | paye=1 | fk_statut=2
rowid=519 | ref=SI2608-0282 | ref_supplier=FR61SK8IABEI | total_ht=7.45000000 | tva=0.00000000 | total_ttc=8.94000000 | datef=2026-08-04 | paye=1 | fk_statut=2
rowid=523 | ref=SI2608-0286 | ref_supplier=FR61SVYHABEI | total_ht=47.11000000 | tva=0.00000000 | total_ttc=56.53000000 | datef=2026-08-05 | paye=1 | fk_statut=2
rowid=521 | ref=SI2608-0284 | ref_supplier=FR61X185ABEI | total_ht=29.92000000 | tva=0.00000000 | total_ttc=35.90000000 | datef=2026-08-22 | paye=1 | fk_statut=2
rowid=515 | ref=SI2608-0278 | ref_supplier=FR61YXX9ABEI | total_ht=7.49000000 | tva=0.00000000 | total_ttc=8.99000000 | datef=2026-08-28 | paye=1 | fk_statut=2
rowid=514 | ref=SI2608-0277 | ref_supplier=FR61ZACBABEI | total_ht=36.82000000 | tva=0.00000000 | total_ttc=44.18000000 | datef=2026-08-29 | paye=1 | fk_statut=2
(27 lignes)

===== E. Reste a payer sur 120/181/185 =====
rowid=120 | ref=SI2601-0034 | total_ttc=133.93000000 | deja_paye=133.93 | reste=0 | paye=1
rowid=181 | ref=SI2601-0042 | total_ttc=107.24000000 | deja_paye=107.24 | reste=0 | paye=1
rowid=185 | ref=SI2605-0046 | total_ttc=13.99000000 | deja_paye=13.99 | reste=0 | paye=1
(3 lignes)

===== F. Lignes de detail des 3 factures =====
ERREUR: Unknown column 'fd.total_tva' in 'field list'

===== G. Controle equivalent cote clients (b.amount - p.amount) =====
somme_ecart=-0.01 | nb=138
(1 lignes)

===== G2. Detail divergences clients =====
rowid=67 | ref=PAY2603-0062 | datep=2026-03-16 12:00:00 | amount=1607.65000000 | b_rowid=68 | b_amount=1607.64000000 | label=(CustomerInvoicePayment)
(1 lignes)

===== H. Nb ecritures en comptabilite =====
nb=0
(1 lignes)

===== I. Notes et dates des 3 factures =====
ERREUR: Unknown column 'date_creation' in 'field list'