Line 3:
Line 3:
Links below will be automatically replicated on translated pages by PolyglotBot -->
Links below will be automatically replicated on translated pages by PolyglotBot -->
[[fr:Module_Comptabilité_en_Partie_Double]]
[[fr:Module_Comptabilité_en_Partie_Double]]
+
[[ja:JA_Module_Double_Entry_Accounting]]
<!-- END interlang links -->
<!-- END interlang links -->
Line 14:
Line 15:
userdoc=This page|}}
userdoc=This page|}}
−
= Introduction =
+
=Introduction=
−
The Accounting Advanced module provide double entry accounting features.
+
The Accounting Advanced module provide double entry accounting features. If you don't need double entry accounting neither editing a ledger, you may use the [[Module Accounting Simplified]] instead.
Its features are:
Its features are:
−
* support for double entry accounting
+
−
* grouping transactions in journals
+
*support for double entry accounting
−
* support for exports (a lot of common software format are supported, and also CSV and FEC format)
+
*grouping transactions in journals
+
*support for exports (a lot of common software format are supported, and also CSV and FEC format)
Dolibarr provides ready-to-use chart of account for several countries:
Dolibarr provides ready-to-use chart of account for several countries:
−
* Africa (Benin, Burkina Faso, Cameroon, Central African Republic, Comoros, Congo (Brazzaville), Congo (Kinshasa), Equatorial Guinea, Ghana, Marocco, Niger, Senegal, Tunisia)
−
* Europe (Belgium, Denmark, Luxembourg, France, Germany, Great Britain, Netherlands, Romania, Switzerland, Spain, Sweden
−
* South America (Chile)
−
* And more... ([https://github.com/Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/data/llx_accounting_abc.sql see full list])
−
= Installation =
+
*Africa (Benin, Burkina Faso, Cameroon, Central African Republic, Comoros, Congo (Brazzaville), Congo (Kinshasa), Equatorial Guinea, Ghana, Marocco, Niger, Senegal, Tunisia)
+
*Europe (Belgium, Denmark, Luxembourg, France, Germany, Great Britain, Netherlands, Romania, Switzerland, Spain, Sweden
+
*South America (Chile)
+
*And more... ([https://github.com/Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/data/llx_accounting_abc.sql see full list])
+
+
=Installation=
{{NoInstallModuleEn}}
{{NoInstallModuleEn}}
−
= Setup =
+
=Setup=
{{ActivationModuleEn}}
{{ActivationModuleEn}}
−
== Default accounts ==
+
==GENERAL==
+
+
+
This module's general configuration page allows you to :
+
<br />
+
+
===Adjust global options===
+
[[File:Global options.png|frameless|1250x1250px]]
+
+
===Adjust binding options===
+
[[File:Binding options.png|frameless|1254x1254px]]<br />
+
+
===Activate the accounting lettering function===
+
Lettering allows you to associate entries from the same account. In dolibarr, lettering can be used for customer or supplier account only.
+
+
For v2 lettering (as it's known internally), it currently only works on sub-ledger accounts. It is planned to work on an evolution (lettering v3) to take over G/L account lettering on the accounts you define.
+
+
Lettering V2 feature requires version 17.0.3 of Dolibarr to activate lettering :
+
[[File:Lettering_activation.png|alt=|left|frameless|600x600px]]
+
<br />
+
==Default accounts==
After setting up your chart of accounts you have to tell Dolibarr to use them.
After setting up your chart of accounts you have to tell Dolibarr to use them.
Line 41:
Line 64:
[[File:Accountancy-defaultaccounts.png|800px]]
[[File:Accountancy-defaultaccounts.png|800px]]
−
== Journals ==
+
==Journals==
Set up your custom journals. Here is an example including a special journal for Upwork "bank" account, taxes and an equity insert/take out.
Set up your custom journals. Here is an example including a special journal for Upwork "bank" account, taxes and an equity insert/take out.
[[File:Accountancy-journals.png|800px]]
[[File:Accountancy-journals.png|800px]]
−
== Vat accounts ==
+
==VAT accounts==
−
Setup the applicable vat rates and accounts for your country.
+
Setup the applicable VAT rates and accounts for your country.
[[File:Vat-accounts.png|800px]]
[[File:Vat-accounts.png|800px]]
−
== Tax accounts ==
+
==Tax accounts==
Setup the account from which you pay your tax.
Setup the account from which you pay your tax.
[[File:Tax-accounts.png|800px]]
[[File:Tax-accounts.png|800px]]
−
== Export options ==
+
==Export options==
Change these if needed.
Change these if needed.
[[File:Accountancy-export.png|800px]]
[[File:Accountancy-export.png|800px]]
−
= Life cycle / Business rules =
+
=Life cycle / Business rules=
Usage of the accountancy module is done in several step:
Usage of the accountancy module is done in several step:
Line 67:
Line 90:
The following actions are usually executed one time only, or once per year...
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 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
+
*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)
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 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 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 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 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 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 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.
+
*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...
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 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 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 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 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.
+
*STEP 5: Add or edit existing transactions and generate reports and exports.
−
= Exports =
+
=Exports=
These are examples of available export formats. Export can be done from the General Ledger:
These are examples of available export formats. Export can be done from the General Ledger:
{{AccountingExpertExportExamples}}
{{AccountingExpertExportExamples}}