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-10 Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 10/16/2023 10:21:03 AM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 60,075.00 0.00 5,850.00 8.87 10-110-501015 Salary-Prosecuting Attorney 34,999.92 32,083.26 0.00 2,916.66 8.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)14,598.40 6,162.28 0.00 8,436.12 57.79 10-110-502010 Social Security 8,990.53 7,323.28 0.00 1,667.25 18.54 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 124,585.44 105,715.41 0.00 18,870.03 15.15 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 34.74 0.00 65.26 65.26 10-110-512010 Printing 400.00 305.47 0.00 94.53 23.63 10-110-512020 Copies 96.00 0.75 0.00 95.25 99.22 10-110-513010 Office Supplies 1,435.00 1,832.59 0.00 -397.59 -27.71 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,031.00 2,173.55 0.00 -142.55 -7.02 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 153,784.95 0.00 -153,784.95 0.00 10-110-520025 Security 1,500.00 1,655.14 0.00 -155.14 -10.34 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,812.01 0.00 -155,957.17 -2,275.14 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 124.00 123.79 0.00 0.21 0.17 E25 Repairs & Maintenance 124.00 123.79 0.00 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,529.88 0.00 -1,529.88 0.00 E70 Capital Purchases 0.00 1,529.88 0.00 -1,529.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 133,595.28 272,354.64 0.00 -138,759.36 -103.8655 Grand Total -133,595.28 -272,354.64 0.00 138,759.36 -1.0387 110 Mayor & Council 133,595.28 272,354.64 0.00 -138,759.36 -103.87 120 City Clerk 10-120-501020 Salaries 58,320.25 53,333.72 0.00 4,986.53 8.55 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,356.55 3,768.05 0.00 588.50 13.51 10-120-502020 Group Health Insurance 13,245.50 11,830.11 0.00 1,415.39 10.69 10-120-502030 Retirement 7,289.39 6,826.75 0.00 462.64 6.35 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 62.12 0.00 7.65 10.96 10-120-502060 Long Term Disability 174.26 167.33 0.00 6.93 3.98 10-120-502070 Employee Assistance Prgm 21.84 20.44 0.00 1.40 6.41 E05 Personnel Services 83,527.55 76,058.51 0.00 7,469.04 8.94 10-120-511020 Postage 200.00 228.82 0.00 -28.82 -14.41 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 311.81 0.00 -11.81 -3.94 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 623.49 0.00 76.51 10.93 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 116.11 0.00 83.89 41.95 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,577.98 0.00 8,676.81 45.06 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 3,832.75 0.00 6,842.25 64.10 E25 Repairs & Maintenance 10,675.00 3,832.75 0.00 6,842.25 64.10 10-120-572020 Purchase Of Equipment 465.33 465.33 0.00 0.00 0.00 E70 Capital Purchases 465.33 465.33 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,622.67 91,558.06 0.00 23,064.61 20.1222 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -114,622.67 -91,558.06 0.00 -23,064.61 0.2012 120 City Clerk 114,622.67 91,558.06 0.00 23,064.61 20.12 140 City Administrator 10-140-501020 Salaries 218,687.56 174,198.17 0.00 44,489.39 20.34 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 9,169.97 0.00 7,141.46 43.78 10-140-502020 Group Health Insurance 21,732.71 16,952.09 0.00 4,780.62 22.00 10-140-502030 Retirement 27,292.33 34,083.14 0.00 -6,790.81 -24.88 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 137.28 0.00 -23.45 -20.60 10-140-502060 Long Term Disability 374.04 429.99 0.00 -55.95 -14.96 10-140-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 284,756.80 235,212.78 0.00 49,544.02 17.40 10-140-511010 Advertising 0.00 2,106.73 0.00 -2,106.73 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 189.00 0.00 -89.00 -89.00 10-140-512020 Copies 150.00 55.34 0.00 94.66 63.11 10-140-513010 Office Supplies 525.00 426.87 0.00 98.13 18.69 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 668.51 0.00 10.23 1.51 E10 Materials & Supplies 1,603.74 3,471.98 0.00 -1,868.24 -116.49 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 352.53 0.00 347.47 49.64 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 754.06 0.00 -754.06 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 49.12 0.00 -49.12 0.00 E15 Contractual Services 2,400.00 2,457.80 0.00 -57.80 -2.41 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 393.93 89.55 -183.48 -61.16 E25 Repairs & Maintenance 300.00 393.93 89.55 -183.48 -61.16 10-140-572020 Purchase Of Equipment 472.60 472.60 0.00 0.00 0.00 E70 Capital Purchases 472.60 472.60 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 289,533.14 242,009.09 89.55 47,434.50 16.3831 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -289,533.14 -242,009.09 -89.55 -47,434.50 0.1638 140 City Administrator 289,533.14 242,009.09 89.55 47,434.50 16.38 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 9,203.82 3,488.65 0.00 5,715.17 62.10 10-143-502010 Social Security 722.68 237.44 0.00 485.24 67.14 10-143-502020 Group Health Insurance 2,646.00 909.36 0.00 1,736.64 65.63 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 1,391.00 446.54 0.00 944.46 67.90 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 9.84 4.10 0.00 5.74 58.33 10-143-502060 Long Term Disability 26.66 11.15 0.00 15.51 58.18 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 5,097.24 0.00 8,902.76 63.59 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 5,097.24 0.00 108,902.76 95.5287 Grand Total -114,000.00 -5,097.24 0.00 -108,902.76 0.9553 143 CDBG-CV Compass Health 114,000.00 5,097.24 0.00 108,902.76 95.53 144 CDBG-DR 10-144-501020 Salaries 242,800.74 31,170.62 0.00 211,630.12 87.16 10-144-502010 Social Security 7,052.54 2,270.72 0.00 4,781.82 67.80 10-144-502020 Group Health Insurance 19,750.50 6,212.26 0.00 13,538.24 68.55 10-144-502030 Retirement 12,501.26 3,989.86 0.00 8,511.40 68.08 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 72.02 37.10 0.00 34.92 48.49 10-144-502060 Long Term Disability 194.94 100.38 0.00 94.56 48.51 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 43,780.94 0.00 238,591.06 84.50 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 43,780.94 0.00 7,265,519.06 99.401 Grand Total -7,309,300.00 -43,780.94 0.00 -7,265,519.06 0.994 144 CDBG-DR 7,309,300.00 43,780.94 0.00 7,265,519.06 99.40 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 36,389.59 12,085.77 0.00 24,303.82 66.79 10-145-502010 Social Security 1,570.81 823.38 0.00 747.43 47.58 10-145-502020 Group Health Insurance 4,842.47 3,044.28 0.00 1,798.19 37.13 10-145-502030 Retirement 2,136.85 1,546.99 0.00 589.86 27.60 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 13.62 0.00 -0.04 -0.29 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 36.29 0.00 -2.95 -8.85 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 17,558.67 0.00 27,441.33 60.98 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 17,558.67 0.00 1,982,441.33 99.1221 Grand Total -2,000,000.00 -17,558.67 0.00 -1,982,441.33 0.9912 145 CDBG-CV Cole Co EMS Station 2,000,000.00 17,558.67 0.00 1,982,441.33 99.12 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 29,980.13 27,023.72 0.00 2,956.41 9.86 10-146-502010 Social Security 4,120.74 1,845.69 0.00 2,275.05 55.21 10-146-502020 Group Health Insurance 16,033.88 7,130.32 0.00 8,903.56 55.53 10-146-502030 Retirement 7,740.28 3,459.06 0.00 4,281.22 55.31 10-146-502040 Workers Compensation 19.66 7.37 0.00 12.29 62.51 10-146-502050 Life Insurance 70.38 33.20 0.00 37.18 52.83 10-146-502060 Long Term Disability 188.48 88.91 0.00 99.57 52.83 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 58,153.55 39,588.27 0.00 18,565.28 31.92 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 355.76 293.94 0.00 61.82 17.38 E15 Contractual Services 355.76 293.94 0.00 61.82 17.38 10-146-550068 Pass-Through Grants 640,830.00 0.00 0.00 640,830.00 100.00 E65 Other Non-Operating Expenses 640,830.00 0.00 0.00 640,830.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 699,339.31 39,882.21 0.00 659,457.10 94.2972 Grand Total -699,339.31 -39,882.21 0.00 -659,457.10 0.943 146 HPF-P Bruhn Revitalization 699,339.31 39,882.21 0.00 659,457.10 94.30 147 CDBG-CV Transform Housing 10-147-501020 Salaries 25,295.88 7,883.89 0.00 17,411.99 68.83 10-147-502010 Social Security 1,160.14 535.65 0.00 624.49 53.83 10-147-502020 Group Health Insurance 3,466.47 1,899.18 0.00 1,567.29 45.21 10-147-502030 Retirement 1,796.20 1,009.12 0.00 787.08 43.82 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 8.54 0.00 0.76 8.17 10-147-502060 Long Term Disability 22.85 22.65 0.00 0.20 0.88 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 11,364.75 0.00 20,395.25 64.22 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)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 11,364.75 0.00 564,395.25 98.0261 Grand Total -575,760.00 -11,364.75 0.00 -564,395.25 0.9803 147 CDBG-CV Transform Housing 575,760.00 11,364.75 0.00 564,395.25 98.03 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 39,729.14 29,419.75 0.00 10,309.39 25.95 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 4,484.91 2,076.22 0.00 2,408.69 53.71 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 15,073.67 6,514.27 0.00 8,559.40 56.78 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 8,228.44 3,765.81 0.00 4,462.63 54.23 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 (10/16/2023 - 10:21 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 34.83 0.00 23.45 40.24 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 93.03 0.00 50.09 35.00 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 30.68 0.00 -9.12 -42.30 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 41,970.40 0.00 25,804.53 38.07 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 110.52 0.00 -40.52 -57.89 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,165.42 0.00 654.58 35.97 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 45.06 0.00 979.94 95.60 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 38,510.00 34,005.00 4,505.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,216.00 0.00 35,784.00 89.46 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 51,569.00 0.00 88,431.00 63.17 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 313,000.00 0.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 365,932.02 0.00 0.00 365,932.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 607.56 12,500.00 26,892.44 67.23 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 403,469.62 17,005.00 537,992.40 56.13 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 (10/16/2023 - 10:21 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 446,605.44 17,005.00 564,451.51 54.9044 Grand Total -1,028,061.95 -446,605.44 -17,005.00 -564,451.51 0.549 149 Entitlement Grant 1,028,061.95 446,605.44 17,005.00 564,451.51 54.90 150 City Attorney 10-150-501020 Salaries 240,166.03 215,631.62 0.00 24,534.41 10.22 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 15,937.72 0.00 1,946.28 10.88 10-150-502020 Group Health Insurance 35,360.71 29,618.57 0.00 5,742.14 16.24 10-150-502030 Retirement 29,923.56 25,177.69 0.00 4,745.87 15.86 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 238.86 0.00 47.56 16.60 10-150-502060 Long Term Disability 607.87 629.25 0.00 -21.38 -3.52 10-150-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,524.90 287,525.86 0.00 36,999.04 11.40 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 270.25 0.00 329.75 54.96 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 22.23 0.00 -22.23 0.00 10-150-513010 Office Supplies 1,275.00 536.99 0.00 738.01 57.88 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 829.47 0.00 1,045.53 55.76 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 8,818.01 1,994.96 475.95 4.22 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 5,248.35 0.00 1,006.65 16.09 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 4,556.08 1,373.57 0.00 3,182.51 69.85 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 59,466.96 0.00 -59,466.96 0.00 E15 Contractual Services 22,600.00 75,271.89 1,994.96 -54,666.85 -241.89 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 348.80 75.00 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 348.80 75.00 -52.80 -14.23 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 349,370.90 363,976.02 2,069.96 -16,675.08 -4.7729 Grand Total -349,370.90 -363,976.02 -2,069.96 16,675.08 -0.0477 150 City Attorney 349,370.90 363,976.02 2,069.96 -16,675.08 -4.77 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 32,083.26 0.00 2,916.66 8.33 10-160-501020 Salaries 133,379.83 123,586.00 0.00 9,793.83 7.34 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 5,415.63 0.00 1,584.37 22.63 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 12,142.17 0.00 689.18 5.37 10-160-502020 Group Health Insurance 25,616.32 20,358.93 0.00 5,257.39 20.52 10-160-502030 Retirement 16,093.46 15,832.75 0.00 260.71 1.62 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 135.95 0.00 17.05 11.14 10-160-502060 Long Term Disability 381.67 365.68 0.00 15.99 4.19 10-160-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 231,719.24 210,286.38 0.00 21,432.86 9.25 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,603.56 0.00 396.44 19.82 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 1,614.16 0.00 885.84 35.43 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 3,217.72 0.00 1,682.28 34.33 10-160-520025 Security 12,500.00 11,802.49 0.00 697.51 5.58 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 98.29 0.00 4,401.71 97.82 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 13,088.28 0.00 9,701.72 42.57 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 (10/16/2023 - 10:21 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,952.30 329.10 13.60 0.22 E25 Repairs & Maintenance 6,295.00 5,952.30 329.10 13.60 0.22 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 265,704.24 232,544.68 329.10 32,830.46 12.356 Grand Total -265,704.24 -232,544.68 -329.10 -32,830.46 0.1236 160 Municipal Court 265,704.24 232,544.68 329.10 32,830.46 12.36 170 Human Resources 10-170-501020 Salaries 238,448.92 220,405.39 0.00 18,043.53 7.57 10-170-501050 Parttime(wo Benefits)13,000.00 12,197.41 0.00 802.59 6.17 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 17,484.38 0.00 1,059.24 5.71 10-170-502020 Group Health Insurance 25,708.58 22,660.42 0.00 3,048.16 11.86 10-170-502030 Retirement 29,363.23 27,921.60 0.00 1,441.63 4.91 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 247.98 0.00 32.32 11.53 10-170-502060 Long Term Disability 589.14 659.60 0.00 -70.46 -11.96 10-170-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 326,425.00 302,141.24 0.00 24,283.76 7.44 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 144.48 0.00 155.52 51.84 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 335.80 0.00 164.20 32.84 10-170-513010 Office Supplies 600.00 322.79 0.00 277.21 46.20 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 868.51 0.00 2,061.49 70.36 10-170-520030 Dues And Publications 700.00 369.98 0.00 330.02 47.15 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,908.70 0.00 1,091.30 36.38 10-170-520070 Training And Education 4,437.00 3,246.94 0.00 1,190.06 26.82 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 498.75 0.00 1.25 0.25 10-170-522020 Professional Services 11,600.00 10,023.44 0.00 1,576.56 13.59 10-170-529010 Special Events 800.00 273.18 0.00 526.82 65.85 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 16,320.99 0.00 4,716.01 22.42 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 52,738.61 52,004.75 89.55 644.31 1.22 E25 Repairs & Maintenance 52,738.61 52,004.75 89.55 644.31 1.22 10-170-572020 Purchase Of Equipment 3,175.24 3,175.24 0.00 0.00 0.00 E70 Capital Purchases 3,175.24 3,175.24 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 406,305.85 374,510.73 89.55 31,705.57 7.8034 Grand Total -406,305.85 -374,510.73 -89.55 -31,705.57 0.078 170 Human Resources 406,305.85 374,510.73 89.55 31,705.57 7.80 180 Finance Department 10-180-501020 Salaries 585,933.62 461,237.37 0.00 124,696.25 21.28 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 34,512.84 0.00 9,146.35 20.95 10-180-502020 Group Health Insurance 96,970.17 73,006.77 0.00 23,963.40 24.71 10-180-502030 Retirement 73,050.67 56,057.81 0.00 16,992.86 23.26 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 529.61 0.00 174.19 24.75 10-180-502060 Long Term Disability 1,743.45 1,416.70 0.00 326.75 18.74 10-180-502070 Employee Assistance Prgm 234.78 175.08 0.00 59.70 25.43 10-180-503020 Unemployment Compensation 0.00 200.28 0.00 -200.28 0.00 E05 Personnel Services 802,794.51 627,635.26 0.00 175,159.25 21.82 10-180-511010 Advertising 1,000.00 681.00 0.00 319.00 31.90 10-180-511020 Postage 10,000.00 8,330.82 0.00 1,669.18 16.69 10-180-511021 Mail Machine Cost 3,000.00 1,868.05 0.00 1,131.95 37.73 10-180-512010 Printing 3,000.00 2,579.03 0.00 420.97 14.03 10-180-512020 Copies 1,000.00 24.60 0.00 975.40 97.54 10-180-512021 Copy Machine Cost 190.00 -214.78 0.00 404.78 213.04 10-180-513010 Office Supplies 1,250.00 342.15 0.00 907.85 72.63 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 212.56 0.00 3,442.44 94.18 E10 Materials & Supplies 23,095.00 13,823.43 0.00 9,271.57 40.15 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 432.06 0.00 1,522.94 77.90 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 3,015.86 0.00 2,434.14 44.66 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 2,804.00 2,808.00 0.00 -4.00 -0.14 10-180-522010 Audit 59,643.71 45,377.88 0.00 14,265.83 23.92 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 49.12 0.00 100.88 67.25 E15 Contractual Services 70,002.71 51,682.92 0.00 18,319.79 26.17 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 14,120.00 13,645.16 312.30 162.54 1.15 E25 Repairs & Maintenance 14,120.00 13,645.16 312.30 162.54 1.15 10-180-572020 Purchase Of Equipment 4,210.45 2,923.35 0.00 1,287.10 30.57 E70 Capital Purchases 4,210.45 2,923.35 0.00 1,287.10 30.57 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 914,222.67 709,710.12 312.30 204,200.25 22.3359 Grand Total -914,222.67 -709,710.12 -312.30 -204,200.25 0.2234 180 Finance Department 914,222.67 709,710.12 312.30 204,200.25 22.34 185 Non-Departmental 10-185-501020 Salaries 16,385.95 0.00 0.00 16,385.95 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 34,558.92 0.00 2,408.51 6.52 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 4,200.00 911.33 0.00 3,288.67 78.30 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,553.38 35,470.25 0.00 22,083.13 38.37 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 19,410.14 0.00 589.86 2.95 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 10-185-550034 National Opioid Settlement 67,382.35 570.00 34,473.75 32,338.60 47.99 E10 Materials & Supplies 87,382.35 19,980.14 34,473.75 32,928.46 37.68 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 481,601.50 497,327.60 0.00 -15,726.10 -3.27 10-185-521020 Insurance Deductible 25,000.00 103,851.39 0.00 -78,851.39 -315.41 10-185-521030 Self Ins Prop & Casualty 15,000.00 701.63 0.00 14,298.37 95.32 10-185-521060 Drugalcohol screening 3,564.00 3,481.90 0.00 82.10 2.30 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 1,671.50 0.00 -1,671.50 0.00 10-185-522020 Professional Services 111,800.00 57,189.00 7,299.00 47,312.00 42.32 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 5,000.00 2,286.06 0.00 2,713.94 54.28 E15 Contractual Services 873,965.50 851,509.08 7,299.00 15,157.42 1.73 10-185-531010 Electricity 32,000.00 31,757.12 0.00 242.88 0.76 10-185-533010 Natural Gas 6,200.00 5,527.53 0.00 672.47 10.85 10-185-535010 Water 7,250.00 6,558.97 0.00 691.03 9.53 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 43,843.62 0.00 1,606.38 3.53 10-185-540010 Building & Grounds Maint.15,000.00 45,214.70 0.00 -30,214.70 -201.43 10-185-540015 Amtrak Station 4,000.00 2,221.93 0.00 1,778.07 44.45 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,852.00 0.00 208.00 10.10 E25 Repairs & Maintenance 46,060.00 74,288.63 0.00 -28,228.63 -61.29 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 287,626.17 0.00 163,934.59 36.30 E30 Other Operating Expenses 464,360.76 299,825.69 0.00 164,535.07 35.43 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 (10/16/2023 - 10:21 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 62,939.98 0.00 -62,939.98 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 62,939.98 0.00 -62,939.98 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,574,771.99 1,387,857.39 41,772.75 145,141.85 9.2167 Grand Total -1,574,771.99 -1,387,857.39 -41,772.75 -145,141.85 0.0922 185 Non-Departmental 1,574,771.99 1,387,857.39 41,772.75 145,141.85 9.22 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 186 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 10-190-501020 Salaries 570,896.20 538,839.20 0.00 32,057.00 5.62 10-190-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 500.00 0.00 0.00 500.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 46,425.69 40,093.03 0.00 6,332.66 13.64 10-190-502020 Group Health Insurance 96,814.24 70,277.63 0.00 26,536.61 27.41 10-190-502030 Retirement 77,679.59 59,763.38 0.00 17,916.21 23.06 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 600.55 0.00 143.64 19.30 10-190-502060 Long Term Disability 1,815.32 1,627.21 0.00 188.11 10.36 10-190-502070 Employee Assistance Prgm 207.48 194.36 0.00 13.12 6.32 E05 Personnel Services 796,440.92 712,753.57 0.00 83,687.35 10.51 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 9.89 0.00 0.11 1.10 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 487.16 0.00 12.84 2.57 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 (10/16/2023 - 10:21 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 2,000.00 3,154.44 0.00 -1,154.44 -57.72 E10 Materials & Supplies 2,660.00 3,705.49 0.00 -1,045.49 -39.30 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 139.00 0.00 11.00 7.33 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 3,902.61 0.00 4,597.39 54.09 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 44,000.00 41,611.11 0.00 2,388.89 5.43 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 22,739.53 0.00 260.47 1.13 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 72,707.25 0.00 7,342.75 9.17 10-190-534010 Telephone 96,000.00 80,131.21 0.00 15,868.79 16.53 E20 Utilities 96,000.00 80,131.21 0.00 15,868.79 16.53 10-190-545010 Software License\maint 197,000.00 205,881.68 0.00 -8,881.68 -4.51 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 19,516.76 104.10 2,379.14 10.81 10-190-547025 Coun Chamber MediaEquip Repr 0.00 273.06 0.00 -273.06 0.00 E25 Repairs & Maintenance 219,000.00 225,671.50 104.10 -6,775.60 -3.09 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,194,150.92 1,094,969.02 104.10 99,077.80 8.2969 Grand Total -1,194,150.92 -1,094,969.02 -104.10 -99,077.80 0.083 190 Information Technology Svcs 1,194,150.92 1,094,969.02 104.10 99,077.80 8.30 300 Police Department 10-300-501020 Salaries 5,508,103.02 4,659,084.05 0.00 849,018.97 15.41 10-300-501030 Holiday Pay 162,165.48 128,841.96 0.00 33,323.52 20.55 10-300-501040 Part-time (w\benefits)40,192.30 0.00 0.00 40,192.30 100.00 10-300-501050 Parttime(wo Benefits)45,858.01 28,087.62 0.00 17,770.39 38.75 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 7,653.13 9,946.77 0.00 -2,293.64 -29.97 10-300-501090 Overtime 326,257.77 379,843.54 0.00 -53,585.77 -16.42 10-300-501095 Overtime Straight Pay 13,275.00 17,101.65 0.00 -3,826.65 -28.83 10-300-502010 Social Security 444,750.67 380,391.44 0.00 64,359.23 14.47 10-300-502020 Group Health Insurance 960,547.52 785,914.68 0.00 174,632.84 18.18 10-300-502030 Retirement 1,009,334.34 883,963.45 0.00 125,370.89 12.42 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 (10/16/2023 - 10:21 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 5,364.24 0.00 1,178.04 18.01 10-300-502060 Long Term Disability 15,894.91 14,374.08 0.00 1,520.83 9.57 10-300-502070 Employee Assistance Prgm 1,960.14 1,851.60 0.00 108.54 5.54 10-300-503010 Awards Program 2,500.00 992.95 0.00 1,507.05 60.28 10-300-503020 Unemployment Compensation 0.00 863.52 0.00 -863.52 0.00 E05 Personnel Services 8,620,120.51 7,371,707.49 0.00 1,248,413.02 14.48 10-300-511010 Advertising 5,665.00 4,346.55 0.00 1,318.45 23.27 10-300-511020 Postage 1,395.00 1,154.61 0.00 240.39 17.23 10-300-512010 Printing 5,951.93 3,579.40 0.00 2,372.53 39.86 10-300-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,529.37 0.00 0.00 1,529.37 100.00 10-300-513010 Office Supplies 15,670.50 16,876.51 0.00 -1,206.01 -7.70 10-300-514010 Gas 188,862.00 185,903.98 0.00 2,958.02 1.57 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 726.63 803.99 0.00 -77.36 -10.65 10-300-515040 First Aid Supplies 1,378.00 2,020.83 0.00 -642.83 -46.65 10-300-516010 Ammunition & Firearms Supplies 63,136.25 62,182.52 0.00 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)255.00 255.00 0.00 0.00 0.00 10-300-516050 Community Projects 11,100.00 11,100.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 46,278.00 46,823.78 0.00 -545.78 -1.18 E10 Materials & Supplies 344,272.75 335,047.24 0.00 9,225.51 2.68 10-300-520030 Dues And Publications 5,400.00 4,824.40 0.00 575.60 10.66 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 78,000.00 69,333.11 0.00 8,666.89 11.11 10-300-520080 Tuition Reimbursement 10,576.11 1,007.00 0.00 9,569.11 90.48 10-300-520090 Recruitment 51,330.75 1,330.74 0.00 50,000.01 97.41 10-300-521040 Medical Claimsservices 6,510.00 7,035.20 0.00 -525.20 -8.07 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 17,005.14 18,626.14 0.00 -1,621.00 -9.53 10-300-522026 Drug Forfeiture - Justice 29,750.00 29,761.01 0.00 -11.01 -0.04 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 44,836.00 50,985.73 0.00 -6,149.73 -13.72 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 666.95 0.00 1,379.05 67.40 E15 Contractual Services 245,454.00 183,570.28 0.00 61,883.72 25.21 10-300-531010 Electricity 42,362.90 39,894.19 0.00 2,468.71 5.83 10-300-533010 Natural Gas 1,033.21 710.10 0.00 323.11 31.27 10-300-534010 Telephone 24,101.00 26,914.63 0.00 -2,813.63 -11.67 10-300-535010 Water 3,348.00 4,228.73 0.00 -880.73 -26.31 E20 Utilities 70,845.11 71,747.65 0.00 -902.54 -1.27 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 103,758.62 6,905.00 -73,463.62 -197.48 10-300-541030 Vehicle Wash 9,752.00 9,562.00 0.00 190.00 1.95 10-300-544010 K-9 Operations 16,740.00 10,924.83 880.36 4,934.81 29.48 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 27,950.00 25,882.23 0.00 2,067.77 7.40 10-300-545010 Software License\maint 82,414.00 64,675.16 0.00 17,738.84 21.52 10-300-546010 Clothing Expense 48,730.12 20,994.11 11,217.69 16,518.32 33.90 10-300-546020 Uniform Cleaning 23,715.00 24,844.01 0.00 -1,129.01 -4.76 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 44,139.12 1,356.60 10,752.28 19.12 10-300-547030 Radio Maintenance 8,025.00 318.52 0.00 7,706.48 96.03 E25 Repairs & Maintenance 320,774.12 306,456.42 20,359.65 -6,041.95 -1.88 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 46,135.43 17,130.00 0.00 29,005.43 62.87 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 131,750.00 131,750.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 17,386.58 12,992.32 0.00 4,394.26 25.27 10-300-572090 Body Worn Cameras 180,000.00 60,000.00 0.00 120,000.00 66.67 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 422,121.81 268,705.12 0.00 153,416.69 36.34 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,023,588.30 8,537,234.20 20,359.65 1,465,994.45 14.6254 Grand Total -10,023,588.30 -8,537,234.20 -20,359.65 -1,465,994.45 0.1463 300 Police Department 10,023,588.30 8,537,234.20 20,359.65 1,465,994.45 14.63 310 School Resource Officer 10-310-501020 Salaries 466,059.20 365,368.46 0.00 100,690.74 21.60 10-310-501030 Holiday Pay 20,720.19 1,783.91 0.00 18,936.28 91.39 10-310-501090 Overtime 68,455.43 93,811.88 0.00 -25,356.45 -37.04 10-310-501095 Overtime Straight Pay 1,796.34 2,267.46 0.00 -471.12 -26.23 10-310-502010 Social Security 42,612.88 33,451.33 0.00 9,161.55 21.50 10-310-502020 Group Health Insurance 89,715.43 69,485.14 0.00 20,230.29 22.55 10-310-502030 Retirement 100,265.61 83,381.77 0.00 16,883.84 16.84 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 423.06 0.00 180.37 29.89 10-310-502060 Long Term Disability 1,498.63 1,137.55 0.00 361.08 24.09 10-310-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 E05 Personnel Services 798,454.72 657,827.10 0.00 140,627.62 17.61 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 9,370.35 0.00 5,974.65 38.94 10-310-517010 Operational Supplies 6,995.00 1,181.12 0.00 5,813.88 83.11 E10 Materials & Supplies 22,340.00 10,551.47 0.00 11,788.53 52.77 10-310-520070 Training And Education 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,227.60 147.11 0.00 5,080.49 97.19 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 1,106.40 1,002.30 104.10 0.00 0.00 E25 Repairs & Maintenance 6,334.00 1,149.41 104.10 5,080.49 80.21 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 831,778.72 670,602.98 104.10 161,071.64 19.3647 Grand Total -831,778.72 -670,602.98 -104.10 -161,071.64 0.1936 310 School Resource Officer 831,778.72 670,602.98 104.10 161,071.64 19.36 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 126,557.42 117,074.42 0.00 9,483.00 7.49 10-320-501030 Holiday Pay 5,319.56 220.95 0.00 5,098.61 95.85 10-320-501090 Overtime 29,418.22 33,544.84 0.00 -4,126.62 -14.03 10-320-501095 Overtime Straight Pay 1,049.54 1,380.98 0.00 -331.44 -31.58 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 11,033.99 0.00 3.19 0.03 10-320-502020 Group Health Insurance 20,462.81 18,245.77 0.00 2,217.04 10.83 10-320-502030 Retirement 25,969.83 27,399.81 0.00 -1,429.98 -5.51 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 134.89 0.00 20.56 13.23 10-320-502060 Long Term Disability 384.75 360.67 0.00 24.08 6.26 10-320-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 222,402.83 211,441.63 0.00 10,961.20 4.93 10-320-514010 Gas 11,848.00 8,718.77 0.00 3,129.23 26.41 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 8,266.40 0.00 6,839.60 45.28 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 17,585.17 0.00 14,563.11 45.30 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 11,700.00 0.00 5,800.00 33.14 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 11,700.00 0.00 5,800.00 33.14 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 240,726.80 0.00 31,324.31 11.5141 Grand Total -272,051.11 -240,726.80 0.00 -31,324.31 0.1151 320 M.U.S.T.A.N.G.272,051.11 240,726.80 0.00 31,324.31 11.51 330 Animal Control 10-330-501020 Salaries 373,650.09 314,460.03 0.00 59,190.06 15.84 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 7,243.45 0.00 1,356.55 15.77 10-330-501090 Overtime 9,887.79 10,996.16 0.00 -1,108.37 -11.21 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 22,844.13 0.00 6,278.74 21.56 10-330-502020 Group Health Insurance 93,298.71 72,453.55 0.00 20,845.16 22.34 10-330-502030 Retirement 48,728.46 38,279.74 0.00 10,448.72 21.44 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 343.33 0.00 113.22 24.80 10-330-502060 Long Term Disability 1,117.06 953.02 0.00 164.04 14.68 10-330-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 569,717.33 472,418.17 0.00 97,299.16 17.08 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 80.39 0.00 71.61 47.11 10-330-512010 Printing 1,860.00 1,541.00 0.00 319.00 17.15 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 270.73 0.00 1,010.27 78.87 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 223.00 163.83 0.00 59.17 26.53 10-330-515040 First Aid Supplies 295.00 355.95 0.00 -60.95 -20.66 10-330-517010 Operational Supplies 7,924.82 6,502.85 0.00 1,421.97 17.94 E10 Materials & Supplies 12,640.82 8,914.75 0.00 3,726.07 29.48 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 664.00 0.00 0.00 664.00 100.00 10-330-521040 Medical Claimsservices 690.00 421.60 0.00 268.40 38.90 10-330-522020 Professional Services 3,361.00 1,306.80 0.00 2,054.20 61.12 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,708.00 3,274.72 0.00 433.28 11.69 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 4,580.00 4,580.00 0.00 0.00 0.00 E15 Contractual Services 13,903.00 9,639.47 0.00 4,263.53 30.67 10-330-531010 Electricity 22,789.00 23,105.57 0.00 -316.57 -1.39 10-330-533010 Natural Gas 21,000.00 22,352.12 0.00 -1,352.12 -6.44 10-330-534010 Telephone 810.00 756.18 0.00 53.82 6.64 10-330-535010 Water 3,800.00 4,476.83 0.00 -676.83 -17.81 E20 Utilities 48,399.00 50,690.70 0.00 -2,291.70 -4.74 10-330-540010 Building & Grounds Maint.18,075.18 18,574.14 0.00 -498.96 -2.76 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 49,141.18 0.00 -351.18 -0.72 10-330-544050 Animal Food 6,103.00 4,508.75 0.00 1,594.25 26.12 10-330-545010 Software Licensemaint 3,191.00 2,795.08 0.00 395.92 12.41 10-330-546010 Clothing Expense 2,025.00 1,827.64 0.00 197.36 9.75 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 198.60 0.00 0.00 198.60 100.00 10-330-547020 Maintenance Agreements 416.40 312.30 104.10 0.00 0.00 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 2,086.00 2,086.00 0.00 0.00 0.00 E25 Repairs & Maintenance 81,485.18 79,785.09 104.10 1,595.99 1.96 10-330-572010 Purchase of Vehicles 42,695.00 42,695.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 42,695.00 42,695.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 768,840.33 664,143.18 104.10 104,593.05 13.604 Grand Total -768,840.33 -664,143.18 -104.10 -104,593.05 0.136 330 Animal Control 768,840.33 664,143.18 104.10 104,593.05 13.60 390 9-1-1 Police 10-390-501020 Salaries 994,222.38 814,593.33 0.00 179,629.05 18.07 10-390-501030 Holiday Pay 38,718.75 30,548.60 0.00 8,170.15 21.10 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 11,106.64 12,064.94 0.00 -958.30 -8.63 10-390-501090 Overtime 84,211.43 108,140.54 0.00 -23,929.11 -28.42 10-390-501095 Overtime Straight Pay 3,162.44 4,021.51 0.00 -859.07 -27.16 10-390-502010 Social Security 87,556.95 71,202.84 0.00 16,354.11 18.68 10-390-502020 Group Health Insurance 223,648.25 151,467.83 0.00 72,180.42 32.27 10-390-502030 Retirement 152,546.30 106,083.74 0.00 46,462.56 30.46 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 906.20 0.00 426.74 32.01 10-390-502060 Long Term Disability 3,302.13 2,423.53 0.00 878.60 26.61 10-390-502070 Employee Assistance Prgm 480.48 434.76 0.00 45.72 9.52 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,603,008.65 1,304,607.78 0.00 298,400.87 18.62 10-390-511010 Advertising 1,400.00 0.00 0.00 1,400.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,800.00 5,743.90 0.00 1,056.10 15.53 E10 Materials & Supplies 8,200.00 5,743.90 0.00 2,456.10 29.95 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 3,651.93 0.00 1,998.07 35.36 10-390-522020 Professional Services 4,300.00 4,601.40 0.00 -301.40 -7.01 10-390-523010 Equipment Rentlease 99,260.00 65,608.00 0.00 33,652.00 33.90 E15 Contractual Services 109,768.00 73,861.33 0.00 35,906.67 32.71 10-390-531010 Electricity 13,437.10 13,437.10 0.00 0.00 0.00 10-390-533010 Natural Gas 361.79 361.79 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 1,026.88 1,026.88 0.00 0.00 0.00 E20 Utilities 14,825.77 14,825.77 0.00 0.00 0.00 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 685.93 112.02 0.00 573.91 83.67 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 12,744.07 12,744.07 0.00 0.00 0.00 10-390-547020 Maintenance Agreements 75,000.00 72,365.53 148.38 2,486.09 3.31 10-390-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 143,606.00 133,774.47 148.38 9,683.15 6.74 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,879,408.42 1,532,813.25 148.38 346,446.79 18.4338 Grand Total -1,879,408.42 -1,532,813.25 -148.38 -346,446.79 0.1843 390 9-1-1 Police 1,879,408.42 1,532,813.25 148.38 346,446.79 18.43 400 Fire Department 10-400-501020 Salaries 4,737,469.64 3,825,952.35 0.00 911,517.29 19.24 10-400-501025 Other Hours 0.00 3,524.26 0.00 -3,524.26 0.00 10-400-501030 Holiday Pay 341,978.12 340,217.39 0.00 1,760.73 0.51 10-400-501035 Training & Essential Functions 0.00 20,839.06 0.00 -20,839.06 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 33,579.82 0.00 4,420.18 11.63 10-400-501090 Overtime-FLSA 48,689.59 225,423.78 0.00 -176,734.19 -362.98 10-400-501092 Overtime-Constant Staffing 0.00 49,737.36 0.00 -49,737.36 0.00 10-400-501095 Overtime Straight Pay 36,310.41 38,742.06 0.00 -2,431.65 -6.70 10-400-502010 Social Security 69,573.39 64,882.22 0.00 4,691.17 6.74 10-400-502020 Group Health Insurance 877,737.91 759,605.40 0.00 118,132.51 13.46 10-400-502030 Retirement 2,292,378.67 2,193,144.16 0.00 99,234.51 4.33 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 4,362.32 0.00 706.26 13.93 10-400-502060 Long Term Disability 12,419.68 11,638.49 0.00 781.19 6.29 10-400-502070 Employee Assistance Prgm 1,681.68 1,554.92 0.00 126.76 7.54 10-400-503010 Awards Program 1,194.49 244.35 0.00 950.14 79.54 E05 Personnel Services 8,615,533.11 7,726,478.89 0.00 889,054.22 10.32 10-400-511010 Advertising 300.00 277.50 0.00 22.50 7.50 10-400-511020 Postage 320.00 320.16 0.00 -0.16 -0.05 10-400-512010 Printing 889.37 889.37 0.00 0.00 0.00 10-400-512020 Copies 0.14 0.14 0.00 0.00 0.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,389.61 1,376.95 0.00 12.66 0.91 10-400-514010 Gas 61,175.00 74,262.22 0.00 -13,087.22 -21.39 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 317.27 16.95 0.00 300.32 94.66 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,248.61 6,248.61 0.00 0.00 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,894.72 0.00 205.28 9.78 10-400-517010 Operational Supplies 18,000.00 14,877.25 0.00 3,122.75 17.35 E10 Materials & Supplies 90,740.00 100,163.87 0.00 -9,423.87 -10.39 10-400-520030 Dues And Publications 3,400.00 3,202.04 0.00 197.96 5.82 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 33,200.00 40,448.89 0.00 -7,248.89 -21.83 10-400-520080 Tuition Reimbursement 13,510.00 10,901.00 0.00 2,609.00 19.31 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 44,451.80 44,451.80 0.00 0.00 0.00 10-400-522020 Professional Services 1,000.00 1,000.00 0.00 0.00 0.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,405.51 5,405.51 0.00 0.00 0.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 945.00 0.00 1,555.00 62.20 E15 Contractual Services 103,660.31 106,354.24 0.00 -2,693.93 -2.60 10-400-531010 Electricity 38,800.00 36,413.66 0.00 2,386.34 6.15 10-400-533010 Natural Gas 23,522.45 22,295.93 0.00 1,226.52 5.21 10-400-534010 Telephone 25,731.75 25,371.89 0.00 359.86 1.40 10-400-535010 Water 12,800.00 11,227.20 0.00 1,572.80 12.29 E20 Utilities 100,854.20 95,308.68 0.00 5,545.52 5.50 10-400-540010 Building & Grounds Maint.90,000.00 59,915.09 23,040.00 7,044.91 7.83 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 92,548.20 85,620.56 0.00 6,927.64 7.49 10-400-546020 Uniform Cleaning 500.00 370.20 0.00 129.80 25.96 10-400-547010 Equipment Maintenance 20,000.00 17,851.98 0.00 2,148.02 10.74 10-400-547020 Maintenance Agreements 39,487.50 38,380.55 578.50 528.45 1.34 10-400-547030 Radio Maintenance 20,925.00 16,461.93 0.00 4,463.07 21.33 E25 Repairs & Maintenance 263,460.70 218,600.31 23,618.50 21,241.89 8.06 10-400-572010 Purchase Of Vehicles 67,456.00 67,456.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 484.11 0.00 1,015.89 67.73 10-400-572021 Purchase of Equipment-ONE TIME 253,126.95 164,387.10 0.00 88,739.85 35.06 10-400-572022 Fitness-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 322,082.95 232,327.21 0.00 89,755.74 27.87 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,496,331.27 8,479,233.20 23,618.50 993,479.57 10.4617 Grand Total -9,496,331.27 -8,479,233.20 -23,618.50 -993,479.57 0.1046 400 Fire Department 9,496,331.27 8,479,233.20 23,618.50 993,479.57 10.46 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,785.50 0.00 -85.50 -5.03 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 12.74 0.00 -12.74 0.00 E20 Utilities 1,700.00 1,798.24 0.00 -98.24 -5.78 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,798.24 0.00 -98.24 -5.7788 Grand Total -1,700.00 -1,798.24 0.00 98.24 -0.0578 401 Fire Museum 1,700.00 1,798.24 0.00 -98.24 -5.78 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.32 0.00 -0.32 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.32 0.00 -0.32 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 (10/16/2023 - 10:21 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.32 0.00 -0.32 0 Grand Total 0.00 -0.32 0.00 0.32 0 500 Public Works 0.00 0.32 0.00 -0.32 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 240,970.33 226,898.54 0.00 14,071.79 5.84 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 16,602.62 0.00 1,773.10 9.65 10-520-502020 Group Health Insurance 52,232.32 41,663.12 0.00 10,569.20 20.23 10-520-502030 Retirement 30,746.30 26,187.37 0.00 4,558.93 14.83 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 228.37 0.00 67.84 22.90 10-520-502060 Long Term Disability 636.77 598.07 0.00 38.70 6.08 10-520-502070 Employee Assistance Prgm 87.36 61.36 0.00 26.00 29.76 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 343,541.91 312,436.35 0.00 31,105.56 9.05 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 603.36 0.00 246.64 29.02 10-520-514010 Gas 12,975.00 14,895.88 0.00 -1,920.88 -14.80 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 1,266.48 0.00 -766.48 -153.30 E10 Materials & Supplies 14,500.00 17,821.57 0.00 -3,321.57 -22.91 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 4,035.45 4,035.45 0.00 0.00 0.00 E15 Contractual Services 7,035.45 5,174.51 0.00 1,860.94 26.45 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 32,125.73 32,144.33 254.10 -272.70 -0.85 E25 Repairs & Maintenance 32,125.73 32,144.33 254.10 -272.70 -0.85 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 397,203.09 367,576.76 254.10 29,372.23 7.3948 Grand Total -397,203.09 -367,576.76 -254.10 -29,372.23 0.0739 520 Plan & Protect Svcs-Admin 397,203.09 367,576.76 254.10 29,372.23 7.39 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 57,618.37 94,470.80 0.00 -36,852.43 -63.96 10-521-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 3,932.77 7,056.79 0.00 -3,124.02 -79.44 10-521-502020 Group Health Insurance 9,239.72 15,638.64 0.00 -6,398.92 -69.25 10-521-502030 Retirement 6,580.32 12,092.06 0.00 -5,511.74 -83.76 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 107.81 0.00 -45.39 -72.72 10-521-502060 Long Term Disability 156.03 288.28 0.00 -132.25 -84.76 10-521-502070 Employee Assistance Prgm 15.29 55.24 0.00 -39.95 -261.28 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,763.27 129,867.97 0.00 -52,104.70 -67.00 10-521-511010 Advertising 3,336.00 3,094.70 0.00 241.30 7.23 10-521-511020 Postage 500.00 281.18 0.00 218.82 43.76 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 230.72 0.00 569.28 71.16 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 87.66 0.00 112.34 56.17 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,112.53 0.00 387.47 25.83 E10 Materials & Supplies 6,336.00 4,806.79 0.00 1,529.21 24.14 10-521-520030 Dues And Publications 14,032.68 14,389.68 0.00 -357.00 -2.54 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 687.32 180.00 0.00 507.32 73.81 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 14,569.68 0.00 150.32 1.02 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,271.00 1,163.09 0.00 107.91 8.49 E25 Repairs & Maintenance 1,271.00 1,163.09 0.00 107.91 8.49 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 100,090.27 150,407.53 0.00 -50,317.26 -50.2719 Grand Total -100,090.27 -150,407.53 0.00 50,317.26 -0.5027 521 Plan & Protect Svcs-Planning 100,090.27 150,407.53 0.00 -50,317.26 -50.27 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 131,978.86 72,725.30 0.00 59,253.56 44.90 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 5,496.33 0.00 4,478.35 44.90 10-522-502020 Group Health Insurance 20,902.54 10,021.34 0.00 10,881.20 52.06 10-522-502030 Retirement 16,689.66 9,309.02 0.00 7,380.64 44.22 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 84.18 0.00 76.86 47.73 10-522-502060 Long Term Disability 397.13 224.87 0.00 172.26 43.38 10-522-502070 Employee Assistance Prgm 50.23 47.04 0.00 3.19 6.35 E05 Personnel Services 180,256.69 98,010.63 0.00 82,246.06 45.63 10-522-511010 Advertising 2,389.73 764.74 0.00 1,624.99 68.00 10-522-511020 Postage 300.00 21.60 0.00 278.40 92.80 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 116.23 0.00 883.77 88.38 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 510.27 510.27 0.00 0.00 0.00 10-522-517010 Operational Supplies 1,000.00 920.43 0.00 79.57 7.96 E10 Materials & Supplies 5,600.00 2,333.27 0.00 3,266.73 58.33 10-522-520030 Dues And Publications 1,500.00 1,975.73 0.00 -475.73 -31.72 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 268.61 0.00 4,231.39 94.03 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 49,028.00 3,890.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 51,272.34 3,890.60 33,837.06 38.02 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 1,364.41 0.00 1,035.59 43.15 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,364.41 0.00 1,035.59 43.15 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 280,656.69 152,980.65 3,890.60 123,785.44 44.1056 Grand Total -280,656.69 -152,980.65 -3,890.60 -123,785.44 0.4411 522 Plan & Protect Svcs-MPO 280,656.69 152,980.65 3,890.60 123,785.44 44.11 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 58,178.00 36,282.97 0.00 21,895.03 37.63 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 5,972.99 2,661.44 0.00 3,311.55 55.44 10-530-502020 Group Health Insurance 8,770.40 5,904.88 0.00 2,865.52 32.67 10-530-502030 Retirement 9,467.98 4,242.43 0.00 5,225.55 55.19 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 36.34 0.00 104.10 74.12 10-530-502060 Long Term Disability 344.86 94.06 0.00 250.80 72.73 10-530-502070 Employee Assistance Prgm 51.96 15.33 0.00 36.63 70.50 E05 Personnel Services 83,012.93 49,325.32 0.00 33,687.61 40.58 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 121.83 0.00 28.17 18.78 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 110.00 36.35 0.00 73.65 66.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 497.03 0.00 82.97 14.31 E10 Materials & Supplies 1,380.00 860.96 0.00 519.04 37.61 10-530-520030 Dues And Publications 604.82 724.70 0.00 -119.88 -19.82 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,895.18 2,564.53 0.00 -669.35 -35.32 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 33,334.00 1,150.35 0.00 32,183.65 96.55 10-530-524025 Glass Recycling 10,000.00 10,000.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,000.00 22,360.62 0.00 -3,360.62 -17.69 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 27,000.00 238.67 0.00 26,761.33 99.12 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 91,834.00 37,038.87 0.00 54,795.13 59.67 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 672.02 711.38 0.00 -39.36 -5.86 E25 Repairs & Maintenance 672.02 711.38 0.00 -39.36 -5.86 10-530-550020 NRA-Residential 45,539.18 40,038.77 0.00 5,500.41 12.08 10-530-550030 NRA-Commercial Facade 13,960.82 6,000.00 0.00 7,960.82 57.02 10-530-550031 Historic Preservation Grant 23,030.99 55.75 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 292.10 0.00 876.91 75.01 10-530-550039 Historic Preservation Grant 50,000.00 67.50 0.00 49,932.50 99.87 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 144,981.52 46,481.12 22,975.24 75,525.16 52.09 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 321,880.47 134,417.65 22,975.24 164,487.58 51.1021 Grand Total -321,880.47 -134,417.65 -22,975.24 -164,487.58 0.511 530 Plan & Protect Svc-RedevGrant 321,880.47 134,417.65 22,975.24 164,487.58 51.10 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 (10/16/2023 - 10:21 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 203,695.87 181,229.73 0.00 22,466.14 11.03 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 12,922.67 0.00 1,985.64 13.32 10-532-502020 Group Health Insurance 39,644.71 34,553.80 0.00 5,090.91 12.84 10-532-502030 Retirement 24,944.62 23,197.36 0.00 1,747.26 7.00 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 179.11 0.00 59.57 24.96 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 540.42 0.00 52.24 8.81 10-532-502070 Employee Assistance Prgm 65.52 79.26 0.00 -13.74 -20.97 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 287,843.79 256,455.77 0.00 31,388.02 10.90 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 82.74 0.00 67.26 44.84 10-532-512010 Printing 293.00 293.00 0.00 0.00 0.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,027.00 711.98 0.00 315.02 30.67 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 546.49 0.00 453.51 45.35 E10 Materials & Supplies 2,625.00 1,634.21 0.00 990.79 37.74 10-532-520030 Dues And Publications 900.00 720.00 0.00 180.00 20.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 552.90 0.00 447.10 44.71 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 201,678.00 184,878.00 16,800.00 0.00 0.00 10-532-529010 Special Events 122.00 0.00 0.00 122.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 203,700.00 186,150.90 16,800.00 749.10 0.37 10-532-534010 Telephone 1,200.00 1,237.20 0.00 -37.20 -3.10 E20 Utilities 1,200.00 1,237.20 0.00 -37.20 -3.10 10-532-540060 Cemetery Maintenance 37,750.00 33,949.39 3,063.00 737.61 1.95 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 880.42 0.00 199.58 18.48 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,310.00 1,048.33 179.10 82.57 6.30 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,470.00 37,162.14 3,242.10 1,065.76 2.57 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 536,838.79 482,640.22 20,042.10 34,156.47 6.3625 Grand Total -536,838.79 -482,640.22 -20,042.10 -34,156.47 0.0636 532 Plan & Protect Svcs-Env Health 536,838.79 482,640.22 20,042.10 34,156.47 6.36 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 187,053.06 171,987.22 0.00 15,065.84 8.05 10-533-501050 Parttime(wo Benefits)25,589.96 28,660.44 0.00 -3,070.48 -12.00 10-533-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 16,861.52 15,190.05 0.00 1,671.47 9.91 10-533-502020 Group Health Insurance 30,239.78 23,246.83 0.00 6,992.95 23.13 10-533-502030 Retirement 21,096.27 18,963.56 0.00 2,132.71 10.11 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 168.24 0.00 35.57 17.45 10-533-502060 Long Term Disability 505.89 463.90 0.00 41.99 8.30 10-533-502070 Employee Assistance Prgm 65.52 58.81 0.00 6.71 10.24 E05 Personnel Services 283,873.19 260,996.43 0.00 22,876.76 8.06 10-533-511010 Advertising 205.63 205.63 0.00 0.00 0.00 10-533-511020 Postage 1,800.00 1,933.61 0.00 -133.61 -7.42 10-533-512010 Printing 299.96 194.00 0.00 105.96 35.32 10-533-512020 Copies 0.04 0.04 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 976.91 0.00 23.09 2.31 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 108.86 0.00 16.14 12.91 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,244.37 1,321.90 0.00 -77.53 -6.23 E10 Materials & Supplies 4,690.00 4,740.95 0.00 -50.95 -1.09 10-533-520030 Dues And Publications 500.00 295.44 0.00 204.56 40.91 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 1,402.47 0.00 -202.47 -16.87 10-533-520080 Tuition Reimbursement 5,082.50 5,082.50 0.00 0.00 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 24,000.00 31,897.80 0.00 -7,897.80 -32.91 10-533-522022 Demo 235,433.60 147,670.50 53,587.00 34,176.10 14.52 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 0.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 344,673.65 230,128.71 53,587.00 60,957.94 17.69 10-533-534010 Telephone 3,701.40 3,600.76 0.00 100.64 2.72 E20 Utilities 3,701.40 3,600.76 0.00 100.64 2.72 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 1,196.43 0.00 83.57 6.53 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 1,156.61 104.10 10.29 0.81 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 2,623.04 104.10 123.86 4.34 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 639,789.24 502,089.89 53,691.10 84,008.25 13.1306 Grand Total -639,789.24 -502,089.89 -53,691.10 -84,008.25 0.1313 533 PPS - Prop MaintCode Enforce 639,789.24 502,089.89 53,691.10 84,008.25 13.13 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 314,201.68 287,079.65 0.00 27,122.03 8.63 10-534-501050 Parttime(wo Benefits)15,900.00 11,532.75 0.00 4,367.25 27.47 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 24,587.69 20,953.58 0.00 3,634.11 14.78 10-534-502020 Group Health Insurance 79,982.22 71,106.80 0.00 8,875.42 11.10 10-534-502030 Retirement 39,104.99 36,746.04 0.00 2,358.95 6.03 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 333.46 0.00 41.08 10.97 10-534-502060 Long Term Disability 929.35 892.47 0.00 36.88 3.97 10-534-502070 Employee Assistance Prgm 109.20 122.76 0.00 -13.56 -12.42 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 479,945.74 433,523.58 0.00 46,422.16 9.67 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 231.94 0.00 868.06 78.91 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 289.79 0.00 610.21 67.80 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 522.71 0.00 1,277.29 70.96 E10 Materials & Supplies 4,115.00 1,044.44 0.00 3,070.56 74.62 10-534-520030 Dues And Publications 2,500.00 1,107.70 0.00 1,392.30 55.69 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 6,950.99 0.00 -1,950.99 -39.02 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 (10/16/2023 - 10:21 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 8,058.69 0.00 -558.69 -7.45 10-534-534010 Telephone 3,060.00 2,823.88 0.00 236.12 7.72 E20 Utilities 3,060.00 2,823.88 0.00 236.12 7.72 10-534-541030 Vehicle Wash 270.00 290.00 0.00 -20.00 -7.41 10-534-546010 Clothing Expense 1,400.00 1,392.00 0.00 8.00 0.57 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 1,028.23 0.00 -40.23 -4.07 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,715.23 0.00 -37.23 -1.39 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 497,298.74 448,165.82 0.00 49,132.92 9.88 Grand Total -497,298.74 -448,165.82 0.00 -49,132.92 0.0988 534 Plan & Protect Svcs-Bldg Regs 497,298.74 448,165.82 0.00 49,132.92 9.88 535 Public Works-Central Maintenan 10-535-501020 Salaries 413,657.31 381,393.68 0.00 32,263.63 7.80 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 2,131.01 0.00 2,368.99 52.64 10-535-501095 Overtime Straight Pay 500.00 174.86 0.00 325.14 65.03 10-535-502010 Social Security 30,175.52 28,056.79 0.00 2,118.73 7.02 10-535-502020 Group Health Insurance 79,635.09 70,670.00 0.00 8,965.09 11.26 10-535-502030 Retirement 49,977.76 47,729.64 0.00 2,248.12 4.50 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 418.08 0.00 54.38 11.51 10-535-502060 Long Term Disability 1,177.64 1,123.61 0.00 54.03 4.59 10-535-502070 Employee Assistance Prgm 152.88 143.20 0.00 9.68 6.33 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 588,718.02 536,310.23 0.00 52,407.79 8.90 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 4.68 0.00 45.32 90.64 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 917.24 0.00 82.76 8.28 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 3,000.00 2,300.31 0.00 699.69 23.32 10-535-517010 Operational Supplies 7,000.00 7,031.03 0.00 -31.03 -0.44 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 11,140.00 10,269.76 0.00 870.24 7.81 10-535-520030 Dues And Publications 350.00 191.00 0.00 159.00 45.43 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 711.12 379.80 0.00 331.32 46.59 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,561.12 1,070.80 0.00 490.32 31.41 10-535-531010 Electricity 6,560.00 5,595.31 0.00 964.69 14.71 10-535-533010 Natural Gas 3,350.00 3,869.26 0.00 -519.26 -15.50 10-535-534010 Telephone 420.00 443.33 0.00 -23.33 -5.55 10-535-535010 Water 1,292.00 1,083.03 0.00 208.97 16.17 E20 Utilities 11,622.00 10,990.93 0.00 631.07 5.43 10-535-540010 Building & Grounds Maint.11,000.00 10,399.57 0.00 600.43 5.46 10-535-541010 Veh & Equip Parts Etc 393,400.00 432,839.39 15,567.13 -55,006.52 -13.98 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 12,088.88 13,581.84 0.00 -1,492.96 -12.35 10-535-547010 Equipment Maintenance 1,000.00 594.19 94.73 311.08 31.11 10-535-547020 Maintenance Agreements 15,551.00 15,123.67 104.10 323.23 2.08 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 433,139.88 472,538.66 15,765.96 -55,164.74 -12.74 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,046,181.02 1,031,180.38 15,765.96 -765.32 -0.0732 Grand Total -1,046,181.02 -1,031,180.38 -15,765.96 765.32 -0.0007 535 Public Works-Central Maintenan 1,046,181.02 1,031,180.38 15,765.96 -765.32 -0.07 540 Public Works-Admin 10-540-501020 Salaries 246,836.90 223,686.72 0.00 23,150.18 9.38 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 17,056.60 0.00 992.40 5.50 10-540-502020 Group Health Insurance 20,506.66 17,278.68 0.00 3,227.98 15.74 10-540-502030 Retirement 30,199.64 27,373.42 0.00 2,826.22 9.36 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 239.09 0.00 51.00 17.58 10-540-502060 Long Term Disability 569.01 621.23 0.00 -52.22 -9.18 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 316,736.05 286,520.99 0.00 30,215.06 9.54 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 (10/16/2023 - 10:21 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 100.00 47.00 0.00 53.00 53.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,500.00 183.75 0.00 1,316.25 87.75 10-540-514010 Gas 103,850.00 85,989.96 0.00 17,860.04 17.20 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 87,329.50 0.00 19,770.50 18.46 10-540-520030 Dues And Publications 800.00 702.39 0.00 97.61 12.20 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,150.00 484.00 0.00 666.00 57.91 10-540-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-540-522020 Professional Services 200.00 60.50 0.00 139.50 69.75 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,150.00 1,246.89 0.00 903.11 42.01 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 405.00 320.79 0.00 84.21 20.79 E25 Repairs & Maintenance 405.00 320.79 0.00 84.21 20.79 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 426,391.05 375,418.17 0.00 50,972.88 11.9545 Grand Total -426,391.05 -375,418.17 0.00 -50,972.88 0.1195 540 Public Works-Admin 426,391.05 375,418.17 0.00 50,972.88 11.95 541 Public Works-Engineering 10-541-501020 Salaries 884,371.34 796,950.98 0.00 87,420.36 9.89 10-541-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 3,709.70 3,709.70 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 58,230.80 0.00 7,603.42 11.55 10-541-502020 Group Health Insurance 132,614.06 126,169.44 0.00 6,444.62 4.86 10-541-502030 Retirement 110,153.99 100,209.35 0.00 9,944.64 9.03 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 928.96 0.00 126.13 11.95 10-541-502060 Long Term Disability 2,488.48 2,474.49 0.00 13.99 0.56 10-541-502070 Employee Assistance Prgm 262.08 260.86 0.00 1.22 0.47 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,206,544.68 1,094,990.30 0.00 111,554.38 9.25 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 243.96 116.50 0.00 127.46 52.25 10-541-511020 Postage 400.00 87.80 0.00 312.20 78.05 10-541-512010 Printing 50.00 41.00 0.00 9.00 18.00 10-541-512020 Copies 25.00 0.47 0.00 24.53 98.12 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 1,166.62 0.00 483.38 29.30 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-541-514040 Food 150.00 17.98 0.00 132.02 88.01 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 719.26 0.00 280.74 28.07 10-541-515080 Surveying Supplies 1,500.00 346.18 0.00 1,153.82 76.92 10-541-517010 Operational Supplies 2,000.00 2,081.42 0.00 -81.42 -4.07 E10 Materials & Supplies 7,193.96 4,577.23 0.00 2,616.73 36.37 10-541-520030 Dues And Publications 3,500.00 3,047.00 0.00 453.00 12.94 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,500.00 2,079.00 0.00 421.00 16.84 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 7,000.00 5,126.00 0.00 1,874.00 26.77 10-541-534010 Telephone 500.00 393.41 0.00 106.59 21.32 E20 Utilities 500.00 393.41 0.00 106.59 21.32 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 716.18 0.00 783.82 52.25 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 10-541-547020 Maintenance Agreements 10,665.00 9,947.50 179.10 538.40 5.05 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 12,273.68 179.10 1,712.22 12.09 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,235,403.64 1,117,360.62 179.10 117,863.92 9.5405 Grand Total -1,235,403.64 -1,117,360.62 -179.10 -117,863.92 0.0954 541 Public Works-Engineering 1,235,403.64 1,117,360.62 179.10 117,863.92 9.54 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,420,739.10 1,216,848.63 0.00 203,890.47 14.35 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,492.31 20,581.14 0.00 -88.83 -0.43 10-542-501070 Stand-by Plan 8,800.00 8,958.89 0.00 -158.89 -1.81 10-542-501090 Overtime 21,542.08 15,436.62 0.00 6,105.46 28.34 10-542-501095 Overtime Straight Pay 4,665.61 1,905.88 0.00 2,759.73 59.15 10-542-502010 Social Security 109,348.68 92,789.16 0.00 16,559.52 15.14 10-542-502020 Group Health Insurance 304,688.92 239,500.47 0.00 65,188.45 21.40 10-542-502030 Retirement 180,402.50 153,630.67 0.00 26,771.83 14.84 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,388.37 0.00 295.85 17.57 10-542-502060 Long Term Disability 4,165.34 3,697.59 0.00 467.75 11.23 10-542-502070 Employee Assistance Prgm 622.44 613.77 0.00 8.67 1.39 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,116,462.04 1,794,462.03 0.00 322,000.01 15.21 10-542-511010 Advertising 750.00 580.00 0.00 170.00 22.67 10-542-511020 Postage 150.00 12.12 0.00 137.88 91.92 10-542-512010 Printing 94.00 94.00 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,396.00 941.74 0.00 454.26 32.54 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 231,022.46 135,261.70 0.00 95,760.76 41.45 10-542-514030 Small Tools 12,362.18 10,073.28 0.00 2,288.90 18.52 10-542-514040 Food 1,637.82 596.58 0.00 1,041.24 63.57 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 275,000.00 299,990.81 0.00 -24,990.81 -9.09 10-542-515040 First Aid Supplies 500.00 291.44 0.00 208.56 41.71 10-542-515060 Weed Control 2,012.41 2,012.41 0.00 0.00 0.00 10-542-515070 Const & Inspect Supplies 200.00 155.71 0.00 44.29 22.15 10-542-517010 Operational Supplies 10,811.47 9,294.85 0.00 1,516.62 14.03 E10 Materials & Supplies 535,946.34 459,305.06 0.00 76,641.28 14.30 10-542-520030 Dues And Publications 1,320.00 554.00 0.00 766.00 58.03 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 12,184.40 11,602.40 0.00 582.00 4.78 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 13,495.60 10,683.30 0.00 2,812.30 20.84 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,200.00 22,839.70 0.00 4,360.30 16.03 10-542-531010 Electricity 24,364.00 22,804.30 0.00 1,559.70 6.40 10-542-531020 Street Lights 571,962.00 594,785.98 0.00 -22,823.98 -3.99 10-542-533010 Natural Gas 12,535.38 12,716.32 0.00 -180.94 -1.44 10-542-534010 Telephone 2,780.00 2,569.11 0.00 210.89 7.59 10-542-535010 Water 7,654.62 4,714.72 0.00 2,939.90 38.41 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 619,296.00 637,590.43 0.00 -18,294.43 -2.95 10-542-540010 Building & Grounds Maint.11,221.02 11,351.68 0.00 -130.66 -1.16 10-542-541030 Vehicle Wash 7,000.00 6,687.00 0.00 313.00 4.47 10-542-542010 Repairs - StopStreet Lights 35,000.00 17,441.75 0.00 17,558.25 50.17 10-542-542030 Signs & Marking Paint 60,000.00 52,414.63 0.00 7,585.37 12.64 10-542-546010 Clothing Expense 13,000.00 12,099.74 0.00 900.26 6.93 10-542-547010 Equipment Maintenance 1,657.58 809.32 0.00 848.26 51.17 10-542-547020 Maintenance Agreements 681.40 577.30 104.10 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 101,381.42 104.10 28,074.48 21.67 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,377.53 0.00 622.47 3.89 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 16,000.00 15,377.53 0.00 622.47 3.89 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,444,464.38 3,030,956.17 104.10 413,404.11 12.002 Grand Total -3,444,464.38 -3,030,956.17 -104.10 -413,404.11 0.12 542 Public Works-Street 3,444,464.38 3,030,956.17 104.10 413,404.11 12.00 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 26,328.02 6,682.21 0.00 19,645.81 74.62 10-700-590051 Trans to Parks 0.00 0.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 0.00 0.00 0.00 0.00 0.00 10-700-590053 Trans to Parking 0.00 0.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 0.00 0.00 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 0.00 0.00 0.00 0.00 0.00 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 97,015.10 97,015.08 0.00 0.02 0.00 10-700-590075 Transit Subsidy 1,218,542.04 1,218,542.04 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 1,341,885.16 1,322,239.33 0.00 19,645.83 1.46 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,341,885.16 1,322,239.33 0.00 19,645.83 1.464 Grand Total -1,341,885.16 -1,322,239.33 0.00 -19,645.83 0.0146 700 Transfers & Subsidies 1,341,885.16 1,322,239.33 0.00 19,645.83 1.46 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 175,000.00 0.00 0.00 0.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 925,000.00 175,000.00 0.00 750,000.00 81.08 10-990-540060 Cemetery Maintenance 30,000.00 3,650.00 0.00 26,350.00 87.83 10-990-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,992.53 2,975.00 0.00 4,017.53 57.45 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 65,917.60 0.00 0.00 65,917.60 100.00 10-990-576008 Air Streets Stormwater 425,000.00 176,229.45 235,781.30 12,989.25 3.06 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 0.00 0.00 0.00 0.00 10-990-576025 Douglas Davis Stormwater 125,267.16 118,201.81 0.00 7,065.35 5.64 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 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 (10/16/2023 - 10:21 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 79.75 145,000.00 4,920.25 3.28 10-990-599505 PD Elevator Replacement 200,000.00 200,000.00 0.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 1,500,000.00 411,619.24 1,088,380.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 98,000.00 850,172.75 78.88 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 276,501.00 0.00 8.44 0.00 E75 Capital Projects 8,701,449.16 1,318,911.25 1,567,162.06 5,815,375.85 66.83 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 1,493,911.25 1,567,162.06 6,565,375.85 68.2014 Grand Total -9,626,449.16 -1,493,911.25 -1,567,162.06 -6,565,375.85 0.682 990 Capital Projects 9,626,449.16 1,493,911.25 1,567,162.06 6,565,375.85 68.20 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 (10/16/2023 - 10:21 AM)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,475,019.09 36,099,026.93 1,790,171.40 26,585,820.76 41.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 64,475,019.09 36,099,026.93 1,790,171.40 26,585,820.76 41.2343 Grand Total -64,475,019.09 -36,099,026.93 -1,790,171.40 -26,585,820.76 0.4123 GL - Trial Balance by Acct Type and Full Acct Number (10/16/2023 - 10:21 AM)Page 43