--- colonne import_key dans llx_bank ?
SHOW COLUMNS FROM llx_bank LIKE 'import_key'
  Field=import_key | Type=varchar(14) | Null=YES | Key= | Default= | Extra=

--- import_key renseignes
SELECT COUNT(*) n, SUM(import_key IS NOT NULL AND import_key<>'') nk FROM llx_bank
  n=350 | nk=0

--- plan comptable installe ?
SELECT COUNT(*) n FROM llx_accounting_account
  n=2741

--- comptes cles existants
SELECT account_number,label FROM llx_accounting_account WHERE account_number LIKE '512%' OR account_number LIKE '471%' OR account_number LIKE '455%' OR account_number LIKE '4455%' OR account_number LIKE '164%' LIMIT 30
  account_number=164 | label=Emprunts auprès des établissements de crédit
  account_number=164 | label=Emprunts auprès des établissements de crédit
  account_number=164 | label=Emprunts auprès des établissements de crédit
  account_number=1641 | label=Emprunts fonciers
  account_number=1642 | label=Autres emprunts à moyen et long terme
  account_number=1643 | label=Emprunts à court terme
  account_number=1648 | label=Intérêts courus sur emprunts auprès des établissements de crédit
  account_number=4455 | label=Taxes sur le chiffre d'affaires à décaisser
  account_number=4455 | label=Taxes sur le chiffre d'affaires à décaisser
  account_number=4455 | label=Taxes sur le chiffre d'affaires à décaisser
  account_number=44551 | label=TVA à décaisser
  account_number=44551 | label=TVA à décaisser
  account_number=44551 | label=TVA à décaisser
  account_number=44552 | label=TVA antérieurement déduite à reverser
  account_number=44558 | label=Taxes assimilées à la TVA
  account_number=44558 | label=Taxes assimilées à la TVA
  account_number=455 | label=Partenaires - comptes courants
  account_number=455 | label=Associés - Comptes courants
  account_number=455 | label=Associés - Comptes courants
  account_number=4551 | label=Principal
  account_number=4551 | label=Associés - Comptes courants (principal)
  account_number=4553 | label=Associés - Comptes bloqués (principal)
  account_number=4558 | label=Intérêts courus
  account_number=4558 | label=Associés - Comptes courants (intérêts courus)
  account_number=45581 | label=Associés - Comptes courants (intérêts courus)
  account_number=45583 | label=Associés - Comptes bloqués (intérêts courus)
  account_number=471 | label=Comptes d'attente (jusqu'à 474)
  account_number=471 | label=Comptes d'attente
  account_number=471 | label=Comptes d'attente
  account_number=512 | label=Banques

--- journaux
SELECT rowid,code,label,nature,active FROM llx_accounting_journal
  rowid=1 | code=VT | label=ACCOUNTING_SELL_JOURNAL | nature=2 | active=1
  rowid=2 | code=AC | label=ACCOUNTING_PURCHASE_JOURNAL | nature=3 | active=1
  rowid=3 | code=BQ | label=FinanceJournal | nature=4 | active=1
  rowid=4 | code=OD | label=ACCOUNTING_MISCELLANEOUS_JOURNAL | nature=1 | active=1
  rowid=5 | code=AN | label=ACCOUNTING_HAS_NEW_JOURNAL | nature=9 | active=1
  rowid=6 | code=ER | label=ExpenseReportsJournal | nature=5 | active=1
  rowid=7 | code=INV | label=InventoryJournal | nature=8 | active=1

--- exercices
SELECT COUNT(*) n FROM llx_accounting_fiscalyear
  n=0

--- ecritures comptables
SELECT COUNT(*) n FROM llx_accounting_bookkeeping
  n=0

--- constantes compta/TVA
SELECT name,value FROM llx_const WHERE name LIKE 'ACCOUNTING%' OR name LIKE '%TAX_MODE%' OR name LIKE 'MAIN_MODULE_ACCOUNTING%' OR name LIKE 'MAIN_MODULE_LOAN%' OR name LIKE 'MAIN_MODULE_SALAR%' OR name LIKE 'MAIN_MODULE_TAX%'
  name=MAIN_MODULE_TAX | value=1
  name=ACCOUNTING_ACCOUNT_SUSPENSE | value=471
  name=ACCOUNTING_ACCOUNT_TRANSFER_CASH | value=58
  name=ACCOUNTING_EXPORT_MODELCSV | value=1
  name=ACCOUNTING_LENGTH_GACCOUNT | value=
  name=ACCOUNTING_LENGTH_AACCOUNT | value=
  name=ACCOUNTING_EXPORT_DATE | value=%Y-%m-%d
  name=ACCOUNTING_EXPORT_SEPARATORCSV | value=,
  name=ACCOUNTING_EXPORT_FORMAT | value=csv
  name=TAX_MODE | value=0
  name=TAX_MODE_SELL_PRODUCT | value=invoice
  name=TAX_MODE_BUY_PRODUCT | value=invoice
  name=TAX_MODE_SELL_SERVICE | value=payment
  name=TAX_MODE_BUY_SERVICE | value=payment
  name=MAIN_MODULE_ACCOUNTING | value=1
  name=MAIN_MODULE_LOAN | value=1

--- comptes bancaires
SELECT rowid,ref,label,account_number,fk_accountancy_journal,clos,rappro,currency_code FROM llx_bank_account
  rowid=1 | ref=Tekni-pli | label=Compte Courant | account_number=1 | fk_accountancy_journal= | clos=0 | rappro=1 | currency_code=EUR
  rowid=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | account_number=512 | fk_accountancy_journal= | clos=1 | rappro=1 | currency_code=EUR

===== FOURNISSEURS =====

--- factures fourn validees par annee/paye
SELECT YEAR(datef) y, paye, COUNT(*) n, ROUND(SUM(total_ht),2) ht, ROUND(SUM(total_tva),2) tva, ROUND(SUM(total_ttc),2) ttc FROM llx_facture_fourn WHERE fk_statut>0 GROUP BY y,paye ORDER BY y,paye
  y=2026 | paye=0 | n=24 | ht=31691.34 | tva=6297.81 | ttc=37989.15
  y=2026 | paye=1 | n=178 | ht=176961.26 | tva=28142.52 | ttc=205103.78

--- factures fourn par statut
SELECT fk_statut, COUNT(*) n, ROUND(SUM(total_ttc),2) ttc FROM llx_facture_fourn GROUP BY fk_statut
  fk_statut=2 | n=178 | ttc=205103.78
  fk_statut=1 | n=24 | ttc=37989.15

--- factures fourn PAYE=1 SANS aucun paiement (charge deja passee, decaissement absent)
SELECT COUNT(*) n, ROUND(SUM(f.total_ttc),2) ttc, ROUND(SUM(f.total_tva),2) tva FROM llx_facture_fourn f WHERE f.paye=1 AND f.fk_statut>0 AND NOT EXISTS (SELECT 1 FROM llx_paiementfourn_facturefourn pf WHERE pf.fk_facturefourn=f.rowid)
  n=0 | ttc= | tva=

--- factures fourn OUVERTES (401 non solde)
SELECT COUNT(*) n, ROUND(SUM(f.total_ttc),2) ttc, ROUND(SUM(f.total_tva),2) tva FROM llx_facture_fourn f WHERE f.paye=0 AND f.fk_statut>0
  n=24 | ttc=37989.15 | tva=6297.81

--- paiements fourn
SELECT COUNT(*) n, ROUND(SUM(amount),2) m FROM llx_paiementfourn
  n=159 | m=205103.76

===== CLIENTS =====

--- factures clients validees par annee/paye
SELECT YEAR(datef) y, paye, COUNT(*) n, ROUND(SUM(total_ht),2) ht, ROUND(SUM(total_tva),2) tva, ROUND(SUM(total_ttc),2) ttc FROM llx_facture WHERE fk_statut>0 GROUP BY y,paye ORDER BY y,paye
  y=2025 | paye=0 | n=8 | ht=66688.34 | tva=13337.68 | ttc=80026.02
  y=2025 | paye=1 | n=107 | ht=105441.14 | tva=21088.12 | ttc=126529.26
  y=2026 | paye=0 | n=47 | ht=26394.44 | tva=5278.81 | ttc=31673.25
  y=2026 | paye=1 | n=169 | ht=153058.83 | tva=30611.87 | ttc=183670.7

--- paiements clients
SELECT COUNT(*) n, ROUND(SUM(amount),2) m FROM llx_paiement
  n=112 | m=311230.32

--- paiements clients par annee
SELECT YEAR(datep) y, COUNT(*) n, ROUND(SUM(amount),2) m FROM llx_paiement GROUP BY y
  y=2025 | n=42 | m=116037.83
  y=2026 | n=70 | m=195192.49

===== AUTRES OBJETS =====
  llx_loan : 1
  llx_payment_loan : 8
  llx_salary : 0
  llx_payment_salary : 0
  llx_payment_various : 68
  llx_tva : 0
  llx_localtax : 0
  llx_chargesociales : 0
  llx_paiementcharge : 0