Loading...
HomeMy WebLinkAboutJuly Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2014 122 ASSETS FIRE DEPT. INVESTMENTS 819,611 PREPAID EXPENSES 3,344 ADVALOREM PROPERTY TAXES RECEIVABLE 19,060 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 8,450 UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,262 TOTAL ASSETS 853,727 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 27,510 ACCOUNTS AND OTHER PAYABLES 20,980 TOTAL LIABILITIES 48,490 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 495,688 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 309,549 TOTAL FUND BALANCE 805,237 TOTAL LIABILITIES AND FUND BALANCE 853,727 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 10:58 08/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000- Assessment - Emerg Svcs 305,445.00- 305,445.00- 532.39- 309,752.79- 101.410 4,307.79 122-40003-000- Emer Svcs Assessmen/Delinquent 1,581.21- 1,581.21 122-40010-000- Property Taxes/MUD Fire 927,555.00- 927,555.00- 3,523.44- 920,702.27- 99.261 6,852.73- 122-40011-000- Property Taxes/Fire-Delinquent 1,344.67- 1,344.67 122-40015-000- Property Taxes/Assessments P&I 750.00- 750.00- 8.81- 738.58- 98.477 11.42- 122-40020-000- Property Taxes/Fire P&I 4,500.00- 4,500.00- 377.60- 5,268.56- 117.079 768.56 Subtotal: 1,238,250.00- 1,238,250.00- 4,442.24- 1,239,388.08- 100.092 1,138.08 122-42014-000- Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 4,800.00- 80.000 1,200.00- Subtotal: 6,000.00- 6,000.00- 800.00- 4,800.00- 80.000 1,200.00- 122-43400-000- Fire Inspections 700.00- 700.00- 150.00- 900.00- 128.571 200.00 122-43415-000- Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 10,150.00- 10,900.00- 101.869 200.00 122-49900-000- Miscellaneous Income 6,000.00- 6,000.00- 1,325.00- 7,375.00- 122.917 1,375.00 Subtotal: 6,000.00- 6,000.00- 1,325.00- 7,375.00- 122.917 1,375.00 Program number: 1,260,950.00- 1,260,950.00- 16,717.24- 1,262,463.08- 100.120 1,513.08 Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 16,717.24- 1,262,463.08- 100.120 1,513.08 Revenues Subtotal ----- 1,260,950.00- 1,260,950.00- 16,717.24- 1,262,463.08- 100.120 1,513.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 10:58 08/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045- Salaries & Wages 455,916.00 455,916.00 35,506.62 362,729.41 79.561 93,186.59 122-50010-045- Overtime 44,225.00 44,225.00 4,353.19 29,941.06 67.702 14,283.94 122-50011-045- DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045- Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045- Certification 4,350.00 4,350.00 400.00 3,739.39 85.963 610.61 122-50020-045- Retirement 70,991.00 70,991.00 5,823.96 58,918.60 82.994 12,072.40 122-50026-045- Medical Insurance 56,968.00 56,968.00 4,316.36 41,774.68 73.330 15,193.32 122-50027-045- Dental Insurance 4,230.00 4,230.00 352.81 3,408.90 80.589 821.10 122-50028-045- Vision Insurance 892.00 892.00 69.51 693.79 77.779 198.21 122-50029-045- Life Insurance & Other 4,250.00 4,250.00 326.49 3,175.47 74.717 1,074.53 122-50030-045- Social Security Taxes 32,980.00 32,980.00 2,284.09 23,682.03 71.807 9,297.97 122-50035-045- Medicare Taxes 7,713.00 7,713.00 534.03 5,537.07 71.789 2,175.93 122-50040-045- Unemployment Taxes 2,259.00 2,259.00 15.32 1,615.94 71.533 643.06 122-50045-045- Workman's Compensation 8,708.00 8,708.00 662.78 6,627.86 76.112 2,080.14 122-50060-045- Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045- Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 54,645.16 559,994.78 78.554 152,884.22 122-55030-045- Software & Support 8,682.00 6,834.00 6,834.00 122-55045-045- Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045- Maintenance & Repairs 20,472.00 20,472.00 907.61 15,617.80 76.289 4,854.20 122-55090-045- Vehicle Maintenance 14,850.00 14,850.00 328.99 7,352.65 49.513 7,497.35 Subtotal: 49,004.00 45,547.00 1,236.60 20,464.94 44.931 25,082.06 122-60005-045- Telephone 100.00 100.00 5.74 26.23 26.230 73.77 122-60010-045- Communications/Pagers/Mobiles 4,237.00 4,237.00 221.11 3,651.42 86.179 585.58 122-60020-045- Electricity/Gas 6,568.00 9,268.00 660.40 5,801.55 62.598 3,466.45 122-60025-045- Water 1,500.00 1,500.00 768.89 51.259 731.11 122-60030-045- Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045- Postage 100.00 100.00 16.46 53.51 53.510 46.49 122-60055-045- Insurance 12,110.00 12,110.00 1,009.25 10,134.50 83.687 1,975.50 122-60066-045- Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045- Dues & Memberships 15,180.00 15,180.00 8,411.64 55.413 6,768.36 122-60080-045- Schools & Training 4,280.00 4,280.00 85.00 4,567.01 106.706 287.01- 122-60096-045- Emergency Management 2,000.00 2,000.00 1,608.70 80.435 391.30 122-60100-045- Travel & per diem 4,577.00 4,577.00 2,490.18 54.406 2,086.82 122-60110-045- Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045- Advertising 200.00 200.00 200.00- 122-60160-045- Programs & Special Projects 4,500.00 4,500.00 36.92 1,471.50 32.700 3,028.50 122-60180-045- Fire Inspection/Enforcement 1,500.00 1,500.00 249.00 16.600 1,251.00 122-60195-045- Flags & Repair 2,000.00 2,000.00 47.50 1,587.12 79.356 412.88 122-60243-045- Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 10:58 08/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045- Miscellaneous Expense 1,000.00 1,000.00 88.00 247.97 24.797 752.03 Subtotal: 276,531.00 282,488.00 2,170.38 259,117.51 91.727 23,370.49 122-65005-045- Fuel & Lube 11,698.00 10,198.00 697.96 6,991.99 68.562 3,206.01 122-65010-045- Uniforms 3,360.00 3,360.00 194.10 2,978.74 88.653 381.26 122-65015-045- Protective Clothing 7,600.00 7,600.00 5,953.77 78.339 1,646.23 122-65030-045- Chemicals 1,000.00 500.00 420.00 84.000 80.00 122-65035-045- Small Tools 2,500.00 2,500.00 694.31 27.772 1,805.69 122-65085-045- Office Supplies 1,000.00 500.00 233.22 46.644 266.78 122-65105-045- Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 892.06 17,272.03 69.763 7,485.97 122-69008-045- Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045- Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 50.000 1,515.50 122-69050-045- Radios 34,200.00 34,200.00 32,693.40 95.595 1,506.60 122-69195-045- GASB34/Reserve for Replacement 67,647.00 67,647.00 41,890.00 41,890.00 61.924 25,757.00 122-69255-045- Airpacks 20,400.00 20,400.00 18,984.00 19,965.59 97.871 434.41 Subtotal: 195,278.00 195,278.00 60,874.00 96,064.49 49.194 99,213.51 Program number: 1,260,950.00 1,260,950.00 119,818.20 952,913.75 75.571 308,036.25 Department number: Fire 1,260,950.00 1,260,950.00 119,818.20 952,913.75 75.571 308,036.25 Expenditures Subtotal ----- 1,260,950.00 1,260,950.00 119,818.20 952,913.75 75.571 308,036.25 Fund number: 122 Trophy Club MUD Fire Dept. 103,100.96 309,549.33- 309,549.33 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 1799 07/03/2014 Property Taxes/Assessments (309,220.40) (37.99) (309,258.39) GL 1802 07/10/2014 Property Taxes/Assessments (83.45) (309,341.84) GL 1805 07/11/2014 Property Taxes/Assessments (156.47) (309,498.31) GL 1811 07/21/2014 Property Taxes/Assessments (55.72) (309,554.03) GL 1812 07/23/2014 Property Taxes/Assessments (89.56) (309,643.59) GL 1816 07/29/2014 Property Taxes/Assessments (85.30) (309,728.89) GL 1820 07/30/2014 Property Taxes/Assessments (23.90) (309,752.79) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (532.39) (309,752.79) ** (305,445.00) Budgeted 4,307.79 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 1800 07/07/2014 Property Taxes/Assessments (917,178.83) (35.41) (917,214.24) GL 1801 07/08/2014 Property Taxes/Assessments (22.91) (917,237.15) GL 1802 07/10/2014 Property Taxes/Assessments (55.00) (917,292.15) GL 1805 07/11/2014 Property Taxes/Assessments (37.14) (917,329.29) GL 1806 07/14/2014 Property Taxes/Assessments (215.41) (917,544.70) GL 1807 07/15/2014 Property Taxes/Assessments (196.13) (917,740.83) GL 1808 07/16/2014 Property Taxes/Assessments (85.74) (917,826.57) GL 1809 07/17/2014 Property Taxes/Assessments (108.76) (917,935.33) GL 1810 07/18/2014 Property Taxes/Assessments (468.07) (918,403.40) GL 1811 07/21/2014 Property Taxes/Assessments (89.51) (918,492.91) GL 1812 07/23/2014 Property Taxes/Assessments (77.52) (918,570.43) GL 1813 07/24/2014 Property Taxes/Assessments (182.94) (918,753.37) GL 1814 07/25/2014 Property Taxes/Assessments (204.60) (918,957.97) GL 1815 07/28/2014 Property Taxes/Assessments (1,268.02) (920,225.99) GL 1816 07/29/2014 Property Taxes/Assessments (78.30) (920,304.29) GL 1820 07/30/2014 Property Taxes/Assessments (127.05) (920,431.34) GL 1845 07/31/2014 Property Taxes/Assessments (270.93) (920,702.27) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,523.44) (920,702.27) ** (927,555.00) Budgeted (6,852.73) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (1,344.67) .00 (1,344.67) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (1,344.67) ** .00 Budgeted 1,344.67 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1799 07/03/2014 Property Taxes/Assessments (729.77) (5.70) (735.47) GL 1820 07/30/2014 Property Taxes/Assessments (3.11) (738.58) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (8.81) (738.58) ** (750.00) Budgeted (11.42) Remaining 98 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1800 07/07/2014 Property Taxes/Assessments (4,890.96) (5.31) (4,896.27) GL 1801 07/08/2014 Property Taxes/Assessments (.89) (4,897.16) GL 1802 07/10/2014 Property Taxes/Assessments (3.32) (4,900.48) GL 1807 07/15/2014 Property Taxes/Assessments (168.70) (5,069.18) GL 1815 07/28/2014 Property Taxes/Assessments (199.38) (5,268.56) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (377.60) (5,268.56) ** (4,500.00) Budgeted 768.56 Remaining 117 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (4,000.00) (800.00) (4,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (4,800.00) ** (6,000.00) Budgeted (1,200.00) Remaining 80 % Used Account: 122-43400-000-000 Fire Inspections 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (750.00) (150.00) (900.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (900.00) ** (700.00) Budgeted 200.00 Remaining 129 % Used Account: 122-43415-000-000 Denton County Pledge-Fire 1737 07/09/2014 Denton County 2014 Fire Pledge (10,000.00) (10,000.00) GL _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: (10,000.00) (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (6,050.00) (1,325.00) (7,375.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,325.00) (7,375.00) ** (6,000.00) Budgeted 1,375.00 Remaining 123 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,262,463.08) ** (1,260,950.00) Budgeted 1,513.08 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1671 07/03/2014 FD Payroll 7/3/14 327,222.79 17,757.28 344,980.07 GL 1677 07/18/2014 FD Payroll 7/18/14 17,749.34 362,729.41 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,506.62 362,729.41 ** 455,916.00 Budgeted 93,186.59 Remaining 80 % Used Account: 122-50010-045-000 Overtime 1671 07/03/2014 FD Payroll 7/3/14 25,587.87 4,353.19 29,941.06 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,353.19 29,941.06 ** 44,225.00 Budgeted 14,283.94 Remaining 68 % 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 1671 07/03/2014 FD Payroll 7/3/14 3,339.39 400.00 3,739.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 400.00 3,739.39 ** 4,350.00 Budgeted 610.61 Remaining 86 % Used Account: 122-50020-045-000 Retirement 1671 07/03/2014 FD Payroll 7/3/14 53,094.64 3,287.76 56,382.40 GL 1677 07/18/2014 FD Payroll 7/18/14 2,536.20 58,918.60 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,823.96 58,918.60 ** 70,991.00 Budgeted 12,072.40 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1671 07/03/2014 FD Payroll 7/3/14 37,458.32 2,488.39 39,946.71 GL 1677 07/18/2014 FD Payroll 7/18/14 1,827.97 41,774.68 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.36 41,774.68 ** 56,968.00 Budgeted 15,193.32 Remaining 73 % Used Account: 122-50027-045-000 Dental Insurance 1671 07/03/2014 FD Payroll 7/3/14 3,056.09 176.38 3,232.47 GL 1677 07/18/2014 FD Payroll 7/18/14 176.43 3,408.90 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.81 3,408.90 ** 4,230.00 Budgeted 821.10 Remaining 81 % Used Account: 122-50028-045-000 Vision Insurance 1671 07/03/2014 FD Payroll 7/3/14 624.28 34.72 659.00 GL 1677 07/18/2014 FD Payroll 7/18/14 34.79 693.79 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.51 693.79 ** 892.00 Budgeted 198.21 Remaining 78 % Used Account: 122-50029-045-000 Life Insurance & Other 1671 07/03/2014 FD Payroll 7/3/14 2,848.98 163.16 3,012.14 GL 1677 07/18/2014 FD Payroll 7/18/14 163.33 3,175.47 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.49 3,175.47 ** 4,250.00 Budgeted 1,074.53 Remaining 75 % Used Account: 122-50030-045-000 Social Security Taxes 1671 07/03/2014 FD Payroll 7/3/14 21,397.94 1,289.60 22,687.54 GL 1677 07/18/2014 FD Payroll 7/18/14 994.49 23,682.03 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,284.09 23,682.03 ** 32,980.00 Budgeted 9,297.97 Remaining 72 % Used Account: 122-50035-045-000 Medicare Taxes 1671 07/03/2014 FD Payroll 7/3/14 5,003.04 301.47 5,304.51 GL 1677 07/18/2014 FD Payroll 7/18/14 232.56 5,537.07 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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: 534.03 5,537.07 ** 7,713.00 Budgeted 2,175.93 Remaining 72 % Used Account: 122-50040-045-000 Unemployment Taxes 1671 07/03/2014 FD Payroll 7/3/14 1,600.62 3.65 1,604.27 GL 1677 07/18/2014 FD Payroll 7/18/14 11.67 1,615.94 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 15.32 1,615.94 ** 2,259.00 Budgeted 643.06 Remaining 72 % Used Account: 122-50045-045-000 Workman's Compensation 125 07/01/2014 FD Jul W/C expense 5,965.08 662.78 6,627.86 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 6,627.86 ** 8,708.00 Budgeted 2,080.14 Remaining 76 % 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 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1736 07/09/2014 July Fire Fighter cable 14,710.19 (133.82) 14,576.37 GL 1762 07/24/2014 July A/P Door repair 170.00 14,746.37 OVERHEAD DOOR FORT WORTH 34007 AP 1772 07/24/2014 July A/P Rug Service-FD 24.51 14,770.88 G & K SERVICES 34014 AP 1772 07/24/2014 July A/P Rug Service-FD 24.51 14,795.39 G & K SERVICES 34014 AP 1881 07/28/2014 6/27/14-7/28/14 PCards EASYAPPLIANCEPARTS.COM 83.69 14,879.08 EASYAPPLIANCEPARTS.COM PC 1881 07/28/2014 6/27/14-7/28/14 PCards ATT*BILL PAYMENT 158.76 15,037.84 ATT*BILL PAYMENT PC 1881 07/28/2014 6/27/14-7/28/14 PCards ATT*BILL PAYMENT 128.82 15,166.66 ATT*BILL PAYMENT PC 1881 07/28/2014 6/27/14-7/28/14 PCards WAL-MART #0266 13.15 15,179.81 WAL-MART #0266 PC 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (24.51) 15,155.30 AR 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 462.50 15,617.80 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 907.61 15,617.80 ** 20,472.00 Budgeted 4,854.20 Remaining 76 % Used Account: 122-55090-045-000 Vehicle Maintenance 1881 07/28/2014 6/27/14-7/28/14 PCards VEHICLESSAFETEYSUPPLY. 7,023.66 87.99 7,111.65 VEHICLESSAFETEYSUPPLY. PC 1881 07/28/2014 6/27/14-7/28/14 PCards WILDFIRE TRUCK & EQUIP 241.00 7,352.65 WILDFIRE TRUCK & EQUIP PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 328.99 7,352.65 ** 14,850.00 Budgeted 7,497.35 Remaining 50 % Used Account: 122-60005-045-000 Telephone 1876 07/31/2014 July A/P BOA PCards IT 20.49 5.74 26.23 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.74 26.23 ** 100.00 Budgeted 73.77 Remaining 26 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1671 07/03/2014 FD Payroll 7/3/14 3,430.31 75.00 3,505.31 GL 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 146.11 3,651.42 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 221.11 3,651.42 ** 4,237.00 Budgeted 585.58 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-60020-045-000 Electricity/Gas 1762 07/24/2014 July A/P Electricity 6/13-7/15/14 5,141.15 1,246.36 6,387.51 HUDSON ENERGY SERVICES, LLC 34002 AP 1765 07/24/2014 July A/P Gas/Fire Station 6/19-7/14/14 74.44 6,461.95 ATMOS ENERGY 33998 AP 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (660.40) 5,801.55 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 660.40 5,801.55 ** 9,268.00 Budgeted 3,466.45 Remaining 63 % Used Account: 122-60025-045-000 Water 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: 768.89 (107.52) 661.37 AR 1876 07/31/2014 July A/P July Water 107.52 768.89 TROPHY CLUB MUD (WATER BILLS) 34053 AP _______________ Account: 122-60025-045-000 Water Totals: .00 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 1730 07/17/2014 July A/P Repair sent to Akron Brass Co 37.05 11.04 48.09 FEDERAL EXPRESS CORP 33978 AP 1844 07/31/2014 July Postage Meter Usage 5.42 53.51 GL _______________ Account: 122-60035-045-000 Postage Totals: 16.46 53.51 ** 100.00 Budgeted 46.49 Remaining 54 % Used Account: 122-60055-045-000 Insurance 57 07/01/2014 Jul Ins & W/C Expense 9,125.25 1,009.25 10,134.50 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 10,134.50 ** 12,110.00 Budgeted 1,975.50 Remaining 84 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 1730 07/17/2014 July A/P Fire Officer 4/Hurd 4,482.01 85.00 4,567.01 TX COMM ON FIRE PROTECTION 33996 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 4,567.01 ** 4,280.00 Budgeted (287.01) Remaining 107 % Used Account: 122-60096-045-000 Emergency Management 1,608.70 .00 1,608.70 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,608.70 ** 2,000.00 Budgeted 391.30 Remaining 80 % Used Account: 122-60100-045-000 Travel & per diem 2,490.18 .00 2,490.18 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,490.18 ** 4,577.00 Budgeted 2,086.82 Remaining 54 % Used Account: 122-60110-045-000 Physicals/Testing 1765 07/24/2014 July A/P Employee testing 63.00 63.00 CARENOW CORPORATE AP 1766 07/24/2014 Void Carenow inv 928329 Employee testing (63.00) .00 CARENOW CORPORATE AP _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 200.00 .00 200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1881 07/28/2014 6/27/14-7/28/14 PCards CRISTINA S MEXICAN 1,434.58 36.92 1,471.50 CRISTINA S MEXICAN PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 36.92 1,471.50 ** 4,500.00 Budgeted 3,028.50 Remaining 33 % 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 1908 07/31/2014 July A/P Symonds Flags #61040668 1,539.62 47.50 1,587.12 TOWN OF TROPHY CLUB AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 47.50 1,587.12 ** 2,000.00 Budgeted 412.88 Remaining 79 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards RANDALLS STORE00017897 159.97 12.99 172.96 RANDALLS STORE00017897 PC 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 46.93 219.89 THE HOME DEPOT 6581 PC 1881 07/28/2014 6/27/14-7/28/14 PCards HOT & CREAMY DONUTS 28.08 247.97 HOT & CREAMY DONUTS PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 88.00 247.97 ** 1,000.00 Budgeted 752.03 Remaining 25 % Used Account: 122-65005-045-000 Fuel & Lube 1863 07/31/2014 MUD Gas log/July 6,294.03 697.96 6,991.99 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 697.96 6,991.99 ** 10,198.00 Budgeted 3,206.01 Remaining 69 % Used Account: 122-65010-045-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: 2,784.64 (194.10) 2,590.54 AR 1876 07/31/2014 July A/P Uniforms 388.20 2,978.74 CW NIELSEN MANUFACTURING, INC 34026 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 194.10 2,978.74 ** 3,360.00 Budgeted 381.26 Remaining 89 % Used Account: 122-65015-045-000 Protective Clothing 5,953.77 .00 5,953.77 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .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 694.31 .00 694.31 _______________ Account: 122-65035-045-000 Small Tools Totals: .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 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-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 1744 07/22/2014 GASB Xfer/Fire Truck Replaceme 41,890.00 41,890.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 41,890.00 41,890.00 ** 67,647.00 Budgeted 25,757.00 Remaining 62 % Used Account: 122-69255-045-000 Airpacks 1876 07/31/2014 July A/P 4 Air-pak X3 981.59 18,984.00 19,965.59 MUNICIPAL EMERGENCY SERVICES 34040 AP _______________ Account: 122-69255-045-000 Airpacks Totals: 18,984.00 19,965.59 ** 20,400.00 Budgeted 434.41 Remaining 98 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 952,913.75 ** 1,260,950.00 Budgeted 308,036.25 Remaining 76 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (309,549.33) .00 Budgeted 309,549.33 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 7/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 280,896 - - 280,896 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,503,897 - - 1,503,897 INVESTMENTS-TEXPOOL 736,113 234,940 279,474 1,250,527 PREPAID EXPENSES 27,982 - - 27,982 ADVALOREM PROPERTY TAXES RECEIVABLE 2,362 - - 2,362 UTILITY AND OTHER ACCOUNTS RECEIVABLE 866,144 - - 866,144 - TOTAL ASSETS 3,417,994 234,940 279,474 3,932,408 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,362 - - 2,362 ACCOUNTS AND OTHER PAYABLES 427,459 - 53,550 481,009 CUSTOMER DEPOSITS 258,127 - - 258,127 - TOTAL LIABILITIES 687,948 - 53,550 741,498 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,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 (258,430) (78,110) (19,176) (355,716) - TOTAL FUND BALANCE 2,730,046 234,940 225,924 3,190,910 - TOTAL LIABILITIES AND FUND BALANCE 3,417,994 234,940 279,474 3,932,408 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000- Property Taxes 99,250.00- 99,250.00- 377.00- 98,561.96- 99.307 688.04- 135-40002-000- Property Taxes/Delinquent 129.61- 129.61 135-40015-000- Property Taxes/P & I 900.00- 900.00- 43.86- 557.67- 61.963 342.33- Subtotal: 100,150.00- 100,150.00- 420.86- 99,249.24- 99.101 900.76- 135-43215-000- Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000- Water 3,749,310.00- 3,749,310.00- 396,691.39- 2,452,396.23- 65.409 1,296,913.77- 135-47005-000- Sewer 1,708,321.00- 1,708,321.00- 220,566.74- 1,613,855.10- 94.470 94,465.90- 135-47025-000- Penalties 64,522.00- 64,522.00- 8,881.23- 44,738.93- 69.339 19,783.07- 135-47030-000- Service Charges 9,075.00- 9,075.00- 978.00- 7,805.00- 86.006 1,270.00- 135-47035-000- Plumbing Inspections 1,200.00- 2,000.00- 200.00- 2,150.00- 107.500 150.00 135-47045-000- Sewer Inspections 4,400.00- 5,000.00- 600.00- 6,750.00- 135.000 1,750.00 135-47070-000- TCCC Effluent Charges 79,586.00- 79,586.00- 12,546.80- 50,949.18- 64.018 28,636.82- Subtotal: 5,616,414.00- 5,617,814.00- 640,464.16- 4,178,644.44- 74.382 1,439,169.56- 135-48005-000- Utility Fees 582,109.00- 582,109.00- 46,000.00- 305,900.00- 52.550 276,209.00- Subtotal: 582,109.00- 582,109.00- 46,000.00- 305,900.00- 52.550 276,209.00- 135-49010-000- Interest Income 4,800.00- 4,800.00- 70,178.91 5,051.59- 105.241 251.59 135-49016-000- Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 9,105.30- 89.584 1,058.70- 135-49018-000- Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 135-49030-000- Vending Revenue 350.00- 350.00- 226.85- 64.814 123.15- 135-49035-000- Prior Year Reserves 880,000.00- 880,000.00- 135-49036-000- GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000- Oversize Meter Reimbursement 84,000.00- 84,000.00- 7,889.00- 72,234.80- 85.994 11,765.20- 135-49900-000- Miscellaneous Income 3,000.00- 3,000.00- 74,610.69- 75,887.05- 2,529.568 72,887.05 135-49901-000- Records Management Revenue 100.00- 100.00- 17.00- 53.39- 53.390 46.61- 135-49903-000- Recovery of Prior Year Expense 4,087.00- 4,087.00- 100.000 135-49905-000- Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 1,003,351.00- 13,831.64- 172,479.28- 17.190 830,871.72- Program number: 6,417,937.00- 7,303,424.00- 700,716.66- 4,756,355.32- 65.125 2,547,068.68- Department number: Revenues 6,417,937.00- 7,303,424.00- 700,716.66- 4,756,355.32- 65.125 2,547,068.68- Revenues Subtotal ----- 6,417,937.00- 7,303,424.00- 700,716.66- 4,756,355.32- 65.125 2,547,068.68- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010- Salaries & Wages 287,709.00 287,709.00 22,136.90 217,353.52 75.546 70,355.48 135-50010-010- Overtime 13,391.00 16,391.00 1,436.21 15,644.64 95.447 746.36 135-50016-010- Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010- Certification 5,100.00 5,100.00 486.00 3,636.00 71.294 1,464.00 135-50020-010- Retirement 27,847.00 27,847.00 2,150.54 22,124.21 79.449 5,722.79 135-50026-010- Medical Insurance 48,334.00 48,334.00 3,559.98 33,380.49 69.062 14,953.51 135-50027-010- Dental Insurance 3,932.00 3,932.00 249.12 2,424.33 61.656 1,507.67 135-50028-010- Vision Insurance 873.00 873.00 63.03 596.08 68.279 276.92 135-50029-010- Life Insurance & Other 3,306.00 3,306.00 253.73 2,152.16 65.099 1,153.84 135-50030-010- Social Security Taxes 19,289.00 19,289.00 1,501.22 15,310.44 79.374 3,978.56 135-50035-010- Medicare Taxes 4,511.00 4,511.00 351.10 3,580.68 79.377 930.32 135-50040-010- Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010- Workman's Compensation 9,829.00 9,829.00 802.45 8,024.50 81.641 1,804.50 135-50060-010- Pre-emp Physicals/Testing 200.00 350.00 63.00 359.90 102.829 9.90- 135-50070-010- Employee Relations 300.00 300.00 180.53 60.177 119.47 Subtotal: 429,580.00 433,920.00 33,053.28 330,916.92 76.262 103,003.08 135-55005-010- Engineering 3,000.00 6,000.00 6,000.00 135-55080-010- Maintenance & Repairs 50,000.00 61,000.00 3,287.94 53,964.90 88.467 7,035.10 135-55090-010- Vehicle Maintenance 5,000.00 5,000.00 609.24 3,622.33 72.447 1,377.67 135-55105-010- Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 248.33 9.933 2,251.67 135-55135-010- Lab Analysis 5,500.00 5,500.00 535.00 3,816.24 69.386 1,683.76 Subtotal: 67,000.00 80,000.00 4,432.18 61,651.80 77.065 18,348.20 135-60010-010- Communications/Pagers/Mobiles 4,913.00 4,913.00 383.50 3,831.33 77.984 1,081.67 135-60020-010- Electricity 162,160.00 155,160.00 19,675.57 107,333.58 69.176 47,826.42 135-60066-010- Publications/Books/Subscripts 500.00 2,538.00 2,715.66 107.000 177.66- 135-60070-010- Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010- Schools & Training 4,184.00 1,500.00 111.00 1,782.00 118.800 282.00- 135-60090-010- Safety Program 400.00 135-60100-010- Travel & per diem 1,450.00 279.00 64.85 237.48 85.118 41.52 135-60105-010- Rent/Lease Equipment 500.00 500.00 60.00 12.000 440.00 135-60135-010- TCEQ Fees & Permits 47,400.00 47,400.00 4,614.30 37,077.89 78.223 10,322.11 135-60150-010- Wholesale Water 2,338,473.00 2,338,473.00 172,395.91 1,318,029.14 56.363 1,020,443.86 135-60245-010- Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010- Property Maintenance 3,500.00 3,500.00 150.00 1,439.55 41.130 2,060.45 135-60285-010- Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010- 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 197,395.13 1,474,459.83 57.663 1,082,553.17 135-65005-010- Fuel & Lube 23,181.00 22,181.00 1,042.09 10,669.82 48.103 11,511.18 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010- Uniforms 3,270.00 2,500.00 1,938.58 77.543 561.42 135-65030-010- Chemicals 5,000.00 5,000.00 2,801.88 7,292.49 145.850 2,292.49- 135-65035-010- Small Tools 1,200.00 1,200.00 490.92 40.910 709.08 135-65040-010- Safety Equipment 1,000.00 1,000.00 344.55 34.455 655.45 135-65050-010- Meter Expense 143,550.00 143,550.00 76,145.04 53.044 67,404.96 Subtotal: 177,201.00 175,431.00 3,843.97 96,881.40 55.225 78,549.60 135-69005-010- Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010- Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 25.099 367,000.00 135-69009-010- Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 60.314 7,646.74 135-69195-010- Gasb34/Reserve for Replacement 30,000.00 135-69280-010- Capital Repairs 7,500.00 135-69281-010- 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 238,724.56 2,235,007.34 57.424 1,657,132.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010- Lab Analysis for PID 1,000.00 2,000.00 440.00 3,182.24 159.112 1,182.24- Subtotal: 1,000.00 2,000.00 440.00 3,182.24 159.112 1,182.24- 135-60135-010- 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 440.00 5,678.43 81.120 1,321.57 Department number: Water 3,932,956.00 3,899,140.00 239,164.56 2,240,685.77 57.466 1,658,454.23 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020- Salaries & Wages 202,894.00 202,894.00 15,566.17 156,168.73 76.971 46,725.27 135-50010-020- Overtime 11,965.00 11,965.00 1,400.77 11,517.36 96.259 447.64 135-50016-020- Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020- Certification 4,800.00 4,800.00 400.00 4,000.00 83.333 800.00 135-50020-020- Retirement 19,905.00 19,905.00 1,559.56 16,154.94 81.160 3,750.06 135-50026-020- Medical Insurance 43,471.00 43,471.00 3,426.76 33,814.84 77.787 9,656.16 135-50027-020- Dental Insurance 2,989.00 2,989.00 211.38 2,159.04 72.233 829.96 135-50028-020- Vision Insurance 658.00 658.00 51.26 508.61 77.296 149.39 135-50029-020- Life Insurance & Other 2,303.00 2,303.00 219.85 1,831.42 79.523 471.58 135-50030-020- Social Security Taxes 13,805.00 13,805.00 949.39 9,812.32 71.078 3,992.68 135-50035-020- Medicare Taxes 3,229.00 3,229.00 222.05 2,294.82 71.069 934.18 135-50040-020- Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020- Workman's Compensation 6,552.00 6,552.00 535.08 5,350.80 81.667 1,201.20 135-50060-020- Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020- Employee Relations 350.00 350.00 46.30 132.57 37.877 217.43 Subtotal: 316,105.00 316,897.00 24,588.57 247,633.95 78.143 69,263.05 135-55070-020- Independent Labor 880,000.00 193,086.89 799,388.84 90.840 80,611.16 135-55080-020- Maintenance & Repairs 35,000.00 36,120.00 593.84 34,695.17 96.055 1,424.83 135-55090-020- Vehicle Maintenance 2,000.00 2,000.00 1,665.48 83.274 334.52 135-55105-020- Maintenance-Backhoe/SkidLoader 500.00 135-55125-020- Dumpster Services 52,000.00 47,000.00 1,604.75 42,900.35 91.277 4,099.65 135-55135-020- Lab Analysis 30,000.00 30,000.00 3,130.00 21,916.08 73.054 8,083.92 Subtotal: 119,500.00 995,120.00 198,415.48 900,565.92 90.498 94,554.08 135-60010-020- Communications/Pagers/Mobiles 3,329.00 3,329.00 306.84 2,756.35 82.798 572.65 135-60020-020- Electricity 148,227.00 138,227.00 10,423.23 89,049.70 64.423 49,177.30 135-60066-020- Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020- Schools & Training 2,636.00 1,636.00 1,347.00 82.335 289.00 135-60090-020- Safety Program 250.00 500.00 474.07 94.814 25.93 135-60100-020- Travel & per diem 1,050.00 1,050.00 3.62 1,088.73 103.689 38.73- 135-60105-020- Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020- TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020- Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020- Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020- Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020- Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 10,733.69 108,918.70 64.497 59,956.30 135-65005-020- Fuel & Lube 14,720.00 13,600.00 1,021.40 9,346.37 68.723 4,253.63 135-65010-020- Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020- Chemicals 39,000.00 31,000.00 20,892.10 67.394 10,107.90 135-65035-020- Small Tools 1,000.00 300.00 169.00 346.09 115.363 46.09- 135-65040-020- Safety Equipment 250.00 500.00 277.86 55.572 222.14 135-65045-020- Lab Supplies 15,000.00 15,000.00 10,004.02 66.693 4,995.98 Subtotal: 71,722.00 62,152.00 1,190.40 42,303.71 68.065 19,848.29 135-69005-020- Capital Outlays 31,000.00 135-69008-020- Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020- Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 73.397 378.30 135-69280-020- 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 234,928.14 1,320,485.98 84.404 244,000.02 Department number: Wastewater 768,011.00 1,564,486.00 234,928.14 1,320,485.98 84.404 244,000.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021- Salaries & Wages 90,299.00 90,299.00 6,869.28 60,652.79 67.169 29,646.21 135-50010-021- Overtime 10,028.00 10,028.00 1,019.95 5,359.84 53.449 4,668.16 135-50016-021- Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021- Certification 1,800.00 1,800.00 150.00 1,500.00 83.333 300.00 135-50020-021- Retirement 9,025.00 9,025.00 721.93 6,606.89 73.207 2,418.11 135-50026-021- Medical Insurance 23,668.00 23,668.00 1,473.70 15,568.69 65.779 8,099.31 135-50027-021- Dental Insurance 1,703.00 1,703.00 102.60 1,120.59 65.801 582.41 135-50028-021- Vision Insurance 314.00 314.00 23.68 241.61 76.946 72.39 135-50029-021- Life Insurance & Other 1,066.00 1,066.00 72.75 830.49 77.907 235.51 135-50030-021- Social Security Taxes 7,442.00 7,442.00 460.58 4,162.12 55.927 3,279.88 135-50035-021- Medicare Taxes 1,741.00 1,741.00 107.73 973.41 55.911 767.59 135-50040-021- Unemployment Taxes 198.00 414.00 414.00 100.000 135-50045-021- Workman's Compensation 3,276.00 3,276.00 267.54 2,675.40 81.667 600.60 135-50070-021- Employee Relations 200.00 200.00 21.05 230.28 115.140 30.28- Subtotal: 168,673.00 153,084.00 11,290.79 102,443.61 66.920 50,640.39 135-55005-021- Engineering 1,500.00 135-55080-021- Maintenance & Repairs 23,801.00 14,451.00 5,273.57 13,336.21 92.286 1,114.79 135-55090-021- Vehicle Maintenance 2,000.00 2,000.00 999.18 49.959 1,000.82 Subtotal: 27,301.00 16,451.00 5,273.57 14,335.39 87.140 2,115.61 135-60010-021- Communications/Pagers/Mobiles 1,333.00 1,333.00 102.72 1,199.76 90.005 133.24 135-60020-021- Electricity 21,178.00 21,178.00 1,925.01 17,262.95 81.514 3,915.05 135-60070-021- Dues & Memberships 250.00 250.00 250.00 135-60080-021- Schools & Training 1,711.00 911.00 450.00 561.00 61.581 350.00 135-60090-021- Safety Program 300.00 300.00 35.34 11.780 264.66 135-60100-021- Travel & per diem 550.00 250.00 668.76 707.25 282.900 457.25- 135-60105-021- Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021- Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 3,146.49 19,766.30 67.411 9,555.70 135-65005-021- Fuel & Lube 22,397.00 21,747.00 1,033.74 9,903.16 45.538 11,843.84 135-65010-021- Uniforms 1,040.00 1,040.00 814.23 78.291 225.77 135-65030-021- Chemicals 6,000.00 2,000.00 300.89 15.045 1,699.11 135-65035-021- Small Tools 1,000.00 300.00 199.00 242.99 80.997 57.01 135-65040-021- Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 1,232.74 11,848.00 45.857 13,989.00 135-69005-021- Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021- Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021- Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021- 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 20,943.59 216,693.50 57.398 160,837.50 Department number: Collection 472,170.00 377,531.00 20,943.59 216,693.50 57.398 160,837.50 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026- Salaries & Wages 10,000.00 10,000.00 500.00 7,000.00 70.000 3,000.00 135-50030-026- Social Security Taxes 620.00 620.00 31.00 434.00 70.000 186.00 135-50035-026- Medicare Taxes 145.00 145.00 7.25 101.50 70.000 43.50 135-50040-026- Unemployment Taxes 10.00 230.00 11.50 106.00 46.087 124.00 135-50045-026- Workman's Compensation 36.00 36.00 2.94 29.47 81.861 6.53 Subtotal: 10,811.00 11,031.00 552.69 7,670.97 69.540 3,360.03 135-60066-026- Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026- Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026- Meetings 1,200.00 1,200.00 174.95 307.87 25.656 892.13 135-60080-026- Schools & Training 4,000.00 4,000.00 125.00 757.00 18.925 3,243.00 135-60100-026- Travel & per diem 5,000.00 5,000.00 41.66 .833 4,958.34 135-60245-026- Miscellaneous Expenses 1,000.00 1,000.00 179.40 17.940 820.60 Subtotal: 11,850.00 11,850.00 299.95 1,320.93 11.147 10,529.07 Program number: 22,661.00 22,881.00 852.64 8,991.90 39.299 13,889.10 Department number: Board of Directors 22,661.00 22,881.00 852.64 8,991.90 39.299 13,889.10 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030- Salaries & Wages 458,721.00 458,721.00 37,780.17 356,584.41 77.734 102,136.59 135-50010-030- Overtime 500.00 750.00 55.80 801.55 106.873 51.55- 135-50016-030- Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030- Retirement 41,419.00 41,419.00 3,225.26 33,169.93 80.084 8,249.07 135-50026-030- Medical Insurance 57,923.00 57,923.00 4,804.81 46,964.90 81.082 10,958.10 135-50027-030- Dental Insurance 5,100.00 5,100.00 340.42 3,447.87 67.605 1,652.13 135-50028-030- Vision Insurance 1,087.00 1,087.00 81.62 818.93 75.339 268.07 135-50029-030- Life Insurance & Other 4,483.00 5,500.00 390.30 3,954.21 71.895 1,545.79 135-50030-030- Social Security Taxes 28,659.00 28,659.00 2,128.91 21,672.01 75.620 6,986.99 135-50035-030- Medicare Taxes 6,702.00 6,702.00 497.89 5,068.46 75.626 1,633.54 135-50040-030- Unemployment Taxes 63.00 1,449.00 1,449.00 100.000 135-50045-030- Workman's Compensation 1,575.00 1,575.00 128.62 1,286.27 81.668 288.73 135-50060-030- Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030- Employee Relations 5,000.00 5,000.00 2,732.68 54.654 2,267.32 Subtotal: 614,450.00 617,103.00 49,433.80 481,027.72 77.949 136,075.28 135-55030-030- Software & Support 59,698.00 59,698.00 2,687.94 45,074.74 75.505 14,623.26 135-55070-030- Independent Labor 7,700.00 7,000.00 54.30 8,454.78 120.783 1,454.78- 135-55080-030- Maintenance & Repairs 4,500.00 4,500.00 75.00 503.45 11.188 3,996.55 135-55100-030- Building Maint & Supplies 6,500.00 6,500.00 188.84- 2,398.32 36.897 4,101.68 135-55120-030- Cleaning Services 19,140.00 19,140.00 1,594.97 14,354.73 74.999 4,785.27 135-55160-030- Professional Outside Services 15,000.00 10,000.00 500.00 500.00 5.000 9,500.00 135-55161-030- Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030- Collection Fees 200.00 200.00 200.00 135-55205-030- Utility Billing Contract 6,808.00 6,808.00 918.83 6,744.24 99.063 63.76 Subtotal: 196,594.00 190,894.00 5,642.20 155,078.26 81.238 35,815.74 135-60005-030- Telephone 11,250.00 11,250.00 1,016.74 10,623.90 94.435 626.10 135-60010-030- Communications/Pagers/Mobiles 3,589.00 4,057.00 337.99 3,002.59 74.010 1,054.41 135-60020-030- Electricity/Gas 15,171.00 15,171.00 11,834.10 78.005 3,336.90 135-60025-030- Water 1,500.00 1,500.00 710.14 47.343 789.86 135-60035-030- Postage 28,500.00 28,500.00 3,566.16 22,286.83 78.199 6,213.17 135-60040-030- Service Charges & Fees 28,330.00 28,330.00 3,486.12 26,880.37 94.883 1,449.63 135-60050-030- Bad Debt Expense 1,500.00 6,200.00 4,351.64 70.188 1,848.36 135-60055-030- Insurance 53,561.00 53,561.00 4,269.73 43,025.55 80.330 10,535.45 135-60066-030- Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030- Dues & Memberships 4,500.00 4,500.00 4,311.95 95.821 188.05 135-60075-030- Meetings 400.00 400.00 27.26 6.815 372.74 135-60079-030- Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030- Schools & Training 7,500.00 6,800.00 184.99- 2,664.26 39.180 4,135.74 135-60100-030- Travel & per diem 5,000.00 5,000.00 568.43 2,976.93 59.539 2,023.07 135-60110-030- Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030- Elections 2,500.00 2,500.00 3,709.19 148.368 1,209.19- 135-60125-030- Advertising 2,500.00 2,500.00 150.00 739.43 29.577 1,760.57 135-60235-030- Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030- Miscellaneous Expenses 22,870.00 17,870.00 108.00 2,064.15 11.551 15,805.85 135-60270-030- 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60336-030- Interfund Trans Out (MUD1 I&S) 16,525.00 16,525.00 16,525.00- 135-60360-030- Furniture/Equipment < $5000 2,500.00 2,500.00 2,563.55 102.542 63.55- Subtotal: 204,221.00 208,689.00 29,843.18 159,096.31 76.236 49,592.69 135-65010-030- Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030- Hardware 13,562.00 13,562.00 108.56 7,474.46 55.113 6,087.54 135-65085-030- Office Supplies 9,100.00 9,100.00 753.54 4,313.92 47.406 4,786.08 135-65090-030- Printer Supplies & Maintenance 5,732.00 5,732.00 375.70 4,027.62 70.266 1,704.38 135-65095-030- Maintenance Supplies 2,500.00 2,500.00 245.31 2,486.30 99.452 13.70 135-65097-030- Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030- Printing 4,000.00 4,000.00 3,424.27 85.607 575.73 Subtotal: 36,484.00 36,484.00 1,483.11 22,802.43 62.500 13,681.57 135-69170-030- Copier Lease Installments 3,450.00 3,450.00 128.42 2,054.81 59.560 1,395.19 Subtotal: 3,450.00 3,450.00 128.42 2,054.81 59.560 1,395.19 Program number: 1,055,199.00 1,056,620.00 86,530.71 820,059.53 77.612 236,560.47 Department number: Administration 1,055,199.00 1,056,620.00 86,530.71 820,059.53 77.612 236,560.47 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 10:58 08/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039- Legal 131,300.00 347,126.00 111,847.49 376,058.60 108.335 28,932.60- 135-55055-039- Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039- Appraisal 10,000.00 10,000.00 8,158.30 81.583 1,841.70 135-55065-039- Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 111,847.49 407,868.30 106.558 25,102.30- Program number: 166,940.00 382,766.00 111,847.49 407,868.30 106.558 25,102.30- Department number: Non Departmental 166,940.00 382,766.00 111,847.49 407,868.30 106.558 25,102.30- Expenditures Subtotal ----- 6,417,937.00 7,303,424.00 694,267.13 5,014,784.98 68.663 2,288,639.02 Fund number: 135 MUD 1 General Fund 6,449.53- 258,429.66 258,429.66- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 10:58 08/13/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000- Interest Income 7.43- 75.23- 75.23 507-49036-000- GASB Reserves 120,000.00- 120,000.00 Subtotal: 7.43- 120,075.23- 120,075.23 Program number: 7.43- 120,075.23- 120,075.23 Department number: 7.43- 120,075.23- 120,075.23 Revenues Subtotal ----------- 7.43- 120,075.23- 120,075.23 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 10:58 08/13/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010- 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 20 10:58 08/13/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010- Capital Rep/Ind Crk Waterline 282,245.17 53,250.00 56,622.00 20.061 225,623.17 Subtotal: 282,245.17 53,250.00 56,622.00 20.061 225,623.17 Program number: 3 Indian Creek Waterline 282,245.17 53,250.00 56,622.00 20.061 225,623.17 Department number: Water 282,245.17 53,250.00 139,251.40 49.337 142,993.77 Expenditures Subtotal ----------- 282,245.17 53,250.00 139,251.40 49.337 142,993.77 Fund number: 507 MUD 1 Capital Projects 282,245.17 53,242.57 19,176.17 6.794 263,069.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 1800 07/07/2014 Property Taxes/Assessments (98,184.96) (3.79) (98,188.75) GL 1801 07/08/2014 Property Taxes/Assessments (2.45) (98,191.20) GL 1802 07/10/2014 Property Taxes/Assessments (5.88) (98,197.08) GL 1805 07/11/2014 Property Taxes/Assessments (3.97) (98,201.05) GL 1806 07/14/2014 Property Taxes/Assessments (23.05) (98,224.10) GL 1807 07/15/2014 Property Taxes/Assessments (20.99) (98,245.09) GL 1808 07/16/2014 Property Taxes/Assessments (9.17) (98,254.26) GL 1809 07/17/2014 Property Taxes/Assessments (11.64) (98,265.90) GL 1810 07/18/2014 Property Taxes/Assessments (50.08) (98,315.98) GL 1811 07/21/2014 Property Taxes/Assessments (9.58) (98,325.56) GL 1812 07/23/2014 Property Taxes/Assessments (8.29) (98,333.85) GL 1813 07/24/2014 Property Taxes/Assessments (19.57) (98,353.42) GL 1814 07/25/2014 Property Taxes/Assessments (21.89) (98,375.31) GL 1815 07/28/2014 Property Taxes/Assessments (135.68) (98,510.99) GL 1816 07/29/2014 Property Taxes/Assessments (8.38) (98,519.37) GL 1820 07/30/2014 Property Taxes/Assessments (13.60) (98,532.97) GL 1845 07/31/2014 Property Taxes/Assessments (28.99) (98,561.96) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (377.00) (98,561.96) ** (99,250.00) Budgeted (688.04) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent (129.61) .00 (129.61) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (129.61) ** .00 Budgeted 129.61 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1800 07/07/2014 Property Taxes/Assessments (513.81) (.57) (514.38) GL 1801 07/08/2014 Property Taxes/Assessments (.10) (514.48) GL 1802 07/10/2014 Property Taxes/Assessments (.36) (514.84) GL 1807 07/15/2014 Property Taxes/Assessments (21.50) (536.34) GL 1815 07/28/2014 Property Taxes/Assessments (21.33) (557.67) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (43.86) (557.67) ** (900.00) Budgeted (342.33) Remaining 62 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1852 07/31/2014 UB 7/31/14 Billing UB20140731-20140731 User: (2,055,704.84) (396,691.39) (2,452,396.23) UB _______________ Account: 135-47000-000-000 Water Totals: (396,691.39) (2,452,396.23) ** (3,749,310.00) Budgeted (1,296,913.77) Remaining 65 % Used Account: 135-47005-000-000 Sewer 1852 07/31/2014 UB 7/31/14 Billing UB20140731-20140731 User: (1,393,288.36) (220,566.74) (1,613,855.10) UB _______________ Account: 135-47005-000-000 Sewer Totals: (220,566.74) (1,613,855.10) ** (1,708,321.00) Budgeted (94,465.90) Remaining 94 % Used Account: 135-47025-000-000 Penalties 1753 07/22/2014 UB 7/22/14 penalties UB20140722-20140722 User: (35,857.70) (9,091.07) (44,948.77) UB 1839 07/22/2014 UB 7/22/14 Adjustment-penalty UB20140722-20140722 User: 3.75 (44,945.02) UB 1850 07/30/2014 UB 7/30/14 Penalty adjustments UB20140730-20140730 User: 206.09 (44,738.93) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,881.23) (44,738.93) ** (64,522.00) Budgeted (19,783.07) Remaining 69 % Used Account: 135-47030-000-000 Service Charges 1824 07/09/2014 UB 7/9/14 Disconnect Fees UB20140709-20140709 User: (6,827.00) (750.00) (7,577.00) UB 1827 07/11/2014 UB 7/11/14 NSF Check Fee UB20140711-20140711 User: (25.00) (7,602.00) UB 1831 07/16/2014 UB 7/16/14 NSF Check fee UB20140716-20140716 User: (25.00) (7,627.00) UB 1833 07/18/2014 UB 7/18/14 Disconnect fee reim UB20140718-20140718 User: 25.00 (7,602.00) UB 1841 07/23/2014 UB 7/23/14 Adj-NSF Check fee UB20140723-20140723 User: (100.00) (7,702.00) UB 1848 07/28/2014 UB 7/28/14 After hours fee UB20140728-20140728 User: (100.00) (7,802.00) UB 1852 07/31/2014 UB 7/31/14 Billing UB20140731-20140731 User: (3.00) (7,805.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (978.00) (7,805.00) ** (9,075.00) Budgeted (1,270.00) Remaining 86 % Used Account: 135-47035-000-000 Plumbing Inspections 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (1,950.00) (200.00) (2,150.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-47035-000-000 Plumbing Inspections Totals: (200.00) (2,150.00) ** (2,000.00) Budgeted 150.00 Remaining 108 % Used Account: 135-47045-000-000 Sewer Inspections 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (6,150.00) (600.00) (6,750.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (6,750.00) ** (5,000.00) Budgeted 1,750.00 Remaining 135 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1852 07/31/2014 UB 7/31/14 Billing UB20140731-20140731 User: (38,402.38) (12,546.80) (50,949.18) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (12,546.80) (50,949.18) ** (79,586.00) Budgeted (28,636.82) Remaining 64 % Used Account: 135-48005-000-000 Utility Fees 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (259,900.00) (46,000.00) (305,900.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (46,000.00) (305,900.00) ** (582,109.00) Budgeted (276,209.00) Remaining 53 % Used Account: 135-49010-000-000 Interest Income 1725 07/01/2014 Recode LOC Interest (75,230.50) 70,700.00 (4,530.50) GL 1872 07/31/2014 Bank Interest/July (61.15) (4,591.65) GL 1872 07/31/2014 Bank Interest/July (51.32) (4,642.97) GL 1872 07/31/2014 Bank Interest/July (408.62) (5,051.59) GL _______________ Account: 135-49010-000-000 Interest Income Totals: 70,178.91 (5,051.59) ** (4,800.00) Budgeted 251.59 Remaining 105 % Used Account: 135-49016-000-000 Cell Tower Revenue 1738 07/09/2014 AT&T Cell Tower Revenue (8,194.77) (910.53) (9,105.30) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,105.30) ** (10,164.00) Budgeted (1,058.70) Remaining 90 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used Account: 135-49030-000-000 Vending Revenue (226.85) .00 (226.85) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (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 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (64,345.80) (7,889.00) (72,234.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (7,889.00) (72,234.80) ** (84,000.00) Budgeted (11,765.20) Remaining 86 % Used Account: 135-49900-000-000 Miscellaneous Income 1725 07/01/2014 Recode LOC Interest (1,276.36) (70,700.00) (71,976.36) GL 1847 07/25/2014 UB 7/25/14 Fireline charges UB20140725-20140725 User: (3,885.00) (75,861.36) UB 1852 07/31/2014 UB 7/31/14 Billing UB20140731-20140731 User: (25.69) (75,887.05) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (74,610.69) (75,887.05) ** (3,000.00) Budgeted 72,887.05 Remaining ########## Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1818 07/31/2014 TN&P Open Records (36.39) (17.00) (53.39) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (17.00) (53.39) ** (100.00) Budgeted (46.61) Remaining 53 % 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,756,355.32) ** (7,303,424.00) Budgeted (2,547,068.68) Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Salaries & Wages 195,216.62 11,069.33 206,285.95 PR 1715 07/18/2014 MUD Payroll 7/18/14 Salaries & Wages 11,067.57 217,353.52 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,136.90 217,353.52 ** 287,709.00 Budgeted 70,355.48 Remaining 76 % Used Account: 135-50010-010-000 Overtime 1644 07/03/2014 MUD Payroll 7/3/14 Overtime 14,208.43 652.93 14,861.36 PR 1715 07/18/2014 MUD Payroll 7/18/14 Overtime 783.28 15,644.64 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,436.21 15,644.64 ** 16,391.00 Budgeted 746.36 Remaining 95 % 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 1682 07/07/2014 July A/P C Water License Test/Clinton 3,150.00 111.00 3,261.00 TX COMMISSION ENVIRONMENTAL QU 33967 AP 1715 07/18/2014 MUD Payroll 7/18/14 Certification 375.00 3,636.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 486.00 3,636.00 ** 5,100.00 Budgeted 1,464.00 Remaining 71 % Used Account: 135-50020-010-000 Retirement 1644 07/03/2014 MUD Payroll 7/3/14 Retirement 19,973.67 1,052.66 21,026.33 PR 1715 07/18/2014 MUD Payroll 7/18/14 Retirement 1,097.88 22,124.21 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,150.54 22,124.21 ** 27,847.00 Budgeted 5,722.79 Remaining 79 % Used Account: 135-50026-010-000 Medical Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Medical Insurance 29,820.51 1,780.02 31,600.53 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medical Insurance 1,779.96 33,380.49 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,559.98 33,380.49 ** 48,334.00 Budgeted 14,953.51 Remaining 69 % Used Account: 135-50027-010-000 Dental Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Dental Insurance 2,175.21 124.54 2,299.75 PR 1715 07/18/2014 MUD Payroll 7/18/14 Dental Insurance 124.58 2,424.33 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 2,424.33 ** 3,932.00 Budgeted 1,507.67 Remaining 62 % Used Account: 135-50028-010-000 Vision Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Vision Insurance 533.05 31.49 564.54 PR 1715 07/18/2014 MUD Payroll 7/18/14 Vision Insurance 31.54 596.08 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 596.08 ** 873.00 Budgeted 276.92 Remaining 68 % Used Account: 135-50029-010-000 Life Insurance & Other 1682 07/07/2014 July A/P Dental, Vision and other Insur 1,898.43 223.17 2,121.60 METLIFE 33949 AP 1682 07/07/2014 July A/P Café 125 Adm fees 15.28 2,136.88 BenefitMall 33918 AP 1762 07/24/2014 July A/P Café 125 Admin Fee 15.28 2,152.16 BenefitMall 33999 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 253.73 2,152.16 ** 3,306.00 Budgeted 1,153.84 Remaining 65 % Used Account: 135-50030-010-000 Social Security Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Social Security Taxes 13,809.22 753.95 14,563.17 PR 1715 07/18/2014 MUD Payroll 7/18/14 Social Security Taxes 747.27 15,310.44 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,501.22 15,310.44 ** 19,289.00 Budgeted 3,978.56 Remaining 79 % Used Account: 135-50035-010-000 Medicare Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Medicare Taxes 3,229.58 176.34 3,405.92 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medicare Taxes 174.76 3,580.68 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 351.10 3,580.68 ** 4,511.00 Budgeted 930.32 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 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 Account: 135-50045-010-000 Workman's Compensation 57 07/01/2014 Jul Ins & W/C Expense 7,222.05 802.45 8,024.50 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 8,024.50 ** 9,829.00 Budgeted 1,804.50 Remaining 82 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1767 07/24/2014 July A/P Employee testing 296.90 63.00 359.90 CARENOW CORPORATE 34000 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 63.00 359.90 ** 350.00 Budgeted (9.90) Remaining 103 % Used Account: 135-50070-010-000 Employee Relations 180.53 .00 180.53 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 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 1730 07/17/2014 July A/P Angle stop 50,676.96 29.19 50,706.15 HD SUPPLY WATERWORKS, LTD. 33982 AP 1772 07/24/2014 July A/P Repair Clamps 524.20 51,230.35 HD SUPPLY WATERWORKS, LTD. 34016 AP 1881 07/28/2014 6/27/14-7/28/14 PCards CLARK 116.64 51,346.99 CLARK PC 1881 07/28/2014 6/27/14-7/28/14 PCards FRYS ELECTRONICS #37 72.98 51,419.97 FRYS ELECTRONICS #37 PC 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 92.03 51,512.00 THE HOME DEPOT 6581 PC 1876 07/31/2014 July A/P Maintenance parts 1,247.90 52,759.90 HD SUPPLY WATERWORKS, LTD. 34032 AP 1908 07/31/2014 July A/P Scada Computers/Scada Programm 1,205.00 53,964.90 DHS AUTOMATION, INC AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-010-000 Maintenance & Repairs Totals: 3,287.94 53,964.90 ** 61,000.00 Budgeted 7,035.10 Remaining 88 % Used Account: 135-55090-010-000 Vehicle Maintenance 1762 07/24/2014 July A/P Oil and Trailer plug 3,013.09 19.49 3,032.58 ROANOKE AUTO SUPPLY 34008 AP 1881 07/28/2014 6/27/14-7/28/14 PCards KWIK KAR LUBE & TUNE O 39.75 3,072.33 KWIK KAR LUBE & TUNE O PC 1881 07/28/2014 6/27/14-7/28/14 PCards DISCOUNT TIRE TXD 75 550.00 3,622.33 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 609.24 3,622.33 ** 5,000.00 Budgeted 1,377.67 Remaining 72 % 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 1730 07/17/2014 July A/P Bac T Samples/MUD 3,281.24 220.00 3,501.24 TARRANT CTY PUBLIC HEALTH LAB 33990 AP 1908 07/31/2014 July A/P Bac T Samples/MUD 315.00 3,816.24 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 535.00 3,816.24 ** 5,500.00 Budgeted 1,683.76 Remaining 69 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 3,447.83 383.50 3,831.33 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.50 3,831.33 ** 4,913.00 Budgeted 1,081.67 Remaining 78 % Used Account: 135-60020-010-000 Electricity 1762 07/24/2014 July A/P Electricity 6/12-7/14/14 87,658.01 79.80 87,737.81 HUDSON ENERGY SERVICES, LLC 34002 AP 1762 07/24/2014 July A/P Electricity 6/13-7/15/14 3,815.41 91,553.22 HUDSON ENERGY SERVICES, LLC 34002 AP 1765 07/24/2014 July A/P Electricity 6/13-7/15/14 15,780.36 107,333.58 HUDSON ENERGY SERVICES, LLC 34002 AP _______________ Account: 135-60020-010-000 Electricity Totals: 19,675.57 107,333.58 ** 155,160.00 Budgeted 47,826.42 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-010-000 Publications/Books/Subscripts 2,715.66 .00 2,715.66 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 2,715.66 ** 2,538.00 Budgeted (177.66) Remaining 107 % Used 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 1881 07/28/2014 6/27/14-7/28/14 PCards TCEQ IND RENEWAL L 1,671.00 111.00 1,782.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 1,782.00 ** 1,500.00 Budgeted (282.00) Remaining 119 % Used Account: 135-60100-010-000 Travel & per diem 1644 07/03/2014 MUD Payroll 7/3/14 Travel & per diem 172.63 64.85 237.48 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 64.85 237.48 ** 279.00 Budgeted 41.52 Remaining 85 % 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 1908 07/31/2014 July A/P Groundwater fee 32,463.59 4,614.30 37,077.89 North Texas Groundwater AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,614.30 37,077.89 ** 47,400.00 Budgeted 10,322.11 Remaining 78 % Used Account: 135-60150-010-000 Wholesale Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1876 07/31/2014 July A/P June Wholesale Water 1,145,633.23 172,395.91 1,318,029.14 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 172,395.91 1,318,029.14 ** 2,338,473.00 Budgeted 1,020,443.86 Remaining 56 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1881 07/28/2014 6/27/14-7/28/14 PCards DENTON SAND & GRAVEL, 1,289.55 42.00 1,331.55 DENTON SAND & GRAVEL, PC 1881 07/28/2014 6/27/14-7/28/14 PCards DENTON SAND & GRAVEL, 108.00 1,439.55 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 150.00 1,439.55 ** 3,500.00 Budgeted 2,060.45 Remaining 41 % 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 1863 07/31/2014 MUD Gas log/July 9,627.73 1,042.09 10,669.82 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,042.09 10,669.82 ** 22,181.00 Budgeted 11,511.18 Remaining 48 % Used Account: 135-65010-010-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1730 07/17/2014 July A/P Free Ammonia, Total Vials 4,490.61 382.09 4,872.70 HACH COMPANY 33981 AP 1730 07/17/2014 July A/P Total Dispenser Testing suppli 119.90 4,992.60 HACH COMPANY 33981 AP 1730 07/17/2014 July A/P Inv 8860147 paid by check and (172.07) 4,820.53 HACH COMPANY 33981 AP 1730 07/17/2014 July A/P Chlorine gas 832.70 5,653.23 DPC INDUSTRIES, INC 33977 AP 1772 07/24/2014 July A/P Testing Supplies 286.12 5,939.35 HACH COMPANY 34015 AP 1876 07/31/2014 July A/P Chlorine 832.70 6,772.05 DPC INDUSTRIES, INC 34028 AP 1908 07/31/2014 July A/P Chlorine 520.44 7,292.49 DPC INDUSTRIES, INC AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,801.88 7,292.49 ** 5,000.00 Budgeted (2,292.49) Remaining 146 % 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 76,145.04 .00 76,145.04 _______________ Account: 135-65050-010-000 Meter Expense Totals: .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69005-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 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 1730 07/17/2014 July A/P Bac T Samples/PID 2,742.24 80.00 2,822.24 TARRANT CTY PUBLIC HEALTH LAB 33991 AP 1908 07/31/2014 July A/P Bac T Samples/PID 360.00 3,182.24 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 440.00 3,182.24 ** 2,000.00 Budgeted (1,182.24) Remaining 159 % 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,240,685.77 ** 3,899,140.00 Budgeted 1,658,454.23 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Salaries & Wages 140,602.56 7,780.67 148,383.23 PR 1715 07/18/2014 MUD Payroll 7/18/14 Salaries & Wages 7,785.50 156,168.73 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,566.17 156,168.73 ** 202,894.00 Budgeted 46,725.27 Remaining 77 % Used Account: 135-50010-020-000 Overtime 1644 07/03/2014 MUD Payroll 7/3/14 Overtime 10,116.59 588.82 10,705.41 PR 1715 07/18/2014 MUD Payroll 7/18/14 Overtime 811.95 11,517.36 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,400.77 11,517.36 ** 11,965.00 Budgeted 447.64 Remaining 96 % 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 1715 07/18/2014 MUD Payroll 7/18/14 Certification 3,600.00 400.00 4,000.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 4,000.00 ** 4,800.00 Budgeted 800.00 Remaining 83 % Used Account: 135-50020-020-000 Retirement 1644 07/03/2014 MUD Payroll 7/3/14 Retirement 14,595.38 751.58 15,346.96 PR 1715 07/18/2014 MUD Payroll 7/18/14 Retirement 807.98 16,154.94 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,559.56 16,154.94 ** 19,905.00 Budgeted 3,750.06 Remaining 81 % Used Account: 135-50026-020-000 Medical Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Medical Insurance 30,388.08 1,713.39 32,101.47 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medical Insurance 1,713.37 33,814.84 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,426.76 33,814.84 ** 43,471.00 Budgeted 9,656.16 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Dental Insurance 1,947.66 105.68 2,053.34 PR 1715 07/18/2014 MUD Payroll 7/18/14 Dental Insurance 105.70 2,159.04 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 2,159.04 ** 2,989.00 Budgeted 829.96 Remaining 72 % Used Account: 135-50028-020-000 Vision Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Vision Insurance 457.35 25.61 482.96 PR 1715 07/18/2014 MUD Payroll 7/18/14 Vision Insurance 25.65 508.61 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 508.61 ** 658.00 Budgeted 149.39 Remaining 77 % Used Account: 135-50029-020-000 Life Insurance & Other 1682 07/07/2014 July A/P Dental, Vision and other Insur 1,611.57 158.73 1,770.30 METLIFE 33949 AP 1682 07/07/2014 July A/P Café 125 Adm fees 30.56 1,800.86 BenefitMall 33918 AP 1762 07/24/2014 July A/P Café 125 Admin Fee 30.56 1,831.42 BenefitMall 33999 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 219.85 1,831.42 ** 2,303.00 Budgeted 471.58 Remaining 80 % Used Account: 135-50030-020-000 Social Security Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Social Security Taxes 8,862.93 477.61 9,340.54 PR 1715 07/18/2014 MUD Payroll 7/18/14 Social Security Taxes 471.78 9,812.32 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 949.39 9,812.32 ** 13,805.00 Budgeted 3,992.68 Remaining 71 % Used Account: 135-50035-020-000 Medicare Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Medicare Taxes 2,072.77 111.70 2,184.47 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medicare Taxes 110.35 2,294.82 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 222.05 2,294.82 ** 3,229.00 Budgeted 934.18 Remaining 71 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 57 07/01/2014 Jul Ins & W/C Expense 4,815.72 535.08 5,350.80 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 5,350.80 ** 6,552.00 Budgeted 1,201.20 Remaining 82 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards SUBWAY 00537845 86.27 12.18 98.45 SUBWAY 00537845 PC 1881 07/28/2014 6/27/14-7/28/14 PCards FLIPS PATIO GRILL FORT 14.10 112.55 FLIPS PATIO GRILL FORT PC 1881 07/28/2014 6/27/14-7/28/14 PCards SPRING CREEK LAKE WORT 20.02 132.57 SPRING CREEK LAKE WORT PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 46.30 132.57 ** 350.00 Budgeted 217.43 Remaining 38 % Used Account: 135-55070-020-000 Independent Labor 1730 07/17/2014 July A/P WWTP Improvements 606,301.95 120,362.50 726,664.45 THE WALLACE GROUP, INC. 33993 AP 1908 07/31/2014 July A/P WWTP Improvements 72,724.39 799,388.84 THE WALLACE GROUP, INC. AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 193,086.89 799,388.84 ** 880,000.00 Budgeted 80,611.16 Remaining 91 % Used Account: 135-55080-020-000 Maintenance & Repairs 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 34,101.33 25.88 34,127.21 THE HOME DEPOT 6581 PC 1881 07/28/2014 6/27/14-7/28/14 PCards TRACTOR SUPPLY COMPANY 46.98 34,174.19 TRACTOR SUPPLY COMPANY PC 1881 07/28/2014 6/27/14-7/28/14 PCards TRACTOR SUPPLY COMPANY 10.98 34,185.17 TRACTOR SUPPLY COMPANY PC 1908 07/31/2014 July A/P Scada Computers/Scada Programm 510.00 34,695.17 DHS AUTOMATION, INC AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 593.84 34,695.17 ** 36,120.00 Budgeted 1,424.83 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1,665.48 .00 1,665.48 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 1,665.48 ** 2,000.00 Budgeted 334.52 Remaining 83 % Used Account: 135-55125-020-000 Dumpster Services 1876 07/31/2014 July A/P Sludge Haul off 41,295.60 1,604.75 42,900.35 L.H. CHANEY MATERIALS, INC. 34035 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,604.75 42,900.35 ** 47,000.00 Budgeted 4,099.65 Remaining 91 % Used Account: 135-55135-020-000 Lab Analysis 1876 07/31/2014 July A/P Testing 18,786.08 176.00 18,962.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 19,208.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 19,384.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 19,630.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 19,806.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 20,052.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 20,228.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 20,474.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 20,650.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 20,896.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 21,142.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 21,318.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 246.00 21,564.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 21,740.08 OXIDOR LABORATORIES LLC 34044 AP 1876 07/31/2014 July A/P Testing 176.00 21,916.08 OXIDOR LABORATORIES LLC 34044 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,130.00 21,916.08 ** 30,000.00 Budgeted 8,083.92 Remaining 73 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 2,449.51 306.84 2,756.35 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 306.84 2,756.35 ** 3,329.00 Budgeted 572.65 Remaining 83 % Used Account: 135-60020-020-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1772 07/24/2014 July A/P Electricity 6/13-7/15/14 78,626.47 10,423.23 89,049.70 HUDSON ENERGY SERVICES, LLC 34017 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,423.23 89,049.70 ** 138,227.00 Budgeted 49,177.30 Remaining 64 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 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 1,347.00 .00 1,347.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .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 1763 07/24/2014 July A/P Tolls 1,085.11 3.62 1,088.73 NTTA 34005 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 3.62 1,088.73 ** 1,050.00 Budgeted (38.73) Remaining 104 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-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 _______________ 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 1863 07/31/2014 MUD Gas log/July 8,324.97 1,021.40 9,346.37 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,021.40 9,346.37 ** 13,600.00 Budgeted 4,253.63 Remaining 69 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-65010-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals 20,892.10 .00 20,892.10 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 20,892.10 ** 31,000.00 Budgeted 10,107.90 Remaining 67 % Used Account: 135-65035-020-000 Small Tools 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 177.09 169.00 346.09 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 169.00 346.09 ** 300.00 Budgeted (46.09) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 277.86 .00 277.86 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 277.86 ** 500.00 Budgeted 222.14 Remaining 56 % Used Account: 135-65045-020-000 Lab Supplies 10,004.02 .00 10,004.02 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-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,320,485.98 ** 1,564,486.00 Budgeted 244,000.02 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Salaries & Wages 53,783.51 3,434.64 57,218.15 PR 1715 07/18/2014 MUD Payroll 7/18/14 Salaries & Wages 3,434.64 60,652.79 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,869.28 60,652.79 ** 90,299.00 Budgeted 29,646.21 Remaining 67 % Used Account: 135-50010-021-000 Overtime 1644 07/03/2014 MUD Payroll 7/3/14 Overtime 4,339.89 502.66 4,842.55 PR 1715 07/18/2014 MUD Payroll 7/18/14 Overtime 517.29 5,359.84 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,019.95 5,359.84 ** 10,028.00 Budgeted 4,668.16 Remaining 53 % 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 1715 07/18/2014 MUD Payroll 7/18/14 Certification 1,350.00 150.00 1,500.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,500.00 ** 1,800.00 Budgeted 300.00 Remaining 83 % Used Account: 135-50020-021-000 Retirement 1644 07/03/2014 MUD Payroll 7/3/14 Retirement 5,884.96 353.57 6,238.53 PR 1715 07/18/2014 MUD Payroll 7/18/14 Retirement 368.36 6,606.89 PR _______________ Account: 135-50020-021-000 Retirement Totals: 721.93 6,606.89 ** 9,025.00 Budgeted 2,418.11 Remaining 73 % Used Account: 135-50026-021-000 Medical Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Medical Insurance 14,094.99 736.86 14,831.85 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medical Insurance 736.84 15,568.69 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 15,568.69 ** 23,668.00 Budgeted 8,099.31 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Dental Insurance 1,017.99 51.30 1,069.29 PR 1715 07/18/2014 MUD Payroll 7/18/14 Dental Insurance 51.30 1,120.59 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 1,120.59 ** 1,703.00 Budgeted 582.41 Remaining 66 % Used Account: 135-50028-021-000 Vision Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Vision Insurance 217.93 11.84 229.77 PR 1715 07/18/2014 MUD Payroll 7/18/14 Vision Insurance 11.84 241.61 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 241.61 ** 314.00 Budgeted 72.39 Remaining 77 % Used Account: 135-50029-021-000 Life Insurance & Other 1682 07/07/2014 July A/P Dental, Vision and other Insur 757.74 72.75 830.49 METLIFE 33949 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 72.75 830.49 ** 1,066.00 Budgeted 235.51 Remaining 78 % Used Account: 135-50030-021-000 Social Security Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Social Security Taxes 3,701.54 228.63 3,930.17 PR 1715 07/18/2014 MUD Payroll 7/18/14 Social Security Taxes 231.95 4,162.12 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 460.58 4,162.12 ** 7,442.00 Budgeted 3,279.88 Remaining 56 % Used Account: 135-50035-021-000 Medicare Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Medicare Taxes 865.68 53.47 919.15 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medicare Taxes 54.26 973.41 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 107.73 973.41 ** 1,741.00 Budgeted 767.59 Remaining 56 % 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 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/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 57 07/01/2014 Jul Ins & W/C Expense 2,407.86 267.54 2,675.40 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 2,675.40 ** 3,276.00 Budgeted 600.60 Remaining 82 % Used Account: 135-50070-021-000 Employee Relations 1881 07/28/2014 6/27/14-7/28/14 PCards WHATABURGER 754 Q26 209.23 21.05 230.28 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 21.05 230.28 ** 200.00 Budgeted (30.28) Remaining 115 % Used Account: 135-55080-021-000 Maintenance & Repairs 1702 07/11/2014 July A/P PM on Gapvax 8,062.64 2,759.69 10,822.33 UNDERGROUND INC 33970 AP 1881 07/28/2014 6/27/14-7/28/14 PCards FASTENAL COMPANY01 3.23 10,825.56 FASTENAL COMPANY01 PC 1881 07/28/2014 6/27/14-7/28/14 PCards TRACTOR SUPPLY COMPANY 41.97 10,867.53 TRACTOR SUPPLY COMPANY PC 1881 07/28/2014 6/27/14-7/28/14 PCards FERGUSON ENT #788 50.32 10,917.85 FERGUSON ENT #788 PC 1876 07/31/2014 July A/P 8" Boom Elbow Assembly W/O Sti 2,146.80 13,064.65 UNDERGROUND INC 34054 AP 1876 07/31/2014 July A/P Hydromatic discharge gasket re 271.56 13,336.21 NORTH TEXAS PUMP CO. 34041 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 5,273.57 13,336.21 ** 14,451.00 Budgeted 1,114.79 Remaining 92 % 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 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 1,097.04 102.72 1,199.76 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 102.72 1,199.76 ** 1,333.00 Budgeted 133.24 Remaining 90 % Used Account: 135-60020-021-000 Electricity 1730 07/17/2014 July A/P Elec 5/30/14-6/30/14 15,337.94 468.19 15,806.13 TRI COUNTY ELECTRIC 33995 AP 1730 07/17/2014 July A/P Elec 5/30/14-6/30/14 231.34 16,037.47 TRI COUNTY ELECTRIC 33995 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1730 07/17/2014 July A/P Elec 5/30/14-6/30/14 15,337.94 28.49 16,065.96 TRI COUNTY ELECTRIC 33995 AP 1762 07/24/2014 July A/P Electricity 6/12-7/14/14 61.40 16,127.36 HUDSON ENERGY SERVICES, LLC 34002 AP 1762 07/24/2014 July A/P Electricity 6/12-7/14/14 40.44 16,167.80 HUDSON ENERGY SERVICES, LLC 34002 AP 1762 07/24/2014 July A/P Electricity 6/13-7/14/14 95.96 16,263.76 HUDSON ENERGY SERVICES, LLC 34002 AP 1772 07/24/2014 July A/P Electricity 6/13-7/15/14 820.35 17,084.11 HUDSON ENERGY SERVICES, LLC 34017 AP 1772 07/24/2014 July A/P Electricity 6/13-7/15/14 268.53 17,352.64 HUDSON ENERGY SERVICES, LLC 34017 AP 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (89.69) 17,262.95 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,925.01 17,262.95 ** 21,178.00 Budgeted 3,915.05 Remaining 82 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards SCMA 111.00 450.00 561.00 SCMA PC _______________ Account: 135-60080-021-000 Schools & Training Totals: 450.00 561.00 ** 911.00 Budgeted 350.00 Remaining 62 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards HYATT HOTELS SAN ANTON 38.49 668.76 707.25 HYATT HOTELS SAN ANTON PC _______________ Account: 135-60100-021-000 Travel & per diem Totals: 668.76 707.25 ** 250.00 Budgeted (457.25) Remaining 283 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1863 07/31/2014 MUD Gas log/July 8,869.42 1,033.74 9,903.16 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,033.74 9,903.16 ** 21,747.00 Budgeted 11,843.84 Remaining 46 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 43.99 199.00 242.99 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-021-000 Small Tools Totals: 199.00 242.99 ** 300.00 Budgeted 57.01 Remaining 81 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 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: ------------------------------------------------------------------------------------------------ 216,693.50 ** 377,531.00 Budgeted 160,837.50 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Salaries & Wages 6,500.00 500.00 7,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 7,000.00 ** 10,000.00 Budgeted 3,000.00 Remaining 70 % Used Account: 135-50030-026-000 Social Security Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Social Security Taxes 403.00 31.00 434.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 434.00 ** 620.00 Budgeted 186.00 Remaining 70 % Used Account: 135-50035-026-000 Medicare Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Medicare Taxes 94.25 7.25 101.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 101.50 ** 145.00 Budgeted 43.50 Remaining 70 % Used Account: 135-50040-026-000 Unemployment Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Unemployment Taxes 94.50 11.50 106.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 11.50 106.00 ** 230.00 Budgeted 124.00 Remaining 46 % Used Account: 135-50045-026-000 Workman's Compensation 57 07/01/2014 Jul Ins & W/C Expense 26.53 2.94 29.47 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 29.47 ** 36.00 Budgeted 6.53 Remaining 82 % 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 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1881 07/28/2014 6/27/14-7/28/14 PCards KELLER TROPHY AND AWAR 132.92 105.00 237.92 KELLER TROPHY AND AWAR PC 1881 07/28/2014 6/27/14-7/28/14 PCards RANDALLS STORE00017897 10.00 247.92 RANDALLS STORE00017897 PC 1881 07/28/2014 6/27/14-7/28/14 PCards WEINBERGERS DELI TWO 59.95 307.87 WEINBERGERS DELI TWO PC _______________ Account: 135-60075-026-000 Meetings Totals: 174.95 307.87 ** 1,200.00 Budgeted 892.13 Remaining 26 % Used Account: 135-60080-026-000 Schools & Training 1881 07/28/2014 6/27/14-7/28/14 PCards NCTCOG AGENCY SRVCS 632.00 125.00 757.00 NCTCOG AGENCY SRVCS PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 125.00 757.00 ** 4,000.00 Budgeted 3,243.00 Remaining 19 % 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,991.90 ** 22,881.00 Budgeted 13,889.10 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Salaries & Wages 318,804.24 17,545.13 336,349.37 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Salaries & Wages 2,135.27 338,484.64 PR 1715 07/18/2014 MUD Payroll 7/18/14 Salaries & Wages 16,179.77 354,664.41 PR 1762 07/24/2014 July A/P Temp Receptionist 640.00 355,304.41 TRINITY EMPLOYMENT SOLUTIONS 34011 AP 1876 07/31/2014 July A/P Temporary Receptionist 640.00 355,944.41 TRINITY EMPLOYMENT SOLUTIONS 34052 AP 1876 07/31/2014 July A/P Temporary Receptionist 640.00 356,584.41 TRINITY EMPLOYMENT SOLUTIONS 34052 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,780.17 356,584.41 ** 458,721.00 Budgeted 102,136.59 Remaining 78 % Used Account: 135-50010-030-000 Overtime 1644 07/03/2014 MUD Payroll 7/3/14 Overtime 745.75 17.94 763.69 PR 1715 07/18/2014 MUD Payroll 7/18/14 Overtime 37.86 801.55 PR _______________ Account: 135-50010-030-000 Overtime Totals: 55.80 801.55 ** 750.00 Budgeted (51.55) Remaining 107 % 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 1644 07/03/2014 MUD Payroll 7/3/14 Retirement 29,944.67 1,577.19 31,521.86 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Retirement 191.74 31,713.60 PR 1715 07/18/2014 MUD Payroll 7/18/14 Retirement 1,456.33 33,169.93 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,225.26 33,169.93 ** 41,419.00 Budgeted 8,249.07 Remaining 80 % Used Account: 135-50026-030-000 Medical Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Medical Insurance 42,160.09 2,402.43 44,562.52 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Medical Insurance 296.66 44,859.18 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medical Insurance 2,105.72 46,964.90 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,804.81 46,964.90 ** 57,923.00 Budgeted 10,958.10 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1644 07/03/2014 MUD Payroll 7/3/14 Dental Insurance 3,107.45 170.19 3,277.64 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Dental Insurance 16.38 3,294.02 PR 1715 07/18/2014 MUD Payroll 7/18/14 Dental Insurance 153.85 3,447.87 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.42 3,447.87 ** 5,100.00 Budgeted 1,652.13 Remaining 68 % Used Account: 135-50028-030-000 Vision Insurance 1644 07/03/2014 MUD Payroll 7/3/14 Vision Insurance 737.31 40.78 778.09 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Vision Insurance 4.53 782.62 PR 1715 07/18/2014 MUD Payroll 7/18/14 Vision Insurance 36.31 818.93 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 818.93 ** 1,087.00 Budgeted 268.07 Remaining 75 % Used Account: 135-50029-030-000 Life Insurance & Other 1682 07/07/2014 July A/P Dental, Vision and other Insur 3,563.91 313.98 3,877.89 METLIFE 33949 AP 1682 07/07/2014 July A/P Café 125 Adm fees 38.16 3,916.05 BenefitMall 33918 AP 1762 07/24/2014 July A/P Café 125 Admin Fee 38.16 3,954.21 BenefitMall 33999 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 390.30 3,954.21 ** 5,500.00 Budgeted 1,545.79 Remaining 72 % Used Account: 135-50030-030-000 Social Security Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Social Security Taxes 19,543.10 1,057.11 20,600.21 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Social Security Taxes 132.39 20,732.60 PR 1715 07/18/2014 MUD Payroll 7/18/14 Social Security Taxes 939.41 21,672.01 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,128.91 21,672.01 ** 28,659.00 Budgeted 6,986.99 Remaining 76 % Used Account: 135-50035-030-000 Medicare Taxes 1644 07/03/2014 MUD Payroll 7/3/14 Medicare Taxes 4,570.57 247.23 4,817.80 PR 1666 07/03/2014 Supplemental Payroll 7/3/14 Medicare Taxes 30.97 4,848.77 PR 1715 07/18/2014 MUD Payroll 7/18/14 Medicare Taxes 219.69 5,068.46 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 497.89 5,068.46 ** 6,702.00 Budgeted 1,633.54 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-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 Account: 135-50045-030-000 Workman's Compensation 57 07/01/2014 Jul Ins & W/C Expense 1,157.65 128.62 1,286.27 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.62 1,286.27 ** 1,575.00 Budgeted 288.73 Remaining 82 % 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 2,732.68 .00 2,732.68 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,732.68 ** 5,000.00 Budgeted 2,267.32 Remaining 55 % Used Account: 135-55030-030-000 Software & Support 1881 07/28/2014 6/27/14-7/28/14 PCards WIN 911 SOFTWARE 42,386.80 395.00 42,781.80 WIN 911 SOFTWARE PC 1881 07/28/2014 6/27/14-7/28/14 PCards BADGER METER INC 989.04 43,770.84 BADGER METER INC PC 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 645.50 44,416.34 TOWN OF TROPHY CLUB 34051 AP 1876 07/31/2014 July A/P BOA PCards IT 160.90 44,577.24 TOWN OF TROPHY CLUB 34051 AP 1876 07/31/2014 July A/P Kyocera, Videotex 497.50 45,074.74 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,687.94 45,074.74 ** 59,698.00 Budgeted 14,623.26 Remaining 76 % Used Account: 135-55070-030-000 Independent Labor 1730 07/17/2014 July A/P Record MUD and Joint meeting 8,400.48 54.30 8,454.78 MIGUEL CRUZ 33988 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 54.30 8,454.78 ** 7,000.00 Budgeted (1,454.78) Remaining 121 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1881 07/28/2014 6/27/14-7/28/14 PCards THE HOME DEPOT 6581 428.45 75.00 503.45 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 75.00 503.45 ** 4,500.00 Budgeted 3,996.55 Remaining 11 % Used Account: 135-55100-030-000 Building Maint & Supplies 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: 2,587.16 (188.84) 2,398.32 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: (188.84) 2,398.32 ** 6,500.00 Budgeted 4,101.68 Remaining 37 % Used Account: 135-55120-030-000 Cleaning Services 1730 07/17/2014 July A/P June janitorial service 12,759.76 1,594.97 14,354.73 MEMBER'S BUILDING MAINTENANCE 33987 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 14,354.73 ** 19,140.00 Budgeted 4,785.27 Remaining 75 % Used Account: 135-55160-030-000 Professional Outside Services 1881 07/28/2014 6/27/14-7/28/14 PCards M3 NETWORKS 500.00 500.00 M3 NETWORKS PC _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 500.00 500.00 ** 10,000.00 Budgeted 9,500.00 Remaining 5 % 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 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1730 07/17/2014 July A/P June Water billing statements 5,825.41 609.40 6,434.81 DATAPROSE LLC 33975 AP 1730 07/17/2014 July A/P Credit memo for Insert (285.94) 6,148.87 DATAPROSE LLC 33975 AP 1908 07/31/2014 July A/P July Water billing 595.37 6,744.24 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 918.83 6,744.24 ** 6,808.00 Budgeted 63.76 Remaining 99 % Used Account: 135-60005-030-000 Telephone 1730 07/17/2014 July A/P Answering service 9,607.16 181.53 9,788.69 KEYSTONE PARK SECRETARIAL 33985 AP 1876 07/31/2014 July A/P BOA PCards IT 835.21 10,623.90 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,016.74 10,623.90 ** 11,250.00 Budgeted 626.10 Remaining 94 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1715 07/18/2014 MUD Payroll 7/18/14 Communications/Pagers/Mobiles 2,664.60 300.00 2,964.60 PR 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 37.99 3,002.59 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 3,002.59 ** 4,057.00 Budgeted 1,054.41 Remaining 74 % Used Account: 135-60020-030-000 Electricity/Gas 11,834.10 .00 11,834.10 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 11,834.10 ** 15,171.00 Budgeted 3,336.90 Remaining 78 % Used Account: 135-60025-030-000 Water 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: 710.14 (104.75) 605.39 AR 1876 07/31/2014 July A/P July Water 104.75 710.14 TROPHY CLUB MUD (WATER BILLS) 34053 AP _______________ Account: 135-60025-030-000 Water Totals: .00 710.14 ** 1,500.00 Budgeted 789.86 Remaining 47 % Used Account: 135-60035-030-000 Postage 1730 07/17/2014 July A/P Overnight Letter 18,720.67 4.99 18,725.66 FEDERAL EXPRESS CORP 33978 AP 1730 07/17/2014 July A/P June Water billing statements 1,694.47 20,420.13 DATAPROSE LLC 33975 AP 1768 07/24/2014 July A/P Overnight letters 10.58 20,430.71 FEDERAL EXPRESS CORP 34001 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1844 07/31/2014 July Postage Meter Usage 18,720.67 164.89 20,595.60 GL 1908 07/31/2014 July A/P July Water billing 1,691.23 22,286.83 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 3,566.16 22,286.83 ** 28,500.00 Budgeted 6,213.17 Remaining 78 % Used Account: 135-60040-030-000 Service Charges & Fees 1866 07/02/2014 Credit Card Fees 23,394.25 52.57 23,446.82 GL 1866 07/02/2014 Credit Card Fees 97.80 23,544.62 GL 1866 07/02/2014 Credit Card Fees 3,085.75 26,630.37 GL 1871 07/16/2014 FF Bank June Account Analysis 250.00 26,880.37 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,486.12 26,880.37 ** 28,330.00 Budgeted 1,449.63 Remaining 95 % Used Account: 135-60050-030-000 Bad Debt Expense 4,351.64 .00 4,351.64 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 4,351.64 ** 6,200.00 Budgeted 1,848.36 Remaining 70 % Used Account: 135-60055-030-000 Insurance 57 07/01/2014 Jul Ins & W/C Expense 38,755.82 4,269.73 43,025.55 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 43,025.55 ** 53,561.00 Budgeted 10,535.45 Remaining 80 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 _______________ 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 4,311.95 .00 4,311.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,311.95 ** 4,500.00 Budgeted 188.05 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-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 1819 07/31/2014 TCDRS Partial Refund/Sisk 2,849.25 (184.99) 2,664.26 GL _______________ Account: 135-60080-030-000 Schools & Training Totals: (184.99) 2,664.26 ** 6,800.00 Budgeted 4,135.74 Remaining 39 % Used Account: 135-60100-030-000 Travel & per diem 1644 07/03/2014 MUD Payroll 7/3/14 Travel & per diem 2,408.50 15.90 2,424.40 PR 1730 07/17/2014 July A/P Toll reimbursement 19.90 2,444.30 LAURIE SLAGHT 33986 AP 1762 07/24/2014 July A/P Mileage (Austin) 241.82 2,686.12 JENNIFER MCKNIGHT 34003 AP 1775 07/24/2014 Void A/P Ck 34003/wrong rate Mileage (Austin) (241.82) 2,444.30 JENNIFER MCKNIGHT 34003 AP 1776 07/24/2014 July A/P Mileage (Austin) 239.68 2,683.98 JENNIFER MCKNIGHT 34018 AP 1881 07/28/2014 6/27/14-7/28/14 PCards CONGRESS AUSTIN 32.15 2,716.13 CONGRESS AUSTIN PC 1881 07/28/2014 6/27/14-7/28/14 PCards TEXADELPHIA 5.40 2,721.53 TEXADELPHIA PC 1881 07/28/2014 6/27/14-7/28/14 PCards TEXADELPHIA 10.18 2,731.71 TEXADELPHIA PC 1881 07/28/2014 6/27/14-7/28/14 PCards SW *HOTELSMPQZSG 240.31 2,972.02 SW *HOTELSMPQZSG PC 1881 07/28/2014 6/27/14-7/28/14 PCards STARBUCKS #02832 HILLS 3.41 2,975.43 STARBUCKS #02832 HILLS PC 1881 07/28/2014 6/27/14-7/28/14 PCards LAVAZZA ESPRESSION 1.50 2,976.93 LAVAZZA ESPRESSION PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 568.43 2,976.93 ** 5,000.00 Budgeted 2,023.07 Remaining 60 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60115-030-000 Elections 3,709.19 .00 3,709.19 _______________ Account: 135-60115-030-000 Elections Totals: .00 3,709.19 ** 2,500.00 Budgeted (1,209.19) Remaining 148 % Used Account: 135-60125-030-000 Advertising 1730 07/17/2014 July A/P Classified Ad-Receptionist/Uti 589.43 150.00 739.43 TX MUNICIPAL LEAGUE 33997 AP _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 739.43 ** 2,500.00 Budgeted 1,760.57 Remaining 30 % 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 1881 07/28/2014 6/27/14-7/28/14 PCards VCN*DENTONRECCTR 1,956.15 108.00 2,064.15 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 108.00 2,064.15 ** 17,870.00 Budgeted 15,805.85 Remaining 12 % 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-60336-030-000 Interfund Trans Out (MUD1 I&S) 1780 07/22/2014 Transfer PID Util Fees to I&S 16,525.00 16,525.00 GL _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: 16,525.00 16,525.00 ** .00 Budgeted (16,525.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1876 07/31/2014 July A/P BOA PCards IT 7,365.90 108.56 7,474.46 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-65055-030-000 Hardware Totals: 108.56 7,474.46 ** 13,562.00 Budgeted 6,087.54 Remaining 55 % Used Account: 135-65085-030-000 Office Supplies 1730 07/17/2014 July A/P Copier paper 3,560.38 57.98 3,618.36 OFFICE DEPOT, INC 33989 AP 1730 07/17/2014 July A/P UB postcards 402.75 4,021.11 DESKTOP PUBLISHING SUPPLIES 33976 AP 1762 07/24/2014 July A/P Office Supplies 179.10 4,200.21 OFFICE DEPOT, INC 34006 AP 1762 07/24/2014 July A/P Office Supplies 15.99 4,216.20 OFFICE DEPOT, INC 34006 AP 1881 07/28/2014 6/27/14-7/28/14 PCards PROBLEM SOLVER 111.55 4,327.75 PROBLEM SOLVER PC 1865 07/31/2014 Bill Town Inv 1187-1195 AR 20140701-20140731 User: (59.43) 4,268.32 AR 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 45.60 4,313.92 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 753.54 4,313.92 ** 9,100.00 Budgeted 4,786.08 Remaining 47 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1876 07/31/2014 July A/P SHI,Charter, Verizon, JPMC rec 3,651.92 375.70 4,027.62 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 375.70 4,027.62 ** 5,732.00 Budgeted 1,704.38 Remaining 70 % Used Account: 135-65095-030-000 Maintenance Supplies 1881 07/28/2014 6/27/14-7/28/14 PCards WAL-MART #0266 2,240.99 37.35 2,278.34 WAL-MART #0266 PC 1881 07/28/2014 6/27/14-7/28/14 PCards SAMS CLUB #4795 121.56 2,399.90 SAMS CLUB #4795 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1881 07/28/2014 6/27/14-7/28/14 PCards AMAZON MKTPLACE PMTS 2,240.99 41.92 2,441.82 AMAZON MKTPLACE PMTS PC 1881 07/28/2014 6/27/14-7/28/14 PCards AMAZON.COM 44.48 2,486.30 AMAZON.COM PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 245.31 2,486.30 ** 2,500.00 Budgeted 13.70 Remaining 99 % 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 3,424.27 .00 3,424.27 _______________ Account: 135-65105-030-000 Printing Totals: .00 3,424.27 ** 4,000.00 Budgeted 575.73 Remaining 86 % Used Account: 135-69170-030-000 Copier Lease Installments 1876 07/31/2014 July A/P Kyocera, Videotex 1,926.39 128.42 2,054.81 TOWN OF TROPHY CLUB 34051 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 128.42 2,054.81 ** 3,450.00 Budgeted 1,395.19 Remaining 60 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 820,059.53 ** 1,056,620.00 Budgeted 236,560.47 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 1730 07/17/2014 July A/P June legal 264,211.11 1,265.00 265,476.11 FREEMAN & CORBETT 33979 AP 1730 07/17/2014 July A/P Legal 97,182.37 362,658.48 Fulbright & Jaworski LLP 33980 AP 1762 07/24/2014 July A/P June Legal 192.50 362,850.98 THE LISTON LAW FIRM, P.C. 34010 AP 1762 07/24/2014 July A/P June Legal/General 1,769.60 364,620.58 WHITAKER CHALK SWINDLE 34012 AP 1762 07/24/2014 July A/P June Legal/Bond Issue WWTP 537.60 365,158.18 WHITAKER CHALK SWINDLE 34012 AP 1762 07/24/2014 July A/P June Legal/BDMR 1,339.80 366,497.98 WHITAKER CHALK SWINDLE 34012 AP 1908 07/31/2014 July A/P July Legal 5,284.62 371,782.60 FREEMAN & CORBETT AP 1908 07/31/2014 July A/P Legal/July 4,276.00 376,058.60 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-000 Legal Totals: 111,847.49 376,058.60 ** 347,126.00 Budgeted (28,932.60) Remaining 108 % 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 8,158.30 .00 8,158.30 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 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: ------------------------------------------------------------------------------------------------ 407,868.30 ** 382,766.00 Budgeted (25,102.30) Remaining 107 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 258,429.66 .00 Budgeted (258,429.66) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/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 1872 07/31/2014 Bank Interest/July (67.80) (7.43) (75.23) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (7.43) (75.23) ** .00 Budgeted 75.23 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,075.23) ** .00 Budgeted 120,075.23 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 528,799 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 10,666 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 544,311 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,666 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 10,666 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 515,766 TOTAL FUND BALANCE 533,645 TOTAL LIABILITIES AND FUND BALANCE 544,311 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 10:58 08/13/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000- Property Taxes 389,216.00- 389,216.00- 1,478.23- 386,447.80- 99.289 2,768.20- 533-40002-000- Property Taxes/Delinquent 2,500.00- 2,500.00- 459.43- 18.377 2,040.57- 533-40015-000- Property Taxes/P & I 1,600.00- 1,600.00- 87.64- 2,137.71- 133.607 537.71 Subtotal: 393,316.00- 393,316.00- 1,565.87- 389,044.94- 98.914 4,271.06- 533-48005-000- Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- 16,525.00- 100.000 Subtotal: 16,525.00- 16,525.00- 16,525.00- 16,525.00- 100.000 533-49010-000- Interest Income 375.00- 375.00- 13.73- 83.63- 22.301 291.37- 533-49015-000- Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 13.73- 214,362.63- 99.864 291.37- Program number: 624,495.00- 624,495.00- 18,104.60- 619,932.57- 99.269 4,562.43- Department number: Revenues 624,495.00- 624,495.00- 18,104.60- 619,932.57- 99.269 4,562.43- Revenues Subtotal ----- 624,495.00- 624,495.00- 18,104.60- 619,932.57- 99.269 4,562.43- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 10:58 08/13/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051- Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 43.478 1,300.00 533-70025-051- Bond Interest Expense-Tax 197,195.00 197,195.00 103,166.25 52.317 94,028.75 533-70035-051- Bond Principal Payment-Tax 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 18,104.60- 515,766.32- 515,766.32 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 7/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 1856 07/01/2014 Fain Grp-App1-Ind Crk 3,372.00 2,647.50 6,019.50 GL 1769 07/24/2014 July A/P Indian Creek Dr (Edgemere to M 50,302.50 56,322.00 The Fain Group 34009 AP 1876 07/31/2014 July A/P Indian Creek Waterline Replace 300.00 56,622.00 TEAGUE, NALL & PERKINS,INC 34050 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 53,250.00 56,622.00 ** 282,245.17 Budgeted 225,623.17 Remaining 20 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 139,251.40 ** 282,245.17 Budgeted 142,993.77 Remaining 49 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 19,176.17 282,245.17 Budgeted 263,069.00 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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 1800 07/07/2014 Property Taxes/Assessments (384,969.57) (14.86) (384,984.43) GL 1801 07/08/2014 Property Taxes/Assessments (9.61) (384,994.04) GL 1802 07/10/2014 Property Taxes/Assessments (23.07) (385,017.11) GL 1805 07/11/2014 Property Taxes/Assessments (15.58) (385,032.69) GL 1806 07/14/2014 Property Taxes/Assessments (90.38) (385,123.07) GL 1807 07/15/2014 Property Taxes/Assessments (82.28) (385,205.35) GL 1808 07/16/2014 Property Taxes/Assessments (35.97) (385,241.32) GL 1809 07/17/2014 Property Taxes/Assessments (45.63) (385,286.95) GL 1810 07/18/2014 Property Taxes/Assessments (196.38) (385,483.33) GL 1811 07/21/2014 Property Taxes/Assessments (37.55) (385,520.88) GL 1812 07/23/2014 Property Taxes/Assessments (32.52) (385,553.40) GL 1813 07/24/2014 Property Taxes/Assessments (76.75) (385,630.15) GL 1814 07/25/2014 Property Taxes/Assessments (85.83) (385,715.98) GL 1815 07/28/2014 Property Taxes/Assessments (531.99) (386,247.97) GL 1816 07/29/2014 Property Taxes/Assessments (32.86) (386,280.83) GL 1820 07/30/2014 Property Taxes/Assessments (53.30) (386,334.13) GL 1845 07/31/2014 Property Taxes/Assessments (113.67) (386,447.80) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,478.23) (386,447.80) ** (389,216.00) Budgeted (2,768.20) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (459.43) .00 (459.43) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (459.43) ** (2,500.00) Budgeted (2,040.57) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 1800 07/07/2014 Property Taxes/Assessments (2,050.07) (2.23) (2,052.30) GL 1801 07/08/2014 Property Taxes/Assessments (.37) (2,052.67) GL 1802 07/10/2014 Property Taxes/Assessments (1.40) (2,054.07) GL 1815 07/28/2014 Property Taxes/Assessments (83.64) (2,137.71) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (87.64) (2,137.71) ** (1,600.00) Budgeted 537.71 Remaining 134 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees 1780 07/22/2014 Transfer PID Util Fees to I&S (16,525.00) (16,525.00) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: (16,525.00) (16,525.00) ** (16,525.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 1872 07/31/2014 Bank Interest/July (69.90) (13.73) (83.63) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (13.73) (83.63) ** (375.00) Budgeted (291.37) Remaining 22 % 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: ------------------------------------------------------------------------------------------------ (619,932.57) ** (624,495.00) Budgeted (4,562.43) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 10:58 08/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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-Tax 103,166.25 .00 103,166.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 103,166.25 ** 197,195.00 Budgeted 94,028.75 Remaining 52 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax 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: ------------------------------------------------------------------------------------------------------ (515,766.32) .00 Budgeted 515,766.32 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (469,599.82) **** 282,245.17 Budgeted 751,844.99 Remaining ########## ******* End of Report *********