- Go to Reports>STRS Reporting>STRS Advance.
- Generate the Non-Advance Positions Report. Are there employees listed that shouldn't be?
- Remember the criteria for an employee to appear on the Non-Advance Positions Report is the following:
- The employee must have a Position with the Retirement Code set to STRS and the Position must have a Job Status of Active or Inactive. Must also have a Contract or Legacy Compensation for the Position.
- The employee must have a Contract (or Legacy) Compensation with a date range that falls within the current date.
- The Compensation Pays Paid must be less than the Pays In Contract and there must be Contract Work Days on the Compensation greater than 0.
- The Compensation Pays Paid must be less than the Pays In Contract and there must be Contract Work Days on the Compensation greater than 0.
- The Compensation Contract Work Days does not equal the Contract Days Worked or the Compensation Contract Work Days must equal the Contract Days Worked as of June 30 (determined using work days from the calendars).
- Remember the criteria for an employee to appear on the Non-Advance Positions Report is the following:
- Generate the Advanced Positions Report. Are there employees listed or not listed that should/shouldn't be? Is the service credit for each employee correct? Are your rehired retirees listed as expected?
- Remember the criteria for an employee to appear on the Advanced Positions Report is the following:
- The employee must have a Position with the Retirement Code set to STRS and the Position must have a Job Status of Active or Inactive.
- The employee must have a Contract (or Legacy) Compensation with a date range that falls within the current date.
- The Compensation Contract Work Days must equal the Contract Days Worked or the Compensation Contract Work Days must equal the Contract Days Worked as of June 30 (determined using work days from the calendars).
- The Compensation Contract Work Days and Contract Days Worked must be greater than 0.
- The Compensation Pays Paid must be less than the Pays In Contract.
- The Compensation Contract Obligation – Amount Paid – Amount Docked must be greater than 0.
- Remember the criteria for an employee to appear on the Advanced Positions Report is the following:
- Generate the Advance Fiscal Year to Date Report. Is the service credit for each employee correct? Are your rehired retirees listed as expected? Begin balancing the figures in the Report Totals section.
- Generate the Non-Advance Positions Report. Are there employees listed that shouldn't be?
New This Year for Fiscal Year End Processing (for those districts who advance their employees):
Payrolls with a July or later pay date that are processed in the new fiscal year can not be processed unless the STRS Advance submission file has been generated. The following error will occur if the first payroll in July is initialized before creating the STRS Advance Submission file:
****RUNNING A PAYROLL IN JULY BEFORE RUNNING STRS ADVANCE ****
Prevent July payrolls until STRS Advance has been completed #6282; 6.89.0
Review, Reconcile, and Verify - FYE related USAS prep - Pat
- 5109 - Period H changes
- 4648 - 7/1 cash beg balances bug
- 5093 - tra/adv not included in fed ass’t
- Accounts Payable Report GAAP FYE
As you prepare for fiscal year end, here is some information to keep in mind for USAS ….
You can prepare your requisitions now for the new fiscal year, dating them 7/1/23, as long as your July 2023 Posting Period has been created and is OPEN. If July is not opened by the User, the system will automatically Open the July posting period during the process of closing June which also closes the fiscal year. The USAS Requisition Approval Workflow can also be utilized while still maintaining the 7/1/23 requested PO date entered when preparing the requisition.
The All Amounts Zero parameter on the Appropriation Resolution Reports has been updated to include accounts that may add up to zero, but were being previously being excluded because the ending balance was zero. For example, if an account had ($1000) appropriated with $1000 Prior FY Carry Over, the Appropriation of zero (0.00) will now be correctly reported on the Appropriation Resolution report.
After reviewing the Fiscal Year’s revenues and expenditures, the user should review their Federal Funds and create their FY23 Federal Assistance Summary record under the Periodic menu in USAS. This information will be included in the EMIS extract. By check marking the box 
the EMIS extract will indicate that the district/entity has expended more than $750,000 of federal funds in one year and thus, requiring a Single Audit to be performed. This is a more extensive Audit and was previously called the OMB Circular A-133 Audit. After creating the Federal Assistance Summary record, you can now clone the FY22 Federal Assistance Detail records to help create the same records for FY23. You will need to edit the cloned record to include the new Cash Account and figures. You may manually enter these Federal Contributions Received and Expended, but the system will populate the figures at the time when the Cash Account is selected. You can also set up an Account Filter for the Non-5xx cash accounts that may be needed to also include. To include these non-5xx funds, set up an Account Filter for read only access for the Fund needed such as: 
Important ! After your initial set up of your Federal Assistance Detail records, if expenditures or revenues change for any accounts reported, additional steps are needed to update the Federal Assistance Detail record’s figures. Please edit the record, click off the Cash Account assigned to the record and then re-select the correct Cash Account to update the figures. You may also update these manually. The figures will exclude any Transfers/Advances. You can verify the figures pulled in with the Cash Account on the Core>Account menu or via reports (i.e. Budget/Revenue Summary). 
NOT done !
As you prepare your Period H collection data, and prior to pulling this information from the SIF, keep in mind that the EMIS Fund Category value on the Cash Account (previously used to populate the ODE Brief Description) and Payables amount (optional ODE Element QC260) will show zero and will not be required per the EMIS updates 23-86 and 24-51 respectively.
The Accounts Payable report is also a report that should be generated and reviewed. The report default populates the last day of the fiscal year but may be edited. This report generates a report showing all payable amounts as of the last day of the fiscal year for GAAP reporting.
- Flag items as not encumbered as of this date?: If running the report for outstanding purchase orders after the end of a fiscal year and the report should show the actual amount which was encumbered as of June 30th then this should be left checked. Otherwise, uncheck this option.
- Include invoice date in selection?: Leaving this unchecked will cause the report to select items with received dates prior or equal to the user specified date. Checking this option will cause the report to select items with both received and invoice dates prior to the user specified date.
Useful links:
- SSDT Wiki
- May Release Recap
- Newsletters Home Page
- SSDT Documentation
- Inventory Documentation
- SSDT YouTube Channel
- Inventory YouTube Playlist
In May, the SSDT support staff recorded an EMIS Staff Common Errors training session we conducted with ITC staff. If you want to know more about how to resolve staff data collector errors, this recording is a must see! Our team reviewed how to debug common EMIS errors in USPS, digging deeper into some of the Level 1 errors generated and how to find and resolve them in USPS
Maintenance of Effort (MOE) is an Elementary and Secondary Education Act (ESEA) fiscal requirement that requires districts to demonstrate that the level of state and local funding remains relatively constant from year to year in order to receive the district’s full allocations of the grants under ESEA. A district’s education expenditures from general fund must be at least 90 percent of the prior year amounts. It is the State’s responsibility to determine annually whether a district has maintained effort.
Prior to funding for the new year, ODE annually compares the district's local or state and local expenditures to ensure that the district budgets and expends at least the same amount of funds as the previous year. Before submitting your FY23 data
Prior to funding, ODE annually compares the district’s local or state & local expenditures to ensure that the district budgets &
expends at least the same amount of funds as the previous year
Budget Summary MOE Report roduces a budget summary report containing the accounts involved in the Maintenance of Effort - IDEA.
You can review the expenditures
prior
to these being reported to
EMIS by running this report
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Topic #2 - Reporting Entity Summary Report - select EMIS days and include start/end date and it will generate report (classic rptsum) |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Topic #3 - USPS related FYE tips? |