Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2017-11 Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 11/06/17 10:05:48 Period 01 - 13 Fiscal Year 2017 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 64,800.00 64,350.00 0.00 450.00 0.69 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 4,957.20 4,579.06 0.00 378.14 7.63 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 69,794.67 68,966.53 0.00 828.14 1.19 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 10.63 0.00 89.37 89.37 10-110-512010 Printing 697.00 697.00 0.00 0.00 0.00 10-110-512020 Copies 200.00 0.07 0.00 199.93 99.97 10-110-513010 Office Supplies 684.00 778.58 0.00 -94.58 -13.83 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,681.00 1,486.28 0.00 194.72 11.58 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 731.72 0.00 768.28 51.22 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 892.00 356.00 0.00 536.00 60.09 10-110-522020 Professional Services 100.00 300.00 0.00 -200.00 -200.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,492.00 6,095.62 0.00 1,396.38 18.64 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 75.00 89.16 0.00 -14.16 -18.88 E25 Repairs & Maintenance 75.00 89.16 0.00 -14.16 -18.88 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 110 Mayor & Council 79,042.67 76,637.59 0.00 2,405.08 3.04 120 City Clerk 10-120-501020 Salaries 66,131.70 55,080.44 0.00 11,051.26 16.71 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 5,059.07 4,009.82 0.00 1,049.25 20.74 10-120-502020 Group Health Insurance 4,427.58 11,100.86 0.00 -6,673.28 -150.72 10-120-502030 Retirement 9,787.50 8,151.89 0.00 1,635.61 16.71 10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00 10-120-502050 Life Insurance 129.25 62.26 0.00 66.99 51.83 10-120-502060 Long Term Disability 203.17 181.77 0.00 21.40 10.53 10-120-502070 Employee Assistance Prgm 34.84 32.36 0.00 2.48 7.12 E05 Personnel Services 85,806.68 78,652.97 0.00 7,153.71 8.34 10-120-511020 Postage 200.00 219.50 0.00 -19.50 -9.75 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 254.68 0.00 45.32 15.11 10-120-513010 Office Supplies 555.00 533.81 0.00 21.19 3.82 E10 Materials & Supplies 1,055.00 1,007.99 0.00 47.01 4.46 10-120-520030 Dues And Publications 275.00 114.98 0.00 160.02 58.19 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,015.00 1,028.35 0.00 -13.35 -1.32 10-120-522020 Professional Services 1,094.64 874.64 0.00 220.00 20.10 10-120-529030 Election Expense 29,945.00 17,618.30 0.00 12,326.70 41.16 E15 Contractual Services 32,329.64 19,636.27 0.00 12,693.37 39.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 295.00 295.76 0.00 -0.76 -0.26 E25 Repairs & Maintenance 295.00 295.76 0.00 -0.76 -0.26 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 119,486.32 99,592.99 0.00 19,893.33 16.65 140 City Administrator 10-140-501020 Salaries 209,190.37 204,818.44 0.00 4,371.93 2.09 10-140-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,673.14 12,669.53 0.00 4,003.61 24.01 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-502020 Group Health Insurance 20,053.89 22,233.67 0.00 -2,179.78 -10.87 10-140-502030 Retirement 33,467.42 27,271.21 0.00 6,196.21 18.51 10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00 10-140-502050 Life Insurance 199.76 132.39 0.00 67.37 33.73 10-140-502060 Long Term Disability 412.24 289.94 0.00 122.30 29.67 10-140-502070 Employee Assistance Prgm 52.39 48.64 0.00 3.75 7.16 E05 Personnel Services 280,134.53 267,549.14 0.00 12,585.39 4.49 10-140-511010 Advertising 200.00 0.00 0.00 200.00 100.00 10-140-511020 Postage 250.00 96.42 0.00 153.58 61.43 10-140-512010 Printing 200.00 106.00 0.00 94.00 47.00 10-140-512020 Copies 250.00 110.26 0.00 139.74 55.90 10-140-513010 Office Supplies 850.00 780.27 0.00 69.73 8.20 10-140-517010 Operational Supplies 1,027.00 905.08 0.00 121.92 11.87 E10 Materials & Supplies 2,777.00 1,998.03 0.00 778.97 28.05 10-140-520030 Dues And Publications 1,800.00 508.70 0.00 1,291.30 71.74 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 3,000.00 2,924.12 0.00 75.88 2.53 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 800.00 672.12 0.00 127.88 15.99 E15 Contractual Services 5,600.00 4,104.94 0.00 1,495.06 26.70 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 220.00 231.99 0.00 -11.99 -5.45 E25 Repairs & Maintenance 220.00 231.99 0.00 -11.99 -5.45 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 288,731.53 273,884.10 0.00 14,847.43 5.14 149 Entitlement Grant 10-149-501020 Salaries 37,424.05 23,135.65 0.00 14,288.40 38.18 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,072.52 1,665.67 0.00 1,406.85 45.79 10-149-502020 Group Health Insurance 5,978.10 5,689.89 0.00 288.21 4.82 10-149-502030 Retirement 2,969.22 2,205.32 0.00 763.90 25.73 10-149-502040 Workers Compensation 30.00 0.00 0.00 30.00 100.00 10-149-502050 Life Insurance 37.21 33.46 0.00 3.75 10.08 10-149-502060 Long Term Disability 73.75 69.83 0.00 3.92 5.32 10-149-502070 Employee Assistance Program 13.10 12.16 0.00 0.94 7.18 E05 Personnel Services 49.597.95 32.811.98 0.00 16.785.97 33.84 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-511010 Advertising 1,499.93 1,359.75 0.00 140.18 9.35 10-149-511020 Postage 500.00 237.35 0.00 262.65 52.53 10-149-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 269.67 0.00 730.33 73.03 10-149-517010 Operational Supplies 525.00 67.94 0.00 457.06 87.06 E10 Materials & Supplies 3,525.00 1,934.78 0.00 1,590.22 45.11 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 5,776.46 5,468.67 0.00 307.79 5.33 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 40,198.00 9,493.00 0.00 30,705.00 76.38 10-149-528012 Housing Rehab -Energy Efficienc 30,198.00 9,996.00 0.00 20,202.00 66.90 10-149-528020 Housing Assistance 25,540.00 20,392.00 0.00 5,148.00 20.16 10-149-528030 Public Improvement 66,300.72 0.00 0.00 66,300.72 100.00 10-149-528040 Neighborhood Redevelopmnt 111,223.54 18,733.00 0.00 92,490.54 83.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 5,000.00 0.00 0.00 5,000.00 100.00 10-149-528080 Homeless Objectives 35,133.47 10,615.94 0.00 24,517.53 69.78 E15 Contractual Services 319,370.19 74,698.61 0.00 244,671.58 76.61 10-149-547020 Maintenance Agreements 350.00 237.97 0.00 112.03 32.01 E25 Repairs & Maintenance 350.00 237.97 0.00 112.03 32.01 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 130,365.00 118,378.55 11,986.45 0.00 0.00 E75 Capital Projects 130,365.00 118,378.55 11,986.45 0.00 0.00 149 Entitlement Grant 503,208.14 228,061.89 11,986.45 263,159.80 52.30 150 City Counselor 10-150-501020 Salaries 228,300.53 246,369.61 0.00 -18,069.08 -7.91 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 17,464.99 18,019.82 0.00 -554.83 -3.18 10-150-502020 Group Health Insurance 38,273.07 44,071.33 0.00 -5,798.26 -15.15 10-150-502030 Retirement 33,788.48 36,462.60 0.00 -2,674.12 -7.91 10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00 10-150-502050 Life Insurance 444.56 376.64 0.00 67.92 15.28 10-150-502060 Long Term Disability 635.04 733.25 0.00 -98.21 -15.47 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502070 Employee Assistance Prgm 87.49 81.24 0.00 6.25 7.14 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 319,154.92 346,275.25 0.00 -27,120.33 -8.50 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 402.95 0.00 197.05 32.84 10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-150-512020 Copies 300.00 2.50 0.00 297.50 99.17 10-150-513010 Office Supplies 1,800.00 1,435.49 0.00 364.51 20.25 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,850.00 1,840.94 0.00 1,009.06 35.41 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,000.00 7,614.65 1,848.00 1,537.35 13.98 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,000.00 4,110.45 0.00 1,889.55 31.49 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 44,150.00 29,726.40 0.00 14,423.60 32.67 10-150-525030 Court Cost & Witness Fees 75.00 11.25 0.00 63.75 85.00 E15 Contractual Services 62,225.00 41,462.75 1,848.00 18,914.25 30.40 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 625.00 499.93 0.00 125.07 20.01 E25 Repairs & Maintenance 625.00 499.93 0.00 125.07 20.01 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 384,854.92 390,078.87 1,848.00 -7,071.95 -1.84 160 Municipal Court 10-160-501010 Salary -elected Officals 59,999.88 65,416.59 0.00 -5,416.71 -9.03 10-160-501020 Salaries 101,707.05 51,109.82 0.00 50,597.23 49.75 10-160-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits) 17,068.99 5,258.75 0.00 11,810.24 69.19 10-160-501090 Overtime 3,000.00 2,069.54 0.00 930.46 31.02 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,905.85 9,101.52 0.00 4,804.33 34.55 10-160-502020 Group Health Insurance 20,227.17 9,970.37 0.00 10,256.80 50.71 10-160-502030 Retirement 15,496.64 6,548.82 0.00 8,947.82 57.74 10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00 10-160-502050 Life Insurance 199.76 64.80 0.00 134.96 67.56 10-160-502060 Lone Term Disabilitv 312.11 133.81 0.00 178.30 57.13 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502070 Employee Assistance Prgm 61.03 56.64 0.00 4.39 7.19 E05 Personnel Services 232,084.90 149,837.08 0.00 82,247.82 35.44 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,800.00 3,285.77 0.00 514.23 13.53 10-160-512010 Printing 1,090.00 540.00 0.00 550.00 50.46 10-160-512020 Copies 500.00 201.57 0.00 298.43 59.69 10-160-513010 Office Supplies 3,500.00 3,167.45 0.00 332.55 9.50 E10 Materials & Supplies 8,890.00 7,194.79 0.00 1,695.21 19.07 10-160-520025 Security 7,000.00 10,509.31 -3,955.17 445.86 6.37 10-160-520030 Dues And Publications 450.00 60.00 0.00 390.00 86.67 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 1,263.33 0.00 1,236.67 49.47 10-160-522020 Professional Services 4,595.02 4,595.02 0.00 0.00 0.00 10-160-525005 Appointed Counsel 7,000.00 4,810.00 0.00 2,190.00 31.29 10-160-525010 Care Of Prisoners 1,904.98 0.00 0.00 1,904.98 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 23,490.00 21,237.66 -3,955.17 6,207.51 26.43 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 730.00 960.89 0.00 -230.89 -31.63 E25 Repairs & Maintenance 730.00 960.89 0.00 -230.89 -31.63 10-160-572020 Purchase Of Equipment 5,563.24 689.06 5,563.24 -689.06 -12.39 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 5,563.24 689.06 5,563.24 -689.06 -12.39 160 Municipal Court 270,758.14 179,919.48 1,608.07 89,230.59 32.96 170 Human Resources 10-170-501020 Salaries 194,985.36 190,196.42 0.00 4,788.94 2.46 10-170-501050 Parttime(wo Benefits) 38,932.80 26,853.35 0.00 12,079.45 31.03 10-170-501090 Overtime 300.00 111.60 0.00 188.40 62.80 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 17,917.69 16,508.62 0.00 1,409.07 7.86 10-170-502020 Group Health Insurance 19,329.42 18,295.19 0.00 1,034.23 5.35 10-170-502030 Retirement 28,902.24 28,165.63 0.00 736.61 2.55 10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00 10-170-502050 Life Insurance 370.14 293.34 0.00 76.80 20.75 10-170-502060 Long Term Disability 521.91 545.11 0.00 -23.20 -4.45 10-170-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 301,432.67 281,136.75 0.00 20,295.92 6.73 10-170-511010 Advertisine 150.00 49.00 0.00 101.00 67.33 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-511020 Postage 300.00 225.83 0.00 74.17 24.72 10-170-512010 Printing 1,000.00 904.04 0.00 95.96 9.60 10-170-512020 Copies 500.00 586.07 0.00 -86.07 -17.21 10-170-513010 Office Supplies 1,200.00 1,003.03 0.00 196.97 16.41 10-170-517010 Operational Supplies 750.00 662.70 0.00 87.30 11.64 E10 Materials & Supplies 3,900.00 3,430.67 0.00 469.33 12.03 10-170-520030 Dues And Publications 1,468.00 32.05 0.00 1,435.95 97.82 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,184.37 0.00 1,315.63 37.59 10-170-520070 Training And Education 5,220.00 4,924.18 0.00 295.82 5.67 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 940.00 792.25 0.00 147.75 15.72 10-170-522020 Professional Services 2,000.00 3,650.92 0.00 -1,650.92 -82.55 10-170-529010 Special Events 1,000.00 50.56 0.00 949.44 94.94 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,128.00 11,634.33 0.00 2,493.67 17.65 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 220.00 230.27 0.00 -10.27 -4.67 E25 Repairs & Maintenance 220.00 230.27 0.00 -10.27 -4.67 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 319,680.67 296,432.02 0.00 23,248.65 7.27 180 Finance Department 10-180-501020 Salaries 622,105.16 588,621.91 0.00 33,483.25 5.38 10-180-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits) 4,362.72 4,362.72 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 47,924.80 44,031.56 0.00 3,893.24 8.12 10-180-502020 Group Health Insurance 74,853.57 71,551.07 0.00 3,302.50 4.41 10-180-502030 Retirement 92,071.56 83,629.93 0.00 8,441.63 9.17 10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00 10-180-502050 Life Insurance 1,212.25 934.40 0.00 277.85 22.92 10-180-502060 Long Term Disability 1,788.94 1,880.06 0.00 -91.12 -5.09 10-180-502070 Employee Assistance Prgm 307.77 285.64 0.00 22.13 7.19 E05 Personnel Services 845,157.87 795,828.39 0.00 49,329.48 5.84 10-180-511010 Advertising 1,000.00 533.18 0.00 466.82 46.68 10-180-511020 Postaee 9.500.00 8.538.20 0.00 961.80 10.12 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511021 Mail Machine Cost 2,500.00 2,319.11 0.00 180.89 7.24 10-180-512010 Printing 4,000.00 3,335.64 0.00 664.36 16.61 10-180-512020 Copies 2,500.00 1,300.65 0.00 1,199.35 47.97 10-180-512021 Copy Machine Cost 1,000.00 -797.21 35.10 1,762.11 176.21 10-180-513010 Office Supplies 4,000.00 6,569.26 0.00 -2,569.26 -64.23 10-180-517010 Operational Supplies 5,500.00 1,017.62 0.00 4,482.38 81.50 E10 Materials & Supplies 30,000.00 22,816.45 35.10 7,148.45 23.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 1,805.00 0.00 495.00 21.52 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 2,703.44 0.00 8,296.56 75.42 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 31,595.00 26,883.28 0.00 4,711.72 14.91 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 11.48 0.00 488.52 97.70 E15 Contractual Services 45,395.00 31,403.20 0.00 13,991.80 30.82 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,000.00 954.46 0.00 45.54 4.55 E25 Repairs & Maintenance 1,000.00 954.46 0.00 45.54 4.55 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 921,552.87 851,002.50 35.10 70,515.27 7.65 185 Non -Departmental 10-185-501020 Salaries 12,571.99 0.00 0.00 12,571.99 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 21,469.40 0.00 -21,469.40 0.00 10-185-502021 Self Insurance -Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 11,221.68 19,635.00 0.00 -8,413.32 -74.97 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 23,793.67 41,104.40 0.00 -17,310.73 -72.75 10-185-514010 Gas 12,000.00 8,013.70 0.00 3,986.30 33.22 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 & Supplies 12,000.00 8,013.70 0.00 3,986.30 33.22 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 315,582.72 285,403.10 0.00 30,179.62 9.56 10-185-521020 Insurance Deductible 15,000.00 22,476.52 0.00 -7,476.52 -49.84 10-185-521030 Self Ins Prop & Casualty 75,000.00 10,700.29 0.00 64,299.71 85.73 10-185-521060 Drugalcohol screening 5,364.00 2,057.25 0.00 3,306.75 61.65 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 1,181.25 67,538.79 0.00 -66,357.54 -5,617.57 10-185-522020 Professional Services 172,600.00 124,999.96 0.00 47,600.04 27.58 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 45,892.00 0.00 -142.00 -0.31 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 21,155.40 0.00 -14,155.40 -202.22 E15 Contractual Services 877,477.97 866,473.31 0.00 11,004.66 1.25 10-185-531010 Electricity 42,000.00 32,688.25 0.00 9,311.75 22.17 10-185-533010 Natural Gas 6,400.00 4,145.59 0.00 2,254.41 35.23 10-185-535010 Water 7,250.00 6,141.96 0.00 1,108.04 15.28 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 42,975.80 0.00 12,674.20 22.77 10-185-540010 Building & Grounds Maint. 65,040.00 36,928.41 19,900.00 8,211.59 12.63 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.79 0.00 383.21 18.25 E25 Repairs & Maintenance 92,140.00 63,645.20 19,900.00 8,594.80 9.33 10-185-550010 Miscellaneous 9,290.36 2,581.90 0.00 6,708.46 72.21 10-185-550015 Bad Debt Expense 0.00 2,403.00 0.00 -2,403.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'1 PositionsEquipment 20,754.89 12,625.38 0.00 8,129.51 39.17 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 9,665.00 2,925.00 0.00 6,740.00 69.74 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 2,041.54 0.00 -2,041.54 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 0.00 0.00 20,000.00 100.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 69,710.25 32,576.82 0.00 37,133.43 53.27 10-185-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/06/2017 - 10:05 AM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,130,771.89 1,054,789.23 19,900.00 56,082.66 4.96 190 I.T. Department 10-190-501020 Salaries 531,187.69 506,106.38 0.00 25,081.31 4.72 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 50.57 0.00 -50.57 0.00 10-190-502010 Social Security 40,727.66 36,820.62 0.00 3,907.04 9.59 10-190-502020 Group Health Insurance 75,335.92 71,319.84 0.00 4,016.08 5.33 10-190-502030 Retirement 78,793.38 62,810.27 0.00 15,983.11 20.28 10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00 10-190-502050 Life Insurance 1,026.20 767.60 0.00 258.60 25.20 10-190-502060 Long Term Disability 1,575.82 1,584.75 0.00 -8.93 -0.57 10-190-502070 Employee Assistance Prgm 248.84 231.00 0.00 17.84 7.17 E05 Personnel Services 730,452.62 680,048.14 0.00 50,404.48 6.90 10-190-511010 Advertising 1,646.00 1,632.40 0.00 13.60 0.83 10-190-511020 Postage 116.11 116.47 0.00 -0.36 -0.31 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 83.89 30.62 0.00 53.27 63.50 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 573.29 0.00 426.71 42.67 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 150.00 60.27 0.00 89.73 59.82 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 3,651.00 3,211.60 0.00 439.40 12.04 E10 Materials & Supplies 6,647.00 5,624.65 0.00 1,022.35 15.38 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 99.00 99.00 0.00 0.00 0.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 14,500.00 12,589.04 0.00 1,910.96 13.18 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 1,500.00 1,006.26 0.00 493.74 32.92 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet TI Web 15,154.00 15,058.30 0.00 95.70 0.63 10-190-522050 Service -remote Locations 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-545020 Citywide Wiringnetwork 300.00 164.01 0.00 135.99 45.33 10-190-522060 City Web Site 4,400.00 4,377.99 0.00 22.01 0.50 E15 Contractual Services 35,653.00 33,130.59 0.00 2,522.41 7.07 10-190-534010 Telephone E20 Utilities 52,200.00 47,561.03 52,200.00 47,561.03 0.00 4,638.97 0.00 4,638.97 8.89 8.89 10-190-545010 Software Licensemaint 130,000.00 128,021.47 0.00 1,978.53 1.52 10-190-545020 Citywide Wiringnetwork 300.00 164.01 0.00 135.99 45.33 10-190-547010 Equipment Maintenance 713.81 713.81 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 15,976.62 15,976.62 0.00 0.00 0.00 E25 Repairs & Maintenance 146,990.43 144,875.91 0.00 2,114.52 1.44 10-190-572020 Purchase Of Equipment 39,709.57 38,911.99 0.00 797.58 2.01 E70 Capital Purchases 39,709.57 38,911.99 0.00 797.58 2.01 190 I.T. Department 1,011,652.62 950,152.31 0.00 61,500.31 6.08 300 Police Department 1,000.00 1,205.71 0.00 -205.71 -20.57 10-300-501020 Salaries 4,263,295.67 4,124,634.69 0.00 138,660.98 3.25 10-300-501030 Holiday Pay 131,844.61 114,094.57 0.00 17,750.04 13.46 10-300-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits) 61,845.64 53,161.80 0.00 8,683.84 14.04 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 4,000.00 4,172.00 0.00 -172.00 -4.30 10-300-501090 Overtime 287,885.80 301,386.12 0.00 43,500.32 -4.69 10-300-501095 Overtime Straight Pay 7,000.00 12,370.86 0.00 -5,370.86 -76.73 10-300-502010 Social Security 355,601.71 334,800.96 0.00 20,800.75 5.85 10-300-502020 Group Health Insurance 757,648.99 712,853.58 0.00 44,795.41 5.91 10-300-502030 Retirement 829,580.25 800,361.05 0.00 29,219.20 3.52 10-300-502040 Workers Compensation 39,409.96 39,409.96 0.00 0.00 0.00 10-300-502050 Life Insurance 8,521.00 6,408.37 0.00 2,112.63 24.79 10-300-502060 Long Term Disability 12,725.99 13,239.37 0.00 -513.38 -4.03 10-300-502070 Employee Assistance Prgm 2,396.71 2,225.00 0.00 171.71 7.16 10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,764,356.33 6,519,118.33 0.00 245,238.00 3.63 10-300-511010 Advertising 1,026.00 2,315.70 0.00 -1,289.70 -125.70 10-300-511020 Postage 1,500.00 1,321.86 0.00 178.14 11.88 10-300-512010 Printing 5,500.00 6,394.91 0.00 -894.91 -16.27 10-300-512020 Copies 55.03 0.00 0.00 55.03 100.00 10-300-512030 Photographic Supplies 2,000.00 1,071.00 0.00 929.00 46.45 10-300-513010 Office Supplies 14,474.00 16,651.26 0.00 -2,177.26 -15.04 10-300-514010 Gas 140,000.00 123,918.15 0.00 16,081.85 11.49 10-300-514040 Food 700.00 773.36 0.00 -73.36 -10.48 10-300-515040 First Aid Supplies 1,000.00 1,205.71 0.00 -205.71 -20.57 10-300-516010 Ammunition & Firearms Supplies 26,300.00 25,265.68 9,180.00 -8,145.68 -30.97 10-300-516020 Dare Program 16,500.00 12,704.46 0.00 3,795.54 23.00 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-516040 Building & Grounds Maint. Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 12,000.00 Community Projects 10,346.62 10,556.47 0.00 -209.85 -2.03 10-300-517010 14,338.89 Operational Supplies 48,075.00 61,832.49 170.96 -13,928.45 -28.97 E10 0.00 Materials & Supplies 269,976.65 266,511.05 9,350.96 -5,885.36 -2.18 10-300-520030 0.00 Dues And Publications 4,220.00 4,759.79 0.00 -539.79 -12.79 10-300-520050 48.35 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 58,030.85 56,181.92 0.00 1,848.93 3.19 10-300-520080 10-300-546020 Tuition Reimbursement 9,180.00 11,882.00 0.00 -2,702.00 -29.43 10-300-520090 Equipment Maintenance Recruitment 1,400.00 1,557.17 0.00 -157.17 -11.23 10-300-521040 46,600.00 Medical Claimsservices 5,000.00 4,603.15 0.00 396.85 7.94 10-300-521050 7,992.12 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 -2,225.75 Professional Services 12,200.00 12,197.50 0.00 2.50 0.02 10-300-522026 29,402.76 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 0.00 Police Evidence Funds 0.00 55,292.03 0.00 -55,292.03 0.00 10-300-523010 10-300-572075 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 1,500.00 1,367.27 0.00 132.73 8.85 E15 Contractual Services 91,530.85 147,840.83 0.00 -56,309.98 -61.52 10-300-531010 Electricity 68,250.00 54,074.09 0.00 14,175.91 20.77 10-300-533010 Natural Gas 7,000.00 1,061.56 0.00 5,938.44 84.83 10-300-534010 Telephone 19,500.00 22,229.42 0.00 -2,729.42 -14.00 10-300-535010 Water 4,500.00 3,127.85 0.00 1,372.15 30.49 E20 Utilities 99,250.00 80,492.92 0.00 18,757.08 18.90 10-300-540010 Building & Grounds Maint. 40,000.00 31,649.54 70.00 8,280.46 20.70 10-300-541030 Vehicle Wash 12,000.00 9,455.42 0.00 2,544.58 21.20 10-300-544010 K-9 Operations 18,500.00 14,338.89 0.00 4,161.11 22.49 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 21,300.00 11,001.08 0.00 10,298.92 48.35 10-300-545010 Software Licensemaint 62,000.00 61,164.01 0.00 835.99 1.35 10-300-546010 Clothing Expense 46,300.00 54,849.80 -2,126.75 -6,423.05 -13.87 10-300-546020 Uniform Cleaning 25,000.00 18,057.15 0.00 6,942.85 27.77 10-300-547010 Equipment Maintenance 9,350.00 7,490.57 0.00 1,859.43 19.89 10-300-547020 Maintenance Agreements 46,600.00 48,040.45 -169.00 -1,271.45 -2.73 10-300-547030 Radio Maintenance 10,000.00 7,992.12 0.00 2,007.88 20.08 E25 Repairs & Maintenance 291,050.00 264,039.03 -2,225.75 29,236.72 10.05 10-300-572010 Purchase Of Vehicles 198,511.76 169,109.00 0.00 29,402.76 14.81 10-300-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 35,295.00 35,295.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 9,902.40 9,902.40 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 6,601.60 6,601.60 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software -morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software -prof Sery 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 250,310.76 220,908.00 0.00 29,402.76 11.75 300 Police Department 7,766,474.59 7,498,910.16 7,125.21 260,439.22 3.35 310 School Resource Officer 10-310-501020 Salaries 233,273.88 278,148.95 0.00 -44,875.07 -19.24 10-310-501030 Holiday Pay 8,866.04 4,818.93 0.00 4,047.11 45.65 10-310-501090 Overtime 17,126.00 36,872.81 0.00 -19,746.81 -115.30 10-310-501095 Overtime Straight Pay 410.00 105.82 0.00 304.18 74.19 10-310-502010 Social Security 19,865.21 22,949.38 0.00 -3,084.17 -15.53 10-310-502020 Group Health Insurance 61,286.66 53,231.75 0.00 8,054.91 13.14 10-310-502030 Retirement 47,780.37 56,864.92 0.00 -9,084.55 -19.01 10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00 10-310-502050 Life Insurance 473.93 426.04 0.00 47.89 10.10 10-310-502060 Long Term Disability 714.82 894.61 0.00 -179.79 -25.15 10-310-502070 Employee Assistance Prgm 130.97 121.60 0.00 9.37 7.15 E05 Personnel Services 392,466.70 456,973.63 0.00 -64,506.93 -16.44 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 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 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 392,466.70 456,973.63 0.00 -64,506.93 -16.44 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 93,718.69 89,197.72 0.00 4,520.97 4.82 10-320-501030 Holiday Pay 2,364.09 337.87 0.00 2,026.22 85.71 10-320-501090 Overtime 24,650.00 24,448.96 0.00 201.04 0.82 10-320-501095 Overtime Straight Pay 1,000.00 594.20 0.00 405.80 40.58 10-320-502010 Social Security 7,691.06 8,280.19 0.00 -589.13 -7.66 10-320-502020 Group Health Insurance 19,569.70 18,278.03 0.00 1,291.67 6.60 10-320-502030 Retirement 18,498.75 20,847.02 0.00 -2,348.27 -12.69 10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00 10-320-502050 Life Insurance 180.17 136.71 0.00 43.46 24.12 10-320-502060 Long Term Disability 271.24 285.67 0.00 -14.43 -5.32 10-320-502070 Employee Assistance Prgm 52.39 48.64 0.00 3.75 7.16 E05 Personnel Services 169,014.55 163,473.47 0.00 5,541.08 3.28 10-320-514010 Gas 5,000.00 5,327.25 0.00 -327.25 -6.55 10-320-516040 Investigations 14,350.00 12,088.88 0.00 2,261.12 15.76 10-320-517010 Operational Supplies 7,750.31 1,965.98 0.00 5,784.33 74.63 E10 Materials & Supplies 27,100.31 19,382.11 0.00 7,718.20 28.48 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 18,269.11 13,000.00 0.00 5,269.11 28.84 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,269.11 13,000.00 0.00 5,269.11 28.84 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 214,383.97 195,855.58 0.00 18,528.39 8.64 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 330 Animal Control 10-330-501020 Salaries 328,493.12 321,081.49 0.00 7,411.63 2.26 10-330-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,308.00 4,194.50 0.00 113.50 2.63 10-330-501090 Overtime 1,709.00 1,896.28 0.00 -187.28 -10.96 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,628.27 23,834.55 0.00 1,793.72 7.00 10-330-502020 Group Health Insurance 57,912.97 62,287.82 0.00 -4,374.85 -7.55 10-330-502030 Retirement 49,581.50 47,975.20 0.00 1,606.30 3.24 10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00 10-330-502050 Life Insurance 640.40 510.07 0.00 130.33 20.35 10-330-502060 Long Term Disability 1,003.75 1,061.44 0.00 -57.69 -5.75 10-330-502070 Employee Assistance Prgm 209.55 194.52 0.00 15.03 7.17 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 472,481.33 465,530.64 0.00 6,950.69 1.47 10-330-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-330-511020 Postage 100.00 111.85 0.00 -11.85 -11.85 10-330-512010 Printing 1,570.00 1,710.65 0.00 -140.65 -8.96 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 400.00 571.01 0.00 -171.01 -42.75 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 250.52 0.00 -10.52 -4.38 10-330-515040 First Aid Supplies 700.00 386.67 0.00 313.33 44.76 10-330-517010 Operational Supplies 9,700.00 12,497.70 0.00 -2,797.70 -28.84 E10 Materials & Supplies 12,710.00 15,528.40 0.00 -2,818.40 -22.17 10-330-520030 Dues And Publications 1,390.00 1,388.03 0.00 1.97 0.14 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 1,288.31 0.00 661.69 33.93 10-330-521040 Medical Claimsservices 564.00 505.00 0.00 59.00 10.46 10-330-522020 Professional Services 2,715.00 14,387.95 0.00 -11,672.95 -429.94 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 7,700.00 10,457.38 0.00 -2,757.38 -35.81 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 14,890.46 14,890.46 0.00 0.00 0.00 E15 Contractual Services 29,209.46 42,917.13 0.00 -13,707.67 -46.93 10-330-531010 Electricity 18,700.00 19,783.61 0.00 -1,083.61 -5.79 10-330-533010 Natural Gas 15,800.00 16,907.40 0.00 -1,107.40 -7.01 10-330-534010 Telephone 300.00 143.84 0.00 156.16 52.05 10-330-535010 Water 4,000.00 2,934.70 0.00 1,065.30 26.63 E20 Utilities 38,800.00 39,769.55 0.00 -969.55 -2.50 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-540010 Building & Grounds Maint. 13,390.00 22,452.00 0.00 -9,062.00 -67.68 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 545.00 0.00 -5.00 -0.93 10-330-544040 Care Of Animals 41,000.00 57,121.90 0.00 -16,121.90 -39.32 10-330-544050 Animal Food 5,000.00 5,610.99 0.00 -610.99 -12.22 10-330-545010 Software Licensemaint 2,350.00 2,287.56 0.00 62.44 2.66 10-330-546010 Clothing Expense 1,800.00 2,386.89 0.00 -586.89 -32.61 10-330-546020 Uniform Cleaning 200.00 195.13 0.00 4.87 2.44 10-330-547010 Equipment Maintenance 1,000.00 1,024.91 0.00 -24.91 -2.49 10-330-547020 Maintenance Agreements 69.00 69.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 61.00 53.55 0.00 7.45 12.21 E25 Repairs & Maintenance 65,410.00 91,746.93 0.00 -26,336.93 -40.26 10-330-572010 Purchase of Vehicles 28,251.96 24,982.40 0.00 3,269.56 11.57 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,251.96 24,982.40 0.00 3,269.56 1 l .57 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 646,862.75 680,475.05 0.00 -33,612.30 -5.20 390 9-1-1 Police 10-390-501020 Salaries 860,459.47 812,326.67 0.00 48,132.80 5.59 10-390-501030 Holiday Pay 29,479.22 27,701.65 0.00 1,777.57 6.03 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 15,252.95 0.00 561.05 3.55 10-390-501095 Overtime Straight Pay 500.00 78.70 0.00 421.30 84.26 10-390-502010 Social Security 69,527.23 62,319.64 0.00 7,207.59 10.37 10-390-502020 Group Health Insurance 169,048.38 143,574.64 0.00 25,473.74 15.07 10-390-502030 Retirement 135,322.10 122,282.81 0.00 13,039.29 9.64 10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00 10-390-502050 Life Insurance 1,737.10 1,256.66 0.00 480.44 27.66 10-390-502060 Long Term Disability 2,637.44 2,608.44 0.00 29.00 1.10 10-390-502070 Employee Assistance Prgm 556.61 516.72 0.00 39.89 7.17 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,288,162.68 1,188,400.01 0.00 99,762.67 7.74 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 1,399.02 0.00 3,600.98 72.02 E10 Materials & Supplies 5,100.00 1,399.02 0.00 3,700.98 72.57 10-390-520030 Dues And Publications 480.00 496.00 0.00 -16.00 -3.33 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,000.00 2,612.27 0.00 2,387.73 47.75 10-390-522020 Professional Services 1,320.00 1,994.48 -680.00 5.52 0.42 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-523010 E15 Equipment Rentlease Contractual Services 98,000.00 104,800.00 94,098.11 99,200.86 0.00 -680.00 3,901.89 6,279.14 3.98 5.99 10-390-534010 Telephone E20 Utilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10-390-545010 Advertising Software Licensemaint 23,000.00 23,000.00 0.00 0.00 0.00 10-390-546010 200.00 Clothing Expense 6,000.00 3,192.26 0.00 2,807.74 46.80 10-390-546020 669.00 Uniform Cleaning 1,400.00 2,931.00 0.00 -1,531.00 -109.36 10-390-547010 0.00 Equipment Maintenance 2,600.00 337.50 0.00 2,262.50 87.02 10-390-547020 0.00 Maintenance Agreements 42,000.00 41,278.91 144.29 576.80 1.37 10-390-547030 2.86 Radio Maintenance 5,000.00 4,742.36 0.00 257.64 5.15 E25 10-400-514020 Repairs & Maintenance 80,000.00 75,482.03 144.29 4,373.68 5.47 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Food Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 1,577.00 9-1-1 Police 1,478,062.68 1,364,481.92 -535.71 114,116.47 7.72 400 9,882.28 Fire Department 117.72 1.18 E10 Materials & Supplies 63,238.70 10-400-501020 0.00 Salaries 3,783,411.71 3,565,298.99 0.00 218,112.72 5.76 10-400-501030 Holiday Pay 269,704.05 269,698.57 0.00 5.48 0.00 10-400-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 34,500.00 33,960.00 0.00 540.00 1.57 10-400-501090 Overtime 40,000.00 29,687.59 0.00 10,312.41 25.78 10-400-501095 Overtime Straight Pay 28,930.00 20,623.65 0.00 8,306.35 28.71 10-400-502010 Social Security 69,436.89 56,312.15 0.00 13,124.74 18.90 10-400-502020 Group Health Insurance 644,562.45 615,561.74 0.00 29,000.71 4.50 10-400-502030 Retirement 1,822,395.71 1,687,467.70 0.00 134,928.01 7.40 10-400-502040 Workers Compensation 79,145.55 79,145.55 0.00 0.00 0.00 10-400-502050 Life Insurance 7,794.43 5,467.93 0.00 2,326.50 29.85 10-400-502060 Long Term Disability 11,342.56 11,295.17 0.00 47.39 0.42 10-400-502070 Employee Assistance Prgm 1,990.71 1,848.08 0.00 142.63 7.16 10-400-503010 Awards Program 830.00 817.07 0.00 12.93 1.56 E05 Personnel Services 6,794,044.06 6,377,184.19 0.00 416,859.87 6.14 10-400-511010 Advertising 875.70 875.70 0.00 0.00 0.00 10-400-511020 Postage 200.00 165.19 0.00 34.81 17.41 10-400-512010 Printing 1,036.00 669.00 0.00 367.00 35.42 10-400-512020 Copies 50.00 0.35 0.00 49.65 99.30 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,300.00 1,262.84 0.00 37.16 2.86 10-400-514010 Gas 41,000.00 35,574.35 0.00 5,425.65 13.23 10-400-514020 Chemicals 1,500.00 1,195.00 0.00 305.00 20.33 10-400-514030 Small Tools 5,700.00 5,655.53 0.00 44.47 0.78 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 1,577.00 1,576.13 0.00 0.87 0.06 10-400-517010 Operational Supplies 10,000.00 9,882.28 0.00 117.72 1.18 E10 Materials & Supplies 63,238.70 56,856.37 0.00 6,382.33 10.09 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520030 Dues And Publications 2,577.00 2,576.80 0.00 0.20 0.01 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 24,000.00 24,244.15 0.00 -244.15 -1.02 10-400-520080 Tuition Reimbursement 5,670.00 5,040.00 0.00 630.00 11.11 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 37,045.48 37,045.48 0.00 0.00 0.00 10-400-522020 Professional Services 2,840.85 2,840.85 0.00 0.00 0.00 10-400-523010 Equipment Rentlease 458.63 85.49 0.00 373.14 81.36 10-400-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-400-529010 Special Events 5,541.37 8,857.53 0.00 -3,316.16 -59.84 10-400-529040 Child Pass Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 80,633.33 81,470.30 0.00 -836.97 -1.04 10-400-531010 Electricity 32,000.00 32,268.16 0.00 -268.16 -0.84 10-400-533010 Natural Gas 13,425.00 12,580.94 0.00 844.06 6.29 10-400-534010 Telephone 23,075.00 20,614.71 0.00 2,460.29 10.66 10-400-535010 Water 18,500.00 18,431.55 0.00 68.45 0.37 E20 Utilities 87,000.00 83,895.36 0.00 3,104.64 3.57 10-400-540010 Building & Grounds Maint. 203,738.00 96,456.00 124,185.38 -16,903.38 -8.30 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 46,100.00 44,623.04 -4,096.04 5,573.00 12.09 10-400-546020 Uniform Cleaning 500.00 258.25 0.00 241.75 48.35 10-400-547010 Equipment Maintenance 16,704.30 18,321.68 0.00 -1,617.38 -9.68 10-400-547020 Maintenance Agreements 28,500.00 28,286.37 -15,886.97 16,100.60 56.49 10-400-547030 Radio Maintenance 9,500.00 8,963.06 0.00 536.94 5.65 E25 Repairs & Maintenance 305,042.30 196,908.40 104,202.37 3,931.53 1.29 10-400-572010 Purchase Of Vehicles 90,888.67 90,473.07 0.00 415.60 0.46 10-400-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 7,650.00 7,645.85 0.00 4.15 0.05 10-400-572021 Purchase of Equipment -ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 274,461.00 201,480.97 54,866.43 18,113.60 6.60 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 1,163,313.93 1,163,313.93 0.00 0.00 0.00 E70 Capital Purchases 1,536,313.60 1,462,913.82 54,866.43 18,533.35 1.21 400 Fire Department 8,866,271.99 8,259,228.44 159,068.80 447,974.75 5.05 401 Fire Museum 10-401-531010 Electricity 619.06 935.32 0.00 -316.26 -51.09 10-401-533010 Natural Gas 324.39 412.85 0.00 -88.46 -27.27 10-401-535010 Water 306.55 405.39 0.00 -98.84 -32.24 E20 Utilities 1,250.00 1,753.56 0.00 -503.56 -40.28 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 1,250.00 1,753.56 0.00 -503.56 -40.28 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 -291.18 0.00 291.18 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 -291.18 0.00 291.18 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 -291.18 0.00 291.18 0.00 520 Plan & Protect Svcs -Admin 10-520-501020 Salaries 233,118.82 219,280.74 0.00 13,838.08 5.94 10-520-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 17,188.14 16,452.26 0.00 735.88 4.28 10-520-502020 Group Health Insurance 31,191.13 24,904.39 0.00 6,286.74 20.16 10-520-502030 Retirement 32,020.81 28,093.77 0.00 3,927.04 12.26 10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00 10-520-502050 Life Insurance 419.10 271.83 0.00 147.27 35.14 10-520-502060 Long Term Disability 607.35 551.11 0.00 56.24 9.26 10-520-502070 Employee Assistance Prgm 104.77 97.28 0.00 7.49 7.15 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 314,773.47 289,774.73 0.00 24,998.74 7.94 10-520-511010 Advertising 5,474.42 5,474.42 0.00 0.00 0.00 10-520-511020 Postage 200.00 25.48 0.00 174.52 87.26 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 1,056.83 1,062.89 0.00 -6.06 -0.57 10-520-514010 Gas 9,000.00 7,359.26 0.00 1,640.74 18.23 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 2,708.40 2,708.40 0.00 0.00 0.00 E10 Materials & Supplies 18,439.65 16,630.45 0.00 1,809.20 9.81 10-520-520030 Dues And Publications 368.39 150.88 0.00 217.51 59.04 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,269.70 728.20 0.00 541.50 42.65 10-520-522020 Professional Services 1,638.30 1,385.15 0.00 253.15 15.45 E15 Contractual Services 3,276.39 2,264.23 0.00 1,012.16 30.89 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,419.45 898.09 56.16 465.20 32.77 E25 Repairs & Maintenance 1,419.45 898.09 56.16 465.20 32.77 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 337,908.96 309,567.50 56.16 28,285.30 8.37 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 62,688.54 61,107.34 0.00 1,581.20 2.52 10-521-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits) 13,890.11 11,658.33 0.00 2,231.78 16.07 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-547020 Maintenance Agreements 1,662.58 1,455.78 87.75 119.05 7.16 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 5,702.12 5,442.70 0.00 259.42 4.55 10-521-502020 Group Health Insurance 10,090.77 9,716.13 0.00 374.64 3.71 10-521-502030 Retirement 9,277.93 9,043.90 0.00 234.03 2.52 10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00 10-521-502050 Life Insurance 99.27 94.78 0.00 4.49 4.52 10-521-502060 Long Term Disability 202.07 197.23 0.00 4.84 2.40 10-521-502070 Employee Assistance Prgm 26.19 24.32 0.00 1.87 7.14 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 102,017.27 97,325.00 0.00 4,692.27 4.60 10-521-511010 Advertising 5,000.00 4,879.25 0.00 120.75 2.42 10-521-511020 Postage 1,000.00 577.15 0.00 422.85 42.29 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 19.08 19.08 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 687.59 0.00 312.41 31.24 10-521-514040 Food 174.88 174.88 0.00 0.00 0.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,916.04 1,238.47 0.00 677.57 35.36 E10 Materials & Supplies 9,110.00 7,576.42 0.00 1,533.58 16.83 10-521-520030 Dues And Publications 15,500.00 13,897.70 0.00 1,602.30 10.34 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,126.13 0.00 0.00 1,126.13 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 16,626.13 13,897.70 0.00 2,728.43 16.41 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,662.58 1,455.78 87.75 119.05 7.16 E25 Repairs & Maintenance 1,662.58 1,455.78 87.75 119.05 7.16 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 129,415.98 120,254.90 87.75 9,073.33 7.01 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 114,947.75 102,872.20 0.00 12,075.55 10.51 10-522-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 11,592.06 7,846.43 0.00 3,745.63 32.31 10-522-502020 GrouD Health Insurance 18.872.81 13.018.59 0.00 5.854.22 31.02 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 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-502030 Retirement 24,116.63 15,225.09 0.00 8,891.54 36.87 10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00 10-522-502050 Life Insurance 317.26 164.22 0.00 153.04 48.24 10-522-502060 Long Term Disability 496.94 338.23 0.00 158.71 31.94 10-522-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15 E05 Personnel Services 170,485.40 139,601.09 0.00 30,884.31 18.12 10-522-511010 Advertising 2,101.00 1,293.50 0.00 807.50 38.43 10-522-511020 Postage 400.00 234.57 0.00 165.43 41.36 10-522-512010 Printing 125.00 38.00 0.00 87.00 69.60 10-522-512020 Copies 50.00 2.74 0.00 47.26 94.52 10-522-513010 Office Supplies 1,000.00 788.71 0.00 211.29 21.13 10-522-514040 Food 250.00 194.18 0.00 55.82 22.33 10-522-517010 Operational Supplies 1,245.00 314.32 0.00 930.68 74.75 E10 Materials & Supplies 5,171.00 2,866.02 0.00 2,304.98 44.58 10-522-520030 Dues And Publications 1,305.00 1,305.00 0.00 0.00 0.00 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 9,576.64 4,903.48 0.00 4,673.16 48.80 10-522-522020 Professional Services 235,000.00 68,330.86 6,669.14 160,000.00 68.09 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 245,881.64 74,539.34 6,669.14 164,673.16 66.97 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 750.00 643.80 108.81 -2.61 -0.35 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 750.00 643.80 108.81 -2.61 -0.35 10-522-572020 Purchase Of Equipment 2,774.00 2,774.00 0.00 0.00 0.00 E70 Capital Purchases 2,774.00 2,774.00 0.00 0.00 0.00 522 Plan & Protect Svcs -MPO 425,062.04 220,424.25 6,777.95 197,859.84 46.55 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 104,707.80 76,580.22 0.00 28,127.58 26.86 10-530-501050 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 8,010.14 5,300.70 0.00 2,709.44 33.83 10-530-502020 Group Health Insurance 16,238.38 11,995.03 0.00 4,243.35 26.13 10-530-502030 Retirement 15,496.76 11,333.84 0.00 4,162.92 26.86 10-530-502040 Workers Compensation 28.02 0.00 0.00 28.02 100.00 10-530-502050 Life Insurance 205.63 118.59 0.00 87.04 42.33 10-530-502060 Long Term Disability 307.40 247.81 0.00 59.59 19.39 10-530-502070 Employee Assistance Prgm 65.48 60.80 0.00 4.68 7.15 E05 Personnel Services 145.059.61 105.636.99 0.00 39.422.62 27.18 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-511010 Advertising 495.05 495.05 0.00 0.00 0.00 10-530-511020 Postage 100.00 94.03 0.00 5.97 5.97 10-530-512010 Printing 43.99 40.00 0.00 3.99 9.07 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 309.58 309.58 0.00 0.00 0.00 10-530-517010 Operational Supplies 408.70 408.70 0.00 0.00 0.00 E10 Materials & Supplies 1,357.32 1,347.36 0.00 9.96 0.73 10-530-520030 Dues And Publications 270.00 296.25 0.00 -26.25 -9.72 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 750.52 773.02 0.00 -22.50 -3.00 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 20,401.82 14,402.22 4,397.78 1,601.82 7.85 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 1,670.84 1,670.84 0.00 0.00 0.00 10-530-524029 Recycling Education 9,947.89 5,513.68 0.00 4,434.21 44.57 10-530-528085 Fair Housing Assistance Prog 238.00 238.00 0.00 0.00 0.00 E15 Contractual Services 33,279.07 22,894.01 4,397.78 5,987.28 17.99 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 350.00 64.95 73.71 211.34 60.38 E25 Repairs & Maintenance 350.00 64.95 73.71 211.34 60.38 10-530-550020 NRA -Residential 55,000.00 52,908.47 0.00 2,091.53 3.80 10-530-550030 NRA -Commercial Facade 17,000.00 16,715.32 0.00 284.68 1.67 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA -Rental Facade 33,066.00 5,060.00 0.00 28,006.00 84.70 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 247.84 247.84 0.00 0.00 0.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 62,411.54 14,492.81 0.00 47,918.73 76.78 10-530-550055 HERO 48,480.00 44,500.00 0.00 3,980.00 8.21 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 216,205.38 133,924.44 0.00 82,280.94 38.06 530 Plan & Protect Svc-RedevGrant 396,251.38 263,867.75 4,471.49 127,912.14 32.28 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 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 66.00 0.00 -66.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 66.00 0.00 -66.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs -Build Reg 0.00 66.00 0.00 -66.00 0.00 532 Plan & Protect Svcs -Env Health 10-532-501020 Salaries 170.870.89 164.100.50 0.00 6.770.39 3.96 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-501050 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 46.42 0.00 0.00 46.42 100.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 11,992.31 11,492.70 0.00 499.61 4.17 10-532-502020 Group Health Insurance 30,174.42 28,914.14 0.00 1,260.28 4.18 10-532-502030 Retirement 25,289.03 24,287.00 0.00 1,002.03 3.96 10-532-502040 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00 10-532-502050 Life Insurance 276.14 259.16 0.00 16.98 6.15 10-532-502060 Long Term Disability 562.05 538.68 0.00 23.37 4.16 10-532-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 241,069.07 231,444.37 0.00 9,624.70 3.99 10-532-511010 Advertising 102.82 90.00 0.00 12.82 12.47 10-532-511020 Postage 200.00 173.29 0.00 26.71 13.36 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,497.18 1,681.57 0.00 -184.39 -12.32 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,229.00 1,209.65 0.00 19.35 1.57 E10 Materials & Supplies 3,164.00 3,154.51 0.00 9.49 0.30 10-532-520030 Dues And Publications 1,000.00 990.00 0.00 10.00 1.00 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 695.00 0.00 305.00 30.50 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 1,474.00 1,474.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 221,000.00 221,000.04 0.00 -0.04 0.00 10-532-529010 Special Events 700.00 0.00 0.00 700.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 225,174.00 224,159.04 0.00 1,014.96 0.45 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 30,000.00 26,696.88 2,365.00 938.12 3.13 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-546010 Clothing Expense 1,631.00 763.00 0.00 868.00 53.22 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 800.00 606.87 0.00 193.13 24.14 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 33,801.00 29,350.75 2,365.00 2,085.25 6.17 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 503,208.07 488,108.67 2,365.00 12,734.40 2.53 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 154,167.75 149,447.00 0.00 4,720.75 3.06 10-533-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-533-501060 Seasonal Salaries 15,709.44 12,813.30 0.00 2,896.14 18.44 10-533-501090 Overtime 72.72 0.00 0.00 72.72 100.00 10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00 10-533-502010 Social Security 13,680.89 11,587.46 0.00 2,093.43 15.30 10-533-502020 Group Health Insurance 23,944.06 23,013.28 0.00 930.78 3.89 10-533-502030 Retirement 21,141.08 16,085.09 0.00 5,055.99 23.92 10-533-502040 Workers Compensation 1,874.09 0.00 0.00 1,874.09 100.00 10-533-502050 Life Insurance 241.76 201.55 0.00 40.21 16.63 10-533-502060 Long Term Disability 469.14 450.48 0.00 18.66 3.98 10-533-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15 E05 Personnel Services 231,639.51 213,671.12 0.00 17,968.39 7.76 10-533-511010 Advertising 106.23 106.23 0.00 0.00 0.00 10-533-511020 Postage 1,586.69 1,745.07 0.00 -158.38 -9.98 10-533-512010 Printing 254.00 254.00 0.00 0.00 0.00 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,097.18 1,087.33 0.00 9.85 0.90 10-533-514030 Small Tools 119.91 119.91 0.00 0.00 0.00 10-533-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-533-517010 Operational Supplies 4,370.52 2,472.27 0.00 1,898.25 43.43 E10 Materials & Supplies 7,534.53 5,784.81 0.00 1,749.72 23.22 10-533-520030 Dues And Publications 314.98 314.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,066.00 997.00 0.00 69.00 6.47 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 55,107.49 53,690.00 0.00 1,417.49 2.57 10-533-522022 Demo 23,500.00 23,500.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,988.47 78,501.98 0.00 1,486.49 1.86 10-533-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,235.00 1,235.00 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 750.00 591.91 14.04 144.05 19.21 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,285.00 2,096.91 14.04 174.05 7.62 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 533 PPS - Prop MaintCode Enforce 321,447.51 300,054.82 14.04 21,378.65 6.65 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 241,926.10 231,536.54 0.00 10,389.56 4.29 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 70.00 0.00 0.00 70.00 100.00 10-534-501095 Overtime Straight Pay 12.00 0.00 0.00 12.00 100.00 10-534-502010 Social Security 16,937.83 16,242.39 0.00 695.44 4.11 10-534-502020 Group Health Insurance 50,309.21 47,996.52 0.00 2,312.69 4.60 10-534-502030 Retirement 35,795.72 34,267.51 0.00 1,528.21 4.27 10-534-502040 Workers Compensation 12.43 0.00 0.00 12.43 100.00 10-534-502050 Life Insurance 402.85 363.48 0.00 39.37 9.77 10-534-502060 Long Term Disability 796.31 760.37 0.00 35.94 4.51 10-534-502070 Employee Assistance Prgm 104.77 97.28 0.00 7.49 7.15 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 346,367.22 331,264.09 0.00 15,103.13 4.36 10-534-511010 Advertising 188.80 188.80 0.00 0.00 0.00 10-534-511020 Postage 1,000.00 1,132.96 0.00 -132.96 -13.30 10-534-512010 Printing 136.75 0.00 0.00 136.75 100.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 680.97 662.97 0.00 18.00 2.64 10-534-514030 Small Tools 69.86 39.88 0.00 29.98 42.91 10-534-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-534-517010 Operational Supplies 1,220.09 1,220.09 0.00 0.00 0.00 E10 Materials & Supplies 3,311.47 3,244.70 0.00 66.77 2.02 10-534-520030 Dues And Publications 5,353.78 3,270.66 0.00 2,083.12 38.91 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 7,319.40 6,093.22 0.00 1,226.18 16.75 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 Eauinment Rentlease 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-546010 Clothing Expense 1,330.98 1,330.98 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 12,673.18 9,363.88 0.00 3,309.30 26.11 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,330.98 1,330.98 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 983.57 835.78 0.00 147.79 15.03 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,604.55 2,436.76 0.00 167.79 6.44 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 364,956.42 346,309.43 0.00 18,646.99 5.11 535 Public Works -Central Maintenan 10-535-501020 Salaries 327,152.00 319,551.71 0.00 7,600.29 2.32 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 4,188.00 0.00 3,212.00 43.41 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 8,895.22 0.00 -4,395.22 -97.67 10-535-501095 Overtime Straight Pay 500.00 634.79 0.00 -134.79 -26.96 10-535-502010 Social Security 25,975.72 24,365.75 0.00 1,609.97 6.20 10-535-502020 Group Health Insurance 58,302.46 62,605.63 0.00 -4,303.17 -7.38 10-535-502030 Retirement 49,158.50 48,704.14 0.00 454.36 0.92 10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00 10-535-502050 Life Insurance 630.60 499.71 0.00 130.89 20.76 10-535-502060 Long Term Disability 989.73 1,041.54 0.00 -51.81 -5.23 10-535-502070 Employee Assistance Prgm 183.36 170.24 0.00 13.12 7.16 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 477,052.92 472,917.28 0.00 4,135.64 0.87 10-535-511010 Advertising 80.00 43.75 0.00 36.25 45.31 10-535-511020 Postage 50.00 6.73 0.00 43.27 86.54 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 2,357.78 2,357.78 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,770.50 6,326.40 0.00 1,444.10 18.58 10-535-517010 Operational Supplies 6,330.63 6,148.54 0.00 182.09 2.88 E10 Materials & Supplies 16,598.91 14,883.20 0.00 1,715.71 10.34 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,041.09 2,041.09 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,541.09 2,541.09 0.00 0.00 0.00 10-535-531010 Electricity 7,560.00 7,183.82 0.00 376.18 4.98 10-535-533010 Natural Gas 6,942.89 5,758.14 0.00 1,184.75 17.06 10-535-534010 Telephone 220.00 199.20 0.00 20.80 9.45 10-535-535010 Water 1,400.00 1,327.93 0.00 72.07 5.15 E20 Utilities 16,122.89 14,469.09 0.00 1,653.80 10.26 10-535-540010 Building & Grounds Maint. 15,000.00 18,638.11 60.00 -3,698.11 -24.65 10-535-541010 Veh & Equip Parts Etc 535,000.00 588,634.52 0.00 -53,634.52 -10.03 10-535-546010 Clothing Expense 5,500.00 5,842.15 -4,544.80 4,202.65 76.41 10-535-547010 Equipment Maintenance 2,408.00 1,837.23 0.00 570.77 23.70 10-535-547020 Maintenance Agreements 9,349.11 9,349.11 0.00 0.00 0.00 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 567,357.11 624,301.12 -4,484.80 -52,459.21 -9.25 10-535-572020 Purchase Of Equipment 17,500.00 16,515.00 0.00 985.00 5.63 E70 Capital Purchases 17,500.00 16,515.00 0.00 985.00 5.63 535 Public Works -Central Maintenan 1,097,172.92 1,145,626.78 -4,484.80 -43,969.06 -4.01 540 Public Works -Admin 10-540-501020 Salaries 204,518.14 199,719.15 0.00 4,798.99 2.35 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 15,645.64 14,216.61 0.00 1,429.03 9.13 10-540-502020 Group Health Insurance 34,432.33 28,709.21 0.00 5,723.12 16.62 10-540-502030 Retirement 30,268.68 29,558.39 0.00 710.29 2.35 10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00 10-540-502050 Life Insurance 397.56 314.91 0.00 82.65 20.79 10-540-502060 Long Term Disability 530.48 554.29 0.00 -23.81 -4.49 10-540-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15 E05 Personnel Services 285,986.68 273,260.79 0.00 12,725.89 4.45 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 12.11 0.00 187.89 93.95 10-540-512010 Printing 87.60 0.00 0.00 87.60 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 250.00 0.00 0.00 250.00 100.00 10-540-514010 Gas 61,000.00 53,257.14 0.00 7,742.86 12.69 10-540-514040 Food 1,091.83 1,091.83 0.00 0.00 0.00 10-540-517010 Operational Supplies 650.00 6.50 0.00 643.50 99.00 E10 Materials & Supplies 63,379.43 54,367.58 0.00 9,011.85 14.22 10-540-520030 Dues And Publications 791.25 791.25 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 Trainine And Education 4.165.57 4.124.59 0.00 40.98 0.98 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-522020 Professional Services 163.75 0.00 0.00 163.75 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,120.57 4,915.84 0.00 204.73 4.00 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 450.00 269.54 0.00 180.46 40.10 E25 Repairs & Maintenance 450.00 269.54 0.00 180.46 40.10 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 354,936.68 332,813.75 0.00 22,122.93 6.23 541 Public Works -Engineering 10-541-501020 Salaries 758,049.97 725,689.69 0.00 32,360.28 4.27 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 664.86 664.86 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 88.63 0.00 0.00 88.63 100.00 10-541-502010 Social Security 58,052.02 51,855.96 0.00 6,196.06 10.67 10-541-502020 Group Health Insurance 120,839.39 120,481.97 0.00 357.42 0.30 10-541-502030 Retirement 112,309.80 99,158.40 0.00 13,151.40 11.71 10-541-502040 Workers Compensation 3,639.97 3,639.97 0.00 0.00 0.00 10-541-502050 Life Insurance 1,474.68 1,131.23 0.00 343.45 23.29 10-541-502060 Long Term Disability 2,348.30 2,348.30 0.00 0.00 0.00 10-541-502070 Employee Assistance Prgm 314.32 291.80 0.00 22.52 7.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,057,781.94 1,005,262.18 0.00 52,519.76 4.97 10-541-511010 Advertising 621.19 514.00 0.00 107.19 17.26 10-541-511020 Postage 400.00 293.47 0.00 106.53 26.63 10-541-512010 Printing 100.00 38.00 0.00 62.00 62.00 10-541-512020 Copies 75.00 3.47 0.00 71.53 95.37 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 6,028.25 6,028.25 0.00 0.00 0.00 10-541-514030 Small Tools 133.21 0.00 0.00 133.21 100.00 10-541-514040 Food 286.95 286.95 0.00 0.00 0.00 10-541-515040 First Aid Supplies 50.00 10.18 0.00 39.82 79.64 10-541-515070 Const & Inspect Supplies 1,771.75 491.67 0.00 1,280.08 72.25 10-541-515080 Surveying Supplies 2,000.00 909.41 0.00 1,090.59 54.53 10-541-517010 Operational Supplies 1,677.88 1,677.88 0.00 0.00 0.00 E10 Materials & Supplies 13,144.23 10,253.28 0.00 2,890.95 21.99 10-541-520030 Dues And Publications 4,541.60 4,604.60 0.00 -63.00 -1.39 10-541-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/06/2017 - 10:05 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-520070 Training And Education 3,088.01 3,238.01 0.00 -150.00 -4.86 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 3,151.16 820.00 0.00 2,331.16 73.98 10-541-522055 Stormwater Compliance 1,500.00 73.08 0.00 1,426.92 95.13 E15 Contractual Services 12,280.77 8,735.69 0.00 3,545.08 28.87 10-541-534010 Telephone 500.00 420.95 0.00 79.05 15.81 E20 Utilities 500.00 420.95 0.00 79.05 15.81 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,000.00 879.41 0.00 120.59 12.06 10-541-547010 Equipment Maintenance 1,500.00 614.20 0.00 885.80 59.05 10-541-547020 Maintenance Agreements 12,400.00 8,711.63 7.02 3,681.35 29.69 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,900.00 11,165.24 7.02 4,727.74 29.73 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works -Engineering 1,099,606.94 1,035,837.34 7.02 63,762.58 5.80 542 Public Works -Street 10-542-501020 Salaries 1,110,951.68 1,103,575.47 0.00 7,376.21 0.66 10-542-501060 Seasonal Salaries 18,000.00 13,198.63 0.00 4,801.37 26.67 10-542-501070 Stand-by Plan 5,000.00 4,332.00 0.00 668.00 13.36 10-542-501090 Overtime 34,488.40 28,795.02 0.00 5,693.38 16.51 10-542-501095 Overtime Straight Pay 1,011.60 1,011.60 0.00 0.00 0.00 10-542-502010 Social Security 89,463.05 85,283.97 0.00 4,179.08 4.67 10-542-502020 Group Health Insurance 189,300.56 183,416.19 0.00 5,884.37 3.11 10-542-502030 Retirement 170,414.84 151,889.63 0.00 18,525.21 10.87 10-542-502040 Workers Compensation 18,752.09 18,752.09 0.00 0.00 0.00 10-542-502050 Life Insurance 2,157.00 1,675.70 0.00 481.30 22.31 10-542-502060 Long Term Disability 3,352.31 3,457.51 0.00 -105.20 -3.14 10-542-502070 Employee Assistance Prgm 667.42 619.60 0.00 47.82 7.16 10-542-503010 Awards Program 200.00 108.00 0.00 92.00 46.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,643,758.95 1,596,115.41 0.00 47,643.54 2.90 10-542-511010 Advertising 676.90 676.90 0.00 0.00 0.00 10-542-511020 Postage 45.00 39.17 0.00 5.83 12.96 10-542-512010 Printing 46.25 0.00 0.00 46.25 100.00 10-542-512020 Conies 10.00 0.00 0.00 10.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-513010 Office Supplies 1,760.75 1,760.75 0.00 0.00 0.00 10-542-514020 Chemicals 143,424.28 143,424.28 0.00 0.00 0.00 10-542-514030 Small Tools 9,000.00 8,959.58 0.00 40.42 0.45 10-542-514040 Food 2,000.00 1,932.47 0.00 67.53 3.38 10-542-515010 Stormwater Material 31.80 31.80 0.00 0.00 0.00 10-542-515020 Street Materials 355,358.09 341,086.67 2,000.00 12,271.42 3.45 10-542-515040 First Aid Supplies 468.20 285.10 0.00 183.10 39.11 10-542-515060 Weed Control 3,000.00 2,198.00 0.00 802.00 26.73 10-542-515070 Const & Inspect Supplies 144.25 0.00 0.00 144.25 100.00 10-542-517010 Operational Supplies 4,666.85 4,523.61 0.00 143.24 3.07 E10 Materials & Supplies 520,632.37 504,918.33 2,000.00 13,714.04 2.63 10-542-520030 Dues And Publications 983.00 983.00 0.00 0.00 0.00 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 3,932.74 4,732.74 0.00 -800.00 -20.34 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 17,684.26 16,047.13 500.00 1,137.13 6.43 10-542-523010 Equipment Rentlease 200.00 77.06 0.00 122.94 61.47 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,800.00 21,839.93 500.00 460.07 2.02 10-542-531010 Electricity 26,582.38 22,324.75 0.00 4,257.63 16.02 10-542-531020 Street Lights 650,000.00 581,477.38 0.00 68,522.62 10.54 10-542-533010 Natural Gas 11,051.19 7,808.34 0.00 3,242.85 29.34 10-542-534010 Telephone 580.00 96.00 0.00 484.00 83.45 10-542-535010 Water 9,645.54 10,624.31 0.00 -978.77 -10.15 E20 Utilities 697,859.11 622,330.78 0.00 75,528.33 10.82 10-542-540010 Building & Grounds Maint. 14,353.48 14,245.88 225.00 -117.40 -0.82 10-542-541030 Vehicle Wash 7,000.00 6,639.00 0.00 361.00 5.16 10-542-542010 Repairs - StopStreet Lights 21,787.84 21,787.84 0.00 0.00 0.00 10-542-542030 Signs & Marking Paint 33,257.05 31,624.10 0.00 1,632.95 4.91 10-542-546010 Clothing Expense 10,567.56 12,033.98 0.00 -1,466.42 -13.88 10-542-547010 Equipment Maintenance 2,148.96 1,388.27 0.00 760.69 35.40 10-542-547020 Maintenance Agreements 300.00 300.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 843.02 0.00 156.98 15.70 E25 Repairs & Maintenance 90,414.89 88,862.09 225.00 1,327.80 1.47 10-542-572010 Purchase Of Vehicles 324,489.00 231,612.00 92,877.00 0.00 0.00 10-542-572020 Purchase Of Equipment 350,267.00 349,805.50 0.00 461.50 0.13 10-542-573030 Purchimprov Landbuildin 20,773.85 20,773.85 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 695,529.85 602,191.35 92,877.00 461.50 0.07 542 Public Works -Street 3,670,995.17 3,436,257.89 95,602.00 139,135.28 3.79 Page 32 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 22,750.00 9,872.70 0.00 12,877.30 56.60 10-700-590065 Trans to Self -Funded H1thIns 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 258,459.28 258,459.28 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,007,265.64 1,007,265.64 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,288,474.92 1,275,597.62 0.00 12,877.30 1.00 700 Transfers & Subsidies 1,288,474.92 1,275,597.62 0.00 12,877.30 1.00 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 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 750,000.00 0.00 0.00 750,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 396,891.29 396,891.29 0.00 0.00 0.00 10-990-577054 Wayfinding 124,354.97 111,854.97 0.00 12,500.00 10.05 10-990-577056 SOMO Sewer Extension 300,000.00 300,000.00 0.00 0.00 0.00 10-990-577058 Downtown Electric 23,500.00 12,375.00 11,125.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 288,500.00 11,784.80 0.00 276,715.20 95.92 10-990-577063 Clark Avenue 93,658.26 0.00 0.00 93,658.26 100.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 400,494.60 61,800.00 338,694.60 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-590071 Mo Blvd1400-1800 Block 278,564.00 0.00 0.00 278,564.00 100.00 E75 Capital Projects 2,655,963.12 894,706.06 349,819.60 1,411,437.46 53.14 990 Capital Projects 2,655,963.12 894,706.06 349,819.60 1,411,437.46 53.14 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Expense Expense 37,040,912.56 33,027,430.90 655,752.13 3,357,729.53 9.06 GL - Trial Balance by Acct Type and Full Acct Number (11/06/2017 - 10:05 AM) Page 34