EMIS Cash Table Report - File Layout and Data Mapping

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

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

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

Column in PDF	Column in CSV	Field	Description	Data Source or Valid Values
1	A	FUND	A three-digit code assigned by the State Auditor's Office to ensure money is spent for specified purposes. For more information on each code's corresponding program, refer to the current EMIS manual.	Retrieved from the Fund field on the EMIS Cash Table form.
2	B	SPECIAL COST CENTER	The four-digit code that tracks costs for temporary or specific needs when defining funds. This code is required by state and federal mandates to subdivide funds.	Retrieved from the Special Cost Center field on the EMIS Cash Table form.
3	C	ACCOUNT DESCRIPTION	The description of the account structure as maintained by the State Auditor. This is not submitted to ODE.	Retrieved from the Account Description field on the EMIS Cash Table form.
4	D	FUND CLASS	The fund class.	Retrieved from the Fund Class field on the EMIS Cash Table form. Valid values: G - General Fund S - Special Revenue C - Capital Project D - Debt Service A - Custodial Funds E - Enterprise I - Internal Service P - Permanent R - Private Purpose Trust V - Investment Trust W - Pension Trust
5	E	JULY 1 CASH BALANCE	The available cash at the beginning of the fiscal year, which is July 1st.	Retrieved from the July 1 Cash Balance field on the EMIS Cash Table form.
6	F	FISCAL YEAR RECEIPTS	The receipts for the fiscal year.	Retrieved from the Fiscal Year Receipts field on the EMIS Cash Table form.
7	G	FISCAL YEAR EXPENDITURES	The funds spent during the fiscal year for goods and services.	Retrieved from the Fiscal Year Expenditures field on the EMIS Cash Table form.
8	H	CURRENT CASH ENCUMBERED	The funds or cash encumbered for orders in process.	Retrieved from the Current Cash Encumbered field on the EMIS Cash Table form.
9	I	CURRENT FUND BALANCE	The balance of a particular fund at a given time.	Retrieved from the Current Fund Balance field on the EMIS Cash Table form.
10	J	CURRENT PAYABLES (OP)	The invoices for goods/services received and not yet paid. This field is only required if the Fiscal Year is 2023 or earlier.	Retrieved from the Current Payables field on the EMIS Cash Table form.
11	K	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 Cash Table form.