Receipt Table
Use the EMIS Receipt Table page to add and update information about receipts for income and expenses for a school or district. The EMIS financial load process populates this table.
The coding requirements for receipts are Fund/SCC and Receipt Code. For more information about the receipt codes, refer to the USAS manual.
If an operational unit is reported on the Receipt Record, the OPU code must also be reported in the Operational Unit Description Record. If an OPU is reported and the receipt is district-wide, then the OPU reported for the receipt must be 000. For more information about the Operational Units, refer to Operational Unit Table.
For more information about the Receipt Codes required, refer to Section 6.4 of the Ohio EMIS manual.
Maintain data
On the start page, select EMIS.
From the EMIS Financial Tables menu, select Receipt Table.
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 Receipt Table 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 | The 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 AAP. 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 is 1. This field cannot be edited after saving the record. |
Schedule Number | The state-specified schedule number. The valid value is RCT. This field cannot be edited. |
Fund | The fund that receives the federal funds. The three-digit code is assigned by the State Auditor's Office to ensure money is spent for specified purposes. If the value is 002, select the General Fund Debt-Bond Retirement option. |
Special Cost Center | The four-digit code that tracks costs for temporary or specific needs in defining funds. This code is required by state and federal mandates to subdivide funds. |
Receipt | The revenue ledger account. |
Subject | The six-digit code that identifies specific educational costs. The major subject areas will be used for grades 9-12. Two digits are required for all major subject areas (math, science) and elementary physical education, art, and music. |
OPU | The three-digit code that identifies the permanent operational entity. It is used for buildings or physical units. If expenditures are not limited to a specific number of buildings, then no OPU is required, and the district-wide or undistributed OPU will be used. |
Fiscal Year Estimated Revenue | The forecast of expendable revenue to be received during the fiscal year. |
Fiscal Year Actual Receipt | The actual funds received during the fiscal year. |
Fiscal Year Actual Receivables | The funds due to the district, but not yet received. |
General Fund Debt-Bond Retirement | Select this option if the value in the Fund field is 002. |
Create file
On the EMIS Receipt Table page, select Report.
Select the Reporting Period and Fiscal Year.
Select PDF or Excel.
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 names are:PDF:
EMIS Receipt Table Report_<MMDDYYYY>_<hhmmss>.pdfExcel:
EMIS Receipt Table Report_<MMDDYYYY>_<hhmmss>.csv