Loading...
HomeMy WebLinkAbout2017-08 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 572,642 PREPAID EXPENSES 1,376 ADVALOREM PROPERTY TAXES RECEIVABLE 17,798 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 591,816 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 17,798 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 17,798 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 52,910 TOTAL FUND BALANCE 574,018 TOTAL LIABILITIES AND FUND BALANCE 591,816 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:29 09/14/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 1,321.19- 1,034,942.21- 99.916 867.79- 122-40011-000-000 Property Taxes/Fire-Delinquent 6.61- 2,887.32- 2,887.32 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 91.30- 3,873.85- 86.086 626.15- Subtotal: 1,040,310.00- 1,040,310.00- 1,419.10- 1,041,815.40- 100.145 1,505.40 122-49036-000-000 GASB Reserves 23,163.91- 23,163.91- 23,163.91 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 23,163.91- 23,312.91- 23,312.91 Program number: 1,040,310.00- 1,040,310.00- 24,583.01- 1,065,128.31- 102.386 24,818.31 Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 24,583.01- 1,065,128.31- 102.386 24,818.31 Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 24,583.01- 1,065,128.31- 102.386 24,818.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:29 09/14/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 12,410.00 23,163.91 23,163.91- Subtotal: 12,410.00 23,163.91 23,163.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 100.000 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 15,136.99 91.667 1,376.01 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 532,659.00 91.579 48,979.00 Subtotal: 814,905.00 814,905.00 50,350.09 764,549.99 93.821 50,355.01 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 15,936.00 15,936.00 94.654 900.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 225,405.00 225,405.00 15,936.00 224,504.60 99.601 900.40 Program number: 1,040,310.00 1,040,310.00 78,696.09 1,012,218.50 97.300 28,091.50 Department number: Fire 1,040,310.00 1,040,310.00 78,696.09 1,012,218.50 97.300 28,091.50 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 78,696.09 1,012,218.50 97.300 28,091.50 Fund number: 122 Trophy Club MUD Fire Dept. 54,113.08 52,909.81- 52,909.81 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2017 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 (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2229 08/01/2017 Property Taxes (1,033,621.02) (139.18) (1,033,760.20) GL 2230 08/02/2017 Property Taxes (101.59) (1,033,861.79) GL 2231 08/03/2017 Property Taxes (278.87) (1,034,140.66) GL 2233 08/07/2017 Property Taxes (454.61) (1,034,595.27) GL 2234 08/09/2017 Property Taxes (30.14) (1,034,625.41) GL 2235 08/10/2017 Property Taxes (9.73) (1,034,635.14) GL 2236 08/21/2017 Property Taxes (83.32) (1,034,718.46) GL 2237 08/22/2017 Property Taxes (2.29) (1,034,720.75) GL 2238 08/23/2017 Property Taxes (163.83) (1,034,884.58) GL 2271 08/30/2017 Property Taxes (57.63) (1,034,942.21) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,321.19) (1,034,942.21) ** (1,035,810.00) Budgeted (867.79) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2230 08/02/2017 Property Taxes (2,880.71) (6.58) (2,887.29) GL 2271 08/30/2017 Property Taxes (.03) (2,887.32) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (6.61) (2,887.32) ** .00 Budgeted 2,887.32 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2230 08/02/2017 Property Taxes (3,782.55) (2.57) (3,785.12) GL 2231 08/03/2017 Property Taxes (5.23) (3,790.35) GL 2233 08/07/2017 Property Taxes (52.61) (3,842.96) GL 2234 08/09/2017 Property Taxes (2.13) (3,845.09) GL 2235 08/10/2017 Property Taxes (1.36) (3,846.45) GL 2236 08/21/2017 Property Taxes (15.83) (3,862.28) GL 2237 08/22/2017 Property Taxes (.20) (3,862.48) GL 2238 08/23/2017 Property Taxes (7.33) (3,869.81) GL 2271 08/30/2017 Property Taxes (4.04) (3,873.85) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (91.30) (3,873.85) ** (4,500.00) Budgeted (626.15) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49036-000-000 GASB Reserves 2171 08/22/2017 GASB Xfer/Fire repairs FY 2017 (23,163.91) (23,163.91) GL _______________ Account: 122-49036-000-000 GASB Reserves Totals: (23,163.91) (23,163.91) ** .00 Budgeted 23,163.91 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (1,065,128.31) ** (24,583.01) Monthly Total (1,040,310.00) Budgeted 24,818.31 Remaining 102 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 2168 08/21/2017 August A/P Roof / Masonry Repairs (GASB R 10,753.91 12,410.00 23,163.91 Premier Metalwerks, LLC 3433 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 12,410.00 23,163.91 ** .00 Budgeted (23,163.91) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 216,754.00 .00 216,754.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 216,754.00 ** 216,754.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 470 08/01/2017 Insurance/Wrk Comp Exp Aug 13,760.90 1,376.09 15,136.99 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 15,136.99 ** 16,513.00 Budgeted 1,376.01 Remaining 92 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 2057 08/03/2017 August A/P Aug Fire ADmin 483,685.00 48,974.00 532,659.00 TOWN OF TROPHY CLUB 3389 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 532,659.00 ** 581,638.00 Budgeted 48,979.00 Remaining 92 % Used Account: 122-69005-045-000 Capital Outlays 2181 08/23/2017 August A/P Thermal Imagers 15,936.00 15,936.00 METRO FIRE APPARATUS 3426 AP _______________ Account: 122-69005-045-000 Capital Outlays Totals: 15,936.00 15,936.00 ** 16,836.00 Budgeted 900.00 Remaining 95 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 1,012,218.50 ** 78,696.09 Monthly Total 1,040,310.00 Budgeted 28,091.50 Remaining 97 % Used Fund 122 Totals: ----------------------------------- (52,909.81) 54,113.08 Monthly Total .00 Budgeted 52,909.81 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 897,303 - 897,303 CASH IN BANK-SAVINGS-CASH RESERVE 580,614 - 580,614 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,785 - 713,785 INVESTMENTS-TEXPOOL 1,063,542 410,006 1,473,548 PREPAID EXPENSES 10,300 - 10,300 ADVALOREM PROPERTY TAXES RECEIVABLE 1,786 - 1,786 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,192,310 - 1,192,310 TOTAL ASSETS 4,495,398 410,006 4,905,404 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,786 - 1,786 ACCOUNTS AND OTHER PAYABLES 819,313 - 819,313 CUSTOMER DEPOSITS 313,860 - 313,860 - TOTAL LIABILITIES 1,134,959 - 1,134,959 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 425,920 425,920 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 135,000 135,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 90,000 90,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 37,805 37,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 147,201 147,201 UNASSIGNED FUND BALANCE 1,702,202 - 1,702,202 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 1,228,831 - 1,228,831 - TOTAL FUND BALANCE 3,360,439 410,006 3,770,445 TOTAL LIABILITIES AND FUND BALANCE 4,495,398 410,006 4,905,404 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 77.74- 60,905.60- 99.883 71.40- 135-40002-000-000 Property Taxes/Delinquent 1.27- 269.29- 269.29 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 5.70- 260.08- 40.012 389.92- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 84.71- 61,434.97- 29.266 148,483.03- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 670,903.95- 5,101,008.48- 79.248 1,335,725.52- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 243,555.04- 2,319,734.94- 88.219 309,789.06- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 8,340.03- 107,185.76- 89.876 12,074.24- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,250.00- 13,425.00- 117.763 2,025.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 850.00- 2,350.00- 117.500 350.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 1,050.00- 4,650.00- 84.545 850.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 13,708.00- 71,989.85- 117.654 10,801.85 Subtotal: 9,265,606.00- 9,265,606.00- 939,657.02- 7,620,344.03- 82.243 1,645,261.97- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,913.37- 16,094.00- 201.150 8,093.00 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 10,015.83- 91.670 910.17- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49035-000-000 Prior Year Reserves 295,408.00- 295,408.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 2,315.00- 20,521.02- 94.965 1,087.98- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 948.21- 12,337.50- 61.688 7,662.50- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 6,670.44- 65,416.98- 17.924 299,547.02- Program number: 9,545,080.00- 9,840,488.00- 946,412.17- 7,747,195.98- 78.728 2,093,292.02- Department number: Revenues 9,545,080.00- 9,840,488.00- 946,412.17- 7,747,195.98- 78.728 2,093,292.02- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 946,412.17- 7,747,195.98- 78.728 2,093,292.02- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 17,261.56 197,796.51 72.949 73,346.49 135-50010-010-000 Overtime 19,500.00 19,500.00 1,070.02 11,241.69 57.650 8,258.31 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 175.00 2,400.00 50.000 2,400.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,711.86 19,539.85 71.967 7,611.15 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,362.21 27,203.03 48.652 28,710.97 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 243.46 2,661.23 63.987 1,497.77 135-50028-010-000 Vision Insurance 910.00 910.00 49.22 519.94 57.136 390.06 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 194.27 2,327.79 83.046 475.21 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,135.41 13,041.81 68.565 5,979.19 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 265.55 3,050.13 68.573 1,397.87 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 1.50 46.50 4.532 979.50 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 10,789.76 82.039 2,362.24 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 76.00 346.90 26.685 953.10 135-50070-010-000 Employee Relations 300.00 300.00 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 25,620.22 294,422.23 68.646 134,474.77 135-55005-010-000 Engineering 5,000.00 60,000.00 9,243.28- 28,762.16 47.937 31,237.84 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 7,125.30 74,933.81 58.314 53,566.19 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 2,459.00 81.967 541.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 44.95 2,102.75 26.284 5,897.25 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 200.00 3,748.26 68.150 1,751.74 Subtotal: 125,000.00 208,500.00 1,873.03- 112,005.98 53.720 96,494.02 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 363.72 3,523.80 65.256 1,876.20 135-60020-010-000 Electricity 172,737.00 172,737.00 15,601.49 138,807.68 80.358 33,929.32 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 767.00 102.267 17.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 825.00 19.541 3,397.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 124.46 8.297 1,375.54 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 3,037.90 24,978.35 49.781 25,197.65 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 264,173.29 1,736,536.79 57.908 1,262,265.21 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 102.70 51.350 97.30 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 666.60 13.332 4,333.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 6,750.00 45.763 8,000.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 240,821.65 81.082 56,189.35 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 4,083.00 43,964.45 67.721 20,955.55 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 310,652.28 2,197,868.48 57.530 1,622,499.52 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 727.28 7,693.52 30.987 17,134.48 135-65010-010-000 Uniforms 4,608.00 4,608.00 139.93 2,923.86 63.452 1,684.14 135-65030-010-000 Chemicals 20,000.00 20,000.00 10,660.36 22,833.07 114.165 2,833.07- 135-65035-010-000 Small Tools 1,200.00 1,200.00 867.64 72.303 332.36 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 506.50 506.50 50.650 493.50 135-65050-010-000 Meter Expense 115,000.00 31,500.00 23,999.88 76.190 7,500.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 71,160.00 87.313 10,340.00 Subtotal: 256,319.00 164,636.00 12,034.07 129,984.47 78.953 34,651.53 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 9,875.00- 343,087.82 49.692 347,334.18 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 126,958.00 126,957.75 100.000 .25 Subtotal: 696,196.00 892,380.00 9,875.00- 545,045.57 61.078 347,334.43 Program number: 5,326,780.00 5,514,781.00 336,558.54 3,279,326.73 59.464 2,235,454.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 1,503.10 30.062 3,496.90 Subtotal: 5,000.00 5,000.00 80.00 1,503.10 30.062 3,496.90 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 1,503.10 15.031 8,496.90 Department number: Water 5,336,780.00 5,524,781.00 336,638.54 3,280,829.83 59.384 2,243,951.17 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 29,978.08 342,451.67 87.561 48,650.33 135-50010-020-000 Overtime 29,500.00 29,500.00 1,679.81 28,558.63 96.809 941.37 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 700.00 7,575.00 97.115 225.00 135-50020-020-000 Retirement 39,584.00 39,584.00 2,993.12 35,082.53 88.628 4,501.47 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 50,425.31 69.055 22,596.69 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 4,065.00 88.524 527.00 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 869.91 84.375 161.09 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 393.14 4,159.22 92.736 325.78 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,872.96 22,446.16 80.493 5,439.84 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 438.03 5,249.50 80.489 1,272.50 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 63.00 5.263 1,134.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 926.75 13,976.25 123.171 2,629.25- 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 80.00 26.667 220.00 135-50070-020-000 Employee Relations 650.00 650.00 69.38 461.00 70.923 189.00 Subtotal: 605,653.00 605,653.00 44,245.12 522,098.18 86.204 83,554.82 135-55005-020-000 Engineering 70,000.00 70,000.00 852.48 1.218 69,147.52 135-55070-020-000 Independent Labor 20,000.00 20,000.00 19,449.39 97.247 550.61 135-55080-020-000 Maintenance & Repairs 83,100.00 79,700.00 5,821.19 96,989.45 121.693 17,289.45- 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 6,076.00 30.380 13,924.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 181.99 7,782.41 117.915 1,182.41- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,553.59 49,944.68 90.809 5,055.32 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 3,486.50 30,265.06 121.060 5,265.06- Subtotal: 277,600.00 276,800.00 12,043.27 211,383.41 76.367 65,416.59 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 629.45 4,709.54 87.214 690.46 135-60020-020-000 Electricity 158,627.00 158,627.00 12,821.76 130,049.21 81.984 28,577.79 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 143.85 35.963 256.15 135-60070-020-000 Dues & Memberships 250.00 267.00 267.00 100.000 135-60080-020-000 Schools & Training 4,195.00 4,195.00 2,357.81 56.205 1,837.19 135-60090-020-000 Safety Program 550.00 550.00 291.12 52.931 258.88 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 107.88 2,486.18 103.591 86.18- 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 18,348.38 106.988 1,198.38- 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 113.27 25.171 336.73 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 6,621.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 5,310.00 45.776 6,290.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.80 120,492.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.90 595,638.00 100.000 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 10,278.00 170,139.25 137.773 46,647.25- 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,256,282.00 90,119.79 1,054,431.98 83.933 201,850.02 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 829.00 7,814.24 27.821 20,273.76 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,753.87 84.186 705.13 135-65030-020-000 Chemicals 25,000.00 21,000.00 23,247.95 110.705 2,247.95- 135-65035-020-000 Small Tools 2,000.00 2,000.00 211.64 1,682.36 84.118 317.64 135-65040-020-000 Safety Equipment 750.00 750.00 517.03 68.937 232.97 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 288.64 13,095.59 93.540 904.41 Subtotal: 74,297.00 70,297.00 1,329.28 50,111.04 71.285 20,185.96 135-69005-020-000 Capital Outlays 485,000.00 462,000.00 200,903.11 43.486 261,096.89 Subtotal: 485,000.00 462,000.00 200,903.11 43.486 261,096.89 Program number: 2,698,015.00 2,671,032.00 147,737.46 2,038,927.72 76.335 632,104.28 Department number: Wastewater 2,698,015.00 2,671,032.00 147,737.46 2,038,927.72 76.335 632,104.28 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 2.61 27.71 86.594 4.29 Subtotal: 32.00 32.00 2.61 27.71 86.594 4.29 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 145.45 12.121 1,054.55 135-60080-026-000 Schools & Training 4,000.00 4,000.00 270.00 3,557.35 88.934 442.65 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 2,446.95 48.939 2,553.05 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 270.00 6,149.75 47.858 6,700.25 Program number: 12,882.00 12,882.00 272.61 6,177.46 47.954 6,704.54 Department number: Board of Directors 12,882.00 12,882.00 272.61 6,177.46 47.954 6,704.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 29,616.87 381,324.38 73.348 138,558.62 135-50010-030-000 Overtime 1,000.00 2,500.00 73.55 3,410.12 136.405 910.12- 135-50016-030-000 Longevity 3,890.00 3,417.00 3,417.50 100.015 .50- 135-50020-030-000 Retirement 47,768.00 47,768.00 2,746.37 35,207.90 73.706 12,560.10 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 3,349.61 41,326.88 49.030 42,962.12 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 311.37 3,663.67 61.255 2,317.33 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 66.77 784.52 59.796 527.48 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 361.52 4,147.73 70.420 1,742.27 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 1,754.09 22,911.26 69.900 9,865.74 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 410.24 5,358.27 66.282 2,725.73 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 293.73 21.471 1,074.27 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 1,650.83 92.535 133.17 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 606.80 121.360 106.80- 135-50070-030-000 Employee Relations 4,960.00 4,960.00 34.94 2,640.34 53.233 2,319.66 Subtotal: 719,486.00 720,513.00 38,908.86 506,743.93 70.331 213,769.07 135-55030-030-000 Software & Support 67,791.00 77,791.00 4,820.07 87,205.49 112.102 9,414.49- 135-55070-030-000 Independent Labor 12,000.00 4,000.00 16,185.42 17,455.42 436.386 13,455.42- 135-55080-030-000 Maintenance & Repairs 7,000.00 2,000.00 826.00 41.300 1,174.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 485.00 4.850 9,515.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 268.97 6,769.75 96.711 230.25 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 6,071.60 75.895 1,928.40 135-55160-030-000 Professional Outside Services 63,325.00 60,000.00 4,085.64 61,417.64 102.363 1,417.64- 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 590.31 6,877.89 83.877 1,322.11 Subtotal: 185,945.00 177,191.00 26,583.47 187,108.79 105.597 9,917.79- 135-60005-030-000 Telephone 17,532.00 17,532.00 1,830.32 12,815.96 73.100 4,716.04 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 262.99 3,004.90 85.854 495.10 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 833.71 8,022.75 63.516 4,608.25 135-60025-030-000 Water 1,500.00 1,500.00 70.09 979.51 65.301 520.49 135-60035-030-000 Postage 28,932.00 28,932.00 1,632.04 25,674.03 88.739 3,257.97 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,146.29 47,590.85 85.657 7,969.15 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 526.88 15.054 2,973.12 135-60055-030-000 Insurance 55,692.00 55,692.00 8,412.16 54,949.96 98.668 742.04 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 437.63 769.51 48.094 830.49 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 190.00 4,851.25 80.854 1,148.75 135-60075-030-000 Meetings 400.00 400.00 15.98 121.69 30.423 278.31 135-60079-030-000 Public Education 8,754.00 8,754.00 4,972.32 56.801 3,781.68 135-60080-030-000 Schools & Training 7,840.00 7,840.00 420.00 2,255.00 28.763 5,585.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 100.48 7,111.81 94.824 388.19 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 45.00 2,970.33 39.604 4,529.67 135-60125-030-000 Advertising 7,500.00 7,500.00 1,698.09 22.641 5,801.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 160.96 .920 17,339.04 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,055.94 42.238 1,444.06 Subtotal: 246,041.00 247,491.00 19,396.69 179,531.74 72.541 67,959.26 135-65010-030-000 Uniforms 1,855.00 855.00 142.36 16.650 712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 2,300.20 24.356 7,143.80 135-65085-030-000 Office Supplies 9,000.00 9,000.00 265.58 5,124.79 56.942 3,875.21 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 85.98 754.36 37.718 1,245.64 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 500.03 3,684.01 92.100 315.99 135-65105-030-000 Printing 4,800.00 2,500.00 2,553.88 102.155 53.88- Subtotal: 32,099.00 27,799.00 851.59 14,559.60 52.375 13,239.40 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 9,875.00 119,756.15 45.119 145,667.85 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 362.30 3,364.85 73.149 1,235.15 Subtotal: 111,601.00 270,024.00 10,237.30 123,121.00 45.596 146,903.00 Program number: 1,295,172.00 1,443,018.00 95,977.91 1,011,065.06 70.066 431,952.94 Department number: Administration 1,295,172.00 1,443,018.00 95,977.91 1,011,065.06 70.066 431,952.94 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:29 09/14/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 86,145.51 151,326.30 100.884 1,326.30- 135-55055-039-000 Auditing 23,860.00 23,860.00 18,808.92 78.830 5,051.08 135-55060-039-000 Appraisal 11,115.00 11,115.00 8,667.45 77.980 2,447.55 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 86,145.51 181,364.43 96.074 7,410.57 Program number: 188,775.00 188,775.00 86,145.51 181,364.43 96.074 7,410.57 Department number: Non Departmental 188,775.00 188,775.00 86,145.51 181,364.43 96.074 7,410.57 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 666,772.03 6,518,364.50 66.240 3,322,123.50 Fund number: 135 MUD 1 General Fund 13,456.00- 279,640.14- 1,228,831.48- 1,228,831.48 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:29 09/14/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:29 09/14/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 23,163.91 23,163.91 23,163.91- Subtotal: 23,163.91 23,163.91 23,163.91- Program number: 23,163.91 23,163.91 23,163.91- Department number: Fire Department 23,163.91 23,163.91 23,163.91- Expenditures Subtotal ----------- 23,163.91 23,163.91 23,163.91- Fund number: 137 MUD 1 Consolidated GASB 23,163.91 133,256.09- 133,256.09 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 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 2229 08/01/2017 Property Taxes (60,827.86) (8.19) (60,836.05) GL 2230 08/02/2017 Property Taxes (5.98) (60,842.03) GL 2231 08/03/2017 Property Taxes (16.41) (60,858.44) GL 2233 08/07/2017 Property Taxes (26.75) (60,885.19) GL 2234 08/09/2017 Property Taxes (1.77) (60,886.96) GL 2235 08/10/2017 Property Taxes (.57) (60,887.53) GL 2236 08/21/2017 Property Taxes (4.90) (60,892.43) GL 2237 08/22/2017 Property Taxes (.14) (60,892.57) GL 2238 08/23/2017 Property Taxes (9.64) (60,902.21) GL 2271 08/30/2017 Property Taxes (3.39) (60,905.60) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (77.74) (60,905.60) ** (60,977.00) Budgeted (71.40) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2230 08/02/2017 Property Taxes (268.02) (1.27) (269.29) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.27) (269.29) ** .00 Budgeted 269.29 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2230 08/02/2017 Property Taxes (254.38) (.49) (254.87) GL 2231 08/03/2017 Property Taxes (.30) (255.17) GL 2233 08/07/2017 Property Taxes (3.09) (258.26) GL 2234 08/09/2017 Property Taxes (.13) (258.39) GL 2235 08/10/2017 Property Taxes (.08) (258.47) GL 2236 08/21/2017 Property Taxes (.93) (259.40) GL 2237 08/22/2017 Property Taxes (.01) (259.41) GL 2238 08/23/2017 Property Taxes (.43) (259.84) GL 2271 08/30/2017 Property Taxes (.24) (260.08) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (5.70) (260.08) ** (650.00) Budgeted (389.92) Remaining 40 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47000-000-000 Water 2243 08/04/2017 Adjustment UB20170804-20170804 User: (4,430,104.53) 38.35 (4,430,066.18) UB 2245 08/07/2017 Adjustments UB20170807-20170807 User: 32.23 (4,430,033.95) UB 2246 08/08/2017 adjustments UB20170808-20170808 User: 12.25 (4,430,021.70) UB 2248 08/09/2017 Account adjustments UB20170809-20170809 User: 57.55 (4,429,964.15) UB 2232 08/31/2017 August billing UB20170831-20170831 User: (671,044.33) (5,101,008.48) UB _______________ Account: 135-47000-000-000 Water Totals: (670,903.95) (5,101,008.48) ** (6,436,734.00) Budgeted (1,335,725.52) Remaining 79 % Used Account: 135-47005-000-000 Sewer 2245 08/07/2017 Adjustments UB20170807-20170807 User: (2,076,179.90) 40.95 (2,076,138.95) UB 2246 08/08/2017 adjustments UB20170808-20170808 User: 23.86 (2,076,115.09) UB 2248 08/09/2017 Account adjustments UB20170809-20170809 User: 23.86 (2,076,091.23) UB 2232 08/31/2017 August billing UB20170831-20170831 User: (243,643.71) (2,319,734.94) UB _______________ Account: 135-47005-000-000 Sewer Totals: (243,555.04) (2,319,734.94) ** (2,629,524.00) Budgeted (309,789.06) Remaining 88 % Used Account: 135-47025-000-000 Penalties 2250 08/11/2017 Penalty removals UB20170811-20170811 User: (98,845.73) 410.46 (98,435.27) UB 2170 08/22/2017 Penalties 8/2017 UB20170822-20170822 User: (9,960.14) (108,395.41) UB 2259 08/31/2017 Penalty removals UB20170831-20170831 User: 1,209.65 (107,185.76) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,340.03) (107,185.76) ** (119,260.00) Budgeted (12,074.24) Remaining 90 % Used Account: 135-47030-000-000 Service Charges 2096 08/08/2017 Cut Off List August 2017 UB20170808-20170808 User: (12,175.00) (1,150.00) (13,325.00) UB 2097 08/08/2017 Cut off List August 2017 UB20170808-20170808 User: (1,150.00) (14,475.00) UB 2098 08/08/2017 UB Disconnect Fee reversal UB20170808-20170808 User: 1,150.00 (13,325.00) UB 2247 08/09/2017 Returned ck-2424 Rosebury UB20170809-20170809 User: (25.00) (13,350.00) UB 2249 08/10/2017 UB NSF Checks UB20170810-20170810 User: (50.00) (13,400.00) UB 2251 08/11/2017 NSf Cehck UB20170811-20170811 User: 25.00 (13,375.00) UB 2253 08/17/2017 NSF Ck-3 meadowcreek UB20170817-20170817 User: (25.00) (13,400.00) UB 2256 08/21/2017 Rtd check-22 Ridgewood UB20170821-20170821 User: (25.00) (13,425.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,250.00) (13,425.00) ** (11,400.00) Budgeted 2,025.00 Remaining 118 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 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 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (1,500.00) (50.00) (1,550.00) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 2980 SH 114 (500.00) (2,050.00) OTD TC Compound CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (50.00) (2,100.00) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane 50.00 (2,050.00) Drees Homes CR 2178 08/21/2017 Permits 8/21/17 422 Abbot Lane (50.00) (2,100.00) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 408 Abbot Lane (50.00) (2,150.00) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 503 Fisher Drive (50.00) (2,200.00) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 502 Fisher Drive (50.00) (2,250.00) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 506 Asheville Lane (50.00) (2,300.00) Ashton Wood Homes CR 2226 08/28/2017 Permits 661 Sheldon Drive (50.00) (2,350.00) Ashton Wood homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (850.00) (2,350.00) ** (2,000.00) Budgeted 350.00 Remaining 118 % Used Account: 135-47045-000-000 Sewer Inspections 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (3,600.00) (150.00) (3,750.00) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (150.00) (3,900.00) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane 150.00 (3,750.00) Drees Homes CR 2178 08/21/2017 Permits 8/21/17 422 Abbot Lane (150.00) (3,900.00) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 408 Abbot Lane (150.00) (4,050.00) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 503 Fisher Drive (150.00) (4,200.00) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 502 Fisher Drive (150.00) (4,350.00) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 506 Asheville Lane (150.00) (4,500.00) Ashton Wood Homes CR 2226 08/28/2017 Permits 661 Sheldon Drive (150.00) (4,650.00) Ashton Wood homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,050.00) (4,650.00) ** (5,500.00) Budgeted (850.00) Remaining 85 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2232 08/31/2017 August billing UB20170831-20170831 User: (58,281.85) (13,708.00) (71,989.85) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (13,708.00) (71,989.85) ** (61,188.00) Budgeted 10,801.85 Remaining 118 % Used Account: 135-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (14,180.63) (400.08) (14,580.71) GL 2294 08/31/2017 Bank Interest/August (1,361.77) (15,942.48) GL 2294 08/31/2017 Bank Interest/August (151.52) (16,094.00) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49010-000-000 Interest Income Totals: (1,913.37) (16,094.00) ** (8,001.00) Budgeted 8,093.00 Remaining 201 % Used Account: 135-49016-000-000 Cell Tower Revenue 2205 08/22/2017 AT&T Cell Tower Revenue (9,105.30) (910.53) (10,015.83) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,015.83) ** (10,926.00) Budgeted (910.17) Remaining 92 % Used Account: 135-49018-000-000 Building Rent Income 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (295,408.00) Budgeted (295,408.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (18,206.02) (257.00) (18,463.02) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane (257.00) (18,720.02) Drees Homes CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 20 Katie Lane 257.00 (18,463.02) Drees Homes CR 2178 08/21/2017 Permits 8/21/17 422 Abbot Lane (343.00) (18,806.02) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 408 Abbot Lane (343.00) (19,149.02) Ashton Wood Homes CR 2178 08/21/2017 Permits 8/21/17 503 Fisher Drive (343.00) (19,492.02) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 502 Fisher Drive (343.00) (19,835.02) Ashton Wood Homes CR 2188 08/23/2017 Permits-8/23/17 506 Asheville Lane (343.00) (20,178.02) Ashton Wood Homes CR 2226 08/28/2017 Permits 661 Sheldon Drive (343.00) (20,521.02) Ashton Wood homes CR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,315.00) (20,521.02) ** (21,609.00) Budgeted (1,087.98) Remaining 95 % Used Account: 135-49900-000-000 Miscellaneous Income 2075 08/03/2017 Permits-OTD (2980 SH 114) 2980 SH 114 (11,389.29) (150.00) (11,539.29) OTD TC Compound CR 2252 08/16/2017 Meter testing fee adj-328 tens UB20170816-20170816 User: 150.00 (11,389.29) UB 2188 08/23/2017 Permits-8/23/17 506 Asheville Lane (800.00) (12,189.29) Ashton Wood Homes CR 2232 08/31/2017 August billing UB20170831-20170831 User: (148.21) (12,337.50) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (948.21) (12,337.50) ** (20,000.00) Budgeted (7,662.50) Remaining 62 % Used Account: 135-49901-000-000 Records Management Revenue (32.00) .00 (32.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Department Totals: ----------------------------------- (7,747,195.98) ** (946,412.17) Monthly Total (9,840,488.00) Budgeted (2,093,292.02) Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 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 2105 08/11/2017 MUD PR 08.11.17 Salaries & Wages 180,534.95 8,532.14 189,067.09 PR 2177 08/25/2017 MUD PR 08.25.17 Salaries & Wages 8,729.42 197,796.51 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,261.56 197,796.51 ** 271,143.00 Budgeted 73,346.49 Remaining 73 % Used Account: 135-50010-010-000 Overtime 2105 08/11/2017 MUD PR 08.11.17 Overtime 10,171.67 537.82 10,709.49 PR 2177 08/25/2017 MUD PR 08.25.17 Overtime 532.20 11,241.69 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,070.02 11,241.69 ** 19,500.00 Budgeted 8,258.31 Remaining 58 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 2177 08/25/2017 MUD PR 08.25.17 Certification 2,225.00 175.00 2,400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 2,400.00 ** 4,800.00 Budgeted 2,400.00 Remaining 50 % Used Account: 135-50020-010-000 Retirement 2105 08/11/2017 MUD PR 08.11.17 Retirement 17,827.99 838.98 18,666.97 PR 2177 08/25/2017 MUD PR 08.25.17 Retirement 872.88 19,539.85 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,711.86 19,539.85 ** 27,151.00 Budgeted 7,611.15 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 2105 08/11/2017 MUD PR 08.11.17 Medical Insurance 24,840.82 1,181.10 26,021.92 PR 2177 08/25/2017 MUD PR 08.25.17 Medical Insurance 1,181.11 27,203.03 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,362.21 27,203.03 ** 55,914.00 Budgeted 28,710.97 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 2105 08/11/2017 MUD PR 08.11.17 Dental Insurance 2,417.77 121.75 2,539.52 PR 2177 08/25/2017 MUD PR 08.25.17 Dental Insurance 121.71 2,661.23 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 243.46 2,661.23 ** 4,159.00 Budgeted 1,497.77 Remaining 64 % Used Account: 135-50028-010-000 Vision Insurance 2105 08/11/2017 MUD PR 08.11.17 Vision Insurance 470.72 24.63 495.35 PR 2177 08/25/2017 MUD PR 08.25.17 Vision Insurance 24.59 519.94 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 49.22 519.94 ** 910.00 Budgeted 390.06 Remaining 57 % Used Account: 135-50029-010-000 Life Insurance & Other 2057 08/03/2017 August A/P August dental, vision, life in 2,133.52 183.60 2,317.12 METLIFE GROUP BENEFITS 3377 AP 2172 08/22/2017 August A/P Admin Fee / Café 125 Plan 10.67 2,327.79 BenefitMall 3408 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 194.27 2,327.79 ** 2,803.00 Budgeted 475.21 Remaining 83 % Used Account: 135-50030-010-000 Social Security Taxes 2105 08/11/2017 MUD PR 08.11.17 Social Security Taxes 11,906.40 559.56 12,465.96 PR 2177 08/25/2017 MUD PR 08.25.17 Social Security Taxes 575.85 13,041.81 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,135.41 13,041.81 ** 19,021.00 Budgeted 5,979.19 Remaining 69 % Used Account: 135-50035-010-000 Medicare Taxes 2105 08/11/2017 MUD PR 08.11.17 Medicare Taxes 2,784.58 130.87 2,915.45 PR 2177 08/25/2017 MUD PR 08.25.17 Medicare Taxes 134.68 3,050.13 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 265.55 3,050.13 ** 4,448.00 Budgeted 1,397.87 Remaining 69 % Used Account: 135-50040-010-000 Unemployment Taxes 2105 08/11/2017 MUD PR 08.11.17 Unemployment Taxes 45.00 .42 45.42 PR 2177 08/25/2017 MUD PR 08.25.17 Unemployment Taxes 1.08 46.50 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.50 46.50 ** 1,026.00 Budgeted 979.50 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 470 08/01/2017 Insurance/Wrk Comp Exp Aug 9,715.60 1,074.16 10,789.76 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 10,789.76 ** 13,152.00 Budgeted 2,362.24 Remaining 82 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 2141 08/16/2017 August A/P New employee drug screen 270.90 76.00 346.90 CARENOW CORPORATE 3410 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 76.00 346.90 ** 1,300.00 Budgeted 953.10 Remaining 27 % Used Account: 135-50070-010-000 Employee Relations 187.09 .00 187.09 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 187.09 ** 300.00 Budgeted 112.91 Remaining 62 % Used Account: 135-55005-010-000 Engineering 2303 08/31/2017 Recode CPY to Due from SWIFT 38,005.44 (12,615.00) 25,390.44 GL 2285 08/31/2017 August A/P Tree Survey 16" waterline 3,371.72 28,762.16 Halff Associates, INC 3466 AP _______________ Account: 135-55005-010-000 Engineering Totals: (9,243.28) 28,762.16 ** 60,000.00 Budgeted 31,237.84 Remaining 48 % Used Account: 135-55080-010-000 Maintenance & Repairs 2141 08/16/2017 August A/P meter test 67,808.51 95.00 67,903.51 ATLAS UTILITY SUPPLY CO. 3407 AP 2141 08/16/2017 August A/P acetylene 110.19 68,013.70 ALLIED WELDING SUPPLY, INC 3406 AP 2168 08/21/2017 August A/P Tiger Blade, Rhino Extractor 545.00 68,558.70 ATLAS UTILITY SUPPLY CO. 3407 AP 2168 08/21/2017 August A/P Parts 915.09 69,473.79 HD SUPPLY WATERWORKS, LTD. 3418 AP 2172 08/22/2017 August A/P Meter Boxes / DFW Boxes and Li 3,170.82 72,644.61 HD SUPPLY WATERWORKS, LTD. 3418 AP 2172 08/22/2017 August A/P Belts / Nuts 81.00 72,725.61 HD SUPPLY WATERWORKS, LTD. 3418 AP 2207 08/29/2017 August A/P Oxygen cylinder 160.00 72,885.61 ALLIED WELDING SUPPLY, INC 3441 AP 2207 08/29/2017 August A/P couplings 257.64 73,143.25 HD SUPPLY WATERWORKS, LTD. 3444 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2297 08/31/2017 August A/P Boxes & Lids 67,808.51 1,000.58 74,143.83 Core & Main LP AP 2297 08/31/2017 August A/P Acetylene/Nitrogen semi annual 42.00 74,185.83 ALLIED WELDING SUPPLY, INC AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 104.70 74,290.53 THE HOME DEPOT #6581 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AMAZON MKTPLACE PMTS 215.86 74,506.39 AMAZON MKTPLACE PMTS PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 33.13 74,539.52 THE HOME DEPOT #6581 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FERGUSON ENT 1241 45.69 74,585.21 FERGUSON ENT 1241 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 23.94 74,609.15 THE HOME DEPOT #6581 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FERGUSON ENT 1241 126.13 74,735.28 FERGUSON ENT 1241 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ROANOKE WINNELSON CO 7.91 74,743.19 ROANOKE WINNELSON CO PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 LOWES #00732* 3.98 74,747.17 LOWES #00732* PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FASTENAL COMPANY01 22.04 74,769.21 FASTENAL COMPANY01 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FASTENAL COMPANY01 23.86 74,793.07 FASTENAL COMPANY01 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FASTENAL COMPANY01 (23.86) 74,769.21 FASTENAL COMPANY01 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 TEX-TURF 30.60 74,799.81 TEX-TURF PC 2285 08/31/2017 August A/P Bolts 134.00 74,933.81 HD SUPPLY WATERWORKS, LTD. 3467 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 7,125.30 74,933.81 ** 128,500.00 Budgeted 53,566.19 Remaining 58 % Used Account: 135-55085-010-000 Generator Maint. and Repair 2,459.00 .00 2,459.00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 2,459.00 ** 3,000.00 Budgeted 541.00 Remaining 82 % Used Account: 135-55090-010-000 Vehicle Maintenance 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 CARMEL CARWASH - ROANO 2,057.80 44.95 2,102.75 CARMEL CARWASH - ROANO PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 44.95 2,102.75 ** 8,000.00 Budgeted 5,897.25 Remaining 26 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 2297 08/31/2017 August A/P Water Samples/MUD 3,548.26 200.00 3,748.26 TARRANT CTY PUBLIC HEALTH LAB AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 3,748.26 ** 5,500.00 Budgeted 1,751.74 Remaining 68 % Used Account: 135-60010-010-000 Communications/Mobiles 2168 08/21/2017 August A/P Cell Phones 3,160.08 301.38 3,461.46 VERIZON WIRELESS 3437 AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AMAZON.COM 62.34 3,523.80 AMAZON.COM PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 363.72 3,523.80 ** 5,400.00 Budgeted 1,876.20 Remaining 65 % Used Account: 135-60020-010-000 Electricity 2168 08/21/2017 August A/P Electricity 123,206.19 163.00 123,369.19 HUDSON ENERGY SERVICES, LLC 3419 AP 2172 08/22/2017 August A/P Electricity 15,438.49 138,807.68 HUDSON ENERGY SERVICES, LLC 3419 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,601.49 138,807.68 ** 172,737.00 Budgeted 33,929.32 Remaining 80 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 ** 750.00 Budgeted (17.00) Remaining 102 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 825.00 .00 825.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 825.00 ** 4,222.00 Budgeted 3,397.00 Remaining 20 % Used Account: 135-60090-010-000 Safety Program . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 2168 08/21/2017 August A/P Well Water Fee 21,940.45 3,037.90 24,978.35 North Texas Groundwater 3429 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,037.90 24,978.35 ** 50,176.00 Budgeted 25,197.65 Remaining 50 % Used Account: 135-60150-010-000 Wholesale Water 2285 08/31/2017 August A/P Wholesale Water 1,472,363.50 264,173.29 1,736,536.79 CITY OF FORT WORTH 3459 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 264,173.29 1,736,536.79 ** 2,998,802.00 Budgeted 1,262,265.21 Remaining 58 % Used Account: 135-60245-010-000 Miscellaneous Expenses 102.70 .00 102.70 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 102.70 ** 200.00 Budgeted 97.30 Remaining 51 % Used Account: 135-60280-010-000 Property Maintenance 666.60 .00 666.60 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 666.60 ** 5,000.00 Budgeted 4,333.40 Remaining 13 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2285 08/31/2017 August A/P August Mowing 5,250.00 750.00 6,000.00 WATTS ELLISON LLC 3484 AP 2292 08/31/2017 August A/P July mowing 750.00 6,750.00 WATTS ELLISON LLC 3485 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 6,750.00 ** 14,750.00 Budgeted 8,000.00 Remaining 46 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 2173 08/22/2017 Texpool Transfers 218,928.77 21,892.88 240,821.65 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 240,821.65 ** 297,011.00 Budgeted 56,189.35 Remaining 81 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 2173 08/22/2017 Texpool Transfers 39,881.45 4,083.00 43,964.45 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 43,964.45 ** 64,920.00 Budgeted 20,955.55 Remaining 68 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 2197 08/25/2017 August A/P Fuel 7/25-8/24/17 6,966.24 727.28 7,693.52 US Bank Voyager Fleet Systems 3454 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 727.28 7,693.52 ** 24,828.00 Budgeted 17,134.48 Remaining 31 % Used Account: 135-65010-010-000 Uniforms 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AMAZON.COM 2,783.93 139.93 2,923.86 AMAZON.COM PC _______________ Account: 135-65010-010-000 Uniforms Totals: 139.93 2,923.86 ** 4,608.00 Budgeted 1,684.14 Remaining 63 % Used Account: 135-65030-010-000 Chemicals 2168 08/21/2017 August A/P Profile Heads 12,172.71 9,504.00 21,676.71 ATLAS UTILITY SUPPLY CO. 3407 AP 2168 08/21/2017 August A/P STD Kit 202.89 21,879.60 HACH COMPANY 3417 AP 2285 08/31/2017 August A/P Chlorine 953.47 22,833.07 DPC INDUSTRIES, INC 3461 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 10,660.36 22,833.07 ** 20,000.00 Budgeted (2,833.07) Remaining 114 % Used Account: 135-65035-010-000 Small Tools 867.64 .00 867.64 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 867.64 ** 1,200.00 Budgeted 332.36 Remaining 72 % Used Account: 135-65040-010-000 Safety Equipment 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 TX AMERICA SAFETY 506.50 506.50 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 506.50 506.50 ** 1,000.00 Budgeted 493.50 Remaining 51 % Used Account: 135-65050-010-000 Meter Expense 2075 08/03/2017 Permits-OTD (2980 SH 114) 2980 SH 114 23,999.88 (5,815.81) 18,184.07 OTD TC Compound CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 2980 SH 114 (2,817.46) 15,366.61 OTD TC Compound CR 2075 08/03/2017 Permits-OTD (2980 SH 114) 2980 SH 114 (853.56) 14,513.05 OTD TC Compound CR 2168 08/21/2017 August A/P HG Sply 9,486.83 23,999.88 ATLAS UTILITY SUPPLY CO. 3407 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 23,999.88 ** 31,500.00 Budgeted 7,500.12 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65053-010-000 Meter Change Out Program 71,160.00 .00 71,160.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 71,160.00 ** 81,500.00 Budgeted 10,340.00 Remaining 87 % Used Account: 135-69005-010-000 Capital Outlays 2325 08/31/2017 Recode Bollards/Water to Adm 352,962.82 (9,875.00) 343,087.82 GL _______________ Account: 135-69005-010-000 Capital Outlays Totals: (9,875.00) 343,087.82 ** 690,422.00 Budgeted 347,334.18 Remaining 50 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 2297 08/31/2017 August A/P Water Samples/PID 1,423.10 80.00 1,503.10 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,503.10 ** 5,000.00 Budgeted 3,496.90 Remaining 30 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 3,280,829.83 ** 336,638.54 Monthly Total 5,524,781.00 Budgeted 2,243,951.17 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 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 2105 08/11/2017 MUD PR 08.11.17 Salaries & Wages 312,473.59 14,989.04 327,462.63 PR 2177 08/25/2017 MUD PR 08.25.17 Salaries & Wages 14,989.04 342,451.67 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 29,978.08 342,451.67 ** 391,102.00 Budgeted 48,650.33 Remaining 88 % Used Account: 135-50010-020-000 Overtime 2105 08/11/2017 MUD PR 08.11.17 Overtime 26,878.82 763.01 27,641.83 PR 2177 08/25/2017 MUD PR 08.25.17 Overtime 916.80 28,558.63 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,679.81 28,558.63 ** 29,500.00 Budgeted 941.37 Remaining 97 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 2177 08/25/2017 MUD PR 08.25.17 Certification 6,875.00 700.00 7,575.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 7,575.00 ** 7,800.00 Budgeted 225.00 Remaining 97 % Used Account: 135-50020-020-000 Retirement 2105 08/11/2017 MUD PR 08.11.17 Retirement 32,089.41 1,457.07 33,546.48 PR 2177 08/25/2017 MUD PR 08.25.17 Retirement 1,536.05 35,082.53 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,993.12 35,082.53 ** 39,584.00 Budgeted 4,501.47 Remaining 89 % Used Account: 135-50026-020-000 Medical Insurance 2105 08/11/2017 MUD PR 08.11.17 Medical Insurance 45,715.11 2,355.10 48,070.21 PR 2177 08/25/2017 MUD PR 08.25.17 Medical Insurance 2,355.10 50,425.31 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 50,425.31 ** 73,022.00 Budgeted 22,596.69 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 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 2105 08/11/2017 MUD PR 08.11.17 Dental Insurance 3,665.68 199.69 3,865.37 PR 2177 08/25/2017 MUD PR 08.25.17 Dental Insurance 199.63 4,065.00 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 4,065.00 ** 4,592.00 Budgeted 527.00 Remaining 89 % Used Account: 135-50028-020-000 Vision Insurance 2105 08/11/2017 MUD PR 08.11.17 Vision Insurance 785.58 42.19 827.77 PR 2177 08/25/2017 MUD PR 08.25.17 Vision Insurance 42.14 869.91 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 869.91 ** 1,031.00 Budgeted 161.09 Remaining 84 % Used Account: 135-50029-020-000 Life Insurance & Other 2057 08/03/2017 August A/P August dental, vision, life in 3,766.08 361.15 4,127.23 METLIFE GROUP BENEFITS 3377 AP 2172 08/22/2017 August A/P Admin Fee / Café 125 Plan 31.99 4,159.22 BenefitMall 3408 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 393.14 4,159.22 ** 4,485.00 Budgeted 325.78 Remaining 93 % Used Account: 135-50030-020-000 Social Security Taxes 2105 08/11/2017 MUD PR 08.11.17 Social Security Taxes 20,573.20 919.29 21,492.49 PR 2177 08/25/2017 MUD PR 08.25.17 Social Security Taxes 953.67 22,446.16 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,872.96 22,446.16 ** 27,886.00 Budgeted 5,439.84 Remaining 80 % Used Account: 135-50035-020-000 Medicare Taxes 2105 08/11/2017 MUD PR 08.11.17 Medicare Taxes 4,811.47 214.99 5,026.46 PR 2177 08/25/2017 MUD PR 08.25.17 Medicare Taxes 223.04 5,249.50 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 438.03 5,249.50 ** 6,522.00 Budgeted 1,272.50 Remaining 80 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 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 63.00 ** 1,197.00 Budgeted 1,134.00 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 470 08/01/2017 Insurance/Wrk Comp Exp Aug 13,049.50 926.75 13,976.25 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 13,976.25 ** 11,347.00 Budgeted (2,629.25) Remaining 123 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 80.00 .00 80.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 80.00 ** 300.00 Budgeted 220.00 Remaining 27 % Used Account: 135-50070-020-000 Employee Relations 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 MR JIMS PIZZA - ROANOK 391.62 63.96 455.58 MR JIMS PIZZA - ROANOK PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RANDALLS STORE00017897 5.42 461.00 RANDALLS STORE00017897 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 69.38 461.00 ** 650.00 Budgeted 189.00 Remaining 71 % Used Account: 135-55005-020-000 Engineering 852.48 .00 852.48 _______________ Account: 135-55005-020-000 Engineering Totals: .00 852.48 ** 70,000.00 Budgeted 69,147.52 Remaining 1 % Used Account: 135-55070-020-000 Independent Labor 19,449.39 .00 19,449.39 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 19,449.39 ** 20,000.00 Budgeted 550.61 Remaining 97 % Used Account: 135-55080-020-000 Maintenance & Repairs 2181 08/23/2017 August A/P WWTP gate repair 91,168.26 910.00 92,078.26 Alan's Gates, Inc. 3405 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2300 08/31/2017 August A/P Longo Pack bags, replacement r 91,168.26 1,081.50 93,159.76 Huber Technology Inc AP 2300 08/31/2017 August A/P Repair WWTP non-portable pumps 3,693.00 96,852.76 SMITH PUMP COMPANY, INC. AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 69.39 96,922.15 THE HOME DEPOT #6581 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 FUSECO DALLAS 67.30 96,989.45 FUSECO DALLAS PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,821.19 96,989.45 ** 79,700.00 Budgeted (17,289.45) Remaining 122 % Used Account: 135-55085-020-000 Generator Maint. and Repair 6,076.00 .00 6,076.00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 6,076.00 ** 20,000.00 Budgeted 13,924.00 Remaining 30 % Used Account: 135-55090-020-000 Vehicle Maintenance 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 MUSTANG ELITE CAR 7,600.42 36.00 7,636.42 MUSTANG ELITE CAR PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 MUSTANG ELITE CAR 36.00 7,672.42 MUSTANG ELITE CAR PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 MUSTANG ELITE CAR 109.99 7,782.41 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 181.99 7,782.41 ** 6,600.00 Budgeted (1,182.41) Remaining 118 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 23.94 .00 23.94 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 2181 08/23/2017 August A/P Sludge haul off 47,391.09 845.00 48,236.09 L.H. CHANEY MATERIALS, INC. 3422 AP 2300 08/31/2017 August A/P Sludge Haul off 1,708.59 49,944.68 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,553.59 49,944.68 ** 55,000.00 Budgeted 5,055.32 Remaining 91 % Used Account: 135-55135-020-000 Lab Analysis 2112 08/09/2017 August A/P Testing 26,778.56 246.00 27,024.56 OXIDOR LABORATORIES LLC 3401 AP 2112 08/09/2017 August A/P Testing 176.00 27,200.56 OXIDOR LABORATORIES LLC 3401 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2181 08/23/2017 August A/P chemicals 26,778.56 246.00 27,446.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P Lab supplies 176.00 27,622.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P chemicals 246.00 27,868.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P chemicals 176.00 28,044.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P chemicals 201.00 28,245.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P checmicals 201.00 28,446.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P checmicals 240.00 28,686.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P Checmicals 113.00 28,799.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P Lab supplies 246.00 29,045.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P chemicals 176.00 29,221.56 OXIDOR LABORATORIES LLC 3432 AP 2181 08/23/2017 August A/P chemicals 113.00 29,334.56 OXIDOR LABORATORIES LLC 3432 AP 2300 08/31/2017 August A/P Testing 246.00 29,580.56 OXIDOR LABORATORIES LLC AP 2300 08/31/2017 August A/P Testing 176.00 29,756.56 OXIDOR LABORATORIES LLC AP 2300 08/31/2017 August A/P Testing 201.00 29,957.56 OXIDOR LABORATORIES LLC AP 2300 08/31/2017 August A/P Bio Monitoring 1,080.00 31,037.56 HUTHER AND ASSOCIATES,INC AP 2232 08/31/2017 August billing UB20170831-20170831 User: (772.50) 30,265.06 UB _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,486.50 30,265.06 ** 25,000.00 Budgeted (5,265.06) Remaining 121 % Used Account: 135-60010-020-000 Communications/Mobiles 2168 08/21/2017 August A/P Cell Phones 4,080.09 629.45 4,709.54 VERIZON WIRELESS 3437 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 629.45 4,709.54 ** 5,400.00 Budgeted 690.46 Remaining 87 % Used Account: 135-60020-020-000 Electricity 2168 08/21/2017 August A/P Electricity 117,227.45 30.17 117,257.62 HUDSON ENERGY SERVICES, LLC 3419 AP 2168 08/21/2017 August A/P Electricity 96.84 117,354.46 HUDSON ENERGY SERVICES, LLC 3419 AP 2168 08/21/2017 August A/P WWTP 07/12/2017 - 08/09/2017 4,158.84 121,513.30 ENGIE Resources LLC 3413 AP 2172 08/22/2017 August A/P Electricity 322.92 121,836.22 MP2 ENERGY TEXAS LLC 3427 AP 2172 08/22/2017 August A/P Electricity 406.02 122,242.24 HUDSON ENERGY SERVICES, LLC 3419 AP 2172 08/22/2017 August A/P Electricity 7,998.29 130,240.53 HUDSON ENERGY SERVICES, LLC 3419 AP 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: (191.32) 130,049.21 AR _______________ Account: 135-60020-020-000 Electricity Totals: 12,821.76 130,049.21 ** 158,627.00 Budgeted 28,577.79 Remaining 82 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 143.85 .00 143.85 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 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-020-000 Publications/Books/Subscripts Totals: .00 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used Account: 135-60070-020-000 Dues & Memberships 267.00 .00 267.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 267.00 ** 267.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-020-000 Schools & Training 2,357.81 .00 2,357.81 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 2,357.81 ** 4,195.00 Budgeted 1,837.19 Remaining 56 % Used Account: 135-60090-020-000 Safety Program 291.12 .00 291.12 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 291.12 ** 550.00 Budgeted 258.88 Remaining 53 % Used Account: 135-60100-020-000 Travel & per diem 2172 08/22/2017 August A/P Tolls / Labs 2,378.30 42.36 2,420.66 NTTA 3430 AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 HOFFBRAU STEAKS 31.04 2,451.70 HOFFBRAU STEAKS PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RAILHEAD SMOKEHOUSE 18.78 2,470.48 RAILHEAD SMOKEHOUSE PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RAILHEAD SMOKEHOUSE 15.70 2,486.18 RAILHEAD SMOKEHOUSE PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 107.88 2,486.18 ** 2,400.00 Budgeted (86.18) Remaining 104 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 18,348.38 .00 18,348.38 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 18,348.38 ** 17,150.00 Budgeted (1,198.38) Remaining 107 % Used Account: 135-60245-020-000 Miscellaneous Expenses 113.27 .00 113.27 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 113.27 ** 450.00 Budgeted 336.73 Remaining 25 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 6,621.00 Budgeted 6,621.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2285 08/31/2017 August A/P August Mowing 4,130.00 590.00 4,720.00 WATTS ELLISON LLC 3484 AP 2292 08/31/2017 August A/P July mowing 590.00 5,310.00 WATTS ELLISON LLC 3485 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 5,310.00 ** 11,600.00 Budgeted 6,290.00 Remaining 46 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 2189 08/23/2017 Texpool Transfers 109,538.20 10,953.80 120,492.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.80 120,492.00 ** 120,492.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2189 08/23/2017 Texpool Transfers 541,489.10 54,148.90 595,638.00 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.90 595,638.00 ** 595,638.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 2173 08/22/2017 Texpool Transfers 159,861.25 10,278.00 170,139.25 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 170,139.25 ** 123,492.00 Budgeted (46,647.25) Remaining 138 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 2197 08/25/2017 August A/P Fuel 7/25-8/24/17 6,985.24 829.00 7,814.24 US Bank Voyager Fleet Systems 3454 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 829.00 7,814.24 ** 28,088.00 Budgeted 20,273.76 Remaining 28 % Used Account: 135-65010-020-000 Uniforms 3,753.87 .00 3,753.87 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 3,753.87 ** 4,459.00 Budgeted 705.13 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 23,247.95 .00 23,247.95 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 23,247.95 ** 21,000.00 Budgeted (2,247.95) Remaining 111 % Used Account: 135-65035-020-000 Small Tools 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 1,470.72 95.88 1,566.60 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 1,470.72 90.78 1,657.38 THE HOME DEPOT #6581 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 THE HOME DEPOT #6581 24.98 1,682.36 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 211.64 1,682.36 ** 2,000.00 Budgeted 317.64 Remaining 84 % Used Account: 135-65040-020-000 Safety Equipment 517.03 .00 517.03 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 517.03 ** 750.00 Budgeted 232.97 Remaining 69 % Used Account: 135-65045-020-000 Lab Supplies 2181 08/23/2017 August A/P lab supplies 12,806.95 83.64 12,890.59 HACH COMPANY 3417 AP 2181 08/23/2017 August A/P lab supplies 205.00 13,095.59 HACH COMPANY 3417 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 288.64 13,095.59 ** 14,000.00 Budgeted 904.41 Remaining 94 % Used Account: 135-69005-020-000 Capital Outlays 200,903.11 .00 200,903.11 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 200,903.11 ** 462,000.00 Budgeted 261,096.89 Remaining 43 % Used Department 20 Totals: ----------------------------------- 2,038,927.72 ** 147,737.46 Monthly Total 2,671,032.00 Budgeted 632,104.28 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2017 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-026-000 Workman's Compensation 470 08/01/2017 Insurance/Wrk Comp Exp Aug 25.10 2.61 27.71 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 27.71 ** 32.00 Budgeted 4.29 Remaining 87 % 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 .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 145.45 .00 145.45 _______________ Account: 135-60075-026-000 Meetings Totals: .00 145.45 ** 1,200.00 Budgeted 1,054.55 Remaining 12 % Used Account: 135-60080-026-000 Schools & Training 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 NCTCOG RTC TRAINING 3,287.35 135.00 3,422.35 NCTCOG RTC TRAINING PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 NCTCOG RTC TRAINING 135.00 3,557.35 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 270.00 3,557.35 ** 4,000.00 Budgeted 442.65 Remaining 89 % Used Account: 135-60100-026-000 Travel & per diem 2,446.95 .00 2,446.95 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 2,446.95 ** 5,000.00 Budgeted 2,553.05 Remaining 49 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 6,177.46 ** 272.61 Monthly Total 12,882.00 Budgeted 6,704.54 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 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 2105 08/11/2017 MUD PR 08.11.17 Salaries & Wages 351,707.51 14,527.48 366,234.99 PR 2177 08/25/2017 MUD PR 08.25.17 Salaries & Wages 15,089.39 381,324.38 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 29,616.87 381,324.38 ** 519,883.00 Budgeted 138,558.62 Remaining 73 % Used Account: 135-50010-030-000 Overtime 2105 08/11/2017 MUD PR 08.11.17 Overtime 3,336.57 42.01 3,378.58 PR 2177 08/25/2017 MUD PR 08.25.17 Overtime 31.54 3,410.12 PR _______________ Account: 135-50010-030-000 Overtime Totals: 73.55 3,410.12 ** 2,500.00 Budgeted (910.12) Remaining 136 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,417.00 Budgeted (.50) Remaining 100 % Used Account: 135-50020-030-000 Retirement 2105 08/11/2017 MUD PR 08.11.17 Retirement 32,461.53 1,347.68 33,809.21 PR 2177 08/25/2017 MUD PR 08.25.17 Retirement 1,398.69 35,207.90 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,746.37 35,207.90 ** 47,768.00 Budgeted 12,560.10 Remaining 74 % Used Account: 135-50026-030-000 Medical Insurance 2105 08/11/2017 MUD PR 08.11.17 Medical Insurance 37,977.27 1,674.80 39,652.07 PR 2177 08/25/2017 MUD PR 08.25.17 Medical Insurance 1,674.81 41,326.88 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,349.61 41,326.88 ** 84,289.00 Budgeted 42,962.12 Remaining 49 % Used Account: 135-50027-030-000 Dental Insurance 2105 08/11/2017 MUD PR 08.11.17 Dental Insurance 3,352.30 155.71 3,508.01 PR 2177 08/25/2017 MUD PR 08.25.17 Dental Insurance 155.66 3,663.67 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 311.37 3,663.67 ** 5,981.00 Budgeted 2,317.33 Remaining 61 % Used Account: 135-50028-030-000 Vision Insurance 2105 08/11/2017 MUD PR 08.11.17 Vision Insurance 717.75 33.41 751.16 PR 2177 08/25/2017 MUD PR 08.25.17 Vision Insurance 33.36 784.52 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 66.77 784.52 ** 1,312.00 Budgeted 527.48 Remaining 60 % Used Account: 135-50029-030-000 Life Insurance & Other 2057 08/03/2017 August A/P August dental, vision, life in 3,786.21 290.16 4,076.37 METLIFE GROUP BENEFITS 3377 AP 2172 08/22/2017 August A/P Admin Fee / Café 125 Plan 21.34 4,097.71 BenefitMall 3408 AP 2204 08/28/2017 Clear Ins Liab as of 8/2017 50.04 4,147.75 GL 2297 08/31/2017 August A/P Rounding adjustment (.02) 4,147.73 Legal Shield AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 361.52 4,147.73 ** 5,890.00 Budgeted 1,742.27 Remaining 70 % Used Account: 135-50030-030-000 Social Security Taxes 2105 08/11/2017 MUD PR 08.11.17 Social Security Taxes 21,157.17 866.12 22,023.29 PR 2177 08/25/2017 MUD PR 08.25.17 Social Security Taxes 887.97 22,911.26 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,754.09 22,911.26 ** 32,777.00 Budgeted 9,865.74 Remaining 70 % Used Account: 135-50035-030-000 Medicare Taxes 2105 08/11/2017 MUD PR 08.11.17 Medicare Taxes 4,948.03 202.56 5,150.59 PR 2177 08/25/2017 MUD PR 08.25.17 Medicare Taxes 207.68 5,358.27 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 410.24 5,358.27 ** 8,084.00 Budgeted 2,725.73 Remaining 66 % Used Account: 135-50040-030-000 Unemployment Taxes 293.73 .00 293.73 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 293.73 ** 1,368.00 Budgeted 1,074.27 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 470 08/01/2017 Insurance/Wrk Comp Exp Aug 1,505.30 145.53 1,650.83 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,650.83 ** 1,784.00 Budgeted 133.17 Remaining 93 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 2141 08/16/2017 August A/P New employee drug screen 568.80 38.00 606.80 CARENOW CORPORATE 3410 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 38.00 606.80 ** 500.00 Budgeted (106.80) Remaining 121 % Used Account: 135-50070-030-000 Employee Relations 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 DONUT HAVEN 2,605.40 23.95 2,629.35 DONUT HAVEN PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RANDALLS STORE00017897 10.99 2,640.34 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 34.94 2,640.34 ** 4,960.00 Budgeted 2,319.66 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 2168 08/21/2017 August A/P Server Migration / Billing Sup 82,385.42 3,024.00 85,409.42 STW INC 3434 AP 2168 08/21/2017 August A/P Internet August 1,036.77 86,446.19 WHOLESALE CARRIER SERVICES INC 3439 AP 2168 08/21/2017 August A/P Email License 168.00 86,614.19 M3 Networks 3423 AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 63.49 86,677.68 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 85.56 86,763.24 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ATT*BILL PAYMENT 102.08 86,865.32 ATT*BILL PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 84.85 86,950.17 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 63.49 87,013.66 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ATT*BILL PAYMENT 156.67 87,170.33 ATT*BILL PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 DNH*GODADDY.COM 15.17 87,185.50 DNH*GODADDY.COM PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ADOBE *IL CREATIVE CLD 19.99 87,205.49 ADOBE *IL CREATIVE CLD PC _______________ Account: 135-55030-030-000 Software & Support Totals: 4,820.07 87,205.49 ** 77,791.00 Budgeted (9,414.49) Remaining 112 % Used Account: 135-55070-030-000 Independent Labor 2172 08/22/2017 August A/P Reception Temp Admin 1,270.00 136.48 1,406.48 Onin Staffing, LLC 3431 AP 2207 08/29/2017 August A/P Temp Receptionist 672.83 2,079.31 Onin Staffing, LLC 3452 AP 2263 08/31/2017 August A/P Sept Hours- 196 14,700.00 16,779.31 Carman Consulting LLC. 3455 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2273 08/31/2017 August A/P Krystle Reception Temp- Hours 1,270.00 676.11 17,455.42 Onin Staffing, LLC 3478 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 16,185.42 17,455.42 ** 4,000.00 Budgeted (13,455.42) Remaining 436 % Used Account: 135-55080-030-000 Maintenance & Repairs 826.00 .00 826.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 826.00 ** 2,000.00 Budgeted 1,174.00 Remaining 41 % Used Account: 135-55085-030-000 Generator Maint. and Repair 485.00 .00 485.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 2057 08/03/2017 August A/P Electricity 5/10-6/9/17 6,500.78 87.50 6,588.28 TOWN OF TROPHY CLUB 3389 AP 2168 08/21/2017 August A/P Rug Services August 66.47 6,654.75 G & K SERVICES 3416 AP 2172 08/22/2017 August A/P Server Room A/C 230.00 6,884.75 BRANDON R REED 3409 AP 2215 08/30/2017 August A/P Rug Service MUD/PS Bldg 66.47 6,951.22 G & K SERVICES 3443 AP 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: (181.47) 6,769.75 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 268.97 6,769.75 ** 7,000.00 Budgeted 230.25 Remaining 97 % Used Account: 135-55120-030-000 Cleaning Services 2168 08/21/2017 August A/P Janitorial Services July 5,438.54 869.06 6,307.60 MEMBER'S BUILDING MAINTENANCE 3425 AP 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: (236.00) 6,071.60 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 6,071.60 ** 8,000.00 Budgeted 1,928.40 Remaining 76 % Used Account: 135-55160-030-000 Professional Outside Services 2172 08/22/2017 August A/P Rate Analysis 57,332.00 4,085.64 61,417.64 NEW GEN STRATEGIES & SOLUTIONS 3428 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 4,085.64 61,417.64 ** 60,000.00 Budgeted (1,417.64) Remaining 102 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55165-030-000 Collection Fees .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 2297 08/31/2017 August A/P August Utility Billing 6,287.58 590.31 6,877.89 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 590.31 6,877.89 ** 8,200.00 Budgeted 1,322.11 Remaining 84 % Used Account: 135-60005-030-000 Telephone 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: 10,985.64 (913.18) 10,072.46 AR 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ATT*BUS PHONE PMT 852.51 10,924.97 ATT*BUS PHONE PMT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 185.85 11,110.82 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ATT*BUS PHONE PMT 456.77 11,567.59 ATT*BUS PHONE PMT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RINGCENTRAL, INC 12.99 11,580.58 RINGCENTRAL, INC PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AT&T *PAYMENT 185.22 11,765.80 AT&T *PAYMENT PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 ATT*BUS PHONE PMT 850.16 12,615.96 ATT*BUS PHONE PMT PC 2287 08/31/2017 August A/P 200.00 12,815.96 KEYSTONE PARK SECRETARIAL 3470 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,830.32 12,815.96 ** 17,532.00 Budgeted 4,716.04 Remaining 73 % Used Account: 135-60010-030-000 Communications/Mobiles 2168 08/21/2017 August A/P Cell Phones 2,741.91 37.99 2,779.90 VERIZON WIRELESS 3437 AP 2177 08/25/2017 MUD PR 08.25.17 Communications/Mobiles 225.00 3,004.90 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 262.99 3,004.90 ** 3,500.00 Budgeted 495.10 Remaining 86 % Used Account: 135-60020-030-000 Electricity/Gas 2057 08/03/2017 August A/P Electricity 5/10-6/9/17 7,189.04 833.71 8,022.75 TOWN OF TROPHY CLUB 3389 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 833.71 8,022.75 ** 12,631.00 Budgeted 4,608.25 Remaining 64 % Used Account: 135-60025-030-000 Water . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2296 08/31/2017 Town Billed Invoice 1585-1592 AR 20170831-20170831 User: 909.42 (70.08) 839.34 AR 2297 08/31/2017 August A/P August Water 140.17 979.51 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 135-60025-030-000 Water Totals: 70.09 979.51 ** 1,500.00 Budgeted 520.49 Remaining 65 % Used Account: 135-60035-030-000 Postage 2116 08/10/2017 August A/P Overnight letters 24,041.99 51.50 24,093.49 FEDERAL EXPRESS CORP 3396 AP 2172 08/22/2017 August A/P Postage 23.29 24,116.78 FEDERAL EXPRESS CORP 3415 AP 2297 08/31/2017 August A/P August Utility Billing 1,557.25 25,674.03 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 1,632.04 25,674.03 ** 28,932.00 Budgeted 3,257.97 Remaining 89 % Used Account: 135-60040-030-000 Service Charges & Fees 2225 08/03/2017 Credit card fees 42,444.56 4,927.71 47,372.27 GL 2225 08/03/2017 Credit card fees 150.49 47,522.76 GL 2069 08/04/2017 TWC 2nd Qtr 15.09 47,537.85 GL 2106 08/11/2017 Child Support Fee 1.50 47,539.35 GL 2179 08/25/2017 Child Support Fee 1.50 47,540.85 GL 2285 08/31/2017 August A/P Direct Send Fees 50.00 47,590.85 Fiserv Solutions, LLC 3463 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,146.29 47,590.85 ** 55,560.00 Budgeted 7,969.15 Remaining 86 % Used Account: 135-60050-030-000 Bad Debt Expense 526.88 .00 526.88 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 526.88 ** 3,500.00 Budgeted 2,973.12 Remaining 15 % Used Account: 135-60055-030-000 Insurance 470 08/01/2017 Insurance/Wrk Comp Exp Aug 46,537.80 4,664.56 51,202.36 GL 2172 08/22/2017 August A/P Director Bonds 200.00 51,402.36 VICTOR O SCHINNERER & CO, INC 3438 AP 2289 08/31/2017 August A/P Real & Personal Property Adj 3,547.60 54,949.96 TML INTERGOVERNMENTAL RISK 3481 AP _______________ Account: 135-60055-030-000 Insurance Totals: 8,412.16 54,949.96 ** 55,692.00 Budgeted 742.04 Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-030-000 Publications/Books/Subscripts 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AWWA.ORG 331.88 437.63 769.51 AWWA.ORG PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 437.63 769.51 ** 1,600.00 Budgeted 830.49 Remaining 48 % Used Account: 135-60070-030-000 Dues & Memberships 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMS CLUB #4795 4,661.25 90.00 4,751.25 SAMS CLUB #4795 PC 2285 08/31/2017 August A/P State of TX CO-OP Annual Membe 100.00 4,851.25 TX COMPTROLLER 3483 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 190.00 4,851.25 ** 6,000.00 Budgeted 1,148.75 Remaining 81 % Used Account: 135-60075-030-000 Meetings 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 RANDALLS STORE00017897 105.71 15.98 121.69 RANDALLS STORE00017897 PC _______________ Account: 135-60075-030-000 Meetings Totals: 15.98 121.69 ** 400.00 Budgeted 278.31 Remaining 30 % Used Account: 135-60079-030-000 Public Education 4,972.32 .00 4,972.32 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,972.32 ** 8,754.00 Budgeted 3,781.68 Remaining 57 % Used Account: 135-60080-030-000 Schools & Training 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 NCTCOG RTC TRAINING 1,835.00 270.00 2,105.00 NCTCOG RTC TRAINING PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 YOURMEMBER-CAREERS 150.00 2,255.00 YOURMEMBER-CAREERS PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 420.00 2,255.00 ** 7,840.00 Budgeted 5,585.00 Remaining 29 % Used Account: 135-60100-030-000 Travel & per diem 2105 08/11/2017 MUD PR 08.11.17 Travel & per diem 7,011.33 64.15 7,075.48 PR 2177 08/25/2017 MUD PR 08.25.17 Travel & per diem 18.14 7,093.62 PR 2263 08/31/2017 August A/P Sept Miles 18.19 7,111.81 Carman Consulting LLC. 3455 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 100.48 7,111.81 ** 7,500.00 Budgeted 388.19 Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 LANGUAGE USA 2,925.33 45.00 2,970.33 LANGUAGE USA PC _______________ Account: 135-60115-030-000 Elections Totals: 45.00 2,970.33 ** 7,500.00 Budgeted 4,529.67 Remaining 40 % Used Account: 135-60125-030-000 Advertising 1,698.09 .00 1,698.09 _______________ Account: 135-60125-030-000 Advertising Totals: .00 1,698.09 ** 7,500.00 Budgeted 5,801.91 Remaining 23 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 160.96 .00 160.96 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 160.96 ** 17,500.00 Budgeted 17,339.04 Remaining 1 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,055.94 .00 1,055.94 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,055.94 ** 2,500.00 Budgeted 1,444.06 Remaining 42 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 855.00 Budgeted 712.64 Remaining 17 % Used Account: 135-65055-030-000 Hardware 2,300.20 .00 2,300.20 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,300.20 ** 9,444.00 Budgeted 7,143.80 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 2197 08/25/2017 August A/P Office Supplies 4,859.21 80.96 4,940.17 OFFICE DEPOT, INC 3450 AP 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 KELLER TROPHY AND AWAR 20.00 4,960.17 KELLER TROPHY AND AWAR PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 STAPLES 00116533 60.59 5,020.76 STAPLES 00116533 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 WM SUPERCENTER #5247 49.10 5,069.86 WM SUPERCENTER #5247 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 STAPLES DIRECT 54.93 5,124.79 STAPLES DIRECT PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 265.58 5,124.79 ** 9,000.00 Budgeted 3,875.21 Remaining 57 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 BEST BUY 00001487 668.38 85.98 754.36 BEST BUY 00001487 PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 85.98 754.36 ** 2,000.00 Budgeted 1,245.64 Remaining 38 % Used Account: 135-65095-030-000 Maintenance Supplies 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMSCLUB.COM 3,183.98 63.37 3,247.35 SAMSCLUB.COM PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMSCLUB.COM 42.46 3,289.81 SAMSCLUB.COM PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMSCLUB.COM 67.04 3,356.85 SAMSCLUB.COM PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AMAZON MKTPLACE PMTS 50.65 3,407.50 AMAZON MKTPLACE PMTS PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMSCLUB.COM 78.75 3,486.25 SAMSCLUB.COM PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 SAMS CLUB #4795 73.58 3,559.83 SAMS CLUB #4795 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 WM SUPERCENTER #5247 15.92 3,575.75 WM SUPERCENTER #5247 PC 2275 08/31/2017 Pcard 07/27/17 - 08/28/17 AMAZON MKTPLACE PMTS 108.26 3,684.01 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 500.03 3,684.01 ** 4,000.00 Budgeted 315.99 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 2,553.88 .00 2,553.88 _______________ Account: 135-65105-030-000 Printing Totals: .00 2,553.88 ** 2,500.00 Budgeted (53.88) Remaining 102 % Used Account: 135-69005-030-000 Capital Outlays 2325 08/31/2017 Recode Bollards/Water to Adm 109,881.15 9,875.00 119,756.15 GL _______________ Account: 135-69005-030-000 Capital Outlays Totals: 9,875.00 119,756.15 ** 265,424.00 Budgeted 145,667.85 Remaining 45 % Used Account: 135-69170-030-000 Copier Lease Installments 2168 08/21/2017 August A/P Copier Lease 3,002.55 194.00 3,196.55 EVERBANK COMMERCIAL FINANCE 3414 AP 2197 08/25/2017 August A/P Copies 7/23-8/22 168.30 3,364.85 KYOCERA DOCUMENT SOLUTIONS 3447 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 362.30 3,364.85 ** 4,600.00 Budgeted 1,235.15 Remaining 73 % Used Department 30 Totals: ----------------------------------- 1,011,065.06 ** 95,977.91 Monthly Total 1,443,018.00 Budgeted 431,952.94 Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2017 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 2168 08/21/2017 August A/P Legal July 65,180.79 7,950.00 73,130.79 McLean & Howard, L.L.P. 3424 AP 2168 08/21/2017 August A/P Permit Renewal Legal July 660.00 73,790.79 McLean & Howard, L.L.P. 3424 AP 2168 08/21/2017 August A/P Legal July 1,400.00 75,190.79 McLean & Howard, L.L.P. 3424 AP 2172 08/22/2017 August A/P Legal - WWTP 11,407.00 86,597.79 Dubois Bryant Campbell LLP 3412 AP 2172 08/22/2017 August A/P Legal - WWTP 18,105.00 104,702.79 Dubois Bryant Campbell LLP 3412 AP 2195 08/24/2017 Void ck 3424 McLean & Howard Legal July (7,950.00) 96,752.79 McLean & Howard, L.L.P. 3424 AP 2195 08/24/2017 Void ck 3424 McLean & Howard Permit Renewal Legal July (660.00) 96,092.79 McLean & Howard, L.L.P. 3424 AP 2195 08/24/2017 Void ck 3424 McLean & Howard Legal July (1,400.00) 94,692.79 McLean & Howard, L.L.P. 3424 AP 2197 08/25/2017 August A/P Legal July 7,950.00 102,642.79 McLean & Howard, L.L.P. 3448 AP 2197 08/25/2017 August A/P Permit Renewal Legal July 660.00 103,302.79 McLean & Howard, L.L.P. 3448 AP 2197 08/25/2017 August A/P Legal July 1,050.00 104,352.79 McLean & Howard, L.L.P. 3448 AP 2297 08/31/2017 August A/P August Legal 5,103.13 109,455.92 McLean & Howard, L.L.P. AP 2297 08/31/2017 August A/P August legal 1,050.00 110,505.92 McLean & Howard, L.L.P. AP 2300 08/31/2017 August A/P Legal/August 10,072.50 120,578.42 Dubois Bryant Campbell LLP AP 2285 08/31/2017 August A/P February Legal 6,132.50 126,710.92 THE LISTON LAW FIRM, P.C. 3480 AP 2285 08/31/2017 August A/P March Legal 5,572.67 132,283.59 THE LISTON LAW FIRM, P.C. 3480 AP 2285 08/31/2017 August A/P April Legal 9,747.71 142,031.30 THE LISTON LAW FIRM, P.C. 3480 AP 2285 08/31/2017 August A/P May Legal 9,295.00 151,326.30 THE LISTON LAW FIRM, P.C. 3480 AP _______________ Account: 135-55045-039-000 Legal Totals: 86,145.51 151,326.30 ** 150,000.00 Budgeted (1,326.30) Remaining 101 % Used Account: 135-55055-039-000 Auditing 18,808.92 .00 18,808.92 _______________ Account: 135-55055-039-000 Auditing Totals: .00 18,808.92 ** 23,860.00 Budgeted 5,051.08 Remaining 79 % Used Account: 135-55060-039-000 Appraisal 8,667.45 .00 8,667.45 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,667.45 ** 11,115.00 Budgeted 2,447.55 Remaining 78 % Used Account: 135-55065-039-000 Tax Admin Fees 2,561.76 .00 2,561.76 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 39 Totals: ----------------------------------- 181,364.43 ** 86,145.51 Monthly Total 188,775.00 Budgeted 7,410.57 Remaining 96 % Used Fund 135 Totals: ----------------------------------- (1,228,831.48) (279,640.14) Monthly Total .00 Budgeted 1,228,831.48 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (156,420.00) ** .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 2171 08/22/2017 GASB Xfer/Fire repairs FY 2017 23,163.91 23,163.91 GL _______________ Account: 137-69195-045-000 GASB Replacement Totals: 23,163.91 23,163.91 ** .00 Budgeted (23,163.91) Remaining 0 % Used Department 45 Totals: ----------------------------------- 23,163.91 ** 23,163.91 Monthly Total .00 Budgeted (23,163.91) Remaining 0 % Used Fund 137 Totals: ----------------------------------- (133,256.09) 23,163.91 Monthly Total .00 Budgeted 133,256.09 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET AUGUST 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,839,737 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,839,737 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 790,917 TOTAL LIABILITIES 790,917 FUND BALANCE ASSIGNED FUND BALANCE 4,433,035 NET REVENUES / EXPENDITURES (2,384,215) TOTAL FUND BALANCE 2,048,820 TOTAL LIABILITIES AND FUND BALANCE 2,839,737 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 14:29 09/14/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,423.58- 20,496.06- 20,496.06 Subtotal: 2,423.58- 20,496.06- 20,496.06 Program number: 2,423.58- 20,496.06- 20,496.06 Department number: Revenues 2,423.58- 20,496.06- 20,496.06 Revenues Subtotal ----------- 2,423.58- 20,496.06- 20,496.06 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 14:29 09/14/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 2,404,710.67 2,404,710.67- Subtotal: 2,404,710.67 2,404,710.67- Program number: 2,404,710.67 2,404,710.67- Department number: Wastewater 2,404,710.67 2,404,710.67- Expenditures Subtotal ----------- 2,404,710.67 2,404,710.67- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 2,423.58- 2,384,214.61 2,384,214.61- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (18,072.48) (2,423.58) (20,496.06) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (2,423.58) (20,496.06) ** .00 Budgeted 20,496.06 Remaining 0 % Used Department Totals: ----------------------------------- (20,496.06) ** (2,423.58) Monthly Total .00 Budgeted 20,496.06 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 2,404,710.67 .00 2,404,710.67 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 2,404,710.67 ** .00 Budgeted (2,404,710.67) Remaining 0 % Used Department 20 Totals: ----------------------------------- 2,404,710.67 ** .00 Monthly Total .00 Budgeted (2,404,710.67) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 2,384,214.61 (2,423.58) Monthly Total .00 Budgeted (2,384,214.61) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET AUGUST 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES (13,158) TOTAL FUND BALANCE (13,158) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:29 09/14/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-010-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- 519-69005-010-000 Capital Outlays 12,615.00 12,615.00 12,615.00- Subtotal: 12,615.00 12,615.00 12,615.00- Program number: 12,615.00 13,157.95 13,157.95- Department number: Water 12,615.00 13,157.95 13,157.95- Expenditures Subtotal ----------- 12,615.00 13,157.95 13,157.95- Fund number: 519 2016 Rev Bond Const-SWIFT 12,615.00 13,157.95 13,157.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60245-010-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-010-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2303 08/31/2017 Recode CPY to Due from SWIFT 12,615.00 12,615.00 GL _______________ Account: 519-69005-010-000 Capital Outlays Totals: 12,615.00 12,615.00 ** .00 Budgeted (12,615.00) Remaining 0 % Used Department 10 Totals: ----------------------------------- 13,157.95 ** 12,615.00 Monthly Total .00 Budgeted (13,157.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 13,157.95 12,615.00 Monthly Total .00 Budgeted (13,157.95) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 411,865 ACCOUNTS RECEIVABLE - TOTAL ASSETS 411,865 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 216,103 TOTAL FUND BALANCE 411,865 TOTAL LIABILITIES AND FUND BALANCE 411,865 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:29 09/14/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 340.91- 1,998.83- 666.277 1,698.83 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 4,083.00- 43,964.45- 67.721 20,955.55- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 10,278.00- 170,139.25- 137.773 46,647.25 Subtotal: 188,712.00- 188,712.00- 14,701.91- 216,102.53- 114.514 27,390.53 Program number: 188,712.00- 188,712.00- 14,701.91- 216,102.53- 114.514 27,390.53 Department number: 188,712.00- 188,712.00- 14,701.91- 216,102.53- 114.514 27,390.53 Revenues Subtotal ----------- 188,712.00- 188,712.00- 14,701.91- 216,102.53- 114.514 27,390.53 Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 14,701.91- 216,102.53- 114.514 27,390.53 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (1,657.92) (340.91) (1,998.83) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (340.91) (1,998.83) ** (300.00) Budgeted 1,698.83 Remaining 666 % Used Account: 528-49142-000-000 Interfund transfer in-Water 2173 08/22/2017 Texpool Transfers (39,881.45) (4,083.00) (43,964.45) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (43,964.45) ** (64,920.00) Budgeted (20,955.55) Remaining 68 % Used Account: 528-49143-000-000 Interfund transfer in-WW 2173 08/22/2017 Texpool Transfers (159,861.25) (10,278.00) (170,139.25) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (170,139.25) ** (123,492.00) Budgeted 46,647.25 Remaining 138 % Used Department Totals: ----------------------------------- (216,102.53) ** (14,701.91) Monthly Total (188,712.00) Budgeted 27,390.53 Remaining 115 % Used Fund 528 Totals: ----------------------------------- (216,102.53) (14,701.91) Monthly Total (188,712.00) Budgeted 27,390.53 Remaining 115 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 26,137 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 11,480 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 42,190 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 11,480 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 11,480 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 4,679 TOTAL FUND BALANCE 30,710 TOTAL LIABILITIES AND FUND BALANCE 42,190 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:29 09/14/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 858.73- 672,881.96- 99.933 454.04- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 3.53- 1,702.28- 48.623 1,798.72- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 59.03- 2,045.69- 102.285 45.69 Subtotal: 678,837.00- 678,837.00- 921.29- 676,629.93- 99.675 2,207.07- 533-49010-000-000 Interest Income 140.00- 140.00- 579.52- 3,535.38- 2,525.271 3,395.38 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.80- 120,492.00- 100.000 Subtotal: 337,386.00- 337,386.00- 11,533.32- 340,781.38- 101.006 3,395.38 Program number: 1,016,223.00- 1,016,223.00- 12,454.61- 1,017,411.31- 100.117 1,188.31 Department number: Revenues 1,016,223.00- 1,016,223.00- 12,454.61- 1,017,411.31- 100.117 1,188.31 Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 12,454.61- 1,017,411.31- 100.117 1,188.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:29 09/14/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 700.00 1,950.00 76.471 600.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 150,291.25 300,782.50 100.066 199.50- 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 710,000.00 100.000 Subtotal: 1,013,133.00 1,013,133.00 860,991.25 1,012,732.50 99.960 400.50 Program number: 1,013,133.00 1,013,133.00 860,991.25 1,012,732.50 99.960 400.50 Department number: Administration 1,013,133.00 1,013,133.00 860,991.25 1,012,732.50 99.960 400.50 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 860,991.25 1,012,732.50 99.960 400.50 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 848,536.64 4,678.81- 151.418 1,588.81 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2017 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 2229 08/01/2017 Property Taxes (672,023.23) (90.46) (672,113.69) GL 2230 08/02/2017 Property Taxes (66.04) (672,179.73) GL 2231 08/03/2017 Property Taxes (181.26) (672,360.99) GL 2233 08/07/2017 Property Taxes (295.47) (672,656.46) GL 2234 08/09/2017 Property Taxes (19.59) (672,676.05) GL 2235 08/10/2017 Property Taxes (6.32) (672,682.37) GL 2236 08/21/2017 Property Taxes (54.14) (672,736.51) GL 2237 08/22/2017 Property Taxes (1.50) (672,738.01) GL 2238 08/23/2017 Property Taxes (106.48) (672,844.49) GL 2271 08/30/2017 Property Taxes (37.47) (672,881.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (858.73) (672,881.96) ** (673,336.00) Budgeted (454.04) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2230 08/02/2017 Property Taxes (1,698.75) (3.51) (1,702.26) GL 2271 08/30/2017 Property Taxes (.02) (1,702.28) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.53) (1,702.28) ** (3,501.00) Budgeted (1,798.72) Remaining 49 % Used Account: 533-40015-000-000 Property Taxes/P & I 2230 08/02/2017 Property Taxes (1,986.66) (1.37) (1,988.03) GL 2231 08/03/2017 Property Taxes (3.39) (1,991.42) GL 2233 08/07/2017 Property Taxes (34.20) (2,025.62) GL 2234 08/09/2017 Property Taxes (1.41) (2,027.03) GL 2235 08/10/2017 Property Taxes (.89) (2,027.92) GL 2236 08/21/2017 Property Taxes (10.28) (2,038.20) GL 2237 08/22/2017 Property Taxes (.12) (2,038.32) GL 2238 08/23/2017 Property Taxes (4.76) (2,043.08) GL 2271 08/30/2017 Property Taxes (2.61) (2,045.69) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (59.03) (2,045.69) ** (2,000.00) Budgeted 45.69 Remaining 102 % Used Account: 533-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (2,955.86) (579.52) (3,535.38) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (579.52) (3,535.38) ** (140.00) Budgeted 3,395.38 Remaining 2.525 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49015-000-000 Lease/Rental Income (216,754.00) .00 (216,754.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (216,754.00) ** (216,754.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 2189 08/23/2017 Texpool Transfers (109,538.20) (10,953.80) (120,492.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.80) (120,492.00) ** (120,492.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (1,017,411.31) ** (12,454.61) Monthly Total (1,016,223.00) Budgeted 1,188.31 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2017 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 2302 08/25/2017 TCMUD1-13 Paying Agent fee 1,250.00 500.00 1,750.00 GL 2169 08/25/2017 9/1/17 Bond Payments BOKF Unl Tax Bond, Series 2014 200.00 1,950.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 700.00 1,950.00 ** 2,550.00 Budgeted 600.00 Remaining 76 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 2169 08/25/2017 9/1/17 Bond Payments BOKF Unl Tax Bond, Series 2014 150,491.25 72,400.00 222,891.25 GL 2169 08/25/2017 9/1/17 Bond Payments BNY MELLON Unl Tax Series 2010 34,328.75 257,220.00 GL 2169 08/25/2017 9/1/17 Bond Payments BNYMELLON Unl Tax Ref Ser 2012 22,175.00 279,395.00 GL 2169 08/25/2017 9/1/17 Bond Payments BNYMELLON Unl Tax Ref Ser 2013 21,387.50 300,782.50 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 150,291.25 300,782.50 ** 300,583.00 Budgeted (199.50) Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 2169 08/25/2017 9/1/17 Bond Payments BOKF Unl Tax Bond, Series 2014 240,000.00 240,000.00 GL 2169 08/25/2017 9/1/17 Bond Payments BNY MELLON Unl Tax Series 2010 80,000.00 320,000.00 GL 2169 08/25/2017 9/1/17 Bond Payments BNYMELLON Unl Tax Ref Ser 2012 205,000.00 525,000.00 GL 2169 08/25/2017 9/1/17 Bond Payments BNYMELLON Unl Tax Ref Ser 2013 185,000.00 710,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: 710,000.00 710,000.00 ** 710,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,012,732.50 ** 860,991.25 Monthly Total 1,013,133.00 Budgeted 400.50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (4,678.81) 848,536.64 Monthly Total (3,090.00) Budgeted 1,588.81 Remaining 151 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET AUGUST 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 16,197 ACCOUNTS RECEIVABLE - TOTAL ASSETS 16,197 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 1,100 TOTAL FUND BALANCE 16,197 TOTAL LIABILITIES AND FUND BALANCE 16,197 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:29 09/14/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 296.14- 1,498.93- 749.465 1,298.93 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 54,148.90- 595,638.00- 100.000 Subtotal: 892,849.00- 892,849.00- 54,445.04- 597,136.93- 66.880 295,712.07- Program number: 892,849.00- 892,849.00- 54,445.04- 597,136.93- 66.880 295,712.07- Department number: Revenues 892,849.00- 892,849.00- 54,445.04- 597,136.93- 66.880 295,712.07- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,445.04- 597,136.93- 66.880 295,712.07- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 14:29 09/14/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 200.00 400.00 400.00- 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 115,318.75 230,637.50 59.496 157,011.50 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 365,000.00 365,000.00 72.277 140,000.00 Subtotal: 892,649.00 892,649.00 480,518.75 596,037.50 66.772 296,611.50 Program number: 892,649.00 892,649.00 480,518.75 596,037.50 66.772 296,611.50 Department number: Administration 892,649.00 892,649.00 480,518.75 596,037.50 66.772 296,611.50 Expenditures Subtotal ----------- 892,649.00 892,649.00 480,518.75 596,037.50 66.772 296,611.50 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 426,073.71 1,099.43- 549.715 899.43 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (1,202.79) (296.14) (1,498.93) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (296.14) (1,498.93) ** (200.00) Budgeted 1,298.93 Remaining 749 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 2189 08/23/2017 Texpool Transfers (541,489.10) (54,148.90) (595,638.00) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.90) (595,638.00) ** (595,638.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (597,136.93) ** (54,445.04) Monthly Total (892,849.00) Budgeted (295,712.07) Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee 2169 08/25/2017 9/1/17 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 200.00 200.00 400.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 400.00 ** .00 Budgeted (400.00) Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 2169 08/25/2017 9/1/17 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 115,318.75 115,318.75 230,637.50 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 115,318.75 230,637.50 ** 387,649.00 Budgeted 157,011.50 Remaining 59 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 2169 08/25/2017 9/1/17 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 365,000.00 365,000.00 GL _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 365,000.00 365,000.00 ** 505,000.00 Budgeted 140,000.00 Remaining 72 % Used Department 51 Totals: ----------------------------------- 596,037.50 ** 480,518.75 Monthly Total 892,649.00 Budgeted 296,611.50 Remaining 67 % Used Fund 534 Totals: ----------------------------------- (1,099.43) 426,073.71 Monthly Total (200.00) Budgeted 899.43 Remaining 550 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 951 ACCOUNTS RECEIVABLE - TOTAL ASSETS 951 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 951 TOTAL FUND BALANCE 951 TOTAL LIABILITIES AND FUND BALANCE 951 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 14:29 09/14/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 145.93- 750.84- 750.84 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 240,821.65- 240,821.65 Subtotal: 22,038.81- 241,572.49- 241,572.49 Program number: 22,038.81- 241,572.49- 241,572.49 Department number: Revenues 22,038.81- 241,572.49- 241,572.49 Revenues Subtotal ----------- 22,038.81- 241,572.49- 241,572.49 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 14:29 09/14/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 8/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 200.00 200.00 200.00- 535-70040-051-000 Revenue Bond Interest Expense 50,421.65 50,421.65 50,421.65- 535-70045-051-000 Revenue Bond Principal Expense 190,000.00 190,000.00 190,000.00- Subtotal: 240,621.65 240,621.65 240,621.65- Program number: 240,621.65 240,621.65 240,621.65- Department number: Administration 240,621.65 240,621.65 240,621.65- Expenditures Subtotal ----------- 240,621.65 240,621.65 240,621.65- Fund number: 535 2016 Rev Bond I&S-SWIFT 218,582.84 950.84- 950.84 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 2294 08/31/2017 Bank Interest/August (604.91) (145.93) (750.84) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (145.93) (750.84) ** .00 Budgeted 750.84 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 2173 08/22/2017 Texpool Transfers (218,928.77) (21,892.88) (240,821.65) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (240,821.65) ** .00 Budgeted 240,821.65 Remaining 0 % Used Department Totals: ----------------------------------- (241,572.49) ** (22,038.81) Monthly Total .00 Budgeted 241,572.49 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 14:29 09/14/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 8/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee 2169 08/25/2017 9/1/17 Bond Payments BOKF SWIFT 1TROP1116WSS 200.00 200.00 GL _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 2169 08/25/2017 9/1/17 Bond Payments BOKF SWIFT 1TROP1116WSS 50,421.65 50,421.65 GL _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 50,421.65 50,421.65 ** .00 Budgeted (50,421.65) Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense 2169 08/25/2017 9/1/17 Bond Payments BOKF SWIFT 1TROP1116WSS 190,000.00 190,000.00 GL _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 190,000.00 190,000.00 ** .00 Budgeted (190,000.00) Remaining 0 % Used Department 51 Totals: ----------------------------------- 240,621.65 ** 240,621.65 Monthly Total .00 Budgeted (240,621.65) Remaining 0 % Used Fund 535 Totals: ----------------------------------- (950.84) 218,582.84 Monthly Total .00 Budgeted 950.84 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 759,543.57 **** 1,286,319.55 Monthly Total (192,002.00) Budgeted (951,545.57) Remaining ########## ******* End of Report *********