Loading...
HomeMy WebLinkAbout2018-06 June Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 2018 122 ASSETS FIRE DEPT. CASH IN BANK 60,743 INVESTMENTS 691,610 PREPAID EXPENSES 3,810 ADVALOREM PROPERTY TAXES RECEIVABLE 19,637 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 775,799 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 19,637 ACCOUNTS AND OTHER PAYABLES 111,485 TOTAL LIABILITIES 131,122 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 122,424 TOTAL FUND BALANCE 644,677 TOTAL LIABILITIES AND FUND BALANCE 775,799 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 19:44 07/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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- 3,787.88- 1,061,756.03- 100.694 7,323.03 122-40011-000-000 Property Taxes/Fire-Delinquent 17.31- 3,903.29- 3,903.29 122-40020-000-000 Property Taxes/Fire P&I 183.11- 4,631.92- 4,631.92 Subtotal: 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24 Program number: 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 19:44 07/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 11,428.83 63.494 6,571.17 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 101,485.00 507,425.00 83.333 101,485.00 Subtotal: 845,864.00 845,864.00 102,754.87 737,807.83 87.225 108,056.17 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 102,754.87 947,866.92 89.894 106,566.08 Department number: Fire 1,054,433.00 1,054,433.00 102,754.87 947,866.92 89.894 106,566.08 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 102,754.87 947,866.92 89.894 106,566.08 Fund number: 122 Trophy Club MUD Fire Dept. 98,766.57 122,424.32- 122,424.32 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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 1664 06/01/2018 Property Taxes (1,057,968.15) (517.33) (1,058,485.48) GL 1665 06/04/2018 Property Taxes (816.12) (1,059,301.60) GL 1666 06/05/2018 Property Taxes (55.45) (1,059,357.05) GL 1667 06/07/2018 Property Taxes (1,040.62) (1,060,397.67) GL 1668 06/11/2018 Property Taxes (185.51) (1,060,583.18) GL 1669 06/12/2018 Property Taxes (12.60) (1,060,595.78) GL 1670 06/13/2018 Property Taxes (1,012.71) (1,061,608.49) GL 1671 06/15/2018 Property Taxes (19.91) (1,061,628.40) GL 1672 06/18/2018 Property Taxes (36.44) (1,061,664.84) GL 1673 06/19/2018 Property Taxes (69.94) (1,061,734.78) GL 1674 06/21/2018 Property Taxes (4.24) (1,061,739.02) GL 1675 06/22/2018 Property Taxes (12.36) (1,061,751.38) GL 1676 06/25/2018 Property Taxes (20.87) (1,061,772.25) GL 1677 06/26/2018 Property Taxes (35.10) (1,061,807.35) GL 1678 06/28/2018 Property Taxes (1.88) (1,061,809.23) GL 1679 06/29/2018 Property Taxes 53.20 (1,061,756.03) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,787.88) (1,061,756.03) ** (1,054,433.00) Budgeted 7,323.03 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1665 06/04/2018 Property Taxes (3,885.98) (35.92) (3,921.90) GL 1679 06/29/2018 Property Taxes 18.61 (3,903.29) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (17.31) (3,903.29) ** .00 Budgeted 3,903.29 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1664 06/01/2018 Property Taxes (4,448.81) (7.70) (4,456.51) GL 1665 06/04/2018 Property Taxes (7.99) (4,464.50) GL 1667 06/07/2018 Property Taxes (130.49) (4,594.99) GL 1668 06/11/2018 Property Taxes (27.83) (4,622.82) GL 1670 06/13/2018 Property Taxes (3.02) (4,625.84) GL 1671 06/15/2018 Property Taxes (2.99) (4,628.83) GL 1674 06/21/2018 Property Taxes (.63) (4,629.46) GL 1677 06/26/2018 Property Taxes (2.46) (4,631.92) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (183.11) (4,631.92) ** .00 Budgeted 4,631.92 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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-43415-000-000 Denton County Pledge-Fire 1540 06/07/2018 2018 Fire Pledge-Denton County (10,000.00) (10,000.00) GL 1692 06/29/2018 June A/P Denton County Fire Pledge FY19 10,000.00 .00 TOWN OF TROPHY CLUB 4365 AP _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department Totals: ----------------------------------- (1,070,291.24) ** (3,988.30) Monthly Total (1,054,433.00) Budgeted 15,858.24 Remaining 102 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 10,158.96 1,269.87 11,428.83 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 11,428.83 ** 18,000.00 Budgeted 6,571.17 Remaining 63 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1692 06/29/2018 June A/P June Fire Admin 405,940.00 50,742.50 456,682.50 TOWN OF TROPHY CLUB 4365 AP 1692 06/29/2018 June A/P July Fire Admin 50,742.50 507,425.00 TOWN OF TROPHY CLUB 4365 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 101,485.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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: ----------------------------------- 947,866.92 ** 102,754.87 Monthly Total 1,054,433.00 Budgeted 106,566.08 Remaining 90 % Used Fund 122 Totals: ----------------------------------- (122,424.32) 98,766.57 Monthly Total .00 Budgeted 122,424.32 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JUNE 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,678,923 - 1,678,923 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,223 - 715,223 INVESTMENTS-TEXPOOL 2,261,972 596,426 2,858,398 PREPAID EXPENSES 28,908 - 28,908 ADVALOREM PROPERTY TAXES RECEIVABLE 2,132 - 2,132 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,240,905 - 1,240,905 TOTAL ASSETS 6,711,321 596,426 7,307,747 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,132 - 2,132 ACCOUNTS AND OTHER PAYABLES 708,674 - 708,674 CUSTOMER DEPOSITS 315,985 - 315,985 - TOTAL LIABILITIES 1,026,791 - 1,026,791 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,534,162 - 1,534,162 - TOTAL FUND BALANCE 5,684,530 596,426 6,280,956 TOTAL LIABILITIES AND FUND BALANCE 6,711,321 596,426 7,307,747 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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- 434.50- 121,785.15- 100.690 835.15 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 1.01- 344.61- 172.305 144.61 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 20.65- 512.97- 256.485 312.97 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 456.16- 122,642.73- 40.992 176,546.27- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 746,487.77- 3,886,089.31- 60.119 2,577,929.69- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 265,925.19- 2,209,522.16- 74.193 768,544.84- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 8,906.00- 80,968.31- 76.185 25,310.69- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,200.00- 10,600.00- 49.649 10,750.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 1,800.00- 120.000 300.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 4,600.00- 102.222 100.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 14,924.80- 42,120.80- 70.201 17,879.20- Subtotal: 9,635,715.00- 9,635,715.00- 1,037,843.76- 6,235,700.58- 64.714 3,400,014.42- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 7,121.94- 37,767.71- 314.731 25,767.71 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 8,741.01- 80.002 2,184.99- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 11,492.76- 63.220 6,686.24- 135-49141-000-000 Interfund Transfer In 1,639.76- 1,851,769.22- 1,851,769.22 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 225.44- 59,001.27- 1,180.025 54,001.27 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 11,235.28- 1,989,421.94- 631.312 1,674,296.94 Program number: 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 29,854.77 168,036.77 61.265 106,242.23 135-50010-010-000 Overtime 20,000.00 20,000.00 1,549.55 8,067.93 40.340 11,932.07 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 200.00 1,600.00 48.485 1,700.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,923.41 18,153.82 65.201 9,689.18 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 23,953.43 45.891 28,242.57 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,948.34 37.598 3,233.66 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 352.07 35.420 641.93 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 105.01 1,908.32 63.995 1,073.68 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,942.82 11,156.01 59.779 7,505.99 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 454.38 2,609.07 59.773 1,755.93 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,099.28 68.325 3,754.72 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 41,128.23 250,258.76 58.655 176,403.24 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 839.83 51,009.44 51.009 48,990.56 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 323.36 4,211.18 105.280 211.18- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 35.00 1.000 3,465.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 280.00 6,045.16 109.912 545.16- Subtotal: 391,000.00 391,000.00 1,478.19 61,300.78 15.678 329,699.22 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.18 2,862.80 60.911 1,837.20 135-60020-010-000 Electricity 175,356.00 175,356.00 12,787.14 94,948.69 54.146 80,407.31 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 1,536.78 55.181 1,248.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 17,410.32 31.554 37,765.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 223,655.16 1,244,668.24 44.088 1,578,501.76 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 7,500.00 50.847 7,250.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 227,522.79 81.818 50,561.21 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,098.00 36,747.00 75.000 12,249.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 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 267,690.79 2,693,516.90 74.533 920,335.10 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 987.64 7,953.62 53.024 7,046.38 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 1,490.96 13,449.80 67.249 6,550.20 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 583.00 58.300 417.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 3,873.75 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 6,352.35 97,111.31 55.275 78,576.69 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 31,893.08 557,431.42 68.818 252,580.58 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 5,713.00 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 31,893.08 740,295.80 70.623 307,935.20 Program number: 5,655,433.00 5,655,433.00 348,542.64 3,842,483.55 67.943 1,812,949.45 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/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 1,200.08 60.004 799.92 Subtotal: 2,000.00 2,000.00 1,200.08 60.004 799.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,200.08 60.004 799.92 Department number: Water 5,657,433.00 5,657,433.00 348,542.64 3,843,683.63 67.940 1,813,749.37 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 38,070.84 273,389.53 66.540 137,476.47 135-50010-020-000 Overtime 30,000.00 30,000.00 2,688.44 26,289.25 87.631 3,710.75 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 6,336.00 75.429 2,064.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,834.98 30,446.44 72.075 11,796.56 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 49,012.02 78.829 13,162.98 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 3,576.07 67.844 1,694.93 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 626.16 56.208 487.84 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 156.84 3,319.02 77.529 961.98 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,393.71 18,043.88 63.728 10,270.12 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 559.82 4,219.93 63.726 2,402.07 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 12,132.00 67.437 5,858.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 63.00 126.00 42.000 174.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 55,765.11 436,065.30 69.592 190,535.70 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 19,761.98 64,183.35 74.545 21,916.65 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 450.00 6,803.60 85.045 1,196.40 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 105.71 395.40 79.080 104.60 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 2,502.47 57,579.59 95.966 2,420.41 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,442.00 24,158.02 80.527 5,841.98 Subtotal: 219,150.00 219,150.00 24,262.16 155,293.74 70.862 63,856.26 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 332.19 3,725.19 79.259 974.81 135-60020-020-000 Electricity 266,709.00 266,709.00 11,562.83 121,836.21 45.681 144,872.79 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.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 21.91 41.88 1.047 3,958.12 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 5,780.00 49.828 5,820.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 99,853.29 81.818 22,189.71 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 489,876.48 81.818 108,861.52 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,308.00 92,502.00 75.000 30,834.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 142,368.99 343,400.98 171.700 143,400.98- 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 231,299.45 1,190,150.74 82.710 248,787.26 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 644.06 6,909.73 55.278 5,590.27 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 1,193.00 9,234.23 33.579 18,265.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 239.94 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 2,160.43 15,644.24 111.745 1,644.24- Subtotal: 60,209.00 60,209.00 4,237.43 36,110.17 59.975 24,098.83 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 15,368.68 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 7,573.00 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 15,368.68 136,519.29 21.457 499,722.71 Program number: 2,981,140.00 2,981,140.00 330,932.83 1,954,139.24 65.550 1,027,000.76 Department number: Wastewater 2,981,140.00 2,981,140.00 330,932.83 1,954,139.24 65.550 1,027,000.76 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 21.78 72.600 8.22 Subtotal: 30.00 30.00 2.42 21.78 72.600 8.22 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 43.85 1,258.85 104.904 58.85- 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,540.00 38.500 2,460.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 3,392.28 4,352.28 87.046 647.72 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 148.98 1,404.26 70.213 595.74 Subtotal: 12,950.00 12,950.00 3,585.11 9,205.39 71.084 3,744.61 Program number: 12,980.00 12,980.00 3,587.53 9,227.17 71.088 3,752.83 Department number: Board of Directors 12,980.00 12,980.00 3,587.53 9,227.17 71.088 3,752.83 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 35,351.93 283,511.34 65.497 149,351.66 135-50010-030-000 Overtime 2,000.00 2,000.00 556.92 27.846 1,443.08 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 3,270.05 28,911.39 71.293 11,641.61 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,555.48 35,039.17 55.193 28,445.83 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 226.37 2,498.33 45.408 3,003.67 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 35.92 462.35 39.416 710.65 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 118.24 2,813.08 55.605 2,245.92 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,112.95 17,137.41 63.049 10,043.59 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 494.14 4,007.92 63.047 2,349.08 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 17.31 1,001.08 79.451 258.92 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,111.50 72.695 417.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 86.95 211.90 42.380 288.10 135-50070-030-000 Employee Relations 4,960.00 4,960.00 38.10 3,147.18 63.451 1,812.82 Subtotal: 595,970.00 595,970.00 45,430.94 383,957.07 64.426 212,012.93 135-55030-030-000 Software & Support 78,391.00 78,391.00 3,032.54 62,465.58 79.685 15,925.42 135-55070-030-000 Independent Labor 154,000.00 154,000.00 11,872.89 113,700.82 73.832 40,299.18 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 669.58 4,624.58 46.246 5,375.42 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 6,569.57 65.696 3,430.43 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 1,001.44 5,707.36 63.415 3,292.64 Subtotal: 338,916.00 338,916.00 17,445.51 257,468.60 75.968 81,447.40 135-60005-030-000 Telephone 27,300.00 27,300.00 232.48 12,089.81 44.285 15,210.19 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.37 2,274.17 56.854 1,725.83 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 963.22 4,815.43 29.613 11,445.57 135-60025-030-000 Water 2,500.00 2,500.00 184.89 524.01 20.960 1,975.99 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 3,022.55 17,579.92 58.600 12,420.08 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,899.08 43,616.40 78.503 11,943.60 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,620.36 58,698.24 104.818 2,698.24- 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 3,828.42 63.807 2,171.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 3,143.00 41.355 4,457.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 114.99 958.71 19.626 3,926.29 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 48.00 144.00 5.333 2,556.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 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 33,322.94 166,281.88 66.644 83,224.12 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 284.28 3,870.52 55.293 3,129.48 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 152.59 3,420.04 85.501 579.96 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 436.87 11,763.63 46.830 13,356.37 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 11,027.67 48,354.99 371.961 35,354.99- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 226.31 2,216.86 48.193 2,383.14 Subtotal: 17,600.00 17,600.00 11,253.98 50,571.85 287.340 32,971.85- Program number: 1,227,112.00 1,227,112.00 107,890.24 870,043.03 70.902 357,068.97 Department number: Administration 1,227,112.00 1,227,112.00 107,890.24 870,043.03 70.902 357,068.97 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 19:44 07/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 39,936.84 99,198.77 72.408 37,801.23 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 39,936.84 136,509.79 77.235 40,236.21 Program number: 176,746.00 176,746.00 39,936.84 136,509.79 77.235 40,236.21 Department number: Non Departmental 176,746.00 176,746.00 39,936.84 136,509.79 77.235 40,236.21 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 830,890.08 6,813,602.86 67.761 3,241,808.14 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 218,645.12- 1,534,162.39- 788.294 1,339,544.39 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 19:44 07/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/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 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1664 06/01/2018 Property Taxes (121,350.65) (59.34) (121,409.99) GL 1665 06/04/2018 Property Taxes (93.61) (121,503.60) GL 1666 06/05/2018 Property Taxes (6.36) (121,509.96) GL 1667 06/07/2018 Property Taxes (119.36) (121,629.32) GL 1668 06/11/2018 Property Taxes (21.28) (121,650.60) GL 1669 06/12/2018 Property Taxes (1.45) (121,652.05) GL 1670 06/13/2018 Property Taxes (116.16) (121,768.21) GL 1671 06/15/2018 Property Taxes (2.29) (121,770.50) GL 1672 06/18/2018 Property Taxes (4.18) (121,774.68) GL 1673 06/19/2018 Property Taxes (8.02) (121,782.70) GL 1674 06/21/2018 Property Taxes (.49) (121,783.19) GL 1675 06/22/2018 Property Taxes (1.42) (121,784.61) GL 1676 06/25/2018 Property Taxes (2.39) (121,787.00) GL 1677 06/26/2018 Property Taxes (4.03) (121,791.03) GL 1678 06/28/2018 Property Taxes (.22) (121,791.25) GL 1679 06/29/2018 Property Taxes 6.10 (121,785.15) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (434.50) (121,785.15) ** (120,950.00) Budgeted 835.15 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1665 06/04/2018 Property Taxes (343.60) (2.11) (345.71) GL 1679 06/29/2018 Property Taxes 1.10 (344.61) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.01) (344.61) ** (200.00) Budgeted 144.61 Remaining 172 % Used Account: 135-40015-000-000 Property Taxes/P & I 1664 06/01/2018 Property Taxes (492.32) (.88) (493.20) GL 1665 06/04/2018 Property Taxes (.57) (493.77) GL 1667 06/07/2018 Property Taxes (14.97) (508.74) GL 1668 06/11/2018 Property Taxes (3.19) (511.93) GL 1670 06/13/2018 Property Taxes (.35) (512.28) GL 1671 06/15/2018 Property Taxes (.34) (512.62) GL 1674 06/21/2018 Property Taxes (.07) (512.69) GL 1677 06/26/2018 Property Taxes (.28) (512.97) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.65) (512.97) ** (200.00) Budgeted 312.97 Remaining 256 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-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 1523 06/08/2018 UB 06/08/2018 Penalty removal UB20180608-20180608 User: (3,139,601.54) 26.13 (3,139,575.41) UB 1589 06/21/2018 UB 06/21/2018 Credit adjust UB20180621-20180621 User: 32.23 (3,139,543.18) UB 1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (746,546.13) (3,886,089.31) UB _______________ Account: 135-47000-000-000 Water Totals: (746,487.77) (3,886,089.31) ** (6,464,019.00) Budgeted (2,577,929.69) Remaining 60 % Used Account: 135-47005-000-000 Sewer 1501 06/05/2018 UB 06/05/2018 WA Credits UB20180605-20180605 User: (1,943,596.97) 30.02 (1,943,566.95) UB 1523 06/08/2018 UB 06/08/2018 Penalty removal UB20180608-20180608 User: 53.22 (1,943,513.73) UB 1572 06/19/2018 UB 06/19/2018 WA Credit UB20180619-20180619 User: 304.43 (1,943,209.30) UB 1589 06/21/2018 UB 06/21/2018 Credit adjust UB20180621-20180621 User: 71.79 (1,943,137.51) UB 1607 06/25/2018 UB 06/25/2018 WA Credit UB20180625-20180625 User: 109.68 (1,943,027.83) UB 1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (266,494.33) (2,209,522.16) UB _______________ Account: 135-47005-000-000 Sewer Totals: (265,925.19) (2,209,522.16) ** (2,978,067.00) Budgeted (768,544.84) Remaining 74 % Used Account: 135-47025-000-000 Penalties 1475 06/05/2018 UB 06/05/2018 Penalty removal UB20180605-20180605 User: (72,062.31) 28.03 (72,034.28) UB 1566 06/18/2018 UB 06/18/2018 Penalty Removal UB20180618-20180618 User: 50.41 (71,983.87) UB 1581 06/20/2018 UB 06/20/2018 Penalty Removal UB20180620-20180620 User: 20.87 (71,963.00) UB 1594 06/21/2018 UB 06/21/2018 Assess Penalties UB20180621-20180621 User: (9,403.75) (81,366.75) UB 1616 06/26/2018 UB 06/26/2018 Penaly Removal UB20180626-20180626 User: 302.45 (81,064.30) UB 1627 06/28/2018 UB 06/28/2018 Penalty Removal UB20180628-20180628 User: 95.99 (80,968.31) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,906.00) (80,968.31) ** (106,279.00) Budgeted (25,310.69) Remaining 76 % Used Account: 135-47030-000-000 Service Charges 1508 06/06/2018 UB 06/2018 Disconnect Fees UB20180606-20180606 User: (9,400.00) (1,000.00) (10,400.00) UB 1618 06/26/2018 UB 06/26/2018 After hours fee UB20180626-20180626 User: (200.00) (10,600.00) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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: (1,200.00) (10,600.00) ** (21,350.00) Budgeted (10,750.00) Remaining 50 % Used Account: 135-47035-000-000 Plumbing Inspections 1654 06/15/2018 Customer deposits 603 Hogan's Drive (1,700.00) (50.00) (1,750.00) Drees Homes CR 1654 06/15/2018 Customer deposits 16 Sadie Court (50.00) (1,800.00) Drees Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,800.00) ** (1,500.00) Budgeted 300.00 Remaining 120 % Used Account: 135-47045-000-000 Sewer Inspections 1654 06/15/2018 Customer deposits 603 Hogan's Drive (4,300.00) (150.00) (4,450.00) Drees Homes CR 1654 06/15/2018 Customer deposits 16 Sadie Court (150.00) (4,600.00) Drees Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (4,600.00) ** (4,500.00) Budgeted 100.00 Remaining 102 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (27,196.00) (14,924.80) (42,120.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,924.80) (42,120.80) ** (60,000.00) Budgeted (17,879.20) Remaining 70 % Used Account: 135-49010-000-000 Interest Income 1683 06/15/2018 June Bk of West CD Interest (30,645.77) (158.92) (30,804.69) GL 1684 06/30/2018 Bank Interest- June (142.04) (30,946.73) GL 1684 06/30/2018 Bank Interest- June (469.12) (31,415.85) GL 1684 06/30/2018 Bank Interest- June (5,670.28) (37,086.13) GL 1684 06/30/2018 Bank Interest- June (681.58) (37,767.71) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (7,121.94) (37,767.71) ** (12,000.00) Budgeted 25,767.71 Remaining 315 % Used Account: 135-49016-000-000 Cell Tower Revenue 1539 06/07/2018 Cell Tower Rev AT&T June (7,762.20) (978.81) (8,741.01) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (8,741.01) ** (10,926.00) Budgeted (2,184.99) Remaining 80 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (4,666.64) (583.33) (5,249.97) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (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 1654 06/15/2018 Customer deposits 603 Hogan's Drive (10,806.76) (343.00) (11,149.76) Drees Homes CR 1654 06/15/2018 Customer deposits 16 Sadie Court (343.00) (11,492.76) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (11,492.76) ** (18,179.00) Budgeted (6,686.24) Remaining 63 % Used Account: 135-49141-000-000 Interfund Transfer In 1552 06/04/2018 Texpl Tsfr May Int 519 to 135 (1,850,129.46) (1,484.87) (1,851,614.33) GL 1685 06/30/2018 Transfer 517 Pros to 135 Pros (154.89) (1,851,769.22) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (1,639.76) (1,851,769.22) ** .00 Budgeted 1,851,769.22 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (58,775.83) (225.44) (59,001.27) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (225.44) (59,001.27) ** (5,000.00) Budgeted 54,001.27 Remaining 1.180 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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: ----------------------------------- (8,347,765.25) ** (1,049,535.20) Monthly Total (10,250,029.00) Budgeted (1,902,263.75) Remaining 81 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 138,182.00 9,939.23 148,121.23 PR 1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 9,939.22 158,060.45 PR 1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 9,976.32 168,036.77 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 29,854.77 168,036.77 ** 274,279.00 Budgeted 106,242.23 Remaining 61 % Used Account: 135-50010-010-000 Overtime 1448 06/01/2018 MUD PR 06.01.18 Overtime 6,518.38 440.61 6,958.99 PR 1548 06/15/2018 MUD PR 06.15.18 Overtime 586.26 7,545.25 PR 1614 06/29/2018 MUD PR 06/29/18 Overtime 522.68 8,067.93 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,549.55 8,067.93 ** 20,000.00 Budgeted 11,932.07 Remaining 40 % 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 1548 06/15/2018 MUD PR 06.15.18 Certification 1,400.00 200.00 1,600.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 1,600.00 ** 3,300.00 Budgeted 1,700.00 Remaining 48 % Used Account: 135-50020-010-000 Retirement 1448 06/01/2018 MUD PR 06.01.18 Retirement 15,230.41 960.15 16,190.56 PR 1548 06/15/2018 MUD PR 06.15.18 Retirement 992.08 17,182.64 PR 1614 06/29/2018 MUD PR 06/29/18 Retirement 971.18 18,153.82 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,923.41 18,153.82 ** 27,843.00 Budgeted 9,689.18 Remaining 65 % Used Account: 135-50026-010-000 Medical Insurance 1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 21,004.63 1,474.40 22,479.03 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 21,004.63 1,474.40 23,953.43 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 23,953.43 ** 52,196.00 Budgeted 28,242.57 Remaining 46 % Used Account: 135-50027-010-000 Dental Insurance 1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 1,734.69 106.85 1,841.54 PR 1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 106.80 1,948.34 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,948.34 ** 5,182.00 Budgeted 3,233.66 Remaining 38 % Used Account: 135-50028-010-000 Vision Insurance 1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 316.15 17.98 334.13 PR 1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 17.94 352.07 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 352.07 ** 994.00 Budgeted 641.93 Remaining 35 % Used Account: 135-50029-010-000 Life Insurance & Other 1459 06/01/2018 June A/P Employee benefits LTD & STD 1,803.31 87.01 1,890.32 METLIFE GROUP BENEFITS 4254 AP 1651 06/29/2018 June A/P Benefits-Café 125 18.00 1,908.32 BenefitMall 4319 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 105.01 1,908.32 ** 2,982.00 Budgeted 1,073.68 Remaining 64 % Used Account: 135-50030-010-000 Social Security Taxes 1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 9,213.19 641.07 9,854.26 PR 1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 649.52 10,503.78 PR 1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 652.23 11,156.01 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,942.82 11,156.01 ** 18,662.00 Budgeted 7,505.99 Remaining 60 % Used Account: 135-50035-010-000 Medicare Taxes 1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 2,154.69 149.93 2,304.62 PR 1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 151.91 2,456.53 PR 1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 152.54 2,609.07 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-50035-010-000 Medicare Taxes Totals: 454.38 2,609.07 ** 4,365.00 Budgeted 1,755.93 Remaining 60 % Used 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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 7,199.36 899.92 8,099.28 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 8,099.28 ** 11,854.00 Budgeted 3,754.72 Remaining 68 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 226.05 .00 226.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 226.05 ** 200.00 Budgeted (26.05) Remaining 113 % 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 1591 06/21/2018 June A/P Dechlor tabs-Flags 50,169.61 517.94 50,687.55 Core & Main LP 4279 AP 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 58.84 50,746.39 AMAZON MKTPLACE PMTS PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE WINNELSON CO 50,169.61 28.58 50,774.97 ROANOKE WINNELSON CO PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 19.50 50,794.47 THE HOME DEPOT #6581 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 107.09 50,901.56 THE HOME DEPOT #6581 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 33.81 50,935.37 THE HOME DEPOT #6581 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 46.47 50,981.84 THE HOME DEPOT #6581 PC 1651 06/29/2018 June A/P Gaskets 27.60 51,009.44 Core & Main LP 4324 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 839.83 51,009.44 ** 100,000.00 Budgeted 48,990.56 Remaining 51 % 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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 CARMEL CARWASH - ROANO 3,887.82 49.95 3,937.77 CARMEL CARWASH - ROANO PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT 66.60 4,004.37 ROANOKE AUTO SUPPLY LT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AUTOZONE #4206 41.98 4,046.35 AUTOZONE #4206 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DISCOUNT TIRE TXD 75 28.50 4,074.85 DISCOUNT TIRE TXD 75 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KWIK KAR LUBE & TUNE O 63.96 4,138.81 KWIK KAR LUBE & TUNE O PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 GIERISCH CARE 0050292 72.37 4,211.18 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 323.36 4,211.18 ** 4,000.00 Budgeted (211.18) Remaining 105 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 BLAGG TIRE & SERVICE 35.00 35.00 BLAGG TIRE & SERVICE PC _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 35.00 35.00 ** 3,500.00 Budgeted 3,465.00 Remaining 1 % Used Account: 135-55135-010-000 Lab Analysis 1591 06/21/2018 June A/P Lab samples-water 5,765.16 280.00 6,045.16 TARRANT CTY PUBLIC HEALTH LAB 4298 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 280.00 6,045.16 ** 5,500.00 Budgeted (545.16) Remaining 110 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-60010-010-000 Communications/Mobiles 1591 06/21/2018 June A/P Cell phones 2,492.62 370.18 2,862.80 VERIZON WIRELESS 4302 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.18 2,862.80 ** 4,700.00 Budgeted 1,837.20 Remaining 61 % Used Account: 135-60020-010-000 Electricity 1591 06/21/2018 June A/P Electricity 5/9-6/8 82,161.55 12,787.14 94,948.69 HUDSON ENERGY SERVICES, LLC 4289 AP _______________ Account: 135-60020-010-000 Electricity Totals: 12,787.14 94,948.69 ** 175,356.00 Budgeted 80,407.31 Remaining 54 % 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 1,536.78 .00 1,536.78 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,536.78 ** 2,785.00 Budgeted 1,248.22 Remaining 55 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 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 17,410.32 .00 17,410.32 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 17,410.32 ** 55,176.00 Budgeted 37,765.68 Remaining 32 % Used Account: 135-60150-010-000 Wholesale Water 1651 06/29/2018 June A/P Wholesale water 1,021,013.08 223,655.16 1,244,668.24 CITY OF FORT WORTH 4323 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 223,655.16 1,244,668.24 ** 2,823,170.00 Budgeted 1,578,501.76 Remaining 44 % 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 1695 06/30/2018 June A/P June Mowing 6,000.00 1,500.00 7,500.00 WATTS ELLISON LLC 4370 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 7,500.00 ** 14,750.00 Budgeted 7,250.00 Remaining 51 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1606 06/30/2018 Texpool Transfers June 202,242.48 25,280.31 227,522.79 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 227,522.79 ** 278,084.00 Budgeted 50,561.21 Remaining 82 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 32,649.00 15.00 32,664.00 GL 1606 06/30/2018 Texpool Transfers June 4,083.00 36,747.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,098.00 36,747.00 ** 48,996.00 Budgeted 12,249.00 Remaining 75 % 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 1609 06/24/2018 June A/P Fuel 6,965.98 987.64 7,953.62 US Bank Voyager Fleet Systems 4368 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 987.64 7,953.62 ** 15,000.00 Budgeted 7,046.38 Remaining 53 % Used Account: 135-65010-010-000 Uniforms 1,249.14 .00 1,249.14 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-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 1591 06/21/2018 June A/P Testing supplies 11,958.84 606.00 12,564.84 HACH COMPANY 4287 AP 1651 06/29/2018 June A/P Chlorine 884.96 13,449.80 DPC INDUSTRIES, INC 4329 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,490.96 13,449.80 ** 20,000.00 Budgeted 6,550.20 Remaining 67 % 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 583.00 .00 583.00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 583.00 ** 1,000.00 Budgeted 417.00 Remaining 58 % Used Account: 135-65050-010-000 Meter Expense 1587 06/21/2018 June A/P meters 21,102.00 3,360.75 24,462.75 ATLAS UTILITY SUPPLY CO. 4276 AP 1651 06/29/2018 June A/P CE endpoints 513.00 24,975.75 ATLAS UTILITY SUPPLY CO. 4318 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 3,873.75 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1591 06/21/2018 June A/P 16" water line 525,538.34 461.02 525,999.36 Halff Associates, INC 4286 AP 1591 06/21/2018 June A/P 16" water line 31,432.06 557,431.42 Halff Associates, INC 4286 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 31,893.08 557,431.42 ** 810,012.00 Budgeted 252,580.58 Remaining 69 % 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 .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % 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 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/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 1,200.08 .00 1,200.08 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,200.08 ** 2,000.00 Budgeted 799.92 Remaining 60 % Used Department 10 Totals: ----------------------------------- 3,843,683.63 ** 348,542.64 Monthly Total 5,657,433.00 Budgeted 1,813,749.37 Remaining 68 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 235,318.69 12,605.43 247,924.12 PR 1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 12,746.59 260,670.71 PR 1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 12,718.82 273,389.53 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 38,070.84 273,389.53 ** 410,866.00 Budgeted 137,476.47 Remaining 67 % Used Account: 135-50010-020-000 Overtime 1448 06/01/2018 MUD PR 06.01.18 Overtime 23,600.81 1,018.40 24,619.21 PR 1548 06/15/2018 MUD PR 06.15.18 Overtime 846.82 25,466.03 PR 1614 06/29/2018 MUD PR 06/29/18 Overtime 823.22 26,289.25 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,688.44 26,289.25 ** 30,000.00 Budgeted 3,710.75 Remaining 88 % 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 1548 06/15/2018 MUD PR 06.15.18 Certification 5,636.00 700.00 6,336.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 6,336.00 ** 8,400.00 Budgeted 2,064.00 Remaining 75 % Used Account: 135-50020-020-000 Retirement 1448 06/01/2018 MUD PR 06.01.18 Retirement 26,611.46 1,260.20 27,871.66 PR 1548 06/15/2018 MUD PR 06.15.18 Retirement 1,322.14 29,193.80 PR 1614 06/29/2018 MUD PR 06/29/18 Retirement 1,252.64 30,446.44 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,834.98 30,446.44 ** 42,243.00 Budgeted 11,796.56 Remaining 72 % Used Account: 135-50026-020-000 Medical Insurance 1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 43,493.33 2,759.36 46,252.69 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 43,493.33 2,759.33 49,012.02 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 49,012.02 ** 62,175.00 Budgeted 13,162.98 Remaining 79 % Used Account: 135-50027-020-000 Dental Insurance 1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 3,204.18 185.96 3,390.14 PR 1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 185.93 3,576.07 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 3,576.07 ** 5,271.00 Budgeted 1,694.93 Remaining 68 % Used Account: 135-50028-020-000 Vision Insurance 1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 567.26 29.46 596.72 PR 1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 29.44 626.16 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 626.16 ** 1,114.00 Budgeted 487.84 Remaining 56 % Used Account: 135-50029-020-000 Life Insurance & Other 1459 06/01/2018 June A/P Employee benefits LTD & STD 3,162.18 120.84 3,283.02 METLIFE GROUP BENEFITS 4254 AP 1651 06/29/2018 June A/P Benefits-Café 125 36.00 3,319.02 BenefitMall 4319 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 156.84 3,319.02 ** 4,281.00 Budgeted 961.98 Remaining 78 % Used Account: 135-50030-020-000 Social Security Taxes 1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 15,650.17 767.07 16,417.24 PR 1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 784.44 17,201.68 PR 1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 842.20 18,043.88 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,393.71 18,043.88 ** 28,314.00 Budgeted 10,270.12 Remaining 64 % Used Account: 135-50035-020-000 Medicare Taxes 1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 3,660.11 179.41 3,839.52 PR 1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 183.44 4,022.96 PR 1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 196.97 4,219.93 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-50035-020-000 Medicare Taxes Totals: 559.82 4,219.93 ** 6,622.00 Budgeted 2,402.07 Remaining 64 % Used 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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 10,784.00 1,348.00 12,132.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 12,132.00 ** 17,990.00 Budgeted 5,858.00 Remaining 67 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1591 06/21/2018 June A/P Post accident drug test 63.00 63.00 126.00 CARENOW CORPORATE 4277 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 126.00 ** 300.00 Budgeted 174.00 Remaining 42 % 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 1591 06/21/2018 June A/P Fan in LS #8 panel 44,421.37 625.89 45,047.26 DHS AUTOMATION, INC 4281 AP 1591 06/21/2018 June A/P Push camera fix 1,626.32 46,673.58 CLS SEWER EQUIPMENT CO., INC 4278 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1591 06/21/2018 June A/P Valves in vault for Lakes A & 44,421.37 16,036.89 62,710.47 REY-MAR CONSTRUCTION 4296 AP 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROYAL BRASS AND HOSE 280.71 62,991.18 ROYAL BRASS AND HOSE PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 GRAINGER 16.82 63,008.00 GRAINGER PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 24.27 63,032.27 THE HOME DEPOT #6581 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 102.69 63,134.96 THE HOME DEPOT #6581 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 FILTER ELEMENT STORE 454.86 63,589.82 FILTER ELEMENT STORE PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 76.54 63,666.36 THE HOME DEPOT #6581 PC 1651 06/29/2018 June A/P oil & grease for blowers 516.99 64,183.35 Universal Blower Pac, Inc 4367 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 19,761.98 64,183.35 ** 86,100.00 Budgeted 21,916.65 Remaining 75 % 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 1651 06/29/2018 June A/P welding 6,353.60 450.00 6,803.60 REY-MAR CONSTRUCTION 4356 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 450.00 6,803.60 ** 8,000.00 Budgeted 1,196.40 Remaining 85 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AUTOZONE #4206 289.69 17.99 307.68 AUTOZONE #4206 PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 RDOCE-FTW- 87.72 395.40 RDOCE-FTW- PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT (119.94) 275.46 ROANOKE AUTO SUPPLY LT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT 119.94 395.40 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 105.71 395.40 ** 500.00 Budgeted 104.60 Remaining 79 % Used Account: 135-55125-020-000 Dumpster Services 1591 06/21/2018 June A/P Dumpster Haul off 55,077.12 1,690.00 56,767.12 L.H. CHANEY MATERIALS, INC. 4292 AP 1651 06/29/2018 June A/P Dumpster services 812.47 57,579.59 L.H. CHANEY MATERIALS, INC. 4347 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,502.47 57,579.59 ** 60,000.00 Budgeted 2,420.41 Remaining 96 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Lab Analysis 1591 06/21/2018 June A/P Lab testing 22,716.02 246.00 22,962.02 OXIDOR LABORATORIES LLC 4295 AP 1591 06/21/2018 June A/P lab testing 176.00 23,138.02 OXIDOR LABORATORIES LLC 4295 AP 1591 06/21/2018 June A/P Lab testing 176.00 23,314.02 OXIDOR LABORATORIES LLC 4295 AP 1591 06/21/2018 June A/P lab testing 176.00 23,490.02 OXIDOR LABORATORIES LLC 4295 AP 1591 06/21/2018 June A/P Lab testing 246.00 23,736.02 OXIDOR LABORATORIES LLC 4295 AP 1651 06/29/2018 June A/P Lab testing 246.00 23,982.02 OXIDOR LABORATORIES LLC 4355 AP 1651 06/29/2018 June A/P Lab testing 176.00 24,158.02 OXIDOR LABORATORIES LLC 4355 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,442.00 24,158.02 ** 30,000.00 Budgeted 5,841.98 Remaining 81 % Used Account: 135-60010-020-000 Communications/Mobiles 1591 06/21/2018 June A/P Cell phones 3,393.00 332.19 3,725.19 VERIZON WIRELESS 4302 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 332.19 3,725.19 ** 4,700.00 Budgeted 974.81 Remaining 79 % Used Account: 135-60020-020-000 Electricity 1591 06/21/2018 June A/P Electricity 4/24-5/24 110,273.38 27.90 110,301.28 TRI COUNTY ELECTRIC 4300 AP 1591 06/21/2018 June A/P Electricity 4/24-5/24 307.43 110,608.71 TRI COUNTY ELECTRIC 4300 AP 1591 06/21/2018 June A/P Electricity 4/24-5/24 182.03 110,790.74 TRI COUNTY ELECTRIC 4300 AP 1591 06/21/2018 June A/P Electricity 5/9-6/8 11,247.75 122,038.49 HUDSON ENERGY SERVICES, LLC 4289 AP 1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (202.28) 121,836.21 AR _______________ Account: 135-60020-020-000 Electricity Totals: 11,562.83 121,836.21 ** 266,709.00 Budgeted 144,872.79 Remaining 46 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .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 .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-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 .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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 19.97 21.91 41.88 THE HOME DEPOT #6581 PC _______________ Account: 135-60280-020-000 Property Maintenance Totals: 21.91 41.88 ** 4,000.00 Budgeted 3,958.12 Remaining 1 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1695 06/30/2018 June A/P June Mowing 4,600.00 1,180.00 5,780.00 WATTS ELLISON LLC 4370 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 5,780.00 ** 11,600.00 Budgeted 5,820.00 Remaining 50 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1606 06/30/2018 Texpool Transfers June 88,758.48 11,094.81 99,853.29 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 99,853.29 ** 122,043.00 Budgeted 22,189.71 Remaining 82 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1606 06/30/2018 Texpool Transfers June 435,445.76 54,430.72 489,876.48 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 489,876.48 ** 598,738.00 Budgeted 108,861.52 Remaining 82 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 82,194.00 30.00 82,224.00 GL 1606 06/30/2018 Texpool Transfers June 10,278.00 92,502.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,308.00 92,502.00 ** 123,336.00 Budgeted 30,834.00 Remaining 75 % Used Account: 135-60334-020-000 Interfund Transfer Out . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1606 06/30/2018 Texpool Transfers June 201,031.99 142,059.21 343,091.20 GL 1606 06/30/2018 Texpool Transfers June 309.78 343,400.98 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 142,368.99 343,400.98 ** 200,000.00 Budgeted (143,400.98) Remaining 172 % 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 1609 06/24/2018 June A/P Fuel 6,265.67 644.06 6,909.73 US Bank Voyager Fleet Systems 4368 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 644.06 6,909.73 ** 12,500.00 Budgeted 5,590.27 Remaining 55 % 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 1591 06/21/2018 June A/P CIP Solutions 8,041.23 657.00 8,698.23 Valley Solvent Company, INC 4301 AP 1651 06/29/2018 June A/P CIP solution 536.00 9,234.23 Valley Solvent Company, INC 4369 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,193.00 9,234.23 ** 27,500.00 Budgeted 18,265.77 Remaining 34 % Used Account: 135-65035-020-000 Small Tools 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 SAMSCLUB.COM 1,149.94 239.94 1,389.88 SAMSCLUB.COM PC _______________ Account: 135-65035-020-000 Small Tools Totals: 239.94 1,389.88 ** 1,000.00 Budgeted (389.88) Remaining 139 % Used Account: 135-65040-020-000 Safety Equipment . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1591 06/21/2018 June A/P lab supplies 13,483.81 2,083.79 15,567.60 IDEXX DISTRIBUTION, INC 4290 AP 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 TOM THUMB #1789 3.96 15,571.56 TOM THUMB #1789 PC 1651 06/29/2018 June A/P Lab supplies 72.68 15,644.24 HACH COMPANY 4336 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,160.43 15,644.24 ** 14,000.00 Budgeted (1,644.24) Remaining 112 % Used Account: 135-69005-020-000 Capital Outlays 1591 06/21/2018 June A/P Second half of payment 91,150.61 12,471.18 103,621.79 DHS AUTOMATION, INC 4281 AP 1591 06/21/2018 June A/P Legal WWTP 297.50 103,919.29 Dubois Bryant Campbell LLP 4283 AP 1651 06/29/2018 June A/P SCADA LS #2 2,600.00 106,519.29 DHS AUTOMATION, INC 4328 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 15,368.68 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 .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ----------------------------------- 1,954,139.24 ** 330,932.83 Monthly Total 2,981,140.00 Budgeted 1,027,000.76 Remaining 66 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 19.36 2.42 21.78 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 21.78 ** 30.00 Budgeted 8.22 Remaining 73 % 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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 WAL-MART #5247 1,215.00 43.85 1,258.85 WAL-MART #5247 PC _______________ Account: 135-60075-026-000 Meetings Totals: 43.85 1,258.85 ** 1,200.00 Budgeted (58.85) Remaining 105 % Used Account: 135-60080-026-000 Schools & Training 1,540.00 .00 1,540.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,540.00 ** 4,000.00 Budgeted 2,460.00 Remaining 39 % Used Account: 135-60100-026-000 Travel & per diem 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 HYATT HOTELS 960.00 244.01 1,204.01 HYATT HOTELS PC 1651 06/29/2018 June A/P AWBD conference, hotel, mileag 661.43 1,865.44 William Rose 4372 AP 1651 06/29/2018 June A/P AWBD conference, hotel, mileag 533.04 2,398.48 Steve Flynn 4362 AP 1651 06/29/2018 June A/P AWBD conference, hotel, mileag 914.66 3,313.14 Gregory Wilson 4335 AP 1651 06/29/2018 June A/P AWBD conference, hotel, mileag 1,039.14 4,352.28 Kelly Castonguay 4343 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 3,392.28 4,352.28 ** 5,000.00 Budgeted 647.72 Remaining 87 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 PANERA BREAD #601996 1,255.28 148.98 1,404.26 PANERA BREAD #601996 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 148.98 1,404.26 ** 2,000.00 Budgeted 595.74 Remaining 70 % Used Department 26 Totals: ----------------------------------- 9,227.17 ** 3,587.53 Monthly Total 12,980.00 Budgeted 3,752.83 Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 248,159.41 11,460.10 259,619.51 PR 1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 11,465.80 271,085.31 PR 1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 12,426.03 283,511.34 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,351.93 283,511.34 ** 432,863.00 Budgeted 149,351.66 Remaining 65 % Used Account: 135-50010-030-000 Overtime 556.92 .00 556.92 _______________ Account: 135-50010-030-000 Overtime Totals: .00 556.92 ** 2,000.00 Budgeted 1,443.08 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 1448 06/01/2018 MUD PR 06.01.18 Retirement 25,641.34 1,060.05 26,701.39 PR 1548 06/15/2018 MUD PR 06.15.18 Retirement 1,060.60 27,761.99 PR 1614 06/29/2018 MUD PR 06/29/18 Retirement 1,149.40 28,911.39 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,270.05 28,911.39 ** 40,553.00 Budgeted 11,641.61 Remaining 71 % Used Account: 135-50026-030-000 Medical Insurance 1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 31,483.69 1,777.75 33,261.44 PR 1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 1,777.73 35,039.17 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,555.48 35,039.17 ** 63,485.00 Budgeted 28,445.83 Remaining 55 % Used Account: 135-50027-030-000 Dental Insurance 1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 2,271.96 113.20 2,385.16 PR 1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 113.17 2,498.33 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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: 226.37 2,498.33 ** 5,502.00 Budgeted 3,003.67 Remaining 45 % Used Account: 135-50028-030-000 Vision Insurance 1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 426.43 17.98 444.41 PR 1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 17.94 462.35 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 35.92 462.35 ** 1,173.00 Budgeted 710.65 Remaining 39 % Used Account: 135-50029-030-000 Life Insurance & Other 1459 06/01/2018 June A/P Employee benefits LTD & STD 2,694.84 100.24 2,795.08 METLIFE GROUP BENEFITS 4254 AP 1651 06/29/2018 June A/P Benefits-Café 125 18.00 2,813.08 BenefitMall 4319 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 118.24 2,813.08 ** 5,059.00 Budgeted 2,245.92 Remaining 56 % Used Account: 135-50030-030-000 Social Security Taxes 1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 15,024.46 672.30 15,696.76 PR 1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 670.23 16,366.99 PR 1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 770.42 17,137.41 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,112.95 17,137.41 ** 27,181.00 Budgeted 10,043.59 Remaining 63 % Used Account: 135-50035-030-000 Medicare Taxes 1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 3,513.78 157.23 3,671.01 PR 1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 156.74 3,827.75 PR 1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 180.17 4,007.92 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 494.14 4,007.92 ** 6,357.00 Budgeted 2,349.08 Remaining 63 % Used Account: 135-50040-030-000 Unemployment Taxes 1614 06/29/2018 MUD PR 06/29/18 Unemployment Taxes 983.77 17.31 1,001.08 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 17.31 1,001.08 ** 1,260.00 Budgeted 258.92 Remaining 79 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 988.00 123.50 1,111.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 1,111.50 ** 1,529.00 Budgeted 417.50 Remaining 73 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 1681 06/30/2018 June A/P New hire-Desiree 124.95 86.95 211.90 FIRST CHECK APPLICANT SCREENIN 4332 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 86.95 211.90 ** 500.00 Budgeted 288.10 Remaining 42 % Used Account: 135-50070-030-000 Employee Relations 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KIM S DONUTS 3,109.08 38.10 3,147.18 KIM S DONUTS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 38.10 3,147.18 ** 4,960.00 Budgeted 1,812.82 Remaining 63 % Used Account: 135-55030-030-000 Software & Support 1459 06/01/2018 June A/P annual maintenance-Remitplus 59,433.04 1,856.58 61,289.62 JACK HENRY & ASSOC, INC 4246 AP 1591 06/21/2018 June A/P Final internet bill (5/1-5/10) 346.55 61,636.17 WHOLESALE CARRIER SERVICES INC 4306 AP 1591 06/21/2018 June A/P Email, MS office 456.00 62,092.17 M3 Networks 4293 AP 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DNH*GODADDY.COM 39.34 62,131.51 DNH*GODADDY.COM PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 85.71 62,217.22 ATT*BILL PAYMENT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 124.34 62,341.56 ATT*BILL PAYMENT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 107.79 62,449.35 ATT*BILL PAYMENT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ADOBE SYSTEMS INC 16.23 62,465.58 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,032.54 62,465.58 ** 78,391.00 Budgeted 15,925.42 Remaining 80 % Used Account: 135-55070-030-000 Independent Labor 1692 06/29/2018 June A/P June GM 101,827.93 11,850.00 113,677.93 Carman Consulting LLC. 4321 AP 1692 06/29/2018 June A/P June GM 22.89 113,700.82 Carman Consulting LLC. 4321 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,872.89 113,700.82 ** 154,000.00 Budgeted 40,299.18 Remaining 74 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1591 06/21/2018 June A/P office generator repair 3,955.00 669.58 4,624.58 Sluder Emergency Power Service 4297 AP _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: 669.58 4,624.58 ** 10,000.00 Budgeted 5,375.42 Remaining 46 % Used Account: 135-55120-030-000 Cleaning Services 1600 06/22/2018 June A/P Janitorial service 5,700.51 869.06 6,569.57 MEMBER'S BUILDING MAINTENANCE 4311 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 6,569.57 ** 10,000.00 Budgeted 3,430.43 Remaining 66 % 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 1681 06/30/2018 June A/P June Billings 4,705.92 1,001.44 5,707.36 DATAPROSE LLC 4327 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,001.44 5,707.36 ** 9,000.00 Budgeted 3,292.64 Remaining 63 % Used Account: 135-60005-030-000 Telephone 1587 06/21/2018 June A/P Answering service 11,857.33 207.75 12,065.08 KEYSTONE PARK SECRETARIAL 4291 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 11,857.33 190.78 12,255.86 ATT*BILL PAYMENT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 RINGCENTRAL, INC 13.95 12,269.81 RINGCENTRAL, INC PC 1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (180.00) 12,089.81 AR _______________ Account: 135-60005-030-000 Telephone Totals: 232.48 12,089.81 ** 27,300.00 Budgeted 15,210.19 Remaining 44 % Used Account: 135-60010-030-000 Communications/Mobiles 1548 06/15/2018 MUD PR 06.15.18 Communications/Mobiles 2,036.80 150.00 2,186.80 PR 1591 06/21/2018 June A/P Cell phones 87.37 2,274.17 VERIZON WIRELESS 4302 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.37 2,274.17 ** 4,000.00 Budgeted 1,725.83 Remaining 57 % Used Account: 135-60020-030-000 Electricity/Gas 1692 06/29/2018 June A/P 3/9-4/10 & 4/10-5/9 Admin Elec 3,852.21 963.22 4,815.43 TOWN OF TROPHY CLUB 4365 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 963.22 4,815.43 ** 16,261.00 Budgeted 11,445.57 Remaining 30 % Used Account: 135-60025-030-000 Water 1600 06/22/2018 June A/P May water 339.12 116.64 455.76 TROPHY CLUB MUD (WATER BILLS) 4314 AP 1651 06/29/2018 June A/P June water 136.50 592.26 TROPHY CLUB MUD (WATER BILLS) 4366 AP 1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (68.25) 524.01 AR _______________ Account: 135-60025-030-000 Water Totals: 184.89 524.01 ** 2,500.00 Budgeted 1,975.99 Remaining 21 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 1591 06/21/2018 June A/P overnight-TCEQ 14,557.37 6.93 14,564.30 FEDERAL EXPRESS CORP 4285 AP 1681 06/30/2018 June A/P June Billings 3,015.62 17,579.92 DATAPROSE LLC 4327 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-60035-030-000 Postage Totals: 3,022.55 17,579.92 ** 30,000.00 Budgeted 12,420.08 Remaining 59 % Used Account: 135-60040-030-000 Service Charges & Fees 1451 06/01/2018 Child Support Fee 38,717.32 1.50 38,718.82 GL 1549 06/15/2018 Child Support Fee 1.50 38,720.32 GL 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DENTON COUNTY, TX SOUT 2.00 38,722.32 DENTON COUNTY, TX SOUT PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DENTON COUNTY, TX SOUT 1.00 38,723.32 DENTON COUNTY, TX SOUT PC 1615 06/29/2018 Child Support Fee 1.50 38,724.82 GL 1526 06/30/2018 Pace Credit Card Fees 4,801.82 43,526.64 GL 1526 06/30/2018 Pace Credit Card Fees 89.76 43,616.40 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,899.08 43,616.40 ** 55,560.00 Budgeted 11,943.60 Remaining 79 % 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 240 06/01/2018 Insurance/Wrk Comp Exp Jun 52,077.88 6,100.36 58,178.24 GL 1591 06/21/2018 June A/P Director bonds 2018 200.00 58,378.24 VICTOR O SCHINNERER & CO, INC 4303 AP 1591 06/21/2018 June A/P Director Bonds 2019 & 2020 320.00 58,698.24 VICTOR O SCHINNERER & CO, INC 4303 AP _______________ Account: 135-60055-030-000 Insurance Totals: 6,620.36 58,698.24 ** 56,000.00 Budgeted (2,698.24) Remaining 105 % 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 Account: 135-60070-030-000 Dues & Memberships 3,828.42 .00 3,828.42 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 Totals: .00 3,828.42 ** 6,000.00 Budgeted 2,171.58 Remaining 64 % 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 3,143.00 .00 3,143.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,143.00 ** 7,600.00 Budgeted 4,457.00 Remaining 41 % Used Account: 135-60100-030-000 Travel & per diem 1548 06/15/2018 MUD PR 06.15.18 Travel & per diem 843.72 81.53 925.25 PR 1614 06/29/2018 MUD PR 06/29/18 Travel & per diem 33.46 958.71 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 114.99 958.71 ** 4,885.00 Budgeted 3,926.29 Remaining 20 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 220.00 .00 220.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 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 1591 06/21/2018 June A/P Panic button monitor 96.00 24.00 120.00 Digital Air Control, Inc 4282 AP 1591 06/21/2018 June A/P Panic button monitor 24.00 144.00 Digital Air Control, Inc 4282 AP _______________ Account: 135-60235-030-000 Security Totals: 48.00 144.00 ** 2,700.00 Budgeted 2,556.00 Remaining 5 % 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 1568 06/01/2018 Comp Study Capital-GM Conting Comp Study- Seagal Waters 17,000.00 17,000.00 GL _______________ Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.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 273.73 .00 273.73 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KELLER TROPHY & AWAR 3,586.24 50.00 3,636.24 KELLER TROPHY & AWAR PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 47.07 3,683.31 AMAZON MKTPLACE PMTS PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 30.60 3,713.91 AMAZON MKTPLACE PMTS PC 1651 06/29/2018 June A/P Office supplies 100.82 3,814.73 OFFICE DEPOT, INC 4354 AP 1651 06/29/2018 June A/P Office supplies 55.79 3,870.52 OFFICE DEPOT, INC 4354 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 284.28 3,870.52 ** 7,000.00 Budgeted 3,129.48 Remaining 55 % 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 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 3,267.45 14.96 3,282.41 AMAZON MKTPLACE PMTS PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON.COM 7.92 3,290.33 AMAZON.COM PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 95.68 3,386.01 AMAZON MKTPLACE PMTS PC 1682 06/26/2018 Pcard 05/29/18 - 06/26/18 WAL-MART #5247 34.03 3,420.04 WAL-MART #5247 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 152.59 3,420.04 ** 4,000.00 Budgeted 579.96 Remaining 86 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 1568 06/01/2018 Comp Study Capital-GM Conting Comp Study- Seagal Waters 37,327.32 (17,000.00) 20,327.32 GL 1651 06/29/2018 June A/P Second half-Security project 19,527.67 39,854.99 3RD EYE SURVEILLANCE SYSTEMS 4315 AP 1651 06/29/2018 June A/P comp salary survey 8,500.00 48,354.99 Segal Waters Consulting 4359 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 11,027.67 48,354.99 ** 13,000.00 Budgeted (35,354.99) Remaining 372 % Used Account: 135-69170-030-000 Copier Lease Installments 1591 06/21/2018 June A/P copier lease 1,990.55 165.00 2,155.55 EVERBANK COMMERCIAL FINANCE 4284 AP 1651 06/29/2018 June A/P Lease-copies 61.31 2,216.86 KYOCERA DOCUMENT SOLUTIONS 4346 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 226.31 2,216.86 ** 4,600.00 Budgeted 2,383.14 Remaining 48 % Used Department 30 Totals: ----------------------------------- 870,043.03 ** 107,890.24 Monthly Total 1,227,112.00 Budgeted 357,068.97 Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1591 06/21/2018 June A/P Legal-Southlake easement 59,261.93 24,306.84 83,568.77 WHITAKER CHALK SWINDLE 4305 AP 1591 06/21/2018 June A/P legal 5,280.00 88,848.77 McLean & Howard, L.L.P. 4294 AP 1591 06/21/2018 June A/P legal travel board 1,050.00 89,898.77 McLean & Howard, L.L.P. 4294 AP 1701 06/30/2018 June A/P Legal 8,250.00 98,148.77 McLean & Howard, L.L.P. 4349 AP 1701 06/30/2018 June A/P Legal 1,050.00 99,198.77 McLean & Howard, L.L.P. 4349 AP _______________ Account: 135-55045-039-000 Legal Totals: 39,936.84 99,198.77 ** 137,000.00 Budgeted 37,801.23 Remaining 72 % 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: ----------------------------------- 136,509.79 ** 39,936.84 Monthly Total 176,746.00 Budgeted 40,236.21 Remaining 77 % Used Fund 135 Totals: ----------------------------------- (1,534,162.39) (218,645.12) Monthly Total (194,618.00) Budgeted 1,339,544.39 Remaining 788 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/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 JUNE 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 803,772 TOTAL LIABILITIES 803,772 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,796,351) TOTAL FUND BALANCE (803,772) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 19:44 07/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/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 19:44 07/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/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 142,368.99- 343,400.98- 343,400.98 Subtotal: 142,368.99- 343,400.98- 343,400.98 Program number: 142,368.99- 343,400.98- 343,400.98 Department number: Wastewater 142,368.99- 343,400.98- 343,400.98 Revenues Subtotal ----------- 142,368.99- 352,749.14- 352,749.14 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 19:44 07/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/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 154.89- Subtotal: 154.89 154.89 154.89- 517-69005-020-000 Capital Outlays 142,510.23 2,148,945.58 2,148,945.58- Subtotal: 142,510.23 2,148,945.58 2,148,945.58- Program number: 142,665.12 2,149,100.47 2,149,100.47- Department number: Wastewater 142,665.12 2,149,100.47 2,149,100.47- Expenditures Subtotal ----------- 142,665.12 2,149,100.47 2,149,100.47- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 296.13 1,796,351.33 1,796,351.33- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/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 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/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 1606 06/30/2018 Texpool Transfers June (201,031.99) (142,059.21) (343,091.20) GL 1606 06/30/2018 Texpool Transfers June (309.78) (343,400.98) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (142,368.99) (343,400.98) ** .00 Budgeted 343,400.98 Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1685 06/30/2018 Transfer 517 Pros to 135 Pros $0 out 517 to 135 154.89 154.89 GL _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: 154.89 154.89 ** .00 Budgeted (154.89) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 1591 06/21/2018 June A/P WWTP Improvements 2,006,435.35 22,436.15 2,028,871.50 CP&Y/WALLACE GROUP, INC. 4280 AP 1651 06/29/2018 June A/P WWTP Improvement 112,474.59 2,141,346.09 WEBBER-CADAGUA PARTNERS 4371 AP 1681 06/30/2018 June A/P WWTP Improvements 7,599.49 2,148,945.58 CP&Y/WALLACE GROUP, INC. 4325 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 142,510.23 2,148,945.58 ** .00 Budgeted (2,148,945.58) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,805,699.49 ** 296.13 Monthly Total .00 Budgeted (1,805,699.49) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,796,351.33 296.13 Monthly Total .00 Budgeted (1,796,351.33) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JUNE 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 19:44 07/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 6/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 19:44 07/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 6/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,484.87 1,851,614.33 1,851,614.33- Subtotal: 1,484.87 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: 1,484.87 4,544,823.01 4,544,823.01- Department number: Water 1,484.87 4,544,823.01 4,544,823.01- Expenditures Subtotal ----------- 1,484.87 4,544,823.01 4,544,823.01- Fund number: 519 2016 Rev Bond Const-SWIFT 1,484.87 3,489,353.76 3,489,353.76- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 6/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 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 6/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 1552 06/04/2018 Texpl Tsfr May Int 519 to 135 1,850,129.46 1,484.87 1,851,614.33 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: 1,484.87 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 ** 1,484.87 Monthly Total .00 Budgeted (4,544,823.01) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,489,353.76 1,484.87 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET JUNE 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 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 561,007 ACCOUNTS RECEIVABLE - TOTAL ASSETS 561,007 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 134,429 TOTAL FUND BALANCE 561,007 TOTAL LIABILITIES AND FUND BALANCE 561,007 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 19:44 07/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/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- 814.67- 5,179.61- 517.961 4,179.61 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,098.00- 36,747.00- 75.000 12,249.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,308.00- 92,502.00- 75.000 30,834.00- Subtotal: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39- Program number: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39- Department number: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/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 1684 06/30/2018 Bank Interest- June (4,364.94) (814.67) (5,179.61) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (814.67) (5,179.61) ** (1,000.00) Budgeted 4,179.61 Remaining 518 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 (32,649.00) (15.00) (32,664.00) GL 1606 06/30/2018 Texpool Transfers June (4,083.00) (36,747.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,098.00) (36,747.00) ** (48,996.00) Budgeted (12,249.00) Remaining 75 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 (82,194.00) (30.00) (82,224.00) GL 1606 06/30/2018 Texpool Transfers June (10,278.00) (92,502.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,308.00) (92,502.00) ** (123,336.00) Budgeted (30,834.00) Remaining 75 % Used Department Totals: ----------------------------------- (134,428.61) ** (15,220.67) Monthly Total (173,332.00) Budgeted (38,903.39) Remaining 78 % Used Fund 528 Totals: ----------------------------------- (134,428.61) (15,220.67) Monthly Total (173,332.00) Budgeted (38,903.39) Remaining 78 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JUNE 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 888,505 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,199 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 905,276 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,199 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,199 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 860,737 TOTAL FUND BALANCE 893,077 TOTAL LIABILITIES AND FUND BALANCE 905,276 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 19:44 07/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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- 2,405.60- 674,318.61- 100.696 4,658.61 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 11.24- 2,597.59- 144.311 797.59 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 115.99- 1,911.39- 95.570 88.61- Subtotal: 673,460.00- 673,460.00- 2,532.83- 678,827.59- 100.797 5,367.59 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,304.34- 6,305.39- 315.270 4,305.39 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- 99,853.29- 81.818 22,189.71- Subtotal: 342,997.00- 342,997.00- 12,399.15- 325,112.68- 94.786 17,884.32- Program number: 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73- Department number: Revenues 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 19:44 07/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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,931.98- 860,736.52- ############### 854,937.52 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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 1664 06/01/2018 Property Taxes (671,913.01) (328.54) (672,241.55) GL 1665 06/04/2018 Property Taxes (518.31) (672,759.86) GL 1666 06/05/2018 Property Taxes (35.21) (672,795.07) GL 1667 06/07/2018 Property Taxes (660.87) (673,455.94) GL 1668 06/11/2018 Property Taxes (117.81) (673,573.75) GL 1669 06/12/2018 Property Taxes (8.01) (673,581.76) GL 1670 06/13/2018 Property Taxes (643.16) (674,224.92) GL 1671 06/15/2018 Property Taxes (12.65) (674,237.57) GL 1672 06/18/2018 Property Taxes (23.15) (674,260.72) GL 1673 06/19/2018 Property Taxes (44.41) (674,305.13) GL 1674 06/21/2018 Property Taxes (2.69) (674,307.82) GL 1675 06/22/2018 Property Taxes (7.85) (674,315.67) GL 1676 06/25/2018 Property Taxes (13.25) (674,328.92) GL 1677 06/26/2018 Property Taxes (22.29) (674,351.21) GL 1678 06/28/2018 Property Taxes (1.21) (674,352.42) GL 1679 06/29/2018 Property Taxes 33.81 (674,318.61) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,405.60) (674,318.61) ** (669,660.00) Budgeted 4,658.61 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1665 06/04/2018 Property Taxes (2,586.35) (23.34) (2,609.69) GL 1679 06/29/2018 Property Taxes 12.10 (2,597.59) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (11.24) (2,597.59) ** (1,800.00) Budgeted 797.59 Remaining 144 % Used Account: 533-40015-000-000 Property Taxes/P & I 1664 06/01/2018 Property Taxes (1,795.40) (4.89) (1,800.29) GL 1665 06/04/2018 Property Taxes (5.19) (1,805.48) GL 1667 06/07/2018 Property Taxes (82.85) (1,888.33) GL 1668 06/11/2018 Property Taxes (17.67) (1,906.00) GL 1670 06/13/2018 Property Taxes (1.93) (1,907.93) GL 1671 06/15/2018 Property Taxes (1.90) (1,909.83) GL 1677 06/26/2018 Property Taxes (1.56) (1,911.39) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (115.99) (1,911.39) ** (2,000.00) Budgeted (88.61) Remaining 96 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1684 06/30/2018 Bank Interest- June (5,001.05) (1,304.34) (6,305.39) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,304.34) (6,305.39) ** (2,000.00) Budgeted 4,305.39 Remaining 315 % 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 1606 06/30/2018 Texpool Transfers June (88,758.48) (11,094.81) (99,853.29) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (99,853.29) ** (122,043.00) Budgeted (22,189.71) Remaining 82 % Used Department Totals: ----------------------------------- (1,003,940.27) ** (14,931.98) Monthly Total (1,016,457.00) Budgeted (12,516.73) Remaining 99 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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: ----------------------------------- (860,736.52) (14,931.98) Monthly Total (5,799.00) Budgeted 854,937.52 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JUNE 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 396,346 ACCOUNTS RECEIVABLE - TOTAL ASSETS 396,346 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 380,136 TOTAL FUND BALANCE 396,346 TOTAL LIABILITIES AND FUND BALANCE 396,346 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 19:44 07/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/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- 516.68- 2,127.85- 212.785 1,127.85 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 489,876.48- 81.818 108,861.52- Subtotal: 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67- Program number: 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67- Department number: Revenues 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 19:44 07/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/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- 54,947.40- 380,135.58- ############### 379,135.58 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/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 1684 06/30/2018 Bank Interest- June (1,611.17) (516.68) (2,127.85) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (516.68) (2,127.85) ** (1,000.00) Budgeted 1,127.85 Remaining 213 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1606 06/30/2018 Texpool Transfers June (435,445.76) (54,430.72) (489,876.48) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (489,876.48) ** (598,738.00) Budgeted (108,861.52) Remaining 82 % Used Department Totals: ----------------------------------- (492,004.33) ** (54,947.40) Monthly Total (599,738.00) Budgeted (107,733.67) Remaining 82 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/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: ----------------------------------- (380,135.58) (54,947.40) Monthly Total (1,000.00) Budgeted 379,135.58 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 197,971 ACCOUNTS RECEIVABLE - TOTAL ASSETS 197,971 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 197,019 TOTAL FUND BALANCE 197,971 TOTAL LIABILITIES AND FUND BALANCE 197,971 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 19:44 07/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 6/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- 260.62- 1,038.41- 173.068 438.41 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 227,522.79- 81.818 50,561.21- Subtotal: 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80- Program number: 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80- Department number: Revenues 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 19:44 07/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 6/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,540.93- 197,019.45- ############### 196,419.45 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 6/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 1684 06/30/2018 Bank Interest- June (777.79) (260.62) (1,038.41) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (260.62) (1,038.41) ** (600.00) Budgeted 438.41 Remaining 173 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1606 06/30/2018 Texpool Transfers June (202,242.48) (25,280.31) (227,522.79) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (227,522.79) ** (278,084.00) Budgeted (50,561.21) Remaining 82 % Used Department Totals: ----------------------------------- (228,561.20) ** (25,540.93) Monthly Total (278,684.00) Budgeted (50,122.80) Remaining 82 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 19:45 07/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 6/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: ----------------------------------- (197,019.45) (25,540.93) Monthly Total (600.00) Budgeted 196,419.45 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 1,870,378.22 **** (228,738.53) Monthly Total (375,349.00) Budgeted (2,245,727.22) Remaining ########## ******* End of Report *********