Foundation Administrator Tasks

Back to home page of
the Dolibarr foundation

Retour page accueil
association Dolibarr

Goal of this page is to describe different tasks the foundation administrator must work on.

Web site or Social networks

Post news frequently

When: When a topic to post a news come. Good frequency is at least one post per week. How:

• When a news is possible, post a news onto dolibarr.org and dolibarr.fr by creating a new article into joomla admin console of portals -> This will post also news onto social networks with hootsuite scheduler.

Example of major news:

- new stable version of dolibarr.

- happy new years.

- summary of major event.

• Or for minor information, just post directly news/link/image onto hootsuite to push it on social networks.

Example of minor news:

- new version of a module

- stats

- article found into press

Add new surveys

When: When a new idea of survey is found (Maximum, once a month)

Add a new survey into Joomla backoffice and post a news onto communication networks (social networks, mailing-list) to invite to vote.

Accountancy

Each quarter, the foundation must provide information for book keeper. This is how to find/generate such documents.

Conciliation

When: Once a month

Conciliate into Dolibarr at end of month bank account. For this:

• You can use scan of bank receipts and export of Paypal transactions.
• Create an invoice at end of each month to enter amount earned from dolistore onto CEP using generic customer "Client DoliStore CEP".

Generate documents for book keeper

When: Once a quarter, we must send to Dolibarr foundation book keeper, documents to make accountancy. For this:

1) Run script rebuild_merge_pdf to create a PDF with all customer invoices (subscriptions) with payments during the quarter, on each bank account:

cd /home/dolibarr/asso.dolibarr.org/dolibarr
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=excludethirdparties 962 lang=fr_FR regenerate=crabe
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=excludethirdparties 962 lang=fr_FR regenerate=crabe

Rename all generated files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) to replace "merged_payments_" with "Cotisations_"

Save all generated PDF (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) into directory

/compta/Cotisations CEP directement

2) Run script rebuild_merge_pdf to create PDF with customer invoices for generic Dolistore client, with payment during the quarter, on each bank account

cd /home/dolibarr/asso.dolibarr.org/dolibarr
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=onlythirdparties 962 lang=fr_FR regenerate=crabe
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=onlythirdparties 962 lang=fr_FR regenerate=crabe

Rename all generated files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) to replace "merged_payments_" with "Ventes Dolistore via CEP_"

Save all generated PDF into directory

/compta/Ventes Dolistore CEP directement

3) And to get invoices for subscriptions done onto paypal:

cd /home/dolibarr/asso.dolibarr.org/dolibarr
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Paypal filter=excludethirdparties 50 lang=fr_FR regenerate=crabe

Rename all generated files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) to replace "merged_payments_" with "Cotisations_"

Save all generated PDF (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) into directory

/compta/Cotisations via Paypal

4) Run export of bank receipt for month of quarter on each bank account

cd /home/dolibarr/asso.dolibarr.org/dolibarr
scripts/bank/export-bank-receipts.php CEP 201301 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEP 201302 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEP 201303 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201301 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201302 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201303 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php Caisse 201301 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php Caisse 201302 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php Caisse 201303 excel2007 lang=fr_FR

Save all generated Excel files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/bank/temp) into directory

/compta/Relevés bancaires

Note: Receipt for Paypal account is not provided to book keeper.

5) Then open each files (one file per month), and for each line with

> Transfert vers CEP

replace line with

> Transfert vers CEP (Cotisations X + Ventes Y)

X is sum of all subscriptions found for month, onto PDF generated at step 3, Y is (amount of line - X).

6) Go into GED module of dolibarr, section supplier invoices. Sort on date. Then download each file and save it into directory.

/compta/Factures fournisseurs (si obtenues)

7) Once all of this is done, copy directory /compta into a USB drive or create a zip file to send it by email to the foundation book keeper (email address is available into the gmail contact account of the foundation).

Support for Dolistore

When: Once every two days

Read frequently mailbox "DoliStore - Asssitance à traiter"

If a member ask the dolistore 20% discount

• First check user is a valid member (subscription is up to date)
  • If no ask user information about its last subscription to be sure.
  • If yes, go onto dolistore.com backoffice and check member as an account.
    • If no, ask him to create a dolistore account first
    • If yes, edit its account and add "Foundation Members" to its groups, and modify default group to "Foundation Members"

If a customer has a not valid link

When: When a buyer has paid a module but link he received did not works:

• Go onto Dolistore admin - Orders - and read state of order.
  • If status is "payment accepted", send customer the file.
  • If status is "payment accepted":
    • If confirm email was received by customer or if paypal account payment was recorded into paypal dashboard, modify status into dolistore to "Payment accepted".
    • If not, answer to ask customer the paypal payment email that confirm transaction. Do previous point, once received.

If a paypal dispute email was received

Just read dispute and try to find a solution.

Other email

Keep them into the inbox. A member of the foundation office will process them.

Note: Once processed, EMails found into "DoliStore - Assistance à traiter" must be moved to "Dolistore - Assistance traitées"

Validate new uploaded modules

When: When a new module is published

• Go onto Dolistore admin, and if there is new submitted modules, check everything is ok with new submissions
  • If yes, validate new module
  • If no, send an email to submitter to ask him to fix his submission.

Manage Preferred Partner program

When: When a request to be a preferred partner is received

When a request to be a preferred partner is received,

- if request is for a spain or latino america, transfer email to 2byte.

- if request is for another country, check that prerequisites are filled and document is provided. Ask it if not. If document is ok, send an email to foundation board to ask them to vote yes or no. If vote is no, answer requester and tell him why. If vote is yes, update wiki pages to add new partner, update member card into the Dolibarr foundation to classify requester into category "Preferred Partner" -> This add automatically member to the preferred partner mailing-list.

When: When a preferred partner is no more a partner

Update the Dolibarr foundation to remove the category "Preferred Partner" of member.

Promos Dolistore

When: Once a month

Once a month, choose a product with editor allow to make a 50% promotion. Setup Dolistore to add promotion and post a news onto facebook - twitter - mailing list foundation.

Support on Wiki

Create accounts

When: When a email is received to create an account

When such an email is received into the foundation mailbox, admin guy must:

• create account onto wiki
• answer the requester with the credentials of created account
• Email must then be moved into Imap directory "Support".

Adding URL to pages

When: When a email is received to be included into partner/user list.

There is some page to list companies that use Dolibarr or provide support on it (For example all subpages of page List of Dolibarr partners and providers. Visitor can add their record themself, except for their URLs because of antispam system (only white-list URLs are allowed). If a visitor send a mail to ask to add its URL, this is what to do:

• Go into the whitelist page: http://wiki.dolibarr.org/index.php/MediaWiki:Spam-whitelist
• Edit the page to add URL (using regexp syntax).
• Answer EMail to tell user he can now add its URL into its card.

Specific development

When: When we can enhance this.

This is specific works. For example:

• dolibarr fix bugs or tasks
• enhancements into dolistore module

Specific task

When: When required by the foundation.

This is example of specific works. For example:

• upgrade of software tools (joomla, mediawiki, tuleap, ...)

Admin Proxmox

• To create a new VM, click on create CT and choose image *.tar.tgz into

/var/lib/vz/template/cache

• To restore a VM after a corruption of server, ...

Annexe

How cost a salary ? This is some answer provided by another french foundation:

On compte en ratio "coût salarial" / "salaire net" de 1,9. Donc pour 100€ perçu par le salarié, l'employeur paye environ 190€, la différence allant dans les caisses de cotisation (retraite, chômage, DIF, etc.) + CSG et consorts.

Le salaire net est environ 77% du salaire brut. Le brut est environ 130% le salaire net.

Ces estimées sont valables pour un salaire net pas trop faible, ni trop élevé. En effet, si le salaire est inférieur à 1,6 SMIC, la réduction Fillon est applicable, et tu payes moins de cotisations (28,1 % d'allègement de cotisation dites patronales pour un salarié au SMIC, 0% pour un salaire à 1,6 SMIC, et une décroissance linéaire entre les deux). Si le salaire dépasse certains plafonds fixé par la sécu, une tranche "B" (puis deux "B" et "C") de cotisation supplémentaire sont applicables (premier plafond : 37 548 € de salaire brut, second plafond à 4x ça). Aussi, pour les cadres, la principale différence (pour un salarié en tranche A) est le paiement de la CET, qui supposent 0.35% de cotisations en plus.

Dans les coûts annexes à prévoir en plus du salaire :

• la taxe sur les salaires, si vous ne faites pas la récupération de la TVA (de l'ordre de 1k€ par salarié) ;
• la gestion de la paye (l'association PPSJ fait ça pour quelques centaines d'euros par an). Rem: Plus simple encore, le service chèque emploi association www.cea.urssaf. fr/ceawebinfo/cms/index.html
• les visites médicales (un billet de 130€ à chaque visite) ;
• les avantages en nature (ticket resto, etc.).