HomeMy WebLinkAbout2016.01 January Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley King, Finance Division Manager
David Meimers, Accounting Manager
Subject: January 2016 Monthly Financial Report
Date: March 18, 2016
Please find attached the unaudited financial statements as of January 31, 2015. A
summary by fund for revenues, expenditures, fund and cash balances is as follows:
YTD
Revenues
YTD
Expenses YTD Net Fund
Balance Cash Balance
4,257,848 5,500,424 (1,242,576)11,859,782 3,656,830
7 57,569 (57,561)682,048 460,558
73,732 6,444 67,288 115,583 28,961
1,000,000
16,557 405,352 (388,795)1,714,096 963,235
19 2,911 (2,892)119,332 210,742
168,422 69,417 99,005 1,387,082 1,844,301
42,444 70,079 (27,635)575,042 383,649
144,258 (190,544)
37,794 (37,794)438,346 (8,564)
3,220 3,220 2,454,889 225,410
462,247 102,244 360,003 3,041,280 2,459,311
119,332 169,915
2,285 2,285 4,635,293 6,828
21,026 21,026 2,734,540 995,686
726 29,167 (28,441)6,944,106 6,521,303
589,427 525,429
205 12,704 (12,499)1,293,258 1,329,687
11,430 5,118 6,312 182,334 (19,668)
101 2,099 (1,997)441,493 448,588
2,962 (2,962)309,108 309,109
146,154 13,487,663 (13,341,509)2,488,580 433,510
67,470 5,751 61,719 6,111,557 7,170,907
35,860 21,737 14,123 2,696,529 2,692,459
389,130 250,653 138,476 10,650,534 10,371,907
588,145 1,765,821 (1,177,675)6,442,303 8,337,812
1,085,606 526,360 559,246 4,979,283 2,954,300
378,518 98,721 279,797 (754,971)(1,208,007)
282,038 85,360 196,678 470,136 (61,755)
120,952 120,952 2,019,963 1,196,221
2,132,673 1,255,960 876,713 (3,077,905)1,865,480
10,286,815 23,802,309 (13,515,493)71,806,638 55,073,599
176 HUMAN SERVICES FUND
TOTALS
600 FLEET SERVICES FUND
601 EQUIPMENT REPLACEMENT FUND
605 INSURANCE FUND
515 SEWER FUND
520 SOLID WASTE FUND
510-3 WATER FUND
505 PARKING SYSTEM FUND
415 CAPITAL IMPROVEMENTS FUND
420 SPECIAL ASSESSMENT FUND
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
320 DEBT SERVICE FUND
335 WEST EVANSTON TIF FUND
305 SPECIAL SERVICE AREA (SSA) #5
310 HOWARD-HARTREY TIF
250 AFFORDABLE HOUSING FUND
300 WASHINGTON NATIONAL TIF
330 HOWARD-RIDGE TIF FUND
235 NEIGHBORHOOD IMPROVEMENT
240 HOME FUND
220 CDBG LOAN
225 ECONOMIC DEVELOPMENT FUND
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
215 CDBG FUND
195 NEIGHBORHOOD STABILIZATION
200 MOTOR FUEL TAX FUND
175 GENERAL ASSISTANCE FUND
180 GOOD NEIGHBOR FUND
185 LIBRARY FUND
Fund Fund Description
100 GENERAL FUND
* Negative Cash Balances reflect internal account balances and not external bank balances, due
to transaction timing at month end.
Memorandum
Included above are the ending balances as of January 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 may 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 disbu rsements such as receivables (including property
tax) due to the City and accounts payable/accrued expenses.
As of January 31, 2016, the General Fund is reporting a net deficit of $1,242,576. This
is due to a number of revenues not being received in th e beginning of the year.
Property taxes will be shown on the February and March 2016 financial reports. The
attached supplemental charts show all departments below the 8.3% goal for the month.
Many funds had lower than anticipated January expenses due to delays in issuing
purchase orders. This was caused by the reorganization of multiple City departments
and the creation of the Public Works Agency which changed the General Ledger string
for many funds. Expenses will be caught up by the March financial report.
Through January 31, 2016, the CDBG Fund is showing a negative cash balance of
$8,564 which will be reimbursed from February draw-downs.
Through January 31, 2016, the SSA #4 Fund and Howard Ridge TIF funds show
negative cash balances due to the timing of property taxes. This will be eliminated in
the March report as monies have been received in February and March 2016.
Through January 31, 2016, the Economic Development Fund is showing a fund balance
of $3,042,280 and a cash balance of $2,459,311.
The Parking Fund made the $3.2 million Sherman Garage deck payment in December,
reducing their fund balance to $10,650,534.
The Debt Service Fund made a $13 million payment in January in connection with the
refinancing of the 2006B bonds.
Through January 31, 2016, the Solid Waste Fund is showing a negative fund balance of
$754,971 and a cash balance of negative $1,280,007. The January and February
payments to SWANCC were approved by Council in March.
Though operating at a $470,136 surplus for the year, the Fleet Fund is showing a
negative $61,755 cash balance through January 31, 2016. .
Through January 31, 2016, the Insurance Fund is showing a negative fund balance of
$3,077,487 with a cash balance of $1,865,480. This negative balance is primarily for
claims/cases being expensed. These claims/cases have not been settled, and
therefore there is no guarantee the City will actually experience this negative fund
balance as estimated.
YTD
2016 Budget
Amount
January
Actual
Actual
Amount
% of
Budget 2015 Total
27,417,407 20,466 20,466 0 11,397,061
45,986,550 2,133,064 2,133,064 5 43,520,871
5,329,777 321,700 321,700 6 5,324,137
9,276,550 252,160 252,160 3 6,704,846
125,700 19,698 19,698 16 155,619
4,609,825 245,653 245,653 5 3,548,230
640,000 0 640,000
5,374,751 311,755 311,755 6 5,406,379
2,433,216 310,056 310,056 13 2,239,528
8,842,365 583,742 583,742 7 7,836,484
765,727 19,987 19,987 3 640,910
1,286,843 38,882 38,882 3 693,996
50,000 687 687 1 6,572
REVENUE TOTAL 112,138,711 4,257,848 4,257,848 88,114,633
13 - CITY COUNCIL 424,958 27,044 27,044 6%417,571
14 - CITY CLERK 263,203 64,528 16,806 6%281,913
15 - CITY MANAGER'S OFFICE 6,989,746 321,170 321,170 5%1,804,588
17 - LAW 1,130,000 107,430 59,708 5%1,044,228
19 - ADMINISTRATIVE SERVICES 9,634,173 450,936 403,214 4%9,538,936
21 - COMMUNITY DEVELOPMENT 2,740,032 197,942 150,220 5%2,407,297
22 - POLICE 37,696,278 1,848,333 1,800,611 5%28,354,274
23 - FIRE MGMT & SUPPORT 22,601,742 1,114,361 1,066,639 5%14,837,447
24 - HEALTH 3,544,226 169,289 121,567 3%3,198,674
30 - PARKS, REC. AND COMMUNITY SERV. 11,820,590 569,785 522,063 4%11,140,766
40 - PUBLIC WORKS AGENCY 14,861,248 629,606 581,884 4%0
111,706,196 5,500,424 5,070,926 6%73,025,695
112,138,711 4,257,848 4,257,848 4%88,114,633
111,706,196 5,500,424 5,070,926 6%73,025,695
432,515 (1,242,576)(813,078)366%(2,926,259)
Income Statement
Through 01/31/16
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
Fines and Forfeitures
Parking Charges for Services
Parks and Recreation Charges for Services
Other Charges for Services
Property Taxes
Other Taxes
License
Permit
Fee
REVENUE TOTALS
EXPENSE TOTALS
Fund 100 - GENERAL FUND Net Gain (Loss)
Fund 100 - GENERAL FUND Totals
EXPENSE TOTALS
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
YTD
2016 Budget
Amount
January
Actual
Actual
Amount
% of
Budget 2015 Total
900 900 150
6,379,675 372,972 372,972 6 6,081,495
65,000
3,711,770 2,925,296
12,125
119,216 13,791 13,791 12 153,545
35,070 1,467 1,467 4 18,260
REVENUE TOTAL 10,322,856 388,230 388,230 9,178,596
23,000 3,523 3,523 15 29,187
1,348,940 83,388 83,388 6 1,136,557
113,349 7,229 7,229 6 99,018
3,022,411 34,106 34,106 1 2,698,537
278,864 599 599 243,068
3,474,000 2,107,697
319,648 42,327 42,327 13 319,649
2,873,395
11,000 6,951
3,917,652 3,917,650
252,000
1,303,783 79,482 79,482 6 923,092
EXPENSE TOTAL 16,938,042 250,653 250,653 11,481,405
10,322,856 389,130 389,130 9,178,746
16,938,042 250,653 250,653 11,481,405
(6,615,186)138,476 138,476 ()(2,302,659)
EXPENSE TOTALS
Fund 505 - PARKING SYSTEM FUND Net Gain
Income Statement
Through 01/31/16
Summary Listing
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
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 505 - PARKING SYSTEM FUND
YTD
2016 Budget
Amount January Actual Actual Amount
% of
Budget 2015 Total
70,000 5,883 5,883 8 105,483
15,133,000 580,332 580,332 (3)15,301,983
39,000 0 45,102
126,000 0 125,545
22,348,400 1,223 1,223 0 6,109,981
1,600 707 707 44 3,448
REVENUE TOTAL 37,718,000 588,145 588,145 21,691,542
210,465 14,647 14,647 7 157,679
4,534,306 299,578 299,578 7 4,510,838
360,355 25,852 25,852 7 386,339
2,098,760 14,884 14,884 1 1,227,081
1,392,190 23,054 23,054 2 961,136
75,800 595 595 1 583,227
468,492 95,351 95,351 20 468,493
1,000 0 854
1,053,288 0 981,389
62,980 0 875
3,502,313 1,291,859 1,291,859 37 11,875,155
EXPENSE TOTAL 13,759,949 1,765,821 1,765,821 21,153,065
37,718,000 588,145 588,145 (1%)21,691,542
13,759,949 1,765,821 1,765,821 13%21,153,065
23,958,051 (1,177,676)(1,177,676)(9%)538,477
Interfund Transfers
Fund 510 - WATER FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 510 - WATER FUND Net Gain (Loss)
Capital Outlay
Insurance and Other Chargebacks
Contingencies
Debt Service
Miscellaneous
Benefits
Pensions
Services
Supplies
Other Charges for Services
Other Revenue
Interest Income
Employee Pay
Fee
Water Charges for Services
Sewer Charges for Services
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 510-513 - WATER FUND
Income Statement
Through 01/31/16
Summary Listing
YTD
2016 Budget
Amount January Actual Actual Amount
% of
Budget 2015 Total
12,869,000.00 1,085,137.22 1,085,137.22 8%13,003,876.03
19,650.00 .00 .00 0%19,650.01
984,165.00 .00 .00 0%.00
1,000.00 469.07 469.07 47%2,705.81
REVENUE TOTAL 13,873,815.00 1,085,606.29 1,085,606.29 13,026,231.85
57,040.00 2,409.81 2,409.81 4%60,837.05
1,025,778.00 71,112.95 71,112.95 7%1,005,581.58
86,092.00 6,375.52 6,375.52 7%91,066.44
903,500.00 105.00 105.00 0%898,074.62
92,300.00 2,303.91 2,303.91 2%18,817.35
3,048,314.00 .00 .00 0%500,880.96
269,988.00 55,283.75 55,283.75 20%269,988.00
9,222,913.00 345,237.73 345,237.73 4%1,911,502.59
1,500.00 .00 .00 0%3,305.66
773,876.00 43,531.67 43,531.67 6%735,235.44
EXPENSE TOTAL 15,481,301.00 526,360.34 526,360.34 5,495,289.69
13,873,815.00 1,085,606.29 1,085,606.29 13,026,231.85
15,481,301.00 526,360.34 526,360.34 5,495,289.69
($1,607,486.00)$559,245.95 $559,245.95 $7,530,942.16Fund 515 - SEWER FUND Net Gain (Loss)
Income Statement
Through 01/31/16
Summary Listing
Miscellaneous
Interfund Transfers
Fund 515 - SEWER FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Services
Supplies
Capital Outlay
Insurance and Other Chargebacks
Debt Service
Employee Pay
Benefits
Pensions
Charges for Services
Sewer Charges for Services
Other Charges for Services
Other Revenue
Interest Income
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 515 - SEWER FUND
YTD
2016 Budget
Amount January Actual
Actual
Amount
% of
Budget 2015 Total
275,000 357,583
87,997 87,997
3,632,394 289,548 289,548 (8)3,557,884
1,055,967 973 973 1,055,967
238,000 228,394
REVENUE TOTAL 5,201,361 378,518 378,518 5,199,828
25,000 4,124 4,124 16 41,358
779,380 35,814 35,814 5 702,238
63,718 3,040 3,040 5 60,582
3,679,126 389 389 3,644,097
53,050 2,922 2,922 6 73,788
25,750 24,738
10,808 10,808
85,326
15,000
499,493 41,624 41,624 8 490,106
EXPENSE TOTAL 5,140,517 98,721 98,721 5,122,233
5,201,361 378,518 378,518 5,199,828
5,140,517 98,721 98,721 5,122,233
60,844 279,797 279,797 77,595
License
Solid Waste Charges for Services
Other Charges for Services
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 520 - SOLID WASTE FUND
Pensions
Services
Supplies
Interfund Transfers
Other Revenue
Employee Pay
Benefits
Income Statement
Through 01/31/16
Summary Listing
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 520 - SOLID WASTE FUND Net Gain (Loss)
Capital Outlay
Insurance and Other Chargebacks
Debt Service
Miscellaneous
Interfund Transfers
Jan-16 YTD 2015
Transactions Transactions Actual
20,466 20,466 11,397,061
2,133,064 2,133,064 43,520,871
593,558 593,558 12,184,602
245,653 245,653 3,548,230
621,810 621,810 8,285,907
583,742 583,742 7,836,484
19,987 19,987 640,910
38,882 38,882 693,996
687 687 6,572
4,257,848 4,257,848 88,114,633
3,840,662 3,840,662 68,444,110
189,238 189,238 11,407,851
1,492 1,492 142,786
970,889 970,889 3,020,991
952,678
30,433
95,131 95,131 1,740,188
403,012 403,012 5,301,854
5,500,424 5,500,424 91,040,892
4,257,848 4,257,848 88,114,633
5,500,424 5,500,424 91,040,892
(1,242,576)(1,242,576)(2,926,259)
Starting Fund Balance 13,102,358 13,102,358
Net Change (567,485)(1,242,576)
Ending Fund Balance 12,534,873 11,859,782
REVENUE TOTALS 112,138,711
EXPENSE TOTALS 112,706,196
Fund 100 - GENERAL FUND Totals (567,485)
Interfund Transfers 6,534,528
EXPENSE TOTALS 112,706,196
Fund 100 - GENERAL FUND Totals
Contingencies 213,505
Debt Service
Miscellaneous 1,661,899
Insurance and Other Chargebacks 20,282,973
Community Sponsored Organizations 925,029
Depreciation Expense
EXPENSE
Salary and Benefits 71,111,353
Services and Supplies 11,776,309
Capital Outlay 200,600
Special Assessment
Reappropriation of Surplus
REVENUE TOTALS 112,138,711
Insurance
Library Revenue
Interest Income 50,000
Intergovernmental Revenue 765,727
Other Revenue 1,286,843
Workers Compensation and Liability
Fines and Forfeitures 4,609,825
Charges for Services 8,447,967
Interfund Transfers 8,842,365
REVENUE
Property Taxes 27,417,407
Other Taxes 45,986,550
Licenses, Permits and Fees 14,732,027
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 100 - GENERAL FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 1 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,313,420
3,208
19,534
7 7 62
7 7 1,336,224
14,809 14,809 183,547
40,931 40,931 591,542
1,770 1,770
59 59 4,625
57,569 57,569 779,714
7 7 1,336,224
57,569 57,569 779,714
(57,561)(57,561)556,510
Starting Fund Balance 739,609 739,609
Net Change 38,167 (57,561)
Ending Fund Balance 777,776 682,048
REVENUE TOTALS 1,026,000
EXPENSE TOTALS 987,833
Fund 175 - GENERAL ASSISTANCE 38,167
Interfund Transfers
EXPENSE TOTALS 987,833
Fund 175 - GENERAL ASSISTANCE
Contingencies
Debt Service
Miscellaneous 7,000
Insurance and Other Chargebacks
Community Sponsored Organizations
Depreciation Expense
EXPENSE
Salary and Benefits 221,933
Services and Supplies 758,900
Capital Outlay
Special Assessment
Reappropriation of Surplus
REVENUE TOTALS 1,026,000
Insurance
Library Revenue
Interest Income 1,000
Intergovernmental Revenue
Other Revenue 25,000
Workers Compensation and Liability
Fines and Forfeitures
Charges for Services
Interfund Transfers
REVENUE
Property Taxes 1,000,000
Other Taxes
Licenses, Permits and Fees
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 175 - GENERAL ASSISTANCE FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 2 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
73,732 73,732 884,794
73,732 73,732 884,794
6,444 6,444 849,388
6,444 6,444 849,388
73,732 73,732 884,794
6,444 6,444 849,388
67,288 67,288 35,406
Starting Fund Balance 48,295 48,295
Net Change 25,641 67,288
Ending Fund Balance 73,936 115,583
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN 25,641
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 884,794
Capital Outlay
Community Sponsored Organizations 859,153
Miscellaneous
Other Revenue
REVENUE TOTALS 884,794
EXPENSE
Services and Supplies
REVENUE
Charges for Services
Interfund Transfers 884,794
Intergovernmental Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 176 - HEALTH AND HUMAN SERVICES
Run by Ashley King on 03/09/2016 10:12:21 AM Page 3 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
Starting Fund Balance
Net Change
Ending Fund Balance
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
REVENUE TOTALS 1,000,000
EXPENSE
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 180 - GOOD NEIGHBOR FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 4 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
16,420 16,420 5,916,852
50,200
189,929
171,000
238,203
286
(81)(81)315,890
218 218 2,683
16,557 16,557 6,885,044
317,567 317,567 4,354,576
25,471 25,471 1,442,859
90 90 37,508
41,045 41,045 77,268
250,000
21,179 21,179 4,200
405,352 405,352 6,166,411
16,557 16,557 6,885,044
405,352 405,352 6,166,411
(388,795)(388,795)718,634
Starting Fund Balance 2,102,891 2,102,891
Net Change 20,015 (388,795)
Ending Fund Balance 2,122,906 1,714,096
EXPENSE TOTALS 6,997,142
Fund 185 - LIBRARY FUND Totals 20,015
EXPENSE TOTALS 6,997,142
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 7,017,157
Debt Service
Miscellaneous 250,000
Interfund Transfers 10,183
Insurance and Other Chargebacks 80,089
Depreciation Expense
Contingencies
EXPENSE
Salary and Benefits 4,751,497
Services and Supplies 1,872,573
Capital Outlay 32,800
Library Revenue 333,300
Interest Income 2,000
REVENUE TOTALS 7,017,157
Interfund Transfers 185,800
Intergovernmental Revenue 94,177
Other Revenue 247,500
REVENUE
Property Taxes 6,104,180
Other Taxes 50,200
Fines and Forfeitures
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 185 - LIBRARY FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 5 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
601,811
601,811
14,550
277,553
562,740
854,842
601,811
854,842
(253,031)
Starting Fund Balance 132,667 132,667
Net Change
Ending Fund Balance 132,667 132,667
REVENUE TOTALS 393,409
EXPENSE TOTALS 393,409
Fund 186 - LIBRARY DEBT SERVICE
Miscellaneous
EXPENSE TOTALS 393,409
Fund 186 - LIBRARY DEBT SERVICE
EXPENSE
Services and Supplies
Capital Outlay
Debt Service 393,409
REVENUE
Property Taxes 393,409
Interest Income
REVENUE TOTALS 393,409
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 186 - LIBRARY DEBT SERVICE FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 6 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
131,113
135,461
19 19 213
19 19 266,788
2,128 2,128 59,467
4,611
69,203
784 784 5,730
180
(8,213)
2,911 2,911 130,978
19 19 266,788
2,911 2,911 130,978
(2,892)(2,892)135,810
Starting Fund Balance 122,224 122,224
Net Change (303)(2,892)
Ending Fund Balance 121,921 119,332
EXPENSE TOTALS 198,954
Fund 195 - NEIGHBORHOOD (303)
EXPENSE TOTALS 198,954
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 198,651
Debt Service
Miscellaneous 120,862
Interfund Transfers
Services and Supplies 5,100
Capital Outlay 35,000
Insurance and Other Chargebacks 4,344
Interest Income
REVENUE TOTALS 198,651
EXPENSE
Salary and Benefits 33,648
REVENUE
Licenses, Permits and Fees
Intergovernmental Revenue 198,651
Other Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 7 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
168,107 168,107 1,840,455
315 315 819
168,422 168,422 1,841,274
1,500,228
69,417 69,417 833,000
69,417 69,417 2,333,228
168,422 168,422 1,841,274
69,417 69,417 2,333,228
99,005 99,005 (491,954)
Starting Fund Balance 1,288,077 1,288,077
Net Change (478,000)99,005
Ending Fund Balance 810,077 1,387,082
Fund 200 - MOTOR FUEL TAX FUND (478,000)
Fund 200 - MOTOR FUEL TAX FUND
REVENUE TOTALS 1,711,000
EXPENSE TOTALS 2,189,000
Miscellaneous
Interfund Transfers 2,189,000
EXPENSE TOTALS 2,189,000
Capital Outlay
Contingencies
Debt Service
Reappropriation of Surplus
REVENUE TOTALS 1,711,000
EXPENSE
Services and Supplies
REVENUE
Intergovernmental Revenue 1,710,000
Other Revenue
Interest Income 1,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 200 - MOTOR FUEL TAX FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 8 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
42,348 42,348 1,023,357
100
96 96 189
42,444 42,444 1,023,646
40,857 40,857 579,447
21,310 21,310 347,694
239,421
7,912 7,912 29,486
2,046
1,500
129,729
70,079 70,079 1,329,323
42,444 42,444 1,023,646
70,079 70,079 1,329,323
(27,635)(27,635)(305,677)
Starting Fund Balance 602,677 602,677
Net Change (497,643)(27,635)
Ending Fund Balance 105,034 575,042
Fund 205 - EMERGENCY TELEPHONE (497,643)
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,019,000
EXPENSE TOTALS 1,516,643
Miscellaneous
Interfund Transfers 129,729
EXPENSE TOTALS 1,516,643
Community Sponsored Organizations
Contingencies 5,000
Debt Service
Services and Supplies 377,600
Capital Outlay 393,615
Insurance and Other Chargebacks 29,926
Interest Income 1,000
REVENUE TOTALS 1,019,000
EXPENSE
Salary and Benefits 580,773
REVENUE
Other Taxes 1,018,000
Intergovernmental Revenue
Other Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 9 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
322,055
3
322,058
323,000
323,000
322,058
323,000
(942)
Starting Fund Balance 144,258 144,258
Net Change
Ending Fund Balance 144,258 144,258
EXPENSE TOTALS 320,000
Fund 210 - SPECIAL SERVICE AREA
EXPENSE TOTALS 320,000
Fund 210 - SPECIAL SERVICE AREA
REVENUE TOTALS 320,000
EXPENSE
Services and Supplies 320,000
Debt Service
Miscellaneous
REVENUE
Property Taxes 320,000
Interest Income
REVENUE TOTALS 320,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
Run by Ashley King on 03/09/2016 10:12:21 AM Page 10 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,750,089
3,318
1,753,407
33,465 33,465 362,786
5 5 28,988
276,834
7,647 7,647 20,767
235,459
(3,500)(3,500)72,142
177 177 449,083
37,794 37,794 1,446,060
1,753,407
37,794 37,794 1,446,060
(37,794)(37,794)307,347
Starting Fund Balance 476,140 476,140
Net Change 375 (37,794)
Ending Fund Balance 476,515 438,346
EXPENSE TOTALS 2,594,625
Fund 215 - CDBG FUND Totals 375
EXPENSE TOTALS 2,594,625
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,595,000
Debt Service
Miscellaneous 1,274,280
Interfund Transfers 837,124
Insurance and Other Chargebacks 26,989
Community Sponsored Organizations
Contingencies
EXPENSE
Salary and Benefits 452,432
Services and Supplies 3,800
Capital Outlay
Other Revenue
Interest Income
REVENUE TOTALS 2,595,000
REVENUE
Charges for Services
Interfund Transfers
Intergovernmental Revenue 2,595,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 215 - CDBG FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 11 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
3,172 3,172 237,317
48 48 375
3,220 3,220 237,692
198,070
1,919
199,989
3,220 3,220 237,692
199,989
3,220 3,220 37,703
Starting Fund Balance 2,451,669 2,451,669
Net Change 3,220
Ending Fund Balance 2,451,669 2,454,889
Fund 220 - CDBG LOAN Totals
Fund 220 - CDBG LOAN Totals
REVENUE TOTALS 350,000
EXPENSE TOTALS 350,000
Miscellaneous 10,000
Interfund Transfers
EXPENSE TOTALS 350,000
REVENUE TOTALS 350,000
EXPENSE
Salary and Benefits
Services and Supplies 340,000
REVENUE
Intergovernmental Revenue
Other Revenue 350,000
Interest Income
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 220 - CDBG LOAN
Run by Ashley King on 03/09/2016 10:12:21 AM Page 12 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
461,289 461,289 2,104,007
900 900 49,000
58 58 128
462,247 462,247 2,153,135
41,715 41,715 596,265
800 800 295,851
(242)(242)194,941
9,971 9,971 32,230
1,293,041
50,000 50,000 600,000
102,244 102,244 3,012,329
462,247 462,247 2,153,135
102,244 102,244 3,012,329
360,003 360,003 (859,193)
Starting Fund Balance 2,681,277 2,681,277
Net Change (286,099)360,003
Ending Fund Balance 2,395,178 3,041,280
EXPENSE TOTALS 2,548,699
Fund 225 - ECONOMIC DEVELOPMENT (286,099)
EXPENSE TOTALS 2,548,699
Fund 225 - ECONOMIC DEVELOPMENT
REVENUE TOTALS 2,262,600
Debt Service
Miscellaneous 16,000
Interfund Transfers 600,000
Insurance and Other Chargebacks 32,770
Community Sponsored Organizations
Contingencies
EXPENSE
Salary and Benefits 734,229
Services and Supplies 912,200
Capital Outlay 253,500
Other Revenue 50,000
Interest Income 100
REVENUE TOTALS 2,262,600
REVENUE
Other Taxes 2,165,000
Interfund Transfers 47,500
Intergovernmental Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 225 - ECONOMIC DEVELOPMENT FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 13 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
Starting Fund Balance 169,915 169,915
Net Change (80,000)
Ending Fund Balance 89,915 169,915
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (80,000)
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS 20,000
Debt Service
Miscellaneous 100,000
Interfund Transfers
REVENUE TOTALS 20,000
EXPENSE
Services and Supplies
Capital Outlay
REVENUE
Other Taxes 20,000
Interfund Transfers
Interest Income
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 235 - NEIGHBORHOOD IMPROVEMENT
Run by Ashley King on 03/09/2016 10:12:21 AM Page 14 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
518,870
2,282 2,282 33,633
3 3 19
2,285 2,285 552,523
12,388
458,168
1,368
680
26,990
499,594
2,285 2,285 552,523
499,594
2,285 2,285 52,929
Starting Fund Balance 4,633,008 4,633,008
Net Change 2,285
Ending Fund Balance 4,633,008 4,635,293
EXPENSE TOTALS 402,168
Fund 240 - HOME FUND Totals
EXPENSE TOTALS 402,168
Fund 240 - HOME FUND Totals
REVENUE TOTALS 402,168
Debt Service
Miscellaneous 500
Interfund Transfers
Capital Outlay
Insurance and Other Chargebacks 820
Community Sponsored Organizations
REVENUE TOTALS 402,168
EXPENSE
Salary and Benefits 48,348
Services and Supplies 352,500
REVENUE
Intergovernmental Revenue 393,868
Other Revenue 8,300
Interest Income
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 240 - HOME FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 15 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
20,000 20,000 100,000
972 972 142,315
54 54 111
21,026 21,026 242,426
98
75,734
75,832
21,026 21,026 242,426
75,832
21,026 21,026 166,594
Starting Fund Balance 2,713,514 2,713,514
Net Change (313,719)21,026
Ending Fund Balance 2,399,795 2,734,540
REVENUE TOTALS 160,628
EXPENSE TOTALS 474,347
Fund 250 - AFFORDABLE HOUSING (313,719)
Interfund Transfers
EXPENSE TOTALS 474,347
Fund 250 - AFFORDABLE HOUSING
Community Sponsored Organizations
Debt Service
Miscellaneous 76,000
EXPENSE
Salary and Benefits 48,347
Services and Supplies 350,000
Capital Outlay
Other Revenue 130,400
Interest Income 228
REVENUE TOTALS 160,628
REVENUE
Other Taxes 30,000
Interfund Transfers
Intergovernmental Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 250 - AFFORDABLE HOUSING FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 16 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
4,921,484
726 726 3,530
726 726 4,925,014
1,408
198,823
574,976
98,670
29,167 29,167 3,265,296
29,167 29,167 4,139,172
726 726 4,925,014
29,167 29,167 4,139,172
(28,441)(28,441)785,843
Starting Fund Balance 6,972,547 6,972,547
Net Change (2,640,683)(28,441)
Ending Fund Balance 4,331,864 6,944,106
EXPENSE TOTALS 7,787,683
Fund 300 - WASHINGTON NATIONAL (2,640,683)
EXPENSE TOTALS 7,787,683
Fund 300 - WASHINGTON NATIONAL
REVENUE TOTALS 5,147,000
Debt Service
Miscellaneous 500,000
Interfund Transfers 6,287,683
EXPENSE
Salary and Benefits
Services and Supplies 1,000,000
Capital Outlay
Other Revenue
Interest Income 2,000
REVENUE TOTALS 5,147,000
REVENUE
Property Taxes 5,145,000
Other Taxes
Interfund Transfers
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 300 - WASHINGTON NATIONAL TIF FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 17 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
422,527
4
422,531
297,150
297,150
422,531
297,150
125,381
Starting Fund Balance 589,427 589,427
Net Change (467,971)
Ending Fund Balance 121,456 589,427
Fund 305 - SPECIAL SERVICE AREA (467,971)
Fund 305 - SPECIAL SERVICE AREA
REVENUE TOTALS 300
EXPENSE TOTALS 468,271
Debt Service 416,872
Miscellaneous
EXPENSE TOTALS 468,271
Interest Income 300
REVENUE TOTALS 300
EXPENSE
Services and Supplies 51,399
REVENUE
Property Taxes
Interfund Transfers
Other Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 305 - SPECIAL SERVICE AREA (SSA) #5
Run by Ashley King on 03/09/2016 10:12:21 AM Page 18 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,248,231
205 205 1,985
205 205 1,250,216
1,158
11,402
2,153,374
12,704 12,704 148,010
12,704 12,704 2,313,943
205 205 1,250,216
12,704 12,704 2,313,943
(12,499)(12,499)(1,063,726)
Starting Fund Balance 1,305,757 1,305,757
Net Change (650,450)(12,499)
Ending Fund Balance 655,307 1,293,258
EXPENSE TOTALS 1,952,450
Fund 310 - HOWARD-HARTREY TIF (650,450)
EXPENSE TOTALS 1,952,450
Fund 310 - HOWARD-HARTREY TIF
REVENUE TOTALS 1,302,000
Debt Service
Miscellaneous 200,000
Interfund Transfers 1,752,450
EXPENSE
Services and Supplies
Capital Outlay
Community Sponsored Organizations
REVENUE
Property Taxes 1,300,000
Interest Income 2,000
REVENUE TOTALS 1,302,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 310 - HOWARD-HARTREY TIF
Run by Ashley King on 03/09/2016 10:12:21 AM Page 19 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
893,387
893,387
893,387
(893,387)
Starting Fund Balance
Net Change
Ending Fund Balance
Fund 315 - SOUTHWEST TIF FUND
Fund 315 - SOUTHWEST TIF FUND
REVENUE TOTALS
EXPENSE TOTALS
Miscellaneous
Interfund Transfers
EXPENSE TOTALS
EXPENSE
Services and Supplies
Capital Outlay
Debt Service
REVENUE
Property Taxes
Interest Income
REVENUE TOTALS
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 315 - SOUTHWEST TIF FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 20 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
30,799 30,799 11,156,231
1,642,654
115,133 115,133 12,278,473
222 222 7,668
146,154 146,154 25,085,026
171,576
13,487,663 13,487,663 13,028,022
880
13,487,663 13,487,663 13,200,479
146,154 146,154 25,085,026
13,487,663 13,487,663 13,200,479
(13,341,509)(13,341,509)11,884,547
Starting Fund Balance 15,697,422 15,697,422
Net Change (2,751,668)(13,341,509)
Ending Fund Balance 12,945,754 2,355,913
EXPENSE TOTALS 16,279,452
Fund 320 - DEBT SERVICE FUND Totals (2,751,668)
EXPENSE TOTALS 16,279,452
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 13,527,784
Debt Service 15,963,682
Miscellaneous
Interfund Transfers
Interest Income 1,500
REVENUE TOTALS 13,527,784
EXPENSE
Services and Supplies 315,770
REVENUE
Property Taxes 10,879,993
Interfund Transfers 2,646,291
Other Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 320 - DEBT SERVICE FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 21 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
6,204 6,204 540,576
5,197 5,197 64,176
29 29 1,815
11,430 11,430 606,568
67 67 587,839
(6,275)
51 51 585
15
5,000 5,000 107,500
5,118 5,118 689,664
11,430 11,430 606,568
5,118 5,118 689,664
6,312 6,312 (83,097)
Starting Fund Balance 176,022 176,022
Net Change 24,000 6,312
Ending Fund Balance 200,022 182,334
REVENUE TOTALS 1,670,100
EXPENSE TOTALS 1,646,100
Fund 330 - HOWARD-RIDGE TIF FUND 24,000
Interfund Transfers 107,500
EXPENSE TOTALS 1,646,100
Fund 330 - HOWARD-RIDGE TIF FUND
Community Sponsored Organizations
Debt Service 600
Miscellaneous
REVENUE TOTALS 1,670,100
EXPENSE
Services and Supplies 538,000
Capital Outlay 1,000,000
REVENUE
Property Taxes 550,000
Other Revenue 1,120,000
Interest Income 100
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 330 - HOWARD-RIDGE TIF FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 22 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
101 101 257
101 101 257
1,158
(1,028)(1,028)(11,205)
627 627 7,185
2,500 2,500 60,000
2,099 2,099 57,137
101 101 257
2,099 2,099 57,137
(1,997)(1,997)(56,880)
Starting Fund Balance 443,490 443,490
Net Change (39,850)(1,997)
Ending Fund Balance 403,640 441,493
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF FUND
Contingencies
Debt Service 10,000
Miscellaneous
REVENUE TOTALS 150
EXPENSE
Services and Supplies
Capital Outlay
REVENUE
Property Taxes
Other Revenue
Interest Income 150
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 335 - WEST EVANSTON TIF FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 23 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
Starting Fund Balance
Net Change 10,000
Ending Fund Balance 10,000
Fund 340 - DEMPSTER-DODGE TIF 10,000
Fund 340 - DEMPSTER-DODGE TIF
REVENUE TOTALS 50,000
EXPENSE TOTALS 40,000
EXPENSE
Services and Supplies
Debt Service 40,000
EXPENSE TOTALS 40,000
REVENUE
Property Taxes
Other Revenue 50,000
REVENUE TOTALS 50,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 340 - DEMPSTER-DODGE TIF FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 24 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
900,000
2,900,000
580,000
2,962 2,962 7,930
2,962 2,962 587,930
900,000
2,962 2,962 587,930
(2,962)(2,962)312,070
Starting Fund Balance 312,070 312,070
Net Change 31,500 (2,962)
Ending Fund Balance 343,570 309,108
EXPENSE TOTALS 43,500
Fund 345 - CHICAGO-MAIN TIF Totals 31,500
EXPENSE TOTALS 43,500
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 75,000
EXPENSE
Services and Supplies
Capital Outlay
Debt Service 43,500
REVENUE
Property Taxes 75,000
Other Revenue
REVENUE TOTALS 75,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 345 - CHICAGO-MAIN TIF
Run by Ashley King on 03/09/2016 10:12:21 AM Page 25 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
Starting Fund Balance
Net Change 10,500
Ending Fund Balance 10,500
Fund 350 - SPECIAL SERVICE AREA 10,500
Fund 350 - SPECIAL SERVICE AREA
REVENUE TOTALS 210,500
EXPENSE TOTALS 200,000
EXPENSE
Services and Supplies 200,000
EXPENSE TOTALS 200,000
REVENUE
Property Taxes 210,000
Interest Income 500
REVENUE TOTALS 210,500
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
Run by Ashley King on 03/09/2016 10:12:21 AM Page 26 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
23,498 23,498 87,391
464,081
43,000 43,000 7,945,481
972 972 3,815
67,470 67,470 8,500,767
72 72 643,510
5,679 5,679 9,269,789
490,000
5,751 5,751 10,403,299
67,470 67,470 8,500,767
5,751 5,751 10,403,299
61,719 61,719 (1,902,532)
Starting Fund Balance 6,049,838 6,049,838
Net Change (2,209,000)61,719
Ending Fund Balance 3,840,838 6,111,557
EXPENSE TOTALS 22,769,615
Fund 415 - CAPITAL IMPROVEMENTS (2,209,000)
EXPENSE TOTALS 22,769,615
Fund 415 - CAPITAL IMPROVEMENTS
REVENUE TOTALS 20,560,615
Debt Service
Miscellaneous
Interfund Transfers 490,000
EXPENSE
Salary and Benefits
Services and Supplies 2,256,962
Capital Outlay 20,022,653
Other Revenue 9,248,000
Interest Income
REVENUE TOTALS 20,560,615
REVENUE
Charges for Services
Interfund Transfers 6,471,000
Intergovernmental Revenue 4,841,615
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 415 - CAPITAL IMPROVEMENTS FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 27 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
243,113
6,669 6,669 26,205
29,191 29,191 122,937
35,860 35,860 392,255
12 12 1,879
226,538
21,725 21,725
21,737 21,737 228,417
35,860 35,860 392,255
21,737 21,737 228,417
14,123 14,123 163,838
Starting Fund Balance 2,682,406 2,682,406
Net Change 98,950 14,123
Ending Fund Balance 2,781,356 2,696,529
REVENUE TOTALS 481,200
EXPENSE TOTALS 382,250
Fund 420 - SPECIAL ASSESSMENT 98,950
Interfund Transfers 382,250
EXPENSE TOTALS 382,250
Fund 420 - SPECIAL ASSESSMENT
Insurance and Other Chargebacks
Debt Service
Miscellaneous
EXPENSE
Salary and Benefits
Services and Supplies
Capital Outlay
Special Assessment 180,167
Reappropriation of Surplus
REVENUE TOTALS 481,200
Insurance
Library Revenue
Interest Income 51,033
Intergovernmental Revenue
Other Revenue 250,000
Workers Compensation and Liability
Fines and Forfeitures
Charges for Services
Interfund Transfers
REVENUE
Property Taxes
Other Taxes
Licenses, Permits and Fees
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 420 - SPECIAL ASSESSMENT FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 28 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
900 900 150
372,972 372,972 6,081,495
2,925,296
13,791 13,791 153,545
1,467 1,467 18,260
389,130 389,130 9,178,746
94,140 94,140 1,264,762
34,704 34,704 2,941,605
2,107,697
42,327 42,327 319,649
6,951
3,917,650
79,482 79,482 923,092
250,653 250,653 11,481,405
389,130 389,130 9,178,746
250,653 250,653 11,481,405
138,476 138,476 (2,302,659)
Starting Fund Balance 10,512,058 10,512,058
Net Change (6,615,186)138,476
Ending Fund Balance 3,896,872 10,650,534
Fund 505 - PARKING SYSTEM FUND (6,615,186)
Fund 505 - PARKING SYSTEM FUND
REVENUE TOTALS 10,322,856
EXPENSE TOTALS 16,938,042
Miscellaneous 252,000
Interfund Transfers 1,303,783
EXPENSE TOTALS 16,938,042
Depreciation Expense 2,873,395
Contingencies 11,000
Debt Service 3,917,652
Capital Outlay 3,474,000
Insurance and Other Chargebacks 319,648
Community Sponsored Organizations
REVENUE TOTALS 10,322,856
EXPENSE
Salary and Benefits 1,485,289
Services and Supplies 3,301,275
Intergovernmental Revenue 12,125
Other Revenue 119,216
Interest Income 35,070
Fines and Forfeitures
Charges for Services 6,444,675
Interfund Transfers 3,711,770
REVENUE
Property Taxes
Other Taxes
Licenses, Permits and Fees
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 505 - PARKING SYSTEM FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 29 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
5,883 5,883 105,483
(419,965)(419,965)15,472,630
1,223 1,223 6,109,981
707 707 3,448
(412,151)(412,151)21,691,542
340,078 340,078 5,054,856
37,938 37,938 2,188,217
595 595 583,227
93,879 93,879 468,493
854
981,389
875
1,291,859 1,291,859 11,875,155
1,764,349 1,764,349 21,153,065
(412,151)(412,151)21,691,542
1,764,349 1,764,349 21,153,065
(2,176,500)(2,176,500)538,477
Starting Fund Balance 7,619,979 7,619,979
Net Change 23,958,051 (2,176,500)
Ending Fund Balance 31,578,030 5,443,479
EXPENSE TOTALS 13,759,949
Fund 510 - WATER FUND Totals 23,958,051
EXPENSE TOTALS 13,759,949
Fund 510 - WATER FUND Totals
REVENUE TOTALS 37,718,000
Debt Service 1,053,288
Miscellaneous 62,980
Interfund Transfers 3,502,313
Community Sponsored Organizations
Depreciation Expense
Contingencies 1,000
Services and Supplies 3,490,950
Capital Outlay 75,800
Insurance and Other Chargebacks 468,492
Interest Income 1,600
REVENUE TOTALS 37,718,000
EXPENSE
Salary and Benefits 5,105,126
Interfund Transfers
Intergovernmental Revenue
Other Revenue 22,348,400
REVENUE
Other Taxes
Licenses, Permits and Fees 70,000
Charges for Services 15,298,000
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 510 - WATER FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 30 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
195 195 1,207
195 195 1,207
195 195 1,207
195 195 1,207
Starting Fund Balance
Net Change 195
Ending Fund Balance 195
REVENUE TOTALS
EXPENSE TOTALS
Fund 511 - WATER - BOND AND
Miscellaneous
EXPENSE TOTALS
Fund 511 - WATER - BOND AND
REVENUE TOTALS
EXPENSE
Services and Supplies
Debt Service
REVENUE
Interfund Transfers
Other Revenue
Interest Income
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 511 - WATER - BOND AND INTEREST
Run by Ashley King on 03/09/2016 10:12:21 AM Page 31 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
54 54 792
54 54 792
54 54 792
54 54 792
Starting Fund Balance
Net Change 54
Ending Fund Balance 54
EXPENSE TOTALS
Fund 512 - WATER-BOND RESERVE
EXPENSE TOTALS
Fund 512 - WATER-BOND RESERVE
REVENUE TOTALS
Services and Supplies
Miscellaneous
Interfund Transfers
REVENUE
Interest Income
REVENUE TOTALS
EXPENSE
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 512 - WATER-BOND RESERVE
Run by Ashley King on 03/09/2016 10:12:21 AM Page 32 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,000,000 1,000,000 8,550,000
997,243
47 47 534
1,000,047 1,000,047 9,547,777
395,395
1,471 1,471 8,293,392
1,471 1,471 8,688,787
1,000,047 1,000,047 9,547,777
1,471 1,471 8,688,787
998,576 998,576 858,989
Starting Fund Balance
Net Change (27,365,306)998,576
Ending Fund Balance (27,365,306)998,576
EXPENSE TOTALS 27,365,306
Fund 513 - WATER DEPR IMPRV & (27,365,306)
EXPENSE TOTALS 27,365,306
Fund 513 - WATER DEPR IMPRV &
REVENUE TOTALS
Capital Outlay 24,700,306
Miscellaneous
Interfund Transfers
Interest Income
REVENUE TOTALS
EXPENSE
Services and Supplies 2,665,000
REVENUE
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 513 - WATER DEPR IMPRV & EXTENSION
Run by Ashley King on 03/09/2016 10:12:21 AM Page 33 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,085,137 1,085,137 13,023,526
469 469 2,706
1,085,606 1,085,606 13,026,232
79,898 79,898 1,157,485
2,409 2,409 916,892
500,881
55,284 55,284 269,988
345,238 345,238 1,911,503
3,306
43,532 43,532 735,235
526,360 526,360 5,495,290
1,085,606 1,085,606 13,026,232
526,360 526,360 5,495,290
559,246 559,246 7,530,942
Starting Fund Balance 4,420,037 4,420,037
Net Change (1,607,486)559,246
Ending Fund Balance 2,812,551 4,979,283
Fund 515 - SEWER FUND Totals (1,607,486)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 13,873,815
EXPENSE TOTALS 15,481,301
Miscellaneous 1,500
Interfund Transfers 773,876
EXPENSE TOTALS 15,481,301
Depreciation Expense
Contingencies
Debt Service 9,222,913
Services and Supplies 995,800
Capital Outlay 3,048,314
Insurance and Other Chargebacks 269,988
Interest Income 1,000
REVENUE TOTALS 13,873,815
EXPENSE
Salary and Benefits 1,168,910
REVENUE
Charges for Services 12,888,650
Interfund Transfers
Other Revenue 984,165
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 515 - SEWER FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 34 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
357,583
87,997 87,997 3,557,884
289,548 289,548 1,055,967
973 973
228,394
378,518 378,518 5,199,828
42,978 42,978 804,178
3,311 3,311 3,717,885
24,738
10,808 10,808
85,326
41,624 41,624 490,106
98,721 98,721 5,122,233
378,518 378,518 5,199,828
98,721 98,721 5,122,233
279,797 279,797 77,595
Starting Fund Balance (1,034,768)(1,034,768)
Net Change 60,844 279,797
Ending Fund Balance (973,924)(754,971)
Fund 520 - SOLID WASTE FUND Totals 60,844
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,201,361
EXPENSE TOTALS 5,140,517
Miscellaneous 15,000
Interfund Transfers 499,493
EXPENSE TOTALS 5,140,517
Depreciation Expense
Contingencies
Debt Service
Capital Outlay 25,750
Insurance and Other Chargebacks
Community Sponsored Organizations
REVENUE TOTALS 5,201,361
EXPENSE
Salary and Benefits 868,098
Services and Supplies 3,732,176
Intergovernmental Revenue
Other Revenue 238,000
Interest Income
REVENUE
Licenses, Permits and Fees 275,000
Charges for Services 3,632,394
Interfund Transfers 1,055,967
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 520 - SOLID WASTE FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 35 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
282,038 282,038 3,289,009
46,933
282,038 282,038 3,335,942
67,724 67,724 1,173,877
62 62 1,741,844
17,575 17,575 25,820
85,360 85,360 2,941,540
282,038 282,038 3,335,942
85,360 85,360 2,941,540
196,678 196,678 394,402
Starting Fund Balance 273,458 273,458
Net Change (244,277)196,678
Ending Fund Balance 29,181 470,136
EXPENSE TOTALS 3,644,146
Fund 600 - FLEET SERVICES FUND (244,277)
EXPENSE TOTALS 3,644,146
Fund 600 - FLEET SERVICES FUND
REVENUE TOTALS 3,399,869
Debt Service
Miscellaneous
Interfund Transfers
Insurance and Other Chargebacks 26,762
Depreciation Expense
Contingencies 450
EXPENSE
Salary and Benefits 1,236,877
Services and Supplies 2,380,057
Capital Outlay
Other Revenue 81,781
Interest Income 1,000
REVENUE TOTALS 3,399,869
REVENUE
Charges for Services 3,317,088
Interfund Transfers
Intergovernmental Revenue
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 600 - FLEET SERVICES FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 36 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
120,952 120,952 1,451,422
85,036
120,952 120,952 1,536,458
52,472
1,768,343
1,820,815
120,952 120,952 1,536,458
418 418 1,820,815
120,534 120,534 (284,357)
Starting Fund Balance 1,899,429 1,899,429
Net Change 146,216 120,534
Ending Fund Balance 2,045,645 2,019,963
Fund 601 - EQUIPMENT REPLACEMENT 146,216
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,661,638
EXPENSE TOTALS 1,515,422
Depreciation Expense
Miscellaneous
EXPENSE TOTALS 1,515,422
REVENUE TOTALS 1,661,638
EXPENSE
Services and Supplies 60,000
Capital Outlay 1,455,422
REVENUE
Charges for Services 1,451,421
Interfund Transfers
Other Revenue 210,217
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 601 - EQUIPMENT REPLACEMENT FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 37 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
1,055,276 1,055,276 162,411
50,137 50,137
781,006 781,006 10,182,110
10,052 10,052 1,034,405
236,190 236,190 5,304,769
11 11 136
2,132,673 2,132,673 16,683,830
35,016 35,016 483,455
52,131 52,131 2,214,473
1,158,002 1,158,002 14,663,593
(105,000)
10,811 10,811
1,255,960 1,255,960 17,256,521
2,132,673 2,132,673 16,683,830
1,255,960 1,255,960 17,256,521
876,713 876,713 (572,691)
Starting Fund Balance (3,954,618)(3,954,618)
Net Change 565,405 876,713
Ending Fund Balance (3,389,213)(3,077,905)
Fund 605 - INSURANCE FUND Totals 565,405
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 17,758,038
EXPENSE TOTALS 17,192,633
Miscellaneous
Interfund Transfers
EXPENSE TOTALS 17,192,633
Depreciation Expense
Contingencies
Debt Service
Capital Outlay
Insurance and Other Chargebacks 15,328,062
Community Sponsored Organizations
REVENUE TOTALS 17,758,038
EXPENSE
Salary and Benefits 479,323
Services and Supplies 1,385,248
Workers Compensation and Liability 1,023,094
Insurance 6,459,839
Interest Income 1,000
REVENUE
Charges for Services 162,411
Interfund Transfers
Other Revenue 10,111,694
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 605 - INSURANCE FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 38 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
15,298 15,298 6,097,482
50,995 50,995 280,000
63,725 63,725 1,007,337
4 4 1,198,791
130,022 130,022 8,583,610
696,728 696,728 8,296,220
696,728 696,728 8,296,220
130,022 130,022 8,583,610
696,728 696,728 8,296,220
(566,705)(566,705)287,390Fund 700 - FIRE PENSION FUND Totals 4,297,865
Fund 700 - FIRE PENSION FUND Totals
REVENUE TOTALS 12,460,865
EXPENSE TOTALS 8,163,000
Debt Service
Miscellaneous
EXPENSE TOTALS 8,163,000
EXPENSE
Salary and Benefits 8,163,000
Services and Supplies
Community Sponsored Organizations
Other Revenue 1,010,000
Interest Income 4,100,000
REVENUE TOTALS 12,460,865
REVENUE
Property Taxes 7,070,865
Other Taxes 280,000
Interfund Transfers
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 700 - FIRE PENSION FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 39 of 42
Jan-16 YTD 2015
Transactions Transactions Actual
21,398 21,398 8,421,427
50,995 50,995 325,000
93,714 93,714 1,454,770
5 5 2,925,526
166,113 166,113 13,126,723
913,664 913,664 10,762,296
913,664 913,664 10,762,296
166,113 166,113 13,126,723
913,664 913,664 10,762,296
(747,550)(747,550)2,364,427
REVENUE TOTALS 17,430,940
EXPENSE TOTALS 11,047,000
Fund 705 - POLICE PENSION FUND 6,383,940
Miscellaneous
EXPENSE TOTALS 11,047,000
Fund 705 - POLICE PENSION FUND
EXPENSE
Salary and Benefits 11,047,000
Services and Supplies
Debt Service
Other Revenue 1,550,000
Interest Income 6,500,000
REVENUE TOTALS 17,430,940
REVENUE
Property Taxes 9,055,940
Other Taxes 325,000
Interfund Transfers
Budget by Organization
Report
Through 01/31/16
Prior Fiscal Year Activity Included
2016
Classification Budget
Fund 705 - POLICE PENSION FUND
Run by Ashley King on 03/09/2016 10:12:21 AM Page 40 of 42