Loading...
HomeMy Public PortalAbout2024-02 Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 2/15/2024 8:43:08 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 16,200.00 0.00 49,725.00 75.43 10-110-501015 Salary-Prosecuting Attorney 34,999.92 8,749.98 0.00 26,249.94 75.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)18,146.13 1,855.57 0.00 16,290.56 89.77 10-110-502010 Social Security 9,108.94 2,023.91 0.00 7,085.03 77.78 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 28,901.05 0.00 99,350.53 77.47 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 25.00 14.50 0.00 10.50 42.00 10-110-512010 Printing 350.00 211.00 0.00 139.00 39.71 10-110-512020 Copies 15.00 3.12 0.00 11.88 79.20 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 514.62 0.00 1,310.38 71.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 311.14 0.00 2,088.86 87.04 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 50.00 0.00 750.00 93.75 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,838.06 0.00 2,861.94 29.50 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 (02/15/2024 - 08:43 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 36,253.73 133.72 104,529.13 74.178 Grand Total -140,916.58 -36,253.73 -133.72 -104,529.13 0.7418 110 Mayor & Council 140,916.58 36,253.73 133.72 104,529.13 74.18 120 City Clerk 10-120-501020 Salaries 60,416.48 15,801.17 0.00 44,615.31 73.85 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 1,122.12 0.00 3,499.74 75.72 10-120-502020 Group Health Insurance 14,599.86 3,339.41 0.00 11,260.45 77.13 10-120-502030 Retirement 7,129.15 1,864.56 0.00 5,264.59 73.85 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 74.66 17.14 0.00 57.52 77.04 10-120-502060 Long Term Disability 184.87 41.56 0.00 143.31 77.52 10-120-502070 Employee Assistance Prgm 21.84 5.11 0.00 16.73 76.60 E05 Personnel Services 87,098.71 22,241.06 0.00 64,857.65 74.46 10-120-511020 Postage 200.00 37.89 0.00 162.11 81.06 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 118.03 0.00 181.97 60.66 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 169.23 0.00 530.77 75.82 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 59.79 0.00 38,940.21 99.85 E15 Contractual Services 39,675.00 109.79 0.00 39,565.21 99.72 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 2,366.99 133.72 8,174.29 76.57 E25 Repairs & Maintenance 10,675.00 2,366.99 133.72 8,174.29 76.57 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 24,887.07 133.72 113,127.92 81.8885 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -138,148.71 -24,887.07 -133.72 -113,127.92 0.8189 120 City Clerk 138,148.71 24,887.07 133.72 113,127.92 81.89 140 City Administrator 10-140-501020 Salaries 342,835.98 60,217.36 0.00 282,618.62 82.44 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 4,454.39 0.00 21,772.56 83.02 10-140-502020 Group Health Insurance 27,965.91 6,629.79 0.00 21,336.12 76.29 10-140-502030 Retirement 40,454.65 6,918.61 0.00 33,536.04 82.90 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 411.26 64.40 0.00 346.86 84.34 10-140-502060 Long Term Disability 647.19 135.20 0.00 511.99 79.11 10-140-502070 Employee Assistance Prgm 65.52 10.23 0.00 55.29 84.39 E05 Personnel Services 438,808.68 78,631.20 0.00 360,177.48 82.08 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.66 0.00 73.34 97.79 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 82.45 0.00 217.55 72.52 E10 Materials & Supplies 1,025.00 191.99 0.00 833.01 81.27 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 25.00 0.00 475.00 95.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 497.92 0.00 -497.92 0.00 10-140-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,500.00 522.92 0.00 977.08 65.14 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 79,346.11 491.88 361,795.69 81.9221 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -441,633.68 -79,346.11 -491.88 -361,795.69 0.8192 140 City Administrator 441,633.68 79,346.11 491.88 361,795.69 81.92 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 2,322.16 0.00 78,953.84 97.14 10-142-502010 Social Security 0.00 148.73 0.00 -148.73 0.00 10-142-502020 Group Health Insurance 0.00 693.87 0.00 -693.87 0.00 10-142-502030 Retirement 0.00 274.03 0.00 -274.03 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 2.52 0.00 -2.52 0.00 10-142-502060 Long Term Disability 0.00 5.60 0.00 -5.60 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 3,446.91 0.00 77,829.09 95.76 10-142-522017 Rehabilitation 378,463.00 0.00 0.00 378,463.00 100.00 10-142-522018 Streetscaping 2,295,169.00 0.00 114,138.09 2,181,030.91 95.03 10-142-522021 Asbestos Abatement 291,574.00 1,443.69 0.00 290,130.31 99.50 10-142-522022 Demo 1,179,856.00 0.00 0.00 1,179,856.00 100.00 E15 Contractual Services 4,145,062.00 1,443.69 114,138.09 4,029,480.22 97.21 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 4,226,338.00 4,890.60 114,138.09 4,107,309.31 97.1836 Grand Total -4,226,338.00 -4,890.60 -114,138.09 -4,107,309.31 0.9718 142 Community Revitalization 4,226,338.00 4,890.60 114,138.09 4,107,309.31 97.18 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 (02/15/2024 - 08:43 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 5,546.82 0.00 19,727.73 78.05 10-145-502010 Social Security 320.10 381.15 0.00 -61.05 -19.07 10-145-502020 Group Health Insurance 367.06 1,391.44 0.00 -1,024.38 -279.08 10-145-502030 Retirement 114.61 654.51 0.00 -539.90 -471.08 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 6.44 0.00 -6.44 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 15.63 0.00 -15.63 0.00 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 26,081.34 7,995.99 0.00 18,085.35 69.34 10-145-520072 Subrecipient Reimbursements 1,577,640.06 198,077.39 0.00 1,379,562.67 87.44 E15 Contractual Services 1,577,640.06 198,077.39 0.00 1,379,562.67 87.44 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,603,721.40 206,073.38 0.00 1,397,648.02 87.1503 Grand Total -1,603,721.40 -206,073.38 0.00 -1,397,648.02 0.8715 145 CDBG-CV Cole Co EMS Station 1,603,721.40 206,073.38 0.00 1,397,648.02 87.15 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 33,921.37 9,191.81 0.00 24,729.56 72.90 10-146-502010 Social Security 0.00 638.89 0.00 -638.89 0.00 10-146-502020 Group Health Insurance 19.26 2,137.20 0.00 -2,117.94 -10,996.57 10-146-502030 Retirement 0.00 1,084.64 0.00 -1,084.64 0.00 10-146-502040 Workers Compensation 2.46 2.46 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 9.93 0.00 -9.93 0.00 10-146-502060 Long Term Disability 0.00 24.18 0.00 -24.18 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 33,943.09 13,089.11 0.00 20,853.98 61.44 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 13,089.11 0.00 661,745.80 98.0604 Grand Total -674,834.91 -13,089.11 0.00 -661,745.80 0.9806 146 HPF-P Bruhn Revitalization 674,834.91 13,089.11 0.00 661,745.80 98.06 147 CDBG-CV Transform Housing 10-147-501020 Salaries 18,486.80 3,189.82 0.00 15,296.98 82.75 10-147-502010 Social Security 299.07 203.53 0.00 95.54 31.95 10-147-502020 Group Health Insurance 537.69 992.39 0.00 -454.70 -84.57 10-147-502030 Retirement 310.64 376.40 0.00 -65.76 -21.17 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.13 3.89 0.00 -3.76 -2,892.31 10-147-502060 Long Term Disability 0.00 9.51 0.00 -9.51 0.00 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 19,637.77 4,775.54 0.00 14,862.23 75.68 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 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 4,775.54 0.00 558,614.48 99.1524 Grand Total -563,390.02 -4,775.54 0.00 -558,614.48 0.9915 147 CDBG-CV Transform Housing 563,390.02 4,775.54 0.00 558,614.48 99.15 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 14,535.53 0.00 56,365.96 79.50 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 1,089.87 0.00 -1,089.87 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 2,292.37 0.00 -2,292.37 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,715.18 0.00 -1,715.18 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 (02/15/2024 - 08:43 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 15.30 0.00 -15.30 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 37.07 0.00 -37.07 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 19,692.99 0.00 51,208.50 72.22 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 22.26 0.00 177.74 88.87 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 22.26 0.00 1,007.74 97.84 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,027.00 0.00 30,757.00 85.95 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,629.25 2,005.00 334,901.48 94.46 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 (02/15/2024 - 08:43 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 37,344.50 2,005.00 387,117.72 90.7731 Grand Total -426,467.22 -37,344.50 -2,005.00 -387,117.72 0.9077 149 Entitlement Grant 426,467.22 37,344.50 2,005.00 387,117.72 90.77 150 City Attorney 10-150-501020 Salaries 251,003.67 71,039.12 0.00 179,964.55 71.70 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 5,264.42 0.00 13,937.36 72.58 10-150-502020 Group Health Insurance 38,330.74 8,850.01 0.00 29,480.73 76.91 10-150-502030 Retirement 29,618.43 6,177.47 0.00 23,440.96 79.14 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 307.22 73.41 0.00 233.81 76.11 10-150-502060 Long Term Disability 629.25 177.56 0.00 451.69 71.78 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 91,828.12 0.00 247,559.28 72.94 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 142.97 0.00 357.03 71.41 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 88.21 0.00 -88.21 0.00 10-150-513010 Office Supplies 500.00 115.07 0.00 384.93 76.99 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 346.25 0.00 653.75 65.38 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,563.96 4,164.43 771.61 9.08 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 41.44 0.00 458.56 91.71 10-150-525031 Special Litigation Expenses 0.00 26,309.31 0.00 -26,309.31 0.00 E15 Contractual Services 26,000.00 29,914.71 4,164.43 -8,079.14 -31.07 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 (02/15/2024 - 08:43 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 122,089.08 4,598.11 240,140.21 65.4641 Grand Total -366,827.40 -122,089.08 -4,598.11 -240,140.21 0.6546 150 City Attorney 366,827.40 122,089.08 4,598.11 240,140.21 65.46 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 8,749.98 0.00 26,249.94 75.00 10-160-501020 Salaries 142,510.04 37,271.89 0.00 105,238.15 73.85 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 1,394.02 0.00 5,605.98 80.09 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 3,581.51 0.00 10,533.50 74.63 10-160-502020 Group Health Insurance 23,221.30 4,870.79 0.00 18,350.51 79.02 10-160-502030 Retirement 16,816.18 4,398.06 0.00 12,418.12 73.85 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 176.26 39.13 0.00 137.13 77.80 10-160-502060 Long Term Disability 436.08 94.31 0.00 341.77 78.37 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 60,613.20 0.00 178,925.28 74.70 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 490.18 0.00 1,509.82 75.49 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 501.98 0.00 4,398.02 89.76 10-160-520025 Security 14,000.00 3,433.23 0.00 10,566.77 75.48 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 225.00 0.00 1,275.00 85.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 780.00 0.00 2,220.00 74.00 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 4,438.23 0.00 18,851.77 80.94 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 (02/15/2024 - 08:43 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 920.00 1,316.40 4,058.60 64.47 E25 Repairs & Maintenance 6,295.00 920.00 1,316.40 4,058.60 64.47 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 66,473.41 1,316.40 206,233.67 75.2613 Grand Total -274,023.48 -66,473.41 -1,316.40 -206,233.67 0.7526 160 Municipal Court 274,023.48 66,473.41 1,316.40 206,233.67 75.26 170 Human Resources 10-170-501020 Salaries 248,975.73 65,105.88 0.00 183,869.85 73.85 10-170-501050 Parttime(wo Benefits)13,000.00 4,761.00 0.00 8,239.00 63.38 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 5,296.62 0.00 14,752.17 73.58 10-170-502020 Group Health Insurance 27,922.60 6,043.72 0.00 21,878.88 78.36 10-170-502030 Retirement 29,390.94 7,682.47 0.00 21,708.47 73.86 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 304.78 69.18 0.00 235.60 77.30 10-170-502060 Long Term Disability 627.76 168.53 0.00 459.23 73.15 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 89,468.43 0.00 251,293.38 73.74 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 39.00 0.00 261.00 87.00 10-170-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-170-512020 Copies 500.00 85.27 0.00 414.73 82.95 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 185.07 0.00 2,164.93 92.12 10-170-520030 Dues And Publications 700.00 67.50 0.00 632.50 90.36 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 91.59 0.00 2,908.41 96.95 10-170-520070 Training And Education 4,437.00 365.00 0.00 4,072.00 91.77 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 524.09 0.00 9,912.91 94.98 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 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 16,528.59 491.88 42,692.98 71.50 E25 Repairs & Maintenance 59,713.45 16,528.59 491.88 42,692.98 71.50 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 106,706.18 491.88 306,064.20 74.0605 Grand Total -413,262.26 -106,706.18 -491.88 -306,064.20 0.7406 170 Human Resources 413,262.26 106,706.18 491.88 306,064.20 74.06 180 Finance Department 10-180-501020 Salaries 591,685.24 145,180.28 0.00 446,504.96 75.46 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 10,888.33 0.00 34,375.59 75.94 10-180-502020 Group Health Insurance 110,372.73 21,779.25 0.00 88,593.48 80.27 10-180-502030 Retirement 69,818.86 17,131.23 0.00 52,687.63 75.46 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 730.73 157.51 0.00 573.22 78.44 10-180-502060 Long Term Disability 1,792.67 380.62 0.00 1,412.05 78.77 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 196,059.82 0.00 624,337.94 76.10 10-180-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-180-511020 Postage 10,000.00 3,554.72 0.00 6,445.28 64.45 10-180-511021 Mail Machine Cost 3,000.00 1,352.53 0.00 1,647.47 54.92 10-180-512010 Printing 4,000.00 0.00 0.00 4,000.00 100.00 10-180-512020 Copies 100.00 6.13 0.00 93.87 93.87 10-180-512021 Copy Machine Cost 190.00 -303.99 0.00 493.99 259.99 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 4,648.99 0.00 18,046.01 79.52 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,041.99 0.00 58.01 5.27 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 (02/15/2024 - 08:43 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,795.44 0.00 63,969.44 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,542.50 1,249.20 366.10 2.59 E25 Repairs & Maintenance 14,157.80 12,542.50 1,249.20 366.10 2.59 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 223,046.75 1,249.20 706,719.49 75.9085 Grand Total -931,015.44 -223,046.75 -1,249.20 -706,719.49 0.7591 180 Finance Department 931,015.44 223,046.75 1,249.20 706,719.49 75.91 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 4,672.01 0.00 17,327.99 78.76 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 12,720.43 26,425.33 50,166.59 56.17 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 6,884.01 0.00 43,115.99 86.23 10-185-521030 Self Ins Prop & Casualty 40,000.00 9,594.54 0.00 30,405.46 76.01 10-185-521060 Drugalcohol screening 3,564.00 298.00 0.00 3,266.00 91.64 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 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 251.25 0.00 -251.25 0.00 10-185-522020 Professional Services 112,388.00 15,597.00 18,900.00 77,891.00 69.31 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 92,500.00 0.00 92,500.00 50.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 485,878.23 18,900.00 518,344.95 50.66 10-185-531010 Electricity 35,200.00 6,199.77 0.00 29,000.23 82.39 10-185-533010 Natural Gas 6,510.00 3,148.88 0.00 3,361.12 51.63 10-185-535010 Water 7,250.00 1,500.06 0.00 5,749.94 79.31 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 48,960.00 10,848.71 0.00 38,111.29 77.84 10-185-540010 Building & Grounds Maint.40,000.00 85,981.30 0.00 -45,981.30 -114.95 10-185-540015 Amtrak Station 4,000.00 571.65 0.00 3,428.35 85.71 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 600.00 0.00 1,460.00 70.87 E25 Repairs & Maintenance 71,060.00 87,152.95 0.00 -16,092.95 -22.65 10-185-550010 Miscellaneous 2,800.00 488.00 0.00 2,312.00 82.57 10-185-550015 Bad Debt Expense 0.00 20.00 0.00 -20.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 273,643.50 0.00 -110,174.42 -67.40 E30 Other Operating Expenses 176,269.08 274,151.50 0.00 -97,882.42 -55.53 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 (02/15/2024 - 08:43 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 873,306.70 45,325.33 527,060.01 36.4573 Grand Total -1,445,692.04 -873,306.70 -45,325.33 -527,060.01 0.3646 185 Non-Departmental 1,445,692.04 873,306.70 45,325.33 527,060.01 36.46 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 27,950.00 16,075.82 0.00 11,874.18 42.48 E25 Repairs & Maintenance 27,950.00 16,075.82 0.00 11,874.18 42.48 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 27,950.00 16,075.82 0.00 11,874.18 42.4836 Grand Total -27,950.00 -16,075.82 0.00 -11,874.18 0.4248 186 Emerg Mgmt Operations 27,950.00 16,075.82 0.00 11,874.18 42.48 190 Information Technology Svcs 10-190-501020 Salaries 652,615.68 159,893.17 0.00 492,722.51 75.50 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 11,936.56 0.00 37,988.54 76.09 10-190-502020 Group Health Insurance 99,908.29 20,002.53 0.00 79,905.76 79.98 10-190-502030 Retirement 77,008.65 17,308.03 0.00 59,700.62 77.52 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 798.05 171.66 0.00 626.39 78.49 10-190-502060 Long Term Disability 1,924.15 414.98 0.00 1,509.17 78.43 10-190-502070 Employee Assistance Prgm 223.86 48.59 0.00 175.27 78.29 E05 Personnel Services 883,761.99 211,133.73 0.00 672,628.26 76.11 10-190-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-190-511020 Postage 50.00 1.26 0.00 48.74 97.48 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 0.19 0.00 9.81 98.10 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 114.38 0.00 385.62 77.12 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 (02/15/2024 - 08:43 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 323.98 0.00 3,676.02 91.90 E10 Materials & Supplies 4,560.00 439.81 0.00 4,120.19 90.36 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 25.00 0.00 7,475.00 99.67 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 1,312.88 6,237.38 69.30 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 7,278.30 0.00 15,721.70 68.36 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 8,753.04 1,312.88 33,984.08 77.15 10-190-534010 Telephone 90,000.00 22,291.90 0.00 67,708.10 75.23 E20 Utilities 90,000.00 22,291.90 0.00 67,708.10 75.23 10-190-545010 Software License\maint 233,000.00 164,435.77 8,210.58 60,353.65 25.90 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 164,435.77 8,626.98 82,417.25 32.26 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-190-572021 Purchase of Equipment-ONE TIME 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 407,054.25 9,939.86 860,857.88 67.3676 Grand Total -1,277,851.99 -407,054.25 -9,939.86 -860,857.88 0.6737 190 Information Technology Svcs 1,277,851.99 407,054.25 9,939.86 860,857.88 67.37 300 Police Department 10-300-501020 Salaries 5,585,563.46 1,437,936.15 0.00 4,147,627.31 74.26 10-300-501030 Holiday Pay 179,249.71 75,477.60 0.00 103,772.11 57.89 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 7,794.29 0.00 39,509.89 83.52 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 2,682.57 0.00 2,317.43 46.35 10-300-501090 Overtime 263,762.11 79,484.57 0.00 184,277.54 69.87 10-300-501095 Overtime Straight Pay 13,275.00 4,430.75 0.00 8,844.25 66.62 10-300-502010 Social Security 465,407.81 117,979.14 0.00 347,428.67 74.65 10-300-502020 Group Health Insurance 1,060,092.76 228,029.30 0.00 832,063.46 78.49 10-300-502030 Retirement 996,597.99 247,877.18 0.00 748,720.81 75.13 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502040 Workers Compensation 75,084.94 75,084.94 0.00 0.00 0.00 10-300-502050 Life Insurance 6,900.98 1,539.31 0.00 5,361.67 77.69 10-300-502060 Long Term Disability 16,618.95 3,734.30 0.00 12,884.65 77.53 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 2,282,513.00 0.00 6,482,181.02 73.96 10-300-511010 Advertising 5,665.00 0.00 0.00 5,665.00 100.00 10-300-511020 Postage 1,395.00 442.89 0.00 952.11 68.25 10-300-512010 Printing 5,952.00 627.17 0.00 5,324.83 89.46 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 4,197.36 0.00 11,473.14 73.21 10-300-514010 Gas 195,940.00 46,475.00 0.00 149,465.00 76.28 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 1,243.75 681.84 0.00 561.91 45.18 10-300-515040 First Aid Supplies 1,378.00 959.89 0.00 418.11 30.34 10-300-516010 Ammunition & Firearms Supplies 65,000.00 23,721.48 41,775.40 -496.88 -0.76 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,250.00 0.00 2,850.00 25.68 10-300-517010 Operational Supplies 48,591.90 18,016.84 11,695.42 18,879.64 38.85 E10 Materials & Supplies 356,121.15 103,707.47 53,470.82 198,942.86 55.86 10-300-520030 Dues And Publications 5,400.00 3,851.40 0.00 1,548.60 28.68 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 15,606.66 0.00 38,413.34 71.11 10-300-520080 Tuition Reimbursement 11,625.00 900.00 0.00 10,725.00 92.26 10-300-520090 Recruitment 50,000.00 25,000.00 0.00 25,000.00 50.00 10-300-521040 Medical Claimsservices 6,510.00 2,892.00 0.00 3,618.00 55.58 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,450.00 19,059.92 0.00 -2,609.92 -15.87 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 67,308.50 0.00 78,742.50 53.91 10-300-531010 Electricity 44,640.00 12,973.27 0.00 31,666.73 70.94 10-300-533010 Natural Gas 1,116.00 338.64 0.00 777.36 69.66 10-300-534010 Telephone 24,101.00 8,566.22 0.00 15,534.78 64.46 10-300-535010 Water 3,348.00 979.20 0.00 2,368.80 70.75 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 73,205.00 22,857.33 0.00 50,347.67 68.78 10-300-540010 Building & Grounds Maint.60,000.00 3,195.21 0.00 56,804.79 94.67 10-300-541030 Vehicle Wash 9,752.00 5,766.52 0.00 3,985.48 40.87 10-300-544010 K-9 Operations 16,740.00 1,181.41 0.00 15,558.59 92.94 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 75,521.54 1,500.00 23,135.96 23.10 10-300-546010 Clothing Expense 60,137.69 6,250.39 51,878.74 2,008.56 3.34 10-300-546020 Uniform Cleaning 23,715.00 6,402.00 0.00 17,313.00 73.00 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,899.35 7,945.80 59,456.73 74.98 10-300-547030 Radio Maintenance 8,025.00 641.27 0.00 7,383.73 92.01 E25 Repairs & Maintenance 367,829.07 110,857.69 61,324.54 195,646.84 53.19 10-300-572010 Purchase Of Vehicles 233,200.00 211,760.00 15,415.00 6,025.00 2.58 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 205,490.00 33,507.50 49,956.07 122,026.43 59.38 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 567,218.18 245,267.50 65,371.07 256,579.61 45.23 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 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,275,118.42 2,832,511.49 180,166.43 7,262,440.50 70.6799 Grand Total -10,275,118.42 -2,832,511.49 -180,166.43 -7,262,440.50 0.7068 300 Police Department 10,275,118.42 2,832,511.49 180,166.43 7,262,440.50 70.68 310 School Resource Officer 10-310-501020 Salaries 501,710.46 105,574.72 0.00 396,135.74 78.96 10-310-501030 Holiday Pay 21,214.01 0.00 0.00 21,214.01 100.00 10-310-501090 Overtime 45,106.00 17,740.78 0.00 27,365.22 60.67 10-310-501095 Overtime Straight Pay 1,311.00 895.89 0.00 415.11 31.66 10-310-502010 Social Security 43,554.63 8,955.09 0.00 34,599.54 79.44 10-310-502020 Group Health Insurance 104,608.25 19,762.36 0.00 84,845.89 81.11 10-310-502030 Retirement 96,788.06 21,115.95 0.00 75,672.11 78.18 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 615.82 117.09 0.00 498.73 80.99 10-310-502060 Long Term Disability 1,528.69 285.05 0.00 1,243.64 81.35 10-310-502070 Employee Assistance Prgm 174.72 40.92 0.00 133.80 76.58 E05 Personnel Services 823,164.50 181,040.71 0.00 642,123.79 78.01 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 181,852.51 3,980.65 670,711.74 78.3043 Grand Total -856,544.90 -181,852.51 -3,980.65 -670,711.74 0.783 310 School Resource Officer 856,544.90 181,852.51 3,980.65 670,711.74 78.30 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 130,750.33 33,948.20 0.00 96,802.13 74.04 10-320-501030 Holiday Pay 5,452.54 0.00 0.00 5,452.54 100.00 10-320-501090 Overtime 30,089.28 8,586.65 0.00 21,502.63 71.46 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-501095 Overtime Straight Pay 0.00 622.82 0.00 -622.82 0.00 10-320-502010 Social Security 11,287.82 3,123.69 0.00 8,164.13 72.33 10-320-502020 Group Health Insurance 22,743.74 5,176.59 0.00 17,567.15 77.24 10-320-502030 Retirement 25,084.04 7,336.80 0.00 17,747.24 70.75 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 157.90 37.13 0.00 120.77 76.49 10-320-502060 Long Term Disability 394.37 90.20 0.00 304.17 77.13 10-320-502070 Employee Assistance Prgm 43.68 10.23 0.00 33.45 76.58 E05 Personnel Services 228,008.09 60,936.70 0.00 167,071.39 73.27 10-320-514010 Gas 11,327.53 2,002.94 0.00 9,324.59 82.32 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 2,390.00 0.00 12,716.00 84.18 10-320-517010 Operational Supplies 1,200.00 570.90 0.00 629.10 52.43 E10 Materials & Supplies 27,633.53 4,963.84 0.00 22,669.69 82.04 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 3,600.00 0.00 14,900.00 80.54 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,500.00 3,600.00 0.00 14,900.00 80.54 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 69,500.54 0.00 204,641.08 74.6479 Grand Total -274,141.62 -69,500.54 0.00 -204,641.08 0.7465 320 M.U.S.T.A.N.G.274,141.62 69,500.54 0.00 204,641.08 74.65 330 Animal Control 10-330-501020 Salaries 394,208.69 100,707.87 0.00 293,500.82 74.45 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 2,266.85 0.00 6,333.15 73.64 10-330-501090 Overtime 2,000.00 456.07 0.00 1,543.93 77.20 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 30,967.86 7,247.88 0.00 23,719.98 76.60 10-330-502020 Group Health Insurance 101,449.34 20,432.77 0.00 81,016.57 79.86 10-330-502030 Retirement 47,767.43 9,914.00 0.00 37,853.43 79.25 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 487.15 109.26 0.00 377.89 77.57 10-330-502060 Long Term Disability 1,175.12 262.72 0.00 912.40 77.64 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 146,119.42 0.00 445,391.97 75.30 10-330-511010 Advertising 905.00 62.25 0.00 842.75 93.12 10-330-511020 Postage 152.00 5.01 0.00 146.99 96.70 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 1,924.04 0.00 9,075.96 82.51 E10 Materials & Supplies 16,016.00 2,295.23 0.00 13,720.77 85.67 10-330-520030 Dues And Publications 900.00 370.00 0.00 530.00 58.89 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 584.54 0.00 105.46 15.28 10-330-522020 Professional Services 4,830.00 444.50 0.00 4,385.50 90.80 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 3,896.96 0.00 10,342.04 72.63 10-330-531010 Electricity 25,067.90 3,511.02 0.00 21,556.88 85.99 10-330-533010 Natural Gas 22,050.00 3,740.18 0.00 18,309.82 83.04 10-330-534010 Telephone 810.00 137.80 0.00 672.20 82.99 10-330-535010 Water 3,800.00 1,185.56 0.00 2,614.44 68.80 E20 Utilities 51,727.90 8,574.56 0.00 43,153.34 83.42 10-330-540010 Building & Grounds Maint.15,000.00 2,069.54 0.00 12,930.46 86.20 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 18,210.64 0.00 31,079.36 63.05 10-330-544050 Animal Food 6,603.00 723.55 0.00 5,879.45 89.04 10-330-545010 Software Licensemaint 8,087.00 2,570.05 0.00 5,516.95 68.22 10-330-546010 Clothing Expense 2,325.00 1,102.62 0.00 1,222.38 52.58 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 2,230.00 0.00 0.00 2,230.00 100.00 E25 Repairs & Maintenance 85,796.40 25,216.40 416.40 60,163.60 70.12 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 186,102.57 416.40 572,771.72 75.4351 Grand Total -759,290.69 -186,102.57 -416.40 -572,771.72 0.7544 330 Animal Control 759,290.69 186,102.57 416.40 572,771.72 75.44 390 9-1-1 Police 10-390-501020 Salaries 1,053,365.22 237,174.43 0.00 816,190.79 77.48 10-390-501030 Holiday Pay 40,668.88 18,373.70 0.00 22,295.18 54.82 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 529.48 0.00 -529.48 0.00 10-390-501090 Overtime 22,814.00 19,230.40 0.00 3,583.60 15.71 10-390-501095 Overtime Straight Pay 500.00 897.00 0.00 -397.00 -79.40 10-390-502010 Social Security 85,477.13 20,306.13 0.00 65,171.00 76.24 10-390-502020 Group Health Insurance 232,987.77 42,108.08 0.00 190,879.69 81.93 10-390-502030 Retirement 136,605.11 32,149.20 0.00 104,455.91 76.47 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 254.40 0.00 1,047.94 80.47 10-390-502060 Long Term Disability 3,220.09 613.68 0.00 2,606.41 80.94 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 374,465.15 0.00 1,205,653.99 76.30 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 5,246.58 0.00 978.42 15.72 E10 Materials & Supplies 7,625.00 5,246.58 0.00 2,378.42 31.19 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 413.45 0.00 3,886.55 90.38 10-390-523010 Equipment Rentlease 99,260.00 20,389.58 0.00 78,870.42 79.46 E15 Contractual Services 109,768.00 21,519.87 0.00 88,248.13 80.40 10-390-531010 Electricity 12,276.00 0.00 0.00 12,276.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-533010 Natural Gas 292.95 0.00 0.00 292.95 100.00 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 57,952.29 0.00 -4,537.29 -8.49 10-390-546010 Clothing Expense 5,580.00 3,722.72 0.00 1,857.28 33.28 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 30,632.06 0.00 48,924.34 61.50 10-390-547030 Radio Maintenance 4,650.00 0.00 1,866.04 2,783.96 59.87 E25 Repairs & Maintenance 150,377.40 92,307.07 1,866.04 56,204.29 37.38 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 493,538.67 1,866.04 1,365,890.78 73.3839 Grand Total -1,861,295.49 -493,538.67 -1,866.04 -1,365,890.78 0.7338 390 9-1-1 Police 1,861,295.49 493,538.67 1,866.04 1,365,890.78 73.38 400 Fire Department 10-400-501020 Salaries 4,690,038.81 1,127,172.86 0.00 3,562,865.95 75.97 10-400-501025 Other Hours 0.00 3,576.37 0.00 -3,576.37 0.00 10-400-501030 Holiday Pay 388,303.41 201,730.54 0.00 186,572.87 48.05 10-400-501035 Training & Essential Functions 82,395.68 12,073.75 0.00 70,321.93 85.35 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 11,640.07 0.00 44,093.26 79.11 10-400-501090 Overtime-FLSA 195,037.45 142,898.83 0.00 52,138.62 26.73 10-400-501092 Overtime-Constant Staffing 187,813.69 20,680.24 0.00 167,133.45 88.99 10-400-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-400-502010 Social Security 83,367.55 21,829.54 0.00 61,538.01 73.82 10-400-502020 Group Health Insurance 946,285.13 221,223.39 0.00 725,061.74 76.62 10-400-502030 Retirement 2,805,502.77 758,759.35 0.00 2,046,743.42 72.95 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 1,259.39 0.00 4,459.14 77.98 10-400-502060 Long Term Disability 13,863.74 3,048.39 0.00 10,815.35 78.01 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 2,679,312.40 0.00 6,930,938.48 72.12 10-400-511010 Advertising 300.00 57.00 0.00 243.00 81.00 10-400-511020 Postage 120.00 145.56 0.00 -25.56 -21.30 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 234.84 0.00 1,160.16 83.17 10-400-514010 Gas 91,180.00 18,230.72 0.00 72,949.28 80.01 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 10-400-514030 Small Tools 6,000.00 4,992.84 0.00 1,007.16 16.79 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 272.18 0.00 1,827.82 87.04 10-400-517010 Operational Supplies 18,000.00 3,277.76 0.00 14,722.24 81.79 E10 Materials & Supplies 120,645.00 27,210.90 0.00 93,434.10 77.45 10-400-520030 Dues And Publications 3,400.00 1,640.54 0.00 1,759.46 51.75 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 10,074.24 0.00 23,925.76 70.37 10-400-520080 Tuition Reimbursement 7,500.00 5,616.00 0.00 1,884.00 25.12 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 67.45 0.00 4,932.55 98.65 10-400-529040 Child Safety Seat Pass-through 2,500.00 550.00 0.00 1,950.00 78.00 E15 Contractual Services 102,653.70 26,049.03 0.00 76,604.67 74.62 10-400-531010 Electricity 38,500.00 7,910.12 0.00 30,589.88 79.45 10-400-533010 Natural Gas 20,000.00 7,503.73 0.00 12,496.27 62.48 10-400-534010 Telephone 25,984.20 9,284.14 0.00 16,700.06 64.27 10-400-535010 Water 12,000.00 3,316.88 0.00 8,683.12 72.36 E20 Utilities 96,484.20 28,014.87 0.00 68,469.33 70.96 10-400-540010 Building & Grounds Maint.113,040.00 39,767.54 825.00 72,447.46 64.09 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 98,000.00 39,854.08 0.00 58,145.92 59.33 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,000.00 8,558.33 0.00 11,441.67 57.21 10-400-547020 Maintenance Agreements 39,487.20 9,548.25 1,259.36 28,679.59 72.63 10-400-547030 Radio Maintenance 20,925.00 5,494.88 0.00 15,430.12 73.74 E25 Repairs & Maintenance 291,952.20 103,223.08 2,084.36 186,644.76 63.93 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 18,125.58 0.00 90,274.19 83.28 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 561,016.58 0.00 90,274.19 13.86 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,873,276.75 3,424,826.86 2,084.36 7,446,365.53 68.4832 Grand Total -10,873,276.75 -3,424,826.86 -2,084.36 -7,446,365.53 0.6848 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 400 Fire Department 10,873,276.75 3,424,826.86 2,084.36 7,446,365.53 68.48 401 Fire Museum 10-401-531010 Electricity 1,900.00 299.62 0.00 1,600.38 84.23 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 300.00 12.74 0.00 287.26 95.75 E20 Utilities 2,200.00 312.36 0.00 1,887.64 85.80 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 312.36 0.00 1,887.64 85.8018 Grand Total -2,200.00 -312.36 0.00 -1,887.64 0.858 401 Fire Museum 2,200.00 312.36 0.00 1,887.64 85.80 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 (02/15/2024 - 08:43 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 59,221.19 0.00 187,824.77 76.03 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 4,369.94 0.00 14,529.08 76.88 10-520-502020 Group Health Insurance 57,799.07 11,293.44 0.00 46,505.63 80.46 10-520-502030 Retirement 29,151.42 5,439.66 0.00 23,711.76 81.34 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 303.55 66.49 0.00 237.06 78.10 10-520-502060 Long Term Disability 660.64 161.94 0.00 498.70 75.49 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 80,764.90 0.00 273,379.02 77.19 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 15.75 0.00 59.25 79.00 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 566.03 0.00 283.97 33.41 10-520-514010 Gas 16,490.00 4,105.33 0.00 12,384.67 75.10 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 491.74 0.00 8.26 1.65 E10 Materials & Supplies 18,015.00 5,178.85 0.00 12,836.15 71.25 10-520-520030 Dues And Publications 1,200.00 688.00 0.00 512.00 42.67 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 688.00 0.00 5,312.00 88.53 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 34,902.55 33,776.53 1,091.79 34.23 0.10 E25 Repairs & Maintenance 34,902.55 33,776.53 1,091.79 34.23 0.10 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 120,408.28 1,091.79 291,561.40 70.5855 Grand Total -413,061.47 -120,408.28 -1,091.79 -291,561.40 0.7059 520 Plan & Protect Svcs-Admin 413,061.47 120,408.28 1,091.79 291,561.40 70.59 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 93,573.53 28,632.47 0.00 64,941.06 69.40 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 2,143.19 0.00 5,015.19 70.06 10-521-502020 Group Health Insurance 16,621.90 4,461.70 0.00 12,160.20 73.16 10-521-502030 Retirement 11,041.68 3,378.48 0.00 7,663.20 69.40 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 115.06 30.53 0.00 84.53 73.47 10-521-502060 Long Term Disability 285.42 73.66 0.00 211.76 74.19 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 38,892.19 0.00 90,094.89 69.85 10-521-511010 Advertising 3,336.00 598.00 0.00 2,738.00 82.07 10-521-511020 Postage 500.00 20.16 0.00 479.84 95.97 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 638.94 0.00 5,697.06 89.92 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 15,709.68 0.00 0.00 15,709.68 100.00 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 470.44 798.35 66.21 4.96 E25 Repairs & Maintenance 1,335.00 470.44 798.35 66.21 4.96 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 40,001.57 798.35 111,567.84 73.2227 Grand Total -152,367.76 -40,001.57 -798.35 -111,567.84 0.7322 521 Plan & Protect Svcs-Planning 152,367.76 40,001.57 798.35 111,567.84 73.22 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 109,870.24 24,568.42 0.00 85,301.82 77.64 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,861.34 0.00 6,543.73 77.85 10-522-502020 Group Health Insurance 16,621.90 3,130.34 0.00 13,491.56 81.17 10-522-502030 Retirement 12,964.69 2,899.17 0.00 10,065.52 77.64 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 135.86 26.73 0.00 109.13 80.33 10-522-502060 Long Term Disability 335.28 64.30 0.00 270.98 80.82 10-522-502070 Employee Assistance Prgm 32.76 11.76 0.00 21.00 64.10 E05 Personnel Services 148,468.35 32,664.61 0.00 115,803.74 78.00 10-522-511010 Advertising 2,600.00 148.00 0.00 2,452.00 94.31 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 187.89 0.00 812.11 81.21 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 657.57 0.00 342.43 34.24 E10 Materials & Supplies 5,600.00 1,032.11 0.00 4,567.89 81.57 10-522-520030 Dues And Publications 1,500.00 285.00 0.00 1,215.00 81.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 744.00 3,890.60 34,365.40 88.12 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-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-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 398.49 722.96 1,278.55 53.27 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 398.49 722.96 1,278.55 53.27 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 34,839.21 4,613.56 159,415.58 80.1614 Grand Total -198,868.35 -34,839.21 -4,613.56 -159,415.58 0.8016 522 Plan & Protect Svcs-MPO 198,868.35 34,839.21 4,613.56 159,415.58 80.16 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,845.53 4,738.79 0.00 53,106.74 91.81 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 336.85 0.00 -336.85 0.00 10-530-502020 Group Health Insurance 0.00 915.10 0.00 -915.10 0.00 10-530-502030 Retirement 0.00 559.19 0.00 -559.19 0.00 10-530-502040 Workers Compensation 145.11 145.11 0.00 0.00 0.00 10-530-502050 Life Insurance 0.00 4.33 0.00 -4.33 0.00 10-530-502060 Long Term Disability 0.00 10.36 0.00 -10.36 0.00 10-530-502070 Employee Assistance Prgm 0.00 5.11 0.00 -5.11 0.00 E05 Personnel Services 57,990.64 6,714.84 0.00 51,275.80 88.42 10-530-511010 Advertising 415.00 0.00 0.00 415.00 100.00 10-530-511020 Postage 100.00 3.19 0.00 96.81 96.81 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 84.23 0.00 385.77 82.08 E10 Materials & Supplies 1,085.00 250.98 0.00 834.02 76.87 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 147.00 0.00 4,353.00 96.73 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 7,500.00 0.00 24,683.65 76.70 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 13,364.38 0.00 9,635.62 41.89 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-524029 Recycling Education 35,761.33 0.00 0.00 35,761.33 100.00 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 21,011.38 0.00 79,683.60 79.13 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 242.71 417.22 1,081.09 62.10 E25 Repairs & Maintenance 1,741.02 242.71 417.22 1,081.09 62.10 10-530-550020 NRA-Residential 40,000.00 15,875.91 0.00 24,124.09 60.31 10-530-550030 NRA-Commercial Facade 17,562.80 0.00 0.00 17,562.80 100.00 10-530-550031 Historic Preservation Grant 24,912.44 0.00 22,975.24 1,937.20 7.78 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 31,794.91 22,975.24 70,632.59 56.32 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 286,914.38 60,014.82 23,392.46 203,507.10 70.9296 Grand Total -286,914.38 -60,014.82 -23,392.46 -203,507.10 0.7093 530 Plan & Protect Svc-RedevGrant 286,914.38 60,014.82 23,392.46 203,507.10 70.93 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 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 57,071.02 0.00 160,161.37 73.73 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 4,349.45 0.00 12,268.83 73.83 10-532-502020 Group Health Insurance 44,266.53 10,660.24 0.00 33,606.29 75.92 10-532-502030 Retirement 25,633.42 7,106.68 0.00 18,526.74 72.28 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502050 Life Insurance 266.83 54.97 0.00 211.86 79.40 10-532-502060 Long Term Disability 661.06 151.27 0.00 509.79 77.12 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 83,162.39 0.00 225,335.06 73.04 10-532-511010 Advertising 90.00 147.25 0.00 -57.25 -63.61 10-532-511020 Postage 150.00 62.07 0.00 87.93 58.62 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 92.98 0.00 1,207.02 92.85 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 302.30 0.00 2,322.70 88.48 10-532-520030 Dues And Publications 900.00 345.00 0.00 555.00 61.67 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 26,140.70 0.00 168,259.30 86.55 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 26,575.70 0.00 170,324.30 86.50 10-532-534010 Telephone 1,500.00 371.16 0.00 1,128.84 75.26 E20 Utilities 1,500.00 371.16 0.00 1,128.84 75.26 10-532-540060 Cemetery Maintenance 39,000.00 6,339.41 28,503.00 4,157.59 10.66 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 160.00 0.00 920.00 85.19 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 163.59 1,110.45 -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 7,947.00 29,613.45 4,759.55 11.25 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 551,842.45 118,358.55 29,613.45 403,870.45 73.1858 Grand Total -551,842.45 -118,358.55 -29,613.45 -403,870.45 0.7319 532 Plan & Protect Svcs-Env Health 551,842.45 118,358.55 29,613.45 403,870.45 73.19 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 167,225.57 42,341.51 0.00 124,884.06 74.68 10-533-501050 Parttime(wo Benefits)20,000.00 13,747.00 0.00 6,253.00 31.27 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 4,233.41 0.00 10,089.35 70.44 10-533-502020 Group Health Insurance 27,353.91 6,170.11 0.00 21,183.80 77.44 10-533-502030 Retirement 19,732.62 4,738.99 0.00 14,993.63 75.98 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 206.86 43.85 0.00 163.01 78.80 10-533-502060 Long Term Disability 511.71 100.98 0.00 410.73 80.27 10-533-502070 Employee Assistance Prgm 65.52 17.90 0.00 47.62 72.68 E05 Personnel Services 251,676.33 73,651.13 0.00 178,025.20 70.74 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.00 291.04 0.00 1,508.96 83.83 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 637.02 0.00 712.98 52.81 E10 Materials & Supplies 4,690.00 928.06 0.00 3,761.94 80.21 10-533-520030 Dues And Publications 500.00 125.00 0.00 375.00 75.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 607.21 0.00 592.79 49.40 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,660.00 0.00 5,340.00 53.40 10-533-522022 Demo 59,610.00 36,884.62 5,519.87 17,205.51 28.86 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 42,276.83 5,519.87 58,190.85 54.90 10-533-534010 Telephone 3,701.40 1,417.53 0.00 2,283.87 61.70 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 3,701.40 1,417.53 0.00 2,283.87 61.70 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 112.22 0.00 1,167.78 91.23 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 327.49 1,045.93 -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 709.71 1,045.93 1,095.36 38.42 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 118,983.26 6,565.80 243,357.22 65.9672 Grand Total -368,906.28 -118,983.26 -6,565.80 -243,357.22 0.6597 533 PPS - Prop MaintCode Enforce 368,906.28 118,983.26 6,565.80 243,357.22 65.97 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 325,779.08 85,183.45 0.00 240,595.63 73.85 10-534-501050 Parttime(wo Benefits)15,900.00 3,646.42 0.00 12,253.58 77.07 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 6,257.41 0.00 19,881.04 76.06 10-534-502020 Group Health Insurance 88,283.39 20,197.24 0.00 68,086.15 77.12 10-534-502030 Retirement 38,441.93 10,051.63 0.00 28,390.30 73.85 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 399.02 88.93 0.00 310.09 77.71 10-534-502060 Long Term Disability 991.38 222.11 0.00 769.27 77.60 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 130,433.95 0.00 370,364.57 73.95 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 88.44 0.00 1,011.56 91.96 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 84.40 0.00 815.60 90.62 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 172.84 0.00 3,942.16 95.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 2,668.81 0.00 3,331.19 55.52 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 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 2,967.81 0.00 5,532.19 65.08 10-534-534010 Telephone 3,060.00 848.26 0.00 2,211.74 72.28 E20 Utilities 3,060.00 848.26 0.00 2,211.74 72.28 10-534-541030 Vehicle Wash 270.00 280.00 0.00 -10.00 -3.70 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 351.54 717.99 250.47 18.98 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,010.00 791.54 717.99 1,500.47 49.85 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 135,214.40 717.99 383,551.13 73.8332 Grand Total -519,483.52 -135,214.40 -717.99 -383,551.13 0.7383 534 Plan & Protect Svcs-Bldg Regs 519,483.52 135,214.40 717.99 383,551.13 73.83 535 Public Works-Central Maintenan 10-535-501020 Salaries 432,501.41 111,234.80 0.00 321,266.61 74.28 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 1,537.97 0.00 2,962.03 65.82 10-535-501095 Overtime Straight Pay 500.00 391.48 0.00 108.52 21.70 10-535-502010 Social Security 33,774.86 8,401.81 0.00 25,373.05 75.12 10-535-502020 Group Health Insurance 87,782.78 18,489.62 0.00 69,293.16 78.94 10-535-502030 Retirement 51,625.17 13,353.43 0.00 38,271.74 74.13 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 531.22 116.34 0.00 414.88 78.10 10-535-502060 Long Term Disability 1,321.62 281.58 0.00 1,040.04 78.69 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 158,312.19 0.00 462,847.11 74.51 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 3.78 0.00 46.22 92.44 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 140.62 0.00 859.38 85.94 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 1,035.39 0.00 4,964.61 82.74 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-517010 Operational Supplies 6,000.00 1,717.93 0.00 4,282.07 71.37 E10 Materials & Supplies 13,140.00 2,897.72 0.00 10,242.28 77.95 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 2,085.10 0.00 5,130.90 71.10 10-535-533010 Natural Gas 3,150.00 1,281.22 0.00 1,868.78 59.33 10-535-534010 Telephone 220.00 97.87 0.00 122.13 55.51 10-535-535010 Water 1,442.00 345.18 0.00 1,096.82 76.06 E20 Utilities 12,028.00 3,809.37 0.00 8,218.63 68.33 10-535-540010 Building & Grounds Maint.10,000.00 2,001.00 35.00 7,964.00 79.64 10-535-541010 Veh & Equip Parts Etc 519,218.90 167,062.11 0.00 352,156.79 67.82 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 4,446.86 0.00 5,553.14 55.53 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 5,859.00 416.40 10,975.60 63.62 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 557,569.90 179,368.97 451.40 377,749.53 67.75 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 344,578.15 451.40 860,717.65 71.3846 Grand Total -1,205,747.20 -344,578.15 -451.40 -860,717.65 0.7138 535 Public Works-Central Maintenan 1,205,747.20 344,578.15 451.40 860,717.65 71.38 540 Public Works-Admin 10-540-501020 Salaries 232,494.74 61,367.22 0.00 171,127.52 73.60 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 4,711.06 0.00 13,074.79 73.51 10-540-502020 Group Health Insurance 21,692.23 5,504.02 0.00 16,188.21 74.63 10-540-502030 Retirement 27,434.38 7,241.35 0.00 20,193.03 73.60 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 285.19 64.84 0.00 220.35 77.26 10-540-502060 Long Term Disability 534.43 156.40 0.00 378.03 70.74 10-540-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 E05 Personnel Services 300,511.57 79,264.12 0.00 221,247.45 73.62 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-511020 Postage 200.00 14.17 0.00 185.83 92.92 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.18 0.00 99.82 99.82 10-540-513010 Office Supplies 850.00 185.67 0.00 664.33 78.16 10-540-514010 Gas 127,070.00 23,280.97 0.00 103,789.03 81.68 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 128,920.00 23,480.99 0.00 105,439.01 81.79 10-540-520030 Dues And Publications 800.00 529.35 0.00 270.65 33.83 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 529.35 0.00 3,470.65 86.77 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 455.00 112.02 239.36 103.62 22.77 E25 Repairs & Maintenance 455.00 112.02 239.36 103.62 22.77 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 103,386.48 239.36 330,260.73 76.1168 Grand Total -433,886.57 -103,386.48 -239.36 -330,260.73 0.7612 540 Public Works-Admin 433,886.57 103,386.48 239.36 330,260.73 76.12 541 Public Works-Engineering 10-541-501020 Salaries 908,304.51 234,109.75 0.00 674,194.76 74.23 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 497.97 0.00 1,502.03 75.10 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 69,638.29 17,029.51 0.00 52,608.78 75.55 10-541-502020 Group Health Insurance 156,203.72 35,731.15 0.00 120,472.57 77.13 10-541-502030 Retirement 107,415.93 27,630.40 0.00 79,785.53 74.28 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 252.21 0.00 860.41 77.33 10-541-502060 Long Term Disability 2,565.79 609.18 0.00 1,956.61 76.26 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 321,992.61 0.00 931,566.05 74.31 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 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 19.57 0.00 380.43 95.11 10-541-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-541-512020 Copies 0.00 0.18 0.00 -0.18 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 545.27 0.00 1,104.73 66.95 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 157.96 0.00 842.04 84.20 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 33.46 0.00 1,966.54 98.33 E10 Materials & Supplies 7,350.00 756.44 0.00 6,593.56 89.71 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 82.48 0.00 417.52 83.50 E20 Utilities 500.00 82.48 0.00 417.52 83.50 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,635.03 0.00 864.97 34.60 10-541-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-547020 Maintenance Agreements 10,665.00 1,269.69 1,509.78 7,885.53 73.94 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 3,864.72 1,509.78 8,790.50 62.06 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 328,516.25 1,509.78 955,047.63 74.3185 Grand Total -1,285,073.66 -328,516.25 -1,509.78 -955,047.63 0.7432 541 Public Works-Engineering 1,285,073.66 328,516.25 1,509.78 955,047.63 74.32 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 542 Public Works-Street 10-542-501020 Salaries 1,431,726.66 384,282.92 0.00 1,047,443.74 73.16 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 279.87 0.00 19,720.13 98.60 10-542-501070 Stand-by Plan 5,000.00 2,558.60 0.00 2,441.40 48.83 10-542-501090 Overtime 30,000.00 7,528.93 0.00 22,471.07 74.90 10-542-501095 Overtime Straight Pay 500.00 281.48 0.00 218.52 43.70 10-542-502010 Social Security 113,772.84 29,235.66 0.00 84,537.18 74.30 10-542-502020 Group Health Insurance 310,874.53 68,371.83 0.00 242,502.70 78.01 10-542-502030 Retirement 173,132.75 41,969.27 0.00 131,163.48 75.76 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 389.12 0.00 1,366.10 77.83 10-542-502060 Long Term Disability 4,323.95 939.58 0.00 3,384.37 78.27 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 575,093.87 0.00 1,555,925.36 73.01 10-542-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-542-511020 Postage 150.00 10.32 0.00 139.68 93.12 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 606.62 0.00 793.38 56.67 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 1,257.20 0.00 8,742.80 87.43 10-542-514040 Food 2,000.00 495.66 0.00 1,504.34 75.22 10-542-515010 Stormwater Material 125,000.00 12,727.28 0.00 112,272.72 89.82 10-542-515020 Street Materials 225,000.00 104,137.22 0.00 120,862.78 53.72 10-542-515040 First Aid Supplies 500.00 27.57 0.00 472.43 94.49 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 63.01 0.00 136.99 68.50 10-542-517010 Operational Supplies 7,500.00 4,239.66 0.00 3,260.34 43.47 E10 Materials & Supplies 663,374.11 123,564.54 0.00 539,809.57 81.37 10-542-520030 Dues And Publications 1,320.00 92.00 0.00 1,228.00 93.03 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 2,620.00 0.00 5,060.00 65.89 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 16,000.00 10,200.65 0.00 5,799.35 36.25 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 12,912.65 0.00 13,287.35 50.72 10-542-531010 Electricity 24,364.00 8,283.46 0.00 16,080.54 66.00 10-542-531020 Street Lights 593,000.00 135,717.24 0.00 457,282.76 77.11 10-542-533010 Natural Gas 10,000.00 3,353.11 0.00 6,646.89 66.47 10-542-534010 Telephone 2,000.00 515.59 0.00 1,484.41 74.22 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-535010 Water 12,390.00 1,389.40 0.00 11,000.60 88.79 E20 Utilities 641,754.00 149,258.80 0.00 492,495.20 76.74 10-542-540010 Building & Grounds Maint.12,000.00 4,193.75 140.00 7,666.25 63.89 10-542-541030 Vehicle Wash 7,000.00 6,642.00 0.00 358.00 5.11 10-542-542010 Repairs - StopStreet Lights 35,000.00 16,558.30 7,954.00 10,487.70 29.96 10-542-542030 Signs & Marking Paint 60,000.00 1,283.53 0.00 58,716.47 97.86 10-542-546010 Clothing Expense 13,000.00 8,182.43 0.00 4,817.57 37.06 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 36,860.01 8,510.40 86,189.59 65.51 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 897,689.87 224,736.29 2,687,707.07 70.541 Grand Total -3,810,133.23 -897,689.87 -224,736.29 -2,687,707.07 0.7054 542 Public Works-Street 3,810,133.23 897,689.87 224,736.29 2,687,707.07 70.54 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 5,009.93 0.00 34,990.07 87.48 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,266,879.11 0.00 34,990.07 2.69 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,301,869.18 1,266,879.11 0.00 34,990.07 2.6877 Grand Total -1,301,869.18 -1,266,879.11 0.00 -34,990.07 0.0269 700 Transfers & Subsidies 1,301,869.18 1,266,879.11 0.00 34,990.07 2.69 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 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 0.00 0.00 0.00 0.00 0.00 10-990-576008 Air Streets Stormwater 147,996.00 56,382.29 82,809.46 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 35,917.60 0.00 0.00 35,917.60 100.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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 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 421,341.53 532,109.89 2,895,337.85 75.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 4,598,789.27 421,341.53 532,109.89 3,645,337.85 79.2673 Grand Total -4,598,789.27 -421,341.53 -532,109.89 -3,645,337.85 0.7927 990 Capital Projects 4,598,789.27 421,341.53 532,109.89 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 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 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 62,554,995.58 13,400,268.71 1,194,177.19 47,960,549.68 76.67 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 62,554,995.58 13,400,268.71 1,194,177.19 47,960,549.68 76.6694 Grand Total -62,554,995.58 -13,400,268.71 -1,194,177.19 -47,960,549.68 0.7667 GL - Trial Balance by Acct Type and Full Acct Number (02/15/2024 - 08:43 AM)Page 43