Budget 2022

CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 1 Period: 01/22 Nov 10, 2021 10:21AM Report Criteria: Accounts to include: With balances or activity Print FUND Titles Page and Total by FUND Print SOURCE Titles Total by SOURCE Print COST CATEGORY Titles All Segments Tested for Total Breaks 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget GENERAL FUND TAXES 100-41-4111-000 GENERAL PROPERTY TAXES 838,732.00 838,732.37 805,623.00 805,623.00 855,167.00 100-41-4112-000 MOBILE HOME TAXES 2,200.00 2,105.91 1,700.00 1,036.00 1,200.00 100-41-4131-000 TAX ON UTILITIES 73,304.00 69,381.04 78,500.00 63,346.70 69,381.00 Total TAXES: 914,236.00 910,219.32 885,823.00 870,005.70 925,748.00 SPECIAL ASSESSMENTS 100-42-4214-000 GRAVEL, BLACK DIRT, BLACKTOP .00 227.36 .00 .00 .00 Total SPECIAL ASSESSMENTS: .00 227.36 .00 .00 .00 INTERGOVERNMENTAL REVENUES 100-43-4341-000 STATE SHARED TAXES 455,423.00 439,772.61 427,127.00 64,069.03 427,136.00 100-43-4342-000 FIRE INSURANCE TAX FROM STATE 3,600.00 4,029.64 4,000.00 4,449.35 4,000.00 100-43-4344-000 TOWN OF FOX LAKE-DAM WAGES 4,140.00 4,140.00 4,140.00 3,105.00 4,140.00 100-43-4352-000 STATE AID-POLICE TRAINING 480.00 640.00 480.00 .00 480.00 100-43-4353-000 STATE AID-ROAD ALLOTMENT 133,678.30 133,678.42 153,730.00 153,730.05 176,789.56 100-43-4355-000 STATE AID-RECYCLE GRANT 8,000.00 8,077.76 8,000.00 8,155.78 8,100.00 100-43-4359-000 STATE AID-OTHER GRANTS 5,600.00 3,293.82 6,933.37 4,550.98 5,492.83 100-43-4361-000 COVID-19 CARES GRANT .00 20,032.86 .00 .00 .00 100-43-4362-000 DODGE COUNTY - OTHER .00 847.59 .00 .00 .00 100-43-4372-000 STATE AID-OTHER GRANTS LIBRARY .00 343.00 .00 .00 .00 Total INTERGOVERNMENTAL REVENUES: 610,921.30 614,855.70 604,410.37 238,060.19 626,138.39 LICENSES & PERMITS 100-44-4411-000 LIQUOR & MALT BEVERAGE LICENSE 2,000.00 584.25 2,000.00 518.64 2,015.00 100-44-4412-000 OPERATORS LICENSE 1,000.00 45.00 1,000.00 .00 855.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 2 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-44-4413-000 CIGARETTE LICENSE 150.00 200.00 200.00 200.00 200.00 100-44-4415-000 DOG & CAT LICENSES 1,400.00 1,716.81 1,200.00 1,059.47 1,000.00 100-44-4417-000 OTHER LICENSES 75.00 75.00 75.00 145.00 150.00 100-44-4421-000 CABLE TV FRANCHISE FEE 20,000.00 20,410.26 19,600.00 14,045.01 19,600.00 100-44-4431-000 BUILDING PERMITS 6,000.00 10,745.20 6,000.00 21,410.10 10,000.00 100-44-4432-000 ELECTRICAL PERMITS 2,000.00 3,480.16 1,500.00 3,490.20 2,000.00 100-44-4433-000 PLUMBING PERMITS 1,000.00 3,733.52 600.00 5,154.40 2,000.00 Total LICENSES & PERMITS: 33,625.00 40,990.20 32,175.00 46,022.82 37,820.00 FINES & FORFEITURES 100-45-4511-000 COURT PENALTIES & COSTS 30,000.00 15,694.66 25,000.00 26,100.66 30,000.00 Total FINES & FORFEITURES: 30,000.00 15,694.66 25,000.00 26,100.66 30,000.00 PUBLIC CHARGES FOR SERVICE 100-46-4612-000 PUBLICATION FEES 200.00 6.33- 100.00 86.40 100.00 100-46-4614-000 GENERAL GOVERNMENT 2,000.00 3,397.63 2,500.00 3,255.00 3,000.00 100-46-4621-000 POLICE DEPARTMENT FEES 1,000.00 5,025.34 1,500.00 1,734.41 2,000.00 100-46-4631-000 SNOW & ICE CONTROL 500.00 750.00 500.00 600.00 500.00 100-46-4641-000 GARBAGE COLLECTION 91,200.00 90,042.79 95,800.00 82,954.31 95,800.00 100-46-4642-000 WEED CONTROL 250.00 .00 150.00 1,075.00 150.00 100-46-4651-000 PARKS 300.00 150.00 100.00 135.00 150.00 100-46-4652-000 WATER RECREATION 10,000.00 20,339.89 15,000.00 14,550.84 14,000.00 100-46-4653-000 SWIMMING POOL 16,500.00 6,091.25 16,000.00 21,938.67 22,000.00 100-46-4654-000 COMMUNITY CENTER-RENT 3,250.00 300.00 1,200.00 4,170.00 3,250.00 100-46-4655-000 CEMETERY 6,500.00 5,680.00 3,000.00 6,800.00 5,000.00 100-46-4656-000 SWIMMING POOL-CONCESSIONS 2,000.00 .00 1,500.00 1,762.45 2,000.00 100-46-4657-000 LIBRARY 38,138.61 37,477.94 33,535.00 33,535.28 46,034.33 100-46-4690-000 OTHER REVENUE 3,000.00 9,812.40 4,000.00 9,068.32 4,000.00 Total PUBLIC CHARGES FOR SERVICE: 174,838.61 179,060.91 174,885.00 181,665.68 197,984.33 INTERDEPARTMENTAL CHARGES 100-47-4721-000 SANITATION SERVICES 500.00 1,186.49 800.00 1,049.00 800.00 Total INTERDEPARTMENTAL CHARGES: 500.00 1,186.49 800.00 1,049.00 800.00 MISCELLANEOUS REVENUE 100-48-4811-000 INTEREST ON TEMP . INVESTMENTS 5,000.00 3,479.03 4,000.00 449.79 500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 3 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-48-4815-000 INTEREST ON TIF ADVANCE .00 1,946.00 .00 .00 .00 100-48-4821-000 RENT OF CITY OWNED LAND 200.00 200.00 200.00 300.00 300.00 100-48-4851-000 DONATIONS 2,500.00 3,615.50 3,000.00 22,842.67 3,000.00 100-48-4891-000 FIRE ASSOC SERVICE AWARD PROG .00 .00 .00 .00 .00 Total MISCELLANEOUS REVENUE: 7,700.00 9,240.53 7,200.00 23,592.46 3,800.00 OTHER FINANCING SOURCES 100-49-4900-400 TRANSFER IN FROM CAP . IMP FUND .00 .00 .00 .00 .00 100-49-4900-701 TRANSFER IN FROM CEMETARY .00 .00 .00 .00 .00 100-49-4930-000 FUNDS APPLIED 94,253.25 .00 287,936.44 .00 158,890.69 Total OTHER FINANCING SOURCES: 94,253.25 .00 287,936.44 .00 158,890.69 GENERAL GOVERMENT 100-51-5110-120 COUNCIL-WAGES 24,090.00 23,389.91 29,100.00 24,758.30 29,100.00 100-51-5110-130 COUNCIL-FICA 1,951.00 1,863.88 2,226.00 1,962.83 2,226.00 100-51-5110-320 COUNCIL-PUB/SUB/DUES 630.00 630.09 608.55 608.55 720.00 100-51-5110-330 COUNCIL-TRAVEL 100.00 .00 100.00 167.10 540.00 100-51-5110-331 COUNCIL-TRAINING .00 .00 .00 100.00 300.00 100-51-5110-390 COUNCIL-OTHER SUPPLIES 100.00 .00 100.00 283.00 100.00 100-51-5120-120 MUNICIPAL COURT-WAGES 12,748.00 10,656.20 13,526.00 5,583.84 13,916.00 100-51-5120-125 MUNICIPAL COURT-VAC PAYOUT .00 .00 .00 58.65 .00 100-51-5120-130 MUNICIPAL COURT-FICA 975.00 819.75 1,035.00 435.47 1,065.00 100-51-5120-135 MUNICIPAL COURT-WI RET FUND 579.00 496.49 686.00 387.61 686.00 100-51-5120-220 MUNICIPAL COURT-UTILITIES 700.00 242.80 525.00 150.00 200.00 100-51-5120-311 MUNICIPAL COURT-COMPUTER SUPP 7,000.00 7,099.01 7,250.00 9,064.87 11,800.00 100-51-5120-320 MUNICIPAL COURT-PUB/SUB/DUES 845.00 845.00 845.00 120.00 160.00 100-51-5120-330 MUNICIPAL COURT-TRAIN/TRAVEL 700.00 255.28 425.00 700.00 700.00 100-51-5120-390 MUNICIPAL COURT-OTHER SUPPLIES 1,000.00 572.22 1,000.00 834.58 1,000.00 100-51-5140-120 ADMINISTRATOR-WAGES .00 .00 .00 9,593.76 38,653.00 100-51-5140-130 ADMINISTRATOR- FICA .00 .00 .00 733.92 2,957.00 100-51-5140-135 ADMINISTRATOR-WIS RET FUND .00 .00 .00 647.58 2,512.00 100-51-5140-140 ADMINISTRATOR-INSURANCES .00 .00 .00 1,281.82 4,597.00 100-51-5140-210 ADMINISTRATOR-PROF SERVICES 28,000.00 31,536.75 30,000.00 17,685.50 695.00 100-51-5140-310 ADMINISTRATOR-OFFICE EXPENSE 1,000.00 2,450.70 1,500.00 1,500.57 2,000.00 100-51-5140-311 ADMINISTRATOR-COMPUTER SUP/EX 4,400.00 2,637.65 2,750.00 2,915.10 3,100.00 100-51-5140-320 ADMINISTRATOR-PUB/SUB/DUES .00 83.39 66.00 66.00 66.00 100-51-5140-330 ADMINISTRATOR-TRAVEL 200.00 .00 200.00 .00 200.00 100-51-5140-340 ADMINISTRATOR-OPERATING SUPPL .00 .00 .00 .00 100.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 4 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5140-390 ADMINISTRATOR-OTHER EXPENSES 530.00 105.11 200.00 52.00 200.00 100-51-5141-120 MAYOR-WAGES 6,830.00 6,569.97 7,200.00 6,360.00 7,200.00 100-51-5141-130 MAYOR-FICA 551.00 522.49 551.00 504.90 551.00 100-51-5141-390 MAYOR-EXPENSES 700.00 292.70 700.00 464.57 700.00 100-51-5142-120 CLERK-WAGES 34,905.00 46,574.05 31,240.00 27,487.27 24,751.00 100-51-5142-125 CLERK-VACATION PAYOUT .00 4,399.76 .00 1,580.25 .00 100-51-5142-130 CLERK-FICA 2,670.00 4,123.63 2,390.00 2,513.28 1,893.00 100-51-5142-135 CLERK-WI RETIREMENT FUND 2,304.00 3,638.35 2,109.00 2,217.66 1,608.00 100-51-5142-140 CLERK-INSURANCES 14,282.00 8,522.87 2,576.00 3,459.42 1,784.00 100-51-5142-310 CLERK-OFFICE EXPENSE 3,400.00 4,035.12 3,400.00 3,949.14 4,000.00 100-51-5142-311 CLERK-COMPUTER SUPPORT/EXPEN 4,000.00 2,967.00 4,000.00 3,132.34 3,500.00 100-51-5142-320 CLERK-PUB/SUB/DUES 2,500.00 2,412.53 2,500.00 50.00 60.00 100-51-5142-330 CLERK-TRAVEL 425.00 48.24 425.00 .00 425.00 100-51-5142-331 CLERK-TRAINING 575.00 664.00 600.00 544.00 600.00 100-51-5142-340 CLERK-OPERATING SUPPLIES 150.00 346.06 175.00 200.63 300.00 100-51-5144-120 ELECTIONS-WAGES 680.00 2,500.17 840.00 1,333.50 3,030.00 100-51-5144-130 ELECTIONS-FICA 55.00 177.86 64.00 102.03 232.00 100-51-5144-135 ELECTIONS-WI RETIREMENT FUND .00 156.95 57.00 90.01 197.00 100-51-5144-140 ELECTIONS-INSURANCES .00 270.59 46.00 37.67 218.00 100-51-5144-310 ELECTIONS-OFFICE EXPENSE .00 97.03 .00 223.97 400.00 100-51-5144-340 ELECTIONS-OPERATING EXPENSE 5,880.00 4,339.36 2,800.00 1,674.46 2,800.00 100-51-5144-390 ELECTIONS-POLL WORKERS 4,080.00 4,148.38 1,900.00 1,877.50 2,700.00 100-51-5151-120 TREASURER-WAGES 30,837.00 32,087.06 33,180.00 25,584.13 31,357.00 100-51-5151-130 TREASURER-FICA 2,359.00 2,555.31 2,538.00 1,994.18 2,399.00 100-51-5151-135 TREASURER-WI RETIREMENT FUND 2,035.00 2,254.60 2,233.00 1,759.60 2,038.00 100-51-5151-140 TREASURER-INSURANCES 6,199.00 12,248.24 14,691.00 12,528.76 13,651.00 100-51-5151-310 TREASURER-OFFICE EXPENSE 1,200.00 2,965.21 2,500.00 2,220.88 2,200.00 100-51-5151-311 TREASURER-COMPUTER SUP/EXP 5,500.00 3,100.81 3,500.00 2,462.09 2,800.00 100-51-5151-320 TREASURER-PUB/SUB/DUES 120.00 274.41 100.00 60.00 60.00 100-51-5151-330 TREASURER-TRAVEL 200.00 .00 .00 .00 .00 100-51-5151-331 TREASURER-TRAINING 1,500.00 694.00 1,000.00 150.75 1,000.00 100-51-5151-340 TREASURER-OPERATING SUPPLIES 500.00 815.90 500.00 78.20 200.00 100-51-5151-390 TREASURER-OTHER EXPENSE 100.00 2,093.72 100.00 .00 100.00 100-51-5153-120 ASSESS OF PROPERTY-WAGES 200.00 150.00 300.00 200.00 400.00 100-51-5153-130 ASSESS OF PROPERTY-FICA 30.00 11.49 19.00 15.30 30.60 100-51-5153-210 ASSESS OF PROPERTY-PROF SERV 12,200.00 12,200.00 12,900.00 10,117.31 27,050.00 100-51-5153-340 ASSESS OF PROPERTY-OPER SUPPL .00 .00 .00 28.89 50.00 100-51-5153-390 ASSESS OF PROPERTY-OTHER EXP 150.00 81.36 100.00 103.86 125.00 100-51-5157-210 INDEPENDENT AUDITING-PRO SERVI 25,000.00 33,170.00 30,000.00 30,675.00 30,700.00 100-51-5161-210 ATTORNEY-PROFESSIONAL SERVICE 10,000.00 5,856.45 7,000.00 7,511.25 8,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 5 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5161-290 ATTORNEY-PROSECUTION 2,000.00 1,882.50 1,000.00 805.00 1,000.00 100-51-5162-120 OTHER MUNI BLDG-WAGES .00 .00 .00 35.00 .00 100-51-5162-130 OTHER MUNI BLDG-FICA .00 .00 .00 2.68 .00 100-51-5162-135 OTHER MUNI BLDG-WI RET FUND .00 .00 .00 2.36 .00 100-51-5162-140 OTHER MUNI BLDG-INSURANCES .00 .00 .00 20.82 .00 100-51-5162-220 OTHER MUNI BLDG-UTILITY SERVIC 4,365.00 3,414.00 4,000.00 2,794.54 3,500.00 100-51-5162-350 OTHER MUNI BLDG-REP/MAIN SUPPL .00 463.97 785.00 .00 585.00 100-51-5162-390 OTHER MUNI BLDG-OTHER SUPP/EX 100.00 124.27 100.00 55.00 100.00 100-51-5163-210 COD OF ORDIN.-PROFESSIONAL SER .00 .00 2,400.00 2,205.36 .00 100-51-5171-120 MUNI BLDG-WAGES 2,307.00 4,675.05 5,893.00 2,886.48 6,117.00 100-51-5171-130 MUNI BLDG-FICA 176.00 354.17 451.00 224.36 468.00 100-51-5171-135 MUNI BLDG-WI RET FUND 170.00 66.47 367.00 28.99 66.00 100-51-5171-140 MUNI BLDG-INSURANCES 1,228.00 363.02 64.00 194.27 404.00 100-51-5171-210 MUNI BLDG-PROFESSIONAL SERVICE 4,000.00 1,348.71 2,000.00 688.22 1,200.00 100-51-5171-220 MUNI BLDG-UTILITY SERVICES 15,000.00 12,746.92 15,000.00 10,577.93 13,000.00 100-51-5171-230 MUNI BLDG-REPAIR/MAIN SERVICES 500.00 .00 100.00 269.00 100.00 100-51-5171-340 MUNI BLDG-OPERATING EXPENSE 1,500.00 762.69 1,500.00 748.65 1,000.00 100-51-5171-350 MUNI BLDG-REP/MAIN EXPENSE 1,000.00 341.50 1,300.00 221.94 3,000.00 100-51-5171-390 MUNI BLDG-SUPPLIES/EXPENSE 2,000.00 1,583.62 2,000.00 1,958.52 1,700.00 100-51-5194-510 PROPERTY/LIABILITY INSURANCE 34,000.00 34,198.00 20,724.16 19,110.11 23,552.00 100-51-5195-390 UNEMPLOYMENT ASSESSMENT 1,400.00 .00 .00 2.06 .00 100-51-5196-510 WORKER'S COMP INSURANCE 16,000.00 10,637.00 14,383.17 9,957.54 15,053.00 PUBLIC SAFTEY 100-52-5210-120 POLICE ADMIN-WAGES 85,591.00 87,873.89 89,625.00 77,159.61 92,160.00 100-52-5210-125 POLICE ADMIN-VACATION PAYOUT .00 113.72 .00 .00 .00 100-52-5210-130 POLICE ADMIN-FICA 6,548.00 7,018.55 6,856.00 6,011.57 7,050.00 100-52-5210-135 POLICE ADMIN-WI RET FUND 7,842.00 5,680.08 5,226.00 4,202.85 5,225.00 100-52-5210-140 POLICE ADMIN-INSURANCES 19,525.00 14,839.81 14,439.00 13,074.68 14,706.00 100-52-5210-190 POLICE ADMIN-UNIFORM ALLOWANC 600.00 334.39 600.00 .00 600.00 100-52-5210-320 POLICE ADMIN -PUB/SUB/DUES 150.00 .00 150.00 .00 150.00 100-52-5210-390 POLICE ADMIN-OTHER SUP/EXPENSE 100.00 28.72 100.00 .00 100.00 100-52-5211-120 POLICE PATROL-WAGES 123,262.00 109,008.19 132,147.00 87,845.49 146,713.00 100-52-5211-125 POLICE PATROL-VACATION PAYOUT .00 1,932.82 .00 .00 .00 100-52-5211-130 POLICE PATROL-FICA 9,430.00 8,873.69 10,109.00 7,094.65 11,224.00 100-52-5211-135 POLICE PATROL-WI RET FUND 9,794.00 12,783.56 13,198.00 10,553.08 15,260.00 100-52-5211-140 POLICE PATROL-INSURANCES 39,407.00 22,907.40 23,559.00 21,270.81 25,660.00 100-52-5211-190 POLICE PATROL-UNIFORM ALLOWAN 1,400.00 1,024.26 1,400.00 468.71 1,400.00 100-52-5211-210 POLICE PATROL-PROFESSIONAL SER 1,000.00 153.00 500.00 .00 500.00 100-52-5211-220 POLICE PATROL-TELEPHONE 6,500.00 3,828.98 3,800.00 3,168.54 3,800.00 100-52-5211-230 POLICE PATROL-VEHICLE LEASE 5,800.00 5,258.44 5,800.00 5,258.44 5,800.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 6 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-52-5211-310 POLICE PATROL-OFFICE SUPPL/EXP 2,000.00 1,705.71 1,000.00 2,731.30 3,200.00 100-52-5211-311 POLICE PATROL-COMPUTER SUPPO 7,800.00 12,566.40 12,000.00 11,021.29 10,800.00 100-52-5211-330 POLICE PATROL-TRAIN/TRAVEL EXP 1,000.00 671.82 1,000.00 1,759.82 2,000.00 100-52-5211-340 POLICE PATROL-OPERATING SUP/EX 1,000.00 2,383.09 2,200.00 2,506.61 1,300.00 100-52-5211-350 POLICE PATROL-REPAIR/MAIN SUPP .00 278.56 100.00 1,081.59 500.00 100-52-5211-370 POLICE PATROL-VEH MAINT/REPAIR 2,000.00 673.32 2,000.00 2,569.14 2,000.00 100-52-5211-371 POLICE PATROL-GAS 5,000.00 4,124.88 5,000.00 4,127.51 5,000.00 100-52-5211-390 POLICE PATROL-OTHER SUPP/EXPEN 1,200.00 1,413.53 1,000.00 436.41 1,000.00 100-52-5232-290 FIRE SUPPRESSION-HYDRANT RENT 139,389.00 139,389.00 139,389.00 116,157.50 139,389.00 100-52-5232-390 FIRE SUPPRESSION-OTHER 500.00 2,068.16 1,590.00 413.00 1,000.00 100-52-5232-590 FIRE SUPPRESSION-FIRE CALLS 1,000.00 1,380.00 1,200.00 575.00 1,000.00 100-52-5232-591 FIRE SUPPRESSION-F.A. BUDGET 44,073.00 44,073.00 44,073.00 44,073.00 53,737.20 100-52-5232-592 FIRE SUPPRESSION-2% FIRE DUES 3,400.00 4,029.64 4,060.00 4,449.35 4,000.00 100-52-5241-210 BUILDING INSPECTION-PRO SERVIC 8,000.00 18,737.74 8,000.00 29,100.88 14,000.00 100-52-5241-310 BLDG INSP-OFFICE SUPPLIES .00 .00 .00 25.84 50.00 PUBLIC WORKS 100-53-5323-120 GARAGE-WAGES 20,910.00 23,496.84 26,068.00 16,465.68 33,433.00 100-53-5323-125 GARAGE-VACATION PAYOUT .00 120.18 6,601.20 4,682.81 .00 100-53-5323-130 GARAGE-FICA 1,660.00 1,860.28 2,500.00 1,629.66 2,558.00 100-53-5323-135 GARAGE-WI RETIREMENT FUND 1,544.00 1,641.48 2,105.00 1,421.34 2,061.00 100-53-5323-140 GARAGE-INSURANCES 11,134.00 7,552.17 9,457.00 6,352.67 12,583.00 100-53-5323-210 GARAGE-CELL PHONES 900.00 750.88 1,275.00 1,147.19 900.00 100-53-5323-220 GARAGE-UTILITY SERVICES 12,000.00 11,320.55 12,000.00 9,922.51 11,500.00 100-53-5323-320 GARAGE-LEASE PAYMENT .00 .00 13,742.00 6,870.60 13,742.00 100-53-5323-340 GARAGE-OPERATING SUPPLIES 7,000.00 8,186.02 7,000.00 7,608.16 8,000.00 100-53-5323-341 GARAGE-TOOL REPLACEMENT 1,000.00 1,344.67 1,500.00 986.59 1,500.00 100-53-5323-380 GARAGE-UNIFORM ALLOWANCE .00 .00 .00 .00 380.00 100-53-5323-390 GARAGE-OTHER EXPENSE 2,500.00 3,835.46 2,880.00 2,286.63 3,800.00 100-53-5324-120 MACH/EQUIPMENT-WAGES 27,841.00 39,347.61 40,450.00 29,039.01 43,903.00 100-53-5324-125 MACH/EQUIP-VACATION PAYOUT .00 200.30 .00 .00 .00 100-53-5324-130 MACH/EQUIPMENT-FICA 2,130.00 3,106.48 3,171.00 2,274.16 3,358.00 100-53-5324-135 MACH/EQUIPMENT-WI RET FUND 2,055.00 2,740.14 2,638.00 2,003.65 2,707.00 100-53-5324-140 MACH/EQUIPMENT-INSURANCES 14,824.00 15,006.93 15,038.00 12,285.58 16,524.00 100-53-5324-340 MACH/EQUIPMENT-OPER SUP/EXP 2,300.00 2,284.91 3,500.00 3,849.23 4,000.00 100-53-5324-350 MACH/EQUIPMENT-REPAIR/MAINT 1,000.00 1,256.92 2,000.00 2,973.43 4,000.00 100-53-5324-370 MACH/EQUIPMENT-VEHICLE MAINT 3,000.00 3,712.56 3,300.00 3,357.09 3,500.00 100-53-5324-371 MACH/EQUIPMENT-GAS 1,500.00 1,630.67 1,500.00 1,840.11 2,000.00 100-53-5324-390 MACH/EQUIPMENT-OTHER 250.00 389.04 500.00 594.94 1,000.00 100-53-5330-120 STREETS/ALLEYS-WAGES 2,419.00 2,644.62 2,991.00 2,173.45 3,168.00 100-53-5330-125 STREETS/ALLEYS-VACATION PAYOUT .00 160.24 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 7 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5330-130 STREETS/ALLEYS-FICA 185.00 218.92 229.00 167.18 242.00 100-53-5330-135 STREETS/ALLEYS-WI RET FUND 179.00 191.62 190.00 147.50 195.00 100-53-5330-140 STREETS/ALLEYS-INSURANCES 1,288.00 1,088.16 1,085.00 806.30 1,192.00 100-53-5330-320 STREETS/ALLEYS-LEASE PAYMENT 10,996.00 10,899.39 10,900.00 10,899.39 10,900.00 100-53-5330-340 STREETS/ALLEYS-OPERATING SUP/E 2,000.00 762.25 1,000.00 213.57 1,000.00 100-53-5330-350 STREETS/ALLEYS-REP/MAIN SUPPLI 1,500.00 788.40 1,000.00 278.19 2,000.00 100-53-5330-370 STREETS/ALLEYS-ROADWAY SUPPLI 25,000.00 22,364.38 25,000.00 16,639.38 25,000.00 100-53-5330-390 STREETS/ALLEYS-OTHER SUP/EXP 1,600.00 28.32 100.00 .00 200.00 100-53-5331-120 BRIDGES/CULVERTS-WAGES 60.00 .00 72.00 42.06 75.00 100-53-5331-130 BRIDGES/CULVERTS-FICA 5.00 .00 6.00 3.22 6.00 100-53-5331-135 BRIDGES/CULVERTS-WI RET FUND 4.00 .00 5.00 2.84 5.00 100-53-5331-140 BRIDGES/CULVERTS-INSURANCES 32.00 .00 26.00 18.55 28.00 100-53-5331-340 BRIDGES/CULVERTS-OPERATING SU 200.00 490.11 200.00 .00 500.00 100-53-5332-120 CURB/GUTTER-WAGES 127.00 56.06 82.00 231.82 86.00 100-53-5332-130 CURB/GUTTER-FICA 10.00 4.28 6.00 17.74 7.00 100-53-5332-135 CURB/GUTTER-WI RET FUND 9.00 3.78 5.00 15.64 5.00 100-53-5332-140 CURB/GUTTER-INSURANCES 68.00 23.98 30.00 86.93 32.00 100-53-5333-120 STREET CLEANING-WAGES 730.00 .00 106.00 26.97 2,435.00 100-53-5333-130 STREET CLEANING-FICA 56.00 .00 8.00 2.06 186.00 100-53-5333-135 STREET CLEANING-WI RET FUND 54.00 .00 7.00 1.82 152.00 100-53-5333-140 STREET CLEANING-INSURANCES 389.00 .00 39.00 9.45 983.00 100-53-5333-320 ST CLEANING-LEASE PAYMENT .00 .00 .00 .00 20,900.00 100-53-5333-350 STREET CLEANING-CONTRACTED SE 6,000.00 3,877.50 7,000.00 3,630.00 .00 100-53-5333-370 STREET CLEANING-VEHICLE MAINT .00 .00 .00 .00 500.00 100-53-5333-371 STREET CLEANING-GAS .00 .00 .00 .00 1,200.00 100-53-5334-120 SNOW/ICE REMOVAL-WAGES 10,653.00 12,479.51 11,901.00 11,040.64 12,783.00 100-53-5334-125 SNOW/ICE REMOVAL-VAC PAYOUT .00 360.54 .00 .00 .00 100-53-5334-130 SNOW/ICE REMOVAL-FICA 815.00 942.26 882.00 889.06 977.00 100-53-5334-135 SNOW/ICE REMOVAL-WI RET FUND 787.00 831.40 734.00 784.45 788.00 100-53-5334-140 SNOW/ICE REMOVAL-INSURANCES 5,672.00 2,508.32 4,183.00 4,034.02 4,810.00 100-53-5334-320 SNOW/ICE REMOVAL-LEASE PAYMEN 10,996.00 10,899.38 10,900.00 10,899.38 10,900.00 100-53-5334-340 SNOW/ICE REMOVAL-OPERATING SU 3,000.00 2,271.62 3,000.00 3,341.54 4,000.00 100-53-5334-370 SNOW/ICE REMOVAL-VEHICLE MAIN 6,000.00 6,493.79 6,000.00 4,069.30 6,000.00 100-53-5334-371 SNOW/ICE REMOVAL-GAS 3,000.00 2,937.06 3,000.00 2,266.56 3,500.00 100-53-5334-390 SNOW/ICE REMOVAL-MISC SUP/EXP 13,000.00 .00 13,000.00 9,834.20 15,000.00 100-53-5335-120 TRAFFIC CONTROL-WAGES 1,315.00 1,196.34 1,257.00 836.76 1,330.00 100-53-5335-130 TRAFFIC CONTROL-FICA 101.00 94.27 96.00 65.33 101.00 100-53-5335-135 TRAFFIC CONTROL-WI RET FUND 97.00 83.17 80.00 57.63 82.00 100-53-5335-140 TRAFFIC CONTROL-INSURANCES 700.00 558.55 455.00 304.64 500.00 100-53-5335-340 TRAFFIC CONTROL-OPER SUPPLIES 2,500.00 2,394.52 2,500.00 2,263.29 2,500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 8 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5335-390 TRAFFIC CONTROL-SUPP/EXP 1,000.00 1,516.10 1,500.00 2,171.98 2,000.00 100-53-5336-120 TREE/BRUSH-WAGES 4,197.00 8,400.68 8,316.00 9,612.32 8,808.00 100-53-5336-125 TREE/BRUSH-VACATION PAYOUT .00 80.12 .00 .00 .00 100-53-5336-130 TREE/BRUSH-FICA 321.00 673.16 636.16 761.96 673.00 100-53-5336-135 TREE/BRUSH-WI RET FUND 310.00 591.48 529.00 648.58 543.00 100-53-5336-140 TREE/BRUSH-INSURANCES 2,234.00 3,590.91 3,017.00 4,098.47 3,315.00 100-53-5336-370 TREE/BRUSH-VEHICLE MAINTENANC 500.00 371.66 500.00 114.53 500.00 100-53-5336-371 TREE/BRUSH-GAS 300.00 526.83 300.00 925.54 500.00 100-53-5336-390 TREE/BRUSH-SUPPLIES/EXPENSE .00 .00 .00 600.00 4,000.00 100-53-5342-220 STREET LIGHTING 27,500.00 30,363.33 27,500.00 25,349.55 27,500.00 100-53-5343-120 SDWALKS/CROSSWALKS-WAGES 561.00 .00 27.00 26.97 29.00 100-53-5343-130 SDWALKS/CROSSWALKS-FICA 43.00 .00 2.00 2.06 2.00 100-53-5343-135 SDWALKS/CROSSWALKS-WI RET FND 41.00 .00 2.00 1.82 2.00 100-53-5343-140 SDWALKS/CROSSWALKS- INSURANC 299.00 .00 10.00 8.50 11.00 100-53-5343-290 SDWALKS/CROSSWALKS-CONTRACT .00 .00 1,500.00 .00 1,500.00 100-53-5344-120 STORM SEWER-WAGES 1,117.00 862.09 1,140.00 1,182.35 1,247.00 100-53-5344-130 STORM SEWER-FICA 85.00 65.98 90.00 90.43 95.00 100-53-5344-135 STORM SEWER-WI RET FUND 83.00 58.19 75.00 76.88 77.00 100-53-5344-140 STORM SEWER-INSURANCES 595.00 338.44 427.00 390.52 470.00 100-53-5344-350 STORM SEWER-REPAIR/MAIN SUPPLI 500.00 436.33 4,500.00 1,373.06 1,500.00 100-53-5344-390 STORM SEWER-SUPPLIES/EXPENSE 500.00 466.90 500.00 100.00- 500.00 100-53-5345-120 PARKING LOTS-WAGES 49.00 .00 500.00 42.06 529.00 100-53-5345-130 PARKING LOTS-FICA 4.00 .00 39.00 3.22 41.00 100-53-5345-135 PARKING LOTS-WI RET FUND 4.00 .00 32.00 2.84 32.00 100-53-5345-140 PARKING LOTS-INSURANCES 20.00 .00 181.00 16.55 200.00 100-53-5345-220 PARKING LOTS-UTILITY SERVICES 350.00 315.28 350.00 415.63 420.00 100-53-5362-120 GARBAGE COLLECTION-WAGES 1,202.00 1,767.05 1,072.00 1,277.04 1,335.00 100-53-5362-130 GARBAGE COLLECTION-FICA 92.00 136.16 90.00 98.30 87.00 100-53-5362-135 GARBAGE COLLECTION-WI RET FND 89.00 120.10 68.00 86.63 70.00 100-53-5362-140 GARBAGE COLLECTION- INSURANCE 640.00 865.11 388.00 694.84 428.00 100-53-5362-210 GARBAGE COLLECTION-PROF SERVI 68,387.00 76,184.85 71,000.00 53,373.28 71,000.00 100-53-5362-371 GARBAGE COLLECTION-GAS 100.00 210.69 .00 .00 200.00 100-53-5362-390 GARBAGE COLLECTION-OTHER EXP 300.00 1,425.00 950.00 450.00 4,500.00 100-53-5363-120 TRANSFER STATION-WAGES 814.00 170.49 257.00 139.67 271.00 100-53-5363-125 TRANSFER STATION-VAC PAYOUT .00 80.12 .00 .00 .00 100-53-5363-130 TRANSFER STATION-FICA 62.00 19.17 20.00 10.69 20.00 100-53-5363-135 TRANSFER STATION-WI RET FUND 60.00 16.92 16.00 9.43 16.00 100-53-5363-140 TRANSFER STATION-INSURANCES 433.00 37.44 93.00 60.31 102.00 100-53-5363-220 TRANSFER STATION-UTILITY SERVI 350.00 324.47 300.00 273.08 300.00 100-53-5363-290 TRANSFER STATION-CONTRACT SER 2,500.00 2,507.00 2,000.00 1,553.50 2,500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 9 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5363-390 TRANSFER STATION-OTHER SUPP/EP 1,000.00 1,246.06 1,500.00 165.00 1,500.00 100-53-5365-120 RECYCLING-WAGES 6,920.00 9,827.61 9,413.00 4,666.25 6,483.00 100-53-5365-125 RECYCLING-VACATION PAYOUT .00 120.18 .00 .00 .00 100-53-5365-130 RECYCLING-FICA 529.00 772.73 720.00 360.90 497.00 100-53-5365-135 RECYCLING-WI RET FUND 511.00 675.63 599.00 315.52 398.00 100-53-5365-140 RECYCLING-INSURANCES 3,684.00 3,821.45 3,415.00 1,962.19 2,374.00 100-53-5365-210 RECYCLING-PROFESSIONAL SERVIC 25,000.00 27,241.07 25,000.00 18,782.72 25,000.00 100-53-5365-340 RECYCLING-OPERATING SUPPLIES .00 .00 .00 .00 200.00 100-53-5365-370 RECYCLING-VEHICLE MAINTENANCE .00 1,473.19 1,000.00 743.34 1,000.00 100-53-5365-371 RECYCLING-GAS 100.00 165.74 200.00 797.18 1,000.00 100-53-5422-290 ENGINEERING-STORM SEWERS 1,500.00 1,979.50 1,000.00 .00 1,000.00 100-53-5424-290 ENGINEERING-STREET 10,000.00 2,636.50 5,000.00 405.00 5,000.00 100-53-5429-290 ENGINEERING-OTHER 5,000.00 253.00 2,500.00 710.00 2,500.00 HEALTH AND HUMAN SERVICES 100-54-5410-290 RETIRED PERSONS HEALTH INSURA .00 .00 5,297.00 .00 6,094.80 100-54-5414-290 ANIMAL POUND-CONTRACT SERVICE 300.00 .00 300.00 .00 300.00 100-54-5910-120 CEMETERY-WAGES 13,362.00 14,624.49 14,320.00 9,227.39 9,947.00 100-54-5910-125 CEMETERY-VACATION PAYOUT .00 40.06 .00 .00 .00 100-54-5910-130 CEMETERY-FICA 1,022.00 1,121.42 1,097.00 706.33 761.00 100-54-5910-135 CEMETERY-WI RETIREMENT FUND .00 112.60 229.00 142.28 40.00 100-54-5910-140 CEMETERY-INSURANCES .00 631.58 40.00 905.48 251.00 100-54-5910-210 CEMETERY-CONTRACTED SERVICES 3,000.00 115.00 2,000.00 .00 4,000.00 100-54-5910-220 CEMETERY-UTILITY SERVICES 350.00 414.03 380.00 319.08 400.00 100-54-5910-340 CEMETERY-OPERATING SUPPLIES 1,200.00 1,154.93 1,000.00 1,735.60 1,200.00 100-54-5910-350 CEMETERY-REPAIR/MAIN EXPENSE 1,000.00 1,519.69 1,000.00 259.09 1,000.00 100-54-5910-390 CEMETERY-SUPPLIES/EXPENSE 450.00 77.58 450.00 40.00 1,000.00 CULTURE,RECREATION & EDUCATION 100-55-5157-210 INDEPENDENT AUDITING-LIBRARY 1,100.00 3,845.00 1,200.00 2,070.00 2,500.00 100-55-5511-120 LIBRARY-WAGES 66,793.00 62,573.00 66,396.00 52,618.62 70,206.00 100-55-5511-130 LIBRARY-FICA 5,110.00 4,920.16 5,079.00 4,095.88 5,371.00 100-55-5511-135 LIBRARY-WI RETIREMENT FUND 2,520.00 2,781.33 2,648.00 2,328.16 2,767.00 100-55-5511-140 LIBRARY-INSURANCES 19,836.00 17,948.52 19,514.00 17,145.29 20,836.00 100-55-5511-145 LIBRARY-WORKERS COMP INS .00 .00 2,025.35 1,749.28 1,768.00 100-55-5511-220 LIBRARY-UTILITY SERVICES 6,000.00 5,555.46 6,000.00 4,323.73 6,000.00 100-55-5511-290 LIBRARY-CONTRACTUAL SERVICES 8,500.00 9,680.50 9,000.00 8,873.02 9,500.00 100-55-5511-310 LIBRARY-OFFICE SUPPLIES 2,500.00 770.67 2,500.00 913.72 2,500.00 100-55-5511-315 LIBRARY-ADULT & JUVENILE PROGR 4,000.00 2,555.92 4,000.00 2,081.27 4,000.00 100-55-5511-320 LIBRARY-SUBSCRIPTIONS/MAGAZINE 2,000.00 815.60 1,500.00 982.45 1,200.00 100-55-5511-331 LIBRARY-TRAINING 1,000.00 985.70 1,000.00 746.50 1,000.00 100-55-5511-340 LIBRARY-OPERATING SUPP/MISC 3,000.00 2,930.71 3,000.00 1,660.19 3,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 10 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5511-350 LIBRARY-REP/MAIN BLDG & EQUIPT 3,000.00 7,080.22 3,000.00 1,810.58 3,000.00 100-55-5511-390 LIBRARY-MATERIALS 20,000.00 16,871.36 20,000.00 13,729.52 20,000.00 100-55-5515-390 HARRIET O'CONNELL SUPP/EXPENSE 1,500.00 1,197.77 1,500.00 336.67 1,500.00 100-55-5520-120 PARKS-WAGES 25,999.00 33,823.21 37,433.00 38,399.36 33,929.00 100-55-5520-125 PARKS-VACATION PAYOUT .00 1,339.22 .00 .00 .00 100-55-5520-130 PARKS-FICA 1,989.00 2,690.74 2,864.00 2,958.67 2,596.00 100-55-5520-135 PARKS-WI RETIREMENT FUND 1,919.00 2,345.79 2,383.00 2,362.30 2,093.00 100-55-5520-140 PARKS-INSURANCES 13,843.00 13,438.16 13,580.00 15,135.95 12,770.00 100-55-5520-220 PARKS-UTILITY SERVICES 2,500.00 2,644.13 2,250.00 2,159.19 2,100.00 100-55-5520-340 PARKS-OPERATING SUPPLIES 3,400.00 3,487.10 3,400.00 2,999.45 3,500.00 100-55-5520-350 PARKS-REPAIR/MAINT SUP/EXP 1,000.00 2,271.63 1,250.00 4,305.25 3,000.00 100-55-5520-370 PARKS-VEHICLE MAINTENANCE 1,500.00 1,362.31 1,250.00 166.26 1,500.00 100-55-5520-371 PARKS-GAS 1,500.00 1,389.68 1,500.00 1,747.99 3,000.00 100-55-5520-390 PARKS-SUPPLIES/EXPENSE 1,000.00 1,441.60 1,000.00 1,815.01 2,000.00 100-55-5530-120 CELEBRATIONS-WAGES 1,302.00 653.89 748.00 447.83 791.00 100-55-5530-130 CELEBRATIONS-FICA 100.00 163.16 57.00 39.58 61.00 100-55-5530-135 CELEBRATIONS-WI RET FUND 96.00 136.25 48.00 34.96 49.00 100-55-5530-140 CELEBRATIONS-INSURANCES 693.00 194.79 271.00 247.75 298.00 100-55-5530-340 CELEBRATIONS-OPERATING SUPPLIE .00 62.09 .00 .00 400.00 100-55-5530-390 CELEBRATIONS-OTHER SUP/EXPENS 8,790.00 7,044.77 7,540.00 6,046.52 8,840.00 100-55-5541-120 WATER RECREATION-WAGES 50.00 164.24 181.00 .00 191.00 100-55-5541-130 WATER RECREATION-FICA 4.00 12.56 14.00 .00 15.00 100-55-5541-135 WATER RECREATION-WI RET FUND 4.00 11.09 12.00 .00 11.00 100-55-5541-140 WATER RECREATION-INSURANCES 10.00 .00 66.00 .00 72.00 100-55-5541-340 WATER RECREATION-OPER SUP/EXP 1,200.00 1,205.79 1,200.00 1,616.10 2,000.00 100-55-5541-350 WATER RECREATION-REP/MAIN SUP 100.00 8.00 500.00 .00 1,000.00 100-55-5542-120 SWIMMING POOL-WAGES 3,885.00 3,132.98 3,732.00 4,111.99 3,690.00 100-55-5542-130 SWIMMING POOL-FICA 296.00 239.66 285.00 314.60 282.00 100-55-5542-135 SWIMMING POOL-WI RET FUND 255.00 175.95 252.00 277.54 239.00 100-55-5542-140 SWIMMING POOL-INSURANCES 1,581.00 819.41 1,373.00 1,580.47 1,479.00 100-55-5542-210 SWIMMING POOL-PROFESSIONAL SE 1,000.00 1,770.44 1,700.00 4,853.37 500.00 100-55-5542-220 SWIMMING POOL-UTILITY SERVICES 9,000.00 6,426.78 9,000.00 9,540.61 9,800.00 100-55-5542-290 SWIMMING POOL-CONTRACTUAL SE 35,500.00 26,479.17 32,500.00 34,333.97 35,500.00 100-55-5542-310 SWIMMING POOL-OFFICE SUPPLIES 20.00 .00 20.00 .00 50.00 100-55-5542-331 SWIMMING POOL-CONCESSIONS 1,500.00 .00 1,500.00 1,144.12 1,500.00 100-55-5542-340 SWIMMING POOL-OPERATING SUPPL 3,500.00 3,193.38 3,500.00 2,848.88 3,000.00 100-55-5542-350 SWIMMING POOL-CHEMICALS 8,000.00 1,663.87 5,000.00 2,291.00 4,000.00 100-55-5542-351 SWIMMING POOL-REP/MAINT SUP/EX .00 .00 .00 .00 4,500.00 100-55-5542-390 SWIMMING POOL-SUPP/EXPENSE 4,000.00 3,929.90 4,000.00 3,231.56 2,000.00 100-55-5543-120 OTHER SUMMER REC-WAGES 23.00 .00 538.00 .00 560.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 11 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5543-130 OTHER SUMMER REC-FICA 2.00 .00 41.00 .00 42.00 100-55-5543-135 OTHER SUMMER REC-WI RET FUND 2.00 .00 34.00 .00 34.00 100-55-5543-140 OTHER SUMMER REC-INSURANCES 12.00 .00 195.00 .00 215.00 100-55-5543-390 OTHER SUMMER REC-SUP/EXP .00 210.18 200.00 190.70 220.00 100-55-5544-120 OTHER WINTER REC-WAGES .00 .00 26.00 .00 27.00 100-55-5544-130 OTHER WINTER REC-FICA .00 .00 2.00 .00 2.00 100-55-5544-135 OTHER WINTER REC-WI RET FUND .00 .00 2.00 .00 2.00 100-55-5544-140 OTHER WINTER REC-INSURANCES .00 .00 10.00 .00 10.00 CONSERVATION & DEVELOPMENT 100-56-5364-120 WEED CONTROL-WAGES 1,518.00 2,164.74 942.00 982.49 1,028.00 100-56-5364-125 WEED CONTROL-VACATION PAYOUT .00 689.64 .00 .00 .00 100-56-5364-130 WEED CONTROL-FICA 116.00 218.35 72.00 75.16 79.00 100-56-5364-135 WEED CONTROL-WI RET FUND 112.00 192.67 60.00 66.32 64.00 100-56-5364-140 WEED CONTROL-INSURANCES 808.00 643.51 342.00 387.81 387.00 100-56-5364-210 WEED CONTROL-PROFESSIONAL SE 500.00 200.00 500.00 1,050.00 500.00 100-56-5364-350 WEED CONTROL-REPAIR/MAIN SUPP 100.00 809.35 100.00 7.04 100.00 100-56-5364-370 WEED CONTROL-VEHICLE MAINTENA .00 356.67 500.00 .00 500.00 100-56-5364-371 WEED CONTROL-GAS 100.00 87.19 100.00 .00 200.00 100-56-5364-390 WEED CONTROL-SUPP/EXPENSE 1,000.00 1,616.27 1,800.00 2,343.37 1,500.00 100-56-5611-120 FORESTRY-WAGES 406.00 932.40 1,494.00 611.81 1,582.00 100-56-5611-125 FORESTRY-VACATION PAYOUT .00 529.40 .00 .00 .00 100-56-5611-130 FORESTRY-FICA 31.00 111.83 114.00 46.78 121.00 100-56-5611-135 FORESTRY-WI RET FUND 30.00 98.65 95.00 41.30 98.00 100-56-5611-140 FORESTRY-INSURANCES 216.00 311.93 542.00 159.78 595.00 100-56-5611-210 FORESTRY-CONTRACTED SERVICES 3,000.00 600.00 2,000.00 250.00 2,000.00 100-56-5611-340 FORESTRY-OPERATING SUPPLIES .00 36.83 .00 .00 .00 100-56-5611-390 FORESTRY-SUPPLIES/EXPENSE 500.00 480.54 600.00 39.58 500.00 100-56-5670-120 ECON DEVELOPMENT-WAGES .00 26.47 29.00 80.91 31.00 100-56-5670-130 ECON DEVELOPMENT-FICA .00 2.02 2.00 6.18 3.00 100-56-5670-135 ECON DEVELOPMENT-WI RET FUND .00 1.79 2.00 5.46 2.00 100-56-5670-140 ECON DEVELOPMENT-INSURANCES .00 8.50 11.00 27.04 12.00 100-56-5670-390 ECON DEVELOPMENT-SUP/EXPENSE 240.00 276.04 240.00 315.32 300.00 100-56-5690-120 DAM-WAGES 5,000.00 3,297.70 3,423.00 2,116.76 3,625.00 100-56-5690-130 DAM-FICA 400.00 256.80 262.00 165.34 277.00 100-56-5690-135 DAM-WI RET FUND 300.00 226.53 218.00 146.07 223.00 100-56-5690-140 DAM-INSURANCES 2,000.00 1,120.29 1,242.00 822.94 1,365.00 100-56-5690-210 DAM-PROFESSIONAL SERVICES 1,000.00 300.00 500.00 .00 500.00 100-56-5690-350 DAM-REPAIR/MAINTENANCE EXPENS .00 .00 200.00 .00 200.00 100-56-5690-390 DAM-OTHER SUPPLIES/EXPENSE 200.00 40.03 200.00 .00 200.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 12 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget DEBT SERVICE 100-58-5800-000 TRANSFER OUT TO CEMETERY LGIP .00 .00 .00 .00 .00 100-58-5915-610 PRINCIPLE - SHORT TERM LOAN .00 .00 .00 .00 .00 100-58-5915-620 INTEREST - SHORT TERM LOAN .00 .00 .00 .00 .00 100-58-5918-610 PRINCIPAL - R.D.A. 48,535.88 41,385.46 .00 .00 .00 100-58-5918-620 INTEREST - R.D.A. 1,688.90 1,688.90 .00 .00 .00 OTHER FINANCING USES 100-59-5900-205 TRANSFER OUT TO 205 88,963.20 0.20 .00 .00 .00 100-59-5900-301 TRANSFER OUT TO 301 124,488.18 124,488.18 74,626.84 74,626.84 148,655.81 100-59-5900-400 TRANSFER OUT TO 400 .00 139,616.00 264,269.64 105,532.38 63,660.00 GENERAL FUND Revenue Total: 1,866,074.16 1,771,475.17 2,018,229.81 1,386,496.51 1,981,181.41 GENERAL FUND Expenditure Total: 1,866,074.16 1,886,407.78 1,982,558.07 1,545,259.73 1,981,181.41 Net Total GENERAL FUND: .00 114,932.61- 35,671.74 158,763.22- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 13 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget REVOLVING LOAN S/R FUND MISCELLANEOUS REVENUE 202-48-4810-000 INTEREST 100.00 68.70 80.00 4.76 15.00 Total MISCELLANEOUS REVENUE: 100.00 68.70 80.00 4.76 15.00 CAPITAL OUTLAY 202-57-5710-310 ADMINISTRATIVE EXPENSE 500.00 30.00 100.00 3,655.03 500.00 REVOLVING LOAN S/R FUND Revenue Total: 100.00 68.70 80.00 4.76 15.00 REVOLVING LOAN S/R FUND Expenditure Total: 500.00 30.00 100.00 3,655.03 500.00 Net Total REVOLVING LOAN S/R FUND: 400.00- 38.70 20.00- 3,650.27- 485.00- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 14 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget REDEVELOPMENT AUTHORITY FUND MISCELLANEOUS REVENUE 205-48-4800-000 TRANSFER IN 88,963.02 0.20 88,963.20 88,963.20 88,973.20 205-48-4810-000 INTEREST 50.00 .00 .00 .00 .00 205-48-4815-000 RDA 1.2M 2019-INTEREST REVENUE .00 708.00 .00 .00 .00 205-48-4850-000 MISCELLANEOUS REVENUE 19,440.00 67,683.83 17,812.00 14,887.45 16,000.00 Total MISCELLANEOUS REVENUE: 108,453.02 68,392.03 106,775.20 103,850.65 104,973.20 GENERAL GOVERMENT 205-51-5157-210 INDEPENDENT AUDITING 3,100.00 3,524.00 3,100.00 3,100.00 3,100.00 CAPITAL OUTLAY 205-57-5710-310 ADMINISTRATIVE EXPENSE 1,500.00 23,506.16 10,000.00 4,390.00 3,000.00 DEBT SERVICE 205-58-5813-610 RDA 1.2M 2019 - PRINCIPAL 41,179.61 39,612.76 43,083.92 21,501.57 44,943.39 205-58-5813-620 RDA 1.2M 2019 - INTEREST 47,783.59 49,350.44 45,880.28 22,980.03 44,029.81 REDEVELOPMENT AUTHORITY FUND Revenue Total: 108,453.02 68,392.03 106,775.20 103,850.65 104,973.20 REDEVELOPMENT AUTHORITY FUND Expenditure Total: 93,563.20 115,993.36 102,064.20 51,971.60 95,073.20 Net Total REDEVELOPMENT AUTHORITY FUND: 14,889.82 47,601.33- 4,711.00 51,879.05 9,900.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 15 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget ARPA FUND INTERGOVERNMENTAL REVENUES 206-43-4361-000 ARPA GRANT .00 .00 .00 75,832.37 75,832.37 Total INTERGOVERNMENTAL REVENUES: .00 .00 .00 75,832.37 75,832.37 OTHER FINANCING SOURCES 206-49-4930-000 FUNDS APPLIED .00 .00 .00 .00 35,000.00 Total OTHER FINANCING SOURCES: .00 .00 .00 .00 35,000.00 GENERAL GOVERNMENT 206-51-5140-120 COVID SICK LEAVE .00 .00 .00 2,460.14 2,332.37 206-51-5140-310 ADMINISTRATIVE EXPENSE .00 .00 .00 1,139.72 1,250.00 PUBLIC SAFETY 206-52-5210-000 PUBLIC HEALTH .00 .00 .00 .00 62,250.00 CULTURE,RECREATION & EDUCATION 206-55-5520-000 RECREATION .00 .00 .00 .00 45,000.00 206-55-5530-000 HOSPITALITY/TOURISM SUPPORT .00 .00 .00 2,030.00 .00 OTHER FINANCING USES 206-59-5900-400 TRANSFERS OUT TO 400 .00 .00 .00 26,381.15 .00 ARPA FUND Revenue Total: .00 .00 .00 75,832.37 110,832.37 ARPA FUND Expenditure Total: .00 .00 .00 32,011.01 110,832.37 Net Total ARPA FUND: .00 .00 .00 43,821.36 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 16 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget DEBT SERVICE FUND OTHER FINANCING SOURCES 301-49-4900-100 TRANSFER IN FROM GENERAL FUND 124,488.18 124,488.18 74,626.84 74,626.84 148,655.81 Total OTHER FINANCING SOURCES: 124,488.18 124,488.18 74,626.84 74,626.84 148,655.81 GENERAL GOVERMENT 301-51-5157-210 INDEPENDENT AUDITING 800.00 800.00 500.00 500.00 500.00 DEBT SERVICE 301-58-5811-610 STFL 2018 $557,000 PRINCIPAL 17,884.03 17,884.03 18,748.18 18,748.18 19,591.85 301-58-5811-620 STFL 2018 $557,000 INTEREST 21,729.53 21,729.53 20,865.38 20,865.38 20,021.71 301-58-5812-610 STFL $367,795 PRINCIPAL 67,215.98 67,215.98 .00 .00 .00 301-58-5812-620 STFL $367,795 INTEREST 2,022.00 2,022.00 .00 .00 .00 301-58-5820-610 $527,000 PRINC CITY SHARE 52% 5,770.07 5,770.07 6,032.65 6,032.65 6,307.17 301-58-5820-620 $527,000 INT CITY SHARE 52% 9,066.57 9,066.57 8,803.99 8,803.99 8,529.47 301-58-5827-610 STFL 2020 $150,000 PRINCIPLE .00 .00 13,332.46 13,332.46 15,234.94 301-58-5827-620 STFL 2020 $150,000 INTEREST .00 .00 6,344.18 6,344.18 4,441.70 301-58-5828-610 STFL 2021 $560,000 PRIN 68.68% .00 .00 .00 .00 14,058.10 301-58-5828-620 STFL 2021 $650,000 INT 68.68% .00 .00 .00 .00 14,162.00 301-58-5829-610 STFL 2021 $127,225 PRINCIPLE .00 .00 .00 .00 24,404.87 301-58-5829-620 STFL 2021 $127,225 INTEREST .00 .00 .00 .00 2,927.92 301-58-5830-610 STFL 2021 $86,000 PRINCIPLE .00 .00 .00 .00 16,496.90 301-58-5830-620 STFL 2021 $86,000 INTEREST .00 .00 .00 .00 1,979.18 DEBT SERVICE FUND Revenue Total: 124,488.18 124,488.18 74,626.84 74,626.84 148,655.81 DEBT SERVICE FUND Expenditure Total: 124,488.18 124,488.18 74,626.84 74,626.84 148,655.81 Net Total DEBT SERVICE FUND: .00 .00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 17 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAPITAL IMPROVEMENTS FUND MISCELLANEOUS REVENUE 400-48-4850-000 MISCELLANEOUS REVENUES .00 1,577.00 .00 10,435.00 .00 400-48-4851-704 GRANT-CDBG-PF-2020 .00 .00 703,491.00 .00 .00 Total MISCELLANEOUS REVENUE: .00 1,577.00 703,491.00 10,435.00 .00 MISCELLANEOUS REVENUE 400-48-4851-750 GRANT - OTHER .00 .00 .00 500.00- .00 OTHER FINANCING SOURCES 400-49-4900-101 LOAN PROCEEDS .00 .00 127,225.00 127,225.00 305,000.00 400-49-4900-102 LOAN PROCEEDS-GREEN STREET .00 .00 560,000.00 560,000.00 .00 400-49-4900-204 TRANSFER IN FROM GENERAL FUND .00 .00 264,269.64 105,532.38 63,660.00 400-49-4900-206 TRANSFERS IN FROM ARPA FUND .00 .00 .00 26,381.15 .00 400-49-4900-400 TRSFR IN FROM GENERAL OUTLAY 139,616.00 139,616.00 .00 .00 .00 400-49-4900-701 TRANSFER IN FROM CEMETERY PC 7,400.00 7,400.00 3,000.00 2,810.94 .00 400-49-4930-000 FUNDS APPLIED .00 .00 .00 10,000.00 .00 Total OTHER FINANCING SOURCES: 147,016.00 147,016.00 954,494.64 831,949.47 368,660.00 GENERAL GOVERMENT 400-51-5120-810 MUNICIPAL COURT-CAPITAL EQUIPM 3,836.00 2,748.00 2,320.00 .00 .00 400-51-5140-810 MSA ADMINISTRATIVE COSTS .00 10.00 .00 .00 .00 400-51-5142-810 CLERK-CAPITAL EQUIPMENT .00 .00 .00 529.78 .00 400-51-5151-810 TREASURER-CAPITAL EQUIPMENT 1,500.00 .00 .00 .00 .00 400-51-5162-810 OTHER MUNI BLDG-CAPITAL EQUIPM .00 .00 8,700.00 4,200.00 9,824.00 400-51-5162-820 OTHER MUNI BLDG-CAPITAL IMPROV .00 .00 .00 .00 .00 400-51-5171-810 MUNI BLDG-CAPITAL EQUIPMENT 17,980.00 17,980.00 .00 1,679.89 .00 400-51-5171-820 MUNI BLDG-CAPITAL IMPROVEMENT 11,400.00 6,258.52 .00 2,419.39 .00 PUBLIC SAFTEY 400-52-5211-810 POLICE PATROL-CAPITAL EQUIPMT 15,500.00 .00 .00 677.85 5,600.00 400-52-5211-820 POLICE PATROL-CAPITAL IMPROV 1,600.00 1,761.60 19,069.00 19,459.00 .00 400-52-5232-810 FIRE SUPPRESSION-CAPITAL EQUIP .00 .00 146,725.00 146,672.39 8,652.00 PUBLIC WORKS 400-53-5323-810 GARAGE-CAPITAL EQUIPMENT 11,550.00 13,342.98 .00 .00 .00 400-53-5323-820 GARAGE-CAPITAL IMPROVEMENT .00 .00 .00 .00 .00 400-53-5324-810 MACH/EQUIP-CAPITAL EQUIPMENT 11,500.00 10,240.00 .00 6,750.00 24,111.00 400-53-5330-810 STREETS/ALLEYS-CAPITAL EQUIP .00 .00 .00 2,285.00 .00 400-53-5330-820 STREETS/ALLEYS-CAPITAL IMPROV 23,000.00 22,768.00 43,854.00 714.64 285,350.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 18 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 400-53-5330-830 TRENTON ST-CAPITAL IMPROVEMEN .00 391.58 .00 2,320.44 .00 400-53-5330-845 SECOND ST-CAPITAL IMPROVEMENT .00 .00 .00 .00 .00 400-53-5330-850 GREEN ST-CAPITAL IMPROVEMENTS .00 .00 1,132,737.00 634,273.93 .00 400-53-5344-810 STORM SEWER-CAPITAL EQUIPMENT .00 35,500.00 .00 .00 .00 400-53-5344-820 STORM SEWER-CAPITAL IMPROVEME .00 6,255.85 66,218.00 .00 .00 400-53-5344-825 STORM SEWER-CAPITAL IMPV-ARPA .00 .00 .00 26,381.15 .00 400-53-5424-830 TRENTON STREET- ENGINEERING .00 662.46 .00 .00 .00 400-53-5424-850 GREEN ST-ENGINEERING .00 30,030.00 130,754.00 94,389.75 .00 HEALTH AND HUMAN SERVICES 400-54-5910-810 CEMETERY-CAPITAL EQUIPMENT 7,400.00 7,400.00 3,000.00 2,810.94 .00 CULTURE,RECREATION & EDUCATION 400-55-5511-810 LIBRARY-CAPITAL EQUIPMENT .00 .00 2,500.00 2,196.61 4,000.00 400-55-5511-820 LIBRARY-CAPITAL IMPROVEMENT .00 4,046.63 3,750.00 3,239.83 1,500.00 400-55-5520-810 PARKS-CAPITAL EQUIPMENT 11,500.00 10,239.99 2,500.00 2,200.00 6,000.00 400-55-5520-820 PARKS-CAPITAL IMPROVEMENT .00 .00 10,000.00 11,034.60 .00 400-55-5542-810 SWIMMING POOL-CAPITAL EQUIPME 30,250.00 85,730.75 50,186.00 20,132.33 21,323.00 400-55-5542-820 SWIMMING POOL-CAPITAL IMPROVE .00 .00 .00 .00 2,300.00 DEBT SERVICE 400-58-5820-610 PRINCIPAL ON LOANS .00 .00 35,500.00 35,500.00 .00 400-58-5820-620 INTEREST ON LOANS .00 382.00 172.64 447.40 .00 OTHER FINANCING USES 400-59-5900-100 TRANSFER OUT TO GENERAL FUND .00 .00 .00 .00 .00 CAPITAL IMPROVEMENTS FUND Revenue Total: 147,016.00 148,593.00 1,657,985.64 842,384.47 368,660.00 CAPITAL IMPROVEMENTS FUND Expenditure Total: 147,016.00 255,748.36 1,657,985.64 1,019,814.92 368,660.00 Net Total CAPITAL IMPROVEMENTS FUND: .00 107,155.36- .00 177,430.45- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 19 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget TIF #2 CAPITAL PROJECTS FUND TIF #2 INCREMENT 401-41-4112-000 TIF #2 INCREMENT 63,443.00 67,824.00 62,831.00 160,424.00 198,167.00 Total TIF #2 INCREMENT: 63,443.00 67,824.00 62,831.00 160,424.00 198,167.00 INTERGOVERNMENTAL REVENUES 401-42-4250-000 STATE AID-EXEMPT COMPUTERS "T" .00 2,382.00 .00 2,382.39 2,382.39 401-42-4259-000 STATE AID-OTHER GRANTS .00 2,692.18 5,334.20 5,334.20 2,692.18 Total INTERGOVERNMENTAL REVENUES: .00 5,074.18 5,334.20 7,716.59 5,074.57 MISCELLANEOUS REVENUE 401-48-4851-700 GRANT-WI DEPT OF TRANSPORTATIO .00 .00 31,759.51 .00 .00 Total MISCELLANEOUS REVENUE: .00 .00 31,759.51 .00 .00 OTHER FINANCING SOURCES 401-49-4910-000 LOAN PROCEEDS .00 .00 .00 86,000.00 .00 Total OTHER FINANCING SOURCES: .00 .00 .00 86,000.00 .00 GENERAL GOVERMENT 401-51-5140-120 ADMIN/OFFICE-WAGES .00 .00 .00 .00 15,408.00 401-51-5140-140 ADMIN/OFFICE-INSURANCES .00 .00 .00 .00 2,537.00 401-51-5140-310 ADMINISTRATIVE EXPENSE 2,650.00 10,862.23 3,000.00 9,526.14 10,000.00 401-51-5157-210 INDEPENDENT AUDITING 4,250.00 1,975.50 2,000.00 1,875.00 2,000.00 PUBLIC WORKS 401-53-5330-800 MILL RD-CAPITAL IMPROVEMENTS .00 .00 116,880.00 113,160.05 .00 CAPITAL OUTLAY 401-57-5700-790 BUSINESS INCENTIVES .00 504,999.00 .00 38,765.27 .00 401-57-5700-791 COVID-19 BUSINESS LOANS .00 26,600.00 .00 .00 .00 401-57-5700-792 DOWNTOWN BUSINESS SUPPORT PR .00 21,668.35 .00 26,914.89 .00 401-57-5700-795 TIF #2 LAND PURCHASES .00 5,350.00 .00 40,597.62 .00 401-57-5710-820 TIF #2 EXPENDITURES .00 .00 .00 7,341.72 .00 401-57-5740-130 ADMIN/OFFICE-FICA .00 .00 .00 .00 1,179.00 401-57-5740-135 ADMIN/OFFICE-WIS RET FUND .00 .00 .00 .00 1,002.00 DEBT SERVICE 401-58-5810-610 STFL $390,000 PRINCIPAL 6,288.66 6,288.66 15,514.94 15,514.94 16,213.11 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 20 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 401-58-5820-620 STFL $390,000 INTEREST 26,493.29 26,493.29 17,267.01 17,267.01 16,569.84 401-58-5830-610 STFL $800,000 PRI TIF#2 SHARE .00 .00 16,065.62 16,065.62 23,505.41 401-58-5830-620 STFL $800,000 INT TIF#2 SHARE .00 .00 29,524.83 29,524.83 23,505.41 TIF #2 CAPITAL PROJECTS FUND Revenue Total: 63,443.00 72,898.18 99,924.71 254,140.59 203,241.57 TIF #2 CAPITAL PROJECTS FUND Expenditure Total: 39,681.95 604,237.03 200,252.40 316,553.09 111,919.77 Net Total TIF #2 CAPITAL PROJECTS FUND: 23,761.05 531,338.85- 100,327.69- 62,412.50- 91,321.80 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 21 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget TIF #3 FUND TAXES 402-41-4112-000 TIF #3 INCREMENT 16,190.00 75,030.00 37,910.00 96,795.00 102,733.00 Total TAXES: 16,190.00 75,030.00 37,910.00 96,795.00 102,733.00 MISCELLANEOUS REVENUE 402-48-4810-000 INTEREST 120.00 1,288.48 60.00 13.48 15.00 Total MISCELLANEOUS REVENUE: 120.00 1,288.48 60.00 13.48 15.00 GENERAL GOVERMENT 402-51-5140-120 ADMIN/OFFICE-WAGES .00 .00 .00 .00 15,408.00 402-51-5140-130 ADMIN/OFFICE-FICA .00 .00 .00 .00 1,179.00 402-51-5140-135 ADMIN/OFFICE-WIS RET FUND .00 .00 .00 .00 1,002.00 402-51-5140-140 ADMIN/OFFICE-INSURANCES .00 .00 .00 .00 2,537.00 402-51-5140-310 ADMINISTRATIVE EXPENSE 15,000.00 2,303.32 1,650.00 7,127.74 50,000.00 402-51-5157-210 INDEPENDENT AUDITING 4,250.00 1,975.50 2,000.00 1,875.00 2,000.00 PUBLIC WORKS 402-53-5330-820 STREETS/ALLEYS -CAPITAL IMPROV .00 2,450.08 .00 .00 .00 TIF #3 CAPITAL PROJECTS 402-57-5700-791 LEROY MEATS INCENTIVE 22,500.00 22,500.00 4,500.00 4,500.00 .00 402-57-5700-792 GLOBAL TECH INCENTIVE 10,000.00 10,000.00 .00 .00 .00 402-57-5700-793 DOLLAR GENERAL INCENTIVE 20,000.00 24,034.46 25,965.54 23,740.50 2,225.04 402-57-5700-794 VALLIDO HOMES INCENTIVE .00 .00 .00 .00 100,000.00 DEBT SERVICE 402-58-5820-620 ERGO BANK INTEREST 1.2M .00 46,042.00 .00 .00 .00 402-58-5820-630 INTEREST ON TIF ADVANCE .00 2,654.00 .00 .00 .00 402-58-5830-610 STFL $800,000 PRI TIF#3 SHARE .00 .00 5,178.18 5,178.18 7,576.13 402-58-5830-620 STFL $800,000 INT TIF#3 SHARE .00 .00 9,516.27 9,516.27 7,118.32 OTHER FINANCING USES 402-59-5900-205 TRANSFER OUT TO 205 .00 .00 88,963.20 88,963.20 88,973.20 TIF #3 FUND Revenue Total: 16,310.00 76,318.48 37,970.00 96,808.48 102,748.00 TIF #3 FUND Expenditure Total: 71,750.00 111,959.36 137,773.19 140,900.89 278,018.69 Net Total TIF #3 FUND: 55,440.00- 35,640.88- 99,803.19- 44,092.41- 175,270.69- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 22 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 23 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAP PROJ-MUNICIPAL BLDG FUND MISCELLANEOUS REVENUE 403-48-4811-000 INTEREST 100.00 76.24 .00 .00 .00 403-48-4815-000 CAPITAL LEASE INTEREST REVENUE 1,688.90 1,688.90 .00 .00 .00 403-48-4915-000 CAPITAL LEASE PRINCIPAL REVENU 48,535.88 41,385.46 .00 .00 .00 Total MISCELLANEOUS REVENUE: 50,324.78 43,150.60 .00 .00 .00 GENERAL GOVERMENT 403-51-5157-210 INDEPENDENT AUDITING 500.00 76.00 .00 .00 .00 DEBT SERVICE 403-58-5919-610 RDA 4/19/96 1M PRINCIPAL 48,535.88 134,800.00 .00 .00 .00 403-58-5919-620 RDA 4/19/96 1M INTEREST 1,688.90 1,688.90 .00 .00 .00 CAP PROJ-MUNICIPAL BLDG FUND Revenue Total: 50,324.78 43,150.60 .00 .00 .00 CAP PROJ-MUNICIPAL BLDG FUND Expenditure Total: 50,724.78 136,564.90 .00 .00 .00 Net Total CAP PROJ-MUNICIPAL BLDG FUND: 400.00- 93,414.30- .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 24 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAP PROJ-RURAL DEV GRANT FUND MISCELLANEOUS REVENUE 404-48-4800-000 TRANSFER IN .00 14,837.00 .00 .00 .00 Total MISCELLANEOUS REVENUE: .00 14,837.00 .00 .00 .00 CAPITAL OUTLAY 404-57-5711-620 INTEREST EXPENSE .00 9,002.00 .00 .00 .00 CAP PROJ-RURAL DEV GRANT FUND Revenue Total: .00 14,837.00 .00 .00 .00 CAP PROJ-RURAL DEV GRANT FUND Expenditure Total: .00 9,002.00 .00 .00 .00 Net Total CAP PROJ-RURAL DEV GRANT FUND: .00 5,835.00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 25 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget WATER DEPARTMENT FUND WATER SALES REVENUE 610-41-4190-000 INTEREST ON TEMP INVESTMENT 360.00 1,181.64 205.00 66.48 65.00 610-41-4610-000 RESIDENTIAL REVENUE 167,000.00 178,332.10 167,000.00 149,669.25 181,000.00 610-41-4612-000 COMMERCIAL REVENUE 20,000.00 23,533.97 24,000.00 21,439.58 25,700.00 610-41-4612-100 MULTI FAMILY REVENUE 17,000.00 13,242.97 17,000.00 12,063.22 14,600.00 610-41-4613-000 INDUSTRIAL REVENUE 33,000.00 34,570.82 33,000.00 40,008.51 48,500.00 610-41-4614-000 REVENUE-PUBLIC AUTHORITIES 11,000.00 8,121.19 8,500.00 6,118.90 7,495.00 610-41-4620-000 PRIVATE FIRE PROTECTION 5,000.00 5,592.00 5,600.00 3,390.00 5,600.00 610-41-4630-000 PUBLIC FIRE PROTECTION 139,389.00 139,389.00 139,389.00 116,157.50 139,389.00 610-41-4700-000 FORFEITED DISCOUNTS 1,000.00 310.42 1,000.00 469.70 500.00 610-41-4730-000 GAIN(LOSS)ON SALE OF ASSET .00 .00 .00 2,887.50 .00 610-41-4740-000 OTHER WATER REVENUE 500.00 8,471.72 100.00 3,329.03 100.00 610-41-4750-000 WATER CONNECTION CHARGES 1,000.00 .00 .00 5,000.00 .00 Total WATER SALES REVENUE: 395,249.00 412,745.83 395,794.00 360,599.67 422,949.00 SOURCE: 43 610-43-4361-000 COVID-19 CARES GRANT .00 2,708.87 .00 .00 .00 Total SOURCE: 43: .00 2,708.87 .00 .00 .00 OTHER FINANCING SOURCES 610-49-4900-200 TRANS IN FROM LGIP WATER OUTLA 235,000.00 .00 .00 .00 .00 Total OTHER FINANCING SOURCES: 235,000.00 .00 .00 .00 .00 PUBLIC WORKS 610-53-0403-000 DEPRECIATION EXPENSE 75,000.00 77,566.00 75,000.00 .00 77,500.00 610-53-0403-001 DEPRECIATION EXPENSE-CIAC 29,000.00 27,799.00 29,000.00 .00 27,000.00 610-53-0408-000 WATER DEPARTMENT-FICA 5,442.00 6,178.27 5,544.00 5,284.80 6,093.00 610-53-0408-100 WATER DEPARTMENT-TAX EQUIVALE 73,304.00 67,989.01 76,500.00 63,346.70 76,500.00 610-53-0427-000 INTEREST ON LONG TERM DEBT 7,630.68 10,580.29 10,349.11 10,349.11 10,702.24 610-53-0600-000 WATER DEPARTMENT-WAGES 59,299.00 64,055.72 60,794.00 56,930.78 60,068.00 610-53-0600-125 WATER DEPARTMENT-VAC PAYOUT .00 .00 .00 745.70 .00 610-53-0600-140 WATER DEPARTMENT-INSURANCE .00 5,405.19 .00 3,463.52 .00 610-53-0620-000 PURCHASED POWER 10,000.00 10,422.86 9,500.00 8,368.14 9,500.00 610-53-0630-000 CHEMICALS 7,000.00 8,653.06 7,500.00 5,937.16 10,000.00 610-53-0640-000 OPERATING SUPPLIES & EXPENSE 8,000.00 12,213.03 11,400.00 10,888.67 12,500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 26 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 610-53-0640-220 UTILITY SERVICES 1,000.00 1,218.76 1,100.00 823.98 1,000.00 610-53-0650-000 REPAIR TO WATER PLANT 7,000.00 4,172.07 10,000.00 9,896.16 26,000.00 610-53-0660-000 TRANSPORTATION EXPENSE 3,500.00 3,312.52 3,000.00 5,228.39 5,800.00 610-53-0670-000 WATER DEPARTMENT-CAPITAL EQUIP 42,830.00 1,628.85 13,889.00 11,535.07 6,000.00 610-53-0670-100 WATER DEPTARTMENT-CAPITAL IMPR 235,000.00 96.65 .00 .00 36,000.00 610-53-0670-811 WATER DEPARTMENT-CAPITAL CARR 15,000.00 411.12 .00 .00 .00 610-53-0680-000 WATER DEPARTMENT-ADMIN SALARY 11,927.00 15,318.04 11,680.00 10,327.51 19,580.00 610-53-0680-140 WATER DEPARTMENT-ADMIN INSURA .00 574.46 .00 330.16 .00 610-53-0681-000 OFFICE SUPPLIES & EXPENSE 4,400.00 2,948.29 2,500.00 3,088.88 3,500.00 610-53-0682-000 OUTSIDE PROFESSIONAL SERVICES 11,500.00 10,109.45 10,000.00 8,972.07 12,000.00 610-53-0682-100 WATER DEPARTMENT-COMPUTER SU 200.00 4,659.83 3,750.00 4,033.86 5,000.00 610-53-0682-200 INDEPENDENT AUDITING 10,500.00 8,558.39 10,000.00 7,355.47 8,000.00 610-53-0683-000 CELL PHONE & ALARM CHARGES 800.00 529.82 800.00 754.67 950.00 610-53-0684-000 INSURANCE EXPENSE .00 .00 11,693.41 10,157.07 12,483.00 610-53-0686-000 EMP PENSION/HEALTH/LIFE WATER 26,382.00 15,534.70 28,245.00 24,085.61 30,927.00 610-53-0686-100 WORKERS COMPENSATION INSURAN .00 .00 1,536.74 1,327.09 1,526.00 610-53-0686-200 WATER DEPT EDUCATION-TRAINING .00 .00 .00 519.50 800.00 610-53-0688-000 REGULATORY COMMISSION EXPENS 125.00 125.00 125.00 606.70 125.00 610-53-0689-000 MISCELLANEOUS GENERAL EXPENS 2,000.00 60.00 .00 390.00 390.00 610-53-0689-100 WATER DEPARTMENT-UNIFORM ALL 350.00 375.34 350.00 227.91 350.00 DEBT SERVICE 610-58-5917-610 PRINCIPAL DEBT SERVICE 26,972.00 .00 28,081.99 .00 30,670.85 WATER DEPARTMENT FUND Revenue Total: 630,249.00 415,454.70 395,794.00 360,599.67 422,949.00 WATER DEPARTMENT FUND Expenditure Total: 674,161.68 360,495.72 422,338.25 264,974.68 490,965.09 Net Total WATER DEPARTMENT FUND: 43,912.68- 54,958.98 26,544.25- 95,624.99 68,016.09- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 27 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget SEWER DEPARTMENT FUND SEWER SALES REVENUE 620-41-4190-000 INTEREST ON TEMP INVEST 2,700.00 618.80 205.00 57.86 36.00 620-41-4210-000 RESIDENTIAL REVENUE 360,000.00 378,018.65 360,000.00 314,921.06 380,000.00 620-41-4210-001 MISC NON-OPERATING REVENUE .00 .00 .00 13,853.67 .00 620-41-4220-000 COMMERCIAL REVENUE 87,000.00 84,955.14 87,000.00 76,602.91 92,200.00 620-41-4230-000 INDUSTRIAL REVENUE 130,000.00 143,942.11 130,000.00 175,188.65 212,700.00 620-41-4240-000 PUBLIC AUTHORITY REVENUE 12,000.00 10,856.24 12,000.00 8,311.52 9,500.00 620-41-4720-000 FUNDS APPLIED .00 .00 82,500.00 .00 .00 620-41-6320-000 PENALTIES 1,500.00 620.59 1,500.00 839.38 1,500.00 620-41-6340-000 MISC. OPERATING REVENUES 3,500.00 19,103.23 9,250.00 7,157.68 9,500.00 620-41-6350-000 SEWER CONNECTION CHARGES .00 .00 .00 7,500.00 .00 Total SEWER SALES REVENUE: 596,700.00 638,114.76 682,455.00 604,432.73 705,436.00 SOURCE: 43 620-43-4361-000 COVID-19 CARES GRANT .00 2,708.87 .00 .00 .00 Total SOURCE: 43: .00 2,708.87 .00 .00 .00 PUBLIC WORKS 620-53-0082-000 SEWER DEPARTMENT-WAGES 55,414.00 57,750.78 63,622.00 44,767.31 65,866.00 620-53-0082-125 SEWER DEPARTMENT-VAC PAYOUT .00 .00 .00 745.70 .00 620-53-0082-140 SEWER DEPT/INS/DISABLE/DENTAL .00 4,811.28 .00 2,222.62 .00 620-53-0403-000 DEPRECIATION OF EXPENSE 156,000.00 161,047.00 159,000.00 .00 160,000.00 620-53-0408-000 SEWER DEPARTMENT-FICA 5,145.00 5,700.23 5,761.00 4,344.82 6,537.00 620-53-0427-000 INTEREST ON LONG TERM DEBT 43,910.00 34,728.10 33,945.31 33,945.31 38,076.57 620-53-0429-000 INCOME FROM JOINT VENTURE .00 7,990.00 .00 .00 .00 620-53-0620-000 POWER PURCHASED FOR PUMPING 17,000.00 15,990.19 16,000.00 12,788.75 16,300.00 620-53-0826-000 CELL PHONE & ALARM CHARGES 1,100.00 835.68 1,100.00 1,105.58 1,000.00 620-53-0827-000 OPERATING SUPPLIES & EXPENSE 15,200.00 19,415.05 7,000.00 10,689.10 1,400.00 620-53-0827-220 UTILITY SERVICES 1,800.00 2,369.07 2,500.00 2,000.90 2,500.00 620-53-0828-000 TRANSPORTATION EXPENSE 3,500.00 2,502.11 3,000.00 4,457.76 3,500.00 620-53-0829-000 SEWER DEPARTMENT-CAPITAL EQUI 29,330.00 855.63 13,889.00 6,359.00 .00 620-53-0829-100 SEWER DEPARTMENT-CAPITAL IMPR .00 .00 82,500.00 10,032.03 15,000.00 620-53-0829-811 SEWER DEPARTMENT-CAPITAL CARR .00 1,762.31 .00 .00 .00 620-53-0831-000 MAINT OF SEWERAGE COLL SYSTEM .00 7,966.39 6,000.00 5,518.96 6,000.00 620-53-0832-000 MAINT OF PUMP STATION EQUIP 8,000.00 21,022.85 8,000.00 9,725.70 8,000.00 620-53-0833-000 MAINT OF CHALET GRINDER PUMP 500.00 1,080.86 1,000.00 .00 1,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 28 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 620-53-0834-000 MAINT/REPAIR BLDGS & GROUNDS 1,000.00 2,384.15 1,500.00 13,546.17 3,800.00 620-53-0850-000 SEWER DEPARTMENT-ADMIN SALARI 11,927.00 15,318.04 11,680.00 10,256.51 19,580.00 620-53-0850-140 SEWER DEPARTMENT-OFF WAGES/IN .00 574.45 .00 330.18 .00 620-53-0851-000 GEN OFFICE SUPPLIES & EXPENSE 4,500.00 3,219.36 3,500.00 3,292.80 3,500.00 620-53-0851-100 FLWCC BUDGET EXPENSE 120,000.00 127,999.39 120,000.00 132,935.60 120,000.00 620-53-0851-101 FLWCC FUTURE RESERVE FUND .00 .00 .00 .00 .00 620-53-0851-102 FLWCC COPPER SURCHARGE 1,000.00 .00 1,000.00 .00 1,000.00 620-53-0851-103 FLWCC SLUDGE REMOVAL/LINER 56,250.00 56,250.50 56,250.00 124,467.00 56,250.00 620-53-0852-000 OUTSIDE PROFESSIONAL SERVICES 7,500.00 4,774.32 7,600.00 2,016.70 5,000.00 620-53-0852-100 SEWER DEPARTMENT-COMPUTER S 500.00 2,974.32 3,750.00 4,034.00 5,500.00 620-53-0852-200 INDEPENDENT AUDITING 10,200.00 7,945.90 9,500.00 7,355.48 9,000.00 620-53-0853-000 INSURANCE EXPENSE .00 .00 7,419.43 10,818.82 6,439.00 620-53-0854-000 EMP PENSION/BENEFIT/HEALTH/LIF 26,382.00 14,303.28 28,882.00 21,147.74 31,620.00 620-53-0854-100 WORKERS COMPENSATION INSURAN .00 .00 1,536.74 942.85 1,526.00 620-53-0856-000 MISC. GENERAL EXPENSE .00 326.86 .00 .00 .00 620-53-0856-100 SEWER DEPARTMENT-UNIFORM ALL 350.00 375.35 350.00 227.91 350.00 620-53-0857-000 RENT 10,000.00 3,532.00 .00 .00 .00 DEBT SERVICE 620-58-5917-610 PRINCIPAL DEBT SERVICE 52,606.00 .00 52,606.00 .00 42,979.96 SEWER DEPARTMENT FUND Revenue Total: 596,700.00 640,823.63 682,455.00 604,432.73 705,436.00 SEWER DEPARTMENT FUND Expenditure Total: 639,114.00 585,805.45 708,891.48 480,075.30 631,724.53 Net Total SEWER DEPARTMENT FUND: 42,414.00- 55,018.18 26,436.48- 124,357.43 73,711.47 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 29 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CEMETERY NONEXP TRUST FUND MISCELLANEOUS REVENUE 701-48-4800-000 TRANSFER IN .00 .00 .00 .00 .00 701-48-4810-000 INTEREST 300.00 1,964.64 1,190.00 1,450.64 750.00 Total MISCELLANEOUS REVENUE: 300.00 1,964.64 1,190.00 1,450.64 750.00 DEBT SERVICE 701-58-5800-000 TRANSFER OUT 7,400.00 7,400.00 3,000.00 2,810.94 .00 CEMETERY NONEXP TRUST FUND Revenue Total: 300.00 1,964.64 1,190.00 1,450.64 750.00 CEMETERY NONEXP TRUST FUND Expenditure Total: 7,400.00 7,400.00 3,000.00 2,810.94 .00 Net Total CEMETERY NONEXP TRUST FUND: 7,100.00- 5,435.36- 1,810.00- 1,360.30- 750.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 30 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget ROBERTS EXP TRUST FUND MISCELLANEOUS REVENUE 802-48-4810-000 INTEREST 40.00 118.76 75.00 43.61 75.00 Total MISCELLANEOUS REVENUE: 40.00 118.76 75.00 43.61 75.00 OTHER FINANCING USES 802-59-5900-390 MISCELLANEOUS EXPENSE 150.00 225.00 200.00 200.00 250.00 ROBERTS EXP TRUST FUND Revenue Total: 40.00 118.76 75.00 43.61 75.00 ROBERTS EXP TRUST FUND Expenditure Total: 150.00 225.00 200.00 200.00 250.00 Net Total ROBERTS EXP TRUST FUND: 110.00- 106.24- 125.00- 156.39- 175.00- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 31 Period: 01/22 Nov 10, 2021 10:21AM 2020-20 2020-20 2021-21 2021-21 2022-22 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget LIBRARY S/R FUND INTERGOVERNMENTAL REVENUES 804-43-4372-000 COUNTY AID 5,746.61 .00 .00 .00 .00 804-43-4373-000 GRANTS - OTHER .00 .00 .00 500.00 .00 804-43-4374-000 HICKS GRANT .00 5,000.00 .00 5,000.00 5,000.00 Total INTERGOVERNMENTAL REVENUES: 5,746.61 5,000.00 .00 5,500.00 5,000.00 MISCELLANEOUS REVENUE 804-48-4810-000 INTEREST 25,000.00 19,400.18 15,000.00 2.96 15,000.00 804-48-4850-000 DONATIONS 4,000.00 11,570.00 4,000.00 579.00 2,000.00 804-48-4890-000 LIBRARY MISCELLANEOUS REVENUE .00 875.43 500.00 644.82 500.00 Total MISCELLANEOUS REVENUE: 29,000.00 31,845.61 19,500.00 1,226.78 17,500.00 CULTURE,RECREATION & EDUCATION 804-55-5500-000 LIBRARY EXPENDITURES 12,000.00 8,765.32 5,000.00 4,674.18 5,000.00 LIBRARY S/R FUND Revenue Total: 34,746.61 36,845.61 19,500.00 6,726.78 22,500.00 LIBRARY S/R FUND Expenditure Total: 12,000.00 8,765.32 5,000.00 4,674.18 5,000.00 Net Total LIBRARY S/R FUND: 22,746.61 28,080.29 14,500.00 2,052.60 17,500.00 Report Criteria: Accounts to include: With balances or activity Print FUND Titles Page and Total by FUND Print SOURCE Titles Total by SOURCE Print COST CATEGORY Titles All Segments Tested for Total Breaks