I am based in the US, but I am not an accountant. In the ENG-BASE chart of accounts, there are roughly 345 accounts. That’s way, way, to many. So, I’m wanting to create my own custom chart of accounts, with only the needed accounts present.
Dolibarr 8.0.4
advanced accounting = on
q1) What is the best way to trim down these accounts to only what I need?
q2) Are there any specific accounts required by Dolibarr to function correctly?
q3) If I change the below accounts, will I need to change anything else in Dolibarr?
q4) Also, another question. Can I change the “Group of Account” (pcg_type) to something like below?
These are also my main branches of accounts.
(also, I have attached a .txt file that’s easier to read.)
| fk_pcg_version | pcg_type | account_number | account_parent | |
| - |
| ENG-US-CUSTOM Assets 10000 0 |
| ENG-US-CUSTOM Liabilities 20000 0 |
| ENG-US-CUSTOM Equity 30000 0 |
| ENG-US-CUSTOM Income and Revenue 40000 0 |
| ENG-US-CUSTOM Job Costs or COGS 50000 0 |
| ENG-US-CUSTOM Overhead and Expenses 60000 0 |
| ENG-US-CUSTOM Other Income 70000 0 |
| ENG-US-CUSTOM Other Expenses 80000 0 |
In other words, I would like to change these “Group of Accounts” (pcg_type) from these …
CAPIT | IMMO| STOCK | TIERS | FINAN | CHARGE | PROD
To these …
Assets | Liabilities | Equity | Income and Revenue | Job costs and COGS | Overhead and Expenses | Other Income | Other Expenses
What I want to clarify is the Chart of Accounts you Pre-Built on the system has been built by the Sequence of the System? Or we can modify as such:
xx Assets
xxxxxxx Current Assets
xxxxxxx Other Assets
xx Liabilities
xxxxxx Current Liabilities
xxxxxx Long-Term Liabilities
xx Capital
xxxxx Owner’s Withdrawals
xxxxx Onwer’s Capital
xxxxx Rentained Earnings
xx Revenue
xxxxx Sales from Operation
xxxxx Other Sales
xx Cost of Sales
xxxxx Cost from the Operation
xxxxx Other Cost of Sales
I have noticed the Pre-Built in. Does it mean like this? I am trying to Do my own numbering start from 1000 Assets by it did not take it. It saved 1 Assets Instead of Starting from 1000. Does it had to do with your Programming?
1 CAPIT - Capital?
2 IMMO - Customers/Sales?
3 STOCK - Inventory?
4 TIERS - Suppliers/Purchases?
5 FINAN - Loan/Liabilities?
6 CHARG - Expenses?
7 PROD - Manufacturing?
Is this the Euro/African Standard Chart of Accounts?
in the numbering system, there are reserved numbers already in the system. I noticed I can’t just changed them using the GUI. So, I had to connect to mySQL to make the changes.
On the Chart of Accounts there is a Column called Sub-Group
On Accounting report this has not showing, I believed this is very important to the report since, We can segregate the Accounts as per Sub-Group if someone has Multiple company setup
How to let this Sub-Group to be appearing on the Accounting report?
Here is what I did for India accounts. They follow India Accounting Standards (INDAS).
Check out this link for more info : What is Accounting Standards? - Imprezz
Hello, I am trying to Setup the accounting module as per Indian Standard, http://www.mca.gov.in/MinistryV2/Stand.html - this link is not working for getting the Indlian account standard code, can any one share the list of code which I need to setup for Indian Accountancy.
Also, If any one can help me by step be step configuration , so that I don’t mess any thing and the reports and calculation works properly in Dolibarr System.
When making the file you need some account numbers start with something like one million and increment 1 number at a time, like in this line:
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 71501, 'ENG-BASE', 'CAPIT', '1', '0', 'Equity, provisions for liabilities and charges and liabilities at more than one year', 1);
I am talking about the number 71501 you can start with 1000001