Salary Costing Report

The Salary Costing Report is a salary projection report with sorting / subtotaling options of employee number, occupation code, GL or GL Level. Function lines to be included are selected based on pay types. All salary amounts are reported annualized. The annual salary for all function lines except 'A'nnual and 'C'ontract function lines (which already contains an annual amount) will use the Number of Salary Periods from the pay cycle code database. When the Number of Salary periods is not used (set to Ø) the employee's annual salary is calculated using the Number of Periods value from the applicable pay cycle code. You can also define accrual or pay storage banks earnings to calculated and costed based on the selected earnings.

This report includes an option to generate an export file, ######.EXP where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have extra spaces removed from the front and back of fields and a tab character separates all fields. The export file includes the following fields:

Employee's Payroll employee number
Employee name
Occupation code
Occupation description
Salary grid code
Costing distribution (Percent Employed time GL costing distribution)
Salary
Full GL Account Code
GL Account broken down by levels (10 fields)
GL Alias broken down by levels (10 fields)

Enter pay types for function line selection

Accept default to project on all pay types.
Enter 'F' to project on fixed salaried employees only.
Enter 'L' to project on lump sum.
Enter 'A' to project on annual salaried employees only.
Enter 'S' to project on salaried employees only.
Enter 'H' to project on hourly paid employees only.
Enter 'P' to project on part-time employees only.
Enter 'C' to project on contract paid employees only.

Use of the various pay type codes provides control over the function lines on the employee's master that will be included in the projection process.

Enter Storage Banks to Include in Salary

Accept default when no accrual or pay storage banks are to be included on the report.
Enter one or a list of accruals or pay storage banks to have the storage bank earnings included. The accrual or pay banks are calculated and costed to the appropriate GL accounts according to the earnings being processed. The FTE on the bank entries will display as zero to prevent the bank entries from inflating the FTE totals and distorting the subtotal averages.

Report Employees Terminated / On Leave / Benefits

Sort by Employee, Occupation Code, GL, GL Level

Enter 'G' to generate the report in GL account sequence.
Enter 'E' to generate the report in employee number sequence.
Enter 'O' to generate the report in occupation code sequence.
Enter 'L' to generate the report sorted by a specific GL level.

When report by GL 'L'evel was selected:

Select GL Level to Sort On

The levels of your GL account will display.

Enter the GL level to be used for sorting and subtotaling on the report.

Include Generation of Export File

Enter 'N' to omit generation of the export file.
Enter 'Y' to include the generation of the export file with this report.

The report prints the following information:

Employee Number and name
Occupation Code and description
Salary Grid
Costing distribution (Percent Employed time GL costing distribution) (zero on bank entries)
GL Account
Gross Salary, including premiums
Average salary on Subtotal (salary for category divided by Distribution for category)