Iowa
Retirement Report Setup ProceduresNote: Complete the Iowa Retirement Report Setup Procedures for each employee who earned retirement before completing the steps listed below to generate the Iowa Monthly Retirement Report.
Iowa
Retirement Report Setup Procedures
From the Payroll screen, select the Government Reporting menu and then Iowa Monthly Retirement Report.
At the Iowa Monthly Retirement Report screen, click the Report Options tab and complete the information.
Enter the month for which to generate the report in the Ending Month field. Use the mm/yyyy format or click the down-arrow button to select the desired date. The default of the most recent (greatest) month used as the Processing Month in Payroll will appear, but can be changed.
Enter the number (up to 5 digits) assigned to your organization by IPERS in the Employer ID field.
If applicable, click the down-arrow button for the Hire/Rehire Date field to select the correct date custom field defined in the Employee File to track the Hire/Rehire Date for each employee.
Note: If this field is left blank (a Hire/Rehire custom field was not defined), or the Hire/Rehire custom date field is not completed for an employee, the most recent Hire/Rehire Date as entered in the Employee Dates List on the Employment screen in the Employee File will be reported as the Hire/Rehire Date.
Click the Save button.
Click the Pay Groups tab to select the pay groups to include on the retirement report.
Note: The pay groups defined (within the Pay Group File) to be included on the Iowa Monthly Retirement Report are selected by default, but can be changed if needed; if changes are made here, the changes will also be reflected in the Pay Group File.
To select a pay group, click the box under the Selected column to the left of the pay group ID. A checkmark will appear in the box if the pay group is selected.
To select all of the pay groups, click the Select All button located above the Pay Groups List.
Click the Save button.
Click the Deductions tab to select which deductions are set up for the various retirement options.
Tip: To lock a column in place so that it does not move while scrolling the information in the grid, click the pushpin located to the right of the desired column heading. Once the pushpin has been selected for a column, the pushpin will appear vertical to indicate the column is locked, and the locked column will move to the left and appear in front of all unlocked columns. To unlock a column, click the pushpin again; the pushpin will appear horizontal to indicate a column is unlocked. If the screen is closed and re-opened, or the Save button is clicked (if applicable), the settings for the pushpins will go back to the defaults.
For each retirement deduction, enter which share (Employee, Employer, or Both) of the deduction to include on the report in the field under the column for the appropriate category (Retirement - Employee and Retirement - Employer), or click the down-arrow button in the field under the appropriate category to select the correct one.
Click the Save button.
Click the Taxes tab to select which tax is set up for the Federal Unemployment Tax for use with the variance report.
For the appropriate tax, click the box under the Selected column to the left of the tax ID. A checkmark will appear in the box if the tax is selected.
Click the Save button.
The retirement report can then be generated to paper or a file (or both).
Printing to Paper:
From the Iowa Monthly Retirement Report screen, select the Reports menu and then select the desired report: Employee Earnings Report by Month, Employee Earnings Report by Quarter, IA Monthly Retirement Variance Report, IA Quarterly Retirement Variance Report, IA Wages Comparison Report, and IPERS Monthly Wage Detail.
Tip: The IPERS Monthly Wage Detail report contains the information to be submitted to the Retirement Office for the monthly contributions, while the other reports are optional and can be printed at any time. The optional reports can be printed as follows:
1) Print the Employee Earnings Report by Month or the Employee Earnings Report by Quarter if the Retirement Office requests a report of gross wages paid to each employee in each month or quarter of a particular year being audited.
2) Print the IA Monthly Retirement Variance Report to determine if there is a variance between the retirement gross and the FUTA gross wages for employees in the month being reported; normally, the retirement gross should equal the FUTA gross wages, and so this report will print an asterisk at the end of the line for any employee in the month that has a variance. If desired, print the IA Quarterly Retirement Variance Report instead to see if there is a variance with the grosses in a particular quarter rather than the month being reported.
3) Print the IA Wages Comparison Report to determine if an employee qualifies for IPERS by earning $1,000 or more in two consecutive quarters; an asterisk will print at the end of the line for those employees who do qualify as a reminder for you to set them up for IPERS.
4) Also, to see if someone who was set up with IPERS has had four consecutive quarters of non-payment and so would have to requalify for IPERS, print the Employee Deduction Report with the following options: specifying just your retirement deduction in the Deduction ID parameter; selecting all Rate Types except ‘Unused’; entering a date of one year ago in the To field for the Last Date Paid parameter; and then if desired, completing the Active Employee, Active Employee Deduction, Employee Status, and Pay Group ID parameters.
Creating a File:
Complete the Create Report File option.
Note: If there is an employee with a negative retirement gross for the month, a screen will appear after the file is created listing the employees with a negative retirement gross who were not included in the file.
After the retirement report is printed and the file created, click the X in the upper right-hand corner to close the screen.
