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-11 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 11/20/2023 9:39:08 AM Period 01 - 13 Fiscal Year 2024 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 5,400.00 0.00 60,525.00 91.81 10-110-501015 Salary-Prosecuting Attorney 34,999.92 2,916.66 0.00 32,083.26 91.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)18,146.13 301.02 0.00 17,845.11 98.34 10-110-502010 Social Security 9,108.94 650.35 0.00 8,458.59 92.86 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 0.00 0.00 71.59 100.00 E05 Personnel Services 128,251.58 9,268.03 0.00 118,983.55 92.77 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 25.00 0.00 0.00 25.00 100.00 10-110-512010 Printing 350.00 0.00 0.00 350.00 100.00 10-110-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-110-513010 Office Supplies 1,435.00 0.00 0.00 1,435.00 100.00 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 1,825.00 0.00 0.00 1,825.00 100.00 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 2,400.00 0.00 0.00 2,400.00 100.00 10-110-520030 Dues And Publications 6,500.00 0.00 0.00 6,500.00 100.00 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 800.00 0.00 0.00 800.00 100.00 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 9,700.00 0.00 0.00 9,700.00 100.00 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 140.00 0.00 133.72 6.28 4.49 E25 Repairs & Maintenance 140.00 0.00 133.72 6.28 4.49 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 1,000.00 0.00 0.00 1,000.00 100.00 E70 Capital Purchases 1,000.00 0.00 0.00 1,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 140,916.58 9,268.03 133.72 131,514.83 93.3281 Grand Total -140,916.58 -9,268.03 -133.72 -131,514.83 0.9333 110 Mayor & Council 140,916.58 9,268.03 133.72 131,514.83 93.33 120 City Clerk 10-120-501020 Salaries 60,416.48 1,858.96 0.00 58,557.52 96.92 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,621.86 130.88 0.00 4,490.98 97.17 10-120-502020 Group Health Insurance 14,599.86 438.71 0.00 14,161.15 97.00 10-120-502030 Retirement 7,129.15 219.36 0.00 6,909.79 96.92 10-120-502040 Workers Compensation 49.99 0.00 0.00 49.99 100.00 10-120-502050 Life Insurance 74.66 2.29 0.00 72.37 96.93 10-120-502060 Long Term Disability 184.87 6.24 0.00 178.63 96.62 10-120-502070 Employee Assistance Prgm 21.84 0.00 0.00 21.84 100.00 E05 Personnel Services 87,098.71 2,656.44 0.00 84,442.27 96.95 10-120-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 0.00 0.00 300.00 100.00 10-120-513010 Office Supplies 200.00 0.00 0.00 200.00 100.00 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 0.00 0.00 700.00 100.00 10-120-520030 Dues And Publications 75.00 0.00 0.00 75.00 100.00 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 0.00 0.00 400.00 100.00 10-120-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-120-529030 Election Expense 39,000.00 0.00 0.00 39,000.00 100.00 E15 Contractual Services 39,675.00 0.00 0.00 39,675.00 100.00 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 0.00 133.72 10,541.28 98.75 E25 Repairs & Maintenance 10,675.00 0.00 133.72 10,541.28 98.75 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 138,148.71 2,656.44 133.72 135,358.55 97.9803 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -138,148.71 -2,656.44 -133.72 -135,358.55 0.9798 120 City Clerk 138,148.71 2,656.44 133.72 135,358.55 97.98 140 City Administrator 10-140-501020 Salaries 342,835.98 6,846.16 0.00 335,989.82 98.00 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 26,226.95 502.61 0.00 25,724.34 98.08 10-140-502020 Group Health Insurance 27,965.91 855.26 0.00 27,110.65 96.94 10-140-502030 Retirement 40,454.65 620.86 0.00 39,833.79 98.47 10-140-502040 Workers Compensation 201.22 0.00 0.00 201.22 100.00 10-140-502050 Life Insurance 411.26 8.85 0.00 402.41 97.85 10-140-502060 Long Term Disability 647.19 20.74 0.00 626.45 96.80 10-140-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 E05 Personnel Services 438,808.68 8,854.48 0.00 429,954.20 97.98 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 75.00 0.00 0.00 75.00 100.00 10-140-513010 Office Supplies 500.00 0.00 0.00 500.00 100.00 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 1,025.00 0.00 0.00 1,025.00 100.00 10-140-520030 Dues And Publications 1,000.00 0.00 0.00 1,000.00 100.00 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 500.00 0.00 0.00 500.00 100.00 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,500.00 0.00 0.00 1,500.00 100.00 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 0.00 491.88 -191.88 -63.96 E25 Repairs & Maintenance 300.00 0.00 491.88 -191.88 -63.96 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 441,633.68 8,854.48 491.88 432,287.32 97.8837 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -441,633.68 -8,854.48 -491.88 -432,287.32 0.9788 140 City Administrator 441,633.68 8,854.48 491.88 432,287.32 97.88 141 Local Tourism Asset Develop 10-141-501020 Salaries 0.00 0.00 0.00 0.00 0.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 0.00 0.00 0.00 0.00 0.00 10-141-520072 Subrecipient Reimbursements 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 141 Local Tourism Asset Develop 0.00 0.00 0.00 0.00 0.00 142 Community Revitalization 10-142-501020 Salaries 0.00 194.53 0.00 -194.53 0.00 10-142-502010 Social Security 0.00 12.02 0.00 -12.02 0.00 10-142-502020 Group Health Insurance 0.00 63.20 0.00 -63.20 0.00 10-142-502030 Retirement 0.00 22.96 0.00 -22.96 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.24 0.00 -0.24 0.00 10-142-502060 Long Term Disability 0.00 0.65 0.00 -0.65 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 293.60 0.00 -293.60 0.00 10-142-522017 Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-142-522018 Streetscaping 0.00 0.00 0.00 0.00 0.00 10-142-522021 Asbestos Abatement 0.00 0.00 0.00 0.00 0.00 10-142-522022 Demo 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 293.60 0.00 -293.60 0 Grand Total 0.00 -293.60 0.00 293.60 0 142 Community Revitalization 0.00 293.60 0.00 -293.60 0.00 143 CDBG-CV Compass Health 10-143-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-143-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-143-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-143-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-143-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-143-520072 Subrecipient Reimbursements 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 143 CDBG-CV Compass Health 0.00 0.00 0.00 0.00 0.00 144 CDBG-DR 10-144-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-144-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-144-502020 Group Health Insurance 0.00 0.01 0.00 -0.01 0.00 10-144-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 -0.01 0.00 0.01 0.00 10-144-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-144-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-144-528041 Acquisition for Demo 0.00 0.00 0.00 0.00 0.00 10-144-528042 New Construction SF 0.00 0.00 0.00 0.00 0.00 10-144-528043 Multi-Family 0.00 0.00 0.00 0.00 0.00 10-144-528044 Down Payment Assistance 0.00 0.00 0.00 0.00 0.00 10-144-528046 Homeowner Rehab 0.00 0.00 0.00 0.00 0.00 10-144-528047 Infrastructure 0.00 0.00 0.00 0.00 0.00 10-144-528048 Public Service 0.00 0.00 0.00 0.00 0.00 10-144-528049 Planning 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 144 CDBG-DR 0.00 0.00 0.00 0.00 0.00 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 0.00 1,052.27 0.00 -1,052.27 0.00 10-145-502010 Social Security 0.00 70.73 0.00 -70.73 0.00 10-145-502020 Group Health Insurance 0.00 286.00 0.00 -286.00 0.00 10-145-502030 Retirement 0.00 124.16 0.00 -124.16 0.00 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 1.32 0.00 -1.32 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 3.52 0.00 -3.52 0.00 10-145-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 1,538.00 0.00 -1,538.00 0.00 10-145-520072 Subrecipient Reimbursements 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 1,538.00 0.00 -1,538.00 0 Grand Total 0.00 -1,538.00 0.00 1,538.00 0 145 CDBG-CV Cole Co EMS Station 0.00 1,538.00 0.00 -1,538.00 0.00 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 20,337.45 913.32 0.00 19,424.13 95.51 10-146-502010 Social Security 0.00 62.13 0.00 -62.13 0.00 10-146-502020 Group Health Insurance 0.00 240.79 0.00 -240.79 0.00 10-146-502030 Retirement 0.00 107.77 0.00 -107.77 0.00 10-146-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 1.12 0.00 -1.12 0.00 10-146-502060 Long Term Disability 0.00 3.05 0.00 -3.05 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 20,337.45 1,328.18 0.00 19,009.27 93.47 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 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-146-550068 Pass-Through Grants 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 20,337.45 1,328.18 0.00 19,009.27 93.4693 Grand Total -20,337.45 -1,328.18 0.00 -19,009.27 0.9347 146 HPF-P Bruhn Revitalization 20,337.45 1,328.18 0.00 19,009.27 93.47 147 CDBG-CV Transform Housing 10-147-501020 Salaries 0.00 389.06 0.00 -389.06 0.00 10-147-502010 Social Security 0.00 24.02 0.00 -24.02 0.00 10-147-502020 Group Health Insurance 0.00 126.41 0.00 -126.41 0.00 10-147-502030 Retirement 0.00 45.91 0.00 -45.91 0.00 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.00 0.49 0.00 -0.49 0.00 10-147-502060 Long Term Disability 0.00 1.29 0.00 -1.29 0.00 10-147-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 587.18 0.00 -587.18 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-520072 Subrecipient Reimbursements 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 587.18 0.00 -587.18 0 Grand Total 0.00 -587.18 0.00 587.18 0 147 CDBG-CV Transform Housing 0.00 587.18 0.00 -587.18 0.00 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 0.00 0.00 0.00 0.00 0.00 10-148-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 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 148 CDBG-CV 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 10-149-501020 Salaries 65,580.20 1,700.34 0.00 63,879.86 97.41 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 0.00 127.94 0.00 -127.94 0.00 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 0.00 299.56 0.00 -299.56 0.00 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 0.00 200.64 0.00 -200.64 0.00 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 0.00 2.10 0.00 -2.10 0.00 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 0.00 5.71 0.00 -5.71 0.00 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 0.00 0.00 0.00 0.00 0.00 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 65,580.20 2,336.29 0.00 63,243.91 96.44 10-149-511010 Advertising 830.00 0.00 0.00 830.00 100.00 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,030.00 0.00 0.00 1,030.00 100.00 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 0.00 0.00 2,000.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 650.00 0.00 2,005.00 -1,355.00 -208.46 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 0.00 5,000.00 0.00 -5,000.00 0.00 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 50,270.00 0.00 0.00 50,270.00 100.00 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 63,385.80 0.00 0.00 63,385.80 100.00 10-149-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-149-528040 Neighborhood Redevelopmnt 60,000.00 0.00 12,500.00 47,500.00 79.17 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 25,135.00 0.00 0.00 25,135.00 100.00 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 201,440.80 5,000.00 14,505.00 181,935.80 90.32 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 (11/20/2023 - 09:39 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 268,051.00 7,336.29 14,505.00 246,209.71 91.8518 Grand Total -268,051.00 -7,336.29 -14,505.00 -246,209.71 0.9185 149 Entitlement Grant 268,051.00 7,336.29 14,505.00 246,209.71 91.85 150 City Attorney 10-150-501020 Salaries 251,003.67 8,198.72 0.00 242,804.95 96.73 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 19,201.78 604.56 0.00 18,597.22 96.85 10-150-502020 Group Health Insurance 38,330.74 1,148.41 0.00 37,182.33 97.00 10-150-502030 Retirement 29,618.43 664.92 0.00 28,953.51 97.76 10-150-502040 Workers Compensation 230.79 0.00 0.00 230.79 100.00 10-150-502050 Life Insurance 307.22 9.51 0.00 297.71 96.90 10-150-502060 Long Term Disability 629.25 25.85 0.00 603.40 95.89 10-150-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 339,387.40 10,651.97 0.00 328,735.43 96.86 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 0.00 0.00 500.00 100.00 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-150-513010 Office Supplies 500.00 0.00 0.00 500.00 100.00 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,000.00 0.00 0.00 1,000.00 100.00 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 8,500.00 498.74 5,685.58 2,315.68 27.24 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 8,500.00 948.84 0.00 7,551.16 88.84 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 8,500.00 0.00 0.00 8,500.00 100.00 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 26,000.00 1,447.58 5,685.58 18,866.84 72.56 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 440.00 0.00 433.68 6.32 1.44 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 440.00 0.00 433.68 6.32 1.44 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 366,827.40 12,099.55 6,119.26 348,608.59 95.0334 Grand Total -366,827.40 -12,099.55 -6,119.26 -348,608.59 0.9503 150 City Attorney 366,827.40 12,099.55 6,119.26 348,608.59 95.03 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 2,916.66 0.00 32,083.26 91.67 10-160-501020 Salaries 142,510.04 4,384.78 0.00 138,125.26 96.92 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 155.51 0.00 6,844.49 97.78 10-160-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 14,115.01 562.81 0.00 13,552.20 96.01 10-160-502020 Group Health Insurance 23,221.30 624.19 0.00 22,597.11 97.31 10-160-502030 Retirement 16,816.18 517.41 0.00 16,298.77 96.92 10-160-502040 Workers Compensation 198.17 0.00 0.00 198.17 100.00 10-160-502050 Life Insurance 176.26 5.03 0.00 171.23 97.15 10-160-502060 Long Term Disability 436.08 13.68 0.00 422.40 96.86 10-160-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 239,538.48 9,180.07 0.00 230,358.41 96.17 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 0.00 0.00 2,000.00 100.00 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 0.00 0.00 2,500.00 100.00 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 0.00 0.00 4,900.00 100.00 10-160-520025 Security 14,000.00 0.00 0.00 14,000.00 100.00 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 1,500.00 0.00 0.00 1,500.00 100.00 10-160-522020 Professional Services 4,500.00 0.00 0.00 4,500.00 100.00 10-160-525005 Appointed Counsel 3,000.00 0.00 0.00 3,000.00 100.00 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 23,290.00 0.00 0.00 23,290.00 100.00 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 (11/20/2023 - 09:39 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 335.00 1,316.40 4,643.60 73.77 E25 Repairs & Maintenance 6,295.00 335.00 1,316.40 4,643.60 73.77 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 274,023.48 9,515.07 1,316.40 263,192.01 96.0472 Grand Total -274,023.48 -9,515.07 -1,316.40 -263,192.01 0.9605 160 Municipal Court 274,023.48 9,515.07 1,316.40 263,192.01 96.05 170 Human Resources 10-170-501020 Salaries 248,975.73 7,633.05 0.00 241,342.68 96.93 10-170-501050 Parttime(wo Benefits)13,000.00 390.00 0.00 12,610.00 97.00 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 0.00 0.00 100.00 100.00 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 20,048.79 601.62 0.00 19,447.17 97.00 10-170-502020 Group Health Insurance 27,922.60 841.39 0.00 27,081.21 96.99 10-170-502030 Retirement 29,390.94 900.70 0.00 28,490.24 96.94 10-170-502040 Workers Compensation 325.69 0.00 0.00 325.69 100.00 10-170-502050 Life Insurance 304.78 9.13 0.00 295.65 97.00 10-170-502060 Long Term Disability 627.76 25.05 0.00 602.71 96.01 10-170-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 340,761.81 10,400.94 0.00 330,360.87 96.95 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-170-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-170-512020 Copies 500.00 0.00 0.00 500.00 100.00 10-170-513010 Office Supplies 600.00 0.00 0.00 600.00 100.00 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 500.00 -1.44 0.00 501.44 100.29 E10 Materials & Supplies 2,350.00 -1.44 0.00 2,351.44 100.06 10-170-520030 Dues And Publications 700.00 0.00 0.00 700.00 100.00 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 0.00 0.00 3,000.00 100.00 10-170-520070 Training And Education 4,437.00 0.00 0.00 4,437.00 100.00 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 0.00 0.00 500.00 100.00 10-170-522020 Professional Services 1,000.00 0.00 0.00 1,000.00 100.00 10-170-529010 Special Events 800.00 0.00 0.00 800.00 100.00 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 10,437.00 0.00 0.00 10,437.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 59,713.45 0.00 491.88 59,221.57 99.18 E25 Repairs & Maintenance 59,713.45 0.00 491.88 59,221.57 99.18 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 413,262.26 10,399.50 491.88 402,370.88 97.3645 Grand Total -413,262.26 -10,399.50 -491.88 -402,370.88 0.9736 170 Human Resources 413,262.26 10,399.50 491.88 402,370.88 97.36 180 Finance Department 10-180-501020 Salaries 591,685.24 16,982.94 0.00 574,702.30 97.13 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 45,263.92 1,270.75 0.00 43,993.17 97.19 10-180-502020 Group Health Insurance 110,372.73 2,875.87 0.00 107,496.86 97.39 10-180-502030 Retirement 69,818.86 2,003.98 0.00 67,814.88 97.13 10-180-502040 Workers Compensation 498.83 0.00 0.00 498.83 100.00 10-180-502050 Life Insurance 730.73 21.12 0.00 709.61 97.11 10-180-502060 Long Term Disability 1,792.67 57.01 0.00 1,735.66 96.82 10-180-502070 Employee Assistance Prgm 234.78 0.00 0.00 234.78 100.00 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 820,397.76 23,211.67 0.00 797,186.09 97.17 10-180-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-180-511020 Postage 10,000.00 0.00 0.00 10,000.00 100.00 10-180-511021 Mail Machine Cost 3,000.00 0.00 0.00 3,000.00 100.00 10-180-512010 Printing 4,000.00 0.00 0.00 4,000.00 100.00 10-180-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-180-512021 Copy Machine Cost 190.00 0.00 0.00 190.00 100.00 10-180-513010 Office Supplies 1,250.00 0.00 0.00 1,250.00 100.00 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 0.00 0.00 3,655.00 100.00 E10 Materials & Supplies 22,695.00 0.00 0.00 22,695.00 100.00 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,100.00 0.00 0.00 1,100.00 100.00 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 0.00 0.00 5,450.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 67,064.88 0.00 0.00 67,064.88 100.00 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 0.00 0.00 150.00 100.00 E15 Contractual Services 73,764.88 0.00 0.00 73,764.88 100.00 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,157.80 0.00 1,249.20 12,908.60 91.18 E25 Repairs & Maintenance 14,157.80 0.00 1,249.20 12,908.60 91.18 10-180-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 931,015.44 23,211.67 1,249.20 906,554.57 97.3727 Grand Total -931,015.44 -23,211.67 -1,249.20 -906,554.57 0.9737 180 Finance Department 931,015.44 23,211.67 1,249.20 906,554.57 97.37 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.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 0.00 0.00 36,967.43 100.00 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 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 36,967.43 0.00 0.00 36,967.43 100.00 10-185-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-185-514010 Gas 22,000.00 0.00 0.00 22,000.00 100.00 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 0.00 0.00 34,473.75 -34,473.75 0.00 E10 Materials & Supplies 22,500.00 0.00 34,473.75 -11,973.75 -53.22 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 580,171.18 360,571.31 0.00 219,599.87 37.85 10-185-521020 Insurance Deductible 50,000.00 1,975.15 0.00 48,024.85 96.05 10-185-521030 Self Ins Prop & Casualty 40,000.00 1,225.71 0.00 38,774.29 96.94 10-185-521060 Drugalcohol screening 3,564.00 0.00 0.00 3,564.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 62,388.00 5,199.00 23,100.00 34,089.00 54.64 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 0.00 0.00 185,000.00 100.00 10-185-529010 Special Events 5,000.00 -3,390.00 0.00 8,390.00 167.80 E15 Contractual Services 973,123.18 365,581.17 23,100.00 584,442.01 60.06 10-185-531010 Electricity 35,200.00 0.00 0.00 35,200.00 100.00 10-185-533010 Natural Gas 6,510.00 0.00 0.00 6,510.00 100.00 10-185-535010 Water 7,250.00 0.00 0.00 7,250.00 100.00 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 48,960.00 0.00 0.00 48,960.00 100.00 10-185-540010 Building & Grounds Maint.40,000.00 0.00 0.00 40,000.00 100.00 10-185-540015 Amtrak Station 4,000.00 0.00 0.00 4,000.00 100.00 10-185-540020 Tree & Landscape Maint 25,000.00 0.00 0.00 25,000.00 100.00 10-185-547020 Maintenance Agreements 2,060.00 0.00 0.00 2,060.00 100.00 E25 Repairs & Maintenance 71,060.00 0.00 0.00 71,060.00 100.00 10-185-550010 Miscellaneous 2,800.00 0.00 0.00 2,800.00 100.00 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 0.00 0.00 10,000.00 100.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 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 12,800.00 0.00 0.00 12,800.00 100.00 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 (11/20/2023 - 09:39 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 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,165,410.61 365,581.17 57,573.75 742,255.69 63.6905 Grand Total -1,165,410.61 -365,581.17 -57,573.75 -742,255.69 0.6369 185 Non-Departmental 1,165,410.61 365,581.17 57,573.75 742,255.69 63.69 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 27,950.00 0.00 0.00 27,950.00 100.00 E25 Repairs & Maintenance 27,950.00 0.00 0.00 27,950.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 27,950.00 0.00 0.00 27,950.00 100 Grand Total -27,950.00 0.00 0.00 -27,950.00 1 186 Emerg Mgmt Operations 27,950.00 0.00 0.00 27,950.00 100.00 190 Information Technology Svcs 10-190-501020 Salaries 652,615.68 18,645.52 0.00 633,970.16 97.14 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 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 49,925.10 1,386.52 0.00 48,538.58 97.22 10-190-502020 Group Health Insurance 99,908.29 2,706.44 0.00 97,201.85 97.29 10-190-502030 Retirement 77,008.65 2,018.80 0.00 74,989.85 97.38 10-190-502040 Workers Compensation 1,358.21 0.00 0.00 1,358.21 100.00 10-190-502050 Life Insurance 798.05 23.00 0.00 775.05 97.12 10-190-502060 Long Term Disability 1,924.15 62.13 0.00 1,862.02 96.77 10-190-502070 Employee Assistance Prgm 223.86 0.00 0.00 223.86 100.00 E05 Personnel Services 883,761.99 24,842.41 0.00 858,919.58 97.19 10-190-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 0.00 0.00 500.00 100.00 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 (11/20/2023 - 09:39 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 4,000.00 0.00 113.11 3,886.89 97.17 E10 Materials & Supplies 4,560.00 0.00 113.11 4,446.89 97.52 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 0.00 0.00 150.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 7,500.00 0.00 0.00 7,500.00 100.00 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 9,000.00 0.00 1,449.74 7,550.26 83.89 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 1,232.91 0.00 21,767.09 94.64 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 0.00 0.00 4,400.00 100.00 E15 Contractual Services 44,050.00 1,232.91 1,449.74 41,367.35 93.91 10-190-534010 Telephone 90,000.00 0.00 0.00 90,000.00 100.00 E20 Utilities 90,000.00 0.00 0.00 90,000.00 100.00 10-190-545010 Software License\maint 233,000.00 0.00 11,749.18 221,250.82 94.96 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 0.00 416.40 21,583.60 98.11 10-190-547025 Coun Chamber MediaEquip Repr 480.00 0.00 0.00 480.00 100.00 E25 Repairs & Maintenance 255,480.00 0.00 12,165.58 243,314.42 95.24 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,277,851.99 26,075.32 13,728.43 1,238,048.24 96.8851 Grand Total -1,277,851.99 -26,075.32 -13,728.43 -1,238,048.24 0.9689 190 Information Technology Svcs 1,277,851.99 26,075.32 13,728.43 1,238,048.24 96.89 300 Police Department 10-300-501020 Salaries 5,557,743.46 167,919.15 0.00 5,389,824.31 96.98 10-300-501030 Holiday Pay 179,249.71 12,137.20 0.00 167,112.51 93.23 10-300-501040 Part-time (w\benefits)45,305.01 0.00 0.00 45,305.01 100.00 10-300-501050 Parttime(wo Benefits)47,304.18 785.25 0.00 46,518.93 98.34 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 327.59 0.00 4,672.41 93.45 10-300-501090 Overtime 235,884.97 14,513.43 0.00 221,371.54 93.85 10-300-501095 Overtime Straight Pay 13,275.00 393.83 0.00 12,881.17 97.03 10-300-502010 Social Security 465,407.81 14,234.59 0.00 451,173.22 96.94 10-300-502020 Group Health Insurance 1,060,092.76 31,995.25 0.00 1,028,097.51 96.98 10-300-502030 Retirement 996,597.99 31,328.11 0.00 965,269.88 96.86 10-300-502040 Workers Compensation 75,084.94 0.00 0.00 75,084.94 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,900.98 219.77 0.00 6,681.21 96.82 10-300-502060 Long Term Disability 16,618.95 594.23 0.00 16,024.72 96.42 10-300-502070 Employee Assistance Prgm 2,031.12 0.00 0.00 2,031.12 100.00 10-300-503010 Awards Program 2,500.00 0.00 0.00 2,500.00 100.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,708,996.88 274,448.40 0.00 8,434,548.48 96.85 10-300-511010 Advertising 5,665.00 0.00 0.00 5,665.00 100.00 10-300-511020 Postage 1,395.00 0.00 0.00 1,395.00 100.00 10-300-512010 Printing 5,952.00 219.50 0.00 5,732.50 96.31 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 519.76 0.00 15,150.74 96.68 10-300-514010 Gas 195,940.00 0.00 0.00 195,940.00 100.00 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 1,243.75 0.00 0.00 1,243.75 100.00 10-300-515040 First Aid Supplies 1,378.00 0.00 0.00 1,378.00 100.00 10-300-516010 Ammunition & Firearms Supplies 65,000.00 0.00 0.00 65,000.00 100.00 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 335.00 0.00 1,990.00 85.59 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 11,100.00 0.00 0.00 11,100.00 100.00 10-300-517010 Operational Supplies 48,591.90 545.75 0.00 48,046.15 98.88 E10 Materials & Supplies 356,121.15 1,620.01 0.00 354,501.14 99.55 10-300-520030 Dues And Publications 5,400.00 190.00 0.00 5,210.00 96.48 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 45,000.00 8,571.00 0.00 36,429.00 80.95 10-300-520080 Tuition Reimbursement 11,625.00 0.00 0.00 11,625.00 100.00 10-300-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-300-521040 Medical Claimsservices 6,510.00 0.00 0.00 6,510.00 100.00 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 15,674.85 0.00 325.15 2.03 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 -1.48 0.00 2,047.48 100.07 E15 Contractual Services 86,581.00 24,434.37 0.00 62,146.63 71.78 10-300-531010 Electricity 44,640.00 0.00 0.00 44,640.00 100.00 10-300-533010 Natural Gas 1,116.00 0.00 0.00 1,116.00 100.00 10-300-534010 Telephone 24,101.00 70.01 0.00 24,030.99 99.71 10-300-535010 Water 3,348.00 31.41 0.00 3,316.59 99.06 E20 Utilities 73,205.00 101.42 0.00 73,103.58 99.86 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.60,000.00 742.20 0.00 59,257.80 98.76 10-300-541030 Vehicle Wash 9,752.00 0.00 0.00 9,752.00 100.00 10-300-544010 K-9 Operations 16,740.00 0.00 0.00 16,740.00 100.00 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 0.00 11,400.28 0.00 -11,400.28 0.00 10-300-545010 Software License\maint 100,157.50 73,284.99 0.00 26,872.51 26.83 10-300-546010 Clothing Expense 48,920.00 678.07 11,217.69 37,024.24 75.68 10-300-546020 Uniform Cleaning 23,715.00 1,569.85 0.00 22,145.15 93.38 10-300-547010 Equipment Maintenance 10,000.00 0.00 0.00 10,000.00 100.00 10-300-547020 Maintenance Agreements 79,301.88 1,009.44 5,896.80 72,395.64 91.29 10-300-547030 Radio Maintenance 8,025.00 0.00 0.00 8,025.00 100.00 E25 Repairs & Maintenance 356,611.38 88,684.83 17,114.49 250,812.06 70.33 10-300-572010 Purchase Of Vehicles 233,200.00 0.00 0.00 233,200.00 100.00 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 158,338.02 0.00 0.00 158,338.02 100.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 0.00 0.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 0.00 0.00 0.00 0.00 0.00 10-300-572090 Body Worn Cameras 0.00 0.00 0.00 0.00 0.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 391,538.02 0.00 0.00 391,538.02 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,973,053.43 389,289.03 17,114.49 9,566,649.91 95.925 Grand Total -9,973,053.43 -389,289.03 -17,114.49 -9,566,649.91 0.9592 300 Police Department 9,973,053.43 389,289.03 17,114.49 9,566,649.91 95.92 310 School Resource Officer 10-310-501020 Salaries 501,710.46 12,192.90 0.00 489,517.56 97.57 10-310-501030 Holiday Pay 21,214.01 0.00 0.00 21,214.01 100.00 10-310-501090 Overtime 45,106.00 3,144.19 0.00 41,961.81 93.03 10-310-501095 Overtime Straight Pay 1,311.00 492.08 0.00 818.92 62.47 10-310-502010 Social Security 43,554.63 1,135.60 0.00 42,419.03 97.39 10-310-502020 Group Health Insurance 104,608.25 2,677.16 0.00 101,931.09 97.44 10-310-502030 Retirement 96,788.06 2,690.96 0.00 94,097.10 97.22 10-310-502040 Workers Compensation 6,552.86 0.00 0.00 6,552.86 100.00 10-310-502050 Life Insurance 615.82 16.44 0.00 599.38 97.33 10-310-502060 Long Term Disability 1,528.69 44.63 0.00 1,484.06 97.08 10-310-502070 Employee Assistance Prgm 174.72 0.00 0.00 174.72 100.00 E05 Personnel Services 823,164.50 22,393.96 0.00 800,770.54 97.28 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 0.00 0.00 15,345.00 100.00 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 0.00 0.00 22,340.00 100.00 10-310-520070 Training And Education 4,650.00 0.00 0.00 4,650.00 100.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 0.00 0.00 4,650.00 100.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 0.00 0.00 5,974.00 100.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 416.40 811.80 416.40 -811.80 -194.96 E25 Repairs & Maintenance 6,390.40 811.80 416.40 5,162.20 80.78 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 856,544.90 23,205.76 416.40 832,922.74 97.2422 Grand Total -856,544.90 -23,205.76 -416.40 -832,922.74 0.9724 310 School Resource Officer 856,544.90 23,205.76 416.40 832,922.74 97.24 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 130,750.33 3,469.81 0.00 127,280.52 97.35 10-320-501030 Holiday Pay 5,452.54 0.00 0.00 5,452.54 100.00 10-320-501090 Overtime 11,350.31 2,390.03 0.00 8,960.28 78.94 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,287.82 424.33 0.00 10,863.49 96.24 10-320-502020 Group Health Insurance 22,743.74 674.94 0.00 22,068.80 97.03 10-320-502030 Retirement 25,084.04 996.18 0.00 24,087.86 96.03 10-320-502040 Workers Compensation 2,004.39 0.00 0.00 2,004.39 100.00 10-320-502050 Life Insurance 157.90 5.08 0.00 152.82 96.78 10-320-502060 Long Term Disability 394.37 13.73 0.00 380.64 96.52 10-320-502070 Employee Assistance Prgm 43.68 0.00 0.00 43.68 100.00 E05 Personnel Services 209,269.12 7,974.10 0.00 201,295.02 96.19 10-320-514010 Gas 6,300.00 53.92 0.00 6,246.08 99.14 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 0.00 0.00 15,106.00 100.00 10-320-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 21,406.00 53.92 0.00 21,352.08 99.75 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 12,000.00 0.00 0.00 12,000.00 100.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 12,000.00 0.00 0.00 12,000.00 100.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 242,675.12 8,028.02 0.00 234,647.10 96.6919 Grand Total -242,675.12 -8,028.02 0.00 -234,647.10 0.9669 320 M.U.S.T.A.N.G.242,675.12 8,028.02 0.00 234,647.10 96.69 330 Animal Control 10-330-501020 Salaries 394,208.69 11,798.39 0.00 382,410.30 97.01 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 274.46 0.00 8,325.54 96.81 10-330-501090 Overtime 2,000.00 308.52 0.00 1,691.48 84.57 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 30,967.86 857.37 0.00 30,110.49 97.23 10-330-502020 Group Health Insurance 101,449.34 2,663.69 0.00 98,785.65 97.37 10-330-502030 Retirement 47,767.43 1,140.88 0.00 46,626.55 97.61 10-330-502040 Workers Compensation 4,681.08 0.00 0.00 4,681.08 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 487.15 14.61 0.00 472.54 97.00 10-330-502060 Long Term Disability 1,175.12 39.35 0.00 1,135.77 96.65 10-330-502070 Employee Assistance Prgm 174.72 0.00 0.00 174.72 100.00 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 591,511.39 17,097.27 0.00 574,414.12 97.11 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 0.00 0.00 152.00 100.00 10-330-512010 Printing 1,860.00 0.00 0.00 1,860.00 100.00 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 0.00 0.00 1,581.00 100.00 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 0.00 0.00 223.00 100.00 10-330-515040 First Aid Supplies 295.00 0.00 0.00 295.00 100.00 10-330-517010 Operational Supplies 11,000.00 0.00 0.00 11,000.00 100.00 E10 Materials & Supplies 16,016.00 0.00 0.00 16,016.00 100.00 10-330-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 0.00 0.00 2,611.00 100.00 10-330-521040 Medical Claimsservices 690.00 662.54 0.00 27.46 3.98 10-330-522020 Professional Services 4,830.00 0.00 0.00 4,830.00 100.00 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 0.00 0.00 5,208.00 100.00 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,239.00 662.54 0.00 13,576.46 95.35 10-330-531010 Electricity 25,067.90 1,340.17 0.00 23,727.73 94.65 10-330-533010 Natural Gas 22,050.00 2,131.13 0.00 19,918.87 90.34 10-330-534010 Telephone 810.00 11.48 0.00 798.52 98.58 10-330-535010 Water 3,800.00 0.00 0.00 3,800.00 100.00 E20 Utilities 51,727.90 3,482.78 0.00 48,245.12 93.27 10-330-540010 Building & Grounds Maint.15,000.00 850.37 0.00 14,149.63 94.33 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 0.00 0.00 540.00 100.00 10-330-544040 Care Of Animals 49,290.00 10,377.58 0.00 38,912.42 78.95 10-330-544050 Animal Food 6,603.00 205.90 0.00 6,397.10 96.88 10-330-545010 Software Licensemaint 8,087.00 2,345.02 0.00 5,741.98 71.00 10-330-546010 Clothing Expense 2,325.00 0.00 0.00 2,325.00 100.00 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 1,406.40 0.00 416.40 990.00 70.39 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 (11/20/2023 - 09:39 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 2,230.00 0.00 0.00 2,230.00 100.00 E25 Repairs & Maintenance 85,796.40 13,778.87 416.40 71,601.13 83.45 10-330-572010 Purchase of Vehicles 0.00 0.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 0.00 0.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 759,290.69 35,021.46 416.40 723,852.83 95.3328 Grand Total -759,290.69 -35,021.46 -416.40 -723,852.83 0.9533 330 Animal Control 759,290.69 35,021.46 416.40 723,852.83 95.33 390 9-1-1 Police 10-390-501020 Salaries 1,053,365.22 26,589.47 0.00 1,026,775.75 97.48 10-390-501030 Holiday Pay 40,668.88 2,927.81 0.00 37,741.07 92.80 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 22,814.00 2,975.41 0.00 19,838.59 86.96 10-390-501095 Overtime Straight Pay 500.00 98.08 0.00 401.92 80.38 10-390-502010 Social Security 85,477.13 2,382.24 0.00 83,094.89 97.21 10-390-502020 Group Health Insurance 232,987.77 5,722.42 0.00 227,265.35 97.54 10-390-502030 Retirement 136,605.11 3,921.04 0.00 132,684.07 97.13 10-390-502040 Workers Compensation 2,719.96 0.00 0.00 2,719.96 100.00 10-390-502050 Life Insurance 1,302.34 34.87 0.00 1,267.47 97.32 10-390-502060 Long Term Disability 3,220.09 93.97 0.00 3,126.12 97.08 10-390-502070 Employee Assistance Prgm 458.64 0.00 0.00 458.64 100.00 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,580,119.14 44,745.31 0.00 1,535,373.83 97.17 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,225.00 0.00 0.00 6,225.00 100.00 E10 Materials & Supplies 7,625.00 0.00 0.00 7,625.00 100.00 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 0.00 0.00 5,650.00 100.00 10-390-522020 Professional Services 4,300.00 0.00 0.00 4,300.00 100.00 10-390-523010 Equipment Rentlease 99,260.00 7,058.01 0.00 92,201.99 92.89 E15 Contractual Services 109,768.00 7,058.01 0.00 102,709.99 93.57 10-390-531010 Electricity 12,276.00 0.00 0.00 12,276.00 100.00 10-390-533010 Natural Gas 292.95 0.00 0.00 292.95 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 0.00 0.00 837.00 100.00 E20 Utilities 13,405.95 0.00 0.00 13,405.95 100.00 10-390-545010 Software License\maint 53,415.00 48,856.66 0.00 4,558.34 8.53 10-390-546010 Clothing Expense 5,580.00 0.00 0.00 5,580.00 100.00 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 0.00 0.00 4,200.00 100.00 10-390-547020 Maintenance Agreements 79,556.40 10,352.96 0.00 69,203.44 86.99 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 150,377.40 59,209.62 0.00 91,167.78 60.63 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,861,295.49 111,012.94 0.00 1,750,282.55 94.0357 Grand Total -1,861,295.49 -111,012.94 0.00 -1,750,282.55 0.9404 390 9-1-1 Police 1,861,295.49 111,012.94 0.00 1,750,282.55 94.04 400 Fire Department 10-400-501020 Salaries 4,690,038.81 124,405.25 0.00 4,565,633.56 97.35 10-400-501025 Other Hours 0.00 1,140.97 0.00 -1,140.97 0.00 10-400-501030 Holiday Pay 388,303.41 34,120.76 0.00 354,182.65 91.21 10-400-501035 Training & Essential Functions 82,395.68 4,320.51 0.00 78,075.17 94.76 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 55,733.33 1,640.00 0.00 54,093.33 97.06 10-400-501090 Overtime-FLSA 195,037.45 24,977.68 0.00 170,059.77 87.19 10-400-501092 Overtime-Constant Staffing 187,813.69 3,187.19 0.00 184,626.50 98.30 10-400-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-400-502010 Social Security 83,367.55 2,757.85 0.00 80,609.70 96.69 10-400-502020 Group Health Insurance 946,285.13 40,746.04 0.00 905,539.09 95.69 10-400-502030 Retirement 2,805,502.77 96,078.26 0.00 2,709,424.51 96.58 10-400-502040 Workers Compensation 153,030.95 0.00 0.00 153,030.95 100.00 10-400-502050 Life Insurance 5,718.53 170.09 0.00 5,548.44 97.03 10-400-502060 Long Term Disability 13,863.74 463.27 0.00 13,400.47 96.66 10-400-502070 Employee Assistance Prgm 1,659.84 0.00 0.00 1,659.84 100.00 10-400-503010 Awards Program 1,500.00 0.00 0.00 1,500.00 100.00 E05 Personnel Services 9,610,250.88 334,007.87 0.00 9,276,243.01 96.52 10-400-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-400-511020 Postage 120.00 0.00 0.00 120.00 100.00 10-400-512010 Printing 600.00 0.00 0.00 600.00 100.00 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 73.68 0.00 1,321.32 94.72 10-400-514010 Gas 91,180.00 0.00 0.00 91,180.00 100.00 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,000.00 2,639.97 0.00 3,360.03 56.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 0.00 0.00 2,100.00 100.00 10-400-517010 Operational Supplies 18,000.00 719.35 0.00 17,280.65 96.00 E10 Materials & Supplies 120,645.00 3,433.00 0.00 117,212.00 97.15 10-400-520030 Dues And Publications 3,400.00 0.00 0.00 3,400.00 100.00 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 34,000.00 2,515.00 0.00 31,485.00 92.60 10-400-520080 Tuition Reimbursement 7,500.00 0.00 0.00 7,500.00 100.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 0.00 0.00 40,000.00 100.00 10-400-522020 Professional Services 3,000.00 0.00 0.00 3,000.00 100.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,000.00 0.00 0.00 5,000.00 100.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 0.00 0.00 2,500.00 100.00 E15 Contractual Services 95,593.00 2,515.00 0.00 93,078.00 97.37 10-400-531010 Electricity 38,500.00 629.12 0.00 37,870.88 98.37 10-400-533010 Natural Gas 20,000.00 229.71 0.00 19,770.29 98.85 10-400-534010 Telephone 25,984.20 947.44 0.00 25,036.76 96.35 10-400-535010 Water 12,000.00 0.00 0.00 12,000.00 100.00 E20 Utilities 96,484.20 1,806.27 0.00 94,677.93 98.13 10-400-540010 Building & Grounds Maint.90,000.00 175.00 24,340.00 65,485.00 72.76 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 98,000.00 1,525.32 0.00 96,474.68 98.44 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,000.00 0.00 0.00 20,000.00 100.00 10-400-547020 Maintenance Agreements 39,487.20 8,388.84 1,516.17 29,582.19 74.92 10-400-547030 Radio Maintenance 20,925.00 0.00 0.00 20,925.00 100.00 E25 Repairs & Maintenance 268,912.20 10,089.16 25,856.17 232,966.87 86.63 10-400-572010 Purchase Of Vehicles 42,891.00 0.00 0.00 42,891.00 100.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 18,972.50 8,829.00 -1,000.00 11,143.50 58.74 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 61,863.50 8,829.00 -1,000.00 54,034.50 87.34 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 10,253,748.78 360,680.30 24,856.17 9,868,212.31 96.24 Grand Total -10,253,748.78 -360,680.30 -24,856.17 -9,868,212.31 0.9624 400 Fire Department 10,253,748.78 360,680.30 24,856.17 9,868,212.31 96.24 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,900.00 0.00 0.00 1,900.00 100.00 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 300.00 0.00 0.00 300.00 100.00 E20 Utilities 2,200.00 0.00 0.00 2,200.00 100.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 2,200.00 0.00 0.00 2,200.00 100 Grand Total -2,200.00 0.00 0.00 -2,200.00 1 401 Fire Museum 2,200.00 0.00 0.00 2,200.00 100.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.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 247,045.96 7,525.44 0.00 239,520.52 96.95 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,899.02 546.03 0.00 18,352.99 97.11 10-520-502020 Group Health Insurance 57,799.07 1,750.02 0.00 56,049.05 96.97 10-520-502030 Retirement 29,151.42 715.97 0.00 28,435.45 97.54 10-520-502040 Workers Compensation 196.90 0.00 0.00 196.90 100.00 10-520-502050 Life Insurance 303.55 9.54 0.00 294.01 96.86 10-520-502060 Long Term Disability 660.64 25.77 0.00 634.87 96.10 10-520-502070 Employee Assistance Prgm 87.36 0.00 0.00 87.36 100.00 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 354,143.92 10,572.77 0.00 343,571.15 97.01 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 0.00 0.00 75.00 100.00 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 0.00 0.00 850.00 100.00 10-520-514010 Gas 16,490.00 0.00 0.00 16,490.00 100.00 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 0.00 0.00 500.00 100.00 E10 Materials & Supplies 18,015.00 0.00 0.00 18,015.00 100.00 10-520-520030 Dues And Publications 1,200.00 0.00 0.00 1,200.00 100.00 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 0.00 0.00 1,800.00 100.00 10-520-522020 Professional Services 3,000.00 0.00 0.00 3,000.00 100.00 E15 Contractual Services 6,000.00 0.00 0.00 6,000.00 100.00 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 (11/20/2023 - 09:39 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 34,902.55 20.07 1,124.10 33,758.38 96.72 E25 Repairs & Maintenance 34,902.55 20.07 1,124.10 33,758.38 96.72 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 413,061.47 10,592.84 1,124.10 401,344.53 97.1634 Grand Total -413,061.47 -10,592.84 -1,124.10 -401,344.53 0.9716 520 Plan & Protect Svcs-Admin 413,061.47 10,592.84 1,124.10 401,344.53 97.16 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 93,573.53 3,356.26 0.00 90,217.27 96.41 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 7,158.38 250.46 0.00 6,907.92 96.50 10-521-502020 Group Health Insurance 16,621.90 588.09 0.00 16,033.81 96.46 10-521-502030 Retirement 11,041.68 396.03 0.00 10,645.65 96.41 10-521-502040 Workers Compensation 158.35 0.00 0.00 158.35 100.00 10-521-502050 Life Insurance 115.06 4.03 0.00 111.03 96.50 10-521-502060 Long Term Disability 285.42 10.87 0.00 274.55 96.19 10-521-502070 Employee Assistance Prgm 32.76 0.00 0.00 32.76 100.00 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 128,987.08 4,605.74 0.00 124,381.34 96.43 10-521-511010 Advertising 3,336.00 0.00 0.00 3,336.00 100.00 10-521-511020 Postage 500.00 0.00 0.00 500.00 100.00 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 0.00 0.00 800.00 100.00 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 0.00 0.00 1,500.00 100.00 E10 Materials & Supplies 6,336.00 0.00 0.00 6,336.00 100.00 10-521-520030 Dues And Publications 14,209.68 0.00 0.00 14,209.68 100.00 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 15,709.68 0.00 0.00 15,709.68 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,335.00 91.18 1,096.28 147.54 11.05 E25 Repairs & Maintenance 1,335.00 91.18 1,096.28 147.54 11.05 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 152,367.76 4,696.92 1,096.28 146,574.56 96.1979 Grand Total -152,367.76 -4,696.92 -1,096.28 -146,574.56 0.962 521 Plan & Protect Svcs-Planning 152,367.76 4,696.92 1,096.28 146,574.56 96.20 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 109,870.24 2,885.02 0.00 106,985.22 97.37 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 8,405.07 218.28 0.00 8,186.79 97.40 10-522-502020 Group Health Insurance 16,621.90 412.60 0.00 16,209.30 97.52 10-522-502030 Retirement 12,964.69 340.44 0.00 12,624.25 97.37 10-522-502040 Workers Compensation 102.55 0.00 0.00 102.55 100.00 10-522-502050 Life Insurance 135.86 3.58 0.00 132.28 97.36 10-522-502060 Long Term Disability 335.28 9.64 0.00 325.64 97.12 10-522-502070 Employee Assistance Prgm 32.76 0.00 0.00 32.76 100.00 E05 Personnel Services 148,468.35 3,869.56 0.00 144,598.79 97.39 10-522-511010 Advertising 2,600.00 0.00 0.00 2,600.00 100.00 10-522-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 300.00 0.00 0.00 300.00 100.00 10-522-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 5,600.00 0.00 0.00 5,600.00 100.00 10-522-520030 Dues And Publications 1,500.00 0.00 0.00 1,500.00 100.00 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 30,000.00 0.00 3,890.60 26,109.40 87.03 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 39,000.00 0.00 3,890.60 35,109.40 90.02 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,400.00 70.10 988.58 1,341.32 55.89 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 70.10 988.58 1,341.32 55.89 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 198,868.35 3,939.66 4,879.18 190,049.51 95.5655 Grand Total -198,868.35 -3,939.66 -4,879.18 -190,049.51 0.9557 522 Plan & Protect Svcs-MPO 198,868.35 3,939.66 4,879.18 190,049.51 95.57 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,845.53 442.14 0.00 57,403.39 99.24 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 0.00 31.12 0.00 -31.12 0.00 10-530-502020 Group Health Insurance 0.00 106.36 0.00 -106.36 0.00 10-530-502030 Retirement 0.00 52.18 0.00 -52.18 0.00 10-530-502040 Workers Compensation 145.11 0.00 0.00 145.11 100.00 10-530-502050 Life Insurance 0.00 0.56 0.00 -0.56 0.00 10-530-502060 Long Term Disability 0.00 1.49 0.00 -1.49 0.00 10-530-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,990.64 633.85 0.00 57,356.79 98.91 10-530-511010 Advertising 415.00 0.00 0.00 415.00 100.00 10-530-511020 Postage 100.00 0.00 0.00 100.00 100.00 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 100.00 0.00 0.00 100.00 100.00 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 470.00 0.00 0.00 470.00 100.00 E10 Materials & Supplies 1,085.00 0.00 0.00 1,085.00 100.00 10-530-520030 Dues And Publications 250.00 0.00 0.00 250.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 5,000.00 0.00 0.00 5,000.00 100.00 10-530-524026 Household Hazardous Waste 23,000.00 0.00 0.00 23,000.00 100.00 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 9,000.00 0.00 0.00 9,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 41,750.00 0.00 0.00 41,750.00 100.00 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 1,741.02 30.58 566.56 1,143.88 65.70 E25 Repairs & Maintenance 1,741.02 30.58 566.56 1,143.88 65.70 10-530-550020 NRA-Residential 40,000.00 0.00 0.00 40,000.00 100.00 10-530-550030 NRA-Commercial Facade 19,500.00 0.00 0.00 19,500.00 100.00 10-530-550031 Historic Preservation Grant 0.00 0.00 22,975.24 -22,975.24 0.00 10-530-550032 NRA-Rental Facade 15,000.00 0.00 0.00 15,000.00 100.00 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 200.00 0.00 0.00 200.00 100.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 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 74,700.00 0.00 22,975.24 51,724.76 69.24 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 177,266.66 664.43 23,541.80 153,060.43 86.3447 Grand Total -177,266.66 -664.43 -23,541.80 -153,060.43 0.8634 530 Plan & Protect Svc-RedevGrant 177,266.66 664.43 23,541.80 153,060.43 86.34 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 (11/20/2023 - 09:39 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 217,232.39 7,001.63 0.00 210,230.76 96.78 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 16,618.28 534.67 0.00 16,083.61 96.78 10-532-502020 Group Health Insurance 44,266.53 1,402.69 0.00 42,863.84 96.83 10-532-502030 Retirement 25,633.42 877.56 0.00 24,755.86 96.58 10-532-502040 Workers Compensation 3,753.42 0.00 0.00 3,753.42 100.00 10-532-502050 Life Insurance 266.83 7.35 0.00 259.48 97.25 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 661.06 22.57 0.00 638.49 96.59 10-532-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 308,497.45 9,846.47 0.00 298,650.98 96.81 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 0.00 0.00 150.00 100.00 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 0.00 0.00 1,300.00 100.00 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 2,625.00 0.00 0.00 2,625.00 100.00 10-532-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 194,400.00 3,778.11 0.00 190,621.89 98.06 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 196,900.00 3,778.11 0.00 193,121.89 98.08 10-532-534010 Telephone 1,500.00 0.00 0.00 1,500.00 100.00 E20 Utilities 1,500.00 0.00 0.00 1,500.00 100.00 10-532-540060 Cemetery Maintenance 39,000.00 0.00 34,837.00 4,163.00 10.67 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 0.00 0.00 1,290.00 100.00 10-532-546010 Clothing Expense 1,080.00 0.00 0.00 1,080.00 100.00 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 0.00 1,274.04 -364.04 -40.00 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 42,320.00 0.00 36,111.04 6,208.96 14.67 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 (11/20/2023 - 09:39 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 551,842.45 13,624.58 36,111.04 502,106.83 90.9874 Grand Total -551,842.45 -13,624.58 -36,111.04 -502,106.83 0.9099 532 Plan & Protect Svcs-Env Health 551,842.45 13,624.58 36,111.04 502,106.83 90.99 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 167,225.57 5,251.30 0.00 161,974.27 96.86 10-533-501050 Parttime(wo Benefits)20,000.00 1,792.60 0.00 18,207.40 91.04 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 14,322.76 534.44 0.00 13,788.32 96.27 10-533-502020 Group Health Insurance 27,353.91 860.53 0.00 26,493.38 96.85 10-533-502030 Retirement 19,732.62 619.65 0.00 19,112.97 96.86 10-533-502040 Workers Compensation 2,257.38 0.00 0.00 2,257.38 100.00 10-533-502050 Life Insurance 206.86 6.48 0.00 200.38 96.87 10-533-502060 Long Term Disability 511.71 17.57 0.00 494.14 96.57 10-533-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 E05 Personnel Services 251,676.33 9,082.57 0.00 242,593.76 96.39 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.00 0.00 0.00 1,800.00 100.00 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 0.00 0.00 1,350.00 100.00 E10 Materials & Supplies 4,690.00 0.00 0.00 4,690.00 100.00 10-533-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 0.00 0.00 1,200.00 100.00 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522019 Demo-Grant Funded 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 10,000.00 1,860.00 0.00 8,140.00 81.40 10-533-522022 Demo 20,000.00 0.00 39,610.00 -19,610.00 -98.05 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 31,700.00 1,860.00 39,610.00 -9,770.00 -30.82 10-533-534010 Telephone 3,701.40 0.00 0.00 3,701.40 100.00 E20 Utilities 3,701.40 0.00 0.00 3,701.40 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 0.00 0.00 270.00 100.00 10-533-546010 Clothing Expense 1,280.00 0.00 0.00 1,280.00 100.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 41.82 1,334.60 -105.42 -8.29 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 41.82 1,334.60 1,474.58 51.72 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 294,618.73 10,984.39 40,944.60 242,689.74 82.3742 Grand Total -294,618.73 -10,984.39 -40,944.60 -242,689.74 0.8237 533 PPS - Prop MaintCode Enforce 294,618.73 10,984.39 40,944.60 242,689.74 82.37 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 325,779.08 9,968.64 0.00 315,810.44 96.94 10-534-501050 Parttime(wo Benefits)15,900.00 405.16 0.00 15,494.84 97.45 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 26,138.45 724.99 0.00 25,413.46 97.23 10-534-502020 Group Health Insurance 88,283.39 2,644.99 0.00 85,638.40 97.00 10-534-502030 Retirement 38,441.93 1,176.31 0.00 37,265.62 96.94 10-534-502040 Workers Compensation 4,756.07 0.00 0.00 4,756.07 100.00 10-534-502050 Life Insurance 399.02 12.31 0.00 386.71 96.91 10-534-502060 Long Term Disability 991.38 33.29 0.00 958.09 96.64 10-534-502070 Employee Assistance Prgm 109.20 0.00 0.00 109.20 100.00 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 500,798.52 14,965.69 0.00 485,832.83 97.01 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 0.00 0.00 1,100.00 100.00 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 0.00 0.00 900.00 100.00 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 0.00 0.00 1,800.00 100.00 E10 Materials & Supplies 4,115.00 0.00 0.00 4,115.00 100.00 10-534-520030 Dues And Publications 2,500.00 0.00 0.00 2,500.00 100.00 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 6,000.00 696.97 0.00 5,303.03 88.38 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 (11/20/2023 - 09:39 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,500.00 696.97 0.00 7,803.03 91.80 10-534-534010 Telephone 3,060.00 0.00 0.00 3,060.00 100.00 E20 Utilities 3,060.00 0.00 0.00 3,060.00 100.00 10-534-541030 Vehicle Wash 270.00 0.00 0.00 270.00 100.00 10-534-546010 Clothing Expense 1,400.00 0.00 0.00 1,400.00 100.00 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,320.00 0.00 1,053.96 266.04 20.15 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,010.00 0.00 1,053.96 1,956.04 64.98 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 519,483.52 15,662.66 1,053.96 502,766.90 96.7821 Grand Total -519,483.52 -15,662.66 -1,053.96 -502,766.90 0.9678 534 Plan & Protect Svcs-Bldg Regs 519,483.52 15,662.66 1,053.96 502,766.90 96.78 535 Public Works-Central Maintenan 10-535-501020 Salaries 432,501.41 13,068.79 0.00 419,432.62 96.98 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 0.00 0.00 4,500.00 100.00 10-535-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-535-502010 Social Security 33,774.86 958.22 0.00 32,816.64 97.16 10-535-502020 Group Health Insurance 87,782.78 2,450.81 0.00 85,331.97 97.21 10-535-502030 Retirement 51,625.17 1,542.11 0.00 50,083.06 97.01 10-535-502040 Workers Compensation 4,469.36 0.00 0.00 4,469.36 100.00 10-535-502050 Life Insurance 531.22 15.04 0.00 516.18 97.17 10-535-502060 Long Term Disability 1,321.62 40.88 0.00 1,280.74 96.91 10-535-502070 Employee Assistance Prgm 152.88 0.00 0.00 152.88 100.00 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 621,159.30 18,075.85 0.00 603,083.45 97.09 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 6,000.00 0.00 0.00 6,000.00 100.00 10-535-517010 Operational Supplies 6,000.00 0.00 0.00 6,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,140.00 0.00 0.00 13,140.00 100.00 10-535-520030 Dues And Publications 350.00 0.00 0.00 350.00 100.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,850.00 0.00 0.00 1,850.00 100.00 10-535-531010 Electricity 7,216.00 462.93 0.00 6,753.07 93.58 10-535-533010 Natural Gas 3,150.00 25.63 0.00 3,124.37 99.19 10-535-534010 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 Water 1,442.00 0.00 0.00 1,442.00 100.00 E20 Utilities 12,028.00 488.56 0.00 11,539.44 95.94 10-535-540010 Building & Grounds Maint.10,000.00 0.00 0.00 10,000.00 100.00 10-535-541010 Veh & Equip Parts Etc 503,651.77 5,076.94 15,567.13 483,007.70 95.90 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 10,000.00 0.00 0.00 10,000.00 100.00 10-535-547010 Equipment Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 10-535-547020 Maintenance Agreements 17,251.00 0.00 416.40 16,834.60 97.59 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 542,002.77 5,076.94 15,983.53 520,942.30 96.11 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,190,180.07 23,641.35 15,983.53 1,150,555.19 96.6707 Grand Total -1,190,180.07 -23,641.35 -15,983.53 -1,150,555.19 0.9667 535 Public Works-Central Maintenan 1,190,180.07 23,641.35 15,983.53 1,150,555.19 96.67 540 Public Works-Admin 10-540-501020 Salaries 232,494.74 7,193.20 0.00 225,301.54 96.91 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 17,785.85 545.64 0.00 17,240.21 96.93 10-540-502020 Group Health Insurance 21,692.23 640.44 0.00 21,051.79 97.05 10-540-502030 Retirement 27,434.38 848.80 0.00 26,585.58 96.91 10-540-502040 Workers Compensation 219.23 0.00 0.00 219.23 100.00 10-540-502050 Life Insurance 285.19 8.49 0.00 276.70 97.02 10-540-502060 Long Term Disability 534.43 22.90 0.00 511.53 95.72 10-540-502070 Employee Assistance Prgm 65.52 0.00 0.00 65.52 100.00 E05 Personnel Services 300,511.57 9,259.47 0.00 291,252.10 96.92 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.00 0.00 200.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 127,070.00 0.00 0.00 127,070.00 100.00 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 129,070.00 0.00 0.00 129,070.00 100.00 10-540-520030 Dues And Publications 800.00 35.95 0.00 764.05 95.51 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-540-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,000.00 35.95 0.00 3,964.05 99.10 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 305.00 0.00 351.36 -46.36 -15.20 E25 Repairs & Maintenance 305.00 0.00 351.36 -46.36 -15.20 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 433,886.57 9,295.42 351.36 424,239.79 97.7767 Grand Total -433,886.57 -9,295.42 -351.36 -424,239.79 0.9778 540 Public Works-Admin 433,886.57 9,295.42 351.36 424,239.79 97.78 541 Public Works-Engineering 10-541-501020 Salaries 908,304.51 27,086.58 0.00 881,217.93 97.02 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 2,000.00 0.00 0.00 2,000.00 100.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 69,638.29 1,959.33 0.00 67,678.96 97.19 10-541-502020 Group Health Insurance 156,203.72 4,629.67 0.00 151,574.05 97.04 10-541-502030 Retirement 107,415.93 3,142.94 0.00 104,272.99 97.07 10-541-502040 Workers Compensation 6,055.72 0.00 0.00 6,055.72 100.00 10-541-502050 Life Insurance 1,112.62 34.06 0.00 1,078.56 96.94 10-541-502060 Long Term Disability 2,565.79 92.19 0.00 2,473.60 96.41 10-541-502070 Employee Assistance Prgm 262.08 0.00 0.00 262.08 100.00 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,253,558.66 36,944.77 0.00 1,216,613.89 97.05 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 0.00 0.00 400.00 100.00 10-541-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-541-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 0.00 0.00 1,650.00 100.00 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-541-515080 Surveying Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-541-517010 Operational Supplies 2,000.00 0.00 0.00 2,000.00 100.00 E10 Materials & Supplies 7,350.00 0.00 0.00 7,350.00 100.00 10-541-520030 Dues And Publications 3,500.00 0.00 0.00 3,500.00 100.00 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 5,000.00 0.00 0.00 5,000.00 100.00 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,500.00 0.00 0.00 9,500.00 100.00 10-541-534010 Telephone 500.00 0.00 0.00 500.00 100.00 E20 Utilities 500.00 0.00 0.00 500.00 100.00 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 0.00 0.00 1,000.00 100.00 10-541-546010 Clothing Expense 2,500.00 0.00 0.00 2,500.00 100.00 10-541-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-547020 Maintenance Agreements 10,665.00 20.07 1,878.06 8,766.87 82.20 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 20.07 1,878.06 12,266.87 86.60 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,285,073.66 36,964.84 1,878.06 1,246,230.76 96.9774 Grand Total -1,285,073.66 -36,964.84 -1,878.06 -1,246,230.76 0.9698 541 Public Works-Engineering 1,285,073.66 36,964.84 1,878.06 1,246,230.76 96.98 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,431,726.66 58,542.56 0.00 1,373,184.10 95.91 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 71.55 0.00 19,928.45 99.64 10-542-501070 Stand-by Plan 5,000.00 301.01 0.00 4,698.99 93.98 10-542-501090 Overtime 30,000.00 726.29 0.00 29,273.71 97.58 10-542-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-542-502010 Social Security 113,772.84 4,422.86 0.00 109,349.98 96.11 10-542-502020 Group Health Insurance 310,874.53 9,165.52 0.00 301,709.01 97.05 10-542-502030 Retirement 173,132.75 4,906.11 0.00 168,226.64 97.17 10-542-502040 Workers Compensation 39,110.84 0.00 0.00 39,110.84 100.00 10-542-502050 Life Insurance 1,755.22 52.53 0.00 1,702.69 97.01 10-542-502060 Long Term Disability 4,323.95 141.49 0.00 4,182.46 96.73 10-542-502070 Employee Assistance Prgm 622.44 0.00 0.00 622.44 100.00 10-542-503010 Awards Program 200.00 60.50 0.00 139.50 69.75 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,131,019.23 78,390.42 0.00 2,052,628.81 96.32 10-542-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-542-511020 Postage 150.00 0.00 0.00 150.00 100.00 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,400.00 0.00 0.00 1,400.00 100.00 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 288,774.11 0.00 0.00 288,774.11 100.00 10-542-514030 Small Tools 10,000.00 0.00 0.00 10,000.00 100.00 10-542-514040 Food 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515010 Stormwater Material 125,000.00 0.00 0.00 125,000.00 100.00 10-542-515020 Street Materials 225,000.00 0.00 0.00 225,000.00 100.00 10-542-515040 First Aid Supplies 500.00 0.00 0.00 500.00 100.00 10-542-515060 Weed Control 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 7,500.00 0.00 0.00 7,500.00 100.00 E10 Materials & Supplies 663,374.11 0.00 0.00 663,374.11 100.00 10-542-520030 Dues And Publications 1,320.00 0.00 0.00 1,320.00 100.00 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 0.00 0.00 7,680.00 100.00 10-542-521040 Medical Claimsservices 0.00 60.00 0.00 -60.00 0.00 10-542-522020 Professional Services 16,000.00 0.00 0.00 16,000.00 100.00 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 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 26,200.00 60.00 0.00 26,140.00 99.77 10-542-531010 Electricity 24,364.00 879.17 0.00 23,484.83 96.39 10-542-531020 Street Lights 593,000.00 2,270.68 0.00 590,729.32 99.62 10-542-533010 Natural Gas 10,000.00 63.97 0.00 9,936.03 99.36 10-542-534010 Telephone 2,000.00 0.00 0.00 2,000.00 100.00 10-542-535010 Water 12,390.00 0.00 0.00 12,390.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 641,754.00 3,213.82 0.00 638,540.18 99.50 10-542-540010 Building & Grounds Maint.12,000.00 0.00 0.00 12,000.00 100.00 10-542-541030 Vehicle Wash 7,000.00 0.00 0.00 7,000.00 100.00 10-542-542010 Repairs - StopStreet Lights 35,000.00 0.00 0.00 35,000.00 100.00 10-542-542030 Signs & Marking Paint 60,000.00 0.00 0.00 60,000.00 100.00 10-542-546010 Clothing Expense 13,000.00 323.44 0.00 12,676.56 97.51 10-542-547010 Equipment Maintenance 3,200.00 0.00 0.00 3,200.00 100.00 10-542-547020 Maintenance Agreements 360.00 0.00 416.40 -56.40 -15.67 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 131,560.00 323.44 416.40 130,820.16 99.44 10-542-572010 Purchase Of Vehicles 216,225.89 0.00 216,225.89 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 216,225.89 0.00 216,225.89 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,810,133.23 81,987.68 216,642.29 3,511,503.26 92.1622 Grand Total -3,810,133.23 -81,987.68 -216,642.29 -3,511,503.26 0.9216 542 Public Works-Street 3,810,133.23 81,987.68 216,642.29 3,511,503.26 92.16 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 40,000.00 0.00 0.00 40,000.00 100.00 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 131,359.67 0.00 0.00 131,359.67 100.00 10-700-590075 Transit Subsidy 1,130,509.51 0.00 0.00 1,130,509.51 100.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 1,301,869.18 0.00 0.00 1,301,869.18 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,301,869.18 0.00 0.00 1,301,869.18 100 Grand Total -1,301,869.18 0.00 0.00 -1,301,869.18 1 700 Transfers & Subsidies 1,301,869.18 0.00 0.00 1,301,869.18 100.00 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 (11/20/2023 - 09:39 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-990-599502 Downtown Beautification-Match 0.00 0.00 0.00 0.00 0.00 10-990-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-990-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-990-540060 Cemetery Maintenance 0.00 0.00 0.00 0.00 0.00 10-990-572015 Vehicle Leasing 50,000.00 0.00 0.00 50,000.00 100.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 0.00 0.00 0.00 0.00 0.00 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576008 Air Streets Stormwater 0.00 0.00 120,350.60 -120,350.60 0.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 0.00 0.00 0.00 0.00 10-990-576025 Douglas Davis Stormwater 0.00 0.00 0.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 0.00 0.00 0.00 0.00 0.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 0.00 0.00 0.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 0.00 0.00 0.00 0.00 0.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 (11/20/2023 - 09:39 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 0.00 0.00 0.00 0.00 0.00 10-990-578063 Contingency 0.00 0.00 0.00 0.00 0.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 0.00 0.00 145,000.00 -145,000.00 0.00 10-990-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 10-990-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-990-599507 Hyde Park Burn Bldg 0.00 0.00 568,879.67 -568,879.67 0.00 10-990-599508 High Street Viaduct 0.00 0.00 98,000.00 -98,000.00 0.00 10-990-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-990-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 50,000.00 0.00 932,230.27 -882,230.27 -1,764.46 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 50,000.00 0.00 932,230.27 -882,230.27 -1764.4605 Grand Total -50,000.00 0.00 -932,230.27 882,230.27 -17.6446 990 Capital Projects 50,000.00 0.00 932,230.27 -882,230.27 -1,764.46 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 (11/20/2023 - 09:39 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 39,792,888.66 1,618,036.76 1,414,383.17 36,760,468.73 92.38 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 39,792,888.66 1,618,036.76 1,414,383.17 36,760,468.73 92.3795 Grand Total -39,792,888.66 -1,618,036.76 -1,414,383.17 -36,760,468.73 0.9238 GL - Trial Balance by Acct Type and Full Acct Number (11/20/2023 - 09:39 AM)Page 43