FrontAccounting forum — bank import module

Re: bank import module

2021-08-25T00:31:11Z

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.

Re: bank import module

2015-03-09T06:01:19Z

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

Re: bank import module

2014-11-06T14:04:43Z

David, do you have some feedback ?

Re: bank import module

2014-11-01T10:00:05Z

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

2014-11-01T05:53:15Z

great!

Re: bank import module

2014-10-31T20:18:29Z

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

Re: bank import module

2014-10-31T07:50:10Z

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

2014-10-12T11:33:33Z

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

2014-10-07T15:26:35Z

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

2014-10-06T21:24:18Z

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

2014-10-06T19:11:31Z

man, sorry, I do not get your point.

Re: bank import module

2014-10-06T19:07:29Z

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

Re: bank import module

2014-10-06T18:38:44Z

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

Re: bank import module

2014-10-06T18:30:11Z

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

bank import module

2014-10-05T21:03:11Z

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