...

•  1. Cost of Life Insurance Over $50,000.  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>Payroll Payments - Future or Payroll Payments - Current, enter the calculated life insurance cost as part of their final pay using a Pay Type of Life Insurance Premium. Click here for more information from the IRS regarding Group-Term Life Insurance and related costs.  Click here for the checklist regarding reporting taxable amounts of life insurance premiums. 
•  2.  Run the STRS Advance Reports to begin checking and balancing the reports.  You can also clear up errors that appear at this time.
  • Go to Reports>STRS Reporting>STRS Advance.
    • Sort By - Employee Name.  Can be changed from drop down if desired. 
    • Report Format - PDF.  Can be changed from drop down if desired. 
    • Starting Date for the Academic Year - Enter starting date for the academic year or choose the starting date of the academic year from the calendar.
    • Ending Date for the Academic Year - Enter ending date for the academic year or choose the ending date of the academic year from the calendar.
    • Click Generate Advance Fiscal Year to Date Report.
    • Click Generate Advanced Positions Report.
    • Click Non-Advance Positions Report.
  • Link to STRS Advance Common Errors & Warnings
  • Link to STRS Advance Balancing Slides 2024.pptx.pdf

Month-End Closing for June

...

•  12.  Balance the Quarter Report.
  • Go to Reports/Quarter Report.
    • Year - Choose year from drop down. Default should be current year.
    • Quarter - Choose from drop down. Default should be current quarter.
    • Sort By - Choose sorting option.
    • Click Generate Report.

  • Assure Total Adjusted Gross and Calculated Adjusted Gross on Quarter Report balance.

    Note
    icon false
    In the 'Totals Summary' section of the Quarter Report, the Calculated Adjusted Gross is calculated by the following:   Total Gross (Total gross paid on all Position records.) - Total Annuities (Total of Payroll Items with the Type equaling Annuity and all Adjustments.) +Non-Cash Earnings (Total of all Life Insurance paid using Payroll Payments - Future or Payroll Payments - Current) ----------------------- Calculated Adjusted Gross If in balance, the Total Gross paid on all Compensations minus the Total Annuities plus the Non-Cash Earnings should equal the Applicable Gross from the Core>Payroll Item>Federal records. This would be the case since the total gross from the jobs should equal the total gross from the Federal tax records. In other words, the gross paid on all jobs is potentially subject to federal taxation. If the 'Calculated Adjusted Gross' figure differs from the adjusted gross on the Federal tax records, an additional amount prints on the Quarter Report. This difference could represent manual adjustments or problems with annuity error adjustments and should be researched. For more information and specifics, please refer to the User Guide Chapter titled, "Quarter and Year-end Balancing."

    
    

  • Verify all Payee checks for the quarter equals the Payroll Items total listed on Quarter Report. (Including Electronic Transfer payments such as Federal and Medicare).
  • Verify the Total Gross on Quarter Report equals the total of all USAS payroll disbursement checks (on the USAS side>Transaction>Disbursements>Type=Payroll) processed for the quarter. (These are created from the USAS Integration>USAS Payroll Submission>Post to USAS process on the USPS side).
  • The total of all Employer Distribution amounts (if tracked on the system) should equal the total of all USAS disbursements.
  • For city withholdings, verify the Applicable Gross times the city tax percentage should equal the tax withheld.  Mobile employees can cause discrepancies.

...

...

•  

  20.  Verify and balance all STRS Advance reports.  

  Tip
  These reports can be run as many times as needed.

  • Go to Reports> STRS Reporting>STRS Advance.
    • Sort By - Employee Name.  Can be changed from drop down if desired.
    • Report Format - PDF.   Can be changed from drop down if desired.
    • Starting Date for the Academic Year - Enter starting date for the academic year or choose the starting date of the academic year from the calendar.
    • Ending Date for the Academic Year - Enter ending date for the academic year or choose the ending date of the academic year from the calendar.
    • Click Generate Advance Fiscal Year to Date Report.
    • Click Generate Advanced Positions Report.

    • Click Generate Non-Advance Positions Report.

  • Link to STRS Advance Common Errors & Warnings 

  • Link to STRS Advance Balancing Slides 2024.pptx.pdf

  • 
    

    Note
    icon false
    STRS Advance Reports: Advance Fiscal Year to Date Report - A complete list fiscal year-end report for all STRS employees.  Verify service credit and FYTD totals for each employee.  Criteria for employees to appear on the report: Employee must have a position with retirement system set to STRS Employee must have earnings in the fiscal year. Earnings are a sum of 3 things.  For an advancing compensation, the accrued wages will be added to earnings (accrued wages = contract obligation – amount paid – amount docked).  Adjustment journals of type Total Gross that are applied to the STRS item for the employee with a transaction date within the fiscal year will be added to earnings.  The applicable gross of historical STRS pay items paid to the employee on payrolls that are not imported from classic and have a pay date within the fiscal year will be added to earnings. Employee must have a contract compensation with a date range that falls within the fiscal year AND the compensation pays paid is not equal to pays in contract, -or- the compensation has been paid in the fiscal year, -or- Employee must have a non contract compensation with a date range that overlaps the fiscal year. To balance the Advance Fiscal Year to Date Report, the Taxed + Non Taxed Deposit Pickup should equal what has been paid to STRS to date plus the STRS Advance amount.  Advance amounts from the previous FY are not tracked on the report and are tracked separately behind the scenes.  Those figures come from the 450 (if Taxed) or 591 (if Non Taxed) and 691 (Pickup) withholding amounts for the current fiscal year (not including any advance amounts) and any new earnings that will be paid over the summer months while in advance. Advanced Positions Report - Lists all advanced positions for the district.  Verify that all positions listed are accurate and no one is missing.  Criteria for a position to advance: Employee must have a position with retirement system set to STRS and position must have a job status of Active or Inactive Employee must have a contract (or legacy) compensation with a date range that falls within the fiscal year. The compensation work days must equal the contract work days on the compensation or the compensation work days must equal the contract work days as of June 30 (determined by using work days from the calendars).  Contract work days and days in contract must be greater than 0.  Pays paid on the compensation must be less than pays in contract. The compensation contract obligation – amount paid – amount docked must be greater than 0. Non-Advanced Positions Report - Lists all positions not advancing. Verify all positions listed are accurate and no one is missing.  Compensation Adjustments in the Compensation screen can be used to update the Days Worked to correct.  Criteria for a position to not advance: Employee must have a position with retirement system set to STRS. Position must have a job status of Active or Inactive. Employee must have a contract compensation with a date range that falls within the fiscal year. The compensation pays paid must be less than pays in contract and there must be contract work days on the compensation greater than 0. The compensation work days does not equal work days in contract or the compensation work days does not equal the contract work days as of June 30 (determined by using work days from the calendars).

                   

•  21.  Generate the STRS Submission File.
  • Reports>STRS Reporting>STRS Advance>Generate Submission File.
  • Save the STRSADXX06.TXT to your computer.

...

•  22.  

  Status
  colour Green title If applicable

  Merge your STRSADXX06.TXT with your third party file.  The third party file will need to be in the proper STRS Annual Record Layout.  
  • Go to Reports>STRS Reporting>STRS Advance.
  • Upload Advance Submission File For Merge, click Choose File.  This is the Redesign STRSADXX06.TXT file. 
  • Uploaded File to Merge, click Choose File.  This is the third party file.  
  • Click Generate STRS Merge Report.  Verify the information in the report.
  • Click Merge Files.
•  23.  Upload the file to STRS.
  • Reports>STRS Reporting>STRS Advance.
  • Upload Submission File.  Click Choose File.  Browse to locate the STRSADXXXX.TXT file.
  • Click Submit Uploaded File to STRS.

...

• • Go to System>Configuration>STRS Advance Configuration.  
  • If the STRS Advance balanced, the Advance Amount should be 0.00, the Advance Mode checkbox should not be checked, the Amount Paid Back should be 0.00.  Nothing further is required.
  • If the STRS Advance did not balance, there will be values remaining.   These will need to be researched.
    • Run the Reports>STRS Reporting>Check STRS Advance report.   
      • Start Date - Enter the pay period start date of your first STRS advance pay in July.
      • End Date -  Enter the pay period end date of your last  STRS advance pay date.
      • Sort By - Select the same sort option that was selected when the STRS Advance Positions Report was run.
      • Report Format - PDF.  Can be changed using the drop down.
      • Generate.
    • Compare the amounts for each employee on the STRS Advance Positions Report and the Check STRS Advance Report. 
    • Report any discrepancies to STRS as prior fiscal year corrections.

    • Post Core>Adjustments for the 450 and/or 591/691 using the Total Gross (450) and Amount Withheld (591/691) and the Fiscal Year To Date date option.

      Tip
      Contact The Fiscal Team, mail_staff_fis@nwoca.org or 419-267-2808, if you have any remaining STRS advance amounts removed from STRS Advance Configuration

      
      

...