FrontAccounting forum — bank import module

Re: bank import module

null@example.com (lawmaina78) — Wed, 25 Aug 2021 00:31:11 +0000

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

null@example.com (daveross) — Mon, 09 Mar 2015 06:01:19 +0000

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

null@example.com (serbanc) — Thu, 06 Nov 2014 14:04:43 +0000

David, do you have some feedback ?

Re: bank import module

null@example.com (serbanc) — Sat, 01 Nov 2014 10:00:05 +0000

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

null@example.com (DavidMaurice) — Sat, 01 Nov 2014 05:53:15 +0000

great!

Re: bank import module

null@example.com (serbanc) — Fri, 31 Oct 2014 20:18:29 +0000

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

Re: bank import module

null@example.com (DavidMaurice) — Fri, 31 Oct 2014 07:50:10 +0000

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

null@example.com (serbanc) — Sun, 12 Oct 2014 11:33:33 +0000

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

null@example.com (serbanc) — Tue, 07 Oct 2014 15:26:35 +0000

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

null@example.com (apmuthu) — Mon, 06 Oct 2014 21:24:18 +0000

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

null@example.com (serbanc) — Mon, 06 Oct 2014 19:11:31 +0000

man, sorry, I do not get your point.

Re: bank import module

null@example.com (apmuthu) — Mon, 06 Oct 2014 19:07:29 +0000

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

Re: bank import module

null@example.com (serbanc) — Mon, 06 Oct 2014 18:38:44 +0000

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

Re: bank import module

null@example.com (apmuthu) — Mon, 06 Oct 2014 18:30:11 +0000

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

bank import module

null@example.com (serbanc) — Sun, 05 Oct 2014 21:03:11 +0000

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