The Detail GL Distribution Report - Online provides a listing of the temporary GL transaction as generated by a payroll run. This report accesses the temporary file created by running the payroll processing. The results of this temporary file will be used by the payroll update to generate the permanent GL transactions to be interfaced into the accounting system.
This report provides an option to run for all GL transactions, a summary by GL account code or for invalid GL account codes only. It is recommended that this report be at least run for invalid GL accounts only at the end of payroll processing and before the payroll update is processed. Corrections to the GL costing can then be made if necessary and the payroll rerun to prevent invalid GL costing into the accounting system. The detailed information supplied by this report will allow you to isolate where in the payroll the invalid GL account code is.
NOTE: This report can only be run after completing a payroll processing run and before the payroll update.
The export file includes the following fields:
-
GL Account
-
GL Description
-
Employee Number
-
Employee Name
-
Cost Center Code
-
Occupation Code
-
Position
-
Vendor Number
-
Batch Type
-
Date
-
Shift Code
-
Pay/Deduction Code
-
Hours
-
Amount
Enter Pay Period
-
Enter the pay period for which to produce the report.
Full/Summary Report/Invalid
-
Enter 'S' to produce a summary report.
-
Enter 'F' to produce a full report.
-
Enter 'I' to produce a report of invalid GL entries. (same format as a full report.)
Earnings/Deduction Transactions
-
Enter 'E' to include only earnings transactions
-
Enter 'D' to include only deduction transactions.
When Deductions or ALL transactions was selected:
Enter Deduction Include / Exclude
-
Enter 'E' to indicate the deduction codes entered in the following prompt are to be excluded from the report. Entering 'E' without entering a list of deduction codes indicates that no deduction codes will be excluded (exclude nothing).
-
Enter 'I' to indicate the deduction codes entered in the following prompt are to be the only deductions to be included on the report. Entering 'I' without specifying a deduction list indicates that no deductions are to be reported.
Enter Deduction Codes
-
Enter the list of deductions one at a time. Use look-up for valid deduction codes.
When 'E'arnings or ALL transactions was selected:
Enter Earnings Include / Exclude
-
Enter 'E' to indicate the pay codes entered in the following prompt are to be excluded from the report. Entering 'E' without entering a list of pay codes indicates that no pay codes will be excluded (exclude nothing).
-
Enter 'I' to indicate the pay codes entered in the following prompt are to be the only earnings to be included on the report. Entering 'I' without specifying a pay code list indicates that no earnings are to be reported.
Enter Earning Codes
-
Enter the list of pay codes one at a time. Use look-up for a list of valid pay codes.
When 'F'ull or 'I'invalid report was selected:
Report by GL or Employee
-
Enter 'G' to produce the report by GL code.
-
Enter 'E' to produce the report by employee.
When report by 'E'mployee was selected:
Sort by Employee Number OR Name
-
Enter 'E' to produce the report sorted by employee number.
-
Enter 'N' to produce the report sorted by employee name.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file with this report.
This report lists the following:
Summary:
-
GL account and description
-
Interface hours and amount
Full:
-
GL account and description
-
Employee number and name
-
Cost center, occupation code
-
Batch # - the time entry batch, or pay type for function line, or
-
DED for deducted amount, or
-
OHD for employer's share of deduction
-
Date, shift code, pay/deduction code, hours, amount