Help Needed: Country wise Chart of Accounts

Hello @pagliaso

Hope you are doing fine. Really I need your help to know how you were able to resolve the problem of having creditors and debtors as root account which belongs to assets and liabilities and how you obtained right balance sheet and trial balance?

Also, what you placed the root type of the creditors and debtors root account?

I am facing same problem in Lebanon where the total root accounts are 7 and some root accounts are mix of Liabilities and Assets and another root account is mix of Equity and Liabilities and so on, and I am always think how the balance sheet will appear in this case. Below is the attached of the chart of account in Lebanon:

Hello @nabinhait
What is the right procedure in this chart of account type and what will happen in the balance sheet and trial balance in this case? Please note that this chart of account type is existed in a lot of countries. As you see, the root accounts are mix of different type, also some group accounts are mix of different root type !!

Regards
Bilal

Hello Bilal,

Thanks for your email and very sorry for my slow reply.

I started to write this email and then was very very busy and forgot about it.

I have to confess I don’t remember very well how I did it at the end. I am sending you attached the file that I imported and this is the account tree we have been working with for months, maybe years.

We don’t use ERPNext’s full potential of accounting, but for what we use, that is basically Profit and Losses reports, we have not found any trouble we are aware of.

I am sorry I can not be of much help regarding this, but I hope that the file attached can be of any use to you.

Kind regards from Spain,

Alberto

Hello @pagliaso
Thank you, I resolved my problem :slight_smile:
But tell me: why you do not use ERPNext full potential for accounting, what is the barrier for this?

Regards
Bilal

Hello Bilal,

Thanks for letting me know, and I am glad you were able to do it.

The main problem is lack of time and resources for learning and adjusting the ERP to how we do the things in the company, and over all the “resistance” of the person in the company that would have to be making the accounts to learn a new system, use it, and feed the system with data.

Also, what we have missed version after version, is a system that would let us account project oriented jobs or tasks, allowing us to account for time and materials of different tasks in a project. In this way, we would like to bill to the project, different tasks, that could be completed or not.

With the bill of materials, that I think is the way that the developers recommend to do this, I see it not very intuitive and very complicated.

Thanks and Kind regards,

Alberto

Hello Alberto;

There is Project module and it is possible to bill based on task and to bill to the project. Where is the problem in this part?

Regards
Bilal

1 Like

Hi Bilal,

I’m new to erpnext and i’m facing the same problem in uploading cimilar Coa.

Could you please send me the template you used to ulpoad Coa

Hi. I created a custom chart of account in JSON format and I push it in side of apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/verified/, but when I try to charge it from the site I giving an error. I validated the JSON with an external tool, but there is any way to validate this kind of file from ERPNext or Frappe?

Hi Bilal,
Hope that you’re well. We are importing COA for our Lebanese entity into ERPNext and are confused with the Root types since every group has mixed roots. Can you please share how you were able to resolve this? If you could share the COA template that you used, it would save us a lot of time and effort.
Thank you.
Regards,
Ahmad

Hello Bilal,

Many thanks for this message that I have just seen, and I am very very sorry that I never replied to this.

I didn’t knew that! I have seen that you can assign task and projects to timesheets, and I have just known from what you say (I had not tried to do this again for the last few years) that you can assign a task and project to a Line of a Purchase. So, is there a way to bill based on this?

How can all that information be put on a bill? And can you bill on the same bill different tasks of a project!?

Many thanks and kind regards from Spain,

Alberto