Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2023-03 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 3/20/2023 8:22:30 AM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 21,600.00 0.00 44,325.00 67.24 10-110-501015 Salary-Prosecuting Attorney 34,999.92 11,666.64 0.00 23,333.28 66.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 2,079.43 0.00 14,518.97 87.47 10-110-502010 Social Security 8,990.53 2,568.09 0.00 6,422.44 71.44 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 37,985.75 0.00 88,599.69 69.99 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 15.39 0.00 84.61 84.61 10-110-512010 Printing 400.00 120.00 0.00 280.00 70.00 10-110-512020 Copies 96.00 0.00 0.00 96.00 100.00 10-110-513010 Office Supplies 1,435.00 439.99 0.00 995.01 69.34 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,031.00 575.38 0.00 1,455.62 71.67 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 726.62 0.00 773.38 51.56 10-110-520030 Dues And Publications 4,165.00 6,501.92 0.00 -2,336.92 -56.11 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,189.84 570.00 0.00 619.84 52.09 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 6,854.84 7,798.54 0.00 -943.70 -13.77 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 124.00 61.89 61.90 0.21 0.17 E25 Repairs & Maintenance 124.00 61.89 61.90 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,529.88 0.00 -1,529.88 0.00 E70 Capital Purchases 0.00 1,529.88 0.00 -1,529.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 135,595.28 47,951.44 61.90 87,581.94 64.5907 Grand Total -135,595.28 -47,951.44 -61.90 -87,581.94 0.6459 110 Mayor & Council 135,595.28 47,951.44 61.90 87,581.94 64.59 120 City Clerk 10-120-501020 Salaries 56,948.36 19,493.71 0.00 37,454.65 65.77 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,356.55 1,376.41 0.00 2,980.14 68.41 10-120-502020 Group Health Insurance 13,245.50 4,171.20 0.00 9,074.30 68.51 10-120-502030 Retirement 7,289.39 2,495.20 0.00 4,794.19 65.77 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 22.22 0.00 47.55 68.15 10-120-502060 Long Term Disability 174.26 58.69 0.00 115.57 66.32 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 82,155.66 27,677.64 0.00 54,478.02 66.31 10-120-511020 Postage 200.00 99.40 0.00 100.60 50.30 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 146.17 0.00 153.83 51.28 10-120-513010 Office Supplies 200.00 64.59 0.00 135.41 67.71 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 310.16 0.00 389.84 55.69 10-120-520030 Dues And Publications 75.00 15.00 0.00 60.00 80.00 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 164.10 0.00 235.90 58.98 10-120-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-120-529030 Election Expense 18,579.79 155.02 0.00 18,424.77 99.17 E15 Contractual Services 19,254.79 334.12 0.00 18,920.67 98.26 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,675.00 1,364.89 61.90 9,248.21 86.63 E25 Repairs & Maintenance 10,675.00 1,364.89 61.90 9,248.21 86.63 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 112,785.45 29,686.81 61.90 83,036.74 73.6236 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -29,686.81 -61.90 -83,036.74 0.7362 120 City Clerk 112,785.45 29,686.81 61.90 83,036.74 73.62 140 City Administrator 10-140-501020 Salaries 213,221.32 72,914.75 0.00 140,306.57 65.80 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,311.43 3,997.10 0.00 12,314.33 75.50 10-140-502020 Group Health Insurance 21,732.71 6,839.90 0.00 14,892.81 68.53 10-140-502030 Retirement 27,292.33 9,333.08 0.00 17,959.25 65.80 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 47.97 0.00 65.86 57.86 10-140-502060 Long Term Disability 374.04 167.71 0.00 206.33 55.16 10-140-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 279,290.56 93,522.19 0.00 185,768.37 66.51 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 21.33 0.00 128.67 85.78 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 11.31 0.00 138.69 92.46 10-140-513010 Office Supplies 525.00 266.72 0.00 258.28 49.20 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 22.20 0.00 656.54 96.73 E10 Materials & Supplies 1,603.74 321.56 0.00 1,282.18 79.95 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 300.00 0.00 400.00 57.14 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,400.00 1,602.09 0.00 797.91 33.25 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 63.38 61.90 174.72 58.24 E25 Repairs & Maintenance 300.00 63.38 61.90 174.72 58.24 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 283,594.30 95,509.22 61.90 188,023.18 66.3001 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -95,509.22 -61.90 -188,023.18 0.663 140 City Administrator 283,594.30 95,509.22 61.90 188,023.18 66.30 143 CDBG-CV Compass Health 10-143-501020 Salaries 14,000.00 1,455.43 0.00 12,544.57 89.60 10-143-502010 Social Security 0.00 99.42 0.00 -99.42 0.00 10-143-502020 Group Health Insurance 0.00 379.56 0.00 -379.56 0.00 10-143-502030 Retirement 0.00 186.29 0.00 -186.29 0.00 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 0.00 1.70 0.00 -1.70 0.00 10-143-502060 Long Term Disability 0.00 4.58 0.00 -4.58 0.00 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 2,126.98 0.00 11,873.02 84.81 10-143-520072 Subrecipient Reimbursements 100,000.00 0.00 0.00 100,000.00 100.00 E15 Contractual Services 100,000.00 0.00 0.00 100,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,000.00 2,126.98 0.00 111,873.02 98.1342 Grand Total -114,000.00 -2,126.98 0.00 -111,873.02 0.9813 143 CDBG-CV Compass Health 114,000.00 2,126.98 0.00 111,873.02 98.13 144 CDBG-DR 10-144-501020 Salaries 282,372.00 6,106.76 0.00 276,265.24 97.84 10-144-502010 Social Security 0.00 444.80 0.00 -444.80 0.00 10-144-502020 Group Health Insurance 0.00 1,213.62 0.00 -1,213.62 0.00 10-144-502030 Retirement 0.00 781.66 0.00 -781.66 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 7.00 0.00 -7.00 0.00 10-144-502060 Long Term Disability 0.00 18.82 0.00 -18.82 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 8,572.66 0.00 273,799.34 96.96 10-144-528041 Acquisition for Demo 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528042 New Construction SF 521,928.00 0.00 0.00 521,928.00 100.00 10-144-528043 Multi-Family 4,800,000.00 0.00 0.00 4,800,000.00 100.00 10-144-528044 Down Payment Assistance 50,000.00 0.00 0.00 50,000.00 100.00 10-144-528046 Homeowner Rehab 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528047 Infrastructure 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-144-528048 Public Service 5,000.00 0.00 0.00 5,000.00 100.00 10-144-528049 Planning 250,000.00 0.00 0.00 250,000.00 100.00 E15 Contractual Services 7,026,928.00 0.00 0.00 7,026,928.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 7,309,300.00 8,572.66 0.00 7,300,727.34 99.8827 Grand Total -7,309,300.00 -8,572.66 0.00 -7,300,727.34 0.9988 144 CDBG-DR 7,309,300.00 8,572.66 0.00 7,300,727.34 99.88 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 40,200.63 3,671.07 0.00 36,529.56 90.87 10-145-502010 Social Security 840.81 251.35 0.00 589.46 70.11 10-145-502020 Group Health Insurance 2,491.43 919.44 0.00 1,571.99 63.10 10-145-502030 Retirement 1,406.85 469.90 0.00 936.95 66.60 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 4.05 0.00 9.53 70.18 10-145-502060 Long Term Disability 33.34 10.60 0.00 22.74 68.21 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 5,334.75 0.00 39,665.25 88.15 10-145-520072 Subrecipient Reimbursements 1,955,000.00 0.00 0.00 1,955,000.00 100.00 E15 Contractual Services 1,955,000.00 0.00 0.00 1,955,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,000,000.00 5,334.75 0.00 1,994,665.25 99.7333 Grand Total -2,000,000.00 -5,334.75 0.00 -1,994,665.25 0.9973 145 CDBG-CV Cole Co EMS Station 2,000,000.00 5,334.75 0.00 1,994,665.25 99.73 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 9,710.28 8,434.86 0.00 1,275.42 13.13 10-146-502010 Social Security 742.84 569.04 0.00 173.80 23.40 10-146-502020 Group Health Insurance 2,201.13 2,247.86 0.00 -46.73 -2.12 10-146-502030 Retirement 1,242.92 1,079.65 0.00 163.27 13.14 10-146-502040 Workers Compensation 7.37 7.37 0.00 0.00 0.00 10-146-502050 Life Insurance 12.00 9.95 0.00 2.05 17.08 10-146-502060 Long Term Disability 29.46 26.50 0.00 2.96 10.05 10-146-502070 Employee Assistance Prgm 4.44 0.00 0.00 4.44 100.00 E05 Personnel Services 13,950.44 12,375.23 0.00 1,575.21 11.29 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 355.76 0.00 0.00 355.76 100.00 E15 Contractual Services 355.76 0.00 0.00 355.76 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 688,886.20 12,375.23 0.00 676,510.97 98.2036 Grand Total -688,886.20 -12,375.23 0.00 -676,510.97 0.982 146 HPF-P Bruhn Revitalization 688,886.20 12,375.23 0.00 676,510.97 98.20 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 2,223.56 0.00 26,247.82 92.19 10-147-502010 Social Security 576.14 152.30 0.00 423.84 73.57 10-147-502020 Group Health Insurance 1,707.17 511.74 0.00 1,195.43 70.02 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-502030 Retirement 964.00 284.63 0.00 679.37 70.47 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 2.44 0.00 6.86 73.76 10-147-502060 Long Term Disability 22.85 6.32 0.00 16.53 72.34 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 3,186.71 0.00 28,573.29 89.97 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 3,186.71 0.00 572,573.29 99.4465 Grand Total -575,760.00 -3,186.71 0.00 -572,573.29 0.9945 147 CDBG-CV Transform Housing 575,760.00 3,186.71 0.00 572,573.29 99.45 148 CDBG-CV 10-148-501020 Salaries 2,064.39 0.00 0.00 2,064.39 100.00 10-148-502010 Social Security 157.93 0.00 0.00 157.93 100.00 10-148-502020 Group Health Insurance 467.96 0.00 0.00 467.96 100.00 10-148-502030 Retirement 264.24 0.00 0.00 264.24 100.00 10-148-502040 Workers Compensation 1.57 0.00 0.00 1.57 100.00 10-148-502050 Life Insurance 2.55 0.00 0.00 2.55 100.00 10-148-502060 Long Term Disability 6.26 0.00 0.00 6.26 100.00 10-148-502070 Employee Assistance Prgm 0.94 0.00 0.00 0.94 100.00 E05 Personnel Services 2,965.84 0.00 0.00 2,965.84 100.00 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-148-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-148-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 0.00 0.00 1,362.22 -1,362.22 0.00 10-148-528025 CARES-Childcare Services 19,944.00 0.00 0.00 19,944.00 100.00 10-148-528035 CARES-ED For-Profit Business 59,962.32 29,351.32 0.00 30,611.00 51.05 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,906.32 29,351.32 1,362.22 49,192.78 61.56 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 82,872.16 29,351.32 1,362.22 52,158.62 62.9387 Grand Total -82,872.16 -29,351.32 -1,362.22 -52,158.62 0.6294 148 CDBG-CV 82,872.16 29,351.32 1,362.22 52,158.62 62.94 149 Entitlement Grant 10-149-501020 Salaries 47,175.14 10,071.58 0.00 37,103.56 78.65 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 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502010 Social Security 3,608.91 707.21 0.00 2,901.70 80.40 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 10,693.67 2,311.95 0.00 8,381.72 78.38 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 6,038.44 1,289.15 0.00 4,749.29 78.65 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 35.81 35.81 0.00 0.00 0.00 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 12.25 0.00 46.03 78.98 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 31.91 0.00 111.21 77.70 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 15.34 0.00 6.22 28.85 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 14,475.20 0.00 53,299.73 78.64 10-149-511010 Advertising 1,400.00 339.75 0.00 1,060.25 75.73 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 7.80 0.00 62.20 88.86 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 250.00 0.00 0.00 250.00 100.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,820.00 347.55 0.00 1,472.45 80.90 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 40,000.00 81.00 0.00 39,919.00 99.80 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 10,222.00 0.00 129,778.00 92.70 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 107,000.00 313,000.00 0.00 -206,000.00 -192.52 10-149-528035 CARES-ED For-Profit Business 610,442.02 0.00 0.00 610,442.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 27.00 0.00 39,973.00 99.93 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 20,000.00 27.00 0.00 19,973.00 99.87 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 958,467.02 323,357.00 0.00 635,110.02 66.26 10-149-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 338,179.75 0.00 689,882.20 67.1051 Grand Total -1,028,061.95 -338,179.75 0.00 -689,882.20 0.6711 149 Entitlement Grant 1,028,061.95 338,179.75 0.00 689,882.20 67.11 150 City Attorney 10-150-501020 Salaries 233,777.84 79,143.08 0.00 154,634.76 66.15 10-150-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,884.00 5,842.33 0.00 12,041.67 67.33 10-150-502020 Group Health Insurance 35,360.71 10,854.60 0.00 24,506.11 69.30 10-150-502030 Retirement 29,923.56 10,130.33 0.00 19,793.23 66.15 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 90.66 0.00 195.76 68.35 10-150-502060 Long Term Disability 607.87 226.85 0.00 381.02 62.68 10-150-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 318,136.71 106,549.32 0.00 211,587.39 66.51 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 76.13 0.00 523.87 87.31 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 6.87 0.00 -6.87 0.00 10-150-513010 Office Supplies 1,275.00 37.16 0.00 1,237.84 97.09 10-150-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,875.00 120.16 0.00 1,754.84 93.59 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 8,500.00 1,001.90 0.00 7,498.10 88.21 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,100.00 2,411.80 0.00 2,688.20 52.71 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 8,500.00 29.00 0.00 8,471.00 99.66 10-150-525030 Litigation Expenses 500.00 150.00 0.00 350.00 70.00 10-150-525031 Special Litigation Expenses 0.00 16,905.47 0.00 -16,905.47 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 22,600.00 20,498.17 0.00 2,101.83 9.30 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 371.00 61.90 61.90 247.20 66.63 E25 Repairs & Maintenance 371.00 61.90 61.90 247.20 66.63 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 342,982.71 127,229.55 61.90 215,691.26 62.8869 Grand Total -342,982.71 -127,229.55 -61.90 -215,691.26 0.6289 150 City Attorney 342,982.71 127,229.55 61.90 215,691.26 62.89 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 11,666.64 0.00 23,333.28 66.67 10-160-501020 Salaries 124,730.18 42,653.22 0.00 82,076.96 65.80 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 1,946.37 0.00 5,053.63 72.19 10-160-501090 Overtime 1,000.00 106.48 0.00 893.52 89.35 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,831.35 4,230.72 0.00 8,600.63 67.03 10-160-502020 Group Health Insurance 25,616.32 9,655.97 0.00 15,960.35 62.31 10-160-502030 Retirement 16,093.46 5,473.27 0.00 10,620.19 65.99 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 48.45 0.00 104.55 68.33 10-160-502060 Long Term Disability 381.67 127.82 0.00 253.85 66.51 10-160-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 223,069.59 76,137.79 0.00 146,931.80 65.87 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 531.99 0.00 1,468.01 73.40 10-160-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 2,500.00 194.47 0.00 2,305.53 92.22 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 726.46 0.00 4,173.54 85.17 10-160-520025 Security 12,500.00 3,718.25 0.00 8,781.75 70.25 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 180.00 0.00 2,320.00 92.80 10-160-522020 Professional Services 4,500.00 0.00 0.00 4,500.00 100.00 10-160-525005 Appointed Counsel 3,000.00 382.50 0.00 2,617.50 87.25 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 22,790.00 4,280.75 0.00 18,509.25 81.22 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 920.00 0.00 5,375.00 85.39 E25 Repairs & Maintenance 6,295.00 920.00 0.00 5,375.00 85.39 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 257,054.59 82,065.00 0.00 174,989.59 68.0749 Grand Total -257,054.59 -82,065.00 0.00 -174,989.59 0.6807 160 Municipal Court 257,054.59 82,065.00 0.00 174,989.59 68.07 170 Human Resources 10-170-501020 Salaries 229,300.24 78,482.90 0.00 150,817.34 65.77 10-170-501050 Parttime(wo Benefits)13,000.00 6,220.35 0.00 6,779.65 52.15 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.82 0.00 -46.82 -46.82 10-170-501095 Overtime Straight Pay 0.00 30.59 0.00 -30.59 0.00 10-170-502010 Social Security 18,543.62 6,380.46 0.00 12,163.16 65.59 10-170-502020 Group Health Insurance 25,708.58 8,021.88 0.00 17,686.70 68.80 10-170-502030 Retirement 29,363.23 10,068.45 0.00 19,294.78 65.71 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 89.08 0.00 191.22 68.22 10-170-502060 Long Term Disability 589.14 223.92 0.00 365.22 61.99 10-170-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 317,276.32 110,020.82 0.00 207,255.50 65.32 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 113.25 0.00 186.75 62.25 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 200.62 0.00 299.38 59.88 10-170-513010 Office Supplies 600.00 29.12 0.00 570.88 95.15 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 680.00 65.44 0.00 614.56 90.38 E10 Materials & Supplies 2,930.00 408.43 0.00 2,521.57 86.06 10-170-520030 Dues And Publications 700.00 240.00 0.00 460.00 65.71 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 589.58 0.00 2,410.42 80.35 10-170-520070 Training And Education 4,437.00 43.44 0.00 4,393.56 99.02 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 0.00 0.00 500.00 100.00 10-170-522020 Professional Services 11,600.00 54.30 9,500.00 2,045.70 17.64 10-170-529010 Special Events 800.00 9.58 0.00 790.42 98.80 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 936.90 9,500.00 10,600.10 50.39 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 52,738.61 20,307.55 61.90 32,369.16 61.38 E25 Repairs & Maintenance 52,738.61 20,307.55 61.90 32,369.16 61.38 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 393,981.93 131,673.70 9,561.90 252,746.33 64.1518 Grand Total -393,981.93 -131,673.70 -9,561.90 -252,746.33 0.6415 170 Human Resources 393,981.93 131,673.70 9,561.90 252,746.33 64.15 180 Finance Department 10-180-501020 Salaries 570,708.35 160,228.07 0.00 410,480.28 71.92 10-180-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 43,659.19 12,023.89 0.00 31,635.30 72.46 10-180-502020 Group Health Insurance 96,970.17 24,047.37 0.00 72,922.80 75.20 10-180-502030 Retirement 73,050.67 20,459.56 0.00 52,591.11 71.99 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 175.92 0.00 527.88 75.00 10-180-502060 Long Term Disability 1,743.45 460.92 0.00 1,282.53 73.56 10-180-502070 Employee Assistance Prgm 234.78 87.54 0.00 147.24 62.71 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 787,569.24 217,982.07 0.00 569,587.17 72.32 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 10,000.00 3,713.01 0.00 6,286.99 62.87 10-180-511021 Mail Machine Cost 3,000.00 1,334.53 0.00 1,665.47 55.52 10-180-512010 Printing 3,000.00 834.80 0.00 2,165.20 72.17 10-180-512020 Copies 1,000.00 13.27 0.00 986.73 98.67 10-180-512021 Copy Machine Cost 190.00 -380.19 0.00 570.19 300.10 10-180-513010 Office Supplies 1,250.00 149.45 0.00 1,100.55 88.04 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 0.00 0.00 3,655.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 23,095.00 5,664.87 0.00 17,430.13 75.47 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 1,955.00 40.00 0.00 1,915.00 97.95 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 555.00 0.00 4,895.00 89.82 10-180-520080 Tuition Reimbursement 4,704.00 2,808.00 0.00 1,896.00 40.31 10-180-522010 Audit 60,581.64 6,364.12 0.00 54,217.52 89.49 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 0.00 0.00 150.00 100.00 E15 Contractual Services 72,840.64 9,767.12 0.00 63,073.52 86.59 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 14,120.00 12,500.00 0.00 1,620.00 11.47 E25 Repairs & Maintenance 14,120.00 12,500.00 0.00 1,620.00 11.47 10-180-572020 Purchase Of Equipment 4,210.45 2,923.35 0.00 1,287.10 30.57 E70 Capital Purchases 4,210.45 2,923.35 0.00 1,287.10 30.57 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 901,835.33 248,837.41 0.00 652,997.92 72.4077 Grand Total -901,835.33 -248,837.41 0.00 -652,997.92 0.7241 180 Finance Department 901,835.33 248,837.41 0.00 652,997.92 72.41 185 Non-Departmental 10-185-501020 Salaries 358,011.26 0.00 0.00 358,011.26 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 34,558.92 0.00 2,408.51 6.52 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 4,200.00 -13.69 0.00 4,213.69 100.33 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 399,178.69 34,545.23 0.00 364,633.46 91.35 10-185-514010 Gas 20,000.00 6,863.98 0.00 13,136.02 65.68 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 10-185-550034 National Opioid Settlement 44,119.17 0.00 0.00 44,119.17 100.00 E10 Materials & Supplies 64,119.17 6,863.98 0.00 57,255.19 89.29 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-520030 Dues and Publications 0.00 54.00 0.00 -54.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 481,601.50 360,501.88 0.00 121,099.62 25.15 10-185-521020 Insurance Deductible 25,000.00 36,010.36 0.00 -11,010.36 -44.04 10-185-521030 Self Ins Prop & Casualty 40,000.00 0.00 0.00 40,000.00 100.00 10-185-521060 Drugalcohol screening 3,564.00 1,586.00 0.00 1,978.00 55.50 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 61,800.00 24,996.00 37,392.00 -588.00 -0.95 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 92,500.00 0.00 92,500.00 50.00 10-185-529010 Special Events 5,000.00 1,256.20 0.00 3,743.80 74.88 E15 Contractual Services 848,965.50 516,904.44 37,392.00 294,669.06 34.71 10-185-531010 Electricity 32,000.00 8,185.87 0.00 23,814.13 74.42 10-185-533010 Natural Gas 6,200.00 3,789.08 0.00 2,410.92 38.89 10-185-535010 Water 7,250.00 2,419.90 0.00 4,830.10 66.62 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 14,394.85 0.00 31,055.15 68.33 10-185-540010 Building & Grounds Maint.40,000.00 24,640.84 0.00 15,359.16 38.40 10-185-540015 Amtrak Station 4,000.00 906.94 0.00 3,093.06 77.33 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 916.00 0.00 1,144.00 55.53 E25 Repairs & Maintenance 71,060.00 51,463.78 0.00 19,596.22 27.58 10-185-550010 Miscellaneous 2,800.00 2,199.52 0.00 600.48 21.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 451,560.76 165,834.35 207,401.00 78,325.41 17.35 E30 Other Operating Expenses 464,360.76 178,033.87 207,401.00 78,925.89 17.00 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 0.00 102,807.43 0.00 -102,807.43 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 102,807.43 0.00 -102,807.43 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,893,134.12 905,013.58 244,793.00 743,327.54 39.2644 Grand Total -1,893,134.12 -905,013.58 -244,793.00 -743,327.54 0.3926 185 Non-Departmental 1,893,134.12 905,013.58 244,793.00 743,327.54 39.26 190 Information Technology Svcs 10-190-501020 Salaries 606,371.81 199,915.09 0.00 406,456.72 67.03 10-190-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 500.00 0.00 0.00 500.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 46,425.69 14,842.10 0.00 31,583.59 68.03 10-190-502020 Group Health Insurance 96,814.24 25,293.46 0.00 71,520.78 73.87 10-190-502030 Retirement 77,679.59 23,229.41 0.00 54,450.18 70.10 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 214.99 0.00 529.20 71.11 10-190-502060 Long Term Disability 1,815.32 577.80 0.00 1,237.52 68.17 10-190-502070 Employee Assistance Prgm 207.48 97.18 0.00 110.30 53.16 E05 Personnel Services 831,916.53 265,528.24 0.00 566,388.29 68.08 10-190-511010 Advertising 100.00 54.00 0.00 46.00 46.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 0.74 0.00 9.26 92.60 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 216.11 0.00 283.89 56.78 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 2,000.00 1,873.06 0.00 126.94 6.35 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 2,660.00 2,143.91 0.00 516.09 19.40 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 0.00 0.00 150.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 0.00 0.00 8,500.00 100.00 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 9,000.00 6,041.99 0.00 2,958.01 32.87 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 9,510.72 0.00 13,489.28 58.65 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 45,050.00 19,867.71 0.00 25,182.29 55.90 10-190-534010 Telephone 96,000.00 29,175.64 0.00 66,824.36 69.61 E20 Utilities 96,000.00 29,175.64 0.00 66,824.36 69.61 10-190-545010 Software License\maint 182,000.00 154,292.09 0.00 27,707.91 15.22 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 9,812.00 0.00 12,188.00 55.40 10-190-547025 Coun Chamber MediaEquip Repr 0.00 114.99 0.00 -114.99 0.00 E25 Repairs & Maintenance 204,000.00 164,219.08 0.00 39,780.92 19.50 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,179,626.53 480,934.58 0.00 698,691.95 59.2299 Grand Total -1,179,626.53 -480,934.58 0.00 -698,691.95 0.5923 190 Information Technology Svcs 1,179,626.53 480,934.58 0.00 698,691.95 59.23 300 Police Department 10-300-501020 Salaries 5,457,482.75 1,684,496.96 0.00 3,772,985.79 69.13 10-300-501030 Holiday Pay 169,092.64 66,292.53 0.00 102,800.11 60.80 10-300-501040 Part-time (w\benefits)40,192.30 0.00 0.00 40,192.30 100.00 10-300-501050 Parttime(wo Benefits)45,858.01 10,517.98 0.00 35,340.03 77.06 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 3,577.30 0.00 1,422.70 28.45 10-300-501090 Overtime 285,142.77 119,942.09 0.00 165,200.68 57.94 10-300-501095 Overtime Straight Pay 13,275.00 7,087.44 0.00 6,187.56 46.61 10-300-502010 Social Security 444,750.67 137,881.33 0.00 306,869.34 69.00 10-300-502020 Group Health Insurance 960,547.52 273,481.23 0.00 687,066.29 71.53 10-300-502030 Retirement 1,009,334.34 320,241.29 0.00 689,093.05 68.27 10-300-502040 Workers Compensation 75,085.94 75,085.94 0.00 0.00 0.00 10-300-502050 Life Insurance 6,542.28 1,827.56 0.00 4,714.72 72.07 10-300-502060 Long Term Disability 15,894.91 4,809.22 0.00 11,085.69 69.74 10-300-502070 Employee Assistance Prgm 1,960.14 925.80 0.00 1,034.34 52.77 10-300-503010 Awards Program 2,500.00 0.00 0.00 2,500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,532,659.27 2,706,166.67 0.00 5,826,492.60 68.28 10-300-511010 Advertising 5,665.00 3,762.25 0.00 1,902.75 33.59 10-300-511020 Postage 1,395.00 539.65 0.00 855.35 61.32 10-300-512010 Printing 5,952.00 2,449.40 0.00 3,502.60 58.85 10-300-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 8,374.78 0.00 7,295.72 46.56 10-300-514010 Gas 188,862.00 60,691.50 0.00 128,170.50 67.86 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 613.90 0.00 37.10 5.70 10-300-515040 First Aid Supplies 1,378.00 732.94 0.00 645.06 46.81 10-300-516010 Ammunition & Firearms Supplies 63,136.25 35,359.32 25,421.00 2,355.93 3.73 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)0.00 255.00 0.00 -255.00 0.00 10-300-516050 Community Projects 11,100.00 11,520.00 0.00 -420.00 -3.78 10-300-517010 Operational Supplies 46,278.00 17,609.28 2,425.00 26,243.72 56.71 E10 Materials & Supplies 344,272.75 141,908.09 27,846.00 174,518.66 50.69 10-300-520030 Dues And Publications 5,400.00 2,439.40 0.00 2,960.60 54.83 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 76,000.00 30,485.76 0.00 45,514.24 59.89 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 205.74 0.00 1,081.26 84.01 10-300-521040 Medical Claimsservices 6,510.00 2,780.00 0.00 3,730.00 57.30 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 15,374.50 0.00 625.50 3.91 10-300-522026 Drug Forfeiture - Justice 29,750.00 0.00 9,000.00 20,750.00 69.75 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 12,086.00 0.00 -12,086.00 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 0.00 0.00 2,046.00 100.00 E15 Contractual Services 148,618.00 63,478.40 9,000.00 76,139.60 51.23 10-300-531010 Electricity 44,640.00 16,182.38 0.00 28,457.62 63.75 10-300-533010 Natural Gas 1,116.00 405.00 0.00 711.00 63.71 10-300-534010 Telephone 24,101.00 4,766.30 0.00 19,334.70 80.22 10-300-535010 Water 3,348.00 1,651.88 0.00 1,696.12 50.66 E20 Utilities 73,205.00 23,005.56 0.00 50,199.44 68.57 10-300-540010 Building & Grounds Maint.37,200.00 43,700.03 0.00 -6,500.03 -17.47 10-300-541030 Vehicle Wash 9,752.00 6,164.00 0.00 3,588.00 36.79 10-300-544010 K-9 Operations 16,740.00 8,335.11 880.35 7,524.54 44.95 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 27,950.00 2,293.00 0.00 25,657.00 91.80 10-300-545010 Software License\maint 82,414.00 64,406.11 0.00 18,007.89 21.85 10-300-546010 Clothing Expense 48,920.00 6,017.57 1,725.00 41,177.43 84.17 10-300-546020 Uniform Cleaning 23,715.00 11,205.43 0.00 12,509.57 52.75 10-300-547010 Equipment Maintenance 10,000.00 1,357.82 0.00 8,642.18 86.42 10-300-547020 Maintenance Agreements 56,248.00 25,692.32 4,697.40 25,858.28 45.97 10-300-547030 Radio Maintenance 8,025.00 96.88 0.00 7,928.12 98.79 E25 Repairs & Maintenance 320,964.00 169,268.27 7,302.75 144,392.98 44.99 10-300-572010 Purchase Of Vehicles 46,849.80 5,093.80 0.00 41,756.00 89.13 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 0.00 37,162.93 100.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 46,750.00 46,750.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 13,538.67 0.00 0.00 13,538.67 100.00 10-300-572090 Body Worn Cameras 180,000.00 0.00 0.00 180,000.00 100.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 324,301.40 51,843.80 0.00 272,457.60 84.01 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,744,020.42 3,155,670.79 44,148.75 6,544,200.88 67.1612 Grand Total -9,744,020.42 -3,155,670.79 -44,148.75 -6,544,200.88 0.6716 300 Police Department 9,744,020.42 3,155,670.79 44,148.75 6,544,200.88 67.16 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-501020 Salaries 489,893.97 135,979.62 0.00 353,914.35 72.24 10-310-501030 Holiday Pay 20,720.19 0.00 0.00 20,720.19 100.00 10-310-501090 Overtime 45,106.00 30,226.55 0.00 14,879.45 32.99 10-310-501095 Overtime Straight Pay 1,311.00 1,411.98 0.00 -100.98 -7.70 10-310-502010 Social Security 42,612.88 12,110.25 0.00 30,502.63 71.58 10-310-502020 Group Health Insurance 89,715.43 24,420.68 0.00 65,294.75 72.78 10-310-502030 Retirement 100,265.61 30,171.28 0.00 70,094.33 69.91 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 143.76 0.00 459.67 76.18 10-310-502060 Long Term Disability 1,498.63 379.87 0.00 1,118.76 74.65 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 798,454.72 241,478.69 0.00 556,976.03 69.76 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 0.00 0.00 15,345.00 100.00 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 0.00 0.00 22,340.00 100.00 10-310-520070 Training And Education 4,650.00 0.00 0.00 4,650.00 100.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 0.00 0.00 4,650.00 100.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 0.00 959.20 5,014.80 83.94 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 690.00 0.00 -330.00 -91.67 E25 Repairs & Maintenance 6,334.00 690.00 959.20 4,684.80 73.96 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 831,778.72 242,168.69 959.20 588,650.83 70.7701 Grand Total -831,778.72 -242,168.69 -959.20 -588,650.83 0.7077 310 School Resource Officer 831,778.72 242,168.69 959.20 588,650.83 70.77 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 43,664.02 0.00 83,942.94 65.78 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 11,964.34 0.00 17,453.88 59.33 10-320-501095 Overtime Straight Pay 0.00 441.91 0.00 -441.91 0.00 10-320-502010 Social Security 11,037.18 4,099.84 0.00 6,937.34 62.85 10-320-502020 Group Health Insurance 20,462.81 6,398.20 0.00 14,064.61 68.73 10-320-502030 Retirement 25,969.83 10,092.64 0.00 15,877.19 61.14 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 45.99 0.00 109.46 70.41 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502060 Long Term Disability 384.75 120.85 0.00 263.90 68.59 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 222,402.83 78,852.64 0.00 143,550.19 64.55 10-320-514010 Gas 7,500.00 2,902.92 0.00 4,597.08 61.29 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 6,035.00 0.00 9,071.00 60.05 10-320-517010 Operational Supplies 3,994.28 600.00 0.00 3,394.28 84.98 E10 Materials & Supplies 26,600.28 9,537.92 0.00 17,062.36 64.14 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 17,500.00 4,500.00 0.00 13,000.00 74.29 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 4,500.00 0.00 13,000.00 74.29 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 266,503.11 92,890.56 0.00 173,612.55 65.1447 Grand Total -266,503.11 -92,890.56 0.00 -173,612.55 0.6514 320 M.U.S.T.A.N.G.266,503.11 92,890.56 0.00 173,612.55 65.14 330 Animal Control 10-330-501020 Salaries 370,091.13 105,418.74 0.00 264,672.39 71.52 10-330-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 2,993.98 0.00 5,606.02 65.19 10-330-501090 Overtime 2,000.00 6,666.47 0.00 -4,666.47 -233.32 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 7,934.73 0.00 21,188.14 72.75 10-330-502020 Group Health Insurance 93,298.71 25,530.18 0.00 67,768.53 72.64 10-330-502030 Retirement 48,728.46 14,730.11 0.00 33,998.35 69.77 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 456.55 115.68 0.00 340.87 74.66 10-330-502060 Long Term Disability 1,117.06 311.87 0.00 805.19 72.08 10-330-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 558,270.58 168,464.68 0.00 389,805.90 69.82 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 43.94 0.00 108.06 71.09 10-330-512010 Printing 1,860.00 638.61 0.00 1,221.39 65.67 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 193.98 0.00 1,387.02 87.73 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 188.44 0.00 34.56 15.50 10-330-515040 First Aid Supplies 295.00 0.00 0.00 295.00 100.00 10-330-517010 Operational Supplies 11,000.00 6,642.21 0.00 4,357.79 39.62 E10 Materials & Supplies 16,016.00 7,707.18 0.00 8,308.82 51.88 10-330-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 0.00 0.00 2,611.00 100.00 10-330-521040 Medical Claimsservices 690.00 0.00 0.00 690.00 100.00 10-330-522020 Professional Services 4,830.00 917.20 0.00 3,912.80 81.01 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 1,111.89 0.00 4,096.11 78.65 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 26,800.00 4,580.00 0.00 22,220.00 82.91 E15 Contractual Services 41,039.00 6,609.09 0.00 34,429.91 83.90 10-330-531010 Electricity 22,789.00 8,099.19 0.00 14,689.81 64.46 10-330-533010 Natural Gas 21,000.00 7,857.99 0.00 13,142.01 62.58 10-330-534010 Telephone 810.00 337.06 0.00 472.94 58.39 10-330-535010 Water 3,800.00 1,027.05 0.00 2,772.95 72.97 E20 Utilities 48,399.00 17,321.29 0.00 31,077.71 64.21 10-330-540010 Building & Grounds Maint.15,000.00 9,742.32 0.00 5,257.68 35.05 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 14,782.88 0.00 34,507.12 70.01 10-330-544050 Animal Food 6,603.00 1,463.51 0.00 5,139.49 77.84 10-330-545010 Software Licensemaint 3,191.00 2,495.04 0.00 695.96 21.81 10-330-546010 Clothing Expense 2,325.00 986.80 0.00 1,338.20 57.56 10-330-546020 Uniform Cleaning 0.00 182.16 0.00 -182.16 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 58.00 0.00 1,692.00 96.69 E25 Repairs & Maintenance 79,374.00 30,250.71 0.00 49,123.29 61.89 10-330-572010 Purchase of Vehicles 26,800.00 1,600.00 0.00 25,200.00 94.03 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 26,800.00 1,600.00 0.00 25,200.00 94.03 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 769,898.58 231,952.95 0.00 537,945.63 69.8723 Grand Total -769,898.58 -231,952.95 0.00 -537,945.63 0.6987 330 Animal Control 769,898.58 231,952.95 0.00 537,945.63 69.87 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 280,955.66 0.00 800,196.85 74.01 10-390-501030 Holiday Pay 38,718.75 14,900.88 0.00 23,817.87 61.52 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501070 Stand-by Plan 0.00 6,168.14 0.00 -6,168.14 0.00 10-390-501090 Overtime 22,814.00 36,369.39 0.00 -13,555.39 -59.42 10-390-501095 Overtime Straight Pay 1,850.00 648.52 0.00 1,201.48 64.94 10-390-502010 Social Security 87,556.95 24,999.67 0.00 62,557.28 71.45 10-390-502020 Group Health Insurance 223,648.25 48,804.36 0.00 174,843.89 78.18 10-390-502030 Retirement 152,546.30 36,963.08 0.00 115,583.22 75.77 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,332.94 295.70 0.00 1,037.24 77.82 10-390-502060 Long Term Disability 3,302.13 776.48 0.00 2,525.65 76.49 10-390-502070 Employee Assistance Prgm 480.48 217.38 0.00 263.10 54.76 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,616,122.27 453,819.22 0.00 1,162,303.05 71.92 10-390-511010 Advertising 1,400.00 0.00 0.00 1,400.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,800.00 1,066.21 2,279.40 3,454.39 50.80 E10 Materials & Supplies 8,200.00 1,066.21 2,279.40 4,854.39 59.20 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,650.00 1,476.00 0.00 4,174.00 73.88 10-390-522020 Professional Services 4,300.00 1,950.02 0.00 2,349.98 54.65 10-390-523010 Equipment Rentlease 99,260.00 32,690.70 0.00 66,569.30 67.07 E15 Contractual Services 109,768.00 36,116.72 0.00 73,651.28 67.10 10-390-531010 Electricity 11,160.00 0.00 0.00 11,160.00 100.00 10-390-533010 Natural Gas 279.00 0.00 0.00 279.00 100.00 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 0.00 0.00 837.00 100.00 E20 Utilities 12,276.00 0.00 0.00 12,276.00 100.00 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-546010 Clothing Expense 5,580.00 47.65 0.00 5,532.35 99.15 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 363.97 0.00 3,836.03 91.33 10-390-547020 Maintenance Agreements 75,000.00 12,673.42 5,921.40 56,405.18 75.21 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 61,637.89 5,921.40 76,046.71 52.96 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,889,972.27 552,640.04 8,200.80 1,329,131.43 70.3254 Grand Total -1,889,972.27 -552,640.04 -8,200.80 -1,329,131.43 0.7033 390 9-1-1 Police 1,889,972.27 552,640.04 8,200.80 1,329,131.43 70.33 400 Fire Department 10-400-501020 Salaries 4,989,033.59 1,388,708.00 0.00 3,600,325.59 72.16 10-400-501030 Holiday Pay 341,978.12 170,121.08 0.00 171,857.04 50.25 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 10,110.73 0.00 27,889.27 73.39 10-400-501090 Overtime 45,000.00 19,432.20 0.00 25,567.80 56.82 10-400-501095 Overtime Straight Pay 40,000.00 18,836.99 0.00 21,163.01 52.91 10-400-502010 Social Security 69,573.39 22,897.40 0.00 46,675.99 67.09 10-400-502020 Group Health Insurance 871,448.91 269,377.56 0.00 602,071.35 69.09 10-400-502030 Retirement 2,292,378.67 784,522.16 0.00 1,507,856.51 65.78 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 1,575.88 0.00 3,492.70 68.91 10-400-502060 Long Term Disability 12,419.68 4,120.43 0.00 8,299.25 66.82 10-400-502070 Employee Assistance Prgm 1,681.68 777.46 0.00 904.22 53.77 10-400-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 E05 Personnel Services 8,861,213.57 2,843,510.84 0.00 6,017,702.73 67.91 10-400-511010 Advertising 300.00 96.00 0.00 204.00 68.00 10-400-511020 Postage 120.00 150.67 0.00 -30.67 -25.56 10-400-512010 Printing 700.00 189.12 0.00 510.88 72.98 10-400-512020 Copies 50.00 0.14 0.00 49.86 99.72 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 375.34 0.00 1,019.66 73.09 10-400-514010 Gas 61,175.00 26,846.72 0.00 34,328.28 56.11 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 900.00 0.00 0.00 900.00 100.00 10-400-514030 Small Tools 6,000.00 2,817.08 0.00 3,182.92 53.05 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,788.30 0.00 311.70 14.84 10-400-517010 Operational Supplies 18,000.00 5,428.54 0.00 12,571.46 69.84 E10 Materials & Supplies 90,740.00 37,691.91 0.00 53,048.09 58.46 10-400-520030 Dues And Publications 3,400.00 2,225.55 0.00 1,174.45 34.54 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,000.00 17,822.71 0.00 14,177.29 44.30 10-400-520080 Tuition Reimbursement 7,500.00 3,510.00 0.00 3,990.00 53.20 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 4,085.00 0.00 35,915.00 89.79 10-400-522020 Professional Services 3,000.00 330.00 0.00 2,670.00 89.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,000.00 3,084.89 0.00 1,915.11 38.30 10-400-529040 Child Safety Seat Pass-through 2,500.00 495.00 0.00 2,005.00 80.20 E15 Contractual Services 93,593.00 31,553.15 0.00 62,039.85 66.29 10-400-531010 Electricity 35,000.00 10,438.03 0.00 24,561.97 70.18 10-400-533010 Natural Gas 17,670.00 15,895.57 0.00 1,774.43 10.04 10-400-534010 Telephone 25,984.20 9,351.63 0.00 16,632.57 64.01 10-400-535010 Water 12,000.00 3,417.53 0.00 8,582.47 71.52 E20 Utilities 90,654.20 39,102.76 0.00 51,551.44 56.87 10-400-540010 Building & Grounds Maint.90,000.00 18,244.07 675.00 71,080.93 78.98 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 28,615.56 0.00 66,384.44 69.88 10-400-546020 Uniform Cleaning 500.00 101.95 0.00 398.05 79.61 10-400-547010 Equipment Maintenance 20,000.00 6,636.95 0.00 13,363.05 66.82 10-400-547020 Maintenance Agreements 39,487.50 17,387.64 293.16 21,806.70 55.22 10-400-547030 Radio Maintenance 20,925.00 3,866.97 0.00 17,058.03 81.52 E25 Repairs & Maintenance 265,912.50 74,853.14 968.16 190,091.20 71.49 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 1,500.00 3,942.04 0.00 -2,442.04 -162.80 10-400-572021 Purchase of Equipment-ONE TIME 141,576.18 14,905.11 21,337.00 105,334.07 74.40 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 143,076.18 18,847.15 21,337.00 102,892.03 71.91 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,545,189.45 3,045,558.95 22,305.16 6,477,325.34 67.8596 Grand Total -9,545,189.45 -3,045,558.95 -22,305.16 -6,477,325.34 0.6786 400 Fire Department 9,545,189.45 3,045,558.95 22,305.16 6,477,325.34 67.86 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,105.48 0.00 594.52 34.97 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,700.00 1,105.48 0.00 594.52 34.97 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,700.00 1,105.48 0.00 594.52 34.9718 Grand Total -1,700.00 -1,105.48 0.00 -594.52 0.3497 401 Fire Museum 1,700.00 1,105.48 0.00 594.52 34.97 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 240,205.46 99,334.31 0.00 140,871.15 58.65 10-520-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 18,375.72 7,329.99 0.00 11,045.73 60.11 10-520-502020 Group Health Insurance 52,232.32 15,556.82 0.00 36,675.50 70.22 10-520-502030 Retirement 30,746.30 10,289.53 0.00 20,456.77 66.53 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 87.40 0.00 208.81 70.49 10-520-502060 Long Term Disability 636.77 218.21 0.00 418.56 65.73 10-520-502070 Employee Assistance Prgm 87.36 30.68 0.00 56.68 64.88 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 342,777.04 133,043.84 0.00 209,733.20 61.19 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 24.57 0.00 50.43 67.24 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.08 0.00 -0.08 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 252.42 0.00 597.58 70.30 10-520-514010 Gas 12,975.00 4,252.83 0.00 8,722.17 67.22 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 480.95 0.00 19.05 3.81 E10 Materials & Supplies 14,500.00 6,033.35 0.00 8,466.65 58.39 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 3,000.00 4,035.45 0.00 -1,035.45 -34.52 E15 Contractual Services 6,000.00 5,174.51 0.00 825.49 13.76 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 29,089.01 30,726.23 65.10 -1,702.32 -5.85 E25 Repairs & Maintenance 29,089.01 30,726.23 65.10 -1,702.32 -5.85 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 392,366.05 174,977.93 65.10 217,323.02 55.3878 Grand Total -392,366.05 -174,977.93 -65.10 -217,323.02 0.5539 520 Plan & Protect Svcs-Admin 392,366.05 174,977.93 65.10 217,323.02 55.39 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 34,133.56 0.00 17,275.22 33.60 10-521-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 3,932.77 2,550.28 0.00 1,382.49 35.15 10-521-502020 Group Health Insurance 9,239.72 5,581.85 0.00 3,657.87 39.59 10-521-502030 Retirement 6,580.32 4,368.95 0.00 2,211.37 33.61 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 38.98 0.00 23.44 37.55 10-521-502060 Long Term Disability 156.03 102.26 0.00 53.77 34.46 10-521-502070 Employee Assistance Prgm 15.29 27.62 0.00 -12.33 -80.64 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 71,553.68 46,961.85 0.00 24,591.83 34.37 10-521-511010 Advertising 3,336.00 1,291.50 0.00 2,044.50 61.29 10-521-511020 Postage 500.00 103.40 0.00 396.60 79.32 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 187.37 0.00 612.63 76.58 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 259.03 0.00 1,240.97 82.73 E10 Materials & Supplies 6,336.00 1,841.30 0.00 4,494.70 70.94 10-521-520030 Dues And Publications 13,220.00 99.00 0.00 13,121.00 99.25 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,720.00 99.00 0.00 14,621.00 99.33 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,271.00 441.78 637.86 191.36 15.06 E25 Repairs & Maintenance 1,271.00 441.78 637.86 191.36 15.06 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 93,880.68 49,343.93 637.86 43,898.89 46.7603 Grand Total -93,880.68 -49,343.93 -637.86 -43,898.89 0.4676 521 Plan & Protect Svcs-Planning 93,880.68 49,343.93 637.86 43,898.89 46.76 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 25,038.60 0.00 105,349.34 80.80 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,974.68 1,891.48 0.00 8,083.20 81.04 10-522-502020 Group Health Insurance 20,902.54 3,380.52 0.00 17,522.02 83.83 10-522-502030 Retirement 16,689.66 3,205.09 0.00 13,484.57 80.80 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 28.22 0.00 132.82 82.48 10-522-502060 Long Term Disability 397.13 74.05 0.00 323.08 81.35 10-522-502070 Employee Assistance Prgm 50.23 23.52 0.00 26.71 53.18 E05 Personnel Services 178,665.77 33,744.03 0.00 144,921.74 81.11 10-522-511010 Advertising 2,600.00 463.62 0.00 2,136.38 82.17 10-522-511020 Postage 300.00 21.60 0.00 278.40 92.80 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 300.00 43.43 0.00 256.57 85.52 10-522-517010 Operational Supplies 1,000.00 31.23 0.00 968.77 96.88 E10 Materials & Supplies 5,600.00 559.88 0.00 5,040.12 90.00 10-522-520030 Dues And Publications 1,500.00 235.97 0.00 1,264.03 84.27 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 23,821.00 29,097.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 24,056.97 29,097.60 35,845.43 40.28 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 2,400.00 629.78 565.69 1,204.53 50.19 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 629.78 565.69 1,204.53 50.19 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 279,065.77 58,990.66 29,663.29 190,411.82 68.2319 Grand Total -279,065.77 -58,990.66 -29,663.29 -190,411.82 0.6823 522 Plan & Protect Svcs-MPO 279,065.77 58,990.66 29,663.29 190,411.82 68.23 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 26,998.19 0.00 57,477.09 68.04 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 8,696.19 1,997.42 0.00 6,698.77 77.03 10-530-502020 Group Health Insurance 25,767.93 4,361.17 0.00 21,406.76 83.08 10-530-502030 Retirement 14,550.48 3,455.70 0.00 11,094.78 76.25 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 28.90 0.00 111.54 79.42 10-530-502060 Long Term Disability 344.86 74.07 0.00 270.79 78.52 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 37,008.43 0.00 97,105.01 72.41 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 6.06 0.00 143.94 95.96 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 110.00 14.35 0.00 95.65 86.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 235.04 0.00 344.96 59.48 E10 Materials & Supplies 1,380.00 461.20 0.00 918.80 66.58 10-530-520030 Dues And Publications 500.00 74.90 0.00 425.10 85.02 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,000.00 147.63 0.00 1,852.37 92.62 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 14,615.52 10,000.00 0.00 4,615.52 31.58 10-530-524026 Household Hazardous Waste 19,000.00 11,946.19 0.00 7,053.81 37.13 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 27,000.00 0.00 0.00 27,000.00 100.00 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 63,115.52 22,168.72 0.00 40,946.80 64.88 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 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-547020 Maintenance Agreements 672.02 306.14 328.04 37.84 5.63 E25 Repairs & Maintenance 672.02 306.14 328.04 37.84 5.63 10-530-550020 NRA-Residential 40,000.00 33,699.34 0.00 6,300.66 15.75 10-530-550030 NRA-Commercial Facade 19,500.00 3,000.00 0.00 16,500.00 84.62 10-530-550031 Historic Preservation Grant 23,000.00 55.75 2,750.00 20,194.25 87.80 10-530-550032 NRA-Rental Facade 15,000.00 27.00 0.00 14,973.00 99.82 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 1,200.00 26.00 0.00 1,174.00 97.83 10-530-550039 Historic Preservation Grant 50,000.00 67.50 2,750.00 47,182.50 94.37 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 92.94 0.00 -92.94 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 148,700.00 36,968.53 5,500.00 106,231.47 71.44 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 347,980.98 96,913.02 5,828.04 245,239.92 70.4751 Grand Total -347,980.98 -96,913.02 -5,828.04 -245,239.92 0.7048 530 Plan & Protect Svc-RedevGrant 347,980.98 96,913.02 5,828.04 245,239.92 70.48 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 194,879.84 63,877.09 0.00 131,002.75 67.22 10-532-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 14,908.31 4,525.77 0.00 10,382.54 69.64 10-532-502020 Group Health Insurance 39,644.71 12,254.95 0.00 27,389.76 69.09 10-532-502030 Retirement 24,944.62 8,176.28 0.00 16,768.34 67.22 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 66.51 0.00 172.17 72.13 10-532-502060 Long Term Disability 592.66 190.12 0.00 402.54 67.92 10-532-502070 Employee Assistance Prgm 65.52 48.58 0.00 16.94 25.85 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 279,027.76 92,892.72 0.00 186,135.04 66.71 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 37.65 0.00 112.35 74.90 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 0.00 0.00 1,300.00 100.00 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 2,625.00 37.65 0.00 2,587.35 98.57 10-532-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 382.00 0.00 618.00 61.80 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 201,600.00 67,200.00 134,400.00 0.00 0.00 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 204,100.00 67,582.00 134,400.00 2,118.00 1.04 10-532-534010 Telephone 1,200.00 371.16 0.00 828.84 69.07 E20 Utilities 1,200.00 371.16 0.00 828.84 69.07 10-532-540060 Cemetery Maintenance 37,750.00 12,248.82 24,504.00 997.18 2.64 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 160.00 0.00 920.00 85.19 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 223.32 287.66 399.02 43.85 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 13,916.14 24,791.66 2,362.20 5.75 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 528,022.76 174,799.67 159,191.66 194,031.43 36.7468 Grand Total -528,022.76 -174,799.67 -159,191.66 -194,031.43 0.3675 532 Plan & Protect Svcs-Env Health 528,022.76 174,799.67 159,191.66 194,031.43 36.75 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 164,815.30 65,449.35 0.00 99,365.95 60.29 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-501050 Parttime(wo Benefits)20,000.00 0.00 0.00 20,000.00 100.00 10-533-501060 Seasonal Salaries 0.00 7,994.37 0.00 -7,994.37 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,138.32 5,499.74 0.00 8,638.58 61.10 10-533-502020 Group Health Insurance 30,239.78 8,365.58 0.00 21,874.20 72.34 10-533-502030 Retirement 21,096.27 6,663.19 0.00 14,433.08 68.42 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 55.48 0.00 148.33 72.78 10-533-502060 Long Term Disability 505.89 158.53 0.00 347.36 68.66 10-533-502070 Employee Assistance Prgm 65.52 23.01 0.00 42.51 64.88 E05 Personnel Services 253,322.27 96,466.63 0.00 156,855.64 61.92 10-533-511010 Advertising 100.00 52.44 0.00 47.56 47.56 10-533-511020 Postage 1,800.00 538.68 0.00 1,261.32 70.07 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 559.32 0.00 440.68 44.07 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 451.45 0.00 898.55 66.56 E10 Materials & Supplies 4,690.00 1,601.89 0.00 3,088.11 65.84 10-533-520030 Dues And Publications 500.00 168.00 0.00 332.00 66.40 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 0.00 0.00 1,200.00 100.00 10-533-520080 Tuition Reimbursement 0.00 2,629.50 0.00 -2,629.50 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 10,000.00 6,297.80 0.00 3,702.20 37.02 10-533-522022 Demo 83,433.60 13,762.18 0.00 69,671.42 83.51 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 173,591.15 66,637.48 0.00 106,953.67 61.61 10-533-534010 Telephone 3,701.40 1,054.20 0.00 2,647.20 71.52 E20 Utilities 3,701.40 1,054.20 0.00 2,647.20 71.52 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 240.86 0.00 1,039.14 81.18 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 369.22 495.36 406.42 31.98 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 880.08 495.36 1,475.56 51.76 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 438,155.82 166,640.28 495.36 271,020.18 61.8547 Grand Total -438,155.82 -166,640.28 -495.36 -271,020.18 0.6185 533 PPS - Prop MaintCode Enforce 438,155.82 166,640.28 495.36 271,020.18 61.85 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 104,562.68 0.00 200,945.08 65.77 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 4,201.40 0.00 -4,201.40 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 24,587.69 7,623.14 0.00 16,964.55 69.00 10-534-502020 Group Health Insurance 79,982.22 25,037.00 0.00 54,945.22 68.70 10-534-502030 Retirement 39,104.99 13,383.99 0.00 25,721.00 65.77 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 119.26 0.00 255.28 68.16 10-534-502060 Long Term Disability 929.35 313.29 0.00 616.06 66.29 10-534-502070 Employee Assistance Prgm 109.20 61.38 0.00 47.82 43.79 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 471,251.82 160,058.21 0.00 311,193.61 66.04 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 110.88 0.00 989.12 89.92 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 232.87 0.00 667.13 74.13 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 370.84 0.00 1,429.16 79.40 E10 Materials & Supplies 4,115.00 714.59 0.00 3,400.41 82.63 10-534-520030 Dues And Publications 2,500.00 534.00 0.00 1,966.00 78.64 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 4,488.05 0.00 511.95 10.24 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 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 5,022.05 0.00 2,477.95 33.04 10-534-534010 Telephone 3,060.00 845.86 0.00 2,214.14 72.36 E20 Utilities 3,060.00 845.86 0.00 2,214.14 72.36 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,400.00 160.00 0.00 1,240.00 88.57 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 988.00 462.65 531.34 -5.99 -0.61 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 892.65 531.34 1,254.01 46.83 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 488,604.82 167,533.36 531.34 320,540.12 65.6031 Grand Total -488,604.82 -167,533.36 -531.34 -320,540.12 0.656 534 Plan & Protect Svcs-Bldg Regs 488,604.82 167,533.36 531.34 320,540.12 65.60 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 131,936.11 0.00 253,515.13 65.77 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 1,311.99 0.00 3,188.01 70.84 10-535-501095 Overtime Straight Pay 500.00 24.47 0.00 475.53 95.11 10-535-502010 Social Security 30,175.52 9,746.42 0.00 20,429.10 67.70 10-535-502020 Group Health Insurance 79,635.09 25,154.45 0.00 54,480.64 68.41 10-535-502030 Retirement 49,977.76 17,058.80 0.00 32,918.96 65.87 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 150.43 0.00 322.03 68.16 10-535-502060 Long Term Disability 1,177.64 396.52 0.00 781.12 66.33 10-535-502070 Employee Assistance Prgm 152.88 71.60 0.00 81.28 53.17 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 560,511.95 190,320.15 0.00 370,191.80 66.05 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 1.17 0.00 48.83 97.66 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 706.42 0.00 293.58 29.36 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 6,000.00 976.25 0.00 5,023.75 83.73 10-535-517010 Operational Supplies 6,000.00 3,799.39 0.00 2,200.61 36.68 E10 Materials & Supplies 13,140.00 5,499.73 0.00 7,640.27 58.15 10-535-520030 Dues And Publications 350.00 191.00 0.00 159.00 45.43 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,500.00 189.90 0.00 1,310.10 87.34 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,350.00 380.90 0.00 1,969.10 83.79 10-535-531010 Electricity 6,560.00 1,933.40 0.00 4,626.60 70.53 10-535-533010 Natural Gas 3,000.00 2,406.98 0.00 593.02 19.77 10-535-534010 Telephone 220.00 142.57 0.00 77.43 35.20 10-535-535010 Water 1,442.00 367.69 0.00 1,074.31 74.50 E20 Utilities 11,222.00 4,850.64 0.00 6,371.36 56.78 10-535-540010 Building & Grounds Maint.10,000.00 4,380.76 35.00 5,584.24 55.84 10-535-541010 Veh & Equip Parts Etc 393,400.00 59,061.49 15,567.13 318,771.38 81.03 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 9,000.00 4,871.87 0.00 4,128.13 45.87 10-535-547010 Equipment Maintenance 1,000.00 99.73 284.19 616.08 61.61 10-535-547020 Maintenance Agreements 17,251.00 6,064.43 0.00 11,186.57 64.85 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 74,478.28 15,886.32 340,386.40 79.02 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,017,974.95 275,529.70 15,886.32 726,558.93 71.373 Grand Total -1,017,974.95 -275,529.70 -15,886.32 -726,558.93 0.7137 535 Public Works-Central Maintenan 1,017,974.95 275,529.70 15,886.32 726,558.93 71.37 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 80,754.98 0.00 155,179.68 65.77 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 18,049.00 6,170.61 0.00 11,878.39 65.81 10-540-502020 Group Health Insurance 20,506.66 6,706.15 0.00 13,800.51 67.30 10-540-502030 Retirement 30,199.64 10,336.59 0.00 19,863.05 65.77 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 92.74 0.00 197.35 68.03 10-540-502060 Long Term Disability 569.01 226.10 0.00 342.91 60.26 10-540-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 E05 Personnel Services 305,833.81 104,537.08 0.00 201,296.73 65.82 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 2.40 0.00 197.60 98.80 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 104,350.00 33,253.15 0.00 71,096.85 68.13 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 106,350.00 33,255.55 0.00 73,094.45 68.73 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-520030 Dues And Publications 800.00 684.40 0.00 115.60 14.45 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,000.00 0.00 0.00 2,000.00 100.00 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,000.00 684.40 0.00 2,315.60 77.19 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 144.04 176.64 -15.68 -5.14 E25 Repairs & Maintenance 305.00 144.04 176.64 -15.68 -5.14 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 415,488.81 138,621.07 176.64 276,691.10 66.5941 Grand Total -415,488.81 -138,621.07 -176.64 -276,691.10 0.6659 540 Public Works-Admin 415,488.81 138,621.07 176.64 276,691.10 66.59 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 290,760.90 0.00 569,417.14 66.20 10-541-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 2,188.01 0.00 -1,788.01 -447.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 21,344.37 0.00 44,489.85 67.58 10-541-502020 Group Health Insurance 132,614.06 44,389.97 0.00 88,224.09 66.53 10-541-502030 Retirement 110,153.99 36,494.51 0.00 73,659.48 66.87 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 1,055.09 332.56 0.00 722.53 68.48 10-541-502060 Long Term Disability 2,488.48 860.59 0.00 1,627.89 65.42 10-541-502070 Employee Assistance Prgm 262.08 122.76 0.00 139.32 53.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,041.68 402,549.39 0.00 776,492.29 65.86 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 2.01 0.00 397.99 99.50 10-541-512010 Printing 0.00 41.00 0.00 -41.00 0.00 10-541-512020 Copies 0.00 0.43 0.00 -0.43 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 225.78 0.00 1,424.22 86.32 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 266.04 0.00 733.96 73.40 10-541-515080 Surveying Supplies 1,500.00 70.00 0.00 1,430.00 95.33 10-541-517010 Operational Supplies 2,000.00 876.22 0.00 1,123.78 56.19 E10 Materials & Supplies 7,350.00 1,481.48 0.00 5,868.52 79.84 10-541-520030 Dues And Publications 3,500.00 2,792.00 0.00 708.00 20.23 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,500.00 1,425.00 0.00 1,075.00 43.00 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 7,000.00 4,217.00 0.00 2,783.00 39.76 10-541-534010 Telephone 500.00 145.80 0.00 354.20 70.84 E20 Utilities 500.00 145.80 0.00 354.20 70.84 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,500.00 0.00 0.00 1,500.00 100.00 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 10-541-547020 Maintenance Agreements 10,665.00 7,895.20 596.44 2,173.36 20.38 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 9,505.20 596.44 4,063.36 28.69 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,208,056.68 417,898.87 596.44 789,561.37 65.358 Grand Total -1,208,056.68 -417,898.87 -596.44 -789,561.37 0.6536 541 Public Works-Engineering 1,208,056.68 417,898.87 596.44 789,561.37 65.36 542 Public Works-Street 10-542-501020 Salaries 1,373,894.56 380,853.29 0.00 993,041.27 72.28 10-542-501024 Salaries-Stormwater 0.00 61,598.81 0.00 -61,598.81 0.00 10-542-501060 Seasonal Salaries 20,000.00 0.00 0.00 20,000.00 100.00 10-542-501070 Stand-by Plan 5,000.00 3,054.40 0.00 1,945.60 38.91 10-542-501090 Overtime 30,000.00 6,883.61 0.00 23,116.39 77.05 10-542-501095 Overtime Straight Pay 500.00 1,125.64 0.00 -625.64 -125.13 10-542-502010 Social Security 109,348.68 33,417.08 0.00 75,931.60 69.44 10-542-502020 Group Health Insurance 304,688.92 84,968.78 0.00 219,720.14 72.11 10-542-502030 Retirement 180,402.50 56,477.76 0.00 123,924.74 68.69 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,684.22 496.64 0.00 1,187.58 70.51 10-542-502060 Long Term Disability 4,165.34 1,293.28 0.00 2,872.06 68.95 10-542-502070 Employee Assistance Prgm 622.44 291.54 0.00 330.90 53.16 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 2,069,617.50 669,571.67 0.00 1,400,045.83 67.65 10-542-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-542-511020 Postage 150.00 0.57 0.00 149.43 99.62 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,400.00 478.35 0.00 921.65 65.83 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 295,000.00 137,490.58 0.00 157,509.42 53.39 10-542-514030 Small Tools 9,000.00 6,285.61 0.00 2,714.39 30.16 10-542-514040 Food 2,000.00 596.58 0.00 1,403.42 70.17 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 225,000.00 105,197.82 0.00 119,802.18 53.25 10-542-515040 First Aid Supplies 500.00 161.22 0.00 338.78 67.76 10-542-515060 Weed Control 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 6,500.00 2,754.50 0.00 3,745.50 57.62 E10 Materials & Supplies 542,600.00 252,965.65 0.00 289,634.35 53.38 10-542-520030 Dues And Publications 1,320.00 477.00 0.00 843.00 63.86 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 4,108.47 0.00 3,571.53 46.50 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,500.00 1,102.80 0.00 13,397.20 92.39 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,700.00 5,688.27 0.00 18,011.73 76.00 10-542-531010 Electricity 24,364.00 8,379.83 0.00 15,984.17 65.61 10-542-531020 Street Lights 593,000.00 211,989.24 0.00 381,010.76 64.25 10-542-533010 Natural Gas 10,000.00 9,413.34 0.00 586.66 5.87 10-542-534010 Telephone 580.00 808.18 0.00 -228.18 -39.34 10-542-535010 Water 12,390.00 1,274.81 0.00 11,115.19 89.71 E20 Utilities 640,334.00 231,865.40 0.00 408,468.60 63.79 10-542-540010 Building & Grounds Maint.10,000.00 6,988.83 180.00 2,831.17 28.31 10-542-541030 Vehicle Wash 7,000.00 6,642.00 0.00 358.00 5.11 10-542-542010 Repairs - StopStreet Lights 35,000.00 3,227.44 0.00 31,772.56 90.78 10-542-542030 Signs & Marking Paint 60,000.00 1,218.01 9,681.98 49,100.01 81.83 10-542-546010 Clothing Expense 13,000.00 6,405.74 0.00 6,594.26 50.73 10-542-547010 Equipment Maintenance 3,200.00 809.32 0.00 2,390.68 74.71 10-542-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 25,291.34 9,861.98 94,406.68 72.87 10-542-572010 Purchase Of Vehicles 0.00 0.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 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 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,405,811.50 1,185,382.33 9,861.98 2,210,567.19 64.9057 Grand Total -3,405,811.50 -1,185,382.33 -9,861.98 -2,210,567.19 0.6491 542 Public Works-Street 3,405,811.50 1,185,382.33 9,861.98 2,210,567.19 64.91 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 26,328.02 6,682.21 0.00 19,645.81 74.62 10-700-590051 Trans to Parks 0.00 0.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 0.00 0.00 0.00 0.00 0.00 10-700-590053 Trans to Parking 0.00 0.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 0.00 0.00 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 0.00 0.00 0.00 0.00 0.00 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 91,200.16 91,200.16 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,189,132.88 1,189,132.88 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 1,306,661.06 1,287,015.25 0.00 19,645.81 1.50 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,306,661.06 1,287,015.25 0.00 19,645.81 1.5035 Grand Total -1,306,661.06 -1,287,015.25 0.00 -19,645.81 0.015 700 Transfers & Subsidies 1,306,661.06 1,287,015.25 0.00 19,645.81 1.50 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-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 992.53 0.00 0.00 992.53 100.00 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 10-990-576023 Norris Drive Culvert 0.00 2,130.42 927.75 -3,058.17 0.00 10-990-576025 Douglas Davis Stormwater 75,267.16 35,859.72 39,407.44 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 5,700.06 0.00 0.00 5,700.06 100.00 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 1,500,000.00 0.00 0.00 1,500,000.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599507 Hyde Park Burn Bldg 300,000.00 0.00 0.00 300,000.00 100.00 E75 Capital Projects 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.29 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.2905 Grand Total -2,111,503.35 -37,990.14 -40,335.19 -2,033,178.02 0.9629 990 Capital Projects 2,111,503.35 37,990.14 40,335.19 2,033,178.02 96.29 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery Maintenance 30,000.00 0.00 0.00 30,000.00 100.00 E25 Repairs & Maintenance 30,000.00 0.00 0.00 30,000.00 100.00 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-572010 Purchase of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 10-995-572020 Purchase of Equipment 19,500.00 17,345.38 0.00 2,154.62 11.05 E70 Capital Purchases 86,956.00 65,393.31 17,234.42 4,328.27 4.98 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 80,000.00 0.00 0.00 80,000.00 100.00 10-995-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-995-576007 Stormwater Improvements 540,917.60 31,305.75 0.00 509,611.85 94.21 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 200,000.00 0.00 0.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,077,827.75 3,352.25 0.00 1,074,475.50 99.69 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 58,903.62 500.00 40,596.38 40.60 10-995-599512 Street Resurfacing 276,509.44 274,622.36 1,878.64 8.44 0.00 E75 Capital Projects 4,995,889.79 368,183.98 202,378.64 4,425,327.17 88.58 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 5,887,845.79 433,577.29 219,613.06 5,234,655.44 88.9061 Grand Total -5,887,845.79 -433,577.29 -219,613.06 -5,234,655.44 0.8891 995 ARPA 5,887,845.79 433,577.29 219,613.06 5,234,655.44 88.91 Expense Expense 58,269,952.12 14,535,229.65 814,460.91 42,920,261.56 73.66 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 58,269,952.12 14,535,229.65 814,460.91 42,920,261.56 73.6576 Grand Total -58,269,952.12 -14,535,229.65 -814,460.91 -42,920,261.56 0.7366 GL - Trial Balance by Acct Type and Full Acct Number (03/20/2023 - 08:22 AM)Page 41