Receipt Table
Use the EMIS Receipt Table page to add, update, delete, search, and print receipt/revenue records for Ohio EMIS state reporting. This page allows users to manage RCT (Receipt) schedule records that track detailed revenue data organized by fund, special cost center, receipt code, subject, and operational unit. The data is used to generate the EMIS Receipt Table Report (QC record type with schedule number RCT) for submission to the Ohio Department of Education.
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, the reported OPU for the receipt must be 000. For more information about the Operational Units, refer to the Operational Unit Table.
For more information on the required Receipt Codes, 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 Search 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.
Field descriptions
The following table describes the fields on the EMIS Receipt Table form of the EMIS Receipt Table page.
Field | Description | Load Logic - Data source and Valid values |
|---|---|---|
Record Number | The system-generated sequential number that uniquely identifies each receipt record. This field is view-only. | Calculated during the data load process. The calculated value represents the next sequential record number, incremented for each record loaded. |
Record Status | Indicates the status of the record for EMIS submission. This field is view-only. | The valid value is A - Add. Calculated during the data load process. The calculated value represents the record status, which is automatically set to A - Add for all receipt records created during the data load. |
Sort Type | The EMIS record type identifier. This field is view-only. | The valid value is QC. Populated during the data load process. |
Fiscal Year | The fiscal year for which the receipt information is being reported. This field is view-only. | Populated during the data load process. The value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. |
Reporting Period | The EMIS reporting period for this record. This field is view-only. | Valid values:
The value is retrieved from the Financial Reporting Period field on the EMIS Profile page. |
District IRN | The six-digit state-assigned Information Retrieval Number (IRN) assigned to the school district. This field is view-only. | Populated during the data load process. The value is retrieved from the District IRN field on the EMIS Profile page. |
Schedule Sequence | The three-character sequence code for the schedule. This field is view-only. | The valid value is AAP. Populated during the data load process. |
Schedule Frequency | The three-character schedule frequency code indicating how often this record is reported. This field is view-only. | The valid value is 001. Populated during the data load process. |
Line Number | A sequential line number within the schedule for the current fiscal year and reporting period. This field cannot be updated after saving the record. | The valid value is 1. Populated during the data load process. |
Schedule Number | The EMIS schedule identifier for this record type. This field is view-only. | The valid value is RCT. Populated during the data load process. |
Fund | The fund code associated with the receipt. Identifies the district fund in which revenue from receipts is recorded. If the value is 002, select the General Fund Debt-Bond Retirement option. | Populated during the data load process. The field value is retrieved from the first three characters of the Fund field on the Organization Record page. This corresponds to the EMIS Fund code. |
Special Cost Center | The special cost center code that further categorizes the receipt. Used to identify specific programs or projects within a fund. | Calculated during the data load process. The field value is retrieved from characters 4-7 of the Fund field on the Organization Record page. This corresponds to the EMIS Special Cost Center code. |
Receipt | The receipt code identifying the type of revenue being reported. | Calculated during the data load process. The calculated value corresponds to the revenue account number from the Account field on the Revenue Ledger page. If the account number begins with R, the leading R is stripped. This corresponds to the EMIS receipt classification. |
Subject | The six-digit EMIS Subject Area code associated with the receipt, providing additional classification for the revenue source. 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. | Calculated during the data load process. The field value is retrieved from the Level 2 field on the Organization Record page. This corresponds to the EMIS Subject Area code. For a Mentor site, orgn3 is used instead. |
OPU | The three-digit Operational Unit code identifying which operational unit the receipt is associated with. 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. | Valid values range from 000 (district-wide) to 999. Calculated during the data load process. The field value is retrieved from the Level 3 field on the Organization Record page. This corresponds to the EMIS Operational Unit code. For a Mentor site, orgn4 is used instead. |
Fiscal Year Estimated Revenue | The estimated revenue amount for the fiscal year. | Calculated during the data load process. The calculated value represents the sum of all budget period amounts (bud1 through bud13) from the Revenue Ledger page. |
Fiscal Year Actual Receipt | The actual receipt amount received during the fiscal year. | Calculated during the data load process. The calculated value represents the sum of all actual receipt period amounts (exp1 through exp13) from the Revenue Ledger page. |
Fiscal Year Actual Receivables | The actual receivables amount (amounts owed but not yet received) for the fiscal year. | Populated during the data load process. The value is set to 0.00 (receivables are not calculated during the load). |
General Fund Debt-Bond Retirement | Indicates whether this fund is a general fund debt-bond retirement fund. Select this option if the value in the Fund field is 002. | Calculated during the data load process. The calculated value represents whether the fund is a debt-bond retirement fund. This option is selected if the Fund is 002; otherwise, it is cleared. |
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
For detailed information about the report’s file layout, refer to EMIS Receipt Table Report - File Layout and Data Mapping.