...

•  

  1. Run the program VALACT

  Code Block
  MENU>VALACT

  
  

• • This insures that no invalid accounts exist in your master account file at this point. If invalid accounts do exist, they should be eliminated via the ACTCHG program by changing them to valid account codes * Contact NWOCA personnel if you have any questions regarding any particular accounts.

    Note
    Fatal messages will prevent USAEMS from generating the .SEQ output file so they MUST be cleaned up. Any accounts with $0 in all amount fields will be listed as a warning and may be ignored.

    
    

•  

  2. The Building Profile, Central office square footage and ITC IRN information must be entered in the USAEMSDB program. The building profile includes information to report the correct square footage, bussing percentages, and lunchroom percentages for each building in your district. The district profile includes information to report the central office square footage for your district.

  Code Block
  MENU>USAEMSDB

  
  

...

• • Examine the MTD, YTD, and FYTD expenditure lines on BALCHK report (dollar amounts for cash, budget, & approp. accts should all be identical for each line on report)
  • Examine the MTD, YTD, and FYTD revenue lines on BALCHK report (dollar amounts for cash and revenue accounts should be identical for each line on report)
  • Compare Current Encumbered totals from the BALCHK and Outstanding PODETL reports. They should be identical…….. if not execute the FIXENC to correct and regenerate BALCHK and compare totals. If the totals still do not balance contact NWOCA personnel for assistance.

• •  

    Run FINSUMM, selecting "Y" to generate the FINDET report for comparison.

    Code Block
    MENU>FINSUMM

    
    

• • This will cause the FINDET report to be generated with identical selection criteria as the FINSUMM and will determine if it balances with FINSUMM.
  • The total will display on the screen when run is complete. Compare the total from the FINDET and FINSUMM, they should be identical

...

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

Monthly Copy

•  

  10. Log into your "B" account and at the menu prompt enter the command:

  Code Block
  MENU>MONTHEND

  
  

Provided no messages appear in the form described above, the user may proceed

Monthly CD/Reports

•  

  11. Log into your "B" account and at the menu prompt enter the command:

  Code Block
  Menu>MONTHLYCD

  
  

  Info
  You will be prompted whether you want to generate the reports for NOW or LATER. (NOW would cause it to run immediately and LATER will run at night.) We recommend LATER to relieve load on the system during the day.

  
  

...

•  12. Please verify that the reports appear on the web page and are correct.
•  13. Generate any additional month-end reports from your "B" account

ADJUST

•  

  14. Log into your NORMAL account and run the ADJUST program.

  Code Block
  MENU>ADJUST

  •  Indicate to the program that you desire to perform month end processing and you are indeed completed with processing for that month. The ADJUST program will also automatically calculate your SM2 for the month.

Fiscal Year-End Closing

•  

  15. Run ADJUST from your NORMAL account

  Code Block
  MENU>ADJUST

  •  Select the "Year-End" option and run for "FISCAL"

...

•  

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

  Code Block
  MENU>USAEMSEDT

  
  

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

...

•  

  18. Run the UEMS_EMAIL from your "B" account

  Code Block
  MENU>UEMS_EMAIL

  
  

...

•  

  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.)
•  20. Perform Fiscal Year-End copy from your "B" account

• • Log into your "B" account at the menu prompt enter the command:

    Code Block
    MENU>FISCOPY

    
    

•  

  21. Log into your "B" account and at the menu prompt enter the command:

  Code Block
  MENU>FISCALCD

  
  

...

•  22. Please verify that the reports appear on the web page and are correct.
•  23. 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.
•  

  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

  
  

...

• • Follow the "Capital Asset Reporting for NON-EIS Districts" handout.

•  

  26. Submit your financial data via EMIS-R.

  Tip
  Please refer to the NWOCA Financial Checklist for more information on submitting your data via EMIS-R

...