Versions Compared

Key

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

...

◊  All OPUs must have an IRN within your district

  

Δ  5)

...

MENU>EFM

◊  At this point you will be in the EFM_LOCAL report program. Use the defaults for the options. Press PF4 to actually generate the reports

◊  Print and review the resulting reports. If any corrections or account changes are necessary, these changes can be completed now before closing out the fiscal year.

Note

The ADM figures may still be estimates at this point, depending upon how soon ODE makes actual June ADM figures available.

...

If you planned to use the NYPMASS, NYPMNT, or NYPLOAD of the APPROP program to enter your proposed budgets and revenue estimates, this must be completed before running ADJUST to close the fiscal year. Otherwise, you can use IABMASS, IABMNT, or IABLOAD of the APPROP program once you have closed for the fiscal year.

 

Δ 

...

6) Check the "Track accounts payable" flag in USASDAT/USACON and make sure it is set to "Y".

◊  Make sure you enter correct received dates when processing invoices during the summer months.  This will allow an accurate accounts payable (PAYABL) report to be generated later for GAAP reporting purposes.

Month-End Closing

Δ 

...

7) Enter all transactions for the current month

 

Δ 

...

8)Attempt to reconcile USAS records with your bank(s):

Ο  A) Perform bank reconciliation procedure

...

If all above steps are performed and totals all agree, you are in balance and may proceed.

  

Δ 

...

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:

MENU>MONTHEND

Warning
titleBEWARE of anything the computer displays on your screen which contains the word "error"
%COPY-E-OPENIN, error opening NBA:[GLORE.TEST]ACCT.IDX;2 as input -RMS-E-FLK, file currently locked by another user
THIS IS AN ERROR CONDITION AND THE USER SHOULD INFORM NWOCA IMMEDIATELY

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:

Menu>MONTHLYCD

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

...

-xx meaning the two character abbreviation used for your districts archive account

Δ 

...

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.

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

Warning

YOU MUST NOT BE RUNNING ANY OTHER PROGRAMS FROM YOUR NORMAL ACCOUNT DURING THIS PROCESS (THAT INCLUDES THE WEB AND PAYROLL PROGRAMS!)

 
Fiscal Year-End Closing

Δ 

...

15) Run ADJUST from your NORMAL account

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

...

Info

Once you have completed the above steps, you have completely closed your NORMAL account for June and can begin processing for July.

Δ 

...

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

◊  Remember you must complete/enter each option 1-4 of the USAEMSEDT program even if you have no data for that particular section.

...

    • 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

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

...

Note

NWOCA_WILL NOT_ be validating/loading your financial data into EMIS this year. EMIS-R will be used to submit financial data and will be under district control instead of NWOCA's control. An authorized person in the district (EMIS Coordinator, Treasurer, etc.), with the correct EMIS-R role, will be uploading the financial data into EMIS-R, running the data collection process, and submitting the financial data to ODE.

 Δ 

...

18) Run the UEMS_EMAIL from your "B" account

◊  This program will email the USAEMS_EMISR.SEQ file to your email. Since you are running this procedure from the B account, it will prompt you to enter your email address which would be the email address you normally use (i.e. exchange email address). Once you receive the file, you will either forward it onto the person designated to upload files into EMIS-R or you will upload the file yourself.

Note

For information on how to upload the financial flat file into EMIs-R please refer to the "Financial submission checklist"

Δ 

...

19) Run the USASAUD program from your "B" account

◊  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:

...

Warning
iconfalse
titleSTOP
Due to the importance of securing a copy of the USAS files, once the fiscal copy procedure is complete you will receive an automated email message indication that you are NOT to proceed with the next step in this procedure until notified by NWOCA.
NWOCA staff will respond to you via email with instructions to continue with the procedure. Wait until this message is received from NWOCA before proceeding.

 

Δ 

...

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

MENU>FISCALCD

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

...

-xx meaning the two character abbreviation used for your districts archive account

 Δ 

...

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) Compile your capital assets information before period H closes.

Ο  EIS DISTRICTS (NORMAL ACCOUNT)

...

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

 Δ 

...

25) Submit your financial data via EMIS-R.

Please refer to the  Financial (Period H) Submission Checklist for more information on submitting your data via EMIS-R

...

Note

If you plan to use the Web-GAAP system for GASB34 reporting or to access the Legacy Cash Reports continue with step 27.

Δ 

...

26) 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.

◊ GAAP_EXP will create the file necessary for uploading into the WEB_GAAP system and also allows you to enter the email address of the person you wish to send the export file to. Multiple addresses may be entered by separating them with commas.

...