This procedure outlines the steps to be taken to close the USAS fiscal year.
◊ You can generate a building report by running option 3 BLDRPT
◊ 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.
◊ The category defines the FUND/SCC describing what type of fund it is for EMIS year-end financial data processing and is required for funds that have multiple sources of revenue as defined in the biennial budget.
◊ All OPUs must have an IRN within your district
◊ Select 11H
◊ At this point you will be in the EFM_LOCAL report program. Enter a "U" at the first question to generate the report using USAS data instead of EMIS data. Use the defaults for the rest of the responses, EXCEPT tab down and space out the lines for "Spreadsheet filename" and "Spreadsheet Type." 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.
The ADM figures may still be estimates at this point, depending upon how soon ODE makes actual June ADM figures available.
◊ 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.
◊ In the USAEMSEDT program, option 1, enter your cash reconciliation information
◊ 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.
◊ 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
If all above steps are performed and totals all agree, you are in balance and may proceed.
|%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
◊ 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.
Please IGNORE the message at the end of the MONTHLYCD program that tells you to wait to run ADJUST until after MONTHLYCD has completed. This message is there for the benefit of the majority of the districts around the state who do not utilize monthly copy accounts. As long as you run MONTHLYCD from your "B" account you can set it run for later and still run ADJUST from your live account immediately
◊ Upon completion of MonthlyCD you will receive an email message in your "B" account; the reports will be accessible via the following URL:
-xx meaning the two character abbreviation used for your districts archive account
◊ 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.
YOU MUST NOT BE RUNNING ANY OTHER PROGRAMS FROM YOUR NORMAL ACCOUNT DURING THIS PROCESS (THAT INCLUDES THE WEB AND PAYROLL PROGRAMS!)
Select the "Year-End" option and run for "FISCAL"
You will be preparing your fiscal year-end reports from your "B" account; therefore you may indicate to this program that you have already generated those reports.
NOTE Once you have completed the above steps, you have completely closed your NORMAL account for June and can begin processing for July.
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
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: If warnings are encountered, the .SEQ file will still be created and the automated email sent. If corrections need to be made, notification should be sent the EMIS staff (email@example.com) indicating the file should not be loaded at that time, corrections can be made and USAEMS re-run to generate an updated file.
NWOCA EMIS staff will load your data into EMIS and run validations on it. The EMIS staff will then contact the EMIS contact that you provided in the USAEMS program to review the validation reports and go over any discrepancies and correct the data as needed. Once the reports have been resolved you will need to contact the EMIS staff and authorize them to submit your district's data to ODE.
This program will email the USAEMS_EMISR.SEQ file to your NWOCA email. Once the file is received you will either email it to the person designated to upload files into EMIS-R or you will upload the file. For information on how to upload a flat file into EMIS-R please see the EMIS-R handout.
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.)
Log into your "B" account at the menu prompt enter the command:
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.
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.
NOTE: Please IGNORE the message at the end of the FISCALCD program that tells you to wait to run ADJUST until after FISCALCD has completed. This message is there for the benefit of the majority of the districts around the state who do not utilize monthly copy accounts.
Upon completion of FISCAL CD you will receive an email message in your "B" account; the reports will be accessible via the following URL: www.nwoca.org/fiscdrom/xx
-xx meaning the two character abbreviation used for your districts archive account
EIS DISTRICTS (NORMAL ACCOUNT)
Follow the "NWOCA EIS Closing Procedures" handout through at least step 3 EISEMS.
Follow the "Capital Asset Reporting for NON-EIS Districts" handout.
You will need to notify the NWOCA EMIS staff upon completion and specify which way you are reporting your capital assets information either entered/exported through EMIS-FFE or created EISEMS.SEQ . You will also want to state that USAEMS data has already been submitted.
NOTE If you plan to use the Web-GAAP system for GASB34 reporting or to access the Legacy Cash Reports continue with step 27.
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.
For more information on Web-GAAP and legacy cash reports you can go to the GAAP Wikki http://gaapwiki.oecn.k12.oh.us/index.php?title=Main_Page