|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch
<br />Printed: 5/2/2023 3:34:07 PM
<br />Period 01 - 03
<br />Fiscal Year 2023
<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 285,610.00 71,402.50 57,918.59 43,423.92
<br />601-494-4102-000 Overtime - Water 7,000.00 1,750.00 2,006.92 2,147.24
<br />601-494-4105-000 On CallStandby 5,000.00 1,250.00 0.00 -344.35
<br />601-494-4106-000 Temporaries - Water 9,860.00 2,465.00 684.00 802.50
<br />601-494-4108-000 Wellness Program-Water 72.00 18.00 0.00 0.00
<br />601-494-4121-000 PERA 22,321.00 5,580.25 5,229.13 4,000.06
<br />601-494-4122-000 FICA Water 23,521.00 5,880.25 4,449.09 3,395.40
<br />601-494-4123-000 Def Comp Employer Contribution 145.00 36.25 0.00 101.49
<br />601-494-4131-000 Health Insurance 35,939.00 8,984.75 7,685.69 7,706.67
<br />601-494-4133-000 Life Insurance 905.00 226.25 165.99 193.50
<br />601-494-4134-000 Dental Insurance 2,481.00 620.25 689.04 530.33
<br />601-494-4151-000 Workers Compensation 10,406.00 2,601.50 6,972.00 3,918.00
<br />Personal Services 403,260.00 100,815.00 85,800.45 65,874.76
<br />Supplies
<br />601-494-4200-000 Office Supplies-Water 2,500.00 625.00 913.71 177.08
<br />601-494-4211-000 Maintenance Supplies-Water 45,000.00 11,250.00 1,618.05 6,700.64
<br />601-494-4212-000 Vehicle Fuel 12,000.00 3,000.00 0.00 0.00
<br />601-494-4215-000 Water Meters 150,000.00 37,500.00 6,106.56 10,605.80
<br />601-494-4216-000 Irrigation Controllers 20,000.00 5,000.00 0.00 19,798.90
<br />601-494-4222-000 Chemicals 125,000.00 31,250.00 16,410.14 11,751.94
<br />601-494-4240-000 Small ToolsEquip-Water 2,500.00 625.00 401.46 214.70
<br />Supplies 357,000.00 89,250.00 25,449.92 49,249.06
<br />Services & Charges
<br />601-494-4300-000 Professional Services-Water 100,300.00 25,075.00 15,118.40 10,873.83
<br />601-494-4301-000 Municipal Attorney 0.00 0.00 1,612.50 0.00
<br />601-494-4304-000 Municipal Engineer 25,000.00 6,250.00 1,144.50 1,559.09
<br />601-494-4308-000 Auditor 0.00 0.00 1,500.00 0.00
<br />601-494-4310-000 Other Consultant-Water 16,547.00 4,136.75 5,408.51 7,309.81
<br />601-494-4321-000 Telephone-Water 5,000.00 1,250.00 808.85 573.67
<br />601-494-4322-000 Postage-Water 5,500.00 1,375.00 596.92 596.60
<br />601-494-4330-000 TravelTuition-Water 4,500.00 1,125.00 97.50 0.00
<br />601-494-4340-000 Advertising-Water 10,000.00 2,500.00 0.00 188.07
<br />601-494-4345-000 Payment Processing 11,000.00 2,750.00 1,755.20 1,293.02
<br />601-494-4360-000 Insurance 26,840.00 6,710.00 17,316.00 7,646.00
<br />601-494-4363-000 Auto Insurance 1,000.00 250.00 645.00 629.00
<br />601-494-4370-000 Uniforms-Water 900.00 225.00 198.94 334.95
<br />601-494-4381-000 Electricity-Water 90,000.00 22,500.00 15,001.79 15,703.67
<br />601-494-4382-000 Utilities-Water 15,000.00 3,750.00 1,217.40 1,265.73
<br />601-494-4383-000 Heat-Water 5,000.00 1,250.00 898.31 967.76
<br />Services & Charges 316,587.00 79,146.75 63,319.82 48,941.20
<br />Contractual Services
<br />601-494-4410-000 Contracted Services-Water 64,495.00 16,123.75 1,625.25 773.99
<br />601-494-4452-000 SubscriptionsDues-Water 1,000.00 250.00 55.00 637.87
<br />Contractual Services 65,495.00 16,373.75 1,680.25 1,411.86
<br />Capital Outlay
<br />601-494-5000-000 Capital Outlay 0.00 0.00 -10,455.98 36,831.65
<br />Capital Outlay 0.00 0.00 -10,455.98 36,831.65
<br />Operating Transfers
<br />601-494-4910-000 Operating Transfers 980,020.00 245,005.00 0.00 0.00
<br />Operating Transfers 980,020.00 245,005.00 0.00 0.00
<br />GL - Budget to Actual (05/02/2023 - 03:34 PM)Page 122
|