Loading...
HomeMy WebLinkAbout2020-06 Combined Financials June 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET JUNE 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 808,765 PREPAID EXPENSES 4,923 ADVALOREM PROPERTY TAXES RECEIVABLE 29,098 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 842,786 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 29,105 TOTAL LIABILITIES 29,105 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 209,913 TOTAL FUND BALANCE 813,682 TOTAL LIABILITIES AND FUND BALANCE 842,786 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 122-40020-000-000 Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 3,955.53- 1,216,517.28- 103.45- 2,866.10- 990.96- 5,291.88- 100.188 2,287.28 2,866.10 5,291.88 Page 1 Subtotal: 1,214,230.00- 1,214,230.00- 5,049.94- 1,224,675.26- 100.860 10,445.26 Program number: 1,214,230.00- 1,214,230.00- 5,049.94- 1,224,675.26- 100.860 10,445.26 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 5,049.94- 1,224,675.26- 100.860 10,445.26 I Revenues Subtotal 1,214,230.00- 1,214,230.00- 5,049.94- 1,224,675.26- 100.860 10,445.26 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 tota1: 957,661.00 957,661.00 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 Subtota1: 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire 1,214,230.00 1,214,230.00 Expenditures Subtotal 1,214,230.00 1,214,230.00 Fund number: 122 Trophy Club MUD Fire Dept. 1,640.88 59,888.08 218,004.00 14,767.92 538,992.72 100.000 70.323 75.000 6,232.08 179,664.28 61,528.96 185,896.36 31,679.00 2,879.76- 2,879.76 31704,14 34,429.00 9,078.48 81,420.00 118,070.12 93,207.96 93,20 4 4 71.727 13,571.00 9,078.48- 100.000 92.860 9,078.88 Page 2 94. X571.40 83.572 83.572 83.572 199,467.76 199,467.76 199,467.76 209,913.02 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010,090 1446 06/01/2020 Property Taxes 1447 06/02/2020 Property Taxes 1448 06/03/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1452 06/10/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1461 06/29/2020 Property Taxes Account: 122 -40010 -000 - Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 6/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page Check Source Number Property Taxes/MUD Fire Property Taxes/MUD Fire Totals: (1,214,230.00) Budgeted (1,212,561.75) 2,287.28 Remaining 100 % Used (378.65) (1,212,940.40) (1,091.72) (1,214,032.12) (182.26) (1,214,214.38) (45.12) (1,214,259.50) (5,076.15) (1,219,335.65) (397.36) (1,219,733.01) (136.52) (1,219,869.53) (696.03) (1,220,565.56) (238.81) (1,220,804.37) (45.25) (1,220,849.62) (51.58) (1,220,901.20) 4,483.59 (1,216,417.61) (29.91) (1,216,447.52) (29.68) (1,216,477.20) (40.08) (1,216,517.28) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40011-000-00 1449 06/04/2020 Property Taxes 1454 06/12/2020 Property Taxes 1456 06/17/2020 Property Taxes 1460 06/25/2020 Property Taxes 1462 06/30/2020 Property Taxes Property Taxes/Fire-Delinquent Account: 122-40011-000-00 Property Taxes/Fire-Delinquent Totals .00 Budgeted 2,866.10 Remaining Account: 122-40020-000-00 1446 06/01/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1452 06/10/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes Property Taxes/Fire P&I (2,762.65) (4,300.92) (17.52) (2,780.17) (44.75) (2,824.92) (19.12) (2,844.04) (9.72) (2,853.76) (12.34) (2,866.10) 0 % Used (12.31) (4,313.23) (4.21) (4,317.44) (712.36) (5,029.80) (46.28) (5,076.08) (16.42) (5,092.50) (104.41) (5,196.91) (44.32) (5,241.23) (3.16) (5,244.39) (9.24) (5,253.63) (17.42) (5,271.05) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 20:46 07/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1460 06/25/2020 Property Taxes 1461 06/29/2020 Property Taxes 1462 06/30/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 6/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Account: 122-40024000- Property Taxes/Fire P51 Totals: Department Totals: .00 Budgeted (5,049.94) Monthly Total (4,300.92) ■ 5,291.88 Remaining 0 % Used (1.06) (5,272.11) (9.38) (5,281.49) (2.53) (5,284.02) (5.03) (5,289.05) (2.83) (5,291.88) (1,224,675.26) ** (1,214,230.00) Budgeted 10,445.26 Remaining 101 % Used Page 2 Check Source Number GL GL GL GL GL glpdatb2 skrolczyk 20:46 07/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Period Ending: 6/2020 Program: JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 3 Check Source Number Account: 122-60030-045-000 Rent And/Or Usage 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 74 06/01/2020 Insurance/Wrk Comp Expense Jun 13,127.04 1,640.88 14,767.92 GL Account: 122-60055-045-000 Insurance Totals: 11111,640.88 14,767.92 ** 21,000.00 Budgeted 6,232.08 Remaining 70 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1252 06/02/2020 June A/P Fire admin June 479,104.64 59,888.08 538,992.72 TOWN OF TROPHY CLUB 6479 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 538,992.72 ** 718,657.00 Budgeted 179,664.28 Remaining 75 % Used Account: 122-69005-045-000 Capital Outlays 1344 06/19/2020 June A/P FD Excavation tools 2,750.00 31,679.00 34,429.00 MUNICIPAL EMERGENCY SERVICES 6535 AP Account: 122-69005-045-000 Capital Outlays Totals: 31,679.00 34,429.00 ** 48,000.00 Budgeted 13,571.00 Remaining 72 % Used Account: 122-69009-045-000 Short Term Debt -Interest 1368 06/30/2020 Correct Int/Prin Fire Trk FY20 Correct Interest in Cap Lease 11,958.24 (2,879.76) 9,078.48 GL Account: 122-69009-045-000 Short Term Debt -Interest Totals: (2,879.76) 9,078.48 ** .00 Budgeted (9,078.48) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases ■ glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1368 06/30/2020 Correct Int/Prin Fire Trk FY20 Correct Interest in Cap Lease 115,190.36 Capital Leases Totals: 127,149.00 Budgeted 2,879.76 118,070.12 9,078.88 Remaining 93 % Used Department 45 Totals: 1,014,762.24 •• 93,207.96 Monthly Total 1,214,230.00 Budgeted 199,467.76 Remaining 84 % Used Fund 122 Totals: (209,913.02) 88,158.02 Monthly Total .00 Budgeted 209,913.02 Remaining 0 % Used oL TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JUNE 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,335,854 3,335,854 CASH IN BANK -SAVINGS -CASH RESERVE 1,606,010 1,606,010 INVESTMENTS-TEXPOOL 3,459,560 919,266 4,378,826 PREPAID EXPENSES 30,447 30,447 ADVALOREM PROPERTY TAXES RECEIVABLE 3,135 3,135 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,180,033 1,180,033 TOTAL ASSETS 9,615,639 919,266 10,534,905 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,135 3,135 ACCOUNTS AND OTHER PAYABLES 413,771 413,771 CUSTOMER DEPOSITS 314,690 314,690 TOTAL LIABILITIES 731,596 731,596 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 482,659 482,659 TOTAL FUND BALANCE 8,884,043 919,266 9,803,309 TOTAL LIABILITIES AND FUND BALANCE 9,615,639 919,266 10,534,905 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 439.11- 11.77- 110.09- 135,048.22- 296.85- 578.92- 100.131 98.950 192.973 177.22 3.15- 278.92 164,253.00- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 616,408.45- 3,568,162.16- 55.008 2,918,460.84- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 283,116.67- 2,336,520.81- 66.684 1,167,364.19- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 51,074.93- 45.356 61,533.07- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 75.00- 9,900.00- 65.347 5,250.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 2,250.00- 4,500.00- 600.000 3,750.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 750.00- 2,100.00- 84.000 400.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 15,904.00- 41,812.80- 83.626 8,187.20- 10,171,516.00- 10,171,516.00- 918,504.12- 6,014,070.127 4,157,445 135-49011-000-000 Interest Income 120,000.00- 120,000.00- 3,423.57- 70,805.86- 59.005 49,194.14- 135-49016-000-000 Cell Tower Revenue 14,146.00- 14,146.00- 1,178.81- 9,430.48- 66.665 4,715.52- 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 13,000.00- 13,000.00- 8,925.00- 68.654 4,075.00- 135-49075-000-000 Oversize Meter Reimbursement 12,691.00- 12,691.00- 5,295.00- 13,025.28- 102.634 334.28 135-49900-000-000 Miscellaneous Income 7,000.00- 7,000.00- 11,393.07- 20,365.00- 290.929 13,365.00 173,837.00- 21,873.78- ..6"ubtot : Program number: 0- 10,645,077.00- 940,938.87- 6 974 4,36 Department number: Revenues 0- 10,645,077.00- 940,938.87- 974 4,36 Revenues Subtotal 1i10- 10,645,077.00- 940,938.87- 1111974 4,36 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 27,162.78 266,227.02 76.007 84,039.98 135-50010-010-000 Overtime 17,000.00 17,000.00 1,239.58 14,667.33 86.278 2,332.67 135-50016-010-000 Longevity 3,920.00 3,920.00 5,082.50 129.656 1,162.50- 135-50017-010-000 Certification 5,400.00 5,400.00 425.00 3,775.00 69.907 1,625.00 135-50020-010-000 Retirement 34,863.00 34,863.00 2,669.40 27,902.64 80.035 6,960.36 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 5,225.04 45,278.78 53.695 39,047.22 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 316.63 2,748.00 58.159 1,977.00 135-50028-010-000 Vision Insurance 767.00 767.00 48.18 428.83 55.910 338.17 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 328.89 2,863.84 91.438 268.16 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 1,761.89 17,763.22 76.080 5,584.78 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 412.07 4,154.29 76.072 1,306.71 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 880.68 81.544 199.32 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 771.49 7,118.91 60.075 4,731.09 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 71.00 71.00 17.750 329.00 135-50070-010-000 Employee Relations 300.00 300.00 66.82 66.82 22.273 233.18 FSubtotal: ' 546,839.00 546,839.00 147,810.14 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 2,058.40 31,580.09 31.580 68,419.91 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 132.75 2,577.18 51.544 2,422.82 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 1,828.19 52.234 1,671.81 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 700.00 70.000 300.00 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 1,099.44 3,551.08 47.348 3,948.92 Page 4 140,000.00 140,000.00 3,378.09 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 405.39 4,058.73 81.175 941.27 135-60020-010-000 Electricity 125,677.00 125,677.00 10,956.60 91,718.95 72.980 33,958.05 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 850.00 85.000 150.00 135-60070-010-000 Dues & Memberships 500.00 500.00 105.00 21.000 395.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 1,547.00 20.832 5,879.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 2,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00 20,205.04 32.071 42,794.96 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00 176,443.41 1,059,747.90 39.037 1,654,962.10 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 756.00 25.200 2,244.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 3,750.00 25.424 11,000.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 47,943.74 431,493.66 81.818 95,887.34 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 36,800.00 66.675 18,393.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 180,000.00 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 6/2020 Amended Total Current YTD 5 of Remaining Budget Encumb. Month Total Budget Budget Program: 2,500.00 2,500.00 561.72 22.469 1,938.28 1,651,5 053,488 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 813.28 1,568.10 6,989.26 2,917.33 15,220.28 46.595 56.211 76.101 59,593.08 85.133 36,900.00 42.414 8,010.74 2,272.67 4,779.72 1,200.00 1,000.00 10,406.92 50,100.00 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 F Subt 135-70040-010-000 Su• Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 13,977.21 349,868.65 30,512.00 1,840.00 75,000.00 102,077.11 51.085 100.000 56.948 100.000 85.064 297.76 Bond Related Expenses 1,220.00 11 ` 50.373 335,006.35 1,391.00 17,922.89 354,320.24 1,220.00- 1,220.00- 2,731,931.89 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program: 1 Lab Analysis for PID 135-55135-010-001 Lab Analysis for PID Subtotal: Program number: 1 Lab Analysis for PU1111111111 Department number: Water 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 80.00 1,081.64 80.00 54.082 1,081.64 54.082 80.00 1,081.64 54.082 5,506,929.00 5,506,929.00 296,814.59 2,774,078.75 50.374 918.36 918.36 918.36 2,732,850.23 Page 6 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 135-55005-020-000 Engineering 135-55070-020-000 Independent Labor 135-55080-020-000 Maintenance & Repairs 135-55081-020-000 Mainten & Revairs Collections 135-55085-020-000 Generator Meant. and Repair 135-55090-020-000 Vehicle Maintenance 135-55091-020-000 Veh Maintenance Collections 135-55105-020-000 Maintenance-Backhoe/SkidLoader 135-55120-020-000 Cleaning Services 135-55125-020-000 Dumpster Services 135-55135-020-000 Lab Analysis 33,184.19 298,107.02 67.476 143,691.98 1,828.62 16,881.29 51.155 16,118.71 6,872.50 85.532 1,162.50 625.00 5,700.00 63.333 3,300.00 3,300.06 31,860.56 69.976 13,670.44 6,926.71 63,119.97 60.196 41,738.03 392.75 3,664.72 63.000 2,152.28 62.80 585.51 61.763 362.49 384.52 3,338.22 74.183 1,161.78 2,107.83 19,141.09 62.770 11,352.91 492.98 4,476.53 62.767 2,655.47 1,008.00 80.000 252.00 1,110.20 10,167.30 66.137 5,205.70 243.00 281.00 70.250 119.00 46.08 15.360 253.92 Page 7 50,658.66 465,249.79 243,197.21 30,000.00 30,000.00 15,000.00 15,000.00 88,000.00 88,000.00 10,000.00 10,000.00 10,000.00 10,000.00 4,000.00 4,000.00 8,000.00 8,000.00 3,000.00 3,000.00 1,500.00 1,500.00 100,000.00 100,000.00 40,000.00 40,000.00 30,000.00 3,000.00 20.000 12,000.00 4,783.84 52,787.32 59.986 35,212.68 524.06 18,637.93 186.379 8,637.93- 10,000.00 207.48 1,032.42 25.811 2,967.58 136.07 2,156.87 26.961 5,843.13 33.99 1,066.21 35.540 1,933.79 87.50 700.00 46.667 800.00 5,897.44 67,770.28 67.770 32,229.72 4,145.73 27,962.07 69.905 12,037.93 tJ 13 135-60010-020-000 Communications/Mobiles 135-60020-020-000 Electricity 135-60066-020-000 Publications/Books/Subscripts 135-60070-020-000 Dues & Memberships 135-60080-020-000 Schools & Training 135-60090-020-000 Safety Program 135-60100-020-000 Travel & per diem 135-60105-020-000 Rent/Lease Equipment 135-60125-020-000 Advertising 135-60135-020-000 TCEQ Fees & Permits 135-60245-020-000 Miscellaneous Expenses 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 160,067.00 160,067.00 200.00 200.00 300.00 300.00 4,990.00 4,990.00 1,000.00 1,000.00 1,545.00 1,545.00 5,000.00 5,000.00 2,500.00 2,500.00 15,000.00 15,000.00 450.00 450.00 5,000.00 5,000.00 440.37 4,344.46 86.889 655.54 11,851.00 96,231.01 60.119 63,835.99 200.00 216.00 72.000 84.00 2,542.85 50.959 2,447.15 109.14 10.914 890.86 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 11.699 4,415.06 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Subtotal: 1,310,669.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 894.74 3,854.74 27.534 10,145.26 10,414.81 93,733.29 81.818 20,829.71 61,260.70 551,345.70 81.818 122,521.30 46,000.00 36.745 79,187.00 180,000.00 190.00 9.500 1,810.00 Page 8 84,861.62 809,650.87 501,018.13 508.51 5,614.72 44.918 3,507.93 63.839 580.00 20,508.34 102.542 4,994.00 28.537 1,166.53 97.211 2,664.47 19,198.53 95.993 6,885.28 1,987.07 508.34- 12,506.00 1,200.00 33.47 801.47 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtota.- Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 12,053.46 306,065.4657.694 224,434.54 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 12,053.46 501,792 .-24r11125 249,117.77 167,142.83 2,006,796.04 11111111111158 1,150,624.96 167,142.83 2,006,796 .58 1,150,624. glbase_tbam skrolczyk 20:25 07/15/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 6/2020 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 1.99 Program: YTD Total 17.91 % of Budget 59.700 Remaining Budget 12.09 Page 9 17. 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 WMFSubtota1: Program number: Department number: Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 150.00 750.00 750.00 1,300.00 1,300.00 4,000.00 4,000.00 5,000.00 5,000.00 2,000.00 2,000.00 123.99 375.00 675.00 537.80 375.00 90.000 41.369 9.375 150.00 75.00 762.20 3,625.00 5,000.00 2,000.00 13,200. 0 13,200.00 — 13,230.00 — 13,230.00 Board of Directors 13,230.00 13,230.00 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 135-50010-030-000 Overtime 2,000.00 2,000.00 135-50016-030-000 Longevity 2,208.00 2,208.00 135-50020-030-000 Retirement 58,554.00 58,554.00 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 42,385.00 299,176.62 47.617 329,121.38 10.02 41.79 2.090 1,958.21 2,207.50 99.977 .50 3,925.79 29,408.71 50.225 29,145.29 7,970.17 56,165.45 45.151 68,228.55 441.96 3,109.91 48.111 3,354.09 65.60 470.31 45.441 564.69 343.91 3,002.75 66.728 1,497.25 2,431.28 17,459.22 44.522 21,755.78 568.61 4,083.23 44.523 5,087.77 144.00 1,008.00 70.000 432.00 104.82 943.38 53.148 831.62 500.00 3,078.10 38.476 4,921.90 Page 10 1.16 420,154 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanini7 Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 3,610.86 84,181.02 62.504 50,499.98 1,115.53 89,926.07 66.612 45,073.93 295.00 1,855.00 12.367 13,145.00 531.00 5.310 9,469.00 1,896.92 9,555.56 95.556 444.44 57,100.00 87.043 8,500.00 1,073.90 5,253.58 58.373 3,746.42 130,878 135-60005-030-000 Telephone 23,680.00 23,680.00 2,565.53 14,760.87 62.335 8,919.13 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 274.63 2,089.75 52.244 1,910.25 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 464.46 4,372.02 63.556 2,506.98 135-60025-030-000 Water 1,500.00 1,500.00 113.25 1,363.85 90.923 136.15 135-60035-030-000 Postage 30,000.00 30,000.00 2,996.74 14,722.25 49.074 15,277.75 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 5,982.78 52,819.07 78.834 14,180.93 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 6,998.39 59,423.65 70.742 24,576.35 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 125.00 12.500 875.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,285.55 71.426 1,714.45 135-60075-030-000 Meetings 400.00 400.00 115.09 28.773 284.91 135-60079-030-000 Public Education 6,000.00 6,000.00 76.34 4,047.85 67.464 1,952.15 135-60080-030-000 Schools & Training 6,850.00 6,850.00 934.00 2,386.21 34.835 4,463.79 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 58.80 1,157.41 32.649 2,387.59 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 138.04 138.04- 135-60125-030-000 Advertising 2,500.00 2,500.00 2,189.60 3,961.80 158.472 1,461.80 - glbase_tbam skrolczyk 20:25 07/15/20 Fund: 135 MUD 1 General Fund Account Description 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 26,485.00 26,485.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 Program number: Department number: Administration 195,000.00 4,000.00 000.00 ,712.00 .712.00 24.00 69.99 1,002.46 503.15 165.00 90,802.49 90,802.49 192.00 14.907 3,986.20 3,938.45 3,351.68 83.792 62.311 15.051 65.641 11,276.33 28,447.84 2,077.60 30,525.44 876,319. 876,319.38 14.589 51.940 1,096.00 500.00 17,000.00 2,500.00 2,050.00 22,498.80 2,061.55 3,500.00 648.32 2,500.00 166,552.16 1,922.40 168,474.56 900,392.62 900,392.62 Page 11 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 4,775.00 2,243.48 95,202.89 27,713.27 9,665.52 3,756.00 70.521 81.992 82.183 93.900 39,797.11 6,086.73 2,095.48 244.00 Page 12 ir Subtotal: ' 184,561.00 184,561.00 7,018.48 136,337.68 73.871 48,223.32 Program number: 184,561.00 184,561.00 7,018.48 136,337.68 73.871 48,223.32 Department number: Non Departmental 184,561.00 184,561.00 7,018.48 136,337.68 73.871 48,223.32 Expenditures Subtotal 10,638,853.00 10,638,853.00 562,279.37 5,795,137.56 54.471 4,843,715.44 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 378,659.50- 482,658.72- 7,754.799 476,434.72 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 Page 13 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000- 1446 06/01/2020 Property Taxes 1447 06/02/2020 Property Taxes 1448 06/03/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1452 06/10/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1461 06/29/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 6/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Property Taxes Account: 135-40000-000- Property Taxes Total (134,871.00) Budgeted (134,609.11) 177.22 Remaining (42.03) (134,651.14) (121.19) (134,772.33) (20.23) (134,792.56) (5.01) (134,797.57) (563.51) (135,361.08) (44.11) (135,405.19) (15.16) (135,420.35) (77.27) (135,497.62) (26.51) (135,524.13) (5.02) (135,529.15) (5.73) (135,534.88) 497.73 (135,037.15) (3.32) (135,040.47) (3.30) (135,043.77) (4.45) (135,048.22) 100 % Used GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40002-000-00 1449 06/04/2020 Property Taxes 1454 06/12/2020 Property Taxes 1456 06/17/2020 Property Taxes 1460 06/25/2020 Property Taxes 1462 06/30/2020 Property Taxes Property Taxes/Delinquent Account: 135-40002-000-00 Property Taxes/Delinquent (300.00) Budgeted Account: 135-40015-000-00 1446 06/01/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1452 06/10/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes Property Taxes/P & I (285.08) Totals: Emir (3.15) Remaining 99 % Used (468.83) (1.99) (5.09) (2.18) (1.11) (1.40) (287.07) (292.16) (294.34) (295.45) (296.85) (1.37) (470.20) (.48) (470.68) (79.08) (549.76) (5.14) (554.90) (1.82) (556.72) (11.59) (568.31) (4.95) (573.26) (.35) (573.61) (1.05) (574.66) (1.93) (576.59) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1460 06/25/2020 Property Taxes 1461 06/29/2020 Property Taxes 1462 06/30/2020 Property Taxes -40015-000- Property Taxes/P & I Totals: (300.00) Budgeted Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (164,253.00) Budgeted Account: 135-47000-000-000 1296 06/01/2020 UB 06/01/2020 NSF Check 1390 06/01/2020 acct adj-26 Fair Green 1398 06/30/2020 UB 06/30/2020 Billing Account: 135-47000-000-000 (468.83) 278.92 Remaining 193 % Used (164,253.00) Remaining 0 % Used UB20200601-20200601 Ueer: UB20200601-20200601 User: UB20200630-20200630 User: (2,951,753.71) (6,486,623.00) Budgeted (2,918,460.84) Remaining Account: 135-4700 -000- 1296 06/01/2020 UB 06/01/2020 NSF Check 1390 06/01/2020 acct adj-26 Fair Green 1295 06/08/2020 UB 06/08/2020 WA Adjustment 1299 06/08/2020 UB 06/08/2020 WA Adjustment 1322 06/12/2020 UB 06/12/2020 WA Adjustment 1369 06/24/2020 UB 06/24/2020 WA adjustment 1398 06/30/2020 UB 06/30/2020 Billing Account: 135-47005-000-000 Account: 135-47025-000-000 Account: 135-47025-000-000 UB20200601-20200601 User: UB20200601-20200601 User: UB20200608-20200608 User: UB20200608-20200608 User: UB20200612-20200612 User: UB20200624-20200624 User: UB20200630-20200630 User: 55 % Used (2,053,404.14) (3,503,885.00) Budgeted (1,167,364.19) Remaining 67 % Used (.12) (576.71) (1.04) (577.75) (.28) (578.03) (.56) (578.59) (.33) (578.92) .00 .00 24.20 (2,951,729.51) 78.17 (2,951,651.34) (616,510.82) (3,568,162.16) (616,408.45) (3,568,162.16) •• 41.83 (2,053,362.31) 14.01 (2,053,348.30) 721.44 (2,052,626.86) 253.18 (2,052,373.68) 383.18 (2,051,990.50) 156.68 (2,051,833.82) (284,686.99) (2,336,520.81) Penaltie (51,074.93) .00 (51,074.93) Penalties Totals: (112,608.00) Budgeted (61,533.07) Remaining 45 % Used GL GL GL GL GL UB UB UB UB UB UB UB UB UB UB glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number A000 JE Date ro0-:r JE Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance Revenues Period Ending: 6/2020 Beginning Balance JE Detail Description/Comment Service Cha 1296 06/01/2020 UB 06/01/2020 NSF Check 1360 06/22/2020 UB 06/22/2020 NSF Check 1361 06/23/2020 UB 06/23/2020 NSF Check UB20200601-20200601 User: UB20200622-20200622 User: UB20200623-20200623 User: Account: vice Charg (15,150.00) Budgeted Account: 135-47035-000-00 1442 06/03/2020 Permits -13 Sadie 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 Account: 135-47035-000-000 Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Account: 135-47045-000-000 1442 06/03/2020 Permits -13 Sadie 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive Plumbing Inspect' 13 Saide Court 129 Claire 141 Claire 139 Claire 137 Claire 135 Claire 133 Claire 131 Claire 130 Claire 142 Claire 140 Claire 138 Claire 136 Claire 134 Claire 132 Claire Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Plumbing Inspections (750.00) Budgeted Sewer Inspections U 13 Saide Court 129 Claire Drive 141 Claire Drive 139 Claire Drive 137 Claire Drive 135 Claire Drive 133 Claire Drive 131 Claire Drive 130 Claire Drive 142 Claire Drive 140 Claire Drive 138 Claire Drive (5,250.00) Remaining 3,750.00 Remaining (9,825.00) 65 % Used (2,250.00) 600 % Used (1,350.00) Program: Transaction Detail (25.00) (25.00) (25.00) Transaction Vendor Name Detail (SUBTOTAL) (9,850.00) (9,875.00) (9,900.00) (150.00) (2,400.00) Dress Homes (150.00) (2,550.00) CB Jeni (150.00) (2,700.00) CB Jeni (150.00) (2,850.00) CB Jeni (150.00) (3,000.00) CB Jeni (150.00) (3,150.00) CB Jeni (150.00) (3,300.00) CB Jeni (150.00) (3,450.00) CB Jeni (150.00) (3,600.00) CB Jeni (150.00) (3,750.00) CB Jeni (150.00) (3,900.00) CB Jeni (150.00) (4,050.00) CB Jeni (150.00) (4,200.00) CB Jeni (150.00) (4,350.00) CB Jeni (150.00) (4,500.00) CB Jeni (4,500.00) (50.00) (1,400.00) Drees Homes (50.00) (1,450.00) CB Jeni (50.00) (1,500.00) CB Jeni (50.00) (1,550.00) CB Jeni (50.00) (1,600.00) CB Jeni (50.00) (1,650.00) CB Jeni (50.00) (1,700.00) CB Jeni (50.00) (1,750.00) CB Jeni (50.00) (1,800.00) CB Jeni (50.00) (1,850.00) CB Jeni (50.00) (1,900.00) CB Jeni (50.00) (1,950.00) CB Jeni Page 7 Check Source Number UB UB UB CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR glpdatb2 skrolczyk Trophy Club MUD No.1 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 8 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 136 Claire Drive 134 Claire Drive 132 Claire Drive (1,350.00) (50.00) (50.00) (50.00) (2,000.00) CB Jeni (2,050.00) CB Jeni (2,100.00) CB Jeni CR CR CR Account: 135-470 Sewer Inspections Ili Totals: (400.00) Remaining 84 % Used (2,500.00) Budgeted Account: 135-47070-000-000 TCCC Effluent Chargee 1398 06/30/2020 UB 06/30/2020 Billing UB20200630-20200630 User: Account: 135-47070-000-00 TCCC Effluent Charges (50,000.00) Budgeted Accoun- •11-000- 1438 06/30/2020 Bank Interest- June 1438 06/30/2020 Bank Interest- June 1438 06/30/2020 Bank Interest- June Account: 135-49011-000-00come (120,000.00) Budgeted Account: 135-49016-000-011 Tower Revenue 1435 06/22/2020 Cell Tower Rev AT&T (25,908.80) (15,904.00) (41,812.80) UB 5,904.00) (41,812.80) (8,187.20) Remaining 84 % Used (67,382.29) (1,346.11) (68,728.40) GL (1,118.16) (69,846.56) GL (959.30) (70,805.86) GL (49,194.14) Remaining 59 % Used (8,251.67) AC Cell Tower Revenue Tota (14,146.00) Budgeted (4,715.52) Remaining 67 % Ueed Account: Building Rent Incoll 1468 06/30/2020 Town Billed Invoices 1742-1745 AR 20200630-20200630 User: (4,666.64) Account: 135-49018-000-000 Building Rent Income ' Totals: (1,750.03) Remaining 75 % Used (7,000.00) Budgeted 7) (70,805.86) •• (1,178.81) (9,430.48) (583.33) (5,249.97) Account: 135-49026-000-000 Proceeds from Sale of Assets Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (13,000.00) Budgeted (4,075.00) Remaining (8,925.00) 69 % Ueed .00 (8,925.00) GL AR glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-49075-000-00� 1442 06/03/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1443 06/04/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 1444 06/05/2020 Account: 135-49075-00 Permits -13 Sadie Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Permits -Claire Drive Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment Oversize Meter Reimbursement 13 Saida Court 129 Claire Drive 141 Claire Drive 139 Claire Drive 137 Claire Drive 135 Claire Drive 133 Claire Drive 131 Claire Drive 130 Claire Drive 142 Claire Drive 140 Claire Drive 138 Claire Drive 136 Claire Drive 134 Claire Drive 132 Claire Drive 0- Oversize Meter Reimbursement Totals: (12,691.00) Budgeted 334.28 Remaining Account: 135-49900-000-000 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1443 06/04/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1444 06/05/2020 Permits -Claire Drive 1395 06/17/2020 acct adj-26 Fair green 1436 06/22/2020 Easement Approachment Fee 1398 06/30/2020 UB 06/30/2020 Billing Miscellaneous Income 129 Claire Drive 141 Claire Drive 139 Claire Drive 137 Claire Drive 135 CLaire Drive 1330 Claire Drive 131 Claire Drive 130 Claire Drive 142 laire Drive 140 Claire Drive 138 Claire Drive 136 Claire Drive 134 Claire Drive 132 Claire Drive UB20200617-20200617 User: Easement Approachment Fee U820200630-20200630 User: Miscellaneous Income (7,000.00) Budgeted 13,365.00 Remaining (7,730.28) Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) (353.00) (8,083.28) Dress Homes (353.00) (8,436.28) CB Jeni (353.00) (8,789.28) C8 Jeni (353.00) (9,142.28) CB Jeni (353.00) (9,495.28) CB Jeni (353.00) (9,848.28) CB Jeni (353.00) (10,201.28) CB Jeni (353.00) (10,554.28) CB Jeni (353.00) (10,907.28) CB Jeni (353.00) (11,260.28) CB Jeni (353.00) (11,613.28) CB Jeni (353.00) (11,966.28) CB Jeni (353.00) (12,319.28) CB Jeni (353.00) (12,672.28) CB Jeni (353.00) (13,025.28) CB Jeni 103 % Used (8,971.93) 291 % Used (800.00) (9,771.93) C8 Jeni (800.00) (10,571.93) CB Jeni (800.00) (11,371.93) CB Jeni (800.00) (12,171.93) CB Jeni (800.00) (12,971.93) CB Jeni (800.00) (13,771.93) CB Jeni (800.00) (14,571.93) CB Jeni (800.00) (15,371.93) CB Jeni (800.00) (16,171.93) CB Jeni (800.00) (16,971.93) CB Jeni (800.00) (17,771.93) CB Jeni (800.00) (18,571.93) CB Jeni (800.00) (19,371.93) CB Jeni (800.00) (20,171.93) CB Jeni (.73) (20,172.66) (10.00) (20,182.66) (182.34) (20,365.00) Page 9 Check Source Number CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR UB GL UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: (6,277,796.28) ** (940,938.87) Monthly Total (10,645,077.00) Budgeted (4,367,280.72) Remaining 59 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2020 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- Salaries & W 1305 06/12/2020 MUD Payroll 6/12/2020 Salaries & Wages 239,064.24 1357 06/26/2020 MUD Payroll 6/26/2020 Salaries & Wages Account:5-05-0 Salaries & Wages = Totals: 350,267.00 Budgeted Account: 135-50010-010-000vertime 1305 06/12/2020 MUD Payroll 6/12/2020 Overtime 1357 06/26/2020 MUD Payroll 6/26/2020 Overtime Account: 135-50010-010-000 84,039.98 Remaining 76 % Used 13,394.99 252,459.23 PR 13,767.79 266,227.02 PR 13,427.75 587.37 14,015.12 PR 652.21 14,667.33 PR 17,000.00 Budgeted 2,332.67 Remaining 86 % Ueed Account: 135-50016-010 Longevit 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Totals: Account: 135-50017-010-000 1357 06/26/2020 MUD Payroll 6/26/2020 Certification Certification 3,350.00 425.00 3,775.00 PR Account: 135-50017-01 Certification Account: 135-50020-010-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: 135-50020-010-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 5,400.00 Budgeted eme Retirement Retirement Retirement 3 34,863.00 Budgeted Medical Insurance Medical Insurance Medical Insurance Accc Medical Insurance 84,326.00 Budgeted 1,625.00 Remaining 25,233.24 70 % Ueed Totals: 6,960.36 Remaining 80 % Used 40,053.74 Totals: 39,047.22 Remaining 54 5 Used 1,294.77 26,528.01 1,374.63 27,902.64 2,612.55 42,666.29 PR PR PR 2,612.49 45,278.78 PR glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Department: 10 Water JE Detail Description/Comment AccOUnt: 135-50027-010- ental IneuI 1305 06/12/2020 MUD Payroll 6/12/2020 Dental Insurance 1357 06/26/2020 MUD Payroll 6/26/2020 Dental Insurance Trophy Club MUD No.1 Page 12 Detailed Accounting Trial Balance Period Ending: 6/2020 Beginning Balance Account: -1.1 Dental Ineuranc Totals: 4,725.00 Budgeted 1,977.00 Remaining Account: 135-50028-010-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: 135-50028-01 1213 06/01/2020 Payroll Benefits June 1213 06/01/2020 Payroll Benefits June 1372 06/25/2020 June A/P Account: 135-50029-010-000 W Vision Insurance Vision Insurance Vision Insurance Vision Insurance Totals: 767.00 Budgeted 338.17 Remaining Life Insurance & Other Employee Benefits Employee LTD & STD cafe 125 plan 2,431.37 380.65 58 % Used Program: Transaction Detail 158.32 158.31 24.10 24.08 56 % Used Transaction Vendor Name Detail (SUBTOTAL) 2,589.69 2,748.00 404.75 428.83 2,534.95 176.88 2,711.83 Humana Inc 132.01 2,843.84 METLIFE GROUP BENEFITS 20.00 2,863.84 BenefitMall Check Source Number PR PR PR PR 6449 AP 6459 AP 6549 AP Life Insurance & Other Totals: Account: 135 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: Account: 135-50040-010-000 3,132.00 Budgeted 268.16 Remaining Social Security Taxes Social Security Taxes Social Security Taxes Social S- 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes 5,584.78 Remaining Medicare Tax 5,461.00 Budgeted 1,306.71 Remaining 16,001.33 3,742.22 91 % Used 76 857.05 904.84 Used 200.44 211.63 76 % Used 880.68 .00 16,858.38 17,763.22 3,942.66 4,154.29 880.68 PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accq Unemployment Taxes Tota 1,080.00 Budgeted 199.32 Remaining 82 % Ueed Workman's Compensation 74 06/01/2020 Insurance/Wrk Comp Expense Jun 6,347.42 771.49 7,118.91 GL Account: 135-50045-010-000 Workman's Compensation Totals: 11,850.00 Budgeted 1419 06/30/2020 June A/P 1419 06/30/2020 June A/P Account: 135 Account: 4,731.09 Remaining 60 % Used Pre-emp Physicals/Testing MVAs 60.00 60.00 FIRST CHECK APPLICANT SCREENIN 6595 AP MVRs 11.00 71.00 FIRST CHECK APPLICANT SCREENIN 6595 AP Pre-emp Physicals/Testing Totals: 400.00 Budgeted 329.00 Remaining Employee Relations 1403 06/26/2020 PCards 5/27/2020-6/26/2020 flowers for BCooper • 18 % Used 1 66.82 66.82 1-800-FLOWERS.COM,INC. PC Account: Employee Relations Tota 71 Account: 135-55005-010-000 300.00 Budgeted 233.18 Remaining 22 % Used Engineering Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining 0 % Ueed .00 .00 Account: 135-55080-010-000 1310 06/09/2020 June A/P 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1420 06/30/2020 June A7P Maintenance & Repairs parts annual inspection Well testing Account: 135-55080-010-000 Maintenance & Repairs 100,000.00 Budgeted 29,521.69 697.40 30,219.09 Core & Main LP 6505 AP 211.00 30,430.09 IN *ALL TEST FIRE PROT PC 1,150.00 31,580.09 Aqua -Metric Sales Company 6591 AP 68,419.91 Remaining 32 % Used Account: 135-55085-010-0 t. and Repair glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 14 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55085-010- Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135-55090-010-00' Vehicle Maintenances 1403 06/26/2020 PCards 5/27/2020-6/26/2020 Tire Account: 135-55090-010-00 Vehicle Maintenance 5,000.00 Budgeted 2,422.82 Remaining Account: 135-55105-010-000 ■ Maintenance-Backhoe/SkidLoa Account: 135-55105-01' Maintenance-Backhoe/SkidLoader Tot. 3,500.00 Budgeted 1,671.81 Remaining Account: 135-55120-010-00' Cleaning Services 1344 06/19/2020 June A/P Account Account: 135-55135-010-000- 1310 06/09/2020 June A/P 1427 06/30/2020 June A/P Account: 135-55_M2-00 Account: Janitorial service -May Cleaning Services Totals: 1,000.00 Budgeted Lab Analysis water samples TCEQ samples J 2,444.43 1,828.19 .00 0 % Used 132.75 52 % Ueed .00 52 % Ueed .00 2,577.18 DISCOUNT TIRE TXD 75 1,828.19 PC 612.50 87.50 700.00 MEMBER'S BUILDING MAINTENANCE 6534 AP 300.00 Remaining 70 % Ueed 2,451.64 200.00 2,651.64 TARRANT CTY PUBLIC HEALTH LAB 6515 AP 899.44 3,551.08 LOWER COLORADO RIVER AUTHORITY 6606 AP Lab Analysis Totals: . MIL 1,09 3,948.92 Remaining 47 % Used 7,500.00 Budgeted Communications/Mobiles 1 1310 06/09/2020 June A/P Cell phones -June 1403 06/26/2020 PCards 5/27/2020-6/26/2020 phone case 135-60010-010-00 ommunications/Mobiles 5,000.00 Budgeted 3,653.34 385.40 4,038.74 VERIZON WIRELESS 6519 AP 19.99 4,058.73 AMZN MKTP US*MS55L7EJ2 941.27 Remaining 81 % Ueed PC Account: 135-60020-010-00 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1344 06/19/2020 June A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 6/2020 JE Detail Description/Comment Electricity 5/8-6/9 Page 15 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-6010-000 Electricity Totals: 125,677.00 Budgeted 33,958.05 Remaining Account: 135-60066-010-000 Account: 135-60066-010-000 Publications/Books/Subscripts Publications/Books/Subscri 1,000.00 Budgeted 150.00 Remaining 80,762.35 10,956.60 850.00 73 % Used 85 .00 Used 91,718.95 HUDSON ENERGY SERVICES, LLC 6527 AP 850.00 Account: 135-60070-010-000 Dues & Memberships Account: 135-60070-010-000 Dues & Memberships 500.00 Budgeted Account: 135-60080-010-000 Schools & Training 105.00 395.00 Remaining 21 % Ueed 1,547.00 .00 1,547.00 .00 105.00 Account: 135-60080-010-000 Schools & Training Totals: 7,426.00 Budgeted 5,879.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Safety Program Totals: 400.00 Budgeted .00 .00 400.00 Remaining 0 % Ueed Account: 135-60100-010-000 AIL Travel & per diem AIL Account: 135-60100-010-000 Travel & per diem 2,845.00 Budgeted .00 .00 2,845.00 Remaining 0 % Used Account: 135-60105-010-000 .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135 Rent/Lease Equipment Tota 1,500.00 Budgeted 1,500.00 Remaining 0 % Ueed Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 Account: 135-60150-010-000 1363 06/23/2020 June A/P 20,205.04 TCEQ Fees & Permits _ Total - 63,000.00 Budgeted 42,794.96 Remaining Wholesale Waterml wholesale water 883,304.49 Account: 135-60150-010-000 Wholesale Water 2,714,710.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 Miscellaneous Expense 32 % Used 1,654,962.10 Remaining 39 % Used 200.00 Budgeted 200.00 Remaining Account: 135-60280-010-000 Property Maintenance Account: 135-60280-010-000IMM Property Maintenance 3,000.00 Budgeted 0 % Used 756.00 2,244.00 Remaining 25 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1419 06/30/2020 June A/P Mowing -June 85-010-000- Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 11,000.00 Remaining Interfund Transfer Out -Rev I&S� 1439 06/30/2020 TexPool Transfers June TexPool O&M to I&S- W&WW SYS 1439 06/30/2020 TexPool Transfers June TexPool O&M to 16Swift Rev I&S .00 .00 20,205.04 176,443.41 1,059,747.90 CITY OF FORT WORTH 176,443.41 1,05 .00 .00 .00 .00 756.00 3,000.00 750.00 25 % Used 6552 AP 3,750.00 WATTS ELL15ON LLC 6604 AP 383,549.92 22,896.02 406,445.94 GL 25,047.72 431,493.66 GL glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 17 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-60332-01t Interfund Transfer Out -Rev I&S Tota 527,381.00 Budgeted 95,887.34 Remaining Account: 135-60333-010-0001MM Interfund Transfer Out -Reserve Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 18,393.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $500 2,500.00 Budgeted Account: 135-65005-01 1374 06/24/2020 Fuel Fuel -may Account: 135-65005-0 Account: 135-65010-0 1344 06/19/2020 June A/P 1363 06/23/2020 June A/P Fuel & Lube 15,000.00 Budgeted Unif 5,190.00 Budgeted Chemical testing supplies 1,938.28 Remaining 8,010.74 Remaining 2,272.67 Remaining 36,800.00 561.72 6,175.98 2,917.33 13,652.18 82 Used 67 % Used 0 % Used 22 Used 47 % Used 56 % Used .00 36,800.00 .00 .00 .00 813.28 0 561.72 6,989.26 2,917.33 US Bank Voyager Fleet Systems 898.01 14,550.19 HACH COMPANY 6569 AP 6526 AP chlorine 670.09 15,220.28 DPC INDUSTRIES, INC 6556 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Page 18 Detailed Accounting Trial Balance Account: 135-65030-01t Account: 135-65035-010-000 Account: 135-65035-010-000 Account: 135-65040-010-000 Account: 135-65040-010-000 Account: 135-65050-010-000 Account: 135-65050-010-000 Account: 135-65053-010-000 Chemicals 20,000.00 Budgeted Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense Meter Expense 70,000.00 Budgeted Meter Change Out Prog Totals: 4,779.72 Remaining 76 % Used 1,200.00 Remaining 0 % Used Totals. 1,000.00 Remaining 0 % Used 59,593.08 10,406.92 Remaining 85 % Used Account: 135-65053-010-000 Meter Change Out Program 87,000.00 Budgeted 50,100.00 Remaining Account: ital Outla 1312 06/10/2020 June A/P Meadowbrook Lane 1363 06/23/2020 June A/P Pump head 1473 06/30/2020 Reclass CapOut Depart 10 - 20 March Hach Capital from W - WW Account: 135-69005-0 Capital Outlays 684,875.00 Budgeted 36,900.00 1,568.11111 .00 .00 .00 .00 .00 59,593.08 .00 36,900.00 42 5 Used 335,891.44 13,050.00 348,941.44 Jackson Construction, LTD 6512 AP 12,980.67 361,922.11 REY-MAR CONSTRUCTION 6567 AP (12,053.46) 349,868.65 GL 335,006.35 Remaining 51 5 Used Account: 135-6900 Short Term Debt -Principal glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 6/2020 Beginning Balance 30,512.00 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) .00 30,512.00 Page 19 Check Source Number Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,512.00 ** 30,512.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 1,840.00 .00 1,840.00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 1,840.00 ** 3,231.00 Budgeted 1,391.00 Remaining 57 % 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 102,077.11 .00 102,077.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: ' .00 102,077.11 ** 120,000.00 Budgeted 17,922.89 Remaining 85 % Used Account: 135-70040-010-000 Bond Related Expenses 1,220.00 .00 1,220.00 Account: 135-70040-010-000 Bond Related Expenses Totals: .00 1,220.00 ** .00 Budgeted (1,220.00) Remaining 0 % Used glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 20 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 1310 06/09/2020 June A/P water samples 1,001.64 80.00 1,081.64 TARRANT CTY PUBLIC HEALTH LAB 6515 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,081.64 ** 2,000.00 Budgeted 918.36 Remaining 54 % Used Department 10 Totals: 2,774,078.75 ** 296,814.59 Monthly Total 5,506,929.00 Budgeted 2,732,850.25 Remaining 50 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-5000 020- Salaries & Wa 1305 06/12/2020 MUD Payroll 6/12/2020 Salaries & Wages 264,922.83 1357 06/26/2020 MUD Payroll 6/26/2020 Salaries & Wages 16,559.46 281,482.29 PR 16,624.73 298,107.02 PR Account:5-05-0 Salaries & Wages ' Totals: 441,799.00 Budgeted Account: 135-50010-020-000vertime 1305 06/12/2020 MUD Payroll 6/12/2020 Overtime 1357 06/26/2020 MUD Payroll 6/26/2020 Overtime 143,691.98 Remaining 67 % Used 15,052.67 780.66 15,833.33 PR 1,047.96 16,881.29 PR Account: 135-50010-020-000 Account: 135 - Account: 135-50016-020-000 33,000.00 Budgeted 16,118.71 Remaining 51 % Used Longevity 6,872.50 .00 6,872.50 Longevity Totals: 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 1357 06/26/2020 MUD Payroll 6/26/2020 Certification Account: 135-50017-020-000 ertification 9,000.00 Budgeted Account: 135-50020-020-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: 135-50020-020-000 Acc 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Retirement Retirement 3,300.00 Remaining Retirement AIL Totals: 45,531.00 Budgeted 13,670.44 Remaining Medical Insurance Medical Insurance Medical Insurance Medical Insurance 104,858.00 Budgeted 5,075.00 63 % Used 28,560.50 70 % Used 56,193.26 Totals: 11111 41,738.03 Remaining 60 % Used 625.00 5,700.00 1,605.68 1,694.38 3,463.38 3,463.33 6,926.71 30,166.18 31,860.56 59,656.64 63,119.97 PR PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOunt: 135-50027020- ental IRsuI 1305 06/12/2020 MUD Payroll 6/12/2020 Dental Insurance 1357 06/26/2020 MUD Payroll 6/26/2020 Dental Insurance Account: -1.1 Dental Insuranc Totals: 5,817.00 Budgeted 2,152.28 Remaining Account: 135-50028-020-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Vision Insurance Vision Insurance Vision Insurance Account: 135-50028-020-000 Vision Insurance 948.00 Budgeted fe Insurance & Other 1213 06/01/2020 Payroll Benefits June Employee Benefits 1213 06/01/2020 Payroll Benefits June Employee LTD & STD 1372 06/25/2020 June A/P cafe 125 plan Account: 135-50029-020-000 Life Insurance & Other 4,500.00 Budgeted Account: 135-50030-020-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 Account: 135-50035-020-000 1305 06/12/2020 MUD Payroll 6/12/2020 1357 06/26/2020 MUD Payroll 6/26/2020 3,271.97 196.39 3,468.36 PR 196.36 3,664.72 PR 63 % Used 522.71 31.40 554.11 PR 31.40 585.51 PR 362.49 Remaining 62 % Used 2,953.70 186.78 3,140.48 Humana Inc 165.74 3,306.22 METLIFE GROUP BENEFITS 32.00 3,338.22 BenefitMall 1,161.78 Remaining 74 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security T 30,494.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Account: 135-50035-020-000 Medicare Taxe, 7,132.00 Budgeted Account: 135-50040-020-000 11,352.91 Remaining 17,033.26 3,983.55 63 1,042.57 1,065.26 Used 18,075.83 19,141.09 243.85 4,227.40 249.13 4,476.53 2,655.47 Remaining 63 % Used 1,008.00 .00 1,008.00 6449 AP 6459 AP 6549 AP PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes Tota Accq 1,260.00 Budgeted Workman's Compensation 252.00 Remaining 80 % Ueed 74 06/01/2020 Insurance/Wrk Comp Expense Jun 9,057.10 Account: 135-50045-020-000 Workman's Compensation Totals: 15,373.00 Budgeted 5,205.70 Remaining 66 % Ueed Account: 135 Pre-emp Physicals/Testing 1344 06/19/2020 June A/P employee drug screen -C. Howard 1419 06/30/2020 June A/P MVPs Account: 135 Account: 135 Account: 135-50070-020-000= Pre-emp Physicals/Testing Totai 400.00 Budgeted Employee Relations 1,110.20 10,167.30 GL 38.00 161.00 199.00 CARENOW CORPORATE 6520 AP 82.00 281.00 FIRST CHECK APPLICANT SCREENIN 6595 AP 119.00 Remaining 70 % Used 46.08 .00 46.08 Employee Relations Totals: 11.1MIWIR** 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 253.92 Remaining 15 % Used Engineering Totals: 30,000.00 Budgeted .00 .00 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135-5 1310 06/09/2020 June A/P Independent Labor 15,000.00 Budgeted e & Repai work gloves 12,000.00 Remaining 3,000.00 48,003.48 .00 3,000.00 20 % Used 115.93 48,119.41 Ritz Safety, LLC 6514 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date 1310 06/09/2020 1344 06/19/2020 1344 06/19/2020 1363 06/23/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1385 06/30/2020 1385 06/30/2020 1385 06/30/2020 .5-5508 JE Description June A/P June A/P June A/P June A/P PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 June A/P June A/P June A/P Account: 135-55081-020-000 1344 06/19/2020 June A/P 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 Account: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment longo bags work gloves for WWTP CIP/trailer parts parts for 2nd annual visit rubber hose hose refund rubber hose, gloves hose,fly ribbon, roundup,etc. half back LBF -15 drain spade, water nozzle, bug pliers LMI Metering Pump Refund Filters for blowers relay for ras pump relay for ras pump Maintenance & Repairs Totals: 88,000.00 Budgeted 35,212.68 Remaining Mainten & Repairs Collections Radio upgrade water cooler water cooler refund 5 gallon jug shovel, wd40,pliers, tape,etc Account: 135-55085-020-000 48,003.48 18,113.87 Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 650.00 48,769.41 57.27 48,826.68 80.24 48,906.92 2,947.71 51,854.63 35.08 51,889.71 (35.08) 51,854.63 69.82 51,924.45 146.89 52,071.34 11.98 52,083.32 69.66 52,152.98 63.98 52,216.96 (761.04) 51,455.92 581.40 52,037.32 375.00 52,412.32 375.00 52,787.32 60 % Used Huber Technology Inc Ritz Safety, LLC Stuart Hose & Pipe Huber Technology Inc THE THE THE THE THE THE HOME HOME HOME HOME HOME HOME DEPOT #6581 DEPOT #6581 DEPOT #6581 DEPOT #6581 DEPOT #6581 DEPOT 6581 TRACTOR SUPPLY COMPANY MANUFACTURERS EDGE, IN DFW Compressor LLC NORTH TEXAS PUMP CO. NORTH TEXAS PUMP CO. 7.32 ** 331.00 18,444.87 24.97 18,469.84 (24.97) 18,444.87 30.28 18,475.15 162.78 18,637.93 OMNISITE THE HOME DEPOT 6581 THE HOME DEPOT #6581 THE HOME DEPOT #6581 LOWES #00732* Mainten & Repairs Collections Totals: 8,637.93 ** 10,000.00 Budgeted (8,637.93) Remaining 186 % Ueed Generator Maint. and Repair Generator Maint. and Repair Totals: ' 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55090-020-000 icle Maintenance 1403 06/26/2020 PCards 5/27/2020-6/26/2020 new battery 1403 06/26/2020 PCards 5/27/2020-6/26/2020 inspection 1403 06/26/2020 PCards 5/27/2020-6/26/2020 inspection fee .00 0 % Used .00 824.94 186.98 1,011.92 NTH 759 16.50 1,028.42 DENTON VEHREG 4.00 1,032.42 TX.GOV*SERVICEFEE-DIR Page 24 Check Source Number 6510 AP 6539 AP 6540 AP 6558 AP PC PC PC PC PC PC PC PC 6554 AP 6563 AP 6563 AP 6537 AP PC PC PC PC PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance 4,000.00 Budgeted 2,967.58 Remaining 26 % Ueed Account: Veh Maintenance Collections 1• 1,032.42 ** 1403 06/26/2020 PCards 5/27/2020-6/26/2020 clevis pin 2,020.80 8.76 2,029.56 THE HOME DEPOT #6581 PC 1403 06/26/2020 PCards 5/27/2020-6/26/2020 oil change 127.31 2,156.87 KWIK KAR LUBE & TUNE 0 PC Account: 135-55091-020-000 Veh Maintenance Collections 2,156.87 ** 8,000.00 Budgeted 5,843.13 Remaining 27 % Ueed Account: 135-55105-020- Maintenance-Backhoe/SkidLoader 1403 06/26/2020 PCards 5/27/2020-6/26/2020 Terra Cair DEF 1,032.22 20.00 1,052.22 ROANOKE AUTO SUPPLY LT PC 1403 06/26/2020 PCards 5/27/2020-6/26/2020 blade 13.99 1,066.21 ROANOKE AUTO SUPPLY LT PC Account05-02 - intenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 1,933.79 Remaining 36 % Ueed Account: 135-55120-020-000 Cleaning Services 1344 06/19/2020 June A/P Janitorial service -May Account: 135-55120-020-000 .ILning Services 1,500.00 Budgeted Account: 135-55125-020-000 1344 06/19/2020 June A/P sludge haul off 1344 06/19/2020 June A/P sludge/grit 1385 06/30/2020 June A/P sludge/grit 612.50 87.50 700.00 MEMBER'S BUILDING MAINTENANCE 6534 AP 800.00 Remaining 47 % Used 61,872.84 2,345.46 484.84 3,067.14 64,218.30 L.H. CHANEY MATERIALS, INC. 64,703.14 L.H. CHANEY MATERIALS, INC. 67,770.28 L.H. CHANEY MATERIALS, INC. 6531 AP 6531 AP 6560 AP Account: 135-55125-020-000 Services Totals: Account: 135-55135-020-0� 1310 06/09/2020 June A/P 1310 06/09/2020 June A/P 1344 06/19/2020 June A/P 1344 06/19/2020 June A/P 1344 06/19/2020 June A/P 100,000.00 Budgeted Lab Analysis lab testing lab testing lab testing lab testing lab testing 32,229.72 Remaining 68 % Used 23,816.34 341.55 24,157.89 OXIDOR LABORATORIES LLC 241.50 24,399.39 OXIDOR LABORATORIES LLC 241.50 24,640.89 OXIDOR LABORATORIES LLC 341.55 24,982.44 OXIDOR LABORATORIES LLC 341.55 25,323.99 OXIDOR LABORATORIES LLC 6513 AP 6513 AP 6538 AP 6538 AP 6538 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date 1344 06/19/2020 1346 06/19/2020 1437 06/22/2020 1366 06/24/2020 1366 06/24/2020 1403 06/26/2020 1419 06/30/2020 1419 06/30/2020 Account: 135-55135-020-000 JE Description June A/P June A/P Refund Shipping- Reel Printing June A/P June A/P PCards 5/27/2020-6/26/2020 June A/P June A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment lab testing biomonitoring Refund Pcard- Isola Ship Cost lab testing lab testing lab analysis lab testing lab testing Lab Analysis J 40,000.00 Budgeted Accoml: 135-60010-020- unicati. 1310 06/09/2020 June A/P Cell phones -June Acc'until Account: 135-60020-020-000 1344 06/19/2020 June A/P 1344 06/19/2020 June A/P Communications/Mobiles 5,000.00 Budgeted 12,037.93 Remaining 655.54 Remaining Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 23,816.34 241.50 25,565.49 OXIDOR LABORATORIES LLC 1,080.00 26,645.49 HUTHER AND ASSOCIATES,INC (100.00) 26,545.49 341.55 26,887.04 OXIDOR LABORATORIES LLC 241.50 27,128.54 OXIDOR LABORATORIES LLC 250.48 27,379.02 POSTNET TX193 341.55 27,720.57 OXIDOR LABORATORIES LLC 241.50 27,962.07 OXIDOR LABORATORIES LLC 3,904.09 70 % Ueed 4,145.73 440.37 87 % Ueed 4,344.46 VERIZON IRELESS Page 26 Check Source Number 6538 AP 6528 AP GL 6566 AP 6566 AP PC 6598 AP 6598 AP 6519 AP E electricity 5/5-6/1 Electricity 5/8-6/9 1468 06/30/2020 Town Billed Invoices 1742-1745 AR 20200630-20200630 User: Account: 135-60066-020-000 Account: 135-60066-020-000 Account: 135-60070-020-000 Account: 135-60070-020-000 Account: 135-60080-020-000 Electrics 160,067.00 Budgeted 63,835.99 Remaining Publications/Books/Subscripts Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Dues & Memberships Dues & Memberships 300.00 Budgeted To 84.00 Remaining 84,380.01 442.42 11,641.49 (232.91) 84,822.43 TRI COUNTY ELECTRIC 96,463.92 HUDSON ENERGY SERVICES, LLC 96,231.01 6544 AP 6527 AP AR 11,851.00 216.00 60 % Used 0 % Ueed 72 .00 .00 Ueed .00 216.00 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment 2,542.85 .00 2,542.85 Page 27 Check Source Number Account: 135-60080-020-000 Schools & Training Totals: .00 2,542.85 ** 4,990.00 Budgeted 2,447.15 Remaining 51 % Used Account: 135-60090-020-000 Safety Program 109.14 .00 109.14 Account: 135-60090-020-000 Safety Program Totals: .00 109.14 ** 1,000.00 Budgeted 890.86 Remaining 11 % Used Account: 135-60100-020-000 Travel & per diem 410.72 .00 410.72 Account: 135-60100-020-000 Travel & per diem Totals: .00 410.72 ** 1,545.00 Budgeted 1,134.28 Remaining 27 % 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 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 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-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 0 % Used 584.94 Totals: 4,415.06 Remaining 12 % Used Account: 135- Lawn Equipment & Maintenance 1403 06/26/2020 PCards 5/27/2020-6/26/2020 spark plug 1419 06/30/2020 June A/P Mowing -June Account: 135 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 10,145.26 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1439 06/30/2020 TexPool Transfers June TexPool O&M to I&S- PID Debt Account -6030 Interfund Transfer Out -Tax I&S Totals: 114,563.00 Budgeted 20,829.71 Remaining Account: 135-60332-020-000 1439 06/30/2020 TexPool Transfers June 1439 06/30/2020 TexPool Transfers June Account: 135-60333-020-000 .00 584.94 2,960.00 4.74 2,964.74 ROANOKE AUTO SUPPLY LT 28 % Used PC 890.00 3,854.74 WATTS ELLISON LLC 6604 AP 894.74 3,854.74 ** 83,318.48 10,414.81 TexPool O&M to I&S- W&WW SYS 490,085.00 TexPool O&M to Rev Bd WWTP I&S Interfund Transfer Out -Rev I&S Totals: 673,867.00 Budgeted 122,521.30 Remaining Interfund Transfer Out -Reserve 46,000.00 Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 79,187.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out 82 % Used 82 % Used 37 % Used 1 93,733.29 GL 93.29 ** 6,839.07 496,924.07 GL 54,421.63 551,345.70 GL .00 46,000.00 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment .00 .00 Page 29 Check Source Number Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 190.00 .00 190.00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 190.00 ** 2,000.00 Budgeted 1,810.00 Remaining 10 % Used Account: 135-65005-020-000 Fuel & Lube 1374 06/24/2020 Fuel Fuel -may 5,106.21 508.51 5,614.72 US Bank Voyager Fleet Systems 6569 AP Account: 135-65005-020-000 Fuel & Lube Totals: 508.51 5,614.72 ** 12,500.00 Budgeted 6,885.28 Remaining 45 % Used Account: 135-65010-020-000 Uniforms 3,507.93 .00 3,507.93 Account: 135-65010-020-000 Uniforms Totals: .00 3,507.93 ** 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020-000 Chemicals 1310 06/09/2020 June A/P 4 drums sodium hypo 19,928.34 580.00 20,508.34 Valley Solvent Company, INC 6518 AP Account: 135-65030-020-000 Chemicals Totals: 580.00 20,508.34 ** 20,000.00 Budgeted (508.34) Remaining 103 % Used Account: 135-65031-020-000 Chemicals Collections 4,994.00 .00 4,994.00 Account: 135-65031-020-000 Chemicals Collections Totals: .00 4,994.00 ** 17,500.00 Budgeted 12,506.00 Remaining 29 % Used Account: 135-65035-020-000 Small Tools .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted Account: 135-65045-020-000 Lab Supplies 1310 06/09/2020 June A/P lab supplies 1363 06/23/2020 June A/P lab supplies 1403 06/26/2020 PCards 5/27/2020-6/26/2020 UV Hand held light 1419 06/30/2020 June A/P lab supplies 1419 06/30/2020 June A/P lab supplies 1427 06/30/2020 June A/P lab supplies Account: 135-65045-020-000 Lab Supplies 20,000.00 Budgeted 1,200.00 Remaining 0 % Ueed 1,166.53 Totals: 33.47 Remaining 97 % Used 801.47 Remaining Capital Outl= 1473 06/30/2020 Reclass CapOut Depart 10 - 20 March Hach Capital from W ital Outlays 530,500.00 Budgeted .00 1,166.53 16,534.06 1,793.03 18,327.09 IDEXX DISTRIBUTION, INC 6511 AP 321.80 18,648.89 HACH COMPANY 6557 AP 203.99 18,852.88 SERFINITYMEDICAL PC 80.00 18,932.88 HACH COMPANY 6596 AP 177.10 19,109.98 HACH COMPANY 6596 AP 88.55 19,198.53 HACH COMPANY 6605 AP 96 % Used WW 294,012.00 12,053.46 306,065.46 GL 224,434.54 Remaining 58 % Used Short Term Debt -Principal ME Account: 135-69008-020-000 • Short Term Debt -Principal Totals: 79,133.00 Budgeted 19,528.26 Remaining Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt -Interest Tota 11,277.00 Budgeted 5,154.97 Remaining 59,604.74 6,122.03 .00 59,604.74 75 % Used 54 % Used .00 6,122.03 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 .00 130,000.00 Account: 135-69195-020-000 41 Gasb34/Reserve for Replacement Totals: ' .00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 2,006,796.04 ** 167,142.83 Monthly Total 3,157,421.00 Budgeted 1,150,624.96 Remaining 64 % Used glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 26 Board of Directors Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 32 Check Source Number Account: 135-50045-026-000 Workman's Compensation J 74 06/01/2020 Insurance/Wrk Comp Expense Jun 15.92 1.99 17.91 GL Account: 135-50045-026-000 Workman's Compensation Totals: 1.99 17.91 ** 30.00 Budgeted 12.09 Remaining 60 % 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 675.00 .00 675.00 Account: 135-60070-026-000 Dues & Memberships Totals: .00 675.00 ** 750.00 Budgeted 75.00 Remaining 90 % Used Account: 135-60075-026-000 Meetings 1403 06/26/2020 PCards 5/27/2020-6/26/2020 Board Meetings 413.81 123.99 537.80 ZOOM.US PC Account: 135-60075-026-000 Meetings Totals: 123.99 537.80 ** 1,300.00 Budgeted 762.20 Remaining 41 % Used Account: 135-60080-026-000 Schools & Training 1310 06/09/2020 June A/P Mark Chapman Annual Conference 375.00 375.00 AWBD 6503 AP Account: 135-60080-026-000 Schools & Training Totals: 375.00 375.00 ** 4,000.00 Budgeted 3,625.00 Remaining 9 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 1,605.71 ** 500.98 Monthly Total 13,230.00 Budgeted 11,624.29 Remaining 12 % Used glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 34 Check Source Number Account: 135-50005-030-000 Salaries & Wages 1305 06/12/2020 1357 06/26/2020 MUD MUD Payroll Payroll 6/12/2020 Salaries & Wages 256,791.62 6/26/2020 Salaries & Wages 21,192.51 21,192.49 277,984.13 299,176.62 PR PR Account: 135-50005-030-000 Salaries & Wages Totals: 42,385.00 299,176.62 ** 628,298.00 Budgeted 329,121.38 Remaining 48 9 Used Account: 135-50010-030-000 Overtime 1357 06/26/2020 MUD Payroll 6/26/2020 Overtime 31.77 10.02 41.79 PR Account: 135-50010-030-000 Overtime Totals: 10.02 41.79 ** 2,000.00 Budgeted 1,958.21 Remaining 2 % Used Account: 135-50016-030-000 Longevity 2,207.50 .00 2,207.50 Account: 135-50016-030-000 Longevity Totals: .00 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1305 06/12/2020 1357 06/26/2020 MUD MUD Payroll Payroll 6/12/2020 Retirement 6/26/2020 Retirement 25,482.92 1,962.44 1,963.35 27,445.36 29,408.71 PR PR Account: 135-50020-030-000 Retirement Totals: 3,925.79 29,408.71 ** 58,554.00 Budgeted 29,145.29 Remaining 50 % Used Account: 135-50026-030-000 Medical Insurance 1305 06/12/2020 1357 06/26/2020 MUD MUD Payroll Payroll 6/12/2020 Medical Insurance 6/26/2020 Medical Insurance 48,195.28 3,985.11 3,985.06 52,180.39 56,165.45 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 7,970.17 56,165.45 ** 124,394.00 Budgeted 68,228.55 Remaining 45 % Used Account: 135-50027-030-000 Dental Insurance 1305 06/12/2020 1357 06/26/2020 MUD MUD Payroll Payroll 6/12/2020 Dental Insurance 6/26/2020 Dental Insurance 2,667.95 220.99 220.97 2,888.94 3,109.91 PR PR Account: 135-50027-030-000 Dental Insurance Totals: 441.96 3,109.91 ** 6,464.00 Budgeted 3,354.09 Remaining 48 % Used glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 35 Check Source Number Account: 135-50028-030-000 Vision Insurance 1305 06/12/2020 MUD Payroll 6/12/2020 Vision Insurance 1357 06/26/2020 MUD Payroll 6/26/2020 Vision Insurance 404.71 32.81 32.79 437.52 470.31 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 65.60 470.31 ** 1,035.00 Budgeted 564.69 Remaining 45 % Used Account: 135-50029-030-000 Life Insurance & Other 1213 06/01/2020 Payroll Benefits June Employee Benefits 1213 06/01/2020 Payroll Benefits June Employee LTD & STD 1372 06/25/2020 June A/P cafe 125 plan 2,658.84 176.22 151.69 16.00 2,835.06 2,986.75 3,002.75 Humana Inc METLIFE GROUP BenefitMall BENEFITS 6449 6459 6549 AP AP AP Account: 135-50029-030-000 ■ Life Insurance & Other Totals: 343.91 3,002.75 ** 4,500.00 Budgeted 1,497.25 Remaining 67 % Used Account: 135-50030-030-000 Social Security Taxes 1305 06/12/2020 MUD Payroll 6/12/2020 Social Security Taxes 1357 06/26/2020 MUD Payroll 6/26/2020 Social Security Taxes 15,027.94 1,217.06 1,214.22 16,245.00 17,459.22 PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,431.28 17,459.22 ** 39,215.00 Budgeted 21,755.78 Remaining 45 % Used Account: 135-50035-030-000 Medicare Taxes Mr 1305 06/12/2020 MUD Payroll 6/12/2020 Medicare Taxes 1357 06/26/2020 MUD Payroll 6/26/2020 Medicare Taxes 3,514.62 284.64 283.97 3,799.26 4,083.23 PR PR Account: 135-50035-030-000 Medicare Taxes Totals: 568.61 4,083.23 ** 9,171.00 Budgeted 5,087.77 Remaining 45 % Used Account: 135-50040-030-000 Unemployment Taxes 1305 06/12/2020 MUD Payroll 6/12/2020 Unemployment Taxes 1357 06/26/2020 MUD Payroll 6/26/2020 Unemployment Taxes 864.00 86.15 57.85 950.15 1,008.00 PR PR Account: 135-50040-030-000 Unemployment Taxes Totals: 144.00 1,008.00 ** 1,440.00 Budgeted 432.00 Remaining 70 % Used Account: 135-50045-030-000 Workman's Compensation 74 06/01/2020 Insurance/Wrk Comp Expense Jun 838.56 104.82 943.38 GL glpdatb2 ekrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 Beginning Balance JE Detail Description/Comment Workman's Compensatio 1,775.00 Budgeted Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Account: 135-50060-030-000 Pre-emp Physicals/Testing 831.62 Remaining Account: 135-50060-030-000 Pre-emp Physicals/Testing 500.00 Budgeted 500.00 Remaining Account: 135-50070-030-000 Employee Relations Account: 135-50070-030-000 Employee Relations o a e• 8,000.00 Budgeted 4,921.90 Remaining Software & Support Account: 135-55030-030-000 1192 06/01/2020 1252 06/02/2020 1310 06/09/2020 1366 06/24/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 Account: June A/p June A/P June A/P June A/P PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 Microsoft exchange Annual Maintenance -Remit Cell phones -June Internet -June website fee Internet internet Internet adobe subscription 135-55030-030- Totals: 134,681.00 Budgeted 50,499.98 Remaining 3,078.10 80,570.16 53 % Used 0 % Used 38 % Used 63 % Used .00 .00 .00 3,078.10 494.00 81,064.16 1,950.00 83,014.16 49.63 83,063.79 899.00 83,962.79 44.34 84,007.13 52.37 84,059.50 42.37 84,101.87 42.37 84,144.24 36.78 84,181.02 M3 Networks JACK HENRY & ASSOC, INC VERIZON WIRELESS Charter Communications DNH*GODADDY. COM ATT*BILL PAYMENT ATT*SILL PAYMENT ATT*SILL PAYMENT ADOBE ACROPRO SUBS Page 36 Check Source Number 6455 AP 6472 AP 6519 AP 6551 AP PC PC PC PC PC Account: 135-55070-030-000 Independent Labor 1310 06/09/2020 June A/P Carmen hours April & May Account: 135-55070-030-000 Independent Labor 135,000.00 Budgeted 45,073.93 Remaining Account: 135-551Ie & R 1385 06/30/2020 June A/P a/c work 88,810.54 1,115.53 67 % Used 89,926.07 Carman Consulting LLC. 6504 AP 1,560.00 295.00 1,855.00 BRANDON R REED 6550 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number Account: 135 JE Date Account: 135-55085-030-000 Account: 135-55085-030-000 JE Description Account: 135-55120-030-000 1344 06/19/2020 June A/P Account: 135-55120-030-000 Account: 135-55160-030-000 Account: 135-55160-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment Maintenance & Repairs 15,000.00 Budgeted 13,145.00 Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Cleaning Services Janitorial service -May Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Remaining Cleaning Services 10,000.00 Budgeted 444.44 Remaining Professional Outside Services Professional Outside Servi 65,600.00 Budgeted Account: 135-55205-030- Utility Billing Cont 1310 06/09/2020 June A/P Billing -May 1419 06/30/2020 June A/P A xb205-0ce0111111111111111 Account: 135-60005-030-000 i 1192 06/01/2020 June A/P water bills -June 8,500.00 Remaining Utility Billing Contract Totals: 9,000.00 Budgeted 3,746.42 Remaining Tnlnnhnnu 1344 06/19/2020 June A/P 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1468 06/30/2020 Town Billed Invoices 1742-174 Answering service -June Answering service -July phone phone phone answering service 5 AR 20200630-20200630 User: 531.00 7,658.64 57,100.00 4,179.68 12,195.34 12 Ueed 5 % Used 96 % Ueed 87 Used .00 531.00 Page 37 Check Source Number 1,896.92 9,555.56 MEMBER'S BUILDING MAINTENANCE 6534 AP .00 57,100.00 535.41 4,715.09 DATAPROSE LLC 538.49 5,253.58 DATAPROSE LLC 58 b Used 530.99 758.26 466.71 797.51 175.30 16.76 (180.00) 12,726.33 13,484.59 13,951.30 14,748.81 14,924.11 14,940.87 14,760.87 KEYSTONE PARK SECRETARIAL KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 6507 AP 6593 AP 6453 AP 6530 AP PC PC PC PC AR glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 6/2020 JE Detail Description/Comment Telephone 23,680.00 Budgeted Page 38 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 8,919.13 Communications/Mobiles 1310 06/09/2020 June A/P Cell phones -June 1357 06/26/2020 MUD Payroll 6/26/2020 Communications/Mobiles Account: 135 Communications/Mobiles 4,000.00 Budgeted Remaining 62 Used 1,815.12 49.63 1,864.75 VERIZON WIRELESS 6519 AP 225.00 2,089.75 PR 1,910.25 Remaining 52 % Used Acco Electricity/GAIL 1344 06/19/2020 June A/P Gexa energy Acc'until Electricity 6,879.00 Budgeted 3,907.56 464.46 2,506.98 Remaining 64 % Used 4,372.02 TOWN OF TROPHY CLUB 6543 AP Account: 135-60025-030-000 Wate 1419 06/30/2020 June A/P water -June 1,250.60 226.50 1,477.10 TROPHY CLUB MUD (WATER BILLS) 6602 AP 1468 06/30/2020 Town Billed Invoices 1742-1745 AR 20200630-20200630 User: (113.25) 1,363.85 AR Account: 135-60025-030-000 1,500.00 Budgeted 35-03 1310 06/09/2020 June A/P Billing -May 1403 06/26/2020 PCards 5/27/2020-6/26/2020 FedEx shipping 1419 06/30/2020 June A/P water bills -June 136.15 Remaining 91 % Used 11,725.51 1,456.56 13,182.07 DATAPROSE LLC 6507 AP 87.64 13,269.71 FEDEX 61681905 PC 1,452.54 14,722.25 DATAPROSE LLC 6593 AP Account 30,000.00 Budgeted Account: 135-60040-030-0 Service Charges & Fees 1310 06/09/2020 June A/P Dig Tess -May 1344 06/19/2020 June A/P 1419 06/30/2020 June A/P 1419 06/30/2020 June A/P 1433 06/30/2020 Pace Credit Card Fees 15,277.75 Remaining 49 % Used Direct send fees -May Dig Tess -June Direct send fees -June 46,836.29 251.75 47,088.04 Texas Excavation Safety System 6516 AP 50.00 47,138.04 Fisery Solutions, LLC 6525 AP 301.15 47,439.19 Texas Excavation Safety System 6600 AP 50.00 47,489.19 Fisery Solutions, LLC 6594 AP 5,322.88 52,812.07 GL glpdatb2 skrolczyk Trophy Club MUD No.1 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 39 1433 06/30/2020 Pace Credit Card Fees 'Account: 135-6O 'Q -O Service Charges & Fees Totals: 67,000.00 Budgeted 14,180.93 Remaining Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 Bad Debt Expense 1,500.00 Budgeted Account: 135- -030- 74 06/01/2020 Insurance/Wrk Comp Expense Jun Account: 135-60066-030-000 Account: 135-60066-030-000 Insurance 84,000.00 Budgeted 1,500.00 Remaining 46,836.29 7.00 52,819.07 79 % Used 0 % Used 5,98 .00 .00 52,425.26 6,998.39 24,576.35 Remaining 71 % Used Publications/Books/Subscripts 125.00 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 875.00 Remaining 13 % Ueed Account: 135-60070-030-000 Dues & Memberships Account: 135-60070-030-000 Account: 135-60075-030-000 Dues & Memberships Totals: 6,000.00 Budgeted Meetings Account: 135-60075-030-000 Meeting. 400.00 Budgeted Account: 135-6: 1403 06/26/2020 PCards 5/27/2020-6/26/2020 Legal documents 4,285.55 1,714.45 Remaining 71 % Ueed 284.91 Remaining 115.09 3,971.51 29 GL 59,423.65 GL .00 125.00 .00 4,285.55 .00 115.09 4,047.85 Used 76.34 NCOURT TXTARRANTCOSWP PC glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment Account: 135-60079-03t Public Education 6,000.00 Budgeted Account: 135 ools 1344 06/19/2020 June A/P 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1,952.15 Remaining & Training Training for timeclock plus GFOA Conference refund AFourmentin Training Training for HR for DGrubbs Membership for training for DG 1,452.21 Program: Transaction Detail 67 % Ueed Transaction Vendor Name Detail (SUBTOTAL) 76_- 4,047.85 :e 450.00 (195.00) 280.00 239.00 160.00 1,902.21 1,707.21 1,987.21 2,226.21 2,386.21 Data Management Inc. GOVERNMENT FINANCE OFF NCTCOG RTC TRAINING SOCIETYFORHUMANRESOURC DALLAS HUMAN RESOURCE Page 40 Check Source Number 6523 AP PC PC PC PC 6,850.00 Budgeted 4,463.79 Remaining Travel & per diem 1305 06/12/2020 MUD Payroll 6/12/2020 1403 06/26/2020 PCards 5/27/2020-6/26/2020 1385 06/30/2020 June A/P Travel & per diem parking fee tolls to lab Account: 135-60100-030-00 Travel & per diem Account: 135-60110-030-000 1 35 % Used 1,098.61 45.70 1,144.31 1.25 1,145.56 CFW PARKING METER 11.85 1,157.41 NTTA PR PC 6564 AP Totals: 3,545.00 Budgeted 2,387.59 Remaining 33 % Used Physicals/Testing Account: 135-60110-030-000 Account: 135 ailli Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining 0 % Used .00 .00 Elections Account: 135-60115-0 Elections .00 Budgeted (138.04) Remaining Account: 135-60125-030- Advertis� 1403 06/26/2020 PCards 5/27/2020-6/26/2020 job posting 1419 06/30/2020 June A/P engineer RFP 138.04 0 % Used .00 138.04 1,772.20 150.00 1,922.20 YOURMEMBER-CAREERS PC 2,039.60 3,961.80 STAR -TELEGRAM OPERATING LTD 6599 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Accmigi 1363 06/23/2020 June A/P Account: 13 2,500.00 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 6/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Budgeted (1,461.80) Remaining Security monitoring svc-june Security 1,288.00 Budgeted 158 168.00 Used Totals: 1,096.00 Remaining 15 % Used Account: 135-602 Miscellaneous Expenses Account: 135-60245-030-000 Miscellaneous Expenses Totals: Account: 135-60246-030-000 General Manager Contingency 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 General Manager Contingenc 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < Furniture/Equipment < 0500 2,500.00 Budgeted Uniforms= 2,050.00 Budgeted Account: 135-65055-030-000 Hardware - 1344 06/19/2020 June A/P back up battery 2,500.00 Remaining 0 % Used 0 24.00 192.00 Digital Air Control, Inc .00 .00 .00 .00 .00 Used .00 2,050.00 Remaining 0 % Used 3,916.21 69.99 .00 .00 Page 41 Check Source Number 6555 AP 3,986.20 M3 Networks 6532 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment Account: 135-65055-03t Hardware 7 26,485.00 Budgeted 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1344 06/19/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1385 06/30/2020 Account: 135-65085-030-000 Account: 135-65090-030-000 Account: 135-65090-030-000 Account: 135-65095-030-000 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 1403 06/26/2020 Office June A/P June A/P June A/P June A/P June A/P June A/P June A/P June A/P June A/P June A/P PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 PCards 5/27/2020-6/26/2020 June A/P PCards PCards PCards PCards PCards PCards PCards PCards PCards 22,498.80 Remaining Supplies office supplies office supplies office supplies office supplies office supplies office supplies office supplies office supplies office supplies office supplies name plates business cards for AFourmentin portfolio windscreen office supplies `e Supplj 6,000.00 Budgeted 2,061.55 Remaining Printer Supplies & Maintenance Printer Supplies & Maintenance Tota 3,500.00 Budgeted 3,500.00 Remaining Maint 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 enance Suppli- parital refund on gloves sanitizing wipes tea tea gloves hand sanitizer, candy hand sanitizer coffee walmart supplies Program: Transaction Detail 15 % Used Transaction Vendor Name Detail (SUBTOTAL) 69_- 3,986.20 ** 2,935.99 21.24 2,957.23 OFFICE DEPOT, INC 6.86 2,964.09 OFFICE DEPOT, INC 65.67 3,029.76 OFFICE DEPOT, INC 49.99 3,079.75 OFFICE DEPOT, INC 38.97 3,118.72 OFFICE DEPOT, INC 165.58 3,284.30 OFFICE DEPOT, INC 3.52 3,287.82 OFFICE DEPOT, INC 5.12 3,292.94 OFFICE DEPOT, INC 4.54 3,297.48 OFFICE DEPOT, INC 59.69 3,357.17 OFFICE DEPOT, INC 100.00 3,457.17 SQ *KELLER TROPHY AND 60.00 3,517.17 SIGMA SIGNS AND PRINTI 12.99 3,530.16 AMZN MKTP US*MSOSD5FA2 18.29 3,548.45 AMAZON.COM*MY82W3CV1 390.00 3,938.45 OFFICE DEPOT, INC 2,848 53 66 % Used 0 % Used .00 .00 .00 ** (1.08) 2,847.45 36.54 2,883.99 12.29 2,896.28 13.22 2,909.50 26.67 2,936.17 31.97 2,968.14 24.59 2,992.73 49.17 3,041.90 2.91 3,044.81 AMZN MKTP US AMZN MKTP US*MS7FN9NT0 AMAZON.COM*MS81MOCA0 AMAZON.COM*MS5714CP0 AMZN MKTP US*MY6H08KQ2 TOM THUMB #1789 AMAZON.COM*MS9E41LD1 AMAZON.COM*MY59806M2 WALMART GROCERY Page 42 Check Source Number 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP 6536 AP PC PC PC PC 6565 AP PC PC PC PC PC PC PC PC PC glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1403 06/26/2020 PCards 1403 06/26/2020 PCards 1403 06/26/2020 PCards 1403 06/26/2020 PCards 1403 06/26/2020 PCards 1403 06/26/2020 PCards 1403 06/26/2020 PCards 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 5/27/2020-6/26/2020 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2020 JE Detail Beginning Balance Description/Comment walmart supplies walmart supplies walmart supplies walmart supplies walmart supplies urinal mat masks, floor decals Account: 135-65095-030-00 Maintenance Suppli 4,000.00 Budgeted Account: 135-65105-030-000 Printing Totals: 648.32 Remaining Account: 135-65105-030-000"Mr •_Pr tale: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-69005-030-000 Capital Outlays Account: 135-69005-030-00 Capital Outlays 195,000.00 Budgeted 166,552.16 Remaining Account: 135-69170-030- Copier Lease Installments 1346 06/19/2020 June A/P copier lease-june Department 30 Totals: Copier Lease Installments 4,000.00 Budgeted 1,922.40 Remaining 90,802.49 Monthly Total Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 2,848.53 12.96 3,057.77 WALMART GROCERY 5.34 3,063.11 WALMART GROCERY 3.02 3,066.13 WALMART GROCERY 86.53 3,152.66 WALMART GROCERY .26 3,152.92 WALMART GROCERY 54.99 3,207.91 AMZN METP US*MY6AW7E60 143.77 3,351.68 AMZN METP US*MY8JV7JS0 28,447.84 50 84 % Used 0 % Used 15 % Used .00 .00 .00 28,447.84 1,912.60 165.00 2,077.60 TIAA COMMERCIAL FINANCE 165.00 52 % Used 876,319.38 ** 1,776,712.00 Budgeted 900,392.62 Remaining 49 % Used Page 43 Check Source Number PC PC PC PC PC PC PC 6542 AP glpdatb2 skrolczyk 20:46 07/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 44 Check Source Number Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 7,018.48 Monthly Total 244.00 Remaining 94 % Used 136,337.68 ** 184,561.00 Budgeted 48,223.32 Remaining 74 % Used (482,658.72) (378,659.50) Monthly Total (6,224.00) Budgeted 476,434.72 Remaining ########## Account: 135-55045-039-000 Legal 1344 06/19/2020 June 1344 06/19/2020 June A/P A/P Westlake easement legal legal 90,427.89 322.50 4,452.50 90,750.39 95,202.89 WHITAKER CHALK SWINDLE McLean & Howard, L.L.P. 6545 6533 AP AP Account: 135-55045-039-000 Legal Totals: 4,775.00 95,202.89 ** 135,000.00 Budgeted 39,797.11 Remaining 71 % Used Account: 135-55055-039-000 Auditing 27,713.27 .00 27,713.27 Account: 135-55055-039-000 Auditing Totals: .00 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 1310 06/09/2020 June A/P 3rd qtr 2020 appraisel 7,422.04 2,243.48 9,665.52 DENTON CENTRAL APPRAISAL DISTR 6508 AP Account: 135-55060-039-000 Appraisal Totals: 2,243.48 9,665.52 ** 11,761.00 Budgeted 2,095.48 Remaining 82 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 7,018.48 Monthly Total 244.00 Remaining 94 % Used 136,337.68 ** 184,561.00 Budgeted 48,223.32 Remaining 74 % Used (482,658.72) (378,659.50) Monthly Total (6,224.00) Budgeted 476,434.72 Remaining ########## glpdatb2 skrolczyk 20:46 07/15/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 6/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 45 Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,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: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 496,811 TOTAL ASSETS 496,811 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (118,410) (70,255) TOTAL FUND BALANCE (188,665) TOTAL LIABILITIES AND FUND BALANCE 496,811 glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 89.73- 4,902.54- 4,902.54 Page 14 Subtotal: 89.73- 4,902.54- 4,902.54 Program number: 89.73- 4,902.54- 4,902.54 Department number: Revenues mm 89.73- 4,902.54- 4,902.54 Revenues Subtotal 89.73- 4,902.54- 4,902.54 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 6/2020 Adopted Amended Total Current Budget Budget Encumb. Month 7,811.25 Program: YTD Total 75,157.66 % of Remaining Budget Budget 75,157.66 - Page 15 Subtotal: 7,811.25 75,157.66 75,157.66 - Program number: 7,811.25 75,157.66 75,157.66 - Department number: Wastewater 7,811.25 75,157.66 75,157.66 - Expenditures Subtotal 7,811.25 75,157.66 75,157.66 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 7,721.52 70,255.12 70,255.12- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A00O." 1-000-000 Accoun Interest Income 1438 06/30/2020 Bank Interest- June (4,812.81) (89.73) (4,902.54) GL Interest Income Totals: (89.73) (4,902.54) .00 Budgeted 4,902.54 Remaining 0 % Used Department Totals: (4,902.54) ** (89.73) Monthly Total .00 Budgeted 4,902.54 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-0a0- 1310 06/09/2020 June A/P 1344 06/19/2020 June A/P 1350 06/22/2020 June A/P Department 20 Totals: Capital Outla WWTP foam system WWTP Lega; WWTP Crane Legal Capital .00 Budgeted 7,811.25 Monthly Total (75,157.66) Remaining 67,346.41 0 % Used .00 Budgeted 1,833.75 4,887.50 1,090.00 69,180.16 CP&Y/WALLACE GROUP, INC. 74,067.66 Dubois Bryant Campbell LLP 75,157.66 Wiss, Janney, Elstner Assoc 75,157.66 •• (75,157.66) Remaining 0 % Used Fund 517 Totals: 70,255.12 7,721.52 Monthly Total .00 Budgeted (70,255.12) Remaining 0 % Used 6506 AP 6524 AP 6546 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,947 TOTAL ASSETS 784,947 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 698,648 4,608 703,256 784,947 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 519 2016 Rev Bond Const -SWIFT Account Description 519-49011-000-000 Interest Income Subtotal: Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 6.67- 4,608.37- 6.67- 4,608.37- 4,608.37 4,608.37 Page 16 Department number: Revue 6.67- 4,608.37- 6.67- 4,608.37- 6.67- 4,608.37- 4,608.37 4,608.37 4,608.37 Revenues Subtotal Fund number: 519 2016 Rev Bond Const -SWIFT glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A00Ou 1-000-000 Interest Income 1438 06/30/2020 Bank Interest- June Account Interest Income .00 Budgeted (4,601.70) (6.67) (4,608.37) GL (6.67) (4,608.37) ** 4,608.37 Remaining 0 % Used Department Totals: (4,608.37) ** (6.67) Monthly Total .00 Budgeted 4,608.37 Remaining 0 % Used Fund 519 Totals: (4,608.37) (6.67) Monthly Total .00 Budgeted 4,608.37 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JUNE 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 345,704 INVESTMENTS 3,892,427 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,238,131 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,454,290 (216,159) 4,238,131 4,238,131 107.11- 27,687.08- 27,687.08 107.11- 27,687.08- 27,687.08 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 107.11- 27,687.08- 27,687.08 Page 17 Subtotal: Program number: 107.11- 27,687.08- 27,687.08 Department number: Revenues Subtotal 107.11- 27,687.08- 27,687.08 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 6/2020 Adopted Amended Total Current Budget Budget Encumb. Month 70,281.01 Program: YTD Total 243,845.79 % of Remaining Budget Budget 243,845.79 - Page 18 Subtotal: 70,281.01 243,845.79 243,845.79 - Program number: 70,281.01 243,845.79 243,845.79 - Department number: Water Department 70,281.01 243,845.79 243,845.79 - Expenditures Subtotal 70,281.01 243,845.79 243,845.79 - Fund number: 520 Revenue Bond 16" Waterline ME 70,173.90 216,158.71 216,158.71- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Interest Income 1438 06/30/2020 Bank Interest- June (27,579.97) 1438 06/30/2020 Bank Interest- June Account: 520-490 Interest Income Totals: .00 Budgeted 27,687.08 Remaining 0 % Used (74.05) (27,654.02) GL (33.06) (27,687.08) GL Department Totals: (27,687.08) ** (107.11) Monthly Total .00 Budgeted 27,687.08 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 5a0 -69005-010-P" 1313 06/09/2020 June A/P 1344 06/19/2020 June A/P Account: -.115T;71505-0 Capital Outlays Easement with Trophy Club Lodg Parcel 28 easement -Davis Blvd Capital Outlays Totals: .00 Budgeted 173,564.78 31,163.00 204,727.78 Barron a Adler, LLP 6502 AP 39,118.01 243,845.79 Citibank, N.A. 6521 AP (243,845.79) Remaining 0 % Used Department 10 Totals: 243,845.79 ** 70,281.01 Monthly Total .00 Budgeted (243,845.79) Remaining 0 % Used Fund 520 Totals: 216,158.71 70,173.90 Monthly Total .00 Budgeted (216,158.71) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,467 TOTAL ASSETS 893,467 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 803,457 90,010 893,467 893,467 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 528 2015 Revenue Bond Reserve Fund Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW Trophy Club MUD No.1 Budget Summary with Amendment Department: Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- 158.93- 7,209.96- 36,800.00- 46,000.00- 65.545 11.985 22.952 3,790.04- 270,249.00- 154,417.00- Program number: Department number: Revenues Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 158.93- 158.93- 158.93- 158.93- 90,009.96- 90,009.96- 90,009.96- 90,009.96- 17.361 17.361 17.361 17.361 428,456.04- 428,456.04- 428,456.04- 428,456.04 - Page 19 glpdatb2 skrolczyk Trophy Club MUD No.1 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 51 ACcoua. 'l-000-000 1438 06/30/2020 Bank Interest- June Interest Income Ac 8-490 come Account: 528-49142-000-000 Account: 528-49142-000-000 Account: 528-49143-000-000 Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (11,000.00) Budgeted (7,051.03) (158.93) (3,790.04) Remaining 66 % Used (36,800.00) (307,049.00) Budgeted (270,249.00) Remaining iInterfund trans£= Interfund transfer in -WW (7,209.96) GL .00 (36,800.00) 12 % Used (46,000.00) (200,417.00) Budgeted (154,417.00) Remaining 0 23 % Used (46,000.00) (90,009.96) ** (158.93) Monthly Total (518,466.00) Budgeted (428,456.04) Remaining 17 % Used (90,009.96) (158.93) Monthly Total (518,466.00) Budgeted (428,456.04) Remaining 17 % Used TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS 873,939 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 16,646 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 890,585 FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 16,646 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 16,646 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 790,985 TOTAL FUND BALANCE 873,939 TOTAL LIABILITIES AND FUND BALANCE 890,585 glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 2,223.17- 70.26- 544.12- 683,727.67- 1,859.98- 2,367.90- 100.189 185.998 118.395 1,286.67 859.98 367.90 Page 20 Subtotal: Mr - 2,837.55- 100.367 2,514.55 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 161.63- 10,414.81- 3,907.27- 218,004.00- 93,733.29- 78.145 100.000 81.818 1,092.73- 20,829.71- 1 Subtotal: 337,567.00- 337,567.00- 10,576.44- 315,644.56- 93.506 21,922.44 - Program number: 1,023,008.00- 1,023,008.00- 13,413.99- 1,003,600.11- 98.103 19,407.89 - Department number: Revenues 1,023,008.00- 1,023,008.00- 13,413.99- 1,003,600.11- 98.103 19,407.89 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 13,413.99- 1,003,600.11- 98.103 19,407.89- glbase_tbam skrolczyk 20:25 07/15/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 533-70020-051-000 533-70025-051-000 1 533-70035-051-000 Paying Agent Fee Bond Issuance Bond Interest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 87,236.14 1,450.00 87,236.14 123,928.75 67.442 50.000 700.00 87,236.14- 123,929.25 765,000.00 Page 21 ir Subtotal: 1,015,008.00 1,015,008.00 87,236.14 212,614.89 20.947 802,393.11 Program number: 1,015,008.00 1,015,008.00 87,236.14 212,614.89 20.947 802,393.11 Department number: Administration 1,015,008.00 1,015,008.00 87,236.14 212,614.89 20.947 802,393.11 Expenditures Subtotal 1,015,008.00 1,015,008.00 87,236.14 212,614.89 20.947 802,393.11 Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 73,822.15 790,985.22- 9,887.315 782,985.22 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Acco : 533-40000-000- 1446 06/01/2020 Property Taxes 1447 06/02/2020 Property Taxes 1448 06/03/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1452 06/10/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1461 06/29/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 6/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes Account: 533-40000-000- Property Taxes Total (682,441.00) Budgeted (681,504.50) 1,286.67 Remaining (212.80) (681,717.30) (613.58) (682,330.88) (102.44) (682,433.32) (25.36) (682,458.68) (2,852.97) (685,311.65) (223.34) (685,534.99) (76.73) (685,611.72) (391.20) (686,002.92) (134.22) (686,137.14) (25.43) (686,162.57) (28.99) (686,191.56) 2,519.89 (683,671.67) (16.81) (683,688.48) (16.68) (683,705.16) (22.51) (683,727.67) 100 % Used Page 52 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40002-000-00 1449 06/04/2020 Property Taxes 1452 06/10/2020 Property Taxes 1454 06/12/2020 Property Taxes 1456 06/17/2020 Property Taxes 1460 06/25/2020 Property Taxes 1462 06/30/2020 Property Taxes Property Taxes/Delinquent J Account: 533-40015-000-000 1446 06/01/2020 Property Taxes 1449 06/04/2020 Property Taxes 1450 06/05/2020 Property Taxes 1451 06/09/2020 Property Taxes 1453 06/11/2020 Property Taxes 1454 06/12/2020 Property Taxes 1455 06/15/2020 Property Taxes 1456 06/17/2020 Property Taxes 1457 06/22/2020 Property Taxes Property Taxes/Delinquent Totals: (1,000.00) Budgeted 859.98 Remaining Property Taxes/P & I (1,789.72) (10.77) (1,800.49) (6.62) (1,807.11) (27.53) (1,834.64) (11.77) (1,846.41) (5.98) (1,852.39) (7.59) (1,859.98) 186 % Used (1,823.78) (6.90) (1,830.68) (2.58) (1,833.26) (400.37) (2,233.63) (26.01) (2,259.64) (58.68) (2,318.32) (25.36) (2,343.68) (1.79) (2,345.47) (3.41) (2,348.88) (9.79) (2,358.67) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: Page 53 1458 06/23/2020 Property Taxes 1459 06/24/2020 Property Taxes 1460 06/25/2020 Property Taxes 1461 06/29/2020 Property Taxes 1462 06/30/2020 Property Taxes -40015-000- Account: 533-49011-000-000 1438 06/30/2020 Bank Interest- June Account: 533-49011-000-000 Account: 533-49015-000-000 Account: 533-49015-000-000 Property Taxes/P & I Totals: (2,000.00) Budgeted Interest Income Interes• (5,000.00) Budgeted Lease/Rental Income Lease/Rental Income (218,004.00) Budgeted (1,823.78) 367.90 Remaining 118 % Used (1,092.73) Remaining (3,745.64) 78 (218,004.00) .00 Remaining Used 100 % Used (.60) (2,359.27) (2.50) (2,361.77) (1.56) (2,363.33) (2.82) (2,366.15) (1.75) (2,367.90) (161.63) (3,907.27) .00 (218,004.00) .00 (218,004.00) •• Account: 533-49141-000-0 terfund Trans In -PID Su• 1439 06/30/2020 TexPool Transfers June TexPool O&M to I&S- PID Debt (83,318.48) (10,414.81) (93,733.29) AC Department Totals: (114,563.00) Budgeted (13,413.99) Monthly Total (20,829.71) Remaining 82 Used (1,003,600.11) •* (1,023,008.00) Budgeted (19,407.89) Remaining 98 % Used GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/2020 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 Account: 533-70005-051-00011 Paying Agent Fee 2,150.00 Budgeted Account: 533-70020-051-000 Bond Issuance 1496 06/17/2020 Refud Unl Tax Bond Series 2020 Issuer Contribution Account: 1,450.00 .00 1,450.00 700.00 Remaining 67 % Ueed Bond Issuance .00 Budgeted (87,236.14) Remaining 87,236.14 87,236.14 0 % Ueed GL Account: 533-70051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 123,928.75 Bond Interest Expense -Tax Totals: 247,858.00 Budgeted 123,929.25 Remaining .00 123,928.75 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Bond Principal Payment -T 765,000.00 Budgeted Department 51 Totals: 765,000.00 Remaining 0 Used .00 .00 212,614.89 ** 87,236.14 Monthly Total 1,015,008.00 Budgeted 802,393.11 Remaining 21 % Used Fund 533 Totals: (790,985.22) 73,822.15 Monthly Total (8,000.00) Budgeted 782,985.22 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 411,330 TOTAL ASSETS 411,330 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 24,518 386,812 411,330 411,330 glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 598,638.00- 598,638.00- Subtot 6060- 601 438.00 - Program number: 6011111100 - Department number: Revenues 6011'38.00 - Revenues Subtotal 601,138.00- 601,138.00- 601,138.00- 601,138.00 - Page 22 63.81- 1,336.79- 53.472 1,163.21- I 54,421.63- 489,794.07- 81.818 108,843.93- I ,485.44- 1 54,485.44- 491,130.86- 54,485.44- 491,130.86- 54,485.44- 491,130.86- glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 534-70040-051-000 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 208,238.00 390,000.00 400.00 208,238.00 390,000.00 Subtotal: , 598,638.00 598,638.00 Program number: III 598,638.00 598,638.00 Department number: Administration III 598,638.00 598,638.00 Expenditures Subtotal III 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,485.44- 200.00 50.000 200.00 104,118.75 50.000 104,119.25 390,000.00 17.426 494,319.25 1C=Plin 17.426 494,319.25 18.75 17.426 494,31 1c L8.75 17.426 494,31 3411..2.11- ############### 384,312.11 Page 23 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (54,485.44) Monthly Total (491,130.86) ** (601,138.00) Budgeted (110,007.14) Remaining 82 5 Used Account: 534-49011-000-000 Interest Income 1438 06/30/2020 Bank Interest- June (1,272.98) (63.81) (1,336.79) GL Account: 534-49011-000-000 Interest Income Totals: (63.81) (1,336.79) ** (2,500.00) Budgeted (1,163.21) Remaining 53 5 Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales I 1439 06/30/2020 TexPool Transfers June TexPool O&M to Rev Bd WWTP I&S (435,372.44) (54,421.63) (489,794.07) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: * (54,421.63) (489,794.07) ** (598,638.00) Budgeted (108,843.93) Remaining 82 5 Used Department Totals: (54,485.44) Monthly Total (491,130.86) ** (601,138.00) Budgeted (110,007.14) Remaining 82 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/2020 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 Account: 534-70005-051-000 Rev Bond Paying Agent Fee - 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 Account: 534-70045-051-000 Revenue Bond Principal Expense t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining 50 % Used .00 200.00 .00 104,118.75 50 % Used .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (386,812.11) (54,485.44) Monthly Total (2,500.00) Budgeted 384,312.11 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 200,728 TOTAL ASSETS 200,728 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,967 195,761 200,728 200,728 glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Subtot Program number: Department number: Revenues Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Revenues Subtotal 31.37- 25,047.72- 25.00- 0- 276125.00- * 25,079.09- 0- 276,525.00- 25,079.09- 276,525.00- 276,525.00- 25,079.09- 594.15- 59.415 405.85- 225,429.48- 81.818 50,095.52- 226, 81.737 50,501.37- 22. 226, EZ'S.'�3- 226,023.63- 81.737 81.737 81.737 50,501.37- 50,501.37- 50,501.37 - Page 24 glbase_tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 6/2020 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 800.00 800.00 200.00 25.000 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 30,062.50 7.772 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: ,IIIIIII02,611.00 602,611.00 5.022 Program number: _b02,611.00 602,611.00 II 30,262.50 5.022 Department number: Administration mEr 602,611.00 602,611.00 II 30,262.50 5.022 Expenditures Subtotal 602,611.00 602,611.00 II 30,262.50 5.022 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 195,761.13- -60.034 600.00 356,748.50 215,000.00 572,348.50 572,348.50 572,348.50 572,348.50 521,847.13 Page 25 glpdatb2 skrolczyk 20:46 07/15/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 6/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 57 Check Source Number Department Totals: (25,079.09) Monthly Total (226,023.63) ** (276,525.00) Budgeted (50,501.37) Remaining 82 % Used Account: 535-49011-000-000 Interest Income 1438 06/30/2020 Bank Interest- June (562.78) (31.37) (594.15) GL Account: 535-49011-000-000 Interest Income Totals: (31.37) (594.15) ** (1,000.00) Budgeted (405.85) Remaining 59 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1439 06/30/2020 TexPool Transfers June TexPool O&M to 16Swift Rev I&S (200,381.76) (25,047.72) (225,429.48) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals:MI (25,047.72) (225,429.48) ** (275,525.00) Budgeted (50,095.52) Remaining 82 5 Used Department Totals: (25,079.09) Monthly Total (226,023.63) ** (276,525.00) Budgeted (50,501.37) Remaining 82 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 6/2020 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 Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Account: 535-70045-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 200.00 30,062.50 25 % Used .00 200.00 .00 30,062.50 8 % Used .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (195,761.13) (25,079.09) Monthly Total 326,086.00 Budgeted 521,847.13 Remaining -60 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JUNE 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 53,035 TOTAL ASSETS 53,035 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 53,035 TOTAL FUND BALANCE 53,035 TOTAL LIABILITIES AND FUND BALANCE 53,035 glbase tbam skrolczyk Trophy Club MUD No.1 20:25 07/15/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 6/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 26 1536-49011-000-000 Interest Income 4.34- 453.20- 453.20 I 1536-49142-000-000 Interfund Tran In -Water Sales 22,896.02- 206,064.18- 206,064.18 I 1536-49143-000-000 Interfund Transfer In -WW Sales 6,839.07- 61,551.63- 61,551.63 I Subtotal: 29,739.43- 268,069.01- 268,069.01 Program number: 29,739.43- 268,069.01- 268,069.01 Department number: Revenues 29,739.43- 268,069.01- 268,069.01 I Revenues Subtotal ME 29,739.43- 268,069.01- 268,069.01 glbase_tbam skrolczyk 20:25 07/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-70005-051-000 536-70040-051-000 Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 6/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - Page 27 Subtotal: Program number: 215,034.51 215,034.51 215,034.51 - 215,034.51 - Department number: Administration 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 29,739.43- 53,034.50- 53,034.50 ******* End of Report ********* glpdatb2 skrolczyk Trophy Club MUD No.1 Page 59 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 1438 06/30/2020 Bank Interest- June (448.86) (4.34) (453.20) GL Account: 536-49011-000-000 Interest Income Totals: (4.34) (453.20) ** .00 Budgeted 453.20 Remaining 0 % Uaed Account: 536-49142-000-000 1439 06/30/2020 TexPool Transfers June TexPool O&M to I&S- W&WW SYS (183,168.16) (22,896.02) (206,064.18) GL Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: (22,896.02) (206,064.18) ** .00 Budgeted 206,064.18 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales 1439 06/30/2020 TexPool Transfers June TexPool O&M to I&S- W&WW SYS (54,712.56) (6,839.07) (61,551.63) GL Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: (6,839.07) (61,551.63) ** .00 Budgeted 61,551.63 Remaining 0 % Used Department Totals: (268,069.01) ** (29,739.43) Monthly Total .00 Budgeted 268,069.01 Remaining 0 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 60 20:46 07/15/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 6/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Rev Bond Paying Agent Fee Account: 536-70005-051-000 Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 214,892.43 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (214,892.43) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 5 Used .00 Monthly Total .00 Budgeted (29,739.43) Monthly Total .00 Budgeted .00 142.08 .00 214,892.43 .00 215,034.51 ** (215,034.51) Remaining 0 5 Used (53,034.50) 53,034.50 Remaining 0 % Used ******* End of Report ********* (2,213,789.20) **** (248,253.47) Monthly Total (209,104.00) Budgeted 2,004,685.20 Remaining ##########