Payroll Interface Cost Split | PowerSchool Atrieve

The Payroll Interface Cost Split provides a means of splitting a payroll interface file by percentage, before interfacing the journal entries into the Finance system. This option would be used for payrolls that cross over a fiscal year end and you want a percentage of the payroll costed to each fiscal year. NOTE: Prior to running this process, the Payroll Update must be run saying N to the interface option so that the files do not auto interface into Finance and are available during the running of this process.

This process offers two options. A straight percentage split where the values from the existing interface file are split into two new files. The second option allows you to select specific employees to be split. The option to selectively split the interface costs allows you to identify a group of employees to be split while all other employees' costs will remain unsplit and costed under the ###%%%%PRin01.YPP file.

Enter Period #

Enter a valid pay period number. The pay period entered identifies the interface file ###%%%%PRin01.YPP to be split, where ### is the Finance interface code and %%%% is payroll ID code both taken from the Payroll master profile. This interface file is created by running the Payroll Update phase of the payroll.

Enter Percentage to CHARGE to NEXT Period

Enter the percentage of the interface file which is to be charged to the next accounting year. These charges will be contained in an interface file by the name of ###%%%%PRinØ2.YPP where the YPP will be the same pay period number as the period entered in the previous prompt.

The ###%%%%PRinØ1 file would be interfaced into the current accounting year. The ###%%%%PRinØ2 file would be interfaced into the next accounting year.

Split Interface Based on Employee Selection

Enter "N' to split all GL entries within the current interface file.
Enter 'Y' to select a group of employees to have their GL entries split while all non selected employees will not be split.

When selection by employee selected:

Select Employees by Code

Employee Number - EM
Pay Code - PC
Location Code - LC
Cost Center - CS
Salary Grid – GR
Occupation Code - OC
Pay Cycle Code – CY
Employee Type - ET
Pay Type – PT
Shift Code - SC

Enter a 2-character code to define the field to use for employee selection. Selection is based on the master function line.

Enter 'EM' to select employees based on employee number.

When employee selection is by employee Number:

Report All or Select Employees

Enter 'A' to select all employees.
Enter 'S' to select specific employees.

When employee selection is based on any field other than employee number, you are prompted to enter one or more of that code or value. You may enter valid codes or any combination using the wild card '?'. The wild card is not a valid entry for numeric fields such as hours. The list of values entered will determine if an employee is selected based on the values from the master function line.

When selection by employee Selected:

Generate Interface by – GL or Employee

Enter 'G' to have the interface entries summarized by GL account code. There is one Journal Entry created for each GL per file with only the total of all entries against the code being processed. The report will also be generated in GL summary format.
Enter 'E' to have the interface include complete detailed transactions for all payroll entries. No compression of entries is done. The journal entries will have the employee name on them. The report will be generated by employee with a summary per employee cost.

Report Content

The report lists each account code or employee with the details spread on three lines for commitment, expense and hours.

The following columns are reported:

Next Period	Identifies the amount of each of the items to be charged to the next accounting period and contained in the ###%%%%PRinØ2 file.
Current Period	This is the amount to be charged to the current year and is contained in the ###%%%%PRinØ1 file.
Computed Total	This is the sum of the next period and current period distributions.
Original Amount	This is the original amount contained in the original ###%%%%PRinØ1 file read by the program. Not applicable on employee selection.
Difference	This is any difference that exists between the computed total and the original amount and should always be zero. Not applicable on employee selection.

Any non-zero figures in the difference column is caused to contact atrieveERP Support.