Financial Reports

GIS Consortium
FY2017 (01/01/2017-12/31/2017) Financial Report
Fund 850

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
12/31/2017
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$289,808.00$221,614.0076.47%$68,194.00
City of Champaign$67,861.00$67,861.00100.00%$0.00
City of Urbana$38,652.00$38,652.00100.00%$0.00
Piatt County$60,000.00$31,000.0051.67%$29,000.00
University of Illinois$34,375.00$34,375.25100.00%- $0.25
Village of Mahomet$14,303.00$14,303.39100.00%- $0.39
Village of Rantoul$24,393.00$24,023.1898.48%$369.82
Village of Savoy$13,667.00$13,667.50100.00%- $0.50
Local Government Total$543,059.00$445,496.3282.03%$97,562.68
 
Local Government Reimbursement$14,200.00$15,700.00110.56%- $1,500.00
Charges for Services$57,000.00$43,820.0976.88%$13,179.91
Investment Interest$200.00$1,928.68964.34%- $1,728.68
Maps & Data Sales$13,500.00$7,767.6257.54%$5,732.38
Interdepartment Transfers$58,000.00$58,000.00100.00%$0.00
REVENUE TOTAL$685,959.00$572,712.7183.49%$113,246.29


This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
12/31/2017
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$317,982.00$317,982.00$308,214.6096.93%$9,767.40
Fringe Benefits$113,973.00$113,973.00$91,565.1580.34%$22,407.85
Personnel Total$431,955.00$431,955.00$399,779.7592.55%$32,175.25
 
Commodities$16,850.00$17,611.00$12,162.9469.06%$5,448.06
 
Services
Audit$11,200.00$11,200.00$7,200.0064.29%$4,000.00
Professional Services$154,000.00$154,000.00$107,045.0069.51%$46,955.00
Job Required Travel$750.00$750.00$228.0030.40%$522.00
Utilities$2,250.00$2,250.00$1,162.7851.68%$1,087.22
Computer/InfoTech Services$5,000.00$5,000.00$20.170.40%$4,979.83
Telephone Service$500.00$815.00$770.5694.55%$44.44
Equipment Maintenance$37,625.00$37,625.00$37,551.8899.81%$73.12
Conferences & Training$3,000.00$3,000.00$129.524.32%$2,870.48
All Other Services$4,160.00$4,160.00$1,435.8034.51%$2,724.20
Services Total$218,485.00$218,800.00$155,543.7171.09%$63,256.29
 
Capital$10,625.00$10,625.00$0.000.00%$10,625.00
Transfer to General County Fund$10,000.00$8,924.00$1,394.4715.63%$7,529.53
Interdepartment Transfers$58,500.00$58,500.00$58,000.0099.15%$500.00
EXPENDITURE TOTAL$746,415.00$746,415.00$626,880.8783.99%$119,534.13


This table contains the CCGISC 850 fund balance report.
850 FUND BALANCE   -   01/01/2017 
 
Balance
FY2017 Beginning Fund Balance (unaudited)$381,469.12
Reserve for Aerial Photography- $77,780.46
10% Restricted Reserve- $51,126.33
FY2017 Remaining Unreserved Fund Balance (unaudited)$252,562.33