Page tree

Versions Compared

Key

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

...

  •  

    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>):_
                                 




    •  1 -  Cash Reconciliation - 1
      •  Using the R option to create a report and review it
        • CSHREC.TXT - Cash Reconciliation
      •  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
    •   2 - 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
    •  3 -  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
    •  4 - 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.

...