Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
March Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 1,096,015 PREPAID EXPENSES 10,032 ADVALOREM PROPERTY TAXES RECEIVABLE 34,828 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 4,804 UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,029 TOTAL ASSETS 1,148,708 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 39,632 ACCOUNTS AND OTHER PAYABLES 1,414 TOTAL LIABILITIES 41,046 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 611,974 TOTAL FUND BALANCE 1,107,662 TOTAL LIABILITIES AND FUND BALANCE 1,148,708 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 13:51 04/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 2,398.65- 305,154.18- 99.905 290.82- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 26,550.13- 905,529.05- 97.625 22,025.95- 122-40011-000-000 Property Taxes/Fire-Delinquent 328.21- 725.55- 725.55 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 158.86- 224.94- 29.992 525.06- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 1,944.91- 3,542.76- 78.728 957.24- Subtotal: 1,238,250.00- 1,238,250.00- 31,380.76- 1,215,177.13- 98.137 23,072.87- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 2,800.00- 46.667 3,200.00- Subtotal: 6,000.00- 6,000.00- 800.00- 2,800.00- 46.667 3,200.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 150.00- 525.00- 75.000 175.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 150.00- 525.00- 4.907 10,175.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 1,050.00- 4,475.00- 74.583 1,525.00- Subtotal: 6,000.00- 6,000.00- 1,050.00- 4,475.00- 74.583 1,525.00- Program number: 1,260,950.00- 1,260,950.00- 33,380.76- 1,222,977.13- 96.989 37,972.87- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 33,380.76- 1,222,977.13- 96.989 37,972.87- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 33,380.76- 1,222,977.13- 96.989 37,972.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 13:51 04/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 35,856.99 220,775.08 48.425 235,140.92 122-50010-045-000 Overtime 44,225.00 44,225.00 2,760.71 16,847.73 38.095 27,377.27 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 375.00 2,214.39 50.906 2,135.61 122-50020-045-000 Retirement 70,991.00 70,991.00 5,555.03 36,292.97 51.123 34,698.03 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,316.40 24,509.25 43.023 32,458.75 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 352.79 1,997.64 47.226 2,232.36 122-50028-045-000 Vision Insurance 892.00 892.00 69.55 415.80 46.614 476.20 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 340.68 1,869.41 43.986 2,380.59 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,203.70 14,822.55 44.944 18,157.45 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 515.26 3,465.67 44.933 4,247.33 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 1,468.27 1,535.98 67.994 723.02 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 3,976.74 45.668 4,731.26 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 54,477.17 346,873.79 48.658 366,005.21 122-55030-045-000 Software & Support 8,682.00 8,682.00 462.50 462.50 5.327 8,219.50 122-55045-045-000 Legal 5,000.00 5,000.00 2,505.51- -50.110 7,505.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 4,918.05 9,332.87 45.588 11,139.13 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 339.09 2,919.43 19.659 11,930.57 Subtotal: 49,004.00 49,004.00 5,719.64 10,209.29 20.834 38,794.71 122-60005-045-000 Telephone 100.00 100.00 3.34 3.340 96.66 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 214.52 1,388.27 32.765 2,848.73 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 792.73 3,680.03 56.030 2,887.97 122-60025-045-000 Water 1,500.00 1,500.00 52.39 407.02 27.135 1,092.98 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 3.36 29.89 29.890 70.11 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 6,097.50 50.351 6,012.50 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 8,197.64 54.003 6,982.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 224.00 2,270.00 53.037 2,010.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 525.41 1,525.41 76.271 474.59 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 1,812.01 39.589 2,764.99 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 200.00 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 341.17 7.582 4,158.83 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 150.00 150.00 10.000 1,350.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 662.50 832.75 41.638 1,167.25 122-60243-045-000 Prior Year Expense 3,456.54 3,456.54- . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 13:51 04/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 861.00- 359.97 35.997 640.03 Subtotal: 276,531.00 276,531.00 2,773.16 244,943.29 88.577 31,587.71 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 747.55 3,916.89 33.483 7,781.11 122-65010-045-000 Uniforms 3,360.00 3,360.00 1,066.31 1,386.15 41.254 1,973.85 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 803.00 1,651.87 21.735 5,948.13 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 198.29 344.73 13.789 2,155.27 122-65085-045-000 Office Supplies 1,000.00 1,000.00 76.78 161.22 16.122 838.78 122-65095-045-000 Maintenance Supplies 111.16- 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 2,780.77 7,460.86 27.371 19,797.14 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 50.000 1,515.50 122-69050-045-000 Radios 34,200.00 34,200.00 34,200.00 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 195,278.00 195,278.00 1,515.50 .776 193,762.50 Program number: 1,260,950.00 1,260,950.00 65,750.74 611,002.73 48.456 649,947.27 Department number: Fire 1,260,950.00 1,260,950.00 65,750.74 611,002.73 48.456 649,947.27 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 65,750.74 611,002.73 48.456 649,947.27 Fund number: 122 Trophy Club MUD Fire Dept. 32,369.98 611,974.40- 611,974.40 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 1011 03/04/2014 Property Taxes/Assessments (302,755.53) (77.79) (302,833.32) GL 1015 03/06/2014 Property Taxes/Assessments (670.94) (303,504.26) GL 1016 03/07/2014 Property Taxes/Assessments (192.20) (303,696.46) GL 1017 03/10/2014 Property Taxes/Assessments (406.13) (304,102.59) GL 1018 03/11/2014 Property Taxes/Assessments (238.90) (304,341.49) GL 1020 03/13/2014 Property Taxes/Assessments (94.76) (304,436.25) GL 1022 03/17/2014 Property Taxes/Assessments (144.47) (304,580.72) GL 1029 03/19/2014 Property Taxes/Assessments (55.71) (304,636.43) GL 1081 03/21/2014 Property Taxes/Assessments (359.69) (304,996.12) GL 1082 03/24/2014 Property Taxes/Assessments (89.55) (305,085.67) GL 1084 03/26/2014 Property Taxes/Assessments (17.05) (305,102.72) GL 1103 03/31/2014 Property Taxes/Assessments (51.46) (305,154.18) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (2,398.65) (305,154.18) ** (305,445.00) Budgeted (290.82) Remaining 100 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (.65) .00 (.65) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (.65) ** .00 Budgeted .65 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 953 03/03/2014 Property Taxes/Assessments (878,978.92) (40.42) (879,019.34) AP 1011 03/04/2014 Property Taxes/Assessments (300.06) (879,319.40) GL 1014 03/05/2014 Property Taxes/Assessments (233.22) (879,552.62) GL 1015 03/06/2014 Property Taxes/Assessments (19,100.00) (898,652.62) GL 1016 03/07/2014 Property Taxes/Assessments (1,463.63) (900,116.25) GL 1017 03/10/2014 Property Taxes/Assessments (69.10) (900,185.35) GL 1018 03/11/2014 Property Taxes/Assessments (883.56) (901,068.91) GL 1019 03/12/2014 Property Taxes/Assessments (162.47) (901,231.38) GL 1020 03/13/2014 Property Taxes/Assessments (146.21) (901,377.59) GL 1021 03/14/2014 Property Taxes/Assessments (118.41) (901,496.00) GL 1022 03/17/2014 Property Taxes/Assessments (451.27) (901,947.27) GL 1023 03/18/2014 Property Taxes/Assessments (268.90) (902,216.17) GL 1029 03/19/2014 Property Taxes/Assessments (169.14) (902,385.31) GL 1030 03/20/2014 Property Taxes/Assessments (31.65) (902,416.96) GL 1081 03/21/2014 Property Taxes/Assessments (624.93) (903,041.89) GL 1082 03/24/2014 Property Taxes/Assessments 144.13 (902,897.76) GL 1083 03/25/2014 Property Taxes/Assessments (730.75) (903,628.51) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1084 03/26/2014 Property Taxes/Assessments (878,978.92) (367.53) (903,996.04) GL 1085 03/27/2014 Property Taxes/Assessments (989.81) (904,985.85) GL 1102 03/28/2014 Property Taxes/Assessments (141.18) (905,127.03) GL 1103 03/31/2014 Property Taxes/Assessments (402.02) (905,529.05) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (26,550.13) (905,529.05) ** (927,555.00) Budgeted (22,025.95) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1017 03/10/2014 Property Taxes/Assessments (397.34) 67.93 (329.41) GL 1084 03/26/2014 Property Taxes/Assessments (396.14) (725.55) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (328.21) (725.55) ** .00 Budgeted 725.55 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1011 03/04/2014 Property Taxes/Assessments (66.08) (5.45) (71.53) GL 1015 03/06/2014 Property Taxes/Assessments (46.75) (118.28) GL 1016 03/07/2014 Property Taxes/Assessments (13.96) (132.24) GL 1017 03/10/2014 Property Taxes/Assessments (29.84) (162.08) GL 1018 03/11/2014 Property Taxes/Assessments (7.06) (169.14) GL 1020 03/13/2014 Property Taxes/Assessments (8.52) (177.66) GL 1022 03/17/2014 Property Taxes/Assessments (13.00) (190.66) GL 1081 03/21/2014 Property Taxes/Assessments (32.37) (223.03) GL 1103 03/31/2014 Property Taxes/Assessments (1.91) (224.94) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (158.86) (224.94) ** (750.00) Budgeted (525.06) Remaining 30 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 953 03/03/2014 Property Taxes/Assessments (1,597.85) (3.22) (1,601.07) AP 1011 03/04/2014 Property Taxes/Assessments (21.00) (1,622.07) GL 1014 03/05/2014 Property Taxes/Assessments (19.34) (1,641.41) GL 1015 03/06/2014 Property Taxes/Assessments (1,340.54) (2,981.95) GL 1016 03/07/2014 Property Taxes/Assessments (119.40) (3,101.35) GL 1017 03/10/2014 Property Taxes/Assessments (.57) (3,101.92) GL 1018 03/11/2014 Property Taxes/Assessments (71.92) (3,173.84) GL 1020 03/13/2014 Property Taxes/Assessments (10.61) (3,184.45) GL 1022 03/17/2014 Property Taxes/Assessments (17.47) (3,201.92) GL 1023 03/18/2014 Property Taxes/Assessments (20.86) (3,222.78) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1081 03/21/2014 Property Taxes/Assessments (1,597.85) (32.68) (3,255.46) GL 1082 03/24/2014 Property Taxes/Assessments (25.77) (3,281.23) GL 1083 03/25/2014 Property Taxes/Assessments (34.32) (3,315.55) GL 1084 03/26/2014 Property Taxes/Assessments (141.92) (3,457.47) GL 1085 03/27/2014 Property Taxes/Assessments (73.79) (3,531.26) GL 1103 03/31/2014 Property Taxes/Assessments (11.50) (3,542.76) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,944.91) (3,542.76) ** (4,500.00) Budgeted (957.24) Remaining 79 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (2,000.00) (800.00) (2,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (2,800.00) ** (6,000.00) Budgeted (3,200.00) Remaining 47 % Used Account: 122-43400-000-000 Fire Inspections 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (375.00) (150.00) (525.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (525.00) ** (700.00) Budgeted (175.00) Remaining 75 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (3,425.00) (1,050.00) (4,475.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,050.00) (4,475.00) ** (6,000.00) Budgeted (1,525.00) Remaining 75 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,222,977.13) ** (1,260,950.00) Budgeted (37,972.87) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1009 03/14/2014 FD Payroll 3/14/14 184,918.09 18,054.17 202,972.26 GL 1076 03/28/2014 FD 3/28/14 Payroll 17,802.82 220,775.08 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,856.99 220,775.08 ** 455,916.00 Budgeted 235,140.92 Remaining 48 % Used Account: 122-50010-045-000 Overtime 1009 03/14/2014 FD Payroll 3/14/14 14,087.02 2,760.71 16,847.73 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,760.71 16,847.73 ** 44,225.00 Budgeted 27,377.27 Remaining 38 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 1009 03/14/2014 FD Payroll 3/14/14 1,839.39 375.00 2,214.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 375.00 2,214.39 ** 4,350.00 Budgeted 2,135.61 Remaining 51 % Used Account: 122-50020-045-000 Retirement 1009 03/14/2014 FD Payroll 3/14/14 30,737.94 3,017.54 33,755.48 GL 1076 03/28/2014 FD 3/28/14 Payroll 2,537.49 36,292.97 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,555.03 36,292.97 ** 70,991.00 Budgeted 34,698.03 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1009 03/14/2014 FD Payroll 3/14/14 20,192.85 2,488.43 22,681.28 GL 1076 03/28/2014 FD 3/28/14 Payroll 1,827.97 24,509.25 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.40 24,509.25 ** 56,968.00 Budgeted 32,458.75 Remaining 43 % Used Account: 122-50027-045-000 Dental Insurance 1009 03/14/2014 FD Payroll 3/14/14 1,644.85 176.37 1,821.22 GL 1076 03/28/2014 FD 3/28/14 Payroll 176.42 1,997.64 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.79 1,997.64 ** 4,230.00 Budgeted 2,232.36 Remaining 47 % Used Account: 122-50028-045-000 Vision Insurance 1009 03/14/2014 FD Payroll 3/14/14 346.25 34.76 381.01 GL 1076 03/28/2014 FD 3/28/14 Payroll 34.79 415.80 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.55 415.80 ** 892.00 Budgeted 476.20 Remaining 47 % Used Account: 122-50029-045-000 Life Insurance & Other 1009 03/14/2014 FD Payroll 3/14/14 1,528.73 177.36 1,706.09 GL 1076 03/28/2014 FD 3/28/14 Payroll 163.32 1,869.41 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 340.68 1,869.41 ** 4,250.00 Budgeted 2,380.59 Remaining 44 % Used Account: 122-50030-045-000 Social Security Taxes 1009 03/14/2014 FD Payroll 3/14/14 12,618.85 1,206.81 13,825.66 GL 1076 03/28/2014 FD 3/28/14 Payroll 996.89 14,822.55 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,203.70 14,822.55 ** 32,980.00 Budgeted 18,157.45 Remaining 45 % Used Account: 122-50035-045-000 Medicare Taxes 1009 03/14/2014 FD Payroll 3/14/14 2,950.41 282.17 3,232.58 GL 1076 03/28/2014 FD 3/28/14 Payroll 233.09 3,465.67 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 515.26 3,465.67 ** 7,713.00 Budgeted 4,247.33 Remaining 45 % Used Account: 122-50040-045-000 Unemployment Taxes 1009 03/14/2014 FD Payroll 3/14/14 67.71 1,435.09 1,502.80 GL 1076 03/28/2014 FD 3/28/14 Payroll 33.18 1,535.98 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1,468.27 1,535.98 ** 2,259.00 Budgeted 723.02 Remaining 68 % Used Account: 122-50045-045-000 Workman's Compensation 121 03/01/2014 FD Mar W/C expense 3,313.95 662.79 3,976.74 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 3,976.74 ** 8,708.00 Budgeted 4,731.26 Remaining 46 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 1074 03/28/2014 Recode Charter Invoice 462.50 462.50 GL _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 462.50 ** 8,682.00 Budgeted 8,219.50 Remaining 5 % Used Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 5,000.00 Budgeted 7,505.51 Remaining -50 % Used Account: 122-55080-045-000 Maintenance & Repairs 1006 03/19/2014 March Firefighter cable 4,414.82 (133.82) 4,281.00 GL 1104 03/26/2014 2/27/14-3/26/14 PCards WILDFIRE TRUCK & EQUIP 250.20 4,531.20 WILDFIRE TRUCK & EQUIP PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 12.45 4,543.65 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards TRACTOR SUPPLY COMPANY 63.67 4,607.32 TRACTOR SUPPLY COMPANY PC 1104 03/26/2014 2/27/14-3/26/14 PCards AT&T*BILL PAYMENT 133.82 4,741.14 AT&T*BILL PAYMENT PC 1104 03/26/2014 2/27/14-3/26/14 PCards AT&T*BILL PAYMENT 157.97 4,899.11 AT&T*BILL PAYMENT PC 1104 03/26/2014 2/27/14-3/26/14 PCards SAMSCLUB #4795 17.58 4,916.69 SAMSCLUB #4795 PC 1060 03/26/2014 Mar A/P Rug Service 24.51 4,941.20 G & K SERVICES 33593 AP 1060 03/26/2014 Mar A/P Rug Service 24.51 4,965.71 G & K SERVICES 33593 AP 1060 03/26/2014 Mar A/P 2014 SCBA NFPA Flow Test 2,400.90 7,366.61 MUNICIPAL EMERGENCY SERVICES 33602 AP 1060 03/26/2014 Mar A/P SCBA Repair 1,721.00 9,087.61 MUNICIPAL EMERGENCY SERVICES 33602 AP 1060 03/26/2014 Mar A/P Single air Text 146.35 9,233.96 AUGUST INDUSTRIES, INC 33587 AP 1073 03/27/2014 Reclassify Maintenance Supplie Sam's Club expenses 111.16 9,345.12 GL 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (36.76) 9,308.36 AR 1126 03/31/2014 Recode unbudgeted expenses 111.16 9,419.52 GL 1127 03/31/2014 Rev JE1126 unbudgeted expenses (111.16) 9,308.36 GL 1132 03/31/2014 March A/P Rug Service 24.51 9,332.87 G & K SERVICES AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 4,918.05 9,332.87 ** 20,472.00 Budgeted 11,139.13 Remaining 46 % Used Account: 122-55090-045-000 Vehicle Maintenance 1104 03/26/2014 2/27/14-3/26/14 PCards UNITY MANUFACTURING CO 2,580.34 171.84 2,752.18 UNITY MANUFACTURING CO PC 1060 03/26/2014 Mar A/P Repair Trimmer valve on CAFS S 167.25 2,919.43 SIDDONS-MARTIN EMERGENCY GROUP 33606 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 339.09 2,919.43 ** 14,850.00 Budgeted 11,930.57 Remaining 20 % Used Account: 122-60005-045-000 Telephone 3.34 .00 3.34 _______________ Account: 122-60005-045-000 Telephone Totals: .00 3.34 ** 100.00 Budgeted 96.66 Remaining 3 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1009 03/14/2014 FD Payroll 3/14/14 1,173.75 75.00 1,248.75 GL 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 139.52 1,388.27 TOWN OF TROPHY CLUB 33582 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.52 1,388.27 ** 4,237.00 Budgeted 2,848.73 Remaining 33 % Used Account: 122-60020-045-000 Electricity/Gas 994 03/18/2014 Mar A/P Electricity 2/11-3/12/14 2,887.30 785.33 3,672.63 HUDSON ENERGY SERVICES, LLC 33564 AP 1060 03/26/2014 Mar A/P Fire Station Electricity 2/20- 359.96 4,032.59 ATMOS ENERGY 33586 AP 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (572.64) 3,459.95 AR 1132 03/31/2014 March A/P March water 220.08 3,680.03 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 792.73 3,680.03 ** 6,568.00 Budgeted 2,887.97 Remaining 56 % Used Account: 122-60025-045-000 Water 954 03/07/2014 AP-March 354.63 116.42 471.05 TROPHY CLUB MUD (WATER BILLS) 33547 AP 954 03/07/2014 AP-March water 46.01 517.06 TROPHY CLUB MUD (WATER BILLS) 33547 AP 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (110.04) 407.02 AR _______________ Account: 122-60025-045-000 Water Totals: 52.39 407.02 ** 1,500.00 Budgeted 1,092.98 Remaining 27 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1116 03/31/2014 MUD/FD Postage meter usage/Mar 26.53 3.36 29.89 GL _______________ Account: 122-60035-045-000 Postage Totals: 3.36 29.89 ** 100.00 Budgeted 70.11 Remaining 30 % Used Account: 122-60055-045-000 Insurance 52 03/01/2014 Mar Ins & W/C Expense 5,088.25 1,009.25 6,097.50 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 6,097.50 ** 12,110.00 Budgeted 6,012.50 Remaining 50 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 8,197.64 .00 8,197.64 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 8,197.64 ** 15,180.00 Budgeted 6,982.36 Remaining 54 % Used Account: 122-60080-045-000 Schools & Training 1104 03/26/2014 2/27/14-3/26/14 PCards ROANOKE AUTO SUPPLY LT 2,046.00 19.00 2,065.00 ROANOKE AUTO SUPPLY LT PC 1060 03/26/2014 Mar A/P Instructor II test fee/Steve R 85.00 2,150.00 TX COMM ON FIRE PROTECTION 33610 AP 1060 03/26/2014 Mar A/P Incident command module 35.00 2,185.00 ROBERT PENNY 33605 AP 1092 03/31/2014 Mar A/P E Sampson, Driver Operator/Pum 85.00 2,270.00 TX COMM ON FIRE PROTECTION 33647 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 224.00 2,270.00 ** 4,280.00 Budgeted 2,010.00 Remaining 53 % Used Account: 122-60096-045-000 Emergency Management 994 03/18/2014 Mar A/P Food for Fire fighters (Big Fi 1,000.00 178.64 1,178.64 Jo Ann Jones 33568 AP 994 03/18/2014 Mar A/P Food bought for Firefighters a 346.77 1,525.41 Robert Radder 33575 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 525.41 1,525.41 ** 2,000.00 Budgeted 474.59 Remaining 76 % Used Account: 122-60100-045-000 Travel & per diem 1,812.01 .00 1,812.01 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,812.01 ** 4,577.00 Budgeted 2,764.99 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 341.17 .00 341.17 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 994 03/18/2014 Mar A/P Fire Marshal Training 75.00 75.00 TARRANT COUNTY COLLEGE 33578 AP 994 03/18/2014 Mar A/P Fire Marshal Training 75.00 150.00 TARRANT COUNTY COLLEGE 33578 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 150.00 150.00 ** 1,500.00 Budgeted 1,350.00 Remaining 10 % Used Account: 122-60195-045-000 Flags & Repair 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 170.25 625.00 795.25 TOWN OF TROPHY CLUB 33582 AP 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 37.50 832.75 TOWN OF TROPHY CLUB 33609 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 662.50 832.75 ** 2,000.00 Budgeted 1,167.25 Remaining 42 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** .00 Budgeted (3,456.54) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60245-045-000 Miscellaneous Expense 1039 03/24/2014 Correct JE860/Town Inv DCADfee 1,220.97 (861.00) 359.97 GL _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: (861.00) 359.97 ** 1,000.00 Budgeted 640.03 Remaining 36 % Used Account: 122-65005-045-000 Fuel & Lube 1114 03/31/2014 MUD/FD Gaslog/March 3,169.34 747.55 3,916.89 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 747.55 3,916.89 ** 11,698.00 Budgeted 7,781.11 Remaining 33 % Used Account: 122-65010-045-000 Uniforms 994 03/18/2014 Mar A/P New badges/Uniforms 319.84 343.80 663.64 CW NIELSEN MANUFACTURING, INC 33558 AP 1060 03/26/2014 Mar A/P Uniforms 179.56 843.20 GST PUBLIC SAFETY SUPPLY 33594 AP 1060 03/26/2014 Mar A/P Uniforms 275.01 1,118.21 GST PUBLIC SAFETY SUPPLY 33594 AP 1060 03/26/2014 Mar A/P Uniforms 577.35 1,695.56 GST PUBLIC SAFETY SUPPLY 33594 AP 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (309.41) 1,386.15 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 1,066.31 1,386.15 ** 3,360.00 Budgeted 1,973.85 Remaining 41 % Used Account: 122-65015-045-000 Protective Clothing 1060 03/26/2014 Mar A/P Boots, Gloves Hawkins & Farrel 848.87 803.00 1,651.87 CASCO INDUSTRIES INC 33590 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 803.00 1,651.87 ** 7,600.00 Budgeted 5,948.13 Remaining 22 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 1104 03/26/2014 2/27/14-3/26/14 PCards HAZ-MAT DQE 146.44 198.29 344.73 HAZ-MAT DQE PC _______________ Account: 122-65035-045-000 Small Tools Totals: 198.29 344.73 ** 2,500.00 Budgeted 2,155.27 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65085-045-000 Office Supplies 994 03/18/2014 Mar A/P Office Supplies 84.44 16.84 101.28 OFFICE DEPOT, INC 33571 AP 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 59.94 161.22 THE HOME DEPOT 6581 PC _______________ Account: 122-65085-045-000 Office Supplies Totals: 76.78 161.22 ** 1,000.00 Budgeted 838.78 Remaining 16 % Used Account: 122-65095-045-000 Maintenance Supplies 1073 03/27/2014 Reclassify Maintenance Supplie Sam's Club expenses 111.16 (111.16) .00 GL 1126 03/31/2014 Recode unbudgeted expenses (111.16) (111.16) GL 1127 03/31/2014 Rev JE1126 unbudgeted expenses 111.16 .00 GL _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: (111.16) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest 1,515.50 .00 1,515.50 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 1,515.50 ** 3,031.00 Budgeted 1,515.50 Remaining 50 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 34,200.00 Budgeted 34,200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 611,002.73 ** 1,260,950.00 Budgeted 649,947.27 Remaining 48 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (611,974.40) .00 Budgeted 611,974.40 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 3/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 172,439 - - 172,439 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,502,290 - - 1,502,290 INVESTMENTS-TEXPOOL 938,713 313,050 162,522 1,414,284 PREPAID EXPENSES 47,880 - - 47,880 ADVALOREM PROPERTY TAXES RECEIVABLE 4,079 - - 4,079 UTILITY AND OTHER ACCOUNTS RECEIVABLE 499,483 - - 499,483 - TOTAL ASSETS 3,165,484 313,050 162,522 3,641,056 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,079 - - 4,079 ACCOUNTS AND OTHER PAYABLES 427,381 - - 427,381 CUSTOMER DEPOSITS 250,222 - - 250,222 - TOTAL LIABILITIES 681,683 - - 681,683 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (504,674) - (82,579) (587,254) - TOTAL FUND BALANCE 2,483,801 313,050 162,522 2,959,373 - TOTAL LIABILITIES AND FUND BALANCE 3,165,484 313,050 162,522 3,641,056 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 2,840.95- 96,938.43- 97.671 2,311.57- 135-40002-000-000 Property Taxes/Delinquent 32.36- 33.83- 33.83 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 204.19- 351.42- 39.047 548.58- Subtotal: 100,150.00- 100,150.00- 3,077.50- 97,323.68- 97.178 2,826.32- 135-43215-000-000 Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 213,499.66- 1,137,814.47- 30.347 2,611,495.53- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 152,715.70- 850,727.58- 49.799 857,593.42- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 3,840.43- 24,326.84- 37.703 40,195.16- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 353.00- 4,018.00- 44.275 5,057.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 600.00- 1,500.00- 125.000 300.00 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 1,800.00- 4,650.00- 105.682 250.00 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 1,972.60- 10,025.78- 12.597 69,560.22- Subtotal: 5,616,414.00- 5,616,414.00- 374,781.39- 2,033,062.67- 36.199 3,583,351.33- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 11,500.00- 186,300.00- 32.004 395,809.00- Subtotal: 582,109.00- 582,109.00- 11,500.00- 186,300.00- 32.004 395,809.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 501.10- 3,044.00- 63.417 1,756.00- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 5,463.18- 53.750 4,700.82- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49030-000-000 Vending Revenue 350.00- 350.00- 48.00- 146.00- 41.714 204.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 9,075.71- 46,104.48- 54.886 37,895.52- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 1,158.08- 38.603 1,841.92- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49903-000-000 Recovery of Prior Year Expense 4,087.00- 4,087.00 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 11,118.67- 63,502.72- 53.246 55,761.28- Program number: 6,417,937.00- 6,417,937.00- 400,477.56- 2,380,271.43- 37.088 4,037,665.57- Department number: Revenues 6,417,937.00- 6,417,937.00- 400,477.56- 2,380,271.43- 37.088 4,037,665.57- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 400,477.56- 2,380,271.43- 37.088 4,037,665.57- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 21,716.28 128,804.69 44.769 158,904.31 135-50010-010-000 Overtime 13,391.00 13,391.00 2,619.44 10,526.49 78.609 2,864.51 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 2,025.00 39.706 3,075.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,219.02 13,578.22 48.760 14,268.78 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,799.98 19,140.57 39.601 29,193.43 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 1,427.85 36.314 2,504.15 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 343.96 39.400 529.04 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 234.03 1,236.13 37.391 2,069.87 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,520.69 9,404.86 48.758 9,884.14 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 355.65 2,199.53 48.759 2,311.47 135-50040-010-000 Unemployment Taxes 54.00 54.00 1,191.79 1,244.44 2,304.519 1,190.44- 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 4,814.70 48.985 5,014.30 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 233.90 116.950 33.90- 135-50070-010-000 Employee Relations 300.00 300.00 107.78 35.927 192.22 Subtotal: 429,580.00 429,580.00 35,146.48 199,993.12 46.556 229,586.88 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 6,868.90- 31,766.52 63.533 18,233.48 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 688.65 2,479.60 49.592 2,520.40 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 248.33 7.095 3,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 205.00 1,195.00 21.727 4,305.00 Subtotal: 67,000.00 67,000.00 5,975.25- 35,689.45 53.268 31,310.55 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 383.37 1,914.56 38.969 2,998.44 135-60020-010-000 Electricity 162,160.00 162,160.00 6,223.74 47,457.25 29.266 114,702.75 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 289.00 192.667 139.00- 135-60080-010-000 Schools & Training 4,184.00 4,184.00 295.00 1,065.00 25.454 3,119.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,450.00 1,450.00 171.13 11.802 1,278.87 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 24.00 4.800 476.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 32,195.79 67.924 15,204.21 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 121,206.18 625,678.69 26.756 1,712,794.31 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 411.50 1,090.20 31.149 2,409.80 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 1,664.20 1,664.20 47.549 1,835.80 Subtotal: 2,567,580.00 2,567,580.00 130,183.99 711,549.82 27.713 1,856,030.18 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 1,037.93 5,808.63 25.058 17,372.37 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 3,270.00 106.95 1,938.58 59.284 1,331.42 135-65030-010-000 Chemicals 5,000.00 5,000.00 2,667.29 53.346 2,332.71 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 322.67 32.267 677.33 135-65050-010-000 Meter Expense 143,550.00 143,550.00 895.00 60,287.12 41.997 83,262.88 Subtotal: 177,201.00 177,201.00 2,039.88 71,489.23 40.344 105,711.77 135-69005-010-000 Capital Outlays 37,000.00 37,000.00 35,679.59 35,679.59 96.431 1,320.41 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 122,980.00 25.099 367,000.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 11,621.26 60.314 7,646.74 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 7,500.00 7,500.00 135-69281-010-000 Water Tank Inspection Contract 106,847.00 106,847.00 100,816.54 94.356 6,030.46 Subtotal: 690,595.00 690,595.00 170,280.85 271,097.39 39.256 419,497.61 Program number: 3,931,956.00 3,931,956.00 331,675.95 1,289,819.01 32.803 2,642,136.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis 1,000.00 1,000.00 100.00 698.49 69.849 301.51 Subtotal: 1,000.00 1,000.00 100.00 698.49 69.849 301.51 135-60135-010-001 TCEQ Fees & Permits 130.00 2,496.19 2,496.19- Subtotal: 130.00 2,496.19 2,496.19- Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 230.00 3,194.68 319.468 2,194.68- Department number: Water 3,932,956.00 3,932,956.00 331,905.95 1,293,013.69 32.876 2,639,942.31 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,174.92 93,899.32 46.280 108,994.68 135-50010-020-000 Overtime 11,965.00 11,965.00 1,229.95 7,104.10 59.374 4,860.90 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 2,400.00 50.000 2,400.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,509.09 10,023.16 50.355 9,881.84 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,798.07 20,107.80 46.256 23,363.20 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,313.52 43.945 1,675.48 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 303.57 46.135 354.43 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 185.56 1,036.49 45.006 1,266.51 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 884.98 6,152.60 44.568 7,652.40 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 206.97 1,438.91 44.562 1,790.09 135-50040-020-000 Unemployment Taxes 36.00 36.00 793.50 828.00 2,300.000 792.00- 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 3,210.48 49.000 3,341.52 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 59.99 17.140 290.01 Subtotal: 316,105.00 316,105.00 24,980.76 150,938.44 47.749 165,166.56 135-55070-020-000 Independent Labor 107,890.00 460,866.25 460,866.25- 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 4,672.91 23,694.47 67.698 11,305.53 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 9.97 1,227.46 61.373 772.54 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 52,000.00 52,000.00 8,327.91 24,774.65 47.644 27,225.35 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 5,367.13 15,851.26 52.838 14,148.74 Subtotal: 119,500.00 119,500.00 126,267.92 526,414.09 440.514 406,914.09- 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 306.74 1,229.56 36.935 2,099.44 135-60020-020-000 Electricity 148,227.00 148,227.00 8,776.81 48,641.88 32.816 99,585.12 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 191.00 351.00 87.750 49.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 295.00 517.00 19.613 2,119.00 135-60090-020-000 Safety Program 250.00 250.00 60.69 432.07 172.828 182.07- 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 26.72 292.81 27.887 757.19 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020-000 Prior Year Expense 3,554.22 3,554.22 3,554.22- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 3,000.00 1,079.10 1,079.10 35.970 1,920.90 Subtotal: 178,242.00 178,242.00 14,290.28 65,316.17 36.645 112,925.83 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 1,251.53 5,322.90 36.161 9,397.10 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 39,000.00 39,000.00 3,840.00 14,158.12 36.303 24,841.88 135-65035-020-000 Small Tools 1,000.00 1,000.00 91.00 9.100 909.00 135-65040-020-000 Safety Equipment 250.00 250.00 230.63 92.252 19.37 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 1,259.50 6,643.08 44.287 8,356.92 Subtotal: 71,722.00 71,722.00 6,351.03 27,883.00 38.876 43,839.00 135-69005-020-000 Capital Outlays 31,000.00 31,000.00 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 20,020.00 100.000 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 1,043.70 73.397 378.30 135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00 Subtotal: 82,442.00 82,442.00 21,063.70 21,063.70 25.550 61,378.30 Program number: 768,011.00 768,011.00 192,953.69 791,615.40 103.073 23,604.40- Department number: Wastewater 768,011.00 768,011.00 192,953.69 791,615.40 103.073 23,604.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 6,706.16 33,175.64 36.740 57,123.36 135-50010-021-000 Overtime 10,028.00 10,028.00 225.63 2,359.14 23.526 7,668.86 135-50016-021-000 Longevity 17,913.00 17,913.00 2,107.50 11.765 15,805.50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 900.00 50.000 900.00 135-50020-021-000 Retirement 9,025.00 9,025.00 635.95 3,816.10 42.284 5,208.90 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,616.35 9,673.89 40.873 13,994.11 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 710.19 41.702 992.81 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 146.89 46.780 167.11 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 71.54 539.49 50.609 526.51 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 397.31 2,378.88 31.966 5,063.12 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 92.92 556.35 31.956 1,184.65 135-50040-021-000 Unemployment Taxes 198.00 198.00 292.97 303.15 153.106 105.15- 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 1,605.24 49.000 1,670.76 135-50070-021-000 Employee Relations 200.00 200.00 132.02 66.010 67.98 Subtotal: 168,673.00 168,673.00 10,582.65 58,404.48 34.626 110,268.52 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 23,801.00 1,123.20 4,114.48 17.287 19,686.52 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 49.959 1,000.82 Subtotal: 27,301.00 27,301.00 1,123.20 5,113.66 18.731 22,187.34 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.68 686.40 51.493 646.60 135-60020-021-000 Electricity 21,178.00 21,178.00 1,890.47 10,039.63 47.406 11,138.37 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 1,711.00 1,711.00 135-60090-021-000 Safety Program 300.00 300.00 300.00 135-60100-021-000 Travel & per diem 550.00 550.00 550.00 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 35,422.00 1,993.15 10,726.03 30.281 24,695.97 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 876.65 5,890.25 26.299 16,506.75 135-65010-021-000 Uniforms 1,040.00 1,040.00 814.23 78.291 225.77 135-65030-021-000 Chemicals 6,000.00 6,000.00 6,000.00 135-65035-021-000 Small Tools 1,000.00 1,000.00 43.99 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 586.73 117.346 86.73- Subtotal: 30,937.00 30,937.00 876.65 7,335.20 23.710 23,601.80 135-69005-021-000 Capital Outlays 100,000.00 100,000.00 68,300.20 68.300 31,699.80 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 71,000.00 71,000.00 Subtotal: 209,837.00 209,837.00 68,300.20 32.549 141,536.80 Program number: 472,170.00 472,170.00 14,575.65 149,879.57 31.743 322,290.43 Department number: Collection 472,170.00 472,170.00 14,575.65 149,879.57 31.743 322,290.43 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,500.00 5,200.00 52.000 4,800.00 135-50030-026-000 Social Security Taxes 620.00 620.00 93.00 322.40 52.000 297.60 135-50035-026-000 Medicare Taxes 145.00 145.00 21.75 75.40 52.000 69.60 135-50040-026-000 Unemployment Taxes 10.00 10.00 60.90 64.60 646.000 54.60- 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 17.70 49.167 18.30 Subtotal: 10,811.00 10,811.00 1,678.60 5,680.10 52.540 5,130.90 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 35.95 2.996 1,164.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 265.00 6.625 3,735.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 335.95 2.835 11,514.05 Program number: 22,661.00 22,661.00 1,678.60 6,016.05 26.548 16,644.95 Department number: Board of Directors 22,661.00 22,661.00 1,678.60 6,016.05 26.548 16,644.95 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 34,600.02 213,533.71 46.550 245,187.29 135-50010-030-000 Overtime 500.00 500.00 218.89 567.53 113.506 67.53- 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,126.73 20,475.38 49.435 20,943.62 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 5,209.37 27,745.66 47.901 30,177.34 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 2,180.28 42.751 2,919.72 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 492.45 45.304 594.55 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 348.39 2,538.68 56.629 1,944.32 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,025.00 13,395.05 46.739 15,263.95 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 473.59 3,132.73 46.743 3,569.27 135-50040-030-000 Unemployment Taxes 63.00 63.00 1,390.82 1,449.00 2,300.000 1,386.00- 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 771.78 49.002 803.22 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 27.95 2,662.55 53.251 2,337.45 Subtotal: 614,450.00 614,450.00 47,971.43 292,022.30 47.526 322,427.70 135-55030-030-000 Software & Support 59,698.00 59,698.00 671.63 21,023.82 35.217 38,674.18 135-55070-030-000 Independent Labor 7,700.00 7,700.00 2,545.53 4,923.48 63.941 2,776.52 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 1,961.91 12.94 .288 4,487.06 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 36.57 1,930.43 29.699 4,569.57 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 3,189.94 9,569.82 49.999 9,570.18 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Town Personnel Contract 77,048.00 77,048.00 38,524.00 77,048.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 569.72 2,900.07 42.598 3,907.93 Subtotal: 196,594.00 196,594.00 47,499.30 117,408.56 59.721 79,185.44 135-60005-030-000 Telephone 11,250.00 11,250.00 1,219.89 6,207.25 55.176 5,042.75 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 323.13 1,493.59 41.616 2,095.41 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 924.40- 6,319.18 41.653 8,851.82 135-60025-030-000 Water 1,500.00 1,500.00 202.08 430.16 28.677 1,069.84 135-60035-030-000 Postage 28,500.00 28,500.00 1,974.74 11,004.03 38.611 17,495.97 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,602.16 14,666.48 51.770 13,663.52 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 484.71 4,197.27 279.818 2,697.27- 135-60055-030-000 Insurance 53,561.00 53,561.00 4,314.73 25,746.63 48.070 27,814.37 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 275.08 401.08 40.108 598.92 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 4,011.95 89.154 488.05 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 274.83 274.83 274.83- 135-60080-030-000 Schools & Training 7,500.00 7,500.00 450.00 1,651.30 22.017 5,848.70 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 119.26 822.42 16.448 4,177.58 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00 135-60125-030-000 Advertising 2,500.00 2,500.00 80.81 589.43 23.577 1,910.57 135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 22,870.00 29.71 376.25 1.645 22,493.75 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 204,221.00 204,221.00 11,426.73 78,315.41 38.348 125,905.59 135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 432.38 2,178.04 16.060 11,383.96 135-65085-030-000 Office Supplies 9,100.00 9,100.00 274.30 2,367.74 26.019 6,732.26 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 227.42 1,473.75 25.711 4,258.25 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 357.90 1,469.39 58.776 1,030.61 135-65097-030-000 Vending Machine Supplies 200.00 200.00 25.96 76.96 38.480 123.04 135-65105-030-000 Printing 4,000.00 4,000.00 947.27 2,348.27 58.707 1,651.73 Subtotal: 36,484.00 36,484.00 2,265.23 10,913.05 29.912 25,570.95 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,284.25 37.225 2,165.75 Subtotal: 3,450.00 3,450.00 256.85 1,284.25 37.225 2,165.75 Program number: 1,055,199.00 1,055,199.00 109,419.54 499,943.57 47.379 555,255.43 Department number: Administration 1,055,199.00 1,055,199.00 109,419.54 499,943.57 47.379 555,255.43 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 13:51 04/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 131,300.00 17,773.83 114,582.30 87.268 16,717.70 135-55055-039-000 Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 1,914.46 6,243.84 62.438 3,756.16 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 166,940.00 19,688.29 144,477.54 86.545 22,462.46 Program number: 166,940.00 166,940.00 19,688.29 144,477.54 86.545 22,462.46 Department number: Non Departmental 166,940.00 166,940.00 19,688.29 144,477.54 86.545 22,462.46 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 670,221.72 2,884,945.82 44.951 3,532,991.18 Fund number: 135 MUD 1 General Fund 269,744.16 504,674.39 504,674.39- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 13:51 04/07/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 4.15- 50.84- 50.84 Subtotal: 4.15- 50.84- 50.84 Program number: 4.15- 50.84- 50.84 Department number: 4.15- 50.84- 50.84 Revenues Subtotal ----------- 4.15- 50.84- 50.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 13:51 04/07/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- Department number: Water 82,629.40 82,629.40- Expenditures Subtotal ----------- 82,629.40 82,629.40- Fund number: 507 MUD 1 Capital Projects 4.15- 82,578.56 82,578.56- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 953 03/03/2014 Property Taxes/Assessments (94,097.48) (4.32) (94,101.80) AP 1011 03/04/2014 Property Taxes/Assessments (32.11) (94,133.91) GL 1014 03/05/2014 Property Taxes/Assessments (24.96) (94,158.87) GL 1015 03/06/2014 Property Taxes/Assessments (2,043.77) (96,202.64) GL 1016 03/07/2014 Property Taxes/Assessments (156.61) (96,359.25) GL 1017 03/10/2014 Property Taxes/Assessments (7.39) (96,366.64) GL 1018 03/11/2014 Property Taxes/Assessments (94.54) (96,461.18) GL 1019 03/12/2014 Property Taxes/Assessments (17.38) (96,478.56) GL 1020 03/13/2014 Property Taxes/Assessments (15.64) (96,494.20) GL 1021 03/14/2014 Property Taxes/Assessments (12.67) (96,506.87) GL 1022 03/17/2014 Property Taxes/Assessments (48.29) (96,555.16) GL 1023 03/18/2014 Property Taxes/Assessments (28.77) (96,583.93) GL 1029 03/19/2014 Property Taxes/Assessments (18.10) (96,602.03) GL 1030 03/20/2014 Property Taxes/Assessments (3.39) (96,605.42) GL 1081 03/21/2014 Property Taxes/Assessments (66.87) (96,672.29) GL 1082 03/24/2014 Property Taxes/Assessments 15.42 (96,656.87) GL 1083 03/25/2014 Property Taxes/Assessments (78.19) (96,735.06) GL 1084 03/26/2014 Property Taxes/Assessments (39.33) (96,774.39) GL 1085 03/27/2014 Property Taxes/Assessments (105.91) (96,880.30) GL 1102 03/28/2014 Property Taxes/Assessments (15.11) (96,895.41) GL 1103 03/31/2014 Property Taxes/Assessments (43.02) (96,938.43) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,840.95) (96,938.43) ** (99,250.00) Budgeted (2,311.57) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1014 03/05/2014 Property Taxes/Assessments (1.47) (2.07) (3.54) GL 1017 03/10/2014 Property Taxes/Assessments 6.46 2.92 GL 1084 03/26/2014 Property Taxes/Assessments (36.75) (33.83) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (32.36) (33.83) ** .00 Budgeted 33.83 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 953 03/03/2014 Property Taxes/Assessments (147.23) (.35) (147.58) AP 1011 03/04/2014 Property Taxes/Assessments (2.25) (149.83) GL 1015 03/06/2014 Property Taxes/Assessments (143.45) (293.28) GL 1016 03/07/2014 Property Taxes/Assessments (12.78) (306.06) GL 1017 03/10/2014 Property Taxes/Assessments (.06) (306.12) GL 1018 03/11/2014 Property Taxes/Assessments (7.70) (313.82) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1020 03/13/2014 Property Taxes/Assessments (147.23) (1.14) (314.96) GL 1022 03/17/2014 Property Taxes/Assessments (1.87) (316.83) GL 1023 03/18/2014 Property Taxes/Assessments (2.23) (319.06) GL 1081 03/21/2014 Property Taxes/Assessments (3.50) (322.56) GL 1082 03/24/2014 Property Taxes/Assessments (2.75) (325.31) GL 1083 03/25/2014 Property Taxes/Assessments (3.67) (328.98) GL 1084 03/26/2014 Property Taxes/Assessments (13.31) (342.29) GL 1085 03/27/2014 Property Taxes/Assessments (7.90) (350.19) GL 1103 03/31/2014 Property Taxes/Assessments (1.23) (351.42) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (204.19) (351.42) ** (900.00) Budgeted (548.58) Remaining 39 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1046 03/06/2014 UB 3/6/14 Adjustment UB20140306-20140306 User: (924,314.81) (100.00) (924,414.81) UB 1055 03/20/2014 UB 3/20/14 Adjustments UB20140320-20140320 User: (200.00) (924,614.81) UB 1101 03/31/2014 UB 3/31/14 Billing-March UB20140331-20140331 User: (213,199.66) (1,137,814.47) UB _______________ Account: 135-47000-000-000 Water Totals: (213,499.66) (1,137,814.47) ** (3,749,310.00) Budgeted (2,611,495.53) Remaining 30 % Used Account: 135-47005-000-000 Sewer 1101 03/31/2014 UB 3/31/14 Billing-March UB20140331-20140331 User: (698,011.88) (152,715.70) (850,727.58) UB _______________ Account: 135-47005-000-000 Sewer Totals: (152,715.70) (850,727.58) ** (1,708,321.00) Budgeted (857,593.42) Remaining 50 % Used Account: 135-47025-000-000 Penalties 1047 03/19/2014 UB 03/19/2014 Adjustments UB20140319-20140319 User: (20,486.41) 9.22 (20,477.19) UB 1028 03/21/2014 UB 3/21/14 Penalties UB20140321-20140321 User: (3,939.69) (24,416.88) UB 1099 03/31/2014 UB 3/31/14 Penalty Adjustments UB20140331-20140331 User: 90.04 (24,326.84) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,840.43) (24,326.84) ** (64,522.00) Budgeted (40,195.16) Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 974 03/12/2014 UB 3/12/14 Cut Off Fees UB20140312-20140312 User: (3,665.00) (350.00) (4,015.00) UB 1101 03/31/2014 UB 3/31/14 Billing-March UB20140331-20140331 User: (3.00) (4,018.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (353.00) (4,018.00) ** (9,075.00) Budgeted (5,057.00) Remaining 44 % Used Account: 135-47035-000-000 Plumbing Inspections 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (900.00) (600.00) (1,500.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (600.00) (1,500.00) ** (1,200.00) Budgeted 300.00 Remaining 125 % Used Account: 135-47045-000-000 Sewer Inspections 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (2,850.00) (1,800.00) (4,650.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,800.00) (4,650.00) ** (4,400.00) Budgeted 250.00 Remaining 106 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1101 03/31/2014 UB 3/31/14 Billing-March UB20140331-20140331 User: (8,053.18) (1,972.60) (10,025.78) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (1,972.60) (10,025.78) ** (79,586.00) Budgeted (69,560.22) Remaining 13 % Used Account: 135-48005-000-000 Utility Fees 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (174,800.00) (11,500.00) (186,300.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (11,500.00) (186,300.00) ** (582,109.00) Budgeted (395,809.00) Remaining 32 % Used Account: 135-49010-000-000 Interest Income 1112 03/31/2014 Bank Statement Interest/March (2,542.90) (408.18) (2,951.08) GL 1112 03/31/2014 Bank Statement Interest/March (32.76) (2,983.84) GL 1112 03/31/2014 Bank Statement Interest/March (60.16) (3,044.00) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (501.10) (3,044.00) ** (4,800.00) Budgeted (1,756.00) Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49016-000-000 Cell Tower Revenue 1005 03/19/2014 AT&T Cell Tower Revenue (4,552.65) (910.53) (5,463.18) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (5,463.18) ** (10,164.00) Budgeted (4,700.82) Remaining 54 % Used Account: 135-49018-000-000 Building Rent Income 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49030-000-000 Vending Revenue 1078 03/28/2014 WWTP Vending (98.00) (48.00) (146.00) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (48.00) (146.00) ** (350.00) Budgeted (204.00) Remaining 42 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (37,028.77) (9,075.71) (46,104.48) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (9,075.71) (46,104.48) ** (84,000.00) Budgeted (37,895.52) Remaining 55 % Used Account: 135-49900-000-000 Miscellaneous Income (1,158.08) .00 (1,158.08) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (1,158.08) ** (3,000.00) Budgeted (1,841.92) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** .00 Budgeted 4,087.00 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,380,271.43) ** (6,417,937.00) Budgeted (4,037,665.57) Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 966 03/10/2014 PR 3-14-14 Salaries & Wages 107,088.41 10,858.14 117,946.55 PR 1058 03/28/2014 MUD Payroll 3/28/14 Salaries & Wages 10,858.14 128,804.69 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 21,716.28 128,804.69 ** 287,709.00 Budgeted 158,904.31 Remaining 45 % Used Account: 135-50010-010-000 Overtime 966 03/10/2014 PR 3-14-14 Overtime 7,907.05 899.31 8,806.36 PR 1058 03/28/2014 MUD Payroll 3/28/14 Overtime 1,720.13 10,526.49 PR _______________ Account: 135-50010-010-000 Overtime Totals: 2,619.44 10,526.49 ** 13,391.00 Budgeted 2,864.51 Remaining 79 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1058 03/28/2014 MUD Payroll 3/28/14 Certification 1,650.00 375.00 2,025.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 2,025.00 ** 5,100.00 Budgeted 3,075.00 Remaining 40 % Used Account: 135-50020-010-000 Retirement 966 03/10/2014 PR 3-14-14 Retirement 11,359.20 1,055.80 12,415.00 PR 1058 03/28/2014 MUD Payroll 3/28/14 Retirement 1,163.22 13,578.22 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,219.02 13,578.22 ** 27,847.00 Budgeted 14,268.78 Remaining 49 % Used Account: 135-50026-010-000 Medical Insurance 966 03/10/2014 PR 3-14-14 Medical Insurance 15,340.59 1,720.02 17,060.61 PR 1064 03/26/2014 Jan-Mar Obamacare monthly fee 360.00 17,420.61 GL 1058 03/28/2014 MUD Payroll 3/28/14 Medical Insurance 1,719.96 19,140.57 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,799.98 19,140.57 ** 48,334.00 Budgeted 29,193.43 Remaining 40 % Used Account: 135-50027-010-000 Dental Insurance 966 03/10/2014 PR 3-14-14 Dental Insurance 1,178.73 124.54 1,303.27 PR 1058 03/28/2014 MUD Payroll 3/28/14 Dental Insurance 124.58 1,427.85 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 1,427.85 ** 3,932.00 Budgeted 2,504.15 Remaining 36 % Used Account: 135-50028-010-000 Vision Insurance 966 03/10/2014 PR 3-14-14 Vision Insurance 280.93 31.49 312.42 PR 1058 03/28/2014 MUD Payroll 3/28/14 Vision Insurance 31.54 343.96 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 343.96 ** 873.00 Budgeted 529.04 Remaining 39 % Used Account: 135-50029-010-000 Life Insurance & Other 871 03/01/2014 March A/P March Medical 1,002.10 218.75 1,220.85 METLIFE 33498 AP 1060 03/26/2014 Mar A/P Flex account adm fee 15.28 1,236.13 BenefitMall 33588 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 234.03 1,236.13 ** 3,306.00 Budgeted 2,069.87 Remaining 37 % Used Account: 135-50030-010-000 Social Security Taxes 966 03/10/2014 PR 3-14-14 Social Security Taxes 7,884.17 725.74 8,609.91 PR 1058 03/28/2014 MUD Payroll 3/28/14 Social Security Taxes 794.95 9,404.86 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,520.69 9,404.86 ** 19,289.00 Budgeted 9,884.14 Remaining 49 % Used Account: 135-50035-010-000 Medicare Taxes 966 03/10/2014 PR 3-14-14 Medicare Taxes 1,843.88 169.73 2,013.61 PR 1058 03/28/2014 MUD Payroll 3/28/14 Medicare Taxes 185.92 2,199.53 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 355.65 2,199.53 ** 4,511.00 Budgeted 2,311.47 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 966 03/10/2014 PR 3-14-14 Unemployment Taxes 52.65 .12 52.77 PR 1058 03/28/2014 MUD Payroll 3/28/14 Unemployment Taxes .12 52.89 PR 1130 03/31/2014 TWC increase from .1 to 2.3 1,191.55 1,244.44 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1,191.79 1,244.44 ** 54.00 Budgeted (1,190.44) Remaining ########## Account: 135-50045-010-000 Workman's Compensation 52 03/01/2014 Mar Ins & W/C Expense 4,012.25 802.45 4,814.70 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 4,814.70 ** 9,829.00 Budgeted 5,014.30 Remaining 49 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 233.90 .00 233.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 233.90 ** 200.00 Budgeted (33.90) Remaining 117 % Used Account: 135-50070-010-000 Employee Relations 107.78 .00 107.78 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 107.78 ** 300.00 Budgeted 192.22 Remaining 36 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 954 03/07/2014 AP-March Meter expense 38,635.42 64.00 38,699.42 ATLAS UTILITY SUPPLY CO. 33514 AP 958 03/07/2014 March A/P Bushings, gaskets, u-branches 1,183.06 39,882.48 HD SUPPLY WATERWORKS, LTD. 33524 AP 994 03/18/2014 Mar A/P Remove and Replace 24" mag met 5,980.00 45,862.48 AXIS CONSTRUCTION 33555 AP 1104 03/26/2014 2/27/14-3/26/14 PCards WAL-MART #5247 82.85 45,945.33 WAL-MART #5247 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 22.44 45,967.77 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1104 03/26/2014 2/27/14-3/26/14 PCards ROANOKE WINNELSON CO 38,635.42 21.35 45,989.12 ROANOKE WINNELSON CO PC 1104 03/26/2014 2/27/14-3/26/14 PCards ELIGHTBULBS 800-948-1 16.95 46,006.07 ELIGHTBULBS 800-948-1 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 3.46 46,009.53 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 41.18 46,050.71 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 26.83 46,077.54 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 46.62 46,124.16 THE HOME DEPOT 6581 PC 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter- Axis Construct (5,980.00) 40,144.16 GL 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter- Atlas U S (9,250.00) 30,894.16 GL 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter- DHS Automation (975.00) 29,919.16 GL 1091 03/31/2014 Mar A/P Fire Hydrant-Fresh Meadow 1,782.36 31,701.52 HD SUPPLY WATERWORKS, LTD. 33625 AP 1091 03/31/2014 Mar A/P 4x5 Blue flags marked water 65.00 31,766.52 HD SUPPLY WATERWORKS, LTD. 33625 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: (6,868.90) 31,766.52 ** 50,000.00 Budgeted 18,233.48 Remaining 64 % Used Account: 135-55090-010-000 Vehicle Maintenance 1104 03/26/2014 2/27/14-3/26/14 PCards INLAND TRUCK PARTS #18 1,790.95 70.65 1,861.60 INLAND TRUCK PARTS #18 PC 1104 03/26/2014 2/27/14-3/26/14 PCards DISCOUNT TIRE TXD 75 293.00 2,154.60 DISCOUNT TIRE TXD 75 PC 1104 03/26/2014 2/27/14-3/26/14 PCards DISCOUNT TIRE TXD 75 325.00 2,479.60 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 688.65 2,479.60 ** 5,000.00 Budgeted 2,520.40 Remaining 50 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 248.33 .00 248.33 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 ** 3,500.00 Budgeted 3,251.67 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 994 03/18/2014 Mar A/P Bac T Samples/MUD 990.00 205.00 1,195.00 TARRANT CTY PUBLIC HEALTH LAB 33579 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 205.00 1,195.00 ** 5,500.00 Budgeted 4,305.00 Remaining 22 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 1,531.19 383.37 1,914.56 TOWN OF TROPHY CLUB 33582 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.37 1,914.56 ** 4,913.00 Budgeted 2,998.44 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 994 03/18/2014 Mar A/P Electricity 2/11-3/12/14 41,233.51 3,263.24 44,496.75 HUDSON ENERGY SERVICES, LLC 33564 AP 994 03/18/2014 Mar A/P Electricity 2/9-3/11/14 77.50 44,574.25 HUDSON ENERGY SERVICES, LLC 33564 AP 1060 03/26/2014 Mar A/P Electricity 2/11-3/12/14 2,883.00 47,457.25 HUDSON ENERGY SERVICES, LLC 33595 AP _______________ Account: 135-60020-010-000 Electricity Totals: 6,223.74 47,457.25 ** 162,160.00 Budgeted 114,702.75 Remaining 29 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 150.00 Budgeted (139.00) Remaining 193 % Used Account: 135-60080-010-000 Schools & Training 1104 03/26/2014 2/27/14-3/26/14 PCards TEXAS WATER 770.00 295.00 1,065.00 TEXAS WATER PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 295.00 1,065.00 ** 4,184.00 Budgeted 3,119.00 Remaining 25 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 171.13 .00 171.13 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 171.13 ** 1,450.00 Budgeted 1,278.87 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-010-000 Rent/Lease Equipment 24.00 .00 24.00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 24.00 ** 500.00 Budgeted 476.00 Remaining 5 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 32,195.79 .00 32,195.79 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 32,195.79 ** 47,400.00 Budgeted 15,204.21 Remaining 68 % Used Account: 135-60150-010-000 Wholesale Water 1092 03/31/2014 Mar A/P Feb Wholesale Water 504,472.51 121,206.18 625,678.69 CITY OF FORT WORTH 33615 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 121,206.18 625,678.69 ** 2,338,473.00 Budgeted 1,712,794.31 Remaining 27 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1104 03/26/2014 2/27/14-3/26/14 PCards DENTON SAND & GRAVEL, 678.70 42.00 720.70 DENTON SAND & GRAVEL, PC 1104 03/26/2014 2/27/14-3/26/14 PCards DENTON SAND & GRAVEL, 108.00 828.70 DENTON SAND & GRAVEL, PC 1104 03/26/2014 2/27/14-3/26/14 PCards DENTON SAND & GRAVEL, 108.00 936.70 DENTON SAND & GRAVEL, PC 1104 03/26/2014 2/27/14-3/26/14 PCards DENTON SAND & GRAVEL, 108.00 1,044.70 DENTON SAND & GRAVEL, PC 1104 03/26/2014 2/27/14-3/26/14 PCards TEX-TURF 27.30 1,072.00 TEX-TURF PC 1104 03/26/2014 2/27/14-3/26/14 PCards TEX-TURF 18.20 1,090.20 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 411.50 1,090.20 ** 3,500.00 Budgeted 2,409.80 Remaining 31 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 958 03/07/2014 March A/P Shelving for water barn 1,664.20 1,664.20 COSTCO WHOLESALE 33517 AP _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 1,664.20 1,664.20 ** 3,500.00 Budgeted 1,835.80 Remaining 48 % Used Account: 135-65005-010-000 Fuel & Lube 1104 03/26/2014 2/27/14-3/26/14 PCards SHELL OIL 575420870QPS 4,770.70 50.94 4,821.64 SHELL OIL 575420870QPS PC 1114 03/31/2014 MUD/FD Gaslog/March 986.99 5,808.63 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,037.93 5,808.63 ** 23,181.00 Budgeted 17,372.37 Remaining 25 % Used Account: 135-65010-010-000 Uniforms 1104 03/26/2014 2/27/14-3/26/14 PCards TRACTOR SUPPLY COMPANY 1,831.63 106.95 1,938.58 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 106.95 1,938.58 ** 3,270.00 Budgeted 1,331.42 Remaining 59 % Used Account: 135-65030-010-000 Chemicals 2,667.29 .00 2,667.29 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 2,667.29 ** 5,000.00 Budgeted 2,332.71 Remaining 53 % Used Account: 135-65035-010-000 Small Tools 464.94 .00 464.94 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % Used Account: 135-65040-010-000 Safety Equipment 322.67 .00 322.67 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 322.67 ** 1,000.00 Budgeted 677.33 Remaining 32 % Used Account: 135-65050-010-000 Meter Expense 954 03/07/2014 AP-March Meter expense 59,392.12 895.00 60,287.12 ATLAS UTILITY SUPPLY CO. 33514 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 895.00 60,287.12 ** 143,550.00 Budgeted 83,262.88 Remaining 42 % Used Account: 135-69005-010-000 Capital Outlays 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves 10" Valve @ Trophy Wood & Peb 8,225.08 8,225.08 GL 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves #2 of 4"water line @Phonex&Peb 3,913.84 12,138.92 GL 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves #1 of 4"water line @Phoenx&Peb 7,335.67 19,474.59 GL 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter- Axis Construct 5,980.00 25,454.59 GL 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter- Atlas U S 9,250.00 34,704.59 GL 1070 03/27/2014 Reclassify 24" Mag Meter 24" Mag Meter-DHS Automation 975.00 35,679.59 GL _______________ Account: 135-69005-010-000 Capital Outlays Totals: 35,679.59 35,679.59 ** 37,000.00 Budgeted 1,320.41 Remaining 96 % Used Account: 135-69008-010-000 Short Term Debt-Principal 871 03/01/2014 March A/P Principal and Interest, 445K n 122,980.00 122,980.00 FIRST FINANCIAL BANK 33487 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 122,980.00 122,980.00 ** 489,980.00 Budgeted 367,000.00 Remaining 25 % Used Account: 135-69009-010-000 Short Term Debt-Interest 871 03/01/2014 March A/P Principal and Interest, 445K n 6,411.28 6,411.28 FIRST FINANCIAL BANK 33487 AP 871 03/01/2014 March A/P Ground Storage loan interest 5,209.98 11,621.26 FIRST FINANCIAL BANK 33488 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 11,621.26 11,621.26 ** 19,268.00 Budgeted 7,646.74 Remaining 60 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69280-010-000 Capital Repairs 1060 03/26/2014 Mar A/P 10" valve replacement 8,225.08 8,225.08 REY-MAR CONSTRUCTION 33604 AP 1060 03/26/2014 Mar A/P 6" Valve replacement/225 Phoen 3,913.84 12,138.92 REY-MAR CONSTRUCTION 33604 AP 1060 03/26/2014 Mar A/P Water line replacement/225 Pho 7,335.67 19,474.59 REY-MAR CONSTRUCTION 33604 AP 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves 10" Valve @ Trophy Wood & Peb (8,225.08) 11,249.51 GL 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves #2 of 4" waterline @ Phoex&Peb (3,913.84) 7,335.67 GL 1068 03/27/2014 Reclassify Rey-Mar-Proj-Valves #1 of 4"water line@Phonex&Peb (7,335.67) .00 GL _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 100,816.54 ** 106,847.00 Budgeted 6,030.46 Remaining 94 % Used Account: 135-55135-010-001 Lab Analysis 994 03/18/2014 Mar A/P Bac T Samples/PID 598.49 100.00 698.49 TARRANT CTY PUBLIC HEALTH LAB 33580 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 100.00 698.49 ** 1,000.00 Budgeted 301.51 Remaining 70 % Used Account: 135-60135-010-001 TCEQ Fees & Permits 954 03/07/2014 AP-March Water samples PID 2,366.19 130.00 2,496.19 CRISP ANALYTICAL LABS, LLC 33518 AP _______________ Account: 135-60135-010-001 TCEQ Fees & Permits Totals: 130.00 2,496.19 ** .00 Budgeted (2,496.19) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,293,013.69 ** 3,932,956.00 Budgeted 2,639,942.31 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 966 03/10/2014 PR 3-14-14 Salaries & Wages 78,724.40 7,587.46 86,311.86 PR 1058 03/28/2014 MUD Payroll 3/28/14 Salaries & Wages 7,587.46 93,899.32 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,174.92 93,899.32 ** 202,894.00 Budgeted 108,994.68 Remaining 46 % Used Account: 135-50010-020-000 Overtime 966 03/10/2014 PR 3-14-14 Overtime 5,874.15 452.28 6,326.43 PR 1058 03/28/2014 MUD Payroll 3/28/14 Overtime 777.67 7,104.10 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,229.95 7,104.10 ** 11,965.00 Budgeted 4,860.90 Remaining 59 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1058 03/28/2014 MUD Payroll 3/28/14 Certification 2,000.00 400.00 2,400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 2,400.00 ** 4,800.00 Budgeted 2,400.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 966 03/10/2014 PR 3-14-14 Retirement 8,514.07 721.97 9,236.04 PR 1058 03/28/2014 MUD Payroll 3/28/14 Retirement 787.12 10,023.16 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,509.09 10,023.16 ** 19,905.00 Budgeted 9,881.84 Remaining 50 % Used Account: 135-50026-020-000 Medical Insurance 966 03/10/2014 PR 3-14-14 Medical Insurance 16,309.73 1,620.56 17,930.29 PR 1064 03/26/2014 Jan-Mar Obamacare monthly fee 556.98 18,487.27 GL 1058 03/28/2014 MUD Payroll 3/28/14 Medical Insurance 1,620.53 20,107.80 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,798.07 20,107.80 ** 43,471.00 Budgeted 23,363.20 Remaining 46 % Used Account: 135-50027-020-000 Dental Insurance 966 03/10/2014 PR 3-14-14 Dental Insurance 1,102.14 105.68 1,207.82 PR 1058 03/28/2014 MUD Payroll 3/28/14 Dental Insurance 105.70 1,313.52 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,313.52 ** 2,989.00 Budgeted 1,675.48 Remaining 44 % Used Account: 135-50028-020-000 Vision Insurance 966 03/10/2014 PR 3-14-14 Vision Insurance 252.31 25.61 277.92 PR 1058 03/28/2014 MUD Payroll 3/28/14 Vision Insurance 25.65 303.57 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 303.57 ** 658.00 Budgeted 354.43 Remaining 46 % Used Account: 135-50029-020-000 Life Insurance & Other 871 03/01/2014 March A/P March Medical 850.93 155.00 1,005.93 METLIFE 33498 AP 1060 03/26/2014 Mar A/P Flex account adm fee 30.56 1,036.49 BenefitMall 33588 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 185.56 1,036.49 ** 2,303.00 Budgeted 1,266.51 Remaining 45 % Used Account: 135-50030-020-000 Social Security Taxes 966 03/10/2014 PR 3-14-14 Social Security Taxes 5,267.62 425.00 5,692.62 PR 1058 03/28/2014 MUD Payroll 3/28/14 Social Security Taxes 459.98 6,152.60 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 884.98 6,152.60 ** 13,805.00 Budgeted 7,652.40 Remaining 45 % Used Account: 135-50035-020-000 Medicare Taxes 966 03/10/2014 PR 3-14-14 Medicare Taxes 1,231.94 99.39 1,331.33 PR 1058 03/28/2014 MUD Payroll 3/28/14 Medicare Taxes 107.58 1,438.91 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 206.97 1,438.91 ** 3,229.00 Budgeted 1,790.09 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes 966 03/10/2014 PR 3-14-14 Unemployment Taxes 34.50 .08 34.58 PR 1058 03/28/2014 MUD Payroll 3/28/14 Unemployment Taxes .08 34.66 PR 1130 03/31/2014 TWC increase from .1 to 2.3 793.34 828.00 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 793.50 828.00 ** 36.00 Budgeted (792.00) Remaining ########## Account: 135-50045-020-000 Workman's Compensation 52 03/01/2014 Mar Ins & W/C Expense 2,675.40 535.08 3,210.48 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 3,210.48 ** 6,552.00 Budgeted 3,341.52 Remaining 49 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 59.99 .00 59.99 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 59.99 ** 350.00 Budgeted 290.01 Remaining 17 % Used Account: 135-55070-020-000 Independent Labor 961 03/07/2014 March A/P WWTP Improvements 352,976.25 58,055.00 411,031.25 THE WALLACE GROUP, INC. 33552 AP 1132 03/31/2014 March A/P WWTP Improvements 49,835.00 460,866.25 THE WALLACE GROUP, INC. AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 107,890.00 460,866.25 ** .00 Budgeted (460,866.25) Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 994 03/18/2014 Mar A/P Proximity Sensor Assembly with 19,021.56 149.77 19,171.33 ALFA LAVAL ASHBROOK 33554 AP 994 03/18/2014 Mar A/P Batteries for WWTP Generator 855.26 20,026.59 ENTECH SALES AND SERVICE INC 33560 AP 994 03/18/2014 Mar A/P Troubleshoot flow meter 409.50 20,436.09 Prime Controls, LP 33574 AP 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 27.21 20,463.30 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1104 03/26/2014 2/27/14-3/26/14 PCards BREAKER BROKER 19,021.56 55.00 20,518.30 BREAKER BROKER PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 5.44 20,523.74 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards FERGUSON ENT #788 66.92 20,590.66 FERGUSON ENT #788 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 19.13 20,609.79 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 19.17 20,628.96 THE HOME DEPOT 6581 PC 1132 03/31/2014 March A/P Tatung 25hp new motor, ball va 2,975.00 23,603.96 PETERSON PUMP & MOTOR SERVICE AP 1132 03/31/2014 March A/P PVD, Flanges 90.51 23,694.47 HD SUPPLY FACILITIES MAINT LTD AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,672.91 23,694.47 ** 35,000.00 Budgeted 11,305.53 Remaining 68 % Used Account: 135-55090-020-000 Vehicle Maintenance 1104 03/26/2014 2/27/14-3/26/14 PCards AUTOZONE #3134 1,217.49 9.97 1,227.46 AUTOZONE #3134 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 9.97 1,227.46 ** 2,000.00 Budgeted 772.54 Remaining 61 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 994 03/18/2014 Mar A/P Sludge haul off 16,446.74 1,841.67 18,288.41 L.H. CHANEY MATERIALS, INC. 33569 AP 1132 03/31/2014 March A/P Sludge Haul off 1,797.61 20,086.02 L.H. CHANEY MATERIALS, INC. AP 1132 03/31/2014 March A/P Sludge Haul off 950.79 21,036.81 L.H. CHANEY MATERIALS, INC. AP 1132 03/31/2014 March A/P Sludge Haul off 1,890.37 22,927.18 L.H. CHANEY MATERIALS, INC. AP 1132 03/31/2014 March A/P Sludge Haul off 1,847.47 24,774.65 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 8,327.91 24,774.65 ** 52,000.00 Budgeted 27,225.35 Remaining 48 % Used Account: 135-55135-020-000 Lab Analysis 994 03/18/2014 Mar A/P Testing 10,484.13 88.00 10,572.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testing 246.00 10,818.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testiing 176.00 10,994.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testing 246.00 11,240.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testing 176.00 11,416.13 OXIDOR LABORATORIES LLC 33572 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 994 03/18/2014 Mar A/P Testing 10,484.13 226.00 11,642.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testing 176.00 11,818.13 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Annual Sludge Testing 1,347.50 13,165.63 OXIDOR LABORATORIES LLC 33572 AP 994 03/18/2014 Mar A/P Testing 246.00 13,411.63 OXIDOR LABORATORIES LLC 33572 AP 1060 03/26/2014 Mar A/P Full Preventative Maint onsite 222.45 13,634.08 METTLER TOLEDO INTERNATIONAL 33600 AP 1132 03/31/2014 March A/P Testing 1,109.18 14,743.26 OXIDOR LABORATORIES LLC AP 1132 03/31/2014 March A/P Testing 246.00 14,989.26 OXIDOR LABORATORIES LLC AP 1132 03/31/2014 March A/P Testing 176.00 15,165.26 OXIDOR LABORATORIES LLC AP 1132 03/31/2014 March A/P Testing 246.00 15,411.26 OXIDOR LABORATORIES LLC AP 1132 03/31/2014 March A/P Testing 201.00 15,612.26 OXIDOR LABORATORIES LLC AP 1132 03/31/2014 March A/P Testing 239.00 15,851.26 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 5,367.13 15,851.26 ** 30,000.00 Budgeted 14,148.74 Remaining 53 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 922.82 306.74 1,229.56 TOWN OF TROPHY CLUB 33582 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 306.74 1,229.56 ** 3,329.00 Budgeted 2,099.44 Remaining 37 % Used Account: 135-60020-020-000 Electricity 994 03/18/2014 Mar A/P Electricity 2/11-3/12/14 39,865.07 8,776.81 48,641.88 HUDSON ENERGY SERVICES, LLC 33564 AP _______________ Account: 135-60020-020-000 Electricity Totals: 8,776.81 48,641.88 ** 148,227.00 Budgeted 99,585.12 Remaining 33 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 1104 03/26/2014 2/27/14-3/26/14 PCards AMERICAN WATERWORKS 160.00 191.00 351.00 AMERICAN WATERWORKS PC _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 191.00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1104 03/26/2014 2/27/14-3/26/14 PCards TEXAS WATER 222.00 295.00 517.00 TEXAS WATER PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 295.00 517.00 ** 2,636.00 Budgeted 2,119.00 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-020-000 Safety Program 1132 03/31/2014 March A/P first aid supplies 371.38 60.69 432.07 CINTAS CORPORATION NO. 2 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 60.69 432.07 ** 250.00 Budgeted (182.07) Remaining 173 % Used Account: 135-60100-020-000 Travel & per diem 1104 03/26/2014 2/27/14-3/26/14 PCards STOP-N-START TRAVEL CE 266.09 10.82 276.91 STOP-N-START TRAVEL CE PC 1104 03/26/2014 2/27/14-3/26/14 PCards SHELL OIL 542954500QPS 4.42 281.33 SHELL OIL 542954500QPS PC 1092 03/31/2014 Mar A/P Toll/K Schlielig 11.48 292.81 NTTA 33642 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 26.72 292.81 ** 1,050.00 Budgeted 757.19 Remaining 28 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60125-020-000 Advertising 1104 03/26/2014 2/27/14-3/26/14 PCards FEDEXOFFICE 00003319 61.68 61.68 FEDEXOFFICE 00003319 PC 1104 03/26/2014 2/27/14-3/26/14 PCards HOBBY-LOBBY #256 19.13 80.81 HOBBY-LOBBY #256 PC 1126 03/31/2014 Recode unbudgeted expenses (80.81) .00 GL _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60243-020-000 Prior Year Expense 1106 03/31/2014 Mar A/P P/Y exp/WW Module SC1000/Modul 3,554.22 3,554.22 HACH COMPANY 33624 AP _______________ Account: 135-60243-020-000 Prior Year Expense Totals: 3,554.22 3,554.22 ** .00 Budgeted (3,554.22) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1104 03/26/2014 2/27/14-3/26/14 PCards HOMEDEPOT.COM 1,079.10 1,079.10 HOMEDEPOT.COM PC _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 1,079.10 1,079.10 ** 3,000.00 Budgeted 1,920.90 Remaining 36 % Used Account: 135-65005-020-000 Fuel & Lube 1104 03/26/2014 2/27/14-3/26/14 PCards MUSTANG ELITE CAR WASH 4,071.37 140.98 4,212.35 MUSTANG ELITE CAR WASH PC 1104 03/26/2014 2/27/14-3/26/14 PCards MUSTANG ELITE CAR WASH 140.98 4,353.33 MUSTANG ELITE CAR WASH PC 1104 03/26/2014 2/27/14-3/26/14 PCards EXXONMOBIL 47653431 79.07 4,432.40 EXXONMOBIL 47653431 PC 1114 03/31/2014 MUD/FD Gaslog/March 890.50 5,322.90 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,251.53 5,322.90 ** 14,720.00 Budgeted 9,397.10 Remaining 36 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals 994 03/18/2014 Mar A/P Clarifloc 10,318.12 1,080.00 11,398.12 POLYDYNE, INC 33573 AP 994 03/18/2014 Mar A/P 100 lbs HTH 1,680.00 13,078.12 HARCROS CHEMICALS INC 33562 AP 1132 03/31/2014 March A/P Clarifloc 1,080.00 14,158.12 POLYDYNE, INC AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: 3,840.00 14,158.12 ** 39,000.00 Budgeted 24,841.88 Remaining 36 % Used Account: 135-65035-020-000 Small Tools 91.00 .00 91.00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 91.00 ** 1,000.00 Budgeted 909.00 Remaining 9 % Used Account: 135-65040-020-000 Safety Equipment 230.63 .00 230.63 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 230.63 ** 250.00 Budgeted 19.37 Remaining 92 % Used Account: 135-65045-020-000 Lab Supplies 994 03/18/2014 Mar A/P Lab supplies 5,383.58 751.70 6,135.28 HACH COMPANY 33561 AP 994 03/18/2014 Mar A/P PH Buffer solution kit 118.87 6,254.15 HACH COMPANY 33561 AP 994 03/18/2014 Mar A/P Digital Frio-Temp Thermometer 246.83 6,500.98 HD SUPPLY FACILITIES MAINT LTD 33563 AP 1132 03/31/2014 March A/P Protector towels 142.10 6,643.08 SHARE CORP AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,259.50 6,643.08 ** 15,000.00 Budgeted 8,356.92 Remaining 44 % Used Account: 135-69005-020-000 Capital Outlays .00 .00 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 .00 ** 31,000.00 Budgeted 31,000.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal 871 03/01/2014 March A/P Principal and Interest, 445K n 20,020.00 20,020.00 FIRST FINANCIAL BANK 33487 AP _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: 20,020.00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 871 03/01/2014 March A/P Principal and Interest, 445K n 1,043.70 1,043.70 FIRST FINANCIAL BANK 33487 AP _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 1,043.70 1,043.70 ** 1,422.00 Budgeted 378.30 Remaining 73 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 791,615.40 ** 768,011.00 Budgeted (23,604.40) Remaining 103 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 966 03/10/2014 PR 3-14-14 Salaries & Wages 26,469.48 3,354.58 29,824.06 PR 1058 03/28/2014 MUD Payroll 3/28/14 Salaries & Wages 3,351.58 33,175.64 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,706.16 33,175.64 ** 90,299.00 Budgeted 57,123.36 Remaining 37 % Used Account: 135-50010-021-000 Overtime 1058 03/28/2014 MUD Payroll 3/28/14 Overtime 2,133.51 225.63 2,359.14 PR _______________ Account: 135-50010-021-000 Overtime Totals: 225.63 2,359.14 ** 10,028.00 Budgeted 7,668.86 Remaining 24 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 17,913.00 Budgeted 15,805.50 Remaining 12 % Used Account: 135-50017-021-000 Certification 1058 03/28/2014 MUD Payroll 3/28/14 Certification 750.00 150.00 900.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 900.00 ** 1,800.00 Budgeted 900.00 Remaining 50 % Used Account: 135-50020-021-000 Retirement 966 03/10/2014 PR 3-14-14 Retirement 3,180.15 301.25 3,481.40 PR 1058 03/28/2014 MUD Payroll 3/28/14 Retirement 334.70 3,816.10 PR _______________ Account: 135-50020-021-000 Retirement Totals: 635.95 3,816.10 ** 9,025.00 Budgeted 5,208.90 Remaining 42 % Used Account: 135-50026-021-000 Medical Insurance 966 03/10/2014 PR 3-14-14 Medical Insurance 8,057.54 701.20 8,758.74 PR 1064 03/26/2014 Jan-Mar Obamacare monthly fee 213.96 8,972.70 GL 1058 03/28/2014 MUD Payroll 3/28/14 Medical Insurance 701.19 9,673.89 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,616.35 9,673.89 ** 23,668.00 Budgeted 13,994.11 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 966 03/10/2014 PR 3-14-14 Dental Insurance 607.59 51.30 658.89 PR 1058 03/28/2014 MUD Payroll 3/28/14 Dental Insurance 51.30 710.19 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 710.19 ** 1,703.00 Budgeted 992.81 Remaining 42 % Used Account: 135-50028-021-000 Vision Insurance 966 03/10/2014 PR 3-14-14 Vision Insurance 123.21 11.84 135.05 PR 1058 03/28/2014 MUD Payroll 3/28/14 Vision Insurance 11.84 146.89 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 146.89 ** 314.00 Budgeted 167.11 Remaining 47 % Used Account: 135-50029-021-000 Life Insurance & Other 871 03/01/2014 March A/P March Medical 467.95 71.54 539.49 METLIFE 33498 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 71.54 539.49 ** 1,066.00 Budgeted 526.51 Remaining 51 % Used Account: 135-50030-021-000 Social Security Taxes 966 03/10/2014 PR 3-14-14 Social Security Taxes 1,981.57 188.58 2,170.15 PR 1058 03/28/2014 MUD Payroll 3/28/14 Social Security Taxes 208.73 2,378.88 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 397.31 2,378.88 ** 7,442.00 Budgeted 5,063.12 Remaining 32 % Used Account: 135-50035-021-000 Medicare Taxes 966 03/10/2014 PR 3-14-14 Medicare Taxes 463.43 44.11 507.54 PR 1058 03/28/2014 MUD Payroll 3/28/14 Medicare Taxes 48.81 556.35 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 92.92 556.35 ** 1,741.00 Budgeted 1,184.65 Remaining 32 % Used Account: 135-50040-021-000 Unemployment Taxes 966 03/10/2014 PR 3-14-14 Unemployment Taxes 10.18 .04 10.22 PR 1058 03/28/2014 MUD Payroll 3/28/14 Unemployment Taxes .04 10.26 PR 1130 03/31/2014 TWC increase from .1 to 2.3 292.89 303.15 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 292.97 303.15 ** 198.00 Budgeted (105.15) Remaining 153 % Used Account: 135-50045-021-000 Workman's Compensation 52 03/01/2014 Mar Ins & W/C Expense 1,337.70 267.54 1,605.24 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 1,605.24 ** 3,276.00 Budgeted 1,670.76 Remaining 49 % Used Account: 135-50070-021-000 Employee Relations 132.02 .00 132.02 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 132.02 ** 200.00 Budgeted 67.98 Remaining 66 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 994 03/18/2014 Mar A/P Trigger gun 2,991.28 567.40 3,558.68 CLS SEWER EQUIPMENT CO INC 33556 AP 1104 03/26/2014 2/27/14-3/26/14 PCards WW GRAINGER 281.50 3,840.18 WW GRAINGER PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 250.22 4,090.40 THE HOME DEPOT 6581 PC 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 24.08 4,114.48 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,123.20 4,114.48 ** 23,801.00 Budgeted 19,686.52 Remaining 17 % Used Account: 135-55090-021-000 Vehicle Maintenance 999.18 .00 999.18 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 999.18 ** 2,000.00 Budgeted 1,000.82 Remaining 50 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 583.72 102.68 686.40 TOWN OF TROPHY CLUB 33582 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 102.68 686.40 ** 1,333.00 Budgeted 646.60 Remaining 51 % Used Account: 135-60020-021-000 Electricity 994 03/18/2014 Mar A/P Electricity 1/31-3/3/14 8,149.16 274.82 8,423.98 TRI COUNTY ELECTRIC 33583 AP 994 03/18/2014 Mar A/P Electricity 1/31-3/3/14 145.19 8,569.17 TRI COUNTY ELECTRIC 33583 AP 994 03/18/2014 Mar A/P Electricity 1/31-3/3/14 28.03 8,597.20 TRI COUNTY ELECTRIC 33583 AP 994 03/18/2014 Mar A/P Electricity 2/11-3/12/14 509.50 9,106.70 HUDSON ENERGY SERVICES, LLC 33564 AP 994 03/18/2014 Mar A/P Electricity 2/11-3/12/14 1,033.77 10,140.47 HUDSON ENERGY SERVICES, LLC 33564 AP 994 03/18/2014 Mar A/P Electricity 2/10-3/11/14 52.75 10,193.22 HUDSON ENERGY SERVICES, LLC 33564 AP 994 03/18/2014 Mar A/P Electricity 2/10-3/11/14 20.27 10,213.49 HUDSON ENERGY SERVICES, LLC 33564 AP 994 03/18/2014 Mar A/P Electricity 2/10-3/11/14 80.88 10,294.37 HUDSON ENERGY SERVICES, LLC 33564 AP 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (254.74) 10,039.63 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,890.47 10,039.63 ** 21,178.00 Budgeted 11,138.37 Remaining 47 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 1,711.00 Budgeted 1,711.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1114 03/31/2014 MUD/FD Gaslog/March 5,013.60 876.65 5,890.25 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 876.65 5,890.25 ** 22,397.00 Budgeted 16,506.75 Remaining 26 % Used Account: 135-65010-021-000 Uniforms 814.23 .00 814.23 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 814.23 ** 1,040.00 Budgeted 225.77 Remaining 78 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 500.00 Budgeted (86.73) Remaining 117 % Used Account: 135-69005-021-000 Capital Outlays 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 100,000.00 Budgeted 31,699.80 Remaining 68 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 71,000.00 Budgeted 71,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 149,879.57 ** 472,170.00 Budgeted 322,290.43 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 966 03/10/2014 PR 3-14-14 Salaries & Wages 3,700.00 500.00 4,200.00 PR 1058 03/28/2014 MUD Payroll 3/28/14 Salaries & Wages 1,000.00 5,200.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 5,200.00 ** 10,000.00 Budgeted 4,800.00 Remaining 52 % Used Account: 135-50030-026-000 Social Security Taxes 966 03/10/2014 PR 3-14-14 Social Security Taxes 229.40 31.00 260.40 PR 1058 03/28/2014 MUD Payroll 3/28/14 Social Security Taxes 62.00 322.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 322.40 ** 620.00 Budgeted 297.60 Remaining 52 % Used Account: 135-50035-026-000 Medicare Taxes 966 03/10/2014 PR 3-14-14 Medicare Taxes 53.65 7.25 60.90 PR 1058 03/28/2014 MUD Payroll 3/28/14 Medicare Taxes 14.50 75.40 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 75.40 ** 145.00 Budgeted 69.60 Remaining 52 % Used Account: 135-50040-026-000 Unemployment Taxes 966 03/10/2014 PR 3-14-14 Unemployment Taxes 3.70 .10 3.80 PR 1058 03/28/2014 MUD Payroll 3/28/14 Unemployment Taxes .10 3.90 PR 1130 03/31/2014 TWC increase from .1 to 2.3 60.70 64.60 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 60.90 64.60 ** 10.00 Budgeted (54.60) Remaining 646 % Used Account: 135-50045-026-000 Workman's Compensation 52 03/01/2014 Mar Ins & W/C Expense 14.75 2.95 17.70 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 17.70 ** 36.00 Budgeted 18.30 Remaining 49 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 35.95 .00 35.95 _______________ Account: 135-60075-026-000 Meetings Totals: .00 35.95 ** 1,200.00 Budgeted 1,164.05 Remaining 3 % Used Account: 135-60080-026-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 265.00 ** 4,000.00 Budgeted 3,735.00 Remaining 7 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 6,016.05 ** 22,661.00 Budgeted 16,644.95 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 966 03/10/2014 PR 3-14-14 Salaries & Wages 178,933.69 17,300.01 196,233.70 PR 1058 03/28/2014 MUD Payroll 3/28/14 Salaries & Wages 17,300.01 213,533.71 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 34,600.02 213,533.71 ** 458,721.00 Budgeted 245,187.29 Remaining 47 % Used Account: 135-50010-030-000 Overtime 966 03/10/2014 PR 3-14-14 Overtime 348.64 15.84 364.48 PR 1058 03/28/2014 MUD Payroll 3/28/14 Overtime 203.05 567.53 PR _______________ Account: 135-50010-030-000 Overtime Totals: 218.89 567.53 ** 500.00 Budgeted (67.53) Remaining 114 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 966 03/10/2014 PR 3-14-14 Retirement 17,348.65 1,554.96 18,903.61 PR 1058 03/28/2014 MUD Payroll 3/28/14 Retirement 1,571.77 20,475.38 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,126.73 20,475.38 ** 41,419.00 Budgeted 20,943.62 Remaining 49 % Used Account: 135-50026-030-000 Medical Insurance 966 03/10/2014 PR 3-14-14 Medical Insurance 22,536.29 2,301.30 24,837.59 PR 1064 03/26/2014 Jan-Mar Obamacare monthly fee 606.84 25,444.43 GL 1058 03/28/2014 MUD Payroll 3/28/14 Medical Insurance 2,301.23 27,745.66 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,209.37 27,745.66 ** 57,923.00 Budgeted 30,177.34 Remaining 48 % Used Account: 135-50027-030-000 Dental Insurance 966 03/10/2014 PR 3-14-14 Dental Insurance 1,839.86 170.19 2,010.05 PR 1058 03/28/2014 MUD Payroll 3/28/14 Dental Insurance 170.23 2,180.28 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.42 2,180.28 ** 5,100.00 Budgeted 2,919.72 Remaining 43 % Used Account: 135-50028-030-000 Vision Insurance 966 03/10/2014 PR 3-14-14 Vision Insurance 410.83 40.78 451.61 PR 1058 03/28/2014 MUD Payroll 3/28/14 Vision Insurance 40.84 492.45 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 492.45 ** 1,087.00 Budgeted 594.55 Remaining 45 % Used Account: 135-50029-030-000 Life Insurance & Other 871 03/01/2014 March A/P March Medical 2,190.29 310.23 2,500.52 METLIFE 33498 AP 1060 03/26/2014 Mar A/P Flex account adm fee 38.16 2,538.68 BenefitMall 33588 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 348.39 2,538.68 ** 4,483.00 Budgeted 1,944.32 Remaining 57 % Used Account: 135-50030-030-000 Social Security Taxes 966 03/10/2014 PR 3-14-14 Social Security Taxes 11,370.05 1,012.69 12,382.74 PR 1058 03/28/2014 MUD Payroll 3/28/14 Social Security Taxes 1,012.31 13,395.05 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,025.00 13,395.05 ** 28,659.00 Budgeted 15,263.95 Remaining 47 % Used Account: 135-50035-030-000 Medicare Taxes 966 03/10/2014 PR 3-14-14 Medicare Taxes 2,659.14 236.83 2,895.97 PR 1058 03/28/2014 MUD Payroll 3/28/14 Medicare Taxes 236.76 3,132.73 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 473.59 3,132.73 ** 6,702.00 Budgeted 3,569.27 Remaining 47 % Used Account: 135-50040-030-000 Unemployment Taxes 966 03/10/2014 PR 3-14-14 Unemployment Taxes 58.18 .14 58.32 PR 1058 03/28/2014 MUD Payroll 3/28/14 Unemployment Taxes .14 58.46 PR 1130 03/31/2014 TWC increase from .1 to 2.3 1,390.54 1,449.00 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 1,390.82 1,449.00 ** 63.00 Budgeted (1,386.00) Remaining ########## . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 52 03/01/2014 Mar Ins & W/C Expense 643.15 128.63 771.78 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 771.78 ** 1,575.00 Budgeted 803.22 Remaining 49 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1104 03/26/2014 2/27/14-3/26/14 PCards AMAZON MKTPLACE PMTS 2,634.60 27.95 2,662.55 AMAZON MKTPLACE PMTS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 27.95 2,662.55 ** 5,000.00 Budgeted 2,337.45 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 994 03/18/2014 Mar A/P Software support 20,352.19 149.63 20,501.82 STW INC 33576 AP 1026 03/21/2014 Recode Repairs/Maint Admin Recode Syntech gas tank maint (1,152.37) 19,349.45 GL 1104 03/26/2014 2/27/14-3/26/14 PCards GOOGLE *GOOGLE INC 399.00 19,748.45 GOOGLE *GOOGLE INC PC 1060 03/26/2014 Mar A/P IT BOA 582.37 20,330.82 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 47.50 20,378.32 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 1,108.00 21,486.32 TOWN OF TROPHY CLUB 33609 AP 1074 03/28/2014 Recode Charter Invoice (462.50) 21,023.82 GL _______________ Account: 135-55030-030-000 Software & Support Totals: 671.63 21,023.82 ** 59,698.00 Budgeted 38,674.18 Remaining 35 % Used Account: 135-55070-030-000 Independent Labor 1060 03/26/2014 Mar A/P Record MUD Meeting 2,377.95 75.00 2,452.95 MIGUEL CRUZ 33601 AP 1060 03/26/2014 Mar A/P Professional fees 2/16-3/15/14 2,470.53 4,923.48 NEW GEN STRATEGIES & SOLUTIONS 33603 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 2,545.53 4,923.48 ** 7,700.00 Budgeted 2,776.52 Remaining 64 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1026 03/21/2014 Recode Repairs/Maint Admin Recode Syntech gas tank maint (1,948.97) 1,152.37 (796.60) GL 1026 03/21/2014 Recode Repairs/Maint Admin Recode G&K Rug Svc/Town reimb 802.57 5.97 GL 1104 03/26/2014 2/27/14-3/26/14 PCards THE HOME DEPOT 6581 6.97 12.94 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 1,961.91 12.94 ** 4,500.00 Budgeted 4,487.06 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 954 03/07/2014 AP-March rug service 1,893.86 94.42 1,988.28 G & K SERVICES 33523 AP 954 03/07/2014 AP-March Rug service 94.42 2,082.70 G & K SERVICES 33523 AP 954 03/07/2014 AP-March rug service 94.42 2,177.12 G & K SERVICES 33523 AP 954 03/07/2014 AP-March rug service 94.42 2,271.54 G & K SERVICES 33523 AP 1026 03/21/2014 Recode Repairs/Maint Admin Recode G&K Rug Svc/Town reimb (802.57) 1,468.97 GL 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (502.64) 966.33 AR 1132 03/31/2014 March A/P Rug Service 94.42 1,060.75 G & K SERVICES AP 1132 03/31/2014 March A/P Rug Service 94.42 1,155.17 G & K SERVICES AP 1132 03/31/2014 March A/P Rug Service 94.42 1,249.59 G & K SERVICES AP 1132 03/31/2014 March A/P Rug Service 94.42 1,344.01 G & K SERVICES AP 1132 03/31/2014 March A/P Rug Service 94.42 1,438.43 G & K SERVICES AP 1092 03/31/2014 Mar A/P Fan motor on Unit #5 492.00 1,930.43 NORTH TX HEATING & AIR, INC 33641 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 36.57 1,930.43 ** 6,500.00 Budgeted 4,569.57 Remaining 30 % Used Account: 135-55120-030-000 Cleaning Services 994 03/18/2014 Mar A/P February Janitorial service 6,379.88 1,594.97 7,974.85 MEMBER'S BUILDING MAINTENANCE 33570 AP 1132 03/31/2014 March A/P March Janitorial service 1,594.97 9,569.82 MEMBER'S BUILDING MAINTENANCE AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 3,189.94 9,569.82 ** 19,140.00 Budgeted 9,570.18 Remaining 50 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Town Personnel Contract 961 03/07/2014 March A/P 1st Installment Contractual Pe 38,524.00 38,524.00 77,048.00 TOWN OF TROPHY CLUB 33553 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: 38,524.00 77,048.00 ** 77,048.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 994 03/18/2014 Mar A/P Feb Billing and printing of in 2,330.35 569.72 2,900.07 DATAPROSE LLC 33559 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 569.72 2,900.07 ** 6,808.00 Budgeted 3,907.93 Remaining 43 % Used Account: 135-60005-030-000 Telephone 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 4,987.36 87.00 5,074.36 TOWN OF TROPHY CLUB 33582 AP 1060 03/26/2014 Mar A/P IT BOA 936.89 6,011.25 TOWN OF TROPHY CLUB 33609 AP 1091 03/31/2014 Mar A/P Answering Service 196.00 6,207.25 KEYSTONE PARK SECRETARIAL 33629 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,219.89 6,207.25 ** 11,250.00 Budgeted 5,042.75 Remaining 55 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 994 03/18/2014 Mar A/P Natl Telesystems, Verizon, Sym 1,170.46 140.67 1,311.13 TOWN OF TROPHY CLUB 33582 AP 1104 03/26/2014 2/27/14-3/26/14 PCards LOVE S COUNTRY00002311 32.46 1,343.59 LOVE S COUNTRY00002311 PC 1058 03/28/2014 MUD Payroll 3/28/14 Communications/Pagers/Mobiles 150.00 1,493.59 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 323.13 1,493.59 ** 3,589.00 Budgeted 2,095.41 Remaining 42 % Used Account: 135-60020-030-000 Electricity/Gas 1060 03/26/2014 Mar A/P Direct Energy Refund duplicate 7,243.58 (2,733.83) 4,509.75 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Gexa 12/31/13-1/11/14 554.68 5,064.43 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Gexa 1/11-2/10/14 1,254.75 6,319.18 TOWN OF TROPHY CLUB 33609 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: (924.40) 6,319.18 ** 15,171.00 Budgeted 8,851.82 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60025-030-000 Water 954 03/07/2014 AP-March Water 228.08 104.22 332.30 TROPHY CLUB MUD (WATER BILLS) 33547 AP 1124 03/31/2014 Town billing Inv 1148-1158 AR 20140301-20140331 User: (97.86) 234.44 AR 1132 03/31/2014 March A/P March water 195.72 430.16 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 135-60025-030-000 Water Totals: 202.08 430.16 ** 1,500.00 Budgeted 1,069.84 Remaining 29 % Used Account: 135-60035-030-000 Postage 954 03/07/2014 AP-March overnight letter 9,029.29 6.17 9,035.46 FEDERAL EXPRESS CORP 33520 AP 994 03/18/2014 Mar A/P Feb Billing and printing of in 1,681.16 10,716.62 DATAPROSE LLC 33559 AP 1004 03/19/2014 Postage Sold from meter (7.75) 10,708.87 GL 1007 03/20/2014 Postage sold from meter (3.02) 10,705.85 GL 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 145.00 10,850.85 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Overnight letter 5.92 10,856.77 FEDERAL EXPRESS CORP 33592 AP 1116 03/31/2014 MUD/FD Postage meter usage/Mar 147.26 11,004.03 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,974.74 11,004.03 ** 28,500.00 Budgeted 17,495.97 Remaining 39 % Used Account: 135-60040-030-000 Service Charges & Fees 1113 03/04/2014 Credit card fees/Feb 12,064.32 2,218.84 14,283.16 GL 1113 03/04/2014 Credit card fees/Feb 94.25 14,377.41 GL 1113 03/04/2014 Credit card fees/Feb 39.07 14,416.48 GL 1057 03/18/2014 Feb Account analysis FF Bank 250.00 14,666.48 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,602.16 14,666.48 ** 28,330.00 Budgeted 13,663.52 Remaining 52 % Used Account: 135-60050-030-000 Bad Debt Expense 1100 03/31/2014 UB 3/31/14 Write Offs UB20140331-20140331 User: 3,712.56 484.71 4,197.27 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 484.71 4,197.27 ** 1,500.00 Budgeted (2,697.27) Remaining 280 % Used Account: 135-60055-030-000 Insurance 52 03/01/2014 Mar Ins & W/C Expense 21,431.90 4,269.73 25,701.63 GL 994 03/18/2014 Mar A/P Bond/Slaght 50.00 25,751.63 VICTOR O SCHINNERER & CO, INC 33584 AP 1079 03/28/2014 Notary Rfnd-Schaefer NCTCOG (105.00) 25,646.63 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1092 03/31/2014 Mar A/P D'Andria/Notary Bond 21,431.90 50.00 25,696.63 VICTOR O SCHINNERER & CO, INC 33648 AP 1092 03/31/2014 Mar A/P M Schaefer/Notary Bond 50.00 25,746.63 VICTOR O SCHINNERER & CO, INC 33648 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,314.73 25,746.63 ** 53,561.00 Budgeted 27,814.37 Remaining 48 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1060 03/26/2014 Mar A/P Annual newspaper renewal 126.00 275.08 401.08 STAR-TELEGRAM OPERATING LTD 33607 AP _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 275.08 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 4,011.95 .00 4,011.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,011.95 ** 4,500.00 Budgeted 488.05 Remaining 89 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 1104 03/26/2014 2/27/14-3/26/14 PCards FOX RENTAL 75.00 75.00 FOX RENTAL PC 1104 03/26/2014 2/27/14-3/26/14 PCards RANDALLS STORE00017897 5.00 80.00 RANDALLS STORE00017897 PC 1104 03/26/2014 2/27/14-3/26/14 PCards WAL-MART #5247 14.88 94.88 WAL-MART #5247 PC 1104 03/26/2014 2/27/14-3/26/14 PCards MICHAELS STORES 2063 29.98 124.86 MICHAELS STORES 2063 PC 1104 03/26/2014 2/27/14-3/26/14 PCards WAL-MART #0266 14.79 139.65 WAL-MART #0266 PC 1104 03/26/2014 2/27/14-3/26/14 PCards AMAZON MKTPLACE PMTS 48.29 187.94 AMAZON MKTPLACE PMTS PC 1104 03/26/2014 2/27/14-3/26/14 PCards FORAND BALLOON IMPRINT 86.89 274.83 FORAND BALLOON IMPRINT PC _______________ Account: 135-60079-030-000 Public Education Totals: 274.83 274.83 ** .00 Budgeted (274.83) Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 994 03/18/2014 Mar A/P STW User Conference/Nicole D'A 1,201.30 300.00 1,501.30 STW INC 33577 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1104 03/26/2014 2/27/14-3/26/14 PCards EXTENSION CONFERENCE S 1,201.30 150.00 1,651.30 EXTENSION CONFERENCE S PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 450.00 1,651.30 ** 7,500.00 Budgeted 5,848.70 Remaining 22 % Used Account: 135-60100-030-000 Travel & per diem 966 03/10/2014 PR 3-14-14 Travel & per diem 703.16 28.22 731.38 PR 1104 03/26/2014 2/27/14-3/26/14 PCards SHELL OIL 575420870QPS 4.43 735.81 SHELL OIL 575420870QPS PC 1104 03/26/2014 2/27/14-3/26/14 PCards STARBUCKS #02832 HILLS 1.89 737.70 STARBUCKS #02832 HILLS PC 1060 03/26/2014 Mar A/P Mileage reimbursement 22.32 760.02 LAURIE SLAGHT 33599 AP 1060 03/26/2014 Mar A/P TRWA Conference 40.00 800.02 JENNIFER MCKNIGHT 33598 AP 1058 03/28/2014 MUD Payroll 3/28/14 Travel & per diem 22.40 822.42 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 119.26 822.42 ** 5,000.00 Budgeted 4,177.58 Remaining 16 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 1126 03/31/2014 Recode unbudgeted expenses 508.62 80.81 589.43 GL _______________ Account: 135-60125-030-000 Advertising Totals: 80.81 589.43 ** 2,500.00 Budgeted 1,910.57 Remaining 24 % Used Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-030-000 Miscellaneous Expenses 1104 03/26/2014 2/27/14-3/26/14 PCards HOT & CREAMY DONUTS 346.54 14.61 361.15 HOT & CREAMY DONUTS PC 1104 03/26/2014 2/27/14-3/26/14 PCards STARBUCKS #06552 TROPH 15.10 376.25 STARBUCKS #06552 TROPH PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 29.71 376.25 ** 22,870.00 Budgeted 22,493.75 Remaining 2 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used Account: 135-65055-030-000 Hardware 1060 03/26/2014 Mar A/P IT BOA 1,745.66 233.58 1,979.24 TOWN OF TROPHY CLUB 33609 AP 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 198.80 2,178.04 TOWN OF TROPHY CLUB 33609 AP _______________ Account: 135-65055-030-000 Hardware Totals: 432.38 2,178.04 ** 13,562.00 Budgeted 11,383.96 Remaining 16 % Used Account: 135-65085-030-000 Office Supplies 954 03/07/2014 AP-March office supplies 2,093.44 57.98 2,151.42 OFFICE DEPOT, INC 33538 AP 958 03/07/2014 March A/P Office Supplies 51.41 2,202.83 OFFICE DEPOT, INC 33538 AP 994 03/18/2014 Mar A/P Office Supplies 33.57 2,236.40 OFFICE DEPOT, INC 33571 AP 1104 03/26/2014 2/27/14-3/26/14 PCards JABO'S ACE HARDWARE 3.90 2,240.30 JABO'S ACE HARDWARE PC 1104 03/26/2014 2/27/14-3/26/14 PCards BLANKDOORHA 127.44 2,367.74 BLANKDOORHA PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-030-000 Office Supplies Totals: 274.30 2,367.74 ** 9,100.00 Budgeted 6,732.26 Remaining 26 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 1,246.33 227.42 1,473.75 TOWN OF TROPHY CLUB 33609 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 227.42 1,473.75 ** 5,732.00 Budgeted 4,258.25 Remaining 26 % Used Account: 135-65095-030-000 Maintenance Supplies 1104 03/26/2014 2/27/14-3/26/14 PCards SAMSCLUB #4795 1,111.49 333.33 1,444.82 SAMSCLUB #4795 PC 1106 03/31/2014 Mar A/P Kitchen supplies/Adm 24.57 1,469.39 COSTCO WHOLESALE 33617 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 357.90 1,469.39 ** 2,500.00 Budgeted 1,030.61 Remaining 59 % Used Account: 135-65097-030-000 Vending Machine Supplies 1078 03/28/2014 WWTP Vending 51.00 25.96 76.96 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 25.96 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing 994 03/18/2014 Mar A/P Feb Billing and printing of in 1,401.00 854.00 2,255.00 DATAPROSE LLC 33559 AP 1104 03/26/2014 2/27/14-3/26/14 PCards BANNERSONTHECHEAP.COM 93.27 2,348.27 BANNERSONTHECHEAP.COM PC _______________ Account: 135-65105-030-000 Printing Totals: 947.27 2,348.27 ** 4,000.00 Budgeted 1,651.73 Remaining 59 % Used Account: 135-69170-030-000 Copier Lease Installments 1060 03/26/2014 Mar A/P Premier,Symonds,Pitney B,Kyoce 1,027.40 256.85 1,284.25 TOWN OF TROPHY CLUB 33609 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,284.25 ** 3,450.00 Budgeted 2,165.75 Remaining 37 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 499,943.57 ** 1,055,199.00 Budgeted 555,255.43 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 954 03/07/2014 AP-March legal 96,808.47 4,060.53 100,869.00 WHITAKER CHALK SWINDLE 33549 AP 954 03/07/2014 AP-March legal 1,489.35 102,358.35 WHITAKER CHALK SWINDLE 33549 AP 954 03/07/2014 AP-March legal 2,677.00 105,035.35 THE LISTON LAW FIRM, P.C. 33546 AP 954 03/07/2014 AP-March legal 239.85 105,275.20 WHITAKER CHALK SWINDLE 33549 AP 954 03/07/2014 AP-March legal 1,209.60 106,484.80 WHITAKER CHALK SWINDLE 33549 AP 954 03/07/2014 AP-March legal 470.40 106,955.20 WHITAKER CHALK SWINDLE 33549 AP 961 03/07/2014 March A/P Feb Legal 4,317.50 111,272.70 FREEMAN & CORBETT 33551 AP 1060 03/26/2014 Mar A/P Feb General 285.60 111,558.30 WHITAKER CHALK SWINDLE 33611 AP 1060 03/26/2014 Mar A/P Feb Legal 67.20 111,625.50 WHITAKER CHALK SWINDLE 33611 AP 1060 03/26/2014 Mar A/P Feb Legal 2,200.80 113,826.30 WHITAKER CHALK SWINDLE 33611 AP 1060 03/26/2014 Mar A/P Feb Legal 554.40 114,380.70 WHITAKER CHALK SWINDLE 33611 AP 1060 03/26/2014 Mar A/P Feb Legal 201.60 114,582.30 WHITAKER CHALK SWINDLE 33611 AP _______________ Account: 135-55045-039-000 Legal Totals: 17,773.83 114,582.30 ** 131,300.00 Budgeted 16,717.70 Remaining 87 % Used Account: 135-55055-039-000 Auditing 21,200.00 .00 21,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 954 03/07/2014 AP-March 2nd quarter DCAQ Budget 4,329.38 1,914.46 6,243.84 DENTON CENTRAL APPRAISAL DISTR 33519 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,914.46 6,243.84 ** 10,000.00 Budgeted 3,756.16 Remaining 62 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 144,477.54 ** 166,940.00 Budgeted 22,462.46 Remaining 87 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 504,674.39 .00 Budgeted (504,674.39) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 1112 03/31/2014 Bank Statement Interest/March (46.69) (4.15) (50.84) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (4.15) (50.84) ** .00 Budgeted 50.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (50.84) ** .00 Budgeted 50.84 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 82,578.56 .00 Budgeted (82,578.56) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 505,830 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 17,356 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 528,033 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 17,356 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 17,356 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 492,798 TOTAL FUND BALANCE 510,677 TOTAL LIABILITIES AND FUND BALANCE 528,033 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 13:51 04/07/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 11,139.02- 380,081.92- 97.653 9,134.08- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 127.12- 125.73- 5.029 2,374.27- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 809.84- 1,443.90- 90.244 156.10- Subtotal: 393,316.00- 393,316.00- 12,075.98- 381,651.55- 97.034 11,664.45- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- 12.74- 33.41- 8.909 341.59- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 12.74- 214,312.41- 99.841 341.59- Program number: 624,495.00- 624,495.00- 12,088.72- 595,963.96- 95.431 28,531.04- Department number: Revenues 624,495.00- 624,495.00- 12,088.72- 595,963.96- 95.431 28,531.04- Revenues Subtotal ----------- 624,495.00- 624,495.00- 12,088.72- 595,963.96- 95.431 28,531.04- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 13:51 04/07/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 52.317 94,028.75 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 103,166.25 16.520 521,328.75 Program number: 624,495.00 624,495.00 103,166.25 16.520 521,328.75 Department number: Administration 624,495.00 624,495.00 103,166.25 16.520 521,328.75 Expenditures Subtotal ----------- 624,495.00 624,495.00 103,166.25 16.520 521,328.75 Fund number: 533 MUD 1 I&S Consolidated 12,088.72- 492,797.71- 492,797.71 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 953 03/03/2014 Property Taxes/Assessments (368,942.90) (16.94) (368,959.84) AP 1011 03/04/2014 Property Taxes/Assessments (125.90) (369,085.74) GL 1014 03/05/2014 Property Taxes/Assessments (97.84) (369,183.58) GL 1015 03/06/2014 Property Taxes/Assessments (8,013.35) (377,196.93) GL 1016 03/07/2014 Property Taxes/Assessments (614.06) (377,810.99) GL 1017 03/10/2014 Property Taxes/Assessments (28.99) (377,839.98) GL 1018 03/11/2014 Property Taxes/Assessments (370.69) (378,210.67) GL 1019 03/12/2014 Property Taxes/Assessments (68.17) (378,278.84) GL 1020 03/13/2014 Property Taxes/Assessments (61.34) (378,340.18) GL 1021 03/14/2014 Property Taxes/Assessments (49.68) (378,389.86) GL 1022 03/17/2014 Property Taxes/Assessments (189.33) (378,579.19) GL 1023 03/18/2014 Property Taxes/Assessments (112.81) (378,692.00) GL 1029 03/19/2014 Property Taxes/Assessments (70.97) (378,762.97) GL 1030 03/20/2014 Property Taxes/Assessments (13.28) (378,776.25) GL 1081 03/21/2014 Property Taxes/Assessments (262.19) (379,038.44) GL 1082 03/24/2014 Property Taxes/Assessments 60.46 (378,977.98) GL 1083 03/25/2014 Property Taxes/Assessments (306.58) (379,284.56) GL 1084 03/26/2014 Property Taxes/Assessments (154.18) (379,438.74) GL 1085 03/27/2014 Property Taxes/Assessments (415.27) (379,854.01) GL 1102 03/28/2014 Property Taxes/Assessments (59.23) (379,913.24) GL 1103 03/31/2014 Property Taxes/Assessments (168.68) (380,081.92) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (11,139.02) (380,081.92) ** (389,216.00) Budgeted (9,134.08) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1017 03/10/2014 Property Taxes/Assessments 1.39 12.74 14.13 GL 1084 03/26/2014 Property Taxes/Assessments (139.86) (125.73) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (127.12) (125.73) ** (2,500.00) Budgeted (2,374.27) Remaining 5 % Used Account: 533-40015-000-000 Property Taxes/P & I 953 03/03/2014 Property Taxes/Assessments (634.06) (1.36) (635.42) AP 1011 03/04/2014 Property Taxes/Assessments (8.81) (644.23) GL 1014 03/05/2014 Property Taxes/Assessments (6.84) (651.07) GL 1015 03/06/2014 Property Taxes/Assessments (562.39) (1,213.46) GL 1016 03/07/2014 Property Taxes/Assessments (50.08) (1,263.54) GL 1017 03/10/2014 Property Taxes/Assessments (.10) (1,263.64) GL 1018 03/11/2014 Property Taxes/Assessments (30.17) (1,293.81) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1020 03/13/2014 Property Taxes/Assessments (634.06) (4.46) (1,298.27) GL 1022 03/17/2014 Property Taxes/Assessments (7.34) (1,305.61) GL 1023 03/18/2014 Property Taxes/Assessments (8.65) (1,314.26) GL 1081 03/21/2014 Property Taxes/Assessments (13.73) (1,327.99) GL 1082 03/24/2014 Property Taxes/Assessments (10.80) (1,338.79) GL 1083 03/25/2014 Property Taxes/Assessments (14.40) (1,353.19) GL 1084 03/26/2014 Property Taxes/Assessments (54.92) (1,408.11) GL 1085 03/27/2014 Property Taxes/Assessments (30.97) (1,439.08) GL 1103 03/31/2014 Property Taxes/Assessments (4.82) (1,443.90) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (809.84) (1,443.90) ** (1,600.00) Budgeted (156.10) Remaining 90 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1112 03/31/2014 Bank Statement Interest/March (20.67) (12.74) (33.41) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (12.74) (33.41) ** (375.00) Budgeted (341.59) Remaining 9 % Used Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (595,963.96) ** (624,495.00) Budgeted (28,531.04) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 13:51 04/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense 103,166.25 .00 103,166.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 103,166.25 ** 197,195.00 Budgeted 94,028.75 Remaining 52 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 103,166.25 ** 624,495.00 Budgeted 521,328.75 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (492,797.71) .00 Budgeted 492,797.71 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (517,519.16) **** .00 Budgeted 517,519.16 Remaining 0 % Used ******* End of Report *********