HomeMy WebLinkAbout2016.12 December Monthly ReportAttachment 1: December 2016 Monthly Financial Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley King, Finance & Budget Manager
Subject: December 2016 Monthly Financial Report
Date: February 22, 2017
Please find attached the unaudited financial statements as of December 31, 2016. A
summary by fund for revenues, expenditures, fund and cash balances is as follows:
YTD
Revenues YTD Expenses YTD Net
YTD Fund
Balance
YTD Cash
Balance
112,354,935 111,150,697 1,204,238 11,909,074 5,370,342
884,794 849,394 35,400 35,400 70,806
878,006 806,600 71,406 584,645 589,098
1,000,000 1,000,000 ()(0) 1,000,000
7,008,429 6,667,696 340,733 760,818 879,204
63,157 91,447 (28,289)(28,289) 92,669
1,903,074 2,319,789 (416,715)1,413,678 1,236,977
890,046 1,429,460 (539,414)12,304
321,268 323,000 (1,732)(192,276)
2,026,675 2,022,452 4,224 64,106
217,817 218,521 (704)157,661 52,816
2,564,472 2,232,536 331,936 2,887,918 2,614,100
169,915 169,915
273,784 276,177 (2,393)2,377
633,250 226,207 407,043 1,400,923 1,405,965
390,978 439,491 (48,513)(11,849) 328,633
4,743,661 4,561,415 182,246 6,624,676 6,728,527
(145) 525,284 (525,429)-
1,235,994 1,873,437 (637,443)473,064 701,026
815,787 787,249 28,537 (84) 82,737
12,995 37,998 (25,003)417,260 425,582
29,415 (29,415)(29,415)
1,580,000 1,756,993 (176,993)135,077 135,077
21,754,356 23,294,416 (1,540,061)746,055 1,048,486
223,298 145,003 78,294 78,294 165,699
15,675,519 11,558,743 4,116,776 9,633,817 13,124,676
685,884 369,449 316,435 2,999,216 2,996,021
10,436,695 9,727,700 708,995 11,486,869 8,425,983
24,473,951 28,405,732 (3,931,781)5,291,422 6,024,908
13,056,297 4,842,356 8,213,941 5,693,921 3,443,030
5,042,632 4,740,573 302,059 (926,498)
3,402,094 2,994,316 407,779 773,239 274,674
1,501,041 1,495,009 6,032 1,283,721 1,266,754
17,072,851 17,347,460 (274,609)(639,105) 1,749,678
TOTALS 253,123,596 244,546,014 8,577,582 63,207,936 60,403,383
605 INSURANCE FUND
600 FLEET SERVICES FUND
601 EQUIPMENT REPLACEMENT FUND
515 SEWER FUND
520 SOLID WASTE FUND
510 WATER FUND
420 SPECIAL ASSESSMENT FUND
505 PARKING SYSTEM FUND
320 DEBT SERVICE FUND
415 CAPITAL IMPROVEMENTS FUND
350 SPECIAL SERVICE AREA #6
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
330 HOWARD-RIDGE TIF FUND
335 WEST EVANSTON TIF FUND
305 SPECIAL SERVICE AREA (SSA) #5
310 HOWARD-HARTREY TIF
186 LIBRARY DEBT SERVICE FUND
300 WASHINGTON NATIONAL TIF
250 AFFORDABLE HOUSING FUND
235 NEIGHBORHOOD IMPROVEMENT
240 HOME FUND
225 ECONOMIC DEVELOPMENT FUND
215 CDBG FUND
220 CDBG LOAN
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
195 NEIGHBORHOOD STABILIZATION
200 MOTOR FUEL TAX FUND
185 LIBRARY FUND
175 GENERAL ASSISTANCE FUND
180 GOOD NEIGHBOR FUND
100 GENERAL FUND
176 HEALTH AND HUMAN SERVICES
Fund Fund Description
Memorandum
Attachment 1: December 2016 Monthly Financial Report
Included above are the ending balances as of December 31, 2016 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.
As of December 31, 2016, the General Fund is reporting a net surplus of $1,204.238.
This does not include a variety of year-end adjustments which are anticipated to bring
the General Fund fund balance to approximately $12,000,000. The original projected
surplus was just over $1.6 million. Year-end expenses were under the estimate but
revenues did not meet estimates, mainly due to income and sales tax being below
anticipated amounts. The attached supplemental charts show the General Fund
Revenues at 100.2% of budget and expenses lower at 99.4%. General Fund revenues
include the $2.9 million permit from Northwestern as well as pension property taxes.
Through December 31, 2016, the SSA #4 Fund is showing a negative fund balance of
$192,276 and a $0 cash balance. This is due to the timing of payments to the
Downtown Evanston group.
Through December 31, 2016, the Economic Development Fund is showing a fund
balance of $2,887,918 and a cash balance of $2,614,100. This fund will be eliminated
in 2017 with the fund and cash balance transferred to Business Unit 5300 in the
General Fund.
Special Service Area #5 received 2016 property taxes in error for the first installment.
This is due to the first property tax installment always being 55% of the previous year’s
tax amount. This money was refunded to the County in early December and is reflected
in this financial report.
Through December 31, 2016, the Capital Fund is showing expenses of $11,558,743.
As the year-end close process continues, expenses are anticipated to increase to reflect
payables due to IDOT and other organizations which will be paid in 2017.
Through December 31, 2016, the enterprise funds (Parking, Water, and Sewer) have
balances above average.
Through December 31, 2016, the Solid Waste Fund has a negative fund balance of
$926,498 and a cash balance of $0.
Through December 31, 2016, the Insurance Fund is showing a negative fund balance of
$639,105 with a cash balance of $1,749,678.
If there are any questions on the attached report, please contact me by phone at (847)
859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can
be found at: http://www.cityofevanston.org/city-budget/financial-reports/.
51 of 432
Attachment 1: December 2016 Monthly Financial Report
Attachment 1: December 2016 Monthly Financial Report
2016 December YTD % of
Budget Actual Actual % 2015 Actual
Fund 100 - GENERAL FUND
27,417,407 156,456 27,302,687 99.6% 25,915,970
45,986,550 5,377,364 44,946,338 97.7% 44,978,985
5,329,777 1,757,030 5,268,550 98.9% 5,324,137
9,276,550 322,687 11,012,646 118.7% 6,704,846
125,700 22,316 70,395 56.0% 155,619
4,609,825 468,198 3,602,413 78.1% 3,548,230
640,000 53,334 646,695 101.0% 640,000
5,374,751 357,842 5,724,759 106.5% 5,406,379
2,433,216 285,433 2,687,947 110.5% 2,239,528
8,842,365 1,399,916 8,709,861 98.5% 7,774,256
765,727 150,549 769,027 100.4% 670,245
1,286,843 569,350 1,583,332 123.0% 956,932
50,000 3,751 30,285 60.6% 6,572
112,138,711 10,924,226 112,354,936 100.2% 104,321,698
424,958 48,548 424,171 99.8% 419,962
263,203 37,150 293,975 111.7% 283,764
6,989,746 1,549,141 6,871,876 98.3% 1,814,469
1,130,000 130,863 1,046,582 92.6% 1,051,325
9,634,173 1,304,624 9,161,332 95.1% 9,763,951
2,782,897 328,358 2,505,921 90.0% 2,425,618
37,696,278 3,677,663 37,802,175 100.3% 37,239,961
22,601,742 2,087,186 23,233,603 102.8% 21,331,507
3,610,779 347,261 3,093,815 85.7% 3,212,848
11,845,590 1,477,036 11,961,040 101.0% 11,180,116
14,861,248 2,114,581 14,756,209 99.3% 18,148,755
111,840,614 13,102,411 111,150,697 99.4% 106,872,275
112,138,711 10,924,226 112,354,936 100%104,321,698
111,840,614 13,102,690 111,150,697 99%106,872,275
298,097 (2,178,464) 1,204,239 286%(2,550,577)
Classification
Fines and Forfeitures
Parking Charges for Services
Parks and Recreation Charges for Services
Other Charges for Services
Property Taxes
Other Taxes
License
Permit
Fee
City Council
City Clerk
City Manager's Office
Law
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
EXPENSE TOTALS
Administrative Services
Community Development
Police
Fire
Health & Human Services
December Financial Report
Through 12/31/16
City of Evanston
REVENUE TOTAL
EXPENSE TOTAL
Fund 100 - GENERAL FUND Net Gain (Loss)
Parks, Recreation & Community Service
Public Works Agency
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS
Attachment 1: December 2016 Monthly Financial Report
2016 December YTD
Budget Actual Actual % 2015 Actual
Fund 505 - PARKING SYSTEM FUND
0 150 3,350 +++150
6,379,675 623,131 6,319,024 99.0% 6,010,558
65,000 0 168,500 259.2%0
3,711,770 309,314 3,711,768 100.0% 2,925,296
12,125 0 0 0.0%0
119,216 42,855 195,895 164.3% 153,545
35,070 9,867 38,159 108.8% 18,260
10,322,856 985,317 10,436,695 101.1% 9,107,809
23,000 4,197 26,465 115.1% 29,187
1,160,688 159,578 1,206,649 104.0% 966,953
113,349 14,064 105,009 92.6% (33,034)
3,022,411 243,278 2,841,933 94.0% 2,616,554
278,864 21,308 237,610 85.2% 243,068
3,474,000 716,134 2,867,258 82.5% 128,726
507,900 47,105 504,784 99.4% 478,187
2,873,395 0 0 0.0% 2,846,227
11,000 1,119 5,910 53.7% 6,951
3,917,652 (3,516,846) 390,235 10.0% 503,423
252,000 0 238,064 94.5% 23,687
1,303,783 108,649 1,303,783 100.0% 923,092
16,938,042 (2,201,414) 9,727,700 57.4% 8,733,020
10,322,856 985,317 10,436,695 101%9,107,809
16,938,042 (2,201,414) 9,727,700 57%8,733,020
(6,615,186) 3,186,732 708,995 (11%) 374,789
EXPENSE TOTALS
Fund 505 - PARKING SYSTEM FUND Net Gain
December Financial Report
Through 12/31/16
City of Evanston
REVENUE TOTAL
EXPENSE TOTAL
Debt Service
Miscellaneous
Interfund Transfers
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS
Supplies
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Contingencies
Employee Pay
Benefits
Pensions
Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
Permit
Parking Charges for Services
Parks and Recreation Charges for Services
Classification
Attachment 1: December 2016 Monthly Financial Report
2016 December YTD % of
Budget Actual Actual % 2015 Actual
Fund 510 - WATER FUND
70,000 4,007 90,592 129.4% 105,483
15,133,000 (1,478,214) 15,783,608 104.3% 15,141,770
39,000 17,669 65,296 167.4% 40,911
126,000 0 134,470 106.7% 125,545
0 0 8,125,064 2,354,582
22,348,400 (3,960,241) 258,384 1.2% 350,065
1,600 1,773 16,536 1033.5% 3,448
37,718,000 (5,415,006) 24,473,950 64.9% 18,121,804
210,465 30,678 193,328 91.9% 157,679
3,888,603 510,506 3,908,362 100.5% 3,884,943
360,355 53,312 393,195 109.1% (114,870)
4,763,760 440,896 2,099,412 44.1% 1,250,874
1,392,190 134,124 943,833 67.8% 1,048,119
24,776,106 179,523 7,484,138 30.2%105
1,114,195 105,096 1,110,835 99.7% 1,131,508
0 0 0 2,096,633
1,000 342 1,000 100.0%933
1,053,288 (867,266) 633,708 60.2% 432,628
62,980 0 10,543 16.7% (286,678)
3,502,313 (30,320) 11,627,377 332.0% 3,692,565
41,125,255 556,890 28,405,731 69.1% 13,294,439
37,718,000 (5,415,006) 24,473,950 43%18,121,804
41,125,255 556,890 28,405,731 151%13,294,439
(3,407,255) (5,971,896) (3,931,781) (18%) 4,827,365
EXPENSE TOTALS
Fund 510 - WATER FUND Net Gain (Loss)
December Financial Report
Through 12/31/16
City of Evanston
REVENUE TOTAL
EXPENSE TOTAL
Debt Service
Miscellaneous
Interfund Transfers
Fund 510 - WATER FUND Totals
REVENUE TOTALS
Supplies
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Contingencies
Employee Pay
Benefits
Pensions
Services
Other Charges for Services
Interfund Transfers
Other Revenue
Interest Income
Fee
Water Charges for Services
Sewer Charges for Services
Classification
Attachment 1: December 2016 Monthly Financial Report
2016 December YTD % of
Budget Actual Actual % 2015 Actual
Fund 515 - SEWER FUND
12,869,000 822,795 13,027,160 101.23% 12,491,290
19,650 0 21,600 109.92% 19,650
984,165 (551,776) 3,087 0.31% 2,962
1,000 392 4,450 444.95% 2,706
13,873,815 271,411 13,056,297 94.11% 12,516,607
57,040 3,740 37,763 66.20% 60,837
881,327 111,678 862,355 97.85% 858,361
86,092 11,363 85,100 98.85% (27,099)
903,500 276,455 530,350 58.70% 90,109
92,300 7,256 40,736 44.13% 18,817
3,048,314 33,400 756,544 24.82% 13,609
414,439 38,670 414,270 99.96% 412,461
0 0 0 3,443,723
9,222,913 (7,084,604) 1,336,366 14.49% 1,550,407
1,500 0 5,000 333.33% 3,306
773,876 64,489 773,873 100.00% 735,235
15,481,301 (6,537,552) 4,842,356 31.28% 7,159,766
13,873,815 271,411 13,056,297 94%12,516,607
15,481,301 (6,537,552) 4,842,356 31%7,159,766
(1,607,486) 6,808,964 8,213,941 (511%) 5,356,842
EXPENSE TOTALS
Fund 515 - SEWER FUND Net Gain (Loss)
December Financial Report
Through 12/31/16
City of Evanston
REVENUE TOTAL
EXPENSE TOTAL
Debt Service
Miscellaneous
Interfund Transfers
Fund 515 - SEWER FUND Totals
REVENUE TOTALS
Services
Supplies
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Employee Pay
Benefits
Pensions
Sewer Charges for Services
Other Charges for Services
Other Revenue
Interest Income
Classification
Attachment 1: December 2016 Monthly Financial Report
2016 December YTD % of
Budget Actual Actual % 2015 Actual
Fund 520 - SOLID WASTE FUND
275,000 0 125,404 45.60% 213,490
3,632,394 322,100 3,586,453 98.74% 3,561,584
1,055,967 87,997 1,055,967 100.00% 1,055,967
238,000 1,367 274,808 115.47% 228,469
5,201,361 411,464 5,042,632 96.95% 5,059,510
25,000 7,562 43,025 172.10% 41,358
649,690 74,383 620,226 95.46% 574,692
63,718 7,939 63,448 99.58% (15,981)
3,679,126 171,501 3,300,142 89.70% 3,644,097
53,050 2,878 55,106 103.88% 73,788
25,750 720 6,034 23.43% 24,738
129,690 13,531 138,618 106.88% 249,232
0 (17,982) 2,251 68,419
15,000 0 12,232 81.55%0
499,493 41,624 499,493 100.00% 490,106
5,140,517 302,157 4,740,573 92.22% 5,150,448
5,201,361 411,464 5,042,632 97%5,059,510
5,140,517 302,157 4,740,573 92%5,150,448
60,844 109,307 302,059 496%(90,938)
REVENUE TOTALS
EXPENSE TOTALS
Fund 520 - SOLID WASTE FUND Net Gain (Loss)
Insurance and Other Chargebacks
Debt Service
Miscellaneous
Interfund Transfers
Fund 520 - SOLID WASTE FUND Totals
EXPENSE TOTAL
Services
Supplies
Capital Outlay
Interfund Transfers
Other Revenue
Employee Pay
Benefits
Pensions
REVENUE TOTAL
License
Other Charges for Services
Classification
December Financial Report
Through 12/31/16
City of Evanston
December YTD 2015
2016 2016 Actual
156,456 27,302,687 25,915,970
5,377,364 44,946,338 44,978,985
2,740,631 16,351,591 12,184,602
468,198 3,602,413 3,548,230
696,608 9,059,400 8,285,907
1,399,916 8,709,861 7,774,256
150,549 769,027 670,245
569,350 1,583,332 956,932
- - -
- - -
- - -
3,751 30,285 6,572
- - -
- - -
11,562,823 112,354,935 104,321,698
8,407,474 61,447,382 60,215,578
1,844,136 11,793,109 11,506,401
69,708 194,933 155,975
1,648,984 28,062,250 10,846,854
92,645 865,156 952,678
- - -
2,041 51,836 30,529
- - -
220,293 1,694,150 17,171,181
817,409 7,041,881 5,993,080
13,102,690 111,150,697 106,872,275
11,562,823 112,354,935 104,321,698
13,102,690 111,150,697 106,872,275
(1,539,867) 1,204,238 (2,550,577)
Starting Fund Balance 10,704,836 10,704,836
Net Change (567,485) 1,204,238
Ending Fund Balance 10,137,351 11,909,074
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 27,417,407
Other Taxes 45,986,550
Licenses, Permits and Fees 14,732,027
Fines and Forfeitures 4,609,825
Charges for Services 8,447,967
Interfund Transfers 8,842,365
Intergovernmental Revenue 765,727
Other Revenue 1,286,843
Workers Compensation and Liability
Insurance
Library Revenue
Interest Income 50,000
Special Assessment
Reappropriation of Surplus
REVENUE TOTALS 112,138,711
EXPENSE
Salary and Benefits 62,388,836
Services and Supplies 11,834,924
Capital Outlay 200,600
Insurance and Other Chargebacks 28,210,185
Community Sponsored Organizations 925,029
Depreciation Expense
Contingencies 213,505
Debt Service
Miscellaneous 1,679,285
Interfund Transfers 7,253,832
EXPENSE TOTALS 112,706,196
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 112,138,711
EXPENSE TOTALS 112,706,196
Fund 100 - GENERAL FUND Totals (567,485)
Run by Ashley King on 02/20/2017 03:26:56 PM Page 1 of 39
December YTD 2015
2016 2016 Actual
4,910 827,615 1,313,420
- - -
- - -
- - -
- - -
- - -
- 167 3,208
- 49,423 19,534
- - -
- - -
- - -
105 802 62
- - -
- - -
5,015 878,006 1,336,224
37,096 246,916 166,822
46,392 529,013 592,645
- - -
4,400 26,205 18,609
- - -
- - -
- - -
- - -
- 4,466 4,625
- - -
87,888 806,600 782,701
5,015 878,006 1,336,224
87,888 806,600 782,701
(82,873) 71,406 553,522
Starting Fund Balance 513,239 513,239
Net Change 38,167 71,406
Ending Fund Balance 551,406 584,645
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 1,000,000
Other Taxes
Licenses, Permits and Fees
Fines and Forfeitures
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue 25,000
Workers Compensation and Liability
Insurance
Library Revenue
Interest Income 1,000
Special Assessment
Reappropriation of Surplus
REVENUE TOTALS 1,026,000
EXPENSE
Salary and Benefits 200,704
Services and Supplies 758,900
Capital Outlay
Insurance and Other Chargebacks 21,229
Community Sponsored Organizations
Depreciation Expense
Contingencies
Debt Service
Miscellaneous 7,000
Interfund Transfers
EXPENSE TOTALS 987,833
Fund 175 - GENERAL ASSISTANCE
REVENUE TOTALS 1,026,000
EXPENSE TOTALS 987,833
Fund 175 - GENERAL ASSISTANCE 38,167
Run by Ashley King on 02/20/2017 03:26:56 PM Page 2 of 39
December YTD 2015
2016 2016 Actual
- - -
73,733 884,794 884,794
- - -
- - -
73,733 884,794 884,794
61 61 -
- - -
191,952 849,333 849,388
- - -
192,012 849,394 849,388
73,733 884,794 884,794
192,012 849,394 849,388
(118,280) 35,400 35,406
Starting Fund Balance - -
Net Change 25,641 35,400
Ending Fund Balance 25,641 35,400
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Charges for Services
Interfund Transfers 884,794
Intergovernmental Revenue
Other Revenue
REVENUE TOTALS 884,794
EXPENSE
Services and Supplies
884,794
Capital Outlay
Community Sponsored Organizations 859,153
Miscellaneous
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN 25,641
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 3 of 39
December YTD 2015
2016 2016 Actual
- 1,000,000 -
- 1,000,000 -
83,333 1,000,000 -
83,333 1,000,000 -
- 1,000,000 -
83,333 1,000,000 -
(83,333) (0) -
Starting Fund Balance - -
Net Change - (0)
Ending Fund Balance - (0)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
REVENUE TOTALS 1,000,000
EXPENSE
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND
Run by Ashley King on 02/20/2017 03:26:56 PM Page 4 of 39
December YTD 2015
2016 2016 Actual
34,403 6,136,248 5,916,852
- - 46,059
24,778 154,329 129,808
- 235,800 171,000
7,500 75,418 181,283
8,223 66,453 286
190,272 335,465 315,924
314 4,717 2,683
265,489 7,008,429 6,763,897
561,231 4,246,657 4,062,199
172,288 1,658,209 1,425,484
(22,077) 16,395 299,628
42,826 406,163 810,678
- - -
- - -
- - -
20,833 250,000 250,000
7,523 90,272 81,468
782,624 6,667,696 6,929,456
265,489 7,008,429 6,763,897
782,624 6,667,696 6,929,456
(517,135) 340,733 (165,560)
Starting Fund Balance 420,085 420,085
Net Change 20,015 340,733
Ending Fund Balance 440,100 760,818
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,104,180.00
Other Taxes 50,200.00
Fines and Forfeitures 160,000.00
Interfund Transfers 185,800.00
Intergovernmental Revenue 94,177.00
Other Revenue 87,500.00
Library Revenue 333,300.00
Interest Income 2,000.00
REVENUE TOTALS $7,017,157.00
EXPENSE
Salary and Benefits 4,289,180.00
Services and Supplies 1,872,573.00
Capital Outlay 32,800.00
Insurance and Other Chargebacks 462,317.00
Depreciation Expense .00
Contingencies .00
7,017,157.00
Debt Service .00
Miscellaneous 250,000.00
Interfund Transfers 90,272.00
EXPENSE TOTALS 6,997,142.00
Fund 185 - LIBRARY FUND Totals $20,015.00
EXPENSE TOTALS $6,997,142.00
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 5 of 39
December YTD 2015
2016 2016 Actual
- 364,827 601,811
- 26,150 -
- 1 -
- 390,978 601,811
578 12,349 -
- 41,447 -
- 385,696 562,740
- - -
578 439,491 562,740
- 390,978 601,811
578 439,491 562,740
(578) (48,513) 39,072
Starting Fund Balance 36,664 36,664
Net Change - (48,513)
Ending Fund Balance 36,664 (11,849)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 393,409
Other Revenue
Interest Income
REVENUE TOTALS 393,409
EXPENSE
Services and Supplies
Capital Outlay
Debt Service 393,409
Miscellaneous
EXPENSE TOTALS 393,409
Fund 186 - LIBRARY DEBT SERVICE
Fund 186 - LIBRARY DEBT SERVICE
REVENUE TOTALS 393,409
EXPENSE TOTALS 393,409
Run by Ashley King on 02/20/2017 03:26:56 PM Page 6 of 39
December YTD 2015
2016 2016 Actual
- - -
1,515 62,935 130,126
- - -
21 222 -
1,536 63,157 130,126
2,969 22,569 54,159
- 6,060 4,611
1,526 39,316 68,352
437 4,173 6,847
- - -
- 1,705 179
6,637 17,623 (4,022)
11,569 91,447 130,126
1,536 63,157 130,126
11,569 91,447 130,126
(10,033) (28,289) -
Starting Fund Balance - -
Net Change (303) (28,289)
Ending Fund Balance (303) (28,289)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Licenses, Permits and Fees
Intergovernmental Revenue 198,651
Other Revenue
Interest Income
REVENUE TOTALS 198,651
EXPENSE
Salary and Benefits 28,590
Services and Supplies 5,100
Capital Outlay 35,000
Insurance and Other Chargebacks 5,058
198,651
Debt Service
Miscellaneous 120,862
Interfund Transfers 4,344
EXPENSE TOTALS 198,954
Fund 195 - NEIGHBORHOOD (303)
EXPENSE TOTALS 198,954
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 7 of 39
December YTD 2015
2016 2016 Actual
177,087 1,896,461 2,465,781
- - -
670 6,613 819
- - -
177,757 1,903,074 2,466,600
- - -
(25,744) 130,789 1,583,238
- - -
- - -
- - -
182,417 2,189,000 833,000
156,672 2,319,789 2,416,238
177,757 1,903,074 2,466,600
156,672 2,319,789 2,416,238
21,085 (416,715) 50,362
Starting Fund Balance 1,830,393 1,830,393
Net Change (478,000) (416,715)
Ending Fund Balance 1,352,393 1,413,678
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,710,000
Other Revenue
Interest Income 1,000
Reappropriation of Surplus
REVENUE TOTALS 1,711,000
EXPENSE
Services and Supplies
Capital Outlay
Contingencies
Debt Service
Miscellaneous
Interfund Transfers 2,189,000
EXPENSE TOTALS 2,189,000
Fund 200 - MOTOR FUEL TAX FUND (478,000)
Fund 200 - MOTOR FUEL TAX FUND
REVENUE TOTALS 1,711,000
EXPENSE TOTALS 2,189,000
Run by Ashley King on 02/20/2017 03:26:56 PM Page 8 of 39
December YTD 2015
2016 2016 Actual
78,987 887,574 977,071
- - -
- - 100
255 2,472 189
79,242 890,046 977,361
55,411 509,028 505,437
11,065 263,105 347,694
109,541 423,493 239,421
7,422 91,628 96,132
- - -
- - 2,046
- - -
- - 1,500
11,851 142,207 141,767
195,290 1,429,460 1,333,996
79,242 890,046 977,361
195,290 1,429,460 1,333,996
(116,048) (539,414) (356,635)
Starting Fund Balance 551,718 551,718
Net Change (497,643) (539,414)
Ending Fund Balance 54,075 12,304
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,018,000
Intergovernmental Revenue
Other Revenue
Interest Income 1,000
REVENUE TOTALS 1,019,000
EXPENSE
Salary and Benefits 503,275
Services and Supplies 377,600
Capital Outlay 393,615
Insurance and Other Chargebacks 94,946
Community Sponsored Organizations
Contingencies 5,000
Debt Service
Miscellaneous
Interfund Transfers 142,207
EXPENSE TOTALS 1,516,643
Fund 205 - EMERGENCY (497,643)
Fund 205 - EMERGENCY
REVENUE TOTALS 1,019,000
EXPENSE TOTALS 1,516,643
Run by Ashley King on 02/20/2017 03:26:56 PM Page 9 of 39
December YTD 2015
2016 2016 Actual
- 321,266 322,055
- 2 3
- 321,268 322,058
80,750 323,000 323,000
- - -
- - -
80,750 323,000 323,000
- 321,268 322,058
80,750 323,000 323,000
(80,750) (1,732) (942)
Starting Fund Balance (190,544) (190,544)
Net Change - (1,732)
Ending Fund Balance (190,544) (192,276)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 320,000
Interest Income
REVENUE TOTALS 320,000
320,000
EXPENSE
Services and Supplies 320,000
Debt Service
Miscellaneous
EXPENSE TOTALS 320,000
Fund 210 - SPECIAL SERVICE AREA
EXPENSE TOTALS 320,000
Fund 210 - SPECIAL SERVICE AREA
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 10 of 39
December YTD 2015
2016 2016 Actual
- - -
- - -
1,098,210 2,016,478 1,502,924
- 10,197 3,318
- - -
1,098,210 2,026,675 1,506,242
52,359 414,848 318,743
1,286 6,219 28,988
423,584 608,829 276,834
23,947 87,411 58,583
159,092 360,315 235,459
- - -
- - -
102,136 209,055 72,442
148,902 335,774 455,310
911,305 2,022,452 1,446,359
1,098,210 2,026,675 1,506,242
911,305 2,022,452 1,446,359
186,905 4,224 59,883
Starting Fund Balance 59,882 59,882
Net Change 375 4,224
Ending Fund Balance 60,257 64,106
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 215 - CDBG FUND
REVENUE
Charges for Services
Interfund Transfers
Intergovernmental Revenue 2,595,000
Other Revenue
Interest Income
REVENUE TOTALS 2,595,000
EXPENSE
Salary and Benefits 385,285
Services and Supplies 3,800
Capital Outlay
Insurance and Other Chargebacks 87,795
Community Sponsored Organizations
Contingencies
2,595,000
Debt Service
Miscellaneous 1,274,280
Interfund Transfers 843,465
EXPENSE TOTALS 2,594,625
Fund 215 - CDBG FUND Totals 375
EXPENSE TOTALS 2,594,625
Fund 215 - CDBG FUND Totals
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 11 of 39
December YTD 2015
2016 2016 Actual
- - -
34,317 213,162 397,708
25 4,656 375
34,342 217,817 398,083
- - -
79,254 160,641 280,461
- 57,880 1,919
- - -
79,254 218,521 282,380
34,342 217,817 398,083
79,254 218,521 282,380
(44,912) (704) 115,703
Starting Fund Balance 158,365 158,365
Net Change - (704)
Ending Fund Balance 158,365 157,661
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 220 - CDBG LOAN
REVENUE
Intergovernmental Revenue
Other Revenue 350,000
Interest Income
REVENUE TOTALS 350,000
EXPENSE
Salary and Benefits
Services and Supplies 340,000
Miscellaneous 10,000
Interfund Transfers
EXPENSE TOTALS 350,000
Fund 220 - CDBG LOAN Totals
Fund 220 - CDBG LOAN Totals
REVENUE TOTALS 350,000
EXPENSE TOTALS 350,000
Run by Ashley King on 02/20/2017 03:26:56 PM Page 12 of 39
December YTD 2015
2016 2016 Actual
55,964 2,266,987 2,116,843
3,958 47,500 -
- - -
833 241,224 49,000
155 8,761 128
60,910 2,564,472 2,165,971
70,974 539,508 537,286
57,035 414,974 302,867
25,659 241,180 194,941
7,131 73,245 80,941
- - -
- - -
- - -
346 98,312 1,419,643
72,110 865,318 614,782
233,254 2,232,536 3,150,460
60,910 2,564,472 2,165,971
233,254 2,232,536 3,150,460
(172,344) 331,936 (984,489)
Starting Fund Balance 2,555,982 2,555,982
Net Change (286,099) 331,936
Ending Fund Balance 2,269,883 2,887,918
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 225 - ECONOMIC DEVELOPMENT FUND
REVENUE
Other Taxes 2,165,000
Interfund Transfers 47,500
Intergovernmental Revenue
Other Revenue 50,000
Interest Income 100
REVENUE TOTALS 2,262,600
EXPENSE
Salary and Benefits 646,806
Services and Supplies 912,200
Capital Outlay 253,500
Insurance and Other Chargebacks 104,871
Community Sponsored Organizations
Contingencies
2,262,600
Debt Service
Miscellaneous 16,000
Interfund Transfers 615,322
EXPENSE TOTALS 2,548,699
Fund 225 - ECONOMIC (286,099)
EXPENSE TOTALS 2,548,699
Fund 225 - ECONOMIC
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 13 of 39
December YTD 2015
2016 2016 Actual
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Starting Fund Balance 169,915 169,915
Net Change (80,000) -
Ending Fund Balance 89,915 169,915
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Other Taxes 20,000
Interfund Transfers
Interest Income
REVENUE TOTALS 20,000
EXPENSE
Services and Supplies
Capital Outlay
20,000
Debt Service
Miscellaneous 100,000
Interfund Transfers
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (80,000)
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 14 of 39
December YTD 2015
2016 2016 Actual
26,114 246,511 465,961
2,282 27,259 6,402
0 14 19
28,397 273,784 472,382
4,191 31,964 12,388
10,025 248,410 282,753
- - -
462 3,998 1,368
- - -
- - -
- 100 193,931
(8,295) (8,295) 26,990
6,384 276,177 517,430
28,397 273,784 472,382
6,384 276,177 517,430
22,013 (2,393) (45,048)
Starting Fund Balance 4,770 4,770
Net Change - (2,393)
Ending Fund Balance 4,770 2,377
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 393,868
Other Revenue 8,300
Interest Income
REVENUE TOTALS 402,168
EXPENSE
Salary and Benefits 48,348
Services and Supplies 352,500
Capital Outlay
Insurance and Other Chargebacks 820
Community Sponsored Organizations
402,168
Debt Service
Miscellaneous 500
Interfund Transfers
EXPENSE TOTALS 402,168
Fund 240 - HOME FUND Totals
EXPENSE TOTALS 402,168
Fund 240 - HOME FUND Totals
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 15 of 39
December YTD 2015
2016 2016 Actual
20,113 106,780 100,000
- - -
- - -
315,718 525,078 125,150
143 1,392 111
335,975 633,250 225,261
6,366 34,138 -
- 201 98
- - -
393 3,178 -
- 735 -
- - -
57,137 187,956 214,752
- - -
63,897 226,207 214,851
335,975 633,250 225,261
63,897 226,207 214,851
272,078 407,043 10,411
Starting Fund Balance 993,880 993,880
Net Change (313,719) 407,043
Ending Fund Balance 680,161 1,400,923
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 30,000
Interfund Transfers
Intergovernmental Revenue
Other Revenue 130,400
Interest Income 228
REVENUE TOTALS 160,628
EXPENSE
Salary and Benefits 48,347
Services and Supplies 350,000
Capital Outlay
Insurance and Other Chargebacks
Community Sponsored Organizations
Debt Service
Miscellaneous 76,000
Interfund Transfers
EXPENSE TOTALS 474,347
Fund 250 - AFFORDABLE HOUSING (313,719)
Fund 250 - AFFORDABLE HOUSING
REVENUE TOTALS 160,628
EXPENSE TOTALS 474,347
Run by Ashley King on 02/20/2017 03:26:56 PM Page 16 of 39
December YTD 2015
2016 2016 Actual
9,721 4,729,649 4,921,484
- - -
- - -
- - -
1,589 14,012 3,530
11,311 4,743,661 4,925,014
- - -
263 2,750 1,408
- 4,473 198,823
- - 574,976
24,669 98,676 110,310
732,228 4,455,515 3,265,296
757,159 4,561,415 4,150,811
11,311 4,743,661 4,925,014
757,159 4,561,415 4,150,811
(745,848) 182,246 774,203
Starting Fund Balance 6,442,430 6,442,430
Net Change (2,640,683) 182,246
Ending Fund Balance 3,801,747 6,624,676
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,145,000
Other Taxes
Interfund Transfers
Other Revenue
Interest Income 2,000
REVENUE TOTALS 5,147,000
EXPENSE
Salary and Benefits
Services and Supplies 1,000,000
Capital Outlay
5,147,000
Debt Service
Miscellaneous 500,000
Interfund Transfers 6,287,683
EXPENSE TOTALS 7,787,683
Fund 300 - WASHINGTON (2,640,683)
EXPENSE TOTALS 7,787,683
Fund 300 - WASHINGTON
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 17 of 39
December YTD 2015
2016 2016 Actual
(288,005) (180) 422,527
- - -
- - -
- 35 4
(288,005) (145) 422,531
5,652 5,652 -
- 428,186 297,150
- - -
91,445 91,445 -
97,098 525,284 297,150
(288,005) (145) 422,531
97,098 525,284 297,150
(385,103) (525,429) 125,381
Starting Fund Balance 525,429 525,429
Net Change (467,971) (525,429)
Ending Fund Balance 57,458 (0)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 305 - SPECIAL SERVICE AREA (SSA) #5
REVENUE
Property Taxes
Interfund Transfers
Other Revenue
Interest Income 300
REVENUE TOTALS 300
EXPENSE
Services and Supplies 51,399
300
Debt Service 416,872
Miscellaneous
Interfund Transfers
EXPENSE TOTALS 468,271
Fund 305 - SPECIAL SERVICE AREA (467,971)
EXPENSE TOTALS 468,271
Fund 305 - SPECIAL SERVICE AREA
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 18 of 39
December YTD 2015
2016 2016 Actual
- 1,233,675 1,248,231
- - -
262 2,319 1,985
262 1,235,994 1,250,216
- 2,488 1,158
(1,022,540) - 11,402
- - -
- - -
- 129,192 2,162,381
1,687,316 1,912,366 148,010
664,776 2,044,045 2,322,950
262 1,235,994 1,250,216
664,776 2,044,045 2,322,950
(664,514) (808,051) (1,072,734)
Starting Fund Balance 1,281,115 1,281,115
Net Change (650,450) (808,051)
Ending Fund Balance 630,665 473,064
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 310 - HOWARD-HARTREY TIF
REVENUE
Property Taxes 1,300,000
Other Revenue
Interest Income 2,000
REVENUE TOTALS 1,302,000
EXPENSE
Services and Supplies
Capital Outlay
Community Sponsored Organizations
Debt Service
Miscellaneous 200,000
Interfund Transfers 1,752,450
EXPENSE TOTALS 1,952,450
Fund 310 - HOWARD-HARTREY TIF
REVENUE TOTALS 1,302,000
EXPENSE TOTALS 1,952,450
Fund 310 - HOWARD-HARTREY TIF (650,450)
Run by Ashley King on 02/20/2017 03:26:56 PM Page 19 of 39
December YTD 2015
2016 2016 Actual
- - -
- - -
- - -
- - -
- - -
- - -
- - 893,387
- - -
- - 893,387
- - -
- - 893,387
- - (893,387)
Starting Fund Balance - -
Net Change - -
Ending Fund Balance - -
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 315 - SOUTHWEST TIF FUND
REVENUE
Property Taxes
Interest Income
REVENUE TOTALS
EXPENSE
Services and Supplies
Capital Outlay
Debt Service
Miscellaneous
Interfund Transfers
EXPENSE TOTALS
Fund 315 - SOUTHWEST TIF FUND
Fund 315 - SOUTHWEST TIF FUND
REVENUE TOTALS
EXPENSE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 20 of 39
December YTD 2015
2016 2016 Actual
110,795 10,438,928 11,156,231
517,966 3,079,968 1,642,654
- 8,211,196 12,278,473
722 24,264 7,668
629,483 21,754,356 25,085,026
49,550 149,553 171,576
- 23,454,863 24,358,022
- - 3,062
- - -
49,550 23,604,416 24,532,661
629,483 21,754,356 25,085,026
49,550 23,604,416 24,532,661
579,933 (1,850,061) 552,365
Starting Fund Balance 2,596,116 2,596,116
Net Change (2,751,668) (1,850,061)
Ending Fund Balance (155,552) 746,055
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 320 - DEBT SERVICE FUND
REVENUE
Property Taxes 10,879,993
Interfund Transfers 2,646,291
Other Revenue
Interest Income 1,500
REVENUE TOTALS 13,527,784
EXPENSE
Services and Supplies 315,770
13,527,784
Debt Service 15,963,682
Miscellaneous
Interfund Transfers
EXPENSE TOTALS 16,279,452
Fund 320 - DEBT SERVICE FUND (2,751,668)
EXPENSE TOTALS 16,279,452
Fund 320 - DEBT SERVICE FUND
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 21 of 39
December YTD 2015
2016 2016 Actual
- 533,105 540,576
6,045 282,307 64,176
1 374 1,815
6,046 815,787 606,568
105,679 679,056 587,839
- - (6,275)
- - -
- - -
62 693 585
- - 350
8,958 107,500 107,500
114,700 787,249 689,999
6,046 815,787 606,568
114,700 787,249 689,999
(108,654) 28,537 (83,431)
Starting Fund Balance (28,621) (28,621)
Net Change 24,000 28,537
Ending Fund Balance (4,621) (84)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 550,000
Other Revenue 1,120,000
Interest Income 100
REVENUE TOTALS 1,670,100
EXPENSE
Services and Supplies 538,000
Capital Outlay 1,000,000
Insurance and Other Chargebacks
Community Sponsored Organizations
Debt Service 600
Miscellaneous
Interfund Transfers 107,500
EXPENSE TOTALS 1,646,100
Fund 330 - HOWARD-RIDGE TIF 24,000
Fund 330 - HOWARD-RIDGE TIF
REVENUE TOTALS 1,670,100
EXPENSE TOTALS 1,646,100
Run by Ashley King on 02/20/2017 03:26:56 PM Page 22 of 39
December YTD 2015
2016 2016 Actual
- - -
1,028 11,311 -
172 1,684 257
1,201 12,995 257
- 507 1,158
- (1,028) (11,205)
- - -
- - -
766 8,519 7,185
- - 1,227
2,500 30,000 60,000
3,266 37,998 58,365
1,201 12,995 257
3,266 37,998 58,365
(2,066) (25,003) (58,107)
Starting Fund Balance 442,263 442,263
Net Change (39,850) (25,003)
Ending Fund Balance 402,413 417,260
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes
Other Revenue
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Contingencies
Debt Service 10,000
Miscellaneous
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF (39,850)
Fund 335 - WEST EVANSTON TIF
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Run by Ashley King on 02/20/2017 03:26:56 PM Page 23 of 39
December YTD 2015
2016 2016 Actual
- - -
- - 2,000,000
- - 2,000,000
- 971 -
- - 2,000,000
2,554 28,444 -
2,554 29,415 2,000,000
- - 2,000,000
2,554 29,415 2,000,000
(2,554) (29,415) -
Starting Fund Balance - -
Net Change - (29,415)
Ending Fund Balance - (29,415)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes
Other Revenue 50,000
REVENUE TOTALS 50,000
50,000
EXPENSE
Services and Supplies
Capital Outlay
Debt Service 40,000
EXPENSE TOTALS 40,000
Fund 340 - DEMPSTER-DODGE TIF 10,000
EXPENSE TOTALS 40,000
Fund 340 - DEMPSTER-DODGE TIF
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 24 of 39
December YTD 2015
2016 2016 Actual
- - -
1,000,000 1,580,000 900,000
1,000,000 1,580,000 900,000
- 437 -
580,000 1,740,000 580,000
1,890 16,556 7,930
581,890 1,756,993 587,930
1,000,000 1,580,000 900,000
581,890 1,756,993 587,930
418,110 (176,993) 312,070
Starting Fund Balance 312,070 312,070
Net Change 31,500 (176,993)
Ending Fund Balance 343,570 135,077
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 75,000
Other Revenue
REVENUE TOTALS 75,000
75,000
EXPENSE
Services and Supplies
Capital Outlay
Debt Service 43,500
EXPENSE TOTALS 43,500
Fund 345 - CHICAGO-MAIN TIF 31,500
EXPENSE TOTALS 43,500
Fund 345 - CHICAGO-MAIN TIF
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 25 of 39
December YTD 2015
2016 2016 Actual
509 223,296 -
0 2 -
510 223,298 -
145,003 145,003 -
- - -
145,003 145,003 -
510 223,298 -
145,003 145,003 -
(144,494) 78,294 -
Starting Fund Balance - -
Net Change 10,500 78,294
Ending Fund Balance 10,500 78,294
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 210,000
Interest Income 500
REVENUE TOTALS 210,500
EXPENSE
Services and Supplies 200,000
Interfund Transfers
EXPENSE TOTALS 200,000
Fund 350 - SPECIAL SERVICE AREA 10,500
Fund 350 - SPECIAL SERVICE AREA
REVENUE TOTALS 210,500
EXPENSE TOTALS 200,000
Run by Ashley King on 02/20/2017 03:26:56 PM Page 26 of 39
December YTD 2015
2016 2016 Actual
- - 87,391
633,830 4,864,054 -
- 919,386 270,268
- 9,884,305 7,945,481
3,050 7,774 3,815
636,881 15,675,519 8,306,954
- - -
356,628 1,272,534 643,510
721,479 9,796,209 9,794,396
- - -
- - 32,933
490,000 490,000 490,000
1,568,107 11,558,743 10,960,839
636,881 15,675,519 8,306,954
1,568,107 11,558,743 10,960,839
(931,226) 4,116,776 (2,653,885)
Starting Fund Balance 5,517,041 5,517,041
Net Change (2,209,000) 4,116,776
Ending Fund Balance 3,308,041 9,633,817
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Charges for Services
Interfund Transfers 6,471,000
Intergovernmental Revenue 4,841,615
Other Revenue 9,248,000
Interest Income
REVENUE TOTALS 20,560,615
EXPENSE
Salary and Benefits
Services and Supplies 2,256,962
Capital Outlay 20,022,653
20,560,615
Debt Service
Miscellaneous
Interfund Transfers 490,000
EXPENSE TOTALS 22,769,615
Fund 415 - CAPITAL (2,209,000)
EXPENSE TOTALS 22,769,615
Fund 415 - CAPITAL
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 27 of 39
December YTD 2015
2016 2016 Actual
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 513,349 243,113
- - -
- - -
- - -
4,126 29,660 24,832
20,079 142,874 125,218
- - -
24,205 685,884 393,163
- - -
409 8,751 1,879
- - 226,538
- - -
- - -
- - 534
30,058 360,698 -
30,467 369,449 228,951
24,205 685,884 393,163
30,467 369,449 228,951
(6,262) 316,435 164,213
Starting Fund Balance 2,682,781 2,682,781
Net Change 98,950 316,435
Ending Fund Balance 2,781,731 2,999,216
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Property Taxes
Other Taxes
Licenses, Permits and Fees
Fines and Forfeitures
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue 250,000
Workers Compensation and Liability
Insurance
Library Revenue
Interest Income 51,033
Special Assessment 180,167
Reappropriation of Surplus
REVENUE TOTALS 481,200
EXPENSE
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Debt Service
Miscellaneous
Interfund Transfers 382,250
EXPENSE TOTALS 382,250
Fund 420 - SPECIAL ASSESSMENT
REVENUE TOTALS 481,200
EXPENSE TOTALS 382,250
Fund 420 - SPECIAL ASSESSMENT 98,950
Run by Ashley King on 02/20/2017 03:26:56 PM Page 28 of 39
December YTD 2015
2016 2016 Actual
- - -
- - -
150 3,350 150
- - -
623,131 6,487,524 6,010,558
309,314 3,711,768 2,925,296
- - -
42,855 195,895 153,545
9,867 38,159 18,260
985,317 10,436,695 9,107,809
177,840 1,338,122 963,107
264,585 3,079,543 2,859,622
716,134 2,867,258 128,726
47,105 504,784 478,187
- - -
- - 2,846,227
1,119 5,910 6,951
(3,516,846) 390,235 503,423
- 238,064 23,687
108,649 1,303,783 923,092
(2,201,414) 9,727,700 8,733,020
985,317 10,436,695 9,107,809
(2,201,414) 9,727,700 8,733,020
3,186,732 708,995 374,789
Starting Fund Balance 10,777,874 10,777,874
Net Change (6,615,186) 708,995
Ending Fund Balance 4,162,688 11,486,869
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 505 - PARKING SYSTEM FUND
REVENUE
Property Taxes
Other Taxes
Licenses, Permits and Fees
Fines and Forfeitures
Charges for Services 6,444,675
Interfund Transfers 3,711,770
Intergovernmental Revenue 12,125
Other Revenue 119,216
Interest Income 35,070
REVENUE TOTALS 10,322,856
EXPENSE
Salary and Benefits 1,297,037
Services and Supplies 3,301,275
Capital Outlay 3,474,000
Insurance and Other Chargebacks 507,900
Community Sponsored Organizations
Depreciation Expense 2,873,395
Contingencies 11,000
Debt Service 3,917,652
Miscellaneous 252,000
Interfund Transfers 1,303,783
EXPENSE TOTALS 16,938,042
Fund 505 - PARKING SYSTEM FUND (6,615,186)
Fund 505 - PARKING SYSTEM FUND
REVENUE TOTALS 10,322,856
EXPENSE TOTALS 16,938,042
Run by Ashley King on 02/20/2017 03:26:56 PM Page 29 of 39
December YTD 2015
2016 2016 Actual
822,795 13,048,760 12,510,940
- - -
- 554,863 2,962
392 4,450 2,706
823,187 13,608,073 12,516,607
126,782 985,218 892,099
283,711 571,085 108,927
33,400 756,544 13,609
38,670 414,270 412,461
- - 3,443,723
- - -
- 8,420,970 1,550,407
- 5,000 3,306
64,489 773,873 735,235
64,489 11,926,960 7,159,766
823,187 13,608,073 12,516,607
64,489 11,926,960 7,159,766
758,698 1,681,113 5,356,842
Starting Fund Balance 4,012,808 4,012,808
Net Change (1,607,486) 1,681,113
Ending Fund Balance 2,405,322 5,693,921
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,888,650
Interfund Transfers
Other Revenue 984,165
Interest Income 1,000
REVENUE TOTALS 13,873,815
EXPENSE
Salary and Benefits 1,024,459
Services and Supplies 995,800
Capital Outlay 3,048,314
Insurance and Other Chargebacks 414,439
Depreciation Expense
Contingencies
Debt Service 9,222,913
Miscellaneous 1,500
Interfund Transfers 773,876
EXPENSE TOTALS 15,481,301
Fund 515 - SEWER FUND Totals (1,607,486)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 13,873,815
EXPENSE TOTALS 15,481,301
Run by Ashley King on 02/20/2017 03:26:56 PM Page 30 of 39
December YTD 2015
2016 2016 Actual
- - -
4,007 90,592 105,483
(1,782,726) 24,108,438 15,308,225
- - 2,354,582
- - -
(3,960,241) 258,384 350,065
1,820 16,536 3,448
(5,737,139) 24,473,950 18,121,804
594,496 4,494,885 3,927,752
575,020 3,043,246 2,298,993
179,523 7,484,138 105
105,096 1,110,835 1,131,508
0 - -
0 - 2,096,633
342 1,000 933
(867,266) 633,708 432,628
0 10,543 (286,678)
(30,320) 11,627,377 3,692,565
556,890 28,405,731 13,294,439
(5,737,139) 24,473,950 18,121,804
556,890 28,405,731 13,294,439
(6,294,029) (3,931,781) 4,827,365
Starting Fund Balance 9,223,203 9,223,203
Net Change (3,407,255) (3,931,781)
Ending Fund Balance 5,815,948 5,291,422
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 510 - WATER FUND
REVENUE
Other Taxes
Licenses, Permits and Fees 70,000
Charges for Services 15,298,000
Interfund Transfers
Intergovernmental Revenue
Other Revenue 22,348,400
Interest Income 1,600
REVENUE TOTALS 37,718,000
EXPENSE
Salary and Benefits 4,459,423
Services and Supplies 6,155,950
Capital Outlay 24,776,106
Insurance and Other Chargebacks 1,114,195
Community Sponsored Organizations
Depreciation Expense
Contingencies 1,000
37,718,000
Debt Service 1,053,288
Miscellaneous 62,980
Interfund Transfers 3,502,313
EXPENSE TOTALS 41,125,255
Fund 510 - WATER FUND Totals (3,407,255)
EXPENSE TOTALS 41,125,255
Fund 510 - WATER FUND Totals
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 31 of 39
December YTD 2015
2016 2016 Actual
- 125,404 213,490
322,100 3,586,453 3,561,584
87,997 1,055,967 1,055,967
- - -
1,367 274,808 228,469
- - -
411,464 5,042,632 5,059,510
89,884 726,698 600,068
174,379 3,355,248 3,717,885
720 6,034 24,738
13,531 138,618 249,232
- - -
- - -
- - -
(17,982) 2,251 68,419
- 12,232 -
41,624 499,493 490,106
302,157 4,740,573 5,150,448
411,464 5,042,632 5,059,510
302,157 4,740,573 5,150,448
109,307 302,059 (90,938)
Starting Fund Balance (1,228,557) (1,228,557)
Net Change 60,844 302,059
Ending Fund Balance (1,167,713) (926,498)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 520 - SOLID WASTE FUND
REVENUE
Licenses, Permits and Fees 275,000
Charges for Services 3,632,394
Interfund Transfers 1,055,967
Intergovernmental Revenue
Other Revenue 238,000
Interest Income
REVENUE TOTALS 5,201,361
EXPENSE
Salary and Benefits 738,408
Services and Supplies 3,732,176
Capital Outlay 25,750
Insurance and Other Chargebacks 129,690
Community Sponsored Organizations
Depreciation Expense
Contingencies
Debt Service
Miscellaneous 15,000
Interfund Transfers 499,493
EXPENSE TOTALS 5,140,517
Fund 520 - SOLID WASTE FUND 60,844
Fund 520 - SOLID WASTE FUND
REVENUE TOTALS 5,201,361
EXPENSE TOTALS 5,140,517
Run by Ashley King on 02/20/2017 03:26:56 PM Page 32 of 39
December YTD 2015
2016 2016 Actual
282,301 3,387,680 3,289,009
- - -
- - -
1,853 14,415 46,933
- - -
284,154 3,402,094 3,335,942
155,769 888,262 961,887
183,277 1,911,340 1,686,117
- - -
16,190 167,952 175,716
- - -
- - -
- - -
- - -
2,230 26,762 25,820
357,466 2,994,316 2,849,539
284,154 3,402,094 3,335,942
357,466 2,994,316 2,849,539
(73,312) 407,779 486,403
Starting Fund Balance 365,460 365,460
Net Change (244,277) 407,779
Ending Fund Balance 121,183 773,239
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 3,317,088
Interfund Transfers
Intergovernmental Revenue
Other Revenue 81,781
Interest Income 1,000
REVENUE TOTALS 3,399,869
EXPENSE
Salary and Benefits 1,052,741
Services and Supplies 2,380,057
Capital Outlay
Insurance and Other Chargebacks 184,136
Depreciation Expense
Contingencies 450
3,399,869
Debt Service
Miscellaneous
Interfund Transfers 26,762
EXPENSE TOTALS 3,644,146
Fund 600 - FLEET SERVICES FUND (244,277)
EXPENSE TOTALS 3,644,146
Fund 600 - FLEET SERVICES FUND
REVENUE TOTALS
Run by Ashley King on 02/20/2017 03:26:56 PM Page 33 of 39
December YTD 2015
2016 2016 Actual
121,255 1,455,172 1,451,422
- - -
11,107 45,869 34,286
132,362 1,501,041 1,485,708
2,600 57,041 53,400
626,582 1,437,968 -
- - 1,684,835
- - -
629,182 1,495,009 1,738,234
132,362 1,501,041 1,485,708
629,182 1,495,009 1,738,234
(496,820) 6,032 (252,527)
Starting Fund Balance 1,277,689 1,277,689
Net Change 146,216 6,032
Ending Fund Balance 1,423,905 1,283,721
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,451,421
Interfund Transfers
Other Revenue 210,217
REVENUE TOTALS 1,661,638
EXPENSE
Services and Supplies 60,000
Capital Outlay 1,455,422
Depreciation Expense
Miscellaneous
EXPENSE TOTALS 1,515,422
Fund 601 - EQUIPMENT 146,216
Fund 601 - EQUIPMENT
REVENUE TOTALS 1,661,638
EXPENSE TOTALS 1,515,422
Run by Ashley King on 02/20/2017 03:26:56 PM Page 34 of 39
December YTD 2015
2016 2016 Actual
404,248 441,246 162,411
68 820 306,051
1,061,309 9,994,682 10,413,499
9,217 89,822 1,034,405
611,455 6,546,063 5,753,308
20 218 136
2,086,318 17,072,851 17,669,810
63,873 448,109 460,086
503,420 2,538,464 1,305,086
- - -
992,784 14,347,295 14,318,413
- - -
- - -
- - -
- - -
- 4,330 -
772 9,262 8,936
1,560,850 17,347,460 16,092,521
2,086,318 17,072,851 17,669,810
1,560,850 17,347,460 16,092,521
525,468 (274,609) 1,577,289
Starting Fund Balance (364,496) (364,496)
Net Change 565,405 (274,609)
Ending Fund Balance 200,909 (639,105)
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 605 - INSURANCE FUND
REVENUE
Charges for Services 162,411
Interfund Transfers
Other Revenue 10,111,694
Workers Compensation and Liability 1,023,094
Insurance 6,459,839
Interest Income 1,000
REVENUE TOTALS 17,758,038
EXPENSE
Salary and Benefits 419,515
Services and Supplies 1,385,248
Capital Outlay
Insurance and Other Chargebacks 15,378,608
Community Sponsored Organizations
Depreciation Expense
Contingencies
Debt Service
Miscellaneous
Interfund Transfers 9,262
EXPENSE TOTALS 17,192,633
Fund 605 - INSURANCE FUND Totals 565,405
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 17,758,038
EXPENSE TOTALS 17,192,633
Run by Ashley King on 02/20/2017 03:26:56 PM Page 35 of 39
December YTD 2015
2016 2016 Actual
- - -
- - 280,000
- - -
485,409 10,905,570 6,273,004
470,766 1,559,737 1,206,228
956,175 12,465,308 7,759,232
590,826 8,422,495 8,302,220
- - -
- - -
- - -
153,553 153,553 -
744,379 8,576,048 8,302,220
956,175 12,465,308 7,759,232
744,379 8,576,048 8,302,220
211,796 3,889,259 (542,988)
Starting Fund Balance 66,741,084 66,741,084
Net Change 4,297,865 3,889,259
Ending Fund Balance 71,038,949 70,630,343
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 700 - FIRE PENSION FUND
REVENUE
Property Taxes 7,070,865
Other Taxes 280,000
Interfund Transfers
Other Revenue 1,010,000
Interest Income 4,100,000
REVENUE TOTALS 12,460,865
EXPENSE
Salary and Benefits 8,163,000
Services and Supplies
Community Sponsored Organizations
Debt Service
Miscellaneous
EXPENSE TOTALS 8,163,000
Fund 700 - FIRE PENSION FUND 4,297,865
Fund 700 - FIRE PENSION FUND
REVENUE TOTALS 12,460,865
EXPENSE TOTALS 8,163,000
Run by Ashley King on 02/20/2017 03:26:56 PM Page 36 of 39
December YTD 2015
2016 2016 Actual
- - 57,836
- - 325,000
- - -
1,061,807 16,271,673 7,676,438
477,498 2,713,348 2,902,399
1,539,305 18,985,021 10,961,673
681,880 11,081,511 10,768,296
- - -
- - -
257,574 257,574 -
939,454 11,339,085 10,768,296
1,539,305 18,985,021 10,961,673
939,454 11,339,085 10,768,296
599,851 7,645,936 193,377
Starting Fund Balance 98,558,837 98,558,837
Net Change 6,383,940 7,645,936
Ending Fund Balance 104,942,777 106,204,773
Budget by Organization
Report
Through 12/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 705 - POLICE PENSION FUND
REVENUE
Property Taxes 9,055,940
Other Taxes 325,000
Interfund Transfers
Other Revenue 1,550,000
Interest Income 6,500,000
REVENUE TOTALS 17,430,940
EXPENSE
Salary and Benefits 11,047,000
Services and Supplies
Debt Service
Miscellaneous
EXPENSE TOTALS 11,047,000
Fund 705 - POLICE PENSION FUND
REVENUE TOTALS 17,430,940
EXPENSE TOTALS 11,047,000
Fund 705 - POLICE PENSION FUND 6,383,940
Run by Ashley King on 02/20/2017 03:26:56 PM Page 37 of 39