Steps to Export Grid1. From the General Ledger screen, select the Government Reporting menu and then North Dakota ESSA Report.
Generating the Report:
2. Enter the ending date of the fiscal year for which to generate the report in the Fiscal Year End field. Use the mm/dd/yyyy format or click the down-arrow button to select the desired date.
Tip: The date and time when the report was last generated (when the View tab was selected) for the specified fiscal year displays to the right of the Fiscal Year End field.
3. In the Report Format Year field, the corresponding year appears for the specified fiscal year (from the Fiscal Year End field) as the report format to use when generating the report, and cannot be changed.
Note: If the report format for the specified fiscal year is not yet available, the most recent year displays, and then when generating the report, a prompt will appear asking to generate the report with the old format.
4. Enter the number of the county for your school district (up to 2 digits) in the County Number field.
5. Enter the number for your school district (up to 3 digits) in the District Number field.
6. Each of the funds defined by the state that are reported on the ESSA report appear in the Funds List. The fund number and description are listed for each fund. For each of the funds, enter the actual fund number being used to track the specified fund under the Actual Fund column, or click the down-arrow button to select the correct one. Up to 30 different fund numbers can be entered for a fund. If more than one fund number is entered in the Actual Fund columns, the funds will be combined together and included under the one number on the report. For example, Fund 10 may be used to track specific information, but on the annual report, this fund should be combined with Fund 01; therefore, under the Actual Fund columns for Fund 01, enter both 01 and 10.
7. Click the Save button.
8. Click the Organizations tab.
All the organization codes (numbers) defined in the Organizations Reference File that are used in account numbers for the applicable funds specified under the Actual Fund columns on the Generate screen appear in the DPI Plant Number Cross Reference List.
For each organization code (number) listed, enter the appropriate 4-digit school building number to be reported for the account numbers using the organization in the DPI Plant Number field.
Note: A DPI Plant Number must be assigned for each organization code (number) in order to view the report data (on the View tab) or create the report file.
Click the Save button.
Viewing the Report:
9. If desired, click the View tab to view the information to be included on the ESSA report file.
Note: The View screen (tab) can only be accessed if a DPI Plant Number is assigned for each organization code (number) on the Organizations screen.
All the expenditure account numbers with a year-to-date balance for the applicable funds (as specified under the Actual Fund columns on the Generate screen) that are reportable appear in the View List. If desired, change the filters to modify the account numbers displayed here.
The data in the View List cannot be changed.
To export the data shown in the View List into a file in order to open and print the report (such as in Microsoft® Excel), if desired, complete the Export Grid option (accessed from the File menu).
Note: The file created with the Export Grid option is not the file to submit to the state as it is not using the correct required file format/layout.
Creating the Report File:
10. Select the Options menu and then Create Report File.
Note: The file can only be created if a DPI Plant Number is assigned for each organization code (number) on the Organizations screen.
11. At the Create Report File screen, select the desired path (drive and folders) for the destination location and click the Save button. The system will default to the location that was last specified.
Note: Do not change the name of the file.
12. A message will appear in the status bar on the screen to show that the file was created.
13. Submit the ESSA report file to the state following their instructions.
14. The report information can be accessed and generated anytime during the year.
15. Click the X in the upper right-hand corner to close the screen.