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

...

Pre-Closing Procedures

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

...

•  15. Go to Extract/EMIS
  •  Click on 'Generate Extract File' to create a USAEMS_FYYY.SEQ file to be uploaded into the data collector.

  • 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. 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. 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
    title Creating New Federal Assistance Detail records
    Click on Image Modified 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 Modified 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
    title Cloning Federal Assistance Detail records
    View existing federal assistance detail record using the  from the grid Click on  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. 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) Warning If there are changes to the FYTD revenues/expenditures AFTER the Federal Assistance Detail record is created, it will need to be edited, cash account reselected (and saved) in order to update.

    
    

•  18. Generate any additional fiscal year end reports needed.

...