ERPNext FinTS Connector (German Banks)

Community German Community
,
12

Hi,

thank you for sharing this progress. Volksbank and Kreissparkasse are the main two banks we are looking for at the moment.

Where would this thing go into core? I think this should go some where around “desk#modules/Integrations”.

Please let @Basawaraj_Savalagi know what you need to make this core ready.

As we are looking for KSK Integration for ourselves this would be very interesting for us and also connected to a bounty.

1 Like
13
  • Volksbank and Kreissparkasse are working in my lab. Unfortunately not without quirks but I’m excited what will result from this: PSD2 support by raphaelm · Pull Request #95 · raphaelm/python-fints · GitHub
  • I would suggest so. I think the plaid integration would function as a reference implementation. In regards to plaid integration I do not understand why it relies on the bank reconciliation functionality. Maybe someone can elaborate the benefit compared to importing payment entries
  • I’m still new to the ERPNext cosmos / Open Source collab. / git , maybe @Basawaraj_Savalagi can tell me what would be required to get core ready or what would the ERPNext Community need to adapt my app into the core

My code already starts hassling me and I’m about to rewrite certain parts. I think I could do better and improve it with my current python / javascript knowledge. I started the project as a newbie.

My self-imposed roadmap would look as following:

  • Watch and be support the FinTS Library progress
  • Complete the “Bank Account Wizard” page
  • Rewrite/Improve Code
  • Integrate unit-tests and maybe cypress-tests (personal studies required)

I’m working on this on my free time so I’m not able to propose a schedule, pardon me :slight_smile:

1 Like
14

Hi!
great work.
like wojosc, i would like the KSK integration too. In fact we planed to do an integration by ourselves, but had no time to do this yet.
If it helps, I would be in for a bounty, too.

15

I did some testing with the proposed PSD2 testing-script from the FinTS Library which worked for both VoBa and KSK after removing the if f.init_tan_response: part. Cross checking my code lead me to an unnecessary line.

My develop branch should work now for both banks. If someone is will to test please make sure to uninstall fints first with env/bin/pip uninstall fints from the virtualenv.
Check the link for the explantation:
https://github.com/jHetzer/erpnextfints/commit/5929e5e770a5b3d4ec6a26398b1e52bf8d817c14#commitcomment-36295468

16

Thanks! I will try that asap!

@joelios I’ll put this on the list. @jHetzer do you support installions too?

17

Happy to hear that. I would recommend you to use the develop branch with new improvements:

Depends on what you mean

18

Bank Account Wizard

19

I mean, do you help integrating the app and take a moment to introduce so we are able to use it and look out for things not to do.

We are happy to compensate on the matter.

20

Sure, i will pm you

21

@jHetzer Thank your for your visit in our offices today. Heiko and I where impressed by the maturity of your app. It pretty much does what we need.

@itsdave I am looking to have this implemented in our system tomorrow. I am happy to give you a demo once it’s working.

Please direct your bounty towards @jHetzer

@Basawaraj_Savalagi You should definatelly have a look at this app and we should think about how and where to implement it into core. I think Bank Reconciliation might be doubled here. Also to you, I’ll do a specific demo as the hbci protocoll used for the german banks is something unique to Germany.

@Mario_Truss @Martin_Seibert @dominik is this something you have worked on/solved already?

You all have a nice weekend.

3 Likes
22

Nope. Did not tackle this yet.

23

I’d love to see how the whole thing looks in your system, now. Do you think we could schedule a call to give me short presentation?

24

Sure, once we have it I will let you know (we are waiting for the HBCI credentials from our bank at the moment).

Best
Wolfram

25

Hi, did you get the app working?
Is it possible to use it in production environment?
I want to use it with Volksbank.

26

Hello, would also like to know about the project. Thanks.

27

Hell @mkautenburger @Balacc sorry for not letting you know any earlier. We are using the App in v12 and it works fine. Once you have trained the system by mathing IBANs to customers your good to go and only need to touch payments that aren’t 100% clear.

To make it work you might have to unlock the feature in your online-banking and register for credentials with your bank.

28

Thanks wojosc for your reply. When we tried to call the bank statement, we get only a JSON file attached, how to proceed from this point?

29

Import transactions:

grafik
grafik1288×580 36.6 KB

then run wizard:
grafik

1 Like
30

Hey @Snogha

did you define a default customer and supplier in “FinTS Login” and also checked the “activate” tick for the type of payments you want to import?
After that you should be able to import the payments (Credit = customer / Debit = Supplier). Once you changed the customer/supplier for a payment entry you can use the “Bank Account Wizard” to match IBAN’s to a customer/supplier. The next import (e.g. via “FinTS Schedule”) will then auto assign payments to the matching party.

1 Like
31

I use my app for quite some time (also Volksbank). Till now there were no major issues. It might be required to login into your bank account periodically so a TAN is not required (PSD2) to fetch the payment.
Implementing a viable process for handling TAN’s is unfortunately not an easy task.

PR’s into “develop” are always welcome.

1 Like