Financial Reports



GIS Consortium
FY2023 (01/01/2023-12/31/2023) Financial Report
Fund 8850

This table contains the CCGISC revenue report.
REVENUEBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
06/30/2023
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$329,127.00$329,127.00$94,188.0029%$234,939.00
City of Champaign$81,049.00$81,049.00$0.000%$81,049.00
City of Urbana$40,432.00$40,432.00$0.000%$40,432.00
Douglas County$35,000.00$35,000.00$0.000%$35,000.00
Piatt County$40,000.00$40,000.00$0.000%$40,000.00
U-C Sanitary District$1,157.00$1,157.00$0.000%$1,157.00
University of Illinois$38,999.00$38,999.00$0.000%$38,999.00
Village of Mahomet$19,134.00$19,134.00$3,688.5019%$15,445.50
Village of Rantoul$26,267.00$26,267.00$6,273.6424%$19,993.36
Village of Savoy$19,155.00$19,155.00$2,956.0015%$16,199.00
Village of St Joseph$0.00$0.00$0.000%$0.00
Local Government Total$630,320.00$630,320.00$107,106.1417%$523,213.86
 
Local Government Reimbursement$22,866.00$22,866.00$6,077.0027%$16,789.00
Charges for Services$60,500.00$60,500.00$25,911.9143%$34,588.09
Investment Interest$500.00$500.00$5,062.791013%- $4,562.79
Maps & Data Sales$13,000.00$13,000.00$2,710.0021%$10,290.00
Miscellaneous Revenue$0.00$0.00$0.000%$0.00
Interfund Transfers$58,500.00$58,500.00$0.000%$58,500.00
REVENUE TOTAL$785,686.00$785,686.00$146,867.8419%$638,818.16

This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
06/30/2023
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$412,332.00$412,332.00$197,136.5248%$215,195.48
Fringe Benefits$124,425.00$124,425.00$44,062.1435%$80,362.86
Personnel Total$536,757.00$536,757.00$241,198.6645%$295,558.34
 
Commodities$4,700.00$7,700.00$3,873.5850%$3,826.42
 
Services
Audit$10,500.00$10,500.00$2,990.4028%$7,509.60
Professional Services$187,000.00$187,000.00$0.000%$187,000.00
Job Required Travel$500.00$500.00$209.0842%$290.92
Utilities$2,250.00$2,250.00$0.000%$2,250.00
Computer/InfoTech Services$8,500.00$8,500.00$71.161%$8,428.84
Telephone Service$1,000.00$1,000.00$461.2646%$538.74
Equipment Maintenance$63,375.00$61,190.00$39,862.3165%$21,327.69
Conferences & Training$2,500.00$2,685.00$2,685.00100%$0.00
All Other Services$9,800.00$9,800.00$825.998%$8,974.01
Services Total$285,425.00$283,425.00$47,105.2017%$236,319.80
 
Capital$10,000.00$9,000.00$0.000%$9,000.00
Transfer to County Fund$3,000.00$3,000.00$0.000%$3,000.00
Interdepartment Transfers$58,500.00$58,500.00$0.000%$58,500.00
EXPENDITURE TOTAL$898,382.00$898,382.00$292,177.4433%$606,204.56

This table contains the CCGISC 850 fund balance report.
850 FUND BALANCE   -   01/01/2023 
 
Balance
FY2023 Beginning Fund Balance (unaudited)$646,583.12
Reserve for Aerial Photography- $96,389.06
10% Restricted Reserve- $89,778.26
Restricted Capital and Technology Reserve- $75,933.49
FY2023 Remaining Unreserved Fund Balance (unaudited)$384,482.31