The URL can be used to link to this page

Administration Committee Packet 2021 12-15-21 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, December 15, 2021 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: November 17, 2021 New Business: 1. ADM 2021-53 Budget Report for November 2021 2. ADM 2021-54 Treasurer’s Report for November 2021 3. ADM 2021-55 Cash Statement for September 2021 4. ADM 2021-56 Website Report for November 2021 5. ADM 2021-57 Sales Tax Performance and Budget Projections 6. ADM 2021-58 Minute Taker Review 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, December 15, 2021 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. November 17, 2021 □ Approved __________ □ As presented □ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2021-53 Budget Report for November 2021 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2021-54 Treasurer’s Report for November 2021 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2021-55 Cash Statement for September 2021 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2021-56 Website Report for November 2021 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2021-57 Sales Tax Performance and Budget Projections □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2021-58 Minute Taker Review □ 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 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 Minutes Tracking Number Minutes of the Administration Committee – November 17, 2021 Administration Committee – December 15, 2021 Majority Committee Approval Minute Taker Name Department DRAFT Page 1 of 4 UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Wednesday, November 17, 2021 6:00pm City Council Chambers 800 Game Farm Rd., 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 ongoing Covid-19 pandemic. All attendees were in person unless otherwise noted. Committee Members In Attendance: Vice-Chairman Chris Funkhouser Alderman Seaver Tarulis Alderman Dan Transier Other City Officials In Attendance: City Administrator Bart Olson Assistant City Administrator Erin Willrett Others in Attendance: Mike Alesia, Insurance Broker/Alliant Insurance Services (via Zoom) The meeting was called to order at 6:00pm by Vice-Chairman Chris Funkhouser and he announced those who were present. He asked to amend the agenda and move item #6 forward. Citizen Comments: None Minutes for Correction/Approval: October 20, 2021 The minutes were approved as presented. New Business: 6. ADM 2021-48 Liability Insurance Renewal (out of sequence) Mr. Olson explained the insurance renewal and said Finance Director Fredrickson had provided a memo which gives an overview of the quote. He said each year the city determines if they should remain with the existing carrier or explore other companies. In the past year, the city has had a couple claims, but they will roll off next year. Mr. Alesia recommended that the city not go out to full bid this year based on those claims and market instability. Due to the large claim, other companies would decline coverage this year. Mr. Alesia said the market is not optimal this year and the current company is basically holding the same costs. Glatfelter has been the city's property/casualty Page 2 of 4 insurance carrier for about the last 10 years. He said $1 million is carried for cyber liability protection. He said cyber protection is difficult now due to many breaches. He said clients must have 4 protocols against hacking in order for him to obtain quotes for coverage. They are: encryption, MFA (multi factor authenticating), vulnerability testing and employee training. Three of those are in process and will be completed by January. When complete, the quote will be revisited and prices will likely double. Mr. Alesia added that Yorkville is a model community with minimal losses. He said the overall price increases this year are a little over 8%, below the normal 10-20% in other towns. Mr. Olson explained the MFA further and said it is a standard requirement for coverage. He also informed the committee about the street sweeper that caught fire, the salvage value and replacement cost. Mr. Alesia was instrumental in advocating the claim. This matter will come before the Administration Committee soon to consider a new sweeper purchase. The street sweeper component would be removed on the old machine so it can be used as a truck. Mr. Funkhouser noted that KenCom is moving through the cyber issues as well and asked the city to insure they stay current with this subject. Alderman Transier asked if there is a plan for budgeting the increase or if it will be dealt with as it comes up. Mr. Olson said the increase will be easily absorbed in the budget. This moves forward to the City Council Administration agenda. 1. ADM 2021-43 Budget Report for October 2021 Mr. Olson said the sales tax performance is 10-30% above the 2020 figures which were also above normal. He said in December there could be discussion on performance estimates and Alderman Funkhouser added he would like a conversation on capital. 2. ADM 2021-44 Treasurer's Report for October 2021 Mr. Olson referred to the reports which will move forward to the consent agenda. Beginning Fund Balance: $14,992,729 YTD Revenue: $32,670,299 YTD Expenses $16,642,167 Projected Ending Fund Balance: $31,020,861 3. ADM 2021-45 Cash Statement for August 2021 These reports are for information. 4. ADM 2021-46 Website Report for October 2021 The high numbers on the website are decreasing at year's end, however, there are several views on the website and social media due to current and upcoming events. 5. ADM 2021-47 Auditor RFP Mr. Olson said the auditor contract will expire soon and the city will go out for bids. The city has had 2 five-year terms with Lauterbach and Amen, LLP and they will be allowed Page 3 of 4 to bid as well. This is for information and the RFP is basically the same as 5 years ago. This moves to City Council on the regular Administration agenda. 7. ADM 2021-49 Bond Abatement Ordinances Mr. Olson said as long as revenue is received, there are no increases to the tax rolls. As a result, there will be total abatement of these eight ordinances. 8. ADM 2021-50 Special Service Area Abatement Ordinances These ordinances have a maximum tax that can be levied and staff must abate a portion of them yearly depending on the amount of money needed. The chart compiled by Mr. Fredrickson provides a summary of what will appear on the property taxes. The increases this year are inflationary and calculations are done by the SSA administrators. Interest rates are lower at this time so the amount residents must pay has gone up slightly. This moves to the City Council Administration agenda. 9. ADM 2021-51 Ordinance for the Amended Levy and Assessment of Taxes for....Special Service Area Number 2004-201 (Fox Hill) Mr. Olson said the same maintenance plan will be in place this year and the maintenance package will be bid when the contract expires. The city is proposing a levy of $97.29 per home this year. The county had mis-entered figures in a report resulting in lost revenue of $2,600 last year. This moves to the Administration agenda for the City Council meeting. 10. ADM 2021- 52 Ordinance for the Amended Levy and Assessment of Taxes for..... Special Service Area Number 2006-119 (Sunflower Estates) There is no change to the maintenance agreement and the levy increases to $179.49 due to the pond maintenance needed here. Mr. Olson noted there is a small amount of $8,400 left to pay. The Fund Balances for Sunflower and Fox Hill are both being built up to pay for maintenance. This moves to the Administration agenda for City Council. Old Business: 1. ADM 2021-41 2011 Bond Refinancing Discussion This is a continuation of the discussion being held at City Council. Nothing has changed in the bond ordinance and this moves to the December City Council for approval. Mr. Olson said one individual objected to the Public Hearing notice but attorneys were contacted and the objection resolved. For information. Additional Business: Alderman Transier asked if the city has explored the infrastructure funds the government has and Mr. Olson replied that state and federal lobbyists are monitoring the situation. He hopes that more new federal money might be allotted and low-interest loans may be available for the water project. Alderman Funkhouser asked to look at the budget item “Professional Services and Subscriptions”. He said the city has transitioned from purchasing software to monthly subscriptions. He added that some items in that line item may not be professional services and he wants to insure the city is keeping up with budgeting trends. He also wants to monitor the re-districting in the state. Page 4 of 4 Mr. Transier asked if there will be a replacement soon for former Alderwoman Milschewski. A new Council member will be appointed for the next Council meeting, said Mr. Olson. There was a brief discussion regarding the present Aldermen reaching out to the appointee and the necessary Council confirmation process. There was no further business and the meeting adjourned at 6:41pm. Respectfully transcribed by Marlys Young, Minute Taker 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-53 Budget Report for November 2021 Administration Committee – December 15, 2021 Informational None Monthly budget report and income statement. Rob Fredrickson Finance Name Department % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetGENERAL FUND REVENUESTaxes01-000-40-00-4000 PROPERTY TAXES 98,145 987,686 30,162 81,453 841,468 31,392 14,645 2,084,951 2,091,475 99.69%01-000-40-00-4010PROPERTY TAXES-POLICE PENSION62,631 630,291 19,248 51,979 536,982 20,033 9,346 1,330,510 1,334,771 99.68%01-000-40-00-4030 MUNICIPAL SALES TAX 258,698 389,717 353,904 409,710 401,970 363,298 356,893 2,534,191 3,582,508 70.74%01-000-40-00-4035 NON-HOME RULE SALES TAX 195,140 299,299 283,575 306,463 317,410 292,581 288,924 1,983,392 2,649,473 74.86%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 15,429 14,711 131,960 270,000 48.87%01-000-40-00-4043 EXCISE TAX 17,210 17,577 16,333 16,969 17,463 17,979 16,829 120,360 209,000 57.59%01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 695 695 695 695 695 4,865 8,340 58.33%01-000-40-00-4045 CABLE FRANCHISE FEES 66,083 - 7,870 66,926 - 7,316 66,594 214,789 300,000 71.60%01-000-40-00-4050 HOTEL TAX 3,764 22,511 5,647 7,909 7,683 27,812 6,412 81,738 80,000 102.17%01-000-40-00-4055 VIDEO GAMING TAX 19,200 19,886 19,246 19,914 18,711 19,377 18,046 134,380 140,000 95.99%01-000-40-00-4060 AMUSEMENT TAX 1,326 996 42,268 2,429 20,099 32,307 74,478 173,904 125,000 139.12%01-000-40-00-4065 ADMISSIONS TAX- - - - - 148,662 - 148,662 145,000 102.53%01-000-40-00-4070BDD TAX - KENDALL MARKETPLACE24,419 38,802 36,147 40,129 44,783 34,852 33,510 252,642 379,950 66.49%01-000-40-00-4071 BDD TAX - DOWNTOWN 2,835 5,503 3,781 4,395 3,811 4,101 1,487 25,913 30,000 86.38%01-000-40-00-4072 BDD TAX - COUNTRYSIDE 2,307 2,772 2,834 3,053 3,340 6,073 5,944 26,324 12,000 219.36%01-000-40-00-4075 AUTO RENTAL TAX 1,273 1,477 1,506 1,325 1,827 1,765 1,569 10,742 16,500 65.10%Intergovernmental01-000-41-00-4100 STATE INCOME TAX 320,085 280,842 251,940 141,468 149,398 271,492 155,634 1,570,860 2,336,774 67.22%01-000-41-00-4105 LOCAL USE TAX 49,471 63,245 57,461 52,889 60,281 56,138 59,258 398,742 937,660 42.53%01-000-41-00-4106 CANNABIS EXCISE TAX 2,179 2,529 2,229 1,989 2,366 2,814 2,463 16,569 19,596 84.56%01-000-41-00-4110 ROAD & BRIDGE TAX 3,175 26,433 874 1,887 21,034 1,007 461 54,872 54,975 99.81%01-000-41-00-4120 PERSONAL PROPERTY TAX 6,292 - 4,585 583 - 7,639 - 19,098 16,500 115.74%01-000-41-00-4160 FEDERAL GRANTS 200,000 5,682 7,516 - - - 4,796 217,994 15,275 1427.13%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 1,000 200 6,864 65,000 10.56%01-000-42-00-4205 OTHER LICENSES & PERMITS 936 1,662 150 149 - 1,091 - 3,988 9,500 41.98%01-000-42-00-4210 BUILDING PERMITS 81,647 85,423 80,985 127,927 79,497 90,835 76,006 622,321 450,000 138.29%Fines & Forfeits01-000-43-00-4310 CIRCUIT COURT FINES 2,743 1,825 4,994 3,824 5,190 2,384 3,948 24,907 35,000 71.16%01-000-43-00-4320ADMINISTRATIVE ADJUDICATION1,354 2,139 1,214 2,746 1,243 1,210 2,750 12,656 26,500 47.76%01-000-43-00-4323 OFFENDER REGISTRATION FEES 115 - - 35 70 105 35 360 350 102.86%01-000-43-00-4325 POLICE TOWS 4,000 5,000 3,000 5,500 9,500 3,500 7,500 38,000 55,000 69.09%UNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 20211 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021Charges for Service01-000-44-00-4400 GARBAGE SURCHARGE 244 238,580 358 240,802 362 242,939 113 723,397 1,376,063 52.57%01-000-44-00-4405 UB COLLECTION FEES 13,327 12,756 - 16,871 17,252 27,080 15,771 103,057 165,000 62.46%01-000-44-00-4407 LATE PENALTIES - GARBAGE 11 4,587 18 5,083 6 4,636 6 14,347 21,000 68.32%01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 18,213 18,213 18,213 18,213 18,213 18,213 18,213 127,493 218,560 58.33%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 514 537 2,935 20,000 14.68%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 1,107 15,057 22,476 12,000 187.30%Miscellaneous01-000-48-00-4820RENTAL INCOME500 - 760 500 630 500 500 3,390 7,000 48.43%01-000-48-00-4850 MISCELLANEOUS INCOME3,873 18,135 3,000 3,050 3,002 3,954 3,000 38,014 88,000 43.20%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,675,600 2,833,714 1,761,831 1,276,332 13,687,325 18,100,270 75.62%ADMINISTRATION EXPENDITURESSalaries & Wages01-110-50-00-5001 SALARIES - MAYOR 825 825 825 825 825 825 825 5,775 10,000 57.75%01-110-50-00-5002 SALARIES - LIQUOR COMM 83 83 83 83 83 83 83 583 1,000 58.34%01-110-50-00-5005 SALARIES - ALDERMAN 3,900 4,400 3,800 3,900 4,000 3,900 3,400 27,300 48,000 56.88%01-110-50-00-5010 SALARIES - ADMINISTRATION 43,952 40,852 49,900 29,487 33,032 45,344 31,762 274,330 567,473 48.34%01-110-50-00-5015 PART-TIME SALARIES - - - - 1,029 1,488 684 3,201 - 0.00%Benefits01-110-52-00-5212RETIREMENT PLAN CONTRIBUTION4,891 4,555 3,812 3,284 3,670 5,054 3,545 28,812 59,061 48.78%01-110-52-00-5214 FICA CONTRIBUTION 3,634 3,468 2,925 2,584 2,936 2,658 1,944 20,148 44,356 45.42%01-110-52-00-5216 GROUP HEALTH INSURANCE 14,193 11,171 4,995 108 2,781 3,633 3,375 40,256 88,445 45.52%01-110-52-00-5222 GROUP LIFE INSURANCE (110) 285 (51) 204 (51) 36 41 354 687 51.56%01-110-52-00-5223 GROUP DENTAL INSURANCE - 1,496 499 238 412 480 480 3,604 7,454 48.35%01-110-52-00-5224 VISION INSURANCE 94 94 - 205 - 62 72 527 1,130 46.63%Contractual Services01-110-54-00-5412 TRAINING & CONFERENCES - - 429 930 - 50 50 1,459 17,000 8.58%01-110-54-00-5424COMPUTER REPLACEMENT CHRGBCK- - - - - - - - 3,336 0.00%01-110-54-00-5415 TRAVEL & LODGING - - - 2,091 48 (412) - 1,727 10,000 17.27%01-110-54-00-5426 PUBLISHING & ADVERTISING - - 170 - - - 107 277 5,000 5.54%01-110-54-00-5430 PRINTING & DUPLICATION - 84 80 67 53 78 64 426 3,250 13.11%01-110-54-00-5440 TELECOMMUNICATIONS - 3,008 2,476 4,502 300 4,976 299 15,560 22,300 69.78%2 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-110-54-00-5448 FILING FEES- - - - - - - - 500 0.00%01-110-54-00-5451 CODIFICATION- 1,242 - - - 50 966 2,258 10,000 22.58%01-110-54-00-5452 POSTAGE & SHIPPING7 15 1 31 19 10 22 106 3,000 3.52%01-110-54-00-5460 DUES & SUBSCRIPTIONS7,634 225 257 100 588 897 1,951 11,651 22,000 52.96%01-110-54-00-5462 PROFESSIONAL SERVICES202 519 498 1,413 322 393 617 3,965 12,000 33.04%01-110-54-00-5480 UTILITIES- 827 6,214 5,808 6,584 7,851 2,598 29,882 33,708 88.65%01-110-54-00-5485 RENTAL & LEASE PURCHASE338 226 226 226 226 308 226 1,775 3,000 59.18%01-110-54-00-5488 OFFICE CLEANING- 1,046 1,058 1,091 1,091 - 2,182 6,466 13,743 47.05%Supplies01-110-56-00-5610 OFFICE SUPPLIES507 310 1,607 1,091 267 616 827 5,225 10,000 52.25%TOTAL EXPENDITURES: ADMINISTRATION80,151 74,732 79,802 58,269 58,214 78,380 56,121 485,667 996,443 48.74%FINANCE EXPENDITURESSalaries & Wages01-120-50-00-5010SALARIES & WAGES24,238 28,680 26,881 24,193 23,206 35,559 23,373 186,130 326,735 56.97%Benefits01-120-52-00-5212RETIREMENT PLAN CONTRIBUTION2,709 3,203 3,003 2,704 2,578 3,984 2,613 20,796 34,006 61.15%01-120-52-00-5214 FICA CONTRIBUTION 1,824 2,164 2,026 1,820 1,733 2,700 1,572 13,838 23,676 58.45%01-120-52-00-5216 GROUP HEALTH INSURANCE 3,429 7,104 3,199 2,952 2,511 3,952 2,891 26,039 48,081 54.16%01-120-52-00-5222 GROUP LIFE INSURANCE - 53 - 93 - 31 31 208 361 57.52%01-120-52-00-5223 DENTAL INSURANCE - 1,033 344 344 344 344 344 2,755 4,132 66.67%01-120-52-00-5224 VISION INSURANCE 39 65 - 156 - 52 52 364 624 58.32%Contractual Services01-120-54-00-5412 TRAINING & CONFERENCES - - - - - - - - 3,500 0.00%01-120-54-00-5414 AUDITING SERVICES - 15,000 - - - 15,200 5,700 35,900 35,900 100.00%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 386 57 1,412 3,500 40.35%01-120-54-00-5440 TELECOMMUNICATIONS - 170 170 170 170 327 170 1,177 1,980 59.45%01-120-54-00-5452 POSTAGE & SHIPPING 55 75 72 121 107 84 73 587 1,200 48.91%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,222 3,426 3,156 12,314 4,389 33,753 65,000 51.93%01-120-54-00-5485 RENTAL & LEASE PURCHASE 259 113 113 387 113 113 275 1,373 2,200 62.42%Supplies01-120-56-00-5610 OFFICE SUPPLIES - 89 - 138 - 132 623 981 2,500 39.25%TOTAL EXPENDITURES: FINANCE 36,618 61,408 39,137 36,963 33,937 75,177 42,163 325,402 557,390 58.38%POLICE EXPENDITURESSalaries & Wages01-210-50-00-5008 SALARIES - POLICE OFFICERS 161,377 158,933 155,605 158,184 156,531 227,544 153,648 1,171,821 1,975,199 59.33%01-210-50-00-5011SALARIES - COMMAND STAFF31,168 34,341 33,560 30,848 29,578 55,868 29,578 244,941 525,732 46.59%3 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-210-50-00-5012 SALARIES - SERGEANTS41,497 47,475 40,740 39,750 45,238 59,625 44,040 318,364 559,921 56.86%01-210-50-00-5013 SALARIES - POLICE CLERKS12,953 12,953 15,431 19,237 9,214 17,923 11,980 99,691 182,926 54.50%01-210-50-00-5014 SALARIES - CROSSING GUARD3,278 707 - - 1,667 4,103 3,452 13,205 30,000 44.02%01-210-50-00-5015 PART-TIME SALARIES2,089 4,040 5,559 3,949 5,467 7,056 3,910 32,070 70,000 45.81%01-210-50-00-5020 OVERTIME7,579 8,545 11,965 4,066 10,650 3,595 1,810 48,210 111,000 43.43%Benefits01-210-52-00-5212RETIREMENT PLAN CONTRIBUTION1,439 1,439 1,714 2,137 1,024 1,991 1,331 11,076 19,039 58.17%01-210-52-00-5213 EMPLOYER CONTRI - POL PEN 62,631 630,291 19,248 51,979 536,982 20,033 9,346 1,330,510 1,334,771 99.68%01-210-52-00-5214 FICA CONTRIBUTION 19,323 19,850 19,502 19,054 19,043 28,257 18,145 143,174 257,542 55.59%01-210-52-00-5216 GROUP HEALTH INSURANCE 85,493 92,725 50,282 51,590 42,545 43,575 40,528 406,737 572,407 71.06%01-210-52-00-5222 GROUP LIFE INSURANCE (100) 688 (100) 1,321 (100) 355 346 2,410 4,269 56.46%01-210-52-00-5223 DENTAL INSURANCE - 9,852 3,467 3,345 3,345 3,308 3,491 26,809 39,409 68.03%01-210-52-00-5224 VISION INSURANCE 505 505 - 1,484 - 493 486 3,473 5,987 58.01%Contractual Services01-210-54-00-5410 TUITION REIMBURSEMENT - - - 2,412 1,206 3,216 1,206 8,040 13,350 60.22%01-210-54-00-5411 POLICE COMMISSION - - 310 - 155 - 605 1,070 5,780 18.51%01-210-54-00-5412 TRAINING & CONFERENCES - 6,250 (5,335) 1,394 125 1,048 533 4,015 24,500 16.39%01-210-54-00-5415 TRAVEL & LODGING - 292 597 - 168 70 169 1,296 10,000 12.96%01-210-54-00-5422VEHICLE & EQUIPMENT CHARGEBACK7,644 7,644 7,644 7,644 7,644 7,644 7,644 53,510 91,732 58.33%01-210-54-00-5424COMPUTER REPLACEMENT CHARGEBACK- - - - - - - - 3,336 0.00%01-210-54-00-5430 PRINTING & DUPLICATING - 78 71 55 131 234 96 666 5,000 13.31%01-210-54-00-5440 TELECOMMUNICATIONS - 1,851 3,436 5,174 1,979 4,890 2,137 19,468 43,500 44.75%01-210-54-00-5452 POSTAGE & SHIPPING 25 52 54 - 57 49 94 331 1,200 27.61%01-210-54-00-5460 DUES & SUBSCRIPTIONS 5,750 4,000 5,126 126 6 6 155 15,169 10,700 141.76%01-210-54-00-5462 PROFESSIONAL SERVICES 600 5,000 485 905 1,469 45 974 9,478 39,950 23.72%01-210-54-00-5467 ADJUDICATION SERVICES - 700 271 1,300 625 - 1,100 3,996 20,750 19.26%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 411 411 2,880 5,600 51.43%01-210-54-00-5488 OFFICE CLEANING - 1,046 1,058 1,091 1,091 - 2,182 6,466 13,806 46.84%01-210-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - 1,690 5,533 1,731 4,229 2,813 15,996 60,000 26.66%Supplies01-210-56-00-5600 WEARING APPAREL - - - 352 647 1,177 1,398 3,574 15,000 23.83%01-210-56-00-5610 OFFICE SUPPLIES - 65 35 - 348 252 606 1,306 4,500 29.02%01-210-56-00-5620 OPERATING SUPPLIES - 225 20 253 45 292 411 1,245 16,500 7.55%01-210-56-00-5650 COMMUNITY SERVICES - 30 - 436 209 74 - 748 3,000 24.94%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 5,618 5,220 31,123 62,348 49.92%4 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-210-56-00-5696 AMMUNITION- - - - - - 10 10 9,000 0.11%TOTAL EXPENDITURES: POLICE443,774 1,055,082 377,582 418,858 884,745 502,980 349,853 4,032,876 6,158,904 65.48%COMMUNITY DEVELOPMENT EXPENDITURESSalaries & Wages01-220-50-00-5010 SALARIES & WAGES40,628 47,667 47,718 40,990 41,569 62,812 42,744 324,128 561,611 57.71%Benefits01-220-52-00-5212RETIREMENT PLAN CONTRIBUTION4,547 5,329 5,335 4,587 4,618 7,045 4,782 36,244 58,451 62.01%01-220-52-00-5214 FICA CONTRIBUTION 3,014 3,552 3,556 3,042 3,063 4,709 3,176 24,112 41,374 58.28%01-220-52-00-5216 GROUP HEALTH INSURANCE 12,767 12,912 6,749 7,512 4,243 6,000 6,042 56,226 85,991 65.39%01-220-52-00-5222 GROUP LIFE INSURANCE - - - 166 - 55 60 281 707 39.81%01-220-52-00-5223 DENTAL INSURANCE - 1,699 566 566 566 585 604 4,587 7,034 65.22%01-220-52-00-5224 VISION INSURANCE 90 90 - 270 - 90 93 634 1,115 56.84%Contractual Services01-220-54-00-5412 TRAINING & CONFERENCES 350 41 365 - - 195 (195) 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 - - - 1,450 2,165 2,500 86.59%01-220-54-00-5430 PRINTING & DUPLICATING - 49 63 45 70 48 64 340 1,500 22.65%01-220-54-00-5440 TELECOMMUNICATIONS - 98 267 267 267 267 323 1,489 4,000 37.23%01-220-54-00-5452 POSTAGE & SHIPPING 2 9 8 11 13 14 8 65 500 13.06%01-220-54-00-5459 INSPECTIONS - - 18,440 20,080 15,040 - 16,360 69,920 70,000 99.89%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 2,892 645 19,586 89,280 21.94%01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 189 189 189 189 189 189 1,324 3,150 42.02%01-220-54-00-5490VEHICLE MAINTENANCE SERVICES- 396 - 218 - - - 614 4,500 13.64%Supplies01-220-56-00-5610 OFFICE SUPPLIES - - 66 - 151 184 119 520 1,500 34.69%01-220-56-00-5620 OPERATING SUPPLIES - 38 686 201 76 213 148 1,361 5,000 27.21%01-220-56-00-5695 GASOLINE - 373 280 350 428 323 359 2,113 4,752 44.46%TOTAL EXPENDITURES: COMMUNITY DEVELP 66,838 73,071 90,142 80,870 74,061 85,621 76,971 547,574 990,515 55.28%PUBLIC WORKS - STREET OPERATIONS EXPENDITURESSalaries & Wages01-410-50-00-5010 SALARIES & WAGES 34,292 36,287 36,921 34,063 34,506 52,422 34,727 263,217 560,857 46.93%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 789 325 2,039 22,500 9.06%Benefits01-410-52-00-5212RETIREMENT PLAN CONTRIBUTION3,834 4,031 4,114 3,808 3,877 5,912 3,894 29,470 60,715 48.54%01-410-52-00-5214 FICA CONTRIBUTION 2,532 2,668 2,723 2,511 2,559 3,947 2,570 19,509 43,565 44.78%01-410-52-00-5216 GROUP HEALTH INSURANCE 17,948 18,818 9,005 9,062 8,280 10,099 8,968 82,181 156,120 52.64%5 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-410-52-00-5222 GROUP LIFE INSURANCE(145) 372 (145) 511 (145) 74 79 602 941 63.96%01-410-52-00-5223 DENTAL INSURANCE- 1,844 705 660 660 678 660 5,206 10,663 48.83%01-410-52-00-5224 VISION INSURANCE96 96 - 287 - 96 99 674 1,576 42.74%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 8,333 8,333 58,333 100,000 58.33%01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - 410 237 66 3,480 511 492 5,195 30,000 17.32%01-410-54-00-5440 TELECOMMUNICATIONS - 310 310 376 310 336 315 1,957 7,600 25.75%01-410-54-00-5455 MOSQUITO CONTROL - - - - - - - - 6,615 0.00%01-410-54-00-5458 TREE & STUMP MAINTENANCE - - 4,750 - - 5,400 - 10,150 15,000 67.67%01-410-54-00-5462 PROFESSIONAL SERVICES 367 372 60 981 368 370 1,041 3,559 9,225 38.58%01-410-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 - 3,290 4,500 73.11%01-410-54-00-5485 RENTAL & LEASE PURCHASE 69 274 213 159 185 396 599 1,894 6,000 31.56%01-410-54-00-5488 OFFICE CLEANING - 103 105 108 108 - 215 638 1,329 48.00%01-410-54-00-5490VEHICLE MAINTENANCE SERVICES- - 4,743 4,133 2,634 4,284 15,020 30,815 65,000 47.41%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 478 858 4,035 22,000 18.34%01-410-56-00-5628VEHICLE MAINTENANCE SUPPLIES600 43 866 1,441 1,368 2,567 4,227 11,113 30,000 37.04%01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - 471 21 281 210 - 194 1,177 21,500 5.48%01-410-56-00-5640 REPAIR & MAINTENANCE - 942 809 355 45 1,211 4,760 8,123 25,000 32.49%01-410-56-00-5665 JULIE SUPPLIES - - - - - - - - 1,200 0.00%01-410-56-00-5695 GASOLINE - 285 475 3,870 1,076 986 2,394 9,084 25,680 35.38%TOTAL EXP: PUBLIC WORKS - STREET OPS 68,139 77,291 76,570 75,106 69,323 100,533 89,770 556,733 1,255,026 44.36%PW - HEALTH & SANITATION EXPENDITURES- Contractual Services01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - 3,517 3,550 3,610 3,602 3,589 17,868 44,588 40.07%01-540-54-00-5442 GARBAGE SERVICES - - 117,910 116,674 115,511 117,340 118,656 586,090 1,340,671 43.72%01-540-54-00-5443 LEAF PICKUP - 600 - - - - - 600 9,000 6.67%TOTAL EXPENDITURES: HEALTH & SANITATION - 600 121,427 120,223 119,121 120,942 122,244 604,557 1,394,259 43.36%ADMINISTRATIVE 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 INSURANCE81,864 26,432 26,432 26,432 41,844 26,419 14,236 243,660 346,323 70.36%01-640-52-00-5240 RETIREES - GROUP HEALTH INS13,890 22,095 (2,426) 7,298 (2,471) 835 3,103 42,324 44,302 95.53%6 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-640-52-00-5241 RETIREES - DENTAL INSURANCE(1,036) 3,347 (40) 506 83 88 98 3,047 333 915.02%01-640-52-00-5242 RETIREES - VISION INSURANCE32 84 (236) 506 (289) (32) 0 65 62 104.66%Contractual Services01-640-54-00-5418 PURCHASING SERVICES- - 36 - - 4,025 - 4,061 62,437 6.50%01-640-54-00-5423 IDOR ADMINISTRATION FEE3,623 5,541 5,213 5,652 5,914 5,406 5,260 36,610 49,556 73.88%01-640-54-00-5424COMPUTER REPLACEMENT CHRGEBACK- - - - - - - - 1,895 0.00%01-640-54-00-5427GC HOUSING RENTAL ASSISTANCE1,658 829 829 829 - 1,658 829 6,632 10,114 65.57%01-640-54-00-5428 UTILITY TAX REBATE - - - - - - - - 8,000 0.00%01-640-54-00-5432FACILITY MANAGEMENT SERVICES- - - - - 15,261 - 15,261 - 0.00%01-640-54-00-5439 AMUSEMENT TAX REBATE - - 996 1,836 2,415 1,540 1,187 7,974 12,000 66.45%01-640-54-00-5449 KENCOM - 13,693 1,170 1,170 1,164 - 1,575 18,773 124,409 15.09%01-640-54-00-5450 INFORMATION TECH SRVCS - 3,308 8,662 9,414 28,245 19,840 9,310 78,780 400,000 19.69%01-640-54-00-5453BUILDINGS & GROUNDS CHARGEBACK- - - - - - - - 118,190 0.00%01-640-54-00-5456 CORPORATE COUNSEL - 5,653 4,009 3,948 - 9,866 3,728 27,204 110,000 24.73%01-640-54-00-5461 LITIGATION COUNSEL - 2,214 - 5,356 4,745 - 18,548 30,863 110,000 28.06%01-640-54-00-5462 PROFESSIONAL SERVICES 523 - 2,729 27,652 - 8,188 - 39,092 48,150 81.19%01-640-54-00-5463 SPECIAL COUNSEL - (1,692) - 4,788 90 900 180 4,266 25,000 17.06%01-640-54-00-5465 ENGINEERING SERVICES - - 35,093 67,011 28,382 - 72,105 202,591 300,000 67.53%01-640-54-00-5473 KENDALL AREA TRANSIT - - - - - - 11,775 11,775 25,000 47.10%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 25,982 6,006 54,568 72,000 75.79%01-640-54-00-5486 ECONOMIC DEVELOPMENT - 9,425 17,400 9,425 9,425 24,650 9,425 79,750 165,000 48.33%01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - - - 1,328 - 1,328 1,326 100.13%01-640-54-00-5492 SALES TAX REBATES- - - - - 232,250 136,750 369,000 1,004,700 36.73%01-640-54-00-5493 BUSINESS DISTRICT REBATES28,970 46,136 41,907 46,626 50,895 44,126 40,122 298,781 413,511 72.25%01-640-54-00-5494 ADMISSIONS TAX REBATE- - - - - - 148,662 148,662 145,000 102.53%01-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 33,438 33,438 234,063 401,250 58.33%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 26,781 26,781 187,469 321,375 58.33%01-640-99-00-9952 TRANSFER TO SEWER 43,312 43,312 43,312 43,312 43,312 43,312 43,312 303,187 519,749 58.33%01-640-99-00-9979TRANSFER TO PARKS & RECREATION119,571 119,571 119,571 119,571 119,571 119,571 119,571 836,995 1,434,849 58.33%7 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202101-640-99-00-9982 TRANSFER TO LIBRARY OPS5,518 1,775 2,139 1,775 1,775 1,774 872 15,629 26,993 57.90%TOTAL EXPENDITURES: ADMIN SERVICES358,143 362,228 382,985 448,675 404,600 647,206 706,874 3,310,712 6,747,733 49.06%TOTAL FUND REVENUES1,498,237 3,365,612 1,275,999 1,675,600 2,833,714 1,761,831 1,276,332 13,687,325 18,100,270 75.62%TOTAL FUND EXPENDITURES1,053,663 1,704,412 1,167,646 1,238,964 1,644,000 1,610,840 1,443,996 9,863,521 18,100,270 54.49%FUND SURPLUS (DEFICIT)444,573 1,661,200 108,353 436,636 1,189,714 150,991 (167,665) 3,823,804 - FOX HILL SSA REVENUES11-000-40-00-4000 PROPERTY TAXES501 7,872 116 435 6,965 145 0 16,034 19,000 84.39%TOTAL REVENUES: FOX HILL SSA501 7,872 116 435 6,965 145 0 16,034 19,000 84.39%FOX HILL SSA EXPENDITURES11-111-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 1,267 608 487 1,475 365 487 4,688 59,200 7.92%TOTAL FUND REVENUES 501 7,872 116 435 6,965 145 0 16,034 19,000 84.39%TOTAL FUND EXPENDITURES - 1,267 608 487 1,475 365 487 4,688 59,200 7.92%FUND SURPLUS (DEFICIT) 501 6,605 (493) (51) 5,490 (220) (487) 11,346 (40,200) SUNFLOWER SSA REVENUES12-000-40-00-4000 PROPERTY TAXES 801 9,201 93 522 9,137 522 87 20,363 21,000 96.97%TOTAL REVENUES: SUNFLOWER SSA 801 9,201 93 522 9,137 522 87 20,363 21,000 96.97%SUNFLOWER 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 345 460 6,301 12,200 51.65%TOTAL FUND REVENUES 801 9,201 93 522 9,137 522 87 20,363 21,000 96.97%TOTAL FUND EXPENDITURES 817 1,917 1,277 3,653 1,100 345 460 9,569 17,200 55.63%FUND SURPLUS (DEFICIT) (16) 7,284 (1,184) (3,131) 8,037 177 (373) 10,794 3,800 MOTOR FUEL TAX REVENUES15-000-41-00-4112 MOTOR FUEL TAX 36,740 36,117 37,425 36,754 40,299 37,843 35,230 260,408 482,526 53.97%15-000-41-00-4113 MFT HIGH GROWTH - - - - - 79,463 - 79,463 11,000 722.39%15-000-41-00-4114 TRANSPORTATION RENEWAL TAX 25,924 26,038 26,425 26,545 28,337 27,924 25,350 186,543 346,618 53.82%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 42 46 291 2,000 14.54%TOTAL REVENUES: MOTOR FUEL TAX 271,641 62,194 63,894 63,345 68,670 145,273 60,626 735,642 1,260,019 58.38%8 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021MOTOR 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 6,149 6,149 43,042 73,788 58.33%TOTAL FUND REVENUES 271,641 62,194 63,894 63,345 68,670 145,273 60,626 735,642 1,260,019 58.38%TOTAL FUND EXPENDITURES 6,149 6,149 6,149 467,096 6,149 6,149 6,149 503,990 2,435,413 20.69%FUND SURPLUS (DEFICIT) 265,492 56,045 57,745 (403,752) 62,521 139,124 54,477 231,652 (1,175,394) CITY-WIDE CAPITAL REVENUESLicenses & Permits23-000-42-00-4214 DEVELOPMENT FEES - 500 85 - (85) 500 - 1,000 5,000 20.00%23-000-42-00-4222 ROAD CONTRIBUTION FEE 26,000 (18,000) 48,000 56,000 30,000 (134,000) 52,000 60,000 100,000 60.00%Charges for Service23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 279 136,621 390 137,532 434 138,371 379 414,006 785,000 52.74%Investment Earnings23-000-45-00-4500 INVESTMENT EARNINGS 6 6 6 6 6 6 6 42 500 8.41%23-000-45-00-4550GAIN 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 REIMB - MILL ROAD - - 3,597 4,111 - - 1,188,097 1,195,804 2,320,000 51.54%23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE- 165 - - - - - 165 - 0.00%23-000-46-00-4636 REIMB - RAINTREE VILLAGE- 6,355 - - - - - 6,355 165,000 3.85%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 33,438 33,438 234,063 401,250 58.33%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,300,443 85,515 231,210 79,659 38,315 1,273,919 4,068,783 5,808,072 70.05%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 - 24,123 33,483 109,000 30.72%23-230-54-00-5482 STREET LIGHTING - 5 7,801 7,860 8,351 9,411 9,587 43,016 110,214 39.03%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 - 2,999 120 4,461 15,000 29.74%9 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202123-230-60-00-6032 ASPHALT PATCHING- 1,956 860 150 - - - 2,966 35,000 8.48%23-230-56-00-5637SIDEWALK CONSTRUCTION SUPPLIES- 640 522 2,244 414 - - 3,820 7,500 50.93%23-230-56-00-5642STREET LIGHTING & OTHER SUPPLIES- 733 1,880 330 403 298 13,235 16,879 45,000 37.51%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 - 723,277 1,198,017 2,260,000 53.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-6025ROAD TO BETTER ROADS PROGRAM- - 19,135 2,062 29,340 - 50,429 100,966 1,148,725 8.79%23-230-60-00-6032 BRISTOL RIDGE ROAD - - 774 2,485 4,166 - 824 8,249 70,000 11.78%23-230-60-00-6036RAINTREE VILLAGE IMPROVEMENTS- 6,355 - - - - - 6,355 165,000 3.85%23-230-60-00-6041SIDEWALK REPLACEMENT PROGRAM- - 2,959 2,758 1,223 - 1,976 8,915 300,000 2.97%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 - 23,873 37,678 60,000 62.80%23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL - - - - - - - - 32,000 0.00%2014A Bond23-230-78-00-8000 PRINCIPAL PAYMENT - - - - - - 200,000 200,000 200,000 100.00%23-230-78-00-8050 INTEREST PAYMENT 57,669 - - - - - 57,669 115,338 115,338 100.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 8,713 8,713 60,992 104,558 58.33%TOTAL FUND REVENUES 59,722 2,300,443 85,515 231,210 79,659 38,315 1,273,919 4,068,783 5,808,072 70.05%TOTAL FUND EXPENDITURES 66,382 18,402 50,017 44,831 526,730 21,421 1,113,827 1,841,611 5,545,285 33.21%FUND SURPLUS (DEFICIT) (6,660) 2,282,040 35,498 186,379 (447,071) 16,894 160,093 2,227,173 262,787 BUILDING & GROUNDS REVENUESLicenses & Permits24-000-42-00-4218DEVELOPMENT FEES - MUNICIPAL BLDG8,236 600 2,209 2,509 2,809 900 150 17,413 35,000 49.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 67 65 465 3,000 15.50%Other Financing Sources24-000-48-00-4845 DONATIONS - - - - - - - - 2,000 0.00%24-000-48-00-4850 MISCELLANEOUS INCOME - - - - - - 412 412 - 0.00%24-000-49-00-4900 BOND PROCEEDS 8,250,000 - - - - - - 8,250,000 8,707,478 94.75%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 967 627 8,793,301 9,584,249 91.75%10 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021BUILDING & GROUNDS EXPENDITURESSalaries & Wages24-216-50-00-5010 SALARIES & WAGES - - - - - 3,143 4,190 7,333 50,117 14.63%Benefits24-216-52-00-5212RETIREMENT PLAN CONTRIBUTION- - - - - 349 482 831 5,216 15.94%24-216-52-00-5214 FICA CONTRIBUTION - - - - - 240 332 572 3,547 16.14%24-216-52-00-5216 GROUP HEALTH INSURANCE - - - - - - 150 150 21,690 0.69%24-216-52-00-5222 GROUP LIFE INSURANCE - - - - - - - - 109 0.00%24-216-52-00-5223 DENTAL INSURANCE - - - - - - 148 148 1,352 10.95%24-216-52-00-5224 VISION INSURANCE - - - - - - - - 197 0.00%Contractual Services24-216-54-00-5402 BOND ISSUANCE COSTS 96,175 - - 74 - - - 96,249 82,478 116.70%24-216-54-00-5432FACILITY MANAGEMENT SERVICES- - - - - - 45 45 65,510 0.07%24-216-54-00-5440 TELECOMMUNICATIONS - - - - - - 45 45 - 0.00%24-216-54-00-5446PROPERTY & BUILDING MAINTENANCE SERVICES1,737 2,775 8,966 4,909 6,980 7,515 17,069 49,952 160,000 31.22%Supplies24-216-56-00-5600 WEARING APPAREL - - - - - - 329 329 - 0.00%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 328 1,734 6,986 25,000 27.95%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 967 627 8,793,301 9,584,249 91.75%TOTAL FUND EXPENDITURES 97,912 2,146,497 12,010 5,470 87,865 11,575 24,524 2,385,854 9,584,249 24.89%FUND SURPLUS (DEFICIT) 8,685,386 (2,145,813) (9,734) (2,894) (84,991) (10,609) (23,897) 6,407,447 - VEHICLE & EQUIPMENT REVENUELicenses & Permits25-000-41-00-4170 STATE GRANTS - - - - 19,080 - - 19,080 - 0.00%25-000-42-00-4215DEVELOPMENT FEES - POLICE CAPITAL7,200 3,600 4,650 2,250 2,400 1,500 300 21,900 30,000 73.00%25-000-42-00-4217 WEATHER WARNING SIREN FEES 326 109 109 217 380 217 54 1,411 - 0.00%25-000-42-00-4218 ENGINEERING CAPITAL FEE 2,300 2,100 2,700 3,500 2,300 2,500 2,700 18,100 10,000 181.00%25-000-42-00-4219DEVELOPMENT FEES - PW CAPITAL17,000 8,600 10,950 5,350 5,600 3,700 700 51,900 64,500 80.47%25-000-42-00-4220DEVELOPMENT FEES - PARK CAPITAL1,150 1,050 1,350 1,750 1,150 1,250 1,350 9,050 5,000 181.00%Fines & Forfeits25-000-43-00-4315 DUI FINES 350 217 1,100 700 350 64 - 2,781 7,000 39.73%Other Financing Uses11 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202125-000-43-00-4316 ELECTRONIC CITATION FEES74 32 68 70 76 58 72 450 800 56.25%Charges 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 CHARGEBACK7,644 7,644 7,644 7,644 7,644 7,644 7,644 53,510 91,732 58.33%25-000-44-00-4421 PUBLIC WORKS CHARGEBACK8,333 8,333 8,333 8,333 8,333 8,333 8,333 58,333 100,000 58.33%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 47,418 25,267 21,154 243,038 547,226 44.41%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 16,162 - 24,498 12,232 200.28%Capital Outlay25-212-60-00-6070 VEHICLES - - 31,070 - - 74,959 4,066 110,095 31,000 355.15%TOTAL EXPENDITURES: GENERAL GOVERNMENT - - 31,070 - 8,336 91,121 4,066 134,593 43,232 311.33%PUBLIC WORKS CAPITAL EXPENDITURESContractual Services25-215-54-00-5448 FILING FEES - - - - - - - - 750 0.00%Supplies25-215-56-00-5620 OPERATING SUPPLIES - - - - - - - - 1,000 0.00%12 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021Capital Outlay25-215-60-00-6060 EQUIPMENT - - - - - - 14,752 14,752 15,000 98.35%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 4,471 4,442 30,941 53,527 57.80%25-215-92-00-8050 INTEREST PAYMENT 1,377 1,409 1,351 1,382 1,368 1,312 1,341 9,540 15,869 60.12%TOTAL EXPENDITURES: PW CAPITAL 16,569 5,783 5,783 51,260 5,783 5,783 20,535 111,496 997,146 11.18%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 (44) - 6,268 152,096 4.12%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 140 139 969 1,677 57.81%25-225-92-00-8050 INTEREST PAYMENT43 44 42 43 43 41 42 299 497 60.14%TOTAL EXPENDITURES: PARK & REC CAPITAL10,260 12,180 8,111 5,980 695 137 181 37,545 518,870 7.24%TOTAL FUND REVENUES 44,377 37,032 37,599 30,190 47,418 25,267 21,154 243,038 547,226 44.41%TOTAL FUND EXPENDITURES 26,829 115,173 45,388 75,336 16,714 97,041 24,783 401,263 1,877,998 21.37%FUND SURPLUS (DEFICIT) 17,548 (78,141) (7,789) (45,146) 30,705 (71,774) (3,629) (158,225) (1,330,772) DEBT SERVICE REVENUES42-000-42-00-4208RECAPTURE FEES-WATER & SEWER1,075 1,000 900 1,625 775 875 700 6,950 8,000 86.88%42-000-49-00-4901 TRANSFER FROM GENERAL 26,781 26,781 26,781 26,781 26,781 26,781 26,781 187,469 321,375 58.33%TOTAL REVENUES: DEBT SERVICE 27,856 27,781 27,681 28,406 27,556 27,656 27,481 194,419 329,375 59.03%DEBT 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 27,656 27,481 194,419 329,375 59.03%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 27,656 27,481 184,494 - 13 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021WATER FUND REVENUESCharges for Service51-000-41-00-4165 FEDERAL GRANTS - APRA FUNDS - - - - - - - - 131,250 0.00%51-000-44-00-4424 WATER SALES 1,019 488,600 8,579 724,843 6,049 643,241 3,598 1,875,928 3,412,500 54.97%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 23,918 25 70,729 116,394 60.77%51-000-44-00-4430 WATER METER SALES 25,990 24,500 19,535 38,935 15,860 19,800 15,325 159,945 60,000 266.58%51-000-44-00-4440 WATER INFRASTRUCTURE FEE 259 140,106 416 140,979 464 142,086 400 424,710 820,000 51.79%51-000-44-00-4450 WATER CONNECTION FEES 44,400 23,800 38,800 48,308 50,600 37,200 3,700 246,808 230,000 107.31%Investment Earnings51-000-45-00-4500 INVESTMENT EARNINGS 38 87 113 145 127 142 134 786 3,000 26.19%51-000-45-00-4550 GAIN ON INVESTMENT - - - - 611 - - 611 - 0.00%Miscellaneous51-000-46-00-4690MISCELLANEOUS REIMBURSEMENT- - - - - - 2,920 2,920 - 0.00%51-000-48-00-4820 RENTAL INCOME 8,513 11,178 5,538 8,513 11,489 5,538 8,557 59,327 102,644 57.80%51-000-48-00-4850 MISCELLANEOUS INCOME 56 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 8,713 8,713 60,992 104,558 58.33%51-000-49-00-4952 TRANSFER FROM SEWER 6,306 6,306 6,306 6,306 6,306 6,306 6,306 44,144 75,675 58.33%TOTAL REVENUES: WATER FUND 95,384 728,221 88,075 998,801 100,257 886,944 49,678 2,947,359 5,061,271 58.23%WATER OPERATIONS EXPENSESSalaries & Wages51-510-50-00-5010 SALARIES & WAGES 33,942 36,214 35,190 38,461 36,863 53,355 35,403 269,428 485,856 55.45%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 1,016 644 3,740 22,000 17.00%Benefits51-510-52-00-5212RETIREMENT PLAN CONTRIBUTION3,805 4,079 3,923 4,340 4,156 6,041 4,005 30,349 52,857 57.42%51-510-52-00-5214 FICA CONTRIBUTION 2,499 2,798 2,733 2,865 2,732 4,015 2,626 20,269 39,634 51.14%51-510-52-00-5216 GROUP HEALTH INSURANCE 17,462 19,964 10,425 9,671 10,031 11,473 11,425 90,451 107,242 84.34%51-510-52-00-5222 GROUP LIFE INSURANCE (20) 133 (20) 238 (20) 66 71 449 897 50.07%51-510-52-00-5223 DENTAL INSURANCE - 2,167 903 789 887 857 838 6,441 8,634 74.60%51-510-52-00-5224 VISION INSURANCE 99 113 - 318 - 106 109 745 1,306 57.06%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 2,082 1,023 18,504 31,023 59.65%Contractual Services51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 10,550 10,550 10,550 10,550 10,550 10,550 10,550 73,848 126,596 58.33%51-510-54-00-5412 TRAINING & CONFERENCES - - 240 - 745 86 - 1,071 9,200 11.64%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 594 749 3,348 8,000 41.85%14 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202151-510-54-00-5430 PRINTING & DUPLICATING- 487 107 518 2 485 15 1,614 3,250 49.66%51-510-54-00-5440 TELECOMMUNICATIONS- 3,302 3,734 6,867 735 6,828 742 22,207 40,000 55.52%51-510-54-00-5445 TREATMENT FACILITY SERVICES13,972 16,321 30,500 20,789 40,130 35,071 22,107 178,891 225,000 79.51%51-510-54-00-5448 FILING FEES134 469 134 - - 268 - 1,005 3,000 33.50%51-510-54-00-5452 POSTAGE & SHIPPING3,050 516 2,735 47 80 3,359 3,340 13,126 20,000 65.63%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,855 5,824 4,789 11,283 4,991 44,785 166,000 26.98%51-510-54-00-5465 ENGINEERING SERVICES - - 4,415 7,350 8,534 - 38,325 58,624 75,000 78.17%51-510-54-00-5480 UTILITIES - - 27,032 27,009 27,176 28,366 25,999 135,583 312,700 43.36%51-510-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 - 3,290 4,500 73.11%51-510-54-00-5485 RENTAL & LEASE PURCHASE 145 95 208 95 152 95 173 962 2,000 48.12%51-510-54-00-5488 OFFICE CLEANING - 103 105 108 108 - 215 638 1,329 48.00%51-510-54-00-5490VEHICLE MAINTENANCE SERVICES- - - - - - - - 12,000 0.00%51-510-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - - 12,709 - - 761 13,471 32,000 42.10%51-510-54-00-5498 PAYING AGENT FEES - - 349 475 - 475 - 1,299 1,300 99.95%51-510-54-00-5499 BAD DEBT - - - - - - - - 10,000 0.00%Supplies51-510-56-00-5600 WEARING APPAREL - 33 247 - - 391 209 880 5,000 17.60%51-510-56-00-5620 OPERATING SUPPLIES - 324 457 696 117 202 322 2,120 11,000 19.27%51-510-56-00-5628VEHICLE MAINTENANCE SUPPLIES- 2,797 532 1,945 - 192 - 5,465 2,500 218.60%51-510-56-00-5630 SMALL TOOLS & EQUIPMENT - - 96 - 43 64 182 385 8,400 4.58%51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 5,282 8,659 14,358 19,108 15,637 19,580 12,214 94,838 191,425 49.54%51-510-56-00-5640 REPAIR & MAINTENANCE - 1,098 617 4,345 1,622 - 4,259 11,942 27,500 43.43%51-510-56-00-5664 METERS & PARTS - 1,205 5,036 32,576 28,252 10,206 34,948 112,224 100,000 112.22%51-510-56-00-5665 JULIE SUPPLIES - - - - 8 - 192 200 3,000 6.66%51-510-56-00-5695 GASOLINE - 285 646 3,365 1,395 1,341 1,634 8,667 21,400 40.50%Capital Outlay51-510-60-00-6015 WATER TOWER PAINTING - - - - - - - - 20,000 0.00%51-510-60-00-6022 WELL REHABILITATIONS - - - - - - 2,195 2,195 192,000 1.14%51-510-60-00-6025ROAD TO BETTER ROADS PROGRAM- - 161,675 148,787 42,704 161,745 38,521 553,433 950,000 58.26%51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - - - - - - - 21,000 0.00%51-510-60-00-6060 EQUIPMENT - - - 158 611 - 24,996 25,764 463,000 5.56%51-510-60-00-6066RTE 71 WATERMAIN REPLACEMENT- - - - - - - - 33,208 0.00%51-510-60-00-6070 VEHICLES - - - - - 3,200 - 3,200 100,000 3.20%51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 3,781 3,781 3,781 3,781 3,781 26,467 45,372 58.33%51-510-60-00-6081CATION EXCHANGE MEDIA REPLACEMENT- - - - - - - - 216,000 0.00%2015A Bond51-510-77-00-8000 PRINCIPAL PAYMENT - - - - - - 312,545 312,545 312,545 100.00%15 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202151-510-77-00-8050 INTEREST PAYMENT 64,127 - - - - - 64,127 128,254 128,254 100.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%2014C 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 REVENUES95,384 728,221 88,075 998,801 100,257 886,944 49,678 2,947,359 5,061,271 58.23%TOTAL FUND EXPENSES172,807 164,730 332,887 431,240 244,904 378,817 664,237 2,389,623 6,081,733 39.29%FUND SURPLUS (DEFICIT)(77,423) 563,490 (244,812) 567,561 (144,648) 508,127 (614,559) 557,736 (1,020,462) SEWER FUND REVENUESCharges for Service52-000-41-00-4165FEDERAL GRANTS - ARPA FUNDS- - - - - - - - 84,500 0.00%52-000-44-00-4435 SEWER MAINTENANCE FEES187 175,357 350 176,807 353 177,865 201 531,120 1,055,596 50.31%52-000-44-00-4440 SEWER INFRASTRUCTURE FEE127 68,526 198 68,961 220 69,377 184 207,592 395,000 52.55%52-000-44-00-4455 SW CONNECTION FEES - OPS8,900 10,300 12,800 15,600 9,300 11,700 13,200 81,800 23,300 351.07%52-000-44-00-4456 SW CONNECTION FEES - CAPITAL21,600 7,200 7,200 14,400 16,200 10,800 1,800 79,200 180,000 44.00%52-000-44-00-4462 LATE PENALTIES - SEWER12 3,495 11 3,261 5 2,960 3 9,746 15,957 61.08%Investment Earnings52-000-45-00-4500 INVESTMENT EARNINGS7 13 17 27 32 37 40 173 1,500 11.55%52-000-45-00-4550 GAIN ON INVESTMENT- - - - 2,874 - - 2,874 - 0.00%Other Financing Sources52-000-46-00-4690 REIMB - MISCELLANEOUS~- - - - - - 1,683 1,683 - 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 43,312 43,312 303,187 519,749 58.33%TOTAL REVENUES: SEWER FUND 74,145 308,433 63,887 322,369 72,296 316,052 60,423 1,217,604 2,275,602 53.51%SEWER OPERATIONS EXPENSESSalaries & Wages52-520-50-00-5010 SALARIES & WAGES 18,560 19,518 20,334 18,874 19,378 32,188 19,725 148,576 271,613 54.70%52-520-50-00-5015 PART-TIME SALARIES - - - - - - - - 6,720 0.00%52-520-50-00-5020 OVERTIME - - 149 73 100 97 66 483 500 96.66%Benefits52-520-52-00-5212RETIREMENT PLAN CONTRIBUTION2,062 2,168 2,276 2,105 2,164 3,587 2,199 16,561 28,321 58.47%52-520-52-00-5214 FICA CONTRIBUTION 1,352 1,426 1,497 1,380 1,421 2,398 1,443 10,916 20,151 54.17%52-520-52-00-5216 GROUP HEALTH INSURANCE 10,325 8,889 4,342 3,830 3,278 4,863 4,731 40,259 80,510 50.00%52-520-52-00-5222 GROUP LIFE INSURANCE (67) 135 (67) 253 (67) 39 44 270 529 50.98%16 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202152-520-52-00-5223 DENTAL INSURANCE- 898 299 322 322 340 322 2,503 5,527 45.29%52-520-52-00-5224 VISION INSURANCE66 66 - 199 - 66 70 467 830 56.30%52-520-52-00-5230 UNEMPLOYMENT INSURANCE- - 303 - - - - 303 850 35.65%52-520-52-00-5231 LIABILITY INSURANCE3,345 941 941 941 941 940 462 8,511 15,036 56.61%Contractual Services52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK3,797 3,797 3,797 3,797 3,797 3,797 3,797 26,578 45,563 58.33%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 228 7 757 1,500 50.45%52-520-54-00-5440 TELECOMMUNICATIONS- 606 642 1,410 806 1,140 269 4,873 13,500 36.09%52-520-54-00-5444 LIFT STATION SERVICES92 6,417 9,580 4,907 381 515 4,516 26,407 36,000 73.35%52-520-54-00-5462BUILDINGS & GROUNDS CHARGEBACK- - - - - - - - 14,774 0.00%52-520-54-00-5462 PROFESSIONAL SERVICES 2,771 2,331 1,867 2,674 2,242 1,483 2,328 15,697 35,500 44.22%52-520-54-00-5480 UTILITIES - - 1,004 1,070 1,016 984 1,275 5,349 25,249 21.19%52-520-54-00-5483 JULIE SERVICES - - - 1,645 - 1,645 - 3,290 4,500 73.11%52-520-54-00-5485 RENTAL & LEASE PURCHASE 69 57 170 57 57 57 135 603 1,500 40.21%52-520-54-00-5488 OFFICE CLEANING - 103 105 108 108 - 215 638 1,329 48.00%52-520-54-00-5490VEHICLE MAINTENANCE SERVICES- 1,929 - - - - 1,929 10,000 19.29%52-520-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - - - - 350 350 16,000 2.19%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 - 45 966 3,980 24.28%52-520-56-00-5610 OFFICE SUPPLIES - - 26 146 72 307 49 599 1,250 47.93%52-520-56-00-5613 LIFT STATION MAINTENANCE - - 39 - - 2,737 3,088 5,864 8,000 73.30%52-520-56-00-5620 OPERATING SUPPLIES - 170 242 278 915 783 393 2,780 9,500 29.27%52-520-56-00-5628VEHICLE MAINTENANCE SUPPLIES- 627 209 155 2,083 165 1,956 5,194 10,000 51.94%52-520-56-00-5630 SMALL TOOLS & EQUIPMENT - - 269 - 389 - 438 1,096 5,600 19.57%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 615 2,394 7,734 20,000 38.67%Capital 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 1,873 1,873 13,114 22,488 58.32%2003 IRBB Debt Certificates17 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202152-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 WATER6,306 6,306 6,306 6,306 6,306 6,306 6,306 44,144 75,675 58.33%TOTAL FUND REVENUES74,145 308,433 63,887 322,369 72,296 316,052 60,423 1,217,604 2,275,602 53.51%TOTAL FUND EXPENSES50,553 164,781 66,399 56,174 92,654 67,154 58,494 556,208 2,428,579 22.90%FUND SURPLUS (DEFICIT)23,592 143,652 (2,512) 266,196 (20,358) 248,897 1,929 661,396 (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-4725 HEARTLAND MEADOWS- - - - - - - - 3,522 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%LAND 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 - ARPA FUNDS - - - - - - - - 334,250 0.00%79-000-44-00-4402 SPECIAL EVENTS 11,700 17,656 27,788 - 45 6,425 7,005 70,619 90,000 78.47%79-000-44-00-4403 CHILD DEVELOPMENT 5,330 12,348 1,638 12,251 12,530 12,769 11,834 68,699 145,000 47.38%79-000-44-00-4404 ATHLETICS AND FITNESS 14,764 55,314 42,939 8,777 3,994 4,533 14,361 144,681 370,000 39.10%79-000-44-00-4441 CONCESSION REVENUE 4,235 7,560 3,878 1,631 3,646 1,649 - 22,598 45,000 50.22%Investment Earnings79-000-45-00-4500 INVESTMENT EARNINGS 7 4 9 12 8 10 5 55 250 21.90%18 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 2021Reimbursements79-000-46-00-4690 REIMB - MISCELLANEOUS - - - - - 1,057 2,933 3,991 - 0.00%Miscellaneous79-000-48-00-4820 RENTAL INCOME - 54,849 1,700 1,700 700 1,700 700 61,349 66,209 92.66%79-000-48-00-4825 PARK RENTALS 785 932 4,638 1,392 535 617 309 9,208 17,500 52.62%79-000-48-00-4843 HOMETOWN DAYS 1,675 3,075 2,700 8,080 124,044 - 6,102 145,676 120,000 121.40%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 INCOME 109 2,017 - 2,088 18 792 - 5,025 5,000 100.49%Other Financing Sources79-000-49-00-4901 TRANSFER FROM GENERAL 119,571 119,571 119,571 119,571 119,571 119,571 119,571 836,995 1,434,849 58.33%TOTAL REVENUES: PARK & RECREATION 158,176 278,775 205,210 156,652 265,340 149,122 162,819 1,376,095 2,643,058 52.06%PARKS DEPARTMENT EXPENDITURESSalaries & Wages79-790-50-00-5010 SALARIES & WAGES 46,271 46,406 46,414 44,746 44,745 68,386 45,635 342,602 659,709 51.93%79-790-50-00-5015 PART-TIME SALARIES 2,832 5,745 7,440 7,313 5,940 7,956 4,036 41,262 62,500 66.02%79-790-50-00-5020 OVERTIME58 - 769 - 1,314 590 548 3,279 5,000 65.58%Benefits79-790-52-00-5212RETIREMENT PLAN CONTRIBUTION5,324 5,337 5,402 5,110 5,282 7,927 5,305 39,687 70,935 55.95%79-790-52-00-5214 FICA CONTRIBUTION 3,643 3,872 4,061 3,865 3,853 5,775 3,724 28,792 53,594 53.72%79-790-52-00-5216 GROUP HEALTH INSURANCE 22,007 22,292 10,989 10,684 14,252 11,225 10,285 101,733 173,195 58.74%79-790-52-00-5222 GROUP LIFE INSURANCE - 142 - 250 - 83 83 558 1,149 48.58%79-790-52-00-5223 DENTAL INSURANCE - 2,563 854 854 854 854 854 6,836 11,605 58.90%79-790-52-00-5224 VISION INSURANCE 128 128 - 384 - 128 128 897 1,734 51.72%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 1,182 772 5,290 8,250 64.13%79-790-54-00-5462 PROFESSIONAL SERVICES 510 589 634 3,141 829 578 576 6,857 11,400 60.15%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 99 95 7,160 8,055 88.88%79-790-54-00-5488 OFFICE CLEANING - 341 344 352 352 - 703 2,090 3,487 59.94%79-790-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 53 88 16 3,357 1,254 4,236 9,004 40,000 22.51%Supplies79-790-56-00-5600 WEARING APPAREL - - 312 125 274 - 191 902 6,220 14.51%79-790-56-00-5620 OPERATING SUPPLIES - 775 472 1,615 1,500 196 1,198 5,755 25,000 23.02%79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - 17 178 44 145 705 652 1,741 11,000 15.83%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 4,322 13,883 52,468 71,000 73.90%19 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202179-790-56-00-5646 ATHLETIC FIELDS & EQUIPMENT- 326 - 4,153 7,760 6,852 - 19,092 55,000 34.71%79-790-56-00-5695 GASOLINE- 955 3,517 4,091 2,751 3,807 4,702 19,823 21,824 90.83%TOTAL EXPENDITURES: PARKS DEPARTMENT81,526 101,661 98,723 93,673 100,719 121,920 97,607 695,829 1,402,523 49.61%RECREATION DEPARTMENT EXPENDITURESSalaries & Wages79-795-50-00-5010 SALARIES & WAGES28,258 24,483 25,867 28,256 28,256 44,254 27,829 207,203 386,753 53.58%79-795-50-00-5015 PART-TIME SALARIES33 496 468 - 2,240 - 193 3,429 23,500 14.59%79-795-50-00-5045 CONCESSION WAGES680 2,591 2,298 - 672 1,001 39 7,281 15,000 48.54%79-795-50-00-5046 PRE-SCHOOL WAGES2,399 656 1,013 540 1,025 8,108 5,731 19,472 40,000 48.68%79-795-50-00-5052 INSTRUCTORS WAGES2,113 1,219 1,193 1,525 987 2,440 579 10,055 40,000 25.14%Benefits79-795-52-00-5212RETIREMENT PLAN CONTRIBUTION3,148 2,737 2,893 3,289 3,236 5,243 3,103 23,649 45,446 52.04%79-795-52-00-5214 FICA CONTRIBUTION 2,492 2,211 2,320 2,271 2,476 4,234 2,575 18,577 37,238 49.89%79-795-52-00-5216 GROUP HEALTH INSURANCE 12,962 9,856 4,148 5,343 4,372 5,058 4,902 46,639 107,479 43.39%79-795-52-00-5222 GROUP LIFE INSURANCE (41) 109 (41) 242 (41) 62 52 343 748 45.84%79-795-52-00-5223 DENTAL INSURANCE - 1,279 455 492 455 388 388 3,458 7,685 45.00%79-795-52-00-5224 VISION INSURANCE 72 59 - 209 - 72 62 474 1,156 40.99%Contractual Services79-795-54-00-5412 TRAINING & CONFERENCES - - 824 14 - 14 179 1,032 5,000 20.64%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 265 790 6,199 55,000 11.27%79-795-54-00-5440 TELECOMMUNICATIONS - 681 679 1,610 868 1,258 780 5,876 8,750 67.15%79-795-54-00-5447 SCHOLARSHIPS - - - - - - - - 2,500 0.00%79-795-54-00-5452 POSTAGE & SHIPPING 67 259 74 72 65 181 104 822 3,500 23.47%79-795-54-00-5460 DUES & SUBSCRIPTIONS - 39 - - - - 675 714 3,000 23.80%79-795-54-00-5462 PROFESSIONAL SERVICES 2,151 12,117 19,320 6,036 10,743 7,850 3,661 61,879 140,000 44.20%79-795-54-00-5480 UTILITIES - 172 441 615 328 429 835 2,820 14,072 20.04%79-795-54-00-5485 RENTAL & LEASE PURCHASE 95 95 155 95 95 155 95 783 3,000 26.09%79-795-54-00-5488 OFFICE CLEANING - 619 622 630 600 - 1,260 3,731 7,938 47.00%79-795-54-00-5495OUTSIDE REPAIR & MAINTENANCE- - 12 - 306 400 16 734 3,000 24.46%Supplies79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 9,475 - 602 36,275 74,584 3,823 2,226 126,986 120,000 105.82%79-795-56-00-5606 PROGRAM SUPPLIES 13,300 47,638 21,931 9,203 4,416 21,267 13,538 131,293 200,000 65.65%79-795-56-00-5607 CONCESSION SUPPLIES 350 492 1,945 779 3,380 1,348 (181) 8,113 18,000 45.07%79-795-56-00-5610 OFFICE SUPPLIES - - 52 76 247 227 210 813 3,000 27.09%79-795-56-00-5620 OPERATING SUPPLIES - 3,170 3,466 2,520 2,378 2,807 2,883 17,224 15,000 114.82%20 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202179-795-56-00-5640 REPAIR & MAINTENANCE- - 6 52 458 198 81 795 2,000 39.73%TOTAL EXPENDITURES: RECREATION DEPARTMENT81,053 111,505 90,745 100,408 142,998 111,082 72,604 710,394 1,313,535 54.08%TOTAL FUND REVENUES158,176 278,775 205,210 156,652 265,340 149,122 162,819 1,376,095 2,643,058 52.06%TOTAL FUND EXPENDITURES162,579 213,166 189,468 194,081 243,717 233,002 170,211 1,406,223 2,716,058 51.77%FUND SURPLUS (DEFICIT)(4,403) 65,610 15,742 (37,429) 21,623 (83,880) (7,392) (30,128) (73,000) LIBRARY OPERATIONS REVENUESTaxes82-000-40-00-4000 PROPERTY TAXES 36,449 366,781 11,201 30,247 312,477 11,654 5,438 774,248 776,734 99.68%82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE39,429 396,774 12,117 32,721 338,029 12,607 5,883 837,560 836,024 100.18%Intergovernmental82-000-41-00-4120 PERSONAL PROPERTY TAX2,085 - 1,519 193 - 2,531 - 6,329 5,250 120.55%82-000-41-00-4160 FEDERAL GRANTS- - - - 764 - - 764 - 0.00%82-000-41-00-4170 STATE GRANTS- - - 24,958 - - - 24,958 21,151 118.00%Fines & Forfeits82-000-43-00-4330 LIBRARY FINES557 485 238 1,215 152 1,466 228 4,340 8,500 51.06%Charges for Service82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS1,435 991 - 2,735 - 1,431 - 6,592 8,500 77.56%82-000-44-00-4422 COPY FEES271 297 - 547 287 212 107 1,722 3,800 45.31%82-000-44-00-4438 PROGRAM FEES- - - 11 - 3 7 21 - 0.00%Investment Earnings82-000-45-00-4500 INVESTMENT EARNINGS41 44 64 61 72 85 86 453 2,000 22.65%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 INCOME98 374 175 360 249 245 111 1,612 2,000 80.60%Other Financing Sources82-000-49-00-4901 TRANSFER FROM GENERAL1,775 1,775 2,139 1,775 1,775 1,774 872 11,887 26,993 44.04%TOTAL REVENUES: LIBRARY 82,141 767,522 27,453 94,824 654,234 32,009 12,733 1,670,916 1,692,702 98.71%LIBRARY OPERATIONS EXPENDITURESSalaries & Wages82-820-50-00-5010 SALARIES & WAGES17,137 17,567 19,173 21,179 21,452 32,178 21,452 150,138 286,470 52.41%82-820-50-00-5015 PART-TIME SALARIES12,796 12,339 12,568 12,770 11,441 21,376 13,189 96,480 195,544 49.34%Benefits82-820-52-00-5212RETIREMENT PLAN CONTRIBUTION1,904 1,952 2,130 2,353 2,383 3,575 2,383 16,680 32,180 51.83%82-820-52-00-5214 FICA CONTRIBUTION 2,219 2,217 2,357 2,521 2,440 4,021 2,574 18,350 35,685 51.42%82-820-52-00-5216 GROUP HEALTH INSURANCE 11,119 12,186 6,145 7,145 7,266 6,543 6,047 56,451 105,501 53.51%82-820-52-00-5222 GROUP LIFE INSURANCE - 66 - 131 - 52 47 295 377 78.36%82-820-52-00-5223 DENTAL INSURANCE - 1,439 480 554 517 517 517 4,021 7,079 56.81%82-820-52-00-5224 VISION INSURANCE 34 72 - 228 - 78 78 490 1,088 45.05%21 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 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 1,774 872 11,862 25,993 45.64%Contractual Services82-820-54-00-5412 TRAINING & CONFERENCES- - - - 20 260 - 280 3,000 9.33%82-820-54-00-5415 TRAVEL & LODGING- - - - - - 82 82 1,500 5.45%82-820-54-00-5426 PUBLISHING & ADVERTISING- - 167 - - - - 167 2,500 6.68%82-820-54-00-5440 TELECOMMUNICATIONS- 426 - 252 293 161 600 1,732 7,200 24.06%82-820-54-00-5452 POSTAGE & SHIPPING- 12 6 180 34 6 131 369 750 49.19%82-820-54-00-5460 DUES & SUBSCRIPTIONS569 1,371 1,492 13 172 1,863 155 5,634 11,000 51.22%82-820-54-00-5462 PROFESSIONAL SERVICES1,262 2,982 2,767 3,973 4,312 1,157 4,996 21,450 40,000 53.62%82-820-54-00-5466 LEGAL SERVICES- - - 2,138 - - 788 2,925 3,000 97.50%82-820-54-00-5468 AUTOMATION2,534 - 4,748 - - - 4,464 11,747 20,000 58.73%82-820-54-00-5480 UTILITIES- - 2,406 1,343 1,392 1,600 2,145 8,886 12,351 71.95%82-820-54-00-5495OUTSIDE REPAIR & MAINTENANCE1,033 2,347 5,905 2,775 270 1,635 5,977 19,942 50,000 39.88%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 554 65 2,300 8,000 28.75%82-820-56-00-5620 OPERATING SUPPLIES - 446 - - 240 36 29 750 4,000 18.76%82-820-56-00-5621 CUSTODIAL SUPPLIES - 28 103 169 289 26 692 1,306 7,000 18.66%82-820-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - 807 - 2,043 2,850 2,000 142.50%82-820-56-00-5671 LIBRARY PROGRAMMING - 26 180 - - - 97 303 2,000 15.15%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 - 69 22 363 1,500 24.22%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%82-820-99-00-8050 INTEREST PAYMENT - 51,775 - - - - - 51,775 103,550 50.00%TOTAL FUND REVENUES 82,141 767,522 27,453 94,824 654,234 32,009 12,733 1,670,916 1,692,702 98.71%TOTAL FUND EXPENDITURES 52,721 118,916 63,548 59,939 55,969 77,482 69,446 498,020 1,709,443 29.13%FUND SURPLUS (DEFICIT)29,420 648,606 (36,095) 34,884 598,266 (45,473) (56,713) 1,172,896 (16,741) LIBRARY CAPITAL REVENUES84-000-42-00-4214 DEVELOPMENT FEES10,300 10,300 13,150 16,650 9,750 11,800 13,250 85,200 50,000 170.40%84-000-45-00-4500 INVESTMENT EARNINGS13 14 16 16 16 18 17 111 200 55.45%22 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202184-000-48-00-4850 MISCELLANEOUS INCOME- 31 - - - - - 31 - 0.00%TOTAL REVENUES: LIBRARY CAPITAL10,313 10,346 13,166 16,666 9,766 11,818 13,267 85,342 50,200 170.00%LIBRARY CAPITAL EXPENDITURES84-840-54-00-5460 E-BOOK SUBSCRIPTIONS- - - - - - - - 3,500 0.00%84-840-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - - - 9,600 9,600 15,000 64.00%84-840-56-00-5683 AUDIO BOOKS - 20 265 231 210 425 888 2,039 3,500 58.24%84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - 34 - 34 500 6.80%84-840-56-00-5685 DVD'S - 121 181 261 241 204 163 1,172 3,000 39.07%84-840-56-00-5686 BOOKS - 2,239 1,090 2,386 4,892 1,134 4,226 15,968 50,000 31.94%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 11,818 13,267 85,342 50,200 170.00%TOTAL FUND EXPENDITURES - 2,380 1,537 3,743 5,343 1,798 14,878 29,679 95,500 31.08%FUND SURPLUS (DEFICIT) 10,313 7,965 11,629 12,922 4,423 10,020 (1,611) 55,664 (45,300) COUNTRYSIDE TIF REVENUES87-000-40-00-4000 PROPERTY TAXES - 56,774 573 - 168,913 24,104 2 250,366 260,727 96.03%TOTAL REVENUES: COUNTRYSIDE TIF - 56,774 573 - 168,913 24,104 2 250,366 260,727 96.03%COUNTRYSIDE TIF EXPENDITURESContractual Services87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK948 948 948 948 948 948 948 6,639 11,381 58.33%87-870-54-00-5462 PROFESSIONAL SERVICES- - - - - - 187 187 2,000 9.33%87-870-54-00-5498 PAYING AGENT FEES- - 126 - - - - 126 700 17.95%2015A Bond87-870-77-00-8000 PRINCIPAL PAYMENT - - - - - - 112,455 112,455 112,455 100.00%87-870-77-00-8050 INTEREST PAYMENT 23,073 - - - - - 23,073 46,146 46,146 100.00%2014 Refunding Bond87-870-93-00-8050 INTEREST PAYMENT 25,358 - - - - - 25,358 50,715 50,715 100.00%TOTAL FUND REVENUES- 56,774 573 - 168,913 24,104 2 250,366 260,727 96.03%TOTAL FUND EXPENDITURES49,379 948 1,074 948 948 948 162,021 216,268 223,397 96.81%FUND SURPLUS (DEFICIT)(49,379) 55,825 (501) (948) 167,964 23,156 (162,019) 34,098 37,330 DOWNTOWN TIF REVENUES88-000-40-00-4000PROPERTY TAXES7,651 48,602 1,303 590 37,770 349 530 96,795 70,000 138.28%TOTAL REVENUES: DOWNTOWN TIF 7,651 48,602 1,303 590 37,770 349 530 96,795 70,000 138.28%DOWNTOWN TIF EXPENDITURESContractual Services88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK2,918 2,918 2,918 2,918 2,918 2,918 2,918 20,428 35,020 58.33%88-880-54-00-5425 TIF INCENTIVE PAYOUT- - - - - 36,562 - 36,562 27,820 131.42%23 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2022 ACCOUNT NUMBER DESCRIPTION May-21 June-21 July-21 August-21 September-21 October-21 November-21Totals BUDGET % of BudgetUNITED CITY OF YORKVILLEFISCAL YEAR 2022 BUDGET REPORTFor the Month Ended November 30, 202188-880-54-00-5462 PROFESSIONAL SERVICES- 330 - - - - 269 599 5,000 11.98%Capital Outlay88-880-60-00-6000 PROJECT COSTS- - - - - - - - 10,000 0.00%88-880-60-00-6079 ROUTE 47 EXPANSION624 624 624 624 624 624 624 4,368 7,488 58.33%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 349 530 96,795 70,000 138.28%TOTAL FUND EXPENDITURES3,542 209,956 3,542 3,542 3,542 40,104 3,812 268,041 291,412 91.98%FUND SURPLUS (DEFICIT)4,109 (161,354) (2,239) (2,953) 34,227 (39,755) (3,281) (171,246) (221,412) DOWNTOWN TIF II REVENUES89-000-40-00-4000 PROPERTY TAXES1,405 40,247 1,309 319 32,018 262 3,204 78,764 48,526 162.31%TOTAL REVENUES: DOWNTOWN TIF II1,405 40,247 1,309 319 32,018 262 3,204 78,764 48,526 162.31%DOWNTOWN TIF II EXPENDITURES89-890-54-00-5425TIF INCENTIVE PAYOUT17,500 - 1,805 - - - 17,500 36,805 25,500 144.33%89-890-54-00-5462 PROFESSIONAL SERVICES- 88 - 55 - 198 269 610 5,000 12.20%TOTAL FUND REVENUES1,405 40,247 1,309 319 32,018 262 3,204 78,764 48,526 162.31%TOTAL FUND EXPENDITURES17,500 88 1,805 55 - 198 17,769 37,415 30,500 122.67%FUND SURPLUS (DEFICIT)(16,095) 40,159 (496) 264 32,018 64 (14,565) 41,349 18,026 24 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) REVENUES Property Taxes 23,991$ 3,415,461$ 99.69% 3,426,246$ 3,327,913$ 2.63% Municipal Sales Tax 356,893 2,534,191 70.74% 3,582,508 1,942,081 30.49% Non-Home Rule Sales Tax 288,924 1,983,392 74.86% 2,649,473 1,424,640 39.22% Electric Utility Tax - 349,427 48.87%715,000 348,789 0.18% Natural Gas Tax 14,711 131,960 48.87%270,000 103,510 27.49% Excise (Telecommunication) Tax 16,829 120,360 57.59%209,000 146,344 -17.76% Cable Franchise Fees 66,594 214,789 71.60%300,000 205,440 4.55% Hotel Tax 6,412 81,738 102.17% 80,000 39,360 107.67% Video Gaming Tax 18,046 134,380 95.99%140,000 47,492 182.95% Amusement Tax 74,478 173,904 139.12%125,000 65,287 166.37% State Income Tax 155,634 1,570,860 67.22% 2,336,774 1,257,844 24.89% Local Use Tax 59,258 398,742 42.53%937,660 454,556 -12.28% Road & Bridge Tax 461 54,872 99.81%54,975 52,363 4.79% Building Permits 76,006 622,321 138.29%450,000 416,314 49.48% Garbage Surcharge 113 723,397$ 52.57%1,376,063 670,023 7.97% Investment Earnings 537 6,585$ 32.92% 20,000$ 9,467 -30.45% MOTOR FUEL TAX FUND (15) REVENUES Motor Fuel Tax 35,230$ 260,408$ 53.97% 482,526$ 229,084$ 13.67% Transportation Renewal Funds 25,350 186,543 53.82%346,618 160,940 15.91% WATER FUND (51) REVENUES Water Sales 3,598$ 1,875,928$ 54.97%3,412,500$ 1,815,464$ 3.33% Water Infrastructure Fees 400 424,710 51.79%820,000 407,946 4.11% Water Connection Fees 3,700 246,808 107.31%230,000 439,677 -43.87% Water Meter Sales 15,325 159,945 266.58%60,000 148,620 7.62% SEWER FUND (52) REVENUES Sewer Maintenance Fees 201$ 531,120$ 50.31%1,055,596$ 510,125$ 4.12% Sewer Infrastructure Fees 184 207,592 52.55%395,000 196,027 5.90% Sewer Connection Fees 15,000 161,000 79.19%203,300 203,100 -20.73% PARKS & RECREATION (79) REVENUES Special Events 7,005$ 70,619$ 78.47%90,000$ 5,430$ 1200.53% Child Development 11,834 68,699 47.38%145,000 32,938 108.57% Athletics & Fitness 14,361 144,681 39.10%370,000 113,598 27.36% Rental Income 700 61,349 92.66% 66,209 54,976 11.59% Hometown Days 6,102 145,676 121.40%120,000 1,675 8597.05% *November represents 58% of fiscal year 2022 UNITED CITY OF YORKVILLE MONTHLY ANALYSIS OF MAJOR REVENUES For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 25 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes 23,991$ 3,415,461$ 99.69% 3,426,246$ 3,327,913$ 2.63% Municipal Sales Tax 356,893 2,534,191 70.74% 3,582,508 1,942,081 30.49% Non-Home Rule Sales Tax 288,924 1,983,392 74.86% 2,649,473 1,424,640 39.22% Electric Utility Tax - 349,427 48.87% 715,000 348,789 0.18% Natural Gas Tax 14,711 131,960 48.87% 270,000 103,510 27.49% Excise (Telecommunication) Tax 16,829 120,360 57.59% 209,000 146,344 -17.76% Telephone Utility Tax 695 4,865 58.33%8,340 4,865 0.00% Cable Franchise Fees 66,594 214,789 71.60% 300,000 205,440 4.55% Hotel Tax 6,412 81,738 102.17% 80,000 39,360 107.67% Video Gaming Tax 18,046 134,380 95.99% 140,000 47,492 182.95% Amusement Tax 74,478 173,904 139.12% 125,000 65,287 166.37% Admissions Tax - 148,662 102.53% 145,000 58,105 155.85% Business District Tax 40,941 304,879 72.25% 421,950 222,685 36.91% Auto Rental Tax 1,569 10,742 65.10% 16,500 7,355 46.05% Total Taxes 910,084$ 9,608,750$ 79.48% 12,089,017$ 7,943,867$ 20.96% Intergovernmental State Income Tax 155,634$ 1,570,860$ 67.22% 2,336,774$ 1,257,844$ 24.89% Local Use Tax 59,258 398,742 42.53% 937,660 454,556 -12.28% Cannabis Exise Tax 2,463 16,569 84.56% 19,596.00 7,013 136.26% Road & Bridge Tax 461 54,872 99.81% 54,975 52,363 4.79% Personal Property Replacement Tax - 19,098 115.74% 16,500 9,124 109.31% Other Intergovernmental 4,796 267,117 736.37% 36,275 848,454 -68.52% Total Intergovernmental 222,613$ 2,327,259$ 68.41% 3,401,780$ 2,629,355$ -11.49% Licenses & Permits Liquor Licenses 200$ 6,864$ 10.56% 65,000$ 23,704$ -71.04% Building Permits 76,006 622,321 138.29% 450,000 416,314 49.48% Other Licenses & Permits - 3,988 41.97%9,500 5,574 -28.47% Total Licenses & Permits 76,206$ 633,172$ 120.72% 524,500$ 445,592$ 42.10% Fines & Forfeits Circuit Court Fines 3,948$ 24,907$ 71.16% 35,000$ 14,378$ 73.24% Administrative Adjudication 2,750 12,656 47.76% 26,500 7,527 68.14% Police Tows 7,500 38,000 69.09% 55,000 38,500 -1.30% Other Fines & Forfeits 35 360 102.86%350 215 67.44% Total Fines & Forfeits 14,233$ 75,924$ 64.98% 116,850$ 60,620$ 25.25% Charges for Services ^Garbage Surcharge 113$ 723,397$ 52.57% 1,376,063$ 670,023$ 7.97% ^Late PMT Penalties - Garbage 6 14,347 68.32% 21,000 52 27363.40% ^UB Collection Fees 15,771 103,057 62.46% 165,000 94,251 9.34% Administrative Chargebacks 18,213 127,493 58.33% 218,560 124,773 2.18% Other Services - 2,453 490.50%500 - 0.00% Total Charges for Services 34,103$ 970,747$ 54.50% 1,781,123$ 889,099$ 9.18% Investment Earnings 537$ 6,585$ 32.92% 20,000$ 9,467$ -30.45% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 26 November 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 November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ 1,009$ 10.09% 10,000$ 5,153$ -80.42% Other Reimbursements 15,057 22,476 83.24% 27,000 27,971 -19.64% Rental Income 500 3,390 48.43%7,000 2,000 69.50% Miscellaneous Income & Transfers In 3,000 38,014 30.91% 123,000 80,553 -52.81% Total Miscellaneous 18,557$ 64,889$ 38.86% 167,000$ 115,676$ -43.90% Total Revenues and Transfers 1,276,332$ 13,687,325$ 75.62% 18,100,270$ 12,093,677$ 13.18% Expenditures Administration 56,121$ 485,667$ 48.74%996,443$ 540,332$ -10.12% 50 Salaries 36,755 311,190 49.67% 626,473 355,117 -12.37% 52 Benefits 9,457 93,701 46.59% 201,133 124,508 -24.74% 54 Contractual Services 9,082 75,552 47.57% 158,837 53,652 40.82% 56 Supplies 827 5,225 52.25% 10,000 7,055 -25.94% Finance 42,163$ 325,402$ 58.38%557,390$ 314,040$ 3.62% 50 Salaries 23,373 186,130 56.97% 326,735 181,969 2.29% 52 Benefits 7,504 63,999 57.72% 110,880 69,645 -8.11% 54 Contractual Services 10,664 74,293 63.35% 117,275 60,093 23.63% 56 Supplies 623 981 39.25%2,500 2,333 -57.94% Police 349,853$ 4,032,876$ 65.48%6,158,904$ 3,829,531$ 5.31% Salaries 246,607 1,880,092 56.23% 3,343,778 1,850,647 1.59% Overtime 1,810 48,210 43.43% 111,000 43,440 10.98% 52 Benefits 73,673 1,924,188 86.15% 2,233,424 1,768,463 8.81% 54 Contractual Services 20,119 142,380 40.02% 355,804 130,309 9.26% 56 Supplies 7,645 38,006 33.08% 114,898 36,672 3.64% Community Development 76,971$ 547,574$ 55.28%990,515$ 458,841$ 19.34% 50 Salaries 42,744 324,128 57.71% 561,611 315,125 2.86% 52 Benefits 14,757 122,084 62.71% 194,672 113,635 7.44% 54 Contractual Services 18,844 97,368 43.67% 222,980 21,245 358.32% 56 Supplies 626 3,994 35.49% 11,252 8,836 -54.80% PW - Street Ops & Sanitation 212,014$ 1,161,290$ 43.83%2,649,285$ 1,116,480$ 4.01% Salaries 34,727 267,087 46.51% 574,297 263,062 1.53% Overtime 325 2,039 9.06% 22,500 830 145.68% 52 Benefits 16,270 137,642 50.31% 273,580 124,223 10.80% 54 Contractual Services 148,260 720,388 43.70% 1,648,528 697,198 3.33% 56 Supplies 12,433 34,134 26.18% 130,380 31,166 9.52% Administrative Services 706,874$ 3,310,712$ 49.06%6,747,733$ 2,528,869$ 30.92% 50 Salaries - 2,453 490.60%500 4,425 -44.56% 52 Benefits 17,438 294,946 72.38% 407,520 257,171 14.69% 54 Contractual Services 465,462 1,435,971 43.88% 3,272,288 1,048,919 36.90% 56 Supplies - - 0.00% 15,000 - 0.00% 70 Contingency - - 0.00% 44,000 - 0.00% 99 Transfers Out 223,974 1,577,343 52.43% 3,008,425 1,218,355 29.46% Total Expenditures and Transfers 1,443,996$ 9,863,522$ 54.49% 18,100,270$ 8,788,093$ 12.24% Surplus(Deficit)(167,665)$ 3,823,803$ -$ 3,305,584$ ^modified accruals basis *November represents 58% of fiscal year 2022 50 50 27 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales 3,598$ 1,875,928$ 54.97% 3,412,500$ 1,815,464$ 3.33% ^ Water Infrastructure Fees 400 424,710 51.79% 820,000 407,946 4.11% ^ Late Penalties 25 70,729 60.77% 116,394 458 15353.88% Water Connection Fees 3,700 246,808 107.31% 230,000 439,677 -43.87% Bulk Water Sales - - 0.00% 5,000 (1,950) -100.00% Water Meter Sales 15,325 159,945 266.58% 60,000 148,620 7.62% Total Charges for Services 23,048$ 2,778,120$ 59.82% 4,643,894$ 2,810,215$ -1.14% Investment Earnings 134$ 1,397$ 46.57% 3,000$ 1,060$ 31.77% Reimbursements/Miscellaneous/Transfers In Reimbursements 2,920$ 2,920$ 0.00%-$ 11,628$ -74.89% Rental Income 8,557 59,327 57.80% 102,644 58,107 2.10% Miscellaneous Income & Transfers In 15,019 105,595 33.87% 311,733 104,819 0.74% Total Miscellaneous 26,496$ 167,842$ 40.50% 414,377$ 174,553$ -3.84% Total Revenues and Transfers 49,678$ 2,947,359$ 58.23% 5,061,271$ 2,985,829$ -1.29% Expenses Water Operations Salaries 35,403$ 272,916$ 52.91% 515,856$ 267,334$ 2.09% Overtime 644 3,740 17.00% 22,000 3,972 -5.83% 52 Benefits 20,098 167,785 68.88% 243,593 143,782 16.69% 54 Contractual Services 107,968 556,591 51.84% 1,073,649 393,165 41.57% 56 Supplies 53,961 236,720 63.94% 370,225 209,593 12.94% 60 Capital Outlay 69,493$ 611,058$ 29.95%2,040,580$ 200,928$ 204.12% Well Rehabilitations & Water Tower Painting 2,195 2,195 1.04% 212,000 Road to Better Roads Program 38,521 553,433 58.26% 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 26,467 58.33% 45,372 Cation Exhange Media Replacement - - 0.00% 216,000 Vehicles & Equipment 24,996 28,964 5.14% 563,000 Debt Service 376,672$ 540,814$ 29.78% 1,815,830$ 560,469$ -3.51% 2015A Bond 376,672 440,799 100.00% 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 664,237$ 2,389,624$ 39.29% 6,081,733$ 1,779,243$ 34.31% Surplus(Deficit)(614,559)$ 557,736$ (1,020,462)$ 1,206,586$ ^modified accruals basis *November represents 58% of fiscal year 2022 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 Charges for Services 89 50 6025 6059 6022 6066 6081 6079 6070 77 85 94 28 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 201$ 531,120$ 50.31% 1,055,596$ 510,125$ 4.12% ^Sewer Infrastructure Fees 184 207,592 52.55% 395,000 196,027 5.90% ^Late Penalties 3 9,746 61.08% 15,957 54 17832.77% Sewer Connection Fees 15,000 161,000 79.19% 203,300 203,100 -20.73% Total Charges for Services 15,388$ 909,458$ 54.46% 1,669,853$ 909,306$ 0.02% Investment Earnings 40$ 3,047$ 203.12% 1,500$ 414$ 635.55% Reimbursements/Miscellaneous/Transfers In Miscellaneous Income & Transfers In 44,995 305,099 50.49% 604,249 106,549 186.35% Total Miscellaneous 44,995$ 305,099$ 50.49% 604,249$ 106,549$ 186.35% Total Revenues and Transfers 60,423$ 1,217,604$ 53.51% 2,275,602$ 1,016,269$ 19.81% Expenses Sewer Operations Salaries 19,725$ 148,576$ 53.38% 278,333$ 145,549$ 2.08% Overtime 66 483 96.66%500 88 447.23% 52 Benefits 9,270 79,790 52.58% 151,754 85,028 -6.16% 54 Contractual Services 12,892 86,501 40.30% 214,665 136,233 -36.51% 56 Supplies 8,362 24,427 37.26% 65,563 16,828 45.15% 60 Capital Outlay 1,873$ 56,897$ 16.67% 341,309$ 156,634$ -63.67% SCADA - 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 13,114 58.32% 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$ 44,144$ 58.33% 75,675$ 43,823$ 0.73% Total Expenses and Transfers 58,494$ 556,208$ 22.90% 2,428,579$ 722,083$ -22.97% Surplus(Deficit)1,929$ 661,396$ (152,977)$ 294,186$ ^modified accruals basis *November represents 58% of fiscal year 2022 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 6070 Charges for Services 50 6001 6059 6066 6079 90 92 29 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 7,005$ 70,619$ 78.47% 90,000$ 5,430$ 1200.53% Child Development 11,834 68,699 47.38% 145,000 32,938 108.57% Athletics & Fitness 14,361 144,681 39.10% 370,000 113,598 27.36% Concession Revenue - 22,598 50.22% 45,000 4,642 386.85% Total Charges for Services 33,200$ 306,597$ 47.17% 650,000$ 156,608$ 95.77% Investment Earnings 5$ 55$ 21.90%250$ 211$ -74.03% Reimbursements/Miscellaneous/Transfers In Reimbursements 2,933$ 3,991$ 0.00%-$ 5,040$ -20.82% Rental Income 700 61,349 92.66% 66,209 54,976 11.59% Park Rentals 609 9,208 52.62% 17,500 1,631 464.66% Hometown Days 6,102 145,676 121.40% 120,000 1,675 8597.05% Sponsorships & Donations - 7,200 48.00% 15,000 3,022 138.25% Miscellaneous Income & Transfers In 119,571 842,020 47.46% 1,774,099 768,676 9.54% Total Miscellaneous 129,914$ 1,069,443$ 53.67% 1,992,808$ 835,020$ 28.07% Total Revenues and Transfers 163,119$ 1,376,095$ 52.06% 2,643,058$ 991,838$ 38.74% Expenditures Parks Department 97,606$ 695,829$ 49.61%1,402,523$ 586,698$ 18.60% Salaries 49,671 383,864 53.15% 722,209 359,351 6.82% Overtime 548 3,279 65.58%5,000 1,914.08 71.30% 52 Benefits 20,378 178,503 57.17% 312,212 167,812 6.37% 54 Contractual Services 6,382 30,401 17.57% 173,058 19,217 58.20% 56 Supplies 20,627 99,782 52.50% 190,044 38,403 159.83% Recreation Department 72,604$ 710,394$ 54.08%1,313,535$ 498,336$ 42.55% 50 Salaries 34,371 247,441 48.97% 505,253 237,903 4.01% 52 Benefits 11,082 93,141 46.63% 199,752 94,590 -1.53% 54 Contractual Services 8,394 84,589 33.76% 250,530 49,826 69.77% 56 Hometown Days 2,226 126,986 105.82% 120,000 12,425 922.02% 56 Supplies 16,531 158,238 66.49% 238,000 103,592 52.75% Total Expenditures 170,210$ 1,406,223$ 51.77% 2,716,058$ 1,085,034$ 29.60% Surplus(Deficit)(7,091)$ (30,128)$ (73,000)$ (93,196)$ *November represents 58% of fiscal year 2022 YORKVILLE PARKS & RECREATION STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 50 30 November YTD % of FY 2022 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 11,321$ 1,611,808$ 99.94% 1,612,758$ 1,561,523$ 3.22% Intergovernmental Personal Property Replacement Tax -$ 6,329$ 120.55%5,250$ 3,024$ 109.31% State Grants - 25,722 121.61% 21,151 21,151 21.61% Total Intergovernmental -$ 32,051$ 121.40% 26,401$ 24,175$ 32.58% Library Fines 228$ 4,340$ 51.06%8,500$ 2,228$ 94.84% Charges for Services Library Subscription Cards -$ 6,592$ 77.56%8,500$ 2,831$ 132.88% Copy Fees 107 1,722 0.00%-$ 732$ 135.06% Program Fees 7 21 0.56%3,800 2 970.00% Total Charges for Services 114$ 8,335$ 67.77% 12,300$ 3,565$ 133.80% Investment Earnings 86$ 808$ 40.38%2,000$ 934$ -13.53% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.00%-$ -$ 0.00% Rental Income - 75 4.29%1,750 - 0.00% Miscellaneous Income 111 1,612 80.60%2,000 374 330.63% Transfer In 872 11,887 44.04% 26,993 17,124 -30.58% Total Miscellaneous & Transfers 983$ 13,574$ 44.15% 30,743$ 17,499$ -22.43% Total Revenues and Transfers 12,733$ 1,670,916$ 98.71% 1,692,702$ 1,609,924$ 3.79% Expenditures Library Operations 69,446$ 498,020$ 29.13%1,709,443$ 511,708$ -2.67% 50 Salaries 34,642 246,618 51.16% 482,014 261,692 -5.76% 52 Benefits 12,520 108,514 51.94% 208,903 107,531 0.91% 54 Contractual Services 19,337 74,902 48.96% 153,001 62,818 19.24% 56 Supplies 2,948 7,873 31.12% 25,300 8,622 -8.69% 99 Debt Service - 60,113 7.15% 840,225 71,044 -15.39% Total Expenditures and Transfers 69,446$ 498,020$ 29.13% 1,709,443$ 511,708$ -2.67% Surplus(Deficit)(56,713)$ 1,172,896$ (16,741)$ 1,098,216$ *November represents 58% of fiscal year 2022 YORKVILLE PUBLIC LIBRARY STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended November 30, 2021 * Fiscal Year 2021 For the Month Ended Nov 30, 2020 31 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 1TIME: 09:21:02 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. 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.00GJ-210503FC 05/05/2021 01 Flex Cobra - Mar 2021 110.00AP-210525B 05/19/2021 09 05/04/21 EDC MEETING MINUTES MARLYS J. YOUNG 534716 050421 42.00GJ-210528FC 06/01/2021 01 Flex Cobra - May 2021 50.00_________________________________TOTAL PERIOD 01 ACTIVITY 202.00 0.0002 GJ-210531FX 07/06/2021 01 Flex Cobra - May 2021 75.00AP-210608A 06/02/2021 22 MAY 25 CITY COUNCIL MEETING CHRISTINE M. VITOSH 534812 CMV 2017 180.00AP-210622B 06/15/2021 18 05/18/21 PW MEETING MINUTES MARLYS J. YOUNG 534904 051821 53.75AP-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.0003 AP-2101725M 07/26/2021 11 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900107 072521-B.OLSON 209.96AP-210713B 07/07/2021 47 MOBILE VENDOR BACKGROUND ILLINOIS STATE POLIC 534956 053121 84.7507/07/2021 48 06/09/21 P&Z MEETING MINUTES MARLYS J. YOUNG 535012 060921 50.00AP-210727 07/20/2021 09 06/15/21 PW MEETING MINUTES MARLYS J. YOUNG 535107 061521 49.5007/20/2021 10 06/16/21 ADMIN MEETING MINUTES MARLYS J. YOUNG 535107 061621 54.25GJ-210731FX 08/03/2021 01 FLEX - COBRA NOTICES JULY 2021 50.00_________________________________TOTAL PERIOD 03 ACTIVITY 498.46 0.0004 AP-210810 08/04/2021 13 SOLICITOR BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 480.2508/04/2021 14 MOBILE VENDOR BACKGROUND ILLINOIS STATE POLIC 535142 063021 56.50GJ-210816FE 08/25/2021 01 CLERK'S ACCOUNT-ANALYSIS FEE 5.40AP-210824 08/17/2021 15 07/01/21 PUBLIC SAFETY MEETING MARLYS J. YOUNG 535262 070121 59.2508/17/2021 16 07/21/21 PW MEETING MINUTES MARLYS J. YOUNG 535262 072121 41.75AP-210825M 08/19/2021 12 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900108 082521-B.OLSON 209.9608/19/2021 13 GIFT OF HOPE-DONATION ON FIRST NATIONAL BANK 900108 082521-R.FREDRICKSON 500.00GJ-210831FC 09/08/2021 01 FLEX COBRA NOTICES - JULY 2021 60.00_________________________________TOTAL PERIOD 04 ACTIVITY 1,413.11 0.0005 AP-210914 09/07/2021 19 08/12 PUBLIC SAFETY MEETING MARLYS J. YOUNG 535349 081221 45.75GJ-210915FE 10/11/2021 01 CLERK'S ACCT - ANALYSIS CHARGE 16.50AP-210925M 09/20/2021 09 ZOOM-MONTHLY USAGE FEE FIRST NATIONAL BANK 900109 092521-B.OLSON 209.96GJ-210928FC 11/18/2021 01 FLEX COBRA INV FBS-231547-AUG 50.00_________________________________TOTAL PERIOD 05 ACTIVITY 322.21 0.0006 AP-211012 10/07/2021 16 LIQUOR LICENSE BACKGROUND ILLINOIS STATE POLIC 535476 083121 28.2510/07/2021 17 MASSAGE LICENSE BACKGROUND ILLINOIS STATE POLIC 535477 083121 28.2510/07/2021 18 EMPLOYMENT BACK GROUND CHECK ILLINOIS STATE POLIC 535477 083121 28.25AP-211025M 10/20/2021 13 ZOOM-08/23-09/22 USER FEES FIRST NATIONAL BANK 900110 102521-B.OLSON 209.9610/20/2021 14 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900110 102521-E.WILLRETT 45.00AP-211026 10/19/2021 30 09/21/21 PW MEETING MINUTES MARLYS J. YOUNG 535624 092121 53.75_________________________________TOTAL PERIOD 06 ACTIVITY 393.46 0.0007 GJ-211101FC 11/02/2021 01 FLEX COBRA NOTICES - SEPT 2021 50.00AP-211109 11/03/2021 09 08/17/21 PW MEETING MINUTES MARLYS J. YOUNG 535731 081721 39.2511/03/2021 10 10/05/21 EDC MEETING MINUTES MARLYS J. YOUNG 535731 100521 55.0011/03/2021 11 10/19/21 PW MEETING MINUTES MARLYS J. YOUNG 535731 101921 46.20 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 2TIME: 09:21:02 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________07 AP-211109 11/03/2021 12 10/20/21 ADMIN MEETING MINUTES MARLYS J. YOUNG 535731 102021 41.25AP-211123 11/15/2021 12 NOTARY RENEWAL REIMBURSEMENT KATELYN GREGORY 535760 110421-NOTARY 10.0011/15/2021 13 10/21/21 MEETING MINUTES MARLYS J. YOUNG 535799 102121 85.00AP-211125M 11/17/2021 14 ZOOM-09/23-11/22 USAGE FEES FIRST NATIONAL BANK 900111 112521-B.OLSON 209.9611/17/2021 15 CNA-NOTARY RENEWAL FIRST NATIONAL BANK 900111 112521-K.GREGORY 30.00GJ-211130FC 12/03/2021 01 FLEX COBRA NOTICES - OCT 2021 50.00_________________________________TOTAL PERIOD 07 ACTIVITY 616.66 0.00YTD BUDGET 7,000.00 TOTAL ACCOUNT ACTIVITY 3,964.61 0.00ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 3,964.61_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00GJ-053121FE 07/14/2021 01 UB WSB LOCKBOX FEES - MAY 2020 152.51GJ-210531FE 05/27/2021 01 UB CC Fees - Apr 2021 2,110.1205/27/2021 07 UB Paymentus Fee-Apr 2021 1,399.6305/27/2021 13 FNBO Analysis Chrg-Apr 2021 312.77_________________________________TOTAL PERIOD 01 ACTIVITY 3,975.03 0.0002 GJ-063021FE 08/05/2021 01 UB WSB LOCKBOX FEE - JUN 2021 87.23GJ-210630FE 06/24/2021 01 UB CC Fees - May 2021 1,767.7006/24/2021 07 UB Paymentus Fees - May 2021 1,089.5606/24/2021 13 FNBO Analysis Chrg - May 2021 326.38_________________________________TOTAL PERIOD 02 ACTIVITY 3,270.87 0.0003 GJ-073121FE 10/12/2021 01 UB WSB LOCKBOX FEES-JULY 2021 160.12AP-2101725M 07/26/2021 18 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 43.00AP-210713B 07/07/2021 63 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 89.37AP-210726M 07/26/2021 01 2021 PCORI FEE UNITED STATES TREASU 535111 2021 PCORI 159.60AP-210727 07/20/2021 32 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 33.96GJ-210731FE 07/27/2021 01 UB CC Fees - June 2021 873.2307/27/2021 07 UB Paymentus Fees - June 2021 1,488.5007/27/2021 13 FNBO Analysis Chrg - June 2021 373.93_________________________________TOTAL PERIOD 03 ACTIVITY 3,221.71 0.0004 GJ-083121FE 10/12/2021 01 UB WSB LOCKBOX FEES-AUG 2021 69.27AP-210810 08/04/2021 23 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 233.56GJ-210831FE 08/24/2021 01 UB CC Fees - July 2021 1,631.7508/24/2021 07 UB Paymentus Fees - July 2021 1,175.3208/24/2021 13 UB Analysis Fees - July 2021 316.45_________________________________TOTAL PERIOD 04 ACTIVITY 3,426.35 0.0005 GJ-093021FE 10/11/2021 01 UB WSB LOCKBOX FEES 167.80AP-210914 09/07/2021 34 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 91.73GJ-210930FE 09/22/2021 01 UB CC Fees - Aug 2021 1,037.5309/22/2021 07 UB Paymentus Fees - Aug 2021 1,516.6709/22/2021 13 FNBO Analysis Chrg - Aug 2021 342.60_________________________________TOTAL PERIOD 05 ACTIVITY 3,156.33 0.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 3TIME: 09:21:05 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________06 GJ-103121FE 11/04/2021 01 UB WSB LOCKBOX FEE - OCT 2021 54.97AP-211026 10/19/2021 54 PREPARATION OF ACUARIAL MWM CONSULTING GROUP 535591 290920 6,400.0010/19/2021 55 PREPARATION OF GASB#75 MWM CONSULTING GROUP 535592 290921 4,000.00GJ-211031FE 10/25/2021 01 UB CC Fees - Sept 2021 409.9410/25/2021 07 UB Paymentus Fees - Sept 2021 1,138.6410/25/2021 13 FNBO Analysis Charge-Sept 2021 310.52_________________________________TOTAL PERIOD 06 ACTIVITY 12,314.07 0.0007 GJ-113021FE 12/03/2021 01 UB WSB LOCKBOX FEE 146.97AP-211109 11/03/2021 24 MYGOVHUB FEES - SEPT 2021 HARRIS COMPUTER SYST 535665 MSIXT0000139 237.9311/03/2021 25 PUBLIC OFFICIAL BOND RENEWAL - MESIROW INSURANCE SE 535694 1788108 500.00AP-211123 11/15/2021 37 MYGOVHUB FEES-OCT 2021 HARRIS COMPUTER SYST 535761 MSIXT0000158 93.96AP-211125M 11/17/2021 27 IGFOA-CERTIFICATE OF FIRST NATIONAL BANK 900111 112521-R.FREDRICKSON 530.00GJ-211130FE 12/01/2021 01 UB CC Fees - Oct 2021 935.3012/01/2021 07 UB Paymentus Fees - Oct 2021 1,582.3512/01/2021 13 FNBO Analysis Chrg - Oct 2021 362.25_________________________________TOTAL PERIOD 07 ACTIVITY 4,388.76 0.00YTD BUDGET 37,916.69 TOTAL ACCOUNT ACTIVITY 33,753.12 0.00ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 33,753.12_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-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.0002 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.0003 AP-2101725M 07/26/2021 27 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 133.0007/26/2021 28 SHRED IT-MAY 2021 SHREDDING FIRST NATIONAL BANK 900107 072521-N.DECKER 202.3307/26/2021 29 ACCURINT-MAY 2021 SEARCHES FIRST NATIONAL BANK 900107 072521-N.DECKER 150.00_________________________________TOTAL PERIOD 03 ACTIVITY 485.33 0.0004 AP-210810 08/04/2021 30 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 56.50AP-210825M 08/19/2021 33 SHRED IT-07/05 SHREDDING FIRST NATIONAL BANK 900108 082521-N.DECKER 203.2108/19/2021 34 ACCURINT-JUN 2021 SEARCHES FIRST NATIONAL BANK 900108 082521-N.DECKER 150.0008/19/2021 35 SHRED IT-07/26 SHREDDING FIRST NATIONAL BANK 900108 082521-N.DECKER 204.1008/19/2021 36 KENDALL PRINTING-PATROLL & FIRST NATIONAL BANK 900108 082521-N.DECKER 291.20_________________________________TOTAL PERIOD 04 ACTIVITY 905.01 0.0005 AP-210928 09/21/2021 31 MONTHLY COURTSMART PUBLICATION DALE ANDERSON 535399 INV-0374 1,280.0009/21/2021 32 2 PHOTO ID CARDS P.F. PETTIBONE & CO. 535415 180996 34.0009/21/2021 33 APPLICANT POLYGRAPH TROTSKY INVESTIGATIV 535435 PD 21-02 155.00_________________________________TOTAL PERIOD 05 ACTIVITY 1,469.00 0.0006 AP-211025M 10/20/2021 28 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900110 102521-E.WILLRETT 45.00_________________________________TOTAL PERIOD 06 ACTIVITY 45.00 0.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 4TIME: 09:21:08 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________07 AP-211109 11/03/2021 42 OFFENDER REGISTRATION SYSTEM BARCA ENTERPRISES, I 535636 300204 480.0011/03/2021 43 DIGITAL PHOTO ID-WARREN P.F. PETTIBONE & CO. 535703 181097 18.00AP-211125M 11/17/2021 38 PHYSICIANS CARE-DRUG SCREEN FIRST NATIONAL BANK 900111 112521-E.WILLRETT 45.0011/17/2021 39 ACCURINT-AUG 2021 SEARCHES FIRST NATIONAL BANK 900111 112521-K.BALOG 280.7511/17/2021 40 ACCURINT-JUL 2021 SEARCHES FIRST NATIONAL BANK 900111 112521-K.BALOG 150.00_________________________________TOTAL PERIOD 07 ACTIVITY 973.75 0.00YTD BUDGET 23,304.19 TOTAL ACCOUNT ACTIVITY 9,478.09 0.00ANNUAL REVISED BUDGET 39,950.00 ENDING BALANCE 9,478.09_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-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.0002 AP-210608A 06/02/2021 45 KENDALL COUNTY DATABASE RECORD INFORMATION S 534803 50179 575.00AP-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.0003 AP-2101725M 07/26/2021 45 ADOBE-CREATIVE CLOUD FEE FIRST NATIONAL BANK 900107 072521-J.ENGBERG 52.9907/26/2021 46 IWORDQ-INTERNET SOFTWARE FIRST NATIONAL BANK 900107 072521-K.BARKSDALE 4,750.0007/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.0004 AP-210810 08/04/2021 38 PROFESSIONAL CONSULTING HOUSEAL LAVIGNE ASSO 535140 5177 970.00AP-210824 08/17/2021 49 JULY 2021 CAR WASHES PARADISE CAR WASH 535245 224341 13.00AP-210825M 08/19/2021 66 ADOBE-CREATIVE CLOUD MONTHLY FIRST NATIONAL BANK 900108 082521-J.ENGBERG 52.9908/19/2021 67 ESRI-ARCGIS DESKTOP LICENSE FIRST NATIONAL BANK 900108 082521-K.BARKSDALE 500.00_________________________________TOTAL PERIOD 04 ACTIVITY 1,535.99 0.0005 AP-210914 09/07/2021 50 PROFESSIONAL CONSULTING HOUSEAL LAVIGNE ASSO 535299 5208 3,698.75AP-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.0006 AP-211012 10/07/2021 44 AUG 2021 CONSULTING SERVICES HOUSEAL LAVIGNE ASSO 535474 5247 2,838.75AP-211025M 10/20/2021 62 ADOBE-MONTHLY CREATIVE CLOUD FIRST NATIONAL BANK 900110 102521-J.ENHBERG 52.99_________________________________TOTAL PERIOD 06 ACTIVITY 2,891.74 0.0007 AP-211109 11/03/2021 55 PROFESSIONAL CONSULTING HOUSEAL LAVIGNE ASSO 535671 5286 392.50AP-211125M 11/17/2021 66 ADOBE-MONTHLY CREATIVE CLOUD FIRST NATIONAL BANK 900111 112521-J.ENGBERG 52.9911/17/2021 67 ESRI-ARCGIS BLOCK OF 1,000 FIRST NATIONAL BANK 900111 112521-J.ENGBERG 200.00_________________________________TOTAL PERIOD 07 ACTIVITY 645.49 0.00YTD BUDGET 52,080.00 TOTAL ACCOUNT ACTIVITY 19,585.94 0.00ANNUAL REVISED BUDGET 89,280.00 ENDING BALANCE 19,585.94_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-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 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 5TIME: 09:21:13 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________02 AP-210622B 06/15/2021 44 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 5.13AP-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.0003 AP-210713B 07/07/2021 95 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 56.50AP-210727 07/20/2021 40 ANNUAL FY22 STORMWATER BILLING ILLINOIS EPS (NPDES) 535058 ILR400554-062821 1,000.0007/20/2021 41 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.16GJ-210727RC 07/21/2021 02 RC ILEPA Inv#ILR400554-062821 1,000.00_________________________________TOTAL PERIOD 03 ACTIVITY 1,059.66 1,000.0004 AP-210824 08/17/2021 51 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 2.82AP-210825M 08/19/2021 73 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 244.0008/19/2021 74 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 366.8508/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.0005 AP-210914 09/07/2021 61 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 1.52AP-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.0006 AP-211025M 10/20/2021 71 MINER ELECT#329828-OCT 2021 FIRST NATIONAL BANK 900110 102521-K.GREGORY 366.85AP-211026 10/19/2021 64 08/29-09/28 COPY CHARGES IMPACT NETWORKING, L 535574 2276498 3.17_________________________________TOTAL PERIOD 06 ACTIVITY 370.02 0.0007 AP-211123 11/15/2021 43 09/28-10/28 COPY CHARGES IMPACT NETWORKING, L 535764 2311729 4.30AP-211125M 11/17/2021 75 SHAWE MEDIA-JOB POSTING FIRST NATIONAL BANK 900111 112521-J.BEHLAND 670.0011/17/2021 76 MINER ELECT-NOV 2021 SHARED FIRST NATIONAL BANK 900111 112521-K.GREGORY 366.85_________________________________TOTAL PERIOD 07 ACTIVITY 1,041.15 0.00YTD BUDGET 5,381.25 TOTAL ACCOUNT ACTIVITY 4,558.55 1,000.00ANNUAL REVISED BUDGET 9,225.00 ENDING BALANCE 3,558.55_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-210525B 05/19/2021 16 2020 ROB ROY DRAINAGE DIST FEE KENDALL COUNTY COLLE 534697 2020 FEE-ROB ROY 161.6205/19/2021 17 2020 RAYMOND DRAINAGE DIST FEE KENDALL COUNTY COLLE 534697 2020 FEES-RAYMOND 315.58AP-210527M 05/26/2021 01 2020 CALEDONIA DRAINAGE DIST KENDALL COUNTY COLLE 534719 2020012552-062021 20.0005/26/2021 02 2020 CALEDONIA DRAINAGE DIST KENDALL COUNTY COLLE 534720 2020012553-062021 25.72_________________________________TOTAL PERIOD 01 ACTIVITY 522.92 0.0003 AP-210727 07/20/2021 65 LOBBYIST FEE VILLAGE OF OSWEGO 535084 0521 1,166.6707/20/2021 66 LOBBYIST FEE REIMBURSEMENT VILLAGE OF OSWEGO 535084 EGA050-2021-05 1,562.50_________________________________TOTAL PERIOD 03 ACTIVITY 2,729.17 0.0004 AP-210824 08/17/2021 86 2021 ROAD PROGRAM ENGINEERING ENTERPRI 535210 71992 29,864.50GJ-211026RC 10/26/2021 04 RC EEI Inv#71992 2,212.50_________________________________TOTAL PERIOD 04 ACTIVITY 29,864.50 2,212.5006 AP-211012 10/07/2021 95 STATE LOBBYIST CHARGES VILLAGE OF OSWEGO 535507 1332 3,500.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 6TIME: 09:21:17 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________06 AP-211012 10/07/2021 96 FEDERAL LOBBYIST CHARGES VILLAGE OF OSWEGO 535507 1332 4,687.50_________________________________TOTAL PERIOD 06 ACTIVITY 8,187.50 0.00YTD BUDGET 28,087.50 TOTAL ACCOUNT ACTIVITY 41,304.09 2,212.50ANNUAL REVISED BUDGET 48,150.00 ENDING BALANCE 39,091.59_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00YTD BUDGET 7,875.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00ANNUAL REVISED BUDGET 13,500.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-205-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-225-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00GJ-053121FE 07/14/2021 03 UB WSB LOCKBOX FEES - MAY 2020 204.33AP-210525MB 05/25/2021 11 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 430.65GJ-210531FE 05/27/2021 03 UB CC Fees - Apr 2021 2,827.0405/27/2021 09 UB Paymentus Fee-Apr 2021 1,875.1605/27/2021 15 FNBO Analysis Chrg-Apr 2021 419.04GJ-21629PRE 06/29/2021 33 Cintas-2224 Tremont Monitoring 158.0006/29/2021 34 Cintas-3299 Lehman Monitoring 158.0006/29/2021 35 Cintas-610 Tower Monitoring 158.00_________________________________TOTAL PERIOD 01 ACTIVITY 6,230.22 0.0002 GJ-063021FE 08/05/2021 03 UB WSB LOCKBOX FEE - JUN 2021 116.87AP-210625MB 06/23/2021 49 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 430.65GJ-210630FE 06/24/2021 03 UB CC Fees - May 2021 2,368.2906/24/2021 09 UB Paymentus Fees - May 2021 1,459.7506/24/2021 15 FNBO Analysis Chrg - May 2021 437.27_________________________________TOTAL PERIOD 02 ACTIVITY 4,812.83 0.0003 GJ-073121FE 10/12/2021 03 UB WSB LOCKBOX FEES-JULY 2021 214.51AP-210713B 07/07/2021 195 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 134.8607/07/2021 196 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 56.50AP-210727 07/20/2021 103 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 51.2507/20/2021 104 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.1507/20/2021 105 LOBBYIST FEE VILLAGE OF OSWEGO 535084 0521 1,166.6707/20/2021 106 LOBBYIST FEE VILLAGE OF OSWEGO 535084 EGA050-2021-05 1,562.50GJ-210731FE 07/27/2021 03 UB CC Fees - June 2021 1,169.9107/27/2021 09 UB Paymentus Fees - June 2021 1,994.23 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 7TIME: 09:21:56 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________03 GJ-210731FE 07/27/2021 15 FNBO Analysis Chrg - June 2021 500.98_________________________________TOTAL PERIOD 03 ACTIVITY 6,854.56 0.0004 GJ-083121FE 10/12/2021 03 UB WSB LOCKBOX FEES-AUG 2021 92.81AP-210810 08/04/2021 103 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 352.47AP-210824 08/17/2021 183 JULY 2021 DUMPING PLANO CLEAN FILL 535248 819 150.00AP-210825M 08/19/2021 129 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 183.0008/19/2021 130 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 430.6508/19/2021 131 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 430.65GJ-210831FE 08/24/2021 03 UB CC Fees - July 2021 2,186.1408/24/2021 09 UB Paymentus Fees - July 2021 1,574.6508/24/2021 15 UB Analysis Fees - July 2021 423.97_________________________________TOTAL PERIOD 04 ACTIVITY 5,824.34 0.0005 GJ-093021FE 10/11/2021 03 UB WSB LOCKBOX FEES 224.80AP-210914 09/07/2021 136 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 138.4409/07/2021 137 BACKGROUND CHECKS ILLINOIS STATE POLIC 535300 073121-4811 56.50AP-210925M 09/20/2021 91 PYSICIANS-RANDOM DOT TEST FIRST NATIONAL BANK 900109 092521-E.WILLRETT 58.0009/20/2021 92 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 430.65GJ-210930FE 09/22/2021 03 UB CC Fees - Aug 2021 1,390.0309/22/2021 09 UB Paymentus Fees - Aug 2021 2,031.9709/22/2021 15 FNBO Analysis Chrg - Aug 2021 459.00_________________________________TOTAL PERIOD 05 ACTIVITY 4,789.39 0.0006 GJ-103121FE 11/04/2021 03 UB WSB LOCKBOX FEE - OCT 2021 73.66AP-211012 10/07/2021 140 STATE LOBBYIST CHARGES VILLAGE OF OSWEGO 535507 1332 3,500.0010/07/2021 141 FEDERAL LOBBYIST CHARGES VILLAGE OF OSWEGO 535507 1332 4,687.50AP-211025M 10/20/2021 106 MINER ELECT#329828-OCT 2021 FIRST NATIONAL BANK 900110 102521-K.GREGORY 430.65AP-211026 10/19/2021 114 AUG & SEPT 2021 DUMPING PLANO CLEAN FILL 535599 828 100.00GJ-211031FE 10/25/2021 03 UB CC Fees - Sept 2021 549.2110/25/2021 09 UB Paymentus Fees - Sept 2021 1,525.5010/25/2021 15 FNBO Analysis Charge-Sept 2021 416.02_________________________________TOTAL PERIOD 06 ACTIVITY 11,282.54 0.0007 GJ-113021FE 12/03/2021 03 UB WSB LOCKBOX FEE 196.91AP-211109 11/03/2021 182 MYGOVHUB FEES - SEPT 2021 HARRIS COMPUTER SYST 535665 MSIXT0000139 359.06AP-211123 11/15/2021 170 MYGOVHUB FEES-OCT 2021 HARRIS COMPUTER SYST 535761 MSIXT0000158 141.8111/15/2021 171 09/28-10/28 COPY CHARGES IMPACT NETWORKING, L 535764 2311729 4.30AP-211125M 11/17/2021 119 MINER ELECT-NOV 2021 SHARED FIRST NATIONAL BANK 900111 112521-K.GREGORY 430.65GJ-211130FE 12/01/2021 03 UB CC Fees - Oct 2021 1,253.0612/01/2021 09 UB Paymentus Fees - Oct 2021 2,119.9812/01/2021 15 FNBO Analysis Chrg - Oct 2021 485.33_________________________________TOTAL PERIOD 07 ACTIVITY 4,991.10 0.00YTD BUDGET 96,833.35 TOTAL ACCOUNT ACTIVITY 44,784.98 0.00ANNUAL REVISED BUDGET 166,000.00 ENDING BALANCE 44,784.98_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 8TIME: 09:22:10 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. 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.31AP-210525MB 05/25/2021 13 MINER#101045-MAY 2021 MANAGED FIRST NATIONAL BANK 900103 052521-K.GREGORY 287.10GJ-210531FE 05/27/2021 05 UB CC Fees - Apr 2021 1,318.7405/27/2021 11 UB Paymentus Fee-Apr 2021 874.7105/27/2021 17 FNBO Analysis Chrg-Apr 2021 195.47_________________________________TOTAL PERIOD 01 ACTIVITY 2,771.33 0.0002 GJ-063021FE 08/05/2021 05 UB WSB LOCKBOX FEE - JUN 2021 54.52AP-210625MB 06/23/2021 58 MINER#326824-JUN 2021 MANAGED FIRST NATIONAL BANK 900105 062521-K.GREGORY-B 287.10GJ-210630FE 06/24/2021 05 UB CC Fees - May 2021 1,104.7506/24/2021 11 UB Paymentus Fees - May 2021 680.9406/24/2021 17 FNBO Analysis Chrg - May 2021 203.97_________________________________TOTAL PERIOD 02 ACTIVITY 2,331.28 0.0003 GJ-073121FE 10/12/2021 05 UB WSB LOCKBOX FEES-JULY 2021 100.06AP-210713B 07/07/2021 231 MYGOVHUB FEES - JUNE 2021 HARRIS COMPUTER SYST 534950 MSIXT0000107 38.92AP-210727 07/20/2021 136 MAY 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535055 MSIXT0000088 14.7907/20/2021 137 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 3.14GJ-210731FE 07/27/2021 05 UB CC Fees - June 2021 545.7307/27/2021 11 UB Paymentus Fees - June 2021 930.2707/27/2021 17 FNBO Analysis Chrg - June 2021 233.70_________________________________TOTAL PERIOD 03 ACTIVITY 1,866.61 0.0004 GJ-083121FE 10/12/2021 05 UB WSB LOCKBOX FEES-AUG 2021 43.29AP-210810 08/04/2021 132 JUL 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535135 MSIXT0000109 101.72AP-210824 08/17/2021 226 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 2.82AP-210825M 08/19/2021 167 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 287.1008/19/2021 168 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 287.10GJ-210831FE 08/24/2021 05 UB CC Fees - July 2021 1,019.7808/24/2021 11 UB Paymentus Fees - July 2021 734.5308/24/2021 17 UB Analysis Fees - July 2021 197.77_________________________________TOTAL PERIOD 04 ACTIVITY 2,674.11 0.0005 GJ-093021FE 10/11/2021 05 UB WSB LOCKBOX FEES 104.86AP-210914 09/07/2021 171 AUG 2021 MYGOVHUB FEES HARRIS COMPUTER SYST 535295 MSIXY0000123 39.95AP-210925M 09/20/2021 107 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 287.10GJ-210930FE 09/22/2021 05 UB CC Fees - Aug 2021 648.4209/22/2021 11 UB Paymentus Fees - Aug 2021 947.8609/22/2021 17 FNBO Analysis Chrg - Aug 2021 214.11_________________________________TOTAL PERIOD 05 ACTIVITY 2,242.30 0.0006 GJ-103121FE 11/04/2021 05 UB WSB LOCKBOX FEE - OCT 2021 34.36AP-211025M 10/20/2021 126 MINER ELECT#329828-OCT 2021 FIRST NATIONAL BANK 900110 102521-K.GREGORY 287.10GJ-211031FE 10/25/2021 05 UB CC Fees - Sept 2021 256.2010/25/2021 11 UB Paymentus Fees - Sept 2021 711.6110/25/2021 17 FNBO Analysis Charge-Sept 2021 194.07_________________________________TOTAL PERIOD 06 ACTIVITY 1,483.34 0.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 9TIME: 09:22:10 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________07 GJ-113021FE 12/03/2021 05 UB WSB LOCKBOX FEE 91.85AP-211109 11/03/2021 215 MYGOVHUB FEES - SEPT 2021 HARRIS COMPUTER SYST 535665 MSIXT0000139 103.62AP-211123 11/15/2021 204 MYGOVHUB FEES-OCT 2021 HARRIS COMPUTER SYST 535761 MSIXT0000158 40.9211/15/2021 205 09/28-10/28 COPY CHARGES IMPACT NETWORKING, L 535764 2311729 4.30AP-211125M 11/17/2021 147 MINER ELECT-NOV 2021 SHARED FIRST NATIONAL BANK 900111 112521-K.GREGORY 287.10GJ-211130FE 12/01/2021 05 UB CC Fees - Oct 2021 584.5212/01/2021 11 UB Paymentus Fees - Oct 2021 988.9212/01/2021 17 FNBO Analysis Chrg - Oct 2021 226.39_________________________________TOTAL PERIOD 07 ACTIVITY 2,327.62 0.00YTD BUDGET 20,708.35 TOTAL ACCOUNT ACTIVITY 15,696.59 0.00ANNUAL REVISED BUDGET 35,500.00 ENDING BALANCE 15,696.59_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-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.0002 AP-210622B 06/15/2021 107 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 39.3206/15/2021 108 MAY 2021 COPY CHARGES IMPACT NETWORKING, L 534855 2144435 39.31AP-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.0003 AP-2101725M 07/26/2021 124 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900107 072521-K.GREGORY 405.0007/26/2021 125 ARAMARK#610000139707-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 56.6507/26/2021 126 ARAMARK#610000126829-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.2107/26/2021 127 ARAMARK#610000130040-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.2107/26/2021 128 ARAMARK#610000133317-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.2107/26/2021 129 ARAMARK#610000136522-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.2107/26/2021 130 ARAMARK#610000139702-MATS FIRST NATIONAL BANK 900107 072521-S.REDMON 18.21AP-210713B 07/07/2021 250 05/20/21 MEETING MINUTES MARLYS J. YOUNG 535012 052021 30.00AP-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.0004 AP-210824 08/17/2021 248 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 29.1708/17/2021 249 05/01-07/31 MANAGED PRINT IMPACT NETWORKING, L 535226 2216307 0.94AP-210825M 08/19/2021 192 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 90.0008/19/2021 193 MINER ELEC#327563-JUL 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 510.4008/19/2021 194 MINER ELECT#328298-AUG 2021 FIRST NATIONAL BANK 900108 082521-K.GREGORY-C 510.4008/19/2021 195 PLAYGROUND GUARDIAN-PARK FIRST NATIONAL BANK 900108 082521-R.HORNER 2,000.00_________________________________TOTAL PERIOD 04 ACTIVITY 3,140.91 0.0005 AP-210914 09/07/2021 196 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 77.6809/07/2021 197 08/05/21 PARK BOARD MEETING MARLYS J. YOUNG 535349 080521 31.50AP-210925M 09/20/2021 120 PYSICIANS-RANDOM DOT TESTS FIRST NATIONAL BANK 900109 092521-E.WILLRETT 209.0009/20/2021 121 MINER ELECT#329021-SEPT 2021 FIRST NATIONAL BANK 900109 092521-K.GREGORY 510.40_________________________________TOTAL PERIOD 05 ACTIVITY 828.58 0.0006 AP-211025M 10/20/2021 146 MINER ELECT#329828-OCT 2021 FIRST NATIONAL BANK 900110 102521-K.GREGORY 510.40 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 10TIME: 09:22:22 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________06 AP-211026 10/19/2021 155 08/29-09/28 COPY CHARGES IMPACT NETWORKING, L 535574 2276498 67.77_________________________________TOTAL PERIOD 06 ACTIVITY 578.17 0.0007 AP-211123 11/15/2021 227 09/28-10/28 COPY CHARGES IMPACT NETWORKING, L 535764 2311729 64.6211/15/2021 228 08/01-10/31 MANAGED PRINT IMPACT NETWORKING, L 535764 2315531 0.93AP-211125M 11/17/2021 168 MINER ELECT-NOV 2021 SHARED FIRST NATIONAL BANK 900111 112521-K.GREGORY 510.40_________________________________TOTAL PERIOD 07 ACTIVITY 575.95 0.00YTD BUDGET 6,650.00 TOTAL ACCOUNT ACTIVITY 6,856.90 0.00ANNUAL REVISED BUDGET 11,400.00 ENDING BALANCE 6,856.90_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-210525B 05/19/2021 32 UMPIRE JOSLYN T. BULLINGTON 534684 MAY 1 - 11 35.0005/19/2021 33 UMPIRE JOHN ELENBAAS 534688 050821 70.0005/19/2021 34 UMPIRE W. THOMAS EVINS 534690 050121 70.0005/19/2021 35 UMPIRE NOLAN HOOPER 534692 MAY 1 - 11 20.0005/19/2021 36 UMPIRE STEPHEN IRVING 534694 050621 160.0005/19/2021 37 UMPIRE JAVIER LASSALLE 534698 050821 70.0005/19/2021 38 UMPIRE JACOB LIPSCOMB 534699 MAY 1 - 11 55.0005/19/2021 39 UMPIRE JACK MODAFF 534702 MAY 1 - 11 110.0005/19/2021 40 UMPIRE ROBERT L. RIETZ JR. 534709 050621 160.0005/19/2021 41 UMPIRE KATIE STRAZNICAS 534713 050121 70.0005/19/2021 42 UMPIRE MICHAEL VOITIK 534715 050621 160.00GJ-210531FE 05/27/2021 19 PR CC Fee - Apr 2021 1,171.01_________________________________TOTAL PERIOD 01 ACTIVITY 2,151.01 0.0002 AP-210608A 06/02/2021 141 UMPIRE ERIC ADAMS 534750 MAY 12-MAY 25 110.0006/02/2021 142 UMPIRE WILLIAM BLAKE 534753 MAY 12-MAY 25 330.0006/02/2021 143 UMPIRE JOSLYN T. BULLINGTON 534754 MAY 12-MAY 25 130.0006/02/2021 144 UMPIRE JACKSON BULLINGTON 534755 MAY 12-MAY 25 80.0006/02/2021 145 UMPIRE JOHN ELENBAAS 534763 051521 70.0006/02/2021 146 UMPIRE JOHN ELENBAAS 534763 052221 70.0006/02/2021 147 UMPIRE JORY ELENBAAS 534764 052221 70.0006/02/2021 148 UMPIRE RYAN EVANS 534766 MAY 12-MAY 25 20.0006/02/2021 149 UMPIRE W. THOMAS EVINS 534767 051521 70.0006/02/2021 150 UMPIRE ALLEN R. GOSS 534769 MAY 12-MAY 25 55.0006/02/2021 151 UMPIRE COLIN GRIFFIN 534770 MAY 12-MAY 25 45.0006/02/2021 152 UMPIRE NOLAN HOOPER 534773 MAY 12-MAY 25 60.0006/02/2021 153 UMPIRE STEPHEN IRVING 534777 051321 160.0006/02/2021 154 UMPIRE STEPHEN IRVING 534777 052021 160.0006/02/2021 155 UMPIRE GREGORY JOHNSON 534778 MAY 12-MAY 25 55.0006/02/2021 156 UMPIRE JACOB LIPSCOMB 534783 MAY 12-MAY 25 55.0006/02/2021 157 UMPIRE GAVIN DANIEL LOHER 534784 MAY 12-MAY 25 155.0006/02/2021 158 UMPIRE KYLE DEAN MCCURDY 534787 MAY 12-MAY 25 140.0006/02/2021 159 UMPIRE RYAN MEHOCHKO 534788 MAY12-MAY 25 20.0006/02/2021 160 UMPIRE JACK MODAFF 534792 MAY 12-MAY 25 220.0006/02/2021 161 UMPIRE LIAM PHENEY 534796 MAY 12-MAY 25 60.0006/02/2021 162 UMPIRE JEFF RICHARDSON 534801 MAY 12-MAY 25 55.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 11TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. 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 163 UMPIRE ROBERT L. RIETZ JR. 534802 051321 160.0006/02/2021 164 UMPIRE ROBERT L. RIETZ JR. 534802 052021 160.0006/02/2021 165 UMPIRE EDWIN A RUNDLE 534804 MAY 12-MAY 25 55.0006/02/2021 166 UMPIRE BRYSON SCHMIDT 534805 MAY 12-MAY 25 35.0006/02/2021 167 CHILD & BABYSITTING SAFETY SECOND CHANCE CARDIA 534806 21-005-355 418.6006/02/2021 168 UMPIRE JAMES A. TIETZ 534810 MAY 12-MAY 25 55.0006/02/2021 169 UMPIRE MICHAEL VOITIK 534813 051321 160.0006/02/2021 170 UMPIRE MICHAEL VOITIK 534813 052021 160.0006/02/2021 171 UMPIRE MARK RUNYON 2091 MAY 12-MAY 25 110.00AP-210622B 06/15/2021 118 UMPIRE DAVID BEEBE 534829 MAY 26-JUNE 07 55.0006/15/2021 119 UMPIRE JOSLYN T. BULLINGTON 534833 MAY 26-JUNE 07 200.0006/15/2021 120 UMPIRE JACKSON BULLINGTON 534834 MAY 26-JUNE 07 100.0006/15/2021 121 UMPIRE THOMAS DEES 534839 MAY 26-JUNE 07 110.0006/15/2021 122 UMPIRE ANDREW GOLINSKI 534848 MAY 26-JUNE 07 35.0006/15/2021 123 UMPIRE ALLEN R. GOSS 534849 MAY 26-JUNE 07 55.0006/15/2021 124 UMPIRE COLIN GRIFFIN 534851 MAY 26-JUNE 07 65.0006/15/2021 125 UMPIRE ETHAN HANSON 534852 MAY 26-JUNE 07 75.0006/15/2021 126 UMPIRE JACKSON HAWKINSON 534853 MAY 26-JUNE 07 95.0006/15/2021 127 UMPIRE NOLAN HOOPER 534854 MAY 26-JUNE 07 45.0006/15/2021 128 UMPIRE STEPHEN IRVING 534858 060321 160.0006/15/2021 129 UMPIRE JACOB LIPSCOMB 534864 MAY 26-JUNE 07 55.0006/15/2021 130 UMPIRE GAVIN DANIEL LOHER 534865 MAY 26-JUNE 07 65.0006/15/2021 131 UMPIRE KYLE DEAN MCCURDY 534869 MAY 26-JUNE 07 175.0006/15/2021 132 UMPIRE RYAN MEHOCHKO 534870 MAY 26-JUNE 07 90.0006/15/2021 133 UMPIRE STEVE PEARSON 534877 MAY 26-JUNE 07 55.0006/15/2021 134 UMPIRE JEFF RICHARDSON 534884 MAY 26-JUNE 07 55.0006/15/2021 135 UMPIRE ROBERT L. RIETZ JR. 534885 060321 120.0006/15/2021 136 UMPIRE EMMA ROBERTS 534886 MAY 26-JUNE 07 55.0006/15/2021 137 UMPIRE BRYSON SCHMIDT 534887 MAY 26-JUNE 07 95.0006/15/2021 138 RECTRAC/WEBTRAC ANNUAL VERMONT SYSTEMS 534897 69991 5,538.0006/15/2021 139 UMPIRE MICHAEL VOITIK 534898 060321 160.0006/15/2021 140 UMPIRE MARK RUNYON 2104 MAY 26-JUNE 07 55.00GJ-210630FE 06/24/2021 19 PR CC Fees - May 2021 1,100.81_________________________________TOTAL PERIOD 02 ACTIVITY 12,117.41 0.0003 AP-2101725M 07/26/2021 159 PLUGNPAY-MAY 2021 BILLING FEE FIRST NATIONAL BANK 900107 072521-S.REDMON 30.0007/26/2021 160 LOMBARSI COACHING-YOUTH CLASS FIRST NATIONAL BANK 900107 072521-S.REDMON 137.2007/26/2021 161 CANVA-ANNUAL SUBSCRIPTION FIRST NATIONAL BANK 900107 072521-S.REDMON 99.99AP-210713B 07/07/2021 276 UMPIRE ERIC ADAMS 534916 JUNE 9-JUNE 26 55.0007/07/2021 277 UMPIRE WILLIAM BLAKE 534922 JUNE 9-JUNE 26 165.0007/07/2021 278 UMPIRE TERENCE BOWMAN 534924 062421 160.0007/07/2021 279 UMPIRE JOSLYN T. BULLINGTON 534926 JUNE 9-JUNE 26 120.0007/07/2021 280 UMPIRE JACKSON BULLINGTON 534927 JUNE 9-JUNE 26 60.0007/07/2021 281 UMPIRE RAIUMUNDO FONSECA 534945 JUNE 9-JUNE 26 60.0007/07/2021 282 UMPIRE ANDREW GOLINSKI 534947 JUNE 9-JUNE 26 105.0007/07/2021 283 UMPIRE ALLEN R. GOSS 534948 JUNE 9-JUNE 26 165.0007/07/2021 284 UMPIRE COLIN GRIFFIN 534949 JUNE 9-JUNE 26 25.0007/07/2021 285 UMPIRE NOLAN HOOPER 534954 JUNE 9-JUNE 26 115.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 12TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. 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 286 BACKGROUND CHECKS ILLINOIS STATE POLIC 534956 053121 84.7507/07/2021 287 UMPIRE STEPHEN IRVING 534961 052721 160.0007/07/2021 288 UMPIRE STEPHEN IRVING 534961 061021 160.0007/07/2021 289 UMPIRE STEPHEN IRVING 534961 061721 160.0007/07/2021 290 UMPIRE STEPHEN IRVING 534961 062421 160.0007/07/2021 291 UMPIRE HALEY N. KOSIN 534967 JUNE 9-JUNE 26 60.0007/07/2021 292 UMPIRE JOHN LEPACEK 534968 JUNE 9-JUNE 26 55.0007/07/2021 293 UMPIRE JACOB LIPSCOMB 534969 JUNE 9-JUNE 26 55.0007/07/2021 294 UMPIRE GAVIN DANIEL LOHER 534970 JUNE 9-JUNE 26 150.0007/07/2021 295 UMPIRE MICHAEL F. MARCHETTI 534971 JUNE 9-JUNE 26 55.0007/07/2021 296 UMPIRE KYLE DEAN MCCURDY 534975 JUNE 9-JUNE 26 280.0007/07/2021 297 UMPIRE RYAN MEHOCHKO 534976 JUNE 9-JUNE 26 105.0007/07/2021 298 UMPIRE JACK MODAFF 534982 JUNE 9-JUNE 26 120.0007/07/2021 299 UMPIRE STEVE PEARSON 534991 JUNE 9-JUNE 26 55.0007/07/2021 300 UMPIRE LIAM PHENEY 534992 JUNE 9-JUNE 26 40.0007/07/2021 301 UMPIRE ROBERT L. RIETZ JR. 534997 052721 160.0007/07/2021 302 UMPIRE ROBERT L. RIETZ JR. 534997 061021 160.0007/07/2021 303 UMPIRE ROBERT L. RIETZ JR. 534997 061721 160.0007/07/2021 304 UMPIRE ROBERT L. RIETZ JR. 534997 JUNE 9-JUNE 26 120.0007/07/2021 305 UMPIRE EMMA ROBERTS 534998 JUNE 9-JUNE 26 110.0007/07/2021 306 UMPIRE BRYSON SCHMIDT 535000 JUNE 9-JUNE 26 130.0007/07/2021 307 UMPIRE JAMES A. TIETZ 535003 JUNE 9-JUNE 26 110.0007/07/2021 308 UMPIRE MICHAEL VOITIK 535007 052721 160.0007/07/2021 309 UMPIRE MICHAEL VOITIK 535007 061021 160.0007/07/2021 310 UMPIRE MICHAEL VOITIK 535007 061721 160.0007/07/2021 311 UMPIRE MICHAEL VOITIK 535007 062421 160.0007/07/2021 312 05/20/21 MEETING MINUTES MARLYS J. YOUNG 535012 052021 30.0007/07/2021 313 UMPIRE KAYLA ZUBER 535013 JUNE 9-JUNE 26 65.0007/07/2021 314 UMPIRE SAM GOLINSKI 2116 JUNE 9-JUNE 26 55.00AP-210727 07/20/2021 171 SOCCER CAMP INSTRUCTION 5 STAR SOCCER CAMPS 535025 7221 1,800.0007/20/2021 172 UMPIRE ERIC ADAMS 535027 JUNE 27-JULY 14 220.0007/20/2021 173 SUMMER 2021 CLASS INSTRUCTION ALL STAR SPORTS INST 535028 214010 7,510.0007/20/2021 174 UMPIRE WILLIAM BLAKE 535034 JUNE 27-JULY 14 275.0007/20/2021 175 UMPIRE ANTHONY BOULE 535035 JUNE 27-JULY 14 140.0007/20/2021 176 UMPIRE JOSLYN T. BULLINGTON 535036 JUNE 27-JULY 14 50.0007/20/2021 177 UMPIRE JACKSON BULLINGTON 535037 JUNE 27-JULY 14 40.0007/20/2021 178 UMPRE THOMAS DEES 535043 JUNE 27-JULY 14 280.0007/20/2021 179 UMPIRE ALLEN R. GOSS 535052 JUNE 27-JULY 14 165.0007/20/2021 180 UMPIRE COLIN GRIFFIN 535053 JUNE 27-JULY 14 60.0007/20/2021 181 UMPIRE JACKSON HAWKINSON 535056 JUNE 27-JULY 14 120.0007/20/2021 182 UMPIRE NOLAN HOOPER 535057 JUNE 27-JULY 14 20.0007/20/2021 183 05/29-06/28 COPY CHARGES IMPACT NETWORKING, L 535061 2176592 51.1607/20/2021 184 UMPIRE STEPHEN IRVING 535064 070121 80.0007/20/2021 185 UMPIRE GREGORY JOHNSON 535066 JUNE 27-JULY 14 60.0007/20/2021 186 UMPIRE HALEY N. KOSIN 535069 JUNE 27-JULY 14 50.0007/20/2021 187 UMPIRE JIM KWIATKOWSKI 535070 JUNE 27-JULY 14 55.0007/20/2021 188 UMPIRE JACOB LIPSCOMB 535071 JUNE 27-JULY 14 110.0007/20/2021 189 UMPIRE GAVIN DANIEL LOHER 535072 JUNE 27-JULY 14 165.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 13TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________03 AP-210727 07/20/2021 190 UMPIRE KYLE DEAN MCCURDY 535075 JUNE 27-JULY 14 165.0007/20/2021 191 UMPIRE RYAN MEHOCHKO 535076 JUNE 27-JULY 14 165.0007/20/2021 192 UMPIRE JACK MODAFF 535080 JUNE 27-JULY 14 55.0007/20/2021 193 UMPIRE ARBITER RENEWAL CYNTHIA O'LEARY 535082 REC UMPS RENEWAL 264.0007/20/2021 194 SPING SOCCER REFEREE ASSIGNING CYNTHIA O'LEARY 535083 SOCCER SPRING 2021 125.0007/20/2021 195 UMPIRE STEVE PEARSON 535086 JUNE 27-JULY 14 165.0007/20/2021 196 UMPIRE LIAM PHENEY 535087 JUNE 27-JULY 14 95.0007/20/2021 197 UMPIRE JEFF RICHARDSON 535094 JUNE 27-JULY 14 55.0007/20/2021 198 UMPIRE ROBERT L. RIETZ JR. 535095 070121 120.0007/20/2021 199 UMPIRE ROBERT L. RIETZ JR. 535095 JUNE 27-JULY 14 55.0007/20/2021 200 UMPIRE BRYSON SCHMIDT 535096 JUNE 27-JULY 14 130.0007/20/2021 201 UMPIRE TIM SIPES 535098 JUNE 27-JULY 14 55.0007/20/2021 202 UMPIRE MICHAEL VOITIK 535104 070121 80.0007/20/2021 203 UMPIRE KAYLA ZUBER 535108 JUNE 27-JULY 14 75.0007/20/2021 204 UMPIRE EMMA ROBERTS 2140 JUNE 27-JULY 14 55.00GJ-210731FE 07/27/2021 19 PR CC Fees - June 2021 1,673.28_________________________________TOTAL PERIOD 03 ACTIVITY 19,320.38 0.0004 AP-210810 08/04/2021 158 UMPIRE WILLIAM BLAKE 535119 JULY 15-JULY 23 225.0008/04/2021 159 UMPIRE JOSLYN T. BULLINGTON 535121 JULY 15-JULY 23 10.0008/04/2021 160 UMPIRE JACKSON BULLINGTON 535122 JULY 15-JULY 23 70.0008/04/2021 161 UMPIRE NOLAN HOOPER 535139 JULY 15-JULY 23 25.0008/04/2021 162 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 84.7508/04/2021 163 UMPIRE JACOB LIPSCOMB 535150 JULY 15-JULY 23 225.0008/04/2021 164 UMPIRE GAVIN DANIEL LOHER 535151 JULY 15-JULY 23 50.0008/04/2021 165 UMPIRE RYAN MEHOCHKO 535153 JULY 15-JULY 23 115.0008/04/2021 166 REFEREE ASSIGNER'S FEE CYNTHIA O'LEARY 535160 YORKVILLE REC 2,300.0008/04/2021 167 UMPIRE LIAM PHENEY 535163 JULY 15-JULY 23 40.0008/04/2021 168 UMPIRE ROBERT L. RIETZ JR. 535168 JULY 15-JULY 23 55.0008/04/2021 169 UMPIRE BRYSON SCHMIDT 535169 JULY 15-JULY 23 35.0008/04/2021 170 UMPIRE JAMES A. TIETZ 535174 JULY 15-JULY 23 55.00AP-210824 08/17/2021 271 UMPIRE JOSLYN T. BULLINGTON 535195 JULY 24-AUG 5 40.0008/17/2021 272 UMPIRE JACKSON BULLINGTON 535196 JULY 24-AUG 5 20.0008/17/2021 273 UMPIRE RAIUMUNDO FONSECA 535220 JULY 24-AUG 5 60.0008/17/2021 274 06/29-07/28 COPY CHARGES IMPACT NETWORKING, L 535226 2207915 29.1708/17/2021 275 UMPIRE GREGORY JOHNSON 535228 JULY 24-AUG 5 60.0008/17/2021 276 UMPIRE EDSON KING JR 535230 051721 35.0008/17/2021 277 UMPIRE KATIE STRAZNICAS 535255 051721 35.0008/17/2021 278 UMPIRE MARK RUNYON 2175 JULY 24-AUG 5 60.00AP-210825M 08/19/2021 230 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 180.0008/19/2021 231 PLUG & PAY-JUN 2021 BILLING FIRST NATIONAL BANK 900108 082521-S.REDMON 44.7708/19/2021 232 SMITHEREEN-JUN 2021 PEST FIRST NATIONAL BANK 900108 082521-S.REDMON 67.0008/19/2021 233 PETITE PALETTE-PAINTING CLASS FIRST NATIONAL BANK 900108 082521-S.REDMON 180.00GJ-210831FE 08/24/2021 19 PR CC Fees-July 2021 1,935.55_________________________________TOTAL PERIOD 04 ACTIVITY 6,036.24 0.0005 AP-210914 09/07/2021 224 UMPIRE BENNETT ALLEN 535268 JULY 25-AUG 24 40.0009/07/2021 225 UMPIRE ROBERT FERGUSON 535289 JULY 25-AUG 24 55.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 14TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________05 AP-210914 09/07/2021 226 UMPIRE RAIUMUNDO FONSECA 535291 JULY 25-AUG 24 60.0009/07/2021 227 UMPIRE NOLAN HOOPER 535298 JULY 25-AUG 24 50.0009/07/2021 228 BACKGROUND CHECKS ILLINOIS STATE POLIC 535300 073121-4811 1,045.2509/07/2021 229 07/29-08/28 COPY CHARGES IMPACT NETWORKING, L 535303 2241283 77.6909/07/2021 230 UMPIRE STEPHEN IRVING 535306 081221 160.0009/07/2021 231 UMPIRE STEPHEN IRVING 535306 081921 160.0009/07/2021 232 UMPIRE GREGORY JOHNSON 535307 JULY 25-AUG 24 165.0009/07/2021 233 UMPIRE BENJAMIN KOZIAL 535312 JULY 25-AUG 24 70.0009/07/2021 234 UMPIRE JIM KWIATKOWSKI 535313 JULY 25-AUG 24 55.0009/07/2021 235 UMPIRE KYLE DEAN MCCURDY 535314 JULY 25-AUG 24 70.0009/07/2021 236 UMPIRE LIAM PHENEY 535324 JULY 25-AUG 24 40.0009/07/2021 237 UMPIRE ROBERT L. RIETZ JR. 535333 081221 160.0009/07/2021 238 UMPIRE ROBERT L. RIETZ JR. 535333 081921 160.0009/07/2021 239 UMPIRE EDWIN A RUNDLE 535335 JULY 25-AUG 24 110.0009/07/2021 240 UMPIRE MICHAEL VOITIK 535341 081221 160.0009/07/2021 241 UMPIRE MICHAEL VOITIK 535341 081921 160.0009/07/2021 242 UMPIRE ASSIGNING FEE WCSUA 535343 #1 384.0009/07/2021 243 08/05/21 PARK BOARD MEETING MARLYS J. YOUNG 535349 080521 31.5009/07/2021 244 UMPIRE EMMA ROBERTS 2198 JULY 25-AUG 24 55.0009/07/2021 245 UMPIRE MARK RUNYON 2200 JULY 25-AUG 24 115.00AP-210915VR 09/28/2021 01 UMPIRE :VOID 535395 JIM KWIATKOWSKI AUG 25-SEPT 15 55.00AP-210925M 09/20/2021 157 PLUG & PAY-JUL 2021 FEES FIRST NATIONAL BANK 900109 092521-S.REDMON 49.95AP-210928 09/21/2021 223 UMPIRE ERIC ADAMS 535351 AUG 25-SEPT 15 110.0009/21/2021 224 UMPIRE BENNETT ALLEN 535352 AUG 25-SEPT 15 120.0009/21/2021 225 SUMMER II CLASS INSTRUCTION ALL STAR SPORTS INST 535353 215018 1,125.0009/21/2021 226 UMPIRE DAVID BEEBE 535357 AUG 25-SEPT 15 110.0009/21/2021 227 UMPIRE WILLIAM BLAKE 535358 AUG 25-SEPT 15 165.0009/21/2021 228 UMPIRE W. THOMAS EVINS 535375 082821 70.0009/21/2021 229 UMPIRE ALLEN R. GOSS 535379 AUG 25-SEPT 15 110.0009/21/2021 230 UMPIRE JACKSON HAWKINSON 535380 AUG 25-SEPT 15 155.0009/21/2021 231 UMPIRE HAROLD HIX 535382 AUG 25-SEPT 15 110.0009/21/2021 232 UMPIRE NOLAN HOOPER 535383 AUG 25-SEPT 15 35.0009/21/2021 233 UMPIRE STEPHEN IRVING 535387 082621 160.0009/21/2021 234 UMPIRE STEPHEN IRVING 535387 090921 160.0009/21/2021 235 UMPIRE GREGORY JOHNSON 535389 AUG 25-SEPT 15 110.0009/21/2021 236 JUN 2021 MAGIC CLASS GARY KANTOR 535390 061721 30.0009/21/2021 237 UMPIRE EDSON KING JR 535392 091121 70.0009/21/2021 238 UMPIRE BENJAMIN KOZIAL 535393 AUG 25-SEPT 15 65.0009/21/2021 239 UMPIRE MATTHEW KRONSBEIN 535394 AUG 25-SEPT 15 110.0009/21/2021 240 UMPIRE JIM KWIATKOWSKI AUG 25-SEPT 15 55.0009/21/2021 241 UMPIRE JAVIER LASSALLE 535397 082821 105.0009/21/2021 242 UMPIRE MATTHEW J. LAWLESS 535398 091121 70.0009/21/2021 243 UMPIRE JACOB LIPSCOMB 535401 AUG 25-SEPT 15 55.0009/21/2021 244 UMPIRE MICHAEL F. MARCHETTI 535402 AUG 25-SEPT 15 55.0009/21/2021 245 UMPIRE KYLE DEAN MCCURDY 535403 AUG 25-SEPT 15 105.0009/21/2021 246 UMPIRE RYAN MEHOCHKO 535404 AUG 25-SEPT 15 85.0009/21/2021 247 ASSIGNING FEE FOR OFFICIALS CYNTHIA O'LEARY 535411 SOCCER FALL 2021 200.0009/21/2021 248 OFFICIAL ASSIGNING FEE CYNTHIA O'LEARY 535411 YORK REC FALL TOURNE 360.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 15TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. 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 249 FALL ASSIGNING FEE FOR CYNTHIA O'LEARY 535411 YORKVILLE REC-FALL 2 800.0009/21/2021 250 UMPIRE MARK PAWLOWSKI 535413 090921 160.0009/21/2021 251 UMPIRE STEVE PEARSON 535414 AUG 25-SEPT 15 55.0009/21/2021 252 UMPIRE LIAM PHENEY 535416 AUG 25-SEPT 15 190.0009/21/2021 253 UMPIRE ROBERT L. RIETZ JR. 535427 082621 160.0009/21/2021 254 UMPIRE ROBERT L. RIETZ JR. 535427 090921 160.0009/21/2021 255 UMPIRE EDWIN A RUNDLE 535428 AUG 25-SEPT 15 55.0009/21/2021 256 SOCCER TRAINING & DEVELOPMENT SCOT THOMAS ANDERSON 535429 2202-083121 385.0009/21/2021 257 UMPIRE TIM SIPES 535430 AUG 25-SEPT 15 55.0009/21/2021 258 UMPIRE JAMES A. TIETZ 535434 AUG 25-SEPT 15 165.0009/21/2021 259 UMPIRE MICHAEL VOITIK 535436 082621 160.0009/21/2021 260 UMPIRE MARK RUNYON 2214 AUG 25-SEPT 15 55.00GJ-210930FE 09/22/2021 19 PR CC Fees - Aug 2021 1,059.75_________________________________TOTAL PERIOD 05 ACTIVITY 10,798.14 55.0006 AP-211012 10/07/2021 191 UMPIRE BENNETT ALLEN 535444 SEPT 15-SEPT 27 40.0010/07/2021 192 UMPIRE DAVID BEEBE 535447 SEPT 15-SEPT 27 110.0010/07/2021 193 SEPT 15-SEPT 27 WILLIAM BLAKE 535448 SEPT 15-SEPT 27 275.0010/07/2021 194 UMPIRE TERENCE BOWMAN 535450 092321 160.0010/07/2021 195 UMPIRE JACKSON BULLINGTON 535451 SEPT 15-SEPT 27 165.0010/07/2021 196 UMPIRE W. THOMAS EVINS 535461 092521 70.0010/07/2021 197 UMPIRE ROBERT FERGUSTON 535462 SEPT 15-SEPT 27 55.0010/07/2021 198 UMPIRE ALLEN R. GOSS 535466 SEPT 15-SEPT 27 110.0010/07/2021 199 FALL ADULT SOFTBALL LEAGUE FEE BIG DAWG ATHLETICS L 535470 15 240.0010/07/2021 200 UMPIRE JACKSON HAWKINSON 535471 SEPT 15-SEPT 27 110.0010/07/2021 201 BACKGROUND CHECKS ILLINOIS STATE POLIC 535477 083121 423.7510/07/2021 202 UMPIRE STEPHEN IRVING 535480 091621 160.0010/07/2021 203 UMPIRE STEPHEN IRVING 535480 092321 160.0010/07/2021 204 UMPIRE GREGORY JOHNSON 535482 SEPT 15-SEPT 27 55.0010/07/2021 205 UMPIRE BENJAMIN KOZIAL 535487 SEPT 15-SEPT 27 40.0010/07/2021 206 UMPIRE JOESEPH KWIATKOWSKI 535626 SEPT 15-SEPT 27 275.0010/07/2021 207 UMPIRE JACOB LIPSCOMB 535490 SEPT 15-SEPT 27 110.0010/07/2021 208 UMPIRE KYLE DEAN MCCURDY 535494 SEPT 15-SEPT 27 150.0010/07/2021 209 UMPIRE RYAN MEHOCHKO 535495 SEPT 15-SEPT 27 50.0010/07/2021 210 UMPIRE CLIFFORD NWECHEFOM 535506 092521 105.0010/07/2021 211 UMPIRE STEVE PEARSON 535510 SEPT 15-SEPT 27 110.0010/07/2021 212 UMPIRE LIAM PHENEY 535512 SEPT 15-SEPT 27 125.0010/07/2021 213 UMPIRE ROBERT L. RIETZ JR. 535523 091621 160.0010/07/2021 214 UMPIRE ROBERT L. RIETZ JR. 535523 092321 160.0010/07/2021 215 UMPIRE TIM SIPES 535527 SEPT 15-SEPT 27 55.0010/07/2021 216 UMPIRE JAMES A. TIETZ 535529 SEPT 15-SEPT 27 55.0010/07/2021 217 UMPIRE MICHAEL VOITIK 535534 091621 160.0010/07/2021 218 UMPIRE BRYAN WALDE 535535 091821 105.00AP-211025M 10/20/2021 177 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900110 102521-E.WILLRETT 180.0010/20/2021 178 PLUG N PAY-SEPT 2021 FEES FIRST NATIONAL BANK 900110 102521-S.REDMON 39.07AP-211026 10/19/2021 176 UMPIRE ERIC ADAMS 535545 SEPT 30-OCT 12 55.0010/19/2021 177 UMPIRE BENNETT ALLEN 535547 SEPT 30-OCT 12 40.0010/19/2021 178 FALL I SESSION INSTRUCTION ALL STAR SPORTS INST 535548 216022 812.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 16TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________06 AP-211026 10/19/2021 179 UMPIRE WAYNE BAKER 535553 SEPT 30-OCT 12 110.0010/19/2021 180 UMPIRE WILLIAM BLAKE 535554 SEPT 30-OCT 12 220.0010/19/2021 181 UMPIRE JACKSON BULLINGTON 535555 SEPT 30-OCT 12 345.0010/19/2021 182 UMPIRE VICTOR CARBAJAL 535558 100221 105.0010/19/2021 183 UMPIRE RAIUMUNDO FONSECA 535566 SEPT 30-OCT 12 55.0010/19/2021 184 UMPIRE JACKSON HAWKINSON 535570 SEPT 30-OCT 12 105.0010/19/2021 185 UMPIRE DIEGO HUITRAN 535572 100221 70.0010/19/2021 186 UMPIRE DIEGO HUITRAN 535572 100921 70.0010/19/2021 187 UMPIRE DIEGO HUITRAN 535572 101221 35.0010/19/2021 188 08/29-09/28 COPY CHARGES IMPACT NETWORKING, L 535574 2276498 67.7710/19/2021 189 UMPIRE STEPHEN IRVING 535578 093021 160.0010/19/2021 190 UMPIRE GREGORY JOHNSON 535580 SEPT 30-OCT 12 55.0010/19/2021 191 UMPIRE KYLE DEAN MCCURDY 535586 SEPT 30-OCT 12 80.0010/19/2021 192 UMPIRE RYAN MEHOCHKO 535587 SEPT 30-OCT 12 40.0010/19/2021 193 UMPIRE CLIFFORD NWECHEFOM 535595 100921 70.0010/19/2021 194 UMPIRE LIAM PHENEY 535598 SEPT 30-OCT 12 95.0010/19/2021 195 UMPIRE ROBERT L. RIETZ JR. 535611 093021 160.0010/19/2021 196 UMPIRE TIM SIPES 535612 SEPT 30-OCT 12 55.0010/19/2021 197 UMPIRE PETER J. VAN HOOREWE 535617 SEPT 30-OCT 12 110.0010/19/2021 198 UMPIRE MICHAEL VOITIK 535618 093021 160.0010/19/2021 199 UMPIRE BRYAN WALDE 535619 101221 35.00GJ-211031FE 10/25/2021 19 PR CC Fees - Sept 2021 727.59_________________________________TOTAL PERIOD 06 ACTIVITY 7,850.18 0.0007 AP-211109 11/03/2021 290 UMPIRE ERIC ADAMS 535628 OCT 12-OCT 26 55.0011/03/2021 291 UMPIRE BENNETT ALLEN 535631 OCT 12-OCT 26 40.0011/03/2021 292 UMPIRE WAYNE BAKER 535635 OCT 12-OCT 26 110.0011/03/2021 293 UMPIRE DAVID BEEBE 535637 OCT 12-OCT 26 110.0011/03/2021 294 UMPIRE WILLIAM BLAKE 535639 OCT 12-OCT 26 330.0011/03/2021 295 UMPIRE JACKSON BULLINGTON 535641 OCT 12-OCT 26 185.0011/03/2021 296 UMPIRE JOHN ELENBAAS 535655 101621 70.0011/03/2021 297 UMPIRE RAIUMUNDO FONSECA 535660 OCT 12-OCT 26 55.0011/03/2021 298 UMPIRE JACKSON HAWKINSON 535667 OCT 12-OCT 26 110.0011/03/2021 299 UMPIRE DIEGO HUITRAN 535672 101421 35.0011/03/2021 300 UMPIRE STEPHEN IRVING 535677 101421 120.0011/03/2021 301 UMPIRE GREGORY JOHNSON 535679 OCT 12-OCT 26 55.0011/03/2021 302 OCT 2021 MAGIC CLASS GARY KANTOR 535680 OCT 2021 45.0011/03/2021 303 UMPIRE MATTHEW KRONSBEIN 535687 OCT 12-OCT 26 110.0011/03/2021 304 UMPIRE KYLE DEAN MCCURDY 535690 OCT 12-OCT 26 150.0011/03/2021 305 UMPIRE RYAN MEHOCHKO 535691 OCT 12-OCT 26 80.0011/03/2021 306 UMPIRE MARK PAWLOWSKI 535702 101321 120.0011/03/2021 307 UMPIRE LIAM PHENEY 535704 OCT 12-OCT 26 145.0011/03/2021 308 UMPIRE ROBERT L. RIETZ JR. 535715 101421 120.0011/03/2021 309 UMPIRE TIM SIPES 535718 OCT 12-OCT 26 55.0011/03/2021 310 UMPIRE PETER J. VAN HOOREWE 535723 OCT 12-OCT 26 110.0011/03/2021 311 UMPIRE BRYAN WALDE 535725 101421 35.0011/03/2021 312 UMPIRE BRYAN WALDE 535725 101621 105.0011/03/2021 313 UMPIRE ASSIGNING FEE WCSUA 535728 2 273.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 17TIME: 09:22:25 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________07 AP-211109 11/03/2021 314 UMPIRE MARK RUNYON 2275 OCT 12-OCT 26 55.00AP-211123 11/15/2021 233 09/28-10/28 COPY CHARGES IMPACT NETWORKING, L 535764 2311729 64.62AP-211125M 11/17/2021 215 PLUG N PAY-SEPT 2021 FEES FIRST NATIONAL BANK 900111 112521-S.REDMON 30.00GJ-211130FE 12/01/2021 19 PR CC Fees - Oct 2021 887.94_________________________________TOTAL PERIOD 07 ACTIVITY 3,660.56 0.00YTD BUDGET 81,666.69 TOTAL ACCOUNT ACTIVITY 61,933.92 55.00ANNUAL REVISED BUDGET 140,000.00 ENDING BALANCE 61,878.92_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.00AP-210511B 05/05/2021 44 JUN 2021 COPIER LEASE DLL FINANCIAL SERVIC 534629 72214154 185.00AP-210525MB 05/25/2021 20 TBS-ANNUAL LICENSE RENEWAL FIRST NATIONAL BANK 900103 052521-S.AUGUSTINE-B 795.00GJ-21629PRE 06/29/2021 53 Sound Inc-May Srvc Agrrmnt 97.0006/29/2021 55 Delage-May Copier Lease 185.00_________________________________TOTAL PERIOD 01 ACTIVITY 1,262.00 0.0002 AP-210614B 06/08/2021 02 JUL 2021 COPIER LEASE DLL FINANCIAL SERVIC 105030 72537061 185.0006/08/2021 03 NEW BOND OFFICIAL-RENEWAL LIBERTY MUTUAL INSUR 999061264-060121 800.0006/08/2021 04 BOND RENEWAL LIBERTY MUTUAL INSUR LSF037877-0320335-05 456.0006/08/2021 05 JUN-AUG 2021 TELEPHONE & SOUND INCORPORATED 105034 R173903 291.0006/08/2021 06 MAY-JUL 2021 ELEVATOR THYSSENKRUPP ELEVATO 105035 3005903516 578.3706/08/2021 07 ANNUAL LICENSE FEE REWAL & TODAY'S BUSINESS SOL 105036 11859 1,244.0006/08/2021 08 05/10/21 MEETING MINUTES MARLYS J. YOUNG 105038 051021 114.7506/08/2021 09 05/17/21 MEETING MIYTES MARLYS J. YOUNG 105038 051721 43.2506/08/2021 10 05/24/21 MEETING MINUTES MARLYS J. YOUNG 105038 052421 69.50AP-210615R 06/16/2021 01 BOND RENEWAL LIBERTY MUTUAL INSUR 105039 LSF037877-0320335-05 456.00AP-210616VD 06/16/2021 01 NEW BOND OFFICIAL-:VOID 105031 LIBERTY MUTUAL INSUR 999061264-060121 800.0006/16/2021 02 BOND RENEWAL :VOID 105031 LIBERTY MUTUAL INSUR LSF037877-0320335-05 456.00_________________________________TOTAL PERIOD 02 ACTIVITY 4,237.87 1,256.0003 AP-210712 07/07/2021 03 FY22 E-RATE CONSULTING SERVICE E-RATE FUND SERVICES 105042 485 400.0007/07/2021 04 WEBSITE DESIGN SERVICE - WEBLINX INCORPORATED 105050 30270 1,650.0007/07/2021 05 ANNUAL FEE FOR WORDPRESS BASE WEBLINX INCORPORATED 105050 30274 200.0007/07/2021 06 WEBSITE DESIGN CHANGES FEE WEBLINX INCORPORATED 105050 30295 62.5007/07/2021 07 05/24/21 MEETING MINUTES MARLYS J. YOUNG 105051 052421-2 105.4007/07/2021 08 06/14/21 MEETING MINUTES MARLYS J. YOUNG 105051 061421 105.4007/07/2021 09 06/21/21 MEETING MINUTES MARLYS J. YOUNG 105051 062121 78.75AP-210713B 07/07/2021 320 AUG 2021 COPIER LEASE DLL FINANCIAL SERVIC 534932 72866312 185.00AP-210727 07/20/2021 243 REFUND FOR 06/14/21 MINUTES MARLYS J. YOUNG 535107 061421-RFND 105.4007/20/2021 244 06/30/21 MEETING MINUTES MARLYS J. YOUNG 535107 063021 46.2507/20/2021 245 07/07/21 MEETING MINUTES MARLYS J. YOUNG 535107 070721 39.50_________________________________TOTAL PERIOD 03 ACTIVITY 2,872.80 105.4004 AP-210809 08/03/2021 01 SEPT 2021 COPIER LEASE DLL FINANCIAL SERVIC 105054 73193559 185.0008/03/2021 02 04/15-07/14 COPIER CHARGES IMPACT NETWORKING, L 105055 2197254 169.6208/03/2021 03 APR 2021 ONLINE IT SUPPORT LLOYD WARBER 105056 10500 720.0008/03/2021 04 MAY 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10501 720.0008/03/2021 05 JUN 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10502 720.00 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 18TIME: 09:22:32 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________04 AP-210809 08/03/2021 06 JUL 2021 ON SITE IT SUPPORT LLOYD WARBER 105056 10503 1,080.0008/03/2021 07 1ST QTR COST FOR FAXES TODAY'S BUSINESS SOL 105062 071221-73 24.4808/03/2021 08 07/07/21 LIB COMMUNITY MARLYS J. YOUNG 105063 070721-LIB 63.0008/03/2021 09 07/12/21 MEETING MINUTES MARLYS J. YOUNG 105063 071221 76.7508/03/2021 10 07/07/21 MEETING MINUTES MARLYS J. YOUNG 105063 07721-LIB REL 63.00AP-210810 08/04/2021 195 BACKGROUND CHECKS ILLINOIS STATE POLIC 535142 063021 28.25AP-210825M 08/19/2021 266 PHYSICIANS-DRUG TESTING FIRST NATIONAL BANK 900108 082521-E.WILLRETT 45.0008/19/2021 267 SMITHEREEN-JULY 2021 PEST FIRST NATIONAL BANK 900108 082521-S.AUGUSTINE 78.00_________________________________TOTAL PERIOD 04 ACTIVITY 3,973.10 0.0005 AP-210913 09/07/2021 06 2021 ANNUAL SPRINKER GREAT LAKES PLUMBING 105067 23972 450.0009/07/2021 07 AUG 2021 ONSITE IT SUPPORT LLOYD WARBER 105068 10508 750.0009/07/2021 08 AUG-OCT 2021 ELEVATOR TK ELEVATOR CORPORAT 105072 3006071458 578.3709/07/2021 09 INSTALL NEW CAR CALL BUTTON TK ELEVATOR CORPORAT 105072 5001549298M1 550.3709/07/2021 10 ACCESS CONTROL CLOUD UMBRELLA TECHNOLOGIE 105073 1091 960.0009/07/2021 11 07/19/21 MEETING MINUTES MARLYS J. YOUNG 105074 071921 56.2509/07/2021 12 08/09/21 MEETING MINUTES MARLYS J. YOUNG 105074 080921 45.50AP-210914 09/07/2021 261 OCT 2021 COPIER LEASE DLL FINANCIAL SERVIC 535283 73505558 185.0009/07/2021 262 CREDIT FOR 07/12 MEETING MARLYS J. YOUNG 535349 082121-CR 63.00AP-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.0006 AP-211011 10/07/2021 07 SEPT 2021 ON SITE IT SUPPORT LLOYD WARBER 105077 10510 750.0010/07/2021 08 08/09/21 MEETING MINUTES MARLYS J. YOUNG 105082 080921-LIB 61.7510/07/2021 09 09/08/21 LIB POLICY MEETING MARLYS J. YOUNG 105082 090821 70.50AP-211012 10/07/2021 248 NOV 2021 COPIER LEASE DLL FINANCIAL SERVIC 535457 73836543 185.00AP-211025M 10/20/2021 229 PHYSICIANS CARE-DRUG SCREENING FIRST NATIONAL BANK 900110 102521-E.WILLRETT 90.00_________________________________TOTAL PERIOD 06 ACTIVITY 1,157.25 0.0007 AP-211108 11/02/2021 04 OCT 2021 ON SITE IT SUPPORT LLOYD WARBER 105088 10512 720.0011/02/2021 05 HOSTED VOIP TCG SOLUTIONS, INC 105095 21-0618 445.0011/02/2021 06 HOSTED VOIP TCG SOLUTIONS, INC 105095 21-0619 445.0011/02/2021 07 HOSTED VOIP TCG SOLUTIONS, INC 105095 21-0620 445.0011/02/2021 08 HOSTED VOIP, INSTALLED NEW TCG SOLUTIONS, INC 105095 21-0621 1,445.0011/02/2021 09 11/01/21-01/31/22 ELEVATOR TK ELEVATOR CORPORAT 105096 3006261402 597.3411/02/2021 10 ANNUAL WEBSITE HOSTING FEE WEBLINX INCORPORATED 105097 30722 300.0011/02/2021 11 09/13/21 MEETING MINUTES MARLYS J. YOUNG 105098 091321 72.5011/02/2021 12 10/11/21 MEETING MINUTES MARLYS J. YOUNG 105098 101121 59.50AP-211109 11/03/2021 342 DEC 2021 COPIER LEASE DLL FINANCIAL SERVIC 535644 74167691 185.0011/03/2021 343 07/15-10/14 COPIER CHARGES IMPACT NETWORKING, L 535674 2299426 236.24AP-211125M 11/17/2021 267 PHYSICIANS CARE-DRUG SCREEN FIRST NATIONAL BANK 900111 112521-E.WILLRETT 45.00_________________________________TOTAL PERIOD 07 ACTIVITY 4,995.58 0.00YTD BUDGET 23,333.35 TOTAL ACCOUNT ACTIVITY 22,874.09 1,424.40ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 21,449.69_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.0007 AP-211123 11/15/2021 245 TIF COMPLIANCE LAUTERBACH & AMEN, L 535773 60636 186.67_________________________________TOTAL PERIOD 07 ACTIVITY 186.67 0.00YTD BUDGET 1,166.69 TOTAL ACCOUNT ACTIVITY 186.67 0.00ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 186.67 DATE: 12/08/2021 UNITED CITY OF YORKVILLE PAGE: 19TIME: 09:22:39 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2022ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.0002 AP-210622B 06/15/2021 181 DOWNTOWN TIF LEGAL MATTERS KATHLEEN FIELD ORR & 2103 16542 330.00_________________________________TOTAL PERIOD 02 ACTIVITY 330.00 0.0007 AP-211123 11/15/2021 247 TIF COMPLIANCE LAUTERBACH & AMEN, L 535773 60636 186.6711/15/2021 248 DOWNTOWN TIF MATTERS KATHLEEN FIELD ORR & 2289 16704 82.50_________________________________TOTAL PERIOD 07 ACTIVITY 269.17 0.00YTD BUDGET 2,916.69 TOTAL ACCOUNT ACTIVITY 599.17 0.00ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 599.17_____________________________________________________________________________________________________________________________________________________89-890-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2021 BEGINNING BALANCE 0.0002 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.0004 AP-210824 08/17/2021 311 DOWNTOWN TIF II MATTERS KATHLEEN FIELD ORR & 2174 16618 55.00_________________________________TOTAL PERIOD 04 ACTIVITY 55.00 0.0006 AP-211012 10/07/2021 250 DOWNTOWN TIF II MATTERS KATHLEEN FIELD ORR & 2231 16670 110.00AP-211012M 10/11/2021 05 DOWNTOWN TIF II MATTERS KATHLEEN FIELD ORR & 2246 16641 88.00_________________________________TOTAL PERIOD 06 ACTIVITY 198.00 0.0007 AP-211123 11/15/2021 251 TIF COMPLIANCE LAUTERBACH & AMEN, L 535773 60636 186.6611/15/2021 252 DOWNTOWN TIF II MATTERS KATHLEEN FIELD ORR & 2289 16704 82.50_________________________________TOTAL PERIOD 07 ACTIVITY 269.16 0.00YTD BUDGET 2,916.69 TOTAL ACCOUNT ACTIVITY 610.16 0.00ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 610.16GRAND TOTAL 261,494.98 0.00TOTAL DIFFERENCE 261,494.98 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-54 Treasurer’s Report for November 2021 Administration Committee – December 15, 2021 Majority Approval Rob Fredrickson Finance Name Department Beginning Fund Balance Nov Revenues YTD Revenues Revenue Budget % of Budget Nov Expenses YTD Expenses Expense Budget % of Budget Projected Ending Fund Balance General Fund01 - General 9,172,352$ 1,276,332$ 13,687,325$ 18,100,270$ 76%1,443,996$ 9,859,096$ 18,100,270$ 54%13,000,580$ Special Revenue Funds15 - Motor Fuel Tax1,243,821 60,626 735,642 1,260,019 58%6,149 503,990 2,435,413 21%1,475,473 79 - Parks and Recreation 73,002 162,819 1,376,095 2,643,058 52% 170,211 1,406,223 2,716,058 52% 42,874 72 - Land Cash 31,131 - 1,329 25,760 5% - - 5,000 0% 32,460 87 - Countryside TIF (1,211,223) 2 250,366 260,727 96% 162,021 216,268 223,397 97% (1,177,125) 88 - Downtown TIF (1,448,929) 530 96,795 70,000 138% 3,812 268,041 291,412 92% (1,620,175) 89 - Downtown TIF II (47,869) 3,204 78,764 48,526 0% 17,769 37,415 30,500 123% (6,520) 11 - Fox Hill SSA 10,231 0 16,034 19,000 84% 487 4,688 59,200 8% 21,577 12 - Sunflower SSA (8,409) 87 20,363 21,000 97% 460 9,569 17,200 56% 2,385 Debt Service Fund42 - Debt Service - 27,481 194,419 329,375 59% - 9,925 329,375 3% 184,494 Capital Project Funds25 - Vehicle & Equipment 1,485,790 21,154 243,038 547,226 44% 24,783 401,263 1,877,998 21% 1,327,565 24 - Buildings & Grounds - 627 8,793,301 9,584,249 92% 24,524 2,385,854 9,584,249 25% 6,407,447 23 - City-Wide Capital 119,566 1,273,919 4,068,783 5,808,072 70% 1,113,827 1,841,611 5,545,285 33% 2,346,739 Enterprise Funds *51 - Water3,901,358 49,678 2,947,359 5,061,271 58%664,237 2,389,624 6,081,733 39%4,459,094 *52 - Sewer864,688 60,423 1,217,604 2,275,602 54%58,494 556,208 2,428,579 23%1,526,084 Library Funds82 - Library Operations638,033 12,733 1,670,916 1,692,702 99%69,446 498,020 1,709,443 29%1,810,929 84 - Library Capital169,187 13,267 85,342 50,200 170%14,878 29,679 95,500 31%224,851 Total Funds14,992,729$ 2,962,883$ 35,483,475$ 47,797,057$ 74%3,775,092$ 20,417,472$ 51,530,612$ 40%30,058,732$ * Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending November 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-55 Cash Statement for September 2021 Administration Committee – December 15, 2021 Informational None Rob Fredrickson Finance Name Department First National West Suburban Associated / PMA Illinois Trust Illinois Funds Old Second Grand Totals Restricted at IMET General Fund 01 - General 5,091,275$ 309,514$ 1,893,987$ 101,147$ 4,088,213$ -$ 11,484,135$ 38,814$ Special Revenue Funds 15 - Motor Fuel Tax (175,482) - - - 1,394,692 - 1,219,210 - 79 - Parks and Recreation 177,898 - - - - - 177,898 - 72 - Land Cash 32,268 - - - - - 32,268 - 87 - Countryside TIF (1,038,261) - - - - - (1,038,261) - 88 - Downtown TIF (1,577,139) - - - - - (1,577,139) - 89 - Downtown TIF II 7,982 - - - - - 7,982 - 11 - Fox Hill SSA 22,283 - - - - - 22,283 - 12 - Sunflower SSA 2,581 - - - - - 2,581 - Debt Service Fund 42 - Debt Service 129,356 - - - - - 129,356 - Capital Project Funds 23 - City-Wide Capital 4,869,565 179,905 819,071 - - - 5,868,541 48,918 24 - Buildings & Grounds (182,174) - 6,374,185 - - - 6,192,012 - 25 - Police Capital 274,952 - - - - - 274,952 - 25 - General Gov Capital (151,824) - - - - - (151,824) - 25 - Public Works Capital 691,692 - - - - - 691,692 - 25 - Park & Rec Capital 837,527 - - - - - 837,527 1,116 Enterprise Funds 51 - Water 1,467,267 941,840 1,449,946 - - - 3,859,054 6,503 52 - Sewer 282,295 325,280 529,326 - - - 1,136,901 30,564 Agency Funds 90 - Developer Escrow 179,030 - - - - - 179,030 - 95 - Escrow Deposit (426,390) 781,793 - - - - 355,403 - Total City Funds 10,514,703$ 2,538,332$ 11,066,515$ 101,147$ 5,482,905$ -$ 29,703,602$ 125,915$ Distribution %35.40%8.55%37.26%0.34%18.46% Library Funds 82 - Library Operations 63$ -$ -$ -$ 283,127$ 971,994$ 1,255,184$ 3,771$ 84 - Library Capital 9,750 - - - - 206,641 216,391 - Library Totals 9,813$ -$ -$ -$ 283,127$ 1,178,636$ 1,471,575$ 3,771$ Distribution %0.67%19.24%80.09% UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY - as of September 30, 2021 Cash Summary 1 Financial Accrued Type of Investment Institution FDIC #Interest Rate Original Cost Maturity Date Interest to Date Value at Maturity Fund Certificate of Deposit (CD)Servisfirst Bank 57993 0.16%249,500 6/20/2022 110 249,902 General (01) Certificate of Deposit (CD)Western Alliance Bank 57512 0.21%249,400 2/28/2022 304 249,912 General (01) Certificate of Deposit (CD)Preferred Bank 33539 0.15%249,600 6/20/2022 104 249,972 General (01) Certificate of Deposit (CD)Royal Business Bank 58816 0.06%249,900 12/15/2021 41 249,975 General (01) 998,400$ 560$ 999,759$ UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY - as of September 30, 2021 Investments Summary Investment Totals 2 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-56 Website Report for November 2021 Administration Committee – December 15, 2021 Informational None See attached memo. Erin Willrett Administration Name Department 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 Total Visits Total Visits Summary Yorkville’s website and social media analytics report for November 2021. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is November 1, 2021 – November 30, 2021. Website Visits: Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 April 2021 May 2021 June 2021 July 2021 Aug 2021 Sept 2021 Oct 2021 Nov 2021 Unique Visitors 11,685 10,221 10,665 10,985 15,434 15,619 16,445 21,824 31,022 26,945 36,752 21,042 33,770 Returning Visits 4,424 3,541 3,640 3,999 5,677 5,618 5,260 7,902 10,418 6,545 8,662 5,942 5,632 Total Visits 14,742 12,649 13,302 13,863 19,861 19,808 20,395 27,988 38,999 31,848 30,154 25,347 37,917 Visit Times (Averages):  3 minutes 37 seconds average visit duration  2.2 actions (page views, downloads, outlinks and internal site searches) per visit Memorandum To: Administration Committee From: Erin Willrett, Assistant Administrator CC: Bart Olson, City Administrator Date: December 15, 2021 Subject: Website Report for November 2021 Website Statistics: September 2021 October 2021 November 2021i Top 5 Pages Visited 1. Hometown Days Festival 2. Homepage 3. Jobs 4. Facilities 5. Online Utility Payments 1. Homepage 2. Online Utility Payments 3. My GovHub Transition Page 4. Parks and Recreation 5. Job Opportunities 1. Homepage 2. Holiday Celebration Weekend 3. Online Utility Payments 4. My GovHub Transition Page 5. Pick-Up/Service Schedules September 2021 October 2021 November 2021ii Top 5 Downloads 1. Hometown Days Schedule 2. Senior Services & Programs 3. Parkway Tree Program 4. Annual Drinking Water Report 5. Administrative Asst Job Description 1. Annual Drinking Water Report 2. Senior Services & Programs 3. Meter Read Information 4. Residential Permit Application 5. Parks Map and Matrix 1. Annual Drinking Water Report 2. Rudolph Run Route Map 3. Annual Meeting Schedule 4. Support Assistant Job Description 5. Meter Read Information September 2021 October 2021 November 2021 Top 5 Searches 1. Meter 2. Basketball 3. Garbage 4. Request for Meter Reading 5. Water 1. Basketball 2. Halloween Trick or Treating 3. Meter 4. Halloween 5. Garbage 1. Meter 2. 2021 City Leaf Pick-Up (#4, #5) 3. Basketball 4. Request for Meter Reading 5. Garbage September 2021 October 2021 November 2021 Top 5 Website Referrers 1. Facebook 2. enjoyaurora.com 3. americanenglish.com 4. envirobidnet.com 5. search.aol.com 1. Facebook 2. wspynews.com 3. envirobidnet.com 4. patch.com 5. newsbreakapp.com 1. Facebook 2. newsbreakapp.com 3. patch.com 4. envirobident.com 5. enjoyaurora.com City Facebook Data: November 2021 Total Page Followers: 6,765 (an increase of 46 followers from October) Total Page Likes: 6,501 Total Average Reach: 1,497 Highest Viewed Post: “We’re hiring! …” (Posted November 17, 2021) Highest Viewed Post Reach: 4,551; 358 Post Clicks; 48 Reactions, Comments & Shares Parks and Recreation Facebook Data: November 2021 Total Page Followers: 4,446 (an increase of 56 followers from October) Total Page Likes: 4,285 Total Average Reach: 1,276 Highest Viewed Post: “Holiday Celebration Tonight! ...” (Posted November 19, 2021) Highest Viewed Post Reach: 7,241; 400 Post Clicks; 99 Reactions, Comments & Shares Police Facebook Data: November 2021 Total Page Followers: 6,393 (an increase of 79 followers from October) Total Page Likes: 5,968 Total Average Reach: 3,279 Highest Viewed Post: “Help reunite these two with their family.…” (Posted November 24, 2021) Highest Viewed Post Reach: 17,436; 1,018 Post Clicks; 326 Reactions, Comments & Shares City Twitter Data: November 2021 Total Followers: 1,725 (A decrease of 2 followers from October) Total Tweet Impressions: 2,962 Total Profile Visits: 400 Top Tweet (earned 299 Impressions): “…The City Leaf Pick-Up will be…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/; https://www.yorkville.il.us/490/Holiday-Celebration-Weekend; https://www.yorkville.il.us/131/Online-Utility-Payments; https://www.yorkville.il.us/573/MyGovHub-Transition-Page; https://www.yorkville.il.us/187/Pickup-Service-Schedules ii https://www.yorkville.il.us/DocumentCenter/View/7667/2020-Annual-Drinking-Water-Quality-Report-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/7984/Rudolph-Run-Route-Map-2021?bidId=; https://www.yorkville.il.us/DocumentCenter/View/1728/Annual-Meeting-Schedule-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/8030/Support-Assistant-Job-Description-111721?bidId=; https://www.yorkville.il.us/faq.aspx?qid=65 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 #5 Tracking Number ADM 2021-57 Sales Tax Performance and Budget Projections Administration Committee – December 15, 2021 Informational None Rob Fredrickson Finance Name Department Summary A review of the City’s historical municipal and non-home rules sales tax performance and revised budget projections for the current (FY 22) and subsequent (FY 23) fiscal years. Background Excluding the three business districts, the total general merchandise sales tax rate for the United City of Yorkville is 8.25%, which is broken down between various units of local government as follows: • 5% - State of Illinois sales tax rate • 1% - Yorkville - municipal sales tax rate • 1% - Yorkville – non-home rule (NHR) sales tax rate • 1% - Kendall County – public safety sales tax rate • 0.25% - Kendall County sales tax rate The City’s sales tax rate on qualifying food, drugs and medical appliances is 1%, a 100% of which goes to the City as municipal sales tax (qualifying food, drugs and medical appliances are exempt from non-home rule sales tax). Combined sales taxes are the largest source of revenue for the General Fund, accounting for 32% of total revenues for the FYE 2021 (18% - municipal sale / 14% NHR sales). Municipal Sales Tax As indicated by the graph above, pre-pandemic municipal sales tax revenues steadily increased by an annualized average of around 2% between FY 09 and FY 19. In FY 20, annual sales tax increased by ~5%, as this revenue stream was bolstered by sharp increases in consumer sales in the waning months of the fiscal year stemming from the onset of the COVID-19 pandemic. $2,250,000 $2,750,000 $3,250,000 $3,750,000 $4,250,000 $4,750,000 FY 09 FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 Proj Municipal Sales Tax -Fiscal Year 2009 thru Fiscal Year 2022 Memorandum To: Administration Committee From: Rob Fredrickson, Finance Director Date: December 9, 2021 Subject: Sales Tax Performance & Budget Projections Municipal Sales Taxes Fiscal Fiscal Year Year Actual % Change 2009 $ 2,499,754 - 2010 2,446,099 -2.15% 2011 2,569,233 5.03% 2012 2,552,483 -0.65% 2013 2,490,503 -2.43% 2014 2,586,460 3.85% 2015 2,704,651 4.57% 2016 2,778,116 2.72% 2017 2,940,976 5.86% 2018 3,002,133 2.08% 2019 3,070,663 2.28% 2020 3,222,256 4.94% 2021 3,617,361 12.26% 2022 Proj 4,262,241 17.83% As we moved into FY 22 sales taxes have continued their upward trajectory, as fiscal year-to-date (FYTD) proceeds from July through November 2021 (April thru August 2021 consumer sales) totaled $1,885,776; an increase of $428,399 (29%) in comparison to that same time frame last year. Assuming an average 10% growth rate over the remaining months of FY 22, this would yield a projected amount of $4.26M, which is up 18% over FY 21 amounts. Fiscal Fiscal Year Fiscal Year $ Over (Under) Fiscal Year $ Over (Under) % of Year Actual Projected Projected % Over (Under) Budget Budget Budget 2017 $ 2,940,976 $ 2,925,000 $ 15,976 0.55% $ 2,800,920 $ 140,056 105.00% 2018 3,002,133 2,965,000 37,133 1.25% 3,012,750 (10,617) 99.65% 2019 3,070,663 3,090,000 (19,337) -0.63% 3,009,475 61,188 102.03% 2020 3,222,256 3,220,000 2,256 0.07% 3,151,800 70,456 102.24% 2021 3,617,361 3,512,263 105,098 2.99% 3,284,400 332,961 110.14% 2022 4,262,241 4,262,241 - - 3,582,508 679,733 118.97% The above table compares actual sales tax figures to budgeted (light gray shading) and projected amounts, as reflected in each year’s respective budget documents (dark grey). In the pre-pandemic era (FY 17 thru FY 19) projected sales tax amounts were fairly precise, only deviating between +/-1% when compared to actual amounts. The same held true for FY 20, as projected amounts were off a nominal .07% from actual. However, in FY 21, as sales tax began its meteoric rise, this revenue stream became more erratic and difficult to project. As a result, when crafting the FY 22 budget last February, staff projected a 9% increase (which is more than three times the City’s historical norm) in sales tax for the FY 21 projected number ($3.51M) based on the information available at that time. This number served as the base in which FY 22 budgeted sales tax was projected – which was increased by an estimated 2% (pursuant to the City’s past practice of conservatively projecting sales tax growth in conjunction with all the systemic risk currently in the economy due to the ongoing pandemic) – yielding a budget number of $3,582,508. Happily, sales tax actually increased by 12% for the FYE 21; however, this unfortunately left the FY 22 budgeted number artificially low. Sales taxes were particularly vigorous during the latter half of FY 21, due to the resiliency of the local economy, pent up demand from the ongoing COVID-19 pandemic and statutory changes regarding how sales tax proceeds are sourced. In the past, tax revenues from products purchased on the internet that were used or consumed in Illinois, were distributed to municipalities on a per-capita basis (i.e., local use tax). With the new sourcing law that went into effect July 1, 2020, most on-line retailers are now required to collect both State and locally imposed sales taxes on products being used or consumed within Yorkville. The effect of these statutory changes, in combination with other local and macro-economic factors, resulted in the City experiencing unprecedented increases over the course of FY 21, as sales tax proceeds increased by over 12% ($395,105). In response, staff has projected out a revised FY 22 sales tax number of $4.26M – which assumes an average growth rate of 10% for sales tax proceeds to be received in the months of December 21 thru June 22 (September 21 thru April 22 consumer sales). Additionally, staff would recommend that any sales taxes received in excess of that amount be transferred to the (24) Building & Grounds and/or (23) City-Wide Capital Funds to aid in the financing of the 651 Prairie Point building renovation and/or other roadway related capital projects. Unless, directed otherwise, these revisions will be reflected in the upcoming FY 23 budget draft. Account FY 2021 FY 2022 FY 2022 % of % Inc (Dec) Number Description Actual Budget Projected Budget over FY 21 01-000-40-00-4030 Municipal Sales Tax $ 3,617,361 $ 3,582,508 $ 4,262,241 119% 18% Non-Home Rule (NHR) Sales Tax Non-Home Rule (NHR) sales tax was voted into existence via referendum and was implemented on January 1, 2012, as a funding mechanism for the 2011 Refunding Bond. Similar to the sales tax graph presented earlier, pre- pandemic non-home rule sales tax revenues steadily increased by an annual average of around 3.5% between FY 14 and FY 19. In FY 20, annual NHR sales tax growth was muted a bit, only increasing by about 2%, as this revenue stream was negatively effected by the onset of the COVID-19 pandemic, as consumer purchases focused more on food and other related household items, which are exempt from NHR sales. $1,500,000 $1,750,000 $2,000,000 $2,250,000 $2,500,000 $2,750,000 $3,000,000 $3,250,000 $3,500,000 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 Proj Non-Home Rule Sales Tax -Fiscal Year 2013 thru Fiscal Year 2022 Non-Home Rule Sales Taxes Fiscal Fiscal Year Year Actual % Change FY 13 $ 1,919,423 - FY 14 1,986,566 3.50% FY 15 2,078,061 4.61% FY 16 2,126,851 2.35% FY 17 2,259,787 6.25% FY 18 2,325,623 2.91% FY 19 2,358,568 1.42% FY 20 2,413,689 2.34% FY 21 2,724,628 12.88% FY 22 Proj 3,282,882 20.49% As we moved into FY 22, NHR sales taxes have increased at even greater rate than municipal sales, as fiscal year- to-date (FYTD) proceeds from July through November 21 (April thru August 21 consumer sales) totaled $1,488,953, an increase of $394,730 (36%) in comparison to that same time frame last year. Assuming an average 10% growth rate over the remaining months of FY 22, would yield a projected amount of $3.28M, which is up 21% over FY 21 amounts. Fiscal Fiscal Year Fiscal Year $ Over (Under) Fiscal Year $ Over (Under) % of Year Actual Projected Projected % Over (Under) Budget Budget Budget 2017 $ 2,259,787 $ 2,265,000 $ (5,213) -0.23% $ 2,157,300 $ 102,487 104.75% 2018 2,325,623 2,305,000 20,623 0.89% 2,332,950 (7,327) 99.69% 2019 2,358,568 2,385,000 (26,432) -1.11% 2,339,575 18,993 100.81% 2020 2,413,689 2,445,000 (31,311) -1.28% 2,432,700 (19,011) 99.22% 2021 2,724,628 2,597,523 127,105 4.89% 2,493,000 231,628 109.29% 2022 3,282,882 3,282,882 - - 2,649,473 633,409 123.91% The above table compares actual NHR sales tax amounts with what was initially budgeted (light gray shading) and projected. Like municipal sales, during the pre-pandemic era (FY 17 thru FY 19) NHR sales tax projected amounts were fairly precise, only deviating approximately +/-1% in comparison to actual amounts. The same held true for FY 20, as projected amounts were off a nominal -1.28% from actual figures. However, in FY 21, just like sales tax, this revenue stream became more erratic and difficult to project. As a result, when crafting the FY 22 budget last February, staff projected an 8% increase in NHR sales tax for the FY 21 projected number ($2.6M). This number served as the base in which FY 22 budgeted NHR sales tax was projected – which, like municipal sales, was increased by an estimated 2% – yielding a budget number of $2,649,473. NHR sales actually eclipsed municipal sales by 1%, increasing by 13% for the FYE 21; however, this unfortunately left the FY 22 budgeted number artificially low. After lagging in the early months of FY 21, NHR Sales taxes came roaring back as the fiscal year progressed, as consumers began to increasingly purchase general merchandise items. Like municipal sales, new sourcing laws that went into effect on January 1, 2021, requiring most on-line retailers to collect locally imposed (i.e., NHR) sales taxes on products being used or consumed within Yorkville. The effect of these statutory changes in combination with other local and macro-economic factors resulted in the City experiencing unprecedented increases over the course of FY 21, as NHR sales tax proceeds increased by ~13% ($310,939). Again, in response, staff has projected out a revised FY 22 NHR sales tax number of $3.28M – which assumes an average growth of 10% for NHR sales tax proceeds to be received in the months of December 21 thru June 22 (September 21 thru April 22 consumer sales). As with municipal sales, staff would recommend that any NHR sales taxes received in excess of that amount be transferred to the (24) Building & Grounds and/or (23) City-Wide Capital Funds to aid in the financing of the 651 Prairie Point building renovation and/or other roadway related capital projects. Unless, directed otherwise, these revisions will be reflected in the upcoming FY 23 budget draft. Account FY 2021 FY 2022 FY 2022 % of % Inc (Dec) Number Description Actual Budget Projected Budget over FY 21 01-000-40-00-4035 Non-Home Rule Sales Tax $ 2,724,628 $ 2,649,473 $ 3,282,882 124% 20% Recommendation Informational. 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 #6 Tracking Number ADM 2021-58 Minute Taker Review Administration Committee – December 15, 2021 Majority Approval Erin Willrett Administration Name Department Summary Consideration of a vote to repeal Resolution 2007-37 A Policy for Minute Taker’s Hourly Wages. Background City Council last approved the Minute Taker’s hourly wages in 2007. Since that time, inflation has occurred, and adjustments have not been made. Rather than amending this contractor’s compensation through a City Council vote, we would like to repeal that section of City Code and have staff adjust that rate annually, as needed. As some general insight into the staff’s compensation recommendation (which the City Council would not have to approve in the future), the minute taker is currently paid a base rate of $35.00 for meetings up to two hours. For meetings over two hours, additional meeting time is paid at the rate of $17.50 per hour. They are paid for transcription at 2 x the length of the meeting. For typed minutes turned in within one week the transcription rate is $14.00 per hour. For typed minutes turned in over one week the transcription rate is $12.50 per hour. An example of payment for a one-hour Administration Committee meeting under the current rate structure, would be $63. Again, these rates have not changed since 2007. For the remainder of this fiscal year (FY22), staff will change the rate to $85 flat rate per meeting, with no additional transcription rate. The proposed payment would be $85 for that same one-hour Administration Committee meeting. This is approximately a 35% increase over the current rate structure, but that percentage increase is variable depending on the length of the meeting. The City’s current minute taker is extremely reliable and does a great job in getting minutes turned in on time without any reminders. Staff is also recommending a $40 flat cancellation fee for any meeting that is cancelled two hours prior to the meeting start time. The minute taker blocks out time to be available for our meetings and in the case of a meeting that was cancelled shortly before the start of the meeting, they may have already traveled to City Hall to attend the meeting. This fiscal year, there has been no meeting cancellations. This is rarely used, but it is a practice that would be helpful to recognize the time that the minute taker blocks off. Staff completed a survey of 16 communities of those 16, only 1 uses a contractor as minute taker. The City of Batavia does use a minute taker and pays $25.07/hour. Most municipalities are paying their hourly staff overtime to fulfill this duty. We have looked at our internal employees and hourly rates and we feel it is better to continue to outsource this function. Memorandum To: City Council From: Erin Willrett, Assistant City Administrator CC: Bart Olson, City Administrator Date: December 14, 2021 Subject: Minute Taker Wages Recommendation Staff is recommending repeal of Resolution 2007-37, which will allow us to set minute taker contractor rates as a staff function, within budgeted amounts. STATE OF ILLINOIS ss COUNTY OF KENDALL ) RESOLUTION NO. 2007 - 3 RESOLUTION APPROVING A POLICY FOR MINUTE TAKER'S HOURLY WAGES WHEREAS, the City Council of the United City of Yorkville has considered and discussed I establishing a policy concerning minute taker's hourly wages, and WHEREAS, the City Council has determined that it desires to establish such a policy, and WHEREAS, the text of the policy the City Council now desires to establish concerning minute taker's hourly wages is set forth on the attached Exhibit "A" which is incorporated herein, and NOW THEREFORE, upon Motion duly made, seconded and approved by the majority of those members of the City Council voting, the Minute Taker's Hourly Wage Policy is hereby approved by the City Council of the United City of Yorkville in the form set forth on Exhibit A" attached hereto and incorporated herein. ROBYN SUTCLIFF_JOSEPH BESCO ARDEN JOE PLOCHER L WALTER WERDERICH GARY GOLINSKI MARTY MUNNS ROSE SPEARS JASON LESLIE I Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this Day of 0 A.D. 2007. MAYOR Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this \ a Day of A.D. 2007. ATTEST: CITY CLERK I I EXHIBIT "A" MINUTE TAKER'S HOURLY WAGE POLICY Rate Structure (minutes completed and turned into the Citv Clerk after one week) 35.00 base rate for meetings 17.50 per hour after two hours 12.50 per hour for transcription (transcriptions hours are paid out at 2x hours of meeting) Rate Structure (minutes completed and turned into the Citv Clerk before one week] 35.00 base rate for meetings 17.50 per hour after two hours 14.00 per hour for transcription (transcriptions hours are paid out at 2x hours of meeting) I I I I I