Community mailing list archives

Chart of accounts

John Pia Jr
- 12/12/2014 06:33:34


I am seeking some feed back as to how other businesses go about managing a very large chart of accounts.

Let me first explain what we have been doing for years (I Dont necessarily think that this method is still the best choice being as we are operating on a very outdated set of software platforms)

Basically we have a list of a couple hundred different types of GL codes. Each of those GL codes must be related to a cost center(locations). Currently we create 1 gl code location. For example let's take the GL code for repair and maintenance, within that code there are 5 sub codes, each one of those 5 sub codes need to be related to a location.


GL = x
Sub gl = Y
Sub gl 2 = z

Location 1=L1
Location 2 = L2
Locations 3 = L3

Here are a list of gl codes that are created as a result from the above.


The entire purpose of creating a separate GL code for each location is only for reporting purposes. My accounting department likes to be able to see on a trial balance report all of me codes broken down by location. To me this is a very old way of doing things

What I would like to do is I would like to be able to give my accountant that same break down of transactional information based on location, but rather than use the GL code to represent the location I want to know if it is possible to use the location being the source or destination location within any transaction to create that relationship between GL code and location. By doing this it will allow me to expedient really decrease the amount of GL codes we currently have.

Finally I would like to ask the community if anybody would be willing to share with me some of the basic accounting reports offered by odoo that are of much larger companies. For example we are a 200 million dollar organization with 8 locations and 3800 GL codes. I would  like to have a better understanding as to how others among our size handle the above question.

What I'm looking to do is get rid of the need to have to identify a location within a GL code.

If I have not been clear please let me know, and thank you in advance for any help