VILLAGE OF CAMPTON HILLS, IL FY25 3-MONTH YTD RESULTS
VILLAGE OF CAMPTON HILLS, IL FY25 3-MONTH YTD RESULTS
Agenda #: 5b
UNAUDITED
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |
A B | C | D | E | F | G | H | |
GENERAL FUND REVENUES | |||||||
TAXES | (2,730,463) | (911,241) | (819,128) | (1,819,222) | 33.4% | 92,114 | |
LICENSE FEES | (155,696) | (46,314) | (64,408) | (109,381) | 29.7% | (18,093) | |
FINES | (84,009) | (10,301) | (25,941) | (73,708) | 12.3% | (15,640) | |
FEES | (21,650) | (827) | (12,355) | (20,823) | 3.8% | (11,529) | |
MISCELLANEOUS REVENUES | (154,176) | (51,913) | (53,713) | (102,263) | 33.7% | (1,800) | |
TOTAL GENERAL FUND REVENUES | (3,145,993) | (1,020,597) | (975,544) | (2,125,397) | 32.4% | 45,053 | |
GENERAL FUND EXPENDITURES | |||||||
VILLAGE BOARD & LEGISLATIVE | 136,254 | 38,567 | 16,976 | 97,688 | 28.3% | (21,590) | |
ADMINISTRATIVE | 703,216 | 140,684 | 143,733 | 562,532 | 20.0% | 3,049 | |
COMMUNITY RELATIONS | 7,843 | 366 | 1,698 | 7,477 | 4.7% | 1,332 | |
POLICE | 1,709,243 | 408,093 | 340,863 | 1,301,150 | 23.9% | (67,230) | |
K-9 UNIT | 20,997 | 329 | 6,150 | 20,668 | 1.6% | 5,821 | |
POLICE COMMISSION | 2,000 | 524 | - | 1,476 | 26.2% | (524) | |
BUILDING & ZONING | 347,108 | 55,572 | 58,643 | 291,536 | 16.0% | 3,070 | |
GENERAL TRANSFERS OUT | 210,000 | - | - | 210,000 | 0.0% | - | |
TOTAL GENERAL FUND EXPENDITURES | 3,136,662 | 644,135 | 568,063 | 2,492,526 | 20.5% | (76,072) | |
NET (REVENUE) OVER EXPENDITURES | (9,332) | (376,462) | (407,481) | 367,130 | 4034.1% | (31,019) |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |
A B | C | D | E | F | G | H | |
GENERAL FUND TAXES | |||||||
10-4110 Income Tax | (1,753,209) | (597,763) | (548,200) | (1,155,446) | 34.1% | 49,563 | |
10-4111 Building Permits | (200,000) | (90,395) | (73,049) | (109,605) | 45.2% | 17,346 | |
10-4120 Local Use Tax | (437,414) | (100,059) | (105,290) | (337,355) | 22.9% | (5,231) | |
10-4130 Sales Tax | (300,000) | (110,058) | (82,715) | (189,942) | 36.7% | 27,343 | |
10-4135 Video Gaming Tax | (23,607) | (8,531) | (5,840) | (15,076) | 36.1% | 2,691 | |
10-4140 Cannabis Use Tax | (16,233) | (4,436) | (4,034) | (11,797) | 27.3% | 402 | |
GENERAL FUND TAXES | (2,730,463) | (911,241) | (819,128) | (1,819,222) | 33.4% | 92,114 | |
GENERAL FUND FEE REVENUE | |||||||
10-4250 Liquor License | (17,500) | (9,000) | (14,950) | (8,500) | 51.4% | (5,950) | |
10-4255 Video Gaming License Fees | (5,839) | - | (2,393) | (5,839) | 0.0% | (2,393) | |
10-4271 At & T Uverse Franchise Fees | (8,185) | - | (5,457) | (8,185) | 0.0% | (5,457) | |
10-4272 Electric Aggregation Admin Fee | - | - | - | - | - | - | |
10-4273 Nicor Franchise Fees | - | - | - | - | - | - | |
10-4276 Comcast Franchise Fees | (120,000) | (36,939) | (39,227) | (83,061) | 30.8% | (2,288) | |
10-4282 Solicitation Fees | (1,350) | (375) | (500) | (975) | 27.8% | (125) | |
10-4156 Reimbursement from Fed / State | (2,821) | - | (1,881) | (2,821) | 0.0% | (1,881) | |
GENERAL FUND FEE REVENUE | (155,696) | (46,314) | (64,408) | (109,381) | 29.7% | (18,093) | |
GENERAL FUND FINES REVENUE | |||||||
10-4310 Court Fines | (15,000) | (1,882) | (2,977) | (13,118) | 12.5% | (1,095) | |
10-4311 Local Prosecutor Fees | (84) | (37) | (31) | (47) | 44.2% | 6 | |
10-4312 DSP Agency Fines | (69) | - | (4) | (69) | 0.0% | (4) | |
10-4313 Supervision Fees | - | - | - | - | - | - | |
10-4314 DUI Prevention Fund | (309) | (350) | (175) | 41 | 113.4% | 175 | |
10-4318 E-Citations | (947) | (100) | (227) | (847) | 10.6% | (127) | |
10-4319 Fine Agency Fees | (40,000) | (6,247) | (11,478) | (33,753) | 15.6% | (5,231) | |
10-4330 Police Fines | (18,000) | (1,475) | (5,774) | (16,525) | 8.2% | (4,299) | |
10-4331 DUI Fines | (3,000) | - | - | (3,000) | 0.0% | - | |
10-4332 DUI Restitution Fines | (3,500) | - | (3,000) | (3,500) | 0.0% | (3,000) | |
10-4340 Towing Fees | (1,100) | (210) | (585) | (890) | 19.1% | (375) | |
10-4380 Code Violation Fines | (2,000) | - | (1,689) | (2,000) | 0.0% | (1,689) | |
10-4381 False Alarm Fines | - | - | - | - | - | - | |
GENERAL FUND FINES REVENUE | (84,009) | (10,301) | (25,941) | (73,708) | 12.3% | (15,640) |
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |||
A B | C | D | E | F | G | H | |||
BUILDING & ZONING FEES | |||||||||
10-4480 Zoning Development/Variance Fe | (1,650) | (550) | - | (1,100) | 33.3% | 550 | |||
10-4483 Driveway Access Permit Fees | (20,000) | (277) | (12,355) | (19,723) | 1.4% | (12,079) | |||
BUILDING & ZONING FEES | (21,650) | (827) | (12,355) | (20,823) | 3.8% | (11,529) | |||
MISCELLANEOUS REVENUE | |||||||||
10-4820 K-9 Unit Donations & Revenues | - | - | (1,842) | - | - | (1,842) | |||
10-4910 Interest | (144,231) | (49,038) | (49,120) | (95,193) | 34.0% | (82) | |||
10-4941 FOIA | (38) | - | (25) | (38) | 0.0% | (25) | |||
10-4942 Accident Reports | (848) | (325) | (175) | (523) | 38.3% | 150 | |||
10-4980 Tenant Rental Income | (8,925) | (2,550) | (2,550) | (6,375) | 28.6% | - | |||
10-4990 Miscellaneous Income | (135) | - | - | (135) | 0.0% | - | |||
MISCELLANEOUS REVENUE | (154,176) | (51,913) | (53,713) | (102,263) | 33.7% | (1,800) | |||
VILLAGE BOARD & LEGISLATIVE | |||||||||
10-01-4300 Officials Allowance | 50,800 | 11,165 | 11,565 | 39,635 | 22.0% | 399 | |||
10-01-4610 Social Security | 1,629 | 692 | - | 936 | 42.5% | (692) | |||
10-01-4620 Medicare | 381 | 162 | - | 219 | 42.5% | (162) | |||
10-01-5330 General Legal Service | 75,000 | 26,066 | 2,682 | 48,934 | 34.8% | (23,384) | |||
10-01-5340 Litigation Svcs | - | - | - | - | - | - | |||
10-01-5370 Information Tech - Elected Off | - | - | - | - | - | - | |||
10-01-5395 Other Professional Svcs. | 1,969 | - | 1,250 | 1,969 | 0.0% | 1,250 | |||
10-01-5540 Printing & Publishing | - | - | - | - | - | - | |||
10-01-5610 Dues and Subscriptions | 3,462 | - | 1,200 | 3,462 | 0.0% | 1,200 | |||
10-01-5620 Travel/Lodging/Meals | - | - | - | - | - | - | |||
10-01-5630 Training & Registration | 780 | 481 | 195 | 298 | 61.7% | (286) | |||
10-01-5930 Risk Management Contribution | 2,100 | - | - | 2,100 | 0.0% | - | |||
10-01-6550 Meeting Supplies | 134 | - | 85 | 134 | 0.0% | 85 | |||
VILLAGE BOARD & LEGISLATIVE | 136,254 | 38,567 | 16,976 | 97,688 | 28.3% | (21,590) |
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
ACCOUNT # | ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |||||
A | B | C | D | E | F | G | H | |||||
GENERAL ADMINISTRATIVE | ||||||||||||
10-11-4200 | Salaries | - | 40,500 | - | (40,500) | - | (40,500) | |||||
10-11-4210 | Salaries-Regular | 204,120 | 46,030 | 71,236 | 158,090 | 22.6% | 25,206 | |||||
10-11-4211 | Bonus - Admin Department | - | - | - | - | - | - | |||||
10-11-4250 | HSA - Village Contributions | - | - | 538 | - | - | 538 | |||||
10-11-4510 | Health & Dental Insurance | 15,114 | (533) | 10,568 | 15,646 | -3.5% | 11,101 | |||||
10-11-4520 | Life Insurance | 87 | (5) | 37 | 92 | -6.0% | 43 | |||||
10-11-4530 | Unemployment Ins | 493 | 141 | 135 | 352 | 28.6% | (6) | |||||
10-11-4610 | Social Security | 12,655 | 2,831 | 5,679 | 9,824 | 22.4% | 2,848 | |||||
10-11-4620 | Medicare | 2,960 | 662 | 1,328 | 2,298 | 22.4% | 666 | |||||
10-11-4640 | IMRF Contribution | 17,697 | 3,991 | 6,503 | 13,706 | 22.6% | 2,512 | |||||
10-11-5110 | Building/Equip Maintenance | 8,883 | 1,331 | 4,108 | 7,552 | 15.0% | 2,778 | |||||
10-11-5130 | Fox Mill Square Assoc | 15,000 | - | 13,457 | 15,000 | 0.0% | 13,457 | |||||
10-11-5150 | Real Estate Taxes | (2,748) | 13 | (1,844) | (2,760) | -0.5% | (1,856) | |||||
10-11-5310 | Accounting/Audit Service | 20,000 | 2,760 | 1,613 | 17,240 | 13.8% | (1,147) | |||||
10-11-5330 | General Legal Service | - | 4,358 | 5,000 | (4,358) | - | 643 | |||||
10-11-5360 | Janitorial Service | 4,504 | 1,600 | - | 2,904 | 35.5% | (1,600) | |||||
10-11-5370 | Information Tech - Admin | 49,207 | 5,017 | 13,034 | 44,190 | 10.2% | 8,017 | |||||
10-11-5385 | Animal Control | 500 | - | - | 500 | 0.0% | - | |||||
10-11-5391 | Contracts - Admin. Dept. | 162,000 | - | - | 162,000 | 0.0% | - | |||||
10-11-5395 | Other Professional Svcs. | 18,443 | - | 493 | 18,443 | 0.0% | 493 | |||||
10-11-5510 | Postage | 643 | 68 | 231 | 575 | 10.6% | 163 | |||||
10-11-5520 | Telephone | 2,910 | 340 | 852 | 2,571 | 11.7% | 513 | |||||
10-11-5540 | Printing & Publishing | 941 | 157 | 390 | 784 | 16.7% | 233 | |||||
10-11-5610 | Dues and Subscriptions | 13,133 | 25,685 | 6,255 | (12,552) | 195.6% | (19,431) | |||||
10-11-5620 | Travel/Lodging/Meals | 969 | 129 | 136 | 840 | 13.3% | 7 | |||||
10-11-5630 | Training & Registration | 1,131 | 1,497 | 35 | (366) | 132.4% | (1,462) | |||||
10-11-5710 | Utilities | 10,624 | 2,337 | 1,597 | 8,286 | 22.0% | (740) | |||||
10-11-5790 | Bank Charges | 429 | 199 | - | 230 | 46.4% | (199) | |||||
10-11-5930 | Risk Management Contribution | 10,500 | - | - | 10,500 | 0.0% | - | |||||
10-11-5940 | Copier lease/maintenance | 3,790 | 919 | 831 | 2,871 | 24.2% | (87) | |||||
10-11-6510 | Office Supplies | 1,943 | 330 | 489 | 1,614 | 17.0% | 160 | |||||
10-11-6520 | Operating Supplies | 945 | 26 | 492 | 919 | 2.7% | 466 | |||||
10-11-6540 | Janitorial Supplies | 518 | 277 | 179 | 240 | 53.6% | (99) | |||||
10-11-6550 | Meeting Supplies | 377 | 27 | 60 | 350 | 7.1% | 33 | |||||
10-11-7200 | Interest | - | - | - | - | - | - | |||||
10-11-8300 | Office Equipment | 450 | - | 300 | 450 | 0.0% | 300 | |||||
10-11-9040 | Otter Creek Watershed | - | - | - | - | - | - | |||||
10-11-9050 | Water Resource Committee | - | - | - | - | - | - |
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | ||||||
A B | C | D | E | F | G | H | ||||||
10-11-9290 Miscellaneous / Contingency | 125,000 | - | - | 125,000 | 0.0% | - | ||||||
GENERAL ADMINISTRATIVE | 703,216 | 140,684 | 143,733 | 562,532 | 20.0% | 3,049 | ||||||
COMMUNITY RELATIONS | ||||||||||||
10-11-9370 Community Relations | 1,932 | - | 51 | 1,932 | 0.0% | 51 | ||||||
10-11-9380 National Night Out | 5,911 | 366 | 1,647 | 5,545 | 6.2% | 1,281 | ||||||
COMMUNITY RELATIONS | 7,843 | 366 | 1,698 | 7,477 | 4.7% | 1,332 | ||||||
POLICE SERVICES | ||||||||||||
10-21-4210 Salaries-Regular | 710,924 | 210,120 | 164,922 | 500,804 29.6% | (45,198) | |||||||
10-21-4211 Bonus - Police Department | 28,500 | - | - | 28,500 0.0% | - | |||||||
10-21-4214 Salaries - Training for Police | 62,000 | - | 13,880 | 62,000 0.0% | 13,880 | |||||||
10-21-4220 Salaries-Part Time Employees | 68,670 | 59,645 | 27,035 | 9,025 86.9% | (32,610) | |||||||
10-21-4230 Salaries-Overtime | 128,447 | 7,993 | 15,423 | 120,454 6.2% | 7,430 | |||||||
10-21-4250 HSA - Village Contributions | - | - | 1,154 | - - | 1,154 | |||||||
10-21-4510 Health & Dental Insurance | 158,773 | 18,645 | 38,064 | 140,128 11.7% | 19,419 | |||||||
10-21-4520 Life Insurance | 544 | 73 | 125 | 471 13.4% | 52 | |||||||
10-21-4530 Unemployment Insurance | - | 329 | (690) | (329) - | (1,018) | |||||||
10-21-4610 Social Security Contribution | 4,258 | 3,509 | 1,856 | 749 82.4% | (1,653) | |||||||
10-21-4620 Medicare Contribution | 12,768 | 3,968 | 3,107 | 8,799 31.1% | (861) | |||||||
10-21-4630 Retirement Contribution | 195,753 | 45,180 | 42,900 | 150,573 23.1% | (2,280) | |||||||
10-21-4710 Uniforms Allowance | 15,000 | 1,427 | 645 | 13,573 9.5% | (782) | |||||||
10-21-4720 Bullet Proof Vests | 2,500 | - | - | 2,500 0.0% | - | |||||||
10-21-5120 Maint Svc-Equipment | 2,385 | 344 | - | 2,042 14.4% | (344) | |||||||
10-21-5130 Maint Svc-Vehicle | 25,631 | 9,190 | 6,334 | 16,441 35.9% | (2,856) | |||||||
10-21-5180 Maint Svc-Software | 1,654 | - | - | 1,654 0.0% | - | |||||||
10-21-5330 Legal Services | 29,563 | 3,518 | 2,850 | 26,045 11.9% | (668) | |||||||
10-21-5360 Janitorial Services | - | - | - | - - | - | |||||||
10-21-5370 Information Tech - Police | 39,972 | 27,287 | 936 | 12,685 68.3% | (26,351) | |||||||
10-21-5395 Other Prof. Services | - | - | - | - - | - | |||||||
10-21-5510 Postage & Shipping | 73 | 46 | - | 27 63.4% | (46) | |||||||
10-21-5520 Telephone | 7,373 | 1,106 | 1,523 | 6,266 15.0% | 417 | |||||||
10-21-5540 Printing & Publishing | 1,008 | 365 | 65 | 643 36.2% | (300) | |||||||
10-21-5560 Dispatch | 87,790 | - | - | 87,790 0.0% | - | |||||||
10-21-5610 Dues and Subscriptions | 6,500 | 1,662 | 9,435 | 4,838 25.6% | 7,773 | |||||||
10-21-5620 Travel/Lodging/Meals | 1,032 | 354 | 631 | 678 34.3% | 277 | |||||||
10-21-5630 Training & Registration | 10,194 | 1,800 | 1,288 | 8,394 17.7% | (513) | |||||||
10-21-5640 Community Relations | 368 | - | - | 368 0.0% | - | |||||||
10-21-5650 Periodicals & Publications | - | - | - | - - | - | |||||||
10-21-5710 Utilities | 566 | 150 | 123 | 416 26.5% | (27) |
ACCOUNT # | ACCOUNT NAME FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | ||||||||
167 | A 10-21-5930 | B Risk Management Contribution | C | 52,500 | D | - | E | - | F | 52,500 | G | 0.0% | H | - |
168 | 10-21-5940 | Copier lease/maintenance | 1,403 | 394 | 196 | 1,009 | 28.1% | (197) | ||||||
169 | 10-21-5990 | Other Contractual Services | - | - | - | - | - | - | ||||||
170 | 10-21-6120 | Maint Supplies-Equipment | 544 | 158 | - | 386 | 29.0% | (158) | ||||||
171 | 10-21-6510 | Office Supplies | 312 | 400 | 71 | (88) | 128.1% | (329) | ||||||
172 | 10-21-6520 | Operating Supplies | 6,000 | 182 | 636 | 5,818 | 3.0% | 454 | ||||||
173 | 10-21-6550 | Auto Fuel | 38,738 | 8,457 | 8,352 | 30,281 | 21.8% | (104) | ||||||
174 | 10-21-8300 | Equipment | 5,000 | 531 | - | 4,469 | 10.6% | (531) | ||||||
175 | 10-21-8500 | Computers | 2,500 | 1,260 | - | 1,240 | 50.4% | (1,260) | ||||||
176 | POLICE SERVICES | 1,709,243 | 408,093 | 340,863 | 1,301,150 | 23.9% | (67,230) | |||||||
177 | ||||||||||||||
178 | K9 UNIT | |||||||||||||
179 | 10-21-9380 K-9 Unit Expenditures | 20,997 | 329 | 6,150 | 20,668 | 1.6% | 5,821 | |||||||
180 | K9 UNIT | 20,997 | 329 | 6,150 | 20,668 | 1.6% | 5,821 | |||||||
181 | ||||||||||||||
182 | POLICE COMMISSION | |||||||||||||
183 | 10-22-5395 Other Professional Svcs. | 2,000 | 524 | - | 1,476 | 26.2% | (524) | |||||||
184 | POLICE COMMISSION | 2,000 | 524 | - | 1,476 | 26.2% | (524) | |||||||
185 | ||||||||||||||
186 | BUILDING & ZONING | |||||||||||||
187 | 10-31-4210 | Salaries-Regular | 39,749 | 7,316 | 12,818 | 32,432 | 18.4% | 5,501 | ||||||
188 | 10-31-4520 | Life Insurance | (10) | - | (6) | (10) | 0.0% | (6) | ||||||
189 | 10-31-4530 | Unemployment Insurance | 36 | - | 13 | 36 | 0.0% | 13 | ||||||
190 | 10-31-4610 | Social Security | 2,464 | 454 | - | 2,011 | 18.4% | (454) | ||||||
191 | 10-31-4620 | Medicare | 576 | 106 | - | 470 | 18.4% | (106) | ||||||
192 | 10-31-4640 | IMRF Contribution | 3,446 | 634 | 759 | 2,812 | 18.4% | 125 | ||||||
193 | 10-31-5320 | Engineering Services | 20,000 | 3,275 | 7,584 | 16,725 | 16.4% | 4,309 | ||||||
194 | 10-31-5330 | Legal Services | 24,000 | 4,568 | 3,518 | 19,433 | 19.0% | (1,050) | ||||||
195 | 10-31-5350 | Inspection Services | 136,054 | 23,467 | 24,281 | 112,588 | 17.2% | 814 | ||||||
196 | 10-31-5370 | Information Tech - B & Z | 2,250 | - | - | 2,250 | 0.0% | - | ||||||
197 | 10-31-5391 | Contracts - B & Z Dept. | 87,360 | 8,298 | 9,026 | 79,062 | 9.5% | 728 | ||||||
198 | 10-31-5395 | Other Professional Svcs. | - | - | - | - | - | - | ||||||
199 | 10-31-5510 | Postage & Shipping | - | - | - | - | - | - | ||||||
200 | 10-31-5540 | Printing & Publishing | - | - | - | - | - | - | ||||||
201 | 10-31-5610 | Training | - | - | - | - | - | - | ||||||
202 | 10-31-5960 | Driveway Access Fees - To CTHD | 30,000 | 7,200 | - | 22,800 | 24.0% | (7,200) | ||||||
203 | 10-31-5980 | Other Permit Fees - To CTHD | 1,170 | 255 | 650 | 915 | 21.8% | 395 | ||||||
204 10-31-6510 Office Supplies 12 | - | - | 12 | 0.0% | - | |||||||||
205 BUILDING & ZONING 347,108 | 55,572 | 58,643 | 291,536 | 16.0% | 3,070 | |||||||||
206 |
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |||||
A B | C | D | E | F | G | H | |||||
GENERAL - TRANSFERS OUT | |||||||||||
10-00-8520 Trans Out - To Capital Project | 210,000 | - | - | 210,000 | 0.0% | - | |||||
GENERAL - TRANSFERS OUT | 210,000 | - | - | 210,000 | 0.0% | - |
207
208
209
210
ACCOUNT # ACCOUNT NAME | FY25 BUDGET | FY25 ACTUALS YTD | FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |
A B | C | D | E | F | G | H | |
MFT FUND REVENUE | |||||||
13-4170 Motor Fuel Tax Fund Allotment | (254,382) | (59,625) | (63,195) | (194,757) | 23.4% | (3,570) | |
13-4190 MFT Transportation Renewal | (217,700) | (59,339) | (55,620) | (158,361) | 27.3% | 3,719 | |
13-4910 MFT Interest Income | (72,115) | (6,767) | (18,814) | (65,348) | 9.4% | (12,046) | |
MFT FUND REVENUE | (544,197) | (125,732) | (137,629) | (418,465) | 23.1% | (11,897) | |
MFT EXPENDITURES | |||||||
13-00-5160 Maint. Svcs. - Snow Removal | 50,000 | - | - | 50,000 | 0.0% | - | |
13-00-5180 Maint. Svcs. - Trees, Trimming | 15,000 | - | 3,760 | 15,000 | 0.0% | 3,760 | |
13-00-5320 Engineering Services | - | 18,829 | 27,017 | (18,829) | - | 8,188 | |
13-00-5401 Grant Exp - REBUILD IL BONDS | - | - | 733,600 | - | - | 733,600 | |
13-00-5413 Grant Exp - Misc. Grants | - | - | - | - | - | - | |
13-00-9160 Misc Road Projects | 816,000 | - | 800,198 | 816,000 | 0.0% | 800,198 | |
MFT EXPENDITURES | 881,000 | 18,829 | 1,564,575 | 862,171 | 2.1% | 1,545,746 | |
MFT FUND - NET (REVENUE) OVER EXPENDITURES | 336,803 | (106,903) | 1,426,946 | 443,705 | -31.7% | 1,533,849 | |
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229 | ACCOUNT # A ROAD & BRIDGE REVENUE | ACCOUNT NAME B | FY25 BUDGET FY25 ACTUALS YTD FY24 ACTUALS YTD C D E | BUDGET REMAINING F | % BUDGET SPENT G | FY25 VARIANCE TO FY24 H | |||
230 | 14-4151 | R&B Taxes - Campton Twp | (558,274) | (311,518) | (299,993) | (246,756) | 55.8% | 11,524 | |
231 | 14-4152 | R&B Taxes - Plato Twp | (6) | (7,834) | (3) | 7,828 | 133461.3% | 7,831 | |
232 | 14-4153 | R&B Taxes - Elgin Twp | (15,165) | (4) | (8,189) | (15,161) | 0.0% | (8,185) | |
233 | 14-4751 | Transfer in From General Fund | (140,000) | - | - | (140,000) | 0.0% | - | |
234 | 14-4910 | R&B - Interest Income | (1,442) | (12,793) | (2,628) | 11,351 | 887.2% | 10,165 | |
235 | ROAD & | BRIDGE REVENUE | (714,886) | (332,149) | (310,813) | (382,738) | 46.5% | 21,335 | |
236 | |||||||||
237 | ROAD & | BRIDGE EXPENDITURE | |||||||
238 | 14-00-5770 | R & B Utilities | 4,882 | 904 | 761 | 3,978 | 18.5% | (143) | |
239 | 14-00-5810 | IGA - Campton Township HD | 644,156 | - | 77,643 | 644,156 | 0.0% | 77,643 | |
240 | 14-00-5820 | Plato Township Services | 44,442 | 6,298 | 15,600 | 38,144 | 14.2% | 9,302 | |
241 | ROAD & BRIDGE EXPENDITURE | 693,479 | 7,202 | 94,004 | 686,277 | 1.0% | 86,802 | ||
242 | |||||||||
243 | |||||||||
244 | ROAD & BRIDGE FUND - NET (REVENUE) OVER EXPENDIT | (21,407) | (324,946) | (216,810) | 303,539 | 1517.9% | 108,137 | ||
245 |
ACCOUNT # | ACCOUNT NAME | FY25 BUDGET FY25 ACTUALS YTD FY24 ACTUALS YTD | BUDGET REMAINING | % BUDGET SPENT | FY25 VARIANCE TO FY24 | |||
A | B | C D E | F | G | H | |||
246 | CAPITAL FUND REVENUES | |||||||
247 | 20-4751 | Transfers In from General Fund | (70,000) | - | - | (70,000) | 0.0% | - |
248 | 20-4910 | Interest | (7,212) | (4,499) | (15,101) | (2,713) | 62.4% | (10,603) |
249 | CAPITAL | FUND REVENUES | (77,212) | (4,499) | (15,101) | (72,713) | 5.8% | (10,603) |
250 | ||||||||
251 | CAPITAL | FUND EXPENDITURES | ||||||
252 | 20-00-5003 | Tornado Siren | - | - - | - | - | - | |
253 | 20-00-5004 | Miscellaneous Capital Projects | 20,000 | - 480 | 20,000 | 0.0% | 480 | |
254 | 20-00-5005 | Police Vehicles | 70,000 | 70,441 - | (441) | 100.6% | (70,441) | |
255 | 20-00-5010 | Village Hall Improvements | - | - 65 | - | - | 65 | |
256 20-00-5012 Truck Scale - | - | - | - | - | - | |||
257 CAPITAL FUND EXPENDITURES 90,000 258 259 | 70,441 | 545 | 19,559 | 78.3% | (69,896) | |||
260 CAPITAL FUND - NET (REVENUE) OVER EXPENDITURES 12,788 65,942 (14,557) | (53,154) 515.7% | (80,499) | ||||||
261 | ||||||||
262 | ||||||||
263 | ||||||||
264 | ||||||||
265 | ||||||||
266 | ||||||||
267 | ||||||||
268 | ||||||||
269 | ||||||||
270 | ||||||||
271 | ||||||||
272 | ||||||||
273 | ||||||||
274 | ||||||||
275 | ||||||||
276 | ||||||||
277 | 3.16% | |||||||
278 | 3.16% | |||||||
279 | ||||||||
280 | 5.37% | |||||||
281 | 5.37% | |||||||
282 | ||||||||
283 | ||||||||
284 | TOTAL | $ 6,309,005.70 |
GENERAL FUND - NET (REVENUE) OVER EXPENDITURES | (9,332) | (376,462) | (407,481) | 367,130 | 4034.1% | (31,019) |
MFT FUND - NET (REVENUE) OVER EXPENDITURES | 336,803 | (106,903) | 1,426,946 | 443,705 | -31.7% | 1,533,849 |
ROAD & BRIDGE FUND - NET (REVENUE) OVER EXPENDIT | (21,407) | (324,946) | (216,810) | 303,539 | 1517.9% | 108,137 |
CAPITAL FUND - NET (REVENUE) OVER EXPENDITURES | 12,788 | 65,942 | (14,557) | (53,154) | 515.7% | (80,499) |
VILLAGE WIDE - NET (REVENUE) OVER EXPENDITURES | 318,851 | (742,368) | 788,099 | 1,061,220 | -232.8% | 1,530,467 |
CASH BALANCES | |||
FINANCIAL INSTITUTION | NAME | BALANCE | DATE |
First American Bank | Operating | $ 327,596.06 | 8/16/2024 |
First American Bank | Money Market | $ 81,696.17 | 8/16/2024 |
First American Bank | ARPA | $ 171,528.02 | 8/16/2024 |
Total First American Bank | $ 580,820.25 | 8/16/2024 | |
Illinois Funds | General | $ 5,138,127.11 | 8/16/2024 |
Illinois Funds - 1500000820 | MFT | $ 590,058.34 | 8/16/2024 |
Total Illinois Funds | $ 5,728,185.45 | 8/16/2024 |