Loading...
HomeMy WebLinkAbout2017-06 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 2017 122 ASSETS FIRE DEPT. CASH IN BANK 694 INVESTMENTS 718,637 PREPAID EXPENSES 4,128 ADVALOREM PROPERTY TAXES RECEIVABLE 23,014 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 746,473 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 23,014 ACCOUNTS AND OTHER PAYABLES 48,974 TOTAL LIABILITIES 71,988 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 153,377 TOTAL FUND BALANCE 674,485 TOTAL LIABILITIES AND FUND BALANCE 746,473 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 15:27 07/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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- 4,630.13- 1,029,872.25- 99.427 5,937.75- 122-40011-000-000 Property Taxes/Fire-Delinquent 430.94- 2,873.72- 2,873.72 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 480.92- 3,542.43- 78.721 957.57- Subtotal: 1,040,310.00- 1,040,310.00- 5,541.99- 1,036,400.42- 99.624 3,909.58- 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- 5,541.99- 1,036,549.42- 99.639 3,760.58- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 5,541.99- 1,036,549.42- 99.639 3,760.58- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 5,541.99- 1,036,549.42- 99.639 3,760.58- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 15:27 07/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 12,384.81 75.000 4,128.19 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 434,711.00 74.739 146,927.00 Subtotal: 814,905.00 814,905.00 50,350.09 663,849.81 81.463 151,055.19 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 883,172.32 84.895 157,137.68 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 883,172.32 84.895 157,137.68 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 883,172.32 84.895 157,137.68 Fund number: 122 Trophy Club MUD Fire Dept. 44,808.10 153,377.10- 153,377.10 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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 1863 06/01/2017 Property Taxes (1,025,242.12) (106.04) (1,025,348.16) GL 1864 06/02/2017 Property Taxes (612.85) (1,025,961.01) GL 1865 06/05/2017 Property Taxes (532.67) (1,026,493.68) GL 1866 06/06/2017 Property Taxes (1,400.73) (1,027,894.41) GL 1867 06/07/2017 Property Taxes (28.92) (1,027,923.33) GL 1869 06/08/2017 Property Taxes (118.58) (1,028,041.91) GL 1870 06/09/2017 Property Taxes (364.74) (1,028,406.65) GL 1871 06/13/2017 Property Taxes (169.07) (1,028,575.72) GL 1872 06/14/2017 Property Taxes (125.64) (1,028,701.36) GL 1873 06/15/2017 Property Taxes (4.71) (1,028,706.07) GL 1874 06/16/2017 Property Taxes (43.25) (1,028,749.32) GL 1875 06/19/2017 Property Taxes (527.21) (1,029,276.53) GL 1877 06/21/2017 Property Taxes (16.64) (1,029,293.17) GL 1878 06/26/2017 Property Taxes (189.91) (1,029,483.08) GL 1879 06/28/2017 Property Taxes (280.50) (1,029,763.58) GL 1880 06/29/2017 Property Taxes (8.07) (1,029,771.65) GL 1881 06/30/2017 Property Taxes (100.60) (1,029,872.25) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (4,630.13) (1,029,872.25) ** (1,035,810.00) Budgeted (5,937.75) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1869 06/08/2017 Property Taxes (2,442.78) (.24) (2,443.02) GL 1870 06/09/2017 Property Taxes (280.69) (2,723.71) GL 1874 06/16/2017 Property Taxes (149.58) (2,873.29) GL 1876 06/20/2017 Property Taxes (.43) (2,873.72) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (430.94) (2,873.72) ** .00 Budgeted 2,873.72 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1863 06/01/2017 Property Taxes (3,061.51) (6.68) (3,068.19) GL 1863 06/01/2017 Property Taxes (16.26) (3,084.45) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1865 06/05/2017 Property Taxes (3,061.51) (50.06) (3,134.51) GL 1866 06/06/2017 Property Taxes (70.26) (3,204.77) GL 1867 06/07/2017 Property Taxes (2.02) (3,206.79) GL 1869 06/08/2017 Property Taxes (17.83) (3,224.62) GL 1870 06/09/2017 Property Taxes (82.39) (3,307.01) GL 1871 06/13/2017 Property Taxes (4.94) (3,311.95) GL 1872 06/14/2017 Property Taxes (9.88) (3,321.83) GL 1874 06/16/2017 Property Taxes (85.12) (3,406.95) GL 1875 06/19/2017 Property Taxes (79.08) (3,486.03) GL 1878 06/26/2017 Property Taxes (23.72) (3,509.75) GL 1879 06/28/2017 Property Taxes (29.48) (3,539.23) GL 1881 06/30/2017 Property Taxes (3.20) (3,542.43) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (480.92) (3,542.43) ** (4,500.00) Budgeted (957.57) Remaining 79 % 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,036,549.42) ** (5,541.99) Monthly Total (1,040,310.00) Budgeted (3,760.58) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 468 06/01/2017 Insurance/Wrk Comp Exp Jun 11,008.72 1,376.09 12,384.81 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 12,384.81 ** 16,513.00 Budgeted 4,128.19 Remaining 75 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1895 06/30/2017 June A/P Fire Services-june 2017 385,737.00 48,974.00 434,711.00 TOWN OF TROPHY CLUB 3306 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 434,711.00 ** 581,638.00 Budgeted 146,927.00 Remaining 75 % 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 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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: ----------------------------------- 883,172.32 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 157,137.68 Remaining 85 % Used Fund 122 Totals: ----------------------------------- (153,377.10) 44,808.10 Monthly Total .00 Budgeted 153,377.10 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JUNE 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 728,858 - 728,858 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,482 - 713,482 INVESTMENTS-TEXPOOL 414,310 433,170 847,480 PREPAID EXPENSES 23,927 - 23,927 ADVALOREM PROPERTY TAXES RECEIVABLE 2,094 - 2,094 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,068,086 - 1,068,086 TOTAL ASSETS 3,567,129 433,170 4,000,299 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,094 - 2,094 ACCOUNTS AND OTHER PAYABLES 457,424 - 457,424 CUSTOMER DEPOSITS 315,860 - 315,860 - TOTAL LIABILITIES 775,377 - 775,377 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 660,144 - 660,144 - TOTAL FUND BALANCE 2,791,752 433,170 3,224,922 TOTAL LIABILITIES AND FUND BALANCE 3,567,129 433,170 4,000,299 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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- 272.41- 60,607.30- 99.394 369.70- 135-40002-000-000 Property Taxes/Delinquent 55.75- 266.73- 266.73 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 37.49- 240.03- 36.928 409.97- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 365.65- 61,114.06- 29.113 148,803.94- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 631,343.23- 3,816,953.08- 59.300 2,619,780.92- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 235,900.30- 1,841,298.38- 70.024 788,225.62- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 10,401.58- 85,903.63- 72.031 33,356.37- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,300.00- 10,875.00- 95.395 525.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 200.00- 1,350.00- 67.500 650.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 600.00- 3,150.00- 57.273 2,350.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 13,236.00- 44,507.45- 72.739 16,680.55- Subtotal: 9,265,606.00- 9,265,606.00- 892,981.11- 5,804,037.54- 62.641 3,461,568.46- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,863.97- 12,398.84- 154.966 4,397.84 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 8,194.77- 75.002 2,731.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-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,715.00- 16,834.02- 77.903 4,774.98- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 4,419.00- 11,003.98- 55.020 8,996.02- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 9,491.83- 53,713.58- 14.718 311,250.42- Program number: 9,545,080.00- 9,840,488.00- 902,838.59- 5,918,865.18- 60.148 3,921,622.82- Department number: Revenues 9,545,080.00- 9,840,488.00- 902,838.59- 5,918,865.18- 60.148 3,921,622.82- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 902,838.59- 5,918,865.18- 60.148 3,921,622.82- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 22,599.41 163,853.17 60.431 107,289.83 135-50010-010-000 Overtime 19,500.00 19,500.00 911.02 9,098.16 46.657 10,401.84 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,050.00 42.708 2,750.00 135-50020-010-000 Retirement 27,151.00 27,151.00 2,190.91 16,169.44 59.554 10,981.56 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 1,889.77 22,951.05 41.047 32,962.95 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 205.93 2,211.84 53.182 1,947.16 135-50028-010-000 Vision Insurance 910.00 910.00 40.17 430.55 47.313 479.45 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 9.71 1,940.21 69.219 862.79 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,453.89 10,793.89 56.747 8,227.11 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 340.02 2,524.39 56.753 1,923.61 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 8,641.44 65.704 4,510.56 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 30,889.99 244,166.23 56.929 184,730.77 135-55005-010-000 Engineering 5,000.00 60,000.00 1,133.64 37,358.07 62.263 22,641.93 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 15,017.10 67,693.79 52.680 60,806.21 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 1,350.00 45.000 1,650.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 399.61 1,419.50 17.744 6,580.50 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 254.76 2,790.56 50.737 2,709.44 Subtotal: 125,000.00 208,500.00 16,805.11 110,611.92 53.051 97,888.08 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.75 2,813.09 52.094 2,586.91 135-60020-010-000 Electricity 172,737.00 172,737.00 15,914.74 106,101.77 61.424 66,635.23 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 25.00 590.00 13.974 3,632.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 240,360.19 1,273,167.70 42.456 1,725,634.30 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 72.00 666.60 13.332 4,333.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 3,750.00 25.424 11,000.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 197,035.89 66.340 99,975.11 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 3,134.45 118,022.45 181.797 53,102.45- 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 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 282,496.01 1,725,082.11 45.155 2,095,285.89 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 705.96 6,291.55 25.341 18,536.45 135-65010-010-000 Uniforms 4,608.00 4,608.00 471.08 1,800.56 39.075 2,807.44 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,766.25 11,295.83 56.479 8,704.17 135-65035-010-000 Small Tools 1,200.00 1,200.00 646.02 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 17,069.88 54.190 14,430.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 48,264.00 59.220 33,236.00 Subtotal: 256,319.00 164,636.00 3,589.31 85,589.46 51.987 79,046.54 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 302,870.09 43.867 387,551.91 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 504,827.84 56.571 387,552.16 Program number: 5,326,780.00 5,514,781.00 333,780.42 2,670,277.56 48.420 2,844,503.44 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/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 975.40 19.508 4,024.60 Subtotal: 5,000.00 5,000.00 975.40 19.508 4,024.60 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 975.40 9.754 9,024.60 Department number: Water 5,336,780.00 5,524,781.00 333,780.42 2,671,252.96 48.350 2,853,528.04 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 45,024.66 282,491.77 72.230 108,610.23 135-50010-020-000 Overtime 29,500.00 29,500.00 3,146.61 24,432.29 82.821 5,067.71 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,175.00 79.167 1,625.00 135-50020-020-000 Retirement 39,584.00 39,584.00 4,520.58 29,025.05 73.325 10,558.95 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 41,004.91 56.154 32,017.09 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 3,266.36 71.132 1,325.64 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 701.25 68.016 329.75 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 29.13 3,375.80 75.269 1,109.20 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 2,902.00 18,640.77 66.846 9,245.23 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 678.69 4,359.52 66.843 2,162.48 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 12,122.75 106.837 775.75- 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 63,122.27 432,765.09 71.454 172,887.91 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 39,215.66 89,300.15 112.045 9,600.15- 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 1,566.00 7.830 18,434.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 424.92 7,585.44 114.931 985.44- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,173.45 41,135.74 74.792 13,864.26 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,460.50 21,373.50 85.494 3,626.50 Subtotal: 277,600.00 276,800.00 44,274.53 181,286.64 65.494 95,513.36 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 411.68 3,668.09 67.928 1,731.91 135-60020-020-000 Electricity 158,627.00 158,627.00 13,437.96 103,171.19 65.040 55,455.81 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 50.00 2,357.81 56.205 1,837.19 135-60090-020-000 Safety Program 550.00 550.00 8.97 291.12 52.931 258.88 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 24.14 2,286.73 95.280 113.27 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 475.00 15,151.97 88.350 1,998.03 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 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 590.00 2,950.00 25.431 8,650.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 98,584.38 81.818 21,907.62 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 487,340.19 81.818 108,297.81 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 11,226.55 67,359.25 54.545 56,132.75 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 91,327.03 787,657.95 62.698 468,624.05 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 743.42 6,445.06 22.946 21,642.94 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 17,906.95 85.271 3,093.05 135-65035-020-000 Small Tools 2,000.00 2,000.00 1,405.54 70.277 594.46 135-65040-020-000 Safety Equipment 750.00 750.00 101.89 354.53 47.271 395.47 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,134.01 12,806.95 91.478 1,193.05 Subtotal: 74,297.00 70,297.00 2,979.32 42,672.90 60.704 27,624.10 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 201,703.15 1,645,285.69 61.597 1,025,746.31 Department number: Wastewater 2,698,015.00 2,671,032.00 201,703.15 1,645,285.69 61.597 1,025,746.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 22.49 70.281 9.51 Subtotal: 32.00 32.00 2.61 22.49 70.281 9.51 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 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 562.35 3,287.35 82.184 712.65 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 627.58 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 1,189.93 5,734.30 44.625 7,115.70 Program number: 12,882.00 12,882.00 1,192.54 5,756.79 44.689 7,125.21 Department number: Board of Directors 12,882.00 12,882.00 1,192.54 5,756.79 44.689 7,125.21 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 57,463.53 319,474.15 61.451 200,408.85 135-50010-030-000 Overtime 1,000.00 2,500.00 44.65 3,291.84 131.674 791.84- 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 5,319.51 29,475.81 61.706 18,292.19 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 4,551.97 34,155.22 40.522 50,133.78 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 416.81 3,003.40 50.216 2,977.60 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 88.84 641.93 48.928 670.07 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 29.14 3,325.93 56.467 2,564.07 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 3,453.95 19,242.57 58.708 13,534.43 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 807.79 4,500.28 55.669 3,583.72 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,359.77 76.220 424.23 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 402.35 80.470 97.65 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 72,321.72 425,189.88 59.012 295,323.12 135-55030-030-000 Software & Support 67,791.00 77,791.00 3,130.04 80,070.08 102.930 2,279.08- 135-55070-030-000 Independent Labor 12,000.00 4,000.00 277.50 1,210.00 30.250 2,790.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 33.24 5,971.76 85.311 1,028.24 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 4,805.48 60.069 3,194.52 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 612.50 5,618.14 68.514 2,581.86 Subtotal: 185,945.00 177,191.00 4,686.34 156,318.46 88.220 20,872.54 135-60005-030-000 Telephone 17,532.00 17,532.00 230.93- 9,041.86 51.573 8,490.14 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 337.99 2,478.92 70.826 1,021.08 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 6,306.95 7,189.04 56.916 5,441.96 135-60025-030-000 Water 1,500.00 1,500.00 65.64- 712.50 47.500 787.50 135-60035-030-000 Postage 28,932.00 28,932.00 3,605.16 22,341.23 77.220 6,590.77 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,755.75 37,620.30 67.711 17,939.70 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 41,873.24 75.187 13,818.76 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 20.00 331.88 20.743 1,268.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 325.00 4,661.25 77.688 1,338.75 135-60075-030-000 Meetings 400.00 400.00 53.21 105.71 26.428 294.29 135-60079-030-000 Public Education 8,754.00 8,754.00 100.00 4,972.32 56.801 3,781.68 135-60080-030-000 Schools & Training 7,840.00 7,840.00 1,675.00 21.365 6,165.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 22.84 6,955.11 92.735 544.89 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 102.66 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 76.00 .434 17,424.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 247,491.00 19,997.55 146,224.66 59.083 101,266.34 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 73.99 4,394.86 48.832 4,605.14 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 478.78 23.939 1,521.22 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 514.33 2,898.07 72.452 1,101.93 135-65105-030-000 Printing 4,800.00 2,500.00 1,784.11 2,330.88 93.235 169.12 Subtotal: 32,099.00 27,799.00 2,372.43 12,545.15 45.128 15,253.85 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 1,687.70 109,881.15 41.398 155,542.85 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 233.22 2,837.55 61.686 1,762.45 Subtotal: 111,601.00 270,024.00 1,920.92 112,718.70 41.744 157,305.30 Program number: 1,295,172.00 1,443,018.00 101,298.96 852,996.85 59.112 590,021.15 Department number: Administration 1,295,172.00 1,443,018.00 101,298.96 852,996.85 59.112 590,021.15 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 15:27 07/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 14,453.78 53,390.79 35.594 96,609.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 2,045.87 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 16,499.65 83,428.92 44.195 105,346.08 Program number: 188,775.00 188,775.00 16,499.65 83,428.92 44.195 105,346.08 Department number: Non Departmental 188,775.00 188,775.00 16,499.65 83,428.92 44.195 105,346.08 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 654,474.72 5,258,721.21 53.440 4,581,766.79 Fund number: 135 MUD 1 General Fund 13,456.00- 248,363.87- 660,143.97- 660,143.97 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 15:27 07/13/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/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 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1863 06/01/2017 Property Taxes (60,334.89) (6.24) (60,341.13) GL 1864 06/02/2017 Property Taxes (36.06) (60,377.19) GL 1865 06/05/2017 Property Taxes (31.34) (60,408.53) GL 1866 06/06/2017 Property Taxes (82.41) (60,490.94) GL 1867 06/07/2017 Property Taxes (1.70) (60,492.64) GL 1869 06/08/2017 Property Taxes (6.97) (60,499.61) GL 1870 06/09/2017 Property Taxes (21.46) (60,521.07) GL 1871 06/13/2017 Property Taxes (9.95) (60,531.02) GL 1872 06/14/2017 Property Taxes (7.39) (60,538.41) GL 1873 06/15/2017 Property Taxes (.28) (60,538.69) GL 1874 06/16/2017 Property Taxes (2.54) (60,541.23) GL 1875 06/19/2017 Property Taxes (31.02) (60,572.25) GL 1877 06/21/2017 Property Taxes (.98) (60,573.23) GL 1878 06/26/2017 Property Taxes (11.17) (60,584.40) GL 1879 06/28/2017 Property Taxes (16.51) (60,600.91) GL 1880 06/29/2017 Property Taxes (.47) (60,601.38) GL 1881 06/30/2017 Property Taxes (5.92) (60,607.30) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (272.41) (60,607.30) ** (60,977.00) Budgeted (369.70) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1863 06/01/2017 Property Taxes (210.98) (1.28) (212.26) GL 1869 06/08/2017 Property Taxes (.02) (212.28) GL 1870 06/09/2017 Property Taxes (35.80) (248.08) GL 1874 06/16/2017 Property Taxes (18.62) (266.70) GL 1876 06/20/2017 Property Taxes (.03) (266.73) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (55.75) (266.73) ** .00 Budgeted 266.73 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1863 06/01/2017 Property Taxes (202.54) (1.29) (203.83) GL 1865 06/05/2017 Property Taxes (2.94) (206.77) GL 1866 06/06/2017 Property Taxes (4.13) (210.90) GL 1867 06/07/2017 Property Taxes (.12) (211.02) GL 1869 06/08/2017 Property Taxes (1.05) (212.07) GL 1870 06/09/2017 Property Taxes (8.41) (220.48) GL 1871 06/13/2017 Property Taxes (.29) (220.77) GL 1872 06/14/2017 Property Taxes (.58) (221.35) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1874 06/16/2017 Property Taxes (202.54) (10.71) (232.06) GL 1875 06/19/2017 Property Taxes (4.65) (236.71) GL 1878 06/26/2017 Property Taxes (1.40) (238.11) GL 1879 06/28/2017 Property Taxes (1.73) (239.84) GL 1881 06/30/2017 Property Taxes (.19) (240.03) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (37.49) (240.03) ** (650.00) Budgeted (409.97) Remaining 37 % 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 1836 06/07/2017 06/07/2017 UB Bill Adjustment UB20170607-20170607 User: (3,185,609.85) 4.20 (3,185,605.65) UB 1807 06/14/2017 rfd due to billed wrg mtr size UB20170614-20170614 User: 5,244.04 (3,180,361.61) UB 1825 06/30/2017 06/30/2017 UB Billing UB20170630-20170630 User: (636,591.47) (3,816,953.08) UB _______________ Account: 135-47000-000-000 Water Totals: (631,343.23) (3,816,953.08) ** (6,436,734.00) Budgeted (2,619,780.92) Remaining 59 % Used Account: 135-47005-000-000 Sewer 1834 06/07/2017 06/07/2017 UB Bill Adjustment UB20170607-20170607 User: (1,605,398.08) 4.27 (1,605,393.81) UB 1799 06/21/2017 Sewer winter avg adjs UB20170621-20170621 User: 92.04 (1,605,301.77) UB 1801 06/25/2017 Sewer adj-bill did not prorate UB20170625-20170625 User: 23.31 (1,605,278.46) UB 1803 06/28/2017 Swr winter avg adjs UB20170628-20170628 User: 1,012.76 (1,604,265.70) UB 1825 06/30/2017 06/30/2017 UB Billing UB20170630-20170630 User: (237,032.68) (1,841,298.38) UB _______________ Account: 135-47005-000-000 Sewer Totals: (235,900.30) (1,841,298.38) ** (2,629,524.00) Budgeted (788,225.62) Remaining 70 % Used Account: 135-47025-000-000 Penalties 1828 06/15/2017 06/15/2017 UB Penalties UB20170615-20170615 User: (75,502.05) 55.28 (75,446.77) UB 1761 06/21/2017 06/21/2017 UB Penalties UB20170621-20170621 User: (10,914.39) (86,361.16) UB 1829 06/26/2017 06/26/2017 UB Penalties UB20170626-20170626 User: 283.49 (86,077.67) UB 1845 06/27/2017 06/27/2017 Ub Penalties UB20170627-20170627 User: 16.44 (86,061.23) UB 1827 06/29/2017 06/29/2017 UB Penalties UB20170629-20170629 User: 157.60 (85,903.63) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-47025-000-000 Penalties Totals: (10,401.58) (85,903.63) ** (119,260.00) Budgeted (33,356.37) Remaining 72 % Used Account: 135-47030-000-000 Service Charges 1685 06/01/2017 06/01/2017 UB NSF Fee UB20170601-20170601 User: (9,575.00) (25.00) (9,600.00) UB 1675 06/07/2017 06/07/2017 UB Disconnect Fees UB20170607-20170607 User: (1,125.00) (10,725.00) UB 1837 06/09/2017 06/09/2017 UB NSF Fee UB20170609-20170609 User: (25.00) (10,750.00) UB 1839 06/16/2017 06/16/2017 UB NSF Fee UB20170616-20170616 User: (25.00) (10,775.00) UB 1841 06/19/2017 06/19/2017 UB NSF Fee UB20170619-20170619 User: (75.00) (10,850.00) UB 1831 06/20/2017 06/20/2017 UB Data Log fee UB20170620-20170620 User: (25.00) (10,875.00) UB 1843 06/21/2017 06/21/2017 UB NSF Fee UB20170621-20170621 User: (25.00) (10,900.00) UB 1830 06/26/2017 06/26/2017 UB NSF Fee UB20170626-20170626 User: 25.00 (10,875.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,300.00) (10,875.00) ** (11,400.00) Budgeted (525.00) Remaining 95 % Used Account: 135-47035-000-000 Plumbing Inspections 1723 06/13/2017 06/13/2017 UB Permits 523 Asheville Lane (1,150.00) (50.00) (1,200.00) Ashton Wood Homes CR 1723 06/13/2017 06/13/2017 UB Permits 645 Sheldon Drive (50.00) (1,250.00) Ashton Wood Homes CR 1762 06/21/2017 06/21/2017 UB Permits 333 Tenison trail (50.00) (1,300.00) First Texas Homes CR 1762 06/21/2017 06/21/2017 UB Permits 655 Indian Creek Drive (50.00) (1,350.00) First Texas Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (1,350.00) ** (2,000.00) Budgeted (650.00) Remaining 68 % Used Account: 135-47045-000-000 Sewer Inspections 1723 06/13/2017 06/13/2017 UB Permits 523 Asheville Lane (2,550.00) (150.00) (2,700.00) Ashton Wood Homes CR 1723 06/13/2017 06/13/2017 UB Permits 645 Sheldon Drive (150.00) (2,850.00) Ashton Wood Homes CR 1762 06/21/2017 06/21/2017 UB Permits 333 Tenison Trail (150.00) (3,000.00) First Texas Homes CR 1762 06/21/2017 06/21/2017 UB Permits 655 Indian Creek Drive (150.00) (3,150.00) First Texas Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (3,150.00) ** (5,500.00) Budgeted (2,350.00) Remaining 57 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1825 06/30/2017 06/30/2017 UB Billing UB20170630-20170630 User: (31,271.45) (13,236.00) (44,507.45) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (13,236.00) (44,507.45) ** (61,188.00) Budgeted (16,680.55) Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49010-000-000 Interest Income 1898 06/30/2017 Bank Interest/June (10,534.87) (146.58) (10,681.45) GL 1898 06/30/2017 Bank Interest/June (314.59) (10,996.04) GL 1898 06/30/2017 Bank Interest/June (202.40) (11,198.44) GL 1898 06/30/2017 Bank Interest/June (1,200.40) (12,398.84) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,863.97) (12,398.84) ** (8,001.00) Budgeted 4,397.84 Remaining 155 % Used Account: 135-49016-000-000 Cell Tower Revenue 1884 06/05/2017 AT&T Cell Antenna Lease (7,284.24) (910.53) (8,194.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (8,194.77) ** (10,926.00) Budgeted (2,731.23) Remaining 75 % Used Account: 135-49018-000-000 Building Rent Income 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: (4,666.64) (583.33) (5,249.97) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-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 1712 06/12/2017 06/12/2017 UB Permits 9076 Forest Ln (200 Hogans Dr) (15,119.02) (343.00) (15,462.02) D&D Commercial Landscape Mngmt CR 1723 06/13/2017 06/13/2017 UB Permits 523 Asheville Lane (343.00) (15,805.02) Ashton Wood Homes CR 1723 06/13/2017 06/13/2017 UB Permits 645 Sheldon Drive (343.00) (16,148.02) Ashton Wood Homes CR 1762 06/21/2017 06/21/2017 UB Permits 333 Tenison Trail (343.00) (16,491.02) First Texas Homes CR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1762 06/21/2017 06/21/2017 UB Permits 655 Indian Creek Drive (15,119.02) (343.00) (16,834.02) First Texas Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,715.00) (16,834.02) ** (21,609.00) Budgeted (4,774.98) Remaining 78 % Used Account: 135-49900-000-000 Miscellaneous Income 1883 06/05/2017 Lone Star Auctioneers (6,584.98) (4,310.00) (10,894.98) GL 1712 06/12/2017 06/12/2017 UB Permits 9076 Forest Ln (200 Hogans Dr) (3,000.00) (13,894.98) D&D Commercial Landscape Mngmt CR 1712 06/12/2017 06/12/2017 UB Permits 9076 Forest Ln (200 Hogans Dr) (1,200.00) (15,094.98) D&D Commercial Landscape Mngmt CR 1799 06/21/2017 Sewer winter avg adjs UB20170621-20170621 User: 80.00 (15,014.98) UB 1782 06/27/2017 June A/P 200 Hogan's Drive-New tap 4,200.00 (10,814.98) REY-MAR CONSTRUCTION 3262 AP 1825 06/30/2017 06/30/2017 UB Billing UB20170630-20170630 User: (189.00) (11,003.98) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (4,419.00) (11,003.98) ** (20,000.00) Budgeted (8,996.02) Remaining 55 % Used Account: 135-49901-000-000 Records Management Revenue (32.00) .00 (32.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Department Totals: ----------------------------------- (5,918,865.18) ** (902,838.59) Monthly Total (9,840,488.00) Budgeted (3,921,622.82) Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 1609 06/02/2017 MUD PR 06/02/17 Salaries & Wages 141,253.76 7,082.82 148,336.58 PR 1713 06/16/2017 MUD PR 06.16.17 Salaries & Wages 7,125.81 155,462.39 PR 1784 06/30/2017 MUD PR 06/30/17 Salaries & Wages 8,390.78 163,853.17 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,599.41 163,853.17 ** 271,143.00 Budgeted 107,289.83 Remaining 60 % Used Account: 135-50010-010-000 Overtime 1609 06/02/2017 MUD PR 06/02/17 Overtime 8,187.14 197.55 8,384.69 PR 1713 06/16/2017 MUD PR 06.16.17 Overtime 193.98 8,578.67 PR 1784 06/30/2017 MUD PR 06/30/17 Overtime 519.49 9,098.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 911.02 9,098.16 ** 19,500.00 Budgeted 10,401.84 Remaining 47 % 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 1713 06/16/2017 MUD PR 06.16.17 Certification 1,875.00 175.00 2,050.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 2,050.00 ** 4,800.00 Budgeted 2,750.00 Remaining 43 % Used Account: 135-50020-010-000 Retirement 1609 06/02/2017 MUD PR 06/02/17 Retirement 13,978.53 673.45 14,651.98 PR 1713 06/16/2017 MUD PR 06.16.17 Retirement 693.27 15,345.25 PR 1784 06/30/2017 MUD PR 06/30/17 Retirement 824.19 16,169.44 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,190.91 16,169.44 ** 27,151.00 Budgeted 10,981.56 Remaining 60 % Used Account: 135-50026-010-000 Medical Insurance 1609 06/02/2017 MUD PR 06/02/17 Medical Insurance 21,061.28 944.88 22,006.16 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1713 06/16/2017 MUD PR 06.16.17 Medical Insurance 21,061.28 944.89 22,951.05 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,889.77 22,951.05 ** 55,914.00 Budgeted 32,962.95 Remaining 41 % Used Account: 135-50027-010-000 Dental Insurance 1609 06/02/2017 MUD PR 06/02/17 Dental Insurance 2,005.91 102.98 2,108.89 PR 1713 06/16/2017 MUD PR 06.16.17 Dental Insurance 102.95 2,211.84 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 205.93 2,211.84 ** 4,159.00 Budgeted 1,947.16 Remaining 53 % Used Account: 135-50028-010-000 Vision Insurance 1609 06/02/2017 MUD PR 06/02/17 Vision Insurance 390.38 20.10 410.48 PR 1713 06/16/2017 MUD PR 06.16.17 Vision Insurance 20.07 430.55 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.17 430.55 ** 910.00 Budgeted 479.45 Remaining 47 % Used Account: 135-50029-010-000 Life Insurance & Other 1782 06/27/2017 June A/P Café 125 Admin 1,930.50 9.71 1,940.21 BenefitMall 3243 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 9.71 1,940.21 ** 2,803.00 Budgeted 862.79 Remaining 69 % Used Account: 135-50030-010-000 Social Security Taxes 1609 06/02/2017 MUD PR 06/02/17 Social Security Taxes 9,340.00 446.00 9,786.00 PR 1713 06/16/2017 MUD PR 06.16.17 Social Security Taxes 455.45 10,241.45 PR 1784 06/30/2017 MUD PR 06/30/17 Social Security Taxes 552.44 10,793.89 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,453.89 10,793.89 ** 19,021.00 Budgeted 8,227.11 Remaining 57 % Used Account: 135-50035-010-000 Medicare Taxes 1609 06/02/2017 MUD PR 06/02/17 Medicare Taxes 2,184.37 104.31 2,288.68 PR 1713 06/16/2017 MUD PR 06.16.17 Medicare Taxes 106.51 2,395.19 PR 1784 06/30/2017 MUD PR 06/30/17 Medicare Taxes 129.20 2,524.39 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-50035-010-000 Medicare Taxes Totals: 340.02 2,524.39 ** 4,448.00 Budgeted 1,923.61 Remaining 57 % Used Account: 135-50040-010-000 Unemployment Taxes 45.00 .00 45.00 _______________ 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 468 06/01/2017 Insurance/Wrk Comp Exp Jun 7,567.28 1,074.16 8,641.44 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 8,641.44 ** 13,152.00 Budgeted 4,510.56 Remaining 66 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % 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 1724 06/14/2017 June A/P Water Study Engineering-final 36,224.43 1,133.64 37,358.07 CP&Y/WALLACE GROUP, INC. 3214 AP _______________ Account: 135-55005-010-000 Engineering Totals: 1,133.64 37,358.07 ** 60,000.00 Budgeted 22,641.93 Remaining 62 % Used Account: 135-55080-010-000 Maintenance & Repairs 1734 06/16/2017 June A/P Injector nozzle for chlorine 52,676.69 207.85 52,884.54 SCOOP 3234 AP 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 16.80 52,901.34 AMAZON MKTPLACE PMTS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 ROANOKE AUTO SUPPLY LT 52,676.69 13.25 52,914.59 ROANOKE AUTO SUPPLY LT PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 ONLINECOMPONENTS.COM 277.99 53,192.58 ONLINECOMPONENTS.COM PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #0587 67.96 53,260.54 THE HOME DEPOT #0587 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #0587 (75.60) 53,184.94 THE HOME DEPOT #0587 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 64.10 53,249.04 THE HOME DEPOT #6581 PC 1782 06/27/2017 June A/P Well #3 11,898.00 65,147.04 MILLICAN WELL SERVICE, LLC 3258 AP 1895 06/30/2017 June A/P SCADA repair 2,546.75 67,693.79 DHS AUTOMATION, INC 3275 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 15,017.10 67,693.79 ** 128,500.00 Budgeted 60,806.21 Remaining 53 % Used Account: 135-55085-010-000 Generator Maint. and Repair 1,350.00 .00 1,350.00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 1,350.00 ** 3,000.00 Budgeted 1,650.00 Remaining 45 % Used Account: 135-55090-010-000 Vehicle Maintenance 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 ROANOKE AUTO SUPPLY LT 1,019.89 34.61 1,054.50 ROANOKE AUTO SUPPLY LT PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 DISCOUNT TIRE TXD 75 365.00 1,419.50 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 399.61 1,419.50 ** 8,000.00 Budgeted 6,580.50 Remaining 18 % 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 1734 06/16/2017 June A/P Water samples 2,535.80 245.00 2,780.80 TARRANT CTY PUBLIC HEALTH LAB 3235 AP 1894 06/30/2017 June A/P Reimburse Petty Cash 9.76 2,790.56 TROPHY CLUB MUD PETTY CASH 3308 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 254.76 2,790.56 ** 5,500.00 Budgeted 2,709.44 Remaining 51 % Used Account: 135-60010-010-000 Communications/Mobiles . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1724 06/14/2017 June A/P Cell phones 2,466.34 346.75 2,813.09 VERIZON WIRELESS 3240 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.75 2,813.09 ** 5,400.00 Budgeted 2,586.91 Remaining 52 % Used Account: 135-60020-010-000 Electricity 1724 06/14/2017 June A/P Electricity 5/9-6/8/17 90,187.03 120.52 90,307.55 HUDSON ENERGY SERVICES, LLC 3221 AP 1751 06/20/2017 June A/P Electricity 5/10-6/9 13,881.53 104,189.08 HUDSON ENERGY SERVICES, LLC 3252 AP 1751 06/20/2017 June A/P Electricity 5/10-6/9 1,912.69 106,101.77 HUDSON ENERGY SERVICES, LLC 3252 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,914.74 106,101.77 ** 172,737.00 Budgeted 66,635.23 Remaining 61 % 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 1894 06/30/2017 June A/P Reimburse Petty Cash 565.00 25.00 590.00 TROPHY CLUB MUD PETTY CASH 3308 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 25.00 590.00 ** 4,222.00 Budgeted 3,632.00 Remaining 14 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 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 1782 06/27/2017 June A/P Wholesale water 1,032,807.51 240,360.19 1,273,167.70 CITY OF FORT WORTH 3244 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 240,360.19 1,273,167.70 ** 2,998,802.00 Budgeted 1,725,634.30 Remaining 42 % 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 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 DENTON SAND & 00 OF 00 594.60 72.00 666.60 DENTON SAND & 00 OF 00 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 72.00 666.60 ** 5,000.00 Budgeted 4,333.40 Remaining 13 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1895 06/30/2017 June A/P mowing 3,000.00 750.00 3,750.00 WATTS ELLISON LLC 3310 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 3,750.00 ** 14,750.00 Budgeted 11,000.00 Remaining 25 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1900 06/29/2017 Texpool Transfers 175,143.01 21,892.88 197,035.89 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 197,035.89 ** 297,011.00 Budgeted 99,975.11 Remaining 66 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1900 06/29/2017 Texpool Transfers 114,888.00 3,134.45 118,022.45 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 3,134.45 118,022.45 ** 64,920.00 Budgeted (53,102.45) Remaining 182 % 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 1895 06/30/2017 June A/P fule 5,585.59 705.96 6,291.55 US Bank Voyager Fleet Systems 3309 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 705.96 6,291.55 ** 24,828.00 Budgeted 18,536.45 Remaining 25 % Used Account: 135-65010-010-000 Uniforms 1907 06/30/2017 June A/P Shirts and jackets 1,329.48 471.08 1,800.56 RON MONTGOMERY & ASSOC INC AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-65010-010-000 Uniforms Totals: 471.08 1,800.56 ** 4,608.00 Budgeted 2,807.44 Remaining 39 % Used Account: 135-65030-010-000 Chemicals 1782 06/27/2017 June A/P chlorine 9,529.58 847.52 10,377.10 DPC INDUSTRIES, INC 3249 AP 1895 06/30/2017 June A/P lab supplies 918.73 11,295.83 HACH COMPANY 3282 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,766.25 11,295.83 ** 20,000.00 Budgeted 8,704.17 Remaining 56 % Used Account: 135-65035-010-000 Small Tools 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 221.62 646.02 867.64 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 646.02 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 17,069.88 .00 17,069.88 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 17,069.88 ** 31,500.00 Budgeted 14,430.12 Remaining 54 % Used Account: 135-65053-010-000 Meter Change Out Program 48,264.00 .00 48,264.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,264.00 ** 81,500.00 Budgeted 33,236.00 Remaining 59 % Used Account: 135-69005-010-000 Capital Outlays 302,870.09 .00 302,870.09 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Capital Outlays Totals: .00 302,870.09 ** 690,422.00 Budgeted 387,551.91 Remaining 44 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/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 975.40 .00 975.40 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 975.40 ** 5,000.00 Budgeted 4,024.60 Remaining 20 % 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,671,252.96 ** 333,780.42 Monthly Total 5,524,781.00 Budgeted 2,853,528.04 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1609 06/02/2017 MUD PR 06/02/17 Salaries & Wages 237,467.11 14,989.04 252,456.15 PR 1713 06/16/2017 MUD PR 06.16.17 Salaries & Wages 15,046.58 267,502.73 PR 1784 06/30/2017 MUD PR 06/30/17 Salaries & Wages 14,989.04 282,491.77 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 45,024.66 282,491.77 ** 391,102.00 Budgeted 108,610.23 Remaining 72 % Used Account: 135-50010-020-000 Overtime 1609 06/02/2017 MUD PR 06/02/17 Overtime 21,285.68 885.67 22,171.35 PR 1713 06/16/2017 MUD PR 06.16.17 Overtime 1,158.79 23,330.14 PR 1784 06/30/2017 MUD PR 06/30/17 Overtime 1,102.15 24,432.29 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,146.61 24,432.29 ** 29,500.00 Budgeted 5,067.71 Remaining 83 % 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 1713 06/16/2017 MUD PR 06.16.17 Certification 5,475.00 700.00 6,175.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 6,175.00 ** 7,800.00 Budgeted 1,625.00 Remaining 79 % Used Account: 135-50020-020-000 Retirement 1609 06/02/2017 MUD PR 06/02/17 Retirement 24,504.47 1,468.40 25,972.87 PR 1713 06/16/2017 MUD PR 06.16.17 Retirement 1,563.76 27,536.63 PR 1784 06/30/2017 MUD PR 06/30/17 Retirement 1,488.42 29,025.05 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,520.58 29,025.05 ** 39,584.00 Budgeted 10,558.95 Remaining 73 % Used Account: 135-50026-020-000 Medical Insurance 1609 06/02/2017 MUD PR 06/02/17 Medical Insurance 36,294.71 2,355.10 38,649.81 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1713 06/16/2017 MUD PR 06.16.17 Medical Insurance 36,294.71 2,355.10 41,004.91 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 41,004.91 ** 73,022.00 Budgeted 32,017.09 Remaining 56 % Used Account: 135-50027-020-000 Dental Insurance 1609 06/02/2017 MUD PR 06/02/17 Dental Insurance 2,867.04 199.69 3,066.73 PR 1713 06/16/2017 MUD PR 06.16.17 Dental Insurance 199.63 3,266.36 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 3,266.36 ** 4,592.00 Budgeted 1,325.64 Remaining 71 % Used Account: 135-50028-020-000 Vision Insurance 1609 06/02/2017 MUD PR 06/02/17 Vision Insurance 616.92 42.19 659.11 PR 1713 06/16/2017 MUD PR 06.16.17 Vision Insurance 42.14 701.25 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 701.25 ** 1,031.00 Budgeted 329.75 Remaining 68 % Used Account: 135-50029-020-000 Life Insurance & Other 1782 06/27/2017 June A/P Café 125 Admin 3,346.67 29.13 3,375.80 BenefitMall 3243 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 29.13 3,375.80 ** 4,485.00 Budgeted 1,109.20 Remaining 75 % Used Account: 135-50030-020-000 Social Security Taxes 1609 06/02/2017 MUD PR 06/02/17 Social Security Taxes 15,738.77 928.19 16,666.96 PR 1713 06/16/2017 MUD PR 06.16.17 Social Security Taxes 972.24 17,639.20 PR 1784 06/30/2017 MUD PR 06/30/17 Social Security Taxes 1,001.57 18,640.77 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,902.00 18,640.77 ** 27,886.00 Budgeted 9,245.23 Remaining 67 % Used Account: 135-50035-020-000 Medicare Taxes 1609 06/02/2017 MUD PR 06/02/17 Medicare Taxes 3,680.83 217.08 3,897.91 PR 1713 06/16/2017 MUD PR 06.16.17 Medicare Taxes 227.39 4,125.30 PR 1784 06/30/2017 MUD PR 06/30/17 Medicare Taxes 234.22 4,359.52 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-50035-020-000 Medicare Taxes Totals: 678.69 4,359.52 ** 6,522.00 Budgeted 2,162.48 Remaining 67 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 _______________ 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 468 06/01/2017 Insurance/Wrk Comp Exp Jun 11,196.00 926.75 12,122.75 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 12,122.75 ** 11,347.00 Budgeted (775.75) Remaining 107 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-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 1734 06/16/2017 June A/P Sep TCEQ-Manhole repair 50,084.49 30,200.00 80,284.49 REY-MAR CONSTRUCTION 3232 AP 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 4.99 80,289.48 THE HOME DEPOT #6581 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 76.77 80,366.25 THE HOME DEPOT #6581 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 33.30 80,399.55 THE HOME DEPOT #6581 PC 1782 06/27/2017 June A/P Replacement rubber for boots 62.00 80,461.55 Huber Technology Inc 3251 AP 1895 06/30/2017 June A/P repair of LS #1, pump #2 6,527.00 86,988.55 XYLEM WATER SOLUTIONS USA INC 3311 AP 1895 06/30/2017 June A/P Repair of LS #1 2,311.60 89,300.15 RLC Controls 3304 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 39,215.66 89,300.15 ** 79,700.00 Budgeted (9,600.15) Remaining 112 % Used Account: 135-55085-020-000 Generator Maint. and Repair 1,566.00 .00 1,566.00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 1,566.00 ** 20,000.00 Budgeted 18,434.00 Remaining 8 % Used Account: 135-55090-020-000 Vehicle Maintenance 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 DISCOUNT TIRE TXD 75 7,160.52 196.50 7,357.02 DISCOUNT TIRE TXD 75 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 CLASSIC CHEVROLET LT 191.44 7,548.46 CLASSIC CHEVROLET LT PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 36.98 7,585.44 THE HOME DEPOT #6581 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 424.92 7,585.44 ** 6,600.00 Budgeted (985.44) 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 1782 06/27/2017 June A/P Sludge haul off 38,962.29 845.00 39,807.29 L.H. CHANEY MATERIALS, INC. 3254 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1893 06/30/2017 June A/P Sludge haul off 38,962.29 475.00 40,282.29 L.H. CHANEY MATERIALS, INC. 3291 AP 1893 06/30/2017 June A/P Sludge haul off 853.45 41,135.74 L.H. CHANEY MATERIALS, INC. 3291 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,173.45 41,135.74 ** 55,000.00 Budgeted 13,864.26 Remaining 75 % Used Account: 135-55135-020-000 Lab Analysis 1724 06/14/2017 June A/P Lab 18,913.00 246.00 19,159.00 OXIDOR LABORATORIES LLC 3231 AP 1724 06/14/2017 June A/P Lab 176.00 19,335.00 OXIDOR LABORATORIES LLC 3231 AP 1782 06/27/2017 June A/P Lab analysis 772.50 20,107.50 OXIDOR LABORATORIES LLC 3261 AP 1782 06/27/2017 June A/P Lab analysis 246.00 20,353.50 OXIDOR LABORATORIES LLC 3261 AP 1782 06/27/2017 June A/P Lab analysis 176.00 20,529.50 OXIDOR LABORATORIES LLC 3261 AP 1782 06/27/2017 June A/P Lab analysis 246.00 20,775.50 OXIDOR LABORATORIES LLC 3261 AP 1782 06/27/2017 June A/P Lab analysis 176.00 20,951.50 OXIDOR LABORATORIES LLC 3261 AP 1893 06/30/2017 June A/P Testing 246.00 21,197.50 OXIDOR LABORATORIES LLC 3301 AP 1893 06/30/2017 June A/P Testing 176.00 21,373.50 OXIDOR LABORATORIES LLC 3301 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,460.50 21,373.50 ** 25,000.00 Budgeted 3,626.50 Remaining 85 % Used Account: 135-60010-020-000 Communications/Mobiles 1724 06/14/2017 June A/P Cell phones 3,256.41 411.68 3,668.09 VERIZON WIRELESS 3240 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 411.68 3,668.09 ** 5,400.00 Budgeted 1,731.91 Remaining 68 % Used Account: 135-60020-020-000 Electricity 1724 06/14/2017 June A/P Electricity 5/6-6/8/17 89,733.23 34.07 89,767.30 HUDSON ENERGY SERVICES, LLC 3221 AP 1724 06/14/2017 June A/P Electricity 5/9-6/8/17 74.49 89,841.79 HUDSON ENERGY SERVICES, LLC 3221 AP 1734 06/16/2017 June A/P Electricity 5/10-6/9 359 Dover 102.05 89,943.84 HUDSON ENERGY SERVICES, LLC 3221 AP 1734 06/16/2017 June A/P Electricity 5/10-6/8 4,234.31 94,178.15 ENGIE Resources LLC 3216 AP 1751 06/20/2017 June A/P Electricity 5/10-6/9 438.00 94,616.15 HUDSON ENERGY SERVICES, LLC 3252 AP 1751 06/20/2017 June A/P Electricity 5/10-6/9 7,743.66 102,359.81 HUDSON ENERGY SERVICES, LLC 3252 AP 1751 06/20/2017 June A/P Electricity 5/10-6/9 264.09 102,623.90 MP2 ENERGY TEXAS LLC 3259 AP 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: (171.95) 102,451.95 AR 1929 06/30/2017 Recode June TriCounty Elec 719.24 103,171.19 GL _______________ Account: 135-60020-020-000 Electricity Totals: 13,437.96 103,171.19 ** 158,627.00 Budgeted 55,455.81 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-020-000 Publications/Books/Subscripts 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 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 1894 06/30/2017 June A/P Reimburse Petty Cash 2,307.81 50.00 2,357.81 TROPHY CLUB MUD PETTY CASH 3308 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 50.00 2,357.81 ** 4,195.00 Budgeted 1,837.19 Remaining 56 % Used Account: 135-60090-020-000 Safety Program 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 RANDALLS STORE00017897 282.15 8.97 291.12 RANDALLS STORE00017897 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 8.97 291.12 ** 550.00 Budgeted 258.88 Remaining 53 % Used Account: 135-60100-020-000 Travel & per diem 1782 06/27/2017 June A/P Tolls for lab samples 2,262.59 24.14 2,286.73 NTTA 3260 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 24.14 2,286.73 ** 2,400.00 Budgeted 113.27 Remaining 95 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1724 06/14/2017 June A/P WW Permit renewal 14,676.97 475.00 15,151.97 CP&Y/WALLACE GROUP, INC. 3214 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 475.00 15,151.97 ** 17,150.00 Budgeted 1,998.03 Remaining 88 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % 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 1895 06/30/2017 June A/P mowing 2,360.00 590.00 2,950.00 WATTS ELLISON LLC 3310 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 2,950.00 ** 11,600.00 Budgeted 8,650.00 Remaining 25 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1900 06/29/2017 Texpool Transfers 87,630.56 10,953.82 98,584.38 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 98,584.38 ** 120,492.00 Budgeted 21,907.62 Remaining 82 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1900 06/29/2017 Texpool Transfers 433,191.28 54,148.91 487,340.19 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 487,340.19 ** 595,638.00 Budgeted 108,297.81 Remaining 82 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1900 06/29/2017 Texpool Transfers 56,132.70 11,226.55 67,359.25 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 11,226.55 67,359.25 ** 123,492.00 Budgeted 56,132.75 Remaining 55 % 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 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 CORNER STORE 1764 5,701.64 26.11 5,727.75 CORNER STORE 1764 PC 1895 06/30/2017 June A/P fule 717.31 6,445.06 US Bank Voyager Fleet Systems 3309 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 743.42 6,445.06 ** 28,088.00 Budgeted 21,642.94 Remaining 23 % 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 17,906.95 .00 17,906.95 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 17,906.95 ** 21,000.00 Budgeted 3,093.05 Remaining 85 % Used Account: 135-65035-020-000 Small Tools 1,405.54 .00 1,405.54 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-65035-020-000 Small Tools Totals: .00 1,405.54 ** 2,000.00 Budgeted 594.46 Remaining 70 % Used Account: 135-65040-020-000 Safety Equipment 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 TRACTOR SUPPLY COMPANY 252.64 59.98 312.62 TRACTOR SUPPLY COMPANY PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 THE HOME DEPOT #6581 41.91 354.53 THE HOME DEPOT #6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 101.89 354.53 ** 750.00 Budgeted 395.47 Remaining 47 % Used Account: 135-65045-020-000 Lab Supplies 1724 06/14/2017 June A/P 10,672.94 1,499.09 12,172.03 IDEXX DISTRIBUTION, INC 3222 AP 1782 06/27/2017 June A/P lab 385.22 12,557.25 HACH COMPANY 3250 AP 1782 06/27/2017 June A/P Lab supplies 87.70 12,644.95 HACH COMPANY 3250 AP 1893 06/30/2017 June A/P Gloves for lab 162.00 12,806.95 LOU'S GLOVES INCORPORATED 3295 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,134.01 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,645,285.69 ** 201,703.15 Monthly Total 2,671,032.00 Budgeted 1,025,746.31 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-60020-021-000 Electricity 1893 06/30/2017 June A/P Electricity 5/24-6/26/17 240.66 240.66 TRI COUNTY ELECTRIC 3307 AP 1893 06/30/2017 June A/P Electricity 5/24-6/26/17 28.23 268.89 TRI COUNTY ELECTRIC 3307 AP 1893 06/30/2017 June A/P Electricity 5/24-6/26/17 450.35 719.24 TRI COUNTY ELECTRIC 3307 AP 1929 06/30/2017 Recode June TriCounty Elec (719.24) .00 GL _______________ Account: 135-60020-021-000 Electricity Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department 21 Totals: ----------------------------------- .00 ** .00 Monthly Total .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 468 06/01/2017 Insurance/Wrk Comp Exp Jun 19.88 2.61 22.49 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 22.49 ** 32.00 Budgeted 9.51 Remaining 70 % 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 .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 Kevin Carr 2,725.00 187.45 2,912.45 OMNI HOTELS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 Bill Rose 187.45 3,099.90 OMNI HOTELS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 Shane Jeff 187.45 3,287.35 OMNI HOTELS PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 562.35 3,287.35 ** 4,000.00 Budgeted 712.65 Remaining 82 % Used Account: 135-60100-026-000 Travel & per diem 1782 06/27/2017 June A/P AWBD 1,819.37 627.58 2,446.95 William Rose 3265 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 627.58 2,446.95 ** 5,000.00 Budgeted 2,553.05 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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-60245-026-000 Miscellaneous Expenses .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,756.79 ** 1,192.54 Monthly Total 12,882.00 Budgeted 7,125.21 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1609 06/02/2017 MUD PR 06/02/17 Salaries & Wages 262,010.62 19,511.58 281,522.20 PR 1713 06/16/2017 MUD PR 06.16.17 Salaries & Wages 19,511.27 301,033.47 PR 1784 06/30/2017 MUD PR 06/30/17 Salaries & Wages 18,440.68 319,474.15 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 57,463.53 319,474.15 ** 519,883.00 Budgeted 200,408.85 Remaining 61 % Used Account: 135-50010-030-000 Overtime 1609 06/02/2017 MUD PR 06/02/17 Overtime 3,247.19 8.05 3,255.24 PR 1713 06/16/2017 MUD PR 06.16.17 Overtime 19.10 3,274.34 PR 1784 06/30/2017 MUD PR 06/30/17 Overtime 17.50 3,291.84 PR _______________ Account: 135-50010-030-000 Overtime Totals: 44.65 3,291.84 ** 2,500.00 Budgeted (791.84) Remaining 132 % 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 1609 06/02/2017 MUD PR 06/02/17 Retirement 24,156.30 1,805.56 25,961.86 PR 1713 06/16/2017 MUD PR 06.16.17 Retirement 1,806.57 27,768.43 PR 1784 06/30/2017 MUD PR 06/30/17 Retirement 1,707.38 29,475.81 PR _______________ Account: 135-50020-030-000 Retirement Totals: 5,319.51 29,475.81 ** 47,768.00 Budgeted 18,292.19 Remaining 62 % Used Account: 135-50026-030-000 Medical Insurance 1609 06/02/2017 MUD PR 06/02/17 Medical Insurance 29,603.25 2,275.98 31,879.23 PR 1713 06/16/2017 MUD PR 06.16.17 Medical Insurance 2,275.99 34,155.22 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,551.97 34,155.22 ** 84,289.00 Budgeted 50,133.78 Remaining 41 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1609 06/02/2017 MUD PR 06/02/17 Dental Insurance 2,586.59 208.44 2,795.03 PR 1713 06/16/2017 MUD PR 06.16.17 Dental Insurance 208.37 3,003.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 416.81 3,003.40 ** 5,981.00 Budgeted 2,977.60 Remaining 50 % Used Account: 135-50028-030-000 Vision Insurance 1609 06/02/2017 MUD PR 06/02/17 Vision Insurance 553.09 44.45 597.54 PR 1713 06/16/2017 MUD PR 06.16.17 Vision Insurance 44.39 641.93 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 88.84 641.93 ** 1,312.00 Budgeted 670.07 Remaining 49 % Used Account: 135-50029-030-000 Life Insurance & Other 1782 06/27/2017 June A/P Rounding adjustment 3,296.79 (.02) 3,296.77 Legal Shield 3255 AP 1782 06/27/2017 June A/P Café 125 Admin 29.16 3,325.93 BenefitMall 3243 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 29.14 3,325.93 ** 5,890.00 Budgeted 2,564.07 Remaining 56 % Used Account: 135-50030-030-000 Social Security Taxes 1609 06/02/2017 MUD PR 06/02/17 Social Security Taxes 15,788.62 1,160.89 16,949.51 PR 1713 06/16/2017 MUD PR 06.16.17 Social Security Taxes 1,148.68 18,098.19 PR 1784 06/30/2017 MUD PR 06/30/17 Social Security Taxes 1,144.38 19,242.57 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,453.95 19,242.57 ** 32,777.00 Budgeted 13,534.43 Remaining 59 % Used Account: 135-50035-030-000 Medicare Taxes 1609 06/02/2017 MUD PR 06/02/17 Medicare Taxes 3,692.49 271.49 3,963.98 PR 1713 06/16/2017 MUD PR 06.16.17 Medicare Taxes 268.65 4,232.63 PR 1784 06/30/2017 MUD PR 06/30/17 Medicare Taxes 267.65 4,500.28 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 807.79 4,500.28 ** 8,084.00 Budgeted 3,583.72 Remaining 56 % Used Account: 135-50040-030-000 Unemployment Taxes 293.73 .00 293.73 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-030-000 Unemployment Taxes Totals: .00 293.73 ** 1,368.00 Budgeted 1,074.27 Remaining 21 % Used Account: 135-50045-030-000 Workman's Compensation 468 06/01/2017 Insurance/Wrk Comp Exp Jun 1,214.24 145.53 1,359.77 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,359.77 ** 1,784.00 Budgeted 424.23 Remaining 76 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 402.35 .00 402.35 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 402.35 ** 500.00 Budgeted 97.65 Remaining 80 % 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 1665 06/05/2017 June A/P Remit annual maintenance 76,940.04 1,856.58 78,796.62 JACK HENRY & ASSOC, INC 3187 AP 1724 06/14/2017 June A/P Internet 1,036.77 79,833.39 WHOLESALE CARRIER SERVICES INC 3241 AP 1734 06/16/2017 June A/P Emil license 168.00 80,001.39 M3 Networks 3227 AP 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 ADOBE *IL CREATIVE CLD 19.99 80,021.38 ADOBE *IL CREATIVE CLD PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 DNH*GODADDY.COM 48.70 80,070.08 DNH*GODADDY.COM PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,130.04 80,070.08 ** 77,791.00 Budgeted (2,279.08) Remaining 103 % Used Account: 135-55070-030-000 Independent Labor 1907 06/30/2017 June A/P Record MUD Meetings Mar-June 932.50 277.50 1,210.00 MIGUEL CRUZ AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 277.50 1,210.00 ** 4,000.00 Budgeted 2,790.00 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-55080-030-000 Maintenance & Repairs 826.00 .00 826.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 826.00 ** 2,000.00 Budgeted 1,174.00 Remaining 41 % Used Account: 135-55085-030-000 Generator Maint. and Repair 485.00 .00 485.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 1724 06/14/2017 June A/P Rug service 5,938.52 66.47 6,004.99 G & K SERVICES 3220 AP 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: (33.23) 5,971.76 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 33.24 5,971.76 ** 7,000.00 Budgeted 1,028.24 Remaining 85 % Used Account: 135-55120-030-000 Cleaning Services 1753 06/20/2017 June A/P Janitorial ervice-May 4,172.42 869.06 5,041.48 MEMBER'S BUILDING MAINTENANCE 3256 AP 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: (236.00) 4,805.48 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 4,805.48 ** 8,000.00 Budgeted 3,194.52 Remaining 60 % 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 36 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1893 06/30/2017 June A/P Water Billings June 5,005.64 612.50 5,618.14 DATAPROSE LLC 3272 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 612.50 5,618.14 ** 8,200.00 Budgeted 2,581.86 Remaining 69 % Used Account: 135-60005-030-000 Telephone 1734 06/16/2017 June A/P Answering service 9,272.79 208.50 9,481.29 KEYSTONE PARK SECRETARIAL 3225 AP 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 RINGCENTRAL, INC 13.95 9,495.24 RINGCENTRAL, INC PC 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: (453.38) 9,041.86 AR _______________ Account: 135-60005-030-000 Telephone Totals: (230.93) 9,041.86 ** 17,532.00 Budgeted 8,490.14 Remaining 52 % Used Account: 135-60010-030-000 Communications/Mobiles 1724 06/14/2017 June A/P Cell phones 2,140.93 37.99 2,178.92 VERIZON WIRELESS 3240 AP 1713 06/16/2017 MUD PR 06.16.17 Communications/Mobiles 300.00 2,478.92 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 2,478.92 ** 3,500.00 Budgeted 1,021.08 Remaining 71 % Used Account: 135-60020-030-000 Electricity/Gas 1734 06/16/2017 June A/P Elec-MUD/PS Bldgs Dec-Apr 882.09 4,724.96 5,607.05 TOWN OF TROPHY CLUB 3237 AP 1734 06/16/2017 June A/P MUD/PS Bldg Elec-April & may 1,581.99 7,189.04 TOWN OF TROPHY CLUB 3237 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 6,306.95 7,189.04 ** 12,631.00 Budgeted 5,441.96 Remaining 57 % Used Account: 135-60025-030-000 Water 1899 06/30/2017 Billed Town Inv 1574-79 AR 20170630-20170630 User: 778.14 (65.64) 712.50 AR _______________ Account: 135-60025-030-000 Water Totals: (65.64) 712.50 ** 1,500.00 Budgeted 787.50 Remaining 48 % Used Account: 135-60035-030-000 Postage 1893 06/30/2017 June A/P Overnight letter 18,736.07 6.22 18,742.29 FEDERAL EXPRESS CORP 3276 AP 1893 06/30/2017 June A/P Printing & Mailing of CCR 1,848.42 20,590.71 DATAPROSE LLC 3272 AP 1893 06/30/2017 June A/P Water Billings June 1,750.52 22,341.23 DATAPROSE LLC 3272 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-60035-030-000 Postage Totals: 3,605.16 22,341.23 ** 28,932.00 Budgeted 6,590.77 Remaining 77 % Used Account: 135-60040-030-000 Service Charges & Fees 1627 06/02/2017 Child Support Fee 32,864.55 1.50 32,866.05 GL 1891 06/02/2017 Credit card fees 140.18 33,006.23 GL 1891 06/02/2017 Credit card fees 4,611.07 37,617.30 GL 1714 06/16/2017 Child Support Fee 1.50 37,618.80 GL 1787 06/30/2017 Child Support Fee 1.50 37,620.30 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,755.75 37,620.30 ** 55,560.00 Budgeted 17,939.70 Remaining 68 % 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 468 06/01/2017 Insurance/Wrk Comp Exp Jun 37,208.68 4,664.56 41,873.24 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 41,873.24 ** 55,692.00 Budgeted 13,818.76 Remaining 75 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 TX WATER DEV BOARD ACC 311.88 20.00 331.88 TX WATER DEV BOARD ACC PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 20.00 331.88 ** 1,600.00 Budgeted 1,268.12 Remaining 21 % Used Account: 135-60070-030-000 Dues & Memberships 1724 06/14/2017 June A/P Dues 4,336.25 325.00 4,661.25 TX MUNICIPAL LEAGUE 3239 AP 1885 06/26/2017 Costco Card Cancellation (50.42) 4,610.83 GL 1894 06/30/2017 June A/P Reimburse Petty Cash 50.42 4,661.25 TROPHY CLUB MUD PETTY CASH 3308 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 325.00 4,661.25 ** 6,000.00 Budgeted 1,338.75 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1895 06/30/2017 June A/P Meetings 52.50 53.21 105.71 KEVIN R. CARR 3289 AP _______________ Account: 135-60075-030-000 Meetings Totals: 53.21 105.71 ** 400.00 Budgeted 294.29 Remaining 26 % Used Account: 135-60079-030-000 Public Education 1782 06/27/2017 June A/P Public education 4,872.32 100.00 4,972.32 TEXAS A&M AGRILIFE RESEARCH 3263 AP _______________ Account: 135-60079-030-000 Public Education Totals: 100.00 4,972.32 ** 8,754.00 Budgeted 3,781.68 Remaining 57 % Used Account: 135-60080-030-000 Schools & Training 1,675.00 .00 1,675.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 1,675.00 ** 7,840.00 Budgeted 6,165.00 Remaining 21 % Used Account: 135-60100-030-000 Travel & per diem 1609 06/02/2017 MUD PR 06/02/17 Travel & per diem 6,932.27 22.84 6,955.11 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 22.84 6,955.11 ** 7,500.00 Budgeted 544.89 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 1753 06/20/2017 June A/P Elections 2,822.67 102.66 2,925.33 DENTON COUNTY ELECTIONS 3248 AP _______________ Account: 135-60115-030-000 Elections Totals: 102.66 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 39 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 76.00 .00 76.00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 76.00 ** 17,500.00 Budgeted 17,424.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,040.00 .00 1,040.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 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 1895 06/30/2017 June A/P Office supplies 4,320.87 67.99 4,388.86 OFFICE DEPOT, INC 3300 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1895 06/30/2017 June A/P Office supplies 4,320.87 6.00 4,394.86 OFFICE DEPOT, INC 3300 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 73.99 4,394.86 ** 9,000.00 Budgeted 4,605.14 Remaining 49 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 478.78 .00 478.78 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 478.78 ** 2,000.00 Budgeted 1,521.22 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 SAMSCLUB.COM 2,383.74 99.15 2,482.89 SAMSCLUB.COM PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 WM SUPERCENTER #5247 23.89 2,506.78 WM SUPERCENTER #5247 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 22.60 2,529.38 AMAZON MKTPLACE PMTS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 26.83 2,556.21 AMAZON MKTPLACE PMTS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 STAPLES DIRECT 83.46 2,639.67 STAPLES DIRECT PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 WAL-MART #5247 37.88 2,677.55 WAL-MART #5247 PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 58.55 2,736.10 AMAZON MKTPLACE PMTS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 59.99 2,796.09 AMAZON MKTPLACE PMTS PC 1815 06/26/2017 Pcar 05/27/17 - 06/26/17 AMAZON MKTPLACE PMTS 101.98 2,898.07 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 514.33 2,898.07 ** 4,000.00 Budgeted 1,101.93 Remaining 72 % Used Account: 135-65105-030-000 Printing 1893 06/30/2017 June A/P Printing & Mailing of CCR 546.77 1,784.11 2,330.88 DATAPROSE LLC 3272 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,784.11 2,330.88 ** 2,500.00 Budgeted 169.12 Remaining 93 % Used Account: 135-69005-030-000 Capital Outlays 1724 06/14/2017 June A/P Final-restroom remodel 108,193.45 1,687.70 109,881.15 CP&Y/WALLACE GROUP, INC. 3214 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 1,687.70 109,881.15 ** 265,424.00 Budgeted 155,542.85 Remaining 41 % Used Account: 135-69170-030-000 Copier Lease Installments . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1724 06/14/2017 June A/P Copier lease 2,604.33 165.00 2,769.33 EVERBANK COMMERCIAL FINANCE 3217 AP 1782 06/27/2017 June A/P Copier 68.22 2,837.55 KYOCERA DOCUMENT SOLUTIONS 3253 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 233.22 2,837.55 ** 4,600.00 Budgeted 1,762.45 Remaining 62 % Used Department 30 Totals: ----------------------------------- 852,996.85 ** 101,298.96 Monthly Total 1,443,018.00 Budgeted 590,021.15 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1724 06/14/2017 June A/P Legal 38,937.01 14,453.78 53,390.79 McLean & Howard, L.L.P. 3228 AP _______________ Account: 135-55045-039-000 Legal Totals: 14,453.78 53,390.79 ** 150,000.00 Budgeted 96,609.21 Remaining 36 % 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 1782 06/27/2017 June A/P third qtr DCAD budget 6,621.58 2,045.87 8,667.45 DENTON CENTRAL APPRAISAL DISTR 3247 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,045.87 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: ----------------------------------- 83,428.92 ** 16,499.65 Monthly Total 188,775.00 Budgeted 105,346.08 Remaining 44 % Used Fund 135 Totals: ----------------------------------- (660,143.97) (248,363.87) Monthly Total .00 Budgeted 660,143.97 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/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 JUNE 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,863,529 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,863,529 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 740,883 TOTAL LIABILITIES 740,883 FUND BALANCE ASSIGNED FUND BALANCE 4,433,035 NET REVENUES / EXPENDITURES (2,310,388) TOTAL FUND BALANCE 2,122,647 TOTAL LIABILITIES AND FUND BALANCE 2,863,529 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 15:27 07/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,073.67- 15,710.03- 15,710.03 Subtotal: 2,073.67- 15,710.03- 15,710.03 Program number: 2,073.67- 15,710.03- 15,710.03 Department number: Revenues 2,073.67- 15,710.03- 15,710.03 Revenues Subtotal ----------- 2,073.67- 15,710.03- 15,710.03 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 15:27 07/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 49,633.74 2,326,098.51 2,326,098.51- Subtotal: 49,633.74 2,326,098.51 2,326,098.51- Program number: 49,633.74 2,326,098.51 2,326,098.51- Department number: Wastewater 49,633.74 2,326,098.51 2,326,098.51- Expenditures Subtotal ----------- 49,633.74 2,326,098.51 2,326,098.51- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 47,560.07 2,310,388.48 2,310,388.48- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/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 1898 06/30/2017 Bank Interest/June (13,636.36) (2,073.67) (15,710.03) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (2,073.67) (15,710.03) ** .00 Budgeted 15,710.03 Remaining 0 % Used Department Totals: ----------------------------------- (15,710.03) ** (2,073.67) Monthly Total .00 Budgeted 15,710.03 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/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 1724 06/14/2017 June A/P WWTP Improvements 2,276,464.77 49,633.74 2,326,098.51 CP&Y/WALLACE GROUP, INC. 3214 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 49,633.74 2,326,098.51 ** .00 Budgeted (2,326,098.51) Remaining 0 % Used Department 20 Totals: ----------------------------------- 2,326,098.51 ** 49,633.74 Monthly Total .00 Budgeted (2,326,098.51) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 2,310,388.48 47,560.07 Monthly Total .00 Budgeted (2,310,388.48) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JUNE 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 15:27 07/13/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 6/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 46 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 6/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 JUNE 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 267,303 ACCOUNTS RECEIVABLE - TOTAL ASSETS 267,303 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 71,541 TOTAL FUND BALANCE 267,303 TOTAL LIABILITIES AND FUND BALANCE 267,303 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 15:27 07/13/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/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- 183.90- 1,047.47- 349.157 747.47 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 3,134.45- 3,134.45- 4.828 61,785.55- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 11,226.55- 67,359.25- 54.545 56,132.75- Subtotal: 188,712.00- 188,712.00- 14,544.90- 71,541.17- 37.910 117,170.83- Program number: 188,712.00- 188,712.00- 14,544.90- 71,541.17- 37.910 117,170.83- Department number: 188,712.00- 188,712.00- 14,544.90- 71,541.17- 37.910 117,170.83- Revenues Subtotal ----------- 188,712.00- 188,712.00- 14,544.90- 71,541.17- 37.910 117,170.83- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 14,544.90- 71,541.17- 37.910 117,170.83- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/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 1898 06/30/2017 Bank Interest/June (863.57) (183.90) (1,047.47) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (183.90) (1,047.47) ** (300.00) Budgeted 747.47 Remaining 349 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1900 06/29/2017 Texpool Transfers (3,134.45) (3,134.45) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (3,134.45) (3,134.45) ** (64,920.00) Budgeted (61,785.55) Remaining 5 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1900 06/29/2017 Texpool Transfers (56,132.70) (11,226.55) (67,359.25) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (11,226.55) (67,359.25) ** (123,492.00) Budgeted (56,132.75) Remaining 55 % Used Department Totals: ----------------------------------- (71,541.17) ** (14,544.90) Monthly Total (188,712.00) Budgeted (117,170.83) Remaining 38 % Used Fund 528 Totals: ----------------------------------- (71,541.17) (14,544.90) Monthly Total (188,712.00) Budgeted (117,170.83) Remaining 38 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET June 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 115,182 ACCOUNTS RECEIVABLE - TOTAL ASSETS 115,182 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 115,182 TOTAL FUND BALANCE 115,182 TOTAL LIABILITIES AND FUND BALANCE 115,182 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 15:27 07/13/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 6/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 83.41- 294.46- 294.46 529-49142-000-000 Interfund transfer in-Water 114,888.00- 114,888.00 Subtotal: 83.41- 115,182.46- 115,182.46 Program number: 83.41- 115,182.46- 115,182.46 Department number: 83.41- 115,182.46- 115,182.46 Revenues Subtotal ----------- 83.41- 115,182.46- 115,182.46 Fund number: 529 2016 Rev Bond Reserve-SWIFT 83.41- 115,182.46- 115,182.46 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 6/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 1898 06/30/2017 Bank Interest/June (211.05) (83.41) (294.46) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (83.41) (294.46) ** .00 Budgeted 294.46 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water (114,888.00) .00 (114,888.00) _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: .00 (114,888.00) ** .00 Budgeted 114,888.00 Remaining 0 % Used Department Totals: ----------------------------------- (115,182.46) ** (83.41) Monthly Total .00 Budgeted 115,182.46 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (115,182.46) (83.41) Monthly Total .00 Budgeted 115,182.46 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JUNE 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 860,416 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,859 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 879,847 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,859 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 14,859 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 838,957 TOTAL FUND BALANCE 864,988 TOTAL LIABILITIES AND FUND BALANCE 879,847 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 15:27 07/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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- 3,009.40- 669,586.66- 99.443 3,749.34- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 271.57- 1,694.95- 48.413 1,806.05- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 272.00- 1,833.36- 91.668 166.64- Subtotal: 678,837.00- 678,837.00- 3,552.97- 673,114.97- 99.157 5,722.03- 533-49010-000-000 Interest Income 140.00- 140.00- 614.61- 2,245.37- 1,603.836 2,105.37 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- 98,584.38- 81.818 21,907.62- Subtotal: 337,386.00- 337,386.00- 11,568.43- 317,583.75- 94.131 19,802.25- Program number: 1,016,223.00- 1,016,223.00- 15,121.40- 990,698.72- 97.488 25,524.28- Department number: Revenues 1,016,223.00- 1,016,223.00- 15,121.40- 990,698.72- 97.488 25,524.28- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 15,121.40- 990,698.72- 97.488 25,524.28- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 15:27 07/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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- 15,121.40- 838,957.47- ############### 835,867.47 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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 1863 06/01/2017 Property Taxes (666,577.26) (68.93) (666,646.19) GL 1864 06/02/2017 Property Taxes (398.36) (667,044.55) GL 1865 06/05/2017 Property Taxes (346.18) (667,390.73) GL 1866 06/06/2017 Property Taxes (910.42) (668,301.15) GL 1867 06/07/2017 Property Taxes (18.79) (668,319.94) GL 1869 06/08/2017 Property Taxes (77.07) (668,397.01) GL 1870 06/09/2017 Property Taxes (237.07) (668,634.08) GL 1871 06/13/2017 Property Taxes (109.89) (668,743.97) GL 1872 06/14/2017 Property Taxes (81.66) (668,825.63) GL 1873 06/15/2017 Property Taxes (3.06) (668,828.69) GL 1874 06/16/2017 Property Taxes (28.11) (668,856.80) GL 1875 06/19/2017 Property Taxes (342.66) (669,199.46) GL 1877 06/21/2017 Property Taxes (10.82) (669,210.28) GL 1878 06/26/2017 Property Taxes (123.43) (669,333.71) GL 1879 06/28/2017 Property Taxes (182.32) (669,516.03) GL 1880 06/29/2017 Property Taxes (5.24) (669,521.27) GL 1881 06/30/2017 Property Taxes (65.39) (669,586.66) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,009.40) (669,586.66) ** (673,336.00) Budgeted (3,749.34) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1863 06/01/2017 Property Taxes (1,423.38) (3.56) (1,426.94) GL 1869 06/08/2017 Property Taxes (.18) (1,427.12) GL 1870 06/09/2017 Property Taxes (180.88) (1,608.00) GL 1874 06/16/2017 Property Taxes (86.63) (1,694.63) GL 1876 06/20/2017 Property Taxes (.32) (1,694.95) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (271.57) (1,694.95) ** (3,501.00) Budgeted (1,806.05) Remaining 48 % Used Account: 533-40015-000-000 Property Taxes/P & I 1863 06/01/2017 Property Taxes (1,561.36) (10.28) (1,571.64) GL 1865 06/05/2017 Property Taxes (16.31) (1,587.95) GL 1866 06/06/2017 Property Taxes (45.66) (1,633.61) GL 1867 06/07/2017 Property Taxes (1.32) (1,634.93) GL 1869 06/08/2017 Property Taxes (11.59) (1,646.52) GL 1870 06/09/2017 Property Taxes (52.10) (1,698.62) GL 1871 06/13/2017 Property Taxes (3.21) (1,701.83) GL 1872 06/14/2017 Property Taxes (6.41) (1,708.24) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1874 06/16/2017 Property Taxes (1,561.36) (37.03) (1,745.27) GL 1875 06/19/2017 Property Taxes (51.41) (1,796.68) GL 1878 06/26/2017 Property Taxes (15.44) (1,812.12) GL 1879 06/28/2017 Property Taxes (19.16) (1,831.28) GL 1881 06/30/2017 Property Taxes (2.08) (1,833.36) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (272.00) (1,833.36) ** (2,000.00) Budgeted (166.64) Remaining 92 % Used Account: 533-49010-000-000 Interest Income 1898 06/30/2017 Bank Interest/June (1,630.76) (614.61) (2,245.37) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (614.61) (2,245.37) ** (140.00) Budgeted 2,105.37 Remaining 1.604 % 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 1900 06/29/2017 Texpool Transfers (87,630.56) (10,953.82) (98,584.38) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (98,584.38) ** (120,492.00) Budgeted (21,907.62) Remaining 82 % Used Department Totals: ----------------------------------- (990,698.72) ** (15,121.40) Monthly Total (1,016,223.00) Budgeted (25,524.28) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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: ----------------------------------- (838,957.47) (15,121.40) Monthly Total (3,090.00) Budgeted 835,867.47 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JUNE 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 387,800 ACCOUNTS RECEIVABLE - TOTAL ASSETS 387,800 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 372,703 TOTAL FUND BALANCE 387,800 TOTAL LIABILITIES AND FUND BALANCE 387,800 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 15:27 07/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/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- 244.44- 881.39- 440.695 681.39 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- 487,340.19- 81.818 108,297.81- Subtotal: 892,849.00- 892,849.00- 54,393.35- 488,221.58- 54.681 404,627.42- Program number: 892,849.00- 892,849.00- 54,393.35- 488,221.58- 54.681 404,627.42- Department number: Revenues 892,849.00- 892,849.00- 54,393.35- 488,221.58- 54.681 404,627.42- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,393.35- 488,221.58- 54.681 404,627.42- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 15:27 07/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 115,518.75 29.800 272,130.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,393.35- 372,702.83- ############### 372,502.83 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/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 1898 06/30/2017 Bank Interest/June (636.95) (244.44) (881.39) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (244.44) (881.39) ** (200.00) Budgeted 681.39 Remaining 441 % 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 1900 06/29/2017 Texpool Transfers (433,191.28) (54,148.91) (487,340.19) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (487,340.19) ** (595,638.00) Budgeted (108,297.81) Remaining 82 % Used Department Totals: ----------------------------------- (488,221.58) ** (54,393.35) Monthly Total (892,849.00) Budgeted (404,627.42) Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/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-70040-051-000 Revenue Bond Interest Expense 115,518.75 .00 115,518.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 115,518.75 ** 387,649.00 Budgeted 272,130.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: ----------------------------------- (372,702.83) (54,393.35) Monthly Total (200.00) Budgeted 372,502.83 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 197,477 ACCOUNTS RECEIVABLE - TOTAL ASSETS 197,477 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 197,477 TOTAL FUND BALANCE 197,477 TOTAL LIABILITIES AND FUND BALANCE 197,477 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 15:27 07/13/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 6/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 128.28- 441.38- 441.38 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 197,035.89- 197,035.89 Subtotal: 22,021.16- 197,477.27- 197,477.27 Program number: 22,021.16- 197,477.27- 197,477.27 Department number: Revenues 22,021.16- 197,477.27- 197,477.27 Revenues Subtotal ----------- 22,021.16- 197,477.27- 197,477.27 Fund number: 535 2016 Rev Bond I&S-SWIFT 22,021.16- 197,477.27- 197,477.27 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 15:27 07/13/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 6/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 1898 06/30/2017 Bank Interest/June (313.10) (128.28) (441.38) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (128.28) (441.38) ** .00 Budgeted 441.38 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1900 06/29/2017 Texpool Transfers (175,143.01) (21,892.88) (197,035.89) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (197,035.89) ** .00 Budgeted 197,035.89 Remaining 0 % Used Department Totals: ----------------------------------- (197,477.27) ** (22,021.16) Monthly Total .00 Budgeted 197,477.27 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (197,477.27) (22,021.16) Monthly Total .00 Budgeted 197,477.27 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (254,870.84) **** (262,159.92) Monthly Total (192,002.00) Budgeted 62,868.84 Remaining 133 % Used ******* End of Report *********