Financial Reports

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

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
12/31/2018
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$296,628.00$226,728.2576.44%$69,899.75
City of Champaign$69,383.00$69,382.00100.00%$1.00
City of Urbana$39,506.00$39,506.00100.00%$0.00
University of Illinois$35,159.00$35,159.25100.00%- $0.25
Village of Mahomet$14,588.00$14,341.2798.31%$246.73
Village of Rantoul$24,773.00$24,393.1998.47%$379.81
Village of Savoy$13,952.00$13,952.50100.00%- $0.50
Local Government Total$493,989.00$423,462.4685.72%$70,526.54
 
Local Government Reimbursement$15,700.00$15,700.00100.00%$0.00
Charges for Services$57,000.00$41,780.4373.30%$15,219.57
Investment Interest$750.00$4,199.22559.90%- $3,449.22
Maps & Data Sales$13,500.00$14,188.10105.10%- $688.10
Miscellaneous Revenue$0.00$800.000.00%- $800.00
Interdepartment Transfers$84,500.00$84,500.00100.00%$0.00
REVENUE TOTAL$665,439.00$584,630.2187.86%$80,808.79


This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
12/31/2018
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$328,295.00$328,295.00$312,233.2595.11%$16,061.75
Fringe Benefits$118,755.00$118,755.00$88,293.9474.35%$30,461.06
Personnel Total$447,050.00$447,050.00$400,527.1989.59%$46,522.81
 
Commodities$20,275.00$33,115.00$16,582.0250.07%$8,258.18
 
Services
Audit$11,200.00$11,200.00$7,340.0065.54%$3,860.00
Professional Services$1,750.00$1,750.00$0.000.00%$1,750.00
Job Required Travel$500.00$600.00$498.2883.05%$101.72
Utilities$2,250.00$2,250.00$1,213.1753.92%$1,036.83
Computer/InfoTech Services$5,000.00$5,000.00$20.170.40%$4,979.83
Telephone Service$700.00$700.00$717.76102.54%- $17.76
Equipment Maintenance$40,775.00$40,815.00$38,747.4894.93%$2,067.52
Conferences & Training$3,000.00$3,000.00$564.5918.82%$2,435.41
All Other Services$8,210.00$8,210.00$693.478.45%$7,516.53
Services Total$73,385.00$73,525.00$49,794.9267.73%$23,730.08
 
Capital$28,975.00$17,900.00$0.000.00%$17,900.00
Transfer to General County Fund$4,500.00$2,595.00$0.000.00%$2,595.00
Interdepartment Transfers$84,500.00$84,500.00$84,500.00100.00%$0.00
EXPENDITURE TOTAL$658,685.00$658,685.00$551,404.1383.71%$99,006.07


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