1 Topic by serbanc (edited by serbanc 10/05/2014 09:03:33 pm)

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Topic: bank import module

i have created a module to import/process bank statements.
the module is in alpha stage, do not use in production!

the module has two parts:
- a bank file statement parser
- the interface to import/process bank transactions

The Parser
- based on MT940 format
- able to import CSV files as well
- developed in ROmania - the files are specific to Romanian banks (one with MT940 format, one with CSV format)

The interface
- match bank transactions to FA transactions

Next steps
- develop some documentation
- ability to identify transactions and propose an action
- ability to auto-identify customers, suppliers, quick entries etc.


Any feedback is welcomed!
on github

serbanc's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank import module

That's great! See if you can extend it to importing customers as well or make another one for it.

apmuthu's Website

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

what do you mean by "importing customers" ? it is related to this module ?

serbanc's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank import module

The only relation to this module will be the CSV parser. You can refer this post for the SQLs involved.

apmuthu's Website

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

man, sorry, I do not get your point.

serbanc's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank import module

Just like importing bank statements into FA, we also need to import customers into FA. Since both can benefit from a common CSV parsing routine based on different templates, it would also be a nice addition or as a separate extension that partakes of this code.

apmuthu's Website

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

got your point.
The import and conversion from CSV to a unified format (close to MT940) works ok. I will put some test files on github.

What would be interesting to validate are the interpretation of transactions and their correct registration into FA.

serbanc's Website

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

updated code.

- a form to manage IBAN(S) for customers/suppliers
- based on the above data, if transaction's account is known, the customer/supplier is proposed (pre-selected)
- a sample MT940 file (anonymized data) is provided.

serbanc's Website

  • Registered: 09/30/2014
  • Posts: 7

Re: bank import module

Hi Serbanc,
Tx for the module. Do you have any example of csv file that would work with your csv parser ?
Tx

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

allow me some time to anonymize a file. I will upload the file on github repo

serbanc's Website

  • Registered: 09/30/2014
  • Posts: 7

Re: bank import module

great!

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

updated readme
added an anonymized CSV file for RO_BCR_parser. please note that start/end balances might not match due to removal of transactions!!

enjoy!

serbanc's Website

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: bank import module

David, do you have some feedback ?

serbanc's Website

  • Registered: 03/09/2015
  • Posts: 3

Re: bank import module

Share some feedback so we can be able to create the same and see how it really work son our end.

15 Reply by lawmaina78 (edited by lawmaina78 08/25/2021 11:06:44 pm)

  • From: Tanzania, Arusha
  • Registered: 04/27/2012
  • Posts: 34

Re: bank import module

Please share sample working CSV file accepted, I have tried various but are all failing.
I even tried uploading the provided CSV file but it failed.