Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Revenue to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Estimated Revenue (Budget)
Program: FIN3051 Page 1 of 8 File ID: A
Revenue Realized Current
Revenue RealizedTo Date
Revenue Balance
Percent Realized
GENERAL OPERATING FUNDS 5700 - REVENUE-LOCAL & INTERMED 5710 - LOCAL REAL-PROPERTY TAXES 5730 - TUITION & FEES FROM PATRONS 5740 - TRANS FROM WITHIN STATE 5750 - ENTERPRISING ACTIVITIES 5760 - OTHER REV FM LOCAL SOURCE Total 5700 - REVENUE-LOCAL & INTERMED
6,845,000.00
-173,286.84
-7,035,109.66
-190,109.66
102.78%
10,000.00
.00
57,500.00
-9,726.85
-12,756.00
-2,756.00
127.56%
-68,253.59
-10,753.59
118.70%
53,000.00
-903.94
.00
-5,000.00
-52,304.99
695.01
98.69%
-8,070.00
-8,070.00
.00%
6,965,500.00
-188,917.63
-7,176,494.24
-210,994.24
103.03%
10,632,174.00
-4,732,182.00
-11,362,728.00
-730,554.00
106.87%
11,800.72
.00
-11,800.72
.00
100.00%
5800 - STATE PROGRAM REVENUES 5810 - PER CAPITA-FOUNDATION REV 5820 - STATE PROGRAM REVENUE 5830 - STATE REVENUE FROM STATE Total 5800 - STATE PROGRAM REVENUES
733,152.00
-659,205.86
-773,818.00
-40,666.00
105.55%
11,377,126.72
-5,391,387.86
-12,148,346.72
-771,220.00
106.78%
225,000.00
-101,077.11
-312,701.58
-87,701.58
138.98%
5900 - FEDERAL PROGRAM REVENUES 5930 - VOC ED NON FOUNDATION Total 5900 - FEDERAL PROGRAM REVENUES 5000 Total R E C E I P T S
225,000.00
-101,077.11
-312,701.58
-87,701.58
138.98%
18,567,626.72
-5,681,382.60
-19,637,542.54
-1,069,915.82
105.76%
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Expenditures and Encumbrances to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Encumbrance YTD
Budget
Expenditure YTD
Program: FIN3051 Page 2 of 8 File ID: A
Current Expenditure
Percent Expended
Balance
GENERAL OPERATING FUNDS 11 - INSTRUCTION 6100 - PAYROLL COSTS
-9,323,030.72
.00
8,932,702.31
6200 - PURCHASE & CONTRACTED SVS
-383,546.75
.00
343,456.49
84,722.11
-40,090.26
89.55%
6300 - SUPPLIES AND MATERIALS
-253,548.25
.00
572,264.37
407,826.26
318,716.12
225.70%
6400 - OTHER OPERATING EXPENSES
1,018,379.22
-390,328.41
95.81%
-56,659.00
.00
60,881.57
27,522.82
4,222.57
107.45%
-10,016,784.72
.00
9,909,304.74
1,538,450.41
-107,479.98
98.93%
6100 - PAYROLL COSTS
-471,445.00
.00
460,762.34
34,038.87
-10,682.66
97.73%
6200 - PURCHASE & CONTRACTED SVS
-159,730.00
.00
95,800.40
-62,137.32
-63,929.60
59.98%
6300 - SUPPLIES AND MATERIALS
-521,822.00
.00
189,778.24
-174,869.32
-332,043.76
36.37%
Total Function 11 INSTRUCTION 12 - INST RESOURCES & MEDIA SERVICE
6400 - OTHER OPERATING EXPENSES Total Function 12 INST RESOURCES & MEDIA
.00
.00
96.38
96.38
96.38
.00%
-1,152,997.00
.00
746,437.36
-202,871.39
-406,559.64
64.74%
13 - CURRICULUM & INSTRUCTIONAL 6100 - PAYROLL COSTS
-396,439.00
.00
366,446.08
28,782.83
-29,992.92
92.43%
6200 - PURCHASE & CONTRACTED SVS
-57,160.00
.00
55,925.40
3,388.95
-1,234.60
97.84%
6300 - SUPPLIES AND MATERIALS
-19,600.00
.00
18,016.76
394.84
-1,583.24
91.92%
6400 - OTHER OPERATING EXPENSES
-14,255.00
.00
17,100.57
8,263.15
2,845.57
119.96%
6600 - CPTL OUTLY LAND BLDG & EQUIP
-34,000.00
.00
32,985.00
.00
-1,015.00
97.01%
-521,454.00
.00
490,473.81
40,829.77
-30,980.19
94.06%
-196,079.00
.00
183,302.10
14,670.50
-12,776.90
93.48%
-40,284.00
.00
33,665.92
2,971.59
-6,618.08
83.57%
Total Function 13 CURRICULUM & 21 - INSTRUCTIONAL DEVELOPMENT 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES Total Function 21 INSTRUCTIONAL DEVELOPMENT
-6,520.00
.00
7,552.24
236.19
1,032.24
115.83%
-14,756.00
.00
14,577.92
3,124.89
-178.08
98.79%
-257,639.00
.00
239,098.18
21,003.17
-18,540.82
92.80%
23 - SCHOOL ADMINISTRATION 6100 - PAYROLL COSTS
-1,109,726.00
.00
1,076,027.88
86,129.73
-33,698.12
96.96%
6200 - PURCHASE & CONTRACTED SVS
-22,370.00
.00
15,202.00
.00
-7,168.00
67.96%
6300 - SUPPLIES AND MATERIALS
-13,014.30
.00
15,262.52
-107.77
2,248.22
117.27%
-9,468.70
.00
10,630.54
1,172.67
1,161.84
112.27%
-1,154,579.00
.00
1,117,122.94
87,194.63
-37,456.06
96.76%
-423,460.00
.00
414,617.53
27,348.78
-8,842.47
97.91%
-4,300.00
.00
4,300.00
.00
.00
100.00%
-14,284.00
.00
10,952.28
587.68
-3,331.72
76.68%
-2,256.00
.00
1,455.40
.00
-800.60
64.51%
-444,300.00
.00
431,325.21
27,936.46
-12,974.79
97.08%
-59,330.00
.00
59,168.42
4,770.82
-161.58
99.73%
-750.00
.00
750.00
83.08
.00
100.00%
6300 - SUPPLIES AND MATERIALS
-7,500.00
.00
5,991.45
1,491.45
-1,508.55
79.89%
6400 - OTHER OPERATING EXPENSES
-3,167.00
.00
3,158.12
452.85
-8.88
99.72%
-70,747.00
.00
69,067.99
6,798.20
-1,679.01
97.63%
6400 - OTHER OPERATING EXPENSES Total Function 23 SCHOOL ADMINISTRATION 31 - GUIDANCE AND COUNSELING SVS 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES Total Function 31 GUIDANCE AND COUNSELING 32 - ATTENDANCE & SOCIAL WORK SVS 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS
Total Function 32 ATTENDANCE & SOCIAL WORK
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Expenditures and Encumbrances to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Budget
Encumbrance YTD
Expenditure YTD
Program: FIN3051 Page 3 of 8 File ID: A
Current Expenditure
Percent Expended
Balance
GENERAL OPERATING FUNDS 33 - HEALTH SERVICES 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES Total Function 33 HEALTH SERVICES
-221,722.00
.00
216,959.28
7,670.05
-4,762.72
97.85%
-354.00
.00
336.00
.00
-18.00
94.92%
-8,796.00
.00
5,328.87
501.47
-3,467.13
60.58%
-650.00
.00
370.00
.00
-280.00
56.92%
-231,522.00
.00
222,994.15
8,171.52
-8,527.85
96.32%
-696,069.00
.00
644,120.64
32,654.33
-51,948.36
92.54%
34 - PUPIL TRANSPORTATION-REGULAR 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES 6600 - CPTL OUTLY LAND BLDG & EQUIP Total Function 34 PUPIL TRANSPORTATION-
-35,332.00
.00
33,944.25
263.79
-1,387.75
96.07%
-317,345.00
.00
247,116.86
-37,385.11
-70,228.14
77.87%
-37,445.00
.00
26,489.74
-1,092.75
-10,955.26
70.74%
-156,000.00
.00
148,845.00
.00
-7,155.00
95.41%
-1,242,191.00
.00
1,100,516.49
-5,559.74
-141,674.51
88.59%
-4,000.00
.00
1,503.91
1,503.91
-2,496.09
37.60%
-4,000.00
.00
1,503.91
1,503.91
-2,496.09
37.60%
-438,979.00
.00
416,049.13
22,965.76
-22,929.87
94.78%
35 - FOOD SERVICE 6400 - OTHER OPERATING EXPENSES Total Function 35 FOOD SERVICE 36 - CO-CURRICULAR ACTIVITIES 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES
-80,277.00
.00
69,643.35
748.71
-10,633.65
86.75%
-122,950.42
.00
112,239.15
5,212.66
-10,711.27
91.29%
-94,662.58
.00
69,185.34
4,581.57
-25,477.24
73.09%
-736,869.00
.00
667,116.97
33,508.70
-69,752.03
90.53%
6100 - PAYROLL COSTS
-662,711.00
.00
658,568.42
53,446.98
-4,142.58
99.37%
6200 - PURCHASE & CONTRACTED SVS
Total Function 36 CO-CURRICULAR ACTIVITIES 41 - GENERAL ADMINISTRATION
-134,574.00
.00
93,176.08
4,934.17
-41,397.92
69.24%
6300 - SUPPLIES AND MATERIALS
-20,916.00
.00
33,054.78
17,251.48
12,138.78
158.04%
6400 - OTHER OPERATING EXPENSES
-91,049.00
.00
57,878.48
12,827.67
-33,170.52
63.57%
6600 - CPTL OUTLY LAND BLDG & EQUIP
-20,000.00
.00
.00
-15,222.38
-20,000.00
-.00%
Total Function 41 GENERAL ADMINISTRATION
-929,250.00
.00
842,677.76
73,237.92
-86,572.24
90.68%
6100 - PAYROLL COSTS
-1,224,633.00
.00
1,109,549.90
82,457.05
-115,083.10
90.60%
6200 - PURCHASE & CONTRACTED SVS
-1,128,813.00
.00
1,085,016.83
192,066.05
-43,796.17
96.12%
-389,571.63
.00
396,487.30
68,439.51
6,915.67
101.78%
-69,950.00
.00
67,090.07
460.94
-2,859.93
95.91%
51 - PLANT MAINTENANCE & OPERATION
6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES 6600 - CPTL OUTLY LAND BLDG & EQUIP
-75,250.00
.00
37,999.00
-31,210.09
-37,251.00
50.50%
-2,888,217.63
.00
2,696,143.10
312,213.46
-192,074.53
93.35%
-143,604.00
.00
136,415.49
11,508.20
-7,188.51
94.99%
-20,475.00
.00
13,510.41
300.00
-6,964.59
65.98%
-7,550.00
.00
12,742.75
4,474.33
5,192.75
168.78%
6600 - CPTL OUTLY LAND BLDG & EQUIP
-35,000.00
.00
35,000.00
.00
.00
100.00%
Total Function 52 SECURITY AND MONITORING
-206,629.00
.00
197,668.65
16,282.53
-8,960.35
95.66%
Total Function 51 PLANT MAINTENANCE & 52 - SECURITY AND MONITORING SERV. 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS
53 - DATA PROCESSING SERVICES
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Expenditures and Encumbrances to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Encumbrance YTD
Budget GENERAL OPERATING FUNDS 6100 - PAYROLL COSTS
Expenditure YTD
Program: FIN3051 Page 4 of 8 File ID: A
Current Expenditure
Balance
Percent Expended
-110,284.00
.00
102,158.41
6,792.48
-8,125.59
92.63%
.00
.00
1,820.00
182.00
1,820.00
.00%
6300 - SUPPLIES AND MATERIALS
-3,000.00
.00
979.80
.00
-2,020.20
32.66%
6400 - OTHER OPERATING EXPENSES
-1,905.00
.00
1,260.00
.00
-645.00
66.14%
-115,189.00
.00
106,218.21
6,974.48
-8,970.79
92.21%
6100 - PAYROLL COSTS
-104,530.00
.00
65,719.23
-6,654.77
-38,810.77
62.87%
6200 - PURCHASE & CONTRACTED SVS
-134,148.37
.00
30,283.91
-1,851.84
-103,864.46
22.57%
6200 - PURCHASE & CONTRACTED SVS
Total Function 53 DATA PROCESSING SERVICES 61 - COMMUNITY SERVICES
6300 - SUPPLIES AND MATERIALS
-47,094.00
.00
37,736.03
7,236.20
-9,357.97
80.13%
6400 - OTHER OPERATING EXPENSES
-1,500.00
.00
1,372.01
.00
-127.99
91.47%
Total Function 61 COMMUNITY SERVICES
-287,272.37
.00
135,111.18
-1,270.41
-152,161.19
47.03%
-170,000.00
.00
163,992.34
40,814.66
-6,007.66
96.47%
-170,000.00
.00
163,992.34
40,814.66
-6,007.66
96.47%
-20,429,640.72
.00
19,136,772.99
2,005,218.28
-1,292,867.73
93.67%
99 - OTHER INTERGOVERNMENTAL CHARGE 6200 - PURCHASE & CONTRACTED SVS Total Function 99 OTHER INTERGOVERNMENTAL 6000 Total E X P E N D I T U R E S
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Revenue to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Estimated Revenue (Budget)
Program: FIN3051 Page 5 of 8 File ID: A
Revenue Realized Current
Revenue RealizedTo Date
Revenue Balance
Percent Realized
SPECIAL REVENUE FUNDS 5700 - REVENUE-LOCAL & INTERMED 5740 - TRANS FROM WITHIN STATE
.00
-376.80
-376.80
-376.80
.00%
359,000.00
-6,253.84
-337,502.50
21,497.50
94.01%
359,000.00
-6,630.64
-337,879.30
21,120.70
94.12%
5820 - STATE PROGRAM REVENUE
7,000.00
.00
-6,769.62
230.38
96.71%
Total 5800 - STATE PROGRAM REVENUES
7,000.00
.00
-6,769.62
230.38
96.71%
882,178.00
-222,496.20
-963,479.14
-81,301.14
109.22%
882,178.00
-222,496.20
-963,479.14
-81,301.14
109.22%
1,248,178.00
-229,126.84
-1,308,128.06
-59,950.06
104.80%
5750 - ENTERPRISING ACTIVITIES Total 5700 - REVENUE-LOCAL & INTERMED 5800 - STATE PROGRAM REVENUES
5900 - FEDERAL PROGRAM REVENUES 5920 - FEDERAL REVENUES Total 5900 - FEDERAL PROGRAM REVENUES 5000 Total R E C E I P T S
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Expenditures and Encumbrances to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Budget
Encumbrance YTD
Expenditure YTD
Program: FIN3051 Page 6 of 8 File ID: A
Current Expenditure
Percent Expended
Balance
SPECIAL REVENUE FUNDS 35 - FOOD SERVICE 6100 - PAYROLL COSTS 6200 - PURCHASE & CONTRACTED SVS 6300 - SUPPLIES AND MATERIALS 6400 - OTHER OPERATING EXPENSES
-561,997.00
.00
538,996.81
25,700.30
-23,000.19
95.91%
-20,300.00
.00
12,394.20
980.02
-7,905.80
61.06%
-706,877.00
.00
680,581.70
135,735.94
-26,295.30
96.28%
-1,700.00
.00
389.10
.00
-1,310.90
22.89%
-13,900.00
.00
13,895.00
.00
-5.00
99.96%
Total Function 35 FOOD SERVICE
-1,304,774.00
.00
1,246,256.81
162,416.26
-58,517.19
95.52%
6000 Total E X P E N D I T U R E S
-1,304,774.00
.00
1,246,256.81
162,416.26
-58,517.19
95.52%
6600 - CPTL OUTLY LAND BLDG & EQUIP
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Revenue to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Estimated Revenue (Budget)
Program: FIN3051 Page 7 of 8 File ID: A
Revenue Realized Current
Revenue RealizedTo Date
Revenue Balance
Percent Realized
INTEREST AND SINKING FUNDS 5700 - REVENUE-LOCAL & INTERMED 5710 - LOCAL REAL-PROPERTY TAXES 5740 - TRANS FROM WITHIN STATE Total 5700 - REVENUE-LOCAL & INTERMED
1,280,000.00
-32,881.43
-1,351,195.67
-71,195.67
105.56%
500.00
-43.61
-578.42
-78.42
115.68%
1,280,500.00
-32,925.04
-1,351,774.09
-71,274.09
105.57%
232,879.00
-123,879.00
-308,882.00
-76,003.00
132.64%
232,879.00
-123,879.00
-308,882.00
-76,003.00
132.64%
1,513,379.00
-156,804.04
-1,660,656.09
-147,277.09
109.73%
5800 - STATE PROGRAM REVENUES 5820 - STATE PROGRAM REVENUE Total 5800 - STATE PROGRAM REVENUES 5000 Total R E C E I P T S
Date Run: 01-21-2015 2:49 PM Cnty Dist: 116-908
Combined Funds Board Report Comparison of Expenditures and Encumbrances to Budget QUINLAN ISD As of: June QUINLAN ISD 2013-2014 SCHOOL YEAR
Budget
Encumbrance YTD
Expenditure YTD
Program: FIN3051 Page 8 of 8 File ID: A
Current Expenditure
Balance
Percent Expended
INTEREST AND SINKING FUNDS 71 - DEBT SERVICE 6500 - DEBT SERVICE
-1,658,851.00
.00
1,657,687.50
.00
-1,163.50
99.93%
Total Function 71 DEBT SERVICE
-1,658,851.00
.00
1,657,687.50
.00
-1,163.50
99.93%
6000 Total E X P E N D I T U R E S
-1,658,851.00
.00
1,657,687.50
.00
-1,163.50
99.93%
End of Report