Glen Ellyn Public Library

Financial & Operations Dashboard

January 2025 – Present · Data extracted from monthly board packets · Generated 2026-03-13

Monthly Spend

$296,301

Mar 2026, all funds

Total Fund Balance

$4.6M

Feb 2026 · -18.5% since Jan 2025

Budget Pace

25%

Expected · 0 categories over

Data Coverage

15 months

Expenditures through Mar 2026

Financial Overview

Monthly spending steady through the fiscal year transition

Total expenditures by fund · Jan 2025–Mar 2026

Operating Fund (10) Special Revenue Fund (99)

Source: Statement of Expenditures, monthly board packets

Three months in: spending tracks close to budget pace

YTD spending as % of annual budget · Top categories · FY2026

Source: Statement of Expenditures, Mar 2026 board packet

Revenue

Property tax collections drive revenue timing

Aggregate property tax revenue (all levies) · monthly

Source: Statement of Revenues, monthly board packets

Other revenue sources: café and passport services lead

Selected non-tax revenue streams · monthly

Café

—

Passport Services

—

Investment Income

—

Non-Resident Cards

—

Makerspace

—

Lost Books / Fines

—

Charging Station

—

Source: Statement of Revenues, monthly board packets

Balance Sheet

Total fund balance: $4.6M (-18.5% since Jan 2025)

Combined balance across all funds

Source: Balance Sheet, monthly board packets

Fund balance breakdown by type

Stacked area · individual fund balances

Source: Balance Sheet, monthly board packets

Library Operations

Key operational metrics at a glance

Monthly trends from statistical reports · 52 metrics across 8 categories

Visits & Access

Visits to the Library

—

Drive-Up Window

—

Locker Deliveries

—

Registered Cardholders

—

Public Computer Sessions

—

WiFi Devices Connected

—

Flight Simulator

—

The Studio

—

Circulation

Loans of Material

—

Print Materials

—

Nonprint Materials

—

Adult Materials

—

Youth Materials

—

Young Adult Materials

—

E-Materials (Circulation)

—

Reciprocal Borrowing

—

ILL / Reserves Received

—

ILL Sent

—

Holds & Sharing

Holds Placed

—

Holds Filled

—

SWAN Items Sent

—

SWAN Items Received

—

Reference

Reference Inquiries (Total)

—

Adult Dept Reference

—

Youth Dept Reference

—

Library Services Reference

—

Makerspace Inquiries

—

Digital

Adult Database Usage

—

Youth Database Usage

—

Website Page Views

—

Programs

Program Attendance (Total)

—

Adult Programs

—

Youth Programs

—

Young Adult Programs

—

Passive Programs

—

Outreach

—

Makerspace Usage

—

Spaces & Operations

Meeting Room Uses

—

Study Room Usage

—

Professional Development

—

Home Deliveries

—

Volunteer Hours

—

Collections

Materials Collections (Total)

—

Adult/Teen Print

—

Adult/Teen Nonprint

—

Youth Print

—

Youth Nonprint

—

E-Materials (Collections)

—

Items Added

—

Items Withdrawn

—

Source: Statistical Reports (Pt. IV), monthly board packets

Methodology

Data sources: All figures are extracted programmatically from the monthly board packet PDFs (Statement of Expenditures, Statement of Revenues, Balance Sheet, and Statistical Report) filed with the Board of Trustees.

Extraction: PDF text is parsed using pdftotext with layout preservation, then structured into CSV format via regex-based extraction. Each extracted value is traceable to its source document and GL code.

Validation: Extracted totals are cross-checked against fund subtotals (Operating + Special Revenue = Total Expense). Individual figures have been verified against the March 2026 monthly financial review.

Update frequency: Regenerated when new board packets are available (monthly). Last generated: 2026-03-13.

Coverage: Financial data: Jan 2025 – Mar 2026 (15 months). Revenue: 14 months. Balance sheet: 14 months. Statistical: 13 months.