Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2020-12 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 12/07/20 09:47:01 Period 01 - 13 Fiscal Year 2020 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 66,150.00 0.00 -225.00 -0.34 10-110-501015 Salary -Prosecuting Attorney 34,999.92 34,999.92 0.00 0.00 0.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits) 13,934.05 6,303.62 0.00 7,630.43 54.76 10-110-502010 Social Security 8,786.71 7,722.15 0.00 1,064.56 12.12 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 123,717.27 115,247.28 0.00 8,469.99 6.85 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 70.00 17.25 0.00 52.75 75.36 10-110-512010 Printing 325.00 295.00 0.00 30.00 9.23 10-110-512020 Copies 30.00 8.69 0.00 21.31 71.03 10-110-513010 Office Supplies 695.00 672.73 0.00 22.27 3.20 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 1,120.00 993.67 0.00 126.33 11.28 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 890.00 831.60 0.00 58.40 6.56 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,939.84 1,928.67 0.00 11.17 0.58 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,729.84 7,468.17 0.00 261.67 3.39 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 88.00 88.66 0.00 -0.66 -0.75 E25 Repairs & Maintenance 88.00 88.66 0.00 -0.66 -0.75 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 132,655. L 1 123,797.78 0.00 8,857.33 6.68 120 City Clerk 10-120-501020 Salaries 49,774.86 49,989.89 0.00 -215.03 -0.43 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,807.78 3,409.59 0.00 398.19 10.46 10-120-502020 Group Health Insurance 11,509.33 11,210.76 0.00 298.57 2.59 10-120-502030 Retirement 6,072.53 6,110.33 0.00 -37.80 -0.62 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 59.98 60.13 0.00 -0.15 -0.25 10-120-502060 Long Term Disability 149.33 149.61 0.00 -0.28 -0.19 10-120-502070 Employee Assistance Prgm 28.06 20.15 0.00 7.91 28.19 E05 Personnel Services 71,451.86 71,000.45 0.00 451.41 0.63 10-120-511020 Postage 200.00 177.76 0.00 22.24 11.12 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 280.58 0.00 19.42 6.47 10-120-513010 Office Supplies 200.00 136.45 0.00 63.55 31.78 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 594.79 0.00 105.21 15.03 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 350.00 0.00 50.00 12.50 10-120-522020 Professional Services 200.00 209.21 0.00 -9.21 -4.61 10-120-529030 Election Expense 18,579.79 25,496.42 0.00 -6,916.63 -37.23 E15 Contractual Services 19,254.79 26,120.63 0.00 -6,865.84 -35.66 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 4,228.00 10,372.25 0.00 -6,144.25 -145.32 E25 Repairs & Maintenance 4,228.00 10,372.25 0.00 -6,144.25 -145.32 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 95,634.65 108,088.12 0.00 -12,453.47 -13.02 140 City Administrator 10-140-501020 Salaries 215,571.09 205,931.77 0.00 9,639.32 4.47 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 (12/07/2020 - 9:47 AM) 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 16,491.19 13,573.81 0.00 2,917.38 17.69 10-140-502020 Group Health Insurance 22,787.32 22,107.42 0.00 679.90 2.98 10-140-502030 Retirement 26,299.67 25,173.09 0.00 1,126.58 4.28 10-140-502040 Workers Compensation 201.21 201.21 0.00 0.00 0.00 10-140-502050 Life Insurance 107.71 107.31 0.00 0.40 0.37 10-140-502060 Long Term Disability 267.81 266.12 0.00 1.69 0.63 10-140-502070 Employee Assistance Prgm 56.12 40.31 0.00 15.81 28.17 E05 Personnel Services 281,782.12 267,401.04 0.00 14,381.08 5.10 10-140-511010 Advertising 45.00 43.75 0.00 1.25 2.78 10-140-511020 Postage 150.00 65.85 0.00 84.15 56.10 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 51.86 0.00 98.14 65.43 10-140-513010 Office Supplies 595.00 331.26 0.00 263.74 44.33 10-140-514017 COVID-19 2,789.03 3,120.58 0.00 -331.55 -11.89 10-140-517010 Operational Supplies 678.74 661.74 0.00 17.00 2.50 E10 Materials & Supplies 4,507.77 4,275.04 0.00 232.73 5.16 10-140-520030 Dues And Publications 700.00 433.70 0.00 266.30 38.04 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,110.00 1,902.00 0.00 208.00 9.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 400.00 159.17 0.00 240.83 60.21 E15 Contractual Services 3,210.00 2,494.87 0.00 715.13 22.28 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 268.00 273.46 0.00 -5.46 -2.04 E25 Repairs & Maintenance 268.00 273.46 0.00 -5.46 -2.04 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 289,767.89 274,444.41 0.00 15,323.48 5.29 149 Entitlement Grant 10-149-501020 Salaries 60,104.36 58,264.20 0.00 1,840.16 3.06 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,373.98 3,940.60 0.00 -566.62 -16.79 10-149-502020 Group Health Insurance 14,611.44 14,763.61 0.00 -152.17 -1.04 10-149-502030 Retirement 5,380.73 5,580.53 0.00 -199.80 -3.71 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502050 Life Insurance 53.24 69.31 0.00 -16.07 -30.18 10-149-502060 Long Term Disability 131.82 172.70 0.00 -40.88 -31.01 10-149-502070 Employee Assistance Program 28.06 20.15 0.00 7.91 28.19 E05 Personnel Services 83,770.66 82,898.13 0.00 872.53 1.04 10-149-511010 Advertising 1,884.50 2,369.60 0.00 -485.10 -25.74 10-149-511020 Postage 500.00 331.40 0.00 168.60 33.72 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 538.12 0.00 461.88 46.19 10-149-517010 Operational Supplies 525.00 640.64 0.00 -115.64 -22.03 E10 Materials & Supplies 3,909.50 3,879.76 0.00 29.74 0.76 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,615.50 37.35 0.00 1,578.15 97.69 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 31,100.00 36,319.50 0.00 -5,219.50 -16.78 10-149-528012 Housing Rehab -Energy Efficient 20,900.00 0.00 0.00 20,900.00 100.00 10-149-528020 Housing Assistance 131,600.00 132,780.00 0.00 -1,180.00 -0.90 10-149-528030 Public Improvement 319,774.25 138,406.50 6,920.33 174,447.42 54.55 10-149-528040 Neighborhood Redevelopmnt 100,000.00 14,027.00 0.00 85,973.00 85.97 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 5,000.00 0.00 0.00 5,000.00 100.00 10-149-528080 Homeless Objectives 13,322.83 0.00 0.00 13,322.83 100.00 E15 Contractual Services 623,312.58 321,570.35 6,920.33 294,821.90 47.30 10-149-547020 Maintenance Agreements 150.00 127.77 0.00 22.23 14.82 E25 Repairs & Maintenance 150.00 127.77 0.00 22.23 14.82 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 711,142.74 408,476.01 6,920.33 295,746.40 41.59 150 City Attorney 10-150-501020 Salaries 213,931.99 202,081.86 0.00 11,850.13 5.54 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,365.80 14,600.49 0.00 1,765.31 10.79 10-150-502020 Groun Health Insurance 34.764.83 30.131.47 0.00 4.633.36 13.33 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502030 Retirement 26,099.70 22,384.92 0.00 3,714.78 14.23 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 257.04 231.51 0.00 25.53 9.93 10-150-502060 Long Term Disability 445.29 494.37 0.00 -49.08 -11.02 10-150-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 292,179.62 270,215.90 0.00 21,963.72 7.52 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 170.85 0.00 329.15 65.83 10-150-512010 Printing 300.00 271.88 0.00 28.12 9.37 10-150-512020 Copies 50.00 9.64 0.00 40.36 80.72 10-150-513010 Office Supplies 2,800.00 2,766.37 0.00 33.63 1.20 10-150-514017 COVID-19 2,024.60 2,024.60 0.00 0.00 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 5,674.60 5,243.34 0.00 431.26 7.60 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,200.00 6,730.86 0.00 4,469.14 39.90 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 1,204.65 0.00 3,795.35 75.91 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 24,000.00 15,677.16 0.00 8,322.84 34.68 10-150-525030 Litigation Expenses 500.00 220.00 0.00 280.00 56.00 E15 Contractual Services 40,700.00 23,832.67 0.00 16,867.33 41.44 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 568.00 328.83 0.00 239.17 42.11 E25 Repairs & Maintenance 568.00 328.83 0.00 239.17 42.11 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 339,122.22 299,620.74 0.00 39,501.48 11.65 160 Municipal Court 10-160-501010 Salary -elected Officals 34,999.92 34,999.92 0.00 0.00 0.00 10-160-501020 Salaries 120,182.91 117,630.43 0.00 2,552.48 2.12 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 6,430.30 0.00 569.70 8.14 10-160-501090 Overtime 1,500.00 872.03 0.00 627.97 41.86 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Securitv 12.521.74 11.796.24 0.00 725.50 5.79 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502020 Group Health Insurance 30,420.85 23,886.73 0.00 6,534.12 21.48 10-160-502030 Retirement 14,845.31 10,358.47 0.00 4,486.84 30.22 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 146.88 136.16 0.00 10.72 7.30 10-160-502060 Long Term Disability 360.59 335.09 0.00 25.50 7.07 10-160-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-160-503020 Unemployment Compensation 0.00 33.91 0.00 -33.91 0.00 E05 Personnel Services 222,260.55 206,737.94 0.00 15,522.61 6.98 10-160-511010 Advertising 50.00 50.00 0.00 0.00 0.00 10-160-511020 Postage 3,550.00 2,441.10 0.00 1,108.90 31.24 10-160-512010 Printing 443.77 308.00 0.00 135.77 30.59 10-160-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-160-513010 Office Supplies 5,250.00 2,272.73 0.00 2,977.27 56.71 10-160-514017 COVID-19 0.00 341.55 0.00 -341.55 0.00 E10 Materials & Supplies 9,293.84 5,413.45 0.00 3,880.39 41.75 10-160-520025 Security 10,000.00 9,044.86 0.00 955.14 9.55 10-160-520030 Dues And Publications 250.00 120.00 0.00 130.00 52.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 300.00 0.00 1,200.00 80.00 10-160-522020 Professional Services 7,420.00 4,080.05 0.00 3,339.95 45.01 10-160-525005 Appointed Counsel 4,000.00 3,501.07 0.00 498.93 12.47 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 23,460.00 17,045.98 0.00 6,414.02 27.34 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,388.00 5,837.79 0.00 550.21 8.61 E25 Repairs & Maintenance 6,388.00 5,837.79 0.00 550.21 8.61 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 261,402.39 235,035.16 0.00 26,367.23 10.09 170 Human Resources 10-170-501020 Salaries 212,474.64 213,363.58 0.00 -888.94 -0.42 10-170-501050 Parttime(wo Benefits) 13,000.00 15,516.90 0.00 -2,516.90 -19.36 10-170-501060 Seasonal Salaries 20,000.00 0.00 0.00 20,000.00 100.00 10-170-501090 Overtime 100.00 40.91 0.00 59.09 59.09 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 18,786.46 17,195.92 0.00 1,590.54 8.47 10-170-502020 Group Health Insurance 26,241.76 25,434.86 0.00 806.90 3.07 10-170-502030 Retirement 25.934.11 26.084.72 0.00 -150.61 -0.58 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 255.82 256.15 0.00 -0.33 -0.13 10-170-502060 Long Term Disability 554.47 551.31 0.00 3.16 0.57 10-170-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-170-503020 Unemployment Compensation 0.00 147.00 0.00 -147.00 0.00 E05 Personnel Services 317,757.13 298,977.53 0.00 18,779.60 5.91 10-170-511010 Advertising 0.00 49.00 0.00 -49.00 0.00 10-170-511020 Postage 150.00 527.65 0.00 -377.65 -251.77 10-170-512010 Printing 740.00 146.87 0.00 593.13 80.15 10-170-512020 Copies 500.00 506.34 0.00 -6.34 -1.27 10-170-513010 Office Supplies 1,000.00 469.66 0.00 530.34 53.03 10-170-514017 COVID-19 1,596.33 4,789.00 0.00 -3,192.67 -200.00 10-170-517010 Operational Supplies 800.00 548.55 0.00 251.45 31.43 E10 Materials & Supplies 4,786.33 7,037.07 0.00 -2,250.74 -47.02 10-170-520030 Dues And Publications 1,000.00 616.40 0.00 383.60 38.36 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 3,594.87 0.00 -94.87 -2.71 10-170-520070 Training And Education 5,220.00 5,170.00 0.00 50.00 0.96 10-170-520080 Tuition Reimbursement 3,690.00 100.00 0.00 3,590.00 97.29 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 220.00 0.00 280.00 56.00 10-170-522020 Professional Services 4,000.00 4,576.35 0.00 -576.35 -14.41 10-170-529010 Special Events 800.00 313.32 0.00 486.68 60.84 10-170-529015 Human Relations Commission 500.00 420.00 0.00 80.00 16.00 E15 Contractual Services 19,210.00 15,010.94 0.00 4,199.06 21.86 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 268.00 267.79 0.00 0.21 0.08 E25 Repairs & Maintenance 268.00 267.79 0.00 0.21 0.08 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 342,021.46 321,293.33 0.00 20,728.13 6.06 180 Finance Department 10-180-501020 Salaries 649,002.72 570,338.90 0.00 78,663.82 12.12 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 49,648.71 42,107.86 0.00 7,540.85 15.19 10-180-502020 GrOUD Health Insurance 99.910.43 85.434.78 0.00 14.475.65 14.49 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502030 Retirement 79,178.33 61,114.20 0.00 18,064.13 22.81 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 807.47 668.25 0.00 139.22 17.24 10-180-502060 Long Term Disability 1,878.11 1,625.14 0.00 252.97 13.47 10-180-502070 Employee Assistance Prgm 329.71 236.84 0.00 92.87 28.17 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 881,254.31 762,024.80 0.00 119,229.51 13.53 10-180-511010 Advertising 1,000.00 277.75 0.00 722.25 72.23 10-180-511020 Postage 10,000.00 10,053.75 0.00 -53.75 -0.54 10-180-511021 Mail Machine Cost 3,000.00 2,570.54 0.00 429.46 14.32 10-180-512010 Printing 3,300.00 3,500.85 0.00 -200.85 -6.09 10-180-512020 Copies 1,300.00 357.57 0.00 942.43 72.49 10-180-512021 Copy Machine Cost 200.00 648.87 0.00 -448.87 -224.44 10-180-513010 Office Supplies 3,600.00 665.51 0.00 2,934.49 81.51 10-180-514017 COVID-19 3,370.71 3,439.62 0.00 -68.91 -2.04 10-180-517010 Operational Supplies 3,600.00 5,583.16 0.00 -1,983.16 -55.09 E10 Materials & Supplies 29,370.71 27,097.62 0.00 2,273.09 7.74 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,300.00 2,155.00 0.00 145.00 6.30 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 7,975.76 1,785.82 0.00 6,189.94 77.61 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 38,214.82 51,215.73 0.00 -13,000.91 -34.02 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 210.96 0.00 89.04 29.68 E15 Contractual Services 48,790.58 55,367.51 0.00 -6,576.93 -13.48 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,251.61 0.00 8.39 0.67 E25 Repairs & Maintenance 1,260.00 1,251.61 0.00 8.39 0.67 10-180-572020 Purchase Of Equipment 0.00 3,413.00 0.00 -3,413.00 0.00 E70 Capital Purchases 0.00 3,413.00 0.00 -3,413.00 0.00 180 Finance Department 960,675.60 849,154.54 0.00 111,521.06 11.61 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 39.589.29 36.967.43 0.00 2.621.86 6.62 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 39,589.29 36,967.43 0.00 2,621.86 6.62 10-185-514010 Gas 12,000.00 7,561.48 0.00 4,438.52 36.99 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 58,567.55 0.00 -58,567.55 0.00 10-185-514016 Flooding 0.00 1,326.14 0.00 -1,326.14 0.00 E10 Materials & Supplies 12,000.00 67,455.17 0.00 -55,455.17 -462.13 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 366,004.61 352,193.63 0.00 13,810.98 3.77 10-185-521020 Insurance Deductible 30,000.00 29,128.90 0.00 871.10 2.90 10-185-521030 Self Ins Prop & Casualty 40,000.00 102,571.49 0.00 -62,571.49 -156.43 10-185-521060 Drugalcohol screening 3,564.00 3,091.80 0.00 472.20 13.25 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 30,685.00 30,684.96 0.00 0.04 0.00 10-185-522023 LCRA Reimbursement 229,700.65 229,700.65 0.00 0.00 0.00 10-185-522025 JCTV 55,000.00 55,000.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 92,240.48 0.00 -45,240.48 -96.26 10-185-527020 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 7,000.00 8,525.65 0.00 -1,525.65 -21.80 E15 Contractual Services 993,954.26 1,088,137.56 0.00 -94,183.30 -9.48 10-185-531010 Electricity 33,000.00 29,462.73 0.00 3,537.27 10.72 10-185-533010 Natural Gas 6,200.00 4,512.06 0.00 1,687.94 27.22 10-185-535010 Water 7,250.00 6,773.81 0.00 476.19 6.57 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 46,450.00 40,748.60 0.00 5,701.40 12.27 10-185-540010 Building & Grounds Maint. 42,925.00 40,376.35 0.00 2,548.65 5.94 10-185-540015 Amtrak Station 13,000.00 13,012.51 0.00 -12.51 -0.10 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,100.00 1,872.00 0.00 228.00 10.86 E25 Repairs & Maintenance 83,025.00 80,260.86 0.00 2,764.14 3.33 10-185-550010 Miscellaneous 5,000.00 1,279.95 0.00 3,720.05 74.40 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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-550040 Public Art 500.00 500.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 1,000.00 0.00 0.00 1,000.00 100.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 NeighborhdImprovement 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 16,500.00 11,779.95 0.00 4,720.05 28.61 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-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 185 Non -Departmental 1,191,518.55 1,325,349.57 0.00 -133,831.02 -11.23 190 Information Technology Svcs 10-190-501020 Salaries 560,680.59 563,248.37 0.00 -2,567.78 -0.46 10-190-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits) 0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 107.32 0.00 -107.32 0.00 10-190-502010 Social Security 42,983.86 41,275.02 0.00 1,708.84 3.98 10-190-502020 Group Health Insurance 85,587.16 83,181.73 0.00 2,405.43 2.81 10-190-502030 Retirement 68,549.43 68,860.13 0.00 -310.70 -0.45 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 671.67 674.56 0.00 -2.89 -0.43 10-190-502060 Long Term Disability 1,633.80 1,632.21 0.00 1.59 0.10 10-190-502070 Employee Assistance Prgm 266.57 191.51 0.00 75.06 28.16 E05 Personnel Services 762,931.29 760,529.06 0.00 2,402.23 0.31 10-190-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 9.83 0.00 10.17 50.85 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 549.07 0.00 350.93 38.99 10-190-514017 COVID-19 10,116.86 6,756.76 0.00 3,360.10 33.21 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 2,457.55 0.00 42.45 1.70 E10 Materials & Supplies 13,686.86 9,773.21 0.00 3,913.65 28.59 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 124.99 0.00 175.01 58.34 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 1,849.50 1,243.90 0.00 605.60 32.74 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 10,000.00 5,357.21 0.00 4,642.79 46.43 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet Tl Web 18,800.00 19,586.24 0.00 -786.24 -4.18 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 35,349.50 30,627.34 0.00 4,722.16 13.36 10-190-534010 Telephone 70,000.00 76,195.72 0.00 -6,195.72 -8.85 E20 Utilities 70,000.00 76,195.72 0.00 -6,195.72 -8.85 10-190-545010 Software Licensemaint 237,200.00 227,381.64 0.00 9,818.36 4.14 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 Maintenance Agreements 23,000.00 19,532.45 0.00 3,467.55 15.08 E25 Repairs & Maintenance 264,200.00 246,914.09 0.00 17,285.91 6.54 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 1,146,167.65 1,124,039.42 0.00 22,128.23 1.93 300 Police Department 10-300-501020 Salaries 4,398,889.08 4,395,103.52 0.00 3,785.56 0.09 10-300-501030 Holiday Pay 136,093.81 96,687.02 0.00 39,406.79 28.96 10-300-501040 Part-time (wbenefits) 33,090.22 0.00 0.00 33,090.22 100.00 10-300-501050 Parttime(wo Benefits) 66,208.36 55,410.51 0.00 10,797.85 16.31 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 4,388.00 0.00 612.00 12.24 10-300-501090 Overtime 356,421.07 246,699.48 0.00 109,721.59 30.78 10-300-501095 Overtime Straight Pay 14,000.00 14,336.95 0.00 -336.95 -2.41 10-300-502010 Social Security 374,784.70 349,467.77 0.00 25,316.93 6.76 10-300-502020 Group Health Insurance 830,255.11 778,130.81 0.00 52,124.30 6.28 10-300-502030 Retirement 847,484.81 804,742.85 0.00 42,741.96 5.04 10-300-502040 Workers Compensation 75,085.92 75,085.92 0.00 0.00 0.00 10-300-502050 Life Insurance 5,574.10 5,111.69 0.00 462.41 8.30 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502060 Long Term Disability 13,176.12 12,641.72 0.00 534.40 4.06 10-300-502070 Employee Assistance Prgm 2,539.43 1,824.39 0.00 715.04 28.16 10-300-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,158,602.73 6,839,630.63 0.00 318,972.10 4.46 10-300-511010 Advertising 5,325.00 4,606.97 0.00 718.03 13.48 10-300-511020 Postage 1,395.00 1,530.24 0.00 -135.24 -9.69 10-300-512010 Printing 5,952.00 6,059.75 0.00 -107.75 -1.81 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 860.00 466.97 0.00 393.03 45.70 10-300-513010 Office Supplies 9,770.50 13,973.76 0.00 -4,203.26 -43.02 10-300-514010 Gas 148,800.00 126,888.15 0.00 21,911.85 14.73 10-300-514017 COVID-19 1,236.39 1,071.39 0.00 165.00 13.35 10-300-514040 Food 1,001.00 1,560.14 0.00 -559.14 -55.86 10-300-515040 First Aid Supplies 1,209.00 1,742.05 0.00 -533.05 -44.09 10-300-516010 Ammunition & Firearms Supplies 49,465.35 50,506.86 0.00 -1,041.51 -2.11 10-300-516020 Dare Program 15,795.00 7,560.55 0.00 8,234.45 52.13 10-300-516030 Special Investigation 2,325.00 2,325.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 10,115.56 2,953.00 0.00 7,162.56 70.81 10-300-517010 Operational Supplies 40,038.54 36,564.75 0.00 3,473.79 8.68 E10 Materials & Supplies 293,288.34 257,809.58 0.00 35,478.76 12.10 10-300-520030 Dues And Publications 5,522.00 5,589.90 0.00 -67.90 -1.23 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 71,008.00 45,141.82 0.00 25,866.18 36.43 10-300-520080 Tuition Reimbursement 11,925.00 14,499.00 0.00 -2,574.00 -21.58 10-300-520090 Recruitment 325.00 1,339.88 0.00 -1,014.88 -312.27 10-300-521040 Medical Claimsservices 5,510.00 5,208.50 0.00 301.50 5.47 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 13,915.00 13,148.36 0.00 766.64 5.51 10-300-522026 Drug Forfeiture - Justice 15,000.00 15,000.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 51,487.78 0.00 -51,487.78 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 1,696.00 1,031.39 0.00 664.61 39.19 E15 Contractual Services 124,901.00 152,446.63 0.00 -27,545.63 -22.05 10-300-531010 Electricity 44,640.00 44,553.55 0.00 86.45 0.19 10-300-533010 Natural Gas 1,116.00 970.04 0.00 145.96 13.08 10-300-534010 Telephone 22,405.56 20,835.93 0.00 1,569.63 7.01 10-300-535010 Water 3,348.00 3,346.50 0.00 1.50 0.04 E20 Utilities 71,509.56 69,706.02 0.00 1,803.54 2.52 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint. 50,700.00 59,041.49 0.00 -8,341.49 -16.45 10-300-541030 Vehicle Wash 9,000.00 9,769.50 0.00 -769.50 -8.55 10-300-544010 K-9 Operations 17,740.00 24,350.89 0.00 -6,610.89 -37.27 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 30,249.82 0.00 -7,650.82 -33.85 10-300-545010 Software Licensemaint 54,764.01 54,757.00 0.00 7.01 0.01 10-300-546010 Clothing Expense 40,327.56 27,664.62 0.00 12,662.94 31.40 10-300-546020 Uniform Cleaning 21,715.00 22,183.11 0.00 -468.11 -2.16 10-300-547010 Equipment Maintenance 13,025.50 16,732.56 0.00 -3,707.06 -28.46 10-300-547020 Maintenance Agreements 59,140.00 49,748.87 0.00 9,391.13 15.88 10-300-547030 Radio Maintenance 4,970.00 6,931.03 0.00 -1,961.03 -39.46 E25 Repairs & Maintenance 293,981.07 301,428.89 0.00 -7,447.82 -2.53 10-300-572010 Purchase Of Vehicles 202,860.00 0.00 0.00 202,860.00 100.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 17,544.00 8,772.00 0.00 8,772.00 50.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 6,940.20 6,940.20 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 37,268.00 33,809.99 0.00 3,458.01 9.28 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 24,633.62 12,942.66 0.00 11,690.96 47.46 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 4,626.80 4,626.80 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software -morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software -prof 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 293,872.62 67,091.65 0.00 226,780.97 77.17 300 Police Department 8,236,155.32 7,688,113.40 0.00 548,041.92 6.65 Page 13 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-501020 Salaries 395,805.07 402,762.92 0.00 -6,957.85 -1.76 10-310-501030 Holiday Pay 15,214.96 3,822.35 0.00 11,392.61 74.88 10-310-501090 Overtime 35,126.00 57,507.01 0.00 -22,381.01 -63.72 10-310-501095 Overtime Straight Pay 586.00 1,155.58 0.00 -569.58 -97.20 10-310-502010 Social Security 34,175.00 33,013.20 0.00 1,161.80 3.40 10-310-502020 Group Health Insurance 89,435.68 86,713.99 0.00 2,721.69 3.04 10-310-502030 Retirement 80,858.50 83,908.79 0.00 -3,050.29 -3.77 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 481.03 481.22 0.00 -0.19 -0.04 10-310-502060 Long Term Disability 1,187.04 1,189.32 0.00 -2.28 -0.19 10-310-502070 Employee Assistance Prgm 224.48 161.28 0.00 63.20 28.15 E05 Personnel Services 659,646.62 677,268.52 0.00 -17,621.90 -2.67 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-517010 Operational Supplies 10,233.92 5,032.14 0.00 5,201.78 50.83 E10 Materials & Supplies 10,233.92 5,032.14 0.00 5,201.78 50.83 10-310-520070 Training And Education 4,650.00 1,309.65 0.00 3,340.35 71.84 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,309.65 0.00 3,340.35 71.84 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 9,473.78 9,483.22 0.00 -9.44 -0.10 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 9,473.78 9,483.22 0.00 -9.44 -0.10 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 684,004.32 693,093.53 0.00 -9,089.21 -1.33 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 96,476.83 100,475.23 0.00 -3,998.40 -4.14 10-320-501030 Holiday Pay 3,641.42 361.96 0.00 3,279.46 90.06 10-320-501090 Overtime 28,552.09 23,876.90 0.00 4,675.19 16.37 10-320-501095 Overtime Straight Pay 0.00 268.32 0.00 -268.32 0.00 10-320-502010 Social Security 8,527.34 9,159.42 0.00 -632.08 -7.41 10-320-502020 Group Health Insurance 22,276.30 20,450.50 0.00 1,825.80 8.20 10-320-502030 Retirement 20,175.81 22,429.07 0.00 -2,253.26 -11.17 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 115.06 115.12 0.00 -0.06 -0.05 10-320-502060 Long Term Disability 283.97 284.22 0.00 -0.25 -0.09 10-320-502070 Employee Assistance Prgm 56.12 40.31 0.00 15.81 28.17 E05 Personnel Services 182,109.33 179,465.44 0.00 2,643.89 1.45 10-320-514010 Gas 5.580.00 4.805.92 0.00 774.08 13.87 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,905.36 14,121.34 0.00 -215.98 -1.55 10-320-517010 Operational Supplies 12,274.60 415.58 0.00 11,859.02 96.61 E10 Materials & Supplies 31,759.96 19,342.84 0.00 12,417.12 39.10 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 17,160.00 15,000.00 0.00 2,160.00 12.59 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,160.00 15,000.00 0.00 2,160.00 12.59 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 231,029.29 213,808.28 0.00 17,221.01 7.45 330 Animal Control 10-330-501020 Salaries 353,755.38 337,833.05 0.00 15,922.33 4.50 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 4,320.00 0.00 -12.00 -0.28 10-330-501090 Overtime 1,709.00 11,311.07 0.00 -9,602.07 -561.85 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 27,522.59 25,533.14 0.00 1,989.45 7.23 10-330-502020 Group Health Insurance 75,516.45 67,751.80 0.00 7,764.65 10.28 10-330-502030 Retirement 43,892.23 36,100.85 0.00 7,791.38 17.75 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 429.62 381.37 0.00 48.25 11.23 10-330-502060 Long Term Disability 1,059.25 940.80 0.00 118.45 11.18 10-330-502070 Employee Assistance Prgm 224.48 161.28 0.00 63.20 28.15 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 513,098.08 489,014.44 0.00 24,083.64 4.69 10-330-511010 Advertising 936.60 818.00 0.00 118.60 12.66 10-330-511020 Postage 213.00 243.15 0.00 -30.15 -14.15 10-330-512010 Printing 1,720.50 1,806.62 0.00 -86.12 -5.01 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,411.00 1,193.71 0.00 217.29 15.40 10-330-514017 COVID-19 74.93 74.93 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-514040 Food 223.20 148.68 0.00 74.52 33.39 10-330-515040 First Aid Supplies 465.00 140.88 0.00 324.12 69.70 10-330-517010 Operational Supplies 9,690.60 8,981.41 0.00 709.19 7.32 E10 Materials & Supplies 14,734.83 13,407.38 0.00 1,327.45 9.01 10-330-520030 Dues And Publications 1,166.00 1,165.25 0.00 0.75 0.06 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,813.50 2,758.22 0.00 -944.72 -52.09 10-330-521040 Medical Claimsservices 431.52 4,275.30 0.00 -3,843.78 -890.75 10-330-522020 Professional Services 5,010.00 3,788.08 0.00 1,221.92 24.39 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,206.24 12,982.17 0.00 -9,775.93 -304.90 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 13,314.50 13,787.23 0.00 -472.73 -3.55 E15 Contractual Services 24,941.76 38,756.25 0.00 -13,814.49 -55.39 10-330-531010 Electricity 19,152.00 24,030.07 0.00 -4,878.07 -25.47 10-330-533010 Natural Gas 15,700.00 19,481.79 0.00 -3,781.79 -24.09 10-330-534010 Telephone 300.00 418.85 0.00 -118.85 -39.62 10-330-535010 Water 3,800.00 4,580.80 0.00 -780.80 -20.55 E20 Utilities 38,952.00 48,511.51 0.00 -9,559.51 -24.54 10-330-540010 Building & Grounds Maint. 17,600.00 39,976.05 0.00 -22,376.05 -127.14 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 541.76 541.76 0.00 0.00 0.00 10-330-544040 Care Of Animals 48,290.00 49,191.89 0.00 -901.89 -1.87 10-330-544050 Animal Food 5,703.00 4,064.90 0.00 1,638.10 28.72 10-330-545010 Software Licensemaint 3,172.00 3,107.76 0.00 64.24 2.03 10-330-546010 Clothing Expense 2,325.00 2,728.14 0.00 -403.14 -17.34 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 49.81 21.99 0.00 27.82 55.85 10-330-547020 Maintenance Agreements 2,600.00 2,304.00 0.00 296.00 11.38 10-330-547030 Radio Maintenance 232.50 90.44 0.00 142.06 61.10 E25 Repairs & Maintenance 80,514.07 102,026.93 0.00 -21,512.86 -26.72 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 28,486.60 24,116.60 0.00 4,370.00 15.34 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 28,486.60 24,116.60 0.00 4,370.00 15.34 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 700,727.34 715,833.11 0.00 -15,105.77 -2.16 390 9-1-1 Police GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-501020 Salaries 896,855.55 876,989.26 0.00 19,866.29 2.22 10-390-501030 Holiday Pay 31,505.21 26,907.70 0.00 4,597.51 14.59 10-390-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 22,814.00 44,550.50 0.00 -21,736.50 -95.28 10-390-501095 Overtime Straight Pay 500.00 2,331.22 0.00 -1,831.22 -366.24 10-390-502010 Social Security 72,803.12 68,900.01 0.00 3,903.11 5.36 10-390-502020 Group Health Insurance 196,184.53 181,791.16 0.00 14,393.37 7.34 10-390-502030 Retirement 117,893.93 110,409.96 0.00 7,483.97 6.35 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,112.80 1,032.14 0.00 80.66 7.25 10-390-502060 Long Term Disability 2,707.70 2,548.56 0.00 159.14 5.88 10-390-502070 Employee Assistance Prgm 596.28 428.39 0.00 167.89 28.16 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,345,693.08 1,318,608.86 0.00 27,084.22 2.01 10-390-511010 Advertising 93.00 2,095.25 0.00 -2,002.25 -2,152.96 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 10.44 10.44 0.00 0.00 0.00 10-390-517010 Operational Supplies 5,394.00 5,165.30 0.00 228.70 4.24 E10 Materials & Supplies 5,497.44 7,270.99 0.00 -1,773.55 -32.26 10-390-520030 Dues And Publications 558.00 308.99 0.00 249.01 44.63 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 2,344.49 0.00 2,305.51 49.58 10-390-522020 Professional Services 2,511.00 5,958.63 0.00 -3,447.63 -137.30 10-390-523010 Equipment Rentlease 85,560.00 99,192.98 0.00 -13,632.98 -15.93 E15 Contractual Services 93,279.00 107,805.09 0.00 -14,526.09 -15.57 10-390-531010 Electricity 11,160.00 3,991.22 0.00 7,168.78 64.24 10-390-533010 Natural Gas 279.00 89.00 0.00 190.00 68.10 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 609.97 0.00 227.03 27.12 E20 Utilities 12,276.00 4,690.19 0.00 7,585.81 61.79 10-390-545010 Software Licensemaint 30,236.16 32,284.00 0.00 -2,047.84 -6.77 10-390-546010 Clothing Expense 5,580.00 8,111.40 0.00 -2,531.40 -45.37 10-390-546020 Uniform Cleaning 2,976.00 3,462.95 0.00 -486.95 -16.36 10-390-547010 Equipment Maintenance 2,790.00 5,240.52 0.00 -2,450.52 -87.83 10-390-547020 Maintenance Agreements 57,000.00 82,336.10 0.00 -25,336.10 -44.45 10-390-547030 Radio Maintenance 4,650.00 1,425.99 0.00 3,224.01 69.33 E25 Repairs & Maintenance 103,232.16 132,860.96 0.00 -29,628.80 -28.70 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,559,977.68 1,571,236.09 0.00 -11,258.41 -0.72 400 Fire Department GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-501020 Dues And Publications Salaries 3,931,958.32 3,866,657.33 0.00 65,300.99 1.66 10-400-501030 INACTIVE - Mtgs & Conferences 0.00 Holiday Pay 294,561.33 284,205.29 0.00 10,356.04 3.52 10-400-501050 0.00 0.00 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 0.00 794.99 Step-up Pay 28,500.00 39,282.55 0.00 -10,782.55 -37.83 10-400-501090 -1,164.00 -19.26 Overtime 41,000.00 72,188.11 0.00 -31,188.11 -76.07 10-400-501095 0.00 10-400-521040 Overtime Straight Pay 33,000.00 41,151.49 0.00 -8,151.49 -24.70 10-400-502010 10-400-522020 Social Security 65,375.80 61,163.22 0.00 4,212.58 6.44 10-400-502020 Group Health Insurance 766,446.12 722,838.48 0.00 43,607.64 5.69 10-400-502030 10-400-524010 Retirement 2,020,017.53 1,944,708.71 0.00 75,308.82 3.73 10-400-502040 Special Events Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Child Safety Seat Pass-through 2,700.00 Life Insurance 4,670.78 4,535.27 0.00 135.51 2.90 10-400-502060 83,958.50 57,123.43 Long Term Disability 11,615.57 11,132.81 0.00 482.76 4.16 10-400-502070 35,430.27 0.00 Employee Assistance Prgm 2,132.56 1,531.08 0.00 601.48 28.20 10-400-503010 0.00 5,182.59 Awards Program 1,500.00 1,626.87 0.00 -126.87 -8.46 E05 3.29 10-400-535010 Personnel Services 7,353,808.96 7,204,052.16 0.00 149,756.80 2.04 10-400-511010 Advertising 372.00 373.69 0.00 -1.69 -0.45 10-400-511020 Postage 139.50 106.23 0.00 33.27 23.85 10-400-512010 Printing 790.50 335.75 0.00 454.75 57.53 10-400-512020 Copies 46.50 0.00 0.00 46.50 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,604.20 0.00 -209.20 -15.00 10-400-514010 Gas 51,150.00 43,072.73 0.00 8,077.27 15.79 10-400-514017 COVID-19 21,354.33 24,839.26 0.00 -3,484.93 -16.32 10-400-514020 Chemicals 930.00 512.50 0.00 417.50 44.89 10-400-514030 Small Tools 4,650.00 5,309.84 0.00 -659.84 -14.19 10-400-514040 Food 0.00 186.90 0.00 -186.90 0.00 10-400-515040 First Aid Supplies 2,046.00 228.75 0.00 1,817.25 88.82 10-400-517010 Operational Supplies 13,476.00 8,653.43 0.00 4,822.57 35.79 E10 Materials & Supplies 96,349.83 85,223.28 0.00 11,126.55 11.55 10-400-520030 Dues And Publications 2,673.50 1,819.97 0.00 853.53 31.93 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 30,225.00 29,430.01 0.00 794.99 2.63 10-400-520080 Tuition Reimbursement 6,045.00 7,209.00 0.00 -1,164.00 -19.26 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 35,340.00 10,184.50 0.00 25,155.50 71.18 10-400-522020 Professional Services 186.00 0.00 0.00 186.00 100.00 10-400-523010 Equipment Rentlease 186.00 40.00 0.00 146.00 78.49 10-400-524010 Trash Collections 93.00 218.34 0.00 -125.34 -134.77 10-400-529010 Special Events 6,510.00 6,516.61 0.00 -6.61 -0.10 10-400-529040 Child Safety Seat Pass-through 2,700.00 1,705.00 0.00 995.00 36.85 E15 Contractual Services 83,958.50 57,123.43 0.00 26,835.07 31.96 10-400-531010 Electricity 30,690.00 35,430.27 0.00 -4,740.27 -15.45 10-400-533010 Natural Gas 17,670.00 12,487.41 0.00 5,182.59 29.33 10-400-534010 Telephone 23,250.00 22,485.91 0.00 764.09 3.29 10-400-535010 Water 16,740.00 11,055.12 0.00 5,684.88 33.96 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 88,350.00 81,458.71 0.00 6,891.29 7.80 10-400-540010 Building & Grounds Maint. 90,510.91 66,443.83 0.00 24,067.08 26.59 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,703.50 60,414.41 0.00 9,289.09 13.33 10-400-546020 Uniform Cleaning 186.00 668.70 0.00 -482.70 -259.52 10-400-547010 Equipment Maintenance 15,462.15 16,501.34 0.00 -1,039.19 -6.72 10-400-547020 Maintenance Agreements 35,757.54 31,093.95 0.00 4,663.59 13.04 10-400-547030 Radio Maintenance 22,650.00 24,795.25 0.00 -2,145.25 -9.47 E25 Repairs & Maintenance 234,270.10 199,917.48 0.00 34,352.62 14.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 0.00 12,229.59 0.00 -12,229.59 0.00 10-400-572021 Purchase of Equipment -ONE TIME 22,474.09 20,974.27 0.00 1,499.82 6.67 10-400-572022 Fitness -ONE TIME 10,746.36 10,746.36 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 33,220.45 43,950.22 0.00 40,729.77 -32.30 400 Fire Department 7,889,957.84 7,671,725.28 0.00 218,232.56 2.77 401 Fire Museum 10-401-531010 Electricity 1,274.35 777.66 0.00 496.69 38.98 10-401-533010 Natural Gas 389.02 510.24 0.00 -121.22 -31.16 10-401-535010 Water 196.63 296.93 0.00 -100.30 -51.01 E20 Utilities 1,860.00 1,584.83 0.00 275.17 14.79 10-401-540010 Building & Grounds Maint. 0.00 148.39 0.00 -148.39 0.00 E25 Repairs & Maintenance 0.00 148.39 0.00 -148.39 0.00 401 Fire Museum 1,860.00 1,733.22 0.00 126.78 6.82 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 Advertisine 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 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 183,686.46 184,465.72 0.00 -779.26 -0.42 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,052.01 13,508.83 0.00 543.18 3.87 10-520-502020 Group Health Insurance 27,276.96 26,548.34 0.00 728.62 2.67 10-520-502030 Retirement 22,409.75 22,547.51 0.00 -137.76 -0.61 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 217.87 220.90 0.00 -3.03 -1.39 10-520-502060 Long Term Disability 475.65 477.50 0.00 -1.85 -0.39 10-520-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 248,399.78 248,026.19 0.00 373.59 0.15 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 8.50 0.00 66.50 88.67 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 Photoaranhic Sullies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-513010 Office Supplies 850.00 769.05 0.00 80.95 9.52 10-520-514010 Gas 11,000.00 10,262.49 0.00 737.51 6.70 10-520-514017 COVID-19 881.46 939.08 0.00 -57.62 -6.54 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 316.55 0.00 183.45 36.69 E10 Materials & Supplies 13,406.46 12,295.74 0.00 1,110.72 8.28 10-520-520030 Dues And Publications 1,259.30 1,146.50 0.00 112.80 8.96 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 540.70 523.33 0.00 17.37 3.21 10-520-522020 Professional Services 21,742.38 12,387.58 0.00 9,354.80 43.03 E15 Contractual Services 23,542.38 14,057.41 0.00 9,484.97 40.29 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 826.00 788.52 0.00 37.48 4.54 E25 Repairs & Maintenance 826.00 788.52 0.00 37.48 4.54 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 286,174.62 275,167.86 0.00 t 1,006.76 3.85 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 138,518.99 138,586.27 0.00 -67.28 -0.05 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,596.70 10,063.03 0.00 533.67 5.04 10-521-502020 Group Health Insurance 31,325.80 29,845.78 0.00 1,480.02 4.72 10-521-502030 Retirement 16,899.32 16,801.81 0.00 97.51 0.58 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 167.57 165.66 0.00 1.91 1.14 10-521-502060 Long Term Disability 414.25 409.31 0.00 4.94 1.19 10-521-502070 Employee Assistance Prgm 75.76 54.44 0.00 21.32 28.14 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 198,156.74 196,084.65 0.00 2,072.09 1.05 10-521-511010 Advertising 2,500.00 2,675.75 0.00 -175.75 -7.03 10-521-511020 Postage 900.00 150.30 0.00 749.70 83.30 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 4.76 0.00 -4.76 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Sunolies 800.00 579.67 0.00 220.33 27.54 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-547020 Maintenance Agreements 1,400.00 1,833.56 0.00 -433.56 -30.97 10-521-514017 COVID-19 0.00 58.05 0.00 -58.05 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,282.60 0.00 217.40 14.49 E10 Materials & Supplies 5,900.00 4,751.13 0.00 1,148.87 19.47 10-521-520030 Dues And Publications 14,300.00 14,329.49 0.00 -29.49 -0.21 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 2,281.16 0.00 118.84 4.95 10-521-520080 Tuition Reimbursement 873.00 855.00 0.00 18.00 2.06 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 17,573.00 17,465.65 0.00 107.35 0.61 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,400.00 1,833.56 0.00 -433.56 -30.97 E25 Repairs & Maintenance 1,400.00 1,833.56 0.00 -433.56 -30.97 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 223,029.74 220,134.99 0.00 2,894.75 1.30 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 122,107.26 110,653.51 0.00 11,453.75 9.38 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,341.21 8,380.92 0.00 960.29 10.28 10-522-502020 Group Health Insurance 17,996.06 16,607.48 0.00 1,388.58 7.72 10-522-502030 Retirement 14,897.09 12,241.52 0.00 2,655.57 17.83 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 147.74 132.35 0.00 15.39 10.42 10-522-502060 Long Term Disability 364.74 328.09 0.00 36.65 10.05 10-522-502070 Employee Assistance Prgm 64.54 46.38 0.00 18.16 28.14 E05 Personnel Services 165,021.19 148,492.80 0.00 16,528.39 10.02 10-522-511010 Advertising 1,800.00 592.50 0.00 1,207.50 67.08 10-522-511020 Postage 200.00 1.65 0.00 198.35 99.18 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.70 0.00 9.30 93.00 10-522-513010 Office Supplies 1,000.00 693.41 0.00 306.59 30.66 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 1,165.55 0.00 454.45 28.05 E10 Materials & SuDOlies 5.005.00 2.453.81 0.00 2.551.19 50.97 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-520030 Dues And Publications 1,500.00 583.80 0.00 916.20 61.08 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 92.50 0.00 5,907.50 98.46 10-522-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 676.30 0.00 6,823.70 90.98 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,075.00 1,474.47 0.00 600.53 28.94 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,075.00 1,474.47 0.00 600.53 28.94 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs -MPO 179,601.19 153,097.38 0.00 26,503.81 14.76 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 59,979.00 50,004.67 0.00 9,974.33 16.63 10-530-501050 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 6,175.19 3,299.18 0.00 2,876.01 46.57 10-530-502020 Group Health Insurance 9,710.69 10,173.11 0.00 -462.42 -4.76 10-530-502030 Retirement 9,848.01 3,762.81 0.00 6,085.20 61.79 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 96.70 55.00 0.00 41.70 43.12 10-530-502060 Long Term Disability 239.90 135.51 0.00 104.39 43.51 10-530-502070 Employee Assistance Prgm 42.09 30.23 0.00 11.86 28.18 E05 Personnel Services 86,149.66 67,518.59 0.00 18,631.07 21.63 10-530-511010 Advertising 405.00 1,009.50 0.00 -604.50 -149.26 10-530-511020 Postage 515.50 598.40 0.00 -82.90 -16.08 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 0.00 2.22 0.00 -2.22 0.00 10-530-513010 Office Supplies 796.84 796.40 0.00 0.44 0.06 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 500.00 310.54 0.00 189.46 37.89 E10 Materials & Supplies 2,267.34 2,717.06 0.00 -449.72 -19.83 10-530-520030 Dues And Publications 700.00 700.97 0.00 -0.97 -0.14 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,132.66 123.91 0.00 1,008.75 89.06 10-530-522020 Professional Services 402.00 63.00 0.00 339.00 84.33 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 18,800.00 25,435.62 0.00 -6,635.62 -35.30 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 1,000.00 319.89 0.00 680.11 68.01 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 110,240.56 26,643.39 0.00 83,597.17 75.83 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 508.00 442.59 0.00 65.41 12.88 E25 Repairs & Maintenance 508.00 442.59 0.00 65.41 12.88 10-530-550020 NRA -Residential 29,379.77 29,379.57 0.00 0.20 0.00 10-530-550030 NRA -Commercial Facade 20,000.00 19,447.65 0.00 552.35 2.76 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA -Rental Facade 0.00 0.00 0.00 0.00 0.00 10-530-550033 HPF Grant -Structural Survey 72,000.00 70,127.59 0.00 1,872.41 2.60 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 151.17 0.00 98.83 39.53 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 121,629.77 119,105.98 0.00 2,523.79 2.07 530 Plan & Protect Svc-RedevGrant 320,795.33 216,427.61 0.00 104,367.72 32.53 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 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs -Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 10-532-501020 Salaries 179,725.82 180,512.93 0.00 -787.11 -0.44 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 13,749.02 12,643.17 0.00 1,105.85 8.04 10-532-502020 Group Health Insurance 34,764.83 33,899.74 0.00 865.09 2.49 10-532-502030 Retirement 21,926.55 22,064.38 0.00 -137.83 -0.63 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 215.42 215.36 0.00 0.06 0.03 10-532-502060 Long Term Disability 535.62 536.66 0.00 -1.04 -0.19 10-532-502070 Emnlovee Assistance Prem 84.18 60.49 0.00 23.69 28.14 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 254,754.86 253,686.15 0.00 1,068.71 0.42 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 56.65 0.00 93.35 62.23 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.25 0.00 -0.25 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 1,049.72 0.00 250.28 19.25 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 872.93 0.00 127.07 12.71 E10 Materials & Supplies 2,625.00 1,979.55 0.00 645.45 24.59 10-532-520030 Dues And Publications 900.00 620.00 0.00 280.00 31.11 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 310.00 557.88 0.00 -247.88 -79.96 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 194,400.00 194,400.00 0.00 0.00 0.00 10-532-529010 Special Events 62.13 62.13 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 195,672.13 195,640.01 0.00 32.12 0.02 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 34,000.00 33,402.08 0.00 597.92 1.76 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 805.57 823.57 0.00 -18.00 -2.23 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 750.00 729.00 0.00 21.00 2.80 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 36,885.57 36,238.65 0.00 646.92 1.75 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 489,937.56 487,544.36 0.00 2,393.20 0.49 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 533 Telephone PPS - Prop MaintCode Enforce 3,659.41 0.00 41.99 1.13 E20 10-533-501020 3,701.40 Salaries 163,223.07 168,688.36 0.00 -5,465.29 -3.35 10-533-501050 270.00 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-533-501060 0.00 Seasonal Salaries 30,000.00 36,646.76 0.00 -6,646.76 -22.16 10-533-501090 0.00 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 0.00 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,781.57 15,082.41 0.00 -300.84 -2.04 10-533-502020 Group Health Insurance 32,001.37 31,025.76 0.00 975.61 3.05 10-533-502030 Retirement 19,913.21 20,620.22 0.00 -707.01 -3.55 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 177.60 178.01 0.00 -0.41 -0.23 10-533-502060 Long Term Disability 489.48 490.31 0.00 -0.83 -0.17 10-533-502070 Employee Assistance Prgm 98.21 70.57 0.00 27.64 28.14 E05 Personnel Services 262,941.89 275,059.78 0.00 -12,117.89 -4.61 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.51 1,422.30 0.00 378.21 21.01 10-533-512010 Printing 300.00 225.00 0.00 75.00 25.00 10-533-512020 Copies 0.00 0.04 0.00 -0.04 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 847.43 710.57 0.00 136.86 16.15 10-533-514017 COVID-19 7,813.04 4,696.10 0.00 3,116.94 39.89 10-533-514030 Small Tools 72.56 0.00 0.00 72.56 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,525.49 1,525.49 0.00 0.00 0.00 E10 Materials & Supplies 12,474.03 8,579.50 0.00 3,894.53 31.22 10-533-520030 Dues And Publications 593.34 593.34 0.00 0.00 0.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 607.95 607.95 0.00 0.00 0.00 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 27,699.53 29,342.58 0.00 -1,643.05 -5.93 10-533-522022 Demo 332,617.31 258,782.76 0.00 73,834.55 22.20 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 361,518.13 289,326.63 0.00 72,191.50 19.97 10-533-534010 Telephone 3,701.40 3,659.41 0.00 41.99 1.13 E20 Utilities 3,701.40 3,659.41 0.00 41.99 1.13 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,200.00 831.02 0.00 368.98 30.75 10-533-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-533-547020 Maintenance Agreements 14,657.20 14,657.18 0.00 0.02 0.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 16,127.20 15,758.20 0.00 369.00 2.29 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 656,762.65 592,383.52 0.00 64,379.13 9.80 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 319,227.85 317,085.54 0.00 2,142.31 0.67 10-534-501050 Parttime(wo Benefits) 0.00 1,586.00 0.00 -1,586.00 0.00 10-534-501060 Seasonal Salaries 0.00 623.60 0.00 -623.60 0.00 10-534-501090 Overtime 0.00 6,506.57 0.00 -6,506.57 0.00 10-534-501095 Overtime Straight Pay 0.00 29.10 0.00 -29.10 0.00 10-534-502010 Social Security 24,489.78 23,374.95 0.00 1,114.83 4.55 10-534-502020 Group Health Insurance 71,448.27 67,077.15 0.00 4,371.12 6.12 10-534-502030 Retirement 39,055.60 37,847.65 0.00 1,207.95 3.09 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 384.34 360.55 0.00 23.79 6.19 10-534-502060 Long Term Disability 951.29 891.31 0.00 59.98 6.31 10-534-502070 Employee Assistance Prgm 168.36 158.06 0.00 10.30 6.12 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 460,481.56 460,296.55 0.00 185.01 0.04 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 518.70 0.00 581.30 52.85 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.22 0.00 -0.22 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 514.46 0.00 385.54 42.84 10-534-514017 COVID-19 10.75 10.75 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 2,040.63 0.00 -240.63 -13.37 E10 Materials & Supplies 4,125.75 3,084.76 0.00 1,040.99 25.23 10-534-520030 Dues And Publications 3,000.00 3,793.85 0.00 -793.85 -26.46 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 4,581.08 0.00 418.92 8.38 10-534-522020 Professional Services 0.00 6,982.91 0.00 -6,982.91 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 15,357.84 0.00 -7,357.84 -91.97 10-534-534010 Telephone 900.00 304.62 0.00 595.38 66.15 E20 Utilities 900.00 304.62 0.00 595.38 66.15 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 1,336.00 0.00 -156.00 -13.22 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 800.00 966.17 0.00 -166.17 -20.77 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,270.00 2,572.17 0.00 -302.17 -13.31 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 475,777.31 481,615.94 0.00 -5,838.63 -1.23 535 Public Works -Central Maintenan 10-535-501020 Salaries 353,324.68 356,092.99 0.00 -2,768.31 -0.78 10-535-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits) 2,104.60 0.00 0.00 2,104.60 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 6,237.07 6,237.07 0.00 0.00 0.00 10-535-501095 Overtime Straight Pay 658.33 658.33 0.00 0.00 0.00 10-535-502010 Social Security 27,717.84 26,120.61 0.00 1,597.23 5.76 10-535-502020 Group Health Insurance 76,549.23 76,248.57 0.00 300.66 0.39 10-535-502030 Retirement 43,715.61 44,199.83 0.00 -484.22 -1.11 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 428.50 429.23 0.00 -0.73 -0.17 10-535-502060 Long Term Disability 1,058.03 1,060.21 0.00 -2.18 -0.21 10-535-502070 Employee Assistance Prgm 196.42 103.99 0.00 92.43 47.06 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 516,459.67 515,620.19 0.00 839.48 0.16 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 1.45 0.00 48.55 97.10 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 865.10 667.18 0.00 197.92 22.88 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 6,700.64 0.00 299.36 4.28 10-535-517010 Operational Supplies 7,634.90 7,745.96 0.00 -111.06 -1.45 E10 Materials & Supplies 15,640.00 15,115.23 0.00 524.77 3.36 10-535-520030 Dues And Publications 350.00 175.00 0.00 175.00 50.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,650.00 -74.95 0.00 1,724.95 104.54 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,500.00 600.05 0.00 1,899.95 76.00 10-535-531010 Electricity 7,560.00 6,522.27 0.00 1,037.73 13.73 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-533010 Advertising Natural Gas 2,300.00 1,851.48 0.00 448.52 19.50 10-535-534010 200.00 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 0.00 Water 1,442.00 1,339.70 0.00 102.30 7.09 E20 0.00 Utilities 11,522.00 9,713.45 0.00 1,808.55 15.70 10-535-540010 355.02 Building & Grounds Maint. 10,000.00 8,537.74 0.00 1,462.26 14.62 10-535-541010 7.23 Veh & Equip Parts Etc 557,000.00 625,105.72 0.00 -68,105.72 -12.23 10-535-541015 10-540-514040 Vehicle Hail Damage Repair 118,102.76 15,909.57 0.00 102,193.19 86.53 10-535-546010 Operational Supplies Clothing Expense 8,700.00 8,402.32 0.00 297.68 3.42 10-535-547010 74,302.36 Equipment Maintenance 1,000.00 390.47 0.00 609.53 60.95 10-535-547020 671.40 Maintenance Agreements 13,300.00 12,676.09 0.00 623.91 4.69 10-535-547030 0.00 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 2,373.33 Repairs & Maintenance 708,202.76 671,021.91 0.00 37,180.85 5.25 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 0.00 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works -Central Maintenan 1,254,324.43 1,212,070.83 0.00 42,253.60 3.37 540 Public Works -Admin 10-540-501020 Salaries 218,788.95 219,700.85 0.00 -911.90 -0.42 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 16,737.35 16,180.66 0.00 556.69 3.33 10-540-502020 Group Health Insurance 28,006.51 27,257.59 0.00 748.92 2.67 10-540-502030 Retirement 26,692.25 26,854.23 0.00 -161.98 -0.61 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 263.16 263.38 0.00 -0.22 -0.08 10-540-502060 Long Term Disability 535.62 532.53 0.00 3.09 0.58 10-540-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 E05 Personnel Services 291,327.25 291,068.96 0.00 258.29 0.09 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 8.35 0.00 191.65 95.83 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.14 0.00 99.86 99.86 10-540-513010 Office Supplies 1,000.00 644.98 0.00 355.02 35.50 10-540-514010 Gas 71,300.00 66,147.27 0.00 5,152.73 7.23 10-540-514017 COVID-19 1,002.36 1,451.60 0.00 -449.24 -44.82 10-540-514040 Food 200.00 187.04 0.00 12.96 6.48 10-540-517010 Operational Supplies 300.00 191.95 0.00 108.05 36.02 E10 Materials & Supplies 74,302.36 68,631.33 0.00 5,671.03 7.63 10-540-520030 Dues And Publications 800.00 671.40 0.00 128.60 16.08 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,975.00 601.67 0.00 2,373.33 79.78 10-540-522020 Professional Services 3,200.00 2,742.38 0.00 457.62 14.30 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 6,975.00 4,015.45 0.00 2,959.55 42.43 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 275.00 247.88 0.00 27.12 9.86 E25 Repairs & Maintenance 275.00 247.88 0.00 27.12 9.86 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 372,879.61 363,963.62 0.00 8,915.99 2.39 541 Public Works -Engineering 10-541-501020 Salaries 815,326.68 819,128.25 0.00 -3,801.57 -0.47 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 536.26 844.00 0.00 -307.74 -57.39 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 62,413.51 58,899.11 0.00 3,514.40 5.63 10-541-502020 Group Health Insurance 125,084.78 131,496.10 0.00 -6,411.32 -5.13 10-541-502030 Retirement 99,535.28 100,226.13 0.00 -690.85 -0.69 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 982.87 977.76 0.00 5.11 0.52 10-541-502060 Long Term Disability 2,392.68 2,367.69 0.00 24.99 1.04 10-541-502070 Employee Assistance Prgm 336.72 241.90 0.00 94.82 28.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,112,664.50 1,120,236.66 0.00 -7,572.16 -0.68 10-541-511010 Advertising 911.75 911.75 0.00 0.00 0.00 10-541-511020 Postage 375.31 271.35 0.00 103.96 27.70 10-541-512010 Printing 53.19 53.19 0.00 0.00 0.00 10-541-512020 Copies 0.47 0.47 0.00 0.00 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 2,067.31 2,318.99 0.00 -251.68 -12.17 10-541-514017 COVID-19 25,046.40 26,084.25 0.00 -1,037.85 -4.14 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 23.37 0.00 126.63 84.42 10-541-515040 First Aid Supplies 115.72 115.72 0.00 0.00 0.00 10-541-515070 Const & Inspect Supplies 1,000.00 647.50 0.00 352.50 35.25 10-541-515080 Surveying Supplies 1,500.00 1,290.67 0.00 209.33 13.96 10-541-517010 Operational Supplies 3,785.36 3,781.40 0.00 3.96 0.10 E10 Materials & Supplies 35,205.51 35,498.66 0.00 -293.15 -0.83 10-541-520030 Dues And Publications 4,000.00 2,799.35 0.00 1,200.65 30.02 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,063.89 1,392.65 0.00 1,671.24 54.55 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 183.00 0.00 317.00 63.40 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 8,063.89 4,375.00 0.00 3,688.89 45.75 10-541-534010 Telephone 500.00 489.77 0.00 10.23 2.05 E20 Utilities 500.00 489.77 0.00 10.23 2.05 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,500.00 1,409.56 0.00 90.44 6.03 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 9,652.00 8,604.50 0.00 1,047.50 10.85 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 13,152.00 11,589.06 0.00 1,562.94 11.88 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works -Engineering 1,169,585.90 1,172,189.15 0.00 -2,603.25 -0.22 542 Public Works -Street 10-542-501020 Salaries 1,232,199.83 1,242,662.21 0.00 -10,462.38 -0.85 10-542-501060 Seasonal Salaries 20,000.00 15,221.76 0.00 4,778.24 23.89 10-542-501070 Stand-by Plan 5,000.00 4,276.00 0.00 724.00 14.48 10-542-501090 Overtime 29,200.52 24,778.50 0.00 4,422.02 15.14 10-542-501095 Overtime Straight Pay 1,299.48 1,407.40 0.00 -107.92 -8.30 10-542-502010 Social Security 98,509.04 94,182.96 0.00 4,326.08 4.39 10-542-502020 Group Health Insurance 257,026.73 260,182.38 0.00 -3,155.65 -1.23 10-542-502030 Retirement 154,659.38 155,470.06 0.00 -810.68 -0.52 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,471.55 1,489.45 0.00 -17.90 -1.22 10-542-502060 Long Term Disability 3,590.24 3,628.18 0.00 -37.94 -1.06 10-542-502070 Employee Assistance Prgm 799.71 574.54 0.00 225.17 28.16 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 87.15 0.00 -87.15 0.00 E05 Personnel Services 1,843,067.32 1,843,071.43 0.00 -4.11 0.00 10-542-511010 Advertising 926.97 311.50 0.00 615.47 66.40 10-542-511020 Postage 150.00 18.55 0.00 131.45 87.63 10-542-512010 Printing 163.03 163.03 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.53 0.00 9.47 94.70 10-542-513010 Office Supplies 1,600.00 889.21 0.00 710.79 44.42 10-542-514017 COVID-19 1.957.17 2.331.37 0.00 -374.20 -19.12 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-514020 Chemicals 344,445.29 344,445.29 0.00 0.00 0.00 10-542-514030 Small Tools 9,000.00 9,570.98 0.00 -570.98 -6.34 10-542-514040 Food 2,000.00 1,634.23 0.00 365.77 18.29 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 354,895.71 380,534.58 0.00 -25,638.87 -7.22 10-542-515040 First Aid Supplies 245.15 0.00 0.00 245.15 100.00 10-542-515060 Weed Control 1,500.00 1,715.96 0.00 -215.96 -14.40 10-542-515070 Const & Inspect Supplies 200.00 185.71 0.00 14.29 7.15 10-542-517010 Operational Supplies 5,254.85 5,278.63 0.00 -23.78 -0.45 E10 Materials & Supplies 722,348.17 747,079.57 0.00 -24,731.40 -3.42 10-542-520030 Dues And Publications 1,320.00 956.50 0.00 363.50 27.54 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,040.97 5,234.75 0.00 1,806.22 25.65 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 13,843.50 12,820.35 0.00 1,023.15 7.39 10-542-523010 Equipment Rentlease 356.50 406.50 0.00 -50.00 -14.03 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 639.03 639.03 0.00 0.00 0.00 E15 Contractual Services 23,200.00 20,057.13 0.00 3,142.87 13.55 10-542-531010 Electricity 24,734.35 23,946.32 0.00 788.03 3.19 10-542-531020 Street Lights 589,589.40 592,795.87 0.00 -3,206.47 -0.54 10-542-533010 Natural Gas 10,000.00 9,666.55 0.00 333.45 3.33 10-542-534010 Telephone 880.00 832.75 0.00 47.25 5.37 10-542-535010 Water 13,090.00 6,211.35 0.00 6,878.65 52.55 E20 Utilities 638,293.75 633,452.84 0.00 4,840.91 0.76 10-542-540010 Building & Grounds Maint. 12,000.00 11,081.41 0.00 918.59 7.65 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 29,306.30 21,723.09 0.00 7,583.21 25.88 10-542-542030 Signs & Marking Paint 62,808.11 70,217.33 0.00 -7,409.22 -11.80 10-542-546010 Clothing Expense 15,000.00 12,340.97 0.00 2,659.03 17.73 10-542-547010 Equipment Maintenance 3,200.00 1,137.84 0.00 2,062.16 64.44 10-542-547020 Maintenance Agreements 300.00 8.13 0.00 291.87 97.29 10-542-547030 Radio Maintenance 1,000.00 28.32 0.00 971.68 97.17 E25 Repairs & Maintenance 130,614.41 123,161.09 0.00 7,453.32 5.71 10-542-572010 Purchase Of Vehicles 85,120.28 85,105.78 0.00 14.50 0.02 10-542-572020 Purchase Of Equipment 7,555.84 7,555.84 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 92,676.12 92,661.62 0.00 14.50 0.02 542 Public Works -Street 3,450,199.77 3,459,483.68 0.00 -9,283.91 -0.27 700 Transfers & Subsidies GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-700-590050 Transfer To Tif Fund 15,000.00 14,566.98 0.00 433.02 2.89 10-700-590065 Trans to Self -Funded H1thIns 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 250,488.56 250,488.56 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,147,753.33 1,147,753.33 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 1,413,241.89 1,412,808.87 0.00 433.02 0.03 700 Transfers & Subsidies 1,413,241.89 1,412,808.87 0.00 433.02 0.03 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 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhclegp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575006 New Fire Station Number 2 3,424.50 3,424.50 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 34,172.50 2,470.00 0.00 31,702.50 92.77 10-990-575023 Fire Station 4 Rehab 348,252.57 0.00 0.00 348,252.57 100.00 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 110,000.00 110,000.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 285,084.20 181,146.50 0.00 103,937.70 36.46 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-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E75 Capital Projects 781,733.77 297,041.00 0.00 484,692.77 62.00 990 Capital Projects 781,733.77 297,041.00 0.00 484,692.77 62.00 Expense Expense 35,847,863.82 33,968,770.80 6,920.33 1,872,172.69 5.22 GL - Trial Balance by Acct Type and Full Acct Number (12/07/2020 - 9:47 AM) Page 35