Page tree
Skip to end of metadata
Go to start of metadata

USPS-R Fiscal Year End Checklist

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" chapter of the USPS-R Appendix documentation.-  https://wiki.ssdt-ohio.org/display/uspsrdoc/Appendix

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

Month-End Closing

_____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

Quarter-End Closing

_____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


             Gross
             - Annuities
             ____________
             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.

https://wiki.ssdt-ohio.org/display/SMT/2017+ITC+Calendar+Year+End+Meeting?preview=/24084551/24215568/W2%20RECONCILIATION%20WORKSHEET.pdf

 _____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 (not yet named) 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


You have completed the USPS Fiscal Year End Closing procedures.

  • No labels