Différences

Ci-dessous, les différences entre deux révisions de la page.

--- en:addons:cyberbanque [2025/07/17 11:51] – [Modifier - Panel] ics02
+++ en:addons:cyberbanque [2025/08/19 08:02] (Version actuelle) – [Versions] ics02
@@ Ligne 1: / Ligne 1: @@
-====== CYBERBANQUE: Integration of banking files* ======
+====== CYBERBANQUE: Integration of banking files ======
-FIXME EXTENSION BEING MIGRATED.
 ==== Features ====
@@ Ligne 28: / Ligne 28: @@
 It is also possible to use the [[https://manuel.gestan.fr/doku.php?id=en:wiki:outils:importer_fichier|import program]] to import posting files via text files.
-===== Installation =====
-The extension is installed via the [[en:wiki:admin:extensions|extensions manager]].
-Once installed, the **CyberBanque** menu will appear in Gestan's **Accounting** menu.
-{{:addons:cyberbank_04.png?nolink|}}
-With the ribbon menu, the menu is present in the **Receipts and disbursements** button menu.
 ===== Using the screen =====
@@ Ligne 42: / Ligne 33: @@
 //**Access : ** Accounting -> Receipts and disbursements -> CyberBanque//
-{{:en:addons:cyberbank_01.png?nolink|}}
+{{:en:addons:cyberbanque_01_en.png?nolink|}}
-Select the bank account concerned, confirm whether or not it is for **professional fees** (and if so, enter a default **VAT rate**). The **Latest** field will then display the latest date of the entries you have uploaded to this account (to enable extractions to be made from the correct date).
+Select the bank account concerned, confirm whether or not it is for **professional fees** (and if so, enter a default **VAT rate**). The **Last** field will then display the latest date of the entries you have uploaded to this account (to enable extractions to be made from the correct date).
 Then select a **default account assignment**, and specify the type of **bank format** for the input file.
@@ Ligne 54: / Ligne 45: @@
 You can then modify, as required: the payment method, the charge, enter a third party and a cheque number.
-Finally, the **Clear** button launches the integration of the entries into the database. If you had ticked the **Pointer** box, the entries created will be punched directly.
+Finally, the **Confirm** button launches the integration of the entries into the database. If you had ticked the **Pointing** box, the entries created will be punched directly.
 ==== Table context menu ====
-{{:en:addons:cyberbank_03.png?nolink|}}
+{{:en:addons:cyberbanque_03_en.png?nolink|}}
 You can select one or more rows in the table, and right-click on this selection to :
@@ Ligne 68: / Ligne 59: @@
 Correspondence rules are used to deduce an account assignment, a third party and an entry wording from the gross wording received from the bank.
-{{:addons:cyberbank_02.png?nolink|}}
+{{en:addons:cyberbanque_02_en.png?nolink|}}
 To set up a rule, use the context menu of a line and choose the **Create a rule** option.
-The **Original label** field displays the label read from the file.
+The **Origin label** field displays the label read from the file.
 From the original label, extract what is characteristic. Each time a label contains this **expression**, the entry will be classified in the chosen **imputation**, with the labels **entry** and **thirds**.
@@ Ligne 197: / Ligne 188: @@
 </code>
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="Crédit agricole">
-See Caisse d'Épargne, it's the same format.
+The file format is as follows:
+<code>
+Download from 22/08/2011
+M.OU MME NOIRAUD PAUL
+CCHQ 65445513447
+Balance at 22/08/2011 +12,368.71 Euros (EUR)
+Date: 18/08
+Label: CONRAD ELEC LEZENNES 16/08
+ PAIEMENT PAR CARTE
+Debit (EUR): 132.25
++--------------------------------------------------------------------+
+Date: 18/08
+Wording: 155056
+ CHEQUE RECEIPT
+Credit (EUR): 1,000.00
++--------------------------------------------------------------------+
+Date: 17/08
+Wording: APRR AUTOROUTE 21850 14/08
+ CARD PAYMENT
+Debit (EUR): 8.30
++--------------------------------------------------------------------+
+Date: 17/08
+Wording: APRR AUTOROUTE 21256 15/08
+ PAYMENT BY CARD
+Debit (EUR): 2.30
++--------------------------------------------------------------------+
+MME PAULETTE NOIRAUD
+MASTERCARD DEB I 5131 52xx xxxx xx25
+No transactions for this card between 01/08/2011 and 23/08/2011
+MR PAUL NOIRAUD
+MASTERCARD DEB I 5131 52xx xxxx xx77
+No transactions for this card between 01/08/2011 and 23/08/2011
+</code>
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="Crédit Agricole new format 2020">
-See Caisse d'Épargne, it's the same format.
+The file format is as follows:
+<code>
+Downloaded on 22/04/2020;
+E.U.R.L. SANZOT
+Card current account no. 84052696798;
+Balance at 22/04/2020 €60,585.93
+Outstanding on 1 card(s) at the end of May; -€309.85
+List of account transactions between 20/04/2020 and 22/04/2020;
+Date;Wording;Debit euros;Credit euros;
+/04/2020; "VIREMENT EMIS
+WEB IMPOTS 896222275 TVA 02 2020 896222275 TVA 02 2020
+896222275 VAT 02 2020 ";4 238,00;;
+/04/2020; "TRANSFER ISSUED
+WEB ICS-INFORMATIQUE order 2020-125-6 order 2020-125-6
+order 2020-125-6 ";168,50;;
+E.U.R.L. SANZOT - Holder;
+MR GASTON LAPELOUSE - Cardholder;
+ card no 7913 56XX XXXX 5487
+You have no outstanding balances;
+</code>
+CA files can concern several accounts at the same time. Gestan will read all the lines corresponding to the first account. Reading will stop at the end of the data in the
+first account.
+It is up to the user either to download one file per account, or to split the complete file into as many sub-files for different accounts.
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="Crédit Lyonnais">
-See Caisse d'Épargne, it's the same format.
+Crédit Lyonnais sends xls files which are actually text with a TAB separator.
+The format of LCL files is as follows:
+<code>
+date<tab>amount<tab>payment method<tab><tab>libellé<car10>
+</code>
+For example:
+<code>
+/03/2011 150.0 Transfer VIR.PERMANENT EU RL ANDREA
+/03/2011 -191.17 Direct debit PRLV APRIL ASSURANCES
+</code>
+Gestan processes all lines.
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="Crédit Mutuel">
-See Caisse d'Épargne, it's the same format.
+The file format is as follows
+<code>
+Transaction date;Value date;Debit;Credit;Label;Balance
+</code>
+For example
+<code>
+/08/2016;15/08/2016;-53,57;;PAIEMENT CB 2177 FONTENAY LE C ETS AUBERT CARTE 00000120;685,13
+/08/2016;15/08/2016;-990,92;;EFFET DOMICILIE0000084RLV000122 OPTIMIS CULTURE;-577,84
+/08/2016;15/08/2016;-355,42;; ECH PRET CAP+IN 00052 205207 02;-933,26
+/08/2016;15/08/2016;;3090,00;VRST REF39000V10;1709,46
+/08/2016;16/08/2016;-687,62;;PRLV SEPA CAISSE MSA des OP20160816000000EN220022221221S EMISSION 162;1021,84
+/08/2016;17/08/2016;;170,70; REM CHQ N0000085 REF00040R37;-164.46
+/08/2016;16/08/2016;-254.87;;EFFET DOMICILIE0000999RLV000027 COMMERCIALISATION RENE ;863.05
+/08/2016;17/08/2016;-389.64;;VIR SEPA REGLT FACT FC160201 EARL DUPONT;-591.59
+/08/2016;-376.60; CHEQUE 3584150;-968.19
+/08/2016;17/08/2016;-121.26;;PAIEMENT CB 1207 EGLY CARTE 06473358;-1183.53
+/08/2016;18/08/2016;-1000.00;;VIR FACTURE SANZOT;329.21
+/08/2016;22/08/2016;-303.85;;VIR RENUMERATION SALAIRE 2015;2021.56
+</code>
+The program processes all the lines.
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="La Banque Postale">
-See Caisse d'Épargne, it's the same format.
+The file format is as follows:
+<code>
+Date;Label;Amount(euros);Amount(francs);
+</code>
+For example:
+<code>
+Account number 0936769C031
+Type CCP
+Account held in euros
+Date 10/06/2014
+Balance (EUROS) -2905.12
+Balance (FRANCS) -19056.34
+Date Wording Amount(EUROS) Amount(FRANCS)
+/06/2014 CARD X8978 05/06/14 A 13H07 RETRAIT DAB AUCHAN LUNEVILLE -200 -1311,91
+/06/2014 CHEQUE N 4489094 -69,62 -456,68
+/06/2014 ACHAT CB E D F 02.06. 14 CARD NUMBER 456 -526.15 -3451.32
+/06/2014 CHEQUE REMISE DU 02/06/2014 287.86 1888.24
+/06/2014 PRELEVEMENT DE Orange REF: 7895614384 ABO MOBILE: 0655698 - (compte: 6595269629) - R -45.21 -296.56
+/06/2014 PAYMENT LCR OF 31/05/14 STATEMENT NO 00000057 -189.07 -1240.22
+/06/2014 PAYMENT LCR OF 31/05/14 STATEMENT NO 00000057 -55.24 -362.35
+/06/2014 PAYMENT LCR OF 31/05/14 STATEMENT NO 00000057 -35.56 -233.26
+/06/2014 CHEQUE N 4489095 -86.84 -569.63
+/06/2014 PURCHASE CB BUFFALO GRILL 01. 06.14 CARD NUMBER 456 -47.2 -309.61
+/06/2014 PURCHASE CB KFC 31.05.14 CARD NUMBER 456 -31.68 -207.81
+/06/2014 PURCHASE CB L ATRIUM 01.06.14 CARD NUMBER 456 -22 -144.31
+/06/2014 PURCHASE CB WP-SKYPE 28.05. 14 CARD NUMBER 456 -11.5 -75.44
+/05/2014 TRANSFER FOR ICS INFORMATIQUE ACCOUNT FR76589661008956000748758 PAYMENT OF INVOICE 2946 -100 -655, 96
+/05/2014 TRANSFER FOR MME DUPONT AURELIE ACCOUNT FR0220459005600907896E031 -400 -2623.83
+/05/2014 TRANSFER FOR DURANT MARC ACCOUNT FR76895661008795000728956 REGLEMENT FACTURE 24744 -300 -1967.87
+</code>
 </panel>
-<panel title="Banque de La Réunion">
+<panel title="PostFinance Suisse">
-See Caisse d'Épargne, it's the same format.
+The file format is as follows:
+The file format is as follows:
+<code>
+Posting date;Notification text;Credit in CHF;Debit in CHF;Value;Balance in CHF
+</code>
+For example:
+<code>
+Date from:;2020-03-01
+Date to:;2020-03-30
+Posting type:;All entries
+Account:;CH3909000000000000123
+Currency:;CHF
+Posting date;Notification text;Credit in CHF;Debit in CHF;Value;Balance in CHF
+-03-30; "BVR 01-0031-6 Credit Suisse 6010 Kriens SENDER REFERENCE: ALSACLOUD-C1 ";;-10. 25;2020-03-30;
+-03-26; "GIRO POST CH2109000000000000801 Dupont Jaques Plan-les-Ouates SENDER REFERENCE: salaire-dj-2020-03 ";;-2730.00;2020-03-26;115807.22
+-03-24; "BVR 01-200020-9 Aargauische Kantonalbank Aarau SENDER REFERENCE: comm-c-170-309-7 ";;-145.35;2020-03-24;118537. 22
+-03-24; "BASIC CH-DD WITHDRAWAL ORDER ID OF PAYING PARTY: 41000000000000321 REFERENCE NO.: 2020-03-23-800000000123-000123 PAYING PARTY: PostFinance, Kreditkarten COMMUNICATIONS: INVOICE DUE 27.02.2020 ACCOUNT NO. 0000 0000 0000 1234 TRANSACTION ID: 200-12345678";;-576.40;2020-03-24;
+-03-18; "ACHAT/SERVICE DU 18.03.2020 CARTE NO XXXX1234 POSTE CH SA (1029) CHÊNE-BOURG ";;-5.50;2020-03-18;119948. 72
+-03-11; "GIRO INTERNATIONAL (SEPA) EUR 139.30 AU COURS DE 1.0733 BANQUE POPULAIRE DU SUD 38 BOULEVARD GEORGES CLEMENCEAU 66966 PERPIGNAN FR7616607002080944858901884 SARL PRODSTAR 1 BOULEVARD ST MARTIN 47000 TOURS ";;-149. 51;2020-03-11;125474.47
+-03-09; "GROUP CREDIT BVR PROCESSED ON 09.03.2020 CUSTOMER NUMBER 01-010101-7 PACKET ID: 200309CH00000000";4504.80;;2020-03-10;125817.83
+-03-05; "BANK TRANSFER ORDERING PARTY: Swisscom (Schweiz) AG Alte Tiefenaustrasse 6 3048 Worblaufen COMMUNICATIONS: RG.02 /2020 OF 29.02.2020RG .02/2020 OF 29.02.2020 REFERENCES: 0026046247 ICWV200304C88155 200305CH05ATGBXH";3663.50;;2020-03-05;121313.03
+Disclaimer:
+This is not a document created by PostFinance Ltd. PostFinance SA cannot be held responsible for its content.
+</code>
+The program will process all lines whose first column is a valid date.
 </panel>
 <panel title="Société Générale">
@@ Ligne 291: / Ligne 451: @@
 In this example, account assignment 2 would correspond to ‘Taxes’, account assignment 3 to ‘Donations to charities’, and account assignment 9 to ‘Miscellaneous swindles’, account assignment 5 to ‘Professional income’, while the URSSAF account assignment would appear in the account assignment labels with ID 8.
 </panel>
-<panel title="Banque de La Réunion">
-See Caisse d'Épargne, it's the same format.
-</panel>
 </accordion>
@@ Ligne 316: / Ligne 474: @@
 {{:wiki:tags:voir_aussi.gif?nolink |}}**Other ‘Extensions’ articles**
-[[en:wiki:admin:extensions|How to install an extension]]
 <nspages en:addons -nbCol=2 -textPages="" -h1 -r -simpleLineBreak >