Loading...
HomeMy WebLinkAbout2018-07 July 2018 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 643,886 PREPAID EXPENSES 2,540 ADVALOREM PROPERTY TAXES RECEIVABLE 16,575 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 663,001 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 16,575 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 16,575 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 124,173 TOTAL FUND BALANCE 646,426 TOTAL LIABILITIES AND FUND BALANCE 663,001 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 15:41 08/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 2,936.65- 1,064,692.68- 100.973 10,259.68 122-40011-000-000 Property Taxes/Fire-Delinquent 41.81- 3,945.10- 3,945.10 122-40020-000-000 Property Taxes/Fire P&I 40.09- 4,672.01- 4,672.01 Subtotal: 1,054,433.00- 1,054,433.00- 3,018.55- 1,073,309.79- 101.790 18,876.79 Program number: 1,054,433.00- 1,054,433.00- 3,018.55- 1,073,309.79- 101.790 18,876.79 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 3,018.55- 1,073,309.79- 101.790 18,876.79 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 3,018.55- 1,073,309.79- 101.790 18,876.79 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 15:41 08/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 12,698.70 70.548 5,301.30 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 507,425.00 83.333 101,485.00 Subtotal: 845,864.00 845,864.00 1,269.87 739,077.70 87.375 106,786.30 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: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 1,269.87 949,136.79 90.014 105,296.21 Department number: Fire 1,054,433.00 1,054,433.00 1,269.87 949,136.79 90.014 105,296.21 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 1,269.87 949,136.79 90.014 105,296.21 Fund number: 122 Trophy Club MUD Fire Dept. 1,748.68- 124,173.00- 124,173.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1819 07/02/2018 Property Taxes (1,061,756.03) (50.24) (1,061,806.27) GL 1820 07/03/2018 Property Taxes (33.83) (1,061,840.10) GL 1821 07/05/2018 Property Taxes (52.87) (1,061,892.97) GL 1822 07/06/2018 Property Taxes (116.82) (1,062,009.79) GL 1823 07/09/2018 Property Taxes (100.80) (1,062,110.59) GL 1824 07/10/2018 Property Taxes (70.74) (1,062,181.33) GL 1825 07/11/2018 Property Taxes (286.12) (1,062,467.45) GL 1826 07/12/2018 Property Taxes (85.25) (1,062,552.70) GL 1827 07/13/2018 Property Taxes (90.71) (1,062,643.41) GL 1828 07/16/2018 Property Taxes (173.94) (1,062,817.35) GL 1829 07/17/2018 Property Taxes (38.44) (1,062,855.79) GL 1830 07/18/2018 Property Taxes (81.45) (1,062,937.24) GL 1831 07/19/2018 Property Taxes (237.00) (1,063,174.24) GL 1832 07/20/2018 Property Taxes (131.16) (1,063,305.40) GL 1833 07/23/2018 Property Taxes (279.33) (1,063,584.73) GL 1834 07/24/2018 Property Taxes (31.85) (1,063,616.58) GL 1835 07/25/2018 Property Taxes (121.14) (1,063,737.72) GL 1836 07/26/2018 Property Taxes (61.15) (1,063,798.87) GL 1837 07/27/2018 Property Taxes (320.44) (1,064,119.31) GL 1838 07/30/2018 Property Taxes (138.45) (1,064,257.76) GL 1839 07/31/2018 Property Taxes (434.92) (1,064,692.68) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,936.65) (1,064,692.68) ** (1,054,433.00) Budgeted 10,259.68 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1819 07/02/2018 Property Taxes (3,903.29) (.49) (3,903.78) GL 1820 07/03/2018 Property Taxes (41.32) (3,945.10) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (41.81) (3,945.10) ** .00 Budgeted 3,945.10 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1819 07/02/2018 Property Taxes (4,631.92) (4.22) (4,636.14) GL 1820 07/03/2018 Property Taxes (12.10) (4,648.24) GL 1822 07/06/2018 Property Taxes (4.94) (4,653.18) GL 1831 07/19/2018 Property Taxes (.44) (4,653.62) GL 1833 07/23/2018 Property Taxes (.29) (4,653.91) GL 1835 07/25/2018 Property Taxes (3.50) (4,657.41) GL 1837 07/27/2018 Property Taxes (14.21) (4,671.62) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1838 07/30/2018 Property Taxes (4,631.92) (.39) (4,672.01) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (40.09) (4,672.01) ** .00 Budgeted 4,672.01 Remaining 0 % Used Department Totals: ----------------------------------- (1,073,309.79) ** (3,018.55) Monthly Total (1,054,433.00) Budgeted 18,876.79 Remaining 102 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2018 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 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 218,954.00 .00 218,954.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 241 07/01/2018 Insurance/Wrk Comp Exp Jul 11,428.83 1,269.87 12,698.70 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 12,698.70 ** 18,000.00 Budgeted 5,301.30 Remaining 71 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 507,425.00 .00 507,425.00 _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: .00 507,425.00 ** 608,910.00 Budgeted 101,485.00 Remaining 83 % 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 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: ----------------------------------- 949,136.79 ** 1,269.87 Monthly Total 1,054,433.00 Budgeted 105,296.21 Remaining 90 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- (124,173.00) (1,748.68) Monthly Total .00 Budgeted 124,173.00 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,990,715 - 1,990,715 CASH IN BANK-SAVINGS-CASH RESERVE 782,658 - 782,658 CD-BANK OF THE WEST/THB DEPOSIT - - - INVESTMENTS-MONEY MARKET-BANK OF THE WEST 715,380 - 715,380 INVESTMENTS-TEXPOOL 2,042,759 596,426 2,639,185 PREPAID EXPENSES 20,434 - 20,434 ADVALOREM PROPERTY TAXES RECEIVABLE 1,790 - 1,790 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,467,265 - 1,467,265 TOTAL ASSETS 7,021,600 596,426 7,618,026 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,790 - 1,790 ACCOUNTS AND OTHER PAYABLES 615,106 - 615,106 CUSTOMER DEPOSITS 316,085 - 316,085 - TOTAL LIABILITIES 932,981 - 932,981 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 1,938,251 - 1,938,251 - TOTAL FUND BALANCE 6,088,619 596,426 6,685,045 TOTAL LIABILITIES AND FUND BALANCE 7,021,600 596,426 7,618,026 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 336.81- 122,121.96- 100.969 1,171.96 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 2.46- 347.07- 173.535 147.07 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 4.22- 517.19- 258.595 317.19 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 343.49- 122,986.22- 41.107 176,202.78- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 789,975.32- 4,676,064.63- 72.340 1,787,954.37- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 260,547.69- 2,470,069.85- 82.942 507,997.15- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 10,414.67- 91,382.98- 85.984 14,896.02- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 805.50- 11,405.50- 53.422 9,944.50- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 150.00- 1,950.00- 130.000 450.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 450.00- 5,050.00- 112.222 550.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 16,992.00- 59,112.80- 98.521 887.20- Subtotal: 9,635,715.00- 9,635,715.00- 1,079,335.18- 7,315,035.76- 75.916 2,320,679.24- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 6,411.17- 44,178.88- 368.157 32,178.88 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 9,719.82- 88.960 1,206.18- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,029.00- 12,521.76- 68.880 5,657.24- 135-49141-000-000 Interfund Transfer In 1,851,769.22- 1,851,769.22 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 238.83- 59,240.10- 1,184.802 54,240.10 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 2.00- 10.000 18.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 9,243.14- 1,998,665.08- 634.245 1,683,540.08 Program number: 10,250,029.00- 10,250,029.00- 1,088,921.81- 9,436,687.06- 92.065 813,341.94- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,088,921.81- 9,436,687.06- 92.065 813,341.94- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,088,921.81- 9,436,687.06- 92.065 813,341.94- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 19,878.44 187,915.21 68.512 86,363.79 135-50010-010-000 Overtime 20,000.00 20,000.00 1,729.97 9,797.90 48.990 10,202.10 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 350.00 1,950.00 59.091 1,350.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,031.16 20,184.98 72.496 7,658.02 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,964.73 26,918.16 51.571 25,277.84 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 2,161.99 41.721 3,020.01 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 387.99 39.033 606.01 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 215.61 2,123.93 71.225 858.07 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,344.79 12,500.80 66.985 6,161.20 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 314.50 2,923.57 66.978 1,441.43 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 818.68 75.804 261.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 8,999.20 75.917 2,854.80 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 59.00 285.05 142.525 85.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 30,037.69 280,296.45 65.695 146,365.55 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,982.12 52,991.56 52.992 47,008.44 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 151.09 4,362.27 109.057 362.27- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 1.000 3,465.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 490.00 6,535.16 118.821 1,035.16- Subtotal: 391,000.00 391,000.00 2,623.21 63,923.99 16.349 327,076.01 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.01 3,232.81 68.783 1,467.19 135-60020-010-000 Electricity 175,356.00 175,356.00 14,331.74 109,280.43 62.319 66,075.57 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.00 76.700 233.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 372.00 1,908.78 68.538 876.22 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 6,310.00 23,720.32 42.990 31,455.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 301,162.20 1,545,830.44 54.755 1,277,339.56 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 502.70 16.757 2,497.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 9,000.00 61.017 5,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 252,803.10 90.909 25,280.90 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 40,830.00 83.333 8,166.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 526.968 853,935.08- 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 353,409.26 3,046,926.16 84.312 566,925.84 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 918.99 8,872.61 59.151 6,127.39 135-65010-010-000 Uniforms 4,488.00 4,488.00 1,249.14 27.833 3,238.86 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,517.30 15,967.10 79.836 4,032.90 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 186.00 769.00 76.900 231.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 24,975.75 49.952 25,024.25 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 58.214 35,100.00 Subtotal: 175,688.00 175,688.00 3,622.29 100,733.60 57.337 74,954.40 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 72,295.53- 485,135.89 59.892 324,876.11 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 2,271.24 2,271.24 39.756 3,441.76 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 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 70,024.29- 670,271.51 63.943 377,959.49 Program number: 5,655,433.00 5,655,433.00 319,668.16 4,162,151.71 73.596 1,493,281.29 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 185.00 1,385.08 69.254 614.92 Subtotal: 2,000.00 2,000.00 185.00 1,385.08 69.254 614.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 185.00 1,385.08 69.254 614.92 Department number: Water 5,657,433.00 5,657,433.00 319,853.16 4,163,536.79 73.594 1,493,896.21 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 25,466.07 298,855.60 72.738 112,010.40 135-50010-020-000 Overtime 30,000.00 30,000.00 2,147.71 28,436.96 94.790 1,563.04 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 7,036.00 83.762 1,364.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,619.02 33,065.46 78.274 9,177.54 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,534.62 54,546.64 87.731 7,628.36 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 3,947.96 74.900 1,323.04 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 685.06 61.496 428.94 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 259.37 3,578.39 83.588 702.61 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,576.08 19,619.96 69.294 8,694.04 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 368.61 4,588.54 69.292 2,033.46 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 13,480.00 74.931 4,510.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 109.00 235.00 78.333 65.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 40,559.27 476,624.57 76.065 149,976.43 135-55070-020-000 Independent Labor 20,550.00 20,550.00 2,145.00 10.438 18,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 11,270.12 75,453.47 87.635 10,646.53 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 1,504.38 8,307.98 103.850 307.98- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 395.40 79.080 104.60 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 5,322.11 62,901.70 104.836 2,901.70- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,346.00 26,504.02 88.347 3,495.98 Subtotal: 219,150.00 219,150.00 20,442.61 175,736.35 80.190 43,413.65 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 331.92 4,057.11 86.321 642.89 135-60020-020-000 Electricity 266,709.00 266,709.00 13,701.14 135,537.35 50.818 131,171.65 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 60.00 60.00 20.000 240.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 658.00 11.591 5,019.00 135-60090-020-000 Safety Program 550.00 550.00 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 90.46 5.533 1,544.54 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 41.88 1.047 3,958.12 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 6,960.00 60.000 4,640.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 110,948.10 90.909 11,094.90 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 544,307.20 90.909 54,430.80 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 102,780.00 83.333 20,556.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 120,074.08 463,475.06 231.738 263,475.06- 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 1,438,938.00 211,150.67 1,401,301.41 97.384 37,636.59 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 587.97 7,497.70 59.982 5,002.30 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,774.59 39.798 2,684.41 135-65030-020-000 Chemicals 27,500.00 27,500.00 9,234.23 33.579 18,265.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,389.88 138.988 389.88- 135-65040-020-000 Safety Equipment 750.00 750.00 1,157.50 154.333 407.50- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 952.47 16,596.71 118.548 2,596.71- Subtotal: 60,209.00 60,209.00 1,540.44 37,650.61 62.533 22,558.39 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 106,519.29 19.462 440,807.71 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 3,010.73 3,010.73 39.756 4,562.27 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 3,010.73 139,530.02 21.930 496,711.98 Program number: 2,981,140.00 2,981,140.00 276,703.72 2,230,842.96 74.832 750,297.04 Department number: Wastewater 2,981,140.00 2,981,140.00 276,703.72 2,230,842.96 74.832 750,297.04 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.42 24.20 80.667 5.80 Subtotal: 30.00 30.00 2.42 24.20 80.667 5.80 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,167.57- 91.28 7.607 1,108.72 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,215.00 2,755.00 68.875 1,245.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 4,352.28 87.046 647.72 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,404.26 70.213 595.74 Subtotal: 12,950.00 12,950.00 47.43 9,252.82 71.450 3,697.18 Program number: 12,980.00 12,980.00 49.85 9,277.02 71.472 3,702.98 Department number: Board of Directors 12,980.00 12,980.00 49.85 9,277.02 71.472 3,702.98 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 26,791.04 310,302.38 71.686 122,560.62 135-50010-030-000 Overtime 2,000.00 2,000.00 6.13 563.05 28.153 1,436.95 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,478.73 31,390.12 77.405 9,162.88 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,161.18 39,200.35 61.747 24,284.65 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 2,757.85 50.125 2,744.15 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 504.86 43.040 668.14 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 263.28 3,076.36 60.810 1,982.64 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,582.71 18,720.12 68.872 8,460.88 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 370.17 4,378.09 68.870 1,978.91 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 69.23 1,070.31 84.945 189.69 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,235.00 80.772 294.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 211.90 42.380 288.10 135-50070-030-000 Employee Relations 4,960.00 4,960.00 81.29 3,228.47 65.090 1,731.53 Subtotal: 595,970.00 595,970.00 36,229.29 420,186.36 70.505 175,783.64 135-55030-030-000 Software & Support 78,391.00 78,391.00 1,411.29 63,876.87 81.485 14,514.13 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,248.08 127,948.90 83.084 26,051.10 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 5,160.69 36.862 8,839.31 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 4,624.58 46.246 5,375.42 135-55100-030-000 Building Maint & Supplies 398.00 398.00 398.00- 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 7,438.63 74.386 2,561.37 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 59,240.00 93.549 4,085.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 184.44 5,891.80 65.464 3,108.20 Subtotal: 338,916.00 338,916.00 17,110.87 274,579.47 81.017 64,336.53 135-60005-030-000 Telephone 27,300.00 27,300.00 1,604.06 13,693.87 50.161 13,606.13 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.33 2,511.50 62.788 1,488.50 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,173.49 5,988.92 36.830 10,272.08 135-60025-030-000 Water 2,500.00 2,500.00 68.25 592.26 23.690 1,907.74 135-60030-030-000 Rent And/Or Usage 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 269.55 17,849.47 59.498 12,150.53 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,441.35 49,057.75 88.297 6,502.25 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.36 64,798.60 115.712 8,798.60- 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 12.899 1,393.62 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 160.00 3,988.42 66.474 2,011.58 135-60075-030-000 Meetings 400.00 400.00 80.50 20.125 319.50 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 95.00 3,238.00 42.605 4,362.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 621.81 1,580.52 32.355 3,304.48 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 6.000 2,350.00 135-60235-030-000 Security 2,700.00 2,700.00 250.00 394.00 14.593 2,306.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 100.000 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 15,404.80 181,686.68 72.819 67,819.32 135-65010-030-000 Uniforms 700.00 700.00 273.73 39.104 426.27 135-65055-030-000 Hardware 7,420.00 7,420.00 2,006.68 27.044 5,413.32 135-65085-030-000 Office Supplies 7,000.00 7,000.00 136.40 4,006.92 57.242 2,993.08 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,048.66 102.433 48.66- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 376.67 3,796.71 94.918 203.29 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 513.07 12,276.70 48.872 12,843.30 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 48,354.99 371.961 35,354.99- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 244.88 2,461.74 53.516 2,138.26 Subtotal: 17,600.00 17,600.00 244.88 50,816.73 288.731 33,216.73- Program number: 1,227,112.00 1,227,112.00 69,502.91 939,545.94 76.566 287,566.06 Department number: Administration 1,227,112.00 1,227,112.00 69,502.91 939,545.94 76.566 287,566.06 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 15:41 08/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 18,723.13 117,921.90 86.074 19,078.10 135-55055-039-000 Auditing 24,500.00 24,500.00 25,658.70 104.729 1,158.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 8,683.92 75.869 2,762.08 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 18,723.13 155,232.92 87.828 21,513.08 Program number: 176,746.00 176,746.00 18,723.13 155,232.92 87.828 21,513.08 Department number: Non Departmental 176,746.00 176,746.00 18,723.13 155,232.92 87.828 21,513.08 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 684,832.77 7,498,435.63 74.571 2,556,975.37 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 404,089.04- 1,938,251.43- 995.926 1,743,633.43 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 15:41 08/15/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 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 1819 07/02/2018 Property Taxes (121,785.15) (5.76) (121,790.91) GL 1820 07/03/2018 Property Taxes (3.88) (121,794.79) GL 1821 07/05/2018 Property Taxes (6.06) (121,800.85) GL 1822 07/06/2018 Property Taxes (13.40) (121,814.25) GL 1823 07/09/2018 Property Taxes (11.56) (121,825.81) GL 1824 07/10/2018 Property Taxes (8.11) (121,833.92) GL 1825 07/11/2018 Property Taxes (32.82) (121,866.74) GL 1826 07/12/2018 Property Taxes (9.78) (121,876.52) GL 1827 07/13/2018 Property Taxes (10.40) (121,886.92) GL 1828 07/16/2018 Property Taxes (19.95) (121,906.87) GL 1829 07/17/2018 Property Taxes (4.41) (121,911.28) GL 1830 07/18/2018 Property Taxes (9.34) (121,920.62) GL 1831 07/19/2018 Property Taxes (27.18) (121,947.80) GL 1832 07/20/2018 Property Taxes (15.04) (121,962.84) GL 1833 07/23/2018 Property Taxes (32.04) (121,994.88) GL 1834 07/24/2018 Property Taxes (3.65) (121,998.53) GL 1835 07/25/2018 Property Taxes (13.90) (122,012.43) GL 1836 07/26/2018 Property Taxes (7.01) (122,019.44) GL 1837 07/27/2018 Property Taxes (36.75) (122,056.19) GL 1838 07/30/2018 Property Taxes (15.88) (122,072.07) GL 1839 07/31/2018 Property Taxes (49.89) (122,121.96) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (336.81) (122,121.96) ** (120,950.00) Budgeted 1,171.96 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1819 07/02/2018 Property Taxes (344.61) (.03) (344.64) GL 1820 07/03/2018 Property Taxes (2.43) (347.07) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (2.46) (347.07) ** (200.00) Budgeted 147.07 Remaining 174 % Used Account: 135-40015-000-000 Property Taxes/P & I 1819 07/02/2018 Property Taxes (512.97) (.48) (513.45) GL 1820 07/03/2018 Property Taxes (1.00) (514.45) GL 1822 07/06/2018 Property Taxes (.57) (515.02) GL 1831 07/19/2018 Property Taxes (.06) (515.08) GL 1833 07/23/2018 Property Taxes (.03) (515.11) GL 1835 07/25/2018 Property Taxes (.40) (515.51) GL 1837 07/27/2018 Property Taxes (1.63) (517.14) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1838 07/30/2018 Property Taxes (512.97) (.05) (517.19) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (4.22) (517.19) ** (200.00) Budgeted 317.19 Remaining 259 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1804 07/31/2018 UB 07/31/2018 Billing UB20180731-20180731 User: (3,886,089.31) (789,975.32) (4,676,064.63) UB _______________ Account: 135-47000-000-000 Water Totals: (789,975.32) (4,676,064.63) ** (6,464,019.00) Budgeted (1,787,954.37) Remaining 72 % Used Account: 135-47005-000-000 Sewer 1804 07/31/2018 UB 07/31/2018 Billing UB20180731-20180731 User: (2,209,522.16) (260,547.69) (2,470,069.85) UB _______________ Account: 135-47005-000-000 Sewer Totals: (260,547.69) (2,470,069.85) ** (2,978,067.00) Budgeted (507,997.15) Remaining 83 % Used Account: 135-47025-000-000 Penalties 1710 07/10/2018 UB 07/10/2018 Penalty removal UB20180710-20180710 User: (80,968.31) 36.78 (80,931.53) UB 1724 07/13/2018 UB 07/13/2018 Penalty removal UB20180713-20180713 User: 29.39 (80,902.14) UB 1769 07/23/2018 UB 07/2018 Assess Penalties UB20180723-20180723 User: (10,762.22) (91,664.36) UB 1780 07/25/2018 UB 07/25/2018 Penalty removal UB20180725-20180725 User: 94.60 (91,569.76) UB 1795 07/30/2018 UB 07/30/2018 Penalty removal UB20180730-20180730 User: 186.78 (91,382.98) UB _______________ Account: 135-47025-000-000 Penalties Totals: (10,414.67) (91,382.98) ** (106,279.00) Budgeted (14,896.02) Remaining 86 % Used Account: 135-47030-000-000 Service Charges 1707 07/10/2018 UB 07/2018 Disconnect Fees UB20180710-20180710 User: (10,600.00) (1,000.00) (11,600.00) UB 1759 07/13/2018 UB 07/13/2018 NSF adjustment UB20180713-20180713 User: (25.00) (11,625.00) UB 1767 07/20/2018 UB 07/20/2018 NSF adjustments UB20180720-20180720 User: 219.50 (11,405.50) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47030-000-000 Service Charges Totals: (805.50) (11,405.50) ** (21,350.00) Budgeted (9,944.50) Remaining 53 % Used Account: 135-47035-000-000 Plumbing Inspections 1812 07/11/2018 Permitting-648 Sheldon 648 Sheldon Drive (1,800.00) (50.00) (1,850.00) Ashton Woods Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 30 Katie Lane (50.00) (1,900.00) Drees Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 14 Sadie Court (50.00) (1,950.00) Drees Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,950.00) ** (1,500.00) Budgeted 450.00 Remaining 130 % Used Account: 135-47045-000-000 Sewer Inspections 1812 07/11/2018 Permitting-648 Sheldon 648 Sheldon Drive (4,600.00) (150.00) (4,750.00) Ashton Woods Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 30 Katie Lane (150.00) (4,900.00) Drees Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 14 Sadie Court (150.00) (5,050.00) Drees Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,050.00) ** (4,500.00) Budgeted 550.00 Remaining 112 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1804 07/31/2018 UB 07/31/2018 Billing UB20180731-20180731 User: (42,120.80) (16,992.00) (59,112.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (16,992.00) (59,112.80) ** (60,000.00) Budgeted (887.20) Remaining 99 % Used Account: 135-49010-000-000 Interest Income 1899 07/31/2018 Bank Interest- July (37,767.71) (156.76) (37,924.47) GL 1899 07/31/2018 Bank Interest- July (570.03) (38,494.50) GL 1899 07/31/2018 Bank Interest- July (5,684.38) (44,178.88) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (6,411.17) (44,178.88) ** (12,000.00) Budgeted 32,178.88 Remaining 368 % Used Account: 135-49016-000-000 Cell Tower Revenue 1807 07/30/2018 Cell Tower Rev AT&T July (8,741.01) (978.81) (9,719.82) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (9,719.82) ** (10,926.00) Budgeted (1,206.18) Remaining 89 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 1892 07/31/2018 Town BIlled Invoices 1648-1651 AR 20180731-20180731 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (15,400.00) .00 (15,400.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,400.00) ** (2,000.00) Budgeted 13,400.00 Remaining 770 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1812 07/11/2018 Permitting-648 Sheldon 648 Sheldon Drive (11,492.76) (343.00) (11,835.76) Ashton Woods Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 30 Katie Lane (343.00) (12,178.76) Drees Homes CR 1813 07/24/2018 Permitting-30 Katie & 14 Sadie 14 Sadie Court (343.00) (12,521.76) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,029.00) (12,521.76) ** (18,179.00) Budgeted (5,657.24) Remaining 69 % Used Account: 135-49141-000-000 Interfund Transfer In (1,851,769.22) .00 (1,851,769.22) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (1,851,769.22) ** .00 Budgeted 1,851,769.22 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1804 07/31/2018 UB 07/31/2018 Billing UB20180731-20180731 User: (59,001.27) (238.83) (59,240.10) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (238.83) (59,240.10) ** (5,000.00) Budgeted 54,240.10 Remaining 1.185 % Used Account: 135-49901-000-000 Records Management Revenue 1809 07/30/2018 Public Information Revenue (2.00) (2.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (9,436,687.06) ** (1,088,921.81) Monthly Total (10,250,029.00) Budgeted (813,341.94) Remaining 92 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 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 1708 07/13/2018 MUD PR 7-13-2018 Salaries & Wages 168,036.77 9,939.22 177,975.99 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Salaries & Wages 9,939.22 187,915.21 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,878.44 187,915.21 ** 274,279.00 Budgeted 86,363.79 Remaining 69 % Used Account: 135-50010-010-000 Overtime 1708 07/13/2018 MUD PR 7-13-2018 Overtime 8,067.93 565.68 8,633.61 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Overtime 1,164.29 9,797.90 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,729.97 9,797.90 ** 20,000.00 Budgeted 10,202.10 Remaining 49 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 1774 07/27/2018 MUD Payroll 07/27/2018 Certification 1,600.00 350.00 1,950.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 350.00 1,950.00 ** 3,300.00 Budgeted 1,350.00 Remaining 59 % Used Account: 135-50020-010-000 Retirement 1708 07/13/2018 MUD PR 7-13-2018 Retirement 18,153.82 971.71 19,125.53 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Retirement 1,059.45 20,184.98 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,031.16 20,184.98 ** 27,843.00 Budgeted 7,658.02 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 1708 07/13/2018 MUD PR 7-13-2018 Medical Insurance 23,953.43 1,474.40 25,427.83 PR 1727 07/13/2018 IRS- F720 Health Ins Fee 2018 Form 720- Self-insured Health 15.93 25,443.76 UNITED STATES TREASURY 4388 AP 1774 07/27/2018 MUD Payroll 07/27/2018 Medical Insurance 1,474.40 26,918.16 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,964.73 26,918.16 ** 52,196.00 Budgeted 25,277.84 Remaining 52 % Used Account: 135-50027-010-000 Dental Insurance 1708 07/13/2018 MUD PR 7-13-2018 Dental Insurance 1,948.34 106.85 2,055.19 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Dental Insurance 106.80 2,161.99 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 2,161.99 ** 5,182.00 Budgeted 3,020.01 Remaining 42 % Used Account: 135-50028-010-000 Vision Insurance 1708 07/13/2018 MUD PR 7-13-2018 Vision Insurance 352.07 17.98 370.05 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Vision Insurance 17.94 387.99 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 387.99 ** 994.00 Budgeted 606.01 Remaining 39 % Used Account: 135-50029-010-000 Life Insurance & Other 1592 07/01/2018 July A/P Employee benefits-july 1,908.32 110.60 2,018.92 Humana Inc 4288 AP 1696 07/09/2018 July A/P Employee benefits LTD & STD 87.01 2,105.93 METLIFE GROUP BENEFITS 4350 AP 1772 07/24/2018 July A/P Benefits-Café 125 18.00 2,123.93 BenefitMall 4390 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 2,123.93 ** 2,982.00 Budgeted 858.07 Remaining 71 % Used Account: 135-50030-010-000 Social Security Taxes 1708 07/13/2018 MUD PR 7-13-2018 Social Security Taxes 11,156.01 644.16 11,800.17 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Social Security Taxes 700.63 12,500.80 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,344.79 12,500.80 ** 18,662.00 Budgeted 6,161.20 Remaining 67 % Used Account: 135-50035-010-000 Medicare Taxes 1708 07/13/2018 MUD PR 7-13-2018 Medicare Taxes 2,609.07 150.64 2,759.71 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Medicare Taxes 163.86 2,923.57 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 314.50 2,923.57 ** 4,365.00 Budgeted 1,441.43 Remaining 67 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 818.68 .00 818.68 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 818.68 ** 1,080.00 Budgeted 261.32 Remaining 76 % Used Account: 135-50045-010-000 Workman's Compensation 241 07/01/2018 Insurance/Wrk Comp Exp Jul 8,099.28 899.92 8,999.20 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 8,999.20 ** 11,854.00 Budgeted 2,854.80 Remaining 76 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1869 07/31/2018 July A/P Department MVRS 226.05 59.00 285.05 FIRST CHECK APPLICANT SCREENIN 4439 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 59.00 285.05 ** 200.00 Budgeted (85.05) Remaining 143 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1696 07/09/2018 July A/P AC Pump room 51,009.44 200.00 51,209.44 BRANDON R REED 4320 AP 1735 07/16/2018 July A/P antenna on elevated tank 1,498.41 52,707.85 DHS AUTOMATION, INC 4378 AP 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 12.00 52,719.85 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 50.01 52,769.86 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 36.10 52,805.96 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 179.40 52,985.36 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 6.20 52,991.56 THE HOME DEPOT #6581 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,982.12 52,991.56 ** 100,000.00 Budgeted 47,008.44 Remaining 53 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 ROANOKE AUTO SUPPLY LT 4,211.18 20.00 4,231.18 ROANOKE AUTO SUPPLY LT PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 GIERISCH CARE 0050292 131.09 4,362.27 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 151.09 4,362.27 ** 4,000.00 Budgeted (362.27) Remaining 109 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 35.00 .00 35.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 35.00 ** 3,500.00 Budgeted 3,465.00 Remaining 1 % Used Account: 135-55135-010-000 Lab Analysis 1735 07/16/2018 July A/P Water samples 6,045.16 200.00 6,245.16 TARRANT CTY PUBLIC HEALTH LAB 4385 AP 1869 07/31/2018 July A/P Water samples 290.00 6,535.16 TARRANT CTY PUBLIC HEALTH LAB 4462 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 490.00 6,535.16 ** 5,500.00 Budgeted (1,035.16) Remaining 119 % Used Account: 135-60010-010-000 Communications/Mobiles 1772 07/24/2018 July A/P Cell phones 2,862.80 370.01 3,232.81 VERIZON WIRELESS 4403 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.01 3,232.81 ** 4,700.00 Budgeted 1,467.19 Remaining 69 % Used Account: 135-60020-010-000 Electricity . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1772 07/24/2018 July A/P Electricity 6/8-7/11 94,948.69 14,331.74 109,280.43 HUDSON ENERGY SERVICES, LLC 4395 AP _______________ Account: 135-60020-010-000 Electricity Totals: 14,331.74 109,280.43 ** 175,356.00 Budgeted 66,075.57 Remaining 62 % 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 ** 1,000.00 Budgeted 233.00 Remaining 77 % 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 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 TCEQ IND RENEWAL L 1,536.78 111.00 1,647.78 TCEQ IND RENEWAL L PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 TCEQ EPAYMENT 111.00 1,758.78 TCEQ EPAYMENT PC 1796 07/30/2018 July A/P petty cash reimbursement-Nicol 75.00 1,833.78 TROPHY CLUB MUD PETTY CASH 4419 AP 1796 07/30/2018 July A/P petty cash reimbursement-Steve 75.00 1,908.78 TROPHY CLUB MUD PETTY CASH 4419 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 372.00 1,908.78 ** 2,785.00 Budgeted 876.22 Remaining 69 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-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 1897 07/31/2018 July A/P Well water charge 17,410.32 6,310.00 23,720.32 North Texas Groundwater 4456 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 6,310.00 23,720.32 ** 55,176.00 Budgeted 31,455.68 Remaining 43 % Used Account: 135-60150-010-000 Wholesale Water 1796 07/30/2018 July A/P Wholesale water 1,244,668.24 301,162.20 1,545,830.44 CITY OF FORT WORTH 4406 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 301,162.20 1,545,830.44 ** 2,823,170.00 Budgeted 1,277,339.56 Remaining 55 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 502.70 .00 502.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 502.70 ** 3,000.00 Budgeted 2,497.30 Remaining 17 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1843 07/31/2018 July A/P July mowing 7,500.00 1,500.00 9,000.00 WATTS ELLISON LLC 4473 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 9,000.00 ** 14,750.00 Budgeted 5,750.00 Remaining 61 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1870 07/31/2018 Texpool Transfers July 227,522.79 25,280.31 252,803.10 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 252,803.10 ** 278,084.00 Budgeted 25,280.90 Remaining 91 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1870 07/31/2018 Texpool Transfers July 36,747.00 4,083.00 40,830.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 40,830.00 ** 48,996.00 Budgeted 8,166.00 Remaining 83 % Used Account: 135-60334-010-000 Interfund Transfer Out 1,053,935.08 .00 1,053,935.08 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 1,053,935.08 ** 200,000.00 Budgeted (853,935.08) Remaining 527 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 1796 07/30/2018 July A/P fuel 7,953.62 918.99 8,872.61 US Bank Voyager Fleet Systems 4420 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 918.99 8,872.61 ** 15,000.00 Budgeted 6,127.39 Remaining 59 % Used Account: 135-65010-010-000 Uniforms 1,249.14 .00 1,249.14 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,249.14 ** 4,488.00 Budgeted 3,238.86 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1735 07/16/2018 July A/P Lab supplies 13,449.80 649.75 14,099.55 HACH COMPANY 4379 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1796 07/30/2018 July A/P chemicals 13,449.80 982.59 15,082.14 HACH COMPANY 4410 AP 1796 07/30/2018 July A/P chlorine 884.96 15,967.10 DPC INDUSTRIES, INC 4408 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,517.30 15,967.10 ** 20,000.00 Budgeted 4,032.90 Remaining 80 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 TX AMERICA SAFETY 583.00 (15.35) 567.65 TX AMERICA SAFETY PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 TX AMERICA SAFETY 201.35 769.00 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 186.00 769.00 ** 1,000.00 Budgeted 231.00 Remaining 77 % Used Account: 135-65050-010-000 Meter Expense 24,975.75 .00 24,975.75 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 24,975.75 ** 50,000.00 Budgeted 25,024.25 Remaining 50 % Used Account: 135-65053-010-000 Meter Change Out Program 48,900.00 .00 48,900.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,900.00 ** 84,000.00 Budgeted 35,100.00 Remaining 58 % Used Account: 135-69005-010-000 Capital Outlays 1772 07/24/2018 July A/P 16" water line phase 2 557,431.42 19,835.20 577,266.62 Halff Associates, INC 4392 AP 1772 07/24/2018 July A/P 16" water line 34,627.00 611,893.62 La Banda, LLC 4397 AP 1875 07/31/2018 July A/P Water main line repairs 8,600.00 620,493.62 TEAGUE, NALL & PERKINS,INC 4464 AP 1877 07/31/2018 July A/P Meadowbrook & Sundance water l 2,250.00 622,743.62 TEAGUE, NALL & PERKINS,INC 4464 AP 1897 07/31/2018 July A/P 16" water line phase II 6,323.40 629,067.02 Halff Associates, INC 4440 AP 1897 07/31/2018 July A/P 16" water line phase II 29,627.81 658,694.83 Halff Associates, INC 4440 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1905 07/31/2018 Due To/Due From MUD-Fund 520 557,431.42 (173,558.94) 485,135.89 GL _______________ Account: 135-69005-010-000 Capital Outlays Totals: (72,295.53) 485,135.89 ** 810,012.00 Budgeted 324,876.11 Remaining 60 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1796 07/30/2018 July A/P VACCON Interest payment 2,271.24 2,271.24 FIRST FINANCIAL BANK 4409 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 2,271.24 2,271.24 ** 5,713.00 Budgeted 3,441.76 Remaining 40 % 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 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/2018 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 1735 07/16/2018 July A/P Water samples 1,200.08 105.00 1,305.08 TARRANT CTY PUBLIC HEALTH LAB 4385 AP 1869 07/31/2018 July A/P Water samples-PID 80.00 1,385.08 TARRANT CTY PUBLIC HEALTH LAB 4462 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 185.00 1,385.08 ** 2,000.00 Budgeted 614.92 Remaining 69 % Used Department 10 Totals: ----------------------------------- 4,163,536.79 ** 319,853.16 Monthly Total 5,657,433.00 Budgeted 1,493,896.21 Remaining 74 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 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 1708 07/13/2018 MUD PR 7-13-2018 Salaries & Wages 273,389.53 12,797.40 286,186.93 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Salaries & Wages 12,668.67 298,855.60 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,466.07 298,855.60 ** 410,866.00 Budgeted 112,010.40 Remaining 73 % Used Account: 135-50010-020-000 Overtime 1708 07/13/2018 MUD PR 7-13-2018 Overtime 26,289.25 1,050.88 27,340.13 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Overtime 1,096.83 28,436.96 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,147.71 28,436.96 ** 30,000.00 Budgeted 1,563.04 Remaining 95 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1774 07/27/2018 MUD Payroll 07/27/2018 Certification 6,336.00 700.00 7,036.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 7,036.00 ** 8,400.00 Budgeted 1,364.00 Remaining 84 % Used Account: 135-50020-020-000 Retirement 1708 07/13/2018 MUD PR 7-13-2018 Retirement 30,446.44 1,280.98 31,727.42 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Retirement 1,338.04 33,065.46 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,619.02 33,065.46 ** 42,243.00 Budgeted 9,177.54 Remaining 78 % Used Account: 135-50026-020-000 Medical Insurance 1708 07/13/2018 MUD PR 7-13-2018 Medical Insurance 49,012.02 2,759.36 51,771.38 PR 1727 07/13/2018 IRS- F720 Health Ins Fee 2018 Form 720- Self-insured Health 15.93 51,787.31 UNITED STATES TREASURY 4388 AP 1774 07/27/2018 MUD Payroll 07/27/2018 Medical Insurance 2,759.33 54,546.64 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,534.62 54,546.64 ** 62,175.00 Budgeted 7,628.36 Remaining 88 % Used Account: 135-50027-020-000 Dental Insurance 1708 07/13/2018 MUD PR 7-13-2018 Dental Insurance 3,576.07 185.96 3,762.03 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Dental Insurance 185.93 3,947.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 3,947.96 ** 5,271.00 Budgeted 1,323.04 Remaining 75 % Used Account: 135-50028-020-000 Vision Insurance 1708 07/13/2018 MUD PR 7-13-2018 Vision Insurance 626.16 29.46 655.62 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Vision Insurance 29.44 685.06 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 685.06 ** 1,114.00 Budgeted 428.94 Remaining 61 % Used Account: 135-50029-020-000 Life Insurance & Other 1592 07/01/2018 July A/P Employee benefits-july 3,319.02 136.36 3,455.38 Humana Inc 4288 AP 1696 07/09/2018 July A/P Employee benefits LTD & STD 87.01 3,542.39 METLIFE GROUP BENEFITS 4350 AP 1772 07/24/2018 July A/P Benefits-Café 125 36.00 3,578.39 BenefitMall 4390 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 259.37 3,578.39 ** 4,281.00 Budgeted 702.61 Remaining 84 % Used Account: 135-50030-020-000 Social Security Taxes 1708 07/13/2018 MUD PR 7-13-2018 Social Security Taxes 18,043.88 780.99 18,824.87 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Social Security Taxes 795.09 19,619.96 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,576.08 19,619.96 ** 28,314.00 Budgeted 8,694.04 Remaining 69 % Used Account: 135-50035-020-000 Medicare Taxes 1708 07/13/2018 MUD PR 7-13-2018 Medicare Taxes 4,219.93 182.66 4,402.59 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Medicare Taxes 185.95 4,588.54 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 368.61 4,588.54 ** 6,622.00 Budgeted 2,033.46 Remaining 69 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 241 07/01/2018 Insurance/Wrk Comp Exp Jul 12,132.00 1,348.00 13,480.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 13,480.00 ** 17,990.00 Budgeted 4,510.00 Remaining 75 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1735 07/16/2018 July A/P Employment drug screen-Desiree 126.00 38.00 164.00 CARENOW CORPORATE 4374 AP 1869 07/31/2018 July A/P Department MVRS 71.00 235.00 FIRST CHECK APPLICANT SCREENIN 4439 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 109.00 235.00 ** 300.00 Budgeted 65.00 Remaining 78 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 2,145.00 .00 2,145.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 2,145.00 ** 20,550.00 Budgeted 18,405.00 Remaining 10 % Used Account: 135-55080-020-000 Maintenance & Repairs 1735 07/16/2018 July A/P Breaker for effluent pump 64,183.35 823.25 65,006.60 DHS AUTOMATION, INC 4378 AP 1735 07/16/2018 July A/P 3" ball valves 556.08 65,562.68 Core & Main LP 4376 AP 1772 07/24/2018 July A/P Bags 1,200.00 66,762.68 Huber Technology Inc 4393 AP 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 35.22 66,797.90 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 45.14 66,843.04 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 UV DOCTOR LAMPS 301.51 67,144.55 UV DOCTOR LAMPS PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 FILTER ELEMENT STORE 64,183.35 676.74 67,821.29 FILTER ELEMENT STORE PC 1796 07/30/2018 July A/P petty cash reimbursement-Steve 3.00 67,824.29 TROPHY CLUB MUD PETTY CASH 4419 AP 1843 07/31/2018 July A/P Ladder LS #1 3,214.18 71,038.47 REY-MAR CONSTRUCTION 4460 AP 1843 07/31/2018 July A/P Fix Effluent valve 4,415.00 75,453.47 REY-MAR CONSTRUCTION 4460 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 11,270.12 75,453.47 ** 86,100.00 Budgeted 10,646.53 Remaining 88 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 KWIK KAR LUBE & TUNE O 6,803.60 76.56 6,880.16 KWIK KAR LUBE & TUNE O PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 DENTON COUNTY, TX SOUT 1.00 6,881.16 DENTON COUNTY, TX SOUT PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 DENTON COUNTY, TX SOUT 7.50 6,888.66 DENTON COUNTY, TX SOUT PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 KWIK KAR LUBE & TUNE O 394.84 7,283.50 KWIK KAR LUBE & TUNE O PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 KWIK KAR LUBE & TUNE O (29.18) 7,254.32 KWIK KAR LUBE & TUNE O PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 MUSTANG ELITE CAR 93.50 7,347.82 MUSTANG ELITE CAR PC 1843 07/31/2018 July A/P vAC TRUCK TIRES 960.16 8,307.98 BLAGG TIRE & SERVICE 4425 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,504.38 8,307.98 ** 8,000.00 Budgeted (307.98) Remaining 104 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 395.40 .00 395.40 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 395.40 ** 500.00 Budgeted 104.60 Remaining 79 % Used Account: 135-55125-020-000 Dumpster Services 1772 07/24/2018 July A/P Dumpster service 57,579.59 924.73 58,504.32 L.H. CHANEY MATERIALS, INC. 4396 AP 1796 07/30/2018 July A/P sludge haul off 1,690.00 60,194.32 L.H. CHANEY MATERIALS, INC. 4414 AP 1796 07/30/2018 July A/P sludge haul off 1,017.38 61,211.70 L.H. CHANEY MATERIALS, INC. 4414 AP 1796 07/30/2018 July A/P sludge haul off 845.00 62,056.70 L.H. CHANEY MATERIALS, INC. 4414 AP 1843 07/31/2018 July A/P Dumpster services 845.00 62,901.70 L.H. CHANEY MATERIALS, INC. 4450 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,322.11 62,901.70 ** 60,000.00 Budgeted (2,901.70) Remaining 105 % Used Account: 135-55135-020-000 Lab Analysis 1696 07/09/2018 July A/P Lab testing 24,158.02 246.00 24,404.02 OXIDOR LABORATORIES LLC 4355 AP 1696 07/09/2018 July A/P lab testing 176.00 24,580.02 OXIDOR LABORATORIES LLC 4355 AP 1735 07/16/2018 July A/P Lab testing 246.00 24,826.02 OXIDOR LABORATORIES LLC 4384 AP 1772 07/24/2018 July A/P lab testing 246.00 25,072.02 OXIDOR LABORATORIES LLC 4400 AP 1772 07/24/2018 July A/P lab testing 176.00 25,248.02 OXIDOR LABORATORIES LLC 4400 AP 1772 07/24/2018 July A/P lab testing 246.00 25,494.02 OXIDOR LABORATORIES LLC 4400 AP 1772 07/24/2018 July A/P lab testing 176.00 25,670.02 OXIDOR LABORATORIES LLC 4400 AP 1796 07/30/2018 July A/P lab testing 246.00 25,916.02 OXIDOR LABORATORIES LLC 4417 AP 1796 07/30/2018 July A/P lab testing 176.00 26,092.02 OXIDOR LABORATORIES LLC 4417 AP 1843 07/31/2018 July A/P LAB TESTING 176.00 26,268.02 OXIDOR LABORATORIES LLC 4457 AP 1843 07/31/2018 July A/P lAB TESTING 236.00 26,504.02 OXIDOR LABORATORIES LLC 4457 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,346.00 26,504.02 ** 30,000.00 Budgeted 3,495.98 Remaining 88 % Used Account: 135-60010-020-000 Communications/Mobiles 1772 07/24/2018 July A/P Cell phones 3,725.19 331.92 4,057.11 VERIZON WIRELESS 4403 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 331.92 4,057.11 ** 4,700.00 Budgeted 642.89 Remaining 86 % Used Account: 135-60020-020-000 Electricity 1735 07/16/2018 July A/P Electricity 5/24-6/25 121,836.21 307.46 122,143.67 TRI COUNTY ELECTRIC 4387 AP 1735 07/16/2018 July A/P Electricity 5/24-6/25 28.07 122,171.74 TRI COUNTY ELECTRIC 4387 AP 1772 07/24/2018 July A/P Electricity 5/24-6/25 178.81 122,350.55 TRI COUNTY ELECTRIC 4401 AP 1772 07/24/2018 July A/P Electricity 6/8-7/11 12,924.17 135,274.72 HUDSON ENERGY SERVICES, LLC 4395 AP 1890 07/31/2018 July A/P Electricity 6/25-7/24 179.25 135,453.97 TRI COUNTY ELECTRIC 4466 AP 1890 07/31/2018 July A/P Electricity 6/25-7/24 278.92 135,732.89 TRI COUNTY ELECTRIC 4466 AP 1890 07/31/2018 July A/P Electricity 6/25-7/24 27.79 135,760.68 TRI COUNTY ELECTRIC 4466 AP 1892 07/31/2018 Town BIlled Invoices 1648-1651 AR 20180731-20180731 User: (223.33) 135,537.35 AR _______________ Account: 135-60020-020-000 Electricity Totals: 13,701.14 135,537.35 ** 266,709.00 Budgeted 131,171.65 Remaining 51 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 SAMS CLUB #6781 15.00 15.00 SAMS CLUB #6781 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 SAMS CLUB #6781 45.00 60.00 SAMS CLUB #6781 PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 60.00 60.00 ** 300.00 Budgeted 240.00 Remaining 20 % Used Account: 135-60080-020-000 Schools & Training 658.00 .00 658.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 658.00 ** 5,677.00 Budgeted 5,019.00 Remaining 12 % Used Account: 135-60090-020-000 Safety Program 351.72 .00 351.72 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 90.46 .00 90.46 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 90.46 ** 1,635.00 Budgeted 1,544.54 Remaining 6 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 41.88 .00 41.88 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 41.88 ** 4,000.00 Budgeted 3,958.12 Remaining 1 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1843 07/31/2018 July A/P July mowing 5,780.00 1,180.00 6,960.00 WATTS ELLISON LLC 4473 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 6,960.00 ** 11,600.00 Budgeted 4,640.00 Remaining 60 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1870 07/31/2018 Texpool Transfers July 99,853.29 11,094.81 110,948.10 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 110,948.10 ** 122,043.00 Budgeted 11,094.90 Remaining 91 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1870 07/31/2018 Texpool Transfers July 489,876.48 54,430.72 544,307.20 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 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,430.72 544,307.20 ** 598,738.00 Budgeted 54,430.80 Remaining 91 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1870 07/31/2018 Texpool Transfers July 92,502.00 10,278.00 102,780.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 102,780.00 ** 123,336.00 Budgeted 20,556.00 Remaining 83 % Used Account: 135-60334-020-000 Interfund Transfer Out 1870 07/31/2018 Texpool Transfers July 343,400.98 120,074.08 463,475.06 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 120,074.08 463,475.06 ** 200,000.00 Budgeted (263,475.06) Remaining 232 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,762.00 .00 1,762.00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 1796 07/30/2018 July A/P fuel 6,909.73 587.97 7,497.70 US Bank Voyager Fleet Systems 4420 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 587.97 7,497.70 ** 12,500.00 Budgeted 5,002.30 Remaining 60 % Used Account: 135-65010-020-000 Uniforms 1,774.59 .00 1,774.59 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,774.59 ** 4,459.00 Budgeted 2,684.41 Remaining 40 % Used Account: 135-65030-020-000 Chemicals 9,234.23 .00 9,234.23 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: .00 9,234.23 ** 27,500.00 Budgeted 18,265.77 Remaining 34 % Used Account: 135-65035-020-000 Small Tools 1,389.88 .00 1,389.88 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 1,389.88 ** 1,000.00 Budgeted (389.88) Remaining 139 % Used Account: 135-65040-020-000 Safety Equipment 1,157.50 .00 1,157.50 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 1,157.50 ** 750.00 Budgeted (407.50) Remaining 154 % Used Account: 135-65045-020-000 Lab Supplies 1696 07/09/2018 July A/P Lab supplies 15,644.24 197.77 15,842.01 IDEXX DISTRIBUTION, INC 4339 AP 1735 07/16/2018 July A/P Lab supplies 298.43 16,140.44 HACH COMPANY 4379 AP 1796 07/30/2018 July A/P latex gloves 152.00 16,292.44 LOU'S GLOVES INCORPORATED 4415 AP 1796 07/30/2018 July A/P lab supplies 304.27 16,596.71 HACH COMPANY 4410 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 952.47 16,596.71 ** 14,000.00 Budgeted (2,596.71) Remaining 119 % Used Account: 135-69005-020-000 Capital Outlays 106,519.29 .00 106,519.29 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 106,519.29 ** 547,327.00 Budgeted 440,807.71 Remaining 19 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1796 07/30/2018 July A/P VACCON Interest payment 3,010.73 3,010.73 FIRST FINANCIAL BANK 4409 AP _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 3,010.73 3,010.73 ** 7,573.00 Budgeted 4,562.27 Remaining 40 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 2,230,842.96 ** 276,703.72 Monthly Total 2,981,140.00 Budgeted 750,297.04 Remaining 75 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2018 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 241 07/01/2018 Insurance/Wrk Comp Exp Jul 21.78 2.42 24.20 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 24.20 ** 30.00 Budgeted 5.80 Remaining 81 % 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 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 TOM THUMB #1789 1,258.85 37.94 1,296.79 TOM THUMB #1789 PC 1796 07/30/2018 July A/P petty cash reimbursement-Nicol 9.49 1,306.28 TROPHY CLUB MUD PETTY CASH 4419 AP 1742 07/30/2018 Corrected JE Accounts Correcting Pcard coding- Train (1,215.00) 91.28 GL _______________ Account: 135-60075-026-000 Meetings Totals: (1,167.57) 91.28 ** 1,200.00 Budgeted 1,108.72 Remaining 8 % Used Account: 135-60080-026-000 Schools & Training 1742 07/30/2018 Corrected JE Accounts AWBD 3@ 405 each 1,540.00 1,215.00 2,755.00 GL _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,215.00 2,755.00 ** 4,000.00 Budgeted 1,245.00 Remaining 69 % Used Account: 135-60100-026-000 Travel & per diem 4,352.28 .00 4,352.28 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 4,352.28 ** 5,000.00 Budgeted 647.72 Remaining 87 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2018 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 1,404.26 .00 1,404.26 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,404.26 ** 2,000.00 Budgeted 595.74 Remaining 70 % Used Department 26 Totals: ----------------------------------- 9,277.02 ** 49.85 Monthly Total 12,980.00 Budgeted 3,702.98 Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 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 1708 07/13/2018 MUD PR 7-13-2018 Salaries & Wages 283,511.34 13,394.87 296,906.21 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Salaries & Wages 13,396.17 310,302.38 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 26,791.04 310,302.38 ** 432,863.00 Budgeted 122,560.62 Remaining 72 % Used Account: 135-50010-030-000 Overtime 1708 07/13/2018 MUD PR 7-13-2018 Overtime 556.92 6.13 563.05 PR _______________ Account: 135-50010-030-000 Overtime Totals: 6.13 563.05 ** 2,000.00 Budgeted 1,436.95 Remaining 28 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1708 07/13/2018 MUD PR 7-13-2018 Retirement 28,911.39 1,239.61 30,151.00 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Retirement 1,239.12 31,390.12 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,478.73 31,390.12 ** 40,553.00 Budgeted 9,162.88 Remaining 77 % Used Account: 135-50026-030-000 Medical Insurance 1708 07/13/2018 MUD PR 7-13-2018 Medical Insurance 35,039.17 2,072.63 37,111.80 PR 1727 07/13/2018 IRS- F720 Health Ins Fee 2018 Form 720- Self-insured Health 15.94 37,127.74 UNITED STATES TREASURY 4388 AP 1774 07/27/2018 MUD Payroll 07/27/2018 Medical Insurance 2,072.61 39,200.35 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,161.18 39,200.35 ** 63,485.00 Budgeted 24,284.65 Remaining 62 % Used Account: 135-50027-030-000 Dental Insurance 1708 07/13/2018 MUD PR 7-13-2018 Dental Insurance 2,498.33 129.78 2,628.11 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Dental Insurance 129.74 2,757.85 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 2,757.85 ** 5,502.00 Budgeted 2,744.15 Remaining 50 % Used Account: 135-50028-030-000 Vision Insurance 1708 07/13/2018 MUD PR 7-13-2018 Vision Insurance 462.35 21.28 483.63 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Vision Insurance 21.23 504.86 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 504.86 ** 1,173.00 Budgeted 668.14 Remaining 43 % Used Account: 135-50029-030-000 Life Insurance & Other 1592 07/01/2018 July A/P Employee benefits-july 2,813.08 145.04 2,958.12 Humana Inc 4288 AP 1696 07/09/2018 July A/P Employee benefits LTD & STD 100.24 3,058.36 METLIFE GROUP BENEFITS 4350 AP 1772 07/24/2018 July A/P Benefits-Café 125 18.00 3,076.36 BenefitMall 4390 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 263.28 3,076.36 ** 5,059.00 Budgeted 1,982.64 Remaining 61 % Used Account: 135-50030-030-000 Social Security Taxes 1708 07/13/2018 MUD PR 7-13-2018 Social Security Taxes 17,137.41 792.81 17,930.22 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Social Security Taxes 789.90 18,720.12 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,582.71 18,720.12 ** 27,181.00 Budgeted 8,460.88 Remaining 69 % Used Account: 135-50035-030-000 Medicare Taxes 1708 07/13/2018 MUD PR 7-13-2018 Medicare Taxes 4,007.92 185.44 4,193.36 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Medicare Taxes 184.73 4,378.09 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 370.17 4,378.09 ** 6,357.00 Budgeted 1,978.91 Remaining 69 % Used Account: 135-50040-030-000 Unemployment Taxes 1708 07/13/2018 MUD PR 7-13-2018 Unemployment Taxes 1,001.08 34.61 1,035.69 PR 1774 07/27/2018 MUD Payroll 07/27/2018 Unemployment Taxes 34.62 1,070.31 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 69.23 1,070.31 ** 1,260.00 Budgeted 189.69 Remaining 85 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 241 07/01/2018 Insurance/Wrk Comp Exp Jul 1,111.50 123.50 1,235.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 1,235.00 ** 1,529.00 Budgeted 294.00 Remaining 81 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 211.90 .00 211.90 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 211.90 ** 500.00 Budgeted 288.10 Remaining 42 % Used Account: 135-50070-030-000 Employee Relations 1796 07/30/2018 July A/P petty cash reimbursement-Nicol 3,147.18 30.43 3,177.61 TROPHY CLUB MUD PETTY CASH 4419 AP 1796 07/30/2018 July A/P petty cash reimbursement-Steve 35.46 3,213.07 TROPHY CLUB MUD PETTY CASH 4419 AP 1796 07/30/2018 July A/P petty cash reimbursement-Steve 15.40 3,228.47 TROPHY CLUB MUD PETTY CASH 4419 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 81.29 3,228.47 ** 4,960.00 Budgeted 1,731.53 Remaining 65 % Used Account: 135-55030-030-000 Software & Support 1696 07/09/2018 July A/P July Internet 62,465.58 903.72 63,369.30 Charter Communications 4322 AP 1735 07/16/2018 July A/P Office 365 credentials and ema 456.00 63,825.30 M3 Networks 4383 AP 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 DNH*GODADDY.COM 35.34 63,860.64 DNH*GODADDY.COM PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 ADOBE SYSTEMS INC 16.23 63,876.87 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,411.29 63,876.87 ** 78,391.00 Budgeted 14,514.13 Remaining 81 % Used Account: 135-55070-030-000 Independent Labor 1881 07/31/2018 July A/P F19 Budget consulting 113,700.82 595.00 114,295.82 DRG ENTERPRISES 4435 AP 1883 07/31/2018 July A/P GM-July 13,640.00 127,935.82 Carman Consulting LLC. 4428 AP 1883 07/31/2018 July A/P GM-July 13.08 127,948.90 Carman Consulting LLC. 4428 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,248.08 127,948.90 ** 154,000.00 Budgeted 26,051.10 Remaining 83 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 5,160.69 .00 5,160.69 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 5,160.69 ** 14,000.00 Budgeted 8,839.31 Remaining 37 % Used Account: 135-55085-030-000 Generator Maint. and Repair 4,624.58 .00 4,624.58 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 4,624.58 ** 10,000.00 Budgeted 5,375.42 Remaining 46 % Used Account: 135-55100-030-000 Building Maint & Supplies 1735 07/16/2018 July A/P Fire Extinguisher Inspection 398.00 398.00 All Test Service Solutions LLC 4373 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 398.00 398.00 ** .00 Budgeted (398.00) Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 1772 07/24/2018 July A/P Janitorial services-June 6,569.57 869.06 7,438.63 MEMBER'S BUILDING MAINTENANCE 4398 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 7,438.63 ** 10,000.00 Budgeted 2,561.37 Remaining 74 % Used Account: 135-55160-030-000 Professional Outside Services 59,240.00 .00 59,240.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 59,240.00 ** 63,325.00 Budgeted 4,085.00 Remaining 94 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1869 07/31/2018 July A/P July billings 5,707.36 184.44 5,891.80 DATAPROSE LLC 4432 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 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 Totals: 184.44 5,891.80 ** 9,000.00 Budgeted 3,108.20 Remaining 65 % Used Account: 135-60005-030-000 Telephone 1735 07/16/2018 July A/P Answering service 12,089.81 194.75 12,284.56 KEYSTONE PARK SECRETARIAL 4382 AP 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 RINGCENTRAL, INC 13.95 12,298.51 RINGCENTRAL, INC PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 ATT*BUS PHONE PMT 455.73 12,754.24 ATT*BUS PHONE PMT PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 ATT*BUS PHONE PMT 856.06 13,610.30 ATT*BUS PHONE PMT PC 1883 07/31/2018 July A/P Answering service-July 263.57 13,873.87 KEYSTONE PARK SECRETARIAL 4448 AP 1892 07/31/2018 Town BIlled Invoices 1648-1651 AR 20180731-20180731 User: (180.00) 13,693.87 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,604.06 13,693.87 ** 27,300.00 Budgeted 13,606.13 Remaining 50 % Used Account: 135-60010-030-000 Communications/Mobiles 1772 07/24/2018 July A/P Cell phones 2,274.17 87.33 2,361.50 VERIZON WIRELESS 4403 AP 1774 07/27/2018 MUD Payroll 07/27/2018 Communications/Mobiles 150.00 2,511.50 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.33 2,511.50 ** 4,000.00 Budgeted 1,488.50 Remaining 63 % Used Account: 135-60020-030-000 Electricity/Gas 1890 07/31/2018 July A/P Electricity admin 5/9-6/8 & 6/ 4,815.43 1,173.49 5,988.92 TOWN OF TROPHY CLUB 4465 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,173.49 5,988.92 ** 16,261.00 Budgeted 10,272.08 Remaining 37 % Used Account: 135-60025-030-000 Water 1843 07/31/2018 July A/P july water 524.01 136.50 660.51 TROPHY CLUB MUD (WATER BILLS) 4467 AP 1892 07/31/2018 Town BIlled Invoices 1648-1651 AR 20180731-20180731 User: (68.25) 592.26 AR _______________ Account: 135-60025-030-000 Water Totals: 68.25 592.26 ** 2,500.00 Budgeted 1,907.74 Remaining 24 % Used Account: 135-60030-030-000 Rent And/Or Usage 1742 07/30/2018 Corrected JE Accounts 616.40 (616.40) .00 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: (616.40) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60035-030-000 Postage 1772 07/24/2018 July A/P Postage lease 17,579.92 97.65 17,677.57 U.S. Postal Service (CMRS-FP) 4402 AP 1869 07/31/2018 July A/P July billings 171.90 17,849.47 DATAPROSE LLC 4432 AP _______________ Account: 135-60035-030-000 Postage Totals: 269.55 17,849.47 ** 30,000.00 Budgeted 12,150.53 Remaining 59 % Used Account: 135-60040-030-000 Service Charges & Fees 1709 07/13/2018 Child Support Fee 43,616.40 1.50 43,617.90 GL 1775 07/27/2018 Child Support Fee 1.50 43,619.40 GL 1805 07/31/2018 Pace Credit Card Fees 5,206.43 48,825.83 GL 1805 07/31/2018 Pace Credit Card Fees 131.92 48,957.75 GL 1845 07/31/2018 July A/P Direct send fees 50.00 49,007.75 Fiserv Solutions, LLC 4438 AP 1875 07/31/2018 July A/P Direct send fees 50.00 49,057.75 Fiserv Solutions, LLC 4438 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,441.35 49,057.75 ** 55,560.00 Budgeted 6,502.25 Remaining 88 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 241 07/01/2018 Insurance/Wrk Comp Exp Jul 58,698.24 6,100.36 64,798.60 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 64,798.60 ** 56,000.00 Budgeted (8,798.60) Remaining 116 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 206.38 .00 206.38 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 206.38 ** 1,600.00 Budgeted 1,393.62 Remaining 13 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 GOVERNMENT FINANCE OFF 3,828.42 160.00 3,988.42 GOVERNMENT FINANCE OFF PC _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 160.00 3,988.42 ** 6,000.00 Budgeted 2,011.58 Remaining 66 % Used Account: 135-60075-030-000 Meetings 80.50 .00 80.50 _______________ Account: 135-60075-030-000 Meetings Totals: .00 80.50 ** 400.00 Budgeted 319.50 Remaining 20 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 GOVERNMENT FINANCE OFF 3,143.00 85.00 3,228.00 GOVERNMENT FINANCE OFF PC 1796 07/30/2018 July A/P petty cash reimbursement-Steve 10.00 3,238.00 TROPHY CLUB MUD PETTY CASH 4419 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 95.00 3,238.00 ** 7,600.00 Budgeted 4,362.00 Remaining 43 % Used Account: 135-60100-030-000 Travel & per diem 1742 07/30/2018 Corrected JE Accounts Correct Pcard coding- Travel 958.71 616.40 1,575.11 GL 1796 07/30/2018 July A/P GM tolls 5.41 1,580.52 NTTA 4416 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 621.81 1,580.52 ** 4,885.00 Budgeted 3,304.48 Remaining 32 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60115-030-000 Elections 220.00 .00 220.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising 150.00 .00 150.00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 150.00 ** 2,500.00 Budgeted 2,350.00 Remaining 6 % Used Account: 135-60235-030-000 Security 1772 07/24/2018 July A/P Monitoring service 144.00 24.00 168.00 Digital Air Control, Inc 4391 AP 1881 07/31/2018 July A/P Panel monitoring service call 226.00 394.00 Digital Air Control, Inc 4433 AP _______________ Account: 135-60235-030-000 Security Totals: 250.00 394.00 ** 2,700.00 Budgeted 2,306.00 Remaining 15 % Used Account: 135-60245-030-000 Miscellaneous Expenses 124.50 .00 124.50 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency 17,000.00 .00 17,000.00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 17,000.00 ** 17,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 273.73 .00 273.73 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 273.73 ** 700.00 Budgeted 426.27 Remaining 39 % Used Account: 135-65055-030-000 Hardware 2,006.68 .00 2,006.68 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,006.68 ** 7,420.00 Budgeted 5,413.32 Remaining 27 % Used Account: 135-65085-030-000 Office Supplies 1772 07/24/2018 July A/P Office supplies 3,870.52 65.77 3,936.29 OFFICE DEPOT, INC 4399 AP 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 AMAZON MKTPLACE PMTS 46.23 3,982.52 AMAZON MKTPLACE PMTS PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 AMAZON MKTPLACE PMTS 24.40 4,006.92 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 136.40 4,006.92 ** 7,000.00 Budgeted 2,993.08 Remaining 57 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,048.66 .00 2,048.66 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,048.66 ** 2,000.00 Budgeted (48.66) Remaining 102 % Used Account: 135-65095-030-000 Maintenance Supplies 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 SAMSCLUB.COM 3,420.04 321.10 3,741.14 SAMSCLUB.COM PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 THE HOME DEPOT #6581 29.16 3,770.30 THE HOME DEPOT #6581 PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 AMAZON MKTPLACE PMTS 19.09 3,789.39 AMAZON MKTPLACE PMTS PC 1867 07/26/2018 Pcard 06/27/18 - 07/26/18 WM SUPERCENTER #5247 7.32 3,796.71 WM SUPERCENTER #5247 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 376.67 3,796.71 ** 4,000.00 Budgeted 203.29 Remaining 95 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays 48,354.99 .00 48,354.99 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 48,354.99 ** 13,000.00 Budgeted (35,354.99) Remaining 372 % Used Account: 135-69170-030-000 Copier Lease Installments 1796 07/30/2018 July A/P Copier lease 2,216.86 244.88 2,461.74 KYOCERA DOCUMENT SOLUTIONS 4413 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 244.88 2,461.74 ** 4,600.00 Budgeted 2,138.26 Remaining 54 % Used Department 30 Totals: ----------------------------------- 939,545.94 ** 69,502.91 Monthly Total 1,227,112.00 Budgeted 287,566.06 Remaining 77 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2018 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 1772 07/24/2018 July A/P Legal-Southlake easement 99,198.77 11,359.26 110,558.03 WHITAKER CHALK SWINDLE 4404 AP 1890 07/31/2018 July A/P Legal 2,550.00 113,108.03 McLean & Howard, L.L.P. 4453 AP 1890 07/31/2018 July A/P Legal 1,050.00 114,158.03 McLean & Howard, L.L.P. 4453 AP 1900 07/31/2018 July A/P legal-Southlake easement 3,763.87 117,921.90 WHITAKER CHALK SWINDLE 4475 AP _______________ Account: 135-55045-039-000 Legal Totals: 18,723.13 117,921.90 ** 137,000.00 Budgeted 19,078.10 Remaining 86 % Used Account: 135-55055-039-000 Auditing 25,658.70 .00 25,658.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,658.70 ** 24,500.00 Budgeted (1,158.70) Remaining 105 % Used Account: 135-55060-039-000 Appraisal 8,683.92 .00 8,683.92 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,683.92 ** 11,446.00 Budgeted 2,762.08 Remaining 76 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 155,232.92 ** 18,723.13 Monthly Total 176,746.00 Budgeted 21,513.08 Remaining 88 % Used Fund 135 Totals: ----------------------------------- (1,938,251.43) (404,089.04) Monthly Total (194,618.00) Budgeted 1,743,633.43 Remaining 996 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/2018 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 (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,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: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JULY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 800,292 TOTAL LIABILITIES 800,292 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,792,871) TOTAL FUND BALANCE (800,292) TOTAL LIABILITIES AND FUND BALANCE 0 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 15:41 08/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 9,348.16- 9,348.16 Subtotal: 9,348.16- 9,348.16 Program number: 9,348.16- 9,348.16 Department number: Revenues 9,348.16- 9,348.16 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 15:41 08/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49141-020-000 Interfund Transfers In Gen 120,074.08- 463,475.06- 463,475.06 Subtotal: 120,074.08- 463,475.06- 463,475.06 Program number: 120,074.08- 463,475.06- 463,475.06 Department number: Wastewater 120,074.08- 463,475.06- 463,475.06 Revenues Subtotal ----------- 120,074.08- 472,823.22- 472,823.22 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 15:41 08/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60335-020-000 Intergov Transfer Out (GF) 154.89 154.89- Subtotal: 154.89 154.89- 517-69005-020-000 Capital Outlays 116,594.01 2,265,539.59 2,265,539.59- Subtotal: 116,594.01 2,265,539.59 2,265,539.59- Program number: 116,594.01 2,265,694.48 2,265,694.48- Department number: Wastewater 116,594.01 2,265,694.48 2,265,694.48- Expenditures Subtotal ----------- 116,594.01 2,265,694.48 2,265,694.48- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 3,480.07- 1,792,871.26 1,792,871.26- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2018 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 (9,348.16) .00 (9,348.16) _______________ Account: 517-49010-000-000 Interest Income Totals: .00 (9,348.16) ** .00 Budgeted 9,348.16 Remaining 0 % Used Department Totals: ----------------------------------- (9,348.16) ** .00 Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49141-020-000 Interfund Transfers In Gen 1870 07/31/2018 Texpool Transfers July (343,400.98) (120,074.08) (463,475.06) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (120,074.08) (463,475.06) ** .00 Budgeted 463,475.06 Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 154.89 .00 154.89 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 154.89 ** .00 Budgeted (154.89) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 1869 07/31/2018 July A/P WWTP Improvements 2,148,945.58 98,619.74 2,247,565.32 WEBBER-CADAGUA PARTNERS 4474 AP 1900 07/31/2018 July A/P WWTP Improvements 17,974.27 2,265,539.59 CP&Y/WALLACE GROUP, INC. 4431 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 116,594.01 2,265,539.59 ** .00 Budgeted (2,265,539.59) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,802,219.42 ** (3,480.07) Monthly Total .00 Budgeted (1,802,219.42) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,792,871.26 (3,480.07) Monthly Total .00 Budgeted (1,792,871.26) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JULY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 749,385 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES (3,489,354) TOTAL FUND BALANCE 736,227 TOTAL LIABILITIES AND FUND BALANCE 749,385 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 15:41 08/15/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 1,534.17- 1,534.17 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08 Subtotal: 1,055,469.25- 1,055,469.25 Program number: 1,055,469.25- 1,055,469.25 Department number: Revenues 1,055,469.25- 1,055,469.25 Revenues Subtotal ----------- 1,055,469.25- 1,055,469.25 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 15:41 08/15/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 1,851,614.33 1,851,614.33- Subtotal: 1,851,614.33 1,851,614.33- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68- Program number: 4,544,823.01 4,544,823.01- Department number: Water 4,544,823.01 4,544,823.01- Expenditures Subtotal ----------- 4,544,823.01 4,544,823.01- Fund number: 519 2016 Rev Bond Const-SWIFT 3,489,353.76 3,489,353.76- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49010-000-000 Interest Income (1,534.17) .00 (1,534.17) _______________ Account: 519-49010-000-000 Interest Income Totals: .00 (1,534.17) ** .00 Budgeted 1,534.17 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund (1,053,935.08) .00 (1,053,935.08) _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (1,053,935.08) ** .00 Budgeted 1,053,935.08 Remaining 0 % Used Department Totals: ----------------------------------- (1,055,469.25) ** .00 Monthly Total .00 Budgeted 1,055,469.25 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60334-010-000 Interfund Transfer Out 1,851,614.33 .00 1,851,614.33 _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: .00 1,851,614.33 ** .00 Budgeted (1,851,614.33) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2,693,208.68 .00 2,693,208.68 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 4,544,823.01 ** .00 Monthly Total .00 Budgeted (4,544,823.01) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,489,353.76 .00 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET JULY 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 213,458 TOTAL LIABILITIES 213,458 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES (173,559) TOTAL FUND BALANCE (213,458) TOTAL LIABILITIES AND FUND BALANCE 0 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 15:41 08/15/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 173,558.94 173,558.94 173,558.94- Subtotal: 173,558.94 173,558.94 173,558.94- Program number: 173,558.94 173,558.94 173,558.94- Department number: Water Department 173,558.94 173,558.94 173,558.94- Expenditures Subtotal ----------- 173,558.94 173,558.94 173,558.94- Fund number: 520 Revenue Bond 16" Waterline 173,558.94 173,558.94 173,558.94- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 1905 07/31/2018 Due To/Due From MUD-Fund 520 173,558.94 173,558.94 GL _______________ Account: 520-69005-010-000 Capital Outlays Totals: 173,558.94 173,558.94 ** .00 Budgeted (173,558.94) Remaining 0 % Used Department 10 Totals: ----------------------------------- 173,558.94 ** 173,558.94 Monthly Total .00 Budgeted (173,558.94) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 173,558.94 173,558.94 Monthly Total .00 Budgeted (173,558.94) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 576,269 ACCOUNTS RECEIVABLE - TOTAL ASSETS 576,269 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 149,691 TOTAL FUND BALANCE 576,269 TOTAL LIABILITIES AND FUND BALANCE 576,269 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 15:41 08/15/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 901.06- 6,080.67- 608.067 5,080.67 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 40,830.00- 83.333 8,166.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 102,780.00- 83.333 20,556.00- Subtotal: 173,332.00- 173,332.00- 15,262.06- 149,690.67- 86.361 23,641.33- Program number: 173,332.00- 173,332.00- 15,262.06- 149,690.67- 86.361 23,641.33- Department number: 173,332.00- 173,332.00- 15,262.06- 149,690.67- 86.361 23,641.33- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,262.06- 149,690.67- 86.361 23,641.33- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,262.06- 149,690.67- 86.361 23,641.33- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2018 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 1899 07/31/2018 Bank Interest- July (5,179.61) (901.06) (6,080.67) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (901.06) (6,080.67) ** (1,000.00) Budgeted 5,080.67 Remaining 608 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1870 07/31/2018 Texpool Transfers July (36,747.00) (4,083.00) (40,830.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (40,830.00) ** (48,996.00) Budgeted (8,166.00) Remaining 83 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1870 07/31/2018 Texpool Transfers July (92,502.00) (10,278.00) (102,780.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (102,780.00) ** (123,336.00) Budgeted (20,556.00) Remaining 83 % Used Department Totals: ----------------------------------- (149,690.67) ** (15,262.06) Monthly Total (173,332.00) Budgeted (23,641.33) Remaining 86 % Used Fund 528 Totals: ----------------------------------- (149,690.67) (15,262.06) Monthly Total (173,332.00) Budgeted (23,641.33) Remaining 86 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 902,945 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 10,307 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 917,824 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,307 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 10,307 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 875,176 TOTAL FUND BALANCE 907,517 TOTAL LIABILITIES AND FUND BALANCE 917,824 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 15:41 08/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 1,864.98- 676,183.59- 100.974 6,523.59 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 27.18- 2,624.77- 145.821 824.77 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 25.55- 1,936.94- 96.847 63.06- Subtotal: 673,460.00- 673,460.00- 1,917.71- 680,745.30- 101.082 7,285.30 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,427.42- 7,732.81- 386.641 5,732.81 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 11,094.81- 110,948.10- 90.909 11,094.90- Subtotal: 342,997.00- 342,997.00- 12,522.23- 337,634.91- 98.437 5,362.09- Program number: 1,016,457.00- 1,016,457.00- 14,439.94- 1,018,380.21- 100.189 1,923.21 Department number: Revenues 1,016,457.00- 1,016,457.00- 14,439.94- 1,018,380.21- 100.189 1,923.21 Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 14,439.94- 1,018,380.21- 100.189 1,923.21 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 15:41 08/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 1,450.00 67.442 700.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 50.000 141,754.25 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Program number: 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Department number: Administration 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 14,439.94- 875,176.46- ############### 869,377.46 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2018 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 1819 07/02/2018 Property Taxes (674,318.61) (31.90) (674,350.51) GL 1820 07/03/2018 Property Taxes (21.49) (674,372.00) GL 1821 07/05/2018 Property Taxes (33.57) (674,405.57) GL 1822 07/06/2018 Property Taxes (74.19) (674,479.76) GL 1823 07/09/2018 Property Taxes (64.02) (674,543.78) GL 1824 07/10/2018 Property Taxes (44.92) (674,588.70) GL 1825 07/11/2018 Property Taxes (181.70) (674,770.40) GL 1826 07/12/2018 Property Taxes (54.14) (674,824.54) GL 1827 07/13/2018 Property Taxes (57.62) (674,882.16) GL 1828 07/16/2018 Property Taxes (110.47) (674,992.63) GL 1829 07/17/2018 Property Taxes (24.42) (675,017.05) GL 1830 07/18/2018 Property Taxes (51.73) (675,068.78) GL 1831 07/19/2018 Property Taxes (150.50) (675,219.28) GL 1832 07/20/2018 Property Taxes (83.29) (675,302.57) GL 1833 07/23/2018 Property Taxes (177.40) (675,479.97) GL 1834 07/24/2018 Property Taxes (20.22) (675,500.19) GL 1835 07/25/2018 Property Taxes (76.93) (675,577.12) GL 1836 07/26/2018 Property Taxes (38.83) (675,615.95) GL 1837 07/27/2018 Property Taxes (203.51) (675,819.46) GL 1838 07/30/2018 Property Taxes (87.92) (675,907.38) GL 1839 07/31/2018 Property Taxes (276.21) (676,183.59) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,864.98) (676,183.59) ** (669,660.00) Budgeted 6,523.59 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1819 07/02/2018 Property Taxes (2,597.59) (.32) (2,597.91) GL 1820 07/03/2018 Property Taxes (26.86) (2,624.77) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (27.18) (2,624.77) ** (1,800.00) Budgeted 824.77 Remaining 146 % Used Account: 533-40015-000-000 Property Taxes/P & I 1819 07/02/2018 Property Taxes (1,911.39) (2.68) (1,914.07) GL 1820 07/03/2018 Property Taxes (7.79) (1,921.86) GL 1822 07/06/2018 Property Taxes (3.14) (1,925.00) GL 1831 07/19/2018 Property Taxes (.28) (1,925.28) GL 1833 07/23/2018 Property Taxes (.17) (1,925.45) GL 1835 07/25/2018 Property Taxes (2.21) (1,927.66) GL 1837 07/27/2018 Property Taxes (9.03) (1,936.69) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1838 07/30/2018 Property Taxes (1,911.39) (.25) (1,936.94) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (25.55) (1,936.94) ** (2,000.00) Budgeted (63.06) Remaining 97 % Used Account: 533-49010-000-000 Interest Income 1899 07/31/2018 Bank Interest- July (6,305.39) (1,427.42) (7,732.81) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,427.42) (7,732.81) ** (2,000.00) Budgeted 5,732.81 Remaining 387 % Used Account: 533-49015-000-000 Lease/Rental Income (218,954.00) .00 (218,954.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1870 07/31/2018 Texpool Transfers July (99,853.29) (11,094.81) (110,948.10) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (110,948.10) ** (122,043.00) Budgeted (11,094.90) Remaining 91 % Used Department Totals: ----------------------------------- (1,018,380.21) ** (14,439.94) Monthly Total (1,016,457.00) Budgeted 1,923.21 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2018 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,450.00 .00 1,450.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 141,753.75 .00 141,753.75 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 141,753.75 ** 283,508.00 Budgeted 141,754.25 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 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 143,203.75 ** .00 Monthly Total 1,010,658.00 Budgeted 867,454.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (875,176.46) (14,439.94) Monthly Total (5,799.00) Budgeted 869,377.46 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JULY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 451,416 ACCOUNTS RECEIVABLE - TOTAL ASSETS 451,416 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,211 NET REVENUES / EXPENDITURES 435,205 TOTAL FUND BALANCE 451,416 TOTAL LIABILITIES AND FUND BALANCE 451,416 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 15:41 08/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 638.93- 2,766.78- 276.678 1,766.78 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 544,307.20- 90.909 54,430.80- Subtotal: 599,738.00- 599,738.00- 55,069.65- 547,073.98- 91.219 52,664.02- Program number: 599,738.00- 599,738.00- 55,069.65- 547,073.98- 91.219 52,664.02- Department number: Revenues 599,738.00- 599,738.00- 55,069.65- 547,073.98- 91.219 52,664.02- Revenues Subtotal ----------- 599,738.00- 599,738.00- 55,069.65- 547,073.98- 91.219 52,664.02- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 15:41 08/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 50.000 111,669.25 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Program number: 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Department number: Administration 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Expenditures Subtotal ----------- 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 55,069.65- 435,205.23- ############### 434,205.23 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/2018 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 1899 07/31/2018 Bank Interest- July (2,127.85) (638.93) (2,766.78) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (638.93) (2,766.78) ** (1,000.00) Budgeted 1,766.78 Remaining 277 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1870 07/31/2018 Texpool Transfers July (489,876.48) (54,430.72) (544,307.20) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (544,307.20) ** (598,738.00) Budgeted (54,430.80) Remaining 91 % Used Department Totals: ----------------------------------- (547,073.98) ** (55,069.65) Monthly Total (599,738.00) Budgeted (52,664.02) Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee 200.00 .00 200.00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 111,668.75 .00 111,668.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 111,668.75 ** 223,338.00 Budgeted 111,669.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 111,868.75 ** .00 Monthly Total 598,738.00 Budgeted 486,869.25 Remaining 19 % Used Fund 534 Totals: ----------------------------------- (435,205.23) (55,069.65) Monthly Total (1,000.00) Budgeted 434,205.23 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 223,571 ACCOUNTS RECEIVABLE - TOTAL ASSETS 223,571 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 222,619 TOTAL FUND BALANCE 223,571 TOTAL LIABILITIES AND FUND BALANCE 223,571 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 15:41 08/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 600.00- 600.00- 319.03- 1,357.44- 226.240 757.44 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 252,803.10- 90.909 25,280.90- Subtotal: 278,684.00- 278,684.00- 25,599.34- 254,160.54- 91.200 24,523.46- Program number: 278,684.00- 278,684.00- 25,599.34- 254,160.54- 91.200 24,523.46- Department number: Revenues 278,684.00- 278,684.00- 25,599.34- 254,160.54- 91.200 24,523.46- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,599.34- 254,160.54- 91.200 24,523.46- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 15:41 08/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 7/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 50.000 31,342.25 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Program number: 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Department number: Administration 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Expenditures Subtotal ----------- 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,599.34- 222,618.79- ############### 222,018.79 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 7/2018 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 1899 07/31/2018 Bank Interest- July (1,038.41) (319.03) (1,357.44) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (319.03) (1,357.44) ** (600.00) Budgeted 757.44 Remaining 226 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1870 07/31/2018 Texpool Transfers July (227,522.79) (25,280.31) (252,803.10) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (252,803.10) ** (278,084.00) Budgeted (25,280.90) Remaining 91 % Used Department Totals: ----------------------------------- (254,160.54) ** (25,599.34) Monthly Total (278,684.00) Budgeted (24,523.46) Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 15:42 08/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 7/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee 200.00 .00 200.00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 31,341.75 .00 31,341.75 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 31,341.75 ** 62,684.00 Budgeted 31,342.25 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 31,541.75 ** .00 Monthly Total 278,084.00 Budgeted 246,542.25 Remaining 11 % Used Fund 535 Totals: ----------------------------------- (222,618.79) (25,599.34) Monthly Total (600.00) Budgeted 222,018.79 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 1,524,248.38 **** (346,129.84) Monthly Total (375,349.00) Budgeted (1,899,597.38) Remaining ########## ******* End of Report *********