PEXGL Payroll Exchange Finance G/L File

This provides Payroll Exchange clients with some options on how fields are populated in the FINANCE file.

Position Option Default Description

14

Y   Populate "GL Account Desc" field with G/L Interface Account Description
Not 'Y' Leave "GL Account Desc" field unpopulated
15 Y   Populate "Cost Centre" field from External Interface Mapping if found, else from "Department" field
Not 'Y' Populate "Cost Centre" field from Department Code only
16 Y   Populate "Pay Element" field with PEX Wage Type Code
Not 'Y' Leave "Pay Element" field unpopulated
17 Y   Populate "Person ID" field with Employee ID Number
Not 'Y' Leave "Person ID" field unpopulated
18 Y   Populate "HRIS" field with Global ID 2
Not 'Y' Leave "HRIS ID" field unpopulated
20 1   Populate "Analysis Code 1" field with Preceda Level 1 Code
Not '1' Leave "Analysis Code 1" field unpopulated
21 P   Populate "Analysis Code 2" field with PEX Wage Type Description
Not 'P' Leave "Analysis Code 2" field unpopulated

 

This provides Payroll Exchange clients with some options on how fields are populated in the FINANCE file. This file can be generated in either a Detailed or Consolidated format.

  • Detailed File - If any of Positions 16 to 21 are populated, a separate line will be output to the Finance file for each record in the associated General Ledger Batch.
  • Consolidated File - When Positions 16 to 21 are all blank, all records in the General Ledger Batch which have the same G/L Account and Cost Center information will be summarised and output to the Finance file on a single line.