HomeMy WebLinkAbout2018.07 July Monthly Report
YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance
73,192,379 69,129,043 4,063,335 17,279,434 10,816,697
751,842 539,037 212,805 857,304 857,305
483,426 430,528 52,898 42,083 42,082
1,487 583,382 (581,895) (580,011) 419,989
5,693,232 3,824,953 1,868,279 2,910,583 2,852,653
272,239 54,962 217,277 221,366 221,367
- 6,833 (6,833) 301,566 301,565
16,897 21,657 (4,759) (4,759) 100,054
1,119,017 1,433,828 (314,810) 2,058,920 1,893,824
819,941 539,514 280,427 462,423 152,374
228,545 185,000 43,545 (155,249) (155,249)
18,562 417,830 (399,267) (335,160) (335,160)
76,048 85,392 (9,344) 243,268 243,267
348 16 332 170,503 170,502
104,975 126,338 (21,363) (12,086) (12,086)
105,916 127,101 (21,185) 1,455,359 1,459,775
4,539,899 4,195,109 344,790 5,607,334 5,680,321
10,772,181 2,055,366 8,716,815 8,958,596 9,034,465
416,723 1,177,965 (761,242) (513,864) (511,594)
147,703 27,713 119,989 552,755 561,077
136,930 75,136 61,794 55,785 55,785
209,109 108,593 100,516 161,709 161,710
56,981 - 56,981 59,188 59,188
3,914,719 6,961,174 (3,046,455) 5,712,018 7,267,982
(402) 1,021,559 (1,021,960) (481,099) (481,099)
149,420 340,522 (191,102) 2,806,598 2,803,061
6,370,083 4,179,667 2,190,416 6,901,117 6,796,130
9,873,697 8,618,072 1,255,625 7,818,420 5,011,681
7,299,688 5,794,056 1,505,632 5,543,387 3,208,434
2,994,827 2,647,104 347,723 (714,243) (1,224,255)
1,755,901 1,758,058 (2,157) 339,186 (441,973)
799,832 649,529 150,303 999,822 999,822
10,482,954 12,646,740 (2,163,786) (6,502,291) (3,691,895)
142,805,101 129,761,777 13,043,324 62,219,962 54,317,799
Fund Fund Description
175 GENERAL ASSISTANCE FUND
180 GOOD NEIGHBOR FUND
100 GENERAL FUND
176 HEALTH AND HUMAN SERVICES
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
185 LIBRARY FUND
195 NEIGHBORHOOD STABILIZATION
300 WASHINGTON NATIONAL TIF
186 LIBRARY DEBT SERVICE FUND
250 AFFORDABLE HOUSING FUND
240 HOME FUND
235 NEIGHBORHOOD IMPROVEMENT
215 CDBG FUND
220 CDBG LOAN FUND
200 MOTOR FUEL TAX FUND
415 CAPITAL IMPROVEMENTS FUND
187 LIBRARY CAPITAL IMPROVEMENT
320 DEBT SERVICE FUND
350 SPECIAL SERVICE AREA (SSA) #6
335 WEST EVANSTON TIF FUND
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
330 HOWARD-RIDGE TIF FUND
505 PARKING SYSTEM FUND
416 CROWN CONSTRUCTION FUND
420 SPECIAL ASSESSMENT FUND
515 SEWER FUND
520 SOLID WASTE FUND
510 WATER FUND
605 INSURANCE FUND
600 FLEET SERVICES FUND
601 EQUIPMENT REPLACEMENT FUND
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/City Treasurer
Ashley King, Budget & Finance Manager
Kate Lewis-Lakin, Senior Management Analyst
Subject: July 2018 Monthly Financial Report
Date: August 27, 2018
Please find attached the unaudited financial statements as of July 31, 2018. A
summary by fund for revenues, expenditures, fund and cash balances is as follows:
Memorandum
Included above are the ending balances as of July 31, 2018 for both unreserved fund
and cash balances. Of these two amounts, cash balance is the more meaningful metric
since this represents liquid cash and/or invested assets which can be used (or easily
sold) to support and fund current operations. While ending fund balance is also an
important measurement of the City’s financial health, it usually includes illiquid assets or
future cash receipts or disbursements such as receivables (including property tax) due
to the City and accounts payable/accrued expenses.
The beginning fund balances included in this financial report have been updated to
reflect audited 2017 actuals. These numbers are slightly different than those presented
in the January-April financial reports, as these were based on unaudited numbers.
As of July 31, 2018, the General Fund is reporting a net surplus of $4,063,335 The fund
balance in the General Fund is $17,279,434 with a cash balance of $10,816,697. The
attached supplemental charts show the General Fund Revenues at 63.7% of budget
and expenses at 60.5%. Fund and cash balances have increased in July, due primarily
to early payments of the second installment of property taxes. The General Fund
received $6.7 million in property tax revenue in July, equaling 23% of the budget for
property taxes.
Through July 31, 2018, the Good Neighbor Fund is showing a negative fund balance of
$580,011. This is because the revenue to this fund from Northwestern University is not
received until later in the year. Transfers to other funds from the Good Neighbor Fund
are made monthly to cover expenses throughout the year on designated projects.
Through July 31, 2018, the Neighborhood Stabilization Fund is showing a negative fund
balance of $4,759. This is due to the timing of grant funding revenues.
Through July 31, 2018, the SSA #4 Fund is showing a negative fund and cash balance
of $155,249.
Through July 31, 2018, the CDBG fund is showing a negative fund and cash balance of
$335,160. This is due to a delay in reimbursements and will be repaid with draw-downs
during August.
Through July 31, 2018, the HOME Fund is showing a negative fund balance of $12,086.
This is due to the timing of grant funding revenues.
Through July 31, 2018, the Howard-Ridge TIF Fund is showing a negative fund balance
of $513,864 and a negative cash balance of $511,594. This is due to capital project
spending which will be repaid later in the summer by proceeds from the 2018D bond
issuance.
Through July 31, 2018, the Capital Fund is showing a fund balance of $5,712,018 and a
cash balance of $7,267,982. The fund continues to spend down balances from the
2017A General Obligation Bonds that were received in October 2017. As of July 31 the
fund has not yet received revenue for the 2018B bond issuance.
Through July 31, 2018, the Crown Construction fund has a negative fund and cash
balance of $481,099. This is due to capital project spending which will be repaid later in
the summer by proceeds from the 2018A bond issuance.
Through July 31, 2018, the enterprise funds (Parking, Water, and Sewer) continue to
spend down fund balance for capital projects.
As seen in the Water Fund, Evanston bills the Village of Skokie at a rate of $2.06 per
1,000 gallons. Skokie is currently paying $0.78 per 1,000 g allons. This issue is being
challenged in court.
Through July 31, 2018, the Solid Waste Fund has a negative fund balance of $714,243
and a negative cash balance of $1,224,255. The Solid Waste Fund is receiving property
tax revenue for the first time in 2018, and has received $355,868 in Property Taxes to
date.
Through July 31, 2018, the Insurance Fund is showing a negative fund balance of
$6,502,291 and a negative cash balance of $3,691,895. Fund balance is lower than
cash balance due to accrued liabilities for pending litigation.
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 July 31, 2018 year-to-date
financial information and reports which to the best of my knowledge appear accurate
and complete.
January February March April May June July
2017 Unreserved
Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 18,292,843$ 17,839,404$ 14,612,957$ 13,603,487$
2018 Unreserved
Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$ 15,488,721$ 17,279,434$
2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$ 6,169,276$ 7,179,518$
2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$ 10,816,697$
2017 v 2018 Fund and Cash Balance-- General Fund
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
2017 Unreserved Fund Balance
2018 Unreserved Fund Balance
2017 Cash Balance
2018 Cash Balance
July YTD 2017
2018 2018 % Actual
6,702,429 22,656,633 78.5% 28,294,363
4,189,912 29,228,915 58.8% 46,951,377
827,785 6,232,176 50.3% 13,357,911
712,444 2,095,690 54.0% 3,467,694
1,458,947 6,718,455 66.7% 8,754,025
618,143 4,326,999 55.8% 11,586,943
123,089 802,959 101.2% 1,234,749
217,047 1,093,908 84.1% 1,858,106
8,331 36,643 73.1% 38,544
14,858,127 73,192,379 63.7% 115,543,711
CITY COUNCIL 492,806 39,813 320,620 65.1% 498,172
CITY CLERK 191,784 17,491 118,838 62.0% 251,193
CITY MANAGER'S OFFICE 7,540,597 551,781 4,006,396 53.1% 7,539,496
LAW 736,346 46,007 393,330 53.4% 772,045
ADMINISTRATIVE SERVICES 9,075,303 664,676 5,137,876 56.6% 9,314,164
COMMUNITY DEVELOPMENT 3,614,774 274,984 1,835,199 50.8% 2,592,984
POLICE 38,391,099 4,872,109 24,627,230 64.1% 39,067,047
FIRE MGMT & SUPPORT 23,934,390 3,532,515 16,072,554 67.2% 24,355,551
HEALTH 3,697,529 285,261 1,811,150 49.0% 3,071,334
PARKS, REC. AND COMMUNITY SERV. 11,955,812 1,731,653 7,146,349 59.8% 12,479,438
PUBLIC WORKS AGENCY 14,607,356 1,052,785 7,659,502 52.4% 13,983,314
13,069,076 69,129,043 60.5% 113,924,739
14,858,127 73,192,379 63.7% 115,543,711
13,069,076 69,129,043 60.5% 113,924,739
1,789,051 4,063,335 1,618,972
Licenses, Permits and Fees 12,397,400
Budget by Organization Report
Through 07/31/18
Prior Fiscal Year Activity Included
Detail Listing2018
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Interfund Transfers 7,748,417
REVENUE TOTALS 114,840,754
EXPENSE
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
Interest Income 50,100
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
July YTD 2017
2018 2018 % Actual
- 2,068 100.0% 1,900
32,198 3,671,487 55.0% 6,303,624
347,253 2,430,773 57.6% 4,120,636
- - 0.0% -
105,295 222,884 115.3% 253,523
11,377 42,871 122.2% 62,067
496,124 6,370,083 57.2% 10,741,750
140,893 990,173 53.6% 1,675,404
251,089 1,826,020 52.9% 3,172,070
31,612 194,174 7.9% 280,311
26,637 186,461 58.3% 319,648
- - 100.0% 2,561,771
- - 0.0% 4,246
- 53,131 1.7% 267,734
- 89,464 29.4% 267,436
120,035 840,243 58.3% 1,584,683
570,267 4,179,667 32.4% 10,133,302
496,124 6,370,083 57.2% 10,741,750
570,267 4,179,667 32.4% 10,133,302
(74,143) 2,190,416 608,448
Interfund Transfers 4,217,040
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 505 - PARKING SYSTEM FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services 6,676,575
Services and Supplies 3,451,775
Intergovernmental Revenue 12,125
Other Revenue 193,316
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Salary and Benefits 1,849,028
Capital Outlay 2,450,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Fund 505 - PARKING SYSTEM FUND
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Fund 505 - PARKING SYSTEM FUND (1,762,367)
July YTD 2017
2018 2018 % Actual
6,150 30,942 44.2% 86,063
215,939 9,684,091 53.0% 17,255,947
5,425 42,928 0.2% 294,812
25,805 115,736 462.9% 35,784
253,320 9,873,697 21.6% 17,672,605
435,000 3,091,603 55.1% 5,958,873
291,599 1,608,908 34.6% 2,528,863
515,085 1,030,891 3.5% (192,124)
39,041 273,287 58.3% 468,492
- - 100.0% 2,470,280
- - 0.0% -
- 465,369 23.7% 717,388
- - 0.0% 2
306,859 2,148,014 59.6% 6,327,314
1,587,584 8,618,072 18.9% 18,279,088
253,320 9,873,697 21.6% 17,672,605
1,587,584 8,618,072 18.9% 18,279,088
(1,334,264) 1,255,625 (606,483)
Fund 510 - WATER FUND
Budget by Organization Report
Through 07/31/18
Prior Fiscal Year Activity
Included2018
Classification Budget
Salary and Benefits 5,614,331
REVENUE
Licenses, Permits and Fees 70,000
Charges for Services 18,267,000
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
EXPENSE
Services and Supplies 4,655,410
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
EXPENSE TOTALS 45,663,506
July YTD 2017
2018 2018 % Actual
1,165,370 7,281,137 57.8% 12,477,657
- - 0.0% 14,870
3,726 18,551 371.0% 16,023
1,169,095 7,299,688 49.7% 12,508,550
103,916 734,769 57.6% 1,313,154
25,387 62,884 2.5% 88,677
47,668 341,431 15.7% 16,941
22,499 157,493 58.3% 269,988
- - 0.0% 3,530,787
364,699 3,919,001 52.0% 1,143,643
- - 0.0% -
82,640 578,478 58.3% 1,141,676
646,808 5,794,056 39.1% 7,504,867
1,169,095 7,299,688 49.7% 12,508,550
646,808 5,794,056 39.1% 7,504,867
522,287 1,505,632 5,003,683
Fund 515 - SEWER FUND
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Salary and Benefits 1,274,709
REVENUE
Charges for Services 12,589,650
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
EXPENSE
Depreciation Expense -
Debt Service 7,540,066
Services and Supplies 2,558,630
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Miscellaneous 1,500
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
July YTD 2017
2018 2018 % Actual
88,305 355,868 86.8% -
- 56,086 20.4% 199,513
336,239 2,120,267 58.4% 3,611,308
58,831 411,814 58.3% 755,967
7,703 50,791 21.3% 250,687
491,077 2,994,827 56.9% 4,817,475
94,869 541,332 54.5% 890,220
305,873 1,906,352 54.6% 3,482,141
- 7,023 2.5% 24,635
- 665 3.1% 1,797
- 3,688 49.2% 3,057
26,864 188,045 58.3% 504,807
427,605 2,647,104 51.8% 4,906,657
491,077 2,994,827 56.9% 4,817,475
427,605 2,647,104 51.8% 4,906,657
63,472 347,723 (89,182)
Fund 520 - SOLID WASTE FUND
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Interfund Transfers 705,967
Other Revenue 238,000
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 275,000
Charges for Services 3,632,394
REVENUE TOTALS 5,261,361
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Capital Outlay 275,750
Debt Service 21,797
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
EXPENSE TOTALS 5,109,701
July YTD 2017
2018 2018 Actual
6,702,429 22,656,633 28,294,363
4,189,912 29,228,915 46,951,377
827,785 6,232,176 13,357,911
712,444 2,095,690 3,467,694
1,458,947 6,718,455 8,754,025
618,143 4,326,999 11,586,943
123,089 802,959 1,234,749
217,047 1,093,908 1,858,106
8,331 36,643 38,544
14,858,127 73,192,379 115,543,711
5,540,172 40,343,726 71,659,904
1,519,912 6,593,424 13,414,590
25,690 81,003 361,427
5,255,157 17,177,383 20,883,996
5,018 42,594 124,131
- 106 4,090
83,618 414,236 835,363
639,510 4,476,570 6,641,237
13,069,076 69,129,043 113,924,739
14,858,127 73,192,379 115,543,711
13,069,076 69,129,043 113,924,739
1,789,051 4,063,335 1,618,972
Starting Fund Balance 13,216,099 13,216,099
Net Change 602,958 4,063,335
Ending Fund Balance 13,819,057 17,279,434
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
Licenses, Permits and Fees 12,397,400
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Interfund Transfers 7,748,417
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
Interest Income 50,100
REVENUE TOTALS 114,840,754
EXPENSE
Salary and Benefits 70,175,937
Services and Supplies 12,367,791
Capital Outlay 354,000
Insurance and Other Chargebacks 22,287,563
Community Sponsored Organizations 123,886
Contingencies 208,500
Miscellaneous 1,015,317
Interfund Transfers 7,704,802
EXPENSE TOTALS 114,237,796
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 1 of 35
July YTD 2017
2018 2018 Actual
230,383 736,476 933,020
- 12,311 33,019
1,082 3,055 1,548
231,465 751,842 967,586
30,909 220,651 324,972
48,336 314,266 579,392
4,000 4,120 5,110
83,245 539,037 909,475
231,465 751,842 967,586
83,245 539,037 909,475
148,220 212,805 58,111
Starting Fund Balance 644,499 644,499
Net Change (312,421) 212,805
Ending Fund Balance 332,078 857,304
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 925,000
Other Revenue 27,500
Interest Income 1,000
REVENUE TOTALS 953,500
EXPENSE
Salary and Benefits 400,721
Services and Supplies 858,200
Miscellaneous 7,000
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE TOTALS 953,500
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND (312,421)
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 2 of 35
July YTD 2017
2018 2018 Actual
69,039 483,275 859,153
101 151 14
69,140 483,426 859,167
- (22,593) 22,593
14,416 28,816 121
180,270 419,305 918,074
2,500 5,000 -
197,187 430,528 940,789
69,140 483,426 859,167
197,187 430,528 940,789
(128,046) 52,898 (81,622)
Starting Fund Balance (10,815) (10,815)
Net Change (30,682) 52,898
Ending Fund Balance (41,497) 42,083
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Interfund Transfers 828,471
Interest Income -
REVENUE TOTALS 828,471
EXPENSE
Salary and Benefits -
Services and Supplies 859,153
Community Sponsored Organizations -
Miscellaneous -
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN (30,682)
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 828,471
EXPENSE TOTALS 859,153
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 3 of 35
July YTD 2017
2018 2018 Actual
- - 1,000,000
298 1,487 1,884
298 1,487 1,001,884
49 49 -
83,333 583,333 1,000,000
83,382 583,382 1,000,000
298 1,487 1,001,884
83,382 583,382 1,000,000
(83,084) (581,895) 1,884
Starting Fund Balance 1,884 1,884
Net Change - (581,895)
Ending Fund Balance 1,884 (580,011)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
Interest Income -
REVENUE TOTALS 1,000,000
EXPENSE
Services and Supplies -
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals -
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 4 of 35
July YTD 2017
2018 2018 Actual
1,858,548 5,317,337 6,370,507
- 60,296 122,862
37 189 338
5,833 40,833 190,200
- 105,792 74,206
- 43,334 70,807
- 113,050 362,608
4,550 12,399 5,169
1,868,968 5,693,232 7,196,696
393,508 2,778,717 4,739,145
175,128 831,691 1,712,359
- 492 9,904
- - 22
30,579 214,053 343,618
599,216 3,824,953 6,805,048
1,868,968 5,693,232 7,196,696
599,216 3,824,953 6,805,048
1,269,752 1,868,279 391,648
Starting Fund Balance 1,042,304 1,042,304
Net Change 216,912 1,868,279
Ending Fund Balance 1,259,216 2,910,583
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,685,000
Fines and Forfeitures 130,000
Charges for Services -
Interfund Transfers 265,771
Intergovernmental Revenue 152,418
Other Revenue 130,000
Library Revenue 324,620
Interest Income 5,400
REVENUE TOTALS 7,693,209
EXPENSE
Salary and Benefits 5,074,260
Services and Supplies 2,024,688
Capital Outlay 10,400
Miscellaneous -
Interfund Transfers 366,949
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals 216,912
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 7,693,209
EXPENSE TOTALS 7,476,297
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 5 of 35
July YTD 2017
2018 2018 Actual
114,379 272,239 338,897
- - 778,745
- - 7
114,379 272,239 1,117,649
- - 8,587
- 54,962 1,134,570
- - 112
- 54,962 1,143,269
114,379 272,239 1,117,649
- 54,962 1,143,269
114,379 217,277 (25,619)
Starting Fund Balance 4,089 4,089
Net Change 12,386 217,277
Ending Fund Balance 16,475 221,366
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 345,790
Other Revenue -
Interest Income -
REVENUE TOTALS 345,790
EXPENSE
Services and Supplies -
Debt Service 333,404
Interfund Transfers -
EXPENSE TOTALS 333,404
EXPENSE TOTALS 333,404
Fund 186 - LIBRARY DEBT SERVICE FUND 12,386
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE TOTALS 345,790
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 6 of 35
July YTD 2017
2018 2018 Actual
- - 1,431,106
- - 1,431,106
- - 30,790
- 6,833 1,091,917
- 6,833 1,122,708
- - 1,431,106
- 6,833 1,122,708
- (6,833) 308,399
Starting Fund Balance 308,399 308,399
Net Change - (6,833)
Ending Fund Balance 308,399 301,566
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Other Revenue 10,095,000
REVENUE TOTALS 10,095,000
EXPENSE
Services and Supplies -
Capital Outlay 10,095,000
EXPENSE TOTALS 10,095,000
Fund 187 - LIBRARY CAPITAL -
Fund 187 - LIBRARY CAPITAL
REVENUE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 7 of 35
July YTD 2017
2018 2018 Actual
- 16,617 37,641
105 280 -
105 16,897 37,641
2,208 15,789 26,454
5 1,865 1,860
- 4,873 2,642
(5,369) (5,369) (233)
40 1,784 2,400
388 2,715 4,518
(2,729) 21,657 37,641
105 16,897 37,641
(2,729) 21,657 37,641
2,833 (4,759) -
Starting Fund Balance - -
Net Change 326 (4,759)
Ending Fund Balance 326 (4,759)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Intergovernmental Revenue 95,147
Interest Income -
REVENUE TOTALS 95,147
EXPENSE
Salary and Benefits 28,067
Services and Supplies 5,100
Capital Outlay 7,000
Insurance and Other Chargebacks -
Miscellaneous 50,000
Interfund Transfers 4,654
EXPENSE TOTALS 94,821
EXPENSE TOTALS 94,821
Fund 195 - NEIGHBORHOOD 326
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 95,147
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 8 of 35
July YTD 2017
2018 2018 Actual
143,867 1,095,168 1,899,884
3,692 23,849 18,158
- - -
147,559 1,119,017 1,918,041
125,000 875,000 -
79,833 558,828 957,990
204,833 1,433,828 957,990
147,559 1,119,017 1,918,041
204,833 1,433,828 957,990
(57,274) (314,810) 960,051
Starting Fund Balance 2,373,730 2,373,730
Net Change (535,990) (314,810)
Ending Fund Balance 1,837,740 2,058,920
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,910,000
Interest Income 12,000
Reappropriation of Surplus -
REVENUE TOTALS 1,922,000
EXPENSE
Capital Outlay 1,500,000
Interfund Transfers 957,990
EXPENSE TOTALS 2,457,990
Fund 200 - MOTOR FUEL TAX FUND Totals (535,990)
Fund 200 - MOTOR FUEL TAX FUND Totals
REVENUE TOTALS 1,922,000
EXPENSE TOTALS 2,457,990
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 9 of 35
July YTD 2017
2018 2018 Actual
122,243 811,939 978,523
- 863 -
1,590 7,140 7,178
123,833 819,941 985,701
43,378 337,836 585,510
3,130 148,703 239,161
- - 51,670
1,454 10,178 17,448
6,114 42,797 72,977
54,076 539,514 966,766
123,833 819,941 985,701
54,076 539,514 966,766
69,758 280,427 18,935
Starting Fund Balance 181,996 181,996
Net Change 8,262 280,427
Ending Fund Balance 190,258 462,423
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,050,700
Other Revenue -
Interest Income 1,000
REVENUE TOTALS 1,051,700
EXPENSE
Salary and Benefits 615,224
Services and Supplies 282,400
Capital Outlay 55,000
Insurance and Other Chargebacks 17,448
Interfund Transfers 73,366
EXPENSE TOTALS 1,043,438
Fund 205 - EMERGENCY TELEPHONE 8,262
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,051,700
EXPENSE TOTALS 1,043,438
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 10 of 35
July YTD 2017
2018 2018 Actual
68,568 228,520 322,477
0 25 5
68,568 228,545 322,482
92,500 185,000 329,000
92,500 185,000 329,000
68,568 228,545 322,482
92,500 185,000 329,000
(23,932) 43,545 (6,518)
Starting Fund Balance (198,794) (198,794)
Net Change - 43,545
Ending Fund Balance (198,794) (155,249)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 370,000
Interest Income -
REVENUE TOTALS 370,000
EXPENSE
Services and Supplies 370,000
EXPENSE TOTALS 370,000
EXPENSE TOTALS 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) -
Fund 210 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 370,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 11 of 35
July YTD 2017
2018 2018 Actual
- 14,558 1,906,708
2,856 4,004 262
2,856 18,562 1,906,970
35,269 246,569 431,440
41 3,481 3,797
- 14,558 645,289
124,099 132,823 392,279
- - 318,412
16 15,174 95,606
746 5,224 20,145
160,172 417,830 1,906,970
2,856 18,562 1,906,970
160,172 417,830 1,906,970
(157,316) (399,267) -
Starting Fund Balance 64,107 64,107
Net Change (109,388) (399,267)
Ending Fund Balance (45,281) (335,160)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 215 - CDBG FUND
REVENUE
Intergovernmental Revenue 2,330,124
Other Revenue -
REVENUE TOTALS 2,330,124
EXPENSE
Salary and Benefits 502,898
Services and Supplies 220,840
Capital Outlay -
Insurance and Other Chargebacks 20,648
Community Sponsored Organizations 175,500
Miscellaneous 569,970
Interfund Transfers 949,656
EXPENSE TOTALS 2,439,512
EXPENSE TOTALS 2,439,512
Fund 215 - CDBG FUND Totals (109,388)
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,330,124
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 12 of 35
July YTD 2017
2018 2018 Actual
54,048 75,352 51,369
192 695 3,391
54,240 76,048 54,760
20,446 85,392 13,070
20,446 85,392 13,070
54,240 76,048 54,760
20,446 85,392 13,070
33,794 (9,344) 41,690
Starting Fund Balance 252,612 252,612
Net Change - (9,344)
Ending Fund Balance 252,612 243,268
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 220 - CDBG LOAN FUND
REVENUE
Other Revenue 293,000
Interest Income -
REVENUE TOTALS 293,000
EXPENSE
Services and Supplies 293,000
EXPENSE TOTALS 293,000
Fund 220 - CDBG LOAN FUND Totals -
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 293,000
EXPENSE TOTALS 293,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 13 of 35
July YTD 2017
2018 2018 Actual
101 348 256
101 348 256
16 16 -
- - -
16 16 -
101 348 256
16 16 -
85 332 256
Starting Fund Balance 170,171 170,171
Net Change (100,000) 332
Ending Fund Balance 70,171 170,503
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Interest Income -
REVENUE TOTALS -
EXPENSE
Services and Supplies -
Miscellaneous 100,000
EXPENSE TOTALS 100,000
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (100,000)
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS -
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 14 of 35
July YTD 2017
2018 2018 Actual
- 83,655 227,450
2,282 21,248 21,820
23 72 5,685
2,305 104,975 254,955
2,445 21,052 43,994
5 98,267 231,806
6,608 7,018 (27,871)
- - 126
9,059 126,338 248,055
2,305 104,975 254,955
9,059 126,338 248,055
(6,754) (21,363) 6,900
Starting Fund Balance 9,277 9,277
Net Change 615 (21,363)
Ending Fund Balance 9,892 (12,086)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 588,936
Other Revenue -
Interest Income -
REVENUE TOTALS 588,936
EXPENSE
Salary and Benefits 46,801
Services and Supplies 540,200
Insurance and Other Chargebacks 820
Miscellaneous 500
EXPENSE TOTALS 588,321
EXPENSE TOTALS 588,321
Fund 240 - HOME FUND Totals 615
Fund 240 - HOME FUND Totals
REVENUE TOTALS 588,936
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 15 of 35
July YTD 2017
2018 2018 Actual
4,050 34,050 97,000
417 65,417 333,056
1,558 6,450 5,623
6,025 105,916 435,678
6,116 46,510 44,432
108 34,026 209,772
25,674 25,674 11,532
4,086 6,484 8,927
- 14,407 85,660
35,984 127,101 360,323
6,025 105,916 435,678
35,984 127,101 360,323
(29,959) (21,185) 75,355
Starting Fund Balance 1,476,544 1,476,544
Net Change (38,470) (21,185)
Ending Fund Balance 1,438,074 1,455,359
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 50,000
Other Revenue 400,600
Interest Income 230
REVENUE TOTALS 450,830
EXPENSE
Salary and Benefits 96,800
Services and Supplies 279,500
Insurance and Other Chargebacks -
Community Sponsored Organizations 70,000
Miscellaneous 43,000
EXPENSE TOTALS 489,300
Fund 250 - AFFORDABLE HOUSING FUND (38,470)
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE TOTALS 450,830
EXPENSE TOTALS 489,300
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 16 of 35
July YTD 2017
2018 2018 Actual
1,544,080 4,518,533 5,249,949
3,589 21,366 45,924
1,547,669 4,539,899 5,295,873
- - 2,007
24,668 49,336 98,672
592,253 4,145,773 5,557,325
616,921 4,195,109 5,658,005
1,547,669 4,539,899 5,295,873
616,921 4,195,109 5,658,005
930,747 344,790 (362,132)
Starting Fund Balance 5,262,544 5,262,544
Net Change (3,437,040) 344,790
Ending Fund Balance 1,825,504 5,607,334
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,750,000
Interest Income 20,000
REVENUE TOTALS 5,770,000
EXPENSE
Services and Supplies 2,000,000
Miscellaneous 100,000
Interfund Transfers 7,107,040
EXPENSE TOTALS 9,207,040
EXPENSE TOTALS 9,207,040
Fund 300 - WASHINGTON NATIONAL TIF (3,437,040)
Fund 300 - WASHINGTON NATIONAL TIF
REVENUE TOTALS 5,770,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 17 of 35
July YTD 2017
2018 2018 Actual
3,590,755 8,471,542 10,797,411
470,595 2,204,172 2,895,561
7,219 50,531 -
- - 8,966,396
12,557 45,937 36,782
4,081,125 10,772,181 22,696,150
5 5 100,625
- 2,055,360 23,099,797
- - (57)
5 2,055,366 23,200,365
4,081,125 10,772,181 22,696,150
5 2,055,366 23,200,365
4,081,120 8,716,815 (504,215)
Starting Fund Balance 241,781 241,781
Net Change 128,349 8,716,815
Ending Fund Balance 370,130 8,958,596
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 320 - DEBT SERVICE FUND
REVENUE
Property Taxes 10,879,993
Interfund Transfers 3,460,821
Intergovernmental Revenue 83,292
Other Revenue -
Interest Income 1,500
REVENUE TOTALS 14,425,606
EXPENSE
Services and Supplies 120,000
Debt Service 14,177,257
Miscellaneous -
EXPENSE TOTALS 14,297,257
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals 128,349
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 14,425,606
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 18 of 35
July YTD 2017
2018 2018 Actual
38,378 357,092 583,827
31,496 59,569 32,000
0 62 22
69,874 416,723 615,848
17 229,054 307,391
157,348 913,164 -
121 747 995
5,000 35,000 60,000
162,486 1,177,965 368,386
69,874 416,723 615,848
162,486 1,177,965 368,386
(92,612) (761,242) 247,462
Starting Fund Balance 247,378 247,378
Net Change (296,100) (761,242)
Ending Fund Balance (48,722) (513,864)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 605,000
Other Revenue 3,780,000
Interest Income 400
REVENUE TOTALS 4,385,400
EXPENSE
Services and Supplies 461,500
Capital Outlay 3,200,000
Debt Service 960,000
Interfund Transfers 60,000
EXPENSE TOTALS 4,681,500
Fund 330 - HOWARD-RIDGE TIF FUND (296,100)
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE TOTALS 4,385,400
EXPENSE TOTALS 4,681,500
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 19 of 35
July YTD 2017
2018 2018 Actual
94,151 137,327 43,503
1,028 6,170 12,339
784 4,206 3,898
95,964 147,703 59,741
- 1,032 2,007
1,488 9,182 12,227
2,500 17,500 30,000
3,988 27,713 44,235
95,964 147,703 59,741
3,988 27,713 44,235
91,976 119,989 15,506
Starting Fund Balance 432,766 432,766
Net Change (39,850) 119,989
Ending Fund Balance 392,916 552,755
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes -
Other Revenue -
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Services and Supplies -
Debt Service 10,000
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Fund 335 - WEST EVANSTON TIF FUND
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 20 of 35
July YTD 2017
2018 2018 Actual
110,526 136,927 48,001
- - 2,067,512
- 3 1
110,526 136,930 2,115,514
- 1,032 38,588
- - 2,053,521
74,104 74,104 -
74,104 75,136 2,092,108
110,526 136,930 2,115,514
74,104 75,136 2,092,108
36,422 61,794 23,406
Starting Fund Balance (6,009) (6,009)
Net Change 202,334 61,794
Ending Fund Balance 196,325 55,785
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes 275,000
Other Revenue -
Interest Income -
REVENUE TOTALS 275,000
EXPENSE
Services and Supplies -
Debt Service 72,666
Interfund Transfers -
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND 202,334
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE TOTALS 275,000
EXPENSE TOTALS 72,666
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 21 of 35
July YTD 2017
2018 2018 Actual
177,799 209,106 75,430
- - 3,520,189
- 4 9
177,799 209,109 3,595,628
- 1,032 58,113
- - 580,000
- - 3,031,398
107,561 107,561 -
107,561 108,593 3,669,511
177,799 209,109 3,595,628
107,561 108,593 3,669,511
70,238 100,516 (73,884)
Starting Fund Balance 61,193 61,193
Net Change 316,001 100,516
Ending Fund Balance 377,194 161,709
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 425,000
Other Revenue -
Interest Income -
REVENUE TOTALS 425,000
EXPENSE
Services and Supplies -
Capital Outlay -
Debt Service 108,999
Interfund Transfers -
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals 316,001
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 425,000
EXPENSE TOTALS 108,999
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 22 of 35
July YTD 2017
2018 2018 Actual
46,730 56,963 215,245
0 18 21
46,730 56,981 215,266
- - 213,354
- - 78,000
- - 291,354
46,730 56,981 215,266
- - 291,354
46,730 56,981 (76,088)
Starting Fund Balance 2,207 2,207
Net Change - 56,981
Ending Fund Balance 2,207 59,188
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 221,000
Interest Income 500
REVENUE TOTALS 221,500
EXPENSE
Services and Supplies 221,500
Interfund Transfers -
EXPENSE TOTALS 221,500
Fund 350 - SPECIAL SERVICE AREA (SSA) -
Fund 350 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 221,500
EXPENSE TOTALS 221,500
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 23 of 35
July YTD 2017
2018 2018 Actual
- - 359,706
15,726 42,964 33,339
536,667 3,756,667 787,177
- 51,221 530,812
- - 11,246,149
7,848 63,867 56,607
560,240 3,914,719 13,013,790
51,713 357,774 5,392
123,273 504,430 1,672,608
953,100 5,807,303 13,582,482
41,667 291,667 500,000
1,169,753 6,961,174 15,760,481
560,240 3,914,719 13,013,790
1,169,753 6,961,174 15,760,481
(609,513) (3,046,455) (2,746,691)
Starting Fund Balance 8,758,473 8,758,473
Net Change (7,655,527) (3,046,455)
Ending Fund Balance 1,102,946 5,712,018
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services -
Interfund Transfers 6,450,000
Intergovernmental Revenue 4,190,000
Other Revenue 12,002,000
Interest Income -
REVENUE TOTALS 22,642,000
EXPENSE
Salary and Benefits 85,527
Services and Supplies -
Capital Outlay 29,712,000
Interfund Transfers 500,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS (7,655,527)
Fund 415 - CAPITAL IMPROVEMENTS
REVENUE TOTALS 22,642,000
EXPENSE TOTALS 30,297,527
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 24 of 35
July YTD 2017
2018 2018 Actual
- - 649,512
(402) (402) 900,000
- - -
(402) (402) 1,549,512
389 1,009,789 638,727
- 11,770 369,924
389 1,021,559 1,008,651
(402) (402) 1,549,512
389 1,021,559 1,008,651
(790) (1,021,960) 540,861
Starting Fund Balance 540,861 540,861
Net Change 1,866,000 (1,021,960)
Ending Fund Balance 2,406,861 (481,099)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Interfund Transfers -
Other Revenue 11,500,000
Interest Income -
REVENUE TOTALS 11,500,000
EXPENSE
Services and Supplies 1,634,000
Capital Outlay 8,000,000
EXPENSE TOTALS 9,634,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION FUND 1,866,000
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE TOTALS 11,500,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 25 of 35
July YTD 2017
2018 2018 Actual
- - -
5,340 25,608 31,207
11,747 123,812 237,012
17,087 149,420 268,219
6,220 41,013 694
10 10 5,613
42,786 299,499 263,427
49,016 340,522 269,734
17,087 149,420 268,219
49,016 340,522 269,734
(31,929) (191,102) (1,516)
Starting Fund Balance 2,997,700 2,997,700
Net Change (123,850) (191,102)
Ending Fund Balance 2,873,850 2,806,598
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Other Revenue 250,000
Interest Income 31,200
Special Assessment 180,167
REVENUE TOTALS 461,367
EXPENSE
Salary and Benefits 71,790
Services and Supplies -
Interfund Transfers 513,427
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE TOTALS 461,367
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND (123,850)
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 26 of 35
July YTD 2017
2018 2018 Actual
- 2,068 1,900
32,198 3,671,487 6,303,624
347,253 2,430,773 4,120,636
- - -
105,295 222,884 253,523
11,377 42,871 62,067
496,124 6,370,083 10,741,750
140,893 990,173 1,675,404
251,089 1,826,020 3,172,070
31,612 194,174 280,311
26,637 186,461 319,648
- - 2,561,771
- - 4,246
- 53,131 267,734
- 89,464 267,436
120,035 840,243 1,584,683
570,267 4,179,667 10,133,302
496,124 6,370,083 10,741,750
570,267 4,179,667 10,133,302
(74,143) 2,190,416 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,190,416
Ending Fund Balance 2,948,334 6,901,117
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 505 - PARKING SYSTEM FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services 6,676,575
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue 193,316
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Capital Outlay 2,450,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Fund 505 - PARKING SYSTEM FUND Totals (1,762,367)
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 27 of 35
July YTD 2017
2018 2018 Actual
6,150 30,942 86,063
215,939 9,684,091 17,255,947
5,425 42,928 294,812
25,805 115,736 35,784
253,320 9,873,697 17,672,605
435,000 3,091,603 5,958,873
291,599 1,608,908 2,528,863
515,085 1,030,891 (192,124)
39,041 273,287 468,492
- - 2,470,280
- - -
- 465,369 717,388
- - 2
306,859 2,148,014 6,327,314
1,587,584 8,618,072 18,279,088
253,320 9,873,697 17,672,605
1,587,584 8,618,072 18,279,088
(1,334,264) 1,255,625 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 1,255,625
Ending Fund Balance 6,594,945 7,818,420
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
Charges for Services 18,267,000
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 28 of 35
July YTD 2017
2018 2018 Actual
1,165,370 7,281,137 12,477,657
- - -
- - 14,870
3,726 18,551 16,023
1,169,095 7,299,688 12,508,550
103,916 734,769 1,313,154
25,387 62,884 88,677
47,668 341,431 16,941
22,499 157,493 269,988
- - 3,530,787
- - -
364,699 3,919,001 1,143,643
- - -
82,640 578,478 1,141,676
646,808 5,794,056 7,504,867
1,169,095 7,299,688 12,508,550
646,808 5,794,056 7,504,867
522,287 1,505,632 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 1,505,632
Ending Fund Balance 3,918,535 5,543,387
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
Interfund Transfers -
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
Contingencies -
Debt Service 7,540,066
Miscellaneous 1,500
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 29 of 35
July YTD 2017
2018 2018 Actual
88,305 355,868 -
- 56,086 199,513
336,239 2,120,267 3,611,308
58,831 411,814 755,967
- - -
7,703 50,791 250,687
- - -
491,077 2,994,827 4,817,475
94,869 541,332 890,220
305,873 1,906,352 3,482,141
- 7,023 24,635
- 665 1,797
- 3,688 3,057
26,864 188,045 504,807
427,605 2,647,104 4,906,657
491,077 2,994,827 4,817,475
427,605 2,647,104 4,906,657
63,472 347,723 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 347,723
Ending Fund Balance (910,306) (714,243)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 275,000
Charges for Services 3,632,394
Interfund Transfers 705,967
Intergovernmental Revenue -
Other Revenue 238,000
Interest Income -
REVENUE TOTALS 5,261,361
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Capital Outlay 275,750
Debt Service 21,797
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 30 of 35
July YTD 2017
2018 2018 Actual
249,053 1,743,373 2,478,435
1,610 12,504 19,016
- 24 339
250,663 1,755,901 2,497,791
84,116 592,677 1,154,569
168,389 1,145,873 1,744,972
- - -
2,787 19,508 27,833
255,292 1,758,058 2,927,375
250,663 1,755,901 2,497,791
255,292 1,758,058 2,927,375
(4,629) (2,157) (429,584)
Starting Fund Balance 341,343 341,343
Net Change (262,450) (2,157)
Ending Fund Balance 78,893 339,186
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 2,988,640
Other Revenue 81,781
Interest Income 1,000
REVENUE TOTALS 3,071,421
EXPENSE
Salary and Benefits 1,069,922
Services and Supplies 2,230,057
Contingencies 450
Interfund Transfers 33,442
EXPENSE TOTALS 3,333,871
EXPENSE TOTALS 3,333,871
Fund 600 - FLEET SERVICES FUND Totals (262,450)
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,071,421
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 31 of 35
July YTD 2017
2018 2018 Actual
111,228 778,594 1,400,057
- 19,758 88,015
532 1,480 2,128
111,759 799,832 1,490,200
5,425 18,709 74,539
3,293 630,820 -
- - 1,780,829
8,718 649,529 1,855,367
111,759 799,832 1,490,200
8,718 649,529 1,855,367
103,041 150,303 (365,167)
Starting Fund Balance 849,519 849,519
Net Change (53,028) 150,303
Ending Fund Balance 796,491 999,822
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,334,732
Other Revenue 210,217
Interest Income -
REVENUE TOTALS 1,544,949
EXPENSE
Services and Supplies 75,000
Capital Outlay 1,522,977
Depreciation Expense -
EXPENSE TOTALS 1,597,977
EXPENSE TOTALS 1,597,977
Fund 601 - EQUIPMENT REPLACEMENT (53,028)
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,544,949
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 32 of 35
July YTD 2017
2018 2018 Actual
13,534 100,021 162,411
- - 2,300,000
873,230 5,900,168 10,926,377
190,678 1,223,156 1,032,678
437,295 3,257,512 5,611,626
307 2,097 382
1,515,043 10,482,954 20,033,473
39,378 359,370 606,021
1,522,402 2,694,472 3,594,432
1,336,132 9,587,279 17,164,869
803 5,619 9,632
2,898,715 12,646,740 21,374,954
1,515,043 10,482,954 20,033,473
2,898,715 12,646,740 21,374,954
(1,383,671) (2,163,786) (1,341,481)
Starting Fund Balance (4,338,505) (4,338,505)
Net Change 653,342 (2,163,786)
Ending Fund Balance (3,685,163) (6,502,291)
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 605 - INSURANCE FUND
REVENUE
Charges for Services 162,411
Interfund Transfers 55,242
Other Revenue 10,867,028
Workers Compensation and Liability 2,196,415
Insurance 5,811,177
Interest Income 1,000
REVENUE TOTALS 19,093,273
EXPENSE
Salary and Benefits 729,027
Services and Supplies 2,385,448
Insurance and Other Chargebacks 15,315,824
Interfund Transfers 9,632
EXPENSE TOTALS 18,439,931
EXPENSE TOTALS 18,439,931
Fund 605 - INSURANCE FUND Totals 653,342
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 19,093,273
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 33 of 35
July YTD 2017
2018 2018 Actual
- - -
- - -
3,576,654 8,106,304 15,225,459
75,436 857,106 2,065,885
3,652,090 8,963,410 17,291,343
759,878 5,299,410 8,682,009
6,026 31,398 136,256
765,904 5,330,808 8,818,265
3,652,090 8,963,410 17,291,343
765,904 5,330,808 8,818,265
2,886,186 3,632,602 8,473,079
Starting Fund Balance 79,073,077 79,073,077
Net Change 4,989,947 3,632,602
Ending Fund Balance 84,063,024 82,705,679
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 700 - FIRE PENSION FUND
REVENUE
Other Taxes 280,000
Interfund Transfers 10,000
Other Revenue 9,394,947
Interest Income 4,100,000
REVENUE TOTALS 13,784,947
EXPENSE
Salary and Benefits 8,795,000
Miscellaneous -
EXPENSE TOTALS 8,795,000
Fund 700 - FIRE PENSION FUND Totals 4,989,947
Fund 700 - FIRE PENSION FUND Totals
REVENUE TOTALS 13,784,947
EXPENSE TOTALS 8,795,000
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 34 of 35
July YTD 2017
2018 2018 Actual
- - -
5,223,419 11,519,104 24,497,983
156,016 1,573,860 2,829,084
5,379,435 13,092,964 27,327,068
999,578 6,971,056 11,624,574
55,471 180,934 264,371
1,055,050 7,151,990 11,888,945
5,379,435 13,092,964 27,327,068
1,055,050 7,151,990 11,888,945
4,324,386 5,940,974 15,438,122
Starting Fund Balance 121,629,667 121,629,667
Net Change 6,194,704 5,940,974
Ending Fund Balance 127,824,371 127,570,641
Budget by Organization
Report
Through 07/31/18
Prior Fiscal Year Activity 2018
Classification Budget
Fund 705 - POLICE PENSION FUND
REVENUE
Interfund Transfers 57,000
Other Revenue 12,162,704
Interest Income 6,500,000
REVENUE TOTALS 18,719,704
EXPENSE
Salary and Benefits 12,255,000
Miscellaneous 270,000
EXPENSE TOTALS 12,525,000
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals 6,194,704
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS 18,719,704
Run by Kate LewisLakin on 08/24/2018 09:14:52 AM Page 35 of 35