On 18/05/17 16:36, Reinhard Müller wrote:

Hi, Daniel!

Am 2017-05-18 um 16:25 schrieb Daniel Pocock:

...

Which accounting software is currently used by FSFE?

FSFE currently uses plain CSV files which are to a very large extent automatically filled from various sources like electronic bank account statements, reports from our credit card payment provider, and so on. All of that is very individually tailored to FSFE's needs.

At the end of the year, our tax consultant distills the legally required reports from these CSV files.

Has FSFE developed any scripts that are used for:

- fetching data from public sites (like the bank)

- transforming/normalizing the data

- producing the reports (e.g. balance sheet) from time to time?

and could they be shared?

I wonder if people could use the CSV files to automatically populate databases for the various free software solutions[1] and see them side by side.

Are there any other free software tools used in the process, e.g. the Firefox plugin ExportToCSV[2]?

Regards,

Daniel

1. https://danielpocock.com/comparison-of-free-open-source-accounting-software 2. https://addons.mozilla.org/en-US/firefox/addon/export-to-csv/

Hi, Daniel!

Am 2017-05-18 um 16:42 schrieb Daniel Pocock:

Has FSFE developed any scripts that are used for:

• fetching data from public sites (like the bank)

We use aqbanking-cli for fetching data from the bank. All other sources are manual download from their web interfaces.

• transforming/normalizing the data

That's very specialized scripts that consist mostly of attempts to interpret the transaction text, like:

if transaction text begins with "FC" then transaction type = "fellowship contribution" elsif transaction text beings with "MP" then transaction type = "merchandise purchase" ....

• producing the reports (e.g. balance sheet) from time to time?

We do this in LibreOffice using the function "data pilot".

and could they be shared?

All of the scripts used are so completely specific to FSFE's kinds of transactions and internal numbering schemes we have that they can hardly be reused by anybody. Still, if someone is interested just to learn from it and see how we do things, just let me know.

Are there any other free software tools used in the process, e.g. the Firefox plugin ExportToCSV[2]?

No, all we use is aqbanking-cli, LibreOffice, and these specialized Python scripts.

Thanks,

Le 18/05/2017 à 22:28, Nikos Roussos a écrit :

...

There is currently some discussion about choosing something for the Open Labs hackerspace in Tirana

I saw Gnucash was mentioned in that discussion. There is a django-based web frontend that in theory can make it multiuser, but I've never tried it. https://github.com/nylen/gnucash-django/

~nikos

Hello, what about that : open concerto https://www.openconcerto.org/fr/index.html

Sorry the page is in french only for the moment, but it's a real nice alternative to dolibarr (http://dolibarr.org) when it comes to accounting

What's your opinion about this project

?

Michel Roche