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 option


    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 Use 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.

...

  •  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


...