Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2022-09 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 09/14/22 11:19:35 Period 01 - 13 Fiscal Year 2022 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 54,225.00 0.00 11,700.00 17.75 10-110-501015 Salary-Prosecuting Attorney 34,999.92 29,166.60 0.00 5,833.32 16.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 5,210.14 0.00 11,388.26 68.61 10-110-502010 Social Security 8,990.53 6,358.97 0.00 2,631.56 29.27 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 126,585.44 95,032.30 0.00 31,553.14 24.93 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 7.26 0.00 92.74 92.74 10-110-512010 Printing 400.00 348.93 0.00 51.07 12.77 10-110-512020 Copies 100.00 2.04 0.00 97.96 97.96 10-110-513010 Office Supplies 2,050.00 1,638.84 0.00 411.16 20.06 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,650.00 1,997.07 0.00 652.93 24.64 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,250.00 1,331.97 0.00 -81.97 -6.56 10-110-520030 Dues And Publications 4,900.00 4,722.80 0.00 177.20 3.62 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,089.84 270.00 0.00 819.84 75.23 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,339.84 6,324.77 0.00 1,015.07 13.83 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 120.00 95.60 19.12 5.28 4.40 E25 Repairs & Maintenance 120.00 95.60 19.12 5.28 4.40 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-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 110 Mayor & Council 136,695.28 103,449.74 19.12 33,226.42 24.31 120 City Clerk 10-120-501020 Salaries 58,183.92 49,262.07 0.00 8,921.85 15.33 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,391.73 3,461.23 0.00 930.50 21.19 10-120-502020 Group Health Insurance 12,676.22 9,838.00 0.00 2,838.22 22.39 10-120-502030 Retirement 7,577.34 6,453.14 0.00 1,124.20 14.84 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 62.42 54.40 0.00 8.02 12.85 10-120-502060 Long Term Disability 155.45 135.67 0.00 19.78 12.72 10-120-502070 Employee Assistance Prgm 21.84 20.44 0.00 1.40 6.41 E05 Personnel Services 83,118.91 69,274.94 0.00 13,843.97 16.66 10-120-511020 Postage 200.00 156.00 0.00 44.00 22.00 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 196.09 0.00 103.91 34.64 10-120-513010 Office Supplies 200.00 164.15 0.00 35.85 17.93 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 516.24 0.00 183.76 26.25 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 378.05 0.00 21.95 5.49 10-120-522020 Professional Services 200.00 39.00 0.00 161.00 80.50 10-120-529030 Election Expense 18,579.79 39,171.92 0.00 -20,592.13 -110.83 E15 Contractual Services 19,254.79 39,653.97 0.00 -20,399.18 -105.94 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,555.00 4,850.47 19.10 5,685.43 53.86 E25 Repairs & Maintenance 10,555.00 4,850.47 19.10 5,685.43 53.86 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 120 City Clerk 113,628.70 114,295.62 19.10 -686.02 -0.60 140 City Administrator 10-140-501020 Salaries 216,956.98 183,901.64 0.00 33,055.34 15.24 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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,537.87 12,560.79 0.00 3,977.08 24.05 10-140-502020 Group Health Insurance 24,948.52 16,163.25 0.00 8,785.27 35.21 10-140-502030 Retirement 29,143.02 24,688.40 0.00 4,454.62 15.29 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 89.35 73.85 0.00 15.50 17.35 10-140-502060 Long Term Disability 218.85 282.16 0.00 -63.31 -28.93 10-140-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 288,139.49 237,912.23 0.00 50,227.26 17.43 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 41.51 0.00 108.49 72.33 10-140-512010 Printing 100.00 80.00 0.00 20.00 20.00 10-140-512020 Copies 150.00 47.78 0.00 102.22 68.15 10-140-513010 Office Supplies 750.00 489.79 0.00 260.21 34.69 10-140-514017 COVID-19 0.00 4,934.00 0.00 -4,934.00 0.00 10-140-517010 Operational Supplies 678.74 362.71 0.00 316.03 46.56 E10 Materials & Supplies 1,828.74 5,955.79 0.00 -4,127.05 -225.68 10-140-520030 Dues And Publications 700.00 1,936.78 0.00 -1,236.78 -176.68 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 500.00 0.00 1,500.00 75.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 400.00 0.00 0.00 400.00 100.00 E15 Contractual Services 3,100.00 2,436.78 0.00 663.22 21.39 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 275.50 19.10 5.40 1.80 E25 Repairs & Maintenance 300.00 275.50 19.10 5.40 1.80 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 140 City Administrator 293,368.23 246,580.30 19.10 46,768.83 15.94 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 45,000.00 0.00 0.00 45,000.00 100.00 10-145-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-145-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-145-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-145-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 45,000.00 0.00 0.00 45,000.00 100.00 10-145-520072 Subrecipient Reimbursements 1,955,000.00 0.00 0.00 1,955,000.00 100.00 E15 Contractual Services 1,955,000.00 0.00 0.00 1,955,000.00 100.00 145 CDBG-CV Cole Co EMS Station 2,000,000.00 0.00 0.00 2,000,000.00 100.00 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-146-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-146-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-146-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-146-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-146-511020 Postage 0.00 64.24 0.00 -64.24 0.00 E10 Materials & Supplies 0.00 64.24 0.00 -64.24 0.00 10-146-522020 Professional Services 420.00 0.00 0.00 420.00 100.00 E15 Contractual Services 420.00 0.00 0.00 420.00 100.00 10-146-550068 Pass-Through Grants 674,580.00 0.00 0.00 674,580.00 100.00 E65 Other Non-Operating Expenses 674,580.00 0.00 0.00 674,580.00 100.00 146 HPF-P Bruhn Revitalization 675,000.00 64.24 0.00 674,935.76 99.99 147 CDBG-CV Transform Housing 10-147-501020 Salaries 31,760.00 0.00 0.00 31,760.00 100.00 10-147-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-147-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-147-502030 Retirement 0.00 0.00 0.00 0.00 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.00 0.00 0.00 0.00 10-147-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-147-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 31,760.00 0.00 0.00 31,760.00 100.00 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 147 CDBG-CV Transform Housing 575,760.00 0.00 0.00 575,760.00 100.00 148 CDBG-CV 10-148-501020 Salaries 48,187.00 36,638.43 0.00 11,548.57 23.97 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-148-502010 Social Security 0.00 2,392.47 0.00 -2,392.47 0.00 10-148-502020 Group Health Insurance 0.00 10,758.30 0.00 -10,758.30 0.00 10-148-502030 Retirement 0.00 5,056.14 0.00 -5,056.14 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 45.26 0.00 -45.26 0.00 10-148-502060 Long Term Disability 0.00 112.31 0.00 -112.31 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 48,187.00 55,002.91 0.00 -6,815.91 -14.14 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 10.12 0.00 -10.12 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 10.12 0.00 -10.12 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 31,500.00 22,500.00 9,000.00 0.00 0.00 10-148-528025 CARES-Childcare Services 124,030.00 38,346.00 0.00 85,684.00 69.08 10-148-528035 CARES-ED For-Profit Business 103,359.00 111,006.23 0.00 -7,647.23 -7.40 10-148-528045 CARES-ED Microenterprise 103,359.00 40,867.96 0.00 62,491.04 60.46 E15 Contractual Services 362,248.00 212,720.19 9,000.00 140,527.81 38.79 148 CDBG-CV 410,435.00 267,733.22 9,000.00 133,701.78 32.58 149 Entitlement Grant 10-149-501020 Salaries 54,522.69 37,552.58 0.00 16,970.11 31.12 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 4,111.65 2,587.88 0.00 1,523.77 37.06 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 14,746.59 8,679.45 0.00 6,067.14 41.14 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,072.09 4,837.20 0.00 2,234.89 31.60 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 60.59 39.22 0.00 21.37 35.27 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 149.89 96.40 0.00 53.49 35.69 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.84 30.68 0.00 -8.84 -40.48 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 80,772.37 53,910.44 0.00 26,861.93 33.26 10-149-511010 Advertising 1,880.00 192.50 0.00 1,687.50 89.76 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 270.00 29.78 0.00 240.22 88.97 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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-513010 Office Supplies 295.00 0.00 0.00 295.00 100.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 220.00 0.00 0.00 220.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,665.00 222.28 0.00 2,442.72 91.66 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 0.00 2,642.00 0.00 -2,642.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 363,643.35 56,184.00 0.00 307,459.35 84.55 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 0.00 313,000.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-149-528040 Neighborhood Redevelopmnt 41,214.50 41,214.50 0.00 0.00 0.00 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 20,000.00 27.00 0.00 19,973.00 99.87 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 738,882.85 100,067.50 313,000.00 325,815.35 44.10 10-149-547020 Maintenance Agreements 361.00 960.19 29.48 -628.67 -174.15 E25 Repairs & Maintenance 361.00 960.19 29.48 -628.67 -174.15 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 149 Entitlement Grant 822,681.22 155,160.41 313,029.48 354,491.33 43.09 150 City Attorney 10-150-501020 Salaries 236,249.51 196,339.80 0.00 39,909.71 16.89 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,954.41 14,529.20 0.00 3,425.21 19.08 10-150-502020 Group Health Insurance 33,887.26 24,840.99 0.00 9,046.27 26.70 10-150-502030 Retirement 31,698.35 26,058.84 0.00 5,639.51 17.79 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502050 Life Insurance 274.18 219.95 0.00 54.23 19.78 10-150-502060 Long Term Disability 591.19 467.59 0.00 123.60 20.91 10-150-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 320,951.21 262,748.52 0.00 58,202.69 18.13 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 426.82 0.00 73.18 14.64 10-150-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-150-512020 Copies 50.00 6.07 0.00 43.93 87.86 10-150-513010 Office Supplies 3,369.00 2,147.82 0.00 1,221.18 36.25 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 4,019.00 2,580.71 0.00 1,438.29 35.79 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,200.00 5,346.28 2,153.30 3,700.42 33.04 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 7,000.00 5,407.52 0.00 1,592.48 22.75 10-150-520080 Tuition Reimbursement 1,869.00 1,869.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 10,000.00 2,490.00 0.00 7,510.00 75.10 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 109,775.02 0.00 -109,775.02 0.00 E15 Contractual Services 30,569.00 124,887.82 2,153.30 -96,472.12 -315.59 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 360.00 335.50 19.10 5.40 1.50 E25 Repairs & Maintenance 360.00 335.50 19.10 5.40 1.50 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 150 City Attorney 355,899.21 390,552.55 2,172.40 -36,825.74 -10.35 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 29,166.60 0.00 5,833.32 16.67 10-160-501020 Salaries 128,437.14 108,827.48 0.00 19,609.66 15.27 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 4,311.94 0.00 2,688.06 38.40 10-160-501090 Overtime 1,500.00 728.90 0.00 771.10 51.41 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,975.17 10,654.12 0.00 2,321.05 17.89 10-160-502020 Group Health Insurance 26,475.46 19,632.31 0.00 6,843.15 25.85 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502030 Retirement 16,575.20 14,083.80 0.00 2,491.40 15.03 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 141.98 118.55 0.00 23.43 16.50 10-160-502060 Long Term Disability 352.27 295.28 0.00 56.99 16.18 10-160-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 228,720.83 188,078.51 0.00 40,642.32 17.77 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,050.00 1,231.45 0.00 1,818.55 59.62 10-160-512010 Printing 400.00 201.93 0.00 198.07 49.52 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 4,000.00 707.46 0.00 3,292.54 82.31 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,450.00 2,140.84 0.00 5,309.16 71.26 10-160-520025 Security 10,000.00 9,505.12 0.00 494.88 4.95 10-160-520030 Dues And Publications 200.00 180.00 0.00 20.00 10.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 695.00 0.00 805.00 53.67 10-160-522020 Professional Services 6,000.00 412.50 0.00 5,587.50 93.13 10-160-525005 Appointed Counsel 4,000.00 1,962.75 0.00 2,037.25 50.93 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 21,990.00 12,755.37 0.00 9,234.63 41.99 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,820.00 0.00 475.00 7.55 E25 Repairs & Maintenance 6,295.00 5,820.00 0.00 475.00 7.55 10-160-572020 Purchase Of Equipment 3,000.00 0.00 0.00 3,000.00 100.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 3,000.00 0.00 0.00 3,000.00 100.00 160 Municipal Court 267,455.83 208,794.72 0.00 58,661.11 21.93 170 Human Resources 10-170-501020 Salaries 233,007.45 197,297.49 0.00 35,709.96 15.33 10-170-501050 Parttime(wo Benefits)13,000.00 14,434.72 0.00 -1,434.72 -11.04 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 42.98 0.00 57.02 57.02 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 18,649.20 15,953.14 0.00 2,696.06 14.46 10-170-502020 Group Health Insurance 24,473.08 19,130.91 0.00 5,342.17 21.83 10-170-502030 Retirement 30,812.70 26,198.01 0.00 4,614.69 14.98 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502050 Life Insurance 265.61 222.10 0.00 43.51 16.38 10-170-502060 Long Term Disability 566.96 470.00 0.00 96.96 17.10 10-170-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 321,266.21 274,136.40 0.00 47,129.81 14.67 10-170-511010 Advertising 0.00 99.75 0.00 -99.75 0.00 10-170-511020 Postage 300.00 166.64 0.00 133.36 44.45 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 350.80 0.00 149.20 29.84 10-170-513010 Office Supplies 900.00 413.46 0.00 486.54 54.06 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 800.00 168.03 0.00 631.97 79.00 E10 Materials & Supplies 3,300.00 1,198.68 0.00 2,101.32 63.68 10-170-520030 Dues And Publications 1,000.00 467.00 0.00 533.00 53.30 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,041.73 0.00 2,458.27 70.24 10-170-520070 Training And Education 5,220.00 2,230.98 0.00 2,989.02 57.26 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 365.75 0.00 134.25 26.85 10-170-522020 Professional Services 32,500.00 10,022.16 19,000.00 3,477.84 10.70 10-170-529010 Special Events 800.00 67.40 0.00 732.60 91.58 10-170-529015 Human Relations Commission 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 44,020.00 14,195.02 19,000.00 10,824.98 24.59 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 21,186.77 21,503.11 19.10 -335.44 -1.58 E25 Repairs & Maintenance 21,186.77 21,503.11 19.10 -335.44 -1.58 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 170 Human Resources 389,772.98 311,033.21 19,019.10 59,720.67 15.32 180 Finance Department 10-180-501020 Salaries 613,538.97 455,687.91 0.00 157,851.06 25.73 10-180-501040 Part-time (wbenefits)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 48,673.35 34,340.83 0.00 14,332.52 29.45 10-180-502020 Group Health Insurance 103,286.70 64,287.32 0.00 38,999.38 37.76 10-180-502030 Retirement 85,042.90 55,025.61 0.00 30,017.29 35.30 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 746.95 487.16 0.00 259.79 34.78 10-180-502060 Long Term Disability 1,758.64 1,172.85 0.00 585.79 33.31 10-180-502070 Employee Assistance Prgm 256.62 224.22 0.00 32.40 12.63 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 853,802.96 611,724.73 0.00 242,078.23 28.35 10-180-511010 Advertising 1,000.00 461.75 0.00 538.25 53.83 10-180-511020 Postage 10,000.00 7,639.64 0.00 2,360.36 23.60 10-180-511021 Mail Machine Cost 3,000.00 1,690.21 0.00 1,309.79 43.66 10-180-512010 Printing 3,300.00 2,398.32 0.00 901.68 27.32 10-180-512020 Copies 1,000.00 45.00 0.00 955.00 95.50 10-180-512021 Copy Machine Cost 190.00 223.81 0.00 -33.81 -17.79 10-180-513010 Office Supplies 3,000.00 495.58 0.00 2,504.42 83.48 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 4,500.00 4,108.64 0.00 391.36 8.70 E10 Materials & Supplies 25,990.00 17,062.95 0.00 8,927.05 34.35 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 2,300.00 1,330.00 0.00 970.00 42.17 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 7,975.76 4,072.00 0.00 3,903.76 48.95 10-180-520080 Tuition Reimbursement 0.00 5,376.00 0.00 -5,376.00 0.00 10-180-522010 Audit 56,553.73 53,642.17 0.00 2,911.56 5.15 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 160.00 0.00 140.00 46.67 E15 Contractual Services 67,129.49 64,580.17 0.00 2,549.32 3.80 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 1,260.00 1,260.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,260.00 1,260.00 0.00 0.00 0.00 10-180-572020 Purchase Of Equipment 0.00 0.00 2,923.35 -2,923.35 0.00 E70 Capital Purchases 0.00 0.00 2,923.35 -2,923.35 0.00 180 Finance Department 948,182.45 694,627.85 2,923.35 250,631.25 26.43 185 Non-Departmental 10-185-501020 Salaries 3,370.29 0.00 0.00 3,370.29 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 35,758.52 0.00 1,208.91 3.27 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 6,000.00 364.54 0.00 5,635.46 93.92 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 46,337.72 36,123.06 0.00 10,214.66 22.04 10-185-514010 Gas 13,000.00 18,174.26 0.00 -5,174.26 -39.80 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 E10 Materials & Supplies 13,000.00 18,174.26 0.00 -5,174.26 -39.80 10-185-520030 Dues and Publications 0.00 49.00 0.00 -49.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 445,389.47 439,291.91 0.00 6,097.56 1.37 10-185-521020 Insurance Deductible 25,000.00 69,953.07 0.00 -44,953.07 -179.81 10-185-521030 Self Ins Prop & Casualty 40,000.00 36,027.05 0.00 3,972.95 9.93 10-185-521060 Drugalcohol screening 3,564.00 2,688.00 0.00 876.00 24.58 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 44,104.18 54,400.00 6,300.00 -16,595.82 -37.63 10-185-522023 LCRA Reimbursement 0.00 112,888.39 0.00 -112,888.39 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 186,668.00 0.00 -1,668.00 -0.90 10-185-529010 Special Events 7,000.00 2,553.61 0.00 4,446.39 63.52 E15 Contractual Services 797,057.65 904,519.03 6,300.00 -113,761.38 -14.27 10-185-531010 Electricity 30,000.00 26,239.81 0.00 3,760.19 12.53 10-185-533010 Natural Gas 5,200.00 6,001.57 0.00 -801.57 -15.41 10-185-535010 Water 7,250.00 5,591.39 0.00 1,658.61 22.88 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 42,450.00 37,832.77 0.00 4,617.23 10.88 10-185-540010 Building & Grounds Maint.122,417.27 125,833.71 0.00 -3,416.44 -2.79 10-185-540015 Amtrak Station 8,000.00 1,987.65 0.00 6,012.35 75.15 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,681.93 0.00 378.07 18.35 E25 Repairs & Maintenance 157,477.27 154,503.29 0.00 2,973.98 1.89 10-185-550010 Miscellaneous 4,000.00 13,098.00 0.00 -9,098.00 -227.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 575,000.00 43,285.84 313,953.00 217,761.16 37.87 E30 Other Operating Expenses 589,000.00 66,383.84 313,953.00 208,663.16 35.43 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 159,452.75 165,179.95 0.00 -5,727.20 -3.59 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 159,452.75 165,179.95 0.00 -5,727.20 -3.59 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 185 Non-Departmental 1,804,775.39 1,382,716.20 320,253.00 101,806.19 5.64 190 Information Technology Svcs 10-190-501020 Salaries 580,870.24 521,230.47 0.00 59,639.77 10.27 10-190-501040 Part-time (wbenefits)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 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 47,046.67 38,406.36 0.00 8,640.31 18.37 10-190-502020 Group Health Insurance 94,024.95 69,580.07 0.00 24,444.88 26.00 10-190-502030 Retirement 81,418.51 59,567.05 0.00 21,851.46 26.84 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 699.52 555.64 0.00 143.88 20.57 10-190-502060 Long Term Disability 1,688.08 1,344.58 0.00 343.50 20.35 10-190-502070 Employee Assistance Prgm 207.48 194.36 0.00 13.12 6.32 E05 Personnel Services 808,513.66 692,236.74 0.00 116,276.92 14.38 10-190-511010 Advertising 2,304.00 2,444.00 0.00 -140.00 -6.08 10-190-511020 Postage 115.00 110.87 0.00 4.13 3.59 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 0.64 0.00 19.36 96.80 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 618.54 0.00 281.46 31.27 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 5,559.67 5,641.65 0.00 -81.98 -1.47 E10 Materials & Supplies 8,898.67 8,815.70 0.00 82.97 0.93 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 139.00 0.00 161.00 53.67 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,940.33 5,757.81 0.00 3,182.52 35.60 10-190-520080 Tuition Reimbursement 4,032.00 1,344.00 0.00 2,688.00 66.67 10-190-522020 Professional Services 44,195.71 40,150.00 0.00 4,045.71 9.15 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 19,450.27 0.00 3,549.73 15.43 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 4,315.00 0.00 85.00 1.93 E15 Contractual Services 84,868.04 71,156.08 0.00 13,711.96 16.16 10-190-534010 Telephone 56,000.00 62,301.74 0.00 -6,301.74 -11.25 E20 Utilities 56,000.00 62,301.74 0.00 -6,301.74 -11.25 10-190-545010 Software Licensemaint 217,595.35 211,670.86 18,399.49 -12,475.00 -5.73 10-190-545020 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 Equipment Maintenance 2,000.00 759.98 0.00 1,240.02 62.00 10-190-547020 Maintenance Agreements 22,000.00 10,712.00 16,495.38 -5,207.38 -23.67 E25 Repairs & Maintenance 243,595.35 223,142.84 34,894.87 -14,442.36 -5.93 10-190-572020 Purchase Of Equipment 435.29 1,058.28 0.00 -622.99 -143.12 E70 Capital Purchases 435.29 1,058.28 0.00 -622.99 -143.12 190 Information Technology Svcs 1,202,311.01 1,058,711.38 34,894.87 108,704.76 9.04 300 Police Department 10-300-501020 Salaries 5,080,360.46 4,032,814.57 0.00 1,047,545.89 20.62 10-300-501030 Holiday Pay 176,918.37 77,278.58 0.00 99,639.79 56.32 10-300-501040 Part-time (wbenefits)34,764.59 0.00 0.00 34,764.59 100.00 10-300-501050 Parttime(wo Benefits)47,304.18 26,081.41 0.00 21,222.77 44.86 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 9,360.00 14,503.71 0.00 -5,143.71 -54.95 10-300-501090 Overtime 307,140.24 252,389.24 0.00 54,751.00 17.83 10-300-501095 Overtime Straight Pay 13,275.00 16,055.05 0.00 -2,780.05 -20.94 10-300-502010 Social Security 428,314.82 320,127.99 0.00 108,186.83 25.26 10-300-502020 Group Health Insurance 920,452.34 664,829.47 0.00 255,622.87 27.77 10-300-502030 Retirement 988,207.96 715,465.76 0.00 272,742.20 27.60 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502040 Workers Compensation 75,085.94 75,085.91 0.00 0.03 0.00 10-300-502050 Life Insurance 5,495.76 4,132.65 0.00 1,363.11 24.80 10-300-502060 Long Term Disability 13,637.73 10,247.00 0.00 3,390.73 24.86 10-300-502070 Employee Assistance Prgm 1,976.52 1,851.60 0.00 124.92 6.32 10-300-503010 Awards Program 4,233.00 4,233.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,106,526.91 6,215,095.94 0.00 1,891,430.97 23.33 10-300-511010 Advertising 5,665.00 8,898.00 0.00 -3,233.00 -57.07 10-300-511020 Postage 1,395.00 1,292.65 0.00 102.35 7.34 10-300-512010 Printing 4,452.00 4,345.49 0.00 106.51 2.39 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 634.90 79.99 0.00 554.91 87.40 10-300-513010 Office Supplies 15,670.50 18,876.81 0.00 -3,206.31 -20.46 10-300-514010 Gas 164,000.00 177,785.84 0.00 -13,785.84 -8.41 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 968.93 0.00 -317.93 -48.84 10-300-515040 First Aid Supplies 1,378.00 1,345.46 0.00 32.54 2.36 10-300-516010 Ammunition & Firearms Supplies 34,365.57 20,675.64 13,405.25 284.68 0.83 10-300-516020 Dare Program 0.00 90.00 0.00 -90.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 12,750.00 12,750.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 70,050.00 62,586.70 11,050.21 -3,586.91 -5.12 E10 Materials & Supplies 313,336.97 309,695.51 24,455.46 -20,814.00 -6.64 10-300-520030 Dues And Publications 5,400.00 5,085.36 0.00 314.64 5.83 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 75,900.00 71,036.86 0.00 4,863.14 6.41 10-300-520080 Tuition Reimbursement 5,625.00 0.00 0.00 5,625.00 100.00 10-300-520090 Recruitment 2,325.00 3,078.07 0.00 -753.07 -32.39 10-300-521040 Medical Claimsservices 6,510.00 6,609.20 0.00 -99.20 -1.52 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,082.00 15,996.33 0.00 85.67 0.53 10-300-522026 Drug Forfeiture - Justice 74,953.39 60,486.70 13,065.60 1,401.09 1.87 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 35,515.20 0.00 -35,515.20 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,772.64 0.00 273.36 13.36 E15 Contractual Services 188,841.39 199,580.36 13,065.60 -23,804.57 -12.61 10-300-531010 Electricity 32,140.00 29,396.73 0.00 2,743.27 8.54 10-300-533010 Natural Gas 1,116.00 714.35 0.00 401.65 35.99 10-300-534010 Telephone 24,101.00 19,580.59 0.00 4,520.41 18.76 10-300-535010 Water 3,348.00 2,083.56 0.00 1,264.44 37.77 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 60,705.00 51,775.23 0.00 8,929.77 14.71 10-300-540010 Building & Grounds Maint.49,700.00 57,961.78 0.00 -8,261.78 -16.62 10-300-541030 Vehicle Wash 9,752.00 8,113.80 0.00 1,638.20 16.80 10-300-544010 K-9 Operations 16,740.00 17,203.43 0.00 -463.43 -2.77 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 22,599.00 12,158.53 0.00 10,440.47 46.20 10-300-545010 Software Licensemaint 74,123.00 61,159.98 0.00 12,963.02 17.49 10-300-546010 Clothing Expense 51,687.00 18,397.99 37,859.55 -4,570.54 -8.84 10-300-546020 Uniform Cleaning 20,715.00 17,247.46 0.00 3,467.54 16.74 10-300-547010 Equipment Maintenance 6,500.00 2,945.73 0.00 3,554.27 54.68 10-300-547020 Maintenance Agreements 57,121.00 42,851.58 0.00 14,269.42 24.98 10-300-547030 Radio Maintenance 2,300.00 756.51 0.00 1,543.49 67.11 E25 Repairs & Maintenance 311,237.00 238,796.79 37,859.55 34,580.66 11.11 10-300-572010 Purchase Of Vehicles 88,833.60 88,468.28 0.00 365.32 0.41 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 65,930.10 36,382.50 29,547.60 0.00 0.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 53,192.80 0.00 46,750.00 6,442.80 12.11 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 11,260.75 0.00 6,397.49 4,863.26 43.19 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 4,295.20 0.00 0.00 4,295.20 100.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 223,512.45 124,850.78 82,695.09 15,966.58 7.14 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 300 Police Department 9,204,159.72 7,139,794.61 158,075.70 1,906,289.41 20.71 310 School Resource Officer 10-310-501020 Salaries 459,344.05 292,617.44 0.00 166,726.61 36.30 10-310-501030 Holiday Pay 17,071.90 4,459.23 0.00 12,612.67 73.88 10-310-501090 Overtime 45,106.00 41,573.46 0.00 3,532.54 7.83 10-310-501095 Overtime Straight Pay 1,311.00 2,755.65 0.00 -1,444.65 -110.19 10-310-502010 Social Security 39,998.49 24,513.99 0.00 15,484.50 38.71 10-310-502020 Group Health Insurance 94,284.62 54,287.89 0.00 39,996.73 42.42 10-310-502030 Retirement 96,492.66 62,017.18 0.00 34,475.48 35.73 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 504.29 304.19 0.00 200.10 39.68 10-310-502060 Long Term Disability 1,247.26 754.85 0.00 492.41 39.48 10-310-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 E05 Personnel Services 762,087.85 490,000.42 0.00 272,087.43 35.70 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 3,036.46 7,209.50 5,099.04 33.23 10-310-517010 Operational Supplies 5,995.00 6,208.10 0.00 -213.10 -3.55 E10 Materials & Supplies 21,340.00 9,244.56 7,209.50 4,885.94 22.90 10-310-520070 Training And Education 4,650.00 1,264.00 0.00 3,386.00 72.82 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,264.00 0.00 3,386.00 72.82 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 6,974.00 2,736.90 4,899.00 -661.90 -9.49 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 E25 Repairs & Maintenance 7,334.00 2,736.90 4,899.00 -301.90 -4.12 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 310 School Resource Officer 795,411.85 503,245.88 12,108.50 280,057.47 35.21 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 113,859.54 98,505.01 0.00 15,354.53 13.49 10-320-501030 Holiday Pay 4,112.08 0.00 0.00 4,112.08 100.00 10-320-501090 Overtime 29,776.88 20,325.95 0.00 9,450.93 31.74 10-320-501095 Overtime Straight Pay 0.00 428.36 0.00 -428.36 0.00 10-320-502010 Social Security 9,893.63 8,807.09 0.00 1,086.54 10.98 10-320-502020 Group Health Insurance 19,512.74 15,125.75 0.00 4,386.99 22.48 10-320-502030 Retirement 23,622.41 21,709.29 0.00 1,913.12 8.10 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 118.73 99.55 0.00 19.18 16.15 10-320-502060 Long Term Disability 293.76 246.12 0.00 47.64 16.22 10-320-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 203,237.84 167,292.43 0.00 35,945.41 17.69 10-320-514010 Gas 11,348.00 9,547.62 0.00 1,800.38 15.87 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,906.00 11,280.71 0.00 2,625.29 18.88 10-320-517010 Operational Supplies 8,446.20 999.95 0.00 7,446.25 88.16 E10 Materials & Supplies 33,700.20 21,828.28 0.00 11,871.92 35.23 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 22,152.72 13,500.00 0.00 8,652.72 39.06 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,152.72 13,500.00 0.00 8,652.72 39.06 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 320 M.U.S.T.A.N.G.259,090.76 202,620.71 0.00 56,470.05 21.80 330 Animal Control 10-330-501020 Salaries 383,190.92 292,592.26 0.00 90,598.66 23.64 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 6,972.98 0.00 1,627.02 18.92 10-330-501090 Overtime 2,000.00 6,687.05 0.00 -4,687.05 -234.35 10-330-501095 Overtime Straight Pay 0.00 79.09 0.00 -79.09 0.00 10-330-502010 Social Security 30,125.00 21,597.58 0.00 8,527.42 28.31 10-330-502020 Group Health Insurance 93,893.80 61,097.19 0.00 32,796.61 34.93 10-330-502030 Retirement 51,583.15 34,413.14 0.00 17,170.01 33.29 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 434.52 304.93 0.00 129.59 29.82 10-330-502060 Long Term Disability 1,077.61 749.04 0.00 328.57 30.49 10-330-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 575,760.80 429,338.02 0.00 146,422.78 25.43 10-330-511010 Advertising 405.00 991.75 0.00 -586.75 -144.88 10-330-511020 Postage 152.00 160.24 0.00 -8.24 -5.42 10-330-512010 Printing 1,860.00 871.74 0.00 988.26 53.13 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-513010 Office Supplies 1,581.00 558.59 0.00 1,022.41 64.67 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 140.94 0.00 82.06 36.80 10-330-515040 First Aid Supplies 295.00 261.64 0.00 33.36 11.31 10-330-517010 Operational Supplies 12,016.00 4,665.61 0.00 7,350.39 61.17 E10 Materials & Supplies 16,532.00 7,650.51 0.00 8,881.49 53.72 10-330-520030 Dues And Publications 1,491.00 31.25 0.00 1,459.75 97.90 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 1,538.00 0.00 1,073.00 41.10 10-330-521040 Medical Claimsservices 432.00 1,298.60 0.00 -866.60 -200.60 10-330-522020 Professional Services 6,510.00 1,592.00 0.00 4,918.00 75.55 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 8,782.37 0.00 -3,574.37 -68.63 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 33,031.25 0.00 33,031.25 0.00 0.00 E15 Contractual Services 49,283.25 13,242.22 33,031.25 3,009.78 6.11 10-330-531010 Electricity 22,789.00 17,510.86 0.00 5,278.14 23.16 10-330-533010 Natural Gas 18,000.00 20,529.61 0.00 -2,529.61 -14.05 10-330-534010 Telephone 580.00 806.02 0.00 -226.02 -38.97 10-330-535010 Water 3,800.00 2,816.39 0.00 983.61 25.88 E20 Utilities 45,169.00 41,662.88 0.00 3,506.12 7.76 10-330-540010 Building & Grounds Maint.15,000.00 25,738.43 0.00 -10,738.43 -71.59 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 49,290.00 39,109.96 0.00 10,180.04 20.65 10-330-544050 Animal Food 6,603.00 3,855.28 0.00 2,747.72 41.61 10-330-545010 Software Licensemaint 3,191.00 2,778.08 424.56 -11.64 -0.36 10-330-546010 Clothing Expense 2,325.00 1,280.12 0.00 1,044.88 44.94 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 837.00 836.17 0.00 0.83 0.10 10-330-547020 Maintenance Agreements 360.00 510.02 0.00 -150.02 -41.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 61.20 0.00 1,688.80 96.50 E25 Repairs & Maintenance 79,956.00 74,709.26 424.56 4,822.18 6.03 10-330-572010 Purchase of Vehicles 25,523.00 25,523.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 4,600.00 4,600.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 30,123.00 30,123.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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 330 Animal Control 796,824.05 596,725.89 33,455.81 166,642.35 20.91 390 9-1-1 Police 10-390-501020 Salaries 987,543.13 719,512.09 0.00 268,031.04 27.14 10-390-501030 Holiday Pay 31,748.70 22,801.48 0.00 8,947.22 28.18 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-501090 Overtime 22,814.00 44,111.26 0.00 -21,297.26 -93.35 10-390-501095 Overtime Straight Pay 500.00 1,668.06 0.00 -1,168.06 -233.61 10-390-502010 Social Security 76,901.79 57,599.99 0.00 19,301.80 25.10 10-390-502020 Group Health Insurance 217,337.41 135,083.80 0.00 82,253.61 37.85 10-390-502030 Retirement 135,500.14 100,830.04 0.00 34,670.10 25.59 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,093.34 749.10 0.00 344.24 31.49 10-390-502060 Long Term Disability 2,691.88 1,854.80 0.00 837.08 31.10 10-390-502070 Employee Assistance Prgm 464.10 434.76 0.00 29.34 6.32 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,479,314.45 1,087,365.34 0.00 391,949.11 26.50 10-390-511010 Advertising 928.00 1,702.50 0.00 -774.50 -83.46 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 8,651.62 0.00 -2,426.62 -38.98 E10 Materials & Supplies 7,153.00 10,354.12 0.00 -3,201.12 -44.75 10-390-520030 Dues And Publications 558.00 220.00 0.00 338.00 60.57 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 4,650.00 1,020.40 0.00 3,629.60 78.06 10-390-522020 Professional Services 3,000.00 2,624.41 0.00 375.59 12.52 10-390-523010 Equipment Rentlease 96,760.00 63,529.82 0.00 33,230.18 34.34 E15 Contractual Services 104,968.00 67,394.63 0.00 37,573.37 35.80 10-390-531010 Electricity 11,160.00 9,684.25 0.00 1,475.75 13.22 10-390-533010 Natural Gas 279.00 234.00 0.00 45.00 16.13 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 1,127.78 0.00 -290.78 -34.74 E20 Utilities 12,276.00 11,046.03 0.00 1,229.97 10.02 10-390-545010 Software Licensemaint 42,901.00 46,535.53 0.00 -3,634.53 -8.47 10-390-546010 Clothing Expense 5,580.00 2,119.91 0.00 3,460.09 62.01 10-390-546020 Uniform Cleaning 2,976.00 1,315.80 0.00 1,660.20 55.79 10-390-547010 Equipment Maintenance 6,700.00 5,341.01 1,043.62 315.37 4.71 10-390-547020 Maintenance Agreements 88,613.00 61,624.09 8,671.38 18,317.53 20.67 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 151,420.00 116,936.34 9,715.00 24,768.66 16.36 10-390-572020 Purchase Of Equipment 30,545.00 16,310.00 14,235.00 0.00 0.00 E70 Capital Purchases 30,545.00 16,310.00 14,235.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 390 9-1-1 Police 1,785,676.45 1,309,406.46 23,950.00 452,319.99 25.33 400 Fire Department 10-400-501020 Salaries 4,259,710.27 3,471,005.32 0.00 788,704.95 18.52 10-400-501030 Holiday Pay 329,190.84 303,924.46 0.00 25,266.38 7.68 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 38,000.00 26,978.85 0.00 11,021.15 29.00 10-400-501090 Overtime 45,000.00 93,433.70 0.00 -48,433.70 -107.63 10-400-501095 Overtime Straight Pay 40,000.00 73,055.95 0.00 -33,055.95 -82.64 10-400-502010 Social Security 69,912.07 56,624.77 0.00 13,287.30 19.01 10-400-502020 Group Health Insurance 857,281.66 637,352.18 0.00 219,929.48 25.65 10-400-502030 Retirement 2,168,347.96 1,801,517.03 0.00 366,830.93 16.92 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 4,724.64 3,848.21 0.00 876.43 18.55 10-400-502060 Long Term Disability 11,754.80 9,436.02 0.00 2,318.78 19.73 10-400-502070 Employee Assistance Prgm 1,659.84 1,554.92 0.00 104.92 6.32 10-400-503010 Awards Program 1,500.00 499.02 0.00 1,000.98 66.73 E05 Personnel Services 7,980,113.03 6,632,261.38 0.00 1,347,851.65 16.89 10-400-511010 Advertising 300.00 105.00 0.00 195.00 65.00 10-400-511020 Postage 139.50 157.75 0.00 -18.25 -13.08 10-400-512010 Printing 700.00 433.22 0.00 266.78 38.11 10-400-512020 Copies 46.50 0.00 0.00 46.50 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 1,006.72 0.00 388.28 27.83 10-400-514010 Gas 59,000.00 76,894.33 0.00 -17,894.33 -30.33 10-400-514017 COVID-19 8,481.00 10,069.27 0.00 -1,588.27 -18.73 10-400-514020 Chemicals 930.00 100.00 0.00 830.00 89.25 10-400-514030 Small Tools 6,000.00 3,871.26 0.00 2,128.74 35.48 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,046.00 1,760.17 0.00 285.83 13.97 10-400-517010 Operational Supplies 17,000.00 6,119.52 0.00 10,880.48 64.00 E10 Materials & Supplies 96,038.00 100,517.24 0.00 -4,479.24 -4.66 10-400-520030 Dues And Publications 3,373.65 3,462.09 0.00 -88.44 -2.62 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,427.51 27,143.84 0.00 5,283.67 16.29 10-400-520080 Tuition Reimbursement 7,045.00 6,048.00 0.00 997.00 14.15 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 34,944.00 0.00 5,056.00 12.64 10-400-522020 Professional Services 3,333.00 2,067.73 0.00 1,265.27 37.96 10-400-523010 Equipment Rentlease 186.00 0.00 0.00 186.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 6,510.00 4,982.57 0.00 1,527.43 23.46 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,605.00 0.00 895.00 35.80 E15 Contractual Services 95,468.16 80,253.23 0.00 15,214.93 15.94 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-531010 Electricity 35,000.00 30,960.25 0.00 4,039.75 11.54 10-400-533010 Natural Gas 17,670.00 19,815.33 0.00 -2,145.33 -12.14 10-400-534010 Telephone 25,984.20 20,659.32 0.00 5,324.88 20.49 10-400-535010 Water 12,000.00 9,365.69 0.00 2,634.31 21.95 E20 Utilities 90,654.20 80,800.59 0.00 9,853.61 10.87 10-400-540010 Building & Grounds Maint.81,455.49 76,976.86 325.00 4,153.63 5.10 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 96,004.91 86,195.41 0.00 9,809.50 10.22 10-400-546020 Uniform Cleaning 500.00 196.00 0.00 304.00 60.80 10-400-547010 Equipment Maintenance 20,667.24 11,526.23 0.00 9,141.01 44.23 10-400-547020 Maintenance Agreements 38,412.76 36,919.47 38.78 1,454.51 3.79 10-400-547030 Radio Maintenance 20,925.00 13,742.61 0.00 7,182.39 34.32 E25 Repairs & Maintenance 257,965.40 225,556.58 363.78 32,045.04 12.42 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 1,719.69 0.00 -1,719.69 0.00 10-400-572021 Purchase of Equipment-ONE TIME 24,640.00 22,310.00 0.00 2,330.00 9.46 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 24,640.00 24,029.69 0.00 610.31 2.48 400 Fire Department 8,544,878.79 7,143,418.71 363.78 1,401,096.30 16.40 401 Fire Museum 10-401-531010 Electricity 1,860.00 2,042.50 0.00 -182.50 -9.81 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,860.00 2,042.50 0.00 -182.50 -9.81 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 401 Fire Museum 1,860.00 2,042.50 0.00 -182.50 -9.81 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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 246,716.82 198,978.79 0.00 47,738.03 19.35 10-520-501040 Part-time (wbenefits)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,636.48 14,524.37 0.00 4,112.11 22.06 10-520-502020 Group Health Insurance 31,670.84 32,271.53 0.00 -600.69 -1.90 10-520-502030 Retirement 32,238.75 23,725.84 0.00 8,512.91 26.41 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 275.40 213.92 0.00 61.48 22.32 10-520-502060 Long Term Disability 605.64 459.39 0.00 146.25 24.15 10-520-502070 Employee Assistance Prgm 87.36 61.36 0.00 26.00 29.76 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 330,428.19 270,432.10 0.00 59,996.09 18.16 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-511020 Postage 75.00 204.47 0.00 -129.47 -172.63 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 444.36 0.00 405.64 47.72 10-520-514010 Gas 13,000.00 13,398.63 0.00 -398.63 -3.07 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 254.48 0.00 245.52 49.10 E10 Materials & Supplies 14,525.00 14,301.94 0.00 223.06 1.54 10-520-520030 Dues And Publications 1,200.00 1,320.85 0.00 -120.85 -10.07 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 25.00 0.00 1,775.00 98.61 10-520-522020 Professional Services 9,756.70 7,251.21 0.00 2,505.49 25.68 E15 Contractual Services 12,756.70 8,597.06 0.00 4,159.64 32.61 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 28,348.00 38,664.54 0.00 -10,316.54 -36.39 E25 Repairs & Maintenance 28,348.00 38,664.54 0.00 -10,316.54 -36.39 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 520 Plan & Protect Svcs-Admin 386,057.89 331,995.64 0.00 54,062.25 14.00 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 134,036.16 86,227.83 0.00 47,808.33 35.67 10-521-501040 Part-time (wbenefits)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 11,609.48 6,442.32 0.00 5,167.16 44.51 10-521-502020 Group Health Insurance 25,099.96 13,140.52 0.00 11,959.44 47.65 10-521-502030 Retirement 20,252.59 9,839.24 0.00 10,413.35 51.42 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 176.62 95.74 0.00 80.88 45.79 10-521-502060 Long Term Disability 435.33 238.06 0.00 197.27 45.32 10-521-502070 Employee Assistance Prgm 58.97 55.24 0.00 3.73 6.33 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 191,827.46 116,197.30 0.00 75,630.16 39.43 10-521-511010 Advertising 4,000.00 2,891.50 0.00 1,108.50 27.71 10-521-511020 Postage 500.00 81.06 0.00 418.94 83.79 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 258.79 0.00 541.21 67.65 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 1,051.96 0.00 448.04 29.87 E10 Materials & Supplies 7,000.00 4,283.31 0.00 2,716.69 38.81 10-521-520030 Dues And Publications 14,329.49 14,373.68 0.00 -44.19 -0.31 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 2,400.00 0.00 0.00 2,400.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 16,729.49 14,373.68 0.00 2,355.81 14.08 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,552.00 1,101.69 44.23 406.08 26.16 E25 Repairs & Maintenance 1,552.00 1,101.69 44.23 406.08 26.16 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 521 Plan & Protect Svcs-Planning 217,108.95 135,955.98 44.23 81,108.74 37.36 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 125,900.96 101,439.66 0.00 24,461.30 19.43 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 95.22 0.00 -95.22 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,877.44 7,704.85 0.00 2,172.59 22.00 10-522-502020 Group Health Insurance 20,600.84 13,697.94 0.00 6,902.90 33.51 10-522-502030 Retirement 17,473.13 13,109.90 0.00 4,363.23 24.97 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 150.91 110.59 0.00 40.32 26.72 10-522-502060 Long Term Disability 374.46 274.26 0.00 100.20 26.76 10-522-502070 Employee Assistance Prgm 50.23 47.04 0.00 3.19 6.35 E05 Personnel Services 174,530.52 136,582.01 0.00 37,948.51 21.74 10-522-511010 Advertising 1,800.00 546.05 0.00 1,253.95 69.66 10-522-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-522-513010 Office Supplies 1,000.00 29.28 0.00 970.72 97.07 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 31.89 0.00 1,588.11 98.03 E10 Materials & Supplies 5,005.00 607.22 0.00 4,397.78 87.87 10-522-520030 Dues And Publications 1,500.00 1,273.87 0.00 226.13 15.08 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 20.00 0.00 4,480.00 99.56 10-522-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-522-522020 Professional Services 108,000.00 18,988.00 89,112.00 -100.00 -0.09 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 114,000.00 20,281.87 89,112.00 4,606.13 4.04 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,533.00 1,116.60 44.23 372.17 24.28 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,533.00 1,116.60 44.23 372.17 24.28 10-522-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 522 Plan & Protect Svcs-MPO 295,068.52 158,587.70 89,156.23 47,324.59 16.04 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 74,191.89 69,615.95 0.00 4,575.94 6.17 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 5,527.33 5,226.86 0.00 300.47 5.44 10-530-502020 Group Health Insurance 12,101.67 8,809.26 0.00 3,292.41 27.21 10-530-502030 Retirement 8,935.87 8,744.53 0.00 191.34 2.14 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 77.72 72.73 0.00 4.99 6.42 10-530-502060 Long Term Disability 191.56 179.60 0.00 11.96 6.24 10-530-502070 Employee Assistance Prgm 32.76 20.44 0.00 12.32 37.61 E05 Personnel Services 101,116.88 92,727.45 0.00 8,389.43 8.30 10-530-511010 Advertising 45.00 1,820.00 0.00 -1,775.00 -3,944.44 10-530-511020 Postage 25.00 84.45 0.00 -59.45 -237.80 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 1.16 0.00 -1.16 0.00 10-530-513010 Office Supplies 0.00 633.94 0.00 -633.94 0.00 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 2,805.37 3,069.24 0.00 -263.87 -9.41 E10 Materials & Supplies 2,875.37 5,608.79 0.00 -2,733.42 -95.06 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-520030 Dues And Publications 500.00 688.78 0.00 -188.78 -37.76 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,494.63 4,173.12 0.00 -2,678.49 -179.21 10-530-522020 Professional Services 240.00 0.00 0.00 240.00 100.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 12,000.00 0.00 0.00 12,000.00 100.00 10-530-524026 Household Hazardous Waste 31,300.00 22,892.09 0.00 8,407.91 26.86 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 18,000.00 0.00 0.00 18,000.00 100.00 10-530-526060 Refund of Grant Proceeds 78,805.90 78,457.55 0.00 348.35 0.44 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 142,340.53 106,211.54 0.00 36,128.99 25.38 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 361.00 0.00 0.00 361.00 100.00 E25 Repairs & Maintenance 361.00 0.00 0.00 361.00 100.00 10-530-550020 NRA-Residential 40,000.00 37,379.51 0.00 2,620.49 6.55 10-530-550030 NRA-Commercial Facade 19,500.00 12,000.00 0.00 7,500.00 38.46 10-530-550031 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 10-530-550032 NRA-Rental Facade 15,000.00 108.00 0.00 14,892.00 99.28 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 500.00 60.00 0.00 440.00 88.00 10-530-550039 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 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 50,000.00 42,516.34 0.00 7,483.66 14.97 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 171,000.00 112,096.51 5,500.00 53,403.49 31.23 530 Plan & Protect Svc-RedevGrant 417,693.78 316,644.29 5,500.00 95,549.49 22.88 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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 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 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 198,586.84 168,145.86 0.00 30,440.98 15.33 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 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502010 Social Security 15,013.88 11,768.08 0.00 3,245.80 21.62 10-532-502020 Group Health Insurance 37,936.86 29,694.00 0.00 8,242.86 21.73 10-532-502030 Retirement 26,048.86 22,169.08 0.00 3,879.78 14.89 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 223.99 188.10 0.00 35.89 16.02 10-532-502060 Long Term Disability 557.41 466.79 0.00 90.62 16.26 10-532-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,186.78 236,246.69 0.00 45,940.09 16.28 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 117.80 0.00 32.20 21.47 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 310.35 0.00 989.65 76.13 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 133.56 0.00 866.44 86.64 E10 Materials & Supplies 2,625.00 561.71 0.00 2,063.29 78.60 10-532-520030 Dues And Publications 900.00 902.00 0.00 -2.00 -0.22 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 96.99 0.00 903.01 90.30 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 4,996.70 4,996.70 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 199,200.00 149,400.00 49,800.00 0.00 0.00 10-532-529010 Special Events 600.00 600.00 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 206,696.70 155,995.69 49,800.00 901.01 0.44 10-532-534010 Telephone 1,287.00 773.13 0.00 513.87 39.93 E20 Utilities 1,287.00 773.13 0.00 513.87 39.93 10-532-540060 Cemetery Maintenance 39,500.00 29,974.78 5,924.00 3,601.22 9.12 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 438.00 0.00 642.00 59.44 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,081.00 1,283.22 29.48 -231.70 -21.43 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 42,991.00 32,980.00 5,953.48 4,057.52 9.44 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 532 Plan & Protect Svcs-Env Health 535,786.48 426,557.22 55,753.48 53,475.78 9.98 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 193,853.88 155,567.16 0.00 38,286.72 19.75 10-533-501050 Parttime(wo Benefits)20,000.00 13,196.64 0.00 6,803.36 34.02 10-533-501060 Seasonal Salaries 0.00 5,518.43 0.00 -5,518.43 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 16,152.14 12,848.43 0.00 3,303.71 20.45 10-533-502020 Group Health Insurance 35,121.60 25,111.46 0.00 10,010.14 28.50 10-533-502030 Retirement 25,342.19 20,260.68 0.00 5,081.51 20.05 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 198.90 155.87 0.00 43.03 21.63 10-533-502060 Long Term Disability 523.14 429.16 0.00 93.98 17.96 10-533-502070 Employee Assistance Prgm 76.44 71.60 0.00 4.84 6.33 E05 Personnel Services 293,525.67 235,416.81 0.00 58,108.86 19.80 10-533-511010 Advertising 100.00 129.44 0.00 -29.44 -29.44 10-533-511020 Postage 2,300.00 1,180.98 0.00 1,119.02 48.65 10-533-512010 Printing 300.00 509.50 0.00 -209.50 -69.83 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 196.70 0.00 803.30 80.33 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 1,209.38 0.00 140.62 10.42 E10 Materials & Supplies 5,190.00 3,226.00 0.00 1,964.00 37.84 10-533-520030 Dues And Publications 500.00 75.00 0.00 425.00 85.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,400.00 761.02 0.00 638.98 45.64 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 160.00 0.00 -160.00 0.00 10-533-522021 Abatement 10,000.00 26,437.87 0.00 -16,437.87 -164.38 10-533-522022 Demo 230,782.57 166,642.79 0.00 64,139.78 27.79 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 242,682.57 194,076.68 0.00 48,605.89 20.03 10-533-534010 Telephone 3,701.40 2,600.40 0.00 1,101.00 29.75 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 3,701.40 2,600.40 0.00 1,101.00 29.75 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 446.28 0.00 833.72 65.13 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,183.00 1,141.71 29.48 11.81 1.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,763.00 1,857.99 29.48 875.53 31.69 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 533 PPS - Prop MaintCode Enforce 547,862.64 437,177.88 29.48 110,655.28 20.20 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 301,564.20 258,442.51 0.00 43,121.69 14.30 10-534-501050 Parttime(wo Benefits)15,900.00 0.00 0.00 15,900.00 100.00 10-534-501060 Seasonal Salaries 0.00 10,378.19 0.00 -10,378.19 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 23,989.32 18,798.39 0.00 5,190.93 21.64 10-534-502020 Group Health Insurance 67,522.51 56,832.57 0.00 10,689.94 15.83 10-534-502030 Retirement 39,355.64 33,940.12 0.00 5,415.52 13.76 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 345.17 288.15 0.00 57.02 16.52 10-534-502060 Long Term Disability 845.87 716.46 0.00 129.41 15.30 10-534-502070 Employee Assistance Prgm 109.20 122.76 0.00 -13.56 -12.42 10-534-503020 Unemployment Compensation 0.00 3,200.00 0.00 -3,200.00 0.00 E05 Personnel Services 454,387.98 387,475.22 0.00 66,912.76 14.73 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 542.31 0.00 557.69 50.70 10-534-512010 Printing 100.00 180.47 0.00 -80.47 -80.47 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 583.92 0.00 316.08 35.12 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 132.86 0.00 -32.86 -32.86 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 127.98 0.00 1,672.02 92.89 E10 Materials & Supplies 4,115.00 1,567.54 0.00 2,547.46 61.91 10-534-520030 Dues And Publications 3,000.00 744.00 0.00 2,256.00 75.20 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 8,000.00 4,305.56 0.00 3,694.44 46.18 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 11,000.00 5,049.56 0.00 5,950.44 54.09 10-534-534010 Telephone 2,100.00 2,855.88 0.00 -755.88 -35.99 E20 Utilities 2,100.00 2,855.88 0.00 -755.88 -35.99 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 616.97 0.00 563.03 47.71 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,022.00 901.09 44.23 76.68 7.50 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,492.00 1,788.06 44.23 659.71 26.47 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 534 Plan & Protect Svcs-Bldg Regs 474,094.98 398,736.26 44.23 75,314.49 15.89 535 Public Works-Central Maintenan 10-535-501020 Salaries 394,101.90 333,757.45 0.00 60,344.45 15.31 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 575.59 0.00 3,424.41 85.61 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,476.32 0.00 1,023.68 22.75 10-535-501095 Overtime Straight Pay 500.00 184.87 0.00 315.13 63.03 10-535-502010 Social Security 30,421.92 24,825.92 0.00 5,596.00 18.39 10-535-502020 Group Health Insurance 85,350.94 60,531.39 0.00 24,819.55 29.08 10-535-502030 Retirement 51,911.76 44,148.91 0.00 7,762.85 14.95 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 445.54 370.80 0.00 74.74 16.78 10-535-502060 Long Term Disability 1,101.36 922.58 0.00 178.78 16.23 10-535-502070 Employee Assistance Prgm 152.88 143.20 0.00 9.68 6.33 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 576,955.66 473,406.39 0.00 103,549.27 17.95 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,500.00 552.58 0.00 947.42 63.16 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,500.00 5,020.67 0.00 1,479.33 22.76 10-535-517010 Operational Supplies 6,500.00 6,251.47 0.00 248.53 3.82 E10 Materials & Supplies 14,640.00 11,824.72 0.00 2,815.28 19.23 10-535-520030 Dues And Publications 350.00 185.00 0.00 165.00 47.14 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 184.00 0.00 1,816.00 90.80 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,850.00 869.00 0.00 1,981.00 69.51 10-535-531010 Electricity 6,560.00 5,337.20 0.00 1,222.80 18.64 10-535-533010 Natural Gas 3,000.00 2,797.97 0.00 202.03 6.73 10-535-534010 Telephone 320.00 289.99 0.00 30.01 9.38 10-535-535010 Water 1,342.00 1,008.85 0.00 333.15 24.82 E20 Utilities 11,222.00 9,434.01 0.00 1,787.99 15.93 10-535-540010 Building & Grounds Maint.10,000.00 15,976.66 0.00 -5,976.66 -59.77 10-535-541010 Veh & Equip Parts Etc 600,000.00 604,588.43 0.00 -4,588.43 -0.76 10-535-541015 Vehicle Hail Damage Repair 24,360.36 24,360.36 0.00 0.00 0.00 10-535-546010 Clothing Expense 7,700.00 8,428.40 0.00 -728.40 -9.46 10-535-547010 Equipment Maintenance 1,000.00 1,139.48 0.00 -139.48 -13.95 10-535-547020 Maintenance Agreements 16,051.00 15,465.77 0.00 585.23 3.65 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 659,211.36 669,959.10 0.00 -10,747.74 -1.63 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 535 Public Works-Central Maintenan 1,264,879.02 1,165,493.22 0.00 99,385.80 7.86 540 Public Works-Admin 10-540-501020 Salaries 239,641.61 202,888.91 0.00 36,752.70 15.34 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 18,154.57 15,497.54 0.00 2,657.03 14.64 10-540-502020 Group Health Insurance 21,189.53 16,072.39 0.00 5,117.14 24.15 10-540-502030 Retirement 31,714.41 26,963.68 0.00 4,750.73 14.98 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 272.95 229.80 0.00 43.15 15.81 10-540-502060 Long Term Disability 547.62 453.69 0.00 93.93 17.15 10-540-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 E05 Personnel Services 311,805.44 262,386.60 0.00 49,418.84 15.85 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.53 0.00 199.47 99.74 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.11 0.00 99.89 99.89 10-540-513010 Office Supplies 1,000.00 489.98 0.00 510.02 51.00 10-540-514010 Gas 100,000.00 100,628.34 0.00 -628.34 -0.63 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 -141.87 0.00 341.87 170.94 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 102,000.00 100,977.09 0.00 1,022.91 1.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-520030 Dues And Publications 800.00 738.63 0.00 61.37 7.67 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,000.00 0.00 0.00 3,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 738.63 0.00 3,261.37 81.53 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 281.08 14.74 9.18 3.01 E25 Repairs & Maintenance 305.00 281.08 14.74 9.18 3.01 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 540 Public Works-Admin 418,110.44 364,383.40 14.74 53,712.30 12.85 541 Public Works-Engineering 10-541-501020 Salaries 879,396.07 754,167.54 0.00 125,228.53 14.24 10-541-501040 Part-time (wbenefits)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 1,438.60 1,438.60 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 23.62 60.25 0.00 -36.63 -155.08 10-541-502010 Social Security 66,732.93 55,121.56 0.00 11,611.37 17.40 10-541-502020 Group Health Insurance 143,366.51 101,680.58 0.00 41,685.93 29.08 10-541-502030 Retirement 116,585.97 95,765.86 0.00 20,820.11 17.86 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 976.75 812.57 0.00 164.18 16.81 10-541-502060 Long Term Disability 2,422.05 1,958.58 0.00 463.47 19.14 10-541-502070 Employee Assistance Prgm 262.08 245.52 0.00 16.56 6.32 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,217,260.30 1,017,306.78 0.00 199,953.52 16.43 10-541-511010 Advertising 400.00 714.25 0.00 -314.25 -78.56 10-541-511020 Postage 400.00 106.04 0.00 293.96 73.49 10-541-512010 Printing 46.50 46.50 0.00 0.00 0.00 10-541-512020 Copies 15.00 0.74 0.00 14.26 95.07 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 1,235.28 0.00 414.72 25.13 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 138.50 0.00 0.00 138.50 100.00 10-541-514040 Food 520.10 547.07 0.00 -26.97 -5.19 10-541-515040 First Aid Supplies 110.51 110.51 0.00 0.00 0.00 10-541-515070 Const & Inspect Supplies 1,380.72 1,560.40 0.00 -179.68 -13.01 10-541-515080 Surveying Supplies 1,500.00 908.41 0.00 591.59 39.44 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-517010 Operational Supplies 3,538.67 3,529.68 0.00 8.99 0.25 E10 Materials & Supplies 9,700.00 8,758.88 0.00 941.12 9.70 10-541-520030 Dues And Publications 6,014.75 6,014.75 0.00 0.00 0.00 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 1,985.25 1,878.68 0.00 106.57 5.37 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 135.00 0.00 365.00 73.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,000.00 8,028.43 0.00 971.57 10.80 10-541-534010 Telephone 265.04 262.26 0.00 2.78 1.05 E20 Utilities 265.04 262.26 0.00 2.78 1.05 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,564.96 1,834.50 0.00 -269.54 -17.22 10-541-547010 Equipment Maintenance 1,000.00 1,170.00 0.00 -170.00 -17.00 10-541-547020 Maintenance Agreements 10,835.00 8,759.61 1,518.08 557.31 5.14 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,399.96 12,724.11 1,518.08 157.77 1.10 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 541 Public Works-Engineering 1,250,625.30 1,047,080.46 1,518.08 202,026.76 16.15 542 Public Works-Street 10-542-501020 Salaries 1,299,417.80 1,070,929.15 0.00 228,488.65 17.58 10-542-501024 Salaries-Stormwater 13,195.22 13,195.22 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 17,193.60 0.00 2,806.40 14.03 10-542-501070 Stand-by Plan 9,248.00 7,511.50 0.00 1,736.50 18.78 10-542-501090 Overtime 29,057.24 26,338.11 0.00 2,719.13 9.36 10-542-501095 Overtime Straight Pay 1,442.76 1,442.76 0.00 0.00 0.00 10-542-502010 Social Security 103,535.02 83,880.63 0.00 19,654.39 18.98 10-542-502020 Group Health Insurance 280,799.01 197,693.40 0.00 83,105.61 29.60 10-542-502030 Retirement 174,945.32 139,374.50 0.00 35,570.82 20.33 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,462.73 1,169.93 0.00 292.80 20.02 10-542-502060 Long Term Disability 3,575.74 2,854.70 0.00 721.04 20.16 10-542-502070 Employee Assistance Prgm 622.44 583.08 0.00 39.36 6.32 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 1,976,612.12 1,601,277.42 0.00 375,334.70 18.99 10-542-511010 Advertising 1,000.00 544.50 0.00 455.50 45.55 10-542-511020 Postage 150.00 24.05 0.00 125.95 83.97 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.36 976.36 0.00 424.00 30.28 10-542-514017 COVID-19 199.64 199.64 0.00 0.00 0.00 10-542-514020 Chemicals 300,000.00 289,641.60 0.00 10,358.40 3.45 10-542-514030 Small Tools 7,865.75 6,106.23 0.00 1,759.52 22.37 10-542-514040 Food 2,000.00 1,809.53 0.00 190.47 9.52 10-542-515010 Stormwater Material 73,647.86 1,588.71 0.00 72,059.15 97.84 10-542-515020 Street Materials 0.00 6,666.16 0.00 -6,666.16 0.00 10-542-515040 First Aid Supplies 500.00 332.07 0.00 167.93 33.59 10-542-515060 Weed Control 1,500.00 1,284.97 0.00 215.03 14.34 10-542-515070 Const & Inspect Supplies 200.00 28.23 0.00 171.77 85.89 10-542-517010 Operational Supplies 6,134.25 6,173.32 0.00 -39.07 -0.64 E10 Materials & Supplies 394,697.86 315,375.37 0.00 79,322.49 20.10 10-542-520030 Dues And Publications 1,320.00 742.00 0.00 578.00 43.79 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 8,071.24 0.00 -391.24 -5.09 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,738.75 15,620.00 0.00 -881.25 -5.98 10-542-523010 Equipment Rentlease 218.02 218.02 0.00 0.00 0.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,956.77 24,651.26 0.00 -694.49 -2.90 10-542-531010 Electricity 24,364.00 21,308.84 0.00 3,055.16 12.54 10-542-531020 Street Lights 593,000.00 513,694.97 0.00 79,305.03 13.37 10-542-533010 Natural Gas 13,480.00 13,543.16 0.00 -63.16 -0.47 10-542-534010 Telephone 1,211.67 1,454.61 0.00 -242.94 -20.05 10-542-535010 Water 7,521.56 3,465.60 0.00 4,055.96 53.92 E20 Utilities 639,577.23 553,467.18 0.00 86,110.05 13.46 10-542-540010 Building & Grounds Maint.13,477.39 16,102.36 120.00 -2,744.97 -20.37 10-542-541030 Vehicle Wash 7,000.00 6,657.94 0.00 342.06 4.89 10-542-542010 Repairs - StopStreet Lights 32,400.86 27,979.89 0.00 4,420.97 13.64 10-542-542030 Signs & Marking Paint 50,886.82 50,517.85 0.00 368.97 0.73 10-542-546010 Clothing Expense 15,000.00 11,056.30 0.00 3,943.70 26.29 10-542-547010 Equipment Maintenance 4,321.75 4,321.75 0.00 0.00 0.00 10-542-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 113.18 0.00 0.00 113.18 100.00 E25 Repairs & Maintenance 123,560.00 116,996.09 120.00 6,443.91 5.22 10-542-572010 Purchase Of Vehicles 152,000.00 152,000.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 152,000.00 152,000.00 0.00 0.00 0.00 542 Public Works-Street 3,310,403.98 2,763,767.32 120.00 546,516.66 16.51 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 5,863.77 0.00 9,136.23 60.91 10-700-590051 Trans to Parks 118,415.00 118,415.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 8,073.75 8,073.75 0.00 0.00 0.00 10-700-590053 Trans to Parking 21,530.00 21,530.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 69,972.50 69,972.50 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 91,502.50 91,502.50 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 113,316.60 113,316.60 0.00 0.00 0.00 10-700-590075 Transit Subsidy 187,072.59 187,072.59 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 624,882.94 615,746.71 0.00 9,136.23 1.46 700 Transfers & Subsidies 624,882.94 615,746.71 0.00 9,136.23 1.46 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 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 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,000.00 0.00 0.00 6,000.00 100.00 10-990-575023 Fire Station 4 Rehab 3,579.28 2,586.75 0.00 992.53 27.73 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-576023 Norris Drive Culvert 243,750.00 203,409.56 40,340.44 0.00 0.00 10-990-576025 Douglas Davis Stormwater 124,019.00 0.00 124,019.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-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 11,035.29 58.50 0.00 10,976.79 99.47 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 3,488,778.57 206,054.81 164,359.44 3,118,364.32 89.38 990 Capital Projects 3,488,778.57 206,054.81 164,359.44 3,118,364.32 89.38 995 ARPA 10-995-501020 Salaries 87,700.27 87,700.27 0.00 0.00 0.00 10-995-502010 Social Security 6,468.51 6,468.51 0.00 0.00 0.00 10-995-502020 Group Health Insurance 17,740.61 17,740.61 0.00 0.00 0.00 10-995-502030 Retirement 11,417.41 11,417.41 0.00 0.00 0.00 10-995-502050 Life Insurance 92.36 92.36 0.00 0.00 0.00 10-995-502060 Long Term Disability 228.70 228.70 0.00 0.00 0.00 E05 Personnel Services 123,647.86 123,647.86 0.00 0.00 0.00 10-995-515010 Stormwater Materials 126,352.14 145,567.63 2,703.96 -21,919.45 -17.35 E10 Materials & Supplies 126,352.14 145,567.63 2,703.96 -21,919.45 -17.35 10-995-599501 JCCVB Lost Revenue 175,000.00 0.00 0.00 175,000.00 100.00 10-995-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-995-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 775,000.00 0.00 0.00 775,000.00 100.00 10-995-576007 Stormwater Improvements 540,917.60 0.00 0.00 540,917.60 100.00 10-995-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599503 Organizational Review Study 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599505 PD Elevator Replacement 200,000.00 0.00 0.00 200,000.00 100.00 10-995-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599507 Hyde Park Burn Bldg 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599508 High Street Viaduct 1,090,000.00 0.00 0.00 1,090,000.00 100.00 10-995-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-995-599510 Demolitions 100,000.00 0.00 0.00 100,000.00 100.00 10-995-599512 Street Resurfacing 325,000.00 0.00 48,490.56 276,509.44 85.08 E75 Capital Projects 4,755,917.60 0.00 48,490.56 4,707,427.04 98.98 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 995 ARPA 5,780,917.60 269,215.49 51,194.52 5,460,507.59 94.46 Expense Expense 50,396,138.01 30,468,370.58 1,297,037.74 18,630,729.69 36.97 GL - Trial Balance by Acct Type and Full Acct Number (09/14/2022 - 11:19 AM)Page 38