Creating Divisions within our organization

We need to create Divisions within our organization.

Is anyone familiar with this?

  • Hi  can you explain further what you're trying to achieve overall and from a reporting perspective?  The basic approach is to add G/L Segments to your charge of accounts so for example you have your natural accounts like 1000, 2000, 3000, 4000 for different balance sheet/P&L items like Assets, Liabilities, Expenses, Revenues, Equity but then you will have Segments such as Division, Cost Centre, Project, Event etc.  So if you setup a segment called Divisions and then had a three number code for each division i.e. 100 = Executive, 200 = Corporate Services & IT, 300 = Finance, 400 = Marketing, 500 = HR etc then when recording and reporting on expenses for example you will have Corporate Services & IT expense accounts in the range 3000-200 such as new laptop purchases might go to 3500-220 which would be 3500 (Computer Hardware) - 220 (Corporate Services & IT - Hardware) which you can then report on.  If purchasing new laptops for marketing it would be 3500-520.  You can then expand this with additional segments such as you might have an Events segment where event code 650 is "Conference - Marketing Annual" so the marketing expense for the laptops for use at the conference might be 3500-520-650.  So I'm focused on the IT aspect of Sage 300 and not accounting so I'm sure someone else can explain better.  If you're already doing this then you can do divisions in more advanced ways such as:

    1. If you wish to have a whole separate division with separate logins, permissions, completely segregated then you could run another Sage 300 database and use G/L Consolidations for group reporting.  This is particularly useful if you have a "Group" company that you report from and separate wholly-owned operating divisions underneath, i.e. a large company might have four separate retail locations they run out of separate sage 300 companies but consolidate data back to a group company for reporting.
    2. You could use G/L Account Permissions and other tools to segregate access between accounts in the Chart of Accounts so users in different divisions can't look at each data.
    3. You could expand the use of segmented accounting by using Inter-Entity transactions to automatically process inter-company loans from cross invoicing for example when one division purchases something on behalf of another division.

    Again I'm sure someone will do a better job answering but hope this gives you an idea of some options.  Good luck...Tim.