Loading...
HomeMy Public PortalAbout2024-01 NO Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 1/10/2024 10:51:09 AM Period 01 - 13 Fiscal Year 2024 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 10,800.00 0.00 55,125.00 83.62 10-110-501015 Salary-Prosecuting Attorney 34,999.92 5,833.32 0.00 29,166.60 83.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)18,146.13 1,289.46 0.00 16,856.67 92.89 10-110-502010 Social Security 9,108.94 1,353.28 0.00 7,755.66 85.14 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 128,251.58 19,347.65 0.00 108,903.93 84.91 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 25.00 8.82 0.00 16.18 64.72 10-110-512010 Printing 350.00 0.00 0.00 350.00 100.00 10-110-512020 Copies 15.00 0.84 0.00 14.16 94.40 10-110-513010 Office Supplies 1,435.00 286.00 0.00 1,149.00 80.07 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,825.00 295.66 0.00 1,529.34 83.80 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 2,400.00 103.64 0.00 2,296.36 95.68 10-110-520030 Dues And Publications 6,500.00 6,476.92 0.00 23.08 0.36 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 800.00 0.00 0.00 800.00 100.00 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 9,700.00 6,580.56 0.00 3,119.44 32.16 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 140.00 0.00 133.72 6.28 4.49 E25 Repairs & Maintenance 140.00 0.00 133.72 6.28 4.49 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 1,000.00 0.00 0.00 1,000.00 100.00 E70 Capital Purchases 1,000.00 0.00 0.00 1,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 140,916.58 26,223.87 133.72 114,558.99 81.2956 Grand Total -140,916.58 -26,223.87 -133.72 -114,558.99 0.813 110 Mayor & Council 140,916.58 26,223.87 133.72 114,558.99 81.30 120 City Clerk 10-120-501020 Salaries 60,416.48 11,153.76 0.00 49,262.72 81.54 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,621.86 798.08 0.00 3,823.78 82.73 10-120-502020 Group Health Insurance 14,599.86 2,136.28 0.00 12,463.58 85.37 10-120-502030 Retirement 7,129.15 1,316.16 0.00 5,812.99 81.54 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 74.66 11.04 0.00 63.62 85.21 10-120-502060 Long Term Disability 184.87 28.36 0.00 156.51 84.66 10-120-502070 Employee Assistance Prgm 21.84 5.11 0.00 16.73 76.60 E05 Personnel Services 87,098.71 15,498.78 0.00 71,599.93 82.21 10-120-511020 Postage 200.00 23.92 0.00 176.08 88.04 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 89.47 0.00 210.53 70.18 10-120-513010 Office Supplies 200.00 13.31 0.00 186.69 93.35 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 126.70 0.00 573.30 81.90 10-120-520030 Dues And Publications 75.00 50.00 0.00 25.00 33.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 0.00 0.00 400.00 100.00 10-120-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-120-529030 Election Expense 39,000.00 46.50 0.00 38,953.50 99.88 E15 Contractual Services 39,675.00 96.50 0.00 39,578.50 99.76 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,675.00 1,195.00 133.72 9,346.28 87.55 E25 Repairs & Maintenance 10,675.00 1,195.00 133.72 9,346.28 87.55 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 138,148.71 16,916.98 133.72 121,098.01 87.6577 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -138,148.71 -16,916.98 -133.72 -121,098.01 0.8766 120 City Clerk 138,148.71 16,916.98 133.72 121,098.01 87.66 140 City Administrator 10-140-501020 Salaries 342,835.98 42,426.96 0.00 300,409.02 87.62 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 26,226.95 3,146.09 0.00 23,080.86 88.00 10-140-502020 Group Health Insurance 27,965.91 4,206.56 0.00 23,759.35 84.96 10-140-502030 Retirement 40,454.65 4,819.36 0.00 35,635.29 88.09 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 411.26 42.10 0.00 369.16 89.76 10-140-502060 Long Term Disability 647.19 93.40 0.00 553.79 85.57 10-140-502070 Employee Assistance Prgm 65.52 10.23 0.00 55.29 84.39 E05 Personnel Services 438,808.68 54,945.92 0.00 383,862.76 87.48 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 75.00 1.41 0.00 73.59 98.12 10-140-513010 Office Supplies 500.00 107.88 0.00 392.12 78.42 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 1,025.00 109.29 0.00 915.71 89.34 10-140-520030 Dues And Publications 1,000.00 0.00 0.00 1,000.00 100.00 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 500.00 0.00 0.00 500.00 100.00 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,500.00 0.00 0.00 1,500.00 100.00 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 300.00 0.00 491.88 -191.88 -63.96 E25 Repairs & Maintenance 300.00 0.00 491.88 -191.88 -63.96 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 441,633.68 55,055.21 491.88 386,086.59 87.4224 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -441,633.68 -55,055.21 -491.88 -386,086.59 0.8742 140 City Administrator 441,633.68 55,055.21 491.88 386,086.59 87.42 141 Local Tourism Asset Develop 10-141-501020 Salaries 82,499.00 0.00 0.00 82,499.00 100.00 10-141-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-141-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-141-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-141-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-141-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 82,499.00 0.00 0.00 82,499.00 100.00 10-141-520072 Subrecipient Reimbursements 2,062,476.00 0.00 0.00 2,062,476.00 100.00 E15 Contractual Services 2,062,476.00 0.00 0.00 2,062,476.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,144,975.00 0.00 0.00 2,144,975.00 100 Grand Total -2,144,975.00 0.00 0.00 -2,144,975.00 1 141 Local Tourism Asset Develop 2,144,975.00 0.00 0.00 2,144,975.00 100.00 142 Community Revitalization 10-142-501020 Salaries 81,276.00 361.27 0.00 80,914.73 99.56 10-142-502010 Social Security 0.00 24.78 0.00 -24.78 0.00 10-142-502020 Group Health Insurance 0.00 63.20 0.00 -63.20 0.00 10-142-502030 Retirement 0.00 42.64 0.00 -42.64 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 0.24 0.00 -0.24 0.00 10-142-502060 Long Term Disability 0.00 0.65 0.00 -0.65 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 492.78 0.00 80,783.22 99.39 10-142-522017 Rehabilitation 378,463.00 0.00 0.00 378,463.00 100.00 10-142-522018 Streetscaping 1,182,000.00 0.00 0.00 1,182,000.00 100.00 10-142-522021 Asbestos Abatement 291,574.00 0.00 0.00 291,574.00 100.00 10-142-522022 Demo 1,179,856.00 0.00 0.00 1,179,856.00 100.00 E15 Contractual Services 3,031,893.00 0.00 0.00 3,031,893.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,113,169.00 492.78 0.00 3,112,676.22 99.9842 Grand Total -3,113,169.00 -492.78 0.00 -3,112,676.22 0.9998 142 Community Revitalization 3,113,169.00 492.78 0.00 3,112,676.22 99.98 143 CDBG-CV Compass Health 10-143-501020 Salaries 11,601.91 0.00 0.00 11,601.91 100.00 10-143-502010 Social Security 361.34 0.00 0.00 361.34 100.00 10-143-502020 Group Health Insurance 1,323.00 0.00 0.00 1,323.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 695.50 0.00 0.00 695.50 100.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 4.92 0.00 0.00 4.92 100.00 10-143-502060 Long Term Disability 13.33 0.00 0.00 13.33 100.00 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 0.00 0.00 14,000.00 100.00 10-143-520072 Subrecipient Reimbursements 100,000.00 0.00 0.00 100,000.00 100.00 E15 Contractual Services 100,000.00 0.00 0.00 100,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,000.00 0.00 0.00 114,000.00 100 Grand Total -114,000.00 0.00 0.00 -114,000.00 1 143 CDBG-CV Compass Health 114,000.00 0.00 0.00 114,000.00 100.00 144 CDBG-DR 10-144-501020 Salaries 230,788.34 0.00 0.00 230,788.34 100.00 10-144-502010 Social Security 1,217.24 0.00 0.00 1,217.24 100.00 10-144-502020 Group Health Insurance 3,460.14 0.01 0.00 3,460.13 100.00 10-144-502030 Retirement 2,187.54 0.00 0.00 2,187.54 100.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 -0.01 0.00 0.01 0.00 10-144-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 237,653.26 0.00 0.00 237,653.26 100.00 10-144-528041 Acquisition for Demo 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528042 New Construction SF 521,928.00 0.00 0.00 521,928.00 100.00 10-144-528043 Multi-Family 4,800,000.00 0.00 0.00 4,800,000.00 100.00 10-144-528044 Down Payment Assistance 50,000.00 0.00 0.00 50,000.00 100.00 10-144-528046 Homeowner Rehab 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528047 Infrastructure 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-144-528048 Public Service 5,000.00 0.00 0.00 5,000.00 100.00 10-144-528049 Planning 250,000.00 0.00 0.00 250,000.00 100.00 E15 Contractual Services 7,026,928.00 0.00 0.00 7,026,928.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 7,264,581.26 0.00 0.00 7,264,581.26 100 Grand Total -7,264,581.26 0.00 0.00 -7,264,581.26 1 144 CDBG-DR 7,264,581.26 0.00 0.00 7,264,581.26 100.00 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 25,274.55 4,022.29 0.00 21,252.26 84.09 10-145-502010 Social Security 320.10 274.45 0.00 45.65 14.26 10-145-502020 Group Health Insurance 367.06 989.96 0.00 -622.90 -169.70 10-145-502030 Retirement 114.61 474.64 0.00 -360.03 -314.13 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 4.48 0.00 -4.48 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 11.45 0.00 -11.45 0.00 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 26,081.34 5,777.27 0.00 20,304.07 77.85 10-145-520072 Subrecipient Reimbursements 1,577,640.06 0.00 0.00 1,577,640.06 100.00 E15 Contractual Services 1,577,640.06 0.00 0.00 1,577,640.06 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,603,721.40 5,777.27 0.00 1,597,944.13 99.6398 Grand Total -1,603,721.40 -5,777.27 0.00 -1,597,944.13 0.9964 145 CDBG-CV Cole Co EMS Station 1,603,721.40 5,777.27 0.00 1,597,944.13 99.64 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 33,921.37 6,947.16 0.00 26,974.21 79.52 10-146-502010 Social Security 0.00 482.51 0.00 -482.51 0.00 10-146-502020 Group Health Insurance 19.26 1,539.33 0.00 -1,520.07 -7,892.37 10-146-502030 Retirement 0.00 819.77 0.00 -819.77 0.00 10-146-502040 Workers Compensation 2.46 2.46 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 7.07 0.00 -7.07 0.00 10-146-502060 Long Term Disability 0.00 18.01 0.00 -18.01 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 33,943.09 9,816.31 0.00 24,126.78 71.08 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 61.82 0.00 0.00 61.82 100.00 E15 Contractual Services 61.82 0.00 0.00 61.82 100.00 10-146-550068 Pass-Through Grants 640,830.00 0.00 0.00 640,830.00 100.00 E65 Other Non-Operating Expenses 640,830.00 0.00 0.00 640,830.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 674,834.91 9,816.31 0.00 665,018.60 98.5454 Grand Total -674,834.91 -9,816.31 0.00 -665,018.60 0.9855 146 HPF-P Bruhn Revitalization 674,834.91 9,816.31 0.00 665,018.60 98.55 147 CDBG-CV Transform Housing 10-147-501020 Salaries 18,486.80 1,880.74 0.00 16,606.06 89.83 10-147-502010 Social Security 299.07 119.48 0.00 179.59 60.05 10-147-502020 Group Health Insurance 537.69 580.87 0.00 -43.18 -8.03 10-147-502030 Retirement 310.64 221.92 0.00 88.72 28.56 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.13 2.33 0.00 -2.20 -1,692.31 10-147-502060 Long Term Disability 0.00 6.12 0.00 -6.12 0.00 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 19,637.77 2,811.46 0.00 16,826.31 85.68 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 543,752.25 0.00 0.00 543,752.25 100.00 E15 Contractual Services 543,752.25 0.00 0.00 543,752.25 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 563,390.02 2,811.46 0.00 560,578.56 99.501 Grand Total -563,390.02 -2,811.46 0.00 -560,578.56 0.995 147 CDBG-CV Transform Housing 563,390.02 2,811.46 0.00 560,578.56 99.50 148 CDBG-CV 10-148-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-148-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-148-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-148-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-148-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-148-528025 CARES-Childcare Services 19,944.00 0.00 0.00 19,944.00 100.00 10-148-528035 CARES-ED For-Profit Business 30,611.00 0.00 0.00 30,611.00 100.00 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 50,555.00 0.00 0.00 50,555.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 50,555.00 0.00 0.00 50,555.00 100 Grand Total -50,555.00 0.00 0.00 -50,555.00 1 148 CDBG-CV 50,555.00 0.00 0.00 50,555.00 100.00 149 Entitlement Grant 10-149-501020 Salaries 70,901.49 10,822.15 0.00 60,079.34 84.74 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 0.00 810.39 0.00 -810.39 0.00 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 0.00 1,579.95 0.00 -1,579.95 0.00 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 0.00 1,277.01 0.00 -1,277.01 0.00 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 0.00 10.42 0.00 -10.42 0.00 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 0.00 26.59 0.00 -26.59 0.00 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 0.00 7.67 0.00 -7.67 0.00 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 70,901.49 14,534.18 0.00 56,367.31 79.50 10-149-511010 Advertising 830.00 0.00 0.00 830.00 100.00 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 200.00 12.81 0.00 187.19 93.60 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,030.00 12.81 0.00 1,017.19 98.76 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 102.25 0.00 1,897.75 94.89 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 2,655.00 0.00 2,005.00 650.00 24.48 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 35,784.00 5,000.00 0.00 30,784.00 86.03 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 109,993.66 0.00 0.00 109,993.66 100.00 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 63,385.80 0.00 0.00 63,385.80 100.00 10-149-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-149-528040 Neighborhood Redevelopmnt 95,609.27 12,500.00 0.00 83,109.27 86.93 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 45,108.00 0.00 0.00 45,108.00 100.00 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 354,535.73 17,602.25 2,005.00 334,928.48 94.47 10-149-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00 10-149-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 426,467.22 32,149.24 2,005.00 392,312.98 91.9914 Grand Total -426,467.22 -32,149.24 -2,005.00 -392,312.98 0.9199 149 Entitlement Grant 426,467.22 32,149.24 2,005.00 392,312.98 91.99 150 City Attorney 10-150-501020 Salaries 251,003.67 50,092.32 0.00 200,911.35 80.04 10-150-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 19,201.78 3,723.07 0.00 15,478.71 80.61 10-150-502020 Group Health Insurance 38,330.74 5,628.12 0.00 32,702.62 85.32 10-150-502030 Retirement 29,618.43 4,083.92 0.00 25,534.51 86.21 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 307.22 46.61 0.00 260.61 84.83 10-150-502060 Long Term Disability 629.25 119.38 0.00 509.87 81.03 10-150-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 339,387.40 63,939.55 0.00 275,447.85 81.16 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 64.56 0.00 435.44 87.09 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 80.79 0.00 -80.79 0.00 10-150-513010 Office Supplies 500.00 55.29 0.00 444.71 88.94 10-150-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,000.00 200.64 0.00 799.36 79.94 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 8,500.00 3,045.22 4,688.10 766.68 9.02 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 8,500.00 0.00 0.00 8,500.00 100.00 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 8,500.00 0.00 0.00 8,500.00 100.00 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 9,641.36 0.00 -9,641.36 0.00 E15 Contractual Services 26,000.00 12,686.58 4,688.10 8,625.32 33.17 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 440.00 0.00 433.68 6.32 1.44 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 440.00 0.00 433.68 6.32 1.44 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 366,827.40 76,826.77 5,121.78 284,878.85 77.6602 Grand Total -366,827.40 -76,826.77 -5,121.78 -284,878.85 0.7766 150 City Attorney 366,827.40 76,826.77 5,121.78 284,878.85 77.66 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 5,833.32 0.00 29,166.60 83.33 10-160-501020 Salaries 142,510.04 26,309.51 0.00 116,200.53 81.54 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 894.17 0.00 6,105.83 87.23 10-160-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 14,115.01 2,496.75 0.00 11,618.26 82.31 10-160-502020 Group Health Insurance 23,221.30 3,077.90 0.00 20,143.40 86.75 10-160-502030 Retirement 16,816.18 3,104.51 0.00 13,711.67 81.54 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 176.26 24.73 0.00 151.53 85.97 10-160-502060 Long Term Disability 436.08 63.21 0.00 372.87 85.50 10-160-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 239,538.48 42,017.61 0.00 197,520.87 82.46 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 304.44 0.00 1,695.56 84.78 10-160-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 2,500.00 11.80 0.00 2,488.20 99.53 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 316.24 0.00 4,583.76 93.55 10-160-520025 Security 14,000.00 1,050.84 0.00 12,949.16 92.49 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-160-522020 Professional Services 4,500.00 0.00 0.00 4,500.00 100.00 10-160-525005 Appointed Counsel 3,000.00 217.50 0.00 2,782.50 92.75 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 23,290.00 1,268.34 0.00 22,021.66 94.55 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 585.00 1,316.40 4,393.60 69.80 E25 Repairs & Maintenance 6,295.00 585.00 1,316.40 4,393.60 69.80 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 274,023.48 44,187.19 1,316.40 228,519.89 83.3943 Grand Total -274,023.48 -44,187.19 -1,316.40 -228,519.89 0.8339 160 Municipal Court 274,023.48 44,187.19 1,316.40 228,519.89 83.39 170 Human Resources 10-170-501020 Salaries 248,975.73 45,948.26 0.00 203,027.47 81.55 10-170-501050 Parttime(wo Benefits)13,000.00 3,011.00 0.00 9,989.00 76.84 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 0.00 0.00 100.00 100.00 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 20,048.79 3,701.80 0.00 16,346.99 81.54 10-170-502020 Group Health Insurance 27,922.60 3,771.04 0.00 24,151.56 86.49 10-170-502030 Retirement 29,390.94 5,421.88 0.00 23,969.06 81.55 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 304.78 44.28 0.00 260.50 85.47 10-170-502060 Long Term Disability 627.76 114.37 0.00 513.39 81.78 10-170-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 340,761.81 62,353.66 0.00 278,408.15 81.70 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 37.74 0.00 262.26 87.42 10-170-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-170-512020 Copies 500.00 68.57 0.00 431.43 86.29 10-170-513010 Office Supplies 600.00 0.00 0.00 600.00 100.00 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 500.00 60.80 0.00 439.20 87.84 E10 Materials & Supplies 2,350.00 167.11 0.00 2,182.89 92.89 10-170-520030 Dues And Publications 700.00 0.00 0.00 700.00 100.00 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 0.00 0.00 3,000.00 100.00 10-170-520070 Training And Education 4,437.00 0.00 0.00 4,437.00 100.00 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 0.00 0.00 500.00 100.00 10-170-522020 Professional Services 1,000.00 0.00 0.00 1,000.00 100.00 10-170-529010 Special Events 800.00 0.00 0.00 800.00 100.00 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 10,437.00 0.00 0.00 10,437.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 59,713.45 9,273.96 491.88 49,947.61 83.65 E25 Repairs & Maintenance 59,713.45 9,273.96 491.88 49,947.61 83.65 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 413,262.26 71,794.73 491.88 340,975.65 82.5083 Grand Total -413,262.26 -71,794.73 -491.88 -340,975.65 0.8251 170 Human Resources 413,262.26 71,794.73 491.88 340,975.65 82.51 180 Finance Department 10-180-501020 Salaries 591,685.24 102,404.10 0.00 489,281.14 82.69 10-180-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 45,263.92 7,695.57 0.00 37,568.35 83.00 10-180-502020 Group Health Insurance 110,372.73 13,949.60 0.00 96,423.13 87.36 10-180-502030 Retirement 69,818.86 12,083.65 0.00 57,735.21 82.69 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 730.73 101.54 0.00 629.19 86.10 10-180-502060 Long Term Disability 1,792.67 259.33 0.00 1,533.34 85.53 10-180-502070 Employee Assistance Prgm 234.78 43.77 0.00 191.01 81.36 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 820,397.76 137,036.39 0.00 683,361.37 83.30 10-180-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-180-511020 Postage 10,000.00 3,051.07 0.00 6,948.93 69.49 10-180-511021 Mail Machine Cost 3,000.00 0.00 0.00 3,000.00 100.00 10-180-512010 Printing 4,000.00 0.00 0.00 4,000.00 100.00 10-180-512020 Copies 100.00 5.78 0.00 94.22 94.22 10-180-512021 Copy Machine Cost 190.00 -248.03 0.00 438.03 230.54 10-180-513010 Office Supplies 1,250.00 39.60 0.00 1,210.40 96.83 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 0.00 0.00 3,655.00 100.00 E10 Materials & Supplies 22,695.00 2,848.42 0.00 19,846.58 87.45 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 1,100.00 1,040.00 0.00 60.00 5.45 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 919.90 0.00 4,530.10 83.12 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 67,064.88 7,833.55 0.00 59,231.33 88.32 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 0.00 0.00 150.00 100.00 E15 Contractual Services 73,764.88 9,793.45 0.00 63,971.43 86.72 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 14,157.80 12,500.00 1,249.20 408.60 2.89 E25 Repairs & Maintenance 14,157.80 12,500.00 1,249.20 408.60 2.89 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 931,015.44 162,178.26 1,249.20 767,587.98 82.4463 Grand Total -931,015.44 -162,178.26 -1,249.20 -767,587.98 0.8245 180 Finance Department 931,015.44 162,178.26 1,249.20 767,587.98 82.45 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 6,495.15 0.00 30,472.28 82.43 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 36,967.43 6,495.15 0.00 30,472.28 82.43 10-185-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-185-514010 Gas 22,000.00 1,398.53 0.00 20,601.47 93.64 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 10-185-550034 National Opioid Settlement 66,812.35 8,048.42 26,425.33 32,338.60 48.40 E10 Materials & Supplies 89,312.35 9,446.95 26,425.33 53,440.07 59.84 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 580,171.18 360,753.43 0.00 219,417.75 37.82 10-185-521020 Insurance Deductible 50,000.00 5,923.93 0.00 44,076.07 88.15 10-185-521030 Self Ins Prop & Casualty 40,000.00 4,005.97 0.00 35,994.03 89.99 10-185-521060 Drugalcohol screening 3,564.00 222.00 0.00 3,342.00 93.77 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 90.00 0.00 -90.00 0.00 10-185-522020 Professional Services 112,388.00 12,498.00 18,900.00 80,990.00 72.06 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 46,250.00 0.00 138,750.00 75.00 10-185-529010 Special Events 5,000.00 0.00 0.00 5,000.00 100.00 E15 Contractual Services 1,023,123.18 429,743.33 18,900.00 574,479.85 56.15 10-185-531010 Electricity 35,200.00 2,114.68 0.00 33,085.32 93.99 10-185-533010 Natural Gas 6,510.00 545.24 0.00 5,964.76 91.62 10-185-535010 Water 7,250.00 734.05 0.00 6,515.95 89.88 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 48,960.00 3,393.97 0.00 45,566.03 93.07 10-185-540010 Building & Grounds Maint.40,000.00 79,229.51 0.00 -39,229.51 -98.07 10-185-540015 Amtrak Station 4,000.00 305.25 0.00 3,694.75 92.37 10-185-540020 Tree & Landscape Maint 25,000.00 0.00 0.00 25,000.00 100.00 10-185-547020 Maintenance Agreements 2,060.00 288.00 0.00 1,772.00 86.02 E25 Repairs & Maintenance 71,060.00 79,822.76 0.00 -8,762.76 -12.33 10-185-550010 Miscellaneous 2,800.00 488.00 0.00 2,312.00 82.57 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 0.00 0.00 10,000.00 100.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 163,469.08 1,073.50 0.00 162,395.58 99.34 E30 Other Operating Expenses 176,269.08 1,561.50 0.00 174,707.58 99.11 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 -3,940.27 0.00 3,940.27 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 -3,940.27 0.00 3,940.27 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,445,692.04 526,523.39 45,325.33 873,843.32 60.4446 Grand Total -1,445,692.04 -526,523.39 -45,325.33 -873,843.32 0.6044 185 Non-Departmental 1,445,692.04 526,523.39 45,325.33 873,843.32 60.44 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 27,950.00 0.00 0.00 27,950.00 100.00 E25 Repairs & Maintenance 27,950.00 0.00 0.00 27,950.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 27,950.00 0.00 0.00 27,950.00 100 Grand Total -27,950.00 0.00 0.00 -27,950.00 1 186 Emerg Mgmt Operations 27,950.00 0.00 0.00 27,950.00 100.00 190 Information Technology Svcs 10-190-501020 Salaries 652,615.68 112,810.62 0.00 539,805.06 82.71 10-190-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 49,925.10 8,439.92 0.00 41,485.18 83.09 10-190-502020 Group Health Insurance 99,908.29 12,975.05 0.00 86,933.24 87.01 10-190-502030 Retirement 77,008.65 12,211.62 0.00 64,797.03 84.14 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 798.05 110.73 0.00 687.32 86.12 10-190-502060 Long Term Disability 1,924.15 282.71 0.00 1,641.44 85.31 10-190-502070 Employee Assistance Prgm 223.86 48.59 0.00 175.27 78.29 E05 Personnel Services 883,761.99 148,237.45 0.00 735,524.54 83.23 10-190-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 0.15 0.00 9.85 98.50 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 96.39 0.00 403.61 80.72 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 4,000.00 197.09 0.00 3,802.91 95.07 E10 Materials & Supplies 4,560.00 293.63 0.00 4,266.37 93.56 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 0.00 0.00 150.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 7,500.00 0.00 0.00 7,500.00 100.00 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 9,000.00 1,449.74 0.00 7,550.26 83.89 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 23,000.00 3,619.68 0.00 19,380.32 84.26 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 0.00 0.00 4,400.00 100.00 E15 Contractual Services 44,050.00 5,069.42 0.00 38,980.58 88.49 10-190-534010 Telephone 90,000.00 12,894.83 0.00 77,105.17 85.67 E20 Utilities 90,000.00 12,894.83 0.00 77,105.17 85.67 10-190-545010 Software License\maint 233,000.00 56,101.93 638.50 176,259.57 75.65 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 0.00 416.40 21,583.60 98.11 10-190-547025 Coun Chamber MediaEquip Repr 480.00 0.00 0.00 480.00 100.00 E25 Repairs & Maintenance 255,480.00 56,101.93 1,054.90 198,323.17 77.63 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,277,851.99 222,597.26 1,054.90 1,054,199.83 82.4978 Grand Total -1,277,851.99 -222,597.26 -1,054.90 -1,054,199.83 0.825 190 Information Technology Svcs 1,277,851.99 222,597.26 1,054.90 1,054,199.83 82.50 300 Police Department 10-300-501020 Salaries 5,585,563.46 1,000,909.55 0.00 4,584,653.91 82.08 10-300-501030 Holiday Pay 179,249.71 62,354.42 0.00 116,895.29 65.21 10-300-501040 Part-time (w\benefits)45,305.01 0.00 0.00 45,305.01 100.00 10-300-501050 Parttime(wo Benefits)47,304.18 5,505.00 0.00 41,799.18 88.36 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 1,744.12 0.00 3,255.88 65.12 10-300-501090 Overtime 263,762.11 62,576.93 0.00 201,185.18 76.28 10-300-501095 Overtime Straight Pay 13,275.00 2,540.14 0.00 10,734.86 80.87 10-300-502010 Social Security 465,407.81 83,554.21 0.00 381,853.60 82.05 10-300-502020 Group Health Insurance 1,060,092.76 145,577.85 0.00 914,514.91 86.27 10-300-502030 Retirement 996,597.99 177,626.83 0.00 818,971.16 82.18 10-300-502040 Workers Compensation 75,084.94 75,084.94 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,900.98 1,001.20 0.00 5,899.78 85.49 10-300-502060 Long Term Disability 16,618.95 2,565.68 0.00 14,053.27 84.56 10-300-502070 Employee Assistance Prgm 2,031.12 462.90 0.00 1,568.22 77.21 10-300-503010 Awards Program 2,500.00 0.00 0.00 2,500.00 100.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,764,694.02 1,621,503.77 0.00 7,143,190.25 81.50 10-300-511010 Advertising 5,665.00 0.00 0.00 5,665.00 100.00 10-300-511020 Postage 1,395.00 318.97 0.00 1,076.03 77.13 10-300-512010 Printing 5,952.00 406.50 0.00 5,545.50 93.17 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 3,307.52 0.00 12,362.98 78.89 10-300-514010 Gas 195,940.00 15,994.32 0.00 179,945.68 91.84 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 1,243.75 31.38 0.00 1,212.37 97.48 10-300-515040 First Aid Supplies 1,378.00 798.31 0.00 579.69 42.07 10-300-516010 Ammunition & Firearms Supplies 65,000.00 869.01 60,442.40 3,688.59 5.67 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 335.00 0.00 1,990.00 85.59 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 11,100.00 8,550.00 0.00 2,550.00 22.97 10-300-517010 Operational Supplies 48,591.90 9,461.98 8,233.37 30,896.55 63.58 E10 Materials & Supplies 356,121.15 40,072.99 68,675.77 247,372.39 69.46 10-300-520030 Dues And Publications 5,400.00 961.40 0.00 4,438.60 82.20 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 54,020.00 9,307.08 0.00 44,712.92 82.77 10-300-520080 Tuition Reimbursement 11,625.00 0.00 0.00 11,625.00 100.00 10-300-520090 Recruitment 50,000.00 0.00 0.00 50,000.00 100.00 10-300-521040 Medical Claimsservices 6,510.00 0.00 0.00 6,510.00 100.00 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,450.00 16,638.30 0.00 -188.30 -1.14 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 -1.48 0.00 2,047.48 100.07 E15 Contractual Services 146,051.00 26,905.30 0.00 119,145.70 81.58 10-300-531010 Electricity 44,640.00 3,914.60 0.00 40,725.40 91.23 10-300-533010 Natural Gas 1,116.00 113.42 0.00 1,002.58 89.84 10-300-534010 Telephone 24,101.00 5,680.33 0.00 18,420.67 76.43 10-300-535010 Water 3,348.00 427.82 0.00 2,920.18 87.22 E20 Utilities 73,205.00 10,136.17 0.00 63,068.83 86.15 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.60,000.00 940.28 0.00 59,059.72 98.43 10-300-541030 Vehicle Wash 9,752.00 5,329.44 0.00 4,422.56 45.35 10-300-544010 K-9 Operations 16,740.00 390.50 0.00 16,349.50 97.67 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 10-300-545010 Software License\maint 100,157.50 74,241.54 0.00 25,915.96 25.88 10-300-546010 Clothing Expense 60,137.69 3,226.33 48,509.74 8,401.62 13.97 10-300-546020 Uniform Cleaning 23,715.00 2,978.72 0.00 20,736.28 87.44 10-300-547010 Equipment Maintenance 10,000.00 0.00 0.00 10,000.00 100.00 10-300-547020 Maintenance Agreements 79,301.88 11,490.31 5,896.80 61,914.77 78.07 10-300-547030 Radio Maintenance 8,025.00 133.00 0.00 7,892.00 98.34 E25 Repairs & Maintenance 367,829.07 98,730.12 54,406.54 214,692.41 58.37 10-300-572010 Purchase Of Vehicles 233,200.00 211,760.00 0.00 21,440.00 9.19 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 195,490.02 0.00 69,111.07 126,378.95 64.65 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 8,528.18 0.00 0.00 8,528.18 100.00 10-300-572090 Body Worn Cameras 120,000.00 0.00 0.00 120,000.00 100.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 557,218.20 211,760.00 69,111.07 276,347.13 49.59 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,265,118.44 2,009,108.35 192,193.38 8,063,816.71 78.5555 Grand Total -10,265,118.44 -2,009,108.35 -192,193.38 -8,063,816.71 0.7856 300 Police Department 10,265,118.44 2,009,108.35 192,193.38 8,063,816.71 78.56 310 School Resource Officer 10-310-501020 Salaries 501,710.46 74,312.84 0.00 427,397.62 85.19 10-310-501030 Holiday Pay 21,214.01 0.00 0.00 21,214.01 100.00 10-310-501090 Overtime 45,106.00 14,413.23 0.00 30,692.77 68.05 10-310-501095 Overtime Straight Pay 1,311.00 593.03 0.00 717.97 54.77 10-310-502010 Social Security 43,554.63 6,479.23 0.00 37,075.40 85.12 10-310-502020 Group Health Insurance 104,608.25 12,666.58 0.00 91,941.67 87.89 10-310-502030 Retirement 96,788.06 15,184.26 0.00 81,603.80 84.31 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 615.82 76.59 0.00 539.23 87.56 10-310-502060 Long Term Disability 1,528.69 196.93 0.00 1,331.76 87.12 10-310-502070 Employee Assistance Prgm 174.72 40.92 0.00 133.80 76.58 E05 Personnel Services 823,164.50 130,516.47 0.00 692,648.03 84.14 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 0.00 0.00 15,345.00 100.00 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 0.00 0.00 22,340.00 100.00 10-310-520070 Training And Education 4,650.00 0.00 0.00 4,650.00 100.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 0.00 0.00 4,650.00 100.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 0.00 3,564.25 2,409.75 40.34 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 416.40 811.80 416.40 -811.80 -194.96 E25 Repairs & Maintenance 6,390.40 811.80 3,980.65 1,597.95 25.01 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 856,544.90 131,328.27 3,980.65 721,235.98 84.2029 Grand Total -856,544.90 -131,328.27 -3,980.65 -721,235.98 0.842 310 School Resource Officer 856,544.90 131,328.27 3,980.65 721,235.98 84.20 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 130,750.33 23,609.27 0.00 107,141.06 81.94 10-320-501030 Holiday Pay 5,452.54 0.00 0.00 5,452.54 100.00 10-320-501090 Overtime 30,089.28 7,314.32 0.00 22,774.96 75.69 10-320-501095 Overtime Straight Pay 0.00 509.58 0.00 -509.58 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,287.82 2,289.29 0.00 8,998.53 79.72 10-320-502020 Group Health Insurance 22,743.74 3,305.08 0.00 19,438.66 85.47 10-320-502030 Retirement 25,084.04 5,343.64 0.00 19,740.40 78.70 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 157.90 24.23 0.00 133.67 84.65 10-320-502060 Long Term Disability 394.37 62.06 0.00 332.31 84.26 10-320-502070 Employee Assistance Prgm 43.68 10.23 0.00 33.45 76.58 E05 Personnel Services 228,008.09 44,472.09 0.00 183,536.00 80.50 10-320-514010 Gas 11,327.53 1,478.25 0.00 9,849.28 86.95 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 510.00 0.00 14,596.00 96.62 10-320-517010 Operational Supplies 1,200.00 0.00 0.00 1,200.00 100.00 E10 Materials & Supplies 27,633.53 1,988.25 0.00 25,645.28 92.80 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 18,500.00 2,400.00 0.00 16,100.00 87.03 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,500.00 2,400.00 0.00 16,100.00 87.03 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 274,141.62 48,860.34 0.00 225,281.28 82.177 Grand Total -274,141.62 -48,860.34 0.00 -225,281.28 0.8218 320 M.U.S.T.A.N.G.274,141.62 48,860.34 0.00 225,281.28 82.18 330 Animal Control 10-330-501020 Salaries 394,208.69 71,070.42 0.00 323,138.27 81.97 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 1,629.23 0.00 6,970.77 81.06 10-330-501090 Overtime 2,000.00 442.66 0.00 1,557.34 77.87 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 30,967.86 5,163.71 0.00 25,804.15 83.33 10-330-502020 Group Health Insurance 101,449.34 13,035.10 0.00 88,414.24 87.15 10-330-502030 Retirement 47,767.43 6,868.95 0.00 40,898.48 85.62 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 487.15 70.36 0.00 416.79 85.56 10-330-502060 Long Term Disability 1,175.12 178.94 0.00 996.18 84.77 10-330-502070 Employee Assistance Prgm 174.72 40.92 0.00 133.80 76.58 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 591,511.39 103,181.37 0.00 488,330.02 82.56 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 0.00 0.00 152.00 100.00 10-330-512010 Printing 1,860.00 285.95 0.00 1,574.05 84.63 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 17.98 0.00 1,563.02 98.86 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 223.00 0.00 0.00 223.00 100.00 10-330-515040 First Aid Supplies 295.00 0.00 0.00 295.00 100.00 10-330-517010 Operational Supplies 11,000.00 317.65 0.00 10,682.35 97.11 E10 Materials & Supplies 16,016.00 621.58 0.00 15,394.42 96.12 10-330-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 0.00 0.00 2,611.00 100.00 10-330-521040 Medical Claimsservices 690.00 0.00 0.00 690.00 100.00 10-330-522020 Professional Services 4,830.00 40.00 0.00 4,790.00 99.17 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 2,497.92 0.00 2,710.08 52.04 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,239.00 2,537.92 0.00 11,701.08 82.18 10-330-531010 Electricity 25,067.90 1,860.77 0.00 23,207.13 92.58 10-330-533010 Natural Gas 22,050.00 2,027.35 0.00 20,022.65 90.81 10-330-534010 Telephone 810.00 64.41 0.00 745.59 92.05 10-330-535010 Water 3,800.00 613.33 0.00 3,186.67 83.86 E20 Utilities 51,727.90 4,565.86 0.00 47,162.04 91.17 10-330-540010 Building & Grounds Maint.15,000.00 882.76 0.00 14,117.24 94.11 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 49,290.00 13,037.22 0.00 36,252.78 73.55 10-330-544050 Animal Food 6,603.00 430.23 0.00 6,172.77 93.48 10-330-545010 Software Licensemaint 8,087.00 2,495.04 0.00 5,591.96 69.15 10-330-546010 Clothing Expense 2,325.00 868.04 0.00 1,456.96 62.66 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 1,406.40 0.00 416.40 990.00 70.39 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 2,230.00 0.00 0.00 2,230.00 100.00 E25 Repairs & Maintenance 85,796.40 18,253.29 416.40 67,126.71 78.24 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 759,290.69 129,160.02 416.40 629,714.27 82.9345 Grand Total -759,290.69 -129,160.02 -416.40 -629,714.27 0.8293 330 Animal Control 759,290.69 129,160.02 416.40 629,714.27 82.93 390 9-1-1 Police 10-390-501020 Salaries 1,053,365.22 165,550.31 0.00 887,814.91 84.28 10-390-501030 Holiday Pay 40,668.88 15,281.09 0.00 25,387.79 62.43 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 0.00 247.09 0.00 -247.09 0.00 10-390-501090 Overtime 22,814.00 13,861.13 0.00 8,952.87 39.24 10-390-501095 Overtime Straight Pay 500.00 744.53 0.00 -244.53 -48.91 10-390-502010 Social Security 85,477.13 14,443.79 0.00 71,033.34 83.10 10-390-502020 Group Health Insurance 232,987.77 26,998.79 0.00 205,988.98 88.41 10-390-502030 Retirement 136,605.11 22,990.23 0.00 113,614.88 83.17 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,302.34 163.99 0.00 1,138.35 87.41 10-390-502060 Long Term Disability 3,220.09 418.02 0.00 2,802.07 87.02 10-390-502070 Employee Assistance Prgm 458.64 108.69 0.00 349.95 76.30 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,580,119.14 263,527.62 0.00 1,316,591.52 83.32 10-390-511010 Advertising 1,400.00 0.00 0.00 1,400.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,225.00 218.42 0.00 6,006.58 96.49 E10 Materials & Supplies 7,625.00 218.42 0.00 7,406.58 97.14 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,650.00 716.84 0.00 4,933.16 87.31 10-390-522020 Professional Services 4,300.00 342.05 0.00 3,957.95 92.05 10-390-523010 Equipment Rentlease 99,260.00 13,287.16 0.00 85,972.84 86.61 E15 Contractual Services 109,768.00 14,346.05 0.00 95,421.95 86.93 10-390-531010 Electricity 12,276.00 0.00 0.00 12,276.00 100.00 10-390-533010 Natural Gas 292.95 0.00 0.00 292.95 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 0.00 0.00 837.00 100.00 E20 Utilities 13,405.95 0.00 0.00 13,405.95 100.00 10-390-545010 Software License\maint 53,415.00 48,856.66 0.00 4,558.34 8.53 10-390-546010 Clothing Expense 5,580.00 17.72 0.00 5,562.28 99.68 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 0.00 0.00 4,200.00 100.00 10-390-547020 Maintenance Agreements 79,556.40 10,584.24 0.00 68,972.16 86.70 10-390-547030 Radio Maintenance 4,650.00 0.00 1,866.04 2,783.96 59.87 E25 Repairs & Maintenance 150,377.40 59,458.62 1,866.04 89,052.74 59.22 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,861,295.49 337,550.71 1,866.04 1,521,878.74 81.7645 Grand Total -1,861,295.49 -337,550.71 -1,866.04 -1,521,878.74 0.8176 390 9-1-1 Police 1,861,295.49 337,550.71 1,866.04 1,521,878.74 81.76 400 Fire Department 10-400-501020 Salaries 4,690,038.81 795,351.00 0.00 3,894,687.81 83.04 10-400-501025 Other Hours 0.00 2,709.95 0.00 -2,709.95 0.00 10-400-501030 Holiday Pay 388,303.41 168,141.33 0.00 220,162.08 56.70 10-400-501035 Training & Essential Functions 82,395.68 8,746.12 0.00 73,649.56 89.39 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 55,733.33 9,061.08 0.00 46,672.25 83.74 10-400-501090 Overtime-FLSA 195,037.45 103,907.26 0.00 91,130.19 46.72 10-400-501092 Overtime-Constant Staffing 187,813.69 16,364.57 0.00 171,449.12 91.29 10-400-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-400-502010 Social Security 83,367.55 15,918.30 0.00 67,449.25 80.91 10-400-502020 Group Health Insurance 946,285.13 146,454.49 0.00 799,830.64 84.52 10-400-502030 Retirement 2,805,502.77 550,449.28 0.00 2,255,053.49 80.38 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,718.53 801.19 0.00 4,917.34 85.99 10-400-502060 Long Term Disability 13,863.74 2,055.63 0.00 11,808.11 85.17 10-400-502070 Employee Assistance Prgm 1,659.84 388.73 0.00 1,271.11 76.58 10-400-503010 Awards Program 1,500.00 0.00 0.00 1,500.00 100.00 E05 Personnel Services 9,610,250.88 1,973,379.88 0.00 7,636,871.00 79.47 10-400-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-400-511020 Postage 120.00 49.17 0.00 70.83 59.03 10-400-512010 Printing 600.00 0.00 0.00 600.00 100.00 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 187.20 0.00 1,207.80 86.58 10-400-514010 Gas 91,180.00 6,803.08 0.00 84,376.92 92.54 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,000.00 4,096.38 0.00 1,903.62 31.73 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 0.00 0.00 2,100.00 100.00 10-400-517010 Operational Supplies 18,000.00 1,690.76 0.00 16,309.24 90.61 E10 Materials & Supplies 120,645.00 12,826.59 0.00 107,818.41 89.37 10-400-520030 Dues And Publications 3,400.00 610.60 0.00 2,789.40 82.04 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 34,000.00 4,151.50 0.00 29,848.50 87.79 10-400-520080 Tuition Reimbursement 7,500.00 702.00 0.00 6,798.00 90.64 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 0.00 0.00 40,000.00 100.00 10-400-522020 Professional Services 10,060.70 8,100.80 0.00 1,959.90 19.48 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,000.00 0.00 0.00 5,000.00 100.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 0.00 0.00 2,500.00 100.00 E15 Contractual Services 102,653.70 13,564.90 0.00 89,088.80 86.79 10-400-531010 Electricity 38,500.00 3,811.14 0.00 34,688.86 90.10 10-400-533010 Natural Gas 20,000.00 2,428.77 0.00 17,571.23 87.86 10-400-534010 Telephone 25,984.20 5,703.21 0.00 20,280.99 78.05 10-400-535010 Water 12,000.00 2,210.56 0.00 9,789.44 81.58 E20 Utilities 96,484.20 14,153.68 0.00 82,330.52 85.33 10-400-540010 Building & Grounds Maint.113,040.00 4,592.89 24,165.00 84,282.11 74.56 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 98,000.00 2,952.63 0.00 95,047.37 96.99 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,000.00 6,577.11 0.00 13,422.89 67.11 10-400-547020 Maintenance Agreements 39,487.20 9,025.32 1,424.03 29,037.85 73.54 10-400-547030 Radio Maintenance 20,925.00 3,722.80 0.00 17,202.20 82.21 E25 Repairs & Maintenance 291,952.20 26,870.75 25,589.03 239,492.42 82.03 10-400-572010 Purchase Of Vehicles 42,891.00 42,891.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 108,399.77 16,925.58 0.00 91,474.19 84.39 10-400-572022 Fitness-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 500,000.00 500,000.00 0.00 0.00 0.00 E70 Capital Purchases 651,290.77 559,816.58 0.00 91,474.19 14.05 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,873,276.75 2,600,612.38 25,589.03 8,247,075.34 75.8472 Grand Total -10,873,276.75 -2,600,612.38 -25,589.03 -8,247,075.34 0.7585 400 Fire Department 10,873,276.75 2,600,612.38 25,589.03 8,247,075.34 75.85 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,900.00 129.66 0.00 1,770.34 93.18 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 300.00 0.00 0.00 300.00 100.00 E20 Utilities 2,200.00 129.66 0.00 2,070.34 94.11 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,200.00 129.66 0.00 2,070.34 94.1064 Grand Total -2,200.00 -129.66 0.00 -2,070.34 0.9411 401 Fire Museum 2,200.00 129.66 0.00 2,070.34 94.11 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 247,045.96 42,452.24 0.00 204,593.72 82.82 10-520-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 18,899.02 3,127.38 0.00 15,771.64 83.45 10-520-502020 Group Health Insurance 57,799.07 7,712.36 0.00 50,086.71 86.66 10-520-502030 Retirement 29,151.42 3,977.21 0.00 25,174.21 86.36 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 303.55 43.69 0.00 259.86 85.61 10-520-502060 Long Term Disability 660.64 112.47 0.00 548.17 82.98 10-520-502070 Employee Assistance Prgm 87.36 15.34 0.00 72.02 82.44 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 354,143.92 57,637.59 0.00 296,506.33 83.72 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 15.12 0.00 59.88 79.84 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 352.68 0.00 497.32 58.51 10-520-514010 Gas 16,490.00 1,621.33 0.00 14,868.67 90.17 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 0.00 0.00 500.00 100.00 E10 Materials & Supplies 18,015.00 1,989.13 0.00 16,025.87 88.96 10-520-520030 Dues And Publications 1,200.00 0.00 0.00 1,200.00 100.00 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 0.00 0.00 1,800.00 100.00 10-520-522020 Professional Services 3,000.00 0.00 0.00 3,000.00 100.00 E15 Contractual Services 6,000.00 0.00 0.00 6,000.00 100.00 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 34,902.55 30.84 1,113.33 33,758.38 96.72 E25 Repairs & Maintenance 34,902.55 30.84 1,113.33 33,758.38 96.72 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 413,061.47 59,657.56 1,113.33 352,290.58 85.2877 Grand Total -413,061.47 -59,657.56 -1,113.33 -352,290.58 0.8529 520 Plan & Protect Svcs-Admin 413,061.47 59,657.56 1,113.33 352,290.58 85.29 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 93,573.53 20,207.06 0.00 73,366.47 78.41 10-521-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 7,158.38 1,515.54 0.00 5,642.84 78.83 10-521-502020 Group Health Insurance 16,621.90 2,853.74 0.00 13,768.16 82.83 10-521-502030 Retirement 11,041.68 2,384.33 0.00 8,657.35 78.41 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 115.06 19.52 0.00 95.54 83.03 10-521-502060 Long Term Disability 285.42 49.84 0.00 235.58 82.54 10-521-502070 Employee Assistance Prgm 32.76 13.81 0.00 18.95 57.84 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 128,987.08 27,202.19 0.00 101,784.89 78.91 10-521-511010 Advertising 3,336.00 318.00 0.00 3,018.00 90.47 10-521-511020 Postage 500.00 19.53 0.00 480.47 96.09 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 20.78 0.00 779.22 97.40 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 0.00 0.00 1,500.00 100.00 E10 Materials & Supplies 6,336.00 358.31 0.00 5,977.69 94.34 10-521-520030 Dues And Publications 14,209.68 0.00 0.00 14,209.68 100.00 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 15,709.68 0.00 0.00 15,709.68 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,335.00 141.90 1,048.56 144.54 10.83 E25 Repairs & Maintenance 1,335.00 141.90 1,048.56 144.54 10.83 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 152,367.76 27,702.40 1,048.56 123,616.80 81.1305 Grand Total -152,367.76 -27,702.40 -1,048.56 -123,616.80 0.8113 521 Plan & Protect Svcs-Planning 152,367.76 27,702.40 1,048.56 123,616.80 81.13 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 109,870.24 17,340.62 0.00 92,529.62 84.22 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 8,405.07 1,314.92 0.00 7,090.15 84.36 10-522-502020 Group Health Insurance 16,621.90 2,002.16 0.00 14,619.74 87.95 10-522-502030 Retirement 12,964.69 2,046.26 0.00 10,918.43 84.22 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 135.86 17.24 0.00 118.62 87.31 10-522-502060 Long Term Disability 335.28 43.82 0.00 291.46 86.93 10-522-502070 Employee Assistance Prgm 32.76 11.76 0.00 21.00 64.10 E05 Personnel Services 148,468.35 22,879.33 0.00 125,589.02 84.59 10-522-511010 Advertising 2,600.00 0.00 0.00 2,600.00 100.00 10-522-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.95 0.00 199.05 99.53 10-522-513010 Office Supplies 1,000.00 27.83 0.00 972.17 97.22 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 300.00 37.70 0.00 262.30 87.43 10-522-517010 Operational Supplies 1,000.00 436.85 0.00 563.15 56.32 E10 Materials & Supplies 5,600.00 503.33 0.00 5,096.67 91.01 10-522-520030 Dues And Publications 1,500.00 0.00 0.00 1,500.00 100.00 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 30,000.00 459.00 3,890.60 25,650.40 85.50 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 39,000.00 459.00 3,890.60 34,650.40 88.85 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 107.05 951.63 1,341.32 55.89 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 107.05 951.63 1,341.32 55.89 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 198,868.35 23,948.71 4,842.23 170,077.41 85.5226 Grand Total -198,868.35 -23,948.71 -4,842.23 -170,077.41 0.8552 522 Plan & Protect Svcs-MPO 198,868.35 23,948.71 4,842.23 170,077.41 85.52 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,845.53 3,786.04 0.00 54,059.49 93.45 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 0.00 269.78 0.00 -269.78 0.00 10-530-502020 Group Health Insurance 0.00 667.48 0.00 -667.48 0.00 10-530-502030 Retirement 0.00 446.76 0.00 -446.76 0.00 10-530-502040 Workers Compensation 145.11 145.11 0.00 0.00 0.00 10-530-502050 Life Insurance 0.00 3.12 0.00 -3.12 0.00 10-530-502060 Long Term Disability 0.00 7.72 0.00 -7.72 0.00 10-530-502070 Employee Assistance Prgm 0.00 5.11 0.00 -5.11 0.00 E05 Personnel Services 57,990.64 5,331.12 0.00 52,659.52 90.81 10-530-511010 Advertising 415.00 0.00 0.00 415.00 100.00 10-530-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 100.00 163.56 0.00 -63.56 -63.56 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 470.00 0.00 0.00 470.00 100.00 E10 Materials & Supplies 1,085.00 163.56 0.00 921.44 84.93 10-530-520030 Dues And Publications 250.00 0.00 0.00 250.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 32,183.65 0.00 0.00 32,183.65 100.00 10-530-524025 Glass Recycling 5,000.00 0.00 0.00 5,000.00 100.00 10-530-524026 Household Hazardous Waste 23,000.00 18.00 0.00 22,982.00 99.92 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 35,761.33 0.00 0.00 35,761.33 100.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 100,694.98 18.00 0.00 100,676.98 99.98 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 1,741.02 45.98 551.16 1,143.88 65.70 E25 Repairs & Maintenance 1,741.02 45.98 551.16 1,143.88 65.70 10-530-550020 NRA-Residential 40,000.00 5,027.00 0.00 34,973.00 87.43 10-530-550030 NRA-Commercial Facade 19,500.00 0.00 0.00 19,500.00 100.00 10-530-550031 Historic Preservation Grant 22,975.24 0.00 22,975.24 0.00 0.00 10-530-550032 NRA-Rental Facade 15,000.00 54.00 0.00 14,946.00 99.64 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 200.00 0.00 0.00 200.00 100.00 10-530-550039 Historic Preservation Grant 27,727.50 15,865.00 0.00 11,862.50 42.78 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 125,402.74 20,946.00 22,975.24 81,481.50 64.98 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 286,914.38 26,504.66 23,526.40 236,883.32 82.5624 Grand Total -286,914.38 -26,504.66 -23,526.40 -236,883.32 0.8256 530 Plan & Protect Svc-RedevGrant 286,914.38 26,504.66 23,526.40 236,883.32 82.56 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 217,232.39 40,381.22 0.00 176,851.17 81.41 10-532-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 16,618.28 3,150.93 0.00 13,467.35 81.04 10-532-502020 Group Health Insurance 44,266.53 6,942.72 0.00 37,323.81 84.32 10-532-502030 Retirement 25,633.42 5,117.10 0.00 20,516.32 80.04 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 266.83 35.83 0.00 231.00 86.57 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 661.06 103.84 0.00 557.22 84.29 10-532-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 308,497.45 59,500.40 0.00 248,997.05 80.71 10-532-511010 Advertising 90.00 147.25 0.00 -57.25 -63.61 10-532-511020 Postage 150.00 45.54 0.00 104.46 69.64 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 37.00 0.00 1,263.00 97.15 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 2,625.00 229.79 0.00 2,395.21 91.25 10-532-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 90.00 0.00 910.00 91.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 194,400.00 5,629.24 0.00 188,770.76 97.10 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 196,900.00 5,719.24 0.00 191,180.76 97.10 10-532-534010 Telephone 1,500.00 247.44 0.00 1,252.56 83.50 E20 Utilities 1,500.00 247.44 0.00 1,252.56 83.50 10-532-540060 Cemetery Maintenance 39,000.00 3,151.61 31,670.00 4,178.39 10.71 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 0.00 0.00 1,080.00 100.00 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 36.27 1,237.77 -364.04 -40.00 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 42,320.00 4,471.88 32,907.77 4,940.35 11.67 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 551,842.45 70,168.75 32,907.77 448,765.93 81.3214 Grand Total -551,842.45 -70,168.75 -32,907.77 -448,765.93 0.8132 532 Plan & Protect Svcs-Env Health 551,842.45 70,168.75 32,907.77 448,765.93 81.32 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 167,225.57 33,031.76 0.00 134,193.81 80.25 10-533-501050 Parttime(wo Benefits)20,000.00 9,982.54 0.00 10,017.46 50.09 10-533-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,322.76 3,260.16 0.00 11,062.60 77.24 10-533-502020 Group Health Insurance 27,353.91 4,058.29 0.00 23,295.62 85.16 10-533-502030 Retirement 19,732.62 3,640.42 0.00 16,092.20 81.55 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 206.86 31.60 0.00 175.26 84.72 10-533-502060 Long Term Disability 511.71 74.57 0.00 437.14 85.43 10-533-502070 Employee Assistance Prgm 65.52 17.90 0.00 47.62 72.68 E05 Personnel Services 251,676.33 56,354.62 0.00 195,321.71 77.61 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.00 199.32 0.00 1,600.68 88.93 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 143.34 0.00 1,206.66 89.38 E10 Materials & Supplies 4,690.00 342.66 0.00 4,347.34 92.69 10-533-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 71.21 0.00 1,128.79 94.07 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522019 Demo-Grant Funded 34,677.55 0.00 0.00 34,677.55 100.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 10,000.00 4,215.00 0.00 5,785.00 57.85 10-533-522022 Demo 59,610.00 36,520.62 5,519.87 17,569.51 29.47 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 0.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 105,987.55 40,806.83 5,519.87 59,660.85 56.29 10-533-534010 Telephone 3,701.40 708.72 0.00 2,992.68 80.85 E20 Utilities 3,701.40 708.72 0.00 2,992.68 80.85 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 0.00 0.00 1,280.00 100.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 132.89 1,240.53 -102.42 -8.06 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 402.89 1,240.53 1,207.58 42.36 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 368,906.28 98,615.72 6,760.40 263,530.16 71.4355 Grand Total -368,906.28 -98,615.72 -6,760.40 -263,530.16 0.7144 533 PPS - Prop MaintCode Enforce 368,906.28 98,615.72 6,760.40 263,530.16 71.44 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 325,779.08 60,111.85 0.00 265,667.23 81.55 10-534-501050 Parttime(wo Benefits)15,900.00 2,615.11 0.00 13,284.89 83.55 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 26,138.45 4,460.07 0.00 21,678.38 82.94 10-534-502020 Group Health Insurance 88,283.39 12,885.84 0.00 75,397.55 85.40 10-534-502030 Retirement 38,441.93 7,093.19 0.00 31,348.74 81.55 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 399.02 58.25 0.00 340.77 85.40 10-534-502060 Long Term Disability 991.38 151.39 0.00 839.99 84.73 10-534-502070 Employee Assistance Prgm 109.20 30.69 0.00 78.51 71.90 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 500,798.52 92,162.46 0.00 408,636.06 81.60 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 87.18 0.00 1,012.82 92.07 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 44.33 0.00 855.67 95.07 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 0.00 0.00 1,800.00 100.00 E10 Materials & Supplies 4,115.00 131.51 0.00 3,983.49 96.80 10-534-520030 Dues And Publications 2,500.00 299.00 0.00 2,201.00 88.04 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 6,000.00 696.97 0.00 5,303.03 88.38 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,500.00 995.97 0.00 7,504.03 88.28 10-534-534010 Telephone 3,060.00 565.48 0.00 2,494.52 81.52 E20 Utilities 3,060.00 565.48 0.00 2,494.52 81.52 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,400.00 160.00 0.00 1,240.00 88.57 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,320.00 108.74 945.24 266.02 20.15 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,010.00 538.74 945.24 1,526.02 50.70 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 519,483.52 94,394.16 945.24 424,144.12 81.6473 Grand Total -519,483.52 -94,394.16 -945.24 -424,144.12 0.8165 534 Plan & Protect Svcs-Bldg Regs 519,483.52 94,394.16 945.24 424,144.12 81.65 535 Public Works-Central Maintenan 10-535-501020 Salaries 432,501.41 78,512.79 0.00 353,988.62 81.85 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 316.91 0.00 4,183.09 92.96 10-535-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-535-502010 Social Security 33,774.86 5,849.07 0.00 27,925.79 82.68 10-535-502020 Group Health Insurance 87,782.78 11,864.21 0.00 75,918.57 86.48 10-535-502030 Retirement 51,625.17 9,301.93 0.00 42,323.24 81.98 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 531.22 73.74 0.00 457.48 86.12 10-535-502060 Long Term Disability 1,321.62 188.86 0.00 1,132.76 85.71 10-535-502070 Employee Assistance Prgm 152.88 35.80 0.00 117.08 76.58 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 621,159.30 110,612.67 0.00 510,546.63 82.19 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 3.15 0.00 46.85 93.70 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 98.63 0.00 901.37 90.14 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 6,000.00 905.04 0.00 5,094.96 84.92 10-535-517010 Operational Supplies 6,000.00 946.97 0.00 5,053.03 84.22 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,140.00 1,953.79 0.00 11,186.21 85.13 10-535-520030 Dues And Publications 350.00 0.00 0.00 350.00 100.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,000.00 189.90 0.00 810.10 81.01 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,850.00 189.90 0.00 1,660.10 89.74 10-535-531010 Electricity 7,216.00 957.65 0.00 6,258.35 86.73 10-535-533010 Natural Gas 3,150.00 278.89 0.00 2,871.11 91.15 10-535-534010 Telephone 220.00 48.93 0.00 171.07 77.76 10-535-535010 Water 1,442.00 233.47 0.00 1,208.53 83.81 E20 Utilities 12,028.00 1,518.94 0.00 10,509.06 87.37 10-535-540010 Building & Grounds Maint.10,000.00 193.20 0.00 9,806.80 98.07 10-535-541010 Veh & Equip Parts Etc 519,218.90 126,316.76 0.00 392,902.14 75.67 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 10,000.00 3,014.82 0.00 6,985.18 69.85 10-535-547010 Equipment Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 10-535-547020 Maintenance Agreements 17,251.00 0.00 416.40 16,834.60 97.59 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 557,569.90 129,524.78 416.40 427,628.72 76.70 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,205,747.20 243,800.08 416.40 961,530.72 79.7456 Grand Total -1,205,747.20 -243,800.08 -416.40 -961,530.72 0.7975 535 Public Works-Central Maintenan 1,205,747.20 243,800.08 416.40 961,530.72 79.75 540 Public Works-Admin 10-540-501020 Salaries 232,494.74 43,309.22 0.00 189,185.52 81.37 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 17,785.85 3,328.74 0.00 14,457.11 81.28 10-540-502020 Group Health Insurance 21,692.23 3,597.00 0.00 18,095.23 83.42 10-540-502030 Retirement 27,434.38 5,110.50 0.00 22,323.88 81.37 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 285.19 41.34 0.00 243.85 85.50 10-540-502060 Long Term Disability 534.43 105.36 0.00 429.07 80.29 10-540-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 E05 Personnel Services 300,511.57 55,711.39 0.00 244,800.18 81.46 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.63 0.00 199.37 99.69 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 127,070.00 7,617.01 0.00 119,452.99 94.01 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 129,070.00 7,617.64 0.00 121,452.36 94.10 10-540-520030 Dues And Publications 800.00 334.95 0.00 465.05 58.13 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-540-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,000.00 334.95 0.00 3,665.05 91.63 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 305.00 36.26 315.12 -46.38 -15.21 E25 Repairs & Maintenance 305.00 36.26 315.12 -46.38 -15.21 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 433,886.57 63,700.24 315.12 369,871.21 85.2461 Grand Total -433,886.57 -63,700.24 -315.12 -369,871.21 0.8525 540 Public Works-Admin 433,886.57 63,700.24 315.12 369,871.21 85.25 541 Public Works-Engineering 10-541-501020 Salaries 908,304.51 164,104.33 0.00 744,200.18 81.93 10-541-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 2,000.00 277.00 0.00 1,723.00 86.15 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 69,638.29 12,009.47 0.00 57,628.82 82.75 10-541-502020 Group Health Insurance 156,203.72 22,363.08 0.00 133,840.64 85.68 10-541-502030 Retirement 107,415.93 19,343.70 0.00 88,072.23 81.99 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 1,112.62 161.31 0.00 951.31 85.50 10-541-502060 Long Term Disability 2,565.79 412.08 0.00 2,153.71 83.94 10-541-502070 Employee Assistance Prgm 262.08 76.72 0.00 185.36 70.73 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,253,558.66 224,803.41 0.00 1,028,755.25 82.07 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 18.94 0.00 381.06 95.27 10-541-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-541-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 0.00 0.00 1,650.00 100.00 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-541-515080 Surveying Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-541-517010 Operational Supplies 2,000.00 0.00 0.00 2,000.00 100.00 E10 Materials & Supplies 7,350.00 18.94 0.00 7,331.06 99.74 10-541-520030 Dues And Publications 3,500.00 1,700.00 0.00 1,800.00 51.43 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 5,000.00 120.00 0.00 4,880.00 97.60 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,500.00 1,820.00 0.00 7,680.00 80.84 10-541-534010 Telephone 500.00 41.24 0.00 458.76 91.75 E20 Utilities 500.00 41.24 0.00 458.76 91.75 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 2,500.00 1,487.00 0.00 1,013.00 40.52 10-541-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-547020 Maintenance Agreements 10,665.00 942.56 1,758.57 7,963.87 74.67 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 3,389.56 1,758.57 9,016.87 63.66 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,285,073.66 230,073.15 1,758.57 1,053,241.94 81.9597 Grand Total -1,285,073.66 -230,073.15 -1,758.57 -1,053,241.94 0.8196 541 Public Works-Engineering 1,285,073.66 230,073.15 1,758.57 1,053,241.94 81.96 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,431,726.66 273,658.25 0.00 1,158,068.41 80.89 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 249.49 0.00 19,750.51 98.75 10-542-501070 Stand-by Plan 5,000.00 1,823.77 0.00 3,176.23 63.52 10-542-501090 Overtime 30,000.00 1,813.45 0.00 28,186.55 93.96 10-542-501095 Overtime Straight Pay 500.00 172.05 0.00 327.95 65.59 10-542-502010 Social Security 113,772.84 20,602.61 0.00 93,170.23 81.89 10-542-502020 Group Health Insurance 310,874.53 43,576.60 0.00 267,297.93 85.98 10-542-502030 Retirement 173,132.75 29,112.56 0.00 144,020.19 83.18 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,755.22 248.38 0.00 1,506.84 85.85 10-542-502060 Long Term Disability 4,323.95 632.92 0.00 3,691.03 85.36 10-542-502070 Employee Assistance Prgm 622.44 145.77 0.00 476.67 76.58 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,131,019.23 411,146.69 0.00 1,719,872.54 80.71 10-542-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-542-511020 Postage 150.00 4.02 0.00 145.98 97.32 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,400.00 489.88 0.00 910.12 65.01 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 288,774.11 0.00 0.00 288,774.11 100.00 10-542-514030 Small Tools 10,000.00 504.81 0.00 9,495.19 94.95 10-542-514040 Food 2,000.00 103.51 0.00 1,896.49 94.82 10-542-515010 Stormwater Material 125,000.00 10,861.98 0.00 114,138.02 91.31 10-542-515020 Street Materials 225,000.00 81,843.62 0.00 143,156.38 63.63 10-542-515040 First Aid Supplies 500.00 0.00 0.00 500.00 100.00 10-542-515060 Weed Control 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 7,500.00 2,647.15 0.00 4,852.85 64.70 E10 Materials & Supplies 663,374.11 96,454.97 0.00 566,919.14 85.46 10-542-520030 Dues And Publications 1,320.00 51.00 0.00 1,269.00 96.14 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 1,310.00 0.00 6,370.00 82.94 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 16,000.00 28.35 0.00 15,971.65 99.82 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 26,200.00 1,389.35 0.00 24,810.65 94.70 10-542-531010 Electricity 24,364.00 3,444.92 0.00 20,919.08 85.86 10-542-531020 Street Lights 593,000.00 75,424.29 0.00 517,575.71 87.28 10-542-533010 Natural Gas 10,000.00 349.90 0.00 9,650.10 96.50 10-542-534010 Telephone 2,000.00 257.78 0.00 1,742.22 87.11 10-542-535010 Water 12,390.00 941.80 0.00 11,448.20 92.40 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 641,754.00 80,418.69 0.00 561,335.31 87.47 10-542-540010 Building & Grounds Maint.12,000.00 603.69 0.00 11,396.31 94.97 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 35,000.00 426.90 7,954.00 26,619.10 76.05 10-542-542030 Signs & Marking Paint 60,000.00 642.97 0.00 59,357.03 98.93 10-542-546010 Clothing Expense 13,000.00 7,702.43 0.00 5,297.57 40.75 10-542-547010 Equipment Maintenance 3,200.00 0.00 0.00 3,200.00 100.00 10-542-547020 Maintenance Agreements 360.00 0.00 416.40 -56.40 -15.67 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 131,560.00 15,999.99 8,370.40 107,189.61 81.48 10-542-572010 Purchase Of Vehicles 216,225.89 0.00 216,225.89 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 216,225.89 0.00 216,225.89 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,810,133.23 605,409.69 224,596.29 2,980,127.25 78.2158 Grand Total -3,810,133.23 -605,409.69 -224,596.29 -2,980,127.25 0.7822 542 Public Works-Street 3,810,133.23 605,409.69 224,596.29 2,980,127.25 78.22 700 Transfers & Subsidies 10-700-590036 Transfer to Sales Tax G (45)0.00 0.00 0.00 0.00 0.00 10-700-590050 Transfer To Tif Fund 40,000.00 0.00 0.00 40,000.00 100.00 10-700-590051 Trans to Parks 0.00 0.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 0.00 0.00 0.00 0.00 0.00 10-700-590053 Trans to Parking 0.00 0.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 0.00 0.00 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 0.00 0.00 0.00 0.00 0.00 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 131,359.67 131,359.67 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,130,509.51 1,130,509.51 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 1,301,869.18 1,261,869.18 0.00 40,000.00 3.07 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,301,869.18 1,261,869.18 0.00 40,000.00 3.0725 Grand Total -1,301,869.18 -1,261,869.18 0.00 -40,000.00 0.0307 700 Transfers & Subsidies 1,301,869.18 1,261,869.18 0.00 40,000.00 3.07 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 750,000.00 0.00 0.00 750,000.00 100.00 10-990-540060 Cemetery Maintenance 22,710.00 0.00 0.00 22,710.00 100.00 10-990-572015 Vehicle Leasing 50,000.00 0.00 0.00 50,000.00 100.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 4,017.53 2,380.00 0.00 1,637.53 40.76 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 35,917.60 0.00 0.00 35,917.60 100.00 10-990-576008 Air Streets Stormwater 147,996.00 -15,343.85 154,535.60 8,804.25 5.95 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 0.00 0.00 0.00 0.00 10-990-576025 Douglas Davis Stormwater 7,065.35 0.00 0.00 7,065.35 100.00 10-990-576026 Pipe Lining - 2024 0.00 0.00 0.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 0.00 0.00 0.00 0.00 0.00 10-990-577078 S. Country Club Trail 169,762.00 0.00 0.00 169,762.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 149,920.25 12,900.00 132,100.00 4,920.25 3.28 10-990-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 568,879.67 349,679.24 219,200.43 0.00 0.00 10-990-599508 High Street Viaduct 948,172.75 0.00 98,000.00 850,172.75 89.66 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 8.44 0.00 0.00 8.44 100.00 E75 Capital Projects 3,848,789.27 349,615.39 603,836.03 2,895,337.85 75.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 4,598,789.27 349,615.39 603,836.03 3,645,337.85 79.2673 Grand Total -4,598,789.27 -349,615.39 -603,836.03 -3,645,337.85 0.7927 990 Capital Projects 4,598,789.27 349,615.39 603,836.03 3,645,337.85 79.27 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-995-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-995-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-995-599511 United Cap City Soccer Complex 0.00 0.00 0.00 0.00 0.00 E65 Other Non-Operating Expenses 0.00 0.00 0.00 0.00 0.00 10-995-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-995-572020 Purchase of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-599502 Downtown Beautification-Match 0.00 0.00 0.00 0.00 0.00 10-995-599503 Organizational Review Study 0.00 0.00 0.00 0.00 0.00 10-995-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 61,431,826.60 9,665,560.14 1,183,435.65 50,582,830.81 82.34 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 61,431,826.60 9,665,560.14 1,183,435.65 50,582,830.81 82.3398 Grand Total -61,431,826.60 -9,665,560.14 -1,183,435.65 -50,582,830.81 0.8234 GL - Trial Balance by Acct Type and Full Acct Number (01/10/2024 - 10:51 AM)Page 43