Loading...
HomeMy Public PortalAbout2023-12 Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 12/19/2023 11:15:11 AM Period 01 - 13 Fiscal Year 2023 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 65,475.00 0.00 450.00 0.68 10-110-501015 Salary-Prosecuting Attorney 34,999.92 34,999.92 0.00 0.00 0.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)14,598.40 6,799.14 0.00 7,799.26 53.43 10-110-502010 Social Security 8,990.53 7,999.32 0.00 991.21 11.03 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 124,585.44 115,344.97 0.00 9,240.47 7.42 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 34.74 0.00 65.26 65.26 10-110-512010 Printing 400.00 357.15 0.00 42.85 10.71 10-110-512020 Copies 96.00 0.82 0.00 95.18 99.15 10-110-513010 Office Supplies 1,435.00 1,832.59 0.00 -397.59 -27.71 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 2,031.00 2,225.30 0.00 -194.30 -9.57 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 148,600.00 153,784.95 0.00 -5,184.95 -3.49 10-110-520025 Security 1,500.00 1,794.14 0.00 -294.14 -19.61 10-110-520030 Dues And Publications 4,165.00 6,501.92 0.00 -2,336.92 -56.11 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,189.84 870.00 0.00 319.84 26.88 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 155,454.84 162,951.01 0.00 -7,496.17 -4.82 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 124.00 123.79 0.00 0.21 0.17 E25 Repairs & Maintenance 124.00 123.79 0.00 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,529.88 0.00 -1,529.88 0.00 E70 Capital Purchases 0.00 1,529.88 0.00 -1,529.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 282,195.28 282,174.95 0.00 20.33 0.0072 Grand Total -282,195.28 -282,174.95 0.00 -20.33 0.0001 110 Mayor & Council 282,195.28 282,174.95 0.00 20.33 0.01 120 City Clerk 10-120-501020 Salaries 43,120.25 58,296.92 0.00 -15,176.67 -35.20 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,356.55 4,116.82 0.00 239.73 5.50 10-120-502020 Group Health Insurance 13,245.50 13,030.72 0.00 214.78 1.62 10-120-502030 Retirement 7,289.39 7,434.97 0.00 -145.58 -2.00 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 68.38 0.00 1.39 1.99 10-120-502060 Long Term Disability 174.26 184.37 0.00 -10.11 -5.80 10-120-502070 Employee Assistance Prgm 21.84 20.44 0.00 1.40 6.41 E05 Personnel Services 68,327.55 83,202.61 0.00 -14,875.06 -21.77 10-120-511020 Postage 200.00 236.56 0.00 -36.56 -18.28 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 343.31 0.00 -43.31 -14.44 10-120-513010 Office Supplies 200.00 82.86 0.00 117.14 58.57 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 662.73 0.00 37.27 5.32 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.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 164.10 0.00 235.90 58.98 10-120-522020 Professional Services 200.00 126.33 0.00 73.67 36.84 10-120-529030 Election Expense 18,579.79 10,232.77 0.00 8,347.02 44.93 E15 Contractual Services 19,254.79 10,588.20 0.00 8,666.59 45.01 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 4,426.75 0.00 6,248.25 58.53 E25 Repairs & Maintenance 10,675.00 4,426.75 0.00 6,248.25 58.53 10-120-572020 Purchase Of Equipment 465.33 465.33 0.00 0.00 0.00 E70 Capital Purchases 465.33 465.33 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 99,422.67 99,345.62 0.00 77.05 0.0775 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -99,422.67 -99,345.62 0.00 -77.05 0.0008 120 City Clerk 99,422.67 99,345.62 0.00 77.05 0.08 140 City Administrator 10-140-501020 Salaries 202,787.56 192,611.62 0.00 10,175.94 5.02 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 16,311.43 10,527.98 0.00 5,783.45 35.46 10-140-502020 Group Health Insurance 21,732.71 19,301.67 0.00 2,431.04 11.19 10-140-502030 Retirement 27,292.33 35,935.91 0.00 -8,643.58 -31.67 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 161.58 0.00 -47.75 -41.95 10-140-502060 Long Term Disability 374.04 486.89 0.00 -112.85 -30.17 10-140-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 268,856.80 259,267.79 0.00 9,589.01 3.57 10-140-511010 Advertising 0.00 2,106.73 0.00 -2,106.73 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 235.58 0.00 -135.58 -135.58 10-140-512020 Copies 150.00 55.73 0.00 94.27 62.85 10-140-513010 Office Supplies 525.00 639.96 0.00 -114.96 -21.90 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 668.51 0.00 10.23 1.51 E10 Materials & Supplies 1,603.74 3,732.04 0.00 -2,128.30 -132.71 10-140-520030 Dues And Publications 1,700.00 2,413.09 0.00 -713.09 -41.95 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 1,294.77 0.00 -594.77 -84.97 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 754.06 0.00 -754.06 0.00 10-140-520095 Relocation Fees 0.00 4,502.08 0.00 -4,502.08 0.00 10-140-522020 Professional Services 0.00 59.34 0.00 -59.34 0.00 E15 Contractual Services 2,400.00 9,023.34 0.00 -6,623.34 -275.97 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 483.48 0.00 -183.48 -61.16 E25 Repairs & Maintenance 300.00 483.48 0.00 -183.48 -61.16 10-140-572020 Purchase Of Equipment 472.60 1,076.59 0.00 -603.99 -127.80 E70 Capital Purchases 472.60 1,076.59 0.00 -603.99 -127.80 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 273,633.14 273,583.24 0.00 49.90 0.0182 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -273,633.14 -273,583.24 0.00 -49.90 0.0002 140 City Administrator 273,633.14 273,583.24 0.00 49.90 0.02 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 0.00 0.00 81,276.00 100.00 10-142-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-142-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 0.00 0.00 81,276.00 100.00 10-142-522017 Rehabilitation 378,463.00 0.00 0.00 378,463.00 100.00 10-142-522018 Streetscaping 1,182,000.00 0.00 0.00 1,182,000.00 100.00 10-142-522021 Asbestos Abatement 291,574.00 0.00 0.00 291,574.00 100.00 10-142-522022 Demo 1,179,856.00 0.00 0.00 1,179,856.00 100.00 E15 Contractual Services 3,031,893.00 0.00 0.00 3,031,893.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,113,169.00 0.00 0.00 3,113,169.00 100 Grand Total -3,113,169.00 0.00 0.00 -3,113,169.00 1 142 Community Revitalization 3,113,169.00 0.00 0.00 3,113,169.00 100.00 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 (12/19/2023 - 11:15 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 262,586.37 31,791.19 0.00 230,795.18 87.89 10-144-502010 Social Security 3,526.27 2,309.03 0.00 1,217.24 34.52 10-144-502020 Group Health Insurance 9,875.25 6,415.11 0.00 3,460.14 35.04 10-144-502030 Retirement 6,250.63 4,063.09 0.00 2,187.54 35.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 36.01 37.88 0.00 -1.87 -5.19 10-144-502060 Long Term Disability 97.47 102.44 0.00 -4.97 -5.10 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 44,718.74 0.00 237,653.26 84.16 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,309,300.00 44,718.74 0.00 7,264,581.26 99.3882 Grand Total -7,309,300.00 -44,718.74 0.00 -7,264,581.26 0.9939 144 CDBG-DR 7,309,300.00 44,718.74 0.00 7,264,581.26 99.39 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 38,295.11 13,013.28 0.00 25,281.83 66.02 10-145-502010 Social Security 1,205.81 885.71 0.00 320.10 26.55 10-145-502020 Group Health Insurance 3,666.95 3,299.89 0.00 367.06 10.01 10-145-502030 Retirement 1,771.85 1,657.24 0.00 114.61 6.47 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 14.78 0.00 -1.20 -8.84 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 39.42 0.00 -6.08 -18.24 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 18,918.66 0.00 26,081.34 57.96 10-145-520072 Subrecipient Reimbursements 1,955,000.00 0.00 0.00 1,955,000.00 100.00 E15 Contractual Services 1,955,000.00 0.00 0.00 1,955,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,000,000.00 18,918.66 0.00 1,981,081.34 99.0541 Grand Total -2,000,000.00 -18,918.66 0.00 -1,981,081.34 0.9905 145 CDBG-CV Cole Co EMS Station 2,000,000.00 18,918.66 0.00 1,981,081.34 99.05 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 44,066.84 30,446.48 0.00 13,620.36 30.91 10-146-502010 Social Security 2,060.37 2,083.32 0.00 -22.95 -1.11 10-146-502020 Group Health Insurance 8,016.94 7,997.68 0.00 19.26 0.24 10-146-502030 Retirement 3,870.14 3,874.99 0.00 -4.85 -0.13 10-146-502040 Workers Compensation 9.83 7.37 0.00 2.46 25.03 10-146-502050 Life Insurance 35.19 37.53 0.00 -2.34 -6.65 10-146-502060 Long Term Disability 94.24 100.54 0.00 -6.30 -6.69 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 58,153.55 44,547.91 0.00 13,605.64 23.40 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 355.76 293.94 0.00 61.82 17.38 E15 Contractual Services 355.76 293.94 0.00 61.82 17.38 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 699,339.31 44,841.85 0.00 654,497.46 93.588 Grand Total -699,339.31 -44,841.85 0.00 -654,497.46 0.9359 146 HPF-P Bruhn Revitalization 699,339.31 44,841.85 0.00 654,497.46 93.59 147 CDBG-CV Transform Housing 10-147-501020 Salaries 26,883.63 8,395.31 0.00 18,488.32 68.77 10-147-502010 Social Security 868.14 569.07 0.00 299.07 34.45 10-147-502020 Group Health Insurance 2,586.82 2,049.13 0.00 537.69 20.79 10-147-502030 Retirement 1,380.10 1,069.46 0.00 310.64 22.51 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 9.17 0.00 0.13 1.40 10-147-502060 Long Term Disability 22.85 24.37 0.00 -1.52 -6.65 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 12,122.23 0.00 19,637.77 61.83 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 544,000.00 247.75 0.00 543,752.25 99.95 E15 Contractual Services 544,000.00 247.75 0.00 543,752.25 99.95 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 12,369.98 0.00 563,390.02 97.8515 Grand Total -575,760.00 -12,369.98 0.00 -563,390.02 0.9785 147 CDBG-CV Transform Housing 575,760.00 12,369.98 0.00 563,390.02 97.85 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 59,962.32 29,351.32 0.00 30,611.00 51.05 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,906.32 29,351.32 0.00 50,555.00 63.27 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 79,906.32 29,351.32 0.00 50,555.00 63.2678 Grand Total -79,906.32 -29,351.32 0.00 -50,555.00 0.6327 148 CDBG-CV 79,906.32 29,351.32 0.00 50,555.00 63.27 149 Entitlement Grant 10-149-501020 Salaries 43,452.14 35,381.07 0.00 8,071.07 18.57 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 4,046.91 2,502.82 0.00 1,544.09 38.15 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 12,883.67 7,827.52 0.00 5,056.15 39.24 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,133.44 4,506.89 0.00 2,626.55 36.82 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 35.81 35.81 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 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 58.28 42.36 0.00 15.92 27.32 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 113.45 0.00 29.67 20.73 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 30.68 0.00 -9.12 -42.30 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 50,440.60 0.00 17,334.33 25.58 10-149-511010 Advertising 1,400.00 1,031.25 0.00 368.75 26.34 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 113.67 0.00 -43.67 -62.39 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 250.00 23.65 0.00 226.35 90.54 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,820.00 1,168.57 0.00 651.43 35.79 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 525.00 0.00 500.00 48.78 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 38,510.00 36,505.00 0.00 2,005.00 5.21 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 40,000.00 4,216.00 0.00 35,784.00 89.46 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 51,569.00 0.00 88,431.00 63.17 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 313,000.00 0.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 216,363.08 0.00 0.00 216,363.08 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 4,390.73 0.00 35,609.27 89.02 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 20,000.00 27.00 0.00 19,973.00 99.87 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 808,898.08 410,232.73 0.00 398,665.35 49.28 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 (12/19/2023 - 11:15 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 878,493.01 461,841.90 0.00 416,651.11 47.4279 Grand Total -878,493.01 -461,841.90 0.00 -416,651.11 0.4743 149 Entitlement Grant 878,493.01 461,841.90 0.00 416,651.11 47.43 150 City Attorney 10-150-501020 Salaries 240,166.03 238,310.20 0.00 1,855.83 0.77 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 17,884.00 17,610.51 0.00 273.49 1.53 10-150-502020 Group Health Insurance 35,360.71 32,768.62 0.00 2,592.09 7.33 10-150-502030 Retirement 29,923.56 27,110.09 0.00 2,813.47 9.40 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 264.90 0.00 21.52 7.51 10-150-502060 Long Term Disability 607.87 700.06 0.00 -92.19 -15.17 10-150-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,524.90 317,056.53 0.00 7,468.37 2.30 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 352.81 0.00 247.19 41.20 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 22.41 0.00 -22.41 0.00 10-150-513010 Office Supplies 1,275.00 552.98 0.00 722.02 56.63 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,875.00 928.20 0.00 946.80 50.50 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 8,089.01 1,994.96 1,204.95 10.67 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,255.00 6,232.19 0.00 22.81 0.36 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 4,556.08 1,383.79 0.00 3,172.29 69.63 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 53,120.00 67,998.88 0.00 -14,878.88 -28.01 E15 Contractual Services 75,720.00 84,068.87 1,994.96 -10,343.83 -13.66 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 371.00 423.80 0.00 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 423.80 0.00 -52.80 -14.23 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 402,490.90 402,477.40 1,994.96 -1,981.46 -0.4923 Grand Total -402,490.90 -402,477.40 -1,994.96 1,981.46 -0.0049 150 City Attorney 402,490.90 402,477.40 1,994.96 -1,981.46 -0.49 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 34,999.92 0.00 0.00 0.00 10-160-501020 Salaries 121,879.83 135,293.46 0.00 -13,413.63 -11.01 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 5,863.18 0.00 1,136.82 16.24 10-160-501090 Overtime 1,000.00 106.48 0.00 893.52 89.35 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,831.35 13,279.84 0.00 -448.49 -3.50 10-160-502020 Group Health Insurance 25,616.32 22,065.95 0.00 3,550.37 13.86 10-160-502030 Retirement 16,093.46 17,267.45 0.00 -1,173.99 -7.29 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 149.67 0.00 3.33 2.18 10-160-502060 Long Term Disability 381.67 402.97 0.00 -21.30 -5.58 10-160-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 220,219.24 229,688.45 0.00 -9,469.21 -4.30 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,762.08 0.00 237.92 11.90 10-160-512010 Printing 400.00 162.00 0.00 238.00 59.50 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 2,500.00 1,910.40 0.00 589.60 23.58 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 3,834.48 0.00 1,065.52 21.75 10-160-520025 Security 12,900.00 12,881.13 0.00 18.87 0.15 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 2,500.00 480.00 0.00 2,020.00 80.80 10-160-522020 Professional Services 4,100.00 118.77 0.00 3,981.23 97.10 10-160-525005 Appointed Counsel 3,000.00 857.50 0.00 2,142.50 71.42 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 22,790.00 14,337.40 0.00 8,452.60 37.09 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 (12/19/2023 - 11:15 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 6,281.40 0.00 13.60 0.22 E25 Repairs & Maintenance 6,295.00 6,281.40 0.00 13.60 0.22 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 254,204.24 254,141.73 0.00 62.51 0.0246 Grand Total -254,204.24 -254,141.73 0.00 -62.51 0.0002 160 Municipal Court 254,204.24 254,141.73 0.00 62.51 0.02 170 Human Resources 10-170-501020 Salaries 238,448.92 240,860.08 0.00 -2,411.16 -1.01 10-170-501050 Parttime(wo Benefits)13,000.00 13,247.41 0.00 -247.41 -1.90 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.82 0.00 -46.82 -46.82 10-170-501095 Overtime Straight Pay 0.00 30.59 0.00 -30.59 0.00 10-170-502010 Social Security 18,543.62 19,096.33 0.00 -552.71 -2.98 10-170-502020 Group Health Insurance 25,708.58 24,955.86 0.00 752.72 2.93 10-170-502030 Retirement 29,363.23 30,427.89 0.00 -1,064.66 -3.63 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 272.90 0.00 7.40 2.64 10-170-502060 Long Term Disability 589.14 727.91 0.00 -138.77 -23.55 10-170-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 326,425.00 330,152.84 0.00 -3,727.84 -1.14 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 148.50 0.00 151.50 50.50 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 343.22 0.00 156.78 31.36 10-170-513010 Office Supplies 600.00 425.56 0.00 174.44 29.07 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 680.00 116.88 0.00 563.12 82.81 E10 Materials & Supplies 2,930.00 1,034.16 0.00 1,895.84 64.70 10-170-520030 Dues And Publications 700.00 1,001.38 0.00 -301.38 -43.05 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 2,655.91 0.00 344.09 11.47 10-170-520070 Training And Education 4,437.00 4,578.40 0.00 -141.40 -3.19 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 498.75 0.00 1.25 0.25 10-170-522020 Professional Services 11,600.00 10,033.67 0.00 1,566.33 13.50 10-170-529010 Special Events 800.00 661.70 0.00 138.30 17.29 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 19,429.81 0.00 1,607.19 7.64 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 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 52,738.61 52,148.60 0.00 590.01 1.12 E25 Repairs & Maintenance 52,738.61 52,148.60 0.00 590.01 1.12 10-170-572020 Purchase Of Equipment 3,175.24 3,175.24 0.00 0.00 0.00 E70 Capital Purchases 3,175.24 3,175.24 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 406,305.85 405,940.65 0.00 365.20 0.0899 Grand Total -406,305.85 -405,940.65 0.00 -365.20 0.0009 170 Human Resources 406,305.85 405,940.65 0.00 365.20 0.09 180 Finance Department 10-180-501020 Salaries 448,933.62 506,636.73 0.00 -57,703.11 -12.85 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 43,659.19 37,908.24 0.00 5,750.95 13.17 10-180-502020 Group Health Insurance 96,970.17 80,859.84 0.00 16,110.33 16.61 10-180-502030 Retirement 73,050.67 61,382.76 0.00 11,667.91 15.97 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 587.17 0.00 116.63 16.57 10-180-502060 Long Term Disability 1,743.45 1,572.23 0.00 171.22 9.82 10-180-502070 Employee Assistance Prgm 234.78 175.08 0.00 59.70 25.43 10-180-503020 Unemployment Compensation 0.00 200.28 0.00 -200.28 0.00 E05 Personnel Services 665,794.51 689,821.13 0.00 -24,026.62 -3.61 10-180-511010 Advertising 1,000.00 681.00 0.00 319.00 31.90 10-180-511020 Postage 10,000.00 8,798.92 0.00 1,201.08 12.01 10-180-511021 Mail Machine Cost 3,000.00 2,399.23 0.00 600.77 20.03 10-180-512010 Printing 3,000.00 3,774.30 0.00 -774.30 -25.81 10-180-512020 Copies 1,000.00 24.71 0.00 975.29 97.53 10-180-512021 Copy Machine Cost 190.00 -254.91 0.00 444.91 234.16 10-180-513010 Office Supplies 1,250.00 899.99 0.00 350.01 28.00 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 1,258.00 0.00 2,397.00 65.58 E10 Materials & Supplies 23,095.00 17,581.24 0.00 5,513.76 23.87 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,955.00 682.06 0.00 1,272.94 65.11 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 3,583.13 0.00 1,866.87 34.25 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 2,804.00 2,808.00 0.00 -4.00 -0.14 10-180-522010 Audit 59,643.71 45,377.88 0.00 14,265.83 23.92 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 59.34 0.00 90.66 60.44 E15 Contractual Services 70,002.71 52,510.41 0.00 17,492.30 24.99 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,120.00 14,030.43 0.00 89.57 0.63 E25 Repairs & Maintenance 14,120.00 14,030.43 0.00 89.57 0.63 10-180-572020 Purchase Of Equipment 4,210.45 2,923.35 0.00 1,287.10 30.57 E70 Capital Purchases 4,210.45 2,923.35 0.00 1,287.10 30.57 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 777,222.67 776,866.56 0.00 356.11 0.0458 Grand Total -777,222.67 -776,866.56 0.00 -356.11 0.0005 180 Finance Department 777,222.67 776,866.56 0.00 356.11 0.05 185 Non-Departmental 10-185-501020 Salaries 16,385.95 0.00 0.00 16,385.95 100.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 34,558.92 0.00 2,408.51 6.52 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 4,200.00 4,702.24 0.00 -502.24 -11.96 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,553.38 39,261.16 0.00 18,292.22 31.78 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 21,294.74 0.00 -1,294.74 -6.47 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 67,382.35 570.00 0.00 66,812.35 99.15 E10 Materials & Supplies 87,382.35 21,864.74 0.00 65,517.61 74.98 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 481,601.50 497,327.60 0.00 -15,726.10 -3.27 10-185-521020 Insurance Deductible 108,948.45 108,948.45 0.00 0.00 0.00 10-185-521030 Self Ins Prop & Casualty 15,000.00 701.63 0.00 14,298.37 95.32 10-185-521060 Drugalcohol screening 3,564.00 3,779.90 0.00 -215.90 -6.06 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 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 5,548.25 0.00 -5,548.25 0.00 10-185-522020 Professional Services 111,800.00 59,289.00 7,299.00 45,212.00 40.44 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 46,483.25 0.00 516.75 1.10 10-185-527020 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 5,000.00 8,441.06 0.00 -3,441.06 -68.82 E15 Contractual Services 957,913.95 915,519.14 7,299.00 35,095.81 3.66 10-185-531010 Electricity 32,000.00 34,258.79 0.00 -2,258.79 -7.06 10-185-533010 Natural Gas 6,200.00 5,650.99 0.00 549.01 8.86 10-185-535010 Water 7,250.00 7,465.56 0.00 -215.56 -2.97 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 47,375.34 0.00 -1,925.34 -4.24 10-185-540010 Building & Grounds Maint.38,014.69 47,614.69 0.00 -9,600.00 -25.25 10-185-540015 Amtrak Station 4,000.00 2,348.47 0.00 1,651.53 41.29 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 2,164.00 0.00 -104.00 -5.05 E25 Repairs & Maintenance 69,074.69 77,127.16 0.00 -8,052.47 -11.66 10-185-550010 Miscellaneous 2,800.00 2,199.52 0.00 600.48 21.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 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 451,560.76 288,091.68 0.00 163,469.08 36.20 E30 Other Operating Expenses 464,360.76 300,291.20 0.00 164,069.56 35.33 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 (12/19/2023 - 11:15 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 78,935.79 78,935.79 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 78,935.79 78,935.79 0.00 0.00 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,760,670.92 1,480,374.53 7,299.00 272,997.39 15.5053 Grand Total -1,760,670.92 -1,480,374.53 -7,299.00 -272,997.39 0.1551 185 Non-Departmental 1,760,670.92 1,480,374.53 7,299.00 272,997.39 15.51 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 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 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 186 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 10-190-501020 Salaries 550,896.20 589,039.11 0.00 -38,142.91 -6.92 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 500.00 0.00 0.00 500.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 46,425.69 43,824.59 0.00 2,601.10 5.60 10-190-502020 Group Health Insurance 96,814.24 77,680.10 0.00 19,134.14 19.76 10-190-502030 Retirement 77,679.59 65,410.35 0.00 12,269.24 15.79 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 663.42 0.00 80.77 10.85 10-190-502060 Long Term Disability 1,815.32 1,796.72 0.00 18.60 1.02 10-190-502070 Employee Assistance Prgm 207.48 194.36 0.00 13.12 6.32 E05 Personnel Services 776,440.92 779,966.86 0.00 -3,525.94 -0.45 10-190-511010 Advertising 100.00 54.00 0.00 46.00 46.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 10.14 0.00 -0.14 -1.40 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 493.15 0.00 6.85 1.37 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 (12/19/2023 - 11:15 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 2,000.00 3,212.43 0.00 -1,212.43 -60.62 E10 Materials & Supplies 2,660.00 3,769.72 0.00 -1,109.72 -41.72 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 139.00 0.00 11.00 7.33 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 3,902.61 0.00 4,597.39 54.09 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 44,000.00 41,621.33 0.00 2,378.67 5.41 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 25,580.76 0.00 -2,580.76 -11.22 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 4,315.00 0.00 85.00 1.93 E15 Contractual Services 80,050.00 75,558.70 0.00 4,491.30 5.61 10-190-534010 Telephone 96,000.00 87,559.53 0.00 8,440.47 8.79 E20 Utilities 96,000.00 87,559.53 0.00 8,440.47 8.79 10-190-545010 Software License\maint 197,000.00 205,951.08 0.00 -8,951.08 -4.54 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 19,620.86 0.00 2,379.14 10.81 10-190-547025 Coun Chamber MediaEquip Repr 0.00 1,573.06 0.00 -1,573.06 0.00 E25 Repairs & Maintenance 219,000.00 227,145.00 0.00 -8,145.00 -3.72 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,174,150.92 1,173,999.81 0.00 151.11 0.0129 Grand Total -1,174,150.92 -1,173,999.81 0.00 -151.11 0.0001 190 Information Technology Svcs 1,174,150.92 1,173,999.81 0.00 151.11 0.01 300 Police Department 10-300-501020 Salaries 5,502,458.02 5,108,666.13 0.00 393,791.89 7.16 10-300-501030 Holiday Pay 162,165.48 128,841.96 0.00 33,323.52 20.55 10-300-501040 Part-time (w\benefits)40,192.30 0.00 0.00 40,192.30 100.00 10-300-501050 Parttime(wo Benefits)45,858.01 29,775.81 0.00 16,082.20 35.07 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 7,653.13 10,944.97 0.00 -3,291.84 -43.01 10-300-501090 Overtime 331,257.77 426,639.74 0.00 -95,381.97 -28.79 10-300-501095 Overtime Straight Pay 13,275.00 17,880.73 0.00 -4,605.73 -34.69 10-300-502010 Social Security 444,750.67 416,654.32 0.00 28,096.35 6.32 10-300-502020 Group Health Insurance 960,547.52 867,283.73 0.00 93,263.79 9.71 10-300-502030 Retirement 1,009,334.34 965,028.39 0.00 44,305.95 4.39 10-300-502040 Workers Compensation 75,085.94 75,085.94 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 5,929.32 0.00 612.96 9.37 10-300-502060 Long Term Disability 15,894.91 15,902.80 0.00 -7.89 -0.05 10-300-502070 Employee Assistance Prgm 1,960.14 1,851.60 0.00 108.54 5.54 10-300-503010 Awards Program 2,500.00 992.95 0.00 1,507.05 60.28 10-300-503020 Unemployment Compensation 0.00 2,590.56 0.00 -2,590.56 0.00 E05 Personnel Services 8,619,475.51 8,074,068.95 0.00 545,406.56 6.33 10-300-511010 Advertising 5,665.00 4,346.55 0.00 1,318.45 23.27 10-300-511020 Postage 1,395.00 1,199.01 0.00 195.99 14.05 10-300-512010 Printing 5,951.93 3,638.40 0.00 2,313.53 38.87 10-300-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,529.37 0.00 0.00 1,529.37 100.00 10-300-513010 Office Supplies 15,670.50 18,624.11 0.00 -2,953.61 -18.85 10-300-514010 Gas 188,862.00 225,566.42 0.00 -36,704.42 -19.43 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 726.63 1,164.01 0.00 -437.38 -60.19 10-300-515040 First Aid Supplies 1,378.00 2,166.66 0.00 -788.66 -57.23 10-300-516010 Ammunition & Firearms Supplies 63,136.25 62,607.35 0.00 528.90 0.84 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)255.00 255.00 0.00 0.00 0.00 10-300-516050 Community Projects 11,100.00 11,100.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 46,278.00 50,865.83 0.00 -4,587.83 -9.91 E10 Materials & Supplies 344,272.75 381,533.41 0.00 -37,260.66 -10.82 10-300-520030 Dues And Publications 5,400.00 4,824.40 0.00 575.60 10.66 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 75,794.00 70,308.07 0.00 5,485.93 7.24 10-300-520080 Tuition Reimbursement 10,576.11 1,457.00 0.00 9,119.11 86.22 10-300-520090 Recruitment 51,330.75 1,330.74 0.00 50,000.01 97.41 10-300-521040 Medical Claimsservices 6,510.00 7,035.20 0.00 -525.20 -8.07 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 17,005.14 20,420.14 0.00 -3,415.00 -20.08 10-300-522026 Drug Forfeiture - Justice 29,750.00 29,761.01 0.00 -11.01 -0.04 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 44,836.00 50,985.73 0.00 -6,149.73 -13.72 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 796.19 0.00 1,249.81 61.09 E15 Contractual Services 243,248.00 186,918.48 0.00 56,329.52 23.16 10-300-531010 Electricity 42,362.90 43,684.60 0.00 -1,321.70 -3.12 10-300-533010 Natural Gas 1,033.21 810.85 0.00 222.36 21.52 10-300-534010 Telephone 24,101.00 29,709.74 0.00 -5,608.74 -23.27 10-300-535010 Water 3,348.00 4,625.57 0.00 -1,277.57 -38.16 E20 Utilities 70,845.11 78,830.76 0.00 -7,985.65 -11.27 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 114,908.01 0.00 -77,708.01 -208.89 10-300-541030 Vehicle Wash 9,752.00 10,043.00 0.00 -291.00 -2.98 10-300-544010 K-9 Operations 16,740.00 11,957.15 0.00 4,782.85 28.57 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 27,950.00 37,282.51 0.00 -9,332.51 -33.39 10-300-545010 Software License\maint 82,414.00 64,705.16 0.00 17,708.84 21.49 10-300-546010 Clothing Expense 48,730.12 26,686.71 0.00 22,043.41 45.24 10-300-546020 Uniform Cleaning 23,715.00 26,170.92 0.00 -2,455.92 -10.36 10-300-547010 Equipment Maintenance 10,000.00 1,357.82 0.00 8,642.18 86.42 10-300-547020 Maintenance Agreements 56,248.00 45,405.72 90.00 10,752.28 19.12 10-300-547030 Radio Maintenance 8,025.00 330.16 0.00 7,694.84 95.89 E25 Repairs & Maintenance 320,774.12 338,847.16 90.00 -18,163.04 -5.66 10-300-572010 Purchase Of Vehicles 46,849.80 46,849.09 0.00 0.71 0.00 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 62,215.43 17,130.00 0.00 45,085.43 72.47 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 131,750.00 131,750.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 17,386.58 12,992.32 0.00 4,394.26 25.27 10-300-572090 Body Worn Cameras 180,000.00 60,000.00 0.00 120,000.00 66.67 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 438,201.81 268,721.41 0.00 169,480.40 38.68 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,036,817.30 9,328,920.17 90.00 707,807.13 7.0521 Grand Total -10,036,817.30 -9,328,920.17 -90.00 -707,807.13 0.0705 300 Police Department 10,036,817.30 9,328,920.17 90.00 707,807.13 7.05 310 School Resource Officer 10-310-501020 Salaries 466,059.20 399,209.84 0.00 66,849.36 14.34 10-310-501030 Holiday Pay 20,720.19 1,783.91 0.00 18,936.28 91.39 10-310-501090 Overtime 68,455.43 114,471.55 0.00 -46,016.12 -67.22 10-310-501095 Overtime Straight Pay 1,796.34 2,267.46 0.00 -471.12 -26.23 10-310-502010 Social Security 42,612.88 37,423.07 0.00 5,189.81 12.18 10-310-502020 Group Health Insurance 89,715.43 76,460.90 0.00 13,254.53 14.77 10-310-502030 Retirement 100,265.61 92,899.46 0.00 7,366.15 7.35 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 466.47 0.00 136.96 22.70 10-310-502060 Long Term Disability 1,498.63 1,255.28 0.00 243.35 16.24 10-310-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 E05 Personnel Services 798,454.72 732,954.48 0.00 65,500.24 8.20 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 9,891.10 0.00 5,453.90 35.54 10-310-517010 Operational Supplies 6,995.00 1,181.12 0.00 5,813.88 83.11 E10 Materials & Supplies 22,340.00 11,072.22 0.00 11,267.78 50.44 10-310-520070 Training And Education 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,227.60 147.11 0.00 5,080.49 97.19 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 1,106.40 1,106.40 0.00 0.00 0.00 E25 Repairs & Maintenance 6,334.00 1,253.51 0.00 5,080.49 80.21 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 831,778.72 746,355.21 0.00 85,423.51 10.27 Grand Total -831,778.72 -746,355.21 0.00 -85,423.51 0.1027 310 School Resource Officer 831,778.72 746,355.21 0.00 85,423.51 10.27 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 126,557.42 128,353.11 0.00 -1,795.69 -1.42 10-320-501030 Holiday Pay 5,319.56 220.95 0.00 5,098.61 95.85 10-320-501090 Overtime 50,125.78 36,272.88 0.00 13,852.90 27.64 10-320-501095 Overtime Straight Pay 1,049.54 1,491.46 0.00 -441.92 -42.11 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 12,047.57 0.00 -1,010.39 -9.15 10-320-502020 Group Health Insurance 20,462.81 20,107.72 0.00 355.09 1.74 10-320-502030 Retirement 25,969.83 29,864.11 0.00 -3,894.28 -15.00 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 148.86 0.00 6.59 4.24 10-320-502060 Long Term Disability 384.75 398.33 0.00 -13.58 -3.53 10-320-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 243,110.39 230,950.30 0.00 12,160.09 5.00 10-320-514010 Gas 11,848.00 9,526.58 0.00 2,321.42 19.59 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 8,521.40 0.00 6,584.60 43.59 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 18,647.98 0.00 13,500.30 41.99 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 19,706.00 12,900.00 0.00 6,806.00 34.54 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 19,706.00 12,900.00 0.00 6,806.00 34.54 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 294,964.67 262,498.28 0.00 32,466.39 11.0069 Grand Total -294,964.67 -262,498.28 0.00 -32,466.39 0.1101 320 M.U.S.T.A.N.G.294,964.67 262,498.28 0.00 32,466.39 11.01 330 Animal Control 10-330-501020 Salaries 331,650.09 346,048.79 0.00 -14,398.70 -4.34 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 7,989.93 0.00 610.07 7.09 10-330-501090 Overtime 9,887.79 11,009.18 0.00 -1,121.39 -11.34 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 25,070.31 0.00 4,052.56 13.92 10-330-502020 Group Health Insurance 93,298.71 79,784.66 0.00 13,514.05 14.48 10-330-502030 Retirement 48,728.46 41,272.98 0.00 7,455.48 15.30 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 383.17 0.00 73.38 16.07 10-330-502060 Long Term Disability 1,117.06 1,060.22 0.00 56.84 5.09 10-330-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 527,717.33 517,464.00 0.00 10,253.33 1.94 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 106.16 0.00 45.84 30.16 10-330-512010 Printing 1,860.00 1,541.00 0.00 319.00 17.15 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 336.00 0.00 945.00 73.77 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 221.76 0.00 1.24 0.56 10-330-515040 First Aid Supplies 295.00 355.95 0.00 -60.95 -20.66 10-330-517010 Operational Supplies 7,924.82 6,788.21 0.00 1,136.61 14.34 E10 Materials & Supplies 12,640.82 9,349.08 0.00 3,291.74 26.04 10-330-520030 Dues And Publications 900.00 237.60 0.00 662.40 73.60 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 664.00 0.00 0.00 664.00 100.00 10-330-521040 Medical Claimsservices 690.00 1,084.14 0.00 -394.14 -57.12 10-330-522020 Professional Services 3,361.00 1,546.80 0.00 1,814.20 53.98 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,708.00 3,274.72 0.00 433.28 11.69 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 4,580.00 4,580.00 0.00 0.00 0.00 E15 Contractual Services 13,903.00 10,723.26 0.00 3,179.74 22.87 10-330-531010 Electricity 22,789.00 26,261.27 0.00 -3,472.27 -15.24 10-330-533010 Natural Gas 21,000.00 26,531.28 0.00 -5,531.28 -26.34 10-330-534010 Telephone 810.00 838.89 0.00 -28.89 -3.57 10-330-535010 Water 3,800.00 4,986.52 0.00 -1,186.52 -31.22 E20 Utilities 48,399.00 58,617.96 0.00 -10,218.96 -21.11 10-330-540010 Building & Grounds Maint.18,075.18 21,508.61 0.00 -3,433.43 -19.00 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 48,790.00 53,708.23 0.00 -4,918.23 -10.08 10-330-544050 Animal Food 6,103.00 4,923.58 0.00 1,179.42 19.33 10-330-545010 Software Licensemaint 3,191.00 2,870.09 0.00 320.91 10.06 10-330-546010 Clothing Expense 2,025.00 1,857.36 0.00 167.64 8.28 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 198.60 0.00 0.00 198.60 100.00 10-330-547020 Maintenance Agreements 416.40 416.40 0.00 0.00 0.00 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 2,086.00 2,086.00 0.00 0.00 0.00 E25 Repairs & Maintenance 81,485.18 87,910.27 0.00 -6,425.09 -7.88 10-330-572010 Purchase of Vehicles 42,695.00 42,695.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 42,695.00 42,695.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 726,840.33 726,759.57 0.00 80.76 0.0111 Grand Total -726,840.33 -726,759.57 0.00 -80.76 0.0001 330 Animal Control 726,840.33 726,759.57 0.00 80.76 0.01 390 9-1-1 Police 10-390-501020 Salaries 934,271.90 891,785.91 0.00 42,485.99 4.55 10-390-501030 Holiday Pay 38,718.75 30,548.60 0.00 8,170.15 21.10 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 11,106.64 12,064.94 0.00 -958.30 -8.63 10-390-501090 Overtime 84,211.43 113,926.60 0.00 -29,715.17 -35.29 10-390-501095 Overtime Straight Pay 3,162.44 4,625.67 0.00 -1,463.23 -46.27 10-390-502010 Social Security 87,556.95 77,297.17 0.00 10,259.78 11.72 10-390-502020 Group Health Insurance 223,648.25 166,927.48 0.00 56,720.77 25.36 10-390-502030 Retirement 152,546.30 116,099.02 0.00 36,447.28 23.89 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,332.94 1,001.54 0.00 331.40 24.86 10-390-502060 Long Term Disability 3,302.13 2,680.35 0.00 621.78 18.83 10-390-502070 Employee Assistance Prgm 480.48 434.76 0.00 45.72 9.52 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,543,058.17 1,420,112.00 0.00 122,946.17 7.97 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,800.00 5,948.84 0.00 851.16 12.52 E10 Materials & Supplies 8,200.00 5,948.84 0.00 2,251.16 27.45 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 4,082.33 0.00 1,567.67 27.75 10-390-522020 Professional Services 4,300.00 4,601.40 0.00 -301.40 -7.01 10-390-523010 Equipment Rentlease 99,260.00 65,674.50 0.00 33,585.50 33.84 E15 Contractual Services 109,768.00 74,358.23 0.00 35,409.77 32.26 10-390-531010 Electricity 13,437.10 13,437.10 0.00 0.00 0.00 10-390-533010 Natural Gas 361.79 361.79 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 1,026.88 1,026.88 0.00 0.00 0.00 E20 Utilities 14,825.77 14,825.77 0.00 0.00 0.00 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 685.93 112.02 0.00 573.91 83.67 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 12,744.07 12,744.07 0.00 0.00 0.00 10-390-547020 Maintenance Agreements 75,000.00 75,069.65 44.28 -113.93 -0.15 10-390-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 143,606.00 136,478.59 44.28 7,083.13 4.93 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,819,457.94 1,651,723.43 44.28 167,690.23 9.2165 Grand Total -1,819,457.94 -1,651,723.43 -44.28 -167,690.23 0.0922 390 9-1-1 Police 1,819,457.94 1,651,723.43 44.28 167,690.23 9.22 400 Fire Department 10-400-501020 Salaries 4,730,228.94 4,188,946.00 0.00 541,282.94 11.44 10-400-501025 Other Hours 0.00 5,094.73 0.00 -5,094.73 0.00 10-400-501030 Holiday Pay 341,978.12 340,217.39 0.00 1,760.73 0.51 10-400-501035 Training & Essential Functions 0.00 25,852.83 0.00 -25,852.83 0.00 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 38,000.00 37,019.82 0.00 980.18 2.58 10-400-501090 Overtime-FLSA 48,689.59 263,384.58 0.00 -214,694.99 -440.95 10-400-501092 Overtime-Constant Staffing 0.00 59,359.06 0.00 -59,359.06 0.00 10-400-501095 Overtime Straight Pay 36,310.41 38,800.69 0.00 -2,490.28 -6.86 10-400-502010 Social Security 69,573.39 70,857.93 0.00 -1,284.54 -1.85 10-400-502020 Group Health Insurance 877,737.91 835,003.88 0.00 42,734.03 4.87 10-400-502030 Retirement 2,292,378.67 2,398,567.04 0.00 -106,188.37 -4.63 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 4,795.23 0.00 273.35 5.39 10-400-502060 Long Term Disability 12,419.68 12,819.19 0.00 -399.51 -3.22 10-400-502070 Employee Assistance Prgm 1,681.68 1,554.92 0.00 126.76 7.54 10-400-503010 Awards Program 1,194.49 382.35 0.00 812.14 67.99 E05 Personnel Services 8,608,292.41 8,435,686.59 0.00 172,605.82 2.01 10-400-511010 Advertising 300.00 332.75 0.00 -32.75 -10.92 10-400-511020 Postage 320.00 328.98 0.00 -8.98 -2.81 10-400-512010 Printing 889.37 889.37 0.00 0.00 0.00 10-400-512020 Copies 0.14 0.14 0.00 0.00 0.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,389.61 1,376.95 0.00 12.66 0.91 10-400-514010 Gas 61,175.00 89,766.01 0.00 -28,591.01 -46.74 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 317.27 16.95 0.00 300.32 94.66 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,248.61 6,248.61 0.00 0.00 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 2,100.00 0.00 0.00 0.00 10-400-517010 Operational Supplies 18,000.00 15,491.36 0.00 2,508.64 13.94 E10 Materials & Supplies 90,740.00 116,551.12 0.00 -25,811.12 -28.45 10-400-520030 Dues And Publications 3,400.00 3,202.04 0.00 197.96 5.82 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 33,200.00 34,721.00 0.00 -1,521.00 -4.58 10-400-520080 Tuition Reimbursement 13,510.00 13,709.00 0.00 -199.00 -1.47 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 44,451.80 44,451.80 0.00 0.00 0.00 10-400-522020 Professional Services 7,896.70 1,000.00 0.00 6,896.70 87.34 10-400-523010 Equipment Rentlease 100.00 100.00 0.00 0.00 0.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,405.51 5,405.51 0.00 0.00 0.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,165.00 0.00 1,335.00 53.40 E15 Contractual Services 110,557.01 103,754.35 0.00 6,802.66 6.15 10-400-531010 Electricity 38,800.00 39,942.79 0.00 -1,142.79 -2.95 10-400-533010 Natural Gas 23,522.45 23,030.23 0.00 492.22 2.09 10-400-534010 Telephone 25,731.75 26,771.98 0.00 -1,040.23 -4.04 10-400-535010 Water 12,800.00 12,505.52 0.00 294.48 2.30 E20 Utilities 100,854.20 102,250.52 0.00 -1,396.32 -1.38 10-400-540010 Building & Grounds Maint.90,000.00 66,465.62 0.00 23,534.38 26.15 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 92,548.20 88,975.37 0.00 3,572.83 3.86 10-400-546020 Uniform Cleaning 500.00 370.20 0.00 129.80 25.96 10-400-547010 Equipment Maintenance 20,000.00 19,793.99 0.00 206.01 1.03 10-400-547020 Maintenance Agreements 39,651.50 40,466.09 474.40 -1,288.99 -3.25 10-400-547030 Radio Maintenance 20,925.00 20,119.90 0.00 805.10 3.85 E25 Repairs & Maintenance 263,624.70 236,191.17 474.40 26,959.13 10.23 10-400-572010 Purchase Of Vehicles 67,456.00 67,456.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 1,500.00 1,196.00 0.00 304.00 20.27 10-400-572021 Purchase of Equipment-ONE TIME 253,126.95 164,691.10 0.00 88,435.85 34.94 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 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 322,082.95 233,343.10 0.00 88,739.85 27.55 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,496,151.27 9,227,776.85 474.40 267,900.02 2.8211 Grand Total -9,496,151.27 -9,227,776.85 -474.40 -267,900.02 0.0282 400 Fire Department 9,496,151.27 9,227,776.85 474.40 267,900.02 2.82 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,880.00 1,853.57 0.00 26.43 1.41 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 25.48 0.00 -25.48 0.00 E20 Utilities 1,880.00 1,879.05 0.00 0.95 0.05 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 1,880.00 1,879.05 0.00 0.95 0.0505 Grand Total -1,880.00 -1,879.05 0.00 -0.95 0.0005 401 Fire Museum 1,880.00 1,879.05 0.00 0.95 0.05 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 243,740.33 247,065.71 0.00 -3,325.38 -1.36 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,375.72 18,064.45 0.00 311.27 1.69 10-520-502020 Group Health Insurance 52,232.32 46,437.38 0.00 5,794.94 11.09 10-520-502030 Retirement 30,746.30 28,181.44 0.00 2,564.86 8.34 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 254.38 0.00 41.83 14.12 10-520-502060 Long Term Disability 636.77 668.36 0.00 -31.59 -4.96 10-520-502070 Employee Assistance Prgm 87.36 61.36 0.00 26.00 29.76 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 346,311.91 340,929.98 0.00 5,381.93 1.55 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 42.43 0.00 32.57 43.43 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.08 0.00 -0.08 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 642.33 0.00 207.67 24.43 10-520-514010 Gas 12,975.00 18,486.88 0.00 -5,511.88 -42.48 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 1,266.48 0.00 -766.48 -153.30 E10 Materials & Supplies 14,500.00 21,460.70 0.00 -6,960.70 -48.00 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 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 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 4,035.45 4,035.45 0.00 0.00 0.00 E15 Contractual Services 7,035.45 5,174.51 0.00 1,860.94 26.45 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 32,125.73 32,398.43 0.00 -272.70 -0.85 E25 Repairs & Maintenance 32,125.73 32,398.43 0.00 -272.70 -0.85 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 399,973.09 399,963.62 0.00 9.47 0.0024 Grand Total -399,973.09 -399,963.62 0.00 -9.47 0 520 Plan & Protect Svcs-Admin 399,973.09 399,963.62 0.00 9.47 0.00 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 120,568.37 103,466.52 0.00 17,101.85 14.18 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 3,932.77 7,727.76 0.00 -3,794.99 -96.50 10-521-502020 Group Health Insurance 9,239.72 17,243.01 0.00 -8,003.29 -86.62 10-521-502030 Retirement 6,580.32 13,194.27 0.00 -6,613.95 -100.51 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 118.79 0.00 -56.37 -90.31 10-521-502060 Long Term Disability 156.03 317.98 0.00 -161.95 -103.79 10-521-502070 Employee Assistance Prgm 15.29 55.24 0.00 -39.95 -261.28 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 140,713.27 142,281.92 0.00 -1,568.65 -1.11 10-521-511010 Advertising 3,336.00 3,278.70 0.00 57.30 1.72 10-521-511020 Postage 500.00 293.63 0.00 206.37 41.27 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 230.72 0.00 569.28 71.16 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 87.66 0.00 112.34 56.17 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,112.53 0.00 387.47 25.83 E10 Materials & Supplies 6,336.00 5,003.24 0.00 1,332.76 21.03 10-521-520030 Dues And Publications 14,032.68 14,389.68 0.00 -357.00 -2.54 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 687.32 180.00 0.00 507.32 73.81 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 14,569.68 0.00 150.32 1.02 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,271.00 1,165.79 0.00 105.21 8.28 E25 Repairs & Maintenance 1,271.00 1,165.79 0.00 105.21 8.28 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 163,040.27 163,020.63 0.00 19.64 0.012 Grand Total -163,040.27 -163,020.63 0.00 -19.64 0.0001 521 Plan & Protect Svcs-Planning 163,040.27 163,020.63 0.00 19.64 0.01 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 131,978.86 79,658.40 0.00 52,320.46 39.64 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,974.68 6,020.09 0.00 3,954.59 39.65 10-522-502020 Group Health Insurance 20,902.54 11,042.23 0.00 9,860.31 47.17 10-522-502030 Retirement 16,689.66 10,154.30 0.00 6,535.36 39.16 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 92.93 0.00 68.11 42.29 10-522-502060 Long Term Disability 397.13 248.46 0.00 148.67 37.44 10-522-502070 Employee Assistance Prgm 50.23 47.04 0.00 3.19 6.35 E05 Personnel Services 180,256.69 107,366.00 0.00 72,890.69 40.44 10-522-511010 Advertising 2,389.73 764.74 0.00 1,624.99 68.00 10-522-511020 Postage 300.00 21.60 0.00 278.40 92.80 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 116.23 0.00 883.77 88.38 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 510.27 510.27 0.00 0.00 0.00 10-522-517010 Operational Supplies 1,000.00 966.95 0.00 33.05 3.31 E10 Materials & Supplies 5,600.00 2,379.79 0.00 3,220.21 57.50 10-522-520030 Dues And Publications 1,500.00 1,975.73 0.00 -475.73 -31.72 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 1,009.23 0.00 3,490.77 77.57 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 49,028.00 0.00 30,972.00 38.72 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 52,012.96 0.00 36,987.04 41.56 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 1,364.41 0.00 1,035.59 43.15 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,364.41 0.00 1,035.59 43.15 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 280,656.69 163,123.16 0.00 117,533.53 41.878 Grand Total -280,656.69 -163,123.16 0.00 -117,533.53 0.4188 522 Plan & Protect Svcs-MPO 280,656.69 163,123.16 0.00 117,533.53 41.88 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 9,278.00 40,763.06 0.00 -31,485.06 -339.35 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 5,972.99 2,967.37 0.00 3,005.62 50.32 10-530-502020 Group Health Insurance 8,770.40 7,070.56 0.00 1,699.84 19.38 10-530-502030 Retirement 9,467.98 4,812.41 0.00 4,655.57 49.17 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 41.72 0.00 98.72 70.29 10-530-502060 Long Term Disability 344.86 108.62 0.00 236.24 68.50 10-530-502070 Employee Assistance Prgm 51.96 15.33 0.00 36.63 70.50 E05 Personnel Services 34,112.93 55,866.94 0.00 -21,754.01 -63.77 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 121.83 0.00 28.17 18.78 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 110.00 36.35 0.00 73.65 66.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 497.03 0.00 82.97 14.31 E10 Materials & Supplies 1,380.00 860.96 0.00 519.04 37.61 10-530-520030 Dues And Publications 604.82 724.70 0.00 -119.88 -19.82 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,895.18 2,686.51 0.00 -791.33 -41.75 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 33,334.00 1,150.35 0.00 32,183.65 96.55 10-530-524025 Glass Recycling 10,000.00 10,000.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,000.00 22,378.62 0.00 -3,378.62 -17.78 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 27,000.00 238.67 0.00 26,761.33 99.12 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 91,834.00 37,178.85 0.00 54,655.15 59.52 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 672.02 711.38 0.00 -39.36 -5.86 E25 Repairs & Maintenance 672.02 711.38 0.00 -39.36 -5.86 10-530-550020 NRA-Residential 45,539.18 40,038.77 0.00 5,500.41 12.08 10-530-550030 NRA-Commercial Facade 13,960.82 6,000.00 0.00 7,960.82 57.02 10-530-550031 Historic Preservation Grant 23,030.99 55.75 0.00 22,975.24 99.76 10-530-550032 NRA-Rental Facade 11,281.52 27.00 0.00 11,254.52 99.76 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 1,169.01 292.10 0.00 876.91 75.01 10-530-550039 Historic Preservation Grant 50,000.00 22,272.50 0.00 27,727.50 55.46 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 144,981.52 68,686.12 0.00 76,295.40 52.62 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 272,980.47 163,304.25 0.00 109,676.22 40.1773 Grand Total -272,980.47 -163,304.25 0.00 -109,676.22 0.4018 530 Plan & Protect Svc-RedevGrant 272,980.47 163,304.25 0.00 109,676.22 40.18 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 199,295.87 199,076.93 0.00 218.94 0.11 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 14,908.31 14,195.95 0.00 712.36 4.78 10-532-502020 Group Health Insurance 39,644.71 38,141.22 0.00 1,503.49 3.79 10-532-502030 Retirement 24,944.62 25,384.00 0.00 -439.38 -1.76 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 197.83 0.00 40.85 17.11 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 598.16 0.00 -5.50 -0.93 10-532-502070 Employee Assistance Prgm 65.52 79.26 0.00 -13.74 -20.97 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 283,443.79 281,426.77 0.00 2,017.02 0.71 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 85.92 0.00 64.08 42.72 10-532-512010 Printing 293.00 293.00 0.00 0.00 0.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,027.00 711.98 0.00 315.02 30.67 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 654.49 0.00 345.51 34.55 E10 Materials & Supplies 2,625.00 1,745.39 0.00 879.61 33.51 10-532-520030 Dues And Publications 900.00 720.00 0.00 180.00 20.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 552.90 0.00 447.10 44.71 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 201,678.00 206,213.55 0.00 -4,535.55 -2.25 10-532-529010 Special Events 122.00 0.00 0.00 122.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 203,700.00 207,486.45 0.00 -3,786.45 -1.86 10-532-534010 Telephone 1,200.00 1,360.92 0.00 -160.92 -13.41 E20 Utilities 1,200.00 1,360.92 0.00 -160.92 -13.41 10-532-540060 Cemetery Maintenance 37,750.00 37,012.39 0.00 737.61 1.95 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 880.42 0.00 199.58 18.48 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,310.00 1,227.43 0.00 82.57 6.30 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,470.00 40,404.24 0.00 1,065.76 2.57 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 532,438.79 532,423.77 0.00 15.02 0.0028 Grand Total -532,438.79 -532,423.77 0.00 -15.02 0 532 Plan & Protect Svcs-Env Health 532,438.79 532,423.77 0.00 15.02 0.00 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 187,928.06 186,149.19 0.00 1,778.87 0.95 10-533-501050 Parttime(wo Benefits)25,589.96 33,707.31 0.00 -8,117.35 -31.72 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 16,861.52 16,647.40 0.00 214.12 1.27 10-533-502020 Group Health Insurance 30,239.78 25,618.55 0.00 4,621.23 15.28 10-533-502030 Retirement 21,096.27 20,698.39 0.00 397.88 1.89 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 186.13 0.00 17.68 8.67 10-533-502060 Long Term Disability 505.89 512.33 0.00 -6.44 -1.27 10-533-502070 Employee Assistance Prgm 65.52 58.81 0.00 6.71 10.24 E05 Personnel Services 284,748.19 285,835.49 0.00 -1,087.30 -0.38 10-533-511010 Advertising 205.63 205.63 0.00 0.00 0.00 10-533-511020 Postage 2,138.11 2,138.11 0.00 0.00 0.00 10-533-512010 Printing 224.43 194.00 0.00 30.43 13.56 10-533-512020 Copies 0.04 0.04 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 976.91 0.00 23.09 2.31 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 108.86 0.00 16.14 12.91 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,319.90 1,321.90 0.00 -2.00 -0.15 E10 Materials & Supplies 5,028.11 4,945.45 0.00 82.66 1.64 10-533-520030 Dues And Publications 297.53 295.44 0.00 2.09 0.70 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,402.47 1,402.47 0.00 0.00 0.00 10-533-520080 Tuition Reimbursement 5,082.50 5,082.50 0.00 0.00 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 31,897.80 31,897.80 0.00 0.00 0.00 10-533-522022 Demo 226,944.83 186,447.50 0.00 40,497.33 17.84 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 344,082.68 268,905.71 0.00 75,176.97 21.85 10-533-534010 Telephone 3,954.26 3,954.26 0.00 0.00 0.00 E20 Utilities 3,954.26 3,954.26 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 1,196.43 0.00 83.57 6.53 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 1,260.71 0.00 10.29 0.81 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 2,727.14 0.00 123.86 4.34 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 640,664.24 566,368.05 0.00 74,296.19 11.5967 Grand Total -640,664.24 -566,368.05 0.00 -74,296.19 0.116 533 PPS - Prop MaintCode Enforce 640,664.24 566,368.05 0.00 74,296.19 11.60 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 306,551.68 313,844.81 0.00 -7,293.13 -2.38 10-534-501050 Parttime(wo Benefits)15,900.00 12,820.20 0.00 3,079.80 19.37 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 24,587.69 22,912.50 0.00 1,675.19 6.81 10-534-502020 Group Health Insurance 79,982.22 78,330.16 0.00 1,652.06 2.07 10-534-502030 Retirement 39,104.99 40,025.29 0.00 -920.30 -2.35 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 367.05 0.00 7.49 2.00 10-534-502060 Long Term Disability 929.35 983.29 0.00 -53.94 -5.80 10-534-502070 Employee Assistance Prgm 109.20 122.76 0.00 -13.56 -12.42 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 472,295.74 474,162.13 0.00 -1,866.39 -0.40 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 238.24 0.00 861.76 78.34 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 289.79 0.00 610.21 67.80 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 522.71 0.00 1,277.29 70.96 E10 Materials & Supplies 4,115.00 1,050.74 0.00 3,064.26 74.47 10-534-520030 Dues And Publications 2,500.00 1,107.70 0.00 1,392.30 55.69 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 7,446.59 0.00 -2,446.59 -48.93 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 8,554.29 0.00 -1,054.29 -14.06 10-534-534010 Telephone 3,060.00 3,106.62 0.00 -46.62 -1.52 E20 Utilities 3,060.00 3,106.62 0.00 -46.62 -1.52 10-534-541030 Vehicle Wash 270.00 300.00 0.00 -30.00 -11.11 10-534-546010 Clothing Expense 1,400.00 1,392.00 0.00 8.00 0.57 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 1,030.92 0.00 -42.92 -4.34 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,727.92 0.00 -49.92 -1.86 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 489,648.74 489,601.70 0.00 47.04 0.0096 Grand Total -489,648.74 -489,601.70 0.00 -47.04 0.0001 534 Plan & Protect Svcs-Bldg Regs 489,648.74 489,601.70 0.00 47.04 0.01 535 Public Works-Central Maintenan 10-535-501020 Salaries 422,548.51 412,612.96 0.00 9,935.55 2.35 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 2,131.01 0.00 2,368.99 52.64 10-535-501095 Overtime Straight Pay 500.00 174.86 0.00 325.14 65.03 10-535-502010 Social Security 30,175.52 30,336.03 0.00 -160.51 -0.53 10-535-502020 Group Health Insurance 79,635.09 76,715.29 0.00 2,919.80 3.67 10-535-502030 Retirement 49,977.76 51,553.53 0.00 -1,575.77 -3.15 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 455.24 0.00 17.22 3.64 10-535-502060 Long Term Disability 1,177.64 1,224.54 0.00 -46.90 -3.98 10-535-502070 Employee Assistance Prgm 152.88 143.20 0.00 9.68 6.33 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 597,609.22 579,816.02 0.00 17,793.20 2.98 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 4.68 0.00 45.32 90.64 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 992.64 0.00 7.36 0.74 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 3,000.00 3,016.08 0.00 -16.08 -0.54 10-535-517010 Operational Supplies 7,000.00 7,041.97 0.00 -41.97 -0.60 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 11,140.00 11,071.87 0.00 68.13 0.61 10-535-520030 Dues And Publications 350.00 191.00 0.00 159.00 45.43 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 711.12 379.80 0.00 331.32 46.59 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.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,561.12 1,070.80 0.00 490.32 31.41 10-535-531010 Electricity 6,560.00 5,595.31 0.00 964.69 14.71 10-535-533010 Natural Gas 3,350.00 3,869.26 0.00 -519.26 -15.50 10-535-534010 Telephone 420.00 541.19 0.00 -121.19 -28.85 10-535-535010 Water 1,292.00 1,264.16 0.00 27.84 2.15 E20 Utilities 11,622.00 11,269.92 0.00 352.08 3.03 10-535-540010 Building & Grounds Maint.11,000.00 11,872.19 0.00 -872.19 -7.93 10-535-541010 Veh & Equip Parts Etc 456,892.87 463,960.67 0.00 -7,067.80 -1.55 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 12,088.88 14,992.87 0.00 -2,903.99 -24.02 10-535-547010 Equipment Maintenance 1,000.00 783.65 0.00 216.35 21.64 10-535-547020 Maintenance Agreements 15,551.00 15,227.77 0.00 323.23 2.08 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 496,632.75 506,837.15 0.00 -10,204.40 -2.05 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,118,565.09 1,110,065.76 0.00 8,499.33 0.7598 Grand Total -1,118,565.09 -1,110,065.76 0.00 -8,499.33 0.0076 535 Public Works-Central Maintenan 1,118,565.09 1,110,065.76 0.00 8,499.33 0.76 540 Public Works-Admin 10-540-501020 Salaries 239,588.45 242,966.86 0.00 -3,378.41 -1.41 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 18,049.00 18,518.92 0.00 -469.92 -2.60 10-540-502020 Group Health Insurance 20,506.66 19,033.44 0.00 1,473.22 7.18 10-540-502030 Retirement 30,199.64 29,735.78 0.00 463.86 1.54 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 262.25 0.00 27.84 9.60 10-540-502060 Long Term Disability 569.01 683.74 0.00 -114.73 -20.16 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 309,487.60 311,466.24 0.00 -1,978.64 -0.64 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 3.00 0.00 197.00 98.50 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 100.00 47.00 0.00 53.00 53.00 10-540-512020 Copies 100.00 0.53 0.00 99.47 99.47 10-540-513010 Office Supplies 1,500.00 629.64 0.00 870.36 58.02 10-540-514010 Gas 103,850.00 102,996.56 0.00 853.44 0.82 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 1,050.00 1,025.80 0.00 24.20 2.30 10-540-517010 Operational Supplies 300.00 159.98 0.00 140.02 46.67 E10 Materials & Supplies 107,100.00 104,862.51 0.00 2,237.49 2.09 10-540-520030 Dues And Publications 800.00 702.39 0.00 97.61 12.20 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,150.00 943.09 0.00 206.91 17.99 10-540-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-540-522020 Professional Services 200.00 60.50 0.00 139.50 69.75 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,150.00 1,705.98 0.00 444.02 20.65 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 405.00 320.79 0.00 84.21 20.79 E25 Repairs & Maintenance 405.00 320.79 0.00 84.21 20.79 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 419,142.60 418,355.52 0.00 787.08 0.1878 Grand Total -419,142.60 -418,355.52 0.00 -787.08 0.0019 540 Public Works-Admin 419,142.60 418,355.52 0.00 787.08 0.19 541 Public Works-Engineering 10-541-501020 Salaries 870,271.34 871,704.09 0.00 -1,432.75 -0.16 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 3,709.70 3,709.70 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 63,641.71 0.00 2,192.51 3.33 10-541-502020 Group Health Insurance 132,614.06 139,064.84 0.00 -6,450.78 -4.86 10-541-502030 Retirement 110,153.99 108,974.03 0.00 1,179.96 1.07 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 1,055.09 1,023.30 0.00 31.79 3.01 10-541-502060 Long Term Disability 2,488.48 2,729.85 0.00 -241.37 -9.70 10-541-502070 Employee Assistance Prgm 262.08 260.86 0.00 1.22 0.47 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,192,444.68 1,197,164.10 0.00 -4,719.42 -0.40 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 243.96 116.50 0.00 127.46 52.25 10-541-511020 Postage 400.00 87.80 0.00 312.20 78.05 10-541-512010 Printing 50.00 41.00 0.00 9.00 18.00 10-541-512020 Copies 25.00 0.47 0.00 24.53 98.12 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 1,244.30 0.00 405.70 24.59 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-541-514040 Food 150.00 17.98 0.00 132.02 88.01 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 904.66 0.00 95.34 9.53 10-541-515080 Surveying Supplies 1,500.00 1,039.68 0.00 460.32 30.69 10-541-517010 Operational Supplies 2,000.00 2,081.42 0.00 -81.42 -4.07 E10 Materials & Supplies 7,193.96 5,533.81 0.00 1,660.15 23.08 10-541-520030 Dues And Publications 3,500.00 3,047.00 0.00 453.00 12.94 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,500.00 2,079.00 0.00 421.00 16.84 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 7,000.00 5,126.00 0.00 1,874.00 26.77 10-541-534010 Telephone 500.00 475.89 0.00 24.11 4.82 E20 Utilities 500.00 475.89 0.00 24.11 4.82 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 1,500.00 876.18 0.00 623.82 41.59 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 10-541-547020 Maintenance Agreements 10,665.00 10,478.29 0.00 186.71 1.75 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 12,964.47 0.00 1,200.53 8.48 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,221,303.64 1,221,264.27 0.00 39.37 0.0032 Grand Total -1,221,303.64 -1,221,264.27 0.00 -39.37 0 541 Public Works-Engineering 1,221,303.64 1,221,264.27 0.00 39.37 0.00 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,356,019.10 1,332,293.97 0.00 23,725.13 1.75 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,492.31 20,839.95 0.00 -347.64 -1.70 10-542-501070 Stand-by Plan 8,800.00 9,731.41 0.00 -931.41 -10.58 10-542-501090 Overtime 21,542.08 15,886.53 0.00 5,655.55 26.25 10-542-501095 Overtime Straight Pay 4,665.61 1,905.88 0.00 2,759.73 59.15 10-542-502010 Social Security 109,348.68 101,355.44 0.00 7,993.24 7.31 10-542-502020 Group Health Insurance 304,688.92 264,562.23 0.00 40,126.69 13.17 10-542-502030 Retirement 180,402.50 167,283.70 0.00 13,118.80 7.27 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,684.22 1,532.86 0.00 151.36 8.99 10-542-502060 Long Term Disability 4,165.34 4,087.04 0.00 78.30 1.88 10-542-502070 Employee Assistance Prgm 622.44 613.77 0.00 8.67 1.39 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,051,742.04 1,959,203.62 0.00 92,538.42 4.51 10-542-511010 Advertising 750.00 580.00 0.00 170.00 22.67 10-542-511020 Postage 150.00 12.12 0.00 137.88 91.92 10-542-512010 Printing 94.00 94.00 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,396.00 1,189.71 0.00 206.29 14.78 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 167,529.59 135,261.70 0.00 32,267.89 19.26 10-542-514030 Small Tools 12,362.18 10,073.28 0.00 2,288.90 18.52 10-542-514040 Food 1,637.82 596.58 0.00 1,041.24 63.57 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 275,000.00 347,847.98 0.00 -72,847.98 -26.49 10-542-515040 First Aid Supplies 500.00 399.09 0.00 100.91 20.18 10-542-515060 Weed Control 2,012.41 2,012.41 0.00 0.00 0.00 10-542-515070 Const & Inspect Supplies 200.00 155.71 0.00 44.29 22.15 10-542-517010 Operational Supplies 10,811.47 9,573.55 0.00 1,237.92 11.45 E10 Materials & Supplies 472,453.47 507,796.55 0.00 -35,343.08 -7.48 10-542-520030 Dues And Publications 1,320.00 672.00 0.00 648.00 49.09 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 12,184.40 15,055.63 0.00 -2,871.23 -23.56 10-542-521040 Medical Claimsservices 0.00 60.00 0.00 -60.00 0.00 10-542-522020 Professional Services 13,495.60 10,742.70 0.00 2,752.90 20.40 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 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,200.00 26,530.33 0.00 669.67 2.46 10-542-531010 Electricity 24,364.00 24,146.93 0.00 217.07 0.89 10-542-531020 Street Lights 571,962.00 647,599.75 0.00 -75,637.75 -13.22 10-542-533010 Natural Gas 12,535.38 12,900.90 0.00 -365.52 -2.92 10-542-534010 Telephone 2,780.00 3,084.67 0.00 -304.67 -10.96 10-542-535010 Water 7,654.62 5,097.87 0.00 2,556.75 33.40 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 619,296.00 692,830.12 0.00 -73,534.12 -11.87 10-542-540010 Building & Grounds Maint.11,221.02 12,101.13 0.00 -880.11 -7.84 10-542-541030 Vehicle Wash 7,000.00 6,693.00 0.00 307.00 4.39 10-542-542010 Repairs - StopStreet Lights 26,108.80 19,569.36 0.00 6,539.44 25.05 10-542-542030 Signs & Marking Paint 60,000.00 52,769.61 0.00 7,230.39 12.05 10-542-546010 Clothing Expense 13,000.00 12,809.47 0.00 190.53 1.47 10-542-547010 Equipment Maintenance 1,657.58 809.32 0.00 848.26 51.17 10-542-547020 Maintenance Agreements 681.40 681.40 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 120,668.80 105,433.29 0.00 15,235.51 12.63 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,377.53 0.00 622.47 3.89 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 16,000.00 15,377.53 0.00 622.47 3.89 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,307,360.31 3,307,171.44 0.00 188.87 0.0057 Grand Total -3,307,360.31 -3,307,171.44 0.00 -188.87 0.0001 542 Public Works-Street 3,307,360.31 3,307,171.44 0.00 188.87 0.01 700 Transfers & Subsidies 10-700-590036 Transfer to Sales Tax G (45)599,595.00 599,595.00 0.00 0.00 0.00 10-700-590050 Transfer To Tif Fund 26,328.02 52,725.27 0.00 -26,397.25 -100.26 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 97,015.10 97,015.08 0.00 0.02 0.00 10-700-590075 Transit Subsidy 1,218,542.04 1,218,542.04 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,941,480.16 1,967,877.39 0.00 -26,397.23 -1.36 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,941,480.16 1,967,877.39 0.00 -26,397.23 -1.3596 Grand Total -1,941,480.16 -1,967,877.39 0.00 26,397.23 -0.0136 700 Transfers & Subsidies 1,941,480.16 1,967,877.39 0.00 -26,397.23 -1.36 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 175,000.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 925,000.00 175,000.00 0.00 750,000.00 81.08 10-990-540060 Cemetery Maintenance 30,000.00 7,290.00 0.00 22,710.00 75.70 10-990-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.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 6,992.53 2,975.00 0.00 4,017.53 57.45 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 35,917.60 0.00 0.00 35,917.60 100.00 10-990-576008 Air Streets Stormwater 455,000.00 307,004.00 0.00 147,996.00 32.53 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 125,267.16 118,201.81 0.00 7,065.35 5.64 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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-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 150,000.00 79.75 0.00 149,920.25 99.95 10-990-599505 PD Elevator Replacement 200,000.00 200,000.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 1,500,000.00 931,120.33 0.00 568,879.67 37.93 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 0.00 948,172.75 87.97 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 276,501.00 0.00 8.44 0.00 E75 Capital Projects 5,601,854.16 1,972,826.89 0.00 3,629,027.27 64.78 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 6,526,854.16 2,147,826.89 0.00 4,379,027.27 67.0925 Grand Total -6,526,854.16 -2,147,826.89 0.00 -4,379,027.27 0.6709 990 Capital Projects 6,526,854.16 2,147,826.89 0.00 4,379,027.27 67.09 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-995-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-995-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-995-599511 United Cap City Soccer Complex 0.00 0.00 0.00 0.00 0.00 E65 Other Non-Operating Expenses 0.00 0.00 0.00 0.00 0.00 10-995-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-995-572020 Purchase of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,867,237.71 40,357,225.95 9,902.64 22,500,109.12 35.79 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 62,867,237.71 40,357,225.95 9,902.64 22,500,109.12 35.7899 Grand Total -62,867,237.71 -40,357,225.95 -9,902.64 -22,500,109.12 0.3579 GL - Trial Balance by Acct Type and Full Acct Number (12/19/2023 - 11:15 AM)Page 43