Loading...
HomeMy Public PortalAbout2023-06 NO Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 6/16/2023 9:44:01 AM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 43,650.00 0.00 22,275.00 33.79 10-110-501015 Salary-Prosecuting Attorney 34,999.92 23,333.28 0.00 11,666.64 33.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 3,955.11 0.00 12,643.29 76.17 10-110-502010 Social Security 8,990.53 5,255.27 0.00 3,735.26 41.55 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 126,585.44 76,265.25 0.00 50,320.19 39.75 10-110-511010 Advertising 0.00 79.75 0.00 -79.75 0.00 10-110-511020 Postage 100.00 15.99 0.00 84.01 84.01 10-110-512010 Printing 400.00 120.00 0.00 280.00 70.00 10-110-512020 Copies 96.00 0.04 0.00 95.96 99.96 10-110-513010 Office Supplies 1,435.00 1,045.46 0.00 389.54 27.15 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 1,261.24 0.00 769.76 37.90 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 726.62 0.00 773.38 51.56 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 161,883.49 0.00 -155,028.65 -2,261.59 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 61.89 61.90 0.21 0.17 E25 Repairs & Maintenance 124.00 61.89 61.90 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,796.88 0.00 -1,796.88 0.00 E70 Capital Purchases 0.00 1,796.88 0.00 -1,796.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 135,595.28 241,268.75 61.90 -105,735.37 -77.9786 Grand Total -135,595.28 -241,268.75 -61.90 105,735.37 -0.7798 110 Mayor & Council 135,595.28 241,268.75 61.90 -105,735.37 -77.98 120 City Clerk 10-120-501020 Salaries 56,948.36 35,285.72 0.00 21,662.64 38.04 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 2,485.91 0.00 1,870.64 42.94 10-120-502020 Group Health Insurance 13,245.50 7,998.78 0.00 5,246.72 39.61 10-120-502030 Retirement 7,289.39 4,516.59 0.00 2,772.80 38.04 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 42.17 0.00 27.60 39.56 10-120-502060 Long Term Disability 174.26 113.01 0.00 61.25 35.15 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 82,155.66 50,502.39 0.00 31,653.27 38.53 10-120-511020 Postage 200.00 161.38 0.00 38.62 19.31 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 227.38 0.00 72.62 24.21 10-120-513010 Office Supplies 200.00 64.59 0.00 135.41 67.71 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 453.35 0.00 246.65 35.24 10-120-520030 Dues And Publications 75.00 15.00 0.00 60.00 80.00 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 95.67 0.00 104.33 52.17 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,507.54 0.00 8,747.25 45.43 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,675.00 1,364.89 61.90 9,248.21 86.63 E25 Repairs & Maintenance 10,675.00 1,364.89 61.90 9,248.21 86.63 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 112,785.45 62,828.17 61.90 49,895.38 44.2392 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -62,828.17 -61.90 -49,895.38 0.4424 120 City Clerk 112,785.45 62,828.17 61.90 49,895.38 44.24 140 City Administrator 10-140-501020 Salaries 213,221.32 119,285.45 0.00 93,935.87 44.06 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 7,250.78 0.00 9,060.65 55.55 10-140-502020 Group Health Insurance 21,732.71 10,329.05 0.00 11,403.66 52.47 10-140-502030 Retirement 27,292.33 15,505.33 0.00 11,787.00 43.19 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 85.32 0.00 28.51 25.05 10-140-502060 Long Term Disability 374.04 292.57 0.00 81.47 21.78 10-140-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 279,290.56 152,970.18 0.00 126,320.38 45.23 10-140-511010 Advertising 0.00 525.00 0.00 -525.00 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 15.97 0.00 134.03 89.35 10-140-513010 Office Supplies 525.00 266.72 0.00 258.28 49.20 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 337.17 0.00 341.57 50.32 E10 Materials & Supplies 1,603.74 1,170.39 0.00 433.35 27.02 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 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 75.01 0.00 -75.01 0.00 E15 Contractual Services 2,400.00 1,707.10 0.00 692.90 28.87 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 242.48 241.00 -183.48 -61.16 E25 Repairs & Maintenance 300.00 242.48 241.00 -183.48 -61.16 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 283,594.30 156,090.15 241.00 127,263.15 44.8751 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -156,090.15 -241.00 -127,263.15 0.4488 140 City Administrator 283,594.30 156,090.15 241.00 127,263.15 44.88 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 14,000.00 2,352.80 0.00 11,647.20 83.19 10-143-502010 Social Security 0.00 159.58 0.00 -159.58 0.00 10-143-502020 Group Health Insurance 0.00 630.74 0.00 -630.74 0.00 10-143-502030 Retirement 0.00 301.19 0.00 -301.19 0.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 0.00 2.82 0.00 -2.82 0.00 10-143-502060 Long Term Disability 0.00 7.64 0.00 -7.64 0.00 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 3,454.77 0.00 10,545.23 75.32 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 3,454.77 0.00 110,545.23 96.9695 Grand Total -114,000.00 -3,454.77 0.00 -110,545.23 0.9697 143 CDBG-CV Compass Health 114,000.00 3,454.77 0.00 110,545.23 96.97 144 CDBG-DR 10-144-501020 Salaries 282,372.00 14,915.93 0.00 267,456.07 94.72 10-144-502010 Social Security 0.00 1,109.69 0.00 -1,109.69 0.00 10-144-502020 Group Health Insurance 0.00 2,781.50 0.00 -2,781.50 0.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-144-502030 Retirement 0.00 1,909.22 0.00 -1,909.22 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 18.14 0.00 -18.14 0.00 10-144-502060 Long Term Disability 0.00 49.12 0.00 -49.12 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 20,783.60 0.00 261,588.40 92.64 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 20,783.60 0.00 7,288,516.40 99.7157 Grand Total -7,309,300.00 -20,783.60 0.00 -7,288,516.40 0.9972 144 CDBG-DR 7,309,300.00 20,783.60 0.00 7,288,516.40 99.72 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 40,200.63 8,904.03 0.00 31,296.60 77.85 10-145-502010 Social Security 840.81 597.52 0.00 243.29 28.94 10-145-502020 Group Health Insurance 2,491.43 2,448.10 0.00 43.33 1.74 10-145-502030 Retirement 1,406.85 1,139.71 0.00 267.14 18.99 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 10.74 0.00 2.84 20.91 10-145-502060 Long Term Disability 33.34 28.44 0.00 4.90 14.70 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 13,136.88 0.00 31,863.12 70.81 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 13,136.88 0.00 1,986,863.12 99.3432 Grand Total -2,000,000.00 -13,136.88 0.00 -1,986,863.12 0.9934 145 CDBG-CV Cole Co EMS Station 2,000,000.00 13,136.88 0.00 1,986,863.12 99.34 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 9,710.28 19,140.94 0.00 -9,430.66 -97.12 10-146-502010 Social Security 742.84 1,302.00 0.00 -559.16 -75.27 10-146-502020 Group Health Insurance 2,201.13 5,143.48 0.00 -2,942.35 -133.67 10-146-502030 Retirement 1,242.92 2,450.04 0.00 -1,207.12 -97.12 10-146-502040 Workers Compensation 7.37 7.37 0.00 0.00 0.00 10-146-502050 Life Insurance 12.00 23.52 0.00 -11.52 -96.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-146-502060 Long Term Disability 29.46 63.03 0.00 -33.57 -113.95 10-146-502070 Employee Assistance Prgm 4.44 0.00 0.00 4.44 100.00 E05 Personnel Services 13,950.44 28,130.38 0.00 -14,179.94 -101.65 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 201.00 0.00 154.76 43.50 E15 Contractual Services 355.76 201.00 0.00 154.76 43.50 10-146-550068 Pass-Through Grants 674,580.00 0.00 0.00 674,580.00 100.00 E65 Other Non-Operating Expenses 674,580.00 0.00 0.00 674,580.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 688,886.20 28,331.38 0.00 660,554.82 95.8874 Grand Total -688,886.20 -28,331.38 0.00 -660,554.82 0.9589 146 HPF-P Bruhn Revitalization 688,886.20 28,331.38 0.00 660,554.82 95.89 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 6,064.61 0.00 22,406.77 78.70 10-147-502010 Social Security 576.14 405.31 0.00 170.83 29.65 10-147-502020 Group Health Insurance 1,707.17 1,633.79 0.00 73.38 4.30 10-147-502030 Retirement 964.00 776.27 0.00 187.73 19.47 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 7.30 0.00 2.00 21.51 10-147-502060 Long Term Disability 22.85 19.38 0.00 3.47 15.19 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 8,912.38 0.00 22,847.62 71.94 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 8,912.38 0.00 566,847.62 98.4521 Grand Total -575,760.00 -8,912.38 0.00 -566,847.62 0.9845 147 CDBG-CV Transform Housing 575,760.00 8,912.38 0.00 566,847.62 98.45 148 CDBG-CV 10-148-501020 Salaries 2,064.39 0.00 0.00 2,064.39 100.00 10-148-502010 Social Security 157.93 0.00 0.00 157.93 100.00 10-148-502020 Group Health Insurance 467.96 0.00 0.00 467.96 100.00 10-148-502030 Retirement 264.24 0.00 0.00 264.24 100.00 10-148-502040 Workers Compensation 1.57 0.00 0.00 1.57 100.00 10-148-502050 Life Insurance 2.55 0.00 0.00 2.55 100.00 10-148-502060 Long Term Disability 6.26 0.00 0.00 6.26 100.00 10-148-502070 Employee Assistance Prgm 0.94 0.00 0.00 0.94 100.00 E05 Personnel Services 2,965.84 0.00 0.00 2,965.84 100.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 1,362.22 -1,362.22 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 1,362.22 49,192.78 61.56 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 82,872.16 29,351.32 1,362.22 52,158.62 62.9387 Grand Total -82,872.16 -29,351.32 -1,362.22 -52,158.62 0.6294 148 CDBG-CV 82,872.16 29,351.32 1,362.22 52,158.62 62.94 149 Entitlement Grant 10-149-501020 Salaries 47,175.14 17,854.33 0.00 29,320.81 62.15 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 3,608.91 1,265.48 0.00 2,343.43 64.93 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 10,693.67 4,021.80 0.00 6,671.87 62.39 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 6,038.44 2,285.40 0.00 3,753.04 62.15 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 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 22.06 0.00 36.22 62.15 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 58.54 0.00 84.58 59.10 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 15.34 0.00 6.22 28.85 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 25,558.76 0.00 42,216.17 62.29 10-149-511010 Advertising 1,400.00 703.75 0.00 696.25 49.73 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 101.94 0.00 -31.94 -45.63 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 829.34 0.00 990.66 54.43 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 0.00 0.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,083.00 0.00 35,917.00 89.79 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 35,839.00 0.00 104,161.00 74.40 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 404,442.02 0.00 0.00 404,442.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 353,003.00 0.00 605,464.02 63.17 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 379,391.10 0.00 648,670.85 63.0965 Grand Total -1,028,061.95 -379,391.10 0.00 -648,670.85 0.631 149 Entitlement Grant 1,028,061.95 379,391.10 0.00 648,670.85 63.10 150 City Attorney 10-150-501020 Salaries 233,777.84 147,592.10 0.00 86,185.74 36.87 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 10,912.51 0.00 6,971.49 38.98 10-150-502020 Group Health Insurance 35,360.71 20,234.71 0.00 15,126.00 42.78 10-150-502030 Retirement 29,923.56 18,399.44 0.00 11,524.12 38.51 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 164.01 0.00 122.41 42.74 10-150-502060 Long Term Disability 607.87 425.75 0.00 182.12 29.96 10-150-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 318,136.71 197,989.99 0.00 120,146.72 37.77 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 126.05 0.00 473.95 78.99 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 16.93 0.00 -16.93 0.00 10-150-513010 Office Supplies 1,275.00 37.16 0.00 1,237.84 97.09 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 180.14 0.00 1,694.86 90.39 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 5,943.30 2,493.70 2,851.92 25.26 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 3,968.65 0.00 2,286.35 36.55 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 57.68 0.00 4,498.40 98.73 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 37,308.12 0.00 -37,308.12 0.00 E15 Contractual Services 22,600.00 47,642.75 2,493.70 -27,536.45 -121.84 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 211.90 211.90 -52.80 -14.23 E25 Repairs & Maintenance 371.00 211.90 211.90 -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 342,982.71 246,024.78 2,705.60 94,252.33 27.4802 Grand Total -342,982.71 -246,024.78 -2,705.60 -94,252.33 0.2748 150 City Attorney 342,982.71 246,024.78 2,705.60 94,252.33 27.48 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 23,333.28 0.00 11,666.64 33.33 10-160-501020 Salaries 124,730.18 81,013.84 0.00 43,716.34 35.05 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 3,395.76 0.00 3,604.24 51.49 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 8,115.10 0.00 4,716.25 36.76 10-160-502020 Group Health Insurance 25,616.32 14,449.87 0.00 11,166.45 43.59 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502030 Retirement 16,093.46 10,383.47 0.00 5,709.99 35.48 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 92.20 0.00 60.80 39.74 10-160-502060 Long Term Disability 381.67 246.75 0.00 134.92 35.35 10-160-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 223,069.59 141,365.60 0.00 81,703.99 36.63 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 968.91 0.00 1,031.09 51.55 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 363.04 0.00 2,136.96 85.48 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 1,331.95 0.00 3,568.05 72.82 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 57.33 0.00 4,442.67 98.73 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,310.20 0.00 14,479.80 63.54 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 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,038.20 658.20 598.60 9.51 E25 Repairs & Maintenance 6,295.00 5,038.20 658.20 598.60 9.51 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 257,054.59 156,045.95 658.20 100,350.44 39.0386 Grand Total -257,054.59 -156,045.95 -658.20 -100,350.44 0.3904 160 Municipal Court 257,054.59 156,045.95 658.20 100,350.44 39.04 170 Human Resources 10-170-501020 Salaries 229,300.24 143,912.39 0.00 85,387.85 37.24 10-170-501050 Parttime(wo Benefits)13,000.00 9,377.41 0.00 3,622.59 27.87 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 11,521.59 0.00 7,022.03 37.87 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502020 Group Health Insurance 25,708.58 15,341.15 0.00 10,367.43 40.33 10-170-502030 Retirement 29,363.23 18,397.36 0.00 10,965.87 37.35 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 168.53 0.00 111.77 39.88 10-170-502060 Long Term Disability 589.14 441.76 0.00 147.38 25.02 10-170-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 317,276.32 199,693.97 0.00 117,582.35 37.06 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 128.61 0.00 171.39 57.13 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 258.23 0.00 241.77 48.35 10-170-513010 Office Supplies 600.00 124.28 0.00 475.72 79.29 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 576.56 0.00 2,353.44 80.32 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,067.24 0.00 1,932.76 64.43 10-170-520070 Training And Education 4,437.00 343.44 0.00 4,093.56 92.26 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 266.00 0.00 234.00 46.80 10-170-522020 Professional Services 11,600.00 9,582.98 0.00 2,017.02 17.39 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 11,519.22 0.00 9,517.78 45.24 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 20,649.55 241.00 31,848.06 60.39 E25 Repairs & Maintenance 52,738.61 20,649.55 241.00 31,848.06 60.39 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 397,157.17 235,614.54 241.00 161,301.63 40.6141 Grand Total -397,157.17 -235,614.54 -241.00 -161,301.63 0.4061 170 Human Resources 397,157.17 235,614.54 241.00 161,301.63 40.61 180 Finance Department 10-180-501020 Salaries 570,708.35 296,362.38 0.00 274,345.97 48.07 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 22,154.38 0.00 21,504.81 49.26 10-180-502020 Group Health Insurance 96,970.17 48,060.19 0.00 48,909.98 50.44 10-180-502030 Retirement 73,050.67 36,812.47 0.00 36,238.20 49.61 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 346.06 0.00 357.74 50.83 10-180-502060 Long Term Disability 1,743.45 920.75 0.00 822.70 47.19 10-180-502070 Employee Assistance Prgm 234.78 87.54 0.00 147.24 62.71 10-180-503020 Unemployment Compensation 0.00 112.09 0.00 -112.09 0.00 E05 Personnel Services 787,569.24 405,354.66 0.00 382,214.58 48.53 10-180-511010 Advertising 1,000.00 107.00 0.00 893.00 89.30 10-180-511020 Postage 10,000.00 5,738.07 0.00 4,261.93 42.62 10-180-511021 Mail Machine Cost 3,000.00 1,512.37 0.00 1,487.63 49.59 10-180-512010 Printing 3,000.00 1,397.60 0.00 1,602.40 53.41 10-180-512020 Copies 1,000.00 22.94 0.00 977.06 97.71 10-180-512021 Copy Machine Cost 190.00 -220.63 0.00 410.63 216.12 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 179.00 0.00 3,476.00 95.10 E10 Materials & Supplies 23,095.00 8,937.98 0.00 14,157.02 61.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 40.00 0.00 1,915.00 97.95 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 1,649.66 0.00 3,800.34 69.73 10-180-520080 Tuition Reimbursement 4,704.00 2,808.00 0.00 1,896.00 40.31 10-180-522010 Audit 60,581.64 45,377.88 0.00 15,203.76 25.10 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 28.68 0.00 121.32 80.88 E15 Contractual Services 72,840.64 49,904.22 0.00 22,936.42 31.49 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,213.16 1,228.70 -321.86 -2.28 E25 Repairs & Maintenance 14,120.00 13,213.16 1,228.70 -321.86 -2.28 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 901,835.33 480,333.37 1,228.70 420,273.26 46.602 Grand Total -901,835.33 -480,333.37 -1,228.70 -420,273.26 0.466 180 Finance Department 901,835.33 480,333.37 1,228.70 420,273.26 46.60 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 185 Non-Departmental 10-185-501020 Salaries 358,011.26 0.00 0.00 358,011.26 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 211.99 0.00 3,988.01 94.95 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 399,178.69 34,770.91 0.00 364,407.78 91.29 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 10,249.49 0.00 9,750.51 48.75 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 44,119.17 570.00 0.00 43,549.17 98.71 E10 Materials & Supplies 64,119.17 10,819.49 0.00 53,299.68 83.13 10-185-520030 Dues and Publications 0.00 54.00 0.00 -54.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 491,256.34 0.00 -9,654.84 -2.00 10-185-521020 Insurance Deductible 25,000.00 83,827.40 0.00 -58,827.40 -235.31 10-185-521030 Self Ins Prop & Casualty 40,000.00 701.63 0.00 39,298.37 98.25 10-185-521060 Drugalcohol screening 3,564.00 1,909.00 0.00 1,655.00 46.44 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 61,800.00 38,493.00 25,995.00 -2,688.00 -4.35 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 92,500.00 0.00 92,500.00 50.00 10-185-529010 Special Events 5,000.00 1,507.84 0.00 3,492.16 69.84 E15 Contractual Services 848,965.50 710,249.21 25,995.00 112,721.29 13.28 10-185-531010 Electricity 32,000.00 14,596.55 0.00 17,403.45 54.39 10-185-533010 Natural Gas 6,200.00 5,021.58 0.00 1,178.42 19.01 10-185-535010 Water 7,250.00 3,670.25 0.00 3,579.75 49.38 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 23,288.38 0.00 22,161.62 48.76 10-185-540010 Building & Grounds Maint.40,000.00 29,456.24 0.00 10,543.76 26.36 10-185-540015 Amtrak Station 4,000.00 1,359.92 0.00 2,640.08 66.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,384.00 0.00 676.00 32.82 E25 Repairs & Maintenance 71,060.00 57,200.16 0.00 13,859.84 19.50 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 284,987.08 0.00 166,573.68 36.89 E30 Other Operating Expenses 464,360.76 297,186.60 0.00 167,174.16 36.00 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 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 11,735.95 0.00 -11,735.95 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 11,735.95 0.00 -11,735.95 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,893,134.12 1,145,250.70 25,995.00 721,888.42 38.1319 Grand Total -1,893,134.12 -1,145,250.70 -25,995.00 -721,888.42 0.3813 185 Non-Departmental 1,893,134.12 1,145,250.70 25,995.00 721,888.42 38.13 190 Information Technology Svcs 10-190-501020 Salaries 556,371.81 362,857.24 0.00 193,514.57 34.78 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 26,971.05 0.00 19,454.64 41.90 10-190-502020 Group Health Insurance 96,814.24 47,250.94 0.00 49,563.30 51.19 10-190-502030 Retirement 77,679.59 39,815.50 0.00 37,864.09 48.74 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 405.05 0.00 339.14 45.57 10-190-502060 Long Term Disability 1,815.32 1,099.96 0.00 715.36 39.41 10-190-502070 Employee Assistance Prgm 207.48 97.18 0.00 110.30 53.16 E05 Personnel Services 781,916.53 479,855.13 0.00 302,061.40 38.63 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 7.25 0.00 2.75 27.50 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 304.40 0.00 195.60 39.12 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 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,015.20 0.00 -1,015.20 -50.76 E10 Materials & Supplies 2,660.00 3,380.85 0.00 -720.85 -27.10 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 1,499.06 0.00 7,000.94 82.36 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 44,000.00 6,070.67 0.00 37,929.33 86.20 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 14,777.22 0.00 8,222.78 35.75 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 26,800.95 0.00 53,249.05 66.52 10-190-534010 Telephone 96,000.00 51,045.34 0.00 44,954.66 46.83 E20 Utilities 96,000.00 51,045.34 0.00 44,954.66 46.83 10-190-545010 Software License\maint 197,000.00 186,426.86 0.00 10,573.14 5.37 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,092.66 208.20 2,699.14 12.27 10-190-547025 Coun Chamber MediaEquip Repr 0.00 242.84 0.00 -242.84 0.00 E25 Repairs & Maintenance 219,000.00 205,762.36 208.20 13,029.44 5.95 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,179,626.53 766,844.63 208.20 412,573.70 34.9749 Grand Total -1,179,626.53 -766,844.63 -208.20 -412,573.70 0.3497 190 Information Technology Svcs 1,179,626.53 766,844.63 208.20 412,573.70 34.97 300 Police Department 10-300-501020 Salaries 5,457,482.75 3,052,010.43 0.00 2,405,472.32 44.08 10-300-501030 Holiday Pay 169,092.64 91,945.16 0.00 77,147.48 45.62 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 18,821.02 0.00 27,036.99 58.96 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 6,515.50 0.00 -1,515.50 -30.31 10-300-501090 Overtime 304,257.77 258,183.41 0.00 46,074.36 15.14 10-300-501095 Overtime Straight Pay 13,275.00 10,193.72 0.00 3,081.28 23.21 10-300-502010 Social Security 444,750.67 249,994.99 0.00 194,755.68 43.79 10-300-502020 Group Health Insurance 960,547.52 528,859.70 0.00 431,687.82 44.94 10-300-502030 Retirement 1,009,334.34 582,661.91 0.00 426,672.43 42.27 10-300-502040 Workers Compensation 75,085.94 75,085.94 0.00 0.00 0.00 10-300-502050 Life Insurance 6,542.28 3,585.18 0.00 2,957.10 45.20 10-300-502060 Long Term Disability 15,894.91 9,562.13 0.00 6,332.78 39.84 10-300-502070 Employee Assistance Prgm 1,960.14 925.80 0.00 1,034.34 52.77 10-300-503010 Awards Program 2,500.00 0.00 687.00 1,813.00 72.52 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,551,774.27 4,888,344.89 687.00 3,662,742.38 42.83 10-300-511010 Advertising 5,665.00 3,762.25 0.00 1,902.75 33.59 10-300-511020 Postage 1,395.00 814.47 0.00 580.53 41.62 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 11,252.13 1,657.35 2,761.02 17.62 10-300-514010 Gas 188,862.00 91,848.54 0.00 97,013.46 51.37 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 698.14 0.00 -47.14 -7.24 10-300-515040 First Aid Supplies 1,378.00 1,299.02 0.00 78.98 5.73 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 37,744.16 3,134.00 5,399.84 11.67 E10 Materials & Supplies 344,272.75 218,862.14 9,613.91 115,796.70 33.64 10-300-520030 Dues And Publications 5,400.00 4,364.40 0.00 1,035.60 19.18 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 57,493.88 0.00 18,506.12 24.35 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 375.74 0.00 911.26 70.80 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-521040 Medical Claimsservices 6,510.00 6,252.00 0.00 258.00 3.96 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 0.00 0.00 29,750.00 100.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 43,359.00 43,359.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 553.39 0.00 1,492.61 72.95 E15 Contractual Services 191,977.00 129,510.55 0.00 62,466.45 32.54 10-300-531010 Electricity 44,640.00 19,646.68 0.00 24,993.32 55.99 10-300-533010 Natural Gas 1,116.00 405.00 0.00 711.00 63.71 10-300-534010 Telephone 24,101.00 16,019.95 0.00 8,081.05 33.53 10-300-535010 Water 3,348.00 1,963.36 0.00 1,384.64 41.36 E20 Utilities 73,205.00 38,034.99 0.00 35,170.01 48.04 10-300-540010 Building & Grounds Maint.37,200.00 96,054.75 0.00 -58,854.75 -158.21 10-300-541030 Vehicle Wash 9,752.00 7,593.00 0.00 2,159.00 22.14 10-300-544010 K-9 Operations 16,740.00 10,460.72 880.35 5,398.93 32.25 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 9,897.31 0.00 18,052.69 64.59 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 15,598.23 472.50 32,849.27 67.15 10-300-546020 Uniform Cleaning 23,715.00 18,323.11 0.00 5,391.89 22.74 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 37,027.49 7,410.60 11,809.91 21.00 10-300-547030 Radio Maintenance 8,025.00 96.88 0.00 7,928.12 98.79 E25 Repairs & Maintenance 320,964.00 261,054.47 8,763.45 51,146.08 15.94 10-300-572010 Purchase Of Vehicles 46,849.80 5,093.80 41,739.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 0.00 37,162.93 100.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 89,250.00 89,250.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 0.00 13,538.67 100.00 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 366,801.40 154,343.80 41,739.00 170,718.60 46.54 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,848,994.42 5,690,150.84 60,803.36 4,098,040.22 41.6087 Grand Total -9,848,994.42 -5,690,150.84 -60,803.36 -4,098,040.22 0.4161 300 Police Department 9,848,994.42 5,690,150.84 60,803.36 4,098,040.22 41.61 310 School Resource Officer 10-310-501020 Salaries 489,893.97 243,214.78 0.00 246,679.19 50.35 10-310-501030 Holiday Pay 20,720.19 0.00 0.00 20,720.19 100.00 10-310-501090 Overtime 45,106.00 67,766.62 0.00 -22,660.62 -50.24 10-310-501095 Overtime Straight Pay 1,311.00 1,796.34 0.00 -485.34 -37.02 10-310-502010 Social Security 42,612.88 22,578.11 0.00 20,034.77 47.02 10-310-502020 Group Health Insurance 89,715.43 46,949.16 0.00 42,766.27 47.67 10-310-502030 Retirement 100,265.61 56,300.01 0.00 43,965.60 43.85 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 283.41 0.00 320.02 53.03 10-310-502060 Long Term Disability 1,498.63 758.71 0.00 739.92 49.37 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 798,454.72 446,281.84 0.00 352,172.88 44.11 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 1,913.48 0.00 13,431.52 87.53 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 1,913.48 0.00 20,426.52 91.43 10-310-520070 Training And Education 4,650.00 600.00 0.00 4,050.00 87.10 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 600.00 0.00 4,050.00 87.10 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 898.20 208.20 -746.40 -207.33 E25 Repairs & Maintenance 6,334.00 1,045.31 208.20 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 449,840.63 208.20 381,729.89 45.8932 Grand Total -831,778.72 -449,840.63 -208.20 -381,729.89 0.4589 310 School Resource Officer 831,778.72 449,840.63 208.20 381,729.89 45.89 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 77,983.73 0.00 49,623.23 38.89 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 22,882.77 0.00 6,535.45 22.22 10-320-501095 Overtime Straight Pay 0.00 773.35 0.00 -773.35 0.00 10-320-502010 Social Security 11,037.18 7,375.18 0.00 3,662.00 33.18 10-320-502020 Group Health Insurance 20,462.81 12,320.11 0.00 8,142.70 39.79 10-320-502030 Retirement 25,969.83 18,295.17 0.00 7,674.66 29.55 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 90.44 0.00 65.01 41.82 10-320-502060 Long Term Disability 384.75 240.76 0.00 143.99 37.42 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 222,402.83 141,986.36 0.00 80,416.47 36.16 10-320-514010 Gas 11,848.00 5,338.69 0.00 6,509.31 54.94 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 6,943.40 0.00 8,162.60 54.04 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 12,882.09 0.00 19,266.19 59.93 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 6,900.00 0.00 10,600.00 60.57 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 6,900.00 0.00 10,600.00 60.57 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 272,051.11 161,768.45 0.00 110,282.66 40.5375 Grand Total -272,051.11 -161,768.45 0.00 -110,282.66 0.4054 320 M.U.S.T.A.N.G.272,051.11 161,768.45 0.00 110,282.66 40.54 330 Animal Control 10-330-501020 Salaries 370,091.13 195,058.66 0.00 175,032.47 47.29 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 5,035.78 0.00 3,564.22 41.44 10-330-501090 Overtime 2,000.00 9,014.11 0.00 -7,014.11 -350.71 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 14,256.97 0.00 14,865.90 51.05 10-330-502020 Group Health Insurance 93,298.71 48,549.98 0.00 44,748.73 47.96 10-330-502030 Retirement 48,728.46 26,003.86 0.00 22,724.60 46.64 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 456.55 222.08 0.00 234.47 51.36 10-330-502060 Long Term Disability 1,117.06 613.71 0.00 503.35 45.06 10-330-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 558,270.58 303,518.07 0.00 254,752.51 45.63 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 48.14 0.00 103.86 68.33 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 243.74 0.00 1,037.26 80.97 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 113.90 0.00 109.10 48.92 10-330-515040 First Aid Supplies 295.00 138.15 0.00 156.85 53.17 10-330-517010 Operational Supplies 11,000.00 4,215.24 0.00 6,784.76 61.68 E10 Materials & Supplies 15,716.00 5,657.76 0.00 10,058.24 64.00 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,611.00 0.00 0.00 1,611.00 100.00 10-330-521040 Medical Claimsservices 690.00 60.00 0.00 630.00 91.30 10-330-522020 Professional Services 4,830.00 1,237.20 0.00 3,592.80 74.39 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 1,111.89 0.00 4,096.11 78.65 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 0.00 4,580.00 0.00 -4,580.00 0.00 E15 Contractual Services 13,239.00 7,045.44 0.00 6,193.56 46.78 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-531010 Electricity 22,789.00 13,420.55 0.00 9,368.45 41.11 10-330-533010 Natural Gas 21,000.00 15,008.39 0.00 5,991.61 28.53 10-330-534010 Telephone 810.00 550.38 0.00 259.62 32.05 10-330-535010 Water 3,800.00 1,984.69 0.00 1,815.31 47.77 E20 Utilities 48,399.00 30,964.01 0.00 17,434.99 36.02 10-330-540010 Building & Grounds Maint.15,000.00 16,431.87 0.00 -1,431.87 -9.55 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 49,290.00 34,862.57 0.00 14,427.43 29.27 10-330-544050 Animal Food 6,603.00 2,773.05 0.00 3,829.95 58.00 10-330-545010 Software Licensemaint 3,191.00 2,500.04 0.00 690.96 21.65 10-330-546010 Clothing Expense 2,025.00 1,425.69 0.00 599.31 29.60 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 208.20 208.20 -56.40 -15.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 79,074.00 60,827.42 208.20 18,038.38 22.81 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 757,393.58 450,707.70 208.20 306,477.68 40.4648 Grand Total -757,393.58 -450,707.70 -208.20 -306,477.68 0.4046 330 Animal Control 757,393.58 450,707.70 208.20 306,477.68 40.46 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 530,266.45 0.00 550,886.06 50.95 10-390-501030 Holiday Pay 38,718.75 21,310.12 0.00 17,408.63 44.96 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 10,152.14 0.00 -10,152.14 0.00 10-390-501090 Overtime 22,814.00 76,249.89 0.00 -53,435.89 -234.22 10-390-501095 Overtime Straight Pay 1,850.00 2,802.52 0.00 -952.52 -51.49 10-390-502010 Social Security 87,556.95 47,049.27 0.00 40,507.68 46.26 10-390-502020 Group Health Insurance 223,648.25 101,441.97 0.00 122,206.28 54.64 10-390-502030 Retirement 152,546.30 68,470.88 0.00 84,075.42 55.11 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 606.40 0.00 726.54 54.51 10-390-502060 Long Term Disability 3,302.13 1,615.31 0.00 1,686.82 51.08 10-390-502070 Employee Assistance Prgm 480.48 217.38 0.00 263.10 54.76 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,616,122.27 862,902.29 0.00 753,219.98 46.61 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 3,032.62 0.00 1,267.38 29.47 10-390-523010 Equipment Rentlease 99,260.00 33,597.20 0.00 65,662.80 66.15 E15 Contractual Services 109,768.00 38,834.75 0.00 70,933.25 64.62 10-390-531010 Electricity 11,160.00 7,920.71 0.00 3,239.29 29.03 10-390-533010 Natural Gas 279.00 260.38 0.00 18.62 6.67 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 848.46 0.00 -11.46 -1.37 E20 Utilities 12,276.00 9,029.55 0.00 3,246.45 26.45 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 83.56 0.00 5,496.44 98.50 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,065.06 341.04 3,593.90 4.79 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 132,445.54 341.04 10,819.42 7.53 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,889,972.27 1,047,940.24 341.04 841,690.99 44.5346 Grand Total -1,889,972.27 -1,047,940.24 -341.04 -841,690.99 0.4453 390 9-1-1 Police 1,889,972.27 1,047,940.24 341.04 841,690.99 44.53 400 Fire Department 10-400-501020 Salaries 4,989,033.59 2,552,182.87 0.00 2,436,850.72 48.84 10-400-501025 Other Hours 0.00 48.44 0.00 -48.44 0.00 10-400-501030 Holiday Pay 341,978.12 240,475.95 0.00 101,502.17 29.68 10-400-501035 Training & Essential Functions 0.00 4,932.69 0.00 -4,932.69 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 21,760.73 0.00 16,239.27 42.73 10-400-501090 Overtime-FLSA 45,000.00 67,341.11 0.00 -22,341.11 -49.65 10-400-501092 Overtime-Constant Staffing 0.00 2,856.83 0.00 -2,856.83 0.00 10-400-501095 Overtime Straight Pay 40,000.00 35,290.26 0.00 4,709.74 11.77 10-400-502010 Social Security 69,573.39 41,732.93 0.00 27,840.46 40.02 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-502020 Group Health Insurance 871,448.91 519,308.82 0.00 352,140.09 40.41 10-400-502030 Retirement 2,292,378.67 1,413,517.48 0.00 878,861.19 38.34 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 2,979.51 0.00 2,089.07 41.22 10-400-502060 Long Term Disability 12,419.68 7,906.05 0.00 4,513.63 36.34 10-400-502070 Employee Assistance Prgm 1,681.68 777.46 0.00 904.22 53.77 10-400-503010 Awards Program 1,600.00 244.35 0.00 1,355.65 84.73 E05 Personnel Services 8,861,213.57 5,064,386.43 0.00 3,796,827.14 42.85 10-400-511010 Advertising 300.00 96.00 0.00 204.00 68.00 10-400-511020 Postage 120.00 217.26 0.00 -97.26 -81.05 10-400-512010 Printing 700.00 834.12 0.00 -134.12 -19.16 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 734.89 0.00 660.11 47.32 10-400-514010 Gas 61,175.00 38,656.18 0.00 22,518.82 36.81 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 10-400-514030 Small Tools 6,000.00 3,783.56 0.00 2,216.44 36.94 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,848.29 0.00 251.71 11.99 10-400-517010 Operational Supplies 18,000.00 7,159.04 0.00 10,840.96 60.23 E10 Materials & Supplies 90,740.00 53,329.48 0.00 37,410.52 41.23 10-400-520030 Dues And Publications 3,400.00 2,398.55 0.00 1,001.45 29.45 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 27,063.79 0.00 4,936.21 15.43 10-400-520080 Tuition Reimbursement 7,500.00 9,297.00 0.00 -1,797.00 -23.96 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 4,464.20 0.00 35,535.80 88.84 10-400-522020 Professional Services 3,000.00 660.00 0.00 2,340.00 78.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,000.00 5,405.51 0.00 -405.51 -8.11 10-400-529040 Child Safety Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 93,593.00 50,069.05 0.00 43,523.95 46.50 10-400-531010 Electricity 35,000.00 17,754.03 0.00 17,245.97 49.27 10-400-533010 Natural Gas 17,670.00 20,194.63 0.00 -2,524.63 -14.29 10-400-534010 Telephone 25,984.20 16,212.86 0.00 9,771.34 37.60 10-400-535010 Water 12,000.00 6,405.18 0.00 5,594.82 46.62 E20 Utilities 90,654.20 60,566.70 0.00 30,087.50 33.19 10-400-540010 Building & Grounds Maint.90,000.00 27,866.92 11,287.00 50,846.08 56.50 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 64,027.24 0.00 30,972.76 32.60 10-400-546020 Uniform Cleaning 500.00 205.45 0.00 294.55 58.91 10-400-547010 Equipment Maintenance 20,000.00 11,998.64 0.00 8,001.36 40.01 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-547020 Maintenance Agreements 39,487.50 23,049.63 1,052.48 15,385.39 38.96 10-400-547030 Radio Maintenance 20,925.00 8,935.76 0.00 11,989.24 57.30 E25 Repairs & Maintenance 265,912.50 136,083.64 12,339.48 117,489.38 44.18 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 4,162.15 0.00 -2,662.15 -177.48 10-400-572021 Purchase of Equipment-ONE TIME 163,699.68 17,678.42 124,203.40 21,817.86 13.33 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 69,888.50 141,437.82 21,329.36 9.17 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,634,768.95 5,434,323.80 153,777.30 4,046,667.85 42.0007 Grand Total -9,634,768.95 -5,434,323.80 -153,777.30 -4,046,667.85 0.42 400 Fire Department 9,634,768.95 5,434,323.80 153,777.30 4,046,667.85 42.00 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,415.49 0.00 284.51 16.74 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,700.00 1,415.49 0.00 284.51 16.74 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,415.49 0.00 284.51 16.7359 Grand Total -1,700.00 -1,415.49 0.00 -284.51 0.1674 401 Fire Museum 1,700.00 1,415.49 0.00 284.51 16.74 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 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,205.46 178,412.10 0.00 61,793.36 25.73 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 13,143.20 0.00 5,232.52 28.48 10-520-502020 Group Health Insurance 52,232.32 30,274.70 0.00 21,957.62 42.04 10-520-502030 Retirement 30,746.30 20,411.45 0.00 10,334.85 33.61 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 174.67 0.00 121.54 41.03 10-520-502060 Long Term Disability 636.77 453.18 0.00 183.59 28.83 10-520-502070 Employee Assistance Prgm 87.36 30.68 0.00 56.68 64.88 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 342,777.04 243,096.88 0.00 99,680.16 29.08 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 25.17 0.00 49.83 66.44 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 338.30 0.00 511.70 60.20 10-520-514010 Gas 12,975.00 6,901.48 0.00 6,073.52 46.81 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 9,501.57 0.00 4,998.43 34.47 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 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 29,089.01 31,262.33 545.40 -2,718.72 -9.35 E25 Repairs & Maintenance 29,089.01 31,262.33 545.40 -2,718.72 -9.35 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 392,366.05 289,035.29 545.40 102,785.36 26.1963 Grand Total -392,366.05 -289,035.29 -545.40 -102,785.36 0.262 520 Plan & Protect Svcs-Admin 392,366.05 289,035.29 545.40 102,785.36 26.20 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 61,746.21 0.00 -10,337.43 -20.11 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 4,608.13 0.00 -675.36 -17.17 10-521-502020 Group Health Insurance 9,239.72 10,522.96 0.00 -1,283.24 -13.89 10-521-502030 Retirement 6,580.32 7,903.35 0.00 -1,323.03 -20.11 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 72.81 0.00 -10.39 -16.65 10-521-502060 Long Term Disability 156.03 193.62 0.00 -37.59 -24.09 10-521-502070 Employee Assistance Prgm 15.29 27.62 0.00 -12.33 -80.64 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 71,553.68 85,233.05 0.00 -13,679.37 -19.12 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-511010 Advertising 3,336.00 2,478.20 0.00 857.80 25.71 10-521-511020 Postage 500.00 213.08 0.00 286.92 57.38 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,094.19 0.00 2,241.81 35.38 10-521-520030 Dues And Publications 13,220.00 632.00 0.00 12,588.00 95.22 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 180.00 0.00 1,320.00 88.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 812.00 0.00 13,908.00 94.48 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 824.43 364.49 82.08 6.46 E25 Repairs & Maintenance 1,271.00 824.43 364.49 82.08 6.46 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 93,880.68 90,963.67 364.49 2,552.52 2.7189 Grand Total -93,880.68 -90,963.67 -364.49 -2,552.52 0.0272 521 Plan & Protect Svcs-Planning 93,880.68 90,963.67 364.49 2,552.52 2.72 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 49,442.71 0.00 80,945.23 62.08 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 3,736.21 0.00 6,238.47 62.54 10-522-502020 Group Health Insurance 20,902.54 7,025.67 0.00 13,876.87 66.39 10-522-502030 Retirement 16,689.66 6,328.83 0.00 10,360.83 62.08 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 58.71 0.00 102.33 63.54 10-522-502060 Long Term Disability 397.13 156.33 0.00 240.80 60.64 10-522-502070 Employee Assistance Prgm 50.23 23.52 0.00 26.71 53.18 E05 Personnel Services 178,665.77 66,874.53 0.00 111,791.24 62.57 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-511010 Advertising 2,600.00 764.74 0.00 1,835.26 70.59 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 300.00 510.27 0.00 -210.27 -70.09 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 235.97 0.00 1,264.03 84.27 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 34,713.40 18,205.20 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 34,949.37 18,205.20 35,845.43 40.28 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 936.77 323.25 1,139.98 47.50 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 936.77 323.25 1,139.98 47.50 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 279,065.77 104,977.71 18,528.45 155,559.61 55.743 Grand Total -279,065.77 -104,977.71 -18,528.45 -155,559.61 0.5574 522 Plan & Protect Svcs-MPO 279,065.77 104,977.71 18,528.45 155,559.61 55.74 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 30,429.91 0.00 54,045.37 63.98 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,231.82 0.00 6,464.37 74.34 10-530-502020 Group Health Insurance 25,767.93 5,188.12 0.00 20,579.81 79.87 10-530-502030 Retirement 14,550.48 3,837.32 0.00 10,713.16 73.63 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 32.68 0.00 107.76 76.73 10-530-502060 Long Term Disability 344.86 84.17 0.00 260.69 75.59 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 41,897.00 0.00 92,216.44 68.76 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-511020 Postage 150.00 21.66 0.00 128.34 85.56 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 618.80 0.00 761.20 55.16 10-530-520030 Dues And Publications 500.00 604.82 0.00 -104.82 -20.96 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,000.00 512.90 0.00 1,487.10 74.36 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 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 14,615.52 10,000.00 0.00 4,615.52 31.58 10-530-524026 Household Hazardous Waste 19,000.00 11,994.19 0.00 7,005.81 36.87 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 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 63,115.52 23,111.91 0.00 40,003.61 63.38 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 446.73 187.45 37.84 5.63 E25 Repairs & Maintenance 672.02 446.73 187.45 37.84 5.63 10-530-550020 NRA-Residential 40,000.00 39,526.59 0.00 473.41 1.18 10-530-550030 NRA-Commercial Facade 19,500.00 3,000.00 0.00 16,500.00 84.62 10-530-550031 Historic Preservation Grant 23,000.00 55.75 0.00 22,944.25 99.76 10-530-550032 NRA-Rental Facade 15,000.00 27.00 0.00 14,973.00 99.82 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,200.00 39.20 0.00 1,160.80 96.73 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 92.94 0.00 -92.94 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 148,700.00 42,808.98 0.00 105,891.02 71.21 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 347,980.98 108,883.42 187.45 238,910.11 68.6561 Grand Total -347,980.98 -108,883.42 -187.45 -238,910.11 0.6866 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 530 Plan & Protect Svc-RedevGrant 347,980.98 108,883.42 187.45 238,910.11 68.66 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 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 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 194,879.84 100,565.69 0.00 94,314.15 48.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 7,052.28 0.00 7,856.03 52.70 10-532-502020 Group Health Insurance 39,644.71 21,329.86 0.00 18,314.85 46.20 10-532-502030 Retirement 24,944.62 12,872.39 0.00 12,072.23 48.40 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 101.51 0.00 137.17 57.47 10-532-502060 Long Term Disability 592.66 307.79 0.00 284.87 48.07 10-532-502070 Employee Assistance Prgm 65.52 48.58 0.00 16.94 25.85 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 279,027.76 146,031.52 0.00 132,996.24 47.66 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 43.35 0.00 106.65 71.10 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 365.91 0.00 934.09 71.85 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 299.99 0.00 700.01 70.00 E10 Materials & Supplies 2,625.00 709.25 0.00 1,915.75 72.98 10-532-520030 Dues And Publications 900.00 345.00 0.00 555.00 61.67 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 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 117,678.00 84,000.00 -78.00 -0.04 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 118,575.90 84,000.00 1,524.10 0.75 10-532-534010 Telephone 1,200.00 742.32 0.00 457.68 38.14 E20 Utilities 1,200.00 742.32 0.00 457.68 38.14 10-532-540060 Cemetery Maintenance 37,750.00 21,605.45 15,315.00 829.55 2.20 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 709.54 517.87 -317.41 -34.88 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 24,159.41 15,832.87 1,077.72 2.62 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 528,022.76 290,218.40 99,832.87 137,971.49 26.1298 Grand Total -528,022.76 -290,218.40 -99,832.87 -137,971.49 0.2613 532 Plan & Protect Svcs-Env Health 528,022.76 290,218.40 99,832.87 137,971.49 26.13 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 164,815.30 117,125.15 0.00 47,690.15 28.94 10-533-501050 Parttime(wo Benefits)20,000.00 4,394.26 0.00 15,605.74 78.03 10-533-501060 Seasonal Salaries 0.00 9,876.07 0.00 -9,876.07 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 9,911.43 0.00 4,226.89 29.90 10-533-502020 Group Health Insurance 30,239.78 15,734.87 0.00 14,504.91 47.97 10-533-502030 Retirement 21,096.27 12,342.14 0.00 8,754.13 41.50 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 111.61 0.00 92.20 45.24 10-533-502060 Long Term Disability 505.89 310.53 0.00 195.36 38.62 10-533-502070 Employee Assistance Prgm 65.52 23.01 0.00 42.51 64.88 E05 Personnel Services 253,322.27 172,086.45 0.00 81,235.82 32.07 10-533-511010 Advertising 100.00 205.63 0.00 -105.63 -105.63 10-533-511020 Postage 1,800.00 1,186.92 0.00 613.08 34.06 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 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 954.92 0.00 45.08 4.51 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-517010 Operational Supplies 1,350.00 800.13 0.00 549.87 40.73 E10 Materials & Supplies 4,690.00 3,147.64 0.00 1,542.36 32.89 10-533-520030 Dues And Publications 500.00 168.00 0.00 332.00 66.40 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 598.47 0.00 601.53 50.13 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 10,000.00 12,877.80 0.00 -2,877.80 -28.78 10-533-522022 Demo 263,433.60 88,385.89 44,616.88 130,430.83 49.51 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 353,591.15 150,892.66 44,616.88 158,081.61 44.71 10-533-534010 Telephone 3,701.40 2,186.84 0.00 1,514.56 40.92 E20 Utilities 3,701.40 2,186.84 0.00 1,514.56 40.92 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 799.13 481.85 -9.98 -0.79 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 1,918.56 481.85 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 618,155.82 330,232.15 45,098.73 242,824.94 39.2822 Grand Total -618,155.82 -330,232.15 -45,098.73 -242,824.94 0.3928 533 PPS - Prop MaintCode Enforce 618,155.82 330,232.15 45,098.73 242,824.94 39.28 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 189,697.26 0.00 115,810.50 37.91 10-534-501050 Parttime(wo Benefits)15,900.00 2,431.86 0.00 13,468.14 84.71 10-534-501060 Seasonal Salaries 0.00 5,059.70 0.00 -5,059.70 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 13,790.99 0.00 10,796.70 43.91 10-534-502020 Group Health Insurance 79,982.22 48,068.15 0.00 31,914.07 39.90 10-534-502030 Retirement 39,104.99 24,281.16 0.00 14,823.83 37.91 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 226.36 0.00 148.18 39.56 10-534-502060 Long Term Disability 929.35 602.88 0.00 326.47 35.13 10-534-502070 Employee Assistance Prgm 109.20 61.38 0.00 47.82 43.79 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 471,251.82 288,975.81 0.00 182,276.01 38.68 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 161.16 0.00 938.84 85.35 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 370.84 0.00 1,429.16 79.40 E10 Materials & Supplies 4,115.00 773.80 0.00 3,341.20 81.20 10-534-520030 Dues And Publications 2,500.00 654.00 0.00 1,846.00 73.84 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,515.92 0.00 -515.92 -10.32 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 6,169.92 0.00 1,330.08 17.73 10-534-534010 Telephone 3,060.00 1,693.68 0.00 1,366.32 44.65 E20 Utilities 3,060.00 1,693.68 0.00 1,366.32 44.65 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 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 721.17 289.50 -22.67 -2.29 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 1,927.17 289.50 461.33 17.23 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 488,604.82 299,540.38 289.50 188,774.94 38.6355 Grand Total -488,604.82 -299,540.38 -289.50 -188,774.94 0.3864 534 Plan & Protect Svcs-Bldg Regs 488,604.82 299,540.38 289.50 188,774.94 38.64 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 244,980.06 0.00 140,471.18 36.44 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,352.35 0.00 3,147.65 69.95 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-501095 Overtime Straight Pay 500.00 78.28 0.00 421.72 84.34 10-535-502010 Social Security 30,175.52 17,973.80 0.00 12,201.72 40.44 10-535-502020 Group Health Insurance 79,635.09 48,218.57 0.00 31,416.52 39.45 10-535-502030 Retirement 49,977.76 31,540.52 0.00 18,437.24 36.89 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 285.53 0.00 186.93 39.57 10-535-502060 Long Term Disability 1,177.64 763.53 0.00 414.11 35.16 10-535-502070 Employee Assistance Prgm 152.88 71.60 0.00 81.28 53.17 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 560,511.95 349,733.60 0.00 210,778.35 37.60 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 739.41 0.00 260.59 26.06 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 6,000.00 1,257.70 0.00 4,742.30 79.04 10-535-517010 Operational Supplies 6,000.00 4,975.60 0.00 1,024.40 17.07 E10 Materials & Supplies 13,140.00 6,991.58 0.00 6,148.42 46.79 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,500.00 189.90 0.00 1,310.10 87.34 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 2,350.00 380.90 0.00 1,969.10 83.79 10-535-531010 Electricity 6,560.00 3,305.77 0.00 3,254.23 49.61 10-535-533010 Natural Gas 3,000.00 3,080.72 0.00 -80.72 -2.69 10-535-534010 Telephone 220.00 289.11 0.00 -69.11 -31.41 10-535-535010 Water 1,442.00 698.18 0.00 743.82 51.58 E20 Utilities 11,222.00 7,373.78 0.00 3,848.22 34.29 10-535-540010 Building & Grounds Maint.10,000.00 8,451.98 17.50 1,530.52 15.31 10-535-541010 Veh & Equip Parts Etc 393,400.00 211,863.09 15,567.13 165,969.78 42.19 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 9,000.00 8,097.58 0.00 902.42 10.03 10-535-547010 Equipment Maintenance 1,000.00 194.46 189.46 616.08 61.61 10-535-547020 Maintenance Agreements 17,251.00 11,495.97 208.20 5,546.83 32.15 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 240,103.08 15,982.29 174,665.63 40.55 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Expense Total 1,017,974.95 604,582.94 15,982.29 397,409.72 39.0392 Grand Total -1,017,974.95 -604,582.94 -15,982.29 -397,409.72 0.3904 535 Public Works-Central Maintenan 1,017,974.95 604,582.94 15,982.29 397,409.72 39.04 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 153,549.87 0.00 82,384.79 34.92 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 11,723.05 0.00 6,325.95 35.05 10-540-502020 Group Health Insurance 20,506.66 11,577.38 0.00 8,929.28 43.54 10-540-502030 Retirement 30,199.64 18,395.90 0.00 11,803.74 39.09 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 165.24 0.00 124.85 43.04 10-540-502060 Long Term Disability 569.01 421.94 0.00 147.07 25.85 10-540-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 E05 Personnel Services 305,833.81 196,083.29 0.00 109,750.52 35.89 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 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 27.82 0.00 972.18 97.22 10-540-514010 Gas 104,350.00 47,036.47 0.00 57,313.53 54.92 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 1,025.80 0.00 -825.80 -412.90 10-540-517010 Operational Supplies 300.00 79.99 0.00 220.01 73.34 E10 Materials & Supplies 106,350.00 48,173.08 0.00 58,176.92 54.70 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 2,000.00 0.00 0.00 2,000.00 100.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 3,000.00 744.90 0.00 2,255.10 75.17 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 305.00 224.50 96.23 -15.73 -5.16 E25 Repairs & Maintenance 305.00 224.50 96.23 -15.73 -5.16 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 415,488.81 245,225.77 96.23 170,166.81 40.9558 Grand Total -415,488.81 -245,225.77 -96.23 -170,166.81 0.4096 540 Public Works-Admin 415,488.81 245,225.77 96.23 170,166.81 40.96 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 526,720.71 0.00 333,457.33 38.77 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 400.00 3,553.66 0.00 -3,153.66 -788.42 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 38,519.31 0.00 27,314.91 41.49 10-541-502020 Group Health Insurance 132,614.06 85,173.86 0.00 47,440.20 35.77 10-541-502030 Retirement 110,153.99 66,872.10 0.00 43,281.89 39.29 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 629.36 0.00 425.73 40.35 10-541-502060 Long Term Disability 2,488.48 1,663.54 0.00 824.94 33.15 10-541-502070 Employee Assistance Prgm 262.08 122.76 0.00 139.32 53.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,041.68 729,311.02 0.00 449,730.66 38.14 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 29.39 0.00 370.61 92.65 10-541-512010 Printing 0.00 41.00 0.00 -41.00 0.00 10-541-512020 Copies 0.00 0.43 0.00 -0.43 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 484.19 0.00 1,165.81 70.66 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 539.30 0.00 460.70 46.07 10-541-515080 Surveying Supplies 1,500.00 156.75 0.00 1,343.25 89.55 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 3,160.04 0.00 4,189.96 57.01 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,545.00 0.00 955.00 38.20 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,337.00 0.00 2,663.00 38.04 10-541-534010 Telephone 500.00 269.52 0.00 230.48 46.10 E20 Utilities 500.00 269.52 0.00 230.48 46.10 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 0.00 0.00 1,500.00 100.00 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-547020 Maintenance Agreements 10,665.00 8,585.67 684.90 1,394.43 13.07 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 10,195.67 684.90 3,284.43 23.19 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,208,056.68 747,273.25 684.90 460,098.53 38.0858 Grand Total -1,208,056.68 -747,273.25 -684.90 -460,098.53 0.3809 541 Public Works-Engineering 1,208,056.68 747,273.25 684.90 460,098.53 38.09 542 Public Works-Street 10-542-501020 Salaries 1,373,894.56 796,652.06 0.00 577,242.50 42.02 10-542-501024 Salaries-Stormwater 0.00 11,078.11 0.00 -11,078.11 0.00 10-542-501060 Seasonal Salaries 20,000.00 5,280.00 0.00 14,720.00 73.60 10-542-501070 Stand-by Plan 5,000.00 6,166.25 0.00 -1,166.25 -23.33 10-542-501090 Overtime 30,000.00 9,024.77 0.00 20,975.23 69.92 10-542-501095 Overtime Straight Pay 500.00 1,457.92 0.00 -957.92 -191.58 10-542-502010 Social Security 109,348.68 61,021.11 0.00 48,327.57 44.20 10-542-502020 Group Health Insurance 304,688.92 162,838.86 0.00 141,850.06 46.56 10-542-502030 Retirement 180,402.50 102,171.71 0.00 78,230.79 43.36 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 946.17 0.00 738.05 43.82 10-542-502060 Long Term Disability 4,165.34 2,505.70 0.00 1,659.64 39.84 10-542-502070 Employee Assistance Prgm 622.44 291.54 0.00 330.90 53.16 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,069,617.50 1,198,545.04 0.00 871,072.46 42.09 10-542-511010 Advertising 750.00 58.75 0.00 691.25 92.17 10-542-511020 Postage 150.00 1.41 0.00 148.59 99.06 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,400.00 478.35 0.00 921.65 65.83 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 295,000.00 135,261.70 0.00 159,738.30 54.15 10-542-514030 Small Tools 9,000.00 9,362.18 0.00 -362.18 -4.02 10-542-514040 Food 2,000.00 596.58 0.00 1,403.42 70.17 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 225,000.00 165,718.33 0.00 59,281.67 26.35 10-542-515040 First Aid Supplies 500.00 161.22 0.00 338.78 67.76 10-542-515060 Weed Control 2,000.00 1,142.41 0.00 857.59 42.88 10-542-515070 Const & Inspect Supplies 200.00 89.80 0.00 110.20 55.10 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-517010 Operational Supplies 6,500.00 7,811.47 0.00 -1,311.47 -20.18 E10 Materials & Supplies 542,600.00 320,682.62 0.00 221,917.38 40.90 10-542-520030 Dues And Publications 1,320.00 477.00 0.00 843.00 63.86 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 8,584.40 0.00 -904.40 -11.78 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,500.00 10,382.25 0.00 4,117.75 28.40 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,700.00 19,443.65 0.00 4,256.35 17.96 10-542-531010 Electricity 24,364.00 13,234.58 0.00 11,129.42 45.68 10-542-531020 Street Lights 593,000.00 370,751.95 0.00 222,248.05 37.48 10-542-533010 Natural Gas 10,000.00 11,966.02 0.00 -1,966.02 -19.66 10-542-534010 Telephone 580.00 1,579.87 0.00 -999.87 -172.39 10-542-535010 Water 12,390.00 2,575.25 0.00 9,814.75 79.22 E20 Utilities 640,334.00 400,107.67 0.00 240,226.33 37.52 10-542-540010 Building & Grounds Maint.10,000.00 8,305.12 150.00 1,544.88 15.45 10-542-541030 Vehicle Wash 7,000.00 6,642.00 0.00 358.00 5.11 10-542-542010 Repairs - StopStreet Lights 35,000.00 11,045.40 0.00 23,954.60 68.44 10-542-542030 Signs & Marking Paint 60,000.00 34,249.86 16,780.92 8,969.22 14.95 10-542-546010 Clothing Expense 13,000.00 9,745.97 0.00 3,254.03 25.03 10-542-547010 Equipment Maintenance 3,200.00 809.32 0.00 2,390.68 74.71 10-542-547020 Maintenance Agreements 360.00 208.20 208.20 -56.40 -15.67 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 71,005.87 17,139.12 41,415.01 31.97 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,421,811.50 2,025,162.38 17,139.12 1,379,510.00 40.3152 Grand Total -3,421,811.50 -2,025,162.38 -17,139.12 -1,379,510.00 0.4032 542 Public Works-Street 3,421,811.50 2,025,162.38 17,139.12 1,379,510.00 40.32 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 91,200.16 91,200.16 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,189,132.88 1,189,132.88 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,306,661.06 1,287,015.25 0.00 19,645.81 1.50 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,306,661.06 1,287,015.25 0.00 19,645.81 1.5035 Grand Total -1,306,661.06 -1,287,015.25 0.00 -19,645.81 0.015 700 Transfers & Subsidies 1,306,661.06 1,287,015.25 0.00 19,645.81 1.50 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 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 0.00 0.00 175,000.00 100.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 0.00 0.00 925,000.00 100.00 10-990-540060 Cemetery Maintenance 30,000.00 0.00 0.00 30,000.00 100.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 0.00 425,000.00 100.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 2,130.42 927.75 -3,058.17 0.00 10-990-576025 Douglas Davis Stormwater 125,267.16 68,556.54 6,710.62 50,000.00 39.91 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 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 0.00 0.00 150,000.00 100.00 10-990-599505 PD Elevator Replacement 200,000.00 0.00 200,000.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 185,940.24 1,314,059.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 662,783.20 1,619,698.13 6,418,967.83 73.77 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 662,783.20 1,619,698.13 7,343,967.83 76.2895 Grand Total -9,626,449.16 -662,783.20 -1,619,698.13 -7,343,967.83 0.7629 990 Capital Projects 9,626,449.16 662,783.20 1,619,698.13 7,343,967.83 76.29 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 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 62,396,992.88 24,295,703.43 2,066,549.39 36,034,740.06 57.75 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 62,396,992.88 24,295,703.43 2,066,549.39 36,034,740.06 57.7508 Grand Total -62,396,992.88 -24,295,703.43 -2,066,549.39 -36,034,740.06 0.5775 GL - Trial Balance by Acct Type and Full Acct Number (06/16/2023 - 09:44 AM)Page 42