Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2023-07 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 7/17/2023 4:19:34 PM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 43,650.00 0.00 22,275.00 33.79 10-110-501015 Salary-Prosecuting Attorney 34,999.92 23,333.28 0.00 11,666.64 33.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 4,417.48 0.00 12,180.92 73.39 10-110-502010 Social Security 8,990.53 5,290.63 0.00 3,699.90 41.15 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 126,585.44 76,762.98 0.00 49,822.46 39.36 10-110-511010 Advertising 0.00 79.75 0.00 -79.75 0.00 10-110-511020 Postage 100.00 31.59 0.00 68.41 68.41 10-110-512010 Printing 400.00 242.00 0.00 158.00 39.50 10-110-512020 Copies 96.00 0.04 0.00 95.96 99.96 10-110-513010 Office Supplies 1,435.00 1,486.21 0.00 -51.21 -3.57 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,031.00 1,839.59 0.00 191.41 9.42 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 153,784.95 0.00 -153,784.95 0.00 10-110-520025 Security 1,500.00 971.26 0.00 528.74 35.25 10-110-520030 Dues And Publications 4,165.00 6,501.92 0.00 -2,336.92 -56.11 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,189.84 870.00 0.00 319.84 26.88 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 6,854.84 162,128.13 0.00 -155,273.29 -2,265.16 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 124.00 92.84 30.95 0.21 0.17 E25 Repairs & Maintenance 124.00 92.84 30.95 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,796.88 0.00 -1,796.88 0.00 E70 Capital Purchases 0.00 1,796.88 0.00 -1,796.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 135,595.28 242,620.42 30.95 -107,056.09 -78.9527 Grand Total -135,595.28 -242,620.42 -30.95 107,056.09 -0.7895 110 Mayor & Council 135,595.28 242,620.42 30.95 -107,056.09 -78.95 120 City Clerk 10-120-501020 Salaries 56,948.36 39,797.72 0.00 17,150.64 30.12 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,356.55 2,817.05 0.00 1,539.50 35.34 10-120-502020 Group Health Insurance 13,245.50 8,547.72 0.00 4,697.78 35.47 10-120-502030 Retirement 7,289.39 5,094.13 0.00 2,195.26 30.12 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 45.02 0.00 24.75 35.47 10-120-502060 Long Term Disability 174.26 120.77 0.00 53.49 30.70 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 82,155.66 56,482.62 0.00 25,673.04 31.25 10-120-511020 Postage 200.00 176.38 0.00 23.62 11.81 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 249.01 0.00 50.99 17.00 10-120-513010 Office Supplies 200.00 82.86 0.00 117.14 58.57 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 508.25 0.00 191.75 27.39 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 164.10 0.00 235.90 58.98 10-120-522020 Professional Services 200.00 95.67 0.00 104.33 52.17 10-120-529030 Election Expense 18,579.79 10,232.77 0.00 8,347.02 44.93 E15 Contractual Services 19,254.79 10,557.54 0.00 8,697.25 45.17 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,675.00 2,773.82 30.95 7,870.23 73.73 E25 Repairs & Maintenance 10,675.00 2,773.82 30.95 7,870.23 73.73 10-120-572020 Purchase Of Equipment 0.00 465.33 0.00 -465.33 0.00 E70 Capital Purchases 0.00 465.33 0.00 -465.33 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 112,785.45 70,787.56 30.95 41,966.94 37.2095 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -70,787.56 -30.95 -41,966.94 0.3721 120 City Clerk 112,785.45 70,787.56 30.95 41,966.94 37.21 140 City Administrator 10-140-501020 Salaries 213,221.32 131,782.38 0.00 81,438.94 38.19 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,311.43 7,643.51 0.00 8,667.92 53.14 10-140-502020 Group Health Insurance 21,732.71 11,173.15 0.00 10,559.56 48.59 10-140-502030 Retirement 27,292.33 20,022.90 0.00 7,269.43 26.64 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 91.52 0.00 22.31 19.60 10-140-502060 Long Term Disability 374.04 309.48 0.00 64.56 17.26 10-140-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 279,290.56 171,244.62 0.00 108,045.94 38.69 10-140-511010 Advertising 0.00 1,931.73 0.00 -1,931.73 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 52.53 0.00 97.47 64.98 10-140-513010 Office Supplies 525.00 298.37 0.00 226.63 43.17 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 622.18 0.00 56.56 8.33 E10 Materials & Supplies 1,603.74 2,930.34 0.00 -1,326.60 -82.72 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 330.00 0.00 370.00 52.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 75.01 0.00 -75.01 0.00 E15 Contractual Services 2,400.00 1,707.10 0.00 692.90 28.87 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 300.00 273.43 210.05 -183.48 -61.16 E25 Repairs & Maintenance 300.00 273.43 210.05 -183.48 -61.16 10-140-572020 Purchase Of Equipment 0.00 472.60 0.00 -472.60 0.00 E70 Capital Purchases 0.00 472.60 0.00 -472.60 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 283,594.30 176,628.09 210.05 106,756.16 37.644 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -176,628.09 -210.05 -106,756.16 0.3764 140 City Administrator 283,594.30 176,628.09 210.05 106,756.16 37.64 141 Local Tourism Asset Develop 10-141-501020 Salaries 82,499.00 0.00 0.00 82,499.00 100.00 10-141-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-141-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-141-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-141-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-141-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 82,499.00 0.00 0.00 82,499.00 100.00 10-141-520072 Subrecipient Reimbursements 2,062,476.00 0.00 0.00 2,062,476.00 100.00 E15 Contractual Services 2,062,476.00 0.00 0.00 2,062,476.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,144,975.00 0.00 0.00 2,144,975.00 100 Grand Total -2,144,975.00 0.00 0.00 -2,144,975.00 1 141 Local Tourism Asset Develop 2,144,975.00 0.00 0.00 2,144,975.00 100.00 142 Community Revitalization 10-142-501020 Salaries 81,276.00 0.00 0.00 81,276.00 100.00 10-142-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-142-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 0.00 0.00 81,276.00 100.00 10-142-522017 Rehabilitation 378,463.00 0.00 0.00 378,463.00 100.00 10-142-522018 Streetscaping 182,000.00 0.00 0.00 182,000.00 100.00 10-142-522021 Asbestos Abatement 291,574.00 0.00 0.00 291,574.00 100.00 10-142-522022 Demo 1,179,856.00 0.00 0.00 1,179,856.00 100.00 E15 Contractual Services 2,031,893.00 0.00 0.00 2,031,893.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,113,169.00 0.00 0.00 2,113,169.00 100 Grand Total -2,113,169.00 0.00 0.00 -2,113,169.00 1 142 Community Revitalization 2,113,169.00 0.00 0.00 2,113,169.00 100.00 143 CDBG-CV Compass Health 10-143-501020 Salaries 14,000.00 2,601.31 0.00 11,398.69 81.42 10-143-502010 Social Security 0.00 178.14 0.00 -178.14 0.00 10-143-502020 Group Health Insurance 0.00 661.61 0.00 -661.61 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 0.00 332.99 0.00 -332.99 0.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 0.00 2.99 0.00 -2.99 0.00 10-143-502060 Long Term Disability 0.00 8.12 0.00 -8.12 0.00 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 3,785.16 0.00 10,214.84 72.96 10-143-520072 Subrecipient Reimbursements 100,000.00 0.00 0.00 100,000.00 100.00 E15 Contractual Services 100,000.00 0.00 0.00 100,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,000.00 3,785.16 0.00 110,214.84 96.6797 Grand Total -114,000.00 -3,785.16 0.00 -110,214.84 0.9668 143 CDBG-CV Compass Health 114,000.00 3,785.16 0.00 110,214.84 96.68 144 CDBG-DR 10-144-501020 Salaries 282,372.00 19,473.22 0.00 262,898.78 93.10 10-144-502010 Social Security 0.00 1,440.84 0.00 -1,440.84 0.00 10-144-502020 Group Health Insurance 0.00 3,532.59 0.00 -3,532.59 0.00 10-144-502030 Retirement 0.00 2,492.57 0.00 -2,492.57 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 22.32 0.00 -22.32 0.00 10-144-502060 Long Term Disability 0.00 60.42 0.00 -60.42 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 27,021.96 0.00 255,350.04 90.43 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 27,021.96 0.00 7,282,278.04 99.6303 Grand Total -7,309,300.00 -27,021.96 0.00 -7,282,278.04 0.9963 144 CDBG-DR 7,309,300.00 27,021.96 0.00 7,282,278.04 99.63 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 40,200.63 10,024.87 0.00 30,175.76 75.06 10-145-502010 Social Security 840.81 681.30 0.00 159.51 18.97 10-145-502020 Group Health Insurance 2,491.43 2,509.85 0.00 -18.42 -0.74 10-145-502030 Retirement 1,406.85 1,283.17 0.00 123.68 8.79 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 11.02 0.00 2.56 18.85 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 29.22 0.00 4.12 12.36 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 14,547.77 0.00 30,452.23 67.67 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 14,547.77 0.00 1,985,452.23 99.2726 Grand Total -2,000,000.00 -14,547.77 0.00 -1,985,452.23 0.9927 145 CDBG-CV Cole Co EMS Station 2,000,000.00 14,547.77 0.00 1,985,452.23 99.27 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 0.00 20,558.57 0.00 -20,558.57 0.00 10-146-502010 Social Security 0.00 1,400.58 0.00 -1,400.58 0.00 10-146-502020 Group Health Insurance 0.00 5,447.81 0.00 -5,447.81 0.00 10-146-502030 Retirement 0.00 2,631.51 0.00 -2,631.51 0.00 10-146-502040 Workers Compensation 0.00 7.37 0.00 -7.37 0.00 10-146-502050 Life Insurance 0.00 24.95 0.00 -24.95 0.00 10-146-502060 Long Term Disability 0.00 66.83 0.00 -66.83 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 30,137.62 0.00 -30,137.62 0.00 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 355.76 201.00 0.00 154.76 43.50 E15 Contractual Services 355.76 201.00 0.00 154.76 43.50 10-146-550068 Pass-Through Grants 674,580.00 0.00 0.00 674,580.00 100.00 E65 Other Non-Operating Expenses 674,580.00 0.00 0.00 674,580.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 674,935.76 30,338.62 0.00 644,597.14 95.505 Grand Total -674,935.76 -30,338.62 0.00 -644,597.14 0.955 146 HPF-P Bruhn Revitalization 674,935.76 30,338.62 0.00 644,597.14 95.50 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 7,010.36 0.00 21,461.02 75.38 10-147-502010 Social Security 576.14 476.71 0.00 99.43 17.26 10-147-502020 Group Health Insurance 1,707.17 1,660.26 0.00 46.91 2.75 10-147-502030 Retirement 964.00 897.32 0.00 66.68 6.92 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 7.42 0.00 1.88 20.22 10-147-502060 Long Term Disability 22.85 19.70 0.00 3.15 13.79 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 10,077.49 0.00 21,682.51 68.27 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 10,077.49 0.00 565,682.51 98.2497 Grand Total -575,760.00 -10,077.49 0.00 -565,682.51 0.9825 147 CDBG-CV Transform Housing 575,760.00 10,077.49 0.00 565,682.51 98.25 148 CDBG-CV 10-148-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-148-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-148-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-148-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-148-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-148-528025 CARES-Childcare Services 19,944.00 0.00 0.00 19,944.00 100.00 10-148-528035 CARES-ED For-Profit Business 59,962.32 29,351.32 0.00 30,611.00 51.05 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,906.32 29,351.32 0.00 50,555.00 63.27 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 79,906.32 29,351.32 0.00 50,555.00 63.2678 Grand Total -79,906.32 -29,351.32 0.00 -50,555.00 0.6327 148 CDBG-CV 79,906.32 29,351.32 0.00 50,555.00 63.27 149 Entitlement Grant 10-149-501020 Salaries 47,175.14 19,694.59 0.00 27,480.55 58.25 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,608.91 1,402.64 0.00 2,206.27 61.13 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 10,693.67 4,126.75 0.00 6,566.92 61.41 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 6,038.44 2,520.99 0.00 3,517.45 58.25 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 35.81 35.81 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 22.56 0.00 35.72 61.29 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 59.87 0.00 83.25 58.17 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 15.34 0.00 6.22 28.85 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 27,878.55 0.00 39,896.38 58.87 10-149-511010 Advertising 1,400.00 1,031.25 0.00 368.75 26.34 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 102.54 0.00 -32.54 -46.49 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 250.00 23.65 0.00 226.35 90.54 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,820.00 1,157.44 0.00 662.56 36.40 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 40,000.00 4,110.00 0.00 35,890.00 89.73 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 36,093.00 0.00 103,907.00 74.22 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 313,000.00 0.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 404,442.02 0.00 0.00 404,442.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 54.00 0.00 39,946.00 99.87 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 20,000.00 27.00 0.00 19,973.00 99.87 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 958,467.02 353,284.00 0.00 605,183.02 63.14 10-149-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00 10-149-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 382,319.99 0.00 645,741.96 62.8116 Grand Total -1,028,061.95 -382,319.99 0.00 -645,741.96 0.6281 149 Entitlement Grant 1,028,061.95 382,319.99 0.00 645,741.96 62.81 150 City Attorney 10-150-501020 Salaries 233,777.84 160,078.08 0.00 73,699.76 31.53 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 11,848.52 0.00 6,035.48 33.75 10-150-502020 Group Health Insurance 35,360.71 21,342.09 0.00 14,018.62 39.64 10-150-502030 Retirement 29,923.56 19,997.64 0.00 9,925.92 33.17 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 171.81 0.00 114.61 40.01 10-150-502060 Long Term Disability 607.87 446.95 0.00 160.92 26.47 10-150-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 318,136.71 214,146.56 0.00 103,990.15 32.69 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 161.45 0.00 438.55 73.09 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 19.14 0.00 -19.14 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 217.75 0.00 1,657.25 88.39 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 6,522.79 2,493.70 2,272.43 20.13 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,255.00 4,740.63 0.00 1,514.37 24.21 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 4,556.08 57.68 0.00 4,498.40 98.73 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 56,815.96 0.00 -56,815.96 0.00 E15 Contractual Services 22,600.00 68,502.06 2,493.70 -48,395.76 -214.14 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 242.85 180.95 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 242.85 180.95 -52.80 -14.23 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 342,982.71 283,109.22 2,674.65 57,198.84 16.6769 Grand Total -342,982.71 -283,109.22 -2,674.65 -57,198.84 0.1668 150 City Attorney 342,982.71 283,109.22 2,674.65 57,198.84 16.68 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 23,333.28 0.00 11,666.64 33.33 10-160-501020 Salaries 124,730.18 91,656.89 0.00 33,073.29 26.52 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 3,740.85 0.00 3,259.15 46.56 10-160-501090 Overtime 1,000.00 106.48 0.00 893.52 89.35 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,831.35 8,948.03 0.00 3,883.32 30.26 10-160-502020 Group Health Insurance 25,616.32 15,345.27 0.00 10,271.05 40.10 10-160-502030 Retirement 16,093.46 11,745.79 0.00 4,347.67 27.02 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 98.45 0.00 54.55 35.65 10-160-502060 Long Term Disability 381.67 263.74 0.00 117.93 30.90 10-160-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 223,069.59 155,467.63 0.00 67,601.96 30.31 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,136.85 0.00 863.15 43.16 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 397.03 0.00 2,102.97 84.12 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 1,533.88 0.00 3,366.12 68.70 10-160-520025 Security 12,500.00 7,065.37 0.00 5,434.63 43.48 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 480.00 0.00 2,020.00 80.80 10-160-522020 Professional Services 4,500.00 57.33 0.00 4,442.67 98.73 10-160-525005 Appointed Counsel 3,000.00 707.50 0.00 2,292.50 76.42 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 22,790.00 8,310.20 0.00 14,479.80 63.54 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,163.20 658.20 473.60 7.52 E25 Repairs & Maintenance 6,295.00 5,163.20 658.20 473.60 7.52 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 170,474.91 658.20 85,921.48 33.4254 Grand Total -257,054.59 -170,474.91 -658.20 -85,921.48 0.3343 160 Municipal Court 257,054.59 170,474.91 658.20 85,921.48 33.43 170 Human Resources 10-170-501020 Salaries 229,300.24 163,834.41 0.00 65,465.83 28.55 10-170-501050 Parttime(wo Benefits)13,000.00 9,377.41 0.00 3,622.59 27.87 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.82 0.00 -46.82 -46.82 10-170-501095 Overtime Straight Pay 0.00 30.59 0.00 -30.59 0.00 10-170-502010 Social Security 18,543.62 13,031.61 0.00 5,512.01 29.72 10-170-502020 Group Health Insurance 25,708.58 16,386.76 0.00 9,321.82 36.26 10-170-502030 Retirement 29,363.23 20,778.42 0.00 8,584.81 29.24 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 179.88 0.00 100.42 35.83 10-170-502060 Long Term Disability 589.14 472.88 0.00 116.26 19.73 10-170-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 317,276.32 224,595.15 0.00 92,681.17 29.21 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 131.85 0.00 168.15 56.05 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 261.91 0.00 238.09 47.62 10-170-513010 Office Supplies 600.00 164.74 0.00 435.26 72.54 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 623.94 0.00 2,306.06 78.71 10-170-520030 Dues And Publications 700.00 249.98 0.00 450.02 64.29 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 1,282.93 0.00 1,717.07 57.24 10-170-520070 Training And Education 4,437.00 1,350.44 0.00 3,086.56 69.56 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 266.00 0.00 234.00 46.80 10-170-522020 Professional Services 11,600.00 9,582.98 0.00 2,017.02 17.39 10-170-529010 Special Events 800.00 9.58 0.00 790.42 98.80 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 12,741.91 0.00 8,295.09 39.43 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 52,738.61 20,734.80 210.05 31,793.76 60.29 E25 Repairs & Maintenance 52,738.61 20,734.80 210.05 31,793.76 60.29 10-170-572020 Purchase Of Equipment 3,175.24 3,175.24 0.00 0.00 0.00 E70 Capital Purchases 3,175.24 3,175.24 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 397,157.17 261,871.04 210.05 135,076.08 34.0107 Grand Total -397,157.17 -261,871.04 -210.05 -135,076.08 0.3401 170 Human Resources 397,157.17 261,871.04 210.05 135,076.08 34.01 180 Finance Department 10-180-501020 Salaries 570,708.35 337,777.99 0.00 232,930.36 40.81 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 25,286.12 0.00 18,373.07 42.08 10-180-502020 Group Health Insurance 96,970.17 51,616.50 0.00 45,353.67 46.77 10-180-502030 Retirement 73,050.67 41,637.08 0.00 31,413.59 43.00 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 372.32 0.00 331.48 47.10 10-180-502060 Long Term Disability 1,743.45 991.60 0.00 751.85 43.12 10-180-502070 Employee Assistance Prgm 234.78 87.54 0.00 147.24 62.71 10-180-503020 Unemployment Compensation 0.00 112.09 0.00 -112.09 0.00 E05 Personnel Services 787,569.24 458,380.04 0.00 329,189.20 41.80 10-180-511010 Advertising 1,000.00 164.00 0.00 836.00 83.60 10-180-511020 Postage 10,000.00 6,695.73 0.00 3,304.27 33.04 10-180-511021 Mail Machine Cost 3,000.00 1,512.37 0.00 1,487.63 49.59 10-180-512010 Printing 3,000.00 2,020.68 0.00 979.32 32.64 10-180-512020 Copies 1,000.00 23.68 0.00 976.32 97.63 10-180-512021 Copy Machine Cost 190.00 -249.52 181.96 257.56 135.56 10-180-513010 Office Supplies 1,250.00 201.63 0.00 1,048.37 83.87 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 185.58 0.00 3,469.42 94.92 E10 Materials & Supplies 23,095.00 10,554.15 181.96 12,358.89 53.51 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 65.75 0.00 1,889.25 96.64 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 1,899.66 0.00 3,550.34 65.14 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 4,704.00 2,808.00 0.00 1,896.00 40.31 10-180-522010 Audit 60,581.64 45,377.88 0.00 15,203.76 25.10 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 28.68 0.00 121.32 80.88 E15 Contractual Services 72,840.64 50,179.97 0.00 22,660.67 31.11 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 14,120.00 13,213.16 1,228.70 -321.86 -2.28 E25 Repairs & Maintenance 14,120.00 13,213.16 1,228.70 -321.86 -2.28 10-180-572020 Purchase Of Equipment 4,210.45 2,923.35 0.00 1,287.10 30.57 E70 Capital Purchases 4,210.45 2,923.35 0.00 1,287.10 30.57 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 901,835.33 535,250.67 1,410.66 365,174.00 40.4923 Grand Total -901,835.33 -535,250.67 -1,410.66 -365,174.00 0.4049 180 Finance Department 901,835.33 535,250.67 1,410.66 365,174.00 40.49 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 481.75 0.00 3,718.25 88.53 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 399,178.69 35,040.67 0.00 364,138.02 91.22 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 12,264.76 0.00 7,735.24 38.68 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 10-185-550034 National Opioid Settlement 44,119.17 570.00 0.00 43,549.17 98.71 E10 Materials & Supplies 64,119.17 12,834.76 0.00 51,284.41 79.98 10-185-520030 Dues and Publications 0.00 54.00 0.00 -54.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 481,601.50 497,327.60 0.00 -15,726.10 -3.27 10-185-521020 Insurance Deductible 25,000.00 88,827.40 0.00 -63,827.40 -255.31 10-185-521030 Self Ins Prop & Casualty 40,000.00 701.63 0.00 39,298.37 98.25 10-185-521060 Drugalcohol screening 3,564.00 1,909.00 0.00 1,655.00 46.44 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 61,800.00 40,593.00 23,895.00 -2,688.00 -4.35 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 138,750.00 0.00 46,250.00 25.00 10-185-529010 Special Events 5,000.00 2,126.06 0.00 2,873.94 57.48 E15 Contractual Services 848,965.50 770,288.69 23,895.00 54,781.81 6.45 10-185-531010 Electricity 32,000.00 14,596.55 0.00 17,403.45 54.39 10-185-533010 Natural Gas 6,200.00 5,054.89 0.00 1,145.11 18.47 10-185-535010 Water 7,250.00 3,733.83 0.00 3,516.17 48.50 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 23,385.27 0.00 22,064.73 48.55 10-185-540010 Building & Grounds Maint.40,000.00 42,137.80 0.00 -2,137.80 -5.34 10-185-540015 Amtrak Station 4,000.00 1,500.44 0.00 2,499.56 62.49 10-185-540020 Tree & Landscape Maint 25,000.00 28,000.00 0.00 -3,000.00 -12.00 10-185-547020 Maintenance Agreements 2,060.00 1,384.00 0.00 676.00 32.82 E25 Repairs & Maintenance 71,060.00 73,022.24 0.00 -1,962.24 -2.76 10-185-550010 Miscellaneous 2,800.00 2,199.52 0.00 600.48 21.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 451,560.76 285,540.67 0.00 166,020.09 36.77 E30 Other Operating Expenses 464,360.76 297,740.19 0.00 166,620.57 35.88 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 11,735.95 0.00 -11,735.95 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 11,735.95 0.00 -11,735.95 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,893,134.12 1,224,047.77 23,895.00 645,191.35 34.0806 Grand Total -1,893,134.12 -1,224,047.77 -23,895.00 -645,191.35 0.3408 185 Non-Departmental 1,893,134.12 1,224,047.77 23,895.00 645,191.35 34.08 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 186 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 10-190-501020 Salaries 556,371.81 404,800.79 0.00 151,571.02 27.24 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 30,132.81 0.00 16,292.88 35.09 10-190-502020 Group Health Insurance 96,814.24 50,320.14 0.00 46,494.10 48.02 10-190-502030 Retirement 77,679.59 44,161.89 0.00 33,517.70 43.15 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 431.19 0.00 313.00 42.06 10-190-502060 Long Term Disability 1,815.32 1,170.56 0.00 644.76 35.52 10-190-502070 Employee Assistance Prgm 207.48 97.18 0.00 110.30 53.16 E05 Personnel Services 781,916.53 532,472.77 0.00 249,443.76 31.90 10-190-511010 Advertising 100.00 54.00 0.00 46.00 46.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 7.25 0.00 2.75 27.50 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 304.40 0.00 195.60 39.12 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 2,000.00 3,015.20 0.00 -1,015.20 -50.76 E10 Materials & Supplies 2,660.00 3,380.85 0.00 -720.85 -27.10 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 139.00 0.00 11.00 7.33 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 1,499.06 0.00 7,000.94 82.36 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 44,000.00 41,590.67 0.00 2,409.33 5.48 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 16,867.41 0.00 6,132.59 26.66 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 4,315.00 0.00 85.00 1.93 E15 Contractual Services 80,050.00 64,411.14 0.00 15,638.86 19.54 10-190-534010 Telephone 96,000.00 58,296.99 0.00 37,703.01 39.27 E20 Utilities 96,000.00 58,296.99 0.00 37,703.01 39.27 10-190-545010 Software License\maint 197,000.00 187,540.33 1,080.00 8,379.67 4.25 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 19,092.66 208.20 2,699.14 12.27 10-190-547025 Coun Chamber MediaEquip Repr 0.00 273.06 0.00 -273.06 0.00 E25 Repairs & Maintenance 219,000.00 206,906.05 1,288.20 10,805.75 4.93 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 865,467.80 1,288.20 312,870.53 26.5228 Grand Total -1,179,626.53 -865,467.80 -1,288.20 -312,870.53 0.2652 190 Information Technology Svcs 1,179,626.53 865,467.80 1,288.20 312,870.53 26.52 300 Police Department 10-300-501020 Salaries 5,457,482.75 3,450,592.78 0.00 2,006,889.97 36.77 10-300-501030 Holiday Pay 169,092.64 116,981.39 0.00 52,111.25 30.82 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 20,895.36 0.00 24,962.65 54.43 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 7,653.13 0.00 -2,653.13 -53.06 10-300-501090 Overtime 304,257.77 290,492.33 0.00 13,765.44 4.52 10-300-501095 Overtime Straight Pay 13,275.00 12,116.19 0.00 1,158.81 8.73 10-300-502010 Social Security 444,750.67 284,396.31 0.00 160,354.36 36.05 10-300-502020 Group Health Insurance 960,547.52 565,690.40 0.00 394,857.12 41.11 10-300-502030 Retirement 1,009,334.34 661,722.40 0.00 347,611.94 34.44 10-300-502040 Workers Compensation 75,085.94 75,085.94 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 3,839.60 0.00 2,702.68 41.31 10-300-502060 Long Term Disability 15,894.91 10,250.16 0.00 5,644.75 35.51 10-300-502070 Employee Assistance Prgm 1,960.14 925.80 0.00 1,034.34 52.77 10-300-503010 Awards Program 2,500.00 0.00 687.00 1,813.00 72.52 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,551,774.27 5,500,641.79 687.00 3,050,445.48 35.67 10-300-511010 Advertising 5,665.00 4,262.80 0.00 1,402.20 24.75 10-300-511020 Postage 1,395.00 946.77 0.00 448.23 32.13 10-300-512010 Printing 5,952.00 2,728.40 0.00 3,223.60 54.16 10-300-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 14,825.08 0.00 845.42 5.39 10-300-514010 Gas 188,862.00 109,501.74 0.00 79,360.26 42.02 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 726.63 0.00 -75.63 -11.62 10-300-515040 First Aid Supplies 1,378.00 1,299.02 0.00 78.98 5.73 10-300-516010 Ammunition & Firearms Supplies 63,136.25 57,359.96 4,822.56 953.73 1.51 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)0.00 255.00 0.00 -255.00 0.00 10-300-516050 Community Projects 11,100.00 11,100.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 46,278.00 41,531.41 3,543.36 1,203.23 2.60 E10 Materials & Supplies 344,272.75 244,536.88 8,365.92 91,369.95 26.54 10-300-520030 Dues And Publications 5,400.00 4,764.40 0.00 635.60 11.77 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 60,098.35 0.00 15,901.65 20.92 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 1,330.74 0.00 -43.74 -3.40 10-300-521040 Medical Claimsservices 6,510.00 6,252.00 0.00 258.00 3.96 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 17,005.14 0.00 -1,005.14 -6.28 10-300-522026 Drug Forfeiture - Justice 29,750.00 29,750.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 44,836.00 43,359.00 0.00 1,477.00 3.29 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 553.39 0.00 1,492.61 72.95 E15 Contractual Services 193,454.00 163,220.02 0.00 30,233.98 15.63 10-300-531010 Electricity 44,640.00 19,646.68 0.00 24,993.32 55.99 10-300-533010 Natural Gas 1,116.00 405.00 0.00 711.00 63.71 10-300-534010 Telephone 24,101.00 16,063.18 0.00 8,037.82 33.35 10-300-535010 Water 3,348.00 2,454.18 0.00 893.82 26.70 E20 Utilities 73,205.00 38,569.04 0.00 34,635.96 47.31 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 99,346.04 0.00 -62,146.04 -167.06 10-300-541030 Vehicle Wash 9,752.00 7,593.00 0.00 2,159.00 22.14 10-300-544010 K-9 Operations 16,740.00 10,589.08 0.00 6,150.92 36.74 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 27,950.00 9,897.31 0.00 18,052.69 64.59 10-300-545010 Software License\maint 82,414.00 64,645.16 0.00 17,768.84 21.56 10-300-546010 Clothing Expense 48,920.00 19,237.59 130.50 29,551.91 60.41 10-300-546020 Uniform Cleaning 23,715.00 20,142.53 0.00 3,572.47 15.06 10-300-547010 Equipment Maintenance 10,000.00 1,357.82 0.00 8,642.18 86.42 10-300-547020 Maintenance Agreements 56,248.00 37,154.06 7,380.60 11,713.34 20.82 10-300-547030 Radio Maintenance 8,025.00 108.52 0.00 7,916.48 98.65 E25 Repairs & Maintenance 320,964.00 270,071.11 7,511.10 43,381.79 13.52 10-300-572010 Purchase Of Vehicles 46,849.80 46,832.80 0.00 17.00 0.04 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 17,130.00 20,032.93 53.91 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 131,750.00 89,250.00 0.00 42,500.00 32.26 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 13,538.67 0.00 12,992.32 546.35 4.04 10-300-572090 Body Worn Cameras 180,000.00 60,000.00 0.00 120,000.00 66.67 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 409,301.40 196,082.80 30,122.32 183,096.28 44.73 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,892,971.42 6,413,121.64 46,686.34 3,433,163.44 34.7031 Grand Total -9,892,971.42 -6,413,121.64 -46,686.34 -3,433,163.44 0.347 300 Police Department 9,892,971.42 6,413,121.64 46,686.34 3,433,163.44 34.70 310 School Resource Officer 10-310-501020 Salaries 489,893.97 275,031.97 0.00 214,862.00 43.86 10-310-501030 Holiday Pay 20,720.19 256.24 0.00 20,463.95 98.76 10-310-501090 Overtime 45,106.00 68,455.43 0.00 -23,349.43 -51.77 10-310-501095 Overtime Straight Pay 1,311.00 1,796.34 0.00 -485.34 -37.02 10-310-502010 Social Security 42,612.88 24,993.79 0.00 17,619.09 41.35 10-310-502020 Group Health Insurance 89,715.43 50,171.80 0.00 39,543.63 44.08 10-310-502030 Retirement 100,265.61 62,197.23 0.00 38,068.38 37.97 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 303.36 0.00 300.07 49.73 10-310-502060 Long Term Disability 1,498.63 812.83 0.00 685.80 45.76 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 798,454.72 490,653.69 0.00 307,801.03 38.55 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 2,753.48 0.00 12,591.52 82.06 10-310-517010 Operational Supplies 6,995.00 0.00 1,181.12 5,813.88 83.11 E10 Materials & Supplies 22,340.00 2,753.48 1,181.12 18,405.40 82.39 10-310-520070 Training And Education 4,650.00 600.00 0.00 4,050.00 87.10 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 600.00 0.00 4,050.00 87.10 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 147.11 0.00 5,826.89 97.54 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 898.20 208.20 -746.40 -207.33 E25 Repairs & Maintenance 6,334.00 1,045.31 208.20 5,080.49 80.21 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 831,778.72 495,052.48 1,389.32 335,336.92 40.3156 Grand Total -831,778.72 -495,052.48 -1,389.32 -335,336.92 0.4032 310 School Resource Officer 831,778.72 495,052.48 1,389.32 335,336.92 40.32 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 87,811.65 0.00 39,795.31 31.19 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 25,227.80 0.00 4,190.42 14.24 10-320-501095 Overtime Straight Pay 0.00 1,049.54 0.00 -1,049.54 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 8,297.50 0.00 2,739.68 24.82 10-320-502020 Group Health Insurance 20,462.81 13,168.24 0.00 7,294.57 35.65 10-320-502030 Retirement 25,969.83 20,536.01 0.00 5,433.82 20.92 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 96.79 0.00 58.66 37.74 10-320-502060 Long Term Disability 384.75 257.89 0.00 126.86 32.97 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 222,402.83 158,470.27 0.00 63,932.56 28.75 10-320-514010 Gas 11,848.00 6,256.11 0.00 5,591.89 47.20 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 7,453.40 0.00 7,652.60 50.66 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 14,309.51 0.00 17,838.77 55.49 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 8,100.00 0.00 9,400.00 53.71 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 8,100.00 0.00 9,400.00 53.71 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 272,051.11 180,879.78 0.00 91,171.33 33.5126 Grand Total -272,051.11 -180,879.78 0.00 -91,171.33 0.3351 320 M.U.S.T.A.N.G.272,051.11 180,879.78 0.00 91,171.33 33.51 330 Animal Control 10-330-501020 Salaries 370,091.13 221,726.08 0.00 148,365.05 40.09 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 5,460.49 0.00 3,139.51 36.51 10-330-501090 Overtime 2,000.00 9,887.79 0.00 -7,887.79 -394.39 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 16,274.62 0.00 12,848.25 44.12 10-330-502020 Group Health Insurance 93,298.71 51,766.89 0.00 41,531.82 44.51 10-330-502030 Retirement 48,728.46 29,228.93 0.00 19,499.53 40.02 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 238.03 0.00 218.52 47.86 10-330-502060 Long Term Disability 1,117.06 658.84 0.00 458.22 41.02 10-330-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 558,270.58 340,004.59 0.00 218,265.99 39.10 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 51.74 0.00 100.26 65.96 10-330-512010 Printing 1,860.00 898.59 0.00 961.41 51.69 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 243.74 0.00 1,037.26 80.97 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 223.00 163.83 0.00 59.17 26.53 10-330-515040 First Aid Supplies 295.00 138.15 0.00 156.85 53.17 10-330-517010 Operational Supplies 11,000.00 4,748.93 0.00 6,251.07 56.83 E10 Materials & Supplies 15,716.00 6,244.98 0.00 9,471.02 60.26 10-330-520030 Dues And Publications 900.00 56.35 0.00 843.65 93.74 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-330-521040 Medical Claimsservices 690.00 60.00 0.00 630.00 91.30 10-330-522020 Professional Services 3,361.00 1,253.20 0.00 2,107.80 62.71 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,708.00 1,111.89 0.00 2,596.11 70.01 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 4,580.00 4,580.00 0.00 0.00 0.00 E15 Contractual Services 14,239.00 7,061.44 0.00 7,177.56 50.41 10-330-531010 Electricity 22,789.00 15,292.91 0.00 7,496.09 32.89 10-330-533010 Natural Gas 21,000.00 17,364.77 0.00 3,635.23 17.31 10-330-534010 Telephone 810.00 550.38 0.00 259.62 32.05 10-330-535010 Water 3,800.00 2,555.49 0.00 1,244.51 32.75 E20 Utilities 48,399.00 35,763.55 0.00 12,635.45 26.11 10-330-540010 Building & Grounds Maint.15,000.00 18,075.18 0.00 -3,075.18 -20.50 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 48,790.00 37,707.91 0.00 11,082.09 22.71 10-330-544050 Animal Food 6,103.00 3,201.74 0.00 2,901.26 47.54 10-330-545010 Software Licensemaint 3,191.00 2,500.04 0.00 690.96 21.65 10-330-546010 Clothing Expense 2,025.00 1,577.65 0.00 447.35 22.09 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 360.00 208.20 208.20 -56.40 -15.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 1,750.00 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 78,074.00 65,896.72 208.20 11,969.08 15.33 10-330-572010 Purchase of Vehicles 42,695.00 42,695.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 42,695.00 42,695.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 757,393.58 497,666.28 208.20 259,519.10 34.2648 Grand Total -757,393.58 -497,666.28 -208.20 -259,519.10 0.3426 330 Animal Control 757,393.58 497,666.28 208.20 259,519.10 34.26 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 599,661.53 0.00 481,490.98 44.53 10-390-501030 Holiday Pay 38,718.75 27,402.44 0.00 11,316.31 29.23 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 0.00 11,106.64 0.00 -11,106.64 0.00 10-390-501090 Overtime 22,814.00 84,211.43 0.00 -61,397.43 -269.12 10-390-501095 Overtime Straight Pay 1,850.00 3,162.44 0.00 -1,312.44 -70.94 10-390-502010 Social Security 87,556.95 53,373.08 0.00 34,183.87 39.04 10-390-502020 Group Health Insurance 223,648.25 108,695.47 0.00 114,952.78 51.40 10-390-502030 Retirement 152,546.30 77,550.40 0.00 74,995.90 49.16 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 648.03 0.00 684.91 51.38 10-390-502060 Long Term Disability 3,302.13 1,727.71 0.00 1,574.42 47.68 10-390-502070 Employee Assistance Prgm 480.48 217.38 0.00 263.10 54.76 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,616,122.27 970,476.51 0.00 645,645.76 39.95 10-390-511010 Advertising 1,400.00 0.00 0.00 1,400.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,800.00 4,728.11 0.00 2,071.89 30.47 E10 Materials & Supplies 8,200.00 4,728.11 0.00 3,471.89 42.34 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,650.00 2,204.93 0.00 3,445.07 60.97 10-390-522020 Professional Services 4,300.00 3,124.12 0.00 1,175.88 27.35 10-390-523010 Equipment Rentlease 99,260.00 39,808.40 0.00 59,451.60 59.89 E15 Contractual Services 109,768.00 45,137.45 0.00 64,630.55 58.88 10-390-531010 Electricity 11,160.00 13,437.10 0.00 -2,277.10 -20.40 10-390-533010 Natural Gas 279.00 361.79 0.00 -82.79 -29.67 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 1,026.88 0.00 -189.88 -22.69 E20 Utilities 12,276.00 14,825.77 0.00 -2,549.77 -20.77 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 5,580.00 97.79 0.00 5,482.21 98.25 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 12,744.07 0.00 -8,544.07 -203.43 10-390-547020 Maintenance Agreements 75,000.00 71,319.06 296.76 3,384.18 4.51 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 132,713.77 296.76 10,595.47 7.38 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,889,972.27 1,167,881.61 296.76 721,793.90 38.1907 Grand Total -1,889,972.27 -1,167,881.61 -296.76 -721,793.90 0.3819 390 9-1-1 Police 1,889,972.27 1,167,881.61 296.76 721,793.90 38.19 400 Fire Department 10-400-501020 Salaries 4,989,033.59 2,870,902.80 0.00 2,118,130.79 42.46 10-400-501025 Other Hours 0.00 1,114.81 0.00 -1,114.81 0.00 10-400-501030 Holiday Pay 341,978.12 306,613.01 0.00 35,365.11 10.34 10-400-501035 Training & Essential Functions 0.00 7,576.44 0.00 -7,576.44 0.00 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 38,000.00 25,120.73 0.00 12,879.27 33.89 10-400-501090 Overtime-FLSA 45,000.00 105,380.74 0.00 -60,380.74 -134.18 10-400-501092 Overtime-Constant Staffing 0.00 11,786.10 0.00 -11,786.10 0.00 10-400-501095 Overtime Straight Pay 40,000.00 36,310.41 0.00 3,689.59 9.22 10-400-502010 Social Security 69,573.39 48,178.72 0.00 21,394.67 30.75 10-400-502020 Group Health Insurance 871,448.91 553,314.96 0.00 318,133.95 36.51 10-400-502030 Retirement 2,292,378.67 1,626,640.94 0.00 665,737.73 29.04 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 3,176.66 0.00 1,891.92 37.33 10-400-502060 Long Term Disability 12,419.68 8,437.70 0.00 3,981.98 32.06 10-400-502070 Employee Assistance Prgm 1,681.68 777.46 0.00 904.22 53.77 10-400-503010 Awards Program 1,600.00 244.35 0.00 1,355.65 84.73 E05 Personnel Services 8,861,213.57 5,758,606.78 0.00 3,102,606.79 35.01 10-400-511010 Advertising 300.00 158.25 0.00 141.75 47.25 10-400-511020 Postage 120.00 263.50 0.00 -143.50 -119.58 10-400-512010 Printing 700.00 834.12 0.00 -134.12 -19.16 10-400-512020 Copies 50.00 0.14 0.00 49.86 99.72 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,258.61 0.00 136.39 9.78 10-400-514010 Gas 61,175.00 45,668.29 0.00 15,506.71 25.35 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 16.95 0.00 883.05 98.12 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,000.00 5,460.71 0.00 539.29 8.99 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,848.29 0.00 251.71 11.99 10-400-517010 Operational Supplies 18,000.00 9,088.07 0.00 8,911.93 49.51 E10 Materials & Supplies 90,740.00 64,596.93 0.00 26,143.07 28.81 10-400-520030 Dues And Publications 3,400.00 2,502.04 0.00 897.96 26.41 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,000.00 29,694.56 0.00 2,305.44 7.20 10-400-520080 Tuition Reimbursement 7,500.00 9,297.00 0.00 -1,797.00 -23.96 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 43,698.20 0.00 -3,698.20 -9.25 10-400-522020 Professional Services 3,000.00 660.00 0.00 2,340.00 78.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,000.00 5,405.51 0.00 -405.51 -8.11 10-400-529040 Child Safety Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 93,593.00 92,037.31 0.00 1,555.69 1.66 10-400-531010 Electricity 35,000.00 21,804.19 0.00 13,195.81 37.70 10-400-533010 Natural Gas 17,670.00 20,732.35 0.00 -3,062.35 -17.33 10-400-534010 Telephone 25,984.20 18,474.34 0.00 7,509.86 28.90 10-400-535010 Water 12,000.00 7,701.85 0.00 4,298.15 35.82 E20 Utilities 90,654.20 68,712.73 0.00 21,941.47 24.20 10-400-540010 Building & Grounds Maint.90,000.00 30,927.17 11,137.00 47,935.83 53.26 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 66,540.70 0.00 28,459.30 29.96 10-400-546020 Uniform Cleaning 500.00 205.45 0.00 294.55 58.91 10-400-547010 Equipment Maintenance 20,000.00 12,529.19 0.00 7,470.81 37.35 10-400-547020 Maintenance Agreements 39,487.50 24,433.14 892.00 14,162.36 35.87 10-400-547030 Radio Maintenance 20,925.00 8,935.76 0.00 11,989.24 57.30 E25 Repairs & Maintenance 265,912.50 143,571.41 12,029.00 110,312.09 41.48 10-400-572010 Purchase Of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 4,162.15 0.00 -2,662.15 -177.48 10-400-572021 Purchase of Equipment-ONE TIME 163,699.68 17,678.42 143,935.90 2,085.36 1.27 10-400-572022 Fitness-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 232,655.68 69,888.50 161,170.32 1,596.86 0.69 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,634,768.95 6,197,413.66 173,199.32 3,264,155.97 33.8789 Grand Total -9,634,768.95 -6,197,413.66 -173,199.32 -3,264,155.97 0.3388 400 Fire Department 9,634,768.95 6,197,413.66 173,199.32 3,264,155.97 33.88 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,529.36 0.00 170.64 10.04 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,700.00 1,529.36 0.00 170.64 10.04 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,700.00 1,529.36 0.00 170.64 10.0376 Grand Total -1,700.00 -1,529.36 0.00 -170.64 0.1004 401 Fire Museum 1,700.00 1,529.36 0.00 170.64 10.04 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 240,205.46 179,130.44 0.00 61,075.02 25.43 10-520-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 18,375.72 13,168.06 0.00 5,207.66 28.34 10-520-502020 Group Health Insurance 52,232.32 30,339.32 0.00 21,893.00 41.91 10-520-502030 Retirement 30,746.30 20,503.38 0.00 10,242.92 33.31 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 166.47 0.00 129.74 43.80 10-520-502060 Long Term Disability 636.77 431.03 0.00 205.74 32.31 10-520-502070 Employee Assistance Prgm 87.36 30.68 0.00 56.68 64.88 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 342,777.04 243,966.28 0.00 98,810.76 28.83 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 33.27 0.00 41.73 55.64 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.08 0.00 -0.08 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 389.72 0.00 460.28 54.15 10-520-514010 Gas 12,975.00 8,099.12 0.00 4,875.88 37.58 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 1,214.04 0.00 -714.04 -142.81 E10 Materials & Supplies 14,500.00 10,758.73 0.00 3,741.27 25.80 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 3,000.00 4,035.45 0.00 -1,035.45 -34.52 E15 Contractual Services 6,000.00 5,174.51 0.00 825.49 13.76 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 29,089.01 31,871.63 536.10 -3,318.72 -11.41 E25 Repairs & Maintenance 29,089.01 31,871.63 536.10 -3,318.72 -11.41 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 392,366.05 291,771.15 536.10 100,058.80 25.5014 Grand Total -392,366.05 -291,771.15 -536.10 -100,058.80 0.255 520 Plan & Protect Svcs-Admin 392,366.05 291,771.15 536.10 100,058.80 25.50 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 69,927.30 0.00 -18,518.52 -36.02 10-521-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 3,932.77 5,226.23 0.00 -1,293.46 -32.89 10-521-502020 Group Health Insurance 9,239.72 11,253.77 0.00 -2,014.05 -21.80 10-521-502030 Retirement 6,580.32 8,950.52 0.00 -2,370.20 -36.02 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 77.81 0.00 -15.39 -24.66 10-521-502060 Long Term Disability 156.03 207.15 0.00 -51.12 -32.76 10-521-502070 Employee Assistance Prgm 15.29 27.62 0.00 -12.33 -80.64 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 71,553.68 95,828.75 0.00 -24,275.07 -33.93 10-521-511010 Advertising 3,336.00 2,599.95 0.00 736.05 22.06 10-521-511020 Postage 500.00 246.68 0.00 253.32 50.66 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 202.72 0.00 597.28 74.66 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 87.66 0.00 112.34 56.17 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,112.53 0.00 387.47 25.83 E10 Materials & Supplies 6,336.00 4,249.54 0.00 2,086.46 32.93 10-521-520030 Dues And Publications 13,220.00 632.00 0.00 12,588.00 95.22 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 180.00 0.00 1,320.00 88.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 812.00 0.00 13,908.00 94.48 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,271.00 923.43 273.37 74.20 5.84 E25 Repairs & Maintenance 1,271.00 923.43 273.37 74.20 5.84 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 101,813.72 273.37 -8,206.41 -8.7413 Grand Total -93,880.68 -101,813.72 -273.37 8,206.41 -0.0874 521 Plan & Protect Svcs-Planning 93,880.68 101,813.72 273.37 -8,206.41 -8.74 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 55,596.70 0.00 74,791.24 57.36 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,974.68 4,204.07 0.00 5,770.61 57.85 10-522-502020 Group Health Insurance 20,902.54 7,468.59 0.00 13,433.95 64.27 10-522-502030 Retirement 16,689.66 7,116.54 0.00 9,573.12 57.36 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 62.49 0.00 98.55 61.20 10-522-502060 Long Term Disability 397.13 166.50 0.00 230.63 58.07 10-522-502070 Employee Assistance Prgm 50.23 23.52 0.00 26.71 53.18 E05 Personnel Services 178,665.77 74,740.96 0.00 103,924.81 58.17 10-522-511010 Advertising 2,600.00 764.74 0.00 1,835.26 70.59 10-522-511020 Postage 300.00 21.60 0.00 278.40 92.80 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 300.00 510.27 0.00 -210.27 -70.09 10-522-517010 Operational Supplies 1,000.00 920.43 0.00 79.57 7.96 E10 Materials & Supplies 5,600.00 2,217.04 0.00 3,382.96 60.41 10-522-520030 Dues And Publications 1,500.00 235.97 0.00 1,264.03 84.27 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 34,713.40 18,205.20 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 34,949.37 18,205.20 35,845.43 40.28 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 1,062.77 242.44 1,094.79 45.62 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,062.77 242.44 1,094.79 45.62 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 279,065.77 112,970.14 18,447.64 147,647.99 52.908 Grand Total -279,065.77 -112,970.14 -18,447.64 -147,647.99 0.5291 522 Plan & Protect Svcs-MPO 279,065.77 112,970.14 18,447.64 147,647.99 52.91 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 32,368.09 0.00 52,107.19 61.68 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 8,696.19 2,375.95 0.00 6,320.24 72.68 10-530-502020 Group Health Insurance 25,767.93 5,306.54 0.00 20,461.39 79.41 10-530-502030 Retirement 14,550.48 3,925.65 0.00 10,624.83 73.02 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 33.21 0.00 107.23 76.35 10-530-502060 Long Term Disability 344.86 85.59 0.00 259.27 75.18 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 44,188.01 0.00 89,925.43 67.05 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 21.66 0.00 128.34 85.56 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 110.00 14.35 0.00 95.65 86.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 377.04 0.00 202.96 34.99 E10 Materials & Supplies 1,380.00 618.80 0.00 761.20 55.16 10-530-520030 Dues And Publications 500.00 604.82 0.00 -104.82 -20.96 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,000.00 1,472.19 0.00 527.81 26.39 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 33,334.00 0.00 0.00 33,334.00 100.00 10-530-524025 Glass Recycling 10,000.00 10,000.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,000.00 12,222.99 0.00 6,777.01 35.67 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 27,000.00 0.00 0.00 27,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 91,834.00 24,300.00 0.00 67,534.00 73.54 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 672.02 493.59 140.59 37.84 5.63 E25 Repairs & Maintenance 672.02 493.59 140.59 37.84 5.63 10-530-550020 NRA-Residential 40,000.00 40,038.77 0.00 -38.77 -0.10 10-530-550030 NRA-Commercial Facade 19,500.00 6,000.00 0.00 13,500.00 69.23 10-530-550031 Historic Preservation Grant 23,030.99 55.75 22,975.24 0.00 0.00 10-530-550032 NRA-Rental Facade 11,281.52 27.00 0.00 11,254.52 99.76 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 1,169.01 84.20 0.00 1,084.81 92.80 10-530-550039 Historic Preservation Grant 50,000.00 67.50 0.00 49,932.50 99.87 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 92.94 0.00 -92.94 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 144,981.52 46,366.16 22,975.24 75,640.12 52.17 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 372,980.98 115,966.56 23,115.83 233,898.59 62.7106 Grand Total -372,980.98 -115,966.56 -23,115.83 -233,898.59 0.6271 530 Plan & Protect Svc-RedevGrant 372,980.98 115,966.56 23,115.83 233,898.59 62.71 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 194,879.84 132,528.29 0.00 62,351.55 31.99 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 9,449.00 0.00 5,459.31 36.62 10-532-502020 Group Health Insurance 39,644.71 24,717.13 0.00 14,927.58 37.65 10-532-502030 Retirement 24,944.62 16,963.60 0.00 7,981.02 31.99 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 127.81 0.00 110.87 46.45 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 382.08 0.00 210.58 35.53 10-532-502070 Employee Assistance Prgm 65.52 48.58 0.00 16.94 25.85 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 279,027.76 187,969.91 0.00 91,057.85 32.63 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 72.27 0.00 77.73 51.82 10-532-512010 Printing 20.00 293.00 0.00 -273.00 -1,365.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 411.17 0.00 888.83 68.37 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 299.99 0.00 700.01 70.00 E10 Materials & Supplies 2,625.00 1,076.43 0.00 1,548.57 58.99 10-532-520030 Dues And Publications 900.00 720.00 0.00 180.00 20.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 552.90 0.00 447.10 44.71 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 201,600.00 134,478.00 67,200.00 -78.00 -0.04 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 204,100.00 135,750.90 67,200.00 1,149.10 0.56 10-532-534010 Telephone 1,200.00 866.04 0.00 333.96 27.83 E20 Utilities 1,200.00 866.04 0.00 333.96 27.83 10-532-540060 Cemetery Maintenance 37,750.00 24,689.36 12,252.00 808.64 2.14 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 560.42 0.00 519.58 48.11 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 752.21 475.21 -317.42 -34.88 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 27,285.99 12,727.21 1,056.80 2.57 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 528,022.76 352,949.27 79,927.21 95,146.28 18.0194 Grand Total -528,022.76 -352,949.27 -79,927.21 -95,146.28 0.1802 532 Plan & Protect Svcs-Env Health 528,022.76 352,949.27 79,927.21 95,146.28 18.02 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 164,815.30 132,576.62 0.00 32,238.68 19.56 10-533-501050 Parttime(wo Benefits)20,000.00 6,656.65 0.00 13,343.35 66.72 10-533-501060 Seasonal Salaries 0.00 9,876.07 0.00 -9,876.07 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,138.32 11,264.34 0.00 2,873.98 20.33 10-533-502020 Group Health Insurance 30,239.78 16,808.63 0.00 13,431.15 44.42 10-533-502030 Retirement 21,096.27 14,052.61 0.00 7,043.66 33.39 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 119.70 0.00 84.11 41.27 10-533-502060 Long Term Disability 505.89 332.46 0.00 173.43 34.28 10-533-502070 Employee Assistance Prgm 65.52 23.01 0.00 42.51 64.88 E05 Personnel Services 253,322.27 193,967.47 0.00 59,354.80 23.43 10-533-511010 Advertising 100.00 205.63 0.00 -105.63 -105.63 10-533-511020 Postage 1,800.00 1,385.52 0.00 414.48 23.03 10-533-512010 Printing 300.00 194.00 0.00 106.00 35.33 10-533-512020 Copies 0.00 0.04 0.00 -0.04 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 968.91 0.00 31.09 3.11 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 800.13 0.00 549.87 40.73 E10 Materials & Supplies 4,690.00 3,554.23 0.00 1,135.77 24.22 10-533-520030 Dues And Publications 500.00 220.44 0.00 279.56 55.91 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 598.47 0.00 601.53 50.13 10-533-520080 Tuition Reimbursement 0.00 5,082.50 0.00 -5,082.50 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 10,000.00 18,982.80 0.00 -8,982.80 -89.83 10-533-522022 Demo 263,433.60 92,503.34 58,566.88 112,363.38 42.65 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 0.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 353,591.15 161,167.55 58,566.88 133,856.72 37.86 10-533-534010 Telephone 3,701.40 2,893.76 0.00 807.64 21.82 E20 Utilities 3,701.40 2,893.76 0.00 807.64 21.82 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 849.43 0.00 430.57 33.64 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 873.03 407.95 -9.98 -0.79 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 1,992.46 407.95 450.59 15.80 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 618,155.82 363,575.47 58,974.83 195,605.52 31.6434 Grand Total -618,155.82 -363,575.47 -58,974.83 -195,605.52 0.3164 533 PPS - Prop MaintCode Enforce 618,155.82 363,575.47 58,974.83 195,605.52 31.64 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 214,042.86 0.00 91,464.90 29.94 10-534-501050 Parttime(wo Benefits)15,900.00 3,075.59 0.00 12,824.41 80.66 10-534-501060 Seasonal Salaries 0.00 5,059.70 0.00 -5,059.70 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 24,587.69 15,617.76 0.00 8,969.93 36.48 10-534-502020 Group Health Insurance 79,982.22 51,362.60 0.00 28,619.62 35.78 10-534-502030 Retirement 39,104.99 27,397.38 0.00 11,707.61 29.94 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 241.66 0.00 132.88 35.48 10-534-502060 Long Term Disability 929.35 644.25 0.00 285.10 30.68 10-534-502070 Employee Assistance Prgm 109.20 61.38 0.00 47.82 43.79 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 471,251.82 322,259.25 0.00 148,992.57 31.62 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 161.76 0.00 938.24 85.29 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 241.80 0.00 658.20 73.13 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 473.84 0.00 1,326.16 73.68 E10 Materials & Supplies 4,115.00 877.40 0.00 3,237.60 78.68 10-534-520030 Dues And Publications 2,500.00 734.00 0.00 1,766.00 70.64 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 5,500.04 0.00 -500.04 -10.00 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 6,234.04 0.00 1,265.96 16.88 10-534-534010 Telephone 3,060.00 1,976.26 0.00 1,083.74 35.42 E20 Utilities 3,060.00 1,976.26 0.00 1,083.74 35.42 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,400.00 931.00 0.00 469.00 33.50 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 809.66 208.89 -30.55 -3.09 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,015.66 208.89 453.45 16.93 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 333,362.61 208.89 155,033.32 31.7298 Grand Total -488,604.82 -333,362.61 -208.89 -155,033.32 0.3173 534 Plan & Protect Svcs-Bldg Regs 488,604.82 333,362.61 208.89 155,033.32 31.73 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 277,285.46 0.00 108,165.78 28.06 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,541.62 0.00 2,958.38 65.74 10-535-501095 Overtime Straight Pay 500.00 107.59 0.00 392.41 78.48 10-535-502010 Social Security 30,175.52 20,401.08 0.00 9,774.44 32.39 10-535-502020 Group Health Insurance 79,635.09 51,517.73 0.00 28,117.36 35.31 10-535-502030 Retirement 49,977.76 35,703.59 0.00 14,274.17 28.56 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 304.83 0.00 167.63 35.48 10-535-502060 Long Term Disability 1,177.64 815.96 0.00 361.68 30.71 10-535-502070 Employee Assistance Prgm 152.88 71.60 0.00 81.28 53.17 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 560,511.95 392,218.82 0.00 168,293.13 30.02 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 2.37 0.00 47.63 95.26 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 739.41 0.00 260.59 26.06 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 6,000.00 1,350.48 0.00 4,649.52 77.49 10-535-517010 Operational Supplies 6,000.00 5,326.99 0.00 673.01 11.22 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,140.00 7,435.75 0.00 5,704.25 43.41 10-535-520030 Dues And Publications 350.00 191.00 0.00 159.00 45.43 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,100.00 189.90 0.00 910.10 82.74 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,950.00 380.90 0.00 1,569.10 80.47 10-535-531010 Electricity 6,560.00 3,305.77 0.00 3,254.23 49.61 10-535-533010 Natural Gas 3,200.00 3,080.72 0.00 119.28 3.73 10-535-534010 Telephone 420.00 337.94 0.00 82.06 19.54 10-535-535010 Water 1,442.00 817.89 0.00 624.11 43.28 E20 Utilities 11,622.00 7,542.32 0.00 4,079.68 35.10 10-535-540010 Building & Grounds Maint.10,000.00 8,451.98 17.50 1,530.52 15.31 10-535-541010 Veh & Equip Parts Etc 393,400.00 251,165.89 15,567.13 126,666.98 32.20 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 9,000.00 8,995.51 0.00 4.49 0.05 10-535-547010 Equipment Maintenance 1,000.00 194.46 189.46 616.08 61.61 10-535-547020 Maintenance Agreements 17,251.00 12,245.97 208.20 4,796.83 27.81 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 281,053.81 15,982.29 133,714.90 31.04 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 688,631.60 15,982.29 313,361.06 30.7828 Grand Total -1,017,974.95 -688,631.60 -15,982.29 -313,361.06 0.3078 535 Public Works-Central Maintenan 1,017,974.95 688,631.60 15,982.29 313,361.06 30.78 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 171,084.07 0.00 64,850.59 27.49 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 13,061.23 0.00 4,987.77 27.63 10-540-502020 Group Health Insurance 20,506.66 12,405.78 0.00 8,100.88 39.50 10-540-502030 Retirement 30,199.64 20,640.28 0.00 9,559.36 31.65 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 175.79 0.00 114.30 39.40 10-540-502060 Long Term Disability 569.01 450.41 0.00 118.60 20.84 10-540-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 E05 Personnel Services 305,833.81 218,067.47 0.00 87,766.34 28.70 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 3.00 0.00 197.00 98.50 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 100.00 47.00 0.00 53.00 53.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 126.17 0.00 873.83 87.38 10-540-514010 Gas 104,350.00 53,710.03 0.00 50,639.97 48.53 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 1,050.00 1,025.80 0.00 24.20 2.30 10-540-517010 Operational Supplies 300.00 79.99 0.00 220.01 73.34 E10 Materials & Supplies 107,100.00 54,991.99 0.00 52,108.01 48.65 10-540-520030 Dues And Publications 800.00 684.40 0.00 115.60 14.45 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,150.00 0.00 0.00 1,150.00 100.00 10-540-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-540-522020 Professional Services 200.00 60.50 0.00 139.50 69.75 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,150.00 744.90 0.00 1,405.10 65.35 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 405.00 251.31 69.43 84.26 20.80 E25 Repairs & Maintenance 405.00 251.31 69.43 84.26 20.80 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 415,488.81 274,055.67 69.43 141,363.71 34.0235 Grand Total -415,488.81 -274,055.67 -69.43 -141,363.71 0.3402 540 Public Works-Admin 415,488.81 274,055.67 69.43 141,363.71 34.02 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 592,962.92 0.00 267,215.12 31.07 10-541-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 3,553.66 0.00 -3,153.66 -788.42 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 43,451.35 0.00 22,382.87 34.00 10-541-502020 Group Health Insurance 132,614.06 91,048.05 0.00 41,566.01 31.34 10-541-502030 Retirement 110,153.99 75,201.42 0.00 34,952.57 31.73 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 672.16 0.00 382.93 36.29 10-541-502060 Long Term Disability 2,488.48 1,779.39 0.00 709.09 28.49 10-541-502070 Employee Assistance Prgm 262.08 122.76 0.00 139.32 53.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,041.68 814,847.43 0.00 364,194.25 30.89 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 56.99 0.00 343.01 85.75 10-541-512010 Printing 50.00 41.00 0.00 9.00 18.00 10-541-512020 Copies 25.00 0.43 0.00 24.57 98.28 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 626.61 0.00 1,023.39 62.02 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 539.30 0.00 460.70 46.07 10-541-515080 Surveying Supplies 1,500.00 215.75 0.00 1,284.25 85.62 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 3,389.06 0.00 3,960.94 53.89 10-541-520030 Dues And Publications 3,500.00 2,792.00 0.00 708.00 20.23 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,500.00 1,944.00 0.00 556.00 22.24 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 7,000.00 4,736.00 0.00 2,264.00 32.34 10-541-534010 Telephone 500.00 310.76 0.00 189.24 37.85 E20 Utilities 500.00 310.76 0.00 189.24 37.85 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 8,751.23 594.99 1,318.78 12.37 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 10,361.23 594.99 3,208.78 22.65 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,208,056.68 833,644.48 594.99 373,817.21 30.9437 Grand Total -1,208,056.68 -833,644.48 -594.99 -373,817.21 0.3094 541 Public Works-Engineering 1,208,056.68 833,644.48 594.99 373,817.21 30.94 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,373,894.56 899,888.03 0.00 474,006.53 34.50 10-542-501024 Salaries-Stormwater 0.00 11,078.11 0.00 -11,078.11 0.00 10-542-501060 Seasonal Salaries 20,000.00 11,377.50 0.00 8,622.50 43.11 10-542-501070 Stand-by Plan 5,000.00 6,880.05 0.00 -1,880.05 -37.60 10-542-501090 Overtime 30,000.00 9,825.02 0.00 20,174.98 67.25 10-542-501095 Overtime Straight Pay 500.00 1,457.92 0.00 -957.92 -191.58 10-542-502010 Social Security 109,348.68 69,335.05 0.00 40,013.63 36.59 10-542-502020 Group Health Insurance 304,688.92 173,755.45 0.00 130,933.47 42.97 10-542-502030 Retirement 180,402.50 115,025.94 0.00 65,376.56 36.24 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,684.22 1,009.10 0.00 675.12 40.09 10-542-502060 Long Term Disability 4,165.34 2,675.33 0.00 1,490.01 35.77 10-542-502070 Employee Assistance Prgm 622.44 291.54 0.00 330.90 53.16 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,069,617.50 1,341,709.88 0.00 727,907.62 35.17 10-542-511010 Advertising 750.00 228.75 0.00 521.25 69.50 10-542-511020 Postage 150.00 1.41 0.00 148.59 99.06 10-542-512010 Printing 90.00 94.00 0.00 -4.00 -4.44 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,400.00 488.33 0.00 911.67 65.12 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 293,688.53 135,261.70 0.00 158,426.83 53.94 10-542-514030 Small Tools 9,362.18 9,475.11 0.00 -112.93 -1.21 10-542-514040 Food 1,637.82 596.58 0.00 1,041.24 63.57 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 225,000.00 185,844.15 0.00 39,155.85 17.40 10-542-515040 First Aid Supplies 500.00 161.22 0.00 338.78 67.76 10-542-515060 Weed Control 2,000.00 1,142.41 0.00 857.59 42.88 10-542-515070 Const & Inspect Supplies 200.00 115.78 0.00 84.22 42.11 10-542-517010 Operational Supplies 7,811.47 8,451.63 0.00 -640.16 -8.20 E10 Materials & Supplies 542,600.00 341,861.49 0.00 200,738.51 37.00 10-542-520030 Dues And Publications 1,320.00 477.00 0.00 843.00 63.86 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 8,584.40 8,684.40 0.00 -100.00 -1.16 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 13,595.60 10,506.45 0.00 3,089.15 22.72 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,700.00 19,667.85 0.00 4,032.15 17.01 10-542-531010 Electricity 24,364.00 14,784.37 0.00 9,579.63 39.32 10-542-531020 Street Lights 593,000.00 374,549.04 0.00 218,450.96 36.84 10-542-533010 Natural Gas 12,500.00 12,016.25 0.00 483.75 3.87 10-542-534010 Telephone 2,080.00 1,837.47 0.00 242.53 11.66 10-542-535010 Water 8,390.00 2,945.51 0.00 5,444.49 64.89 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 640,334.00 406,132.64 0.00 234,201.36 36.57 10-542-540010 Building & Grounds Maint.10,000.00 9,205.52 150.00 644.48 6.44 10-542-541030 Vehicle Wash 7,000.00 6,654.00 0.00 346.00 4.94 10-542-542010 Repairs - StopStreet Lights 35,000.00 12,041.88 0.00 22,958.12 65.59 10-542-542030 Signs & Marking Paint 60,000.00 41,983.63 9,305.92 8,710.45 14.52 10-542-546010 Clothing Expense 13,000.00 10,734.77 0.00 2,265.23 17.42 10-542-547010 Equipment Maintenance 3,100.00 809.32 0.00 2,290.68 73.89 10-542-547020 Maintenance Agreements 460.00 208.20 208.20 43.60 9.48 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 81,637.32 9,664.12 38,258.56 29.53 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,377.53 0.00 622.47 3.89 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 16,000.00 15,377.53 0.00 622.47 3.89 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,421,811.50 2,206,386.71 9,664.12 1,205,760.67 35.2375 Grand Total -3,421,811.50 -2,206,386.71 -9,664.12 -1,205,760.67 0.3524 542 Public Works-Street 3,421,811.50 2,206,386.71 9,664.12 1,205,760.67 35.24 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 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 0.00 0.00 175,000.00 100.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 925,000.00 0.00 0.00 925,000.00 100.00 10-990-540060 Cemetery Maintenance 30,000.00 3,650.00 0.00 26,350.00 87.83 10-990-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,992.53 0.00 0.00 6,992.53 100.00 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 65,917.60 0.00 0.00 65,917.60 100.00 10-990-576008 Air Streets Stormwater 425,000.00 0.00 0.00 425,000.00 100.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 2,130.42 927.75 -3,058.17 0.00 10-990-576025 Douglas Davis Stormwater 125,267.16 68,556.54 6,710.62 50,000.00 39.91 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 0.00 145,000.00 5,000.00 3.33 10-990-599505 PD Elevator Replacement 200,000.00 194,275.00 5,725.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 1,500,000.00 217,940.24 1,282,059.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 98,000.00 850,172.75 78.88 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 276,501.00 0.00 8.44 0.00 E75 Capital Projects 8,701,449.16 892,708.20 1,538,423.13 6,270,317.83 72.06 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 892,708.20 1,538,423.13 7,195,317.83 74.7453 Grand Total -9,626,449.16 -892,708.20 -1,538,423.13 -7,195,317.83 0.7475 990 Capital Projects 9,626,449.16 892,708.20 1,538,423.13 7,195,317.83 74.75 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-995-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-995-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-995-599511 United Cap City Soccer Complex 0.00 0.00 0.00 0.00 0.00 E65 Other Non-Operating Expenses 0.00 0.00 0.00 0.00 0.00 10-995-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-995-572020 Purchase of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-995-599502 Downtown Beautification-Match 0.00 0.00 0.00 0.00 0.00 10-995-599503 Organizational Review Study 0.00 0.00 0.00 0.00 0.00 10-995-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 64,594,028.60 27,136,095.43 1,998,406.47 35,459,526.70 54.90 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 64,594,028.60 27,136,095.43 1,998,406.47 35,459,526.70 54.896 Grand Total -64,594,028.60 -27,136,095.43 -1,998,406.47 -35,459,526.70 0.549 GL - Trial Balance by Acct Type and Full Acct Number (07/17/2023 - 04:19 PM)Page 43