Managing General Ledger Group Data

How to manage GL accounts at group consolidation level

Written By Grainne Reidy (Super Administrator)

Updated at June 5th, 2024

Introduction

From your consolidation group entity, you can now create a GL Account against all or a selection of entities within a group in just two simple steps.

This feature enables you to add the following to all subsidiaries within a group:

  • a posting type GL code
  • a control type GL code
  • categories
  • subcategories 

Access to this feature is provided by default to all entity or group administrators. For all other users, access can be granted through the user profile management screen.

See:

GL Group Data Management (12.4) - AIQ Academy

Delete

Adding posting type GL codes

1. Log in to the consolidating group entity. Go to General > General Ledger Accounts > New GL Account and create a new GL code.


Delete


When you add default BI Codes to the GL Code, the BI Codes will be propagated down to all selected entities along with the linked dimensions.




2. After creating a new GL code, click Refresh Grid and find your newly created GL code in the code field.

 

3. Against the newly created GL code, go to Actions and select Add GL A/C to Entities.

4. The Add GL A/C Record window displays a list of all types of entities created against your group. Select the entities that you want to add the GL code to by ticking the box next to their names. To select all entities, tick the top checkbox. You can also filter the list of entities by GL code location. This facilitates selection when dealing with numerous entities.

 

5. Click Process to add the GL code to the selected subsidiaries. The system creates the GL Account within all selected subsidiaries and confirms completion. You can verify the newly created GL code by logging in to one of the entities. The system creates an Excel log of this process which you can access in the Document Manager. 

 


Delete

Adding control type GL codes

After creating a GL code, you can convert it into a Control Account and copy it down to a selection of subsidiaries.

1. Log in to the consolidating group entity. Go to Setup > Codes Maintenence > System Accounts > Add New Control Account. Click Refresh Grid.



2. After you convert a GL Account into a Control Account, add it to all relevant entities within the group. Go to Actions and select Add GL A/C to Entities (see previous section for more details).


Delete

Adding categories

To add a Category or Subcategories to entities within a group, first, create the Category or Subcategory in the consolidation entity.

1. Log into the consolidating group entity. Go to Setup > Codes Maintenence > GL Categories > Add New Category.

2. In Add Category, fill out Code, Description, and Category Type. Click Save.


3. After creating a Category/Subcategory, assign it to the GL Account. You must use a newly created GL code. Go to General > General Ledger Accounts, and in the code column, select the code. In General Ledger Maintenence, complete all relevant details. Ensure all details are correct before clicking Process.


4. To add the newly created GL Category and Control Account to all selected subsidiaries of a group, go to Actions, and select Add GL A/C To Entities. Select all relevant Entities. Click Process.




Delete