HomeMy WebLinkAbout2018.08 August Monthly Report
Fund Fund Description YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance
100 GENERAL FUND 85,137,109 80,007,686 5,129,423 18,345,522 12,252,460
175 GENERAL ASSISTANCE FUND 918,061 619,640 298,421 942,920 942,920
176 HEALTH AND HUMAN SERVICES 552,485 444,137 108,348 97,533 97,533
180 GOOD NEIGHBOR FUND 1,685 666,747 (665,062) (663,178) 336,822
185 LIBRARY FUND 7,024,657 4,348,648 2,676,008 3,718,312 3,660,535
186 LIBRARY DEBT SERVICE FUND 2,491,257 77,312 2,413,945 2,418,034 2,418,034
187 LIBRARY CAPITAL IMPROVEMENT
FD
- 16,664 (16,664) 291,735 291,735
195 NEIGHBORHOOD STABILIZATION
FUND
33,185 26,393 6,793 6,793 95,468
200 MOTOR FUEL TAX FUND 1,291,018 1,638,660 (347,642) 2,026,088 1,860,530
205 EMERGENCY TELEPHONE (E911)
FUND
944,383 599,634 344,750 526,746 216,697
210 SPECIAL SERVICE AREA (SSA) #4 341,959 185,000 156,959 (41,835) (41,835)
215 CDBG FUND 434,841 455,105 (20,263) 43,844 43,844
220 CDBG LOAN FUND 79,244 90,387 (11,143) 241,469 241,469
235 NEIGHBORHOOD IMPROVEMENT 429 29 399 170,570 170,570
240 HOME FUND 198,473 194,273 4,201 13,478 13,478
250 AFFORDABLE HOUSING FUND 107,586 138,942 (31,357) 1,445,188 1,449,604
300 WASHINGTON NATIONAL TIF
FUND
5,718,432 4,787,363 931,069 6,193,613 6,268,398
320 DEBT SERVICE FUND 20,116,100 9,101,167 11,014,933 11,256,714 11,332,583
330 HOWARD-RIDGE TIF FUND 4,284,159 1,379,873 2,904,286 3,151,664 3,153,934
335 WEST EVANSTON TIF FUND 223,039 32,308 190,731 623,497 631,819
340 DEMPSTER-DODGE TIF FUND 136,937 75,630 61,307 55,298 55,298
345 CHICAGO-MAIN TIF 219,366 109,087 110,279 171,472 171,472
350 SPECIAL SERVICE AREA (SSA) #6 113,720 - 113,720 115,927 115,927
415 CAPITAL IMPROVEMENTS FUND 14,741,757 8,144,374 6,597,383 15,355,856 16,480,101
416 CROWN CONSTRUCTION FUND 25,623,743 1,242,021 24,381,722 24,922,583 24,922,583
420 SPECIAL ASSESSMENT FUND 434,739 694,893 (260,154) 2,737,546 2,734,010
505 PARKING SYSTEM FUND 7,284,979 4,908,800 2,376,179 7,086,880 7,006,377
510 WATER FUND 16,369,488 11,297,127 5,072,361 11,635,156 9,109,942
515 SEWER FUND 10,268,414 8,308,734 1,959,679 5,997,434 3,057,745
520 SOLID WASTE FUND 3,470,367 2,820,678 649,689 (412,277) (909,916)
600 FLEET SERVICES FUND 2,007,675 2,065,484 (57,810) 283,533 (497,626)
601 EQUIPMENT REPLACEMENT FUND 931,377 1,002,787 (71,411) 778,108 778,108
605 INSURANCE FUND 12,057,098 14,323,171 (2,266,073) (6,604,578) (3,794,182)
223,557,759 159,802,753 63,755,006 112,931,644 104,666,437
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/City Treasurer
Ashley King, Budget & Finance Manager
Kate Lewis-Lakin, Senior Management Analyst
Subject: August 2018 Monthly Financial Report
Date: October 2, 2018
Please find attached the unaudited financial statements as of August 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 August 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 t ax) due
to the City and accounts payable/accrued expenses.
As of August 31, 2018, the General Fund is reporting a net surplus of $5,129,522 The
fund balance in the General Fund is $18,345,522 with a cash balance of $12,252,460.
The attached supplemental charts show the General Fund Revenues at 74.1% of
budget and expenses at 70.0%. Fund and cash balances have increased in August, due
primarily to receipt of the second installment of property taxes. To date, the General
Fund has received 96.5% of property tax revenue for the year.
Through August 31, 2018, the Good Neighbor Fund is showing a negative fund balance
of $663,178. 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 August 31, 2018, the SSA #4 Fund is showing a negative fund and cash
balance of $41,835.
Through August 31, 2018, the Capital Fund is showing a fund balance of $15,355,856
and a cash balance of $16,480,101. The fund continues to spend down balances from
the 2017A General Obligation Bonds that were received in October 2017. Proceeds
from the 2018B General Obligation Bonds were received in August, increasing fund and
cash balances.
Through August 31, 2018, the Crown Construction fund is showing a fund and cash
balance of $24,922,583. Proceeds from the 2018A General Obligation Bonds were
received in August, increasing fund and cash balances.
Through August 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 gallons. This issue is being
challenged in court.
Through August 31, 2018, the Solid Waste Fund has a negative fund balance of
$412,277 and a negative cash balance of $909,916. The Solid Waste Fund is receiving
property tax revenue for the first time in 2018, and has received $410,000 in Property
Taxes to date.
Through August 31, 2018, the Insurance Fund is showing a negative fund balance of
$6,604,578 and a negative cash balance of $3,794,182. 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 August 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 August
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$ 16,910,096$
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$ 18,345,522$
2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$ 6,169,276$ 7,179,518$ 10,652,102$
2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$ 10,816,697$ 12,252,460$
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
August YTD 2017
2018 2018 %Actuals
5,175,827 27,832,460 96.5% 28,294,363
3,780,981 33,009,897 66.4% 46,951,377
1,027,764 7,259,940 58.6% 13,357,911
394,838 2,490,528 64.1% 3,467,694
760,734 7,479,189 74.2% 8,754,025
618,143 4,945,141 63.8% 11,586,943
129,731 932,690 117.6% 1,234,749
47,629 1,141,537 87.8% 1,858,106
9,085 45,728 91.3% 38,544
11,944,730 85,137,109 74.1% 115,543,711
37,544 358,163 72.7% 498,172
19,270 138,108 72.0% 251,193
618,237 4,624,634 61.3% 7,539,496
55,319 448,649 60.9% 772,045
692,552 5,830,428 64.2% 9,314,164
233,623 2,068,822 57.2% 2,592,984
3,930,828 28,558,058 74.4% 39,067,047
2,620,354 18,692,907 78.1% 24,355,551
257,997 2,069,147 56.0% 3,071,334
1,443,233 8,589,582 71.8% 12,479,438
969,687 8,629,189 59.1% 13,983,314
10,878,642 80,007,686 70.0% 113,924,739
11,944,730 85,137,109 74.1% 115,543,711
10,878,642 80,007,686 70.0% 113,924,739
1,066,088 5,129,423 1,618,972
11,955,812
14,607,356
23,934,390
21 - COMMUNITY DEVELOPMENT
19 - ADMINISTRATIVE SERVICES
17 - LAW
15 - CITY MANAGER'S OFFICE
14 - CITY CLERK
40 - PUBLIC WORKS AGENCY
30 - PARKS, REC. AND COMMUNITY
24 - HEALTH
23 - FIRE MGMT & SUPPORT
22 - POLICE
3,697,529
736,346
9,075,303
3,614,774
38,391,099
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
EXPENSE TOTALS
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
114,237,796
REVENUE TOTALS 114,840,754
EXPENSE
7,540,597
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
Interest Income 50,100
492,806
191,784
13 - CITY COUNCIL
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Interfund Transfers 7,748,417
Licenses, Permits and Fees 12,397,400
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
August YTD 2017
2018 2018 %Actuals
75 2,143 100% 1,900
536,823 4,208,310 63.0% 6,303,624
347,253 2,778,027 65.9% 4,120,636
- - 0.0% -
14,534 237,418 122.8% 253,523
16,211 59,081 168.5% 62,067
914,896 7,284,979 65.4% 10,741,750
137,881 1,128,055 61.0% 1,675,404
431,310 2,257,330 65.4% 3,172,070
- 194,174 7.9% 280,311
26,637 213,099 66.7% 319,648
- - 0.0% 2,561,771
- - 0.0% 4,246
- 53,131 1.7% 267,734
13,269 102,734 33.8% 267,436
120,035 960,278 66.7% 1,584,683
729,133 4,908,800 38.1% 10,133,302
914,896 7,284,979 65.4% 10,741,750
729,133 4,908,800 32.6% 10,133,302
185,763 2,376,179 608,448
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Fund 505 - PARKING SYSTEM FUND (1,762,367)
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Fund 505 - PARKING SYSTEM FUND
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Capital Outlay 2,450,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
REVENUE TOTALS 11,134,126
EXPENSE
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Intergovernmental Revenue 12,125
Other Revenue 193,316
Interest Income 35,070
REVENUE
Licenses, Permits and Fees -
Charges for Services 6,676,575
Interfund Transfers 4,217,040
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Fund 505 - PARKING SYSTEM FUND
August YTD 2017
2018 2018 %Actuals
7,986 38,928 55.6% 86,063
1,336,987 11,021,078 60.3% 17,255,947
5,144,317 5,187,245 19.0% 294,812
6,501 122,237 488.9% 35,784
6,495,791 16,369,488 35.8% 17,672,605
433,403 3,525,006 62.8% 5,958,873
324,732 1,933,641 41.5% 2,528,863
1,575,020 2,605,911 8.9% (192,125)
39,041 312,328 66.7% 468,492
- - 0.0% 2,470,280
- - 0.0% -
- 465,369 23.7% 717,388
- - 0.0% 2
306,859 2,454,873 68.1% 6,327,314
2,679,056 11,297,128 24.7% 18,279,088
6,495,791 16,369,488 35.8% 17,672,605
2,679,056 11,297,128 24.7% 18,279,088
3,816,735 5,072,361 (606,483) Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
EXPENSE TOTALS 45,663,506
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Services and Supplies 4,655,410
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
Interest Income 25,000
REVENUE TOTALS 45,695,656
EXPENSE
Salary and Benefits 5,614,331
REVENUE
Licenses, Permits and Fees 70,000
Charges for Services 18,267,000
Other Revenue 27,333,656
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Fund 510 - WATER FUND
August YTD 2017
2018 2018 %Actuals
1,460,369 8,741,506 69.4% 12,477,657
- - 0.0% -
1,504,154 1,504,154 71.5% 14,870
4,202 22,753 455.1% 16,023
2,968,726 10,268,414 69.9% 12,508,550
107,383 842,151 66.1% 1,313,154
23,590 86,474 3.4% 88,677
364,076 705,507 32.3% 16,941
22,499 179,992 66.7% 269,988
- - 0.0% 3,530,787
1,914,491 5,833,492 77.4% 1,143,643
- - 0.0% -
82,640 661,118 66.7% 1,141,676
2,514,679 8,308,734 56.1% 7,504,867
2,968,726 10,268,414 69.9% 12,508,550
2,514,679 8,308,734 56.1% 7,504,867
454,047 1,959,679 5,003,683
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Fund 515 - SEWER FUND Totals (119,220)
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Fund 515 - SEWER FUND Totals
Depreciation Expense -
Debt Service 7,540,066
Miscellaneous 1,500
Services and Supplies 2,558,630
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Interest Income 5,000
REVENUE TOTALS 14,698,650
EXPENSE
Salary and Benefits 1,274,709
REVENUE
Charges for Services 12,589,650
Interfund Transfers -
Other Revenue 2,104,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Fund 515 - SEWER FUND
August YTD 2017
2018 2018 %Actuals
54,132 410,000 100.0% -
51,833 168,343 44.9% 329,039
308,059 2,335,497 62.6% 3,699,121
58,831 470,645 66.7% 755,967
2,686 85,883 226.0% 33,348
475,540 3,470,367 66.0% 4,817,475
75,998 617,330 62.1% 890,220
67,755 1,974,107 56.6% 3,482,141
2,958 9,981 3.6% 24,635
- 665 3.1% 1,797
- 3,688 49.2% 3,057
26,864 214,908 66.7% 504,807
173,575 2,820,678 55.2% 4,906,657
475,540 3,470,367 66.0% 4,817,475
173,575 2,820,678 55.2% 4,906,657
301,966 649,689 (89,182)
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND 151,660
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND
REVENUE TOTALS 5,261,361
Debt Service 21,797
Miscellaneous 7,500
Interfund Transfers 322,362
Capital Outlay 275,750
Interfund Transfers 705,967
Other Revenue 38,000
REVENUE TOTALS 5,261,361
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Charges for Services 3,732,394
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 375,000
August YTD 2017
2018 2018 Actuals
5,175,827 27,832,460 28,294,363
3,780,981 33,009,897 46,951,377
1,027,764 7,259,940 13,357,911
394,838 2,490,528 3,467,694
760,734 7,479,189 8,754,025
618,143 4,945,141 11,586,943
129,731 932,690 1,234,749
47,629 1,141,537 1,858,106
9,085 45,728 38,544
11,944,730 85,137,109 115,543,711
5,460,886 45,804,613 71,659,904
1,289,457 7,882,881 13,414,590
13,915 94,918 361,427
3,420,646 20,598,029 20,883,996
- 42,594 124,131
- 106 4,090
54,228 468,464 835,363
639,510 5,116,080 6,641,237
10,878,642 80,007,686 113,924,739
11,944,730 85,137,109 115,543,711
10,878,642 80,007,686 113,924,739
1,066,088 5,129,423 1,618,972
Starting Fund Balance 13,216,099 13,216,099
Net Change 602,958 5,129,423
Ending Fund Balance 13,819,057 18,345,522
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals
Miscellaneous 1,015,317
Interfund Transfers 7,704,802
Community Sponsored Organizations 123,886
Contingencies 208,500
Services and Supplies 12,367,791
Capital Outlay 354,000
Insurance and Other Chargebacks 22,287,563
REVENUE TOTALS 114,840,754
EXPENSE
Salary and Benefits 70,175,937
Interest Income 50,100
Interfund Transfers 7,748,417
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
Licenses, Permits and Fees 12,397,400
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 1 of 35
August YTD 2017
2018 2018 Actuals
164,928 901,405 933,020
82 12,393 33,019
1,208 4,263 1,548
166,219 918,061 967,586
31,097 251,748 324,972
49,506 363,771 579,392
- 4,120 5,110
80,603 619,640 909,475
166,219 918,061 967,586
80,603 619,640 909,475
85,616 298,421 58,111
Starting Fund Balance 644,499 644,499
Net Change (312,421) 298,421
Ending Fund Balance 332,078 942,920
REVENUE TOTALS 953,500
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND (312,421)
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND
Miscellaneous 7,000
Services and Supplies 858,200
REVENUE TOTALS 953,500
EXPENSE
Salary and Benefits 400,721
Interest Income 1,000
Other Revenue 27,500
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 925,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 2 of 35
August YTD 2017
2018 2018 Actuals
69,039 552,314 859,153
20 171 14
69,059 552,485 859,167
- (22,593) 22,593
3 28,820 121
13,606 432,911 918,074
- 5,000 -
13,609 444,137 940,789
69,059 552,485 859,167
13,609 444,137 940,789
55,450 108,348 (81,622)
Starting Fund Balance (10,815) (10,815)
Net Change (30,682) 108,348
Ending Fund Balance (41,497) 97,533
Fund 176 - HEALTH AND HUMAN (30,682)
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 828,471
EXPENSE TOTALS 859,153
Miscellaneous -
EXPENSE TOTALS 859,153
Services and Supplies 859,153
Community Sponsored Organizations -
REVENUE TOTALS 828,471
EXPENSE
Salary and Benefits -
Interest Income -
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Interfund Transfers 828,471
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 3 of 35
August YTD 2017
2018 2018 Actuals
- - 1,000,000
198 1,685 1,884
198 1,685 1,001,884
32 80 -
83,333 666,667 1,000,000
83,365 666,747 1,000,000
198 1,685 1,001,884
83,365 666,747 1,000,000
(83,167) (665,062) 1,884
Starting Fund Balance 1,884 1,884
Net Change - (665,062)
Ending Fund Balance 1,884 (663,178)
Fund 180 - GOOD NEIGHBOR FUND Totals -
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
REVENUE TOTALS 1,000,000
EXPENSE
Services and Supplies -
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
Interest Income -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 4 of 35
August YTD 2017
2018 2018 Actuals
1,196,741 6,514,079 6,370,507
8,836 69,133 122,862
47 236 338
5,833 46,667 190,200
95,576 201,368 74,206
1,264 44,599 70,807
18,450 131,501 362,608
4,676 17,075 5,169
1,331,425 7,024,657 7,196,696
379,232 3,157,949 4,739,145
113,884 945,575 1,712,359
- 492 9,904
- - 22
30,579 244,633 343,618
523,695 4,348,648 6,805,048
1,331,425 7,024,657 7,196,696
523,695 4,348,648 6,805,048
807,730 2,676,008 391,648
Starting Fund Balance 1,042,304 1,042,304
Net Change 216,912 2,676,008
Ending Fund Balance 1,259,216 3,718,312
REVENUE TOTALS 7,693,209
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals 216,912
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals
Miscellaneous -
Interfund Transfers 366,949
Salary and Benefits 5,074,260
Services and Supplies 2,024,688
Capital Outlay 10,400
Interest Income 5,400
REVENUE TOTALS 7,693,209
EXPENSE
Intergovernmental Revenue 152,418
Other Revenue 130,000
Library Revenue 324,620
Fines and Forfeitures 130,000
Charges for Services -
Interfund Transfers 265,771
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,685,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 5 of 35
August YTD 2017
2018 2018 Actuals
61,290 333,529 338,897
2,157,728 2,157,728 778,745
- - 7
2,219,018 2,491,257 1,117,649
22,350 22,350 8,587
- 54,962 1,134,570
- - 112
22,350 77,312 1,143,269
2,219,018 2,491,257 1,117,649
22,350 77,312 1,143,269
2,196,668 2,413,945 (25,619)
Starting Fund Balance 4,089 4,089
Net Change 12,386 2,413,945
Ending Fund Balance 16,475 2,418,034
EXPENSE TOTALS 333,404
Fund 186 - LIBRARY DEBT SERVICE FUND 12,386
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE TOTALS 345,790
Interfund Transfers -
EXPENSE TOTALS 333,404
Services and Supplies -
Debt Service 333,404
Interest Income -
REVENUE TOTALS 345,790
EXPENSE
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 345,790
Other Revenue -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 6 of 35
August YTD 2017
2018 2018 Actuals
- - 1,431,106
- - 1,431,106
- - 30,790
9,831 16,664 1,091,917
9,831 16,664 1,122,708
- - 1,431,106
9,831 16,664 1,122,708
(9,831) (16,664) 308,399
Starting Fund Balance 308,399 308,399
Net Change - (16,664)
Ending Fund Balance 308,399 291,735
Fund 187 - LIBRARY CAPITAL -
Fund 187 - LIBRARY CAPITAL
REVENUE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
Services and Supplies -
Capital Outlay 10,095,000
REVENUE TOTALS 10,095,000
EXPENSE
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Other Revenue 10,095,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 7 of 35
August YTD 2017
2018 2018 Actuals
16,138 32,755 37,641
150 430 -
16,288 33,185 37,641
2,208 17,997 26,454
5 1,870 1,860
2,135 7,008 2,642
- (5,369) (233)
- 1,784 2,400
388 3,103 4,518
4,736 26,393 37,641
16,288 33,185 37,641
4,736 26,393 37,641
11,552 6,793 -
Starting Fund Balance - -
Net Change 326 6,793
Ending Fund Balance 326 6,793
EXPENSE TOTALS 94,821
Fund 195 - NEIGHBORHOOD 326
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 95,147
Miscellaneous 50,000
Interfund Transfers 4,654
EXPENSE TOTALS 94,821
Capital Outlay 7,000
Insurance and Other Chargebacks -
EXPENSE
Salary and Benefits 28,067
Services and Supplies 5,100
Interest Income -
REVENUE TOTALS 95,147
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Intergovernmental Revenue 95,147
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 8 of 35
August YTD 2017
2018 2018 Actuals
168,855 1,264,023 1,899,884
3,146 26,995 18,158
172,001 1,291,018 1,918,041
125,000 1,000,000 -
79,833 638,660 957,990
204,833 1,638,660 957,990
172,001 1,291,018 1,918,041
204,833 1,638,660 957,990
(32,832) (347,642) 960,051
Starting Fund Balance 2,373,730 2,373,730
Net Change (535,990) (347,642)
Ending Fund Balance 1,837,740 2,026,088
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
Interfund Transfers 957,990
EXPENSE TOTALS 2,457,990
EXPENSE
Capital Outlay 1,500,000
Interest Income 12,000
REVENUE TOTALS 1,922,000
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,910,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 9 of 35
August YTD 2017
2018 2018 Actuals
123,130 935,068 978,523
- 863 -
1,313 8,453 7,178
124,442 944,383 985,701
43,538 381,374 585,510
9,013 157,717 239,161
- - 51,670
1,454 11,632 17,448
6,114 48,911 72,977
60,120 599,634 966,766
124,442 944,383 985,701
60,120 599,634 966,766
64,322 344,750 18,935
Starting Fund Balance 181,996 181,996
Net Change 8,262 344,750
Ending Fund Balance 190,258 526,746
Fund 205 - EMERGENCY TELEPHONE 8,262
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,051,700
EXPENSE TOTALS 1,043,438
Interfund Transfers 73,366
EXPENSE TOTALS 1,043,438
Capital Outlay 55,000
Insurance and Other Chargebacks 17,448
EXPENSE
Salary and Benefits 615,224
Services and Supplies 282,400
Other Revenue -
Interest Income 1,000
REVENUE TOTALS 1,051,700
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,050,700
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 10 of 35
August YTD 2017
2018 2018 Actuals
113,414 341,934 322,477
- 25 5
113,414 341,959 322,482
- 185,000 329,000
- 185,000 329,000
113,414 341,959 322,482
- 185,000 329,000
113,414 156,959 (6,518)
Starting Fund Balance (198,794) (198,794)
Net Change - 156,959
Ending Fund Balance (198,794) (41,835)
EXPENSE TOTALS 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) -
Fund 210 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 370,000
EXPENSE TOTALS 370,000
REVENUE TOTALS 370,000
EXPENSE
Services and Supplies 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 370,000
Interest Income -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 11 of 35
August YTD 2017
2018 2018 Actuals
416,279 430,838 1,906,708
- 4,004 262
416,279 434,841 1,906,970
35,037 281,606 431,440
38 3,519 3,797
- 14,558 645,289
1,454 134,277 392,279
- - 318,412
- 15,174 95,606
746 5,970 20,145
37,275 455,105 1,906,970
416,279 434,841 1,906,970
37,275 455,105 1,906,970
379,004 (20,263) -
Starting Fund Balance 64,107 64,107
Net Change (109,388) (20,263)
Ending Fund Balance (45,281) 43,844
EXPENSE TOTALS 2,439,512
Fund 215 - CDBG FUND Totals (109,388)
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,330,124
Miscellaneous 569,970
Interfund Transfers 949,656
EXPENSE TOTALS 2,439,512
Community Sponsored Organizations 175,500
Services and Supplies 220,840
Capital Outlay -
Insurance and Other Chargebacks 20,648
REVENUE TOTALS 2,330,124
EXPENSE
Salary and Benefits 502,898
Intergovernmental Revenue 2,330,124
Other Revenue -
Fund 215 - CDBG FUND
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 12 of 35
August YTD 2017
2018 2018 Actuals
3,101 78,453 51,369
95 790 3,391
3,196 79,244 54,760
4,995 90,387 13,070
4,995 90,387 13,070
3,196 79,244 54,760
4,995 90,387 13,070
(1,799) (11,143) 41,690
Starting Fund Balance 252,612 252,612
Net Change - (11,143)
Ending Fund Balance 252,612 241,469
Fund 220 - CDBG LOAN FUND Totals -
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 293,000
EXPENSE TOTALS 293,000
EXPENSE TOTALS 293,000
Services and Supplies 293,000
Interest Income -
REVENUE TOTALS 293,000
EXPENSE
Fund 220 - CDBG LOAN FUND
REVENUE
Other Revenue 293,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 13 of 35
August YTD 2017
2018 2018 Actuals
80 429 256
80 429 256
13 29 -
- - -
13 29 -
80 429 256
13 29 -
68 399 256
Starting Fund Balance 170,171 170,171
Net Change (100,000) 399
Ending Fund Balance 70,171 170,570
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (100,000)
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS -
Miscellaneous 100,000
EXPENSE TOTALS 100,000
Services and Supplies -
Interest Income -
REVENUE TOTALS -
EXPENSE
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 14 of 35
August YTD 2017
2018 2018 Actuals
91,161 174,817 227,450
2,282 23,530 21,820
55 127 5,685
93,498 198,473 254,955
2,510 23,562 43,994
65,356 163,624 231,806
68 7,087 (27,871)
- - 126
67,934 194,273 248,055
93,498 198,473 254,955
67,934 194,273 248,055
25,564 4,201 6,900
Starting Fund Balance 9,277 9,277
Net Change 615 4,201
Ending Fund Balance 9,892 13,478
EXPENSE TOTALS 588,321
Fund 240 - HOME FUND Totals 615
Fund 240 - HOME FUND Totals
REVENUE TOTALS 588,936
Miscellaneous 500
EXPENSE TOTALS 588,321
Insurance and Other Chargebacks 820
Salary and Benefits 46,801
Services and Supplies 540,200
Interest Income -
REVENUE TOTALS 588,936
EXPENSE
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 588,936
Other Revenue -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 15 of 35
August YTD 2017
2018 2018 Actuals
- 34,050 97,000
417 65,833 333,056
1,252 7,702 5,623
1,669 107,586 435,678
6,181 52,691 44,432
82 34,107 209,772
- 25,674 11,532
3,042 9,526 8,927
2,536 16,943 85,660
11,841 138,942 360,323
1,669 107,586 435,678
11,841 138,942 360,323
(10,171) (31,357) 75,355
Starting Fund Balance 1,476,544 1,476,544
Net Change (38,470) (31,357)
Ending Fund Balance 1,438,074 1,445,188
Fund 250 - AFFORDABLE HOUSING FUND (38,470)
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE TOTALS 450,830
EXPENSE TOTALS 489,300
EXPENSE TOTALS 489,300
Community Sponsored Organizations 70,000
Miscellaneous 43,000
Services and Supplies 279,500
Insurance and Other Chargebacks -
REVENUE TOTALS 450,830
EXPENSE
Salary and Benefits 96,800
Other Revenue 400,600
Interest Income 230
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 50,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 16 of 35
August YTD 2017
2018 2018 Actuals
1,175,132 5,693,666 5,249,949
3,401 24,766 45,924
1,178,533 5,718,432 5,295,873
- - 2,007
- 49,336 98,672
592,253 4,738,027 5,557,325
592,253 4,787,363 5,658,005
1,178,533 5,718,432 5,295,873
592,253 4,787,363 5,658,005
586,280 931,069 (362,132)
Starting Fund Balance 5,262,544 5,262,544
Net Change (3,437,040) 931,069
Ending Fund Balance 1,825,504 6,193,613
EXPENSE TOTALS 9,207,040
Fund 300 - WASHINGTON NATIONAL TIF (3,437,040)
Fund 300 - WASHINGTON NATIONAL TIF
REVENUE TOTALS 5,770,000
Miscellaneous 100,000
Interfund Transfers 7,107,040
EXPENSE TOTALS 9,207,040
Services and Supplies 2,000,000
REVENUE TOTALS 5,770,000
EXPENSE
Interest Income 20,000
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,750,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 17 of 35
August YTD 2017
2018 2018 Actuals
1,924,332 10,395,873 10,797,411
288,930 2,493,101 2,895,561
7,219 57,749 -
7,106,441 7,106,441 8,966,396
16,998 62,935 36,782
9,343,919 20,116,100 22,696,150
43,884 43,889 100,625
7,001,917 9,057,278 23,099,797
- - (57)
7,045,801 9,101,167 23,200,365
9,343,919 20,116,100 22,696,150
7,045,801 9,101,167 23,200,365
2,298,118 11,014,933 (504,215)
Starting Fund Balance 241,781 241,781
Net Change 128,349 11,014,933
Ending Fund Balance 370,130 11,256,714
REVENUE TOTALS 14,425,606
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals 128,349
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals
Debt Service 14,177,257
Miscellaneous -
REVENUE TOTALS 14,425,606
EXPENSE
Services and Supplies 120,000
Intergovernmental Revenue 83,292
Other Revenue -
Interest Income 1,500
Fund 320 - DEBT SERVICE FUND
REVENUE
Property Taxes 10,879,993
Interfund Transfers 3,460,821
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 18 of 35
August YTD 2017
2018 2018 Actuals
264,904 621,996 583,827
3,602,526 3,662,096 32,000
5 67 22
3,867,436 4,284,159 615,848
40,344 269,399 307,391
156,434 1,069,597 -
130 877 995
5,000 40,000 60,000
201,908 1,379,873 368,386
3,867,436 4,284,159 615,848
201,908 1,379,873 368,386
3,665,528 2,904,286 247,462
Starting Fund Balance 247,378 247,378
Net Change (296,100) 2,904,286
Ending Fund Balance (48,722) 3,151,664
Fund 330 - HOWARD-RIDGE TIF FUND (296,100)
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE TOTALS 4,385,400
EXPENSE TOTALS 4,681,500
Interfund Transfers 60,000
EXPENSE TOTALS 4,681,500
Debt Service 960,000
Services and Supplies 461,500
Capital Outlay 3,200,000
Interest Income 400
REVENUE TOTALS 4,385,400
EXPENSE
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 605,000
Other Revenue 3,780,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 19 of 35
August YTD 2017
2018 2018 Actuals
73,282 210,609 43,503
1,028 7,198 12,339
1,026 5,232 3,898
75,336 223,039 59,741
494 1,526 2,007
1,601 10,782 12,227
2,500 20,000 30,000
4,594 32,308 44,235
75,336 223,039 59,741
4,594 32,308 44,235
70,742 190,731 15,506
Starting Fund Balance 432,766 432,766
Net Change (39,850) 190,731
Ending Fund Balance 392,916 623,497
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Fund 335 - WEST EVANSTON TIF FUND
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Debt Service 10,000
Services and Supplies -
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes -
Other Revenue -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 20 of 35
August YTD 2017
2018 2018 Actuals
- 136,927 48,001
- - 2,067,512
7 10 1
7 136,937 2,115,514
494 1,526 38,588
- - 2,053,521
- 74,104 -
494 75,630 2,092,108
7 136,937 2,115,514
494 75,630 2,092,108
(487) 61,307 23,406
Starting Fund Balance (6,009) (6,009)
Net Change 202,334 61,307
Ending Fund Balance 196,325 55,298
Fund 340 - DEMPSTER-DODGE TIF FUND 202,334
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE TOTALS 275,000
EXPENSE TOTALS 72,666
Interfund Transfers -
EXPENSE TOTALS 72,666
Services and Supplies -
Debt Service 72,666
Interest Income -
REVENUE TOTALS 275,000
EXPENSE
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes 275,000
Other Revenue -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 21 of 35
August YTD 2017
2018 2018 Actuals
10,240 219,346 75,430
- - 3,520,189
17 20 9
10,257 219,366 3,595,628
494 1,526 58,113
- - 580,000
- - 3,031,398
- 107,561 -
494 109,087 3,669,511
10,257 219,366 3,595,628
494 109,087 3,669,511
9,763 110,279 (73,884)
Starting Fund Balance 61,193 61,193
Net Change 316,001 110,279
Ending Fund Balance 377,194 171,472
Fund 345 - CHICAGO-MAIN TIF Totals 316,001
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 425,000
EXPENSE TOTALS 108,999
Interfund Transfers -
EXPENSE TOTALS 108,999
Services and Supplies -
Capital Outlay -
Debt Service 108,999
Interest Income -
REVENUE TOTALS 425,000
EXPENSE
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 425,000
Other Revenue -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 22 of 35
August YTD 2017
2018 2018 Actuals
56,731 113,694 215,245
7 25 21
56,738 113,720 215,266
- - 213,354
- - 78,000
- - 291,354
56,738 113,720 215,266
- - 291,354
56,738 113,720 (76,088)
Starting Fund Balance 2,207 2,207
Net Change - 113,720
Ending Fund Balance 2,207 115,927
Fund 350 - SPECIAL SERVICE AREA (SSA) -
Fund 350 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 221,500
EXPENSE TOTALS 221,500
Interfund Transfers -
EXPENSE TOTALS 221,500
REVENUE TOTALS 221,500
EXPENSE
Services and Supplies 221,500
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 221,000
Interest Income 500
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 23 of 35
August YTD 2017
2018 2018 Actuals
- - 359,706
1,016 43,980 33,339
536,667 4,293,333 787,177
- 51,221 530,812
10,274,896 10,274,896 11,246,149
14,459 78,326 56,607
10,827,038 14,741,757 13,013,790
51,383 409,157 5,392
132,971 637,402 1,672,608
957,178 6,764,481 13,582,482
41,667 333,333 500,000
1,183,200 8,144,374 15,760,481
10,827,038 14,741,757 13,013,790
1,183,200 8,144,374 15,760,481
9,643,838 6,597,383 (2,746,691)
Starting Fund Balance 8,758,473 8,758,473
Net Change (7,655,527) 6,597,383
Ending Fund Balance 1,102,946 15,355,856
REVENUE TOTALS 22,642,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS (7,655,527)
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS
Interfund Transfers 500,000
Salary and Benefits 85,527
Services and Supplies -
Capital Outlay 29,712,000
Interest Income -
REVENUE TOTALS 22,642,000
EXPENSE
Interfund Transfers 6,450,000
Intergovernmental Revenue 4,190,000
Other Revenue 12,002,000
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 24 of 35
August YTD 2017
2018 2018 Actuals
- - 649,512
25,615,251 25,614,849 900,000
8,894 8,894 -
25,624,144 25,623,743 1,549,512
220,463 1,230,251 638,727
- 11,770 369,924
- - -
220,463 1,242,021 1,008,651
25,624,144 25,623,743 1,549,512
220,463 1,242,021 1,008,651
25,403,682 24,381,722 540,861
Starting Fund Balance 540,861 540,861
Net Change 1,866,000 24,381,722
Ending Fund Balance 2,406,861 24,922,583
REVENUE TOTALS 11,500,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION FUND 1,866,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION FUND
Capital Outlay 8,000,000
Debt Service -
REVENUE TOTALS 11,500,000
EXPENSE
Services and Supplies 1,634,000
Interfund Transfers -
Other Revenue 11,500,000
Interest Income -
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 25 of 35
August YTD 2017
2018 2018 Actuals
277,004 277,004 -
6,752 32,361 31,207
1,563 125,375 237,012
285,319 434,739 268,219
5,926 46,939 694
1,923 1,933 5,613
303,736 303,736 -
42,786 342,285 263,427
354,371 694,893 269,734
285,319 434,739 268,219
354,371 694,893 269,734
(69,052) (260,154) (1,516)
Starting Fund Balance 2,997,700 2,997,700
Net Change (123,850) (260,154)
Ending Fund Balance 2,873,850 2,737,546
REVENUE TOTALS 461,367
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND (123,850)
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND
Debt Service -
Interfund Transfers 513,427
Services and Supplies -
REVENUE TOTALS 461,367
EXPENSE
Salary and Benefits 71,790
Interest Income 31,200
Special Assessment 180,167
Other Revenue 250,000
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 26 of 35
August YTD 2017
2018 2018 Actuals
75 2,143 1,900
536,823 4,208,310 6,303,624
347,253 2,778,027 4,120,636
- - -
14,534 237,418 253,523
16,211 59,081 62,067
914,896 7,284,979 10,741,750
137,881 1,128,055 1,675,404
431,310 2,257,330 3,172,070
- 194,174 280,311
26,637 213,099 319,648
- - 2,561,771
- - 4,246
- 53,131 267,734
13,269 102,734 267,436
120,035 960,278 1,584,683
729,133 4,908,800 10,133,302
914,896 7,284,979 10,741,750
729,133 4,908,800 10,133,302
185,763 2,376,179 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,376,179
Ending Fund Balance 2,948,334 7,086,880
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
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Capital Outlay 2,450,000
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue 193,316
Licenses, Permits and Fees -
Charges for Services 6,676,575
Fund 505 - PARKING SYSTEM FUND
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 27 of 35
August YTD 2017
2018 2018 Actuals
7,986 38,928 86,063
1,336,987 11,021,078 17,255,947
5,144,317 5,187,245 294,812
6,501 122,237 35,784
6,495,791 16,369,488 17,672,605
433,403 3,525,006 5,958,873
324,732 1,933,641 2,528,863
1,575,020 2,605,911 (192,125)
39,041 312,328 468,492
- - 2,470,280
- - -
- 465,369 717,388
- - 2
306,859 2,454,873 6,327,314
2,679,056 11,297,128 18,279,088
6,495,791 16,369,488 17,672,605
2,679,056 11,297,128 18,279,088
3,816,735 5,072,361 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 5,072,361
Ending Fund Balance 6,594,945 11,635,156
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
Charges for Services 18,267,000
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 28 of 35
August YTD 2017
2018 2018 Actuals
1,460,369 8,741,506 12,477,657
- - -
1,504,154 1,504,154 14,870
4,202 22,753 16,023
2,968,726 10,268,414 12,508,550
107,383 842,151 1,313,154
23,590 86,474 88,677
364,076 705,507 16,941
22,499 179,992 269,988
- - 3,530,787
1,914,491 5,833,492 1,143,643
- - -
82,640 661,118 1,141,676
2,514,679 8,308,734 7,504,867
2,968,726 10,268,414 12,508,550
2,514,679 8,308,734 7,504,867
454,047 1,959,679 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 1,959,679
Ending Fund Balance 3,918,535 5,997,434
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Debt Service 7,540,066
Miscellaneous 1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
Interfund Transfers -
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 29 of 35
August YTD 2017
2018 2018 Actuals
54,132 410,000 - -
51,833 168,343 329,039
308,059 2,335,497 3,699,121
58,831 470,645 755,967
2,686 85,883 33,348
475,540 3,470,367 4,817,475
75,998 617,330 890,220
67,755 1,974,107 3,482,141
2,958 9,981 24,635
- 665 1,797
- 3,688 3,057
26,864 214,908 504,807
173,575 2,820,678 4,906,657
475,540 3,470,367 4,817,475
173,575 2,820,678 4,906,657
301,966 649,689 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 649,689
Ending Fund Balance (910,306) (412,277)
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
Debt Service 21,797
Capital Outlay 275,750
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Other Revenue 38,000
REVENUE TOTALS 5,261,361
Charges for Services 3,732,394
Interfund Transfers 705,967
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 375,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 30 of 35
August YTD 2017
2018 2018 Actuals
249,053 1,992,427 2,478,435
2,720 15,224 19,016
- 24 339
251,773 2,007,675 2,497,791
80,513 673,190 1,154,569
224,126 1,369,999 1,744,972
- - -
2,787 22,295 27,833
307,426 2,065,484 2,927,375
251,773 2,007,675 2,497,791
307,426 2,065,484 2,927,375
(55,653) (57,810) (429,584)
Starting Fund Balance 341,343 341,343
Net Change (262,450) (57,810)
Ending Fund Balance 78,893 283,533
EXPENSE TOTALS 3,333,871
Fund 600 - FLEET SERVICES FUND Totals (262,450)
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,071,421
Interfund Transfers 33,442
EXPENSE TOTALS 3,333,871
Contingencies 450
Services and Supplies 2,230,057
REVENUE TOTALS 3,071,421
EXPENSE
Salary and Benefits 1,069,922
Other Revenue 81,781
Interest Income 1,000
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 2,988,640
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 31 of 35
August YTD 2017
2018 2018 Actuals
111,228 889,821 1,400,057
19,845 39,603 88,015
472 1,952 2,128
131,545 931,377 1,490,200
3,448 22,156 74,539
349,811 980,631 -
- - 1,780,829
353,259 1,002,787 1,855,367
131,545 931,377 1,490,200
353,259 1,002,787 1,855,367
(221,714) (71,411) (365,167)
Starting Fund Balance 849,519 849,519
Net Change (53,028) (71,411)
Ending Fund Balance 796,491 778,108
EXPENSE TOTALS 1,597,977
Fund 601 - EQUIPMENT REPLACEMENT (53,028)
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,544,949
Depreciation Expense -
EXPENSE TOTALS 1,597,977
EXPENSE
Services and Supplies 75,000
Capital Outlay 1,522,977
Other Revenue 210,217
Interest Income -
REVENUE TOTALS 1,544,949
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,334,732
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 32 of 35
August YTD 2017
2018 2018 Actuals
13,534 113,555 162,411
- - 2,300,000
870,136 6,770,304 10,926,377
174,042 1,397,198 1,032,678
515,954 3,773,466 5,611,626
478 2,575 382
1,574,144 12,057,098 20,033,473
33,875 393,245 606,021
290,367 2,984,839 3,594,432
28,211 28,211 -
1,323,176 10,910,456 17,164,869
803 6,421 9,632
1,676,431 14,323,171 21,374,954
1,574,144 12,057,098 20,033,473
1,676,431 14,323,171 21,374,954
(102,288) (2,266,073) (1,341,481)
Starting Fund Balance (4,338,505) (4,338,505)
Net Change 653,342 (2,266,073)
Ending Fund Balance (3,685,163) (6,604,578)
EXPENSE TOTALS 18,439,931
Fund 605 - INSURANCE FUND Totals 653,342
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 19,093,273
Interfund Transfers 9,632
EXPENSE TOTALS 18,439,931
Capital Outlay -
Insurance and Other Chargebacks 15,315,824
EXPENSE
Salary and Benefits 729,027
Services and Supplies 2,385,448
Insurance 5,811,177
Interest Income 1,000
REVENUE TOTALS 19,093,273
Other Revenue 10,867,028
Workers Compensation and Liability 2,196,415
Fund 605 - INSURANCE FUND
REVENUE
Charges for Services 162,411
Interfund Transfers 55,242
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 33 of 35
August YTD 2017
2018 2018 Actuals
- - -
- - -
2,569,832 10,676,137 15,225,459
85,891 942,996 2,065,885
2,655,723 11,619,133 17,291,343
798,618 6,098,028 8,682,009
2,720 34,117 136,256
801,337 6,132,145 8,818,265
2,655,723 11,619,133 17,291,343
801,337 6,132,145 8,818,265
1,854,386 5,486,988 8,473,079
Starting Fund Balance 79,073,077 79,073,077
Net Change 4,989,947 5,486,988
Ending Fund Balance 84,063,024 84,560,065
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
Miscellaneous -
EXPENSE TOTALS 8,795,000
REVENUE TOTALS 13,784,947
EXPENSE
Salary and Benefits 8,795,000
Interfund Transfers 10,000
Other Revenue 9,394,947
Interest Income 4,100,000
Fund 700 - FIRE PENSION FUND
REVENUE
Other Taxes 280,000
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 34 of 35
August YTD 2017
2018 2018 Actuals
- - -
4,393,785 15,912,889 24,497,983
167,365 1,741,225 2,829,084
4,561,150 17,654,114 27,327,068
1,010,867 7,981,923 11,624,574
11,165 192,099 264,371
1,022,032 8,174,022 11,888,945
4,561,150 17,654,114 27,327,068
1,022,032 8,174,022 11,888,945
3,539,118 9,480,092 15,438,122
Starting Fund Balance 121,629,667 121,629,667
Net Change 6,194,704 9,480,092
Ending Fund Balance 127,824,371 131,109,759
REVENUE TOTALS 18,719,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals 6,194,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals
Miscellaneous 270,000
REVENUE TOTALS 18,719,704
EXPENSE
Salary and Benefits 12,255,000
Interfund Transfers 57,000
Other Revenue 12,162,704
Interest Income 6,500,000
Fund 705 - POLICE PENSION FUND
REVENUE
Budget by Organization Report
Through 08/31/18
Prior Fiscal Year Activity Included
Detail Listing
2018
Classification Budget
Run by Kate LewisLakin on 10/02/2018 09:58:08 AM Page 35 of 35