Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2024-03 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 3/19/2024 8:56:30 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 21,600.00 0.00 44,325.00 67.24 10-110-501015 Salary-Prosecuting Attorney 34,999.92 11,666.64 0.00 23,333.28 66.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)18,146.13 2,354.27 0.00 15,791.86 87.03 10-110-502010 Social Security 9,108.94 2,707.28 0.00 6,401.66 70.28 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 38,399.78 0.00 89,851.80 70.06 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 578.02 0.00 1,821.98 75.92 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 560.00 0.00 240.00 30.00 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 9,700.00 7,614.94 0.00 2,085.06 21.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 66.86 66.86 6.28 4.49 E25 Repairs & Maintenance 140.00 66.86 66.86 6.28 4.49 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 46,596.20 66.86 94,253.52 66.886 Grand Total -140,916.58 -46,596.20 -66.86 -94,253.52 0.6689 110 Mayor & Council 140,916.58 46,596.20 66.86 94,253.52 66.89 120 City Clerk 10-120-501020 Salaries 60,416.48 20,448.58 0.00 39,967.90 66.15 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,446.16 0.00 3,175.70 68.71 10-120-502020 Group Health Insurance 14,599.86 4,542.54 0.00 10,057.32 68.89 10-120-502030 Retirement 7,129.15 2,412.96 0.00 4,716.19 66.15 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 74.66 23.24 0.00 51.42 68.87 10-120-502060 Long Term Disability 184.87 54.76 0.00 130.11 70.38 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 87,098.71 28,988.45 0.00 58,110.26 66.72 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 183.38 0.00 116.62 38.87 10-120-513010 Office Supplies 200.00 43.30 0.00 156.70 78.35 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 264.57 0.00 435.43 62.20 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 186.62 0.00 38,813.38 99.52 E15 Contractual Services 39,675.00 236.62 0.00 39,438.38 99.40 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,541.83 216.86 7,916.31 74.16 E25 Repairs & Maintenance 10,675.00 2,541.83 216.86 7,916.31 74.16 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 32,031.47 216.86 105,900.38 76.6568 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -138,148.71 -32,031.47 -216.86 -105,900.38 0.7666 120 City Clerk 138,148.71 32,031.47 216.86 105,900.38 76.66 140 City Administrator 10-140-501020 Salaries 342,835.98 80,775.06 0.00 262,060.92 76.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 5,974.40 0.00 20,252.55 77.22 10-140-502020 Group Health Insurance 27,965.91 9,398.43 0.00 18,567.48 66.39 10-140-502030 Retirement 40,454.65 9,344.40 0.00 31,110.25 76.90 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 411.26 89.40 0.00 321.86 78.26 10-140-502060 Long Term Disability 647.19 182.86 0.00 464.33 71.75 10-140-502070 Employee Assistance Prgm 65.52 20.46 0.00 45.06 68.77 E05 Personnel Services 438,808.68 105,986.23 0.00 332,822.45 75.85 10-140-511010 Advertising 0.00 249.00 0.00 -249.00 0.00 10-140-511020 Postage 50.00 2.40 0.00 47.60 95.20 10-140-512010 Printing 100.00 129.00 0.00 -29.00 -29.00 10-140-512020 Copies 75.00 6.95 0.00 68.05 90.73 10-140-513010 Office Supplies 500.00 351.51 0.00 148.49 29.70 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 300.00 1,764.45 0.00 -1,464.45 -488.15 E10 Materials & Supplies 1,025.00 2,503.31 0.00 -1,478.31 -144.23 10-140-520030 Dues And Publications 1,000.00 199.09 0.00 800.91 80.09 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 500.00 -266.34 0.00 766.34 153.27 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 430.67 0.00 1,069.33 71.29 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 66.84 275.04 -41.88 -13.96 E25 Repairs & Maintenance 300.00 66.84 275.04 -41.88 -13.96 10-140-572020 Purchase Of Equipment 0.00 700.26 0.00 -700.26 0.00 E70 Capital Purchases 0.00 700.26 0.00 -700.26 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 441,633.68 109,687.31 275.04 331,671.33 75.101 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -441,633.68 -109,687.31 -275.04 -331,671.33 0.751 140 City Administrator 441,633.68 109,687.31 275.04 331,671.33 75.10 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 6,243.93 0.00 75,032.07 92.32 10-142-502010 Social Security 0.00 396.14 0.00 -396.14 0.00 10-142-502020 Group Health Insurance 0.00 1,964.50 0.00 -1,964.50 0.00 10-142-502030 Retirement 0.00 736.81 0.00 -736.81 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 7.10 0.00 -7.10 0.00 10-142-502060 Long Term Disability 0.00 15.58 0.00 -15.58 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 9,364.06 0.00 71,911.94 88.48 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 119,108.09 2,176,060.91 94.81 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 144,680.00 1,035,176.00 87.74 E15 Contractual Services 4,145,062.00 1,443.69 263,788.09 3,879,830.22 93.60 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 4,226,338.00 10,807.75 263,788.09 3,951,742.16 93.5027 Grand Total -4,226,338.00 -10,807.75 -263,788.09 -3,951,742.16 0.935 142 Community Revitalization 4,226,338.00 10,807.75 263,788.09 3,951,742.16 93.50 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 (03/19/2024 - 08:56 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 6,146.73 0.00 19,127.82 75.68 10-145-502010 Social Security 320.10 425.17 0.00 -105.07 -32.82 10-145-502020 Group Health Insurance 367.06 1,531.82 0.00 -1,164.76 -317.32 10-145-502030 Retirement 114.61 725.29 0.00 -610.68 -532.83 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 7.24 0.00 -7.24 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 17.33 0.00 -17.33 0.00 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 26,081.34 8,853.58 0.00 17,227.76 66.05 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,930.97 0.00 1,396,790.43 87.0968 Grand Total -1,603,721.40 -206,930.97 0.00 -1,396,790.43 0.871 145 CDBG-CV Cole Co EMS Station 1,603,721.40 206,930.97 0.00 1,396,790.43 87.10 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 33,921.37 10,743.28 0.00 23,178.09 68.33 10-146-502010 Social Security 0.00 752.67 0.00 -752.67 0.00 10-146-502020 Group Health Insurance 19.26 2,499.06 0.00 -2,479.80 -12,875.39 10-146-502030 Retirement 0.00 1,267.72 0.00 -1,267.72 0.00 10-146-502040 Workers Compensation 2.46 2.46 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 12.00 0.00 -12.00 0.00 10-146-502060 Long Term Disability 0.00 28.58 0.00 -28.58 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 33,943.09 15,305.77 0.00 18,637.32 54.91 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 15,305.77 0.00 659,529.14 97.7319 Grand Total -674,834.91 -15,305.77 0.00 -659,529.14 0.9773 146 HPF-P Bruhn Revitalization 674,834.91 15,305.77 0.00 659,529.14 97.73 147 CDBG-CV Transform Housing 10-147-501020 Salaries 18,486.80 4,225.11 0.00 14,261.69 77.15 10-147-502010 Social Security 299.07 271.92 0.00 27.15 9.08 10-147-502020 Group Health Insurance 537.69 1,301.08 0.00 -763.39 -141.98 10-147-502030 Retirement 310.64 498.56 0.00 -187.92 -60.49 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.13 5.16 0.00 -5.03 -3,869.23 10-147-502060 Long Term Disability 0.00 12.24 0.00 -12.24 0.00 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 19,637.77 6,314.07 0.00 13,323.70 67.85 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 6,314.07 0.00 557,075.95 98.8793 Grand Total -563,390.02 -6,314.07 0.00 -557,075.95 0.9888 147 CDBG-CV Transform Housing 563,390.02 6,314.07 0.00 557,075.95 98.88 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 18,828.21 0.00 52,073.28 73.44 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,415.11 0.00 -1,415.11 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 3,092.01 0.00 -3,092.01 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 2,221.71 0.00 -2,221.71 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 (03/19/2024 - 08:56 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 20.97 0.00 -20.97 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 49.24 0.00 -49.24 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 15.34 0.00 -15.34 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 25,642.59 0.00 45,258.90 63.83 10-149-511010 Advertising 830.00 339.75 0.00 490.25 59.07 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 200.00 24.37 0.00 175.63 87.82 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 55.00 0.00 -55.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 419.12 0.00 610.88 59.31 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 241.00 0.00 109,752.66 99.78 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,870.25 2,005.00 334,660.48 94.39 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 (03/19/2024 - 08:56 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 43,931.96 2,005.00 380,530.26 89.2285 Grand Total -426,467.22 -43,931.96 -2,005.00 -380,530.26 0.8923 149 Entitlement Grant 426,467.22 43,931.96 2,005.00 380,530.26 89.23 150 City Attorney 10-150-501020 Salaries 251,003.67 91,985.92 0.00 159,017.75 63.35 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 6,805.77 0.00 12,396.01 64.56 10-150-502020 Group Health Insurance 38,330.74 12,071.90 0.00 26,258.84 68.51 10-150-502030 Retirement 29,618.43 8,649.17 0.00 20,969.26 70.80 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 307.22 100.21 0.00 207.01 67.38 10-150-502060 Long Term Disability 629.25 235.74 0.00 393.51 62.54 10-150-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 339,387.40 120,110.18 0.00 219,277.22 64.61 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 143.61 0.00 356.39 71.28 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 88.74 0.00 -88.74 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 347.42 0.00 652.58 65.26 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 4,112.70 3,665.69 721.61 8.49 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 1,488.96 0.00 7,011.04 82.48 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 52.78 0.00 447.22 89.44 10-150-525031 Special Litigation Expenses 0.00 37,848.70 0.00 -37,848.70 0.00 E15 Contractual Services 26,000.00 43,503.14 3,665.69 -21,168.83 -81.42 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 66.84 366.84 6.32 1.44 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 440.00 66.84 366.84 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 164,027.58 4,032.53 198,767.29 54.1855 Grand Total -366,827.40 -164,027.58 -4,032.53 -198,767.29 0.5419 150 City Attorney 366,827.40 164,027.58 4,032.53 198,767.29 54.19 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 11,666.64 0.00 23,333.28 66.67 10-160-501020 Salaries 142,510.04 48,234.30 0.00 94,275.74 66.15 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,882.75 0.00 5,117.25 73.10 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 4,665.40 0.00 9,449.61 66.95 10-160-502020 Group Health Insurance 23,221.30 6,663.68 0.00 16,557.62 71.30 10-160-502030 Retirement 16,816.18 5,691.62 0.00 11,124.56 66.15 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 176.26 53.53 0.00 122.73 69.63 10-160-502060 Long Term Disability 436.08 125.41 0.00 310.67 71.24 10-160-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 239,538.48 79,212.18 0.00 160,326.30 66.93 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 620.34 0.00 1,379.66 68.98 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 632.14 0.00 4,267.86 87.10 10-160-520025 Security 14,000.00 4,705.38 0.00 9,294.62 66.39 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 5,710.38 0.00 17,579.62 75.48 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 (03/19/2024 - 08:56 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 3,795.00 1,316.40 1,183.60 18.80 E25 Repairs & Maintenance 6,295.00 3,795.00 1,316.40 1,183.60 18.80 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 274,023.48 89,349.70 1,316.40 183,357.38 66.913 Grand Total -274,023.48 -89,349.70 -1,316.40 -183,357.38 0.6691 160 Municipal Court 274,023.48 89,349.70 1,316.40 183,357.38 66.91 170 Human Resources 10-170-501020 Salaries 248,975.73 84,188.50 0.00 164,787.23 66.19 10-170-501050 Parttime(wo Benefits)13,000.00 6,646.00 0.00 6,354.00 48.88 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 6,896.05 0.00 13,152.74 65.60 10-170-502020 Group Health Insurance 27,922.60 8,316.40 0.00 19,606.20 70.22 10-170-502030 Retirement 29,390.94 9,934.21 0.00 19,456.73 66.20 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 304.78 94.08 0.00 210.70 69.13 10-170-502060 Long Term Disability 627.76 222.69 0.00 405.07 64.53 10-170-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 340,761.81 116,654.30 0.00 224,107.51 65.77 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 52.10 0.00 247.90 82.63 10-170-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-170-512020 Copies 500.00 96.12 0.00 403.88 80.78 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 160.80 0.00 339.20 67.84 E10 Materials & Supplies 2,350.00 309.02 0.00 2,040.98 86.85 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 501.66 0.00 2,498.34 83.28 10-170-520070 Training And Education 4,437.00 415.00 0.00 4,022.00 90.65 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 984.16 0.00 9,452.84 90.57 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 21,400.08 425.04 37,888.33 63.45 E25 Repairs & Maintenance 59,713.45 21,400.08 425.04 37,888.33 63.45 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 139,347.56 425.04 273,489.66 66.1782 Grand Total -413,262.26 -139,347.56 -425.04 -273,489.66 0.6618 170 Human Resources 413,262.26 139,347.56 425.04 273,489.66 66.18 180 Finance Department 10-180-501020 Salaries 591,685.24 191,172.13 0.00 400,513.11 67.69 10-180-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 45,263.92 14,328.78 0.00 30,935.14 68.34 10-180-502020 Group Health Insurance 110,372.73 29,517.77 0.00 80,854.96 73.26 10-180-502030 Retirement 69,818.86 22,167.52 0.00 47,651.34 68.25 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 730.73 214.71 0.00 516.02 70.62 10-180-502060 Long Term Disability 1,792.67 504.53 0.00 1,288.14 71.86 10-180-502070 Employee Assistance Prgm 234.78 87.54 0.00 147.24 62.71 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 820,397.76 258,491.81 0.00 561,905.95 68.49 10-180-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-180-511020 Postage 10,000.00 4,359.01 0.00 5,640.99 56.41 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 54.50 0.00 3,945.50 98.64 10-180-512020 Copies 100.00 6.59 0.00 93.41 93.41 10-180-512021 Copy Machine Cost 190.00 -386.61 0.00 576.61 303.48 10-180-513010 Office Supplies 1,250.00 151.48 0.00 1,098.52 87.88 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 11.99 0.00 3,643.01 99.67 E10 Materials & Supplies 22,695.00 5,549.49 0.00 17,145.51 75.55 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,043.98 0.00 56.02 5.09 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 1,047.90 0.00 4,402.10 80.77 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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,925.43 0.00 63,839.45 86.54 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 82,582.25 -80,966.95 -571.89 E25 Repairs & Maintenance 14,157.80 12,542.50 82,582.25 -80,966.95 -571.89 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 931,015.44 286,509.23 82,582.25 561,923.96 60.356 Grand Total -931,015.44 -286,509.23 -82,582.25 -561,923.96 0.6036 180 Finance Department 931,015.44 286,509.23 82,582.25 561,923.96 60.36 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 5,957.37 0.00 16,042.63 72.92 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 10,721.42 23,752.33 32,338.60 48.40 E10 Materials & Supplies 89,312.35 16,678.79 23,752.33 48,881.23 54.73 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 17,012.69 0.00 32,987.31 65.97 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 (03/19/2024 - 08:56 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 23,895.00 16,800.00 71,693.00 63.79 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 94,424.40 0.00 90,575.60 48.96 10-185-529010 Special Events 5,000.00 124.35 0.00 4,875.65 97.51 E15 Contractual Services 1,023,123.18 506,353.66 16,800.00 499,969.52 48.87 10-185-531010 Electricity 35,200.00 8,377.59 0.00 26,822.41 76.20 10-185-533010 Natural Gas 6,510.00 3,953.57 0.00 2,556.43 39.27 10-185-535010 Water 7,250.00 2,038.28 0.00 5,211.72 71.89 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 48,960.00 14,369.44 0.00 34,590.56 70.65 10-185-540010 Building & Grounds Maint.40,000.00 88,514.41 0.00 -48,514.41 -121.29 10-185-540015 Amtrak Station 4,000.00 773.58 0.00 3,226.42 80.66 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 756.00 0.00 1,304.00 63.30 E25 Repairs & Maintenance 71,060.00 90,043.99 0.00 -18,983.99 -26.72 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 10,000.00 0.00 0.00 0.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 274,915.50 0.00 -111,446.42 -68.18 E30 Other Operating Expenses 176,269.08 285,423.50 0.00 -109,154.42 -61.92 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 (03/19/2024 - 08:56 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 -57,408.62 0.00 57,408.62 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 -57,408.62 0.00 57,408.62 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 861,955.91 40,552.33 543,183.80 37.5726 Grand Total -1,445,692.04 -861,955.91 -40,552.33 -543,183.80 0.3757 185 Non-Departmental 1,445,692.04 861,955.91 40,552.33 543,183.80 37.57 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 205,919.67 0.00 446,696.01 68.45 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 15,352.64 0.00 34,572.46 69.25 10-190-502020 Group Health Insurance 99,908.29 26,933.98 0.00 72,974.31 73.04 10-190-502030 Retirement 77,008.65 22,971.74 0.00 54,036.91 70.17 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 798.05 231.16 0.00 566.89 71.03 10-190-502060 Long Term Disability 1,924.15 544.16 0.00 1,379.99 71.72 10-190-502070 Employee Assistance Prgm 223.86 97.18 0.00 126.68 56.59 E05 Personnel Services 883,761.99 273,408.74 0.00 610,353.25 69.06 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.26 0.00 9.74 97.40 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 (03/19/2024 - 08:56 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 385.65 0.00 3,614.35 90.36 E10 Materials & Supplies 4,560.00 501.55 0.00 4,058.45 89.00 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 1,363.39 0.00 6,136.61 81.82 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 9,826.24 0.00 13,173.76 57.28 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 12,639.37 1,312.88 30,097.75 68.33 10-190-534010 Telephone 90,000.00 29,717.68 0.00 60,282.32 66.98 E20 Utilities 90,000.00 29,717.68 0.00 60,282.32 66.98 10-190-545010 Software License\maint 233,000.00 168,045.74 0.00 64,954.26 27.88 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 168,045.74 416.40 87,017.86 34.06 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 484,313.08 1,729.28 791,809.63 61.9641 Grand Total -1,277,851.99 -484,313.08 -1,729.28 -791,809.63 0.6196 190 Information Technology Svcs 1,277,851.99 484,313.08 1,729.28 791,809.63 61.96 300 Police Department 10-300-501020 Salaries 5,557,743.46 1,860,856.86 0.00 3,696,886.60 66.52 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 10,234.19 0.00 37,069.99 78.37 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 3,766.31 0.00 1,233.69 24.67 10-300-501090 Overtime 264,262.11 108,728.63 0.00 155,533.48 58.86 10-300-501095 Overtime Straight Pay 13,275.00 6,157.76 0.00 7,117.24 53.61 10-300-502010 Social Security 465,407.81 151,289.55 0.00 314,118.26 67.49 10-300-502020 Group Health Insurance 1,060,092.76 311,556.86 0.00 748,535.90 70.61 10-300-502030 Retirement 996,597.99 317,130.55 0.00 679,467.44 68.18 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 2,085.34 0.00 4,815.64 69.78 10-300-502060 Long Term Disability 16,618.95 4,920.24 0.00 11,698.71 70.39 10-300-502070 Employee Assistance Prgm 2,031.12 925.80 0.00 1,105.32 54.42 10-300-503010 Awards Program 2,500.00 32.70 0.00 2,467.30 98.69 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,737,374.02 2,928,247.33 0.00 5,809,126.69 66.49 10-300-511010 Advertising 5,665.00 62.25 0.00 5,602.75 98.90 10-300-511020 Postage 1,395.00 660.71 0.00 734.29 52.64 10-300-512010 Printing 5,952.00 851.16 0.00 5,100.84 85.70 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,860.00 163.50 0.00 1,696.50 91.21 10-300-513010 Office Supplies 15,670.50 5,039.71 0.00 10,630.79 67.84 10-300-514010 Gas 195,940.00 61,119.23 0.00 134,820.77 68.81 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 1,243.75 959.92 0.00 283.83 22.82 10-300-515040 First Aid Supplies 1,378.00 1,262.19 0.00 115.81 8.40 10-300-516010 Ammunition & Firearms Supplies 65,000.00 43,292.83 23,960.40 -2,253.23 -3.47 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 886.05 0.00 1,438.95 61.89 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 34,134.21 4,211.87 10,245.82 21.09 E10 Materials & Supplies 356,121.15 156,681.76 28,172.27 171,267.12 48.09 10-300-520030 Dues And Publications 5,400.00 5,994.40 0.00 -594.40 -11.01 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 47,000.00 23,172.00 0.00 23,828.00 50.70 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,627.00 0.00 24,373.00 48.75 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,000.00 19,537.67 0.00 -3,537.67 -22.11 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-525025 Police Internship Program 35,290.00 0.00 0.00 35,290.00 100.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 126.66 0.00 1,919.34 93.81 E15 Contractual Services 173,871.00 78,249.73 0.00 95,621.27 55.00 10-300-531010 Electricity 44,640.00 17,163.60 0.00 27,476.40 61.55 10-300-533010 Natural Gas 1,116.00 447.28 0.00 668.72 59.92 10-300-534010 Telephone 24,101.00 10,179.72 0.00 13,921.28 57.76 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-535010 Water 3,348.00 1,220.44 0.00 2,127.56 63.55 E20 Utilities 73,205.00 29,011.04 0.00 44,193.96 60.37 10-300-540010 Building & Grounds Maint.60,000.00 7,376.79 0.00 52,623.21 87.71 10-300-541030 Vehicle Wash 9,752.00 7,263.96 0.00 2,488.04 25.51 10-300-544010 K-9 Operations 16,740.00 1,776.83 0.00 14,963.17 89.39 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 11,725.50 40,671.30 7,740.89 12.87 10-300-546020 Uniform Cleaning 23,715.00 9,451.47 0.00 14,263.53 60.15 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 13,638.46 7,945.80 57,717.62 72.78 10-300-547030 Radio Maintenance 8,025.00 641.27 0.00 7,383.73 92.01 E25 Repairs & Maintenance 367,829.07 127,395.82 50,117.10 190,316.15 51.74 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 331,355.34 42,584.50 219,391.89 69,378.95 20.94 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 693,083.52 254,344.50 234,806.89 203,932.13 29.42 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,401,483.76 3,573,930.18 313,096.26 6,514,457.32 62.6301 Grand Total -10,401,483.76 -3,573,930.18 -313,096.26 -6,514,457.32 0.6263 300 Police Department 10,401,483.76 3,573,930.18 313,096.26 6,514,457.32 62.63 310 School Resource Officer 10-310-501020 Salaries 501,710.46 136,634.68 0.00 365,075.78 72.77 10-310-501030 Holiday Pay 21,214.01 0.00 0.00 21,214.01 100.00 10-310-501090 Overtime 45,106.00 25,303.34 0.00 19,802.66 43.90 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 11,716.30 0.00 31,838.33 73.10 10-310-502020 Group Health Insurance 104,608.25 26,858.14 0.00 77,750.11 74.33 10-310-502030 Retirement 96,788.06 27,681.78 0.00 69,106.28 71.40 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 615.82 157.59 0.00 458.23 74.41 10-310-502060 Long Term Disability 1,528.69 373.17 0.00 1,155.52 75.59 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 823,164.50 236,255.59 0.00 586,908.91 71.30 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 420.00 0.00 14,925.00 97.26 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 420.00 0.00 21,920.00 98.12 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 237,487.39 3,980.65 615,076.86 71.8091 Grand Total -856,544.90 -237,487.39 -3,980.65 -615,076.86 0.7181 310 School Resource Officer 856,544.90 237,487.39 3,980.65 615,076.86 71.81 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 130,750.33 44,017.92 0.00 86,732.41 66.33 10-320-501030 Holiday Pay 5,452.54 0.00 0.00 5,452.54 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-501090 Overtime 30,089.28 12,490.98 0.00 17,598.30 58.49 10-320-501095 Overtime Straight Pay 0.00 736.06 0.00 -736.06 0.00 10-320-502010 Social Security 11,287.82 4,138.82 0.00 7,149.00 63.33 10-320-502020 Group Health Insurance 22,743.74 7,048.10 0.00 15,695.64 69.01 10-320-502030 Retirement 25,084.04 9,731.64 0.00 15,352.40 61.20 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 157.90 50.03 0.00 107.87 68.32 10-320-502060 Long Term Disability 394.37 118.34 0.00 276.03 69.99 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 228,008.09 80,356.74 0.00 147,651.35 64.76 10-320-514010 Gas 11,327.53 2,692.99 0.00 8,634.54 76.23 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 2,645.00 0.00 12,461.00 82.49 10-320-517010 Operational Supplies 1,200.00 570.90 0.00 629.10 52.43 E10 Materials & Supplies 27,633.53 5,908.89 0.00 21,724.64 78.62 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 4,800.00 0.00 13,700.00 74.05 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,500.00 4,800.00 0.00 13,700.00 74.05 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 91,065.63 0.00 183,075.99 66.7815 Grand Total -274,141.62 -91,065.63 0.00 -183,075.99 0.6678 320 M.U.S.T.A.N.G.274,141.62 91,065.63 0.00 183,075.99 66.78 330 Animal Control 10-330-501020 Salaries 394,208.69 130,339.67 0.00 263,869.02 66.94 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,930.87 0.00 5,669.13 65.92 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 9,332.60 0.00 21,635.26 69.86 10-330-502020 Group Health Insurance 101,449.34 27,830.44 0.00 73,618.90 72.57 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502030 Retirement 47,767.43 13,130.35 0.00 34,637.08 72.51 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 487.15 148.16 0.00 338.99 69.59 10-330-502060 Long Term Disability 1,175.12 346.50 0.00 828.62 70.51 10-330-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 591,511.39 189,277.58 0.00 402,233.81 68.00 10-330-511010 Advertising 905.00 62.25 0.00 842.75 93.12 10-330-511020 Postage 152.00 5.65 0.00 146.35 96.28 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 95.23 0.00 1,485.77 93.98 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 2,301.52 0.00 8,698.48 79.08 E10 Materials & Supplies 16,016.00 2,750.60 0.00 13,265.40 82.83 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 484.50 0.00 4,345.50 89.97 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,936.96 0.00 10,302.04 72.35 10-330-531010 Electricity 25,067.90 5,566.97 0.00 19,500.93 77.79 10-330-533010 Natural Gas 22,050.00 5,501.65 0.00 16,548.35 75.05 10-330-534010 Telephone 810.00 276.07 0.00 533.93 65.92 10-330-535010 Water 3,800.00 1,498.04 0.00 2,301.96 60.58 E20 Utilities 51,727.90 12,842.73 0.00 38,885.17 75.17 10-330-540010 Building & Grounds Maint.15,000.00 4,104.92 0.00 10,895.08 72.63 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 21,675.64 0.00 27,614.36 56.02 10-330-544050 Animal Food 6,603.00 1,335.67 0.00 5,267.33 79.77 10-330-545010 Software Licensemaint 8,087.00 2,645.06 0.00 5,441.94 67.29 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547020 Maintenance Agreements 1,406.40 0.00 416.40 990.00 70.39 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 2,230.00 0.00 0.00 2,230.00 100.00 E25 Repairs & Maintenance 85,796.40 31,403.91 416.40 53,976.09 62.91 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 240,211.78 416.40 518,662.51 68.3088 Grand Total -759,290.69 -240,211.78 -416.40 -518,662.51 0.6831 330 Animal Control 759,290.69 240,211.78 416.40 518,662.51 68.31 390 9-1-1 Police 10-390-501020 Salaries 1,053,365.22 309,015.42 0.00 744,349.80 70.66 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 23,665.48 0.00 -851.48 -3.73 10-390-501095 Overtime Straight Pay 500.00 897.00 0.00 -397.00 -79.40 10-390-502010 Social Security 85,477.13 25,843.81 0.00 59,633.32 69.77 10-390-502020 Group Health Insurance 232,987.77 57,167.28 0.00 175,820.49 75.46 10-390-502030 Retirement 136,605.11 40,808.30 0.00 95,796.81 70.13 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 344.49 0.00 957.85 73.55 10-390-502060 Long Term Disability 3,220.09 808.64 0.00 2,411.45 74.89 10-390-502070 Employee Assistance Prgm 458.64 217.38 0.00 241.26 52.60 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,580,119.14 480,390.94 0.00 1,099,728.20 69.60 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 9,670.19 0.00 -3,445.19 -55.34 E10 Materials & Supplies 7,625.00 9,670.19 0.00 -2,045.19 -26.82 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 1,843.84 0.00 3,806.16 67.37 10-390-522020 Professional Services 4,300.00 2,928.41 0.00 1,371.59 31.90 10-390-523010 Equipment Rentlease 99,260.00 32,980.94 0.00 66,279.06 66.77 E15 Contractual Services 109,768.00 37,753.19 0.00 72,014.81 65.61 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-531010 Electricity 12,276.00 0.00 0.00 12,276.00 100.00 10-390-533010 Natural Gas 292.95 0.00 0.00 292.95 100.00 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,679.88 6,270.00 42,606.52 53.56 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,354.89 8,136.04 49,886.47 33.17 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 620,169.21 8,136.04 1,232,990.24 66.2437 Grand Total -1,861,295.49 -620,169.21 -8,136.04 -1,232,990.24 0.6624 390 9-1-1 Police 1,861,295.49 620,169.21 8,136.04 1,232,990.24 66.24 400 Fire Department 10-400-501020 Salaries 4,690,038.81 1,453,908.48 0.00 3,236,130.33 69.00 10-400-501025 Other Hours 0.00 4,459.02 0.00 -4,459.02 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 15,171.71 0.00 67,223.97 81.59 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 13,960.07 0.00 41,773.26 74.95 10-400-501090 Overtime-FLSA 195,037.45 189,740.44 0.00 5,297.01 2.72 10-400-501092 Overtime-Constant Staffing 187,813.69 29,472.85 0.00 158,340.84 84.31 10-400-501095 Overtime Straight Pay 0.00 76.39 0.00 -76.39 0.00 10-400-502010 Social Security 83,367.55 27,347.94 0.00 56,019.61 67.20 10-400-502020 Group Health Insurance 946,285.13 297,028.80 0.00 649,256.33 68.61 10-400-502030 Retirement 2,805,502.77 953,400.08 0.00 1,852,102.69 66.02 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,722.44 0.00 3,996.09 69.88 10-400-502060 Long Term Disability 13,863.74 4,051.56 0.00 9,812.18 70.78 10-400-502070 Employee Assistance Prgm 1,659.84 777.46 0.00 882.38 53.16 10-400-503010 Awards Program 1,500.00 0.00 0.00 1,500.00 100.00 E05 Personnel Services 9,610,250.88 3,345,878.73 0.00 6,264,372.15 65.18 10-400-511010 Advertising 300.00 57.00 0.00 243.00 81.00 10-400-511020 Postage 120.00 189.79 0.00 -69.79 -58.16 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 287.18 0.00 1,107.82 79.41 10-400-514010 Gas 91,180.00 23,137.80 0.00 68,042.20 74.62 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 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 332.16 0.00 1,767.84 84.18 10-400-517010 Operational Supplies 18,000.00 6,403.62 0.00 11,596.38 64.42 E10 Materials & Supplies 120,645.00 35,400.39 0.00 85,244.61 70.66 10-400-520030 Dues And Publications 3,400.00 1,935.54 0.00 1,464.46 43.07 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,617.83 0.00 23,382.17 68.77 10-400-520080 Tuition Reimbursement 7,500.00 7,020.00 0.00 480.00 6.40 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 1,440.00 0.00 1,060.00 42.40 E15 Contractual Services 102,653.70 29,181.62 0.00 73,472.08 71.57 10-400-531010 Electricity 38,500.00 10,734.92 0.00 27,765.08 72.12 10-400-533010 Natural Gas 20,000.00 10,503.42 0.00 9,496.58 47.48 10-400-534010 Telephone 25,984.20 11,592.11 0.00 14,392.09 55.39 10-400-535010 Water 12,000.00 4,604.80 0.00 7,395.20 61.63 E20 Utilities 96,484.20 37,435.25 0.00 59,048.95 61.20 10-400-540010 Building & Grounds Maint.113,040.00 55,238.72 650.00 57,151.28 50.56 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 98,000.00 41,176.03 0.00 56,823.97 57.98 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,000.00 8,661.72 0.00 11,338.28 56.69 10-400-547020 Maintenance Agreements 39,487.20 9,754.17 1,213.29 28,519.74 72.23 10-400-547030 Radio Maintenance 20,925.00 5,875.12 0.00 15,049.88 71.92 E25 Repairs & Maintenance 291,952.20 120,705.76 1,863.29 169,383.15 58.02 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 88,227.27 2,046.92 1.89 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 88,227.27 2,046.92 0.31 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,873,276.75 4,129,618.33 90,090.56 6,653,567.86 61.1919 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -10,873,276.75 -4,129,618.33 -90,090.56 -6,653,567.86 0.6119 400 Fire Department 10,873,276.75 4,129,618.33 90,090.56 6,653,567.86 61.19 401 Fire Museum 10-401-531010 Electricity 1,900.00 402.12 0.00 1,497.88 78.84 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 414.86 0.00 1,785.14 81.14 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 414.86 0.00 1,785.14 81.1427 Grand Total -2,200.00 -414.86 0.00 -1,785.14 0.8114 401 Fire Museum 2,200.00 414.86 0.00 1,785.14 81.14 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 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 78,182.39 0.00 168,863.57 68.35 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 5,774.16 0.00 13,124.86 69.45 10-520-502020 Group Health Insurance 57,799.07 15,233.71 0.00 42,565.36 73.64 10-520-502030 Retirement 29,151.42 7,117.14 0.00 22,034.28 75.59 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 303.55 91.19 0.00 212.36 69.96 10-520-502060 Long Term Disability 660.64 215.56 0.00 445.08 67.37 10-520-502070 Employee Assistance Prgm 87.36 30.68 0.00 56.68 64.88 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 354,143.92 106,841.73 0.00 247,302.19 69.83 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 774.21 0.00 75.79 8.92 10-520-514010 Gas 16,490.00 5,125.86 0.00 11,364.14 68.92 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 546.24 0.00 -46.24 -9.25 E10 Materials & Supplies 18,015.00 6,462.06 0.00 11,552.94 64.13 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 40.00 0.00 1,760.00 97.78 10-520-522020 Professional Services 3,000.00 22.13 0.00 2,977.87 99.26 E15 Contractual Services 6,000.00 750.13 0.00 5,249.87 87.50 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 34,902.55 33,787.30 1,081.02 34.23 0.10 E25 Repairs & Maintenance 34,902.55 33,787.30 1,081.02 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 147,841.22 1,081.02 264,139.23 63.9467 Grand Total -413,061.47 -147,841.22 -1,081.02 -264,139.23 0.6395 520 Plan & Protect Svcs-Admin 413,061.47 147,841.22 1,081.02 264,139.23 63.95 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 93,573.53 37,057.87 0.00 56,515.66 60.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,770.85 0.00 4,387.53 61.29 10-521-502020 Group Health Insurance 16,621.90 6,069.71 0.00 10,552.19 63.48 10-521-502030 Retirement 11,041.68 4,372.63 0.00 6,669.05 60.40 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 115.06 41.52 0.00 73.54 63.91 10-521-502060 Long Term Disability 285.42 97.49 0.00 187.93 65.84 10-521-502070 Employee Assistance Prgm 32.76 27.62 0.00 5.14 15.69 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 128,987.08 50,596.04 0.00 78,391.04 60.77 10-521-511010 Advertising 3,336.00 690.00 0.00 2,646.00 79.32 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 75.78 0.00 724.22 90.53 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 785.94 0.00 5,550.06 87.60 10-521-520030 Dues And Publications 14,209.68 548.00 0.00 13,661.68 96.14 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 15,709.68 548.00 0.00 15,161.68 96.51 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 688.20 647.45 -0.65 -0.05 E25 Repairs & Maintenance 1,335.00 688.20 647.45 -0.65 -0.05 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 52,618.18 647.45 99,102.13 65.0414 Grand Total -152,367.76 -52,618.18 -647.45 -99,102.13 0.6504 521 Plan & Protect Svcs-Planning 152,367.76 52,618.18 647.45 99,102.13 65.04 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 109,870.24 31,306.22 0.00 78,564.02 71.51 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 2,370.25 0.00 6,034.82 71.80 10-522-502020 Group Health Insurance 16,621.90 4,258.47 0.00 12,363.43 74.38 10-522-502030 Retirement 12,964.69 3,694.26 0.00 9,270.43 71.51 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 135.86 36.24 0.00 99.62 73.33 10-522-502060 Long Term Disability 335.28 84.77 0.00 250.51 74.72 10-522-502070 Employee Assistance Prgm 32.76 23.52 0.00 9.24 28.21 E05 Personnel Services 148,468.35 41,876.28 0.00 106,592.07 71.79 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 242.89 0.00 757.11 75.71 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 389.95 0.00 610.05 61.01 E10 Materials & Supplies 5,600.00 819.49 0.00 4,780.51 85.37 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 230,000.00 6,749.60 0.00 223,250.40 97.07 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 239,000.00 7,034.60 0.00 231,965.40 97.06 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 578.65 582.83 1,238.52 51.61 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 578.65 582.83 1,238.52 51.61 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 398,868.35 50,309.02 582.83 347,976.50 87.2409 Grand Total -398,868.35 -50,309.02 -582.83 -347,976.50 0.8724 522 Plan & Protect Svcs-MPO 398,868.35 50,309.02 582.83 347,976.50 87.24 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,845.53 5,744.82 0.00 52,100.71 90.07 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 409.11 0.00 -409.11 0.00 10-530-502020 Group Health Insurance 0.00 1,162.73 0.00 -1,162.73 0.00 10-530-502030 Retirement 0.00 677.90 0.00 -677.90 0.00 10-530-502040 Workers Compensation 145.11 145.11 0.00 0.00 0.00 10-530-502050 Life Insurance 0.00 5.63 0.00 -5.63 0.00 10-530-502060 Long Term Disability 0.00 13.18 0.00 -13.18 0.00 10-530-502070 Employee Assistance Prgm 0.00 10.22 0.00 -10.22 0.00 E05 Personnel Services 57,990.64 8,168.70 0.00 49,821.94 85.91 10-530-511010 Advertising 347.50 0.00 0.00 347.50 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.07 0.00 -0.07 0.00 10-530-513010 Office Supplies 100.00 218.56 0.00 -118.56 -118.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,017.50 306.05 0.00 711.45 69.92 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 188.39 0.00 4,311.61 95.81 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,382.38 0.00 9,617.62 41.82 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 35,761.33 0.00 0.00 35,761.33 100.00 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,070.77 0.00 79,624.21 79.07 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 366.90 333.06 1,041.06 59.80 E25 Repairs & Maintenance 1,741.02 366.90 333.06 1,041.06 59.80 10-530-550020 NRA-Residential 40,000.00 20,983.91 0.00 19,016.09 47.54 10-530-550030 NRA-Commercial Facade 17,562.80 0.00 0.00 17,562.80 100.00 10-530-550031 Historic Preservation Grant 27,818.24 0.00 22,975.24 4,843.00 17.41 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,795.00 27,795.00 0.00 0.00 0.00 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 128,376.04 48,832.91 22,975.24 56,567.89 44.06 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 289,820.18 78,745.33 23,308.30 187,766.55 64.7873 Grand Total -289,820.18 -78,745.33 -23,308.30 -187,766.55 0.6479 530 Plan & Protect Svc-RedevGrant 289,820.18 78,745.33 23,308.30 187,766.55 64.79 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 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 73,760.80 0.00 143,471.59 66.05 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 5,536.93 0.00 11,081.35 66.68 10-532-502020 Group Health Insurance 44,266.53 14,313.13 0.00 29,953.40 67.67 10-532-502030 Retirement 25,633.42 9,076.08 0.00 16,557.34 64.59 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 266.83 73.95 0.00 192.88 72.29 10-532-502060 Long Term Disability 661.06 198.35 0.00 462.71 70.00 10-532-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 308,497.45 106,743.34 0.00 201,754.11 65.40 10-532-511010 Advertising 90.00 147.25 0.00 -57.25 -63.61 10-532-511020 Postage 150.00 69.86 0.00 80.14 53.43 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 162.81 0.00 1,137.19 87.48 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 55.65 0.00 944.35 94.44 E10 Materials & Supplies 2,625.00 435.57 0.00 2,189.43 83.41 10-532-520030 Dues And Publications 900.00 653.00 0.00 247.00 27.44 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 465.00 0.00 535.00 53.50 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 27,258.70 0.00 169,641.30 86.16 10-532-534010 Telephone 1,500.00 494.88 0.00 1,005.12 67.01 E20 Utilities 1,500.00 494.88 0.00 1,005.12 67.01 10-532-540060 Cemetery Maintenance 39,000.00 9,506.41 25,336.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 320.00 0.00 760.00 70.37 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 244.44 1,029.60 -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 11,354.85 26,365.60 4,599.55 10.87 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 551,842.45 146,287.34 26,365.60 379,189.51 68.7134 Grand Total -551,842.45 -146,287.34 -26,365.60 -379,189.51 0.6871 532 Plan & Protect Svcs-Env Health 551,842.45 146,287.34 26,365.60 379,189.51 68.71 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 167,225.57 54,566.20 0.00 112,659.37 67.37 10-533-501050 Parttime(wo Benefits)20,000.00 17,332.20 0.00 2,667.80 13.34 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 5,394.31 0.00 8,928.45 62.34 10-533-502020 Group Health Insurance 27,353.91 8,955.37 0.00 18,398.54 67.26 10-533-502030 Retirement 19,732.62 6,181.51 0.00 13,551.11 68.67 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 206.86 57.56 0.00 149.30 72.17 10-533-502060 Long Term Disability 511.71 130.53 0.00 381.18 74.49 10-533-502070 Employee Assistance Prgm 65.52 35.80 0.00 29.72 45.36 E05 Personnel Services 251,676.33 94,910.86 0.00 156,765.47 62.29 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.00 396.08 0.00 1,403.92 78.00 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 164.32 0.00 835.68 83.57 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 686.52 0.00 663.48 49.15 E10 Materials & Supplies 4,690.00 1,246.92 0.00 3,443.08 73.41 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,985.00 0.00 5,015.00 50.15 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,601.83 5,519.87 57,865.85 54.60 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-534010 Telephone 3,701.40 1,774.87 0.00 1,926.53 52.05 E20 Utilities 3,701.40 1,774.87 0.00 1,926.53 52.05 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 441.98 931.44 -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 824.20 931.44 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 141,358.68 6,451.31 221,096.29 59.9329 Grand Total -368,906.28 -141,358.68 -6,451.31 -221,096.29 0.5993 533 PPS - Prop MaintCode Enforce 368,906.28 141,358.68 6,451.31 221,096.29 59.93 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 325,779.08 109,848.75 0.00 215,930.33 66.28 10-534-501050 Parttime(wo Benefits)15,900.00 4,825.06 0.00 11,074.94 69.65 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 8,050.26 0.00 18,088.19 69.20 10-534-502020 Group Health Insurance 88,283.39 26,682.95 0.00 61,600.44 69.78 10-534-502030 Retirement 38,441.93 12,692.51 0.00 25,749.42 66.98 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 399.02 115.86 0.00 283.16 70.96 10-534-502060 Long Term Disability 991.38 284.69 0.00 706.69 71.28 10-534-502070 Employee Assistance Prgm 109.20 61.38 0.00 47.82 43.79 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 500,798.52 167,317.53 0.00 333,480.99 66.59 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 101.24 0.00 998.76 90.80 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 179.77 0.00 720.23 80.03 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 281.01 0.00 3,833.99 93.17 10-534-520030 Dues And Publications 2,500.00 534.00 0.00 1,966.00 78.64 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 4,875.36 0.00 1,124.64 18.74 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 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 5,409.36 0.00 3,090.64 36.36 10-534-534010 Telephone 3,060.00 1,131.04 0.00 1,928.96 63.04 E20 Utilities 3,060.00 1,131.04 0.00 1,928.96 63.04 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 490.96 578.57 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 930.96 578.57 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 175,069.90 578.57 343,835.05 66.1879 Grand Total -519,483.52 -175,069.90 -578.57 -343,835.05 0.6619 534 Plan & Protect Svcs-Bldg Regs 519,483.52 175,069.90 578.57 343,835.05 66.19 535 Public Works-Central Maintenan 10-535-501020 Salaries 432,501.41 143,956.81 0.00 288,544.60 66.72 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,628.51 0.00 2,871.49 63.81 10-535-501095 Overtime Straight Pay 500.00 391.48 0.00 108.52 21.70 10-535-502010 Social Security 33,774.86 10,838.15 0.00 22,936.71 67.91 10-535-502020 Group Health Insurance 87,782.78 25,115.03 0.00 62,667.75 71.39 10-535-502030 Retirement 51,625.17 17,225.32 0.00 34,399.85 66.63 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 531.22 158.94 0.00 372.28 70.08 10-535-502060 Long Term Disability 1,321.62 374.30 0.00 947.32 71.68 10-535-502070 Employee Assistance Prgm 152.88 71.60 0.00 81.28 53.17 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 621,159.30 204,229.50 0.00 416,929.80 67.12 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 225.15 0.00 774.85 77.49 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-514030 Small Tools 6,000.00 1,120.37 0.00 4,879.63 81.33 10-535-517010 Operational Supplies 6,000.00 1,930.69 0.00 4,069.31 67.82 E10 Materials & Supplies 13,140.00 3,279.99 0.00 9,860.01 75.04 10-535-520030 Dues And Publications 350.00 198.80 0.00 151.20 43.20 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 388.70 0.00 1,461.30 78.99 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 146.81 0.00 73.19 33.27 10-535-535010 Water 1,442.00 471.01 0.00 970.99 67.34 E20 Utilities 12,028.00 3,984.14 0.00 8,043.86 66.88 10-535-540010 Building & Grounds Maint.10,000.00 2,026.46 17.50 7,956.04 79.56 10-535-541010 Veh & Equip Parts Etc 519,218.90 224,764.42 0.00 294,454.48 56.71 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 5,924.21 0.00 4,075.79 40.76 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 8,664.83 416.40 8,169.77 47.36 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 557,569.90 241,379.92 433.90 315,756.08 56.63 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 453,262.25 433.90 752,051.05 62.3722 Grand Total -1,205,747.20 -453,262.25 -433.90 -752,051.05 0.6237 535 Public Works-Central Maintenan 1,205,747.20 453,262.25 433.90 752,051.05 62.37 540 Public Works-Admin 10-540-501020 Salaries 232,494.74 79,425.23 0.00 153,069.51 65.84 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 6,093.38 0.00 11,692.47 65.74 10-540-502020 Group Health Insurance 21,692.23 7,411.04 0.00 14,281.19 65.84 10-540-502030 Retirement 27,434.38 9,372.20 0.00 18,062.18 65.84 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 285.19 88.34 0.00 196.85 69.02 10-540-502060 Long Term Disability 534.43 207.44 0.00 326.99 61.18 10-540-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 E05 Personnel Services 300,511.57 102,832.20 0.00 197,679.37 65.78 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 23.15 0.00 176.85 88.43 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 198.64 0.00 651.36 76.63 10-540-514010 Gas 127,070.00 31,087.69 0.00 95,982.31 75.53 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 31,309.66 0.00 97,610.34 75.71 10-540-520030 Dues And Publications 800.00 728.15 0.00 71.85 8.98 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 728.15 0.00 3,271.85 81.80 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 158.50 192.88 103.62 22.77 E25 Repairs & Maintenance 455.00 158.50 192.88 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 135,028.51 192.88 298,665.18 68.8349 Grand Total -433,886.57 -135,028.51 -192.88 -298,665.18 0.6883 540 Public Works-Admin 433,886.57 135,028.51 192.88 298,665.18 68.83 541 Public Works-Engineering 10-541-501020 Salaries 908,304.51 304,115.15 0.00 604,189.36 66.52 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 22,032.61 0.00 47,605.68 68.36 10-541-502020 Group Health Insurance 156,203.72 49,102.97 0.00 107,100.75 68.56 10-541-502030 Retirement 107,415.93 35,891.03 0.00 71,524.90 66.59 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 343.11 0.00 769.51 69.16 10-541-502060 Long Term Disability 2,565.79 806.28 0.00 1,759.51 68.58 10-541-502070 Employee Assistance Prgm 262.08 138.10 0.00 123.98 47.31 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 1,253,558.66 418,982.94 0.00 834,575.72 66.58 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 676.26 0.00 973.74 59.01 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 37.84 0.00 112.16 74.77 10-541-515040 First Aid Supplies 50.00 20.41 0.00 29.59 59.18 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 187.46 0.00 1,812.54 90.63 E10 Materials & Supplies 7,350.00 1,099.68 0.00 6,250.32 85.04 10-541-520030 Dues And Publications 3,500.00 2,694.00 0.00 806.00 23.03 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 620.00 0.00 4,380.00 87.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 3,314.00 0.00 6,186.00 65.12 10-541-534010 Telephone 500.00 123.72 0.00 376.28 75.26 E20 Utilities 500.00 123.72 0.00 376.28 75.26 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,486.76 1,359.59 7,818.65 73.31 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 4,081.79 1,359.59 8,723.62 61.59 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 427,602.13 1,359.59 856,111.94 66.6197 Grand Total -1,285,073.66 -427,602.13 -1,359.59 -856,111.94 0.6662 541 Public Works-Engineering 1,285,073.66 427,602.13 1,359.59 856,111.94 66.62 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 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 493,910.47 0.00 937,816.19 65.50 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 311.33 0.00 19,688.67 98.44 10-542-501070 Stand-by Plan 5,000.00 3,266.88 0.00 1,733.12 34.66 10-542-501090 Overtime 30,000.00 8,695.26 0.00 21,304.74 71.02 10-542-501095 Overtime Straight Pay 500.00 343.71 0.00 156.29 31.26 10-542-502010 Social Security 113,772.84 37,436.86 0.00 76,335.98 67.10 10-542-502020 Group Health Insurance 310,874.53 93,231.69 0.00 217,642.84 70.01 10-542-502030 Retirement 173,132.75 54,121.00 0.00 119,011.75 68.74 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 530.02 0.00 1,225.20 69.80 10-542-502060 Long Term Disability 4,323.95 1,246.59 0.00 3,077.36 71.17 10-542-502070 Employee Assistance Prgm 622.44 291.54 0.00 330.90 53.16 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 732,496.19 0.00 1,398,523.04 65.63 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 68,410.70 0.00 220,363.41 76.31 10-542-514030 Small Tools 10,000.00 2,128.17 0.00 7,871.83 78.72 10-542-514040 Food 2,000.00 495.66 0.00 1,504.34 75.22 10-542-515010 Stormwater Material 125,000.00 30,336.25 0.00 94,663.75 75.73 10-542-515020 Street Materials 225,000.00 154,729.95 0.00 70,270.05 31.23 10-542-515040 First Aid Supplies 500.00 397.49 0.00 102.51 20.50 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,307.61 0.00 3,192.39 42.57 E10 Materials & Supplies 663,374.11 261,485.78 0.00 401,888.33 60.58 10-542-520030 Dues And Publications 1,320.00 1,242.60 0.00 77.40 5.86 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,270.85 0.00 5,729.15 35.81 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 14,133.45 0.00 12,066.55 46.06 10-542-531010 Electricity 24,364.00 9,404.32 0.00 14,959.68 61.40 10-542-531020 Street Lights 593,000.00 236,707.37 0.00 356,292.63 60.08 10-542-533010 Natural Gas 10,000.00 4,950.69 0.00 5,049.31 50.49 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-534010 Telephone 2,000.00 773.40 0.00 1,226.60 61.33 10-542-535010 Water 12,390.00 1,992.86 0.00 10,397.14 83.92 E20 Utilities 641,754.00 253,828.64 0.00 387,925.36 60.45 10-542-540010 Building & Grounds Maint.12,000.00 9,985.54 70.00 1,944.46 16.20 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,828.21 7,954.00 10,217.79 29.19 10-542-542030 Signs & Marking Paint 60,000.00 3,631.21 10,360.35 46,008.44 76.68 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 45,269.39 18,800.75 67,489.86 51.30 10-542-572010 Purchase Of Vehicles 216,225.89 29.00 216,225.89 -29.00 -0.01 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 29.00 216,225.89 -29.00 -0.01 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,810,133.23 1,307,242.45 235,026.64 2,267,864.14 59.5219 Grand Total -3,810,133.23 -1,307,242.45 -235,026.64 -2,267,864.14 0.5952 542 Public Works-Street 3,810,133.23 1,307,242.45 235,026.64 2,267,864.14 59.52 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 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 81,057.26 58,134.49 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 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 22,000.00 123,000.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 69,398.40 28,601.60 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 524,514.90 428,936.52 2,895,337.85 75.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 4,598,789.27 524,514.90 428,936.52 3,645,337.85 79.2673 Grand Total -4,598,789.27 -524,514.90 -428,936.52 -3,645,337.85 0.7927 990 Capital Projects 4,598,789.27 524,514.90 428,936.52 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 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 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,884,266.72 16,312,840.78 1,537,674.20 45,033,751.74 71.61 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 62,884,266.72 16,312,840.78 1,537,674.20 45,033,751.74 71.6137 Grand Total -62,884,266.72 -16,312,840.78 -1,537,674.20 -45,033,751.74 0.7161 GL - Trial Balance by Acct Type and Full Acct Number (03/19/2024 - 08:56 AM)Page 43