Loading...
HomeMy WebLinkAboutJan Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 31, 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 1,292,549 PREPAID EXPENSES 13,376 ADVALOREM PROPERTY TAXES RECEIVABLE 148,914 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 21,849 UTILITY AND OTHER ACCOUNTS RECEIVABLE 6,340 TOTAL ASSETS 1,483,028 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 170,763 ACCOUNTS AND OTHER PAYABLES 1,148 TOTAL LIABILITIES 171,911 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 815,429 TOTAL FUND BALANCE 1,311,117 TOTAL LIABILITIES AND FUND BALANCE 1,483,028 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 15:55 02/06/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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- 55,635.17- 287,027.90- 93.970 18,417.10- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 321,566.24- 793,582.83- 85.556 133,972.17- 122-40011-000-000 Property Taxes/Fire-Delinquent 43.91- 7.49 7.49- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- .15- .020 749.85- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 42.31- 113.71- 2.527 4,386.29- Subtotal: 1,238,250.00- 1,238,250.00- 377,287.63- 1,080,717.75- 87.278 157,532.25- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,200.00- 2,000.00- 33.333 4,000.00- Subtotal: 6,000.00- 6,000.00- 1,200.00- 2,000.00- 33.333 4,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 225.00- 375.00- 53.571 325.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- 225.00- 375.00- 3.505 10,325.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 2,075.00- 3,425.00- 57.083 2,575.00- Subtotal: 6,000.00- 6,000.00- 2,075.00- 3,425.00- 57.083 2,575.00- Program number: 1,260,950.00- 1,260,950.00- 380,787.63- 1,086,517.75- 86.167 174,432.25- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 380,787.63- 1,086,517.75- 86.167 174,432.25- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 380,787.63- 1,086,517.75- 86.167 174,432.25- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 15:55 02/06/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 49,802.00 150,950.81 33.109 304,965.19 122-50010-045-000 Overtime 44,225.00 44,225.00 2,652.11 11,399.31 25.776 32,825.69 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 387.50 1,464.39 33.664 2,885.61 122-50020-045-000 Retirement 70,991.00 70,991.00 7,622.57 25,340.25 35.695 45,650.75 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,008.68 16,034.52 28.147 40,933.48 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 326.31 1,305.03 30.852 2,924.97 122-50028-045-000 Vision Insurance 892.00 892.00 68.43 273.57 30.669 618.43 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 306.96 1,227.64 28.886 3,022.36 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 3,080.05 10,523.38 31.908 22,456.62 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 720.13 2,460.43 31.900 5,252.57 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 50.65 52.90 2.342 2,206.10 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 2,651.16 30.445 6,056.84 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 500.00 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 69,688.18 241,628.25 33.895 471,250.75 122-55030-045-000 Software & Support 8,682.00 8,682.00 8,682.00 122-55045-045-000 Legal 5,000.00 5,000.00 2,505.51- 2,505.51- -50.110 7,505.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 797.04 3,211.25 15.686 17,260.75 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 161.47 1,599.73 10.773 13,250.27 122-55095-045-000 Equipment Maintenance 692.83- 122-55100-045-000 Building Maintenance 49.02- Subtotal: 49,004.00 49,004.00 2,288.85- 2,305.47 4.705 46,698.53 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 75.00 959.21 22.639 3,277.79 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 682.59 2,226.59 33.901 4,341.41 122-60025-045-000 Water 1,500.00 1,500.00 93.66- 248.51 16.567 1,251.49 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 122-60035-045-000 Postage 100.00 100.00 20.42 20.420 79.58 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 4,037.00 33.336 8,073.00 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 5,309.88 7,892.64 51.994 7,287.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,624.00 37.944 2,656.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 1,121.60 24.505 3,455.40 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 1,500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 15:55 02/06/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 95.25 132.75 6.638 1,867.25 122-60243-045-000 Prior Year Expense 3,456.54 3,456.54 3,456.54- 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 272.60 359.97 35.997 640.03 Subtotal: 276,531.00 276,531.00 10,807.45 23,536.49 8.511 252,994.51 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 630.81 2,724.95 23.294 8,973.05 122-65010-045-000 Uniforms 3,360.00 3,360.00 401.91 491.74 14.635 2,868.26 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 130.00 130.00 1.711 7,470.00 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 76.46 3.058 2,423.54 122-65085-045-000 Office Supplies 1,000.00 1,000.00 84.44 8.444 915.56 122-65095-045-000 Maintenance Supplies 111.16 111.16- 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 1,162.72 3,618.75 13.276 23,639.25 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 3,031.00 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 195,278.00 Program number: 1,260,950.00 1,260,950.00 79,369.50 271,088.96 21.499 989,861.04 Department number: Fire 1,260,950.00 1,260,950.00 79,369.50 271,088.96 21.499 989,861.04 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 79,369.50 271,088.96 21.499 989,861.04 Fund number: 122 Trophy Club MUD Fire Dept. 301,418.13- 815,428.79- 815,428.79 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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 728 01/02/2014 Property Taxes & Assessments (231,392.73) (8,548.02) (239,940.75) GL 729 01/03/2014 Property Taxes & Assessments (1,398.90) (241,339.65) GL 730 01/07/2014 Property Taxes & Assessments (1,089.83) (242,429.48) GL 731 01/08/2014 Property Taxes & Assessments (904.60) (243,334.08) GL 732 01/09/2014 Property Taxes & Assessments (9,326.02) (252,660.10) GL 733 01/10/2014 Property Taxes & Assessments (656.20) (253,316.30) GL 734 01/13/2014 Property Taxes & Assessments (1,381.91) (254,698.21) GL 736 01/14/2014 Property Taxes & Assessments (447.01) (255,145.22) GL 739 01/15/2014 Property Taxes & Assessments (1,126.73) (256,271.95) GL 740 01/16/2014 Property Taxes & Assessments (850.53) (257,122.48) GL 741 01/17/2014 Property Taxes & Assessments (2,197.95) (259,320.43) GL 743 01/21/2014 Property Taxes & Assessments (1,065.44) (260,385.87) GL 744 01/22/2014 Property Taxes & Assessments (1,919.79) (262,305.66) GL 745 01/23/2014 Property Taxes & Assessments (3,008.78) (265,314.44) GL 746 01/24/2014 Property Taxes & Assessments (6,772.00) (272,086.44) GL 747 01/27/2014 Property Taxes & Assessments (3,885.94) (275,972.38) GL 748 01/28/2014 Property Taxes & Assessments (2,229.53) (278,201.91) GL 749 01/29/2014 Property Taxes & Assessments (1,019.38) (279,221.29) GL 759 01/30/2014 Property Taxes & Assessments (1,225.70) (280,446.99) GL 760 01/31/2014 Property Taxes & Assessments (6,580.91) (287,027.90) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (55,635.17) (287,027.90) ** (305,445.00) Budgeted (18,417.10) Remaining 94 % 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 728 01/02/2014 Property Taxes & Assessments (472,016.59) (27,725.39) (499,741.98) GL 729 01/03/2014 Property Taxes & Assessments (2,275.95) (502,017.93) GL 730 01/07/2014 Property Taxes & Assessments (9,574.03) (511,591.96) GL 731 01/08/2014 Property Taxes & Assessments (5,014.58) (516,606.54) GL 732 01/09/2014 Property Taxes & Assessments (19,010.16) (535,616.70) GL 733 01/10/2014 Property Taxes & Assessments (4,836.50) (540,453.20) GL 734 01/13/2014 Property Taxes & Assessments (5,829.97) (546,283.17) GL 736 01/14/2014 Property Taxes & Assessments (16,365.14) (562,648.31) GL 739 01/15/2014 Property Taxes & Assessments (6,011.07) (568,659.38) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 740 01/16/2014 Property Taxes & Assessments (472,016.59) (7,422.57) (576,081.95) GL 741 01/17/2014 Property Taxes & Assessments (4,144.38) (580,226.33) GL 743 01/21/2014 Property Taxes & Assessments (4,107.42) (584,333.75) GL 744 01/22/2014 Property Taxes & Assessments (8,811.46) (593,145.21) GL 745 01/23/2014 Property Taxes & Assessments (7,482.44) (600,627.65) GL 746 01/24/2014 Property Taxes & Assessments (4,899.87) (605,527.52) GL 747 01/27/2014 Property Taxes & Assessments (15,535.54) (621,063.06) GL 764 01/27/2014 Rev part JE 747 Prop Taxes 15,535.54 (605,527.52) GL 765 01/27/2014 Property Taxes & Assessments (15,625.87) (621,153.39) GL 748 01/28/2014 Property Taxes & Assessments (143,888.48) (765,041.87) GL 749 01/29/2014 Property Taxes & Assessments (9,468.68) (774,510.55) GL 759 01/30/2014 Property Taxes & Assessments (5,924.60) (780,435.15) GL 760 01/31/2014 Property Taxes & Assessments (13,147.68) (793,582.83) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (321,566.24) (793,582.83) ** (927,555.00) Budgeted (133,972.17) Remaining 86 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 734 01/13/2014 Property Taxes & Assessments 51.40 (43.91) 7.49 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (43.91) 7.49 ** .00 Budgeted (7.49) Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (.15) .00 (.15) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (.15) ** (750.00) Budgeted (749.85) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 728 01/02/2014 Property Taxes & Assessments (71.40) (4.69) (76.09) GL 732 01/09/2014 Property Taxes & Assessments (9.52) (85.61) GL 733 01/10/2014 Property Taxes & Assessments (12.73) (98.34) GL 734 01/13/2014 Property Taxes & Assessments (9.67) (108.01) GL 747 01/27/2014 Property Taxes & Assessments (2.91) (110.92) GL 764 01/27/2014 Rev part JE 747 Prop Taxes 2.91 (108.01) GL 765 01/27/2014 Property Taxes & Assessments (2.92) (110.93) GL 748 01/28/2014 Property Taxes & Assessments (2.92) (113.85) GL 772 01/28/2014 Correct JE 765/Rendition pnlty 2.92 (110.93) GL 759 01/30/2014 Property Taxes & Assessments (2.78) (113.71) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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-40020-000-000 Property Taxes/Fire P&I Totals: (42.31) (113.71) ** (4,500.00) Budgeted (4,386.29) Remaining 3 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (800.00) (1,200.00) (2,000.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,200.00) (2,000.00) ** (6,000.00) Budgeted (4,000.00) Remaining 33 % Used Account: 122-43400-000-000 Fire Inspections 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (150.00) (225.00) (375.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (375.00) ** (700.00) Budgeted (325.00) Remaining 54 % 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 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (1,350.00) (2,075.00) (3,425.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (2,075.00) (3,425.00) ** (6,000.00) Budgeted (2,575.00) Remaining 57 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,086,517.75) ** (1,260,950.00) Budgeted (174,432.25) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 637 01/03/2014 Fire Payroll 101,148.81 16,652.58 117,801.39 GL 639 01/17/2014 FD Payroll 16,404.87 134,206.26 GL 691 01/31/2014 Fire Payroll 1/31/14 16,744.55 150,950.81 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 49,802.00 150,950.81 ** 455,916.00 Budgeted 304,965.19 Remaining 33 % Used Account: 122-50010-045-000 Overtime 639 01/17/2014 FD Payroll 8,747.20 2,652.11 11,399.31 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,652.11 11,399.31 ** 44,225.00 Budgeted 32,825.69 Remaining 26 % 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 637 01/03/2014 Fire Payroll 1,076.89 387.50 1,464.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 387.50 1,464.39 ** 4,350.00 Budgeted 2,885.61 Remaining 34 % Used Account: 122-50020-045-000 Retirement 637 01/03/2014 Fire Payroll 17,717.68 2,356.31 20,073.99 GL 639 01/17/2014 FD Payroll 2,803.19 22,877.18 GL 691 01/31/2014 Fire Payroll 1/31/14 2,463.07 25,340.25 GL _______________ Account: 122-50020-045-000 Retirement Totals: 7,622.57 25,340.25 ** 70,991.00 Budgeted 45,650.75 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 637 01/03/2014 Fire Payroll 12,025.84 2,297.54 14,323.38 GL 639 01/17/2014 FD Payroll 1,711.14 16,034.52 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,008.68 16,034.52 ** 56,968.00 Budgeted 40,933.48 Remaining 28 % Used Account: 122-50027-045-000 Dental Insurance 637 01/03/2014 Fire Payroll 978.72 163.14 1,141.86 GL 639 01/17/2014 FD Payroll 163.17 1,305.03 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 326.31 1,305.03 ** 4,230.00 Budgeted 2,924.97 Remaining 31 % Used Account: 122-50028-045-000 Vision Insurance 637 01/03/2014 Fire Payroll 205.14 34.22 239.36 GL 639 01/17/2014 FD Payroll 34.21 273.57 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.43 273.57 ** 892.00 Budgeted 618.43 Remaining 31 % Used Account: 122-50029-045-000 Life Insurance & Other 637 01/03/2014 Fire Payroll 920.68 153.49 1,074.17 GL 639 01/17/2014 FD Payroll 153.47 1,227.64 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 306.96 1,227.64 ** 4,250.00 Budgeted 3,022.36 Remaining 29 % Used Account: 122-50030-045-000 Social Security Taxes 637 01/03/2014 Fire Payroll 7,443.33 958.46 8,401.79 GL 639 01/17/2014 FD Payroll 1,083.48 9,485.27 GL 691 01/31/2014 Fire Payroll 1/31/14 1,038.11 10,523.38 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,080.05 10,523.38 ** 32,980.00 Budgeted 22,456.62 Remaining 32 % Used Account: 122-50035-045-000 Medicare Taxes 637 01/03/2014 Fire Payroll 1,740.30 224.08 1,964.38 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 639 01/17/2014 FD Payroll 1,740.30 253.30 2,217.68 GL 691 01/31/2014 Fire Payroll 1/31/14 242.75 2,460.43 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 720.13 2,460.43 ** 7,713.00 Budgeted 5,252.57 Remaining 32 % Used Account: 122-50040-045-000 Unemployment Taxes 637 01/03/2014 Fire Payroll 2.25 16.96 19.21 GL 639 01/17/2014 FD Payroll 19.01 38.22 GL 691 01/31/2014 Fire Payroll 1/31/14 14.68 52.90 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 50.65 52.90 ** 2,259.00 Budgeted 2,206.10 Remaining 2 % Used Account: 122-50045-045-000 Workman's Compensation 119 01/01/2014 FD Jan W/C expense 1,988.37 662.79 2,651.16 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 2,651.16 ** 8,708.00 Budgeted 6,056.84 Remaining 30 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % 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 .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 8,682.00 Budgeted 8,682.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 683 01/10/2014 Prime Const/Interpleador suit (2,700.00) (2,700.00) GL 644 01/21/2014 Jan A/P Prime Construction/Fire Statio 194.49 (2,505.51) WHITAKER CHALK SWINDLE 33387 AP _______________ Account: 122-55045-045-000 Legal Totals: (2,505.51) (2,505.51) ** 5,000.00 Budgeted 7,505.51 Remaining -50 % Used Account: 122-55080-045-000 Maintenance & Repairs 685 01/22/2014 Firefighter cable/Dec, Jan 2,414.21 (267.42) 2,146.79 GL 770 01/27/2014 12/27/13-1/27/14 PCards SAMSCLUB #4795 39.98 2,186.77 SAMSCLUB #4795 PC 770 01/27/2014 12/27/13-1/27/14 PCards AT&T*BILL PAYMENT 128.71 2,315.48 AT&T*BILL PAYMENT PC 770 01/27/2014 12/27/13-1/27/14 PCards SAMSCLUB #4795 20.57 2,336.05 SAMSCLUB #4795 PC 770 01/27/2014 12/27/13-1/27/14 PCards ATT*BILL PAYMENT 157.86 2,493.91 ATT*BILL PAYMENT PC 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (24.51) 2,469.40 AR 783 01/31/2014 Recode FD Equip & Bldg Maint Annual Maint/Cascade System 692.83 3,162.23 GL 783 01/31/2014 Recode FD Equip & Bldg Maint Nov/Dec Rug Service 49.02 3,211.25 GL _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 797.04 3,211.25 ** 20,472.00 Budgeted 17,260.75 Remaining 16 % Used Account: 122-55090-045-000 Vehicle Maintenance 770 01/27/2014 12/27/13-1/27/14 PCards WAL-MART #5247 1,438.26 23.48 1,461.74 WAL-MART #5247 PC 770 01/27/2014 12/27/13-1/27/14 PCards AUTOZONE #4206 137.99 1,599.73 AUTOZONE #4206 PC 770 01/27/2014 12/27/13-1/27/14 PCards ETRAILER (10.00) 1,589.73 ETRAILER PC 770 01/27/2014 12/27/13-1/27/14 PCards ROANOKE AUTO SUPPLY LT 10.00 1,599.73 ROANOKE AUTO SUPPLY LT PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 161.47 1,599.73 ** 14,850.00 Budgeted 13,250.27 Remaining 11 % Used Account: 122-55095-045-000 Equipment Maintenance 783 01/31/2014 Recode FD Equip & Bldg Maint Annual Maint/Cascade System 692.83 (692.83) .00 GL _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: (692.83) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance 783 01/31/2014 Recode FD Equip & Bldg Maint 49.02 (49.02) .00 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: (49.02) .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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-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 637 01/03/2014 Fire Payroll 884.21 75.00 959.21 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 75.00 959.21 ** 4,237.00 Budgeted 3,277.79 Remaining 23 % Used Account: 122-60020-045-000 Electricity/Gas 661 01/24/2014 Jan A/P Elec Fire Station 12/12-1/13/1 1,544.00 883.67 2,427.67 HUDSON ENERGY SERVICES, LLC 33395 AP 688 01/30/2014 Jan A/P Gas Fire Station 12/19-1/20/14 481.50 2,909.17 ATMOS ENERGY 33405 AP 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (682.58) 2,226.59 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 682.59 2,226.59 ** 6,568.00 Budgeted 4,341.41 Remaining 34 % Used Account: 122-60025-045-000 Water 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: 342.17 (93.66) 248.51 AR _______________ Account: 122-60025-045-000 Water Totals: (93.66) 248.51 ** 1,500.00 Budgeted 1,251.49 Remaining 17 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,279.00 Budgeted 214,279.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 20.42 .00 20.42 _______________ Account: 122-60035-045-000 Postage Totals: .00 20.42 ** 100.00 Budgeted 79.58 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 50 01/01/2014 Jan Ins & W/C Expense 3,027.75 1,009.25 4,037.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 4,037.00 ** 12,110.00 Budgeted 8,073.00 Remaining 33 % 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 628 01/17/2014 Jan A/P FY 14 NEFDA dues & memberships 2,582.76 5,159.88 7,742.64 NORTH EAST FIRE DEPT ASSOC 33371 AP 628 01/17/2014 Jan A/P 2014 Membership Dues 150.00 7,892.64 TX FIRE CHIEFS ASSOCIATION 33381 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 5,309.88 7,892.64 ** 15,180.00 Budgeted 7,287.36 Remaining 52 % Used Account: 122-60080-045-000 Schools & Training 1,624.00 .00 1,624.00 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,624.00 ** 4,280.00 Budgeted 2,656.00 Remaining 38 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used Account: 122-60100-045-000 Travel & per diem 1,121.60 .00 1,121.60 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,121.60 ** 4,577.00 Budgeted 3,455.40 Remaining 25 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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: 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 .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 628 01/17/2014 Jan A/P Flags 37.50 115.50 153.00 SYMONDS FLAGS & POLES 33373 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 37.50 190.50 TOWN OF TROPHY CLUB 33419 AP 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (57.75) 132.75 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 95.25 132.75 ** 2,000.00 Budgeted 1,867.25 Remaining 7 % Used Account: 122-60243-045-000 Prior Year Expense 661 01/24/2014 Jan A/P FD HSA Allotment pd by Town FY 3,456.54 3,456.54 TOWN OF TROPHY CLUB 33403 AP _______________ Account: 122-60243-045-000 Prior Year Expense Totals: 3,456.54 3,456.54 ** .00 Budgeted (3,456.54) Remaining 0 % Used Account: 122-60245-045-000 Miscellaneous Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 657 01/03/2014 Recode JE611/ESD2 Denton Fees 87.37 (861.00) (773.63) GL 729 01/03/2014 Property Taxes & Assessments 861.00 87.37 GL 661 01/24/2014 Jan A/P Fire XMAS party, SHI, Kyocera 262.61 349.98 TOWN OF TROPHY CLUB 33403 AP 770 01/27/2014 12/27/13-1/27/14 PCards THE HOME DEPOT 6581 9.99 359.97 THE HOME DEPOT 6581 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 272.60 359.97 ** 1,000.00 Budgeted 640.03 Remaining 36 % Used Account: 122-65005-045-000 Fuel & Lube 776 01/31/2014 Jan Gas Log 2,094.14 630.81 2,724.95 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 630.81 2,724.95 ** 11,698.00 Budgeted 8,973.05 Remaining 23 % Used Account: 122-65010-045-000 Uniforms 661 01/24/2014 Jan A/P Uniforms/Boone 89.83 796.33 886.16 GST PUBLIC SAFETY SUPPLY 33392 AP 661 01/24/2014 Jan A/P Aterations 7.50 893.66 GST PUBLIC SAFETY SUPPLY 33392 AP 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (401.92) 491.74 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 401.91 491.74 ** 3,360.00 Budgeted 2,868.26 Remaining 15 % Used Account: 122-65015-045-000 Protective Clothing 628 01/17/2014 Jan A/P Protective clothing-gloves 130.00 130.00 CASCO INDUSTRIES INC 33361 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 130.00 130.00 ** 7,600.00 Budgeted 7,470.00 Remaining 2 % 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 76.46 .00 76.46 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 76.46 ** 2,500.00 Budgeted 2,423.54 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 84.44 .00 84.44 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 84.44 ** 1,000.00 Budgeted 915.56 Remaining 8 % Used Account: 122-65095-045-000 Maintenance Supplies 111.16 .00 111.16 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 111.16 ** .00 Budgeted (111.16) 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 .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 3,031.00 Budgeted 3,031.00 Remaining 0 % 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 Account: 122-69195-045-000 GASB34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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: 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: ------------------------------------------------------------------------------------------------ 271,088.96 ** 1,260,950.00 Budgeted 989,861.04 Remaining 21 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (815,428.79) .00 Budgeted 815,428.79 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 31, 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 1/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 137,540 - - 137,540 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,501,513 - - 1,501,513 INVESTMENTS-TEXPOOL 985,833 313,050 187,663 1,486,546 PREPAID EXPENSES 53,153 - - 53,153 ADVALOREM PROPERTY TAXES RECEIVABLE 16,281 - - 16,281 UTILITY AND OTHER ACCOUNTS RECEIVABLE 593,559 - - 593,559 - TOTAL ASSETS 3,288,480 313,050 187,663 3,789,193 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 16,281 - - 16,281 ACCOUNTS AND OTHER PAYABLES 173,472 - 25,149 198,621 CUSTOMER DEPOSITS 246,177 - - 246,177 - TOTAL LIABILITIES 435,930 - 25,149 461,079 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 (135,926) - (82,587) (218,513) - TOTAL FUND BALANCE 2,852,550 313,050 162,514 3,328,114 - TOTAL LIABILITIES AND FUND BALANCE 3,288,480 313,050 187,663 3,789,193 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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- 34,408.83- 84,916.43- 85.558 14,333.57- 135-40002-000-000 Property Taxes/Delinquent 5.55- .68- .68 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 3.05- 10.80 -1.200 910.80- Subtotal: 100,150.00- 100,150.00- 34,417.43- 84,906.31- 84.779 15,243.69- 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- 169,303.16- 762,906.92- 20.348 2,986,403.08- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 142,712.99- 561,566.20- 32.872 1,146,754.80- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 3,178.83- 15,815.76- 24.512 48,706.24- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 878.00- 3,262.00- 35.945 5,813.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 300.00- 800.00- 66.667 400.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 900.00- 2,550.00- 57.955 1,850.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 71.96 7,824.28- 9.831 71,761.72- Subtotal: 5,616,414.00- 5,616,414.00- 317,201.02- 1,354,725.16- 24.121 4,261,688.84- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 39,100.00- 147,200.00- 25.287 434,909.00- Subtotal: 582,109.00- 582,109.00- 39,100.00- 147,200.00- 25.287 434,909.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 529.09- 2,077.55- 43.282 2,722.45- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 3,642.12- 35.834 6,521.88- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,333.32- 33.333 4,666.68- 135-49030-000-000 Vending Revenue 350.00- 350.00- 57.00- 98.00- 28.000 252.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- 10,928.00- 32,226.77- 38.365 51,773.23- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 101.67- 153.28- 5.109 2,846.72- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 13,109.62- 40,531.04- 33.984 78,732.96- Program number: 6,417,937.00- 6,417,937.00- 403,828.07- 1,627,444.87- 25.358 4,790,492.13- Department number: Revenues 6,417,937.00- 6,417,937.00- 403,828.07- 1,627,444.87- 25.358 4,790,492.13- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 403,828.07- 1,627,444.87- 25.358 4,790,492.13- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 32,574.42 85,372.13 29.673 202,336.87 135-50010-010-000 Overtime 13,391.00 13,391.00 3,496.97 6,535.13 48.802 6,855.87 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 325.00 1,300.00 25.490 3,800.00 135-50020-010-000 Retirement 27,847.00 27,847.00 3,268.40 9,254.45 33.233 18,592.55 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,439.98 11,900.61 24.622 36,433.39 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 929.61 23.642 3,002.39 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 217.90 24.960 655.10 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 15.75 765.24 23.147 2,540.76 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 2,250.94 6,442.38 33.399 12,846.62 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 526.44 1,506.70 33.401 3,004.30 135-50040-010-000 Unemployment Taxes 54.00 54.00 36.39 38.83 71.907 15.17 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 3,209.80 32.656 6,619.20 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 8.99 85.77 28.590 214.23 Subtotal: 429,580.00 429,580.00 47,057.88 132,697.45 30.890 296,882.55 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 15,453.08 25,202.19 50.404 24,797.81 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 21.48 1,076.81 21.536 3,923.19 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 50.00 248.33 7.095 3,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 235.00 680.00 12.364 4,820.00 Subtotal: 67,000.00 67,000.00 15,759.56 27,207.33 40.608 39,792.67 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 1,147.80 23.363 3,765.20 135-60020-010-000 Electricity 162,160.00 162,160.00 7,272.13 34,426.03 21.230 127,733.97 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 111.00 700.00 16.730 3,484.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 70.56 171.13 11.802 1,278.87 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 18.00 3.600 482.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 22,875.49 29,355.59 61.932 18,044.41 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 105,632.30 389,555.48 16.659 1,948,917.52 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 168.00 528.70 15.106 2,971.30 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 3,500.00 Subtotal: 2,567,580.00 2,567,580.00 136,135.48 456,191.73 17.767 2,111,388.27 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 1,110.18 3,849.45 16.606 19,331.55 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 1,831.63 56.013 1,438.37 135-65030-010-000 Chemicals 5,000.00 5,000.00 2,045.09 40.902 2,954.91 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 167.81 184.73 18.473 815.27 135-65050-010-000 Meter Expense 143,550.00 143,550.00 1,480.00 57,177.12 39.831 86,372.88 Subtotal: 177,201.00 177,201.00 2,757.99 65,552.96 36.994 111,648.04 135-69005-010-000 Capital Expenses 37,000.00 37,000.00 37,000.00 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 489,980.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 19,268.00 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 Capital Repair-Ground Storage 106,847.00 106,847.00 31,028.52 100,816.54 94.356 6,030.46 Subtotal: 690,595.00 690,595.00 31,028.52 100,816.54 14.599 589,778.46 Program number: 3,931,956.00 3,931,956.00 232,739.43 782,466.01 19.900 3,149,489.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/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 398.49 518.49 51.849 481.51 Subtotal: 1,000.00 1,000.00 398.49 518.49 51.849 481.51 135-60135-010-001 TCEQ Fees & Permits 2,253.85 2,253.85- Subtotal: 2,253.85 2,253.85- Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 398.49 2,772.34 277.234 1,772.34- Department number: Water 3,932,956.00 3,932,956.00 233,137.92 785,238.35 19.966 3,147,717.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 22,762.38 63,559.26 31.326 139,334.74 135-50010-020-000 Overtime 11,965.00 11,965.00 1,422.16 5,164.19 43.161 6,800.81 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 1,600.00 33.333 3,200.00 135-50020-020-000 Retirement 19,905.00 19,905.00 2,207.69 7,052.57 35.431 12,852.43 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,241.09 13,068.64 30.063 30,402.36 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 890.76 29.801 2,098.24 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 201.05 30.555 456.95 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 15.75 664.65 28.860 1,638.35 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 1,365.88 4,416.77 31.994 9,388.23 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 319.44 1,032.95 31.990 2,196.05 135-50040-020-000 Unemployment Taxes 36.00 36.00 24.58 24.58 68.278 11.42 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 2,140.32 32.667 4,411.68 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 8.99 37.98 10.851 312.02 Subtotal: 316,105.00 316,105.00 32,565.68 102,914.22 32.557 213,190.78 135-55070-020-000 Independent Labor 35,605.00 281,411.25 281,411.25- 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 14,077.45 18,088.09 51.680 16,911.91 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 257.98 939.49 46.975 1,060.51 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 2,615.45 9,969.77 19.173 42,030.23 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,694.13 7,294.13 24.314 22,705.87 Subtotal: 119,500.00 119,500.00 54,250.01 317,702.73 265.860 198,202.73- 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 716.08 21.510 2,612.92 135-60020-020-000 Electricity 148,227.00 148,227.00 8,769.57 31,385.28 21.174 116,841.72 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 160.00 40.000 240.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 2,636.00 135-60090-020-000 Safety Program 250.00 250.00 371.38 148.552 121.38- 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 47.04 266.09 25.342 783.91 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-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 3,000.00 Subtotal: 178,242.00 178,242.00 8,816.61 42,117.36 23.629 136,124.64 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 877.14 3,360.83 22.832 11,359.17 135-65010-020-000 Uniforms 1,752.00 1,752.00 152.99 1,437.27 82.036 314.73 135-65030-020-000 Chemicals 39,000.00 39,000.00 3,448.48 8,078.12 20.713 30,921.88 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 57.65 114.08 45.632 135.92 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 619.85 5,383.58 35.891 9,616.42 Subtotal: 71,722.00 71,722.00 5,156.11 18,464.88 25.745 53,257.12 135-69005-020-000 Capital Expenses 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 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,422.00 135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00 Subtotal: 82,442.00 82,442.00 82,442.00 Program number: 768,011.00 768,011.00 100,788.41 481,199.19 62.655 286,811.81 Department number: Wastewater 768,011.00 768,011.00 100,788.41 481,199.19 62.655 286,811.81 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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,485.19 22,149.83 24.529 68,149.17 135-50010-021-000 Overtime 10,028.00 10,028.00 439.72 1,835.04 18.299 8,192.96 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 600.00 33.333 1,200.00 135-50020-021-000 Retirement 9,025.00 9,025.00 635.33 2,751.98 30.493 6,273.02 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,402.39 6,655.15 28.119 17,012.85 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 504.99 29.653 1,198.01 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 99.53 31.697 214.47 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 5.25 396.41 37.187 669.59 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 399.48 1,726.40 23.198 5,715.60 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 93.43 403.76 23.191 1,337.24 135-50040-021-000 Unemployment Taxes 198.00 198.00 7.07 7.07 3.571 190.93 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 1,070.16 32.667 2,205.84 135-50070-021-000 Employee Relations 200.00 200.00 79.33 110.01 55.005 89.99 Subtotal: 168,673.00 168,673.00 10,091.01 40,417.83 23.962 128,255.17 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 93.28 .392 23,707.72 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 27,301.00 27,301.00 93.28 .342 27,207.72 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 276.00 481.04 36.087 851.96 135-60020-021-000 Electricity 21,178.00 21,178.00 1,978.34 5,979.99 28.237 15,198.01 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 2,254.34 6,461.03 18.240 28,960.97 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 1,299.83 4,172.23 18.629 18,224.77 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 540.75 108.150 40.75- Subtotal: 30,937.00 30,937.00 1,299.83 5,571.20 18.008 25,365.80 135-69005-021-000 Capital Expenses 100,000.00 100,000.00 100,000.00 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 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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 209,837.00 Program number: 472,170.00 472,170.00 13,645.18 52,543.34 11.128 419,626.66 Department number: Collection 472,170.00 472,170.00 13,645.18 52,543.34 11.128 419,626.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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 700.00 3,200.00 32.000 6,800.00 135-50030-026-000 Social Security Taxes 620.00 620.00 43.40 198.40 32.000 421.60 135-50035-026-000 Medicare Taxes 145.00 145.00 10.15 46.40 32.000 98.60 135-50040-026-000 Unemployment Taxes 10.00 10.00 .70 3.20 32.000 6.80 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 11.80 32.778 24.20 Subtotal: 10,811.00 10,811.00 757.20 3,459.80 32.003 7,351.20 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 757.20 3,795.75 16.750 18,865.25 Department number: Board of Directors 22,661.00 22,661.00 757.20 3,795.75 16.750 18,865.25 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 51,889.79 144,340.70 31.466 314,380.30 135-50010-030-000 Overtime 500.00 500.00 59.84 319.71 63.942 180.29 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 4,665.08 14,239.60 34.379 27,179.40 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,602.53 17,933.76 30.961 39,989.24 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 1,499.44 29.401 3,600.56 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 329.21 30.286 757.79 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 36.75 1,837.63 40.991 2,645.37 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 3,088.11 9,357.26 32.650 19,301.74 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 722.22 2,188.40 32.653 4,513.60 135-50040-030-000 Unemployment Taxes 63.00 63.00 48.20 48.20 76.508 14.80 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 514.52 32.668 1,060.48 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 350.05- 2,460.91 49.218 2,539.09 Subtotal: 614,450.00 614,450.00 65,313.14 198,146.84 32.248 416,303.16 135-55030-030-000 Software & Support 59,698.00 59,698.00 3,210.11 18,656.24 31.251 41,041.76 135-55070-030-000 Independent Labor 7,700.00 7,700.00 120.00 2,235.45 29.032 5,464.55 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 182.87- 1,760.13- -39.114 6,260.13 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 1,516.18 23.326 4,983.82 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 4,784.91 25.000 14,355.09 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 50.000 38,524.00 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 612.15 1,764.35 25.916 5,043.65 Subtotal: 196,594.00 196,594.00 5,354.36 65,721.00 33.430 130,873.00 135-60005-030-000 Telephone 11,250.00 11,250.00 419.72 2,916.11 25.921 8,333.89 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 150.00 879.79 24.514 2,709.21 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 6,355.62 7,243.58 47.746 7,927.42 135-60025-030-000 Water 1,500.00 1,500.00 77.76- 124.67 8.311 1,375.33 135-60035-030-000 Postage 28,500.00 28,500.00 1,763.42 6,994.20 24.541 21,505.80 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,735.15 9,530.79 33.642 18,799.21 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 3,712.56 247.504 2,212.56- 135-60055-030-000 Insurance 53,561.00 53,561.00 4,269.73 17,112.17 31.949 36,448.83 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 126.00 12.600 874.00 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 80.00 4,011.95 89.154 488.05 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60080-030-000 Schools & Training 7,500.00 7,500.00 312.30 502.30 6.697 6,997.70 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 101.80 703.16 14.063 4,296.84 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 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 221.70 283.08 1.238 22,586.92 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 16,331.68 54,263.92 26.571 149,957.08 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 5.50 1,677.95 12.372 11,884.05 135-65085-030-000 Office Supplies 9,100.00 9,100.00 376.45 1,576.94 17.329 7,523.06 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 342.21 1,246.33 21.743 4,485.67 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 58.75 815.54 32.622 1,684.46 135-65097-030-000 Vending Machine Supplies 200.00 200.00 23.94 51.00 25.500 149.00 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 806.85 7,767.66 21.291 28,716.34 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 513.70 770.55 22.335 2,679.45 Subtotal: 3,450.00 3,450.00 513.70 770.55 22.335 2,679.45 Program number: 1,055,199.00 1,055,199.00 88,319.73 326,669.97 30.958 728,529.03 Department number: Administration 1,055,199.00 1,055,199.00 88,319.73 326,669.97 30.958 728,529.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 15:55 02/06/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/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 16,530.06 85,943.22 65.456 45,356.78 135-55055-039-000 Auditing 21,840.00 21,840.00 5,300.00 21,200.00 97.070 640.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 4,329.38 43.294 5,670.62 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 166,940.00 24,281.46 113,924.00 68.242 53,016.00 Program number: 166,940.00 166,940.00 24,281.46 113,924.00 68.242 53,016.00 Department number: Non Departmental 166,940.00 166,940.00 24,281.46 113,924.00 68.242 53,016.00 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 460,929.90 1,763,370.60 27.476 4,654,566.40 Fund number: 135 MUD 1 General Fund 57,101.83 135,925.73 135,925.73- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 15:55 02/06/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 6.12- 42.62- 42.62 Subtotal: 6.12- 42.62- 42.62 Program number: 6.12- 42.62- 42.62 Department number: 6.12- 42.62- 42.62 Revenues Subtotal ----------- 6.12- 42.62- 42.62 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 15:55 02/06/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 1/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 6,569.22 82,629.40 82,629.40- Subtotal: 6,569.22 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 6,569.22 82,629.40 82,629.40- Department number: Water 6,569.22 82,629.40 82,629.40- Expenditures Subtotal ----------- 6,569.22 82,629.40 82,629.40- Fund number: 507 MUD 1 Capital Projects 6,563.10 82,586.78 82,586.78- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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 728 01/02/2014 Property Taxes & Assessments (50,507.60) (2,966.72) (53,474.32) GL 729 01/03/2014 Property Taxes & Assessments (243.54) (53,717.86) GL 730 01/07/2014 Property Taxes & Assessments (1,024.46) (54,742.32) GL 731 01/08/2014 Property Taxes & Assessments (536.58) (55,278.90) GL 732 01/09/2014 Property Taxes & Assessments (2,034.16) (57,313.06) GL 733 01/10/2014 Property Taxes & Assessments (517.52) (57,830.58) GL 734 01/13/2014 Property Taxes & Assessments (623.83) (58,454.41) GL 736 01/14/2014 Property Taxes & Assessments (1,751.13) (60,205.54) GL 739 01/15/2014 Property Taxes & Assessments (643.21) (60,848.75) GL 740 01/16/2014 Property Taxes & Assessments (794.24) (61,642.99) GL 741 01/17/2014 Property Taxes & Assessments (443.46) (62,086.45) GL 743 01/21/2014 Property Taxes & Assessments (439.51) (62,525.96) GL 744 01/22/2014 Property Taxes & Assessments (942.86) (63,468.82) GL 745 01/23/2014 Property Taxes & Assessments (800.65) (64,269.47) GL 746 01/24/2014 Property Taxes & Assessments (524.31) (64,793.78) GL 747 01/27/2014 Property Taxes & Assessments (1,662.36) (66,456.14) GL 764 01/27/2014 Rev part JE 747 Prop Taxes 1,662.36 (64,793.78) GL 765 01/27/2014 Property Taxes & Assessments (1,672.03) (66,465.81) GL 748 01/28/2014 Property Taxes & Assessments (15,396.63) (81,862.44) GL 749 01/29/2014 Property Taxes & Assessments (1,013.19) (82,875.63) GL 759 01/30/2014 Property Taxes & Assessments (633.95) (83,509.58) GL 760 01/31/2014 Property Taxes & Assessments (1,406.85) (84,916.43) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (34,408.83) (84,916.43) ** (99,250.00) Budgeted (14,333.57) Remaining 86 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 733 01/10/2014 Property Taxes & Assessments 4.87 (1.37) 3.50 GL 734 01/13/2014 Property Taxes & Assessments (4.18) (.68) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (5.55) (.68) ** .00 Budgeted .68 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 728 01/02/2014 Property Taxes & Assessments 13.85 (.51) 13.34 GL 732 01/09/2014 Property Taxes & Assessments (1.02) 12.32 GL 734 01/13/2014 Property Taxes & Assessments (.91) 11.41 GL 747 01/27/2014 Property Taxes & Assessments (.32) 11.09 GL 764 01/27/2014 Rev part JE 747 Prop Taxes .32 11.41 GL 765 01/27/2014 Property Taxes & Assessments (.31) 11.10 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 748 01/28/2014 Property Taxes & Assessments 13.85 (.31) 10.79 GL 772 01/28/2014 Correct JE 765/Rendition pnlty .31 11.10 GL 759 01/30/2014 Property Taxes & Assessments (.30) 10.80 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (3.05) 10.80 ** (900.00) Budgeted (910.80) Remaining -1 % 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 706 01/14/2014 UB 1/14/14 Connect Fees/BF tes UB20140114-20140114 User: (593,603.76) (100.00) (593,703.76) UB 712 01/14/2014 UB 1/14/14 Portable connect fe UB20140114-20140114 User: (100.00) (593,803.76) UB 742 01/31/2014 UB 1/31/14 Billing UB20140131-20140131 User: (169,103.16) (762,906.92) UB _______________ Account: 135-47000-000-000 Water Totals: (169,303.16) (762,906.92) ** (3,749,310.00) Budgeted (2,986,403.08) Remaining 20 % Used Account: 135-47005-000-000 Sewer 742 01/31/2014 UB 1/31/14 Billing UB20140131-20140131 User: (418,853.21) (142,712.99) (561,566.20) UB _______________ Account: 135-47005-000-000 Sewer Totals: (142,712.99) (561,566.20) ** (1,708,321.00) Budgeted (1,146,754.80) Remaining 33 % Used Account: 135-47025-000-000 Penalties 651 01/21/2014 UB 1/21/14 Penalties UB20140121-20140121 User: (12,636.93) (3,298.09) (15,935.02) UB 756 01/30/2014 UB 01/30/2014 Adjustments UB20140130-20140130 User: 119.26 (15,815.76) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,178.83) (15,815.76) ** (64,522.00) Budgeted (48,706.24) Remaining 25 % Used Account: 135-47030-000-000 Service Charges 577 01/08/2014 UB 1/8/14 Cut Off Fees UB20140108-20140108 User: (2,384.00) (700.00) (3,084.00) UB 703 01/08/2014 UB 1/8/14 After Hours Fee UB20140108-20140108 User: (100.00) (3,184.00) UB 716 01/23/2014 UB 1/23/14 NSF Fee UB20140123-20140123 User: (25.00) (3,209.00) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 720 01/24/2014 UB 1/24/14 Adjustments UB20140124-20140124 User: (2,384.00) (75.00) (3,284.00) UB 738 01/30/2014 UB 1/30/14 NSF Fee UB20140130-20140130 User: 25.00 (3,259.00) UB 742 01/31/2014 UB 1/31/14 Billing UB20140131-20140131 User: (3.00) (3,262.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (878.00) (3,262.00) ** (9,075.00) Budgeted (5,813.00) Remaining 36 % Used Account: 135-47035-000-000 Plumbing Inspections 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (500.00) (300.00) (800.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (300.00) (800.00) ** (1,200.00) Budgeted (400.00) Remaining 67 % Used Account: 135-47045-000-000 Sewer Inspections 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (1,650.00) (900.00) (2,550.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (2,550.00) ** (4,400.00) Budgeted (1,850.00) Remaining 58 % Used Account: 135-47070-000-000 TCCC Effluent Charges 742 01/31/2014 UB 1/31/14 Billing UB20140131-20140131 User: (7,896.24) (186.90) (8,083.14) UB 751 01/31/2014 UB 1/31/14 Adj to effluent wt UB20140131-20140131 User: 258.86 (7,824.28) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: 71.96 (7,824.28) ** (79,586.00) Budgeted (71,761.72) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (108,100.00) (39,100.00) (147,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (39,100.00) (147,200.00) ** (582,109.00) Budgeted (434,909.00) Remaining 25 % Used Account: 135-49010-000-000 Interest Income 753 01/31/2014 Bank Statement Interest/Jan (1,548.46) (61.76) (1,610.22) GL 753 01/31/2014 Bank Statement Interest/Jan (407.97) (2,018.19) GL 753 01/31/2014 Bank Statement Interest/Jan (59.36) (2,077.55) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (529.09) (2,077.55) ** (4,800.00) Budgeted (2,722.45) Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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 679 01/08/2014 AT&T Antenna Lease (2,731.59) (910.53) (3,642.12) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (3,642.12) ** (10,164.00) Budgeted (6,521.88) Remaining 36 % Used Account: 135-49018-000-000 Building Rent Income 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (1,749.99) (583.33) (2,333.32) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue 684 01/16/2014 WWTP Vending (41.00) (57.00) (98.00) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (57.00) (98.00) ** (350.00) Budgeted (252.00) Remaining 28 % 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 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (21,298.77) (10,928.00) (32,226.77) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (10,928.00) (32,226.77) ** (84,000.00) Budgeted (51,773.23) Remaining 38 % Used Account: 135-49900-000-000 Miscellaneous Income 710 01/01/2014 UB 1/1/14 Adjustment for valve UB20140101-20140101 User: (51.61) (51.67) (103.28) UB 706 01/14/2014 UB 1/14/14 Connect Fees/BF tes UB20140114-20140114 User: (50.00) (153.28) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (101.67) (153.28) ** (3,000.00) Budgeted (2,846.72) Remaining 5 % Used Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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-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: ------------------------------------------------------------------------------------------------ (1,627,444.87) ** (6,417,937.00) Budgeted (4,790,492.13) Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 520 01/03/2014 1/3/14 Payroll Salaries & Wages 52,797.71 10,858.14 63,655.85 PR 612 01/17/2014 1/17/13 Payroll Salaries & Wages 10,858.14 74,513.99 PR 670 01/31/2014 Payroll 1/31/14 Salaries & Wages 10,858.14 85,372.13 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 32,574.42 85,372.13 ** 287,709.00 Budgeted 202,336.87 Remaining 30 % Used Account: 135-50010-010-000 Overtime 520 01/03/2014 1/3/14 Payroll Overtime 3,038.16 1,052.03 4,090.19 PR 612 01/17/2014 1/17/13 Payroll Overtime 1,730.46 5,820.65 PR 670 01/31/2014 Payroll 1/31/14 Overtime 714.48 6,535.13 PR _______________ Account: 135-50010-010-000 Overtime Totals: 3,496.97 6,535.13 ** 13,391.00 Budgeted 6,855.87 Remaining 49 % 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 612 01/17/2014 1/17/13 Payroll Certification 975.00 325.00 1,300.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 1,300.00 ** 5,100.00 Budgeted 3,800.00 Remaining 25 % Used Account: 135-50020-010-000 Retirement 520 01/03/2014 1/3/14 Payroll Retirement 5,986.05 1,069.52 7,055.57 PR 612 01/17/2014 1/17/13 Payroll Retirement 1,159.66 8,215.23 PR 670 01/31/2014 Payroll 1/31/14 Retirement 1,039.22 9,254.45 PR _______________ Account: 135-50020-010-000 Retirement Totals: 3,268.40 9,254.45 ** 27,847.00 Budgeted 18,592.55 Remaining 33 % Used Account: 135-50026-010-000 Medical Insurance 520 01/03/2014 1/3/14 Payroll Medical Insurance 8,460.63 1,720.02 10,180.65 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 612 01/17/2014 1/17/13 Payroll Medical Insurance 8,460.63 1,719.96 11,900.61 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,439.98 11,900.61 ** 48,334.00 Budgeted 36,433.39 Remaining 25 % Used Account: 135-50027-010-000 Dental Insurance 520 01/03/2014 1/3/14 Payroll Dental Insurance 680.49 124.54 805.03 PR 612 01/17/2014 1/17/13 Payroll Dental Insurance 124.58 929.61 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 929.61 ** 3,932.00 Budgeted 3,002.39 Remaining 24 % Used Account: 135-50028-010-000 Vision Insurance 520 01/03/2014 1/3/14 Payroll Vision Insurance 154.87 31.49 186.36 PR 612 01/17/2014 1/17/13 Payroll Vision Insurance 31.54 217.90 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 217.90 ** 873.00 Budgeted 655.10 Remaining 25 % Used Account: 135-50029-010-000 Life Insurance & Other 605 01/10/2014 Discovery Benefits FSA 11/13 FSA Monthly 749.49 15.75 765.24 Discovery Benefits 33357 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 15.75 765.24 ** 3,306.00 Budgeted 2,540.76 Remaining 23 % Used Account: 135-50030-010-000 Social Security Taxes 520 01/03/2014 1/3/14 Payroll Social Security Taxes 4,191.44 737.04 4,928.48 PR 612 01/17/2014 1/17/13 Payroll Social Security Taxes 789.89 5,718.37 PR 670 01/31/2014 Payroll 1/31/14 Social Security Taxes 724.01 6,442.38 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 2,250.94 6,442.38 ** 19,289.00 Budgeted 12,846.62 Remaining 33 % Used Account: 135-50035-010-000 Medicare Taxes 520 01/03/2014 1/3/14 Payroll Medicare Taxes 980.26 172.38 1,152.64 PR 612 01/17/2014 1/17/13 Payroll Medicare Taxes 184.71 1,337.35 PR 670 01/31/2014 Payroll 1/31/14 Medicare Taxes 169.35 1,506.70 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-50035-010-000 Medicare Taxes Totals: 526.44 1,506.70 ** 4,511.00 Budgeted 3,004.30 Remaining 33 % Used Account: 135-50040-010-000 Unemployment Taxes 520 01/03/2014 1/3/14 Payroll Unemployment Taxes 2.44 11.91 14.35 PR 612 01/17/2014 1/17/13 Payroll Unemployment Taxes 12.92 27.27 PR 670 01/31/2014 Payroll 1/31/14 Unemployment Taxes 11.56 38.83 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 36.39 38.83 ** 54.00 Budgeted 15.17 Remaining 72 % Used Account: 135-50045-010-000 Workman's Compensation 50 01/01/2014 Jan Ins & W/C Expense 2,407.35 802.45 3,209.80 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 3,209.80 ** 9,829.00 Budgeted 6,619.20 Remaining 33 % 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 770 01/27/2014 12/27/13-1/27/14 PCards DONUT HAVEN 76.78 8.99 85.77 DONUT HAVEN PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 8.99 85.77 ** 300.00 Budgeted 214.23 Remaining 29 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 628 01/17/2014 Jan A/P Claval pilot assembly 9,749.11 730.00 10,479.11 ATLAS UTILITY SUPPLY CO. 33359 AP 644 01/21/2014 Jan A/P 16" Water Line Repair (Veranda 8,756.48 19,235.59 REY-MAR CONSTRUCTION 33386 AP 644 01/21/2014 Jan A/P 3 sample stations 2,172.82 21,408.41 KORALEEN ENTERPRISES 33384 AP 661 01/24/2014 Jan A/P Brass Fittings (Compression) A 286.64 21,695.05 ATLAS UTILITY SUPPLY CO. 33389 AP 661 01/24/2014 Jan A/P Water Plant Generator 795.00 22,490.05 ENTECH SALES AND SERVICE INC 33391 AP 770 01/27/2014 12/27/13-1/27/14 PCards FASTSIGNS 25.00 22,515.05 FASTSIGNS PC 770 01/27/2014 12/27/13-1/27/14 PCards RANDALLS STORE00017897 4.69 22,519.74 RANDALLS STORE00017897 PC 770 01/27/2014 12/27/13-1/27/14 PCards BURLESON POWER SPORTS 2,100.00 24,619.74 BURLESON POWER SPORTS PC 770 01/27/2014 12/27/13-1/27/14 PCards ENGINEERSUPPLY COM 478.99 25,098.73 ENGINEERSUPPLY COM PC 770 01/27/2014 12/27/13-1/27/14 PCards THE HOME DEPOT 6581 8.89 25,107.62 THE HOME DEPOT 6581 PC 770 01/27/2014 12/27/13-1/27/14 PCards WW GRAINGER 85.40 25,193.02 WW GRAINGER PC 770 01/27/2014 12/27/13-1/27/14 PCards RANDALLS STORE00017897 9.17 25,202.19 RANDALLS STORE00017897 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 15,453.08 25,202.19 ** 50,000.00 Budgeted 24,797.81 Remaining 50 % Used Account: 135-55090-010-000 Vehicle Maintenance 770 01/27/2014 12/27/13-1/27/14 PCards ROANOKE AUTO SUPPLY LT 1,055.33 21.48 1,076.81 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 21.48 1,076.81 ** 5,000.00 Budgeted 3,923.19 Remaining 22 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 628 01/17/2014 Jan A/P Tires for back hoe 198.33 50.00 248.33 BLAGG TIRE & SERVICE 33360 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 50.00 248.33 ** 3,500.00 Budgeted 3,251.67 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 628 01/17/2014 Jan A/P Bac T samples/MUD 445.00 235.00 680.00 TARRANT CTY PUBLIC HEALTH LAB 33374 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 235.00 680.00 ** 5,500.00 Budgeted 4,820.00 Remaining 12 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1,147.80 .00 1,147.80 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 1,147.80 ** 4,913.00 Budgeted 3,765.20 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 682 01/10/2014 Tri Cty/Patronage Retirement 27,153.90 (363.10) 26,790.80 GL 628 01/17/2014 Jan A/P Electricity 12/11/13-1/11/14 80.71 26,871.51 HUDSON ENERGY SERVICES, LLC 33366 AP 628 01/17/2014 Jan A/P Electricity 12/12/13-1/13/14 2,631.27 29,502.78 HUDSON ENERGY SERVICES, LLC 33366 AP 661 01/24/2014 Jan A/P Elec 12/12-1/13/14 4,923.25 34,426.03 HUDSON ENERGY SERVICES, LLC 33395 AP _______________ Account: 135-60020-010-000 Electricity Totals: 7,272.13 34,426.03 ** 162,160.00 Budgeted 127,733.97 Remaining 21 % 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 770 01/27/2014 12/27/13-1/27/14 PCards TCEQ EPAYMENT 589.00 111.00 700.00 TCEQ EPAYMENT PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 700.00 ** 4,184.00 Budgeted 3,484.00 Remaining 17 % 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 670 01/31/2014 Payroll 1/31/14 Travel & per diem 100.57 70.56 171.13 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 70.56 171.13 ** 1,450.00 Budgeted 1,278.87 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 628 01/17/2014 Jan A/P Nitrogen bottle lease 12.00 6.00 18.00 ALLIED WELDING SUPPLY, INC 33358 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 18.00 ** 500.00 Budgeted 482.00 Remaining 4 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 628 01/17/2014 Jan A/P Revenue & Regulatory Assessmen 6,480.10 22,875.49 29,355.59 TX COMMISSION ENVIRONMENTAL QU 33380 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 22,875.49 29,355.59 ** 47,400.00 Budgeted 18,044.41 Remaining 62 % Used Account: 135-60150-010-000 Wholesale Water 688 01/30/2014 Jan A/P Dec Wholesale Water 283,923.18 105,632.30 389,555.48 CITY OF FORT WORTH 33408 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 105,632.30 389,555.48 ** 2,338,473.00 Budgeted 1,948,917.52 Remaining 17 % 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 770 01/27/2014 12/27/13-1/27/14 PCards DENTON SAND & GRAVEL, 360.70 30.00 390.70 DENTON SAND & GRAVEL, PC 770 01/27/2014 12/27/13-1/27/14 PCards DENTON SAND & GRAVEL, 30.00 420.70 DENTON SAND & GRAVEL, PC 770 01/27/2014 12/27/13-1/27/14 PCards DENTON SAND & GRAVEL, 108.00 528.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 168.00 528.70 ** 3,500.00 Budgeted 2,971.30 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 776 01/31/2014 Jan Gas Log 2,739.27 1,110.18 3,849.45 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,110.18 3,849.45 ** 23,181.00 Budgeted 19,331.55 Remaining 17 % Used Account: 135-65010-010-000 Uniforms 1,831.63 .00 1,831.63 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,831.63 ** 3,270.00 Budgeted 1,438.37 Remaining 56 % Used Account: 135-65030-010-000 Chemicals 2,045.09 .00 2,045.09 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 2,045.09 ** 5,000.00 Budgeted 2,954.91 Remaining 41 % 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 770 01/27/2014 12/27/13-1/27/14 PCards TX AMERICA SAFETY 16.92 167.81 184.73 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 167.81 184.73 ** 1,000.00 Budgeted 815.27 Remaining 18 % Used Account: 135-65050-010-000 Meter Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 628 01/17/2014 Jan A/P Fire line meters 55,697.12 1,480.00 57,177.12 ATLAS UTILITY SUPPLY CO. 33359 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 1,480.00 57,177.12 ** 143,550.00 Budgeted 86,372.88 Remaining 40 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 37,000.00 Budgeted 37,000.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 489,980.00 Budgeted 489,980.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 19,268.00 Budgeted 19,268.00 Remaining 0 % 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 Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ 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 Capital Repair-Ground Storage 628 01/17/2014 Jan A/P Water Plant #1 East-annual ins 69,788.02 31,028.52 100,816.54 UTILITY SERVICE CO, INC. 33382 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-69281-010-000 Capital Repair-Ground Storage Totals: 31,028.52 100,816.54 ** 106,847.00 Budgeted 6,030.46 Remaining 94 % Used Account: 135-55135-010-001 Lab Analysis 628 01/17/2014 Jan A/P Bac T samples/PID 120.00 60.00 180.00 TARRANT CTY PUBLIC HEALTH LAB 33374 AP 628 01/17/2014 Jan A/P PID testing Nitrite 8.49 188.49 LOWER COLORADO RIVER AUTHORITY 33369 AP 628 01/17/2014 Jan A/P Bac T sample-main break (PID) 330.00 518.49 OXIDOR LABORATORIES LLC 33372 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 398.49 518.49 ** 1,000.00 Budgeted 481.51 Remaining 52 % Used Account: 135-60135-010-001 TCEQ Fees & Permits 2,253.85 .00 2,253.85 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits Totals: .00 2,253.85 ** .00 Budgeted (2,253.85) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 785,238.35 ** 3,932,956.00 Budgeted 3,147,717.65 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 520 01/03/2014 1/3/14 Payroll Salaries & Wages 40,796.88 7,587.46 48,384.34 PR 612 01/17/2014 1/17/13 Payroll Salaries & Wages 7,587.46 55,971.80 PR 670 01/31/2014 Payroll 1/31/14 Salaries & Wages 7,587.46 63,559.26 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 22,762.38 63,559.26 ** 202,894.00 Budgeted 139,334.74 Remaining 31 % Used Account: 135-50010-020-000 Overtime 520 01/03/2014 1/3/14 Payroll Overtime 3,742.03 705.25 4,447.28 PR 612 01/17/2014 1/17/13 Payroll Overtime 570.23 5,017.51 PR 670 01/31/2014 Payroll 1/31/14 Overtime 146.68 5,164.19 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,422.16 5,164.19 ** 11,965.00 Budgeted 6,800.81 Remaining 43 % 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 612 01/17/2014 1/17/13 Payroll Certification 1,200.00 400.00 1,600.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 1,600.00 ** 4,800.00 Budgeted 3,200.00 Remaining 33 % Used Account: 135-50020-020-000 Retirement 520 01/03/2014 1/3/14 Payroll Retirement 4,844.88 744.68 5,589.56 PR 612 01/17/2014 1/17/13 Payroll Retirement 768.48 6,358.04 PR 670 01/31/2014 Payroll 1/31/14 Retirement 694.53 7,052.57 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,207.69 7,052.57 ** 19,905.00 Budgeted 12,852.43 Remaining 35 % Used Account: 135-50026-020-000 Medical Insurance 520 01/03/2014 1/3/14 Payroll Medical Insurance 9,827.55 1,620.56 11,448.11 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 612 01/17/2014 1/17/13 Payroll Medical Insurance 9,827.55 1,620.53 13,068.64 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,241.09 13,068.64 ** 43,471.00 Budgeted 30,402.36 Remaining 30 % Used Account: 135-50027-020-000 Dental Insurance 520 01/03/2014 1/3/14 Payroll Dental Insurance 679.38 105.68 785.06 PR 612 01/17/2014 1/17/13 Payroll Dental Insurance 105.70 890.76 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 890.76 ** 2,989.00 Budgeted 2,098.24 Remaining 30 % Used Account: 135-50028-020-000 Vision Insurance 520 01/03/2014 1/3/14 Payroll Vision Insurance 149.79 25.61 175.40 PR 612 01/17/2014 1/17/13 Payroll Vision Insurance 25.65 201.05 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 201.05 ** 658.00 Budgeted 456.95 Remaining 31 % Used Account: 135-50029-020-000 Life Insurance & Other 605 01/10/2014 Discovery Benefits FSA 11/13 FSA Monthly 648.90 15.75 664.65 Discovery Benefits 33357 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 15.75 664.65 ** 2,303.00 Budgeted 1,638.35 Remaining 29 % Used Account: 135-50030-020-000 Social Security Taxes 520 01/03/2014 1/3/14 Payroll Social Security Taxes 3,050.89 439.26 3,490.15 PR 612 01/17/2014 1/17/13 Payroll Social Security Taxes 444.51 3,934.66 PR 670 01/31/2014 Payroll 1/31/14 Social Security Taxes 482.11 4,416.77 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,365.88 4,416.77 ** 13,805.00 Budgeted 9,388.23 Remaining 32 % Used Account: 135-50035-020-000 Medicare Taxes 520 01/03/2014 1/3/14 Payroll Medicare Taxes 713.51 102.73 816.24 PR 612 01/17/2014 1/17/13 Payroll Medicare Taxes 103.95 920.19 PR 670 01/31/2014 Payroll 1/31/14 Medicare Taxes 112.76 1,032.95 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-50035-020-000 Medicare Taxes Totals: 319.44 1,032.95 ** 3,229.00 Budgeted 2,196.05 Remaining 32 % Used Account: 135-50040-020-000 Unemployment Taxes 520 01/03/2014 1/3/14 Payroll Unemployment Taxes 8.29 8.29 PR 612 01/17/2014 1/17/13 Payroll Unemployment Taxes 8.56 16.85 PR 670 01/31/2014 Payroll 1/31/14 Unemployment Taxes 7.73 24.58 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 24.58 24.58 ** 36.00 Budgeted 11.42 Remaining 68 % Used Account: 135-50045-020-000 Workman's Compensation 50 01/01/2014 Jan Ins & W/C Expense 1,605.24 535.08 2,140.32 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 2,140.32 ** 6,552.00 Budgeted 4,411.68 Remaining 33 % 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 770 01/27/2014 12/27/13-1/27/14 PCards DONUT HAVEN 28.99 8.99 37.98 DONUT HAVEN PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 8.99 37.98 ** 350.00 Budgeted 312.02 Remaining 11 % Used Account: 135-55070-020-000 Independent Labor 628 01/17/2014 Jan A/P WWTP Improvements 245,806.25 35,605.00 281,411.25 THE WALLACE GROUP, INC. 33377 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 35,605.00 281,411.25 ** .00 Budgeted (281,411.25) Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 661 01/24/2014 Jan A/P Honda Trash pump 4,010.64 1,729.95 5,740.59 HD SUPPLY FACILITIES MAINT LTD 33394 AP 661 01/24/2014 Jan A/P adapters 119.90 5,860.49 HD SUPPLY FACILITIES MAINT LTD 33394 AP 661 01/24/2014 Jan A/P Lead Free Brass Coupling 79.80 5,940.29 HD SUPPLY FACILITIES MAINT LTD 33394 AP 661 01/24/2014 Jan A/P Plant Lift Station Transducer 1,983.00 7,923.29 XYLEM WATER SOLUTIONS USA INC 33404 AP 661 01/24/2014 Jan A/P 10 hp WWTP Lift Station pump 7,907.58 15,830.87 XYLEM WATER SOLUTIONS USA INC 33404 AP 661 01/24/2014 Jan A/P Check batteries on generator 795.00 16,625.87 ENTECH SALES AND SERVICE INC 33391 AP 770 01/27/2014 12/27/13-1/27/14 PCards ENGINEERSUPPLY COM 478.99 17,104.86 ENGINEERSUPPLY COM PC 770 01/27/2014 12/27/13-1/27/14 PCards ANDRITZ SEPERATION INC 525.00 17,629.86 ANDRITZ SEPERATION INC PC 770 01/27/2014 12/27/13-1/27/14 PCards THE HOME DEPOT 6581 73.66 17,703.52 THE HOME DEPOT 6581 PC 770 01/27/2014 12/27/13-1/27/14 PCards THREE L WELDING SUPPLY 102.45 17,805.97 THREE L WELDING SUPPLY PC 770 01/27/2014 12/27/13-1/27/14 PCards ALLIED ELECTRONICS INC 282.12 18,088.09 ALLIED ELECTRONICS INC PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 14,077.45 18,088.09 ** 35,000.00 Budgeted 16,911.91 Remaining 52 % Used Account: 135-55090-020-000 Vehicle Maintenance 770 01/27/2014 12/27/13-1/27/14 PCards AUTOZONE #4206 681.51 257.98 939.49 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 257.98 939.49 ** 2,000.00 Budgeted 1,060.51 Remaining 47 % 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 661 01/24/2014 Jan A/P Sludge Haul off 7,354.32 909.05 8,263.37 L.H. CHANEY MATERIALS, INC. 33396 AP 661 01/24/2014 Jan A/P Sludge Haul off 1,706.40 9,969.77 L.H. CHANEY MATERIALS, INC. 33396 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,615.45 9,969.77 ** 52,000.00 Budgeted 42,030.23 Remaining 19 % Used Account: 135-55135-020-000 Lab Analysis 661 01/24/2014 Jan A/P Lab water 5,600.00 6.13 5,606.13 OZARKA DIRECT 33400 AP 661 01/24/2014 Jan A/P Lab testing 246.00 5,852.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 176.00 6,028.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 246.00 6,274.13 OXIDOR LABORATORIES LLC 33399 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 661 01/24/2014 Jan A/P Lab Testing 5,600.00 176.00 6,450.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 176.00 6,626.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 246.00 6,872.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 246.00 7,118.13 OXIDOR LABORATORIES LLC 33399 AP 661 01/24/2014 Jan A/P Lab Testing 176.00 7,294.13 OXIDOR LABORATORIES LLC 33399 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,694.13 7,294.13 ** 30,000.00 Budgeted 22,705.87 Remaining 24 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 716.08 .00 716.08 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 716.08 ** 3,329.00 Budgeted 2,612.92 Remaining 22 % Used Account: 135-60020-020-000 Electricity 682 01/10/2014 Tri Cty/Patronage Retirement 22,615.71 (363.10) 22,252.61 GL 661 01/24/2014 Jan A/P Elec 12/12-1/13 9,132.67 31,385.28 HUDSON ENERGY SERVICES, LLC 33395 AP _______________ Account: 135-60020-020-000 Electricity Totals: 8,769.57 31,385.28 ** 148,227.00 Budgeted 116,841.72 Remaining 21 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 160.00 .00 160.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 160.00 ** 400.00 Budgeted 240.00 Remaining 40 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 2,636.00 Budgeted 2,636.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 371.38 .00 371.38 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 371.38 ** 250.00 Budgeted (121.38) Remaining 149 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-60100-020-000 Travel & per diem 670 01/31/2014 Payroll 1/31/14 Travel & per diem 219.05 47.04 266.09 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 47.04 266.09 ** 1,050.00 Budgeted 783.91 Remaining 25 % 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-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-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 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 776 01/31/2014 Jan Gas Log 2,483.69 877.14 3,360.83 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 877.14 3,360.83 ** 14,720.00 Budgeted 11,359.17 Remaining 23 % Used Account: 135-65010-020-000 Uniforms 770 01/27/2014 12/27/13-1/27/14 PCards RED WING SHOES #652 1,284.28 152.99 1,437.27 RED WING SHOES #652 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 152.99 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals 661 01/24/2014 Jan A/P 2 55 gal drums of polymer 4,629.64 1,080.00 5,709.64 POLYDYNE, INC 33401 AP 661 01/24/2014 Jan A/P Chemicals 1,680.00 7,389.64 HARCROS CHEMICALS INC 33393 AP 770 01/27/2014 12/27/13-1/27/14 PCards AQUAFIX INC 688.48 8,078.12 AQUAFIX INC PC _______________ Account: 135-65030-020-000 Chemicals Totals: 3,448.48 8,078.12 ** 39,000.00 Budgeted 30,921.88 Remaining 21 % 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 661 01/24/2014 Jan A/P Supplies for safety cabinet 56.43 57.65 114.08 CINTAS CORPORATION NO. 2 33390 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 57.65 114.08 ** 250.00 Budgeted 135.92 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 661 01/24/2014 Jan A/P Capes and latex gloves 4,763.73 162.00 4,925.73 LOU'S GLOVES INCORPORATED 33397 AP 770 01/27/2014 12/27/13-1/27/14 PCards IDEXX DISTRIBUTION INC 262.60 5,188.33 IDEXX DISTRIBUTION INC PC 770 01/27/2014 12/27/13-1/27/14 PCards IDEXX DISTRIBUTION INC 155.29 5,343.62 IDEXX DISTRIBUTION INC PC 770 01/27/2014 12/27/13-1/27/14 PCards THE HOME DEPOT 6581 39.96 5,383.58 THE HOME DEPOT 6581 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 619.85 5,383.58 ** 15,000.00 Budgeted 9,616.42 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 31,000.00 Budgeted 31,000.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 20,020.00 Budgeted 20,020.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 1,422.00 Budgeted 1,422.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ 481,199.19 ** 768,011.00 Budgeted 286,811.81 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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 520 01/03/2014 1/3/14 Payroll Salaries & Wages 15,664.64 2,185.07 17,849.71 PR 612 01/17/2014 1/17/13 Payroll Salaries & Wages 2,134.58 19,984.29 PR 670 01/31/2014 Payroll 1/31/14 Salaries & Wages 2,165.54 22,149.83 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,485.19 22,149.83 ** 90,299.00 Budgeted 68,149.17 Remaining 25 % Used Account: 135-50010-021-000 Overtime 520 01/03/2014 1/3/14 Payroll Overtime 1,395.32 174.97 1,570.29 PR 670 01/31/2014 Payroll 1/31/14 Overtime 264.75 1,835.04 PR _______________ Account: 135-50010-021-000 Overtime Totals: 439.72 1,835.04 ** 10,028.00 Budgeted 8,192.96 Remaining 18 % 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 612 01/17/2014 1/17/13 Payroll Certification 450.00 150.00 600.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 600.00 ** 1,800.00 Budgeted 1,200.00 Remaining 33 % Used Account: 135-50020-021-000 Retirement 520 01/03/2014 1/3/14 Payroll Retirement 2,116.65 211.93 2,328.58 PR 612 01/17/2014 1/17/13 Payroll Retirement 205.16 2,533.74 PR 670 01/31/2014 Payroll 1/31/14 Retirement 218.24 2,751.98 PR _______________ Account: 135-50020-021-000 Retirement Totals: 635.33 2,751.98 ** 9,025.00 Budgeted 6,273.02 Remaining 30 % Used Account: 135-50026-021-000 Medical Insurance 520 01/03/2014 1/3/14 Payroll Medical Insurance 5,252.76 701.20 5,953.96 PR 612 01/17/2014 1/17/13 Payroll Medical Insurance 701.19 6,655.15 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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-021-000 Medical Insurance Totals: 1,402.39 6,655.15 ** 23,668.00 Budgeted 17,012.85 Remaining 28 % Used Account: 135-50027-021-000 Dental Insurance 520 01/03/2014 1/3/14 Payroll Dental Insurance 402.39 51.30 453.69 PR 612 01/17/2014 1/17/13 Payroll Dental Insurance 51.30 504.99 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 504.99 ** 1,703.00 Budgeted 1,198.01 Remaining 30 % Used Account: 135-50028-021-000 Vision Insurance 520 01/03/2014 1/3/14 Payroll Vision Insurance 75.85 11.84 87.69 PR 612 01/17/2014 1/17/13 Payroll Vision Insurance 11.84 99.53 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 99.53 ** 314.00 Budgeted 214.47 Remaining 32 % Used Account: 135-50029-021-000 Life Insurance & Other 605 01/10/2014 Discovery Benefits FSA 11/13 FSA Monthly 391.16 5.25 396.41 Discovery Benefits 33357 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 5.25 396.41 ** 1,066.00 Budgeted 669.59 Remaining 37 % Used Account: 135-50030-021-000 Social Security Taxes 520 01/03/2014 1/3/14 Payroll Social Security Taxes 1,326.92 128.23 1,455.15 PR 612 01/17/2014 1/17/13 Payroll Social Security Taxes 119.28 1,574.43 PR 670 01/31/2014 Payroll 1/31/14 Social Security Taxes 151.97 1,726.40 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 399.48 1,726.40 ** 7,442.00 Budgeted 5,715.60 Remaining 23 % Used Account: 135-50035-021-000 Medicare Taxes 520 01/03/2014 1/3/14 Payroll Medicare Taxes 310.33 29.99 340.32 PR 612 01/17/2014 1/17/13 Payroll Medicare Taxes 27.89 368.21 PR 670 01/31/2014 Payroll 1/31/14 Medicare Taxes 35.55 403.76 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 93.43 403.76 ** 1,741.00 Budgeted 1,337.24 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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 520 01/03/2014 1/3/14 Payroll Unemployment Taxes 2.36 2.36 PR 612 01/17/2014 1/17/13 Payroll Unemployment Taxes 2.28 4.64 PR 670 01/31/2014 Payroll 1/31/14 Unemployment Taxes 2.43 7.07 PR _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 7.07 7.07 ** 198.00 Budgeted 190.93 Remaining 4 % Used Account: 135-50045-021-000 Workman's Compensation 50 01/01/2014 Jan Ins & W/C Expense 802.62 267.54 1,070.16 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 1,070.16 ** 3,276.00 Budgeted 2,205.84 Remaining 33 % Used Account: 135-50070-021-000 Employee Relations 770 01/27/2014 12/27/13-1/27/14 PCards 1-800-FLOWERS.COM,INC. 30.68 70.34 101.02 1-800-FLOWERS.COM,INC. PC 770 01/27/2014 12/27/13-1/27/14 PCards DONUT HAVEN 8.99 110.01 DONUT HAVEN PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 79.33 110.01 ** 200.00 Budgeted 89.99 Remaining 55 % 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 93.28 .00 93.28 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 93.28 ** 23,801.00 Budgeted 23,707.72 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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-60010-021-000 Communications/Pagers/Mobiles 550 01/07/2014 Jan A/P Pump station monitoring 205.04 276.00 481.04 OMNISITE 33337 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 276.00 481.04 ** 1,333.00 Budgeted 851.96 Remaining 36 % Used Account: 135-60020-021-000 Electricity 682 01/10/2014 Tri Cty/Patronage Retirement 4,001.65 (363.09) 3,638.56 GL 628 01/17/2014 Jan A/P Elec 12/3/13-1/3/14 280.81 3,919.37 TRI COUNTY ELECTRIC 33379 AP 628 01/17/2014 Jan A/P Electricity 12/3/13-1/3/14 134.85 4,054.22 TRI COUNTY ELECTRIC 33379 AP 628 01/17/2014 Jan A/P Electricity 12/3/13-1/3/14 27.80 4,082.02 TRI COUNTY ELECTRIC 33379 AP 628 01/17/2014 Jan A/P Electricity 12/12/13-1/13/14 681.20 4,763.22 HUDSON ENERGY SERVICES, LLC 33366 AP 628 01/17/2014 Jan A/P Electricity 12/11/13-1/11/14 82.66 4,845.88 HUDSON ENERGY SERVICES, LLC 33366 AP 628 01/17/2014 Jan A/P Electricity 12/11/13-1/11/14 30.39 4,876.27 HUDSON ENERGY SERVICES, LLC 33366 AP 628 01/17/2014 Jan A/P Electricity 12/12/13-1/13/14 105.25 4,981.52 HUDSON ENERGY SERVICES, LLC 33366 AP 661 01/24/2014 Jan A/P Elec 12/12-1/13 1,329.49 6,311.01 HUDSON ENERGY SERVICES, LLC 33395 AP 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (331.02) 5,979.99 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,978.34 5,979.99 ** 21,178.00 Budgeted 15,198.01 Remaining 28 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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-60100-021-000 Travel & per diem .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 776 01/31/2014 Jan Gas Log 2,872.40 1,299.83 4,172.23 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,299.83 4,172.23 ** 22,397.00 Budgeted 18,224.77 Remaining 19 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 43.99 .00 43.99 _______________ 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 540.75 .00 540.75 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 540.75 ** 500.00 Budgeted (40.75) Remaining 108 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 100,000.00 Budgeted 100,000.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ 52,543.34 ** 472,170.00 Budgeted 419,626.66 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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 612 01/17/2014 1/17/13 Payroll Salaries & Wages 2,500.00 200.00 2,700.00 PR 670 01/31/2014 Payroll 1/31/14 Salaries & Wages 500.00 3,200.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 700.00 3,200.00 ** 10,000.00 Budgeted 6,800.00 Remaining 32 % Used Account: 135-50030-026-000 Social Security Taxes 612 01/17/2014 1/17/13 Payroll Social Security Taxes 155.00 12.40 167.40 PR 670 01/31/2014 Payroll 1/31/14 Social Security Taxes 31.00 198.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 43.40 198.40 ** 620.00 Budgeted 421.60 Remaining 32 % Used Account: 135-50035-026-000 Medicare Taxes 612 01/17/2014 1/17/13 Payroll Medicare Taxes 36.25 2.90 39.15 PR 670 01/31/2014 Payroll 1/31/14 Medicare Taxes 7.25 46.40 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 10.15 46.40 ** 145.00 Budgeted 98.60 Remaining 32 % Used Account: 135-50040-026-000 Unemployment Taxes 612 01/17/2014 1/17/13 Payroll Unemployment Taxes 2.50 .20 2.70 PR 670 01/31/2014 Payroll 1/31/14 Unemployment Taxes .50 3.20 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .70 3.20 ** 10.00 Budgeted 6.80 Remaining 32 % Used Account: 135-50045-026-000 Workman's Compensation 50 01/01/2014 Jan Ins & W/C Expense 8.85 2.95 11.80 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 11.80 ** 36.00 Budgeted 24.20 Remaining 33 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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-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: ------------------------------------------------------------------------------------------------ 3,795.75 ** 22,661.00 Budgeted 18,865.25 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 520 01/03/2014 1/3/14 Payroll Salaries & Wages 92,450.91 17,300.01 109,750.92 PR 612 01/17/2014 1/17/13 Payroll Salaries & Wages 17,295.67 127,046.59 PR 670 01/31/2014 Payroll 1/31/14 Salaries & Wages 17,294.11 144,340.70 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 51,889.79 144,340.70 ** 458,721.00 Budgeted 314,380.30 Remaining 31 % Used Account: 135-50010-030-000 Overtime 520 01/03/2014 1/3/14 Payroll Overtime 259.87 12.90 272.77 PR 612 01/17/2014 1/17/13 Payroll Overtime 28.37 301.14 PR 670 01/31/2014 Payroll 1/31/14 Overtime 18.57 319.71 PR _______________ Account: 135-50010-030-000 Overtime Totals: 59.84 319.71 ** 500.00 Budgeted 180.29 Remaining 64 % 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 520 01/03/2014 1/3/14 Payroll Retirement 9,574.52 1,554.69 11,129.21 PR 612 01/17/2014 1/17/13 Payroll Retirement 1,555.71 12,684.92 PR 670 01/31/2014 Payroll 1/31/14 Retirement 1,554.68 14,239.60 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,665.08 14,239.60 ** 41,419.00 Budgeted 27,179.40 Remaining 34 % Used Account: 135-50026-030-000 Medical Insurance 520 01/03/2014 1/3/14 Payroll Medical Insurance 13,331.23 2,301.30 15,632.53 PR 612 01/17/2014 1/17/13 Payroll Medical Insurance 2,301.23 17,933.76 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,602.53 17,933.76 ** 57,923.00 Budgeted 39,989.24 Remaining 31 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 520 01/03/2014 1/3/14 Payroll Dental Insurance 1,159.02 170.19 1,329.21 PR 612 01/17/2014 1/17/13 Payroll Dental Insurance 170.23 1,499.44 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.42 1,499.44 ** 5,100.00 Budgeted 3,600.56 Remaining 29 % Used Account: 135-50028-030-000 Vision Insurance 520 01/03/2014 1/3/14 Payroll Vision Insurance 247.59 40.78 288.37 PR 612 01/17/2014 1/17/13 Payroll Vision Insurance 40.84 329.21 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 329.21 ** 1,087.00 Budgeted 757.79 Remaining 30 % Used Account: 135-50029-030-000 Life Insurance & Other 605 01/10/2014 Discovery Benefits FSA 11/13 FSA Monthly 1,800.88 36.75 1,837.63 Discovery Benefits 33357 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 36.75 1,837.63 ** 4,483.00 Budgeted 2,645.37 Remaining 41 % Used Account: 135-50030-030-000 Social Security Taxes 520 01/03/2014 1/3/14 Payroll Social Security Taxes 6,269.15 1,013.53 7,282.68 PR 612 01/17/2014 1/17/13 Payroll Social Security Taxes 1,001.19 8,283.87 PR 670 01/31/2014 Payroll 1/31/14 Social Security Taxes 1,073.39 9,357.26 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,088.11 9,357.26 ** 28,659.00 Budgeted 19,301.74 Remaining 33 % Used Account: 135-50035-030-000 Medicare Taxes 520 01/03/2014 1/3/14 Payroll Medicare Taxes 1,466.18 237.03 1,703.21 PR 612 01/17/2014 1/17/13 Payroll Medicare Taxes 234.16 1,937.37 PR 670 01/31/2014 Payroll 1/31/14 Medicare Taxes 251.03 2,188.40 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 722.22 2,188.40 ** 6,702.00 Budgeted 4,513.60 Remaining 33 % Used Account: 135-50040-030-000 Unemployment Taxes 520 01/03/2014 1/3/14 Payroll Unemployment Taxes 17.31 17.31 PR 612 01/17/2014 1/17/13 Payroll Unemployment Taxes 17.32 34.63 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 670 01/31/2014 Payroll 1/31/14 Unemployment Taxes 13.57 48.20 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 48.20 48.20 ** 63.00 Budgeted 14.80 Remaining 77 % Used Account: 135-50045-030-000 Workman's Compensation 50 01/01/2014 Jan Ins & W/C Expense 385.89 128.63 514.52 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 514.52 ** 1,575.00 Budgeted 1,060.48 Remaining 33 % 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 680 01/08/2014 Flu Shots 2,810.96 (120.00) 2,690.96 GL 681 01/10/2014 Flu Shots (305.00) 2,385.96 GL 770 01/27/2014 12/27/13-1/27/14 PCards FTD*ROTHERMEL FLOWERS 74.95 2,460.91 FTD*ROTHERMEL FLOWERS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: (350.05) 2,460.91 ** 5,000.00 Budgeted 2,539.09 Remaining 49 % Used Account: 135-55030-030-000 Software & Support 661 01/24/2014 Jan A/P Software Support 15,446.13 426.88 15,873.01 STW INC 33402 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 645.50 16,518.51 TOWN OF TROPHY CLUB 33419 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 100.00 16,618.51 TOWN OF TROPHY CLUB 33419 AP 688 01/30/2014 Jan A/P STW Support 2,037.73 18,656.24 STW INC 33417 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,210.11 18,656.24 ** 59,698.00 Budgeted 41,041.76 Remaining 31 % Used Account: 135-55070-030-000 Independent Labor 661 01/24/2014 Jan A/P Record MUD Meeting 2,115.45 56.25 2,171.70 MIGUEL CRUZ 33398 AP 661 01/24/2014 Jan A/P Record CAC meeting 33.75 2,205.45 MIGUEL CRUZ 33398 AP 688 01/30/2014 Jan A/P Record CAC meeting 30.00 2,235.45 MIGUEL CRUZ 33415 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-55070-030-000 Independent Labor Totals: 120.00 2,235.45 ** 7,700.00 Budgeted 5,464.55 Remaining 29 % Used Account: 135-55080-030-000 Maintenance & Repairs 770 01/27/2014 12/27/13-1/27/14 PCards MICHAELS KEYS (1,577.26) 5.97 (1,571.29) MICHAELS KEYS PC 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: (188.84) (1,760.13) AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: (182.87) (1,760.13) ** 4,500.00 Budgeted 6,260.13 Remaining -39 % Used Account: 135-55100-030-000 Building Maint & Supplies 1,516.18 .00 1,516.18 _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: .00 1,516.18 ** 6,500.00 Budgeted 4,983.82 Remaining 23 % Used Account: 135-55120-030-000 Cleaning Services 628 01/17/2014 Jan A/P Janitorial Service/December 3,189.94 1,594.97 4,784.91 MEMBER'S BUILDING MAINTENANCE 33370 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 4,784.91 ** 19,140.00 Budgeted 14,355.09 Remaining 25 % 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 Outside Services-Town Semo 38,524.00 .00 38,524.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 38,524.00 ** 77,048.00 Budgeted 38,524.00 Remaining 50 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 628 01/17/2014 Jan A/P Dec Utility billing 1,152.20 612.15 1,764.35 DATAPROSE LLC 33363 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 612.15 1,764.35 ** 6,808.00 Budgeted 5,043.65 Remaining 26 % Used Account: 135-60005-030-000 Telephone 550 01/07/2014 Jan A/P Answering service January 2,496.39 239.72 2,736.11 KEYSTONE PARK SECRETARIAL 33322 AP 688 01/30/2014 Jan A/P Answering service/Feb 180.00 2,916.11 KEYSTONE PARK SECRETARIAL 33411 AP _______________ Account: 135-60005-030-000 Telephone Totals: 419.72 2,916.11 ** 11,250.00 Budgeted 8,333.89 Remaining 26 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 612 01/17/2014 1/17/13 Payroll Communications/Pagers/Mobiles 729.79 150.00 879.79 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 150.00 879.79 ** 3,589.00 Budgeted 2,709.21 Remaining 25 % Used Account: 135-60020-030-000 Electricity/Gas 661 01/24/2014 Jan A/P Fire XMAS party, SHI, Kyocera 887.96 2,733.83 3,621.79 TOWN OF TROPHY CLUB 33403 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 887.96 4,509.75 TOWN OF TROPHY CLUB 33419 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 2,733.83 7,243.58 TOWN OF TROPHY CLUB 33419 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 6,355.62 7,243.58 ** 15,171.00 Budgeted 7,927.42 Remaining 48 % Used Account: 135-60025-030-000 Water 778 01/31/2014 Bill Town Inv # 1126-1136 AR 20140131-20140131 User: 202.43 (77.76) 124.67 AR _______________ Account: 135-60025-030-000 Water Totals: (77.76) 124.67 ** 1,500.00 Budgeted 1,375.33 Remaining 8 % Used Account: 135-60035-030-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 628 01/17/2014 Jan A/P Dec Utility billing 5,230.78 1,596.32 6,827.10 DATAPROSE LLC 33363 AP 644 01/21/2014 Jan A/P Overnight letters 10.44 6,837.54 FEDERAL EXPRESS CORP 33383 AP 644 01/21/2014 Jan A/P Overnight letters 11.16 6,848.70 FEDERAL EXPRESS CORP 33383 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 145.50 6,994.20 TOWN OF TROPHY CLUB 33419 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,763.42 6,994.20 ** 28,500.00 Budgeted 21,505.80 Remaining 25 % Used Account: 135-60040-030-000 Service Charges & Fees 687 01/03/2014 Credit card fees 6,795.64 2,301.21 9,096.85 GL 687 01/03/2014 Credit card fees 90.60 9,187.45 GL 687 01/03/2014 Credit card fees 43.34 9,230.79 GL 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 50.00 9,280.79 TOWN OF TROPHY CLUB 33419 AP 755 01/30/2014 Jan FF Account Analysis 250.00 9,530.79 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,735.15 9,530.79 ** 28,330.00 Budgeted 18,799.21 Remaining 34 % Used Account: 135-60050-030-000 Bad Debt Expense 3,712.56 .00 3,712.56 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 3,712.56 ** 1,500.00 Budgeted (2,212.56) Remaining 248 % Used Account: 135-60055-030-000 Insurance 50 01/01/2014 Jan Ins & W/C Expense 12,842.44 4,269.73 17,112.17 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 17,112.17 ** 53,561.00 Budgeted 36,448.83 Remaining 32 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 126.00 .00 126.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 126.00 ** 1,000.00 Budgeted 874.00 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 770 01/27/2014 12/27/13-1/27/14 PCards PAYPAL *TXMUNLEAGUE 3,931.95 80.00 4,011.95 PAYPAL *TXMUNLEAGUE PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-60070-030-000 Dues & Memberships Totals: 80.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-60080-030-000 Schools & Training 770 01/27/2014 12/27/13-1/27/14 PCards THE CPE STORE, INC. 190.00 312.30 502.30 THE CPE STORE, INC. PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 312.30 502.30 ** 7,500.00 Budgeted 6,997.70 Remaining 7 % Used Account: 135-60100-030-000 Travel & per diem 520 01/03/2014 1/3/14 Payroll Travel & per diem 601.36 23.56 624.92 PR 612 01/17/2014 1/17/13 Payroll Travel & per diem 17.65 642.57 PR 670 01/31/2014 Payroll 1/31/14 Travel & per diem 60.59 703.16 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 101.80 703.16 ** 5,000.00 Budgeted 4,296.84 Remaining 14 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % 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 Account: 135-60245-030-000 Miscellaneous Expenses 770 01/27/2014 12/27/13-1/27/14 PCards AMAZON MKTPLACE PMTS 61.38 221.70 283.08 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 221.70 283.08 ** 22,870.00 Budgeted 22,586.92 Remaining 1 % 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 688 01/30/2014 Jan A/P SHI Invoices GB99737,99670, 99 1,672.45 5.50 1,677.95 TOWN OF TROPHY CLUB 33419 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-65055-030-000 Hardware Totals: 5.50 1,677.95 ** 13,562.00 Budgeted 11,884.05 Remaining 12 % Used Account: 135-65085-030-000 Office Supplies 644 01/21/2014 Jan A/P Removable tape 1,200.49 10.18 1,210.67 OFFICE DEPOT, INC 33385 AP 661 01/24/2014 Jan A/P Fire XMAS party, SHI, Kyocera 15.00 1,225.67 TOWN OF TROPHY CLUB 33403 AP 770 01/27/2014 12/27/13-1/27/14 PCards AMAZON.COM 29.97 1,255.64 AMAZON.COM PC 770 01/27/2014 12/27/13-1/27/14 PCards AMAZON.COM 43.92 1,299.56 AMAZON.COM PC 770 01/27/2014 12/27/13-1/27/14 PCards OFFICE DEPOT #406 53.98 1,353.54 OFFICE DEPOT #406 PC 770 01/27/2014 12/27/13-1/27/14 PCards OFFICE DEPOT #406 123.95 1,477.49 OFFICE DEPOT #406 PC 688 01/30/2014 Jan A/P SHI Invoices GB99737,99670, 99 15.00 1,492.49 TOWN OF TROPHY CLUB 33419 AP 688 01/30/2014 Jan A/P Office Supplies 84.45 1,576.94 OFFICE DEPOT, INC 33416 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 376.45 1,576.94 ** 9,100.00 Budgeted 7,523.06 Remaining 17 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 628 01/17/2014 Jan A/P SHI Inv GB00092011 904.12 233.50 1,137.62 TOWN OF TROPHY CLUB 33378 AP 688 01/30/2014 Jan A/P Elec, ISP, Flags, Postage mete 17.71 1,155.33 TOWN OF TROPHY CLUB 33419 AP 688 01/30/2014 Jan A/P SHI Invoices GB99737,99670, 99 91.00 1,246.33 TOWN OF TROPHY CLUB 33419 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 342.21 1,246.33 ** 5,732.00 Budgeted 4,485.67 Remaining 22 % Used Account: 135-65095-030-000 Maintenance Supplies 770 01/27/2014 12/27/13-1/27/14 PCards AMAZON.COM 756.79 49.79 806.58 AMAZON.COM PC 770 01/27/2014 12/27/13-1/27/14 PCards WAL-MART #5247 8.96 815.54 WAL-MART #5247 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 58.75 815.54 ** 2,500.00 Budgeted 1,684.46 Remaining 33 % Used Account: 135-65097-030-000 Vending Machine Supplies 684 01/16/2014 WWTP Vending 27.06 23.94 51.00 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 23.94 51.00 ** 200.00 Budgeted 149.00 Remaining 26 % Used Account: 135-65105-030-000 Printing . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,401.00 .00 1,401.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 661 01/24/2014 Jan A/P Fire XMAS party, SHI, Kyocera 256.85 513.70 770.55 TOWN OF TROPHY CLUB 33403 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 513.70 770.55 ** 3,450.00 Budgeted 2,679.45 Remaining 22 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 326,669.97 ** 1,055,199.00 Budgeted 728,529.03 Remaining 31 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/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 628 01/17/2014 Jan A/P 11/22/13-12/31/13 Legal 69,413.16 3,650.71 73,063.87 THE LISTON LAW FIRM, P.C. 33376 AP 628 01/17/2014 Jan A/P Legal 6,820.00 79,883.87 FREEMAN & CORBETT 33365 AP 644 01/21/2014 Jan A/P December General 201.60 80,085.47 WHITAKER CHALK SWINDLE 33387 AP 644 01/21/2014 Jan A/P Dec Legal/CCN (2012) 84.00 80,169.47 WHITAKER CHALK SWINDLE 33387 AP 644 01/21/2014 Jan A/P Dec Legal/Service to Westlake 4,698.55 84,868.02 WHITAKER CHALK SWINDLE 33387 AP 644 01/21/2014 Jan A/P New Contract with Town/Water & 739.20 85,607.22 WHITAKER CHALK SWINDLE 33387 AP 644 01/21/2014 Jan A/P Dec Legal/Bond issue for Plant 336.00 85,943.22 WHITAKER CHALK SWINDLE 33387 AP _______________ Account: 135-55045-039-000 Legal Totals: 16,530.06 85,943.22 ** 131,300.00 Budgeted 45,356.78 Remaining 65 % Used Account: 135-55055-039-000 Auditing 688 01/30/2014 Jan A/P Final Audit FY 2013 15,900.00 5,300.00 21,200.00 LAFOLLETT & ABBOTT PLLC 33412 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,300.00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 4,329.38 .00 4,329.38 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,329.38 ** 10,000.00 Budgeted 5,670.62 Remaining 43 % Used Account: 135-55065-039-000 Tax Admin Fees 611 01/03/2014 Town Billing Inv 1125 AR 20140103-20140103 User: (861.00) (861.00) AR 657 01/03/2014 Recode JE611/ESD2 Denton Fees 861.00 .00 GL 729 01/03/2014 Property Taxes & Assessments 2,451.40 2,451.40 GL _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,451.40 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 113,924.00 ** 166,940.00 Budgeted 53,016.00 Remaining 68 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 135,925.73 .00 Budgeted (135,925.73) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/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 753 01/31/2014 Bank Statement Interest/Jan (36.50) (6.12) (42.62) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (6.12) (42.62) ** .00 Budgeted 42.62 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (42.62) ** .00 Budgeted 42.62 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 1/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 628 01/17/2014 Jan A/P ROFC project 76,060.18 262.50 76,322.68 DELTATEK ENGINEERING 33364 AP 644 01/21/2014 Jan A/P App 6/Final ROFC Project 6,306.72 82,629.40 REY-MAR CONSTRUCTION 33386 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 6,569.22 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,586.78 .00 Budgeted (82,586.78) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 31, 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 346,000 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 65,194 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 416,040 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 65,194 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 65,194 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 332,968 TOTAL FUND BALANCE 350,847 TOTAL LIABILITIES AND FUND BALANCE 416,040 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 15:55 02/06/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/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- 134,912.09- 332,945.40- 85.543 56,270.60- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 8.24- 1.39 -.056 2,501.39- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 1.81- 15.19- .949 1,584.81- Subtotal: 393,316.00- 393,316.00- 134,922.14- 332,959.20- 84.654 60,356.80- 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- 5.44- 8.58- 2.288 366.42- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- Subtotal: 214,654.00- 214,654.00- 5.44- 8.58- .004 214,645.42- Program number: 624,495.00- 624,495.00- 134,927.58- 332,967.78- 53.318 291,527.22- Department number: Revenues 624,495.00- 624,495.00- 134,927.58- 332,967.78- 53.318 291,527.22- Revenues Subtotal ----------- 624,495.00- 624,495.00- 134,927.58- 332,967.78- 53.318 291,527.22- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 15:55 02/06/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/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 197,195.00 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 624,495.00 Program number: 624,495.00 624,495.00 624,495.00 Department number: Administration 624,495.00 624,495.00 624,495.00 Expenditures Subtotal ----------- 624,495.00 624,495.00 624,495.00 Fund number: 533 MUD 1 I&S Consolidated 134,927.58- 332,967.78- 332,967.78 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/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 763 01/02/2014 Property Taxes & Assessments (198,033.31) (11,632.08) (209,665.39) GL 729 01/03/2014 Property Taxes & Assessments (954.90) (210,620.29) GL 730 01/07/2014 Property Taxes & Assessments (4,016.75) (214,637.04) GL 731 01/08/2014 Property Taxes & Assessments (2,103.88) (216,740.92) GL 732 01/09/2014 Property Taxes & Assessments (7,975.64) (224,716.56) GL 733 01/10/2014 Property Taxes & Assessments (2,029.15) (226,745.71) GL 734 01/13/2014 Property Taxes & Assessments (2,445.92) (229,191.63) GL 736 01/14/2014 Property Taxes & Assessments (6,865.92) (236,057.55) GL 739 01/15/2014 Property Taxes & Assessments (2,521.95) (238,579.50) GL 740 01/16/2014 Property Taxes & Assessments (3,114.09) (241,693.59) GL 741 01/17/2014 Property Taxes & Assessments (1,738.78) (243,432.37) GL 743 01/21/2014 Property Taxes & Assessments (1,723.25) (245,155.62) GL 744 01/22/2014 Property Taxes & Assessments (3,696.89) (248,852.51) GL 745 01/23/2014 Property Taxes & Assessments (3,139.19) (251,991.70) GL 746 01/24/2014 Property Taxes & Assessments (2,055.75) (254,047.45) GL 747 01/27/2014 Property Taxes & Assessments (6,555.74) (260,603.19) GL 748 01/28/2014 Property Taxes & Assessments (60,367.94) (320,971.13) GL 749 01/29/2014 Property Taxes & Assessments (3,972.56) (324,943.69) GL 759 01/30/2014 Property Taxes & Assessments (2,485.64) (327,429.33) GL 760 01/31/2014 Property Taxes & Assessments (5,516.07) (332,945.40) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (134,912.09) (332,945.40) ** (389,216.00) Budgeted (56,270.60) Remaining 86 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 734 01/13/2014 Property Taxes & Assessments 9.63 (8.24) 1.39 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (8.24) 1.39 ** (2,500.00) Budgeted (2,501.39) Remaining 0 % Used Account: 533-40015-000-000 Property Taxes/P & I 734 01/13/2014 Property Taxes & Assessments (13.38) (1.81) (15.19) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (1.81) (15.19) ** (1,600.00) Budgeted (1,584.81) Remaining 1 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/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-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 753 01/31/2014 Bank Statement Interest/Jan (3.14) (5.44) (8.58) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (5.44) (8.58) ** (375.00) Budgeted (366.42) Remaining 2 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,279.00) Budgeted (214,279.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (332,967.78) ** (624,495.00) Budgeted (291,527.22) Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 15:55 02/06/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/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 .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 197,195.00 Budgeted 197,195.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ .00 ** 624,495.00 Budgeted 624,495.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (332,967.78) .00 Budgeted 332,967.78 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (929,884.06) **** .00 Budgeted 929,884.06 Remaining 0 % Used ******* End of Report *********