Exhibit 1
Use the EMIS Exhibit 1 page to perform a cash and fund balance reconciliation at the end of the fiscal year to check a district's balance.
Maintain data
On the start page, select EMIS.
From the EMIS Financial Tables menu, select Exhibit 1.
Filter records using the filter criteria. To enter filter criteria:
Select an option in the first field.
Select or enter a value.
Select Add if the button is enabled.
Refer to Searching for Records for more information.To add a record, select Add Record. Refer to the Field Descriptions and enter valid information in the required fields. Select Save, then Yes.
To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
To download the information, select Download, then select Download PDF or Download as an Excel Document.
Field descriptions
The following table describes the fields on the EMIS Exhibit 1 form.
Field | Description |
---|---|
Record Number | The system-generated record number unique for the financial record type, reporting period, and fiscal year. This field cannot be edited. |
Record Status | The status of the record. The valid value is A - Add. This field cannot be edited. |
Sort Type | The sort type for the record. The valid value is QC. This field cannot be edited. |
Fiscal Year | The EMIS fiscal year. The value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. This field cannot be edited. |
Reporting Period | Period of the fiscal year to report on. The value is retrieved from the Financial Reporting Period field on the EMIS Profile page. This field cannot be edited. |
District IRN | The six-digit state-assigned Information Retrieval Number (IRN). The value is retrieved from the District IRN field on the EMIS Profile page. This field cannot be edited. |
Schedule Sequence | The state-specified schedule sequence. The valid value is AAZ. This field cannot be edited. |
Schedule Frequency | The state-specified schedule frequency. The valid value is 001. This field cannot be edited. |
Line Number | The state-specified line number. The valid value depends on the value in the Depository Type field:
|
Schedule Number | The state-specified schedule number. The valid value is EX1. This field cannot be edited. |
Depository Name | The name of the depository. Valid values:
|
Depository Type | The description of the function or classification of the depository. Valid values:
|
Amount | The amounts summed up from the EMIS Cash Table page. For more information, refer to Amount field calculation. |
Amount field calculation
The following table shows how the value in the Amount column of the EMIS Exhibit 1 report is calculated based on the values in the Line Number, Depository Name, and Depository Type fields on the EMIS Exhibit 1 form.
Line Number | Depository Name | Depository Type | Amount |
---|---|---|---|
114 | Governmental Fund Balance | General | csh_fundclass = 'G' |
115 | Governmental Fund Balance | Special Revenue | csh_fundclass = 'S' |
116 | Governmental Fund Balance | Debt Services | csh_fundclass = 'D' |
117 | Governmental Fund Balance | Capital Projects | csh_fundclass = 'C' |
118 | Governmental Fund Balance | Permanent | csh_fundclass='P' |
119 | Governmental Fund Balance | Total Governmental Fund Bal | The sum of the values for lines 114-118. |
120 | Propriety Fund Balance | Enterprise | csh_fundclass = 'E' |
121 | Propriety Fund Balance | Internal Service | csh_fundclass = 'I' |
122 | Propriety Fund Balance | Total Proprietary Fund Balance | The sum of the values for lines 120 and 121. |
123 | Fiduciary Fund Balance | Trust | csh_fundclass = 'R','V','W' |
124 | Fiduciary Fund Balance | Agency | csh_fundclass = 'A' |
125 | Fiduciary Fund Balance | Total Fiduciary Fund Balance | The sum of the values for lines 123 and 124. |
126 | Total Balances, All Funds | Total Balances All Funds | The sum of the values for lines 119, 122, and 125. |
Exhibit 1 Load
The EMIS Financial Load process must be run before the Exhibit 1 load process because the Exhibit 1 load process uses the cash records created by the financial load process.
The field values on the EMIS Exhibit 1 Fund Load page are retrieved from the EMIS Profile. If this information is incorrect, enter the correct information on the EMIS Profile. After this, you can perform the Exhibit 1 fund load process.
On the EMIS Exhibit 1 page, select Exhibit 1 Load.
Select Load.
If data for the selected criteria is loaded, select Yes to delete and reload the data.
Select OK.
Create file
On the EMIS Exhibit 1 page, select Report.
Select the Reporting Period and Fiscal Year.
Select Create, and then Yes.
Save the file and select OK.
Navigate to the folder containing the report file.
Inspect the file. Update data if needed.
Repeat these steps until all the required data is included.
The default file name is EMIS Exhibit 1 Report_<MMDDYYYY>_<hhmmss>.pdf