Versions Compared

Key

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

...

  •  

    4. Run OPULST to review your OPUs and make sure your IRN numbers and Entity types are correct. Use USASWeb/Configuration - OPUS or OPUEDT to make changes.

    Code Block
    MENU>OPULST
    MENU>OPUEDT 

    Tip
    All OPUs must have an IRN within your district 

 


Note

You have the option to run an early collection before closing June in order to validate accounts and for MOE

Run an early collection of your financial data in EMIS-R with the option to submit to ODE

  • Enter "2019" in the fiscal year prompt of the USAEMSEDT - Federal Assistance Summary Option
  • Run USAEMS and use UEMS_EMAIL to email the file to yourself.  Upload into EMIS-R
  • Collect and prepare your data in the data collector to check for bad or missing values.
  • Optionally submit the data to ODE in order to receive reports back from ODE
  • Make any necessary corrections before closing out June 

...

If all above steps are performed and totals all agree, you are in balance and may proceed.  

  •  9. *****Optional Step (SM1/SM2) ****** From your *NORMAL account, run the SM2CALC program. The SM2CALC calculates the SM2 for the month, print the resulting report.

...

  •  16. Run the USAEMSEDT program - from your "B" account
    Code Block
    MENU>USAEMSEDT

MENU>USAEMSEDT

Warning

An update has been made to the USAEMSEDT program for back in FY2016 per AOS bulletin 2015-004, the Single Audit threshold has been updated from $500,000 to $750,000 in the Federal Assistance Summary option. Be sure your Federal Assistance Summary record is set properly. Below is a screenshot of changing the flag on the Federal Assistance Summary record.

Code Block
Menu> usaemsedt
This program allows entry of miscellaneous
information required for EMIS reporting.
 
*** Main Menu ***
     1 - Cash Reconciliation
     2 - Federal Assistance Programs - Summary
     3 - Federal Assistance Programs - Detail
     4 - Civil Proceedings
     5 - Exit Program
 
***System Manager Only***
     6 - Change flags
 
Enter option < 5>: _
                   2
  
*** Federal Assistance Programs - Summary ***
 
Enter Option (A/C/D/L/R/E/? <?>): _
                                  c
 
Federal Assistance Programs Summary
 1. Entity                : SARA LOCAL SCHOOLS  
 2. County                : HENRY     
 3. Fiscal Year End       : 20172019
 4. Total Federal Expenditures
        This Fiscal Period: Under $750,000
 5. Comments: 
 
Enter field number to change or <CR> if no change: _
Enter '9' to display record.                       4
 
Total Federal Expenditures This Fiscal Period:
 
Do you have $750,000 or more in Federal Expenditures
this Fiscal Period (Y/N <N>):_
                             


    •  

...

    • Remember you must complete/enter each option 1-4 of the USAEMSEDT program even if you have no data for that particular section.

...

    •  Create and check the report for each option
      • CSHREC.TXT - Cash Reconciliation
      • FEDSUM .TXT - Federal Assistance Summary
      • FEDDET.TXT - Federal Assistance Detail
      • CVLPRC.TXT - Civil Proceedings
  •  

...

  • 17

...

  • . Run the USAEMS program if you are satisfied with the accuracy of the reports. From your "B" account
    Code Block
    MENU>USAEMS

...

    •  Answer "N" to "Are you extracting for an Information Technology Center?" If no errors are encountered, two .SEQ files will be created containing the necessary financial data for EMIS reporting. An email message will also be automatically sent to the EMIS staff as well as the Fiscal staff indicating the file has been created and is ready to be loaded.

    ...

    • If no errors are encountered, the USAEMS_EMISR.SEQ file will be created containing the necessary financial data for EMIS-R reporting.
    Note

    NWOCA does not validate/load your financial data into EMIS. EMIS-R is used to submit financial data and is under district control. An authorized person in the district (EMIS Coordinator, Treasurer, etc.), with the correct EMIS-R role, uploads the financial data into EMIS-R, runs the data collection process, and submits the financial data to ODE.

    •  

    ...

    • 18

    ...

    • . Run the UEMS_EMAIL from your "B" account
      Code Block
      MENU>UEMS_EMAIL

    ...

    Info
    This program will email the USAEMS_EMISR.SEQ file to your email. Since you are running this procedure from the B account, it will prompt you to enter your email address which would be the email address you normally use (i.e. exchange email address). Once you receive the file, you will either forward it onto the person designated to upload files into EMIS-R or you will download it to your computer to be uploaded at a later time.
    Note

    For information on how to upload the financial flat file into EMIS-R please, refer to the "NWOCA Financial checklist"

    ...

    •  19. Run the USASAUD program from your "B" account
      Code Block
      MENU>USASAUD


    ◊  Answer "Y" to the question "Send data to AOS now." This program will take information from the Account Master, Vendor, Check, and Receipt files and create 3 new data files, ACCTAUD.SEQ, VENDAUD.SEQ, and TRANAUD.SEQ, do not print. It will also generate and send a summary FINSUMM by fund. (.TXT files of this data will also be generated.)

    ...