The URL can be used to link to this page

Home My Public Portal About2023-08 NO Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 8/16/2023 2:42:24 PM 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 49,275.00 0.00 16,650.00 25.26 10-110-501015 Salary-Prosecuting Attorney 34,999.92 26,249.94 0.00 8,749.98 25.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)14,598.40 4,967.09 0.00 9,631.31 65.98 10-110-502010 Social Security 8,990.53 5,977.20 0.00 3,013.33 33.52 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 86,540.82 0.00 38,044.62 30.54 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 31.59 0.00 68.41 68.41 10-110-512010 Printing 400.00 273.00 0.00 127.00 31.75 10-110-512020 Copies 96.00 0.29 0.00 95.71 99.70 10-110-513010 Office Supplies 1,435.00 1,753.21 0.00 -318.21 -22.17 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,058.09 0.00 -27.09 -1.33 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 153,784.95 0.00 -153,784.95 0.00 10-110-520025 Security 1,500.00 1,060.22 0.00 439.78 29.32 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 6,854.84 162,217.09 0.00 -155,362.25 -2,266.46 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 92.84 30.95 0.21 0.17 E25 Repairs & Maintenance 124.00 92.84 30.95 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 133,595.28 252,438.72 30.95 -118,874.39 -88.981 Grand Total -133,595.28 -252,438.72 -30.95 118,874.39 -0.8898 110 Mayor & Council 133,595.28 252,438.72 30.95 -118,874.39 -88.98 120 City Clerk 10-120-501020 Salaries 58,320.25 44,309.72 0.00 14,010.53 24.02 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 3,134.05 0.00 1,222.50 28.06 10-120-502020 Group Health Insurance 13,245.50 9,641.85 0.00 3,603.65 27.21 10-120-502030 Retirement 7,289.39 5,671.67 0.00 1,617.72 22.19 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 50.72 0.00 19.05 27.30 10-120-502060 Long Term Disability 174.26 136.29 0.00 37.97 21.79 10-120-502070 Employee Assistance Prgm 21.84 15.33 0.00 6.51 29.81 E05 Personnel Services 83,527.55 63,009.62 0.00 20,517.93 24.56 10-120-511020 Postage 200.00 197.29 0.00 2.71 1.36 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 269.00 0.00 31.00 10.33 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 549.15 0.00 150.85 21.55 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 105.89 0.00 94.11 47.06 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,567.76 0.00 8,687.03 45.12 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,675.00 2,773.82 30.95 7,870.23 73.73 E25 Repairs & Maintenance 10,675.00 2,773.82 30.95 7,870.23 73.73 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 114,622.67 77,365.68 30.95 37,226.04 32.477 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -114,622.67 -77,365.68 -30.95 -37,226.04 0.3248 120 City Clerk 114,622.67 77,365.68 30.95 37,226.04 32.48 140 City Administrator 10-140-501020 Salaries 218,687.56 144,663.93 0.00 74,023.63 33.85 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 8,062.47 0.00 8,248.96 50.57 10-140-502020 Group Health Insurance 21,732.71 12,858.81 0.00 8,873.90 40.83 10-140-502030 Retirement 27,292.33 24,540.57 0.00 2,751.76 10.08 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 103.92 0.00 9.91 8.71 10-140-502060 Long Term Disability 374.04 343.29 0.00 30.75 8.22 10-140-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 284,756.80 190,804.90 0.00 93,951.90 32.99 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 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 52.64 0.00 97.36 64.91 10-140-513010 Office Supplies 525.00 320.86 0.00 204.14 38.88 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,174.27 0.00 -1,570.53 -97.93 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 330.00 0.00 370.00 52.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 182.74 0.00 -182.74 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 38.90 0.00 -38.90 0.00 E15 Contractual Services 2,400.00 1,853.73 0.00 546.27 22.76 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 362.98 120.50 -183.48 -61.16 E25 Repairs & Maintenance 300.00 362.98 120.50 -183.48 -61.16 10-140-572020 Purchase Of Equipment 472.60 472.60 0.00 0.00 0.00 E70 Capital Purchases 472.60 472.60 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 289,533.14 196,668.48 120.50 92,744.16 32.0323 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -289,533.14 -196,668.48 -120.50 -92,744.16 0.3203 140 City Administrator 289,533.14 196,668.48 120.50 92,744.16 32.03 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 182,000.00 0.00 0.00 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 2,031,893.00 0.00 0.00 2,031,893.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,113,169.00 0.00 0.00 2,113,169.00 100 Grand Total -2,113,169.00 0.00 0.00 -2,113,169.00 1 142 Community Revitalization 2,113,169.00 0.00 0.00 2,113,169.00 100.00 143 CDBG-CV Compass Health 10-143-501020 Salaries 11,601.91 3,152.30 0.00 8,449.61 72.83 10-143-502010 Social Security 361.34 215.34 0.00 146.00 40.41 10-143-502020 Group Health Insurance 1,323.00 812.00 0.00 511.00 38.62 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 695.50 403.50 0.00 292.00 41.98 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 4.92 3.69 0.00 1.23 25.00 10-143-502060 Long Term Disability 13.33 10.00 0.00 3.33 24.98 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 4,596.83 0.00 9,403.17 67.17 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 4,596.83 0.00 109,403.17 95.9677 Grand Total -114,000.00 -4,596.83 0.00 -109,403.17 0.9597 143 CDBG-CV Compass Health 114,000.00 4,596.83 0.00 109,403.17 95.97 144 CDBG-DR 10-144-501020 Salaries 262,586.37 25,753.15 0.00 236,833.22 90.19 10-144-502010 Social Security 3,526.27 1,883.60 0.00 1,642.67 46.58 10-144-502020 Group Health Insurance 9,875.25 5,006.92 0.00 4,868.33 49.30 10-144-502030 Retirement 6,250.63 3,296.41 0.00 2,954.22 47.26 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 36.01 30.27 0.00 5.74 15.94 10-144-502060 Long Term Disability 97.47 81.89 0.00 15.58 15.98 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 36,052.24 0.00 246,319.76 87.23 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 36,052.24 0.00 7,273,247.76 99.5068 Grand Total -7,309,300.00 -36,052.24 0.00 -7,273,247.76 0.9951 144 CDBG-DR 7,309,300.00 36,052.24 0.00 7,273,247.76 99.51 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 38,295.11 10,481.71 0.00 27,813.40 72.63 10-145-502010 Social Security 1,205.81 712.23 0.00 493.58 40.93 10-145-502020 Group Health Insurance 3,666.95 2,633.69 0.00 1,033.26 28.18 10-145-502030 Retirement 1,771.85 1,341.66 0.00 430.19 24.28 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 11.60 0.00 1.98 14.58 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 30.79 0.00 2.55 7.65 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 15,220.02 0.00 29,779.98 66.18 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 15,220.02 0.00 1,984,779.98 99.239 Grand Total -2,000,000.00 -15,220.02 0.00 -1,984,779.98 0.9924 145 CDBG-CV Cole Co EMS Station 2,000,000.00 15,220.02 0.00 1,984,779.98 99.24 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 44,066.84 22,802.67 0.00 21,264.17 48.25 10-146-502010 Social Security 2,060.37 1,552.34 0.00 508.03 24.66 10-146-502020 Group Health Insurance 8,016.94 6,058.30 0.00 1,958.64 24.43 10-146-502030 Retirement 3,870.14 2,918.76 0.00 951.38 24.58 10-146-502040 Workers Compensation 9.83 7.37 0.00 2.46 25.03 10-146-502050 Life Insurance 35.19 27.80 0.00 7.39 21.00 10-146-502060 Long Term Disability 94.24 74.48 0.00 19.76 20.97 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 58,153.55 33,441.72 0.00 24,711.83 42.49 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 33,735.66 0.00 665,603.65 95.1761 Grand Total -699,339.31 -33,735.66 0.00 -665,603.65 0.9518 146 HPF-P Bruhn Revitalization 699,339.31 33,735.66 0.00 665,603.65 95.18 147 CDBG-CV Transform Housing 10-147-501020 Salaries 26,883.63 7,198.62 0.00 19,685.01 73.22 10-147-502010 Social Security 868.14 489.24 0.00 378.90 43.65 10-147-502020 Group Health Insurance 2,586.82 1,713.40 0.00 873.42 33.76 10-147-502030 Retirement 1,380.10 921.42 0.00 458.68 33.24 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 7.66 0.00 1.64 17.63 10-147-502060 Long Term Disability 22.85 20.32 0.00 2.53 11.07 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 10,356.38 0.00 21,403.62 67.39 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 10,356.38 0.00 565,403.62 98.2013 Grand Total -575,760.00 -10,356.38 0.00 -565,403.62 0.982 147 CDBG-CV Transform Housing 575,760.00 10,356.38 0.00 565,403.62 98.20 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 20,501.18 0.00 22,950.96 52.82 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 1,460.63 0.00 2,586.28 63.91 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 4,301.52 0.00 8,582.15 66.61 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,133.44 2,624.23 0.00 4,509.21 63.21 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 (08/16/2023 - 02:42 PM)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 23.57 0.00 34.71 59.56 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 62.63 0.00 80.49 56.24 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 23.01 0.00 -1.45 -6.73 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 29,032.58 0.00 38,742.35 57.16 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 106.74 0.00 -36.74 -52.49 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,161.64 0.00 658.36 36.17 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 0.00 0.00 1,025.00 100.00 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 12,500.00 26,010.00 0.00 0.00 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,189.00 0.00 35,811.00 89.53 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 36,185.00 0.00 103,815.00 74.15 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 365,932.02 0.00 0.00 365,932.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 54.00 0.00 39,946.00 99.87 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 958,467.02 365,955.00 26,010.00 566,502.02 59.11 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 (08/16/2023 - 02:42 PM)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 1,028,061.95 396,149.22 26,010.00 605,902.73 58.9364 Grand Total -1,028,061.95 -396,149.22 -26,010.00 -605,902.73 0.5894 149 Entitlement Grant 1,028,061.95 396,149.22 26,010.00 605,902.73 58.94 150 City Attorney 10-150-501020 Salaries 240,166.03 175,103.12 0.00 65,062.91 27.09 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 12,950.31 0.00 4,933.69 27.59 10-150-502020 Group Health Insurance 35,360.71 23,884.79 0.00 11,475.92 32.45 10-150-502030 Retirement 29,923.56 21,595.84 0.00 8,327.72 27.83 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 191.46 0.00 94.96 33.15 10-150-502060 Long Term Disability 607.87 500.37 0.00 107.50 17.68 10-150-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,524.90 234,502.70 0.00 90,022.20 27.74 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 190.96 0.00 409.04 68.17 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 19.88 0.00 -19.88 0.00 10-150-513010 Office Supplies 1,275.00 102.41 0.00 1,172.59 91.97 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 313.25 0.00 1,561.75 83.29 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 7,036.53 2,493.70 1,758.69 15.58 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 4,934.01 0.00 1,320.99 21.12 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,363.35 0.00 3,192.73 70.08 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 56,815.96 0.00 -56,815.96 0.00 E15 Contractual Services 22,600.00 70,514.85 2,493.70 -50,408.55 -223.05 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 317.85 105.95 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 317.85 105.95 -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 349,370.90 305,648.65 2,599.65 41,122.60 11.7705 Grand Total -349,370.90 -305,648.65 -2,599.65 -41,122.60 0.1177 150 City Attorney 349,370.90 305,648.65 2,599.65 41,122.60 11.77 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 26,249.94 0.00 8,749.98 25.00 10-160-501020 Salaries 133,379.83 102,299.91 0.00 31,079.92 23.30 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 4,348.00 0.00 2,652.00 37.89 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 10,016.48 0.00 2,814.87 21.94 10-160-502020 Group Health Insurance 25,616.32 17,132.32 0.00 8,484.00 33.12 10-160-502030 Retirement 16,093.46 13,108.11 0.00 2,985.35 18.55 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 110.95 0.00 42.05 27.48 10-160-502060 Long Term Disability 381.67 297.72 0.00 83.95 22.00 10-160-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 231,719.24 173,914.10 0.00 57,805.14 24.95 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,285.32 0.00 714.68 35.73 10-160-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 2,500.00 578.35 777.95 1,143.70 45.75 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 1,863.67 777.95 2,258.38 46.09 10-160-520025 Security 12,500.00 7,065.37 0.00 5,434.63 43.48 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 480.00 0.00 2,020.00 80.80 10-160-522020 Professional Services 4,500.00 77.81 0.00 4,422.19 98.27 10-160-525005 Appointed Counsel 3,000.00 707.50 0.00 2,292.50 76.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 8,330.68 0.00 14,459.32 63.45 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 (08/16/2023 - 02:42 PM)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 5,827.30 329.10 138.60 2.20 E25 Repairs & Maintenance 6,295.00 5,827.30 329.10 138.60 2.20 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 265,704.24 189,935.75 1,107.05 74,661.44 28.0995 Grand Total -265,704.24 -189,935.75 -1,107.05 -74,661.44 0.281 160 Municipal Court 265,704.24 189,935.75 1,107.05 74,661.44 28.10 170 Human Resources 10-170-501020 Salaries 238,448.92 183,201.40 0.00 55,247.52 23.17 10-170-501050 Parttime(wo Benefits)13,000.00 9,992.41 0.00 3,007.59 23.14 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 14,530.02 0.00 4,013.60 21.64 10-170-502020 Group Health Insurance 25,708.58 18,477.98 0.00 7,230.60 28.13 10-170-502030 Retirement 29,363.23 23,159.48 0.00 6,203.75 21.13 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 202.58 0.00 77.72 27.73 10-170-502060 Long Term Disability 589.14 535.12 0.00 54.02 9.17 10-170-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 326,425.00 250,648.11 0.00 75,776.89 23.21 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 133.35 0.00 166.65 55.55 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 291.80 0.00 208.20 41.64 10-170-513010 Office Supplies 600.00 305.79 0.00 294.21 49.04 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 680.00 65.44 0.00 614.56 90.38 E10 Materials & Supplies 2,930.00 796.38 0.00 2,133.62 72.82 10-170-520030 Dues And Publications 700.00 249.98 0.00 450.02 64.29 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 1,416.71 0.00 1,583.29 52.78 10-170-520070 Training And Education 4,437.00 2,288.63 0.00 2,148.37 48.42 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 432.25 0.00 67.75 13.55 10-170-522020 Professional Services 11,600.00 10,013.21 0.00 1,586.79 13.68 10-170-529010 Special Events 800.00 9.58 0.00 790.42 98.80 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 14,410.36 0.00 6,626.64 31.50 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 51,865.20 120.50 752.91 1.43 E25 Repairs & Maintenance 52,738.61 51,865.20 120.50 752.91 1.43 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 320,895.29 120.50 85,290.06 20.9916 Grand Total -406,305.85 -320,895.29 -120.50 -85,290.06 0.2099 170 Human Resources 406,305.85 320,895.29 120.50 85,290.06 20.99 180 Finance Department 10-180-501020 Salaries 585,933.62 378,682.90 0.00 207,250.72 35.37 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 28,340.79 0.00 15,318.40 35.09 10-180-502020 Group Health Insurance 96,970.17 58,721.59 0.00 38,248.58 39.44 10-180-502030 Retirement 73,050.67 46,443.99 0.00 26,606.68 36.42 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 424.75 0.00 279.05 39.65 10-180-502060 Long Term Disability 1,743.45 1,133.30 0.00 610.15 35.00 10-180-502070 Employee Assistance Prgm 234.78 131.31 0.00 103.47 44.07 10-180-503020 Unemployment Compensation 0.00 200.28 0.00 -200.28 0.00 E05 Personnel Services 802,794.51 514,577.71 0.00 288,216.80 35.90 10-180-511010 Advertising 1,000.00 164.00 0.00 836.00 83.60 10-180-511020 Postage 10,000.00 7,285.29 0.00 2,714.71 27.15 10-180-511021 Mail Machine Cost 3,000.00 1,690.21 0.00 1,309.79 43.66 10-180-512010 Printing 3,000.00 2,020.68 0.00 979.32 32.64 10-180-512020 Copies 1,000.00 23.86 0.00 976.14 97.61 10-180-512021 Copy Machine Cost 190.00 -301.74 181.96 309.78 163.04 10-180-513010 Office Supplies 1,250.00 201.63 0.00 1,048.37 83.87 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 212.56 0.00 3,442.44 94.18 E10 Materials & Supplies 23,095.00 11,296.49 181.96 11,616.55 50.30 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 142.06 0.00 1,812.94 92.73 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,004.36 0.00 2,445.64 44.87 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 38.90 0.00 111.10 74.07 E15 Contractual Services 70,002.71 51,371.20 0.00 18,631.51 26.62 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 13,645.16 312.30 162.54 1.15 E25 Repairs & Maintenance 14,120.00 13,645.16 312.30 162.54 1.15 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 914,222.67 593,813.91 494.26 319,914.50 34.9931 Grand Total -914,222.67 -593,813.91 -494.26 -319,914.50 0.3499 180 Finance Department 914,222.67 593,813.91 494.26 319,914.50 34.99 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 481.75 0.00 3,718.25 88.53 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,553.38 35,040.67 0.00 22,512.71 39.12 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 15,938.46 0.00 4,061.54 20.31 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 16,508.46 0.00 70,873.89 81.11 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 25,000.00 94,912.11 0.00 -69,912.11 -279.65 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,265.00 0.00 299.00 8.39 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 111,800.00 46,791.00 17,697.00 47,312.00 42.32 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 138,750.00 0.00 46,250.00 25.00 10-185-529010 Special Events 5,000.00 2,126.06 0.00 2,873.94 57.48 E15 Contractual Services 873,965.50 783,873.40 17,697.00 72,395.10 8.28 10-185-531010 Electricity 32,000.00 22,922.40 0.00 9,077.60 28.37 10-185-533010 Natural Gas 6,200.00 5,295.66 0.00 904.34 14.59 10-185-535010 Water 7,250.00 5,257.88 0.00 1,992.12 27.48 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 33,475.94 0.00 11,974.06 26.35 10-185-540010 Building & Grounds Maint.15,000.00 42,809.75 0.00 -27,809.75 -185.40 10-185-540015 Amtrak Station 4,000.00 1,810.62 0.00 2,189.38 54.73 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 1,696.00 0.00 364.00 17.67 E25 Repairs & Maintenance 46,060.00 71,316.37 0.00 -25,256.37 -54.83 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 286,222.17 0.00 165,338.59 36.61 E30 Other Operating Expenses 464,360.76 298,421.69 0.00 165,939.07 35.73 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 (08/16/2023 - 02:42 PM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 45,871.97 0.00 -45,871.97 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 45,871.97 0.00 -45,871.97 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,574,771.99 1,284,508.50 17,697.00 272,566.49 17.3083 Grand Total -1,574,771.99 -1,284,508.50 -17,697.00 -272,566.49 0.1731 185 Non-Departmental 1,574,771.99 1,284,508.50 17,697.00 272,566.49 17.31 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 570,896.20 447,490.50 0.00 123,405.70 21.62 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 33,301.82 0.00 13,123.87 28.27 10-190-502020 Group Health Insurance 96,814.24 56,771.51 0.00 40,042.73 41.36 10-190-502030 Retirement 77,679.59 49,025.86 0.00 28,653.73 36.89 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 486.01 0.00 258.18 34.69 10-190-502060 Long Term Disability 1,815.32 1,318.37 0.00 496.95 27.38 10-190-502070 Employee Assistance Prgm 207.48 145.77 0.00 61.71 29.74 E05 Personnel Services 796,440.92 589,898.05 0.00 206,542.87 25.93 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 8.27 0.00 1.73 17.30 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 439.86 0.00 60.14 12.03 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 (08/16/2023 - 02:42 PM)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,079.50 0.00 -1,079.50 -53.98 E10 Materials & Supplies 2,660.00 3,581.63 0.00 -921.63 -34.65 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,600.89 0.00 2,399.11 5.45 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 18,878.22 0.00 4,121.78 17.92 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 68,835.72 0.00 11,214.28 14.01 10-190-534010 Telephone 96,000.00 63,618.89 0.00 32,381.11 33.73 E20 Utilities 96,000.00 63,618.89 0.00 32,381.11 33.73 10-190-545010 Software License\maint 197,000.00 190,391.90 1,080.00 5,528.10 2.81 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,516.76 104.10 2,379.14 10.81 10-190-547025 Coun Chamber MediaEquip Repr 0.00 273.06 0.00 -273.06 0.00 E25 Repairs & Maintenance 219,000.00 210,181.72 1,184.10 7,634.18 3.49 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,194,150.92 936,116.01 1,184.10 256,850.81 21.5091 Grand Total -1,194,150.92 -936,116.01 -1,184.10 -256,850.81 0.2151 190 Information Technology Svcs 1,194,150.92 936,116.01 1,184.10 256,850.81 21.51 300 Police Department 10-300-501020 Salaries 5,510,756.15 3,863,734.31 0.00 1,647,021.84 29.89 10-300-501030 Holiday Pay 162,165.48 116,981.39 0.00 45,184.09 27.86 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 23,300.03 0.00 22,557.98 49.19 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 8,541.68 0.00 -3,541.68 -70.83 10-300-501090 Overtime 304,257.77 317,360.11 0.00 -13,102.34 -4.31 10-300-501095 Overtime Straight Pay 13,275.00 13,528.38 0.00 -253.38 -1.91 10-300-502010 Social Security 444,750.67 316,651.59 0.00 128,099.08 28.80 10-300-502020 Group Health Insurance 960,547.52 639,738.71 0.00 320,808.81 33.40 10-300-502030 Retirement 1,009,334.34 736,677.47 0.00 272,656.87 27.01 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 (08/16/2023 - 02:42 PM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 4,351.04 0.00 2,191.24 33.49 10-300-502060 Long Term Disability 15,894.91 11,633.28 0.00 4,261.63 26.81 10-300-502070 Employee Assistance Prgm 1,960.14 1,388.70 0.00 571.44 29.15 10-300-503010 Awards Program 2,500.00 687.00 0.00 1,813.00 72.52 10-300-503020 Unemployment Compensation 0.00 863.52 0.00 -863.52 0.00 E05 Personnel Services 8,598,120.51 6,130,523.15 0.00 2,467,597.36 28.70 10-300-511010 Advertising 5,665.00 4,319.80 0.00 1,345.20 23.75 10-300-511020 Postage 1,395.00 1,068.67 0.00 326.33 23.39 10-300-512010 Printing 5,952.00 2,728.40 0.00 3,223.60 54.16 10-300-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 15,365.68 0.00 304.82 1.95 10-300-514010 Gas 188,862.00 146,729.72 0.00 42,132.28 22.31 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 765.53 0.00 -114.53 -17.59 10-300-515040 First Aid Supplies 1,378.00 1,584.03 0.00 -206.03 -14.95 10-300-516010 Ammunition & Firearms Supplies 63,136.25 57,359.96 4,822.56 953.73 1.51 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)0.00 255.00 0.00 -255.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 43,181.40 3,543.36 -446.76 -0.97 E10 Materials & Supplies 344,272.75 284,458.26 8,365.92 51,448.57 14.94 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 76,000.00 67,511.45 0.00 8,488.55 11.17 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 1,330.74 0.00 -43.74 -3.40 10-300-521040 Medical Claimsservices 6,510.00 6,665.20 0.00 -155.20 -2.38 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 17,005.14 0.00 -1,005.14 -6.28 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 44,836.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 655.56 0.00 1,390.44 67.96 E15 Contractual Services 193,454.00 172,696.50 0.00 20,757.50 10.73 10-300-531010 Electricity 44,640.00 26,452.01 0.00 18,187.99 40.74 10-300-533010 Natural Gas 1,116.00 505.75 0.00 610.25 54.68 10-300-534010 Telephone 24,101.00 21,396.21 0.00 2,704.79 11.22 10-300-535010 Water 3,348.00 3,287.69 0.00 60.31 1.80 E20 Utilities 73,205.00 51,641.66 0.00 21,563.34 29.46 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 100,983.05 200.00 -63,983.05 -172.00 10-300-541030 Vehicle Wash 9,752.00 8,476.00 0.00 1,276.00 13.08 10-300-544010 K-9 Operations 16,740.00 10,914.83 880.36 4,944.81 29.54 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 25,882.23 0.00 2,067.77 7.40 10-300-545010 Software License\maint 82,414.00 64,645.16 0.00 17,768.84 21.56 10-300-546010 Clothing Expense 48,920.00 20,244.65 130.50 28,544.85 58.35 10-300-546020 Uniform Cleaning 23,715.00 22,266.10 0.00 1,448.90 6.11 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 39,207.84 6,114.00 10,926.16 19.42 10-300-547030 Radio Maintenance 8,025.00 108.52 0.00 7,916.48 98.65 E25 Repairs & Maintenance 320,964.00 294,086.20 7,324.86 19,552.94 6.09 10-300-572010 Purchase Of Vehicles 46,849.80 46,832.80 0.00 17.00 0.04 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 17,130.00 20,032.93 53.91 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 13,538.67 0.00 12,992.32 546.35 4.04 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 409,301.40 238,582.80 30,122.32 140,596.28 34.35 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 9,939,317.66 7,171,988.57 45,813.10 2,721,515.99 27.3813 Grand Total -9,939,317.66 -7,171,988.57 -45,813.10 -2,721,515.99 0.2738 300 Police Department 9,939,317.66 7,171,988.57 45,813.10 2,721,515.99 27.38 310 School Resource Officer 10-310-501020 Salaries 489,893.97 305,597.29 0.00 184,296.68 37.62 10-310-501030 Holiday Pay 20,720.19 256.24 0.00 20,463.95 98.76 10-310-501090 Overtime 45,106.00 69,547.43 0.00 -24,441.43 -54.19 10-310-501095 Overtime Straight Pay 1,311.00 2,099.20 0.00 -788.20 -60.12 10-310-502010 Social Security 42,612.88 27,256.76 0.00 15,356.12 36.04 10-310-502020 Group Health Insurance 89,715.43 56,609.58 0.00 33,105.85 36.90 10-310-502030 Retirement 100,265.61 67,950.07 0.00 32,315.54 32.23 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 343.26 0.00 260.17 43.12 10-310-502060 Long Term Disability 1,498.63 921.07 0.00 577.56 38.54 10-310-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 E05 Personnel Services 798,454.72 537,256.52 0.00 261,198.20 32.71 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 2,775.44 0.00 12,569.56 81.91 10-310-517010 Operational Supplies 6,995.00 0.00 1,181.12 5,813.88 83.11 E10 Materials & Supplies 22,340.00 2,775.44 1,181.12 18,383.44 82.29 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,974.00 147.11 0.00 5,826.89 97.54 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 1,002.30 104.10 -746.40 -207.33 E25 Repairs & Maintenance 6,334.00 1,149.41 104.10 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 542,256.37 1,285.22 288,237.13 34.6531 Grand Total -831,778.72 -542,256.37 -1,285.22 -288,237.13 0.3465 310 School Resource Officer 831,778.72 542,256.37 1,285.22 288,237.13 34.65 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 97,639.56 0.00 29,967.40 23.48 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 28,730.49 0.00 687.73 2.34 10-320-501095 Overtime Straight Pay 0.00 1,160.02 0.00 -1,160.02 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 9,265.54 0.00 1,771.64 16.05 10-320-502020 Group Health Insurance 20,462.81 14,860.75 0.00 5,602.06 27.38 10-320-502030 Retirement 25,969.83 22,955.41 0.00 3,014.42 11.61 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 109.49 0.00 45.96 29.57 10-320-502060 Long Term Disability 384.75 292.15 0.00 92.60 24.07 10-320-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 222,402.83 177,048.49 0.00 45,354.34 20.39 10-320-514010 Gas 11,848.00 6,943.56 0.00 4,904.44 41.39 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 7,708.40 0.00 7,397.60 48.97 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 15,251.96 0.00 16,896.32 52.56 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 17,500.00 9,300.00 0.00 8,200.00 46.86 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 9,300.00 0.00 8,200.00 46.86 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 272,051.11 201,600.45 0.00 70,450.66 25.8961 Grand Total -272,051.11 -201,600.45 0.00 -70,450.66 0.259 320 M.U.S.T.A.N.G.272,051.11 201,600.45 0.00 70,450.66 25.90 330 Animal Control 10-330-501020 Salaries 381,537.88 250,477.26 0.00 131,060.62 34.35 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 6,141.09 0.00 2,458.91 28.59 10-330-501090 Overtime 2,000.00 10,263.63 0.00 -8,263.63 -413.18 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 18,305.24 0.00 10,817.63 37.14 10-330-502020 Group Health Insurance 93,298.71 58,513.65 0.00 34,785.06 37.28 10-330-502030 Retirement 48,728.46 32,434.66 0.00 16,293.80 33.44 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 (08/16/2023 - 02:42 PM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 271.78 0.00 184.77 40.47 10-330-502060 Long Term Disability 1,117.06 754.02 0.00 363.04 32.50 10-330-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 569,717.33 381,965.17 0.00 187,752.16 32.96 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 62.00 0.00 90.00 59.21 10-330-512010 Printing 1,860.00 898.59 0.00 961.41 51.69 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 270.73 0.00 1,010.27 78.87 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 163.83 0.00 59.17 26.53 10-330-515040 First Aid Supplies 295.00 355.95 0.00 -60.95 -20.66 10-330-517010 Operational Supplies 11,000.00 5,343.49 0.00 5,656.51 51.42 E10 Materials & Supplies 15,716.00 7,094.59 0.00 8,621.41 54.86 10-330-520030 Dues And Publications 900.00 56.35 0.00 843.65 93.74 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-330-521040 Medical Claimsservices 690.00 421.60 0.00 268.40 38.90 10-330-522020 Professional Services 3,361.00 1,373.20 0.00 1,987.80 59.14 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,708.00 3,024.72 0.00 683.28 18.43 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 14,239.00 9,455.87 0.00 4,783.13 33.59 10-330-531010 Electricity 22,789.00 20,311.82 0.00 2,477.18 10.87 10-330-533010 Natural Gas 21,000.00 20,788.17 0.00 211.83 1.01 10-330-534010 Telephone 810.00 686.19 0.00 123.81 15.29 10-330-535010 Water 3,800.00 3,062.96 0.00 737.04 19.40 E20 Utilities 48,399.00 44,849.14 0.00 3,549.86 7.33 10-330-540010 Building & Grounds Maint.15,000.00 18,357.89 0.00 -3,357.89 -22.39 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 43,465.52 0.00 5,324.48 10.91 10-330-544050 Animal Food 6,103.00 3,570.70 0.00 2,532.30 41.49 10-330-545010 Software Licensemaint 3,191.00 2,720.07 0.00 470.93 14.76 10-330-546010 Clothing Expense 2,025.00 1,827.64 0.00 197.36 9.75 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 360.00 312.30 104.10 -56.40 -15.67 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 (08/16/2023 - 02:42 PM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 1,750.00 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 78,074.00 72,880.12 104.10 5,089.78 6.52 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 768,840.33 558,939.89 104.10 209,796.34 27.2874 Grand Total -768,840.33 -558,939.89 -104.10 -209,796.34 0.2729 330 Animal Control 768,840.33 558,939.89 104.10 209,796.34 27.29 390 9-1-1 Police 10-390-501020 Salaries 1,068,038.89 666,609.97 0.00 401,428.92 37.59 10-390-501030 Holiday Pay 38,718.75 27,402.44 0.00 11,316.31 29.23 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 0.00 11,881.69 0.00 -11,881.69 0.00 10-390-501090 Overtime 22,814.00 93,292.54 0.00 -70,478.54 -308.93 10-390-501095 Overtime Straight Pay 1,850.00 3,492.38 0.00 -1,642.38 -88.78 10-390-502010 Social Security 87,556.95 58,999.58 0.00 28,557.37 32.62 10-390-502020 Group Health Insurance 223,648.25 123,017.63 0.00 100,630.62 45.00 10-390-502030 Retirement 152,546.30 86,299.74 0.00 66,246.56 43.43 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 731.54 0.00 601.40 45.12 10-390-502060 Long Term Disability 3,302.13 1,952.99 0.00 1,349.14 40.86 10-390-502070 Employee Assistance Prgm 480.48 326.07 0.00 154.41 32.14 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,603,008.65 1,076,726.53 0.00 526,282.12 32.83 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 4,728.11 0.00 2,071.89 30.47 E10 Materials & Supplies 8,200.00 4,728.11 0.00 3,471.89 42.34 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 2,204.93 0.00 3,445.07 60.97 10-390-522020 Professional Services 4,300.00 4,016.47 0.00 283.53 6.59 10-390-523010 Equipment Rentlease 99,260.00 46,859.76 0.00 52,400.24 52.79 E15 Contractual Services 109,768.00 53,081.16 0.00 56,686.84 51.64 10-390-531010 Electricity 11,160.00 13,437.10 0.00 -2,277.10 -20.40 10-390-533010 Natural Gas 279.00 361.79 0.00 -82.79 -29.67 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 1,026.88 0.00 -189.88 -22.69 E20 Utilities 12,276.00 14,825.77 0.00 -2,549.77 -20.77 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 5,580.00 97.79 0.00 5,482.21 98.25 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 12,744.07 0.00 -8,544.07 -203.43 10-390-547020 Maintenance Agreements 75,000.00 71,803.16 192.66 3,004.18 4.01 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 133,197.87 192.66 10,215.47 7.11 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,876,858.65 1,282,559.44 192.66 594,106.55 31.6543 Grand Total -1,876,858.65 -1,282,559.44 -192.66 -594,106.55 0.3165 390 9-1-1 Police 1,876,858.65 1,282,559.44 192.66 594,106.55 31.65 400 Fire Department 10-400-501020 Salaries 4,763,879.64 3,188,525.05 0.00 1,575,354.59 33.07 10-400-501025 Other Hours 0.00 1,756.58 0.00 -1,756.58 0.00 10-400-501030 Holiday Pay 341,978.12 308,418.25 0.00 33,559.87 9.81 10-400-501035 Training & Essential Functions 0.00 12,444.01 0.00 -12,444.01 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 28,440.73 0.00 9,559.27 25.16 10-400-501090 Overtime-FLSA 48,689.59 146,583.81 0.00 -97,894.22 -201.06 10-400-501092 Overtime-Constant Staffing 0.00 23,566.99 0.00 -23,566.99 0.00 10-400-501095 Overtime Straight Pay 36,310.41 37,845.08 0.00 -1,534.67 -4.23 10-400-502010 Social Security 69,573.39 53,627.83 0.00 15,945.56 22.92 10-400-502020 Group Health Insurance 877,737.91 622,144.22 0.00 255,593.69 29.12 10-400-502030 Retirement 2,292,378.67 1,811,229.90 0.00 481,148.77 20.99 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 3,573.26 0.00 1,495.32 29.50 10-400-502060 Long Term Disability 12,419.68 9,507.25 0.00 2,912.43 23.45 10-400-502070 Employee Assistance Prgm 1,681.68 1,166.19 0.00 515.49 30.65 10-400-503010 Awards Program 1,194.49 244.35 0.00 950.14 79.54 E05 Personnel Services 8,641,943.11 6,402,104.45 0.00 2,239,838.66 25.92 10-400-511010 Advertising 300.00 277.50 0.00 22.50 7.50 10-400-511020 Postage 320.00 302.96 0.00 17.04 5.33 10-400-512010 Printing 834.12 834.12 0.00 0.00 0.00 10-400-512020 Copies 50.00 0.14 0.00 49.86 99.72 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,359.45 0.00 35.55 2.55 10-400-514010 Gas 61,175.00 58,602.24 0.00 2,572.76 4.21 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 (08/16/2023 - 02:42 PM)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 1,893.17 0.00 206.83 9.85 10-400-517010 Operational Supplies 18,000.00 12,296.19 0.00 5,703.81 31.69 E10 Materials & Supplies 90,740.00 81,831.33 0.00 8,908.67 9.82 10-400-520030 Dues And Publications 3,400.00 2,502.04 0.00 897.96 26.41 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 32,000.00 30,885.31 0.00 1,114.69 3.48 10-400-520080 Tuition Reimbursement 7,500.00 10,701.00 0.00 -3,201.00 -42.68 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 1,000.00 660.00 0.00 340.00 34.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,405.51 5,405.51 0.00 0.00 0.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 96,450.31 95,385.66 0.00 1,064.65 1.10 10-400-531010 Electricity 34,000.00 26,512.24 0.00 7,487.76 22.02 10-400-533010 Natural Gas 20,922.45 21,297.08 0.00 -374.63 -1.79 10-400-534010 Telephone 25,731.75 20,066.17 0.00 5,665.58 22.02 10-400-535010 Water 10,000.00 9,025.60 0.00 974.40 9.74 E20 Utilities 90,654.20 76,901.09 0.00 13,753.11 15.17 10-400-540010 Building & Grounds Maint.90,000.00 44,020.26 21,240.00 24,739.74 27.49 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 92,548.20 80,057.76 0.00 12,490.44 13.50 10-400-546020 Uniform Cleaning 500.00 370.20 0.00 129.80 25.96 10-400-547010 Equipment Maintenance 20,000.00 13,654.19 0.00 6,345.81 31.73 10-400-547020 Maintenance Agreements 39,487.50 30,597.39 787.90 8,102.21 20.52 10-400-547030 Radio Maintenance 20,925.00 10,243.26 0.00 10,681.74 51.05 E25 Repairs & Maintenance 263,460.70 178,943.06 22,027.90 62,489.74 23.72 10-400-572010 Purchase Of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 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 220.11 0.00 1,279.89 85.33 10-400-572021 Purchase of Equipment-ONE TIME 163,699.68 120,544.82 41,069.50 2,085.36 1.27 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 232,655.68 168,812.86 58,303.92 5,538.90 2.38 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,415,904.00 7,003,978.45 80,331.82 2,331,593.73 24.7623 Grand Total -9,415,904.00 -7,003,978.45 -80,331.82 -2,331,593.73 0.2476 400 Fire Department 9,415,904.00 7,003,978.45 80,331.82 2,331,593.73 24.76 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,634.46 0.00 65.54 3.86 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 12.74 0.00 -12.74 0.00 E20 Utilities 1,700.00 1,647.20 0.00 52.80 3.11 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,700.00 1,647.20 0.00 52.80 3.1059 Grand Total -1,700.00 -1,647.20 0.00 -52.80 0.0311 401 Fire Museum 1,700.00 1,647.20 0.00 52.80 3.11 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 240,970.33 193,932.65 0.00 47,037.68 19.52 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 14,224.85 0.00 4,150.87 22.59 10-520-502020 Group Health Insurance 52,232.32 33,960.46 0.00 18,271.86 34.98 10-520-502030 Retirement 30,746.30 22,398.05 0.00 8,348.25 27.15 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 185.57 0.00 110.64 37.35 10-520-502060 Long Term Disability 636.77 482.53 0.00 154.24 24.22 10-520-502070 Employee Assistance Prgm 87.36 46.02 0.00 41.34 47.32 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 343,541.91 265,427.03 0.00 78,114.88 22.74 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 33.27 0.00 41.73 55.64 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 439.70 0.00 410.30 48.27 10-520-514010 Gas 12,975.00 11,017.53 0.00 1,957.47 15.09 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,214.04 0.00 -714.04 -142.81 E10 Materials & Supplies 14,500.00 13,727.12 0.00 772.88 5.33 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 3,000.00 4,035.45 0.00 -1,035.45 -34.52 E15 Contractual Services 6,000.00 5,174.51 0.00 825.49 13.76 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 (08/16/2023 - 02:42 PM)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 29,089.01 32,135.03 272.70 -3,318.72 -11.41 E25 Repairs & Maintenance 29,089.01 32,135.03 272.70 -3,318.72 -11.41 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 393,130.92 316,463.69 272.70 76,394.53 19.4323 Grand Total -393,130.92 -316,463.69 -272.70 -76,394.53 0.1943 520 Plan & Protect Svcs-Admin 393,130.92 316,463.69 272.70 76,394.53 19.43 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 57,618.37 78,108.40 0.00 -20,490.03 -35.56 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 5,836.41 0.00 -1,903.64 -48.40 10-521-502020 Group Health Insurance 9,239.72 12,715.40 0.00 -3,475.68 -37.62 10-521-502030 Retirement 6,580.32 9,997.70 0.00 -3,417.38 -51.93 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 87.81 0.00 -25.39 -40.68 10-521-502060 Long Term Disability 156.03 234.20 0.00 -78.17 -50.10 10-521-502070 Employee Assistance Prgm 15.29 41.43 0.00 -26.14 -170.96 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,763.27 107,179.70 0.00 -29,416.43 -37.83 10-521-511010 Advertising 3,336.00 2,691.95 0.00 644.05 19.31 10-521-511020 Postage 500.00 252.35 0.00 247.65 49.53 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 202.72 0.00 597.28 74.66 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 4,347.21 0.00 1,988.79 31.39 10-521-520030 Dues And Publications 14,032.68 14,032.68 0.00 0.00 0.00 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,212.68 0.00 507.32 3.45 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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,017.32 182.25 71.43 5.62 E25 Repairs & Maintenance 1,271.00 1,017.32 182.25 71.43 5.62 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 100,090.27 126,756.91 182.25 -26,848.89 -26.8247 Grand Total -100,090.27 -126,756.91 -182.25 26,848.89 -0.2682 521 Plan & Protect Svcs-Planning 100,090.27 126,756.91 182.25 -26,848.89 -26.82 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 131,978.86 61,044.68 0.00 70,934.18 53.75 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 4,614.82 0.00 5,359.86 53.73 10-522-502020 Group Health Insurance 20,902.54 8,284.58 0.00 12,617.96 60.37 10-522-502030 Retirement 16,689.66 7,813.88 0.00 8,875.78 53.18 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 69.39 0.00 91.65 56.91 10-522-502060 Long Term Disability 397.13 185.05 0.00 212.08 53.40 10-522-502070 Employee Assistance Prgm 50.23 35.28 0.00 14.95 29.76 E05 Personnel Services 180,256.69 82,150.23 0.00 98,106.46 54.43 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 0.00 0.00 1,000.00 100.00 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 920.43 0.00 79.57 7.96 E10 Materials & Supplies 5,600.00 2,217.04 0.00 3,382.96 60.41 10-522-520030 Dues And Publications 1,500.00 1,435.73 0.00 64.27 4.28 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 36,410.00 16,508.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 37,845.73 16,508.60 34,645.67 38.93 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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,143.58 161.63 1,094.79 45.62 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,143.58 161.63 1,094.79 45.62 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 123,356.58 16,670.23 140,629.88 50.1074 Grand Total -280,656.69 -123,356.58 -16,670.23 -140,629.88 0.5011 522 Plan & Protect Svcs-MPO 280,656.69 123,356.58 16,670.23 140,629.88 50.11 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 63,767.96 34,410.44 0.00 29,357.52 46.04 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 8,696.19 2,527.45 0.00 6,168.74 70.94 10-530-502020 Group Health Insurance 25,767.93 5,464.19 0.00 20,303.74 78.79 10-530-502030 Retirement 14,550.48 4,002.75 0.00 10,547.73 72.49 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 33.97 0.00 106.47 75.81 10-530-502060 Long Term Disability 344.86 87.63 0.00 257.23 74.59 10-530-502070 Employee Assistance Prgm 51.96 10.22 0.00 41.74 80.33 E05 Personnel Services 113,406.12 46,624.52 0.00 66,781.60 58.89 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 120.57 0.00 29.43 19.62 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 14.35 0.00 95.65 86.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 377.04 0.00 202.96 34.99 E10 Materials & Supplies 1,380.00 717.71 0.00 662.29 47.99 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,022.19 0.00 -127.01 -6.70 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 0.00 0.00 33,334.00 100.00 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 12,240.99 0.00 6,759.01 35.57 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 0.00 0.00 27,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 24,987.88 0.00 66,846.12 72.79 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 540.47 93.73 37.82 5.63 E25 Repairs & Maintenance 672.02 540.47 93.73 37.82 5.63 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 22,975.24 0.00 0.00 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 92.20 0.00 1,076.81 92.11 10-530-550039 Historic Preservation Grant 50,000.00 67.50 0.00 49,932.50 99.87 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 46,281.22 22,975.24 75,725.06 52.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 352,273.66 119,151.80 23,068.97 210,052.89 59.6278 Grand Total -352,273.66 -119,151.80 -23,068.97 -210,052.89 0.5963 530 Plan & Protect Svc-RedevGrant 352,273.66 119,151.80 23,068.97 210,052.89 59.63 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 (08/16/2023 - 02:42 PM)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 207,768.04 148,762.10 0.00 59,005.94 28.40 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 10,606.89 0.00 4,301.42 28.85 10-532-502020 Group Health Insurance 39,644.71 27,996.02 0.00 11,648.69 29.38 10-532-502030 Retirement 24,944.62 19,041.52 0.00 5,903.10 23.66 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 144.91 0.00 93.77 39.29 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 434.86 0.00 157.80 26.63 10-532-502070 Employee Assistance Prgm 65.52 63.92 0.00 1.60 2.44 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 291,915.96 210,803.64 0.00 81,112.32 27.79 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 75.12 0.00 74.88 49.92 10-532-512010 Printing 20.00 293.00 0.00 -273.00 -1,365.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 411.17 0.00 888.83 68.37 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 355.99 0.00 644.01 64.40 E10 Materials & Supplies 2,625.00 1,135.28 0.00 1,489.72 56.75 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,600.00 151,278.00 50,400.00 -78.00 -0.04 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 204,100.00 152,550.90 50,400.00 1,149.10 0.56 10-532-534010 Telephone 1,200.00 989.76 0.00 210.24 17.52 E20 Utilities 1,200.00 989.76 0.00 210.24 17.52 10-532-540060 Cemetery Maintenance 37,750.00 27,823.39 9,189.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 560.42 0.00 519.58 48.11 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 973.98 253.45 -317.43 -34.88 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 30,641.79 9,442.45 985.76 2.40 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 (08/16/2023 - 02:42 PM)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 540,910.96 396,121.37 59,842.45 84,947.14 15.7045 Grand Total -540,910.96 -396,121.37 -59,842.45 -84,947.14 0.157 532 Plan & Protect Svcs-Env Health 540,910.96 396,121.37 59,842.45 84,947.14 15.70 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 170,055.53 146,675.33 0.00 23,380.20 13.75 10-533-501050 Parttime(wo Benefits)20,000.00 20,187.35 0.00 -187.35 -0.94 10-533-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,138.32 12,617.79 0.00 1,520.53 10.75 10-533-502020 Group Health Insurance 30,239.78 18,999.80 0.00 11,239.98 37.17 10-533-502030 Retirement 21,096.27 15,723.60 0.00 5,372.67 25.47 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 136.21 0.00 67.60 33.17 10-533-502060 Long Term Disability 505.89 377.19 0.00 128.70 25.44 10-533-502070 Employee Assistance Prgm 65.52 40.91 0.00 24.61 37.56 E05 Personnel Services 258,562.50 217,015.56 0.00 41,546.94 16.07 10-533-511010 Advertising 100.00 205.63 0.00 -105.63 -105.63 10-533-511020 Postage 1,800.00 1,506.81 0.00 293.19 16.29 10-533-512010 Printing 300.00 194.00 0.00 106.00 35.33 10-533-512020 Copies 0.00 0.04 0.00 -0.04 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 968.91 0.00 31.09 3.11 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 1,084.07 0.00 265.93 19.70 E10 Materials & Supplies 4,690.00 3,959.46 0.00 730.54 15.58 10-533-520030 Dues And Publications 500.00 220.44 0.00 279.56 55.91 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 1,013.47 0.00 186.53 15.54 10-533-520080 Tuition Reimbursement 0.00 5,082.50 0.00 -5,082.50 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 0.00 23,502.80 0.00 -23,502.80 0.00 10-533-522022 Demo 259,433.60 119,072.12 58,566.88 81,794.60 31.53 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 339,591.15 192,671.33 58,566.88 88,352.94 26.02 10-533-534010 Telephone 3,701.40 2,893.76 0.00 807.64 21.82 E20 Utilities 3,701.40 2,893.76 0.00 807.64 21.82 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)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 849.43 0.00 430.57 33.64 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 1,051.03 229.95 -9.98 -0.78 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 2,170.46 229.95 450.59 15.80 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 609,396.05 418,710.57 58,796.83 131,888.65 21.6425 Grand Total -609,396.05 -418,710.57 -58,796.83 -131,888.65 0.2164 533 PPS - Prop MaintCode Enforce 609,396.05 418,710.57 58,796.83 131,888.65 21.64 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 314,201.68 238,388.46 0.00 75,813.22 24.13 10-534-501050 Parttime(wo Benefits)15,900.00 9,243.93 0.00 6,656.07 41.86 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 17,394.54 0.00 7,193.15 29.26 10-534-502020 Group Health Insurance 79,982.22 57,944.00 0.00 22,038.22 27.55 10-534-502030 Retirement 39,104.99 30,513.60 0.00 8,591.39 21.97 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 272.26 0.00 102.28 27.31 10-534-502060 Long Term Disability 929.35 726.99 0.00 202.36 21.77 10-534-502070 Employee Assistance Prgm 109.20 92.07 0.00 17.13 15.69 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 479,945.74 359,331.92 0.00 120,613.82 25.13 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 196.57 0.00 903.43 82.13 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 241.80 0.00 658.20 73.13 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 491.73 0.00 1,308.27 72.68 E10 Materials & Supplies 4,115.00 930.10 0.00 3,184.90 77.40 10-534-520030 Dues And Publications 2,500.00 734.00 0.00 1,766.00 70.64 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 5,910.99 0.00 -910.99 -18.22 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 (08/16/2023 - 02:42 PM)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 6,644.99 0.00 855.01 11.40 10-534-534010 Telephone 3,060.00 2,258.80 0.00 801.20 26.18 E20 Utilities 3,060.00 2,258.80 0.00 801.20 26.18 10-534-541030 Vehicle Wash 270.00 290.00 0.00 -20.00 -7.41 10-534-546010 Clothing Expense 1,400.00 931.00 0.00 469.00 33.50 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 893.04 128.28 -33.32 -3.37 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,119.04 128.28 430.68 16.08 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 497,298.74 371,284.85 128.28 125,885.61 25.3139 Grand Total -497,298.74 -371,284.85 -128.28 -125,885.61 0.2531 534 Plan & Protect Svcs-Bldg Regs 497,298.74 371,284.85 128.28 125,885.61 25.31 535 Public Works-Central Maintenan 10-535-501020 Salaries 413,657.31 309,590.86 0.00 104,066.45 25.16 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 1,812.54 0.00 2,687.46 59.72 10-535-501095 Overtime Straight Pay 500.00 107.59 0.00 392.41 78.48 10-535-502010 Social Security 30,175.52 22,770.97 0.00 7,404.55 24.54 10-535-502020 Group Health Insurance 79,635.09 58,108.55 0.00 21,526.54 27.03 10-535-502030 Retirement 49,977.76 39,873.35 0.00 10,104.41 20.22 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 343.43 0.00 129.03 27.31 10-535-502060 Long Term Disability 1,177.64 920.82 0.00 256.82 21.81 10-535-502070 Employee Assistance Prgm 152.88 107.40 0.00 45.48 29.75 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 588,718.02 438,104.87 0.00 150,613.15 25.58 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 2.37 0.00 47.63 95.26 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 819.02 0.00 180.98 18.10 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 5,000.00 1,437.53 0.00 3,562.47 71.25 10-535-517010 Operational Supplies 7,000.00 6,381.15 0.00 618.85 8.84 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,140.00 8,656.57 0.00 4,483.43 34.12 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 1,100.00 189.90 0.00 910.10 82.74 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,950.00 380.90 0.00 1,569.10 80.47 10-535-531010 Electricity 6,560.00 4,720.36 0.00 1,839.64 28.04 10-535-533010 Natural Gas 3,200.00 3,187.73 0.00 12.27 0.38 10-535-534010 Telephone 420.00 345.69 0.00 74.31 17.69 10-535-535010 Water 1,442.00 937.98 0.00 504.02 34.95 E20 Utilities 11,622.00 9,191.76 0.00 2,430.24 20.91 10-535-540010 Building & Grounds Maint.10,000.00 9,310.60 17.50 671.90 6.72 10-535-541010 Veh & Equip Parts Etc 393,400.00 325,479.02 15,567.13 52,353.85 13.31 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 10,700.00 10,494.10 0.00 205.90 1.92 10-535-547010 Equipment Maintenance 1,000.00 294.19 94.73 611.08 61.11 10-535-547020 Maintenance Agreements 15,551.00 13,295.51 104.10 2,151.39 13.83 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 358,873.42 15,783.46 56,094.12 13.02 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,046,181.02 815,207.52 15,783.46 215,190.04 20.5691 Grand Total -1,046,181.02 -815,207.52 -15,783.46 -215,190.04 0.2057 535 Public Works-Central Maintenan 1,046,181.02 815,207.52 15,783.46 215,190.04 20.57 540 Public Works-Admin 10-540-501020 Salaries 246,836.90 188,618.28 0.00 58,218.62 23.59 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 14,394.93 0.00 3,654.07 20.25 10-540-502020 Group Health Insurance 20,506.66 14,055.08 0.00 6,451.58 31.46 10-540-502030 Retirement 30,199.64 22,884.66 0.00 7,314.98 24.22 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 196.89 0.00 93.20 32.13 10-540-502060 Long Term Disability 569.01 507.35 0.00 61.66 10.84 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 316,736.05 240,922.44 0.00 75,813.61 23.94 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 (08/16/2023 - 02:42 PM)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.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 126.17 0.00 873.83 87.38 10-540-514010 Gas 104,350.00 70,888.96 0.00 33,461.04 32.07 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 79.99 0.00 220.01 73.34 E10 Materials & Supplies 107,100.00 72,170.92 0.00 34,929.08 32.61 10-540-520030 Dues And Publications 800.00 684.40 0.00 115.60 14.45 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 349.00 0.00 801.00 69.65 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,093.90 0.00 1,056.10 49.12 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 278.13 42.63 84.24 20.80 E25 Repairs & Maintenance 405.00 278.13 42.63 84.24 20.80 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 426,391.05 314,465.39 42.63 111,883.03 26.2395 Grand Total -426,391.05 -314,465.39 -42.63 -111,883.03 0.2624 540 Public Works-Admin 426,391.05 314,465.39 42.63 111,883.03 26.24 541 Public Works-Engineering 10-541-501020 Salaries 884,371.34 660,958.92 0.00 223,412.42 25.26 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,553.66 3,553.66 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 48,375.00 0.00 17,459.22 26.52 10-541-502020 Group Health Insurance 132,614.06 102,770.18 0.00 29,843.88 22.50 10-541-502030 Retirement 110,153.99 83,530.74 0.00 26,623.25 24.17 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 757.76 0.00 297.33 28.18 10-541-502060 Long Term Disability 2,488.48 2,011.09 0.00 477.39 19.18 10-541-502070 Employee Assistance Prgm 262.08 184.14 0.00 77.94 29.74 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,206,388.64 908,197.21 0.00 298,191.43 24.72 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 116.50 0.00 283.50 70.88 10-541-511020 Postage 400.00 56.99 0.00 343.01 85.75 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 626.61 0.00 1,023.39 62.02 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 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 539.30 0.00 460.70 46.07 10-541-515080 Surveying Supplies 1,500.00 273.89 0.00 1,226.11 81.74 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 3,563.74 0.00 3,786.26 51.51 10-541-520030 Dues And Publications 3,500.00 2,792.00 0.00 708.00 20.23 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 1,944.00 0.00 556.00 22.24 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 4,736.00 0.00 2,264.00 32.34 10-541-534010 Telephone 500.00 310.93 0.00 189.07 37.81 E20 Utilities 500.00 310.93 0.00 189.07 37.81 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 422.00 0.00 1,078.00 71.87 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 10-541-547020 Maintenance Agreements 10,665.00 9,023.01 325.98 1,316.01 12.34 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 11,055.01 325.98 2,784.01 19.65 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,235,403.64 927,862.89 325.98 307,214.77 24.8676 Grand Total -1,235,403.64 -927,862.89 -325.98 -307,214.77 0.2487 541 Public Works-Engineering 1,235,403.64 927,862.89 325.98 307,214.77 24.87 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,420,739.10 1,012,423.42 0.00 408,315.68 28.74 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 19,039.50 0.00 960.50 4.80 10-542-501070 Stand-by Plan 7,500.00 7,544.05 0.00 -44.05 -0.59 10-542-501090 Overtime 21,542.08 11,013.88 0.00 10,528.20 48.87 10-542-501095 Overtime Straight Pay 6,457.92 1,696.14 0.00 4,761.78 73.74 10-542-502010 Social Security 109,348.68 77,507.22 0.00 31,841.46 29.12 10-542-502020 Group Health Insurance 304,688.92 195,577.39 0.00 109,111.53 35.81 10-542-502030 Retirement 180,402.50 127,923.64 0.00 52,478.86 29.09 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,134.98 0.00 549.24 32.61 10-542-502060 Long Term Disability 4,165.34 3,014.54 0.00 1,150.80 27.63 10-542-502070 Employee Assistance Prgm 622.44 437.31 0.00 185.13 29.74 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,116,462.04 1,496,422.91 0.00 620,039.13 29.30 10-542-511010 Advertising 750.00 580.00 0.00 170.00 22.67 10-542-511020 Postage 150.00 1.41 0.00 148.59 99.06 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 488.33 0.00 907.67 65.02 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 234,534.87 135,261.70 0.00 99,273.17 42.33 10-542-514030 Small Tools 12,362.18 9,475.11 0.00 2,887.07 23.35 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 211,884.66 0.00 63,115.34 22.95 10-542-515040 First Aid Supplies 500.00 256.02 0.00 243.98 48.80 10-542-515060 Weed Control 2,000.00 1,592.41 0.00 407.59 20.38 10-542-515070 Const & Inspect Supplies 200.00 144.73 0.00 55.27 27.64 10-542-517010 Operational Supplies 10,811.47 9,081.38 0.00 1,730.09 16.00 E10 Materials & Supplies 539,446.34 369,456.75 0.00 169,989.59 31.51 10-542-520030 Dues And Publications 1,320.00 554.00 0.00 766.00 58.03 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 8,684.40 8,684.40 0.00 0.00 0.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 13,495.60 10,602.30 0.00 2,893.30 21.44 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 23,700.00 19,840.70 0.00 3,859.30 16.28 10-542-531010 Electricity 24,364.00 17,244.60 0.00 7,119.40 29.22 10-542-531020 Street Lights 571,962.00 476,746.64 0.00 95,215.36 16.65 10-542-533010 Natural Gas 12,500.00 12,317.89 0.00 182.11 1.46 10-542-534010 Telephone 2,080.00 2,053.97 0.00 26.03 1.25 10-542-535010 Water 8,390.00 3,414.36 0.00 4,975.64 59.30 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 619,296.00 511,777.46 0.00 107,518.54 17.36 10-542-540010 Building & Grounds Maint.10,000.00 10,636.26 150.00 -786.26 -7.86 10-542-541030 Vehicle Wash 7,000.00 6,675.00 0.00 325.00 4.64 10-542-542010 Repairs - StopStreet Lights 35,000.00 16,438.69 0.00 18,561.31 53.03 10-542-542030 Signs & Marking Paint 60,000.00 42,343.84 9,305.92 8,350.24 13.92 10-542-546010 Clothing Expense 13,000.00 10,821.03 0.00 2,178.97 16.76 10-542-547010 Equipment Maintenance 3,100.00 809.32 0.00 2,290.68 73.89 10-542-547020 Maintenance Agreements 460.00 312.30 104.10 43.60 9.48 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 88,036.44 9,560.02 31,963.54 24.67 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,444,464.38 2,500,911.79 9,560.02 933,992.57 27.1158 Grand Total -3,444,464.38 -2,500,911.79 -9,560.02 -933,992.57 0.2712 542 Public Works-Street 3,444,464.38 2,500,911.79 9,560.02 933,992.57 27.12 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 26,328.02 6,682.21 0.00 19,645.81 74.62 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,341,885.16 1,322,239.33 0.00 19,645.83 1.46 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,341,885.16 1,322,239.33 0.00 19,645.83 1.464 Grand Total -1,341,885.16 -1,322,239.33 0.00 -19,645.83 0.0146 700 Transfers & Subsidies 1,341,885.16 1,322,239.33 0.00 19,645.83 1.46 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 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 3,650.00 0.00 26,350.00 87.83 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 0.00 0.00 6,992.53 100.00 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 65,917.60 0.00 0.00 65,917.60 100.00 10-990-576008 Air Streets Stormwater 425,000.00 127.00 411,883.75 12,989.25 3.06 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 927.75 -927.75 0.00 10-990-576025 Douglas Davis Stormwater 125,267.16 118,201.81 6,710.62 354.73 0.28 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 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 79.75 145,000.00 4,920.25 3.28 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 411,619.24 1,088,380.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 98,000.00 850,172.75 78.88 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 8,701,449.16 1,139,833.80 1,750,902.88 5,810,712.48 66.78 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 1,314,833.80 1,750,902.88 6,560,712.48 68.153 Grand Total -9,626,449.16 -1,314,833.80 -1,750,902.88 -6,560,712.48 0.6815 990 Capital Projects 9,626,449.16 1,314,833.80 1,750,902.88 6,560,712.48 68.15 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 10-995-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 64,307,771.41 30,513,189.52 2,112,698.50 31,681,883.39 49.27 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 64,307,771.41 30,513,189.52 2,112,698.50 31,681,883.39 49.266 Grand Total -64,307,771.41 -30,513,189.52 -2,112,698.50 -31,681,883.39 0.4927 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 43