STRS Per Pay Report
STRS Report Options
After you have completed a payroll, you have five working days from the pay date to submit a file to STRS that is created using the STRS Report option under Reports.
The STRS Report uses the 591/691 withholding amounts and 450 Applicable Gross for the Member Earnings for reporting.
Field Definitions:
The Save and Recall option allows the users to create and save certain reports for different report runs for each report option. The Default option is the original SSDT report and the Most Recent is the last report that was ran by the user. If the report is no longer needed, click on to delete the report. The Default reports cannot be deleted.
Report Title: STRS Report is the default file name for the report. This can be changed by entering a new file name in the Report Title field.
Sort By offers the following choices:
- Employee Name
- Employee SSN
Select the Payment Method:
- Check
- Electronic
Enter the Check or Transaction number used to remit the contributions to STRS.
Format:
- PDF (download)
- Comma Separated Values
- Excel-Data
Select payroll from the Historical Payrolls grid:
Payroll Payments
The option below allows districts to include Voided and Un-voided Payments in the STRS file.
Select any additional payments to include from past payroll. Voided and Un-voided payments are shown below:
When all options are entered, click on
Generate Submission File
- Generate the submission file. There are 2 options available:
- To generate the submission file immediately:
- Click on to send the Submission file immediately to STRS. **Once clicked on, it will be disabled to avoid double-clicking and sending multiple submissions to STRS**
- To generate the submission file at a later date:
- Click on and then at a later time you can submit it to STRS. At a later date you would perform the following:
- Find the STRS.SEQ file by clicking on and finding the STRS Report you wish to upload.
- Upload the file by clicking on
- Click on and then at a later time you can submit it to STRS. At a later date you would perform the following:
Submit the file by clicking on - To generate the submission file immediately:
When a file is submitted to STRS, the STRSYYYMMDDXXXX.SEQ file is copied to the Utilities>File Archive>YYYY-STRS Reporting folder.
Calculating Regular and Retirement Pickup
Please click here for documentation on how Retirement is calculated.
Employee's with Full Pick-up on Pick-up with Extra Compensation (same goes for Partial Pick-up on Pick-up with Extra Compensation
The Employee's Dashboard under Payments for that payroll, will show the Payroll Item 450 Applicable Gross inflated for retirement purposes. The 691 Applicable gross is the employee's gross for that pay:
450 15.96%
691 15.96%
$3872.49 X 14% = $542.15
$542.15 X 14% = $75.90
$542.15 + $75.90 = $618.05/14% = $4414.64
The Inflated gross will show on the employee's 450 Payroll Item *TD Total and Applicable Gross $4414.64
The Amount Withheld will show on the employee's 450 Payroll Item *TD Employer Amount $542.15
The Regular Gross will show on the employee's 691 Payroll Item *TD Total and Applicable Gross $3872.49
The Amount Withheld will show on the Employee's 691 Payroll Item *TD Employer Amount $618.06
Explanation of the STRS Per Pay Report
Member Earnings
The Member Earnings is calculated by using the the Payroll Item>450>Total Gross.
Employer Pick Up
The Employer Pick Up amount is calculated by the Payroll Item(s) 591/691>Amount withheld.
- If needing to make Adjustments go to Core>Adjustments and use the following Type:
- 591 = Amount Withheld
- 691 = Board's Amount of Payroll Item
How STRS Days are calculated
The system first finds all checks for employees which have a pay date in the reporting month. The payroll beginning and ending dates for those checks determine the calendar date range for counting service days. This range very likely will start in the preceding month and end during the reporting month. From this information, blank working calendars are created on the system. Blank working calendars are used internally by the system and cannot be viewed.
The job calendars for employees which correspond to the date range from the first step are entered into the blank working calendars. The Attendance transactions (type Attendance or Absence) with paid dates in the reporting month are marked on the working calendars appropriately for each day. The calendars are "modified" inside the program to reflect the days from the calendars plus days from Attendance. So you can think of Attendance records as modifying the calendars on a per employee (or compensation) basis.
After the working calendars are built, the system counts the days for the date range and that is the total unadjusted service days.
The system then locates any Core>Adjustment with the Type equaling STRS Retirement Days. In order for the Adjustment days to be included on the STRS Per Pay Report, the Adjustment>Transaction Date must fall within the period beginning and end dates for payroll being reported. Normally this means the payroll Start Date and End Date: however, if the employee was added to the payroll using the additions option and a different Start Date and End Date were used and that would be the range the Adjustment would have to fall within. The Adjustments (if applicable) are added to or subtracted from the total service days from the working calendars. The total of the days from the working Calendars, Attendance and the Adjustments is the total service days that will appear on STRS Per Pay Report.
When initializing a payroll, the 'Add Date Range Selection' option can be utilized to add pay groups to the payroll using different Start Date and End Dates. This ensures retirement days are counted correctly.
- STRS Per Pay days are not included on the STRS Per Pay submission file sent to STRS. These days are included on the STRS Per Pay Report for verification purposes only. The STRS days will be on the STRS Advance FYTD Report and reported on the STRS Advance submission at fiscal year end time.
- An employee that is marked as 'Retired Retiree' and a 'Retired Date' (these fields are on the 450 Payroll Item) will show days on the STRS Per Pay Repot, but the days are not included on the STRS Per Pay submission file sent to STRS.
Type of Day | From | Is it a Service Day? |
---|---|---|
Work Day | Job Calendar | Yes |
Holiday | Job Calendar | Yes |
Calamity Day | Job Calendar | Yes |
Make-up Day | Job Calendar | No |
Attendance | Attendance | Yes |
Substituting | Attendance | Yes |
Dock | Attendance | not if it is a full dock day |
Corrections Needed if an Employee Was Not Marked as a Retired Rehired When They Should Have Been
The following adjustments are necessary if an employee was not marked as a rehired retiree when they returned to the district as a rehired retiree at the start of the fiscal year. After the creating the corrections in the steps below, the employee should be listed on the STRS Advanced reports with one line and the Rehired Retiree column will be set to Y.
- On the 450 Payroll Item, mark the Rehired Retiree checkbox and enter the rehired date in the Rehired Date field.
- The following adjustments will need to be created:
- Core>Adjustments - Payroll Item 450 using the Type of Portion of FTD Gross that was earned as a rehired retiree, enter the Amount equaling 450 Payroll Item>FYTD Total Gross, and check the Fiscal Year To Date checkbox.
- Core>Adjustments - Payroll Item 450 using the Type of Portion of FTD Board Amount that was earned as a rehired retiree, enter the Amount equaling 450 Payroll Item>FYTD Employer Amount, and check the Fiscal Year To Date checkbox.
- Core>Adjustments - Payroll Item 591 using the Type of Portion of FTD Amount that was withheld as a rehired retiree, enter the Amount equaling 591 Payroll Item>FYTD Withholding, and check the Fiscal Year To Date checkbox.
- (If applicable) Core>Adjustments - Payroll Item 691 using the Type of Portion of Board Amount that was earned as a rehired retiree, enter the Amount equaling 691 Payroll Item>FYTD Employer Amount, and check the Fiscal Year To Date checkbox.
After the adjustments have been created, verify the following:
- The 450 Payroll Item>FYTD Employer Amount should equal the FTYD Rehired Retiree Employer Amount and the FYTD Total Gross should match the Rehired Retiree Gross amount.
- The 591 Payroll Item>FYTD Withholding should equal the FYTD Rehired Retiree Withholding.
- (If applicable) The 691 Payroll Item>FYTD Employer Amount should equal the FYTD Rehired Retiree Employer Amount.
The following adjustments are necessary if an employee was not marked as a rehired retiree when they returned to the district as a rehired retiree at some point during the fiscal year. The employee will be listed on on the STRS Advanced reports with two lines. One line will list the information prior to retiring and the Rehired Retiree column will be set to N and the other line will list the information when the employee returned as a rehired retiree and the Rehired Retiree column will be set to Y.
- On the 450 Payroll Item, mark the Rehired Retiree checkbox and enter the rehired date in the Rehired Date field.
- The following adjustments will need to be created:
- Core>Adjustments - Payroll Item 450 using the Type of Portion of FTD Gross that was earned as a rehired retiree, enter the Amount equaling 450 Payroll Item>FYTD Total Gross that was earned as a rehired retiree, and check the Fiscal Year To Date checkbox.
- Core>Adjustments - Payroll Item 450 using the Type of Portion of FTD Board Amount that was earned as a rehired retiree, enter the Amount equaling 450 Payroll Item>FYTD Employer Amount withheld as a rehired retiree, and check the Fiscal Year To Date checkbox.
- Core>Adjustments - Payroll Item 591 using the Type of Portion of FTD Amount that was withheld as a rehired retiree, enter the Amount equaling 591 Payroll Item>FYTD Withholding withheld as a rehired retiree, and check the Fiscal Year To Date checkbox.
- (If applicable) Core>Adjustments - Payroll Item 691 using the Type of Portion of Board Amount that was earned as a rehired retiree, enter the Amount equaling 691 Payroll Item>FYTD Employer Amount as a rehired retiree, and check the Fiscal Year To Date checkbox.