This procedure outlines the steps to be taken to close the USPS fiscal year.
Cost of Life Insurance over $50,000
_____1) For any employee that will be retiring at the end of the fiscal year, calculate the cost of life insurance over $50,000. Using the PAYROLL PAYMENTS-CURRENT or PAYROLL PAYMENTS-FUTURE program, the amount should be included as part of their final pay using a pay type of Life Insurance Premium. For an example and in depth discussion of the calculation process, refer to the Reporting Taxable Amount of Life Insurance Premiums.
EMIS Staff Reporting
____2) EMIS absence and attendance days are calculated for you through the job calendars and attendance posting. Make adjustments using CORE/ADJUSTMENTS.
____A) Click Create
____B) Find employee by typing a few characters of first or last name and then click on employee name
____C) Go to Type and choose EMIS Attendance or EMIS Absence from drop down option
____D) Enter in a Transaction Date
____E) Enter in the amount of days needed
____F) Click Save
_____3) Go to Reports/STRS Monthly Report (optional)
____A) Report Title-Default is STRS Monthly Report this can be changed if desired
____ B) Month-Choose the Month from the drop down
____ C) Year-Verify year-can be chosen from drop down
____ D) Sort By-Default is Employee Name this can be changed using drop down
____ E) Report Format-Choose format from drop down
____ F) Click Generate Report
_____4) Balance the payroll account (when statement is received from bank)
____A) Go to Reports/Report Manager/SSDT Outstanding Checks Report.
1- Format-Choose format from drop down
2- Page Size-Choose from drop down
3- Orientation- Choose from drop down (landscape/portrait)
4- Name-Default name is Outstanding Checks. Can be changed and named whatever desired
5- Summary Report- If you only want a summary report with totals check the box
6- Start Date-Enter in a start date in MM/DD/YY format
7- End Date- Enter in an end date in MM/DD/YY format
8- Click Generate Report
____B) Go to Payments/Check Register to reconcile checks manually or use Auto Reconcile.
1- Click the Auto Reconcile tab
2- Reconciliation Date- The current date is defaulted. Can be changed by using MM/DD/YYYY format
3- Pay Rec Format-Choose format from the drop down
4- Bank Account-Chose correct Bank Account from drop down
5- Click Choose File-Locate the file from the bank
6- Click Upload
_____5) Go to Processing/ Benefit Update and Projection /Accrual to accrue leave.
1- Report Title-Default name is Benefit Accrual Report. Can be changed if desired
2- Accrual or Projection-Default is Accrual Projection report. Choose from drop down. Recommendation is to process in Projection first
3- Benefit Accrual Option-Choose from drop down
4- Specific Accrual Date-Enter or chose from calendar the specific accrual date
5- Include Ineligible Positions-If you want to include ineligible positions check the box
6- Sort Options-Choose the sorting option from the drop down
7- Selects Pay Groups or Specific Employees-Move to the Selected box
8- Click Generate Report
9- Change Accrual or Projection to Accrual Report from the drop down
10- Click Generate Report
_____6) Go to Reports/ Quarter Report
1- Year-Choose year from drop down. Default should be current year
2- Quarter-Choose from drop down. Default should be current quarter
3- Sort By-Choose sorting option
4- Click-Generate Report
In the "Totals" section of quarter report, the gross and adjusted gross should balance using a manual calculation
Adjusted Gross Calculated
The Adjusted gross calculated should equal the adjusted gross amount from quarter report. This should be true for all adjusted gross figures in the "Totals" section.
_____7) All Payroll Item checks for the quarter should equal the total Payroll Items showing on quarter report. Be sure to verify the electronic transfers of federal and Medicare payments as well. This should be true for every Payroll Item.
_____ 8) The total gross showing on quarter report should equal the total of all payroll disbursement checks created during Payroll Posting to USAS for the quarter.
_____ 9) It is recommended that you balance the W2 Report quarterly to minimize problems at calendar year-end.
_____A) Go to Reports/W2 Report and Submission and check for any errors on the report.
1-Output Type-Click on the option you will be processing (report)
2- Format-Choose the format from the drop down
3- Report Title-Default is W2 Report. Can be changed to desired name
4- Federal ID Number-Defaulted to district Federal Id number
5- State ID Number-Defaulted to district State ID number
6- Kind if Employer-Choose from drop down
7- Sort Options-Choose sorting option from drop down.
8- Report for Year-Current year should be defaulted. Can choose from drop down if need
9- Click Generate Report
_____B) Complete and balance the W2 Report Reconciliation Worksheet for the quarter following the directions on the Worksheet.
_____C) Balance the Payroll Item totals (taxes and annuities) on the W2 Report with the totals from the Outstanding Payables reports from the quarter.
_____D) Balance the gross amounts on the W2 Report with Pay Reports for the quarter.
_____E) If errors are discovered, check employees that had exception processing during the quarter such as voided checks, error adjustments, or adjustments. The Audit Report (Reports/Report Manager/SSDT Audit Trail can be useful in identifying these problems.
1- Format-Choose format from drop down
2- Page Size-Choose from drop down.
3- Orientation-Choose from drop down (landscape or portrait)
4- Name- Default is Audit Report can be changed if desired.
5- Summary Report-If you only want a summary report click the box
6- Start Date- Enter a start date you wish to begin your audit from.
7- End Date- Enter an end date you wish to process the report through.
8- Click Generate Report
_____10) Go to Processing/Outstanding Payable and verify that there are no outstanding Payroll Items. (Screen should be empty)
_____11) The total of all Employer Distribution amounts (if tracked on the system) should equal the total of all USAS accounts payable checks to the vendor or deduction company.
_____12) Complete and file any required quarter-end submission forms.
_____13) For city withholdings, take the total gross times the percentage to be sure the tax withheld and submitted are correct.
Mobile employees could cause discrepancies.
_____14) Go to Reports/ODJFS Report.
1-Year-Default is current year. Choose year from drop down
2-Quarter-Current quarter should be defaulted. Can choose from drop down
3- Sort By-Choose sorting option from drop down
4- Click Generate Report
Check all totals carefully for accuracy. If necessary, go to Core/Adjustments and add the appropriate number of ODJFS weeks.
_____ 15) When all data is correct click on Generate Submission File
_____A) Transfer the file to your desktop or folder of your choosing and securely email the file to your ITC for submission
STRS Advance Processing
Even Though the board will not be advancing the money to STRS as in the past, the process for the annual reporting is the same as prior years.
♦ Employees flagged as full-time must have at least 120 service days to be granted a full year of service credit toward retirement. Employees flagged as part-time will be given credit according to STRS rules outlined in the STRS Employer's Manual. If you are in doubt about an employee's part-time or full-time status, contact STRS and obtain a ruling.
_____ 16) Go to Reports/STRS Advance.
1- Sort By-Choose sorting option from drop down option
2- Start Date for Academic Year-Choose or enter starting date for academic year
3- Ending Date for Academic Year-Choose or enter ending date for academic year
4- Click Generate Advance Fiscal Year to Date Report
5- Click Generate Advanced Positions Report
6- Click Generate Non-Advanced Positions Report
These options can be ran as many times as needed.
-The Advanced Positions Report lists all advanced jobs for the district.
-The Advance Fiscal Year to Date Report is the complete fiscal year-end report for all STRS employees.
-The Non-Advanced Positions Report lists STRS employees whose jobs will not be advanced.
Verify the data on the reports. On the Advance Fiscal Year to Date Report , check each employee's service credit and FYTD totals. At the bottom of this report, there is an amount labeled Taxed + Non-taxed. The amount shown should equal the amount deposited with STRS during the fiscal year plus the amount of accrued contributions on summer pays.
_____ 17) Once the data has been verified for the advance, in the Reports/STRS Advance click on the Generate Submission File option.
♦ This option will flag all eligible jobs as in advance mode, set the system Advance Mode flag and the create the Advance Amount figure. Each time Outstanding Payables are processed for STRS the Advance Pay Back field will be increased by the advance amount figure paid.
_____ 18) Notify your ITC letting them know that your STRS data has been submitted to STRS electronically.
_____ 19) *If applicable** If third party files need to be merged with the STRS advance file that was created send that third party file along with your advance file securely to your ITC. The ITC will combine the necessary data and securely email the file back to you so it can be submitted.
______A) Save the file to your desktop or a folder of your choosing
______B) Go to Reports/STRS Advance
______C) Click Choose File-Find your STRS Advance file
______D) Click Submit Uploaded File to STRS.
Quarter-End Closing Completion
_____ 20) A Surcharge report is in the process of being created and should be available by the end of July.
_____ 21) To remove prior fiscal year long-term illness days after the quarter end reports are printed you will want to use the Mass Change option in the Employee screen. (Contact ITC for assistance)
_____ 22) Add any long term illness days for the new fiscal year on the Employee record in the Long Term Illness field.
Post Fiscal Year-End Closing
Restrictions during the advance:
♦ Modifications cannot be made to certain fields on Position/Compensation records in the advance mode.
♦ Certain Pay Types cannot be processed on advance jobs REG or IRR
_____ 23) STRS follow-up on the Advance after all summer pays:
_____A) System/STRS Advance Configuration-At the time of the last advance payment if all advances have been paid correctly the Pay Back field will zero out and the Advance Mode flag will be turned off. The Advance Amount figure will need to be removed manually. If that figure is not removed it will be overwritten the following fiscal year by the new advance amount.
♦ After the advance is complete to find any discrepancies between what was contributed to STRS and what was reported on the advance submission tape file a report in the redesign, SSDT Check STRS Advance Report, can be ran to compare totals for each employee to those on the Advance Positions Report. Any employee showing a differing amount should be researched.
♦ Any difference should be reported to STRS as a prior fiscal year correction if necessary.
_____ B) Contact your ITC to have any remaining STRS advance amounts removed from STRS Advance Configuration