HomeMy WebLinkAbout2022.01 January Monthly Report
To: Kelley A. Gandurski, Interim City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: January 2022 Monthly Financial Report
Date: March 14, 2022
Please find attached the unaudited financial statements as of January 31, 2022. A summary by fund
for revenues, expenditures, fund and cash balances is as follows:
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 January 31, 2022. 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.
General Fund
The unaudited financial statements show the General Fund as of January 31, 2022 with a fund
balance of $32,230,609 and cash balance of $28,378,521. The attached financials show General
Fund revenues at 8% of budget and expenses at 6% of budget.
Overall, revenues are slightly below target. This is primarily because the City receives most of its
property tax revenue in February and March, as the first installment was due on March 1, 2022.
Expenses are also lower than target because of lower supplies, services, and program expenses in
January.
Staff continues to monitor Police and Fire overtime expenses. Through January, Police had spent
10% of budget for overtime, and Fire had spent 12% of the annual budget.
Overtime
Expenses
2021 Actual 2022 Budget 2022 YTD % Budget
Enterprise Funds
Parking fund revenues through January 31, 2022 are at 6% of budget and expenses are at 5%.
Through January 31, 2022 , the Water Fund appears low on revenue and expenses. This is because
capital projects funded with IEPA loan/debt will take place later in the year/next year. These projects
are budgeted in Other Revenue and expenses in Capital Outlay.
Through January 31, 2022, the Sewer Fund also appears low on expenses mainly due to the capital
projects and debt service payments occurring later in the year.
Through January 31, 2022, the Solid Waste Fund has a fund balance of $855,643 and a negative
cash balance of $358,435.
Other Funds
Through January 31, 2022, the SSA #9 Fund is showing negative fund and cash balance of $206,557.
Through January 31, 2022, the Capital Improvements Fund is showing a fund balance of $11,622,634
and a cash balance of $12,235,908. The fund continues to spend down Series 2021 and Series 2020
bond proceeds.
Through January 31, 2022, the Crown Construction fund is showing fund and cash balance of
$5,655,868. The fund continues to spend down balances from bond proceeds and gifts from the
Friends of Robert Crown.
Through January 31, 2022, the Insurance Fund is showing a negative fund balance of $6,264,134 and
a negative cash balance of $2,228,102. Fund balance is significantly lower than cash balance due to
accrued liabilities for pending litigations.
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 January 31, 2022 year -to-date financial information and reports
which to the best of my knowledge appear accurate and complete.
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
REVENUE
12 LEGISLATIVE .00 .00 .00 .00 +++(200.00)
14 CITY CLERK 80,500.00 48.00 48.00 80,452.00 0 49.00
15 CITY MANAGER'S OFFICE 76,832,408.00 7,259,071.23 7,259,071.23 69,573,336.77 9 80,094,178.78
17 LAW 537,000.00 48,554.75 48,554.75 488,445.25 9 503,273.80
19 ADMINISTRATIVE SERVICES 3,432,000.00 330,016.77 330,016.77 3,101,983.23 10 3,623,013.25
21 COMMUNITY DEVELOPMENT 4,974,700.00 493,600.61 493,600.61 4,481,099.39 10 6,171,539.34
22 POLICE 1,188,000.00 57,626.51 57,626.51 1,130,373.49 5 12,573,125.87
23 FIRE MGMT & SUPPORT 3,043,600.00 608,362.41 608,362.41 2,435,237.59 20 13,402,233.85
24 HEALTH 874,242.00 400,884.13 400,884.13 473,357.87 46 1,537,028.50
26 PUBLIC WORKS .00 .00 .00 .00 +++5.00
30 PARKS AND RECREATION 5,580,175.00 229,875.57 229,875.57 5,350,299.43 4 6,363,294.76
40 PUBLIC WORKS AGENCY 644,000.00 6,689.45 6,689.45 637,310.55 1 345,990.52
99 NON-DEPARTMENTAL 20,723,062.00 .00 .00 20,723,062.00 0 .00
REVENUE TOTALS $117,909,687.00 $9,434,729.43 $9,434,729.43 $108,474,957.57 8%$124,613,532.67
EXPENSE
12 LEGISLATIVE .00 .00 .00 .00 +++1,245.00
13 CITY COUNCIL 579,384.00 46,261.56 46,261.56 533,122.44 8 532,053.69
14 CITY CLERK 343,573.00 13,056.03 13,056.03 330,516.97 4 200,368.83
15 CITY MANAGER'S OFFICE 6,232,882.39 363,838.38 363,838.38 5,869,044.01 6 6,259,698.97
17 LAW 970,341.14 49,076.95 49,076.95 921,264.19 5 538,570.70
19 ADMINISTRATIVE SERVICES 11,449,182.64 528,284.71 528,284.71 10,920,897.93 5 10,999,336.83
21 COMMUNITY DEVELOPMENT 4,488,316.71 214,407.81 214,407.81 4,273,908.90 5 3,441,972.15
22 POLICE 29,280,597.55 2,165,196.61 2,165,196.61 27,115,400.94 7 39,668,310.09
23 FIRE MGMT & SUPPORT 16,823,271.83 1,530,579.45 1,530,579.45 15,292,692.38 9 26,237,840.19
24 HEALTH 1,453,836.00 130,489.62 130,489.62 1,323,346.38 9 1,999,306.65
30 PARKS AND RECREATION 12,101,740.47 503,432.60 503,432.60 11,598,307.87 4 11,218,562.68
40 PUBLIC WORKS AGENCY 13,444,799.45 975,841.26 975,841.26 12,468,958.19 7 11,864,194.00
99 NON-DEPARTMENTAL 20,723,062.00 .00 .00 20,723,062.00 0 .00
EXPENSE TOTALS $117,890,987.18 $6,520,464.98 $6,520,464.98 $111,370,522.20 6%$112,961,459.78
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 117,909,687.00 9,434,729.43 9,434,729.43 108,474,957.57 8%124,613,532.67
EXPENSE TOTALS 117,890,987.18 6,520,464.98 6,520,464.98 111,370,522.20 6%112,961,459.78
Fund 100 - GENERAL FUND Net Gain (Loss)$18,699.82 $2,914,264.45 $2,914,264.45 $2,895,564.63 15,584%$11,652,072.89
Fund Type GENERAL FUND Totals
Page 1 of 2Run by Jessica Tapia on 03/15/2022 12:56:27 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualOrganizationOrganization Description
Fund Category Governmental Funds
REVENUE TOTALS 117,909,687.00 9,434,729.43 9,434,729.43 108,474,957.57 8%124,613,532.67
EXPENSE TOTALS 117,890,987.18 6,520,464.98 6,520,464.98 111,370,522.20 6%112,961,459.78
Fund Type GENERAL FUND Net Gain (Loss)$18,699.82 $2,914,264.45 $2,914,264.45 $2,895,564.63 15,584%$11,652,072.89
Fund Category Governmental Funds Totals
REVENUE TOTALS 117,909,687.00 9,434,729.43 9,434,729.43 108,474,957.57 8%124,613,532.67
EXPENSE TOTALS 117,890,987.18 6,520,464.98 6,520,464.98 111,370,522.20 6%112,961,459.78
Fund Category Governmental Funds Net Gain (Loss)$18,699.82 $2,914,264.45 $2,914,264.45 $2,895,564.63 15,584%$11,652,072.89
Grand Totals
REVENUE TOTALS 117,909,687.00 9,434,729.43 9,434,729.43 108,474,957.57 8%124,613,532.67
EXPENSE TOTALS 117,890,987.18 6,520,464.98 6,520,464.98 111,370,522.20 6%112,961,459.78
Grand Total Net Gain (Loss)$18,699.82 $2,914,264.45 $2,914,264.45 $2,895,564.63 15,584%$11,652,072.89
Page 2 of 2Run by Jessica Tapia on 03/15/2022 12:56:27 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualOrganizationOrganization Description
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes 3,110,000.00 .00 .00 3,110,000.00 0 3,110,000.00
Interfund Transfers .00 .00 .00 .00 +++450,000.00
Intergovernmental Revenue 194,000.00 26,588.67 26,588.67 167,411.33 14 221,265.60
Other Revenue 2,000.00 .00 .00 2,000.00 0 2,940.00
Interest Income .00 461.16 461.16 (461.16)+++1,601.63
Department 24 - HEALTH Totals $3,306,000.00 $27,049.83 $27,049.83 $3,278,950.17 1%$3,785,807.23
REVENUE TOTALS $3,306,000.00 $27,049.83 $27,049.83 $3,278,950.17 1%$3,785,807.23
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 736,373.00 .00 .00 736,373.00 0 .00
Department 21 - COMMUNITY DEVELOPMENT Totals $736,373.00 $0.00 $0.00 $736,373.00 0%$0.00
Department 24 - HEALTH
Salary and Benefits 1,705,819.94 105,232.64 105,232.64 1,600,587.30 6 1,580,847.63
Services and Supplies 1,024,810.00 230.50 230.50 1,024,579.50 0 460,374.37
Insurance and Other Chargebacks .00 .00 .00 .00 +++8,861.29
Community Sponsored Organizations 143,333.00 .00 .00 143,333.00 0 498,019.53
Miscellaneous 258,000.00 13,200.41 13,200.41 244,799.59 5 175,643.87
Department 24 - HEALTH Totals $3,131,962.94 $118,663.55 $118,663.55 $3,013,299.39 4%$2,723,746.69
EXPENSE TOTALS $3,868,335.94 $118,663.55 $118,663.55 $3,749,672.39 3%$2,723,746.69
Fund 176 - HUMAN SERVICES FUND Totals
REVENUE TOTALS 3,306,000.00 27,049.83 27,049.83 3,278,950.17 1%3,785,807.23
EXPENSE TOTALS 3,868,335.94 118,663.55 118,663.55 3,749,672.39 3%2,723,746.69
Fund 176 - HUMAN SERVICES FUND Net Gain (Loss)($562,335.94)($91,613.72)($91,613.72)$470,722.22 16%$1,062,060.54
Page 1 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 170 - AMERICAN RESCUE PLAN
REVENUE
Department 99 - NON-DEPARTMENTAL
Intergovernmental Revenue 21,586,827.00 .00 .00 21,586,827.00 0 21,586,827.00
Interest Income .00 2,141.98 2,141.98 (2,141.98)+++26,544.74
Department 99 - NON-DEPARTMENTAL Totals $21,586,827.00 $2,141.98 $2,141.98 $21,584,685.02 0%$21,613,371.74
REVENUE TOTALS $21,586,827.00 $2,141.98 $2,141.98 $21,584,685.02 0%$21,613,371.74
EXPENSE
Department 99 - NON-DEPARTMENTAL
Miscellaneous 22,250,000.00 .00 .00 22,250,000.00 0 .00
Interfund Transfers 8,150,000.00 679,166.67 679,166.67 7,470,833.33 8 4,800,000.00
Department 99 - NON-DEPARTMENTAL Totals $30,400,000.00 $679,166.67 $679,166.67 $29,720,833.33 2%$4,800,000.00
EXPENSE TOTALS $30,400,000.00 $679,166.67 $679,166.67 $29,720,833.33 2%$4,800,000.00
Fund 170 - AMERICAN RESCUE PLAN Totals
REVENUE TOTALS 21,586,827.00 2,141.98 2,141.98 21,584,685.02 0%21,613,371.74
EXPENSE TOTALS 30,400,000.00 679,166.67 679,166.67 29,720,833.33 2%4,800,000.00
Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss)($8,813,173.00)($677,024.69)($677,024.69)$8,136,148.31 8%$16,813,371.74
Page 3 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Department 24 - HEALTH
Property Taxes 1,300,000.00 3,709.83 3,709.83 1,296,290.17 0 1,318,390.85
Other Revenue 27,500.00 25,276.56 25,276.56 2,223.44 92 2,585.00
Interest Income 1,000.00 121.02 121.02 878.98 12 1,445.64
Department 24 - HEALTH Totals $1,328,500.00 $29,107.41 $29,107.41 $1,299,392.59 2%$1,322,421.49
REVENUE TOTALS $1,328,500.00 $29,107.41 $29,107.41 $1,299,392.59 2%$1,322,421.49
EXPENSE
Department 24 - HEALTH
Salary and Benefits 469,870.53 36,752.94 36,752.94 433,117.59 8 495,273.49
Services and Supplies 864,482.00 41,527.28 41,527.28 822,954.72 5 601,335.93
Miscellaneous 7,000.00 .00 .00 7,000.00 0 4,676.28
Department 24 - HEALTH Totals $1,341,352.53 $78,280.22 $78,280.22 $1,263,072.31 6%$1,101,285.70
EXPENSE TOTALS $1,341,352.53 $78,280.22 $78,280.22 $1,263,072.31 6%$1,101,285.70
Fund 175 - GENERAL ASSISTANCE FUND Totals
REVENUE TOTALS 1,328,500.00 29,107.41 29,107.41 1,299,392.59 2%1,322,421.49
EXPENSE TOTALS 1,341,352.53 78,280.22 78,280.22 1,263,072.31 6%1,101,285.70
Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss)($12,852.53)($49,172.81)($49,172.81)($36,320.28)383%$221,135.79
Page 4 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 177 - REPARATIONS FUND
REVENUE
Department 15 - CITY MANAGER'S OFFICE
Other Taxes 400,000.00 .00 .00 400,000.00 0 .00
Other Revenue .00 2,500.00 2,500.00 (2,500.00)+++48,187.29
Interest Income .00 42.68 42.68 (42.68)+++391.22
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $2,542.68 $2,542.68 $397,457.32 1%$48,578.51
REVENUE TOTALS $400,000.00 $2,542.68 $2,542.68 $397,457.32 1%$48,578.51
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Services and Supplies .00 254.98 254.98 (254.98)+++2,095.79
Miscellaneous 400,000.00 .00 .00 400,000.00 0 .00
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $254.98 $254.98 $399,745.02 0%$2,095.79
EXPENSE TOTALS $400,000.00 $254.98 $254.98 $399,745.02 0%$2,095.79
Fund 177 - REPARATIONS FUND Totals
REVENUE TOTALS 400,000.00 2,542.68 2,542.68 397,457.32 1%48,578.51
EXPENSE TOTALS 400,000.00 254.98 254.98 399,745.02 0%2,095.79
Fund 177 - REPARATIONS FUND Net Gain (Loss)$0.00 $2,287.70 $2,287.70 $2,287.70 +++$46,482.72
Page 5 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Other Revenue .00 .00 .00 .00 +++1,000,000.00
Interest Income .00 162.43 162.43 (162.43)+++883.93
Department 99 - NON-DEPARTMENTAL Totals $0.00 $162.43 $162.43 ($162.43)+++$1,000,883.93
REVENUE TOTALS $0.00 $162.43 $162.43 ($162.43)+++$1,000,883.93
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 66.35 66.35 (66.35)+++466.38
Miscellaneous 1,000,000.00 .00 .00 1,000,000.00 0 34,920.59
Interfund Transfers .00 .00 .00 .00 +++414,151.77
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $66.35 $66.35 $999,933.65 0%$449,538.74
EXPENSE TOTALS $1,000,000.00 $66.35 $66.35 $999,933.65 0%$449,538.74
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS .00 162.43 162.43 (162.43)+++1,000,883.93
EXPENSE TOTALS 1,000,000.00 66.35 66.35 999,933.65 0%449,538.74
Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss)($1,000,000.00)$96.08 $96.08 $1,000,096.08 0%$551,345.19
Page 6 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 185 - LIBRARY FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 7,252,000.00 19,251.33 19,251.33 7,232,748.67 0 7,298,616.48
Licenses, Permits and Fees 115,767.00 .00 .00 115,767.00 0 .00
Fines and Forfeitures .00 .00 .00 .00 +++4,466.46
Charges for Services .00 34.58 34.58 (34.58)+++287.03
Interfund Transfers 217,911.00 .00 .00 217,911.00 0 250,000.00
Intergovernmental Revenue 472,866.00 .00 .00 472,866.00 0 330,037.73
Other Revenue 410,000.00 (67,734.92)(67,734.92)477,734.92 (17)438,206.07
Library Revenue 174,800.00 (639.66)(639.66)175,439.66 0 118,262.91
Interest Income 15,000.00 514.86 514.86 14,485.14 3 10,403.29
Department 48 - LIBRARY Totals $8,658,344.00 ($48,573.81)($48,573.81)$8,706,917.81 (1%)$8,450,279.97
REVENUE TOTALS $8,658,344.00 ($48,573.81)($48,573.81)$8,706,917.81 (1%)$8,450,279.97
EXPENSE
Department 48 - LIBRARY
Salary and Benefits 6,132,692.20 267,021.66 267,021.66 5,865,670.54 4 5,514,203.32
Services and Supplies 2,136,767.00 3,874.71 3,874.71 2,132,892.29 0 2,017,185.97
Capital Outlay 8,500.00 .00 .00 8,500.00 0 1,463.52
Depreciation Expense .00 13,405.90 13,405.90 (13,405.90)+++.00
Miscellaneous .00 .00 .00 .00 +++1,500.00
Interfund Transfers 379,653.00 31,637.75 31,637.75 348,015.25 8 361,212.00
Department 48 - LIBRARY Totals $8,657,612.20 $315,940.02 $315,940.02 $8,341,672.18 4%$7,895,564.81
EXPENSE TOTALS $8,657,612.20 $315,940.02 $315,940.02 $8,341,672.18 4%$7,895,564.81
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 8,658,344.00 (48,573.81)(48,573.81)8,706,917.81 (1%)8,450,279.97
EXPENSE TOTALS 8,657,612.20 315,940.02 315,940.02 8,341,672.18 4%7,895,564.81
Fund 185 - LIBRARY FUND Net Gain (Loss)$731.80 ($364,513.83)($364,513.83)($365,245.63)(49,811%)$554,715.16
Page 7 of 41Run by Jessica Tapia on 03/16/2022 17:41:38 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Intergovernmental Revenue 3,656,700.00 276,988.48 276,988.48 3,379,711.52 8 4,558,025.05
Interest Income 12,000.00 594.91 594.91 11,405.09 5 4,985.72
Department 40 - PUBLIC WORKS AGENCY Totals $3,668,700.00 $277,583.39 $277,583.39 $3,391,116.61 8%$4,563,010.77
REVENUE TOTALS $3,668,700.00 $277,583.39 $277,583.39 $3,391,116.61 8%$4,563,010.77
EXPENSE
Department 26 - PUBLIC WORKS
Capital Outlay .00 .00 .00 .00 +++163,434.00
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$163,434.00
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies 1,038,000.00 .00 .00 1,038,000.00 0 844,024.91
Capital Outlay 3,261,000.00 .00 .00 3,261,000.00 0 1,389,278.60
Interfund Transfers 1,044,987.00 87,082.25 87,082.25 957,904.75 8 1,044,984.00
Department 40 - PUBLIC WORKS AGENCY Totals $5,343,987.00 $87,082.25 $87,082.25 $5,256,904.75 2%$3,278,287.51
EXPENSE TOTALS $5,343,987.00 $87,082.25 $87,082.25 $5,256,904.75 2%$3,441,721.51
Fund 200 - MOTOR FUEL TAX FUND Totals
REVENUE TOTALS 3,668,700.00 277,583.39 277,583.39 3,391,116.61 8%4,563,010.77
EXPENSE TOTALS 5,343,987.00 87,082.25 87,082.25 5,256,904.75 2%3,441,721.51
Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss)($1,675,287.00)$190,501.14 $190,501.14 $1,865,788.14 (11%)$1,121,289.26
Page 8 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Department 22 - POLICE
Other Taxes 1,400,000.00 .00 .00 1,400,000.00 0 1,442,228.44
Other Revenue .00 .00 .00 .00 +++641.17
Interest Income 7,000.00 178.16 178.16 6,821.84 3 735.62
Department 22 - POLICE Totals $1,407,000.00 $178.16 $178.16 $1,406,821.84 0%$1,443,605.23
REVENUE TOTALS $1,407,000.00 $178.16 $178.16 $1,406,821.84 0%$1,443,605.23
EXPENSE
Department 22 - POLICE
Salary and Benefits 768,615.60 56,597.89 56,597.89 712,017.71 7 601,010.24
Services and Supplies 393,700.00 13,690.83 13,690.83 380,009.17 3 340,785.60
Capital Outlay 450,000.00 .00 .00 450,000.00 0 256,588.76
Insurance and Other Chargebacks 18,230.00 1,519.17 1,519.17 16,710.83 8 18,228.00
Miscellaneous .00 .00 .00 .00 +++1,000.00
Interfund Transfers 90,000.00 7,500.00 7,500.00 82,500.00 8 90,000.00
Department 22 - POLICE Totals $1,720,545.60 $79,307.89 $79,307.89 $1,641,237.71 5%$1,307,612.60
EXPENSE TOTALS $1,720,545.60 $79,307.89 $79,307.89 $1,641,237.71 5%$1,307,612.60
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals
REVENUE TOTALS 1,407,000.00 178.16 178.16 1,406,821.84 0%1,443,605.23
EXPENSE TOTALS 1,720,545.60 79,307.89 79,307.89 1,641,237.71 5%1,307,612.60
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss)($313,545.60)($79,129.73)($79,129.73)$234,415.87 25%$135,992.63
Page 9 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 210 - SPECIAL SERVICE AREA (SSA) #9
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Property Taxes 595,000.00 193.41 193.41 594,806.59 0 603,007.19
Interest Income .00 .00 .00 .00 +++28.29
Department 21 - COMMUNITY DEVELOPMENT Totals $595,000.00 $193.41 $193.41 $594,806.59 0%$603,035.48
REVENUE TOTALS $595,000.00 $193.41 $193.41 $594,806.59 0%$603,035.48
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 575,000.00 .00 .00 575,000.00 0 595,125.30
Department 21 - COMMUNITY DEVELOPMENT Totals $575,000.00 $0.00 $0.00 $575,000.00 0%$595,125.30
EXPENSE TOTALS $575,000.00 $0.00 $0.00 $575,000.00 0%$595,125.30
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals
REVENUE TOTALS 595,000.00 193.41 193.41 594,806.59 0%603,035.48
EXPENSE TOTALS 575,000.00 .00 .00 575,000.00 0%595,125.30
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss)$20,000.00 $193.41 $193.41 ($19,806.59)1%$7,910.18
Page 10 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 215 - CDBG FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue 3,684,820.00 .00 .00 3,684,820.00 0 2,317,923.49
Department 21 - COMMUNITY DEVELOPMENT Totals $3,684,820.00 $0.00 $0.00 $3,684,820.00 0%$2,317,923.49
REVENUE TOTALS $3,684,820.00 $0.00 $0.00 $3,684,820.00 0%$2,317,923.49
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 589,421.52 28,659.33 28,659.33 560,762.19 5 356,130.39
Services and Supplies 506,200.00 6.44 6.44 506,193.56 0 42,137.12
Capital Outlay .00 .00 .00 .00 +++476,341.73
Insurance and Other Chargebacks .00 .00 .00 .00 +++352,222.69
Community Sponsored Organizations 75,000.00 .00 .00 75,000.00 0 927,080.49
Miscellaneous 2,515,000.00 .00 .00 2,515,000.00 0 164,011.07
Department 21 - COMMUNITY DEVELOPMENT Totals $3,685,621.52 $28,665.77 $28,665.77 $3,656,955.75 1%$2,317,923.49
EXPENSE TOTALS $3,685,621.52 $28,665.77 $28,665.77 $3,656,955.75 1%$2,317,923.49
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 3,684,820.00 .00 .00 3,684,820.00 0%2,317,923.49
EXPENSE TOTALS 3,685,621.52 28,665.77 28,665.77 3,656,955.75 1%2,317,923.49
Fund 215 - CDBG FUND Net Gain (Loss)($801.52)($28,665.77)($28,665.77)($27,864.25)3,576%$0.00
Page 11 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 220 - CDBG LOAN FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Revenue 100,000.00 3,568.88 3,568.88 96,431.12 4 172,475.57
Interest Income .00 80.68 80.68 (80.68)+++.00
Department 21 - COMMUNITY DEVELOPMENT Totals $100,000.00 $3,649.56 $3,649.56 $96,350.44 4%$172,475.57
REVENUE TOTALS $100,000.00 $3,649.56 $3,649.56 $96,350.44 4%$172,475.57
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 175,000.00 .00 .00 175,000.00 0 44,369.59
Department 21 - COMMUNITY DEVELOPMENT Totals $175,000.00 $0.00 $0.00 $175,000.00 0%$44,369.59
EXPENSE TOTALS $175,000.00 $0.00 $0.00 $175,000.00 0%$44,369.59
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 100,000.00 3,649.56 3,649.56 96,350.44 4%172,475.57
EXPENSE TOTALS 175,000.00 .00 .00 175,000.00 0%44,369.59
Fund 220 - CDBG LOAN FUND Net Gain (Loss)($75,000.00)$3,649.56 $3,649.56 $78,649.56 (5%)$128,105.98
Page 12 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Interest Income .00 3.98 3.98 (3.98)+++22.09
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $3.98 $3.98 ($3.98)+++$22.09
REVENUE TOTALS $0.00 $3.98 $3.98 ($3.98)+++$22.09
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies .00 1.63 1.63 (1.63)+++11.24
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $1.63 $1.63 ($1.63)+++$11.24
EXPENSE TOTALS $0.00 $1.63 $1.63 ($1.63)+++$11.24
Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals
REVENUE TOTALS .00 3.98 3.98 (3.98)+++22.09
EXPENSE TOTALS .00 1.63 1.63 (1.63)+++11.24
Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss)$0.00 $2.35 $2.35 $2.35 +++$10.85
Page 13 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 240 - HOME FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue 540,453.00 .00 .00 540,453.00 0 504,713.62
Other Revenue 25,000.00 125.00 125.00 24,875.00 1 35,955.41
Interest Income 150.00 6.59 6.59 143.41 4 94.16
Department 21 - COMMUNITY DEVELOPMENT Totals $565,603.00 $131.59 $131.59 $565,471.41 0%$540,763.19
REVENUE TOTALS $565,603.00 $131.59 $131.59 $565,471.41 0%$540,763.19
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 70,680.63 4,885.04 4,885.04 65,795.59 7 58,507.28
Services and Supplies 500,565.00 5.24 5.24 500,559.76 0 488,948.85
Insurance and Other Chargebacks .00 .00 .00 .00 +++(2,965.34)
Miscellaneous 500.00 .00 .00 500.00 0 101.50
Department 21 - COMMUNITY DEVELOPMENT Totals $571,745.63 $4,890.28 $4,890.28 $566,855.35 1%$544,592.29
EXPENSE TOTALS $571,745.63 $4,890.28 $4,890.28 $566,855.35 1%$544,592.29
Fund 240 - HOME FUND Totals
REVENUE TOTALS 565,603.00 131.59 131.59 565,471.41 0%540,763.19
EXPENSE TOTALS 571,745.63 4,890.28 4,890.28 566,855.35 1%544,592.29
Fund 240 - HOME FUND Net Gain (Loss)($6,142.63)($4,758.69)($4,758.69)$1,383.94 77%($3,829.10)
Page 14 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Taxes 75,000.00 .00 .00 75,000.00 0 15,453.00
Intergovernmental Revenue 658,000.00 .00 .00 658,000.00 0 640,638.06
Other Revenue 140,600.00 .00 .00 140,600.00 0 129,166.70
Interest Income 5,700.00 432.95 432.95 5,267.05 8 7,428.56
Department 21 - COMMUNITY DEVELOPMENT Totals $879,300.00 $432.95 $432.95 $878,867.05 0%$792,686.32
REVENUE TOTALS $879,300.00 $432.95 $432.95 $878,867.05 0%$792,686.32
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 180,075.00 13,710.95 13,710.95 166,364.05 8 174,931.83
Services and Supplies 2,065,050.00 5.00 5.00 2,065,045.00 0 1,294,027.21
Capital Outlay 10,000.00 .00 .00 10,000.00 0 4,200.00
Insurance and Other Chargebacks 17,000.00 .00 .00 17,000.00 0 (54,375.72)
Community Sponsored Organizations 166,000.00 .00 .00 166,000.00 0 507,564.69
Miscellaneous 67,500.00 1,182.50 1,182.50 66,317.50 2 19,413.66
Department 21 - COMMUNITY DEVELOPMENT Totals $2,505,625.00 $14,898.45 $14,898.45 $2,490,726.55 1%$1,945,761.67
EXPENSE TOTALS $2,505,625.00 $14,898.45 $14,898.45 $2,490,726.55 1%$1,945,761.67
Fund 250 - AFFORDABLE HOUSING FUND Totals
REVENUE TOTALS 879,300.00 432.95 432.95 878,867.05 0%792,686.32
EXPENSE TOTALS 2,505,625.00 14,898.45 14,898.45 2,490,726.55 1%1,945,761.67
Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss)($1,626,325.00)($14,465.50)($14,465.50)$1,611,859.50 1%($1,153,075.35)
Fund Type Special Revenue Funds Totals
REVENUE TOTALS 42,874,094.00 267,553.73 267,553.73 42,606,540.27 1%43,337,233.10
EXPENSE TOTALS 56,376,489.48 1,288,554.51 1,288,554.51 55,087,934.97 2%24,445,602.73
Fund Type Special Revenue Funds Net Gain (Loss)($13,502,395.48)($1,021,000.78)($1,021,000.78)$12,481,394.70 8%$18,891,630.37
Page 16 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 506,625.00 .00 .00 506,625.00 0 482,243.00
Department 48 - LIBRARY Totals $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.00
REVENUE TOTALS $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.00
EXPENSE
Department 48 - LIBRARY
Debt Service 506,625.00 .00 .00 506,625.00 0 482,243.89
Department 48 - LIBRARY Totals $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.89
EXPENSE TOTALS $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.89
Fund 186 - LIBRARY DEBT SERVICE FUND Totals
REVENUE TOTALS 506,625.00 .00 .00 506,625.00 0%482,243.00
EXPENSE TOTALS 506,625.00 .00 .00 506,625.00 0%482,243.89
Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss)$0.00 $0.00 $0.00 $0.00 +++($0.89)
Page 17 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,100,000.00 .00 .00 1,100,000.00 0 1,241,923.98
Other Revenue 5,366.00 3,947.23 3,947.23 1,418.77 74 27,381.64
Interest Income 400.00 348.51 348.51 51.49 87 6,384.08
Department 99 - NON-DEPARTMENTAL Totals $1,105,766.00 $4,295.74 $4,295.74 $1,101,470.26 0%$1,275,689.70
REVENUE TOTALS $1,105,766.00 $4,295.74 $4,295.74 $1,101,470.26 0%$1,275,689.70
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 265,000.00 .80 .80 264,999.20 0 155,849.02
Capital Outlay 785,000.00 .00 .00 785,000.00 0 391,989.20
Miscellaneous .00 .00 .00 .00 +++18,200.00
Interfund Transfers 398,113.00 33,176.08 33,176.08 364,936.92 8 218,112.00
Department 99 - NON-DEPARTMENTAL Totals $1,448,113.00 $33,176.88 $33,176.88 $1,414,936.12 2%$784,150.22
EXPENSE TOTALS $1,448,113.00 $33,176.88 $33,176.88 $1,414,936.12 2%$784,150.22
Fund 330 - HOWARD-RIDGE TIF FUND Totals
REVENUE TOTALS 1,105,766.00 4,295.74 4,295.74 1,101,470.26 0%1,275,689.70
EXPENSE TOTALS 1,448,113.00 33,176.88 33,176.88 1,414,936.12 2%784,150.22
Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss)($342,347.00)($28,881.14)($28,881.14)$313,465.86 8%$491,539.48
Page 18 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,450,000.00 4,362.55 4,362.55 1,445,637.45 0 1,774,424.08
Other Revenue 11,000.00 .00 .00 11,000.00 0 171,504.26
Interest Income 4,000.00 134.45 134.45 3,865.55 3 5,468.09
Department 99 - NON-DEPARTMENTAL Totals $1,465,000.00 $4,497.00 $4,497.00 $1,460,503.00 0%$1,951,396.43
REVENUE TOTALS $1,465,000.00 $4,497.00 $4,497.00 $1,460,503.00 0%$1,951,396.43
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 1,665.72 1,665.72 3,334.28 33 68,183.57
Capital Outlay 1,765,000.00 .00 .00 1,765,000.00 0 332,637.00
Miscellaneous 200,000.00 .00 .00 200,000.00 0 18,000.00
Interfund Transfers 75,000.00 6,250.00 6,250.00 68,750.00 8 75,000.00
Department 99 - NON-DEPARTMENTAL Totals $2,045,000.00 $7,915.72 $7,915.72 $2,037,084.28 0%$493,820.57
EXPENSE TOTALS $2,045,000.00 $7,915.72 $7,915.72 $2,037,084.28 0%$493,820.57
Fund 335 - WEST EVANSTON TIF FUND Totals
REVENUE TOTALS 1,465,000.00 4,497.00 4,497.00 1,460,503.00 0%1,951,396.43
EXPENSE TOTALS 2,045,000.00 7,915.72 7,915.72 2,037,084.28 0%493,820.57
Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss)($580,000.00)($3,418.72)($3,418.72)$576,581.28 1%$1,457,575.86
Page 19 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 160,000.00 .00 .00 160,000.00 0 282,948.21
Interest Income .00 13.34 13.34 (13.34)+++538.94
Department 99 - NON-DEPARTMENTAL Totals $160,000.00 $13.34 $13.34 $159,986.66 0%$283,487.15
REVENUE TOTALS $160,000.00 $13.34 $13.34 $159,986.66 0%$283,487.15
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 2,000.00 .32 .32 1,999.68 0 1,821.75
Interfund Transfers 171,833.00 14,319.41 14,319.41 157,513.59 8 168,924.00
Department 99 - NON-DEPARTMENTAL Totals $173,833.00 $14,319.73 $14,319.73 $159,513.27 8%$170,745.75
EXPENSE TOTALS $173,833.00 $14,319.73 $14,319.73 $159,513.27 8%$170,745.75
Fund 340 - DEMPSTER-DODGE TIF FUND Totals
REVENUE TOTALS 160,000.00 13.34 13.34 159,986.66 0%283,487.15
EXPENSE TOTALS 173,833.00 14,319.73 14,319.73 159,513.27 8%170,745.75
Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss)($13,833.00)($14,306.39)($14,306.39)($473.39)103%$112,741.40
Page 20 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,000,000.00 7,824.98 7,824.98 992,175.02 1 1,207,607.53
Interest Income .00 39.60 39.60 (39.60)+++2,772.11
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $7,864.58 $7,864.58 $992,135.42 1%$1,210,379.64
REVENUE TOTALS $1,000,000.00 $7,864.58 $7,864.58 $992,135.42 1%$1,210,379.64
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 .95 .95 4,999.05 0 1,835.12
Capital Outlay 1,090,000.00 .00 .00 1,090,000.00 0 1,308,890.49
Miscellaneous 250,000.00 .00 .00 250,000.00 0 9,950.00
Interfund Transfers 264,763.00 22,063.58 22,063.58 242,699.42 8 262,848.00
Department 99 - NON-DEPARTMENTAL Totals $1,609,763.00 $22,064.53 $22,064.53 $1,587,698.47 1%$1,583,523.61
EXPENSE TOTALS $1,609,763.00 $22,064.53 $22,064.53 $1,587,698.47 1%$1,583,523.61
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 1,000,000.00 7,864.58 7,864.58 992,135.42 1%1,210,379.64
EXPENSE TOTALS 1,609,763.00 22,064.53 22,064.53 1,587,698.47 1%1,583,523.61
Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss)($609,763.00)($14,199.95)($14,199.95)$595,563.05 2%($373,143.97)
Page 21 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 221,000.00 1,452.50 1,452.50 219,547.50 1 221,554.12
Interest Income .00 .16 .16 (.16)+++66.54
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 $1,452.66 $1,452.66 $219,547.34 1%$221,620.66
REVENUE TOTALS $221,000.00 $1,452.66 $1,452.66 $219,547.34 1%$221,620.66
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 221,000.00 .00 .00 221,000.00 0 223,914.21
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 $0.00 $0.00 $221,000.00 0%$223,914.21
EXPENSE TOTALS $221,000.00 $0.00 $0.00 $221,000.00 0%$223,914.21
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals
REVENUE TOTALS 221,000.00 1,452.66 1,452.66 219,547.34 1%221,620.66
EXPENSE TOTALS 221,000.00 .00 .00 221,000.00 0%223,914.21
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss)$0.00 $1,452.66 $1,452.66 $1,452.66 +++($2,293.55)
Page 22 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 355 - SPECIAL SERVICE AREA (SSA) #7
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 142,000.00 2,149.49 2,149.49 139,850.51 2 144,157.43
Interest Income .00 3.04 3.04 (3.04)+++102.44
Department 99 - NON-DEPARTMENTAL Totals $142,000.00 $2,152.53 $2,152.53 $139,847.47 2%$144,259.87
REVENUE TOTALS $142,000.00 $2,152.53 $2,152.53 $139,847.47 2%$144,259.87
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 140,000.00 .07 .07 139,999.93 0 73,741.11
Department 99 - NON-DEPARTMENTAL Totals $140,000.00 $0.07 $0.07 $139,999.93 0%$73,741.11
EXPENSE TOTALS $140,000.00 $0.07 $0.07 $139,999.93 0%$73,741.11
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals
REVENUE TOTALS 142,000.00 2,152.53 2,152.53 139,847.47 2%144,259.87
EXPENSE TOTALS 140,000.00 .07 .07 139,999.93 0%73,741.11
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss)$2,000.00 $2,152.46 $2,152.46 $152.46 108%$70,518.76
Page 23 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 360 - SPECIAL SERVICE AREA (SSA) #8
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 60,200.00 .00 .00 60,200.00 0 49,544.06
Interest Income .00 .04 .04 (.04)+++11,207.75
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $0.04 $0.04 $60,199.96 0%$60,751.81
REVENUE TOTALS $60,200.00 $0.04 $0.04 $60,199.96 0%$60,751.81
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 60,200.00 .00 .00 60,200.00 0 120,737.27
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $0.00 $0.00 $60,200.00 0%$120,737.27
EXPENSE TOTALS $60,200.00 $0.00 $0.00 $60,200.00 0%$120,737.27
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals
REVENUE TOTALS 60,200.00 .04 .04 60,199.96 0%60,751.81
EXPENSE TOTALS 60,200.00 .00 .00 60,200.00 0%120,737.27
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss)$0.00 $0.04 $0.04 $0.04 +++($59,985.46)
Fund Type Debt Service Funds Totals
REVENUE TOTALS 4,660,591.00 20,275.89 20,275.89 4,640,315.11 0%5,629,828.26
EXPENSE TOTALS 6,204,534.00 77,476.93 77,476.93 6,127,057.07 1%3,932,876.63
Fund Type Debt Service Funds Net Gain (Loss)($1,543,943.00)($57,201.04)($57,201.04)$1,486,741.96 4%$1,696,951.63
Page 24 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Department 48 - LIBRARY
Other Revenue 480,000.00 .00 .00 480,000.00 0 .00
Department 48 - LIBRARY Totals $480,000.00 $0.00 $0.00 $480,000.00 0%$0.00
REVENUE TOTALS $480,000.00 $0.00 $0.00 $480,000.00 0%$0.00
EXPENSE
Department 48 - LIBRARY
Capital Outlay 680,000.00 .00 .00 680,000.00 0 405,832.11
Department 48 - LIBRARY Totals $680,000.00 $0.00 $0.00 $680,000.00 0%$405,832.11
EXPENSE TOTALS $680,000.00 $0.00 $0.00 $680,000.00 0%$405,832.11
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Totals
REVENUE TOTALS 480,000.00 .00 .00 480,000.00 0%.00
EXPENSE TOTALS 680,000.00 .00 .00 680,000.00 0%405,832.11
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss)($200,000.00)$0.00 $0.00 $200,000.00 0%($405,832.11)
Page 25 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 320 - DEBT SERVICE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 13,436,256.00 40,752.05 40,752.05 13,395,503.95 0 14,316,070.00
Interfund Transfers 2,267,041.00 188,920.08 188,920.08 2,078,120.92 8 1,197,420.00
Other Revenue .00 .00 .00 .00 +++4,007,188.01
Interest Income 1,500.00 726.75 726.75 773.25 48 14,056.67
Department 99 - NON-DEPARTMENTAL Totals $15,704,797.00 $230,398.88 $230,398.88 $15,474,398.12 1%$19,534,734.68
REVENUE TOTALS $15,704,797.00 $230,398.88 $230,398.88 $15,474,398.12 1%$19,534,734.68
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 .00 .00 .00 +++56,520.35
Depreciation Expense .00 3,466.70 3,466.70 (3,466.70)+++.00
Debt Service 15,690,075.00 .00 .00 15,690,075.00 0 18,909,105.88
Department 99 - NON-DEPARTMENTAL Totals $15,690,075.00 $3,466.70 $3,466.70 $15,686,608.30 0%$18,965,626.23
EXPENSE TOTALS $15,690,075.00 $3,466.70 $3,466.70 $15,686,608.30 0%$18,965,626.23
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 15,704,797.00 230,398.88 230,398.88 15,474,398.12 1%19,534,734.68
EXPENSE TOTALS 15,690,075.00 3,466.70 3,466.70 15,686,608.30 0%18,965,626.23
Fund 320 - DEBT SERVICE FUND Net Gain (Loss)$14,722.00 $226,932.18 $226,932.18 $212,210.18 1,541%$569,108.45
Page 26 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services .00 .00 .00 .00 +++168,794.05
Intergovernmental Revenue .00 .00 .00 .00 +++340,579.38
Other Revenue 12,253,000.00 .00 .00 12,253,000.00 0 9,029,158.15
Interest Income .00 1,975.01 1,975.01 (1,975.01)+++14,158.15
Department 40 - PUBLIC WORKS AGENCY Totals $12,253,000.00 $1,975.01 $1,975.01 $12,251,024.99 0%$9,552,689.73
Department 99 - NON-DEPARTMENTAL
Other Revenue .00 .00 .00 .00 +++(80,880.22)
Interest Income .00 .00 .00 .00 +++892.68
Department 99 - NON-DEPARTMENTAL Totals $0.00 $0.00 $0.00 $0.00 +++($79,987.54)
REVENUE TOTALS $12,253,000.00 $1,975.01 $1,975.01 $12,251,024.99 0%$9,472,702.19
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits .00 .00 .00 .00 +++710,222.39
Services and Supplies .00 5.00 5.00 (5.00)+++2,036,840.31
Capital Outlay 16,455,000.00 .00 .00 16,455,000.00 0 5,585,783.68
Miscellaneous .00 1,026.81 1,026.81 (1,026.81)+++.00
Department 40 - PUBLIC WORKS AGENCY Totals $16,455,000.00 $1,031.81 $1,031.81 $16,453,968.19 0%$8,332,846.38
Department 99 - NON-DEPARTMENTAL
Depreciation Expense .00 9,941.74 9,941.74 (9,941.74)+++.00
Department 99 - NON-DEPARTMENTAL Totals $0.00 $9,941.74 $9,941.74 ($9,941.74)+++$0.00
EXPENSE TOTALS $16,455,000.00 $10,973.55 $10,973.55 $16,444,026.45 0%$8,332,846.38
Fund 415 - CAPITAL IMPROVEMENTS FUND Totals
REVENUE TOTALS 12,253,000.00 1,975.01 1,975.01 12,251,024.99 0%9,472,702.19
EXPENSE TOTALS 16,455,000.00 10,973.55 10,973.55 16,444,026.45 0%8,332,846.38
Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss)($4,202,000.00)($8,998.54)($8,998.54)$4,193,001.46 0%$1,139,855.81
Page 27 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Intergovernmental Revenue .00 .00 .00 .00 +++1,000,000.00
Other Revenue 1,000,000.00 .00 .00 1,000,000.00 0 2,800,000.00
Interest Income .00 1,054.94 1,054.94 (1,054.94)+++12,174.21
Department 40 - PUBLIC WORKS AGENCY Totals $1,000,000.00 $1,054.94 $1,054.94 $998,945.06 0%$3,812,174.21
REVENUE TOTALS $1,000,000.00 $1,054.94 $1,054.94 $998,945.06 0%$3,812,174.21
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies .00 5.00 5.00 (5.00)+++13,829.13
Capital Outlay 800,000.00 .00 .00 800,000.00 0 699,411.48
Interfund Transfers 900,000.00 75,000.00 75,000.00 825,000.00 8 .00
Department 40 - PUBLIC WORKS AGENCY Totals $1,700,000.00 $75,005.00 $75,005.00 $1,624,995.00 4%$713,240.61
EXPENSE TOTALS $1,700,000.00 $75,005.00 $75,005.00 $1,624,995.00 4%$713,240.61
Fund 416 - CROWN CONSTRUCTION FUND Totals
REVENUE TOTALS 1,000,000.00 1,054.94 1,054.94 998,945.06 0%3,812,174.21
EXPENSE TOTALS 1,700,000.00 75,005.00 75,005.00 1,624,995.00 4%713,240.61
Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss)($700,000.00)($73,950.06)($73,950.06)$626,049.94 11%$3,098,933.60
Page 28 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Interfund Transfers 175,000.00 14,583.33 14,583.33 160,416.67 8 174,996.00
Department 40 - PUBLIC WORKS AGENCY Totals $175,000.00 $14,583.33 $14,583.33 $160,416.67 8%$174,996.00
REVENUE TOTALS $175,000.00 $14,583.33 $14,583.33 $160,416.67 8%$174,996.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals
REVENUE TOTALS 175,000.00 14,583.33 14,583.33 160,416.67 8%174,996.00
EXPENSE TOTALS .00 .00 .00 .00 +++.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss)$175,000.00 $14,583.33 $14,583.33 ($160,416.67)8%$174,996.00
Page 29 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Department 26 - PUBLIC WORKS
Other Taxes 125,000.00 42,126.31 42,126.31 82,873.69 34 97,651.61
Other Revenue .00 .00 .00 .00 +++(1,109.75)
Interest Income 30,000.00 4,332.08 4,332.08 25,667.92 14 17,656.23
Department 26 - PUBLIC WORKS Totals $155,000.00 $46,458.39 $46,458.39 $108,541.61 30%$114,198.09
REVENUE TOTALS $155,000.00 $46,458.39 $46,458.39 $108,541.61 30%$114,198.09
EXPENSE
Department 26 - PUBLIC WORKS
Services and Supplies .00 5.00 5.00 (5.00)+++60.00
Department 26 - PUBLIC WORKS Totals $0.00 $5.00 $5.00 ($5.00)+++$60.00
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay 650,000.00 .00 .00 650,000.00 0 144,685.95
Interfund Transfers 464,938.00 38,744.84 38,744.84 426,193.16 8 489,324.00
Department 40 - PUBLIC WORKS AGENCY Totals $1,114,938.00 $38,744.84 $38,744.84 $1,076,193.16 3%$634,009.95
EXPENSE TOTALS $1,114,938.00 $38,749.84 $38,749.84 $1,076,188.16 3%$634,069.95
Fund 420 - SPECIAL ASSESSMENT FUND Totals
REVENUE TOTALS 155,000.00 46,458.39 46,458.39 108,541.61 30%114,198.09
EXPENSE TOTALS 1,114,938.00 38,749.84 38,749.84 1,076,188.16 3%634,069.95
Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss)($959,938.00)$7,708.55 $7,708.55 $967,646.55 (1%)($519,871.86)
Fund Type Capital Project Funds Totals
REVENUE TOTALS 29,767,797.00 294,470.55 294,470.55 29,473,326.45 1%33,108,805.17
EXPENSE TOTALS 35,640,013.00 128,195.09 128,195.09 35,511,817.91 0%29,051,615.28
Fund Type Capital Project Funds Net Gain (Loss)($5,872,216.00)$166,275.46 $166,275.46 $6,038,491.46 (3%)$4,057,189.89
Fund Category Governmental Funds Totals
REVENUE TOTALS 80,608,482.00 609,350.00 609,350.00 79,999,132.00 1%86,079,667.14
EXPENSE TOTALS 102,089,372.42 1,612,890.08 1,612,890.08 100,476,482.34 2%60,382,990.69
Fund Category Governmental Funds Net Gain (Loss)($21,480,890.42)($1,003,540.08)($1,003,540.08)$20,477,350.34 5%$25,696,676.45
Page 30 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 505 - PARKING SYSTEM FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Licenses, Permits and Fees .00 .00 .00 .00 +++375.00
Charges for Services 8,873,975.00 436,422.55 436,422.55 8,437,552.45 5 7,686,900.24
Intergovernmental Revenue 2,300,000.00 191,666.67 191,666.67 2,108,333.33 8 950,000.00
Other Revenue 486,700.00 16,489.82 16,489.82 470,210.18 3 335,233.97
Interest Income 20,000.00 421.90 421.90 19,578.10 2 38,999.24
Department 19 - ADMINISTRATIVE SERVICES Totals $11,680,675.00 $645,000.94 $645,000.94 $11,035,674.06 6%$9,011,508.45
REVENUE TOTALS $11,680,675.00 $645,000.94 $645,000.94 $11,035,674.06 6%$9,011,508.45
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Salary and Benefits 334,851.42 21,747.75 21,747.75 313,103.67 6 251,903.29
Department 15 - CITY MANAGER'S OFFICE Totals $334,851.42 $21,747.75 $21,747.75 $313,103.67 6%$251,903.29
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 813,004.00 48,831.96 48,831.96 764,172.04 6 711,286.79
Services and Supplies 4,550,316.00 214,856.88 214,856.88 4,335,459.12 5 3,786,085.86
Capital Outlay 2,025,000.00 .00 .00 2,025,000.00 0 353,162.79
Insurance and Other Chargebacks 351,502.00 29,291.83 29,291.83 322,210.17 8 351,504.00
Debt Service 72,900.00 .00 .00 72,900.00 0 47,164.44
Miscellaneous 50,000.00 .00 .00 50,000.00 0 .00
Interfund Transfers 3,132,390.00 261,032.50 261,032.50 2,871,357.50 8 3,132,384.00
Department 19 - ADMINISTRATIVE SERVICES Totals $10,995,112.00 $554,013.17 $554,013.17 $10,441,098.83 5%$8,381,587.88
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 489,417.38 39,156.58 39,156.58 450,260.80 8 519,338.04
Miscellaneous .00 .00 .00 .00 +++300.00
Department 40 - PUBLIC WORKS AGENCY Totals $489,417.38 $39,156.58 $39,156.58 $450,260.80 8%$519,638.04
EXPENSE TOTALS $11,819,380.80 $614,917.50 $614,917.50 $11,204,463.30 5%$9,153,129.21
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS 11,680,675.00 645,000.94 645,000.94 11,035,674.06 6%9,011,508.45
EXPENSE TOTALS 11,819,380.80 614,917.50 614,917.50 11,204,463.30 5%9,153,129.21
Fund 505 - PARKING SYSTEM FUND Net Gain (Loss)($138,705.80)$30,083.44 $30,083.44 $168,789.24 (22%)($141,620.76)
Page 31 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 510 - WATER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Licenses, Permits and Fees 50,000.00 200.00 200.00 49,800.00 0 50,696.30
Charges for Services 23,443,200.00 1,623,950.09 1,623,950.09 21,819,249.91 7 20,561,055.26
Intergovernmental Revenue .00 .00 .00 .00 +++3,000,000.00
Other Revenue 29,834,150.00 92.61 92.61 29,834,057.39 0 2,257,500.64
Interest Income 70,000.00 17,442.83 17,442.83 52,557.17 25 46,780.41
Department 40 - PUBLIC WORKS AGENCY Totals $53,397,350.00 $1,641,685.53 $1,641,685.53 $51,755,664.47 3%$25,916,032.61
Department 71 - UTILITIES
Other Revenue .00 .00 .00 .00 +++2,772,225.94
Department 71 - UTILITIES Totals $0.00 $0.00 $0.00 $0.00 +++$2,772,225.94
REVENUE TOTALS $53,397,350.00 $1,641,685.53 $1,641,685.53 $51,755,664.47 3%$28,688,258.55
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 6,004,605.36 449,218.00 449,218.00 5,555,387.36 7 5,798,903.33
Services and Supplies 5,347,760.00 8,927.42 8,927.42 5,338,832.58 0 3,438,090.15
Capital Outlay 164,400.00 .00 .00 164,400.00 0 21,950.00
Insurance and Other Chargebacks .00 .00 .00 .00 +++19,484.16
Depreciation Expense .00 37,378.71 37,378.71 (37,378.71)+++.00
Contingencies 1,000.00 .00 .00 1,000.00 0 28.75
Miscellaneous 15,000.00 .00 .00 15,000.00 0 9,180.19
Interfund Transfers 180,000.00 1,125,922.51 1,125,922.51 (945,922.51)626 (930,922.51)
Department 40 - PUBLIC WORKS AGENCY Totals $11,712,765.36 $1,621,446.64 $1,621,446.64 $10,091,318.72 14%$8,356,714.07
Department 71 - UTILITIES
Services and Supplies .00 .00 .00 .00 +++34,179.81
Insurance and Other Chargebacks 1,585,843.00 132,153.58 132,153.58 1,453,689.42 8 1,539,648.00
Debt Service 3,596,365.00 .00 .00 3,596,365.00 0 6,388,574.04
Interfund Transfers 4,049,559.00 337,463.25 337,463.25 3,712,095.75 8 4,049,568.00
Department 71 - UTILITIES Totals $9,231,767.00 $469,616.83 $469,616.83 $8,762,150.17 5%$12,011,969.85
EXPENSE TOTALS $20,944,532.36 $2,091,063.47 $2,091,063.47 $18,853,468.89 10%$20,368,683.92
Fund 510 - WATER FUND Totals
REVENUE TOTALS 53,397,350.00 1,641,685.53 1,641,685.53 51,755,664.47 3%28,688,258.55
EXPENSE TOTALS 20,944,532.36 2,091,063.47 2,091,063.47 18,853,468.89 10%20,368,683.92
Fund 510 - WATER FUND Net Gain (Loss)$32,452,817.64 ($449,377.94)($449,377.94)($32,902,195.58)(1%)$8,319,574.63
Page 32 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND
EXPENSE
Department 71 - UTILITIES
Services and Supplies 3,465,000.00 34,100.00 34,100.00 3,430,900.00 1 468,530.30
Capital Outlay 33,036,000.00 .00 .00 33,036,000.00 0 5,563,648.03
Interfund Transfers .00 (1,110,922.51)(1,110,922.51)1,110,922.51 +++1,110,922.51
Department 71 - UTILITIES Totals $36,501,000.00 ($1,076,822.51)($1,076,822.51)$37,577,822.51 (3%)$7,143,100.84
EXPENSE TOTALS $36,501,000.00 ($1,076,822.51)($1,076,822.51)$37,577,822.51 (3%)$7,143,100.84
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals
REVENUE TOTALS .00 .00 .00 .00 +++.00
EXPENSE TOTALS 36,501,000.00 (1,076,822.51)(1,076,822.51)37,577,822.51 (3%)7,143,100.84
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss)($36,501,000.00)$1,076,822.51 $1,076,822.51 $37,577,822.51 (3%)($7,143,100.84)
Page 33 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 515 - SEWER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services 10,113,594.00 604,057.09 604,057.09 9,509,536.91 6 10,350,791.78
Other Revenue 2,001,000.00 .00 .00 2,001,000.00 0 (10,632.04)
Interest Income 25,000.00 294.05 294.05 24,705.95 1 4,547.39
Department 40 - PUBLIC WORKS AGENCY Totals $12,139,594.00 $604,351.14 $604,351.14 $11,535,242.86 5%$10,344,707.13
REVENUE TOTALS $12,139,594.00 $604,351.14 $604,351.14 $11,535,242.86 5%$10,344,707.13
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,383,914.00 103,701.52 103,701.52 1,280,212.48 7 1,354,112.64
Services and Supplies 1,471,800.00 436.15 436.15 1,471,363.85 0 1,982,019.49
Capital Outlay 3,538,100.00 .00 .00 3,538,100.00 0 198,816.30
Insurance and Other Chargebacks 352,190.00 29,349.17 29,349.17 322,840.83 8 332,256.00
Depreciation Expense .00 8,828.33 8,828.33 (8,828.33)+++.00
Miscellaneous 1,500.00 .00 .00 1,500.00 0 500.00
Interfund Transfers 871,164.00 72,597.01 72,597.01 798,566.99 8 855,384.00
Department 40 - PUBLIC WORKS AGENCY Totals $7,618,668.00 $214,912.18 $214,912.18 $7,403,755.82 3%$4,723,088.43
Department 71 - UTILITIES
Debt Service 3,772,691.00 19,460.79 19,460.79 3,753,230.21 1 5,195,204.19
Department 71 - UTILITIES Totals $3,772,691.00 $19,460.79 $19,460.79 $3,753,230.21 1%$5,195,204.19
EXPENSE TOTALS $11,391,359.00 $234,372.97 $234,372.97 $11,156,986.03 2%$9,918,292.62
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 12,139,594.00 604,351.14 604,351.14 11,535,242.86 5%10,344,707.13
EXPENSE TOTALS 11,391,359.00 234,372.97 234,372.97 11,156,986.03 2%9,918,292.62
Fund 515 - SEWER FUND Net Gain (Loss)$748,235.00 $369,978.17 $369,978.17 ($378,256.83)49%$426,414.51
Page 34 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 520 - SOLID WASTE FUND
REVENUE
Department 26 - PUBLIC WORKS
Charges for Services .00 .00 .00 .00 +++3,331.00
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$3,331.00
Department 40 - PUBLIC WORKS AGENCY
Property Taxes 1,332,500.00 .00 .00 1,332,500.00 0 1,332,500.00
Licenses, Permits and Fees 297,000.00 16,965.00 16,965.00 280,035.00 6 293,124.87
Charges for Services 4,516,450.00 332,251.84 332,251.84 4,184,198.16 7 4,538,514.91
Other Revenue 122,000.00 91,731.84 91,731.84 30,268.16 75 133,951.81
Department 40 - PUBLIC WORKS AGENCY Totals $6,267,950.00 $440,948.68 $440,948.68 $5,827,001.32 7%$6,298,091.59
REVENUE TOTALS $6,267,950.00 $440,948.68 $440,948.68 $5,827,001.32 7%$6,301,422.59
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,492,909.00 113,876.72 113,876.72 1,379,032.28 8 1,475,880.59
Services and Supplies 3,786,776.00 186,213.68 186,213.68 3,600,562.32 5 3,636,763.72
Capital Outlay 525,000.00 2,165.00 2,165.00 522,835.00 0 455,668.27
Miscellaneous 15,000.00 .00 .00 15,000.00 0 8,806.23
Interfund Transfers 302,000.00 25,166.67 25,166.67 276,833.33 8 302,004.00
Department 40 - PUBLIC WORKS AGENCY Totals $6,121,685.00 $327,422.07 $327,422.07 $5,794,262.93 5%$5,879,122.81
EXPENSE TOTALS $6,121,685.00 $327,422.07 $327,422.07 $5,794,262.93 5%$5,879,122.81
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 6,267,950.00 440,948.68 440,948.68 5,827,001.32 7%6,301,422.59
EXPENSE TOTALS 6,121,685.00 327,422.07 327,422.07 5,794,262.93 5%5,879,122.81
Fund 520 - SOLID WASTE FUND Net Gain (Loss)$146,265.00 $113,526.61 $113,526.61 ($32,738.39)78%$422,299.78
Fund Type Enterprise Funds Totals
REVENUE TOTALS 83,485,569.00 3,331,986.29 3,331,986.29 80,153,582.71 4%54,345,896.72
EXPENSE TOTALS 86,777,957.16 2,190,953.50 2,190,953.50 84,587,003.66 3%52,462,329.40
Fund Type Enterprise Funds Net Gain (Loss)($3,292,388.16)$1,141,032.79 $1,141,032.79 $4,433,420.95 (35%)$1,883,567.32
Page 35 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 600 - FLEET SERVICES FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services 3,127,440.00 258,953.33 258,953.33 2,868,486.67 8 3,107,436.00
Other Revenue 69,000.00 .00 .00 69,000.00 0 15,773.20
Interest Income 1,000.00 .00 .00 1,000.00 0 .00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,197,440.00 $258,953.33 $258,953.33 $2,938,486.67 8%$3,123,209.20
REVENUE TOTALS $3,197,440.00 $258,953.33 $258,953.33 $2,938,486.67 8%$3,123,209.20
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 1,276,620.55 98,516.07 98,516.07 1,178,104.48 8 1,169,515.40
Services and Supplies 2,034,507.00 24,006.44 24,006.44 2,010,500.56 1 1,928,363.52
Capital Outlay .00 .00 .00 .00 +++22,858.68
Insurance and Other Chargebacks .00 899.88 899.88 (899.88)+++18,168.28
Miscellaneous .00 .00 .00 .00 +++600.00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,311,127.55 $123,422.39 $123,422.39 $3,187,705.16 4%$3,139,505.88
EXPENSE TOTALS $3,311,127.55 $123,422.39 $123,422.39 $3,187,705.16 4%$3,139,505.88
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,197,440.00 258,953.33 258,953.33 2,938,486.67 8%3,123,209.20
EXPENSE TOTALS 3,311,127.55 123,422.39 123,422.39 3,187,705.16 4%3,139,505.88
Fund 600 - FLEET SERVICES FUND Net Gain (Loss)($113,687.55)$135,530.94 $135,530.94 $249,218.49 (119%)($16,296.68)
Page 36 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services 224,885.00 18,740.40 18,740.40 206,144.60 8 224,868.00
Intergovernmental Revenue 1,600,000.00 133,333.33 133,333.33 1,466,666.67 8 850,000.00
Other Revenue 960,217.00 .00 .00 960,217.00 0 157,294.00
Interest Income .00 .00 .00 .00 +++200.07
Department 19 - ADMINISTRATIVE SERVICES Totals $2,785,102.00 $152,073.73 $152,073.73 $2,633,028.27 5%$1,232,362.07
REVENUE TOTALS $2,785,102.00 $152,073.73 $152,073.73 $2,633,028.27 5%$1,232,362.07
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Services and Supplies .00 .00 .00 .00 +++101.15
Capital Outlay 2,750,000.00 .00 .00 2,750,000.00 0 1,367.42
Department 19 - ADMINISTRATIVE SERVICES Totals $2,750,000.00 $0.00 $0.00 $2,750,000.00 0%$1,468.57
Department 26 - PUBLIC WORKS
Depreciation Expense .00 .00 .00 .00 +++1,525,498.02
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$1,525,498.02
EXPENSE TOTALS $2,750,000.00 $0.00 $0.00 $2,750,000.00 0%$1,526,966.59
Fund 601 - EQUIPMENT REPLACEMENT FUND Totals
REVENUE TOTALS 2,785,102.00 152,073.73 152,073.73 2,633,028.27 5%1,232,362.07
EXPENSE TOTALS 2,750,000.00 .00 .00 2,750,000.00 0%1,526,966.59
Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss)$35,102.00 $152,073.73 $152,073.73 $116,971.73 433%($294,604.52)
Page 37 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 605 - INSURANCE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Charges for Services .00 .00 .00 .00 +++7,170.63
Other Revenue 11,248,243.00 863,557.06 863,557.06 10,384,685.94 8 10,440,070.43
Workers Compensation and Liability 825,000.00 62,500.00 62,500.00 762,500.00 8 1,581,986.03
Insurance 8,827,914.00 543,062.51 543,062.51 8,284,851.49 6 9,278,100.45
Department 99 - NON-DEPARTMENTAL Totals $20,901,157.00 $1,469,119.57 $1,469,119.57 $19,432,037.43 7%$21,307,327.54
REVENUE TOTALS $20,901,157.00 $1,469,119.57 $1,469,119.57 $19,432,037.43 7%$21,307,327.54
EXPENSE
Department 99 - NON-DEPARTMENTAL
Salary and Benefits 4,751.36 22,997.96 22,997.96 (18,246.60)484 612,438.27
Services and Supplies 2,994,200.00 1,090,289.05 1,090,289.05 1,903,910.95 36 1,884,045.60
Insurance and Other Chargebacks 16,957,400.00 1,340,780.10 1,340,780.10 15,616,619.90 8 15,626,040.77
Miscellaneous .00 .00 .00 .00 +++300.00
Department 99 - NON-DEPARTMENTAL Totals $19,956,351.36 $2,454,067.11 $2,454,067.11 $17,502,284.25 12%$18,122,824.64
EXPENSE TOTALS $19,956,351.36 $2,454,067.11 $2,454,067.11 $17,502,284.25 12%$18,122,824.64
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 20,901,157.00 1,469,119.57 1,469,119.57 19,432,037.43 7%21,307,327.54
EXPENSE TOTALS 19,956,351.36 2,454,067.11 2,454,067.11 17,502,284.25 12%18,122,824.64
Fund 605 - INSURANCE FUND Net Gain (Loss)$944,805.64 ($984,947.54)($984,947.54)($1,929,753.18)(104%)$3,184,502.90
Fund Type Internal Service Funds Totals
REVENUE TOTALS 26,883,699.00 1,880,146.63 1,880,146.63 25,003,552.37 7%25,662,898.81
EXPENSE TOTALS 26,017,478.91 2,577,489.50 2,577,489.50 23,439,989.41 10%22,789,297.11
Fund Type Internal Service Funds Net Gain (Loss)$866,220.09 ($697,342.87)($697,342.87)($1,563,562.96)(81%)$2,873,601.70
Fund Category Proprietary Funds Totals
REVENUE TOTALS 110,369,268.00 5,212,132.92 5,212,132.92 105,157,135.08 5%80,008,795.53
EXPENSE TOTALS 112,795,436.07 4,768,443.00 4,768,443.00 108,026,993.07 4%75,251,626.51
Fund Category Proprietary Funds Net Gain (Loss)($2,426,168.07)$443,689.92 $443,689.92 $2,869,857.99 (18%)$4,757,169.02
Page 38 of 41Run by Jessica Tapia on 03/16/2022 17:41:39 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 700 - FIRE PENSION FUND
REVENUE
Department 23 - FIRE MGMT & SUPPORT
Other Revenue 11,764,044.00 (4,435,239.30)(4,435,239.30)16,199,283.30 (38)20,999,855.36
Interest Income 2,500,000.00 117,814.59 117,814.59 2,382,185.41 5 3,441,785.24
Department 23 - FIRE MGMT & SUPPORT Totals $14,264,044.00 ($4,317,424.71)($4,317,424.71)$18,581,468.71 (30%)$24,441,640.60
REVENUE TOTALS $14,264,044.00 ($4,317,424.71)($4,317,424.71)$18,581,468.71 (30%)$24,441,640.60
EXPENSE
Department 23 - FIRE MGMT & SUPPORT
Salary and Benefits 11,318,287.00 919,139.85 919,139.85 10,399,147.15 8 10,665,154.60
Miscellaneous 225,000.00 25,341.42 25,341.42 199,658.58 11 214,660.65
Department 23 - FIRE MGMT & SUPPORT Totals $11,543,287.00 $944,481.27 $944,481.27 $10,598,805.73 8%$10,879,815.25
EXPENSE TOTALS $11,543,287.00 $944,481.27 $944,481.27 $10,598,805.73 8%$10,879,815.25
Fund 700 - FIRE PENSION FUND Totals
REVENUE TOTALS 14,264,044.00 (4,317,424.71)(4,317,424.71)18,581,468.71 (30%)24,441,640.60
EXPENSE TOTALS 11,543,287.00 944,481.27 944,481.27 10,598,805.73 8%10,879,815.25
Fund 700 - FIRE PENSION FUND Net Gain (Loss)$2,720,757.00 ($5,261,905.98)($5,261,905.98)($7,982,662.98)(193%)$13,561,825.35
Page 39 of 41Run by Jessica Tapia on 03/16/2022 17:41:40 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 705 - POLICE PENSION FUND
REVENUE
Department 22 - POLICE
Other Revenue 17,481,538.00 (8,923,020.71)(8,923,020.71)26,404,558.71 (51)36,164,184.57
Interest Income 1,500,000.00 155,486.44 155,486.44 1,344,513.56 10 3,591,523.09
Department 22 - POLICE Totals $18,981,538.00 ($8,767,534.27)($8,767,534.27)$27,749,072.27 (46%)$39,755,707.66
REVENUE TOTALS $18,981,538.00 ($8,767,534.27)($8,767,534.27)$27,749,072.27 (46%)$39,755,707.66
EXPENSE
Department 22 - POLICE
Salary and Benefits 15,814,448.00 1,551,353.72 1,551,353.72 14,263,094.28 10 14,968,884.24
Miscellaneous 300,000.00 19,003.14 19,003.14 280,996.86 6 348,090.41
Department 22 - POLICE Totals $16,114,448.00 $1,570,356.86 $1,570,356.86 $14,544,091.14 10%$15,316,974.65
EXPENSE TOTALS $16,114,448.00 $1,570,356.86 $1,570,356.86 $14,544,091.14 10%$15,316,974.65
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS 18,981,538.00 (8,767,534.27)(8,767,534.27)27,749,072.27 (46%)39,755,707.66
EXPENSE TOTALS 16,114,448.00 1,570,356.86 1,570,356.86 14,544,091.14 10%15,316,974.65
Fund 705 - POLICE PENSION FUND Net Gain (Loss)$2,867,090.00 ($10,337,891.13)($10,337,891.13)($13,204,981.13)(361%)$24,438,733.01
Fund Type Pension Trust Funds Totals
REVENUE TOTALS 33,245,582.00 (13,084,958.98)(13,084,958.98)46,330,540.98 (39%)64,197,348.26
EXPENSE TOTALS 27,657,735.00 2,514,838.13 2,514,838.13 25,142,896.87 9%26,196,789.90
Fund Type Pension Trust Funds Net Gain (Loss)$5,587,847.00 ($15,599,797.11)($15,599,797.11)($21,187,644.11)(279%)$38,000,558.36
Fund Category Fiduciary Funds Totals
REVENUE TOTALS 33,245,582.00 (13,084,958.98)(13,084,958.98)46,330,540.98 (39%)64,197,348.26
EXPENSE TOTALS 27,657,735.00 2,514,838.13 2,514,838.13 25,142,896.87 9%26,196,789.90
Fund Category Fiduciary Funds Net Gain (Loss)$5,587,847.00 ($15,599,797.11)($15,599,797.11)($21,187,644.11)(279%)$38,000,558.36
Page 40 of 41Run by Jessica Tapia on 03/16/2022 17:41:40 PM
Income Statement
Through 01/31/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification