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-08 NO Meeting - Expense Report
General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 08/03/17 11:09:06 Period 01 - 09 Fiscal Year 2017 CITY OF JEFFERSON JOHN G_ CHRI TY MUNICIPAL BUILDING 320 E McCarty Si J eff ersDn City, M0 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 48,150.00 0.00 16,650.00 25.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 3,442.90 0.00 1,514.30 30.55 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 51,630.37 0.00 18,164.30 26.03 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 6.03 0.00 93.97 93.97 10-110-512010 Printing 439.00 439.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 674.10 0.00 9.90 1.45 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,423.00 1,119.20 0.00 303.80 21.35 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 533.75 0.00 966.25 64.42 10-110-520030 Dues And Publications 5,000.00 4,707.90 0.00 292.10 5.84 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,150.00 310.00 0.00 840.00 73.04 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,750.00 5,851.65 0.00 1,898.35 24.49 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 107.54 17.55 -50.09 -66.79 E25 Repairs & Maintenance 75.00 107.54 17.55 -50.09 -66.79 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 (08/03/2017 - 11:09 AM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 110 Mayor & Council 79,042.67 58,708.76 17.55 20,316.36 25.70 120 City Clerk 10-120-501020 Salaries 66,131.70 39,970.49 0.00 26,161.21 39.56 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 2,905.79 0.00 2,153.28 42.56 10-120-502020 Group Health Insurance 4,427.58 8,571.78 0.00 -4,144.20 -93.60 10-120-502030 Retirement 9,787.50 5,915.61 0.00 3,871.89 39.56 10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00 10-120-502050 Life Insurance 129.25 48.28 0.00 80.97 62.65 10-120-502060 Long Term Disability 203.17 135.27 0.00 67.90 33.42 10-120-502070 Employee Assistance Prgm 34.84 24.27 0.00 10.57 30.34 E05 Personnel Services 85,806.68 57,605.06 0.00 28,201.62 32.87 10-120-511020 Postage 200.00 171.46 0.00 28.54 14.27 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 159.16 0.00 140.84 46.95 10-120-513010 Office Supplies 500.00 182.48 0.00 317.52 63.50 E10 Materials & Supplies 1,000.00 513.10 0.00 486.90 48.69 10-120-520030 Dues And Publications 275.00 65.00 0.00 210.00 76.36 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 12.00 0.00 988.00 98.80 10-120-522020 Professional Services 1,109.64 265.00 0.00 844.64 76.12 10-120-529030 Election Expense 30,000.00 17,618.30 0.00 12,381.70 41.27 E15 Contractual Services 32,384.64 17,960.30 0.00 14,424.34 44.54 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 279.04 17.55 -1.59 -0.54 E25 Repairs & Maintenance 295.00 279.04 17.55 -1.59 -0.54 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 76,357.50 17.55 43,111.27 36.08 140 City Administrator 10-140-501020 Salaries 209,190.37 148,422.98 0.00 60,767.39 29.05 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 9,395.71 0.00 7,277.43 43.65 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 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 16,463.05 0.00 3,590.84 17.91 10-140-502030 Retirement 33,467.42 19,357.12 0.00 14,110.30 42.16 10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00 10-140-502050 Life Insurance 199.76 99.21 0.00 100.55 50.34 10-140-502060 Long Term Disability 412.24 218.24 0.00 194.00 47.06 10-140-502070 Employee Assistance Prgm 52.39 36.48 0.00 15.91 30.37 E05 Personnel Services 280,134.53 194,078.11 0.00 86,056.42 30.72 10-140-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-140-511020 Postage 250.00 70.00 0.00 180.00 72.00 10-140-512010 Printing 200.00 106.00 0.00 94.00 47.00 10-140-512020 Copies 250.00 90.62 0.00 159.38 63.75 10-140-513010 Office Supplies 850.00 303.80 0.00 546.20 64.26 10-140-517010 Operational Supplies 727.00 395.00 0.00 332.00 45.67 E10 Materials & Supplies 2,777.00 965.42 0.00 1,811.58 65.24 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,540.00 0.00 460.00 15.33 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 71.69 0.00 728.31 91.04 E15 Contractual Services 5,600.00 3,120.39 0.00 2,479.61 44.28 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 220.00 213.58 17.55 -11.13 -5.06 E25 Repairs & Maintenance 220.00 213.58 17.55 -11.13 -5.06 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 198,377.50 17.55 90,336.48 31.29 149 Entitlement Grant 10-149-501020 Salaries 38,624.05 17,721.76 0.00 20,902.29 54.12 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,270.70 0.00 1,801.82 58.64 10-149-502020 Group Health Insurance 4,778.10 4,749.19 0.00 28.91 0.61 10-149-502030 Retirement 2,984.22 1,600.09 0.00 1,384.13 46.38 10-149-502040 Workers Compensation 30.00 0.00 0.00 30.00 100.00 10-149-502050 Life Insurance 37.21 27.89 0.00 9.32 25.05 10-149-502060 Long Term Disability 58.75 57.67 0.00 1.08 1.84 10-149-502070 Employee Assistance Program 13.10 9.12 0.00 3.98 30.38 E05 Personnel Services 49.597.95 25.436.42 0.00 24.161.53 48.71 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-511010 Advertising 1,499.93 876.75 0.00 623.18 41.55 10-149-511020 Postage 500.00 189.52 0.00 310.48 62.10 10-149-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 223.99 0.00 776.01 77.60 10-149-517010 Operational Supplies 525.00 67.94 0.00 457.06 87.06 E10 Materials & Supplies 3,525.00 1,358.27 0.00 2,166.73 61.47 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,432.67 0.00 343.79 5.95 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 30,198.00 9,412.00 0.00 20,786.00 68.83 10-149-528012 Housing Rehab -Energy Efficienc 30,198.00 33.00 0.00 30,165.00 99.89 10-149-528020 Housing Assistance 25,540.00 20,392.00 0.00 5,148.00 20.16 10-149-528030 Public Improvement 37,420.96 0.00 0.00 37,420.96 100.00 10-149-528040 Neighborhood Redevelopmnt 111,223.54 17,500.00 1,200.00 92,523.54 83.19 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 5,132.00 0.00 30,001.47 85.39 E15 Contractual Services 280,490.43 57,901.67 1,200.00 221,388.76 78.93 10-149-547020 Maintenance Agreements 350.00 163.92 25.44 160.64 45.90 E25 Repairs & Maintenance 350.00 163.92 25.44 160.64 45.90 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00 10-149-577064 Broadway St Sidewalk 130,365.00 0.00 130,365.00 0.00 0.00 E75 Capital Projects 130,365.00 0.00 130,365.00 0.00 0.00 149 Entitlement Grant 464,328.38 84,860.28 131,590.44 247,877.66 53.38 150 City Counselor 10-150-501020 Salaries 228,300.53 173,408.04 0.00 54,892.49 24.04 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 12,659.93 0.00 4,805.06 27.51 10-150-502020 Group Health Insurance 38,273.07 31,814.53 0.00 6,458.54 16.87 10-150-502030 Retirement 33,788.48 25,664.32 0.00 8,124.16 24.04 10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00 10-150-502050 Life Insurance 444.56 274.40 0.00 170.16 38.28 10-150-502060 Long Term Disability 635.04 528.47 0.00 106.57 16.78 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502070 Employee Assistance Prgm 87.49 60.93 0.00 26.56 30.36 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 319,154.92 244,571.38 0.00 74,583.54 23.37 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 342.71 0.00 257.29 42.88 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 834.56 0.00 965.44 53.64 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,850.00 1,179.77 0.00 1,670.23 58.60 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 5,533.65 3,234.00 2,232.35 20.29 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 1,887.87 0.00 4,112.13 68.54 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 2,500.00 0.00 0.00 2,500.00 100.00 10-150-522020 Professional Services 22,650.00 24,636.43 0.00 -1,986.43 -8.77 10-150-525030 Court Cost & Witness Fees 75.00 0.00 0.00 75.00 100.00 E15 Contractual Services 42,225.00 32,057.95 3,234.00 6,933.05 16.42 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 483.21 17.55 124.24 19.88 E25 Repairs & Maintenance 625.00 483.21 17.55 124.24 19.88 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 364,854.92 278,292.31 3,251.55 83,311.06 22.83 160 Municipal Court 10-160-501010 Salary -elected Officals 59,999.88 47,916.60 0.00 12,083.28 20.14 10-160-501020 Salaries 101,707.05 39,311.27 0.00 62,395.78 61.35 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 3,540.25 0.00 13,528.74 79.26 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 6,824.02 0.00 7,081.83 50.93 10-160-502020 Group Health Insurance 20,227.17 7,461.56 0.00 12,765.61 63.11 10-160-502030 Retirement 15,496.64 4,802.63 0.00 10,694.01 69.01 10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00 10-160-502050 Life Insurance 199.76 48.78 0.00 150.98 75.58 10-160-502060 Lona Term Disabilitv 312.11 99.37 0.00 212.74 68.16 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502070 Employee Assistance Prgm 61.03 42.48 0.00 18.55 30.39 E05 Personnel Services 232,084.90 112,222.92 0.00 119,861.98 51.65 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,800.00 2,443.26 0.00 1,356.74 35.70 10-160-512010 Printing 1,090.00 270.00 0.00 820.00 75.23 10-160-512020 Copies 500.00 145.00 0.00 355.00 71.00 10-160-513010 Office Supplies 3,500.00 1,902.52 0.00 1,597.48 45.64 E10 Materials & Supplies 8,890.00 4,760.78 0.00 4,129.22 46.45 10-160-520025 Security 7,000.00 7,655.34 -1,101.20 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 655.84 0.00 1,844.16 73.77 10-160-522020 Professional Services 4,500.00 4,150.02 0.00 349.98 7.78 10-160-525005 Appointed Counsel 7,000.00 2,725.00 0.00 4,275.00 61.07 10-160-525010 Care Of Prisoners 2,000.00 0.00 0.00 2,000.00 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 15,246.20 -1,101.20 9,345.00 39.78 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 944.17 17.55 -231.72 -31.74 E25 Repairs & Maintenance 730.00 944.17 17.55 -231.72 -31.74 10-160-572020 Purchase Of Equipment 5,563.24 0.00 5,563.24 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 5,563.24 0.00 5,563.24 0.00 0.00 160 Municipal Court 270,758.14 133,174.07 4,479.59 133,104.48 49.16 170 Human Resources 10-170-501020 Salaries 194,985.36 136,294.77 0.00 58,690.59 30.10 10-170-501050 Parttime(wo Benefits) 38,932.80 20,866.15 0.00 18,066.65 46.40 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 11,958.42 0.00 5,959.27 33.26 10-170-502020 Group Health Insurance 19,329.42 13,552.01 0.00 5,777.41 29.89 10-170-502030 Retirement 28,902.24 20,188.13 0.00 8,714.11 30.15 10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00 10-170-502050 Life Insurance 370.14 219.54 0.00 150.60 40.69 10-170-502060 Long Term Disability 521.91 403.39 0.00 118.52 22.71 10-170-502070 Employee Assistance Prgm 78.58 54.72 0.00 23.86 30.36 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 301,432.67 203,743.26 0.00 97,689.41 32.41 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-511020 Postage 300.00 85.22 0.00 214.78 71.59 10-170-512010 Printing 1,000.00 0.00 0.00 1,000.00 100.00 10-170-512020 Copies 500.00 445.33 0.00 54.67 10.93 10-170-513010 Office Supplies 1,200.00 984.17 0.00 215.83 17.99 10-170-517010 Operational Supplies 750.00 867.48 0.00 -117.48 -15.66 E10 Materials & Supplies 3,900.00 2,382.20 0.00 1,517.80 38.92 10-170-520030 Dues And Publications 1,468.00 -2.95 0.00 1,470.95 100.20 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,230.60 0.00 2,269.40 64.84 10-170-520070 Training And Education 5,220.00 2,924.76 0.00 2,295.24 43.97 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 772.25 0.00 167.75 17.85 10-170-522020 Professional Services 2,000.00 2,502.44 0.00 -502.44 -25.12 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 7,477.66 0.00 6,650.34 47.07 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 210.85 17.55 -8.40 -3.82 E25 Repairs & Maintenance 220.00 210.85 17.55 -8.40 -3.82 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 213,813.97 17.55 105,849.15 33.11 180 Finance Department 10-180-501020 Salaries 622,105.16 430,060.97 0.00 192,044.19 30.87 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 32,239.78 0.00 15,685.02 32.73 10-180-502020 Group Health Insurance 74,853.57 54,098.00 0.00 20,755.57 27.73 10-180-502030 Retirement 92,071.56 60,365.51 0.00 31,706.05 34.44 10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00 10-180-502050 Life Insurance 1,212.25 711.17 0.00 501.08 41.33 10-180-502060 Long Term Disability 1,788.94 1,415.81 0.00 373.13 20.86 10-180-502070 Employee Assistance Prgm 307.77 214.23 0.00 93.54 30.39 E05 Personnel Services 845,157.87 583,999.29 0.00 261,158.58 30.90 10-180-511010 Advertising 1,000.00 268.68 0.00 731.32 73.13 10-180-511020 Postaee 9.500.00 6.934.54 0.00 2.565.46 27.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511021 Mail Machine Cost 2,500.00 1,719.80 0.00 780.20 31.21 10-180-512010 Printing 4,000.00 1,603.71 0.00 2,396.29 59.91 10-180-512020 Copies 2,500.00 1,056.70 0.00 1,443.30 57.73 10-180-512021 Copy Machine Cost 1,000.00 -343.84 105.30 1,238.54 123.85 10-180-513010 Office Supplies 4,000.00 1,556.95 0.00 2,443.05 61.08 10-180-517010 Operational Supplies 5,500.00 37.71 0.00 5,462.29 99.31 E10 Materials & Supplies 30,000.00 12,834.25 105.30 17,060.45 56.87 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,330.00 0.00 970.00 42.17 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,559.79 0.00 8,440.21 76.73 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 0.00 0.00 500.00 100.00 E15 Contractual Services 45,395.00 30,773.07 0.00 14,621.93 32.21 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 628,561.07 105.30 292,886.50 31.78 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 5,688.47 0.00 6,311.53 52.60 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 5,688.47 0.00 6,311.53 52.60 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 (08/03/2017 - 11:09 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 457,635.16 0.00 -142,052.44 -45.01 10-185-521020 Insurance Deductible 15,000.00 10,350.74 0.00 4,649.26 31.00 10-185-521030 Self Ins Prop & Casualty 75,000.00 9,017.91 0.00 65,982.09 87.98 10-185-521060 Drugalcohol screening 5,364.00 1,638.00 0.00 3,726.00 69.46 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 43,871.61 0.00 -42,690.36 -3,614.00 10-185-522020 Professional Services 172,600.00 118,749.97 8,333.33 45,516.70 26.37 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 22,902.00 0.00 22,848.00 49.94 10-185-527020 Economic Development 185,000.00 185,000.00 46,250.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 8,708.95 0.00 -1,708.95 -24.41 E15 Contractual Services 877,477.97 912,874.34 54,583.33 -89,979.70 -10.25 10-185-531010 Electricity 42,000.00 19,173.60 0.00 22,826.40 54.35 10-185-533010 Natural Gas 6,400.00 3,480.75 0.00 2,919.25 45.61 10-185-535010 Water 7,250.00 4,055.85 0.00 3,194.15 44.06 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 26,710.20 0.00 28,939.80 52.00 10-185-540010 Building & Grounds Maint. 65,040.00 31,204.83 240.00 33,595.17 51.65 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,248.79 0.00 851.21 40.53 E25 Repairs & Maintenance 92,140.00 57,453.62 240.00 34,446.38 37.38 10-185-550010 Miscellaneous 9,290.36 1,413.00 0.00 7,877.36 84.79 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 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 500.00 0.00 9,165.00 94.83 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 1,941.54 0.00 -1,941.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 26,479.92 0.00 43,230.33 62.01 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 (08/03/2017 - 11:09 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,070,310.95 54,823.33 5,637.61 0.50 190 I.T. Department 10-190-501020 Salaries 531,187.69 360,876.58 0.00 170,311.11 32.06 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 0.00 0.00 0.00 0.00 10-190-502010 Social Security 40,727.66 26,210.94 0.00 14,516.72 35.64 10-190-502020 Group Health Insurance 75,335.92 51,988.95 0.00 23,346.97 30.99 10-190-502030 Retirement 78,793.38 42,246.87 0.00 36,546.51 46.38 10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00 10-190-502050 Life Insurance 1,026.20 569.52 0.00 456.68 44.50 10-190-502060 Long Term Disability 1,575.82 1,162.72 0.00 413.10 26.21 10-190-502070 Employee Assistance Prgm 248.84 173.25 0.00 75.59 30.38 E05 Personnel Services 730,452.62 483,585.94 0.00 246,866.68 33.80 10-190-511010 Advertising 1,146.00 1,175.10 0.00 -29.10 -2.54 10-190-511020 Postage 100.00 79.56 0.00 20.44 20.44 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 24.98 0.00 75.02 75.02 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 348.31 0.00 651.69 65.17 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,750.00 2,019.97 0.00 1,730.03 46.13 E10 Materials & Supplies 6,246.00 3,708.19 0.00 2,537.81 40.63 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 0.00 99.00 0.00 -99.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 12,000.00 9,353.71 0.00 2,646.29 22.05 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 8,000.00 844.80 0.00 7,155.20 89.44 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet Tl Web 19,654.00 12,352.30 0.00 7,301.70 37.15 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 (08/03/2017 - 11:09 AM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 20.84 10-190-545020 Citywide Wiringnetwork 3,000.00 7.90 0.00 2,992.10 10-190-522060 City Web Site 4,400.00 4,362.82 0.00 37.18 0.85 E15 Contractual Services 44,054.00 27,012.63 0.00 17,041.37 38.68 10-190-534010 Telephone E20 Utilities 58,000.00 37,835.97 58,000.00 37,835.97 0.00 20,164.03 0.00 20,164.03 34.77 34.77 10-190-545010 Advertising Software Licensemaint 142,000.00 107,165.26 5,239.00 29,595.74 20.84 10-190-545020 Citywide Wiringnetwork 3,000.00 7.90 0.00 2,992.10 99.74 10-190-547010 5,000.00 Equipment Maintenance 3,000.00 713.81 0.00 2,286.19 76.21 10-190-547020 0.00 Maintenance Agreements 24,900.00 8,092.53 0.00 16,807.47 67.50 E25 0.00 Repairs & Maintenance 172,900.00 115,979.50 5,239.00 51,681.50 29.89 10-190-572020 -1,357.62 Purchase Of Equipment 0.00 114.99 0.00 -114.99 0.00 E70 43.40 Capital Purchases 0.00 114.99 0.00 -114.99 0.00 190 10-300-515040 I.T. Department 1,011,652.62 668,237.22 5,239.00 338,176.40 33.43 300 Ammunition & Firearms Supplies Police Department 14,477.56 11,756.81 65.63 0.25 10-300-516020 10-300-501020 16,500.00 Salaries 4,263,295.67 2,977,949.22 0.00 1,285,346.45 30.15 10-300-501030 0.00 Holiday Pay 131,844.61 101,560.31 0.00 30,284.30 22.97 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 35,713.79 0.00 26,131.85 42.25 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 4,000.00 3,040.00 0.00 960.00 24.00 10-300-501090 Overtime 236,536.00 214,219.03 0.00 22,316.97 9.43 10-300-501095 Overtime Straight Pay 7,000.00 9,384.25 0.00 -2,384.25 -34.06 10-300-502010 Social Security 355,601.71 242,383.21 0.00 113,218.50 31.84 10-300-502020 Group Health Insurance 757,648.99 531,622.62 0.00 226,026.37 29.83 10-300-502030 Retirement 829,580.25 584,688.80 0.00 244,891.45 29.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 4,830.75 0.00 3,690.25 43.31 10-300-502060 Long Term Disability 12,725.99 9,864.11 0.00 2,861.88 22.49 10-300-502070 Employee Assistance Prgm 2,396.71 1,668.75 0.00 727.96 30.37 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,713,006.53 4,756,334.80 0.00 1,956,671.73 29.15 10-300-511010 Advertising 3,000.00 1,025.67 0.00 1,974.33 65.81 10-300-511020 Postage 1,500.00 1,147.13 0.00 352.87 23.52 10-300-512010 Printing 5,000.00 5,268.13 0.00 -268.13 -5.36 10-300-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-300-512030 Photographic Supplies 2,000.00 1,071.00 0.00 929.00 46.45 10-300-513010 Office Supplies 13,000.00 14,357.62 0.00 -1,357.62 -10.44 10-300-514010 Gas 158,000.00 89,434.82 0.00 68,565.18 43.40 10-300-514040 Food 700.00 489.31 0.00 210.69 30.10 10-300-515040 First Aid Supplies 1,000.00 836.75 0.00 163.25 16.33 10-300-516010 Ammunition & Firearms Supplies 26,300.00 14,477.56 11,756.81 65.63 0.25 10-300-516020 Dare Program 16,500.00 9,467.91 0.00 7,032.09 42.62 10-300-516030 Special Investigation 2,500.00 0.00 0.00 2,500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-516040 Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 5,538.25 5,583.22 0.00 -44.97 -0.81 10-300-517010 Operational Supplies 48,075.00 39,358.06 315.46 8,401.48 17.48 E10 Materials & Supplies 283,213.25 182,517.18 12,072.27 88,623.80 31.29 10-300-520030 Civil Defense Dues And Publications 4,600.00 4,211.90 0.00 388.10 8.44 10-300-520050 Emerg Mgmt Operations INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 57,009.00 45,163.90 0.00 11,845.10 20.78 10-300-520080 Tuition Reimbursement 7,000.00 9,096.00 0.00 -2,096.00 -29.94 10-300-520090 Recruitment 2,500.00 1,382.17 0.00 1,117.83 44.71 10-300-521040 Medical Claimsservices 5,000.00 4,293.15 0.00 706.85 14.14 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 15,500.00 12,197.50 0.00 3,302.50 21.31 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 10-300-572011 Police Evidence Funds 0.00 52,116.03 0.00 -52,116.03 0.00 10-300-523010 10-300-572020 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 10-300-572070 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 1,286.29 0.00 913.71 41.53 E15 Contractual Services 93,809.00 129,746.94 0.00 -35,937.94 -38.31 10-300-531010 Electricity 68,250.00 34,480.73 0.00 33,769.27 49.48 10-300-533010 Natural Gas 7,000.00 690.27 0.00 6,309.73 90.14 10-300-534010 Telephone 19,500.00 14,913.40 0.00 4,586.60 23.52 10-300-535010 Water 4,500.00 1,949.63 0.00 2,550.37 56.67 E20 Utilities 99,250.00 52,034.03 0.00 47,215.97 47.57 10-300-540010 Building & Grounds Maint, 40,000.00 24,272.36 370.00 15,357.64 38.39 10-300-541030 Vehicle Wash 12,000.00 8,132.42 0.00 3,867.58 32.23 10-300-544010 K-9 Operations 18,500.00 11,168.20 0.00 7,331.80 39.63 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 3,032.43 0.00 18,267.57 85.76 10-300-545010 Software Licensemaint 62,000.00 61,164.01 0.00 835.99 1.35 10-300-546010 Clothing Expense 43,000.00 17,054.64 -1,384.28 27,329.64 63.56 10-300-546020 Uniform Cleaning 25,000.00 13,079.68 0.00 11,920.32 47.68 10-300-547010 Equipment Maintenance 9,350.00 5,568.67 0.00 3,781.33 40.44 10-300-547020 Maintenance Agreements 46,600.00 40,847.83 3,933.24 1,818.93 3.90 10-300-547030 Radio Maintenance 10,000.00 4,500.72 0.00 5,499.28 54.99 E25 Repairs & Maintenance 287,750.00 188,820.96 2,918.96 96,010.08 33.37 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,000.00 35,295.00 0.00 -295.00 -0.84 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 (08/03/2017 - 11:09 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,015.76 220,908.00 0.00 29,107.76 11.64 300 Police Department 7,727,044.54 5,530,361.91 14,991.23 2,181,691.40 28.23 310 School Resource Officer 10-310-501020 Salaries 233,273.88 199,680.93 0.00 33,592.95 14.40 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 20,368.43 0.00 -3,242.43 -18.93 10-310-501095 Overtime Straight Pay 410.00 105.82 0.00 304.18 74.19 10-310-502010 Social Security 19,865.21 16,057.13 0.00 3,808.08 19.17 10-310-502020 Group Health Insurance 61,286.66 39,881.51 0.00 21,405.15 34.93 10-310-502030 Retirement 47,780.37 39,792.59 0.00 7,987.78 16.72 10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00 10-310-502050 Life Insurance 473.93 316.78 0.00 157.15 33.16 10-310-502060 Long Term Disability 714.82 658.63 0.00 56.19 7.86 10-310-502070 Employee Assistance Prgm 130.97 91.20 0.00 39.77 30.37 E05 Personnel Services 392,466.70 324,310.77 0.00 68,155.93 17.37 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 (08/03/2017 - 11:09 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 324,310.77 0.00 68,155.93 17.37 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 93,718.69 63,448.42 0.00 30,270.27 32.30 10-320-501030 Holiday Pay 2,364.09 337.87 0.00 2,026.22 85.71 10-320-501090 Overtime 24,650.00 18,451.49 0.00 6,198.51 25.15 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 5,970.73 0.00 1,720.33 22.37 10-320-502020 Group Health Insurance 19,569.70 13,537.91 0.00 6,031.79 30.82 10-320-502030 Retirement 18,498.75 15,241.05 0.00 3,257.70 17.61 10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00 10-320-502050 Life Insurance 180.17 102.39 0.00 77.78 43.17 10-320-502060 Long Term Disability 271.24 211.33 0.00 59.91 22.09 10-320-502070 Employee Assistance Prgm 52.39 36.48 0.00 15.91 30.37 E05 Personnel Services 169,014.55 118,950.33 0.00 50,064.22 29.62 10-320-514010 Gas 5,000.00 3,757.53 0.00 1,242.47 24.85 10-320-516040 Investigations 14,350.00 10,020.01 0.00 4,329.99 30.17 10-320-517010 Operational Supplies 7,750.31 1,344.59 0.00 6,405.72 82.65 E10 Materials & Supplies 27,100.31 15,122.13 0.00 11,978.18 44.20 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 10,000.00 2,000.00 6,269.11 34.32 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,269.11 10,000.00 2,000.00 6,269.11 34.32 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 144,072.46 2,000.00 68,311.51 31.86 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 330 Animal Control 10-330-501020 Salaries 328,493.12 232,835.38 0.00 95,657.74 29.12 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 3,040.00 0.00 1,268.00 29.43 10-330-501090 Overtime 1,709.00 1,565.54 0.00 143.46 8.39 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,628.27 17,282.74 0.00 8,345.53 32.56 10-330-502020 Group Health Insurance 57,912.97 46,261.45 0.00 11,651.52 20.12 10-330-502030 Retirement 49,581.50 35,141.37 0.00 14,440.13 29.12 10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00 10-330-502050 Life Insurance 640.40 382.03 0.00 258.37 40.35 10-330-502060 Long Term Disability 1,003.75 785.50 0.00 218.25 21.74 10-330-502070 Employee Assistance Prgm 209.55 145.89 0.00 63.66 30.38 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 472,481.33 339,934.67 0.00 132,546.66 28.05 10-330-511010 Advertising 120.00 0.00 0.00 120.00 100.00 10-330-511020 Postage 100.00 83.95 0.00 16.05 16.05 10-330-512010 Printing 1,450.00 1,566.04 0.00 -116.04 -8.00 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,900.00 385.31 0.00 1,514.69 79.72 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 190.52 0.00 49.48 20.62 10-330-515040 First Aid Supplies 700.00 244.23 0.00 455.77 65.11 10-330-517010 Operational Supplies 9,700.00 8,563.48 0.00 1,136.52 11.72 E10 Materials & Supplies 14,210.00 11,033.53 0.00 3,176.47 22.35 10-330-520030 Dues And Publications 1,150.00 1,381.78 0.00 -231.78 -20.15 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 0.00 0.00 1,950.00 100.00 10-330-521040 Medical Claimsservices 564.00 505.00 0.00 59.00 10.46 10-330-522020 Professional Services 3,900.00 2,642.60 0.00 1,257.40 32.24 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,600.00 7,861.04 0.00 -2,261.04 -40.38 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 7,625.00 14,890.46 0.00 -7,265.46 -95.28 E15 Contractual Services 20,789.00 27,280.88 0.00 -6,491.88 -31.23 10-330-531010 Electricity 21,700.00 14,291.45 0.00 7,408.55 34.14 10-330-533010 Natural Gas 15,800.00 12,114.11 0.00 3,685.89 23.33 10-330-534010 Telephone 300.00 143.84 0.00 156.16 52.05 10-330-535010 Water 4,300.00 2,216.68 0.00 2,083.32 48.45 E20 Utilities 42,100.00 28,766.08 0.00 13,333.92 31.67 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-540010 Building & Grounds Maint. 9,500.00 13,278.72 0.00 -3,778.72 -39.78 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 41,000.00 40,801.69 0.00 198.31 0.48 10-330-544050 Animal Food 5,000.00 3,219.34 0.00 1,780.66 35.61 10-330-545010 Software Licensemaint 2,350.00 2,141.28 138.00 70.72 3.01 10-330-546010 Clothing Expense 2,500.00 1,724.14 0.00 775.86 31.03 10-330-546020 Uniform Cleaning 0.00 195.13 0.00 -195.13 0.00 10-330-547010 Equipment Maintenance 900.00 956.84 0.00 -56.84 -6.32 10-330-547020 Maintenance Agreements 69.00 69.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 251.00 53.55 0.00 197.45 78.67 E25 Repairs & Maintenance 62,110.00 62,979.69 138.00 -1,007.69 -1.62 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 11.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 639,942.29 494,977.25 138.00 144,827.04 22.63 390 9-1-1 Police 10-390-501020 Salaries 860,459.47 588,492.73 0.00 271,966.74 31.61 10-390-501030 Holiday Pay 29,479.22 24,730.70 0.00 4,748.52 16.11 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 12,256.36 0.00 3,557.64 22.50 10-390-501095 Overtime Straight Pay 500.00 78.70 0.00 421.30 84.26 10-390-502010 Social Security 69,527.23 45,538.97 0.00 23,988.26 34.50 10-390-502020 Group Health Insurance 169,048.38 106,791.72 0.00 62,256.66 36.83 10-390-502030 Retirement 135,322.10 91,180.16 0.00 44,141.94 32.62 10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00 10-390-502050 Life Insurance 1,737.10 954.05 0.00 783.05 45.08 10-390-502060 Long Term Disability 2,637.44 1,958.34 0.00 679.10 25.75 10-390-502070 Employee Assistance Prgm 556.61 387.54 0.00 169.07 30.37 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,288,162.68 872,850.40 0.00 415,312.28 32.24 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 351.00 0.00 129.00 26.88 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 1,518.01 0.00 3,481.99 69.64 10-390-522020 Professional Services 1,320.00 1,310.33 0.00 9.67 0.73 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 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 71,442.41 74,621.75 0.00 0.00 26,557.59 30,178.25 27.10 28.80 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 Software Licensemaint 23,000.00 23,000.00 0.00 0.00 0.00 10-390-546010 Clothing Expense 6,000.00 879.23 0.00 5,120.77 85.35 10-390-546020 Uniform Cleaning 1,400.00 1,947.00 0.00 -547.00 -39.07 10-390-547010 Equipment Maintenance 2,600.00 337.50 0.00 2,262.50 87.02 10-390-547020 Maintenance Agreements 42,000.00 31,255.67 577.16 10,167.17 24.21 10-390-547030 Radio Maintenance 5,000.00 4,092.36 0.00 907.64 18.15 E25 Repairs & Maintenance 80,000.00 61,511.76 577.16 17,911.08 22.39 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 10-400-514030 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 10-400-514040 9-1-1 Police 1,478,062.68 1,010,382.93 577.16 467,102.59 31.60 400 10-400-515040 Fire Department First Aid Supplies 800.00 309.80 0.00 490.20 10-400-501020 10-400-517010 Salaries 3,783,411.71 2,574,448.85 0.00 1,208,962.86 31.95 10-400-501030 E10 Holiday Pay 270,304.05 242,206.80 0.00 28,097.25 10.39 10-400-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,500.00 24,240.00 0.00 4,260.00 14.95 10-400-501090 Overtime 43,000.00 15,548.45 0.00 27,451.55 63.84 10-400-501095 Overtime Straight Pay 35,000.00 12,475.30 0.00 22,524.70 64.36 10-400-502010 Social Security 69,436.89 41,193.48 0.00 28,243.41 40.67 10-400-502020 Group Health Insurance 644,562.45 458,410.47 0.00 186,151.98 28.88 10-400-502030 Retirement 1,822,395.71 1,229,879.86 0.00 592,515.85 32.51 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 4,112.29 0.00 3,682.14 47.24 10-400-502060 Long Term Disability 11,342.56 8,399.03 0.00 2,943.53 25.95 10-400-502070 Employee Assistance Prgm 1,990.71 1,386.06 0.00 604.65 30.37 10-400-503010 Awards Program 900.00 817.07 0.00 82.93 9.21 E05 Personnel Services 6,797,784.06 4,692,263.21 0.00 2,105,520.85 30.97 10-400-511010 Advertising 1,150.00 415.00 0.00 735.00 63.91 10-400-511020 Postage 200.00 161.99 0.00 38.01 19.01 10-400-512010 Printing 1,250.00 0.00 0.00 1,250.00 100.00 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,800.00 1,021.92 0.00 778.08 43.23 10-400-514010 Gas 49,000.00 26,034.36 0.00 22,965.64 46.87 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,255.40 0.00 444.60 7.80 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 800.00 309.80 0.00 490.20 61.28 10-400-517010 Operational Supplies 10,000.00 7,558.56 0.00 2,441.44 24.41 E10 Materials & Supplies 71,450.00 41,952.38 0.00 29,497.62 41.28 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520030 Dues And Publications 2,500.00 2,401.95 0.00 98.05 3.92 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 19,082.43 0.00 4,917.57 20.49 10-400-520080 Tuition Reimbursement 4,000.00 1,845.00 0.00 2,155.00 53.88 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 38,550.00 9,210.25 4,180.00 25,159.75 65.27 10-400-522020 Professional Services 3,250.00 0.00 3,250.00 0.00 0.00 10-400-523010 Equipment Rentlease 500.00 58.74 0.00 441.26 88.25 10-400-524010 Trash Collections 100.00 0.00 0.00 100.00 100.00 10-400-529010 Special Events 5,500.00 5,541.37 0.00 -41.37 -0.75 10-400-529040 Child Pass Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 80,900.00 38,919.74 7,430.00 34,550.26 42.71 10-400-531010 Electricity 32,000.00 20,871.53 0.00 11,128.47 34.78 10-400-533010 Natural Gas 20,000.00 11,376.61 0.00 8,623.39 43.12 10-400-534010 Telephone 20,000.00 16,401.98 0.00 3,598.02 17.99 10-400-535010 Water 13,000.00 11,177.48 0.00 1,822.52 14.02 E20 Utilities 85,000.00 59,827.60 0.00 25,172.40 29.61 10-400-540010 Building & Grounds Maint. 203,738.00 39,953.08 168,890.41 -5,105.49 -2.51 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 46,100.00 39,907.25 -1,408.00 7,600.75 16.49 10-400-546020 Uniform Cleaning 500.00 258.25 0.00 241.75 48.35 10-400-547010 Equipment Maintenance 16,500.00 13,638.15 1,700.80 1,161.05 7.04 10-400-547020 Maintenance Agreements 28,500.00 23,606.54 -12,906.97 17,800.43 62.46 10-400-547030 Radio Maintenance 9,500.00 1,059.32 0.00 8,440.68 88.85 E25 Repairs & Maintenance 304,838.00 118,422.59 156,276.24 30,139.17 9.89 10-400-572010 Purchase Of Vehicles 88,875.00 79,472.07 8,946.00 456.93 0.51 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 0.00 7,645.85 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 0.00 0.00 274,461.00 100.00 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 4,804,609.00 -4,804,609.00 -413.01 E70 Capital Purchases 1,534,299.93 1,242,786.00 4,821,200.85 -4,529,686.92 -295.23 10-400-575017 Fire Apparatus -Loan Principal 0.00 0.00 0.00 0.00 0.00 10-400-575018 Fire Apparatus -Loan Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 400 Fire Department 8,874,271.99 6,194,171.52 4,984,907.09 -2,304,806.62 -25.97 401 Fire Museum 10-401-531010 Electricity 770.06 302.87 0.00 467.19 60.67 10-401-533010 Natural Gas 236.39 294.52 0.00 -58.13 -24.59 10-401-535010 Water 243.55 280.37 0.00 -36.82 -15.12 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 1,250.00 877.76 0.00 372.24 29.78 10-401-540010 Building & Grounds Maint. 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 1,250.00 877.76 0.00 372.24 29.78 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 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 520 Plan & Protect Svcs -Admin 10-520-501020 Salaries 236,183.14 172,243.13 0.00 63,940.01 27.07 10-520-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 17,424.92 12,902.77 0.00 4,522.15 25.95 10-520-502020 Group Health Insurance 31,191.13 19,814.77 0.00 11,376.36 36.47 10-520-502030 Retirement 32,020.81 21,132.15 0.00 10,888.66 34.00 10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00 10-520-502050 Life Insurance 419.10 216.03 0.00 203.07 48.45 10-520-502060 Long Term Disability 607.35 430.33 0.00 177.02 29.15 10-520-502070 Employee Assistance Prgm 104.77 72.96 0.00 31.81 30.36 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 318,074.57 226,935.49 0.00 91,139.08 28.65 10-520-511010 Advertising 5,474.42 5,474.42 0.00 0.00 0.00 10-520-511020 Postage 200.00 22.32 0.00 177.68 88.84 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 800.00 708.88 0.00 91.12 11.39 10-520-514010 Gas 13,000.00 5,038.65 0.00 7,961.35 61.24 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 522.00 522.00 0.00 0.00 0.00 E10 Materials & Supplies 19,996.42 11,766.27 0.00 8,230.15 41.16 10-520-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,317.70 517.20 0.00 800.50 60.75 10-520-522020 Professional Services 3,901.92 1,106.25 0.00 2,795.67 71.65 E15 Contractual Services 5,719.62 1,623.45 0.00 4,096.17 71.62 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 824.62 129.63 465.20 32.77 E25 Repairs & Maintenance 1,419.45 824.62 129.63 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 345,210.06 241,149.83 129.63 103,930.60 30.11 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 60,578.65 42,848.54 0.00 17,730.11 29.27 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-547020 Maintenance Agreements 1,662.58 1,251.58 220.92 190.08 11.43 10-521-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits) 16,000.00 8,672.02 0.00 7,327.98 45.80 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 5,858.27 3,849.69 0.00 2,008.58 34.29 10-521-502020 Group Health Insurance 10,246.91 7,082.21 0.00 3,164.70 30.88 10-521-502030 Retirement 8,965.64 6,341.61 0.00 2,624.03 29.27 10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00 10-521-502050 Life Insurance 117.50 69.74 0.00 47.76 40.65 10-521-502060 Long Term Disability 183.84 143.27 0.00 40.57 22.07 10-521-502070 Employee Assistance Prgm 26.19 18.24 0.00 7.95 30.36 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 102,017.27 69,065.59 0.00 32,951.68 32.30 10-521-511010 Advertising 5,000.00 4,261.50 0.00 738.50 14.77 10-521-511020 Postage 1,000.00 452.18 0.00 547.82 54.78 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 10.00 19.08 0.00 -9.08 -90.80 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 567.79 0.00 432.21 43.22 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,925.12 610.56 0.00 1,314.56 68.28 E10 Materials & Supplies 9,110.00 6,085.99 0.00 3,024.01 33.19 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,251.58 220.92 190.08 11.43 E25 Repairs & Maintenance 1,662.58 1,251.58 220.92 190.08 11.43 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 90,300.86 220.92 38,894.20 30.05 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 139,057.76 78,079.40 0.00 60,978.36 43.85 10-522-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 11,592.06 5,950.99 0.00 5,641.07 48.66 10-522-502020 Group Health Insurance 18,872.81 10,028.83 0.00 8,843.98 46.86 10-522-502030 Retirement 24,116.63 11,555.76 0.00 12,560.87 52.08 10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00 10-522-502050 Life Insurance 317.26 129.56 0.00 187.70 59.16 10-522-502060 Long Term Disability 496.94 262.89 0.00 234.05 47.10 10-522-502070 Employee Assistance Prgm 78.58 54.72 0.00 23.86 30.36 E05 Personnel Services 194,595.41 106,125.52 0.00 88,469.89 45.46 10-522-511010 Advertising 2,101.00 983.43 0.00 1,117.57 53.19 10-522-511020 Postage 400.00 117.57 0.00 282.43 70.61 10-522-512010 Printing 125.00 38.00 0.00 87.00 69.60 10-522-512020 Copies 50.00 2.63 0.00 47.37 94.74 10-522-513010 Office Supplies 1,000.00 750.59 0.00 249.41 24.94 10-522-514040 Food 250.00 194.18 0.00 55.82 22.33 10-522-517010 Operational Supplies 1,300.00 175.59 0.00 1,124.41 86.49 E10 Materials & Supplies 5,226.00 2,261.99 0.00 2,964.01 56.72 10-522-520030 Dues And Publications 1,250.00 965.00 0.00 285.00 22.80 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 3,566.00 0.00 6,010.64 62.76 10-522-522020 Professional Services 235,000.00 57,575.28 17,424.72 160,000.00 68.09 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 245,826.64 62,106.28 17,424.72 166,295.64 67.65 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 463.91 223.02 63.07 8.41 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 750.00 463.91 223.02 63.07 8.41 10-522-572020 Purchase Of Equipment 2,774.00 0.00 0.00 2,774.00 100.00 E70 Capital Purchases 2,774.00 0.00 0.00 2,774.00 100.00 522 Plan & Protect Svcs -MPO 449,172.05 170,957.70 17,647.74 260,566.61 58.01 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 104,707.80 55,129.23 0.00 49,578.57 47.35 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 3,803.45 0.00 4,206.69 52.52 10-530-502020 Group Health Insurance 16,238.38 8,863.11 0.00 7,375.27 45.42 10-530-502030 Retirement 15,496.76 8,159.09 0.00 7,337.67 47.35 10-530-502040 Workers Compensation 28.02 0.00 0.00 28.02 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-502050 Life Insurance 205.63 88.28 0.00 117.35 57.07 10-530-502060 Long Term Disability 307.40 182.51 0.00 124.89 40.63 10-530-502070 Employee Assistance Prgm 65.48 45.60 0.00 19.88 30.36 E05 Personnel Services 145,059.61 76,271.27 0.00 68,788.34 47.42 10-530-511010 Advertising 300.00 212.00 0.00 88.00 29.33 10-530-511020 Postage 100.00 70.60 0.00 29.40 29.40 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 300.00 279.71 0.00 20.29 6.76 10-530-517010 Operational Supplies 300.00 174.24 0.00 125.76 41.92 E10 Materials & Supplies 1,100.00 736.55 0.00 363.45 33.04 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 722.52 0.00 1,077.48 59.86 10-530-522020 Professional Services 880.00 0.00 0.00 880.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 18,800.00 6,587.79 12,212.21 0.00 0.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 2,000.00 1,670.84 0.00 329.16 16.46 10-530-524029 Recycling Education 9,000.00 5,513.68 0.00 3,486.32 38.74 10-530-528085 Fair Housing Assistance Prog 500.00 238.00 0.00 262.00 52.40 E15 Contractual Services 33,480.00 14,732.83 12,212.21 6,534.96 19.52 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 55.47 83.19 211.34 60.38 E25 Repairs & Maintenance 350.00 55.47 83.19 211.34 60.38 10-530-550020 NRA -Residential 55,000.00 52,836.47 0.00 2,163.53 3.93 10-530-550030 NRA -Commercial Facade 35,000.00 16,715.32 0.00 18,284.68 52.24 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA -Rental Facade 15,066.00 5,060.00 0.00 10,006.00 66.41 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 500.00 247.84 0.00 252.16 50.43 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 2,432.78 0.00 59,978.76 96.10 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,457.54 121,792.41 0.00 94,665.13 43.73 530 Plan & Protect Svc-RedevGrant 396,447.15 213,588.53 12,295.40 170,563.22 43.02 Page 23 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 531 Plan & Protect Svcs -Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 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 38.50 0.00 -38.50 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 38.50 0.00 -38.50 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 531 Dues And Publications Plan & Protect Svcs -Build Reg 0.00 38.50 0.00 -38.50 0.00 532 0.00 Plan & Protect Svcs -Env Health 0.00 0.00 0.00 10-532-520070 Training And Education 10-532-501020 428.00 Salaries 169,534.11 118,507.69 0.00 51,026.42 30.10 10-532-501050 0.00 Parttime (wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-532-501060 0.00 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 0.00 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-532-501095 10-532-524026 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 INACTIVE - Portable Recycling Social Security 12,992.31 8,292.39 0.00 4,699.92 36.17 10-532-502020 0.00 Group Health Insurance 21,564.41 21,419.96 0.00 144.45 0.67 10-532-502030 147,333.36 Retirement 25,135.45 17,539.19 0.00 7,596.26 30.22 10-532-502040 0.00 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00 10-532-502050 0.00 Life Insurance 327.05 193.94 0.00 133.11 40.70 10-532-502060 Long Term Disability 511.14 398.46 0.00 112.68 22.04 10-532-502070 0.00 Employee Assistance Prgm 78.58 54.72 0.00 23.86 30.36 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 232,222.28 168,185.58 0.00 64,036.70 27.58 10-532-511010 Advertising 300.00 90.00 0.00 210.00 70.00 10-532-511020 Postage 200.00 140.82 0.00 59.18 29.59 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,300.00 1,103.98 0.00 196.02 15.08 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 853.10 0.00 146.90 14.69 E10 Materials & Supplies 2,935.00 2,187.90 0.00 747.10 25.45 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 428.00 0.00 572.00 57.20 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 Mise Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 221,000.00 147,333.36 73,666.67 -0.03 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 150,225.36 73,666.67 1,281.97 0.57 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-540060 Dues And Publications Cemetery Maintenance 30,000.00 19,175.31 9,460.00 1,364.69 4.55 10-532-540065 0.00 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 1,684.37 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 0.00 Clothing Expense 1,860.00 763.00 0.00 1,097.00 58.98 10-532-547010 7,566.25 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 0.00 Maintenance Agreements 800.00 519.26 57.08 223.66 27.96 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 10-533-529020 Repairs & Maintenance 34,030.00 21,741.57 9,517.08 2,771.35 8.14 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 494,361.28 342,340.41 83,183.75 68,837.12 13.92 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 141,845.17 112,650.55 0.00 29,194.62 20.58 10-533-501060 Seasonal Salaries 28,032.02 8,609.10 0.00 19,422.92 69.29 10-533-501090 Overtime 740.00 0.00 0.00 740.00 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 8,758.72 0.00 4,922.17 35.98 10-533-502020 Group Health Insurance 23,276.78 17,462.35 0.00 5,814.43 24.98 10-533-502030 Retirement 21,141.08 12,409.55 0.00 8,731.53 41.30 10-533-502040 Workers Compensation 1,874.09 0.00 0.00 1,874.09 100.00 10-533-502050 Life Insurance 276.13 150.07 0.00 126.06 45.65 10-533-502060 Long Term Disability 434.77 338.52 0.00 96.25 22.14 10-533-502070 Employee Assistance Prgm 78.58 54.72 0.00 23.86 30.36 E05 Personnel Services 231,639.51 160,433.58 0.00 71,205.93 30.74 10-533-511010 Advertising 106.23 106.23 0.00 0.00 0.00 10-533-511020 Postage 1,200.00 1,257.40 0.00 -57.40 -4.78 10-533-512010 Printing 254.00 254.00 0.00 0.00 0.00 10-533-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 900.00 692.43 0.00 207.57 23.06 10-533-514030 Small Tools 119.91 119.91 0.00 0.00 0.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 2,534.80 2,206.21 0.00 328.59 12.96 E10 Materials & Supplies 5,144.94 4,636.18 0.00 508.76 9.89 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,684.37 1,684.37 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 43,326.25 35,760.00 0.00 7,566.25 17.46 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 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-546010 Clothing Expense 1,591.69 1,235.00 0.00 356.69 22.41 E15 Contractual Services 68,825.60 61,259.35 0.00 7,566.25 10.99 10-533-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-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,591.69 1,235.00 0.00 356.69 22.41 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 750.00 462.88 107.47 179.65 23.95 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,641.69 1,967.88 107.47 566.34 21.44 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 308,251.74 228,296.99 107.47 79,847.28 25.90 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 218,020.35 161,507.32 0.00 56,513.03 25.92 10-534-501050 Parttime(wo Benefits) 21,639.39 0.00 0.00 21,639.39 100.00 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 370.00 0.00 0.00 370.00 100.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 18,737.83 11,295.27 0.00 7,442.56 39.72 10-534-502020 Group Health Insurance 46,436.05 34,255.38 0.00 12,180.67 26.23 10-534-502030 Retirement 32,331.40 23,903.14 0.00 8,428.26 26.07 10-534-502040 Workers Compensation 2,012.43 0.00 0.00 2,012.43 100.00 10-534-502050 Life Insurance 423.01 263.64 0.00 159.37 37.68 10-534-502060 Long Term Disability 662.67 544.73 0.00 117.94 17.80 10-534-502070 Employee Assistance Prgm 104.77 72.96 0.00 31.81 30.36 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 340,802.90 231,842.44 0.00 108,960.46 31.97 10-534-511010 Advertising 188.80 188.80 0.00 0.00 0.00 10-534-511020 Postage 1,000.00 919.65 0.00 80.35 8.04 10-534-512010 Printing 350.00 0.00 0.00 350.00 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 900.00 354.58 0.00 545.42 60.60 10-534-514030 Small Tools 150.00 39.88 0.00 110.12 73.41 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,415.41 67.24 0.00 1,348.17 95.25 E10 Materials & Supplies 4,034.21 1,570.15 0.00 2,464.06 61.08 10-534-520030 Dues And Publications 2,962.66 2,962.66 0.00 0.00 0.00 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 9,000.00 3,994.01 0.00 5,005.99 55.62 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-546010 Clothing Expense 1,727.33 1,018.00 0.00 709.33 41.07 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 11,962.66 6,956.67 0.00 5,005.99 41.85 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,727.33 1,018.00 0.00 709.33 41.07 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 575.00 643.91 111.03 -179.94 -31.29 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,592.33 1,931.91 111.03 549.39 21.19 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 359,392.10 242,301.17 111.03 116,979.90 32.55 535 Public Works -Central Maintenan 10-535-501020 Salaries 327,152.00 229,884.70 0.00 97,267.30 29.73 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 2,976.00 0.00 4,424.00 59.78 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 8,611.10 0.00 -4,111.10 -91.36 10-535-501095 Overtime Straight Pay 500.00 634.79 0.00 -134.79 -26.96 10-535-502010 Social Security 25,975.72 17,674.08 0.00 8,301.64 31.96 10-535-502020 Group Health Insurance 58,302.46 46,556.11 0.00 11,746.35 20.15 10-535-502030 Retirement 49,158.50 35,391.32 0.00 13,767.18 28.01 10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00 10-535-502050 Life Insurance 630.60 373.95 0.00 256.65 40.70 10-535-502060 Long Term Disability 989.73 770.40 0.00 219.33 22.16 10-535-502070 Employee Assistance Prgm 183.36 127.68 0.00 55.68 30.37 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 477,052.92 345,260.68 0.00 131,792.24 27.63 10-535-511010 Advertising 80.00 43.75 0.00 36.25 45.31 10-535-511020 Postage 50.00 5.33 0.00 44.67 89.34 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 2,083.28 2,312.78 0.00 -229.50 -11.02 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 8,000.00 5,197.53 0.00 2,802.47 35.03 10-535-517010 Operational Supplies 6,416.72 3,311.74 0.00 3,104.98 48.39 E10 Materials & Supplies 16,640.00 10,871.13 0.00 5,768.87 34.67 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtes & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-520070 Training And Education 2,000.00 1,597.14 0.00 402.86 20.14 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,500.00 1,597.14 0.00 902.86 36.11 10-535-531010 Electricity 7,560.00 4,612.91 0.00 2,947.09 38.98 10-535-533010 Natural Gas 8,400.00 5,395.38 0.00 3,004.62 35.77 10-535-534010 Telephone 220.00 199.20 0.00 20.80 9.45 10-535-535010 Water 1,400.00 936.68 0.00 463.32 33.09 E20 Utilities 17,580.00 11,144.17 0.00 6,435.83 36.61 10-535-540010 Building & Grounds Maint. 15,000.00 14,741.85 60.00 198.15 1.32 10-535-541010 Veh & Equip Parts Etc 480,000.00 417,724.55 0.00 62,275.45 12.97 10-535-546010 Clothing Expense 5,500.00 3,971.87 -2,970.54 4,498.67 81.79 10-535-547010 Equipment Maintenance 3,000.00 1,015.14 0.00 1,984.86 66.16 10-535-547020 Maintenance Agreements 7,300.00 8,463.91 0.00 -1,163.91 -15.94 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 510,900.00 445,917.32 -2,910.54 67,893.22 13.29 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,042,172.92 831,305.44 -2,910.54 213,778.02 20.51 540 Public Works -Admin 10-540-501020 Salaries 204,518.14 144,215.16 0.00 60,302.98 29.49 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 10,249.97 0.00 5,395.67 34.49 10-540-502020 Group Health Insurance 34,432.33 21,320.03 0.00 13,112.30 38.08 10-540-502030 Retirement 30,268.68 21,343.84 0.00 8,924.84 29.49 10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00 10-540-502050 Life Insurance 397.56 235.71 0.00 161.85 40.71 10-540-502060 Long Term Disability 530.48 410.17 0.00 120.31 22.68 10-540-502070 Employee Assistance Prgm 78.58 54.72 0.00 23.86 30.36 E05 Personnel Services 285,986.68 197,944.87 0.00 88,041.81 30.79 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 10.73 0.00 189.27 94.64 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 86,000.00 40,430.09 0.00 45,569.91 52.99 10-540-514040 Food 979.43 979.43 0.00 0.00 0.00 10-540-517010 Operational Supplies 1,300.00 6.50 0.00 1,293.50 99.50 E10 Materials & Supplies 89,779.43 41,426.75 0.00 48,352.68 53.86 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-520030 Dues And Publications 655.00 655.00 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,865.57 1,890.66 0.00 974.91 34.02 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,720.57 2,545.66 0.00 1,174.91 31.58 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 205.03 31.64 213.33 47.41 E25 Repairs & Maintenance 450.00 205.03 31.64 213.33 47.41 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 379,936.68 242,122.31 31.64 137,782.73 36.26 541 Public Works -Engineering 10-541-501020 Salaries 758,049.97 519,796.30 0.00 238,253.67 31.43 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 135.14 0.00 0.00 135.14 100.00 10-541-502010 Social Security 58,052.02 37,124.74 0.00 20,927.28 36.05 10-541-502020 Group Health Insurance 120,839.39 87,949.16 0.00 32,890.23 27.22 10-541-502030 Retirement 112,309.80 68,686.28 0.00 43,623.52 38.84 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 838.13 0.00 636.55 43.17 10-541-502060 Long Term Disability 2,301.79 1,720.70 0.00 581.09 25.25 10-541-502070 Employee Assistance Prgm 314.32 218.85 0.00 95.47 30.37 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,057,781.94 720,638.99 0.00 337,142.95 31.87 10-541-511010 Advertising 1,000.00 400.25 0.00 599.75 59.98 10-541-511020 Postage 400.00 245.28 0.00 154.72 38.68 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 5,800.00 4,635.52 0.00 1,164.48 20.08 10-541-514030 Small Tools 133.21 0.00 0.00 133.21 100.00 10-541-514040 Food 150.00 124.26 0.00 25.74 17.16 10-541-515040 First Aid Supplies 50.00 10.18 0.00 39.82 79.64 10-541-515070 Const & Inspect Supplies 2,000.00 491.67 0.00 1,508.33 75.42 10-541-515080 Surveying Supplies 2,000.00 726.17 0.00 1,273.83 63.69 10-541-517010 Operational Supplies 1,436.02 1,677.88 0.00 -241.86 -16.84 E10 Materials & Supplies 13,144.23 8,352.68 0.00 4,791.55 36.45 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-520030 Dues And Publications 4,478.60 4,508.60 0.00 -30.00 -0.67 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,000.00 2,303.01 0.00 696.99 23.23 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,302.17 733.00 0.00 2,569.17 77.80 10-541-522055 Stormwater Compliance 1,500.00 73.08 0.00 1,426.92 95.13 E15 Contractual Services 12,280.77 7,617.69 0.00 4,663.08 37.97 10-541-534010 Telephone 500.00 306.00 0.00 194.00 38.80 E20 Utilities 500.00 306.00 0.00 194.00 38.80 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 607.18 0.00 392.82 39.28 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,064.24 135.57 4,200.19 33.87 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,900.00 10,245.62 135.57 5,518.81 34.71 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 747,160.98 135.57 352,310.39 32.04 542 Public Works -Street 10-542-501020 Salaries 1,110,951.68 803,820.51 0.00 307,131.17 27.65 10-542-501060 Seasonal Salaries 18,000.00 10,175.00 0.00 7,825.00 43.47 10-542-501070 Stand-by Plan 5,000.00 3,180.00 0.00 1,820.00 36.40 10-542-501090 Overtime 34,763.36 25,698.49 0.00 9,064.87 26.08 10-542-501095 Overtime Straight Pay 736.64 785.07 0.00 -48.43 -6.57 10-542-502010 Social Security 89,463.05 62,544.94 0.00 26,918.11 30.09 10-542-502020 Group Health Insurance 189,300.56 135,181.47 0.00 54,119.09 28.59 10-542-502030 Retirement 170,414.84 108,382.46 0.00 62,032.38 36.40 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,257.80 0.00 899.20 41.69 10-542-502060 Long Term Disability 3,352.31 2,565.15 0.00 787.16 23.48 10-542-502070 Employee Assistance Prgm 667.42 464.70 0.00 202.72 30.37 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,172,915.68 0.00 470,843.27 28.64 10-542-511010 Advertising 633.15 676.90 0.00 -43.75 -6.91 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-511020 Purchase Of Vehicles Postage 150.00 28.24 0.00 121.76 81.17 10-542-512010 350,267.00 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 0.00 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 0.00 Office Supplies 1,600.00 1,375.79 0.00 224.21 14.01 10-542-514020 0.00 Chemicals 143,424.28 143,424.28 0.00 0.00 0.00 10-542-514030 0.00 Small Tools 9,000.00 7,821.06 0.00 1,178.94 13.10 10-542-514040 Food 2,000.00 1,929.48 0.00 70.52 3.53 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 355,358.09 204,353.49 48,024.75 102,979.85 28.98 10-542-515040 First Aid Supplies 500.00 285.10 0.00 214.90 42.98 10-542-515060 Weed Control 3,000.00 1,266.00 0.00 1,734.00 57.80 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 4,666.85 2,195.71 0.00 2,471.14 52.95 E10 Materials & Supplies 520,632.37 363,356.05 48,024.75 109,251.57 20.98 10-542-520030 Dues And Publications 950.00 950.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,234.74 3,234.74 0.00 0.00 0.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 18,415.26 13,386.50 1,500.00 3,528.76 19.16 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 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 23,300.00 17,648.30 1,500.00 4,151.70 17.82 10-542-531010 Electricity 27,593.00 16,181.82 0.00 11,411.18 41.36 10-542-531020 Street Lights 650,000.00 420,797.11 0.00 229,202.89 35.26 10-542-533010 Natural Gas 15,333.71 7,198.39 0.00 8,135.32 53.06 10-542-534010 Telephone 580.00 72.00 24.00 484.00 83.45 10-542-535010 Water 7,000.00 5,487.89 0.00 1,512.11 21.60 E20 Utilities 700,506.71 449,737.21 24.00 250,745.50 35.79 10-542-540010 Building & Grounds Maint. 14,014.77 13,851.08 250.00 -86.31 -0.62 10-542-541030 Vehicle Wash 7,000.00 6,639.00 0.00 361.00 5.16 10-542-542010 Repairs - StopStreet Lights 18,000.00 11,868.17 0.00 6,131.83 34.07 10-542-542030 Signs & Marking Paint 36,000.00 31,063.94 0.00 4,936.06 13.71 10-542-546010 Clothing Expense 10,000.00 7,387.02 0.00 2,612.98 26.13 10-542-547010 Equipment Maintenance 2,851.52 1,242.49 0.00 1,609.03 56.43 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 89,166.29 73,194.72 250.00 15,721.57 17.63 10-542-572010 Purchase Of Vehicles 322,590.00 231,601.00 0.00 90,989.00 28.21 10-542-572020 Purchase Of Equipment 350,267.00 316,267.00 0.00 34,000.00 9.71 10-542-573030 Purchimprov Landbuildin 20,773.85 0.00 20,773.85 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 693,630.85 547,868.00 20,773.85 124,989.00 18.02 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 542 Public Works -Street 3,670,995.17 2,624,719.96 70,572.60 975,702.61 26.58 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 Hlth Ins 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 Capvhclegp-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-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 396,891.29 209,603.20 167,529.06 19,759.03 4.98 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 0.00 0.00 300,000.00 100.00 10-990-577058 Downtown Electric 23,500.00 11,550.00 11,950.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 288,500.00 0.00 0.00 288,500.00 100.00 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 61,800.00 15,499.24 46,300.76 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 1,567,268.52 348,507.41 225,779.82 992,981.29 63.36 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 990 Expense Capital Projects Expense 1,567,268.52 35,828,987.69 348,507.41 24,707,944.76 225,779.82 5,609,477.92 992,981.29 5,511,565.01 63.36 15.38 GL - Trial Balance by Acct Type and Full Acct Number (08/03/2017 - 11:09 AM) Page 34