1 / 181

HRMS End User Training

1. Table of Contents. . HRMS Payroll and Reports Overview 6Pre-Payroll Analysis 20 Corrections and Returns 27 Logged Changes in Infotype Date 30 Basic Infotype Data 33 Preemptive Time Data Check 36 Pr

henriette
Download Presentation

HRMS End User Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


    2. 1 Table of Contents

    3. 2 HRMS Payroll and Reports Instructor: Introduction Restrooms/Participant lounge Cell phones Questions Class introduction- Name, Agency, Experience with HRMS. Instructor: Introduction Restrooms/Participant lounge Cell phones Questions Class introduction- Name, Agency, Experience with HRMS.

    4. 3 Course Objectives Upon completion of this course, you will be able to: Explain the big picture (overview) of HRMS Payroll and Reports. Explain the new terms and concepts associated with HRMS Payroll and Reports. Complete the Pre-Payroll Analysis, including simulations and reports. Discuss the release of payroll and how agencies are involved in correcting reports. Run and view payroll reports. Complete extended payroll scenarios.

    5. 4 Training Materials The following training materials and tools are used: HRMS Training Guide: Designed to introduce you to HRMS navigation terms and concepts and to provide the necessary information to complete the activities and exercises throughout the course. HRMS Activity Guide: Designed to provide you with activities and exercises that help solidify your understanding of concepts learned in the course and also provide you with an opportunity to use HRMS. HRMS Training Guide This document which contains PowerPoint slides and notes of all of the content covered in class. It is also used as a training manual. HRMS Activity Guide The accompanying Word document that details all the scenarios and data needed to perform an activity in HRMS. Types of activities in the Activity Guide include: HRMS Training Guide This document which contains PowerPoint slides and notes of all of the content covered in class. It is also used as a training manual. HRMS Activity Guide The accompanying Word document that details all the scenarios and data needed to perform an activity in HRMS. Types of activities in the Activity Guide include:

    6. 5 HRMS On-line Quick Reference (OLQR): On-line help that provided you with step-by-step instructions designed to help you complete tasks in HRMS. Training Tools HRMS OLQR An online help tool that contains user procedures and process flows to be used during all activities in the training. HRMS also contains Context Sensitive Help. When accessing the Help feature while working in HRMS, the OLQR will display procedures related to the transaction the user is currently working in. HRMS OLQR An online help tool that contains user procedures and process flows to be used during all activities in the training. HRMS also contains Context Sensitive Help. When accessing the Help feature while working in HRMS, the OLQR will display procedures related to the transaction the user is currently working in.

    7. 6 Job Aids For classes, we are no longer providing copies of job aids. Job Aids can be accessed and printed from the OLQR if you chose to print them when you get back to your desk. While you are in class, you can review the job aids found in the binder on your desk. These binders are to remain in the classroom. Job Aids – Found under tab 5 in binder. A designed to provide you with reference materials so you can quickly access relevant HRMS information. Instructor: Click on link and show how to view job aids in each format.For classes, we are no longer providing copies of job aids. Job Aids can be accessed and printed from the OLQR if you chose to print them when you get back to your desk. While you are in class, you can review the job aids found in the binder on your desk. These binders are to remain in the classroom. Job Aids – Found under tab 5 in binder. A designed to provide you with reference materials so you can quickly access relevant HRMS information. Instructor: Click on link and show how to view job aids in each format.

    8. 7 HRMS Payroll and Reports Overview

    9. 8 HRMS Payroll and Reports Overview Upon completion of this section, you will be able to: Understand the concept of payroll processing in HRMS. Know and understand the functions you will perform as a Payroll Analyst in HRMS. Understand where payroll processing fits into HRMS. Explain the five areas of payroll processing. Understand key terms and concepts of payroll processing. Understand roles as they relate to the course.

    10. 9 New Terms Payroll Processing: Process which runs payroll for the State. Payroll Simulations: Transaction that is run to check payroll results prior to the DOP payroll run. Master data: This is essential personnel information that includes personal and organizational data which is unique to each employee. Payroll: Calculation of pay for an employee for a pay period. Payroll Area: Grouping in HRMS that divides employees into areas to run payroll. Regular Payroll: Period during which payroll is scheduled to run according to the payroll calendar. Instructor: Review terms Payroll area: Groups together employees for whom payroll is run at the same time and in the same way. Examples include: Employees paid semi-monthly (11) – all employees in Washington Employees paid monthly (10) – State Board for Volunteer Firefighters and Reserve Officers. Instructor: Review terms Payroll area: Groups together employees for whom payroll is run at the same time and in the same way. Examples include: Employees paid semi-monthly (11) – all employees in Washington Employees paid monthly (10) – State Board for Volunteer Firefighters and Reserve Officers.

    11. 10 Agency Roles For payroll processing, four primary roles work together to complete the payroll tasks in HRMS. Payroll Analyst: Responsible for producing and reviewing payroll reports. Payroll Processor: Creates and maintains an employee’s payroll master data in HRMS. Payroll Inquirer: Views an employee’s master data after it is entered by the Payroll Processor to verify the information entered is complete and accurate. Payroll Supervisor: Provides oversight to all three of the payroll processing rolls. Has read and reporting access to most payroll information. Must also be mapped to the Payroll Processor or Payroll Analyst roles in order to perform the specific tasks of the roles

    12. 11 Central Role: Department of Personnel DOP is vital to the centralized payroll process During the payroll process DOP is responsible for: Releasing and starting the payroll run (executing payroll). Distributing error reports to agencies. Correcting technical errors. Processing payroll postings and third party remittance.

    13. 12 Central Role: Office of the State Treasurer The Office of the State Treasurer (OST) collaborates with DOP and each agency to assist in payroll processing. During the payroll process, OST is responsible for: Verifying payroll balances based on information provided during the payroll run Releasing signatures on payroll warrants Transmitting Automated Clearinghouse (ACH) files (direct deposit)

    14. 13 Central Role: Office of Financial Management During the payroll process, OFM is responsible for: Financial interfaces between HRMS and the Agency Financial Reporting System (AFRS) HRMS coding will be converted to AFRS. JV to transfer dollars from operating accounts to Fund 035. JV Payments to other state agencies DRS, HCA Combined Fund Drive , Guaranteed Education Tuition via JV. Paying 3rd party vendors through AFRS: Taxes paid to the IRS through the Electronic Funds Payment Transfer System (EFTPS) Savings Bond Purchases. Union Dues Garnishments Other payroll deductions Office of Financial Management is responsible for: The Financial interfaces between HRMS and the Agency Financial Reporting System (AFRS). Information that is entered into HRMS is converted into AFRS coding to populate the AFRS system. OFM is also responsible for creating the JV’s to transfer money from the operating accounts into Fund 035-Agency general operating fund as well as JV payments to DRS, HCA, Combined Fund Drive and Paying 3rd party vendors through AFARS Office of Financial Management is responsible for: The Financial interfaces between HRMS and the Agency Financial Reporting System (AFRS). Information that is entered into HRMS is converted into AFRS coding to populate the AFRS system. OFM is also responsible for creating the JV’s to transfer money from the operating accounts into Fund 035-Agency general operating fund as well as JV payments to DRS, HCA, Combined Fund Drive and Paying 3rd party vendors through AFARS

    15. 14 Payroll Processing Business Process Flow

    16. 15 Determining a Payroll Processing Cycle

    17. 16 Payroll Processing Activities Day 4

    18. 17 Review: HRMS Payroll and Reports Instructions: Match the role on the left to the solution in the column on the right (role may have more than one activity associated with it)

    19. 18 Pre-Payroll Analysis

    20. 19 Pre-Payroll Analysis Upon completion of this section, you will be able to: Understand where Pre-Payroll Analysis tasks are completed within the overall payroll process. View Preemptive payroll reports to review payroll master data. Run a simulation and view simulation logs. View simulation reports. Identify errors and prepare payroll processing.

    21. 20 Pre-Payroll Analysis Business Process Flow

    22. 21 Overview of Pre-Payroll Analysis Tasks Step 1- Payroll processing Activities pre-Day 1and Day 1: Corrections and Returns for Agency ZHR_RPTPY151 Logged Changes in Infotype Data S_AHR_61016380 Basic Infotype Check ZHR_RPTPYN06 Preemptive Time Data Check ZHR_RPTPYN07 Preemptive Compensation Data Check ZHR_RPTPYN08 Step 2- Run/Review Payroll Simulation PC00_M10_CALC_SIMU Step 3- Correct the identified errors and prepare for payroll to be run by DOP. Instructor: Remind class about creating Folders under their user menu for Pre-Day 1, Day 1, Day 2 and Day 3 payroll processing to include the reports they should run on each of the payroll processing days. For help creating folders to your user folder: Go to The Customer Support Web Site/HRMS Resources: http://www.dop.wa.gov/NR/rdonlyres/DD775A43-17B7-461B-B023-460DBCD0AA1F/0/PR_Processing_days.doc Instructor: Remind class about creating Folders under their user menu for Pre-Day 1, Day 1, Day 2 and Day 3 payroll processing to include the reports they should run on each of the payroll processing days. For help creating folders to your user folder: Go to The Customer Support Web Site/HRMS Resources: http://www.dop.wa.gov/NR/rdonlyres/DD775A43-17B7-461B-B023-460DBCD0AA1F/0/PR_Processing_days.doc

    23. 22 HRMS Reporting - Transaction Code Map

    24. Step 1. Payroll processing Activities Pre-day 1 and day 1

    25. 24 Corrections and Return The Corrections and Return Report is used to display the pre-note (for direct deposits) corrections and rejects the agency needs to correct for the employee record. Refer to the OLQR for the User Procedure: Corrections and Returns for Agency Access the Corrections and Return report by using the transaction code ZHR_RPTPY151

    26. 25 Corrections and Return Fields to complete: Key date Personnel Number Personnel Area For Date For Seqnr Click (Execute) to generate report.

    27. 26 Corrections and Return Instructor notes: Return or Reject means the employee’s IT0009 record will be automatically reset back to a Warrant. Do not reenter an account number that has been rejected in the prenote process! It will be rejected a second time, and penalties can occur. ·  Any correction Transactions with codes C01-C07 will automatically update the employee's Bank Details (0009) with the new information. ·         Any Corrections with codes C08 and higher will only be reported, and the user must determine the appropriate course of action. Failed -prenote has failed but the IT0009 record has not been automatically reset back to a Warrant because a future date was used. It is important to obtain, verify and enter corrected banking information before the future effective date arrives to prevent additional errors.    Instructor notes: Return or Reject means the employee’s IT0009 record will be automatically reset back to a Warrant. Do not reenter an account number that has been rejected in the prenote process! It will be rejected a second time, and penalties can occur. ·  Any correction Transactions with codes C01-C07 will automatically update the employee's Bank Details (0009) with the new information. ·         Any Corrections with codes C08 and higher will only be reported, and the user must determine the appropriate course of action. Failed -prenote has failed but the IT0009 record has not been automatically reset back to a Warrant because a future date was used. It is important to obtain, verify and enter corrected banking information before the future effective date arrives to prevent additional errors.   

    28. 27 Logged Changes in Infotype Data Helps identify data changes according to personnel numbers, Infotype and/or date and time.  Run this report daily Refer to the OLQR User Procedure: Logged changes in infotype data Access the Logged Changes in Infotype Data by using the transaction code S_AHR_61016380

    29. 28 Logged Changes in Infotype Data Fields to complete: Long-term documents Short-term documents Personnel Number Infotype Changed on Changed by Select Sort order Click (Execute) to generate report. Instructor: If you have class access report as you explain: Data to key into selection screen: Fields to complete: Check Long Term Check Short Term Infotype- 0006 (Address) Changed on: 1/1/2009-1/15/2009 Check direct output of docs Instructor: If you have class access report as you explain: Data to key into selection screen: Fields to complete:Check Long TermCheck Short TermInfotype- 0006 (Address)Changed on: 1/1/2009-1/15/2009Check direct output of docs

    30. 29 Logged Changes in Infotype Data cont’d. Action types: D- (Delete) indicates a record was deleted I – (Insert) indicates a record was created using the create icon U – (Update) indicates a record was changed using the pencil icon Tip: Fields with an *- indicate the field was changed. Action types: D- (Delete) indicates a record was deleted I – (Insert) indicates a record was created using the create icon U – (Update) indicates a record was changed using the pencil icon Tip: Fields with an *- indicate the field was changed.

    31. 30 Basic Infotype Check The report helps to identify any employees with missing data. Run this report at the beginning or end of each day to help eliminate errors during payroll. Refer to the OLQR User Procedure: Preemptive Basic Data Check Access the Basic Infotype Check by using the transaction code ZHR_RPTPYN06 Note: Run this report whenever you are hiring a new employee or changing employee’s master data for transferred employees. This will help you keep current as you are changing the employees master data. This report can be ran by the: * Payroll Processor * Payroll Analyst * Payroll Inquirer * Payroll Supervisor * Personnel Administrator Processor * Personnel Administrator Supervisor * Personnel Administrator Inquire Note:Run this report whenever you are hiring a new employee or changing employee’s master data for transferred employees. This will help you keep current as you are changing the employees master data. This report can be ran by the:* Payroll Processor* Payroll Analyst* Payroll Inquirer* Payroll Supervisor* Personnel Administrator Processor* Personnel Administrator Supervisor* Personnel Administrator Inquire

    32. 31 Basic Infotype Check cont’d. Fields to complete: Payroll area Personnel area Uncheck Infotypes: 0168 Insurance Benefit 0208 Work Tax Area 0235 Other Taxes* Click (Execute) to generate report. Note: Infotypes 0168 and 0208 are not currently used. Infotype- 235- Is used to exempt employees from paying specific taxes. Transferring employee into your agency may already have this inftoype created, so you may want to leave 235 check. If you have employees questioning this, advise them to speak with their tax people to determine if they are exempt or not. Agencies need to receive information from employees indicating that they are exempt before this can be used. ** Employees who transfer may have an IT 235 (other taxes) and IT 27(cost distribution) record from the prior agency that may need to be delimited.

    33. 32 Basic Infotype Check cont’d.

    34. 33 Preemptive Time Data Check Helps identify any ZCATA time transfer errors. Run this report when time data has been transferred via the ZCATA action into HRMS Refer to the OLQR User Procedure: Preemptive Time Data Check Access the Basic Infotype Check by using the transaction code ZHR_RPTPYN07 A batch process (ZCATA) transfers time data entered in CATS to HRMS.  The information populates infotypes absences (2001) and employee remuneration info (2010).  When payroll runs, the time information is pulled to compute an employees pay from these two infotypes.  Run this report anytime that a time transfer has occurred as well as when GAP1 information has been sent to HRMS. This report can be ran by the: * Payroll Analyst A batch process (ZCATA) transfers time data entered in CATS to HRMS.  The information populates infotypes absences (2001) and employee remuneration info (2010).  When payroll runs, the time information is pulled to compute an employees pay from these two infotypes.  Run this report anytime that a time transfer has occurred as well as when GAP1 information has been sent to HRMS.

    35. 34 Preemptive Time Data Check Fields to complete: Payroll Area Personnel Number Personnel Area Check Missing Attendance Enter Wage types Enter Absence types Check Missing Absences Click (Execute) to generate report This report will search for: Attendance checks: Select wage types that are allowed on Employee Remuneration Infotype (2010).  Examples would be: Wage Type 1290 Overtime  straight-all agy and Wage Type 1060 shift df .50 for all agys. Absence checks:  Select absence types that are allowed on Absences Infotype (2001).  Examples would be:  Absence type 9048 Sick Leave and Absence type 9003 Vacation Leave.

    36. 35 Preemptive Time Data Check cont’d.

    37. 36 Preemptive Compensation Data Check The Preemptive Compensation Data Check report helps to verify that all payroll master data is complete prior to running a payroll simulation This report validates (current payroll processing cycle): Arrears Deductions not taken Claims Payments and deductions limits Time quota compensation status Reversal checks Garnishments checks Refer to the OLQR User Procedure: Preemptive Compensation Data check Access the Preemptive Compensation Data Check by using the transaction code ZHR_RPTPYN08

    38. 37 Preemptive Compensation Data Check cont’d. Arrears: Can be created when a health or retirement deduction is adjusted in a previous pay period. Deductions Not Taken: When there is not enough net pay in the previous pay period to take the deducted wage type from pay. Claims: When the systems recognizes an overpayment situation in the previous pay period. Payments and Deductions Limits: When a payment or deduction amount is higher than normal and should be checked. Time Quota Compensation Status: When time entered does not match employee status. Garnishments Checks: When a garnishment has been created using the incorrect vendor number. Guided Note taking: Arrears is when an employee does _______ have _________ money for their _____________ and _____________ deductions to be taken in full for the current pay period the remaining amount is placed to be taken from the next paycheck. A deduction is not taken from the employee’s check due to the fact that either the __________ did _______ __________ ________and the limit was exceeded on a declining balance, or a monthly, quarterly or annual limit was exceeded. Claim occurs when an employee was ________ in a _________ ______ period and if the employee does not have enough money to repay an overpayment recovery. For example, an employee has agreed to have an overpayment recovery automatically taken from their next paycheck and the employee does not have enough money for the entire amount. Payment and Deduction Limit occurs when ______________ are not taken. This represents the _________ that are _____________ in the system such as the 401K annual limit of $14,000 pre-tax. Time Quota compensation status: Occurs when Time entered does not match the employee status when an hourly employee is set up as monthly or a part time employee is scheduled to work 40 hours. Garnishments checks: ____________ that __________ information for Writs, and support have been keyed in correctly. Guided Note taking: Arrears is when an employee does _______ have _________ money for their _____________ and _____________ deductions to be taken in full for the current pay period the remaining amount is placed to be taken from the next paycheck. A deduction is not taken from the employee’s check due to the fact that either the __________ did _______ __________ ________and the limit was exceeded on a declining balance, or a monthly, quarterly or annual limit was exceeded. Claim occurs when an employee was ________ in a _________ ______ period and if the employee does not have enough money to repay an overpayment recovery. For example, an employee has agreed to have an overpayment recovery automatically taken from their next paycheck and the employee does not have enough money for the entire amount. Payment and Deduction Limit occurs when ______________ are not taken. This represents the _________ that are _____________ in the system such as the 401K annual limit of $14,000 pre-tax. Time Quota compensation status: Occurs when Time entered does not match the employee status when an hourly employee is set up as monthly or a part time employee is scheduled to work 40 hours. Garnishments checks: ____________ that __________ information for Writs, and support have been keyed in correctly.

    39. 38 Preemptive Compensation Data Check cont’d. Enter the Payroll Area. Choose to search by Current period or Other periods. Enter values as appropriate. Scenario: You have made some adjustments to some employees deductions and want to make sure that their payroll master data has been set up correctly into HRMS. The Payroll Area signifies how payroll is run. You can search for Current period or Other periods. Current period pulls data from the time period that you run the report. Other periods allow you to choose more than one period including those not during the time period that you run the report. In period will display current payroll information For-period Prior period that was processed in the current payroll period due to a retro calculation in that period For example, an adjustment was made on 6/25/09 impacting the 5/10/09 payroll, this change will display 9/20XX indicating a retro was been made to the 5/10/2XXX payroll.Scenario:You have made some adjustments to some employees deductions and want to make sure that their payroll master data has been set up correctly into HRMS. The Payroll Area signifies how payroll is run. You can search for Current period or Other periods.Current period pulls data from the time period that you run the report.Other periods allow you to choose more than one period including those not during the time period that you run the report.In period will display current payroll information For-period Prior period that was processed in the current payroll period due to a retro calculation in that period For example, an adjustment was made on 6/25/09 impacting the 5/10/09 payroll, this change will display 9/20XX indicating a retro was been made to the 5/10/2XXX payroll.

    40. 39 Preemptive Compensation Data Check cont’d. Fields to complete: Personnel number (s) Personnel area Personnel subarea Employee group Employee Subgroup Under the Infotype selection choose an infotype to validate by clicking the checkbox. Click (Execute) to generate report.

    41. 40 Preemptive Compensation Data Check cont’d.

    42. 41

    43. 42 Step 2. Run Payroll Simulation/View Log A payroll simulation is the process used prior to running payroll that allows you to: Check for infotypes needed in payroll that might be missing from an employee’s master data. Verify that employee master data is valid. Verify what the employee is paid. Find red lines. Use the payroll simulation to evaluate an individual’s employee payroll results or the results of a group of individuals. Refer to the OLQR User Procedure: Payroll Simulation Access the Payroll Simulation using the transaction code: PC00_M10_CALC_SIMU

    44. 43 Run a Payroll Simulation cont’d. 1. Click to get the screen for simulation processing (as seen to the right). 2. Enter: Payroll Area Current period or Other period Personnel Number Schema 3. Choose the Display log checkbox. If you need to run the simulation for more than 5 employee’s do not check the display log. 4. When finished, click (Execute) to generate report.

    45. 44 Step 3. Viewing Results: Display Log Tree The Display Log Tree report is divided into six main folders: General Data Successful Personnel Numbers Rejected Personnel Numbers Processing at End of Selection Messages Statistics Drill down to see more selections by clicking the folder icon.

    46. 45 Viewing Results: Successful Personnel Numbers 1. Click Successful personnel numbers to display the personnel numbers of employees who successfully run through the payroll simulation. 2. Click on the employee name, then the payroll date to drill down to the USPS Payroll folder. 3. Click on the Final Processing USA folder to get to employee results tables.

    47. 46 Viewing Results: Successful Personnel Numbers cont’d. A list of folders display. Double Click RT to display the Results Table.

    48. 47 Viewing Results: Successful Personnel Numbers cont’d. The employee Results Table shows deductions and wage types and their corresponding amounts. For example, the Total Gross for this employee is $2,444.00. The total miscellaneous deductions and allowances (/110) is $170 Explain slide then give class time to review handout pages 4-7 which breaks the wage types of the paysim. For a list of code and account descriptions: go to: http://www.dop.wa.gov/HRMS/CustomerSupport/Resources/ Explain slide then give class time to review handout pages 4-7 which breaks the wage types of the paysim. For a list of code and account descriptions: go to: http://www.dop.wa.gov/HRMS/CustomerSupport/Resources/

    49. 48 Viewing Results: Rejected Personnel Numbers Identifies red line errors including: Missing or incomplete infotypes Invalid pay scale information Incorrect payroll area information After changes are made to an employee’s master data, rerun the payroll simulation to verify changes are complete. The error message of this screen shot specifics the date up to which payroll accounting has been run for the employee. Payroll accounting cannot be run for personnel numbers which are to be accounted in a payroll periods in which the end date is before the Accounted To date on infotype Payroll status (0003) For example: The January payroll cannot be repeated once the payroll accounting has been executed for February. To correct this red line for this screen shot: Access the employees Payroll Status (0003) infotype and remove the Earl.pers.RA date under the Payroll/Retroactive Accounting section of the screen. Common Red Line errors include: Division by Zero- usually caused by an error on Basic Pay (IT 08) Basic pay must be valid for the entire pay period Missing IT 0209 (Unemployment State)- required infotypes. dates for this infotypes should match employees hire date. Missing IT 0210 (Withholding info for W4/W5 US) is the tax authority FED Multiple splits with wage type 1223 (Salaried Hours override) Caused by a salaried employee with a mid-period pay change on Basic Pay (IT 8)

    50. 49 Payroll Simulation – whole agency Use the Payroll Simulation as a tool to find redlines for your agency, sub agency, or employee. Click to add Personnel Area, Payroll Area to selection criteria. Fields to complete: Payroll area Payroll Period Personnel area Payroll area Schema Click (Execute) to generate report.

    51. 50 Payroll Simulation –whole agency

    52. 51 Payroll Simulation Helpful hints After corrections have been made run a Payroll Simulation, without the Display log checked using the code W- Payroll correction run. Run this simulation during payroll processing days only. Using the Payroll Correction will run the simulation for employee’s who had changes to their master data since the last payroll was processed by DOP.

    53. 52 Payroll Simulation Helpful hints cont’d. Select the Select W – Payroll Correction run This will run only employees who have had updates to their payroll master data. Click (Copy) to continue.

    54. 53 W-Payroll Correction Simulation Fields to complete: Payroll period Personnel Area Personnel Number Schema Click (Execute) to generate the report.

    55. 54 W-Payroll Correction Simulation cont’d. To correct: Ensure that the employee is hourly or salaried for the entire period and assigned a valid work schedule for the entire period.To correct: Ensure that the employee is hourly or salaried for the entire period and assigned a valid work schedule for the entire period.

    56. 55

    57. 56 Step 3 : Correct the Identified errors Run each of these reports prior to payroll cut-offs: Corrections and Returns for Agency ZHR_RPTPY151 Logged Changes in Infotype Data S_AHR_61016380 Basic Infotype Check ZHR_RPTPYN06 Preemptive Time Data Check ZHR_RPTPYN07 Preemptive Compensation Data Check ZHR_RPTPYN08 Payroll Simulation (PC00_M10_CALC_SIMU) Catching these errors and correcting them prior to the release of payroll helps to make sure that payroll is calculated correctly for the employee.

    58. 57 Review: Pre-Payroll Analysis

    59. 58 Payroll processing activities for Day 2 and 3

    60. 59 Payroll processing activities for Day 2 and 3 Upon completion of this section, you will be able to: Understand the tasks and responsibilities for processing payroll. Work through the steps of processing payroll. Run reports to check employee payroll results. Correct payroll errors as needed.

    61. 60 New Terms

    62. 61 Process Payroll: Tasks / Responsibility

    63. 62 Step 1: Release Payroll At 6:00p.m. on the evening of the 1st business day of payroll processing, DOP releases payroll. During this time, all employee records are locked and therefore can not be accessed to make updates during the running of payroll. Agencies do not have any responsibility during this step, however, should be aware that when system messages appear regarding locked payroll, this process is occurring. After corrections are made (Step 4), the process is repeated in order to run payroll again.

    64. 63 DOP processes payroll. This task occurs on the 1st business day for processing the prior payroll period. Like a simulation, running payroll produces reports and identifies errors that need to be validated and verified. These reports are addressed in Step 5 of the payroll process. DOP will check payroll results for any technical errors.

    65. 64 Step 3: Release for Corrections During this step, DOP unlocks the employee records that were previously locked during payroll run. This occurs each day until the final day of payroll processing. Agencies receive a list of corrections from DOP. Which includes RPCIPE and ALAS errors. Check the Spool file for errors (Payroll, ZCATA).

    66. 65 Step 4: Agency Checks Results and Correct Errors 1. Check the HRMS Payroll and Financials website for errors. 2. Access your spool file to check for rejected employee’s data. 3. Reports to run after payroll is released for corrections and prior to payroll exiting: Basic Infotype Check (ZHR_RPTPYN06) Preemptive Time Data Check (ZHR_RPTPYN07) Preemptive Compensation Data Check (ZHR_RPTPYN08) Payroll Threshold Report (ZHR_RPTPYNO9) Active Employees with No Retirement Deductions Taken (ZHR_RPTPY024) Wage Type Reporter (PC00_M99_CWTR) Remittance Detail (PC_M99_URMR) Payroll Posting Report (ZHR_RPTPY126)

    67. 66 HRMS Payroll and Financial Errors http://www.dop.wa.gov/payroll/HRMS/PayrollCalendarSchedules/Pages/HRMSPayrollFinancialErrors.aspx

    68. 67 RPCIPE & ALAS Errors_Day results

    69. 68 RPCIPE errors Are cost distribution errors that can be caused by a variety of conditions. Common cause of RPCIPE errors include: Changes to the employees: Position funding. Position relationship. Employee position information. Employee’s master data. Terminated employee errors. Cost distribution (Infotype 0027) end dating To assist agencies in correcting these errors DOP sends out “Common RPCIPE errors” document. Use the Preemptive Compensation Data check report (ZHR_RPTPYN08) selecting infotype 0027/1018 ( cost distribution)

    70. 69 ALAS errors Caused by claims from prior periods that are not offset in the current period. These errors cause the ALAS financials to be out of balance. If these errors are not corrected prior to DOP exiting payroll the employee will be locked out of the payroll process in HRMS. Use the Payroll Threshold Report (ZHR_RPTPYN09)

    71. 70 Error Spool File Run the Spool file after payroll has been run by DOP. Use the spool file to access Time, Payroll, and GAP 1, Reports. Errors that are found on the reports must be resolved before payroll is exited.

    72. 71 Accessing the Spool File

    73. 72 List of Spool Request The List of spool request displays all of the available reports on the spool file for your agency. Items will stay on the spool file for seven days. To view a report click the box next to the spool you want to view. Click (Display) to view the spool request.

    74. 73 ZCATA_RETSFR Error Messages In the example above: The first messages indicate that there was not enough quota 42 (Personal Holiday-shift) for the absence wage type 9047 on 12/26/2008 for the personnel number. The bottom message tells you that there was not enough quota 31 (annual) for the absent wage type 9003 on 12/31/2008 for the personnel number.

    75. 74 Payroll Results Spool Request Look for error messages highlighted in Red by scrolling down the report. The messages tell you what happened during the payroll run. You must correct any errors before payroll exits.

    76. 75 Gap 1 Time and Attendance Spool Request The Gap 1 Time and Attendance spool will only display if your agency provides a Gap1 file to HRMS. The message text will tell you what errors have occurred.

    77. 76 Displaying more than 10 pages and Printing Spool Select the spool you want to view by selecting the display button. If your file is more than 10 pages, click . Enter the number of pages for your report in the Display area. Click (Continue). An information window will pop up, click (Continue). Click (Print), if you need to print your report.

    78. 77 Exporting Spool to Excel 1. From the Menu Bar, click Spool Request/ Forward/ Save to local file. 2. A Save list in file window will pop up, click the radio button by spreadsheet. 3. Click (Continue). 4. A window to Choose the Directory of where you want to save your file will pop up. Enter a File Name for your document. 5. Click Generate. The Spool file is only available for seven (7) days on the Output Controller. It is recommended that you export your file to Excel. The Spool file is only available for seven (7) days on the Output Controller. It is recommended that you export your file to Excel.

    79. 78 Payroll Threshold Report Run the Payroll Threshold Report after payroll has been run by DOP. The report checks the accuracy of payroll run by displaying issues that have arisen after payroll has been processed. Refer to the OLQR User Procedure: Payroll Threshold Report To access this report, use the transaction code: ZHR_RPTPYN09

    80. 79 1. Click to access the screen shown to the right. 2. Enter the Payroll Area. 3 Choose to search by: Current period Other periods In-period view For-period view Enter values as appropriate. Accessing the Payroll Threshold Report Note: In-period view will be the current period that you are in when running payroll. For-period will be the prior period that was run because of retro calculations in that period. Example: If a change was made during period 7.2009 that had a effective date change during period 5.2009 then it will have an In-Period 7.2009, For-Period 5.2009. This will show you what is being processed in that previous period to cause the retro change you are going to see in the new 7.2009 period. A change in basic pay that was done in a previous period and there for retros back to show changes in all periods that now have to be processed with the new basic pay rate. Note: In-period view will be the current period that you are in when running payroll. For-period will be the prior period that was run because of retro calculations in that period. Example: If a change was made during period 7.2009 that had a effective date change during period 5.2009 then it will have an In-Period 7.2009, For-Period 5.2009. This will show you what is being processed in that previous period to cause the retro change you are going to see in the new 7.2009 period. A change in basic pay that was done in a previous period and there for retros back to show changes in all periods that now have to be processed with the new basic pay rate.

    81. 80 4 Choose a value to search by entering one of the following: Personnel number Personnel area Personnel subarea Employee group Employee Subgroup 5. Choose an area to validate by clicking the box: Arrears (created in current period) Claims Net pay<0 Gross Pay <0 Deductions not Taken Cost Dist Hrs>Available Hrs Net Pay Exceed Limit Retroactive Pay Exceed Limit Wage Types Exceeding Limit 6 Click (Execute). Accessing the Payroll Threshold Report cont’d.

    82. 81 Viewing Results: Payroll Threshold Report Note: There may be multiple messages for an employee. This may be due to retro payroll actions and this report will display a message for each payroll where the situation occurs. This report won’t give errors. Look for amounts that seem off. This is an ALV report, meaning you can customize the look, filter and sort the report as you wish. Move the column headers, or reorder the report by selecting the Change Layout button on the application toolbar.Note: There may be multiple messages for an employee. This may be due to retro payroll actions and this report will display a message for each payroll where the situation occurs. This report won’t give errors. Look for amounts that seem off. This is an ALV report, meaning you can customize the look, filter and sort the report as you wish. Move the column headers, or reorder the report by selecting the Change Layout button on the application toolbar.

    83. 82

    84. 83 Active Employee with No Retirement Deductions Taken Report Use to identify employees who did not have retirement subtracted from their pay during a particular payroll period. Run this report for a single pay period to validate that retirement deductions have been taken for all eligible employees. Refer to OLQR User Procedure: Active Employees with No Retirement Deductions Taken Access this report using the transaction code: ZHR_RPTPY024

    85. 84 Active Employee with No Retirement Deductions Taken Report 1. Enter the Payroll area. 2. Search by Current period or Other period. 3. Choose a value to search by entering one or a combination of the following: Personnel number (s) Personnel area Personnel subarea Employee group Employee subgroup 4. Click (Execute) to generate report. Instructor: Data to enter into selection criteria screen: Other period: 2/2010 Personnel Area: 3500—Sup of Pub. Instruction In the example, we chose the Payroll area 11 – Semimonthly. This is the Payroll area the State uses for regular payroll. We searched for a single pay period, the last pay period of 2006 (12/16 – 12/31).Instructor: Data to enter into selection criteria screen: Other period: 2/2010 Personnel Area: 3500—Sup of Pub. Instruction In the example, we chose the Payroll area 11 – Semimonthly. This is the Payroll area the State uses for regular payroll. We searched for a single pay period, the last pay period of 2006 (12/16 – 12/31).

    86. 85 Viewing Results: Active Employee with No Retirement Deductions Taken Instructor notes: This report does not display errors. It is used to validate retirement results. Position and Employee are ineligible for retirement- NOT enrolled. Instructor notes: This report does not display errors. It is used to validate retirement results. Position and Employee are ineligible for retirement- NOT enrolled.

    87. 86 Understanding Results: Active Employee with No Retirement Deductions Taken The comments that result help to determine where the error is. This slide explains what situation has occurred if the comment in the Comment field appears. For example, if the comment “Pos. eligible, EE eligible, not enrolled appears” you know that the employee is in a eligible position and is eligible for deduction, but a deduction is not enrolled and was not taken.The comments that result help to determine where the error is. This slide explains what situation has occurred if the comment in the Comment field appears. For example, if the comment “Pos. eligible, EE eligible, not enrolled appears” you know that the employee is in a eligible position and is eligible for deduction, but a deduction is not enrolled and was not taken.

    88. 87 Payroll Posting Report The Payroll Posting Report displays all General Ledgers and the Cost Coding. This report reads payroll posting data after it has been processed through payroll. Refer to the OLQR User Procedure: Payroll Posting Report Access this report using the transaction code: ZHR_RPTPY126 Instructor notes: The Payroll Posting report displays all postable wage types and the associated general ledgers and cost distributions. On Days 2 and Day 3 of payroll processing, agencies should run the payroll posting report to verify that they are only paying for their own industrial insurance risk classes. This report can be ran by: Payroll Processor Payroll Analyst Payroll Supervisor Payroll Inquirer Financial Reporting Processor Instructor notes: The Payroll Posting report displays all postable wage types and the associated general ledgers and cost distributions. On Days 2 and Day 3 of payroll processing, agencies should run the payroll posting report to verify that they are only paying for their own industrial insurance risk classes. This report can be ran by:Payroll ProcessorPayroll AnalystPayroll SupervisorPayroll InquirerFinancial Reporting Processor

    89. 88 Accessing Variants To access a variants: Click (Get Variant). Clear the created by field Click the Variant name you are selecting. Click (Choose). Tip: To search for State Wide Variants (SWV) Remove name/prnr from created by field and click execute or, Type SWV* in the variant field name, click execute to bring up all SWV associated with the report Current Statewide Variants for the Payroll Posting Report: SWV GL 5124 – Net pay and ded for GL 5124 (Salary and expenses– EE and ER shares SWV GL 5181 – Health Insurance deductions (Displays out of balance Health deductions) SWV GL 5187- Med Aid/Ins deductions (Collects all Medical Aid to be sent to L&I- can help with LNI quarterly reporting and 035 reconciliation. All med. Aid group numbers should start with agency number.) SWV GL 5188- Savings Bond Deds and Purch (Savings bonds-collect SWV GL 5189- Writ of Garnishment GL 5189 SWV MEDAID/IND- Recon for hrs and amount For a current list of Statewide Variants, refer to The Customer Support Web Site Under HRMS Resources/select Statewide Variant List: http://www.dop.wa.gov/HRMS/CustomerSupport/Resources/ Tip: To search for State Wide Variants (SWV) Remove name/prnr from created by field and click execute or, Type SWV* in the variant field name, click execute to bring up all SWV associated with the report Current Statewide Variants for the Payroll Posting Report: SWV GL 5124 – Net pay and ded for GL 5124 (Salary and expenses– EE and ER shares SWV GL 5181 – Health Insurance deductions (Displays out of balance Health deductions) SWV GL 5187- Med Aid/Ins deductions (Collects all Medical Aid to be sent to L&I- can help with LNI quarterly reporting and 035 reconciliation. All med. Aid group numbers should start with agency number.) SWV GL 5188- Savings Bond Deds and Purch (Savings bonds-collect SWV GL 5189- Writ of Garnishment GL 5189 SWV MEDAID/IND- Recon for hrs and amount For a current list of Statewide Variants, refer to The Customer Support Web Site Under HRMS Resources/select Statewide Variant List:http://www.dop.wa.gov/HRMS/CustomerSupport/Resources/

    90. 89 Payroll Posting Report Fields to complete: Pay period Business Area Click (Execute) to generate the report. Tip: run this report in the background for faster results. Steps for running a job in the back ground: Enter selection criteria Go to the Menu bar and select Program/ Execute in background: Click to select Under the General Properties folder double click: Select Send to SAP Spooler only for now Click the Green check mark to select Select Start Time from the Start Time pop up window. To view results, access your spool files (SP01) Note: For this screen shot the SWV GL 5187 was selectedTip: run this report in the background for faster results. Steps for running a job in the back ground: Enter selection criteria Go to the Menu bar and select Program/ Execute in background: Click to select Under the General Properties folder double click: Select Send to SAP Spooler only for now Click the Green check mark to select Select Start Time from the Start Time pop up window. To view results, access your spool files (SP01) Note: For this screen shot the SWV GL 5187 was selected

    91. 90 Payroll Posting Report The medical aid group numbers should always start with the agencies business personnel area. If an employee transfers into an agency and their risk class is not ended dated, the losing agencies risk class will appear on this report. Medical Aid risk class is brought up during the PA40 transaction and the new agencies risk class will need to be selected. If this is found, you will want to go into the employee’s Medical Aid Risk class using the copy function and change the risk class for the employee using the start date of the employee’s hire date into your agency. If an employee is hired into and agency and their risk class is still showing the losing agency numbers, the gaining agency is still responsible to pay, only the calculation will be off. Tip: Run this report on Days 2 and 3 of payroll processing to ensure that only your agency override group (risk class) is being paid. The medical aid group numbers should always start with the agencies business area/ personnel number.

    92. 91 Wage Type Assignment Run this report to view the list of all HRMS wage types and view the General Ledger account the wage type will post to in OFM’s Agency Financial Reporting System (AFRS) Refer to the OLQR User Procedure: Wage Type Assignment - Display G/L Accounts Access this report using the transaction code: PC00_M99_DKON This report can be ran by: Central Agency Inquirer Payroll Inquirer Financial Reporting Processor. This report can be ran by: Central Agency InquirerPayroll InquirerFinancial Reporting Processor.

    93. 92 Wage Type Assignment Fields to complete: Company Code Key Date Select Cost Planning Select Display as variable list Click (Execute) to generate the report. To view agency specific cost objective for a wage type, use the Tree view and key in specific wage types Note: Display as tree- drill down method. Not recommend if viewing all wage types. To view agency specific cost objective for a wage type, use the Tree view and key in specific wage types Note: Display as tree- drill down method. Not recommendif viewing all wage types.

    94. Wage Type Assignment This report displays: Wage Types Wage type name General Ledger number and name 93 Note: This report has a report layout default. To view the other columns: Select Change layout icon. Move all icons to display. Note: This report has a report layout default. To view the other columns: Select Change layout icon. Move all icons to display.

    95. 94 Wage Type Reporter Use Wage Type Reporter to run analysis on wage types used in the payroll process. This report is used to identify transactions automatically recorded in the Agency Sate payroll Revolving Account 035 in General Ledger (GL) 5199- Other payables. Refer to the OLQR User Procedure: Wage Type Reporter To access this report, use the transaction code: PC00_M99_CWTR

    96. 95 The following Variants have been created for statewide use: SWV GL 5199 – This report should be run each payroll to determine if the agency has any transactions that need to be transferred from the Agency 035 GL 5199 for employee deductions.  It is also used in 035 Reconciliation.  SWV HI ERSHARE-Employer health insurance costs SWV DEF COMP- Deferred compensation deduction Wage Type Reporter – Statewide Variants When accessing the variants remember to input your personnel area and update the payroll dates.  There is no need to save your own variants.  DOP recommends that you retrieve the state-wide variants for these are maintain by DOP and will stay current. SWV CFD – Charity Deduction SWV DEF COMP- Deferred compensation deduction SWV Non Perm’ to create a report for Non Permanent Tracking SWV DEP CARE- Dependent care deduction SWV GET-College Tuition program SWV LIFE- Employees with Life insurance SWV LTD-Employees with LTD SWV HI PRE TAX – This report is used to assist agencies in their YTD reconciliation and is a replacement of the health insurance MDR. SWV HI POST TAX – This report is used to assist agencies in their YTD reconciliation and is a replacement of the health insurance MDR. When accessing the variants remember to input your personnel area and update the payroll dates.  There is no need to save your own variants.  DOP recommends that you retrieve the state-wide variants for these are maintain by DOP and will stay current. SWV CFD – Charity Deduction SWV DEF COMP- Deferred compensation deduction SWV Non Perm’ to create a report for Non Permanent Tracking SWV DEP CARE- Dependent care deduction SWV GET-College Tuition program SWV LIFE- Employees with Life insurance SWV LTD-Employees with LTD SWV HI PRE TAX – This report is used to assist agencies in their YTD reconciliation and is a replacement of the health insurance MDR. SWV HI POST TAX – This report is used to assist agencies in their YTD reconciliation and is a replacement of the health insurance MDR.

    97. 96 Wage Type Reporter

    98. 97 Viewing Results: Wage Type Reporter

    99. 98 Instructor – Use OLQR while performing each transaction during the course and read the scenario from the Activity Guide. This activity should take approximately 20 minutes. Instructor – Use OLQR while performing each transaction during the course and read the scenario from the Activity Guide. This activity should take approximately 20 minutes.

    100. 99 Remittance Detail Report Is used to provide a list of warrants that are not mailed out centrally by OFM. This can act as the agencies Miscellaneous Deduction Register (MDR). Refer to the OLQR User Procedure: 3rd Party Reconciliation Access the Remittance Detail Report using the transaction code PC00_M99_URMR

    101. 100 Remittance Detail Report Fields to complete: Company Code Business Area Vendor Due Date Click (Execute) to generate the report.

    102. 101 Remittance Detail Report

    103. 102 Remittance Detail Print Preview Agencies can print the remittance detail and send to vendors along with their payments Displays: Vendor Name Amount being sent Due Date Number of employees Employee’s personnel number SSN Amount being paid by each employee

    104. 103 Step 5: Exit Payroll The final step in the processing of payroll is exiting payroll. DOP prepares the payroll data for printing of warrants and ACH transmission. DOP is responsible for exiting payroll. Exiting of payroll occurs on the morning of Day 4 prior to Day 4 activities starting. The exit process also loads the Payroll Results tables for outbound interfaces (financials, vendor payments). On the Morning of Day 4- DOP will send out a list of employees who were locked for the current payroll period. They still could be paid outside of HRMS by a manual warrant. Any errors can be fixed in the next payroll period but after payroll is exited, changes CAN NOT be made prior to warrants being released. The exit process also loads the Payroll Results tables for outbound interfaces (financials, vendor payments). On the Morning of Day 4- DOP will send out a list of employees who were locked for the current payroll period. They still could be paid outside of HRMS by a manual warrant. Any errors can be fixed in the next payroll period but after payroll is exited, changes CAN NOT be made prior to warrants being released.

    105. 104 Review Questions.

    106. 105 Reports to run after payroll is exited

    107. 106 Reports to run after payroll is exited Upon completion of this section, you will be able to access key HRMS payroll processing reports including: Payroll Journal (ZHR_RPTPPYN33) Negative Summary Records (ZHR_RPTPY455) Wages Not Subject to OASI/Medicare (ZHR_RPTPY632) Payroll Results Table (PC_PAYRESULT) Accrued and Mandatory Deduction Reports (ZHR_RPTPY010) Warrant/ACH register and Summary (ZHR_RPTPY635) Employee Year to Date (YTD) Payroll register (ZHR_RPTPY646) Payroll Posting Report (ZHR_RPTPY126)

    108. 107 Payroll Journal This report is used for Payroll certification based on the State of Washington Office of Financial Management State Administrative & Accounting Manual (SAAM) Chapter 25.20.30. http://www.ofm.wa.gov/policy/25.20.htm Before you can receive current results, DOP must execute a payroll run and have stored results during a payroll cycle. Signatures for certification should not occur until DOP has processed their final run for the payroll cycle and DOP has generated warrants and ACH. Access the Payroll Journal using the transaction code ZHR_RPTPYN33

    109. 108 Payroll Journal Fields to complete: Payroll area Current Period Other Period Personnel Area Personnel subarea Click (Execute) to generate the report.

    110. 109 Viewing Results: Payroll Journal Screen 1 of 2 Note: Once payroll has been exited, run and print this report, sign and file with payroll results. Hours are currently actual hours worked /5UT Wage Type.Note: Once payroll has been exited, run and print this report, sign and file with payroll results. Hours are currently actual hours worked /5UT Wage Type.

    111. 110 Viewing Results: Payroll Journal Screen 2 of 2

    112. 111

    113. 112 Negative Summary Records Report Use the Negative Summary Records report to identify any negative third party remittances that may have been generated from: Warrant cancellation Credit / Miscellaneous Deductions Retroactive Change Run this report for every payroll to have documentation of any negative deductions and for fund reconciliation. Refer to the OLQR User Procedure: Negative Summary Records Access the Negative Summary Records report using the transaction code ZHR_RPTPY455. This report can be ran by the: * Payroll Processor * Payroll Analyst * Payroll Inquirer * Payroll Supervisor * Financial Reporter * Financial ApproverThis report can be ran by the:* Payroll Processor* Payroll Analyst* Payroll Inquirer* Payroll Supervisor* Financial Reporter* Financial Approver

    114. 113 Negative Summary Records Report Fields to complete: Payroll Area Other Periods Business Area Click (Execute) to generate the report.

    115. In this scenario, the Vendor (Simpson Community Federal CU) with the Vendor ID (2168100) did not receive the Amount of $605.00 due to a cancellation. To recover the amount, use the same processes or procedures that you currently employ in your agency (outside of HRMS). In this scenario, the Vendor (Simpson Community Federal CU) with the Vendor ID (2168100) did not receive the Amount of $605.00 due to a cancellation. To recover the amount, use the same processes or procedures that you currently employ in your agency (outside of HRMS).

    116. 115 Wages Not Subject to OASI/Medicare Displays employees who have wages not subject to OASI and Medicare. Employees exempt from OASI. Employees over OASI maximum Sick leave buyout not subject due to death or disability Dependant care Pretax insurance Refer to the OLQR User Procedure: Wages Not Subject to OASI/Medicare Access the Wages Not Subject to OASI/Medicare report using the transaction code ZHR_RPTPY632 Wages Not Subject to OASI/Medicare This report returns a list of employees with their total gross wages and wages that are subject to and not subject to Social Security and Medicare. This report can be ran by the: * Payroll Analyst * Payroll Supervisor * Payroll InquirerWages Not Subject to OASI/Medicare This report returns a list of employees with their total gross wages and wages that are subject to and not subject to Social Security and Medicare. This report can be ran by the:* Payroll Analyst* Payroll Supervisor* Payroll Inquirer

    117. 116 Wages Not Subject to OASI/Medicare Fields to complete: Period to date Personnel area Click (Execute) to generate the report.

    118. 117 Wages Not Subject to OASI/Medicare Screen 1 of 2

    119. 118 Wages Not Subject to OASI/Medicare Screen 2 of 2

    120. 119 Payroll Results Table Used to view the stored payroll results for a specific payroll run. Refer to the OLQR User Procedure: Payroll Results Access the Payroll Results Table by using the transaction code PC_PAYRESULT

    121. 120 Payroll Results Table Enter the Personnel number. To search for multiple personnel numbers use the (Multiple selection). Click (Enter).

    122. 121 Payroll Results Table In the Personnel numbers selected area, click the Pers.No. you wish to view. Payroll results for the chosen person are shown in the Payroll Results area. Double-click on the record you’d like to view in the Payroll Results area. Note: You can also highlight the payroll period of interest, by clicking on the payroll period record and clicking Display. Notice that the payroll records that appear in the Payroll Results area, are assigned a Status of Record. This status can be: A (current result) P (previous result) – Predecessor of current (a retro generated for a prior period would generate a “P”). O (old result) – Replaced by two retro payments, also a predecessor to “O”. For Period signifies the start of the period. In Period signifies what payroll the period is in. Note: You can also highlight the payroll period of interest, by clicking on the payroll period record and clicking Display. Notice that the payroll records that appear in the Payroll Results area, are assigned a Status of Record. This status can be: A (current result) P (previous result) – Predecessor of current (a retro generated for a prior period would generate a “P”). O (old result) – Replaced by two retro payments, also a predecessor to “O”. For Period signifies the start of the period. In Period signifies what payroll the period is in.

    123. 122 Payroll Results Table A list of payroll information for the chosen employee displays in the Payroll Results Area. To view the payroll results for this employee, double-click on RT in the Name column. You can also highlight RT and click Display. Instructor: Refer to Reading a Results Table hand out. While RT is selected to view the Payroll Results Table, other payroll information that can be viewed by highlighting the selection in the Name column and clicking Display include: WPBP – Basic employee / pay information RT_ - Same as the payroll results table, but information may be abbreviated CRT – Cumulative Results Table that lists year-to-date information and month end information CO/C1- Cost distribution- used to validate RPCIPE fixes- If no costing information on the position you will receive errors. DDNT- Final deductions not taken. ARRS- Arrears table- to display amounts in arrears. Instructor: Refer to Reading a Results Table hand out. While RT is selected to view the Payroll Results Table, other payroll information that can be viewed by highlighting the selection in the Name column and clicking Display include: WPBP – Basic employee / pay information RT_ - Same as the payroll results table, but information may be abbreviated CRT – Cumulative Results Table that lists year-to-date information and month end information CO/C1- Cost distribution- used to validate RPCIPE fixes- If no costing information on the position you will receive errors. DDNT- Final deductions not taken. ARRS- Arrears table- to display amounts in arrears.

    124. 123 Display Payroll Results This screen indicates that the payroll results for the chosen employee have successfully been captured. The report allows you to view: Total gross pay Social Security Tax Other payroll results display here including deductions and other types of earnings. Most deductions will show with a negative. These deductions are life, LTD, credit union, etc will add up to the /110 Net payment/deductions. Deductions that do not show with a negative are employer or provider taxes for federal and state in /4 wage types. This is the same as a payroll simulation- static information. The information found on this report is the final information for the reporting period.Other payroll results display here including deductions and other types of earnings. Most deductions will show with a negative. These deductions are life, LTD, credit union, etc will add up to the /110 Net payment/deductions. Deductions that do not show with a negative are employer or provider taxes for federal and state in /4 wage types. This is the same as a payroll simulation- static information. The information found on this report is the final information for the reporting period.

    125. 124

    126. 125 Accrued and Mandatory Payroll Deduction Reports Used to show: Medical aid and industrial insurance Court payments Social Security and Medicare for both employees and employer Retirement summaries by plan Refer to the OLQR User Procedure: Accrued and Mandatory Payroll Deductions Access this report by using the transaction code ZHR_RPTPY010. This report can be ran by the: * Payroll Processor * Payroll Analyst * Payroll Inquirer * Payroll Supervisor * Financial Reporting Processor * Financial ApproverThis report can be ran by the:* Payroll Processor* Payroll Analyst* Payroll Inquirer* Payroll Supervisor* Financial Reporting Processor* Financial Approver

    127. 126 Accrued and Mandatory Payroll Deduction Reports Click to access the screen shown to the left. Enter the Payroll Area. Enter the Period to search by: Current period Other periods In-period view For-period view Enter values as appropriate. Enter the appropriate selection in the Selections field. Select the Report Type. Click (Execute). Participant fill in the blank Selecting the ___________________________________radio button displays medical aid, industrial insurance, employee and employer shares by risk class. Selecting the ____________________________________radio button details court payments. Selecting the _____________________________________radio button displays the Social Security and Medicare for both the employee and employer. Selecting the _____________________________________radio button details retirement summaries by plan. Participant fill in the blank

    128. 127 Viewing Results: Accrued and Mandatory Payroll Deduction Reports – Medical Aid Note: To view employee level detail (Name of each employee appearing on this report, amount each employee paid) have your Personnel Administration Processor, PA Inquirer, PA Supervisor or Time and Attendance Supervisor, Inquirer, Processor run the Flexible EE Data Report (ZHR_RPTPYN02)Note:To view employee level detail (Name of each employee appearing on this report, amount each employee paid) have your Personnel Administration Processor, PA Inquirer, PA Supervisor or Time and Attendance Supervisor, Inquirer, Processor run the Flexible EE Data Report (ZHR_RPTPYN02)

    129. 128 Viewing Results: Accrued and Mandatory Payroll Deduction Reports – Court Payment This report displays agency name, the wage type court payment and the amount being sent to the vendor.This report displays agency name, the wage type court payment and the amount being sent to the vendor.

    130. 129 Viewing Results: Accrued and Mandatory Payroll Deduction Reports – Employee/State Mandatory Deductions This report displays the Medicare and OASI deductions for both employee and employer totals.This report displays the Medicare and OASI deductions for both employee and employer totals.

    131. 130 Viewing Results: Accrued and Mandatory Payroll Deduction Reports – Retirement Plans This report displays the Retirement deductions for both employee and employer totals by Plan.This report displays the Retirement deductions for both employee and employer totals by Plan.

    132. 131

    133. 132 Warrant/ACH Register and Summary Displays both detail and summary information for warrants and ACH. Refer to the OLQR User Procedure: Warrant/ACH Register and Summary Access the Warrant/ACH Register and Summary by using the transaction code ZHR_RPTPY635 This report can be ran by the: * Payroll Processor * Payroll Analyst * Payroll Inquirer * Payroll Supervisor * Financial Reporter * Financial Approver This report can be ran by the:* Payroll Processor* Payroll Analyst* Payroll Inquirer* Payroll Supervisor* Financial Reporter* Financial Approver

    134. 133 Warrant/ACH Register and Summary Fields to complete: Payroll Area Period Personnel area Select either: Summarize by Personnel Area Summarize by Personnel SubArea Summarize by Org Key Warrant Register ACH Register % Direct by Pers. Area % Direct by Pers. SubArea % Direct by Org. Unit Click (Execute) to execute the report.

    135. 134 Warrant/ACH Register and Summary Summary by Personnel SubArea

    136. 135 Warrant/ACH Register and Summary Summary by Personnel SubArea cont’d.

    137. 136 Warrant/ACH Register and Summary

    138. 137 Employee Year to Date (YTD) Payroll Register Use to view detailed results of employee’s year to date earnings totals. This report shows the year-to-date totals for Gross pay, Withholding tax, Social Security, Medicare, Deferred Compensation and Union Dues. This information is used to create an employee’s W-2 form and form 941 for IRS. Access the Employee Year to Date (YTD) Payroll Register using the transaction code ZHR_RPTPY646.

    139. 138 Employee Year to Date (YTD) Payroll Register 1. Enter one of the following: Personnel number (s) Personnel area Personnel subarea 2. Click the button. 3. Enter the Payroll Area. 4. Select Current period or Other Period, and In-period view or For-period view. 5. Click (Execute).

    140. 139 Viewing Results: Employee Year to Date (YTD) Payroll Register

    141. 140

    142. 141 Other Payroll Reports The following reports are also available to run for payroll purposes. Medical Aid Detail Report (ZHR_RPTPY394) – Displays quarterly gross salary (inclusive of wage types subject to Medical Aid only) and work hours by medical aid risk class code for the quarter Buyout Statements / Lag Leave (ZHR_RPTPY681) – Form that is mailed to employees eligible and have been given the option to buyout sick leave. Adjustments to Earnings Subject to Employment Security (ZHR_RPTPY123) – Used to read payroll posting data after it has been processed through ALAS. This report displays all the posted entries affected by an employee with a cancelled warrant. Buyout Statements/Lag Leave- Run this report to display Sick leave buy outs statements for employees who are over 240 hours Adjustments to Earnings Subject to Employment Security- Use this report to view entries posted to employees record by a cancelled warrant.Buyout Statements/Lag Leave- Run this report to display Sick leave buy outs statements for employees who are over 240 hours Adjustments to Earnings Subject to Employment Security- Use this report to view entries posted to employees record by a cancelled warrant.

    143. 142 Year End Reports The following reports are available for year end reporting in HRMS Form 1099R- (PU19)* Displays information reported on the 1099R Tax Statement (organization code, gross pension) W-2 Wage and Tax Statement- (PU19)* Displays employee’s wages and other information reported to IRS for calendar year W-2 Audit –(PU19)* Displays employees who received wages during calendar year and will receive a W-2 from the agency Transmitter Report and Summary of Magnetic Media (PU19)* Displays data transmitted to the Social Security Administration, summarizes wages reported Appointments with EIC at Year End - (ZHR_RPTPY675) Displays active employees who have Earned Income Credits (EIC) Sick Leave Over 480 – Non eligible report– (ZHR_RPTPY007) Identifies employees with more than 480 hours of sick leave who are not eligible for buyout. Note: Only end users assigned the Tax Reporter role will be able to run the transaction PU19Note: Only end users assigned the Tax Reporter role will be able to run the transaction PU19

    144. 143 Business Intelligence Reports The following reports are available Business Intelligence reporting in HRMS: Distribution of Payroll and Related Costs – Shows employer costs by employee and by AFRS account distribution Position Cost Report – Displays an audit for employer costs, full-time costs, overtime hours, overtime amounts, and shift differential amounts for each position and class title in an agency “Who Charged” Reporting – Displays the AFRS account code structure as to “who” is charged, hours worked, salary used, and organization structure

    145. 144 Review Questions Which report must be run, printed and signed to certify payroll each payroll ? Which report shows the year-to-date totals for Gross pay, Withholding tax, Social Security, Medicare, Deferred Compensation and Union Dues?

    146. 145 Payroll Outputs

    147. 146 HRMS Earning Statements When the payroll process is complete, earnings statements and warrants are distributed to agencies. HRMS earning statements are two-sided. Side 1 contains employee information and net pay. Side 2 contains a breakdown of earning types, allowances, mandatory deductions, voluntary deductions, and employer contributions. Refer to the OLQR User Procedure: Earnings and Deductions Statement Access Earnings and Deductions Statement using the transaction code ZHR_RPTPY711

    148. 147 Reprint Earning Statement Fields to complete: Enter the Payroll Area. Enter Pay Period. Enter the employee’s Personnel number. In the Payment Type Field select Both. Click (Execute).

    149. 148 Reprint Earning Statement cont’d. 1 of 2

    150. 149 Reprint Earning Statement cont’d. 2 of 2

    151. 150 EFT Employee Letter Used to create letters for employees informing them of direct deposit. The letter contains details of changes made to direct deposit including: Financial Institution Name and Number Type of Account Account Number Access EFT Employee Letter using transaction code ZHR_RPTPY713.

    152. 151 EFT Employee Letter Click on to display screen to the right. Fields to complete: Payroll Area Payroll period Personnel Number Click (Execute) to generate the report.

    153. 152 Printing the EFT Letter To preview the EFT Letter prior to printing, click Print preview. In the Spool Control Field, click Print immediately. To Print the EFT Letter, click Print.

    154. 153 EFT Employee Letter

    155. 154 Extended Payroll Scenarios

    156. 155 Extended Payroll Scenarios Upon completion of this section, you will be able to: Complete extended payroll scenarios including: Cancel a Warrant/ACH using the off-cycle reversal Find Overpayments Offsetting overpayments Recover Overpayments Mid-Period Transfers Recover a Manual Warrant

    157. 156 New Terms

    158. 157 Scenario 1: Cancel a Warrant/ACH 1. To access the off-cycle workbench use the transaction code: PUOC_10 in the command field. 2. Enter the Personnel Number. 3. Click on the Reverse payment tab. 4. Click the grey box to the left of the warrant/ACH you want to cancel. 5. Enter a Reversal reason. 6. Click Reverse. 7. Accept the error. The warrant is now cancelled. Notes: The Payroll Posting Report displays entries of employees that have cancelled warrants for a selected pay period. Use the SWV REV NETPAY- for warrant and EFT cancellations to verify the warrant/EFT were cancelled Notes: The Payroll Posting Report displays entries of employees that have cancelled warrants for a selected pay period. Use the SWV REV NETPAY- for warrant and EFT cancellations to verify the warrant/EFT were cancelled

    159. 158

    160. Scenario 2: Identify Cost Distributions To identify Employees with a Cost Distribution Infotype (0027) Employee Cost Distribution Report (ZHR_RPTFI0027) To identify the Cost Distribution Infotype (1018) by Position Position Cost Distribution (ZHR_RPTFI1018) User Procedures on the OLQR Cost Distribution- Employee (IT0027) Cost Distribution- Position (IT1018) 159 Instructor: Data to enter for ZHR_RPTFI0027 Effective date: Payroll Area: 1/16/2010- 1/31/2010 Business Area: 1000 Data to enter for: ZHR_RPTFI1018 Report effective date: 1/31/2010 Business Area: 1000Instructor: Data to enter for ZHR_RPTFI0027 Effective date: Payroll Area: 1/16/2010- 1/31/2010 Business Area: 1000 Data to enter for: ZHR_RPTFI1018 Report effective date: 1/31/2010 Business Area: 1000

    161. 160 Scenario 3: Find Overpayments Reports to run help identify overpayments: Payroll Simulation (PC00_M99_CALC_SIMU) Preemptive Compensation Data Check (ZHR_RPTPYN08) Run After Day 1 of payroll processing. Payroll Threshold Report (ZHR_RPTPYN09) Run After Day 1 of payroll processing. Payroll Posting Report (ZHR_RPTPY126) Run After Day 1 through Day 3 of payroll processing Use the ALAS communication Run ID and Doc #. Payroll Journal (ZHR_RPTPYN33) Payroll Results (PC_PAYRESULT) Wage Type Reporter (PC00_M99_CWTR) Use to Identify new HR actions, catch overpayments before they occur. When there has been a change to the employee’s master data, for example, a change to the employees Basic Pay (infotype 8) the system will automatically create wage type /551. A negative WT 551 = the ee is owed money A positive WT 551 = the ee OWES agency money In conjunction with the /551, a wage type /552 is also produced to show the money coming into the next payroll. This wage type will also be produced until it is cleared on a payroll. When the results display, Verify that the /551 and /552 wage types were created and note the amount of the last /552 wage type. Use the /552 amount in the Recover Overpayment procedure. Select Object Selection, to add Personnel Number to report. Refer to the user procedure Find Overpayments for more information. When there has been a change to the employee’s master data, for example, a change to the employees Basic Pay (infotype 8) the system will automatically create wage type /551. A negative WT 551 = the ee is owed moneyA positive WT 551 = the ee OWES agency money In conjunction with the /551, a wage type /552 is also produced to show the money coming into the next payroll. This wage type will also be produced until it is cleared on a payroll. When the results display, Verify that the /551 and /552 wage types were created and note the amount of the last /552 wage type. Use the /552 amount in the Recover Overpayment procedure. Select Object Selection, to add Personnel Number to report. Refer to the user procedure Find Overpayments for more information.

    162. 161 Scenario 4: Recover Overpayments Overpayments need to be recovered in HRMS. Since money can not be withheld from an employee’s check without his/her approval, you and the Payroll Processor must create a positive balancing adjustment that matches the overpayment amount. If you have the employee’s permission to collect the entire amount then you will not have to do anything in the system. HRMS will automatically process the claim and recover the overpayment. If you have an employee’s permission to recover the overpayment within an agreed amount of time use recurring deduction (Infotype 0014). This must be completed by the Payroll Processor. It is your responsibility for informing the Payroll Processor of any necessary changes to master data (including setting up a recurring deduction).

    163. 162 Scenario 4A. Create a positive balancing adjustment 1. Enter Transaction code PA30 in the command field. 2. Enter the Personnel Number 3. Click the tab. 4. Select or type 15 in the direct selection. 5. Click (Create) to create. Scenario: You have not yet received permission from Austin Power’s to collect his overpayment of $600 from his future paychecks. You need to create a positive balance adjustment that matches the net overpayment amount, so that HRMS does not withhold monies from his paychecks. Since money can not be withheld from an employee’s check without his/her approval, the agency creates a positive balance adjustment that matches the Gross overpayment amount, so that nothing will be withheld from the employee’s check until repayment arrangements can be made. WT 3231 (Gross Adjustment) must be set up to stop the process from happening automatically and to set up the receivable to wait for the appropriate payment plan. Note: If the employee’s approval can not be obtained prior to payroll cutoff, enter wage type 3231- Gross Adjustment to each pay period that is affected by the payroll, doing this sets up the receivable in Fund 035/GL 1324. Scenario:You have not yet received permission from Austin Power’s to collect his overpayment of $600 from his future paychecks. You need to create a positive balance adjustment that matches the net overpayment amount, so that HRMS does not withhold monies from his paychecks. Since money can not be withheld from an employee’s check without his/her approval, the agency creates a positive balance adjustment that matches the Gross overpayment amount, so that nothing will be withheld from the employee’s check until repayment arrangements can be made. WT 3231 (Gross Adjustment) must be set up to stop the process from happening automatically and to set up the receivable to wait for the appropriate payment plan. Note: If the employee’s approval can not be obtained prior to payroll cutoff, enter wage type 3231- Gross Adjustment to each pay period that is affected by the payroll, doing this sets up the receivable in Fund 035/GL 1324.

    164. 163 Scenario 4A. Create a positive balancing adjustment cont’d. Fields to complete Wage Type Amount Date of Origin Click (Enter) to validate. Click (Save) to save.

    165. 164 Scenario 4B Create a recurring payment 1. Enter Transaction code PA30 in the command field. 2. Enter the Personnel Number 3. Click the tab. 4. Select or type 14 in the direct selection. 5. Click (Create) to create.

    166. 165 Scenario 4B. Create a recurring payment cont’d. 1. Enter start date 2. Select wage type 3223 (repay/plan deduction) 3. Enter amount of deduction. 4. Select Payment model 5. Click (Enter) to check entries. 6. Click (Save) to save. Start date: Must a current date or a future date. To date- DO NOT USE the CHECK date the deduction is to stop. Use the last day of the pay period deduction is to stop. Wage Type 3223-Repay/plan deduction. Important- Any overpayment (wage type 3223) must have an end date entered. Example: An employee was overpaid $800 and agrees to pay back $200 per period. Wage type 3223 – if the wage types does not have an end date and the balance has been satisfied, this will cause the employee to come up with a RPCIPE error. Wage type WT3223 has a dynamic action attached to it. When the wage type WT3223 is saved under the Recurring Payment Infotype 0014, an Additional Payment infotype (0015) record is created with a WT3224 (Repay balance). NOTE: IF THE DEDUCTION IS NOT EQUAL FOR ALL PAY PERIODS, YOU WILL NEED TO CREATE AN ADDITIONAL 3223/3224 with the remaining balance. (WITH A START DATE AFTER THE LAST DEDUCTION) TO COLLECT THE REMAINING AMOUNT. EXAMPLE: EMPLOYEE OWES 1999.11, AGREES TO PAY BACK $333 a pay period for the next 6 pay periods= the employee will still owe $1.11- this amount will need to be collected. Enter WA04-every pay period- full amount. Always use WA04 on infotype 14-Recurring payments. Click enter to validate entries Click save Once you click save you will automatically be taken to Infotype 15-Additional Payments to create the declining balance. Tip: If Payment plan is crossing over years, you will need contact OFM, or the DOP Service Center for assistance. Start date: Must a current date or a future date. To date- DO NOT USE the CHECK date the deduction is to stop. Use the last day of the pay period deduction is to stop. Wage Type 3223-Repay/plan deduction. Important- Any overpayment (wage type 3223) must have an end date entered. Example:An employee was overpaid $800 and agrees to pay back $200 per period. Wage type 3223 – if the wage types does not have an end date and the balance has been satisfied, this will cause the employee to come up with a RPCIPE error. Wage type WT3223 has a dynamic action attached to it. When the wage type WT3223 is saved under the Recurring Payment Infotype 0014, an Additional Payment infotype (0015) record is created with a WT3224 (Repay balance). NOTE: IF THE DEDUCTION IS NOT EQUAL FOR ALL PAY PERIODS, YOU WILL NEED TO CREATE AN ADDITIONAL 3223/3224 with the remaining balance. (WITH A START DATE AFTER THE LAST DEDUCTION) TO COLLECT THE REMAINING AMOUNT. EXAMPLE: EMPLOYEE OWES 1999.11, AGREES TO PAY BACK $333 a pay period for the next 6 pay periods= the employee will still owe $1.11- this amount will need to be collected. Enter WA04-every pay period- full amount. Always use WA04 on infotype 14-Recurring payments. Click enter to validate entriesClick save Once you click save you will automatically be taken to Infotype 15-Additional Payments to create the declining balance. Tip: If Payment plan is crossing over years, you will need contact OFM, or the DOP Service Center for assistance.

    167. 166 Scenario 4B. Create a recurring payment cont’d. 1. Select the wage type 3224 (RePay balance). 2. Enter the Amount- entire amount of the claim. 3. Date of origin. 4. Click (Enter) to check entries. 5. Click (Save) to save. Tip: If the amounts entered for wage type 3223 (Repay/Plan deduction) and 3224 (Repay blance) do not equal each other, this will cause a RPCIPE error. To assist with correcting, refer to the Documentation Common RPCIPE error causes Most likely cause: Please see error #5 & 6 as described in "Common RPCIPE Errors" Tip:If the amounts entered for wage type 3223 (Repay/Plan deduction) and 3224 (Repay blance) do not equal each other, this will cause a RPCIPE error. To assist with correcting, refer to the Documentation Common RPCIPE error causes Most likely cause: Please see error #5 & 6 as described in "Common RPCIPE Errors"

    168. Scenario 4C. Overpayment paid with personal check Enter Transaction code PA30 in the command field. Enter the Personnel Number Click the tab. Select or type 14 in the direct selection. Click (Create) to create. 167

    169. Scenario 4C Overpayment paid with personal check cont’d. Fields to complete: Start Wage Type Amount Click (enter) to validate your entries Click (save) to save entries 168 Note: The start date must be a date within current pay period. The TO date must either match the start date or be the last day of the current pay period.Note: The start date must be a date within current pay period.The TO date must either match the start date or be the last day of the current pay period.

    170. Scenario 4C. Overpayment paid with personal check cont’d. Verify Wage Type Amount Enter the amount Click (enter) to validate entries Click (save) to save entries 169

    171. 170 Scenario 5: Mid Period Transfers Department of Personnel encourages managers to make hiring and termination dates align with pay periods (1st or 16th) when possible due to the complicated involvement for payroll processors of the losing & gaining agencies. In HRMS, when an employee transfers mid-period (Appointment Change), a single warrant / EFT is processed for that period. The agency that receives the transferring employee reports the entire pay period taxes and most deductions. The monies are automatically transferred from the losing agency to the gaining agency to cover their portion of the costs on the period After payroll is run, the losing agency no longer owns the employee. Therefore they will not see payroll results, payroll register, mandatory deductions, etc. All this will appear in the gaining agency. The losing agency will see transactions on the expenditure reports. The losing and gaining agencies transfer Journal Vouchers (transfer of money from losing agency to gaining agency). For information regarding Mid-period transfers HRMS and AFRS actions check out OFM’ website (http://www.ofm.wa.gov/resources/payroll.asp) Federal income taxes are paid by the gaining agency. The losing agency will reimburse the gaining agency through HRMS via automated JV. Retirement Hours and contributions are reported by the gaining agency for the entire period. Employee and Employer rates are based off the plan that the employee is currently enrolled in at time of transfer. The gaining and losing agency will record the employer share for the time that the employee worked in their 035-Payroll revolving account. A JV is then sent to the gaining agency for the amount of the losing agency's share. Both the gaining and losing and gaining agency will need to use the WBET system to correct their employer contributions. Medical Aid and Industrial Insurance is calculated based on the position that the employee is in at the end of the pay period. Health insurance Deductions are determined by where the employee was working on the last day of the pay period. Employee deductions and Employer expenditures are recording in the general ledger 5181 on the 10th and 25th of each month. On the 25th the monies are then sent to HCA via a journal voucher. Garnishments are calculated based on combined pay of losing and gaining agencies. The amount is accrued in the gaining agencies revolving (035). A manual JV to transfer the funds to the losing agency may be required. Third party vendors are paid by the gaining agency. Expenditures are recorded in each agencies operating/capital accounts and are transferred to each agencies Payroll Revolving Accounts 035. Then a transfer JV is automatically generated that transfers the employee and employer shares from the losing 035 Account GL5124 to the gaining agency Account 035 GL 5124. The gaining agency deposits and reports the taxes. This is the current design for retirement as well. WBET adjustments and coordination is required with DRS to report the retirement for the losing agency. For information regarding Mid-period transfers HRMS and AFRS actions check out OFM’ website (http://www.ofm.wa.gov/resources/payroll.asp) Federal income taxes are paid by the gaining agency. The losing agency will reimburse the gaining agency through HRMS via automated JV. Retirement Hours and contributions are reported by the gaining agency for the entire period. Employee and Employer rates are based off the plan that the employee is currently enrolled in at time of transfer. The gaining and losing agency will record the employer share for the time that the employee worked in their 035-Payroll revolving account. A JV is then sent to the gaining agency for the amount of the losing agency's share. Both the gaining and losing and gaining agency will need to use the WBET system to correct their employer contributions. Medical Aid and Industrial Insurance is calculated based on the position that the employee is in at the end of the pay period. Health insurance Deductions are determined by where the employee was working on the last day of the pay period. Employee deductions and Employer expenditures are recording in the general ledger 5181 on the 10th and 25th of each month. On the 25th the monies are then sent to HCA via a journal voucher. Garnishments are calculated based on combined pay of losing and gaining agencies. The amount is accrued in the gaining agencies revolving (035). A manual JV to transfer the funds to the losing agency may be required. Third party vendors are paid by the gaining agency. Expenditures are recorded in each agencies operating/capital accounts and are transferred to each agencies Payroll Revolving Accounts 035. Then a transfer JV is automatically generated that transfers the employee and employer shares from the losing 035 Account GL5124 to the gaining agency Account 035 GL 5124. The gaining agency deposits and reports the taxes. This is the current design for retirement as well. WBET adjustments and coordination is required with DRS to report the retirement for the losing agency.

    172. 171 Scenario 5: Mid Period Transfers: W/H, Social Security, Medicare In a mid-period transfer, the applicable employer share of expenditures are recorded in each agency’s operating / capital accounts and 035 payroll revolving account GL 5124. A transfer is then recorded automatically. This transfers the applicable employer share from the losing agency GL5124 to the gaining agency GL5124. Both the employer shares and employee shares of withholding, Social Security, and Medicare are paid and reported by the gaining agency. The gaining agency is responsible for reporting tax information on the 941 and W-2 reports.

    173. 172 Scenario 6: Recover A Manual Warrant

    174. 173 Scenario 6: Recover A Manual Warrant

    175. 174 Summary Throughout the course, you have learned how to: Explain the big picture (overview) of HRMS Payroll and Reports. Explain the new terms and concepts associated with HRMS Payroll and Reports. Complete the Pre-Payroll Analysis, including simulations and reports. Discuss the release of payroll completed in Process Payroll and how agencies are involved in correcting reports. View payroll results. Run and view payroll reports. Complete extended payroll scenarios.

    176. 175

    177. 176 Resources The following resources are available for your use: Department of Personnel’s Service Center (360) 664-6400 ServiceCenter@dop.wa.gov HRMS Resources http://www.dop.wa.gov/payroll/HRMS/HRMSSupport/Pages/HRMSResources.aspx The On-Line Quick Reference (OLQR) http://www.dop.wa.gov/payroll/HRMS/OnLineQuickReference/Pages/default.aspx The Office of Financial Management http://www.ofm.wa.gov/resources/payroll.asp

    178. 177

    179. 178 HRMS Message Center

    180. HRMS Data Definitions website: To ensure HRMS data is consistent and complete across agencies for agency-specific or statewide reporting purposes. Define HRMS data fields and define dropdown options where applicable. Identify erroneous data entry/coding practices. Work with agencies to begin cleanup efforts in HRMS. The following definitions have been identified: Contract Contract Type Employee Group Pay Scale Area HRMS Data Definitions website: To ensure HRMS data is consistent and complete across agencies for agency-specific or statewide reporting purposes. Define HRMS data fields and define dropdown options where applicable. Identify erroneous data entry/coding practices. Work with agencies to begin cleanup efforts in HRMS. The following definitions have been identified: Contract Contract Type Employee Group Pay Scale Area

    181. 180 Training Evaluation Please take a few minutes to complete the course evaluation and participant assessment prior to leaving.

More Related