Managing General Ledger Group Data

Create GL Accounts, Categories and Sub-Categories for your group at Consolidation level

Written By Grainne Reidy (Super Administrator)

Updated at June 4th, 2026

Introduction

Consolidation Access

Please contact support@accountsiq.com if you cannot see the Consolidation option. This might require enabling the Group Accounting add-on.

 

From your consolidation group entity, you can now create the following against all or a selection of entities within a group:

  • Posting type GL code
  • Control type GL code
  • GL Categories
  • GL Sub-Categories 

Permissions

Access to this feature is provided by default to admins. For all other users, access can be granted through the user profile management screen. Check that users have the following permissions set in the Consolidation Entity:

  • Codes Maintenance
  • GL Account Listing
  • Add/Edit GL Accounts
  • Add GL A/C to Entities

See:

GL Group Data Management (12.4) - AIQ Academy

Managing General Ledger Accounts‍ 

 
 

Adding posting type GL codes

  1.  Log in to the consolidating group entity. 
  2. Go to GL > General Ledger AccountsNew GL Account.
  3. Create a new GL code. See Managing General Ledger Accounts for more details. Select a default Dimension Tag if you want it to be propagated down to all selected entities along with the linked Dimensions.
  4.  After creating a new GL code, click the Refresh icon and find your newly created GL code in the code field. Against the newly created GL code, go to Actions and select Add GL A/C to Entities.
  5. Select the subsidiaries you want to have the GL Code by checking them. Filters are available to assist in making your selection. Click Process. The system will confirm completion. You can verify the newly created GL code by logging in to one of the entities. An Excel log of this process is available in the Document Manager in the GL listing grid.
 
 

Adding Control type GL Accounts

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. 
  2. Create a regular GL Account as outlined in the previous section.
  3. Go to Setup > Codes Maintenance > System Accounts. 
  4. Click Add New Control Accounts.
  5. In Account Type, select the relevant type.
  6. In Linked GL Account, select the account you created earlier.
  7. After you convert a GL Account into a Control Account, add it to all relevant entities within the group. In the GL listing grid, go to Actions and select Add GL A/C to Entities as described previously.
 
 

Adding Categories and Sub-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 Consolidation Entity.
  2. Go to Setup > Codes Maintenance and create a Category or Sub-Category as described in Managing General Ledger Accounts.
  3. Go to General Ledger and create or open a GL Account. Assign the Category or Sub-Category you created in the previous step. Refer to Managing General Ledger Accounts for assistance.
  4. Add the Account to all subsidiaries as described in ‘Adding posting GL Codes’. This will automatically add the selected Category and Sub-Category in those subsidiaries.