EMIS Receipt Table Report - File Layout and Data Mapping

The default file names for the EMIS Receipt Table report are:

PDF:
EMIS Receipt Table Report_<MMDDYYYY>_<hhmmss>.pdf
Excel:
EMIS Receipt Table Report_<MMDDYYYY>_<hhmmss>.csv

The following table shows the columns, fields, descriptions, and data source or valid values for the EMIS Receipt Table report.

Column in PDF	Column in CSV	Field	Description	Data Source or Valid Values
1	A	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, the GEN FUND DEBT-BOND RETIRE FUND field value must be Y.	Retrieved from the Fund field on the EMIS Receipt Table form.
2	B	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.	Retrieved from the Special Cost Center field on the EMIS Receipt Table form.
3	C	RECEIPT	The revenue ledger account.	Retrieved from the Receipt field on the EMIS Receipt Table form.
4	D	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.	Retrieved from the Subject field on the EMIS Receipt Table form.
5	E	OPERATIONAL UNIT	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.	Retrieved from the OPU field on the EMIS Receipt Table form.
6	F	FISCAL YEAR ESTIMATED REVENUE	The forecast of expendable revenue to be received during the fiscal year.	Retrieved from the Fiscal Year Estimated Revenue field on the EMIS Receipt Table form.
7	G	FISCAL YEAR ACTUAL RECEIPTS	The actual funds received during the fiscal year.	Retrieved from the Fiscal Year Actual Receipt field on the EMIS Receipt Table form.
8	H	FISCAL YEAR RECEIVEABLES	The funds due to the district, but not yet received.	Retrieved from the Fiscal Year Actual Receivables field on the EMIS Receipt Table form.
9	I	GEN FUND DEBT-BOND RETIRE FUND	Required if the value in the Fund field is 002.	Retrieved from the General Fund Debt-Bond Retirement field on the EMIS Receipt Table form. The valid value is Y if the value in the Fund field is 002.
10	J	UNIQUE RECORD NUMBER	The system-generated record number unique for the financial record type, reporting period, and fiscal year.	Retrieved from the Record Number field on the EMIS Receipt Table form.