UFEF OMB2 AppB Sample Reporting Structure 12-1-20.xlsx

---

Overview

Revenue Report
Expenditure Report
Personnel Report
Accounting Codes Crosswalk
Personnel Code Crosswalk

---

Sheet 1: Revenue Report

School year	School NCES ID	State-assigned school or location ID	School or location name	Fund code	Fund description	Revenue source code	Revenue source description	Allocation amount for given school year	Prior year carryover amount
2019-20	121212199999	9999	Central Office	2	Special Revenue	3010	Title I, Part A	$120,000	$10,000
2019-20	121212199999	9999	Central Office	2	Special Revenue	3310	IDEA, Part B	$100,000	$5,000
2019-20	121212100001	1011	Glass ES	2	Special Revenue	3310	IDEA, Part B	$30,000	$-

---

Sheet 2: Expenditure Report

School year	School NCES ID	State-assigned school or location ID	School or location name	Fund code	Fund description	Revenue source code	Revenue source description	Program	Program	Function code	Function description	Object code	Object description	Amount	[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: I see you are no longer including the three activity areas as part of this table. So, we should change columns L and M to just Program
2019-20	121212199999	9999	Central Office	2	Special Revenue	3010	Title I, Part A	100	General Education	1000	Instruction	100	Salaries	$200,000
2019-20	121212199999	9999	Central Office	2	Special Revenue	3310	IDEA, Part B	200	Special Education	2100	Student Support Services	300	Purchased Services	$5,000
2019-20	121212100001	1011	Glass ES	2	Special Revenue	3310	IDEA, Part B	200	Special Education	2200	Instructional Support	310	Administrative Services	$500

---

Sheet 3: Personnel Report

School year	School NCES ID	State-assigned school or location ID	School or location name	Fund code	Fund description	Revenue source code	Revenue source description	Program	Program	Function code	Function description	Employee ID	Job code	Job description	FTE	Total salary amount	District-paid fringe benefit amount
2019-20	121212199999	9999	Central Office	2	Special Revenue	3010	Title I, Part A	100	General Education	1000	Instruction	922251	2626	Teacher-Title I	1.0	$65,000	$19,500
2019-20	121212199999	9999	Central Office	2	Special Revenue	3310	IDEA, Part B	200	Special Education	1000	Instruction	953333	2626	Teacher-Special Education	1.0	$50,000	$15,000
2019-20	121212100001	1011	Glass ES	2	Special Revenue	3310	IDEA, Part B	200	Special Education	2200	Student Support Services	953535	2800	School Psychologist	0.5	$30,000	$6,000

---

Sheet 4: Accounting Codes Crosswalk

School year

Local accounting codes - Fund code

Local accounting codes - Fund description

Local accounting codes - Revenue source code

Local accounting codes - Revenue source description

Local accounting codes - Program code

Local accounting codes - Program description

Local accounting codes - Function code

Local accounting codes - Function description

Local accounting codes - Object code

Local accounting codes - Object description

State accounting codes - Fund code

State accounting codes - Fund description

State accounting codes - Revenue source code

State accounting codes - Revenue source description

State accounting codes - Program code

State accounting codes - Program description

State accounting codes - Function code

State accounting codes - Function description

State accounting codes - Object code

State accounting codes - Object description

2019-20

2

Special Revenue

3010

Title I, Part A

100

General Education

1000

Instruction

100

Salaries

2

Special Revenue

300

Title I, Part A

10

General Education

1000

Instruction

10

Salaries

2019-20

2

Special Revenue

3310

IDEA, Part B

200

Special Education

2100

Student Support Services

300

Purchased Services

2

Special Revenue

330

IDEA, Part B

20

Special Education

2100

Student Support Services

30

Purchased Services

2019-20

2

Special Revenue

3310

IDEA, Part B

200

Special Education

2200

Instructional Support

310

Administrative Services

2

Special Revenue

330

IDEA, Part B

20

Special Education

2200

Instructional Support

30

Administrative Services

Note: The example above crosswalks the accounting codes for specific expenditures from locally used codes to the state codes for the same expenditure items. In this example the Revenue/Source, Program, and Object codes differ between local and state.

---

Sheet 5: Personnel Code Crosswalk

School year	Local personnel codes - Job code	Local personnel codes - Job description	State personnel codes - Job code	State personnel codes - Job description
2019-20	2626	Teacher-Title I	260	Teacher
2019-20	2626	Teacher-Special Education	260	Teacher-Special Education
2019-20	2800	School Psychologist	275	School Psychologist
Note: The example above crosswalks the job code and description for specific positions from the locally used codes to the state codes for the same position. In this example the Job code differs and the local Description provides more detail – identifying the first teacher as a Title I funded teacher rather than as just a teacher.