31,029
edits
Foundation Administrator Tasks: Difference between revisions
→Generate documents for book keeper
| Line 30: | Line 30: | ||
Once a quarter, we must send to Dolibarr foundation book keeper, documents to make accountancy. For this: | Once a quarter, we must send to Dolibarr foundation book keeper, documents to make accountancy. For this: | ||
Run script rebuild_merge_pdf to create a PDF with all customer invoices with payments during the quarter on each bank account: | 1) Run script rebuild_merge_pdf to create a PDF with all customer invoices (subscriptions) with payments during the quarter, on each bank account: | ||
<source lang="bash"> | <source lang="bash"> | ||
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 CEP filter=excludethirdparties 962 lang=fr_FR regenerate=crabe | ||
| Line 39: | Line 39: | ||
'''/compta/Cotisations directes''' | '''/compta/Cotisations directes''' | ||
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 | |||
<source lang="bash"> | <source lang="bash"> | ||
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 CEP filter=onlythirdparties 962 lang=fr_FR regenerate=crabe | ||
| Line 47: | Line 48: | ||
'''/compta/Ventes Dolistore directes''' | '''/compta/Ventes Dolistore directes''' | ||
And to get | 3) And to get invoices for subscriptions done onto paypal: | ||
<source lang="bash"> | <source lang="bash"> | ||
scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Paypal filter=excludethirdparties 50 lang=fr_FR regenerate=crabe | scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Paypal filter=excludethirdparties 50 lang=fr_FR regenerate=crabe | ||
| Line 55: | Line 56: | ||
'''/compta/Cotisations via Paypal''' | '''/compta/Cotisations via Paypal''' | ||
Run export of bank receipt for month of quarter on each bank account | 4) Run export of bank receipt for month of quarter on each bank account | ||
<source lang="bash"> | <source lang="bash"> | ||
scripts/bank/export-bank-receipts.php CEP 201301 excel2007 lang=fr_FR | scripts/bank/export-bank-receipts.php CEP 201301 excel2007 lang=fr_FR | ||
| Line 71: | Line 72: | ||
'''/compta/Relevés bancaires''' | '''/compta/Relevés bancaires''' | ||
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. | |||
= Assistance Dolistore = | = Assistance Dolistore = | ||