Introduction

The GL Explorer facilitates GL enquires at summary and detail level by period or year. Filter criteria can include cost centre, department, or a combination of both. You can easily track performance with year-to-date and month-to-date variance to budget and prior year, and with stratification across locations/Departments/Dimensions/Projects.

The GL Explorer gives you a detailed drill-down of the figures contained in Financial Reports including:

• Profit & Loss Reports
• Balance Sheets
• Trial Balance
• Extended Business Analysis (BI Code) Reports 

The GL Explorer’s layout and sort-order sequencing reflect each report layout. Each level is progressively more detailed. 

Each GL Account Code belongs to a GL Sub-category, that in turn belongs to a GL Category. Both the GL Category and Sub-Category have a sort order that determines how they will appear in the Report. General Ledger Codes appear in numerical or alphabetic sequence within General Ledger Sub-Category. 

The GL Account Codes link to a version of the Transaction Browser displaying all transactions making up a particular GL Account Code Amount. These transactions then further link to accounts like Supplier, or Bank.

See:

General Ledger Overview (7.0) - AIQ Academy

GL Explorer (11.4) - AIQ Academy

Query Tools (GL Explorer, Transaction browser) (1.6) - AIQ Academy

 Consolidated Reporting (12.3) - AIQ Academy

Changing a Report layout‍ 

Using the Transaction Browser‍ 

Selecting Enquiry Parameters 

1. Go to General > General Ledger Accounts > GL Explorer.
2. Delete

   Info: Our New Look

   If you are using our new look navigation, the GL Explorer can be found in the GL tab in the sidebar: 

3. In the top part of the GL Explorer, select your parameters:

• Profit and Loss, Balance Sheet, Trial Balance: Select which type of Report you wish to examine.
• View: Select either Period values or Year to Date values.
• Dataset: Select Actual, Budget, or Revised Budget values. Underneath the Dataset parameters you can view the Period and Year selection for that Dataset.  
• Compare with: Select either Actual, Budget, and Revised Budget, together with the date parameters. 
• Analyse By: This is for BI Code‍ Report based Enquiries. You can filter your chosen dataset further by selecting a Dimension here. If you have not set up any Dimensions and Elements yet, then this drop down will be empty and disabled. Once you select a particular Dimension to filter on, the list of related Elements will be shown underneath in the associated drop down. You must select an entry in both drop downs. 
  
  

In the example below, the Company has a GL Category called Project, with GL Sub-Categories for Project Code, Activity (e.g. “Mechanical”, “Electrical”, “Chemical”, etc.), and Project Manager. This facilitates P & L reporting. Selecting a GL Category from the upper Analyse By dropdown determines which GL Sub-Categories appear in the lower dropdown. 

3. Click Apply Filter to display the chosen values.

 

Click Refresh data to update your data as other users could have added new transactions to the system. 

 

The system automatically saves the last set of Parameters you used and will display them next time you open the GL Explorer.  However, if you continue with that set of Parameters, remember to click Refresh to get the latest data.

See:

Using Extended Business Analysis‍ 

Using Extended Business Analysis for Job or Project Analysis‍ 

Using the Drill Down Facilities

Drilling Down to Transaction-level in Trading Entities

Click the arrows to Drill down to the next level, from General Ledger Category to General Ledger Sub-Category, and then to General Ledger Account Code. Click the arrows again to exit from the detailed level and return to the summary level. 
 

Export on the bottom left-hand corner of the GL Explorer Window lets you export your results as word, excel, or PDF.

 

Drilling Down to Transaction-level in Consolidation Entities

In a Consolidation Entity, you can drill down to the transactions in both the Sub-Consolidation and Trading Entities. 

The balance appearing for the Trading Entities is in the currency of that entity, not the currency of the Consolidation Entity.

Viewing Transactions in the Transaction Browser

Click any of the references to open the Transaction Browser Window and view the list of transactions making up that Amount.
 

Open any of the transactions and edit them by clicking the pencil icon if necessary.
 

See:

Using the Transaction Browser‍ 

 Amend, Cancel or Delete Transactions‍