I saw development poll 3 https://erpnext.com/polls/development-poll-3
Create Chart of Accounts for multiple countries got 17 votes.
Are there any plans to do this or was it dropped?
Would this include the possibility to create several charts of accounts for different industry groups where one could select the appropriate chart of accounts at company creation?
What about Excel import/export of chart of accounts?
For now, Chart of Account has been designed based on countries accounting system, and not based on industry. You can post it as feature suggestion on Github.
I have followed your suggestion above on the import/export of Charts of accounts.
I really like your facilities on import/export.
They are very extensive and easy to use.
However I have one question.
When I export the Charts of accounts with data I am wondering if the export is correct?
Numbers in the export have decimal separator . and csv column separator ,
When using Excel it knows the country convention.
Like for most European countries the decimal separator is , and the thousand separator is .
When this is the case the csv column separator becomes ;
With ErpNext working with the application in the browser I chose my country and the decimal separator is handled correctly as ,
But when I export the Charts of accounts the decimal separator is . and csv column separator is ,
It is applicable only for root account groups and is mandatory for all roots.
account_type:: Receivable, Payable, Cost of Goods Sold, Stock, Bank, Cash
It is used to identify the type of a account. For example, the group under which warehouse account will be created, should be assigned as “Stock”
group_or_ledger: Group, Ledger
Used to identify account is a group or ledger (leaf node). Assign Group if there are no child for a account but it’s a group. For example, “Bank Accounts” in the above chart.
Just wonder how you want to link COA into the ERPNext? Can you please describe the concept of how COA list to ERPNext system? How it can benefit the FI module? What I can see is that the COA will be different in different business sector. Unless we create different COA in one country.
Nevertheless, I will update the Malaysia COA. Possible with few business sector.