Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2019-12 Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 12/11/19 16:16:27 Period 01 - 13 Fiscal Year 2019 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 64,800.00 0.00 1,125.00 1.71 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) 0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 7,720.76 7,168.46 0.00 552.30 7.15 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 208.54 208.54 0.00 0.00 0.00 E05 Personnel Services 108,854.22 107,176.92 0.00 1,677.30 1.54 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-110-512010 Printing 100.00 40.00 0.00 60.00 60.00 10-110-512020 Copies 200.00 23.31 0.00 176.69 88.35 10-110-513010 Office Supplies 1,300.00 901.47 0.00 398.53 30.66 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,700.00 964.78 0.00 735.22 43.25 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 845.57 0.00 654.43 43.63 10-110-520030 Dues And Publications 5,000.00 4,707.90 0.00 292.10 5.84 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 900.00 180.00 0.00 720.00 80.00 10-110-522020 Professional Services 100.00 70.00 0.00 30.00 30.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 5,803.47 0.00 1,696.53 22.62 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 80.00 76.37 0.00 3.63 4.54 E25 Repairs & Maintenance 80.00 76.37 0.00 3.63 4.54 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-501020 Salaries 48,798.92 49,010.50 0.00 -211.58 -0.43 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 118,134.22 114,021.54 0.00 4,112.68 3.48 120 City Clerk 10-120-501020 Salaries 48,798.92 49,010.50 0.00 -211.58 -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,733.12 3,353.42 0.00 379.70 10.17 10-120-502020 Group Health Insurance 11,025.25 10,790.37 0.00 234.88 2.13 10-120-502030 Retirement 6,099.87 6,111.05 0.00 -11.18 -0.18 10-120-502040 Workers Compensation 46.14 46.14 0.00 0.00 0.00 10-120-502050 Life Insurance 76.38 61.20 0.00 15.18 19.87 10-120-502060 Long Term Disability 165.97 149.21 0.00 16.76 10.10 10-120-502070 Employee Assistance Prgm 27.24 25.56 0.00 1.68 6.17 E05 Personnel Services 69,972.89 69,547.45 0.00 425.44 0.61 10-120-511020 Postage 200.00 128.13 0.00 71.87 35.94 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 319.73 0.00 -19.73 -6.58 10-120-513010 Office Supplies 500.00 384.13 0.00 115.87 23.17 E10 Materials & Supplies 1,000.00 831.99 0.00 168.01 16.80 10-120-520030 Dues And Publications 275.00 80.00 0.00 195.00 70.91 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 205.00 0.00 795.00 79.50 10-120-522020 Professional Services 400.00 197.46 0.00 202.54 50.64 10-120-529030 Election Expense 20,000.00 16,930.47 0.00 3,069.53 15.35 E15 Contractual Services 21,675.00 17,412.93 0.00 4,262.07 19.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 380.00 169.50 0.00 210.50 55.39 E25 Repairs & Maintenance 380.00 169.50 0.00 210.50 55.39 10-120-572020 Purchase Of Equipment 7,745.00 0.00 0.00 7,745.00 100.00 E70 Capital Purchases 7,745.00 0.00 0.00 7,745.00 100.00 120 City Clerk 100,772.89 87,961.87 0.00 12,811.02 12.71 140 City Administrator 10-140-501020 Salaries 214,821.04 207,841.89 0.00 6,979.15 3.25 10-140-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straieht Pav 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-502010 Social Security 16,433.81 13,232.11 0.00 3,201.70 19.48 10-140-502020 Group Health Insurance 21,507.54 21,333.18 0.00 174.36 0.81 10-140-502030 Retirement 26,852.63 25,501.27 0.00 1,351.36 5.03 10-140-502040 Workers Compensation 184.99 184.99 0.00 0.00 0.00 10-140-502050 Life Insurance 138.56 110.27 0.00 28.29 20.42 10-140-502060 Long Term Disability 300.86 268.31 0.00 32.55 10.82 10-140-502070 Employee Assistance Prgm 54.48 51.16 0.00 3.32 6.09 E05 Personnel Services 280,293.91 268,523.18 0.00 11,770.73 4.20 10-140-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-140-511020 Postage 250.00 66.22 0.00 183.78 73.51 10-140-512010 Printing 105.00 0.00 0.00 105.00 100.00 10-140-512020 Copies 250.00 96.92 0.00 153.08 61.23 10-140-513010 Office Supplies 1,190.00 1,171.26 0.00 18.74 1.57 10-140-517010 Operational Supplies 910.00 495.72 0.00 414.28 45.53 E10 Materials & Supplies 2,855.00 1,830.12 0.00 1,024.88 35.90 10-140-520030 Dues And Publications 800.00 448.69 0.00 351.31 43.91 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,095.00 2,083.00 0.00 12.00 0.57 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 500.00 133.70 0.00 366.30 73.26 E15 Contractual Services 3,395.00 2,665.39 0.00 729.61 21.49 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 235.00 129.63 0.00 105.37 44.84 E25 Repairs & Maintenance 235.00 129.63 0.00 105.37 44.84 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 286,778.91 273,148.32 0.00 13,630.59 4.75 149 Entitlement Grant 10-149-501020 Salaries 39,424.11 34,373.45 0.00 5,050.66 12.81 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,015.94 2,529.33 0.00 486.61 16.13 10-149-502020 Group Health Insurance 6,095.64 6,262.31 0.00 -166.67 -2.73 10-149-502030 Retirement 4,928.01 4,158.76 0.00 769.25 15.61 10-149-502040 Workers Compensation 74.27 74.27 0.00 0.00 0.00 10-149-502050 Life Insurance 62.91 42.28 0.00 20.63 32.79 10-149-502060 Long Term Disability 133.54 103.52 0.00 30.02 22.48 10-149-502070 EmDlovee Assistance Proeram 27.24 25.56 0.00 1.68 6.17 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 53,761.66 47,569.48 0.00 6,192.18 11.52 10-149-511010 Advertising 1,880.00 1,880.00 0.00 0.00 0.00 10-149-511020 Postage 500.00 331.55 0.00 168.45 33.69 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 620.00 164.86 0.00 455.14 73.41 10-149-517010 Operational Supplies 425.00 0.00 0.00 425.00 100.00 E10 Materials & Supplies 3,425.00 2,376.41 0.00 1,048.59 30.62 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 1,341.08 0.00 658.92 32.95 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 45,198.00 9,222.91 0.00 35,975.09 79.59 10-149-528012 Housing Rehab -Energy Efficient 27,000.00 4,200.00 0.00 22,800.00 84.44 10-149-528020 Housing Assistance 127,504.00 122,438.00 0.00 5,066.00 3.97 10-149-528030 Public Improvement 258,594.34 0.00 0.00 258,594.34 100.00 10-149-528040 Neighborhood Redevelopmnt 118,487.74 32,413.00 0.00 86,074.74 72.64 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 15,099.00 10,656.00 0.00 4,443.00 29.43 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 593,883.08 180,270.99 0.00 413,612.09 69.65 10-149-547020 Maintenance Agreements 250.00 251.83 0.00 -1.83 -0.73 E25 Repairs & Maintenance 250.00 251.83 0.00 -1.83 -0.73 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 651,319.74 230,468.71 0.00 420,851.03 64.62 150 City Counselor 10-150-501020 Salaries 209,766.44 210,568.78 0.00 -802.34 -0.38 10-150-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits) 0.00 3,432.00 0.00 -3,432.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,047.13 15,749.74 0.00 297.39 1.85 10-150-502020 Group Health Insurance 37,373.71 32,539.02 0.00 4,834.69 12.94 10-150-502030 Retirement 26,220.80 26,255.75 0.00 -34.95 -0.13 10-150-502040 Workers Compensation 212.20 212.20 0.00 0.00 0.00 10-150-502050 Life Insurance 328.03 262.38 0.00 65.65 20.01 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502060 Long Term Disability 631.34 563.69 0.00 67.65 10.72 10-150-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 290,661.37 289,660.28 0.00 1,001.09 0.34 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 219.59 0.00 380.41 63.40 10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-150-512020 Copies 100.00 0.89 0.00 99.11 99.11 10-150-513010 Office Supplies 1,800.00 1,199.72 0.00 600.28 33.35 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,650.00 1,420.20 0.00 1,229.80 46.41 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,500.00 8,821.22 0.00 2,678.78 23.29 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 4,472.99 0.00 527.01 10.54 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 2,000.00 0.00 0.00 2,000.00 100.00 10-150-522020 Professional Services 10,000.00 1,424.57 0.00 8,575.43 85.75 10-150-525030 Litigation Expenses 1,000.00 16.24 0.00 983.76 98.38 E15 Contractual Services 29,500.00 14,735.02 0.00 14,764.98 50.05 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 680.00 169.50 0.00 510.50 75.07 E25 Repairs & Maintenance 680.00 169.50 0.00 510.50 75.07 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 Counselor 323,491.37 305,985.00 0.00 17,506.37 5.41 160 Municipal Court 10-160-501010 Salary -elected Officals 23,333.04 24,791.63 0.00 -1,458.59 -6.25 10-160-501020 Salaries 117,826.24 118,282.51 0.00 -456.27 -0.39 10-160-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits) 21,945.35 5,205.37 0.00 16,739.98 76.28 10-160-501090 Overtime 3,000.00 1,191.90 0.00 1,808.10 60.27 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,599.53 10,930.69 0.00 2,668.84 19.62 10-160-502020 Group Health Insurance 29,055.90 27,751.20 0.00 1,304.70 4.49 10-160-502030 Retirement 15,103.28 14,897.46 0.00 205.82 1.36 10-160-502040 Workers Compensation 318.71 318.71 0.00 0.00 0.00 10-160-502050 Life Insurance 186.29 149.80 0.00 36.49 19.59 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502060 Long Term Disability 400.74 360.36 0.00 40.38 10.08 10-160-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 E05 Personnel Services 224,850.80 203,956.35 0.00 20,894.45 9.29 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,354.25 3,003.58 0.00 350.67 10.45 10-160-512010 Printing 590.00 303.00 0.00 287.00 48.64 10-160-512020 Copies 22.75 22.75 0.00 0.00 0.00 10-160-513010 Office Supplies 5,307.25 5,235.05 0.00 72.20 1.36 E10 Materials & Supplies 9,274.25 8,564.38 0.00 709.87 7.65 10-160-520025 Security 11,500.00 9,832.10 0.00 1,667.90 14.50 10-160-520030 Dues And Publications 60.00 60.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,000.00 1,964.98 0.00 35.02 1.75 10-160-522020 Professional Services 16,667.00 21,946.44 0.00 -5,279.44 -31.68 10-160-525005 Appointed Counsel 6,905.75 6,905.75 0.00 0.00 0.00 10-160-525010 Care Of Prisoners 0.00 0.00 0.00 0.00 0.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 37,172.75 40,709.27 0.00 -3,536.52 -9.51 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 1,100.00 369.52 0.00 730.48 66.41 E25 Repairs & Maintenance 1,100.00 369.52 0.00 730.48 66.41 10-160-572020 Purchase Of Equipment 0.00 1,745.47 0.00 -1,745.47 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 1,745.47 0.00 -1,745.47 0.00 160 Municipal Court 272,397.80 255,344.99 0.00 17,052.81 6.26 170 Human Resources 10-170-501020 Salaries 208,326.08 209,126.67 0.00 -800.59 -0.38 10-170-501050 Parttime(wo Benefits) 23,468.81 24,273.01 0.00 -804.20 -3.43 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 300.00 113.08 0.00 186.92 62.31 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 16,831.30 17,579.98 0.00 -748.68 -4.45 10-170-502020 Group Health Insurance 21,024.20 24,639.09 0.00 -3,614.89 -17.19 10-170-502030 Retirement 26,078.26 26,089.52 0.00 -11.26 -0.04 10-170-502040 Workers Compensation 326.61 326.61 0.00 0.00 0.00 10-170-502050 Life Insurance 326.56 261.14 0.00 65.42 20.03 10-170-502060 Long Term Disability 621.30 554.66 0.00 66.64 10.73 10-170-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 10-170-503020 Unemployment Compensation 923.95 923.95 0.00 0.00 0.00 E05 Personnel Services 298.308.79 303.964.43 0.00 -5.655.64 -1.90 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-511010 Advertising 50.00 50.00 0.00 0.00 0.00 10-170-511020 Postage 300.00 267.97 0.00 32.03 10.68 10-170-512010 Printing 750.00 750.00 0.00 0.00 0.00 10-170-512020 Copies 500.00 534.32 0.00 -34.32 -6.86 10-170-513010 Office Supplies 1,000.00 619.52 0.00 380.48 38.05 10-170-517010 Operational Supplies 1,200.00 884.50 0.00 315.50 26.29 E10 Materials & Supplies 3,800.00 3,106.31 0.00 693.69 18.26 10-170-520030 Dues And Publications 1,468.00 1,055.00 0.00 413.00 28.13 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,500.00 0.00 0.00 0.00 10-170-520070 Training And Education 5,220.00 5,196.58 0.00 23.42 0.45 10-170-520080 Tuition Reimbursement 3,762.00 0.00 0.00 3,762.00 100.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 900.00 320.00 0.00 580.00 64.44 10-170-522020 Professional Services 5,000.00 2,099.21 0.00 2,900.79 58.02 10-170-529010 Special Events 500.00 296.00 0.00 204.00 40.80 10-170-529015 Human Relations Commission 5,000.00 1,667.38 0.00 3,332.62 66.65 E15 Contractual Services 25,350.00 14,134.17 0.00 11,215.83 44.24 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 237.00 128.13 0.00 108.87 45.94 E25 Repairs & Maintenance 237.00 128.13 0.00 108.87 45.94 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 327,695.79 321,333.04 0.00 6,362.75 1.94 180 Finance Department 10-180-501020 Salaries 632,055.83 607,992.56 0.00 24,063.27 3.81 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,545.67 45,133.05 0.00 4,412.62 8.91 10-180-502020 Group Health Insurance 83,788.45 83,551.79 0.00 236.66 0.28 10-180-502030 Retirement 80,956.98 67,455.73 0.00 13,501.25 16.68 10-180-502040 Workers Compensation 490.46 490.46 0.00 0.00 0.00 10-180-502050 Life Insurance 1,026.69 731.78 0.00 294.91 28.72 10-180-502060 Long Term Disability 2,112.81 1,702.61 0.00 410.20 19.41 10-180-502070 Employee Assistance Prgm 320.07 300.52 0.00 19.55 6.11 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 850,296.96 807,358.50 0.00 42,938.46 5.05 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511010 Advertising 1,000.00 764.80 0.00 235.20 23.52 10-180-511020 Postage 9,500.00 10,301.41 0.00 -801.41 -8.44 10-180-511021 Mail Machine Cost 2,600.00 2,114.54 0.00 485.46 18.67 10-180-512010 Printing 4,000.00 3,078.46 0.00 921.54 23.04 10-180-512020 Copies 1,500.00 1,147.99 0.00 352.01 23.47 10-180-512021 Copy Machine Cost 1,000.00 -356.61 0.00 1,356.61 135.66 10-180-513010 Office Supplies 4,000.00 1,210.57 0.00 2,789.43 69.74 10-180-517010 Operational Supplies 4,000.00 3,576.46 0.00 423.54 10.59 E10 Materials & Supplies 27,600.00 21,837.62 0.00 5,762.38 20.88 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,088.00 0.00 212.00 9.22 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 11,000.00 1,295.48 0.00 9,704.52 88.22 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 28,430.00 34,353.68 0.00 -5,923.68 -20.84 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 32.46 0.00 467.54 93.51 E15 Contractual Services 42,230.00 37,769.62 0.00 4,460.38 10.56 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,200.00 400.00 0.00 800.00 66.67 E25 Repairs & Maintenance 1,200.00 400.00 0.00 800.00 66.67 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 921,326.96 867,365.74 0.00 53,961.22 5.86 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 41,214.80 39,589.29 0.00 1,625.51 3.94 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 41,214.80 39,589.29 0.00 1,625.51 3.94 10-185-514010 Gas 13,000.00 10,294.44 0.00 2,705.56 20.81 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-514012 Building & Grounds Maint. Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 25,000.00 Tornado 0.00 411,552.26 0.00 -411,552.26 0.00 10-185-514016 1,872.00 Flooding 0.00 53,874.89 0.00 -53,874.89 0.00 E10 0.00 Materials & Supplies 13,000.00 475,721.59 0.00 -462,721.59 -3,559.40 10-185-520030 975.69 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 0.00 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 10-185-550025 General Insurance 310,142.01 336,040.53 0.00 -25,898.52 -8.35 10-185-521020 Addt'l PositionsEquipment Insurance Deductible 23,000.00 52,314.37 0.00 -29,314.37 -127.45 10-185-521030 0.00 Self Ins Prop & Casualty 50,000.00 68,088.77 0.00 -18,088.77 -36.18 10-185-521060 0.00 Drugalcohol screening 4,364.00 4,286.50 0.00 77.50 1.78 10-185-521070 0.00 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 0.00 TIF Prof Svcs 22,800.64 23,460.39 0.00 -659.75 -2.89 10-185-522020 0.00 Professional Services 29,199.50 25,129.47 0.00 4,070.03 13.94 10-185-522023 LCRA Reimbursement 259,000.00 79,656.95 0.00 179,343.05 69.24 10-185-522025 10-185-550042 JCTV 55,000.00 55,000.00 0.00 0.00 0.00 10-185-524010 JC Fire Museum Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 0.00 Assessment Charge 47,000.00 23,071.12 0.00 23,928.88 50.91 10-185-527020 0.00 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 7,000.00 8,760.43 0.00 -1,760.43 -25.15 E15 Contractual Services 992,506.15 860,808.53 0.00 131,697.62 13.27 10-185-531010 Electricity 42,000.00 31,203.76 0.00 10,796.24 25.71 10-185-533010 Natural Gas 6,400.00 5,482.42 0.00 917.58 14.34 10-185-535010 Water 7,250.00 6,396.34 0.00 853.66 11.77 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 43,082.52 0.00 12,567.48 22.58 10-185-540010 Building & Grounds Maint. 60,000.00 52,375.04 0.00 7,624.96 12.71 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 87,100.00 79,247.04 0.00 7,852.96 9.02 10-185-550010 Miscellaneous 5,000.00 4,024.31 0.00 975.69 19.51 10-185-550015 Bad Debt Expense 0.00 180.00 0.00 -180.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 3,000.00 3,045.96 0.00 -45.96 -1.53 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 1,000.00 500.00 0.00 500.00 50.00 10-185-550043 JC Fire Museum 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 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550060 MSP 15,000.00 15,000.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 34,000.00 32,750.27 0.00 1,249.73 3.68 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,223,470.95 1,531,199.24 0.00 -307,728.29 -25.15 190 Information Technology Svcs 10-190-501020 Salaries 549,787.91 551,840.00 0.00 -2,052.09 -0.37 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 105.22 0.00 1,094.78 91.23 10-190-501095 Overtime Straight Pay 0.00 61.38 0.00 -61.38 0.00 10-190-502010 Social Security 42,150.58 40,667.17 0.00 1,483.41 3.52 10-190-502020 Group Health Insurance 81,985.65 80,308.78 0.00 1,676.87 2.05 10-190-502030 Retirement 68,873.49 68,829.35 0.00 44.14 0.06 10-190-502040 Workers Compensation 1,248.89 1,248.89 0.00 0.00 0.00 10-190-502050 Life Insurance 856.31 684.86 0.00 171.45 20.02 10-190-502060 Long Term Disability 1,821.86 1,633.20 0.00 188.66 10.36 10-190-502070 Employee Assistance Prgm 258.78 242.96 0.00 15.82 6.11 E05 Personnel Services 748,183.47 745,621.81 0.00 2,561.66 0.34 10-190-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-190-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 9.56 0.00 90.44 90.44 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 421.92 0.00 78.08 15.62 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 3,500.00 3,449.91 0.00 50.09 1.43 E10 Materials & Supplies 4,250.00 3,881.39 0.00 368.61 8.67 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 319.00 0.00 181.00 36.20 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 12,000.00 8,794.22 0.00 3,205.78 26.71 10-190-520080 Tuition Reimbursement 1,300.00 0.00 0.00 1,300.00 100.00 10-190-522020 Professional Services 14,000.00 13,411.41 0.00 588.59 4.20 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-intemet Tl Web 21,000.00 20,734.36 0.00 265.64 1.26 10-190-522050 Service -remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 48,800.00 43,258.99 0.00 5,541.01 11.35 10-190-534010 Telephone 49,374.04 47,372.25 0.00 2,001.79 4.05 E20 Utilities 49,374.04 47,372.25 0.00 2,001.79 4.05 10-190-545010 Software Licensemaint 150,600.00 145,041.40 0.00 5,558.60 3.69 10-190-545020 Citywide Wiringnetwork 3,000.00 0.00 0.00 3,000.00 100.00 10-190-547010 Equipment Maintenance 1,474.05 1,474.05 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 18,000.00 17,153.84 0.00 846.16 4.70 E25 Repairs & Maintenance 173,074.05 163,669.29 0.00 9,404.76 5.43 10-190-572020 Purchase Of Equipment 18,151.91 18,037.61 0.00 114.30 0.63 E70 Capital Purchases 18,151.91 18,037.61 0.00 114.30 0.63 190 Information Technology Svcs 1,041,833.47 1,021,841.34 0.00 19,992.13 1.92 300 Police Department 10-300-501020 Salaries 4,437,315.63 4,274,047.29 0.00 163,268.34 3.68 10-300-501030 Holiday Pay 139,079.30 109,593.30 0.00 29,486.00 21.20 10-300-501040 Part-time (wbenefits) 20,913.54 0.00 0.00 20,913.54 100.00 10-300-501050 Parttime(wo Benefits) 66,208.36 59,893.18 0.00 6,315.18 9.54 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,264.00 0.00 736.00 14.72 10-300-501090 Overtime 358,217.84 372,078.53 0.00 -13,860.69 -3.87 10-300-501095 Overtime Straight Pay 8,665.74 18,170.33 0.00 -9,504.59 -109.68 10-300-502010 Social Security 377,653.38 352,876.69 0.00 24,776.69 6.56 10-300-502020 Group Health Insurance 834,518.57 736,827.36 0.00 97,691.21 11.71 10-300-502030 Retirement 848,446.67 806,350.79 0.00 42,095.88 4.96 10-300-502040 Workers Compensation 75,371.19 75,371.19 0.00 0.00 0.00 10-300-502050 Life Insurance 6,878.35 5,181.75 0.00 1,696.60 24.67 10-300-502060 Long Term Disability 14,854.34 12,549.79 0.00 2,304.55 15.51 10-300-502070 Employee Assistance Prgm 2,465.22 2,365.79 0.00 99.43 4.03 10-300-503010 Awards Program 1,600.00 254.50 0.00 1,345.50 84.09 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 7,198,188.13 6,829,824.49 0.00 368,363.64 5.12 10-300-511010 Advertising 2,530.00 3,248.62 0.00 -718.62 -28.40 10-300-511020 Postage 1,212.75 1,385.90 0.00 -173.15 -14.28 10-300-512010 Printing 5,290.00 4,730.56 0.00 559.44 10.58 10-300-512020 Copies 100.00 0.67 0.00 99.33 99.33 10-300-512030 Photographic Supplies 3,110.00 3,904.90 0.00 -794.90 -25.56 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-513010 Office Supplies 15,650.00 20,853.59 0.00 -5,203.59 -33.25 10-300-514010 Gas 155,000.00 163,865.70 0.00 -8,865.70 -5.72 10-300-514040 Food 700.00 662.36 0.00 37.64 5.38 10-300-515040 First Aid Supplies 1,300.00 1,647.78 0.00 -347.78 -26.75 10-300-516010 Ammunition & Firearms Supplies 44,130.00 45,155.18 0.00 -1,025.18 -2.32 10-300-516020 Dare Program 16,500.00 16,804.14 0.00 -304.14 -1.84 10-300-516030 Special Investigation 2,622.25 2,622.25 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 13,241.50 12,407.10 0.00 834.40 6.30 10-300-517010 Operational Supplies 42,995.79 49,854.83 0.00 -6,859.04 -15.95 E10 Materials & Supplies 304,382.29 327,143.58 0.00 -22,761.29 -7.48 10-300-520030 Dues And Publications 4,600.00 5,868.50 0.00 -1,268.50 -27.58 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 78,800.00 67,431.30 0.00 11,368.70 14.43 10-300-520080 Tuition Reimbursement 8,500.00 21,507.00 0.00 -13,007.00 -153.02 10-300-520090 Recruitment 1,000.00 976.69 0.00 23.31 2.33 10-300-521040 Medical Claimsservices 7,000.00 4,971.28 0.00 2,028.72 28.98 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 13,500.00 16,032.38 0.00 -2,532.38 -18.76 10-300-522026 Drug Forfeiture - Justice 8,000.00 8,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 14,879.13 0.00 -14,879.13 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 1,954.83 0.00 245.17 11.14 E15 Contractual Services 123,600.00 141,621.11 0.00 -18,021.11 -14.58 10-300-531010 Electricity 43,000.00 42,132.51 0.00 867.49 2.02 10-300-533010 Natural Gas 1,200.00 608.30 0.00 591.70 49.31 10-300-534010 Telephone 22,200.00 25,196.10 0.00 -2,996.10 -13.50 10-300-535010 Water 3,600.00 4,404.85 0.00 -804.85 -22.36 E20 Utilities 70,000.00 72,341.76 0.00 -2,341.76 -3.35 10-300-540010 Building & Grounds Maint. 53,598.00 67,825.48 0.00 -14,227.48 -26.54 10-300-541030 Vehicle Wash 12,000.00 9,694.45 0.00 2,305.55 19.21 10-300-544010 K-9 Operations 18,500.00 15,749.79 0.00 2,750.21 14.87 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 24,300.00 22,922.67 0.00 1,377.33 5.67 10-300-545010 Software Licensemaint 62,000.00 61,570.25 0.00 429.75 0.69 10-300-546010 Clothing Expense 50,120.28 54,127.10 0.00 -4,006.82 -7.99 10-300-546020 Uniform Cleaning 21,000.00 21,477.39 0.00 -477.39 -2.27 10-300-547010 Equipment Maintenance 9,350.00 10,998.91 0.00 -1,648.91 -17.64 10-300-547020 Maintenance Agreements 45,000.00 48,008.22 0.00 -3,008.22 -6.68 10-300-547030 Radio Maintenance 10,000.00 7,970.19 0.00 2,029.81 20.30 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 305,868.28 320,344.45 0.00 -14,476.17 -4.73 10-300-572010 Purchase Of Vehicles 276,329.11 276,368.50 0.00 -39.39 -0.01 10-300-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 8,772.00 0.00 0.00 8,772.00 100.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 7,156.20 7,156.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-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 32,293.33 7,659.71 0.00 24,633.62 76.28 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,770.80 4,770.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 329,321.44 295,955.21 0.00 33,366.23 10.13 300 Police Department 8,331,360.14 7,987,230.60 0.00 344,129.54 4.13 310 School Resource Officer 10-310-501020 Salaries 386,137.87 391,839.31 0.00 -5,701.44 -1.48 10-310-501030 Holiday Pay 14,843.15 4,701.27 0.00 10,141.88 68.33 10-310-501090 Overtime 17,126.00 62,736.60 0.00 -45,610.60 -266.32 10-310-501095 Overtime Straight Pay 410.00 2,818.96 0.00 -2,408.96 -587.55 10-310-502010 Social Security 32,016.55 32,771.59 0.00 -755.04 -2.36 10-310-502020 Group Health Insurance 82,710.43 84,216.67 0.00 -1,506.24 -1.82 10-310-502030 Retirement 75,333.06 82,758.43 0.00 -7,425.37 -9.86 10-310-502040 Workers Compensation 5,129.35 5,129.35 0.00 0.00 0.00 10-310-502050 Life Insurance 613.22 491.98 0.00 121.24 19.77 10-310-502060 Long Term Disability 1,324.61 1,188.46 0.00 136.15 10.28 10-310-502070 Employee Assistance Prgm 217.92 204.60 0.00 13.32 6.11 E05 Personnel Services 615,862.16 668,857.22 0.00 -52,995.06 -8.61 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-517010 Operational Supplies 11,004.21 3,421.07 0.00 7,583.14 68.91 E10 Materials & Supplies 11,004.21 3,421.07 0.00 7,583.14 68.91 10-310-520070 Training And Education 5,000.00 7,132.77 0.00 -2,132.77 -42.66 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,000.00 7,132.77 0.00 -2,132.77 -42.66 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 9,278.22 5,355.47 0.00 3,922.75 42.28 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 9,278.22 5,355.47 0.00 3,922.75 42.28 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 641,144.59 684,766.53 0.00 -43,621.94 -6.80 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 94,620.00 96,918.02 0.00 -2,298.02 -2.43 10-320-501030 Holiday Pay 3,570.00 355.00 0.00 3,215.00 90.06 10-320-501090 Overtime 25,240.75 25,878.41 0.00 -637.66 -2.53 10-320-501095 Overtime Straight Pay 0.00 133.13 0.00 -133.13 0.00 10-320-502010 Social Security 8,039.16 8,908.26 0.00 -869.10 -10.81 10-320-502020 Group Health Insurance 21,543.04 20,439.46 0.00 1,103.58 5.12 10-320-502030 Retirement 18,915.66 21,789.46 0.00 -2,873.80 -15.19 10-320-502040 Workers Compensation 1,744.38 1,744.38 0.00 0.00 0.00 10-320-502050 Life Insurance 146.39 116.98 0.00 29.41 20.09 10-320-502060 Long Term Disability 315.55 282.80 0.00 32.75 10.38 10-320-502070 Employee Assistance Prgm 54.48 51.16 0.00 3.32 6.09 E05 Personnel Services 174,189.41 176,617.06 0.00 -2,427.65 -1.39 10-320-514010 Gas 6,000.00 6,701.21 0.00 -701.21 -11.69 10-320-516040 Investigations 14,350.00 16,432.61 0.00 -2,082.61 -14.51 10-320-517010 Operational Supplies 10,366.02 2,655.70 0.00 7,710.32 74.38 E10 Materials & Supplies 30,716.02 25,789.52 0.00 4,926.50 16.04 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 1,060.00 0.00 -1,060.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 18,000.00 12,550.00 0.00 5,450.00 30.28 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,000.00 13,610.00 0.00 4,390.00 24.39 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 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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. 222,905.43 216,016.58 0.00 6,888.85 3.09 330 Animal Control 0.00 0.00 0.00 0.00 0.00 10-330-501020 Salaries 346,830.48 344,276.72 0.00 2,553.76 0.74 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,300.00 0.00 8.00 0.19 10-330-501090 Overtime 1,709.00 5,728.83 0.00 -4,019.83 -235.22 10-330-501095 Overtime Straight Pay 500.00 50.11 0.00 449.89 89.98 10-330-502010 Social Security 27,031.08 25,724.71 0.00 1,306.37 4.83 10-330-502020 Group Health Insurance 71,563.22 66,486.07 0.00 5,077.15 7.09 10-330-502030 Retirement 44,168.44 41,536.27 0.00 2,632.17 5.96 10-330-502040 Workers Compensation 4,269.54 4,269.54 0.00 0.00 0.00 10-330-502050 Life Insurance 549.33 413.75 0.00 135.58 24.68 10-330-502060 Long Term Disability 1,177.24 996.68 0.00 180.56 15.34 10-330-502070 Employee Assistance Prgm 217.92 153.45 0.00 64.47 29.58 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 502,324.25 493,936.13 0.00 8,388.12 1.67 10-330-511010 Advertising 120.00 0.00 0.00 120.00 100.00 10-330-511020 Postage 100.00 132.62 0.00 -32.62 -32.62 10-330-512010 Printing 1,600.00 1,925.60 0.00 -325.60 -20.35 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,700.00 2,106.80 0.00 -406.80 -23.93 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 644.91 0.00 -404.91 -168.71 10-330-515040 First Aid Supplies 500.00 358.31 0.00 141.69 28.34 10-330-517010 Operational Supplies 11,900.00 9,665.02 0.00 2,234.98 18.78 E10 Materials & Supplies 16,160.00 14,833.26 0.00 1,326.74 8.21 10-330-520030 Dues And Publications 1,150.00 1,271.25 0.00 -121.25 -10.54 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,450.00 3,114.07 0.00 -664.07 -27.10 10-330-521040 Medical Claimsservices 464.00 680.00 0.00 -216.00 -46.55 10-330-522020 Professional Services 5,200.00 6,699.33 0.00 -1,499.33 -28.83 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,600.00 5,667.45 0.00 -67.45 -1.20 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 1,320.00 1,813.40 0.00 -493.40 -37.38 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 16,184.00 19,245.50 0.00 -3,061.50 -18.92 10-330-531010 Electricity 23,152.00 22,670.38 0.00 481.62 2.08 10-330-533010 Natural Gas 18,700.00 18,632.88 0.00 67.12 0.36 10-330-534010 Telephone 300.00 306.04 0.00 -6.04 -2.01 10-330-535010 Water 3,800.00 3,951.69 0.00 -151.69 -3.99 E20 Utilities 45,952.00 45,560.99 0.00 391.01 0.85 10-330-540010 Building & Grounds Maint. 12,000.00 65,180.62 0.00 -53,180.62 -443.17 10-330-541020 Veh Maintenance 0.00 540.00 0.00 -540.00 0.00 10-330-541030 Vehicle Wash 540.00 0.00 0.00 540.00 100.00 10-330-544040 Care Of Animals 49,400.00 51,990.75 0.00 -2,590.75 -5.24 10-330-544050 Animal Food 5,000.00 5,643.17 0.00 -643.17 -12.86 10-330-545010 Software Licensemaint 3,125.36 3,005.30 0.00 120.06 3.84 10-330-546010 Clothing Expense 2,500.00 1,882.33 0.00 617.67 24.71 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 900.00 579.28 0.00 320.72 35.64 10-330-547020 Maintenance Agreements 0.00 100.00 0.00 -100.00 0.00 10-330-547030 Radio Maintenance 250.00 35.70 0.00 214.30 85.72 E25 Repairs & Maintenance 73,715.36 128,957.15 0.00 -55,241.79 -74.94 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 654,335.61 702,533.03 0.00 -48,197.42 -7.37 390 9-1-1 Police 10-390-501020 Salaries 893,961.98 866,780.33 0.00 27,181.65 3.04 10-390-501030 Holiday Pay 31,165.19 27,808.20 0.00 3,356.99 10.77 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 15,814.00 53,916.48 0.00 -38,102.48 -240.94 10-390-501095 Overtime Straight Pay 500.00 1,676.33 0.00 -1,176.33 -235.27 10-390-502010 Social Security 72,020.25 68,754.55 0.00 3,265.70 4.53 10-390-502020 Group Health Insurance 176,657.52 172,763.42 0.00 3,894.10 2.20 10-390-502030 Retirement 119,725.16 115,537.42 0.00 4,187.74 3.50 10-390-502040 Workers Compensation 1,538.00 1,538.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,411.88 1,043.05 0.00 368.83 26.12 10-390-502060 Long Term Disability 3,033.44 2,520.10 0.00 513.34 16.92 10-390-502070 Employee Assistance Prgm 578.85 543.49 0.00 35.36 6.11 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,316,406.27 1,312,881.37 0.00 3,524.90 0.27 10-390-511010 Advertisine 100.00 0.00 0.00 100.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-512010 Printing 0.00 170.00 0.00 -170.00 0.00 10-390-517010 Operational Supplies 5,000.00 5,236.66 0.00 -236.66 -4.73 E10 Materials & Supplies 5,100.00 5,406.66 0.00 -306.66 -6.01 10-390-520030 Dues And Publications 600.00 354.00 0.00 246.00 41.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,000.00 5,541.73 0.00 -541.73 -10.83 10-390-522020 Professional Services 2,700.00 3,661.67 0.00 -961.67 -35.62 10-390-523010 Equipment Rentlease 98,000.00 95,597.21 0.00 2,402.79 2.45 E15 Contractual Services 106,300.00 105,154.61 0.00 1,145.39 1.08 10-390-531010 Electricity 12,000.00 13,091.38 0.00 -1,091.38 -9.09 10-390-533010 Natural Gas 300.00 260.76 0.00 39.24 13.08 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 900.00 343.04 0.00 556.96 61.88 E20 Utilities 13,200.00 13,695.18 0.00 -495.18 -3.75 10-390-545010 Software Licensemaint 29,251.00 29,251.00 0.00 0.00 0.00 10-390-546010 Clothing Expense 6,000.00 1,457.51 0.00 4,542.49 75.71 10-390-546020 Uniform Cleaning 2,700.00 3,052.29 0.00 -352.29 -13.05 10-390-547010 Equipment Maintenance 3,000.00 3,164.53 0.00 -164.53 -5.48 10-390-547020 Maintenance Agreements 49,535.98 48,463.43 0.00 1,072.55 2.17 10-390-547030 Radio Maintenance 5,000.00 4,367.70 0.00 632.30 12.65 E25 Repairs & Maintenance 95,486.98 89,756.46 0.00 5,730.52 6.00 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,536,493.25 1,526,894.28 0.00 9,598.97 0.62 400 Fire Department 10-400-501020 Salaries 3,896,472.91 3,802,708.16 0.00 93,764.75 2.41 10-400-501030 Holiday Pay 292,107.44 282,807.86 0.00 9,299.58 3.18 10-400-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,500.00 39,270.00 0.00 -10,770.00 -37.79 10-400-501090 Overtime 41,000.00 111,601.82 0.00 -70,601.82 -172.20 10-400-501095 Overtime Straight Pay 33,000.00 53,363.85 0.00 -20,363.85 -61.71 10-400-502010 Social Security 64,774.59 61,226.96 0.00 3,547.63 5.48 10-400-502020 Group Health Insurance 733,881.54 694,649.82 0.00 39,231.72 5.35 10-400-502030 Retirement 1,960,097.52 1,904,918.10 0.00 55,179.42 2.82 10-400-502040 Workers Compensation 152,968.09 152,968.09 0.00 0.00 0.00 10-400-502050 Life Insurance 6,051.95 4,699.97 0.00 1,351.98 22.34 10-400-502060 Long Term Disability 13,140.43 11,307.82 0.00 1,832.61 13.95 10-400-502070 Employee Assistance Prgm 2,070.24 1,943.76 0.00 126.48 6.11 10-400-503010 Awards Program 1,500.00 565.00 0.00 935.00 62.33 E05 Personnel Services 7,225,564.71 7,122,031.21 0.00 103,533.50 1.43 10-400-511010 Advertising 850.00 869.45 0.00 -19.45 -2.29 10-400-511020 Postaee 200.00 112.22 0.00 87.78 43.89 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-512010 Purchase Of Vehicles Printing 850.00 617.16 0.00 232.84 27.39 10-400-512020 0.00 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 15,614.00 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 0.00 Office Supplies 1,500.00 1,528.86 0.00 -28.86 -1.92 10-400-514010 11,920.59 Gas 49,000.00 56,318.04 0.00 -7,318.04 -14.93 10-400-514020 4.32 Chemicals 1,500.00 701.29 0.00 798.71 53.25 10-400-514030 10-400-575004 Small Tools 5,000.00 5,539.38 0.00 -539.38 -10.79 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 3,559.12 4,391.12 0.00 -832.00 -23.38 10-400-517010 Operational Supplies 13,157.00 17,879.29 0.00 -4,722.29 -35.89 E10 Materials & Supplies 75,666.12 87,956.81 0.00 -12,290.69 -16.24 10-400-520030 Dues And Publications 3,260.00 3,373.65 0.00 -113.65 -3.49 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,500.00 31,227.51 0.00 1,272.49 3.92 10-400-520080 Tuition Reimbursement 4,500.00 6,814.00 0.00 -2,314.00 -51.42 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 9,700.00 6,119.75 0.00 3,580.25 36.91 10-400-522020 Professional Services 500.00 2,564.47 0.00 -2,064.47 -412.89 10-400-523010 Equipment Rentlease 300.00 16.05 0.00 283.95 94.65 10-400-524010 Trash Collections 100.00 19.11 0.00 80.89 80.89 10-400-529010 Special Events 6,590.00 5,472.23 0.00 1,117.77 16.96 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,080.00 0.00 1,420.00 56.80 E15 Contractual Services 59,950.00 56,686.77 0.00 3,263.23 5.44 10-400-531010 Electricity 32,000.00 34,478.17 0.00 -2,478.17 -7.74 10-400-533010 Natural Gas 19,000.00 17,468.22 0.00 1,531.78 8.06 10-400-534010 Telephone 22,000.00 23,342.59 0.00 -1,342.59 -6.10 10-400-535010 Water 17,000.00 17,146.98 0.00 -146.98 -0.86 E20 Utilities 90,000.00 92,435.96 0.00 -2,435.96 -2.71 10-400-540010 Building & Grounds Maint. 96,184.73 69,422.28 0.00 26,762.45 27.82 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,500.00 69,085.63 0.00 414.37 0.60 10-400-546020 Uniform Cleaning 300.00 378.00 0.00 -78.00 -26.00 10-400-547010 Equipment Maintenance 17,075.00 20,667.24 0.00 -3,592.24 -21.04 10-400-547020 Maintenance Agreements 25,000.00 24,838.94 0.00 161.06 0.64 10-400-547030 Radio Maintenance 21,315.27 19,476.03 0.00 1,839.24 8.63 E25 Repairs & Maintenance 229,375.00 203,868.12 0.00 25,506.88 11.12 10-400-572010 Purchase Of Vehicles 49,365.00 49,589.71 0.00 -224.71 -0.46 10-400-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 15,615.00 15,614.00 0.00 1.00 0.01 10-400-572021 Purchase of Equipment -ONE TIME 11,216.19 0.00 0.00 11,216.19 100.00 10-400-572022 Fitness -ONE TIME 178,345.00 166,424.41 0.00 11,920.59 6.68 10-400-572060 Fire Grant Equipgear 8,323.00 7,963.16 0.00 359.84 4.32 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 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 262,864.19 239,591.28 0.00 23,272.91 8.85 400 Fire Department 7,943,420.02 7,802,570.15 0.00 140,849.87 1.77 401 Fire Museum 10-401-531010 Electricity 2,200.00 957.89 0.00 1,242.11 56.46 10-401-533010 Natural Gas 0.00 554.87 0.00 -554.87 0.00 10-401-535010 Water 0.00 337.08 0.00 -337.08 0.00 E20 Utilities 2,200.00 1,849.84 0.00 350.16 15.92 10-401-540010 Building & Grounds Maint. 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 2,200.00 1,849.84 0.00 350.16 15.92 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 181,798.44 174,879.63 0.00 6,918.81 3.81 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 13,907.58 13,067.45 0.00 840.13 6.04 10-520-502020 Group Health Insurance 21,927.17 22,322.88 0.00 -395.71 -1.80 10-520-502030 Retirement 22,724.80 21,803.33 0.00 921.47 4.05 10-520-502040 Workers Compensation 211.06 211.06 0.00 0.00 0.00 10-520-502050 Life Insurance 283.23 215.66 0.00 67.57 23.86 10-520-502060 Long Term Disability 546.15 459.05 0.00 87.10 15.95 10-520-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 241,480.15 233,035.78 0.00 8,444.37 3.50 10-520-511010 Advertising 20.98 0.00 0.00 20.98 100.00 10-520-511020 Postage 353.02 353.02 0.00 0.00 0.00 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 720.87 711.03 0.00 9.84 1.37 10-520-514010 Gas 11,179.13 11,611.62 0.00 -432.49 -3.87 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 446.20 446.20 0.00 0.00 0.00 E10 Materials & Supplies 12,720.20 13,121.87 0.00 -401.67 -3.16 10-520-520030 Dues And Publications 1,055.75 1,055.75 0.00 0.00 0.00 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 2,055.81 2,055.81 0.00 0.00 0.00 10-520-522020 Professional Services 5,917.74 917.74 0.00 5,000.00 84.49 E15 Contractual Services 9,029.30 4,029.30 0.00 5,000.00 55.38 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 379.50 379.50 0.00 0.00 0.00 E25 Repairs & Maintenance 379.50 379.50 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs -Admin 263,609.15 250,566.45 0.00 13,042.70 4.95 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 135,81096 136,333.14 0.00 -522.18 -0.38 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 1,204.35 0.00 -1,204.35 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 10,389.54 9,903.15 0.00 486.39 4.68 10-521-502020 Group Health Insurance 29,147.19 29,631.29 0.00 -484.10 -1.66 10-521-502030 Retirement 16,976.37 16,900.40 0.00 75.97 0.45 10-521-502040 Workers Compensation 146.75 146.75 0.00 0.00 0.00 10-521-502050 Life Insurance 214.22 170.59 0.00 43.63 20.37 10-521-502060 Long Term Disability 460.13 414.11 0.00 46.02 10.00 10-521-502070 Employee Assistance Prgm 73.55 69.04 0.00 4.51 6.13 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 193,218.71 194,772.82 0.00 -1,554.11 -0.80 10-521-511010 Advertising 4,250.00 3,196.25 0.00 1,053.75 24.79 10-521-511020 Postage 1,000.00 441.17 0.00 558.83 55.88 10-521-512010 Printing 100.00 25.78 0.00 74.22 74.22 10-521-512020 Copies 10.00 6.73 0.00 3.27 32.70 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 845.24 0.00 154.76 15.48 10-521-514040 Food 250.00 285.70 0.00 -35.70 -14.28 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 581.79 0.00 1,418.21 70.91 E10 Materials & Supplies 8,610.00 5,382.66 0.00 3,227.34 37.48 10-521-520030 Dues And Publications 14,800.00 14,021.99 0.00 778.01 5.26 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,625.00 706.66 0.00 918.34 56.51 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 16,425.00 14,728.65 0.00 1,696.35 10.33 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,121.00 1,948.18 0.00 -827.18 -73.79 E25 Repairs & Maintenance 1,121.00 1,948.18 0.00 -827.18 -73.79 Page 21 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs -Planning 219,374.71 216,832.31 0.00 2,542.40 1.16 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 119,716.57 115,501.69 0.00 4,214.88 3.52 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,158.32 8,743.98 0.00 414.34 4.52 10-522-502020 Group Health Insurance 17,239.64 15,624.64 0.00 1,615.00 9.37 10-522-502030 Retirement 14,964.57 12,380.32 0.00 2,584.25 17.27 10-522-502040 Workers Compensation 94.28 94.28 0.00 0.00 0.00 10-522-502050 Life Insurance 188.11 142.19 0.00 45.92 24.41 10-522-502060 Long Term Disability 405.14 341.15 0.00 63.99 15.79 10-522-502070 Employee Assistance Prgm 62.65 58.84 0.00 3.81 6.08 E05 Personnel Services 161,829.28 152,887.09 0.00 8,942.19 5.53 10-522-511010 Advertising 1,000.00 514.80 0.00 485.20 48.52 10-522-511020 Postage 200.00 79.34 0.00 120.66 60.33 10-522-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-522-512020 Copies 10.00 0.46 0.00 9.54 95.40 10-522-513010 Office Supplies 1,000.00 295.07 0.00 704.93 70.49 10-522-514040 Food 250.00 18.93 0.00 231.07 92.43 10-522-517010 Operational Supplies 2,004.39 477.02 0.00 1,527.37 76.20 E10 Materials & Supplies 4,464.39 1,385.62 0.00 3,078.77 68.96 10-522-520030 Dues And Publications 1,500.00 1,351.30 0.00 148.70 9.91 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 3,500.00 2,718.67 0.00 781.33 22.32 10-522-522020 Professional Services 94,393.31 74,051.87 0.00 20,341.44 21.55 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 99,393.31 78,121.84 0.00 21,271.47 21.40 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 1,611.61 1,611.61 0.00 0.00 0.00 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,611.61 1,611.61 0.00 0.00 0.00 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 267,298.59 234,006.16 0.00 33,292.43 12.46 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 530 Plan & Protect Svc-RedevGrant 0.00 0.00 0.00 0.00 0.00 10-530-501020 Salaries 76,653.41 74,644.96 0.00 2,008.45 2.62 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,055.24 5,262.82 0.00 792.42 13.09 10-530-502020 Group Health Insurance 9,632.67 8,819.96 0.00 812.71 8.44 10-530-502030 Retirement 9,894.18 9,176.66 0.00 717.52 7.25 10-530-502040 Workers Compensation 53.40 53.40 0.00 0.00 0.00 10-530-502050 Life Insurance 124.11 93.32 0.00 30.79 24.81 10-530-502060 Long Term Disability 266.46 225.70 0.00 40.76 15.30 10-530-502070 Employee Assistance Prgm 40.86 38.36 0.00 2.50 6.12 E05 Personnel Services 102,720.33 98,315.18 0.00 4,405.15 4.29 10-530-511010 Advertising 830.50 830.50 0.00 0.00 0.00 10-530-511020 Postage 284.07 182.69 0.00 101.38 35.69 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 726.87 726.87 0.00 0.00 0.00 10-530-517010 Operational Supplies 1,029.39 1,029.39 0.00 0.00 0.00 E10 Materials & Supplies 2,970.83 2,769.45 0.00 201.38 6.78 10-530-520030 Dues And Publications 1,250.00 894.07 0.00 355.93 28.47 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 3,059.02 3,059.02 0.00 0.00 0.00 10-530-522020 Professional Services 90.92 70.00 0.00 20.92 23.01 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 18,800.00 18,800.00 0.00 0.00 0.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 2,000.00 2,000.00 0.00 0.00 0.00 10-530-524029 Recycling Education 9,000.00 9,000.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 465.38 375.00 0.00 90.38 19.42 E15 Contractual Services 34,665.32 34,198.09 0.00 467.23 1.35 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 179.00 138.24 0.00 40.76 22.77 E25 Repairs & Maintenance 179.00 138.24 0.00 40.76 22.77 10-530-550020 NRA -Residential 55,000.00 53,943.91 0.00 1,056.09 1.92 10-530-550030 NRA -Commercial Facade 19,500.00 19,412.88 0.00 87.12 0.45 10-530-550031 Historic Preservation Grant 23,000.00 19,750.00 0.00 3,250.00 14.13 10-530-550032 NRA -Rental Facade 7,000.00 5,118.63 0.00 1,881.37 26.88 10-530-550033 HPF Grant -Structural Survey 40,000.00 0.00 0.00 40,000.00 100.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 913.85 913.85 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-550039 Historic Preservation Grant 46,000.00 42,000.00 0.00 4,000.00 8.70 10-530-550050 Neighb Stablization Prog 47,097.38 0.00 0.00 47,097.38 100.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 238,511.23 141,139.27 0.00 97,371.96 40.82 530 Plan & Protect Svc-RedevGrant 379,046.71 276,560.23 0.00 102,486.48 27.04 531 Plan & Protect Svcs -Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) 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-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 0.00 0.00 0.00 0.00 0.00 10-532-501020 Salaries 176,225.85 176,899.75 0.00 -673.90 -0.38 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 300.00 0.00 0.00 300.00 100.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 13,504.23 12,397.58 0.00 1,106.65 8.19 10-532-502020 Group Health Insurance 33,180.29 32,584.63 0.00 595.66 1.80 10-532-502030 Retirement 22,065.73 22,057.38 0.00 8.35 0.04 10-532-502040 Workers Compensation 3,450.70 3,450.70 0.00 0.00 0.00 10-532-502050 Life Insurance 275.40 219.96 0.00 55.44 20.13 10-532-502060 Long Term Disability 595.11 535.12 0.00 59.99 10.08 10-532-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 249,679.03 248,221.84 0.00 1,457.19 0.58 10-532-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-532-511020 Postage 200.00 106.81 0.00 93.19 46.60 10-532-512010 Printing 50.00 42.00 0.00 8.00 16.00 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,681.64 1,378.67 0.00 302.97 18.02 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 932.43 0.00 67.57 6.76 E10 Materials & Supplies 3,116.64 2,459.91 0.00 656.73 21.07 10-532-520030 Dues And Publications 1,000.00 927.44 0.00 72.56 7.26 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 916.56 0.00 83.44 8.34 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 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Mise Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 192,000.00 192,000.00 0.00 0.00 0.00 10-532-529010 Special Events 231.75 32.50 0.00 199.25 85.98 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 194,231.75 193,876.50 0.00 355.25 0.18 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 31,506.55 31,506.55 0.00 0.00 0.00 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 780.06 780.06 0.00 0.00 0.00 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 695.00 483.24 0.00 211.76 30.47 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 34,351.61 34,053.85 0.00 297.76 0.87 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 481,379.03 478,612.10 0.00 2,766.93 0.57 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 157,104.49 156,404.11 0.00 700.38 0.45 10-533-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-533-501060 Seasonal Salaries 28,740.85 24,814.61 0.00 3,926.24 13.66 10-533-501090 Overtime 1,200.00 1,133.45 0.00 66.55 5.55 10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00 10-533-502010 Social Security 14,876.53 13,020.50 0.00 1,856.03 12.48 10-533-502020 Group Health Insurance 28,549.93 28,890.12 0.00 -340.19 -1.19 10-533-502030 Retirement 19,820.56 19,646.36 0.00 174.20 0.88 10-533-502040 Workers Compensation 1,918.70 1,918.70 0.00 0.00 0.00 10-533-502050 Life Insurance 220.32 174.70 0.00 45.62 20.71 10-533-502060 Long Term Disability 531.22 474.40 0.00 56.82 10.70 10-533-502070 Employee Assistance Prgm 95.34 89.52 0.00 5.82 6.10 E05 Personnel Services 253,317.94 246,566.47 0.00 6,751.47 2.67 10-533-511010 Advertising 200.00 168.00 0.00 32.00 16.00 10-533-511020 Postage 1,900.00 1,810.94 0.00 89.06 4.69 10-533-512010 Printing 1,000.00 238.71 0.00 761.29 76.13 10-533-512020 Copies 15.00 0.56 0.00 14.44 96.27 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,200.00 744.04 0.00 455.96 38.00 10-533-514030 Small Tools 150.00 102.73 0.00 47.27 31.51 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Sunnlies 1.194.07 1.194.07 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 5,674.07 4,259.05 0.00 1,415.02 24.94 10-533-520030 Dues And Publications 1,100.00 254.87 0.00 845.13 76.83 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 658.00 0.00 0.00 658.00 100.00 10-533-520080 Tuition Reimbursement 5,904.00 5,904.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 42,123.00 41,307.00 0.00 816.00 1.94 10-533-522022 Demo 58,605.00 9,202.50 0.00 49,402.50 84.30 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 108,390.00 56,668.37 0.00 51,721.63 47.72 10-533-534010 Telephone 3,898.30 3,898.30 0.00 0.00 0.00 E20 Utilities 3,898.30 3,898.30 0.00 0.00 0.00 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,396.78 990.76 0.00 406.02 29.07 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 13,429.00 13,160.51 0.00 268.49 2.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,125.78 14,421.27 0.00 704.51 4.66 10-533-572020 Purchase Of Equipment 7,168.00 4,812.61 0.00 2,355.39 32.86 E70 Capital Purchases 7,168.00 4,812.61 0.00 2,355.39 32.86 533 PPS - Prop MaintCode Enforce 393,574.09 330,626.07 0.00 62,948.02 15.99 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 319,822.94 314,951.41 0.00 4,871.53 1.52 10-534-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 1,195.32 1,195.32 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 24,562.87 22,565.40 0.00 1,997.47 8.13 10-534-502020 Group Health Insurance 70,799.18 66,109.73 0.00 4,689.45 6.62 10-534-502030 Retirement 40,135.41 39,418.38 0.00 717.03 1.79 10-534-502040 Workers Compensation 4,097.43 4,097.43 0.00 0.00 0.00 10-534-502050 Life Insurance 504.53 392.02 0.00 112.51 22.30 10-534-502060 Long Term Disability 1,083.73 948.88 0.00 134.85 12.44 10-534-502070 Employee Assistance Prgm 163.44 153.44 0.00 10.00 6.12 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 462,429.85 449,832.01 0.00 12,597.84 2.72 10-534-511010 Advertising 785.00 785.00 0.00 0.00 0.00 10-534-511020 Postage 1,376.37 1,376.37 0.00 0.00 0.00 10-534-512010 Printing 350.00 244.00 0.00 106.00 30.29 10-534-512020 Conies 15.00 0.00 0.00 15.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 1,251.56 1,251.56 0.00 0.00 0.00 10-534-514030 Small Tools 481.00 481.00 0.00 0.00 0.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,341.07 1,055.18 0.00 285.89 21.32 E10 Materials & Supplies 5,615.00 5,193.11 0.00 421.89 7.51 10-534-520030 Dues And Publications 2,315.00 1,965.84 0.00 349.16 15.08 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 6,420.89 6,312.93 0.00 107.96 1.68 10-534-522020 Professional Services 1,579.11 1,579.11 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 10,315.00 9,857.88 0.00 457.12 4.43 10-534-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-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,226.61 1,226.61 0.00 0.00 0.00 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 967.39 838.16 0.00 129.23 13.36 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,484.00 2,334.77 0.00 149.23 6.01 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 480,843.85 467,217.77 0.00 13,626.08 2.83 535 Public Works -Central Maintenan 10-535-501020 Salaries 346,408.71 344,778.44 0.00 1,630.27 0.47 10-535-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits) 7,308.68 3,642.50 0.00 3,666.18 50.16 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 15,995.88 0.00 -11,495.88 -255.46 10-535-501095 Overtime Straight Pay 591.32 591.32 0.00 0.00 0.00 10-535-502010 Social Security 27,448.87 26,705.06 0.00 743.81 2.71 10-535-502020 Group Health Insurance 73,150.39 72,806.65 0.00 343.74 0.47 10-535-502030 Retirement 43,926.09 45,060.42 0.00 -1,134.33 -2.58 10-535-502040 Workers Compensation 4,190.81 4,190.81 0.00 0.00 0.00 10-535-502050 Life Insurance 543.46 436.72 0.00 106.74 19.64 10-535-502060 Long Term Disability 1,175.53 1,056.73 0.00 118.80 10.11 10-535-502070 Employee Assistance Prgm 190.68 179.04 0.00 11.64 6.10 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 509,434.54 515,443.57 0.00 -6,009.03 -1.18 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-511010 Advertising 367.90 367.90 0.00 0.00 0.00 10-535-511020 Postage 50.00 5.75 0.00 44.25 88.50 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 1,036.36 0.00 463.64 30.91 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 8,000.00 5,605.12 0.00 2,394.88 29.94 10-535-517010 Operational Supplies 5,478.71 5,228.39 0.00 250.32 4.57 E10 Materials & Supplies 15,406.61 12,243.52 0.00 3,163.09 20.53 10-535-520030 Dues And Publications 170.00 170.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 3,380.29 4,402.15 0.00 -1,021.86 -30.23 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 4,050.29 5,072.15 0.00 -1,021.86 -25.23 10-535-531010 Electricity 7,560.00 6,644.93 0.00 915.07 12.10 10-535-533010 Natural Gas 5,793.69 2,631.57 0.00 3,162.12 54.58 10-535-534010 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 Water 1,442.00 1,314.48 0.00 127.52 8.84 E20 Utilities 15,015.69 10,590.98 0.00 4,424.71 29.47 10-535-540010 Building & Grounds Maint. 10,000.00 9,064.79 0.00 935.21 9.35 10-535-541010 Veh & Equip Parts Etc 500,000.00 561,788.50 0.00 -61,788.50 -12.36 10-535-546010 Clothing Expense 5,902.00 6,756.52 0.00 -854.52 -14.48 10-535-547010 Equipment Maintenance 3,000.00 1,828.82 0.00 1,171.18 39.04 10-535-547020 Maintenance Agreements 13,787.41 15,660.56 0.00 -1,873.15 -13.59 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 532,789.41 595,099.19 0.00 -62,309.78 -11.70 10-535-572020 Purchase Of Equipment 11,500.00 9,556.98 0.00 1,943.02 16.90 E70 Capital Purchases 11,500.00 9,556.98 0.00 1,943.02 16.90 535 Public Works -Central Maintenan 1,088,196.54 1,148,006.39 0.00 -59,809.85 -5.50 540 Public Works -Admin 10-540-501020 Salaries 214,516.68 215,350.58 0.00 -833.90 -0.39 10-540-501090 Overtime 0.00 26.31 0.00 -26.31 0.00 10-540-501095 Overtime Straight Pay 0.00 19.73 0.00 -19.73 0.00 10-540-502010 Social Security 16,410.53 15,856.01 0.00 554.52 3.38 10-540-502020 Group Health Insurance 30,866.53 26,957.52 0.00 3,909.01 12.66 10-540-502030 Retirement 26,814.59 26,857.28 0.00 -42.69 -0.16 10-540-502040 Workers Compensation 201.34 201.34 0.00 0.00 0.00 10-540-502050 Life Insurance 335.87 268.62 0.00 67.25 20.02 10-540-502060 Long Term Disability 600.49 535.83 0.00 64.66 10.77 10-540-502070 Employee Assistance Prgm 81.72 76.72 0.00 5.00 6.12 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 289,827.75 286,149.94 0.00 3,677.81 1.27 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 7.54 11.04 0.00 -3.50 -46.42 10-540-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-540-512020 Copies 0.39 0.39 0.00 0.00 0.00 10-540-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-540-514010 Gas 77,316.99 91,767.87 0.00 -14,450.88 -18.69 10-540-514040 Food 218.00 217.97 0.00 0.03 0.01 10-540-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 77,542.92 91,997.27 0.00 -14,454.35 -18.64 10-540-520030 Dues And Publications 672.60 672.60 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,228.60 3,228.60 0.00 0.00 0.00 10-540-522020 Professional Services 55.88 0.00 0.00 55.88 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,957.08 3,901.20 0.00 55.88 1.41 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 370.00 265.83 0.00 104.17 28.15 E25 Repairs & Maintenance 370.00 265.83 0.00 104.17 28.15 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works -Admin 371,697.75 382,314.24 0.00 -10,616.49 -2.86 541 Public Works -Engineering 10-541-501020 Salaries 795,715.28 791,228.01 0.00 4,487.27 0.56 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 651.94 765.52 0.00 -113.58 -17.42 10-541-501095 Overtime Straight Pay 148.06 17.99 0.00 130.07 87.85 10-541-502010 Social Security 60,933.42 56,895.74 0.00 4,037.68 6.63 10-541-502020 Group Health Insurance 145,725.27 120,724.42 0.00 25,000.85 17.16 10-541-502030 Retirement 99,564.41 95,600.22 0.00 3,964.19 3.98 10-541-502040 Workers Compensation 5,314.04 5,314.04 0.00 0.00 0.00 10-541-502050 Life Insurance 1,245.05 982.80 0.00 262.25 21.06 10-541-502060 Long Term Disability 2,646.78 2,343.47 0.00 303.31 11.46 10-541-502070 Employee Assistance Prgm 326.88 306.92 0.00 19.96 6.11 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,112,271.13 1,074,179.13 0.00 38,092.00 3.42 10-541-511010 Advertisine 1.000.00 406.00 0.00 594.00 59.40 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 30 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-511020 Postage 400.00 383.99 0.00 16.01 4.00 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 0.39 0.00 74.61 99.48 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 3,967.68 2,943.47 0.00 1,024.21 25.81 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 53.67 0.00 96.33 64.22 10-541-515040 First Aid Supplies 59.21 59.21 0.00 0.00 0.00 10-541-515070 Const & Inspect Supplies 2,000.00 995.88 0.00 1,004.12 50.21 10-541-515080 Surveying Supplies 2,000.00 1,736.25 0.00 263.75 13.19 10-541-517010 Operational Supplies 3,073.11 3,903.32 0.00 -830.21 -27.02 E10 Materials & Supplies 13,025.00 10,482.18 0.00 2,542.82 19.52 10-541-520030 Dues And Publications 4,000.00 3,008.85 0.00 991.15 24.78 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,000.00 2,581.55 0.00 418.45 13.95 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 1,000.00 259.00 0.00 741.00 74.10 10-541-522055 Stormwater Compliance 1,500.00 0.00 0.00 1,500.00 100.00 E15 Contractual Services 9,500.00 5,849.40 0.00 3,650.60 38.43 10-541-534010 Telephone 500.00 493.85 0.00 6.15 1.23 E20 Utilities 500.00 493.85 0.00 6.15 1.23 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,750.00 1,680.19 0.00 69.81 3.99 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 12,400.00 8,222.01 0.00 4,177.99 33.69 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 16,150.00 11,477.20 0.00 4,672.80 28.93 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 SidewatkGreenway-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,151,446.13 1,102,481.76 0.00 48,964.37 4.25 542 Public Works -Street 10-542-501020 Salaries 1,224,247.92 1,219,134.33 0.00 5,113.59 0.42 10-542-501060 Seasonal Salaries 20,000.00 31,468.51 0.00 -11,468.51 -57.34 10-542-501070 Stand-by Plan 5,000.00 4,324.00 0.00 676.00 13.52 10-542-501090 Overtime 35,000.00 42,979.15 0.00 -7,979.15 -22.80 10-542-501095 Overtime Straieht Pav 500.00 1.752.90 0.00 -1.252.90 -250.58 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502010 Dues And Publications 1,205.00 Social Security 98,283.22 95,549.32 0.00 2,733.90 2.78 10-542-502020 0.00 0.00 Group Health Insurance 242,417.69 239,559.34 0.00 2,858.35 1.18 10-542-502030 -1,360.73 -14.74 Retirement 158,093.49 150,089.21 0.00 8,004.28 5.06 10-542-502040 10-542-522020 Professional Services Workers Compensation 38,193.00 38,193.00 0.00 0.00 0.00 10-542-502050 586.25 586.25 Life Insurance 1,833.55 1,485.89 0.00 347.66 18.96 10-542-502060 0.00 0.00 Long Term Disability 4,008.48 3,550.94 0.00 457.54 11.41 10-542-502070 24.94 E15 Employee Assistance Prgm 776.34 728.92 0.00 47.42 6.11 10-542-503010 Electricity 24,817.01 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 599,262.89 0.00 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 -542.48 Personnel Services 1,828,553.69 1,828,815.51 0.00 -261.82 -0.01 10-542-511010 50.04 10-542-535010 Advertising 1,000.00 353.20 0.00 646.80 64.68 10-542-511020 Utilities 699,823.78 Postage 150.00 9.91 0.00 140.09 93.39 10-542-512010 14,664.35 0.00 Printing 90.00 40.00 0.00 50.00 55.56 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 1,688.96 6.61 Office Supplies 1,600.00 1,678.45 0.00 -78.45 -4.90 10-542-514020 10-542-546010 Clothing Expense Chemicals 369,700.62 354,332.33 0.00 15,368.29 4.16 10-542-514030 Small Tools 34,751.27 35,556.36 0.00 -805.09 -2.32 10-542-514040 Food 2,250.15 2,281.72 0.00 -31.57 -1.40 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 384,134.28 295,124.97 0.00 89,009.31 23.17 10-542-515040 First Aid Supplies 752.74 752.74 0.00 0.00 0.00 10-542-515060 Weed Control 2,821.53 310.00 0.00 2,511.53 89.01 10-542-515070 Const & Inspect Supplies 200.00 12.74 0.00 187.26 93.63 10-542-517010 Operational Supplies 4,921.73 5,399.33 0.00 -477.60 -9.70 E10 Materials & Supplies 802,382.32 695,851.75 0.00 106,530.57 13.28 10-542-520030 Dues And Publications 1,205.00 1,205.00 0.00 0.00 0.00 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 9,230.39 10,591.12 0.00 -1,360.73 -14.74 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,179.83 14,878.03 0.00 301.80 1.99 10-542-523010 Equipment Rentlease 586.25 586.25 0.00 0.00 0.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 1,000.00 750.59 0.00 249.41 24.94 E15 Contractual Services 27,201.47 28,010.99 0.00 -809.52 -2.98 10-542-531010 Electricity 24,817.01 23,640.72 0.00 1,176.29 4.74 10-542-531020 Street Lights 650,000.00 599,262.89 0.00 50,737.11 7.81 10-542-533010 Natural Gas 11,523.24 12,065.72 0.00 -542.48 -4.71 10-542-534010 Telephone 395.33 197.52 0.00 197.81 50.04 10-542-535010 Water 13,088.20 10,579.31 0.00 2,508.89 19.17 E20 Utilities 699,823.78 645,746.16 0.00 54,077.62 7.73 10-542-540010 Building & Grounds Maint. 13,801.55 14,664.35 0.00 -862.80 -6.25 10-542-541030 Vehicle Wash 7,000.00 6,710.96 0.00 289.04 4.13 10-542-542010 Repairs - StopStreet Lights 25,541.68 23,852.72 0.00 1,688.96 6.61 10-542-542030 Signs & Marking Paint 42,635.53 45,366.39 0.00 -2,730.86 -6.41 10-542-546010 Clothing Expense 12,655.89 12,815.89 0.00 -160.00 -1.26 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-547010 Equipment Maintenance 3,200.00 1,854.50 0.00 1,345.50 42.05 10-542-547020 Maintenance Agreements 401.90 401.90 0.00 0.00 0.00 10-542-547030 Radio Maintenance 969.60 371.78 0.00 597.82 61.66 E25 Repairs & Maintenance 106,206.15 106,038.49 0.00 167.66 0.16 10-542-572010 Purchase Of Vehicles 85,120.28 29.00 0.00 85,091.28 99.97 10-542-572020 Purchase Of Equipment 65,314.08 65,314.08 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 150,434.36 65,343.08 0.00 85,091.28 56.56 542 Public Works -Street 3,614,601.77 3,369,805.98 0.00 244,795.79 6.77 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 10,756.18 0.00 4,243.82 28.29 10-700-590065 Trans to Self -Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 241,769.63 241,769.63 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,111,635.79 1,111,635.79 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,368,405.42 1,364,161.60 0.00 4,243.82 0.31 700 Transfers & Subsidies 1,368,405.42 1,364,161.60 0.00 4,243.82 0.31 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 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 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 1,116,086.98 764,409.91 0.00 351,677.07 31.51 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 43.000.00 8.827.50 0.00 34.172.50 79.47 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-576007 Stormwater Improvements 296,000.00 296,000.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 110,000.00 0.00 0.00 110,000.00 100.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 1,300.00 500.00 0.00 800.00 61.54 10-990-577060 Ongoing InfrastFacility Needs 354,182.55 74,682.08 0.00 279,500.47 78.91 10-990-577063 Clark Avenue 12,743.35 1,816.24 0.00 10,927.11 85.75 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 278,564.00 237,168.18 0.00 41,395.82 14.86 E75 Capital Projects 2,211,876.88 1,383,403.91 0.00 828,472.97 37.46 990 Capital Projects 2,211,876.88 1,383,403.91 0.00 828,472.97 37.46 Expense Expense 36,890,431.76 34,935,125.77 0.00 1,955,305.99 5.30 GL - Trial Balance by Acct Type and Full Acct Number (12/11/2019 - 4:16 PM) Page 34