General Ledger Analysis

Home » Other Functions » System Configuration » General Ledger Analysis
System Configuration No Comments

General Ledger Analysis

Transport

The General Ledger analysis of Transport jobs happens at three levels.

  1. Analysis that is made available when invoicing.
  2. Analysis that is made available when executing a BCTI run.
  3. Subsequent detailed analysis of sales.

General Ledger Analysis of Sales

Invoice Run

All transport sales transactions exported to the financial system are coded to one general ledger code. This code is set against the Global Parameters. It is expected that the user will set this code to either a Revenue Clearing account or a default Transport Sales account.

Subsequent Analysis

Many companies require a more complex level of analysis within their General Ledger. We provide this complexity by allowing analysis at job price line level. At each job break the user can set a Secondary Group. In the example below the secondary group has been set to Metro.

GL1

The secondary group has been linked to a general ledger code, as shown below.

GL2

The secondary group is applied against each price line on the job. This enables us to produce reports as follows;

  • Revenue over a time period by secondary group
  • Revenue over time by general ledger code

Currently it is expected that revenue would be journaled into the general ledger based upon the second report. The reporting at secondary group level is provided to give more in depth analysis without cluttering your general ledger reporting.

General Ledger Analysis of Sub-Contractor Costs.

All sub-contractor costs are analysed to general ledger accounts that are specific to the sub-contractor. The account to be used is defined against the driver record pertaining to the sub-contractor. As shown below the field is titled “GL for BCTI”.

GL3