HomeMy WebLinkAbout2023.09 September Monthly Report
To: Luke Stowe, City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: September 2023 Monthly Financial Report
Date: October 27, 2023
Please find attached the unaudited financial statements as of September 30, 2023. A summary by fund for revenues, expenditures, fund, and
cash balances is as follows:
City of Evanston
Cash & Investment Summary by Fund
September 30, 2023
Fund #Fund Revenue Expense Net Fund Balance Cash Balance
100 General 94,156,050 98,985,554 (4,829,504) 52,972,981 50,037,395
170 American Rescue Plan 1,064,973 4,649,646 (3,584,673) (3,053,503) 27,660,830
175 General Assistance 778,047 788,729 (10,682) 975,704 975,706
176 Human Services 1,971,985 3,106,214 (1,134,229) 1,929,832 1,929,706
177 Reparations 2,883,336 1,206,254 1,677,083 1,925,619 1,925,619
178 Sustainability 570,999 327,443 243,556 628,148 628,149
180 Good Neighbor 11,395 525,178 (513,783) 219,630 219,629
185 Library 4,856,786 5,781,899 (925,113) 3,085,493 3,085,416
186 Library Debt Service 253,956 116,092 137,865 140,647 140,647
187 Library Capital Improvement FD - 512,176 (512,176) 192,213 192,213
200 MFT 2,667,526 2,395,870 271,656 5,729,622 5,424,756
205 E911 990,388 971,716 18,672 1,503,040 1,136,039
210 Special Service Area (SSA) #9 563,162 316,021 247,140 47,153 47,154
215 CDBG 657,172 869,568 (212,396) (153,073) (153,073)
220 CD Loan 117,104 44,609 72,495 451,744 451,744
235 Neighborhood Improvement 451 8 443 22,738 22,738
240 Home 58,406 62,988 (4,582) 2,270 2,271
250 Affordable Housing 452,549 302,205 150,344 2,752,707 2,900,941
320 Debt Service 9,361,545 2,612,855 6,748,690 8,714,500 9,271,210
330 Howard Ridge 747,033 1,366,258 (619,225) 1,485,869 1,477,123
335 West Evanston 912,916 707,974 204,942 2,668,939 2,668,939
340 Dempster-Dodge-TIF 136,005 138,623 (2,618) 370,394 370,394
345 Chicago Main-TIF 722,008 357,817 364,191 2,057,869 2,057,869
350 Special Service Area (SSA) #6 132,943 117,505 15,437 19,992 241,855
355 Special Service Area (SSA) #7 78,651 77,112 1,540 13,976 13,975
360 Special Service Area (SSA) #8 35,410 31,505 3,904 8,433 8,432
365 Five-Fifth TIF 719,286 (719,286) (855,187) (855,187)
415 Capital Improvements 3,872,113 6,649,001 (2,776,887) (809,995) 5,140,570
416 Crown Construction 438,137 708,795 (270,658) 5,034,673 5,034,673
417 Crown Community CTR Maintenance 131,247 - 131,247 621,292 621,292
420 Special Assessment 166,717 361,667 (194,950) 1,247,902 1,247,901
505 Parking 8,090,716 7,184,556 906,160 1,043,611 1,712,887
510-513 Water 24,135,473 22,826,174 1,309,300 5,963,425 4,108,898
515 Sewer 7,204,896 5,555,538 1,649,358 7,662,637 6,768,255
520 Solid Waste 4,391,827 4,124,179 267,649 1,069,770 1,353,716
600 Fleet 2,443,938 3,189,915 (745,977) (402,023) (1,943,067)
601 Equipment Replacement 2,262,072 1,750,983 511,090 3,505,104 1,465,442
605 Insurance 15,864,195 14,922,880 941,315 (1,205,882) (1,386,604)
Memorandum
Please note that the attached supporting documents have been updated to show further fund
and department analysis.
Included above are ending fund and cash balances as of September 30, 2023. Cash balance
represents liquid cash and/or invested assets which can be used (or easily sold) to support
and fund current operations.
Fund balance includes illiquid assets or future cash receipts or disbursements such as receivables
(including property tax) due to the City and accounts payable/accrued expenses. All fund balances are
unaudited.
The City has received its first installment of property tax payments. Officials from Cook County
announced second installment property tax bills for Tax Year 2022 are expected to be available to
property owners by November 1 with a due date of December 1.
The City relies on the Illinois Municipal League to project this revenue and their latest projections from
September 2023 show $162.37 per capita. The State budget year beginning July 1, 2023 did increase
the local share of LGDF from 6.16% to 6.47% and the City has seen a slight increase in Income Tax
returns for the past three months. In total, Income Taxes receipts for FY 2023 slightly trail FY 2022
returns but remains well above prior years largely due to inflation and an increase in Evanston’s
population in the 2020 Census.
Like income tax, sales taxes have outpaced pre-pandemic amounts due to inflation. Inflation continues
to level out but at a slower pace than expected. July is the 7th month of revenue recognized for Sales
Taxes and Home Rule Sales Taxes which are exceeding 2022 returns by 2.7% and 2.1%, respectively.
Personal Property Replacement Taxes are trending below the amounts received in YTD 2022.
According to data from the Illinois Municipal League, these revenues are projected to continue to lag
last year’s actuals by approximately 38% through the end of 2023.
FY 2023 Actual Revenues (Through September 2023)
Account Description
100
GENERAL
FUND
177
REPARATIONS
FUND
700 FIRE
PENSION
FUND
705 POLICE
PENSION
FUND
Grand
Total
STATE INCOME TAX 9,685,050 - - - 9,685,050
SALES TAX - BASIC 9,281,253 - - - 9,281,253
SALES TAX - HOME RULE 7,118,922 - - - 7,118,922
RECREATION PROGRAM FEES 5,474,165 - - - 5,474,165
PROPERTY TAXES 5,429,361 - - - 5,429,361
BUILDING PERMITS 3,901,535 - - - 3,901,535
PERSONAL PROPERTY REPLACEMENT TAX 2,204,787 - 280,000 325,000 2,809,787
LIQUOR TAX 2,777,865 - - 2,777,865
REAL ESTATE TRANSFER TAX - 2,756,994 - - 2,756,994
TICKET FINES-PARKING 2,704,987 - - - 2,704,987
AMBULANCE SERVICE 2,502,330 - - - 2,502,330
WHEEL TAX 2,435,595 - 2,435,595
PARKING TAX 2,137,777 - - - 2,137,777
STATE USE TAX 2,111,707 - - - 2,111,707
ELECTRIC UTILITY TAX 2,081,425 - - - 2,081,425
MUNICIPAL HOTEL TAX 2,014,090 - - - 2,014,090
GEMT SERVICE REVENUE 1,560,716 - - - 1,560,716
The unaudited financials as of September 30, 2023, show the General Fund with a fund balance of
$52,972,981 and cash balance of $50,037,395. The attached financials show both General Fund
revenues slightly under budget (at 74%) and expenses over budget (at 77%).
General Fund Expenses by Category
Insurances and other chargebacks are higher mainly because of a one-time transfer of reserves from
the General Fund to the Police and Fire Pension Funds. Interfund transfers are at 152% of budget
due to a transfer of $3.3 million to the Capital Improvement Fund to cover overages on four capital
projects. Unlike other transfers that are smoothed out throughout the year, these transfers were
completed all at once.
The budget planned for a 4.5% increase for all employees and included a 4% reduction to account for
city-wide vacancies. In January, the City reached an agreement with the Police Department that has
resulted in an 18% increase for Police Officer salaries and 14% increase to Sergeant salaries in 2023.
Negotiations with Fire were finalized in March with a 11% increase for Firefighters. The AFSCME
contract was finalized in September and resulted in an 11% increase for union employees retroactive
to January 1, 2023. Non-union staff received an overall increase of 11% as well. Wage increases for
all employees will have taken effect by the end of October and the retro payment for AFSCME
employees is expected in November and will be reflected in remaining monthly reports through the end
of the year.
Through September 30, 2023, Police spent 95% of budget for overtime, and Fire spent 91% of the
annual budget. Higher than budgeted salary increases are contributing to overages in overtime.
Overtime
Expenses
2022 Actual 2023 Budget 2023 YTD % Budget
Police $1,570,628 $ 1,566,349 $1,485,145 95%
Fire $950,226 $ 959,956 $872,710 91%
Enterprise Funds
Parking Fund revenues are at 82% and expenses at 64% as of September 30, 2023. Capital projects
budgeted under Capital Outlay have not started contributing to expenses coming under budget.
Through September 30, 2023, overall the Water Fund operating revenues and expenses are in line with
the budget. Capital projects funded by IEPA loans have begun. These projects are budgeted in Other
Revenue and expenses in Capital Outlay. One concern is the fact that 2023 GO Bonds have not been
issued for projects planned in this fund. These projects have been drawing on the existing fund balance
until these bonds are issued.
General Fund 2023 Budget 2023 Actual % of Budget 2022 Budget 2022 Actual % of Budget
Expenses
Salary and Benefits 75,748,150 58,824,252 78%74,503,722 52,386,112 70%
Insurance and Other Chargebacks 28,934,436 19,269,021 67%24,383,062 14,945,076 61%
Services and Supplies 16,965,457 13,714,418 81%15,131,213 12,964,505 86%
Interfund Transfers 4,248,750 6,466,766 152%2,595,000 3,564,218 137%
Miscellaneous 617,822 295,400 48%590,390 764,099 129%
Capital Outlay 694,500 234,151 34%434,500 228,397 53%
Contingencies 408,500 126,283 31%183,500 290 0%
Community Sponsored Organizations 120,000 55,264 46%69,600 - 0%
Expenses Total 127,737,614 98,985,554 77%117,890,987 84,852,698 72%
Through September 30, 2023, the Sewer Funds operating revenues and expenses came in below
budget. Capital projects budgeted under Capital Outlay have not started contributing to expenses
coming under budget.
Other Funds
Through September 30, 2023, the Capital Improvements Fund is showing a negative fund balance of
$809,995 and a cash balance of $5,140,570. The fund continues to spend down Series 2021 and Series
2020 bond proceeds. The fund saw a significant decrease in fund balance due to the booking of
expenses for projects that have been completed, but invoices not received from IDOT as well as
deferred issuance of 2022 and 2023 GO Bonds. Several projects have been approved by City Council
at higher than budgeted amounts and have used General Fund cash balance totaling $3,264,226.
Through September 30, 2023, the Crown Construction fund is showing fund and cash balance of
$5,034,673. This cash balance is useful to fund any major needs of the Robert Crown center. The fund
received a $250,000 donation from the Friends of the Robert Crown in August.
Through September 30, 2023, the Fleet Fund is showing a negative fund balance of $402,023 and a
negative cash balance of $1,943,067. This difference is largely a result of inventory on hand that is
reflected as an asset in the fund balance but reduced from the cash balance. This deficit has grown
over the last few months and is a result of wage increases to Fleet Maintenance employees and the
impact of inflation on vehicle parts and fuel. As this is an internal service fund largely supported by the
General Fund, this deficit will need to be covered by increasing transfers from the General Fund.
Through September 30, 2023, the Insurance Fund is showing a negative fund balance of $1,205,882
and a negative cash balance of $1,386,604.
If there are any questions on the attached report, please contact me by phone at (847) 448-8082 or by
email: hdesai@cityofevanston.org. Detailed fund summary reports can be found at:
http://www.cityofevanston.org/city-budget/financial-reports/.
CERTIFICATION OF ATTACHED FINANCIAL REPORTS
As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Hitesh Desai, Treasurer of the City of Evanston,
hereby affirm that I have reviewed the September 30, 2023 year-to-date financial information and
reports which to the best of my knowledge appear accurate and complete.
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
100 GENERAL FUND
Revenue
Other Taxes 56,570,000 49,037,901 87% 51,925,000 52,787,686 102%
Property Taxes 29,047,402 16,682,037 57% 28,774,164 16,178,435 56%
Charges for Services 8,785,075 8,597,171 98% 8,491,325 8,704,561 103%
Licenses, Permits and Fees 7,543,450 5,902,978 78% 8,085,550 7,046,271 87%
Interfund Transfers 7,733,949 5,800,455 75% 8,775,706 6,581,780 75%
Fines and Forfeitures 3,632,500 3,086,422 85% 3,723,500 2,803,626 75%
Intergovernmental Revenue 3,116,184 2,632,601 84% 5,961,342 6,115,543 103%
Other Revenue 11,254,054 1,208,805 11% 2,118,100 1,573,586 74%
Interest Income 55,000 1,207,679 2196% 55,000 282,914 514%
Revenue Total 127,737,614 94,156,050 74% 117,909,687 102,074,401 87%
Expenses
12 LEGISLATIVE - 2,608 - -
13 CITY COUNCIL 658,324 444,127 67% 579,384 477,427 82%
14 CITY CLERK 360,108 253,359 70% 343,573 204,645 60%
15 CITY MANAGER'S OFFICE 8,143,075 8,655,039 106% 6,232,882 4,865,109 78%
17 LAW 988,558 820,167 83% 970,341 699,842 72%
19 ADMINISTRATIVE SERVICES 12,537,670 9,738,391 78% 11,449,183 9,018,293 79%
21 COMMUNITY DEVELOPMENT 4,183,421 2,525,181 60% 4,488,317 2,265,460 50%
22 POLICE 29,214,097 24,046,817 82% 29,280,598 20,185,096 69%
23 FIRE MGMT & SUPPORT 18,689,924 15,754,000 84% 16,823,272 12,970,415 77%
24 HEALTH 1,413,058 1,207,764 85% 1,453,836 1,888,583 130%
30 PARKS AND RECREATION 12,751,313 9,490,074 74% 12,101,740 8,955,535 74%
40 PUBLIC WORKS AGENCY 13,708,631 9,696,020 71% 13,444,799 11,234,438 84%
99 NON-DEPARTMENTAL 25,089,436 16,352,008 65% 20,723,062 12,087,856 58%
Expenses Total 127,737,614 98,985,554 77% 117,890,987 84,852,698 72%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
170 AMERICAN RESCUE PLAN
Revenue
Interest Income - 1,044,292 - 238,547
Other Revenue - 20,682
Intergovernmental Revenue - - 21,586,827 21,586,827 100%
Revenue Total - 1,064,973 21,586,827 21,825,374 101%
Expenses
Interfund Transfers 2,600,000 1,875,032 72% 8,150,000 5,050,000 62%
Services and Supplies - 923,925 - 17
Capital Outlay 800,000 746,403 93% - 20,604
Miscellaneous 18,500,000 672,877 4% 22,250,000 29,248 0%
Salary and Benefits - 351,239 - 400
Insurance and Other Chargebacks 850,000 80,170 9% - 29,247
Community Sponsored Organizations - - - 10,344
Expenses Total 22,750,000 4,649,646 20% 30,400,000 5,139,862 17%
175 GENERAL ASSISTANCE FUND
Revenue
Property Taxes 1,300,000 736,081 57% 1,300,000 736,629 57%
Interest Income 1,000 41,965 4197% 1,000 7,078 708%
Other Revenue 27,500 - 0% 27,500 26,183 95%
Revenue Total 1,328,500 778,047 59% 1,328,500 769,890 58%
Expenses
Services and Supplies 864,482 394,888 46% 864,482 398,120 46%
Salary and Benefits 488,738 381,161 78% 469,871 364,935 78%
Miscellaneous 7,000 12,680 181% 7,000 4,000 57%
Expenses Total 1,360,220 788,729 58% 1,341,353 767,055 57%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
176 HUMAN SERVICES FUND
Revenue
Property Taxes 3,110,000 1,555,000 50% 3,110,000 1,550,000 50%
Intergovernmental Revenue 114,000 340,250 298% 194,000 182,282 94%
Interest Income - 49,399 - 7,168
Other Revenue 2,000 27,336 1367% 2,000 - 0%
Revenue Total 3,226,000 1,971,985 61% 3,306,000 1,739,450 53%
Expenses
Salary and Benefits 2,373,285 1,454,325 61% 1,705,820 1,171,145 69%
Services and Supplies 1,804,973 986,460 55% 1,761,183 268,194 15%
Community Sponsored Organizations 60,000 435,181 725% 143,333 489,782 342%
Miscellaneous 213,000 210,935 99% 258,000 129,488 50%
Insurance and Other Chargebacks - 19,313
Expenses Total 4,451,258 3,106,214 70% 3,868,336 2,058,608 53%
177 REPARATIONS FUND
Revenue
Other Taxes 3,400,000 2,756,994 81% 400,000 - 0%
Intergovernmental Revenue - 100,000
Interest Income - 17,780 - 2,475
Other Revenue - 8,563 - 3,925
Revenue Total 3,400,000 2,883,336 85% 400,000 6,400 2%
Expenses
Miscellaneous 3,400,000 1,204,964 35% 400,000 162,805 41%
Services and Supplies - 1,289 - 1,591
Expenses Total 3,400,000 1,206,254 35% 400,000 164,395 41%
178 SUSTAINABILITY FUND
Revenue
Licenses, Permits and Fees 500,000 361,871 72% - 333,717
Interfund Transfers 200,000 150,003 75% - 117,969
Other Revenue 500,000 50,000 10%
Interest Income - 9,125
Revenue Total 1,200,000 570,999 48% - 451,685
Expenses
Services and Supplies 546,000 205,367 38% - 151,419
Salary and Benefits 256,893 122,076 48%
Expenses Total 802,893 327,443 41% - 151,419
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
180 GOOD NEIGHBOR FUND
Revenue
Interest Income - 11,395 - 2,549
Revenue Total - 11,395 - 2,549
Expenses
Miscellaneous - 450,000 1,000,000 40,000 4%
Capital Outlay - 75,000 - 18,953
Services and Supplies - 178 - 262
Interfund Transfers 85,000 - 0% - -
Expenses Total 85,000 525,178 618% 1,000,000 59,215 6%
185 LIBRARY FUND
Revenue
Property Taxes 7,535,472 4,074,827 54% 7,252,000 4,074,340 56%
Interest Income 21,600 202,070 936% 15,000 37,829 252%
Other Revenue 405,000 199,888 49% 410,000 226,654 55%
Intergovernmental Revenue 209,866 193,694 92% 472,866 173,089 37%
Interfund Transfers 250,000 166,460 67% 217,911 - 0%
Library Revenue 155,394 69,308 45% 174,800 83,425 48%
Charges for Services 400 283 71% - 342
Licenses, Permits and Fees 115,767 - 0%
Fines and Forfeitures - - - 3,101
Revenue Total 8,577,732 4,906,530 57% 8,658,344 4,598,779 53%
Expenses
Salary and Benefits 6,393,544 4,154,772 65% 6,132,692 4,145,412 68%
Services and Supplies 2,247,673 1,392,176 62% 2,136,767 1,422,780 67%
Interfund Transfers 305,325 228,987 75% 379,653 284,740 75%
Insurance and Other Chargebacks - 5,452
Capital Outlay 1,500 512 34% 8,500 1,000 12%
Miscellaneous - -
Expenses Total 8,948,042 5,781,899 65% 8,657,612 5,853,932 68%
186 LIBRARY DEBT SERVICE FUND
Revenue
Property Taxes 507,913 253,956 50% 506,625 253,313 50%
Revenue Total 507,913 253,956 50% 506,625 253,313 50%
Expenses
Debt Service 507,913 116,092 23% 506,625 119,322 24%
Expenses Total 507,913 116,092 23% 506,625 119,322 24%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
187 LIBRARY CAPITAL IMPROVEMENT FD
Revenue
Other Revenue 950,000 - 0% 480,000 - 0%
Revenue Total 950,000 - 0% 480,000 - 0%
Expenses
Capital Outlay 950,000 512,176 54% 680,000 138,563 20%
Expenses Total 950,000 512,176 54% 680,000 138,563 20%
200 MOTOR FUEL TAX FUND
Revenue
Intergovernmental Revenue 2,700,000 2,464,022 91% 3,656,700 3,847,985 105%
Interest Income 12,000 203,505 1696% 12,000 42,986 358%
Revenue Total 2,712,000 2,667,526 98% 3,668,700 3,890,970 106%
Expenses
Capital Outlay 2,778,600 1,957,564 70% 3,261,000 1,027,484 32%
Services and Supplies 1,038,000 438,306 42% 1,038,000 598,457 58%
Salary and Benefits 325,000 - 0%
Interfund Transfers 1,044,987 783,740 75%
Expenses Total 4,141,600 2,395,870 58% 5,343,987 2,409,681 45%
205 EMERGENCY TELEPHONE (E911) FUND
Revenue
Other Taxes 1,400,000 970,597 69% 1,400,000 1,344,656 96%
Interest Income 7,000 19,791 283% 7,000 3,108 44%
Revenue Total 1,407,000 990,388 70% 1,407,000 1,347,764 96%
Expenses
Salary and Benefits 758,058 524,720 69% 768,616 553,835 72%
Services and Supplies 355,000 243,866 69% 393,700 243,663 62%
Capital Outlay 450,000 121,275 27% 450,000 41,202 9%
Interfund Transfers 90,000 67,500 75% 90,000 67,500 75%
Insurance and Other Chargebacks 19,142 14,355 75% 18,230 13,673 75%
Expenses Total 1,672,200 971,716 58% 1,720,546 919,873 53%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
210 SPECIAL SERVICE AREA (SSA) #9
Revenue
Property Taxes 595,000 352,609 59% 595,000 318,404 54%
Interfund Transfers 206,750 206,750 100%
Interest Income - 3,802 - 75
Revenue Total 801,750 563,162 70% 595,000 318,479 54%
Expenses
Services and Supplies 575,000 316,021 55% 575,000 317,540 55%
Expenses Total 575,000 316,021 55% 575,000 317,540 55%
215 CDBG FUND
Revenue
Intergovernmental Revenue 3,629,000 655,078 18% 3,684,820 212,851 6%
Interest Income - 2,094 - 209
Revenue Total 3,629,000 657,172 18% 3,684,820 213,060 6%
Expenses
Salary and Benefits 702,459 334,327 48% 589,422 292,410 50%
Insurance and Other Chargebacks - 210,212 - 127,975
Community Sponsored Organizations 75,000 205,089 273% 75,000 110,136 147%
Capital Outlay - 100,074 - 74,980
Miscellaneous 2,576,376 13,375 1% 2,515,000 19,774 1%
Services and Supplies 307,200 6,491 2% 506,200 25,865 5%
Expenses Total 3,661,035 869,568 24% 3,685,622 651,139 18%
220 CDBG LOAN FUND
Revenue
Other Revenue 100,000 100,494 100% 100,000 67,619 68%
Interest Income - 16,610 - 2,531
Revenue Total 100,000 117,104 117% 100,000 70,151 70%
Expenses
Services and Supplies 325,000 44,609 14% 175,000 375 0%
Expenses Total 325,000 44,609 14% 175,000 375 0%
235 NEIGHBORHOOD IMPROVEMENT
Revenue
Interest Income - 451 - 65
Revenue Total - 451 - 65
Expenses
Services and Supplies - 8 - 7
Expenses Total - 8 - 7
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
240 HOME FUND
Revenue
Intergovernmental Revenue 650,000 37,371 6% 540,453 267,371 49%
Other Revenue 25,000 20,538 82% 25,000 27,223 109%
Interest Income 150 497 331% 150 870 580%
Revenue Total 675,150 58,406 9% 565,603 295,464 52%
Expenses
Salary and Benefits 70,572 47,591 67% 70,681 46,640 66%
Services and Supplies 582,266 29,081 5% 500,565 266,993 53%
Miscellaneous 2,000 - 0% 500 - 0%
Insurance and Other Chargebacks - (13,685) - (6,853)
Expenses Total 654,838 62,988 10% 571,746 306,780 54%
250 AFFORDABLE HOUSING FUND
Revenue
Other Revenue 130,600 297,500 228% 140,600 97,917 70%
Interest Income 4,500 97,836 2174% 5,700 15,659 275%
Intergovernmental Revenue 145,000 57,213 39% 658,000 288,977 44%
Other Taxes 50,000 - 0% 75,000 - 0%
Revenue Total 330,100 452,549 137% 879,300 402,553 46%
Expenses
Services and Supplies 1,565,000 191,263 12% 2,065,050 66,170 3%
Salary and Benefits 130,126 52,980 41% 180,075 134,556 75%
Community Sponsored Organizations 166,000 47,324 29% 166,000 275,952 166%
Miscellaneous 53,500 7,465 14% 67,500 2,991 4%
Insurance and Other Chargebacks 12,000 3,173 26% 17,000 (22,021) -130%
Capital Outlay 10,000 - 0%
Expenses Total 1,926,626 302,205 16% 2,505,625 457,649 18%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
320 DEBT SERVICE FUND
Revenue
Property Taxes 12,878,258 7,389,316 57% 13,436,256 8,012,403 60%
Interfund Transfers 2,918,969 1,739,232 60% 2,267,041 1,700,281 75%
Interest Income 10,000 170,638 1706% 1,500 47,150 3143%
Other Revenue - 62,360 - -
Revenue Total 15,807,227 9,361,545 59% 15,704,797 9,759,833 62%
Expenses
Debt Service 15,797,123 2,612,830 17% 15,690,075 2,853,260 18%
Services and Supplies 6,600 25 0% - 11
Miscellaneous - - - 29,517
Expenses Total 15,803,723 2,612,855 17% 15,690,075 2,882,788 18%
330 HOWARD-RIDGE TIF FUND
Revenue
Property Taxes 1,100,000 633,929 58% 1,100,000 688,893 63%
Interest Income 10,000 78,105 781% 400 19,804 4951%
Other Revenue 5,000 35,000 700% 5,366 65,404 1219%
Revenue Total 1,115,000 747,033 67% 1,105,766 774,100 70%
Expenses
Capital Outlay 785,000 793,978 101% 785,000 391,989 50%
Interfund Transfers 395,913 296,937 75% 398,113 298,585 75%
Services and Supplies 250,000 152,476 61% 265,000 277,305 105%
Miscellaneous - 122,867
Expenses Total 1,430,913 1,366,258 95% 1,448,113 967,879 67%
335 WEST EVANSTON TIF FUND
Revenue
Property Taxes 1,450,000 821,627 57% 1,450,000 995,839 69%
Interest Income 5,000 91,289 1826% 4,000 27,363 684%
Other Revenue 10,000 - 0% 11,000 - 0%
Revenue Total 1,465,000 912,916 62% 1,465,000 1,023,202 70%
Expenses
Miscellaneous 200,000 560,000 280% 200,000 6,613 3%
Capital Outlay 3,660,000 56,264 2% 1,765,000 25,076 1%
Interfund Transfers 75,000 56,250 75% 75,000 56,250 75%
Services and Supplies 5,000 35,460 709% 5,000 10,732 215%
Expenses Total 3,940,000 707,974 18% 2,045,000 98,671 5%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
340 DEMPSTER-DODGE TIF FUND
Revenue
Property Taxes 180,000 121,726 68% 160,000 158,329 99%
Interest Income 1,000 14,278 1428% - 2,743
Revenue Total 181,000 136,005 75% 160,000 161,072 101%
Expenses
Interfund Transfers 174,483 130,860 75% 171,833 128,875 75%
Services and Supplies 2,000 7,763 388% 2,000 1,249 62%
Expenses Total 176,483 138,623 79% 173,833 130,124 75%
345 CHICAGO-MAIN TIF
Revenue
Property Taxes 1,000,000 650,751 65% 1,000,000 671,852 67%
Interest Income 2,500 71,257 2850% - 9,539
Other Revenue 1,880,000 - 0%
Revenue Total 2,882,500 722,008 25% 1,000,000 681,391 68%
Expenses
Interfund Transfers 271,355 203,517 75% 264,763 198,572 75%
Capital Outlay 2,469,000 119,173 5% 1,090,000 64,231 6%
Miscellaneous 250,000 20,000 8% 250,000 - 0%
Services and Supplies 5,000 15,127 303% 5,000 2,477 50%
Expenses Total 2,995,355 357,817 12% 1,609,763 265,280 16%
350 SPECIAL SERVICE AREA (SSA) #6
Revenue
Property Taxes 221,000 121,021 55% 221,000 122,429 55%
Interest Income 250 11,921 4769% - 787
Revenue Total 221,250 132,943 60% 221,000 123,215 56%
Expenses
Services and Supplies 220,000 117,505 53% 221,000 - 0%
Expenses Total 220,000 117,505 53% 221,000 - 0%
355 SPECIAL SERVICE AREA (SSA) #7
Revenue
Property Taxes 142,000 77,003 54% 142,000 81,991 58%
Interest Income 200 1,649 824% - 235
Revenue Total 142,200 78,651 55% 142,000 82,226 58%
Expenses
Services and Supplies 140,000 77,112 55% 140,000 77,075 55%
Expenses Total 140,000 77,112 55% 140,000 77,075 55%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
360 SPECIAL SERVICE AREA (SSA) #8
Revenue
Property Taxes 60,200 34,706 58% 60,200 34,437 57%
Interest Income - 704 - 34
Revenue Total 60,200 35,410 59% 60,200 34,471 57%
Expenses
Services and Supplies 60,200 31,505 52% 60,200 30,517 51%
Expenses Total 60,200 31,505 52% 60,200 30,517 51%
365 FIVE FIFTH TIF FUND
Expenses
Capital Outlay - 506,360
Miscellaneous - 185,665 - 50
Services and Supplies 100,000 27,261 27% - 6,998
Expenses Total 100,000 719,286 719% - 7,048
415 CAPITAL IMPROVEMENTS FUND
Revenue
Interfund Transfers 85,000 3,264,226 3840% - 956,470
Intergovernmental Revenue 4,592,500 322,500 7%
Interest Income - 167,388 - 54,972
Other Revenue 17,350,000 98,523 1% 12,253,000 812,344 7%
Charges for Services - 19,477 - 33,880
Revenue Total 22,027,500 3,872,113 18% 12,253,000 1,857,667 15%
Expenses
Capital Outlay 22,492,500 5,563,718 25% 16,455,000 1,301,081 8%
Services and Supplies - 1,085,283 - 1,414,761
Salary and Benefits - -
Miscellaneous - - - 142,405
Expenses Total 22,492,500 6,649,001 30% 16,455,000 2,858,248 17%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
416 CROWN CONSTRUCTION FUND
Revenue
Other Revenue 1,000,000 246,222 25% 1,000,000 600,000 60%
Interest Income 10,000 191,916 1919% - 45,501
Revenue Total 1,010,000 438,137 43% 1,000,000 645,501 65%
Expenses
Interfund Transfers 945,000 708,750 75% 900,000 675,000 75%
Services and Supplies - 45 - 17,795
Capital Outlay 200,000 - 0% 800,000 154,518 19%
Miscellaneous - -
Expenses Total 1,145,000 708,795 62% 1,700,000 847,313 50%
417 CROWN COMMUNITY CTR MAINTENANCE
Revenue
Interfund Transfers 175,000 131,247 75% 175,000 131,250 75%
Revenue Total 175,000 131,247 75% 175,000 131,250 75%
Expenses
Capital Outlay 175,000 - 0% - 34,951
Expenses Total 175,000 - 0% - 34,951
420 SPECIAL ASSESSMENT FUND
Revenue
Other Taxes 125,000 103,471 83% 125,000 255,765 205%
Interest Income 30,000 63,246 211% 30,000 23,443 78%
Revenue Total 155,000 166,717 108% 155,000 279,208 180%
Expenses
Interfund Transfers 455,360 341,514 75% 464,938 348,704 75%
Capital Outlay 375,000 20,108 5% 650,000 21,782 3%
Services and Supplies - 45 - 45
Expenses Total 830,360 361,667 44% 1,114,938 370,531 33%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
505 PARKING SYSTEM FUND
Revenue
Charges for Services 8,308,975 6,966,432 84% 8,873,975 6,459,825 73%
Intergovernmental Revenue 1,100,000 693,553 63% 2,300,000 1,725,000 75%
Other Revenue 486,700 355,651 73% 486,700 213,749 44%
Interest Income 20,000 75,080 375% 20,000 25,647 128%
Licenses, Permits and Fees - 375
Revenue Total 9,915,675 8,090,716 82% 11,680,675 8,424,596 72%
Expenses
Services and Supplies 4,340,316 3,337,069 77% 4,550,316 3,047,804 67%
Interfund Transfers 3,132,390 2,349,288 75% 3,132,390 2,359,712 75%
Salary and Benefits 1,716,539 1,071,751 62% 1,637,273 1,042,689 64%
Insurance and Other Chargebacks 369,077 277,193 75% 351,502 263,626 75%
Capital Outlay 1,600,000 131,180 8% 2,025,000 932,165 46%
Debt Service 76,150 18,075 24% 72,900 18,950 26%
Miscellaneous 50,000 - 0% 50,000 11,380 23%
Expenses Total 11,284,472 7,184,556 64% 11,819,381 7,676,327 65%
510 WATER FUND
Revenue
Charges for Services 24,378,734 17,524,085 72% 23,443,200 16,792,687 72%
Other Revenue 51,039,150 6,252,558 12% 29,834,150 3,588,124 12%
Interest Income 70,000 204,333 292% 70,000 91,116 130%
Licenses, Permits and Fees 50,000 16,705 33% 50,000 39,313 79%
Revenue Total 75,537,884 23,997,681 32% 53,397,350 20,511,240 38%
Expenses
Salary and Benefits 7,110,142 4,485,314 63% 6,004,605 4,304,258 72%
Interfund Transfers 4,229,559 3,172,176 75% 4,229,559 4,283,092 101%
Services and Supplies 5,908,008 2,118,048 36% 5,347,760 2,212,725 41%
Debt Service 4,072,486 1,268,245 31% 3,596,365 1,290,240 36%
Insurance and Other Chargebacks 1,665,135 1,250,503 75% 1,585,843 1,205,378 76%
Miscellaneous 15,000 - 0% 15,000 240,072 1600%
Contingencies 1,000 - 0% 1,000 9 1%
Capital Outlay 388,400 - 0% 164,400 200,482 122%
Expenses Total 23,389,730 12,294,286 53% 20,944,532 13,736,255 66%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
513 WATER DEPR IMPRV &EXTENSION FUND
Revenue
Interfund Transfers - 137,792
Revenue Total - 137,792
Expenses
Capital Outlay 57,780,500 9,537,242 17% 33,036,000 13,232,404 40%
Services and Supplies 11,700 994,646 8501% 3,465,000 897,597 26%
Interfund Transfers - (1,110,923)
Expenses Total 57,792,200 10,531,888 18% 36,501,000 13,019,079 36%
515 SEWER FUND
Revenue
Charges for Services 10,240,424 7,091,806 69% 10,113,594 7,245,230 72%
Interest Income 25,000 97,673 391% 25,000 13,052 52%
Other Revenue 1,000 15,418 1542% 2,001,000 - 0%
Revenue Total 10,266,424 7,204,896 70% 12,139,594 7,258,282 60%
Expenses
Debt Service 3,809,232 2,445,471 64% 3,772,691 2,416,617 64%
Salary and Benefits 1,386,579 981,529 71% 1,383,914 1,005,792 73%
Interfund Transfers 883,858 662,895 75% 871,164 653,373 75%
Services and Supplies 1,750,300 659,778 38% 1,471,800 1,163,920 79%
Capital Outlay 3,050,700 528,512 17% 3,538,100 172,854 5%
Insurance and Other Chargebacks 369,800 277,353 75% 352,190 264,143 75%
Miscellaneous 1,500 - 0% 1,500 75,169 5011%
Expenses Total 11,251,969 5,555,538 49% 11,391,359 5,751,868 50%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
520 SOLID WASTE FUND
Revenue
Charges for Services 4,669,000 3,369,302 72% 4,516,450 3,345,407 74%
Property Taxes 1,332,500 666,250 50% 1,332,500 666,250 50%
Licenses, Permits and Fees 389,000 283,894 73% 297,000 288,133 97%
Other Revenue 122,000 55,881 46% 122,000 181,703 149%
Interest Income - 16,501
Interfund Transfers - 1,000,000
Revenue Total 6,512,500 4,391,827 67% 6,267,950 5,481,493 87%
Expenses
Services and Supplies 3,935,115 2,594,130 66% 3,786,776 2,672,008 71%
Salary and Benefits 1,651,410 1,213,990 74% 1,492,909 1,158,576 78%
Interfund Transfers 322,000 241,497 75% 302,000 682,970 226%
Capital Outlay 525,000 64,720 12% 525,000 158,162 30%
Miscellaneous 15,000 9,842 66% 15,000 8,790 59%
Expenses Total 6,448,525 4,124,179 64% 6,121,685 4,680,505 76%
600 FLEET SERVICES FUND
Revenue
Charges for Services 3,244,440 2,433,321 75% 3,127,440 2,330,580 75%
Other Revenue 69,000 10,617 15% 69,000 15,102 22%
Interest Income 1,000 - 0% 1,000 - 0%
Revenue Total 3,314,440 2,443,938 74% 3,197,440 2,345,682 73%
Expenses
Services and Supplies 2,044,557 1,908,961 93% 2,034,507 1,667,643 82%
Salary and Benefits 1,417,422 1,096,498 77% 1,276,621 956,732 75%
Capital Outlay - 184,456
Insurance and Other Chargebacks - 900
Expenses Total 3,461,979 3,189,915 92% 3,311,128 2,625,275 79%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
601 EQUIPMENT REPLACEMENT FUND
Revenue
Intergovernmental Revenue 1,500,000 1,181,480 79% 1,600,000 1,200,000 75%
Charges for Services 754,885 566,163 75% 224,885 172,664 77%
Other Revenue 25,000 267,153 1069% 960,217 859,574 90%
Interfund Transfers - 237,001
Interest Income - 10,276 - 42
Revenue Total 2,279,885 2,262,072 99% 2,785,102 2,232,280 80%
Expenses
Capital Outlay 2,700,000 1,750,857 65% 2,750,000 2,329,803 85%
Services and Supplies - 126 - 6
Debt Service - 8,188
Expenses Total 2,700,000 1,750,983 65% 2,750,000 2,337,997 85%
605 INSURANCE FUND
Revenue
Other Revenue 11,448,112 7,810,051 68% 11,248,243 7,671,998 68%
Insurance 9,444,453 7,061,520 75% 8,827,914 6,795,778 77%
Workers Compensation and Liability 862,500 992,495 115% 825,000 587,949 71%
Charges for Services - 129 - 16,447
Revenue Total 21,755,065 15,864,195 73% 20,901,157 15,072,171 72%
Expenses
Insurance and Other Chargebacks 16,765,000 12,221,123 73% 16,957,400 12,419,159 73%
Services and Supplies 3,244,200 2,671,217 82% 2,994,200 2,225,622 74%
Salary and Benefits 4,287 30,541 712% 4,751 82,730 1741%
Expenses Total 20,013,487 14,922,880 75% 19,956,351 14,727,511 74%