Library Board Packet 2023 03-13-23Agenda
Yorkville Public Library
Board of Trustees Meeting
March 13, 2023, at 7:00 P.M.
Michelle Pfister Meeting Room
902 Game Farm Road
1. Roll Call
2. Recognition of Visitors
3. Amendments to the Agenda
4. Presentations
5. Approval of Minutes
6. Correspondence
7. Public Comment
8. Friends of the Library Report
9. Staff Comment
10. Report of the Treasurer: Financial Statement
Payment of Bills
11. Report of the Library Director
12. City Council Liaison
13. Standing Committees: Policy Personnel
Physical Facilities Finance - FY24 Draft Budget Report
Community Relations
14. Unfinished Business: HVAC update
15. New Business:
FY24 Budget Discussion
Set Physical Facilities Committee Meeting Date
Review Executive Session Minutes
16. Executive Session: (if needed)
1. For the discussion of minutes of meeting lawfully closed under the Open Meetings Act,
whether for purposes of approval by the body of the minutes or semi-annual review of the minutes as
mandated by Section 2.06.
17. New Business (continued) Release of Executive Session Minutes
18. Adjournment
1
This page intentionally left blank.
2
Yorkville Public Library
Board of Trustees
Monday, February 13, 2023 7:00pm
902 Game Farm Road – Michelle Pfister Meeting Room
The Board of Trustees meeting was called to order at 7:00pm by President Darren Crawford, roll was called and
a quorum was established.
Roll Call:
Theron Garcia-yes, Bret Reifsteck-yes, Tara Schumacher-yes, Sue Shimp-yes, Keri Pesola-yes,
Jackie Milschewski-yes, Darren Crawford-yes, Ryan Forristall-yes
Absent: Rosie Millen
Staff Present:
Library Director Shelley Augustine
Others Present:
Friends of the Library Co-President Susan Neustrom and Mr. Shawn Ajazi from Progressive Business Solutions
Recognition of Visitors:
President Crawford welcomed staff and guests.
Amendments to the Agenda: None
Presentation:
Shawn Ajazi – Progressive Business Solutions
Mr. Ajazi is Vice-President of Progressive Business Solutions and his company built the Kendall County solar
project and others. In 2021 his company began discussions with the city regarding sites for a solar project.
Progressive has identified 11 sites including the library building. The metal library roof was looked at and 432
panels were estimated to fit on the roof. The panels clamp to the roof seams rather than attach to the roof and a
more detailed look at the roof would be needed. An RFP was done and 6 companies responded and did a walk-
through of the sites. Progressive would look at one aggregate price and there would be no capital investment by
the city. He said Illinois has the most incentives of all states and would pay for 60-70% of the total solar
installations. He explained how the city could keep costs down through a franchise, increase the solar energy
and return dollars to taxpayers. A power purchase agreement was looked at along with a 25-year agreement
where a third party would own, operate and maintain the system and the city would lease out the site. Based on
the current city/ComEd agreement and the power purchase agreement, the city would save $16,000 a year if they
switched to the purchase agreement. He said for most of the municipal projects they have done, the municipality
takes advantage of the power purchase agreement. ComEd installs smart inverters that track the power from the
grid to be able to track usage.
Discussion:
The following questions were asked by Board members and Mr. Ajazi's answers follow:
1. Would the library remain on the city agreement? Yes, it's a franchise for the city, but there has only
been a preliminary conversation with the City Administrator.
2. What is Progressive's role in this? We are a solar developer and an energy commodity broker. We are
licensed and work as the city's energy broker for their commodity buy. We serve as a liaison and have
3
2,000 customers in many states.
3. Does it ultimately fall on the city to make the decision? Yes.
4. Regarding number of panels on the roof, can this roof support the weight--if there is buckling, the
library has a collection that could potentially be water-damaged? Typically there is a weight of 4
pounds per square inch per panel. During the design and engineering phase, a full detailed engineering
inspection is done and if the roof cannot support the solar, the project does not go forward.
5. Does the Board have a say in this? Yes
6. Is there enough sun? Yes, a shade analysis was done and the experts also looked at the pine needles.
7. Mr. Ajazi: The panels last 35 years and can be removed under the decommissioning plan at no cost to
the city
8. What if lightning damages some of the panels? They are under warranty and a third party replaces.
9. Do the panels support the library's electric consumption? Yes, you are offsetting the grid power that
you purchase and you produce more power during the day when the ComEd price is higher.
10. What if the panels produce more than the library consumes? A credit will be on the bill or you get a
zero bill for the electricity portion.
11. The library currently does not pay for electricity and if franchise fee is lower, will residents
benefit? All residents and businesses would pay the franchise fee and the bill is lower by purchasing the
3rd party supplier electricity rather than from ComEd.
12. Is there a penalty if the library opted out of the program? No.
13. What are the next steps? We are in conversation with the city and a rep has been at a City Council
meeting. We did the Plano Sanitary District and Kendall County and have 22 projects at this time.
14. How do you determine panels last 35 years? There is case study and the typical lifespan is 25 years.
15. Does there have to be a fence around the project? The Kendall County project fence was part of an
agreement with the city and the sheriff. If the panels are on the roof, no fence is needed.
16. Mr. Ajazi: Progressive will possibly re-bid the sites as stand-alones since it is not known if all city
departments will participate. We would look at bundle vs. stand-alone.
17. Is there heat underneath the panels and will it feel warmer on the 2nd floor? The panels absorb the
heat.
President Crawford said the library will speak with the city to see how to proceed.
Approval of Minutes: Finance Committee January 4, 2023 and Board of Trustees January 9, 2023
President Crawford moved to approve both sets of minutes which was seconded by Trustee Milschewski. A
correction was noted by Ms. Augustine in the January 4 Finance Committee meeting. On page 2, under
Backflow Testing, the $87,000 should be on a second line under Professional Services. On a new motion and
second by Mr. Crawford and Ms. Milschewski, respectively, the January 4th minutes were approved with the
correction. In a second motion, Mr. Crawford and Ms. Milschewski moved and seconded, respectively, to
approve the January 9th Board of Trustee minutes. Roll call for both motions : Reifsteck-yes, Schumacher-yes,
Shimp-yes, Pesola-yes, Milschewski-yes, Crawford-yes, Forristall-yes, Garcia-yes. Carried 8-0.
Correspondence:
Director Augustine read a letter from Dixie DeBord announcing her retirement on May 5, 2023 after 23 years at
the library. A small party will be held on that day.
Public Comment: None
Friends of the Library Report:
Ms. Neustrom said the mini-golf was a huge success and over $10,000 profit was made, half of which was raised
by Katelyn Gregory. She said there were many positive comments. She detailed the money being appropriated
for specific programs during the Friends meeting today. They will also supply the refreshments for Ms.
DeBord's party. She said that Mike Curtis created a wish list and costs for programs he would like to present.
The Friends will be applying to become a 501(c)(3) allowing them to apply for grants. She provided additional
4
facts regarding the costs and she said it takes about 3-6 months for approval of the application. President
Crawford commented that there is a large amount of money earmarked for libraries.
Staff Comment: None
Report of the Treasurer:
Financial Statement
Treasurer Milschewski highlighted some of the bills for the month including the $14,081 Trico bill for 72 hours
of work including parts. Ms. Milschewski has asked the Director to provide a detailed report /total of the Trico
invoices for 2022.
Payment of Bills
Treasurer Milschewski entertained a motion to pay the bills as follows and President Crawford seconded.
$41,501.93 Accounts Payable
$35,789.79 Payroll
$77,291.72 Total
Roll call: Reifsteck-yes, Schumacher-yes, Shimp-yes, Pesola-yes, Milschewski-yes, Crawford-yes, Forristall-
yes, Garcia-yes. Carried 8-0.
Report of the Library Director:
Director Augustine reported the following:
1. Over 800 people attended the mini-golf and 500 people paid to play golf.
2. Mike Curtis is putting together a volunteer information meeting on February 22nd for an English
Language Learners class. He is also doing a climate change meeting on February 15th.
3. Ms. Weiss is holding a SAT/ACT success Webinar class.
4. A poetry in art program is being done by Ms. Iwanski-Goist on February 25th.
5. A “military healthcare 101” for veterans is being held by Mr. Curtis to help them sign up for Medicare.
6. A paranormal group reached out to Mr. Curtis and on March 29th they will talk about their research.
7. April 11th will host a “Belly of the Beast” Martin Luther King program.
8. Received quote of $1,200 to repair roof drain leak.
9. HVAC had some glitches causing the air handler to shut off fans when it went into night mode and Mr.
Raasch re-set the computer.
10. Staff will take CPR training as a result of a recent medical emergency at library.
11. Resignation letters were received from Ms. DeBord and a part-time staffer, both jobs are posted.
12. Received a reminder from Kendall County Clerk that Board members must file Statement of Economic
Interest, deadline of May 1. There is a financial charge if that date is missed.
13. Ms. Augustine attended library road trip meeting. Yorkville has partnered with 18 other libraries and the
event opens in March through end of May. Friends will sponsor grand prize and giveaways.
President Crawford noted the great increase in visits to the library and that the programs have doubled from last
year. Ms. Augustine said Mr. Curtis has added many programs with 61 this year and 31 last year for the same
time period.
City Council Liaison: None
Standing Committees: None
Unfinished Business:
HVAC Update
Ms. Augustine noted the $14,000 HVAC bill with details of the services provided. She said the system seems to
be working well at this time.
New Business:
City of Yorkville Solar Plan – Library Site
The Board reviewed the presentation from earlier in the meeting. Comments and concerns included: the project
5
was possibly put on hold with the city, concern for possible loss of franchise, not sold on the project, the roof's
age may preclude the project, a flat roof has a lower lifespan than metal, must sign agreement before engineering
study, locked into agreement for 25 years, timeline is aggressive, would be beneficial to have someone from the
city meet with the Board, might need new roof, if not enough roof is covered it won't be beneficial, savings
might not be adequate, most projects are ground-mounted and concern for 25 year guarantee. The next step will
be to have a discussion with the city.
Reminder to File SEI Form with County
Ms. Augustine reminded Board members that these forms are due May 1st. She can provide a link for
information and the County Clerk website has information. There is also a facts sheet which is included in the
agenda packet.
Set Finance Committee Meeting Date for FY24 Budget Planning
Ms. Augustine has received a revised budget from the city and a meeting date of February 27th at 6pm was set for
the Finance Committee.
Review of Executive Session Minutes
Tabled until March.
Executive Session: None
Additional Business: None
Adjournment:
There was no further business and the meeting adjourned at 8:13pm
Minutes respectfully submitted by
Marlys Young, Minute Taker
6
Yorkville Public Library
Board Room
Library Finance Committee Meeting
Monday, February 27, 2023- 6:00pm
902 Game Farm Road
The meeting was called to order at 6:04pm by Chairwoman Jackie Milschewski.
Roll Call: Jackie Milschewski-yes, Rosie Millen-yes, Bret Reifsteck-yes
Absent: Darren Crawford
Others Present:
Library Director Shelley Augustine, City Finance Director Rob Fredrickson, Library Board Trustee
Ryan Forristall
Recognition of Visitors: The Chairwoman recognized staff and guests.
Public Comment: None
New Business:
Budget Planning for FY24
Overview:
The purpose of the meeting was to continue the budget process for FY24. The Committee was
presented with the revised budget and 5-year projections as prepared by Finance Director Fredrickson.
Briefly summarizing the report Mr. Fredrickson said it shows the combined Funds 82 (Operations) and
84 (Capital Fund). He projected a $75,000 surplus for this year and Fund Balance of almost $1 million
and next year he predicted a decline of $100,000 with a Fund Balance of $900,000. He said the library
should have adequate cash flow. Looking ahead to 2028, there should be over $500,000 in the two
Funds even with a chiller replacement etc. He feels the library is financially sound.
Library Operations Fund 82
Mr. Fredrickson then went into more detail of the proposed budget. He said Fund 82 looks healthy
through 2028. He predicts a $12,000 surplus for 2023, a $24,000 deficit in 2024 and that this fund
looks healthy through 2028. Chairman Milschewski asked what would cause the deficit for next year.
Outside Repair and Maintenance was increased to $125,000 based on possible equipment replacement.
Revenues:
On page 2 of the budget, property taxes are the largest revenue source at about $900,000. Property
taxes for debt service are based on debt service amounts and will begin to fall away in 2026 when the
bonds are finished. Other revenue sources include personal property tax which have doubled to about
$17,000 and also the state grant in the amount of $31,500. Mr. Fredrickson said miscellaneous income
tax is higher than normal due to insurance proceeds received last week and the proceeds are basically a
wash with the expenses.
Expenditures:
Expenditures include Ms. DeBord's final payout, part-time salaries, and health insurance. New
insurance rates are estimated to increase by 8% for health, 5% for dental and life/vision is staying the
same. One new employee is opting out of the insurance. Katelyn Gregory's administrative chargeback
7
of $15,000 is included also.
Mr. Fredrickson detailed some of the other expenses such as training and conferences, chargeback for
building and grounds person Ted Milschewski, Professional Services increasing by about $6,000 to
allow for engineering costs for new HVAC system and office cleaning (a new line item). Outside
Repair and Maintenance is tracking at $130,000, but a large amount will be offset by insurance
reimbursement for the flooding. Ms. Augustine noted $52,000 was for remediation and Mr. Fredrickson
said the Outside Repair will continue to be high. Paying Agent Fees will drop when the bonds are
finished and DVD's, audio books, etc. were moved to Library Operations in 2024. Usually $50,000
was budgeted for books and in 2024, $20,000 was budgeted as this item is phased into Operations. The
bond payments are finished after FY 2025.
Library Capital Fund 84:
Revenues
Mr. Fredrickson said development fees are healthy if building is going strong. In the past, $50,000 was
budgeted and it more than doubled this year.
Expenditures
E-books were budgeted at $3,500, computer equipment and software at $25,000 through FY 2028 and
books, DVD's etc will decrease as this moves to the Operations Fund 82. For Building Improvements,
a lighting upgrade to LED was budgeted at $56,000, for FY2025 he budgeted $250,000 for a new
HVAC system, FY 2027 VAV replacement (variable air valve replacement) budgeted at $200,000. Mr.
Fredrickson encouraged the library to continue to be aware of large expense items for planning
purposes. Overall he thinks there should be about a $60,000 surplus with a $240,000 Fund Balance.
He also predicted some declines in the Fund Balance in the '25 and '27 budget years, but no fiscal
concerns in '24 and '25.
Questions/Comments:
Ms. Augustine mentioned some items not budgeted, but suggested by Mr. Raasch. They include
elevator, plumbing and roof repairs and additional funding for Outside Repair. Currently, $45,000 is
budgeted for HVAC repairs. Mr. Raasch suggested a lighting control maintenance contract at $6,100
and maintenance contract for VAV cleaning at about $3,400. Mr. Forristall said the VAV contract
would be beneficial to buy some time if any problems were detected.
Mr. Reifsteck asked about camera replacement. The library has 12-13 new cameras out of a total of 30.
Ms. Augustine said 5 cameras could be replaced at about $1,000 per camera.
Mr. Forristall said he has looked at the library building and he referred to a building evaluation report
done in 2017. Not much has been spent and he said overall the building is in good condition. He said
Mr. Raasch's suggestions were very accurate. He said the report also showed carpet replacement which
would be very costly. Trustee Forristall said he has concerns with the exterior mortar and other items.
He also said window sealants should be looked at since they fail after about 20 years and he said a mill
and resurface of the parking lot should be considered. He said a Facilities meeting could be scheduled
for March.
Ms. Milschewski asked if there is a monthly maintenance schedule of routine repairs saying it could
help with budgeting. Ms. Augustine and Ms. DeBord have a building checklist, said Mr. Forristall.
Mr. Fred rickson said the library could expect that the city will continue to help with maintenance issues
8
Director Augustine would like Mr. Raasch to meet with staff to develop a brief capital needs
assessment plan before he leaves in April.
Summary: Mr. Fr edrickson said revisions can be made in March and more firm numbers for health
information will be received also. The Library Board can pass the budget at the April meeting and all
must be completed by the end of April.
Executive Session: None
Adjournment:
There was no further business and the meeting adjourned at 6:38pm
Minutes respectfully submitted by Marlys Young, Minute Taker
9
This page intentionally left blank.
10
DATE: 02/22/23 UNITED CITY OF YORKVILLE TIME: 14:16:55 MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEM CHECKINVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------900129 FNBO FIRST NATIONAL BANK OMAHA 02/25/23022523-B.VALLES 01/25/23 04 NAPA#331371-WIPERS 01-410-56-00-5628 46.9805 MENARDS#010423-KEY ORGANIZER 01-410-56-00-5620 24.4106 MENARDS#010323-DRILL BITS 01-410-56-00-5630 48.8507 ACE#011023-ROPE 01-410-56-00-5620 4.7208 MENARDS#122822-QUICK LINKS 01-410-56-00-5620 29.5209 MENARDS#123022-BOLTS, GLUE 01-410-56-00-5620 11.4410 MENARDS#012423-WINDSHIELD 01-410-56-00-5628 201.8011 FLUID ** COMMENT **12 MENARDS#122922-COILS 01-410-56-00-5620 27.9913 SOUND DECISION-ANTENNA ADAPTER 01-410-56-00-5628 30.32INVOICE TOTAL: 570.98 *022523-B.WOLF 01/31/23 01 DEKANE#IA87870-BEARINGS 79-790-56-00-5640 223.91INVOICE TOTAL: 223.91 *022523-D.BROWN 01/31/23 01 MENARDS#011923-SHELF, TOTES, 51-510-56-00-5638 79.9602 PINESOL ** COMMENT **03 AMAZON-GARMENT RACK 51-510-56-00-5638 115.9504 MENARDS#011323-HANGERS, BUCKET 51-510-56-00-5638 10.9205 MENARDS#011923-SCREEN, PLIERS, 51-510-56-00-5620 18.9606 CABLE TIES ** COMMENT **07 GRAINGER#9583137782-DANGER 51-510-56-00-5638 20.6408 SIGN ** COMMENT **INVOICE TOTAL: 246.43 *022523-D.DEBORD 01/31/23 01 AMAZON-POWER STRIP 82-820-56-00-5610 7.5902 AMAZON-VGA ADAPTER 82-820-56-00-5610 7.9803 AMAZON PRIME MONTHLY FEE 82-820-54-00-5460 14.99INVOICE TOTAL: 30.56 *022523-D.HENNE 01/31/23 01 NAPA#331194-CONNECTOR 01-410-56-00-5628 9.3602 NAPA#332162-CONNECTOR 01-410-56-00-5628 10.5203 NAPA#331472-BULBS, FILTERS 01-410-56-00-5628 105.7604 NAPA#331475-BULBS 01-410-56-00-5628 1.2205 REILLY#5613-257720-CONNECTORS 01-410-56-00-5628 10.9906 MENARDS#011223-POST SCREWS 01-410-56-00-5620 1.6107 AUTO ZONE-TRAILER CONNECTOR 01-410-56-00-5628 10.9908 HOME DEPO#011923-PROPANE 01-410-56-00-5620 11.9409 HOME DEPO#010623-EXTENSION 01-410-56-00-5620 47.9010 CORDS ** COMMENT **INVOICE TOTAL: 210.29 *022523-D.SMITH 01/31/23 01 MENARDS#011123-MAGIC ERASER, 79-790-56-00-5640 293.5102 SPRAY PAINT, OIL, CHIP BRUSHES ** COMMENT **03 FLATSOS#26433-3 TIRES 79-790-54-00-5495 277.7111
DATE: 02/22/23 UNITED CITY OF YORKVILLE TIME: 14:16:55 MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEM CHECKINVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------900129 FNBO FIRST NATIONAL BANK OMAHA 02/25/23022523-D.SMITH 01/31/23 04 MENARDS#011723-TRAILER 79-790-56-00-5620 100.0905 LIGHTS, TIRE FOAM, DEGREASER, ** COMMENT **06 BUTT SLPICE, WIRE BOND ** COMMENT **07 NAPA#331873-FUSE HOLDER 79-790-56-00-5640 4.7408 MENARDS#011923-BUTT SPLICE, 79-790-56-00-5640 41.4609 SPRAY PAINT, ELECTRICAL ** COMMENT **10 SOLDER, TAPE, FLAT EXTENSION ** COMMENT **11 MENARDS#012023-STUDS 79-790-56-00-5620 40.20INVOICE TOTAL: 757.71 *022523-E.DHUSE 01/30/23 01 APWA-2021 PUBLIC WORKS 51-510-54-00-5462 299.0002 COMPENSATION REPORT AND SALARY ** COMMENT **03 CALCULATOR ** COMMENT **INVOICE TOTAL: 299.00 *022523-E.HERNANDEZ 01/31/23 01 FLATSOS#26484-NEW TIRE 79-790-54-00-5495 115.6702 NAPA#331905-SLIDE TERMINAL 79-790-56-00-5640 2.84INVOICE TOTAL: 118.51 *022523-E.SCHREIBER 01/31/23 01 TARGET-PRESCHOOL SUPLIES 79-795-56-00-5606 9.0002 DOLLAR TREE-CRAFT SUPPLIES 79-795-56-00-5606 47.5003 AMAZON-PAPER BAGS, GLUE 79-795-56-00-5606 82.5904 STICKS, MARKERS, BOUNCING ** COMMENT **05 BALLS ** COMMENT **06 TARGET-PRESCHOOL SUPPLIES 79-795-56-00-5606 35.9507 AMAZON-PHONE CHARGER, NIGHT 79-795-56-00-5606 30.9808 LIGHTS ** COMMENT **09 AMAZON-CONSTRUCTION PAPER, 79-795-56-00-5606 130.3610 GAMES, FISHING NETS ** COMMENT **11 PARTY CITY-FILLED BALLONS 79-795-56-00-5606 175.6012 AMAZON-MASKING TAPE, SWIFFER 79-795-56-00-5606 37.6413 AMAZON-WASHABLE PAINT, 79-795-56-00-5606 54.7414 PLASTIC INSECTS ** COMMENT **INVOICE TOTAL: 604.36 *022523-E.WILLRETT 01/31/23 01 APWA-METRO CHAPTER MEETING 01-110-54-00-5426 25.0002 REGISTRATION ** COMMENT **03 YORKVILLE CHAMBER-ANNUAL DUES 01-110-54-00-5460 5,000.0004 RENEWAL ** COMMENT **05 ELEMENT FOUR-JAN 2023 CLOUD 01-640-54-00-5450 639.4806 CONNECT OFFSITE BACKUPS ** COMMENT **07 PHYSICIANS CARE-DRUG TESTING 82-820-54-00-5462 47.00INVOICE TOTAL: 5,711.48 *022523-G.JOHNSON 01/31/23 01 MENARDS#122922-PLIERS 51-510-56-00-5630 17.9912
DATE: 02/22/23 UNITED CITY OF YORKVILLE TIME: 14:16:55 MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEM CHECKINVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------900129 FNBO FIRST NATIONAL BANK OMAHA 02/25/23022523-J.BEHLAND 01/31/23 02 SHAW MEDIA-FY22 TREASURERS 01-110-54-00-5426 950.0003 REPORT ** COMMENT **INVOICE TOTAL: 1,046.70 *022523-J.DYON 01/31/23 01 WAREHOUSE-CALENDARS 01-120-56-00-5610 17.1302 WAREHOUSE-CALENDARS 51-510-56-00-5620 25.8403 WAREHOUSE-CALENDARS 52-520-56-00-5610 7.4604 WAREHOUSE-FILES, RUBBER FINGER 51-510-56-00-5620 24.4405 WAREHOUSE-FILES, WRITING PADS 51-510-56-00-5620 78.64INVOICE TOTAL: 153.51 *022523-J.ENGBERG 01/31/23 01 ADOBE-CREATIVE CLOUD MONTHLY 01-220-54-00-5462 54.9902 FEE ** COMMENT **INVOICE TOTAL: 54.99 *022523-J.JENSEN 01/31/23 01 ILACP-SAFE-T TRAINING REFUND 01-210-54-00-5412 -20.0002 IACP-ANNUAL DUE RENEWAL 01-210-54-00-5460 190.0003 LOGO FACTORY-NIKE COVERUP 01-210-56-00-5600 67.0004 LOGO FACTORY-3 STAFF JACKETS 01-210-56-00-5600 171.9005 FBINAA-ANNUAL DUE RENEWAL 01-210-54-00-5460 125.00INVOICE TOTAL: 533.90 *022523-J.SLEEZER 01/31/23 01 AMAZON-ROTATING VISE SYSTEM 01-410-56-00-5630 63.5202 AMAZON-ROTATING VISE SYSTEM 51-510-56-00-5630 63.5203 AMAZON-ROTATING VISE SYSTEM 52-520-56-00-5630 63.51INVOICE TOTAL: 190.55 *022523-K.BALOG 01/31/23 01 AMAZON-DESK CALENDARS 01-210-56-00-5620 46.3402 COMCAST-12/15-1/14 INTERNET 01-640-54-00-5449 1,164.4303 SHREDIT-DEC 2022 SHREDDING 01-210-54-00-5462 245.8004 NIBRS-FULL CIRCLE TRAINING 01-210-54-00-5412 429.0005 REGISTRATION-CYKO ** COMMENT **06 COMCAST-1/8-2/7 CABLE 01-210-54-00-5440 21.0807 FLORAL EXPRESSIONS-SYMPATHY 01-210-56-00-5650 97.9408 ARRANGEMENT TO COLLUMN FAMILY ** COMMENT **09 ACCURINT-NOV 2022 SEARCHES 01-210-54-00-5462 150.00INVOICE TOTAL: 2,154.59 *022523-K.BARKSDALE 01/31/23 01 APA-2023 NATIONAL PLANNING 01-220-54-00-5412 785.0002 CONFERENCE REGISTRATION ** COMMENT **INVOICE TOTAL: 785.00 *022523-K.GREGORY 01/31/23 01 COLLINS AWARDS-2023 MINI GOLF 82-820-56-00-5671 17.5502 TROPHY ** COMMENT **INVOICE TOTAL: 17.55 *13
DATE: 02/22/23UNITED CITY OF YORKVILLETIME: 14:16:55MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------900129 FNBO FIRST NATIONAL BANK OMAHA 02/25/23022523-K.JONES01/31/23 01 AMAZON-COPY PAPER01-110-56-00-5610135.3602 AMAZON-COPY PAPER52-520-56-00-5620159.9603 AMAZON-1099-R FORMS01-120-56-00-561041.5004 AMAZON-COPY PAPER01-110-56-00-5610119.97INVOICE TOTAL:456.79 *022523-M.CARYLE 01/31/23 01 IACP-DUES RENEWAL01-210-54-00-5460190.0002 GJOVIK#423821-OIL CHANGE01-210-54-00-549539.9003 GJOVIK#423823-OIL CHANGE01-210-54-00-549538.0004 GJOVIK#423864-OIL CHANGE01-210-54-00-549539.9005 GJOVIK#423740-OIL CHANGE, TIRE 01-210-54-00-5495201.5606 REPAIR** COMMENT **07 GJOVIK#424273-OVERHEATING01-210-54-00-5495176.3508 REPAIR** COMMENT **09 GJOVIK#424270-OIL CHANGE01-210-54-00-5495110.0910 GJOVIK#424315-OIL CHANGE01-210-54-00-549560.9011 GJOVIK#423957-POWER STEERING 01-210-54-00-54952,086.6612 REPAIR** COMMENT **13 50 PADS OF TRAFFIC STOP01-210-54-00-543059.9014 RECEIPTS** COMMENT **INVOICE TOTAL:3,003.26 *022523-M.CISIJA 01/31/23 01 YORK POST1 PKG TO COMED01-110-54-00-545247.4002 AMAZON-PENS LABELS, MARKERS, 01-110-56-00-561067.6703 BINDER CLIPS** COMMENT **04 AMAZON-CREDIT FOR BINDER01-110-56-00-5610-16.4005 CLIPS** COMMENT **INVOICE TOTAL:98.67 *022523-M.CURTIS 01/31/23 01 TARGET-HORMEL TRAY82-000-24-00-248015.4902 CRAFT'D-3 GIFT CARDS82-000-24-00-248040.0003 JEWEL-REFRESHMENTS,COOKIES82-000-24-00-248025.56INVOICE TOTAL:81.05 *022523-M.DONOVAN 01/31/23 01 HYATT-LODGING FOR SOARING TO 79-795-54-00-5415152.6102 NEW HEIGHTS CONFERENCE-DONOVAN ** COMMENT **INVOICE TOTAL:152.61 *022523-M.MCGREGORY 01/31/23 01 MENARDS#011823-CONTRACTOR BAGS 51-510-56-00-562035.79INVOICE TOTAL:35.79 *022523-M.SENG01/31/23 01 FLATSOS#26498-2 NEW TIRES01-410-54-00-54901,800.0002 MENARDS#011123-HOSE BARB01-410-56-00-562022.08INVOICE TOTAL:1,822.08 *022523-P.MCMAHON 01/31/23 01 STREICHERS-BALLAISTIC VEST01-210-56-00-5600651.9914
DATE: 02/22/23UNITED CITY OF YORKVILLETIME: 14:16:55MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------900129 FNBO FIRST NATIONAL BANK OMAHA 02/25/23022523-R.WOOLSEY 01/31/23 50 HEATER, MOUNT KIT** COMMENT **51 AMPERAGE#1364424-IN-LAMPS23-230-56-00-564286.1052 ARNESON#218649-DEC 2022 GAS01-410-56-00-5695187.8653 ARNESON#218649-DEC 2022 GAS51-510-56-00-5695187.8754 ARNESON#218649-DEC 2022 GAS 52-520-56-00-5695187.8755 ARNESON#219901-DEC 2022 DIESEL 01-410-56-00-5695252.4656 ARNESON#219901-DEC 2022 DIESEL 51-510-56-00-5695252.4757 ARNESON#219901-DEC 2022 DIESEL 52-520-56-00-5695252.4658 ARNESON#218648-DEC 2022 DIESEL 01-410-56-00-5695662.3959 ARNESON#218648-DEC 2022 DIESEL 51-510-56-00-5695662.3960 ARNESON#218648-DEC 2022 DIESEL 52-520-56-00-5695662.3861 GJOVIK#83906-SPORD LAMP01-410-56-00-5628263.9462 GJOVIK#83913-PAINT01-410-56-00-562814.3663 LINDCO#221237P-BOSS JOYSTICK 01-410-56-00-56281,321.6464 CONTROLLER AND MOUNTING KIT** COMMENT **65 LINDCO#221606P-FLUSH KIT LID 01-410-56-00-562861.3066 LAWSON-COUPLER01-410-56-00-5620153.1467 FOX RIDGE STONE-GRAVEL51-510-56-00-564065.0068 AMPERAGE#1348488-IN-FREIGHT 23-230-56-00-564217.2469 CHARGE ASSOCIATED WITH** COMMENT **70 INV#1347446-IN** COMMENT **INVOICE TOTAL:13,456.35 *022523-S.AUGUSTINE 01/31/23 01 AMAZON-MONITOR STANDS82-820-56-00-561045.7402 SMITHEREEN-DEC 2022 PEST82-820-54-00-546287.0003 CONTROL** COMMENT **04 REMOTE PC-ANNUAL HOST RENEWAL 82-820-54-00-546210.0005 ILA-INSTITUTIONAL MEMBERSHIP 82-820-54-00-5460150.0006 RENEWAL** COMMENT **07 AMAZON-CHALK MARKERS, GLUE82-820-56-00-561061.2908 STICKS, REPORT COVERS, PAPER** COMMENT **09 CLIPS, STAPLERS, STICKERS** COMMENT **10 AMAZON-BOOK,COLOR SORTING SET 82-820-56-00-567137.0811 AMAZON-CARDSTOCK, PUTTY TACK, 82-820-56-00-561035.7612 CHALKBOARD MARKERS** COMMENT **13 QUILL-MARKERS, POPUP NOTES, 82-820-56-00-5621132.4314 WINDEX, CLEANERS, PAPER TOWELS ** COMMENT **15 QUILL-GARBAGE BAGS82-820-56-00-5621107.7016 VISTA PRINT-BUSINESS CARDS82-820-56-00-561029.79INVOICE TOTAL:696.79 *022523-S.IWANSKI 01/31/23 01 YORK POST-POSTAGE82-820-54-00-5452393.33INVOICE TOTAL:393.33 *022523-S.RAASCH 01/31/23 01 AMAZON-FILTERS24-216-54-00-544674.73Total for all Highlighted Library Invoices: $1,266.2815
82-820LIBRARYOPERATIONS84-840LIBRARYCAPITALDATE: 03/07/23UNITED CITY OF YORKVILLETIME: 08:22:41CHECK REGISTERPRG ID: AP215000.WOWCHECK DATE: 03/13/23CHECK # VENDOR # INVOICE INVOICE ITEMNUMBER DATE # DESCRIPTIONACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------105280 BAKTAY BAKER & TAYLOR203728754201/31/23 01 BOOKS84-840-56-00-56861,092.80INVOICE TOTAL:1,092.80 *203730049002/03/23 01 BOOKS84-840-56-00-5686679.46INVOICE TOTAL:679.46 *203731542102/14/23 01 BOOKS84-840-56-00-56861,358.12INVOICE TOTAL:1,358.12 *CHECK TOTAL:3,130.38105281 DELAGE DLL FINANCIAL SERVICES INC7906031102/15/23 01 APR 2023 COPIER LEASE82-820-54-00-5462185.00INVOICE TOTAL:185.00 *CHECK TOTAL:185.00105282 EBSCO EBSCO INDUSTRIES, INC.1000202249-103/01/23 01 LIBRARY AWARE SUBSCRIPTION 82-820-54-00-54601,337.00INVOICE TOTAL:1,337.00 *CHECK TOTAL:1,337.00105283 IMPERIAL IMPERIAL SERVICE SYSTEMS, INC15965802/08/23 01 FEB 2023 CLEANING SERVICES 82-820-54-00-54625,177.00INVOICE TOTAL:5,177.00 *CHECK TOTAL:5,177.00105284 LLWCONSU LLOYD WARBER1054402/10/23 01 JAN 2023 ON-SITE IT SUPPORT 82-820-54-00-5462720.00INVOICE TOTAL:720.00 *16
82-820LIBRARYOPERATIONS84-840LIBRARYCAPITALDATE: 03/07/23UNITED CITY OF YORKVILLETIME: 08:22:41CHECK REGISTERPRG ID: AP215000.WOWCHECK DATE: 03/13/23CHECK # VENDOR # INVOICE INVOICE ITEMNUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------105284 LLWCONSU LLOYD WARBER1054602/24/23 01 FEB 2023 ON-SITE IT SUPPORT 82-820-54-00-5462720.00INVOICE TOTAL:720.00 *CHECK TOTAL:1,440.00105285 METRONET METRO FIBERNET LLC1651373-03012303/01/23 01 MAR 2023 INTERNET82-820-54-00-5440124.97INVOICE TOTAL:124.97 *CHECK TOTAL:124.97105286 MIDWTAPE MIDWEST TAPE50332428002/03/23 01 AUDIO BOOKS84-840-56-00-568392.9802 DVDS84-840-56-00-568548.73INVOICE TOTAL:141.71 *50338240702/16/23 01 AUDIO BOOK84-840-56-00-568339.9902 DVDS84-840-56-00-568570.47INVOICE TOTAL:110.46 *50342031902/24/23 01 AUDIO BOOK84-840-56-00-568338.99INVOICE TOTAL:38.99 *CHECK TOTAL:291.16105287 NICOR NICOR GAS91-85-68-4012 8-0123 02/02/23 01 01/03-02/01 902 GAME FARM RD 82-820-54-00-54802,527.95INVOICE TOTAL:2,527.95 *CHECK TOTAL:2,527.95105288 TCGTCG SOLUTIONS, INC17
82-820LIBRARYOPERATIONS84-840LIBRARYCAPITALDATE: 03/07/23UNITED CITY OF YORKVILLETIME: 08:22:41CHECK REGISTERPRG ID: AP215000.WOWCHECK DATE: 03/13/23CHECK # VENDOR # INVOICE INVOICE ITEMNUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------105288 TCGTCG SOLUTIONS, INC22-105101/01/23 01 MONTHLY HOSTED VOIP82-820-54-00-5440445.00INVOICE TOTAL:445.00 *CHECK TOTAL:445.00105289 TODAYS TODAY'S BUSINESS SOLUTIONS INC022123-3502/23/23 01 JUL-SEPT 2022 FAXES82-820-54-00-546236.00INVOICE TOTAL:36.00 *CHECK TOTAL:36.00105290 TRICO TRICO MECHANICAL , INC725802/10/23 01 REPLACED ACCUATOR MOTOR82-820-54-00-54951,503.00INVOICE TOTAL:1,503.00 *CHECK TOTAL:1,503.00105291 UMBRELLA UMBRELLA TECHNOLOGIES130703/01/23 01 ACCESS CONTROL CLOUD HOSTING 82-820-54-00-5462480.0002 FOR 11 ENTRIES** COMMENT **INVOICE TOTAL:480.00 *CHECK TOTAL:480.00105292 YOUNGM MARLYS J. YOUNG010423-LIB FINANCE 03/06/23 01 01/04/23 LIB MEETING MINUTES 82-820-54-00-546285.00INVOICE TOTAL:85.00 *010923-LIB01/17/23 01 01/0923 LIB MEETING MINUTES 82-820-54-00-546285.00INVOICE TOTAL:85.00 *18
82-820LIBRARYOPERATIONS84-840LIBRARYCAPITALDATE: 03/07/23UNITED CITY OF YORKVILLETIME: 08:22:41CHECK REGISTERPRG ID: AP215000.WOWCHECK DATE: 03/13/23CHECK # VENDOR # INVOICE INVOICE ITEMNUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------105292 YOUNGM MARLYS J. YOUNG021323-LIB02/28/23 01 02/13/23 LIB MEETING MINUTES 82-820-54-00-546285.00INVOICE TOTAL:85.00 *CHECK TOTAL:255.00TOTAL AMOUNT PAID:16,932.4619
REGULAR OVERTIME TOTAL IMRF FICA TOTALSADMINISTRATION17,438.35 - 17,438.35 1,143.96 1,278.92 19,861.23 FINANCE11,949.80 - 11,949.80 783.90 883.58 13,617.28 POLICE138,952.90 1,688.85 140,641.75 411.40 10,477.79 151,530.94 COMMUNITY DEV.31,254.61 - 31,254.61 2,079.82 2,352.57 35,687.00 STREETS20,536.21 1,491.73 22,027.94 1,451.61 1,635.78 25,115.33 BUILDING & GROUNDS2,328.71 - 2,328.71 162.60 189.60 2,680.91 WATER18,988.90 370.02 19,358.92 1,269.95 1,400.08 22,028.95 SEWER7,420.03 - 7,420.03 486.75 540.66 8,447.44 PARKS27,545.43 181.33 27,726.76 1,800.62 2,068.99 31,596.37 RECREATION23,230.98 - 23,230.98 1,304.06 1,739.84 26,274.88 LIBRARY16,829.02 - 16,829.02 733.80 1,238.00 18,800.82 TOTALS316,474.94$ 3,731.93$ 320,206.87$ 11,628.47$ 23,805.81$ 355,641.15$ TOTAL PAYROLL355,641.15$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYFebruary 3, 202320
REGULAR OVERTIME TOTAL IMRFFICA TOTALSMAYOR & LIQ. COM.908.34$ -$ 908.34$ -$ 69.49$ 977.83$ ALDERMAN3,500.00 - 3,500.00 - 267.75 3,767.75 ADMINISTRATION18,466.13 - 18,466.13 1,211.37 1,357.55 21,035.05 FINANCE12,116.47 - 12,116.47 794.83 896.33 13,807.63 POLICE130,200.95 1,383.65 131,584.60 411.40 9,741.81 141,737.81 COMMUNITY DEV.27,902.21 - 27,902.21 1,830.38 2,061.70 31,794.29 STREETS20,478.15 1,078.93 21,557.08 1,414.17 1,592.96 24,564.21 BUILDING & GROUNDS2,328.71 174.65 2,503.36 164.22 191.51 2,859.09 WATER19,032.17 704.00 19,736.17 1,294.70 1,428.56 22,459.43 SEWER7,453.70 - 7,453.70 488.95 542.62 8,485.27 PARKS27,180.86 27,180.86 1,749.46 2,008.20 30,938.52 RECREATION23,725.47 - 23,725.47 1,328.41 1,766.19 26,820.07 LIBRARY17,031.27 - 17,031.27 733.80 1,253.48 19,018.55 TOTALS310,324.43$ 3,341.23$ 313,665.66$ 11,421.69$ 23,178.15$ 348,265.50$ TOTAL PAYROLL348,265.50$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYFebruary 17, 202321
Library CC Check Register (Pages 1 ‐ 5)02/25/2023 $1,266.28
Library Check Register (Pages 6 ‐ 9)03/13/2023 16,932.46
IPRF ‐ Mar 2023 Work Comp Ins 02/14/2023 1,025.69
Glatfelter ‐ Liability Ins. Installment #1 02/14/2023 1,165.50
First Non‐Profit‐1st Qtr Unemployment Ins 02/14/2023 342.47
Imperial Service Systems‐ Cleaning due to burst water pipe 02/28/2023 1,480.00
Nedrow Decorating ‐ Repairs related to burst water pipe 02/28/2023 6,359.53
Trico‐HVAC repair related to burst water pipe 02/28/2023 13,840.00
Serv Pro‐Cleaning related to burst water pipe 02/28/2023 30,641.33
TOTAL BILLS PAID: $73,053.26
DATE
Bi‐weekly (Page 10)02/03/2023 $18,800.82
Bi‐weekly (Page 11)02/17/2023 19,018.55
TOTAL PAYROLL:$37,819.37
TOTAL DISBURSEMENTS:$110,872.63
PAYROLL
YORKVILLE LIBRARY BOARD
BILL LIST SUMMARY
Monday, March 13, 2023
ACCOUNTS PAYABLE
22
DATE: 03/06/2023 UNITED CITY OF YORKVILLE PAGE: 1TIME: 08:19:52 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2023 ACTIVITY THROUGH FISCAL PERIOD 10PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________ 01 05/01/2022 BEGINNING BALANCE 55,275.84 AP-220525MB 05/24/2022 21 METERNALLY.COM-DVD & FIRST NATIONAL BANK 900118 052522-G,HIX-B 65.45 GJ-220531LB 06/02/2022 05 May 2022 Deposits 93.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 65.45 93.00 02 AP-220613B 06/06/2022 01 BOOKS BAKER & TAYLOR 105168 2036714384 1,083.04 06/06/2022 02 BOOKS BAKER & TAYLOR 105168 2036721767 378.72 06/06/2022 03 BOOKS BAKER & TAYLOR 105168 2036735616 720.23 AP-220625MB 06/15/2022 157 HOME DEPO-PLANTER FLOWERS FIRST NATIONAL BANK 900120 062522-D.DEBORD-B 131.20 06/15/2022 158 AMAZON-FIRE TABLET FIRST NATIONAL BANK 900120 062522-S.AUGUSTINE-B 99.99 06/15/2022 159 AMAZON-BOOKS FIRST NATIONAL BANK 900120 062522-S.AUGUSTINE-B 18.90 06/15/2022 160 AMAZON-BOOK FIRST NATIONAL BANK 900120 062522-S.AUGUSTINE-B 18.95 _________________________________ TOTAL PERIOD 02 ACTIVITY 2,451.03 0.00 03 AP-220725MB 07/19/2022 243 NCG-SUMMER READING CLUB PRIZE FIRST NATIONAL BANK 900122 072522-G.HIX-B 60.00 07/19/2022 244 GRACE-SUMMER READING CLUB FIRST NATIONAL BANK 900122 072522-G.HIX-B 30.97 07/19/2022 245 FOXY'S-SUMMER READING CLUB FIRST NATIONAL BANK 900122 072522-G.HIX-B 20.00 07/19/2022 246 GROUND EFFECTS-PEBBLES FIRST NATIONAL BANK 900122 072522-J.WEISS-B 6.93 GJ-220731LB 08/01/2022 05 July 2022 Deposits 300.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 117.90 300.00 04 AP-220825M 08/22/2022 202 AMAZON-BOOKS FIRST NATIONAL BANK 900123 082522-D.DEBORD 78.63 08/22/2022 203 GUMROAD-BOOKS FIRST NATIONAL BANK 900123 082522-J.WEISS 24.00 08/22/2022 204 TARGET-CANDY, WATER,GIFT CARDS FIRST NATIONAL BANK 900123 082522-J.WEISS 90.09 08/22/2022 205 TARGET-FRIENDS OF HARRY POTTER FIRST NATIONAL BANK 900123 082522-J.WEISS 123.86 08/22/2022 206 JEWEL-POPCORN, BOWLS FIRST NATIONAL BANK 900123 082522-M.CURTIS 13.85 08/22/2022 207 AMAZON-RAFFLE TICKETS FIRST NATIONAL BANK 900123 082522-S.AUGUSTINE 15.54 08/22/2022 208 AMAZON-CHOCOLATE BALLS FIRST NATIONAL BANK 900123 082522-S.AUGUSTINE 33.96 08/22/2022 209 AMAZON-CONTACT LENS SOLUTION, FIRST NATIONAL BANK 900123 082522-S.AUGUSTINE 225.63 08/22/2022 210 AMAZON-CANDY FIRST NATIONAL BANK 900123 082522-S.AUGUSTINE 120.68 GJ-220831LB 09/01/2022 05 August 2022 Deposits 400.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 726.24 400.00 05 AP-220912 09/06/2022 01 BOOKS BAKER & TAYLOR 105202 2036897861 636.81 AP-220925M 09/22/2022 291 DOLLAR TREE-SUPPLIES FOR HARRY FIRST NATIONAL BANK 900124 092522-J.WEISS 43.75 09/22/2022 292 AMAZON-TABLE COVERS FIRST NATIONAL BANK 900124 092522-S.AUGUSTINE 80.86 09/22/2022 293 AMAZON-TABLE COVER REFUND FIRST NATIONAL BANK 900124 092522-S.AUGUSTINE 32.99 09/22/2022 294 MENARDS#49899-PLANTS, SOIL FIRST NATIONAL BANK 900124 092522-S.AUGUSTINE 22.11 GJ-220930LB 10/04/2022 05 Sept 2022 Deposits 100.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 783.53 132.99 06 AP-221025M 10/18/2022 373 MENARDS#44442-MULCH FIRST NATIONAL BANK 900125 102522-D.DEBORD 26.52 10/18/2022 374 MENARDS#44444-MULCH, GRAVEL FIRST NATIONAL BANK 900125 102522-D.DEBORD 24.90 10/18/2022 375 MENARDS#092222-FALL DECOR FIRST NATIONAL BANK 900125 102522-D.DEBORD 92.37 10/18/2022 376 DOLLAR TREE-FRENDS FIRST NATIONAL BANK 900125 102522-J.WEISS 23.75 10/18/2022 377 AMAZON-BOOKS FIRST NATIONAL BANK 900125 102522-M.CURTIS 97.32 10/18/2022 378 BRICKS R US-2 CONCRETE BRICKS FIRST NATIONAL BANK 900125 102522-S.AUGUSTINE 65.37 GJ-221031LB 11/02/2022 05 Oct 2022 Deposits 471.50 _________________________________ TOTAL PERIOD 06 ACTIVITY 330.23 471.5023
DATE: 03/06/2023 UNITED CITY OF YORKVILLE PAGE: 2TIME: 08:19:53 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2023 ACTIVITY THROUGH FISCAL PERIOD 10PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________ 07 AP-221125M 11/18/2022 418 TARGET-SNACKS, C&R SKETCH FIRST NATIONAL BANK 900126 112522-J.WEISS 32.96 11/18/2022 419 MENARDS#102122-STONES, CANDY FIRST NATIONAL BANK 900126 112522-J.WEISS 88.47 11/18/2022 420 MENARDS#102122-FABRIC, STONES FIRST NATIONAL BANK 900126 112522-J.WEISS 52.66 11/18/2022 421 DOLLAR TREE-FRIENDS FIRST NATIONAL BANK 900126 112522-J.WEISS 31.25 11/18/2022 422 BOOK PAGE-ANNUAL RENEWAL FIRST NATIONAL BANK 900126 112522-S.AUGUSTINE 411.50 11/18/2022 423 AMAZON-PUZZELS, PAINTER'S FIRST NATIONAL BANK 900126 112522-S.AUGUSTINE 94.56 11/18/2022 424 AMAZON-BOOKS FIRST NATIONAL BANK 900126 112522-S.AUGUSTINE 45.98 11/18/2022 425 AMAZON-BOOK FIRST NATIONAL BANK 900126 112522-S.AUGUSTINE 14.49 GJ-221130LB 12/01/2022 05 Nov 2022 Deposits 750.00 _________________________________ TOTAL PERIOD 07 ACTIVITY 771.87 750.00 08 AP-221212 12/06/2022 01 SEPT 2022-JUN 2023 ILLINOIS RAILS 105243 10147 750.00 AP-221225M 12/19/2022 359 AMAZON-PUZZEL RETURN CREDIT FIRST NATIONAL BANK 900127 122522-S.AUGUSTINE 21.99 12/19/2022 360 AMAZON-CRAFT SUPPLIES FIRST NATIONAL BANK 900127 122522-S.AUGUSTINE 125.97 GJ-221231LB 01/03/2023 04 Dec 2022 Deposits 1,900.00 _________________________________ TOTAL PERIOD 08 ACTIVITY 875.97 1,921.99 09 AP-230125M 01/20/2023 285 DOLLAR TREE-POLAR EXPRESS FIRST NATIONAL BANK 900128 012523-J.WEISS 88.00 01/20/2023 286 AMAZON-PAPER INDEX FIRST NATIONAL BANK 900128 012523-S.AUGUSTINE 11.79 01/20/2023 287 AMAZON-GROCERY STORE FIRST NATIONAL BANK 900128 012523-S.AUGUSTINE 189.99 GJ-230131LB 02/02/2023 05 Jan 2023 Deposits 2,000.00 _________________________________ TOTAL PERIOD 09 ACTIVITY 289.78 2,000.00 10 AP-230225M 02/22/2023 325 TARGET-HORMEL TRAY FIRST NATIONAL BANK 900129 022523-M.CURTIS 15.49 02/22/2023 326 CRAFT'D-3 GIFT CARDS FIRST NATIONAL BANK 900129 022523-M.CURTIS 40.00 02/22/2023 327 JEWEL-REFRESHMENTS,COOKIES FIRST NATIONAL BANK 900129 022523-M.CURTIS 25.56 GJ-230227LB 03/02/2023 06 Feb 2023 Deposits 600.00 _________________________________ TOTAL PERIOD 10 ACTIVITY 81.05 600.00 TOTAL ACCOUNT ACTIVITY 6,493.05 6,669.48 ENDING BALANCE 55,452.27 GRAND TOTAL 0.00 55,452.27 TOTAL DIFFERENCE 0.00 55,452.2724
% of Fiscal Year8%17%25%33%42%50%58%67%75%83%Year-to-Date FISCAL YEAR 2023 ACCOUNT NUMBER DESCRIPTIONMay-22June-22July-22August-22 September-22 October-22 November-22 December-22 January-23 February-23Totals BUDGET % of BudgetLIBRARY OPERATIONS REVENUESTaxes82-000-40-00-4000 PROPERTY TAXES 44,628 377,451 15,406 27,464 341,193 7,663 6,708 - - - 820,513 822,463 99.76%82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE 45,978 388,869 15,872 28,295 351,515 7,894 6,911 - - - 845,334 844,771 100.07%Intergovernmental82-000-41-00-4120 PERSONAL PROPERTY TAX 3,996 - 2,877 328 - 3,875 - 1,269 2,799 - 15,143 8,000 189.29%82-000-41-00-4160 FEDERAL GRANTS 870 - 840 - - - 746 - - - 2,456 - 0.00%82-000-41-00-4170 STATE GRANTS - - - 31,761 - - - - - - 31,761 21,151 150.16%Fines & Forfeits82-000-43-00-4330 LIBRARY FINES 1,156 38 89 315 67 199 49 99 122 266 2,399 1,000 239.91%Charges for Service82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 2,212 730 569 2,987 628 2,519 206 - 276 719 10,847 8,500 127.62%82-000-44-00-4422 COPY FEES 299 168 210 382 121 163 - 438 7 344 2,132 3,000 71.06%82-000-44-00-4439 POGRAM FEES- - - - - - - - - 1 1 - 0.00%Investment Earnings82-000-45-00-4500 INVESTMENT EARNINGS238 326 447 602 2,130 1,832 1,019 5,056 3,511 1,159 16,318 1,000 1631.79%Miscellaneous82-000-48-00-4820 RENTAL INCOME- - - - - - 75 - - - 75 500 15.00%82-000-48-00-4850 MISCELLANEOUS INCOME306 1,020 200 106 187 191 183 280 1,474 56,251 60,200 2,750 2189.08%Other Financing Sources82-000-49-00-4901 TRANSFER FROM GENERAL7,245 2,022 2,022 2,022 2,303 2,022 928 1,321 4,696 2,534 27,116 23,638 114.71%TOTAL REVENUES: LIBRARY 106,928 770,624 38,532 94,263 698,144 26,358 16,825 8,463 12,885 61,274 1,834,296 1,736,773 105.62%LIBRARY OPERATIONS EXPENDITURESSalaries & Wages82-820-50-00-5010 SALARIES & WAGES21,923 23,457 22,760 22,372 33,558 22,372 22,372 22,372 22,372 22,372 235,931 291,111 81.05%82-820-50-00-5015 PART-TIME SALARIES14,775 14,339 14,679 16,333 21,981 11,751 10,941 9,946 9,603 11,488 135,836 213,000 63.77%Benefits82-820-52-00-5212RETIREMENT PLAN CONTRIBUTION1,951 2,098 2,026 1,991 2,987 1,991 1,991 1,991 1,468 1,468 19,961 26,240 76.07%82-820-52-00-5214 FICA CONTRIBUTION 2,722 2,806 2,777 2,862 4,150 2,512 2,450 2,374 2,347 2,491 27,491 37,585 73.14%82-820-52-00-5216 GROUP HEALTH INSURANCE 15,608 7,030 4,943 12,073 9,612 8,218 7,764 10,428 8,123 6,950 90,747 102,663 88.39%82-820-52-00-5222 GROUP LIFE INSURANCE 47 47 47 30 69 49 49 49 49 49 486 586 82.86%82-820-52-00-5223 DENTAL INSURANCE 624 595 412 930 646 646 646 646 646 581 6,371 7,135 89.29%82-820-52-00-5224 VISION INSURANCE 85 85 85 58 131 91 91 91 91 91 900 1,051 85.67%82-820-52-00-5230 UNEMPLOYMENT INSURANCE 295 - - - 281 - - 295 - 342 1,213 1,000 121.34%82-820-52-00-5231 LIABILITY INSURANCE 6,950 2,022 2,022 2,022 2,022 2,022 928 1,026 5,057 2,191 26,264 22,638 116.02%Contractual Services82-820-54-00-5401 ADMINISTRATIVE CHARGEBACK- - - - - - - - - - - 15,000 0.00%82-820-54-00-5412 TRAINING & CONFERENCES320 - - - - - - 35 - - 355 3,000 11.84%82-820-54-00-5415 TRAVEL & LODGING- 83 - 20 - - 73 - - 74 249 1,500 16.62%82-820-54-00-5426 PUBLISHING & ADVERTISING- - - - - - - - - - - 2,500 0.00%82-820-54-00-5440 TELECOMMUNICATIONS125 695 445 570 125 125 125 125 1,815 540 4,690 8,000 58.62%82-820-54-00-5452 POSTAGE & SHIPPING- 16 116 16 263 18 142 24 37 393 1,025 750 136.65%82-820-54-00-5453BUILDING & GROUND CHARGEBACK536 536 536 536 536 536 536 536 536 536 5,357 6,428 83.33%82-820-54-00-5460 DUES & SUBSCRIPTIONS 829 1,262 194 1,379 15 197 194 400 1,556 165 6,193 11,000 56.30%82-820-54-00-5462 PROFESSIONAL SERVICES 1,617 3,570 1,275 1,331 1,864 107 7,912 11,677 7,079 6,362 42,794 40,000 106.99%82-820-54-00-5466 LEGAL SERVICES - - - - - - - - - - - 3,000 0.00%82-820-54-00-5468 AUTOMATION 2,679 - 4,746 - - 4,791 499 - 4,746 - 17,460 21,000 83.14%82-820-54-00-5480 UTILITIES - - 2,026 - 3,326 - 1,143 1,254 1,798 3,392 12,939 23,320 55.48%82-820-54-00-5495OUTSIDE REPAIR & MAINTENANCE- 6,013 2,408 762 5,484 1,088 26,114 5,229 - 66,402 113,500 50,000 227.00%82-820-54-00-5498 PAYING AGENT FEES - 1,689 - - - - - - - - 1,689 1,700 99.32%SuppliesYORKVILLE PUBLIC LIBRARYFISCAL YEAR 2023 BUDGET REPORTFor the Month Ended February 28, 202325
% of Fiscal Year8%17%25%33%42%50%58%67%75%83%Year-to-Date FISCAL YEAR 2023 ACCOUNT NUMBER DESCRIPTIONMay-22June-22July-22August-22 September-22 October-22 November-22 December-22 January-23 February-23Totals BUDGET % of BudgetYORKVILLE PUBLIC LIBRARYFISCAL YEAR 2023 BUDGET REPORTFor the Month Ended February 28, 202382-820-56-00-5610 OFFICE SUPPLIES- 448 57 196 1,438 74 303 276 227 188 3,207 8,000 40.09%82-820-56-00-5620 OPERATING SUPPLIES- 336 - 392 - - - - 1,383 - 2,111 4,000 52.78%82-820-56-00-5621 CUSTODIAL SUPPLIES- 440 577 569 185 259 559 339 480 240 3,649 7,000 52.12%82-820-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - 420 1,650 1,410 - - - 3,480 3,000 116.00%82-820-56-00-5671 LIBRARY PROGRAMMING - - - - 89 - - - - 55 144 2,000 7.19%82-820-56-00-5675 EMPLOYEE RECOGNITION - 63 - - - - - 20 59 - 141 300 47.10%82-820-56-00-5685 DVD'S - - - - - - - - - - - 500 0.00%82-820-56-00-5686 BOOKS - 599 273 115 - - - - 24 112 1,122 1,500 74.80%2006 Bond82-820-84-00-8000 PRINCIPAL PAYMENT - - - - - - - 75,000 - - 75,000 75,000 100.00%82-820-84-00-8050 INTEREST PAYMENT - 6,556 - - - - - 6,556 - - 13,113 13,113 100.00%2013 Refunding Bond82-820-99-00-8000 PRINCIPAL PAYMENT - - - - - - - 675,000 - - 675,000 675,000 100.00%82-820-99-00-8050 INTEREST PAYMENT- 42,100 - - - - - 42,100 - - 84,200 84,200 100.00%TOTAL FUND REVENUES106,928 770,624 38,532 94,263 698,144 26,358 16,825 8,463 12,885 61,274 1,834,296 1,736,773 105.62%TOTAL FUND EXPENDITURES71,085 116,883 62,405 64,557 89,181 58,496 86,243 867,788 69,495 126,484 1,612,616 1,763,820 91.43%FUND SURPLUS (DEFICIT)35,843 653,742 (23,874) 29,706 608,963 (32,138) (69,419) (859,325) (56,610) (65,210) 221,680 (27,047) LIBRARY CAPITAL REVENUES84-000-42-00-4214 DEVELOPMENT FEES5,650 8,000 4,500 11,150 10,000 27,650 17,500 8,500 5,000 15,000 112,950 50,000 225.90%84-000-45-00-4500 INVESTMENT EARNINGS15 15 15 16 16 15 17 19 20 18 165 350 47.08%84-000-48-00-4850 MISCELLANEOUS INCOME- 26 - - - - - - - - 26 - 0.00%TOTAL REVENUES: LIBRARY CAPITAL5,665 8,040 4,515 11,166 10,016 27,665 17,517 8,519 5,020 15,018 113,141 50,350 224.71%LIBRARY CAPITAL EXPENDITURES84-840-54-00-5460 E-BOOK SUBSCRIPTIONS- - - - - - - - - 3,000 3,000 3,500 85.71%84-840-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - 180 - 308 5,000 - - 960 - 6,448 25,000 25.79%84-840-56-00-5683 AUDIO BOOKS - 345 180 105 10 40 180 205 300 40 1,405 3,500 40.13%84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - - - - - 500 0.00%84-840-56-00-5685 DVD'S - 256 637 173 130 196 964 100 120 439 3,015 3,000 100.49%84-840-56-00-5686 BOOKS - 2,391 1,827 4,728 2,599 5,140 3,664 3,042 2,224 6,310 31,925 50,000 63.85%TOTAL FUND REVENUES 5,665 8,040 4,515 11,166 10,016 27,665 17,517 8,519 5,020 15,018 113,141 50,350 224.71%TOTAL FUND EXPENDITURES - 2,991 2,824 5,006 3,046 10,376 4,807 3,347 3,604 9,789 45,792 85,500 53.56%FUND SURPLUS (DEFICIT) 5,665 5,049 1,692 6,160 6,970 17,289 12,709 5,172 1,416 5,228 67,349 (35,150) 26
May June July August September October November December January February March April202220222022202220222022202220222023202320232023Library Operations Old Second $ 503,901 $ 797,910 $ 762,781 $ 738,833 $ 1,062,151 $ 1,033,664 $ 966,030 $ 855,887 $ 767,113 $ 646,777 Building Development FeesOld Second 177,739 179,331 184,522 184,032 192,152 191,291 214,650 228,822 233,738 228,966 Library Operations Illinois Funds 283,566 283,827 284,214 316,514 317,169 317,993 318,929 319,994 321,140 322,244 Total: $ 965,205 $ 1,261,067 $ 1,231,517 $ 1,239,379 $ 1,571,471 $ 1,542,947 $ 1,499,610 $ 1,404,703 $ 1,321,992 $ 1,197,988 $ - $ - PAYROLL1ST PAY PERIOD20,523$ $ 20,446 $ 21,065 $ 21,830 $ 21,183 $ 19,983 $ 19,983 $ 18,017 $ 17,565 $ 18,801 2ND PAY PERIOD20,848 22,254 21,177 21,729 20,040 18,643 18,552 18,666 18,224 19,019 3RD PAY PERIOD - - - - 21,454 - - - - - Total41,371$ 42,699$ 42,242$ 43,558$ 62,676$ 38,626$ 38,535$ 36,683$ 35,790$ 37,819$ -$ -$ YORKVILLE PUBLIC LIBRARYCASH STATEMENTAs of February 28, 2023FISCAL YEAR 202327
February YTD % of FY 2023
Actual Actual Budget Budget YTD Actual % Change
LIBRARY OPERATIONS FUND (82)
Revenues
Property Taxes -$ 1,665,847$ 99.92% 1,667,234$ 1,611,808$ 3.35%
Intergovernmental
Personal Property Replacement Tax -$ 15,143$ 189.29%8,000$ 8,781$ 72.45%
Federal & State Grants - 34,217 161.78% 21,151 32,546 5.14%
Total Intergovernmental -$ 49,361$ 169.33% 29,151$ 41,327$ 19.44%
Library Fines 266$ 2,399$ 239.91%1,000$ 6,074$ -60.50%
Charges for Services
Library Subscription Cards 719$ 10,847$ 127.62%8,500$ 8,241$ 31.62%
Copy Fees 345 2,133 71.09%3,000 2,280 -6.46%
Total Charges for Services 1,064$ 12,980$ 112.87% 11,500$ 10,521$ 23.37%
Investment Earnings 1,159$ 16,318$ 1631.79%1,000$ 1,065$ 1432.05%
Reimbursements/Miscellaneous/Transfers In
Miscellaneous Reimbursements -$ -$ 0.00%-$ -$ 0.00%
Rental Income - 75 15.00%500 200 -62.50%
Miscellaneous Income 56,251 60,200 2189.08%2,750 2,104 2761.24%
Transfer In 2,534 27,116 114.71% 23,638 23,789 13.99%
Total Miscellaneous & Transfers 58,785$ 87,391$ 325.02% 26,888$ 26,093$ 234.92%
Total Revenues and Transfers 61,274$ 1,834,296$ 105.62% 1,736,773$ 1,696,888$ 8.10%
Expenditures
Library Operations 126,484$ 1,612,617$ 91.43%1,763,820$ 1,465,973$ 10.00%
50 Salaries 33,860 371,768 73.75% 504,111 350,284 6.13%
52 Benefits 14,164 173,432 87.20% 198,898 157,725 9.96%
54 Contractual Services 77,864 206,250 110.18% 187,198 103,788 98.72%
56 Supplies 595 13,854 52.68% 26,300 13,951 -0.70%
99 Debt Service - 847,313 100.00% 847,313 840,225 0.84%
Total Expenditures and Transfers 126,484$ 1,612,617$ 91.43% 1,763,820$ 1,465,973$ 10.00%
Surplus(Deficit)(65,210)$ 221,679$ (27,047)$ 230,915$
*February represents 83% of fiscal year 2023
YORKVILLE PUBLIC LIBRARY
STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS
For the Month Ended February 28, 2023 *
Fiscal Year 2022
For the Month Ended February 28, 2022
28
YPL Director’s Report for Feb 2023
Past & Upcoming Events/Programs
Celebrated National Engineers Week Feb 21-24 with daily challenges for kids using STEM activities.
We held an informational meeting for ELL volunteers in February and had over 30 people attend. This
tells us that there are many people willing to do volunteer activities and we need to bring more
opportunities to them.
Our Poetry & Art Grapeview program was held on Feb 25. This experiment began in January of 2022
with a poet submitting an original poem. In February an artist created a piece of art inspired by that
poem. In March, a different poet crafted a poem based on the February art, and so on throughout the
year. The yearlong program commenced with poets and artists reading and revealing their work. This
will be an annual event and we hope to grow the program in the coming year.
• Military Healthcare 101 – March 21 11:00am
This program is designed for military veterans to learn how military healthcare benefits can be
combined with Medicare benefits to provide better overall healthcare at a lower cost.
• Library Road Trip March 25-April 30 – 17 participating area libraries
Pick up a Library Road Trip passport at any of the participating locations on or after March 25th. Get
your passport stamped at each location you visit. When you have completed your road trip, submit your
passport to YOUR HOME LIBRARY for chances to win a grand prize from your home library.
• Spring Break Programs for Kids March 27-31: Beautiful Oops Art, Storybook YOGA, Family
Books for Bingo, 4-H Junk Drawer STEM, Spy Training, and Interactive Movie.
• A Night to Remember: True Adventures from a Local Paranormal Investigation Team – March
29 7:00pm
West Suburban Paranormal Investigations was founded by 4 friends a little over 5 years ago and is now
one of the only all-female led teams in the area. The group has covered almost 100 Investigations,
capturing close to 1000 pieces of evidence! The investigate unusual occurrences in homes and
businesses with the intent to debunk any peculiar activity, what remains is the evidence that they
believe to be truly paranormal. The team has visited some of the most famous haunted locations in our
area - Waverly Hills Sanitorium, Old Lake County Jail, the Villisca Axe Murder House, and Eldred House.
For this special presentation, the team will show and explain their equipment, tell stories of their
investigations, and share video and audio evidence that they've gathered.
• Tacos, Hollywood, and Redemption with Danny Trejo – Tue, Apr 4 @ 7:00
Film and TV star, Danny Trejo has been seen in well over 100 movies, including Heat, Desperado,
Machete, Spy Kids, and Breaking Bad. He's also a celebrated author and restaurateur who's had a very
atypical road to success. Join this very special Zoom event to hear Trejo's stories about Tacos,
Hollywood, and Redemption.
29
• Belly of the Beast: King in Chicago – April 11 7:00pm
Join historian, musician, and radio personality Clarence Goodman in one of his exciting programs
specializing in Chicago's unique past. In his presentation, In the Belly of the Beast, Mr. Goodman guides
us through a gripping study of Martin Luther King Jr.’s work in Chicago. From his trio of glorious and
inspiring speeches on the University of Chicago campus starting in 1956 to Dr. King 's marches to end
slums and improve living conditions for blacks in the city in 1965 and 1966. Dr. King's efforts helped
change and shape Chicago, and his impact is still felt today.
Library Operations
Andersen Plumbing & Heating was here today to repair the 4” cast iron pipe that was leaking down into
the Children’s Department. Ted has shown me a photo of the crack in the old pipe.
We had a call from ADS on 2/27/23 at 5:00am that the fire alarm was sounding in the library and the fire
department had been dispatched. When I arrived, the building strobes were flashing, and nobody was
present. I call ADS and they said the FD had already been here and didn’t find any trouble. It was
determined that it was a faulty smoke detector by the 1st floor elevator in alarm. Ted came and
disconnected the detector and ADS put our alarm panel out of service until 12:00 noon. I called Fox
Valley Fire to come and service the detector, but they wanted $1,200 for emergency call. I declined their
service, and called ADS, who came out around 9:30 and replaced the detector and reset the panel. Their
charge was $725.
Great Lakes Plumbing was here to inspect our fire sprinkler system on 3/2/23.
Staff
We had 15 employees complete the CRP/AED certification training in Feb. & Mar. They will be receiving
their certificate this month and certification is good for 2 years.
Other
The FOL have paid for the purchase of 4 white boards for all our study rooms and 1 portable white board
for upstairs.
I attended a meeting at the Sandwich Public Library with several area directors for our quarterly
meeting.
30
31
Monthly
Statistics
February 2023
New Cardholders Added
2023: 84
2022: 71
Change: +16.77%
Technology Stats
Events and Programs
2023: 59
2022: 41
Change: +36%
Items Added
2023: 457
2022: 387
Change: +16.59%
Events and Program
Attendance
2023: 1,101
2022: 588
Change: +60.75%
2023: 1,563
2022: 1,293
Change: +18.91%
Digital
Checkouts
2023: 183
2022: 217
Change: -17%
Computer Use
2023: 5,656
2022: 4,367
Change: +25.72%
Website Hits
Checkouts
2023: 5,729
2022: 4,969
Change: +14.21%
Visits
2023: 5,682
2022: 4,014
Change: +34.41%
32
YORKVILLE STATISTICS FOR FY23 PRAIRIECAT
web
renewals web holds
checkout
s+
renewals
checkout
s renewals
holds
placed
holds
filled checkins
Items
lent to
other
libraries
Items
borrowe
d from
other
libraries
Items to
Reciproc
al
Borrower
s
atYorkvill
e
Items
added
Patrons
added
MAY 460 1308 5269 4982 287 373 1350 5227 574 1041 332 534 78
JUNE 553 1772 8341 7965 376 366 1772 6001 598 1427 388 365 212
JUL 1007 1774 8060 7682 378 311 1786 7759 534 1428 521 362 166
AUG 783 1895 7403 6991 412 389 1770 7660 650 1387 416 317 152
SEP 780 1651 5948 5547 401 435 1793 5737 659 1478 378 317 106
OCT 880 1530 5510 5125 385 337 1530 5516 581 1249 348 443 82
NOV 600 1534 5896 5476 420 367 1554 5413 602 1271 517 304 61
DEC 740 1177 3930 3709 221 246 1124 4585 442 912 348 214 58
JAN 667 1758 6778 6432 346 437 1888 5084 643 1597 473 397 92
FEB 654 1569 5711 5389 322 328 1625 5480 698 1283 390 457 84
MAR
APR
Totals
ANCESTRY E-READ IL OMNI OCLC
SEARCHES HITS E-BOOK E-AUDIO USERS E-BOOK E-AUDIO USERS VIDEO LENT BORROWED
MAY 20 9 28 108 31 729 598 317 0 17 3
JUN 18 6 28 81 39 787 661 310 0 10 23
JUL 30 33 24 110 35 728 687 333 0 18 11
AUG 22 78 25 80 34 794 662 333 0 20 20
SEP 11 23 14 92 33 739 592 336 0 18 17
OCT 30 28 26 78 43 748 699 342 0 14 35
NOV 43 24 26 60 34 720 623 335 0 14 4
DEC 2 4 15 72 32 707 592 328 0 8 9
JAN 26 16 17 77 36 844 780 386 0 27 16
FEB 57 17 25 82 35 807 649 354 0 13 13
MAR
APR
Totals
33
FY 2021 ATTENDANCE MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR
PATRON DOOR COUNT 5630 5954 4970 5441 4747 4159 5250 4504 5328 5682
CURBSIDE PATRONS 16 18 3 8 18 4 6 9 14 4
HOME DELIVERY 2 2 1 2 4 9 7 5 8 3
CARDS ISSUED THROUGH WEBSITE 9 24 13 19 12 4 5 8 12 18
CHILDREN'S AGE 0-5 PROGRAMS 8 18 18 8 7 9 8 8 6 5
AGE 0-5 ATTENDANCE 198 201 135 146 214 202 97 146 119 65
CHILDREN'S AGE 6-11 PROGRAMS 7 18 15 8 8 8 7 8 9 7
AGE 6-11 ATTENDANCE 126 238 315 143 138 185 78 116 94 73
NUMBER OF CHILDREN'S PASSIVE PROGRAMS 3 3 4 5 6 6 10 5 7 6
CHILDREN'S PASSIVE PROGRAM ATTENDANCE 332 436 463 525 505 640 493 323 584 444
NUMBER OF YA PROGRAMS 3 4 10 6 4 5 6 3 7 9
YA PROGRAM ATTENDANCE 53 75 66 45 24 73 30 122 111
NUMBER OF YA PASSIVE PROGRAMS 2 1 2 2 1 3 2 1 1
YA PASSIVE PROGRAM ATTENDANCE 6 1 7 13 15 76 27 55 11
YOUTH SUMMER/WINTER READING 218 60
NUMBER OF ADULT PROGRAMS 17 19 17 21 25 25 23 12 28 27
ADULT PROGRAM ATTENDANCE 164 212 177 179 240 213 298 138 273 260
NUMBER OF ADULT PASSIVE PROGRAMS 1 3 3 4 2 4 4 3 3
ADULT PASSIVE PROGRAM ATTENDANCE 3 52 61 73 53 65 65 79 77
ADULT SUMMER/WINTER READING 43
MEETING RM. RENTAL/COMMUNITY USE 2 2 5 12 9 4 10 9
MEETING ROOM USE:24 14 21 15 21 19 15 15 21 23
BOARD ROOM USE 4 6 3 13 16 11 9 4 12 13
STUDY ROOM USE 65 69 41 50 82 92 67 56 62 53
MUSEUM PASS 9 14 22 22 6 12 3 4 4 1
YOUTH COMPUTER SESSIONS 18 37 25 25 16 61 18 11 34 15
ADULT COMPUTER SESSIONS 194 229 218 248 191 192 196 127 223 168
FRIENDS VOLUNTEER HOURS 39 50 62.5 171 47 41
YOUTH VOLUNTEER HOURS
IPLAR NOTES: COUNT LIVE (SYNCRONOUS) VIRTUAL PROGRAMS AS PROGRAM ATTENDANCE
COUNT VIEWS OF RECORDED (ASYNCRONOUS) VIRTUAL PROGRAMS AS PASSIVE PROGRAM ATTENDANCE
34
Read -across -AMer1ca
11,\ircN,�l i"OUC,\ilON ASSOt:1..:.;10:,
(w1t11•n•.,,:. •;u,a� Or c,�,.'" c.,.,a•�
5 16 Facebook SpanishStory Time March 8 and 22 at 10:00 am
MARCH 2
All Day
Story Walk
7
T.A.G.@ 2:45
For more information on Yorkville
Public Library's Children's
programs or to register,
·please visit our website at http://
www.yorkville.lib.il.us
902 GAME FARM RD YORKVILLE, IL
1 Preschool Zone
10:30 or 1:30
Registration Required
2Tots and Toddlers I 3 @ 10:30
Registration Required
4-H S(traw R9)cketsages s� @4:30
DROP IN STORY TIME 10:30 @ YPL
8 Artful Beginnings-19
(Preschool)
10
10:30
Registration Required
DROP IN STORY TIME 10:30@ YPL
3D Printing
**IN PERSON
Registration Required
*SEE WEBSITE
11 VIRTUAL
3D PRINTING
*SEE WEBSITE*
Window Art (March 6-10) !ReQister for an _q Qintme_nt time online12 19 26
LEGO Kits March 13-17
Registration Required
*SEE WEBSITE
13
20 2 BOOK CLUB (GRADE 3-5) 4:30-5:00
Registration Required
ops
ART
1:30-2:30
Registration Required
BOOK CLUB
14 �) 115 TnnMoultfl
Ready Readers
10:30-11:00
Registration Required 21 T.A.G.@ 2:45
Tots and Toddlers @ 10:30
Registration Required
22
16 BOOK CLUB (1-2)
4:30-5:00
Registration Required
23 BOOK CLUB (1-2)
4:30-5:00
Registration Required
TUESDAY-IFRIDAY *DROP IN*
28Storybook YOGA 1294-H Spring Break10:30 Registration Require
*SEE WEBSITEBooks for BINGO
2:00-3:00
Ages 5-7@ 10:30
Ages 8-12@ 1:00
Registration Required
*SEE WEBSITE
30 SPY Training
2:00-3:00
Registration Required
Harry Pt9�r Book
4:30-5:30
SEE WEBSITE
17
24
DROP IN STORY TIME 10:30 @ YPL
DROP IN STORY TIME 10:30@ YPL
31 DROP IN STORY TIME 10:30 @ YPL
Interactive Movie1:00-3:00
Registration Required
BSITE
18
Read With Paws
10:30-11:30
Registration Required
*SEE WEBSITE25 Escape
Room
Thrs Escape Adventure is available the month of March Drop in or contact the librnry for a reservation.
35
This page intentionally left blank.
36
Edu,ational Programs
Computer Basics For Seniors
All classes Wednesday mornings@ 1 0:00 am
Class 9: Email Basics-March 1st
Class 10: Google Tools-March 8th
Class 11: Google Chrome-March 15
class 12: Video conferencing -March 22
Registration Required 3ee a librarian if '=JOU need help registering. l-
�Ju4
Need inspiration?
Looking for a friendly
community of writers?
Join the Yorkville Creative
Writing Group and spark your
creative energies.
The Writing Group holds
meetings on the fourth
Tuesday of every month.
NEXT MEETING: Tuesday, March 21st@ 7:00 PM ..·•·
ID t � 1 t3 � �i-t · jm,,,�,
Get excited and energized about reading with the YPL Men's Book Club, a monthly group that centers on thought provoking and lively discussions about fascinating and diverse books from all different genres.
A book club for readers who love to eat ...or is it a book club for eaters who love to read?
The Books & Cooks book club meets one Tuesday a month to discuss great books and share some food inspired by the books they've read.
__ Lunch·. Bunch(·.·_ -Book ·club . -... , \. ,,; �sEcot-1O·
� 1\1fE \
�I i
,'t11 1tt1E\:\.E�.--·-WES'I'
Bring your lunch and join fellow readers in your community discussing ·, a great new book each month.
NexfMeeting: Wednesday, January 11th @ 12:00 pm ,,,,� :'.. �\ \�-:�' '\ \ Discussing: The Second Life of Mirielle West by Amanda Skenadore _ _ � 37
Military Healthcare & Medicare 101
This program helps veterans learn how military healthcare benefits can be combined with Medicare benefits to provide better overall healthcare at a lower cost. walk and to talk about ridays -March 3rd and 17t Tuesday, March 21st@11:00 am
Yorkville Public Library
902 GAME FARM RD, YORKVILLE, Illinois 60560
630-553-4354www yorkviUe.!ib.i!.us/
,vie at the
son the
Jii,lj _Ill 111•n1n1nr ·orkville 'Public �ibra
M"
upcoming programs I
Taught by• Northwestern Medicine exercise physiologist who is also• classically trained piano teacher, we will explore the effect music has on our health and how different tempos and types of music might make us feel. UtiLizing • vast spectrum of music genres from rock to pop to country, we will discuss the strategic use of different types music to provide doily benefits from heart health to exercise performance to decreasing depression symptoms. Breathing exercises are taught to diverse musical pieces to help participants along on their wellness journey.
A NIGHT TO REMEMICR:
TIVE ADVENTURES J'IOM A loeAL PARANORMAL -INfflfflATION ftAM
JOf"I us +or a ,;pec.d presentattcn from We.5t 5u�an Pora10rrT10l lnve,;l"j"lioro - one ol'. lllno,; only all.+erflOle pan::inorrMI nve<ifv.tationri te.«rl';! The "_f"OOP wJ tell' <;Ct'Tle ,;torie,; about their ne:Al"iy JOO locol inve.;fit_fficm, $hew uc; how their equipn-.,nt war'-<, ond <I-ore rudio and vdeo evidence !hat they've collected O'l/er tt-e year.;. Danny Trejo talk Tacos, Hollgwood, & Film and lV star, Danny Trejo has been seen in we over 100 movies, including Heat, Desperado, tv'achete, Spy Kids, and Breaking Bad. He's also celebrated author and restauranteurwho's had very atypical road to success. Join this veryspe Zoom event to hearTrejo's: Tacos, Hollywood, and Re
• This it;tntis mJCf po1s1:!t D'/llliM!i u:i,anu •��•NOIJ Fresenl J 5t1tt...,1C& ccUl:;or1bon amono put he �•::::•:� li�ranes onenno n1i;rH:;u3111f t·,erits
Thursday, March 23rd @ 3:00 pm
38
Trico Mechanical
HVAC Repair Log FY23
Date Invoice Amount Notes
8/8/22 6806 3,336.00 Main air handler chilled water acuator motors
8/16/22 6807 2,148.00 IT room repair
8/30/22 6836 1,088.00 replaced RH sensor for discharge air
10/4/22 6922 1,278.00 cut in access panel on ductwork for remediation
9/15/22 6924 1,196.00 checked strainer in pump for chiller - install new o-ring
10/21/22 7003 2,976.00 worked on boiler actuators and ran new low voltage wire to pumps
10/21/22 7004 4,886.00 boiler operational controller and sensors
11/2/22 7000 1,771.00 replace exhaust fan motor
11/8/22 8674 4,307.00 boiler pm's and replacement parts
1/31/23 7220 14,081.00 refrigerant testing on chiller - parts and 72 hours of labor
1/31/23 7224 13,840.00 flood repairs - parts and 72 hours of labor
2/10/23 7258 1,503.00 actuator motors and 9 hours labor
52,410.00
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
This page intentionally left blank.
64
FY 2023 FY 2024
FY 2021 FY 2022 Adopted FY 2023 Proposed FY 2025 FY 2026 FY 2027 FY 2028
Actual Actual Budget Projected Budget Projected Projected Projected Projected
Revenues
Taxes 1,561,523$ 1,611,808$ 1,667,234$ 1,665,847$ 1,763,193$ 1,805,403$ 981,755$ 1,011,208$ 1,041,544$
Intergovernmental 29,083 48,746 29,151 51,217 47,000 47,000 47,000 47,000 47,000
Fines & Forfeits 3,249 6,576 1,000 2,500 1,000 1,000 1,000 1,000 1,000
Charges for Service 6,081 11,131 11,500 13,500 6,000 6,000 6,000 6,000 6,000
Investment Earnings 1,268 1,342 1,000 20,000 15,000 10,000 10,000 10,000 10,000
Miscellaneous 1,204 2,770 3,250 61,100 3,500 3,500 4,000 4,000 4,000
Total Revenues 1,602,408$ 1,682,373$ 1,713,135$ 1,814,164$ 1,835,693$ 1,872,903$ 1,049,755$ 1,079,208$ 1,109,544$
Other Financing Sources 25,885 24,809 23,638 28,563 31,335 33,140 35,053 37,081 39,231
Total Revenues and Transfers 1,628,293$ 1,707,182$ 1,736,773$ 1,842,727$ 1,867,028$ 1,906,043$ 1,084,808$ 1,116,289$ 1,148,775$
Expenditures
Salaries 425,775$ 439,588$ 504,111$ 473,000$ 456,307$ 472,956$ 490,865$ 505,041$ 520,492$
Benefits 169,709 172,081 198,898 202,413 188,034 200,115 213,163 226,765 241,396
Contractual Services 127,366 127,412 187,198 286,177 344,406 297,864 300,285 304,576 309,046
Supplies 18,929 19,011 26,300 22,280 51,300 61,300 71,300 81,300 81,300
Debt Service 827,088 840,225 847,313 847,313 866,750 864,000 - - -
Total Expenditures 1,568,867$ 1,598,317$ 1,763,820$ 1,831,183$ 1,906,797$ 1,896,235$ 1,075,613$ 1,117,682$ 1,152,234$
Surplus (Deficit)59,426$ 108,865$ (27,047)$ 11,544$ (39,769)$ 9,808$ 9,195$ (1,393)$ (3,459)$
Ending Fund Balance 638,033$ 746,897$ 663,784$ 758,441$ 718,672$ 728,480$ 737,675$ 736,282$ 732,823$
40.67%46.73%37.63%41.42%37.69%38.42%68.58%65.88%63.60%
Operational Fund Balance %86.01%98.52%72.43%77.09%69.10%70.57%68.58%65.88%63.60%
Library Operations Fund (82)
The Yorkville Public Library provides the people of the community, from pre-school through maturity, with access to a collection of books and other materials which will serve their educational, cultural and
recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading.
$550
$600
$650
$700
$750
$800
ThousandsFund Balance
65
FY 2021 FY 2022 FY 2023 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028
Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected Projected
LIBRARY FUND - 82
82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS 736,883$ 774,248$ 822,463$ 820,513$ 899,043$ 943,995$ 981,755$ 1,011,208$ 1,041,544$
82-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE 824,640 837,560 844,771 845,334 864,150 861,408 - - -
82-000-41-00-4120 PERSONAL PROPERTY TAX 7,432 16,201 8,000 17,000 17,000 17,000 17,000 17,000 17,000
82-000-41-00-4160 FEDERAL GRANTS 500 7,587 - 2,456 - - - - -
82-000-41-00-4170 STATE GRANTS 21,151 24,958 21,151 31,761 30,000 30,000 30,000 30,000 30,000
82-000-43-00-4330 LIBRARY FINES 3,249 6,576 1,000 2,500 1,000 1,000 1,000 1,000 1,000
82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 4,653 8,378 8,500 11,000 3,500 3,500 3,500 3,500 3,500
82-000-44-00-4422 COPY FEES 1,426 2,702 3,000 2,500 2,500 2,500 2,500 2,500 2,500
82-000-44-00-4439 PROGRAM FEES 2 51 - - - - - - -
82-000-45-00-4500 1,268 1,342 1,000 20,000 15,000 10,000 10,000 10,000 10,000
82-000-48-00-4820 RENTAL INCOME - 200 500 100 500 500 1,000 1,000 1,000
82-000-48-00-4850 MISCELLANEOUS INCOME 1,204 2,570 2,750 61,000 3,000 3,000 3,000 3,000 3,000
1,602,408$ 1,682,373$ 1,713,135$ 1,814,164$ 1,835,693$ 1,872,903$ 1,049,755$ 1,079,208$ 1,109,544$
Over Budget 101,029$
82-000-49-00-4901 TRANSFER FROM GENERAL 25,885 24,809 23,638 28,563 31,335 33,140 35,053 37,081 39,231
25,885$ 24,809$ 23,638$ 28,563$ 31,335$ 33,140$ 35,053$ 37,081$ 39,231$
Over Budget 4,925$
1,628,293$ 1,707,182$ 1,736,773$ 1,842,727$ 1,867,028$ 1,906,043$ 1,084,808$ 1,116,289$ 1,148,775$
Over Budget 105,954$
Library Operations Department
82-820-50-00-5010 SALARIES & WAGES 274,146$ 269,386$ 291,111$ 308,000$ 288,307$ 296,956$ 305,865$ 315,041$ 324,492$
82-820-50-00-5015 PART-TIME SALARIES 151,629 170,202 213,000 165,000 168,000 176,000 185,000 190,000 196,000
82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 30,711 27,675 26,240 26,240 21,201 21,411 22,726 24,101 25,570
82-820-52-00-5214 FICA CONTRIBUTION 31,869 32,700 37,585 36,000 33,917 36,181 37,551 38,636 39,818
82-820-52-00-5216 GROUP HEALTH INSURANCE 73,940 79,114 102,663 102,297 93,252 100,712 108,769 117,471 126,869
82-820-52-00-5222 GROUP LIFE INSURANCE 328 532 586 583 554 554 560 566 572
82-820-52-00-5223 DENTAL INSURANCE 5,977 6,336 7,135 7,647 6,835 7,177 7,536 7,913 8,309
82-820-52-00-5224 VISION INSURANCE 999 915 1,051 1,083 940 940 968 997 1,027
82-820-52-00-5230 UNEMPLOYMENT INSURANCE 1,363 645 1,000 1,213 1,250 1,250 1,250 1,250 1,250
82-820-52-00-5231 LIABILITY INSURANCE 24,522 24,164 22,638 27,350 30,085 31,890 33,803 35,831 37,981
82-820-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000
82-820-54-00-5412 TRAINING & CONFERENCES 30 357 3,000 2,000 3,000 3,000 3,000 3,000 3,000
82-820-54-00-5415 TRAVEL & LODGING - 310 1,500 1,000 1,500 1,500 1,500 1,500 1,500
82-820-54-00-5426 PUBLISHING & ADVERTISING 1,104 1,332 2,500 1,500 2,500 2,500 2,500 2,500 2,500
82-820-54-00-5440 TELECOMMUNICATIONS 4,814 7,199 8,000 8,000 8,000 8,000 8,000 8,000 8,000
82-820-54-00-5452 POSTAGE & SHIPPING 491 884 750 1,200 1,000 1,000 1,000 1,000 1,000
82-820-54-00-5453 BUILDING & GROUND CHARGEBACK - - 6,428 6,428 7,487 7,712 7,943 8,181 8,426
82-820-54-00-5460 DUES & SUBSCRIPTIONS 11,974 9,324 11,000 11,000 18,000 18,000 18,000 18,000 18,000
82-820-54-00-5462 PROFESSIONAL SERVICES 41,078 34,322 40,000 30,000 33,500 28,000 28,000 28,000 28,000
Description
Library Fund Revenues
Library Fund Revenue & Transfers
Other Financing Sources
INVESTMENT EARNINGS
66
FY 2021 FY 2022 FY 2023 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028
Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription
82-820-54-00-5466 LEGAL SERVICES 4,613 4,050 3,000 1,000 3,000 3,000 3,000 3,000 3,000
82-820-54-00-5468 AUTOMATION 16,752 17,461 21,000 18,000 25,000 25,000 25,000 25,000 25,000
82-820-54-00-5480 UTILITIES 13,213 27,568 23,320 23,320 24,719 26,202 27,774 29,440 31,206
82-820-54-00-5488 OFFICE CLEANING - - - 36,040 75,000 77,250 79,568 81,955 84,414
82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 31,608 22,916 50,000 130,000 125,000 80,000 80,000 80,000 80,000
82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 1,700 1,689 1,700 1,700 - - -
82-820-56-00-5610 OFFICE SUPPLIES 4,773 4,694 8,000 6,000 8,000 8,000 8,000 8,000 8,000
82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 1,559 1,240 4,000 4,000 4,000 4,000 4,000 4,000 4,000
82-820-56-00-5621 CUSTODIAL SUPPLIES 11,132 4,030 7,000 6,000 7,000 7,000 7,000 7,000 7,000
82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 348 6,916 3,000 3,480 3,000 3,000 3,000 3,000 3,000
82-820-56-00-5671 LIBRARY PROGRAMMING 679 325 2,000 1,000 2,000 2,000 2,000 2,000 2,000
82-820-56-00-5676 EMPLOYEE RECOGNITION 45 171 300 300 300 300 300 300 300
82-820-56-00-5683 AUDIO BOOKS - - - - 3,500 3,500 3,500 3,500 3,500
82-820-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - 500 500 500 500 500
82-820-56-00-5685 DVD'S - - 500 - 3,000 3,000 3,000 3,000 3,000
82-820-56-00-5686 BOOKS 393 1,635 1,500 1,500 20,000 30,000 40,000 50,000 50,000
Debt Service - 2006 Bond
82-820-84-00-8000 PRINCIPAL PAYMENT 75,000 75,000 75,000 75,000 100,000 100,000 - - -
82-820-84-00-8050 INTEREST PAYMENT 20,238 16,675 13,113 13,113 9,550 4,800 - - -
Debt Service - 2013 Refunding Bond
82-820-99-00-8000 PRINCIPAL PAYMENT 610,000 645,000 675,000 675,000 700,000 730,000 - - -
82-820-99-00-8050 INTEREST PAYMENT 121,850 103,550 84,200 84,200 57,200 29,200 - - -
1,568,867$ 1,598,317$ 1,763,820$ 1,831,183$ 1,906,797$ 1,896,235$ 1,075,613$ 1,117,682$ 1,152,234$
Over Budget 67,363$
25,885$ 24,809$ 23,638$ 28,563$ 31,335$ 33,140$ 35,053$ 37,081$ 39,231$
- - - - - - - - -
25,885$ 24,809$ 23,638$ 28,563$ 31,335$ 33,140$ 35,053$ 37,081$ 39,231$
Surplus(Deficit)59,426$ 108,865$ (27,047)$ 11,544$ (39,769)$ 9,808$ 9,195$ (1,393)$ (3,459)$
Fund Balance 638,033$ 746,897$ 663,784$ 758,441$ 718,672$ 728,480$ 737,675$ 736,282$ 732,823$
40.67%46.73%37.63%41.42%37.69%38.42%68.58%65.88%63.60%
86.01%98.52%72.43%77.09%69.10%70.57%68.58%65.88%63.60%Operational Fund Balance %
Library Fund Net Transfers
Transfers In
Library Fund Expenditures
(Transfers Out)
67
.
FY 2023 FY 2024
FY 2021 FY 2022 Adopted FY 2023 Proposed FY 2025 FY 2026 FY 2027 FY 2028
Actual Actual Budget Projected Budget Projected Projected Projected Projected
Revenues
Licenses & Permits 104,600$ 103,850$ 50,000$ 120,000$ 50,000$ 50,000$ 50,000$ 50,000$ 50,000$
Investment Earnings 182 189 350 185 350 500 750 1,000 1,500
Miscellaneous 31 26 - - - - - - -
Total Revenues 104,813$ 104,065$ 50,350$ 120,185$ 50,350$ 50,500$ 50,750$ 51,000$ 51,500$
Expenditures
Contractual Services 3,347$ 3,000$ 3,500$ 3,000$ 3,500$ 3,500$ 3,500$ 3,500$ 3,500$
Supplies 55,862 75,541 82,000 56,500 55,000 45,000 35,000 25,000 25,000
Capital Outlay - 18,050 - - 56,000 250,000 - 200,000 -
Total Expenditures 59,209$ 96,591$ 85,500$ 59,500$ 114,500$ 298,500$ 38,500$ 228,500$ 28,500$
Surplus (Deficit)45,604$ 7,474$ (35,150)$ 60,685$ (64,150)$ (248,000)$ 12,250$ (177,500)$ 23,000$
Ending Fund Balance 169,188$ 176,662$ 145,712$ 237,347$ 173,197$ (74,803)$ (62,553)$ (240,053)$ (217,053)$
Library Capital Fund (84)
The Library Capital Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital, contractual and supply purchases.
($400)
($200)
$0
$200
$400
ThousandsFund Balance
68
FY 2021 FY 2022 FY 2023 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028
Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription
LIBRARY CAPITAL FUND - 84
84-000-42-00-4214 DEVELOPMENT FEES 104,600$ 103,850$ 50,000$ 120,000$ 50,000$ 50,000$ 50,000$ 50,000$ 50,000$
84-000-45-00-4500 182 189 350 185 350 500 750 1,000 1,500
84-000-48-00-4850 MISCELLANEOUS INCOME 31 26 - - - - - - -
104,813$ 104,065$ 50,350$ 120,185$ 50,350$ 50,500$ 50,750$ 51,000$ 51,500$
Over Budget 69,835$
84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,347$ 3,000$ 3,500$ 3,000$ 3,500$ 3,500$ 3,500$ 3,500$ 3,500$
84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 8,387 19,965 25,000 10,000 25,000 25,000 25,000 25,000 25,000
84-840-56-00-5683 AUDIO BOOKS 2,351 3,029 3,500 3,500 - - - - -
84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC 283 45 500 - - - - - -
84-840-56-00-5685 DVD'S 2,307 2,822 3,000 3,000 - - - - -
84-840-56-00-5686 BOOKS 42,534 49,680 50,000 40,000 30,000 20,000 10,000 - -
84-840-60-00-6020 BUILDING IMPROVEMENTS - 18,050 - - 56,000 250,000 - 200,000 -
59,209$ 96,591$ 85,500$ 59,500$ 114,500$ 298,500$ 38,500$ 228,500$ 28,500$
Under Budget (26,000)$
Surplus(Deficit)45,604 7,474 (35,150) 60,685 (64,150) (248,000) 12,250 (177,500) 23,000
Fund Balance 169,188$ 176,662$ 145,712$ 237,347$ 173,197$ (74,803)$ (62,553)$ (240,053)$ (217,053)$
Library Capital Fund Revenues
Library Capital Fund Expenditures
INVESTMENT EARNINGS
69
FY 2023 FY 2024
FY 2021 FY 2022 Adopted FY 2023 Proposed FY 2025 FY 2026 FY 2027 FY 2028
Actual Actual Budget Projected Budget Projected Projected Projected Projected
Revenues
Taxes 1,561,523$ 1,611,808$ 1,667,234$ 1,665,847$ 1,763,193$ 1,805,403$ 981,755$ 1,011,208$ 1,041,544$
Intergovernmental 29,083 48,746 29,151 51,217 47,000 47,000 47,000 47,000 47,000
Licenses & Permits 104,600 103,850 50,000 120,000 50,000 50,000 50,000 50,000 50,000
Fines & Forfeits 3,249 6,576 1,000 2,500 1,000 1,000 1,000 1,000 1,000
Charges for Service 6,081 11,131 11,500 13,500 6,000 6,000 6,000 6,000 6,000
Investment Earnings 1,450 1,531 1,350 20,185 15,350 10,500 10,750 11,000 11,500
Miscellaneous 1,235 2,796 3,250 61,100 3,500 3,500 4,000 4,000 4,000
Total Revenues 1,707,221$ 1,786,438$ 1,763,485$ 1,934,349$ 1,886,043$ 1,923,403$ 1,100,505$ 1,130,208$ 1,161,044$
Other Financing Sources 25,885 24,809 23,638 28,563 31,335 33,140 35,053 37,081 39,231
Total Revenues & Transfers 1,733,106$ 1,811,247$ 1,787,123$ 1,962,912$ 1,917,378$ 1,956,543$ 1,135,558$ 1,167,289$ 1,200,275$
Expenditures
Salaries 425,775$ 439,588$ 504,111$ 473,000$ 456,307$ 472,956$ 490,865$ 505,041$ 520,492$
Benefits 169,709 172,081 198,898 202,413 188,034 200,115 213,163 226,765 241,396
Contractual Services 130,713 130,412 190,698 289,177 347,906 301,364 303,785 308,076 312,546
Supplies 74,791 94,552 108,300 78,780 106,300 106,300 106,300 106,300 106,300
Capital Outlay - 18,050 - - 56,000 250,000 - 200,000 -
Debt Service 827,088 840,225 847,313 847,313 866,750 864,000 - --
Total Expenditures 1,628,076$ 1,694,908$ 1,849,320$ 1,890,683$ 2,021,297$ 2,194,735$ 1,114,113$ 1,346,182$ 1,180,734$
Surplus (Deficit)105,030$ 116,339$ (62,197)$ 72,229$ (103,919)$ (238,192)$ 21,445$ (178,893)$ 19,541$
Ending Fund Balance 807,221$ 923,559$ 809,496$ 995,788$ 891,869$ 653,677$ 675,122$ 496,229$ 515,770$
49.58%54.49%43.77%52.67%44.12%29.78%60.60%36.86%43.68%
The table and graph below present the Library's funds in aggregate, similar to that of a private business (for illustrative purposes only). All budgeted Library funds are included: Library Operations (82); and Library
Capital (84).
Yorkville Public Library - Consolidated Budget
$0
$500
$1,000
$1,500
ThousandsFund Balance
70