Financial Reports



GIS Consortium
FY2022 (01/01/2022-12/31/2022) Financial Report
Fund 8850

This table contains the CCGISC revenue report.
REVENUEBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
12/31/2022
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$321,486.00$321,486.00$245,083.2576%$76,402.75
City of Champaign$75,186.00$85,200.00$158,720.05186%- $73,520.05
City of Urbana$42,765.00$45,019.00$45,017.61100%$1.39
Douglas County$0.00$0.00$0.000%$0.00
Piatt County$0.00$0.00$0.000%$0.00
U-C Sanitary District$1,157.00$1,157.00$1,156.25100%$0.75
University of Illinois$38,151.00$40,220.00$2,068.815%$38,151.19
Village of Mahomet$18,100.00$18,100.00$16,474.8391%$1,625.17
Village of Rantoul$26,651.00$26,651.00$23,753.7089%$2,897.30
Village of Savoy$18,787.00$19,598.00$18,744.3796%$853.63
Local Government Total$542,283.00$557,431.00$511,018.8792%$46,412.13
 
Local Government Reimbursement$23,008.00$23,008.00$22,866.0099%$142.00
Charges for Services$55,000.00$55,000.00$62,538.42114%- $7,538.42
Investment Interest$500.00$500.00$6,914.761383%- $6,414.76
Maps & Data Sales$12,500.00$12,500.00$8,500.1468%$3,999.86
Miscellaneous Revenue$0.00$0.00$0.000%$0.00
Interfund Transfers$57,500.00$57,500.00$0.000%$57,500.00
REVENUE TOTAL$690,791.00$705,939.00$611,838.1987%$94,100.81

This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
12/31/2022
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$395,343.00$396,954.30$389,142.8898%$7,811.42
Fringe Benefits$131,952.00$130,340.70$100,631.8677%$29,708.84
Personnel Total$527,295.00$527,295.00$489,774.7493%$37,520.26
 
Commodities$24,050.00$23,850.00$9,708.7541%$14,141.25
 
Services
Audit$10,500.00$12,290.00$7,565.0062%$4,725.00
Professional Services$2,000.00$29,900.00$27,900.0093%$2,000.00
Job Required Travel$500.00$500.00$125.6325%$374.37
Utilities$2,250.00$2,900.00$2,383.8282%$516.18
Computer/InfoTech Services$26,250.00$16,250.00$0.000%$16,250.00
Telephone Service$1,000.00$1,000.00$807.4381%$192.57
Equipment Maintenance$47,125.00$57,125.00$53,293.5993%$3,831.41
Conferences & Training$3,000.00$2,550.00$375.0015%$2,175.00
All Other Services$10,000.00$14,975.00$12,102.0681%$2,872.94
Services Total$102,625.00$137,490.00$104,552.5376%$32,937.47
 
Capital$0.00$0.00$0.000%$0.00
Transfer to County Fund$3,250.00$3,250.00$0.000%$3,250.00
Interdepartment Transfers$57,500.00$57,500.00$0.000%$57,500.00
EXPENDITURE TOTAL$714,720.00$749,385.00$604,036.0281%$145,348.98

This table contains the CCGISC 850 fund balance report.
850 FUND BALANCE   -   01/01/2022 
 
Balance
FY2022 Beginning Fund Balance (unaudited)$532,881.81
Reserve for Aerial Photography- $58,765.31
10% Restricted Reserve- $60,782.75
Restricted Capital and Technology Reserve- $94,073.61
FY2022 Remaining Unreserved Fund Balance (unaudited)$319,260.14