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

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

Re: bank import module

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

Re: bank import module

apmuthu wrote:

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

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

Re: bank import module

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

Re: bank import module

man, sorry, I do not get your point.

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.

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.

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.

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

Re: bank import module

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

Re: bank import module

great!

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!

Re: bank import module

David, do you have some feedback ?

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.