Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This procedure outlines the steps to be taken to close USAS for the fiscal year in the Redesign.

...

Info

Items to consider prior to FYE - district policies & procedures will vary

Info

Info

ODE Fiscal Year 2024 Changes

  • USAS v2024.0.0 Release Notes - Removal of the Federal Assistance Detail and Summary from Period H EMIS reporting. The EMIS Extract no longer contains federal assistance summary and detail data.  The menu options for Federal Assistance Detail and Summary are still available but are now optional.

Pre-Closing Procedures

The following pre-closing procedures can be completed any time prior to closing the fiscal year.

  •  1. Go to Core/Organization
    •  Enter/Verify Central office square footage
  •  2. Go to Periodic/Building Profiles
    •  Enter/Update Building IRN, Description, square footage, transportation and lunchroom percentages for each building in your district. 

  •  3. Generate  SSDT District Building Information report under the Report Manager grid or from the home screen under All Reports.
  •  4. Generate  SSDT Account Validation report under the Report Manager or from the home screen under All Reports to ensure no invalid accounts exist.   
Info

If invalid accounts do exist, they should be changed via Utilities/Account Change

Tip

Accounts with amounts in them for the reporting fiscal year MUST be cleaned up. If an account does not have an amounts for the reporting fiscal year it can be ignored if desired. Running the Account Validation Report and entering 'true' to the Exclude Accounts with Zero Amounts query parameter will list ONLY invalid accounts with amounts.

  •  5. Go to Core/OPUs
    •  Review OPUs to make sure IRN numbers and Entity types are correct. 
      Tip
      You may generate an SSDT OPU LISTING report under the Report Manager or from the home screen under All Reports if desired. All OPUs must have an IRN within your district.

...

  •  7. Enter all transactions for the current month
  •  8. Attempt to reconcile USAS records with your bank(s)
Panel
bgColor#FFFFFF
  • Perform bank reconciliation procedure

  • Under the Periodic menu, select 'Cash Reconciliation'  to enter your cash reconciliation information for the month

Tip

Your outstanding checks should be entered as a negative number. (i.e. -10,000)

  •  9. Generate  the 'SSDT Cash Summary' report and the 'SSDT Financial Detail Report'.
Panel
bgColor#FFFFFF
  • The Financial Detail Report may be run for the month only to compare MTD totals to the Cash Summary Report. 

  • Compare the totals from reports... they should match with the exception of encumbrances.

Info

Encumbrances on these two reports may not match.

Cash Summary picks up total encumbrances (including carry-over encumbrances).

Financial Detail Report picks up encumbrances for the date range entered on the report.

...

  •  13. Go to Periodic/Cash Reconciliation 
    •  Verify it has been completed for June June if not enter information as needed
  •  14. Go to Periodic/Civil Proceedings
    •  Enter any existing civil proceedings

...

  •  15. Go to Extract/EMIS
    •  Click on 'Generate Extract File' to create a USAEMS_FYYY.SEQ file to be uploaded into the data collector.
Info
  • Warning messages may be issued if the cash reconciliation and civil proceedings programs have not been completed.

Note

The EMIS Extract contains the same data as Classic's partial (USAEMS_EMISR.SEQ) file.  The EMIS Extract output is to be used along with the USAS SIF agent when collecting the data in EMIS-R. The submission process for EMIS-R is under district control. An authorized person in the district (EMIS Coordinator, Treasurer, etc.) will need to upload the extract before running the data collection process and submitting the data to ODE.

  •  16.
    Status
    colourBlue
    titleOptional
    Go to Periodic/Federal Assistance Summary
    •  Create a record for the current fiscal year with the necessary information
Note

The Federal Assistance Summary MUST be created before the Federal Assistance Detail option in order to link them together.

  •  17.
    Status
    colourBlue
    titleOptional
    Go to Periodic/Federal Assistance Detail and Clone/Create and update necessary information for the current fiscal year. Below lists out instructions on how to create or clone federal assistance detail records. Users can use either one or a combination of both. 
Expand
titleCreating New Federal Assistance Detail Records
  • Click on image-20240307-133256.png

  • Enter in the required information for the detail record

    • Select the fiscal year to be reported on under Federal Assistance Summary field. 

    • Line number will auto increment once the summary fiscal year is selected

    • Enter the appropriate CFDA number 

Info

To assist with entering the CFDA number and Grant Title, USAS-R includes a tool tip when you hover over the name of these fields. The tool tip cannot contain a clickable link but it does include the URL to help direct users to the appropriate location. A clickable version of the URL can also be found below.

  • Enter the record description

  • Enter the cash account associated with this record

Info

For any Cash Account that is not in the 5xx's (i.e. 006-0000), the FYTD revenues/expenditures will not automatically populate when entering the Cash Account; however, an Account Filter can be created and once the Cash Account and Filter are selected, the received/expended amounts will populate.  The user can also manually enter the expended and received totals.  

For any Cash Account in the 500's FYTD revenues/expenditures (minus amounts associated with Transfer or Advance accounts) will automatically populate based on the current posting period. If there are changes to the FYTD revenues/expenditures after the Federal Assistance Detail record is created, it will need to be edited in order to update.

Image Removed

image-20240308-123557.pngImage Added

The user can also manually enter the expended and received totals. 

  • Enter the federal contributions received and expended during the fiscal year.

  • Click on Save (click on cancel to not post the changes and return to the grid)

Expand
titleCloning Federal Assistance Detail Records
  • View existing federal assistance detail record using the image-20240307-133649.png   from the grid

  • Click on image-20240307-133657.png

    • Select the fiscal year to be reported on under Federal Assistance Summary field. 

    • Update any necessary information

    • Enter the cash account associated with this record 

Info

For any Cash Account that is not in the 500's (i.e. 006-0000), the FYTD revenues/expenditures will not automatically populate when entering the Cash Account; however, an Account Filter can be created and once the Cash Account and Filter are selected, the received/expended amounts will populate.  The user can also manually enter the expended and received totals.  

For any Cash Account in the 500's FYTD revenues/expenditures (minus amounts associated with Transfer or Advance accounts) will automatically populate based on the current posting period. If there are changes to the FYTD revenues/expenditures after the Federal Assistance Detail record is created, it will need to be edited in order to update.

Image Removed

image-20240308-123700.pngImage Added

The user can also manually enter the expended and received totals.  

  • Click on Save (click on cancel to not post the changes and return to the grid)

...

  •  19. Go to Core/Posting Periods
  • Click on 

...

  • image-20240520-163008.pngImage Added to create July if it does not already exist. Do NOT Mark the 'current box'.

  • Verify June is current

  • Click on Image Modified  to 'Close' June.

  • Go to the Utilities/File Archive to see your Month End & Fiscal Year End reports processing. 

    • Do not make the next month "Current" (the next month can be "open" for continued processing) until your Month end & Fiscal Year End report bundles have finished running.

  • In Core/Posting Periods, click on the Open folder beside July to open (if it is not already), click on the checkmark beside July to make it current. 

  •  20You are now closed for the month and fiscal year.
    NoteJune of the prior fiscal year may be re-opened as long as it was not imported from Classic. For example, if you started live on the Redesign in May 2019 and you are now in August 2019, you may re-open June 2019 (as long as the rule to 'prevent opening of a previously closed posting period' is not enabled). However, if you started live on the Redesign in July 2019 and you are now in August 2019, you will not be able to open June 2019 because it was an imported period.

Post Fiscal Year-End Closing

...

Info

For more information on Web-GAAP and legacy cash reports you can go to the GAAP Wikki Wiki 

  •  22. Submit your financial data via EMIS-R
Tip

Please refer to the NWOCA Financial Checklist for more information on submitting your data via EMIS-R

...