...
-
16. Run the USAEMSEDT program - from your "B" account
Code Block MENU>USAEMSEDT
Expand title AOS 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
- Using the R option to create a report and review it
- 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
- Use the R option to create a report and review it
- 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
- 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.
- 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
- Use the R option to create a report and review it
- 1 - Cash Reconciliation - 1
-
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.
...