Module Double Entry Accounting

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

Return to user
documentation index

File Doc user.png

Return to
list of modules index

Art.png

Accountancy
Numéro/ID du module 50400
Doc utilisateur du module This page
Doc développeur du module Module Double Entry Accounting (developer)

Introduction

The Accounting Advanced module provide double entry accounting features.

Installation

This module is included with the Dolibarr distribution, so there is no need to install it.

Setup

To use this module, you must first enable it using an administrator account, via the menu option "Home - Setup - Modules".

Choose the tab where the module is listed. Then click on "Activate".

The module is now activated.

If an icon appears at end of the line for the module, click on it to access the setup page specific to the module.

Life cycle / Business rules

Usage of the accountancy module is done in several step:


The following actions are usually executed one time only, or once per year...

  • STEP 1: Create a model of chart of account from menu Financial-Accountancy-Setup-Chart of accounts models
  • STEP 2: Create or check content of your chart of account from menu Financial-Accountancy-Setup-Chart of accounts

Next steps should be done to save you time in future by suggesting you the correct default accounting account when making thee journalization (writing record in Journals and General ledger)

  • STEP 3: Check the default binding between miscellaneous transaction lines and accounting account is done. Complete missing bindings. For this you can use the menu entry Financial-Accountancy-Setup-Default accounts.
  • STEP 4: Check the binding between vat rates and accounting account is done. Complete missing bindings. You can set accounting accounts to use for each VAT from page Financial-Accountancy-Setup-Vat accounts.
  • STEP 5: Check the binding between special expences (miscellaneous taxes) and accounting account is done. Complete missing bindings. For this you can use the menu entry Financial-Accountancy-Setup-Tax accounts.
  • STEP 6: Check the binding between type of expense report and accounting account is done. Complete missing bindings. You can set accounting accounts to use for each VAT from page Financial-Accountancy-Setup-Expense report accounts.
  • STEP 7: Check the binding between loans payment and accounting account is done. Complete missing bindings. For this you can use the menu entry Financial-Special expenses-Loans or Financial-Accountancy-Setup-Default accounts.
  • STEP 8: Check the binding between bank accounts and accounting account is done. Complete missing bindings. For this, go on the card of each financial account. You can start from page Home-Bank/Cash.
  • STEP 9: Check the binding between products/services and accounting account is done. Complete missing bindings. For this you can use the menu entry Financial-Accountancy-Setup-Products accounts.


The following actions are usually executed every month, week or day for very large companies...

  • STEP 1: Check the binding between existing customer invoice lines and accounting account is done, so application will be able to journalize transactions in General Ledger in one click. Complete missing bindings. For this you can use the menu entry Financial-Accountancy-Customer invoice binding.
  • STEP 2: Check the binding between existing supplier invoice lines and accounting account is done, so application will be able to journalize transactions in General Ledger in one click. Complete missing bindings. For this you can use the menu entry Financial-Accountancy-Supplier invoice binding.
  • STEP 3: Check the binding between type of expense report and accounting account is done. Complete missing bindings. You can set accounting accounts to use for each VAT from page Financial-Accountancy-Expense report binding.
  • STEP 4: Write transactions into the General Ledger. For this, go into each Journal, and click into button "Journalize transactions in General Ledger".
  • STEP 5: Add or edit existing transactions and generate reports and exports.

Exports

These are examples of available export formats. Export can be done from the General Ledger:

Export Standard (valable pour Cador)

2012016	gérance janvier 2016 (SI1601-0668)	40100000	FGEFFROY	0	1000	ACH
2012016	gérance janvier 2016 (SI1601-0668)	64400000	1000	0	ACH

Export Cegid

2012016	ACH	40100000	FGEFFROY	C	1000	GEFFROY OLIVIER - gérance janvier 2016 - Tiers	gérance janvier 2016 (SI1601-0668)
2012016	ACH	64400000	D	1000	GEFFROY OLIVIER - gérance janvier 2016 - Gerance	gérance janvier 2016 (SI1601-0668)

Export Sage Coala

02/01/2016	ACH	40100000	1	gérance janvier 2016 (SI1601-0668)	0	1000	E	FGEFFROY
02/01/2016	ACH	64400000	1	gérance janvier 2016 (SI1601-0668)	1000	0	E	

Export Sage Bob 50 (To be tested)

1	02/01/2016	F	FGEFFROY	0	1000	GEFFROY OLIVIER - gérance janvie...
1	02/01/2016	G	64400000	1000	0	GEFFROY OLIVIER - gérance janvie...

Export ciel compta (To be tested) format txt

1    ACH06022017020120161           FGEFFROY   gérance janvier 2016 (SI1         1000C                  GEFFROY OLIVIER - gérance janvier O2003
2    ACH06022017020120161           64400000   gérance janvier 2016 (SI1         1000D                  GEFFROY OLIVIER - gérance janvier O2003

Export quadratus format txt

MFGEFFROYAC00006022017 gérance janvier 2016C+000000001000        000000     1                        1       EURACH   gérance janvier 2016 (SI1601-0661                                                                                  
M64400000AC00006022017 gérance janvier 2016D+000000001000        000000     1                        1       EURACH   gérance janvier 2016 (SI1601-0661                                                                                  

Export EBP

10803	2012016	ACH	40100000	40	GEFFROY OLIVIER - gérance janvier 2016 -	1	1000	C	2012016	EUR
10804	2012016	ACH	64400000	64	GEFFROY OLIVIER - gérance janvier 2016 -	1	1000	D	2012016	EUR

Export Cogilog (To be tested)

ACH	2012016	1	40100000	GEFFROY OLIVIER - gérance janvier 2016 - Tiers	2012016	1000	gérance janvier 2016 (SI1601-0668)	GEFFROY OLIVIER - gérance janvier 2016 - Tiers
ACH	2012016	1	64400000	GEFFROY OLIVIER - gérance janvier 2016 - Gerance	2012016	1000	gérance janvier 2016 (SI1601-0668)	GEFFROY OLIVIER - gérance janvier 2016 - Gerance