1. Mailing Lists
  2. Contributors
  3. Re: [26132] Status of the EBICS Integration

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: [26132] Status of the EBICS Integration

Avatar

Re: [26132] Status of the EBICS Integration

by
OpenBig, Thorsten Vocks
- 09/09/2020 13:29:47
Hi Frederik,

currently the easiest way is to my opinion to deal with SEPA flat files. I usually connect via a banking software (in my case it is MoneyMoney), capable to generate a SEPA CAMT.053 .xml file for all financial transactions. Then i use account_bank_statement_import_camt_oca module on the accounting dashboard in order to import all financial transactions of a certain period (day, week, month) from my bank account via the exported flat file. After that i follow up with the default Odoo reconciliation wizard. 

Starmoney Business 8.0 might be another alternative to generate the camt.053 .xml file. Here is an extract from from starmoney business 8.0 manual (in german language):
 
3.16 Daten im camt-Format (UTF-8) (*.xml) exportieren Um Daten aus StarMoney im camt-Format (UTF-8) (*.xml) zu exportieren, verfahren Sie folgendermaßen: 1. Klicken Sie in der Hauptnavigation auf das Menü Verwaltung und wählen Sie den Menüpunkt Datenexport aus. 2. Bestimmen Sie unter Quelle die Option Umsätze. Danach wählen Sie das Konto aus, aus dem Sie die Umsätze exportieren wollen 3. Im Feld Format wählen Sie den Eintrag camt-Format (UTF-8) (*.xml). 4. Klicken Sie anschließend auf [Exportieren] und bestimmen den Speicherort der Datei.

Formerly in 2014 we have realized for Odoo 7.0 in combination with HIBISCUS payment-server a "direct" HBCI integration. I have attached a step-by-step documentation about that implementation based upon the module bank_integration_de_hibiscus. Unfortunately we didn't follow up with further migrations especially to some major changes in Odoo concerning the reconciliation of invoices and payments. Still the Hibiscus payment server approach might be worth to investigate as the flat file import could be avoided. For sure also the direct payment of supplier invoices was more automated as it is currently even with all OCA modules to generate SEPA files on board.

EBICS implementation in Odoo could be a great improvement of the reconciliation process, if it is someday widely supported by german banks. What hibiscus server is currently doing should be integrated into Odoo to avoid another infrastructure setup as described in the attached .pdf file.

Best regards

Thorsten Vocks

openBIG.org
Dipl. Kaufmann (FH)
Porscheweg 4-6
49661 Cloppenburg

Phone: +49 4471 8409000
Fax: +49 4471 84090009
Mail: thorsten.vocks@openbig.org

              


Am Mi., 9. Sept. 2020 um 12:02 Uhr schrieb Frederik Kramer <frederik.kramer@initos.com>:
Dear fellow Odooers, 

being asked by a customer and coming across FinTech and banking again i
stumbled on the EBICS standard and tried to make sense of the current
implementation status in Europe / Germany and the overall
functionality. 

As i have read, French as well as Swiss banks (among the Germans) are
following this bank integration standard and slowley but constantly
replace their older HBCI / FinTS interfaces in favor of EBICS.

However, at least for Germany i found the bank infrastructure quite
underdeveloped. For instance only German DZ-Bank seems to officially
offer a sandbox to test the integration and only to their customers. 

I therefore wonder if there is any partner out there (maybe the folks
at Akretion and Noviat know) that is using the integration with a
German bank (and if so against which test environment has it been
tested)? 

I saw that Zürcher Kantonalbank of Switzerland has a test environment
but obviously doesn't follow the whole standard, so that is not really
useful for the standard case (which should hopefully be applied in
Germany) https://github.com/OCA/bank-payment/issues/465 

As far as i can see the implementation can for now hand in SEPA
mandates to banks, but does it also receive a list of payments for SEPA
as well as NON-SEPA payments from the bank to be reconciled with open
invoices or is that still something that needs to be done manually
(with flat files)?

Thanks for any repsonse in that regards

Cheers Frederik


-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference