SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
REVENUES
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 31000 TOT .00 .00 .00 .00
01-31002-0000 Adjudication fees 25.00 1780.41 .00 3300.00 1519.59 53.95 1780.41
** TOTAL REVENUE 25.00 1780.41 .00 3300.00 1519.59 53.95 1780.41
DEPARTMENT 31002 TOT 25.00 1780.41 .00 3300.00
01-31003-0000 SCAVENGER .00 15.00 .00 .00 15.00- .00 15.00
** TOTAL REVENUE .00 15.00 .00 .00 15.00- .00 15.00
DEPARTMENT 31003 TOT .00 15.00 .00 .00
01-31005-0000 POLICE FINES/OVERWIEGHTS 500.00 7881.91 .00 10000.00 2118.09 78.82 7881.91
** TOTAL REVENUE 500.00 7881.91 .00 10000.00 2118.09 78.82 7881.91
DEPARTMENT 31005 TOT 500.00 7881.91 .00 10000.00
01-31008-0000 POLICE REPORTS 5.00 35.00 .00 50.00 15.00 70.00 35.00
** TOTAL REVENUE 5.00 35.00 .00 50.00 15.00 70.00 35.00
DEPARTMENT 31008 TOT 5.00 35.00 .00 50.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 2
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-31009-0000 LIQUOR LICENSE .00 2750.00 .00 3000.00 250.00 91.67 2750.00
** TOTAL REVENUE .00 2750.00 .00 3000.00 250.00 91.67 2750.00
DEPARTMENT 31009 TOT .00 2750.00 .00 3000.00
01-31010-0000 MISCELLANEOUS INCOME 25.00 10055.00 .00 350.00 9705.00- 2872.86 10055.00
** TOTAL REVENUE 25.00 10055.00 .00 350.00 9705.00- 2872.86 10055.00
DEPARTMENT 31010 TOT 25.00 10055.00 .00 350.00
01-31011-0000 BUILDING PERMITS 125.00 63910.00 .00 66000.00 2090.00 96.83 63910.00
** TOTAL REVENUE 125.00 63910.00 .00 66000.00 2090.00 96.83 63910.00
DEPARTMENT 31011 TOT 125.00 63910.00 .00 66000.00
01-31012-0000 STATE USE TAX 3903.29 50524.80 .00 50850.00 325.20 99.36 50524.80
** TOTAL REVENUE 3903.29 50524.80 .00 50850.00 325.20 99.36 50524.80
DEPARTMENT 31012 TOT 3903.29 50524.80 .00 50850.00
01-31014-0000 MACHINE LICENSE .00 250.00 .00 350.00 100.00 71.43 250.00
** TOTAL REVENUE .00 250.00 .00 350.00 100.00 71.43 250.00
DEPARTMENT 31014 TOT .00 250.00 .00 350.00
01-31016-0000 PEDDLERS PERMIT .00 .00 .00 100.00 100.00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 3
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
** TOTAL REVENUE .00 .00 .00 100.00 100.00 .00 .00
DEPARTMENT 31016 TOT .00 .00 .00 100.00
01-31018-0000 REPLACEMENT TAX 6357.07 30440.12 .00 13000.00 17440.12- 234.15 30440.12
** TOTAL REVENUE 6357.07 30440.12 .00 13000.00 17440.12- 234.15 30440.12
DEPARTMENT 31018 TOT 6357.07 30440.12 .00 13000.00
01-31019-0000 REAL ESTATE TAX .00 262868.84 .00 275000.00 12131.16 95.59 262868.84
** TOTAL REVENUE .00 262868.84 .00 275000.00 12131.16 95.59 262868.84
DEPARTMENT 31019 TOT .00 262868.84 .00 275000.00
01-31021-0000 SALES TAX 14196.22 152440.86 .00 145000.00 7440.86- 105.13 152440.86
** TOTAL REVENUE 14196.22 152440.86 .00 145000.00 7440.86- 105.13 152440.86
DEPARTMENT 31021 TOT 14196.22 152440.86 .00 145000.00
01-31022-0000 AMERITECH UTILITY TAX 1538.65 19916.67 .00 23000.00 3083.33 86.59 19916.67
** TOTAL REVENUE 1538.65 19916.67 .00 23000.00 3083.33 86.59 19916.67
DEPARTMENT 31022 TOT 1538.65 19916.67 .00 23000.00
01-31023-0000 NICOR UTILITY TAX 4145.57 30805.06 .00 15000.00 15805.06- 205.37 30805.06
** TOTAL REVENUE 4145.57 30805.06 .00 15000.00 15805.06- 205.37 30805.06
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 4
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
DEPARTMENT 31023 TOT 4145.57 30805.06 .00 15000.00
01-31024-0000 COMED UTILITY TAX 6517.27 85270.23 .00 70000.00 15270.23- 121.81 85270.23
** TOTAL REVENUE 6517.27 85270.23 .00 70000.00 15270.23- 121.81 85270.23
DEPARTMENT 31024 TOT 6517.27 85270.23 .00 70000.00
01-31025-0000 INCOME TAX 20357.19 189319.72 .00 145000.00 44319.72- 130.57 189319.72
** TOTAL REVENUE 20357.19 189319.72 .00 145000.00 44319.72- 130.57 189319.72
DEPARTMENT 31025 TOT 20357.19 189319.72 .00 145000.00
01-31026-0000 DONATIONS .00 1000.00 .00 50.00 950.00- 2000.00 1000.00
** TOTAL REVENUE .00 1000.00 .00 50.00 950.00- 2000.00 1000.00
DEPARTMENT 31026 TOT .00 1000.00 .00 50.00
01-31027-0000 GRANTS .00 .00 .00 2000.00 2000.00 .00 .00
** TOTAL REVENUE .00 .00 .00 2000.00 2000.00 .00 .00
DEPARTMENT 31027 TOT .00 .00 .00 2000.00
01-31029-0000 TRANSPORTATION MAINT. OF .00 2363.92 .00 4000.00 1636.08 59.10 2363.92
** TOTAL REVENUE .00 2363.92 .00 4000.00 1636.08 59.10 2363.92
DEPARTMENT 31029 TOT .00 2363.92 .00 4000.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 5
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-31030-0000 ELECTRONIC GAMBLING MACHI 769.64 11614.19 .00 8000.00 3614.19- 145.18 11614.19
** TOTAL REVENUE 769.64 11614.19 .00 8000.00 3614.19- 145.18 11614.19
DEPARTMENT 31030 TOT 769.64 11614.19 .00 8000.00
01-31031-0000 MEDICOM TAX /FRANCHISE FE .00 4731.76 .00 4200.00 531.76- 112.66 4731.76
** TOTAL REVENUE .00 4731.76 .00 4200.00 531.76- 112.66 4731.76
DEPARTMENT 31031 TOT .00 4731.76 .00 4200.00
01-31032-0000 police reimbursment .00 3497.25 .00 .00 3497.25- .00 3497.25
** TOTAL REVENUE .00 3497.25 .00 .00 3497.25- .00 3497.25
DEPARTMENT 31032 TOT .00 3497.25 .00 .00
01-31040-0000 CANNABIS USE TAX 199.27 2060.69 .00 700.00 1360.69- 294.38 2060.69
** TOTAL REVENUE 199.27 2060.69 .00 700.00 1360.69- 294.38 2060.69
DEPARTMENT 31040 TOT 199.27 2060.69 .00 700.00
01-31041-0000 AQUA WATER FRANCHISE FEE .00 29394.65 .00 16000.00 13394.65- 183.72 29394.65
** TOTAL REVENUE .00 29394.65 .00 16000.00 13394.65- 183.72 29394.65
DEPARTMENT 31041 TOT .00 29394.65 .00 16000.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 6
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-31043-0000 AQUA SEWER FRANCHISE FEE .00 .00 .00 12500.00 12500.00 .00 .00
** TOTAL REVENUE .00 .00 .00 12500.00 12500.00 .00 .00
DEPARTMENT 31043 TOT .00 .00 .00 12500.00
01-32600-0000 INTEREST INCOME 4.87 37.63 .00 300.00 262.37 12.54 37.63
** TOTAL REVENUE 4.87 37.63 .00 300.00 262.37 12.54 37.63
DEPARTMENT 32600 TOT 4.87 37.63 .00 300.00
01-34000-0000 COMMUNITY PARK RENTAL & D 2200.00 26350.00 .00 12000.00 14350.00- 219.58 26350.00
** TOTAL REVENUE 2200.00 26350.00 .00 12000.00 14350.00- 219.58 26350.00
DEPARTMENT 34000 TOT 2200.00 26350.00 .00 12000.00
01-38003-0000 OX CART 75.00 900.00 .00 500.00 400.00- 180.00 900.00
** TOTAL REVENUE 75.00 900.00 .00 500.00 400.00- 180.00 900.00
DEPARTMENT 38003 TOT 75.00 900.00 .00 500.00
01-38004-0000 GOLF CART LICENSE .00 700.00 .00 .00 700.00- .00 700.00
** TOTAL REVENUE .00 700.00 .00 .00 700.00- .00 700.00
DEPARTMENT 38004 TOT .00 700.00 .00 .00
** TOTAL REVENUE GENERAL FUND .00 .00 .00 .00 .00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 7
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 39999 TOT .00 .00 .00 .00
EXPENSES
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 40000 TOT .00 .00 .00 .00
01-41100-1000 MAYOR SALARY .00 6000.00 .00 6000.00 .00 100.00 6000.00
01-41100-1011 TRUSTEE SALARY .00 12000.00 .00 12000.00 .00 100.00 12000.00
01-41100-1100 EXPENSES 500.00 729.40 .00 2096.00 1366.60 34.80 729.40
01-41100-1500 DUES .00 .00 .00 250.00 250.00 .00 .00
01-41100-2000 VILLAGE SPONSORED EVENT/D .00 949.98 .00 1000.00 50.02 95.00 949.98
** TOTAL EXPENSES MAYOR 500.00 19679.38 .00 21346.00 1666.62 92.19 19679.38
** TOTAL EXPENSE 500.00 19679.38 .00 21346.00 1666.62 92.19 19679.38
DEPARTMENT 41100 TOT 500.00- 19679.38- .00 21346.00-
01-41200-1000 SALARY CLERK .00 3750.00 .00 3750.00 .00 100.00 3750.00
01-41200-1210 OFFICE SUPPLIES .00 4.68 .00 50.00 45.32 9.36 4.68
01-41200-1500 DUES .00 250.00 .00 250.00 .00 100.00 250.00
01-41200-1600 PUBLICATION FEES 218.24 551.54 .00 500.00 51.54- 110.31 551.54
01-41200-6000 ORDINANCE CODIFIER .00 500.00 .00 4000.00 3500.00 12.50 500.00
** TOTAL CLERK 218.24 5056.22 .00 8550.00 3493.78 59.14 5056.22
** TOTAL EXPENSE 218.24 5056.22 .00 8550.00 3493.78 59.14 5056.22
DEPARTMENT 41200 TOT 218.24- 5056.22- .00 8550.00-
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 8
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-41300-1000 SALARY TREASURER .00 3750.00 .00 3750.00 .00 100.00 3750.00
01-41300-1700 AUDIT .00 12625.00 .00 13000.00 375.00 97.12 12625.00
01-41300-2100 ACCOUNTING SERVICES (LOCI .00 1416.00 .00 750.00 666.00- 188.80 1416.00
** TOTAL TREASURER .00 17791.00 .00 17500.00 291.00- 101.66 17791.00
** TOTAL EXPENSE .00 17791.00 .00 17500.00 291.00- 101.66 17791.00
DEPARTMENT 41300 TOT .00 17791.00- .00 17500.00-
01-41400-1000 SALARY-VILLAGE HALL STAFF 2292.68 30170.84 .00 30348.00 177.16 99.42 30170.84
01-41400-1001 MAINT PAY .00 1783.20 .00 11330.00 9546.80 15.74 1783.20
01-41400-1012 PART TIME 129.00 2346.50 .00 4000.00 1653.50 58.66 2346.50
01-41400-1020 VACATION .00 495.06 .00 1200.00 704.94 41.26 495.06
01-41400-1021 SICK PAY .00 377.15 .00 1200.00 822.85 31.43 377.15
01-41400-1022 PTO 248.13 248.13 .00 .00 248.13- .00 248.13
01-41400-1030 Holiday Pay .00 1270.40 .00 1200.00 70.40- 105.87 1270.40
01-41400-1040 VILLAGE SHARE FICA 1874.51 28540.11 .00 28105.00 435.11- 101.55 28540.11
01-41400-1050 VILLAGE SHARE MEDICARE 438.39 6674.53 .00 6500.00 174.53- 102.69 6674.53
** MAINTENANCE PAY 4982.71 71905.92 .00 83883.00 11977.08 85.72 71905.92
01-41400-1200 SUPPLIES & MAINTENANCE 57.50 596.53 .00 1000.00 403.47 59.65 596.53
01-41400-1210 OFFICE SUPPLIES 316.49 856.06 .00 1200.00 343.94 71.34 856.06
01-41400-1211 POSTAGE .00 579.75 .00 300.00 279.75- 193.25 579.75
01-41400-1301 INSURANCE VILLAGE PORTION 436.00 5221.00 .00 6000.00 779.00 87.02 5221.00
01-41400-1302 HSA INSURANCE DEPOSIT .00 .00 .00 1000.00 1000.00 .00 .00
01-41400-1800 TELEPHONE 320.89 3814.67 .00 2450.00 1364.67- 155.70 3814.67
01-41400-1801 DUE INSPECTIONS Chris .00 7220.00 .00 4500.00 2720.00- 160.44 7220.00
01-41400-1830 INTERNET SERVICE @VILLAGE 301.90 2929.78 .00 750.00 2179.78- 390.64 2929.78
01-41400-1831 WEBSITE .00 96.00 .00 100.00 4.00 96.00 96.00
01-41400-1832 COMPUTER TECH/IT 165.00 7675.99 .00 1000.00 6675.99- 767.60 7675.99
01-41400-1900 UTILITIES 219.37 1296.64 .00 600.00 696.64- 216.11 1296.64
01-41400-2000 EQUIPMENT PURCHASED .00 998.96 .00 1500.00 501.04 66.60 998.96
01-41400-2001 E Waste Program .00 3700.00 .00 1850.00 1850.00- 200.00 3700.00
01-41400-2003 IMRF 124.76 1966.42 .00 2500.00 533.58 78.66 1966.42
01-41400-2004 Adjudication Officer .00 2400.00 .00 3600.00 1200.00 66.67 2400.00
01-41400-2005 Adjudication Secretary 75.00 750.00 .00 900.00 150.00 83.33 750.00
01-41400-2200 JULIE INC. .00 336.72 .00 250.00 86.72- 134.69 336.72
01-41400-2500 LOAN PAYABLE PRINCIPLE .00 14448.77 .00 .00 14448.77- .00 14448.77
01-41400-2506 REIMB/REAL ES TAX PER TIF .00 5846.17 .00 6800.00 953.83 85.97 5846.17
01-41400-2900 LEGAL FEES 242.60 18482.10 .00 37000.00 18517.90 49.95 18482.10
01-41400-3000 ENGINEERING .00 1211.54 .00 .00 1211.54- .00 1211.54
01-41400-3108 DUE LIBRARY FOR REPLACEME .00 3745.00 .00 .00 3745.00- .00 3745.00
01-41400-3400 Rail Road Land Lease 1104.08 2186.51 .00 1040.00 1146.51- 210.24 2186.51
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 9
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-41400-3500 COLLECTION COST .00 193.93 .00 200.00 6.07 96.97 193.93
01-41400-3700 REPAIRS ON BUILDINGS .00 14209.32 .00 5000.00 9209.32- 284.19 14209.32
01-41400-3900 MISCELLANEOUS .00 62.00 .00 .00 62.00- .00 62.00
01-41400-5800 INTEREST .00 21.53 .00 .00 21.53- .00 21.53
01-41400-6500 CIVIL DEFENSE 38.92 1913.99 .00 1200.00 713.99- 159.50 1913.99
** TOTAL PUBLIC PROPERTY 3402.51 102759.38 .00 80740.00 22019.38- 127.27 102759.38
** TOTAL EXPENSE 8385.22 174665.30 .00 164623.00 10042.30- 106.10 174665.30
DEPARTMENT 41400 TOT 8385.22- 174665.30- .00 164623.00-
01-41600-1000 CHIEF SALARY 5211.46 67673.09 .00 69385.00 1711.91 97.53 67673.09
01-41600-1010 OVERTIME 63.48 4597.53 .00 7200.00 2602.47 63.85 4597.53
01-41600-1011 FULL TIME SALARY 13878.40 175430.20 .00 179642.00 4211.80 97.66 175430.20
01-41600-1012 PART TIME 1370.30 21052.14 .00 21987.00 934.86 95.75 21052.14
01-41600-1020 VACATION .00 14847.10 .00 9800.00 5047.10- 151.50 14847.10
01-41600-1021 SICK PAY .00 16990.19 .00 1000.00 15990.19- 1699.02 16990.19
01-41600-1030 PERSONAL DAY .00 1685.64 .00 2400.00 714.36 70.24 1685.64
01-41600-1100 EXPENSES .00 845.22 .00 500.00 345.22- 169.04 845.22
01-41600-1200 SUPPLIES & MAINTENANCE 61.05 1845.91 .00 1200.00 645.91- 153.83 1845.91
01-41600-1210 OFFICE SUPPLIES 186.00 2287.48 .00 2500.00 212.52 91.50 2287.48
01-41600-1300 HEALTH INSURANCE STIPEND 850.00 14025.00 .00 15000.00 975.00 93.50 14025.00
01-41600-1301 INSURANCE VILLAGE SHARE 850.84 7096.44 .00 7000.00 96.44- 101.38 7096.44
01-41600-1700 RADAR CERTIFICATION 225.00 225.00 .00 300.00 75.00 75.00 225.00
01-41600-1701 SCALE CERTIFICATION .00 .00 .00 300.00 300.00 .00 .00
01-41600-1800 TELEPHONE OFFICE 310.35 3899.43 .00 3200.00 699.43- 121.86 3899.43
01-41600-1801 TELEPHONE CELL .00 897.35 .00 1500.00 602.65 59.82 897.35
01-41600-1802 AIRCARDS-VERIZON 182.22 2345.76 .00 1200.00 1145.76- 195.48 2345.76
01-41600-1830 INTERNET SERVICE 236.90 1228.62 .00 .00 1228.62- .00 1228.62
01-41600-1900 UTILITIES 370.88 2176.57 .00 800.00 1376.57- 272.07 2176.57
01-41600-2000 EQUIPMENT PURCHASED .00 3209.95 .00 2080.00 1129.95- 154.32 3209.95
01-41600-2001 POLICE PUBLIC RELATIONS .00 151.99 .00 .00 151.99- .00 151.99
01-41600-2002 DISPATCH FEES .00 5454.36 .00 6500.00 1045.64 83.91 5454.36
01-41600-2003 IMRF 982.17 17480.75 .00 9400.00 8080.75- 185.97 17480.75
01-41600-2100 TRAINING .00 2043.00 .00 3100.00 1057.00 65.90 2043.00
01-41600-2200 AMMUNITION .00 741.91 .00 1500.00 758.09 49.46 741.91
01-41600-2300 UNIFORMS FULL TIME 624.60 3130.39 .00 1500.00 1630.39- 208.69 3130.39
01-41600-2301 UNIFORMS PART TIME .00 1073.08 .00 1000.00 73.08- 107.31 1073.08
01-41600-2302 VEST PROG/FULL TIME .00 .00 .00 300.00 300.00 .00 .00
01-41600-2303 VEST PROG/PART TIME .00 .00 .00 300.00 300.00 .00 .00
01-41600-2400 GAS, OIL 976.82 17826.19 .00 12000.00 5826.19- 148.55 17826.19
01-41600-2500 AUTO REPAIRS 1302.06 3740.11 .00 4000.00 259.89 93.50 3740.11
01-41600-2510 AUTOMOBILE TIRES .00 629.56 .00 .00 629.56- .00 629.56
01-41600-2515 VEHICLE SET UP .00 1219.00 .00 1600.00 381.00 76.19 1219.00
01-41600-2520 VEHICLE LEASE .00 7404.92 .00 16000.00 8595.08 46.28 7404.92
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 10
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
01-41600-2600 EQUIPMENT REPAIRS .00 .00 .00 500.00 500.00 .00 .00
01-41600-2800 BOOKING FEES 40.00 200.00 .00 300.00 100.00 66.67 200.00
01-41600-2801 SHERIFFS CAD FEE .00 5197.20 .00 4331.00 866.20- 120.00 5197.20
01-41600-2900 ILEAS MEMBERSHIP DUES .00 110.00 .00 400.00 290.00 27.50 110.00
01-41600-3000 DRUG SCREENING .00 524.00 .00 250.00 274.00- 209.60 524.00
01-41600-3100 COMPUTER EQUIPMENT .00 .00 .00 750.00 750.00 .00 .00
01-41600-3101 Computer Tech Fees .00 7077.98 .00 500.00 6577.98- 1415.60 7077.98
01-41600-3900 MISCELLANEOUS .00 572.61 .00 .00 572.61- .00 572.61
01-41600-4000 ANIMAL CONTROL .00 670.00 .00 200.00 470.00- 335.00 670.00
** TOTAL POLICE 27722.53 417605.67 .00 391425.00 26180.67- 106.69 417605.67
** TOTAL EXPENSE 27722.53 417605.67 .00 391425.00 26180.67- 106.69 417605.67
DEPARTMENT 41600 TOT 27722.53- 417605.67- .00 391425.00-
01-41700-1100 EXPENSES .00 115.00 .00 .00 115.00- .00 115.00
01-41700-1120 LIABILITY & WORK COMP 7300.13 51100.65 .00 64522.00 13421.35 79.20 51100.65
01-41700-2801 DEDUCTIBLE .00 .00 .00 1000.00 1000.00 .00 .00
** TOTAL INSURANCE 7300.13 51215.65 .00 65522.00 14306.35 78.17 51215.65
** TOTAL EXPENSE 7300.13 51215.65 .00 65522.00 14306.35 78.17 51215.65
DEPARTMENT 41700 TOT 7300.13- 51215.65- .00 65522.00-
01-42200-1000 SALARY PARK .00 48.00 .00 1275.00 1227.00 3.76 48.00
01-42200-1200 SUPPLIES & MAINTENANCE .00 649.25 .00 3000.00 2350.75 21.64 649.25
01-42200-1900 UTILITIES 408.45 3789.28 .00 3000.00 789.28- 126.31 3789.28
01-42200-2000 PORTA POTTY .00 1190.00 .00 1190.00 .00 100.00 1190.00
01-42200-3700 REPAIRS .00 1173.95 .00 3000.00 1826.05 39.13 1173.95
01-42200-3800 PARK IMPROVEMENTS .00 .00 .00 2231.00 2231.00 .00 .00
01-42200-3900 PARK DEPOSIT REFUND 300.00 8425.00 .00 8500.00 75.00 99.12 8425.00
01-42200-5710 CLEANING FEES .00 .00 .00 450.00 450.00 .00 .00
** TOTAL PARK 708.45 15275.48 .00 22646.00 7370.52 67.45 15275.48
** TOTAL EXPENSE 708.45 15275.48 .00 22646.00 7370.52 67.45 15275.48
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 11
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
DEPARTMENT 42200 TOT 708.45- 15275.48- .00 22646.00-
01-42400-1000 SALARY-STREET COMMISSIONE 3230.76 29297.31 .00 37750.00 8452.69 77.61 29297.31
01-42400-1001 FULL TIME STREETS & ALLEY 2220.00 37257.35 .00 37886.00 628.65 98.34 37257.35
01-42400-1010 OVERTIME-STREET & ALLEY .00 1081.56 .00 1500.00 418.44 72.10 1081.56
01-42400-1012 PART TIME WAGES .00 7576.25 .00 4500.00 3076.25- 168.36 7576.25
01-42400-1020 VACATION .00 4094.44 .00 .00 4094.44- .00 4094.44
01-42400-1022 PTO 740.00 740.00 .00 .00 740.00- .00 740.00
01-42400-1200 SUPPLIES & MAINTENANCE 402.48 5653.67 .00 3500.00 2153.67- 161.53 5653.67
01-42400-1210 OFFICE SUPPLIES .00 432.85 .00 500.00 67.15 86.57 432.85
01-42400-1212 membership/subscriptions .00 313.00 .00 300.00 13.00- 104.33 313.00
01-42400-1301 INSURANCE VILLAGE SHARE 257.93 2932.43 .00 3300.00 367.57 88.86 2932.43
01-42400-1800 CELL PHONE .00 897.32 .00 1000.00 102.68 89.73 897.32
01-42400-1802 internet .00 .00 .00 1200.00 1200.00 .00 .00
01-42400-1900 UTILITIES 437.39 2381.20 .00 1200.00 1181.20- 198.43 2381.20
01-42400-2000 EQUIPMENT PURCHASED 28300.00 49042.67 .00 20000.00 29042.67- 245.21 49042.67
01-42400-2001 vehicle lease .00 7419.19 .00 8000.00 580.81 92.74 7419.19
01-42400-2003 IMRF 145.34 2962.87 .00 4000.00 1037.13 74.07 2962.87
01-42400-2010 EQUIPMENT RENTAL .00 425.00 .00 500.00 75.00 85.00 425.00
01-42400-2020 EQUIPMENT REPAIRS .00 419.37 .00 4571.00 4151.63 9.17 419.37
01-42400-2021 GENERAL REPAIRS .00 395.00 .00 5000.00 4605.00 7.90 395.00
01-42400-2022 Army Generators .00 .00 .00 250.00 250.00 .00 .00
01-42400-2025 OSHA COMPLIENCE COSTS .00 .00 .00 1000.00 1000.00 .00 .00
01-42400-2400 GAS, OIL 459.19 5770.28 .00 6000.00 229.72 96.17 5770.28
01-42400-3300 REMOVAL & REPLACE TREES .00 7900.00 .00 8000.00 100.00 98.75 7900.00
01-42400-3510 ENGINEERING .00 .00 .00 500.00 500.00 .00 .00
01-42400-3600 STREET LIGHTS 946.33 9922.92 .00 12500.00 2577.08 79.38 9922.92
01-42400-3700 REPAIRS .00 717.50 .00 1500.00 782.50 47.83 717.50
01-42400-3710 SIDEWALKS .00 750.00 .00 500.00 250.00- 150.00 750.00
01-42400-3711 ALLEY MAINTENANCE .00 .00 .00 500.00 500.00 .00 .00
01-42400-3712 PURCHASE TOOLS .00 210.71 .00 800.00 589.29 26.34 210.71
01-42400-3713 CURB PAINT .00 1501.29 .00 800.00 701.29- 187.66 1501.29
01-42400-3714 DRAINAGE/CULVERTS .00 520.00 .00 3000.00 2480.00 17.33 520.00
01-42400-3715 TIRES .00 .00 .00 1500.00 1500.00 .00 .00
01-42400-3718 Training .00 .00 .00 200.00 200.00 .00 .00
01-42400-3720 WEED CONTROl .00 234.69 .00 150.00 84.69- 156.46 234.69
01-42400-3721 BOLT BIN KITS .00 155.09 .00 500.00 344.91 31.02 155.09
01-42400-3723 SNOW PLOW/REPAIRS .00 .00 .00 2000.00 2000.00 .00 .00
01-42400-3724 LAKE METONGA .00 .00 .00 1000.00 1000.00 .00 .00
01-42400-4000 SPRAY PATCHING .00 .00 .00 3500.00 3500.00 .00 .00
01-42400-4700 BLACKTOPPING (NOT MFT FUN .00 .00 .00 3000.00 3000.00 .00 .00
01-42400-4701 SALT .00 .00 .00 1000.00 1000.00 .00 .00
01-42400-5000 SIGNS .00 898.00 .00 1000.00 102.00 89.80 898.00
01-42400-5001 YELLOWHEAD ROAD REPAIR .00 .00 .00 15000.00 15000.00 .00 .00
01-42400-5002 REIMBURSE W/REBUILD ILLIN .00 .00 .00 .00 .00 .00 .00
** TOTAL STREET AND ALLEY 37139.42 181901.96 .00 198907.00 17005.04 91.45 181901.96
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] CORPORATE B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 12
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
** TOTAL EXPENSE 37139.42 181901.96 .00 198907.00 17005.04 91.45 181901.96
DEPARTMENT 42400 TOT 37139.42- 181901.96- .00 198907.00-
** FUND 01 21029.95- 107723.05
EXPENSE TOTAL 81973.99 883190.66 .00 890519.00 7328.34 99.17
REVENUE TOTAL 60944.04 990913.71 .00 880250.00 110663.71- 112.57
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] SEWER FUND B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
REVENUES
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 31000 TOT .00 .00 .00 .00
03-31028-0000 FARM LAND CASH RENT 4532.80 9065.60 .00 9100.00 34.40 99.62 9065.60
** TOTAL REVENUE 4532.80 9065.60 .00 9100.00 34.40 99.62 9065.60
DEPARTMENT 31028 TOT 4532.80 9065.60 .00 9100.00
03-32100-0000 FEES .00 486.58- .00 .00 486.58 .00 486.58-
** TOTAL REVENUE .00 486.58- .00 .00 486.58 .00 486.58-
DEPARTMENT 32100 TOT .00 486.58- .00 .00
03-32600-0000 INTEREST 2.30 14.63 .00 150.00 135.37 9.75 14.63
** TOTAL REVENUE 2.30 14.63 .00 150.00 135.37 9.75 14.63
DEPARTMENT 32600 TOT 2.30 14.63 .00 150.00
EXPENSES
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 40000 TOT .00 .00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] SEWER FUND B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 2
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
03-41000-1500 REAL ESTATE TAXES .00 1666.14 .00 1850.00 183.86 90.06 1666.14
03-41000-3712 storm sewer maintence .00 .00 .00 3000.00 3000.00 .00 .00
** TOTAL EXPENSE .00 1666.14 .00 4850.00 3183.86 34.35 1666.14
DEPARTMENT 41000 TOT .00 1666.14- .00 4850.00-
** TOTAL EXPENSES WATER .00 .00 .00 .00 .00 .00 .00
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 49999 TOT .00 .00 .00 .00
** FUND 03 4535.10 6927.51
EXPENSE TOTAL .00 1666.14 .00 4850.00 3183.86 34.35
REVENUE TOTAL 4535.10 8593.65 .00 9250.00 656.35 92.90
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] MOTOR FUEL TAX B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
REVENUES
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 31000 TOT .00 .00 .00 .00
05-32600-0000 INTEREST 1.74 15.80 .00 15.00 .80- 105.33 15.80
** TOTAL REVENUE 1.74 15.80 .00 15.00 .80- 105.33 15.80
DEPARTMENT 32600 TOT 1.74 15.80 .00 15.00
05-39000-0000 MOTOR FUEL TAX 4430.82 52978.32 .00 40000.00 12978.32- 132.45 52978.32
** TOTAL REVENUE 4430.82 52978.32 .00 40000.00 12978.32- 132.45 52978.32
DEPARTMENT 39000 TOT 4430.82 52978.32 .00 40000.00
** TOTAL REVENUES .00 .00 .00 .00 .00 .00 .00
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 39999 TOT .00 .00 .00 .00
EXPENSES
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 40000 TOT .00 .00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] MOTOR FUEL TAX B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 2
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
05-41000-3000 ENGINEERING .00 .00 .00 30000.00 30000.00 .00 .00
05-41000-4700 STONE & SALT 650.00 6469.30 .00 4000.00 2469.30- 161.73 6469.30
05-41000-4710 STREET & ALLEY REPAIR .00 20203.68 .00 12000.00 8203.68- 168.36 20203.68
05-41000-4711 COLD PATCH .00 1218.92 .00 2000.00 781.08 60.95 1218.92
05-41000-4713 HOT PATCH .00 .00 .00 100.00 100.00 .00 .00
** TOTAL EXPENSE MFT 650.00 27891.90 .00 48100.00 20208.10 57.99 27891.90
** TOTAL EXPENSE 650.00 27891.90 .00 48100.00 20208.10 57.99 27891.90
DEPARTMENT 41000 TOT 650.00- 27891.90- .00 48100.00-
** FUND 05 3782.56 25102.22
EXPENSE TOTAL 650.00 27891.90 .00 48100.00 20208.10 57.98
REVENUE TOTAL 4432.56 52994.12 .00 40015.00 12979.12- 132.43
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
REVENUES
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 31000 TOT .00 .00 .00 .00
07-31001-0000 FEST SPONSOR .00 6735.00 .00 4500.00 2235.00- 149.67 6735.00
** TOTAL REVENUE .00 6735.00 .00 4500.00 2235.00- 149.67 6735.00
DEPARTMENT 31001 TOT .00 6735.00 .00 4500.00
07-31002-0000 DONATIONS .00 .00 .00 150.00 150.00 .00 .00
** TOTAL REVENUE .00 .00 .00 150.00 150.00 .00 .00
DEPARTMENT 31002 TOT .00 .00 .00 150.00
07-31003-0000 5K SPONSOR .00 .00 .00 550.00 550.00 .00 .00
** TOTAL REVENUE .00 .00 .00 550.00 550.00 .00 .00
DEPARTMENT 31003 TOT .00 .00 .00 550.00
07-31004-0000 CRAFT BOOTH .00 .00 .00 500.00 500.00 .00 .00
** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00
DEPARTMENT 31004 TOT .00 .00 .00 500.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 2
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
07-31005-0000 FOOD VENDER BOOTH .00 350.00 .00 800.00 450.00 43.75 350.00
** TOTAL REVENUE .00 350.00 .00 800.00 450.00 43.75 350.00
DEPARTMENT 31005 TOT .00 350.00 .00 800.00
07-31006-0000 5K REGISTRATION .00 .00 .00 500.00 500.00 .00 .00
** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00
DEPARTMENT 31006 TOT .00 .00 .00 500.00
07-31007-0000 CAR SHOW REGISTRATIONS .00 755.00 .00 500.00 255.00- 151.00 755.00
** TOTAL REVENUE .00 755.00 .00 500.00 255.00- 151.00 755.00
DEPARTMENT 31007 TOT .00 755.00 .00 500.00
07-31008-0000 RAFFLE/GUN .00 1315.00 .00 4200.00 2885.00 31.31 1315.00
** TOTAL REVENUE .00 1315.00 .00 4200.00 2885.00 31.31 1315.00
DEPARTMENT 31008 TOT .00 1315.00 .00 4200.00
07-31009-0000 BEVERAGE SALES .00 4566.00 .00 6000.00 1434.00 76.10 4566.00
** TOTAL REVENUE .00 4566.00 .00 6000.00 1434.00 76.10 4566.00
DEPARTMENT 31009 TOT .00 4566.00 .00 6000.00
07-31010-0000 KIDS GAMES .00 602.28 .00 450.00 152.28- 133.84 602.28
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 3
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
** TOTAL REVENUE .00 602.28 .00 450.00 152.28- 133.84 602.28
DEPARTMENT 31010 TOT .00 602.28 .00 450.00
07-31011-0000 BAND COVER .00 .00 .00 2000.00 2000.00 .00 .00
** TOTAL REVENUE .00 .00 .00 2000.00 2000.00 .00 .00
DEPARTMENT 31011 TOT .00 .00 .00 2000.00
07-31012-0000 TASTE .00 .00 .00 500.00 500.00 .00 .00
** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00
DEPARTMENT 31012 TOT .00 .00 .00 500.00
07-31013-0000 BINGO .00 504.34 .00 450.00 54.34- 112.08 504.34
** TOTAL REVENUE .00 504.34 .00 450.00 54.34- 112.08 504.34
DEPARTMENT 31013 TOT .00 504.34 .00 450.00
07-31014-0000 50/50 .00 520.00 .00 300.00 220.00- 173.33 520.00
** TOTAL REVENUE .00 520.00 .00 300.00 220.00- 173.33 520.00
DEPARTMENT 31014 TOT .00 520.00 .00 300.00
07-31016-0000 CHILI CONTEST/TASTE .00 .00 .00 200.00 200.00 .00 .00
** TOTAL REVENUE .00 .00 .00 200.00 200.00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 4
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
DEPARTMENT 31016 TOT .00 .00 .00 200.00
07-31019-0000 food sales .00 .00 .00 400.00 400.00 .00 .00
** TOTAL REVENUE .00 .00 .00 400.00 400.00 .00 .00
DEPARTMENT 31019 TOT .00 .00 .00 400.00
07-32001-0000 BEVERAGE SALES .00 .00 .00 500.00 500.00 .00 .00
** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00
DEPARTMENT 32001 TOT .00 .00 .00 500.00
07-32002-0000 FOOD SALES .00 .00 .00 1000.00 1000.00 .00 .00
** TOTAL REVENUE .00 .00 .00 1000.00 1000.00 .00 .00
DEPARTMENT 32002 TOT .00 .00 .00 1000.00
07-32003-0000 RAFFLE .00 .00 .00 700.00 700.00 .00 .00
** TOTAL REVENUE .00 .00 .00 700.00 700.00 .00 .00
DEPARTMENT 32003 TOT .00 .00 .00 700.00
07-32004-0000 50/50 .00 .00 .00 200.00 200.00 .00 .00
** TOTAL REVENUE .00 .00 .00 200.00 200.00 .00 .00
DEPARTMENT 32004 TOT .00 .00 .00 200.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 5
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
07-32005-0000 MISC DONATIONS/TIPS .00 .00 .00 100.00 100.00 .00 .00
** TOTAL REVENUE .00 .00 .00 100.00 100.00 .00 .00
DEPARTMENT 32005 TOT .00 .00 .00 100.00
07-32006-0000 mums .00 114.15- .00 .00 114.15 .00 114.15-
** TOTAL REVENUE .00 114.15- .00 .00 114.15 .00 114.15-
DEPARTMENT 32006 TOT .00 114.15- .00 .00
07-32008-0000 CFR BINGO .00 .00 .00 300.00 300.00 .00 .00
** TOTAL REVENUE .00 .00 .00 300.00 300.00 .00 .00
DEPARTMENT 32008 TOT .00 .00 .00 300.00
07-32009-0000 CFR COVER .00 .00 .00 80.00 80.00 .00 .00
** TOTAL REVENUE .00 .00 .00 80.00 80.00 .00 .00
DEPARTMENT 32009 TOT .00 .00 .00 80.00
07-32600-0000 INTEREST .56 4.04 .00 5.00 .96 80.80 4.04
** TOTAL REVENUE .56 4.04 .00 5.00 .96 80.80 4.04
DEPARTMENT 32600 TOT .56 4.04 .00 5.00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 6
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
** TOTAL REVENUES .00 .00 .00 .00 .00 .00 .00
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 39999 TOT .00 .00 .00 .00
EXPENSES
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 40000 TOT .00 .00 .00 .00
07-41000-1200 SUPPLIES & MAINTENANCE .00 75.30 .00 200.00 124.70 37.65 75.30
07-41000-1202 T SHIRT .00 225.00 .00 .00 225.00- .00 225.00
07-41000-1210 OFFICE SUPPLIES .00 .00 .00 50.00 50.00 .00 .00
07-41000-1211 POSTAGE .00 .00 .00 400.00 400.00 .00 .00
07-41000-1900 UTILITIES .00 .00 .00 250.00 250.00 .00 .00
07-41000-2000 EQUIPMENT PURCHASED .00 129.99 .00 .00 129.99- .00 129.99
07-41000-4000 RAFFLE PRIZES .00 1900.00 .00 1000.00 900.00- 190.00 1900.00
07-41000-4001 ALCOHOL .00 2318.28 .00 2700.00 381.72 85.86 2318.28
07-41000-4002 BAR SUPPLIES .00 .00 .00 50.00 50.00 .00 .00
07-41000-4003 LIQUOR LICENSE .00 25.00 .00 25.00 .00 100.00 25.00
07-41000-4004 SODA/ WATER .00 234.79 .00 175.00 59.79- 134.17 234.79
07-41000-4005 ICE .00 333.99 .00 150.00 183.99- 222.66 333.99
07-41000-4006 TASTE .00 .00 .00 250.00 250.00 .00 .00
07-41000-4007 DECORATIONS .00 59.48 .00 50.00 9.48- 118.96 59.48
07-41000-4008 BANDS/SOUND .00 2500.00 .00 2600.00 100.00 96.15 2500.00
07-41000-4009 CAR SHOW AWARDS .00 373.08 .00 300.00 73.08- 124.36 373.08
07-41000-4010 CAR SHOW PRINTING .00 149.74 .00 100.00 49.74- 149.74 149.74
07-41000-4011 BURN OUT CONTEST .00 175.00 .00 .00 175.00- .00 175.00
07-41000-4012 KIDS GAMES SUPPLIES .00 1505.68 .00 220.00 1285.68- 684.40 1505.68
07-41000-4013 5K .00 .00 .00 125.00 125.00 .00 .00
07-41000-4014 5K SHIRTS .00 .00 .00 400.00 400.00 .00 .00
07-41000-4015 5K PUBLICITY .00 .00 .00 85.00 85.00 .00 .00
07-41000-4016 NEWSPAPER ADS .00 .00 .00 550.00 550.00 .00 .00
07-41000-4017 UNIFORMS .00 254.17 .00 50.00 204.17- 508.34 254.17
07-41000-4018 FIREWORKS .00 3900.00 .00 5400.00 1500.00 72.22 3900.00
07-41000-4019 TENT .00 2860.00 .00 1600.00 1260.00- 178.75 2860.00
07-41000-4020 PORTA POTTY .00 1310.00 .00 850.00 460.00- 154.12 1310.00
07-41000-4021 CHILI COOK OFF .00 .00 .00 50.00 50.00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] FEST ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 7
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
07-41000-4022 BANNERS .00 80.84 .00 150.00 69.16 53.89 80.84
07-41000-4023 PARADE .00 40.97 .00 .00 40.97- .00 40.97
07-41000-4024 PROMOTIONAL PRODUCTS .00 .00 .00 50.00 50.00 .00 .00
07-41000-4025 FEST BUCKS .00 .00 .00 200.00 200.00 .00 .00
07-41000-4026 DONATIONS TO .00 228.29 .00 .00 228.29- .00 228.29
07-41000-4027 POLICE FEST COVERAGE .00 242.62 .00 1500.00 1257.38 16.17 242.62
07-41000-4028 KIDS GAME RENTAL .00 .00 .00 100.00 100.00 .00 .00
07-41000-4029 KIDS GAME ENTERTAINMENT .00 .00 .00 250.00 250.00 .00 .00
07-41000-4030 KIDS GAME PRIZES .00 146.21 .00 150.00 3.79 97.47 146.21
07-41000-4031 GAS/GENERATOR .00 20.21 .00 200.00 179.79 10.11 20.21
07-41000-4032 COMMITTEE PIZZA .00 123.67 .00 .00 123.67- .00 123.67
07-41000-4034 PRINTING/FLYERS/TIC .00 435.30 .00 500.00 64.70 87.06 435.30
07-41000-4035 CASH DRAW .00 1500.00 .00 1500.00 .00 100.00 1500.00
07-41000-4036 DUMPSTER .00 .00 .00 .00 .00 .00 .00
07-41000-4039 breakfast .00 .00 .00 150.00 150.00 .00 .00
07-41000-4040 CONTEST .00 93.95 .00 50.00 43.95- 187.90 93.95
07-41000-4043 PAYPAL FEES .00 .00 .00 25.00 25.00 .00 .00
07-41000-5001 LIQUOR .00 .00 .00 200.00 200.00 .00 .00
07-41000-5002 SODA/WATER .00 .00 .00 50.00 50.00 .00 .00
07-41000-5003 ICE .00 .00 .00 25.00 25.00 .00 .00
07-41000-5004 RAFFLE .00 .00 .00 50.00 50.00 .00 .00
07-41000-5006 SUPPLIES /DECOR .00 .00 .00 125.00 125.00 .00 .00
07-41000-5007 CASH DRAW .00 .00 .00 500.00 500.00 .00 .00
07-41000-5008 ENTERTAINMENT .00 .00 .00 500.00 500.00 .00 .00
07-41000-5009 POLICE EVENT COVERAGE .00 1495.74 .00 200.00 1295.74- 747.87 1495.74
07-41000-5010 FOOD .00 .00 .00 300.00 300.00 .00 .00
07-41000-5012 POSTAGE .00 .00 .00 50.00 50.00 .00 .00
07-41000-5013 LIQUOR LICENSE CFR .00 .00 .00 25.00 25.00 .00 .00
07-41000-5014 ADVERTISING .00 .00 .00 100.00 100.00 .00 .00
07-41000-6000 EASTER 540.73 540.73 .00 150.00 390.73- 360.49 540.73
07-41000-7000 HALLOWEEN .00 272.89- .00 50.00 322.89 545.78- 272.89-
07-41000-7001 CHRISTMAS .00 .00 .00 100.00 100.00 .00 .00
** TOTAL EXPENSE FEST 540.73 23005.14 .00 24880.00 1874.86 92.46 23005.14
** TOTAL EXPENSE 540.73 23005.14 .00 24880.00 1874.86 92.46 23005.14
DEPARTMENT 41000 TOT 540.73- 23005.14- .00 24880.00-
** FUND 07 540.17- 7767.63-
EXPENSE TOTAL 540.73 23005.14 .00 24880.00 1874.86 92.46
REVENUE TOTAL .56 15237.51 .00 24885.00 9647.49 61.23
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] REBUILD ILLINOIS FUND B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
REVENUES
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 31000 TOT .00 .00 .00 .00
08-39000-0000 REBUILD ILLINOIS TAX .00 29239.38 .00 30000.00 760.62 97.46 29239.38
** TOTAL REVENUE .00 29239.38 .00 30000.00 760.62 97.46 29239.38
DEPARTMENT 39000 TOT .00 29239.38 .00 30000.00
** TOTAL REVENUES .00 .00 .00 .00 .00 .00 .00
** TOTAL REVENUE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 39999 TOT .00 .00 .00 .00
EXPENSES
** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00
DEPARTMENT 40000 TOT .00 .00 .00 .00
08-41000-4710 STREET & ALLEY REPAIR .00 .00 .00 30000.00 30000.00 .00 .00
** TOTAL EXPENSE MFT .00 .00 .00 30000.00 30000.00 .00 .00
** TOTAL EXPENSE .00 .00 .00 30000.00 30000.00 .00 .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] REBUILD ILLINOIS FUND B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 2
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
DEPARTMENT 41000 TOT .00 .00 .00 30000.00-
** FUND 08 .00 29239.38
EXPENSE TOTAL .00 .00 .00 30000.00 30000.00 .00
REVENUE TOTAL .00 29239.38 .00 30000.00 760.62 97.46
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] ICS -Sewer Plant Sale ProceeB U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
09-32600-0000 INTEREST 240.31 3080.23 .00 3000.00 80.23- 102.67 3080.23
** TOTAL REVENUE 240.31 3080.23 .00 3000.00 80.23- 102.67 3080.23
DEPARTMENT 32600 TOT 240.31 3080.23 .00 3000.00
09-41000-1000 TRANSFER TO BALANCE 3000.00 188149.00 .00 .00 188149.00- .00 188149.00
** TOTAL EXPENSE 3000.00 188149.00 .00 .00 188149.00- .00 188149.00
DEPARTMENT 41000 TOT 3000.00- 188149.00- .00 .00
** FUND 09 2759.69- 185068.77-
EXPENSE TOTAL 3000.00 188149.00 .00 .00 188149.00- .00
REVENUE TOTAL 240.31 3080.23 .00 3000.00 80.23- 102.67
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] 250,000 sewer sale acct B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
10-31011-0000 2022 Maint. Truck Payment 20000.00 20000.00 .00 .00 20000.00- .00 20000.00
** TOTAL REVENUE 20000.00 20000.00 .00 .00 20000.00- .00 20000.00
DEPARTMENT 31011 TOT 20000.00 20000.00 .00 .00
10-41000-1000 TRANSFER TO BALANCE .00 11750.00- .00 .00 11750.00 .00 11750.00-
10-41000-3100 2022 Maint. Truck 38000.00- 50000.00- .00 .00 50000.00 .00 50000.00-
10-41000-3101 Maint. Skid Steer 35000.00 35000.00 .00 .00 35000.00- .00 35000.00
10-41000-4700 COMMUNITY & ECONOMIC DEVE .00 11750.00 .00 .00 11750.00- .00 11750.00
10-41000-4801 STREETS & ALLEYS EQUIPMEN 35000.00 35000.00 .00 .00 35000.00- .00 35000.00
** TOTAL EXPENSE 32000.00 20000.00 .00 .00 20000.00- .00 20000.00
DEPARTMENT 41000 TOT 32000.00- 20000.00- .00 .00
** FUND 10 12000.00- .00
EXPENSE TOTAL 32000.00 20000.00 .00 .00 20000.00- .00
REVENUE TOTAL 20000.00 20000.00 .00 .00 20000.00- .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] American Rescue Plan Act GraB U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
11-31000-0000 GRANT INCOME .00 84984.87 .00 .00 84984.87- .00 84984.87
** TOTAL REVENUE .00 84984.87 .00 .00 84984.87- .00 84984.87
DEPARTMENT 31000 TOT .00 84984.87 .00 .00
11-32600-0000 INTEREST 1.40 6.72 .00 .00 6.72- .00 6.72
** TOTAL REVENUE 1.40 6.72 .00 .00 6.72- .00 6.72
DEPARTMENT 32600 TOT 1.40 6.72 .00 .00
** FUND 11 1.40 84991.59
EXPENSE TOTAL .00 .00 .00 .00 .00 .00
REVENUE TOTAL 1.40 84991.59 .00 .00 84991.59- .00
SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:48
[GBC2] VILLAGE T.I.F. ACCOUNT B U D G E T C O M P A R I S O N A N A L Y S I S For Apr of 2022
DATE 07/11/22 Monday July 11, 2022 PAGE 1
G/L ACCT REVENUE / EXPENSE FISCAL UNENCUMB % ESTIMATED
NUMBER TITLE M-T-D Y-T-D ENCUMBERED BUDGET BALANCE USED ACTUALS
====================================================================================================================================
27-32600-0000 INTEREST 14.23 170.14 .00 150.00 20.14- 113.43 170.14
** TOTAL REVENUE 14.23 170.14 .00 150.00 20.14- 113.43 170.14
DEPARTMENT 32600 TOT 14.23 170.14 .00 150.00
27-38005-0000 TAX PAYMENT .00 306876.33 .00 350000.00 43123.67 87.68 306876.33
** TOTAL REVENUE .00 306876.33 .00 350000.00 43123.67 87.68 306876.33
DEPARTMENT 38005 TOT .00 306876.33 .00 350000.00
27-41000-1211 postage .00 .00 .00 25.00 25.00 .00 .00
27-41000-2900 PROFESSIONAL FEES 3931.94 3931.94 .00 6000.00 2068.06 65.53 3931.94
27-41000-3000 Engineering .00 82788.46 .00 25000.00 57788.46- 331.15 82788.46
27-41000-3001 ENG/DOWNTOWN STREETSCAPE 2655.00 13250.00 .00 .00 13250.00- .00 13250.00
27-41000-3002 ENG/SAFE RTE TO SCHOOL 1500.00 7500.00 .00 .00 7500.00- .00 7500.00
27-41000-3003 ENG/ MULTI USE PATH RTE 1 .00 1580.78 .00 .00 1580.78- .00 1580.78
27-41000-3004 ENG/SIGN 175.00 1175.00 .00 .00 1175.00- .00 1175.00
27-41000-4603 CONTRACT DISBURSMENT COUN .00 8571.42 .00 8600.00 28.58 99.67 8571.42
27-41000-4702 COMPREHENSIVE PLAN .00 .00 .00 5500.00 5500.00 .00 .00
27-41000-4706 LEGAL/ACCOUNTING .00 2036.00 .00 10000.00 7964.00 20.36 2036.00
27-41000-4707 DEVELOPMENT PROJECTS .00 102938.67 .00 150000.00 47061.33 68.63 102938.67
27-41000-4708 PROJECT MARKETING .00 .00 .00 1000.00 1000.00 .00 .00
27-41000-4710 SCHOOL REIMBURSEMENT .00 .00 .00 70500.00 70500.00 .00 .00
27-41000-4711 EMERGENCY REPAIRS .00 .00 .00 15000.00 15000.00 .00 .00
27-41000-4801 STREETS & ALLEYS EQUIPMEN .00 .00 .00 50000.00 50000.00 .00 .00
27-41000-4803 STREET REPAIR .00 .00 .00 55000.00 55000.00 .00 .00
** TOTAL EXPENSE 8261.94 223772.27 .00 396625.00 172852.73 56.42 223772.27
** FUND 27 8247.71- 83274.20
EXPENSE TOTAL 8261.94 223772.27 .00 396625.00 172852.73 56.41
REVENUE TOTAL 14.23 307046.47 .00 350150.00 43103.53 87.68