Financial Reports

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

This table contains the CCGISC revenue report.
REVENUEBudgetedActual YTD
06/30/2021
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$324,982.00$95,843.4829.49%$229,138.52
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$0.000.00%$1,157.00
Village of Mahomet$18,069.00$4,478.3124.78%$13,590.69
Village of Rantoul$26,938.00$9,329.4034.63%$17,608.60
Village of Savoy$19,261.00$0.000.00%$19,261.00
Local Government Total$557,390.00$109,651.1919.67%$447,738.81
 
Local Government Reimbursement$23,008.00$11,290.0049.07%$11,718.00
Charges for Services$54,000.00$22,569.5341.80%$31,430.47
Investment Interest$5,500.00$66.181.20%$5,433.82
Maps & Data Sales$13,500.00$4,978.0036.87%$8,522.00
Interdepartment Transfers$57,000.00$57,000.00100.00%$0.00
REVENUE TOTAL$710,398.00$205,554.9028.94%$504,843.10

This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
06/30/2021
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$362,804.00$367,804.00$163,506.8144.45%$204,297.19
Fringe Benefits$122,037.00$117,037.00$39,386.7633.65%$77,650.24
Personnel Total$484,841.00$484,841.00$202,893.5741.85%$281,947.43
 
Commodities$15,050.00$15,050.00$2,355.3015.65%$12,694.70
 
Services
Audit$11,500.00$11,500.00$4,000.0034.78%$7,500.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$402.4417.89%$1,847.56
Computer/InfoTech Services$23,000.00$23,000.00$8,635.4937.55%$14,364.51
Telephone Service$1,000.00$1,000.00$274.7927.48%$725.21
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$586.686.52%$8,413.32
Services Total$97,875.00$127,775.00$58,274.7545.61%$69,500.25
 
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$321,721.6246.45%$370,944.38

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