The URL can be used to link to this page

Administration Committee Packet 2021 10-20-21 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, October 20, 2021 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: September 22, 2021 New Business: 1. ADM 2021-38 Budget Report for September 2021 2. ADM 2021-39 Treasurer’s Report for September 2021 3. ADM 2021-40 Website Report for September 2021 4. ADM 2021-41 2011 Bond Refinancing Discussion 5. ADM 2021-42 Meeting Schedule for 2022 Old Business: Additional Business: 2019/2020 City Council Goals - Administration Committee Goal Priority Staff “Staffing” 1 Bart Olson, Rob Fredrickson, James Jensen, Eric Dhuse, Tim Evans & Erin Willrett “Municipal Building Needs and Planning” 2 Bart Olson, Rob Fredrickson, James Jensen, Eric Dhuse, Tim Evans & Erin Willrett “Road to Better Roads Funding” 3 Bart Olson, Rob Fredrickson & Eric Dhuse “Metra Extension” 7 Bart Olson, Rob Fredrickson, Eric Dhuse, Krysti Barksdale-Noble & Erin Willrett “Automation and Technology” 11 (tie) Bart Olson, Erin Willrett & Lisa Pickering “Grant Opportunities and Planning” 11 (tie) Bart Olson, Erin Willrett & Tim Evans “Revenue Growth” 13 Rob Fredrickson, Krysti Barksdale-Noble & Lynn Dubajic “Special Events Amplification” 14 (tie) Erin Willrett & Tim Evans “Public Relations and Outreach” 16 Bart Olson & Erin Willrett United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Wednesday, October 20, 2021 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1.September 22, 2021 □Approved __________ □As presented □With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1.ADM 2021-38 Budget Report for September 2021 □Informational Item □Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2021-39 Treasurer’s Report for September 2021 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2021-40 Website Report for September 2021 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2021-41 2011 Bond Refinancing Discussion □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2021-42 Meeting Schedule for 2022 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number Minutes Tracking Number Agenda Item Summary Memo Minutes of the Administration Committee – September 22, 2021 Administration Committee – October 20, 2021 Majority Committee Approval Minute Taker Name Department Page 1 of 2 DRAFT UNITED CITY OF YORKVILLE SPECIAL ADMINISTRATION COMMITTEE MEETING Wednesday, September 22, 2021 6:00pm City Hall Conference Room 800 Game Farm Road, Yorkville, IL Note: This meeting was held in accordance with Public Act 101-0640 and Gubernatorial Disaster Proclamation issued by Governor Pritzker pursuant to the powers vested in the Governor under the Illinois Emergency Management Agency Act. This allows remote attendance for this meeting to encourage social distancing due to the current Covid-19 pandemic. Committee Members In Attendance: Chairman Jackie Milschewski/in-person Alderman Chris Funkhouser/in-person Alderman Dan Transier/in-person Absent: Alderman Seaver Tarulis Other City Officials In Attendance: City Administrator Bart Olson/in-person Assistant City Administrator Erin Willrett/in-person Finance Director Rob Fredrickson/in-person Others in Attendance: None The meeting was called to order at 6:00pm by Chairman Jackie Milschewski. Citizen Comments: None Minutes for Correction/Approval: June 16, 2021 Alderman Funkhouser made a motion to approve the minutes as presented. New Business: 1. ADM 2021-32 Budget Report for June – August 2021 Mr. Olson gave an overview of the sales tax and said revenue continues to exceed expectations. Municipal sales tax for May, posted in August, was the highest month ever. He said there are usually two peaks in a year. He pointed out a 27% increase year over year for June sales and he said most businesses in Yorkville did very well. He noted there is also Amazon-based sales tax on the report. Page 2 of 2 2. ADM 2021-33 Treasurer's Report for June – August 2021 Finance Director Fredrickson reported the following: June July August Beg. Fund Bal. Unaudited: $ --- $ --- $14,992,729 YTD Revenues: $19,041,088 $20,933,252 $24,670,090 YTD Expenses $ 6,376,041 $ 8,477,231 $11,146,544 Projected Ending Fund Balance $ --- $ --- $21,989,397 3. ADM 2021-34 Cash Statement for November-December 2020, January-July, 2021 Mr. Fredrickson said these reports are informational and show cash and invested balances. He said the reports are now up-to-date. 4. ADM 2021-35 Website Report for June-August 2021 Ms. Willrett said the social media was greatly increased in July due to the events held. 5. ADM 2021-36 Fiscal Year End 2021 Budget Report (Unaudited) Mr. Olson commented he doesn't expect any changes on the report prepared by Finance Director Fredrickson which will be presented October 12th at the City Council meeting. He said it was a very good year, the state taxes were substantially up and the Fund Balance will be about 50% going forward--all putting the city in a good position. 6. ADM 2021-37 Tax Levy Estimate Mr. Fredrickson prepared a memo recommending the same action as last year which is to capture new construction only, apply a limiting rate to the Library and set the dollar amount at new construction only. Mr. Olson said the estimate is always set higher to allow for changes if needed. He said the recommended levy amount for the city is $3.542 million, $934,000 for the Library operations and $847,000 for Library building bonds. He said the average property taxes would remain about the same. Administrator Olson said staff is still waiting for the police pension fund amount. Alderman Transier asked if the police pension fund estimate is expected to be higher and how much time there is to fully fund it. Mr. Fredrickson said he expects the estimate to be lower and it should be 90% funded by 2040. Alderman Funkhouser inquired what would happen if the estimate was frozen and there was no increase. Mr. Olson said the state would sequester revenues and add it to the funds anyway and that the city is slightly overfunding already. Mr. Olson said a vote on the tax levy will be needed before publishing for a Public Hearing and this will be moved forward to the city Council for discussion. Old Business: None Additional Business: None There was no further business and the meeting adjourned at 6:17pm Respectfully transcribed by Marlys Young, Minute Taker/in-person Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number New Business #1 Tracking Number ADM 2021-38 Budget Report for September 2021 Administration Committee – October 20, 2021 Informational None Monthly budget report and income statement. Rob Fredrickson Finance Name Department % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetGENERAL FUND REVENUESTaxes01-000-40-00-4000 PROPERTY TAXES 98,145 987,686 30,162 81,453 841,468 2,038,914 2,091,475 97.49%01-000-40-00-4010PROPERTY TAXES-POLICE PENSION62,631 630,291 19,248 51,979 536,982 1,301,131 1,334,771 97.48%01-000-40-00-4030 MUNICIPAL SALES TAX 258,698 389,717 353,904 409,710 401,970 1,814,000 3,582,508 50.63%01-000-40-00-4035 NON-HOME RULE SALES TAX 195,140 299,299 283,575 306,463 317,410 1,401,887 2,649,473 52.91%01-000-40-00-4040 ELECTRIC UTILITY TAX - 154,821 - - 194,606 349,427 715,000 48.87%01-000-40-00-4041 NATURAL GAS UTILITY TAX 28,081 22,730 18,762 15,322 16,927 101,821 270,000 37.71%01-000-40-00-4043 EXCISE TAX 17,210 17,577 16,333 16,969 17,463 85,552 209,000 40.93%01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 695 695 695 3,475 8,340 41.66%01-000-40-00-4045 CABLE FRANCHISE FEES 66,083 - 7,870 66,926 - 140,879 300,000 46.96%01-000-40-00-4050 HOTEL TAX 3,764 22,511 5,647 7,909 7,683 47,514 80,000 59.39%01-000-40-00-4055 VIDEO GAMING TAX 19,200 19,886 19,246 19,914 18,711 96,957 140,000 69.26%01-000-40-00-4060 AMUSEMENT TAX 1,326 996 42,268 2,429 20,099 67,118 125,000 53.69%01-000-40-00-4065 ADMISSIONS TAX - - - - - - 145,000 0.00%01-000-40-00-4070BDD TAX - KENDALL MARKETPLACE24,419 38,802 36,147 40,129 44,783 184,280 379,950 48.50%01-000-40-00-4071 BDD TAX - DOWNTOWN 2,835 5,503 3,781 4,395 3,811 20,325 30,000 67.75%01-000-40-00-4072 BDD TAX - COUNTRYSIDE 2,307 2,772 2,834 3,053 3,340 14,306 12,000 119.22%01-000-40-00-4075 AUTO RENTAL TAX 1,273 1,477 1,506 1,325 1,827 7,408 16,500 44.90%Intergovernmental01-000-41-00-4100 STATE INCOME TAX 320,085 280,842 251,940 141,468 149,398 1,143,734 2,336,774 48.94%01-000-41-00-4105 LOCAL USE TAX 49,471 63,245 57,461 52,889 60,281 283,346 937,660 30.22%01-000-41-00-4106 CANNABIS EXCISE TAX 2,179 2,529 2,229 1,989 2,366 11,293 19,596 57.63%01-000-41-00-4110 ROAD & BRIDGE TAX 3,175 26,433 874 1,887 21,034 53,404 54,975 97.14%01-000-41-00-4120 PERSONAL PROPERTY TAX 6,292 - 4,585 583 - 11,459 16,500 69.45%01-000-41-00-4160 FEDERAL GRANTS 200,000 5,682 7,516 - - 213,198 15,275 1395.73%01-000-41-00-4168STATE GRANT - TRF SIGNAL MAINT- - - - 12,329 12,329 20,000 61.65%01-000-41-00-4170 STATE GRANTS - - - 18,060 18,060 36,120 - 0.00%01-000-41-00-4182 MISC INTERGOVERNMENTAL - - - 674 - 674 1,000 67.35%Licenses & Permits01-000-42-00-4200 LIQUOR LICENSES 1,250 804 - 3,010 600 5,664 65,000 8.71%01-000-42-00-4205 OTHER LICENSES & PERMITS 936 1,662 150 149 - 2,897 9,500 30.49%01-000-42-00-4210 BUILDING PERMITS 81,647 85,423 80,985 127,927 79,497 455,479 450,000 101.22%Fines & ForfeitsUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 20211 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-000-43-00-4310 CIRCUIT COURT FINES2,743 1,825 4,994 3,824 5,190 18,575 35,000 53.07%01-000-43-00-4320ADMINISTRATIVE ADJUDICATION1,354 2,139 1,214 2,746 1,243 8,696 26,500 32.82%01-000-43-00-4323 OFFENDER REGISTRATION FEES 115 - - 35 70 220 350 62.86%01-000-43-00-4325 POLICE TOWS 4,000 5,000 3,000 6,500 9,500 28,000 55,000 50.91%Charges for Service01-000-44-00-4400 GARBAGE SURCHARGE 244 238,580 358 240,802 362 480,344 1,376,063 34.91%01-000-44-00-4405 UB COLLECTION FEES 13,327 12,756 - 16,871 17,252 60,207 165,000 36.49%01-000-44-00-4407 LATE PENALTIES - GARBAGE 11 4,587 18 5,083 6 9,705 21,000 46.21%01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 18,213 18,213 18,213 18,213 18,213 91,067 218,560 41.67%01-000-44-00-4474 POLICE SPECIAL DETAIL - 240 - - 2,213 2,453 500 490.50%Investment Earnings01-000-45-00-4500 INVESTMENT EARNINGS 278 258 431 454 465 1,885 20,000 9.42%01-000-45-00-4550 GAINS ON INVESTMENT - - - - 3,649 3,649 - 0.00%Reimbursements01-000-46-00-4604 REIMB - ENGINEERING EXPENSES - - - - - - 10,000 0.00%01-000-46-00-4680 REIMB - LIABILITY INSURANCE 2,051 2,269 (4,367) 1,056 - 1,009 15,000 6.73%01-000-46-00-4690 REIMB - MISCELLANEOUS 4,686 227 660 161 578 6,313 12,000 52.61%Miscellaneous01-000-48-00-4820 RENTAL INCOME500 - 760 500 630 2,390 7,000 34.14%01-000-48-00-4850 MISCELLANEOUS INCOME3,873 18,135 3,000 3,050 3,002 31,060 88,000 35.30%Other Financing Uses01-000-49-00-4916TRANSFER FROM CW MUNICIPAL BLDG- - - - - - 35,000 0.00%TOTAL REVENUES: GENERAL FUND 1,498,237 3,365,612 1,275,999 1,676,600 2,833,714 10,650,163 18,100,270 58.84%ADMINISTRATION EXPENDITURESSalaries & Wages01-110-50-00-5001 SALARIES - MAYOR 825 825 825 825 825 4,125 10,000 41.25%01-110-50-00-5002 SALARIES - LIQUOR COMM 83 83 83 83 83 417 1,000 41.67%01-110-50-00-5005 SALARIES - ALDERMAN 3,900 4,400 3,800 3,900 4,000 20,000 48,000 41.67%01-110-50-00-5010 SALARIES - ADMINISTRATION 43,952 40,852 49,900 29,487 33,032 197,223 567,473 34.75%01-110-50-00-5015 PART-TIME SALARIES - - - - 1,029 1,029 - 0.00%Benefits01-110-52-00-5212RETIREMENT PLAN CONTRIBUTION4,891 4,555 3,812 3,284 3,670 20,213 59,061 34.22%01-110-52-00-5214 FICA CONTRIBUTION 3,634 3,468 2,925 2,584 2,936 15,546 44,356 35.05%01-110-52-00-5216 GROUP HEALTH INSURANCE 14,193 11,171 4,995 108 2,781 33,248 88,445 37.59%2 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-110-52-00-5222 GROUP LIFE INSURANCE(110) 285 (51) 204 (51) 277 687 40.33%01-110-52-00-5223 GROUP DENTAL INSURANCE- 1,496 499 238 412 2,645 7,454 35.49%01-110-52-00-5224 VISION INSURANCE94 94 - 205 - 393 1,130 34.82%Contractual Services01-110-54-00-5412 TRAINING & CONFERENCES- - 429 930 - 1,359 17,000 7.99%01-110-54-00-5424COMPUTER REPLACEMENT CHRGBCK- - - 2,091 - 2,091 3,336 62.68%01-110-54-00-5415 TRAVEL & LODGING - - - - 48 48 10,000 0.48%01-110-54-00-5426 PUBLISHING & ADVERTISING - - 170 - - 170 5,000 3.40%01-110-54-00-5430 PRINTING & DUPLICATION - 84 80 67 53 285 3,250 8.75%01-110-54-00-5440 TELECOMMUNICATIONS - 3,008 2,476 4,502 300 10,285 22,300 46.12%01-110-54-00-5448 FILING FEES - - - - - - 500 0.00%01-110-54-00-5451 CODIFICATION - 1,242 - - - 1,242 10,000 12.42%01-110-54-00-5452 POSTAGE & SHIPPING 7 15 1 31 19 73 3,000 2.45%01-110-54-00-5460 DUES & SUBSCRIPTIONS 7,634 225 257 100 588 8,803 22,000 40.02%01-110-54-00-5462 PROFESSIONAL SERVICES 202 519 498 1,413 272 2,904 12,000 24.20%01-110-54-00-5480 UTILITIES - 827 6,214 5,808 6,584 19,433 33,708 57.65%01-110-54-00-5485 RENTAL & LEASE PURCHASE 338 226 226 226 226 1,241 3,000 41.38%01-110-54-00-5488 OFFICE CLEANING - 1,046 1,058 1,091 1,091 4,285 13,743 31.18%Supplies01-110-56-00-5610 OFFICE SUPPLIES507 310 1,607 1,091 267 3,782 10,000 37.82%TOTAL EXPENDITURES: ADMINISTRATION80,151 74,732 79,802 58,269 58,164 351,117 996,443 35.24%FINANCE EXPENDITURESSalaries & Wages01-120-50-00-5010 SALARIES & WAGES24,238 28,680 26,881 24,193 23,206 127,198 326,735 38.93%Benefits01-120-52-00-5212RETIREMENT PLAN CONTRIBUTION2,709 3,203 3,003 2,704 2,578 14,198 34,006 41.75%01-120-52-00-5214 FICA CONTRIBUTION 1,824 2,164 2,026 1,820 1,733 9,567 23,676 40.41%01-120-52-00-5216 GROUP HEALTH INSURANCE 3,429 7,104 3,199 2,952 2,511 19,195 48,081 39.92%01-120-52-00-5222 GROUP LIFE INSURANCE - 53 - 93 - 146 361 40.41%01-120-52-00-5223 DENTAL INSURANCE - 1,033 344 344 344 2,066 4,132 50.00%01-120-52-00-5224 VISION INSURANCE 39 65 - 156 - 260 624 41.66%Contractual Services01-120-54-00-5412 TRAINING & CONFERENCES - - - - - - 3,500 0.00%3 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-120-54-00-5414 AUDITING SERVICES- 15,000 - - - 15,000 35,900 41.78%01-120-54-00-5415 TRAVEL & LODGING- - - - - - 600 0.00%01-120-54-00-5424COMPUTER REPLACEMENT CHARGEBACK- - - - - - 1,895 0.00%01-120-54-00-5430 PRINTING & DUPLICATING - 388 106 457 18 969 3,500 27.69%01-120-54-00-5440 TELECOMMUNICATIONS - 170 170 170 170 680 1,980 34.36%01-120-54-00-5452 POSTAGE & SHIPPING 55 75 72 121 107 431 1,200 35.88%01-120-54-00-5460 DUES & SUBSCRIPTIONS 90 - - - - 90 1,500 6.00%01-120-54-00-5462 PROFESSIONAL SERVICES 3,975 3,271 3,062 3,357 3,156 16,821 65,000 25.88%01-120-54-00-5485 RENTAL & LEASE PURCHASE 259 113 113 387 113 985 2,200 44.78%Supplies01-120-56-00-5610 OFFICE SUPPLIES - 89 - 138 - 226 2,500 9.06%TOTAL EXPENDITURES: FINANCE 36,618 61,408 38,977 36,893 33,937 207,833 557,390 37.29%POLICE EXPENDITURESSalaries & Wages01-210-50-00-5008 SALARIES - POLICE OFFICERS 161,377 158,933 155,605 158,184 156,531 790,630 1,975,199 40.03%01-210-50-00-5011 SALARIES - COMMAND STAFF 31,168 34,341 33,560 30,848 29,578 159,495 525,732 30.34%01-210-50-00-5012 SALARIES - SERGEANTS 41,497 47,475 40,740 39,750 45,238 214,699 559,921 38.34%01-210-50-00-5013 SALARIES - POLICE CLERKS 12,953 12,953 15,431 19,237 9,214 69,787 182,926 38.15%01-210-50-00-5014 SALARIES - CROSSING GUARD3,278 707 - - 1,667 5,651 30,000 18.84%01-210-50-00-5015 PART-TIME SALARIES2,089 4,040 5,559 3,949 5,467 21,104 70,000 30.15%01-210-50-00-5020 OVERTIME7,579 8,545 11,965 4,066 10,650 42,805 111,000 38.56%Benefits01-210-52-00-5212RETIREMENT PLAN CONTRIBUTION1,439 1,439 1,714 2,137 1,024 7,753 19,039 40.72%01-210-52-00-5213 EMPLOYER CONTRI - POL PEN 62,631 630,291 19,248 51,979 536,982 1,301,131 1,334,771 97.48%01-210-52-00-5214 FICA CONTRIBUTION 19,323 19,850 19,502 19,054 19,043 96,772 257,542 37.58%01-210-52-00-5216 GROUP HEALTH INSURANCE 85,493 92,725 50,282 51,590 42,545 322,634 572,407 56.36%01-210-52-00-5222 GROUP LIFE INSURANCE (100) 688 (100) 1,321 (100) 1,709 4,269 40.02%01-210-52-00-5223 DENTAL INSURANCE - 9,852 3,467 3,345 3,345 20,010 39,409 50.78%01-210-52-00-5224 VISION INSURANCE 505 505 - 1,484 - 2,495 5,987 41.67%4 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Contractual Services01-210-54-00-5410 TUITION REIMBURSEMENT - - - 2,412 1,206 3,618 13,350 27.10%01-210-54-00-5411 POLICE COMMISSION - - 310 - 155 465 5,780 8.04%01-210-54-00-5412 TRAINING & CONFERENCES - 6,250 (5,335) 1,394 125 2,434 24,500 9.93%01-210-54-00-5415 TRAVEL & LODGING - 292 597 - 168 1,057 10,000 10.57%01-210-54-00-5422VEHICLE & EQUIPMENT CHARGEBACK7,644 7,644 7,644 7,644 7,644 38,222 91,732 41.67%01-210-54-00-5424COMPUTER REPLACEMENT CHARGEBACK- - - - - - 3,336 0.00%01-210-54-00-5430 PRINTING & DUPLICATING - 78 71 55 131 335 5,000 6.71%01-210-54-00-5440 TELECOMMUNICATIONS - 1,851 3,436 5,174 1,979 12,440 43,500 28.60%01-210-54-00-5452 POSTAGE & SHIPPING 25 52 54 - 57 188 1,200 15.69%01-210-54-00-5460 DUES & SUBSCRIPTIONS 5,750 4,000 5,126 126 6 15,008 10,700 140.26%01-210-54-00-5462 PROFESSIONAL SERVICES 600 5,000 485 905 1,469 8,459 39,950 21.17%01-210-54-00-5467 ADJUDICATION SERVICES - 700 271 1,300 625 2,896 20,750 13.96%01-210-54-00-5469 NEW WORLD LIVE SCAN - - - - - - 2,000 0.00%01-210-54-00-5472 KENDALL CO. JUVE PROBATION - - - - - - 4,600 0.00%01-210-54-00-5485 RENTAL & LEASE PURCHASE 524 411 411 299 411 2,057 5,600 36.73%01-210-54-00-5488 OFFICE CLEANING - 1,046 1,058 1,091 1,091 4,285 13,806 31.04%01-210-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - 1,690 5,533 1,731 8,954 60,000 14.92%Supplies01-210-56-00-5600 WEARING APPAREL - - - 352 647 999 15,000 6.66%01-210-56-00-5610 OFFICE SUPPLIES - 65 35 - 348 448 4,500 9.96%01-210-56-00-5620 OPERATING SUPPLIES - 225 20 253 45 542 16,500 3.29%01-210-56-00-5650 COMMUNITY SERVICES - 30 - 436 209 675 3,000 22.49%01-210-56-00-5690 BALLISTIC VESTS - - - - - - 4,550 0.00%01-210-56-00-5695 GASOLINE - 5,094 4,736 4,941 5,514 20,285 62,348 32.53%01-210-56-00-5696 AMMUNITION - - - - - - 9,000 0.00%TOTAL EXPENDITURES: POLICE 443,774 1,055,082 377,582 418,858 884,745 3,180,042 6,158,904 51.63%COMMUNITY DEVELOPMENT EXPENDITURESSalaries & Wages01-220-50-00-5010 SALARIES & WAGES 40,628 47,667 47,718 40,990 41,569 218,572 561,611 38.92%Benefits01-220-52-00-5212RETIREMENT PLAN CONTRIBUTION4,547 5,329 5,335 4,587 4,618 24,417 58,451 41.77%01-220-52-00-5214 FICA CONTRIBUTION 3,014 3,552 3,556 3,042 3,063 16,227 41,374 39.22%5 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-220-52-00-5216 GROUP HEALTH INSURANCE12,767 12,912 6,749 7,512 4,243 44,183 85,991 51.38%01-220-52-00-5222 GROUP LIFE INSURANCE- - - 166 - 166 707 23.51%01-220-52-00-5223 DENTAL INSURANCE- 1,699 566 566 566 3,399 7,034 48.32%01-220-52-00-5224 VISION INSURANCE90 90 - 270 - 450 1,115 40.39%Contractual Services01-220-54-00-5412 TRAINING & CONFERENCES350 41 365 - - 756 7,300 10.36%01-220-54-00-5415 TRAVEL & LODGING- - - - 15 15 6,500 0.23%01-220-54-00-5422VEHICLE EQUIPMENT CHARGEBACK- - - - - - 31,000 0.00%01-220-54-00-5426 PUBLISHING & ADVERTISING - - 715 - - 715 2,500 28.59%01-220-54-00-5430 PRINTING & DUPLICATING - 49 63 45 70 228 1,500 15.17%01-220-54-00-5440 TELECOMMUNICATIONS - 98 267 267 267 900 4,000 22.49%01-220-54-00-5452 POSTAGE & SHIPPING 2 9 8 11 13 43 500 8.61%01-220-54-00-5459 INSPECTIONS - - 18,440 20,080 15,040 53,560 70,000 76.51%01-220-54-00-5460 DUES & SUBSCRIPTIONS - - 256 839 - 1,094 2,750 39.79%01-220-54-00-5462 PROFESSIONAL SERVICES 5,250 628 4,883 1,536 3,752 16,049 89,280 17.98%01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 189 189 189 189 946 3,150 30.02%01-220-54-00-5490VEHICLE MAINTENANCE SERVICES- 396 - 218 - 614 4,500 13.64%Supplies01-220-56-00-5610 OFFICE SUPPLIES - - 66 - 151 217 1,500 14.48%01-220-56-00-5620 OPERATING SUPPLIES - 38 686 201 76 1,000 5,000 20.01%01-220-56-00-5695 GASOLINE - 373 280 350 428 1,431 4,752 30.12%TOTAL EXPENDITURES: COMMUNITY DEVELP 66,838 73,071 90,142 80,870 74,061 384,982 990,515 38.87%PUBLIC WORKS - STREET OPERATIONS EXPENDITURESSalaries & Wages01-410-50-00-5010 SALARIES & WAGES 34,292 36,287 36,921 34,063 34,506 176,069 560,857 31.39%01-410-50-00-5015 PART-TIME SALARIES - 1,278 1,632 960 - 3,870 13,440 28.79%01-410-50-00-5020 OVERTIME 213 - 111 208 392 925 22,500 4.11%Benefits01-410-52-00-5212RETIREMENT PLAN CONTRIBUTION3,834 4,031 4,114 3,808 3,877 19,664 60,715 32.39%01-410-52-00-5214 FICA CONTRIBUTION 2,532 2,668 2,723 2,511 2,559 12,993 43,565 29.82%01-410-52-00-5216 GROUP HEALTH INSURANCE 17,948 18,818 9,005 9,062 8,280 63,113 156,120 40.43%01-410-52-00-5222 GROUP LIFE INSURANCE (145) 372 (145) 511 (145) 449 941 47.74%01-410-52-00-5223 DENTAL INSURANCE - 1,844 705 660 660 3,868 10,663 36.28%6 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-410-52-00-5224 VISION INSURANCE96 96 - 287 - 479 1,576 30.38%Contractual Services01-410-54-00-5412 TRAINING & CONFERENCES- - - - - - 6,000 0.00%01-410-54-00-5415 TRAVEL & LODGING- - - - - - 3,000 0.00%01-410-54-00-5422VEHICLE EQUIPMENT CHARGEBACK8,333 8,333 8,333 8,333 8,333 41,667 100,000 41.67%01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - 410 237 66 3,480 4,193 30,000 13.98%01-410-54-00-5440 TELECOMMUNICATIONS - 310 310 376 310 1,306 7,600 17.19%01-410-54-00-5455 MOSQUITO CONTROL - - - - - - 6,615 0.00%01-410-54-00-5458 TREE & STUMP MAINTENANCE - - 4,750 - - 4,750 15,000 31.67%01-410-54-00-5462 PROFESSIONAL SERVICES 367 372 60 981 368 2,147 9,225 23.28%01-410-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 4,500 36.56%01-410-54-00-5485 RENTAL & LEASE PURCHASE 69 274 213 159 185 900 6,000 14.99%01-410-54-00-5488 OFFICE CLEANING - 103 105 108 108 423 1,329 31.83%01-410-54-00-5490VEHICLE MAINTENANCE SERVICES- - 4,743 4,133 2,634 11,511 65,000 17.71%Supplies01-410-56-00-5600 WEARING APPAREL - 35 128 52 386 602 5,000 12.03%01-410-56-00-5620 OPERATING SUPPLIES - 320 454 1,237 689 2,700 22,000 12.27%01-410-56-00-5628VEHICLE MAINTENANCE SUPPLIES600 43 866 1,441 1,368 4,319 30,000 14.40%01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - 471 21 281 210 983 21,500 4.57%01-410-56-00-5640 REPAIR & MAINTENANCE - 942 809 355 45 2,151 25,000 8.60%01-410-56-00-5665 JULIE SUPPLIES - - - - - - 1,200 0.00%01-410-56-00-5695 GASOLINE - 285 475 3,870 1,076 5,705 25,680 22.22%TOTAL EXP: PUBLIC WORKS - STREET OPS 68,139 77,291 76,570 75,106 69,323 366,430 1,255,026 29.20%PW - HEALTH & SANITATION EXPENDITURES- Contractual Services01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - 3,517 3,550 3,610 10,677 44,588 23.95%01-540-54-00-5442 GARBAGE SERVICES - - 117,910 116,674 115,511 350,094 1,340,671 26.11%01-540-54-00-5443 LEAF PICKUP - 600 - - - 600 9,000 6.67%TOTAL EXPENDITURES: HEALTH & SANITATION - 600 121,427 120,223 119,121 361,371 1,394,259 25.92%7 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021ADMINISTRATIVE SERVICES EXPENDITURESSalaries & Wages01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - 240 - - 2,213 2,453 500 490.50%Benefits01-640-52-00-5230 UNEMPLOYMENT INSURANCE - - 5,851 - - 5,851 16,500 35.46%01-640-52-00-5231 LIABILITY INSURANCE 81,864 26,432 26,432 26,432 41,844 203,004 346,323 58.62%01-640-52-00-5240 RETIREES - GROUP HEALTH INS 13,890 22,095 (2,426) 7,298 (2,471) 38,386 44,302 86.65%01-640-52-00-5241 RETIREES - DENTAL INSURANCE (1,036) 3,347 (40) 506 83 2,861 333 859.03%01-640-52-00-5242 RETIREES - VISION INSURANCE 32 84 (236) 506 (289) 96 62 155.32%Contractual Services01-640-54-00-5418 PURCHASING SERVICES - - 36 - - 36 62,437 0.06%01-640-54-00-5423 IDOR ADMINISTRATION FEE 3,623 5,541 5,213 5,652 5,914 25,944 49,556 52.35%01-640-54-00-5424COMPUTER REPLACEMENT CHRGEBACK- - - - - - 1,895 0.00%01-640-54-00-5427GC HOUSING RENTAL ASSISTANCE1,658 829 829 829 - 4,145 10,114 40.98%01-640-54-00-5428 UTILITY TAX REBATE - - - - - - 8,000 0.00%01-640-54-00-5439 AMUSEMENT TAX REBATE - - 996 1,836 2,415 5,247 12,000 43.72%01-640-54-00-5449 KENCOM - 13,693 1,170 1,170 1,164 17,198 124,409 13.82%01-640-54-00-5450 INFORMATION TECH SRVCS - 3,308 8,662 9,414 28,245 49,629 400,000 12.41%01-640-54-00-5453BUILDINGS & GROUNDS CHARGEBACK- - - - - - 118,190 0.00%01-640-54-00-5456 CORPORATE COUNSEL - 5,653 4,009 3,948 - 13,610 110,000 12.37%01-640-54-00-5461 LITIGATION COUNSEL - 2,214 - 5,356 4,745 12,315 110,000 11.20%01-640-54-00-5462 PROFESSIONAL SERVICES 523 - 2,729 29,865 - 33,117 48,150 68.78%01-640-54-00-5463 SPECIAL COUNSEL - (1,692) - 4,788 90 3,186 25,000 12.74%01-640-54-00-5465 ENGINEERING SERVICES - - 35,093 67,011 28,645 130,749 300,000 43.58%01-640-54-00-5473 KENDALL AREA TRANSIT - - - - - - 25,000 0.00%01-640-54-00-5475 CABLE CONSORTIUM FEE - - - - - - 65,000 0.00%01-640-54-00-5481 HOTEL TAX REBATES - 47 10,119 5,349 7,066 22,581 72,000 31.36%01-640-54-00-5486 ECONOMIC DEVELOPMENT - 9,425 17,400 9,425 9,425 45,675 165,000 27.68%01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - - - - 1,326 0.00%01-640-54-00-5492 SALES TAX REBATES - - - - - - 1,004,700 0.00%01-640-54-00-5493 BUSINESS DISTRICT REBATES 28,970 46,136 41,907 46,626 50,895 214,533 413,511 51.88%01-640-54-00-5494 ADMISSIONS TAX REBATE- - - - - - 145,000 0.00%8 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202101-640-54-00-5499 BAD DEBT- - - - - - 1,000 0.00%Supplies01-640-56-00-5625 REIMBURSEABLE REPAIRS- - - - - - 15,000 0.00%Other Financing Uses01-640-70-00-7799 CONTINGENCY- - - - - - 44,000 0.00%01-640-99-00-9923TRANSFER TO CITY-WIDE CAPITAL33,438 33,438 33,438 33,438 33,438 167,188 401,250 41.67%01-640-99-00-9924TRANSFER TO BUILDING & GROUNDS- - - - - - 304,209 0.00%01-640-99-00-9942 TRANSFER TO DEBT SERVICE 26,781 26,781 26,781 26,781 26,781 133,906 321,375 41.67%01-640-99-00-9952 TRANSFER TO SEWER 43,312 43,312 43,312 43,312 43,312 216,562 519,749 41.67%01-640-99-00-9979TRANSFER TO PARKS & RECREATION119,571 119,571 119,571 119,571 119,571 597,854 1,434,849 41.67%01-640-99-00-9982 TRANSFER TO LIBRARY OPS5,518 1,775 2,139 1,775 1,775 12,983 26,993 48.10%TOTAL EXPENDITURES: ADMIN SERVICES358,143 362,228 382,985 450,888 404,863 1,959,107 6,747,733 29.03%TOTAL FUND REVENUES1,498,237 3,365,612 1,275,999 1,676,600 2,833,714 10,650,163 18,100,270 58.84%TOTAL FUND EXPENDITURES1,053,663 1,704,412 1,167,486 1,241,107 1,644,213 6,810,881 18,100,270 37.63%FUND SURPLUS (DEFICIT)444,573 1,661,200 108,514 435,493 1,189,501 3,839,281 - FOX HILL SSA REVENUES11-000-40-00-4000 PROPERTY TAXES501 7,872 116 435 6,965 15,888 19,000 83.62%TOTAL REVENUES: FOX HILL SSA501 7,872 116 435 6,965 15,888 19,000 83.62%FOX HILL SSA EXPENDITURES11-111-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 1,267 608 487 1,475 3,836 59,200 6.48%TOTAL FUND REVENUES 501 7,872 116 435 6,965 15,888 19,000 83.62%TOTAL FUND EXPENDITURES - 1,267 608 487 1,475 3,836 59,200 6.48%FUND SURPLUS (DEFICIT) 501 6,605 (493) (51) 5,490 12,052 (40,200) SUNFLOWER SSA REVENUES12-000-40-00-4000 PROPERTY TAXES 801 9,201 93 522 9,137 19,754 21,000 94.06%TOTAL REVENUES: SUNFLOWER SSA 801 9,201 93 522 9,137 19,754 21,000 94.06%9 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021SUNFLOWER SSA EXPENDITURES12-112-54-00-5416 POND MAINTENANCE 817 817 817 817 - 3,268 5,000 65.35%12-112-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 1,100 460 2,836 1,100 5,496 12,200 45.05%TOTAL FUND REVENUES 801 9,201 93 522 9,137 19,754 21,000 94.06%TOTAL FUND EXPENDITURES 817 1,917 1,277 3,653 1,100 8,764 17,200 50.95%FUND SURPLUS (DEFICIT) (16) 7,284 (1,184) (3,131) 8,037 10,990 3,800 MOTOR FUEL TAX REVENUES15-000-41-00-4112 MOTOR FUEL TAX 36,740 36,117 37,425 36,754 40,299 187,335 482,526 38.82%15-000-41-00-4113 MFT HIGH GROWTH - - - - - - 11,000 0.00%15-000-41-00-4114 TRANSPORTATION RENEWAL TAX 25,924 26,038 26,425 26,545 28,337 133,268 346,618 38.45%15-000-41-00-4115 REBUILD ILLINOIS 208,937 - - - - 208,937 417,875 50.00%15-000-45-00-4500 INVESTMENT EARNINGS 40 40 43 46 35 203 2,000 10.15%TOTAL REVENUES: MOTOR FUEL TAX 271,641 62,194 63,894 63,345 68,670 529,744 1,260,019 42.04%MOTOR FUEL TAX EXPENDITURESCapital Outlay15-155-56-00-5618 SALT - - - - - - 138,000 0.00%15-155-60-00-6005 FOX HILL IMPROVEMENTS - - - - - - 1,253,625 0.00%15-155-60-00-6025ROADS TO BETTER ROADS PROGRAM- - - 460,947 - 460,947 920,000 50.10%15-155-60-00-6028 PAVEMENT STRIPING PROGRAM - - - - - - 50,000 0.00%15-155-60-00-6079 ROUTE 47 EXPANSION 6,149 6,149 6,149 6,149 6,149 30,744 73,788 41.67%TOTAL FUND REVENUES 271,641 62,194 63,894 63,345 68,670 529,744 1,260,019 42.04%TOTAL FUND EXPENDITURES 6,149 6,149 6,149 467,096 6,149 491,692 2,435,413 20.19%FUND SURPLUS (DEFICIT) 265,492 56,045 57,745 (403,752) 62,521 38,052 (1,175,394) CITY-WIDE CAPITAL REVENUESLicenses & Permits23-000-42-00-4214 DEVELOPMENT FEES - 500 85 - (85) 500 5,000 10.00%23-000-42-00-4222 ROAD CONTRIBUTION FEE 26,000 (18,000) 48,000 56,000 30,000 142,000 100,000 142.00%Charges for Service23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 279 136,621 390 137,532 434 275,255 785,000 35.06%Investment Earnings10 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202123-000-45-00-4500 INVESTMENT EARNINGS6 6 6 6 6 30 500 6.03%23-000-45-00-4550 GAIN ON INVESTMENT- - - - 4,599 4,599 - 100.00%Reimbursements23-000-46-00-4614 REIMB - BLACKBERRY WOODS- - - - - - 4,322 0.00%23-000-46-00-4612 MILL ROAD IMPROVEMENTS- - 3,597 4,111 - 7,707 2,320,000 0.33%23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE- 165 - - - 165 - 0.00%23-000-46-00-4636 REIMB - RAINTREE VILLAGE- - - - - - 165,000 0.00%23-000-46-00-4690 REIMB - PUSH FOR THE PATH- - - - - - 26,523 0.00%23-000-46-00-4690 REIMB - MISCELLANEOUS- 1,408 - 124 - 1,532 5,477 27.96%Other Financing Sources23-000-49-00-4901 TRANSFER FROM GENERAL33,438 33,438 33,438 33,438 33,438 167,188 401,250 41.67%23-000-49-00-4924TRANSFER FROM BUILDING & GROUNDS- 2,139,950 - - 11,268 2,151,218 1,995,000 107.83%TOTAL REVENUES: CITY-WIDE CAPITAL 59,722 2,294,087 85,515 231,210 79,659 2,750,194 5,808,072 47.35%CITY-WIDE CAPITAL EXPENDITURESContractual Services23-230-54-00-5462 PROFESSIONAL SERVICES - - - - - - 13,500 0.00%23-230-54-00-5465 ENGINEERING SERVICES - - 3,133 2,828 3,399 9,360 109,000 8.59%23-230-54-00-5482 STREET LIGHTING - 5 7,801 7,860 8,351 24,018 110,214 21.79%23-230-54-00-5498 PAYING AGENT FEES - - - 475 - 475 475 100.00%23-230-54-00-5499 BAD DEBT - - - - - - 1,000 0.00%23-230-56-00-5619 SIGNS - - 625 717 - 1,342 15,000 8.95%23-230-60-00-6032 ASPHALT PATCHING - 1,956 430 - - 2,386 35,000 6.82%23-230-56-00-5637SIDEWALK CONSTRUCTION SUPPLIES- - - 2,244 414 2,658 7,500 35.44%23-230-56-00-5642STREET LIGHTING & OTHER SUPPLIES- 733 1,880 330 403 3,345 45,000 7.43%Capital Outlay23-230-60-00-6005 FOX HILL IMPROVEMENTS - - - - - - 85,000 0.00%23-230-60-00-6012 MILL ROAD IMPROVEMENTS - - 18 10,097 464,625 474,741 2,260,000 21.01%23-230-60-00-6014BLACKBERRY WOODS SUBDIVISION- - - - - - 6,101 0.00%23-230-60-00-6016US 34 (CENTER/ELDAMAIN RD) PROJECT- - - - - - 110,000 0.00%23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION - - - - - - - 0.00%23-230-60-00-6025ROAD TO BETTER ROADS PROGRAM- - 19,565 - 29,340 48,904 1,148,725 4.26%23-230-60-00-6032 BRISTOL RIDGE ROAD - - 774 2,485 3,903 7,162 70,000 10.23%23-230-60-00-6036RAINTREE VILLAGE IMPROVEMENTS- 6,355 - - - 6,355 165,000 3.85%11 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202123-230-60-00-6041SIDEWALK REPLACEMENT PROGRAM- 640 3,481 2,758 1,223 8,102 300,000 2.70%23-230-60-00-6058RT71 (RT47/ORCHARD RD) PROJECT- - - - - - 82,050 0.00%23-230-60-00-6059US RT34 (IL47/ORCHARD RD) PROJECT- - - - - - 85,000 0.00%23-230-60-00-6088 KENNEDY ROAD NORTH - - 3,597 4,111 6,097 13,804 60,000 23.01%23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL - - - - - - 32,000 0.00%2014A Bond23-230-78-00-8000 PRINCIPAL PAYMENT - - - - - - 200,000 0.00%23-230-78-00-8050 INTEREST PAYMENT 57,669 - - - - 57,669 115,338 50.00%23-230-99-00-9924TRANSFER TO BUILDING & GROUNDS- - - - - - 384,824 0.00%23-230-99-00-9951 TRANSFER TO WATER 8,713 8,713 8,713 8,713 8,713 43,566 104,558 41.67%TOTAL FUND REVENUES 59,722 2,294,087 85,515 231,210 79,659 2,750,194 5,808,072 47.35%TOTAL FUND EXPENDITURES 66,382 18,402 50,017 42,618 526,467 703,887 5,545,285 12.69%FUND SURPLUS (DEFICIT) (6,660) 2,275,685 35,498 188,592 (446,808) 2,046,307 262,787 BUILDING & GROUNDS REVENUESLicenses & Permits24-000-42-00-4218DEVELOPMENT FEES - MUNICIPAL BLDG8,236 600 2,209 2,509 2,809 16,363 35,000 46.75%24-000-44-00-4416BUILDING & GROUNDS CHARGEBACK- - - - - - 147,738 0.00%Investment Earnings24-000-45-00-4500 INVESTMENT EARNINGS 51 84 67 67 65 333 3,000 11.10%Other Financing Sources24-000-48-00-4845 DONATIONS - - - - - - 2,000 0.00%24-000-49-00-4900 BOND PROCEEDS 8,250,000 - - - - 8,250,000 8,707,478 0.00%24-000-49-00-4901 TRANSFER FROM GENERAL - - - - - - 304,209 0.00%24-000-49-00-4903 PREMIUM ON BOND ISSUANCE 525,011 - - - - 525,011 - 0.00%24-000-49-00-4923TRANSFER FROM CITY-WIDE CAPITAL- - - - - - 384,824 0.00%TOTAL REVENUES: BUILDINGS & GROUNDS 8,783,298 684 2,276 2,576 2,874 8,791,708 9,584,249 91.73%BUILDING & GROUNDS EXPENDITURESSalaries & Wages24-216-50-00-5010 SALARIES & WAGES - - - - - - 50,117 0.00%Benefits24-216-52-00-5212RETIREMENT PLAN CONTRIBUTION- - - - - - 5,216 0.00%24-216-52-00-5214 FICA CONTRIBUTION - - - - - - 3,547 0.00%24-216-52-00-5216 GROUP HEALTH INSURANCE - - - - - - 21,690 0.00%12 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202124-216-52-00-5222 GROUP LIFE INSURANCE- - - - - - 109 0.00%24-216-52-00-5223 DENTAL INSURANCE- - - - - - 1,352 0.00%24-216-52-00-5224 VISION INSURANCE- - - - - - 197 0.00%Contractual Services24-216-54-00-5402 BOND ISSUANCE COSTS96,175 - - 74 - 96,249 82,478 116.70%24-216-54-00-5432FACILITY MANAGEMENT SERVICES- - - - - - 65,510 0.00%24-216-54-00-5446PROPERTY & BUILDING MAINTENANCE SERVICES1,737 2,775 8,966 4,909 6,980 25,368 160,000 15.85%24-216-56-00-5626 HANGING BASKETS - - - - 412 412 2,000 20.60%24-216-56-00-5656PROPERTY & BUILDING MAINTENANCE SUPPLIES- 3,772 544 488 121 4,925 25,000 19.70%Capital Outlay24-216-60-00-6030 CITY HALL IMPROVEMENTS - - 2,500 - 69,084 71,584 6,980,000 1.03%2021 Bond24-216-82-00-8000 PRINCIPAL PAYMENT - - - - - - - 0.00%24-216-82-00-8050 INTEREST PAYMENT - - - - - - 157,033 0.00%24-216-99-00-9901 TRANSFER TO GENERAL - - - - - - 35,000 0.00%24-216-99-00-9923TRANSFER TO CITY-WIDE CAPITAL- 2,139,950 - - 11,268 2,151,218 1,995,000 107.83%TOTAL FUND REVENUES 8,783,298 684 2,276 2,576 2,874 8,791,708 9,584,249 91.73%TOTAL FUND EXPENDITURES 97,912 2,146,497 12,010 5,470 87,865 2,349,755 9,584,249 24.52%FUND SURPLUS (DEFICIT) 8,685,386 (2,145,813) (9,734) (2,894) (84,991) 6,441,953 - VEHICLE & EQUIPMENT REVENUELicenses & Permits25-000-42-00-4215DEVELOPMENT FEES - POLICE CAPITAL7,200 3,600 4,650 2,250 2,400 20,100 30,000 67.00%25-000-42-00-4217 WEATHER WARNING SIREN FEES 326 109 109 217 380 1,139 - 0.00%25-000-42-00-4218 ENGINEERING CAPITAL FEE 2,300 2,100 2,700 3,500 2,300 12,900 10,000 129.00%25-000-42-00-4219DEVELOPMENT FEES - PW CAPITAL17,000 8,600 10,950 5,350 5,600 47,500 64,500 73.64%25-000-42-00-4220DEVELOPMENT FEES - PARK CAPITAL1,150 1,050 1,350 1,750 1,150 6,450 5,000 129.00%Fines & Forfeits25-000-43-00-4315 DUI FINES 350 217 1,100 700 350 2,717 7,000 38.81%25-000-43-00-4316 ELECTRONIC CITATION FEES 74 32 68 70 76 320 800 40.00%Other Financing Uses13 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Charges for Service25-000-44-00-4418 MOWING INCOME - - - 376 - 376 2,000 18.78%25-000-44-00-4419 COMMUNITY DVLP CHARGEBACK - - - - - - 31,000 0.00%25-000-44-00-4420 POLICE CHARGEBACK 7,644 7,644 7,644 7,644 7,644 38,222 91,732 41.67%25-000-44-00-4421 PUBLIC WORKS CHARGEBACK 8,333 8,333 8,333 8,333 8,333 41,667 100,000 41.67%25-000-44-00-4422PARKS & RECREATION CHARGEBACK- - - - - - 88,866 0.00%25-000-44-00-4425COMPUTER REPLACEMENT CHARGEBACKS- - - - - - 12,232 0.00%Investment Earnings25-000-45-00-4522 INVESTMENT EARNINGS - PARKS - - - - - 1,000 0.00%25-000-45-00-4550 GAIN ON INVESTMENT - - - - 105 105 - 0.00%Miscellaneous25-000-46-00-4692 MISC REIMB - PARK CAPITAL - - - - - - 102,096 0.00%25-000-48-00-4852 MISC INCOME - PD CAPITAL - 666 - - - 666 - 0.00%25-000-48-00-4854 MISC INCOME - PW CAPITAL - 93 - - - 93 1,000 9.35%25-000-48-00-4855 MISC INCOME - PARKS CAPITAL - 588 - - - 588 - 0.00%25-000-49-00-4920 SALE OF CAPITAL ASSETS - PD - - 695 - - 695 - 0.00%25-000-49-00-4922 SALE OF CAPITAL ASSETS - PARKS - 4,000 - - - 4,000 - 0.00%TOTAL REVENUES: VEHICLE & EQUIPMENT 44,377 37,032 37,599 30,190 28,338 177,537 547,226 32.44%VEHICLE & EQUIPMENT EXPENDITURESPOLICE CAPITAL EXPENDITURESContractual Services25-205-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - - 466 - 466 8,750 5.33%Capital Outlay25-205-60-00-6060 EQUIPMENT - - - - - - 50,000 0.00%25-205-60-00-6070 VEHICLES - 97,210 423 17,630 1,900 117,163 260,000 45.06%TOTAL EXPENDITURES: POLICE CAPITAL - 97,210 423 18,096 1,900 117,629 318,750 36.90%GENERAL GOVERNMENT CAPITAL EXPENDITURESContractual Services25-212-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - 8,336 8,336 12,232 68.15%Capital Outlay25-212-60-00-6070 VEHICLES - - 31,070 - - 31,070 31,000 100.23%TOTAL EXPENDITURES: GENERAL GOVERNMENT - - 31,070 - 8,336 39,406 43,232 91.15%PUBLIC WORKS CAPITAL EXPENDITURES14 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Contractual Services25-215-54-00-5448 FILING FEES - - - - - - 750 0.00%Supplies25-215-56-00-5620 OPERATING SUPPLIES - - - - - - 1,000 0.00%Capital Outlay25-215-60-00-6060 EQUIPMENT - - - - - - 15,000 0.00%25-215-60-00-6070 VEHICLES 10,786 - - 45,477 - 56,262 911,000 6.18%185 Wolf Street Building25-215-92-00-8000 PRINCIPAL PAYMENT 4,406 4,374 4,432 4,401 4,415 22,027 53,527 41.15%25-215-92-00-8050 INTEREST PAYMENT 1,377 1,409 1,351 1,382 1,368 6,888 15,869 43.40%TOTAL EXPENDITURES: PW CAPITAL 16,569 5,783 5,783 51,260 5,783 85,177 997,146 8.54%PARK & RECREATION CAPITAL EXPENDITURESContractual Services25-225-54-00-5495 OUTSDE REPAIR & MAINTENANCE - - - - - - 1,600 0.00%Capital Outlay25-225-60-00-6010 PARK IMPROVEMENTS - - - 5,799 513 6,313 152,096 4.15%25-225-60-00-6060 EQUIPMENT 10,079 11,999 7,930 - - 30,008 50,000 60.02%25-225-60-00-6070 VEHICLES - - - - - - 313,000 0.00%185 Wolf Street Building25-225-92-00-8000 PRINCIPAL PAYMENT 138 137 139 138 138 690 1,677 41.15%25-225-92-00-8050 INTEREST PAYMENT 43 44 42 43 43 216 497 43.42%TOTAL EXPENDITURES: PARK & REC CAPITAL10,260 12,180 8,111 5,980 695 37,227 518,870 7.17%TOTAL FUND REVENUES 44,377 37,032 37,599 30,190 28,338 177,537 547,226 32.44%TOTAL FUND EXPENDITURES 26,829 115,173 45,388 75,336 16,714 279,440 1,877,998 14.88%FUND SURPLUS (DEFICIT) 17,548 (78,141) (7,789) (45,146) 11,625 (101,902) (1,330,772) DEBT SERVICE REVENUES42-000-42-00-4208RECAPTURE FEES-WATER & SEWER1,075 1,000 900 1,625 775 5,375 8,000 67.19%42-000-49-00-4901 TRANSFER FROM GENERAL 26,781 26,781 26,781 26,781 26,781 133,906 321,375 41.67%TOTAL REVENUES: DEBT SERVICE 27,856 27,781 27,681 28,406 27,556 139,281 329,375 42.29%15 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021DEBT SERVICE EXPENDITURES42-420-54-00-5498 PAYING AGENT FEES - - - 475 - 475 475 100.00%2014B Refunding Bond42-420-79-00-8000 PRINCIPAL PAYMENT - - - - - - 310,000 0.00%42-420-79-00-8050 INTEREST PAYMENT - 9,450 - - - 9,450 18,900 50.00%TOTAL FUND REVENUES 27,856 27,781 27,681 28,406 27,556 139,281 329,375 42.29%TOTAL FUND EXPENDITURES - 9,450 - 475 - 9,925 329,375 3.01%FUND SURPLUS (DEFICIT) 27,856 18,331 27,681 27,931 27,556 129,356 - WATER FUND REVENUESCharges for Service51-000-41-00-4165 FEDERAL GRANTS - APR FUNDS - - - - - - 131,250 0.00%51-000-44-00-4424 WATER SALES 1,019 488,600 8,579 724,843 6,049 1,229,090 3,412,500 36.02%51-000-44-00-4425 BULK WATER SALES - - - - - - 5,000 0.00%51-000-44-00-4426 LATE PENALTIES - WATER 89 24,527 75 22,058 38 46,786 116,394 40.20%51-000-44-00-4430 WATER METER SALES 25,990 24,500 19,535 38,935 15,860 124,820 60,000 208.03%51-000-44-00-4440 WATER INFRASTRUCTURE FEE 259 140,106 416 140,979 464 282,224 820,000 34.42%51-000-44-00-4450 WATER CONNECTION FEES 44,400 23,800 38,800 48,308 50,600 205,908 230,000 89.53%Investment Earnings51-000-45-00-4500 INVESTMENT EARNINGS38 87 113 145 127 510 3,000 16.99%51-000-45-00-4550 GAIN ON INVESTMENT- - - - 611 611 - 0.00%Miscellaneous51-000-48-00-4820 RENTAL INCOME 8,513 11,178 5,538 8,513 11,489 45,232 102,644 44.07%51-000-48-00-4850 MISCELLANEOUS INCOME56 404 - - - 459 250 183.77%Other Financing Sources51-000-49-00-4923TRANSFER FROM CITY-WIDE CAPITAL8,713 8,713 8,713 8,713 8,713 43,566 104,558 41.67%51-000-49-00-4952 TRANSFER FROM SEWER 6,306 6,306 6,306 6,306 6,306 31,531 75,675 41.67%TOTAL REVENUES: WATER FUND 95,384 728,221 88,075 998,801 100,257 2,010,737 5,061,271 39.73%WATER OPERATIONS EXPENSESSalaries & Wages51-510-50-00-5010 SALARIES & WAGES 33,942 36,214 35,190 38,461 36,863 180,671 485,856 37.19%51-510-50-00-5015 PART-TIME SALARIES - 1,448 2,040 - - 3,488 30,000 11.63%51-510-50-00-5020 OVERTIME 309 502 116 606 547 2,081 22,000 9.46%16 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Benefits51-510-52-00-5212RETIREMENT PLAN CONTRIBUTION3,805 4,079 3,923 4,340 4,156 20,304 52,857 38.41%51-510-52-00-5214 FICA CONTRIBUTION 2,499 2,798 2,733 2,865 2,732 13,628 39,634 34.38%51-510-52-00-5216 GROUP HEALTH INSURANCE 17,462 19,964 10,425 9,671 10,031 67,553 107,242 62.99%51-510-52-00-5222 GROUP LIFE INSURANCE (20) 133 (20) 238 (20) 312 897 34.80%51-510-52-00-5223 DENTAL INSURANCE - 2,167 903 789 887 4,746 8,634 54.97%51-510-52-00-5224 VISION INSURANCE 99 113 - 318 - 530 1,306 40.57%51-510-52-00-5230 UNEMPLOYMENT INSURANCE - - 576 - - 576 2,000 28.80%51-510-52-00-5231 LIABILITY INSURANCE 7,068 2,083 2,083 2,083 2,083 15,399 31,023 49.64%Contractual Services51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 10,550 10,550 10,550 10,550 10,550 52,748 126,596 41.67%51-510-54-00-5412 TRAINING & CONFERENCES - - 240 - 745 985 9,200 10.71%51-510-54-00-5415 TRAVEL & LODGING - - - - - - 4,000 0.00%51-510-54-00-5426 PUBLISHING & ADVERTISING - - - - - - 500 0.00%51-510-54-00-5429 WATER SAMPLES - 434 510 605 456 2,005 8,000 25.06%51-510-54-00-5430 PRINTING & DUPLICATING- 487 107 518 2 1,113 3,250 34.26%51-510-54-00-5440 TELECOMMUNICATIONS- 3,302 3,734 6,867 735 14,637 40,000 36.59%51-510-54-00-5445 TREATMENT FACILITY SERVICES13,972 16,321 30,500 20,789 40,130 121,712 225,000 54.09%51-510-54-00-5448 FILING FEES134 469 134 - - 737 3,000 24.57%51-510-54-00-5452 POSTAGE & SHIPPING3,050 516 2,735 47 80 6,427 20,000 32.14%51-510-54-00-5453BUILDING & GROUNDS CHARGEBACK- - - - - - 14,774 0.00%51-510-54-00-5460 DUES & SUBSCRIPTIONS 371 2,458 - - - 2,829 2,500 113.16%51-510-54-00-5462 PROFESSIONAL SERVICES 6,230 4,813 6,640 5,732 4,789 28,204 166,000 16.99%51-510-54-00-5465 ENGINEERING SERVICES - - 4,415 7,350 8,534 20,299 75,000 27.06%51-510-54-00-5480 UTILITIES - - 27,032 27,009 27,176 81,218 312,700 25.97%51-510-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 4,500 36.56%51-510-54-00-5485 RENTAL & LEASE PURCHASE 145 95 208 95 152 694 2,000 34.72%51-510-54-00-5488 OFFICE CLEANING - 103 105 108 108 423 1,329 31.83%51-510-54-00-5490VEHICLE MAINTENANCE SERVICES- - - - - - 12,000 0.00%51-510-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - - 12,709 - 12,709 32,000 39.72%51-510-54-00-5498 PAYING AGENT FEES - - 349 475 - 824 1,300 63.41%51-510-54-00-5499 BAD DEBT - - - - - - 10,000 0.00%Supplies17 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202151-510-56-00-5600 WEARING APPAREL- 33 247 - - 280 5,000 5.59%51-510-56-00-5620 OPERATING SUPPLIES- 324 457 696 117 1,595 11,000 14.50%51-510-56-00-5628VEHICLE MAINTENANCE SUPPLIES- 2,797 532 1,945 - 5,273 2,500 210.94%51-510-56-00-5630 SMALL TOOLS & EQUIPMENT - - 96 - 43 139 8,400 1.65%51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 5,282 8,659 14,358 19,108 15,637 63,044 191,425 32.93%51-510-56-00-5640 REPAIR & MAINTENANCE - 1,098 617 4,345 1,622 7,682 27,500 27.94%51-510-56-00-5664 METERS & PARTS - 1,205 5,036 32,576 28,252 67,070 100,000 67.07%51-510-56-00-5665 JULIE SUPPLIES - - - - 8 8 3,000 0.26%51-510-56-00-5695 GASOLINE - 285 646 3,365 1,395 5,691 21,400 26.59%Capital Outlay51-510-60-00-6015 WATER TOWER PAINTING - - - - - - 20,000 0.00%51-510-60-00-6022 WELL REHABILITATIONS - - - - - - 192,000 0.00%51-510-60-00-6025ROAD TO BETTER ROADS PROGRAM- - 161,675 148,787 42,704 353,166 950,000 37.18%51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - - - - - 21,000 0.00%51-510-60-00-6060 EQUIPMENT - - - 158 611 769 463,000 0.17%51-510-60-00-6066RTE 71 WATERMAIN REPLACEMENT- - - - - - 33,208 0.00%51-510-60-00-6070 VEHICLES - - - - - - 100,000 0.00%51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 3,781 3,781 3,781 18,905 45,372 41.67%51-510-60-00-6081CATION EXCHANGE MEDIA REPLACEMENT- - - - - - 216,000 0.00%2015A Bond51-510-77-00-8000 PRINCIPAL PAYMENT - - - - - - 312,545 0.00%51-510-77-00-8050 INTEREST PAYMENT 64,127 - - - - 64,127 128,254 50.00%2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - - - - - 1,040,000 0.00%51-510-85-00-8050 INTEREST PAYMENT - 29,325 - - - 29,325 58,650 50.00%IEPA Loan L17-15630051-510-89-00-8000 PRINCIPAL PAYMENT - - - 54,530 - 54,530 109,743 49.69%51-510-89-00-8050 INTEREST PAYMENT - - - 7,985 - 7,985 15,288 52.23%18 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 20212014C Refunding Bond51-510-94-00-8000 PRINCIPAL PAYMENT - - - - - - 135,000 0.00%51-510-94-00-8050 INTEREST PAYMENT - 8,175 - - - 8,175 16,350 50.00%TOTAL FUND REVENUES 95,384 728,221 88,075 998,801 100,257 2,010,737 5,061,271 39.73%TOTAL FUND EXPENSES 172,807 164,730 332,673 431,147 244,904 1,346,262 6,081,733 22.14%FUND SURPLUS (DEFICIT) (77,423) 563,490 (244,598) 567,654 (144,648) 664,475 (1,020,462) SEWER FUND REVENUESCharges for Service52-000-41-00-4165 FEDERAL GRANTS - ARP FUNDS - - - - - - 84,500 0.00%52-000-44-00-4435 SEWER MAINTENANCE FEES 187 175,357 350 176,807 353 353,054 1,055,596 33.45%52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 127 68,526 198 68,961 220 138,031 395,000 34.94%52-000-44-00-4455 SW CONNECTION FEES - OPS 8,900 10,300 12,800 15,600 9,300 56,900 23,300 244.21%52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 21,600 7,200 7,200 14,400 16,200 66,600 180,000 37.00%52-000-44-00-4462 LATE PENALTIES - SEWER 12 3,495 11 3,261 5 6,784 15,957 42.51%Investment Earnings52-000-45-00-4500 INVESTMENT EARNINGS 7 13 17 27 32 96 1,500 6.43%52-000-45-00-4550 GAIN ON INVESTMENT - - - - 2,874 2,874 - 0.00%Other Financing Sources52-000-46-00-4690 REIMB - MISCELLANEOUS~- - - - - - - 0.00%52-000-48-00-4850 MISCELLANEOUS INCOME~- 229 - - - 229 - 0.00%52-000-49-00-4901 TRANSFER FROM GENERAL 43,312 43,312 43,312 43,312 43,312 216,562 519,749 41.67%TOTAL REVENUES: SEWER FUND 74,145 308,433 63,887 322,369 72,296 841,130 2,275,602 36.96%SEWER OPERATIONS EXPENSESSalaries & Wages52-520-50-00-5010 SALARIES & WAGES 18,560 19,518 20,334 18,874 19,378 96,664 271,613 35.59%52-520-50-00-5015 PART-TIME SALARIES - - - - - - 6,720 0.00%52-520-50-00-5020 OVERTIME - - 149 73 100 321 500 64.20%Benefits52-520-52-00-5212RETIREMENT PLAN CONTRIBUTION2,062 2,168 2,276 2,105 2,164 10,775 28,321 38.05%52-520-52-00-5214 FICA CONTRIBUTION 1,352 1,426 1,497 1,380 1,421 7,076 20,151 35.11%52-520-52-00-5216 GROUP HEALTH INSURANCE 10,325 8,889 4,342 3,830 3,278 30,664 80,510 38.09%52-520-52-00-5222 GROUP LIFE INSURANCE (67) 135 (67) 253 (67) 186 529 35.24%19 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202152-520-52-00-5223 DENTAL INSURANCE- 898 299 322 322 1,841 5,527 33.31%52-520-52-00-5224 VISION INSURANCE66 66 - 199 - 331 830 39.93%52-520-52-00-5230 UNEMPLOYMENT INSURANCE- - 303 - - 303 850 35.65%52-520-52-00-5231 LIABILITY INSURANCE3,345 941 941 941 941 7,109 15,036 47.28%Contractual Services52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK3,797 3,797 3,797 3,797 3,797 18,985 45,563 41.67%52-520-54-00-5412 TRAINING & CONFERENCES- - - 30 - 30 3,500 0.86%52-520-54-00-5415 TRAVEL & LODGING- - - - - - 3,000 0.00%52-520-54-00-5430 PRINTING & DUPLICATING- 230 50 240 2 522 1,500 34.78%52-520-54-00-5440 TELECOMMUNICATIONS- 606 642 1,410 806 3,464 13,500 25.66%52-520-54-00-5444 LIFT STATION SERVICES92 6,417 9,580 4,907 381 21,377 36,000 59.38%52-520-54-00-5462BUILDINGS & GROUNDS CHARGEBACK- - - - - - 14,774 0.00%52-520-54-00-5462 PROFESSIONAL SERVICES 2,771 2,331 1,767 2,631 2,242 11,742 35,500 33.08%52-520-54-00-5480 UTILITIES - - 1,004 1,070 1,016 3,090 25,249 12.24%52-520-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 4,500 36.56%52-520-54-00-5485 RENTAL & LEASE PURCHASE 69 57 170 57 57 411 1,500 27.39%52-520-54-00-5488 OFFICE CLEANING - 103 105 108 108 423 1,329 31.83%52-520-54-00-5490VEHICLE MAINTENANCE SERVICES- 1,929 - - 1,929 10,000 19.29%52-520-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - - - - 16,000 0.00%52-520-54-00-5498 PAYING AGENT FEES - - - - - 750 0.00%52-520-54-00-5499 BAD DEBT - - - - - 2,000 0.00%Supplies52-520-56-00-5600 WEARING APPAREL - 401 363 138 20 921 3,980 23.15%52-520-56-00-5610 OFFICE SUPPLIES - - 26 146 72 244 1,250 19.49%52-520-56-00-5613 LIFT STATION MAINTENANCE - - 39 - - 39 8,000 0.48%52-520-56-00-5620 OPERATING SUPPLIES - 170 242 278 915 1,605 9,500 16.89%52-520-56-00-5628VEHICLE MAINTENANCE SUPPLIES- 627 209 155 2,083 3,073 10,000 30.73%52-520-56-00-5630 SMALL TOOLS & EQUIPMENT - - 269 - 389 658 5,600 11.75%52-520-56-00-5640 REPAIR & MAINTENANCE - - - - 193 193 5,000 3.86%52-520-56-00-5665 JULIE SUPPLIES - - - - - - 2,233 0.00%52-520-56-00-5695 GASOLINE - 285 - 3,365 1,076 4,725 20,000 23.63%20 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Capital Outlay52-520-60-00-6001 SCADA SYSTEM - - - - 43,783 43,783 67,000 65.35%52-520-60-00-6059US 34 (IL RT47/ORCHARD) PROJECT- - - - - - 1,100 0.00%52-520-60-00-6060 EQUIPMENT - - - - - - 82,000 0.00%52-520-60-00-6070 VEHICLES - - - - - - 100,000 0.00%52-520-60-00-6066RTE 71 SEWER MAIN REPLACEMENT- - - - - - 68,721 0.00%52-520-60-00-6079 ROUTE 47 EXPANSION 1,873 1,873 1,873 1,873 1,873 9,367 22,488 41.66%2003 IRBB Debt Certificates52-520-90-00-8000 PRINCIPAL PAYMENT - - - - - - 150,000 0.00%52-520-90-00-8050 INTEREST PAYMENT - - 7,855 - - 7,855 15,710 50.00%2011 Refunding Bond52-520-92-00-8000 PRINCIPAL PAYMENT - - - - - - 920,000 0.00%52-520-92-00-8050 INTEREST PAYMENT - 107,535 - - - 107,535 215,070 50.00%Other Financing Uses52-520-99-00-9951 TRANSFER TO WATER 6,306 6,306 6,306 6,306 6,306 31,531 75,675 41.67%TOTAL FUND REVENUES 74,145 308,433 63,887 322,369 72,296 841,130 2,275,602 36.96%TOTAL FUND EXPENSES 50,553 164,781 66,299 56,130 92,654 430,417 2,428,579 17.72%FUND SURPLUS (DEFICIT) 23,592 143,652 (2,412) 266,239 (20,358) 410,713 (152,977) LAND CASH REVENUES72-000-47-00-4701 WHITE OAK - - - - - - 1,406 0.00%72-000-47-00-4702 WHISPERING MEADOWS - - - - - - 4,699 0.00%72-000-47-00-4704 BLACKBERRY WOODS - - - 1,136 - 1,136 1,932 58.82%72-000-47-00-4706 CALEDONIA- - - - - - 4,698 0.00%72-000-47-00-4708 COUNTRY HILLS- - - - - - 4,358 0.00%72-000-47-00-4711 FOX HIGHLANDS- - - - - - - 0.00%72-000-47-00-4724 KENDALL MARKETPLACE- - - - - - - 0.00%72-000-47-00-4725 HEARTLAND MEADOWS- - - - - - 3,522 0.00%72-000-47-00-4727 CIMARRON RIDGE- - - - - - - 0.00%72-000-47-00-4736 BRIARWOOD- - - - - - 5,145 0.00%72-000-48-00-4850 MISCELLANEOUS INCOME- 193 - - - 193 - 0.00%TOTAL REVENUES: LAND CASH - 193 - 1,136 - 1,329 25,760 5.16%21 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021LAND CASH EXPENDITURES72-720-60-00-6067BLACKBERRY CREEK NATURE PRESERVE- - - - - - 5,000 0.00%TOTAL FUND REVENUES - 193 - 1,136 - 1,329 25,760 5.16%TOTAL FUND EXPENDITURES - - - - - - 5,000 0.00%FUND SURPLUS (DEFICIT) - 193 - 1,136 - 1,329 20,760 PARK & RECREATION REVENUESCharges for Service79-000-41-00-4165 FEDERAL GRANT - ARP FUNDS - - - - - - 334,250 0.00%79-000-44-00-4402 SPECIAL EVENTS 11,700 17,656 27,788 - 45 57,189 90,000 63.54%79-000-44-00-4403 CHILD DEVELOPMENT 5,330 12,348 1,638 12,251 12,455 44,022 145,000 30.36%79-000-44-00-4404 ATHLETICS AND FITNESS 14,764 55,314 42,939 8,777 3,344 125,137 370,000 33.82%79-000-44-00-4441 CONCESSION REVENUE 4,235 7,560 3,878 1,631 3,513 20,817 45,000 46.26%Investment Earnings79-000-45-00-4500 INVESTMENT EARNINGS 7 4 9 12 8 41 250 16.24%Reimbursements79-000-46-00-4690 REIMB - MISCELLANEOUS - - - - - - - 0.00%Miscellaneous79-000-48-00-4820 RENTAL INCOME - 54,849 1,700 1,700 700 58,949 66,209 89.03%79-000-48-00-4825 PARK RENTALS 785 932 4,638 1,392 535 8,282 17,500 47.33%79-000-48-00-4843 HOMETOWN DAYS1,675 3,075 2,700 8,080 124,044 139,574 120,000 116.31%79-000-48-00-4846 SPONSORSHIPS & DONATIONS- 5,450 350 1,150 250 7,200 15,000 48.00%79-000-48-00-4850 MISCELLANEOUS INCOME109 2,017 - 2,088 18 4,233 5,000 84.65%Other Financing Sources79-000-49-00-4901 TRANSFER FROM GENERAL119,571 119,571 119,571 119,571 119,571 597,854 1,434,849 41.67%TOTAL REVENUES: PARK & RECREATION158,176 278,775 205,210 156,652 264,482 1,063,296 2,643,058 40.23%PARKS DEPARTMENT EXPENDITURESSalaries & Wages79-790-50-00-5010 SALARIES & WAGES46,271 46,406 46,414 44,746 44,745 228,581 659,709 34.65%79-790-50-00-5015 PART-TIME SALARIES2,832 5,745 7,440 7,313 5,940 29,270 62,500 46.83%79-790-50-00-5020 OVERTIME58 - 769 - 1,314 2,141 5,000 42.82%Benefits79-790-52-00-5212RETIREMENT PLAN CONTRIBUTION5,324 5,337 5,402 5,110 5,282 26,455 70,935 37.29%79-790-52-00-5214 FICA CONTRIBUTION 3,643 3,872 4,061 3,865 3,853 19,293 53,594 36.00%22 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202179-790-52-00-5216 GROUP HEALTH INSURANCE22,007 22,292 10,989 10,684 14,252 80,223 173,195 46.32%79-790-52-00-5222 GROUP LIFE INSURANCE- 142 - 250 - 392 1,149 34.11%79-790-52-00-5223 DENTAL INSURANCE- 2,563 854 854 854 5,127 11,605 44.18%79-790-52-00-5224 VISION INSURANCE128 128 - 384 - 641 1,734 36.94%Contractual Services79-790-54-00-5412 TRAINING & CONFERENCES- - - - - - 9,000 0.00%79-790-54-00-5415 TRAVEL & LODGING- - - - - - 3,000 0.00%79-790-54-00-5422VEHICLE & EQUIPMENT CHARGEBACK- - - - - - 88,866 0.00%79-790-54-00-5424COMPUTER REPLACEMENT CHARGEBACK- - - - - - - 0.00%79-790-54-00-5440 TELECOMMUNICATIONS - 691 1,191 727 727 3,336 8,250 40.44%79-790-54-00-5462 PROFESSIONAL SERVICES 510 589 634 3,141 829 5,703 11,400 50.02%79-790-54-00-5466 LEGAL SERVICES - - - - - - 1,000 0.00%79-790-54-00-5485 RENTAL & LEASE PURCHASE 95 95 5,645 1,037 95 6,967 8,055 86.49%79-790-54-00-5488 OFFICE CLEANING - 341 344 352 352 1,387 3,487 39.78%79-790-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 53 88 16 3,357 3,514 40,000 8.78%Supplies79-790-56-00-5600 WEARING APPAREL - - 312 125 274 711 6,220 11.43%79-790-56-00-5620 OPERATING SUPPLIES - 775 472 1,615 1,500 4,362 25,000 17.45%79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - 17 178 44 145 384 11,000 3.49%79-790-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - - - - 0.00%79-790-56-00-5640 REPAIR & MAINTENANCE 659 11,336 10,413 5,166 6,690 34,263 71,000 48.26%79-790-56-00-5646 ATHLETIC FIELDS & EQUIPMENT - 326 - 4,153 7,760 12,240 55,000 22.25%79-790-56-00-5695 GASOLINE - 955 3,517 4,091 2,751 11,314 21,824 51.84%TOTAL EXPENDITURES: PARKS DEPARTMENT 81,526 101,661 98,723 93,673 100,719 476,302 1,402,523 33.96%RECREATION DEPARTMENT EXPENDITURESSalaries & Wages79-795-50-00-5010 SALARIES & WAGES 28,258 24,483 25,867 28,256 28,256 135,120 386,753 34.94%79-795-50-00-5015 PART-TIME SALARIES 33 496 468 - 2,240 3,236 23,500 13.77%79-795-50-00-5045 CONCESSION WAGES 680 2,591 2,298 - 672 6,241 15,000 41.60%79-795-50-00-5046 PRE-SCHOOL WAGES 2,399 656 1,013 540 1,025 5,633 40,000 14.08%79-795-50-00-5052 INSTRUCTORS WAGES 2,113 1,219 1,193 1,525 987 7,036 40,000 17.59%23 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021Benefits79-795-52-00-5212RETIREMENT PLAN CONTRIBUTION3,148 2,737 2,893 3,289 3,236 15,304 45,446 33.67%79-795-52-00-5214 FICA CONTRIBUTION 2,492 2,211 2,320 2,271 2,476 11,769 37,238 31.60%79-795-52-00-5216 GROUP HEALTH INSURANCE 12,962 9,856 4,148 5,343 4,372 36,680 107,479 34.13%79-795-52-00-5222 GROUP LIFE INSURANCE (41) 109 (41) 242 (41) 229 748 30.60%79-795-52-00-5223 DENTAL INSURANCE - 1,279 455 492 455 2,683 7,685 34.91%79-795-52-00-5224 VISION INSURANCE 72 59 - 209 - 340 1,156 29.38%Contractual Services79-795-54-00-5412 TRAINING & CONFERENCES - - 824 14 - 839 5,000 16.77%79-795-54-00-5415 TRAVEL & LODGING - - - - - - 3,000 0.00%79-795-54-00-5424COMPUTER REPLACEMENT CHARGEBACK- - - - - - 1,770 0.00%79-795-54-00-5426 PUBLISHING & ADVERTISING 3,500 527 - 264 854 5,145 55,000 9.35%79-795-54-00-5440 TELECOMMUNICATIONS - 681 679 1,610 868 3,837 8,750 43.86%79-795-54-00-5447 SCHOLARSHIPS - - - - - - 2,500 0.00%79-795-54-00-5452 POSTAGE & SHIPPING 67 259 74 72 65 537 3,500 15.34%79-795-54-00-5460 DUES & SUBSCRIPTIONS - 39 - - - 39 3,000 1.30%79-795-54-00-5462 PROFESSIONAL SERVICES 2,151 12,117 19,320 6,036 10,743 50,368 140,000 35.98%79-795-54-00-5480 UTILITIES - 172 441 615 328 1,556 14,072 11.06%79-795-54-00-5485 RENTAL & LEASE PURCHASE 95 95 155 95 95 533 3,000 17.77%79-795-54-00-5488 OFFICE CLEANING - 619 622 630 600 2,471 7,938 31.13%79-795-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - 12 - 306 318 3,000 10.60%Supplies79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 9,475 - 602 36,275 74,584 120,937 120,000 100.78%79-795-56-00-5606 PROGRAM SUPPLIES 13,300 47,638 21,931 9,203 4,416 96,488 200,000 48.24%79-795-56-00-5607 CONCESSION SUPPLIES 350 492 1,945 779 3,380 6,947 18,000 38.59%79-795-56-00-5610 OFFICE SUPPLIES - - 52 76 247 375 3,000 12.51%79-795-56-00-5620 OPERATING SUPPLIES - 3,170 3,466 2,520 2,378 11,534 15,000 76.90%79-795-56-00-5640 REPAIR & MAINTENANCE - - 6 52 458 516 2,000 25.79%TOTAL EXPENDITURES: RECREATION DEPARTMENT 81,053 111,505 90,745 100,408 142,998 526,709 1,313,535 40.10%TOTAL FUND REVENUES 158,176 278,775 205,210 156,652 264,482 1,063,296 2,643,058 40.23%TOTAL FUND EXPENDITURES 162,579 213,166 189,468 194,081 243,717 1,003,011 2,716,058 36.93%FUND SURPLUS (DEFICIT) (4,403) 65,610 15,742 (37,429) 20,765 60,285 (73,000) 24 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021LIBRARY OPERATIONS REVENUESTaxes82-000-40-00-4000 PROPERTY TAXES 36,449 366,781 11,201 30,247 312,477 757,156 776,734 97.48%82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE 39,429 396,774 12,117 32,721 338,029 819,070 836,024 97.97%Intergovernmental82-000-41-00-4120 PERSONAL PROPERTY TAX 2,085 - 1,519 193 - 3,797 5,250 72.33%82-000-41-00-4170 STATE GRANTS - - - 24,958 - 24,958 21,151 118.00%Fines & Forfeits82-000-43-00-4330 LIBRARY FINES 557 485 238 1,215 152 2,646 8,500 31.13%Charges for Service82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,435 991 - 2,735 - 5,161 8,500 60.72%82-000-44-00-4422 COPY FEES 271 297 - 547 287 1,402 3,800 36.90%82-000-44-00-4438 PROGRAM FEES - - - 11 - 11 - 0.00%Investment Earnings82-000-45-00-4500 INVESTMENT EARNINGS 41 44 64 61 72 283 2,000 14.13%82-000-45-00-4550 GAIN ON INVESTMENT - - - - 355 355 - 0.00%Miscellaneous82-000-48-00-4820 RENTAL INCOME - - - - 75 75 1,750 4.29%82-000-48-00-4850 MISCELLANEOUS INCOME 98 374 175 360 249 1,256 2,000 62.81%Other Financing Sources82-000-49-00-4901 TRANSFER FROM GENERAL 1,775 1,775 2,139 1,775 1,775 9,240 26,993 34.23%TOTAL REVENUES: LIBRARY 82,141 767,522 27,453 94,824 653,471 1,625,410 1,692,702 96.02%LIBRARY OPERATIONS EXPENDITURESSalaries & Wages82-820-50-00-5010 SALARIES & WAGES17,137 17,567 19,173 21,179 21,452 96,508 286,470 33.69%82-820-50-00-5015 PART-TIME SALARIES12,796 12,339 12,568 12,770 11,441 61,914 195,544 31.66%Benefits82-820-52-00-5212RETIREMENT PLAN CONTRIBUTION1,904 1,952 2,130 2,353 2,383 10,722 32,180 33.32%82-820-52-00-5214 FICA CONTRIBUTION 2,219 2,217 2,357 2,521 2,440 11,754 35,685 32.94%82-820-52-00-5216 GROUP HEALTH INSURANCE 11,119 12,186 6,145 7,145 7,266 43,861 105,501 41.57%82-820-52-00-5222 GROUP LIFE INSURANCE - 66 - 131 - 196 377 52.09%82-820-52-00-5223 DENTAL INSURANCE - 1,439 480 554 517 2,988 7,079 42.21%82-820-52-00-5224 VISION INSURANCE 34 72 - 228 - 333 1,088 30.65%25 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202182-820-52-00-5230 UNEMPLOYMENT INSURANCE- - 364 - - 364 1,000 36.40%82-820-52-00-5231 LIABILITY INSURANCE2,114 1,775 1,775 1,775 1,775 9,215 25,993 35.45%Contractual Services82-820-54-00-5412 TRAINING & CONFERENCES- - - - 20 20 3,000 0.67%82-820-54-00-5415 TRAVEL & LODGING- - - - - - 1,500 0.00%82-820-54-00-5426 PUBLISHING & ADVERTISING- - 167 - - 167 2,500 6.68%82-820-54-00-5440 TELECOMMUNICATIONS- 426 - 252 293 971 7,200 13.49%82-820-54-00-5452 POSTAGE & SHIPPING- 12 6 180 34 232 750 30.90%82-820-54-00-5460 DUES & SUBSCRIPTIONS569 1,371 1,492 13 172 3,616 11,000 32.88%82-820-54-00-5462 PROFESSIONAL SERVICES1,262 2,982 2,767 3,973 4,312 15,297 40,000 38.24%82-820-54-00-5466 LEGAL SERVICES- - - 2,138 - 2,138 3,000 71.25%82-820-54-00-5468 AUTOMATION2,534 - 4,748 - - 7,282 20,000 36.41%82-820-54-00-5480 UTILITIES- - 2,406 1,343 1,392 5,141 12,351 41.62%82-820-54-00-5495OUTSIDE REPAIR & MAINTENANCE1,033 2,347 5,905 2,775 270 12,330 50,000 24.66%82-820-54-00-5498 PAYING AGENT FEES - 1,100 589 - - 1,689 1,700 99.32%Supplies82-820-56-00-5610 OFFICE SUPPLIES - 454 193 168 866 1,681 8,000 21.01%82-820-56-00-5620 OPERATING SUPPLIES - 446 - - 240 686 4,000 17.14%82-820-56-00-5621 CUSTODIAL SUPPLIES - 28 103 169 289 589 7,000 8.41%82-820-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - 807 807 2,000 40.35%82-820-56-00-5671 LIBRARY PROGRAMMING - 26 180 - - 206 2,000 10.30%82-820-56-00-5675 EMPLOYEE RECOGNITION - - - - - - 300 0.00%82-820-56-00-5685 DVD'S - - - - - - 500 0.00%82-820-56-00-5686 BOOKS - - - 272 - 272 1,500 18.16%2006 Bond82-820-84-00-8000 PRINCIPAL PAYMENT - - - - - - 75,000 0.00%82-820-84-00-8050 INTEREST PAYMENT - 8,338 - - - 8,338 16,675 50.00%2013 Refunding Bond82-820-99-00-8000 PRINCIPAL PAYMENT - - - - - - 645,000 0.00%26 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 202182-820-99-00-8050 INTEREST PAYMENT- 51,775 - - - 51,775 103,550 50.00%TOTAL FUND REVENUES82,141 767,522 27,453 94,824 653,471 1,625,410 1,692,702 96.02%TOTAL FUND EXPENDITURES52,721 118,916 63,548 59,939 55,969 351,092 1,709,443 20.54%FUND SURPLUS (DEFICIT)29,420 648,606 (36,095) 34,884 597,502 1,274,318 (16,741) LIBRARY CAPITAL REVENUES84-000-42-00-4214 DEVELOPMENT FEES10,300 10,300 13,150 16,650 9,750 60,150 50,000 120.30%84-000-45-00-4500 INVESTMENT EARNINGS13 14 16 16 16 76 200 37.89%84-000-48-00-4850 MISCELLANEOUS INCOME- 31 - - - 31 - 0.00%TOTAL REVENUES: LIBRARY CAPITAL10,313 10,346 13,166 16,666 9,766 60,257 50,200 120.03%LIBRARY CAPITAL EXPENDITURES84-840-54-00-5460 E-BOOK SUBSCRIPTIONS- - - - - - 3,500 0.00%84-840-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - - - 15,000 0.00%84-840-56-00-5683 AUDIO BOOKS - 20 265 231 210 726 3,500 20.74%84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - 500 0.00%84-840-56-00-5685 DVD'S - 121 181 261 241 805 3,000 26.82%84-840-56-00-5686 BOOKS - 2,239 1,090 2,386 4,892 10,607 50,000 21.21%84-840-60-00-6020 BUILDING IMPROVEMENTS - - - 866 866 20,000 4.33%TOTAL FUND REVENUES 10,313 10,346 13,166 16,666 9,766 60,257 50,200 120.03%TOTAL FUND EXPENDITURES - 2,380 1,537 3,743 5,343 13,003 95,500 13.62%FUND SURPLUS (DEFICIT) 10,313 7,965 11,629 12,922 4,423 47,254 (45,300) COUNTRYSIDE TIF REVENUES87-000-40-00-4000 PROPERTY TAXES - 56,774 573 - 168,913 226,260 260,727 86.78%TOTAL REVENUES: COUNTRYSIDE TIF - 56,774 573 - 168,913 226,260 260,727 86.78%COUNTRYSIDE TIF EXPENDITURESContractual Services87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 948 948 948 948 948 4,742 11,381 41.67%87-870-54-00-5462 PROFESSIONAL SERVICES - - - - - - 2,000 0.00%87-870-54-00-5498 PAYING AGENT FEES- - 126 - - 126 700 17.95%27 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 20212015A Bond87-870-77-00-8000 PRINCIPAL PAYMENT - - - - - - 112,455 0.00%87-870-77-00-8050 INTEREST PAYMENT 23,073 - - - - 23,073 46,146 50.00%2014 Refunding Bond87-870-93-00-8050 INTEREST PAYMENT 25,358 - - - - 25,358 50,715 50.00%TOTAL FUND REVENUES - 56,774 573 - 168,913 226,260 260,727 86.78%TOTAL FUND EXPENDITURES 49,379 948 1,074 948 948 53,298 223,397 23.86%FUND SURPLUS (DEFICIT) (49,379) 55,825 (501) (948) 167,964 172,962 37,330 DOWNTOWN TIF REVENUES88-000-40-00-4000 PROPERTY TAXES 7,651 48,602 1,303 590 37,770 95,915 70,000 137.02%TOTAL REVENUES: DOWNTOWN TIF 7,651 48,602 1,303 590 37,770 95,915 70,000 137.02%DOWNTOWN TIF EXPENDITURESContractual Services88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 2,918 2,918 2,918 2,918 2,918 14,592 35,020 41.67%88-880-54-00-5425 TIF INCENTIVE PAYOUT - - - - - - 27,820 0.00%88-880-54-00-5462 PROFESSIONAL SERVICES - 330 - - - 330 5,000 6.60%Capital Outlay88-880-60-00-6000 PROJECT COSTS - - - - - - 10,000 0.00%88-880-60-00-6079 ROUTE 47 EXPANSION 624 624 624 624 624 3,120 7,488 41.67%FNBO Loan - 102 E Van Emmon Building88-880-81-00-8000 PRINCIPAL PAYMENT - 200,000 - - - 200,000 200,000 100.00%88-880-81-00-8050 INTEREST PAYMENT - 6,083 - - - 6,083 6,084 99.99%TOTAL FUND REVENUES7,651 48,602 1,303 590 37,770 95,915 70,000 137.02%TOTAL FUND EXPENDITURES3,542 209,956 3,542 3,542 3,542 224,125 291,412 76.91%FUND SURPLUS (DEFICIT)4,109 (161,354) (2,239) (2,953) 34,227 (128,210) (221,412) DOWNTOWN TIF II REVENUES89-000-40-00-4000 PROPERTY TAXES1,405 40,247 1,309 319 32,018 75,298 48,526 155.17%TOTAL REVENUES: DOWNTOWN TIF II1,405 40,247 1,309 319 32,018 75,298 48,526 155.17%DOWNTOWN TIF II EXPENDITURES89-890-54-00-5425 TIF INCENTIVE PAYOUT17,500 - 1,805 - - 19,305 25,500 75.70%89-890-54-00-5462 PROFESSIONAL SERVICES- 88 - 55 - 143 5,000 2.86%28 % of Fiscal Year8% 17% 25% 33% 42%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTIONMay-21June-21July-21August-21 September-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended September 30, 2021TOTAL FUND REVENUES1,405 40,247 1,309 319 32,018 75,298 48,526 155.17%TOTAL FUND EXPENDITURES17,500 88 1,805 55 - 19,448 30,500 63.76%FUND SURPLUS (DEFICIT)(16,095) 40,159 (496) 264 32,018 55,850 18,026 29 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) REVENUES Property Taxes 1,378,450$ 3,340,045$ 97.48% 3,426,246$ 3,203,515$ 4.26% Municipal Sales Tax 401,970 1,814,000 50.63% 3,582,508 1,344,179 34.95% Non-Home Rule Sales Tax 317,410 1,401,887 52.91% 2,649,473 963,669 45.47% Electric Utility Tax 194,606 349,427 48.87% 715,000 348,789 0.18% Natural Gas Tax 16,927 101,821 37.71%270,000 76,841 32.51% Excise (Telecommunication) Tax 17,463 85,552 40.93%209,000 105,638 -19.01% Cable Franchise Fees - 140,879 46.96%300,000 133,454 5.56% Hotel Tax 7,683 47,514 59.39%80,000 23,421 102.87% Video Gaming Tax 18,711 96,957 69.26%140,000 18,699 418.50% Amusement Tax 20,099 67,118 53.69%125,000 43,855 53.05% State Income Tax 149,398 1,143,734 48.94% 2,336,774 903,244 26.63% Local Use Tax 60,281 283,346 30.22%937,660 313,420 -9.60% Road & Bridge Tax 21,034 53,404 97.14%54,975 50,128 6.53% Building Permits 79,497 455,479 101.22%450,000 310,045 46.91% Garbage Surcharge 362 480,344$ 34.91%1,376,063 444,608 8.04% Investment Earnings 4,114 5,534$ 27.67% 20,000$ 7,275 -23.93% MOTOR FUEL TAX FUND (15) REVENUES Motor Fuel Tax 40,299$ 187,335$ 38.82% 482,526$ 158,192$ 18.42% Transportation Renewal Funds 28,337 133,268 38.45%346,618 110,722 20.36% WATER FUND (51) REVENUES Water Sales 6,049$ 1,229,090$ 36.02%3,412,500$ 1,146,768$ 7.18% Water Infrastructure Fees 464 282,224 34.42%820,000 271,309 4.02% Water Connection Fees 50,600 205,908 89.53%230,000 303,214 -32.09% Water Meter Sales 15,860 124,820 208.03%60,000 107,650 15.95% SEWER FUND (52) REVENUES Sewer Maintenance Fees 353$ 353,054$ 33.45%1,055,596$ 339,404$ 4.02% Sewer Infrastructure Fees 220 138,031 34.94%395,000 130,406 5.85% Sewer Connection Fees 25,500 123,500 60.75%203,300 137,900 -10.44% PARKS & RECREATION (79) REVENUES Special Events 45$ 57,189$ 63.54%90,000$ 4,450$ 1185.15% Child Development 12,455 44,022 30.36%145,000 18,116 143.00% Athletics & Fitness 3,344 125,137 33.82%370,000 107,443 16.47% Rental Income 700 58,949 89.03% 66,209 56,376 4.56% Hometown Days 124,044 139,574 116.31% 120,000 1,675 8232.77% *September represents 42% of fiscal year 2022 UNITED CITY OF YORKVILLE MONTHLY ANALYSIS OF MAJOR REVENUES For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 30 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes 1,378,450$ 3,340,045$ 97.48% 3,426,246$ 3,203,515$ 4.26% Municipal Sales Tax 401,970 1,814,000 50.63% 3,582,508 1,344,179 34.95% Non-Home Rule Sales Tax 317,410 1,401,887 52.91% 2,649,473 963,669 45.47% Electric Utility Tax 194,606 349,427 48.87% 715,000 348,789 0.18% Natural Gas Tax 16,927 101,821 37.71% 270,000 76,841 32.51% Excise (Telecommunication) Tax 17,463 85,552 40.93% 209,000 105,638 -19.01% Telephone Utility Tax 695 3,475 41.66%8,340 3,475 0.00% Cable Franchise Fees - 140,879 46.96% 300,000 133,454 5.56% Hotel Tax 7,683 47,514 59.39% 80,000 23,421 102.87% Video Gaming Tax 18,711 96,957 69.26% 140,000 18,699 418.50% Amusement Tax 20,099 67,118 53.69% 125,000 43,855 53.05% Admissions Tax - - 0.00% 145,000 - 0.00% Business District Tax 51,934 218,911 51.88% 421,950 156,499 39.88% Auto Rental Tax 1,827 7,408 44.90% 16,500 4,457 66.21% Total Taxes 2,427,776$ 7,674,994$ 63.49% 12,089,017$ 6,426,492$ 19.43% Intergovernmental State Income Tax 149,398$ 1,143,734$ 48.94% 2,336,774$ 903,244$ 26.63% Local Use Tax 60,281 283,346 30.22% 937,660 313,420 -9.60% Cannabis Exise Tax 2,366 11,293 57.63% 19,596.00 5,012 125.32% Road & Bridge Tax 21,034 53,404 97.14% 54,975 50,128 6.53% Personal Property Replacement Tax - 11,459 69.45% 16,500 6,775 69.14% Other Intergovernmental 30,389 262,321 723.14% 36,275 29,171 799.26% Total Intergovernmental 263,468$ 1,765,556$ 51.90% 3,401,780$ 1,307,750$ 35.01% Licenses & Permits Liquor Licenses 600$ 5,664$ 8.71% 65,000$ 22,267$ -74.56% Building Permits 79,497 455,479 101.22% 450,000 310,045 46.91% Other Licenses & Permits - 2,896 30.49%9,500 3,845 -24.67% Total Licenses & Permits 80,097$ 464,039$ 88.47% 524,500$ 336,158$ 38.04% Fines & Forfeits Circuit Court Fines 5,190$ 18,575$ 53.07% 35,000$ 9,424$ 97.11% Administrative Adjudication 1,243 8,696 32.82% 26,500 6,192 40.45% Police Tows 9,500 28,000 50.91% 55,000 25,000 12.00% Other Fines & Forfeits 70 220 62.86%350 170 29.41% Total Fines & Forfeits 16,003$ 55,492$ 47.49% 116,850$ 40,786$ 36.06% Charges for Services ^Garbage Surcharge 362$ 480,344$ 34.91% 1,376,063$ 444,608$ 8.04% ^Late PMT Penalties - Garbage 6 9,705 46.21% 21,000 31 31036.12% ^UB Collection Fees 17,252 60,207 36.49% 165,000 83,702 -28.07% Administrative Chargebacks 18,213 91,067 41.67% 218,560 89,123 2.18% Other Services 2,213 2,453 490.50%500 - 0.00% Total Charges for Services 38,045$ 643,775$ 36.14% 1,781,123$ 617,465$ 4.26% Investment Earnings 4,114$ 5,534$ 27.67% 20,000$ 7,275$ -23.93% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 31 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ 1,009$ 10.09% 10,000$ 2,522$ -60.00% Other Reimbursements 578 6,313 23.38% 27,000 16,811 -62.45% Rental Income 630 2,390 34.14%7,000 1,000.00 139.00% Miscellaneous Income & Transfers In 3,002 31,060 25.25% 123,000 68,174 -54.44% Total Miscellaneous 4,210$ 40,772$ 24.41% 167,000$ 88,507$ -53.93% Total Revenues and Transfers 2,833,714$ 10,650,162$ 58.84% 18,100,270$ 8,824,433$ 20.69% Expenditures Administration 58,164$ 351,117$ 35.24%996,443$ 383,456$ -8.43% 50 Salaries 38,969 222,794 35.56% 626,473 246,873 -9.75% 52 Benefits 9,747 72,322 35.96% 201,133 93,102 -22.32% 54 Contractual Services 9,180 52,219 32.88% 158,837 38,871 34.34% 56 Supplies 267 3,782 37.82% 10,000 4,610 -17.97% Finance 33,937$ 207,833$ 37.29%557,390$ 217,203$ -4.31% 50 Salaries 23,206 127,198 38.93% 326,735 124,691 2.01% 52 Benefits 7,167 45,432 40.97% 110,880 50,418 -9.89% 54 Contractual Services 3,564 34,976 29.82% 117,275 41,357 -15.43% 56 Supplies - 226 9.06%2,500 737 -69.26% Police 884,745$ 3,180,042$ 51.63%6,158,904$ 3,004,203$ 5.85% Salaries 247,695 1,261,366 37.72% 3,343,778 1,277,285 -1.25% Overtime 10,650 42,805 38.56% 111,000 37,135 15.27% 52 Benefits 602,839 1,752,504 78.47% 2,233,424 1,581,299 10.83% 54 Contractual Services 16,799 100,418 28.22% 355,804 87,807 14.36% 56 Supplies 6,762 22,949 19.97% 114,898 20,677 10.99% Community Development 74,061$ 384,982$ 38.87%990,515$ 316,655$ 21.58% 50 Salaries 41,569 218,572 38.92% 561,611 219,527 -0.43% 52 Benefits 12,491 88,843 45.64% 194,672 82,662 7.48% 54 Contractual Services 19,346 74,918 33.60% 222,980 10,052 645.29% 56 Supplies 656 2,649 23.54% 11,252 4,414 -39.99% PW - Street Ops & Sanitation 188,444$ 727,801$ 27.47%2,649,285$ 720,398$ 1.03% Salaries 34,506 179,939 31.33% 574,297 179,945 0.00% Overtime 392 925 4.11% 22,500 822 12.44% 52 Benefits 15,232 100,566 36.76% 273,580 91,098 10.39% 54 Contractual Services 134,539 429,912 26.08% 1,648,528 427,961 0.46% 56 Supplies 3,775 16,459 12.62% 130,380 20,572 -19.99% Administrative Services 404,863$ 1,959,107$ 29.03%6,747,733$ 1,480,405$ 32.34% 50 Salaries 2,213 2,453 490.60%500 - 0.00% 52 Benefits 39,168 250,198 61.40% 407,520 212,295 17.85% 54 Contractual Services 138,605 577,964 17.66% 3,272,288 396,199 45.88% 56 Supplies - - 0.00% 15,000 - 0.00% 70 Contingency - - 0.00% 44,000 - 0.00% 99 Transfers Out 224,877 1,128,492 37.51% 3,008,425 871,910 29.43% Total Expenditures and Transfers 1,644,213$ 6,810,882$ 37.63% 18,100,270$ 6,122,320$ 11.25% Surplus(Deficit)1,189,501$ 3,839,281$ -$ 2,702,113$ ^modified accruals basis *September represents 42% of fiscal year 2022 50 50 32 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales 6,049$ 1,229,090$ 36.02% 3,412,500$ 1,146,768$ 7.18% ^ Water Infrastructure Fees 464 282,224 34.42% 820,000 271,309 4.02% ^ Late Penalties 38 46,786 40.20% 116,394 274 17000.79% Water Connection Fees 50,600 205,908 89.53% 230,000 303,214 -32.09% Bulk Water Sales - - 0.00% 5,000 (1,950) -100.00% Water Meter Sales 15,860 124,820 208.03% 60,000 107,650 15.95% Total Charges for Services 73,011$ 1,888,828$ 40.67% 4,643,894$ 1,827,265$ 3.37% Investment Earnings 738$ 1,121$ 37.37% 3,000$ 764$ 46.74% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.00%-$ 9,711$ -100.00% Rental Income 11,489 45,232 44.07% 102,644 41,475 9.06% Miscellaneous Income & Transfers In 15,019 75,557 24.24% 311,733 74,982 0.77% Total Miscellaneous 26,508$ 120,788$ 29.15% 414,377$ 126,168$ -4.26% Total Revenues and Transfers 100,257$ 2,010,737$ 39.73% 5,061,271$ 1,954,197$ 2.89% Expenses Water Operations Salaries 36,863$ 184,158$ 35.70% 515,856$ 183,459$ 0.38% Overtime 547 2,081 9.46% 22,000 1,495 39.18% 52 Benefits 19,869 123,048 50.51% 243,593 105,498 16.64% 54 Contractual Services 93,455 349,211 32.53% 1,073,649 272,898 27.96% 56 Supplies 47,074 150,782 40.73% 370,225 127,539 18.22% 60 Capital Outlay 47,096$ 372,840$ 18.27%2,040,580$ 161,184$ 131.31% Well Rehabilitations & Water Tower Painting - - 0.00% 212,000 Road to Better Roads Program 42,704 353,166 37.18% 950,000 US 34 Project (IL Rte 47 to Orchard)- - 0.00% 21,000 Route 71 Watermain Replacement - - 0.00% 33,208 Route 47 Expansion 3,781 18,905 41.67% 45,372 Cation Exhange Media Replacement - - 0.00% 216,000 Vehicles & Equipment 611 769 0.14% 563,000 Debt Service -$ 164,142$ 9.04% 1,815,830$ 201,549$ -18.56% 2015A Bond - 64,127 14.55% 440,799 2016 Refunding Bond - 29,325 2.67% 1,098,650 IEPA Loan L17-156300 - 62,515 50.00% 125,031 2014C Refunding Bond - 8,175 5.40% 151,350 Total Expenses 244,904$ 1,346,262$ 22.14% 6,081,733$ 1,053,622$ 27.77% Surplus(Deficit)(144,648)$ 664,475$ (1,020,462)$ 900,575$ ^modified accruals basis *September represents 42% of fiscal year 2022 94 Charges for Services 89 50 6025 6059 6022 6066 6081 6079 6070 77 85 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 33 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 353$ 353,054$ 33.45% 1,055,596$ 339,404$ 4.02% ^Sewer Infrastructure Fees 220 138,031 34.94% 395,000 130,406 5.85% ^Late Penalties 5 6,784 42.51% 15,957 40 16753.69% Sewer Connection Fees 25,500 123,500 60.75% 203,300 137,900 -10.44% Total Charges for Services 26,078$ 621,369$ 37.21% 1,669,853$ 607,751$ 2.24% Investment Earnings 2,906$ 2,970$ 198.00% 1,500$ 309$ 861.15% Reimbursements/Miscellaneous/Transfers In Miscellaneous Income & Transfers In 43,312 216,791 35.88% 604,249 75,625 186.67% Total Miscellaneous 43,312$ 216,791$ 35.88% 604,249$ 75,625$ 186.67% Total Revenues and Transfers 72,296$ 841,130$ 36.96% 2,275,602$ 683,685$ 23.03% Expenses Sewer Operations Salaries 19,378$ 96,664$ 34.73% 278,333$ 98,703$ -2.07% Overtime 100 321 64.20%500 88 263.43% 52 Benefits 8,057 58,285 38.41% 151,754 64,611 -9.79% 54 Contractual Services 8,408 63,617 29.64% 214,665 90,764 -29.91% 56 Supplies 4,748 11,458 17.48% 65,563 10,398 10.20% 60 Capital Outlay 45,656$ 53,150$ 15.57% 341,309$ 35,748$ 48.68% SCADA 43,783 43,783 65.35% 67,000 US 34 Project (IL Rte 47 to Orchard)- - 0.00%1,100 Route 71 Sewer Main Replacement - - 0.00% 68,721 Vehicles & Equipment - - 0.00% 182,000 Route 47 Expansion 1,873 9,367 41.66% 22,488 Debt Service -$ 115,390$ 8.87% 1,300,780$ 137,899$ -16.32% 2003 IRBB Debt Certificates - 7,855 4.74% 165,710 2011 Refunding Bond - 107,535 9.47% 1,135,070 99 Transfers Out 6,306$ 31,531$ 41.67% 75,675$ 31,302$ 0.73% Total Expenses and Transfers 92,654$ 430,417$ 17.72% 2,428,579$ 469,514$ -8.33% Surplus(Deficit)(20,358)$ 410,713$ (152,977)$ 214,171$ ^modified accruals basis *September represents 42% of fiscal year 2022 6079 90 92 6070 Charges for Services 50 6001 6059 6066 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 34 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 45$ 57,189$ 63.54% 90,000$ 4,450$ 1185.15% Child Development 12,455 44,022 30.36% 145,000 18,116 143.00% Athletics & Fitness 3,344 125,137 33.82% 370,000 107,443 16.47% Concession Revenue 3,513 20,817 46.26% 45,000 4,251 389.70% Total Charges for Services 19,356$ 247,165$ 38.03% 650,000$ 134,260$ 84.09% Investment Earnings 8$ 41$ 16.24%250$ 204$ -80.09% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.00%-$ -$ 0.00% Rental Income 700 58,949 89.03% 66,209 56,376 4.56% Park Rentals 535 8,282 47.33% 17,500 1,231 572.97% Hometown Days 124,044 139,574 116.31% 120,000 1,675 8232.77% Sponsorships & Donations 250 7,200 48.00% 15,000 3,022 138.25% Miscellaneous Income & Transfers In 119,589 602,086 33.94% 1,774,099 550,228 9.42% Total Miscellaneous 245,118$ 816,091$ 40.95% 1,992,808$ 612,531$ 33.23% Total Revenues and Transfers 264,482$ 1,063,296$ 40.23% 2,643,058$ 746,995$ 42.34% Expenditures Parks Department 103,347$ 476,302$ 33.96%1,402,523$ 401,895$ 18.51% Salaries 53,313 257,851 35.70% 722,209 241,098 6.95% Overtime 1,314 2,141 42.82%5,000 1,055.08 102.91% 52 Benefits 24,241 132,130 42.32% 312,212 123,898 6.64% 54 Contractual Services 5,359 20,907 12.08% 173,058 13,122 59.33% 56 Supplies 19,120 63,274 33.29% 190,044 22,722 178.47% Recreation Department 142,998$ 526,709$ 40.10%1,313,535$ 297,364$ 77.13% 50 Salaries 33,179 157,266 31.13% 505,253 157,873 -0.38% 52 Benefits 10,499 67,003 33.54% 199,752 69,275 -3.28% 54 Contractual Services 13,858 65,643 26.20% 250,530 28,289 132.04% 56 Hometown Days 74,584 120,937 100.78% 120,000 12,425 873.33% 56 Supplies 10,878 115,860 48.68% 238,000 29,502 292.72% Total Expenditures 246,346$ 1,003,011$ 36.93% 2,716,058$ 699,259$ 43.44% Surplus(Deficit)18,136$ 60,285$ (73,000)$ 47,736$ *September represents 42% of fiscal year 2022 YORKVILLE PARKS & RECREATION STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 50 35 September YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 650,506$ 1,576,225$ 97.73% 1,612,758$ 1,503,154$ 4.86% Intergovernmental Personal Property Replacement Tax -$ 3,797$ 72.33%5,250$ 2,245$ 69.14% State Grants - 24,958 118.00% 21,151 21,151 18.00% Total Intergovernmental -$ 28,756$ 108.92% 26,401$ 23,396$ 22.91% Library Fines 152$ 2,646$ 31.13%8,500$ 1,654$ 60.00% Charges for Services Library Subscription Cards -$ 5,161$ 60.72%8,500$ 1,161$ 344.60% Program Fes - 11 0.00%-$ -$ 0.00% Copy Fees 287 1,402 36.90%3,800 335 318.85% Total Charges for Services 287$ 6,575$ 53.45% 12,300$ 1,496$ 339.59% Investment Earnings 427$ 637$ 31.86%2,000$ 685$ -7.02% - Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.00%-$ -$ 0.00% Rental Income 75 75 4.29%1,750 - 0.00% Miscellaneous Income 249 1,256 62.81%2,000 374 236.04% Transfer In 1,775 9,240 34.23% 26,993 13,888 -33.47% Total Miscellaneous & Transfers 2,099$ 10,572$ 34.39% 30,743$ 14,262$ -25.88% Total Revenues and Transfers 653,471$ 1,625,410$ 96.02% 1,692,702$ 1,544,647$ 5.23% Expenditures Library Operations 55,969$ 351,092$ 20.54%1,709,443$ 373,485$ -6.00% 50 Salaries 32,893 158,422 32.87% 482,014 176,384 -10.18% 52 Benefits 14,382 79,435 38.02% 208,903 82,086 -3.23% 54 Contractual Services 6,493 48,883 31.95% 153,001 37,947 28.82% 56 Supplies 2,201 4,241 16.76% 25,300 6,025 -29.62% 99 Debt Service - 60,113 7.15% 840,225 71,044 -15.39% Total Expenditures and Transfers 55,969$ 351,092$ 20.54% 1,709,443$ 373,485$ -6.00% Surplus(Deficit)597,502$ 1,274,318$ (16,741)$ 1,171,162$ *September represents 42% of fiscal year 2022 YORKVILLE PUBLIC LIBRARY STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended September 30, 2021 * Fiscal Year 2021 For the Month Ended Sept 30, 2020 36 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 1TIME: 09:01:59 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 GJ-210503FC 05/05/2021 01 Flex Cobra - Mar 2021 110.00 AP-210525B 05/19/2021 09 05/04/21 EDC MEETING MINUTES MARLYS J. YOUNG 534716 050421 42.00 GJ-210528FC 06/01/2021 01 Flex Cobra - May 2021 50.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 202.00 0.00 02 GJ-210531FX 07/06/2021 01 Flex Cobra - May 2021 75.00 AP-210608A 06/02/2021 22 MAY 25 CITY COUNCIL MEETING CHRISTINE M. VITOSH 534812 CMV 2017 180.00 AP-210622B 06/15/2021 18 05/18/21 PW MEETING MINUTES MARLYS J. YOUNG 534904 051821 53.75 AP-210625MB 06/23/2021 03 ZOOM - MONTHLY USAGE FEE FIRST NATIONAL BANK 900105 062521-B.OLSON-B 209.96 _________________________________ TOTAL PERIOD 02 ACTIVITY 518.71 0.00 03 AP-2101725M 07/26/2021 11 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900107 072521-B.OLSON 209.96 AP-210713B 07/07/2021 47 MOBILE VENDOR BACKGROUND ILLINOIS STATE POLIC 534956 053121 84.75 07/07/2021 48 06/09/21 P&Z MEETING MINUTES MARLYS J. YOUNG 535012 060921 50.00 AP-210727 07/20/2021 09 06/15/21 PW MEETING MINUTES MARLYS J. YOUNG 535107 061521 49.50 07/20/2021 10 06/16/21 ADMIN MEETING MINUTES MARLYS J. YOUNG 535107 061621 54.25 GJ-210731FX 08/03/2021 01 FLEX - COBRA NOTICES JULY 2021 50.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 498.46 0.00 04 AP-210810 08/04/2021 13 SOLICITOR BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 480.25 08/04/2021 14 MOBILE VENDOR BACKGROUND ILLINOIS STATE POLIC 535142 063021 56.50 GJ-210816FE 08/25/2021 01 CLERK'S ACCOUNT-ANALYSIS FEE 5.40 AP-210824 08/17/2021 15 07/01/21 PUBLIC SAFETY MEETING MARLYS J. YOUNG 535262 070121 59.25 08/17/2021 16 07/21/21 PW MEETING MINUTES MARLYS J. YOUNG 535262 072121 41.75 AP-210825M 08/19/2021 12 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900108 082521-B.OLSON 209.96 08/19/2021 13 GIFT OF HOPE-DONATION ON FIRST NATIONAL BANK 900108 082521-R.FREDRICKSON 500.00 GJ-210831FC 09/08/2021 01 FLEX COBRA NOTICES - JULY 2021 60.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 1,413.11 0.00 05 AP-210914 09/07/2021 19 08/12 PUBLIC SAFETY MEETING MARLYS J. YOUNG 535349 081221 45.75 GJ-210915FE 10/11/2021 01 CLERK'S ACCT - ANALYSIS CHARGE 16.50 AP-210925M 09/20/2021 09 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900109 092521-B.OLSON 209.96 _________________________________ TOTAL PERIOD 05 ACTIVITY 272.21 0.00 YTD BUDGET 5,000.00 TOTAL ACCOUNT ACTIVITY 2,904.49 0.00 ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 2,904.49_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 GJ-053121FE 07/14/2021 01 UB WSB LOCKBOX FEES - MAY 2020 152.51 GJ-210531FE 05/27/2021 01 UB CC Fees - Apr 2021 2,110.12 05/27/2021 07 UB Paymentus Fee-Apr 2021 1,399.63 05/27/2021 13 FNBO Analysis Chrg-Apr 2021 312.77 _________________________________ TOTAL PERIOD 01 ACTIVITY 3,975.03 0.00 02 GJ-063021FE 08/05/2021 01 UB WSB LOCKBOX FEE - JUN 2021 87.23 GJ-210630FE 06/24/2021 01 UB CC Fees - May 2021 1,767.70 06/24/2021 07 UB Paymentus Fees - May 2021 1,089.56 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 2TIME: 09:02:01 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 02 GJ-210630FE 06/24/2021 13 FNBO Analysis Chrg - May 2021 326.38 _________________________________ TOTAL PERIOD 02 ACTIVITY 3,270.87 0.00 03 AP-2101725M 07/26/2021 18 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 43.00 AP-210713B 07/07/2021 63 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 89.37 AP-210726M 07/26/2021 01 2021 PCORI FEE UNITED STATES TREASU 535111 2021 PCORI 159.60 AP-210727 07/20/2021 32 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 33.96 GJ-210731FE 07/27/2021 01 UB CC Fees - June 2021 873.23 07/27/2021 07 UB Paymentus Fees - June 2021 1,488.50 07/27/2021 13 FNBO Analysis Chrg - June 2021 373.93 _________________________________ TOTAL PERIOD 03 ACTIVITY 3,061.59 0.00 04 AP-210810 08/04/2021 23 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 233.56 GJ-210831FE 08/24/2021 01 UB CC Fees - July 2021 1,631.75 08/24/2021 07 UB Paymentus Fees - July 2021 1,175.32 08/24/2021 13 UB Analysis Fees - July 2021 316.45 _________________________________ TOTAL PERIOD 04 ACTIVITY 3,357.08 0.00 05 GJ-093021FE 10/11/2021 01 UB WSB LOCKBOX FEES 167.80 AP-210914 09/07/2021 34 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 91.73 GJ-210930FE 09/22/2021 01 UB CC Fees - Aug 2021 1,037.53 09/22/2021 07 UB Paymentus Fees - Aug 2021 1,516.67 09/22/2021 13 FNBO Analysis Chrg - Aug 2021 342.60 _________________________________ TOTAL PERIOD 05 ACTIVITY 3,156.33 0.00 YTD BUDGET 27,083.35 TOTAL ACCOUNT ACTIVITY 16,820.90 0.00 ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 16,820.90_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525MB 05/25/2021 03 ELINE UP-SOFTWARE RENEWAL FIRST NATIONAL BANK 900103 052521-N.DECKER-B 600.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 600.00 0.00 02 AP-210622B 06/15/2021 37 SOFTWARE MAINTENANCE AGREEMENT CAPERS LLC 534835 INV-0885 5,000.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 5,000.00 0.00 03 AP-2101725M 07/26/2021 27 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 133.00 07/26/2021 28 SHRED IT-MAY 2021 SHREDDING FIRST NATIONAL BANK 900107 072521-N.DECKER 202.33 07/26/2021 29 ACCURINT-MAY 2021 SEARCHES FIRST NATIONAL BANK 900107 072521-N.DECKER 150.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 485.33 0.00 04 AP-210810 08/04/2021 30 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 56.50 AP-210825M 08/19/2021 33 SHRED IT-07/05 SHREDDING FIRST NATIONAL BANK 900108 082521-N.DECKER 203.21 08/19/2021 34 ACCURINT-JUN 2021 SEARCHES FIRST NATIONAL BANK 900108 082521-N.DECKER 150.00 08/19/2021 35 SHRED IT-07/26 SHREDDING FIRST NATIONAL BANK 900108 082521-N.DECKER 204.10 08/19/2021 36 KENDALL PRINTING-PATROLL & FIRST NATIONAL BANK 900108 082521-N.DECKER 291.20 _________________________________ TOTAL PERIOD 04 ACTIVITY 905.01 0.00 05 AP-210928 09/21/2021 31 MONTHLY COURTSMART PUBLICATION DALE ANDERSON 535399 INV-0374 1,280.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 3TIME: 09:02:05 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 05 AP-210928 09/21/2021 32 2 PHOTO ID CARDS P.F. PETTIBONE & CO. 535415 180996 34.00 09/21/2021 33 APPLICANT POLYGRAPH TROTSKY INVESTIGATIV 535435 PD 21-02 155.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 1,469.00 0.00 YTD BUDGET 16,645.85 TOTAL ACCOUNT ACTIVITY 8,459.34 0.00 ANNUAL REVISED BUDGET 39,950.00 ENDING BALANCE 8,459.34_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525B 05/19/2021 13 ENCODE PLUS ANNUAL RENWAL ENCODE PLUS, LLC 534689 18972 5,250.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 5,250.00 0.00 02 AP-210608A 06/02/2021 45 KENDALL COUNTY DATABASE RECORD INFORMATION S 534803 50179 575.00 AP-210625MB 06/23/2021 23 ADOBE-MAY 2021 CREATIVE CLOUD FIRST NATIONAL BANK 900105 062521-J.ENGBERG-B 52.99 _________________________________ TOTAL PERIOD 02 ACTIVITY 627.99 0.00 03 AP-2101725M 07/26/2021 45 ADOBE-CREATIVE CLOUD FEE FIRST NATIONAL BANK 900107 072521-J.ENGBERG 52.99 07/26/2021 46 IWORDQ-INTERNET SOFTWARE FIRST NATIONAL BANK 900107 072521-K.BARKSDALE 4,750.00 07/26/2021 47 KENDALL CO TOWING-VEHICLE TOW FIRST NATIONAL BANK 900107 072521-P.RATOS 80.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 4,882.99 0.00 04 AP-210810 08/04/2021 38 PROFESSIONAL CONSULTING HOUSEAL LAVIGNE ASSO 535140 5177 970.00 AP-210824 08/17/2021 49 JULY 2021 CAR WASHES PARADISE CAR WASH 535245 224341 13.00 AP-210825M 08/19/2021 66 ADOBE-CREATIVE CLOUD MONTHLY FIRST NATIONAL BANK 900108 082521-J.ENGBERG 52.99 08/19/2021 67 ESRI-ARCGIS DESKTOP LICENSE FIRST NATIONAL BANK 900108 082521-K.BARKSDALE 500.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 1,535.99 0.00 05 AP-210914 09/07/2021 50 PROFESSIONAL CONSULTING HOUSEAL LAVIGNE ASSO 535299 5208 3,698.75 AP-210925M 09/20/2021 39 ADOBE-MONTHLY CREATIVE CLOUD FIRST NATIONAL BANK 900109 092521-J.ENGBERG 52.99 _________________________________ TOTAL PERIOD 05 ACTIVITY 3,751.74 0.00 YTD BUDGET 37,200.00 TOTAL ACCOUNT ACTIVITY 16,048.71 0.00 ANNUAL REVISED BUDGET 89,280.00 ENDING BALANCE 16,048.71_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525MB 05/25/2021 05 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 366.85 _________________________________ TOTAL PERIOD 01 ACTIVITY 366.85 0.00 02 AP-210622B 06/15/2021 44 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 5.13 AP-210625MB 06/23/2021 29 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 366.85 _________________________________ TOTAL PERIOD 02 ACTIVITY 371.98 0.00 03 AP-210713B 07/07/2021 95 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 56.50 AP-210727 07/20/2021 40 ANNUAL FY22 STORMWATER BILLING ILLINOIS EPS (NPDES) 535058 ILR400554-062821 1,000.00 07/20/2021 41 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.16 GJ-210727RC 07/21/2021 02 RC ILEPA Inv#ILR400554-062821 1,000.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,059.66 1,000.00 04 AP-210824 08/17/2021 51 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 2.82 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 4TIME: 09:02:12 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 04 AP-210825M 08/19/2021 73 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 244.00 08/19/2021 74 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 366.85 08/19/2021 75 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 366.85 _________________________________ TOTAL PERIOD 04 ACTIVITY 980.52 0.00 05 AP-210914 09/07/2021 61 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 1.52 AP-210925M 09/20/2021 45 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 366.85 _________________________________ TOTAL PERIOD 05 ACTIVITY 368.37 0.00 YTD BUDGET 3,843.75 TOTAL ACCOUNT ACTIVITY 3,147.38 1,000.00 ANNUAL REVISED BUDGET 9,225.00 ENDING BALANCE 2,147.38_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525B 05/19/2021 16 2020 ROB ROY DRAINAGE DIST FEE KENDALL COUNTY COLLE 534697 2020 FEE-ROB ROY 161.62 05/19/2021 17 2020 RAYMOND DRAINAGE DIST FEE KENDALL COUNTY COLLE 534697 2020 FEES-RAYMOND 315.58 AP-210527M 05/26/2021 01 2020 CALEDONIA DRAINAGE DIST KENDALL COUNTY COLLE 534719 2020012552-062021 20.00 05/26/2021 02 2020 CALEDONIA DRAINAGE DIST KENDALL COUNTY COLLE 534720 2020012553-062021 25.72 _________________________________ TOTAL PERIOD 01 ACTIVITY 522.92 0.00 03 AP-210727 07/20/2021 65 LOBBYIST FEE VILLAGE OF OSWEGO 535084 0521 1,166.67 07/20/2021 66 LOBBYIST FEE REIMBURSEMENT VILLAGE OF OSWEGO 535084 EGA050-2021-05 1,562.50 _________________________________ TOTAL PERIOD 03 ACTIVITY 2,729.17 0.00 04 AP-210824 08/17/2021 86 2021 ROAD PROGRAM ENGINEERING ENTERPRI 535210 71992 29,864.50 _________________________________ TOTAL PERIOD 04 ACTIVITY 29,864.50 0.00 YTD BUDGET 20,062.50 TOTAL ACCOUNT ACTIVITY 33,116.59 0.00 ANNUAL REVISED BUDGET 48,150.00 ENDING BALANCE 33,116.59_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 YTD BUDGET 5,625.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 13,500.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-205-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-225-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 GJ-053121FE 07/14/2021 03 UB WSB LOCKBOX FEES - MAY 2020 204.33 AP-210525MB 05/25/2021 11 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 430.65 GJ-210531FE 05/27/2021 03 UB CC Fees - Apr 2021 2,827.04 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 5TIME: 09:03:02 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 GJ-210531FE 05/27/2021 09 UB Paymentus Fee-Apr 2021 1,875.16 05/27/2021 15 FNBO Analysis Chrg-Apr 2021 419.04 GJ-21629PRE 06/29/2021 33 Cintas-2224 Tremont Monitoring 158.00 06/29/2021 34 Cintas-3299 Lehman Monitoring 158.00 06/29/2021 35 Cintas-610 Tower Monitoring 158.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 6,230.22 0.00 02 GJ-063021FE 08/05/2021 03 UB WSB LOCKBOX FEE - JUN 2021 116.87 AP-210625MB 06/23/2021 49 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 430.65 GJ-210630FE 06/24/2021 03 UB CC Fees - May 2021 2,368.29 06/24/2021 09 UB Paymentus Fees - May 2021 1,459.75 06/24/2021 15 FNBO Analysis Chrg - May 2021 437.27 _________________________________ TOTAL PERIOD 02 ACTIVITY 4,812.83 0.00 03 AP-210713B 07/07/2021 195 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 134.86 07/07/2021 196 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 56.50 AP-210727 07/20/2021 103 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 51.25 07/20/2021 104 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.15 07/20/2021 105 LOBBYIST FEE VILLAGE OF OSWEGO 535084 0521 1,166.67 07/20/2021 106 LOBBYIST FEE VILLAGE OF OSWEGO 535084 EGA050-2021-05 1,562.50 GJ-210731FE 07/27/2021 03 UB CC Fees - June 2021 1,169.91 07/27/2021 09 UB Paymentus Fees - June 2021 1,994.23 07/27/2021 15 FNBO Analysis Chrg - June 2021 500.98 _________________________________ TOTAL PERIOD 03 ACTIVITY 6,640.05 0.00 04 AP-210810 08/04/2021 103 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 352.47 AP-210824 08/17/2021 183 JULY 2021 DUMPING PLANO CLEAN FILL 535248 819 150.00 AP-210825M 08/19/2021 129 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 183.00 08/19/2021 130 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 430.65 08/19/2021 131 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 430.65 GJ-210831FE 08/24/2021 03 UB CC Fees - July 2021 2,186.14 08/24/2021 09 UB Paymentus Fees - July 2021 1,574.65 08/24/2021 15 UB Analysis Fees - July 2021 423.97 _________________________________ TOTAL PERIOD 04 ACTIVITY 5,731.53 0.00 05 GJ-093021FE 10/11/2021 03 UB WSB LOCKBOX FEES 224.80 AP-210914 09/07/2021 136 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 138.44 09/07/2021 137 BACKGROUND CHECKS ILLINOIS STATE POLIC 535300 073121-4811 56.50 AP-210925M 09/20/2021 91 PYSICIANS-RANDOM DOT TEST FIRST NATIONAL BANK 900109 092521-E.WILLRETT 58.00 09/20/2021 92 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 430.65 GJ-210930FE 09/22/2021 03 UB CC Fees - Aug 2021 1,390.03 09/22/2021 09 UB Paymentus Fees - Aug 2021 2,031.97 09/22/2021 15 FNBO Analysis Chrg - Aug 2021 459.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 4,789.39 0.00 YTD BUDGET 69,166.69 TOTAL ACCOUNT ACTIVITY 28,204.02 0.00 ANNUAL REVISED BUDGET 166,000.00 ENDING BALANCE 28,204.02_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 6TIME: 09:03:17 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 GJ-053121FE 07/14/2021 05 UB WSB LOCKBOX FEES - MAY 2020 95.31 AP-210525MB 05/25/2021 13 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 287.10 GJ-210531FE 05/27/2021 05 UB CC Fees - Apr 2021 1,318.74 05/27/2021 11 UB Paymentus Fee-Apr 2021 874.71 05/27/2021 17 FNBO Analysis Chrg-Apr 2021 195.47 _________________________________ TOTAL PERIOD 01 ACTIVITY 2,771.33 0.00 02 GJ-063021FE 08/05/2021 05 UB WSB LOCKBOX FEE - JUN 2021 54.52 AP-210625MB 06/23/2021 58 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 287.10 GJ-210630FE 06/24/2021 05 UB CC Fees - May 2021 1,104.75 06/24/2021 11 UB Paymentus Fees - May 2021 680.94 06/24/2021 17 FNBO Analysis Chrg - May 2021 203.97 _________________________________ TOTAL PERIOD 02 ACTIVITY 2,331.28 0.00 03 AP-210713B 07/07/2021 231 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 38.92 AP-210727 07/20/2021 136 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 14.79 07/20/2021 137 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.14 GJ-210731FE 07/27/2021 05 UB CC Fees - June 2021 545.73 07/27/2021 11 UB Paymentus Fees - June 2021 930.27 07/27/2021 17 FNBO Analysis Chrg - June 2021 233.70 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,766.55 0.00 04 AP-210810 08/04/2021 132 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 101.72 AP-210824 08/17/2021 226 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 2.82 AP-210825M 08/19/2021 167 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 287.10 08/19/2021 168 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 287.10 GJ-210831FE 08/24/2021 05 UB CC Fees - July 2021 1,019.78 08/24/2021 11 UB Paymentus Fees - July 2021 734.53 08/24/2021 17 UB Analysis Fees - July 2021 197.77 _________________________________ TOTAL PERIOD 04 ACTIVITY 2,630.82 0.00 05 GJ-093021FE 10/11/2021 05 UB WSB LOCKBOX FEES 104.86 AP-210914 09/07/2021 171 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 39.95 AP-210925M 09/20/2021 107 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 287.10 GJ-210930FE 09/22/2021 05 UB CC Fees - Aug 2021 648.42 09/22/2021 11 UB Paymentus Fees - Aug 2021 947.86 09/22/2021 17 FNBO Analysis Chrg - Aug 2021 214.11 _________________________________ TOTAL PERIOD 05 ACTIVITY 2,242.30 0.00 YTD BUDGET 14,791.69 TOTAL ACCOUNT ACTIVITY 11,742.28 0.00 ANNUAL REVISED BUDGET 35,500.00 ENDING BALANCE 11,742.28_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525MB 05/25/2021 15 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 510.40 _________________________________ TOTAL PERIOD 01 ACTIVITY 510.40 0.00 02 AP-210622B 06/15/2021 107 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 39.32 06/15/2021 108 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 39.31 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 7TIME: 09:03:30 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 02 AP-210625MB 06/23/2021 66 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 510.40 _________________________________ TOTAL PERIOD 02 ACTIVITY 589.03 0.00 03 AP-2101725M 07/26/2021 124 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 405.00 07/26/2021 125 ARAMARK#610000139707-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 56.65 07/26/2021 126 ARAMARK#610000126829-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21 07/26/2021 127 ARAMARK#610000130040-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21 07/26/2021 128 ARAMARK#610000133317-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21 07/26/2021 129 ARAMARK#610000136522-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21 07/26/2021 130 ARAMARK#610000139702-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21 AP-210713B 07/07/2021 250 05/20/21 MEETING MINUTES MARLYS J. YOUNG 535012 052021 30.00 AP-210727 07/20/2021 152 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 51.16 _________________________________ TOTAL PERIOD 03 ACTIVITY 633.86 0.00 04 AP-210824 08/17/2021 248 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 29.17 08/17/2021 249 05/01-07/31 MANAGED PRINT IMPACT NETWORKING, L 535226 2216307 0.94 AP-210825M 08/19/2021 192 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 90.00 08/19/2021 193 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 510.40 08/19/2021 194 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 510.40 08/19/2021 195 PLAYGROUND GUARDIAN-PARK FIRST NATIONAL BANK 900108 082521-R.HORNER 2,000.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 3,140.91 0.00 05 AP-210914 09/07/2021 196 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 77.68 09/07/2021 197 08/05/21 PARK BOARD MEETING MARLYS J. YOUNG 535349 080521 31.50 AP-210925M 09/20/2021 120 PYSICIANS-RANDOM DOT TESTS FIRST NATIONAL BANK 900109 092521-E.WILLRETT 209.00 09/20/2021 121 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 510.40 _________________________________ TOTAL PERIOD 05 ACTIVITY 828.58 0.00 YTD BUDGET 4,750.00 TOTAL ACCOUNT ACTIVITY 5,702.78 0.00 ANNUAL REVISED BUDGET 11,400.00 ENDING BALANCE 5,702.78_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210525B 05/19/2021 32 UMPIRE JOSLYN T. BULLINGTON 534684 MAY 1 - 11 35.00 05/19/2021 33 UMPIRE JOHN ELENBAAS 534688 050821 70.00 05/19/2021 34 UMPIRE W. THOMAS EVINS 534690 050121 70.00 05/19/2021 35 UMPIRE NOLAN HOOPER 534692 MAY 1 - 11 20.00 05/19/2021 36 UMPIRE STEPHEN IRVING 534694 050621 160.00 05/19/2021 37 UMPIRE JAVIER LASSALLE 534698 050821 70.00 05/19/2021 38 UMPIRE JACOB LIPSCOMB 534699 MAY 1 - 11 55.00 05/19/2021 39 UMPIRE JACK MODAFF 534702 MAY 1 - 11 110.00 05/19/2021 40 UMPIRE ROBERT L. RIETZ JR. 534709 050621 160.00 05/19/2021 41 UMPIRE KATIE STRAZNICAS 534713 050121 70.00 05/19/2021 42 UMPIRE MICHAEL VOITIK 534715 050621 160.00 GJ-210531FE 05/27/2021 19 PR CC Fee - Apr 2021 1,171.01 _________________________________ TOTAL PERIOD 01 ACTIVITY 2,151.01 0.00 02 AP-210608A 06/02/2021 141 UMPIRE ERIC ADAMS 534750 MAY 12-MAY 25 110.00 06/02/2021 142 UMPIRE WILLIAM BLAKE 534753 MAY 12-MAY 25 330.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 8TIME: 09:03:33 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 02 AP-210608A 06/02/2021 143 UMPIRE JOSLYN T. BULLINGTON 534754 MAY 12-MAY 25 130.00 06/02/2021 144 UMPIRE JACKSON BULLINGTON 534755 MAY 12-MAY 25 80.00 06/02/2021 145 UMPIRE JOHN ELENBAAS 534763 051521 70.00 06/02/2021 146 UMPIRE JOHN ELENBAAS 534763 052221 70.00 06/02/2021 147 UMPIRE JORY ELENBAAS 534764 052221 70.00 06/02/2021 148 UMPIRE RYAN EVANS 534766 MAY 12-MAY 25 20.00 06/02/2021 149 UMPIRE W. THOMAS EVINS 534767 051521 70.00 06/02/2021 150 UMPIRE ALLEN R. GOSS 534769 MAY 12-MAY 25 55.00 06/02/2021 151 UMPIRE COLIN GRIFFIN 534770 MAY 12-MAY 25 45.00 06/02/2021 152 UMPIRE NOLAN HOOPER 534773 MAY 12-MAY 25 60.00 06/02/2021 153 UMPIRE STEPHEN IRVING 534777 051321 160.00 06/02/2021 154 UMPIRE STEPHEN IRVING 534777 052021 160.00 06/02/2021 155 UMPIRE GREGORY JOHNSON 534778 MAY 12-MAY 25 55.00 06/02/2021 156 UMPIRE JACOB LIPSCOMB 534783 MAY 12-MAY 25 55.00 06/02/2021 157 UMPIRE GAVIN DANIEL LOHER 534784 MAY 12-MAY 25 155.00 06/02/2021 158 UMPIRE KYLE DEAN MCCURDY 534787 MAY 12-MAY 25 140.00 06/02/2021 159 UMPIRE RYAN MEHOCHKO 534788 MAY12-MAY 25 20.00 06/02/2021 160 UMPIRE JACK MODAFF 534792 MAY 12-MAY 25 220.00 06/02/2021 161 UMPIRE LIAM PHENEY 534796 MAY 12-MAY 25 60.00 06/02/2021 162 UMPIRE JEFF RICHARDSON 534801 MAY 12-MAY 25 55.00 06/02/2021 163 UMPIRE ROBERT L. RIETZ JR. 534802 051321 160.00 06/02/2021 164 UMPIRE ROBERT L. RIETZ JR. 534802 052021 160.00 06/02/2021 165 UMPIRE EDWIN A RUNDLE 534804 MAY 12-MAY 25 55.00 06/02/2021 166 UMPIRE BRYSON SCHMIDT 534805 MAY 12-MAY 25 35.00 06/02/2021 167 CHILD & BABYSITTING SAFETY SECOND CHANCE CARDIA 534806 21-005-355 418.60 06/02/2021 168 UMPIRE JAMES A. TIETZ 534810 MAY 12-MAY 25 55.00 06/02/2021 169 UMPIRE MICHAEL VOITIK 534813 051321 160.00 06/02/2021 170 UMPIRE MICHAEL VOITIK 534813 052021 160.00 06/02/2021 171 UMPIRE MARK RUNYON 2091 MAY 12-MAY 25 110.00 AP-210622B 06/15/2021 118 UMPIRE DAVID BEEBE 534829 MAY 26-JUNE 07 55.00 06/15/2021 119 UMPIRE JOSLYN T. BULLINGTON 534833 MAY 26-JUNE 07 200.00 06/15/2021 120 UMPIRE JACKSON BULLINGTON 534834 MAY 26-JUNE 07 100.00 06/15/2021 121 UMPIRE THOMAS DEES 534839 MAY 26-JUNE 07 110.00 06/15/2021 122 UMPIRE ANDREW GOLINSKI 534848 MAY 26-JUNE 07 35.00 06/15/2021 123 UMPIRE ALLEN R. GOSS 534849 MAY 26-JUNE 07 55.00 06/15/2021 124 UMPIRE COLIN GRIFFIN 534851 MAY 26-JUNE 07 65.00 06/15/2021 125 UMPIRE ETHAN HANSON 534852 MAY 26-JUNE 07 75.00 06/15/2021 126 UMPIRE JACKSON HAWKINSON 534853 MAY 26-JUNE 07 95.00 06/15/2021 127 UMPIRE NOLAN HOOPER 534854 MAY 26-JUNE 07 45.00 06/15/2021 128 UMPIRE STEPHEN IRVING 534858 060321 160.00 06/15/2021 129 UMPIRE JACOB LIPSCOMB 534864 MAY 26-JUNE 07 55.00 06/15/2021 130 UMPIRE GAVIN DANIEL LOHER 534865 MAY 26-JUNE 07 65.00 06/15/2021 131 UMPIRE KYLE DEAN MCCURDY 534869 MAY 26-JUNE 07 175.00 06/15/2021 132 UMPIRE RYAN MEHOCHKO 534870 MAY 26-JUNE 07 90.00 06/15/2021 133 UMPIRE STEVE PEARSON 534877 MAY 26-JUNE 07 55.00 06/15/2021 134 UMPIRE JEFF RICHARDSON 534884 MAY 26-JUNE 07 55.00 06/15/2021 135 UMPIRE ROBERT L. RIETZ JR. 534885 060321 120.00 06/15/2021 136 UMPIRE EMMA ROBERTS 534886 MAY 26-JUNE 07 55.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 9TIME: 09:03:34 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 02 AP-210622B 06/15/2021 137 UMPIRE BRYSON SCHMIDT 534887 MAY 26-JUNE 07 95.00 06/15/2021 138 RECTRAC/WEBTRAC ANNUAL VERMONT SYSTEMS 534897 69991 5,538.00 06/15/2021 139 UMPIRE MICHAEL VOITIK 534898 060321 160.00 06/15/2021 140 UMPIRE MARK RUNYON 2104 MAY 26-JUNE 07 55.00 GJ-210630FE 06/24/2021 19 PR CC Fees - May 2021 1,100.81 _________________________________ TOTAL PERIOD 02 ACTIVITY 12,117.41 0.00 03 AP-2101725M 07/26/2021 159 PLUGNPAY-MAY 2021 BILLING FEE FIRST NATIONAL BANK 900107 072521-S.REDMON 30.00 07/26/2021 160 LOMBARSI COACHING-YOUTH CLASS FIRST NATIONAL BANK 900107 072521-S.REDMON 137.20 07/26/2021 161 CANVA-ANNUAL SUBSCRIPTION FIRST NATIONAL BANK 900107 072521-S.REDMON 99.99 AP-210713B 07/07/2021 276 UMPIRE ERIC ADAMS 534916 JUNE 9-JUNE 26 55.00 07/07/2021 277 UMPIRE WILLIAM BLAKE 534922 JUNE 9-JUNE 26 165.00 07/07/2021 278 UMPIRE TERENCE BOWMAN 534924 062421 160.00 07/07/2021 279 UMPIRE JOSLYN T. BULLINGTON 534926 JUNE 9-JUNE 26 120.00 07/07/2021 280 UMPIRE JACKSON BULLINGTON 534927 JUNE 9-JUNE 26 60.00 07/07/2021 281 UMPIRE RAIUMUNDO FONSECA 534945 JUNE 9-JUNE 26 60.00 07/07/2021 282 UMPIRE ANDREW GOLINSKI 534947 JUNE 9-JUNE 26 105.00 07/07/2021 283 UMPIRE ALLEN R. GOSS 534948 JUNE 9-JUNE 26 165.00 07/07/2021 284 UMPIRE COLIN GRIFFIN 534949 JUNE 9-JUNE 26 25.00 07/07/2021 285 UMPIRE NOLAN HOOPER 534954 JUNE 9-JUNE 26 115.00 07/07/2021 286 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 84.75 07/07/2021 287 UMPIRE STEPHEN IRVING 534961 052721 160.00 07/07/2021 288 UMPIRE STEPHEN IRVING 534961 061021 160.00 07/07/2021 289 UMPIRE STEPHEN IRVING 534961 061721 160.00 07/07/2021 290 UMPIRE STEPHEN IRVING 534961 062421 160.00 07/07/2021 291 UMPIRE HALEY N. KOSIN 534967 JUNE 9-JUNE 26 60.00 07/07/2021 292 UMPIRE JOHN LEPACEK 534968 JUNE 9-JUNE 26 55.00 07/07/2021 293 UMPIRE JACOB LIPSCOMB 534969 JUNE 9-JUNE 26 55.00 07/07/2021 294 UMPIRE GAVIN DANIEL LOHER 534970 JUNE 9-JUNE 26 150.00 07/07/2021 295 UMPIRE MICHAEL F. MARCHETTI 534971 JUNE 9-JUNE 26 55.00 07/07/2021 296 UMPIRE KYLE DEAN MCCURDY 534975 JUNE 9-JUNE 26 280.00 07/07/2021 297 UMPIRE RYAN MEHOCHKO 534976 JUNE 9-JUNE 26 105.00 07/07/2021 298 UMPIRE JACK MODAFF 534982 JUNE 9-JUNE 26 120.00 07/07/2021 299 UMPIRE STEVE PEARSON 534991 JUNE 9-JUNE 26 55.00 07/07/2021 300 UMPIRE LIAM PHENEY 534992 JUNE 9-JUNE 26 40.00 07/07/2021 301 UMPIRE ROBERT L. RIETZ JR. 534997 052721 160.00 07/07/2021 302 UMPIRE ROBERT L. RIETZ JR. 534997 061021 160.00 07/07/2021 303 UMPIRE ROBERT L. RIETZ JR. 534997 061721 160.00 07/07/2021 304 UMPIRE ROBERT L. RIETZ JR. 534997 JUNE 9-JUNE 26 120.00 07/07/2021 305 UMPIRE EMMA ROBERTS 534998 JUNE 9-JUNE 26 110.00 07/07/2021 306 UMPIRE BRYSON SCHMIDT 535000 JUNE 9-JUNE 26 130.00 07/07/2021 307 UMPIRE JAMES A. TIETZ 535003 JUNE 9-JUNE 26 110.00 07/07/2021 308 UMPIRE MICHAEL VOITIK 535007 052721 160.00 07/07/2021 309 UMPIRE MICHAEL VOITIK 535007 061021 160.00 07/07/2021 310 UMPIRE MICHAEL VOITIK 535007 061721 160.00 07/07/2021 311 UMPIRE MICHAEL VOITIK 535007 062421 160.00 07/07/2021 312 05/20/21 MEETING MINUTES MARLYS J. YOUNG 535012 052021 30.00 07/07/2021 313 UMPIRE KAYLA ZUBER 535013 JUNE 9-JUNE 26 65.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 10TIME: 09:03:34 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 03 AP-210713B 07/07/2021 314 UMPIRE SAM GOLINSKI 2116 JUNE 9-JUNE 26 55.00 AP-210727 07/20/2021 171 SOCCER CAMP INSTRUCTION 5 STAR SOCCER CAMPS 535025 7221 1,800.00 07/20/2021 172 UMPIRE ERIC ADAMS 535027 JUNE 27-JULY 14 220.00 07/20/2021 173 SUMMER 2021 CLASS INSTRUCTION ALL STAR SPORTS INST 535028 214010 7,510.00 07/20/2021 174 UMPIRE WILLIAM BLAKE 535034 JUNE 27-JULY 14 275.00 07/20/2021 175 UMPIRE ANTHONY BOULE 535035 JUNE 27-JULY 14 140.00 07/20/2021 176 UMPIRE JOSLYN T. BULLINGTON 535036 JUNE 27-JULY 14 50.00 07/20/2021 177 UMPIRE JACKSON BULLINGTON 535037 JUNE 27-JULY 14 40.00 07/20/2021 178 UMPRE THOMAS DEES 535043 JUNE 27-JULY 14 280.00 07/20/2021 179 UMPIRE ALLEN R. GOSS 535052 JUNE 27-JULY 14 165.00 07/20/2021 180 UMPIRE COLIN GRIFFIN 535053 JUNE 27-JULY 14 60.00 07/20/2021 181 UMPIRE JACKSON HAWKINSON 535056 JUNE 27-JULY 14 120.00 07/20/2021 182 UMPIRE NOLAN HOOPER 535057 JUNE 27-JULY 14 20.00 07/20/2021 183 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 51.16 07/20/2021 184 UMPIRE STEPHEN IRVING 535064 070121 80.00 07/20/2021 185 UMPIRE GREGORY JOHNSON 535066 JUNE 27-JULY 14 60.00 07/20/2021 186 UMPIRE HALEY N. KOSIN 535069 JUNE 27-JULY 14 50.00 07/20/2021 187 UMPIRE JIM KWIATKOWSKI 535070 JUNE 27-JULY 14 55.00 07/20/2021 188 UMPIRE JACOB LIPSCOMB 535071 JUNE 27-JULY 14 110.00 07/20/2021 189 UMPIRE GAVIN DANIEL LOHER 535072 JUNE 27-JULY 14 165.00 07/20/2021 190 UMPIRE KYLE DEAN MCCURDY 535075 JUNE 27-JULY 14 165.00 07/20/2021 191 UMPIRE RYAN MEHOCHKO 535076 JUNE 27-JULY 14 165.00 07/20/2021 192 UMPIRE JACK MODAFF 535080 JUNE 27-JULY 14 55.00 07/20/2021 193 UMPIRE ARBITER RENEWAL CYNTHIA O'LEARY 535082 REC UMPS RENEWAL 264.00 07/20/2021 194 SPING SOCCER REFEREE ASSIGNING CYNTHIA O'LEARY 535083 SOCCER SPRING 2021 125.00 07/20/2021 195 UMPIRE STEVE PEARSON 535086 JUNE 27-JULY 14 165.00 07/20/2021 196 UMPIRE LIAM PHENEY 535087 JUNE 27-JULY 14 95.00 07/20/2021 197 UMPIRE JEFF RICHARDSON 535094 JUNE 27-JULY 14 55.00 07/20/2021 198 UMPIRE ROBERT L. RIETZ JR. 535095 070121 120.00 07/20/2021 199 UMPIRE ROBERT L. RIETZ JR. 535095 JUNE 27-JULY 14 55.00 07/20/2021 200 UMPIRE BRYSON SCHMIDT 535096 JUNE 27-JULY 14 130.00 07/20/2021 201 UMPIRE TIM SIPES 535098 JUNE 27-JULY 14 55.00 07/20/2021 202 UMPIRE MICHAEL VOITIK 535104 070121 80.00 07/20/2021 203 UMPIRE KAYLA ZUBER 535108 JUNE 27-JULY 14 75.00 07/20/2021 204 UMPIRE EMMA ROBERTS 2140 JUNE 27-JULY 14 55.00 GJ-210731FE 07/27/2021 19 PR CC Fees - June 2021 1,673.28 _________________________________ TOTAL PERIOD 03 ACTIVITY 19,320.38 0.00 04 AP-210810 08/04/2021 158 UMPIRE WILLIAM BLAKE 535119 JULY 15-JULY 23 225.00 08/04/2021 159 UMPIRE JOSLYN T. BULLINGTON 535121 JULY 15-JULY 23 10.00 08/04/2021 160 UMPIRE JACKSON BULLINGTON 535122 JULY 15-JULY 23 70.00 08/04/2021 161 UMPIRE NOLAN HOOPER 535139 JULY 15-JULY 23 25.00 08/04/2021 162 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 84.75 08/04/2021 163 UMPIRE JACOB LIPSCOMB 535150 JULY 15-JULY 23 225.00 08/04/2021 164 UMPIRE GAVIN DANIEL LOHER 535151 JULY 15-JULY 23 50.00 08/04/2021 165 UMPIRE RYAN MEHOCHKO 535153 JULY 15-JULY 23 115.00 08/04/2021 166 REFEREE ASSIGNER'S FEE CYNTHIA O'LEARY 535160 YORKVILLE REC 2,300.00 08/04/2021 167 UMPIRE LIAM PHENEY 535163 JULY 15-JULY 23 40.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 11TIME: 09:03:34 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 04 AP-210810 08/04/2021 168 UMPIRE ROBERT L. RIETZ JR. 535168 JULY 15-JULY 23 55.00 08/04/2021 169 UMPIRE BRYSON SCHMIDT 535169 JULY 15-JULY 23 35.00 08/04/2021 170 UMPIRE JAMES A. TIETZ 535174 JULY 15-JULY 23 55.00 AP-210824 08/17/2021 271 UMPIRE JOSLYN T. BULLINGTON 535195 JULY 24-AUG 5 40.00 08/17/2021 272 UMPIRE JACKSON BULLINGTON 535196 JULY 24-AUG 5 20.00 08/17/2021 273 UMPIRE RAIUMUNDO FONSECA 535220 JULY 24-AUG 5 60.00 08/17/2021 274 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 29.17 08/17/2021 275 UMPIRE GREGORY JOHNSON 535228 JULY 24-AUG 5 60.00 08/17/2021 276 UMPIRE EDSON KING JR 535230 051721 35.00 08/17/2021 277 UMPIRE KATIE STRAZNICAS 535255 051721 35.00 08/17/2021 278 UMPIRE MARK RUNYON 2175 JULY 24-AUG 5 60.00 AP-210825M 08/19/2021 230 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 180.00 08/19/2021 231 PLUG & PAY-JUN 2021 BILLING FIRST NATIONAL BANK 900108 082521-S.REDMON 44.77 08/19/2021 232 SMITHEREEN-JUN 2021 PEST FIRST NATIONAL BANK 900108 082521-S.REDMON 67.00 08/19/2021 233 PETITE PALETTE-PAINTING CLASS FIRST NATIONAL BANK 900108 082521-S.REDMON 180.00 GJ-210831FE 08/24/2021 19 PR CC Fees-July 2021 1,935.55 _________________________________ TOTAL PERIOD 04 ACTIVITY 6,036.24 0.00 05 AP-210914 09/07/2021 224 UMPIRE BENNETT ALLEN 535268 JULY 25-AUG 24 40.00 09/07/2021 225 UMPIRE ROBERT FERGUSON 535289 JULY 25-AUG 24 55.00 09/07/2021 226 UMPIRE RAIUMUNDO FONSECA 535291 JULY 25-AUG 24 60.00 09/07/2021 227 UMPIRE NOLAN HOOPER 535298 JULY 25-AUG 24 50.00 09/07/2021 228 BACKGROUND CHECKS ILLINOIS STATE POLIC 535300 073121-4811 1,045.25 09/07/2021 229 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 77.69 09/07/2021 230 UMPIRE STEPHEN IRVING 535306 081221 160.00 09/07/2021 231 UMPIRE STEPHEN IRVING 535306 081921 160.00 09/07/2021 232 UMPIRE GREGORY JOHNSON 535307 JULY 25-AUG 24 165.00 09/07/2021 233 UMPIRE BENJAMIN KOZIAL 535312 JULY 25-AUG 24 70.00 09/07/2021 234 UMPIRE JIM KWIATKOWSKI 535313 JULY 25-AUG 24 55.00 09/07/2021 235 UMPIRE KYLE DEAN MCCURDY 535314 JULY 25-AUG 24 70.00 09/07/2021 236 UMPIRE LIAM PHENEY 535324 JULY 25-AUG 24 40.00 09/07/2021 237 UMPIRE ROBERT L. RIETZ JR. 535333 081221 160.00 09/07/2021 238 UMPIRE ROBERT L. RIETZ JR. 535333 081921 160.00 09/07/2021 239 UMPIRE EDWIN A RUNDLE 535335 JULY 25-AUG 24 110.00 09/07/2021 240 UMPIRE MICHAEL VOITIK 535341 081221 160.00 09/07/2021 241 UMPIRE MICHAEL VOITIK 535341 081921 160.00 09/07/2021 242 UMPIRE ASSIGNING FEE WCSUA 535343 #1 384.00 09/07/2021 243 08/05/21 PARK BOARD MEETING MARLYS J. YOUNG 535349 080521 31.50 09/07/2021 244 UMPIRE EMMA ROBERTS 2198 JULY 25-AUG 24 55.00 09/07/2021 245 UMPIRE MARK RUNYON 2200 JULY 25-AUG 24 115.00 AP-210915VR 09/28/2021 01 UMPIRE :VOID 535395 JIM KWIATKOWSKI AUG 25-SEPT 15 55.00 AP-210925M 09/20/2021 157 PLUG & PAY-JUL 2021 FEES FIRST NATIONAL BANK 900109 092521-S.REDMON 49.95 AP-210928 09/21/2021 223 UMPIRE ERIC ADAMS 535351 AUG 25-SEPT 15 110.00 09/21/2021 224 UMPIRE BENNETT ALLEN 535352 AUG 25-SEPT 15 120.00 09/21/2021 225 SUMMER II CLASS INSTRUCTION ALL STAR SPORTS INST 535353 215018 1,125.00 09/21/2021 226 UMPIRE DAVID BEEBE 535357 AUG 25-SEPT 15 110.00 09/21/2021 227 UMPIRE WILLIAM BLAKE 535358 AUG 25-SEPT 15 165.00 09/21/2021 228 UMPIRE W. THOMAS EVINS 535375 082821 70.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 12TIME: 09:03:34 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 05 AP-210928 09/21/2021 229 UMPIRE ALLEN R. GOSS 535379 AUG 25-SEPT 15 110.00 09/21/2021 230 UMPIRE JACKSON HAWKINSON 535380 AUG 25-SEPT 15 155.00 09/21/2021 231 UMPIRE HAROLD HIX 535382 AUG 25-SEPT 15 110.00 09/21/2021 232 UMPIRE NOLAN HOOPER 535383 AUG 25-SEPT 15 35.00 09/21/2021 233 UMPIRE STEPHEN IRVING 535387 082621 160.00 09/21/2021 234 UMPIRE STEPHEN IRVING 535387 090921 160.00 09/21/2021 235 UMPIRE GREGORY JOHNSON 535389 AUG 25-SEPT 15 110.00 09/21/2021 236 JUN 2021 MAGIC CLASS GARY KANTOR 535390 061721 30.00 09/21/2021 237 UMPIRE EDSON KING JR 535392 091121 70.00 09/21/2021 238 UMPIRE BENJAMIN KOZIAL 535393 AUG 25-SEPT 15 65.00 09/21/2021 239 UMPIRE MATTHEW KRONSBEIN 535394 AUG 25-SEPT 15 110.00 09/21/2021 240 UMPIRE JIM KWIATKOWSKI AUG 25-SEPT 15 55.00 09/21/2021 241 UMPIRE JAVIER LASSALLE 535397 082821 105.00 09/21/2021 242 UMPIRE MATTHEW J. LAWLESS 535398 091121 70.00 09/21/2021 243 UMPIRE JACOB LIPSCOMB 535401 AUG 25-SEPT 15 55.00 09/21/2021 244 UMPIRE MICHAEL F. MARCHETTI 535402 AUG 25-SEPT 15 55.00 09/21/2021 245 UMPIRE KYLE DEAN MCCURDY 535403 AUG 25-SEPT 15 105.00 09/21/2021 246 UMPIRE RYAN MEHOCHKO 535404 AUG 25-SEPT 15 85.00 09/21/2021 247 ASSIGNING FEE FOR OFFICIALS CYNTHIA O'LEARY 535411 SOCCER FALL 2021 200.00 09/21/2021 248 OFFICIAL ASSIGNING FEE CYNTHIA O'LEARY 535411 YORK REC FALL TOURNE 360.00 09/21/2021 249 FALL ASSIGNING FEE FOR CYNTHIA O'LEARY 535411 YORKVILLE REC-FALL 2 800.00 09/21/2021 250 UMPIRE MARK PAWLOWSKI 535413 090921 160.00 09/21/2021 251 UMPIRE STEVE PEARSON 535414 AUG 25-SEPT 15 55.00 09/21/2021 252 UMPIRE LIAM PHENEY 535416 AUG 25-SEPT 15 190.00 09/21/2021 253 UMPIRE ROBERT L. RIETZ JR. 535427 082621 160.00 09/21/2021 254 UMPIRE ROBERT L. RIETZ JR. 535427 090921 160.00 09/21/2021 255 UMPIRE EDWIN A RUNDLE 535428 AUG 25-SEPT 15 55.00 09/21/2021 256 SOCCER TRAINING & DEVELOPMENT SCOT THOMAS ANDERSON 535429 2202-083121 385.00 09/21/2021 257 UMPIRE TIM SIPES 535430 AUG 25-SEPT 15 55.00 09/21/2021 258 UMPIRE JAMES A. TIETZ 535434 AUG 25-SEPT 15 165.00 09/21/2021 259 UMPIRE MICHAEL VOITIK 535436 082621 160.00 09/21/2021 260 UMPIRE MARK RUNYON 2214 AUG 25-SEPT 15 55.00 GJ-210930FE 09/22/2021 19 PR CC Fees - Aug 2021 1,059.75 _________________________________ TOTAL PERIOD 05 ACTIVITY 10,798.14 55.00 YTD BUDGET 58,333.35 TOTAL ACCOUNT ACTIVITY 50,423.18 55.00 ANNUAL REVISED BUDGET 140,000.00 ENDING BALANCE 50,368.18_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 AP-210511B 05/05/2021 44 JUN 2021 COPIER LEASE DLL FINANCIAL SERVIC 534629 72214154 185.00 AP-210525MB 05/25/2021 20 TBS-ANNUAL LICENSE RENEWAL FIRST NATIONAL BANK 900103 052521-S.AUGUSTINE-B 795.00 GJ-21629PRE 06/29/2021 53 Sound Inc-May Srvc Agrrmnt 97.00 06/29/2021 55 Delage-May Copier Lease 185.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,262.00 0.00 02 AP-210614B 06/08/2021 02 JUL 2021 COPIER LEASE DLL FINANCIAL SERVIC 105030 72537061 185.00 06/08/2021 03 NEW BOND OFFICIAL-RENEWAL LIBERTY MUTUAL INSUR 999061264-060121 800.00 06/08/2021 04 BOND RENEWAL LIBERTY MUTUAL INSUR LSF037877-0320335-05 456.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 13TIME: 09:03:42 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 02 AP-210614B 06/08/2021 05 JUN-AUG 2021 TELEPHONE & SOUND INCORPORATED 105034 R173903 291.00 06/08/2021 06 MAY-JUL 2021 ELEVATOR THYSSENKRUPP ELEVATO 105035 3005903516 578.37 06/08/2021 07 ANNUAL LICENSE FEE REWAL & TODAY'S BUSINESS SOL 105036 11859 1,244.00 06/08/2021 08 05/10/21 MEETING MINUTES MARLYS J. YOUNG 105038 051021 114.75 06/08/2021 09 05/17/21 MEETING MIYTES MARLYS J. YOUNG 105038 051721 43.25 06/08/2021 10 05/24/21 MEETING MINUTES MARLYS J. YOUNG 105038 052421 69.50 AP-210615R 06/16/2021 01 BOND RENEWAL LIBERTY MUTUAL INSUR 105039 LSF037877-0320335-05 456.00 AP-210616VD 06/16/2021 01 NEW BOND OFFICIAL-:VOID 105031 LIBERTY MUTUAL INSUR 999061264-060121 800.00 06/16/2021 02 BOND RENEWAL :VOID 105031 LIBERTY MUTUAL INSUR LSF037877-0320335-05 456.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 4,237.87 1,256.00 03 AP-210712 07/07/2021 03 FY22 E-RATE CONSULTING SERVICE E-RATE FUND SERVICES 105042 485 400.00 07/07/2021 04 WEBSITE DESIGN SERVICE - WEBLINX INCORPORATED 105050 30270 1,650.00 07/07/2021 05 ANNUAL FEE FOR WORDPRESS BASE WEBLINX INCORPORATED 105050 30274 200.00 07/07/2021 06 WEBSITE DESIGN CHANGES FEE WEBLINX INCORPORATED 105050 30295 62.50 07/07/2021 07 05/24/21 MEETING MINUTES MARLYS J. YOUNG 105051 052421-2 105.40 07/07/2021 08 06/14/21 MEETING MINUTES MARLYS J. YOUNG 105051 061421 105.40 07/07/2021 09 06/21/21 MEETING MINUTES MARLYS J. YOUNG 105051 062121 78.75 AP-210713B 07/07/2021 320 AUG 2021 COPIER LEASE DLL FINANCIAL SERVIC 534932 72866312 185.00 AP-210727 07/20/2021 243 REFUND FOR 06/14/21 MINUTES MARLYS J. YOUNG 535107 061421-RFND 105.40 07/20/2021 244 06/30/21 MEETING MINUTES MARLYS J. YOUNG 535107 063021 46.25 07/20/2021 245 07/07/21 MEETING MINUTES MARLYS J. YOUNG 535107 070721 39.50 _________________________________ TOTAL PERIOD 03 ACTIVITY 2,872.80 105.40 04 AP-210809 08/03/2021 01 SEPT 2021 COPIER LEASE DLL FINANCIAL SERVIC 105054 73193559 185.00 08/03/2021 02 04/15-07/14 COPIER CHARGES IMPACT NETWORKING, L 105055 2197254 169.62 08/03/2021 03 APR 2021 ONLINE IT SUPPORT LLOYD WARBER 105056 10500 720.00 08/03/2021 04 MAY 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10501 720.00 08/03/2021 05 JUN 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10502 720.00 08/03/2021 06 JUL 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10503 1,080.00 08/03/2021 07 1ST QTR COST FOR FAXES TODAY'S BUSINESS SOL 105062 071221-73 24.48 08/03/2021 08 07/07/21 LIB COMMUNITY MARLYS J. YOUNG 105063 070721-LIB 63.00 08/03/2021 09 07/12/21 MEETING MINUTES MARLYS J. YOUNG 105063 071221 76.75 08/03/2021 10 07/07/21 MEETING MINUTES MARLYS J. YOUNG 105063 07721-LIB REL 63.00 AP-210810 08/04/2021 195 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 28.25 AP-210825M 08/19/2021 266 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 45.00 08/19/2021 267 SMITHEREEN-JULY 2021 PEST FIRST NATIONAL BANK 900108 082521-S.AUGUSTINE 78.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 3,973.10 0.00 05 AP-210913 09/07/2021 06 2021 ANNUAL SPRINKER GREAT LAKES PLUMBING 105067 23972 450.00 09/07/2021 07 AUG 2021 ONSITE IT SUPPORT LLOYD WARBER 105068 10508 750.00 09/07/2021 08 AUG-OCT 2021 ELEVATOR TK ELEVATOR CORPORAT 105072 3006071458 578.37 09/07/2021 09 INSTALL NEW CAR CALL BUTTON TK ELEVATOR CORPORAT 105072 5001549298M1 550.37 09/07/2021 10 ACCESS CONTROL CLOUD UMBRELLA TECHNOLOGIE 105073 1091 960.00 09/07/2021 11 07/19/21 MEETING MINUTES MARLYS J. YOUNG 105074 071921 56.25 09/07/2021 12 08/09/21 MEETING MINUTES MARLYS J. YOUNG 105074 080921 45.50 AP-210914 09/07/2021 261 OCT 2021 COPIER LEASE DLL FINANCIAL SERVIC 535283 73505558 185.00 09/07/2021 262 CREDIT FOR 07/12 MEETING MARLYS J. YOUNG 535349 082121-CR 63.00 DATE: 10/14/2021 UNITED CITY OF YORKVILLE PAGE: 14TIME: 09:03:42 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022 ACTIVITY THROUGH FISCAL PERIOD 05PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 05 AP-210925M 09/20/2021 193 LIBERTY MUTUAL-NEW BUSINESS FIRST NATIONAL BANK 900109 092521-S.AUGUSTINE 800.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 4,375.49 63.00 YTD BUDGET 16,666.69 TOTAL ACCOUNT ACTIVITY 16,721.26 1,424.40 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 15,296.86_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 YTD BUDGET 833.35 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 02 AP-210622B 06/15/2021 181 DOWNTOWN TIF LEGAL MATTERS KATHLEEN FIELD ORR & 2103 16542 330.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 330.00 0.00 YTD BUDGET 2,083.35 TOTAL ACCOUNT ACTIVITY 330.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 330.00_____________________________________________________________________________________________________________________________________________________89-890-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________ 01 05/01/2021 BEGINNING BALANCE 0.00 02 AP-210622B 06/15/2021 183 DOWNTOWN TIF II LEGAL MATTERS KATHLEEN FIELD ORR & 2103 16542 88.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 88.00 0.00 04 AP-210824 08/17/2021 311 DOWNTOWN TIF II MATTERS KATHLEEN FIELD ORR & 2174 16618 55.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 55.00 0.00 YTD BUDGET 2,083.35 TOTAL ACCOUNT ACTIVITY 143.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 143.00 GRAND TOTAL 191,284.53 0.00 TOTAL DIFFERENCE 191,284.53 0.00 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number New Business #2 Tracking Number ADM 2021-39 Treasurer’s Report for September 2021 Administration Committee – October 20, 2021 Majority Approval Rob Fredrickson Finance Name Department (Unaudited) Beginning Fund Balance Sept Revenues YTD Revenues Revenue Budget % of Budget Sept Expenses YTD Expenses Expense Budget % of Budget Projected Ending Fund Balance General Fund01 - General 9,172,352$ 2,833,714$ 10,650,162$ 18,100,270$ 59%1,639,788$ 6,806,456$ 18,100,270$ 38%13,016,058$ Special Revenue Funds15 - Motor Fuel Tax1,243,821 68,670 529,744 1,260,019 42%6,149 491,692 2,435,413 20%1,281,873 79 - Parks and Recreation 73,002 264,482 1,063,296 2,643,058 40% 243,717 1,003,011 2,716,058 37% 133,287 72 - Land Cash 31,131 - 1,329 25,760 5% - - 5,000 0% 32,460 87 - Countryside TIF (1,211,223) 168,913 226,260 260,727 87% 948 53,298 223,397 24% (1,038,261) 88 - Downtown TIF (1,448,929) 37,770 95,915 70,000 137% 3,542 224,125 291,412 77% (1,577,139) 89 - Downtown TIF II (47,869) 32,018 75,298 48,526 0% - 19,448 30,500 64% 7,981 11 - Fox Hill SSA 10,231 6,965 15,888 19,000 84% 1,475 3,836 59,200 6% 22,283 12 - Sunflower SSA (8,409) 9,137 19,754 21,000 94% 1,100 8,764 17,200 51% 2,581 Debt Service Fund42 - Debt Service - 27,556 139,281 329,375 42% - 9,925 329,375 3% 129,356 Capital Project Funds25 - Vehicle & Equipment 1,485,790 28,338 177,537 547,226 32% 16,714 279,440 1,877,998 15% 1,383,888 24 - Buildings & Grounds - 2,874 8,791,708 9,584,249 92% 87,865 2,349,755 9,584,249 25% 6,441,953 23 - City-Wide Capital 119,566 79,659 2,750,194 5,808,072 47% 526,467 703,887 5,545,285 13% 2,165,873 Enterprise Funds *51 - Water3,901,358 100,257 2,010,737 5,061,271 40%244,904 1,346,262 6,081,733 22%4,565,833 *52 - Sewer864,688 72,296 841,130 2,275,602 37%92,654 430,417 2,428,579 18%1,275,401 Library Funds82 - Library Operations638,033 653,471 1,625,410 1,692,702 96%55,969 351,092 1,709,443 21%1,912,351 84 - Library Capital 169,187 9,766 60,257 50,200 120% 5,343 13,003 95,500 14% 216,441 Total Funds14,992,729$ 4,395,886$ 29,073,901$ 47,797,057$ 61%2,926,635$ 14,094,411$ 51,530,612$ 27%29,972,219$ * Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending September 30, 2021Cash BasisAs Treasurer of the United City of Yorkville, I hereby attest, to the best of my knowledge, that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number New Business #3 Tracking Number ADM 2021-40 Website Report for September 2021 Administration Committee – October 20, 2021 Informational None See attached memo. Erin Willrett Administration Name Department Summary Yorkville’s website and social media analytics report for September 2021. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is September 1, 2021 – September 30, 2021. Website Visits: Sept 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 April 2021 May 2021 June 2021 July 2021 Aug 2021 Sept 2021 Unique Visitors 13,121 13,361 11,685 10,221 10,665 10,985 15,434 15,619 16,445 21,824 31,022 26,945 36,752 Returning Visits 4,583 5,504 4,424 3,541 3,640 3,999 5,677 5,618 5,260 7,902 10,418 6,545 8,662 Total Visits 16,249 17,198 14,742 12,649 13,302 13,863 19,861 19,808 20,395 27,988 38,999 31,848 30,154 Visit Times (Averages):  2 minutes 8 seconds average visit duration  2.5 actions (page views, downloads, outlinks and internal site searches) per visit 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 Total Visits Total Visits Memorandum To: Administration Committee From: Erin Willrett, Assistant Administrator CC: Bart Olson, City Administrator Date: October 20, 2021 Subject: Website Report for September 2021 Website Statistics: July 2021 August 2021 September 2021i Top 5 Pages Visited 1. Independence Day Celebration 2. Homepage 3.Facilities 4. Parks and Recreation 5. Refuse Collection 1. Homepage 2. Hometown Days Festival 3.Facilities 4. Online Utility Payments 5. My GovHub Transition Page 1. Hometown Days Festival 2. Homepage 3. Jobs 4. Facilities 5. Online Utility Payments July 2021 August 2021 September 2021ii Top 5 Downloads 1. Independence Day Parade Route 2. Senior Services & Programs 3. Independence Day Road Closure Map 4. Riverfest Parking Map 5. Parks Map and Matrix 1. Hometown Days Schedule 2. Senior Services & Programs 3. Parks Map and Matrix 4. Annual Drinking Water Report 5. Residential Permit Application 1. Hometown Days Schedule 2. Senior Services & Programs 3. Parkway Tree Program 4. Annual Drinking Water Report 5. Administrative Asst Job Description July 2021 August 2021 September 2021 Top 5 Searches 1. Garbage 2. Meter 3. Farmers Market 4. Fireworks 5. Tubing 1. Meter (Request for Meter Reading #2) 2. Jobs (Employment #4) 3. Farmers Market 4. Soccer 5. Garbage 1. Meter 2. Basketball 3. Garbage 4. Request for Meter Reading 5. Water July 2021 August 2021 September 2021 Top 5 Website Referrers 1. Facebook 2. enjoyaurora.com 3. nbcchicago.com 4. abcchicago.com 5. patch.com 1. Facebook 2. americanenglish.com 3. enjoyaurora.com 4. patch.com 5. search.aol.com 1. Facebook 2. enjoyaurora.com 3. americanenglish.com 4. envirobidnet.com 5. search.aol.com City Facebook Data: September 2021 Total Page Followers: 7,063 (an increase of 512 followers from August) Total Page Likes: 6,443 Total Average Reach: 2,232 Highest Viewed Post: “Mark your calendars! October 4th – 8th is Amnesty Week …” (Posted September 25, 2021) Highest Viewed Post Reach: 7,996; 583 Post Clicks; 201 Reactions, Comments & Shares Parks and Recreation Facebook Data: September 2021 Total Page Followers: 4,639 (an increase of 333 followers from August) Total Page Likes: 4,192 Total Average Reach: 795 Highest Viewed Post: “Join the excitement & create a scarecrow!...” (Posted September 8, 2021) Highest Viewed Post Reach: 4,003; 195 Post Clicks; 157 Reactions, Comments & Shares Police Facebook Data: September 2021 Total Page Followers: 6,565 (an increase of 395 followers from August) Total Page Likes: 5,873 Total Average Reach: 4,957 Highest Viewed Post: “We found a K9.…” (Posted September 3, 2021) Highest Viewed Post Reach: 42,434; 1,899 Post Clicks; 1,260 Reactions, Comments & Shares City Twitter Data: September 2021 Total Followers: 1,721 (An increase of 12 followers from August) Total Tweet Impressions: 1,933 Total Profile Visits: 234 Top Tweet (earned 303 Impressions): “City Offices will be closed today…Labor Day…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/459/Hometown-Days-Festival; https://www.yorkville.il.us/; https://www.yorkville.il.us/jobs.aspx; https://www.yorkville.il.us/facilities/featureoverview; https://www.yorkville.il.us/131/Online-Utility-Payments ii https://www.yorkville.il.us/DocumentCenter/View/7892/Hometown-Days-Schedule-2021-FINAL?bidId=; https://www.yorkville.il.us/244/Senior-Services-Programs; https://www.yorkville.il.us/DocumentCenter/View/2236/2021-50-50-Parkway-Tree-Program-Tree-Choices?bidId=; https://www.yorkville.il.us/DocumentCenter/View/6094/2019-Annual-Drinking-Water-Quality-Report- PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/7936/Administrative-Assistant-Job-Description- 09_07_21?bidId= Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number New Business #4 Tracking Number ADM 2021-41 2011 Bond Refinancing Discussion Administration Committee – October 20, 2021 Rob Fredrickson Finance Name Department Summary Review of the process to issue $1 million in additional proceeds (“new money”) in conjunction with the refinancing of the 2011 refunding bonds. Background At the October 12th meeting, staff presented City Council with three different scenarios regarding the refinancing of the 2011 refunding bonds (which were issued in November of 2011 in order to refinance the 2005D and 2008 refunding bonds, which were initially issued to finance construction of the Rob Roy Creek sewer interceptor) as summarized below:  Scenario One – Refinance the 2011 Refunding Bonds Only  Scenario Two – Refinance the 2011 Refunding Bonds + New Money in the Amount of $1 Million  Scenario Three – Refinance the 2011 Refunding Bonds + New Money in the Amount of $2 Million Per the direction provided at that meeting, Council has tentatively chosen to pursue Scenario Two. Exhibit A shows various projected debt service reports related to the refinancing of the 2011 refunding bonds, with the inclusion of an additional $1 million in new money. As shown on page 1, total bond proceeds totaling $5,155,000 would be allocated between the (52) Sewer Fund ($4.145 million to refinance the 2011 bonds) and the (24) Buildings & Grounds Fund ($1.01 million) to finance improvements to the 651 Prairie Point building, less issuance costs. The 2011 bond refunding savings would remain at ~$242,000, as noted on page 6. As noted on the attached timeline (Exhibit B), the first step in the issuance process would be the adoption of the Intent to Issue (i.e., Authorizing) Ordinance by City Council on October 26th, which would establish the maximum amount of principal that could be issued (Exhibit C). At the request of Council, the maximum amount of the additional bond proceeds has been set at $1,050,000; comprised of $1 million in principal and $50,000 for issuance costs. Please note that the City is required to only adopt an intent ordinance for the new money portion of the bonds, since the remaining bond proceeds would be used to refund existing debt. Moreover, the intent ordinance only sets the maximum amount that the bonds could be issued for. Council always reserves the right to issue the bonds for less than that amount, should it choose to do so. In addition to setting the maximum amount of the potential bond issue, the intent to issue ordinance also establishes what activities the City may use the bond proceeds on. In order to give the City as much flexibility as possible, the parameters are fairly extensive. Besides being able to spend the bond proceeds on the renovation of the Prairie Point building, the ordinance also allows for proceeds to be spent on the acquisition or renovation of any building within the City for municipal purposes, and any water, sewer or roadway repair or improvement. Assuming passage of the intent ordinance, Council would then be presented with a second ordinance authorizing a public hearing, which would be conducted at the November 9th meeting. Memorandum To: Administration Committee From: Rob Fredrickson, Finance Director Date: October 14, 2021 Subject: Bonds – Intent Ordinance, Public Hearing & Process Discussion Presuming that both ordinances (Exhibit C & D) are approved by Council on October 26th, the next step would be to publish the Intent Ordinance and the Notice of Public Hearing in a local newspaper, which would be completed by staff later that week. The publication of these documents would also begin the 30-day Backdoor Referendum period, pursuant to the Bond Issuance Notification Act (BINA). After the public hearing (also required by BINA), the remaining tentative schedule for the issuance of the bonds would be as follows:  The 30-day Backdoor Referendum period would culminate during the week of November 29th. In addition, the final preliminary official statement (POS), which describes the terms and features of the bonds, would be disseminated to potential buyers at the end of November.  The bond sale would take place on December 14th, followed by adoption of the bond ordinance by City Council that evening.  Closing would take place in early January 2022; issuance costs would be paid, and the City would receive $1 million in new money bond proceeds to finance improvements. All and all, the issuance process would take roughly 60 days to complete, from approval of the authorizing ordinance through the closing date, assuming the City chooses to begin the process on October 26th. Recommendation This is an informational item for discussion purposes. Unless directed otherwise by the Administration Committee, staff is planning to present these materials at the October 26th meeting for the consideration of City Council. United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Table of Contents Report ISSUE SUMMARY Total Issue Sources And Uses 1 Debt Service Schedule 2 Net Debt Service Schedule 3 Pricing Summary 4 Proof of Bond Yield @ 1.5000368%5 REFUNDING OF 2011 Debt Service Comparison 6 Debt Service Schedule 7 Net Debt Service Schedule 8 Current Refunding Escrow 9 Debt Service To Maturity And To Call 10 NEW MONEY Debt Service Schedule 11 Net Debt Service Schedule 12 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Total Issue Sources And Uses Dated 01/06/2022 | Delivered 01/06/2022 Refunding of 2011 New Money Issue Summary Sources Of Funds Par Amount of Bonds $4,145,000.00 $1,010,000.00 $5,155,000.00 Total Sources $4,145,000.00 $1,010,000.00 $5,155,000.00 Uses Of Funds Costs of Issuance 42,213.87 10,286.13 52,500.00 Deposit to Project Construction Fund - 1,000,000.00 1,000,000.00 Deposit to Current Refunding Fund 4,097,921.10 - 4,097,921.10 Rounding Amount 4,865.03 (286.13)4,578.90 Total Uses $4,145,000.00 $1,010,000.00 $5,155,000.00 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 1 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 37,373.75 37,373.75 - 12/30/2022 1,260,000.00 1.500% 38,662.50 1,298,662.50 1,336,036.25 06/30/2023 - - 29,212.50 29,212.50 - 12/30/2023 1,275,000.00 1.500% 29,212.50 1,304,212.50 1,333,425.00 06/30/2024 - - 19,650.00 19,650.00 - 12/30/2024 1,300,000.00 1.500% 19,650.00 1,319,650.00 1,339,300.00 06/30/2025 - - 9,900.00 9,900.00 - 12/30/2025 1,320,000.00 1.500% 9,900.00 1,329,900.00 1,339,800.00 Total $5,155,000.00 -$193,561.25 $5,348,561.25 - Yield Statistics Bond Year Dollars $12,904.08 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9206652% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.503 Years 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 2 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,260,000.00 1.500% 76,036.25 1,336,036.25 1,336,036.25 12/30/2023 1,275,000.00 1.500% 58,425.00 1,333,425.00 1,333,425.00 12/30/2024 1,300,000.00 1.500% 39,300.00 1,339,300.00 1,339,300.00 12/30/2025 1,320,000.00 1.500% 19,800.00 1,339,800.00 1,339,800.00 Total $5,155,000.00 -$193,561.25 $5,348,561.25 $5,348,561.25 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 3 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Pricing Summary Maturity Type of Bond Coupon Yield Maturity Value Price Dollar Price 12/30/2022 Serial Coupon 1.500% 1.500% 1,260,000.00 100.000% 1,260,000.00 12/30/2023 Serial Coupon 1.500% 1.500% 1,275,000.00 100.000% 1,275,000.00 12/30/2024 Serial Coupon 1.500% 1.500% 1,300,000.00 100.000% 1,300,000.00 12/30/2025 Serial Coupon 1.500% 1.500% 1,320,000.00 100.000% 1,320,000.00 Total ---$5,155,000.00 -$5,155,000.00 Bid Information Par Amount of Bonds $5,155,000.00 Gross Production $5,155,000.00 Bid (100.000%)5,155,000.00 Total Purchase Price $5,155,000.00 Bond Year Dollars $12,904.08 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 4 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Proof of Bond Yield @ 1.5000368% Date Cashflow PV Factor Present Value Cumulative PV 01/06/2022 - 1.0000000x - - 06/30/2022 37,373.75 0.9928029x 37,104.77 37,104.77 12/30/2022 1,298,662.50 0.9854121x 1,279,717.78 1,316,822.54 06/30/2023 29,212.50 0.9780764x 28,572.06 1,345,394.60 12/30/2023 1,304,212.50 0.9707952x 1,266,123.28 2,611,517.88 06/30/2024 19,650.00 0.9635683x 18,934.12 2,630,451.99 12/30/2024 1,319,650.00 0.9563952x 1,262,106.86 3,892,558.86 06/30/2025 9,900.00 0.9492754x 9,397.83 3,901,956.68 12/30/2025 1,329,900.00 0.9422087x 1,253,043.32 5,155,000.00 Total $5,348,561.25 -$5,155,000.00 - Derivation Of Target Amount Par Amount of Bonds $5,155,000.00 Original Issue Proceeds $5,155,000.00 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 5 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Comparison Date Total P+I Net New D/S Old Net D/S Savings 12/30/2022 1,076,138.75 1,076,138.75 1,135,266.00 59,127.25 12/30/2023 1,071,950.00 1,071,950.00 1,134,178.00 62,228.00 12/30/2024 1,076,575.00 1,076,575.00 1,136,378.00 59,803.00 12/30/2025 1,075,900.00 1,075,900.00 1,136,652.00 60,752.00 Total $4,300,563.75 $4,300,563.75 $4,542,474.00 $241,910.25 PV Analysis Summary (Net to Net) Gross PV Debt Service Savings 232,078.32 Net PV Cashflow Savings @ 1.921%(AIC)232,078.32 Contingency or Rounding Amount 4,865.03 Net Present Value Benefit $236,943.35 Net PV Benefit / $4,095,000 Refunded Principal 5.786% Net PV Benefit / $4,145,000 Refunding Principal 5.716% Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 6 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 30,051.25 30,051.25 - 12/30/2022 1,015,000.00 1.500% 31,087.50 1,046,087.50 1,076,138.75 06/30/2023 - - 23,475.00 23,475.00 - 12/30/2023 1,025,000.00 1.500% 23,475.00 1,048,475.00 1,071,950.00 06/30/2024 - - 15,787.50 15,787.50 - 12/30/2024 1,045,000.00 1.500% 15,787.50 1,060,787.50 1,076,575.00 06/30/2025 - - 7,950.00 7,950.00 - 12/30/2025 1,060,000.00 1.500% 7,950.00 1,067,950.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 - Yield Statistics Bond Year Dollars $10,370.92 Average Life 2.502 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9208627% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.502 Years 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 7 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,015,000.00 1.500% 61,138.75 1,076,138.75 1,076,138.75 12/30/2023 1,025,000.00 1.500% 46,950.00 1,071,950.00 1,071,950.00 12/30/2024 1,045,000.00 1.500% 31,575.00 1,076,575.00 1,076,575.00 12/30/2025 1,060,000.00 1.500% 15,900.00 1,075,900.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 $4,300,563.75 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 8 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Current Refunding Escrow Date Rate Receipts Disbursements Cash Balance 01/06/2022 - 4,097,921.10 4,097,921.10 - Total -$4,097,921.10 $4,097,921.10 - Investment Parameters Investment Model [PV, GIC, or Securities]Securities Default investment yield target Unrestricted Cash Deposit 4,097,921.10 Total Cost of Investments $4,097,921.10 Target Cost of Investments at bond yield $4,097,921.10 Yield to Receipt - Yield for Arbitrage Purposes 1.5000368% 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 9 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois Series 2011 - Refunds 2005D Except for 500 in 2011 Blc Review Debt Service To Maturity And To Call Date Refunded Bonds Refunded Interest D/S To Call Principal Coupon Interest Refunded D/S 01/06/2022 4,095,000.00 2,921.10 4,097,921.10 - - - - 06/30/2022 - - - - - 87,633.00 87,633.00 12/30/2022 - - - 960,000.00 4.280% 87,633.00 1,047,633.00 06/30/2023 - - - - - 67,089.00 67,089.00 12/30/2023 - - - 1,000,000.00 4.280% 67,089.00 1,067,089.00 06/30/2024 - - - - - 45,689.00 45,689.00 12/30/2024 - - - 1,045,000.00 4.280% 45,689.00 1,090,689.00 06/30/2025 - - - - - 23,326.00 23,326.00 12/30/2025 - - - 1,090,000.00 4.280% 23,326.00 1,113,326.00 Total $4,095,000.00 $2,921.10 $4,097,921.10 $4,095,000.00 -$447,474.00 $4,542,474.00 Yield Statistics Base date for Avg. Life & Avg. Coupon Calculation 1/06/2022 Average Life 2.536 Years Average Coupon 4.2800000% Weighted Average Maturity (Par Basis) 2.536 Years Weighted Average Maturity (Original Price Basis) 2.536 Years Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 Ser 2011 FINAL | SINGLE PURPOSE | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 10 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $1M New Money Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 7,322.50 7,322.50 - 12/30/2022 245,000.00 1.500% 7,575.00 252,575.00 259,897.50 06/30/2023 - - 5,737.50 5,737.50 - 12/30/2023 250,000.00 1.500% 5,737.50 255,737.50 261,475.00 06/30/2024 - - 3,862.50 3,862.50 - 12/30/2024 255,000.00 1.500% 3,862.50 258,862.50 262,725.00 06/30/2025 - - 1,950.00 1,950.00 - 12/30/2025 260,000.00 1.500% 1,950.00 261,950.00 263,900.00 Total $1,010,000.00 -$37,997.50 $1,047,997.50 - Yield Statistics Bond Year Dollars $2,533.17 Average Life 2.508 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000367% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9198564% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.508 Years 2022 Refunding PRLM $1M n | New Money | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 11 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $1M New Money Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 245,000.00 1.500% 14,897.50 259,897.50 259,897.50 12/30/2023 250,000.00 1.500% 11,475.00 261,475.00 261,475.00 12/30/2024 255,000.00 1.500% 7,725.00 262,725.00 262,725.00 12/30/2025 260,000.00 1.500% 3,900.00 263,900.00 263,900.00 Total $1,010,000.00 -$37,997.50 $1,047,997.50 $1,047,997.50 2022 Refunding PRLM $1M n | New Money | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 12 Speer Financial, Inc. INDEPENDENT MUNICIPAL ADVISORS ESTABLISHED 1954 SUITE 2630 ● 230 WEST MONROE STREET ● CHICAGO, ILLINOIS 60606 ● (312) 346-3700 ● FAX (312) 346-8833 All City Council Events or Actions are Highlighted in BLUE All Publication Events Highlighted in GRAY UNITED CITY OF YORKVILLE, ILLINOIS General Obligation Bonds (Alternate Revenue Source), Series 2021 Preliminary Timetable (September 1, 2021) Task Party Responsible Date Distribute Draft POS Speer Week of October 11 Adoption of Authorizing City October 26 Ordinance Publish Authorizing City Week of October 26 Ordinance and Notice of BINA Hearing Begin 30-Day Backdoor Referendum Period Distribute Rating Package Speer Week of October 11 Comments received on draft All Parties Week of November 1 POS Bond Issue Notification Act City November 9 (BINA) Hearing Rating Call City and Speer Week of November 8 Receive Bond Rating City and Speer Week of November 15 Distribute Bond Bond Counsel Week of November 22 Ordinance Finalize and Print POS Speer November 30 Bond Sale All Parities December 14 Bond Ordinance Adopted City December 14 Bond Closing All Parties January 6 39071136.2 MINUTES of a regular public meeting of the City Council of the United City of Yorkville, Kendall County, Illinois, held in the City Hall, 800 Game Farm Road, Yorkville, Illinois, at 7 o’clock P.M., on the 26th day of October, 2021. The Mayor called the meeting to order and directed the City Clerk to call the roll. Upon the roll being called, John Purcell, the City Mayor, and the following Aldermen were physically present at said location: ________________________________________________ _____________________________ _____________________________________________________________________________. The following Aldermen were allowed by a majority of the Aldermen of the City Council in accordance with and to the extent allowed by rules adopted by the City Council to attend the meeting by video or audio conference: _______________________________________________ ______________________________________________________________________________ No Alderman was not permitted to attend the meeting by video or audio conference. The following Aldermen were absent and did not participate in the meeting in any manner or to any extent whatsoever: ________________________________________________ ______________________________________________________________________________ The Mayor announced that, in view of the need to provide funds for (i) the renovation of the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive; (ii) the acquisition and/or renovation of additional existing buildings located within the City for municipal purposes; and (iii) other capital infrastructure projects within the City including water, sewer and road construction and repairs, the City Council would consider the adoption of an ordinance authorizing the issuance of its general obligation alternate revenue bonds pursuant to Section 15 of the Local Government Debt Reform Act of the State of Illinois, as amended, and the 2 Municipal Code of the State of Illinois, as amended, and directing the publication of a notice setting forth the determination of the City Council to issue such bonds. Whereupon Alderman ____________________ presented and the City Clerk read by title an Ordinance as follows, a copy of which was provided to each Alderman prior to said meeting and to everyone in attendance at said meeting who requested a copy: AN ORDINANCE authorizing the issuance of general obligation alternate revenue bonds of the United City of Yorkville, Kendall County, Illinois in an amount not to exceed $1,050,000 pursuant to Section 15 of the Local Government Debt Reform Act of the State of Illinois, as amended, and the Municipal Code of the State of Illinois, as amended. * * * * * WHEREAS, the United City of Yorkville, Kendall County, Illinois (the “City”), is a duly organized and existing municipality incorporated and existing under the provisions of the laws of the State of Illinois, and is now operating under the provisions of Illinois Municipal Code, as amended, and all laws amendatory thereof and supplementary thereto, including without limitation the Local Government Debt Reform Act of the State of Illinois, as amended (the “Debt Reform Act”); and WHEREAS, the Mayor and the City Council of the City (the “City Council”) have determined that it is advisable, necessary and in the best interests of the public health, safety, welfare and convenience of the City to (i) renovate the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive, (ii) acquire and/or renovate additional existing buildings located within the City for municipal purposes; and (iii) provide for other capital infrastructure projects within the City including water, sewer and road construction and repairs (collectively, the “Project”), all in accordance with the preliminary plans and estimates of costs therefor heretofore presented to the City Council and WHEREAS, the estimated costs of the Project, including, without limitation, legal, financial, bond discount, bond registrar, paying agent and other related banking fees, printing and publication costs and other expenses, does not exceed $1,050,000, but the City does not currently have sufficient funds on hand and lawfully available to pay such costs; and WHEREAS, pursuant to the provisions of the Debt Reform Act, “Alternate Bonds” (as defined therein) may be issued whenever there exists a revenue source for the City; and 2 WHEREAS, the costs of the Project are expected to be paid for from the proceeds of the general obligation alternate revenue bonds which are authorized to be issued pursuant to the Debt Reform Act, subject to the right of backdoor petition for referendum; and WHEREAS, it is necessary and for the best interests of the City that the Project be undertaken, and, in order to finance the cost thereof, it will be necessary for the City to issue its general obligation alternate revenue bonds (the “Alternate Bonds”), which Alternate Bonds shall be in an aggregate amount not to exceed $1,050,000 and be payable from (i) all collections distributed to the City from those taxes imposed by the City pursuant to the Non-Home Rule Municipal Retailers’ Occupation Tax Act and the Non-Home Rule Municipal Service Occupation Tax Act, each as supplemented and amended from time to time, or substitute taxes therefor as provided by the State of Illinois or the City in the future, and (ii) such other funds of the City as may be necessary and on hand from time to time and lawfully available for such purpose (collectively, the “Pledged Revenues”), as authorized to be issued at this time pursuant to the Debt Reform Act; and WHEREAS, as provided in the Debt Reform Act, if the Pledged Revenues are insufficient to pay the principal and interest on the Alternate Bonds, ad valorem property taxes levied upon all taxable property in the City without limitation as to rate or amount are authorized to be extended and collected to pay the principal of and interest on the Alternate Bonds; and WHEREAS, pursuant to and in accordance with the provisions of Section 15 of the Debt Reform Act, the City is authorized to issue its Alternate Bonds in an aggregate principal amount not to exceed $1,050,000 for the purpose of providing funds to pay the costs of the Project; and WHEREAS, before the Alternate Bonds may be issued for said purpose, the Debt Reform Act requires that the City Council must first adopt an Ordinance authorizing the issuance of the 3 Alternate Bonds for said purpose and directing that notice of such authorization be published as provided by law. NOW, THEREFORE, Be It and It Is Hereby Ordained by the City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Incorporation of Preambles. The City Council hereby finds that all of the recitals contained in the preambles to this Ordinance are full, true and correct and does incorporate them into this Ordinance by this reference. Section 2. Determination to Issue Bonds. It is necessary and in the best interests of the public health, safety, welfare and convenience of the City to undertake the Project in accordance with the estimate of costs as hereinabove described, and that for such purpose there are hereby authorized to be issued and sold by the City its Alternate Bonds in an aggregate principal amount not to exceed $1,050,000 (the “Bonds”). The issuance of the Bonds shall be subject to the right of backdoor petition for referendum as set forth herein and the adoption of a bond ordinance setting forth the terms for the issuance and sale of the Bonds. Section 3. Publication. This Ordinance, together with a notice in the statutory form as set forth herein in Section 4 (the “Notice”), shall be published at least once in the Beacon-News, the same being a newspaper of general circulation in the City, and if no petition, signed by not less than 1,052 registered voters of the City (being the number of registered voters equal to the greater of (a) seven and one-half percent (7.5%) of the registered voters of the City, or (b) the lesser of (i) fifteen percent (15%) of the registered voters of the City, or (ii) 200 registered voters), asking that the issuance of the Bonds be submitted to referendum, is filed with the City Clerk within thirty (30) days after the date of the publication of this Ordinance and the Notice, then the Bonds shall be authorized to be issued. If such petition is filed with the City Clerk within thirty (30) days after the date of publication of this Ordinance and the Notice, an election 4 on the proposition to issue the Bonds shall be held on the 28th day of June, 2022 (being the next election held in accordance with the general election law of the State of Illinois). The City Clerk shall make a petition form available to anyone requesting one. Section 4. Form of Notice. The notice of the intention to issue the Bonds shall be in substantially the following form: NOTICE OF INTENT OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS TO ISSUE $1,050,000 ALTERNATE REVENUE BONDS AND RIGHT TO FILE PETITION PUBLIC NOTICE is hereby given that pursuant to an Ordinance (the “Ordinance”) adopted on the 26th day of October, 2021 by the City Council (the “City Council”) of the United City of Yorkville, Kendall County, Illinois (the “City”), the City intends to issue its general obligation alternate revenue bonds in an aggregate amount of not to exceed $1,050,000 (the “Bonds”) for the purpose of providing funds for (i) the renovation of the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive; (ii) the acquisition and/or renovation of additional existing buildings located within the City for municipal purposes; and (iii) other capital infrastructure projects within the City including water, sewer and road construction and repairs. The revenue sources for the payment of the Bonds will be (a) all collections distributed to the City from those taxes imposed by the City pursuant to the Non-Home Rule Municipal Retailers’ Occupation Tax Act and the Non-Home Rule Municipal Service Occupation Tax Act, each as supplemented and amended from time to time, or substitute taxes therefor as provided by the State of Illinois or the City in the future, and (b) such other funds of the City as may be necessary and on hand from time to time and lawfully available for such purpose. If these revenue sources are insufficient to pay the Bonds, the City will also levy ad valorem property taxes upon all taxable property in the City without limitation as to rate or amount to pay the principal of and interest on the Bonds. This notice is incorporated into the Ordinance. Notice is hereby further given that a petition may be filed with the City Clerk (the “City Clerk”) within thirty (30) days after the date of publication of the Ordinance and this notice, signed by not less than 1,052 registered voters of the City (being the number of registered voters equal to the greater of (a) seven and one-half percent (7.5%) of the registered voters of the City, or (b) the lesser of (i) fifteen percent (15%) of the registered voters of the City, or (ii) 200 registered voters) asking that the issuance of the Bonds be submitted to the voters of the City. If such petition is filed with the City Clerk within thirty (30) days after the date of publication of this notice, an election on the proposition to issue the Bonds shall be held on the 28th day of June, 2022. Forms of petitions for such purposes are available to any individual requesting one from the office of the City Clerk. The Circuit Court may declare that an emergency referendum should be held prior to said election date pursuant to the provisions of Section 2A-1.4 of the Election Code of the State of Illinois, as amended. If no such petition is filed within said thirty (30) day period, then the City shall thereafter be authorized to issue the Bonds for the purpose hereinabove provided. By order of the City Council of the United City of Yorkville, Kendall County, Illinois. DATED this 26th day of October, 2021. Note to Publisher: Please be certain that this notice appears over the name of the City Clerk. 2 Jori Behland City Clerk United City of Yorkville, Kendall County, Illinois Section 5. Additional Ordinances. If no petition meeting the requirements of applicable law is filed during the petition period hereinabove referred to, then the City Council may adopt additional ordinances or proceedings supplementing or amending this Ordinance providing for the issuance and sale of the Bonds and prescribing all the details of the Bonds, so long as the maximum amount of the Bonds as set forth in this Ordinance is not exceeded and there is no material change in the Project described herein. Such additional ordinances or proceedings shall in all instances become effective immediately without publication or posting or any further act or requirement. This Ordinance, together with such additional ordinances or proceedings, shall constitute complete authority for the issuance of the Bonds under applicable law. Section 6. Severability. If any section, paragraph, clause or provision of this Ordinance shall be held to be invalid or unenforceable for any reason, the invalidity or unenforceability of such section, paragraph, clause or provision shall not affect any of the remaining provisions of this Ordinance. (This space is intentionally blank) 2 Section 7. Repealer and Effective Date. All Ordinances and parts of Ordinances in conflict herewith be and the same are hereby repealed and that this Ordinance be in full force and effect forthwith upon its adoption. ADOPTED by the City Council on the 26th day of October, 2021, pursuant to a roll call vote as follows: DANIEL V. TRANSIER KEN KOCH MATT MAREK ARDEN JOE PLOCHER CHRIS FUNKHOUSER SEAVER TARULIS JASON PETERSON APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, the 26th day of October, 2021. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, the 26th day of October, 2021. CITY CLERK Alderman _______________________ moved and Alderman ________________________ seconded the motion that said Ordinance as presented and read by title be adopted. After a full and complete discussion thereof, the Mayor directed the City Clerk to call the roll for a vote upon the motion to adopt said Ordinance. Upon the roll being called, the following Aldermen voted AYE: ____________________ _____________________________________________________________________________. The following Aldermen voted NAY: __________________________________________ Whereupon the Mayor declared the motion carried and said Ordinance adopted, and in open meeting approved and signed said Ordinance and directed the City Clerk to record the same in full in the records of the City Council of the United City of Yorkville, Kendall County, Illinois, which was done. Other business not pertinent to the adoption of said Ordinance was duly transacted at said meeting. Upon motion duly made, seconded and carried, the meeting was adjourned. ____________________________________ City Clerk STATE OF ILLINOIS ) ) SS COUNTY OF KENDALL ) CERTIFICATION OF MINUTES AND ORDINANCE I, the undersigned, do hereby certify that I am the duly qualified and acting City Clerk of the United City of Yorkville, Kendall County, Illinois (the “City”), and that as such official I am the keeper of the records and files of the City and of the City Council thereof (the “City Council”). I do further certify that the foregoing constitutes a full, true and complete transcript of the minutes of the meeting of the City Council held on the 26th day of October, 2021, insofar as same relates to the adoption of Ordinance No. entitled: AN ORDINANCE authorizing the issuance of general obligation alternate revenue bonds of the United City of Yorkville, Kendall County, Illinois in an amount not to exceed $1,050,000 pursuant to Section 15 of the Local Government Debt Reform Act of the State of Illinois, as amended, and the Municipal Code of the State of Illinois, as amended. a true, correct and complete copy of which said Ordinance as adopted at said meeting appears in the foregoing transcript of the minutes of said meeting. I do further certify that the deliberations of the City Council on the adoption of said Ordinance were conducted openly, that the vote on the adoption of said Ordinance was taken openly, that said meeting was held at a specified time and place convenient to the public, that notice of said meeting was duly given to all of the news media requesting such notice, that an agenda for said meeting was posted at the location where said meeting was held and at the principal office of the City Council at least 96 hours in advance of the holding of said meeting and on a day that was not a Saturday, Sunday or legal holiday in the State of Illinois, that a true, correct and complete copy of said agenda as so posted is attached hereto as Exhibit A, that said meeting was called and held in strict compliance with the provisions of the Public Code of the State of Illinois, as amended, the Open Meetings Act of the State of Illinois, as amended, and the Local Government Debt Reform Act of the State of Illinois, as amended, and that the City Council has complied with all of the provisions of said Acts and with all of the procedural rules of the City Council in the conduct of said meeting and in the adoption of said Ordinance. IN WITNESS WHEREOF, I hereunto affix my official signature, this 26th day of October, 2021. (SEAL) City Clerk, United City of Yorkville, Kendall County, Illinois [Attach Agenda as Exhibit A] STATE OF ILLINOIS ) ) SS COUNTY OF KENDALL ) PETITION – ALTERNATE REVENUE BONDS We, the undersigned, do hereby certify that we are registered voters of United City of Yorkville, Kendall County, Illinois, and as such voters, we do hereby petition you to cause that the following question be submitted to the voters of said City: “Shall the City Council of United City of Yorkville, Kendall County, Illinois, be authorized to issue not to exceed $1,050,000 general obligation alternate revenue bonds to provide funds for (i) the renovation of the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive; (ii) the acquisition and/or renovation of additional existing buildings located within the City for municipal purposes; and (iii) other capital infrastructure projects within the City including water, sewer and road construction and repairs, as provided for by the Ordinance adopted by the City Council of said City on the 26th day of October, 2021, with the revenue sources to be used to pay the principal of and interest on said bonds to be (a) all collections distributed to the City from those taxes imposed by the City pursuant to the Non-Home Rule Municipal Retailers’ Occupation Tax Act and the Non-Home Rule Municipal Service Occupation Tax Act, each as supplemented and amended from time to time, or substitute taxes therefor as provided by the State of Illinois or the City in the future, and (b) such other funds of the City as may be necessary and on hand from time to time and lawfully available for such purpose, unless said revenue sources are insufficient to pay said bonds, in which case ad valorem property taxes levied upon all taxable property in said City without limitation as to rate or amount are authorized to be extended for such purpose?”; and we do hereby further request that the City Clerk certify said proposition to the County Clerk of The County of Kendall, Illinois, for submission to said City voters at the election to be held on the 28th day of June, 2022: CITY, STREET ADDRESS OR CITY SIGNATURE RURAL ROUTE NUMBER OR TOWN COUNTY ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois ___________________ ____________________, Yorkville, Kendall County, Illinois The undersigned, being first duly sworn, deposes and certifies that he or she is at least 18 years of age, his or her residence address is (Street Address), _________________________ (Village, City or Town), _________________ County, _____________ (State), that he or she is a citizen of the United States of America, that the signatures on the foregoing petition were signed in his or her presence and are genuine, that to the best of his or her knowledge and belief the persons so signing were at the time of signing said petition registered voters of said City and that their respective residences are correctly stated therein. _________________________________ Signed and sworn to before me this _____ day of ____________, 2021. ___________________________________ Illinois Notary Public My commission expires _______________ (NOTARY SEAL) STATE OF ILLINOIS ) ) SS COUNTY OF KENDALL ) NO PETITION CERTIFICATE I, the undersigned, do hereby certify that I am the duly qualified and acting City Clerk of the United City of Yorkville, Kendall County, Illinois (the “City”), and as such official I do further certify that pursuant to an Ordinance entitled: AN ORDINANCE authorizing the issuance of general obligation alternate revenue bonds of the United City of Yorkville, Kendall County, Illinois in an amount not to exceed $1,050,000 pursuant to Section 15 of the Local Government Debt Reform Act of the State of Illinois, as amended, and the Municipal Code of the State of Illinois, as amended, duly adopted by the City Council of the City (the “City Council”) on the 26th day of October, 2021, notice of authorization of the City to issue $1,050,000 Alternate Revenue Bonds was published on the day of October, 2021, in the Beacon-News, the same being a newspaper of general circulation in the City, and was not posted electronically on the City’s World Wide Web pages. I do further certify that no petition has ever been filed in my office as City Clerk or has ever been presented to me as such official requesting that the proposition to issue said bonds be submitted to the voters of the City, but that I provided a petition form regarding the same to every individual requesting one. IN WITNESS WHEREOF, I hereunto affix my official signature, this ____ day of ___________, 2021. __________________________________ City Clerk ORDINANCE calling a public hearing concerning the intent of the City Council of the United City of Yorkville, Kendall County, Illinois, to sell not to exceed $1,050,000 General Obligation Alternate Revenue Bonds. * * * WHEREAS, the United City of Yorkville, Kendall County, Illinois (the “City”), is a duly organized and existing municipality incorporated and existing under the provisions of the laws of the State of Illinois, and is now operating under the provisions of Illinois Municipal Code, as amended, and all laws amendatory thereof and supplementary thereto, including the Local Government Debt Reform Act of the State of Illinois, as amended (the “Debt Reform Act”); and WHEREAS, the City Council of the City (the “City Council”) intends to sell bonds in the amount of not to exceed $1,050,000 (the “Bonds”) for the purpose of providing funds for (i) the renovation of the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive; (ii) the acquisition and/or renovation of additional existing buildings located within the City for municipal purposes; and (iii) other capital infrastructure projects within the City including water, sewer and road construction and repairs; and WHEREAS, the Bond Issue Notification Act of the State of Illinois, as amended, requires the City Council to hold a public hearing concerning the City Council’s intent to sell the Bonds before adopting an ordinance providing for the sale of the Bonds: NOW, THEREFORE, Be It and It Is Hereby Ordained by the City Council of the United City of Yorkville, Kendall County, Illinois, as follows: 1. Incorporation of Preambles. The City Council hereby finds that all of the recitals contained in the preambles to this Ordinance are full, true and correct and does incorporate them into this Ordinance by reference. 2. Public Hearing. The City Council hereby calls a public hearing to be held at 7:00 o’clock P.M. on the 9th day of November, 2021, in the City Hall, 800 Game Farm Road, -2- Yorkville, Illinois, concerning the City Council’s intent to sell the Bonds and to receive public comments regarding the proposal to sell the Bonds (the “Hearing”). 3. Notice. The City Clerk (the “City Clerk”) shall (i) publish notice of the Hearing at least once in the Beacon-News, the same being a newspaper of general circulation in the City, not less than seven (7) nor more than thirty (30) days before the date of the Hearing and (ii) post at least 48 hours before the Hearing a copy of said notice at the principal office of the City Council. 4. Form of Notice. Notice of the Hearing shall appear above the name of the City Clerk and shall be in substantially the following form: -3- NOTICE OF PUBLIC HEARING CONCERNING THE INTENT OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS TO SELL NOT TO EXCEED $1,050,000,000 GENERAL OBLIGATION ALTERNATE REVENUE BONDS PUBLIC NOTICE IS HEREBY GIVEN that the United City of Yorkville, KendallCounty, Illinois (the “City”), will hold a public hearing on the 9th day of November, 2021, at 7:00 o’clock P.M. The hearing will be held in the City Hall, 800 Game Farm Road, Yorkville, Illinois. The purpose of the hearing will be to receive public comments on the proposal to sell general obligation alternate revenue bonds of the City in the amount of not to exceed $1,050,000 for the purpose of providing funds for (i) the renovation of the new Yorkville City Hall and Police Station at 651 Prairie Pointe Drive; (ii) the acquisition and/or renovation of additional existing buildings located within the City for municipal purposes; and (iii) other capital infrastructure projects within the City including water, sewer and road construction and repairs. In accordance with Public Act 101-0640 and Gubernatorial Disaster Proclamation issued by Governor Pritzker pursuant to the powers vested in the Governor under the Illinois Emergency Management Agency Act, the City is encouraging social distancing by allowing remote attendance to the public hearing. Public comments on such proposal may be emailed to jbehland@yorkville.il.us. The City publishes a remote participation meeting link for every City meeting at https://www.yorkville.il.us/520/Agendas‐Minutes‐Packets. Each meeting generally has a phone number for audio call‐in, or a video meeting link. Residents who attend the meeting via phone or computer through the methods above, may speak during the public hearing. By order of the City Council of the United City of Yorkville, Kendall County, Illinois. DATED the 26th day of October, 2021. Jori Behland City Clerk United City of Yorkville, Kendall County, Illinois Note to Publisher: Please be certain that this notice appears above the name of the City Clerk. -4- 5. Hearing Requirements. At the Hearing, the City Council shall explain the reasons for the proposed bond issue and permit persons desiring to be heard an opportunity to present written or oral testimony within reasonable time limits. The City Council shall not adopt an ordinance selling the Bonds for a period of seven (7) days after the final adjournment of the Hearing. 6. Severability. If any section, paragraph, clause or provision of this Ordinance shall be held to be invalid or unenforceable for any reason, the invalidity or unenforceability of such section, paragraph, clause or provision shall not affect any of the remaining provisions of this Ordinance. (This space is intentionally blank) -5- 7. Repeal. All Ordinances and parts thereof in conflict herewith be and the same are hereby repealed, and this Ordinance shall be in full force and effect forthwith upon its adoption. ADOPTED by the City Council on the 26th day of October, 2021, pursuant to a roll call vote as follows: DANIEL V. TRANSIER KEN KOCH MATT MAREK ARDEN JOE PLOCHER CHRIS FUNKHOUSER SEAVER TARULIS JASON PETERSON APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, the 26th day of October, 2021. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, the 26th day of October, 2021. CITY CLERK Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #5 Tracking Number ADM 2021-42 Meeting Schedule for 2022 Administration Committee – October 20, 2021 Majority Approval Proposed meeting schedule for 2022. Jori Behland Administration Name Department Summary Proposed 2022 meeting schedule for the Administration Committee. Meeting Schedule for 2022 Listed below are the proposed meeting dates for the Administration Committee meeting for 2022. The proposed schedule has the committee continuing to meet on the third Wednesday of the month at 6:00 p.m.  January 19, 2022  February 16, 2022  March 16, 2022  April 20, 2022  May 18, 2022  June 15, 2022  July 20, 2022  August 17, 2022  September 21, 2022  October 19, 2022  November 16, 2022  December 21, 2022 Recommendation Staff recommends review of the proposed meeting dates and time so that a meeting schedule can be finalized for 2022. Memorandum To: Administration Committee From: Jori Behland, City Clerk CC: Bart Olson, City Administrator Date: October 20, 2021 Subject: Administration Committee Meeting Schedule for 2022 Su M Tu W Th F Sa Su M Tu W Th F Sa Su M Tu W Th F Sa 1 12345 12345 2 34567867 8 9 10 11 12 6 7 8 9 10 11 12 9 10 11 12 13 14 15 13 14 15 16 17 18 19 13 14 15 16 17 18 19 16 17 18 19 20 21 22 20 21 22 23 24 25 26 20 21 22 23 24 25 26 23 24 25 26 27 28 29 27 28 27 28 29 30 31 30 31 Su M Tu W Th F Sa Su M Tu W Th F Sa Su M Tu W Th F Sa 1 21234567 1234 3 45678989 1011121314 5 67891011 10 11 12 13 14 15 16 15 16 17 18 19 20 21 12 13 14 15 16 17 18 17 18 19 20 21 22 23 22 23 24 25 26 27 28 19 20 21 22 23 24 25 24 25 26 27 28 29 30 29 30 31 26 27 28 29 30 Su M Tu W Th F Sa Su M Tu W Th F Sa Su M Tu W Th F Sa 1 2 123456 123 3 45678978 9 10 11 12 13 4 5678910 10 11 12 13 14 15 16 14 15 16 17 18 19 20 11 12 13 14 15 16 17 17 18 19 20 21 22 23 21 22 23 24 25 26 27 18 19 20 21 22 23 24 24 25 26 27 28 29 30 28 29 30 31 25 26 27 28 29 30 31 Su M Tu W Th F Sa Su M Tu W Th F Sa Su M Tu W Th F Sa 1 12345 123 2 34567867 8 9 10 11 12 4 5678910 9 10 11 12 13 14 15 13 14 15 16 17 18 19 11 12 13 14 15 16 17 16 17 18 19 20 21 22 20 21 22 23 24 25 26 18 19 20 21 22 23 24 23 24 25 26 27 28 29 27 28 29 30 25 26 27 28 29 30 31 30 31 January February September 2022 October November December July August April May June March Printable Yearly Calendar © 2018 by Vertex42.com. Free to Print. https://www.vertex42.com/calendars/printable-calendars.html