Différences

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

--- en:addons:cyberbanque [2025/07/17 13:57] – [Modifier - Panel] ics02
+++ en:addons:cyberbanque [2025/08/19 10: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="Crédit Mutuel">
@@ Ligne 373: / 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 398: / 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 >