Financial Reports

GIS Consortium
FY2018 (01/01/2018-12/31/2018) Financial Report
Fund 850

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
06/30/2018
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$296,628.00$86,930.2529.31%$209,697.75
City of Champaign$69,383.00$1,156.251.67%$68,226.75
City of Urbana$39,506.00$1,156.252.93%$38,349.75
University of Illinois$35,159.00$0.000.00%$35,159.00
Village of Mahomet$14,588.00$1,560.0210.69%$13,027.98
Village of Rantoul$24,773.00$24,393.1998.47%$379.81
Village of Savoy$13,952.00$1,156.258.29%$12,795.75
Local Government Total$493,989.00$116,352.2123.55%$377,636.79
 
Local Government Reimbursement$15,700.00$5,300.0033.76%$10,400.00
Charges for Services$57,000.00$18,613.7332.66%$38,386.27
Investment Interest$750.00$1,365.62182.08%- $615.62
Maps & Data Sales$13,500.00$6,653.5649.29%$6,846.44
Interdepartment Transfers$84,500.00$0.000.00%$84,500.00
REVENUE TOTAL$665,439.00$148,285.1222.28%$517,153.88


This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
06/30/2018
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$328,295.00$328,295.00$152,527.9546.46%$175,767.05
Fringe Benefits$118,755.00$118,755.00$43,435.8736.58%$75,319.13
Personnel Total$447,050.00$447,050.00$195,963.8243.83%$251,086.18
 
Commodities$20,275.00$20,275.00$9,633.8447.52%$10,641.16
 
Services
Audit$11,200.00$11,200.00$6,000.0053.57%$5,200.00
Professional Services$1,750.00$1,750.00$0.000.00%$1,750.00
Job Required Travel$500.00$500.00$343.0768.61%$156.93
Utilities$2,250.00$2,250.00$374.8416.66%$1,875.16
Computer/InfoTech Services$5,000.00$5,000.00$20.170.40%$4,979.83
Telephone Service$700.00$700.00$360.0251.43%$339.98
Equipment Maintenance$40,775.00$40,775.00$29,205.6671.63%$11,569.34
Conferences & Training$3,000.00$3,000.00$0.000.00%$3,000.00
All Other Services$8,210.00$8,210.00$289.733.53%$7,920.27
Services Total$73,385.00$73,385.00$36,593.4949.87%$36,791.51
 
Capital$28,975.00$28,975.00$0.000.00%$28,975.00
Transfer to General County Fund$4,500.00$4,500.00$0.000.00%$4,500.00
Interdepartment Transfers$84,500.00$84,500.00$0.000.00%$84,500.00
EXPENDITURE TOTAL$658,685.00$658,685.00$242,191.1536.77%$416,493.85


This table contains the CCGISC 850 fund balance report.
850 FUND BALANCE   -   01/01/2018 
 
Balance
FY2018 Beginning Fund Balance (unaudited)$367,304.64
Reserve for Aerial Photography- $31,196.04
10% Restricted Reserve- $52,690.70
FY2018 Remaining Unreserved Fund Balance (unaudited)$283,417.90