Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
June Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 907,956 PREPAID EXPENSES 5,016 ADVALOREM PROPERTY TAXES RECEIVABLE 22,583 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 8,982 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,734 TOTAL ASSETS 946,271 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 31,565 ACCOUNTS AND OTHER PAYABLES 6,368 TOTAL LIABILITIES 37,933 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 495,688 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 412,650 TOTAL FUND BALANCE 908,338 TOTAL LIABILITIES AND FUND BALANCE 946,271 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 17:03 07/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 1,264.16- 309,220.40- 101.236 3,775.40 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1,581.21- 1,581.21 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 2,329.65- 917,178.83- 98.881 10,376.17- 122-40011-000-000 Property Taxes/Fire-Delinquent .79- 1,344.67- 1,344.67 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 183.84- 729.77- 97.303 20.23- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 189.45- 4,890.96- 108.688 390.96 Subtotal: 1,238,250.00- 1,238,250.00- 3,967.89- 1,234,945.84- 99.733 3,304.16- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 4,000.00- 66.667 2,000.00- Subtotal: 6,000.00- 6,000.00- 400.00- 4,000.00- 66.667 2,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 750.00- 107.143 50.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 75.00- 750.00- 7.009 9,950.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 525.00- 6,050.00- 100.833 50.00 Subtotal: 6,000.00- 6,000.00- 525.00- 6,050.00- 100.833 50.00 Program number: 1,260,950.00- 1,260,950.00- 4,967.89- 1,245,745.84- 98.794 15,204.16- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 4,967.89- 1,245,745.84- 98.794 15,204.16- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 4,967.89- 1,245,745.84- 98.794 15,204.16- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 17:03 07/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 35,840.99 327,222.79 71.773 128,693.21 122-50010-045-000 Overtime 44,225.00 44,225.00 2,466.76 25,587.87 57.858 18,637.13 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 375.00 3,339.39 76.768 1,010.61 122-50020-045-000 Retirement 70,991.00 70,991.00 5,503.34 53,094.64 74.791 17,896.36 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,316.21 37,458.32 65.753 19,509.68 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 352.79 3,056.09 72.248 1,173.91 122-50028-045-000 Vision Insurance 892.00 892.00 69.46 624.28 69.987 267.72 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 326.43 2,848.98 67.035 1,401.02 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,186.32 21,397.94 64.882 11,582.06 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 511.19 5,003.04 64.865 2,709.96 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 29.18 1,600.62 70.855 658.38 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.78 5,965.08 68.501 2,742.92 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 52,640.45 505,349.62 70.889 207,529.38 122-55030-045-000 Software & Support 8,682.00 6,834.00 6,834.00 122-55045-045-000 Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 3,076.87 14,710.19 71.855 5,761.81 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 47.67 7,023.66 47.297 7,826.34 Subtotal: 49,004.00 45,547.00 3,124.54 19,228.34 42.216 26,318.66 122-60005-045-000 Telephone 100.00 100.00 11.42 20.49 20.490 79.51 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 1,612.97 3,430.31 80.961 806.69 122-60020-045-000 Electricity/Gas 6,568.00 9,268.00 538.46 5,141.15 55.472 4,126.85 122-60025-045-000 Water 1,500.00 1,500.00 171.21 768.89 51.259 731.11 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 .96 37.05 37.050 62.95 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 9,125.25 75.353 2,984.75 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 8,411.64 55.413 6,768.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 437.01 4,482.01 104.720 202.01- 122-60096-045-000 Emergency Management 2,000.00 2,000.00 83.29 1,608.70 80.435 391.30 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 13.81 2,490.18 54.406 2,086.82 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 200.00 200.00 200.00- 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 754.33 1,434.58 31.880 3,065.42 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 249.00 16.600 1,251.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 1,539.62 76.981 460.38 122-60243-045-000 Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 17:03 07/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 200.00- 159.97 15.997 840.03 Subtotal: 276,531.00 282,488.00 4,632.71 256,947.13 90.959 25,540.87 122-65005-045-000 Fuel & Lube 11,698.00 10,198.00 727.24 6,294.03 61.718 3,903.97 122-65010-045-000 Uniforms 3,360.00 3,360.00 2,784.64 82.876 575.36 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 3,736.00 5,953.77 78.339 1,646.23 122-65030-045-000 Chemicals 1,000.00 500.00 420.00 84.000 80.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 72.00 694.31 27.772 1,805.69 122-65085-045-000 Office Supplies 1,000.00 500.00 233.22 46.644 266.78 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 4,535.24 16,379.97 66.160 8,378.03 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 50.000 1,515.50 122-69050-045-000 Radios 34,200.00 34,200.00 32,693.40 95.595 1,506.60 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 981.59 981.59 4.812 19,418.41 Subtotal: 195,278.00 195,278.00 981.59 35,190.49 18.021 160,087.51 Program number: 1,260,950.00 1,260,950.00 65,914.53 833,095.55 66.069 427,854.45 Department number: Fire 1,260,950.00 1,260,950.00 65,914.53 833,095.55 66.069 427,854.45 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 65,914.53 833,095.55 66.069 427,854.45 Fund number: 122 Trophy Club MUD Fire Dept. 60,946.64 412,650.29- 412,650.29 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 1632 06/06/2014 Property Taxes/Assessments (307,956.24) (20.81) (307,977.05) GL 1633 06/09/2014 Property Taxes/Assessments (411.99) (308,389.04) GL 1638 06/25/2014 Property Taxes/Assessments (786.38) (309,175.42) GL 1639 06/26/2014 Property Taxes/Assessments (44.98) (309,220.40) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (1,264.16) (309,220.40) ** (305,445.00) Budgeted 3,775.40 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (1,581.21) .00 (1,581.21) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (1,581.21) ** .00 Budgeted 1,581.21 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1629 06/02/2014 Property Taxes/Assessments (914,849.18) (415.41) (915,264.59) GL 1630 06/04/2014 Property Taxes/Assessments (29.12) (915,293.71) GL 1631 06/05/2014 Property Taxes/Assessments (192.19) (915,485.90) GL 1632 06/06/2014 Property Taxes/Assessments (1,236.32) (916,722.22) GL 1634 06/11/2014 Property Taxes/Assessments (204.25) (916,926.47) GL 1635 06/16/2014 Property Taxes/Assessments (27.49) (916,953.96) GL 1636 06/18/2014 Property Taxes/Assessments (64.12) (917,018.08) GL 1640 06/27/2014 Property Taxes/Assessments (42.22) (917,060.30) GL 1647 06/30/2014 Property Taxes/Assessments (118.53) (917,178.83) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,329.65) (917,178.83) ** (927,555.00) Budgeted (10,376.17) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1637 06/23/2014 Property Taxes/Assessments (1,343.88) (.79) (1,344.67) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (.79) (1,344.67) ** .00 Budgeted 1,344.67 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1632 06/06/2014 Property Taxes/Assessments (545.93) (2.29) (548.22) GL 1633 06/09/2014 Property Taxes/Assessments (61.80) (610.02) GL 1638 06/25/2014 Property Taxes/Assessments (117.97) (727.99) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1639 06/26/2014 Property Taxes/Assessments (545.93) (1.78) (729.77) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (183.84) (729.77) ** (750.00) Budgeted (20.23) Remaining 97 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1629 06/02/2014 Property Taxes/Assessments (4,701.51) (.01) (4,701.52) GL 1632 06/06/2014 Property Taxes/Assessments (131.99) (4,833.51) GL 1634 06/11/2014 Property Taxes/Assessments (30.65) (4,864.16) GL 1635 06/16/2014 Property Taxes/Assessments (4.06) (4,868.22) GL 1636 06/18/2014 Property Taxes/Assessments (4.49) (4,872.71) GL 1637 06/23/2014 Property Taxes/Assessments (.40) (4,873.11) GL 1647 06/30/2014 Property Taxes/Assessments (17.85) (4,890.96) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (189.45) (4,890.96) ** (4,500.00) Budgeted 390.96 Remaining 109 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (3,600.00) (400.00) (4,000.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,000.00) ** (6,000.00) Budgeted (2,000.00) Remaining 67 % Used Account: 122-43400-000-000 Fire Inspections 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (675.00) (75.00) (750.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (750.00) ** (700.00) Budgeted 50.00 Remaining 107 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (5,525.00) (525.00) (6,050.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (6,050.00) ** (6,000.00) Budgeted 50.00 Remaining 101 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,245,745.84) ** (1,260,950.00) Budgeted (15,204.16) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1488 06/06/2014 FD 6/6/14 Payroll 291,381.80 18,119.17 309,500.97 GL 1654 06/20/2014 FD Payroll 6/20/14 17,721.82 327,222.79 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,840.99 327,222.79 ** 455,916.00 Budgeted 128,693.21 Remaining 72 % Used Account: 122-50010-045-000 Overtime 1488 06/06/2014 FD 6/6/14 Payroll 23,121.11 2,466.76 25,587.87 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,466.76 25,587.87 ** 44,225.00 Budgeted 18,637.13 Remaining 58 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 1488 06/06/2014 FD 6/6/14 Payroll 2,964.39 375.00 3,339.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 375.00 3,339.39 ** 4,350.00 Budgeted 1,010.61 Remaining 77 % Used Account: 122-50020-045-000 Retirement 1488 06/06/2014 FD 6/6/14 Payroll 47,591.30 2,966.13 50,557.43 GL 1654 06/20/2014 FD Payroll 6/20/14 2,537.21 53,094.64 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,503.34 53,094.64 ** 70,991.00 Budgeted 17,896.36 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1488 06/06/2014 FD 6/6/14 Payroll 33,142.11 2,488.33 35,630.44 GL 1654 06/20/2014 FD Payroll 6/20/14 1,827.88 37,458.32 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.21 37,458.32 ** 56,968.00 Budgeted 19,509.68 Remaining 66 % Used Account: 122-50027-045-000 Dental Insurance 1488 06/06/2014 FD 6/6/14 Payroll 2,703.30 176.37 2,879.67 GL 1654 06/20/2014 FD Payroll 6/20/14 176.42 3,056.09 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.79 3,056.09 ** 4,230.00 Budgeted 1,173.91 Remaining 72 % Used Account: 122-50028-045-000 Vision Insurance 1488 06/06/2014 FD 6/6/14 Payroll 554.82 34.71 589.53 GL 1654 06/20/2014 FD Payroll 6/20/14 34.75 624.28 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.46 624.28 ** 892.00 Budgeted 267.72 Remaining 70 % Used Account: 122-50029-045-000 Life Insurance & Other 1488 06/06/2014 FD 6/6/14 Payroll 2,522.55 163.16 2,685.71 GL 1654 06/20/2014 FD Payroll 6/20/14 163.27 2,848.98 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.43 2,848.98 ** 4,250.00 Budgeted 1,401.02 Remaining 67 % Used Account: 122-50030-045-000 Social Security Taxes 1488 06/06/2014 FD 6/6/14 Payroll 19,211.62 1,193.54 20,405.16 GL 1654 06/20/2014 FD Payroll 6/20/14 992.78 21,397.94 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,186.32 21,397.94 ** 32,980.00 Budgeted 11,582.06 Remaining 65 % Used Account: 122-50035-045-000 Medicare Taxes 1488 06/06/2014 FD 6/6/14 Payroll 4,491.85 279.04 4,770.89 GL 1654 06/20/2014 FD Payroll 6/20/14 232.15 5,003.04 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 511.19 5,003.04 ** 7,713.00 Budgeted 2,709.96 Remaining 65 % Used Account: 122-50040-045-000 Unemployment Taxes 1488 06/06/2014 FD 6/6/14 Payroll 1,571.44 18.30 1,589.74 GL 1654 06/20/2014 FD Payroll 6/20/14 10.88 1,600.62 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 29.18 1,600.62 ** 2,259.00 Budgeted 658.38 Remaining 71 % Used Account: 122-50045-045-000 Workman's Compensation 124 06/01/2014 FD Jun W/C expense 5,302.30 662.78 5,965.08 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 5,965.08 ** 8,708.00 Budgeted 2,742.92 Remaining 69 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 6,834.00 Budgeted 6,834.00 Remaining 0 % Used Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 3,391.00 Budgeted 5,896.51 Remaining -74 % Used Account: 122-55080-045-000 Maintenance & Repairs 1565 06/18/2014 Firefighter cable/June 11,633.32 (133.82) 11,499.50 GL 1567 06/20/2014 June A/P Charter cable 462.50 11,962.00 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 462.50 12,424.50 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P Air test per NFPA 170.50 12,595.00 AUGUST INDUSTRIES, INC 33883 AP 1683 06/26/2014 June A/P THE HOME DEPOT 6581 33.86 12,628.86 THE HOME DEPOT 6581 PC 1683 06/26/2014 June A/P THE HOME DEPOT 6581 29.95 12,658.81 THE HOME DEPOT 6581 PC 1683 06/26/2014 June A/P ATT*BILL PAYMENT 128.82 12,787.63 ATT*BILL PAYMENT PC 1683 06/26/2014 June A/P SAMSCLUB #4795 391.29 13,178.92 SAMSCLUB #4795 PC 1683 06/26/2014 June A/P ATT*BILL PAYMENT 158.76 13,337.68 ATT*BILL PAYMENT PC 1681 06/30/2014 June A/P Rug Service/FD 24.51 13,362.19 G & K SERVICES AP 1681 06/30/2014 June A/P Rug Service/FD 24.51 13,386.70 G & K SERVICES AP 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (24.51) 13,362.19 AR 1687 06/30/2014 June A/P Hose testing 1,348.00 14,710.19 WATERWAY NORTH TEXAS INC AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 3,076.87 14,710.19 ** 20,472.00 Budgeted 5,761.81 Remaining 72 % Used Account: 122-55090-045-000 Vehicle Maintenance 1683 06/26/2014 June A/P KWIK KAR LUBE & TUNE O 6,975.99 47.67 7,023.66 KWIK KAR LUBE & TUNE O PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 47.67 7,023.66 ** 14,850.00 Budgeted 7,826.34 Remaining 47 % Used Account: 122-60005-045-000 Telephone 1567 06/20/2014 June A/P BOA 4/28-5/27/14 9.07 5.73 14.80 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 5.69 20.49 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 122-60005-045-000 Telephone Totals: 11.42 20.49 ** 100.00 Budgeted 79.51 Remaining 20 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1488 06/06/2014 FD 6/6/14 Payroll 1,817.34 75.00 1,892.34 GL 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 139.55 2,031.89 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 139.42 2,171.31 TOWN OF TROPHY CLUB 33906 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1681 06/30/2014 June A/P AV Tek, Denton County (FD Disp 1,817.34 1,259.00 3,430.31 TOWN OF TROPHY CLUB AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 1,612.97 3,430.31 ** 4,237.00 Budgeted 806.69 Remaining 81 % Used Account: 122-60020-045-000 Electricity/Gas 1681 06/30/2014 June A/P Gas/Fire Station 5/17-6/18 4,602.69 92.50 4,695.19 ATMOS ENERGY AP 1681 06/30/2014 June A/P Electricity 5/13-6/13/14 984.42 5,679.61 HUDSON ENERGY SERVICES, LLC AP 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (538.46) 5,141.15 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 538.46 5,141.15 ** 9,268.00 Budgeted 4,126.85 Remaining 55 % Used Account: 122-60025-045-000 Water 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: 597.68 (171.24) 426.44 AR 1687 06/30/2014 June A/P June Water 110.29 536.73 TROPHY CLUB MUD (WATER BILLS) AP 1687 06/30/2014 June A/P June Water 232.16 768.89 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 122-60025-045-000 Water Totals: 171.21 768.89 ** 1,500.00 Budgeted 731.11 Remaining 51 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1526 06/01/2014 May Postage meter usage 36.09 .96 37.05 GL _______________ Account: 122-60035-045-000 Postage Totals: .96 37.05 ** 100.00 Budgeted 62.95 Remaining 37 % Used Account: 122-60055-045-000 Insurance 56 06/01/2014 Jun Ins & W/C Expense 8,116.00 1,009.25 9,125.25 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 9,125.25 ** 12,110.00 Budgeted 2,984.75 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 8,411.64 .00 8,411.64 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 8,411.64 ** 15,180.00 Budgeted 6,768.36 Remaining 55 % Used Account: 122-60080-045-000 Schools & Training 1567 06/20/2014 June A/P Fire Officer III Cert/Hurd 4,045.00 85.00 4,130.00 TX COMM ON FIRE PROTECTION 33908 AP 1683 06/26/2014 June A/P ACTIVE911 INC 187.00 4,317.00 ACTIVE911 INC PC 1683 06/26/2014 June A/P JONES&BARTLETT LEARNIN 66.01 4,383.01 JONES&BARTLETT LEARNIN PC 1683 06/26/2014 June A/P FREDPRYOR CAREERTRACK 99.00 4,482.01 FREDPRYOR CAREERTRACK PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 437.01 4,482.01 ** 4,280.00 Budgeted (202.01) Remaining 105 % Used Account: 122-60096-045-000 Emergency Management 1683 06/26/2014 June A/P THE HOME DEPOT 6581 1,525.41 83.29 1,608.70 THE HOME DEPOT 6581 PC _______________ Account: 122-60096-045-000 Emergency Management Totals: 83.29 1,608.70 ** 2,000.00 Budgeted 391.30 Remaining 80 % Used Account: 122-60100-045-000 Travel & per diem 1683 06/26/2014 June A/P BUFFALO WILD WINGS 015 2,476.37 13.81 2,490.18 BUFFALO WILD WINGS 015 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 13.81 2,490.18 ** 4,577.00 Budgeted 2,086.82 Remaining 54 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60125-045-000 Advertising 1688 06/30/2014 Recode FD Printing/Misc Exp 200.00 200.00 GL _______________ Account: 122-60125-045-000 Advertising Totals: 200.00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 1567 06/20/2014 June A/P Coloring books, sticker rolls 680.25 754.33 1,434.58 RIVER CITY SUPPLY, LLC 33903 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 754.33 1,434.58 ** 4,500.00 Budgeted 3,065.42 Remaining 32 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 249.00 .00 249.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 249.00 ** 1,500.00 Budgeted 1,251.00 Remaining 17 % Used Account: 122-60195-045-000 Flags & Repair 1,539.62 .00 1,539.62 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,539.62 ** 2,000.00 Budgeted 460.38 Remaining 77 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** 3,457.00 Budgeted .46 Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 1688 06/30/2014 Recode FD Printing/Misc Exp 359.97 (200.00) 159.97 GL _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: (200.00) 159.97 ** 1,000.00 Budgeted 840.03 Remaining 16 % Used Account: 122-65005-045-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1652 06/30/2014 June Gas Log 5,566.79 727.24 6,294.03 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 727.24 6,294.03 ** 10,198.00 Budgeted 3,903.97 Remaining 62 % Used Account: 122-65010-045-000 Uniforms 2,784.64 .00 2,784.64 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 2,784.64 ** 3,360.00 Budgeted 575.36 Remaining 83 % Used Account: 122-65015-045-000 Protective Clothing 1567 06/20/2014 June A/P Protective clothing 2,217.77 3,736.00 5,953.77 CASCO INDUSTRIES INC 33885 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 3,736.00 5,953.77 ** 7,600.00 Budgeted 1,646.23 Remaining 78 % Used Account: 122-65030-045-000 Chemicals 420.00 .00 420.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 420.00 ** 500.00 Budgeted 80.00 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 1683 06/26/2014 June A/P WILDFIRE TRUCK & EQUIP 622.31 72.00 694.31 WILDFIRE TRUCK & EQUIP PC _______________ Account: 122-65035-045-000 Small Tools Totals: 72.00 694.31 ** 2,500.00 Budgeted 1,805.69 Remaining 28 % Used Account: 122-65085-045-000 Office Supplies 233.22 .00 233.22 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 233.22 ** 500.00 Budgeted 266.78 Remaining 47 % Used Account: 122-65105-045-000 Printing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest 1,515.50 .00 1,515.50 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 1,515.50 ** 3,031.00 Budgeted 1,515.50 Remaining 50 % Used Account: 122-69050-045-000 Radios 32,693.40 .00 32,693.40 _______________ Account: 122-69050-045-000 Radios Totals: .00 32,693.40 ** 34,200.00 Budgeted 1,506.60 Remaining 96 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks 1681 06/30/2014 June A/P Headset for Airpacks 981.59 981.59 MUNICIPAL EMERGENCY SERVICES AP _______________ Account: 122-69255-045-000 Airpacks Totals: 981.59 981.59 ** 20,400.00 Budgeted 19,418.41 Remaining 5 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 833,095.55 ** 1,260,950.00 Budgeted 427,854.45 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (412,650.29) .00 Budgeted 412,650.29 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JUNE 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 6/30/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 235,487 - - 235,487 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,503,489 - - 1,503,489 INVESTMENTS-TEXPOOL 951,268 193,050 279,467 1,423,785 PREPAID EXPENSES 29,803 - - 29,803 ADVALOREM PROPERTY TAXES RECEIVABLE 2,739 - - 2,739 UTILITY AND OTHER ACCOUNTS RECEIVABLE 708,384 - - 708,384 - TOTAL ASSETS 3,431,770 193,050 279,467 3,904,287 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,739 - - 2,739 ACCOUNTS AND OTHER PAYABLES 447,842 - 300 448,142 CUSTOMER DEPOSITS 257,592 - - 257,592 - TOTAL LIABILITIES 708,173 - 300 708,473 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 193,050 193,050 NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,708,490 - - 2,708,490 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (264,879) - 34,066 (230,813) - TOTAL FUND BALANCE 2,723,597 193,050 279,167 3,195,814 - TOTAL LIABILITIES AND FUND BALANCE 3,431,770 193,050 279,467 3,904,287 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 249.28- 98,184.96- 98.927 1,065.04- 135-40002-000-000 Property Taxes/Delinquent .06- 129.61- 129.61 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 20.26- 513.81- 57.090 386.19- Subtotal: 100,150.00- 100,150.00- 269.60- 98,828.38- 98.680 1,321.62- 135-43215-000-000 Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 361,478.95- 2,055,704.84- 54.829 1,693,605.16- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 193,141.16- 1,393,288.36- 81.559 315,032.64- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 4,078.88- 35,857.70- 55.574 28,664.30- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 953.00- 6,827.00- 75.229 2,248.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 2,000.00- 100.00- 1,950.00- 97.500 50.00- 135-47045-000-000 Sewer Inspections 4,400.00- 5,000.00- 300.00- 6,150.00- 123.000 1,150.00 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 11,235.70- 38,402.38- 48.253 41,183.62- Subtotal: 5,616,414.00- 5,617,814.00- 571,287.69- 3,538,180.28- 62.981 2,079,633.72- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 25,300.00- 259,900.00- 44.648 322,209.00- Subtotal: 582,109.00- 582,109.00- 25,300.00- 259,900.00- 44.648 322,209.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 71,200.79- 75,230.50- 1,567.302 70,430.50 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 8,194.77- 80.625 1,969.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49030-000-000 Vending Revenue 350.00- 350.00- 80.85- 226.85- 64.814 123.15- 135-49035-000-000 Prior Year Reserves 880,000.00- 880,000.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 4,459.00- 64,345.80- 76.602 19,654.20- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 118.28- 1,276.36- 42.545 1,723.64- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 36.39- 36.39- 36.390 63.61- 135-49903-000-000 Recovery of Prior Year Expense 4,087.00- 4,087.00- 100.000 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 1,003,351.00- 77,389.17- 158,647.64- 15.812 844,703.36- Program number: 6,417,937.00- 7,303,424.00- 674,246.46- 4,055,638.66- 55.531 3,247,785.34- Department number: Revenues 6,417,937.00- 7,303,424.00- 674,246.46- 4,055,638.66- 55.531 3,247,785.34- Revenues Subtotal ----------- 6,417,937.00- 7,303,424.00- 674,246.46- 4,055,638.66- 55.531 3,247,785.34- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 22,138.67 195,216.62 67.852 92,492.38 135-50010-010-000 Overtime 13,391.00 16,391.00 1,100.21 14,208.43 86.684 2,182.57 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 3,150.00 61.765 1,950.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,120.52 19,973.67 71.726 7,873.33 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,559.98 29,820.51 61.697 18,513.49 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 2,175.21 55.321 1,756.79 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 533.05 61.060 339.95 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 223.17 1,898.43 57.424 1,407.57 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,459.26 13,809.22 71.591 5,479.78 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 341.28 3,229.58 71.593 1,281.42 135-50040-010-000 Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 7,222.05 73.477 2,606.95 135-50060-010-000 Pre-emp Physicals/Testing 200.00 350.00 63.00 296.90 84.829 53.10 135-50070-010-000 Employee Relations 300.00 300.00 18.75 180.53 60.177 119.47 Subtotal: 429,580.00 433,920.00 32,514.44 297,863.64 68.645 136,056.36 135-55005-010-000 Engineering 3,000.00 6,000.00 6,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 61,000.00 4,713.68 50,676.96 83.077 10,323.04 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 533.49 3,013.09 60.262 1,986.91 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 248.33 9.933 2,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 367.33 3,281.24 59.659 2,218.76 Subtotal: 67,000.00 80,000.00 5,614.50 57,219.62 71.525 22,780.38 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 766.38 3,447.83 70.178 1,465.17 135-60020-010-000 Electricity 162,160.00 155,160.00 17,846.28 87,658.01 56.495 67,501.99 135-60066-010-000 Publications/Books/Subscripts 500.00 2,538.00 2,715.66 2,715.66 107.000 177.66- 135-60070-010-000 Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010-000 Schools & Training 4,184.00 1,500.00 337.00 1,671.00 111.400 171.00- 135-60090-010-000 Safety Program 400.00 135-60100-010-000 Travel & per diem 1,450.00 279.00 172.63 61.875 106.37 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 60.00 12.000 440.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 32,463.59 68.489 14,936.41 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 194,520.44 1,145,633.23 48.991 1,192,839.77 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 1,289.55 36.844 2,210.45 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 2,000.00 1,664.20 83.210 335.80 Subtotal: 2,567,580.00 2,557,013.00 216,185.76 1,277,064.70 49.944 1,279,948.30 135-65005-010-000 Fuel & Lube 23,181.00 22,181.00 1,183.43 9,627.73 43.405 12,553.27 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 2,500.00 1,938.58 77.543 561.42 135-65030-010-000 Chemicals 5,000.00 5,000.00 513.34 4,490.61 89.812 509.39 135-65035-010-000 Small Tools 1,200.00 1,200.00 490.92 40.910 709.08 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 344.55 34.455 655.45 135-65050-010-000 Meter Expense 143,550.00 143,550.00 9,804.00 76,145.04 53.044 67,404.96 Subtotal: 177,201.00 175,431.00 11,500.77 93,037.43 53.034 82,393.57 135-69005-010-000 Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 25.099 367,000.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 60.314 7,646.74 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 135-69281-010-000 Water Tank Inspection Contract 106,847.00 100,847.00 100,816.54 99.970 30.46 Subtotal: 690,595.00 645,776.00 271,097.39 41.980 374,678.61 Program number: 3,931,956.00 3,892,140.00 265,815.47 1,996,282.78 51.290 1,895,857.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 1,000.00 2,000.00 97.63 2,742.24 137.112 742.24- Subtotal: 1,000.00 2,000.00 97.63 2,742.24 137.112 742.24- 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 2,496.19 49.924 2,503.81 Subtotal: 5,000.00 2,496.19 49.924 2,503.81 Program number: 1 Lab Analysis for PID 1,000.00 7,000.00 97.63 5,238.43 74.835 1,761.57 Department number: Water 3,932,956.00 3,899,140.00 265,913.10 2,001,521.21 51.332 1,897,618.79 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,561.19 140,602.56 69.299 62,291.44 135-50010-020-000 Overtime 11,965.00 11,965.00 303.20 10,116.59 84.552 1,848.41 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 3,600.00 75.000 1,200.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,460.53 14,595.38 73.325 5,309.62 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,426.76 30,388.08 69.904 13,082.92 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,947.66 65.161 1,041.34 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 457.35 69.506 200.65 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 158.73 1,611.57 69.977 691.43 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 854.25 8,862.93 64.201 4,942.07 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 199.77 2,072.77 64.192 1,156.23 135-50040-020-000 Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 4,815.72 73.500 1,736.28 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 26.28 86.27 24.649 263.73 Subtotal: 316,105.00 316,897.00 23,188.43 223,045.38 70.384 93,851.62 135-55070-020-000 Independent Labor 880,000.00 606,301.95 68.898 273,698.05 135-55080-020-000 Maintenance & Repairs 35,000.00 36,120.00 6,254.60 34,101.33 94.411 2,018.67 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 12.99 1,665.48 83.274 334.52 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 135-55125-020-000 Dumpster Services 52,000.00 47,000.00 6,583.25 41,295.60 87.863 5,704.40 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 19.18- 18,786.08 62.620 11,213.92 Subtotal: 119,500.00 995,120.00 12,831.66 702,150.44 70.559 292,969.56 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 523.89 2,449.51 73.581 879.49 135-60020-020-000 Electricity 148,227.00 138,227.00 10,631.45 78,626.47 56.882 59,600.53 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020-000 Schools & Training 2,636.00 1,636.00 260.00 1,347.00 82.335 289.00 135-60090-020-000 Safety Program 250.00 500.00 474.07 94.814 25.93 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 1,085.11 103.344 35.11- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020-000 Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 11,415.34 98,185.01 58.141 70,689.99 135-65005-020-000 Fuel & Lube 14,720.00 13,600.00 1,136.67 8,324.97 61.213 5,275.03 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 39,000.00 31,000.00 3,320.00 20,892.10 67.394 10,107.90 135-65035-020-000 Small Tools 1,000.00 300.00 177.09 59.030 122.91 135-65040-020-000 Safety Equipment 250.00 500.00 47.23 277.86 55.572 222.14 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 484.27 10,004.02 66.693 4,995.98 Subtotal: 71,722.00 62,152.00 4,988.17 41,113.31 66.150 21,038.69 135-69005-020-000 Capital Outlays 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 73.397 378.30 135-69280-020-000 Capital Repairs 30,000.00 Subtotal: 82,442.00 21,442.00 21,063.70 98.236 378.30 Program number: 768,011.00 1,564,486.00 52,423.60 1,085,557.84 69.388 478,928.16 Department number: Wastewater 768,011.00 1,564,486.00 52,423.60 1,085,557.84 69.388 478,928.16 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 6,869.30 53,783.51 59.562 36,515.49 135-50010-021-000 Overtime 10,028.00 10,028.00 1,166.07 4,339.89 43.278 5,688.11 135-50016-021-000 Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,350.00 75.000 450.00 135-50020-021-000 Retirement 9,025.00 9,025.00 735.04 5,884.96 65.207 3,140.04 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,473.70 14,094.99 59.553 9,573.01 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 1,017.99 59.776 685.01 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 217.93 69.404 96.07 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 72.75 757.74 71.083 308.26 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 477.46 3,701.54 49.739 3,740.46 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 111.66 865.68 49.723 875.32 135-50040-021-000 Unemployment Taxes 198.00 414.00 414.00 100.000 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 2,407.86 73.500 868.14 135-50070-021-000 Employee Relations 200.00 200.00 77.21 209.23 104.615 9.23- Subtotal: 168,673.00 153,084.00 11,527.01 91,152.82 59.544 61,931.18 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 14,451.00 1,046.40 8,062.64 55.793 6,388.36 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 49.959 1,000.82 Subtotal: 27,301.00 16,451.00 1,046.40 9,061.82 55.084 7,389.18 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 205.24 1,097.04 82.299 235.96 135-60020-021-000 Electricity 21,178.00 21,178.00 1,669.34 15,337.94 72.424 5,840.06 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 911.00 111.00 111.00 12.184 800.00 135-60090-021-000 Safety Program 300.00 300.00 35.34 11.780 264.66 135-60100-021-000 Travel & per diem 550.00 250.00 38.49 15.396 211.51 135-60105-021-000 Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 1,985.58 16,619.81 56.680 12,702.19 135-65005-021-000 Fuel & Lube 22,397.00 21,747.00 862.42 8,869.42 40.785 12,877.58 135-65010-021-000 Uniforms 1,040.00 1,040.00 814.23 78.291 225.77 135-65030-021-000 Chemicals 6,000.00 2,000.00 300.89 15.045 1,699.11 135-65035-021-000 Small Tools 1,000.00 300.00 43.99 14.663 256.01 135-65040-021-000 Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 862.42 10,615.26 41.085 15,221.74 135-69005-021-000 Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 Subtotal: 209,837.00 152,837.00 68,300.20 44.688 84,536.80 Program number: 472,170.00 377,531.00 15,421.41 195,749.91 51.850 181,781.09 Department number: Collection 472,170.00 377,531.00 15,421.41 195,749.91 51.850 181,781.09 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 400.00 6,500.00 65.000 3,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 24.80 403.00 65.000 217.00 135-50035-026-000 Medicare Taxes 145.00 145.00 5.80 94.25 65.000 50.75 135-50040-026-000 Unemployment Taxes 10.00 230.00 9.20 94.50 41.087 135.50 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 26.53 73.694 9.47 Subtotal: 10,811.00 11,031.00 442.74 7,118.28 64.530 3,912.72 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 96.97 132.92 11.077 1,067.08 135-60080-026-000 Schools & Training 4,000.00 4,000.00 632.00 15.800 3,368.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 41.66 .833 4,958.34 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 179.40 17.940 820.60 Subtotal: 11,850.00 11,850.00 96.97 1,020.98 8.616 10,829.02 Program number: 22,661.00 22,881.00 539.71 8,139.26 35.572 14,741.74 Department number: Board of Directors 22,661.00 22,881.00 539.71 8,139.26 35.572 14,741.74 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 35,093.78 318,804.24 69.499 139,916.76 135-50010-030-000 Overtime 500.00 750.00 69.04 745.75 99.433 4.25 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,157.62 29,944.67 72.297 11,474.33 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,804.81 42,160.09 72.786 15,762.91 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 3,107.45 60.930 1,992.55 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 737.31 67.830 349.69 135-50029-030-000 Life Insurance & Other 4,483.00 5,500.00 314.41 3,563.91 64.798 1,936.09 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,046.39 19,543.10 68.192 9,115.90 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 478.59 4,570.57 68.197 2,131.43 135-50040-030-000 Unemployment Taxes 63.00 1,449.00 1,449.00 100.000 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.62 1,157.65 73.502 417.35 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 18.75 2,732.68 54.654 2,267.32 Subtotal: 614,450.00 617,103.00 46,534.05 431,593.92 69.939 185,509.08 135-55030-030-000 Software & Support 59,698.00 59,698.00 4,886.48 42,386.80 71.002 17,311.20 135-55070-030-000 Independent Labor 7,700.00 7,000.00 1,252.50 8,400.48 120.007 1,400.48- 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 428.45 9.521 4,071.55 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 279.05 2,587.16 39.802 3,912.84 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 12,759.76 66.665 6,380.24 135-55160-030-000 Professional Outside Services 15,000.00 10,000.00 10,000.00 135-55161-030-000 Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 5,825.41 85.567 982.59 Subtotal: 196,594.00 190,894.00 8,013.00 149,436.06 78.282 41,457.94 135-60005-030-000 Telephone 11,250.00 11,250.00 1,960.71 9,607.16 85.397 1,642.84 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 4,057.00 478.49 2,664.60 65.679 1,392.40 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 2,964.55 11,834.10 78.005 3,336.90 135-60025-030-000 Water 1,500.00 1,500.00 91.06 710.14 47.343 789.86 135-60035-030-000 Postage 28,500.00 28,500.00 1,570.62 18,720.67 65.687 9,779.33 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 3,176.73 23,394.25 82.578 4,935.75 135-60050-030-000 Bad Debt Expense 1,500.00 6,200.00 198.24 4,351.64 70.188 1,848.36 135-60055-030-000 Insurance 53,561.00 53,561.00 4,469.73 38,755.82 72.358 14,805.18 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 300.00 4,311.95 95.821 188.05 135-60075-030-000 Meetings 400.00 400.00 27.26 6.815 372.74 135-60079-030-000 Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030-000 Schools & Training 7,500.00 6,800.00 2,849.25 41.901 3,950.75 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 925.14 2,408.50 48.170 2,591.50 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 2,500.00 2,500.00 1,859.80 3,709.19 148.368 1,209.19- 135-60125-030-000 Advertising 2,500.00 2,500.00 589.43 23.577 1,910.57 135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 17,870.00 1,579.90 1,956.15 10.947 15,913.85 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,563.55 102.542 63.55- Subtotal: 204,221.00 208,689.00 19,574.97 129,253.13 61.936 79,435.87 135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 5,176.88 7,365.90 54.313 6,196.10 135-65085-030-000 Office Supplies 9,100.00 9,100.00 464.08 3,560.38 39.125 5,539.62 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,248.45 3,651.92 63.711 2,080.08 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 403.63 2,240.99 89.640 259.01 135-65097-030-000 Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030-000 Printing 4,000.00 4,000.00 1,076.00 3,424.27 85.607 575.73 Subtotal: 36,484.00 36,484.00 8,369.04 21,319.32 58.435 15,164.68 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 385.28 1,926.39 55.837 1,523.61 Subtotal: 3,450.00 3,450.00 385.28 1,926.39 55.837 1,523.61 Program number: 1,055,199.00 1,056,620.00 82,876.34 733,528.82 69.422 323,091.18 Department number: Administration 1,055,199.00 1,056,620.00 82,876.34 733,528.82 69.422 323,091.18 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 17:03 07/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 347,126.00 62,856.06 264,211.11 76.114 82,914.89 135-55055-039-000 Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 1,914.46 8,158.30 81.583 1,841.70 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 64,770.52 296,020.81 77.337 86,745.19 Program number: 166,940.00 382,766.00 64,770.52 296,020.81 77.337 86,745.19 Department number: Non Departmental 166,940.00 382,766.00 64,770.52 296,020.81 77.337 86,745.19 Expenditures Subtotal ----------- 6,417,937.00 7,303,424.00 481,944.68 4,320,517.85 59.157 2,982,906.15 Fund number: 135 MUD 1 General Fund 192,301.78- 264,879.19 264,879.19- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 17:03 07/08/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 6.54- 67.80- 67.80 507-49036-000-000 GASB Reserves 120,000.00- 120,000.00 Subtotal: 6.54- 120,067.80- 120,067.80 Program number: 6.54- 120,067.80- 120,067.80 Department number: 6.54- 120,067.80- 120,067.80 Revenues Subtotal ----------- 6.54- 120,067.80- 120,067.80 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 17:03 07/08/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 17:03 07/08/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 282,245.17 300.00 3,372.00 1.195 278,873.17 Subtotal: 282,245.17 300.00 3,372.00 1.195 278,873.17 Program number: 3 Indian Creek Waterline 282,245.17 300.00 3,372.00 1.195 278,873.17 Department number: Water 282,245.17 300.00 86,001.40 30.470 196,243.77 Expenditures Subtotal ----------- 282,245.17 300.00 86,001.40 30.470 196,243.77 Fund number: 507 MUD 1 Capital Projects 282,245.17 293.46 34,066.40- -12.070 316,311.57 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1629 06/02/2014 Property Taxes/Assessments (97,935.68) (44.45) (97,980.13) GL 1630 06/04/2014 Property Taxes/Assessments (3.12) (97,983.25) GL 1631 06/05/2014 Property Taxes/Assessments (20.56) (98,003.81) GL 1632 06/06/2014 Property Taxes/Assessments (132.29) (98,136.10) GL 1634 06/11/2014 Property Taxes/Assessments (21.86) (98,157.96) GL 1635 06/16/2014 Property Taxes/Assessments (2.94) (98,160.90) GL 1636 06/18/2014 Property Taxes/Assessments (6.86) (98,167.76) GL 1640 06/27/2014 Property Taxes/Assessments (4.52) (98,172.28) GL 1647 06/30/2014 Property Taxes/Assessments (12.68) (98,184.96) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (249.28) (98,184.96) ** (99,250.00) Budgeted (1,065.04) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1637 06/23/2014 Property Taxes/Assessments (129.55) (.06) (129.61) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.06) (129.61) ** .00 Budgeted 129.61 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1632 06/06/2014 Property Taxes/Assessments (493.55) (14.12) (507.67) GL 1634 06/11/2014 Property Taxes/Assessments (3.27) (510.94) GL 1635 06/16/2014 Property Taxes/Assessments (.44) (511.38) GL 1636 06/18/2014 Property Taxes/Assessments (.48) (511.86) GL 1637 06/23/2014 Property Taxes/Assessments (.04) (511.90) GL 1647 06/30/2014 Property Taxes/Assessments (1.91) (513.81) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.26) (513.81) ** (900.00) Budgeted (386.19) Remaining 57 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1531 06/02/2014 UB 6/2/14 Adj to 1108 Berkshir UB20140602-20140602 User: (1,694,225.89) 404.95 (1,693,820.94) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1617 06/20/2014 UB 6/20/14-PCF & Backflow fee UB20140620-20140620 User: (1,694,225.89) (100.00) (1,693,920.94) UB 1643 06/30/2014 UB 6/30/14 Billing UB20140630-20140630 User: (361,783.90) (2,055,704.84) UB _______________ Account: 135-47000-000-000 Water Totals: (361,478.95) (2,055,704.84) ** (3,749,310.00) Budgeted (1,693,605.16) Remaining 55 % Used Account: 135-47005-000-000 Sewer 1531 06/02/2014 UB 6/2/14 Adj to 1108 Berkshir UB20140602-20140602 User: (1,200,147.20) 165.00 (1,199,982.20) UB 1643 06/30/2014 UB 6/30/14 Billing UB20140630-20140630 User: (193,306.16) (1,393,288.36) UB _______________ Account: 135-47005-000-000 Sewer Totals: (193,141.16) (1,393,288.36) ** (1,708,321.00) Budgeted (315,032.64) Remaining 82 % Used Account: 135-47025-000-000 Penalties 1585 06/23/2014 UB 6/23/14 Penalites UB20140623-20140623 User: (31,778.82) (5,232.77) (37,011.59) UB 1587 06/23/2014 UB 6/23/2014 Penalties UB20140623-20140623 User: (4,154.72) (41,166.31) UB 1620 06/23/2014 UB 6/23/14 Penalty reversal UB20140623-20140623 User: 5,232.77 (35,933.54) UB 1628 06/30/2014 UB 6/30/14 Penalty removals UB20140630-20140630 User: 75.84 (35,857.70) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,078.88) (35,857.70) ** (64,522.00) Budgeted (28,664.30) Remaining 56 % Used Account: 135-47030-000-000 Service Charges 1607 06/01/2014 UB 6/1/14 After hours fee UB20140601-20140601 User: (5,874.00) (100.00) (5,974.00) UB 1510 06/10/2014 UB 6/10/14 Disconnect Fees UB20140610-20140610 User: (700.00) (6,674.00) UB 1610 06/16/2014 UB 6/16/14 NSF Check Fee UB20140616-20140616 User: (25.00) (6,699.00) UB 1615 06/19/2014 UB 6/19/14 NSF Check Fee UB20140619-20140619 User: (25.00) (6,724.00) UB 1627 06/27/2014 UB 6/27/14 After Hours Fee UB20140627-20140627 User: (100.00) (6,824.00) UB 1643 06/30/2014 UB 6/30/14 Billing UB20140630-20140630 User: (3.00) (6,827.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (953.00) (6,827.00) ** (9,075.00) Budgeted (2,248.00) Remaining 75 % Used Account: 135-47035-000-000 Plumbing Inspections 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (1,850.00) (100.00) (1,950.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,950.00) ** (2,000.00) Budgeted (50.00) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (5,850.00) (300.00) (6,150.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (6,150.00) ** (5,000.00) Budgeted 1,150.00 Remaining 123 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1643 06/30/2014 UB 6/30/14 Billing UB20140630-20140630 User: (27,166.68) (11,235.70) (38,402.38) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (11,235.70) (38,402.38) ** (79,586.00) Budgeted (41,183.62) Remaining 48 % Used Account: 135-48005-000-000 Utility Fees 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (234,600.00) (25,300.00) (259,900.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (25,300.00) (259,900.00) ** (582,109.00) Budgeted (322,209.00) Remaining 45 % Used Account: 135-49010-000-000 Interest Income 1563 06/06/2014 PID Connection Interest (4,029.71) (70,700.00) (74,729.71) GL 1657 06/30/2014 Bank Interest/June (44.38) (74,774.09) GL 1657 06/30/2014 Bank Interest/June (47.90) (74,821.99) GL 1668 06/30/2014 Bank Interest/Bank of the West (408.51) (75,230.50) GL 1679 06/30/2014 Rev Interest/Bank of the West 408.51 (74,821.99) GL 1680 06/30/2014 Bank of West MM Interest (408.51) (75,230.50) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (71,200.79) (75,230.50) ** (4,800.00) Budgeted 70,430.50 Remaining ########## Account: 135-49016-000-000 Cell Tower Revenue 1561 06/06/2014 AT&T Tower Lease (7,284.24) (910.53) (8,194.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (8,194.77) ** (10,164.00) Budgeted (1,969.23) Remaining 81 % Used Account: 135-49018-000-000 Building Rent Income 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (4,666.64) (583.33) (5,249.97) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-49030-000-000 Vending Revenue 1560 06/05/2014 Vending (Adrian) (146.00) (80.85) (226.85) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (80.85) (226.85) ** (350.00) Budgeted (123.15) Remaining 65 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (880,000.00) Budgeted (880,000.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (59,886.80) (4,459.00) (64,345.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,459.00) (64,345.80) ** (84,000.00) Budgeted (19,654.20) Remaining 77 % Used Account: 135-49900-000-000 Miscellaneous Income 1564 06/16/2014 TAD 2013 Allocation refund\ (1,158.08) (68.28) (1,226.36) GL 1617 06/20/2014 UB 6/20/14-PCF & Backflow fee UB20140620-20140620 User: (50.00) (1,276.36) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (118.28) (1,276.36) ** (3,000.00) Budgeted (1,723.64) Remaining 43 % Used Account: 135-49901-000-000 Records Management Revenue 1562 06/06/2014 Open Records/Rose, Kniffen (36.39) (36.39) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (36.39) (36.39) ** (100.00) Budgeted (63.61) Remaining 36 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** (4,087.00) Budgeted .00 Remaining 100 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,055,638.66) ** (7,303,424.00) Budgeted (3,247,785.34) Remaining 56 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 1466 06/06/2014 Payroll 6/6/14 Salaries & Wages 173,077.95 11,069.34 184,147.29 PR 1541 06/20/2014 MUD Payroll 6/20/14 Salaries & Wages 11,069.33 195,216.62 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,138.67 195,216.62 ** 287,709.00 Budgeted 92,492.38 Remaining 68 % Used Account: 135-50010-010-000 Overtime 1466 06/06/2014 Payroll 6/6/14 Overtime 13,108.22 555.50 13,663.72 PR 1541 06/20/2014 MUD Payroll 6/20/14 Overtime 544.71 14,208.43 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,100.21 14,208.43 ** 16,391.00 Budgeted 2,182.57 Remaining 87 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1541 06/20/2014 MUD Payroll 6/20/14 Certification 2,775.00 375.00 3,150.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 3,150.00 ** 5,100.00 Budgeted 1,950.00 Remaining 62 % Used Account: 135-50020-010-000 Retirement 1466 06/06/2014 Payroll 6/6/14 Retirement 17,853.15 1,043.90 18,897.05 PR 1541 06/20/2014 MUD Payroll 6/20/14 Retirement 1,076.62 19,973.67 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,120.52 19,973.67 ** 27,847.00 Budgeted 7,873.33 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 1466 06/06/2014 Payroll 6/6/14 Medical Insurance 26,260.53 1,780.02 28,040.55 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medical Insurance 1,779.96 29,820.51 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,559.98 29,820.51 ** 48,334.00 Budgeted 18,513.49 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1466 06/06/2014 Payroll 6/6/14 Dental Insurance 1,926.09 124.54 2,050.63 PR 1541 06/20/2014 MUD Payroll 6/20/14 Dental Insurance 124.58 2,175.21 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 2,175.21 ** 3,932.00 Budgeted 1,756.79 Remaining 55 % Used Account: 135-50028-010-000 Vision Insurance 1466 06/06/2014 Payroll 6/6/14 Vision Insurance 470.02 31.49 501.51 PR 1541 06/20/2014 MUD Payroll 6/20/14 Vision Insurance 31.54 533.05 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 533.05 ** 873.00 Budgeted 339.95 Remaining 61 % Used Account: 135-50029-010-000 Life Insurance & Other 1440 06/01/2014 June Dental & Other , Vision June Dental & Other, Vision 1,675.26 223.17 1,898.43 METLIFE 33818 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 223.17 1,898.43 ** 3,306.00 Budgeted 1,407.57 Remaining 57 % Used Account: 135-50030-010-000 Social Security Taxes 1466 06/06/2014 Payroll 6/6/14 Social Security Taxes 12,349.96 718.90 13,068.86 PR 1541 06/20/2014 MUD Payroll 6/20/14 Social Security Taxes 740.36 13,809.22 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,459.26 13,809.22 ** 19,289.00 Budgeted 5,479.78 Remaining 72 % Used Account: 135-50035-010-000 Medicare Taxes 1466 06/06/2014 Payroll 6/6/14 Medicare Taxes 2,888.30 168.13 3,056.43 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medicare Taxes 173.15 3,229.58 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 341.28 3,229.58 ** 4,511.00 Budgeted 1,281.42 Remaining 72 % Used Account: 135-50040-010-000 Unemployment Taxes 1,244.44 .00 1,244.44 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 1,244.44 ** 1,244.00 Budgeted (.44) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-010-000 Workman's Compensation 56 06/01/2014 Jun Ins & W/C Expense 6,419.60 802.45 7,222.05 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 7,222.05 ** 9,829.00 Budgeted 2,606.95 Remaining 73 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1567 06/20/2014 June A/P Employee Testing 233.90 63.00 296.90 CARENOW CORPORATE 33884 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 63.00 296.90 ** 350.00 Budgeted 53.10 Remaining 85 % Used Account: 135-50070-010-000 Employee Relations 1683 06/26/2014 June A/P SALAD BOWL #10 161.78 18.75 180.53 SALAD BOWL #10 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 18.75 180.53 ** 300.00 Budgeted 119.47 Remaining 60 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1567 06/20/2014 June A/P Meters and Misc brass fittings 45,963.28 825.64 46,788.92 ATLAS UTILITY SUPPLY CO. 33882 AP 1683 06/26/2014 June A/P MACARTHUR GAUGE INC 50.00 46,838.92 MACARTHUR GAUGE INC PC 1683 06/26/2014 June A/P ROANOKE AUTO SUPPLY LT 65.96 46,904.88 ROANOKE AUTO SUPPLY LT PC 1683 06/26/2014 June A/P SHERWIN WILLIAMS #7495 606.32 47,511.20 SHERWIN WILLIAMS #7495 PC 1683 06/26/2014 June A/P THE HOME DEPOT 6581 74.00 47,585.20 THE HOME DEPOT 6581 PC 1681 06/30/2014 June A/P meter boxes and angle stops 3,091.76 50,676.96 HD SUPPLY WATERWORKS, LTD. AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 4,713.68 50,676.96 ** 61,000.00 Budgeted 10,323.04 Remaining 83 % Used Account: 135-55090-010-000 Vehicle Maintenance 1487 06/06/2014 June A/P Truck 103 Repair fuel tank 2,479.60 432.49 2,912.09 MICHAEL G. WATSON 33859 AP 1487 06/06/2014 June A/P Tow Truck to Watson's for Fuel 101.00 3,013.09 HIGHT MARINE PRODUCTS INC 33846 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 533.49 3,013.09 ** 5,000.00 Budgeted 1,986.91 Remaining 60 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 248.33 .00 248.33 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 ** 2,500.00 Budgeted 2,251.67 Remaining 10 % Used Account: 135-55135-010-000 Lab Analysis 1567 06/20/2014 June A/P Testing 2,913.91 195.26 3,109.17 LOWER COLORADO RIVER AUTHORITY 33896 AP 1683 06/26/2014 June A/P HACH COMPANY 172.07 3,281.24 HACH COMPANY PC _______________ Account: 135-55135-010-000 Lab Analysis Totals: 367.33 3,281.24 ** 5,500.00 Budgeted 2,218.76 Remaining 60 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 2,681.45 383.48 3,064.93 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 382.90 3,447.83 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 766.38 3,447.83 ** 4,913.00 Budgeted 1,465.17 Remaining 70 % Used Account: 135-60020-010-000 Electricity 1567 06/20/2014 June A/P Electricity 5/13-6/13/14 69,811.73 14,033.18 83,844.91 HUDSON ENERGY SERVICES, LLC 33889 AP 1567 06/20/2014 June A/P Electricity 5/13-6/13/14 3,734.87 87,579.78 HUDSON ENERGY SERVICES, LLC 33889 AP 1567 06/20/2014 June A/P Electricity 5/12-6/12/14 78.23 87,658.01 HUDSON ENERGY SERVICES, LLC 33889 AP _______________ Account: 135-60020-010-000 Electricity Totals: 17,846.28 87,658.01 ** 155,160.00 Budgeted 67,501.99 Remaining 56 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1681 06/30/2014 June A/P AWWA Standards 2,715.66 2,715.66 AMERICAN WATER WORKS ASSOC AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 2,715.66 2,715.66 ** 2,538.00 Budgeted (177.66) Remaining 107 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 300.00 Budgeted 11.00 Remaining 96 % Used Account: 135-60080-010-000 Schools & Training 1683 06/26/2014 June A/P TCEQ IND RENEWAL L 1,334.00 111.00 1,445.00 TCEQ IND RENEWAL L PC 1683 06/26/2014 June A/P TCEQ IND RENEWAL L 111.00 1,556.00 TCEQ IND RENEWAL L PC 1681 06/30/2014 June A/P Buy one/get one free TCEQ CEUs 115.00 1,671.00 PRO-LINE PUBLICATIONS AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 337.00 1,671.00 ** 1,500.00 Budgeted (171.00) Remaining 111 % Used Account: 135-60100-010-000 Travel & per diem 172.63 .00 172.63 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 172.63 ** 279.00 Budgeted 106.37 Remaining 62 % Used Account: 135-60105-010-000 Rent/Lease Equipment 60.00 .00 60.00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 60.00 ** 500.00 Budgeted 440.00 Remaining 12 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 32,463.59 .00 32,463.59 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 32,463.59 ** 47,400.00 Budgeted 14,936.41 Remaining 68 % Used Account: 135-60150-010-000 Wholesale Water 1681 06/30/2014 June A/P Wholesale Water/May 951,112.79 194,520.44 1,145,633.23 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 194,520.44 1,145,633.23 ** 2,338,473.00 Budgeted 1,192,839.77 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-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 1,289.55 .00 1,289.55 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 1,289.55 ** 3,500.00 Budgeted 2,210.45 Remaining 37 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 1,664.20 .00 1,664.20 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,664.20 ** 2,000.00 Budgeted 335.80 Remaining 83 % Used Account: 135-65005-010-000 Fuel & Lube 1652 06/30/2014 June Gas Log 8,444.30 1,183.43 9,627.73 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,183.43 9,627.73 ** 22,181.00 Budgeted 12,553.27 Remaining 43 % Used Account: 135-65010-010-000 Uniforms 1,938.58 .00 1,938.58 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,938.58 ** 2,500.00 Budgeted 561.42 Remaining 78 % Used Account: 135-65030-010-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1503 06/09/2014 June A/P Chemicals 3,977.27 341.27 4,318.54 HACH COMPANY 33841 AP 1503 06/09/2014 June A/P Lab test supplies 172.07 4,490.61 HACH COMPANY 33841 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 513.34 4,490.61 ** 5,000.00 Budgeted 509.39 Remaining 90 % Used Account: 135-65035-010-000 Small Tools 490.92 .00 490.92 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 490.92 ** 1,200.00 Budgeted 709.08 Remaining 41 % Used Account: 135-65040-010-000 Safety Equipment 344.55 .00 344.55 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 344.55 ** 1,000.00 Budgeted 655.45 Remaining 34 % Used Account: 135-65050-010-000 Meter Expense 1567 06/20/2014 June A/P Meters and Misc brass fittings 66,341.04 2,519.00 68,860.04 ATLAS UTILITY SUPPLY CO. 33882 AP 1681 06/30/2014 June A/P 47 Orions for Fire lines 7,285.00 76,145.04 ATLAS UTILITY SUPPLY CO. AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 9,804.00 76,145.04 ** 143,550.00 Budgeted 67,404.96 Remaining 53 % Used Account: 135-69005-010-000 Capital Outlays 35,679.59 .00 35,679.59 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 35,679.59 ** 35,681.00 Budgeted 1.41 Remaining 100 % Used Account: 135-69008-010-000 Short Term Debt-Principal 122,980.00 .00 122,980.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 122,980.00 ** 489,980.00 Budgeted 367,000.00 Remaining 25 % Used Account: 135-69009-010-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 11,621.26 .00 11,621.26 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 11,621.26 ** 19,268.00 Budgeted 7,646.74 Remaining 60 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 100,816.54 ** 100,847.00 Budgeted 30.46 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 1681 06/30/2014 June A/P DBP #2 Testing/PID 2,644.61 97.63 2,742.24 LOWER COLORADO RIVER AUTHORITY AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 97.63 2,742.24 ** 2,000.00 Budgeted (742.24) Remaining 137 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,496.19 .00 2,496.19 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,496.19 ** 5,000.00 Budgeted 2,503.81 Remaining 50 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,001,521.21 ** 3,899,140.00 Budgeted 1,897,618.79 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 1466 06/06/2014 Payroll 6/6/14 Salaries & Wages 125,041.37 7,785.51 132,826.88 PR 1541 06/20/2014 MUD Payroll 6/20/14 Salaries & Wages 7,775.68 140,602.56 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,561.19 140,602.56 ** 202,894.00 Budgeted 62,291.44 Remaining 69 % Used Account: 135-50010-020-000 Overtime 1466 06/06/2014 Payroll 6/6/14 Overtime 9,813.39 302.43 10,115.82 PR 1541 06/20/2014 MUD Payroll 6/20/14 Overtime .77 10,116.59 PR _______________ Account: 135-50010-020-000 Overtime Totals: 303.20 10,116.59 ** 11,965.00 Budgeted 1,848.41 Remaining 85 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1541 06/20/2014 MUD Payroll 6/20/14 Certification 3,200.00 400.00 3,600.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 3,600.00 ** 4,800.00 Budgeted 1,200.00 Remaining 75 % Used Account: 135-50020-020-000 Retirement 1466 06/06/2014 Payroll 6/6/14 Retirement 13,134.85 726.29 13,861.14 PR 1541 06/20/2014 MUD Payroll 6/20/14 Retirement 734.24 14,595.38 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,460.53 14,595.38 ** 19,905.00 Budgeted 5,309.62 Remaining 73 % Used Account: 135-50026-020-000 Medical Insurance 1466 06/06/2014 Payroll 6/6/14 Medical Insurance 26,961.32 1,713.39 28,674.71 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medical Insurance 1,713.37 30,388.08 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,426.76 30,388.08 ** 43,471.00 Budgeted 13,082.92 Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1466 06/06/2014 Payroll 6/6/14 Dental Insurance 1,736.28 105.68 1,841.96 PR 1541 06/20/2014 MUD Payroll 6/20/14 Dental Insurance 105.70 1,947.66 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,947.66 ** 2,989.00 Budgeted 1,041.34 Remaining 65 % Used Account: 135-50028-020-000 Vision Insurance 1466 06/06/2014 Payroll 6/6/14 Vision Insurance 406.09 25.61 431.70 PR 1541 06/20/2014 MUD Payroll 6/20/14 Vision Insurance 25.65 457.35 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 457.35 ** 658.00 Budgeted 200.65 Remaining 70 % Used Account: 135-50029-020-000 Life Insurance & Other 1440 06/01/2014 June Dental & Other , Vision June Dental & Other, Vision 1,452.84 158.73 1,611.57 METLIFE 33818 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 158.73 1,611.57 ** 2,303.00 Budgeted 691.43 Remaining 70 % Used Account: 135-50030-020-000 Social Security Taxes 1466 06/06/2014 Payroll 6/6/14 Social Security Taxes 8,008.68 433.38 8,442.06 PR 1541 06/20/2014 MUD Payroll 6/20/14 Social Security Taxes 420.87 8,862.93 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 854.25 8,862.93 ** 13,805.00 Budgeted 4,942.07 Remaining 64 % Used Account: 135-50035-020-000 Medicare Taxes 1466 06/06/2014 Payroll 6/6/14 Medicare Taxes 1,873.00 101.34 1,974.34 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medicare Taxes 98.43 2,072.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 199.77 2,072.77 ** 3,229.00 Budgeted 1,156.23 Remaining 64 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-020-000 Workman's Compensation 56 06/01/2014 Jun Ins & W/C Expense 4,280.64 535.08 4,815.72 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 4,815.72 ** 6,552.00 Budgeted 1,736.28 Remaining 74 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 1683 06/26/2014 June A/P SALAD BOWL #10 59.99 18.75 78.74 SALAD BOWL #10 PC 1683 06/26/2014 June A/P WAL-MART #5247 7.53 86.27 WAL-MART #5247 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 26.28 86.27 ** 350.00 Budgeted 263.73 Remaining 25 % Used Account: 135-55070-020-000 Independent Labor 606,301.95 .00 606,301.95 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 606,301.95 ** 880,000.00 Budgeted 273,698.05 Remaining 69 % Used Account: 135-55080-020-000 Maintenance & Repairs 1567 06/20/2014 June A/P Impeller 27,846.73 2,540.30 30,387.03 XYLEM WATER SOLUTIONS USA INC 33911 AP 1567 06/20/2014 June A/P Scada troubleshooting/repair 3,473.50 33,860.53 Prime Controls, LP 33902 AP 1683 06/26/2014 June A/P THREE L WELDING SUPPLY 62.50 33,923.03 THREE L WELDING SUPPLY PC 1683 06/26/2014 June A/P THE HOME DEPOT 6581 164.33 34,087.36 THE HOME DEPOT 6581 PC 1683 06/26/2014 June A/P WAL-MART #5247 13.97 34,101.33 WAL-MART #5247 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,254.60 34,101.33 ** 36,120.00 Budgeted 2,018.67 Remaining 94 % Used Account: 135-55090-020-000 Vehicle Maintenance 1683 06/26/2014 June A/P AUTOZONE #4206 1,652.49 12.99 1,665.48 AUTOZONE #4206 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 12.99 1,665.48 ** 2,000.00 Budgeted 334.52 Remaining 83 % Used Account: 135-55125-020-000 Dumpster Services 1567 06/20/2014 June A/P Sludge haul off 34,712.35 1,861.38 36,573.73 L.H. CHANEY MATERIALS, INC. 33893 AP 1567 06/20/2014 June A/P Sludge haul off 969.34 37,543.07 L.H. CHANEY MATERIALS, INC. 33893 AP 1567 06/20/2014 June A/P Sludge haul off 929.92 38,472.99 L.H. CHANEY MATERIALS, INC. 33893 AP 1681 06/30/2014 June A/P Sludge haul off 2,822.61 41,295.60 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 6,583.25 41,295.60 ** 47,000.00 Budgeted 5,704.40 Remaining 88 % Used Account: 135-55135-020-000 Lab Analysis 1567 06/20/2014 June A/P Testing 18,805.26 246.00 19,051.26 OXIDOR LABORATORIES LLC 33900 AP 1567 06/20/2014 June A/P Testing 176.00 19,227.26 OXIDOR LABORATORIES LLC 33900 AP 1567 06/20/2014 June A/P Testing 246.00 19,473.26 OXIDOR LABORATORIES LLC 33900 AP 1567 06/20/2014 June A/P Testing 176.00 19,649.26 OXIDOR LABORATORIES LLC 33900 AP 1567 06/20/2014 June A/P Testing 246.00 19,895.26 OXIDOR LABORATORIES LLC 33900 AP 1660 06/30/2014 Recode Oxidor/Soil Sample TCCC (1,109.18) 18,786.08 GL _______________ Account: 135-55135-020-000 Lab Analysis Totals: (19.18) 18,786.08 ** 30,000.00 Budgeted 11,213.92 Remaining 63 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 1,925.62 206.84 2,132.46 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 306.24 2,438.70 TOWN OF TROPHY CLUB 33906 AP 1681 06/30/2014 June A/P RDM+ Remote Desktop for MAC an 10.81 2,449.51 Karl Schlielig AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 523.89 2,449.51 ** 3,329.00 Budgeted 879.49 Remaining 74 % Used Account: 135-60020-020-000 Electricity 1681 06/30/2014 June A/P Electricity 5/13-6/13/14 67,995.02 10,631.45 78,626.47 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,631.45 78,626.47 ** 138,227.00 Budgeted 59,600.53 Remaining 57 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 351.00 .00 351.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1683 06/26/2014 June A/P TARRANT COUNTY COLLEGE 1,087.00 260.00 1,347.00 TARRANT COUNTY COLLEGE PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 260.00 1,347.00 ** 1,636.00 Budgeted 289.00 Remaining 82 % Used Account: 135-60090-020-000 Safety Program 474.07 .00 474.07 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 474.07 ** 500.00 Budgeted 25.93 Remaining 95 % Used Account: 135-60100-020-000 Travel & per diem 1,085.11 .00 1,085.11 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 1,085.11 ** 1,050.00 Budgeted (35.11) Remaining 103 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60243-020-000 Prior Year Expense 3,554.22 .00 3,554.22 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 3,554.22 ** 3,554.00 Budgeted (.22) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,079.10 .00 1,079.10 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,079.10 ** 1,079.00 Budgeted (.10) Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 1652 06/30/2014 June Gas Log 7,188.30 1,136.67 8,324.97 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,136.67 8,324.97 ** 13,600.00 Budgeted 5,275.03 Remaining 61 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals 1567 06/20/2014 June A/P Clarifloc C 17,572.10 1,080.00 18,652.10 POLYDYNE, INC 33901 AP 1567 06/20/2014 June A/P Calc Hypochlorite 2,240.00 20,892.10 HARCROS CHEMICALS INC 33888 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: 3,320.00 20,892.10 ** 31,000.00 Budgeted 10,107.90 Remaining 67 % Used Account: 135-65035-020-000 Small Tools 177.09 .00 177.09 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 177.09 ** 300.00 Budgeted 122.91 Remaining 59 % Used Account: 135-65040-020-000 Safety Equipment 1681 06/30/2014 June A/P Supplies for medicine cabinet/ 230.63 47.23 277.86 CINTAS CORPORATION NO. 2 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 47.23 277.86 ** 500.00 Budgeted 222.14 Remaining 56 % Used Account: 135-65045-020-000 Lab Supplies 1567 06/20/2014 June A/P Gloves 9,519.75 162.00 9,681.75 LOU'S GLOVES INCORPORATED 33895 AP 1683 06/26/2014 June A/P HACH COMPANY 322.27 10,004.02 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 484.27 10,004.02 ** 15,000.00 Budgeted 4,995.98 Remaining 67 % Used Account: 135-69008-020-000 Short Term Debt-Principal 20,020.00 .00 20,020.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1,043.70 .00 1,043.70 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 1,043.70 ** 1,422.00 Budgeted 378.30 Remaining 73 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,085,557.84 ** 1,564,486.00 Budgeted 478,928.16 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 1466 06/06/2014 Payroll 6/6/14 Salaries & Wages 46,914.21 3,434.65 50,348.86 PR 1541 06/20/2014 MUD Payroll 6/20/14 Salaries & Wages 3,434.65 53,783.51 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,869.30 53,783.51 ** 90,299.00 Budgeted 36,515.49 Remaining 60 % Used Account: 135-50010-021-000 Overtime 1466 06/06/2014 Payroll 6/6/14 Overtime 3,173.82 452.92 3,626.74 PR 1541 06/20/2014 MUD Payroll 6/20/14 Overtime 713.15 4,339.89 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,166.07 4,339.89 ** 10,028.00 Budgeted 5,688.11 Remaining 43 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 2,108.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1541 06/20/2014 MUD Payroll 6/20/14 Certification 1,200.00 150.00 1,350.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,350.00 ** 1,800.00 Budgeted 450.00 Remaining 75 % Used Account: 135-50020-021-000 Retirement 1466 06/06/2014 Payroll 6/6/14 Retirement 5,149.92 349.11 5,499.03 PR 1541 06/20/2014 MUD Payroll 6/20/14 Retirement 385.93 5,884.96 PR _______________ Account: 135-50020-021-000 Retirement Totals: 735.04 5,884.96 ** 9,025.00 Budgeted 3,140.04 Remaining 65 % Used Account: 135-50026-021-000 Medical Insurance 1466 06/06/2014 Payroll 6/6/14 Medical Insurance 12,621.29 736.86 13,358.15 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medical Insurance 736.84 14,094.99 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 14,094.99 ** 23,668.00 Budgeted 9,573.01 Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 1466 06/06/2014 Payroll 6/6/14 Dental Insurance 915.39 51.30 966.69 PR 1541 06/20/2014 MUD Payroll 6/20/14 Dental Insurance 51.30 1,017.99 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 1,017.99 ** 1,703.00 Budgeted 685.01 Remaining 60 % Used Account: 135-50028-021-000 Vision Insurance 1466 06/06/2014 Payroll 6/6/14 Vision Insurance 194.25 11.84 206.09 PR 1541 06/20/2014 MUD Payroll 6/20/14 Vision Insurance 11.84 217.93 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 217.93 ** 314.00 Budgeted 96.07 Remaining 69 % Used Account: 135-50029-021-000 Life Insurance & Other 1440 06/01/2014 June Dental & Other , Vision June Dental & Other, Vision 684.99 72.75 757.74 METLIFE 33818 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 72.75 757.74 ** 1,066.00 Budgeted 308.26 Remaining 71 % Used Account: 135-50030-021-000 Social Security Taxes 1466 06/06/2014 Payroll 6/6/14 Social Security Taxes 3,224.08 225.56 3,449.64 PR 1541 06/20/2014 MUD Payroll 6/20/14 Social Security Taxes 251.90 3,701.54 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 477.46 3,701.54 ** 7,442.00 Budgeted 3,740.46 Remaining 50 % Used Account: 135-50035-021-000 Medicare Taxes 1466 06/06/2014 Payroll 6/6/14 Medicare Taxes 754.02 52.75 806.77 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medicare Taxes 58.91 865.68 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 111.66 865.68 ** 1,741.00 Budgeted 875.32 Remaining 50 % Used Account: 135-50040-021-000 Unemployment Taxes 414.00 .00 414.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 414.00 ** 414.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-021-000 Workman's Compensation 56 06/01/2014 Jun Ins & W/C Expense 2,140.32 267.54 2,407.86 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 2,407.86 ** 3,276.00 Budgeted 868.14 Remaining 74 % Used Account: 135-50070-021-000 Employee Relations 1683 06/26/2014 June A/P SALAD BOWL #10 132.02 18.75 150.77 SALAD BOWL #10 PC 1683 06/26/2014 June A/P SALAD BOWL #10 58.46 209.23 SALAD BOWL #10 PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 77.21 209.23 ** 200.00 Budgeted (9.23) Remaining 105 % Used Account: 135-55080-021-000 Maintenance & Repairs 1567 06/20/2014 June A/P GapVax Blower, water pump, wat 7,016.24 1,017.62 8,033.86 UNDERGROUND INC 33909 AP 1683 06/26/2014 June A/P THE HOME DEPOT 6581 20.36 8,054.22 THE HOME DEPOT 6581 PC 1683 06/26/2014 June A/P THE HOME DEPOT 6581 8.42 8,062.64 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,046.40 8,062.64 ** 14,451.00 Budgeted 6,388.36 Remaining 56 % Used Account: 135-55090-021-000 Vehicle Maintenance 999.18 .00 999.18 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 999.18 ** 2,000.00 Budgeted 1,000.82 Remaining 50 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 891.80 102.72 994.52 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 102.52 1,097.04 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 205.24 1,097.04 ** 1,333.00 Budgeted 235.96 Remaining 82 % Used Account: 135-60020-021-000 Electricity 1567 06/20/2014 June A/P Electricity 4/30-5/30 13,668.60 485.19 14,153.79 TRI COUNTY ELECTRIC 33907 AP 1567 06/20/2014 June A/P Eletricity 4/30-5/30 250.23 14,404.02 TRI COUNTY ELECTRIC 33907 AP 1567 06/20/2014 June A/P Elec 4/30-5/30 28.51 14,432.53 TRI COUNTY ELECTRIC 33907 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1567 06/20/2014 June A/P Electricity 5/12-6/13/14 13,668.60 494.74 14,927.27 HUDSON ENERGY SERVICES, LLC 33889 AP 1567 06/20/2014 June A/P Electricity 5/12-6/12/14 61.80 14,989.07 HUDSON ENERGY SERVICES, LLC 33889 AP 1567 06/20/2014 June A/P Electricity 5/12-6/12/14 40.44 15,029.51 HUDSON ENERGY SERVICES, LLC 33889 AP 1567 06/20/2014 June A/P Electricity 5/13-6/13/14 90.94 15,120.45 HUDSON ENERGY SERVICES, LLC 33889 AP 1681 06/30/2014 June A/P Electricity 5/13-6/13/14 293.17 15,413.62 HUDSON ENERGY SERVICES, LLC AP 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (75.68) 15,337.94 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,669.34 15,337.94 ** 21,178.00 Budgeted 5,840.06 Remaining 72 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 1683 06/26/2014 June A/P TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-021-000 Schools & Training Totals: 111.00 111.00 ** 911.00 Budgeted 800.00 Remaining 12 % Used Account: 135-60090-021-000 Safety Program 35.34 .00 35.34 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 35.34 ** 300.00 Budgeted 264.66 Remaining 12 % Used Account: 135-60100-021-000 Travel & per diem 38.49 .00 38.49 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 38.49 ** 250.00 Budgeted 211.51 Remaining 15 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1652 06/30/2014 June Gas Log 8,007.00 862.42 8,869.42 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 862.42 8,869.42 ** 21,747.00 Budgeted 12,877.58 Remaining 41 % Used Account: 135-65010-021-000 Uniforms 814.23 .00 814.23 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 814.23 ** 1,040.00 Budgeted 225.77 Remaining 78 % Used Account: 135-65030-021-000 Chemicals 300.89 .00 300.89 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 300.89 ** 2,000.00 Budgeted 1,699.11 Remaining 15 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 300.00 Budgeted 256.01 Remaining 15 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 114,000.00 Budgeted 45,699.80 Remaining 60 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 195,749.91 ** 377,531.00 Budgeted 181,781.09 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 1466 06/06/2014 Payroll 6/6/14 Salaries & Wages 6,100.00 400.00 6,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 400.00 6,500.00 ** 10,000.00 Budgeted 3,500.00 Remaining 65 % Used Account: 135-50030-026-000 Social Security Taxes 1466 06/06/2014 Payroll 6/6/14 Social Security Taxes 378.20 24.80 403.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 24.80 403.00 ** 620.00 Budgeted 217.00 Remaining 65 % Used Account: 135-50035-026-000 Medicare Taxes 1466 06/06/2014 Payroll 6/6/14 Medicare Taxes 88.45 5.80 94.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 5.80 94.25 ** 145.00 Budgeted 50.75 Remaining 65 % Used Account: 135-50040-026-000 Unemployment Taxes 1466 06/06/2014 Payroll 6/6/14 Unemployment Taxes 85.30 9.20 94.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 9.20 94.50 ** 230.00 Budgeted 135.50 Remaining 41 % Used Account: 135-50045-026-000 Workman's Compensation 56 06/01/2014 Jun Ins & W/C Expense 23.59 2.94 26.53 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 26.53 ** 36.00 Budgeted 9.47 Remaining 74 % 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 #1 Page 41 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 1486 06/06/2014 June A/P Meeting with Tan Parker 35.95 60.72 96.67 James Moss 33850 AP 1683 06/26/2014 June A/P SUBWAY 00217794 21.27 117.94 SUBWAY 00217794 PC 1683 06/26/2014 June A/P RANDALLS STORE00017897 14.98 132.92 RANDALLS STORE00017897 PC _______________ Account: 135-60075-026-000 Meetings Totals: 96.97 132.92 ** 1,200.00 Budgeted 1,067.08 Remaining 11 % Used Account: 135-60080-026-000 Schools & Training 632.00 .00 632.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 632.00 ** 4,000.00 Budgeted 3,368.00 Remaining 16 % Used Account: 135-60100-026-000 Travel & per diem 41.66 .00 41.66 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 41.66 ** 5,000.00 Budgeted 4,958.34 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 179.40 .00 179.40 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 179.40 ** 1,000.00 Budgeted 820.60 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 8,139.26 ** 22,881.00 Budgeted 14,741.74 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 1466 06/06/2014 Payroll 6/6/14 Salaries & Wages 283,710.46 17,546.90 301,257.36 PR 1541 06/20/2014 MUD Payroll 6/20/14 Salaries & Wages 17,546.88 318,804.24 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,093.78 318,804.24 ** 458,721.00 Budgeted 139,916.76 Remaining 69 % Used Account: 135-50010-030-000 Overtime 1466 06/06/2014 Payroll 6/6/14 Overtime 676.71 43.65 720.36 PR 1541 06/20/2014 MUD Payroll 6/20/14 Overtime 25.39 745.75 PR _______________ Account: 135-50010-030-000 Overtime Totals: 69.04 745.75 ** 750.00 Budgeted 4.25 Remaining 99 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 1466 06/06/2014 Payroll 6/6/14 Retirement 26,787.05 1,579.65 28,366.70 PR 1541 06/20/2014 MUD Payroll 6/20/14 Retirement 1,577.97 29,944.67 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,157.62 29,944.67 ** 41,419.00 Budgeted 11,474.33 Remaining 72 % Used Account: 135-50026-030-000 Medical Insurance 1466 06/06/2014 Payroll 6/6/14 Medical Insurance 37,355.28 2,402.43 39,757.71 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medical Insurance 2,402.38 42,160.09 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,804.81 42,160.09 ** 57,923.00 Budgeted 15,762.91 Remaining 73 % Used Account: 135-50027-030-000 Dental Insurance 1466 06/06/2014 Payroll 6/6/14 Dental Insurance 2,767.03 170.19 2,937.22 PR 1541 06/20/2014 MUD Payroll 6/20/14 Dental Insurance 170.23 3,107.45 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.42 3,107.45 ** 5,100.00 Budgeted 1,992.55 Remaining 61 % Used Account: 135-50028-030-000 Vision Insurance 1466 06/06/2014 Payroll 6/6/14 Vision Insurance 655.69 40.78 696.47 PR 1541 06/20/2014 MUD Payroll 6/20/14 Vision Insurance 40.84 737.31 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 737.31 ** 1,087.00 Budgeted 349.69 Remaining 68 % Used Account: 135-50029-030-000 Life Insurance & Other 1440 06/01/2014 June Dental & Other , Vision June Dental & Other, Vision 3,249.50 313.98 3,563.48 METLIFE 33818 AP 1486 06/06/2014 June A/P Rounding adjustment (.06) 3,563.42 Legal Shield AP 1662 06/30/2014 Clear Ins Accruals/rounding .49 3,563.91 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 314.41 3,563.91 ** 5,500.00 Budgeted 1,936.09 Remaining 65 % Used Account: 135-50030-030-000 Social Security Taxes 1466 06/06/2014 Payroll 6/6/14 Social Security Taxes 17,496.71 1,029.80 18,526.51 PR 1541 06/20/2014 MUD Payroll 6/20/14 Social Security Taxes 1,016.59 19,543.10 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,046.39 19,543.10 ** 28,659.00 Budgeted 9,115.90 Remaining 68 % Used Account: 135-50035-030-000 Medicare Taxes 1466 06/06/2014 Payroll 6/6/14 Medicare Taxes 4,091.98 240.85 4,332.83 PR 1541 06/20/2014 MUD Payroll 6/20/14 Medicare Taxes 237.74 4,570.57 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 478.59 4,570.57 ** 6,702.00 Budgeted 2,131.43 Remaining 68 % Used Account: 135-50040-030-000 Unemployment Taxes 1,449.00 .00 1,449.00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 1,449.00 ** 1,449.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 56 06/01/2014 Jun Ins & W/C Expense 1,029.03 128.62 1,157.65 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.62 1,157.65 ** 1,575.00 Budgeted 417.35 Remaining 74 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1683 06/26/2014 June A/P SALAD BOWL #10 2,713.93 18.75 2,732.68 SALAD BOWL #10 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 18.75 2,732.68 ** 5,000.00 Budgeted 2,267.32 Remaining 55 % Used Account: 135-55030-030-000 Software & Support 1381 06/01/2014 June A/P Remit Plus annual renewal 37,500.32 1,750.00 39,250.32 JACK HENRY & ASSOC, INC 33788 AP 1567 06/20/2014 June A/P Charter cable 645.50 39,895.82 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P BOA 4/28-5/27/14 583.19 40,479.01 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 479.10 40,958.11 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 645.50 41,603.61 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 705.73 42,309.34 TOWN OF TROPHY CLUB 33906 AP 1681 06/30/2014 June A/P SHI, AV Tek 47.50 42,356.84 TOWN OF TROPHY CLUB AP 1681 06/30/2014 June A/P AV Tek, Denton County (FD Disp 29.96 42,386.80 TOWN OF TROPHY CLUB AP _______________ Account: 135-55030-030-000 Software & Support Totals: 4,886.48 42,386.80 ** 59,698.00 Budgeted 17,311.20 Remaining 71 % Used Account: 135-55070-030-000 Independent Labor 1567 06/20/2014 June A/P Professional fees 7,147.98 600.00 7,747.98 NEW GEN STRATEGIES & SOLUTIONS 33898 AP 1681 06/30/2014 June A/P Record MUD meeting 52.50 7,800.48 MIGUEL CRUZ AP 1681 06/30/2014 June A/P SHI, AV Tek 600.00 8,400.48 TOWN OF TROPHY CLUB AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 1,252.50 8,400.48 ** 7,000.00 Budgeted (1,400.48) Remaining 120 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 428.45 .00 428.45 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 428.45 ** 4,500.00 Budgeted 4,071.55 Remaining 10 % Used Account: 135-55100-030-000 Building Maint & Supplies 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 2,308.11 43.00 2,351.11 TOWN OF TROPHY CLUB 33906 AP 1681 06/30/2014 June A/P Rug Service 94.42 2,445.53 G & K SERVICES AP 1681 06/30/2014 June A/P Rug Service 94.42 2,539.95 G & K SERVICES AP 1681 06/30/2014 June A/P Rug Service 94.42 2,634.37 G & K SERVICES AP 1681 06/30/2014 June A/P Rug Service 94.42 2,728.79 G & K SERVICES AP 1681 06/30/2014 June A/P Rug Service 94.42 2,823.21 G & K SERVICES AP 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (236.05) 2,587.16 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 279.05 2,587.16 ** 6,500.00 Budgeted 3,912.84 Remaining 40 % Used Account: 135-55120-030-000 Cleaning Services 1567 06/20/2014 June A/P May Janitorial Service 11,164.79 1,594.97 12,759.76 MEMBER'S BUILDING MAINTENANCE 33897 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 12,759.76 ** 19,140.00 Budgeted 6,380.24 Remaining 67 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55161-030-000 Town Personnel Contract 77,048.00 .00 77,048.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 77,048.00 ** 77,048.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 5,825.41 .00 5,825.41 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 5,825.41 ** 6,808.00 Budgeted 982.59 Remaining 86 % Used Account: 135-60005-030-000 Telephone 1567 06/20/2014 June A/P BOA 4/28-5/27/14 7,646.45 972.88 8,619.33 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 807.83 9,427.16 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P Answering service 180.00 9,607.16 KEYSTONE PARK SECRETARIAL 33892 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,960.71 9,607.16 ** 11,250.00 Budgeted 1,642.84 Remaining 85 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1541 06/20/2014 MUD Payroll 6/20/14 Communications/Pagers/Mobiles 2,186.11 300.00 2,486.11 PR 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 37.98 2,524.09 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 140.51 2,664.60 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 478.49 2,664.60 ** 4,057.00 Budgeted 1,392.40 Remaining 66 % Used Account: 135-60020-030-000 Electricity/Gas 1567 06/20/2014 June A/P Shi, Gexa 8,869.55 812.82 9,682.37 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 1,004.88 10,687.25 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 1,146.85 11,834.10 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 2,964.55 11,834.10 ** 15,171.00 Budgeted 3,336.90 Remaining 78 % Used Account: 135-60025-030-000 Water 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: 619.08 (91.06) 528.02 AR 1687 06/30/2014 June A/P June Water 182.12 710.14 TROPHY CLUB MUD (WATER BILLS) AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 91.06 710.14 ** 1,500.00 Budgeted 789.86 Remaining 47 % Used Account: 135-60035-030-000 Postage 1526 06/01/2014 May Postage meter usage 17,150.05 264.86 17,414.91 GL 1473 06/04/2014 June A/P Mailing of CCR 1,032.32 18,447.23 U.S. POSTAL SERVICE 33819 AP 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 145.50 18,592.73 TOWN OF TROPHY CLUB 33906 AP 1653 06/30/2014 MUD Postage Meter Usage/June 127.94 18,720.67 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,570.62 18,720.67 ** 28,500.00 Budgeted 9,779.33 Remaining 66 % Used Account: 135-60040-030-000 Service Charges & Fees 1656 06/03/2014 Credit card fees/UB online pmt 20,217.52 44.27 20,261.79 GL 1656 06/03/2014 Credit card fees/UB online pmt 97.75 20,359.54 GL 1656 06/03/2014 Credit card fees/UB online pmt 2,784.71 23,144.25 GL 1658 06/30/2014 FF Bank May Account Analysis 250.00 23,394.25 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,176.73 23,394.25 ** 28,330.00 Budgeted 4,935.75 Remaining 83 % Used Account: 135-60050-030-000 Bad Debt Expense 1650 06/30/2014 UB 6/30/14 Write Offs UB20140630-20140630 User: 4,153.40 198.24 4,351.64 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 198.24 4,351.64 ** 6,200.00 Budgeted 1,848.36 Remaining 70 % Used Account: 135-60055-030-000 Insurance 56 06/01/2014 Jun Ins & W/C Expense 34,286.09 4,269.73 38,555.82 GL 1681 06/30/2014 June A/P Director Bond 200.00 38,755.82 VICTOR O SCHINNERER & CO, INC AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,469.73 38,755.82 ** 53,561.00 Budgeted 14,805.18 Remaining 72 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 1499 06/09/2014 June A/P Associate Membership/McKnight 4,011.95 300.00 4,311.95 TX MUNICIPAL LEAGUE 33878 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 300.00 4,311.95 ** 4,500.00 Budgeted 188.05 Remaining 96 % Used Account: 135-60075-030-000 Meetings 27.26 .00 27.26 _______________ Account: 135-60075-030-000 Meetings Totals: .00 27.26 ** 400.00 Budgeted 372.74 Remaining 7 % Used Account: 135-60079-030-000 Public Education 274.83 .00 274.83 _______________ Account: 135-60079-030-000 Public Education Totals: .00 274.83 ** 5,000.00 Budgeted 4,725.17 Remaining 5 % Used Account: 135-60080-030-000 Schools & Training 2,849.25 .00 2,849.25 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,849.25 ** 6,800.00 Budgeted 3,950.75 Remaining 42 % Used Account: 135-60100-030-000 Travel & per diem 1499 06/09/2014 June A/P Mileage reimb/STW Conf 1,483.36 74.48 1,557.84 NICOLE D'ANDRIA 33862 AP 1569 06/20/2014 June A/P Mileage/TRWA Office Profession 326.48 1,884.32 LAURIE SLAGHT 33912 AP 1683 06/26/2014 June A/P TEXAS L & C #7112 24.78 1,909.10 TEXAS L & C #7112 PC 1683 06/26/2014 June A/P COURTYARD BY MARRIOTT 483.92 2,393.02 COURTYARD BY MARRIOTT PC 1683 06/26/2014 June A/P COURTYARD BY MARRIOTT 15.48 2,408.50 COURTYARD BY MARRIOTT PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 925.14 2,408.50 ** 5,000.00 Budgeted 2,591.50 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-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 1508 06/10/2014 June A/P Calling of the Election 1,849.39 759.80 2,609.19 DENTON PUBLISHING CO 33832 AP 1545 06/17/2014 June A/P Election Deposit 1,100.00 3,709.19 TARRANT COUNTY ELECTIONS ADMIN 33879 AP _______________ Account: 135-60115-030-000 Elections Totals: 1,859.80 3,709.19 ** 2,500.00 Budgeted (1,209.19) Remaining 148 % Used Account: 135-60125-030-000 Advertising 589.43 .00 589.43 _______________ Account: 135-60125-030-000 Advertising Totals: .00 589.43 ** 2,500.00 Budgeted 1,910.57 Remaining 24 % Used Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1567 06/20/2014 June A/P BOA 4/28-5/27/14 376.25 1,579.90 1,956.15 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 1,579.90 1,956.15 ** 17,870.00 Budgeted 15,913.85 Remaining 11 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,563.55 .00 2,563.55 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 2,563.55 ** 2,500.00 Budgeted (63.55) Remaining 103 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used Account: 135-65055-030-000 Hardware 1567 06/20/2014 June A/P Shi, Gexa 2,189.02 298.30 2,487.32 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P BOA 4/28-5/27/14 554.99 3,042.31 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 4,090.00 7,132.31 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 233.59 7,365.90 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-65055-030-000 Hardware Totals: 5,176.88 7,365.90 ** 13,562.00 Budgeted 6,196.10 Remaining 54 % Used Account: 135-65085-030-000 Office Supplies 1567 06/20/2014 June A/P Shi, Gexa 3,096.30 81.80 3,178.10 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 74.61 3,252.71 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 5.66 3,258.37 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 74.61 3,332.98 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 48.97 3,381.95 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P Office supplies 57.42 3,439.37 OFFICE DEPOT, INC 33899 AP 1683 06/26/2014 June A/P HON ACCESSORIES 24.00 3,463.37 HON ACCESSORIES PC 1683 06/26/2014 June A/P AMER ASSOC NOTARIESWE 74.70 3,538.07 AMER ASSOC NOTARIESWE PC 1683 06/26/2014 June A/P AMAZON MKTPLACE PMTS 8.82 3,546.89 AMAZON MKTPLACE PMTS PC 1683 06/26/2014 June A/P AMAZON.COM 27.98 3,574.87 AMAZON.COM PC 1685 06/30/2014 Town Billed Inv 1179-1186 AR 20140601-20140630 User: (14.49) 3,560.38 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 464.08 3,560.38 ** 9,100.00 Budgeted 5,539.62 Remaining 39 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1567 06/20/2014 June A/P Shi, Gexa 2,403.47 497.00 2,900.47 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 142.50 3,042.97 TOWN OF TROPHY CLUB 33906 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 2,403.47 141.95 3,184.92 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 53.00 3,237.92 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 414.00 3,651.92 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 1,248.45 3,651.92 ** 5,732.00 Budgeted 2,080.08 Remaining 64 % Used Account: 135-65095-030-000 Maintenance Supplies 1683 06/26/2014 June A/P SAMSCLUB #4795 1,837.36 185.88 2,023.24 SAMSCLUB #4795 PC 1683 06/26/2014 June A/P AMAZON.COM 13.11 2,036.35 AMAZON.COM PC 1683 06/26/2014 June A/P GREAT COFFEES OF AMERI 72.64 2,108.99 GREAT COFFEES OF AMERI PC 1683 06/26/2014 June A/P SAMSCLUB #4795 132.00 2,240.99 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 403.63 2,240.99 ** 2,500.00 Budgeted 259.01 Remaining 90 % Used Account: 135-65097-030-000 Vending Machine Supplies 76.96 .00 76.96 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing 1567 06/20/2014 June A/P Printing of CCR 2,348.27 1,076.00 3,424.27 LOGAN GRAPHICS, INC 33894 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,076.00 3,424.27 ** 4,000.00 Budgeted 575.73 Remaining 86 % Used Account: 135-69170-030-000 Copier Lease Installments 1567 06/20/2014 June A/P Kyocera, Verizon, Pitney Bowes 1,541.11 128.43 1,669.54 TOWN OF TROPHY CLUB 33906 AP 1567 06/20/2014 June A/P JPM,BOA,Acclaim,Charter,SHI,Ve 256.85 1,926.39 TOWN OF TROPHY CLUB 33906 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 385.28 1,926.39 ** 3,450.00 Budgeted 1,523.61 Remaining 56 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 733,528.82 ** 1,056,620.00 Budgeted 323,091.18 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1546 06/17/2014 June A/P May Legal 201,355.05 5,136.50 206,491.55 THE LISTON LAW FIRM, P.C. 33881 AP 1567 06/20/2014 June A/P Legal/General 1,786.40 208,277.95 WHITAKER CHALK SWINDLE 33910 AP 1567 06/20/2014 June A/P BDMR Lots 2,448.61 210,726.56 WHITAKER CHALK SWINDLE 33910 AP 1567 06/20/2014 June A/P Service to Solana 168.00 210,894.56 WHITAKER CHALK SWINDLE 33910 AP 1567 06/20/2014 June A/P TIRZ #2 420.00 211,314.56 WHITAKER CHALK SWINDLE 33910 AP 1567 06/20/2014 June A/P BDMR 14,977.00 226,291.56 WHITAKER CHALK SWINDLE 33910 AP 1567 06/20/2014 June A/P Legal/Matter #11404702, 114557 37,919.55 264,211.11 Fulbright & Jaworski LLP 33887 AP _______________ Account: 135-55045-039-000 Legal Totals: 62,856.06 264,211.11 ** 347,126.00 Budgeted 82,914.89 Remaining 76 % Used Account: 135-55055-039-000 Auditing 21,200.00 .00 21,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 1486 06/06/2014 June A/P DCAD Budget 3rd qtr 6,243.84 1,914.46 8,158.30 DENTON CENTRAL APPRAISAL DISTR 33830 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,914.46 8,158.30 ** 10,000.00 Budgeted 1,841.70 Remaining 82 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 296,020.81 ** 382,766.00 Budgeted 86,745.19 Remaining 77 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 264,879.19 .00 Budgeted (264,879.19) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 1657 06/30/2014 Bank Interest/June (61.26) (6.54) (67.80) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (6.54) (67.80) ** .00 Budgeted 67.80 Remaining 0 % Used Account: 507-49036-000-000 GASB Reserves (120,000.00) .00 (120,000.00) _______________ Account: 507-49036-000-000 GASB Reserves Totals: .00 (120,000.00) ** .00 Budgeted 120,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (120,067.80) ** .00 Budgeted 120,067.80 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JUNE 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 510,694 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,145 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 527,685 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,145 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,145 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 497,662 TOTAL FUND BALANCE 515,541 TOTAL LIABILITIES AND FUND BALANCE 527,685 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 17:03 07/08/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 977.43- 384,969.57- 98.909 4,246.43- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- .51- 459.43- 18.377 2,040.57- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 79.52- 2,050.07- 128.129 450.07 Subtotal: 393,316.00- 393,316.00- 1,057.46- 387,479.07- 98.516 5,836.93- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- 11.92- 69.90- 18.640 305.10- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 11.92- 214,348.90- 99.858 305.10- Program number: 624,495.00- 624,495.00- 1,069.38- 601,827.97- 96.370 22,667.03- Department number: Revenues 624,495.00- 624,495.00- 1,069.38- 601,827.97- 96.370 22,667.03- Revenues Subtotal ----------- 624,495.00- 624,495.00- 1,069.38- 601,827.97- 96.370 22,667.03- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 17:03 07/08/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 43.478 1,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 52.317 94,028.75 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Program number: 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Department number: Administration 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Expenditures Subtotal ----------- 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Fund number: 533 MUD 1 I&S Consolidated 1,069.38- 497,661.72- 497,661.72 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 1681 06/30/2014 June A/P Ind Creek Dr. Waterline Replac 3,072.00 300.00 3,372.00 TEAGUE, NALL & PERKINS,INC AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 300.00 3,372.00 ** 282,245.17 Budgeted 278,873.17 Remaining 1 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 86,001.40 ** 282,245.17 Budgeted 196,243.77 Remaining 30 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (34,066.40) 282,245.17 Budgeted 316,311.57 Remaining -12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1629 06/02/2014 Property Taxes/Assessments (383,992.14) (174.28) (384,166.42) GL 1630 06/04/2014 Property Taxes/Assessments (12.22) (384,178.64) GL 1631 06/05/2014 Property Taxes/Assessments (80.62) (384,259.26) GL 1632 06/06/2014 Property Taxes/Assessments (518.72) (384,777.98) GL 1634 06/11/2014 Property Taxes/Assessments (85.70) (384,863.68) GL 1635 06/16/2014 Property Taxes/Assessments (11.53) (384,875.21) GL 1636 06/18/2014 Property Taxes/Assessments (26.90) (384,902.11) GL 1640 06/27/2014 Property Taxes/Assessments (17.72) (384,919.83) GL 1647 06/30/2014 Property Taxes/Assessments (49.74) (384,969.57) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (977.43) (384,969.57) ** (389,216.00) Budgeted (4,246.43) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1637 06/23/2014 Property Taxes/Assessments (458.92) (.51) (459.43) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (.51) (459.43) ** (2,500.00) Budgeted (2,040.57) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 1632 06/06/2014 Property Taxes/Assessments (1,970.55) (55.34) (2,025.89) GL 1634 06/11/2014 Property Taxes/Assessments (12.85) (2,038.74) GL 1635 06/16/2014 Property Taxes/Assessments (1.69) (2,040.43) GL 1636 06/18/2014 Property Taxes/Assessments (1.88) (2,042.31) GL 1637 06/23/2014 Property Taxes/Assessments (.26) (2,042.57) GL 1647 06/30/2014 Property Taxes/Assessments (7.50) (2,050.07) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (79.52) (2,050.07) ** (1,600.00) Budgeted 450.07 Remaining 128 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1657 06/30/2014 Bank Interest/June (57.98) (11.92) (69.90) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-49010-000-000 Interest Income Totals: (11.92) (69.90) ** (375.00) Budgeted (305.10) Remaining 19 % Used Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (601,827.97) ** (624,495.00) Budgeted (22,667.03) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 17:03 07/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 1,000.00 ** 2,300.00 Budgeted 1,300.00 Remaining 43 % Used Account: 533-70025-051-000 Bond Interest Expense 103,166.25 .00 103,166.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 103,166.25 ** 197,195.00 Budgeted 94,028.75 Remaining 52 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 104,166.25 ** 624,495.00 Budgeted 520,328.75 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (497,661.72) .00 Budgeted 497,661.72 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (559,499.22) **** 282,245.17 Budgeted 841,744.39 Remaining ########## ******* End of Report *********