Loading...
HomeMy Public PortalAbout2018-11 NO Meeting - Expense ReportGeneral Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 11/07/18 11:07:10 Period 01 - 13 Fiscal Year 2018 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 65,025.00 0.00 900.00 1.37 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,126.93 0.00 593.83 7.69 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 37.47 37.47 0.00 0.00 0.00 E05 Personnel Services 108,683.15 107,189.32 0.00 1,493.83 1.37 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 2.99 0.00 97.01 97.01 10-110-512010 Printing 240.00 190.50 0.00 49.50 20.63 10-110-512020 Copies 200.00 28.08 0.00 171.92 85.96 10-110-513010 Office Supplies 2,360.00 609.50 0.00 1,750.50 74.17 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,900.00 831.07 0.00 2,068.93 71.34 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,482.00 966.37 -532.86 1,048.49 70.75 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 1,400.00 195.00 0.00 1,205.00 86.07 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,982.00 5,869.27 -532.86 2,645.59 33.14 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 95.00 65.27 5.85 23.88 25.14 E25 Repairs & Maintenance 95.00 65.27 5.85 23.88 25.14 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 (11/07/2018 - 11:07 AM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-501020 Salaries 85,785.97 70,404.72 0.00 15,381.25 17.93 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 119,660.15 113,954.93 -527.01 6,232.23 5.21 120 City Clerk 10-120-501020 Salaries 85,785.97 70,404.72 0.00 15,381.25 17.93 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 6,562.62 5,061.85 0.00 1,500.77 22.87 10-120-502020 Group Health Insurance 905.82 11,388.13 0.00 -10,482.31 -1,157.22 10-120-502030 Retirement 9,355.63 4,058.55 0.00 5,297.08 56.62 10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00 10-120-502050 Life Insurance 104.65 81.16 0.00 23.49 22.45 10-120-502060 Long Term Disability 189.72 190.87 0.00 -1.15 -0.61 10-120-502070 Employee Assistance Prgm 26.40 24.84 0.00 1.56 5.91 E05 Personnel Services 102,964.38 91,243.69 0.00 11,720.69 11.38 10-120-511020 Postage 200.00 186.48 0.00 13.52 6.76 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 404.83 0.00 -104.83 -34.94 10-120-513010 Office Supplies 1,034.17 776.36 0.00 257.81 24.93 E10 Materials & Supplies 1,534.17 1,367.67 0.00 166.50 10.85 10-120-520030 Dues And Publications 275.00 65.00 0.00 210.00 76.36 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 420.83 309.01 0.00 111.82 26.57 10-120-522020 Professional Services 400.00 400.09 0.00 -0.09 -0.02 10-120-529030 Election Expense 30,000.00 31,956.01 0.00 -1,956.01 -6.52 E15 Contractual Services 31,095.83 32,730.11 0.00 -1,634.28 -5.26 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 375.00 365.26 5.85 3.89 1.04 E25 Repairs & Maintenance 375.00 365.26 5.85 3.89 1.04 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 135,969.38 125,706.73 5.85 10,256.80 7.54 140 City Administrator 10-140-501020 Salaries 214,085.70 205,603.39 0.00 8,482.31 3.96 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 (11/07/2018 - 11:07 AM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-502010 Social Security 16,377.56 12,824.09 0.00 3,553.47 21.70 10-140-502020 Group Health Insurance 24,967.95 20,137.86 0.00 4,830.09 19.35 10-140-502030 Retirement 28,259.31 25,707.10 0.00 2,552.21 9.03 10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00 10-140-502050 Life Insurance 147.49 131.81 0.00 15.68 10.63 10-140-502060 Long Term Disability 292.54 286.02 0.00 6.52 2.23 10-140-502070 Employee Assistance Prgm 52.80 49.64 0.00 3.16 5.98 E05 Personnel Services 284,268.67 264,825.23 0.00 19,443.44 6.84 10-140-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-140-511020 Postage 250.00 114.88 0.00 135.12 54.05 10-140-512010 Printing 75.00 0.00 0.00 75.00 100.00 10-140-512020 Copies 250.00 84.94 0.00 165.06 66.02 10-140-513010 Office Supplies 875.00 845.12 0.00 29.88 3.41 10-140-517010 Operational Supplies 1,000.00 712.47 0.00 287.53 28.75 E10 Materials & Supplies 2,950.00 1,757.41 0.00 1,192.59 40.43 10-140-520030 Dues And Publications 1,800.00 448.69 0.00 1,351.31 75.07 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 3,204.00 0.00 -1,204.00 -60.20 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 182.60 0.00 317.40 63.48 E15 Contractual Services 4,300.00 3,835.29 0.00 464.71 10.81 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 260.00 222.23 5.85 31.92 12.28 E25 Repairs & Maintenance 260.00 222.23 5.85 31.92 12.28 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 291,778.67 270,640.16 5.85 21,132.66 7.24 149 Entitlement Grant 10-149-501020 Salaries 37,100.32 29,354.02 0.00 7,746.30 20.88 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 2,838.17 2,206.99 0.00 631.18 22.24 10-149-502020 Group Health Insurance 10,432.17 4,978.17 0.00 5,454.00 52.28 10-149-502030 Retirement 4,897.24 742.04 0.00 4,155.20 84.85 10-149-502040 Workers Compensation 30.00 30.00 0.00 0.00 0.00 10-149-502050 Life Insurance 69.77 46.20 0.00 23.57 33.78 10-149-502060 Long Term Disability 119.83 97.92 0.00 21.91 18.28 10-149-502070 EmDlovee Assistance Proeram 26.40 24.84 0.00 1.56 5.91 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 55,513.90 37,480.18 0.00 18,033.72 32.49 10-149-511010 Advertising 1,500.00 1,400.08 0.00 99.92 6.66 10-149-511020 Postage 500.00 139.77 0.00 360.23 72.05 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 900.00 182.35 0.00 717.65 79.74 10-149-517010 Operational Supplies 525.00 28.58 0.00 496.42 94.56 E10 Materials & Supplies 3,425.00 1,750.78 0.00 1,674.22 48.88 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,682.16 0.00 317.84 15.89 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 21,810.00 11,211.00 0.00 10,599.00 48.60 10-149-528012 Housing Rehab -Energy Efficient 37,168.77 22,925.06 0.00 14,243.71 38.32 10-149-528020 Housing Assistance 56,175.00 56,076.00 0.00 99.00 0.18 10-149-528030 Public Improvement 237,430.41 0.00 0.00 237,430.41 100.00 10-149-528040 Neighborhood Redevelopmnt 106,053.56 35,883.50 0.00 70,170.06 66.16 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 8,190.00 8,190.00 0.00 0.00 0.00 10-149-528080 Homeless Objectives 4,831.23 4,831.23 0.00 0.00 0.00 E15 Contractual Services 473,658.97 140,798.95 0.00 332,860.02 70.27 10-149-547020 Maintenance Agreements 320.00 272.33 0.00 47.67 14.90 E25 Repairs & Maintenance 320.00 272.33 0.00 47.67 14.90 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 12,101.00 5,064.30 0.00 7,036.70 58.15 E75 Capital Projects 12,101.00 5,064.30 0.00 7,036.70 58.15 149 Entitlement Grant 545,018.87 185,366.54 0.00 359,652.33 65.99 150 City Counselor 10-150-501020 Salaries 205,682.78 199,197.26 0.00 6,485.52 3.15 10-150-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 15,734.73 14,531.43 0.00 1,203.30 7.65 10-150-502020 Group Health Insurance 35,835.24 32,631.44 0.00 3,203.80 8.94 10-150-502030 Retirement 27,150.13 26,293.98 0.00 856.15 3.15 10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00 10-150-502050 Life Insurance 378.22 308.96 0.00 69.26 18.31 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502060 Long Term Disability 613.71 595.68 0.00 18.03 2.94 10-150-502070 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 285,634.77 273,793.99 0.00 11,840.78 4.15 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 596.91 0.00 3.09 0.52 10-150-512010 Printing 150.00 45.50 0.00 104.50 69.67 10-150-512020 Copies 300.00 2.20 0.00 297.80 99.27 10-150-513010 Office Supplies 1,675.00 1,669.12 0.00 5.88 0.35 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,725.00 2,313.73 0.00 411.27 15.09 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 10,000.00 8,369.49 475.86 1,154.65 11.55 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,200.00 4,953.69 0.00 246.31 4.74 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 1,000.00 0.00 0.00 1,000.00 100.00 10-150-522020 Professional Services 25,055.15 24,735.92 0.00 319.23 1.27 10-150-525030 Litigation Expenses 575.00 166.68 0.00 408.32 71.01 E15 Contractual Services 41,830.15 38,225.78 475.86 3,128.51 7.48 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 700.00 665.26 5.85 28.89 4.13 E25 Repairs & Maintenance 700.00 665.26 5.85 28.89 4.13 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 330,889.92 314,998.76 481.71 15,409.45 4.66 160 Municipal Court 10-160-501010 Salary -elected Officals 35,000.04 35,000.04 0.00 0.00 0.00 10-160-501020 Salaries 115,515.83 112,059.01 0.00 3,456.82 2.99 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 6,693.50 0.00 15,251.85 69.50 10-160-501090 Overtime 3,000.00 314.28 0.00 2,685.72 89.52 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,422.78 11,379.20 0.00 2,043.58 15.22 10-160-502020 Group Health Insurance 27,753.13 26,703.15 0.00 1,049.98 3.78 10-160-502030 Retirement 15,644.08 14,833.15 0.00 810.93 5.18 10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00 10-160-502050 Life Insurance 214.81 176.49 0.00 38.32 17.84 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502060 Long Term Disability 362.30 379.53 0.00 -17.23 -4.76 10-160-502070 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 E05 Personnel Services 233,043.94 207,719.25 0.00 25,324.69 10.87 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,290.71 3,312.08 0.00 -21.37 -0.65 10-160-512010 Printing 450.00 446.00 0.00 4.00 0.89 10-160-512020 Copies 500.00 217.88 0.00 282.12 56.42 10-160-513010 Office Supplies 12,190.37 8,190.54 0.00 3,999.83 32.81 E10 Materials & Supplies 16,431.08 12,166.50 0.00 4,264.58 25.95 10-160-520025 Security 10,000.00 12,060.89 -4,868.29 2,807.40 28.07 10-160-520030 Dues And Publications 350.00 60.00 0.00 290.00 82.86 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 351.45 351.45 0.00 0.00 0.00 10-160-522020 Professional Services 5,857.47 5,756.98 0.00 100.49 1.72 10-160-525005 Appointed Counsel 4,300.00 3,667.50 0.00 632.50 14.71 10-160-525010 Care Of Prisoners 0.00 0.00 0.00 0.00 0.00 10-160-525030 Litigation Expenses 40.00 33.21 0.00 6.79 16.98 E15 Contractual Services 20,898.92 21,930.03 -4,868.29 3,837.18 18.36 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 965.26 5.85 128.89 11.72 E25 Repairs & Maintenance 1,100.00 965.26 5.85 128.89 11.72 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 160 Municipal Court 271,473.94 242,781.04 -4,862.44 33,555.34 12.36 170 Human Resources 10-170-501020 Salaries 204,258.76 198,783.98 0.00 5,474.78 2.68 10-170-501050 Parttime(wo Benefits) 12,729.60 10,905.65 0.00 1,823.95 14.33 10-170-501090 Overtime 300.00 32.24 0.00 267.76 89.25 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 16,622.56 15,982.34 0.00 640.22 3.85 10-170-502020 Group Health Insurance 20,096.33 19,783.44 0.00 312.89 1.56 10-170-502030 Retirement 27,001.76 26,243.60 0.00 758.16 2.81 10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00 10-170-502050 Life Insurance 376.38 307.52 0.00 68.86 18.30 10-170-502060 Long Term Disability 578.22 585.79 0.00 -7.57 -1.31 10-170-502070 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,137.34 272,793.57 0.00 9,343.77 3.31 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-511010 Advertising 0.00 350.80 0.00 -350.80 0.00 10-170-511020 Postage 300.00 185.59 0.00 114.41 38.14 10-170-512010 Printing 800.00 859.11 0.00 -59.11 -7.39 10-170-512020 Copies 500.00 640.93 0.00 -140.93 -28.19 10-170-513010 Office Supplies 1,000.00 803.91 0.00 196.09 19.61 10-170-517010 Operational Supplies 1,200.00 112.26 0.00 1,087.74 90.65 E10 Materials & Supplies 3,800.00 2,952.60 0.00 847.40 22.30 10-170-520030 Dues And Publications 1,468.00 846.00 0.00 622.00 42.37 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 2,315.48 0.00 1,184.52 33.84 10-170-520070 Training And Education 5,220.00 4,170.35 0.00 1,049.65 20.11 10-170-520080 Tuition Reimbursement 3,690.00 0.00 0.00 3,690.00 100.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 1,400.00 320.00 0.00 1,080.00 77.14 10-170-522020 Professional Services 6,000.00 150.07 0.00 5,849.93 97.50 10-170-529010 Special Events 1,000.00 159.09 0.00 840.91 84.09 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,278.00 7,960.99 0.00 14,317.01 64.27 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 260.00 220.61 5.85 33.54 12.90 E25 Repairs & Maintenance 260.00 220.61 5.85 33.54 12.90 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 308,475.34 283,927.77 5.85 24,541.72 7.96 180 Finance Department 10-180-501020 Salaries 636,539.27 573,129.88 0.00 63,409.39 9.96 10-180-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 48,695.25 42,731.47 0.00 5,963.78 12.25 10-180-502020 Group Health Insurance 80,918.36 69,167.70 0.00 11,750.66 14.52 10-180-502030 Retirement 84,023.18 75,653.66 0.00 8,369.52 9.96 10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00 10-180-502050 Life Insurance 1,178.71 893.68 0.00 285.03 24.18 10-180-502060 Long Term Disability 2,048.67 1,854.54 0.00 194.13 9.48 10-180-502070 Employee Assistance Prgm 310.20 291.72 0.00 18.48 5.96 10-180-503020 Unemployment Compensation 0.00 1,682.64 0.00 -1,682.64 0.00 E05 Personnel Services 854,244.74 765,936.39 0.00 88,308.35 10.34 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511010 Advertising 1,000.00 533.25 0.00 466.75 46.68 10-180-511020 Postage 9,500.00 9,489.67 0.00 10.33 0.11 10-180-511021 Mail Machine Cost 11,200.00 9,816.63 0.00 1,383.37 12.35 10-180-512010 Printing 4,000.00 3,098.35 0.00 901.65 22.54 10-180-512020 Copies 2,500.00 917.06 0.00 1,582.94 63.32 10-180-512021 Copy Machine Cost 1,000.00 -693.50 35.10 1,658.40 165.84 10-180-513010 Office Supplies 4,000.00 3,078.88 0.00 921.12 23.03 10-180-517010 Operational Supplies 5,100.00 8,641.87 0.00 -3,541.87 -69.45 E10 Materials & Supplies 38,300.00 34,882.21 35.10 3,382.69 8.83 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,294.10 0.00 5.90 0.26 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 5,093.60 0.00 5,906.40 53.69 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 38,650.00 36,071.00 0.00 2,579.00 6.67 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 42.36 0.00 457.64 91.53 E15 Contractual Services 52,450.00 43,501.06 0.00 8,948.94 17.06 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 1,200.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,200.00 1,200.00 0.00 0.00 0.00 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 946,194.74 845,519.66 35.10 100,639.98 10.64 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 41,214.80 0.00 0.00 0.00 10-185-502023 Self Insurance -Retirees 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 41,214.80 0.00 0.00 0.00 10-185-514010 Gas 14,000.00 10,081.42 0.00 3,918.58 27.99 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & SUDOlies 14.000.00 10.081.42 0.00 3.918.58 27.99 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 291,653.01 314,888.34 0.00 -23,235.33 -7.97 10-185-521020 Insurance Deductible 16,200.00 34,019.82 0.00 -17,819.82 -110.00 10-185-521030 Self Ins Prop & Casualty 81,000.00 30,687.36 0.00 50,312.64 62.11 10-185-521060 Drugalcohol screening 5,364.00 2,083.50 0.00 3,280.50 61.16 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 3,712.50 0.00 -3,712.50 0.00 10-185-522020 Professional Services 72,600.00 68,400.46 0.00 4,199.54 5.78 10-185-522023 LCRA Reimbursement 259,000.00 0.00 0.00 259,000.00 100.00 10-185-522025 JCTV 55,000.00 55,000.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 45,750.00 46,061.12 0.00 -311.12 -0.68 10-185-527020 Economic Development 185,000.00 231,250.00 0.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 9,164.63 0.00 -2,164.63 -30.92 E15 Contractual Services 1,018,567.01 795,267.73 0.00 223,299.28 21.92 10-185-531010 Electricity 41,000.00 32,951.33 0.00 8,048.67 19.63 10-185-533010 Natural Gas 6,400.00 5,825.81 0.00 574.19 8.97 10-185-535010 Water 8,250.00 8,035.80 0.00 214.20 2.60 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 46,812.94 0.00 8,837.06 15.88 10-185-540010 Building & Grounds Maint. 61,508.00 27,049.25 80.00 34,378.75 55.89 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,716.00 0.00 384.00 18.29 E25 Repairs & Maintenance 88,608.00 53,765.25 80.00 34,762.75 39.23 10-185-550010 Miscellaneous 11,000.00 5,658.47 0.00 5,341.53 48.56 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 12,740.00 12,028.16 0.00 711.84 5.59 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 1,000.00 1,000.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 5,404.05 0.00 -5,404.05 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 20,000.00 15,107.00 0.00 4,893.00 24.47 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E30 Other Operating Expenses 54,740.00 49,197.68 0.00 5,542.32 10.12 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,272,779.81 996,339.82 80.00 276,359.99 21.71 190 Information Technology Svcs 10-190-501020 Salaries 549,003.30 515,867.96 0.00 33,135.34 6.04 10-190-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits) 0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 275.09 0.00 -275.09 0.00 10-190-502010 Social Security 42,090.55 37,889.74 0.00 4,200.81 9.98 10-190-502020 Group Health Insurance 84,702.71 74,136.53 0.00 10,566.18 12.47 10-190-502030 Retirement 72,626.84 65,453.92 0.00 7,172.92 9.88 10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00 10-190-502050 Life Insurance 1,006.13 797.50 0.00 208.63 20.74 10-190-502060 Long Term Disability 1,759.62 1,696.49 0.00 63.13 3.59 10-190-502070 Employee Assistance Prgm 250.80 235.84 0.00 14.96 5.96 E05 Personnel Services 752,997.06 696,710.18 0.00 56,286.88 7.48 10-190-511010 Advertising 500.00 264.80 0.00 235.20 47.04 10-190-511020 Postage 100.00 52.62 0.00 47.38 47.38 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 13.54 0.00 86.46 86.46 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 833.90 0.00 166.10 16.61 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 38.10 0.00 11.90 23.80 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,750.00 1,746.63 0.00 3.37 0.19 E10 Materials & Supplies 3,500.00 2,949.59 0.00 550.41 15.73 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 299.00 0.00 201.00 40.20 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 9,000.00 8,576.62 0.00 423.38 4.70 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 14.000.00 12.707.66 0.00 1.292.34 9.23 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Postage Service-internet Tl Web 12,000.00 9,021.44 0.00 2,978.56 24.82 10-190-522050 5,000.00 Service -remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,049.98 4,049.98 0.00 0.00 0.00 E15 47.59 Contractual Services 39,549.98 34,654.70 0.00 4,895.28 12.38 10-190-534010 0.00 Telephone 52,000.00 51,093.96 0.00 906.04 1.74 E20 12,316.90 Utilities 52,000.00 51,093.96 0.00 906.04 1.74 10-190-545010 -35.32 Software Licensemaint 129,500.00 129,484.67 0.00 15.33 0.01 10-190-545020 Citywide Wiringnetwork 3,000.00 0.00 0.00 3,000.00 100.00 10-190-547010 Equipment Maintenance 3,000.00 814.00 0.00 2,186.00 72.87 10-190-547020 Maintenance Agreements 15,796.58 15,796.58 0.00 0.00 0.00 E25 Repairs & Maintenance 151,296.58 146,095.25 0.00 5,201.33 3.44 10-190-572020 Purchase Of Equipment 34,653.44 24,278.19 8,924.88 1,450.37 4.19 E70 Capital Purchases 34,653.44 24,278.19 8,924.88 1,450.37 4.19 190 Information Technology Svcs 1,033,997.06 955,781.87 8,924.88 69,290.31 6.70 300 Police Department 10-300-501020 Salaries 4,384,816.97 4,168,929.44 0.00 215,887.53 4.92 10-300-501030 Holiday Pay 137,805.60 115,963.46 0.00 21,842.14 15.85 10-300-501040 Part-time (wbenefits) 3,313.54 0.00 0.00 3,313.54 100.00 10-300-501050 Parttime(wo Benefits) 66,208.36 59,742.13 0.00 6,466.23 9.77 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,164.00 0.00 836.00 16.72 10-300-501090 Overtime 357,754.33 310,422.57 0.00 47,331.76 13.23 10-300-501095 Overtime Straight Pay 8,665.74 15,349.14 0.00 -6,683.40 -77.12 10-300-502010 Social Security 372,300.65 339,777.75 0.00 32,522.90 8.74 10-300-502020 Group Health Insurance 821,481.58 732,507.04 0.00 88,974.54 10.83 10-300-502030 Retirement 864,947.00 805,896.06 0.00 59,050.94 6.83 10-300-502040 Workers Compensation 39,409.96 39,409.96 0.00 0.00 0.00 10-300-502050 Life Insurance 8,421.14 6,350.53 0.00 2,070.61 24.59 10-300-502060 Long Term Disability 14,302.32 13,688.35 0.00 613.97 4.29 10-300-502070 Employee Assistance Prgm 2,415.60 2,271.56 0.00 144.04 5.96 10-300-503010 Awards Program 1,600.00 210.50 0.00 1,389.50 86.84 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 7,089,442.79 6,614,682.49 0.00 474,760.30 6.70 10-300-511010 Advertising 3,000.00 2,946.49 0.00 53.51 1.78 10-300-511020 Postage 1,500.00 1,598.18 0.00 -98.18 -6.55 10-300-512010 Printing 5,000.00 5,592.76 0.00 -592.76 -11.86 10-300-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-300-512030 Photographic Supplies 2,000.00 47.59 0.00 1,952.41 97.62 10-300-513010 Office Supplies 13,000.00 18,241.87 0.00 -5,241.87 -40.32 10-300-514010 Gas 153,551.67 141,234.77 0.00 12,316.90 8.02 10-300-514040 Food 700.00 947.25 0.00 -247.25 -35.32 10-300-515040 First Aid Supplies 1,000.00 1,279.39 0.00 -279.39 -27.94 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-516010 Ammunition & Firearms Supplies 43,995.00 40,096.46 0.00 3,898.54 8.86 10-300-516020 Dare Program 16,500.00 14,815.42 0.00 1,684.58 10.21 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 2,825.00 1,596.45 0.00 1,228.55 43.49 10-300-517010 Operational Supplies 53,615.21 42,839.79 2,095.00 8,680.42 16.19 E10 Materials & Supplies 299,286.88 273,736.42 2,095.00 23,455.46 7.84 10-300-520030 Dues And Publications 4,600.00 5,401.13 0.00 -801.13 -17.42 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 75,600.00 75,353.29 0.00 246.71 0.33 10-300-520080 Tuition Reimbursement 9,000.00 9,792.00 0.00 -792.00 -8.80 10-300-520090 Recruitment 2,500.00 1,425.17 0.00 1,074.83 42.99 10-300-521040 Medical Claimsservices 7,000.00 6,309.44 0.00 690.56 9.87 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 28,500.00 29,394.25 0.00 -894.25 -3.14 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 28,201.75 0.00 -28,201.75 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 529.16 0.00 1,670.84 75.95 E15 Contractual Services 129,400.00 156,406.19 0.00 -27,006.19 -20.87 10-300-531010 Electricity 68,250.00 55,999.02 0.00 12,250.98 17.95 10-300-533010 Natural Gas 1,500.00 1,042.71 0.00 457.29 30.49 10-300-534010 Telephone 19,700.00 22,924.49 0.00 -3,224.49 -16.37 10-300-535010 Water 4,500.00 4,188.92 0.00 311.08 6.91 E20 Utilities 93,950.00 84,155.14 0.00 9,794.86 10.43 10-300-540010 Building & Grounds Maint. 40,000.00 34,235.11 600.00 5,164.89 12.91 10-300-541030 Vehicle Wash 12,000.00 9,365.79 0.00 2,634.21 21.95 10-300-544010 K-9 Operations 18,500.00 15,447.19 0.00 3,052.81 16.50 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 16,956.72 0.00 7,343.28 30.22 10-300-545010 Software Licensemaint 62,000.00 53,968.25 0.00 8,031.75 12.95 10-300-546010 Clothing Expense 43,000.00 38,098.33 0.00 4,901.67 11.40 10-300-546020 Uniform Cleaning 25,000.00 23,175.32 0.00 1,824.68 7.30 10-300-547010 Equipment Maintenance 9,350.00 9,248.33 0.00 101.67 1.09 10-300-547020 Maintenance Agreements 47,300.00 35,355.87 0.00 11,944.13 25.25 10-300-547030 Radio Maintenance 10,000.00 7,310.02 0.00 2,689.98 26.90 E25 Repairs & Maintenance 291,450.00 243,160.93 600.00 47,689.07 16.36 10-300-572010 Purchase Of Vehicles 266,913.56 146,191.00 0.00 120,722.56 45.23 10-300-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.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,802.40 0.00 0.00 7,802.40 100.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-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 5,201.60 0.00 0.00 5,201.60 100.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software -morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software -prof Sery 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 279,917.56 146,191.00 0.00 133,726.56 47.77 300 Police Department 8,183,447.23 7,518,332.17 2,695.00 662,420.06 8.09 310 School Resource Officer 10-310-501020 Salaries 289,000.46 278,892.29 0.00 10,108.17 3.50 10-310-501030 Holiday Pay 11,109.86 2,439.49 0.00 8,670.37 78.04 10-310-501090 Overtime 17,126.00 32,848.73 0.00 -15,722.73 -91.81 10-310-501095 Overtime Straight Pay 410.00 1,004.83 0.00 -594.83 -145.08 10-310-502010 Social Security 24,299.94 22,292.26 0.00 2,007.68 8.26 10-310-502020 Group Health Insurance 58,124.94 57,883.89 0.00 241.05 0.41 10-310-502030 Retirement 58,764.57 58,214.68 0.00 549.89 0.94 10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00 10-310-502050 Life Insurance 556.31 436.35 0.00 119.96 21.56 10-310-502060 Long Term Disability 962.80 942.85 0.00 19.95 2.07 10-310-502070 Employee Assistance Prgm 158.40 148.96 0.00 9.44 5.96 E05 Personnel Services 463,052.10 457,643.15 0.00 5,408.95 1.17 10-310-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-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment 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-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 463,052.10 457,643.15 0.00 5,408.95 1.17 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 92,800.31 91,611.63 0.00 1,188.68 1.28 10-320-501030 Holiday Pay 3,500.01 0.00 0.00 3,500.01 100.00 10-320-501090 Overtime 23,371.52 29,634.25 0.00 -6,262.73 -26.80 10-320-501095 Overtime Straight Pay 0.00 174.02 0.00 -174.02 0.00 10-320-502010 Social Security 7,894.60 8,827.49 0.00 -932.89 -11.82 10-320-502020 Group Health Insurance 20,505.62 19,426.78 0.00 1,078.84 5.26 10-320-502030 Retirement 19,091.50 22,245.35 0.00 -3,153.85 -16.52 10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00 10-320-502050 Life Insurance 174.42 138.68 0.00 35.74 20.49 10-320-502060 Long Term Disability 303.31 299.13 0.00 4.18 1.38 10-320-502070 Employee Assistance Prgm 52.80 49.64 0.00 3.16 5.98 E05 Personnel Services 168,712.55 173,425.43 0.00 -4,712.88 -2.79 10-320-514010 Gas 6,000.00 5,624.00 0.00 376.00 6.27 10-320-516040 Investigations 14,350.00 10,485.99 0.00 3,864.01 26.93 10-320-517010 Operational Supplies 7,494.70 1,585.16 0.00 5,909.54 78.85 E10 Materials & Supplies 27,844.70 17,695.15 0.00 10,149.55 36.45 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 19,200.00 12,000.00 -6,000.00 13,200.00 68.75 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 19,200.00 12,000.00 -6,000.00 13,200.00 68.75 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 320 Dues And Publications M.U.S.T.A.N.G. 215,757.25 203,120.58 -6,000.00 18,636.67 8.64 330 0.00 Animal Control 0.00 0.00 0.00 10-330-520070 Training And Education 10-330-501020 962.08 Salaries 340,042.00 334,616.87 0.00 5,425.13 1.60 10-330-501040 0.00 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 -1,814.93 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 13.06 Stand-by Plan 4,308.00 4,164.00 0.00 144.00 3.34 10-330-501090 10-330-529060 Overtime 1,709.00 1,683.14 0.00 25.86 1.51 10-330-501095 Adoption Voucher Program Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 0.00 Social Security 26,511.76 24,741.30 0.00 1,770.46 6.68 10-330-502020 0.00 Group Health Insurance 69,121.87 65,417.30 0.00 3,704.57 5.36 10-330-502030 0.00 Retirement 45,745.79 44,534.85 0.00 1,210.94 2.65 10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00 10-330-502050 -5,015.71 Life Insurance 633.42 520.24 0.00 113.18 17.87 10-330-502060 65.03 Long Term Disability 1,125.84 1,115.72 0.00 10.12 0.90 10-330-502070 Employee Assistance Prgm 211.20 198.60 0.00 12.60 5.97 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 492,403.65 479,486.79 0.00 12,916.86 2.62 10-330-511010 Advertising 120.00 0.00 0.00 120.00 100.00 10-330-511020 Postage 100.00 79.65 0.00 20.35 20.35 10-330-512010 Printing 1,234.30 1,594.37 0.00 -360.07 -29.17 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,700.00 1,156.57 0.00 543.43 31.97 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 162.72 0.00 77.28 32.20 10-330-515040 First Aid Supplies 700.00 382.27 0.00 317.73 45.39 10-330-517010 Operational Supplies 11,900.00 11,480.49 0.00 419.51 3.53 E10 Materials & Supplies 15,994.30 14,856.07 0.00 1,138.23 7.12 10-330-520030 Dues And Publications 1,150.00 1,152.25 0.00 -2.25 -0.20 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,950.00 962.08 0.00 987.92 50.66 10-330-521040 Medical Claimsservices 464.00 0.00 0.00 464.00 100.00 10-330-522020 Professional Services 5,200.00 7,014.93 0.00 -1,814.93 -34.90 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,600.00 4,868.37 0.00 731.63 13.06 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,364.00 13,997.63 0.00 366.37 2.55 10-330-531010 Electricity 21,700.00 24,534.32 0.00 -2,834.32 -13.06 10-330-533010 Natural Gas 15,800.00 20,815.71 0.00 -5,015.71 -31.75 10-330-534010 Telephone 300.00 104.90 0.00 195.10 65.03 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-535010 Water 4,300.00 3,479.76 0.00 820.24 19.08 E20 Utilities 42,100.00 48,934.69 0.00 -6,834.69 -16.23 10-330-540010 Building & Grounds Maint. 10,800.00 12,729.96 0.00 -1,929.96 -17.87 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 43,400.00 47,880.16 0.00 -4,480.16 -10.32 10-330-544050 Animal Food 5,000.00 6,871.99 0.00 -1,871.99 -37.44 10-330-545010 Software Licensemaint 3,190.70 3,102.34 73.14 15.22 0.48 10-330-546010 Clothing Expense 1,700.00 1,186.55 0.00 513.45 30.20 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 900.00 1,004.37 0.00 -104.37 -11.60 10-330-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 320.00 0.00 0.00 320.00 100.00 E25 Repairs & Maintenance 65,850.70 73,315.37 73.14 -7,537.81 -11.45 10-330-572010 Purchase of Vehicles 28,817.00 25,107.00 0.00 3,710.00 12.87 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 28,817.00 25,107.00 0.00 3,710.00 12.87 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 659,529.65 655,697.55 73.14 3,758.96 0.57 390 9-1-1 Police 10-390-501020 Salaries 892,106.65 846,040.90 0.00 46,065.75 5.16 10-390-501030 Holiday Pay 30,884.52 27,624.30 0.00 3,260.22 10.56 10-390-501050 Parttime(wo Benefits) 2,600.00 0.00 0.00 2,600.00 100.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 17,183.01 0.00 -1,369.01 -8.66 10-390-501095 Overtime Straight Pay 500.00 185.45 0.00 314.55 62.91 10-390-502010 Social Security 72,055.75 64,742.28 0.00 7,313.47 10.15 10-390-502020 Group Health Insurance 169,816.78 158,533.93 0.00 11,282.85 6.64 10-390-502030 Retirement 125,920.61 114,584.50 0.00 11,336.11 9.00 10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00 10-390-502050 Life Insurance 1,716.66 1,271.41 0.00 445.25 25.94 10-390-502060 Long Term Disability 2,951.74 2,732.45 0.00 219.29 7.43 10-390-502070 Employee Assistance Prgm 561.00 527.56 0.00 33.44 5.96 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,315,408.84 1,233,906.92 0.00 81,501.92 6.20 10-390-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 5,000.00 4,068.53 0.00 931.47 18.63 E10 Materials & Supplies 5,100.00 4,068.53 0.00 1,031.47 20.22 10-390-520030 Dues And Publications 600.00 276.00 0.00 324.00 54.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-520050 Advertising INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 200.00 Training And Education 5,000.00 4,315.47 0.00 684.53 13.69 10-390-522020 497.24 Professional Services 2,700.00 3,091.88 -1,365.68 973.80 36.07 10-390-523010 0.00 Equipment Rentlease 98,000.00 90,339.54 0.00 7,660.46 7.82 E15 0.00 Contractual Services 106,300.00 98,022.89 -1,365.68 9,642.79 9.07 10-390-534010 40.38 Telephone 0.00 0.00 0.00 0.00 0.00 E20 10-400-514020 Utilities 0.00 0.00 0.00 0.00 0.00 10-390-545010 Small Tools Software Licensemaint 23,000.00 23,000.00 0.00 0.00 0.00 10-390-546010 0.00 Clothing Expense 6,000.00 3,333.67 0.00 2,666.33 44.44 10-390-546020 Uniform Cleaning 2,700.00 3,202.05 0.00 -502.05 -18.59 10-390-547010 Equipment Maintenance 3,000.00 2,830.22 0.00 169.78 5.66 10-390-547020 Maintenance Agreements 43,300.00 42,501.97 0.00 798.03 1.84 10-390-547030 Radio Maintenance 3,700.00 4,500.65 0.00 -800.65 -21.64 E25 Repairs & Maintenance 81,700.00 79,368.56 0.00 2,331.44 2.85 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,508,508.84 1,415,366.90 -1,365.68 94,507.62 6.26 400 Fire Department 10-400-501020 Salaries 3,847,633.76 3,684,336.19 0.00 163,297.57 4.24 10-400-501030 Holiday Pay 288,993.13 280,884.73 0.00 8,108.40 2.81 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 32,240.52 0.00 -3,740.52 -13.12 10-400-501090 Overtime 35,596.00 36,239.12 0.00 -643.12 -1.81 10-400-501095 Overtime Straight Pay 27,596.00 24,780.89 0.00 2,815.11 10.20 10-400-502010 Social Security 64,049.56 57,991.67 0.00 6,057.89 9.46 10-400-502020 Group Health Insurance 690,225.52 653,435.00 0.00 36,790.52 5.33 10-400-502030 Retirement 1,897,197.03 1,769,136.93 0.00 128,060.10 6.75 10-400-502040 Workers Compensation 79,145.55 79,145.55 0.00 0.00 0.00 10-400-502050 Life Insurance 7,665.30 5,639.84 0.00 2,025.46 26.42 10-400-502060 Long Term Disability 12,330.63 12,080.67 0.00 249.96 2.03 10-400-502070 Employee Assistance Prgm 2,006.40 1,886.76 0.00 119.64 5.96 10-400-503010 Awards Program 1,500.00 593.15 0.00 906.85 60.46 E05 Personnel Services 6,982,438.88 6,638,391.02 0.00 344,047.86 4.93 10-400-511010 Advertising 1,150.00 271.25 0.00 878.75 76.41 10-400-511020 Postage 200.00 108.61 0.00 91.39 45.70 10-400-512010 Printing 1,250.00 497.24 0.00 752.76 60.22 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 1,073.10 0.00 726.90 40.38 10-400-514010 Gas 54,971.35 47,359.78 0.00 7,611.57 13.85 10-400-514020 Chemicals 1,500.00 1,620.83 0.00 -120.83 -8.06 10-400-514030 Small Tools 4,500.00 4,770.95 0.00 -270.95 -6.02 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-515040 First Aid Supplies 1,600.00 1,594.78 0.00 5.22 0.33 10-400-517010 Operational Supplies 12,200.00 12,026.51 0.00 173.49 1.42 E10 Materials & Supplies 79,221.35 69,323.05 0.00 9,898.30 12.49 10-400-520030 Dues And Publications 2,500.00 2,475.24 0.00 24.76 0.99 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 28,500.00 26,352.80 0.00 2,147.20 7.53 10-400-520080 Tuition Reimbursement 4,000.00 4,254.00 0.00 -254.00 -6.35 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 36,950.25 0.00 3,049.75 7.62 10-400-522020 Professional Services 200.00 195.29 0.00 4.71 2.36 10-400-523010 Equipment Rentlease 500.00 156.45 0.00 343.55 68.71 10-400-524010 Trash Collections 100.00 28.98 0.00 71.02 71.02 10-400-529010 Special Events 7,000.00 5,420.09 0.00 1,579.91 22.57 10-400-529040 Child Safety Seat Pass-through 2,500.00 2,140.00 0.00 360.00 14.40 E15 Contractual Services 85,300.00 77,973.10 0.00 7,326.90 8.59 10-400-531010 Electricity 32,000.00 36,296.72 0.00 -4,296.72 -13.43 10-400-533010 Natural Gas 19,000.00 16,690.65 0.00 2,309.35 12.15 10-400-534010 Telephone 22,000.00 17,895.51 0.00 4,104.49 18.66 10-400-535010 Water 17,000.00 20,357.98 0.00 -3,357.98 -19.75 E20 Utilities 90,000.00 91,240.86 0.00 -1,240.86 -1.38 10-400-540010 Building & Grounds Maint. 201,785.00 192,028.13 11,806.00 -2,049.13 -1.02 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 65,000.00 65,734.94 -37,952.70 37,217.76 57.26 10-400-546020 Uniform Cleaning 400.00 0.00 0.00 400.00 100.00 10-400-547010 Equipment Maintenance 17,750.00 14,022.96 0.00 3,727.04 21.00 10-400-547020 Maintenance Agreements 23,044.00 22,419.03 -2,213.68 2,838.65 12.32 10-400-547030 Radio Maintenance 9,750.00 9,743.70 0.00 6.30 0.06 E25 Repairs & Maintenance 317,729.00 303,948.76 -28,360.38 42,140.62 13.26 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 42,985.00 42,952.10 0.00 32.90 0.08 10-400-572021 Purchase of Equipment -ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572022 Fitness -ONE TIME 178,345.00 0.00 0.00 178,345.00 100.00 10-400-572060 Fire Grant Equipgear 89,187.38 83,031.32 0.00 6,156.06 6.90 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 310,517.38 125,983.42 0.00 184,533.96 59.43 400 Fire Department 7,865,206.61 7,306,860.21 -28,360.38 586,706.78 7.46 401 Fire Museum 10-401-531010 Electricity 2,000.00 539.46 0.00 1,460.54 73.03 10-401-533010 Natural Gas 0.00 483.61 0.00 -483.61 0.00 10-401-535010 Water 0.00 268.87 0.00 -268.87 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 2,000.00 1,291.94 0.00 708.06 35.40 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,000.00 1,291.94 0.00 708.06 35.40 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 520 Plan & Protect Svcs -Admin 10-520-501020 Salaries 178,251.54 173,478.73 0.00 4,772.81 2.68 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,636.24 13,084.64 0.00 551.60 4.05 10-520-502020 Group Health Insurance 21,467.89 20,246.51 0.00 1,221.38 5.69 10-520-502030 Retirement 23,529.20 22,899.17 0.00 630.03 2.68 10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00 10-520-502050 Life Insurance 326.81 262.18 0.00 64.63 19.78 10-520-502060 Long Term Disability 492.78 512.84 0.00 -20.06 -4.07 10-520-502070 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 237,907.01 230,681.90 0.00 7,225.11 3.04 10-520-511010 Advertising 250.00 0.00 0.00 250.00 100.00 10-520-511020 Postage 200.00 87.65 0.00 112.35 56.18 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 900.00 924.84 0.00 -24.84 -2.76 10-520-514010 Gas 12,000.00 9,724.31 0.00 2,275.69 18.96 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 1,019.20 1,208.84 0.00 -189.64 -18.61 E10 Materials & Supplies 14,369.20 11,945.64 0.00 2,423.56 16.87 10-520-520030 Dues And Publications 1,090.60 1,090.60 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,579.61 2,678.61 0.00 -99.00 -3.84 10-520-522020 Professional Services 2,510.59 2,416.71 0.00 93.88 3.74 E15 Contractual Services 6,180.80 6,185.92 0.00 -5.12 -0.08 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,200.00 1,196.34 0.00 3.66 0.31 E25 Repairs & Maintenance 1,200.00 1,196.34 0.00 3.66 0.31 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 259,657.01 250,009.80 0.00 9,647.21 3.72 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 120,152.26 124,234.47 0.00 -4,082.21 -3.40 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-547020 Maintenance Agreements 1,600.00 1,517.58 0.00 82.42 5.15 10-521-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 9,191.65 8,981.82 0.00 209.83 2.28 10-521-502020 Group Health Insurance 19,595.68 23,044.36 0.00 -3,448.68 -17.60 10-521-502030 Retirement 15,860.10 10,790.37 0.00 5,069.73 31.97 10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00 10-521-502050 Life Insurance 220.03 189.09 0.00 30.94 14.06 10-521-502060 Long Term Disability 473.19 407.51 0.00 65.68 13.88 10-521-502070 Employee Assistance Prgm 66.50 49.64 0.00 16.86 25.35 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 165,599.68 167,737.53 0.00 -2,137.85 -1.29 10-521-511010 Advertising 5,000.00 4,219.75 0.00 780.25 15.61 10-521-511020 Postage 1,000.00 780.37 0.00 219.63 21.96 10-521-512010 Printing 100.00 80.00 0.00 20.00 20.00 10-521-512020 Copies 10.00 2.70 0.00 7.30 73.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,100.00 1,217.67 0.00 -117.67 -10.70 10-521-514040 Food 250.00 10.00 0.00 240.00 96.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 3,900.00 4,294.32 0.00 -394.32 -10.11 E10 Materials & Supplies 11,360.00 10,604.81 0.00 755.19 6.65 10-521-520030 Dues And Publications 15,500.00 14,383.53 0.00 1,116.47 7.20 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 2,500.00 1,739.84 0.00 760.16 30.41 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 18,000.00 16,123.37 0.00 1,876.63 10.43 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,600.00 1,517.58 0.00 82.42 5.15 E25 Repairs & Maintenance 1,600.00 1,517.58 0.00 82.42 5.15 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 196,559.68 195,983.29 0.00 576.39 0.29 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 105,340.42 92,033.44 0.00 13,306.98 12.63 10-522-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-547010 Equipment Maintenance 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 7,904.34 6,989.49 0.00 914.85 11.57 10-522-502020 Group Health Insurance 16,834.61 12,279.20 0.00 4,555.41 27.06 10-522-502030 Retirement 12,815.34 12,148.42 0.00 666.92 5.20 10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00 10-522-502050 Life Insurance 265.21 143.74 0.00 121.47 45.80 10-522-502060 Long Term Disability 434.79 309.51 0.00 125.28 28.81 10-522-502070 Employee Assistance Prgm 65.50 74.48 0.00 -8.98 -13.71 E05 Personnel Services 143,723.58 124,041.65 0.00 19,681.93 13.69 10-522-511010 Advertising 1,500.00 839.94 0.00 660.06 44.00 10-522-511020 Postage 400.00 106.90 0.00 293.10 73.28 10-522-512010 Printing 125.00 40.00 0.00 85.00 68.00 10-522-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-522-513010 Office Supplies 1,000.00 311.50 0.00 688.50 68.85 10-522-514040 Food 250.00 234.33 0.00 15.67 6.27 10-522-517010 Operational Supplies 1,620.00 1,541.37 0.00 78.63 4.85 E10 Materials & Supplies 4,905.00 3,074.04 0.00 1,830.96 37.33 10-522-520030 Dues And Publications 1,500.00 981.30 0.00 518.70 34.58 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 5,750.00 4,025.98 0.00 1,724.02 29.98 10-522-522020 Professional Services 150,000.00 14,396.92 135,595.08 8.00 0.01 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 157,250.00 19,404.20 135,595.08 2,250.72 1.43 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 525.00 518.18 0.00 6.82 1.30 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 525.00 518.18 0.00 6.82 1.30 10-522-572020 Purchase Of Equipment 675.00 0.00 0.00 675.00 100.00 E70 Capital Purchases 675.00 0.00 0.00 675.00 100.00 522 Plan & Protect Svcs -MPO 307,078.58 147,038.07 135,595.08 24,445.43 7.96 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 74,388.22 71,029.10 0.00 3,359.12 4.52 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 5,843.70 5,097.52 0.00 746.18 12.77 10-530-502020 Group Health Insurance 9,190.53 8,358.41 0.00 832.12 9.05 10-530-502030 Retirement 8,083.24 7,704.76 0.00 378.48 4.68 10-530-502040 Workers Compensation 28.02 28.02 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-502050 Life Insurance 141.37 108.94 0.00 32.43 22.94 10-530-502060 Long Term Disability 250.31 234.23 0.00 16.08 6.42 10-530-502070 Employee Assistance Prgm 39.60 37.24 0.00 2.36 5.96 E05 Personnel Services 97,964.99 92,598.22 0.00 5,366.77 5.48 10-530-511010 Advertising 846.90 876.65 0.00 -29.75 -3.51 10-530-511020 Postage 241.97 58.23 0.00 183.74 75.94 10-530-512010 Printing 80.00 80.00 0.00 0.00 0.00 10-530-512020 Copies 18.75 0.00 0.00 18.75 100.00 10-530-513010 Office Supplies 300.00 302.67 0.00 -2.67 -0.89 10-530-517010 Operational Supplies 668.60 515.69 0.00 152.91 22.87 E10 Materials & Supplies 2,156.22 1,833.24 0.00 322.98 14.98 10-530-520030 Dues And Publications 516.10 516.10 0.00 0.00 0.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 4,746.24 2,771.24 0.00 1,975.00 41.61 10-530-522020 Professional Services 790.93 431.00 0.00 359.93 45.51 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,863.50 19,863.50 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 803.96 496.20 0.00 307.76 38.28 10-530-524029 Recycling Education 9,000.00 7,254.16 0.00 1,745.84 19.40 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 35,720.73 31,332.20 0.00 4,388.53 12.29 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 150.00 38.26 0.00 111.74 74.49 E25 Repairs & Maintenance 150.00 38.26 0.00 111.74 74.49 10-530-550020 NRA -Residential 52,742.70 52,742.70 0.00 0.00 0.00 10-530-550030 NRA -Commercial Facade 17,880.53 17,880.53 0.00 0.00 0.00 10-530-550031 Historic Preservation Grant 23,000.00 0.00 0.00 23,000.00 100.00 10-530-550032 NRA -Rental Facade 19,376.77 18,000.00 0.00 1,376.77 7.11 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 523.05 523.05 0.00 0.00 0.00 10-530-550039 Historic Preservation Grant 50,000.00 0.00 0.00 50,000.00 100.00 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 210,620.43 89,146.28 0.00 121,474.15 57.67 530 Plan & Protect Svc-RedevGrant 346,612.37 214,948.20 0.00 131,664.17 37.99 Page 23 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 29.75 0.00 -29.75 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 29.75 0.00 -29.75 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 531 Dues And Publications Plan & Protect Svcs -Build Reg 0.00 29.75 0.00 -29.75 0.00 532 0.00 Plan & Protect Svcs -Env Health 0.00 0.00 0.00 10-532-520070 Training And Education 10-532-501020 758.00 Salaries 172,794.15 168,174.60 0.00 4,619.55 2.67 10-532-501050 0.00 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-532-501060 0.00 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 0.00 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 10-532-524026 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 INACTIVE - Portable Recycling Social Security 13,241.70 11,790.04 0.00 1,451.66 10.96 10-532-502020 0.00 Group Health Insurance 32,261.24 30,239.78 0.00 2,021.46 6.27 10-532-502030 224,000.04 Retirement 22,848.43 22,198.98 0.00 649.45 2.84 10-532-502040 0.00 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00 10-532-502050 0.00 Life Insurance 317.63 261.03 0.00 56.60 17.82 10-532-502060 Long Term Disability 572.10 563.67 0.00 8.43 1.47 10-532-502070 0.00 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 244,193.68 235,081.81 0.00 9,111.87 3.73 10-532-511010 Advertising 100.00 89.25 0.00 10.75 10.75 10-532-511020 Postage 200.00 139.27 0.00 60.73 30.37 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.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,650.00 1,731.66 0.00 -81.66 -4.95 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 2,023.49 2,088.14 0.00 -64.65 -3.19 EIO Materials & Supplies 4,108.49 4,048.32 0.00 60.17 1.46 10-532-520030 Dues And Publications 892.00 743.45 0.00 148.55 16.65 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 758.00 758.00 0.00 0.00 0.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 224,000.00 224,000.04 0.00 -0.04 0.00 10-532-529010 Special Events 423.76 205.00 0.00 218.76 51.62 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 226,073.76 225,706.49 0.00 367.27 0.16 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 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-540060 Cemetery Maintenance 37,000.00 34,229.68 2,483.00 287.32 0.78 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,112.75 888.73 0.00 224.02 20.13 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 740.00 631.69 0.00 108.31 14.64 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 40,222.75 37,034.10 2,483.00 705.65 1.75 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 514,598.68 501,870.72 2,483.00 10,244.96 1.99 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 157,966.61 142,602.86 0.00 15,363.75 9.73 10-533-501050 Parttime(wo Benefits) 3,520.88 3,520.88 0.00 0.00 0.00 10-533-501060 Seasonal Salaries 27,379.12 24,271.74 0.00 3,107.38 11.35 10-533-501090 Overtime 537.50 0.00 0.00 537.50 100.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 13,710.24 12,121.78 0.00 1,588.46 11.59 10-533-502020 Group Health Insurance 27,426.94 24,786.56 0.00 2,640.38 9.63 10-533-502030 Retirement 20,006.31 17,955.08 0.00 2,051.23 10.25 10-533-502040 Workers Compensation 1,874.09 1,874.09 0.00 0.00 0.00 10-533-502050 Life Insurance 297.43 201.09 0.00 96.34 32.39 10-533-502060 Long Term Disability 518.98 480.35 0.00 38.63 7.44 10-533-502070 Employee Assistance Prgm 92.40 86.88 0.00 5.52 5.97 E05 Personnel Services 253,330.50 227,901.31 0.00 25,429.19 10.04 10-533-511010 Advertising 106.23 106.23 0.00 0.00 0.00 10-533-511020 Postage 2,200.00 2,489.99 0.00 -289.99 -13.18 10-533-512010 Printing 350.00 180.00 0.00 170.00 48.57 10-533-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 900.00 895.09 0.00 4.91 0.55 10-533-514030 Small Tools 132.00 117.93 0.00 14.07 10.66 10-533-515040 First Aid Supplies 8.77 0.00 0.00 8.77 100.00 10-533-517010 Operational Supplies 3,125.89 3,364.72 0.00 -238.83 -7.64 E10 Materials & Supplies 6,837.89 7,153.96 0.00 -316.07 -4.62 10-533-520030 Dues And Publications 111.98 111.98 0.00 0.00 0.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,588.58 1,588.58 0.00 0.00 0.00 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 41,235.00 41,235.00 0.00 0.00 0.00 10-533-522022 Demo 40,000.00 5,095.00 0.00 34,905.00 87.26 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-546010 Clothing Expense 1,039.05 1,039.05 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 82,935.56 48,030.56 0.00 34,905.00 42.09 10-533-534010 Telephone 760.00 514.08 0.00 245.92 32.36 E20 Utilities 760.00 514.08 0.00 245.92 32.36 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,039.05 1,039.05 0.00 0.00 0.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 720.00 550.49 0.00 169.51 23.54 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,059.05 1,859.54 0.00 199.51 9.69 10-533-572020 Purchase Of Equipment 34,910.00 27,742.00 7,168.00 0.00 0.00 E70 Capital Purchases 34,910.00 27,742.00 7,168.00 0.00 0.00 533 PPS - Prop MaintCode Enforce 380,833.00 313,201.45 7,168.00 60,463.55 15.88 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 319,690.54 310,765.30 0.00 8,925.24 2.79 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 370.00 0.00 0.00 370.00 100.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 24,489.60 21,926.96 0.00 2,562.64 10.46 10-534-502020 Group Health Insurance 65,491.66 63,482.97 0.00 2,008.69 3.07 10-534-502030 Retirement 42,256.57 36,523.18 0.00 5,733.39 13.57 10-534-502040 Workers Compensation 2,012.43 2,012.43 0.00 0.00 0.00 10-534-502050 Life Insurance 589.36 467.44 0.00 121.92 20.69 10-534-502060 Long Term Disability 1,032.81 1,004.07 0.00 28.74 2.78 10-534-502070 Employee Assistance Prgm 158.40 148.96 0.00 9.44 5.96 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 456,156.37 436,331.31 0.00 19,825.06 4.35 10-534-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-534-511020 Postage 1,000.00 1,179.80 0.00 -179.80 -17.98 10-534-512010 Printing 50.00 40.00 0.00 10.00 20.00 10-534-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 1,600.00 1,619.51 0.00 -19.51 -1.22 10-534-514030 Small Tools 150.00 110.20 0.00 39.80 26.53 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 3,638.89 4,065.13 0.00 -426.24 -11.71 E10 Materials & Supplies 6,468.89 7,014.64 0.00 -545.75 -8.44 10-534-520030 Dues And Publications 6,580.00 6,560.26 0.00 19.74 0.30 10-534-520050 INACTIVE - Mtes & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-520070 Training And Education 8,199.49 8,250.29 0.00 -50.80 -0.62 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,779.49 14,810.55 0.00 -31.06 -0.21 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,632.77 1,632.77 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 1,070.00 778.91 0.00 291.09 27.20 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,992.77 2,681.68 0.00 311.09 10.39 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,397.52 460,838.18 0.00 19,559.34 4.07 535 Public Works -Central Maintenan 10-535-501020 Salaries 339,628.72 330,547.50 0.00 9,081.22 2.67 10-535-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits) 7,400.00 3,696.05 0.00 3,703.95 50.05 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,986.17 0.00 513.83 11.42 10-535-501095 Overtime Straight Pay 500.00 358.15 0.00 141.85 28.37 10-535-502010 Social Security 26,930.20 24,741.78 0.00 2,188.42 8.13 10-535-502020 Group Health Insurance 68,787.67 66,499.36 0.00 2,288.31 3.33 10-535-502030 Retirement 45,490.99 44,205.43 0.00 1,285.56 2.83 10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00 10-535-502050 Life Insurance 626.08 513.36 0.00 112.72 18.00 10-535-502060 Long Term Disability 1,106.25 1,109.93 0.00 -3.68 -0.33 10-535-502070 Employee Assistance Prgm 184.80 173.76 0.00 11.04 5.97 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 497,415.26 478,092.04 0.00 19,323.22 3.88 10-535-511010 Advertising 67.59 0.00 0.00 67.59 100.00 10-535-511020 Postage 50.00 4.60 0.00 45.40 90.80 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,512.41 1,512.41 0.00 0.00 0.00 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,918.30 5,304.88 0.00 2,613.42 33.00 10-535-517010 Operational Supplies 6,950.00 4,014.13 0.00 2,935.87 42.24 E10 Materials & Supplies 16,508.30 10,836.02 0.00 5,672.28 34.36 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-520030 Dues And Publications 131.70 131.70 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,000.00 2,622.38 0.00 377.62 12.59 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 3,631.70 3,254.08 0.00 377.62 10.40 10-535-531010 Electricity 7,560.00 7,117.70 0.00 442.30 5.85 10-535-533010 Natural Gas 8,652.00 6,107.40 0.00 2,544.60 29.41 10-535-534010 Telephone 220.00 106.74 72.00 41.26 18.75 10-535-535010 Water 1,442.00 1,203.10 0.00 238.90 16.57 E20 Utilities 17,874.00 14,534.94 72.00 3,267.06 18.28 10-535-540010 Building & Grounds Maint. 10,926.80 12,239.12 35.00 -1,347.32 -12.33 10-535-541010 Veh & Equip Parts Etc 484,000.00 549,441.48 0.00 -65,441.48 -13.52 10-535-546010 Clothing Expense 5,500.00 6,335.48 0.00 -835.48 -15.19 10-535-547010 Equipment Maintenance 1,152.56 390.34 0.00 762.22 66.13 10-535-547020 Maintenance Agreements 14,220.64 14,346.29 0.00 -125.65 -0.88 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 515,900.00 582,752.71 35.00 -66,887.71 -12.97 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works -Central Maintenan 1,051,329.26 1,089,469.79 107.00 -38,247.53 -3.64 540 Public Works -Admin 10-540-501020 Salaries 210,328.01 204,688.95 0.00 5,639.06 2.68 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 16,090.09 14,588.42 0.00 1,501.67 9.33 10-540-502020 Group Health Insurance 31,871.40 28,443.47 0.00 3,427.93 10.76 10-540-502030 Retirement 27,763.30 27,018.88 0.00 744.42 2.68 10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00 10-540-502050 Life Insurance 387.40 318.10 0.00 69.30 17.89 10-540-502060 Long Term Disability 588.01 570.10 0.00 17.91 3.05 10-540-502070 Employee Assistance Prgm 79.20 74.48 0.00 4.72 5.96 E05 Personnel Services 287,222.68 275,817.67 0.00 11,405.01 3.97 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 36.59 0.00 163.41 81.71 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 51.95 0.00 948.05 94.81 10-540-514010 Gas 83,121.26 61,363.41 0.00 21,757.85 26.18 10-540-514040 Food 200.00 -55.56 0.00 255.56 127.78 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-517010 Operational Supplies 666.02 16.25 0.00 649.77 97.56 E10 Materials & Supplies 85,487.28 61,412.64 0.00 24,074.64 28.16 10-540-520030 Dues And Publications 590.00 590.00 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 4,433.98 4,700.41 0.00 -266.43 -6.01 10-540-522020 Professional Services 110.00 0.00 0.00 110.00 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,133.98 5,290.41 0.00 -156.43 -3.05 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 209.04 0.00 160.96 43.50 E25 Repairs & Maintenance 370.00 209.04 0.00 160.96 43.50 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 378,213.94 342,729.76 0.00 35,484.18 9.38 541 Public Works -Engineering 10-541-501020 Salaries 780,183.89 759,310.15 0.00 20,873.74 2.68 10-541-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 332.79 0.00 67.21 16.80 10-541-501095 Overtime Straight Pay 400.00 0.00 0.00 400.00 100.00 10-541-502010 Social Security 59,745.27 54,175.95 0.00 5,569.32 9.32 10-541-502020 Group Health Insurance 140,790.20 131,666.22 0.00 9,123.98 6.48 10-541-502030 Retirement 103,089.87 100,272.83 0.00 2,817.04 2.73 10-541-502040 Workers Compensation 3,639.97 3,639.97 0.00 0.00 0.00 10-541-502050 Life Insurance 1,435.75 1,178.94 0.00 256.81 17.89 10-541-502060 Long Term Disability 2,560.61 2,508.75 0.00 51.86 2.03 10-541-502070 Employee Assistance Prgm 316.80 297.92 0.00 18.88 5.96 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,092,562.36 1,053,383.52 0.00 39,178.84 3.59 10-541-511010 Advertising 166.25 262.50 0.00 -96.25 -57.89 10-541-511020 Postage 400.00 235.93 0.00 164.07 41.02 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 3.61 0.00 71.39 95.19 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 4,329.63 3,962.35 0.00 367.28 8.48 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 130.01 40.12 0.00 89.89 69.14 10-541-515040 First Aid Supplies 65.45 65.45 0.00 0.00 0.00 10-541-515070 Const & Insnect Suunlies 842.53 842.53 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) 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-515080 Surveying Supplies 581.52 581.52 0.00 0.00 0.00 10-541-517010 Operational Supplies 2,736.67 2,736.67 0.00 0.00 0.00 E10 Materials & Supplies 9,627.06 8,730.68 0.00 896.38 9.31 10-541-520030 Dues And Publications 3,448.00 3,332.99 0.00 115.01 3.34 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,275.02 4,275.02 0.00 0.00 0.00 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 33.00 33.00 0.00 0.00 0.00 10-541-522055 Stormwater Compliance 1,500.00 1,000.00 0.00 500.00 33.33 E15 Contractual Services 9,256.02 8,641.01 0.00 615.01 6.64 10-541-534010 Telephone 500.00 431.62 0.00 68.38 13.68 E20 Utilities 500.00 431.62 0.00 68.38 13.68 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,345.36 1,345.36 0.00 0.00 0.00 10-541-547010 Equipment Maintenance 1,478.00 615.00 0.00 863.00 58.39 10-541-547020 Maintenance Agreements 10,799.64 8,480.26 0.00 2,319.38 21.48 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,623.00 11,400.62 0.00 3,222.38 22.04 10-541-572010 Purchase of Vehicles 56,167.00 56,167.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 6,501.92 6,017.50 0.00 484.42 7.45 E70 Capital Purchases 62,668.92 62,184.50 0.00 484.42 0.77 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works -Engineering 1,189,237.36 1,144,771.95 0.00 44,465.41 3.74 542 Public Works -Street 10-542-501020 Salaries 1,256,482.38 1,226,203.78 0.00 30,278.60 2.41 10-542-501060 Seasonal Salaries 22,030.89 22,314.39 0.00 -283.50 -1.29 10-542-501070 Stand-by Plan 5,000.00 4,164.00 0.00 836.00 16.72 10-542-501090 Overtime 31,461.44 22,061.73 0.00 9,399.71 29.88 10-542-501095 Overtime Straight Pay 2,007.67 2,059.54 0.00 -51.87 -2.58 10-542-502010 Social Security 100,749.15 94,492.22 0.00 6,256.93 6.21 10-542-502020 Group Health Insurance 239,252.17 213,374.97 0.00 25,877.20 10.82 10-542-502030 Retirement 171,201.67 147,167.53 0.00 24,034.14 14.04 10-542-502040 Workers Compensation 18,752.09 18,752.09 0.00 0.00 0.00 10-542-502050 Life Insurance 2,318.22 1,790.47 0.00 527.75 22.77 10-542-502060 Long Term Disability 4,007.58 3,823.40 0.00 184.18 4.60 10-542-502070 Employee Assistance Prgm 752.40 633.04 0.00 119.36 15.86 10-542-503010 Awards Program 200.00 55.00 0.00 145.00 72.50 10-542-503020 UnemDlovment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 1,854,215.66 1,756,892.16 0.00 97,323.50 5.25 10-542-511010 Advertising 1,994.96 1,994.96 0.00 0.00 0.00 10-542-511020 Postage 150.00 55.03 0.00 94.97 63.31 10-542-512010 Printing 213.96 213.96 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,432.29 1,359.21 0.00 73.08 5.10 10-542-514020 Chemicals 148,171.50 148,171.50 -12,294.82 12,294.82 8.30 10-542-514030 Small Tools 9,898.47 9,898.47 0.00 0.00 0.00 10-542-514040 Food 2,000.00 1,638.07 0.00 361.93 18.10 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 404,430.58 387,886.52 13,886.32 2,657.74 0.66 10-542-515040 First Aid Supplies 400.00 124.26 0.00 275.74 68.94 10-542-515060 Weed Control 2,483.11 1,408.00 0.00 1,075.11 43.30 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 4,857.58 5,017.58 0.00 -160.00 -3.29 E10 Materials & Supplies 576,242.45 557,767.56 1,591.50 16,883.39 2.93 10-542-520030 Dues And Publications 1,075.00 1,084.00 0.00 -9.00 -0.84 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 10,298.29 10,694.29 0.00 -396.00 -3.85 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 18,345.24 17,551.55 500.00 293.69 1.60 10-542-523010 Equipment Rentlease 235.00 235.00 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 1,253.68 0.00 -253.68 -25.37 E15 Contractual Services 30,953.53 30,818.52 500.00 -364.99 -1.18 10-542-531010 Electricity 30,882.10 24,525.19 0.00 6,356.91 20.58 10-542-531020 Street Lights 652,979.78 581,457.53 0.00 71,522.25 10.95 10-542-533010 Natural Gas 15,179.36 12,144.24 0.00 3,035.12 20.00 10-542-534010 Telephone 515.00 96.00 0.00 419.00 81.36 10-542-535010 Water 14,009.33 15,294.55 0.00 -1,285.22 -9.17 E20 Utilities 713,565.57 633,517.51 0.00 80,048.06 11.22 10-542-540010 Building & Grounds Maint. 10,956.53 8,592.09 500.00 1,864.44 17.02 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 29,785.56 29,888.76 0.00 -103.20 -0.35 10-542-542030 Signs & Marking Paint 36,561.53 36,561.53 0.00 0.00 0.00 10-542-546010 Clothing Expense 14,400.00 17,343.88 0.00 -2,943.88 -20.44 10-542-547010 Equipment Maintenance 3,200.00 3,098.72 0.00 101.28 3.17 10-542-547020 Maintenance Agreements 330.00 300.00 0.00 30.00 9.09 10-542-547030 Radio Maintenance 438.47 242.40 0.00 196.07 44.72 E25 Repairs & Maintenance 102,672.09 102,651.38 500.00 -479.29 -0.47 10-542-572010 Purchase Of Vehicles 451,853.00 451,794.60 0.00 58.40 0.01 10-542-572020 Purchase Of Equipment 27,350.00 27,350.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571010 Capvehclequip-city Admin 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 479,203.00 479,144.60 0.00 58.40 0.01 542 Public Works -Street 3,756,852.30 3,560,791.73 2,591.50 193,469.07 5.15 700 Transfers & Subsidies 0.00 0.00 0.00 0.00 0.00 10-700-590050 Transfer To Tif Fund 22,750.00 6,370.69 0.00 16,379.31 72.00 10-700-590065 Trans to Self -Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 300,000.00 300,000.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 225,547.12 225,547.12 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,023,442.24 1,023,442.24 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,571,739.36 1,555,360.05 0.00 16,379.31 1.04 700 Transfers & Subsidies 1,571,739.36 1,555,360.05 0.00 16,379.31 1.04 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 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,221,035.00 13,902.52 648,620.67 558,511.81 45.74 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 406,000.00 0.00 0.00 406,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 -35,234.73 0.00 35,234.73 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 637,800.00 636,500.00 1,300.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 476,715.20 122,532.65 16,893.00 337,289.55 70.75 10-990-577063 Clark Avenue 93,658.26 80,897.30 12,760.96 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 502,783.65 239,512.50 102,503.75 160,767.40 31.98 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 0.00 0.00 278,564.00 100.00 E75 Capital Projects 3,616,556.11 1,058,110.24 782,078.38 1,776,367.49 49.12 990 Capital Projects 3,616,556.11 1,058,110.24 782,078.38 1,776,367.49 49.12 Expense Expense 38,203,404.73 32,728,482.76 901,214.83 4,573,707.14 11.97 GL - Trial Balance by Acct Type and Full Acct Number (11/07/2018 - 11:07 AM) Page 34