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.

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.

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:
1. Select an option in the first field.
2. Select or enter a value.
3. 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: 114 = General 115 = Special Revenue 116 = Debt Services 117 = Capital Projects 118 = Permanent 119 = Total Governmental Fund Bal 120 = Enterprise 121 = Internal Service 122 = Total Proprietary Fund Balance 123 = Trust 124 = Agency 125 = Total Fiduciary Fund Balance 126 = Total Balances All Funds
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: Governmental Fund Balance Propriety Fund Balance Fiduciary Fund Balance Total Balances, All Funds
Depository Type	The description of the function or classification of the depository. Valid values: General Special Revenue Debt Services Capital Projects Permanent Total Governmental Fund Bal Enterprise Internal Service Total Proprietary Fund Balance Trust Agency Total Fiduciary Fund Balance Total Balances All Funds
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 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