Skip to content

Country wise Chart of Accounts

nabinhait edited this page Dec 15, 2014 · 24 revisions

The country-wise chart-of-accounts are bootstrapped from a popular open source erp odoo (formerly epenerp). In odoo, the charts were in xml or csv file format. But the major problem was, the charts were not visible in tree structure. We have converted them into json format, for better readability and to view them in tree structure.

File Location

https://github.com/frappe/erpnext/tree/v5.0/erpnext/accounts/doctype/account/chart_of_accounts/

JSON File Structure

{
    "country_code": "in",
    "name": "Indian Chart of Accounts",
	"is_active": "Yes",
    "tree": {
        "Assets": {
            "Current Assets": {
                "Accounts Receivable": {
                    "Debtors": {
                        "account_type": "Receivable"
                    }
                },
                "Inventories": {
	                "account_type": "Stock",
				},
                "Cash In Hand": {
                    "Cash Account": {
                        "account_type": "Cash"
                    }
                },
				"Bank Accounts": {},
            },
			"root_type": "Asset"
        },
        "Liabilities": {
            "Current Liabilities": {
                "Accounts Payable": {
                    "Creditors": {
                        "account_type": "Payable"
                    }
                }
			},
			"root_type": "Liability"
        },
        "Expense": {
            "Cost of Goods Sold": {
                "account_type": "Cost of Goods Sold"
            }
			"root_type": "Expense"
        },
        "Income": {
			"root_type": "Income"
        }
    }
}

After getting the tree, the major hurdle was to assign different properties (like root_type, account_type, group_or_ledger etc) for those accounts. The file contents are in the local language of that country. We have tried our best to read those using translate.google.com and assign multiple properties. We have finalized charts for some countries, but still there are many pending charts to finalize.

Hence, we decided to hand-over the task to the communities. Actually we realized that it is the perfect way of working for such cases. You have better knowledge for your country-specific charts and proficiency in your native language.

Guidelines for contribution:

Please go to the above link and find the file for your country's chart of accounts. You can help us to assign diffrent kind of properties for the accounts.

  1. If you are a developer, you can directly make the changes in json and send pull request.
  2. If you are non-developer, you can mail us at developers@erpnext.com the changes in below format: "account_name": { "property_1": "value1", "property_2": "value2" }

Properties

  1. root_type: Asset, Liability, Expense, Income, Equity

    It is applicable only for root account groups and is mandatory for all roots.

  2. 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 assgned as "Stock"

  3. group_or_ledger: Group, Ledger Used to identify a ccount 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.

Clone this wiki locally