|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch
<br />Printed: 10/14/2021 1:04:54 PM
<br />Period 01 - 09
<br />Fiscal Year 2021
<br />Account Number Description Budget YTD Budget End Bal One Year Prior
<br />Actual
<br />601 Water Operating
<br />Personal Services
<br />601-494-4101-000 Salaries - Water 221,373.00 166,029.75 154,309.89 144,293.90
<br />601-494-4102-000 Overtime - Water 7,000.00 5,250.00 4,905.31 4,719.44
<br />601-494-4105-000 On CallPager 4,996.00 3,747.00 -201.22 -132.69
<br />601-494-4106-000 Temporaries - Water 9,240.00 6,930.00 5,988.62 3,365.81
<br />601-494-4121-000 PERA 17,503.00 13,127.25 12,610.76 11,153.84
<br />601-494-4122-000 FICA 18,560.00 13,920.00 11,954.45 10,897.21
<br />601-494-4123-000 Def Comp Employer Contribution 294.00 220.50 0.00 132.15
<br />601-494-4131-000 Health Insurance 25,528.00 19,146.00 17,742.74 19,037.82
<br />601-494-4133-000 Life Insurance 1,027.00 770.25 618.32 527.44
<br />601-494-4134-000 Dental Insurance 1,753.00 1,314.75 1,284.21 1,204.03
<br />601-494-4151-000 Workers Compensation 5,463.00 4,097.25 5,395.00 5,130.00
<br />Personal Services 312,737.00 234,552.75 214,608.08 200,328.95
<br />Supplies
<br />601-494-4200-000 Office Supplies-Water 2,500.00 1,875.00 1,484.98 3,522.99
<br />601-494-4211-000 Maintenance Supplies-Water 45,000.00 33,750.00 29,082.34 24,399.17
<br />601-494-4212-000 Vehicle Fuel 10,000.00 7,500.00 0.00 0.00
<br />601-494-4215-000 Water Meters 80,000.00 60,000.00 64,691.60 48,320.22
<br />601-494-4216-000 Irrigation Controllers 20,000.00 15,000.00 18,999.00 0.00
<br />601-494-4222-000 Chemicals 80,000.00 60,000.00 105,473.00 69,002.08
<br />601-494-4240-000 Small ToolsEquip-Water 2,500.00 1,875.00 1,901.84 816.28
<br />Supplies 240,000.00 180,000.00 221,632.76 146,060.74
<br />Services & Charges
<br />601-494-4300-000 Professional Services-Water 125,000.00 93,750.00 49,045.49 74,682.72
<br />601-494-4301-000 Municipal Attorney 0.00 0.00 1,100.00 0.00
<br />601-494-4304-000 Municipal Engineer 25,000.00 18,750.00 13,540.75 167,630.35
<br />601-494-4310-000 Other Consultant-Water 11,347.00 8,510.25 9,415.30 8,928.50
<br />601-494-4321-000 Telephone-Water 5,000.00 3,750.00 2,607.34 3,217.25
<br />601-494-4322-000 Postage-Water 5,500.00 4,125.00 4,142.42 3,606.60
<br />601-494-4330-000 TravelTuition-Water 3,000.00 2,250.00 1,614.99 1,000.00
<br />601-494-4340-000 Advertising-Water 3,500.00 2,625.00 4,045.42 3,598.08
<br />601-494-4360-000 Insurance 10,374.00 7,780.50 10,111.00 9,514.00
<br />601-494-4363-000 Auto Insurance 700.00 525.00 941.00 783.00
<br />601-494-4370-000 Uniforms-Water 760.00 570.00 510.75 168.42
<br />601-494-4381-000 Electricity-Water 90,000.00 67,500.00 64,468.04 51,203.91
<br />601-494-4382-000 Utilities 15,000.00 11,250.00 3,377.57 3,402.51
<br />601-494-4383-000 Heat-Water 5,000.00 3,750.00 1,530.57 2,056.56
<br />Services & Charges 300,181.00 225,135.75 166,450.64 329,791.90
<br />Contractual Services
<br />601-494-4410-000 Contracted Services-Water 10,000.00 7,500.00 9,811.88 14,578.46
<br />601-494-4410-129 Contr Services-Phesant Hills 0.00 0.00 0.00 13,283.54
<br />601-494-4452-000 SubscriptionsDues-Water 1,000.00 750.00 1,487.00 580.00
<br />601-494-4510-000 Purchased Assets Dep 605,000.00 453,750.00 0.00 0.00
<br />Contractual Services 616,000.00 462,000.00 11,298.88 28,442.00
<br />Capital Outlay
<br />601-494-5000-000 Capital Outlay 55,000.00 41,250.00 86,928.32 293,233.89
<br />Capital Outlay 55,000.00 41,250.00 86,928.32 293,233.89
<br />601 Water Operating 1,523,918.00 1,142,938.50 700,918.68 997,857.48
<br />602 Sewer Operating
<br />Personal Services
<br />GL - Budget to Actual (10/14/2021 - 01:04 PM)Page 116
|