Payroll Projection Run | PowerSchool Atrieve

The Payroll Projection Run calculates salary costs, and employer expense for a range of periods. Accrual storage banks with 'E'arnings and a Liability GL defined will be calculated and included. The program uses the calendar to determine the number of pay periods to project for each pay cycle code and to determine the number of pay periods to be used in the projection of the benefits costs which are identified by the deduction frequency codes. Each payroll calendar entry indicates the base salary grid from 1 to 12. These are used to determine the appropriate salary for the calculation of total earnings for each period. Changing the grid number in a calendar from 1 to 2 will cause the program to access the second set of grid figures within a salary grid to project the salary costs for that pay period. The hours are not adjusted unless the percentage employed option is being used.

Before beginning a projection run and its following steps, examine the user specific profile and verify the setting the flag that influence the commitment accounting. The flag to check is, Commitment Accounting on page 2 of the User Specific Parameters. This must be set to 'Y' when commitment accounting is being used. The second portion of this field refers to the commitment year. Set this field to 'N' when you are using the Projection Process for reporting only.

The payroll projection program prepares a projected work file. This work file is used by many of the programs in this section. A single projection can be used to load commitments or commitment adjustments. This program is the starting point for all projection activity. The program creates the data file PRPJØ1.DAT which is used as input to the remaining steps in this section. The GL Preload Commitment Report will report the contents of this file.

NOTE: This job will only run in batch.

Run for Commitment Process or Projection Only

You MUST enter 'C' when the results of this run are to be used for the Load Commitments or Commitment Adjustments.
Enter 'P' when the results are to be used for reporting of the projected amounts only or you want Contract salaries overridden to Annual Salaries.

The 'P'rojection option will treat all Contract function lines as an Annual salary. This override of the Contract pay type allows projection of the Annualized salary and hours/days as defined on the employee's function line for the full range of pay periods defined without the contract payments remaining interfering.

To report on the true Contract results run this process as a 'C'ommitment run.

Enter the Start Period #

Enter the starting pay period.

Enter the End Period #

Enter the ending pay period to be included on the report.

A warning message displays if any periods in the selected range were previously updated. The information generated from a run using an updated period cannot be loaded or adjusted into the commitment records.

Reduce End Period

Enter 'N' to omit reductions on the final pay period. This option would not be used for commitment loading runs.
Enter 'Y' to specify a cut-off date that will reduce the employee's salary and deductions for the final pay period only.

When Reduce End Period was selected:

Enter End Period Cut-off Date

Enter a valid date that falls within the final pay period date range. This date is used to determine the full number of working days for the final pay period. The employee's salary and deductions will be reduced accordingly.

Enter Employee Types to Project

Enter 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 file which will be used in the projection process.

Enter Pay Codes to Exclude

Enter pay codes to define the function lines to be excluded from the projection. Pay codes defined here only determine when a function line will be included or excluded from the projection

You may enter any number of pay codes for exclusion from the projection. Use of the pay codes in conjunction with the pay types above gives you further control over the items that are to be included in the projection run. Function lines with negative amount must be excluded.

Include Projected Vacation Adjustments

Vacation adjustments are over and above Accrual storage bank entries. The Commitment/Projection already includes all Accrual storage banks with 'E'arnings and a Liability GL defined.

Enter 'N' to omit vacation adjustments. This option would not be used for commitment loading runs.
Enter 'Y' to enter vacation adjustments per pay cycle code. This option allows the cost projection to be adjusted to cost several vacation days or a storage bank balance to a vacation pay code. The employee's total earnings balance is not affected.

The following prompts apply when Vacation Adjustment was selected:

The following vacation prompts Repeat for up to 21 different vacation definitions

Enter Pay Cycle Code

Enter a pay cycle code for employee selection. Employees with a matching pay cycle code on the master function line will have the following vacation adjustment applied to their salary.

Enter Pay Code for Vacation Monies

Enter the pay code for recording the above pay cycle codes vacation time and monies. GL costing for the vacation will apply to this pay code for the employee's regular cost center/distribution grid.

Vacation by Days or Storage Bank

Enter 'D' to enter a vacation based on a specific number of days.
Enter 'B' to have vacation time determined by the hours balance for a list of storage banks.

When 'D'ays Vacation was selected:

Enter Vacation Days

Enter the number of days this employee group will be on vacation. The system will convert the days to hours (if applicable) based on the number of hours defined on the employees combined function lines.

When 'D'ays Vacation was selected:

Enter Days Per Pay Period

Enter the number of working days for the first valid pay period for this pay cycle code. The number of days per pay period are used in combination with the employee's total hours from the function lines to define the number of hours per day worked. The hours per day worked is used for converting the Days Vacation into hours.

When Storage 'B'ank Vacation was selected:

Enter Vacation Storage Bank Number

Enter up to 11 storage bank codes one at a time. The balance of the storage bank hours for an employee storage banks contained in this list are totaled (negative balances are omitted) to generate a total number of hours of vacation time to be taken.

Enter Period to Clear YTD Deductions

Enter a pay period that is included in the range selected. This has the same effect as zeroing deductions at year end. Only deductions with the clear YTD set to 'Y' will be cleared.
Enter will not clear the YTD values for deductions.

To indicate that deductions should be cleared so that deductions begin with a zero balance at the beginning of a year enter the first pay period of the year as the clear period.

Enter Period to Clear Selective Deductions

Accept default if clearing is not required or enter a pay period in which deductions set as selective clear are to be cleared.

Salary Grid Selection

Enter 'C' to pick up salary grid number from each individual calendar period.
Enter 2 or up to 12 to have the projection run use a salary value from the salary grid points under the salary grid database instead of from the employee's function line.

NOTE: Grid 1 uses the values from the function lines and is the default if no values are found.