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-09 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 9/12/2023 4:33:02 PM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 54,675.00 0.00 11,250.00 17.06 10-110-501015 Salary-Prosecuting Attorney 34,999.92 29,166.60 0.00 5,833.32 16.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)14,598.40 5,503.62 0.00 9,094.78 62.30 10-110-502010 Social Security 8,990.53 6,645.57 0.00 2,344.96 26.08 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 96,062.38 0.00 28,523.06 22.89 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 32.22 0.00 67.78 67.78 10-110-512010 Printing 400.00 273.00 0.00 127.00 31.75 10-110-512020 Copies 96.00 0.29 0.00 95.71 99.70 10-110-513010 Office Supplies 1,435.00 1,753.21 0.00 -318.21 -22.17 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,031.00 2,058.72 0.00 -27.72 -1.36 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,104.70 0.00 395.30 26.35 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,261.57 0.00 -155,406.73 -2,267.11 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 124.00 92.84 30.95 0.21 0.17 E25 Repairs & Maintenance 124.00 92.84 30.95 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,529.88 0.00 -1,529.88 0.00 E70 Capital Purchases 0.00 1,529.88 0.00 -1,529.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 133,595.28 262,005.39 30.95 -128,441.06 -96.1419 Grand Total -133,595.28 -262,005.39 -30.95 128,441.06 -0.9614 110 Mayor & Council 133,595.28 262,005.39 30.95 -128,441.06 -96.14 120 City Clerk 10-120-501020 Salaries 58,320.25 48,821.72 0.00 9,498.53 16.29 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,451.05 0.00 905.50 20.78 10-120-502020 Group Health Insurance 13,245.50 10,735.98 0.00 2,509.52 18.95 10-120-502030 Retirement 7,289.39 6,249.21 0.00 1,040.18 14.27 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 56.42 0.00 13.35 19.13 10-120-502060 Long Term Disability 174.26 151.81 0.00 22.45 12.88 10-120-502070 Employee Assistance Prgm 21.84 15.33 0.00 6.51 29.81 E05 Personnel Services 83,527.55 69,531.51 0.00 13,996.04 16.76 10-120-511020 Postage 200.00 219.13 0.00 -19.13 -9.57 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 296.83 0.00 3.17 1.06 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 598.82 0.00 101.18 14.45 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 2,773.82 30.95 7,870.23 73.73 E25 Repairs & Maintenance 10,675.00 2,773.82 30.95 7,870.23 73.73 10-120-572020 Purchase Of Equipment 465.33 465.33 0.00 0.00 0.00 E70 Capital Purchases 465.33 465.33 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,622.67 83,947.46 30.95 30,644.26 26.7349 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -114,622.67 -83,947.46 -30.95 -30,644.26 0.2673 120 City Clerk 114,622.67 83,947.46 30.95 30,644.26 26.73 140 City Administrator 10-140-501020 Salaries 218,687.56 157,545.48 0.00 61,142.08 27.96 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,311.43 8,481.43 0.00 7,830.00 48.00 10-140-502020 Group Health Insurance 21,732.71 14,544.48 0.00 7,188.23 33.08 10-140-502030 Retirement 27,292.33 29,058.14 0.00 -1,765.81 -6.47 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 116.32 0.00 -2.49 -2.19 10-140-502060 Long Term Disability 374.04 377.11 0.00 -3.07 -0.82 10-140-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 284,756.80 210,354.87 0.00 74,401.93 26.13 10-140-511010 Advertising 0.00 2,106.73 0.00 -2,106.73 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 54.71 0.00 95.29 63.53 10-140-513010 Office Supplies 525.00 353.20 0.00 171.80 32.72 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,208.68 0.00 -1,604.94 -100.07 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 330.00 0.00 370.00 52.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 618.88 0.00 -618.88 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,300.09 0.00 99.91 4.16 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 300.00 362.98 120.50 -183.48 -61.16 E25 Repairs & Maintenance 300.00 362.98 120.50 -183.48 -61.16 10-140-572020 Purchase Of Equipment 472.60 472.60 0.00 0.00 0.00 E70 Capital Purchases 472.60 472.60 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 289,533.14 216,699.22 120.50 72,713.42 25.114 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -289,533.14 -216,699.22 -120.50 -72,713.42 0.2511 140 City Administrator 289,533.14 216,699.22 120.50 72,713.42 25.11 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 (09/12/2023 - 04:33 PM)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 11,302.50 0.00 25,087.09 68.94 10-145-502010 Social Security 1,570.81 766.02 0.00 804.79 51.23 10-145-502020 Group Health Insurance 4,842.47 2,872.78 0.00 1,969.69 40.68 10-145-502030 Retirement 2,136.85 1,446.73 0.00 690.12 32.30 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 12.63 0.00 0.95 7.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 33.59 0.00 -0.25 -0.75 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 16,442.59 0.00 28,557.41 63.46 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 16,442.59 0.00 1,983,557.41 99.1779 Grand Total -2,000,000.00 -16,442.59 0.00 -1,983,557.41 0.9918 145 CDBG-CV Cole Co EMS Station 2,000,000.00 16,442.59 0.00 1,983,557.41 99.18 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 29,980.13 24,774.33 0.00 5,205.80 17.36 10-146-502010 Social Security 4,120.74 1,680.97 0.00 2,439.77 59.21 10-146-502020 Group Health Insurance 16,033.88 6,639.01 0.00 9,394.87 58.59 10-146-502030 Retirement 7,740.28 3,171.14 0.00 4,569.14 59.03 10-146-502040 Workers Compensation 19.66 7.37 0.00 12.29 62.51 10-146-502050 Life Insurance 70.38 30.31 0.00 40.07 56.93 10-146-502060 Long Term Disability 188.48 81.17 0.00 107.31 56.93 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 58,153.55 36,384.30 0.00 21,769.25 37.43 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 36,678.24 0.00 662,661.07 94.7553 Grand Total -699,339.31 -36,678.24 0.00 -662,661.07 0.9476 146 HPF-P Bruhn Revitalization 699,339.31 36,678.24 0.00 662,661.07 94.76 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 (09/12/2023 - 04:33 PM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 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 21,174.13 0.00 18,555.01 46.70 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 1,509.95 0.00 2,974.96 66.33 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 4,437.29 0.00 10,636.38 70.56 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 8,228.44 2,710.36 0.00 5,518.08 67.06 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 (09/12/2023 - 04:33 PM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 24.43 0.00 33.85 58.08 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 64.96 0.00 78.16 54.61 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 23.01 0.00 -1.45 -6.73 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 29,979.94 0.00 37,794.99 55.77 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 109.89 0.00 -39.89 -56.99 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,164.79 0.00 655.21 36.00 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 38,510.00 24,500.00 14,010.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 40,000.00 4,189.00 0.00 35,811.00 89.53 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 51,266.00 0.00 88,734.00 63.38 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 81.00 0.00 39,919.00 99.80 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 393,063.00 14,010.00 551,394.02 57.53 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 (09/12/2023 - 04:33 PM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 424,207.73 14,010.00 589,844.22 57.3744 Grand Total -1,028,061.95 -424,207.73 -14,010.00 -589,844.22 0.5737 149 Entitlement Grant 1,028,061.95 424,207.73 14,010.00 589,844.22 57.37 150 City Attorney 10-150-501020 Salaries 240,166.03 194,973.82 0.00 45,192.21 18.82 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 14,413.91 0.00 3,470.09 19.40 10-150-502020 Group Health Insurance 35,360.71 26,751.68 0.00 8,609.03 24.35 10-150-502030 Retirement 29,923.56 23,336.39 0.00 6,587.17 22.01 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 215.16 0.00 71.26 24.88 10-150-502060 Long Term Disability 607.87 564.81 0.00 43.06 7.08 10-150-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,524.90 260,532.58 0.00 63,992.32 19.72 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 269.62 0.00 330.38 55.06 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 21.74 0.00 -21.74 0.00 10-150-513010 Office Supplies 1,275.00 550.99 0.00 724.01 56.79 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 842.35 0.00 1,032.65 55.07 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 7,535.27 2,493.70 1,259.95 11.16 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,255.00 4,937.01 0.00 1,317.99 21.07 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 73,677.81 2,493.70 -53,571.51 -237.04 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 371.00 317.85 105.95 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 317.85 105.95 -52.80 -14.23 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 349,370.90 335,370.59 2,599.65 11,400.66 3.2632 Grand Total -349,370.90 -335,370.59 -2,599.65 -11,400.66 0.0326 150 City Attorney 349,370.90 335,370.59 2,599.65 11,400.66 3.26 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 29,166.60 0.00 5,833.32 16.67 10-160-501020 Salaries 133,379.83 112,942.97 0.00 20,436.86 15.32 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 4,800.94 0.00 2,199.06 31.42 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 11,073.14 0.00 1,758.21 13.70 10-160-502020 Group Health Insurance 25,616.32 18,803.54 0.00 6,812.78 26.60 10-160-502030 Retirement 16,093.46 14,470.43 0.00 1,623.03 10.09 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 123.45 0.00 29.55 19.31 10-160-502060 Long Term Disability 381.67 331.70 0.00 49.97 13.09 10-160-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 231,719.24 192,063.44 0.00 39,655.80 17.11 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,448.46 0.00 551.54 27.58 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 723.49 777.95 998.56 39.94 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 2,171.95 777.95 1,950.10 39.80 10-160-520025 Security 12,500.00 10,568.17 0.00 1,931.83 15.45 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 11,853.96 0.00 10,936.04 47.99 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 (09/12/2023 - 04:33 PM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,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 212,041.65 1,107.05 52,555.54 19.7797 Grand Total -265,704.24 -212,041.65 -1,107.05 -52,555.54 0.1978 160 Municipal Court 265,704.24 212,041.65 1,107.05 52,555.54 19.78 170 Human Resources 10-170-501020 Salaries 238,448.92 201,803.39 0.00 36,645.53 15.37 10-170-501050 Parttime(wo Benefits)13,000.00 10,777.41 0.00 2,222.59 17.10 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 15,982.91 0.00 2,560.71 13.81 10-170-502020 Group Health Insurance 25,708.58 20,569.20 0.00 5,139.38 19.99 10-170-502030 Retirement 29,363.23 25,540.54 0.00 3,822.69 13.02 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 225.28 0.00 55.02 19.63 10-170-502060 Long Term Disability 589.14 597.36 0.00 -8.22 -1.40 10-170-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 326,425.00 276,045.21 0.00 50,379.79 15.43 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 136.05 0.00 163.95 54.65 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 310.88 0.00 189.12 37.82 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 835.16 0.00 2,094.84 71.50 10-170-520030 Dues And Publications 700.00 319.98 0.00 380.02 54.29 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 1,758.59 0.00 1,241.41 41.38 10-170-520070 Training And Education 4,437.00 2,288.63 0.00 2,148.37 48.42 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 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 181.89 0.00 618.11 77.26 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 15,071.28 0.00 5,965.72 28.36 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 52,738.61 51,919.50 120.50 698.61 1.32 E25 Repairs & Maintenance 52,738.61 51,919.50 120.50 698.61 1.32 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 347,046.39 120.50 59,138.96 14.5553 Grand Total -406,305.85 -347,046.39 -120.50 -59,138.96 0.1456 170 Human Resources 406,305.85 347,046.39 120.50 59,138.96 14.56 180 Finance Department 10-180-501020 Salaries 585,933.62 419,960.13 0.00 165,973.49 28.33 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 31,425.86 0.00 12,233.33 28.02 10-180-502020 Group Health Insurance 96,970.17 65,851.68 0.00 31,118.49 32.09 10-180-502030 Retirement 73,050.67 51,250.90 0.00 21,799.77 29.84 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 477.18 0.00 226.62 32.20 10-180-502060 Long Term Disability 1,743.45 1,275.00 0.00 468.45 26.87 10-180-502070 Employee Assistance Prgm 234.78 131.31 0.00 103.47 44.07 10-180-503020 Unemployment Compensation 0.00 200.28 0.00 -200.28 0.00 E05 Personnel Services 802,794.51 571,071.14 0.00 231,723.37 28.86 10-180-511010 Advertising 1,000.00 681.00 0.00 319.00 31.90 10-180-511020 Postage 10,000.00 7,931.07 0.00 2,068.93 20.69 10-180-511021 Mail Machine Cost 3,000.00 1,690.21 0.00 1,309.79 43.66 10-180-512010 Printing 3,000.00 2,020.68 0.00 979.32 32.64 10-180-512020 Copies 1,000.00 24.25 0.00 975.75 97.58 10-180-512021 Copy Machine Cost 190.00 -172.70 0.00 362.70 190.89 10-180-513010 Office Supplies 1,250.00 201.63 0.00 1,048.37 83.87 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 212.56 0.00 3,442.44 94.18 E10 Materials & Supplies 23,095.00 12,588.70 0.00 10,506.30 45.49 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 1,955.00 142.06 0.00 1,812.94 92.73 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 3,004.36 0.00 2,445.64 44.87 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 2,804.00 2,808.00 0.00 -4.00 -0.14 10-180-522010 Audit 59,643.71 45,377.88 0.00 14,265.83 23.92 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 49.12 0.00 100.88 67.25 E15 Contractual Services 70,002.71 51,381.42 0.00 18,621.29 26.60 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 651,609.77 312.30 262,300.60 28.6911 Grand Total -914,222.67 -651,609.77 -312.30 -262,300.60 0.2869 180 Finance Department 914,222.67 651,609.77 312.30 262,300.60 28.69 185 Non-Departmental 10-185-501020 Salaries 16,385.95 0.00 0.00 16,385.95 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 34,558.92 0.00 2,408.51 6.52 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 4,200.00 481.75 0.00 3,718.25 88.53 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,553.38 35,040.67 0.00 22,512.71 39.12 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 15,938.46 0.00 4,061.54 20.31 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 10-185-550034 National Opioid Settlement 67,382.35 570.00 8,048.42 58,763.93 87.21 E10 Materials & Supplies 87,382.35 16,508.46 8,048.42 62,825.47 71.90 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,265.00 0.00 299.00 8.39 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 1,504.50 0.00 -1,504.50 0.00 10-185-522020 Professional Services 111,800.00 49,890.00 14,598.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,126.06 0.00 2,873.94 57.48 E15 Contractual Services 873,965.50 843,666.18 14,598.00 15,701.32 1.80 10-185-531010 Electricity 32,000.00 27,597.04 0.00 4,402.96 13.76 10-185-533010 Natural Gas 6,200.00 5,410.50 0.00 789.50 12.73 10-185-535010 Water 7,250.00 5,620.33 0.00 1,629.67 22.48 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 38,627.87 0.00 6,822.13 15.01 10-185-540010 Building & Grounds Maint.15,000.00 43,819.68 0.00 -28,819.68 -192.13 10-185-540015 Amtrak Station 4,000.00 2,033.95 0.00 1,966.05 49.15 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,696.00 0.00 364.00 17.67 E25 Repairs & Maintenance 46,060.00 72,549.63 0.00 -26,489.63 -57.51 10-185-550010 Miscellaneous 2,800.00 2,199.52 0.00 600.48 21.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 451,560.76 286,991.67 0.00 164,569.09 36.44 E30 Other Operating Expenses 464,360.76 299,191.19 0.00 165,169.57 35.57 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 (09/12/2023 - 04:33 PM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 45,871.97 0.00 -45,871.97 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 45,871.97 0.00 -45,871.97 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,574,771.99 1,351,455.97 22,646.42 200,669.60 12.7428 Grand Total -1,574,771.99 -1,351,455.97 -22,646.42 -200,669.60 0.1274 185 Non-Departmental 1,574,771.99 1,351,455.97 22,646.42 200,669.60 12.74 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 493,164.85 0.00 77,731.35 13.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 36,698.00 0.00 9,727.69 20.95 10-190-502020 Group Health Insurance 96,814.24 63,532.07 0.00 33,282.17 34.38 10-190-502030 Retirement 77,679.59 54,394.62 0.00 23,284.97 29.98 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 543.28 0.00 200.91 27.00 10-190-502060 Long Term Disability 1,815.32 1,472.79 0.00 342.53 18.87 10-190-502070 Employee Assistance Prgm 207.48 145.77 0.00 61.71 29.74 E05 Personnel Services 796,440.92 651,309.59 0.00 145,131.33 18.22 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.64 0.00 0.36 3.60 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 (09/12/2023 - 04:33 PM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 2,000.00 3,154.44 0.00 -1,154.44 -57.72 E10 Materials & Supplies 2,660.00 3,705.24 0.00 -1,045.24 -39.29 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 4,102.61 0.00 4,397.39 51.73 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 20,808.87 0.00 2,191.13 9.53 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 70,976.59 0.00 9,073.41 11.33 10-190-534010 Telephone 96,000.00 70,895.23 0.00 25,104.77 26.15 E20 Utilities 96,000.00 70,895.23 0.00 25,104.77 26.15 10-190-545010 Software License\maint 197,000.00 190,961.25 1,080.00 4,958.75 2.52 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 19,516.76 104.10 2,379.14 10.81 10-190-547025 Coun Chamber MediaEquip Repr 0.00 273.06 0.00 -273.06 0.00 E25 Repairs & Maintenance 219,000.00 210,751.07 1,184.10 7,064.83 3.23 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,007,637.72 1,184.10 185,329.10 15.5197 Grand Total -1,194,150.92 -1,007,637.72 -1,184.10 -185,329.10 0.1552 190 Information Technology Svcs 1,194,150.92 1,007,637.72 1,184.10 185,329.10 15.52 300 Police Department 10-300-501020 Salaries 5,508,103.02 4,257,885.11 0.00 1,250,217.91 22.70 10-300-501030 Holiday Pay 162,165.48 116,981.39 0.00 45,184.09 27.86 10-300-501040 Part-time (w\benefits)40,192.30 0.00 0.00 40,192.30 100.00 10-300-501050 Parttime(wo Benefits)45,858.01 25,348.44 0.00 20,509.57 44.72 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,105.88 0.00 -1,452.75 -18.98 10-300-501090 Overtime 304,257.77 344,342.48 0.00 -40,084.71 -13.17 10-300-501095 Overtime Straight Pay 13,275.00 16,099.35 0.00 -2,824.35 -21.28 10-300-502010 Social Security 444,750.67 347,510.43 0.00 97,240.24 21.86 10-300-502020 Group Health Insurance 960,547.52 712,315.59 0.00 248,231.93 25.84 10-300-502030 Retirement 1,009,334.34 808,392.50 0.00 200,941.84 19.91 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 (09/12/2023 - 04:33 PM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 4,853.87 0.00 1,688.41 25.81 10-300-502060 Long Term Disability 15,894.91 12,993.40 0.00 2,901.51 18.25 10-300-502070 Employee Assistance Prgm 1,960.14 1,388.70 0.00 571.44 29.15 10-300-503010 Awards Program 2,500.00 908.10 0.00 1,591.90 63.68 10-300-503020 Unemployment Compensation 0.00 863.52 0.00 -863.52 0.00 E05 Personnel Services 8,598,120.51 6,734,074.70 0.00 1,864,045.81 21.68 10-300-511010 Advertising 5,665.00 4,319.80 0.00 1,345.20 23.75 10-300-511020 Postage 1,395.00 1,075.72 0.00 319.28 22.89 10-300-512010 Printing 5,951.93 3,412.40 0.00 2,539.53 42.67 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,496.44 0.00 -825.94 -5.27 10-300-514010 Gas 188,862.00 146,729.72 0.00 42,132.28 22.31 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 726.63 765.53 0.00 -38.90 -5.35 10-300-515040 First Aid Supplies 1,378.00 1,713.12 0.00 -335.12 -24.32 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,894.76 0.00 -616.76 -1.33 E10 Materials & Supplies 344,272.75 294,945.08 0.00 49,327.67 14.33 10-300-520030 Dues And Publications 5,400.00 4,824.40 0.00 575.60 10.66 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 76,000.00 68,389.65 0.00 7,610.35 10.01 10-300-520080 Tuition Reimbursement 10,576.11 107.00 0.00 10,469.11 98.99 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 6,850.20 0.00 -340.20 -5.23 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 17,005.14 17,836.14 0.00 -831.00 -4.89 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 48,806.73 0.00 -3,970.73 -8.86 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 655.56 0.00 1,390.44 67.96 E15 Contractual Services 243,454.00 178,561.43 0.00 64,892.57 26.65 10-300-531010 Electricity 42,362.90 33,852.66 0.00 8,510.24 20.09 10-300-533010 Natural Gas 1,033.21 608.40 0.00 424.81 41.12 10-300-534010 Telephone 24,101.00 24,245.96 0.00 -144.96 -0.60 10-300-535010 Water 3,348.00 3,669.73 0.00 -321.73 -9.61 E20 Utilities 70,845.11 62,376.75 0.00 8,468.36 11.95 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 101,874.37 6,975.00 -71,649.37 -192.61 10-300-541030 Vehicle Wash 9,752.00 8,907.00 0.00 845.00 8.66 10-300-544010 K-9 Operations 16,740.00 10,914.83 880.36 4,944.81 29.54 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 27,950.00 25,882.23 0.00 2,067.77 7.40 10-300-545010 Software License\maint 82,414.00 64,645.16 0.00 17,768.84 21.56 10-300-546010 Clothing Expense 48,730.12 20,590.41 130.50 28,009.21 57.48 10-300-546020 Uniform Cleaning 23,715.00 24,164.37 0.00 -449.37 -1.89 10-300-547010 Equipment Maintenance 10,000.00 1,357.82 0.00 8,642.18 86.42 10-300-547020 Maintenance Agreements 56,248.00 39,360.72 6,114.00 10,773.28 19.15 10-300-547030 Radio Maintenance 8,025.00 108.52 0.00 7,916.48 98.65 E25 Repairs & Maintenance 320,774.12 297,805.43 14,099.86 8,868.83 2.76 10-300-572010 Purchase Of Vehicles 46,849.80 46,832.80 0.00 17.00 0.04 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 17,130.00 20,032.93 53.91 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 131,750.00 131,750.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 13,538.67 12,992.32 0.00 546.35 4.04 10-300-572090 Body Worn Cameras 180,000.00 60,000.00 0.00 120,000.00 66.67 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 409,301.40 251,575.12 17,130.00 140,596.28 34.35 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,986,767.89 7,819,338.51 31,229.86 2,136,199.52 21.3903 Grand Total -9,986,767.89 -7,819,338.51 -31,229.86 -2,136,199.52 0.2139 300 Police Department 9,986,767.89 7,819,338.51 31,229.86 2,136,199.52 21.39 310 School Resource Officer 10-310-501020 Salaries 466,059.20 336,162.60 0.00 129,896.60 27.87 10-310-501030 Holiday Pay 20,720.19 256.24 0.00 20,463.95 98.76 10-310-501090 Overtime 68,455.43 77,134.83 0.00 -8,679.40 -12.68 10-310-501095 Overtime Straight Pay 1,796.34 2,099.20 0.00 -302.86 -16.86 10-310-502010 Social Security 42,612.88 29,993.49 0.00 12,619.39 29.61 10-310-502020 Group Health Insurance 89,715.43 63,047.36 0.00 26,668.07 29.73 10-310-502030 Retirement 100,265.61 74,817.57 0.00 25,448.04 25.38 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 383.16 0.00 220.27 36.50 10-310-502060 Long Term Disability 1,498.63 1,029.31 0.00 469.32 31.32 10-310-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 E05 Personnel Services 798,454.72 591,599.38 0.00 206,855.34 25.91 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 2,775.44 6,594.91 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 3,956.56 6,594.91 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 597,780.35 6,699.01 227,299.36 27.3269 Grand Total -831,778.72 -597,780.35 -6,699.01 -227,299.36 0.2733 310 School Resource Officer 831,778.72 597,780.35 6,699.01 227,299.36 27.33 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 126,557.42 107,467.47 0.00 19,089.95 15.08 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 31,077.87 0.00 -1,659.65 -5.64 10-320-501095 Overtime Straight Pay 1,049.54 1,270.50 0.00 -220.96 -21.05 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 10,145.20 0.00 891.98 8.08 10-320-502020 Group Health Insurance 20,462.81 16,553.26 0.00 3,909.55 19.11 10-320-502030 Retirement 25,969.83 25,166.85 0.00 802.98 3.09 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 122.19 0.00 33.26 21.40 10-320-502060 Long Term Disability 384.75 326.41 0.00 58.34 15.16 10-320-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 222,402.83 194,164.83 0.00 28,238.00 12.70 10-320-514010 Gas 11,848.00 6,943.56 0.00 4,904.44 41.39 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 8,011.40 0.00 7,094.60 46.97 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 15,554.96 0.00 16,593.32 51.61 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 10,500.00 0.00 7,000.00 40.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 10,500.00 0.00 7,000.00 40.00 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 220,219.79 0.00 51,831.32 19.0521 Grand Total -272,051.11 -220,219.79 0.00 -51,831.32 0.1905 320 M.U.S.T.A.N.G.272,051.11 220,219.79 0.00 51,831.32 19.05 330 Animal Control 10-330-501020 Salaries 373,650.09 287,053.44 0.00 86,596.65 23.18 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 6,696.61 0.00 1,903.39 22.13 10-330-501090 Overtime 9,887.79 10,723.29 0.00 -835.50 -8.45 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 20,907.77 0.00 8,215.10 28.21 10-330-502020 Group Health Insurance 93,298.71 66,110.79 0.00 27,187.92 29.14 10-330-502030 Retirement 48,728.46 35,596.03 0.00 13,132.43 26.95 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 (09/12/2023 - 04:33 PM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 308.88 0.00 147.67 32.34 10-330-502060 Long Term Disability 1,117.06 860.24 0.00 256.82 22.99 10-330-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 569,717.33 433,060.89 0.00 136,656.44 23.99 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 79.76 0.00 72.24 47.53 10-330-512010 Printing 1,860.00 898.59 0.00 961.41 51.69 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 270.73 0.00 1,010.27 78.87 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 223.00 163.83 0.00 59.17 26.53 10-330-515040 First Aid Supplies 295.00 355.95 0.00 -60.95 -20.66 10-330-517010 Operational Supplies 7,924.82 5,503.17 0.00 2,421.65 30.56 E10 Materials & Supplies 12,640.82 7,272.03 0.00 5,368.79 42.47 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,235.80 0.00 2,125.20 63.23 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,568.47 0.00 4,334.53 31.18 10-330-531010 Electricity 22,789.00 20,311.82 0.00 2,477.18 10.87 10-330-533010 Natural Gas 21,000.00 20,788.17 0.00 211.83 1.01 10-330-534010 Telephone 810.00 756.18 0.00 53.82 6.64 10-330-535010 Water 3,800.00 3,931.68 0.00 -131.68 -3.47 E20 Utilities 48,399.00 45,787.85 0.00 2,611.15 5.40 10-330-540010 Building & Grounds Maint.18,075.18 18,503.49 0.00 -428.31 -2.37 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 45,035.96 0.00 3,754.04 7.69 10-330-544050 Animal Food 6,103.00 4,027.68 0.00 2,075.32 34.00 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 (09/12/2023 - 04:33 PM)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 75,128.15 104.10 6,252.93 7.67 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 613,512.39 104.10 155,223.84 20.1893 Grand Total -768,840.33 -613,512.39 -104.10 -155,223.84 0.2019 330 Animal Control 768,840.33 613,512.39 104.10 155,223.84 20.19 390 9-1-1 Police 10-390-501020 Salaries 994,222.38 738,017.55 0.00 256,204.83 25.77 10-390-501030 Holiday Pay 38,718.75 27,402.44 0.00 11,316.31 29.23 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 11,106.64 12,064.94 0.00 -958.30 -8.63 10-390-501090 Overtime 84,211.43 98,526.12 0.00 -14,314.69 -17.00 10-390-501095 Overtime Straight Pay 3,162.44 3,641.01 0.00 -478.57 -15.13 10-390-502010 Social Security 87,556.95 64,617.81 0.00 22,939.14 26.20 10-390-502020 Group Health Insurance 223,648.25 137,040.31 0.00 86,607.94 38.73 10-390-502030 Retirement 152,546.30 95,234.07 0.00 57,312.23 37.57 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 817.48 0.00 515.46 38.67 10-390-502060 Long Term Disability 3,302.13 2,184.60 0.00 1,117.53 33.84 10-390-502070 Employee Assistance Prgm 480.48 326.07 0.00 154.41 32.14 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,603,008.65 1,182,592.36 0.00 420,416.29 26.23 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,520.11 0.00 1,279.89 18.82 E10 Materials & Supplies 8,200.00 5,520.11 0.00 2,679.89 32.68 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,650.00 2,586.93 0.00 3,063.07 54.21 10-390-522020 Professional Services 4,300.00 4,076.47 0.00 223.53 5.20 10-390-523010 Equipment Rentlease 99,260.00 46,859.76 0.00 52,400.24 52.79 E15 Contractual Services 109,768.00 53,523.16 0.00 56,244.84 51.24 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 (09/12/2023 - 04:33 PM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 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,120.00 240.48 2,639.52 3.52 10-390-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 143,606.00 133,528.94 240.48 9,836.58 6.85 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,389,990.34 240.48 489,177.60 26.0283 Grand Total -1,879,408.42 -1,389,990.34 -240.48 -489,177.60 0.2603 390 9-1-1 Police 1,879,408.42 1,389,990.34 240.48 489,177.60 26.03 400 Fire Department 10-400-501020 Salaries 4,763,879.64 3,506,465.80 0.00 1,257,413.84 26.39 10-400-501025 Other Hours 0.00 2,927.42 0.00 -2,927.42 0.00 10-400-501030 Holiday Pay 341,978.12 308,418.25 0.00 33,559.87 9.81 10-400-501035 Training & Essential Functions 0.00 16,843.63 0.00 -16,843.63 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 30,859.82 0.00 7,140.18 18.79 10-400-501090 Overtime-FLSA 48,689.59 187,527.97 0.00 -138,838.38 -285.15 10-400-501092 Overtime-Constant Staffing 0.00 32,819.38 0.00 -32,819.38 0.00 10-400-501095 Overtime Straight Pay 36,310.41 38,137.35 0.00 -1,826.94 -5.03 10-400-502010 Social Security 69,573.39 58,986.21 0.00 10,587.18 15.22 10-400-502020 Group Health Insurance 877,737.91 691,093.55 0.00 186,644.36 21.26 10-400-502030 Retirement 2,292,378.67 1,994,038.17 0.00 298,340.50 13.01 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 3,969.78 0.00 1,098.80 21.68 10-400-502060 Long Term Disability 12,419.68 10,576.56 0.00 1,843.12 14.84 10-400-502070 Employee Assistance Prgm 1,681.68 1,166.19 0.00 515.49 30.65 10-400-503010 Awards Program 1,194.49 244.35 0.00 950.14 79.54 E05 Personnel Services 8,641,943.11 7,037,105.38 0.00 1,604,837.73 18.57 10-400-511010 Advertising 300.00 277.50 0.00 22.50 7.50 10-400-511020 Postage 320.00 302.96 0.00 17.04 5.33 10-400-512010 Printing 834.12 834.12 0.00 0.00 0.00 10-400-512020 Copies 50.00 0.14 0.00 49.86 99.72 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,376.95 0.00 18.05 1.29 10-400-514010 Gas 61,175.00 58,602.24 0.00 2,572.76 4.21 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 317.27 16.95 0.00 300.32 94.66 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,248.61 6,248.61 0.00 0.00 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,893.17 0.00 206.83 9.85 10-400-517010 Operational Supplies 18,000.00 12,747.10 0.00 5,252.90 29.18 E10 Materials & Supplies 90,740.00 82,299.74 0.00 8,440.26 9.30 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 32,000.00 38,885.31 0.00 -6,885.31 -21.52 10-400-520080 Tuition Reimbursement 7,500.00 10,701.00 0.00 -3,201.00 -42.68 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 44,451.80 44,451.80 0.00 0.00 0.00 10-400-522020 Professional Services 1,000.00 660.00 0.00 340.00 34.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,405.51 5,405.51 0.00 0.00 0.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 96,450.31 104,085.66 0.00 -7,635.35 -7.92 10-400-531010 Electricity 34,000.00 31,067.33 0.00 2,932.67 8.63 10-400-533010 Natural Gas 20,922.45 21,734.89 0.00 -812.44 -3.88 10-400-534010 Telephone 25,731.75 22,340.61 0.00 3,391.14 13.18 10-400-535010 Water 10,000.00 10,238.78 0.00 -238.78 -2.39 E20 Utilities 90,654.20 85,381.61 0.00 5,272.59 5.82 10-400-540010 Building & Grounds Maint.90,000.00 53,411.88 23,190.00 13,398.12 14.89 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 92,548.20 83,508.42 0.00 9,039.78 9.77 10-400-546020 Uniform Cleaning 500.00 370.20 0.00 129.80 25.96 10-400-547010 Equipment Maintenance 20,000.00 14,621.63 0.00 5,378.37 26.89 10-400-547020 Maintenance Agreements 39,487.50 30,957.21 787.90 7,742.39 19.61 10-400-547030 Radio Maintenance 20,925.00 11,421.65 0.00 9,503.35 45.42 E25 Repairs & Maintenance 263,460.70 194,290.99 23,977.90 45,191.81 17.15 10-400-572010 Purchase Of Vehicles 67,456.00 65,282.35 0.00 2,173.65 3.22 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 355.31 0.00 1,144.69 76.31 10-400-572021 Purchase of Equipment-ONE TIME 251,926.95 142,922.50 19,732.50 89,271.95 35.44 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 320,882.95 208,560.16 19,732.50 92,590.29 28.85 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,504,131.27 7,711,723.54 43,710.40 1,748,697.33 18.3993 Grand Total -9,504,131.27 -7,711,723.54 -43,710.40 -1,748,697.33 0.184 400 Fire Department 9,504,131.27 7,711,723.54 43,710.40 1,748,697.33 18.40 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,738.25 0.00 -38.25 -2.25 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,750.99 0.00 -50.99 -3.00 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,750.99 0.00 -50.99 -2.9994 Grand Total -1,700.00 -1,750.99 0.00 50.99 -0.03 401 Fire Museum 1,700.00 1,750.99 0.00 -50.99 -3.00 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 (09/12/2023 - 04:33 PM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.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 208,734.86 0.00 32,235.47 13.38 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 15,284.70 0.00 3,091.02 16.82 10-520-502020 Group Health Insurance 52,232.32 37,621.60 0.00 14,610.72 27.97 10-520-502030 Retirement 30,746.30 24,292.71 0.00 6,453.59 20.99 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 204.67 0.00 91.54 30.90 10-520-502060 Long Term Disability 636.77 534.03 0.00 102.74 16.13 10-520-502070 Employee Assistance Prgm 87.36 46.02 0.00 41.34 47.32 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 343,541.91 286,915.49 0.00 56,626.42 16.48 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 33.27 0.00 41.73 55.64 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.08 0.00 -0.08 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 439.70 0.00 410.30 48.27 10-520-514010 Gas 12,975.00 11,017.53 0.00 1,957.47 15.09 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 1,214.04 0.00 -714.04 -142.81 E10 Materials & Supplies 14,500.00 13,727.12 0.00 772.88 5.33 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 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 (09/12/2023 - 04:33 PM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 32,125.73 32,144.33 263.40 -282.00 -0.88 E25 Repairs & Maintenance 32,125.73 32,144.33 263.40 -282.00 -0.88 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 337,961.45 263.40 58,978.24 14.8484 Grand Total -397,203.09 -337,961.45 -263.40 -58,978.24 0.1485 520 Plan & Protect Svcs-Admin 397,203.09 337,961.45 263.40 58,978.24 14.85 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 57,618.37 86,289.60 0.00 -28,671.23 -49.76 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 6,446.60 0.00 -2,513.83 -63.92 10-521-502020 Group Health Insurance 9,239.72 14,177.02 0.00 -4,937.30 -53.44 10-521-502030 Retirement 6,580.32 11,044.88 0.00 -4,464.56 -67.85 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 97.81 0.00 -35.39 -56.70 10-521-502060 Long Term Disability 156.03 261.24 0.00 -105.21 -67.43 10-521-502070 Employee Assistance Prgm 15.29 41.43 0.00 -26.14 -170.96 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,763.27 118,516.93 0.00 -40,753.66 -52.41 10-521-511010 Advertising 3,336.00 2,760.95 0.00 575.05 17.24 10-521-511020 Postage 500.00 253.61 0.00 246.39 49.28 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 202.72 0.00 597.28 74.66 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 87.66 0.00 112.34 56.17 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,112.53 0.00 387.47 25.83 E10 Materials & Supplies 6,336.00 4,417.47 0.00 1,918.53 30.28 10-521-520030 Dues And Publications 14,032.68 14,032.68 0.00 0.00 0.00 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 687.32 180.00 0.00 507.32 73.81 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 14,212.68 0.00 507.32 3.45 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,271.00 1,114.14 91.12 65.74 5.17 E25 Repairs & Maintenance 1,271.00 1,114.14 91.12 65.74 5.17 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 138,261.22 91.12 -38,262.07 -38.2276 Grand Total -100,090.27 -138,261.22 -91.12 38,262.07 -0.3823 521 Plan & Protect Svcs-Planning 100,090.27 138,261.22 91.12 -38,262.07 -38.23 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 131,978.86 66,492.56 0.00 65,486.30 49.62 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,025.56 0.00 4,949.12 49.62 10-522-502020 Group Health Insurance 20,902.54 9,100.58 0.00 11,801.96 56.46 10-522-502030 Retirement 16,689.66 8,511.22 0.00 8,178.44 49.00 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 76.29 0.00 84.75 52.63 10-522-502060 Long Term Disability 397.13 203.61 0.00 193.52 48.73 10-522-502070 Employee Assistance Prgm 50.23 35.28 0.00 14.95 29.76 E05 Personnel Services 180,256.69 89,547.65 0.00 90,709.04 50.32 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 81.24 0.00 918.76 91.88 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,298.28 0.00 3,301.72 58.96 10-522-520030 Dues And Publications 1,500.00 1,435.73 0.00 64.27 4.28 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 36,410.00 16,508.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 37,845.73 16,508.60 34,645.67 38.93 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 1,224.39 80.81 1,094.80 45.62 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,224.39 80.81 1,094.80 45.62 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 280,656.69 130,916.05 16,589.41 133,151.23 47.4427 Grand Total -280,656.69 -130,916.05 -16,589.41 -133,151.23 0.4744 522 Plan & Protect Svcs-MPO 280,656.69 130,916.05 16,589.41 133,151.23 47.44 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 58,178.00 35,969.30 0.00 22,208.70 38.17 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,640.04 0.00 3,332.95 55.80 10-530-502020 Group Health Insurance 8,770.40 5,821.49 0.00 2,948.91 33.62 10-530-502030 Retirement 9,467.98 4,202.28 0.00 5,265.70 55.62 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 35.95 0.00 104.49 74.40 10-530-502060 Long Term Disability 344.86 92.99 0.00 251.87 73.04 10-530-502070 Employee Assistance Prgm 51.96 10.22 0.00 41.74 80.33 E05 Personnel Services 83,012.93 48,860.14 0.00 34,152.79 41.14 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 14.35 0.00 95.65 86.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 377.04 0.00 202.96 34.99 E10 Materials & Supplies 1,380.00 718.97 0.00 661.03 47.90 10-530-520030 Dues And Publications 604.82 724.70 0.00 -119.88 -19.82 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,895.18 2,022.19 0.00 -127.01 -6.70 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 33,334.00 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,324.62 0.00 -3,324.62 -17.50 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 27,000.00 0.00 0.00 27,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 91,834.00 36,221.86 0.00 55,612.14 60.56 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 587.33 46.86 37.83 5.63 E25 Repairs & Maintenance 672.02 587.33 46.86 37.83 5.63 10-530-550020 NRA-Residential 45,539.18 40,038.77 0.00 5,500.41 12.08 10-530-550030 NRA-Commercial Facade 13,960.82 6,000.00 0.00 7,960.82 57.02 10-530-550031 Historic Preservation Grant 23,030.99 55.75 22,975.24 0.00 0.00 10-530-550032 NRA-Rental Facade 11,281.52 27.00 0.00 11,254.52 99.76 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 1,169.01 92.20 0.00 1,076.81 92.11 10-530-550039 Historic Preservation Grant 50,000.00 67.50 0.00 49,932.50 99.87 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 144,981.52 46,281.22 22,975.24 75,725.06 52.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 321,880.47 132,669.52 23,022.10 166,188.85 51.6306 Grand Total -321,880.47 -132,669.52 -23,022.10 -166,188.85 0.5163 530 Plan & Protect Svc-RedevGrant 321,880.47 132,669.52 23,022.10 166,188.85 51.63 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 203,695.87 164,995.90 0.00 38,699.97 19.00 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 11,764.78 0.00 3,143.53 21.09 10-532-502020 Group Health Insurance 39,644.71 31,274.91 0.00 8,369.80 21.11 10-532-502030 Retirement 24,944.62 21,119.44 0.00 3,825.18 15.33 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 162.01 0.00 76.67 32.12 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 487.64 0.00 105.02 17.72 10-532-502070 Employee Assistance Prgm 65.52 63.92 0.00 1.60 2.44 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 287,843.79 233,622.02 0.00 54,221.77 18.84 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 79.56 0.00 70.44 46.96 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 411.17 0.00 615.83 59.96 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 355.99 0.00 644.01 64.40 E10 Materials & Supplies 2,625.00 1,139.72 0.00 1,485.28 56.58 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 168,078.00 33,600.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 169,350.90 33,600.00 749.10 0.37 10-532-534010 Telephone 1,200.00 1,113.48 0.00 86.52 7.21 E20 Utilities 1,200.00 1,113.48 0.00 86.52 7.21 10-532-540060 Cemetery Maintenance 37,750.00 30,886.39 6,126.00 737.61 1.95 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 560.42 0.00 519.58 48.11 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,310.00 1,016.65 210.78 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 33,747.46 6,336.78 1,385.76 3.34 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 (09/12/2023 - 04:33 PM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 536,838.79 438,973.58 39,936.78 57,928.43 10.7907 Grand Total -536,838.79 -438,973.58 -39,936.78 -57,928.43 0.1079 532 Plan & Protect Svcs-Env Health 536,838.79 438,973.58 39,936.78 57,928.43 10.79 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 187,053.06 159,395.56 0.00 27,657.50 14.79 10-533-501050 Parttime(wo Benefits)25,589.96 25,005.81 0.00 584.15 2.28 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 13,954.95 0.00 2,906.57 17.24 10-533-502020 Group Health Insurance 30,239.78 21,134.23 0.00 9,105.55 30.11 10-533-502030 Retirement 21,096.27 17,351.82 0.00 3,744.45 17.75 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 152.31 0.00 51.50 25.27 10-533-502060 Long Term Disability 505.89 420.76 0.00 85.13 16.83 10-533-502070 Employee Assistance Prgm 65.52 40.91 0.00 24.61 37.56 E05 Personnel Services 283,873.19 239,713.73 0.00 44,159.46 15.56 10-533-511010 Advertising 205.63 205.63 0.00 0.00 0.00 10-533-511020 Postage 1,800.00 1,745.47 0.00 54.53 3.03 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 968.91 0.00 31.09 3.11 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,244.37 1,084.07 0.00 160.30 12.88 E10 Materials & Supplies 4,690.00 4,198.12 0.00 491.88 10.49 10-533-520030 Dues And Publications 500.00 220.44 0.00 279.56 55.91 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 1,013.47 0.00 186.53 15.54 10-533-520080 Tuition Reimbursement 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 26,177.80 0.00 -2,177.80 -9.07 10-533-522022 Demo 235,433.60 133,386.12 11,616.88 90,430.60 38.41 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 209,660.33 11,616.88 123,396.44 35.80 10-533-534010 Telephone 3,701.40 3,247.26 0.00 454.14 12.27 E20 Utilities 3,701.40 3,247.26 0.00 454.14 12.27 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 849.43 0.00 430.57 33.64 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 1,124.93 156.04 -9.97 -0.78 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 2,244.36 156.04 450.60 15.80 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 639,789.24 459,063.80 11,772.92 168,952.52 26.4075 Grand Total -639,789.24 -459,063.80 -11,772.92 -168,952.52 0.2641 533 PPS - Prop MaintCode Enforce 639,789.24 459,063.80 11,772.92 168,952.52 26.41 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 314,201.68 262,734.05 0.00 51,467.63 16.38 10-534-501050 Parttime(wo Benefits)15,900.00 10,388.34 0.00 5,511.66 34.66 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 19,174.06 0.00 5,413.63 22.02 10-534-502020 Group Health Insurance 79,982.22 64,525.40 0.00 15,456.82 19.33 10-534-502030 Retirement 39,104.99 33,629.82 0.00 5,475.17 14.00 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 302.86 0.00 71.68 19.14 10-534-502060 Long Term Disability 929.35 809.73 0.00 119.62 12.87 10-534-502070 Employee Assistance Prgm 109.20 92.07 0.00 17.13 15.69 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 479,945.74 396,412.40 0.00 83,533.34 17.40 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 230.05 0.00 869.95 79.09 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 241.80 0.00 658.20 73.13 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 491.73 0.00 1,308.27 72.68 E10 Materials & Supplies 4,115.00 963.58 0.00 3,151.42 76.58 10-534-520030 Dues And Publications 2,500.00 734.00 0.00 1,766.00 70.64 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 6,660.99 0.00 -1,660.99 -33.22 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 7,394.99 0.00 105.01 1.40 10-534-534010 Telephone 3,060.00 2,541.34 0.00 518.66 16.95 E20 Utilities 3,060.00 2,541.34 0.00 518.66 16.95 10-534-541030 Vehicle Wash 270.00 290.00 0.00 -20.00 -7.41 10-534-546010 Clothing Expense 1,400.00 931.00 0.00 469.00 33.50 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 979.31 47.66 -38.97 -3.94 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,205.31 47.66 425.03 15.87 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 409,517.62 47.66 87,733.46 17.642 Grand Total -497,298.74 -409,517.62 -47.66 -87,733.46 0.1764 534 Plan & Protect Svcs-Bldg Regs 497,298.74 409,517.62 47.66 87,733.46 17.64 535 Public Works-Central Maintenan 10-535-501020 Salaries 413,657.31 341,896.30 0.00 71,761.01 17.35 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 1,832.73 0.00 2,667.27 59.27 10-535-501095 Overtime Straight Pay 500.00 107.59 0.00 392.41 78.48 10-535-502010 Social Security 30,175.52 25,119.77 0.00 5,055.75 16.75 10-535-502020 Group Health Insurance 79,635.09 64,674.37 0.00 14,960.72 18.79 10-535-502030 Retirement 49,977.76 44,011.03 0.00 5,966.73 11.94 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 382.03 0.00 90.43 19.14 10-535-502060 Long Term Disability 1,177.64 1,025.68 0.00 151.96 12.90 10-535-502070 Employee Assistance Prgm 152.88 107.40 0.00 45.48 29.75 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 588,718.02 483,626.26 0.00 105,091.76 17.85 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 2.37 0.00 47.63 95.26 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 848.17 0.00 151.83 15.18 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 4,000.00 1,437.53 0.00 2,562.47 64.06 10-535-517010 Operational Supplies 7,000.00 6,631.43 0.00 368.57 5.27 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 12,140.00 8,936.00 0.00 3,204.00 26.39 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 189.90 0.00 521.22 73.30 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 880.90 0.00 680.22 43.57 10-535-531010 Electricity 6,560.00 5,546.92 0.00 1,013.08 15.44 10-535-533010 Natural Gas 3,200.00 3,245.22 0.00 -45.22 -1.41 10-535-534010 Telephone 420.00 394.51 0.00 25.49 6.07 10-535-535010 Water 1,442.00 1,062.26 0.00 379.74 26.33 E20 Utilities 11,622.00 10,248.91 0.00 1,373.09 11.81 10-535-540010 Building & Grounds Maint.10,000.00 9,980.98 17.50 1.52 0.02 10-535-541010 Veh & Equip Parts Etc 393,400.00 356,589.31 15,567.13 21,243.56 5.40 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 11,683.66 0.00 405.22 3.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 13,695.67 104.10 1,751.23 11.26 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 432,139.88 392,543.81 15,783.46 23,812.61 5.51 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 896,235.88 15,783.46 134,161.68 12.8239 Grand Total -1,046,181.02 -896,235.88 -15,783.46 -134,161.68 0.1282 535 Public Works-Central Maintenan 1,046,181.02 896,235.88 15,783.46 134,161.68 12.82 540 Public Works-Admin 10-540-501020 Salaries 246,836.90 206,152.50 0.00 40,684.40 16.48 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 15,726.72 0.00 2,322.28 12.87 10-540-502020 Group Health Insurance 20,506.66 15,679.38 0.00 4,827.28 23.54 10-540-502030 Retirement 30,199.64 25,129.04 0.00 5,070.60 16.79 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 217.99 0.00 72.10 24.85 10-540-502060 Long Term Disability 569.01 564.29 0.00 4.72 0.83 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 316,736.05 263,735.17 0.00 53,000.88 16.73 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 (09/12/2023 - 04:33 PM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 100.00 47.00 0.00 53.00 53.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,500.00 162.25 0.00 1,337.75 89.18 10-540-514010 Gas 103,850.00 70,888.96 0.00 32,961.04 31.74 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 1,050.00 1,025.80 0.00 24.20 2.30 10-540-517010 Operational Supplies 300.00 79.99 0.00 220.01 73.34 E10 Materials & Supplies 107,100.00 72,207.00 0.00 34,893.00 32.58 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 304.94 15.82 84.24 20.80 E25 Repairs & Maintenance 405.00 304.94 15.82 84.24 20.80 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 426,391.05 337,494.00 15.82 88,881.23 20.845 Grand Total -426,391.05 -337,494.00 -15.82 -88,881.23 0.2085 540 Public Works-Admin 426,391.05 337,494.00 15.82 88,881.23 20.85 541 Public Works-Engineering 10-541-501020 Salaries 884,371.34 728,954.95 0.00 155,416.39 17.57 10-541-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 3,553.66 3,709.70 0.00 -156.04 -4.39 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 53,309.45 0.00 12,524.77 19.02 10-541-502020 Group Health Insurance 132,614.06 114,477.31 0.00 18,136.75 13.68 10-541-502030 Retirement 110,153.99 91,880.03 0.00 18,273.96 16.59 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 843.36 0.00 211.73 20.07 10-541-502060 Long Term Disability 2,488.48 2,242.79 0.00 245.69 9.87 10-541-502070 Employee Assistance Prgm 262.08 184.14 0.00 77.94 29.74 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,206,388.64 1,001,657.45 0.00 204,731.19 16.97 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 116.50 0.00 283.50 70.88 10-541-511020 Postage 400.00 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,145.88 0.00 504.12 30.55 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 539.30 0.00 460.70 46.07 10-541-515080 Surveying Supplies 1,500.00 273.89 0.00 1,226.11 81.74 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 4,131.80 0.00 3,218.20 43.79 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 352.17 0.00 147.83 29.57 E20 Utilities 500.00 352.17 0.00 147.83 29.57 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 575.96 0.00 924.04 61.60 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,118.58 236.06 1,310.36 12.29 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 11,304.54 236.06 2,624.40 18.53 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,022,571.96 236.06 212,595.62 17.2086 Grand Total -1,235,403.64 -1,022,571.96 -236.06 -212,595.62 0.1721 541 Public Works-Engineering 1,235,403.64 1,022,571.96 236.06 212,595.62 17.21 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,420,739.10 1,114,379.71 0.00 306,359.39 21.56 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,383.50 20,473.68 0.00 -90.18 -0.44 10-542-501070 Stand-by Plan 8,800.00 8,238.45 0.00 561.55 6.38 10-542-501090 Overtime 21,542.08 14,928.76 0.00 6,613.32 30.70 10-542-501095 Overtime Straight Pay 4,774.42 1,830.36 0.00 2,944.06 61.66 10-542-502010 Social Security 109,348.68 85,182.74 0.00 24,165.94 22.10 10-542-502020 Group Health Insurance 304,688.92 217,384.33 0.00 87,304.59 28.65 10-542-502030 Retirement 180,402.50 140,789.36 0.00 39,613.14 21.96 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,260.80 0.00 423.42 25.14 10-542-502060 Long Term Disability 4,165.34 3,353.85 0.00 811.49 19.48 10-542-502070 Employee Assistance Prgm 622.44 437.31 0.00 185.13 29.74 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,116,462.04 1,647,370.19 0.00 469,091.85 22.16 10-542-511010 Advertising 750.00 580.00 0.00 170.00 22.67 10-542-511020 Postage 150.00 2.04 0.00 147.96 98.64 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 532.76 0.00 863.24 61.84 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 231,034.87 135,261.70 0.00 95,773.17 41.45 10-542-514030 Small Tools 12,362.18 9,475.11 0.00 2,887.07 23.35 10-542-514040 Food 1,637.82 596.58 0.00 1,041.24 63.57 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 275,000.00 262,791.86 0.00 12,208.14 4.44 10-542-515040 First Aid Supplies 500.00 256.02 0.00 243.98 48.80 10-542-515060 Weed Control 2,000.00 1,592.41 0.00 407.59 20.38 10-542-515070 Const & Inspect Supplies 200.00 144.73 0.00 55.27 27.64 10-542-517010 Operational Supplies 10,811.47 9,081.38 0.00 1,730.09 16.00 E10 Materials & Supplies 535,946.34 420,409.01 0.00 115,537.33 21.56 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 8,684.40 0.00 3,500.00 28.73 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 19,921.70 0.00 7,278.30 26.76 10-542-531010 Electricity 24,364.00 19,758.65 0.00 4,605.35 18.90 10-542-531020 Street Lights 571,962.00 529,947.58 0.00 42,014.42 7.35 10-542-533010 Natural Gas 12,500.00 12,491.27 0.00 8.73 0.07 10-542-534010 Telephone 2,080.00 2,311.54 0.00 -231.54 -11.13 10-542-535010 Water 8,390.00 3,943.86 0.00 4,446.14 52.99 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 619,296.00 568,452.90 0.00 50,843.10 8.21 10-542-540010 Building & Grounds Maint.11,200.00 10,766.92 60.00 373.08 3.33 10-542-541030 Vehicle Wash 7,000.00 6,681.00 0.00 319.00 4.56 10-542-542010 Repairs - StopStreet Lights 35,000.00 16,438.69 0.00 18,561.31 53.03 10-542-542030 Signs & Marking Paint 60,000.00 51,649.74 0.00 8,350.26 13.92 10-542-546010 Clothing Expense 13,000.00 10,981.03 0.00 2,018.97 15.53 10-542-547010 Equipment Maintenance 1,900.00 809.32 0.00 1,090.68 57.40 10-542-547020 Maintenance Agreements 460.00 577.30 104.10 -221.40 -48.13 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 97,904.00 164.10 31,491.90 24.31 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,377.53 0.00 622.47 3.89 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 16,000.00 15,377.53 0.00 622.47 3.89 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,444,464.38 2,769,435.33 164.10 674,864.95 19.5927 Grand Total -3,444,464.38 -2,769,435.33 -164.10 -674,864.95 0.1959 542 Public Works-Street 3,444,464.38 2,769,435.33 164.10 674,864.95 19.59 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 (09/12/2023 - 04:33 PM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 175,000.00 0.00 0.00 0.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 925,000.00 175,000.00 0.00 750,000.00 81.08 10-990-540060 Cemetery Maintenance 30,000.00 3,650.00 0.00 26,350.00 87.83 10-990-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,992.53 0.00 0.00 6,992.53 100.00 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 65,917.60 0.00 0.00 65,917.60 100.00 10-990-576008 Air Streets Stormwater 425,000.00 103,550.65 308,460.10 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 6,710.62 354.73 0.28 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 79.75 145,000.00 4,920.25 3.28 10-990-599505 PD Elevator Replacement 200,000.00 200,000.00 0.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 1,500,000.00 411,619.24 1,088,380.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 98,000.00 850,172.75 78.88 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 276,501.00 0.00 8.44 0.00 E75 Capital Projects 8,701,449.16 1,243,257.45 1,646,551.48 5,811,640.23 66.79 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 1,418,257.45 1,646,551.48 6,561,640.23 68.1626 Grand Total -9,626,449.16 -1,418,257.45 -1,646,551.48 -6,561,640.23 0.6816 990 Capital Projects 9,626,449.16 1,418,257.45 1,646,551.48 6,561,640.23 68.16 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 (09/12/2023 - 04:33 PM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 64,445,998.68 33,202,650.39 1,878,620.60 29,364,727.69 45.56 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 64,445,998.68 33,202,650.39 1,878,620.60 29,364,727.69 45.5649 Grand Total -64,445,998.68 -33,202,650.39 -1,878,620.60 -29,364,727.69 0.4556 GL - Trial Balance by Acct Type and Full Acct Number (09/12/2023 - 04:33 PM)Page 43