Library Renovation

Renovation Updates

When the plumbers were tying in the sanitary line in the adult area to add the new bathroom they noticed that the line was damaged. After further investigation it was determined that it needed to be replaced all the way out to the street to avoid any future problems. When the concrete was cut out a large portion of the floor sank and became uneven. This was most likely due to the broken sanitary line that probably washed away the subbase underneath the concrete for many years prior. In order to fix this, we will need to remove and replace a fairly large section of approximately 400 square feet of the concrete floor in the adult area.

The below image is a copy of the proposed sidewalk and parking space closure that was approved by the city as the renovation begins on the street facing of the library. Our fencing will be blocking the sidewalk and entrance to the front of the library. This will start sometime the week of 1-16-23 and last for 3-4 weeks. The contractors will be periodically closing off the parking spots right in front of the work area. These spots will be closed during working hours only. They will move the fencing back in the evening when the workday ends.

Admin/Accounting Current Month

Chart of Accounts Restructure

• Adding additional accounts to separate program activity from renovations on the vertical axis to provide clarity on the P&L.

• Restructuring programs and funders under 3 main categories

• Determining types of revenue upon receipt to help with future audits

• All forms are complete and distributed including governmental filings.

Revenue Recognition Accuracy

1099s and W-2s

Records Retention

None to report

Building and Grounds

• Renovation in progress

Website and Technology

• The library experienced an internet and phone outage beginning at approximately 3:00pm on 01/19 (Thursday) and lasted until 9:30am on 01/20 (Friday). The construction crew severed a Comcast cable that was buried. The construction crew temporarily repaired the cable on Friday morning, resuming the library’s internet and phone access. Comcast arrived on 01/21 (Saturday) to make a permanent repair. The staff was able to check-in and checkout materials using wireless hotspots.

• In the month December, the total number of client connections for the wireless patron network was 2624, for a daily average of 85 client connections. This was a decrease from the daily average of 97 for November. The total wireless data delivered in December (31 days) was 397.89GB, a decrease from the November (30 days) total of 468.29GB.

Communications

• Received and addressed a FOIA request related to the construction project.

Personnel/Professional Development

None to report

Grant Update

Grant awards were received from:

Funder Name Amount Prior Status Relationship

with Funder

D&R Legacy Fund $25,000 Existing Funder Awarded

Vivo Foundation $25,000 New Funder Awarded

Modestus Bauer Foundation $5,000 Existing Funder Awarded Morrison Family Foundation $2,000 Existing funder Awarded William W. and Janet S. Boyd $2,000 Existing funder- Awarded Fund.

$7,250.00 in individual donations were also received.

Patron Services—Adults Program (Updates from Diana A. Janet, Yuliya, Aurora)

GED

• We concluded the Science section this month. This was the hardest subject for all students. Some of them are hesitant to schedule their exam. Two students have successfully passed their exam and there are two students who plan on scheduling their exam in January.

Aitana waiting for her mom to finish the Science Test (Mom passed the test)

ESL

• This month with the end of the cycle, festivities, and the weather, we continued to see low attendance in some classes.

• This month we have been connecting with students to complete a speaking post assessment.

• We have 5 participants making significant growth: 37-62%. This growth has been made in the span of 10 weeks or less.

Currently, at the end of this 10-week cycle…

• The last day of class was December 5. We had a potluck. Participants brought their favorite dish to share. We played Bingo, in Spanish and they had the opportunity to meet other members of the program by interviewing each with the worksheet “Find someone who” (all in Spanish).

• Our world is increasingly connected digitally. Digital literacy is possessing skills needed to live, learn, and work in our society where much of our communication and information are offered via the internet, social media, and mobile devices. This course provides students with the opportunities to explore, experiment, and develop expertise using real world applications that prepares them to be more knowledgeable and digitally connected. This class will be offered in both languages.

• We had a wonderful end to the session. Participants had a potluck, they brought chicken, pasta, salad, and many sweets.

• Before the potluck, they gathered to price the items they sold the following day at the Unitarian Church’s Fair Trade. One of the participants made a nice inventory with prices and was prepared for the sale.

Digital Literacy

Sewing Basics Class/Knitters

US Citizenship Test Prep

• We had an excellent month full of good news, positive feedback and lots of support.

• We have a NEW CITIZEN!!!

• One of our participants joined our program as soon as we opened it. He was waiting for this appointment and knew he had to be diligent. He met with our tutor once a week for one hour. He was prepared by the time he received his appointment and passed the exam.

• We currently have 11 participants in this program, each working at their own pace. We are grateful to have such a wonderful team of volunteers.

The pictures below show our tutors working with their students.

They meet once a week for one hour. Each meet at different times and places.

Health Equity - Program updates from Yenny and her team)

Counseling sessions

• One of Monica’s male clients shared that he never thought therapy could feel so life changing. He described his therapy sessions as his personal safe space. He added “I’ve realized that ever since I started coming I am more aware of my feelings and can manage them better. I am more in control”

• This month the support group focused on forgiveness, reflection on growth throughout the year and especially since participating in this group. Participants planned on what they would like to work on individually and in the group for the coming year

• This month our case management team assisted over 30 community

Adult Support Group

Case Management:

members with a variety of needs that included Medicaid applications, scheduling therapy and medical appointments, housing and more.

This resource continues to be of great need.

Charlas Con Propósito:

• Community members learned information about essential vitamins to include in their daily life to help maintain and improve their health.

• Community members played COVID Loteria/Latin American BINGO. As holiday gatherings were approaching, it was important to engage people in creative and fun ways to refresh information on how to gather around their loved ones in a safely manner to prevent COVID infection.

• Community members increased their awareness on lung cancer where they learned common signs, risks, prevention and treatment.

• Our invited guest speaker from Equal Hope presented on cervical cancer. The presentation covered signs, symptoms, prevention and resources for treatment. One participant felt empowered to share her survivor experience to encourage other to seek and schedule preventative screenings.

• Only two sessions held in the month of December due to the holidays. Community members continue to respond positively to this program.

• Rosalind Franklin University provided physical screenings and vaccinations to over 30 community members who would otherwise not have access to this resource.

Zumba

Physical Screenings:

Medicaid Applications

• Event was canceled due to weather alert. 12/22

• One woman shared “I had a massive headache at the beginning of this meditation and now that I’m leaving I don’t feel it anymore. I feel much better”.

• FB Live: Seasonal Depression talked about tips to prevent the effects of this type of depression.

• Conflict Resolution In this this interactive workshop, people learned to reflect on interpersonal conflicts, learn how to identify them, and manage them in a healthy way

• Communication within the Family During our workshop, people learned about the different types of communication and their importance in promoting harmonious relationships within the family.

• Guest speaker: Gaby Leyva shared critical information on coping with grief and loss.

• The team also worked on identifying and lining up key speakers for the first quarter on 2023.

Paz y Calma: Guided meditations the 2nd and 3rd Wednesday of the month from 6:30pm-7:30pm

Sanando El Alma En Comunidad/ Healing the Soul in Community: focused on providing mental health awareness and fostering healing through open conversation every Tuesday.

Caminando Juntos takes place on Facebook Live every first Monday of the month

Illinois Libraries Present

A Conversation with Caitlin Doughty

• These virtual programs are popular among neighboring libraries, but we have received low registration. With the move it’s been difficult to focus on promotion, and we’ll work to increase promotion for the January event.

Patron Services – Elementary Children (Program updates from Alice and Diana)

On-going Children’s Programming Preschool Storytime.

• Attendance was lower in December due to the holidays, but many of our regular families did return for at least one of the sessions! We hope to have everyone back in the same space at the same time in January, as all of our participants have been loving moving and grooving.

• We’ve been working to make Preschool Storytime even more interactive, incorporating felt-boards, a learning cube, and magnet tiles. In January we will be focusing on community outreach to grow the program in the new year.

• In December we focused on books and crafts that celebrated the Winter season. We had a great turnout on December 3rd and families loved the Holiday sweater ornament craft. Though our December

Storytime & Craft

17th Storytime & Craft had lower attendance due to the holidays, it was such a fun day.

• The children, who attended with their moms, were around the same age and the families had the opportunity to get to know each other and stayed to talk and play after the craft had ended. This was a great opportunity for Alice and Diana to get to know the families even better as well.

• Pajama Storytime continues to be offered in our mini-library space. Because this is one of our more popular programs, we will be offering two sessions of this storytime in January - Monday and Wednesday evenings. We will be requiring registration, so as to not overwhelm the limited physical space that we have in the mini-library, and will be assigning different age ranges for those dates, so that crafts can be geared towards kids’ skill levels.

Pajama Storytime

1. Reading Buddies Nights

   • This was our second session at Oak Terrace. It is always wonderful to see young readers, especially those who are otherwise hesitant about reading, excited and motivated to read aloud.

   • Winter Fest was a giant success! Alice, Diana, and Elizabeth dressed as characters from Frozen, read two Frozen storybooks, offered winter-themed crafts, and took photos with the kids attending. The Brushwood Center was also in attendance to lead kids through recycled ornaments and card-making.

   • Our Health Equity team gave out hams, presents, and gifts cards which had been donated to us to provide to the community. Because we are under construction and this is one of our larger community events, we rented the gym and lobby of the Rec Center, and the event location worked out really well – we look forward to utilizing that space for our next big event!

Winter Kids Celebration

Patron Services—Teen (Program Updates from Elizabeth, Alice and Diana)

Learning Partners

• Diana and Elizabeth attended sessions during a week of October for the semester’s assessment. All of our tutors are working wonderfully with their students. We are still actively pairing students with tutors as they apply and there are still students on our waitlist.

• For our first meeting of the month, one of our TAB members presented a proposal they had developed with Alice on an

Teen Advisory Board

LGBTQIA+ program at the library. TAB provided their input on the proposal. They are also very excited about the idea of a Dungeons &

Dragons group. We wrapped up the session by playing several rounds of the card game Pit.

• In December our Teen Advisory Board members had the opportunity to volunteer at our Winter Fest! We had a great volunteer turnout. Volunteers helped us with set-up, each of our 4 craft tables, and assisted the Brushwood Center with their table

• This month, we created “trolls.”

• Rescheduled; spill zone

• Winter holidays and rampant sickness among the kids put a pause on many sessions but some of our tutors continued to adapt and several offered virtual meetings in lieu of in-person. We connected several tutors with online resources, demonstrating the options they have as they adjusted to virtual sessions.

• We hosted a video game tournament in our mini-library space. Teens dueled each other in a variety of Switch Sports in a series of brackets. Teens enjoyed snacking on pizza, watched their friends duel one another, and played card games while waiting for their turn. In a surprise turn of events, Diana and Alice were the semi-finalists and Diana won the tournament.

Craft Cafe

Book Buffet

Homework Help

Teen After Hours

Board meeting open items

None to report

Other updates

The Friends of the Highwood Public Library

Committees continue to work on fundraising and membership drive.

10100 ꞏ Petty Cash/Cash On Hand

50.00

50.00

0.00

0.0%

10110 ꞏ Gift Cards on Hand

169.44

25.38

144.06

567.6%

10120 ꞏ Paypal

37.86

18.93

18.93

100.0%

10201 ꞏ BOH General Fund Chk. (3563)

230,859.99

214,556.23

16,303.76

7.6%

10203 ꞏ BOH General Fund Money Market

553,140.21

707,055.82

-153,915.61

-21.8%

10206 ꞏ BOH Payroll Acct. Chk. (0133)

22,370.73

11,163.12

11,207.61

100.4%

10216 ꞏ IMET Capital Impr. Fund (8102)

3,728.31

3,715.94

12.37

0.3%

10221 ꞏ IMET Reserve Fund (8101)

20,449.77

20,381.95

67.82

0.3%

10240 ꞏ BOH Convenience Fund Chk (2208)

2,762.08

3,036.99

-274.91

-9.1%

10250 ꞏ BOH Building Renovation Account

10,000.00

10,000.00

0.00

0.0%

10251 ꞏ BOH Building Reno. Money Market

1,346,624.19

1,436,445.66

-89,821.47

-6.3%

Total 10000 ꞏ CASH & INVESTMENT ACCOUNTS

2,190,192.58

2,406,450.02

-216,257.44

-9.0%

Total Checking/Savings

2,190,192.58

2,406,450.02

-216,257.44

-9.0%

Other Current Assets

13500 ꞏ Other Receivables

1,552.63

1,552.63

0.00

0.0%

14500 ꞏ Property Tax Receivable

292,500.41

292,500.41

0.00

0.0%

14600 ꞏ Due from Primary Government

1,588.89

1,588.89

0.00

0.0%

Total Other Current Assets

295,641.93

295,641.93

0.00

0.0%

Total Current Assets

2,485,834.51

2,702,091.95

-216,257.44

-8.0%

TOTAL ASSETS

2,485,834.51

2,702,091.95

-216,257.44

-8.0%

LIABILITIES & EQUITY

Liabilities

Current Liabilities Accounts Payable

20000 ꞏ Accounts Payable

19,242.34

2,557.78

16,684.56

652.3%

Total Accounts Payable

19,242.34

2,557.78

16,684.56

652.3%

Other Current Liabilities

22000 ꞏ Payroll Liabilities 22100 ꞏ IMRF W/H Payable

9,669.05

8,357.96

1,311.09

15.7%

22101 ꞏ Insurance Payable

5,958.88

6,604.99

-646.11

-9.8%

22102 ꞏ Payroll Tax Liability

2,473.71

0.00

2,473.71

100.0%

22000 ꞏ Payroll Liabilities - Other

305.07

305.07

0.00

0.0%

Total 22000 ꞏ Payroll Liabilities

18,406.71

15,268.02

3,138.69

20.6%

24000 ꞏ Deferred Property Taxes

292,500.41

292,500.41

0.00

0.0%

24300 ꞏ Deferred Revenue

-443,506.00

-443,506.00

0.00

0.0%

Total Other Current Liabilities

-132,598.88

-135,737.57

3,138.69

2.3%

Total Current Liabilities

-113,356.54

-133,179.79

19,823.25

14.9%

Total Liabilities

-113,356.54

-133,179.79

19,823.25

14.9%

Equity

32000 ꞏ Unrestricted Net Assets

1,749,369.86

1,749,369.86

0.00

0.0%

Net Income

849,821.19

1,085,901.88

-236,080.69

-21.7%

Total Equity

2,599,191.05

2,835,271.74

-236,080.69

-8.3%

TOTAL LIABILITIES & EQUITY

2,485,834.51

2,702,091.95

-216,257.44

-8.0%

41100 ꞏ Tax Revenue - Lake County

289,087.57

292,500.00

-3,412.43

98.8%

41200 ꞏ Tax Revenue - PPRT

0.00

2,500.00

-2,500.00

0.0%

41300 ꞏ Grants

41300.1 ꞏ Per Capita Grant

0.00

7,000.00

-7,000.00

0.0%

41310 ꞏ Unrestricted Grants

11,601.00

14,470.00

-2,869.00

80.2%

41320 ꞏ Temp. Restricted Grant Programs

1,246,311.73

982,570.00

263,741.73

126.8%

41330 ꞏ Temp. Restricted Grant- Bldg

4,873.29

2,681,474.06

-2,676,600.77

0.2%

Total 41300 ꞏ Grants

1,262,786.02

3,685,514.06

-2,422,728.04

34.3%

41400 ꞏ Interest & Dividends

1,072.28

40.00

1,032.28

2,680.7%

Total 41000 ꞏ GENERAL REVENUES

1,552,945.87

3,980,554.06

-2,427,608.19

39.0%

42000 ꞏ OPERATING REVENUES

42100 ꞏ Fines, Fees & Damaged Materials

63.45

800.00

-736.55

7.9%

42300 ꞏ Book Sales

419.59

0.00

419.59

100.0%

42400 ꞏ Cookbook Sales

140.00

0.00

140.00

100.0%

42600 ꞏ Photocopier

1,206.52

1,800.00

-593.48

67.0%

42900 ꞏ Gifts & Donations

42900.1 ꞏ General Gifts & Donations

3,269.65

2,500.00

769.65

130.8%

42900.2 ꞏ Friends of the Library

5,000.00

24,000.00

-19,000.00

20.8%

42900.3 ꞏ Renovation Donations

300,000.00

0.00

300,000.00

100.0%

Total 42900 ꞏ Gifts & Donations

308,269.65

26,500.00

281,769.65

1,163.3%

Total 42000 ꞏ OPERATING REVENUES

310,099.21

29,100.00

280,999.21

1,065.6%

Total Income

1,863,045.08

4,009,654.06

-2,146,608.98

46.5%

Expense

51000 ꞏ PERSONNEL & BENEFITS

51100 ꞏ Wages & Salaries

127,037.53

199,054.00

-72,016.47

63.8%

51110 ꞏ Bonuses

11,843.99

11,500.00

343.99

103.0%

51115 ꞏ IMRF Expense

9,043.13

18,440.11

-9,396.98

49.0%

51120 ꞏ Medical/Health Insurance

7,623.06

12,879.22

-5,256.16

59.2%

51130 ꞏ Life Insurance

120.75

1,774.08

-1,653.33

6.8%

51140 ꞏ Employer FICA

10,895.95

15,227.63

-4,331.68

71.6%

51200 ꞏ Unemployment Expense

162.31

0.00

162.31

100.0%

51999 ꞏ Payroll Processing Fees

1,033.42

1,689.00

-655.58

61.2%

Total 51000 ꞏ PERSONNEL & BENEFITS

167,760.14

260,564.04

-92,803.90

64.4%

52000 ꞏ LIBRARY MATERIALS & SUPPLIES

52100 ꞏ Books, Fiction

52100.1 ꞏ Books F - Adult

2,645.16

3,500.00

-854.84

75.6%

52100.2 ꞏ Books F - Children/Juvenile

1,137.97

1,500.00

-362.03

75.9%

52100.3 ꞏ Books F - Young Adult

577.25

1,265.00

-687.75

45.6%

52100.4 ꞏ Books F - Spanish Adult

145.24

750.00

-604.76

19.4%

52100.5 ꞏ Books F - Spanish Chld./Juv.

590.42

1,500.00

-909.58

39.4%

Total 52100 ꞏ Books, Fiction

5,096.04

8,515.00

-3,418.96

59.8%

52150 ꞏ Books, Non-Fiction

52150.1 ꞏ Books NF - Adult

790.95

2,000.00

-1,209.05

39.5%

52150.2 ꞏ Books NF - Children/Juvenile

1,520.09

2,000.00

-479.91

76.0%

52150.4 ꞏ Books NF - Spanish

245.47

1,000.00

-754.53

24.5%

Total 52150 ꞏ Books, Non-Fiction

2,556.51

5,000.00

-2,443.49

51.1%

52200 ꞏ A/V Materials

52200.1 ꞏ A/V - Adult

782.42

1,800.00

-1,017.58

43.5%

52200.2 ꞏ A/V - Children/Juvenile

289.38

1,000.00

-710.62

28.9%

52200.6 ꞏ A/V Games

0.00

800.00

-800.00

0.0%

Total 52200 ꞏ A/V Materials

1,071.80

3,600.00

-2,528.20

29.8%

52350 ꞏ On-Line Resources

May - Dec 22

Budget

$ Over Budget

% of Budget

52350.3 ꞏ On-Line - Hoopla

463.34

1,200.00

-736.66

38.6%

52350.4 ꞏ On-Line - eRead

478.00

575.00

-97.00

83.1%

Total 52350 ꞏ On-Line Resources

941.34

1,775.00

-833.66

53.0%

52400 ꞏ Periodicals

52400.1 ꞏ Periodicals - Adult

3,891.25

3,500.00

391.25

111.2%

52400.3 ꞏ Periodicals - Subscription Svc

678.65

900.00

-221.35

75.4%

Total 52400 ꞏ Periodicals

4,569.90

4,400.00

169.90

103.9%

52600 ꞏ Book Standing Orders

52600.2 ꞏ Book SO - Children/Juvenile

1,750.00

1,750.00

0.00

100.0%

Total 52600 ꞏ Book Standing Orders

1,750.00

1,750.00

0.00

100.0%

52650 ꞏ Processing Supplies

906.16

800.00

106.16

113.3%

Total 52000 ꞏ LIBRARY MATERIALS & SUPPLIES

16,891.75

25,840.00

-8,948.25

65.4%

53000 ꞏ PROGRAMMING

53100 ꞏ Library Program Facilitators

53100.2 ꞏ Program Fac- Young Adult

0.00

600.00

-600.00

0.0%

53100.3 ꞏ Program Fac- Child

0.00

2,000.00

-2,000.00

0.0%

Total 53100 ꞏ Library Program Facilitators

0.00

2,600.00

-2,600.00

0.0%

53200 ꞏ Program Supplies

53200.1 ꞏ Prog. Suppl. - Adult

761.42

1,000.00

-238.58

76.1%

53200.2 ꞏ Prog. Suppl. - Children

1,056.91

2,600.00

-1,543.09

40.7%

53200.3 ꞏ Prog. Suppl. - Young Adult

99.89

1,000.00

-900.11

10.0%

Total 53200 ꞏ Program Supplies

1,918.22

4,600.00

-2,681.78

41.7%

Total 53000 ꞏ PROGRAMMING

1,918.22

7,200.00

-5,281.78

26.6%

54000 ꞏ GRANT EXPENSES

54110 ꞏ Contracted Services

98,596.00

137,424.00

-38,828.00

71.7%

54115 ꞏ Staff Development

10,268.60

13,575.00

-3,306.40

75.6%

54120 ꞏ Wages & Salaries

424,024.82

634,910.23

-210,885.41

66.8%

54125 ꞏ Bonuses/Overtime

24,725.78

6,004.89

18,720.89

411.8%

54130 ꞏ Employer FICA

32,754.92

48,264.14

-15,509.22

67.9%

54131 ꞏ IMRF Expense

21,030.15

24,675.21

-3,645.06

85.2%

54132 ꞏ Medical/Dental Benefits

37,247.23

73,973.17

-36,725.94

50.4%

54135 ꞏ Grant Program Supplies

17,095.39

29,750.00

-12,654.61

57.5%

54155 ꞏ Travel Reimbursement

309.70

1,800.00

-1,490.30

17.2%

54185 ꞏ Grant Telecommunications

568.24

450.00

118.24

126.3%

54195 ꞏ Training Expense

739.65

3,800.00

-3,060.35

19.5%

54196 ꞏ Liability/Property Insurance

2,840.00

4,000.00

-1,160.00

71.0%

54197 ꞏ Indirect Costs to Operations

6,301.00

0.00

6,301.00

100.0%

Total 54000 ꞏ GRANT EXPENSES

676,501.48

978,626.64

-302,125.16

69.1%

54500 ꞏ Grant Building Renovation Expen

54510 ꞏ Contracted Services

119,456.73

2,681,474.06

-2,562,017.33

4.5%

Total 54500 ꞏ Grant Building Renovation Expen

119,456.73

2,681,474.06

-2,562,017.33

4.5%

55000 ꞏ GENERAL ADMINISTRATION

55100 ꞏ Library Board & Staff Expenses

55100.1 ꞏ Staff Development

996.11

1,200.00

-203.89

83.0%

55100.2 ꞏ Library Board Expense

469.20

600.00

-130.80

78.2%

55100.3 ꞏ Travel Reimbursement

0.00

200.00

-200.00

0.0%

Total 55100 ꞏ Library Board & Staff Expenses

1,465.31

2,000.00

-534.69

73.3%

55200 ꞏ Technology

55200.1 ꞏ Circulation System (ILS)

1,200.00

1,500.00

-300.00

80.0%

55200.2 ꞏ Baker/Taylor TS3 Search System

0.00

1,800.00

-1,800.00

0.0%

55200.3 ꞏ Website

722.50

1,000.00

-277.50

72.3%

55200.5 ꞏ Hardware Purchases

19.91

2,500.00

-2,480.09

0.8%

May - Dec 22

Budget

$ Over Budget

% of Budget

55200.6 ꞏ Software

0.00

800.00

-800.00

0.0%

Total 55200 ꞏ Technology

1,942.41

7,600.00

-5,657.59

25.6%

55300 ꞏ Furniture & Equipment 55300.1 ꞏ Furniture Purchases

0.00

300.00

-300.00

0.0%

55300.2 ꞏ Equipment Leases (Copier)

-291.33

0.00

-291.33

100.0%

55300.3 ꞏ Equipment Purchases

0.00

250.00

-250.00

0.0%

Total 55300 ꞏ Furniture & Equipment

-291.33

550.00

-841.33

-53.0%

55400 ꞏ General Office/Administration 55400.2 ꞏ Office/Library Supplies

5,732.95

6,000.00

-267.05

95.5%

55400.3 ꞏ Membership Dues/Fees

863.27

1,140.00

-276.73

75.7%

55400.4 ꞏ Licensing Fees

962.85

4,221.00

-3,258.15

22.8%

55400.5 ꞏ Postage & Shipping Fees

120.00

700.00

-580.00

17.1%

55400.6 ꞏ Telecommunications/Internet

2,172.30

3,600.00

-1,427.70

60.3%

55400.7 ꞏ Utilities

231.99

600.00

-368.01

38.7%

55400.8 ꞏ Liability/Property Insurance

152.15

3,500.00

-3,347.85

4.3%

55400.9 ꞏ Workers Compensation Insurance

0.00

240.00

-240.00

0.0%

Total 55400 ꞏ General Office/Administration

10,235.51

20,001.00

-9,765.49

51.2%

55500 ꞏ Outreach & Public Relations 55500.2 ꞏ Public Relations - Gen. Library

64.02

1,500.00

-1,435.98

4.3%

55500.3 ꞏ Community Outreach/Relations

0.00

500.00

-500.00

0.0%

55500.7 ꞏ Newsletter

184.00

276.00

-92.00

66.7%

Total 55500 ꞏ Outreach & Public Relations

248.02

2,276.00

-2,027.98

10.9%

55600 ꞏ Bank/Svc. Fees & Fin. Charges 55600.1 ꞏ Wire Transfers

0.00

44.00

-44.00

0.0%

55600.3 ꞏ Other Bank Fees

180.00

150.00

30.00

120.0%

Total 55600 ꞏ Bank/Svc. Fees & Fin. Charges

180.00

194.00

-14.00

92.8%

Total 55000 ꞏ GENERAL ADMINISTRATION

13,779.92

32,621.00

-18,841.08

42.2%

56000 ꞏ PROFESSIONAL/CONTRACT SERVICES

56100 ꞏ Accounting Services

4,455.00

6,250.00

-1,795.00

71.3%

56200 ꞏ Cleaning Services

7,676.00

8,000.00

-324.00

96.0%

56300 ꞏ IT/Computer Services

0.00

6,000.00

-6,000.00

0.0%

56400 ꞏ Legal Services

56500 ꞏ Maintenance Services

56500.1 ꞏ Maintenance Svcs. - Interior

0.00

3,875.65

500.00

2,000.00

-500.00

1,875.65

0.0%

193.8%

56500.2 ꞏ Maintenance Svcs. - Exterior

909.00

125.00

784.00

727.2%

Total 56500 ꞏ Maintenance Services

4,784.65

2,125.00

2,659.65

225.2%

Total 56000 ꞏ PROFESSIONAL/CONTRACT SERVICES

16,915.65

22,875.00

-5,959.35

73.9%

Total Expense

1,013,223.89

4,009,200.74

-2,995,976.85

25.3%

Net Ordinary Income

849,821.19

453.32

849,367.87

187,466.1%

Net Income

849,821.19

453.32

849,367.87

187,466.1%

41100 ꞏ Tax Revenue - Lake County

0.00

6,571.24

-6,571.24

-100.0%

41300 ꞏ Grants

41310 ꞏ Unrestricted Grants

904.50

0.00

904.50

100.0%

41320 ꞏ Temp. Restricted Grant Programs

7,000.00

143,133.10

-136,133.10

-95.1%

41330 ꞏ Temp. Restricted Grant- Bldg

0.00

12,776.00

-12,776.00

-100.0%

Total 41300 ꞏ Grants

7,904.50

155,909.10

-148,004.60

-94.9%

41400 ꞏ Interest & Dividends

328.41

291.61

36.80

12.6%

Total 41000 ꞏ GENERAL REVENUES

8,232.91

162,771.95

-154,539.04

-94.9%

42000 ꞏ OPERATING REVENUES

42300 ꞏ Book Sales

20.00

25.36

-5.36

-21.1%

42400 ꞏ Cookbook Sales

140.00

0.00

140.00

100.0%

42600 ꞏ Photocopier

144.32

230.50

-86.18

-37.4%

42900 ꞏ Gifts & Donations

42900.1 ꞏ General Gifts & Donations

758.93

18.93

740.00

3,909.1%

42900.2 ꞏ Friends of the Library

0.00

0.00

0.00

0.0%

Total 42900 ꞏ Gifts & Donations

758.93

18.93

740.00

3,909.1%

Total 42000 ꞏ OPERATING REVENUES

1,063.25

274.79

788.46

286.9%

Total Income

9,296.16

163,046.74

-153,750.58

-94.3%

Expense

51000 ꞏ PERSONNEL & BENEFITS

51100 ꞏ Wages & Salaries

23,353.90

15,784.95

7,568.95

48.0%

51110 ꞏ Bonuses

1,843.99

0.00

1,843.99

100.0%

51115 ꞏ IMRF Expense

1,456.70

917.52

539.18

58.8%

51120 ꞏ Medical/Health Insurance

2,205.50

0.00

2,205.50

100.0%

51125 ꞏ Dental Insurance

0.00

0.00

0.00

0.0%

51130 ꞏ Life Insurance

34.50

0.00

34.50

100.0%

51135 ꞏ Vision Insurance

0.00

0.00

0.00

0.0%

51140 ꞏ Employer FICA

1,896.38

1,171.62

724.76

61.9%

51999 ꞏ Payroll Processing Fees

149.40

151.00

-1.60

-1.1%

Total 51000 ꞏ PERSONNEL & BENEFITS

30,940.37

18,025.09

12,915.28

71.7%

52000 ꞏ LIBRARY MATERIALS & SUPPLIES

52100 ꞏ Books, Fiction

52100.1 ꞏ Books F - Adult

182.06

139.77

42.29

30.3%

52100.2 ꞏ Books F - Children/Juvenile

320.38

163.26

157.12

96.2%

52100.3 ꞏ Books F - Young Adult

113.26

139.60

-26.34

-18.9%

52100.4 ꞏ Books F - Spanish Adult

16.10

12.37

3.73

30.2%

52100.5 ꞏ Books F - Spanish Chld./Juv.

156.07

143.81

12.26

8.5%

Total 52100 ꞏ Books, Fiction

787.87

598.81

189.06

31.6%

52150 ꞏ Books, Non-Fiction

52150.1 ꞏ Books NF - Adult

49.09

49.93

-0.84

-1.7%

Total 52150 ꞏ Books, Non-Fiction

49.09

49.93

-0.84

-1.7%

52200 ꞏ A/V Materials

52200.1 ꞏ A/V - Adult

490.68

0.00

490.68

100.0%

52200.2 ꞏ A/V - Children/Juvenile

17.96

222.47

-204.51

-91.9%

Total 52200 ꞏ A/V Materials

508.64

222.47

286.17

128.6%

52350 ꞏ On-Line Resources

52350.3 ꞏ On-Line - Hoopla

89.11

90.08

-0.97

-1.1%

Total 52350 ꞏ On-Line Resources

89.11

90.08

-0.97

-1.1%

52400 ꞏ Periodicals

52400.1 ꞏ Periodicals - Adult

259.41

0.00

259.41

100.0%

Dec 22

Nov 22

$ Change

% Change

Total 52400 ꞏ Periodicals

259.41

0.00

259.41

100.0%

52650 ꞏ Processing Supplies

188.67

52.57

136.10

258.9%

Total 52000 ꞏ LIBRARY MATERIALS & SUPPLIES

1,882.79

1,013.86

868.93

85.7%

53000 ꞏ PROGRAMMING

53200 ꞏ Program Supplies

53200.1 ꞏ Prog. Suppl. - Adult

-109.43

150.00

-259.43

-173.0%

53200.2 ꞏ Prog. Suppl. - Children

44.98

0.00

44.98

100.0%

53200.3 ꞏ Prog. Suppl. - Young Adult

0.00

20.00

-20.00

-100.0%

Total 53200 ꞏ Program Supplies

-64.45

170.00

-234.45

-137.9%

Total 53000 ꞏ PROGRAMMING

-64.45

170.00

-234.45

-137.9%

54000 ꞏ GRANT EXPENSES

54110 ꞏ Contracted Services

17,956.00

17,309.00

647.00

3.7%

54115 ꞏ Staff Development

133.18

0.00

133.18

100.0%

54120 ꞏ Wages & Salaries

79,223.40

54,411.17

24,812.23

45.6%

54125 ꞏ Bonuses/Overtime

0.00

18,720.89

-18,720.89

-100.0%

54130 ꞏ Employer FICA

5,849.36

5,468.90

380.46

7.0%

54131 ꞏ IMRF Expense

3,593.27

3,427.12

166.15

4.9%

54132 ꞏ Medical/Dental Benefits

11,853.80

0.00

11,853.80

100.0%

54135 ꞏ Grant Program Supplies

1,568.56

2,995.73

-1,427.17

-47.6%

54155 ꞏ Travel Reimbursement

0.00

45.00

-45.00

-100.0%

54185 ꞏ Grant Telecommunications

157.64

203.22

-45.58

-22.4%

54197 ꞏ Indirect Costs to Operations

904.50

0.00

904.50

100.0%

Total 54000 ꞏ GRANT EXPENSES

121,239.71

102,581.03

18,658.68

18.2%

54500 ꞏ Grant Building Renovation Expen

54510 ꞏ Contracted Services

88,862.00

0.00

88,862.00

100.0%

Total 54500 ꞏ Grant Building Renovation Expen

88,862.00

0.00

88,862.00

100.0%

55000 ꞏ GENERAL ADMINISTRATION

55100 ꞏ Library Board & Staff Expenses

55100.1 ꞏ Staff Development

444.81

0.00

444.81

100.0%

Total 55100 ꞏ Library Board & Staff Expenses

444.81

0.00

444.81

100.0%

55400 ꞏ General Office/Administration

55400.2 ꞏ Office/Library Supplies

506.71

1,980.32

-1,473.61

-74.4%

55400.4 ꞏ Licensing Fees

100.00

161.90

-61.90

-38.2%

55400.6 ꞏ Telecommunications/Internet

241.46

241.46

0.00

0.0%

Total 55400 ꞏ General Office/Administration

848.17

2,383.68

-1,535.51

-64.4%

55500 ꞏ Outreach & Public Relations

55500.2 ꞏ Public Relations - Gen. Library

0.00

64.02

-64.02

-100.0%

55500.7 ꞏ Newsletter

23.00

23.00

0.00

0.0%

Total 55500 ꞏ Outreach & Public Relations

23.00

87.02

-64.02

-73.6%

55600 ꞏ Bank/Svc. Fees & Fin. Charges

55600.3 ꞏ Other Bank Fees

60.00

60.00

0.00

0.0%

55600 ꞏ Bank/Svc. Fees & Fin. Charges - Other

-14.70

14.70

-29.40

-200.0%

Total 55600 ꞏ Bank/Svc. Fees & Fin. Charges

45.30

74.70

-29.40

-39.4%

Total 55000 ꞏ GENERAL ADMINISTRATION

1,361.28

2,545.40

-1,184.12

-46.5%

56000 ꞏ PROFESSIONAL/CONTRACT SERVICES

56200 ꞏ Cleaning Services

912.00

912.00

0.00

0.0%

56500 ꞏ Maintenance Services

56500.1 ꞏ Maintenance Svcs. - Interior

243.15

103.42

139.73

135.1%

56500.2 ꞏ Maintenance Svcs. - Exterior

0.00

57.00

-57.00

-100.0%

Total 56500 ꞏ Maintenance Services

243.15

160.42

82.73

51.6%

Total 56000 ꞏ PROFESSIONAL/CONTRACT SERVICES

1,155.15

1,072.42

82.73

7.7%

Dec 22

Nov 22

$ Change

% Change

Total Expense

245,376.85

125,407.80

119,969.05

95.7%

Net Ordinary Income

-236,080.69

37,638.94

-273,719.63

-727.2%

Net Income

-236,080.69

37,638.94

-273,719.63

-727.2%

Type

Num

Date

Name

Memo

Account

Original Amount

Bill Pmt -Check

DD

12/30/2022

Aldi

10240 ꞏ BOH Convenience Fund Chk (2208)

-39.39

Bill

11302022

11/30/2022

NorthShore University HealthSystem

Charlas Supplies

54135 ꞏ Grant Program Supplies

26.95

Bill

12282022

12/28/2022

NorthShore University HealthSystem

Charlas Supplies

54135 ꞏ Grant Program Supplies

12.44

TOTAL

39.39

Bill Pmt -Check

DD

12/30/2022

Amazon.com

10240 ꞏ BOH Convenience Fund Chk (2208)

-1,436.80

Bill

11272970914121858-2

12/01/2022

Storage Cubes for Mini Library

55400.2 ꞏ Office/Library Supplies

36.99

Bill

11472614438553835

12/02/2022

Winterfest Book

52100.2 ꞏ Books F - Children/Juvenile

7.67

Processing Supplies

52650 ꞏ Processing Supplies

4.82

Bill

11443721041663441

12/04/2022

Magnets

55400.2 ꞏ Office/Library Supplies

10.99

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

11.99

Hand Vacuum

53200.2 ꞏ Prog. Suppl. - Children

44.98

Bill

11498345933239409

12/05/2022

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

26.98

Bill

11402532294499472

12/05/2022

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

80.16

Bill

11499569696025847

12/05/2022

Winterfest Book

52100.2 ꞏ Books F - Children/Juvenile

15.79

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

126.59

Bill

11346075200205828

12/06/2022

The Grainger Foundation Grant

Craft Supplies

54135 ꞏ Grant Program Supplies

6.99

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

6.78

Bill

11307861194331446

12/07/2022

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

27.80

Seat Cushion

55400.2 ꞏ Office/Library Supplies

35.16

Bill

11197118974025834

12/09/2022

IL State Library PNG

Makerspace

54135 ꞏ Grant Program Supplies

173.70

Bill

11397102132530641

12/12/2022

Rubberbands for Newspaper Rack

55400.2 ꞏ Office/Library Supplies

7.97

Bill

11355790140863403-2

12/12/2022

A/V - Children/Juvenile

52200.2 ꞏ A/V - Children/Juvenile

17.96

Bill

11352311128541044

12/12/2022

Adult Literacy Supplies

53200.1 ꞏ Prog. Suppl. - Adult

25.57

Chair Glides

55400.2 ꞏ Office/Library Supplies

98.40

Bill

11373052885009033

12/18/2022

Adult DVDs August-December

52200.1 ꞏ A/V - Adult

375.14

Bill

11305112149283430

12/19/2022

Adult DVDs August-December

52200.1 ꞏ A/V - Adult

17.96

Bill

11349332840792220

12/27/2022

Adult DVDs August-December

52200.1 ꞏ A/V - Adult

14.96

Bill

11338021007489860

12/29/2022

Books F - Adult

52100.1 ꞏ Books F - Adult

44.20

Bill

11196300980226638

12/29/2022

The Grainger Foundation Grant

Teen After Hours Supplies

54135 ꞏ Grant Program Supplies

7.83

Bill

11317141132051421

12/29/2022

Good Reads Best of 2022

52100.1 ꞏ Books F - Adult

37.98

Bill

11373072973455438

12/30/2022

Adult DVDs August-December

52200.1 ꞏ A/V - Adult

82.62

Bill

11195127973218631

12/30/2022

IL State Library PNG

Makerspace Supplies

54135 ꞏ Grant Program Supplies

23.98

The Grainger Foundation Grant

Teen After Hours Supplies

54135 ꞏ Grant Program Supplies

54.85

Bill

11198142529292214

12/28/2022

The Grainger Foundation Grant

Teen After Hours Supplies

54135 ꞏ Grant Program Supplies

9.99

TOTAL

1,436.80

Bill Pmt -Check

DD

12/30/2022

Canva

Subscription Fee for ?

10240 ꞏ BOH Convenience Fund Chk (2208)

-91.07

Bill

03649-28221536

12/29/2022

Julian Grace Foundation

Subscription Tier Increase for Additional Members

54135 ꞏ Grant Program Supplies

91.07

TOTAL

91.07

Type

Num

Date

Name

Memo

Account

Original Amount

Bill Pmt -Check

DD

12/30/2022

Chicago Tribune

Lake County News Sun 12/01/22-01/31/23

10240 ꞏ BOH Convenience Fund Chk (2208)

-109.44

Bill

12202022

12/20/2022

Lake County News Sun 12/07/22-01/31/23

52400.1 ꞏ Periodicals - Adult

109.44

TOTAL

109.44

Bill Pmt -Check

DD

12/30/2022

Domino's Pizza

10240 ꞏ BOH Convenience Fund Chk (2208)

-122.29

Bill

12092022

12/09/2022

The Grainger Foundation Grant

Teen After Hours Supplies

54135 ꞏ Grant Program Supplies

67.39

Bill

12102022

12/10/2022

The Grainger Foundation Grant

Winterfest Supplies

54135 ꞏ Grant Program Supplies

54.90

TOTAL

122.29

Bill Pmt -Check

DD

12/30/2022

Google

10240 ꞏ BOH Convenience Fund Chk (2208)

-200.23

Bill

4623928198

11/30/2022

NorthShore University HealthSystem

Google Telecom for November

54185 ꞏ Grant Telecommunications

38.33

Bill

4614598921

11/30/2022

Google Workspace for November

55400.4 ꞏ Licensing Fees

161.90

TOTAL

200.23

Bill Pmt -Check

DD

12/30/2022

Jewel

10240 ꞏ BOH Convenience Fund Chk (2208)

-36.90

Bill

12142022

12/14/2022

NorthShore University HealthSystem

Charlas Supplies

54135 ꞏ Grant Program Supplies

16.19

Bill

12212022

12/21/2022

NorthShore University HealthSystem

Charlas Supplies

54135 ꞏ Grant Program Supplies

20.71

TOTAL

36.90

Bill Pmt -Check

DD

12/30/2022

La Union Supermarket

Charlas Supplies

10240 ꞏ BOH Convenience Fund Chk (2208)

-21.77

Bill

12072022

12/07/2022

NorthShore University HealthSystem

Charlas Supplies

54135 ꞏ Grant Program Supplies

21.77

TOTAL