Helpful Hints for Maintaining Payroll Data. Session 9A 2014 Spring KASBO Conference Sheila Miller, Business Analyst Office of KIDS Kentucky Department of Education. During this session, we will take a look at functionality in the payroll module that may make your work a little easier.
2014 Spring KASBO Conference
Sheila Miller, Business Analyst
Office of KIDS
Kentucky Department of Education
During this session, we will take a look at functionality in the payroll module that may make your work a little easier.
We will also review information related to Exceptions Tables, Allocation Codes, Job Class Codes and setting up hybrid employees.
Do you ever need to change the GL account number on an employee after a payroll has been processed? There is a much easier way than manually moving the expenditure using a journal entry.
Human Resources/Payroll >Payroll >Employee History >History Transfer
Determine the record(s) that need to be modified. (employee number, check number, etc.)
Once you have selected the record that needs to be changed, select the Transferoption.
You will then enter the new Org/Object/Project.
There is also the option to enter an Allocation code for the update.
Changing the code in History Transfer also corrects all of the fringe benefit codes. This eliminates the need to enter a manual General Journal entry.
When you choose to terminate an employee, the employee is moved from the live payroll module to the Terminated Employee file.
Human Resources/Payroll >Payroll >Employee Maintenance >Employee Master
Select Terminate option on the Employee Master screen after selecting employee or group of employees to move to Terminated File.
User is prompted to Output report. Do not miss this step. Review the report prior to selecting Yes to move the employee(s) to Terminated.
Sample of Terminate Proof Report
The Mass Contract Changes option provides a way to update employee Job/Salary records back to the defaults set on the Salary Tables.
This functionality will reset the number of pays, days, salary amounts, etc. This is useful when you have multiple mid-year hires that come back to work the following year and need a full-year Job/Salary record.
Process this step prior to performing the Mass Salary Update.
We will use transportation department employees for this example.
Records that need to be changed to Salary Table defaults:
Human Resources/Payroll >Payroll >End of Period >Mass Salary Changes >Mass Contract Changes
You can process by any combination of the options in the top part of the screen.
Select Output/Post, review the records and post the changes.
Records after Mass Contract Change was processed:
Records now reflect Num Pays, Days per Yr, Hours per Yr, Annual Pay, Reference Salary, Period Pay for a full year. You can use the Global Update in Job/Salary to change the Remaining Pays field before the first payroll of the new year.
We will review a few of the options available on the Job/Salary record that should make viewing and updates a little easier.
This function can be used to mass create or delete pay records. Example – All primary school level teachers in one school will receive additional pay each month for professional development work that will be completed for throughout the year.
Rather than adding individual records one at a time, use this function to mass create the pay records.
Select Global Add/Del on the Job/Salary screen.
Define the parameters and select Execute.
Select OK to the prompt to add the records.
Pay records are now established and earnings can be entered within the payroll for the professional development.
You will use the same option to delete pay records in mass, Global Add/Delete.
Define the parameters and Execute.
Select OK at the prompt to delete the pay records.
Pay records are gone!
There are many functions available when choosing Global Update on the Job/Salary screen.
We will update the Number of Pays and Remaining Pays in this example.
Find the record or set of records that need to be updated then choose the Global Update button.
Choose Define and select the options to be changed and enter criteria for the update.
We are changing the Number of Pays and Number of Remaining Pays to 24.
Click Execute and Yes to the prompt to post the update after choosing an output method for review.
Here is the same record after performing the Global Update.
This function can be processed on multiple records at one time. This eases the burden of changing the pay information of mid-year hires when starting a new year. You can find on the remaining pays field and enter, for example, <24 if the employees you want to update normally have 24 pays. Then process the update on all records.
Another option in Global Update that can save processing time is Update FTE. You may have multiple staff members whose FTE will be changing beginning with a new school year. Example – .5 FTE teachers will all be moved to 1.0 or vice-versa.
Need to change project numbers on pay records to prepare for new year payroll processing?
Select Project Update located on the Job/Salary screen.
Select Define and enter criteria for the update. You can choose multiple projects to process during the update.
Select Execute, choose an output method, review the report and choose Yes to post the update if information on report is correct.
Need to see Payroll Audit History for an employee when in Job/Salary?
Choose View History.
Payroll Audit Inquiry will display.
Need to find employees being paid from a specific fund or account?
Select GL Acct Find on the Job/Salary screen.
Enter account information into the GL Segment Find screen and click .
All employees within the search criteria will be found.
If you need to set up a G/L Allocation on an employee’s record, it can be set up using this option.
Most districts have employees commonly referred to as Hybrid Employees. These are employees that have a degree, work in a classified position and pay into KTRS.
You can set up a separate Pay Type for these employees. Most districts use a number in the classified range of Pay Types. Set up the Payroll Exceptions to reflect the correct calculation of deductions. (example - Should be excluded from CERS and included in KTRS.)
When a Pay Type is added to the Pay Master, it is important that the Exceptions are updated in the Deduction Master.
Exceptions Tables are extremely important to the accuracy of payroll. If a Pay Type is not correctly set up on deduction codes, deduction amounts may be incorrect when processing a payroll.
Documentation for Kentucky Specific processing and reports (i.e., PSD, CSD, HI Enrollment, KTRS, CERS, etc.) can be found at the following address:
Contact KDE for KY specific processing and reporting. 502-564-2020
Need documentation for a general process or report? (i.e., adding a pay type, adding a deduction, steps for processing a payroll, etc.) Search the Munis KnowledgeBase for information.
Contact Munis Support for issues involving non-KY specific processes and reports. 800-772-2260