General Ledger account entries are usually a summary of several transactions. Transactions of a similar nature are generally grouped together within these ledger accounts.
General Ledger analysis provides a means of distributing transaction values to ledger accounts together with analysis information. This reduces the need to create individual ledger accounts for certain categories of expenses such as travelling, repairs and maintenance, general expenses or donations for example. It also eliminates the need to manually analyze such General Ledger accounts.
|
The following steps are required to configure the General Ledger to use account analysis:
Optionally use the General Ledger Setup program to enable the account types for which analysis entries are required.
When you define an account type as requiring analysis and you use the General Ledger Codes program to add a ledger code with that account type, a message is displayed to remind you that analysis may be required for that ledger code.
Use the GL Analysis Categories and Codes program to define:
the analysis categories you require.
Up to 5 analysis levels (category types) can be defined against each category.
the category codes for each category type you defined against a category.
You can define as many category codes as you require. Transaction values are processed against the category types when you use the Capture GL Analysis Entries program.
Use either the General Ledger Codes or GL Structure Definition program to indicate the ledger accounts against which analysis is required and to define the analysis category to use for that specific ledger code.
In addition, if you want to process analysis entries from sub modules, then the General Ledger integration method for the sub module(s) must be set to detail either at company level (General Ledger Integration) or against the individual General Ledger account code(s) (General Ledger Codes or GL Structure Definition). Failure to do this results in analysis entries not being posted.
The following points are applicable to analysis entries:
In the current version of the program, G/L analysis can only be performed on transactions originating in the following modules:
Work in Progress
You use the Capture GL Analysis Entries program to distribute transaction values to the required analysis codes within the analysis categories.
Whenever you process a transaction containing a General Ledger code for which G/L analysis is required (see General Ledger Codes or GL Structure Definition) then the program is displayed either when you post the transaction, or when the transaction value is distributed to one or more ledger codes.
The Capture GL Analysis Entries program is loaded from the following programs:
An analysis number is automatically assigned to each analysis entry when you use the Capture GL Analysis Entries program to distribute values to analysis codes.
Analysis entries can be printed using the GL Trial Balance program.
Analysis entries can be viewed using the GL Query program.
Analysis entries are retained for the period defined against the option: Detailed transaction history (General Ledger Setup).
Analysis entries are deleted by the Purge function of the GL Period End program, when they are older than the period defined against the option: Detailed transaction history (General Ledger Setup).
Following is an example of an account categorization:
Category - MV EXP (Motor Vehicle Expenses)
Category type - REGISTRATION (This category type would be defined as mandatory)
Category codes:
Category Type - FUEL
Category codes:
Category Type - OILS
Category codes:
Category type - MAINTENANCE
Category codes:
Category type - OTHER
Category codes
In this example, all five category types were used. You could, however have combined FUEL and OILS into one category type. Alternatively, you could have defined only one category type: REGISTRATION and processed all expenses for a specific vehicle (irrespective of the type of the expense) to that vehicle's registration number.