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-05 Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 5/5/2023 10:50:02 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 32,625.00 0.00 33,300.00 50.51 10-110-501015 Salary-Prosecuting Attorney 34,999.92 17,499.96 0.00 17,499.96 50.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 3,169.94 0.00 13,428.46 80.90 10-110-502010 Social Security 8,990.53 3,923.36 0.00 5,067.17 56.36 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 57,289.85 0.00 69,295.59 54.74 10-110-511010 Advertising 0.00 79.75 0.00 -79.75 0.00 10-110-511020 Postage 100.00 15.99 0.00 84.01 84.01 10-110-512010 Printing 400.00 120.00 0.00 280.00 70.00 10-110-512020 Copies 96.00 0.04 0.00 95.96 99.96 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,018.05 0.00 1,012.95 49.87 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 (05/05/2023 - 10:50 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 67,698.21 61.90 67,835.17 50.0277 Grand Total -135,595.28 -67,698.21 -61.90 -67,835.17 0.5003 110 Mayor & Council 135,595.28 67,698.21 61.90 67,835.17 50.03 120 City Clerk 10-120-501020 Salaries 56,948.36 28,517.72 0.00 28,430.64 49.92 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,356.55 2,010.41 0.00 2,346.14 53.85 10-120-502020 Group Health Insurance 13,245.50 6,359.46 0.00 6,886.04 51.99 10-120-502030 Retirement 7,289.39 3,650.28 0.00 3,639.11 49.92 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 33.62 0.00 36.15 51.81 10-120-502060 Long Term Disability 174.26 89.73 0.00 84.53 48.51 10-120-502070 Employee Assistance Prgm 21.84 10.22 0.00 11.62 53.21 E05 Personnel Services 82,155.66 40,721.43 0.00 41,434.23 50.43 10-120-511020 Postage 200.00 153.94 0.00 46.06 23.03 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 192.17 0.00 107.83 35.94 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 410.70 0.00 289.30 41.33 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 10,251.36 0.00 8,328.43 44.83 E15 Contractual Services 19,254.79 10,497.45 0.00 8,757.34 45.48 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 52,994.47 61.90 59,729.08 52.9581 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -112,785.45 -52,994.47 -61.90 -59,729.08 0.5296 120 City Clerk 112,785.45 52,994.47 61.90 59,729.08 52.96 140 City Administrator 10-140-501020 Salaries 213,221.32 107,279.22 0.00 105,942.10 49.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 6,575.75 0.00 9,735.68 59.69 10-140-502020 Group Health Insurance 21,732.71 8,789.35 0.00 12,943.36 59.56 10-140-502030 Retirement 27,292.33 13,152.76 0.00 14,139.57 51.81 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 71.32 0.00 42.51 37.35 10-140-502060 Long Term Disability 374.04 249.78 0.00 124.26 33.22 10-140-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 279,290.56 136,339.86 0.00 142,950.70 51.18 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.97 0.00 134.03 89.35 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 283.96 0.00 394.78 58.16 E10 Materials & Supplies 1,603.74 592.18 0.00 1,011.56 63.08 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 330.00 0.00 370.00 52.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 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,632.09 0.00 767.91 32.00 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 300.00 63.38 420.10 -183.48 -61.16 E25 Repairs & Maintenance 300.00 63.38 420.10 -183.48 -61.16 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 138,627.51 420.10 144,546.69 50.9695 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -283,594.30 -138,627.51 -420.10 -144,546.69 0.5097 140 City Administrator 283,594.30 138,627.51 420.10 144,546.69 50.97 143 CDBG-CV Compass Health 10-143-501020 Salaries 14,000.00 1,671.27 0.00 12,328.73 88.06 10-143-502010 Social Security 0.00 112.81 0.00 -112.81 0.00 10-143-502020 Group Health Insurance 0.00 452.00 0.00 -452.00 0.00 10-143-502030 Retirement 0.00 213.93 0.00 -213.93 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.97 0.00 -1.97 0.00 10-143-502060 Long Term Disability 0.00 5.31 0.00 -5.31 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,457.29 0.00 11,542.71 82.45 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,457.29 0.00 111,542.71 97.8445 Grand Total -114,000.00 -2,457.29 0.00 -111,542.71 0.9784 143 CDBG-CV Compass Health 114,000.00 2,457.29 0.00 111,542.71 97.84 144 CDBG-DR 10-144-501020 Salaries 282,372.00 11,028.47 0.00 271,343.53 96.09 10-144-502010 Social Security 0.00 816.72 0.00 -816.72 0.00 10-144-502020 Group Health Insurance 0.00 2,086.73 0.00 -2,086.73 0.00 10-144-502030 Retirement 0.00 1,411.62 0.00 -1,411.62 0.00 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 0.00 13.24 0.00 -13.24 0.00 10-144-502060 Long Term Disability 0.00 35.77 0.00 -35.77 0.00 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 15,392.55 0.00 266,979.45 94.55 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 15,392.55 0.00 7,293,907.45 99.7894 Grand Total -7,309,300.00 -15,392.55 0.00 -7,293,907.45 0.9979 144 CDBG-DR 7,309,300.00 15,392.55 0.00 7,293,907.45 99.79 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 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 6,316.67 0.00 33,883.96 84.29 10-145-502010 Social Security 840.81 423.67 0.00 417.14 49.61 10-145-502020 Group Health Insurance 2,491.43 1,732.40 0.00 759.03 30.47 10-145-502030 Retirement 1,406.85 808.52 0.00 598.33 42.53 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 7.43 0.00 6.15 45.29 10-145-502060 Long Term Disability 33.34 19.59 0.00 13.75 41.24 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 9,316.62 0.00 35,683.38 79.30 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 9,316.62 0.00 1,990,683.38 99.5342 Grand Total -2,000,000.00 -9,316.62 0.00 -1,990,683.38 0.9953 145 CDBG-CV Cole Co EMS Station 2,000,000.00 9,316.62 0.00 1,990,683.38 99.53 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 9,710.28 17,664.88 0.00 -7,954.60 -81.92 10-146-502010 Social Security 742.84 1,198.96 0.00 -456.12 -61.40 10-146-502020 Group Health Insurance 2,201.13 4,773.08 0.00 -2,571.95 -116.85 10-146-502030 Retirement 1,242.92 2,261.10 0.00 -1,018.18 -81.92 10-146-502040 Workers Compensation 7.37 7.37 0.00 0.00 0.00 10-146-502050 Life Insurance 12.00 21.64 0.00 -9.64 -80.33 10-146-502060 Long Term Disability 29.46 57.97 0.00 -28.51 -96.78 10-146-502070 Employee Assistance Prgm 4.44 0.00 0.00 4.44 100.00 E05 Personnel Services 13,950.44 25,985.00 0.00 -12,034.56 -86.27 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 162.00 0.00 193.76 54.46 E15 Contractual Services 355.76 162.00 0.00 193.76 54.46 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 26,147.00 0.00 662,739.20 96.2045 Grand Total -688,886.20 -26,147.00 0.00 -662,739.20 0.962 146 HPF-P Bruhn Revitalization 688,886.20 26,147.00 0.00 662,739.20 96.20 147 CDBG-CV Transform Housing 10-147-501020 Salaries 28,471.38 3,745.86 0.00 24,725.52 86.84 10-147-502010 Social Security 576.14 249.83 0.00 326.31 56.64 10-147-502020 Group Health Insurance 1,707.17 989.55 0.00 717.62 42.04 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-147-502030 Retirement 964.00 479.49 0.00 484.51 50.26 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 4.34 0.00 4.96 53.33 10-147-502060 Long Term Disability 22.85 11.46 0.00 11.39 49.85 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 5,486.25 0.00 26,273.75 82.73 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 5,486.25 0.00 570,273.75 99.0471 Grand Total -575,760.00 -5,486.25 0.00 -570,273.75 0.9905 147 CDBG-CV Transform Housing 575,760.00 5,486.25 0.00 570,273.75 99.05 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 13,891.00 0.00 33,284.14 70.55 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 (05/05/2023 - 10:50 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502010 Social Security 3,608.91 989.20 0.00 2,619.71 72.59 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 3,067.75 0.00 7,625.92 71.31 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,778.07 0.00 4,260.37 70.55 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 17.06 0.00 41.22 70.73 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 45.00 0.00 98.12 68.56 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 19,839.23 0.00 47,935.70 70.73 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 20,341.00 0.00 119,659.00 85.47 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 54.00 0.00 39,946.00 99.87 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 333,530.00 0.00 624,937.02 65.20 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 (05/05/2023 - 10:50 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 353,884.77 0.00 674,177.18 65.5775 Grand Total -1,028,061.95 -353,884.77 0.00 -674,177.18 0.6558 149 Entitlement Grant 1,028,061.95 353,884.77 0.00 674,177.18 65.58 150 City Attorney 10-150-501020 Salaries 233,777.84 117,004.89 0.00 116,772.95 49.95 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 8,636.84 0.00 9,247.16 51.71 10-150-502020 Group Health Insurance 35,360.71 16,588.38 0.00 18,772.33 53.09 10-150-502030 Retirement 29,923.56 14,976.64 0.00 14,946.92 49.95 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 136.86 0.00 149.56 52.22 10-150-502060 Long Term Disability 607.87 352.05 0.00 255.82 42.08 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 157,957.13 0.00 160,179.58 50.35 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 107.27 0.00 492.73 82.12 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 10.59 0.00 -10.59 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 155.02 0.00 1,719.98 91.73 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 4,945.82 2,992.44 3,350.66 29.68 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,255.00 3,818.65 0.00 2,436.35 38.95 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 4,556.08 29.00 0.00 4,527.08 99.36 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 (05/05/2023 - 10:50 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 22,600.00 38,240.59 2,992.44 -18,633.03 -82.45 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 361.90 -52.80 -14.23 E25 Repairs & Maintenance 371.00 61.90 361.90 -52.80 -14.23 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 342,982.71 196,414.64 3,354.34 143,213.73 41.7554 Grand Total -342,982.71 -196,414.64 -3,354.34 -143,213.73 0.4176 150 City Attorney 342,982.71 196,414.64 3,354.34 143,213.73 41.76 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 17,499.96 0.00 17,499.96 50.00 10-160-501020 Salaries 124,730.18 63,503.33 0.00 61,226.85 49.09 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,818.80 0.00 4,181.20 59.73 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 6,308.12 0.00 6,523.23 50.84 10-160-502020 Group Health Insurance 25,616.32 11,771.17 0.00 13,845.15 54.05 10-160-502030 Retirement 16,093.46 8,142.11 0.00 7,951.35 49.41 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 73.45 0.00 79.55 51.99 10-160-502060 Long Term Disability 381.67 195.78 0.00 185.89 48.70 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 110,648.05 0.00 112,421.54 50.40 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 837.15 0.00 1,162.85 58.14 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 207.68 0.00 2,292.32 91.69 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 1,044.83 0.00 3,855.17 78.68 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 480.00 0.00 2,020.00 80.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 707.50 0.00 2,292.50 76.42 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 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 6,062.23 0.00 16,727.77 73.40 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 4,130.00 1,316.40 848.60 13.48 E25 Repairs & Maintenance 6,295.00 4,130.00 1,316.40 848.60 13.48 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 121,885.11 1,316.40 133,853.08 52.0718 Grand Total -257,054.59 -121,885.11 -1,316.40 -133,853.08 0.5207 160 Municipal Court 257,054.59 121,885.11 1,316.40 133,853.08 52.07 170 Human Resources 10-170-501020 Salaries 229,300.24 115,686.89 0.00 113,613.35 49.55 10-170-501050 Parttime(wo Benefits)13,000.00 8,803.08 0.00 4,196.92 32.28 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 9,363.71 0.00 9,179.91 49.50 10-170-502020 Group Health Insurance 25,708.58 12,204.32 0.00 13,504.26 52.53 10-170-502030 Retirement 29,363.23 14,830.57 0.00 14,532.66 49.49 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 134.48 0.00 145.82 52.02 10-170-502060 Long Term Disability 589.14 348.40 0.00 240.74 40.86 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 161,905.23 0.00 155,371.09 48.97 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 127.17 0.00 172.83 57.61 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 243.67 0.00 256.33 51.27 10-170-513010 Office Supplies 600.00 87.36 0.00 512.64 85.44 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 523.64 0.00 2,406.36 82.13 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 1,067.24 0.00 1,932.76 64.43 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 (05/05/2023 - 10:50 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 266.00 0.00 234.00 46.80 10-170-522020 Professional Services 11,600.00 9,554.30 0.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 11,180.56 0.00 9,856.44 46.85 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,416.15 420.10 31,902.36 60.49 E25 Repairs & Maintenance 52,738.61 20,416.15 420.10 31,902.36 60.49 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 197,200.82 420.10 199,536.25 50.2411 Grand Total -397,157.17 -197,200.82 -420.10 -199,536.25 0.5024 170 Human Resources 397,157.17 197,200.82 420.10 199,536.25 50.24 180 Finance Department 10-180-501020 Salaries 570,708.35 235,051.57 0.00 335,656.78 58.81 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 17,603.87 0.00 26,055.32 59.68 10-180-502020 Group Health Insurance 96,970.17 36,767.33 0.00 60,202.84 62.08 10-180-502030 Retirement 73,050.67 29,679.54 0.00 43,371.13 59.37 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 267.43 0.00 436.37 62.00 10-180-502060 Long Term Disability 1,743.45 708.20 0.00 1,035.25 59.38 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 320,776.37 0.00 466,792.87 59.27 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 10,000.00 4,580.67 0.00 5,419.33 54.19 10-180-511021 Mail Machine Cost 3,000.00 1,512.37 0.00 1,487.63 49.59 10-180-512010 Printing 3,000.00 834.80 0.00 2,165.20 72.17 10-180-512020 Copies 1,000.00 18.63 0.00 981.37 98.14 10-180-512021 Copy Machine Cost 190.00 -160.14 0.00 350.14 184.28 10-180-513010 Office Supplies 1,250.00 201.63 0.00 1,048.37 83.87 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 0.00 0.00 3,655.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 23,095.00 6,987.96 0.00 16,107.04 69.74 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 1,749.20 -129.20 -0.92 E25 Repairs & Maintenance 14,120.00 12,500.00 1,749.20 -129.20 -0.92 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 354,604.46 1,749.20 545,481.67 60.4857 Grand Total -901,835.33 -354,604.46 -1,749.20 -545,481.67 0.6049 180 Finance Department 901,835.33 354,604.46 1,749.20 545,481.67 60.49 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 79.48 0.00 4,120.52 98.11 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 399,178.69 34,638.40 0.00 364,540.29 91.32 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 8,732.32 0.00 11,267.68 56.34 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 8,732.32 0.00 55,386.85 86.38 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 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 70,394.27 0.00 -45,394.27 -181.58 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 31,194.00 31,194.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 557,809.35 31,194.00 259,962.15 30.62 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 3,102.27 0.00 4,147.73 57.21 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 17,813.26 0.00 27,636.74 60.81 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,244.03 0.00 2,755.97 68.90 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,072.00 0.00 988.00 47.96 E25 Repairs & Maintenance 71,060.00 53,695.45 0.00 17,364.55 24.44 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 451,560.76 224,855.08 57,804.00 168,901.68 37.40 E30 Other Operating Expenses 464,360.76 237,054.60 57,804.00 169,502.16 36.50 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 -22,312.07 0.00 22,312.07 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 -22,312.07 0.00 22,312.07 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 887,431.31 88,998.00 916,704.81 48.4226 Grand Total -1,893,134.12 -887,431.31 -88,998.00 -916,704.81 0.4842 185 Non-Departmental 1,893,134.12 887,431.31 88,998.00 916,704.81 48.42 190 Information Technology Svcs 10-190-501020 Salaries 606,371.81 300,303.19 0.00 306,068.62 50.48 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 22,330.81 0.00 24,094.88 51.90 10-190-502020 Group Health Insurance 96,814.24 38,073.27 0.00 58,740.97 60.67 10-190-502030 Retirement 77,679.59 33,316.33 0.00 44,363.26 57.11 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 326.48 0.00 417.71 56.13 10-190-502060 Long Term Disability 1,815.32 888.16 0.00 927.16 51.07 10-190-502070 Employee Assistance Prgm 207.48 97.18 0.00 110.30 53.16 E05 Personnel Services 831,916.53 396,693.63 0.00 435,222.90 52.32 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 298.48 0.00 201.52 40.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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-517010 Operational Supplies 2,000.00 2,015.33 0.00 -15.33 -0.77 E10 Materials & Supplies 2,660.00 2,374.99 0.00 285.01 10.71 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 139.00 0.00 11.00 7.33 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 1,499.06 0.00 7,000.94 82.36 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 11,561.72 0.00 11,438.28 49.73 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 23,556.77 0.00 21,493.23 47.71 10-190-534010 Telephone 96,000.00 36,627.64 0.00 59,372.36 61.85 E20 Utilities 96,000.00 36,627.64 0.00 59,372.36 61.85 10-190-545010 Software License\maint 182,000.00 172,024.29 0.00 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 416.40 11,771.60 53.51 10-190-547025 Coun Chamber MediaEquip Repr 0.00 204.85 0.00 -204.85 0.00 E25 Repairs & Maintenance 204,000.00 182,041.14 416.40 21,542.46 10.56 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 641,294.17 416.40 537,915.96 45.6005 Grand Total -1,179,626.53 -641,294.17 -416.40 -537,915.96 0.456 190 Information Technology Svcs 1,179,626.53 641,294.17 416.40 537,915.96 45.60 300 Police Department 10-300-501020 Salaries 5,457,482.75 2,458,833.56 0.00 2,998,649.19 54.95 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 15,810.73 0.00 30,047.28 65.52 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 5,237.30 0.00 -237.30 -4.75 10-300-501090 Overtime 294,142.77 201,348.38 0.00 92,794.39 31.55 10-300-501095 Overtime Straight Pay 13,275.00 8,781.82 0.00 4,493.18 33.85 10-300-502010 Social Security 444,750.67 200,482.55 0.00 244,268.12 54.92 10-300-502020 Group Health Insurance 960,547.52 419,219.97 0.00 541,327.55 56.36 10-300-502030 Retirement 1,009,334.34 468,050.78 0.00 541,283.56 53.63 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,825.40 0.00 3,716.88 56.81 10-300-502060 Long Term Disability 15,894.91 7,507.18 0.00 8,387.73 52.77 10-300-502070 Employee Assistance Prgm 1,960.14 925.80 0.00 1,034.34 52.77 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-503010 Awards Program 2,500.00 0.00 687.00 1,813.00 72.52 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 8,541,659.27 3,930,401.94 687.00 4,610,570.33 53.98 10-300-511010 Advertising 5,665.00 3,762.25 0.00 1,902.75 33.59 10-300-511020 Postage 1,395.00 757.59 0.00 637.41 45.69 10-300-512010 Printing 5,952.00 2,728.40 0.00 3,223.60 54.16 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,215.21 0.00 5,455.29 34.81 10-300-514010 Gas 188,862.00 75,208.45 0.00 113,653.55 60.18 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,961.52 7,221.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 22,132.55 3,134.00 21,011.45 45.40 E10 Materials & Supplies 344,272.75 183,098.35 10,355.00 150,819.40 43.81 10-300-520030 Dues And Publications 5,400.00 2,564.40 0.00 2,835.60 52.51 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 49,340.65 0.00 26,659.35 35.08 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 375.74 0.00 911.26 70.80 10-300-521040 Medical Claimsservices 6,510.00 6,252.00 0.00 258.00 3.96 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 91,695.79 0.00 69,008.21 42.94 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 12,714.25 0.00 11,386.75 47.25 10-300-535010 Water 3,348.00 1,676.13 0.00 1,671.87 49.94 E20 Utilities 73,205.00 30,977.76 0.00 42,227.24 57.68 10-300-540010 Building & Grounds Maint.37,200.00 79,384.16 0.00 -42,184.16 -113.40 10-300-541030 Vehicle Wash 9,752.00 6,510.00 0.00 3,242.00 33.24 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-544010 K-9 Operations 16,740.00 9,917.96 880.35 5,941.69 35.49 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 11,478.30 472.50 36,969.20 75.57 10-300-546020 Uniform Cleaning 23,715.00 14,236.71 0.00 9,478.29 39.97 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 33,968.54 9,763.80 12,515.66 22.25 10-300-547030 Radio Maintenance 8,025.00 96.88 0.00 7,928.12 98.79 E25 Repairs & Maintenance 320,964.00 231,492.84 11,116.65 78,354.51 24.41 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 89,250.00 0.00 -42,500.00 -90.91 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 94,343.80 41,739.00 188,218.60 58.04 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,765,106.42 4,562,010.48 63,897.65 5,139,198.29 52.6282 Grand Total -9,765,106.42 -4,562,010.48 -63,897.65 -5,139,198.29 0.5263 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 300 Police Department 9,765,106.42 4,562,010.48 63,897.65 5,139,198.29 52.63 310 School Resource Officer 10-310-501020 Salaries 489,893.97 197,110.18 0.00 292,783.79 59.76 10-310-501030 Holiday Pay 20,720.19 0.00 0.00 20,720.19 100.00 10-310-501090 Overtime 45,106.00 45,567.94 0.00 -461.94 -1.02 10-310-501095 Overtime Straight Pay 1,311.00 1,668.22 0.00 -357.22 -27.25 10-310-502010 Social Security 42,612.88 17,616.04 0.00 24,996.84 58.66 10-310-502020 Group Health Insurance 89,715.43 37,296.24 0.00 52,419.19 58.43 10-310-502030 Retirement 100,265.61 43,982.36 0.00 56,283.25 56.13 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 223.56 0.00 379.87 62.95 10-310-502060 Long Term Disability 1,498.63 596.35 0.00 902.28 60.21 10-310-502070 Employee Assistance Prgm 174.72 81.84 0.00 92.88 53.16 E05 Personnel Services 798,454.72 350,695.59 0.00 447,759.13 56.08 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 147.11 959.20 4,867.69 81.48 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 690.00 416.40 -746.40 -207.33 E25 Repairs & Maintenance 6,334.00 837.11 1,375.60 4,121.29 65.07 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 351,532.70 1,375.60 478,870.42 57.5719 Grand Total -831,778.72 -351,532.70 -1,375.60 -478,870.42 0.5757 310 School Resource Officer 831,778.72 351,532.70 1,375.60 478,870.42 57.57 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 63,319.86 0.00 64,287.10 50.38 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 17,776.09 0.00 11,642.13 39.57 10-320-501095 Overtime Straight Pay 0.00 662.87 0.00 -662.87 0.00 10-320-502010 Social Security 11,037.18 5,944.60 0.00 5,092.58 46.14 10-320-502020 Group Health Insurance 20,462.81 9,783.22 0.00 10,679.59 52.19 10-320-502030 Retirement 25,969.83 14,716.58 0.00 11,253.25 43.33 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502050 Life Insurance 155.45 71.39 0.00 84.06 54.08 10-320-502060 Long Term Disability 384.75 189.37 0.00 195.38 50.78 10-320-502070 Employee Assistance Prgm 43.68 20.46 0.00 23.22 53.16 E05 Personnel Services 222,402.83 114,488.83 0.00 107,914.00 48.52 10-320-514010 Gas 11,848.00 4,598.06 0.00 7,249.94 61.19 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 11,558.06 0.00 20,590.22 64.05 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 5,700.00 0.00 11,800.00 67.43 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 5,700.00 0.00 11,800.00 67.43 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 131,746.89 0.00 140,304.22 51.5727 Grand Total -272,051.11 -131,746.89 0.00 -140,304.22 0.5157 320 M.U.S.T.A.N.G.272,051.11 131,746.89 0.00 140,304.22 51.57 330 Animal Control 10-330-501020 Salaries 370,091.13 155,446.12 0.00 214,645.01 58.00 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 4,305.38 0.00 4,294.62 49.94 10-330-501090 Overtime 2,000.00 8,059.69 0.00 -6,059.69 -302.98 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 11,474.30 0.00 17,648.57 60.60 10-330-502020 Group Health Insurance 93,298.71 38,270.75 0.00 55,027.96 58.98 10-330-502030 Retirement 48,728.46 21,225.81 0.00 27,502.65 56.44 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 456.55 174.23 0.00 282.32 61.84 10-330-502060 Long Term Disability 1,117.06 478.32 0.00 638.74 57.18 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 558,270.58 244,197.52 0.00 314,073.06 56.26 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 48.14 0.00 103.86 68.33 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,875.20 0.00 7,840.80 49.89 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 60.00 0.00 630.00 91.30 10-330-522020 Professional Services 4,830.00 1,077.20 0.00 3,752.80 77.70 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,829.09 0.00 6,409.91 48.42 10-330-531010 Electricity 22,789.00 11,920.00 0.00 10,869.00 47.69 10-330-533010 Natural Gas 21,000.00 12,167.61 0.00 8,832.39 42.06 10-330-534010 Telephone 810.00 409.92 0.00 400.08 49.39 10-330-535010 Water 3,800.00 1,434.42 0.00 2,365.58 62.25 E20 Utilities 48,399.00 25,931.95 0.00 22,467.05 46.42 10-330-540010 Building & Grounds Maint.15,000.00 16,060.57 0.00 -1,060.57 -7.07 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 28,134.36 0.00 21,155.64 42.92 10-330-544050 Animal Food 6,603.00 2,273.75 0.00 4,329.25 65.56 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 1,397.71 0.00 627.29 30.98 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 416.40 -56.40 -15.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 79,074.00 53,271.59 416.40 25,386.01 32.10 10-330-572010 Purchase of Vehicles 42,695.00 1,600.00 41,095.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 42,695.00 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 339,705.35 41,511.40 376,176.83 49.6673 Grand Total -757,393.58 -339,705.35 -41,511.40 -376,176.83 0.4967 330 Animal Control 757,393.58 339,705.35 41,511.40 376,176.83 49.67 390 9-1-1 Police 10-390-501020 Salaries 1,081,152.51 420,938.84 0.00 660,213.67 61.07 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 8,741.14 0.00 -8,741.14 0.00 10-390-501090 Overtime 22,814.00 58,965.89 0.00 -36,151.89 -158.46 10-390-501095 Overtime Straight Pay 1,850.00 1,880.43 0.00 -30.43 -1.64 10-390-502010 Social Security 87,556.95 37,189.35 0.00 50,367.60 57.53 10-390-502020 Group Health Insurance 223,648.25 77,580.08 0.00 146,068.17 65.31 10-390-502030 Retirement 152,546.30 54,594.66 0.00 97,951.64 64.21 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 468.02 0.00 864.92 64.89 10-390-502060 Long Term Disability 3,302.13 1,241.71 0.00 2,060.42 62.40 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 679,438.34 0.00 936,683.93 57.96 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,728.11 0.00 2,071.89 30.47 E10 Materials & Supplies 8,200.00 4,728.11 0.00 3,471.89 42.34 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,342.70 0.00 1,957.30 45.52 10-390-523010 Equipment Rentlease 99,260.00 33,530.70 0.00 65,729.30 66.22 E15 Contractual Services 109,768.00 37,215.65 0.00 72,552.35 66.10 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 653.64 0.00 183.36 21.91 E20 Utilities 12,276.00 4,709.99 0.00 7,566.01 61.63 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 5,580.00 83.56 0.00 5,496.44 98.50 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 6,554.97 0.00 -2,354.97 -56.07 10-390-547020 Maintenance Agreements 75,000.00 68,653.40 593.52 5,753.08 7.67 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 123,844.78 593.52 19,167.70 13.35 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 849,936.87 593.52 1,039,441.88 54.9977 Grand Total -1,889,972.27 -849,936.87 -593.52 -1,039,441.88 0.55 390 9-1-1 Police 1,889,972.27 849,936.87 593.52 1,039,441.88 55.00 400 Fire Department 10-400-501020 Salaries 4,989,033.59 2,031,116.10 0.00 2,957,917.49 59.29 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 16,120.73 0.00 21,879.27 57.58 10-400-501090 Overtime 45,000.00 30,649.39 0.00 14,350.61 31.89 10-400-501095 Overtime Straight Pay 40,000.00 29,280.15 0.00 10,719.85 26.80 10-400-502010 Social Security 69,573.39 32,379.00 0.00 37,194.39 53.46 10-400-502020 Group Health Insurance 871,448.91 409,114.77 0.00 462,334.14 53.05 10-400-502030 Retirement 2,292,378.67 1,111,762.59 0.00 1,180,616.08 51.50 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 2,378.88 0.00 2,689.70 53.07 10-400-502060 Long Term Disability 12,419.68 6,286.12 0.00 6,133.56 49.39 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,993,777.04 0.00 4,867,436.53 54.93 10-400-511010 Advertising 300.00 96.00 0.00 204.00 68.00 10-400-511020 Postage 120.00 168.20 0.00 -48.20 -40.17 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 474.50 0.00 920.50 65.99 10-400-514010 Gas 61,175.00 32,911.82 0.00 28,263.18 46.20 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,537.08 0.00 11,462.92 63.68 E10 Materials & Supplies 90,740.00 45,323.20 0.00 45,416.80 50.05 10-400-520030 Dues And Publications 3,400.00 2,225.55 0.00 1,174.45 34.54 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,000.00 22,562.21 0.00 9,437.79 29.49 10-400-520080 Tuition Reimbursement 7,500.00 5,616.00 0.00 1,884.00 25.12 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,655.00 0.00 35,345.00 88.36 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 1,931.56 0.00 3,068.44 61.37 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 37,815.32 0.00 55,777.68 59.60 10-400-531010 Electricity 35,000.00 14,322.69 0.00 20,677.31 59.08 10-400-533010 Natural Gas 17,670.00 19,209.97 0.00 -1,539.97 -8.72 10-400-534010 Telephone 25,984.20 12,432.29 0.00 13,551.91 52.15 10-400-535010 Water 12,000.00 5,358.22 0.00 6,641.78 55.35 E20 Utilities 90,654.20 51,323.17 0.00 39,331.03 43.39 10-400-540010 Building & Grounds Maint.90,000.00 22,531.51 525.00 66,943.49 74.38 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 95,000.00 32,023.69 0.00 62,976.31 66.29 10-400-546020 Uniform Cleaning 500.00 101.95 0.00 398.05 79.61 10-400-547010 Equipment Maintenance 20,000.00 8,953.86 0.00 11,046.14 55.23 10-400-547020 Maintenance Agreements 39,487.50 19,760.74 1,302.56 18,424.20 46.66 10-400-547030 Radio Maintenance 20,925.00 4,445.25 0.00 16,479.75 78.76 E25 Repairs & Maintenance 265,912.50 87,817.00 1,827.56 176,267.94 66.29 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 17,678.42 124,203.40 18,017.36 11.27 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 69,888.50 141,437.82 17,528.86 7.66 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,630,968.45 4,285,944.23 143,265.38 5,201,758.84 54.0108 Grand Total -9,630,968.45 -4,285,944.23 -143,265.38 -5,201,758.84 0.5401 400 Fire Department 9,630,968.45 4,285,944.23 143,265.38 5,201,758.84 54.01 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,283.21 0.00 416.79 24.52 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,283.21 0.00 416.79 24.52 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,700.00 1,283.21 0.00 416.79 24.5171 Grand Total -1,700.00 -1,283.21 0.00 -416.79 0.2452 401 Fire Museum 1,700.00 1,283.21 0.00 416.79 24.52 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 240,205.46 142,720.18 0.00 97,485.28 40.58 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 10,532.98 0.00 7,842.74 42.68 10-520-502020 Group Health Insurance 52,232.32 23,035.58 0.00 29,196.74 55.90 10-520-502030 Retirement 30,746.30 15,842.91 0.00 14,903.39 48.47 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 130.27 0.00 165.94 56.02 10-520-502060 Long Term Disability 636.77 333.58 0.00 303.19 47.61 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 192,823.08 0.00 149,953.96 43.75 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 25.17 0.00 49.83 66.44 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 5,360.44 0.00 7,614.56 58.69 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 717.30 0.00 -217.30 -43.46 E10 Materials & Supplies 14,500.00 7,383.21 0.00 7,116.79 49.08 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 1,072.20 -2,718.72 -9.35 E25 Repairs & Maintenance 29,089.01 30,735.53 1,072.20 -2,718.72 -9.35 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 (05/05/2023 - 10:50 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 236,116.33 1,072.20 155,177.52 39.5492 Grand Total -392,366.05 -236,116.33 -1,072.20 -155,177.52 0.3955 520 Plan & Protect Svcs-Admin 392,366.05 236,116.33 1,072.20 155,177.52 39.55 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,408.78 49,492.01 0.00 1,916.77 3.73 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,694.19 0.00 238.58 6.07 10-521-502020 Group Health Insurance 9,239.72 8,330.51 0.00 909.21 9.84 10-521-502030 Retirement 6,580.32 6,334.82 0.00 245.50 3.73 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 57.76 0.00 4.66 7.47 10-521-502060 Long Term Disability 156.03 153.06 0.00 2.97 1.90 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 68,248.32 0.00 3,305.36 4.62 10-521-511010 Advertising 3,336.00 1,883.20 0.00 1,452.80 43.55 10-521-511020 Postage 500.00 205.88 0.00 294.12 58.82 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 349.53 0.00 1,150.47 76.70 E10 Materials & Supplies 6,336.00 2,713.64 0.00 3,622.36 57.17 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 (05/05/2023 - 10:50 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 72,211.48 546.74 21,122.46 22.4993 Grand Total -93,880.68 -72,211.48 -546.74 -21,122.46 0.225 521 Plan & Protect Svcs-Planning 93,880.68 72,211.48 546.74 21,122.46 22.50 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 130,387.94 38,637.02 0.00 91,750.92 70.37 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,974.68 2,918.86 0.00 7,055.82 70.74 10-522-502020 Group Health Insurance 20,902.54 5,437.91 0.00 15,464.63 73.98 10-522-502030 Retirement 16,689.66 4,945.70 0.00 11,743.96 70.37 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 45.18 0.00 115.86 71.94 10-522-502060 Long Term Disability 397.13 119.76 0.00 277.37 69.84 10-522-502070 Employee Assistance Prgm 50.23 23.52 0.00 26.71 53.18 E05 Personnel Services 178,665.77 52,230.50 0.00 126,435.27 70.77 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 (05/05/2023 - 10:50 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 77,765.93 29,582.48 171,717.36 61.5329 Grand Total -279,065.77 -77,765.93 -29,582.48 -171,717.36 0.6153 522 Plan & Protect Svcs-MPO 279,065.77 77,765.93 29,582.48 171,717.36 61.53 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 84,475.28 27,685.79 0.00 56,789.49 67.23 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,044.81 0.00 6,651.38 76.49 10-530-502020 Group Health Insurance 25,767.93 4,541.19 0.00 21,226.74 82.38 10-530-502030 Retirement 14,550.48 3,543.70 0.00 11,006.78 75.65 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 29.77 0.00 110.67 78.80 10-530-502060 Long Term Disability 344.86 76.38 0.00 268.48 77.85 10-530-502070 Employee Assistance Prgm 51.96 5.11 0.00 46.85 90.17 E05 Personnel Services 134,113.44 38,014.62 0.00 96,098.82 71.65 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 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,807.34 0.00 1,192.66 2.98 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,076.53 0.00 106,623.47 71.70 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 347,980.98 103,234.61 281.18 244,465.19 70.2525 Grand Total -347,980.98 -103,234.61 -281.18 -244,465.19 0.7025 530 Plan & Protect Svc-RedevGrant 347,980.98 103,234.61 281.18 244,465.19 70.25 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 (05/05/2023 - 10:50 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 84,856.30 0.00 110,023.54 56.46 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,972.06 0.00 8,936.25 59.94 10-532-502020 Group Health Insurance 39,644.71 17,460.97 0.00 22,183.74 55.96 10-532-502030 Retirement 24,944.62 10,861.60 0.00 14,083.02 56.46 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 86.51 0.00 152.17 63.75 10-532-502060 Long Term Disability 592.66 257.36 0.00 335.30 56.58 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 123,296.80 0.00 155,730.96 55.81 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 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 618.60 0.00 581.40 48.45 E20 Utilities 1,200.00 618.60 0.00 581.40 48.45 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 298.42 0.00 781.58 72.37 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 265.99 961.40 -317.39 -34.88 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 17,160.23 22,402.40 1,507.37 3.67 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 528,022.76 225,877.20 140,002.40 162,143.16 30.7076 Grand Total -528,022.76 -225,877.20 -140,002.40 -162,143.16 0.3071 532 Plan & Protect Svcs-Env Health 528,022.76 225,877.20 140,002.40 162,143.16 30.71 533 PPS - Prop MaintCode Enforce GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-501020 Salaries 164,815.30 94,950.82 0.00 69,864.48 42.39 10-533-501050 Parttime(wo Benefits)20,000.00 1,740.30 0.00 18,259.70 91.30 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 8,018.89 0.00 6,119.43 43.28 10-533-502020 Group Health Insurance 30,239.78 12,539.78 0.00 17,700.00 58.53 10-533-502030 Retirement 21,096.27 9,904.78 0.00 11,191.49 53.05 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 87.52 0.00 116.29 57.06 10-533-502060 Long Term Disability 505.89 245.29 0.00 260.60 51.51 10-533-502070 Employee Assistance Prgm 65.52 23.01 0.00 42.51 64.88 E05 Personnel Services 253,322.27 139,643.84 0.00 113,678.43 44.88 10-533-511010 Advertising 100.00 104.88 0.00 -4.88 -4.88 10-533-511020 Postage 1,800.00 901.80 0.00 898.20 49.90 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-533-512020 Copies 0.00 0.04 0.00 -0.04 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 601.70 0.00 748.30 55.43 E10 Materials & Supplies 4,690.00 2,167.74 0.00 2,522.26 53.78 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 99.00 0.00 1,101.00 91.75 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 7,092.80 0.00 2,907.20 29.07 10-533-522022 Demo 263,433.60 82,621.89 0.00 180,811.71 68.64 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 137,617.69 0.00 215,973.46 61.08 10-533-534010 Telephone 3,701.40 1,833.38 0.00 1,868.02 50.47 E20 Utilities 3,701.40 1,833.38 0.00 1,868.02 50.47 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 837.86 -9.98 -0.79 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 1,113.98 837.86 899.16 31.54 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 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 282,376.63 837.86 334,941.33 54.184 Grand Total -618,155.82 -282,376.63 -837.86 -334,941.33 0.5418 533 PPS - Prop MaintCode Enforce 618,155.82 282,376.63 837.86 334,941.33 54.18 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 305,507.76 153,253.86 0.00 152,253.90 49.84 10-534-501050 Parttime(wo Benefits)15,900.00 858.31 0.00 15,041.69 94.60 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 11,138.40 0.00 13,449.29 54.70 10-534-502020 Group Health Insurance 79,982.22 38,199.80 0.00 41,782.42 52.24 10-534-502030 Retirement 39,104.99 19,616.43 0.00 19,488.56 49.84 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 180.46 0.00 194.08 51.82 10-534-502060 Long Term Disability 929.35 478.77 0.00 450.58 48.48 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 233,603.18 0.00 237,648.64 50.43 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 147.78 0.00 952.22 86.57 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 751.49 0.00 3,363.51 81.74 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,411.10 0.00 1,648.90 53.89 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 3,060.00 1,411.10 0.00 1,648.90 53.89 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 5.00 0.00 15.00 75.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 981.03 450.73 1,246.24 46.54 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 241,943.85 450.73 246,210.24 50.3905 Grand Total -488,604.82 -241,943.85 -450.73 -246,210.24 0.5039 534 Plan & Protect Svcs-Bldg Regs 488,604.82 241,943.85 450.73 246,210.24 50.39 535 Public Works-Central Maintenan 10-535-501020 Salaries 385,451.24 196,546.90 0.00 188,904.34 49.01 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,352.35 0.00 3,147.65 69.95 10-535-501095 Overtime Straight Pay 500.00 78.28 0.00 421.72 84.34 10-535-502010 Social Security 30,175.52 14,451.96 0.00 15,723.56 52.11 10-535-502020 Group Health Insurance 79,635.09 38,336.09 0.00 41,299.00 51.86 10-535-502030 Retirement 49,977.76 25,341.04 0.00 24,636.72 49.30 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 227.63 0.00 244.83 51.82 10-535-502060 Long Term Disability 1,177.64 606.24 0.00 571.40 48.52 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 281,481.45 0.00 279,030.50 49.78 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,308.07 0.00 1,691.93 28.20 E10 Materials & Supplies 13,140.00 6,055.90 0.00 7,084.10 53.91 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,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 240.28 0.00 -20.28 -9.22 10-535-535010 Water 1,442.00 589.87 0.00 852.13 59.09 E20 Utilities 11,222.00 6,130.38 0.00 5,091.62 45.37 10-535-540010 Building & Grounds Maint.10,000.00 5,023.30 35.00 4,941.70 49.42 10-535-541010 Veh & Equip Parts Etc 393,400.00 145,645.81 15,567.13 232,187.06 59.02 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 6,098.38 0.00 2,901.62 32.24 10-535-547010 Equipment Maintenance 1,000.00 194.46 189.46 616.08 61.61 10-535-547020 Maintenance Agreements 17,251.00 6,892.53 416.40 9,942.07 57.63 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 163,854.48 16,207.99 250,688.53 58.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 457,903.11 16,207.99 543,863.85 53.4261 Grand Total -1,017,974.95 -457,903.11 -16,207.99 -543,863.85 0.5343 535 Public Works-Central Maintenan 1,017,974.95 457,903.11 16,207.99 543,863.85 53.43 540 Public Works-Admin 10-540-501020 Salaries 235,934.66 130,372.25 0.00 105,562.41 44.74 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 9,960.15 0.00 8,088.85 44.82 10-540-502020 Group Health Insurance 20,506.66 9,805.56 0.00 10,701.10 52.18 10-540-502030 Retirement 30,199.64 15,429.17 0.00 14,770.47 48.91 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 137.09 0.00 153.00 52.74 10-540-502060 Long Term Disability 569.01 345.95 0.00 223.06 39.20 10-540-502070 Employee Assistance Prgm 65.52 30.68 0.00 34.84 53.17 E05 Personnel Services 305,833.81 166,300.08 0.00 139,533.73 45.62 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 27.82 0.00 972.18 97.22 10-540-514010 Gas 104,350.00 41,219.02 0.00 63,130.98 60.50 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 79.99 0.00 220.01 73.34 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 106,350.00 41,329.23 0.00 65,020.77 61.14 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 60.50 0.00 139.50 69.75 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,000.00 744.90 0.00 2,255.10 75.17 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 208,545.09 149.84 206,793.88 49.7712 Grand Total -415,488.81 -208,545.09 -149.84 -206,793.88 0.4977 540 Public Works-Admin 415,488.81 208,545.09 149.84 206,793.88 49.77 541 Public Works-Engineering 10-541-501020 Salaries 860,178.04 426,518.10 0.00 433,659.94 50.42 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,456.33 0.00 -2,056.33 -514.08 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 31,188.22 0.00 34,646.00 52.63 10-541-502020 Group Health Insurance 132,614.06 67,881.73 0.00 64,732.33 48.81 10-541-502030 Retirement 110,153.99 53,905.74 0.00 56,248.25 51.06 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 503.16 0.00 551.93 52.31 10-541-502060 Long Term Disability 2,488.48 1,322.11 0.00 1,166.37 46.87 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 589,953.87 0.00 589,087.81 49.96 10-541-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-541-511020 Postage 400.00 26.99 0.00 373.01 93.25 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 458.23 0.00 1,191.77 72.23 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 266.04 0.00 733.96 73.40 10-541-515080 Surveying Supplies 1,500.00 156.75 0.00 1,343.25 89.55 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 2,858.42 0.00 4,491.58 61.11 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 228.28 0.00 271.72 54.34 E20 Utilities 500.00 228.28 0.00 271.72 54.34 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 1,222.93 1,419.11 13.31 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 9,632.96 1,222.93 3,309.11 23.36 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 607,010.53 1,222.93 599,823.22 49.6519 Grand Total -1,208,056.68 -607,010.53 -1,222.93 -599,823.22 0.4965 541 Public Works-Engineering 1,208,056.68 607,010.53 1,222.93 599,823.22 49.65 542 Public Works-Street 10-542-501020 Salaries 1,373,894.56 554,796.29 0.00 819,098.27 59.62 10-542-501024 Salaries-Stormwater 0.00 98,079.63 0.00 -98,079.63 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 5,120.45 0.00 -120.45 -2.41 10-542-501090 Overtime 30,000.00 7,756.74 0.00 22,243.26 74.14 10-542-501095 Overtime Straight Pay 500.00 1,367.30 0.00 -867.30 -173.46 10-542-502010 Social Security 109,348.68 49,093.49 0.00 60,255.19 55.10 10-542-502020 Group Health Insurance 304,688.92 129,862.39 0.00 174,826.53 57.38 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502030 Retirement 180,402.50 82,815.03 0.00 97,587.47 54.09 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 757.54 0.00 926.68 55.02 10-542-502060 Long Term Disability 4,165.34 1,996.93 0.00 2,168.41 52.06 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 971,048.17 0.00 1,098,569.33 53.08 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,612.30 0.00 387.70 4.31 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 147,744.88 0.00 77,255.12 34.34 10-542-515040 First Aid Supplies 500.00 161.22 0.00 338.78 67.76 10-542-515060 Weed Control 2,000.00 1,048.92 0.00 951.08 47.55 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,959.27 0.00 -459.27 -7.07 E10 Materials & Supplies 542,600.00 295,155.84 0.00 247,444.16 45.60 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 7,509.50 0.00 170.50 2.22 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 18,179.75 0.00 5,520.25 23.29 10-542-531010 Electricity 24,364.00 11,394.21 0.00 12,969.79 53.23 10-542-531020 Street Lights 593,000.00 266,837.42 0.00 326,162.58 55.00 10-542-533010 Natural Gas 10,000.00 11,717.78 0.00 -1,717.78 -17.18 10-542-534010 Telephone 580.00 1,322.27 0.00 -742.27 -127.98 10-542-535010 Water 12,390.00 2,076.51 0.00 10,313.49 83.24 E20 Utilities 640,334.00 293,348.19 0.00 346,985.81 54.19 10-542-540010 Building & Grounds Maint.10,000.00 7,596.13 180.00 2,223.87 22.24 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 8,687.41 0.00 26,312.59 75.18 10-542-542030 Signs & Marking Paint 60,000.00 10,042.95 29,943.52 20,013.53 33.36 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-547020 Maintenance Agreements 360.00 0.00 416.40 -56.40 -15.67 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 40,183.55 30,539.92 58,836.53 45.41 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,633,087.74 30,539.92 1,758,183.84 51.3817 Grand Total -3,421,811.50 -1,633,087.74 -30,539.92 -1,758,183.84 0.5138 542 Public Works-Street 3,421,811.50 1,633,087.74 30,539.92 1,758,183.84 51.38 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 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 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 44,117.29 31,149.87 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 185,940.24 1,314,059.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 5,849.25 0.00 1,071,978.50 99.46 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-599512 Street Resurfacing 276,509.44 274,622.36 1,878.64 8.44 0.00 E75 Capital Projects 8,701,449.16 543,965.31 1,548,016.02 6,609,467.83 75.96 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 543,965.31 1,548,016.02 7,534,467.83 78.2684 Grand Total -9,626,449.16 -543,965.31 -1,548,016.02 -7,534,467.83 0.7827 990 Capital Projects 9,626,449.16 543,965.31 1,548,016.02 7,534,467.83 78.27 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 (05/05/2023 - 10:50 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,196,135.38 19,599,399.29 2,117,714.38 38,479,021.71 63.92 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 60,196,135.38 19,599,399.29 2,117,714.38 38,479,021.71 63.9227 Grand Total -60,196,135.38 -19,599,399.29 -2,117,714.38 -38,479,021.71 0.6392 GL - Trial Balance by Acct Type and Full Acct Number (05/05/2023 - 10:50 AM)Page 42