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
08/31/2022
Actual %
of Budget
Unrealized
Balance
Budgeted Local Government
Champaign County$321,486.00$321,486.00$92,277.7529%$229,208.25
City of Champaign$75,186.00$75,186.00$84,691.30113%- $9,505.30
City of Urbana$42,765.00$42,765.00$2,253.615%$40,511.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$38,151.00$2,068.815%$36,082.19
Village of Mahomet$18,100.00$18,100.00$1,749.5810%$16,350.42
Village of Rantoul$26,651.00$26,651.00$23,753.7089%$2,897.30
Village of Savoy$18,787.00$18,787.00$2,707.8714%$16,079.13
Local Government Total$542,283.00$542,283.00$210,658.8739%$331,624.13
 
Local Government Reimbursement$23,008.00$23,008.00$22,866.0099%$142.00
Charges for Services$55,000.00$55,000.00$33,019.3860%$21,980.62
Investment Interest$500.00$500.00$0.000%$500.00
Maps & Data Sales$12,500.00$12,500.00$3,533.0028%$8,967.00
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$690,791.00$270,077.2539%$420,713.75

This table contains the CCGISC expenditure report.
EXPENDITUREBudgeted
(Original)
Budgeted
(Amended)
Actual YTD
08/31/2022
Actual %
of Budget
Unencumbered
Balance
Personnel
Salaries & Wages$395,343.00$395,343.00$213,136.0854%$182,206.92
Fringe Benefits$131,952.00$131,952.00$58,819.9345%$73,132.07
Personnel Total$527,295.00$527,295.00$271,956.0152%$255,338.99
 
Commodities$24,050.00$24,050.00$4,698.6220%$19,351.38
 
Services
Audit$10,500.00$12,290.00$7,040.0057%$5,250.00
Professional Services$2,000.00$2,000.00$0.000%$2,000.00
Job Required Travel$500.00$500.00$0.000%$500.00
Utilities$2,250.00$2,250.00$1,560.6169%$689.39
Computer/InfoTech Services$26,250.00$16,250.00$0.000%$16,250.00
Telephone Service$1,000.00$1,000.00$500.7050%$499.30
Equipment Maintenance$47,125.00$57,125.00$53,859.6094%$3,265.40
Conferences & Training$3,000.00$3,000.00$0.000%$3,000.00
All Other Services$10,000.00$10,000.00$6,597.4066%$3,402.60
Services Total$102,625.00$104,415.00$69,558.3167%$34,856.69
 
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$716,510.00$346,212.9448%$370,297.06

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