HomeMy WebLinkAbout2023.06 June Monthly Report
To: Luke Stowe, City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: June 2023 Monthly Financial Report
Date: July 29, 2023
Please find attached the unaudited financial statements as of June 30 , 2023. A summary by fund for revenues, expenditures, fund and cash
balances is as follows:
City of Evanston
Cash & Investment Summary by Fund
June 30 , 2023
Fund #Fund Revenue Expense Net Fund Balance Cash Balance
100 General 66,304,324 68,884,366 (2,580,042) 55,325,557 51,946,065
170 American Rescue Plan 663,514 2,580,166 (1,916,653) (1,385,481) 29,328,724
175 General Assistance 730,923 520,204 210,719 1,197,107 1,197,107
176 Human Services 1,705,576 1,262,195 443,382 3,507,443 3,507,443
177 Reparations 2,045,208 232,368 1,812,840 2,061,376 2,061,376
178 Sustainability 341,989 159,254 182,735 567,327 567,327
180 Good Neighbor 8,588 300,098 (291,509) 441,903 441,903
185 Library 4,199,628 3,658,979 540,649 4,551,254 4,551,177
186 Library Debt Service 253,956 116,092 137,865 140,647 140,647
187 Library Capital Improvement FD - 436,437 (436,437) 267,952 267,952
200 MFT 1,717,613 893,969 823,644 6,281,610 5,976,744
205 E911 499,444 670,493 (171,049) 1,313,319 946,317
210 Special Service Area (SSA) #9 533,245 316,021 217,223 17,236 17,236
215 CDBG 129,887 488,573 (358,687) (299,364) (299,364)
220 CD Loan 54,151 45,002 9,149 388,399 388,399
235 Neighborhood Improvement 308 4 304 22,599 22,599
240 Home 14,064 23,152 (9,088) (2,235) (2,235)
250 Affordable Housing 162,887 269,561 (106,675) 2,495,689 2,643,922
320 Debt Service 8,183,520 2,588,188 5,595,332 7,738,210 8,294,920
330 Howard Ridge 702,813 382,815 319,997 2,425,093 2,416,346
335 West Evanston 866,167 621,118 245,049 2,709,046 2,709,046
340 Dempster-Dodge-TIF 130,842 95,002 35,839 408,852 408,852
345 Chicago Main-TIF 694,519 235,234 459,286 2,152,964 2,152,964
350 Special Service Area (SSA) #6 127,525 362 127,163 131,719 353,581
355 Special Service Area (SSA) #7 78,477 77,112 1,365 13,801 13,801
360 Special Service Area (SSA) #8 34,239 31,505 2,734 7,262 7,262
365 Five-Fifth TIF 278,460 (278,460) (414,362) (414,362)
415 Capital Improvements 3,768,072 2,196,032 1,572,040 3,538,933 9,489,497
416 Crown Construction 107,413 489,079 (381,666) 4,923,665 4,923,665
417 Crown Community CTR Maintenance 87,498 - 87,498 577,543 577,543
420 Special Assessment 127,986 241,295 (113,309) 1,329,543 1,329,543
505 Parking 5,390,875 4,677,081 713,794 2,139,020 1,537,193
510-513 Water 13,894,358 11,444,719 2,449,639 11,857,322 5,777,628
515 Sewer 4,360,559 3,256,754 1,103,804 8,285,572 6,525,663
520 Solid Waste 3,019,454 2,501,743 517,711 2,845,020 1,754,294
600 Fleet 1,625,994 1,955,040 (329,046) 14,908 (1,526,136)
601 Equipment Replacement 463,942 1,014,949 (551,007) 2,159,394 403,345
605 Insurance 10,668,735 9,549,996 1,118,740 (1,028,458) (1,209,179)
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 June 30, 2023. Cash balance represents liquid
cash and/or invested assets which can be used (or easily so ld) 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 for FY 2023 but the second
installment is expected to be delayed , per reports.
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. The City relies
on the Illinois Municipal League to project this revenue and their latest projections from May 2023 show
$160.87 per capita.
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. April is the 4th month of revenue recognized for Sales
Taxes and Home Rule Sales Taxes . Returns are in line with the amounts received in YTD 2022.
The unaudited financials as of June 30, 2023 show the General Fund with a fund balance of
$55,325,557 and cash balance of $51,946,062 . The attached financials show both General Fund
revenues (at 52%) and expenses (at 54%) slightly higher than budget. General Fund Revenue s are
higher due to Charges for Services and Other Taxes coming over budget.
Revenue 2019 YTD 2020 YTD 2021 YTD 2022 YTD 2023 YTD 2023 Budget
STATE INCOME TAX 4,544,174 3,946,297 5,667,598 7,568,330 6,859,738 11,500,000
SALES TAX - BASIC 5,003,870 4,469,046 5,131,851 5,633,389 5,821,421 11,000,000
PROPERTY TAXES 5,565,162 4,186,342 5,431,974 4,659,253 5,135,869 9,057,297
SALES TAX - HOME RULE 3,019,185 2,916,993 3,647,451 4,204,040 4,366,888 8,000,000
RECREATION PROGRAM FEES 3,769,954 2,255,505 3,734,815 4,097,639 4,091,861 5,371,375
BUILDING PERMITS 2,752,649 3,065,444 3,233,619 2,512,555 2,544,461 4,225,100
LIQUOR TAX 1,617,609 1,391,203 1,393,155 1,673,754 1,877,246 3,000,000
TICKET FINES-PARKING 1,883,161 715,823 1,266,149 1,654,324 1,685,018 3,000,000
STATE USE TAX 1,004,547 1,159,896 1,440,624 1,360,209 1,447,841 2,650,000
PARKING TAX 1,464,022 1,395,415 1,247,141 1,434,715 1,386,691 2,600,000
ELECTRIC UTILITY TAX 1,455,552 1,387,442 1,385,439 1,705,961 1,355,759 2,900,000
Top General Fund Revenues YTD
General Fund Expenses by Category
Salary and Benefits are slightly over budget through June. 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 126% 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 is still being finalized that will also likely result in wage increases higher than budgeted levels.
Through June 30, 2023, Police spent 55% of budget for overtime, and Fire spent 53% of the annual
budget.
Overtime
Expenses
2022 Actual 2023 Budget 2023 YTD % Budget
Police $1,570,628 $ 1,566,349 $856,131 55%
Fire $950,226 $ 959,956 $513,376 53%
Enterprise Funds
Parking F und revenues and expenses are at 54% through June 30, 2023. The increase in fund balance
is due to a transfer from ARPA in the amount of $693,553 for staff paid out of the parking fund.
Through June 30, 2023, overall the Water Fund operating revenues and expense s 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 t he existing fund balance
until these bonds are issued.
Through June 30, 2023, the Sewer & Solid Waste Funds operating revenues and expenses came in
below budget. Capital projects budgeted under Capital Outlay have not started contributing to expenses
coming under budget.
General Fund 2023 Budget 2023 YTD Actual % of Budget 2022 Budget 2022 YTD Actual % of Budget
Expenses
Salary and Benefits 75,558,278 38,361,537 51%74,503,722 34,227,334 46%
Insurance and Other Chargebacks 28,934,436 17,863,991 62%24,383,062 13,927,945 57%
Services and Supplies 16,965,457 7,006,353 41%15,131,213 6,429,765 42%
Interfund Transfers 4,248,750 5,369,266 126%2,595,000 1,915,468 74%
Miscellaneous 694,500 100,617 14%434,500 106,634 25%
Community Sponsored Organizations 598,372 96,357 16%183,500 - 0%
Capital Outlay 617,822 83,648 14%590,390 310,190 53%
Contingencies 120,000 2,599 2%69,600 - 0%
Expenses Total 127,737,614 68,884,366 54%117,890,987 56,917,336 48%
Other Funds
Through June 30, 2023, the SSA #9 Fund is showing a fund and cash balance of $17,236. There was
a February 2023 transfer from the General Fund to SSA #9 in the amount of $206,750.
Through June 30, 2023, the Capital Improvements Fund is showing a fund balance of $3,538,933 and
a cash balance of $9,489,497. 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 . These transfers
from the General Fund to CIP are reflected in the June financials.
Through June 30, 2023, the Crown Construction fund is showing fund and cash balance of $4,923,665.
This cash balance is useful to fund any major needs of the Robert Crown center.
Through June 30, 2023, the Insurance Fund is showing a negative fund balance of $1,028,458 and a
negative cash balance of $1,209,179.
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 summar y 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 June 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 31,226,575 55%51,925,000 33,887,203 65%
Property Taxes 29,047,402 15,941,605 55%28,774,164 16,081,417 56%
Charges for Services 8,785,075 5,802,366 66%8,491,325 6,093,861 72%
Licenses, Permits and Fees 7,543,450 4,050,924 54%8,085,550 4,231,100 52%
Interfund Transfers 7,733,949 3,866,970 50%8,775,706 4,387,853 50%
Intergovernmental Revenue 3,116,184 2,000,263 64%5,961,342 4,841,209 81%
Fines and Forfeitures 3,632,500 1,941,421 53%3,723,500 1,877,341 50%
Other Revenue 11,254,054 754,271 7%2,118,100 1,531,341 72%
Interest Income 55,000 719,929 1309%55,000 113,073 206%
Revenue Total 127,737,614 66,304,324 52%117,909,687 73,044,397 62%
Expenses
13 CITY COUNCIL 658,324 276,587 42%579,384 288,923 50%
14 CITY CLERK 360,108 172,298 48%343,573 119,095 35%
15 CITY MANAGER'S OFFICE 8,143,075 6,400,755 79%6,232,882 2,962,994 48%
17 LAW 988,558 419,452 42%970,341 413,871 43%
19 ADMINISTRATIVE SERVICES 12,537,670 5,673,324 45%11,449,183 5,771,607 50%
21 COMMUNITY DEVELOPMENT 4,183,421 1,713,273 41%4,488,317 1,438,567 32%
22 POLICE 29,214,097 16,199,023 55%29,280,598 13,514,860 46%
23 FIRE MGMT & SUPPORT 18,689,924 9,935,010 53%16,823,272 8,473,157 50%
24 HEALTH 1,413,058 1,030,485 73%1,453,836 1,030,793 71%
30 PARKS AND RECREATION 12,751,313 5,170,096 41%12,101,740 4,658,483 38%
40 PUBLIC WORKS AGENCY 13,708,631 5,988,997 44%13,444,799 6,217,823 46%
99 NON-DEPARTMENTAL 25,089,436 15,905,067 63%20,723,062 12,027,164 58%
Expenses Total 127,737,614 68,884,366 54%117,890,987 56,917,336 48%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
170 AMERICAN RESCUE PLAN
Revenue
Interest Income - 663,514 - 58,165
Intergovernmental Revenue - - 21,586,827 21,586,827 100%
Revenue Total - 663,514 21,586,827 21,644,992 100%
Expenses
Capital Outlay 800,000 724,550 91%- 9,028
Interfund Transfers 2,600,000 693,553 27%8,150,000 4,075,000 50%
Services and Supplies - 470,661 - -
Miscellaneous 18,500,000 409,114 2%22,250,000 12,787 0%
Salary and Benefits - 219,543 - 400
Insurance and Other Chargebacks 850,000 62,746 7%- 29,247
Community Sponsored Organizations - - - 6,000
Expenses Total 22,750,000 2,580,166 11%30,400,000 4,132,463 14%
175 GENERAL ASSISTANCE FUND
Revenue
Property Taxes 1,300,000 706,088 54%1,300,000 732,636 56%
Interest Income 1,000 24,835 2484%1,000 2,253 225%
Other Revenue 27,500 - 0%27,500 25,713 94%
Revenue Total 1,328,500 730,923 55%1,328,500 760,601 57%
Expenses
Services and Supplies 864,482 271,149 31%864,482 275,055 32%
Salary and Benefits 469,278 244,370 52%469,871 233,887 50%
Miscellaneous 7,000 4,685 67%7,000 - 0%
Contingencies 19,460 - 0%
Expenses Total 1,360,220 520,204 38%1,341,353 508,941 38%
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 95,216 84%194,000 141,750 73%
Interest Income - 28,025 - 2,509
Other Revenue 2,000 27,336 1367%2,000 - 0%
Revenue Total 3,226,000 1,705,576 53%3,306,000 1,694,259 51%
Expenses
Salary and Benefits 2,296,809 845,429 37%1,705,820 710,517 42%
Community Sponsored Organizations 60,000 257,713 430%143,333 53,400 37%
Miscellaneous 213,000 106,033 50%258,000 63,798 25%
Services and Supplies 1,804,973 71,824 4%1,761,183 68,328 4%
Contingencies 76,476 - 0%
Insurance and Other Chargebacks - (18,805)
Expenses Total 4,451,258 1,262,195 28%3,868,336 896,043 23%
177 REPARATIONS FUND
Revenue
Other Taxes 3,400,000 1,936,780 57%400,000 - 0%
Intergovernmental Revenue - 100,000
Interest Income - 5,946 - 541
Other Revenue - 2,483 - 3,125
Revenue Total 3,400,000 2,045,208 60%400,000 3,666 1%
Expenses
Miscellaneous 3,400,000 231,381 7%400,000 100,024 25%
Services and Supplies - 987 - 1,097
Expenses Total 3,400,000 232,368 7%400,000 101,122 25%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
178 SUSTAINABILITY FUND
Revenue
Licenses, Permits and Fees 500,000 236,238 47%
Interfund Transfers 200,000 100,002 50%- 117,969
Interest Income - 5,749
Other Revenue 500,000 - 0%
Revenue Total 1,200,000 341,989 28%- 117,969
Expenses
Services and Supplies 546,000 97,479 18%
Salary and Benefits 256,893 61,775 24%
Expenses Total 802,893 159,254 20%
180 GOOD NEIGHBOR FUND
Revenue
Interest Income - 8,588 - 1,085
Revenue Total - 8,588 - 1,085
Expenses
Miscellaneous - 225,000 1,000,000 40,000 4%
Capital Outlay - 75,000 - 18,953
Services and Supplies - 98 - 201
Interfund Transfers 85,000 - 0%- -
Expenses Total 85,000 300,098 353%1,000,000 59,153 6%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
185 LIBRARY FUND
Revenue
Property Taxes 7,535,472 3,913,311 52%7,252,000 4,052,831 56%
Interest Income 21,600 123,061 570%15,000 10,787 72%
Other Revenue 405,000 81,511 20%410,000 137,344 33%
Intergovernmental Revenue 209,866 49,366 24%472,866 23,130 5%
Library Revenue 155,394 32,178 21%174,800 88,454 51%
Charges for Services 400 201 50%- 225
Interfund Transfers 250,000 - 0%217,911 - 0%
Licenses, Permits and Fees 115,767 - 0%
Revenue Total 8,577,732 4,199,628 49%8,658,344 4,312,772 50%
Expenses
Salary and Benefits 6,116,078 2,637,224 43%6,132,692 2,694,269 44%
Services and Supplies 2,247,673 866,964 39%2,136,767 926,313 43%
Interfund Transfers 305,325 152,658 50%379,653 189,827 50%
Insurance and Other Chargebacks - 2,134
Contingencies 277,466 - 0%
Capital Outlay 1,500 - 0%8,500 - 0%
Miscellaneous - 69,847
Expenses Total 8,948,042 3,658,979 41%8,657,612 3,880,255 45%
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%
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 436,437 46%680,000 104,032 15%
Expenses Total 950,000 436,437 46%680,000 104,032 15%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
200 MOTOR FUEL TAX FUND
Revenue
Intergovernmental Revenue 2,700,000 1,602,078 59%3,656,700 2,272,062 62%
Interest Income 12,000 115,535 963%12,000 12,103 101%
Revenue Total 2,712,000 1,717,613 63%3,668,700 2,284,164 62%
Expenses
Capital Outlay 2,778,600 652,954 23%3,261,000 83,029 3%
Services and Supplies 1,038,000 241,015 23%1,038,000 455,356 44%
Salary and Benefits 325,000 - 0%
Interfund Transfers 1,044,987 522,494 50%
Expenses Total 4,141,600 893,969 22%5,343,987 1,060,878 20%
205 EMERGENCY TELEPHONE (E911) FUND
Revenue
Other Taxes 1,400,000 485,375 35%1,400,000 964,280 69%
Interest Income 7,000 14,069 201%7,000 1,098 16%
Revenue Total 1,407,000 499,444 35%1,407,000 965,379 69%
Expenses
Salary and Benefits 726,389 360,837 50%768,616 372,219 48%
Services and Supplies 355,000 212,794 60%393,700 205,209 52%
Interfund Transfers 90,000 45,000 50%90,000 45,000 50%
Capital Outlay 450,000 42,291 9%450,000 35,188 8%
Insurance and Other Chargebacks 19,142 9,570 50%18,230 9,115 50%
Contingencies 31,669 - 0%
Expenses Total 1,672,200 670,493 40%1,720,546 666,731 39%
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 323,048 54%595,000 318,404 54%
Interfund Transfers 206,750 206,750 100%
Interest Income - 3,447 - 75
Revenue Total 801,750 533,245 67%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 128,065 4%3,684,820 110,178 3%
Interest Income - 1,822 - 209
Revenue Total 3,629,000 129,887 4%3,684,820 110,387 3%
Expenses
Salary and Benefits 676,384 206,510 31%589,422 184,940 31%
Insurance and Other Chargebacks - 134,787 - 127,975
Capital Outlay - 84,605
Community Sponsored Organizations 75,000 43,460 58%75,000 110,136 147%
Miscellaneous 2,576,376 13,375 1%2,515,000 7,486 0%
Services and Supplies 307,200 5,836 2%506,200 7,189 1%
Contingencies 26,075 - 0%
Expenses Total 3,661,035 488,573 13%3,685,622 437,725 12%
220 CDBG LOAN FUND
Revenue
Other Revenue 100,000 41,893 42%100,000 65,703 66%
Interest Income - 12,259 - 689
Revenue Total 100,000 54,151 54%100,000 66,392 66%
Expenses
Services and Supplies 325,000 45,002 14%175,000 - 0%
Expenses Total 325,000 45,002 14%175,000 - 0%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
235 NEIGHBORHOOD IMPROVEMENT
Revenue
Interest Income - 308 - 27
Revenue Total - 308 - 27
Expenses
Services and Supplies - 4 - 5
Expenses Total - 4 - 5
240 HOME FUND
Revenue
Other Revenue 25,000 13,692 55%25,000 20,627 83%
Interest Income 150 372 248%150 253 169%
Intergovernmental Revenue 650,000 - 0%540,453 222,190 41%
Revenue Total 675,150 14,064 2%565,603 243,070 43%
Expenses
Salary and Benefits 65,798 29,035 44%70,681 31,481 45%
Services and Supplies 582,266 620 0%500,565 246,002 49%
Contingencies 4,774 - 0%
Miscellaneous 2,000 - 0%500 - 0%
Insurance and Other Chargebacks - (6,503) - (6,853)
Expenses Total 654,838 23,152 4%571,746 270,631 47%
250 AFFORDABLE HOUSING FUND
Revenue
Other Revenue 130,600 65,000 50%140,600 65,417 47%
Interest Income 4,500 62,113 1380%5,700 3,684 65%
Intergovernmental Revenue 145,000 35,774 25%658,000 178,188 27%
Other Taxes 50,000 - 0%75,000 - 0%
Revenue Total 330,100 162,887 49%879,300 247,290 28%
Expenses
Services and Supplies 1,565,000 179,548 11%2,065,050 43,705 2%
Community Sponsored Organizations 166,000 42,307 25%166,000 169,810 102%
Salary and Benefits 130,126 34,423 26%180,075 88,845 49%
Insurance and Other Chargebacks 12,000 12,260 102%17,000 (18,000) -106%
Miscellaneous 53,500 1,023 2%67,500 2,991 4%
Capital Outlay 10,000 - 0%
Expenses Total 1,926,626 269,561 14%2,505,625 287,351 11%
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,081,587 55%13,436,256 7,968,098 59%
Interfund Transfers 2,918,969 1,159,488 40%2,267,041 1,133,520 50%
Interest Income 10,000 119,513 1195%1,500 13,261 884%
Other Revenue - -
Revenue Total 15,807,227 8,360,588 53%15,704,797 9,114,879 58%
Expenses
Debt Service 15,797,123 2,612,830 17%15,690,075 2,853,260 18%
Services and Supplies 6,600 19 0%- 3
Miscellaneous - (24,661) - 18,062
Expenses Total 15,803,723 2,588,188 16%15,690,075 2,871,325 18%
330 HOWARD-RIDGE TIF FUND
Revenue
Property Taxes 1,100,000 630,474 57%1,100,000 678,179 62%
Interest Income 10,000 51,339 513%400 5,366 1342%
Other Revenue 5,000 21,000 420%5,366 32,029 597%
Revenue Total 1,115,000 702,813 63%1,105,766 715,575 65%
Expenses
Interfund Transfers 395,913 197,958 50%398,113 199,056 50%
Miscellaneous - 122,367
Services and Supplies 250,000 52,490 21%265,000 1,695 1%
Capital Outlay 785,000 10,000 1%785,000 - 0%
Expenses Total 1,430,913 382,815 27%1,448,113 200,752 14%
335 WEST EVANSTON TIF FUND
Revenue
Property Taxes 1,450,000 808,636 56%1,450,000 995,438 69%
Interest Income 5,000 57,532 1151%4,000 6,465 162%
Other Revenue 10,000 - 0%11,000 - 0%
Revenue Total 1,465,000 866,167 59%1,465,000 1,001,903 68%
Expenses
Miscellaneous 200,000 560,000 280%200,000 - 0%
Interfund Transfers 75,000 37,500 50%75,000 37,500 50%
Services and Supplies 5,000 20,127 403%5,000 6,008 120%
Capital Outlay 3,660,000 3,492 0%1,765,000 6,767 0%
Expenses Total 3,940,000 621,118 16%2,045,000 50,274 2%
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 155,622 97%
Interest Income 1,000 9,115 912%- 735
Revenue Total 181,000 130,842 72%160,000 156,356 98%
Expenses
Interfund Transfers 174,483 87,240 50%171,833 85,916 50%
Services and Supplies 2,000 7,762 388%2,000 26 1%
Expenses Total 176,483 95,002 54%173,833 85,943 49%
345 CHICAGO-MAIN TIF
Revenue
Property Taxes 1,000,000 650,452 65%1,000,000 671,852 67%
Interest Income 2,500 44,068 1763%- 2,369
Other Revenue 1,880,000 - 0%
Revenue Total 2,882,500 694,519 24%1,000,000 674,221 67%
Expenses
Interfund Transfers 271,355 135,678 50%264,763 132,381 50%
Capital Outlay 2,469,000 64,432 3%1,090,000 44,838 4%
Miscellaneous 250,000 20,000 8%250,000 - 0%
Services and Supplies 5,000 15,124 302%5,000 31 1%
Expenses Total 2,995,355 235,234 8%1,609,763 177,250 11%
350 SPECIAL SERVICE AREA (SSA) #6
Revenue
Property Taxes 221,000 120,072 54%221,000 122,429 55%
Interest Income 250 7,453 2981%- 180
Revenue Total 221,250 127,525 58%221,000 122,609 55%
Expenses
Services and Supplies 220,000 362 0%221,000 - 0%
Expenses Total 220,000 362 0%221,000 - 0%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
355 SPECIAL SERVICE AREA (SSA) #7
Revenue
Property Taxes 142,000 77,003 54%142,000 81,991 58%
Interest Income 200 1,475 737%- 168
Revenue Total 142,200 78,477 55%142,000 82,159 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%
360 SPECIAL SERVICE AREA (SSA) #8
Revenue
Property Taxes 60,200 33,632 56%60,200 32,923 55%
Interest Income - 607 - 0
Revenue Total 60,200 34,239 57%60,200 32,924 55%
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 - 177,091
Miscellaneous - 93,609
Services and Supplies 100,000 7,761 8%
Expenses Total 100,000 278,460 278%
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 - 119,846 - 21,738
Other Revenue 17,350,000 45,505 0%12,253,000 572,853 5%
Charges for Services - 15,995 - 9,837
Revenue Total 22,027,500 3,768,072 17%12,253,000 1,560,898 13%
Expenses
Capital Outlay 22,492,500 1,688,474 8%16,455,000 1,045,432 6%
Services and Supplies - 537,638 - 747,043
Salary and Benefits - -
Miscellaneous - (30,079) - 66,369
Expenses Total 22,492,500 2,196,032 10%16,455,000 1,858,844 11%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
416 CROWN CONSTRUCTION FUND
Revenue
Interest Income 10,000 107,413 1074%- 13,400
Other Revenue 1,000,000 - 0%1,000,000 600,000 60%
Revenue Total 1,010,000 107,413 11%1,000,000 613,400 61%
Expenses
Interfund Transfers 945,000 472,500 50%900,000 450,000 50%
Miscellaneous - 16,549
Services and Supplies - 30 - 17,780
Capital Outlay 200,000 - 0%800,000 2,255 0%
Expenses Total 1,145,000 489,079 43%1,700,000 470,035 28%
417 CROWN COMMUNITY CTR MAINTENANCE
Revenue
Interfund Transfers 175,000 87,498 50%175,000 87,500 50%
Revenue Total 175,000 87,498 50%175,000 87,500 50%
Expenses
Capital Outlay 175,000 - 0%- 34,951
Expenses Total 175,000 - 0%- 34,951
420 SPECIAL ASSESSMENT FUND
Revenue
Other Taxes 125,000 83,814 67%125,000 67,536 54%
Interest Income 30,000 44,172 147%30,000 6,723 22%
Revenue Total 155,000 127,986 83%155,000 74,259 48%
Expenses
Interfund Transfers 455,360 227,676 50%464,938 232,469 50%
Capital Outlay 375,000 13,589 4%650,000 11,440 2%
Services and Supplies - 30 - 30
Expenses Total 830,360 241,295 29%1,114,938 243,939 22%
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 4,380,225 53%8,873,975 4,059,806 46%
Intergovernmental Revenue 1,100,000 693,553 63%2,300,000 1,150,000 50%
Other Revenue 486,700 271,120 56%486,700 149,768 31%
Interest Income 20,000 45,977 230%20,000 10,312 52%
Licenses, Permits and Fees - 375
Revenue Total 9,915,675 5,390,875 54%11,680,675 5,370,260 46%
Expenses
Services and Supplies 4,340,316 2,077,136 48%4,550,316 1,928,170 42%
Interfund Transfers 3,132,390 1,566,192 50%3,132,390 1,566,195 50%
Salary and Benefits 1,649,107 702,160 43%1,637,273 686,458 42%
Insurance and Other Chargebacks 369,077 184,925 50%351,502 175,751 50%
Capital Outlay 1,600,000 131,180 8%2,025,000 343,264 17%
Debt Service 76,150 18,075 24%72,900 18,950 26%
Contingencies 67,432 - 0%
Miscellaneous 50,000 (2,586) -5%50,000 6,255 13%
Expenses Total 11,284,472 4,677,081 41%11,819,381 4,725,042 40%
510 WATER FUND
Revenue
Charges for Services 24,378,734 10,961,347 45%23,443,200 10,403,630 44%
Other Revenue 51,039,150 2,794,845 5%29,834,150 941,029 3%
Interest Income 70,000 130,161 186%70,000 55,002 79%
Licenses, Permits and Fees 50,000 8,005 16%50,000 40,780 82%
Revenue Total 75,537,884 13,894,358 18%53,397,350 11,440,440 21%
Expenses
Salary and Benefits 6,835,566 2,867,520 42%6,004,605 2,829,931 47%
Interfund Transfers 4,229,559 2,114,784 50%4,229,559 3,225,702 76%
Services and Supplies 5,908,008 1,276,648 22%5,347,760 1,438,813 27%
Debt Service 4,072,486 1,268,245 31%3,596,365 1,290,240 36%
Insurance and Other Chargebacks 1,665,135 833,227 50%1,585,843 792,921 50%
Contingencies 275,576 - 0%1,000 - 0%
Capital Outlay 388,400 - 0%164,400 27,749 17%
Miscellaneous 15,000 (45,138) -301%15,000 186,676 1245%
Expenses Total 23,389,730 8,315,287 36%20,944,532 9,792,032 47%
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 2,786,384 5%33,036,000 6,759,402 20%
Services and Supplies 11,700 343,048 2932%3,465,000 307,526 9%
Interfund Transfers - (1,110,923)
Expenses Total 57,792,200 3,129,432 5%36,501,000 5,956,005 16%
515 SEWER FUND
Revenue
Charges for Services 10,240,424 4,315,764 42%10,113,594 4,325,787 43%
Interest Income 25,000 44,794 179%25,000 3,227 13%
Other Revenue 1,000 - 0%2,001,000 - 0%
Revenue Total 10,266,424 4,360,559 42%12,139,594 4,329,015 36%
Expenses
Debt Service 3,809,232 1,820,718 48%3,772,691 1,791,865 47%
Salary and Benefits 1,330,068 620,940 47%1,383,914 656,606 47%
Interfund Transfers 883,858 441,930 50%871,164 435,582 50%
Capital Outlay 3,050,700 228,771 7%3,538,100 - 0%
Insurance and Other Chargebacks 369,800 184,902 50%352,190 176,095 50%
Contingencies 56,511 - 0%
Miscellaneous 1,500 (17,081) -1139%1,500 45,997 3066%
Services and Supplies 1,750,300 (23,427) -1%1,471,800 206,104 14%
Expenses Total 11,251,969 3,256,754 29%11,391,359 3,312,249 29%
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 2,131,587 46%4,516,450 2,204,255 49%
Property Taxes 1,332,500 666,250 50%1,332,500 666,250 50%
Licenses, Permits and Fees 389,000 163,600 42%297,000 176,901 60%
Other Revenue 122,000 53,078 44%122,000 120,803 99%
Interest Income - 4,940
Revenue Total 6,512,500 3,019,454 46%6,267,950 3,168,209 51%
Expenses
Services and Supplies 3,935,115 1,552,076 39%3,786,776 1,685,356 45%
Salary and Benefits 1,582,205 749,999 47%1,492,909 747,141 50%
Interfund Transfers 322,000 160,998 50%302,000 607,470 201%
Capital Outlay 525,000 28,854 5%525,000 143,913 27%
Miscellaneous 15,000 9,816 65%15,000 8,790 59%
Contingencies 69,205 - 0%
Expenses Total 6,448,525 2,501,743 39%6,121,685 3,192,670 52%
600 FLEET SERVICES FUND
Revenue
Charges for Services 3,244,440 1,622,214 50%3,127,440 1,553,720 50%
Other Revenue 69,000 3,780 5%69,000 15,102 22%
Interest Income 1,000 - 0%1,000 - 0%
Revenue Total 3,314,440 1,625,994 49%3,197,440 1,568,822 49%
Expenses
Services and Supplies 2,044,557 1,077,736 53%2,034,507 1,055,920 52%
Salary and Benefits 1,364,942 692,849 51%1,276,621 587,450 46%
Capital Outlay - 184,456
Contingencies 52,480 - 0%
Insurance and Other Chargebacks - 900
Expenses Total 3,461,979 1,955,040 56%3,311,128 1,644,270 50%
Funds 2023 Budget 2023 Actual YTD % of Budget 2022 Budget 2022 Actual YTD % of Budget
601 EQUIPMENT REPLACEMENT FUND
Revenue
Charges for Services 754,885 377,442 50%224,885 112,442 50%
Other Revenue 25,000 77,597 310%960,217 841,299 88%
Interest Income - 8,904
Intergovernmental Revenue 1,500,000 - 0%1,600,000 800,000 50%
Revenue Total 2,279,885 463,942 20%2,785,102 1,753,742 63%
Expenses
Capital Outlay 2,700,000 1,014,851 38%2,750,000 1,392,195 51%
Services and Supplies - 98
Debt Service - 8,188
Expenses Total 2,700,000 1,014,949 38%2,750,000 1,400,383 51%
605 INSURANCE FUND
Revenue
Other Revenue 11,448,112 5,207,393 45%11,248,243 5,147,311 46%
Insurance 9,444,453 4,712,428 50%8,827,914 4,525,191 51%
Workers Compensation and Liability 862,500 748,785 87%825,000 376,651 46%
Charges for Services - 129 - 16,291
Revenue Total 21,755,065 10,668,735 49%20,901,157 10,065,444 48%
Expenses
Insurance and Other Chargebacks 16,765,000 7,805,077 47%16,957,400 8,451,448 50%
Services and Supplies 3,244,200 1,715,356 53%2,994,200 1,876,729 63%
Salary and Benefits 4,287 29,563 690%4,751 59,318 1248%
Expenses Total 20,013,487 9,549,996 48%19,956,351 10,387,495 52%