Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2021-07 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 07/12/21 15:09:33 Period 01 - 08 Fiscal Year 2021 CITY F JEFFERSON JOHN _ CHRI TY MUNICIPAL IPAL BUILDIN 320 E McCarty 1 Jeff arson City, bbl D 65101-3193 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 44,100.00 0.00 21,825.00 33.11 10-110-501015 Salary -Prosecuting Attorney 34,999.92 23,333.28 0.00 11,666.64 33.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits) 16,598.40 3,922.17 0.00 12,676.23 76.37 10-110-502010 Social Security 8,990.53 5,175.76 0.00 3,814.77 42.43 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 76,602.80 0.00 49,982.64 39.49 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 10.50 0.00 89.50 89.50 10-110-512010 Printing 400.00 341.05 0.00 58.95 14.74 10-110-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-110-513010 Office Supplies 1,700.00 1,223.17 0.00 476.83 28.05 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,300.00 1,574.72 0.00 725.28 31.53 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,250.00 105.84 0.00 1,144.16 91.53 10-110-520030 Dues And Publications 4,900.00 4,707.90 0.00 192.10 3.92 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,439.84 270.00 0.00 1,169.84 81.25 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,689.84 5,083.74 0.00 2,606.10 33.89 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 110.00 70.78 29.48 9.74 8.85 E25 Repairs & Maintenance 110.00 70.78 29.48 9.74 8.85 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 136,685.28 83,332.04 29.48 53,323.76 39.01 120 City Clerk 10-120-501020 Salaries 50,739.72 31,243.24 0.00 19,496.48 38.42 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 3,881.59 2,152.33 0.00 1,729.26 44.55 10-120-502020 Group Health Insurance 11,559.58 7,089.60 0.00 4,469.98 38.67 10-120-502030 Retirement 6,494.68 3,999.20 0.00 2,495.48 38.42 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 61.20 38.10 0.00 23.10 37.75 10-120-502060 Long Term Disability 152.27 94.86 0.00 57.41 37.70 10-120-502070 Employee Assistance Prgm 21.84 15.52 0.00 6.32 28.94 E05 Personnel Services 72,960.87 44,682.84 0.00 28,278.03 38.76 10-120-511020 Postage 200.00 105.55 0.00 94.45 47.23 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 143.62 0.00 156.38 52.13 10-120-513010 Office Supplies 200.00 57.07 0.00 142.93 71.47 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 306.24 0.00 393.76 56.25 10-120-520030 Dues And Publications 75.00 80.00 0.00 -5.00 -6.67 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 380.00 0.00 20.00 5.00 10-120-522020 Professional Services 200.00 79.42 0.00 120.58 60.29 10-120-529030 Election Expense 18,579.79 9,268.34 0.00 9,311.45 50.12 E15 Contractual Services 19,254.79 9,807.76 0.00 9,447.03 49.06 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,195.00 3,997.68 29.48 6,167.84 60.50 E25 Repairs & Maintenance 10,195.00 3,997.68 29.48 6,167.84 60.50 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 103,110.66 58,794.52 29.48 44,286.66 42.95 140 City Administrator 10-140-501020 Salaries 205,266.52 126,057.77 0.00 79,208.75 38.59 10-140-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-547010 Equipment Maintenance 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 15,702.89 7,626.67 0.00 8,076.22 51.43 10-140-502020 Group Health Insurance 22,748.28 13,954.20 0.00 8,794.08 38.66 10-140-502030 Retirement 26,274.11 16,135.36 0.00 10,138.75 38.59 10-140-502040 Workers Compensation 201.21 201.21 0.00 0.00 0.00 10-140-502050 Life Insurance 108.94 61.40 0.00 47.54 43.64 10-140-502060 Long Term Disability 270.01 170.07 0.00 99.94 37.01 10-140-502070 Employee Assistance Prgm 43.68 31.06 0.00 12.62 28.89 E05 Personnel Services 270,615.64 164,237.74 0.00 106,377.90 39.31 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 52.31 0.00 97.69 65.13 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 15.10 0.00 134.90 89.93 10-140-513010 Office Supplies 750.00 356.18 0.00 393.82 52.51 10-140-514017 COVID-19 0.00 3,940.97 0.00 -3,940.97 0.00 10-140-517010 Operational Supplies 678.74 58.31 0.00 620.43 91.41 E10 Materials & Supplies 1,828.74 4,422.87 0.00 -2,594.13 -141.85 10-140-520030 Dues And Publications 700.00 483.70 0.00 216.30 30.90 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 1,359.00 0.00 641.00 32.05 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 400.00 7.42 0.00 392.58 98.15 E15 Contractual Services 3,100.00 1,850.12 0.00 1,249.88 40.32 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 290.00 250.73 29.48 9.79 3.38 E25 Repairs & Maintenance 290.00 250.73 29.48 9.79 3.38 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 275,834.38 170,761.46 29.48 105,043.44 38.08 148 CDBG-CV 10-148-501020 Salaries 82,687.00 0.00 0.00 82,687.00 100.00 10-148-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-148-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-148-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 82,687.00 0.00 0.00 82,687.00 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-528025 CARES -Childcare Services 124,030.00 0.00 0.00 124,030.00 100.00 10-148-528035 CARES -ED For -Profit Business 103,359.00 0.00 0.00 103,359.00 100.00 10-148-528045 CARES -ED Microenterprise 103,359.00 0.00 0.00 103,359.00 100.00 E15 Contractual Services 330,748.00 0.00 0.00 330,748.00 100.00 148 CDBG-CV 413,435.00 0.00 0.00 413,435.00 100.00 149 Entitlement Grant 0.00 137,478.73 57.52 10-149-528030 10-149-501020 Salaries 68,290.83 32,923.71 0.00 35,367.12 51.79 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 5,224.25 2,117.34 0.00 3,106.91 59.47 10-149-502020 Group Health Insurance 17,319.42 8,975.35 0.00 8,344.07 48.18 10-149-502030 Retirement 8,741.23 4,094.75 0.00 4,646.48 53.16 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 10-149-502050 Life Insurance 81.47 41.38 0.00 40.09 49.21 10-149-502060 Long Term Disability 202.57 102.45 0.00 100.12 49.42 10-149-502070 Employee Assistance Program 32.76 20.64 0.00 12.12 37.00 E05 Personnel Services 99,979.56 48,362.65 0.00 51,616.91 51.63 10-149-511010 Advertising 1,550.00 812.00 0.00 738.00 47.61 10-149-511020 Postage 240.00 31.23 0.00 208.77 86.99 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 210.00 83.26 0.00 126.74 60.35 10-149-517010 Operational Supplies 35.00 21.43 0.00 13.57 38.77 E10 Materials & Supplies 2,035.00 947.92 0.00 1,087.08 53.42 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,835.00 0.00 0.00 2,835.00 100.00 10-149-522020 Professional Services 40,000.00 0.00 0.00 40,000.00 100.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 9,990.00 162.00 0.00 9,828.00 98.38 10-149-528012 Housing Rehab -Energy Efficienc 13,490.00 27.00 0.00 13,463.00 99.80 10-149-528020 Housing Assistance 239,001.73 101,523.00 0.00 137,478.73 57.52 10-149-528030 Public Improvement 172,809.51 0.00 0.00 172,809.51 100.00 10-149-528040 Neighborhood Redevelopmnt 109,025.00 15,857.62 15,498.38 77,669.00 71.24 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 6,285.00 0.00 0.00 6,285.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-528080 Homeless Objectives 5,292.00 0.00 0.00 5,292.00 100.00 E15 Contractual Services 598,728.24 117,569.62 15,498.38 465,660.24 77.77 10-149-547020 Maintenance Agreements 328.00 93.72 45.81 188.47 57.46 E25 Repairs & Maintenance 328.00 93.72 45.81 188.47 57.46 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00 10-149-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 701,070.80 166,973.91 15,544.19 518,552.70 73.97 150 City Attorney 10-150-501020 Salaries 218,180.70 136,945.00 0.00 81,235.70 37.23 10-150-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,690.82 9,995.56 0.00 6,695.26 40.11 10-150-502020 Group Health Insurance 35,000.04 18,599.46 0.00 16,400.58 46.86 10-150-502030 Retirement 27,927.13 15,826.92 0.00 12,100.21 43.33 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 271.73 164.00 0.00 107.73 39.65 10-150-502060 Long Term Disability 567.20 353.20 0.00 214.00 37.73 10-150-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 298,933.93 182,161.52 0.00 116,772.41 39.06 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 212.62 0.00 287.38 57.48 10-150-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-150-512020 Copies 50.00 0.53 0.00 49.47 98.94 10-150-513010 Office Supplies 1,500.00 1,206.48 0.00 293.52 19.57 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 2,150.00 1,419.63 0.00 730.37 33.97 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 9,331.00 4,688.53 2,533.32 2,109.15 22.60 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 4,831.00 1,945.00 0.00 2,886.00 59.74 10-150-520080 Tuition Reimbursement 3,738.00 3,738.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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-522020 Professional Services 10,000.00 4,104.88 0.00 5,895.12 58.95 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 28,400.00 14,476.41 2,533.32 11,390.27 40.11 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 350.00 310.73 29.48 9.79 2.80 E25 Repairs & Maintenance 350.00 310.73 29.48 9.79 2.80 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Attorney 329,833.93 198,368.29 2,562.80 128,902.84 39.08 160 Municipal Court 10-160-501010 Salary -elected Officals 24,791.57 13,124.97 0.00 11,666.60 47.06 10-160-501020 Salaries 116,693.73 70,841.14 0.00 45,852.59 39.29 10-160-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits) 7,000.00 3,436.08 0.00 3,563.92 50.91 10-160-501090 Overtime 1,500.00 256.56 0.00 1,243.44 82.90 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,254.81 6,493.59 0.00 5,761.22 47.01 10-160-502020 Group Health Insurance 25,245.37 15,138.33 0.00 10,107.04 40.04 10-160-502030 Retirement 15,128.80 8,100.24 0.00 7,028.56 46.46 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 141.98 86.85 0.00 55.13 38.83 10-160-502060 Long Term Disability 350.06 215.01 0.00 135.05 38.58 10-160-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 203,370.01 117,937.53 0.00 85,432.48 42.01 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,550.00 1,772.69 0.00 1,777.31 50.07 10-160-512010 Printing 400.00 165.00 0.00 235.00 58.75 10-160-512020 Copies 0.00 0.95 0.00 -0.95 0.00 10-160-513010 Office Supplies 4,000.00 2,377.87 0.00 1,622.13 40.55 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,950.00 4,316.51 0.00 3,633.49 45.70 10-160-520025 Security 10,000.00 619.92 0.00 9,380.08 93.80 10-160-520030 Dues And Publications 200.00 180.00 0.00 20.00 10.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,500.00 475.00 0.00 1,025.00 68.33 10-160-522020 Professional Services 16,208.35 14,210.78 0.00 1,997.57 12.32 10-160-525005 Appointed Counsel 4,000.00 798.00 0.00 3,202.00 80.05 10-160-525010 Care Of Prisoners 250.00 45.00 0.00 205.00 82.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 32,198.35 16,328.70 0.00 15,869.65 49.29 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,000.00 2,350.00 66.33 3,583.67 59.73 E25 Repairs & Maintenance 6,000.00 2,350.00 66.33 3,583.67 59.73 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 160 Municipal Court 249,518.36 140,932.74 66.33 108,519.29 43.49 170 Human Resources 10-170-501020 Salaries 216,706.40 133,328.22 0.00 83,378.18 38.48 10-170-501050 Parttime(wo Benefits) 13,000.00 9,811.88 0.00 3,188.12 24.52 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.03 0.00 -46.03 -46.03 10-170-501095 Overtime Straight Pay 0.00 55.63 0.00 -55.63 0.00 10-170-502010 Social Security 17,580.19 10,794.71 0.00 6,785.48 38.60 10-170-502020 Group Health Insurance 26,267.63 14,203.71 0.00 12,063.92 45.93 10-170-502030 Retirement 27,751.22 17,091.81 0.00 10,659.41 38.41 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 260.71 162.15 0.00 98.56 37.80 10-170-502060 Long Term Disability 560.59 346.62 0.00 213.97 38.17 10-170-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 302,617.95 186,313.04 0.00 116,304.91 38.43 10-170-511010 Advertising 0.00 49.00 0.00 -49.00 0.00 10-170-511020 Postage 300.00 115.75 0.00 184.25 61.42 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 296.19 0.00 203.81 40.76 10-170-513010 Office Supplies 1,000.00 199.81 0.00 800.19 80.02 10-170-514017 COVID-19 11,787.00 10,887.00 0.00 900.00 7.64 10-170-517010 Operational Supplies 800.00 68.04 0.00 731.96 91.50 E10 Materials & Supplies 15,187.00 11,615.79 0.00 3,571.21 23.51 10-170-520030 Dues And Publications 1,000.00 552.00 0.00 448.00 44.80 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 8,670.00 6,302.32 0.00 2,367.68 27.31 10-170-520070 Training And Education 5,220.00 209.00 0.00 5,011.00 96.00 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 900.00 20.00 0.00 880.00 97.78 10-170-522020 Professional Services 4.000.00 7.42 0.00 3.992.58 99.81 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-529010 Special Events 800.00 54.99 0.00 745.01 93.13 10-170-529015 Human Relations Commission 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 21,090.00 7,145.73 0.00 13,944.27 66.12 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 290.00 250.79 29.48 9.73 3.36 E25 Repairs & Maintenance 290.00 250.79 29.48 9.73 3.36 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 339,184.95 205,325.35 29.48 133,830.12 39.46 180 Finance Department 10-180-501020 Salaries 640,131.46 349,014.25 0.00 291,117.21 45.48 10-180-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 48,970.06 25,935.72 0.00 23,034.34 47.04 10-180-502020 Group Health Insurance 98,124.71 48,431.12 0.00 49,693.59 50.64 10-180-502030 Retirement 81,936.83 39,404.86 0.00 42,531.97 51.91 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 751.54 395.30 0.00 356.24 47.40 10-180-502060 Long Term Disability 1,849.71 937.52 0.00 912.19 49.32 10-180-502070 Employee Assistance Prgm 256.62 182.59 0.00 74.03 28.85 10-180-503020 Unemployment Compensation 0.00 188.70 0.00 -188.70 0.00 E05 Personnel Services 872,519.76 464,988.89 0.00 407,530.87 46.71 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 10,000.00 4,544.25 0.00 5,455.75 54.56 10-180-511021 Mail Machine Cost 3,000.00 1,746.54 0.00 1,253.46 41.78 10-180-512010 Printing 3,300.00 724.21 0.00 2,575.79 78.05 10-180-512020 Copies 1,300.00 70.26 0.00 1,229.74 94.60 10-180-512021 Copy Machine Cost 200.00 -530.31 0.00 730.31 365.16 10-180-513010 Office Supplies 3,600.00 717.90 0.00 2,882.10 80.06 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,600.00 1,687.17 2,570.78 -657.95 -18.28 E10 Materials & Supplies 26,000.00 8,960.02 2,570.78 14,469.20 55.65 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,300.00 1,585.00 0.00 715.00 31.09 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Trainim And Education 7.975.76 1.182.55 0.00 6.793.21 85.17 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 53,571.20 36,502.40 0.00 17,068.80 31.86 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 7.42 0.00 292.58 97.53 E15 Contractual Services 64,146.96 39,277.37 0.00 24,869.59 38.77 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 1,260.00 1,260.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,260.00 1,260.00 0.00 0.00 0.00 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 963,926.72 514,486.28 2,570.78 446,869.66 46.36 185 Non -Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance -Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 34,839.60 0.00 2,127.83 5.76 10-185-502023 Self Insurance -Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 36,967.43 34,839.60 0.00 2,127.83 5.76 10-185-514010 Gas 11,000.00 4,841.79 0.00 6,158.21 55.98 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 11,000.00 4,841.79 0.00 6,158.21 55.98 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 393,468.82 613,276.21 0.00 -219,807.39 -55.86 10-185-521020 Insurance Deductible 25,000.00 101,672.46 0.00 -76,672.46 -306.69 10-185-521030 Self Ins Prop & Casualty 40,000.00 3,110.10 0.00 36,889.90 92.22 10-185-521060 Drugalcohol screening 3,564.00 1,060.00 0.00 2,504.00 70.26 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 25,000.00 16,783.33 8,400.00 -183.33 -0.73 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-522035 Meeting Streaming & Recording 19,369.90 18,555.67 0.00 814.23 4.20 10-185-524010 Amtrak Station Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Tree & Landscape Maint Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Maintenance Agreements Economic Development 185,000.00 138,750.00 0.00 46,250.00 25.00 10-185-529010 Repairs & Maintenance Special Events 7,000.00 661.17 0.00 6,338.83 90.55 E15 Miscellaneous Contractual Services 745,402.72 893,868.94 8,400.00 -156,866.22 -21.04 10-185-531010 Electricity 33,000.00 12,470.19 0.00 20,529.81 62.21 10-185-533010 Natural Gas 6,200.00 4,182.97 0.00 2,017.03 32.53 10-185-535010 Water 7,250.00 3,057.65 0.00 4,192.35 57.83 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 46,450.00 19,710.81 0.00 26,739.19 57.57 10-185-540010 Building & Grounds Maint. 40,000.00 29,640.40 0.00 10,359.60 25.90 10-185-540015 Amtrak Station 8,000.00 1,360.55 0.00 6,639.45 82.99 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 1,900.00 1,212.00 0.00 688.00 36.21 E25 Repairs & Maintenance 74,900.00 57,212.95 0.00 17,687.05 23.61 10-185-550010 Miscellaneous 4,000.00 1,098.00 0.00 2,902.00 72.55 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'1 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 500.00 0.00 0.00 500.00 100.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 14,500.00 11,098.00 0.00 3,402.00 23.46 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 220,000.00 40,829.72 0.00 179,170.28 81.44 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 220,000.00 40,829.72 0.00 179,170.28 81.44 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 185 Non -Departmental 1,149,220.15 1,062,401.81 8,400.00 78,418.34 6.82 190 Information Technology Svcs 10-190-501020 Salaries 571,790.67 351,560.82 0.00 220,229.85 38.52 10-190-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits) 0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 82.10 0.00 1,117.90 93.16 10-190-501095 Overtime Straight Pay 0.00 360.36 0.00 -360.36 0.00 10-190-502010 Social Security 43,833.79 25,829.20 0.00 18,004.59 41.07 10-190-502020 Group Health Insurance 85,871.51 53,084.33 0.00 32,787.18 38.18 10-190-502030 Retirement 73,342.81 45,056.68 0.00 28,286.13 38.57 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 687.28 427.06 0.00 260.22 37.86 10-190-502060 Long Term Disability 1,660.17 1,030.90 0.00 629.27 37.90 10-190-502070 Employee Assistance Prgm 207.48 147.55 0.00 59.93 28.88 E05 Personnel Services 779,951.92 478,937.21 0.00 301,014.71 38.59 10-190-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-190-511020 Postage 50.00 11.55 0.00 38.45 76.90 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 3.48 0.00 16.52 82.60 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 407.43 0.00 492.57 54.73 10-190-514017 COVID-19 16,000.00 4,706.67 0.00 11,293.33 70.58 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 2,500.00 426.65 0.00 2,073.35 82.93 E10 Materials & Supplies 19,570.00 5,555.78 0.00 14,014.22 71.61 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 0.00 0.00 300.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 10,000.00 199.00 0.00 9,801.00 98.01 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 10,000.00 7.42 0.00 9,992.58 99.93 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet Tl Web 20,000.00 10,362.09 0.00 9,637.91 48.19 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 44,700.00 14,883.51 0.00 29,816.49 66.70 10-190-534010 Telephone 56,000.00 59,040.47 0.00 -3,040.47 -5.43 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 56,000.00 59,040.47 0.00 -3,040.47 -5.43 10-190-545010 Postage Software Licensemaint 154,818.36 112,578.97 12,729.83 29,509.56 19.06 10-190-545020 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 Equipment Maintenance 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547020 10-300-512030 Maintenance Agreements 23,000.00 11,114.00 0.00 11,886.00 51.68 E25 10-300-513010 Repairs & Maintenance 181,818.36 123,692.97 12,729.83 45,395.56 24.97 10-190-572020 10-300-514010 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 10-300-514017 Capital Purchases 0.00 0.00 0.00 0.00 0.00 190 10-300-514040 Information Technology Svcs 1,082,040.28 682,109.94 12,729.83 387,200.51 35.78 300 10-300-515040 Police Department First Aid Supplies 1,378.00 997.80 0.00 380.20 10-300-501020 Salaries 4,514,893.65 2,710,517.26 0.00 1,804,376.39 39.96 10-300-501030 4.70 Holiday Pay 140,665.66 73,745.03 0.00 66,920.63 47.57 10-300-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-300-501050 2,325.00 Parttime(wo Benefits) 66,208.36 22,488.45 0.00 43,719.91 66.03 10-300-501060 0.00 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 72.61 Stand-by Plan 5,000.00 2,656.00 0.00 2,344.00 46.88 10-300-501090 22.22 Overtime 290,036.42 160,859.45 0.00 129,176.97 44.54 10-300-501095 Overtime Straight Pay 13,275.00 11,375.69 0.00 1,899.31 14.31 10-300-502010 Social Security 384,177.46 214,545.67 0.00 169,631.79 44.15 10-300-502020 Group Health Insurance 838,663.85 494,649.20 0.00 344,014.65 41.02 10-300-502030 Retirement 881,575.31 498,087.77 0.00 383,487.54 43.50 10-300-502040 Workers Compensation 75,085.92 75,085.92 0.00 0.00 0.00 10-300-502050 Life Insurance 5,340.27 3,175.52 0.00 2,164.75 40.54 10-300-502060 Long Term Disability 13,356.47 7,865.51 0.00 5,490.96 41.11 10-300-502070 Employee Assistance Prgm 1,976.52 1,404.63 0.00 571.89 28.93 10-300-503010 Awards Program 4,786.00 0.00 4,786.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,235,040.89 4,276,456.10 4,786.00 2,953,798.79 40.83 10-300-511010 Advertising 5,665.00 3,205.00 0.00 2,460.00 43.42 10-300-511020 Postage 1,395.00 662.17 0.00 732.83 52.53 10-300-512010 Printing 5,952.00 4,064.55 0.00 1,887.45 31.71 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,860.00 536.00 0.00 1,324.00 71.18 10-300-513010 Office Supplies 15,670.50 12,120.07 1,996.22 1,554.21 9.92 10-300-514010 Gas 145,000.00 78,708.44 0.00 66,291.56 45.72 10-300-514017 COVID-19 0.00 339.16 0.00 -339.16 0.00 10-300-514040 Food 651.00 692.79 0.00 -41.79 -6.42 10-300-515040 First Aid Supplies 1,378.00 997.80 0.00 380.20 27.59 10-300-516010 Ammunition & Firearms Supplies 94,000.00 36,241.37 53,336.85 4,421.78 4.70 10-300-516020 Dare Program 15,345.00 4,488.88 0.00 10,856.12 70.75 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 17,307.43 4,740.45 0.00 12,566.98 72.61 10-300-517010 Operational Supplies 44,278.00 33,180.12 1,257.66 9,840.22 22.22 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 350,826.93 179,976.80 56,590.73 114,259.40 32.57 10-300-520030 10-300-572011 Dues And Publications 5,400.00 5,533.03 0.00 -133.03 -2.46 10-300-520050 0.00 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 3,655.50 Training And Education 75,800.00 37,871.17 0.00 37,928.83 50.04 10-300-520080 0.00 Tuition Reimbursement 11,625.00 12,768.00 0.00 -1,143.00 -9.83 10-300-520090 4,500.00 Recruitment 2,325.00 1,199.45 0.00 1,125.55 48.41 10-300-521040 Medical Claimsservices 6,510.00 6,745.50 0.00 -235.50 -3.62 10-300-521050 3,549.62 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 DEA Equipment Grant Professional Services 14,415.00 18,773.75 0.00 -4,358.75 -30.24 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 1,500.00 0.00 -1,500.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 1,096.35 0.00 949.65 46.41 E15 Contractual Services 118,121.00 85,487.25 0.00 32,633.75 27.63 10-300-531010 Electricity 44,640.00 21,344.25 0.00 23,295.75 52.19 10-300-533010 Natural Gas 1,116.00 344.33 0.00 771.67 69.15 10-300-534010 Telephone 24,101.00 10,447.49 0.00 13,653.51 56.65 10-300-535010 Water 3,348.00 2,472.18 0.00 875.82 26.16 E20 Utilities 73,205.00 34,608.25 0.00 38,596.75 52.72 10-300-540010 Building & Grounds Maint. 43,700.00 39,666.58 3,244.26 789.16 1.81 10-300-541030 Vehicle Wash 9,752.00 6,962.89 0.00 2,789.11 28.60 10-300-544010 K-9 Operations 17,740.00 9,250.08 0.00 8,489.92 47.86 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 22,599.00 20,168.99 0.00 2,430.01 10.75 10-300-545010 Software Licensemaint 64,843.00 64,841.25 0.00 1.75 0.00 10-300-546010 Clothing Expense 45,134.00 22,923.62 0.00 22,210.38 49.21 10-300-546020 Uniform Cleaning 23,715.00 15,872.16 0.00 7,842.84 33.07 10-300-547010 Equipment Maintenance 10,000.00 10,156.43 0.00 -156.43 -1.56 10-300-547020 Maintenance Agreements 55,344.11 32,393.27 11,489.98 11,460.86 20.71 10-300-547030 Radio Maintenance 9,300.00 5,771.89 0.00 3,528.11 37.94 E25 Repairs & Maintenance 302,127.11 228,007.16 14,734.24 59,385.71 19.66 10-300-572010 Purchase Of Vehicles 238,490.10 203,277.10 35,213.00 0.00 0.00 10-300-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 206,532.59 18,771.59 184,105.50 3,655.50 1.77 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 6,249.00 4,500.00 0.00 1,749.00 27.99 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 3,549.62 3,752.40 0.00 -202.78 -5.71 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572085 Bullet Proof Vest Grant 21,149.25 11,177.00 0.00 9,972.25 47.15 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 Cry 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 Cry Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 4,166.00 0.00 0.00 4,166.00 100.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software -morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software -prof Sery 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 480,136.56 241,478.09 219,318.50 19,339.97 4.03 300 Police Department 8,559,457.49 5,046,013.65 295,429.47 3,218,014.37 37.60 310 School Resource Officer 10-310-501020 Salaries 403,716.53 258,133.05 0.00 145,583.48 36.06 10-310-501030 Holiday Pay 15,519.25 2,704.33 0.00 12,814.92 82.57 10-310-501090 Overtime 45,106.00 50,566.39 0.00 -5,460.39 -12.11 10-310-501095 Overtime Straight Pay 1,311.00 348.31 0.00 962.69 73.43 10-310-502010 Social Security 35,622.44 22,077.26 0.00 13,545.18 38.02 10-310-502020 Group Health Insurance 89,658.24 53,208.27 0.00 36,449.97 40.65 10-310-502030 Retirement 85,214.46 57,050.61 0.00 28,163.85 33.05 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 489.60 307.20 0.00 182.40 37.25 10-310-502060 Long Term Disability 1,210.29 759.72 0.00 450.57 37.23 10-310-502070 Employee Assistance Prgm 174.72 124.26 0.00 50.46 28.88 E05 Personnel Services 684,575.39 451,832.26 0.00 232,743.13 34.00 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-310-517010 Operational Supplies 6,994.46 4,086.04 0.00 2,908.42 41.58 E10 Materials & Supplies 6,994.46 4,086.04 0.00 2,908.42 41.58 10-310-520070 Training And Education 4,650.00 3,232.09 0.00 1,417.91 30.49 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 3,232.09 0.00 1,417.91 30.49 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,973.78 3,056.14 0.00 2,917.64 48.84 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 E25 Repairs & Maintenance 6,333.78 3,056.14 0.00 3,277.64 51.75 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 702,553.63 462,206.53 0.00 240,347.10 34.21 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 98,370.35 60,608.12 0.00 37,762.23 38.39 10-320-501030 Holiday Pay 3,714.24 182.45 0.00 3,531.79 95.09 10-320-501090 Overtime 29,363.36 7,849.42 0.00 21,513.94 73.27 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 8,677.77 4,894.89 0.00 3,782.88 43.59 10-320-502020 Group Health Insurance 23,027.36 10,954.20 0.00 12,073.16 52.43 10-320-502030 Retirement 20,758.59 12,561.14 0.00 8,197.45 39.49 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 117.50 72.45 0.00 45.05 38.34 10-320-502060 Long Term Disability 289.60 179.28 0.00 110.32 38.09 10-320-502070 Employee Assistance Prgm 43.68 31.06 0.00 12.62 28.89 E05 Personnel Services 186,366.84 99,337.40 0.00 87,029.44 46.70 10-320-514010 Gas 6,000.00 2,800.12 0.00 3,199.88 53.33 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,905.36 8,605.99 2,930.00 2,369.37 17.04 10-320-517010 Operational Supplies 13,921.60 827.96 0.00 13,093.64 94.05 E10 Materials & Supplies 33,826.96 12,234.07 2,930.00 18,662.89 55.17 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 19,273.92 7,000.00 0.00 12,273.92 63.68 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 19,273.92 7,000.00 0.00 12,273.92 63.68 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 320 M.U.S.T.A.N.G. 239,467.72 118,571.47 2,930.00 117,966.25 49.26 330 Animal Control 0.00 0.00 0.00 0.00 0.00 10-330-501020 Salaries 355,286.75 179,152.80 0.00 176,133.95 49.58 10-330-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,308.00 2,644.00 0.00 1,664.00 38.63 10-330-501090 Overtime 1,709.00 2,820.82 0.00 -1,111.82 -65.06 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 27,639.74 12,787.64 0.00 14,852.10 53.73 10-330-502020 Group Health Insurance 76,144.06 46,590.38 0.00 29,553.68 38.81 10-330-502030 Retirement 46,246.88 19,194.62 0.00 27,052.26 58.50 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 430.85 217.95 0.00 212.90 49.41 10-330-502060 Long Term Disability 1,064.88 539.16 0.00 525.72 49.37 10-330-502070 Employee Assistance Prgm 174.72 124.26 0.00 50.46 28.88 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 517,685.96 268,752.71 0.00 248,933.25 48.09 10-330-511010 Advertising 111.60 1,167.50 0.00 -1,055.90 -946.15 10-330-511020 Postage 110.00 94.70 0.00 15.30 13.91 10-330-512010 Printing 1,720.50 1,419.03 0.00 301.47 17.52 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 583.93 0.00 997.07 63.07 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.20 330.76 0.00 -107.56 -48.19 10-330-515040 First Aid Supplies 465.00 163.07 0.00 301.93 64.93 10-330-517010 Operational Supplies 12,015.60 6,824.33 0.00 5,191.27 43.20 E10 Materials & Supplies 16,226.90 10,583.32 0.00 5,643.58 34.78 10-330-520030 Dues And Publications 1,491.00 123.50 0.00 1,367.50 91.72 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 434.23 0.00 2,176.77 83.37 10-330-521040 Medical Claimsservices 431.52 103.27 0.00 328.25 76.07 10-330-522020 Professional Services 6,510.00 2,184.43 0.00 4,325.57 66.45 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 40,088.77 0.00 -34,880.77 -669.75 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 16,965.99 15,790.99 0.00 1,175.00 6.93 E15 Contractual Services 33,217.51 58,725.19 0.00 -25,507.68 -76.79 10-330-531010 Electricity 22,789.00 14,999.89 0.00 7,789.11 34.18 10-330-533010 Natural Gas 18,000.00 16,230.75 0.00 1,769.25 9.83 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-534010 Telephone 300.00 352.83 0.00 -52.83 -17.61 10-330-535010 Water 3,800.00 1,797.18 0.00 2,002.82 52.71 E20 Utilities 44,889.00 33,380.65 0.00 11,508.35 25.64 10-330-540010 Building & Grounds Maint. 12,600.00 13,128.27 30.00 -558.27 -4.43 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 43,480.00 21,505.73 0.00 21,974.27 50.54 10-330-544050 Animal Food 6,603.00 1,483.80 0.00 5,119.20 77.53 10-330-545010 Software Licensemaint 3,089.96 2,511.12 158.06 420.78 13.62 10-330-546010 Clothing Expense 2,325.00 770.40 0.00 1,554.60 66.86 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 837.00 14.99 0.00 822.01 98.21 10-330-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 232.50 0.00 0.00 232.50 100.00 10-330-547040 Crematory Maint & Repair 23,500.00 23,500.00 0.00 0.00 0.00 E25 Repairs & Maintenance 93,567.46 63,814.31 188.06 29,565.09 31.60 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 25,342.15 3,979.00 20,972.15 391.00 1.54 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 25,342.15 3,979.00 20,972.15 391.00 1.54 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 330 Animal Control 730,928.98 439,235.18 21,160.21 270,533.59 37.01 390 9-1-1 Police 10-390-501020 Salaries 889,827.83 564,036.49 0.00 325,791.34 36.61 10-390-501030 Holiday Pay 31,176.29 22,512.51 0.00 8,663.78 27.79 10-390-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 22,814.00 11,337.31 0.00 11,476.69 50.31 10-390-501095 Overtime Straight Pay 500.00 585.21 0.00 -85.21 -17.04 10-390-502010 Social Security 72,240.34 42,921.71 0.00 29,318.63 40.58 10-390-502020 Group Health Insurance 200,121.03 123,701.37 0.00 76,419.66 38.19 10-390-502030 Retirement 122,574.19 71,929.28 0.00 50,644.91 41.32 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,079.57 686.81 0.00 392.76 36.38 10-390-502060 Long Term Disability 2,665.08 1,692.02 0.00 973.06 36.51 10-390-502070 Employee Assistance Prgm 464.10 330.05 0.00 134.05 28.88 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,346,182.39 842,452.72 0.00 503,729.67 37.42 10-390-511010 Advertising 928.00 437.50 0.00 490.50 52.86 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,225.00 2,973.35 1,214.02 2,037.63 32.73 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 7,153.00 3,410.85 1,214.02 2,528.13 35.34 10-390-520030 Dues And Publications 558.00 192.00 0.00 366.00 65.59 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 4,650.00 4,000.89 0.00 649.11 13.96 10-390-522020 Professional Services 3,000.00 1,778.44 0.00 1,221.56 40.72 10-390-523010 Equipment Rentlease 98,278.00 64,649.16 0.00 33,628.84 34.22 E15 Contractual Services 106,486.00 70,620.49 0.00 35,865.51 33.68 10-390-531010 Electricity 11,160.00 3,192.30 0.00 7,967.70 71.40 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 142.46 0.00 694.54 82.98 E20 Utilities 12,276.00 3,334.76 0.00 8,941.24 72.84 10-390-545010 Software Licensemaint 32,955.00 35,401.08 0.00 -2,446.08 -7.42 10-390-546010 Clothing Expense 5,580.00 2,684.96 0.00 2,895.04 51.88 10-390-546020 Uniform Cleaning 2,976.00 1,815.00 0.00 1,161.00 39.01 10-390-547010 Equipment Maintenance 2,790.00 0.00 0.00 2,790.00 100.00 10-390-547020 Maintenance Agreements 77,656.34 43,942.74 158.19 33,555.41 43.21 10-390-547030 Radio Maintenance 4,650.00 160.00 0.00 4,490.00 96.56 E25 Repairs & Maintenance 126,607.34 84,003.78 158.19 42,445.37 33.53 10-390-572020 Purchase Of Equipment 0.00 0.00 35,970.00 -35,970.00 0.00 E70 Capital Purchases 0.00 0.00 35,970.00 -35,970.00 0.00 390 9-1-1 Police 1,598,704.73 1,003,822.60 37,342.21 557,539.92 34.87 400 Fire Department 10-400-501020 Salaries 3,925,544.21 2,367,924.95 0.00 1,557,619.26 39.68 10-400-501030 Holiday Pay 293,571.79 214,524.99 0.00 79,046.80 26.93 10-400-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 35,000.00 17,147.17 0.00 17,852.83 51.01 10-400-501090 Overtime 41,000.00 26,557.16 0.00 14,442.84 35.23 10-400-501095 Overtime Straight Pay 33,000.00 18,637.65 0.00 14,362.35 43.52 10-400-502010 Social Security 65,414.80 37,496.59 0.00 27,918.21 42.68 10-400-502020 Group Health Insurance 786,688.12 472,264.88 0.00 314,423.24 39.97 10-400-502030 Retirement 2,062,410.10 1,221,597.52 0.00 840,812.58 40.77 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 4,669.56 2,824.86 0.00 1,844.70 39.50 10-400-502060 Long Term Disability 11,694.72 6,926.64 0.00 4,768.08 40.77 10-400-502070 Employee Assistance Prgm 1,659.84 1,180.41 0.00 479.43 28.88 10-400-503010 Awards Program 1,500.00 1,389.73 0.00 110.27 7.35 E05 Personnel Services 7,415,184.09 4,541,503.50 0.00 2,873,680.59 38.75 10-400-511010 Advertising 372.00 290.50 0.00 81.50 21.91 10-400-511020 Postage 139.50 90.97 0.00 48.53 34.79 10-400-512010 Printing 790.50 541.00 0.00 249.50 31.56 10-400-512020 Conies 46.50 0.00 0.00 46.50 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-512030 Purchase Of Vehicles Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 0.00 Office Supplies 1,395.00 1,054.93 0.00 340.07 24.38 10-400-514010 80,297.10 Gas 47,000.00 27,489.87 0.00 19,510.13 41.51 10-400-514017 0.00 COVID-19 112,500.00 65,229.74 1,832.94 45,437.32 40.39 10-400-514020 0.00 Chemicals 930.00 538.80 0.00 391.20 42.06 10-400-514030 0.00 Small Tools 5,000.00 1,007.72 3,655.70 336.58 6.73 10-400-514040 10-400-575004 Food 0.00 469.32 0.00 -469.32 0.00 10-400-515040 First Aid Supplies 2,046.00 560.34 0.00 1,485.66 72.61 10-400-517010 Operational Supplies 14,000.00 14,095.53 0.00 -95.53 -0.68 E10 Materials & Supplies 184,219.50 111,368.72 5,488.64 67,362.14 36.57 10-400-520030 Dues And Publications 3,373.65 2,399.98 0.00 973.67 28.86 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,427.51 17,320.20 2,925.00 12,182.31 37.57 10-400-520080 Tuition Reimbursement 6,045.00 3,547.50 0.00 2,497.50 41.32 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 34,131.60 0.00 5,868.40 14.67 10-400-522020 Professional Services 186.00 880.00 0.00 -694.00 -373.12 10-400-523010 Equipment Rentlease 186.00 47.00 0.00 139.00 74.73 10-400-524010 Trash Collections 93.00 137.76 0.00 -44.76 -48.13 10-400-529010 Special Events 6,510.00 4,594.43 0.00 1,915.57 29.43 10-400-529040 Child Safety Seat Pass-through 2,500.00 673.31 0.00 1,826.69 73.07 E15 Contractual Services 91,321.16 63,731.78 2,925.00 24,664.38 27.01 10-400-531010 Electricity 35,000.00 17,397.06 0.00 17,602.94 50.29 10-400-533010 Natural Gas 17,670.00 12,324.33 0.00 5,345.67 30.25 10-400-534010 Telephone 23,250.00 14,152.56 0.00 9,097.44 39.13 10-400-535010 Water 16,740.00 6,613.99 0.00 10,126.01 60.49 E20 Utilities 92,660.00 50,487.94 0.00 42,172.06 45.51 10-400-540010 Building & Grounds Maint. 199,166.53 68,789.58 84,519.06 45,857.89 23.02 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,703.50 41,204.94 0.00 28,498.56 40.89 10-400-546020 Uniform Cleaning 500.00 131.75 0.00 368.25 73.65 10-400-547010 Equipment Maintenance 20,667.24 12,031.16 0.00 8,636.08 41.79 10-400-547020 Maintenance Agreements 32,844.00 25,186.21 322.27 7,335.52 22.33 10-400-547030 Radio Maintenance 20,925.00 15,098.77 4,853.76 972.47 4.65 E25 Repairs & Maintenance 343,806.27 162,442.41 89,695.09 91,668.77 26.66 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 85,000.00 80,297.10 0.00 4,702.90 5.53 10-400-572021 Purchase of Equipment -ONE TIME 0.00 0.00 0.00 0.00 0.00 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 85,000.00 80,297.10 0.00 4,702.90 5.53 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 400 Fire Department 8,212,191.02 5,009,831.45 98,108.73 3,104,250.84 37.80 401 Fire Museum 10-401-531010 Electricity 1,860.00 244.25 0.00 1,615.75 86.87 10-401-533010 Natural Gas 0.00 293.32 0.00 -293.32 0.00 10-401-535010 Water 0.00 129.59 0.00 -129.59 0.00 E20 Utilities 1,860.00 667.16 0.00 1,192.84 64.13 10-401-540010 Building & Grounds Maint. 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 1,860.00 667.16 0.00 1,192.84 64.13 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 Sery 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs -Admin 10-520-501020 Salaries 187,342.17 132,470.11 0.00 54,872.06 29.29 10-520-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 14,331.68 9,927.82 0.00 4,403.86 30.73 10-520-502020 Group Health Insurance 27,393.78 16,571.34 0.00 10,822.44 39.51 10-520-502030 Retirement 23,979.80 14,926.49 0.00 9,053.31 37.75 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 225.22 155.50 0.00 69.72 30.96 10-520-502060 Long Term Disability 486.17 338.62 0.00 147.55 30.35 10-520-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 254,021.24 174,633.37 0.00 79,387.87 31.25 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 64.32 0.00 10.68 14.24 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 1,063.27 0.00 -213.27 -25.09 10-520-514010 Gas 11,000.00 5,974.98 0.00 5,025.02 45.68 10-520-514017 COVID-19 0.00 24,855.61 23,512.50 -48,368.11 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 575.43 0.00 -75.43 -15.09 E10 Materials & Supplies 12,525.00 32,533.68 23,512.50 -43,521.18 -347.47 10-520-520030 Dues And Publications 1,200.00 1,255.00 0.00 -55.00 -4.58 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 389.45 0.00 1,410.55 78.36 10-520-522020 Professional Services 4,000.00 388.00 7,771.72 -4,159.72 -103.99 E15 Contractual Services 7,000.00 2,032.45 7,771.72 -2,804.17 -40.06 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 1,152.00 766.69 22.87 362.44 31.46 E25 Repairs & Maintenance 1.152.00 766.69 22.87 362.44 31.46 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs -Admin 274,698.24 209,966.19 31,307.09 33,424.96 12.17 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 138,281.07 67,020.11 0.00 71,260.96 51.53 10-521-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 10,808.00 5,034.89 0.00 5,773.11 53.42 10-521-502020 Group Health Insurance 31,454.13 8,879.59 0.00 22,574.54 71.77 10-521-502030 Retirement 18,083.98 7,324.55 0.00 10,759.43 59.50 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 170.87 67.94 0.00 102.93 60.24 10-521-502060 Long Term Disability 422.38 168.27 0.00 254.11 60.16 10-521-502070 Employee Assistance Prgm 58.97 41.94 0.00 17.03 28.88 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 199,437.75 88,695.64 0.00 110,742.11 55.53 10-521-511010 Advertising 4,000.00 1,776.75 0.00 2,223.25 55.58 10-521-511020 Postage 500.00 126.96 0.00 373.04 74.61 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 258.96 0.00 541.04 67.63 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 30.43 0.00 1,469.57 97.97 E10 Materials & Supplies 7,000.00 2,193.10 0.00 4,806.90 68.67 10-521-520030 Dues And Publications 14,300.00 589.00 0.00 13,711.00 95.88 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 2,400.00 0.00 0.00 2,400.00 100.00 10-521-520080 Tuition Reimbursement 3,642.00 0.00 0.00 3,642.00 100.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 20,342.00 589.00 0.00 19,753.00 97.10 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,630.00 1,237.15 320.16 72.69 4.46 E25 Repairs & Maintenance 1,630.00 1,237.15 320.16 72.69 4.46 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 22 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 521 Plan & Protect Svcs -Planning 228,409.75 92,714.89 320.16 135,374.70 59.27 522 Plan & Protect Svcs -MPO 0.00 0.00 0.00 0.00 0.00 10-522-501020 Salaries 122,934.53 75,645.77 0.00 47,288.76 38.47 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,404.49 5,737.61 0.00 3,666.88 38.99 10-522-502020 Group Health Insurance 18,724.32 11,580.63 0.00 7,143.69 38.15 10-522-502030 Retirement 15,735.62 9,682.65 0.00 6,052.97 38.47 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 148.10 92.51 0.00 55.59 37.54 10-522-502060 Long Term Disability 365.96 229.33 0.00 136.63 37.33 10-522-502070 Employee Assistance Prgm 50.23 35.72 0.00 14.51 28.89 E05 Personnel Services 167,465.80 103,106.77 0.00 64,359.03 38.43 10-522-511010 Advertising 2,520.00 1,199.00 0.00 1,321.00 52.42 10-522-511020 Postage 200.00 107.10 0.00 92.90 46.45 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-522-513010 Office Supplies 1,000.00 275.49 0.00 724.51 72.45 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,000.00 21.13 0.00 978.87 97.89 E10 Materials & Supplies 5,105.00 1,602.72 0.00 3,502.28 68.60 10-522-520030 Dues And Publications 1,500.00 616.00 0.00 884.00 58.93 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 6,000.00 0.00 0.00 6,000.00 100.00 10-522-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-522-522020 Professional Services 40,000.00 0.00 40,000.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 47,500.00 616.00 40,000.00 6,884.00 14.49 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 1,187.78 279.86 932.36 38.85 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,187.78 279.86 932.36 38.85 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 522 Vehicle Wash Plan & Protect Svcs -MPO 222,470.80 106,513.27 40,279.86 75,677.67 34.02 530 341.55 Plan & Protect Svc-RedevGrant 109.20 -197.71 -57.89 E25 Repairs & Maintenance 10-530-501020 430.06 Salaries 46,273.40 42,696.49 0.00 3,576.91 7.73 10-530-501050 0.00 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-530-501090 2,548.75 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 3,539.91 2,955.45 0.00 584.46 16.51 10-530-502020 Group Health Insurance 11,720.23 7,979.24 0.00 3,740.99 31.92 10-530-502030 Retirement 5,922.99 4,114.33 0.00 1,808.66 30.54 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 55.08 50.10 0.00 4.98 9.04 10-530-502060 Long Term Disability 137.82 123.64 0.00 14.18 10.29 10-530-502070 Employee Assistance Prgm 21.84 18.17 0.00 3.67 16.80 E05 Personnel Services 67,729.35 57,995.50 0.00 9,733.85 14.37 10-530-511010 Advertising 500.00 180.00 0.00 320.00 64.00 10-530-511020 Postage 150.00 32.89 0.00 117.11 78.07 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 500.00 326.93 0.00 173.07 34.61 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 500.00 391.43 0.00 108.57 21.71 E10 Materials & Supplies 1,700.00 931.25 0.00 768.75 45.22 10-530-520030 Dues And Publications 700.00 0.00 0.00 700.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,250.00 690.64 0.00 1,559.36 69.30 10-530-522020 Professional Services 250.00 0.00 0.00 250.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,800.00 0.00 0.00 19,800.00 100.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 1,000.00 950.60 0.00 49.40 4.94 10-530-524029 Recycling Education 9,000.00 0.00 0.00 9,000.00 100.00 10-530-526060 Refund of Grant Proceeds 78,805.90 0.00 0.00 78,805.90 100.00 10-530-528085 Fair Housing Assistance Prog 400.00 0.00 0.00 400.00 100.00 E15 Contractual Services 112,205.90 1,641.24 0.00 110,564.66 98.54 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 341.55 430.06 109.20 -197.71 -57.89 E25 Repairs & Maintenance 341.55 430.06 109.20 -197.71 -57.89 10-530-550020 NRA -Residential 60,000.00 39,610.54 0.00 20,389.46 33.98 10-530-550030 NRA -Commercial Facade 10,000.00 7,451.25 0.00 2,548.75 25.49 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA -Rental Facade 15,000.00 0.00 0.00 15,000.00 100.00 10-530-550033 HPF Grant -Structural Survey 0.00 0.00 5,872.41 -5,872.41 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 250.00 0.00 0.00 250.00 100.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 85,250.00 47,061.79 5,872.41 32,315.80 37.91 530 Plan & Protect Svc-RedevGrant 267,226.80 108,059.84 5,981.61 153,185.35 57.32 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 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs -Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 10-532-501020 Salaries 183,296.93 112,759.13 0.00 70,537.80 38.48 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,022.21 7,830.13 0.00 6,192.08 44.16 10-532-502020 Group Health Insurance 34,954.14 21,381.30 0.00 13,572.84 38.83 10-532-502030 Retirement 23,462.01 14,433.12 0.00 9,028.89 38.48 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 219.10 136.65 0.00 82.45 37.63 10-532-502060 Long Term Disability 546.15 340.17 0.00 205.98 37.71 10-532-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 260,319.48 160,680.51 0.00 99,638.97 38.28 10-532-511010 Advertising 90.00 45.00 0.00 45.00 50.00 10-532-511020 Postage 150.00 54.91 0.00 95.09 63.39 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 297.62 0.00 1,002.38 77.11 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 139.42 0.00 860.58 86.06 E10 Materials & Supplies 2,625.00 536.95 0.00 2,088.05 79.54 10-532-520030 Dues And Publications 900.00 628.00 0.00 272.00 30.22 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 75.00 0.00 925.00 92.50 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 196,800.00 114,800.00 82,000.00 0.00 0.00 10-532-529010 Special Events 600.00 145.10 0.00 454.90 75.82 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 199,300.00 115,648.10 82,000.00 1,651.90 0.83 10-532-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-532-540060 Cemetery Maintenance 35,748.00 20,182.57 0.00 15,565.43 43.54 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 485.00 0.00 595.00 55.09 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 770.00 899.30 136.44 -265.74 -34.51 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 38,928.00 22,850.87 136.44 15,940.69 40.95 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 501,172.48 299,716.43 82,136.44 119,319.61 23.81 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 171,566.26 103,394.95 0.00 68,171.31 39.73 10-533-501050 Parttime(wo Benefits) 30,000.00 11,883.41 0.00 18,116.59 60.39 10-533-501060 Seasonal Salaries 0.00 2,833.60 0.00 -2,833.60 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 15,419.82 8,690.18 0.00 6,729.64 43.64 10-533-502020 Group Health Insurance 31,986.67 18,164.31 0.00 13,822.36 43.21 10-533-502030 Retirement 21,960.48 13,234.62 0.00 8,725.86 39.73 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 181.40 111.95 0.00 69.45 38.29 10-533-502060 Long Term Disability 499.39 309.53 0.00 189.86 38.02 10-533-502070 Employee Assistance Prgm 76.44 54.36 0.00 22.08 28.89 E05 Personnel Services 273,947.84 160,934.29 0.00 113,013.55 41.25 10-533-511010 Advertising 100.00 168.00 0.00 -68.00 -68.00 10-533-511020 Postage 2,300.00 821.89 0.00 1,478.11 64.27 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 315.99 0.00 684.01 68.40 10-533-514017 COVID-19 0.00 701.37 0.00 -701.37 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 1,026.51 0.00 323.49 23.96 E10 Materials & Supplies 5,190.00 3,033.76 0.00 2,156.24 41.55 10-533-520030 Dues And Publications 500.00 792.00 0.00 -292.00 -58.40 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,400.00 120.00 0.00 1,280.00 91.43 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 28,000.00 15,628.00 0.00 12,372.00 44.19 10-533-522022 Demo 407,849.00 108,304.29 0.00 299,544.71 73.45 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 437,749.00 124,844.29 0.00 312,904.71 71.48 10-533-534010 Telephone 3,701.40 1,775.88 0.00 1,925.52 52.02 E20 Utilities 3,701.40 1,775.88 0.00 1,925.52 52.02 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 456.00 0.00 824.00 64.38 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 13,587.00 853.46 229.32 12,504.22 92.03 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,167.00 1,579.46 229.32 13,358.22 88.07 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 533 PPS - Prop MaintCode Enforce 735,755.24 292,167.68 229.32 443,358.24 60.26 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 327,746.07 154,140.66 0.00 173,605.41 52.97 10-534-501050 Parttime(wo Benefits) 0.00 195.00 0.00 -195.00 0.00 10-534-501060 Seasonal Salaries 0.00 9,317.40 0.00 -9,317.40 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 25,072.57 11,610.65 0.00 13,461.92 53.69 10-534-502020 Group Health Insurance 70,046.46 35,360.85 0.00 34,685.61 49.52 10-534-502030 Retirement 41,951.50 19,287.50 0.00 22,664.00 54.02 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 391.68 181.90 0.00 209.78 53.56 10-534-502060 Long Term Disability 968.67 450.20 0.00 518.47 53.52 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-502070 Employee Assistance Prgm 131.04 93.19 0.00 37.85 28.88 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 471,064.06 235,393.42 0.00 235,670.64 50.03 10-534-511010 Advertising 100.00 31.51 0.00 68.49 68.49 10-534-511020 Postage 1,100.00 112.19 0.00 987.81 89.80 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 128.85 0.00 771.15 85.68 10-534-514017 COVID-19 23,513.00 7,406.20 0.00 16,106.80 68.50 10-534-514030 Small Tools 100.00 48.98 0.00 51.02 51.02 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 836.72 0.00 963.28 53.52 E10 Materials & Supplies 27,628.00 8,564.45 0.00 19,063.55 69.00 10-534-520030 Dues And Publications 3,000.00 849.74 0.00 2,150.26 71.68 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 1,572.20 0.00 3,427.80 68.56 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 8,000.00 2,421.94 0.00 5,578.06 69.73 10-534-534010 Telephone 1,200.00 1,450.12 0.00 -250.12 -20.84 E20 Utilities 1,200.00 1,450.12 0.00 -250.12 -20.84 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 636.26 0.00 543.74 46.08 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 16,050.00 633.29 245.49 15,171.22 94.52 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 17,520.00 1,539.55 245.49 15,734.96 89.81 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 534 Plan & Protect Svcs -Bldg Regs 525,412.06 249,369.48 245.49 275,797.09 52.49 535 Public Works -Central Maintenan 10-535-501020 Salaries 360,379.67 221,753.10 0.00 138,626.57 38.47 10-535-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits) 4,000.00 357.92 0.00 3,642.08 91.05 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,893.25 0.00 606.75 13.48 10-535-501095 Overtime Straieht Pav 500.00 336.39 0.00 163.61 32.72 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-502010 Social Security 28,257.55 16,309.54 0.00 11,948.01 42.28 10-535-502020 Group Health Insurance 78,239.06 48,167.13 0.00 30,071.93 38.44 10-535-502030 Retirement 46,768.60 28,925.88 0.00 17,842.72 38.15 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 436.97 271.95 0.00 165.02 37.76 10-535-502060 Long Term Disability 1,079.32 672.15 0.00 407.17 37.72 10-535-502070 Employee Assistance Prgm 152.88 108.71 0.00 44.17 28.89 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 528,783.41 325,265.38 0.00 203,518.03 38.49 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 2.00 0.00 48.00 96.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 422.74 0.00 1,077.26 71.82 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 7,000.00 1,081.68 0.00 5,918.32 84.55 10-535-517010 Operational Supplies 5,000.00 2,786.23 0.00 2,213.77 44.28 E10 Materials & Supplies 13,640.00 4,292.65 0.00 9,347.35 68.53 10-535-520030 Dues And Publications 350.00 180.00 0.00 170.00 48.57 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 0.00 0.00 2,000.00 100.00 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,850.00 180.00 0.00 2,670.00 93.68 10-535-531010 Electricity 5,660.00 3,133.69 0.00 2,526.31 44.63 10-535-533010 Natural Gas 4,417.00 1,765.80 0.00 2,651.20 60.02 10-535-534010 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 Water 1,442.00 727.37 0.00 714.63 49.56 E20 Utilities 11,739.00 5,626.86 0.00 6,112.14 52.07 10-535-540010 Building & Grounds Maint. 14,983.00 13,430.65 0.00 1,552.35 10.36 10-535-541010 Veh & Equip Parts Etc 557,000.00 401,048.84 0.00 155,951.16 28.00 10-535-541015 Vehicle Hail Damage Repair 102,193.19 37,553.76 0.00 64,639.43 63.25 10-535-546010 Clothing Expense 5,500.00 5,747.42 0.00 -247.42 -4.50 10-535-547010 Equipment Maintenance 1,000.00 759.50 0.00 240.50 24.05 10-535-547020 Maintenance Agreements 13,120.00 11,734.56 178.70 1,206.74 9.20 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 693,896.19 470,274.73 178.70 223,442.76 32.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 535 Public Works -Central Maintenan 1,250,908.60 805,639.62 178.70 445,090.28 35.58 Page 30 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 540 Public Works -Admin 10-540-501020 Salaries 223,146.93 137,293.04 0.00 85,853.89 38.47 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 17,070.74 10,408.95 0.00 6,661.79 39.02 10-540-502020 Group Health Insurance 28,540.74 13,188.00 0.00 15,352.74 53.79 10-540-502030 Retirement 28,562.81 17,573.56 0.00 10,989.25 38.47 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 268.06 166.65 0.00 101.41 37.83 10-540-502060 Long Term Disability 541.50 334.80 0.00 206.70 38.17 10-540-502070 Employee Assistance Prgm 65.52 46.59 0.00 18.93 28.89 E05 Personnel Services 298,415.53 179,230.82 0.00 119,184.71 39.94 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 80,000.00 47,385.88 0.00 32,614.12 40.77 10-540-514017 COVID-19 0.00 2,628.56 0.00 -2,628.56 0.00 10-540-514040 Food 200.00 1,134.51 0.00 -934.51 -467.26 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 82,000.00 51,148.95 0.00 30,851.05 37.62 10-540-520030 Dues And Publications 849.39 849.39 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,800.61 398.00 0.00 2,402.61 85.79 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,850.00 1,247.39 0.00 2,602.61 67.60 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 400.00 190.10 81.84 128.06 32.02 E25 Repairs & Maintenance 400.00 190.10 81.84 128.06 32.02 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works -Admin 384,665.53 231,817.26 81.84 152,766.43 39.71 541 Public Works -Engineering 10-541-501020 Salaries 831,670.27 486,130.38 0.00 345,539.89 41.55 10-541-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 1.223.81 0.00 -823.81 -205.95 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-501095 Overtime Straight Pay 0.00 117.72 0.00 -117.72 0.00 10-541-502010 Social Security 63,653.38 34,780.70 0.00 28,872.68 45.36 10-541-502020 Group Health Insurance 136,643.93 79,217.30 0.00 57,426.63 42.03 10-541-502030 Retirement 106,504.99 62,218.94 0.00 44,286.05 41.58 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 998.78 575.28 0.00 423.50 42.40 10-541-502060 Long Term Disability 2,416.91 1,419.80 0.00 997.11 41.26 10-541-502070 Employee Assistance Prgm 262.08 186.38 0.00 75.70 28.88 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,148,606.06 671,926.03 0.00 476,680.03 41.50 10-541-511010 Advertising 400.00 325.00 0.00 75.00 18.75 10-541-511020 Postage 350.00 52.68 0.00 297.32 84.95 10-541-512010 Printing 0.00 87.00 0.00 -87.00 0.00 10-541-512020 Copies 50.00 0.11 0.00 49.89 99.78 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 4,000.00 801.92 0.00 3,198.08 79.95 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 150.00 64.29 0.00 85.71 57.14 10-541-515070 Const & Inspect Supplies 1,000.00 240.37 0.00 759.63 75.96 10-541-515080 Surveying Supplies 1,500.00 83.01 0.00 1,416.99 94.47 10-541-517010 Operational Supplies 1,900.00 240.28 0.00 1,659.72 87.35 E10 Materials & Supplies 9,700.00 1,894.66 0.00 7,805.34 80.47 10-541-520030 Dues And Publications 4,000.00 3,271.00 0.00 729.00 18.23 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,000.00 660.00 0.00 3,340.00 83.50 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 63.00 0.00 437.00 87.40 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,000.00 3,994.00 0.00 5,006.00 55.62 10-541-534010 Telephone 500.00 308.38 0.00 191.62 38.32 E20 Utilities 500.00 308.38 0.00 191.62 38.32 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 1,822.01 0.00 -322.01 -21.47 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 9,800.00 8,878.96 268.36 652.68 6.66 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 13,300.00 12,275.97 268.36 755.67 5.68 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-576031 Dues And Publications Mise Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 0.00 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 904.00 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 0.00 Public Works -Engineering 1,181,106.06 690,399.04 268.36 490,438.66 41.52 542 1,238.78 Public Works -Street 10-542-523010 Equipment Rentlease 200.00 75.00 0.00 10-542-501020 62.50 Salaries 1,263,093.87 786,864.65 0.00 476,229.22 37.70 10-542-501060 10-542-529070 Seasonal Salaries 20,000.00 7,543.30 0.00 12,456.70 62.28 10-542-501070 Stand-by Plan 5,000.00 2,596.00 0.00 2,404.00 48.08 10-542-501090 Overtime 30,000.00 15,014.21 0.00 14,985.79 49.95 10-542-501095 Overtime Straight Pay 500.00 284.79 0.00 215.21 43.04 10-542-502010 Social Security 100,872.43 58,994.76 0.00 41,877.67 41.52 10-542-502020 Group Health Insurance 271,017.18 166,369.28 0.00 104,647.90 38.61 10-542-502030 Retirement 166,220.01 102,221.73 0.00 63,998.28 38.50 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,518.37 949.51 0.00 568.86 37.47 10-542-502060 Long Term Disability 3,711.17 2,320.48 0.00 1,390.69 37.47 10-542-502070 Employee Assistance Prgm 622.44 442.65 0.00 179.79 28.88 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 1,901,866.31 1,182,712.20 0.00 719,154.11 37.81 10-542-511010 Advertising 1,000.00 548.30 0.00 451.70 45.17 10-542-511020 Postage 150.00 4.20 0.00 145.80 97.20 10-542-512010 Printing 90.00 137.00 0.00 -47.00 -52.22 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 195.19 0.00 1,404.81 87.80 10-542-514017 COVID-19 0.00 2,596.60 0.00 -2,596.60 0.00 10-542-514020 Chemicals 382,599.10 357,573.70 40,652.22 -15,626.82 -4.08 10-542-514030 Small Tools 9,000.00 6,545.73 0.00 2,454.27 27.27 10-542-514040 Food 2,195.04 2,195.04 0.00 0.00 0.00 10-542-515010 Stormwater Material 88.40 88.40 0.00 0.00 0.00 10-542-515020 Street Materials 395,117.46 246,832.34 0.00 148,285.12 37.53 10-542-515040 First Aid Supplies 500.00 23.73 0.00 476.27 95.25 10-542-515060 Weed Control 1,500.00 640.00 0.00 860.00 57.33 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 2,247.48 0.00 2,752.52 55.05 E10 Materials & Supplies 799,050.00 619,627.71 40,652.22 138,770.07 17.37 10-542-520030 Dues And Publications 1,320.00 835.00 0.00 485.00 36.74 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 904.00 0.00 6,776.00 88.23 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,000.00 12,761.22 0.00 1,238.78 8.85 10-542-523010 Equipment Rentlease 200.00 75.00 0.00 125.00 62.50 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 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 23,200.00 14,575.22 0.00 8,624.78 37.18 10-542-531010 Electricity 28,364.00 13,395.67 0.00 14,968.33 52.77 10-542-531020 Street Lights 610,000.00 348,283.15 0.00 261,716.85 42.90 10-542-533010 Natural Gas 10,000.00 9,351.57 0.00 648.43 6.48 10-542-534010 Telephone 580.00 774.29 8.00 -202.29 -34.88 10-542-535010 Water 13,390.00 2,713.14 0.00 10,676.86 79.74 E20 Utilities 662,334.00 374,517.82 8.00 287,808.18 43.45 10-542-540010 Building & Grounds Maint. 12,000.00 12,373.82 120.00 -493.82 -4.12 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 30,000.00 16,902.84 0.00 13,097.16 43.66 10-542-542030 Signs & Marking Paint 51,800.00 21,189.43 25,058.45 5,552.12 10.72 10-542-546010 Clothing Expense 15,000.00 8,809.49 0.00 6,190.51 41.27 10-542-547010 Equipment Maintenance 3,140.00 265.00 0.00 2,875.00 91.56 10-542-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 252.64 0.00 747.36 74.74 E25 Repairs & Maintenance 120,300.00 66,777.22 25,178.45 28,344.33 23.56 10-542-572010 Purchase Of Vehicles 13,000.00 13,000.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 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 13,000.00 13,000.00 0.00 0.00 0.00 542 Public Works -Street 3,519,750.31 2,271,210.17 65,838.67 1,182,701.47 33.60 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 2,206.26 0.00 12,793.74 85.29 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 79,111.25 79,111.25 0.00 0.00 0.00 10-700-590075 Transit Subsidy 579,709.76 579,709.76 0.00 0.00 0.00 10-700-590080 Transfer To Amb Sery 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 673,821.01 661,027.27 0.00 12,793.74 1.90 700 Transfers & Subsidies 673,821.01 661,027.27 0.00 12,793.74 1.90 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhclegp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhclegp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhclegp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhclegp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhclegp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhclegp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Canvhclean-street 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 31,702.50 25,702.50 0.00 6,000.00 18.93 10-990-575023 Fire Station 4 Rehab 348,252.57 14,692.97 322,220.07 11,339.53 3.26 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 0.00 0.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-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 103,937.70 36,848.59 600.00 66,489.11 63.97 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 3,584,287.77 77,244.06 322,820.07 3,184,223.64 88.84 990 Capital Projects 3,584,287.77 77,244.06 322,820.07 3,184,223.64 88.84 995 ARPA 10-995-501020 Salaries 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 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 39,138,708.73 21,459,679.58 1,046,650.08 16,632,379.07 42.50 GL - Trial Balance by Acct Type and Full Acct Number (07/12/2021 - 3:09 PM) Page 35