The URL can be used to link to this page

Home My Public Portal About2023-02 NO Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 2/20/2023 8:43: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 16,200.00 0.00 49,725.00 75.43 10-110-501015 Salary-Prosecuting Attorney 34,999.92 8,749.98 0.00 26,249.94 75.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 1,626.28 0.00 14,972.12 90.20 10-110-502010 Social Security 8,990.53 1,906.10 0.00 7,084.43 78.80 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 28,553.95 0.00 98,031.49 77.44 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 15.39 0.00 84.61 84.61 10-110-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-110-512020 Copies 96.00 0.00 0.00 96.00 100.00 10-110-513010 Office Supplies 1,435.00 26.49 0.00 1,408.51 98.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 41.88 0.00 1,989.12 97.94 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 481.98 0.00 1,018.02 67.87 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 1,089.84 0.00 0.00 1,089.84 100.00 10-110-520070 Training & Education 100.00 540.00 0.00 -440.00 -440.00 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 6,854.84 7,523.90 0.00 -669.06 -9.76 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 (02/20/2023 - 08:43 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,287.00 0.00 -1,287.00 0.00 E70 Capital Purchases 0.00 1,287.00 0.00 -1,287.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 135,595.28 37,468.62 61.90 98,064.76 72.3217 Grand Total -135,595.28 -37,468.62 -61.90 -98,064.76 0.7232 110 Mayor & Council 135,595.28 37,468.62 61.90 98,064.76 72.32 120 City Clerk 10-120-501020 Salaries 56,948.36 15,113.10 0.00 41,835.26 73.46 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 1,069.45 0.00 3,287.10 75.45 10-120-502020 Group Health Insurance 13,245.50 3,077.07 0.00 10,168.43 76.77 10-120-502030 Retirement 7,289.39 1,934.48 0.00 5,354.91 73.46 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 16.52 0.00 53.25 76.32 10-120-502060 Long Term Disability 174.26 43.17 0.00 131.09 75.23 10-120-502070 Employee Assistance Prgm 21.84 5.11 0.00 16.73 76.60 E05 Personnel Services 82,155.66 21,308.89 0.00 60,846.77 74.06 10-120-511020 Postage 200.00 95.80 0.00 104.20 52.10 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 131.61 0.00 168.39 56.13 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 292.00 0.00 408.00 58.29 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 140.00 0.00 260.00 65.00 10-120-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-120-529030 Election Expense 18,579.79 43.50 0.00 18,536.29 99.77 E15 Contractual Services 19,254.79 198.50 0.00 19,056.29 98.97 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 23,164.28 61.90 89,559.27 79.4068 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -23,164.28 -61.90 -89,559.27 0.7941 120 City Clerk 112,785.45 23,164.28 61.90 89,559.27 79.41 140 City Administrator 10-140-501020 Salaries 213,221.32 56,461.17 0.00 156,760.15 73.52 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 2,778.78 0.00 13,532.65 82.96 10-140-502020 Group Health Insurance 21,732.71 5,047.39 0.00 16,685.32 76.78 10-140-502030 Retirement 27,292.33 7,227.03 0.00 20,065.30 73.52 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 33.07 0.00 80.76 70.95 10-140-502060 Long Term Disability 374.04 118.05 0.00 255.99 68.44 10-140-502070 Employee Assistance Prgm 43.68 10.23 0.00 33.45 76.58 E05 Personnel Services 279,290.56 71,876.94 0.00 207,413.62 74.26 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 18.33 0.00 131.67 87.78 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 7.25 0.00 142.75 95.17 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 86.87 0.00 591.87 87.20 E10 Materials & Supplies 1,603.74 379.17 0.00 1,224.57 76.36 10-140-520030 Dues And Publications 1,700.00 1,133.00 0.00 567.00 33.35 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 100.00 0.00 600.00 85.71 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 0.00 0.00 0.00 0.00 E15 Contractual Services 2,400.00 1,233.00 0.00 1,167.00 48.63 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 63.38 61.90 174.72 58.24 E25 Repairs & Maintenance 300.00 63.38 61.90 174.72 58.24 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 73,552.49 61.90 209,979.91 74.0424 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -73,552.49 -61.90 -209,979.91 0.7404 140 City Administrator 283,594.30 73,552.49 61.90 209,979.91 74.04 143 CDBG-CV Compass Health 10-143-501020 Salaries 14,000.00 1,143.53 0.00 12,856.47 91.83 10-143-502010 Social Security 0.00 78.38 0.00 -78.38 0.00 10-143-502020 Group Health Insurance 0.00 288.90 0.00 -288.90 0.00 10-143-502030 Retirement 0.00 146.36 0.00 -146.36 0.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 0.00 1.28 0.00 -1.28 0.00 10-143-502060 Long Term Disability 0.00 3.48 0.00 -3.48 0.00 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 1,661.93 0.00 12,338.07 88.13 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 1,661.93 0.00 112,338.07 98.5422 Grand Total -114,000.00 -1,661.93 0.00 -112,338.07 0.9854 143 CDBG-CV Compass Health 114,000.00 1,661.93 0.00 112,338.07 98.54 144 CDBG-DR 10-144-501020 Salaries 282,372.00 4,677.52 0.00 277,694.48 98.34 10-144-502010 Social Security 0.00 340.81 0.00 -340.81 0.00 10-144-502020 Group Health Insurance 0.00 898.10 0.00 -898.10 0.00 10-144-502030 Retirement 0.00 598.72 0.00 -598.72 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 5.13 0.00 -5.13 0.00 10-144-502060 Long Term Disability 0.00 13.73 0.00 -13.73 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 6,534.01 0.00 275,837.99 97.69 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 6,534.01 0.00 7,302,765.99 99.9106 Grand Total -7,309,300.00 -6,534.01 0.00 -7,302,765.99 0.9991 144 CDBG-DR 7,309,300.00 6,534.01 0.00 7,302,765.99 99.91 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 40,200.63 2,871.94 0.00 37,328.69 92.86 10-145-502010 Social Security 840.81 199.01 0.00 641.80 76.33 10-145-502020 Group Health Insurance 2,491.43 669.87 0.00 1,821.56 73.11 10-145-502030 Retirement 1,406.85 367.62 0.00 1,039.23 73.87 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 3.01 0.00 10.57 77.84 10-145-502060 Long Term Disability 33.34 7.79 0.00 25.55 76.63 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 4,127.58 0.00 40,872.42 90.83 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 4,127.58 0.00 1,995,872.42 99.7936 Grand Total -2,000,000.00 -4,127.58 0.00 -1,995,872.42 0.9979 145 CDBG-CV Cole Co EMS Station 2,000,000.00 4,127.58 0.00 1,995,872.42 99.79 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 9,710.28 4,543.24 0.00 5,167.04 53.21 10-146-502010 Social Security 742.84 314.72 0.00 428.12 57.63 10-146-502020 Group Health Insurance 2,201.13 1,023.12 0.00 1,178.01 53.52 10-146-502030 Retirement 1,242.92 581.54 0.00 661.38 53.21 10-146-502040 Workers Compensation 7.37 7.37 0.00 0.00 0.00 10-146-502050 Life Insurance 12.00 4.86 0.00 7.14 59.50 10-146-502060 Long Term Disability 29.46 12.85 0.00 16.61 56.38 10-146-502070 Employee Assistance Prgm 4.44 0.00 0.00 4.44 100.00 E05 Personnel Services 13,950.44 6,487.70 0.00 7,462.74 53.49 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 355.76 0.00 0.00 355.76 100.00 E15 Contractual Services 355.76 0.00 0.00 355.76 100.00 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 6,487.70 0.00 682,398.50 99.0582 Grand Total -688,886.20 -6,487.70 0.00 -682,398.50 0.9906 146 HPF-P Bruhn Revitalization 688,886.20 6,487.70 0.00 682,398.50 99.06 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 1,885.78 0.00 26,585.60 93.38 10-147-502010 Social Security 576.14 131.45 0.00 444.69 77.18 10-147-502020 Group Health Insurance 1,707.17 390.97 0.00 1,316.20 77.10 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-502030 Retirement 964.00 241.39 0.00 722.61 74.96 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 1.99 0.00 7.31 78.60 10-147-502060 Long Term Disability 22.85 5.13 0.00 17.72 77.55 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 2,662.43 0.00 29,097.57 91.62 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 2,662.43 0.00 573,097.57 99.5376 Grand Total -575,760.00 -2,662.43 0.00 -573,097.57 0.9954 147 CDBG-CV Transform Housing 575,760.00 2,662.43 0.00 573,097.57 99.54 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 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 16,871.32 0.00 43,091.00 71.86 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,906.32 16,871.32 1,362.22 61,672.78 77.18 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 82,872.16 16,871.32 1,362.22 64,638.62 77.998 Grand Total -82,872.16 -16,871.32 -1,362.22 -64,638.62 0.78 148 CDBG-CV 82,872.16 16,871.32 1,362.22 64,638.62 78.00 149 Entitlement Grant 10-149-501020 Salaries 47,175.14 8,442.63 0.00 38,732.51 82.10 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502010 Social Security 3,608.91 585.65 0.00 3,023.26 83.77 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 1,995.30 0.00 8,698.37 81.34 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 6,038.44 1,080.63 0.00 4,957.81 82.10 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 10.15 0.00 48.13 82.58 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 26.17 0.00 116.95 81.71 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 7.67 0.00 13.89 64.42 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 12,184.01 0.00 55,590.92 82.02 10-149-511010 Advertising 1,400.00 151.75 0.00 1,248.25 89.16 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 0.00 0.00 70.00 100.00 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 0.00 0.00 250.00 100.00 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 151.75 0.00 1,668.25 91.66 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 81.00 0.00 39,919.00 99.80 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 5,130.00 0.00 134,870.00 96.34 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 107,000.00 313,000.00 0.00 -206,000.00 -192.52 10-149-528035 CARES-ED For-Profit Business 610,442.02 0.00 0.00 610,442.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 27.00 0.00 39,973.00 99.93 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 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 318,265.00 0.00 640,202.02 66.79 10-149-547020 Maintenance Agreements 0.00 62.39 0.00 -62.39 0.00 E25 Repairs & Maintenance 0.00 62.39 0.00 -62.39 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 330,663.15 0.00 697,398.80 67.8363 Grand Total -1,028,061.95 -330,663.15 0.00 -697,398.80 0.6784 149 Entitlement Grant 1,028,061.95 330,663.15 0.00 697,398.80 67.84 150 City Attorney 10-150-501020 Salaries 233,777.84 61,345.47 0.00 172,432.37 73.76 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 4,531.76 0.00 13,352.24 74.66 10-150-502020 Group Health Insurance 35,360.71 7,987.71 0.00 27,373.00 77.41 10-150-502030 Retirement 29,923.56 7,852.23 0.00 22,071.33 73.76 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 67.56 0.00 218.86 76.41 10-150-502060 Long Term Disability 607.87 164.25 0.00 443.62 72.98 10-150-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 318,136.71 82,195.11 0.00 235,941.60 74.16 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 67.43 0.00 532.57 88.76 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 6.87 0.00 -6.87 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 111.46 0.00 1,763.54 94.06 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 8,500.00 981.90 0.00 7,518.10 88.45 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,100.00 2,115.00 0.00 2,985.00 58.53 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 8,500.00 29.00 0.00 8,471.00 99.66 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 4,641.45 0.00 -4,641.45 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 22,600.00 7,767.35 0.00 14,832.65 65.63 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 61.90 61.90 247.20 66.63 E25 Repairs & Maintenance 371.00 61.90 61.90 247.20 66.63 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 90,135.82 61.90 252,784.99 73.702 Grand Total -342,982.71 -90,135.82 -61.90 -252,784.99 0.737 150 City Attorney 342,982.71 90,135.82 61.90 252,784.99 73.70 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 8,749.98 0.00 26,249.94 75.00 10-160-501020 Salaries 124,730.18 33,058.73 0.00 91,671.45 73.50 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 1,521.29 0.00 5,478.71 78.27 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 3,256.39 0.00 9,574.96 74.62 10-160-502020 Group Health Insurance 25,616.32 7,285.36 0.00 18,330.96 71.56 10-160-502030 Retirement 16,093.46 4,245.17 0.00 11,848.29 73.62 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 35.95 0.00 117.05 76.50 10-160-502060 Long Term Disability 381.67 93.84 0.00 287.83 75.41 10-160-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 223,069.59 58,566.70 0.00 164,502.89 73.75 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 391.23 0.00 1,608.77 80.44 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 194.47 0.00 2,305.53 92.22 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 585.70 0.00 4,314.30 88.05 10-160-520025 Security 12,500.00 1,021.65 0.00 11,478.35 91.83 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 180.00 0.00 2,320.00 92.80 10-160-522020 Professional Services 4,500.00 0.00 0.00 4,500.00 100.00 10-160-525005 Appointed Counsel 3,000.00 157.50 0.00 2,842.50 94.75 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 1,359.15 0.00 21,430.85 94.04 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 920.00 0.00 5,375.00 85.39 E25 Repairs & Maintenance 6,295.00 920.00 0.00 5,375.00 85.39 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 61,431.55 0.00 195,623.04 76.1017 Grand Total -257,054.59 -61,431.55 0.00 -195,623.04 0.761 160 Municipal Court 257,054.59 61,431.55 0.00 195,623.04 76.10 170 Human Resources 10-170-501020 Salaries 229,300.24 60,838.72 0.00 168,461.52 73.47 10-170-501050 Parttime(wo Benefits)13,000.00 4,791.71 0.00 8,208.29 63.14 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.82 0.00 -46.82 -46.82 10-170-501095 Overtime Straight Pay 0.00 30.59 0.00 -30.59 0.00 10-170-502010 Social Security 18,543.62 4,951.60 0.00 13,592.02 73.30 10-170-502020 Group Health Insurance 25,708.58 5,930.66 0.00 19,777.92 76.93 10-170-502030 Retirement 29,363.23 7,810.01 0.00 21,553.22 73.40 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 66.38 0.00 213.92 76.32 10-170-502060 Long Term Disability 589.14 161.68 0.00 427.46 72.56 10-170-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 317,276.32 85,069.20 0.00 232,207.12 73.19 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 55.05 0.00 244.95 81.65 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 186.76 0.00 313.24 62.65 10-170-513010 Office Supplies 600.00 29.12 0.00 570.88 95.15 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 336.37 0.00 2,593.63 88.52 10-170-520030 Dues And Publications 700.00 240.00 0.00 460.00 65.71 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 589.58 0.00 2,410.42 80.35 10-170-520070 Training And Education 4,437.00 43.44 0.00 4,393.56 99.02 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 0.00 0.00 500.00 100.00 10-170-522020 Professional Services 11,600.00 54.30 9,500.00 2,045.70 17.64 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 936.90 9,500.00 10,600.10 50.39 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,307.55 61.90 32,369.16 61.38 E25 Repairs & Maintenance 52,738.61 20,307.55 61.90 32,369.16 61.38 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 393,981.93 106,650.02 9,561.90 277,770.01 70.5032 Grand Total -393,981.93 -106,650.02 -9,561.90 -277,770.01 0.705 170 Human Resources 393,981.93 106,650.02 9,561.90 277,770.01 70.50 180 Finance Department 10-180-501020 Salaries 570,708.35 125,348.59 0.00 445,359.76 78.04 10-180-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 43,659.19 9,417.25 0.00 34,241.94 78.43 10-180-502020 Group Health Insurance 96,970.17 18,019.80 0.00 78,950.37 81.42 10-180-502030 Retirement 73,050.67 16,044.76 0.00 57,005.91 78.04 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 130.44 0.00 573.36 81.47 10-180-502060 Long Term Disability 1,743.45 338.50 0.00 1,404.95 80.58 10-180-502070 Employee Assistance Prgm 234.78 43.77 0.00 191.01 81.36 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 787,569.24 169,841.91 0.00 617,727.33 78.43 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 10,000.00 3,139.77 0.00 6,860.23 68.60 10-180-511021 Mail Machine Cost 3,000.00 1,334.53 0.00 1,665.47 55.52 10-180-512010 Printing 3,000.00 834.80 0.00 2,165.20 72.17 10-180-512020 Copies 1,000.00 12.64 0.00 987.36 98.74 10-180-512021 Copy Machine Cost 190.00 -346.52 0.00 536.52 282.38 10-180-513010 Office Supplies 1,250.00 149.45 0.00 1,100.55 88.04 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 0.00 0.00 3,655.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 23,095.00 5,124.67 0.00 17,970.33 77.81 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 555.00 0.00 4,895.00 89.82 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 6,364.12 0.00 54,217.52 89.49 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 0.00 0.00 150.00 100.00 E15 Contractual Services 72,840.64 9,767.12 0.00 63,073.52 86.59 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 12,500.00 0.00 1,620.00 11.47 E25 Repairs & Maintenance 14,120.00 12,500.00 0.00 1,620.00 11.47 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 200,157.05 0.00 701,678.28 77.8056 Grand Total -901,835.33 -200,157.05 0.00 -701,678.28 0.7781 180 Finance Department 901,835.33 200,157.05 0.00 701,678.28 77.81 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 -13.69 0.00 4,213.69 100.33 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 399,178.69 34,545.23 0.00 364,633.46 91.35 10-185-514010 Gas 20,000.00 5,044.11 0.00 14,955.89 74.78 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 0.00 0.00 44,119.17 100.00 E10 Materials & Supplies 64,119.17 5,044.11 0.00 59,075.06 92.13 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 481,601.50 360,501.88 0.00 121,099.62 25.15 10-185-521020 Insurance Deductible 25,000.00 27,527.97 0.00 -2,527.97 -10.11 10-185-521030 Self Ins Prop & Casualty 40,000.00 0.00 0.00 40,000.00 100.00 10-185-521060 Drugalcohol screening 3,564.00 1,586.00 0.00 1,978.00 55.50 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 17,697.00 44,691.00 -588.00 -0.95 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,256.20 0.00 3,743.80 74.88 E15 Contractual Services 848,965.50 501,069.05 44,691.00 303,205.45 35.71 10-185-531010 Electricity 32,000.00 6,272.26 0.00 25,727.74 80.40 10-185-533010 Natural Gas 6,200.00 2,797.44 0.00 3,402.56 54.88 10-185-535010 Water 7,250.00 1,987.88 0.00 5,262.12 72.58 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 11,057.58 0.00 34,392.42 75.67 10-185-540010 Building & Grounds Maint.40,000.00 23,487.24 0.00 16,512.76 41.28 10-185-540015 Amtrak Station 4,000.00 651.37 0.00 3,348.63 83.72 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 760.00 0.00 1,300.00 63.11 E25 Repairs & Maintenance 71,060.00 49,898.61 0.00 21,161.39 29.78 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 51,631.59 310,945.00 88,984.17 19.71 E30 Other Operating Expenses 464,360.76 63,831.11 310,945.00 89,584.65 19.29 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 83,519.80 0.00 -83,519.80 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 83,519.80 0.00 -83,519.80 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 748,965.49 355,636.00 788,532.63 41.6522 Grand Total -1,893,134.12 -748,965.49 -355,636.00 -788,532.63 0.4165 185 Non-Departmental 1,893,134.12 748,965.49 355,636.00 788,532.63 41.65 190 Information Technology Svcs 10-190-501020 Salaries 606,371.81 154,324.13 0.00 452,047.68 74.55 10-190-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 500.00 0.00 0.00 500.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 46,425.69 11,449.45 0.00 34,976.24 75.34 10-190-502020 Group Health Insurance 96,814.24 18,813.54 0.00 78,000.70 80.57 10-190-502030 Retirement 77,679.59 18,340.65 0.00 59,338.94 76.39 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 158.27 0.00 585.92 78.73 10-190-502060 Long Term Disability 1,815.32 417.95 0.00 1,397.37 76.98 10-190-502070 Employee Assistance Prgm 207.48 48.59 0.00 158.89 76.58 E05 Personnel Services 831,916.53 204,910.79 0.00 627,005.74 75.37 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 0.67 0.00 9.33 93.30 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 82.74 0.00 417.26 83.45 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 1,290.19 0.00 709.81 35.49 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 2,660.00 1,427.60 0.00 1,232.40 46.33 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 0.00 0.00 150.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 0.00 0.00 8,500.00 100.00 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 9,000.00 4,800.00 0.00 4,200.00 46.67 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 23,000.00 7,277.69 0.00 15,722.31 68.36 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 0.00 0.00 4,400.00 100.00 E15 Contractual Services 45,050.00 12,077.69 0.00 32,972.31 73.19 10-190-534010 Telephone 96,000.00 17,943.11 0.00 78,056.89 81.31 E20 Utilities 96,000.00 17,943.11 0.00 78,056.89 81.31 10-190-545010 Software License\maint 182,000.00 148,066.11 0.00 33,933.89 18.64 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 9,812.00 0.00 12,188.00 55.40 10-190-547025 Coun Chamber MediaEquip Repr 0.00 114.99 0.00 -114.99 0.00 E25 Repairs & Maintenance 204,000.00 157,993.10 0.00 46,006.90 22.55 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,179,626.53 394,352.29 0.00 785,274.24 66.5697 Grand Total -1,179,626.53 -394,352.29 0.00 -785,274.24 0.6657 190 Information Technology Svcs 1,179,626.53 394,352.29 0.00 785,274.24 66.57 300 Police Department 10-300-501020 Salaries 5,457,482.75 1,301,194.49 0.00 4,156,288.26 76.16 10-300-501030 Holiday Pay 169,092.64 66,292.53 0.00 102,800.11 60.80 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 8,182.58 0.00 37,675.43 82.16 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 2,913.30 0.00 2,086.70 41.73 10-300-501090 Overtime 285,142.77 93,157.59 0.00 191,985.18 67.33 10-300-501095 Overtime Straight Pay 13,275.00 4,497.71 0.00 8,777.29 66.12 10-300-502010 Social Security 444,750.67 107,847.38 0.00 336,903.29 75.75 10-300-502020 Group Health Insurance 960,547.52 200,629.29 0.00 759,918.23 79.11 10-300-502030 Retirement 1,009,334.34 249,421.63 0.00 759,912.71 75.29 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 1,329.57 0.00 5,212.71 79.68 10-300-502060 Long Term Disability 15,894.91 3,462.76 0.00 12,432.15 78.21 10-300-502070 Employee Assistance Prgm 1,960.14 462.90 0.00 1,497.24 76.38 10-300-503010 Awards Program 2,500.00 0.00 0.00 2,500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,532,659.27 2,114,477.67 0.00 6,418,181.60 75.22 10-300-511010 Advertising 5,665.00 3,762.25 0.00 1,902.75 33.59 10-300-511020 Postage 1,395.00 476.11 0.00 918.89 65.87 10-300-512010 Printing 5,952.00 160.00 0.00 5,792.00 97.31 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 6,863.87 989.15 7,817.48 49.89 10-300-514010 Gas 188,862.00 46,025.58 0.00 142,836.42 75.63 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 524.35 0.00 126.65 19.45 10-300-515040 First Aid Supplies 1,378.00 601.55 0.00 776.45 56.35 10-300-516010 Ammunition & Firearms Supplies 63,136.25 34,544.54 25,421.00 3,170.71 5.02 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 13,258.05 4,041.00 28,978.95 62.62 E10 Materials & Supplies 344,272.75 117,571.37 30,451.15 196,250.23 57.00 10-300-520030 Dues And Publications 5,400.00 2,439.40 0.00 2,960.60 54.83 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 17,920.88 0.00 58,079.12 76.42 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 205.74 0.00 1,081.26 84.01 10-300-521040 Medical Claimsservices 6,510.00 2,770.00 0.00 3,740.00 57.45 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 14,279.00 0.00 1,721.00 10.76 10-300-522026 Drug Forfeiture - Justice 29,750.00 0.00 9,000.00 20,750.00 69.75 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 12,086.00 0.00 -12,086.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 0.00 0.00 2,046.00 100.00 E15 Contractual Services 148,618.00 49,808.02 9,000.00 89,809.98 60.43 10-300-531010 Electricity 44,640.00 12,059.81 0.00 32,580.19 72.98 10-300-533010 Natural Gas 1,116.00 405.00 0.00 711.00 63.71 10-300-534010 Telephone 24,101.00 2,282.39 0.00 21,818.61 90.53 10-300-535010 Water 3,348.00 493.39 0.00 2,854.61 85.26 E20 Utilities 73,205.00 15,240.59 0.00 57,964.41 79.18 10-300-540010 Building & Grounds Maint.37,200.00 26,150.74 0.00 11,049.26 29.70 10-300-541030 Vehicle Wash 9,752.00 5,717.00 0.00 4,035.00 41.38 10-300-544010 K-9 Operations 16,740.00 4,432.88 880.35 11,426.77 68.26 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 292.00 0.00 27,658.00 98.96 10-300-545010 Software License\maint 82,414.00 63,156.11 0.00 19,257.89 23.37 10-300-546010 Clothing Expense 48,920.00 3,220.37 0.00 45,699.63 93.42 10-300-546020 Uniform Cleaning 23,715.00 6,246.51 0.00 17,468.49 73.66 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 25,350.58 4,697.40 26,200.02 46.58 10-300-547030 Radio Maintenance 8,025.00 96.88 0.00 7,928.12 98.79 E25 Repairs & Maintenance 320,964.00 136,020.89 5,577.75 179,365.36 55.88 10-300-572010 Purchase Of Vehicles 0.00 2,037.52 0.00 -2,037.52 0.00 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 8,575.00 0.00 0.00 8,575.00 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 46,750.00 46,750.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 3,070.05 0.00 0.00 3,070.05 100.00 10-300-572090 Body Worn Cameras 180,000.00 0.00 0.00 180,000.00 100.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 238,395.05 48,787.52 0.00 189,607.53 79.54 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,658,114.07 2,481,906.06 45,028.90 7,131,179.11 73.8361 Grand Total -9,658,114.07 -2,481,906.06 -45,028.90 -7,131,179.11 0.7384 300 Police Department 9,658,114.07 2,481,906.06 45,028.90 7,131,179.11 73.84 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-501020 Salaries 489,893.97 105,414.34 0.00 384,479.63 78.48 10-310-501030 Holiday Pay 20,720.19 0.00 0.00 20,720.19 100.00 10-310-501090 Overtime 45,106.00 20,906.62 0.00 24,199.38 53.65 10-310-501095 Overtime Straight Pay 1,311.00 1,283.86 0.00 27.14 2.07 10-310-502010 Social Security 42,612.88 9,231.20 0.00 33,381.68 78.34 10-310-502020 Group Health Insurance 89,715.43 17,982.90 0.00 71,732.53 79.96 10-310-502030 Retirement 100,265.61 22,968.87 0.00 77,296.74 77.09 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 103.86 0.00 499.57 82.79 10-310-502060 Long Term Disability 1,498.63 271.63 0.00 1,227.00 81.87 10-310-502070 Employee Assistance Prgm 174.72 40.92 0.00 133.80 76.58 E05 Personnel Services 798,454.72 184,757.06 0.00 613,697.66 76.86 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 0.00 0.00 15,345.00 100.00 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 0.00 0.00 22,340.00 100.00 10-310-520070 Training And Education 4,650.00 0.00 0.00 4,650.00 100.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 0.00 0.00 4,650.00 100.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 0.00 959.20 5,014.80 83.94 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 690.00 0.00 -330.00 -91.67 E25 Repairs & Maintenance 6,334.00 690.00 959.20 4,684.80 73.96 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 185,447.06 959.20 645,372.46 77.5894 Grand Total -831,778.72 -185,447.06 -959.20 -645,372.46 0.7759 310 School Resource Officer 831,778.72 185,447.06 959.20 645,372.46 77.59 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 33,836.10 0.00 93,770.86 73.48 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 8,992.41 0.00 20,425.81 69.43 10-320-501095 Overtime Straight Pay 0.00 110.48 0.00 -110.48 0.00 10-320-502010 Social Security 11,037.18 3,155.51 0.00 7,881.67 71.41 10-320-502020 Group Health Insurance 20,462.81 4,705.69 0.00 15,757.12 77.00 10-320-502030 Retirement 25,969.83 7,729.00 0.00 18,240.83 70.24 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 33.29 0.00 122.16 78.58 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502060 Long Term Disability 384.75 86.59 0.00 298.16 77.49 10-320-502070 Employee Assistance Prgm 43.68 10.23 0.00 33.45 76.58 E05 Personnel Services 222,402.83 60,663.69 0.00 161,739.14 72.72 10-320-514010 Gas 7,500.00 2,125.02 0.00 5,374.98 71.67 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 5,755.00 0.00 9,351.00 61.90 10-320-517010 Operational Supplies 3,994.28 600.00 0.00 3,394.28 84.98 E10 Materials & Supplies 26,600.28 8,480.02 0.00 18,120.26 68.12 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 3,000.00 0.00 14,500.00 82.86 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 3,000.00 0.00 14,500.00 82.86 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 266,503.11 72,143.71 0.00 194,359.40 72.9295 Grand Total -266,503.11 -72,143.71 0.00 -194,359.40 0.7293 320 M.U.S.T.A.N.G.266,503.11 72,143.71 0.00 194,359.40 72.93 330 Animal Control 10-330-501020 Salaries 370,091.13 82,532.73 0.00 287,558.40 77.70 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 2,329.98 0.00 6,270.02 72.91 10-330-501090 Overtime 2,000.00 5,237.68 0.00 -3,237.68 -161.88 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 6,269.80 0.00 22,853.07 78.47 10-330-502020 Group Health Insurance 93,298.71 19,321.99 0.00 73,976.72 79.29 10-330-502030 Retirement 48,728.46 11,532.82 0.00 37,195.64 76.33 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 456.55 87.28 0.00 369.27 80.88 10-330-502060 Long Term Disability 1,117.06 230.99 0.00 886.07 79.32 10-330-502070 Employee Assistance Prgm 174.72 40.92 0.00 133.80 76.58 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 558,270.58 132,265.27 0.00 426,005.31 76.31 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 34.52 0.00 117.48 77.29 10-330-512010 Printing 1,860.00 371.06 0.00 1,488.94 80.05 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 193.98 0.00 1,387.02 87.73 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 188.44 0.00 34.56 15.50 10-330-515040 First Aid Supplies 295.00 0.00 0.00 295.00 100.00 10-330-517010 Operational Supplies 11,000.00 3,366.80 0.00 7,633.20 69.39 E10 Materials & Supplies 16,016.00 4,154.80 0.00 11,861.20 74.06 10-330-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 0.00 0.00 2,611.00 100.00 10-330-521040 Medical Claimsservices 690.00 0.00 0.00 690.00 100.00 10-330-522020 Professional Services 4,830.00 482.80 0.00 4,347.20 90.00 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 26,800.00 4,580.00 0.00 22,220.00 82.91 E15 Contractual Services 41,039.00 6,174.69 0.00 34,864.31 84.95 10-330-531010 Electricity 22,789.00 5,673.11 0.00 17,115.89 75.11 10-330-533010 Natural Gas 21,000.00 5,435.81 0.00 15,564.19 74.12 10-330-534010 Telephone 810.00 197.35 0.00 612.65 75.64 10-330-535010 Water 3,800.00 896.30 0.00 2,903.70 76.41 E20 Utilities 48,399.00 12,202.57 0.00 36,196.43 74.79 10-330-540010 Building & Grounds Maint.15,000.00 1,270.24 0.00 13,729.76 91.53 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 12,376.55 0.00 36,913.45 74.89 10-330-544050 Animal Food 6,603.00 1,278.36 0.00 5,324.64 80.64 10-330-545010 Software Licensemaint 3,191.00 2,345.02 0.00 845.98 26.51 10-330-546010 Clothing Expense 2,325.00 766.20 0.00 1,558.80 67.05 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 0.00 0.00 360.00 100.00 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 0.00 0.00 1,750.00 100.00 E25 Repairs & Maintenance 79,374.00 18,576.37 0.00 60,797.63 76.60 10-330-572010 Purchase of Vehicles 26,800.00 1,600.00 0.00 25,200.00 94.03 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 26,800.00 1,600.00 0.00 25,200.00 94.03 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 769,898.58 174,973.70 0.00 594,924.88 77.2731 Grand Total -769,898.58 -174,973.70 0.00 -594,924.88 0.7727 330 Animal Control 769,898.58 174,973.70 0.00 594,924.88 77.27 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 217,806.10 0.00 863,346.41 79.85 10-390-501030 Holiday Pay 38,718.75 14,900.88 0.00 23,817.87 61.52 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 4,591.14 0.00 -4,591.14 0.00 10-390-501090 Overtime 22,814.00 27,064.37 0.00 -4,250.37 -18.63 10-390-501095 Overtime Straight Pay 1,850.00 440.27 0.00 1,409.73 76.20 10-390-502010 Social Security 87,556.95 19,566.29 0.00 67,990.66 77.65 10-390-502020 Group Health Insurance 223,648.25 35,186.52 0.00 188,461.73 84.27 10-390-502030 Retirement 152,546.30 29,147.69 0.00 123,398.61 80.89 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,332.94 213.06 0.00 1,119.88 84.02 10-390-502060 Long Term Disability 3,302.13 553.67 0.00 2,748.46 83.23 10-390-502070 Employee Assistance Prgm 480.48 108.69 0.00 371.79 77.38 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,616,122.27 352,298.64 0.00 1,263,823.63 78.20 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 0.00 2,279.40 4,520.60 66.48 E10 Materials & Supplies 8,200.00 0.00 2,279.40 5,920.60 72.20 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,650.00 1,392.00 0.00 4,258.00 75.36 10-390-522020 Professional Services 4,300.00 1,144.31 0.00 3,155.69 73.39 10-390-523010 Equipment Rentlease 99,260.00 20,283.98 0.00 78,976.02 79.56 E15 Contractual Services 109,768.00 22,820.29 0.00 86,947.71 79.21 10-390-531010 Electricity 11,160.00 0.00 0.00 11,160.00 100.00 10-390-533010 Natural Gas 279.00 0.00 0.00 279.00 100.00 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 0.00 0.00 837.00 100.00 E20 Utilities 12,276.00 0.00 0.00 12,276.00 100.00 10-390-545010 Software License\maint 51,200.00 40,284.10 0.00 10,915.90 21.32 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-546010 Clothing Expense 5,580.00 0.00 0.00 5,580.00 100.00 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 363.97 0.00 3,836.03 91.33 10-390-547020 Maintenance Agreements 75,000.00 12,316.64 265.68 62,417.68 83.22 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 52,964.71 265.68 90,375.61 62.93 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,889,972.27 428,083.64 2,545.08 1,459,343.55 77.2151 Grand Total -1,889,972.27 -428,083.64 -2,545.08 -1,459,343.55 0.7722 390 9-1-1 Police 1,889,972.27 428,083.64 2,545.08 1,459,343.55 77.22 400 Fire Department 10-400-501020 Salaries 4,989,033.59 1,076,338.88 0.00 3,912,694.71 78.43 10-400-501030 Holiday Pay 341,978.12 170,121.08 0.00 171,857.04 50.25 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 7,530.73 0.00 30,469.27 80.18 10-400-501090 Overtime 45,000.00 16,911.57 0.00 28,088.43 62.42 10-400-501095 Overtime Straight Pay 40,000.00 16,548.85 0.00 23,451.15 58.63 10-400-502010 Social Security 69,573.39 18,386.63 0.00 51,186.76 73.57 10-400-502020 Group Health Insurance 871,448.91 198,813.48 0.00 672,635.43 77.19 10-400-502030 Retirement 2,292,378.67 627,492.45 0.00 1,664,886.22 72.63 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 1,169.18 0.00 3,899.40 76.93 10-400-502060 Long Term Disability 12,419.68 3,023.64 0.00 9,396.04 75.65 10-400-502070 Employee Assistance Prgm 1,681.68 388.73 0.00 1,292.95 76.88 10-400-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 E05 Personnel Services 8,861,213.57 2,289,756.17 0.00 6,571,457.40 74.16 10-400-511010 Advertising 300.00 96.00 0.00 204.00 68.00 10-400-511020 Postage 120.00 99.95 0.00 20.05 16.71 10-400-512010 Printing 700.00 58.12 0.00 641.88 91.70 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 289.83 0.00 1,105.17 79.22 10-400-514010 Gas 61,175.00 20,942.13 0.00 40,232.87 65.77 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 2,817.08 0.00 3,182.92 53.05 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,788.30 0.00 311.70 14.84 10-400-517010 Operational Supplies 18,000.00 5,049.32 35.00 12,915.68 71.75 E10 Materials & Supplies 90,740.00 31,140.73 35.00 59,564.27 65.64 10-400-520030 Dues And Publications 3,400.00 2,050.55 0.00 1,349.45 39.69 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,000.00 17,273.11 0.00 14,726.89 46.02 10-400-520080 Tuition Reimbursement 7,500.00 3,510.00 0.00 3,990.00 53.20 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,085.00 0.00 35,915.00 89.79 10-400-522020 Professional Services 3,000.00 0.00 0.00 3,000.00 100.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 2,933.63 0.00 2,066.37 41.33 10-400-529040 Child Safety Seat Pass-through 2,500.00 220.00 0.00 2,280.00 91.20 E15 Contractual Services 93,593.00 30,072.29 0.00 63,520.71 67.87 10-400-531010 Electricity 35,000.00 7,756.94 0.00 27,243.06 77.84 10-400-533010 Natural Gas 17,670.00 12,323.12 0.00 5,346.88 30.26 10-400-534010 Telephone 25,984.20 5,138.81 0.00 20,845.39 80.22 10-400-535010 Water 12,000.00 2,548.32 0.00 9,451.68 78.76 E20 Utilities 90,654.20 27,767.19 0.00 62,887.01 69.37 10-400-540010 Building & Grounds Maint.90,000.00 6,157.92 850.00 82,992.08 92.21 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 22,475.17 0.00 72,524.83 76.34 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,000.00 4,623.15 0.00 15,376.85 76.88 10-400-547020 Maintenance Agreements 39,487.50 17,345.76 335.04 21,806.70 55.22 10-400-547030 Radio Maintenance 20,925.00 3,854.21 0.00 17,070.79 81.58 E25 Repairs & Maintenance 265,912.50 54,456.21 1,185.04 210,271.25 79.08 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 3,593.04 0.00 -2,093.04 -139.54 10-400-572021 Purchase of Equipment-ONE TIME 141,576.18 14,905.11 21,337.00 105,334.07 74.40 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 143,076.18 18,498.15 21,337.00 103,241.03 72.16 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,545,189.45 2,451,690.74 22,557.04 7,070,941.67 74.0786 Grand Total -9,545,189.45 -2,451,690.74 -22,557.04 -7,070,941.67 0.7408 400 Fire Department 9,545,189.45 2,451,690.74 22,557.04 7,070,941.67 74.08 401 Fire Museum 10-401-531010 Electricity 1,700.00 971.09 0.00 728.91 42.88 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 971.09 0.00 728.91 42.88 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 971.09 0.00 728.91 42.8771 Grand Total -1,700.00 -971.09 0.00 -728.91 0.4288 401 Fire Museum 1,700.00 971.09 0.00 728.91 42.88 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 62,668.61 0.00 177,536.85 73.91 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 4,582.76 0.00 13,792.96 75.06 10-520-502020 Group Health Insurance 52,232.32 11,766.84 0.00 40,465.48 77.47 10-520-502030 Retirement 30,746.30 8,021.66 0.00 22,724.64 73.91 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 66.52 0.00 229.69 77.54 10-520-502060 Long Term Disability 636.77 161.93 0.00 474.84 74.57 10-520-502070 Employee Assistance Prgm 87.36 15.34 0.00 72.02 82.44 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 342,777.04 87,480.56 0.00 255,296.48 74.48 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 24.57 0.00 50.43 67.24 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 130.05 0.00 719.95 84.70 10-520-514010 Gas 12,975.00 3,354.75 0.00 9,620.25 74.14 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 0.00 0.00 500.00 100.00 E10 Materials & Supplies 14,500.00 4,531.95 0.00 9,968.05 68.75 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 3,537.80 0.00 -537.80 -17.93 E15 Contractual Services 6,000.00 4,676.86 0.00 1,323.14 22.05 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 30,716.93 74.40 -1,702.32 -5.85 E25 Repairs & Maintenance 29,089.01 30,716.93 74.40 -1,702.32 -5.85 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 392,366.05 127,406.30 74.40 264,885.35 67.5098 Grand Total -392,366.05 -127,406.30 -74.40 -264,885.35 0.6751 520 Plan & Protect Svcs-Admin 392,366.05 127,406.30 74.40 264,885.35 67.51 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 26,459.56 0.00 24,949.22 48.53 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 1,978.85 0.00 1,953.92 49.68 10-521-502020 Group Health Insurance 9,239.72 4,120.19 0.00 5,119.53 55.41 10-521-502030 Retirement 6,580.32 3,386.71 0.00 3,193.61 48.53 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 28.98 0.00 33.44 53.57 10-521-502060 Long Term Disability 156.03 75.21 0.00 80.82 51.80 10-521-502070 Employee Assistance Prgm 15.29 13.81 0.00 1.48 9.68 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 71,553.68 36,221.66 0.00 35,332.02 49.38 10-521-511010 Advertising 3,336.00 705.75 0.00 2,630.25 78.84 10-521-511020 Postage 500.00 35.00 0.00 465.00 93.00 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 136.79 0.00 663.21 82.90 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 131.99 0.00 1,368.01 91.20 E10 Materials & Supplies 6,336.00 1,009.53 0.00 5,326.47 84.07 10-521-520030 Dues And Publications 13,220.00 99.00 0.00 13,121.00 99.25 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 99.00 0.00 14,621.00 99.33 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 347.73 728.99 194.28 15.29 E25 Repairs & Maintenance 1,271.00 347.73 728.99 194.28 15.29 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 37,677.92 728.99 55,473.77 59.0897 Grand Total -93,880.68 -37,677.92 -728.99 -55,473.77 0.5909 521 Plan & Protect Svcs-Planning 93,880.68 37,677.92 728.99 55,473.77 59.09 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 18,847.15 0.00 111,540.79 85.55 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 1,423.98 0.00 8,550.70 85.72 10-522-502020 Group Health Insurance 20,902.54 2,431.51 0.00 18,471.03 88.37 10-522-502030 Retirement 16,689.66 2,412.55 0.00 14,277.11 85.54 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 20.14 0.00 140.90 87.49 10-522-502060 Long Term Disability 397.13 52.29 0.00 344.84 86.83 10-522-502070 Employee Assistance Prgm 50.23 11.76 0.00 38.47 76.59 E05 Personnel Services 178,665.77 25,301.93 0.00 153,363.84 85.84 10-522-511010 Advertising 2,600.00 180.00 0.00 2,420.00 93.08 10-522-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.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 0.00 0.00 300.00 100.00 10-522-517010 Operational Supplies 1,000.00 31.23 0.00 968.77 96.88 E10 Materials & Supplies 5,600.00 211.23 0.00 5,388.77 96.23 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 16,945.00 35,973.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 17,180.97 35,973.60 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 460.76 646.51 1,292.73 53.86 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 460.76 646.51 1,292.73 53.86 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 43,154.89 36,620.11 199,290.77 71.4136 Grand Total -279,065.77 -43,154.89 -36,620.11 -199,290.77 0.7141 522 Plan & Protect Svcs-MPO 279,065.77 43,154.89 36,620.11 199,290.77 71.41 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 24,224.92 0.00 60,250.36 71.32 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 1,790.03 0.00 6,906.16 79.42 10-530-502020 Group Health Insurance 25,767.93 3,814.63 0.00 21,953.30 85.20 10-530-502030 Retirement 14,550.48 3,100.73 0.00 11,449.75 78.69 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 25.27 0.00 115.17 82.01 10-530-502060 Long Term Disability 344.86 64.25 0.00 280.61 81.37 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 33,112.81 0.00 101,000.63 75.31 10-530-511010 Advertising 540.00 54.00 0.00 486.00 90.00 10-530-511020 Postage 150.00 4.56 0.00 145.44 96.96 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 9.99 0.00 100.01 90.92 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 107.99 0.00 472.01 81.38 E10 Materials & Supplies 1,380.00 176.54 0.00 1,203.46 87.21 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,000.00 147.63 0.00 1,852.37 92.62 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,931.19 0.00 7,068.81 37.20 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 22,078.82 0.00 41,036.70 65.02 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-547020 Maintenance Agreements 672.02 196.89 374.91 100.22 14.91 E25 Repairs & Maintenance 672.02 196.89 374.91 100.22 14.91 10-530-550020 NRA-Residential 40,000.00 18,006.44 0.00 21,993.56 54.98 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 2,750.00 20,194.25 87.80 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 26.00 0.00 1,174.00 97.83 10-530-550039 Historic Preservation Grant 50,000.00 67.50 2,750.00 47,182.50 94.37 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 21,275.63 5,500.00 121,924.37 81.99 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 347,980.98 76,840.69 5,874.91 265,265.38 76.2299 Grand Total -347,980.98 -76,840.69 -5,874.91 -265,265.38 0.7623 530 Plan & Protect Svc-RedevGrant 347,980.98 76,840.69 5,874.91 265,265.38 76.23 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 194,879.84 51,632.51 0.00 143,247.33 73.51 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 3,669.28 0.00 11,239.03 75.39 10-532-502020 Group Health Insurance 39,644.71 9,295.25 0.00 30,349.46 76.55 10-532-502030 Retirement 24,944.62 6,608.97 0.00 18,335.65 73.51 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 52.96 0.00 185.72 77.81 10-532-502060 Long Term Disability 592.66 146.92 0.00 445.74 75.21 10-532-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 279,027.76 75,174.65 0.00 203,853.11 73.06 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 37.65 0.00 112.35 74.90 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 0.00 1,300.00 100.00 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 2,625.00 37.65 0.00 2,587.35 98.57 10-532-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 201,600.00 50,400.00 151,200.00 0.00 0.00 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 50,400.00 151,200.00 2,500.00 1.22 10-532-534010 Telephone 1,200.00 247.44 0.00 952.56 79.38 E20 Utilities 1,200.00 247.44 0.00 952.56 79.38 10-532-540060 Cemetery Maintenance 37,750.00 9,185.82 27,567.00 997.18 2.64 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 0.00 0.00 1,080.00 100.00 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 180.66 330.33 399.01 43.85 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 10,650.48 27,897.33 2,522.19 6.14 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 136,510.22 179,097.33 212,415.21 40.2284 Grand Total -528,022.76 -136,510.22 -179,097.33 -212,415.21 0.4023 532 Plan & Protect Svcs-Env Health 528,022.76 136,510.22 179,097.33 212,415.21 40.23 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 164,815.30 53,742.72 0.00 111,072.58 67.39 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-501050 Parttime(wo Benefits)20,000.00 0.00 0.00 20,000.00 100.00 10-533-501060 Seasonal Salaries 0.00 6,135.71 0.00 -6,135.71 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 4,468.21 0.00 9,670.11 68.40 10-533-502020 Group Health Insurance 30,239.78 6,618.44 0.00 23,621.34 78.11 10-533-502030 Retirement 21,096.27 5,424.29 0.00 15,671.98 74.29 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 41.68 0.00 162.13 79.55 10-533-502060 Long Term Disability 505.89 121.22 0.00 384.67 76.04 10-533-502070 Employee Assistance Prgm 65.52 17.90 0.00 47.62 72.68 E05 Personnel Services 253,322.27 78,827.55 0.00 174,494.72 68.88 10-533-511010 Advertising 100.00 52.44 0.00 47.56 47.56 10-533-511020 Postage 1,800.00 464.34 0.00 1,335.66 74.20 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 512.85 0.00 487.15 48.72 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 229.62 0.00 1,120.38 82.99 E10 Materials & Supplies 4,690.00 1,259.25 0.00 3,430.75 73.15 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 0.00 0.00 1,200.00 100.00 10-533-520080 Tuition Reimbursement 0.00 2,629.50 0.00 -2,629.50 0.00 10-533-522019 Demo-Grant Funded 78,457.55 0.00 43,780.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 2,562.80 0.00 7,437.20 74.37 10-533-522022 Demo 83,433.60 10,726.70 0.00 72,706.90 87.14 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 173,591.15 16,087.00 43,780.00 113,724.15 65.51 10-533-534010 Telephone 3,701.40 1,054.20 0.00 2,647.20 71.52 E20 Utilities 3,701.40 1,054.20 0.00 2,647.20 71.52 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 0.00 0.00 1,280.00 100.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 295.32 569.27 406.41 31.98 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 565.32 569.27 1,716.41 60.20 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 438,155.82 97,793.32 44,349.27 296,013.23 67.5589 Grand Total -438,155.82 -97,793.32 -44,349.27 -296,013.23 0.6756 533 PPS - Prop MaintCode Enforce 438,155.82 97,793.32 44,349.27 296,013.23 67.56 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 81,050.28 0.00 224,457.48 73.47 10-534-501050 Parttime(wo Benefits)15,900.00 0.00 0.00 15,900.00 100.00 10-534-501060 Seasonal Salaries 0.00 3,368.06 0.00 -3,368.06 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 5,931.18 0.00 18,656.51 75.88 10-534-502020 Group Health Insurance 79,982.22 18,455.60 0.00 61,526.62 76.93 10-534-502030 Retirement 39,104.99 10,374.41 0.00 28,730.58 73.47 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 88.66 0.00 285.88 76.33 10-534-502060 Long Term Disability 929.35 230.55 0.00 698.80 75.19 10-534-502070 Employee Assistance Prgm 109.20 30.69 0.00 78.51 71.90 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 471,251.82 124,285.50 0.00 346,966.32 73.63 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 92.25 0.00 1,007.75 91.61 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 232.87 0.00 667.13 74.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 695.96 0.00 3,419.04 83.09 10-534-520030 Dues And Publications 2,500.00 534.00 0.00 1,966.00 78.64 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 3,140.34 0.00 1,859.66 37.19 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 3,674.34 0.00 3,825.66 51.01 10-534-534010 Telephone 3,060.00 563.20 0.00 2,496.80 81.59 E20 Utilities 3,060.00 563.20 0.00 2,496.80 81.59 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,400.00 160.00 0.00 1,240.00 88.57 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 988.00 379.10 611.96 -3.06 -0.31 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 809.10 611.96 1,256.94 46.94 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 130,028.10 611.96 357,964.76 73.2626 Grand Total -488,604.82 -130,028.10 -611.96 -357,964.76 0.7326 534 Plan & Protect Svcs-Bldg Regs 488,604.82 130,028.10 611.96 357,964.76 73.26 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 102,282.46 0.00 283,168.78 73.46 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,201.87 0.00 3,298.13 73.29 10-535-501095 Overtime Straight Pay 500.00 24.47 0.00 475.53 95.11 10-535-502010 Social Security 30,175.52 7,591.71 0.00 22,583.81 74.84 10-535-502020 Group Health Insurance 79,635.09 18,563.63 0.00 61,071.46 76.69 10-535-502030 Retirement 49,977.76 13,249.05 0.00 36,728.71 73.49 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 111.83 0.00 360.63 76.33 10-535-502060 Long Term Disability 1,177.64 291.66 0.00 885.98 75.23 10-535-502070 Employee Assistance Prgm 152.88 35.80 0.00 117.08 76.58 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 560,511.95 147,821.84 0.00 412,690.11 73.63 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 1.17 0.00 48.83 97.66 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 654.78 0.00 345.22 34.52 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 976.25 0.00 5,023.75 83.73 10-535-517010 Operational Supplies 6,000.00 2,569.33 0.00 3,430.67 57.18 E10 Materials & Supplies 13,140.00 4,218.03 0.00 8,921.97 67.90 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 1,429.82 0.00 5,130.18 78.20 10-535-533010 Natural Gas 3,000.00 1,882.99 0.00 1,117.01 37.23 10-535-534010 Telephone 220.00 93.69 0.00 126.31 57.41 10-535-535010 Water 1,442.00 321.55 0.00 1,120.45 77.70 E20 Utilities 11,222.00 3,728.05 0.00 7,493.95 66.78 10-535-540010 Building & Grounds Maint.10,000.00 3,124.74 52.50 6,822.76 68.23 10-535-541010 Veh & Equip Parts Etc 393,400.00 4,370.89 15,567.13 373,461.98 94.93 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 3,442.40 0.00 5,557.60 61.75 10-535-547010 Equipment Maintenance 1,000.00 99.73 284.19 616.08 61.61 10-535-547020 Maintenance Agreements 17,251.00 4,223.35 0.00 13,027.65 75.52 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 15,261.11 15,903.82 399,586.07 92.76 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,017,974.95 171,409.93 15,903.82 830,661.20 81.5994 Grand Total -1,017,974.95 -171,409.93 -15,903.82 -830,661.20 0.816 535 Public Works-Central Maintenan 1,017,974.95 171,409.93 15,903.82 830,661.20 81.60 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 62,600.21 0.00 173,334.45 73.47 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 4,783.75 0.00 13,265.25 73.50 10-540-502020 Group Health Insurance 20,506.66 4,956.85 0.00 15,549.81 75.83 10-540-502030 Retirement 30,199.64 8,012.79 0.00 22,186.85 73.47 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 69.04 0.00 221.05 76.20 10-540-502060 Long Term Disability 569.01 162.04 0.00 406.97 71.52 10-540-502070 Employee Assistance Prgm 65.52 15.34 0.00 50.18 76.59 E05 Personnel Services 305,833.81 80,819.25 0.00 225,014.56 73.57 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 2.40 0.00 197.60 98.80 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 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 104,350.00 27,766.58 0.00 76,583.42 73.39 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 106,350.00 27,768.98 0.00 78,581.02 73.89 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 0.00 200.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,000.00 684.40 0.00 2,315.60 77.19 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 117.24 203.45 -15.69 -5.14 E25 Repairs & Maintenance 305.00 117.24 203.45 -15.69 -5.14 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 109,389.87 203.45 305,895.49 73.623 Grand Total -415,488.81 -109,389.87 -203.45 -305,895.49 0.7362 540 Public Works-Admin 415,488.81 109,389.87 203.45 305,895.49 73.62 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 225,201.54 0.00 634,976.50 73.82 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 2,188.01 0.00 -1,788.01 -447.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 16,610.73 0.00 49,223.49 74.77 10-541-502020 Group Health Insurance 132,614.06 32,651.59 0.00 99,962.47 75.38 10-541-502030 Retirement 110,153.99 27,932.87 0.00 82,221.12 74.64 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 247.26 0.00 807.83 76.57 10-541-502060 Long Term Disability 2,488.48 629.83 0.00 1,858.65 74.69 10-541-502070 Employee Assistance Prgm 262.08 61.38 0.00 200.70 76.58 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,041.68 311,578.93 0.00 867,462.75 73.57 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 0.81 0.00 399.19 99.80 10-541-512010 Printing 0.00 41.00 0.00 -41.00 0.00 10-541-512020 Copies 0.00 0.08 0.00 -0.08 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 106.33 0.00 1,543.67 93.56 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 266.04 0.00 733.96 73.40 10-541-515080 Surveying Supplies 1,500.00 70.00 0.00 1,430.00 95.33 10-541-517010 Operational Supplies 2,000.00 876.22 0.00 1,123.78 56.19 E10 Materials & Supplies 7,350.00 1,360.48 0.00 5,989.52 81.49 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,425.00 0.00 1,075.00 43.00 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,217.00 0.00 2,783.00 39.76 10-541-534010 Telephone 500.00 104.56 0.00 395.44 79.09 E20 Utilities 500.00 104.56 0.00 395.44 79.09 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 10-541-547020 Maintenance Agreements 10,665.00 407.04 686.36 9,571.60 89.75 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 2,017.04 686.36 11,461.60 80.91 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 319,278.01 686.36 888,092.31 73.5141 Grand Total -1,208,056.68 -319,278.01 -686.36 -888,092.31 0.7351 541 Public Works-Engineering 1,208,056.68 319,278.01 686.36 888,092.31 73.51 542 Public Works-Street 10-542-501020 Salaries 1,373,894.56 306,855.96 0.00 1,067,038.60 77.67 10-542-501024 Salaries-Stormwater 0.00 37,866.75 0.00 -37,866.75 0.00 10-542-501060 Seasonal Salaries 20,000.00 0.00 0.00 20,000.00 100.00 10-542-501070 Stand-by Plan 5,000.00 2,390.40 0.00 2,609.60 52.19 10-542-501090 Overtime 30,000.00 6,485.54 0.00 23,514.46 78.38 10-542-501095 Overtime Straight Pay 500.00 1,008.32 0.00 -508.32 -101.66 10-542-502010 Social Security 109,348.68 26,179.98 0.00 83,168.70 76.06 10-542-502020 Group Health Insurance 304,688.92 63,044.59 0.00 241,644.33 79.31 10-542-502030 Retirement 180,402.50 43,908.95 0.00 136,493.55 75.66 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 368.91 0.00 1,315.31 78.10 10-542-502060 Long Term Disability 4,165.34 948.76 0.00 3,216.58 77.22 10-542-502070 Employee Assistance Prgm 622.44 145.77 0.00 476.67 76.58 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,069,617.50 528,314.77 0.00 1,541,302.73 74.47 10-542-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-542-511020 Postage 150.00 0.57 0.00 149.43 99.62 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 70,473.71 0.00 224,526.29 76.11 10-542-514030 Small Tools 9,000.00 5,023.28 0.00 3,976.72 44.19 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 66,285.85 0.00 158,714.15 70.54 10-542-515040 First Aid Supplies 500.00 161.22 0.00 338.78 67.76 10-542-515060 Weed Control 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 6,500.00 1,880.50 0.00 4,619.50 71.07 E10 Materials & Supplies 542,600.00 144,900.48 0.00 397,699.52 73.30 10-542-520030 Dues And Publications 1,320.00 452.00 0.00 868.00 65.76 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 4,027.11 0.00 3,652.89 47.56 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,500.00 1,000.20 0.00 13,499.80 93.10 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 5,479.31 0.00 18,220.69 76.88 10-542-531010 Electricity 24,364.00 6,253.64 0.00 18,110.36 74.33 10-542-531020 Street Lights 593,000.00 157,611.28 0.00 435,388.72 73.42 10-542-533010 Natural Gas 10,000.00 6,663.94 0.00 3,336.06 33.36 10-542-534010 Telephone 580.00 588.23 0.00 -8.23 -1.42 10-542-535010 Water 12,390.00 1,203.68 0.00 11,186.32 90.29 E20 Utilities 640,334.00 172,320.77 0.00 468,013.23 73.09 10-542-540010 Building & Grounds Maint.10,000.00 3,319.02 210.00 6,470.98 64.71 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 1,861.71 0.00 33,138.29 94.68 10-542-542030 Signs & Marking Paint 60,000.00 389.41 0.00 59,610.59 99.35 10-542-546010 Clothing Expense 13,000.00 6,089.48 0.00 6,910.52 53.16 10-542-547010 Equipment Maintenance 3,200.00 684.67 0.00 2,515.33 78.60 10-542-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 18,986.29 210.00 110,363.71 85.18 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,405,811.50 870,001.62 210.00 2,535,599.88 74.4492 Grand Total -3,405,811.50 -870,001.62 -210.00 -2,535,599.88 0.7445 542 Public Works-Street 3,405,811.50 870,001.62 210.00 2,535,599.88 74.45 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 26,328.02 6,682.21 0.00 19,645.81 74.62 10-700-590051 Trans to Parks 0.00 0.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 0.00 0.00 0.00 0.00 0.00 10-700-590053 Trans to Parking 0.00 0.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 0.00 0.00 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 0.00 0.00 0.00 0.00 0.00 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,000.00 0.00 0.00 6,000.00 100.00 10-990-575023 Fire Station 4 Rehab 992.53 0.00 0.00 992.53 100.00 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.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 75,267.16 35,859.72 39,407.44 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 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 1,500,000.00 0.00 0.00 1,500,000.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599507 Hyde Park Burn Bldg 300,000.00 0.00 0.00 300,000.00 100.00 E75 Capital Projects 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.29 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.2905 Grand Total -2,111,503.35 -37,990.14 -40,335.19 -2,033,178.02 0.9629 990 Capital Projects 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.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 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 30,000.00 0.00 0.00 30,000.00 100.00 E25 Repairs & Maintenance 30,000.00 0.00 0.00 30,000.00 100.00 10-995-599501 JCCVB Lost Revenue 175,000.00 0.00 0.00 175,000.00 100.00 10-995-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-995-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 775,000.00 0.00 0.00 775,000.00 100.00 10-995-572010 Purchase of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 10-995-572020 Purchase of Equipment 19,500.00 3,175.24 10,320.00 6,004.76 30.79 E70 Capital Purchases 86,956.00 51,223.17 27,554.42 8,178.41 9.41 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 80,000.00 0.00 0.00 80,000.00 100.00 10-995-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-995-576007 Stormwater Improvements 540,917.60 31,305.75 0.00 509,611.85 94.21 10-995-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599503 Organizational Review Study 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599505 PD Elevator Replacement 200,000.00 0.00 200,000.00 0.00 0.00 10-995-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599507 Hyde Park Burn Bldg 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599508 High Street Viaduct 1,077,827.75 3,352.25 0.00 1,074,475.50 99.69 10-995-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-995-599510 Demolitions 100,000.00 41,003.62 18,400.00 40,596.38 40.60 10-995-599512 Street Resurfacing 276,509.44 270,702.36 5,798.64 8.44 0.00 E75 Capital Projects 4,995,889.79 346,363.98 224,198.64 4,425,327.17 88.58 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 5,887,845.79 397,587.15 251,753.06 5,238,505.58 88.9715 Grand Total -5,887,845.79 -397,587.15 -251,753.06 -5,238,505.58 0.8897 995 ARPA 5,887,845.79 397,587.15 251,753.06 5,238,505.58 88.97 Expense Expense 58,184,045.77 11,742,185.14 1,014,346.74 45,427,513.89 78.08 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 58,184,045.77 11,742,185.14 1,014,346.74 45,427,513.89 78.0756 Grand Total -58,184,045.77 -11,742,185.14 -1,014,346.74 -45,427,513.89 0.7808 GL - Trial Balance by Acct Type and Full Acct Number (02/20/2023 - 08:43 AM)Page 41