Page tree

Versions Compared

Key

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

...

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 "20202021" 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 

...

  •  

    16. Run the USAEMSEDT program - from your "B" account

    Code Block
    MENU>USAEMSEDT


    Expand
    titleAOS bulletin 2015-004, the Single Audit threshold has been updated from $500,000 to $750,000 in the Federal Assistance Summary


    Warning

    An update has been made to the USAEMSEDT program 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       : 2019
     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
    • Cash Reconciliation - 1
      •  Use the R option to create a report and review it
        • CSHREC.TXT - Cash Reconciliation
  • FEDSUM .TXT - Federal Assistance Summary
  • FEDDET.TXT - Federal Assistance Detail
  • CVLPRC.TXT - Civil Proceedings
      •  If Updates are needed use option C - to change the record
      •  Use option A to add the record if one doesn't already exist
      •  Use the R option to create a report and verify changes
    •  Federal Assistance Summary - 2
      •  Use the R option to create a report and review it
        • FEDSUM .TXT - Federal Assistance Summary
      •  Use option C to change the fiscal year and any other desired changes.
      •  Use the R option to create a report and verify changes
    •  Federal Assistance Detail - 3
      •  Use the R option to create a report and review it, making sure to keep for reference for CFDA #s and any other non 5xx funds.
        • FEDDET.TXT - Federal Assistance Detail
      •  Use the I option to initialize the 5xx funds. This option will delete all detail records with a 5xx fund number from the Federal Assistance Detail and then create records for the 5xx cash accounts.
      •  Use the C option modify the records and populate the CFDA #s and change any existing non 5xx funds in the program (if it applies)
      •  Use the A option to add records
      •  Use the D option to delete any records 
      •  Use the R option to create a report and verify changes
    •  Civil Proceedings - 4
      •  Use the R option to create a report and review it
        • CVLPRC.TXT - Civil Proceedings
      •  Use the C option to change records
      •  Use the D option to delete records
      •  Use the A option add records
      •  Use the R option to create a report and verify changes
  •  

    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.

...

  •  22. Please verify that the reports appear on the web page and are correct.
  •  23.   Optional Send email to mail_staff_fis@nwoca.org if you would like the reports from the MONTHLYCD and/or FISCALCD placed on CDROM. 
    • Please specify if you would like ONLY your FISCALCD reports placed on CDROM or BOTH your MONTHLYCD and FISCALCD reports to be placed on

      CDOM.

      CDROM.

      Info

      There is an additional cost to have your monthlyCD/fiscalCD burnt to CDROM. Majority of districts have moved away from burning a CD of the information as it is available online and will be migrated into the Redesign for districts on State Software. 


  •  

    24. The GAAP_EXP option of USAEXP should be run at this time from your NORMAL account, if you use the Web-GAAP system for GASB34 reporting.

    Code Block
    MENU>USAEXP


...