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-04 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 4/14/2023 9:17:40 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 27,000.00 0.00 38,925.00 59.04 10-110-501015 Salary-Prosecuting Attorney 34,999.92 14,583.30 0.00 20,416.62 58.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 2,520.00 0.00 14,078.40 84.82 10-110-502010 Social Security 8,990.53 3,229.10 0.00 5,761.43 64.08 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 126,585.44 47,403.99 0.00 79,181.45 62.55 10-110-511010 Advertising 0.00 79.75 0.00 -79.75 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 802.27 0.00 632.73 44.09 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 1,017.41 0.00 1,013.59 49.91 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 (04/14/2023 - 09:17 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 57,811.71 61.90 77,721.67 57.3189 Grand Total -135,595.28 -57,811.71 -61.90 -77,721.67 0.5732 110 Mayor & Council 135,595.28 57,811.71 61.90 77,721.67 57.32 120 City Clerk 10-120-501020 Salaries 56,948.36 24,005.72 0.00 32,942.64 57.85 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,693.41 0.00 2,663.14 61.13 10-120-502020 Group Health Insurance 13,245.50 5,265.33 0.00 7,980.17 60.25 10-120-502030 Retirement 7,289.39 3,072.74 0.00 4,216.65 57.85 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 27.92 0.00 41.85 59.98 10-120-502060 Long Term Disability 174.26 74.21 0.00 100.05 57.41 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 82,155.66 34,199.54 0.00 47,956.12 58.37 10-120-511020 Postage 200.00 132.82 0.00 67.18 33.59 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 166.65 0.00 133.35 44.45 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 364.06 0.00 335.94 47.99 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 66.99 0.00 133.01 66.51 10-120-529030 Election Expense 18,579.79 155.02 0.00 18,424.77 99.17 E15 Contractual Services 19,254.79 401.11 0.00 18,853.68 97.92 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 36,329.60 61.90 76,393.95 67.7339 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -36,329.60 -61.90 -76,393.95 0.6773 120 City Clerk 112,785.45 36,329.60 61.90 76,393.95 67.73 140 City Administrator 10-140-501020 Salaries 213,221.32 92,351.51 0.00 120,869.81 56.69 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 5,453.81 0.00 10,857.62 66.56 10-140-502020 Group Health Insurance 21,732.71 8,087.22 0.00 13,645.49 62.79 10-140-502030 Retirement 27,292.33 11,414.46 0.00 15,877.87 58.18 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 60.72 0.00 53.11 46.66 10-140-502060 Long Term Disability 374.04 211.62 0.00 162.42 43.42 10-140-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 279,290.56 117,801.02 0.00 161,489.54 57.82 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 15.83 0.00 134.17 89.45 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 330.28 0.00 1,273.46 79.41 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 119,796.77 61.90 163,735.63 57.7359 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -119,796.77 -61.90 -163,735.63 0.5774 140 City Administrator 283,594.30 119,796.77 61.90 163,735.63 57.74 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 8,395.41 0.00 273,976.59 97.03 10-144-502010 Social Security 0.00 619.15 0.00 -619.15 0.00 10-144-502020 Group Health Insurance 0.00 1,602.11 0.00 -1,602.11 0.00 10-144-502030 Retirement 0.00 1,074.58 0.00 -1,074.58 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 9.91 0.00 -9.91 0.00 10-144-502060 Long Term Disability 0.00 26.72 0.00 -26.72 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 11,727.88 0.00 270,644.12 95.85 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 11,727.88 0.00 7,297,572.12 99.8395 Grand Total -7,309,300.00 -11,727.88 0.00 -7,297,572.12 0.9984 144 CDBG-DR 7,309,300.00 11,727.88 0.00 7,297,572.12 99.84 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 4,688.86 0.00 35,511.77 88.34 10-145-502010 Social Security 840.81 315.96 0.00 524.85 62.42 10-145-502020 Group Health Insurance 2,491.43 1,255.02 0.00 1,236.41 49.63 10-145-502030 Retirement 1,406.85 600.18 0.00 806.67 57.34 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 5.35 0.00 8.23 60.60 10-145-502060 Long Term Disability 33.34 14.05 0.00 19.29 57.86 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 6,887.76 0.00 38,112.24 84.69 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 6,887.76 0.00 1,993,112.24 99.6556 Grand Total -2,000,000.00 -6,887.76 0.00 -1,993,112.24 0.9966 145 CDBG-CV Cole Co EMS Station 2,000,000.00 6,887.76 0.00 1,993,112.24 99.66 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 9,710.28 14,407.85 0.00 -4,697.57 -48.38 10-146-502010 Social Security 742.84 975.57 0.00 -232.73 -31.33 10-146-502020 Group Health Insurance 2,201.13 3,903.98 0.00 -1,702.85 -77.36 10-146-502030 Retirement 1,242.92 1,844.19 0.00 -601.27 -48.38 10-146-502040 Workers Compensation 7.37 7.37 0.00 0.00 0.00 10-146-502050 Life Insurance 12.00 17.51 0.00 -5.51 -45.92 10-146-502060 Long Term Disability 29.46 46.85 0.00 -17.39 -59.03 10-146-502070 Employee Assistance Prgm 4.44 0.00 0.00 4.44 100.00 E05 Personnel Services 13,950.44 21,203.32 0.00 -7,252.88 -51.99 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 21,203.32 0.00 667,682.88 96.9221 Grand Total -688,886.20 -21,203.32 0.00 -667,682.88 0.9692 146 HPF-P Bruhn Revitalization 688,886.20 21,203.32 0.00 667,682.88 96.92 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 2,277.52 0.00 26,193.86 92.00 10-147-502010 Social Security 576.14 155.66 0.00 420.48 72.98 10-147-502020 Group Health Insurance 1,707.17 530.31 0.00 1,176.86 68.94 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-502030 Retirement 964.00 291.54 0.00 672.46 69.76 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 2.51 0.00 6.79 73.01 10-147-502060 Long Term Disability 22.85 6.50 0.00 16.35 71.55 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 3,269.76 0.00 28,490.24 89.70 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,269.76 0.00 572,490.24 99.4321 Grand Total -575,760.00 -3,269.76 0.00 -572,490.24 0.9943 147 CDBG-CV Transform Housing 575,760.00 3,269.76 0.00 572,490.24 99.43 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 12,261.54 0.00 34,913.60 74.01 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 (04/14/2023 - 09:17 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502010 Social Security 3,608.91 868.51 0.00 2,740.40 75.93 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,752.36 0.00 7,941.31 74.26 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,569.49 0.00 4,468.95 74.01 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 14.99 0.00 43.29 74.28 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 39.40 0.00 103.72 72.47 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 17,557.44 0.00 50,217.49 74.09 10-149-511010 Advertising 1,400.00 416.00 0.00 984.00 70.29 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 99.54 0.00 -29.54 -42.20 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 515.54 0.00 1,304.46 71.67 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 108.00 0.00 39,892.00 99.73 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,341.00 0.00 129,659.00 92.61 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 313,000.00 0.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 404,442.02 0.00 0.00 404,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,503.00 0.00 634,964.02 66.25 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 (04/14/2023 - 09:17 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 341,575.98 0.00 686,485.97 66.7748 Grand Total -1,028,061.95 -341,575.98 0.00 -686,485.97 0.6677 149 Entitlement Grant 1,028,061.95 341,575.98 0.00 686,485.97 66.77 150 City Attorney 10-150-501020 Salaries 233,777.84 97,553.26 0.00 136,224.58 58.27 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 7,199.77 0.00 10,684.23 59.74 10-150-502020 Group Health Insurance 35,360.71 13,721.49 0.00 21,639.22 61.20 10-150-502030 Retirement 29,923.56 12,486.83 0.00 17,436.73 58.27 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 113.76 0.00 172.66 60.28 10-150-502060 Long Term Disability 607.87 289.45 0.00 318.42 52.38 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 131,626.03 0.00 186,510.68 58.63 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 94.37 0.00 505.63 84.27 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 9.99 0.00 -9.99 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 141.52 0.00 1,733.48 92.45 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,893.22 0.00 2,206.78 43.27 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 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 29,082.12 0.00 -29,082.12 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 22,600.00 33,371.24 0.00 -10,771.24 -47.66 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 165,200.69 61.90 177,720.12 51.8161 Grand Total -342,982.71 -165,200.69 -61.90 -177,720.12 0.5182 150 City Attorney 342,982.71 165,200.69 61.90 177,720.12 51.82 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 14,583.30 0.00 20,416.62 58.33 10-160-501020 Salaries 124,730.18 53,077.45 0.00 71,652.73 57.45 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 2,205.19 0.00 4,794.81 68.50 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 5,255.78 0.00 7,575.57 59.04 10-160-502020 Group Health Insurance 25,616.32 12,026.58 0.00 13,589.74 53.05 10-160-502030 Retirement 16,093.46 6,807.59 0.00 9,285.87 57.70 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 60.95 0.00 92.05 60.16 10-160-502060 Long Term Disability 381.67 161.80 0.00 219.87 57.61 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 94,513.97 0.00 128,555.62 57.63 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 687.03 0.00 1,312.97 65.65 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 881.50 0.00 4,018.50 82.01 10-160-520025 Security 12,500.00 4,874.73 0.00 7,625.27 61.00 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 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 (04/14/2023 - 09:17 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 5,437.23 0.00 17,352.77 76.14 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 3,795.00 0.00 2,500.00 39.71 E25 Repairs & Maintenance 6,295.00 3,795.00 0.00 2,500.00 39.71 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 104,627.70 0.00 152,426.89 59.2975 Grand Total -257,054.59 -104,627.70 0.00 -152,426.89 0.593 160 Municipal Court 257,054.59 104,627.70 0.00 152,426.89 59.30 170 Human Resources 10-170-501020 Salaries 229,300.24 97,084.90 0.00 132,215.34 57.66 10-170-501050 Parttime(wo Benefits)13,000.00 7,455.87 0.00 5,544.13 42.65 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 7,867.81 0.00 10,675.81 57.57 10-170-502020 Group Health Insurance 25,708.58 10,113.10 0.00 15,595.48 60.66 10-170-502030 Retirement 29,363.23 12,449.51 0.00 16,913.72 57.60 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 111.78 0.00 168.52 60.12 10-170-502060 Long Term Disability 589.14 286.16 0.00 302.98 51.43 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 135,902.91 0.00 181,373.41 57.17 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 119.37 0.00 180.63 60.21 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 207.55 0.00 292.45 58.49 10-170-513010 Office Supplies 600.00 42.61 0.00 557.39 92.90 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 434.97 0.00 2,495.03 85.15 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 827.26 0.00 2,172.74 72.42 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 (04/14/2023 - 09:17 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 33.25 0.00 466.75 93.35 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 1,207.83 9,500.00 10,329.17 49.10 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,361.85 61.90 32,314.86 61.27 E25 Repairs & Maintenance 52,738.61 20,361.85 61.90 32,314.86 61.27 10-170-572020 Purchase Of Equipment 3,175.24 3,175.24 0.00 0.00 0.00 E70 Capital Purchases 3,175.24 3,175.24 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 397,157.17 161,082.80 9,561.90 226,512.47 57.0335 Grand Total -397,157.17 -161,082.80 -9,561.90 -226,512.47 0.5703 170 Human Resources 397,157.17 161,082.80 9,561.90 226,512.47 57.03 180 Finance Department 10-180-501020 Salaries 570,708.35 194,705.12 0.00 376,003.23 65.88 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 14,599.95 0.00 29,059.24 66.56 10-180-502020 Group Health Insurance 96,970.17 29,760.98 0.00 67,209.19 69.31 10-180-502030 Retirement 73,050.67 24,872.62 0.00 48,178.05 65.95 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 219.45 0.00 484.35 68.82 10-180-502060 Long Term Disability 1,743.45 578.54 0.00 1,164.91 66.82 10-180-502070 Employee Assistance Prgm 234.78 87.54 0.00 147.24 62.71 10-180-503020 Unemployment Compensation 0.00 112.09 0.00 -112.09 0.00 E05 Personnel Services 787,569.24 265,435.09 0.00 522,134.15 66.30 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 10,000.00 4,177.89 0.00 5,822.11 58.22 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 14.74 0.00 985.26 98.53 10-180-512021 Copy Machine Cost 190.00 -423.15 0.00 613.15 322.71 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 (04/14/2023 - 09:17 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 23,095.00 6,088.26 0.00 17,006.74 73.64 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 2,204.66 0.00 3,245.34 59.55 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 11,416.78 0.00 61,423.86 84.33 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 298,363.48 0.00 603,471.85 66.916 Grand Total -901,835.33 -298,363.48 0.00 -603,471.85 0.6692 180 Finance Department 901,835.33 298,363.48 0.00 603,471.85 66.92 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 (04/14/2023 - 09:17 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 49,347.50 0.00 -24,347.50 -97.39 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,909.00 0.00 1,655.00 46.44 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 28,095.00 34,293.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 533,663.58 34,293.00 281,008.92 33.10 10-185-531010 Electricity 32,000.00 10,121.60 0.00 21,878.40 68.37 10-185-533010 Natural Gas 6,200.00 4,589.39 0.00 1,610.61 25.98 10-185-535010 Water 7,250.00 2,780.06 0.00 4,469.94 61.65 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 17,491.05 0.00 27,958.95 61.52 10-185-540010 Building & Grounds Maint.40,000.00 26,379.42 0.00 13,620.58 34.05 10-185-540015 Amtrak Station 4,000.00 1,093.94 0.00 2,906.06 72.65 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 53,389.36 0.00 17,670.64 24.87 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 (04/14/2023 - 09:17 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 202,385.08 182,029.00 67,146.68 14.87 E30 Other Operating Expenses 464,360.76 214,584.60 182,029.00 67,747.16 14.59 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 -6,815.99 0.00 6,815.99 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 -6,815.99 0.00 6,815.99 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 853,721.81 216,322.00 823,090.31 43.4777 Grand Total -1,893,134.12 -853,721.81 -216,322.00 -823,090.31 0.4348 185 Non-Departmental 1,893,134.12 853,721.81 216,322.00 823,090.31 43.48 190 Information Technology Svcs 10-190-501020 Salaries 606,371.81 247,025.84 0.00 359,345.97 59.26 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 18,351.01 0.00 28,074.68 60.47 10-190-502020 Group Health Insurance 96,814.24 31,773.44 0.00 65,040.80 67.18 10-190-502030 Retirement 77,679.59 28,276.07 0.00 49,403.52 63.60 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 271.86 0.00 472.33 63.47 10-190-502060 Long Term Disability 1,815.32 737.64 0.00 1,077.68 59.37 10-190-502070 Employee Assistance Prgm 207.48 97.18 0.00 110.30 53.16 E05 Personnel Services 831,916.53 327,891.25 0.00 504,025.28 60.59 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 7.18 0.00 2.82 28.20 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 398.48 0.00 101.52 20.30 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 2,015.33 0.00 -15.33 -0.77 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 2,660.00 2,474.99 0.00 185.01 6.96 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 1,101.40 0.00 7,398.60 87.04 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 10,757.56 0.00 12,242.44 53.23 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 22,215.95 0.00 22,834.05 50.69 10-190-534010 Telephone 96,000.00 36,533.24 0.00 59,466.76 61.94 E20 Utilities 96,000.00 36,533.24 0.00 59,466.76 61.94 10-190-545010 Software License\maint 182,000.00 154,674.09 17,350.20 9,975.71 5.48 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 204.85 0.00 -204.85 0.00 E25 Repairs & Maintenance 204,000.00 164,690.94 17,350.20 21,958.86 10.76 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 553,806.37 17,350.20 608,469.96 51.5816 Grand Total -1,179,626.53 -553,806.37 -17,350.20 -608,469.96 0.5158 190 Information Technology Svcs 1,179,626.53 553,806.37 17,350.20 608,469.96 51.58 300 Police Department 10-300-501020 Salaries 5,457,482.75 2,067,468.55 0.00 3,390,014.20 62.12 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 13,008.70 0.00 32,849.31 71.63 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 4,573.30 0.00 426.70 8.53 10-300-501090 Overtime 285,142.77 157,224.16 0.00 127,918.61 44.86 10-300-501095 Overtime Straight Pay 13,275.00 7,963.19 0.00 5,311.81 40.01 10-300-502010 Social Security 444,750.67 168,599.26 0.00 276,151.41 62.09 10-300-502020 Group Health Insurance 960,547.52 346,180.71 0.00 614,366.81 63.96 10-300-502030 Retirement 1,009,334.34 393,186.34 0.00 616,148.00 61.04 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 2,323.80 0.00 4,218.48 64.48 10-300-502060 Long Term Disability 15,894.91 6,150.90 0.00 9,744.01 61.30 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 687.00 1,813.00 72.52 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 3,308,983.18 687.00 5,222,989.09 61.21 10-300-511010 Advertising 5,665.00 3,762.25 0.00 1,902.75 33.59 10-300-511020 Postage 1,395.00 654.57 0.00 740.43 53.08 10-300-512010 Printing 5,952.00 2,669.40 0.00 3,282.60 55.15 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 10,006.27 0.00 5,664.23 36.15 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 943.41 0.00 434.59 31.54 10-300-516010 Ammunition & Firearms Supplies 63,136.25 54,409.52 7,773.00 953.73 1.51 10-300-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)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 18,663.01 2,425.00 25,189.99 54.43 E10 Materials & Supplies 344,272.75 164,188.90 10,198.00 169,885.85 49.35 10-300-520030 Dues And Publications 5,400.00 2,514.40 0.00 2,885.60 53.44 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 46,101.04 0.00 29,898.96 39.34 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,790.00 0.00 3,720.00 57.14 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 16,470.00 0.00 -470.00 -2.94 10-300-522026 Drug Forfeiture - Justice 29,750.00 4,500.00 0.00 25,250.00 84.87 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 12,086.00 12,086.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 0.00 0.00 2,046.00 100.00 E15 Contractual Services 160,704.00 84,774.18 0.00 75,929.82 47.25 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 8,289.86 0.00 15,811.14 65.60 10-300-535010 Water 3,348.00 1,676.13 0.00 1,671.87 49.94 E20 Utilities 73,205.00 26,553.37 0.00 46,651.63 63.73 10-300-540010 Building & Grounds Maint.37,200.00 68,991.33 0.00 -31,791.33 -85.46 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,440.60 880.35 7,419.05 44.32 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 9,897.31 0.00 18,052.69 64.59 10-300-545010 Software License\maint 82,414.00 64,645.16 0.00 17,768.84 21.56 10-300-546010 Clothing Expense 48,920.00 10,435.20 510.50 37,974.30 77.63 10-300-546020 Uniform Cleaning 23,715.00 12,482.69 0.00 11,232.31 47.36 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 32,989.60 4,697.40 18,561.00 33.00 10-300-547030 Radio Maintenance 8,025.00 96.88 0.00 7,928.12 98.79 E25 Repairs & Maintenance 320,964.00 215,500.59 6,088.25 99,375.16 30.96 10-300-572010 Purchase Of Vehicles 46,849.80 5,093.80 41,739.00 17.00 0.04 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 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 41,739.00 230,718.60 71.14 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,756,106.42 3,851,844.02 58,712.25 5,845,550.15 59.9168 Grand Total -9,756,106.42 -3,851,844.02 -58,712.25 -5,845,550.15 0.5992 300 Police Department 9,756,106.42 3,851,844.02 58,712.25 5,845,550.15 59.92 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-501020 Salaries 489,893.97 166,544.90 0.00 323,349.07 66.00 10-310-501030 Holiday Pay 20,720.19 0.00 0.00 20,720.19 100.00 10-310-501090 Overtime 45,106.00 35,570.94 0.00 9,535.06 21.14 10-310-501095 Overtime Straight Pay 1,311.00 1,540.10 0.00 -229.10 -17.48 10-310-502010 Social Security 42,612.88 14,685.18 0.00 27,927.70 65.54 10-310-502020 Group Health Insurance 89,715.43 30,858.46 0.00 58,856.97 65.60 10-310-502030 Retirement 100,265.61 36,658.08 0.00 63,607.53 63.44 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 183.66 0.00 419.77 69.56 10-310-502060 Long Term Disability 1,498.63 488.11 0.00 1,010.52 67.43 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 798,454.72 293,164.13 0.00 505,290.59 63.28 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 0.00 0.00 15,345.00 100.00 10-310-517010 Operational Supplies 6,995.00 0.00 0.00 6,995.00 100.00 E10 Materials & Supplies 22,340.00 0.00 0.00 22,340.00 100.00 10-310-520070 Training And Education 4,650.00 0.00 0.00 4,650.00 100.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 0.00 0.00 4,650.00 100.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 0.00 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 293,854.13 959.20 536,965.39 64.5563 Grand Total -831,778.72 -293,854.13 -959.20 -536,965.39 0.6456 310 School Resource Officer 831,778.72 293,854.13 959.20 536,965.39 64.56 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 53,491.94 0.00 74,115.02 58.08 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 13,822.38 0.00 15,595.84 53.01 10-320-501095 Overtime Straight Pay 0.00 552.39 0.00 -552.39 0.00 10-320-502010 Social Security 11,037.18 4,942.07 0.00 6,095.11 55.22 10-320-502020 Group Health Insurance 20,462.81 8,090.71 0.00 12,372.10 60.46 10-320-502030 Retirement 25,969.83 12,216.00 0.00 13,753.83 52.96 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 58.69 0.00 96.76 62.25 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502060 Long Term Disability 384.75 155.11 0.00 229.64 59.69 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 222,402.83 95,354.14 0.00 127,048.69 57.13 10-320-514010 Gas 11,848.00 2,902.92 0.00 8,945.08 75.50 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 6,360.00 0.00 8,746.00 57.90 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 9,862.92 0.00 22,285.36 69.32 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 272,051.11 109,717.06 0.00 162,334.05 59.6704 Grand Total -272,051.11 -109,717.06 0.00 -162,334.05 0.5967 320 M.U.S.T.A.N.G.272,051.11 109,717.06 0.00 162,334.05 59.67 330 Animal Control 10-330-501020 Salaries 370,091.13 129,440.16 0.00 240,650.97 65.02 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 3,657.98 0.00 4,942.02 57.47 10-330-501090 Overtime 2,000.00 7,759.71 0.00 -5,759.71 -287.99 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 9,660.87 0.00 19,462.00 66.83 10-330-502020 Group Health Insurance 93,298.71 31,738.37 0.00 61,560.34 65.98 10-330-502030 Retirement 48,728.46 18,029.79 0.00 30,698.67 63.00 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 456.55 144.08 0.00 312.47 68.44 10-330-502060 Long Term Disability 1,117.06 392.75 0.00 724.31 64.84 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 205,586.63 0.00 352,683.95 63.17 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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,281.00 193.98 0.00 1,087.02 84.86 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 113.90 0.00 109.10 48.92 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,880.57 0.00 4,119.43 37.45 E10 Materials & Supplies 15,716.00 7,871.00 0.00 7,845.00 49.92 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 1,611.00 0.00 0.00 1,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 957.20 0.00 3,872.80 80.18 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 0.00 4,580.00 0.00 -4,580.00 0.00 E15 Contractual Services 13,239.00 6,649.09 0.00 6,589.91 49.78 10-330-531010 Electricity 22,789.00 10,127.37 0.00 12,661.63 55.56 10-330-533010 Natural Gas 21,000.00 9,914.40 0.00 11,085.60 52.79 10-330-534010 Telephone 810.00 337.06 0.00 472.94 58.39 10-330-535010 Water 3,800.00 1,306.72 0.00 2,493.28 65.61 E20 Utilities 48,399.00 21,685.55 0.00 26,713.45 55.19 10-330-540010 Building & Grounds Maint.15,000.00 15,270.80 0.00 -270.80 -1.81 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 24,610.40 0.00 24,679.60 50.07 10-330-544050 Animal Food 6,603.00 1,955.11 0.00 4,647.89 70.39 10-330-545010 Software Licensemaint 3,191.00 2,495.04 0.00 695.96 21.81 10-330-546010 Clothing Expense 2,025.00 986.80 0.00 1,038.20 51.27 10-330-546020 Uniform Cleaning 0.00 284.16 0.00 -284.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 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 79,074.00 48,228.31 0.00 30,845.69 39.01 10-330-572010 Purchase of Vehicles 42,695.00 1,600.00 41,095.00 0.00 0.00 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 (04/14/2023 - 09:17 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 42,695.00 1,600.00 41,095.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 757,393.58 291,620.58 41,095.00 424,678.00 56.071 Grand Total -757,393.58 -291,620.58 -41,095.00 -424,678.00 0.5607 330 Animal Control 757,393.58 291,620.58 41,095.00 424,678.00 56.07 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 348,551.60 0.00 732,600.91 67.76 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 7,537.64 0.00 -7,537.64 0.00 10-390-501090 Overtime 22,814.00 47,038.66 0.00 -24,224.66 -106.18 10-390-501095 Overtime Straight Pay 1,850.00 1,296.72 0.00 553.28 29.91 10-390-502010 Social Security 87,556.95 30,893.35 0.00 56,663.60 64.72 10-390-502020 Group Health Insurance 223,648.25 62,672.29 0.00 160,975.96 71.98 10-390-502030 Retirement 152,546.30 45,590.93 0.00 106,955.37 70.11 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 379.81 0.00 953.13 71.51 10-390-502060 Long Term Disability 3,302.13 1,003.48 0.00 2,298.65 69.61 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 562,802.70 0.00 1,053,319.57 65.18 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 4,344.61 0.00 2,455.39 36.11 E10 Materials & Supplies 8,200.00 4,344.61 0.00 3,855.39 47.02 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,342.25 0.00 4,307.75 76.24 10-390-522020 Professional Services 4,300.00 2,282.70 0.00 2,017.30 46.91 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,315.65 0.00 73,452.35 66.92 10-390-531010 Electricity 11,160.00 4,056.35 0.00 7,103.65 63.65 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 146.32 0.00 690.68 82.52 E20 Utilities 12,276.00 4,202.67 0.00 8,073.33 65.77 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 (04/14/2023 - 09:17 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-546010 Clothing Expense 5,580.00 66.85 0.00 5,513.15 98.80 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 63,060.90 177.12 11,761.98 15.68 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 112,044.57 177.12 31,384.31 21.85 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,889,972.27 719,710.20 177.12 1,170,084.95 61.9102 Grand Total -1,889,972.27 -719,710.20 -177.12 -1,170,084.95 0.6191 390 9-1-1 Police 1,889,972.27 719,710.20 177.12 1,170,084.95 61.91 400 Fire Department 10-400-501020 Salaries 4,989,033.59 1,702,142.24 0.00 3,286,891.35 65.88 10-400-501030 Holiday Pay 341,978.12 170,880.90 0.00 171,097.22 50.03 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 12,750.73 0.00 25,249.27 66.45 10-400-501090 Overtime 45,000.00 25,528.37 0.00 19,471.63 43.27 10-400-501095 Overtime Straight Pay 40,000.00 23,436.73 0.00 16,563.27 41.41 10-400-502010 Social Security 69,573.39 27,526.92 0.00 42,046.47 60.43 10-400-502020 Group Health Insurance 871,448.91 339,645.47 0.00 531,803.44 61.03 10-400-502030 Retirement 2,292,378.67 945,262.18 0.00 1,347,116.49 58.77 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,979.78 0.00 3,088.80 60.94 10-400-502060 Long Term Disability 12,419.68 5,209.74 0.00 7,209.94 58.05 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 3,408,171.47 0.00 5,453,042.10 61.54 10-400-511010 Advertising 300.00 96.00 0.00 204.00 68.00 10-400-511020 Postage 120.00 164.96 0.00 -44.96 -37.47 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 430.54 0.00 964.46 69.14 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 3,158.04 0.00 2,841.96 47.37 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 6,019.57 0.00 11,980.43 66.56 E10 Materials & Supplies 90,740.00 38,693.39 0.00 52,046.61 57.36 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 (04/14/2023 - 09:17 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 20,832.21 0.00 11,167.79 34.90 10-400-520080 Tuition Reimbursement 7,500.00 4,914.00 0.00 2,586.00 34.48 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 35,966.65 0.00 57,626.35 61.57 10-400-531010 Electricity 35,000.00 12,441.07 0.00 22,558.93 64.45 10-400-533010 Natural Gas 17,670.00 17,997.42 0.00 -327.42 -1.85 10-400-534010 Telephone 25,984.20 11,559.85 0.00 14,424.35 55.51 10-400-535010 Water 12,000.00 3,974.45 0.00 8,025.55 66.88 E20 Utilities 90,654.20 45,972.79 0.00 44,681.41 49.29 10-400-540010 Building & Grounds Maint.90,000.00 19,575.68 525.00 69,899.32 77.67 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 29,959.66 0.00 65,040.34 68.46 10-400-546020 Uniform Cleaning 500.00 101.95 0.00 398.05 79.61 10-400-547010 Equipment Maintenance 20,000.00 8,485.16 0.00 11,514.84 57.57 10-400-547020 Maintenance Agreements 39,487.50 19,642.14 293.16 19,552.20 49.51 10-400-547030 Radio Maintenance 20,925.00 3,886.78 0.00 17,038.22 81.43 E25 Repairs & Maintenance 265,912.50 81,651.37 818.16 183,442.97 68.99 10-400-572010 Purchase Of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 4,162.15 0.00 -2,662.15 -177.48 10-400-572021 Purchase of Equipment-ONE TIME 159,899.18 16,225.00 124,203.40 19,470.78 12.18 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 228,855.18 68,435.08 141,437.82 18,982.28 8.29 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,630,968.45 3,678,890.75 142,255.98 5,809,821.72 60.3244 Grand Total -9,630,968.45 -3,678,890.75 -142,255.98 -5,809,821.72 0.6032 400 Fire Department 9,630,968.45 3,678,890.75 142,255.98 5,809,821.72 60.32 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,214.88 0.00 485.12 28.54 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,214.88 0.00 485.12 28.54 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 (04/14/2023 - 09:17 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,214.88 0.00 485.12 28.5365 Grand Total -1,700.00 -1,214.88 0.00 -485.12 0.2854 401 Fire Museum 1,700.00 1,214.88 0.00 485.12 28.54 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 (04/14/2023 - 09:17 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 117,490.61 0.00 122,714.85 51.09 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 8,668.30 0.00 9,707.42 52.83 10-520-502020 Group Health Insurance 52,232.32 18,930.83 0.00 33,301.49 63.76 10-520-502030 Retirement 30,746.30 12,613.53 0.00 18,132.77 58.98 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 106.10 0.00 190.11 64.18 10-520-502060 Long Term Disability 636.77 268.49 0.00 368.28 57.84 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 158,305.44 0.00 184,471.60 53.82 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 257.72 0.00 592.28 69.68 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 619.30 0.00 -119.30 -23.86 E10 Materials & Supplies 14,500.00 6,177.00 0.00 8,323.00 57.40 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,735.53 55.80 -1,702.32 -5.85 E25 Repairs & Maintenance 29,089.01 30,735.53 55.80 -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 (04/14/2023 - 09:17 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 200,392.48 55.80 191,917.77 48.9129 Grand Total -392,366.05 -200,392.48 -55.80 -191,917.77 0.4891 520 Plan & Protect Svcs-Admin 392,366.05 200,392.48 55.80 191,917.77 48.91 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 42,314.76 0.00 9,094.02 17.69 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 3,160.47 0.00 772.30 19.64 10-521-502020 Group Health Insurance 9,239.72 7,043.47 0.00 2,196.25 23.77 10-521-502030 Retirement 6,580.32 5,416.13 0.00 1,164.19 17.69 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 48.98 0.00 13.44 21.53 10-521-502060 Long Term Disability 156.03 129.30 0.00 26.73 17.13 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 58,299.08 0.00 13,254.60 18.52 10-521-511010 Advertising 3,336.00 1,883.20 0.00 1,452.80 43.55 10-521-511020 Postage 500.00 164.48 0.00 335.52 67.10 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 87.66 0.00 112.34 56.17 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 259.03 0.00 1,240.97 82.73 E10 Materials & Supplies 6,336.00 2,581.74 0.00 3,754.26 59.25 10-521-520030 Dues And Publications 13,220.00 632.00 0.00 12,588.00 95.22 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 632.00 0.00 14,088.00 95.71 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 617.52 546.74 106.74 8.40 E25 Repairs & Maintenance 1,271.00 617.52 546.74 106.74 8.40 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 62,130.34 546.74 31,203.60 33.2375 Grand Total -93,880.68 -62,130.34 -546.74 -31,203.60 0.3324 521 Plan & Protect Svcs-Planning 93,880.68 62,130.34 546.74 31,203.60 33.24 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 31,558.03 0.00 98,829.91 75.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 2,383.87 0.00 7,590.81 76.10 10-522-502020 Group Health Insurance 20,902.54 4,356.47 0.00 16,546.07 79.16 10-522-502030 Retirement 16,689.66 4,039.59 0.00 12,650.07 75.80 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 36.37 0.00 124.67 77.42 10-522-502060 Long Term Disability 397.13 96.02 0.00 301.11 75.82 10-522-502070 Employee Assistance Prgm 50.23 23.52 0.00 26.71 53.18 E05 Personnel Services 178,665.77 42,596.42 0.00 136,069.35 76.16 10-522-511010 Advertising 2,600.00 656.62 0.00 1,943.38 74.75 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 58.42 0.00 241.58 80.53 10-522-517010 Operational Supplies 1,000.00 31.23 0.00 968.77 96.88 E10 Materials & Supplies 5,600.00 767.87 0.00 4,832.13 86.29 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 710.59 484.88 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 710.59 484.88 1,204.53 50.19 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 68,131.85 29,582.48 181,351.44 64.9852 Grand Total -279,065.77 -68,131.85 -29,582.48 -181,351.44 0.6499 522 Plan & Protect Svcs-MPO 279,065.77 68,131.85 29,582.48 181,351.44 64.99 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 27,131.11 0.00 57,344.17 67.88 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 2,005.74 0.00 6,690.45 76.94 10-530-502020 Group Health Insurance 25,767.93 4,406.10 0.00 21,361.83 82.90 10-530-502030 Retirement 14,550.48 3,472.71 0.00 11,077.77 76.13 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 29.07 0.00 111.37 79.30 10-530-502060 Long Term Disability 344.86 74.51 0.00 270.35 78.39 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 37,212.22 0.00 96,901.22 72.25 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 9.06 0.00 140.94 93.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 464.20 0.00 915.80 66.36 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 290.17 0.00 1,709.83 85.49 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,961.19 0.00 7,038.81 37.05 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,326.26 0.00 40,789.26 64.63 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 (04/14/2023 - 09:17 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-547020 Maintenance Agreements 672.02 353.00 281.18 37.84 5.63 E25 Repairs & Maintenance 672.02 353.00 281.18 37.84 5.63 10-530-550020 NRA-Residential 40,000.00 38,753.34 0.00 1,246.66 3.12 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 0.00 22,944.25 99.76 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 0.00 49,932.50 99.87 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 0.00 0.00 0.00 0.00 0.00 10-530-550067 HPF PBruhn Revitalization 0.00 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 42,022.53 0.00 106,677.47 71.74 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 347,980.98 102,378.21 281.18 245,321.59 70.4986 Grand Total -347,980.98 -102,378.21 -281.18 -245,321.59 0.705 530 Plan & Protect Svc-RedevGrant 347,980.98 102,378.21 281.18 245,321.59 70.50 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 (04/14/2023 - 09:17 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 74,366.69 0.00 120,513.15 61.84 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 5,249.49 0.00 9,658.82 64.79 10-532-502020 Group Health Insurance 39,644.71 14,865.46 0.00 24,779.25 62.50 10-532-502030 Retirement 24,944.62 9,518.94 0.00 15,425.68 61.84 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 76.51 0.00 162.17 67.94 10-532-502060 Long Term Disability 592.66 223.74 0.00 368.92 62.25 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 108,102.83 0.00 170,924.93 61.26 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 (04/14/2023 - 09:17 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 303.92 0.00 996.08 76.62 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 341.57 0.00 2,283.43 86.99 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 84,078.00 117,600.00 -78.00 -0.04 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 84,460.00 117,600.00 2,040.00 1.00 10-532-534010 Telephone 1,200.00 494.88 0.00 705.12 58.76 E20 Utilities 1,200.00 494.88 0.00 705.12 58.76 10-532-540060 Cemetery Maintenance 37,750.00 15,311.82 21,441.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 265.99 245.00 399.01 43.85 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 17,021.81 21,686.00 2,362.19 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 210,421.09 139,286.00 178,315.67 33.7705 Grand Total -528,022.76 -210,421.09 -139,286.00 -178,315.67 0.3377 532 Plan & Protect Svcs-Env Health 528,022.76 210,421.09 139,286.00 178,315.67 33.77 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 164,815.30 80,065.08 0.00 84,750.22 51.42 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 9,876.07 0.00 -9,876.07 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 6,753.49 0.00 7,384.83 52.23 10-533-502020 Group Health Insurance 30,239.78 10,417.26 0.00 19,822.52 65.55 10-533-502030 Retirement 21,096.27 8,266.71 0.00 12,829.56 60.81 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 71.33 0.00 132.48 65.00 10-533-502060 Long Term Disability 505.89 201.44 0.00 304.45 60.18 10-533-502070 Employee Assistance Prgm 65.52 23.01 0.00 42.51 64.88 E05 Personnel Services 253,322.27 117,931.77 0.00 135,390.50 53.45 10-533-511010 Advertising 100.00 104.88 0.00 -4.88 -4.88 10-533-511020 Postage 1,800.00 716.28 0.00 1,083.72 60.21 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 462.20 0.00 887.80 65.76 E10 Materials & Supplies 4,690.00 1,842.68 0.00 2,847.32 60.71 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 79.00 0.00 1,121.00 93.42 10-533-520080 Tuition Reimbursement 0.00 3,856.00 0.00 -3,856.00 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 10,000.00 6,957.80 0.00 3,042.20 30.42 10-533-522022 Demo 263,433.60 72,840.80 0.00 190,592.80 72.35 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 353,591.15 127,681.60 0.00 225,909.55 63.89 10-533-534010 Telephone 3,701.40 1,479.27 0.00 2,222.13 60.03 E20 Utilities 3,701.40 1,479.27 0.00 2,222.13 60.03 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 400.86 0.00 879.14 68.68 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 443.12 421.46 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 1,113.98 421.46 1,315.56 46.14 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 618,155.82 250,049.30 421.46 367,685.06 59.481 Grand Total -618,155.82 -250,049.30 -421.46 -367,685.06 0.5948 533 PPS - Prop MaintCode Enforce 618,155.82 250,049.30 421.46 367,685.06 59.48 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 128,908.27 0.00 176,599.49 57.81 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 5,059.70 0.00 -5,059.70 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 9,380.77 0.00 15,206.92 61.85 10-534-502020 Group Health Insurance 79,982.22 31,618.40 0.00 48,363.82 60.47 10-534-502030 Retirement 39,104.99 16,500.21 0.00 22,604.78 57.81 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 149.86 0.00 224.68 59.99 10-534-502060 Long Term Disability 929.35 396.03 0.00 533.32 57.39 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 196,830.69 0.00 274,421.13 58.23 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 129.18 0.00 970.82 88.26 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 732.89 0.00 3,382.11 82.19 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,663.05 0.00 336.95 6.74 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,197.05 0.00 2,302.95 30.71 10-534-534010 Telephone 3,060.00 1,128.52 0.00 1,931.48 63.12 E20 Utilities 3,060.00 1,128.52 0.00 1,931.48 63.12 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 546.03 450.73 -8.76 -0.89 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 976.03 450.73 1,251.24 46.72 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 204,865.18 450.73 283,288.91 57.9791 Grand Total -488,604.82 -204,865.18 -450.73 -283,288.91 0.5798 534 Plan & Protect Svcs-Bldg Regs 488,604.82 204,865.18 450.73 283,288.91 57.98 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 164,241.50 0.00 221,209.74 57.39 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 12,095.59 0.00 18,079.93 59.92 10-535-502020 Group Health Insurance 79,635.09 31,745.27 0.00 47,889.82 60.14 10-535-502030 Retirement 49,977.76 21,193.89 0.00 28,783.87 57.59 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 189.03 0.00 283.43 59.99 10-535-502060 Long Term Disability 1,177.64 501.38 0.00 676.26 57.43 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 235,844.08 0.00 324,667.87 57.92 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 1,023.74 0.00 4,976.26 82.94 10-535-517010 Operational Supplies 6,000.00 4,038.11 0.00 1,961.89 32.70 E10 Materials & Supplies 13,140.00 5,785.94 0.00 7,354.06 55.97 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 (04/14/2023 - 09:17 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 2,420.43 0.00 4,139.57 63.10 10-535-533010 Natural Gas 3,000.00 2,879.80 0.00 120.20 4.01 10-535-534010 Telephone 220.00 191.45 0.00 28.55 12.98 10-535-535010 Water 1,442.00 480.17 0.00 961.83 66.70 E20 Utilities 11,222.00 5,971.85 0.00 5,250.15 46.78 10-535-540010 Building & Grounds Maint.10,000.00 4,825.80 35.00 5,139.20 51.39 10-535-541010 Veh & Equip Parts Etc 393,400.00 116,676.88 15,567.13 261,155.99 66.38 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 5,641.70 0.00 3,358.30 37.31 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,777.54 0.00 10,473.46 60.71 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 134,021.65 15,886.32 280,843.03 65.20 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 382,004.42 15,886.32 620,084.21 60.9135 Grand Total -1,017,974.95 -382,004.42 -15,886.32 -620,084.21 0.6091 535 Public Works-Central Maintenan 1,017,974.95 382,004.42 15,886.32 620,084.21 60.91 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 99,891.77 0.00 136,042.89 57.66 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 7,632.57 0.00 10,416.43 57.71 10-540-502020 Group Health Insurance 20,506.66 8,455.45 0.00 12,051.21 58.77 10-540-502030 Retirement 30,199.64 12,786.09 0.00 17,413.55 57.66 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 116.44 0.00 173.65 59.86 10-540-502060 Long Term Disability 569.01 290.16 0.00 278.85 49.01 10-540-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 E05 Personnel Services 305,833.81 129,422.39 0.00 176,411.42 57.68 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 (04/14/2023 - 09:17 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 170.88 149.84 -15.72 -5.15 E25 Repairs & Maintenance 305.00 170.88 149.84 -15.72 -5.15 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 163,533.22 149.84 251,805.75 60.6047 Grand Total -415,488.81 -163,533.22 -149.84 -251,805.75 0.606 540 Public Works-Admin 415,488.81 163,533.22 149.84 251,805.75 60.60 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 358,639.49 0.00 501,538.55 58.31 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 26,255.45 0.00 39,578.77 60.12 10-541-502020 Group Health Insurance 132,614.06 56,128.35 0.00 76,485.71 57.68 10-541-502030 Retirement 110,153.99 45,182.95 0.00 64,971.04 58.98 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 417.86 0.00 637.23 60.40 10-541-502060 Long Term Disability 2,488.48 1,091.35 0.00 1,397.13 56.14 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 496,081.94 0.00 682,959.74 57.92 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 16.61 0.00 383.39 95.85 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 432.34 0.00 1,217.66 73.80 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 (04/14/2023 - 09:17 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 160.62 0.00 1,339.38 89.29 10-541-517010 Operational Supplies 2,000.00 1,397.17 0.00 602.83 30.14 E10 Materials & Supplies 7,350.00 2,314.21 0.00 5,035.79 68.51 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,545.00 0.00 955.00 38.20 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,337.00 0.00 2,663.00 38.04 10-541-534010 Telephone 500.00 187.04 0.00 312.96 62.59 E20 Utilities 500.00 187.04 0.00 312.96 62.59 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 8,022.96 506.53 2,135.51 20.02 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 9,632.96 506.53 4,025.51 28.42 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 512,553.15 506.53 694,997.00 57.5302 Grand Total -1,208,056.68 -512,553.15 -506.53 -694,997.00 0.5753 541 Public Works-Engineering 1,208,056.68 512,553.15 506.53 694,997.00 57.53 542 Public Works-Street 10-542-501020 Salaries 1,373,894.56 463,937.31 0.00 909,957.25 66.23 10-542-501024 Salaries-Stormwater 0.00 82,835.09 0.00 -82,835.09 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,718.40 0.00 1,281.60 25.63 10-542-501090 Overtime 30,000.00 7,341.88 0.00 22,658.12 75.53 10-542-501095 Overtime Straight Pay 500.00 1,276.68 0.00 -776.68 -155.34 10-542-502010 Social Security 109,348.68 41,165.52 0.00 68,183.16 62.35 10-542-502020 Group Health Insurance 304,688.92 107,057.48 0.00 197,631.44 64.86 10-542-502030 Retirement 180,402.50 69,626.64 0.00 110,775.86 61.40 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 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 626.17 0.00 1,058.05 62.82 10-542-502060 Long Term Disability 4,165.34 1,642.71 0.00 2,522.63 60.56 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 818,630.26 0.00 1,250,987.24 60.45 10-542-511010 Advertising 750.00 58.75 0.00 691.25 92.17 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 129,494.58 0.00 165,505.42 56.10 10-542-514030 Small Tools 9,000.00 8,143.91 0.00 856.09 9.51 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 129,310.78 0.00 95,689.22 42.53 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 6,274.48 0.00 225.52 3.47 E10 Materials & Supplies 542,600.00 274,519.64 0.00 268,080.36 49.41 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 5,758.47 0.00 1,921.53 25.02 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,500.00 10,193.25 0.00 4,306.75 29.70 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 16,428.72 0.00 7,271.28 30.68 10-542-531010 Electricity 24,364.00 10,277.31 0.00 14,086.69 57.82 10-542-531020 Street Lights 593,000.00 216,078.97 0.00 376,921.03 63.56 10-542-533010 Natural Gas 10,000.00 11,085.96 0.00 -1,085.96 -10.86 10-542-534010 Telephone 580.00 1,064.67 0.00 -484.67 -83.56 10-542-535010 Water 12,390.00 1,835.98 0.00 10,554.02 85.18 E20 Utilities 640,334.00 240,342.89 0.00 399,991.11 62.47 10-542-540010 Building & Grounds Maint.10,000.00 7,137.47 180.00 2,682.53 26.83 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 4,377.39 0.00 30,622.61 87.49 10-542-542030 Signs & Marking Paint 60,000.00 4,998.56 31,553.32 23,448.12 39.08 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 (04/14/2023 - 09:17 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 30,370.48 31,733.32 67,456.20 52.07 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,172.24 0.00 827.76 5.17 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 16,000.00 15,172.24 0.00 827.76 5.17 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,421,811.50 1,395,464.23 31,733.32 1,994,613.95 58.2912 Grand Total -3,421,811.50 -1,395,464.23 -31,733.32 -1,994,613.95 0.5829 542 Public Works-Street 3,421,811.50 1,395,464.23 31,733.32 1,994,613.95 58.29 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 (04/14/2023 - 09:17 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-599501 JCCVB Lost Revenue 175,000.00 0.00 0.00 175,000.00 100.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 925,000.00 0.00 0.00 925,000.00 100.00 10-990-540060 Cemetery Maintenance 30,000.00 0.00 0.00 30,000.00 100.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,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 540,917.60 31,305.75 0.00 509,611.85 94.21 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 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599505 PD Elevator Replacement 200,000.00 0.00 200,000.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 1,500,000.00 0.00 32,000.00 1,468,000.00 97.87 10-990-599508 High Street Viaduct 1,077,827.75 3,352.25 0.00 1,074,475.50 99.69 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 274,622.36 1,878.64 8.44 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E75 Capital Projects 8,701,449.16 347,270.50 274,213.83 8,079,964.83 92.86 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 347,270.50 274,213.83 9,004,964.83 93.544 Grand Total -9,626,449.16 -347,270.50 -274,213.83 -9,004,964.83 0.9354 990 Capital Projects 9,626,449.16 347,270.50 274,213.83 9,004,964.83 93.54 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-995-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-995-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-995-599511 United Cap City Soccer Complex 0.00 0.00 0.00 0.00 0.00 E65 Other Non-Operating Expenses 0.00 0.00 0.00 0.00 0.00 10-995-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-995-572020 Purchase of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-995-599502 Downtown Beautification-Match 0.00 0.00 0.00 0.00 0.00 10-995-599503 Organizational Review Study 0.00 0.00 0.00 0.00 0.00 10-995-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 60,187,135.38 16,899,944.77 981,157.68 42,306,032.93 70.29 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 60,187,135.38 16,899,944.77 981,157.68 42,306,032.93 70.2908 Grand Total -60,187,135.38 -16,899,944.77 -981,157.68 -42,306,032.93 0.7029 GL - Trial Balance by Acct Type and Full Acct Number (04/14/2023 - 09:17 AM)Page 42