Financial Reports

GIS Consortium
FY2021 (01/01/2021-12/31/2021) Financial Report
Fund 850

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
09/30/2021
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$324,982.00$170,382.7352.43%$154,599.27
City of Champaign$83,536.00$0.000.00%$83,536.00
City of Urbana$44,084.00$0.000.00%$44,084.00
University of Illinois$39,363.00$0.000.00%$39,363.00
Urbana Champaign Sanitary District$1,157.00$1,156.2599.94%$0.75
Village of Mahomet$18,069.00$4,478.3124.78%$13,590.69
Village of Rantoul$26,938.00$27,119.15100.67%- $181.15
Village of Savoy$19,261.00$15,700.5081.51%$3,560.50
Local Government Total$557,390.00$218,836.9439.26%$338,553.06
 
Local Government Reimbursement$23,008.00$19,972.0086.80%$3,036.00
Charges for Services$54,000.00$28,212.6152.25%$25,787.39
Investment Interest$5,500.00$105.041.91%$5,394.96
Maps & Data Sales$13,500.00$5,378.0039.84%$8,122.00
Interdepartment Transfers$57,000.00$57,000.00100.00%$0.00
REVENUE TOTAL$710,398.00$329,504.5946.38%$380,893.41

This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
09/30/2021
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$362,804.00$371,304.00$265,646.0771.54%$105,657.93
Fringe Benefits$122,037.00$113,537.00$61,065.9853.79%$52,471.02
Personnel Total$484,841.00$484,841.00$326,712.0567.39%$158,128.95
 
Commodities$15,050.00$15,050.00$4,994.7733.19%$10,055.23
 
Services
Audit$11,500.00$11,500.00$5,640.0049.04%$5,860.00
Professional Services$2,000.00$31,900.00$2,601.058.15%$29,298.95
Job Required Travel$500.00$500.00$0.000.00%$500.00
Utilities$2,250.00$2,250.00$728.7432.39%$1,521.26
Computer/InfoTech Services$23,000.00$23,000.00$8,635.4937.55%$14,364.51
Telephone Service$1,000.00$1,000.00$463.5246.35%$536.48
Equipment Maintenance$45,625.00$45,625.00$41,774.3091.56%$3,850.70
Conferences & Training$3,000.00$3,000.00$0.000.00%$3,000.00
All Other Services$9,000.00$9,000.00$904.8410.05%$8,095.16
Services Total$97,875.00$127,775.00$60,747.9447.54%$67,027.06
 
Transfer to General County Fund$10,000.00$8,000.00$1,198.0014.97%$6,802.00
Interdepartment Transfers$57,000.00$57,000.00$57,000.00100.00%$0.00
EXPENDITURE TOTAL$664,766.00$692,666.00$450,652.7665.06%$242,013.24

This table contains the CCGISC 850 fund balance report.
850 FUND BALANCE   -   01/01/2021 
 
Balance
FY2021 Beginning Fund Balance (unaudited)$534,470.01
Reserve for Aerial Photography- $32,889.06
10% Restricted Reserve- $60,252.40
Restricted Capital and Technology Reserve- $61,458.98
FY2021 Remaining Unreserved Fund Balance (unaudited)$379,869.57