SYS DATE 071222                                      VILLAGE OF GRANT PARK                                      SYS TIME 13:44
 [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 Jul 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                 .00       748.00          .00     2200.00      1452.00        34.00      2992.00

            ** TOTAL REVENUE                       .00       748.00          .00     2200.00      1452.00        34.00      2992.00 



            DEPARTMENT 31002 TOT                   .00       748.00          .00     2200.00 



 01-31005-0000   POLICE FINES/OVERWIEGHTS          .00       361.30          .00     9000.00      8638.70         4.01      1445.20

            ** TOTAL REVENUE                       .00       361.30          .00     9000.00      8638.70         4.01      1445.20 



            DEPARTMENT 31005 TOT                   .00       361.30          .00     9000.00 



 01-31008-0000   POLICE REPORTS                    .00         5.00          .00       50.00        45.00        10.00        20.00

            ** TOTAL REVENUE                       .00         5.00          .00       50.00        45.00        10.00        20.00 



            DEPARTMENT 31008 TOT                   .00         5.00          .00       50.00 



 01-31009-0000   LIQUOR LICENSE                    .00      5750.00          .00     4000.00      1750.00-      143.75     23000.00

            ** TOTAL REVENUE                       .00      5750.00          .00     4000.00      1750.00-      143.75     23000.00 



            DEPARTMENT 31009 TOT                   .00      5750.00          .00     4000.00 





SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-31010-0000 MISCELLANEOUS INCOME .00 400.00 .00 350.00 50.00- 114.29 1600.00 ** TOTAL REVENUE .00 400.00 .00 350.00 50.00- 114.29 1600.00 DEPARTMENT 31010 TOT .00 400.00 .00 350.00 01-31011-0000 BUILDING PERMITS 155.00 1105.00 .00 15000.00 13895.00 7.37 4420.00 ** TOTAL REVENUE 155.00 1105.00 .00 15000.00 13895.00 7.37 4420.00 DEPARTMENT 31011 TOT 155.00 1105.00 .00 15000.00 01-31012-0000 STATE USE TAX .00 8188.23 .00 50000.00 41811.77 16.38 32752.92 ** TOTAL REVENUE .00 8188.23 .00 50000.00 41811.77 16.38 32752.92 DEPARTMENT 31012 TOT .00 8188.23 .00 50000.00 01-31014-0000 MACHINE LICENSE .00 400.00 .00 600.00 200.00 66.67 1600.00 ** TOTAL REVENUE .00 400.00 .00 600.00 200.00 66.67 1600.00 DEPARTMENT 31014 TOT .00 400.00 .00 600.00 01-31016-0000 PEDDLERS PERMIT .00 .00 .00 100.00 100.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 100.00 100.00 .00 .00 DEPARTMENT 31016 TOT .00 .00 .00 100.00 01-31018-0000 REPLACEMENT TAX .00 8511.19 .00 14000.00 5488.81 60.79 34044.76


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 8511.19 .00 14000.00 5488.81 60.79 34044.76 DEPARTMENT 31018 TOT .00 8511.19 .00 14000.00 01-31019-0000 REAL ESTATE TAX .00 .00 .00 275000.00 275000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 275000.00 275000.00 .00 .00 DEPARTMENT 31019 TOT .00 .00 .00 275000.00 01-31021-0000 SALES TAX .00 28491.66 .00 140000.00 111508.34 20.35 113966.64 ** TOTAL REVENUE .00 28491.66 .00 140000.00 111508.34 20.35 113966.64 DEPARTMENT 31021 TOT .00 28491.66 .00 140000.00 01-31022-0000 AMERITECH UTILITY TAX .00 3028.56 .00 19000.00 15971.44 15.94 12114.24 ** TOTAL REVENUE .00 3028.56 .00 19000.00 15971.44 15.94 12114.24 DEPARTMENT 31022 TOT .00 3028.56 .00 19000.00 01-31023-0000 NICOR UTILITY TAX .00 2789.87 .00 25000.00 22210.13 11.16 11159.48 ** TOTAL REVENUE .00 2789.87 .00 25000.00 22210.13 11.16 11159.48 DEPARTMENT 31023 TOT .00 2789.87 .00 25000.00 01-31024-0000 COMED UTILITY TAX .00 5955.63 .00 76000.00 70044.37 7.84 23822.52 ** TOTAL REVENUE .00 5955.63 .00 76000.00 70044.37 7.84 23822.52


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 31024 TOT .00 5955.63 .00 76000.00 01-31025-0000 INCOME TAX .00 53140.21 .00 160000.00 106859.79 33.21 212560.84 ** TOTAL REVENUE .00 53140.21 .00 160000.00 106859.79 33.21 212560.84 DEPARTMENT 31025 TOT .00 53140.21 .00 160000.00 01-31026-0000 DONATIONS .00 .00 .00 50.00 50.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 50.00 50.00 .00 .00 DEPARTMENT 31026 TOT .00 .00 .00 50.00 01-31029-0000 TRANSPORTATION MAINT. OF .00 .00 .00 3000.00 3000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 3000.00 3000.00 .00 .00 DEPARTMENT 31029 TOT .00 .00 .00 3000.00 01-31030-0000 ELECTRONIC GAMBLING MACHI .00 2055.75 .00 12000.00 9944.25 17.13 8223.00 ** TOTAL REVENUE .00 2055.75 .00 12000.00 9944.25 17.13 8223.00 DEPARTMENT 31030 TOT .00 2055.75 .00 12000.00 01-31031-0000 MEDICOM TAX /FRANCHISE FE .00 1480.36 .00 5000.00 3519.64 29.61 5921.44 ** TOTAL REVENUE .00 1480.36 .00 5000.00 3519.64 29.61 5921.44 DEPARTMENT 31031 TOT .00 1480.36 .00 5000.00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-31032-0000 police reimbursment .00 .00 .00 2900.00 2900.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 2900.00 2900.00 .00 .00 DEPARTMENT 31032 TOT .00 .00 .00 2900.00 01-31040-0000 CANNABIS USE TAX .00 358.90 .00 1800.00 1441.10 19.94 1435.60 ** TOTAL REVENUE .00 358.90 .00 1800.00 1441.10 19.94 1435.60 DEPARTMENT 31040 TOT .00 358.90 .00 1800.00 01-31041-0000 AQUA WATER FRANCHISE FEE .00 41129.58 .00 30000.00 11129.58- 137.10 164518.32 ** TOTAL REVENUE .00 41129.58 .00 30000.00 11129.58- 137.10 164518.32 DEPARTMENT 31041 TOT .00 41129.58 .00 30000.00 01-32600-0000 INTEREST INCOME .00 5.98 .00 30.00 24.02 19.93 23.92 ** TOTAL REVENUE .00 5.98 .00 30.00 24.02 19.93 23.92 DEPARTMENT 32600 TOT .00 5.98 .00 30.00 01-34000-0000 COMMUNITY PARK RENTAL & D 450.00 3600.00 .00 24000.00 20400.00 15.00 14400.00 ** TOTAL REVENUE 450.00 3600.00 .00 24000.00 20400.00 15.00 14400.00 DEPARTMENT 34000 TOT 450.00 3600.00 .00 24000.00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-35006-0000 sale of surplus property .00 2500.00 .00 .00 2500.00- .00 10000.00 ** TOTAL REVENUE .00 2500.00 .00 .00 2500.00- .00 10000.00 DEPARTMENT 35006 TOT .00 2500.00 .00 .00 01-38003-0000 OX CART .00 150.00 .00 500.00 350.00 30.00 600.00 ** TOTAL REVENUE .00 150.00 .00 500.00 350.00 30.00 600.00 DEPARTMENT 38003 TOT .00 150.00 .00 500.00 01-38004-0000 GOLF CART LICENSE .00 500.00 .00 700.00 200.00 71.43 2000.00 ** TOTAL REVENUE .00 500.00 .00 700.00 200.00 71.43 2000.00 DEPARTMENT 38004 TOT .00 500.00 .00 700.00 ** TOTAL REVENUE GENERAL FUND .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:44 [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 Jul 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 ==================================================================================================================================== 01-41100-1000 MAYOR SALARY .00 1500.00 .00 6000.00 4500.00 25.00 6000.00 01-41100-1011 TRUSTEE SALARY .00 3000.00 .00 12000.00 9000.00 25.00 12000.00 01-41100-1100 EXPENSES .00 76.57 .00 1275.00 1198.43 6.01 306.28 01-41100-1500 DUES .00 .00 .00 250.00 250.00 .00 .00 01-41100-2000 VILLAGE SPONSORED EVENT/D .00 .00 .00 1000.00 1000.00 .00 .00 ** TOTAL EXPENSES MAYOR .00 4576.57 .00 20525.00 15948.43 22.30 18306.28 ** TOTAL EXPENSE .00 4576.57 .00 20525.00 15948.43 22.30 18306.28 DEPARTMENT 41100 TOT .00 4576.57- .00 20525.00- 01-41200-1000 SALARY CLERK .00 937.50 .00 3750.00 2812.50 25.00 3750.00 01-41200-1210 OFFICE SUPPLIES .00 58.85 .00 50.00 8.85- 117.70 235.40 01-41200-1500 DUES .00 .00 .00 250.00 250.00 .00 .00 01-41200-1600 PUBLICATION FEES .00 100.00 .00 371.00 271.00 26.95 400.00 01-41200-6000 ORDINANCE CODIFIER .00 .00 .00 3800.00 3800.00 .00 .00 ** TOTAL CLERK .00 1096.35 .00 8221.00 7124.65 13.34 4385.40 ** TOTAL EXPENSE .00 1096.35 .00 8221.00 7124.65 13.34 4385.40 DEPARTMENT 41200 TOT .00 1096.35- .00 8221.00- 01-41300-1000 SALARY TREASURER .00 937.50 .00 3750.00 2812.50 25.00 3750.00 01-41300-1700 AUDIT .00 .00 .00 12550.00 12550.00 .00 .00 01-41300-2100 ACCOUNTING SERVICES (LOCI .00 .00 .00 700.00 700.00 .00 .00 ** TOTAL TREASURER .00 937.50 .00 17000.00 16062.50 5.51 3750.00 ** TOTAL EXPENSE .00 937.50 .00 17000.00 16062.50 5.51 3750.00 DEPARTMENT 41300 TOT .00 937.50- .00 17000.00- 01-41400-1000 SALARY-VILLAGE HALL STAFF 745.04 6941.20 .00 35676.16 28734.96 19.46 27764.80


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-41400-1012 PART TIME 152.00 352.75 .00 2000.00 1647.25 17.64 1411.00 01-41400-1022 PTO 214.40 214.40 .00 .00 214.40- .00 857.60 01-41400-1030 Holiday Pay 171.52 343.04 .00 .00 343.04- .00 1372.16 01-41400-1040 VILLAGE SHARE FICA 1048.04 6344.81 .00 25138.00 18793.19 25.24 25379.24 01-41400-1050 VILLAGE SHARE MEDICARE 245.10 1483.85 .00 5879.00 4395.15 25.24 5935.40 ** MAINTENANCE PAY 2576.10 15680.05 .00 68693.16 53013.11 22.83 62720.20 01-41400-1200 SUPPLIES & MAINTENANCE 90.00 362.04 .00 1000.00 637.96 36.20 1448.16 01-41400-1210 OFFICE SUPPLIES .00 688.65 .00 1200.00 511.35 57.39 2754.60 01-41400-1211 POSTAGE 107.20 286.68 .00 400.00 113.32 71.67 1146.72 01-41400-1301 INSURANCE VILLAGE PORTION 425.00 1298.50 .00 6000.00 4701.50 21.64 5194.00 01-41400-1800 TELEPHONE .00 698.06 .00 2500.00 1801.94 27.92 2792.24 01-41400-1801 DUE INSPECTIONS Chris .00 300.00 .00 5000.00 4700.00 6.00 1200.00 01-41400-1830 INTERNET SERVICE @VILLAGE 148.06 825.22 .00 1740.00 914.78 47.43 3300.88 01-41400-1831 WEBSITE .00 96.00 .00 100.00 4.00 96.00 384.00 01-41400-1832 COMPUTER TECH/IT .00 .00 .00 1000.00 1000.00 .00 .00 01-41400-1900 UTILITIES .00 172.29 .00 700.00 527.71 24.61 689.16 01-41400-2000 EQUIPMENT PURCHASED .00 .00 .00 1500.00 1500.00 .00 .00 01-41400-2001 E Waste Program .00 .00 .00 1850.00 1850.00 .00 .00 01-41400-2003 IMRF 55.53 368.18 .00 1753.00 1384.82 21.00 1472.72 01-41400-2004 Adjudication Officer .00 600.00 .00 3600.00 3000.00 16.67 2400.00 01-41400-2005 Adjudication Secretary 75.00 225.00 .00 800.00 575.00 28.13 900.00 01-41400-2200 JULIE INC. .00 .00 .00 340.00 340.00 .00 .00 01-41400-2506 REIMB/REAL ES TAX PER TIF .00 986.65 .00 5900.00 4913.35 16.72 3946.60 01-41400-2900 LEGAL FEES 2995.06 10627.06 .00 30000.00 19372.94 35.42 42508.24 01-41400-3000 ENGINEERING .00 30.00 .00 1000.00 970.00 3.00 120.00 01-41400-3108 DUE LIBRARY FOR REPLACEME .00 .00 .00 1800.00 1800.00 .00 .00 01-41400-3400 Rail Road Land Lease .00 .00 .00 1100.00 1100.00 .00 .00 01-41400-3500 COLLECTION COST .00 31.89 .00 200.00 168.11 15.95 127.56 01-41400-3700 REPAIRS ON BUILDINGS .00 .00 .00 5000.00 5000.00 .00 .00 01-41400-6500 CIVIL DEFENSE .00 72.86 .00 1900.00 1827.14 3.83 291.44 ** TOTAL PUBLIC PROPERTY 3895.85 17669.08 .00 76383.00 58713.92 23.13 70676.32 ** TOTAL EXPENSE 6471.95 33349.13 .00 145076.16 111727.03 22.99 133396.52 DEPARTMENT 41400 TOT 6471.95- 33349.13- .00 145076.16- 01-41600-1000 CHIEF SALARY 2605.73 15634.38 .00 61235.00 45600.62 25.53 62537.52 01-41600-1010 OVERTIME 1126.08 2081.29 .00 5000.00 2918.71 41.63 8325.16 01-41600-1011 FULL TIME SALARY 6996.68 43893.19 .00 194131.00 150237.81 22.61 175572.76 01-41600-1012 PART TIME 640.00 2876.28 .00 24177.00 21300.72 11.90 11505.12 01-41600-1020 VACATION 280.20 840.60 .00 15229.00 14388.40 5.52 3362.40 01-41600-1021 SICK PAY .00 .00 .00 5551.00 5551.00 .00 .00 01-41600-1030 PERSONAL DAY .00 105.08 .00 2776.00 2670.92 3.79 420.32


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-41600-1032 HOLIDAY 369.12 738.24 .00 .00 738.24- .00 2952.96 01-41600-1033 BUY BACK FRINGE .00 .00 .00 9400.00 9400.00 .00 .00 01-41600-1100 EXPENSES 310.64 428.77 .00 800.00 371.23 53.60 1715.08 01-41600-1200 SUPPLIES & MAINTENANCE 1157.96 2375.62 .00 1500.00 875.62- 158.37 9502.48 01-41600-1210 OFFICE SUPPLIES .00 240.02 .00 2000.00 1759.98 12.00 960.08 01-41600-1300 HEALTH INSURANCE STIPEND .00 1700.00 .00 10200.00 8500.00 16.67 6800.00 01-41600-1301 INSURANCE VILLAGE SHARE 850.00 2605.84 .00 7000.00 4394.16 37.23 10423.36 01-41600-1700 RADAR CERTIFICATION .00 .00 .00 300.00 300.00 .00 .00 01-41600-1701 SCALE CERTIFICATION .00 .00 .00 300.00 300.00 .00 .00 01-41600-1800 TELEPHONE OFFICE .00 620.40 .00 500.00 120.40- 124.08 2481.60 01-41600-1801 TELEPHONE CELL 79.70 235.98 .00 1000.00 764.02 23.60 943.92 01-41600-1802 AIRCARDS-VERIZON 197.17 621.51 .00 2200.00 1578.49 28.25 2486.04 01-41600-1830 INTERNET SERVICE 248.06 496.01 .00 3000.00 2503.99 16.53 1984.04 01-41600-1900 UTILITIES 23.72 384.26 .00 1500.00 1115.74 25.62 1537.04 01-41600-2000 EQUIPMENT PURCHASED .00 .00 .00 2000.00 2000.00 .00 .00 01-41600-2001 POLICE PUBLIC RELATIONS 100.00 100.00 .00 100.00 .00 100.00 400.00 01-41600-2002 DISPATCH FEES .00 .00 .00 6500.00 6500.00 .00 .00 01-41600-2003 IMRF 558.64 3191.13 .00 14045.00 10853.87 22.72 12764.52 01-41600-2100 TRAINING .00 920.00 .00 2500.00 1580.00 36.80 3680.00 01-41600-2200 AMMUNITION .00 .00 .00 850.00 850.00 .00 .00 01-41600-2300 UNIFORMS FULL TIME .00 484.92 .00 1500.00 1015.08 32.33 1939.68 01-41600-2301 UNIFORMS PART TIME .00 .00 .00 1000.00 1000.00 .00 .00 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 495.70 4106.48 .00 20000.00 15893.52 20.53 16425.92 01-41600-2500 AUTO REPAIRS .00 2247.78 .00 3000.00 752.22 74.93 8991.12 01-41600-2510 AUTOMOBILE TIRES .00 .00 .00 600.00 600.00 .00 .00 01-41600-2520 VEHICLE LEASE .00 8530.00 .00 16500.00 7970.00 51.70 34120.00 01-41600-2600 EQUIPMENT REPAIRS .00 .00 .00 500.00 500.00 .00 .00 01-41600-2800 BOOKING FEES .00 40.00 .00 200.00 160.00 20.00 160.00 01-41600-2801 SHERIFFS CAD FEE 5197.20 5197.20 .00 5197.00 .20- 100.00 20788.80 01-41600-2900 ILEAS MEMBERSHIP DUES .00 50.00 .00 200.00 150.00 25.00 200.00 01-41600-3000 DRUG SCREENING .00 .00 .00 250.00 250.00 .00 .00 01-41600-3100 COMPUTER EQUIPMENT .00 .00 .00 750.00 750.00 .00 .00 01-41600-3101 Computer Tech Fees .00 549.45 .00 1000.00 450.55 54.95 2197.80 01-41600-3900 MISCELLANEOUS 100.00 100.00 .00 100.00 .00 100.00 400.00 01-41600-4000 ANIMAL CONTROL .00 1000.00 .00 1000.00 .00 100.00 4000.00 ** TOTAL POLICE 21336.60 102394.43 .00 426191.00 323796.57 24.03 409577.72 ** TOTAL EXPENSE 21336.60 102394.43 .00 426191.00 323796.57 24.03 409577.72 DEPARTMENT 41600 TOT 21336.60- 102394.43- .00 426191.00- 01-41700-1100 EXPENSES .00 .00 .00 950.00 950.00 .00 .00 01-41700-1120 LIABILITY & WORK COMP .00 7300.13 .00 70000.00 62699.87 10.43 29200.52


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-41700-2801 DEDUCTIBLE .00 .00 .00 1000.00 1000.00 .00 .00 ** TOTAL INSURANCE .00 7300.13 .00 71950.00 64649.87 10.15 29200.52 ** TOTAL EXPENSE .00 7300.13 .00 71950.00 64649.87 10.15 29200.52 DEPARTMENT 41700 TOT .00 7300.13- .00 71950.00- 01-42200-1000 SALARY PARK .00 .00 .00 500.00 500.00 .00 .00 01-42200-1200 SUPPLIES & MAINTENANCE .00 232.04 .00 3200.00 2967.96 7.25 928.16 01-42200-1900 UTILITIES 224.21 881.23 .00 3000.00 2118.77 29.37 3524.92 01-42200-2000 PORTA POTTY .00 380.00 .00 1400.00 1020.00 27.14 1520.00 01-42200-3700 REPAIRS .00 .00 .00 2000.00 2000.00 .00 .00 01-42200-3800 PARK IMPROVEMENTS .00 .00 .00 2775.00 2775.00 .00 .00 01-42200-3900 PARK DEPOSIT REFUND 450.00 2550.00 .00 8800.00 6250.00 28.98 10200.00 01-42200-5710 CLEANING FEES .00 150.00 .00 100.00 50.00- 150.00 600.00 ** TOTAL PARK 674.21 4193.27 .00 21775.00 17581.73 19.26 16773.08 ** TOTAL EXPENSE 674.21 4193.27 .00 21775.00 17581.73 19.26 16773.08 DEPARTMENT 42200 TOT 674.21- 4193.27- .00 21775.00- 01-42400-1000 SALARY-STREET COMMISSIONE 1615.38 9692.28 .00 42000.00 32307.72 23.08 38769.12 01-42400-1001 FULL TIME STREETS & ALLEY 1443.60 8340.80 .00 41714.40 33373.60 20.00 33363.20 01-42400-1010 OVERTIME-STREET & ALLEY .00 60.15 .00 1500.00 1439.85 4.01 240.60 01-42400-1012 PART TIME WAGES 384.00 864.00 .00 2304.00 1440.00 37.50 3456.00 01-42400-1021 SICK PAY .00 160.40 .00 .00 160.40- .00 641.60 01-42400-1022 PTO .00 802.00 .00 .00 802.00- .00 3208.00 01-42400-1030 HOLIDAY PAY 160.40 320.80 .00 .00 320.80- .00 1283.20 01-42400-1200 SUPPLIES & MAINTENANCE .00 347.78 .00 2000.00 1652.22 17.39 1391.12 01-42400-1210 OFFICE SUPPLIES .00 .00 .00 500.00 500.00 .00 .00 01-42400-1212 membership/subscriptions .00 .00 .00 300.00 300.00 .00 .00 01-42400-1301 INSURANCE VILLAGE SHARE 272.66 815.75 .00 3300.00 2484.25 24.72 3263.00 01-42400-1800 CELL PHONE 79.69 159.38 .00 .00 159.38- .00 637.52 01-42400-1802 internet .00 .00 .00 1200.00 1200.00 .00 .00 01-42400-1900 UTILITIES .00 445.35 .00 1200.00 754.65 37.11 1781.40 01-42400-2000 EQUIPMENT PURCHASED .00 404.22 .00 12000.00 11595.78 3.37 1616.88 01-42400-2001 vehicle lease .00 7419.19 .00 7419.00 .19- 100.00 29676.76 01-42400-2003 IMRF 78.76 475.51 .00 4110.00 3634.49 11.57 1902.04 01-42400-2010 EQUIPMENT RENTAL .00 .00 .00 500.00 500.00 .00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 ==================================================================================================================================== 01-42400-2011 MOWER .00 .00 .00 500.00 500.00 .00 .00 01-42400-2020 EQUIPMENT REPAIRS .00 .00 .00 2500.00 2500.00 .00 .00 01-42400-2021 GENERAL REPAIRS .00 .00 .00 2500.00 2500.00 .00 .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 .00 3408.22 .00 7000.00 3591.78 48.69 13632.88 01-42400-3300 REMOVAL & REPLACE TREES .00 .00 .00 8000.00 8000.00 .00 .00 01-42400-3600 STREET LIGHTS .00 1840.71 .00 10000.00 8159.29 18.41 7362.84 01-42400-3710 SIDEWALKS .00 .00 .00 1000.00 1000.00 .00 .00 01-42400-3711 ALLEY MAINTENANCE .00 .00 .00 7000.00 7000.00 .00 .00 01-42400-3712 PURCHASE TOOLS .00 .00 .00 800.00 800.00 .00 .00 01-42400-3713 CURB PAINT .00 725.00 .00 1500.00 775.00 48.33 2900.00 01-42400-3714 DRAINAGE/CULVERTS .00 .00 .00 3000.00 3000.00 .00 .00 01-42400-3715 TIRES .00 .00 .00 1500.00 1500.00 .00 .00 01-42400-3721 BOLT BIN KITS .00 .00 .00 500.00 500.00 .00 .00 01-42400-3724 LAKE METONGA .00 .00 .00 1000.00 1000.00 .00 .00 01-42400-4000 SPRAY PATCHING 9800.00 9800.00 .00 10000.00 200.00 98.00 39200.00 01-42400-4700 BLACKTOPPING (NOT MFT FUN .00 .00 .00 8402.00 8402.00 .00 .00 01-42400-5000 SIGNS .00 .00 .00 1000.00 1000.00 .00 .00 01-42400-5001 YELLOWHEAD ROAD REPAIR .00 .00 .00 15000.00 15000.00 .00 .00 ** TOTAL STREET AND ALLEY 13834.49 46081.54 .00 202499.40 156417.86 22.76 184326.16 ** TOTAL EXPENSE 13834.49 46081.54 .00 202499.40 156417.86 22.76 184326.16 DEPARTMENT 42400 TOT 13834.49- 46081.54- .00 202499.40- ** FUND 01 41712.25- 29273.70- EXPENSE TOTAL 42317.25 199928.92 .00 913237.56 713308.64 21.89 REVENUE TOTAL 605.00 170655.22 .00 870280.00 699624.78 19.60


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 .00 .00 9066.00 9066.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 9066.00 9066.00 .00 .00 DEPARTMENT 31028 TOT .00 .00 .00 9066.00 03-32600-0000 INTEREST .00 2.41 .00 10.00 7.59 24.10 9.64 ** TOTAL REVENUE .00 2.41 .00 10.00 7.59 24.10 9.64 DEPARTMENT 32600 TOT .00 2.41 .00 10.00 EXPENSES ** TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .00 DEPARTMENT 40000 TOT .00 .00 .00 .00 03-41000-1500 REAL ESTATE TAXES .00 1782.90 .00 1850.00 67.10 96.37 7131.60 03-41000-3712 storm sewer maintence .00 .00 .00 3000.00 3000.00 .00 .00 03-41000-3713 Stormwater Control .00 .00 .00 25000.00 25000.00 .00 .00 ** TOTAL EXPENSE .00 1782.90 .00 29850.00 28067.10 5.97 7131.60 DEPARTMENT 41000 TOT .00 1782.90- .00 29850.00-


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 ==================================================================================================================================== ** 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 .00 1780.49- EXPENSE TOTAL .00 1782.90 .00 29850.00 28067.10 5.97 REVENUE TOTAL .00 2.41 .00 9076.00 9073.59 .02


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 1.87 .00 15.00 13.13 12.47 7.48 ** TOTAL REVENUE .00 1.87 .00 15.00 13.13 12.47 7.48 DEPARTMENT 32600 TOT .00 1.87 .00 15.00 05-39000-0000 MOTOR FUEL TAX .00 8946.49 .00 48000.00 39053.51 18.64 35785.96 ** TOTAL REVENUE .00 8946.49 .00 48000.00 39053.51 18.64 35785.96 DEPARTMENT 39000 TOT .00 8946.49 .00 48000.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:44 [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 Jul 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 2000.00 2000.00 .00 .00 05-41000-4700 STONE & SALT .00 650.00 .00 8000.00 7350.00 8.13 2600.00 05-41000-4710 STREET & ALLEY REPAIR .00 1950.00 .00 30000.00 28050.00 6.50 7800.00 05-41000-4711 COLD PATCH .00 715.52 .00 2000.00 1284.48 35.78 2862.08 05-41000-4713 HOT PATCH .00 .00 .00 100.00 100.00 .00 .00 ** TOTAL EXPENSE MFT .00 3315.52 .00 42100.00 38784.48 7.88 13262.08 ** TOTAL EXPENSE .00 3315.52 .00 42100.00 38784.48 7.88 13262.08 DEPARTMENT 41000 TOT .00 3315.52- .00 42100.00- ** FUND 05 .00 5632.84 EXPENSE TOTAL .00 3315.52 .00 42100.00 38784.48 7.87 REVENUE TOTAL .00 8948.36 .00 48015.00 39066.64 18.63


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 .00 7000.00 7000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 7000.00 7000.00 .00 .00 DEPARTMENT 31001 TOT .00 .00 .00 7000.00 07-31005-0000 FOOD VENDER BOOTH .00 .00 .00 350.00 350.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 350.00 350.00 .00 .00 DEPARTMENT 31005 TOT .00 .00 .00 350.00 07-31007-0000 CAR SHOW REGISTRATIONS .00 .00 .00 800.00 800.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 800.00 800.00 .00 .00 DEPARTMENT 31007 TOT .00 .00 .00 800.00 07-31008-0000 RAFFLE/GUN .00 .00 .00 1000.00 1000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 1000.00 1000.00 .00 .00 DEPARTMENT 31008 TOT .00 .00 .00 1000.00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-31009-0000 BEVERAGE SALES .00 .00 .00 5000.00 5000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 5000.00 5000.00 .00 .00 DEPARTMENT 31009 TOT .00 .00 .00 5000.00 07-31010-0000 KIDS GAMES .00 .00 .00 450.00 450.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 450.00 450.00 .00 .00 DEPARTMENT 31010 TOT .00 .00 .00 450.00 07-31011-0000 BAND COVER .00 .00 .00 500.00 500.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00 DEPARTMENT 31011 TOT .00 .00 .00 500.00 07-31013-0000 BINGO .00 .00 .00 500.00 500.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00 DEPARTMENT 31013 TOT .00 .00 .00 500.00 07-31014-0000 50/50 .00 70.00 .00 300.00 230.00 23.33 280.00 ** TOTAL REVENUE .00 70.00 .00 300.00 230.00 23.33 280.00 DEPARTMENT 31014 TOT .00 70.00 .00 300.00 07-31020-0000 EXCHANGE ACCOUNT .00 .00 .00 1500.00 1500.00 .00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 1500.00 1500.00 .00 .00 DEPARTMENT 31020 TOT .00 .00 .00 1500.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 500.00 500.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 500.00 500.00 .00 .00 DEPARTMENT 32003 TOT .00 .00 .00 500.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 07-32005-0000 MISC DONATIONS/TIPS .00 .00 .00 150.00 150.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 150.00 150.00 .00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 32005 TOT .00 .00 .00 150.00 07-32008-0000 CFR BINGO .00 .00 .00 100.00 100.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 100.00 100.00 .00 .00 DEPARTMENT 32008 TOT .00 .00 .00 100.00 07-32600-0000 INTEREST .00 .58 .00 5.00 4.42 11.60 2.32 ** TOTAL REVENUE .00 .58 .00 5.00 4.42 11.60 2.32 DEPARTMENT 32600 TOT .00 .58 .00 5.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 07-41000-1200 SUPPLIES & MAINTENANCE .00 .00 .00 150.00 150.00 .00 .00 07-41000-1202 T SHIRT .00 .00 .00 500.00 500.00 .00 .00 07-41000-1210 OFFICE SUPPLIES .00 .00 .00 100.00 100.00 .00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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-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-2001 EQUIPMENT RENTAL .00 .00 .00 1000.00 1000.00 .00 .00 07-41000-3700 BUILDING UPGRADES/REPAIR .00 .00 .00 500.00 500.00 .00 .00 07-41000-3701 TABLES/CHAIRS .00 .00 .00 1500.00 1500.00 .00 .00 07-41000-4000 RAFFLE PRIZES .00 .00 .00 1000.00 1000.00 .00 .00 07-41000-4001 ALCOHOL .00 .00 .00 2700.00 2700.00 .00 .00 07-41000-4002 BAR SUPPLIES .00 .00 .00 50.00 50.00 .00 .00 07-41000-4003 LIQUOR LICENSE .00 .00 .00 25.00 25.00 .00 .00 07-41000-4004 SODA/ WATER .00 .00 .00 250.00 250.00 .00 .00 07-41000-4005 ICE .00 .00 .00 350.00 350.00 .00 .00 07-41000-4007 DECORATIONS .00 .00 .00 250.00 250.00 .00 .00 07-41000-4008 BANDS/SOUND .00 .00 .00 2500.00 2500.00 .00 .00 07-41000-4009 CAR SHOW AWARDS .00 .00 .00 800.00 800.00 .00 .00 07-41000-4010 CAR SHOW PRINTING .00 .00 .00 300.00 300.00 .00 .00 07-41000-4011 BURN OUT CONTEST .00 .00 .00 200.00 200.00 .00 .00 07-41000-4012 KIDS GAMES SUPPLIES .00 .00 .00 1500.00 1500.00 .00 .00 07-41000-4018 FIREWORKS .00 8500.00 .00 9000.00 500.00 94.44 34000.00 07-41000-4019 TENT .00 .00 .00 5000.00 5000.00 .00 .00 07-41000-4020 PORTA POTTY .00 .00 .00 1500.00 1500.00 .00 .00 07-41000-4022 BANNERS .00 .00 .00 250.00 250.00 .00 .00 07-41000-4023 PARADE .00 .00 .00 100.00 100.00 .00 .00 07-41000-4024 PROMOTIONAL PRODUCTS .00 .00 .00 100.00 100.00 .00 .00 07-41000-4027 POLICE FEST COVERAGE .00 .00 .00 1600.00 1600.00 .00 .00 07-41000-4030 KIDS GAME PRIZES .00 .00 .00 200.00 200.00 .00 .00 07-41000-4031 GAS/GENERATOR .00 .00 .00 200.00 200.00 .00 .00 07-41000-4032 COMMITTEE PIZZA .00 .00 .00 150.00 150.00 .00 .00 07-41000-4034 PRINTING/FLYERS/TIC .00 .00 .00 500.00 500.00 .00 .00 07-41000-4035 CASH DRAW .00 .00 .00 1500.00 1500.00 .00 .00 07-41000-4036 DUMPSTER .00 .00 .00 350.00 350.00 .00 .00 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 100.00 100.00 .00 .00 07-41000-5006 SUPPLIES /DECOR .00 .00 .00 150.00 150.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 .00 .00 200.00 200.00 .00 .00 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 150.00 150.00 .00 .00 07-41000-6000 EASTER .00 .00 .00 100.00 100.00 .00 .00 07-41000-7000 HALLOWEEN .00 .00 .00 100.00 100.00 .00 .00 07-41000-7001 CHRISTMAS .00 .00 .00 100.00 100.00 .00 .00 ** TOTAL EXPENSE FEST .00 8500.00 .00 37350.00 28850.00 22.76 34000.00 ** TOTAL EXPENSE .00 8500.00 .00 37350.00 28850.00 22.76 34000.00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 ==================================================================================================================================== DEPARTMENT 41000 TOT .00 8500.00- .00 37350.00- ** FUND 07 .00 8429.42- EXPENSE TOTAL .00 8500.00 .00 37350.00 28850.00 22.75 REVENUE TOTAL .00 70.58 .00 19855.00 19784.42 .35


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 ==================================================================================================================================== 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 29000.00 29000.00 .00 .00 ** TOTAL EXPENSE MFT .00 .00 .00 29000.00 29000.00 .00 .00 ** TOTAL EXPENSE .00 .00 .00 29000.00 29000.00 .00 .00 DEPARTMENT 41000 TOT .00 .00 .00 29000.00- ** FUND 08 .00 .00 EXPENSE TOTAL .00 .00 .00 29000.00 29000.00 .00 REVENUE TOTAL .00 .00 .00 .00 .00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 394.59 .00 2500.00 2105.41 15.78 1578.36 ** TOTAL REVENUE .00 394.59 .00 2500.00 2105.41 15.78 1578.36 DEPARTMENT 32600 TOT .00 394.59 .00 2500.00 ** FUND 09 .00 394.59 EXPENSE TOTAL .00 .00 .00 .00 .00 .00 REVENUE TOTAL .00 394.59 .00 2500.00 2105.41 15.78


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 .00 .00 18000.00 18000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 18000.00 18000.00 .00 .00 DEPARTMENT 31011 TOT .00 .00 .00 18000.00 ** FUND 10 .00 .00 EXPENSE TOTAL .00 .00 .00 .00 .00 .00 REVENUE TOTAL .00 .00 .00 18000.00 18000.00 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 .00 84985.00 84985.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 84985.00 84985.00 .00 .00 DEPARTMENT 31000 TOT .00 .00 .00 84985.00 11-32600-0000 INTEREST .00 1.45 .00 5.00 3.55 29.00 5.80 ** TOTAL REVENUE .00 1.45 .00 5.00 3.55 29.00 5.80 DEPARTMENT 32600 TOT .00 1.45 .00 5.00 ** FUND 11 .00 1.45 EXPENSE TOTAL .00 .00 .00 .00 .00 .00 REVENUE TOTAL .00 1.45 .00 84990.00 84988.55 .00


SYS DATE 071222 VILLAGE OF GRANT PARK SYS TIME 13:44 [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 Jul 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 .00 14.52 .00 155.00 140.48 9.37 58.08 ** TOTAL REVENUE .00 14.52 .00 155.00 140.48 9.37 58.08 DEPARTMENT 32600 TOT .00 14.52 .00 155.00 27-38005-0000 TAX PAYMENT .00 .00 .00 308000.00 308000.00 .00 .00 ** TOTAL REVENUE .00 .00 .00 308000.00 308000.00 .00 .00 DEPARTMENT 38005 TOT .00 .00 .00 308000.00 27-41000-1211 postage .00 .00 .00 25.00 25.00 .00 .00 27-41000-2900 PROFESSIONAL FEES .00 1330.00 .00 5000.00 3670.00 26.60 5320.00 27-41000-3000 Engineering .00 .00 .00 25000.00 25000.00 .00 .00 27-41000-3001 ENG/DOWNTOWN STREETSCAPE .00 .00 .00 15000.00 15000.00 .00 .00 27-41000-3002 ENG/SAFE RTE TO SCHOOL .00 4780.00 .00 1800.00 2980.00- 265.56 19120.00 27-41000-3003 ENG/ MULTI USE PATH RTE 1 .00 .00 .00 1000.00 1000.00 .00 .00 27-41000-3004 ENG/SIGN .00 1200.00 .00 16620.00 15420.00 7.22 4800.00 27-41000-4603 CONTRACT DISBURSMENT COUN .00 .00 .00 8571.00 8571.00 .00 .00 27-41000-4604 CONTRACT DISBURSMENT SCOT .00 .00 .00 18000.00 18000.00 .00 .00 27-41000-4605 CONTRACT DISB FLANAGAN'S .00 .00 .00 17000.00 17000.00 .00 .00 27-41000-4606 CONTRACT DISB .00 .00 .00 15000.00 15000.00 .00 .00 27-41000-4706 LEGAL/ACCOUNTING .00 2425.00 .00 4000.00 1575.00 60.63 9700.00 27-41000-4707 DEVELOPMENT PROJECTS .00 .00 .00 40000.00 40000.00 .00 .00 27-41000-4708 PROJECT MARKETING .00 .00 .00 500.00 500.00 .00 .00 27-41000-4710 SCHOOL REIMBURSEMENT .00 56718.00 .00 70500.00 13782.00 80.45 226872.00 27-41000-4711 EMERGENCY REPAIRS .00 .00 .00 15000.00 15000.00 .00 .00 27-41000-4803 STREET REPAIR .00 .00 .00 55000.00 55000.00 .00 .00 ** TOTAL EXPENSE .00 66453.00 .00 308016.00 241563.00 21.57 265812.00 ** FUND 27 .00 66438.48- EXPENSE TOTAL .00 66453.00 .00 308016.00 241563.00 21.57 REVENUE TOTAL .00 14.52 .00 308155.00 308140.48 .00