Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-07 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 625,379 PREPAID EXPENSES 2,752 ADVALOREM PROPERTY TAXES RECEIVABLE 18,987 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 647,118 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 18,987 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 18,987 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 107,023 TOTAL FUND BALANCE 628,131 TOTAL LIABILITIES AND FUND BALANCE 647,118 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 18:32 08/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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- 3,748.77- 1,033,621.02- 99.789 2,188.98- 122-40011-000-000 Property Taxes/Fire-Delinquent 6.99- 2,880.71- 2,880.71 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 240.12- 3,782.55- 84.057 717.45- Subtotal: 1,040,310.00- 1,040,310.00- 3,995.88- 1,040,396.30- 100.008 86.30 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 3,995.88- 1,040,545.30- 100.023 235.30 Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 3,995.88- 1,040,545.30- 100.023 235.30 Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 3,995.88- 1,040,545.30- 100.023 235.30 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 18:32 08/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 10,753.91 10,753.91- Subtotal: 10,753.91 10,753.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 13,760.90 83.334 2,752.10 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 483,685.00 83.159 97,953.00 Subtotal: 814,905.00 814,905.00 50,350.09 714,199.90 87.642 100,705.10 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.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 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 50,350.09 933,522.41 89.735 106,787.59 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 933,522.41 89.735 106,787.59 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 933,522.41 89.735 106,787.59 Fund number: 122 Trophy Club MUD Fire Dept. 46,354.21 107,022.89- 107,022.89 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 2048 07/03/2017 Property Taxes (1,029,872.25) (109.71) (1,029,981.96) GL 2049 07/05/2017 Property Taxes 228.36 (1,029,753.60) GL 2050 07/06/2017 Property Taxes 38.16 (1,029,715.44) GL 2051 07/10/2017 Property Taxes (20.59) (1,029,736.03) GL 2052 07/12/2017 Property Taxes (2.02) (1,029,738.05) GL 2054 07/13/2017 Property Taxes (304.43) (1,030,042.48) GL 2055 07/14/2017 Property Taxes (161.06) (1,030,203.54) GL 2056 07/17/2017 Property Taxes (196.09) (1,030,399.63) GL 2058 07/18/2017 Property Taxes (110.93) (1,030,510.56) GL 2059 07/19/2017 Property Taxes (448.49) (1,030,959.05) GL 2066 07/20/2017 Property Taxes (249.24) (1,031,208.29) GL 2060 07/21/2017 Property Taxes (293.97) (1,031,502.26) GL 2061 07/25/2017 Property Taxes (297.34) (1,031,799.60) GL 2062 07/26/2017 Property Taxes (953.11) (1,032,752.71) GL 2063 07/27/2017 Property Taxes (404.34) (1,033,157.05) GL 2064 07/31/2017 Property Taxes (463.97) (1,033,621.02) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,748.77) (1,033,621.02) ** (1,035,810.00) Budgeted (2,188.98) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2049 07/05/2017 Property Taxes (2,873.72) (6.63) (2,880.35) GL 2050 07/06/2017 Property Taxes (.36) (2,880.71) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (6.99) (2,880.71) ** .00 Budgeted 2,880.71 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2048 07/03/2017 Property Taxes (3,542.43) (12.65) (3,555.08) GL 2049 07/05/2017 Property Taxes (3.34) (3,558.42) GL 2051 07/10/2017 Property Taxes (6.31) (3,564.73) GL 2052 07/12/2017 Property Taxes 1.97 (3,562.76) GL 2054 07/13/2017 Property Taxes (54.56) (3,617.32) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2056 07/17/2017 Property Taxes (3,542.43) (.16) (3,617.48) GL 2059 07/19/2017 Property Taxes (72.74) (3,690.22) GL 2060 07/21/2017 Property Taxes (.83) (3,691.05) GL 2061 07/25/2017 Property Taxes (38.02) (3,729.07) GL 2062 07/26/2017 Property Taxes (55.63) (3,784.70) GL 2063 07/27/2017 Property Taxes 4.90 (3,779.80) GL 2064 07/31/2017 Property Taxes (2.75) (3,782.55) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (240.12) (3,782.55) ** (4,500.00) Budgeted (717.45) Remaining 84 % 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,040,545.30) ** (3,995.88) Monthly Total (1,040,310.00) Budgeted 235.30 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 10,753.91 .00 10,753.91 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 10,753.91 ** .00 Budgeted (10,753.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 469 07/01/2017 Insurance/Wrk Comp Exp Jul 12,384.81 1,376.09 13,760.90 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 13,760.90 ** 16,513.00 Budgeted 2,752.10 Remaining 83 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1937 07/13/2017 July A/P Fire Admn-July 434,711.00 48,974.00 483,685.00 TOWN OF TROPHY CLUB 3339 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 483,685.00 ** 581,638.00 Budgeted 97,953.00 Remaining 83 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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: ----------------------------------- 933,522.41 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 106,787.59 Remaining 90 % Used Fund 122 Totals: ----------------------------------- (107,022.89) 46,354.21 Monthly Total .00 Budgeted 107,022.89 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,250,281 - 1,250,281 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,634 - 713,634 INVESTMENTS-TEXPOOL 363,453 433,170 796,623 PREPAID EXPENSES 17,113 - 17,113 ADVALOREM PROPERTY TAXES RECEIVABLE 1,856 - 1,856 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,104,223 - 1,104,223 TOTAL ASSETS 4,066,932 433,170 4,500,103 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,856 - 1,856 ACCOUNTS AND OTHER PAYABLES 668,591 - 668,591 CUSTOMER DEPOSITS 315,685 - 315,685 - TOTAL LIABILITIES 986,132 - 986,132 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 697,500 697,500 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 170,365 170,365 UNASSIGNED FUND BALANCE 1,430,622 - 1,430,622 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 949,191 - 949,191 - TOTAL FUND BALANCE 3,080,800 433,170 3,513,970 TOTAL LIABILITIES AND FUND BALANCE 4,066,932 433,170 4,500,103 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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- 220.56- 60,827.86- 99.755 149.14- 135-40002-000-000 Property Taxes/Delinquent 1.29- 268.02- 268.02 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 14.35- 254.38- 39.135 395.62- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 236.20- 61,350.26- 29.226 148,567.74- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 613,151.45- 4,430,104.53- 68.825 2,006,629.47- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 234,881.52- 2,076,179.90- 78.956 553,344.10- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 12,942.10- 98,845.73- 82.883 20,414.27- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,300.00- 12,175.00- 106.798 775.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 1,500.00- 75.000 500.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 3,600.00- 65.455 1,900.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 13,774.40- 58,281.85- 95.250 2,906.15- Subtotal: 9,265,606.00- 9,265,606.00- 876,649.47- 6,680,687.01- 72.102 2,584,918.99- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,781.79- 14,180.63- 177.236 6,179.63 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 9,105.30- 83.336 1,820.70- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 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- 1,372.00- 18,206.02- 84.252 3,402.98- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 385.31- 11,389.29- 56.946 8,610.71- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 5,032.96- 58,746.54- 16.097 306,217.46- Program number: 9,545,080.00- 9,840,488.00- 881,918.63- 6,800,783.81- 69.110 3,039,704.19- Department number: Revenues 9,545,080.00- 9,840,488.00- 881,918.63- 6,800,783.81- 69.110 3,039,704.19- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 881,918.63- 6,800,783.81- 69.110 3,039,704.19- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 16,681.78 180,534.95 66.583 90,608.05 135-50010-010-000 Overtime 19,500.00 19,500.00 1,073.51 10,171.67 52.162 9,328.33 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,225.00 46.354 2,575.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,658.55 17,827.99 65.662 9,323.01 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 1,889.77 24,840.82 44.427 31,073.18 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 205.93 2,417.77 58.133 1,741.23 135-50028-010-000 Vision Insurance 910.00 910.00 40.17 470.72 51.727 439.28 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 193.31 2,133.52 76.116 669.48 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,112.51 11,906.40 62.596 7,114.60 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 260.19 2,784.58 62.603 1,663.42 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 45.00 4.386 981.00 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 9,715.60 73.872 3,436.40 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 270.90 270.90 20.838 1,029.10 135-50070-010-000 Employee Relations 300.00 300.00 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 24,635.78 268,802.01 62.673 160,094.99 135-55005-010-000 Engineering 5,000.00 60,000.00 647.37 38,005.44 63.342 21,994.56 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 114.72 67,808.51 52.769 60,691.49 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 1,109.00 2,459.00 81.967 541.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 638.30 2,057.80 25.723 5,942.20 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 757.70 3,548.26 64.514 1,951.74 Subtotal: 125,000.00 208,500.00 3,267.09 113,879.01 54.618 94,620.99 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.99 3,160.08 58.520 2,239.92 135-60020-010-000 Electricity 172,737.00 172,737.00 17,104.42 123,206.19 71.326 49,530.81 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 235.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 21,940.45 43.727 28,235.55 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 199,195.80 1,472,363.50 49.098 1,526,438.50 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 5,250.00 35.593 9,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 218,928.77 73.711 78,082.23 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 78,141.00- 39,881.45 61.432 25,038.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 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 162,134.09 1,887,216.20 49.399 1,933,151.80 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 674.69 6,966.24 28.058 17,861.76 135-65010-010-000 Uniforms 4,608.00 4,608.00 983.37 2,783.93 60.415 1,824.07 135-65030-010-000 Chemicals 20,000.00 20,000.00 876.88 12,172.71 60.864 7,827.29 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 1,000.00 135-65050-010-000 Meter Expense 115,000.00 31,500.00 6,930.00 23,999.88 76.190 7,500.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 22,896.00 71,160.00 87.313 10,340.00 Subtotal: 256,319.00 164,636.00 32,360.94 117,950.40 71.643 46,685.60 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 50,092.73 352,962.82 51.123 337,459.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 50,092.73 554,920.57 62.184 337,459.43 Program number: 5,326,780.00 5,514,781.00 272,490.63 2,942,768.19 53.361 2,572,012.81 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/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 447.70 1,423.10 28.462 3,576.90 Subtotal: 5,000.00 5,000.00 447.70 1,423.10 28.462 3,576.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 447.70 1,423.10 14.231 8,576.90 Department number: Water 5,336,780.00 5,524,781.00 272,938.33 2,944,191.29 53.291 2,580,589.71 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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,981.82 312,473.59 79.896 78,628.41 135-50010-020-000 Overtime 29,500.00 29,500.00 2,446.53 26,878.82 91.115 2,621.18 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 6,875.00 88.141 925.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,064.36 32,089.41 81.067 7,494.59 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 45,715.11 62.605 27,306.89 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 3,665.68 79.828 926.32 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 785.58 76.196 245.42 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 390.28 3,766.08 83.971 718.92 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,932.43 20,573.20 73.776 7,312.80 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 451.95 4,811.47 73.773 1,710.53 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,049.50 115.004 1,702.50- 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 391.62 60.249 258.38 Subtotal: 605,653.00 605,653.00 45,087.97 477,853.06 78.899 127,799.94 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 1,868.11 91,168.26 114.389 11,468.26- 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 4,510.00 6,076.00 30.380 13,924.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 14.98 7,600.42 115.158 1,000.42- 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 6,255.35 47,391.09 86.166 7,608.91 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 5,405.06 26,778.56 107.114 1,778.56- Subtotal: 277,600.00 276,800.00 18,053.50 199,340.14 72.016 77,459.86 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 412.00 4,080.09 75.557 1,319.91 135-60020-020-000 Electricity 158,627.00 158,627.00 14,056.26 117,227.45 73.901 41,399.55 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 91.57 2,378.30 99.096 21.70 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 3,196.41 18,348.38 106.988 1,198.38- 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 113.27 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 4,130.00 35.603 7,470.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 109,538.20 90.909 10,953.80 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 541,489.10 90.909 54,148.90 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 92,502.00 159,861.25 129.451 36,369.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 176,654.24 964,312.19 76.759 291,969.81 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 540.18 6,985.24 24.869 21,102.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 5,341.00 23,247.95 110.705 2,247.95- 135-65035-020-000 Small Tools 2,000.00 2,000.00 65.18 1,470.72 73.536 529.28 135-65040-020-000 Safety Equipment 750.00 750.00 162.50 517.03 68.937 232.97 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 12,806.95 91.478 1,193.05 Subtotal: 74,297.00 70,297.00 6,108.86 48,781.76 69.394 21,515.24 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 245,904.57 1,891,190.26 70.804 779,841.74 Department number: Wastewater 2,698,015.00 2,671,032.00 245,904.57 1,891,190.26 70.804 779,841.74 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 25.10 78.438 6.90 Subtotal: 32.00 32.00 2.61 25.10 78.438 6.90 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 145.45 12.121 1,054.55 135-60080-026-000 Schools & Training 4,000.00 4,000.00 3,287.35 82.184 712.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 145.45 5,879.75 45.757 6,970.25 Program number: 12,882.00 12,882.00 148.06 5,904.85 45.838 6,977.15 Department number: Board of Directors 12,882.00 12,882.00 148.06 5,904.85 45.838 6,977.15 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 32,233.36 351,707.51 67.651 168,175.49 135-50010-030-000 Overtime 1,000.00 2,500.00 44.73 3,336.57 133.463 836.57- 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,985.72 32,461.53 67.957 15,306.47 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 3,822.05 37,977.27 45.056 46,311.73 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 348.90 3,352.30 56.049 2,628.70 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 75.82 717.75 54.707 594.25 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 460.28 3,786.21 64.282 2,103.79 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 1,914.60 21,157.17 64.549 11,619.83 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 447.75 4,948.03 61.208 3,135.97 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,505.30 84.378 278.70 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 166.45 568.80 113.760 68.80- 135-50070-030-000 Employee Relations 4,960.00 4,960.00 2,605.40 52.528 2,354.60 Subtotal: 719,486.00 720,513.00 42,645.19 467,835.07 64.931 252,677.93 135-55030-030-000 Software & Support 67,791.00 77,791.00 2,315.34 82,385.42 105.906 4,594.42- 135-55070-030-000 Independent Labor 12,000.00 4,000.00 60.00 1,270.00 31.750 2,730.00 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 529.02 6,500.78 92.868 499.22 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 5,438.54 67.982 2,561.46 135-55160-030-000 Professional Outside Services 63,325.00 60,000.00 57,332.00 95.553 2,668.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 669.44 6,287.58 76.678 1,912.42 Subtotal: 185,945.00 177,191.00 4,206.86 160,525.32 90.595 16,665.68 135-60005-030-000 Telephone 17,532.00 17,532.00 1,943.78 10,985.64 62.661 6,546.36 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 262.99 2,741.91 78.340 758.09 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 7,189.04 56.916 5,441.96 135-60025-030-000 Water 1,500.00 1,500.00 196.92 909.42 60.628 590.58 135-60035-030-000 Postage 28,932.00 28,932.00 1,700.76 24,041.99 83.098 4,890.01 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,824.26 42,444.56 76.394 13,115.44 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 4,664.56 46,537.80 83.563 9,154.20 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 331.88 20.743 1,268.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,661.25 77.688 1,338.75 135-60075-030-000 Meetings 400.00 400.00 105.71 26.428 294.29 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 160.00 1,835.00 23.406 6,005.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 56.22 7,011.33 93.484 488.67 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 2,925.33 39.004 4,574.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 84.96 160.96 .920 17,339.04 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 15.94 1,055.94 42.238 1,444.06 Subtotal: 246,041.00 247,491.00 13,910.39 160,135.05 64.703 87,355.95 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 464.35 4,859.21 53.991 4,140.79 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 189.60 668.38 33.419 1,331.62 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 285.91 3,183.98 79.600 816.02 135-65105-030-000 Printing 4,800.00 2,500.00 223.00 2,553.88 102.155 53.88- Subtotal: 32,099.00 27,799.00 1,162.86 13,708.01 49.311 14,090.99 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 109,881.15 41.398 155,542.85 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 165.00 3,002.55 65.273 1,597.45 Subtotal: 111,601.00 270,024.00 165.00 112,883.70 41.805 157,140.30 Program number: 1,295,172.00 1,443,018.00 62,090.30 915,087.15 63.415 527,930.85 Department number: Administration 1,295,172.00 1,443,018.00 62,090.30 915,087.15 63.415 527,930.85 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 18:32 08/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 11,790.00 65,180.79 43.454 84,819.21 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 11,790.00 95,218.92 50.440 93,556.08 Program number: 188,775.00 188,775.00 11,790.00 95,218.92 50.440 93,556.08 Department number: Non Departmental 188,775.00 188,775.00 11,790.00 95,218.92 50.440 93,556.08 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 592,871.26 5,851,592.47 59.464 3,988,895.53 Fund number: 135 MUD 1 General Fund 13,456.00- 289,047.37- 949,191.34- 949,191.34 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 18:32 08/10/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 2048 07/03/2017 Property Taxes (60,607.30) (6.46) (60,613.76) GL 2049 07/05/2017 Property Taxes 13.43 (60,600.33) GL 2050 07/06/2017 Property Taxes 2.24 (60,598.09) GL 2051 07/10/2017 Property Taxes (1.21) (60,599.30) GL 2052 07/12/2017 Property Taxes (.11) (60,599.41) GL 2054 07/13/2017 Property Taxes (17.91) (60,617.32) GL 2055 07/14/2017 Property Taxes (9.48) (60,626.80) GL 2056 07/17/2017 Property Taxes (11.54) (60,638.34) GL 2058 07/18/2017 Property Taxes (6.53) (60,644.87) GL 2059 07/19/2017 Property Taxes (26.38) (60,671.25) GL 2066 07/20/2017 Property Taxes (14.66) (60,685.91) GL 2060 07/21/2017 Property Taxes (17.29) (60,703.20) GL 2061 07/25/2017 Property Taxes (17.49) (60,720.69) GL 2062 07/26/2017 Property Taxes (56.08) (60,776.77) GL 2063 07/27/2017 Property Taxes (23.79) (60,800.56) GL 2064 07/31/2017 Property Taxes (27.30) (60,827.86) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (220.56) (60,827.86) ** (60,977.00) Budgeted (149.14) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2049 07/05/2017 Property Taxes (266.73) (1.27) (268.00) GL 2050 07/06/2017 Property Taxes (.02) (268.02) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.29) (268.02) ** .00 Budgeted 268.02 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2048 07/03/2017 Property Taxes (240.03) (.74) (240.77) GL 2049 07/05/2017 Property Taxes (.53) (241.30) GL 2051 07/10/2017 Property Taxes (.37) (241.67) GL 2052 07/12/2017 Property Taxes .22 (241.45) GL 2054 07/13/2017 Property Taxes (3.21) (244.66) GL 2056 07/17/2017 Property Taxes (.01) (244.67) GL 2059 07/19/2017 Property Taxes (4.28) (248.95) GL 2060 07/21/2017 Property Taxes (.05) (249.00) GL 2061 07/25/2017 Property Taxes (2.24) (251.24) GL 2062 07/26/2017 Property Taxes (3.27) (254.51) GL 2063 07/27/2017 Property Taxes .29 (254.22) GL 2064 07/31/2017 Property Taxes (.16) (254.38) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-40015-000-000 Property Taxes/P & I Totals: (14.35) (254.38) ** (650.00) Budgeted (395.62) Remaining 39 % 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 Account: 135-47000-000-000 Water 1846 07/03/2017 07/03/2017 UB Adjust bill UB20170703-20170703 User: (3,816,953.08) 23.76 (3,816,929.32) UB 1913 07/07/2017 07/07/2017 UB Bill Adjustments UB20170707-20170707 User: 12.25 (3,816,917.07) UB 2026 07/22/2017 UB Acct adj UB20170722-20170722 User: 73.42 (3,816,843.65) UB 2014 07/31/2017 UB July Billing UB20170731-20170731 User: (613,260.88) (4,430,104.53) UB _______________ Account: 135-47000-000-000 Water Totals: (613,151.45) (4,430,104.53) ** (6,436,734.00) Budgeted (2,006,629.47) Remaining 69 % Used Account: 135-47005-000-000 Sewer 1911 07/07/2017 07/07/2017 UB Bill Adjustments UB20170707-20170707 User: (1,841,298.38) 20.07 (1,841,278.31) UB 2014 07/31/2017 UB July Billing UB20170731-20170731 User: (234,901.59) (2,076,179.90) UB _______________ Account: 135-47005-000-000 Sewer Totals: (234,881.52) (2,076,179.90) ** (2,629,524.00) Budgeted (553,344.10) Remaining 79 % Used Account: 135-47025-000-000 Penalties 2019 07/18/2017 UB Penalty removed UB20170718-20170718 User: (85,903.63) 19.95 (85,883.68) UB 2022 07/19/2017 UB Penalty removal UB20170719-20170719 User: 150.63 (85,733.05) UB 1970 07/21/2017 Penalties UB 7/21/17 UB20170721-20170721 User: (17,072.28) (102,805.33) UB 2025 07/21/2017 UB Penalty removal UB20170721-20170721 User: 30.02 (102,775.31) UB 2027 07/24/2017 UB penalty removal UB20170724-20170724 User: 16.94 (102,758.37) UB 2028 07/25/2017 UB Penalty removal UB20170725-20170725 User: 319.66 (102,438.71) UB 2029 07/27/2017 UB Penalty removal UB20170727-20170727 User: 310.09 (102,128.62) UB 2030 07/28/2017 UB penalty removal-CC UB20170728-20170728 User: 3,059.59 (99,069.03) UB 2031 07/31/2017 UB Penalty removal UB20170731-20170731 User: 223.30 (98,845.73) UB _______________ Account: 135-47025-000-000 Penalties Totals: (12,942.10) (98,845.73) ** (119,260.00) Budgeted (20,414.27) Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-47030-000-000 Service Charges 1856 07/06/2017 UB Cut off list UB20170706-20170706 User: (10,875.00) (1,100.00) (11,975.00) UB 1886 07/07/2017 07/07/2017 UB After hours fees UB20170707-20170707 User: (200.00) (12,175.00) UB 2020 07/19/2017 UB Returned ACH UB20170719-20170719 User: (25.00) (12,200.00) UB 2023 07/21/2017 UB NSF Check UB20170721-20170721 User: (25.00) (12,225.00) UB 2028 07/25/2017 UB Penalty removal UB20170725-20170725 User: 50.00 (12,175.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,300.00) (12,175.00) ** (11,400.00) Budgeted 775.00 Remaining 107 % Used Account: 135-47035-000-000 Plumbing Inspections 2003 07/24/2017 Permit ck 504 Fisher Drive (1,350.00) (50.00) (1,400.00) Ashton Woods Homes CR 2003 07/24/2017 Permit ck 423 Ramsey Trail (50.00) (1,450.00) Ashton Woods Homes CR 2016 07/27/2017 Permits-501 Fisher Drive 501 Fisher Drive (50.00) (1,500.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,500.00) ** (2,000.00) Budgeted (500.00) Remaining 75 % Used Account: 135-47045-000-000 Sewer Inspections 2003 07/24/2017 Permit ck 504 Fisher Drive (3,150.00) (150.00) (3,300.00) Ashton Woods Homes CR 2003 07/24/2017 Permit ck 423 Ramsey Trail (150.00) (3,450.00) Ashton Woods Homes CR 2016 07/27/2017 Permits-501 Fisher Drive 501 Fisher Drive (150.00) (3,600.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (3,600.00) ** (5,500.00) Budgeted (1,900.00) Remaining 65 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2014 07/31/2017 UB July Billing UB20170731-20170731 User: (44,507.45) (13,774.40) (58,281.85) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (13,774.40) (58,281.85) ** (61,188.00) Budgeted (2,906.15) Remaining 95 % Used Account: 135-49010-000-000 Interest Income 2095 07/31/2017 Bank Interest/July (12,398.84) (151.49) (12,550.33) GL 2095 07/31/2017 Bank Interest/July (341.76) (12,892.09) GL 2095 07/31/2017 Bank Interest/July (1,288.54) (14,180.63) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,781.79) (14,180.63) ** (8,001.00) Budgeted 6,179.63 Remaining 177 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-49016-000-000 Cell Tower Revenue 2085 07/07/2017 AT&T Cell Tower Revenue (8,194.77) (910.53) (9,105.30) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,105.30) ** (10,926.00) Budgeted (1,820.70) Remaining 83 % Used Account: 135-49018-000-000 Building Rent Income 2113 07/31/2017 Town Billed Inv 1580-1584 AR 20170731-20170731 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used Account: 135-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 2003 07/24/2017 Permit ck 504 Fisher Drive (16,834.02) (343.00) (17,177.02) Ashton Woods Homes CR 2003 07/24/2017 Permit ck 423 Ramsey Trail (343.00) (17,520.02) Ashton Woods Homes CR 2016 07/27/2017 Permits-501 Fisher Drive 501 Fisher Drive (343.00) (17,863.02) Ashton Wood Homes CR 2010 07/31/2017 Permit check-2902 Nottingham 2902 Nottingham Drive (343.00) (18,206.02) Texas Mackey Custom Homes, LLC CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,372.00) (18,206.02) ** (21,609.00) Budgeted (3,402.98) Remaining 84 % Used Account: 135-49900-000-000 Miscellaneous Income 2024 07/21/2017 UB Meter Test Fee UB20170721-20170721 User: (11,003.98) (150.00) (11,153.98) UB 2014 07/31/2017 UB July Billing UB20170731-20170731 User: (235.31) (11,389.29) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (385.31) (11,389.29) ** (20,000.00) Budgeted (8,610.71) Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-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: ----------------------------------- (6,800,783.81) ** (881,918.63) Monthly Total (9,840,488.00) Budgeted (3,039,704.19) Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1915 07/14/2017 MUD PR 07.14.17 Salaries & Wages 163,853.17 8,340.89 172,194.06 PR 1985 07/28/2017 PR 07.28.17 Salaries & Wages 8,340.89 180,534.95 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,681.78 180,534.95 ** 271,143.00 Budgeted 90,608.05 Remaining 67 % Used Account: 135-50010-010-000 Overtime 1915 07/14/2017 MUD PR 07.14.17 Overtime 9,098.16 697.79 9,795.95 PR 1985 07/28/2017 PR 07.28.17 Overtime 375.72 10,171.67 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,073.51 10,171.67 ** 19,500.00 Budgeted 9,328.33 Remaining 52 % 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 1985 07/28/2017 PR 07.28.17 Certification 2,050.00 175.00 2,225.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 2,225.00 ** 4,800.00 Budgeted 2,575.00 Remaining 46 % Used Account: 135-50020-010-000 Retirement 1915 07/14/2017 MUD PR 07.14.17 Retirement 16,169.44 836.09 17,005.53 PR 1985 07/28/2017 PR 07.28.17 Retirement 822.46 17,827.99 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,658.55 17,827.99 ** 27,151.00 Budgeted 9,323.01 Remaining 66 % Used Account: 135-50026-010-000 Medical Insurance 1915 07/14/2017 MUD PR 07.14.17 Medical Insurance 22,951.05 944.88 23,895.93 PR 1985 07/28/2017 PR 07.28.17 Medical Insurance 944.89 24,840.82 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,889.77 24,840.82 ** 55,914.00 Budgeted 31,073.18 Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1915 07/14/2017 MUD PR 07.14.17 Dental Insurance 2,211.84 102.98 2,314.82 PR 1985 07/28/2017 PR 07.28.17 Dental Insurance 102.95 2,417.77 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 205.93 2,417.77 ** 4,159.00 Budgeted 1,741.23 Remaining 58 % Used Account: 135-50028-010-000 Vision Insurance 1915 07/14/2017 MUD PR 07.14.17 Vision Insurance 430.55 20.10 450.65 PR 1985 07/28/2017 PR 07.28.17 Vision Insurance 20.07 470.72 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.17 470.72 ** 910.00 Budgeted 439.28 Remaining 52 % Used Account: 135-50029-010-000 Life Insurance & Other 1781 07/01/2017 July A/P July-Dental, vision & other in 1,940.21 183.60 2,123.81 METLIFE GROUP BENEFITS 3257 AP 2053 07/31/2017 July A/P Café 125 adm fee 9.71 2,133.52 BenefitMall 3353 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 193.31 2,133.52 ** 2,803.00 Budgeted 669.48 Remaining 76 % Used Account: 135-50030-010-000 Social Security Taxes 1915 07/14/2017 MUD PR 07.14.17 Social Security Taxes 10,793.89 570.45 11,364.34 PR 1985 07/28/2017 PR 07.28.17 Social Security Taxes 542.06 11,906.40 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,112.51 11,906.40 ** 19,021.00 Budgeted 7,114.60 Remaining 63 % Used Account: 135-50035-010-000 Medicare Taxes 1915 07/14/2017 MUD PR 07.14.17 Medicare Taxes 2,524.39 133.41 2,657.80 PR 1985 07/28/2017 PR 07.28.17 Medicare Taxes 126.78 2,784.58 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 260.19 2,784.58 ** 4,448.00 Budgeted 1,663.42 Remaining 63 % Used Account: 135-50040-010-000 Unemployment Taxes 45.00 .00 45.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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: .00 45.00 ** 1,026.00 Budgeted 981.00 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 469 07/01/2017 Insurance/Wrk Comp Exp Jul 8,641.44 1,074.16 9,715.60 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 9,715.60 ** 13,152.00 Budgeted 3,436.40 Remaining 74 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 2076 07/31/2017 July A/P pre employment screening 270.90 270.90 FIRST CHECK APPLICANT SCREENIN 3365 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 270.90 270.90 ** 1,300.00 Budgeted 1,029.10 Remaining 21 % 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 1977 07/24/2017 July A/P Water study 37,358.07 647.37 38,005.44 CP&Y/WALLACE GROUP, INC. 3315 AP _______________ Account: 135-55005-010-000 Engineering Totals: 647.37 38,005.44 ** 60,000.00 Budgeted 21,994.56 Remaining 63 % Used Account: 135-55080-010-000 Maintenance & Repairs 1977 07/24/2017 July A/P cylinder refills 67,693.79 270.92 67,964.71 ALLIED WELDING SUPPLY, INC 3312 AP 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ONLINECOMPONENTS.COM (270.04) 67,694.67 ONLINECOMPONENTS.COM PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 FASTENAL COMPANY01 38.84 67,733.51 FASTENAL COMPANY01 PC 2053 07/31/2017 July A/P Meter testing 75.00 67,808.51 ATLAS UTILITY SUPPLY CO. 3352 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 114.72 67,808.51 ** 128,500.00 Budgeted 60,691.49 Remaining 53 % Used Account: 135-55085-010-000 Generator Maint. and Repair . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1937 07/13/2017 July A/P Water ant generator 1,350.00 1,109.00 2,459.00 Sluder Emergency Power Service 3335 AP _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: 1,109.00 2,459.00 ** 3,000.00 Budgeted 541.00 Remaining 82 % Used Account: 135-55090-010-000 Vehicle Maintenance 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 GIERISCH CARE 0050292 1,419.50 218.69 1,638.19 GIERISCH CARE 0050292 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 FASTENAL COMPANY01 42.04 1,680.23 FASTENAL COMPANY01 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 FASTENAL COMPANY01 (42.04) 1,638.19 FASTENAL COMPANY01 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ROANOKE AUTO SUPPLY LT 2.69 1,640.88 ROANOKE AUTO SUPPLY LT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 GIERISCH CARE 0050292 171.50 1,812.38 GIERISCH CARE 0050292 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ROANOKE AUTO SUPPLY LT 51.94 1,864.32 ROANOKE AUTO SUPPLY LT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AUTOZONE #4206 193.48 2,057.80 AUTOZONE #4206 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 638.30 2,057.80 ** 8,000.00 Budgeted 5,942.20 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 1977 07/24/2017 July A/P water samples 2,790.56 270.00 3,060.56 TARRANT CTY PUBLIC HEALTH LAB 3337 AP 2111 07/31/2017 July A/P Water samples 280.00 3,340.56 TARRANT CTY PUBLIC HEALTH LAB 3403 AP 2111 07/31/2017 July A/P Lab analysis-MUD 207.70 3,548.26 LOWER COLORADO RIVER AUTHORITY 3399 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 757.70 3,548.26 ** 5,500.00 Budgeted 1,951.74 Remaining 65 % Used Account: 135-60010-010-000 Communications/Mobiles 1978 07/24/2017 July A/P Cell Phones 2,813.09 346.99 3,160.08 VERIZON WIRELESS 3342 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.99 3,160.08 ** 5,400.00 Budgeted 2,239.92 Remaining 59 % Used Account: 135-60020-010-000 Electricity . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1937 07/13/2017 July A/P Electricity 6/8-7/11 106,101.77 169.09 106,270.86 HUDSON ENERGY SERVICES, LLC 3319 AP 1977 07/24/2017 July A/P Electricity 6/9/17-7/12/17 1,909.44 108,180.30 HUDSON ENERGY SERVICES, LLC 3319 AP 1978 07/24/2017 July A/P Electricity 6/9-7/12/17 15,025.89 123,206.19 HUDSON ENERGY SERVICES, LLC 3319 AP _______________ Account: 135-60020-010-000 Electricity Totals: 17,104.42 123,206.19 ** 172,737.00 Budgeted 49,530.81 Remaining 71 % 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 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 SUNCOAST LEARNING SYST 590.00 235.00 825.00 SUNCOAST LEARNING SYST PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 235.00 825.00 ** 4,222.00 Budgeted 3,397.00 Remaining 20 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-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 21,940.45 .00 21,940.45 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 21,940.45 ** 50,176.00 Budgeted 28,235.55 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 2053 07/31/2017 July A/P Wholesale water 1,273,167.70 199,195.80 1,472,363.50 CITY OF FORT WORTH 3357 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 199,195.80 1,472,363.50 ** 2,998,802.00 Budgeted 1,526,438.50 Remaining 49 % 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 _______________ 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 2053 07/31/2017 July A/P Mowing-May 3,750.00 1,500.00 5,250.00 WATTS ELLISON LLC 3392 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 5,250.00 ** 14,750.00 Budgeted 9,500.00 Remaining 36 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 2084 07/31/2017 Texpool Transfers 197,035.89 21,892.88 218,928.77 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 218,928.77 ** 297,011.00 Budgeted 78,082.23 Remaining 74 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 2084 07/31/2017 Texpool Transfers 118,022.45 4,083.00 122,105.45 GL 2121 07/31/2017 Recode W & WW Bond Reserve (82,224.00) 39,881.45 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: (78,141.00) 39,881.45 ** 64,920.00 Budgeted 25,038.55 Remaining 61 % 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 2092 07/31/2017 July A/P Fuel 6,291.55 674.69 6,966.24 US Bank Voyager Fleet Systems 3404 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 674.69 6,966.24 ** 24,828.00 Budgeted 17,861.76 Remaining 28 % Used Account: 135-65010-010-000 Uniforms 1977 07/24/2017 July A/P uniforms 1,800.56 983.37 2,783.93 RON MONTGOMERY & ASSOC INC 3334 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 983.37 2,783.93 ** 4,608.00 Budgeted 1,824.07 Remaining 60 % Used Account: 135-65030-010-000 Chemicals 2053 07/31/2017 July A/P chemicals 11,295.83 52.74 11,348.57 HACH COMPANY 3372 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2053 07/31/2017 July A/P Chemicals-chlorine 11,295.83 741.59 12,090.16 DPC INDUSTRIES, INC 3361 AP 2111 07/31/2017 July A/P Test-n-tube 82.55 12,172.71 HACH COMPANY 3397 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 876.88 12,172.71 ** 20,000.00 Budgeted 7,827.29 Remaining 61 % 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 .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 2053 07/31/2017 July A/P meters 17,069.88 6,930.00 23,999.88 ATLAS UTILITY SUPPLY CO. 3352 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 6,930.00 23,999.88 ** 31,500.00 Budgeted 7,500.12 Remaining 76 % Used Account: 135-65053-010-000 Meter Change Out Program 2053 07/31/2017 July A/P Meter profile heads 48,264.00 22,896.00 71,160.00 ATLAS UTILITY SUPPLY CO. 3352 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 22,896.00 71,160.00 ** 81,500.00 Budgeted 10,340.00 Remaining 87 % Used Account: 135-69005-010-000 Capital Outlays 1977 07/24/2017 July A/P Replace water line at Sunset D 302,870.09 37,841.95 340,712.04 REY-MAR CONSTRUCTION 3333 AP 1977 07/24/2017 July A/P Bollard at Water plant 9,875.00 350,587.04 REY-MAR CONSTRUCTION 3333 AP 2053 07/31/2017 July A/P Tree survey 1,378.28 351,965.32 Halff Associates, INC 3371 AP 2111 07/31/2017 July A/P High Speed Booster Pump 997.50 352,962.82 CP&Y/WALLACE GROUP, INC. 3394 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 50,092.73 352,962.82 ** 690,422.00 Budgeted 337,459.18 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-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 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/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 1977 07/24/2017 July A/P PID water samples 975.40 80.00 1,055.40 TARRANT CTY PUBLIC HEALTH LAB 3337 AP 2076 07/31/2017 July A/P Water samples PID 80.00 1,135.40 TARRANT CTY PUBLIC HEALTH LAB 3386 AP 2111 07/31/2017 July A/P Water samples/PID 80.00 1,215.40 TARRANT CTY PUBLIC HEALTH LAB 3403 AP 2111 07/31/2017 July A/P Lab analysis-PID 207.70 1,423.10 LOWER COLORADO RIVER AUTHORITY 3399 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 447.70 1,423.10 ** 5,000.00 Budgeted 3,576.90 Remaining 28 % 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: ----------------------------------- 2,944,191.29 ** 272,938.33 Monthly Total 5,524,781.00 Budgeted 2,580,589.71 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1915 07/14/2017 MUD PR 07.14.17 Salaries & Wages 282,491.77 14,989.04 297,480.81 PR 1985 07/28/2017 PR 07.28.17 Salaries & Wages 14,992.78 312,473.59 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 29,981.82 312,473.59 ** 391,102.00 Budgeted 78,628.41 Remaining 80 % Used Account: 135-50010-020-000 Overtime 1915 07/14/2017 MUD PR 07.14.17 Overtime 24,432.29 1,578.65 26,010.94 PR 1985 07/28/2017 PR 07.28.17 Overtime 867.88 26,878.82 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,446.53 26,878.82 ** 29,500.00 Budgeted 2,621.18 Remaining 91 % 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 1985 07/28/2017 PR 07.28.17 Certification 6,175.00 700.00 6,875.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 6,875.00 ** 7,800.00 Budgeted 925.00 Remaining 88 % Used Account: 135-50020-020-000 Retirement 1915 07/14/2017 MUD PR 07.14.17 Retirement 29,025.05 1,532.50 30,557.55 PR 1985 07/28/2017 PR 07.28.17 Retirement 1,531.86 32,089.41 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,064.36 32,089.41 ** 39,584.00 Budgeted 7,494.59 Remaining 81 % Used Account: 135-50026-020-000 Medical Insurance 1915 07/14/2017 MUD PR 07.14.17 Medical Insurance 41,004.91 2,355.10 43,360.01 PR 1985 07/28/2017 PR 07.28.17 Medical Insurance 2,355.10 45,715.11 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 45,715.11 ** 73,022.00 Budgeted 27,306.89 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1915 07/14/2017 MUD PR 07.14.17 Dental Insurance 3,266.36 199.69 3,466.05 PR 1985 07/28/2017 PR 07.28.17 Dental Insurance 199.63 3,665.68 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 3,665.68 ** 4,592.00 Budgeted 926.32 Remaining 80 % Used Account: 135-50028-020-000 Vision Insurance 1915 07/14/2017 MUD PR 07.14.17 Vision Insurance 701.25 42.19 743.44 PR 1985 07/28/2017 PR 07.28.17 Vision Insurance 42.14 785.58 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 785.58 ** 1,031.00 Budgeted 245.42 Remaining 76 % Used Account: 135-50029-020-000 Life Insurance & Other 1781 07/01/2017 July A/P July-Dental, vision & other in 3,375.80 361.15 3,736.95 METLIFE GROUP BENEFITS 3257 AP 2053 07/31/2017 July A/P Café 125 adm fee 29.13 3,766.08 BenefitMall 3353 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 390.28 3,766.08 ** 4,485.00 Budgeted 718.92 Remaining 84 % Used Account: 135-50030-020-000 Social Security Taxes 1915 07/14/2017 MUD PR 07.14.17 Social Security Taxes 18,640.77 981.57 19,622.34 PR 1985 07/28/2017 PR 07.28.17 Social Security Taxes 950.86 20,573.20 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,932.43 20,573.20 ** 27,886.00 Budgeted 7,312.80 Remaining 74 % Used Account: 135-50035-020-000 Medicare Taxes 1915 07/14/2017 MUD PR 07.14.17 Medicare Taxes 4,359.52 229.56 4,589.08 PR 1985 07/28/2017 PR 07.28.17 Medicare Taxes 222.39 4,811.47 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 451.95 4,811.47 ** 6,522.00 Budgeted 1,710.53 Remaining 74 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 469 07/01/2017 Insurance/Wrk Comp Exp Jul 12,122.75 926.75 13,049.50 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 13,049.50 ** 11,347.00 Budgeted (1,702.50) Remaining 115 % 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 391.62 .00 391.62 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 391.62 ** 650.00 Budgeted 258.38 Remaining 60 % 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 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 THE HOME DEPOT #6581 89,300.15 27.88 89,328.03 THE HOME DEPOT #6581 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 THE HOME DEPOT #6581 55.84 89,383.87 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 BEST BUY 00001487 89,300.15 79.99 89,463.86 BEST BUY 00001487 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 THE HOME DEPOT #6581 23.02 89,486.88 THE HOME DEPOT #6581 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WALKER ENGINEERING INC 489.38 89,976.26 WALKER ENGINEERING INC PC 2053 07/31/2017 July A/P Field service for belt press 1,192.00 91,168.26 SMITH PUMP COMPANY, INC. 3385 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,868.11 91,168.26 ** 79,700.00 Budgeted (11,468.26) Remaining 114 % Used Account: 135-55085-020-000 Generator Maint. and Repair 1977 07/24/2017 July A/P ATS LS #1 1,566.00 4,510.00 6,076.00 Sluder Emergency Power Service 3335 AP _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: 4,510.00 6,076.00 ** 20,000.00 Budgeted 13,924.00 Remaining 30 % Used Account: 135-55090-020-000 Vehicle Maintenance 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AUTOZONE #4206 7,585.44 14.98 7,600.42 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 14.98 7,600.42 ** 6,600.00 Budgeted (1,000.42) Remaining 115 % 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 1977 07/24/2017 July A/P Sludge haul off 41,135.74 285.00 41,420.74 L.H. CHANEY MATERIALS, INC. 3323 AP 1977 07/24/2017 July A/P Sludge haul off 3,419.72 44,840.46 L.H. CHANEY MATERIALS, INC. 3323 AP 2111 07/31/2017 July A/P Sludge Haul off 2,550.63 47,391.09 L.H. CHANEY MATERIALS, INC. 3398 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 6,255.35 47,391.09 ** 55,000.00 Budgeted 7,608.91 Remaining 86 % Used Account: 135-55135-020-000 Lab Analysis 1937 07/13/2017 July A/P Testing 21,373.50 246.00 21,619.50 OXIDOR LABORATORIES LLC 3331 AP 1937 07/13/2017 July A/P Testing 176.00 21,795.50 OXIDOR LABORATORIES LLC 3331 AP 1977 07/24/2017 July A/P lab supplies 246.00 22,041.50 OXIDOR LABORATORIES LLC 3331 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1977 07/24/2017 July A/P lab supplies 21,373.50 226.00 22,267.50 OXIDOR LABORATORIES LLC 3331 AP 1977 07/24/2017 July A/P lab supplies 226.00 22,493.50 OXIDOR LABORATORIES LLC 3331 AP 1977 07/24/2017 July A/P lab supplies 176.00 22,669.50 OXIDOR LABORATORIES LLC 3331 AP 2053 07/31/2017 July A/P lab supplies 1,357.50 24,027.00 OXIDOR LABORATORIES LLC 3383 AP 2053 07/31/2017 July A/P Lab supplies 246.00 24,273.00 OXIDOR LABORATORIES LLC 3383 AP 2053 07/31/2017 July A/P lab supplies 176.00 24,449.00 OXIDOR LABORATORIES LLC 3383 AP 2053 07/31/2017 July A/P Lab supplies 246.00 24,695.00 OXIDOR LABORATORIES LLC 3383 AP 2053 07/31/2017 July A/P Lab supplies 1,719.07 26,414.07 IDEXX DISTRIBUTION, INC 3373 AP 2053 07/31/2017 July A/P lab spplies 188.49 26,602.56 IDEXX DISTRIBUTION, INC 3373 AP 2111 07/31/2017 July A/P Testing 176.00 26,778.56 OXIDOR LABORATORIES LLC 3401 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 5,405.06 26,778.56 ** 25,000.00 Budgeted (1,778.56) Remaining 107 % Used Account: 135-60010-020-000 Communications/Mobiles 1978 07/24/2017 July A/P Cell Phones 3,668.09 412.00 4,080.09 VERIZON WIRELESS 3342 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 412.00 4,080.09 ** 5,400.00 Budgeted 1,319.91 Remaining 76 % Used Account: 135-60020-020-000 Electricity 1937 07/13/2017 July A/P Electricity 6/8-7/11 103,171.19 33.34 103,204.53 HUDSON ENERGY SERVICES, LLC 3319 AP 1937 07/13/2017 July A/P Electricity 6/8-7/11 83.51 103,288.04 HUDSON ENERGY SERVICES, LLC 3319 AP 1937 07/13/2017 July A/P Electricity 5/24-6/26 240.66 103,528.70 TRI COUNTY ELECTRIC 3340 AP 1937 07/13/2017 July A/P Electricity 5/24-6/26 450.35 103,979.05 TRI COUNTY ELECTRIC 3340 AP 1937 07/13/2017 July A/P Electricity 5/24-6/26 28.23 104,007.28 TRI COUNTY ELECTRIC 3340 AP 1977 07/24/2017 July A/P Electricity 6/9-7/12 115.67 104,122.95 HUDSON ENERGY SERVICES, LLC 3319 AP 1977 07/24/2017 July A/P Electricity 6/9-7/12/17 326.23 104,449.18 MP2 ENERGY TEXAS LLC 3328 AP 1978 07/24/2017 July A/P Electricity 6/9-7/12/17 4,338.42 108,787.60 ENGIE Resources LLC 3316 AP 1978 07/24/2017 July A/P Electricity 6/9-7/12/17 416.98 109,204.58 HUDSON ENERGY SERVICES, LLC 3319 AP 1978 07/24/2017 July A/P Electricity 6/9-7/11/17 8,237.18 117,441.76 HUDSON ENERGY SERVICES, LLC 3319 AP 2113 07/31/2017 Town Billed Inv 1580-1584 AR 20170731-20170731 User: (214.31) 117,227.45 AR _______________ Account: 135-60020-020-000 Electricity Totals: 14,056.26 117,227.45 ** 158,627.00 Budgeted 41,399.55 Remaining 74 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 143.85 .00 143.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-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 1977 07/24/2017 July A/P Tolls for lab samples 2,286.73 33.21 2,319.94 NTTA 3329 AP 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 NO FRILLS GRILL & 14.98 2,334.92 NO FRILLS GRILL & PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 NO FRILLS GRILL & 19.33 2,354.25 NO FRILLS GRILL & PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 NO FRILLS GRILL & 19.48 2,373.73 NO FRILLS GRILL & PC 2053 07/31/2017 July A/P Tolls for lab samples 4.57 2,378.30 NTTA 3380 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 91.57 2,378.30 ** 2,400.00 Budgeted 21.70 Remaining 99 % 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 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-60135-020-000 TCEQ Fees & Permits 2111 07/31/2017 July A/P Notice of Public Hearing/SOAH 15,151.97 1,198.91 16,350.88 Star-Telegram Media 3402 AP 2111 07/31/2017 July A/P WWTP Permit Renewal Applicatio 1,997.50 18,348.38 CP&Y/WALLACE GROUP, INC. 3394 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 3,196.41 18,348.38 ** 17,150.00 Budgeted (1,198.38) Remaining 107 % Used Account: 135-60245-020-000 Miscellaneous Expenses 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WAL-MART #5247 74.40 74.40 WAL-MART #5247 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WM SUPERCENTER #5247 25.29 99.69 WM SUPERCENTER #5247 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 OFFICE DEPOT #406 13.58 113.27 OFFICE DEPOT #406 PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 113.27 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 2053 07/31/2017 July A/P Mowing-May 2,950.00 1,180.00 4,130.00 WATTS ELLISON LLC 3392 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 4,130.00 ** 11,600.00 Budgeted 7,470.00 Remaining 36 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 2084 07/31/2017 Texpool Transfers 98,584.38 10,953.82 109,538.20 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 109,538.20 ** 120,492.00 Budgeted 10,953.80 Remaining 91 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 2084 07/31/2017 Texpool Transfers 487,340.19 54,148.91 541,489.10 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 541,489.10 ** 595,638.00 Budgeted 54,148.90 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-60333-020-000 Interfund Transfer Out-Reserve 2084 07/31/2017 Texpool Transfers 67,359.25 10,278.00 77,637.25 GL 2121 07/31/2017 Recode W & WW Bond Reserve 82,224.00 159,861.25 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 92,502.00 159,861.25 ** 123,492.00 Budgeted (36,369.25) Remaining 129 % 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 2092 07/31/2017 July A/P Fuel 6,445.06 540.18 6,985.24 US Bank Voyager Fleet Systems 3404 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 540.18 6,985.24 ** 28,088.00 Budgeted 21,102.76 Remaining 25 % 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 1977 07/24/2017 July A/P clarifloc 17,906.95 2,760.00 20,666.95 POLYDYNE, INC 3332 AP 2111 07/31/2017 July A/P Degreaser, solvent 2,581.00 23,247.95 MICKEY D CARSON DBA/NUSCO 3400 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 5,341.00 23,247.95 ** 21,000.00 Budgeted (2,247.95) Remaining 111 % Used Account: 135-65035-020-000 Small Tools 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 THE HOME DEPOT #6581 1,405.54 11.29 1,416.83 THE HOME DEPOT #6581 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 THE HOME DEPOT #6581 53.89 1,470.72 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 65.18 1,470.72 ** 2,000.00 Budgeted 529.28 Remaining 74 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-65040-020-000 Safety Equipment 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 RANDALLS STORE00017897 354.53 10.96 365.49 RANDALLS STORE00017897 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 BOOT BARN #150 151.54 517.03 BOOT BARN #150 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 162.50 517.03 ** 750.00 Budgeted 232.97 Remaining 69 % Used Account: 135-65045-020-000 Lab Supplies 12,806.95 .00 12,806.95 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 12,806.95 ** 14,000.00 Budgeted 1,193.05 Remaining 91 % 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: ----------------------------------- 1,891,190.26 ** 245,904.57 Monthly Total 2,671,032.00 Budgeted 779,841.74 Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 469 07/01/2017 Insurance/Wrk Comp Exp Jul 22.49 2.61 25.10 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 25.10 ** 32.00 Budgeted 6.90 Remaining 78 % 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 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 JASON DELI #RTX #2 145.45 145.45 JASON DELI #RTX #2 PC _______________ Account: 135-60075-026-000 Meetings Totals: 145.45 145.45 ** 1,200.00 Budgeted 1,054.55 Remaining 12 % Used Account: 135-60080-026-000 Schools & Training 3,287.35 .00 3,287.35 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 3,287.35 ** 4,000.00 Budgeted 712.65 Remaining 82 % 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 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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: ----------------------------------- 5,904.85 ** 148.06 Monthly Total 12,882.00 Budgeted 6,977.15 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1915 07/14/2017 MUD PR 07.14.17 Salaries & Wages 319,474.15 15,880.24 335,354.39 PR 1985 07/28/2017 PR 07.28.17 Salaries & Wages 16,353.12 351,707.51 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 32,233.36 351,707.51 ** 519,883.00 Budgeted 168,175.49 Remaining 68 % Used Account: 135-50010-030-000 Overtime 1915 07/14/2017 MUD PR 07.14.17 Overtime 3,291.84 17.11 3,308.95 PR 1985 07/28/2017 PR 07.28.17 Overtime 27.62 3,336.57 PR _______________ Account: 135-50010-030-000 Overtime Totals: 44.73 3,336.57 ** 2,500.00 Budgeted (836.57) Remaining 133 % 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 1915 07/14/2017 MUD PR 07.14.17 Retirement 29,475.81 1,470.52 30,946.33 PR 1985 07/28/2017 PR 07.28.17 Retirement 1,515.20 32,461.53 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,985.72 32,461.53 ** 47,768.00 Budgeted 15,306.47 Remaining 68 % Used Account: 135-50026-030-000 Medical Insurance 1915 07/14/2017 MUD PR 07.14.17 Medical Insurance 34,155.22 1,911.02 36,066.24 PR 1985 07/28/2017 PR 07.28.17 Medical Insurance 1,911.03 37,977.27 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,822.05 37,977.27 ** 84,289.00 Budgeted 46,311.73 Remaining 45 % Used Account: 135-50027-030-000 Dental Insurance 1915 07/14/2017 MUD PR 07.14.17 Dental Insurance 3,003.40 174.48 3,177.88 PR 1985 07/28/2017 PR 07.28.17 Dental Insurance 174.42 3,352.30 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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: 348.90 3,352.30 ** 5,981.00 Budgeted 2,628.70 Remaining 56 % Used Account: 135-50028-030-000 Vision Insurance 1915 07/14/2017 MUD PR 07.14.17 Vision Insurance 641.93 37.94 679.87 PR 1985 07/28/2017 PR 07.28.17 Vision Insurance 37.88 717.75 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 75.82 717.75 ** 1,312.00 Budgeted 594.25 Remaining 55 % Used Account: 135-50029-030-000 Life Insurance & Other 1781 07/01/2017 July A/P July-Dental, vision & other in 3,325.93 431.14 3,757.07 METLIFE GROUP BENEFITS 3257 AP 2053 07/31/2017 July A/P Café 125 adm fee 29.16 3,786.23 BenefitMall 3353 AP 2078 07/31/2017 July A/P Rounding adjustment (.02) 3,786.21 Legal Shield 3376 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 460.28 3,786.21 ** 5,890.00 Budgeted 2,103.79 Remaining 64 % Used Account: 135-50030-030-000 Social Security Taxes 1915 07/14/2017 MUD PR 07.14.17 Social Security Taxes 19,242.57 948.54 20,191.11 PR 1985 07/28/2017 PR 07.28.17 Social Security Taxes 966.06 21,157.17 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,914.60 21,157.17 ** 32,777.00 Budgeted 11,619.83 Remaining 65 % Used Account: 135-50035-030-000 Medicare Taxes 1915 07/14/2017 MUD PR 07.14.17 Medicare Taxes 4,500.28 221.83 4,722.11 PR 1985 07/28/2017 PR 07.28.17 Medicare Taxes 225.92 4,948.03 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 447.75 4,948.03 ** 8,084.00 Budgeted 3,135.97 Remaining 61 % 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 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 469 07/01/2017 Insurance/Wrk Comp Exp Jul 1,359.77 145.53 1,505.30 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,505.30 ** 1,784.00 Budgeted 278.70 Remaining 84 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 2076 07/31/2017 July A/P pre employment screening 402.35 166.45 568.80 FIRST CHECK APPLICANT SCREENIN 3365 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 166.45 568.80 ** 500.00 Budgeted (68.80) Remaining 114 % Used Account: 135-50070-030-000 Employee Relations 2,605.40 .00 2,605.40 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,605.40 ** 4,960.00 Budgeted 2,354.60 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 1977 07/24/2017 July A/P software support 80,070.08 154.00 80,224.08 STW INC 3336 AP 1977 07/24/2017 July A/P email license 168.00 80,392.08 M3 Networks 3324 AP 1978 07/24/2017 July A/P Internet 1,036.77 81,428.85 WHOLESALE CARRIER SERVICES INC 3343 AP 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ATT*BILL PAYMENT 212.16 81,641.01 ATT*BILL PAYMENT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ATT*BILL PAYMENT 244.80 81,885.81 ATT*BILL PAYMENT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AT&T *PAYMENT 308.40 82,194.21 AT&T *PAYMENT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AT&T *PAYMENT 135.88 82,330.09 AT&T *PAYMENT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ADOBE *IL CREATIVE CLD 19.99 82,350.08 ADOBE *IL CREATIVE CLD PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 DNH*GODADDY.COM 35.34 82,385.42 DNH*GODADDY.COM PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,315.34 82,385.42 ** 77,791.00 Budgeted (4,594.42) Remaining 106 % Used Account: 135-55070-030-000 Independent Labor 2053 07/31/2017 July A/P Video mud meeting 1,210.00 60.00 1,270.00 MIGUEL CRUZ 3378 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 60.00 1,270.00 ** 4,000.00 Budgeted 2,730.00 Remaining 32 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1937 07/13/2017 July A/P Rug service 5,971.76 66.47 6,038.23 G & K SERVICES 3318 AP 1977 07/24/2017 July A/P rug service 66.47 6,104.70 G & K SERVICES 3318 AP 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AMAZON MKTPLACE PMTS 429.31 6,534.01 AMAZON MKTPLACE PMTS PC 2053 07/31/2017 July A/P Rug service 66.47 6,600.48 G & K SERVICES 3368 AP 2113 07/31/2017 Town Billed Inv 1580-1584 AR 20170731-20170731 User: (99.70) 6,500.78 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 529.02 6,500.78 ** 7,000.00 Budgeted 499.22 Remaining 93 % Used Account: 135-55120-030-000 Cleaning Services 1977 07/24/2017 July A/P janitorial servicesa 4,805.48 869.06 5,674.54 MEMBER'S BUILDING MAINTENANCE 3326 AP 2113 07/31/2017 Town Billed Inv 1580-1584 AR 20170731-20170731 User: (236.00) 5,438.54 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 5,438.54 ** 8,000.00 Budgeted 2,561.46 Remaining 68 % Used Account: 135-55160-030-000 Professional Outside Services 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 60,000.00 Budgeted 2,668.00 Remaining 96 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-55205-030-000 Utility Billing Contract 2111 07/31/2017 July A/P July Utility billing 5,618.14 669.44 6,287.58 DATAPROSE LLC 3395 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 669.44 6,287.58 ** 8,200.00 Budgeted 1,912.42 Remaining 77 % Used Account: 135-60005-030-000 Telephone 1977 07/24/2017 July A/P answering service 9,041.86 194.75 9,236.61 KEYSTONE PARK SECRETARIAL 3322 AP 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ATT*BUS PHONE PMT 444.67 9,681.28 ATT*BUS PHONE PMT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 RINGCENTRAL, INC 13.94 9,695.22 RINGCENTRAL, INC PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ATT*BUS PHONE PMT 845.75 10,540.97 ATT*BUS PHONE PMT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ATT* BILL PAYMENT 444.67 10,985.64 ATT* BILL PAYMENT PC _______________ Account: 135-60005-030-000 Telephone Totals: 1,943.78 10,985.64 ** 17,532.00 Budgeted 6,546.36 Remaining 63 % Used Account: 135-60010-030-000 Communications/Mobiles 1978 07/24/2017 July A/P Cell Phones 2,478.92 37.99 2,516.91 VERIZON WIRELESS 3342 AP 1985 07/28/2017 PR 07.28.17 Communications/Mobiles 225.00 2,741.91 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 262.99 2,741.91 ** 3,500.00 Budgeted 758.09 Remaining 78 % Used Account: 135-60020-030-000 Electricity/Gas 7,189.04 .00 7,189.04 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 7,189.04 ** 12,631.00 Budgeted 5,441.96 Remaining 57 % Used Account: 135-60025-030-000 Water 1977 07/24/2017 July A/P Water 5/24-6/27-27 712.50 131.28 843.78 TROPHY CLUB MUD (WATER BILLS) 3341 AP 2053 07/31/2017 July A/P Water-July 131.28 975.06 TROPHY CLUB MUD (WATER BILLS) 3390 AP 2113 07/31/2017 Town Billed Inv 1580-1584 AR 20170731-20170731 User: (65.64) 909.42 AR _______________ Account: 135-60025-030-000 Water Totals: 196.92 909.42 ** 1,500.00 Budgeted 590.58 Remaining 61 % Used Account: 135-60035-030-000 Postage . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2053 07/31/2017 July A/P overnight letters 22,341.23 8.54 22,349.77 FEDERAL EXPRESS CORP 3364 AP 2053 07/31/2017 July A/P Postage machine rental 93.00 22,442.77 FRANCOTYP-POSTALIA, INC. 3367 AP 2111 07/31/2017 July A/P July Utility billing 1,599.22 24,041.99 DATAPROSE LLC 3395 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,700.76 24,041.99 ** 28,932.00 Budgeted 4,890.01 Remaining 83 % Used Account: 135-60040-030-000 Service Charges & Fees 2107 07/03/2017 Credit card fees 37,620.30 4,684.29 42,304.59 GL 2107 07/03/2017 Credit card fees 136.97 42,441.56 GL 1916 07/14/2017 Child Support Fee 1.50 42,443.06 GL 1989 07/28/2017 Child Support Fee 1.50 42,444.56 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,824.26 42,444.56 ** 55,560.00 Budgeted 13,115.44 Remaining 76 % 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 469 07/01/2017 Insurance/Wrk Comp Exp Jul 41,873.24 4,664.56 46,537.80 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 46,537.80 ** 55,692.00 Budgeted 9,154.20 Remaining 84 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 331.88 .00 331.88 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 331.88 ** 1,600.00 Budgeted 1,268.12 Remaining 21 % Used Account: 135-60070-030-000 Dues & Memberships 4,661.25 .00 4,661.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,661.25 ** 6,000.00 Budgeted 1,338.75 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60075-030-000 Meetings 105.71 .00 105.71 _______________ Account: 135-60075-030-000 Meetings Totals: .00 105.71 ** 400.00 Budgeted 294.29 Remaining 26 % 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 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 GOVERNMENT FINANCE 1,675.00 160.00 1,835.00 GOVERNMENT FINANCE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 160.00 1,835.00 ** 7,840.00 Budgeted 6,005.00 Remaining 23 % Used Account: 135-60100-030-000 Travel & per diem 1915 07/14/2017 MUD PR 07.14.17 Travel & per diem 6,955.11 26.14 6,981.25 PR 1985 07/28/2017 PR 07.28.17 Travel & per diem 30.08 7,011.33 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 56.22 7,011.33 ** 7,500.00 Budgeted 488.67 Remaining 93 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 2,925.33 .00 2,925.33 _______________ Account: 135-60115-030-000 Elections Totals: .00 2,925.33 ** 7,500.00 Budgeted 4,574.67 Remaining 39 % Used Account: 135-60125-030-000 Advertising . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AMAZON MKTPLACE PMTS 76.00 84.96 160.96 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 84.96 160.96 ** 17,500.00 Budgeted 17,339.04 Remaining 1 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WAL-MART #5247 1,040.00 15.94 1,055.94 WAL-MART #5247 PC _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 15.94 1,055.94 ** 2,500.00 Budgeted 1,444.06 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 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 1937 07/13/2017 July A/P Office supplies 4,394.86 86.52 4,481.38 OFFICE DEPOT, INC 3330 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 OFFICE DEPOT #406 4,394.86 46.42 4,527.80 OFFICE DEPOT #406 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 KELLER TROPHY AND AWAR 20.00 4,547.80 KELLER TROPHY AND AWAR PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 ZAPCO INC 87.31 4,635.11 ZAPCO INC PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WM SUPERCENTER #5247 5.94 4,641.05 WM SUPERCENTER #5247 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 STAPLES 00116533 73.03 4,714.08 STAPLES 00116533 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 DESKTOP SUPPLIES.COM 58.66 4,772.74 DESKTOP SUPPLIES.COM PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WAL-MART #5247 3.97 4,776.71 WAL-MART #5247 PC 2053 07/31/2017 July A/P office supplies 82.50 4,859.21 OFFICE DEPOT, INC 3382 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 464.35 4,859.21 ** 9,000.00 Budgeted 4,140.79 Remaining 54 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 SHI GOVERNMENT SOLUTIO 478.78 189.60 668.38 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 189.60 668.38 ** 2,000.00 Budgeted 1,331.62 Remaining 33 % Used Account: 135-65095-030-000 Maintenance Supplies 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WM SUPERCENTER #5247 2,898.07 15.78 2,913.85 WM SUPERCENTER #5247 PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AMAZON MKTPLACE PMTS 49.04 2,962.89 AMAZON MKTPLACE PMTS PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 SAMSCLUB.COM 98.34 3,061.23 SAMSCLUB.COM PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AMAZON MKTPLACE PMTS 103.59 3,164.82 AMAZON MKTPLACE PMTS PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 AMAZON MKTPLACE PMTS 15.18 3,180.00 AMAZON MKTPLACE PMTS PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 WAL-MART #5247 3.98 3,183.98 WAL-MART #5247 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 285.91 3,183.98 ** 4,000.00 Budgeted 816.02 Remaining 80 % Used Account: 135-65105-030-000 Printing 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 CARBONLESS FORMS PRINT 2,330.88 111.50 2,442.38 CARBONLESS FORMS PRINT PC 2046 07/26/2017 Pcard 06/27/17 - 07/26/17 CARBONLESS FORMS PRINT 111.50 2,553.88 CARBONLESS FORMS PRINT PC _______________ Account: 135-65105-030-000 Printing Totals: 223.00 2,553.88 ** 2,500.00 Budgeted (53.88) Remaining 102 % Used Account: 135-69005-030-000 Capital Outlays 109,881.15 .00 109,881.15 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-69005-030-000 Capital Outlays Totals: .00 109,881.15 ** 265,424.00 Budgeted 155,542.85 Remaining 41 % Used Account: 135-69170-030-000 Copier Lease Installments 1937 07/13/2017 July A/P Copier Lease 2,837.55 165.00 3,002.55 EVERBANK COMMERCIAL FINANCE 3317 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 165.00 3,002.55 ** 4,600.00 Budgeted 1,597.45 Remaining 65 % Used Department 30 Totals: ----------------------------------- 915,087.15 ** 62,090.30 Monthly Total 1,443,018.00 Budgeted 527,930.85 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 1977 07/24/2017 July A/P legal 53,390.79 11,520.00 64,910.79 McLean & Howard, L.L.P. 3325 AP 1977 07/24/2017 July A/P legal 270.00 65,180.79 McLean & Howard, L.L.P. 3325 AP _______________ Account: 135-55045-039-000 Legal Totals: 11,790.00 65,180.79 ** 150,000.00 Budgeted 84,819.21 Remaining 43 % 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 Department 39 Totals: ----------------------------------- 95,218.92 ** 11,790.00 Monthly Total 188,775.00 Budgeted 93,556.08 Remaining 50 % Used Fund 135 Totals: ----------------------------------- (949,191.34) (289,047.37) Monthly Total .00 Budgeted 949,191.34 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JULY 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,865,892 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,865,892 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 819,495 TOTAL LIABILITIES 819,495 FUND BALANCE ASSIGNED FUND BALANCE 4,433,035 NET REVENUES / EXPENDITURES (2,386,638) TOTAL FUND BALANCE 2,046,397 TOTAL LIABILITIES AND FUND BALANCE 2,865,892 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 18:32 08/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,362.45- 18,072.48- 18,072.48 Subtotal: 2,362.45- 18,072.48- 18,072.48 Program number: 2,362.45- 18,072.48- 18,072.48 Department number: Revenues 2,362.45- 18,072.48- 18,072.48 Revenues Subtotal ----------- 2,362.45- 18,072.48- 18,072.48 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 18:32 08/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 78,612.16 2,404,710.67 2,404,710.67- Subtotal: 78,612.16 2,404,710.67 2,404,710.67- Program number: 78,612.16 2,404,710.67 2,404,710.67- Department number: Wastewater 78,612.16 2,404,710.67 2,404,710.67- Expenditures Subtotal ----------- 78,612.16 2,404,710.67 2,404,710.67- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 76,249.71 2,386,638.19 2,386,638.19- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/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 2095 07/31/2017 Bank Interest/July (15,710.03) (2,362.45) (18,072.48) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (2,362.45) (18,072.48) ** .00 Budgeted 18,072.48 Remaining 0 % Used Department Totals: ----------------------------------- (18,072.48) ** (2,362.45) Monthly Total .00 Budgeted 18,072.48 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/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 1977 07/24/2017 July A/P WWTP Improvements 2,326,098.51 50,033.88 2,376,132.39 CP&Y/WALLACE GROUP, INC. 3315 AP 2111 07/31/2017 July A/P WWTP Improvements 28,578.28 2,404,710.67 CP&Y/WALLACE GROUP, INC. 3394 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 78,612.16 2,404,710.67 ** .00 Budgeted (2,404,710.67) Remaining 0 % Used Department 20 Totals: ----------------------------------- 2,404,710.67 ** 78,612.16 Monthly Total .00 Budgeted (2,404,710.67) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 2,386,638.19 76,249.71 Monthly Total .00 Budgeted (2,386,638.19) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JULY 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 543 TOTAL LIABILITIES 543 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES (543) TOTAL FUND BALANCE (543) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 18:32 08/10/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-020-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- Program number: 542.95 542.95- Department number: Wastewater 542.95 542.95- Expenditures Subtotal ----------- 542.95 542.95- Fund number: 519 2016 Rev Bond Const-SWIFT 542.95 542.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 7/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-020-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-020-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Department 20 Totals: ----------------------------------- 542.95 ** .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 542.95 .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 397,163 ACCOUNTS RECEIVABLE - TOTAL ASSETS 397,163 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 201,401 TOTAL FUND BALANCE 397,163 TOTAL LIABILITIES AND FUND BALANCE 397,163 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 18:32 08/10/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/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- 610.45- 1,657.92- 552.640 1,357.92 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 36,747.00- 39,881.45- 61.432 25,038.55- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 92,502.00- 159,861.25- 129.451 36,369.25 Subtotal: 188,712.00- 188,712.00- 129,859.45- 201,400.62- 106.724 12,688.62 Program number: 188,712.00- 188,712.00- 129,859.45- 201,400.62- 106.724 12,688.62 Department number: 188,712.00- 188,712.00- 129,859.45- 201,400.62- 106.724 12,688.62 Revenues Subtotal ----------- 188,712.00- 188,712.00- 129,859.45- 201,400.62- 106.724 12,688.62 Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 129,859.45- 201,400.62- 106.724 12,688.62 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/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 2071 07/31/2017 Close Reserve Fund 529 to 528 (1,047.47) (294.46) (1,341.93) GL 2095 07/31/2017 Bank Interest/July (315.99) (1,657.92) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (610.45) (1,657.92) ** (300.00) Budgeted 1,357.92 Remaining 553 % Used Account: 528-49142-000-000 Interfund transfer in-Water 2071 07/31/2017 Close Reserve Fund 529 to 528 (3,134.45) (32,664.00) (35,798.45) GL 2084 07/31/2017 Texpool Transfers (4,083.00) (39,881.45) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (36,747.00) (39,881.45) ** (64,920.00) Budgeted (25,038.55) Remaining 61 % Used Account: 528-49143-000-000 Interfund transfer in-WW 2071 07/31/2017 Close Reserve Fund 529 to 528 (67,359.25) (82,224.00) (149,583.25) GL 2084 07/31/2017 Texpool Transfers (10,278.00) (159,861.25) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (92,502.00) (159,861.25) ** (123,492.00) Budgeted 36,369.25 Remaining 129 % Used Department Totals: ----------------------------------- (201,400.62) ** (129,859.45) Monthly Total (188,712.00) Budgeted 12,688.62 Remaining 107 % Used Fund 528 Totals: ----------------------------------- (201,400.62) (129,859.45) Monthly Total (188,712.00) Budgeted 12,688.62 Remaining 107 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET JULY 2017 THIS ACCOUNT WAS CLOSED INTO FUND 528 REVENUE BOND RESERVE 7/31/17 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE - TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 18:32 08/10/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 294.46 529-49142-000-000 Interfund transfer in-Water 114,888.00 Subtotal: 115,182.46 Program number: 115,182.46 Department number: 115,182.46 Revenues Subtotal ----------- 115,182.46 Fund number: 529 2016 Rev Bond Reserve-SWIFT 115,182.46 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 7/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 2071 07/31/2017 Close Reserve Fund 529 to 528 (294.46) 294.46 .00 GL _______________ Account: 529-49010-000-000 Interest Income Totals: 294.46 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 2070 07/31/2017 Corr Coding W & WW Reserve (114,888.00) 82,224.00 (32,664.00) GL 2071 07/31/2017 Close Reserve Fund 529 to 528 32,664.00 .00 GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: 114,888.00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 529-49143-000-000 Interfund transfer in-WW 2070 07/31/2017 Corr Coding W & WW Reserve (82,224.00) (82,224.00) GL 2071 07/31/2017 Close Reserve Fund 529 to 528 82,224.00 .00 GL _______________ Account: 529-49143-000-000 Interfund transfer in-WW Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department Totals: ----------------------------------- .00 ** 115,182.46 Monthly Total .00 Budgeted .00 Remaining 0 % Used Fund 529 Totals: ----------------------------------- .00 115,182.46 Monthly Total .00 Budgeted .00 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 874,674 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,243 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 891,489 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,243 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,243 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 853,215 TOTAL FUND BALANCE 879,246 TOTAL LIABILITIES AND FUND BALANCE 891,489 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 18:32 08/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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- 2,436.57- 672,023.23- 99.805 1,312.77- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 3.80- 1,698.75- 48.522 1,802.25- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 153.30- 1,986.66- 99.333 13.34- Subtotal: 678,837.00- 678,837.00- 2,593.67- 675,708.64- 99.539 3,128.36- 533-49010-000-000 Interest Income 140.00- 140.00- 710.49- 2,955.86- 2,111.329 2,815.86 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.82- 109,538.20- 90.909 10,953.80- Subtotal: 337,386.00- 337,386.00- 11,664.31- 329,248.06- 97.588 8,137.94- Program number: 1,016,223.00- 1,016,223.00- 14,257.98- 1,004,956.70- 98.891 11,266.30- Department number: Revenues 1,016,223.00- 1,016,223.00- 14,257.98- 1,004,956.70- 98.891 11,266.30- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 14,257.98- 1,004,956.70- 98.891 11,266.30- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 18:32 08/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 150,491.25 50.066 150,091.75 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Program number: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Department number: Administration 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 14,257.98- 853,215.45- ############### 850,125.45 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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 2048 07/03/2017 Property Taxes (669,586.66) (71.31) (669,657.97) GL 2049 07/05/2017 Property Taxes 148.43 (669,509.54) GL 2050 07/06/2017 Property Taxes 24.80 (669,484.74) GL 2051 07/10/2017 Property Taxes (13.38) (669,498.12) GL 2052 07/12/2017 Property Taxes (1.30) (669,499.42) GL 2054 07/13/2017 Property Taxes (197.87) (669,697.29) GL 2055 07/14/2017 Property Taxes (104.68) (669,801.97) GL 2056 07/17/2017 Property Taxes (127.45) (669,929.42) GL 2058 07/18/2017 Property Taxes (72.10) (670,001.52) GL 2059 07/19/2017 Property Taxes (291.51) (670,293.03) GL 2066 07/20/2017 Property Taxes (162.00) (670,455.03) GL 2060 07/21/2017 Property Taxes (191.06) (670,646.09) GL 2061 07/25/2017 Property Taxes (193.26) (670,839.35) GL 2062 07/26/2017 Property Taxes (619.49) (671,458.84) GL 2063 07/27/2017 Property Taxes (262.82) (671,721.66) GL 2064 07/31/2017 Property Taxes (301.57) (672,023.23) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,436.57) (672,023.23) ** (673,336.00) Budgeted (1,312.77) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2049 07/05/2017 Property Taxes (1,694.95) (3.54) (1,698.49) GL 2050 07/06/2017 Property Taxes (.26) (1,698.75) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.80) (1,698.75) ** (3,501.00) Budgeted (1,802.25) Remaining 49 % Used Account: 533-40015-000-000 Property Taxes/P & I 2048 07/03/2017 Property Taxes (1,833.36) (8.21) (1,841.57) GL 2049 07/05/2017 Property Taxes (1.87) (1,843.44) GL 2051 07/10/2017 Property Taxes (2.06) (1,845.50) GL 2052 07/12/2017 Property Taxes 1.26 (1,844.24) GL 2054 07/13/2017 Property Taxes (35.45) (1,879.69) GL 2056 07/17/2017 Property Taxes (.11) (1,879.80) GL 2059 07/19/2017 Property Taxes (47.27) (1,927.07) GL 2060 07/21/2017 Property Taxes (.27) (1,927.34) GL 2061 07/25/2017 Property Taxes (24.71) (1,952.05) GL 2062 07/26/2017 Property Taxes (36.03) (1,988.08) GL 2063 07/27/2017 Property Taxes 3.20 (1,984.88) GL 2064 07/31/2017 Property Taxes (1.78) (1,986.66) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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-40015-000-000 Property Taxes/P & I Totals: (153.30) (1,986.66) ** (2,000.00) Budgeted (13.34) Remaining 99 % Used Account: 533-49010-000-000 Interest Income 2095 07/31/2017 Bank Interest/July (2,245.37) (710.49) (2,955.86) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (710.49) (2,955.86) ** (140.00) Budgeted 2,815.86 Remaining 2.111 % Used 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 2084 07/31/2017 Texpool Transfers (98,584.38) (10,953.82) (109,538.20) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (109,538.20) ** (120,492.00) Budgeted (10,953.80) Remaining 91 % Used Department Totals: ----------------------------------- (1,004,956.70) ** (14,257.98) Monthly Total (1,016,223.00) Budgeted (11,266.30) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 150,491.25 .00 150,491.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 150,491.25 ** 300,583.00 Budgeted 150,091.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 151,741.25 ** .00 Monthly Total 1,013,133.00 Budgeted 861,391.75 Remaining 15 % Used Fund 533 Totals: ----------------------------------- (853,215.45) (14,257.98) Monthly Total (3,090.00) Budgeted 850,125.45 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JULY 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 442,270 ACCOUNTS RECEIVABLE - TOTAL ASSETS 442,270 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 427,173 TOTAL FUND BALANCE 442,270 TOTAL LIABILITIES AND FUND BALANCE 442,270 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 18:32 08/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/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- 321.40- 1,202.79- 601.395 1,002.79 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.91- 541,489.10- 90.909 54,148.90- Subtotal: 892,849.00- 892,849.00- 54,470.31- 542,691.89- 60.782 350,157.11- Program number: 892,849.00- 892,849.00- 54,470.31- 542,691.89- 60.782 350,157.11- Department number: Revenues 892,849.00- 892,849.00- 54,470.31- 542,691.89- 60.782 350,157.11- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,470.31- 542,691.89- 60.782 350,157.11- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 18:32 08/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/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 200.00 200.00- 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 200.00- 115,318.75 29.748 272,330.25 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Program number: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Department number: Administration 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Expenditures Subtotal ----------- 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 54,470.31- 427,173.14- ############### 426,973.14 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/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 2095 07/31/2017 Bank Interest/July (881.39) (321.40) (1,202.79) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (321.40) (1,202.79) ** (200.00) Budgeted 1,002.79 Remaining 601 % 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 2084 07/31/2017 Texpool Transfers (487,340.19) (54,148.91) (541,489.10) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (541,489.10) ** (595,638.00) Budgeted (54,148.90) Remaining 91 % Used Department Totals: ----------------------------------- (542,691.89) ** (54,470.31) Monthly Total (892,849.00) Budgeted (350,157.11) Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/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 2000 07/31/2017 Recode Paying Agent Fee 200.00 200.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 2000 07/31/2017 Recode Paying Agent Fee 115,518.75 (200.00) 115,318.75 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: (200.00) 115,318.75 ** 387,649.00 Budgeted 272,330.25 Remaining 30 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 115,518.75 ** .00 Monthly Total 892,649.00 Budgeted 777,130.25 Remaining 13 % Used Fund 534 Totals: ----------------------------------- (427,173.14) (54,470.31) Monthly Total (200.00) Budgeted 426,973.14 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 219,534 ACCOUNTS RECEIVABLE - TOTAL ASSETS 219,534 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 219,534 TOTAL FUND BALANCE 219,534 TOTAL LIABILITIES AND FUND BALANCE 219,534 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 18:32 08/10/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 7/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 163.53- 604.91- 604.91 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 218,928.77- 218,928.77 Subtotal: 22,056.41- 219,533.68- 219,533.68 Program number: 22,056.41- 219,533.68- 219,533.68 Department number: Revenues 22,056.41- 219,533.68- 219,533.68 Revenues Subtotal ----------- 22,056.41- 219,533.68- 219,533.68 Fund number: 535 2016 Rev Bond I&S-SWIFT 22,056.41- 219,533.68- 219,533.68 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 18:32 08/10/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 7/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 2095 07/31/2017 Bank Interest/July (441.38) (163.53) (604.91) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (163.53) (604.91) ** .00 Budgeted 604.91 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 2084 07/31/2017 Texpool Transfers (197,035.89) (21,892.88) (218,928.77) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (218,928.77) ** .00 Budgeted 218,928.77 Remaining 0 % Used Department Totals: ----------------------------------- (219,533.68) ** (22,056.41) Monthly Total .00 Budgeted 219,533.68 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (219,533.68) (22,056.41) Monthly Total .00 Budgeted 219,533.68 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (526,775.98) **** (271,905.14) Monthly Total (192,002.00) Budgeted 334,773.98 Remaining 274 % Used ******* End of Report *********