Loading...
HomeMy WebLinkAbout2016-01 January Combined Financials . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 09:23 02/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 404,346.00- 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 202,113.82- 794,740.81- 89.300 95,222.19- 122-40011-000-000 Property Taxes/Fire-Delinquent 525.29- 995.71- 995.71 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 155.16- 332.45- 7.388 4,167.55- Subtotal: 1,299,559.00- 1,299,559.00- 202,794.27- 796,068.97- 61.257 503,490.03- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 800.00- 2,800.00- 56.000 2,200.00- Subtotal: 5,000.00- 5,000.00- 800.00- 2,800.00- 56.000 2,200.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 150.00- 625.00- 75.758 200.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,825.00- 10,825.00- 150.00- 625.00- 5.774 10,200.00- 122-49026-000-000 Proceeds from Sale of Assets 55,800.00- 55,800.00- 55,800.00 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 1,600.00- 6,100.00- 12.200 43,900.00- Subtotal: 50,000.00- 50,000.00- 57,400.00- 61,900.00- 123.800 11,900.00 Program number: 1,365,384.00- 1,365,384.00- 261,144.27- 861,393.97- 63.088 503,990.03- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 261,144.27- 861,393.97- 63.088 503,990.03- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 261,144.27- 861,393.97- 63.088 503,990.03- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 09:23 02/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 37,375.61 149,471.47 29.410 358,754.53 122-50010-045-000 Overtime 48,735.00 48,735.00 4,475.00 20,977.93 43.045 27,757.07 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,643.90 92.379 1,208.10 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 387.50 1,190.13 28.336 3,009.87 122-50020-045-000 Retirement 75,571.00 75,571.00 4,783.22 24,973.47 33.046 50,597.53 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,823.92 16,346.47 24.939 49,199.53 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 391.01 1,365.00 27.943 3,520.00 122-50028-045-000 Vision Insurance 859.00 859.00 74.12 375.40 43.702 483.60 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 349.56 1,119.37 24.414 3,465.63 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,417.37 11,199.71 30.997 24,932.29 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 565.18 2,618.64 30.990 5,831.36 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 126.55 128.91 7.477 1,595.09 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 54.00 54.00 21.600 196.00 Subtotal: 790,155.00 790,155.00 55,823.04 250,194.40 31.664 539,960.60 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 1,850.00 27.774 4,811.00 122-55045-045-000 Legal 2,000.00 2,000.00 2,000.00 122-55080-045-000 Maintenance & Repairs 16,370.00 16,370.00 2,264.65 7,158.08 43.727 9,211.92 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 620.80 3,528.39 35.284 6,471.61 Subtotal: 35,031.00 35,031.00 3,347.95 12,536.47 35.787 22,494.53 122-60005-045-000 Telephone 50.00 50.00 5.73 17.38 34.760 32.62 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 226.83 4,671.72 70.220 1,981.28 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 542.74 1,288.53 17.384 6,123.47 122-60025-045-000 Water 1,200.00 1,200.00 115.62 572.76 47.730 627.24 122-60026-045-000 Cable 1,920.00 1,920.00 573.84 1,013.86 52.805 906.14 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 122-60035-045-000 Postage 50.00 50.00 7.97 7.97 15.940 42.03 122-60055-045-000 Insurance 14,077.00 14,077.00 5,546.83 9,066.10 64.404 5,010.90 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 350.00 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 280.00 15,121.59 97.045 460.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 341.39 1,706.39 21.655 6,173.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 4,081.00 769.45 933.34 22.870 3,147.66 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 500.00 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 209.50 6.580 2,974.50 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 209.74 217.24 21.702 783.76 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 09:23 02/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 8,620.14 35,874.06 12.285 256,144.94 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 313.82 1,583.17 10.469 13,538.83 122-65010-045-000 Uniforms 3,140.00 3,140.00 1,091.86 2,475.83 78.848 664.17 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 840.97 840.97 9.344 8,159.03 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 67.54 1,706.04 85.302 293.96 122-65055-045-000 Hardware 750.00 750.00 750.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 2,314.19 6,606.01 20.898 25,003.99 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,365,384.00 70,105.32 513,779.54 37.629 851,604.46 Department number: Fire 1,365,384.00 1,365,384.00 70,105.32 513,779.54 37.629 851,604.46 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 70,105.32 513,779.54 37.629 851,604.46 Fund number: 122 Trophy Club MUD Fire Dept. 191,038.95- 347,614.43- 347,614.43 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2016 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 .00 .00 _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 .00 ** (404,346.00) Budgeted (404,346.00) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 829 01/04/2016 Property Taxes/Assessments (592,626.99) (1,281.73) (593,908.72) GL 831 01/05/2016 Property Taxes/Assessments (19,651.54) (613,560.26) GL 832 01/06/2016 Property Taxes/Assessments (18,641.99) (632,202.25) GL 833 01/07/2016 Property Taxes/Assessments (14,964.58) (647,166.83) GL 834 01/08/2016 Property Taxes/Assessments (6,278.34) (653,445.17) GL 835 01/11/2016 Property Taxes/Assessments (7,624.17) (661,069.34) GL 836 01/12/2016 Property Taxes/Assessments (11,912.42) (672,981.76) GL 837 01/13/2016 Property Taxes/Assessments (11,095.90) (684,077.66) GL 838 01/14/2016 Property Taxes/Assessments (10,715.90) (694,793.56) GL 839 01/15/2016 Property Taxes/Assessments (4,123.75) (698,917.31) GL 840 01/19/2016 Property Taxes/Assessments (14,538.76) (713,456.07) GL 841 01/20/2016 Property Taxes/Assessments (4,237.61) (717,693.68) GL 842 01/21/2016 Property Taxes/Assessments (2,789.50) (720,483.18) GL 843 01/22/2016 Property Taxes/Assessments (5,488.10) (725,971.28) GL 844 01/25/2016 Property Taxes/Assessments (8,219.28) (734,190.56) GL 845 01/26/2016 Property Taxes/Assessments (12,276.52) (746,467.08) GL 847 01/27/2016 Property Taxes/Assessments (9,202.06) (755,669.14) GL 848 01/28/2016 Property Taxes/Assessments (21,472.92) (777,142.06) GL 850 01/29/2016 Property Taxes/Assessments (17,598.75) (794,740.81) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (202,113.82) (794,740.81) ** (889,963.00) Budgeted (95,222.19) Remaining 89 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 831 01/05/2016 Property Taxes/Assessments (470.42) (150.08) (620.50) GL 832 01/06/2016 Property Taxes/Assessments (7.62) (628.12) GL 834 01/08/2016 Property Taxes/Assessments 301.77 (326.35) GL 850 01/29/2016 Property Taxes/Assessments (669.36) (995.71) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (525.29) (995.71) ** .00 Budgeted 995.71 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2016 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-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 832 01/06/2016 Property Taxes/Assessments (177.29) (1.53) (178.82) GL 836 01/12/2016 Property Taxes/Assessments (8.19) (187.01) GL 837 01/13/2016 Property Taxes/Assessments (3.57) (190.58) GL 842 01/21/2016 Property Taxes/Assessments (.44) (191.02) GL 848 01/28/2016 Property Taxes/Assessments (15.70) (206.72) GL 850 01/29/2016 Property Taxes/Assessments (125.73) (332.45) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (155.16) (332.45) ** (4,500.00) Budgeted (4,167.55) Remaining 7 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (2,000.00) (800.00) (2,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (2,800.00) ** (5,000.00) Budgeted (2,200.00) Remaining 56 % Used Account: 122-43400-000-000 Fire Inspections 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (475.00) (150.00) (625.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (625.00) ** (825.00) Budgeted (200.00) Remaining 76 % 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-49026-000-000 Proceeds from Sale of Assets 758 01/21/2016 Recode proceeds from firetruck Recode proceeds from firetruck (60,000.00) (60,000.00) GL 758 01/21/2016 Recode proceeds from firetruck Recode proceeds from firetruck 4,200.00 (55,800.00) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: (55,800.00) (55,800.00) ** .00 Budgeted 55,800.00 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 704 01/12/2016 Bill Sale of Quint 681 AR 20160112-20160112 User: (4,500.00) (60,000.00) (64,500.00) AR 737 01/21/2016 Jan A/P 7% Advertisement fee for sale 4,200.00 (60,300.00) Texas Fire Trucks 1441 AP 758 01/21/2016 Recode proceeds from firetruck Recode proceeds from firetruck 60,000.00 (300.00) GL 758 01/21/2016 Recode proceeds from firetruck Recode proceeds from firetruck (4,200.00) (4,500.00) GL 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (1,600.00) (6,100.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,600.00) (6,100.00) ** (50,000.00) Budgeted (43,900.00) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (861,393.97) ** (1,365,384.00) Budgeted (503,990.03) Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 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 720 01/15/2016 Fire Dept Payroll 1/15/16 112,095.86 18,852.21 130,948.07 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 18,523.40 149,471.47 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 37,375.61 149,471.47 ** 508,226.00 Budgeted 358,754.53 Remaining 29 % Used Account: 122-50010-045-000 Overtime 720 01/15/2016 Fire Dept Payroll 1/15/16 16,502.93 4,475.00 20,977.93 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,475.00 20,977.93 ** 48,735.00 Budgeted 27,757.07 Remaining 43 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,643.90 .00 14,643.90 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,643.90 ** 15,852.00 Budgeted 1,208.10 Remaining 92 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 720 01/15/2016 Fire Dept Payroll 1/15/16 802.63 387.50 1,190.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 387.50 1,190.13 ** 4,200.00 Budgeted 3,009.87 Remaining 28 % Used Account: 122-50020-045-000 Retirement 720 01/15/2016 Fire Dept Payroll 1/15/16 20,190.25 2,717.73 22,907.98 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 2,065.49 24,973.47 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,783.22 24,973.47 ** 75,571.00 Budgeted 50,597.53 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 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 720 01/15/2016 Fire Dept Payroll 1/15/16 11,522.55 2,799.84 14,322.39 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 2,024.08 16,346.47 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,823.92 16,346.47 ** 65,546.00 Budgeted 49,199.53 Remaining 25 % Used Account: 122-50027-045-000 Dental Insurance 720 01/15/2016 Fire Dept Payroll 1/15/16 973.99 195.48 1,169.47 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 195.53 1,365.00 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 391.01 1,365.00 ** 4,885.00 Budgeted 3,520.00 Remaining 28 % Used Account: 122-50028-045-000 Vision Insurance 720 01/15/2016 Fire Dept Payroll 1/15/16 301.28 37.01 338.29 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 37.11 375.40 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 74.12 375.40 ** 859.00 Budgeted 483.60 Remaining 44 % Used Account: 122-50029-045-000 Life Insurance & Other 720 01/15/2016 Fire Dept Payroll 1/15/16 769.81 159.49 929.30 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 190.07 1,119.37 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 349.56 1,119.37 ** 4,585.00 Budgeted 3,465.63 Remaining 24 % Used Account: 122-50030-045-000 Social Security Taxes 720 01/15/2016 Fire Dept Payroll 1/15/16 8,782.34 1,369.60 10,151.94 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 1,047.77 11,199.71 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,417.37 11,199.71 ** 36,132.00 Budgeted 24,932.29 Remaining 31 % Used Account: 122-50035-045-000 Medicare Taxes 720 01/15/2016 Fire Dept Payroll 1/15/16 2,053.46 320.21 2,373.67 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 244.97 2,618.64 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 565.18 2,618.64 ** 8,450.00 Budgeted 5,831.36 Remaining 31 % Used Account: 122-50040-045-000 Unemployment Taxes 720 01/15/2016 Fire Dept Payroll 1/15/16 2.36 71.02 73.38 GL 809 01/29/2016 Fire Dept Payroll 1/29/16 55.53 128.91 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 126.55 128.91 ** 1,724.00 Budgeted 1,595.09 Remaining 7 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 54.00 54.00 TOWN OF TROPHY CLUB 1443 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 54.00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 1,387.50 462.50 1,850.00 TOWN OF TROPHY CLUB 1443 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 1,850.00 ** 6,661.00 Budgeted 4,811.00 Remaining 28 % Used Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 664 01/07/2016 PCards 11/28-12/28/15 SAMS CLUB #4795 4,893.43 376.48 5,269.91 SAMS CLUB #4795 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 737 01/21/2016 Jan A/P Fire dept fire extinguisher in 4,893.43 398.50 5,668.41 KIMBROUGH FIRE EXTINQUISHER CO 1428 AP 737 01/21/2016 Jan A/P Repair door west #2 345.00 6,013.41 OVERHEAD DOOR FORT WORTH 1435 AP 737 01/21/2016 Jan A/P Fire alarm trouble, heat detec 473.41 6,486.82 PRO FIRE & SPRINKLER LLC 1437 AP 761 01/25/2016 Void Ck 1282/Lost in Mail Service on sign transformer 8/ (178.00) 6,308.82 VALLELUNGA ENTERPRISES LLC 1282 AP 762 01/25/2016 A/P Check run Reissue for lost check # 1282 178.00 6,486.82 VALLELUNGA ENTERPRISES LLC 1447 AP 860 01/26/2016 PCards 12/29/15-1/26/16 SAMS CLUB #4795 279.82 6,766.64 SAMS CLUB #4795 PC 860 01/26/2016 PCards 12/29/15-1/26/16 JUSTIN SAW AND ENGINE 93.98 6,860.62 JUSTIN SAW AND ENGINE PC 860 01/26/2016 PCards 12/29/15-1/26/16 KELLER OUTDOOR POWER I 121.34 6,981.96 KELLER OUTDOOR POWER I PC 860 01/26/2016 PCards 12/29/15-1/26/16 SAMSCLUB #4795 68.88 7,050.84 SAMSCLUB #4795 PC 811 01/31/2016 Jan A/P Quarterly pest control 140.00 7,190.84 GANN'S PEST CONTROL 1463 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (107.24) 7,083.60 AR 923 01/31/2016 Jan A/P Rug Service 37.24 7,120.84 G & K SERVICES AP 923 01/31/2016 Jan A/P Rug Service 37.24 7,158.08 G & K SERVICES AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,264.65 7,158.08 ** 16,370.00 Budgeted 9,211.92 Remaining 44 % Used Account: 122-55090-045-000 Vehicle Maintenance 664 01/07/2016 PCards 11/28-12/28/15 WAL-MART #5247 2,907.59 14.97 2,922.56 WAL-MART #5247 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 101.42 3,023.98 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 WAL-MART #5247 35.61 3,059.59 WAL-MART #5247 PC 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 16.21 3,075.80 THE HOME DEPOT 6581 PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE AUTO SUPPLY LT 48.66 3,124.46 ROANOKE AUTO SUPPLY LT PC 860 01/26/2016 PCards 12/29/15-1/26/16 DISCOUNT TIRE TXD 75 385.00 3,509.46 DISCOUNT TIRE TXD 75 PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE AUTO SUPPLY LT 124.00 3,633.46 ROANOKE AUTO SUPPLY LT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE AUTO SUPPLY LT 18.93 3,652.39 ROANOKE AUTO SUPPLY LT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE AUTO SUPPLY LT (124.00) 3,528.39 ROANOKE AUTO SUPPLY LT PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 620.80 3,528.39 ** 10,000.00 Budgeted 6,471.61 Remaining 35 % Used Account: 122-60005-045-000 Telephone 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BUS PHONE PMT 11.65 5.73 17.38 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 5.73 17.38 ** 50.00 Budgeted 32.62 Remaining 35 % Used Account: 122-60010-045-000 Communications/Mobiles 720 01/15/2016 Fire Dept Payroll 1/15/16 4,444.89 75.00 4,519.89 GL 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 151.83 4,671.72 TOWN OF TROPHY CLUB 1443 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 226.83 4,671.72 ** 6,653.00 Budgeted 1,981.28 Remaining 70 % Used Account: 122-60020-045-000 Electricity/Gas 699 01/13/2016 Jan A/P Fire Station electricity 745.79 773.67 1,519.46 HUDSON ENERGY SERVICES, LLC 1385 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (542.72) 976.74 AR 923 01/31/2016 Jan A/P Fire Station Gas 12/17/15-1/18 311.79 1,288.53 ATMOS ENERGY AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 542.74 1,288.53 ** 7,412.00 Budgeted 6,123.47 Remaining 17 % Used Account: 122-60025-045-000 Water 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: 457.14 (115.61) 341.53 AR 923 01/31/2016 Jan A/P January water 231.23 572.76 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 122-60025-045-000 Water Totals: 115.62 572.76 ** 1,200.00 Budgeted 627.24 Remaining 48 % Used Account: 122-60026-045-000 Cable 664 01/07/2016 PCards 11/28-12/28/15 ATT*BILL PAYMENT 440.02 286.92 726.94 ATT*BILL PAYMENT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BILL PAYMENT 128.50 855.44 ATT*BILL PAYMENT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BILL PAYMENT 158.42 1,013.86 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 573.84 1,013.86 ** 1,920.00 Budgeted 906.14 Remaining 53 % 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,379.00 Budgeted 214,379.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 860 01/26/2016 PCards 12/29/15-1/26/16 USPS 48764506630613152 7.97 7.97 USPS 48764506630613152 PC _______________ Account: 122-60035-045-000 Postage Totals: 7.97 7.97 ** 50.00 Budgeted 42.03 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 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 135 01/01/2016 Prepaid Insurance, W/C Jan 3,519.27 1,173.09 4,692.36 GL 923 01/31/2016 Jan A/P Add new fire truck 4,373.74 9,066.10 TML INTERGOVERNMENTAL RISK AP _______________ Account: 122-60055-045-000 Insurance Totals: 5,546.83 9,066.10 ** 14,077.00 Budgeted 5,010.90 Remaining 64 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 923 01/31/2016 Jan A/P 2016 annual dues 14,841.59 280.00 15,121.59 DENTON CO FIRE CHIEFS ASSOC AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 280.00 15,121.59 ** 15,582.00 Budgeted 460.41 Remaining 97 % Used Account: 122-60080-045-000 Schools & Training 664 01/07/2016 PCards 11/28-12/28/15 HOT AND CREAMY DONUTS 1,365.00 39.22 1,404.22 HOT AND CREAMY DONUTS PC 664 01/07/2016 PCards 11/28-12/28/15 HOT AND CREAMY DONUTS 47.17 1,451.39 HOT AND CREAMY DONUTS PC 673 01/10/2016 Jan A/P Peters Certification 85.00 1,536.39 TX COMM ON FIRE PROTECTION 1417 AP 697 01/13/2016 Jan A/P Certification/Sampson 85.00 1,621.39 TX COMM ON FIRE PROTECTION 1417 AP 811 01/31/2016 Jan A/P Tackett Request to test for In 85.00 1,706.39 TX COMM ON FIRE PROTECTION 1480 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 341.39 1,706.39 ** 7,880.00 Budgeted 6,173.61 Remaining 22 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 860 01/26/2016 PCards 12/29/15-1/26/16 HAMPTON INN HOTELS 163.89 342.70 506.59 HAMPTON INN HOTELS PC 860 01/26/2016 PCards 12/29/15-1/26/16 HAMPTON INN HOTELS 342.70 849.29 HAMPTON INN HOTELS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 860 01/26/2016 PCards 12/29/15-1/26/16 EMBASSY-ROCKY RIVER GR 163.89 30.25 879.54 EMBASSY-ROCKY RIVER GR PC 860 01/26/2016 PCards 12/29/15-1/26/16 PANDA EXPRESS #1776 15.20 894.74 PANDA EXPRESS #1776 PC 860 01/26/2016 PCards 12/29/15-1/26/16 CHILI'S SAN MARCOS 24.58 919.32 CHILI'S SAN MARCOS PC 860 01/26/2016 PCards 12/29/15-1/26/16 WHATABURGER 538 Q26 14.02 933.34 WHATABURGER 538 Q26 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 769.45 933.34 ** 4,081.00 Budgeted 3,147.66 Remaining 23 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 209.50 .00 209.50 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 209.50 ** 3,184.00 Budgeted 2,974.50 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60245-045-000 Miscellaneous Expense 664 01/07/2016 PCards 11/28-12/28/15 WM SUPERCENTER #5247 7.50 187.80 195.30 WM SUPERCENTER #5247 PC 860 01/26/2016 PCards 12/29/15-1/26/16 WAL-MART #5247 21.94 217.24 WAL-MART #5247 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 209.74 217.24 ** 1,001.00 Budgeted 783.76 Remaining 22 % Used Account: 122-65005-045-000 Fuel & Lube 811 01/31/2016 Jan A/P Fuel purchases 12/25/15-1/24/1 1,269.35 313.82 1,583.17 US Bank Voyager Fleet Systems 1481 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 313.82 1,583.17 ** 15,122.00 Budgeted 13,538.83 Remaining 10 % Used Account: 122-65010-045-000 Uniforms 664 01/07/2016 PCards 11/28-12/28/15 NUSHOE 1,383.97 90.00 1,473.97 NUSHOE PC 664 01/07/2016 PCards 11/28-12/28/15 NUSHOE 90.00 1,563.97 NUSHOE PC 664 01/07/2016 PCards 11/28-12/28/15 NUSHOE 90.00 1,653.97 NUSHOE PC 697 01/13/2016 Jan A/P Uniforms 241.45 1,895.42 RED THE UNIFORM TAILOR 1402 AP 737 01/21/2016 Jan A/P Uniforms 756.70 2,652.12 RED THE UNIFORM TAILOR 1438 AP 860 01/26/2016 PCards 12/29/15-1/26/16 REDBACK, USA 161.40 2,813.52 REDBACK, USA PC 811 01/31/2016 Jan A/P Uniforms 81.32 2,894.84 RED THE UNIFORM TAILOR 1476 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (419.01) 2,475.83 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 1,091.86 2,475.83 ** 3,140.00 Budgeted 664.17 Remaining 79 % Used Account: 122-65015-045-000 Protective Clothing 811 01/31/2016 Jan A/P PPE Care & Maint svc 840.97 840.97 Gear Cleaning Solutions, LLC 1464 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 840.97 840.97 ** 9,000.00 Budgeted 8,159.03 Remaining 9 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 1,638.50 47.57 1,686.07 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 WM SUPERCENTER #5247 19.97 1,706.04 WM SUPERCENTER #5247 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 67.54 1,706.04 ** 2,000.00 Budgeted 293.96 Remaining 85 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 513,779.54 ** 1,365,384.00 Budgeted 851,604.46 Remaining 38 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (347,614.43) .00 Budgeted 347,614.43 Remaining 0 % Used TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2016 122 ASSETS FIRE DEPT. CASH IN BANK 2,123 INVESTMENTS 899,271 PREPAID EXPENSES 9,385 ADVALOREM PROPERTY TAXES RECEIVABLE 117,677 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 346 UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,735 TOTAL ASSETS 1,032,537 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 118,022 ACCOUNTS AND OTHER PAYABLES 33,403 TOTAL LIABILITIES 151,425 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 347,614 TOTAL FUND BALANCE 881,112 TOTAL LIABILITIES AND FUND BALANCE 1,032,537 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 13,209.31- 51,940.96- 89.275 6,240.04- 135-40002-000-000 Property Taxes/Delinquent 46.91- 134.60- 134.60 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 17.91- 44.53- 6.851 605.47- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 24,739.19- 16.930 121,385.81- Subtotal: 204,956.00- 204,956.00- 13,274.13- 76,859.28- 37.500 128,096.72- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 230,791.72- 1,135,337.45- 22.348 3,944,906.55- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 155,683.36- 667,052.61- 27.635 1,746,723.39- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 9,046.80- 41,512.18- 45.625 49,472.82- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 975.00- 5,475.00- 60.833 3,525.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 350.00- 1,350.00- 67.500 650.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 1,050.00- 3,900.00- 70.909 1,600.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 49.00- 6,013.00- 9.804 55,317.00- Subtotal: 7,662,835.00- 7,662,835.00- 397,945.88- 1,860,640.24- 24.281 5,802,194.76- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 6,900.00- 55,200.00- 80.000 13,800.00- Subtotal: 69,000.00- 69,000.00- 6,900.00- 55,200.00- 80.000 13,800.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 1,049.68- 3,420.72- 57.012 2,579.28- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 3,642.12- 33.334 7,283.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-49026-000-000 Proceeds from Sale of Assets 15,070.00- 15,070.00- 15,070.00 135-49035-000-000 Prior Year Reserves 8,020.00- 8,020.00- 8,020.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 6,174.00- 24,015.80- 152.211 8,237.80 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 288.50- 858.55- 1.357 62,390.45- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 18.40- 20.40- 102.000 .40 Subtotal: 110,993.00- 110,993.00- 24,094.44- 57,395.27- 51.711 53,597.73- Program number: 8,047,784.00- 8,047,784.00- 442,214.45- 2,050,094.79- 25.474 5,997,689.21- Department number: Revenues 8,047,784.00- 8,047,784.00- 442,214.45- 2,050,094.79- 25.474 5,997,689.21- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 442,214.45- 2,050,094.79- 25.474 5,997,689.21- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 265,614.00 16,412.40 67,967.96 25.589 197,646.04 135-50010-010-000 Overtime 19,500.00 19,500.00 1,317.97 4,682.73 24.014 14,817.27 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 4,200.00 200.00 725.00 17.262 3,475.00 135-50020-010-000 Retirement 25,558.00 25,558.00 1,565.32 6,767.90 26.481 18,790.10 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 12,137.46 23.615 39,260.54 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 898.56 22.470 3,100.44 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 203.28 22.338 706.72 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 189.88 763.66 27.244 2,039.34 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 1,113.07 4,691.15 25.269 13,873.85 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 260.31 1,097.10 25.273 3,243.90 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 17.94 22.00 1.771 1,220.00 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,085.15- 2,602.88 17.642 12,151.12 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 417,429.00 417,429.00 23,447.64 105,741.13 25.332 311,687.87 135-55005-010-000 Engineering 5,000.00 5,000.00 19,593.33- 5,640.00 112.800 640.00- 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 25,149.19 42,964.42 50.546 42,035.58 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 546.99 2,770.22 34.628 5,229.78 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 142.45 142.45 4.070 3,357.55 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 325.00 1,262.70 22.958 4,237.30 Subtotal: 107,000.00 107,000.00 6,570.30 52,779.79 49.327 54,220.21 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 1,489.95 27.592 3,910.05 135-60020-010-000 Electricity 166,823.00 166,823.00 10,891.97 39,874.66 23.902 126,948.34 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 151.00 835.00 14.464 4,938.00 135-60090-010-000 Safety Program 400.00 400.00 227.97 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 14.25 1.018 1,385.75 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 3,997.90 10,501.40 21.312 38,773.60 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 109,839.98 464,297.51 15.746 2,484,444.49 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 456.00 1,026.49 29.328 2,473.51 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 125,564.82 518,288.23 16.264 2,668,474.77 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 1,784.92 5,272.61 14.668 30,674.39 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,194.01 1,845.24 40.044 2,762.76 135-65030-010-000 Chemicals 12,000.00 12,000.00 1,038.57 4,174.63 34.789 7,825.37 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 187.99 187.99 18.799 812.01 135-65050-010-000 Meter Expense 115,000.00 115,000.00 18,805.34 16.352 96,194.66 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 44,700.00 89.400 5,300.00 Subtotal: 219,755.00 219,755.00 4,205.49 74,985.81 34.122 144,769.19 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 13,000.00 62,025.85 30.859 138,974.15 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,720.00 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,209.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 126,958.00 126,958.00 37,787.73 118,774.42 93.554 8,183.58 Subtotal: 534,887.00 534,887.00 50,787.73 255,800.27 47.823 279,086.73 Program number: 4,465,834.00 4,465,834.00 210,575.98 1,007,595.23 22.562 3,458,238.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 320.00 6.400 4,680.00 Subtotal: 5,000.00 5,000.00 80.00 320.00 6.400 4,680.00 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 320.00 3.200 9,680.00 Department number: Water 4,475,834.00 4,475,834.00 210,655.98 1,007,915.23 22.519 3,467,918.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,560.01 111,247.77 31.634 240,423.23 135-50010-020-000 Overtime 19,500.00 19,500.00 2,563.91 9,536.78 48.907 9,963.22 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 625.00 2,350.00 32.639 4,850.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,771.69 11,459.89 34.054 22,192.11 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 19,668.78 29.806 46,320.22 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 1,162.53 27.785 3,021.47 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 266.70 27.438 705.30 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 398.21 1,277.06 34.940 2,377.94 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,778.25 7,369.49 29.878 17,295.51 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 415.87 1,723.47 29.880 4,044.53 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 31.73 38.30 2.643 1,410.70 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 1,538.07- 791.23 8.492 8,525.77 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 650.00 Subtotal: 535,097.00 535,097.00 41,564.53 173,255.45 32.378 361,841.55 135-55070-020-000 Independent Labor 50,000.00 50,000.00 50,000.00 135-55080-020-000 Maintenance & Repairs 72,600.00 72,600.00 3,199.14 16,044.89 22.100 56,555.11 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 240.00 385.88 7.718 4,614.12 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,361.41 9,193.61 16.716 45,806.39 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,864.00 9,848.00 28.137 25,152.00 Subtotal: 218,100.00 218,100.00 8,664.55 35,472.38 16.264 182,627.62 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 332.60 1,911.41 35.396 3,488.59 135-60020-020-000 Electricity 161,582.00 161,582.00 11,773.41 35,908.26 22.223 125,673.74 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 830.00 830.00 22.010 2,941.00 135-60090-020-000 Safety Program 550.00 550.00 153.79 192.79 35.053 357.21 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 761.28 761.28 47.580 838.72 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 9,439.28 25.409 27,710.72 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 297.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 119,706.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 444,831.00 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 61,668.00 50.000 61,668.00 Subtotal: 908,423.00 908,423.00 13,851.08 110,711.02 12.187 797,711.98 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 2,832.62 4,819.71 15.052 27,201.29 135-65010-020-000 Uniforms 4,241.00 4,241.00 275.78 2,483.54 58.560 1,757.46 135-65030-020-000 Chemicals 27,000.00 27,000.00 2,249.85 10,658.27 39.475 16,341.73 135-65035-020-000 Small Tools 2,000.00 2,000.00 50.40 50.40 2.520 1,949.60 135-65040-020-000 Safety Equipment 750.00 750.00 162.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 1,570.10 4,825.31 37.118 8,174.69 Subtotal: 79,012.00 79,012.00 7,140.75 23,413.82 29.633 55,598.18 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 593.92 24,198.75 16.133 125,801.25 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,280.00 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 Subtotal: 171,477.00 171,477.00 593.92 24,198.75 14.112 147,278.25 Program number: 1,912,109.00 1,912,109.00 71,814.83 367,051.42 19.196 1,545,057.58 Department number: Wastewater 1,912,109.00 1,912,109.00 71,814.83 367,051.42 19.196 1,545,057.58 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 600.00 2,100.00 16.800 10,400.00 135-50030-026-000 Social Security Taxes 775.00 775.00 37.20 130.20 16.800 644.80 135-50035-026-000 Medicare Taxes 181.00 181.00 8.70 30.45 16.823 150.55 135-50040-026-000 Unemployment Taxes 230.00 230.00 .60 2.10 .913 227.90 135-50045-026-000 Workman's Compensation 37.00 37.00 16.08 25.33 68.459 11.67 Subtotal: 13,723.00 13,723.00 662.58 2,288.08 16.673 11,434.92 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 6.00 .500 1,194.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 550.00 13.750 3,450.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 718.54 718.54 14.371 4,281.46 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 718.54 1,325.02 10.311 11,524.98 Program number: 26,573.00 26,573.00 1,381.12 3,613.10 13.597 22,959.90 Department number: Board of Directors 26,573.00 26,573.00 1,381.12 3,613.10 13.597 22,959.90 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 488,508.00 37,279.79 152,766.90 31.272 335,741.10 135-50010-030-000 Overtime 1,000.00 1,000.00 30.93 110.62 11.062 889.38 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,202.00 3,257.23 13,894.86 32.163 29,307.14 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,310.72 19,974.35 29.290 48,221.65 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 378.79 1,326.62 27.598 3,480.38 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 87.14 306.77 27.538 807.23 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 392.55 1,536.63 34.679 2,894.37 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 2,138.89 9,123.94 29.601 21,699.06 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 500.22 2,133.81 28.080 5,465.19 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 37.19 37.19 2.567 1,411.81 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 439.89 883.56 56.857 670.44 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 1,513.01 2,860.56 57.211 2,139.44 Subtotal: 662,006.00 662,006.00 51,366.35 208,778.31 31.537 453,227.69 135-55030-030-000 Software & Support 78,483.00 78,483.00 2,606.22 8,799.94 11.213 69,683.06 135-55070-030-000 Independent Labor 12,000.00 12,000.00 97.50 12,923.23 107.694 923.23- 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 7,724.66 26.185 21,775.34 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 218.39 1,086.06 15.515 5,913.94 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 1,428.50 2,339.00 23.101 7,786.00 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 51,570.00 84.437 9,505.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 654.12 2,540.87 30.986 5,659.13 Subtotal: 206,583.00 206,583.00 5,004.73 86,983.76 42.106 119,599.24 135-60005-030-000 Telephone 16,349.00 16,349.00 2,061.17 4,937.08 30.198 11,411.92 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 300.00 1,351.96 32.577 2,798.04 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 1,660.33 2,475.12 22.986 8,292.88 135-60025-030-000 Water 1,500.00 1,500.00 60.49 306.73 20.449 1,193.27 135-60035-030-000 Postage 28,932.00 28,932.00 2,842.41 8,924.06 30.845 20,007.94 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 4,816.38 23,144.10 52.600 20,855.90 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 4,291.83 4,291.83 122.624 791.83- 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 11,124.00 21.069 41,673.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,896.25 81.604 1,103.75 135-60075-030-000 Meetings 400.00 400.00 29.00 29.00 7.250 371.00 135-60079-030-000 Public Education 5,000.00 5,000.00 394.00 581.65 11.633 4,418.35 135-60080-030-000 Schools & Training 9,935.00 9,935.00 1,398.00 1,857.00 18.691 8,078.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 1,158.31 1,888.33 34.969 3,511.67 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 613.62- 61.74 .823 7,438.26 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 3,693.00 4,115.98 23.519 13,385.02 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 656.38 26.255 1,843.62 Subtotal: 226,882.00 226,882.00 25,503.68 70,641.21 31.136 156,240.79 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 29,594.00 5,871.85 19.841 23,722.15 135-65085-030-000 Office Supplies 9,000.00 9,000.00 637.48 1,978.19 21.980 7,021.81 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 221.30 5.528 3,781.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 296.06 1,316.47 26.329 3,683.53 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 54,252.00 54,252.00 956.54 9,410.81 17.346 44,841.19 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 1,427.50 1,427.50 2.549 54,572.50 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 381.33 1,143.67 24.862 3,456.33 Subtotal: 60,600.00 60,600.00 1,808.83 2,571.17 4.243 58,028.83 Program number: 1,210,323.00 1,210,323.00 84,640.13 378,385.26 31.263 831,937.74 Department number: Administration 1,210,323.00 1,210,323.00 84,640.13 378,385.26 31.263 831,937.74 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 09:23 02/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 7,606.95 102,471.44 26.538 283,658.56 135-55055-039-000 Auditing 22,750.00 22,750.00 7,793.88 24,039.38 105.668 1,289.38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 4,229.90 41.207 6,035.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 422,945.00 15,400.83 133,209.54 31.496 289,735.46 Program number: 422,945.00 422,945.00 15,400.83 133,209.54 31.496 289,735.46 Department number: Non Departmental 422,945.00 422,945.00 15,400.83 133,209.54 31.496 289,735.46 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 383,892.89 1,890,174.55 23.487 6,157,609.45 Fund number: 135 MUD 1 General Fund 58,321.56- 159,920.24- 159,920.24 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 09:23 02/11/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 09:23 02/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 09:23 02/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 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 829 01/04/2016 Property Taxes/Assessments (38,731.65) (83.77) (38,815.42) GL 831 01/05/2016 Property Taxes/Assessments (1,284.34) (40,099.76) GL 832 01/06/2016 Property Taxes/Assessments (1,218.36) (41,318.12) GL 833 01/07/2016 Property Taxes/Assessments (978.02) (42,296.14) GL 834 01/08/2016 Property Taxes/Assessments (410.33) (42,706.47) GL 835 01/11/2016 Property Taxes/Assessments (498.28) (43,204.75) GL 836 01/12/2016 Property Taxes/Assessments (778.55) (43,983.30) GL 837 01/13/2016 Property Taxes/Assessments (725.18) (44,708.48) GL 838 01/14/2016 Property Taxes/Assessments (700.35) (45,408.83) GL 839 01/15/2016 Property Taxes/Assessments (269.51) (45,678.34) GL 840 01/19/2016 Property Taxes/Assessments (950.19) (46,628.53) GL 841 01/20/2016 Property Taxes/Assessments (276.95) (46,905.48) GL 842 01/21/2016 Property Taxes/Assessments (182.31) (47,087.79) GL 843 01/22/2016 Property Taxes/Assessments (358.68) (47,446.47) GL 844 01/25/2016 Property Taxes/Assessments (537.18) (47,983.65) GL 845 01/26/2016 Property Taxes/Assessments (802.34) (48,785.99) GL 847 01/27/2016 Property Taxes/Assessments (601.41) (49,387.40) GL 848 01/28/2016 Property Taxes/Assessments (1,403.38) (50,790.78) GL 850 01/29/2016 Property Taxes/Assessments (1,150.18) (51,940.96) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (13,209.31) (51,940.96) ** (58,181.00) Budgeted (6,240.04) Remaining 89 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 831 01/05/2016 Property Taxes/Assessments (87.69) (13.90) (101.59) GL 832 01/06/2016 Property Taxes/Assessments (1.47) (103.06) GL 834 01/08/2016 Property Taxes/Assessments 58.04 (45.02) GL 850 01/29/2016 Property Taxes/Assessments (89.58) (134.60) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (46.91) (134.60) ** .00 Budgeted 134.60 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 832 01/06/2016 Property Taxes/Assessments (26.62) (.29) (26.91) GL 836 01/12/2016 Property Taxes/Assessments (.53) (27.44) GL 837 01/13/2016 Property Taxes/Assessments (.24) (27.68) GL 842 01/21/2016 Property Taxes/Assessments (.03) (27.71) GL 848 01/28/2016 Property Taxes/Assessments (1.03) (28.74) GL 850 01/29/2016 Property Taxes/Assessments (15.79) (44.53) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (17.91) (44.53) ** (650.00) Budgeted (605.47) Remaining 7 % Used Account: 135-40025-000-000 PID Surcharges (24,739.19) .00 (24,739.19) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 (24,739.19) ** (146,125.00) Budgeted (121,385.81) Remaining 17 % Used Account: 135-47000-000-000 Water 777 01/27/2016 Bill Kodiak Inv 1403 AR 20160127-20160127 User: (904,545.73) (2,946.40) (907,492.13) AR 788 01/31/2016 UB 1/31/16 Billing UB20160131-20160131 User: (227,845.32) (1,135,337.45) UB _______________ Account: 135-47000-000-000 Water Totals: (230,791.72) (1,135,337.45) ** (5,080,244.00) Budgeted (3,944,906.55) Remaining 22 % Used Account: 135-47005-000-000 Sewer 788 01/31/2016 UB 1/31/16 Billing UB20160131-20160131 User: (511,369.25) (155,683.36) (667,052.61) UB _______________ Account: 135-47005-000-000 Sewer Totals: (155,683.36) (667,052.61) ** (2,413,776.00) Budgeted (1,746,723.39) Remaining 28 % Used Account: 135-47025-000-000 Penalties 800 01/19/2016 UB 1/19/16 Penalties UB20160119-20160119 User: (32,465.38) 352.42 (32,112.96) UB 740 01/21/2016 UB 1/21/16 Penalties UB20160121-20160121 User: (9,896.38) (42,009.34) UB 806 01/28/2016 UB 1/28/16 Penalties UB20160128-20160128 User: 317.26 (41,692.08) UB 807 01/29/2016 UB 1/29/16 Penalties UB20160129-20160129 User: 179.90 (41,512.18) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,046.80) (41,512.18) ** (90,985.00) Budgeted (49,472.82) Remaining 46 % Used Account: 135-47030-000-000 Service Charges 634 01/06/2016 UB 1/6/16 Cut Off List UB20160106-20160106 User: (4,500.00) (1,000.00) (5,500.00) UB 806 01/28/2016 UB 1/28/16 Penalties UB20160128-20160128 User: 25.00 (5,475.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (975.00) (5,475.00) ** (9,000.00) Budgeted (3,525.00) Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47035-000-000 Plumbing Inspections 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (1,000.00) (350.00) (1,350.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (1,350.00) ** (2,000.00) Budgeted (650.00) Remaining 68 % Used Account: 135-47045-000-000 Sewer Inspections 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (2,850.00) (1,050.00) (3,900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,050.00) (3,900.00) ** (5,500.00) Budgeted (1,600.00) Remaining 71 % Used Account: 135-47070-000-000 TCCC Effluent Charges 788 01/31/2016 UB 1/31/16 Billing UB20160131-20160131 User: (5,964.00) (49.00) (6,013.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (49.00) (6,013.00) ** (61,330.00) Budgeted (55,317.00) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (48,300.00) (6,900.00) (55,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (6,900.00) (55,200.00) ** (69,000.00) Budgeted (13,800.00) Remaining 80 % Used Account: 135-49010-000-000 Interest Income 853 01/31/2016 Bank Interest/Month (2,371.04) (11.83) (2,382.87) GL 853 01/31/2016 Bank Interest/Month (584.12) (2,966.99) GL 853 01/31/2016 Bank Interest/Month (299.89) (3,266.88) GL 853 01/31/2016 Bank Interest/Month (153.84) (3,420.72) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,049.68) (3,420.72) ** (6,000.00) Budgeted (2,579.28) Remaining 57 % Used Account: 135-49016-000-000 Cell Tower Revenue 862 01/04/2016 AT&T Cell Tower Revenue (2,731.59) (910.53) (3,642.12) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (3,642.12) ** (10,926.00) Budgeted (7,283.88) Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 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-49026-000-000 Proceeds from Sale of Assets 756 01/25/2016 Refund/Generator Auction Refund Auction price for missi 500.00 500.00 Jimmy Elmore 1446 AP 867 01/28/2016 Lone Star Auctioneers (15,570.00) (15,070.00) GL _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (15,070.00) (15,070.00) ** .00 Budgeted 15,070.00 Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (17,841.80) (6,174.00) (24,015.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,174.00) (24,015.80) ** (15,778.00) Budgeted 8,237.80 Remaining 152 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 777 01/27/2016 Bill Kodiak Inv 1403 AR 20160127-20160127 User: (570.05) (225.00) (795.05) AR 788 01/31/2016 UB 1/31/16 Billing UB20160131-20160131 User: (63.50) (858.55) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (288.50) (858.55) ** (63,249.00) Budgeted (62,390.45) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49901-000-000 Records Management Revenue 864 01/26/2016 Mayer/open records (2.00) (14.80) (16.80) GL 865 01/27/2016 Mayer/open records (3.60) (20.40) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (18.40) (20.40) ** (20.00) Budgeted .40 Remaining 102 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,050,094.79) ** (8,047,784.00) Budgeted (5,997,689.21) Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 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 683 01/15/2016 PR 01-15-2016 Salaries & Wages 51,555.56 8,206.20 59,761.76 PR 765 01/29/2016 MUD Payroll 1/29/16 Salaries & Wages 8,206.20 67,967.96 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,412.40 67,967.96 ** 265,614.00 Budgeted 197,646.04 Remaining 26 % Used Account: 135-50010-010-000 Overtime 683 01/15/2016 PR 01-15-2016 Overtime 3,364.76 688.42 4,053.18 PR 765 01/29/2016 MUD Payroll 1/29/16 Overtime 629.55 4,682.73 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,317.97 4,682.73 ** 19,500.00 Budgeted 14,817.27 Remaining 24 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 765 01/29/2016 MUD Payroll 1/29/16 Certification 525.00 200.00 725.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 725.00 ** 4,200.00 Budgeted 3,475.00 Remaining 17 % Used Account: 135-50020-010-000 Retirement 683 01/15/2016 PR 01-15-2016 Retirement 5,202.58 776.51 5,979.09 PR 765 01/29/2016 MUD Payroll 1/29/16 Retirement 788.81 6,767.90 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,565.32 6,767.90 ** 25,558.00 Budgeted 18,790.10 Remaining 26 % Used Account: 135-50026-010-000 Medical Insurance 683 01/15/2016 PR 01-15-2016 Medical Insurance 8,976.31 1,580.60 10,556.91 PR 765 01/29/2016 MUD Payroll 1/29/16 Medical Insurance 1,580.55 12,137.46 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 12,137.46 ** 51,398.00 Budgeted 39,260.54 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 683 01/15/2016 PR 01-15-2016 Dental Insurance 657.79 120.39 778.18 PR 765 01/29/2016 MUD Payroll 1/29/16 Dental Insurance 120.38 898.56 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 898.56 ** 3,999.00 Budgeted 3,100.44 Remaining 22 % Used Account: 135-50028-010-000 Vision Insurance 683 01/15/2016 PR 01-15-2016 Vision Insurance 149.30 27.01 176.31 PR 765 01/29/2016 MUD Payroll 1/29/16 Vision Insurance 26.97 203.28 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 203.28 ** 910.00 Budgeted 706.72 Remaining 22 % Used Account: 135-50029-010-000 Life Insurance & Other 536 01/01/2016 January A/P January dental, vision & other 573.78 180.17 753.95 METLIFE GROUP BENEFITS 1325 AP 923 01/31/2016 Jan A/P Flex account admin fee 9.71 763.66 BenefitMall AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 189.88 763.66 ** 2,803.00 Budgeted 2,039.34 Remaining 27 % Used Account: 135-50030-010-000 Social Security Taxes 683 01/15/2016 PR 01-15-2016 Social Security Taxes 3,578.08 547.03 4,125.11 PR 765 01/29/2016 MUD Payroll 1/29/16 Social Security Taxes 566.04 4,691.15 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,113.07 4,691.15 ** 18,565.00 Budgeted 13,873.85 Remaining 25 % Used Account: 135-50035-010-000 Medicare Taxes 683 01/15/2016 PR 01-15-2016 Medicare Taxes 836.79 127.93 964.72 PR 765 01/29/2016 MUD Payroll 1/29/16 Medicare Taxes 132.38 1,097.10 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 260.31 1,097.10 ** 4,341.00 Budgeted 3,243.90 Remaining 25 % Used Account: 135-50040-010-000 Unemployment Taxes 683 01/15/2016 PR 01-15-2016 Unemployment Taxes 4.06 8.91 12.97 PR 765 01/29/2016 MUD Payroll 1/29/16 Unemployment Taxes 9.03 22.00 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 17.94 22.00 ** 1,242.00 Budgeted 1,220.00 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 135 01/01/2016 Prepaid Insurance, W/C Jan 3,688.03 1,229.35 4,917.38 GL 863 01/12/2016 TML FY2015 W/C Audit refund (2,314.50) 2,602.88 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: (1,085.15) 2,602.88 ** 14,754.00 Budgeted 12,151.12 Remaining 18 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering 705 01/12/2016 Bill Maguire Inv 1389 AR 20160112-20160112 User: 25,233.33 (19,593.33) 5,640.00 AR _______________ Account: 135-55005-010-000 Engineering Totals: (19,593.33) 5,640.00 ** 5,000.00 Budgeted (640.00) Remaining 113 % Used Account: 135-55080-010-000 Maintenance & Repairs 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 17,815.23 8.92 17,824.15 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 5.24 17,829.39 THE HOME DEPOT 6581 PC 673 01/10/2016 Jan A/P Parts for Solana Mainbreak 142.69 17,972.08 ATLAS UTILITY SUPPLY CO. 1367 AP 673 01/10/2016 Jan A/P Emergency repair/2 Campus Circ 12,215.81 30,187.89 REY-MAR CONSTRUCTION 1403 AP 697 01/13/2016 Jan A/P Remove altitude valve at TW Ki 7,650.00 37,837.89 REY-MAR CONSTRUCTION 1403 AP 737 01/21/2016 Jan A/P Fire extinguisher inspections 403.00 38,240.89 KIMBROUGH FIRE EXTINQUISHER CO 1428 AP 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 14.48 38,255.37 THE HOME DEPOT 6581 PC 860 01/26/2016 PCards 12/29/15-1/26/16 FASTENAL COMPANY01 42.00 38,297.37 FASTENAL COMPANY01 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 860 01/26/2016 PCards 12/29/15-1/26/16 FASTENAL COMPANY01 17,815.23 10.20 38,307.57 FASTENAL COMPANY01 PC 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 11.80 38,319.37 THE HOME DEPOT 6581 PC 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 57.94 38,377.31 THE HOME DEPOT 6581 PC 860 01/26/2016 PCards 12/29/15-1/26/16 Tier II Water 50.00 38,427.31 TCEQ EPAYMENT PC 860 01/26/2016 PCards 12/29/15-1/26/16 AMAZON.COM 137.00 38,564.31 AMAZON.COM PC 811 01/31/2016 Jan A/P Meter boxes and Meter box lids 2,730.52 41,294.83 HD SUPPLY WATERWORKS, LTD. 1465 AP 811 01/31/2016 Jan A/P Water plant generator mother b 1,636.35 42,931.18 WORLDWIDE POWER PRODUCTS 1483 AP 923 01/31/2016 Jan A/P Chlorine danger signs 33.24 42,964.42 HD SUPPLY FACILITIES MAINT LTD AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 25,149.19 42,964.42 ** 85,000.00 Budgeted 42,035.58 Remaining 51 % Used Account: 135-55090-010-000 Vehicle Maintenance 664 01/07/2016 PCards 11/28-12/28/15 MUSTANG ELITE CAR 2,223.23 102.99 2,326.22 MUSTANG ELITE CAR PC 664 01/07/2016 PCards 11/28-12/28/15 DISCOUNT TIRE TXD 75 329.00 2,655.22 DISCOUNT TIRE TXD 75 PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE TIRE & (5.50) 2,649.72 ROANOKE TIRE & PC 860 01/26/2016 PCards 12/29/15-1/26/16 ROANOKE TIRE & 25.50 2,675.22 ROANOKE TIRE & PC 811 01/31/2016 Jan A/P flat repair/dump truck 95.00 2,770.22 BLAGG TIRE & SERVICE 1457 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 546.99 2,770.22 ** 8,000.00 Budgeted 5,229.78 Remaining 35 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 664 01/07/2016 PCards 11/28-12/28/15 ROANOKE AUTO SUPPLY LT 59.01 59.01 ROANOKE AUTO SUPPLY LT PC 664 01/07/2016 PCards 11/28-12/28/15 ROANOKE AUTO SUPPLY LT 83.44 142.45 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 142.45 142.45 ** 3,500.00 Budgeted 3,357.55 Remaining 4 % Used Account: 135-55135-010-000 Lab Analysis 811 01/31/2016 Jan A/P Water Bacteriological Testing 937.70 40.00 977.70 Denton Municipal Utilities 1460 AP 923 01/31/2016 Jan A/P Water Samples-MUD 285.00 1,262.70 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 325.00 1,262.70 ** 5,500.00 Budgeted 4,237.30 Remaining 23 % Used Account: 135-60010-010-000 Communications/Mobiles 1,489.95 .00 1,489.95 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 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-010-000 Communications/Mobiles Totals: .00 1,489.95 ** 5,400.00 Budgeted 3,910.05 Remaining 28 % Used Account: 135-60020-010-000 Electricity 697 01/13/2016 Jan A/P Electricity 12/9-1/9/16 28,982.69 65.77 29,048.46 HUDSON ENERGY SERVICES, LLC 1385 AP 699 01/13/2016 Jan A/P Electricity 12/10/15-1/11-16 1,612.98 30,661.44 HUDSON ENERGY SERVICES, LLC 1385 AP 735 01/20/2016 Jan A/P Electricity 12/10-1/11/16 9,213.22 39,874.66 HUDSON ENERGY SERVICES, LLC 1426 AP _______________ Account: 135-60020-010-000 Electricity Totals: 10,891.97 39,874.66 ** 166,823.00 Budgeted 126,948.34 Remaining 24 % 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 .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 626 01/05/2016 Jan A/P D Water Test/Matt Chitty 684.00 40.00 724.00 N CENTRAL TX COG 1362 AP 664 01/07/2016 PCards 11/28-12/28/15 TCEQ IND RENEWAL L 111.00 835.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 151.00 835.00 ** 5,773.00 Budgeted 4,938.00 Remaining 14 % Used Account: 135-60090-010-000 Safety Program 664 01/07/2016 PCards 11/28-12/28/15 AMAZON.COM 21.00 96.15 117.15 AMAZON.COM PC 664 01/07/2016 PCards 11/28-12/28/15 BASS PRO SHOPS 131.82 248.97 BASS PRO SHOPS PC _______________ Account: 135-60090-010-000 Safety Program Totals: 227.97 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 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-010-000 Travel & per diem 14.25 .00 14.25 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 14.25 ** 1,400.00 Budgeted 1,385.75 Remaining 1 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 923 01/31/2016 Jan A/P Well Water 6,503.50 3,997.90 10,501.40 North Texas Groundwater AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,997.90 10,501.40 ** 49,275.00 Budgeted 38,773.60 Remaining 21 % Used Account: 135-60150-010-000 Wholesale Water 923 01/31/2016 Jan A/P Wholesale Water/December 354,457.53 109,839.98 464,297.51 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 109,839.98 464,297.51 ** 2,948,742.00 Budgeted 2,484,444.49 Remaining 16 % 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 664 01/07/2016 PCards 11/28-12/28/15 DENTON SAND & GRAVEL, 570.49 72.00 642.49 DENTON SAND & GRAVEL, PC 664 01/07/2016 PCards 11/28-12/28/15 DENTON SAND & GRAVEL, 108.00 750.49 DENTON SAND & GRAVEL, PC 664 01/07/2016 PCards 11/28-12/28/15 DENTON SAND & GRAVEL, 108.00 858.49 DENTON SAND & GRAVEL, PC 860 01/26/2016 PCards 12/29/15-1/26/16 DENTON SAND & GRAVEL, 84.00 942.49 DENTON SAND & GRAVEL, PC 860 01/26/2016 PCards 12/29/15-1/26/16 DENTON SAND & GRAVEL, 84.00 1,026.49 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 456.00 1,026.49 ** 3,500.00 Budgeted 2,473.51 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 664 01/07/2016 PCards 11/28-12/28/15 7-ELEVEN 32921 3,487.69 52.35 3,540.04 7-ELEVEN 32921 PC 811 01/31/2016 Jan A/P Fuel purchases 12/25/15-1/24/1 1,032.57 4,572.61 US Bank Voyager Fleet Systems 1481 AP 811 01/31/2016 Jan A/P Water plant generator annual s 700.00 5,272.61 CANTWELL POWER SOLUTIONS 1459 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,784.92 5,272.61 ** 35,947.00 Budgeted 30,674.39 Remaining 15 % Used Account: 135-65010-010-000 Uniforms 664 01/07/2016 PCards 11/28-12/28/15 TRACTOR SUPPLY COMPANY 651.23 307.83 959.06 TRACTOR SUPPLY COMPANY PC 664 01/07/2016 PCards 11/28-12/28/15 TRACTOR SUPPLY COMPANY 11.45 970.51 TRACTOR SUPPLY COMPANY PC 664 01/07/2016 PCards 11/28-12/28/15 TRACTOR SUPPLY COMPANY 874.73 1,845.24 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 1,194.01 1,845.24 ** 4,608.00 Budgeted 2,762.76 Remaining 40 % Used Account: 135-65030-010-000 Chemicals 735 01/20/2016 Jan A/P Chemicals 3,136.06 100.74 3,236.80 HACH COMPANY 1425 AP 811 01/31/2016 Jan A/P Chlorine 741.59 3,978.39 DPC INDUSTRIES, INC 1461 AP 923 01/31/2016 Jan A/P Nitrate Test 196.24 4,174.63 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,038.57 4,174.63 ** 12,000.00 Budgeted 7,825.37 Remaining 35 % Used Account: 135-65035-010-000 Small Tools .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 664 01/07/2016 PCards 11/28-12/28/15 BOUND TREE MEDICAL LLC 187.99 187.99 BOUND TREE MEDICAL LLC PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 187.99 187.99 ** 1,000.00 Budgeted 812.01 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 18,805.34 .00 18,805.34 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 18,805.34 ** 115,000.00 Budgeted 96,194.66 Remaining 16 % Used Account: 135-65053-010-000 Meter Change Out Program 44,700.00 .00 44,700.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 44,700.00 ** 50,000.00 Budgeted 5,300.00 Remaining 89 % Used Account: 135-69005-010-000 Capital Outlays 697 01/13/2016 Jan A/P Balance due Transfer switch/wa 49,025.85 13,000.00 62,025.85 DHS AUTOMATION, INC 1375 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 13,000.00 62,025.85 ** 201,000.00 Budgeted 138,974.15 Remaining 31 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 130,720.00 Budgeted 130,720.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 1,209.00 Budgeted 1,209.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 575 01/01/2016 January A/P Annual tank inspection contrac 80,986.69 37,787.73 118,774.42 UTILITY SERVICE CO, INC. 1360 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 37,787.73 118,774.42 ** 126,958.00 Budgeted 8,183.58 Remaining 94 % Used Account: 135-55135-010-001 Lab Analysis for PID 923 01/31/2016 Jan A/P Water Samples-PID 240.00 80.00 320.00 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 320.00 ** 5,000.00 Budgeted 4,680.00 Remaining 6 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,007,915.23 ** 4,475,834.00 Budgeted 3,467,918.77 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 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 683 01/15/2016 PR 01-15-2016 Salaries & Wages 82,687.76 14,339.55 97,027.31 PR 765 01/29/2016 MUD Payroll 1/29/16 Salaries & Wages 14,220.46 111,247.77 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,560.01 111,247.77 ** 351,671.00 Budgeted 240,423.23 Remaining 32 % Used Account: 135-50010-020-000 Overtime 683 01/15/2016 PR 01-15-2016 Overtime 6,972.87 1,190.91 8,163.78 PR 765 01/29/2016 MUD Payroll 1/29/16 Overtime 1,373.00 9,536.78 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,563.91 9,536.78 ** 19,500.00 Budgeted 9,963.22 Remaining 49 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 765 01/29/2016 MUD Payroll 1/29/16 Certification 1,725.00 625.00 2,350.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 2,350.00 ** 7,200.00 Budgeted 4,850.00 Remaining 33 % Used Account: 135-50020-020-000 Retirement 683 01/15/2016 PR 01-15-2016 Retirement 8,688.20 1,355.81 10,044.01 PR 765 01/29/2016 MUD Payroll 1/29/16 Retirement 1,415.88 11,459.89 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,771.69 11,459.89 ** 33,652.00 Budgeted 22,192.11 Remaining 34 % Used Account: 135-50026-020-000 Medical Insurance 683 01/15/2016 PR 01-15-2016 Medical Insurance 14,136.81 2,765.99 16,902.80 PR 765 01/29/2016 MUD Payroll 1/29/16 Medical Insurance 2,765.98 19,668.78 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 19,668.78 ** 65,989.00 Budgeted 46,320.22 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 683 01/15/2016 PR 01-15-2016 Dental Insurance 814.62 173.97 988.59 PR 765 01/29/2016 MUD Payroll 1/29/16 Dental Insurance 173.94 1,162.53 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 1,162.53 ** 4,184.00 Budgeted 3,021.47 Remaining 28 % Used Account: 135-50028-020-000 Vision Insurance 683 01/15/2016 PR 01-15-2016 Vision Insurance 188.65 39.05 227.70 PR 765 01/29/2016 MUD Payroll 1/29/16 Vision Insurance 39.00 266.70 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 266.70 ** 972.00 Budgeted 705.30 Remaining 27 % Used Account: 135-50029-020-000 Life Insurance & Other 536 01/01/2016 January A/P January dental, vision & other 878.85 369.08 1,247.93 METLIFE GROUP BENEFITS 1325 AP 923 01/31/2016 Jan A/P Flex account admin fee 29.13 1,277.06 BenefitMall AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 398.21 1,277.06 ** 3,655.00 Budgeted 2,377.94 Remaining 35 % Used Account: 135-50030-020-000 Social Security Taxes 683 01/15/2016 PR 01-15-2016 Social Security Taxes 5,591.24 872.79 6,464.03 PR 765 01/29/2016 MUD Payroll 1/29/16 Social Security Taxes 905.46 7,369.49 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,778.25 7,369.49 ** 24,665.00 Budgeted 17,295.51 Remaining 30 % Used Account: 135-50035-020-000 Medicare Taxes 683 01/15/2016 PR 01-15-2016 Medicare Taxes 1,307.60 204.11 1,511.71 PR 765 01/29/2016 MUD Payroll 1/29/16 Medicare Taxes 211.76 1,723.47 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 415.87 1,723.47 ** 5,768.00 Budgeted 4,044.53 Remaining 30 % Used Account: 135-50040-020-000 Unemployment Taxes 683 01/15/2016 PR 01-15-2016 Unemployment Taxes 6.57 15.54 22.11 PR 765 01/29/2016 MUD Payroll 1/29/16 Unemployment Taxes 16.19 38.30 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 31.73 38.30 ** 1,449.00 Budgeted 1,410.70 Remaining 3 % Used Account: 135-50045-020-000 Workman's Compensation 135 01/01/2016 Prepaid Insurance, W/C Jan 2,329.30 776.43 3,105.73 GL 863 01/12/2016 TML FY2015 W/C Audit refund (2,314.50) 791.23 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: (1,538.07) 791.23 ** 9,317.00 Budgeted 8,525.77 Remaining 8 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 650.00 Budgeted 650.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 12,845.75 6.46 12,852.21 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 AUTOZONE #4206 25.00 12,877.21 AUTOZONE #4206 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 89.06 12,966.27 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 BEST BUY 00001487 44.99 13,011.26 BEST BUY 00001487 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 111.75 13,123.01 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 63.97 13,186.98 THE HOME DEPOT 6581 PC 664 01/07/2016 PCards 11/28-12/28/15 BEST BUY 00001487 119.98 13,306.96 BEST BUY 00001487 PC 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 111.99 13,418.95 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 664 01/07/2016 PCards 11/28-12/28/15 THE HOME DEPOT 6581 12,845.75 39.86 13,458.81 THE HOME DEPOT 6581 PC 735 01/20/2016 Jan A/P replace rails Lift station 3 665.00 14,123.81 NORTH TEXAS PUMP CO. 1434 AP 737 01/21/2016 Jan A/P Fire extinguisher inspections 78.50 14,202.31 KIMBROUGH FIRE EXTINQUISHER CO 1428 AP 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 147.48 14,349.79 THE HOME DEPOT 6581 PC 860 01/26/2016 PCards 12/29/15-1/26/16 Tier II WW 50.00 14,399.79 TCEQ EPAYMENT PC 860 01/26/2016 PCards 12/29/15-1/26/16 BEST BUY 00001487 (44.99) 14,354.80 BEST BUY 00001487 PC 860 01/26/2016 PCards 12/29/15-1/26/16 THE HOME DEPOT 6581 11.95 14,366.75 THE HOME DEPOT 6581 PC 811 01/31/2016 Jan A/P Maintenance/Calibration WWTP m 1,453.50 15,820.25 Prime Controls, LP 1475 AP 923 01/31/2016 Jan A/P Back flow valve 224.64 16,044.89 HD SUPPLY WATERWORKS, LTD. AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,199.14 16,044.89 ** 72,600.00 Budgeted 56,555.11 Remaining 22 % Used Account: 135-55090-020-000 Vehicle Maintenance 664 01/07/2016 PCards 11/28-12/28/15 DC AUTO 145.88 240.00 385.88 DC AUTO PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 240.00 385.88 ** 5,000.00 Budgeted 4,614.12 Remaining 8 % 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 811 01/31/2016 Jan A/P Sludge haul off 5,832.20 812.05 6,644.25 L.H. CHANEY MATERIALS, INC. 1468 AP 811 01/31/2016 Jan A/P Sludge haul off 1,712.39 8,356.64 L.H. CHANEY MATERIALS, INC. 1468 AP 923 01/31/2016 Jan A/P Sludge haul off 836.97 9,193.61 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,361.41 9,193.61 ** 55,000.00 Budgeted 45,806.39 Remaining 17 % Used Account: 135-55135-020-000 Lab Analysis 735 01/20/2016 Jan A/P Lab analysis 7,984.00 246.00 8,230.00 OXIDOR LABORATORIES LLC 1436 AP 735 01/20/2016 Jan A/P Lab analysis 176.00 8,406.00 OXIDOR LABORATORIES LLC 1436 AP 735 01/20/2016 Jan A/P Lab analysis 246.00 8,652.00 OXIDOR LABORATORIES LLC 1436 AP 735 01/20/2016 Jan A/P Lab analysis 176.00 8,828.00 OXIDOR LABORATORIES LLC 1436 AP 735 01/20/2016 Jan A/P Lab analysis 246.00 9,074.00 OXIDOR LABORATORIES LLC 1436 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 811 01/31/2016 Jan A/P Testing 7,984.00 176.00 9,250.00 OXIDOR LABORATORIES LLC 1474 AP 811 01/31/2016 Jan A/P Testing 246.00 9,496.00 OXIDOR LABORATORIES LLC 1474 AP 811 01/31/2016 Jan A/P Testing 176.00 9,672.00 OXIDOR LABORATORIES LLC 1474 AP 923 01/31/2016 Jan A/P Testing 176.00 9,848.00 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,864.00 9,848.00 ** 35,000.00 Budgeted 25,152.00 Remaining 28 % Used Account: 135-60010-020-000 Communications/Mobiles 697 01/13/2016 Jan A/P PID Inverted Syphon alarm moni 1,578.81 276.00 1,854.81 OMNISITE 1399 AP 811 01/31/2016 Jan A/P Splashtop, Wireless USB adapto 56.60 1,911.41 M3 Networks 1471 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 332.60 1,911.41 ** 5,400.00 Budgeted 3,488.59 Remaining 35 % Used Account: 135-60020-020-000 Electricity 699 01/13/2016 Jan A/P Electricity 12/9/15-1/9/16 24,134.85 62.37 24,197.22 HUDSON ENERGY SERVICES, LLC 1385 AP 699 01/13/2016 Jan A/P Electricity 12/9/15-1/9/16 55.24 24,252.46 HUDSON ENERGY SERVICES, LLC 1385 AP 699 01/13/2016 Jan A/P Electricity 12/10/15-1/11/16 109.33 24,361.79 HUDSON ENERGY SERVICES, LLC 1385 AP 735 01/20/2016 Jan A/P Electricity 12/10-1/11/16 543.55 24,905.34 HUDSON ENERGY SERVICES, LLC 1426 AP 735 01/20/2016 Jan A/P Electricity 12/10-1/11/16 10,721.06 35,626.40 HUDSON ENERGY SERVICES, LLC 1426 AP 811 01/31/2016 Jan A/P Elecricity 12/10/15-1/11/16 291.45 35,917.85 MP2 ENERGY TEXAS LLC 1472 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (491.51) 35,426.34 AR 923 01/31/2016 Jan A/P Elec 12/29-1/27/16 173.55 35,599.89 TRI COUNTY ELECTRIC AP 923 01/31/2016 Jan A/P Elec 12/29-1/27/16 27.69 35,627.58 TRI COUNTY ELECTRIC AP 923 01/31/2016 Jan A/P Elec 12/29-1/27/16 280.68 35,908.26 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,773.41 35,908.26 ** 161,582.00 Budgeted 125,673.74 Remaining 22 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 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-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 735 01/20/2016 Jan A/P Travel Advance/Membranes Bas 325.00 325.00 LANCE HOLT 1429 AP 860 01/26/2016 PCards 12/29/15-1/26/16 AMER. MEMBRANE TECH. A 505.00 830.00 AMER. MEMBRANE TECH. A PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 830.00 830.00 ** 3,771.00 Budgeted 2,941.00 Remaining 22 % Used Account: 135-60090-020-000 Safety Program 664 01/07/2016 PCards 11/28-12/28/15 BASS PRO SHOPS 39.00 153.79 192.79 BASS PRO SHOPS PC _______________ Account: 135-60090-020-000 Safety Program Totals: 153.79 192.79 ** 550.00 Budgeted 357.21 Remaining 35 % Used Account: 135-60100-020-000 Travel & per diem 860 01/26/2016 PCards 12/29/15-1/26/16 HOTEL*BOULEVARDS.COM 767.28 767.28 HOTEL*BOULEVARDS.COM PC 868 01/29/2016 K Schelig/Reimb PCard (6.00) 761.28 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 761.28 761.28 ** 1,600.00 Budgeted 838.72 Remaining 48 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,439.28 .00 9,439.28 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,439.28 ** 37,150.00 Budgeted 27,710.72 Remaining 25 % Used Account: 135-60245-020-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 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-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 297.00 Budgeted 297.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-60331-020-000 Interfund Transfer Out-Tax I&S .00 .00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 119,706.00 Budgeted 119,706.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 444,831.00 Budgeted 444,831.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 61,668.00 .00 61,668.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % Used Account: 135-65005-020-000 Fuel & Lube 735 01/20/2016 Jan A/P Generator repair WWTP 1,987.09 400.00 2,387.09 CANTWELL POWER SOLUTIONS 1421 AP 811 01/31/2016 Jan A/P Fuel purchases 12/25/15-1/24/1 682.62 3,069.71 US Bank Voyager Fleet Systems 1481 AP 811 01/31/2016 Jan A/P WW plant generator maintenance 1,750.00 4,819.71 CANTWELL POWER SOLUTIONS 1459 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 2,832.62 4,819.71 ** 32,021.00 Budgeted 27,201.29 Remaining 15 % Used Account: 135-65010-020-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 664 01/07/2016 PCards 11/28-12/28/15 GRAPEVINE KAWASAKI 2,207.76 119.83 2,327.59 GRAPEVINE KAWASAKI PC 664 01/07/2016 PCards 11/28-12/28/15 LEVIS OUTLET 322 119.97 2,447.56 LEVIS OUTLET 322 PC 664 01/07/2016 PCards 11/28-12/28/15 ACADEMY SPORTS #141 35.98 2,483.54 ACADEMY SPORTS #141 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 275.78 2,483.54 ** 4,241.00 Budgeted 1,757.46 Remaining 59 % Used Account: 135-65030-020-000 Chemicals 697 01/13/2016 Jan A/P Freestyle Calc Hypochlorite 8,408.42 2,249.85 10,658.27 HARCROS CHEMICALS INC 1384 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,249.85 10,658.27 ** 27,000.00 Budgeted 16,341.73 Remaining 39 % Used Account: 135-65035-020-000 Small Tools 664 01/07/2016 PCards 11/28-12/28/15 WW GRAINGER 50.40 50.40 WW GRAINGER PC _______________ Account: 135-65035-020-000 Small Tools Totals: 50.40 50.40 ** 2,000.00 Budgeted 1,949.60 Remaining 3 % Used Account: 135-65040-020-000 Safety Equipment 811 01/31/2016 Jan A/P Nitrite gloves 414.59 162.00 576.59 LOU'S GLOVES INCORPORATED 1470 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 162.00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used Account: 135-65045-020-000 Lab Supplies 664 01/07/2016 PCards 11/28-12/28/15 CAPITOL SCIENTIFIC, IN 3,255.21 287.83 3,543.04 CAPITOL SCIENTIFIC, IN PC 664 01/07/2016 PCards 11/28-12/28/15 WM SUPERCENTER #266 5.94 3,548.98 WM SUPERCENTER #266 PC 735 01/20/2016 Jan A/P Coliform 171.21 3,720.19 IDEXX DISTRIBUTION, INC 1427 AP 860 01/26/2016 PCards 12/29/15-1/26/16 HACH COMPANY 471.65 4,191.84 HACH COMPANY PC 923 01/31/2016 Jan A/P Quanti trays 633.47 4,825.31 IDEXX DISTRIBUTION, INC AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,570.10 4,825.31 ** 13,000.00 Budgeted 8,174.69 Remaining 37 % Used Account: 135-69005-020-000 Capital Outlays 821 01/31/2016 Move Fence Advertising Move Fence Advertising 23,604.83 593.92 24,198.75 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2016 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 Outlays Totals: 593.92 24,198.75 ** 150,000.00 Budgeted 125,801.25 Remaining 16 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 21,280.00 Budgeted 21,280.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 ** 197.00 Budgeted 197.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 367,051.42 ** 1,912,109.00 Budgeted 1,545,057.58 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2016 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 765 01/29/2016 MUD Payroll 1/29/16 Salaries & Wages 1,500.00 600.00 2,100.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 600.00 2,100.00 ** 12,500.00 Budgeted 10,400.00 Remaining 17 % Used Account: 135-50030-026-000 Social Security Taxes 765 01/29/2016 MUD Payroll 1/29/16 Social Security Taxes 93.00 37.20 130.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 37.20 130.20 ** 775.00 Budgeted 644.80 Remaining 17 % Used Account: 135-50035-026-000 Medicare Taxes 765 01/29/2016 MUD Payroll 1/29/16 Medicare Taxes 21.75 8.70 30.45 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 8.70 30.45 ** 181.00 Budgeted 150.55 Remaining 17 % Used Account: 135-50040-026-000 Unemployment Taxes 765 01/29/2016 MUD Payroll 1/29/16 Unemployment Taxes 1.50 .60 2.10 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .60 2.10 ** 230.00 Budgeted 227.90 Remaining 1 % Used Account: 135-50045-026-000 Workman's Compensation 135 01/01/2016 Prepaid Insurance, W/C Jan 9.25 3.08 12.33 GL 863 01/12/2016 TML FY2015 W/C Audit refund 13.00 25.33 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 16.08 25.33 ** 37.00 Budgeted 11.67 Remaining 68 % 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 Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2016 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-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 6.00 .00 6.00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 6.00 ** 1,200.00 Budgeted 1,194.00 Remaining 1 % Used Account: 135-60080-026-000 Schools & Training 550.00 .00 550.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 550.00 ** 4,000.00 Budgeted 3,450.00 Remaining 14 % Used Account: 135-60100-026-000 Travel & per diem 794 01/29/2016 Jan A/P AWBD Expenses 718.54 718.54 KEVIN CARR 1455 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 718.54 718.54 ** 5,000.00 Budgeted 4,281.46 Remaining 14 % Used Account: 135-60245-026-000 Miscellaneous Expenses 50.48 .00 50.48 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 3,613.10 ** 26,573.00 Budgeted 22,959.90 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 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 683 01/15/2016 PR 01-15-2016 Salaries & Wages 115,487.11 18,643.00 134,130.11 PR 765 01/29/2016 MUD Payroll 1/29/16 Salaries & Wages 18,636.79 152,766.90 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,279.79 152,766.90 ** 488,508.00 Budgeted 335,741.10 Remaining 31 % Used Account: 135-50010-030-000 Overtime 683 01/15/2016 PR 01-15-2016 Overtime 79.69 23.07 102.76 PR 765 01/29/2016 MUD Payroll 1/29/16 Overtime 7.86 110.62 PR _______________ Account: 135-50010-030-000 Overtime Totals: 30.93 110.62 ** 1,000.00 Budgeted 889.38 Remaining 11 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 683 01/15/2016 PR 01-15-2016 Retirement 10,637.63 1,629.54 12,267.17 PR 765 01/29/2016 MUD Payroll 1/29/16 Retirement 1,627.69 13,894.86 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,257.23 13,894.86 ** 43,202.00 Budgeted 29,307.14 Remaining 32 % Used Account: 135-50026-030-000 Medical Insurance 683 01/15/2016 PR 01-15-2016 Medical Insurance 14,663.63 2,655.37 17,319.00 PR 765 01/29/2016 MUD Payroll 1/29/16 Medical Insurance 2,655.35 19,974.35 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,310.72 19,974.35 ** 68,196.00 Budgeted 48,221.65 Remaining 29 % Used Account: 135-50027-030-000 Dental Insurance 683 01/15/2016 PR 01-15-2016 Dental Insurance 947.83 189.41 1,137.24 PR 765 01/29/2016 MUD Payroll 1/29/16 Dental Insurance 189.38 1,326.62 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 378.79 1,326.62 ** 4,807.00 Budgeted 3,480.38 Remaining 28 % Used Account: 135-50028-030-000 Vision Insurance 683 01/15/2016 PR 01-15-2016 Vision Insurance 219.63 43.60 263.23 PR 765 01/29/2016 MUD Payroll 1/29/16 Vision Insurance 43.54 306.77 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 87.14 306.77 ** 1,114.00 Budgeted 807.23 Remaining 28 % Used Account: 135-50029-030-000 Life Insurance & Other 536 01/01/2016 January A/P January dental, vision & other 1,144.08 363.39 1,507.47 METLIFE GROUP BENEFITS 1325 AP 923 01/31/2016 Jan A/P Flex account admin fee 29.16 1,536.63 BenefitMall AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 392.55 1,536.63 ** 4,431.00 Budgeted 2,894.37 Remaining 35 % Used Account: 135-50030-030-000 Social Security Taxes 683 01/15/2016 PR 01-15-2016 Social Security Taxes 6,985.05 1,070.35 8,055.40 PR 765 01/29/2016 MUD Payroll 1/29/16 Social Security Taxes 1,068.54 9,123.94 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,138.89 9,123.94 ** 30,823.00 Budgeted 21,699.06 Remaining 30 % Used Account: 135-50035-030-000 Medicare Taxes 683 01/15/2016 PR 01-15-2016 Medicare Taxes 1,633.59 250.33 1,883.92 PR 765 01/29/2016 MUD Payroll 1/29/16 Medicare Taxes 249.89 2,133.81 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 500.22 2,133.81 ** 7,599.00 Budgeted 5,465.19 Remaining 28 % Used Account: 135-50040-030-000 Unemployment Taxes 683 01/15/2016 PR 01-15-2016 Unemployment Taxes 18.67 18.67 PR 765 01/29/2016 MUD Payroll 1/29/16 Unemployment Taxes 18.52 37.19 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 37.19 37.19 ** 1,449.00 Budgeted 1,411.81 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 135 01/01/2016 Prepaid Insurance, W/C Jan 443.67 147.89 591.56 GL 863 01/12/2016 TML FY2015 W/C Audit refund 292.00 883.56 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 439.89 883.56 ** 1,554.00 Budgeted 670.44 Remaining 57 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 664 01/07/2016 PCards 11/28-12/28/15 WAL-MART #5247 1,347.55 (75.81) 1,271.74 WAL-MART #5247 PC 664 01/07/2016 PCards 11/28-12/28/15 WAL-MART #5247 115.67 1,387.41 WAL-MART #5247 PC 664 01/07/2016 PCards 11/28-12/28/15 RANDALLS STORE00017897 950.00 2,337.41 RANDALLS STORE00017897 PC 664 01/07/2016 PCards 11/28-12/28/15 RANDALLS STORE00017897 350.00 2,687.41 RANDALLS STORE00017897 PC 664 01/07/2016 PCards 11/28-12/28/15 HOBBY-LOBBY #256 122.79 2,810.20 HOBBY-LOBBY #256 PC 664 01/07/2016 PCards 11/28-12/28/15 WM SUPERCENTER #266 50.36 2,860.56 WM SUPERCENTER #266 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,513.01 2,860.56 ** 5,000.00 Budgeted 2,139.44 Remaining 57 % Used Account: 135-55030-030-000 Software & Support 664 01/07/2016 PCards 11/28-12/28/15 ATT*BILL PAYMENT 6,193.72 166.27 6,359.99 ATT*BILL PAYMENT PC 664 01/07/2016 PCards 11/28-12/28/15 ATT*BILL PAYMENT 149.97 6,509.96 ATT*BILL PAYMENT PC 664 01/07/2016 PCards 11/28-12/28/15 ADOBE *PHOTOGPHY PLAN 129.77 6,639.73 ADOBE *PHOTOGPHY PLAN PC 697 01/13/2016 Jan A/P Internet 1,101.17 7,740.90 WHOLESALE CARRIER SERVICES INC 1420 AP 735 01/20/2016 Jan A/P Support thru 11/30/15 742.80 8,483.70 STW INC 1440 AP 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BILL PAYMENT 166.27 8,649.97 ATT*BILL PAYMENT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BILL PAYMENT 149.97 8,799.94 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,606.22 8,799.94 ** 78,483.00 Budgeted 69,683.06 Remaining 11 % Used Account: 135-55070-030-000 Independent Labor 737 01/21/2016 Jan A/P Record MUD meeting 12/16 12,825.73 97.50 12,923.23 MIGUEL CRUZ 1433 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 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: 97.50 12,923.23 ** 12,000.00 Budgeted (923.23) Remaining 108 % Used Account: 135-55080-030-000 Maintenance & Repairs 7,724.66 .00 7,724.66 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 7,724.66 ** 29,500.00 Budgeted 21,775.34 Remaining 26 % Used Account: 135-55100-030-000 Building Maint & Supplies 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 867.67 87.50 955.17 TOWN OF TROPHY CLUB 1443 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (130.89) 824.28 AR 923 01/31/2016 Jan A/P Rug Service 130.89 955.17 G & K SERVICES AP 923 01/31/2016 Jan A/P Rug Service 130.89 1,086.06 G & K SERVICES AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 218.39 1,086.06 ** 7,000.00 Budgeted 5,913.94 Remaining 16 % Used Account: 135-55120-030-000 Cleaning Services 735 01/20/2016 Jan A/P December janitorial service 910.50 843.75 1,754.25 MEMBER'S BUILDING MAINTENANCE 1431 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (259.00) 1,495.25 AR 923 01/31/2016 Jan A/P Janitorial Service/January 843.75 2,339.00 MEMBER'S BUILDING MAINTENANCE AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,428.50 2,339.00 ** 10,125.00 Budgeted 7,786.00 Remaining 23 % Used Account: 135-55160-030-000 Professional Outside Services 51,570.00 .00 51,570.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 51,570.00 ** 61,075.00 Budgeted 9,505.00 Remaining 84 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 923 01/31/2016 Jan A/P 1,886.75 654.12 2,540.87 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 654.12 2,540.87 ** 8,200.00 Budgeted 5,659.13 Remaining 31 % Used Account: 135-60005-030-000 Telephone 664 01/07/2016 PCards 11/28-12/28/15 ATT*BUS PHONE PMT 2,875.91 440.76 3,316.67 ATT*BUS PHONE PMT PC 673 01/10/2016 Jan A/P Answering Service 199.30 3,515.97 KEYSTONE PARK SECRETARIAL 1389 AP 860 01/26/2016 PCards 12/29/15-1/26/16 RINGCENTRAL, INC 9.99 3,525.96 RINGCENTRAL, INC PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BUS PHONE PMT 830.77 4,356.73 ATT*BUS PHONE PMT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BUS PHONE PMT 838.98 5,195.71 ATT*BUS PHONE PMT PC 860 01/26/2016 PCards 12/29/15-1/26/16 ATT*BUS PHONE PMT 442.81 5,638.52 ATT*BUS PHONE PMT PC 811 01/31/2016 Jan A/P Answering service 194.68 5,833.20 KEYSTONE PARK SECRETARIAL 1466 AP 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: (896.12) 4,937.08 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,061.17 4,937.08 ** 16,349.00 Budgeted 11,411.92 Remaining 30 % Used Account: 135-60010-030-000 Communications/Mobiles 765 01/29/2016 MUD Payroll 1/29/16 Communications/Mobiles 1,051.96 300.00 1,351.96 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 300.00 1,351.96 ** 4,150.00 Budgeted 2,798.04 Remaining 33 % Used Account: 135-60020-030-000 Electricity/Gas 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 814.79 746.10 1,560.89 TOWN OF TROPHY CLUB 1443 AP 735 01/20/2016 Jan A/P Gexa,Charter,Verizon,Carenow,E 914.23 2,475.12 TOWN OF TROPHY CLUB 1443 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,660.33 2,475.12 ** 10,768.00 Budgeted 8,292.88 Remaining 23 % Used Account: 135-60025-030-000 Water 918 01/31/2016 Bill Town Inv 1405-1415 AR 20160131-20160131 User: 246.24 (60.49) 185.75 AR 923 01/31/2016 Jan A/P January water 120.98 306.73 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 135-60025-030-000 Water Totals: 60.49 306.73 ** 1,500.00 Budgeted 1,193.27 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 735 01/20/2016 Jan A/P Postage for meter 6,081.65 1,000.00 7,081.65 U.S. Postal Service (CMRS-FP) 1445 AP 735 01/20/2016 Jan A/P Overnight letters 11.10 7,092.75 FEDERAL EXPRESS CORP 1423 AP 811 01/31/2016 Jan A/P Overnight letter 6.48 7,099.23 FEDERAL EXPRESS CORP 1462 AP 811 01/31/2016 Jan A/P Overnight letter 4.21 7,103.44 FEDERAL EXPRESS CORP 1462 AP 811 01/31/2016 Jan A/P 2015 Audit to TCEQ 5.55 7,108.99 FEDERAL EXPRESS CORP 1462 AP 923 01/31/2016 Jan A/P Overnight letters 10.79 7,119.78 FEDERAL EXPRESS CORP AP 923 01/31/2016 Jan A/P 1,804.28 8,924.06 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 2,842.41 8,924.06 ** 28,932.00 Budgeted 20,007.94 Remaining 31 % Used Account: 135-60040-030-000 Service Charges & Fees 816 01/05/2016 Credit Card fees 18,327.72 68.75 18,396.47 GL 816 01/05/2016 Credit Card fees 4,085.76 22,482.23 GL 664 01/07/2016 PCards 11/28-12/28/15 600.00 23,082.23 PC 685 01/15/2016 Child support fee 1.50 23,083.73 GL 764 01/15/2016 Bank Analysis Fee- December 58.87 23,142.60 GL 877 01/29/2016 Child support fee 1/29/16 P/R 1.50 23,144.10 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,816.38 23,144.10 ** 44,000.00 Budgeted 20,855.90 Remaining 53 % Used Account: 135-60050-030-000 Bad Debt Expense 808 01/04/2016 UB 1/4/16 Write offs UB20160104-20160104 User: 3,216.78 3,216.78 UB 823 01/04/2016 UB 1/4/16 Write offs UB20160104-20160104 User: 1,075.05 4,291.83 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 4,291.83 4,291.83 ** 3,500.00 Budgeted (791.83) Remaining 123 % Used Account: 135-60055-030-000 Insurance 135 01/01/2016 Prepaid Insurance, W/C Jan 8,368.00 2,756.00 11,124.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 11,124.00 ** 52,797.00 Budgeted 41,673.00 Remaining 21 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 4,896.25 .00 4,896.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,896.25 ** 6,000.00 Budgeted 1,103.75 Remaining 82 % Used Account: 135-60075-030-000 Meetings 860 01/26/2016 PCards 12/29/15-1/26/16 GERIK'S OLE CZECH 29.00 29.00 GERIK'S OLE CZECH PC _______________ Account: 135-60075-030-000 Meetings Totals: 29.00 29.00 ** 400.00 Budgeted 371.00 Remaining 7 % Used Account: 135-60079-030-000 Public Education 860 01/26/2016 PCards 12/29/15-1/26/16 LETS JUMP 187.65 394.00 581.65 LETS JUMP PC _______________ Account: 135-60079-030-000 Public Education Totals: 394.00 581.65 ** 5,000.00 Budgeted 4,418.35 Remaining 12 % Used Account: 135-60080-030-000 Schools & Training 664 01/07/2016 PCards 11/28-12/28/15 FREDPRYOR CAREERTRACK 459.00 298.00 757.00 FREDPRYOR CAREERTRACK PC 664 01/07/2016 PCards 11/28-12/28/15 WEBUCATOR 975.00 1,732.00 WEBUCATOR PC 860 01/26/2016 PCards 12/29/15-1/26/16 TRWA 00 OF 00 125.00 1,857.00 TRWA 00 OF 00 PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 1,398.00 1,857.00 ** 9,935.00 Budgeted 8,078.00 Remaining 19 % Used Account: 135-60100-030-000 Travel & per diem 664 01/07/2016 PCards 11/28-12/28/15 RINGCENTRAL, INC 730.02 9.99 740.01 RINGCENTRAL, INC PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 465.75 1,205.76 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 2.71 1,208.47 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 2.71 1,211.18 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 KERBEY LANE CAFE-RR 12.28 1,223.46 KERBEY LANE CAFE-RR PC 664 01/07/2016 PCards 11/28-12/28/15 HYDE PARK BAR & GRILL 19.60 1,243.06 HYDE PARK BAR & GRILL PC 664 01/07/2016 PCards 11/28-12/28/15 BRIO AUSTIN 12.55 1,255.61 BRIO AUSTIN PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 664 01/07/2016 PCards 11/28-12/28/15 STARBUCKS #11075 ROUND 730.02 4.06 1,259.67 STARBUCKS #11075 ROUND PC 664 01/07/2016 PCards 11/28-12/28/15 CORNER BAKERY 9.52 1,269.19 CORNER BAKERY PC 664 01/07/2016 PCards 11/28-12/28/15 STARBUCKS #14860 GEORG 4.06 1,273.25 STARBUCKS #14860 GEORG PC 664 01/07/2016 PCards 11/28-12/28/15 BRAUMS #51 4.75 1,278.00 BRAUMS #51 PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 465.75 1,743.75 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 KERBEY LANE CAFE-RR 16.02 1,759.77 KERBEY LANE CAFE-RR PC 664 01/07/2016 PCards 11/28-12/28/15 HYDE PARK BAR & GRILL 16.62 1,776.39 HYDE PARK BAR & GRILL PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 2.98 1,779.37 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 RENAISSANCE HOTELS 2.71 1,782.08 RENAISSANCE HOTELS PC 664 01/07/2016 PCards 11/28-12/28/15 BRIO AUSTIN 15.74 1,797.82 BRIO AUSTIN PC 664 01/07/2016 PCards 11/28-12/28/15 CORNER BAKERY 9.52 1,807.34 CORNER BAKERY PC 664 01/07/2016 PCards 11/28-12/28/15 BRAUMS #51 6.27 1,813.61 BRAUMS #51 PC 683 01/15/2016 PR 01-15-2016 Travel & per diem 25.13 1,838.74 PR 860 01/26/2016 PCards 12/29/15-1/26/16 SOUTH CONGRESS CAFE 34.77 1,873.51 SOUTH CONGRESS CAFE PC 860 01/26/2016 PCards 12/29/15-1/26/16 STARBUCKS #02832 HILLS 4.82 1,878.33 STARBUCKS #02832 HILLS PC 860 01/26/2016 PCards 12/29/15-1/26/16 TX HISTORY MUSEUM PARK 8.00 1,886.33 TX HISTORY MUSEUM PARK PC 860 01/26/2016 PCards 12/29/15-1/26/16 STARBUCKS #02832 HILLS 2.00 1,888.33 STARBUCKS #02832 HILLS PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 1,158.31 1,888.33 ** 5,400.00 Budgeted 3,511.67 Remaining 35 % 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 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 735 01/20/2016 Jan A/P Bid for Solana Campus Circle w 675.36 660.68 1,336.04 STAR-TELEGRAM OPERATING LTD 1439 AP 735 01/20/2016 Jan A/P 9/16/15 billed/paid twice for (613.62) 722.42 STAR-TELEGRAM OPERATING LTD 1439 AP 755 01/25/2016 Bre Solana, Inv 1402 billed AR 20160125-20160125 User: (660.68) 61.74 AR 866 01/27/2016 Star Tel/Refund dupe pmt (613.62) (551.88) GL 811 01/31/2016 Jan A/P Bid for Fence at Lift Sta. 6 & 593.92 42.04 STAR-TELEGRAM OPERATING LTD 1477 AP 811 01/31/2016 Jan A/P Refunded from Star/after we to 613.62 655.66 STAR-TELEGRAM OPERATING LTD 1477 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 821 01/31/2016 Move Fence Advertising Move Fence Advertising 675.36 (593.92) 61.74 GL _______________ Account: 135-60125-030-000 Advertising Totals: (613.62) 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 860 01/26/2016 PCards 12/29/15-1/26/16 VCN*DENTONRECCTR 422.98 56.00 478.98 VCN*DENTONRECCTR PC 860 01/26/2016 PCards 12/29/15-1/26/16 TEXAS SECRETARY OF STA 21.00 499.98 TEXAS SECRETARY OF STA PC 860 01/26/2016 PCards 12/29/15-1/26/16 TEXAS SECRETARY OF STA 21.00 520.98 TEXAS SECRETARY OF STA PC 860 01/26/2016 PCards 12/29/15-1/26/16 AEC TECHNOLOGY 1,995.00 2,515.98 AEC TECHNOLOGY PC 811 01/31/2016 Jan A/P Install Tomar Ingress System 1,600.00 4,115.98 Alan's Gates, Inc. 1456 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 3,693.00 4,115.98 ** 17,501.00 Budgeted 13,385.02 Remaining 24 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 735 01/20/2016 Jan A/P Laptop docking stations 656.38 656.38 M3 Networks 1430 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 656.38 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms 860 01/26/2016 PCards 12/29/15-1/26/16 WM SUPERCENTER #5247 23.00 23.00 WM SUPERCENTER #5247 PC _______________ Account: 135-65010-030-000 Uniforms Totals: 23.00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 5,871.85 .00 5,871.85 _______________ Account: 135-65055-030-000 Hardware Totals: .00 5,871.85 ** 29,594.00 Budgeted 23,722.15 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-030-000 Office Supplies 664 01/07/2016 PCards 11/28-12/28/15 CANVA.COM 1,340.71 1.00 1,341.71 CANVA.COM PC 664 01/07/2016 PCards 11/28-12/28/15 AMAZON.COM 20.38 1,362.09 AMAZON.COM PC 664 01/07/2016 PCards 11/28-12/28/15 AMAZON.COM 22.01 1,384.10 AMAZON.COM PC 664 01/07/2016 PCards 11/28-12/28/15 CARBONLESS FORMS PRINT 178.00 1,562.10 CARBONLESS FORMS PRINT PC 664 01/07/2016 PCards 11/28-12/28/15 CHURCH PAPER INC 57.58 1,619.68 CHURCH PAPER INC PC 860 01/26/2016 PCards 12/29/15-1/26/16 STAPLES 00116533 35.99 1,655.67 STAPLES 00116533 PC 860 01/26/2016 PCards 12/29/15-1/26/16 STAPLES 00116533 108.45 1,764.12 STAPLES 00116533 PC 860 01/26/2016 PCards 12/29/15-1/26/16 CANVA.COM 1.00 1,765.12 CANVA.COM PC 860 01/26/2016 PCards 12/29/15-1/26/16 ADOBE (9.89) 1,755.23 ADOBE PC 811 01/31/2016 Jan A/P Office Supplies 69.16 1,824.39 OFFICE DEPOT, INC 1473 AP 811 01/31/2016 Jan A/P Office Supplies 50.02 1,874.41 OFFICE DEPOT, INC 1473 AP 923 01/31/2016 Jan A/P Office Supplies 94.39 1,968.80 OFFICE DEPOT, INC AP 923 01/31/2016 Jan A/P Office Supplies 9.39 1,978.19 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 637.48 1,978.19 ** 9,000.00 Budgeted 7,021.81 Remaining 22 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 221.30 .00 221.30 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 221.30 ** 4,003.00 Budgeted 3,781.70 Remaining 6 % Used Account: 135-65095-030-000 Maintenance Supplies 664 01/07/2016 PCards 11/28-12/28/15 SAMS CLUB #4795 1,020.41 25.73 1,046.14 SAMS CLUB #4795 PC 664 01/07/2016 PCards 11/28-12/28/15 WM SUPERCENTER #266 14.88 1,061.02 WM SUPERCENTER #266 PC 860 01/26/2016 PCards 12/29/15-1/26/16 SAMS CLUB #4795 255.45 1,316.47 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 296.06 1,316.47 ** 5,000.00 Budgeted 3,683.53 Remaining 26 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 735 01/20/2016 Jan A/P Restroom renovations/Engineeri 1,427.50 1,427.50 THE WALLACE GROUP, INC. 1442 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 1,427.50 1,427.50 ** 56,000.00 Budgeted 54,572.50 Remaining 3 % Used Account: 135-69170-030-000 Copier Lease Installments 697 01/13/2016 Jan A/P 762.34 165.00 927.34 EVERBANK COMMERCIAL FINANCE 1379 AP 811 01/31/2016 Jan A/P Copier 216.33 1,143.67 KYOCERA DOCUMENT SOLUTIONS 1467 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 381.33 1,143.67 ** 4,600.00 Budgeted 3,456.33 Remaining 25 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 378,385.26 ** 1,210,323.00 Budgeted 831,937.74 Remaining 31 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2016 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 811 01/31/2016 Jan A/P WWTP Encroachment Agreement 94,864.49 30.00 94,894.49 THE LISTON LAW FIRM, P.C. 1479 AP 811 01/31/2016 Jan A/P General 3,226.95 98,121.44 THE LISTON LAW FIRM, P.C. 1479 AP 811 01/31/2016 Jan A/P PUC 540.00 98,661.44 THE LISTON LAW FIRM, P.C. 1479 AP 811 01/31/2016 Jan A/P Solana Waterline 120.00 98,781.44 THE LISTON LAW FIRM, P.C. 1479 AP 811 01/31/2016 Jan A/P WWTP-WCP Contract 1,050.00 99,831.44 THE LISTON LAW FIRM, P.C. 1479 AP 923 01/31/2016 Jan A/P Legal/January 390.00 100,221.44 FREEMAN & CORBETT AP 923 01/31/2016 Jan A/P Legal Fees/PUC 2,250.00 102,471.44 FREEMAN & CORBETT AP _______________ Account: 135-55045-039-000 Legal Totals: 7,606.95 102,471.44 ** 386,130.00 Budgeted 283,658.56 Remaining 27 % Used Account: 135-55055-039-000 Auditing 811 01/31/2016 Jan A/P Audit 16,245.50 7,793.88 24,039.38 LAFOLLETT & ABBOTT PLLC 1469 AP _______________ Account: 135-55055-039-000 Auditing Totals: 7,793.88 24,039.38 ** 22,750.00 Budgeted (1,289.38) Remaining 106 % Used Account: 135-55060-039-000 Appraisal 4,229.90 .00 4,229.90 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,229.90 ** 10,265.00 Budgeted 6,035.10 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 133,209.54 ** 422,945.00 Budgeted 289,735.46 Remaining 31 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (159,920.24) .00 Budgeted 159,920.24 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/2016 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 (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 2016 0 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 1/31/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 582,421 - - 582,421 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,510,081 - - 1,510,081 INVESTMENTS-TEXPOOL 1,512,344 326,020 - 1,838,365 PREPAID EXPENSES 42,788 - - 42,788 ADVALOREM PROPERTY TAXES RECEIVABLE 5,291 - - 5,291 UTILITY AND OTHER ACCOUNTS RECEIVABLE 575,242 - - 575,242 - TOTAL ASSETS 4,263,767 326,020 - 4,589,787 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 5,291 - - 5,291 ACCOUNTS AND OTHER PAYABLES 591,925 - - 591,925 CUSTOMER DEPOSITS 317,217 - - 317,217 - TOTAL LIABILITIES 914,433 - - 914,433 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 407,000 - 407,000 UNASSIGNED FUND BALANCE 1,592,494 - 8,032 1,600,526 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES 159,920 - (8,032) 151,889 - TOTAL FUND BALANCE 3,349,333 326,020 - 3,675,353 - TOTAL LIABILITIES AND FUND BALANCE 4,263,767 326,020 - 4,589,787 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 09:23 02/11/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 994.67- 2,444.51- 2,444.51 Subtotal: 994.67- 2,444.51- 2,444.51 Program number: 994.67- 2,444.51- 2,444.51 Department number: Revenues 994.67- 2,444.51- 2,444.51 Revenues Subtotal ----------- 994.67- 2,444.51- 2,444.51 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 994.67- 2,444.51- 2,444.51 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 853 01/31/2016 Bank Interest/Month (1,449.84) (994.67) (2,444.51) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (994.67) (2,444.51) ** .00 Budgeted 2,444.51 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,444.51) ** .00 Budgeted 2,444.51 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (2,444.51) .00 Budgeted 2,444.51 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JANUARY 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,381,007 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,381,007 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 2,444 TOTAL FUND BALANCE 4,381,007 TOTAL LIABILITIES AND FUND BALANCE 4,381,007 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 09:23 02/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,895.71- 4,691.02- 4,691.02 Subtotal: 1,895.71- 4,691.02- 4,691.02 Program number: 1,895.71- 4,691.02- 4,691.02 Department number: Revenues 1,895.71- 4,691.02- 4,691.02 Revenues Subtotal ----------- 1,895.71- 4,691.02- 4,691.02 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 09:23 02/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 706,529.52 757,704.52 757,704.52- Subtotal: 706,529.52 757,704.52 757,704.52- Program number: 706,529.52 757,704.52 757,704.52- Department number: Wastewater 706,529.52 757,704.52 757,704.52- Expenditures Subtotal ----------- 706,529.52 757,704.52 757,704.52- Fund number: 518 2015 Revenue Bond Const Fund 704,633.81 753,013.50 753,013.50- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 853 01/31/2016 Bank Interest/Month (2,795.31) (1,895.71) (4,691.02) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,895.71) (4,691.02) ** .00 Budgeted 4,691.02 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,691.02) ** .00 Budgeted 4,691.02 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 782 01/28/2016 Webber-Cadagua App 3 retainage 51,175.00 70,652.95 121,827.95 GL 811 01/31/2016 Jan A/P WWTP Improvements/App #3 635,876.57 757,704.52 WEBBER-CADAGUA PARTNERS 1482 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 706,529.52 757,704.52 ** .00 Budgeted (757,704.52) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 757,704.52 ** .00 Budgeted (757,704.52) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 753,013.50 .00 Budgeted (753,013.50) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET JANUARY 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,349,581 ACCOUNTS RECEIVABLE - TOTAL ASSETS 8,349,581 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 768,491 TOTAL LIABILITIES 768,491 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (753,014) TOTAL FUND BALANCE 7,581,090 TOTAL LIABILITIES AND FUND BALANCE 8,349,581 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 09:23 02/11/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 30.33- 71.52- 71.52 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 61,668.00- 50.000 61,668.00- Subtotal: 123,336.00- 123,336.00- 30.33- 61,739.52- 50.058 61,596.48- Program number: 123,336.00- 123,336.00- 30.33- 61,739.52- 50.058 61,596.48- Department number: 123,336.00- 123,336.00- 30.33- 61,739.52- 50.058 61,596.48- Revenues Subtotal ----------- 123,336.00- 123,336.00- 30.33- 61,739.52- 50.058 61,596.48- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 30.33- 61,739.52- 50.058 61,596.48- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 853 01/31/2016 Bank Interest/Month (41.19) (30.33) (71.52) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (30.33) (71.52) ** .00 Budgeted 71.52 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (61,668.00) .00 (61,668.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,739.52) ** (123,336.00) Budgeted (61,596.48) Remaining 50 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,739.52) (123,336.00) Budgeted (61,596.48) Remaining 50 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 133,702 ACCOUNTS RECEIVABLE - TOTAL ASSETS 133,702 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 61,740 TOTAL FUND BALANCE 133,702 TOTAL LIABILITIES AND FUND BALANCE 133,702 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 09:23 02/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 151,683.38- 596,440.87- 89.301 71,457.13- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 164.03- 392.32- 17.057 1,907.68- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 48.92- 119.19- 6.622 1,680.81- Subtotal: 671,998.00- 671,998.00- 151,896.33- 596,952.38- 88.832 75,045.62- 533-49010-000-000 Interest Income 140.00- 140.00- 113.77- 134.69- 96.207 5.31- 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- Subtotal: 334,225.00- 334,225.00- 113.77- 134.69- .040 334,090.31- Program number: 1,006,223.00- 1,006,223.00- 152,010.10- 597,087.07- 59.339 409,135.93- Department number: Revenues 1,006,223.00- 1,006,223.00- 152,010.10- 597,087.07- 59.339 409,135.93- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 152,010.10- 597,087.07- 59.339 409,135.93- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 09:23 02/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 316,983.00 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 1,004,533.00 Program number: 1,004,533.00 1,004,533.00 1,004,533.00 Department number: Administration 1,004,533.00 1,004,533.00 1,004,533.00 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,004,533.00 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 152,010.10- 597,087.07- ############### 595,397.07 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2016 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 829 01/04/2016 Property Taxes/Assessments (444,757.49) (961.92) (445,719.41) GL 831 01/05/2016 Property Taxes/Assessments (14,748.14) (460,467.55) GL 832 01/06/2016 Property Taxes/Assessments (13,990.53) (474,458.08) GL 833 01/07/2016 Property Taxes/Assessments (11,230.66) (485,688.74) GL 834 01/08/2016 Property Taxes/Assessments (4,711.78) (490,400.52) GL 835 01/11/2016 Property Taxes/Assessments (5,721.85) (496,122.37) GL 836 01/12/2016 Property Taxes/Assessments (8,940.12) (505,062.49) GL 837 01/13/2016 Property Taxes/Assessments (8,327.29) (513,389.78) GL 838 01/14/2016 Property Taxes/Assessments (8,042.13) (521,431.91) GL 839 01/15/2016 Property Taxes/Assessments (3,094.84) (524,526.75) GL 840 01/19/2016 Property Taxes/Assessments (10,911.17) (535,437.92) GL 841 01/20/2016 Property Taxes/Assessments (3,180.24) (538,618.16) GL 842 01/21/2016 Property Taxes/Assessments (2,093.46) (540,711.62) GL 843 01/22/2016 Property Taxes/Assessments (4,118.72) (544,830.34) GL 844 01/25/2016 Property Taxes/Assessments (6,168.44) (550,998.78) GL 845 01/26/2016 Property Taxes/Assessments (9,213.39) (560,212.17) GL 847 01/27/2016 Property Taxes/Assessments (6,905.99) (567,118.16) GL 848 01/28/2016 Property Taxes/Assessments (16,115.14) (583,233.30) GL 850 01/29/2016 Property Taxes/Assessments (13,207.57) (596,440.87) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (151,683.38) (596,440.87) ** (667,898.00) Budgeted (71,457.13) Remaining 89 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 831 01/05/2016 Property Taxes/Assessments (228.29) (54.74) (283.03) GL 832 01/06/2016 Property Taxes/Assessments (4.07) (287.10) GL 834 01/08/2016 Property Taxes/Assessments 161.13 (125.97) GL 850 01/29/2016 Property Taxes/Assessments (266.35) (392.32) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (164.03) (392.32) ** (2,300.00) Budgeted (1,907.68) Remaining 17 % Used Account: 533-40015-000-000 Property Taxes/P & I 832 01/06/2016 Property Taxes/Assessments (70.27) (.81) (71.08) GL 850 01/29/2016 Property Taxes/Assessments (48.11) (119.19) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (48.92) (119.19) ** (1,800.00) Budgeted (1,680.81) Remaining 7 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 853 01/31/2016 Bank Interest/Month (20.92) (113.77) (134.69) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (113.77) (134.69) ** (140.00) Budgeted (5.31) Remaining 96 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,379.00) Budgeted (214,379.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (119,706.00) Budgeted (119,706.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (597,087.07) ** (1,006,223.00) Budgeted (409,135.93) Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2016 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 316,983.00 Budgeted 316,983.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,004,533.00 Budgeted 1,004,533.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (597,087.07) (1,690.00) Budgeted 595,397.07 Remaining ########## TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 616,413 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 83,414 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 704,674 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 83,414 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 83,414 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 597,087 TOTAL FUND BALANCE 621,260 TOTAL LIABILITIES AND FUND BALANCE 704,674 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 09:23 02/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 3.44- 8.53- 121.857 1.53 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 444,831.00- Subtotal: 444,838.00- 444,838.00- 3.44- 8.53- .002 444,829.47- Program number: 444,838.00- 444,838.00- 3.44- 8.53- .002 444,829.47- Department number: Revenues 444,838.00- 444,838.00- 3.44- 8.53- .002 444,829.47- Revenues Subtotal ----------- 444,838.00- 444,838.00- 3.44- 8.53- .002 444,829.47- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 09:23 02/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 234,838.00 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 444,838.00 Program number: 444,838.00 444,838.00 444,838.00 Department number: Administration 444,838.00 444,838.00 444,838.00 Expenditures Subtotal ----------- 444,838.00 444,838.00 444,838.00 Fund number: 534 2015 Revenue Bond I&S 3.44- 8.53- 8.53 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 61 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 853 01/31/2016 Bank Interest/Month (5.09) (3.44) (8.53) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (3.44) (8.53) ** (7.00) Budgeted 1.53 Remaining 122 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (444,831.00) Budgeted (444,831.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (8.53) ** (444,838.00) Budgeted (444,829.47) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 62 09:23 02/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 234,838.00 Budgeted 234,838.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 444,838.00 Budgeted 444,838.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (8.53) .00 Budgeted 8.53 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (564,189.21) **** (125,026.00) Budgeted 439,163.21 Remaining 451 % Used ******* End of Report ********* TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JANUARY 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,077 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,077 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 9 TOTAL FUND BALANCE 15,077 TOTAL LIABILITIES AND FUND BALANCE 15,077