Loading...
HomeMy WebLinkAbout2020-09 Combined Financials September 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK INVESTMENTS 627,649 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 16,712 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 24,423 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. TOTAL ASSETS 668,784 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 16,719 TOTAL LIABILITIES 16,719 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,768 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 48,297 TOTAL FUND BALANCE 652,065 TOTAL LIABILITIES AND FUND BALANCE 668,784 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 9/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,214,230.00- 1,214,230.00- 357.52- 164.26- 128.22- 1,223,805.45- 3,735.85- 6,897.36- 100.789 9,575.45 3,735.85 6,897.36 Subtotal: 1,214,230.00- 1,214,230.00- 650.00- 1,234,438.66- 101.664 20,208.66 122-49900-000-000 Miscellaneous Income 24,422.67- 24,422.67- 24,422.67 Subtotal: 24,422.67- 24,422.67- 24,422.67 Program number: 1,214,230.00- 1,214,230.00- 25,072.67- 1,258,861.33- 103.676 44,631.33 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 25,072.67- 1,258,861.33- 103.676 44,631.33 Revenues Subtotal 1,214,230.00- 1,214,230.00- 25,072.67- 1,258,861.33- 103.676 44,631.33 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 122 Trophy Club MUD Fire Dept. Account 122-55080-045-000 Description Maintenance & Repairs Department: 45 Fire Period Ending: 9/2020 Amended Total Budget Encumb. Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Program: Current YTD Month Total 1,700.00 5,900.00 % of Remaining Budget Budget 5,900.00 - Page 2 Subtotal: 1,700.00 5,900.00 5,900.00- 122-60030-045-000 122-60055-045-000 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget 218,004.00 21,000.00 718,657.00 218,004.00 21,000.00 718,657.00 1,640.88 59,888.08 218,004.00 19,690.56 718,656.96 100.000 93.765 100.000 1,309.44 .04 Subtotal: 957,661.00 957,661.00 61,528.96 956,351.52 99.863 1,309.48 122-69005-045-000 122-69009-045-000 122-69195-045-000 Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement 48,000.00 81,420.00 48,000.00 81,420.00 5,314.42 39,743.42 9,078.48 81,420.00 82.799 100.000 8,256.58 9,078.48- 122-69305-045-000 Capital Leases 127,149.00 127,149.00 118,070.12 92.860 9,078.88 Subtotal: 256,569.00 256,569.00 5,314.42 248,312.02 96.782 8,256.98 Program number: 1,214,230.00 1,214,230.00 68,543.38 1,210,563.54 99.698 3,666.46 Department number: Fire 1,214,230.00 1,214,230.00 68,543.38 1,210,563.54 99.698 3,666.46 Expenditures Subtotal 1,214,230.00 1,214,230.00 68,543.38 1,210,563.54 99.698 3,666.46 Fund number: 122 Trophy Club MUD Fire Dept. 43,470.71 48,297.79- 48,297.79 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes (1,223,447.93) (32.92) (1,223,480.85) GL (25.82) (1,223,506.67) GL (.46) (1,223,507.13) GL (145.15) (1,223,652.28) GL (153.17) (1,223,805.45) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (357.52) (1,223,805.45) ** (1,214,230.00) Budgeted 9,575.45 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1894 09/03/2020 Property Taxes 1896 09/16/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes (3,571.59) (17.10) (125.61) (.01) (9.49) (12.05) (3,588.69) (3,714.30) (3,714.31) (3,723.80) (3,735.85) GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (164.26) (3,735.85) ** .00 Budgeted 3,735.85 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 1894 09/03/2020 Property Taxes 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes (6,769.14) (4.62) (5.59) (27.27) (.09) (54.15) (33.37) (3.13) (6,773.76) (6,779.35) (6,806.62) (6,806.71) (6,860.86) (6,894.23) (6,897.36) GL GL GL GL GL GL GL Department Totals: (25,072.67) Monthly Total (1,258,861.33) ** (1,214,230.00) Budgeted 44,631.33 Remaining 104 % Used Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: (128.22) (6,897.36) ** .00 Budgeted 6,897.36 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1831 09/21/2020 Town Inv1753 FY19 Fire True -Up AR 20200921-20200921 User: (24,422.67) (24,422.67) AR Account: 122-49900-000-000 Miscellaneous Income Totals: (24,422.67) (24,422.67) ** .00 Budgeted 24,422.67 Remaining 0 % Used Department Totals: (25,072.67) Monthly Total (1,258,861.33) ** (1,214,230.00) Budgeted 44,631.33 Remaining 104 % Used glpdatb2 skrolczyk 14:57 10/14/20 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 2 Detailed Accounting Trial Balance Account: 122-55080-045-000 Maintenance & Repairs 1912 09/30/2020 Reclass Capital with departmen ACE Heating Repair Inv 11/1/19 4,200.00 Account: 122-55080-045-000 Account: 122-60030-045-000 Account: 122-60030-045-000 Maintenance & Repairs Totals: .00 Budgeted Rent And/Or Usage Rent And/Or Usage 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 77 09/01/2020 Insurance/Wrk Comp Expense Sep Account: 122-60055-045-000 Insurance 21,000.00 Budgeted (5,900.00) Remaining 0 % Used 218,004.00 Totals: .00 Remaining 1,700.00 5,900.00 GL 1,700.00 .00 100 % Used 5,900.00 ** 218,004.00 .00 218,004.00 ** 18,049.68 1,640.88 19,690.56 GL Totals: 1,309.44 Remaining 94 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1741 09/03/2020 September A/P Fire admin -September Account: 122-60337-045-000 1,640.88 19,690.56 ** 658,768.88 59,888.08 Transfer to Town/Fire Budget Totals: 718,657.00 Budgeted .04 Remaining Account: 122-69005-045-000 Capital Outlays 1844 09/24/2020 September A/P tough books for fire trucks 1912 09/30/2020 Reclass Capital with departmen ACE Heating Repair Inv 11/1/19 100 % Used 718,656.96 TOWN OF TROPHY CLUB 6790 AP 59,888.08 718,656.96 ** 34,429.00 7,014.42 (1,700.00) 41,443.42 CDW GOVERNMENT, INC 6828 AP 39,743.42 GL Account: 122-69005-045-000 Capital Outlays Totals: 5,314.42 39,743.42 ** 48,000.00 Budgeted Account: 122-69009-045-000 Short Term Debt -Interest Account: 122-69009-045-000 Account: 122-69195-045-000 8,256.58 Remaining 83 % Used Short Term Debt -Interest Totals: .00 Budgeted (9,078.48) Remaining GASB34/Reserve for Replacement 9,078.48 0 8 Used .00 9,078.48 .00 9,078.48 ** glpdatb2 skrolczyk 14:57 10/14/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 9/2020 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: Fund 122 Totals: 68,543.38 Monthly Total 43,470.71 Monthly Total 1,210,563.54 ** 1,214,230.00 Budgeted 3,666.46 Remaining 100 % Used .00 Budgeted (48,297.79) 48,297.79 Remaining 0 % Used 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 118,070.12 .00 118,070.12 Account: 122-69305-045-000 Capital Leases Totals: .00 118,070.12 ** 127,149.00 Budgeted 9,078.88 Remaining 93 % Used Department 45 Totals: Fund 122 Totals: 68,543.38 Monthly Total 43,470.71 Monthly Total 1,210,563.54 ** 1,214,230.00 Budgeted 3,666.46 Remaining 100 % Used .00 Budgeted (48,297.79) 48,297.79 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET SEPTEMBER 2020 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,245,705 3,245,705 CASH IN BANK -SAVINGS -CASH RESERVE 1,844,602 1,844,602 INVESTMENTS-TEXPOOL 3,803,515 1,721,064 5,524,579 PREPAID EXPENSES 3,486 3,486 ADVALOREM PROPERTY TAXES RECEIVABLE 1,752 1,752 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,166,336 1,166,336 TOTAL ASSETS 10,065,997 1,721,064 11,787,061 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,752 1,752 ACCOUNTS AND OTHER PAYABLES 765,316 765,316 CUSTOMER DEPOSITS 311,720 311,720 TOTAL LIABILITIES 1,078,788 1,078, 788 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,351,096 1,351,096 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 430,899 430,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 528,704 528,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 7,046,802 7,046,802 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 585,825 585,825 TOTAL FUND BALANCE 8,987,209 1,721,064 10,708,273 TOTAL LIABILITIES AND FUND BALANCE 10,065,997 1,721,064 11,787,061 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49075-000-000 135-49900-000-000 Subtotal: Program number: Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves Oversize Meter Reimbursement Miscellaneous income Department number: Revenues Revenues Subtotal Department: Adopted Budget 134,871.00- 300.00- 300.00- 164,253.00- 299,724.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00- Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 9/2020 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00- 299,724.00- 6,000,000.00- 3,200,000.00- 60,000.00- 10,000.00- 4,500.00- 2,500.00- 80,000.00- 9,357,000.00- 80,000.00- 14,146.00- 7,000.00- 13,000.00- 160,011.00- 12,691.00- 21,000.00- 307,848.00- 9,964,572.00- 9,964,572.00- 9,964,572.00- Current Month 39.68- 18.35- 14.28 - Program: YTD Total 135,857.26- 401.79- 768.62- 72.31- 137,027.67- 555,841.60- 5,653,504.37- 283,629.66- 3,197,798.38- 10,696.28- 61,752.71- 50.00- 9,950.00- 50.00- 5,500.00- 150.00- 5,100.00- 6,271.20- 89,036.80- 856,688.74- 9,022,642.26- 3,338.85- 1,178.81- 3,595.37- 353.00- 640.99 7,825.04- 81,518.16- 12,966.91- 5,833.30- 12,520.37- 20,085.28- 35,760.53- 168,684.55- 864,586.09- 9,328,354.48- 864,586.09- 9,328,354.48- 864,586.09- 9,328,354.48- % of Budget 100.731 133.930 256.207 45.718 94.225 99.931 102.921 99.500 122.222 204.000 111.296 96.427 101.898 91.665 83.333 96.311 158.264 170.288 54.795 93.615 Remaining Budget 986.26 101.79 468.62 164,253.00- 162,696.33- 346,495.63- 2,201.62- 1,752.71 50.00- 1,000.00 2,600.00 9,036.80 334,357.74- 1,518.16 1,179.09- 1,166.70- 479.63- 160,011.00- 7,394.28 ,179.09 -1,166.70-479.63- 160,011.00- 7,394.28 14,760.53 139,163.45- 636,217.52- 93.615 636,217.52- 93.615 636,217.52 - Page 3 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 9/2020 Amended Total Budget Encumb. 350,267.00 20,000.00 5,083.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 4,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Current Month Program: YTD Total % of Budget Remaining Budget 26,524.53 341,275.05 97.433 8,991.95 1,946.79 20,276.72 101.384 276.72- 5,082.50 99.990 .50 375.00 4,900.00 90.741 500.00 2,671.16 35,475.70 101.757 612.70- 4,818.49 59,350.91 70.383 24,975.09 316.63 3,640.80 77.054 1,084.20 48.18 562.90 73.390 204.10 259.41 3,732.46 90.331 399.54 1,760.42 22,763.02 97.495 584.98 411.70 5,323.58 97.484 137.42 43.42 945.60 87.556 134.40 771.51 8,846.19 74.651 3,003.81 234.90 58.725 165.10 20.25 87.07 29.023 212.93 Page 4 Subtotal: 546,839.00 552,002.00 39,967.49 512,497.40 92.843 39,504.60 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 75,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 30.60 10,357.55 55,261.26 73.682 19,738.74 847.00 28.233 2,153.00 305.44 6,002.77 120.055 1,002.77- 1,828.19 52.234 1,671.81 87.50 962.50 96.250 37.50 240.00 4,341.08 57.881 3,158.92 Subtotal: 140,000.00 95,000.00 30.60 10,990.49 69,242.80 72.887 25,757.20 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 5,500.00 125,677.00 1,000.00 500.00 2,500.00 400.00 500.00 1,500.00 30,000.00 2,299,249.00 200.00 3,000.00 14,750.00 527,381.00 36,800.00 180,000.00 816.05 5,333.74 96.977 166.26 13,289.42 131,998.49 105.030 6,321.49- 850.00 85.000 150.00 105.00 21.000 395.00 461.00 2,920.00 116.800 420.00- 400.00 500.00 1,500.00 25,705.74 85.686 4,294.26 1,865,023.83 81.114 434,225.17 200.00 636.00 1,392.00 46.400 1,608.00 6,000.00 40.678 8,750.00 527,381.14 100.000 .14- 36,800.00 100.000 180,000.00 273,063.28 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 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 Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Department: Adopted Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 9/2020 Amended Total Budget Encumb. 2,500.00 3,231,457.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 Current Month 288,265.75 978.24 1,568.40 695.00 Program: YTD Total 561.72 2,604,071.66 9,855.46 3,425.43 21,491.42 61,774.08 36,900.00 % of Budget 22.469 80.585 65.703 66.001 107.457 88.249 42.414 Remaining Budget 1,938.28 627,385.34 5,144.54 1,764.57 1,491.42- 1,200.00 1,000.00 8,225.92 50,100.00 Subtotal: 199,390.00 199,390.00 3,241.64 133,446.39 66.927 65,943.61 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: 135-70040-010-000 Subtotal: Program number: Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 772,475.00 30,512.00 3,231.00 75,000.00 102,077.00 983,295.00 5,061,144.00 32,038.00 400,899.00 432,937.00 30.60 775,402.37 455,188.45 30,512.00 3,230.00 475,899.00 102,077.11 1,066,906.56 1,220.00 1,220.00 4,387,384.81 58.926 100.000 99.969 634.532 100.000 108.503 86.688 317,286.55 1.00 400,899.00- .11- 83,611.56- 1,220.00- 1,220.00- 673,759.19 glbase_tbam skrolczyk Trophy Club MUD No.1 14:57 10/14/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,063,144.00 680.00 680.00 680.00 30.60 776,082.37 2,135.58 2,135.58 2,135.58 4,389,520.39 106.779 106.779 106.779 86.696 135.58- 135.58- 135.58- 673,623.61 Page 6 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 14:57 10/14/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 35,859.29 401,741.45 90.933 40,057.55 135-50010-020-000 Overtime 33,000.00 30,000.00 1,873.51 21,847.42 72.825 8,152.58 135-50016-020-000 Longevity 8,035.00 6,873.00 6,872.50 99.993 .50 135-50017-020-000 Certification 9,000.00 9,000.00 625.00 7,575.00 84.167 1,425.00 135-50020-020-000 Retirement 45,531.00 45,531.00 3,551.93 42,090.59 92.444 3,440.41 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 7,333.02 84,735.71 80.810 20,122.29 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 430.81 4,900.06 84.237 916.94 135-50028-020-000 Vision Insurance 948.00 948.00 69.78 784.38 82.741 163.62 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 358.99 4,490.62 99.792 9.38 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 2,276.52 25,696.64 84.268 4,797.36 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 532.44 6,009.69 84.264 1,122.31 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 43.01 1,072.51 85.120 187.49 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.17 12,652.86 82.306 2,720.14 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 357.00 89.250 43.00 135-50070-020-000 Employee Relations 300.00 300.00 58.62 104.70 34.900 195.30 Subtotal: 708,447.00 704,285.00 54,123.09 620,931.13 88.165 83,353.87 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 73,000.00 135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 25,000.00 135-55085-020-000 Generator Maint. and Repair 10,000.00 2,500.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 1,292.70 1,080.00 23,200.00 77.333 6,800.00 3,000.00 20.000 12,000.00 6,196.58 75,412.13 103.304 2,412.13- 8,460.00 27,259.49 109.038 2,259.49- 3,197.60 127.904 697.60- 1,203.20 30.080 2,796.80 2,173.37 27.167 5,826.63 404.40 1,470.61 49.020 1,529.39 87.50 962.50 64.167 537.50 7,641.50 91,387.32 91.387 8,612.68 2,915.25 37,204.77 93.012 2,795.23 Subtotal: 309,500.00 302,000.00 2,372.70 25,705.23 266,470.99 88.235 35,529.01 135-60010-020-000 Communications/Mobiles 5,000.00 5,500.00 958.75 5,716.02 103.928 216.02- 135-60020-020-000 Electricity 160,067.00 160,067.00 12,079.95 132,214.00 82.599 27,853.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 216.00 72.000 84.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 1,172.00 4,348.80 87.150 641.20 135-60090-020-000 Safety Program 1,000.00 1,000.00 109.14 10.914 890.86 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 410.72 26.584 1,134.28 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 10,088.02 67.253 4,911.98 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 2,618.47 52.369 2,381.53 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund Account 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Description 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 Fuel & Lube Uniforms Chemicals Chemicals Collections Small Tools Safety E uipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,310,669.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 9/2020 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 46,000.00 180,000.00 2,000.00 1,231,982.00 12,500.00 5,495.00 27,000.00 10,500.00 1,200.00 1,200.00 25,000.00 82,895.00 602,910.00 79,133.00 11,277.00 130,000.00 823,320.00 3,144,482.00 3,144,482.00 8,260.00 8,260.00 10,632.70 10,632.70 Current Month 14,210.70 687.18 224.20 2,546.50 153.79 3,611.67 17,203.25 400,899.00 418,102.25 515,752.94 515,752.94 Program: YTD Total 6,524.74 114,562.91 673,867.10 46,000.00 1,055.00 997,730.92 8,147.83 3,732.13 23,054.84 10,448.60 1,166.53 26,446.37 72,996.30 346,507.80 79,141.86 11,269.04 530,899.00 967,817.70 2,925,947.04 2,925,947.04 % of Budget Remaining Budget 46.605 7,475.26 100.000 .09 100.000 .10- 100.000 180,000.00 52.750 945.00 80.986 234,251.08 65.183 4,352.17 67.919 1,762.87 85.388 3,945.16 99.510 51.40 1,200.00 97.211 33.47 105.785 1,446.37- 88.059 9,898.70 57.473 256,402.20 100.011 8.86- 99.929 7.96 408.384 400,899.00- 117.551 144,497.70- 93.050 218,534.96 93.050 218,534.96 Page 8 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 14:57 10/14/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 500.00 500.00 500.00 3,700.00 3,730.00 3,730.00 1.96 23.85 1.96 23.85 247.98 247.98 249.94 249.94 675.00 1,033.76 1,708.76 1,732.61 1,732.61 79.500 Remaining Budget 6.15 79.500 6.15 90.000 79.520 46.183 46.451 46.451 150.00 75.00 266.24 500.00 500.00 500.00 1,991.24 1,997.39 1,997.39 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 14:57 10/14/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 628,298.00 475,000.00 2,000.00 2,000.00 2,208.00 2,208.00 58,554.00 42,000.00 124,394.00 81,000.00 6,464.00 4,500.00 1,035.00 1,035.00 4,500.00 4,500.00 39,215.00 26,000.00 9,171.00 6,200.00 1,440.00 1,440.00 1,775.00 1,775.00 500.00 500.00 8,000.00 4,000.00 42,441.87 426,344.38 89.757 48,655.62 4.00 50.32 2.516 1,949.68 2,207.50 99.977 .50 4,519.12 41,773.88 99.462 226.12 7,970.17 80,098.83 98.887 901.17 441.96 4,435.79 98.573 64.21 65.60 667.11 64.455 367.89 432.58 4,290.56 95.346 209.44 2,434.46 24,752.54 95.202 1,247.46 569.33 5,788.91 93.370 411.09 .01 1,008.01 70.001 431.99 104.88 1,178.12 66.373 596.88 500.00 61.96 3,140.06 78.502 859.94 Subtotal: 887,554.00 652,158.00 59,045.94 595,736.01 91.348 56,421.99 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 Cleaning Services Professional Outside Services Utility Billing Contract 134,681.00 154,681.00 135,000.00 100,000.00 15,000.00 30,000.00 10,000.00 10,000.00 10,000.00 15,000.00 65,600.00 65,600.00 9,000.00 9,000.00 17,363.78 114,440.54 73.985 40,240.46 255.00 90,481.07 90.481 9,518.93 7,489.07 18,316.71 61.056 11,683.29 1,169.00 11.690 8,831.00 1,896.92 15,246.32 101.642 246.32- 57,100.00 87.043 8,500.00 730.91 7,132.19 79.247 1,867.81 Subtotal: 379,281.00 384,281.00 27,735.68 303,885.83 79.079 80,395.17 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections Advertising 23,680.00 23,680.00 4,000.00 3,000.00 6,879.00 6,879.00 1,500.00 1,500.00 30,000.00 25,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 80,419.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 3,000.00 3,545.00 1,500.00 200.00 200.00 200.00 2,500.00 6,000.00 6,080.36 24,054.86 101.583 374.86- 194.17 2,784.22 92.807 215.78 472.51 5,773.58 83.931 1,105.42 296.15 1,944.54 129.636 444.54- 1,814.17 20,401.66 81.607 4,598.34 7,841.27 73,963.79 110.394 6,963.79- 16,874.26 16,874.26 1,124.951 15,374.26- 6,998.39 79,987.82 99.464 431.18 125.00 12.500 875.00 4,607.36 76.789 1,392.64 148.86 37.215 251.14 2,508.78- 1,875.09 31.252 4,124.91 865.00- 3,018.20 100.607 18.20- 1,204.97 80.331 295.03 200.00 138.04 69.020 61.96 2,000.00 6,111.80 101.863 111.80- glbase_tbam skrolczyk 14:57 10/14/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 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 9/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,288.00 500.00 17,000.00 2,500.00 1,288.00 500.00 17,000.00 2,500.00 264.00 2,026.99 20.497 81.080 1,024.00 500.00 17,000.00 473.01 Subtotal: 266,342.00 254,566.00 39,197.50 245,305.04 96.362 9,260.96 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 26,485.00 6,000.00 7,500.00 2,500.00 18,032.60 288.10 225.63 24,611.30 5,383.24 4,595.53 92.925 89.721 61.274 2,050.00 1,873.70 616.76 2,904.47 2,500.00 Subtotal: 44,535.00 44,535.00 18,546.33 34,590.07 77.669 9,944.93 135-69005-030-000 Capital Outlays 195,000.00 180,000.00 56,127.97 46,313.67 156,106.70 86.726 23,893.30 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 391.67 3,026.88 75.672 973.12 Subtotal: 199,000.00 184,000.00 56,127.97 46,705.34 159,133.58 86.486 24,866.42 Program number: 1,776,712.00 1,519,540.00 56,127.97 191,230.79 1,338,650.53 88.096 180,889.47 Department number: Administration 1,776,712.00 1,519,540.00 56,127.97 191,230.79 1,338,650.53 88.096 180,889.47 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund Account 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Description Legal Auditing,. Appraisal Tax Admin Fees Subtotal: Program number: Department number: Non Departmental Expenditures Subtotal Fund number: 135 MUD 1 General Fund Department: Adopted Budget 135,000.00 33,800.00 11,761.00 4,000.00 184,561.00 184,561.00 184,561.00 10,638,853.00 6,224.00 - Trophy Club MUD No.1 Budget Summary with Amendment 39 Non Departmental Period Ending: 9/2020 Amended Total Budget Encumb. 135,000.00 33,800.00 11,761.00 4,000.00 184,561.00 184,561.00 184,561.00 9,915,457.00 49,115.00- 66,791.27 66,791.27 Current Month 2,667.50 2,243.48 4,910.98 4,910.98 4,910.98 1,488,227.02 623,640.93 Program: YTD Total 105,897.89 31,907.72 11,909.00 3,756.00 153,470.61 153,470.61 153,470.61 8,809,321.18 519,033.30- % of Budget 78.443 94.402 101.258 93.900 83.154 83.154 83.154 88.844 1,056.771 Remaining Budget 29,102.11 1,892.28 148.00- 244.00 31,090.39 31,090.39 31,090.39 1,106,135.82 469,918.30 Page 12 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 9/2020 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 13 137-49145-000-000 1 137-49146-000-000 Intergov Transfer -General Fund Intergov Transfer -Fire Dept 801,798.00- 1,006,798.00- 81,420.00- 1,006,798.00 81,420.00 Subtotal: 801,798.00- 1,088,218.00- 1,088,218.00 Program number: 801,798.00- 1,088,218.00- 1,088,218.00 Department number: 801,798.00- 1,088,218.00- 1,088,218.00 Revenues Subtotal 801,798.00- 1,088,218.00- 1,088,218.00 Fund number: 137 MUD 1 Consolidated GASB 801,798.00- 1,088,218.00- 1,088,218.00 glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000-000 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 4 Check Source Number Property Taxes (135,817.58) (3.65) (135,821.23) (2.87) (135,824.10) (.05) (135,824.15) (16.11) (135,840.26) (17.00) (135,857.26) GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (39.68) (135,857.26) ** Account: 135-40002-000-000 1894 09/03/2020 Property Taxes 1896 09/16/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes Account: 135-40002-000-000 (134,871.00) Budgeted Property Taxes/Delinquent 986.26 Remaining 101 % Used Property Taxes/Delinquent Totals: (300.00) Budgeted 101.79 Remaining (383.44) (1.95) (13.95) (1.08) (1.37) 134 % Used (385.39) (399.34) (400.42) (401.79) (18.35) (401.79) ** GL GL GL GL Account: 135-40015-000-000 1894 09/03/2020 Property Taxes 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes Property Taxes/P & I (754.34) (.52) (.63) (3.02) (.01) (6.02) (3.72) (.36) (754.86) (755.49) (758.51) (758.52) (764.54) (768.26) (768.62) GL GL GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (768.62) ** (300.00) Budgeted 468.62 Remaining 256 % Used Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges Totals: (164,253.00) Budgeted Account: 135-47000-000-000 Water 1744 09/03/2020 UB 09/03/2020 WT adjustment (164,253.00) Remaining 0 % Used UB20200903-20200903 User: (5,097,662.77) .00 .00 767-' .00 ** 1 18.15 (5,097,644.62) UB glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description 1873 09/30/2020 UB 09/30/2020 Billing Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2020 Beginning Balance JE Detail Description/Comment UB20200930-20200930 User: (5,097,662.77) Account: 135-47000-000-000 Water (6,000,000.00) Budgeted Account: 135-47005-000-000 Sewer 1724 09/01/2020 UB 09/01/2020 WA Adjustment 1744 09/03/2020 UB 09/03/2020 WT adjustment 1873 09/30/2020 UB 09/30/2020 Billing Account: 135-47005-000-000 Account: 135-47025-000-000 1837 09/22/2020 UB 09/22/2020 1855 09/28/2020 UB 09/28/2020 1857 09/28/2020 UB 09/28/2020 1860 09/29/2020 UB 09/29/2020 1867 09/30/2020 UB 09/30/2020 Account: 135-47025-000-000 Sewer Totals: (346,495.63) Remaining UB20200901-20200901 User: UB20200903-20200903 User: UB20200930-20200930 User: (3,200,000.00) Budgeted Penalties UB20200922-20200922 User: UB20200928-20200928 User: UB20200928-20200928 User: UB20200929-20200929 User: UB20200930-20200930 User: Penalties Penalty Removal Penalty Removal Penalty removal Penalty removal Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) (555,859.75) (5,653,504.37) 94 % Used (2,914,168.72) Totals: (2,201.62) Remaining 100 % Used (51,056.43) Penalties (60,000.00) Budgeted 1,752.71 Remaining Account: 135-47030-000-000 Service Charges 1839 09/22/2020 UB 09/22/2020 NSF Check UB20200922-20200922 User: 1858 09/24/2020 UB 09/24/2020 NSF Check UB20200924-20200924 User: Account: 135-47030-000-000 Service Charges Totals: (10,000.00) Budgeted Account: 135-47035-000-000 Plumbing Inspections 1904 09/04/2020 Permits -6 sadie court 6 Sadie Court Account: 135-47035-000-000 (50.00) Remaining Plumbing Inspections Totals: (4,500.00) Budgeted 1,000.00 Remaining Account: 135-47045-000-000 Sewer Inspections 1904 09/04/2020 Permits -6 sadie court 6 Sadie Court 103 % Used (9,900.00) 100 % Used (5,450.00) 122 % Used (555,841.60) (5,653,504.37) ** 350.25 (2,913,818.47) 22.15 (2,913,796.32) (284,002.06) (3,197,798.38) (283,629.66) (3,197,798.38) ** (11,198.94) (62,255.37) 284.75 (61,970.62) 139.11 (61,831.51) 59.98 (61,771.53) 18.82 (61,752.71) (10,696.28) (61,752.71) ** (25.00) (25.00) (50.00) (50.00) (50.00) (9,925.00) (9,950.00) (9,950.00) ** (5,500.00) Drees Homes (5,500.00) ** Page 5 Check Source Number UB UB UB UB UB UB UB UB UB UB UB CR (4,950.00) (150.00) (5,100.00) Drees Homes CR glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 9/2020 JE Detail Description/Comment Page 6 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (5,100.00) ** (2,500.00) Budgeted 2,600.00 Remaining 204 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1873 09/30/2020 UB 09/30/2020 Billing UB20200930-20200930 User: (82,765.60) (6,271.20) (89,036.80) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (6,271.20) (89,036.80) ** (80,000.00) Budgeted Account: 135-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September 1880 09/30/2020 Bank Interest- September 1880 09/30/2020 Bank Interest- September 9,036.80 Remaining 111 % Used (78,179.31) (1,396.98) (79,576.29) GL (1,233.80) (80,810.09) GL (708.07) (81,518.16) GL Account: 135-49011-000-000 Interest Income Totals: (3,338.85) (81,518.16) ** (80,000.00) Budgeted 1,518.16 Remaining 102 % Used Account: 135-49016-000-000 Cell Tower Revenue 1823 09/21/2020 Cell Tower Rev AT&T (11,788.10) (1,178.81) (12,966.91) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (12,966.91) ** (14,146.00) Budgeted Account: 135-49018-000-000 Building Rent Income Account: 135-49018-000-000 Building Rent Income (7,000.00) Budgeted (1,179.09) Remaining 92 6 Used (5,833.30) .00 (5,833.30) Totals: ' .00 (5,833.30) ** (1,166.70) Remaining 83 6 Used Account: 135-49026-000-000 Proceeds from Sale of Assets 1821 09/21/2020 Scrap Metal Recycle- 09/11/20 Recycle Scrap Metal 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal Rev Move Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (13,000.00) Budgeted (479.63) Remaining Mih (8,925.00) (2,824.07) (11,749.07) GL (771.30) (12,520.37) GL (3,595.37) (12,520.37) ** 96 % Used Account: 135-49035-000-000 Prior Year Reserves glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 9/2020 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment .00 .00 Page 7 Check Source Number 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/06/20 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/07/20 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/14/20 1873 09/30/2020 UB 09/30/2020 Billing UB20200930-20200930 User: (36,401.52) 257.40 405.90 108.00 (130.31) (36,144.12) (35,738.22) (35,630.22) (35,760.53) GL GL GL UB Account: 135-49900-000-000 Miscellaneous Income Totals: 640.99 (35,760.53) ** Department Totals: (21,000.00) Budgeted 14,760.53 Remaining 170 % Used (864,586.09) Monthly Total (9,964,572.00) Budgeted (9,328,354.48) ** (636,217.52) Remaining 94 % Used Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (160,011.00) Budgeted (160,011.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1904 09/04/2020 Permits -6 sadie court 6 Sadie Court (19,732.28) (353.00) (20,085.28) Drees Homes CR Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (353.00) (20,085.28) ** (12,691.00) Budgeted 7,394.28 Remaining 158 % Used Account: 135-49900-000-000 Miscellaneous Income 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/06/20 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/07/20 1827 09/21/2020 Scrap Metal Rev Misc-Proc Asts Recycle Scrap Metal- 08/14/20 1873 09/30/2020 UB 09/30/2020 Billing UB20200930-20200930 User: (36,401.52) 257.40 405.90 108.00 (130.31) (36,144.12) (35,738.22) (35,630.22) (35,760.53) GL GL GL UB Account: 135-49900-000-000 Miscellaneous Income Totals: 640.99 (35,760.53) ** Department Totals: (21,000.00) Budgeted 14,760.53 Remaining 170 % Used (864,586.09) Monthly Total (9,964,572.00) Budgeted (9,328,354.48) ** (636,217.52) Remaining 94 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-000 1704 09/04/2020 MUD Payroll 9/4/2020 1794 09/18/2020 MUD Payroll 9/18/2020 Salaries & Wages Salaries & Wages Salaries & Wages 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Salaries & Wages 314,750.52 13,138.99 327,889.51 PR 13,326.96 341,216.47 PR 58.58 341,275.05 PR Account: 135-50005-010-000 Salaries & Wages Totals: 26,524.53 341,275.05 ** 350,267.00 Budgeted 8,991.95 Remaining 97 % Used Account: 135-50010-010-000 Overtime 1704 09/04/2020 MUD Payroll 9/4/2020 Overtime 18,329.93 1,048.57 19,378.50 PR 1794 09/18/2020 MUD Payroll 9/18/2020 Overtime 898.22 20,276.72 PR Account: 135-50010-010-000 Overtime Totals: 1,946.79 2011111/2 ** 20,000.00 Budgeted (276.72) Remaining 101 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 5,083.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-010-000 Certification 1794 09/18/2020 MUD Payroll 9/18/2020 Certification 4,525.00 375.00 4,900.00 PR Account: 135-50017-010-000 Certification Totals: 375.00 4,900.00 ** 5,400.00 Budgeted Account: 135-50020-010-000 Retirement 1704 09/04/2020 MUD Payroll 9/4/2020 Retirement 1794 09/18/2020 MUD Payroll 9/18/2020 Retirement 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Retirement 500.00 Remaining 91 % Used 32,804.54 1,313.76 34,118.30 PR 1,351.98 35,470.28 PR 5.42 35,475.70 PR Account: 135-50020-010-000 Retirement Totals: 2,671.16 35,475.70 ** 34,863.00 Budgeted Account: 135-50026-010-000 . Medical Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Medical Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Medical Insurance (612.70) Remaining 102 % Used 54,532.42 2,612.55 57,144.97 PR 2,612.49 59,757.46 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1906 09/30/2020 MUD Contribution Adj 09/2020 MUD Contribution Adjustment 54,532.42 (406.55) 59,350.91 GL Account: 135-50026-010-000 Medical Insurance Totals: 4,818.49 59,350.91 ** 84,326.00 Budgeted Account: 135-50027-010-000 Dental Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Dental Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Dental Insurance Account: 135-50027-010-000 24,975.09 Remaining 70 % Used 3,324.17 158.32 3,482.49 PR 158.31 3,640.80 PR Dental Insurance Totals: 316.63 3,640.80 ** 4,725.00 Budgeted Account: 135-50028-010-000 Vision Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Vision Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Vision Insurance 1,084.20 Remaining 77 % Used 514.72 24.10 538.82 24.08 562.90 Account: 135-50028-010-000 Vision Insurance Totals: 48.18 767.00 Budgeted 204.10 Remaining 73 % Used Account: 135-50029-010-000 Life Insurance & Other 1684 09/01/2020 September Payroll Benefits Employee Benefits 1684 09/01/2020 September Payroll Benefits Employee LTD & STD 1844 09/24/2020 September A/P Caf 125 plan 1888 09/30/2020 Payroll benefits Employee Benefits 1906 09/30/2020 MUD Contribution Adj 09/2020 MUD Contribution Adjustment Account: 135-50029-010-000 Life Insurance & Other Totals: 4,132.00 Budgeted PR PR 3,473.05 150.48 3,623.53 Humana Inc 6780 AP 122.48 3,746.01 METLIFE GROUP BENEFITS 6784 AP 20.00 3,766.01 BenefitMall 6826 AP 23.10 3,789.11 Humana Inc 6882 AP (56.65) 3,732.46 GL 399.54 Remaining 90 6 Used Account: 135-50030-010-000 , Social Security Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Social Security Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Social Security Taxes 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Social Security Taxes Account: 135-50030-010-000 259.41 3,732.46 ** 21,002.60 868.41 21,871.01 PR 888.38 22,759.39 PR 3.63 22,763.02 PR Social Security Taxes Totals: 1,760.42 22,763.02 23,348.00 Budgeted 584.98 Remaining 97 % Used Account: 135-50035-010-000 Medicare Taxes glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1704 09/04/2020 MUD Payroll 9/4/2020 Medicare Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Medicare Taxes 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Medicare Taxes 4,911.88 203.09 5,114.97 PR 207.76 5,322.73 PR .85 5,323.58 PR Account: 135-50035-010-000 Medicare Taxes Totals: 411.70 5,323.58 ** 5,461.00 Budgeted Account: 135-50040-010-000 Unemployment Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Unemployment Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Unemployment Taxes 137.42 Remaining 97 % Used 902.18 21.92 924.10 21.50 945.60 PR PR Account: 135-50040-010-000 Unemployment Taxes Totals: 43.42 945.60 ** 1,080.00 Budgeted Account: 135-50045-010-000 Workman's Compensation 77 09/01/2020 Insurance/Wrk Comp Expense Sep 134.40 Remaining 88 % Used 8,074.68 771.51 Account: 135-50045-010-000 Workman's Compensation Totals: 771.51 Account: 135-50060-010-000 11,850.00 Budgeted Pre-emp Physicals/Testing Account: 135-50060-010-000 3,003.81 Remaining Pre-emp Physicals/Testing Totals: 400.00 Budgeted 165.10 Remaining Account: 135-50070-010-000 Employee Relations 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 M.Chitty Anniversary plaque 234.90 75 6 Used 59 6 Used 8,846.19 8,846.19 ** .00 234.90 .00 234.90 ** 66.82 20.25 87.07 KELLER TROPHY & AWAR GL PC Account: 135-50070-010-000 Employee Relations Totals: 20.25 87.07 ** 300.00 Budgeted 212.93 Remaining 29 % Used Account: 135-55080-010-000 Maintenance & Repairs 1803 09/17/2020 September A/P Main Break 4 Narrow Creek Ct 1804 09/17/2020 Septmeber A/P couplings 1844 09/24/2020 September A/P parts 1844 09/24/2020 September A/P testing supplies 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 oil change 44,873.11 6,752.20 51,625.31 REY-MAR CONSTRUCTION 6816 AP 372.30 51,997.61 Core & Main LP 6799 AP 538.75 52,536.36 Core & Main LP 6829 AP 250.00 52,786.36 Core & Main LP 6829 AP 72.17 52,858.53 KWIK KAR LUBE & TUNE 0 PC glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE Date 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1871 09/30/2020 1871 09/30/2020 1886 09/30/2020 1914 09/30/2020 JE Description Pcards Pcards Pcards Pcards Pcards Pcards Pcards Pcards 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 September A/P September A/P September A/P September A/P Department: 10 Water JE Detail Description/Comment screws and nuts grates Grates screwdrivers refund for HCS HCS & Screws HCS Grade 8 yellow zin Refund Fire hydrant parts Bushings Bull heads valve risers Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 9/2020 Beginning Balance 44,873.11 Program: Transaction Detail 33.80 15.96 77.89 15.47 (28.49) 63.58 28.49 (63.39) 1,413.15 18.50 538.75 258.42 Transaction Vendor_Name Detail (SUBTOTAL) 52,892.33 52,908.29 52,986.18 53,001.65 52,973.16 53,036.74 53,065.23 53,001.84 54,414.99 54,433.49 54,972.24 55,230.66 ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 SITEONE LANDSCAPE SUPP TRACTOR SUPPLY COMPANY FASTENAL COMPANY 01TXA FASTENAL COMPANY 01TXA FASTENAL COMPANY 01TXA FASTSIGNS OF SOUTHLAEE Core & Main LP Core & Main LP Core & Main LP Core & Main LP Page 11 Check Source Number 6844 6844 6868 6884 PC PC PC PC PC PC PC PC AP AP AP AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 10,357.55 55,230.66 ** 75,000.00 Budgeted 19,769.34 Remaining 74 % Used Account: 135-55085-010-000 Generator Maint. and Repair 847.00 .00 847.00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 847.00 ** 3,000.00 Budgeted 2,153.00 Remaining 28 % Used Account: 135-55090-010-000 Vehicle Maintenance 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 tires 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 refund due to tax 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 tires 5,697.33 357.50 (859.06) 807.00 6,054.83 5,195.77 6,002.77 DISCOUNT TIRE TXD 75 DISCOUNT TIRE TXD 75 DISCOUNT TIRE TXD 75 PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 305.44 6,002.77 ** 5,000.00 Budgeted (1,002.77) Remaining 120 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,828.19 .00 1,828.19 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,828.19 ** 3,500.00 Budgeted 1,671.81 Remaining 52 % Used Account: 135-55120-010-000 Cleaning Services 1844 09/24/2020 September A/P Janitorial service -August 875.00 87.50 962.50 MEMBER'S BUILDING MAINTENANCE 6837 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-55120-010-000 Cleaning Services Totals: 87.50 962.50 ** 1,000.00 Budgeted Account: 135-55135-010-000 Lab Analysis 1803 09/17/2020 September A/P water samples 37.50 Remaining 96 % Used 4,101.08 240.00 4,341.08 TARRANT CTY PUBLIC HEALTH LAB 6817 AP Account: 135-55135-010-000 Lab Analysis Totals: 240.00 4,341.08 ** 7,500.00 Budgeted 3,158.92 Remaining 58 % Used Account: 135-60010-010-000 Communications/Mobiles 1803 09/17/2020 September A/P Cell phones -August 1803 09/17/2020 September A/P Cell phones -September 4,517.69 440.39 375.66 4,958.08 VERIZON WIRELESS 6823 AP 5,333.74 VERIZON WIRELESS 6823 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 816.05 5,333.74 ** 5,500.00 Budgeted 166.26 Remaining 97 % Used Account: 135-60020-010-000 Electricity 1808 09/17/2020 September A/P Electricity 8/10-9/9 118,709.07 13,289.42 131,998.49 HUDSON ENERGY SERVICES, LLC 6805 AP Account: 135-60020-010-000 Electricity Totals: 13,289.42 131,998.49 ** 125,677.00 Budgeted (6,321.49) Remaining 105 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 850.00 .00 850.00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 850.00 ** 1,000.00 Budgeted 150.00 Remaining 85 % Used Account: 135-60070-010-000 Dues & Memberships 105.00 .00 105.00 .00 105.00 ** Account: 135-60070-010-000 Dues & Memberships Totals: 500.00 Budgeted 395.00 Remaining 21 6 Used Account: 135-60080-010-000 Schools & Training 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 M. Chitty training 2,459.00 350.00 2,809.00 SUNCOAST LEARNING SYST PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 M. Hubbard license renewal 2,459.00 111.00 2,920.00 TCEQ IND RENEWAL LIC PC Account: 135-60080-010-000 Schools & Training Totals: 461.00 2,920.00 ** 2,500.00 Budgeted (420.00) Remaining 117 % Used Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 .00 .00 Safety Program Totals: .00 400.00 Budgeted 400.00 Remaining 0 % Used Travel & per diem .00 Travel & per diem Totals: 500.00 Budgeted 500.00 Remaining 0 % Used .00 Rent/Lease Equipment .00 Rent/Lease Equipment Totals: .00 1,500.00 Budgeted 1,500.00 Remaining 0 9 Used Account: 135-60135-010-000 Account: 135-60135-010-000 Account: 135-60150-010-000 1886 09/30/2020 September A/P TCEQ Fees & Permits 25,705.74 .00 TCEQ Fees & Permits Totals: .00 30,000.00 Budgeted 4,294.26 Remaining 86 % Used Wholesale Water Wholesale water 1,591,960.55 273,063.28 .00 ** .00 .00 ** .00 .00 ** 25,705.74 25,705.74 ** 1,865,023.83 CITY OF FORT WORTH 6867 AP Account: 135-60150-010-000 Wholesale Water Totals: 273,063.28 1,865,023.83 ** 2,299,249.00 Budgeted 434,225.17 Remaining 81 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60245-010-000 Trophy Club MUD No.1 Page 14 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 9/2020 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Miscellaneous Expenses Totals: 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 sand 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 sand & top soil Account: 135-60280-010-000 Account: 135-60285-010-000 Account: 135-60285-010-000 Account: 135-60332-010-000 Account: 135-60332-010-000 Account: 135-60333-010-000 Account: 135-60333-010-000 Account: 135-60334-010-000 Account: 135-60334-010-000 1 200.00 Remaining 0 % Used Property Maintenance Totals: 3,000.00 Budgeted .00 .00 ** 756.00 48.00 804.00 DENTON SAND & GRAVEL 588.00 1,392.00 DENTON SAND & GRAVEL 1,608.00 Remaining 46 % Used Lawn Equipment & Maintenance 636.00 1,392.00 ** 6,000.00 .00 6,000.00 Lawn Equipment & Maintenance Totals: .00 6,000.00 ** 14,750.00 Budgeted 8,750.00 Remaining 41 % Used Interfund Transfer Out -Rev I&S 527,381.14 Interfund Transfer Out -Rev I&S Totals: 527,381.00 Budgeted (.14) Remaining Interfund Transfer Out -Reserve Interfund Transfer Out -Reserve Totals: 36,800.00 Budgeted .00 Remaining Interfund Transfer Out Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 Furniture/Equipment < $5000 100 % Used 36,800.00 100 % Used 561.72 0 % Used .00 .00 .00 .00 .00 527,381.14 527,381.14 ** 36,800.00 36,800.00 ** .00 .00 .00 ** .00 561.72 PC PC glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 15 Check Source Number Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 561.72 ** 2,500.00 Budgeted 1,938.28 Remaining 22 % Used Account: 135-65005-010-000 Fuel & Lube 1868 09/24/2020 Fuel- September Fuel 8,877.22 978.24 9,855.46 US Bank Voyager Fleet Systems 6853 AP Account: 135-65005-010-000 Fuel & Lube Totals: 978.24 9,855.46 ** 15,000.00 Budgeted 5,144.54 Remaining 66 % Used Account: 135-65010-010-000 Uniforms 3,425.43 .00 3,425.43 Account: 135-65010-010-000 Uniforms Totals: .00 3,425.43 ** 5,190.00 Budgeted 1,764.57 Remaining 66 o Used Account: 135-65030-010-000 Chemicals 1844 09/24/2020 September A/P 1871 09/30/2020 September A/P meters chlorine 19,923.02 674.95 893.45 20,597.97 21,491.42 HACH COMPANY DPC INDUSTRIES, INC 6833 6845 AP AP Account: 135-65030-010-000 Chemicals Totals: 1,568.40 21,491.42 ** 20,000.00 Budgeted (1,491.42) Remaining 107 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 1844 09/24/2020 September A/P 1 1/2 meter 61,079.08 695.00 61,774.08 ATLAS UTILITY SUPPLY CO. 6825 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-65050-010-000 Meter Expense Totals: 695.00 61,774.08 ** 70,000.00 Budgeted 8,225.92 Remaining 88 8 Used Account: 135-65053-010-000 Meter Change Out Program 36,900.00 .00 36,900.00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 36,900.00 ** Account: 135-69005-010-000 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1891 09/30/2020 September A/P 87,000.00 Budgeted 50,100.00 Remaining Capital Outlays Pump head replacement chimney rock & carnoustie meadowbrook & sundance 1912 09/30/2020 Reclass Capital with departmen Reclass LS Upgrades AP 1912 09/30/2020 Reclass Capital with departmen Reclass JE 1473 42 8 Used 423,150.45 24,863.00 448,013.45 REY-MAR CONSTRUCTION 6816 AP 15,850.00 463,863.45 Halff Associates, INC 6832 AP 900.00 464,763.45 TEAGUE, NALL & PEREINS,INC 6878 AP (9,125.00) 455,638.45 GL (450.00) 455,188.45 GL Account: 135-69005-010-000 Capital Outlays Totals: 32,038.00 455,188.45 ** 772,475.00 Budgeted 317,286.55 Remaining 59 % Used Account: 135-69008-010-000 Short Term Debt -Principal Account: 135-69008-010-000 30,512.00 .00 30,512.00 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 3,230.00 .00 3,230.00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 3,230.00 ** 3,231.00 Budgeted 1.00 Remaining 100 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 1916 09/30/2020 GASB Reserve Reallication Water Reserve reallocation 75,000.00 400,899.00 475,899.00 GL Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 400,899.00 475,899.00 ** 75,000.00 Budgeted (400,899.00) Remaining 635 % Used glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 17 Check Source Number 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 ** 102,077.00 Budgeted (.11) Remaining 100 % 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 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 18 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/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 1803 09/17/2020 September A/P Lead & Copper PID 1803 09/17/2020 September A/P water samples 1,455.58 600.00 2,055.58 CITY OF FORT WORTH 6798 AP 80.00 2,135.58 TARRANT CTY PUBLIC HEALTH LAB 6817 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 680.00 2,135.58 ** 2,000.00 Budgeted (135.58) Remaining 107 % Used Department 10 Totals: 4,389,489.79 ** 776,082.37 Monthly Total 5,063,144.00 Budgeted 673,654.21 Remaining 87 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-020-000 Salaries & Wages 1704 09/04/2020 MUD Payroll 9/4/2020 Salaries & Wages 1794 09/18/2020 MUD Payroll 9/18/2020 Salaries & Wages Account: 135-50005-020-000 365,882.16 17,903.46 383,785.62 PR 17,955.83 401,741.45 PR Salaries & Wages Totals: 35,859.29 401,741.45 ** 441,799.00 Budgeted Account: 135-50010-020-000 Overtime 1704 09/04/2020 MUD Payroll 9/4/2020 Overtime 1794 09/18/2020 MUD Payroll 9/18/2020 Overtime 40,057.55 Remaining 91 % Used 19,973.91 786.47 20,760.38 PR 1,087.04 21,847.42 PR Account: 135-50010-020-000 Overtime Totals: 1,873.51 21,847.42 ** 30,000.00 Budgeted Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity Totals: 6,873.00 Budgeted .50 Remaining 8,152.58 Remaining 73 % Used Account: 135-50017-020-000 Certification 1794 09/18/2020 MUD Payroll 9/18/2020 Certification Account: 135-50017-020-000 Certification 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 1704 09/04/2020 MUD Payroll 9/4/2020 Retirement 1794 09/18/2020 MUD Payroll 9/18/2020 Retirement 6,872.50 100 % Used 6,950.00 Totals: 1,425.00 Remaining 84 % Used 38,538.66 .00 6,872.50 .00 6,872.50 ** 625.00 7,575.00 625.00 7,575.00 ** 1,730.69 40,269.35 1,821.24 42,090.59 PR PR PR Account: 135-50020-020-000 Retirement Totals: 3,551.93 42,090.59 ** 45,531.00 Budgeted 3,440.41 Remaining 92 % Used Account: 135-50026-020-000 Medical Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Medical Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Medical Insurance 1906 09/30/2020 MUD Contribution Adj 09/2020 MUD Contribution Adjustment 77,402.69 3,869.82 81,272.51 PR 3,869.76 85,142.27 PR (406.56) 84,735.71 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-50026-020-000 Medical Insurance Totals: 7,333.02 84,735.71 ** 104,858.00 Budgeted Account: 135-50027-020-000 Dental Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Dental Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Dental Insurance Account: 135-50027-020-000 20,122.29 Remaining 81 6 Used 4,469.25 215.42 4,684.67 PR 215.39 4,900.06 PR Dental Insurance Totals: 430.81 4,900.06 ** 5,817.00 Budgeted Account: 135-50028-020-000 Vision Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Vision Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Vision Insurance Account: 135-50028-020-000 916.94 Remaining 84 % Used Vision Insurance Totals: 948.00 Budgeted 714.60 34.89 749.49 PR 34.89 784.38 PR 163.62 Remaining 83 % Used Account: 135-50029-020-000 Life Insurance & Other 1684 09/01/2020 September Payroll Benefits Employee Benefits 1684 09/01/2020 September Payroll Benefits Employee LTD & STD 1844 09/24/2020 September A/P Caf 125 plan 1906 09/30/2020 MUD Contribution Adj 09/2020 MUD Contribution Adjustment Account: 135-50029-020-000 69.78 784.38 ** 1 4,131.63 209.88 4,341.51 Humana Inc 6780 AP 173.76 4,515.27 METLIFE GROUP BENEFITS 6784 AP 32.00 4,547.27 BenefitMall 6826 AP (56.65) 4,490.62 GL Life Insurance & Other Totals: 358.99 4,490.62 ** ' 4,500.00 Budgeted Account: 135-50030-020-000 Social Security Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Social Security Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Social Security Taxes Account: 135-50030-020-000 9.38 Remaining 100 % Used 1 23,420.12 1,126.32 24,546.44 PR 1,150.20 25,696.64 PR Social Security Taxes Totals: 2,276.52 25,696.64 ** 30,494.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Medicare Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Medicare Taxes 4,797.36 Remaining 84 % Used 5,477.25 263.44 5,740.69 PR 269.00 6,009.69 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-50035-020-000 Medicare Taxes Totals: 532.44 6,009.69 ** 7,132.00 Budgeted Account: 135-50040-020-000 Unemployment Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Unemployment Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Unemployment Taxes Account: 135-50040-020-000 1,122.31 Remaining 84 % Used 1,029.50 21.51 1,051.01 PR 21.50 1,072.51 PR Unemployment Taxes Totals: 43.01 1,072.51 ** 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 77 09/01/2020 Insurance/Wrk Comp Expense Sep Account: 135-50045-020-000 Account: 135-50060-020-000 Account: 135-50060-020-000 187.49 Remaining 85 % Used Workman's Compensation Totals: 11,542.69 1,110.17 15,373.00 Budgeted 2,720.14 Remaining 82 % Used Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 400.00 Budgeted 43.00 Remaining Account: 135-50070-020-000 Employee Relations 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 wind chime for L. Holt Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering 357.00 89 8 Used 12,652.86 GL 1,110.17 12,652.86 ** .00 357.00 .00 357.00 ** 46.08 58.62 104.70 AMZN MKTP US*MU2WO5R01 195.30 Remaining 35 8 Used 23,200.00 58.62 104.70 ** .00 23,200.00 Account: 135-55005-020-000 Engineering Totals: .00 23,200.00 ** 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor 6,800.00 Remaining 77 8 Used 3,000.00 .00 3,000.00 PC glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 22 Check Source Number Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 1803 09/17/2020 1803 09/17/2020 1803 09/17/2020 1844 09/24/2020 1845 09/24/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1871 09/30/2020 1917 09/30/2020 September A/P September A/P September A/P September A/P September A?P Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 September A/P September A/P change display gloves Panelview 800/Fine screens parts for fire screen main Electrical work for WWTP flashlight, fly swatters, tape pump cable hoses, bulbs, pvc, couplings pest control MBR -3 RAS pump rebuild 69,215.55 620.00 126.00 802.73 836.91 560.89 131.66 487.52 6.47 85.23 110.00 2,429.17 69,835.55 69,961.55 70,764.28 71,601.19 72,162.08 72,293.74 72,781.26 72,787.73 72,872.96 72,982.96 75,412.13 DHS AUTOMATION, INC LOU'S GLOVES INCORPORATED Huber Technology Inc ROANOKE WINNELSON CO. R & D Electric THE HOME DEPOT #6581 GRAINGER THE HOME DEPOT #6581 THE HOME DEPOT 6581 Exclusive Pest Control NORTH TEXAS PUMP CO. 6803 AP 6809 AP 6804 AP 6842 AP 6841 AP PC PC PC PC 6846 AP 6893 AP Account: 135-55080-020-000 1 Maintenance & Repairs Totals: 6,196.58 75,412.13 ** 73,000.00 Budgeted (2,412.13) Remaining 103 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 1803 09/17/2020 September A/P Sewer repair 219 Durango 18,799.49 8,460.00 27,259.49 REY-MAR CONSTRUCTION 6816 AP Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 8,460.00 27,259.49 ** 25,000.00 Budgeted (2,259.49) Remaining 109 o Used Account: 135-55085-020-000 Generator Maint. and Repair 3,197.60 .00 3,197.60 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 3,197.60 ** 2,500.00 Budgeted (697.60) Remaining 128 % Used Account: 135-55090-020-000 Vehicle Maintenance 1,203.20 .00 1,203.20 Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 1,203.20 ** 4,000.00 Budgeted 2,796.80 Remaining 30 % Used Account: 135-55091-020-000 Veh Maintenance Collections glpdatb2 skrolczyk 14:57 10/14/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 Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment 2,173.37 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 2,173.37 Page 23 Check Source Number 1803 09/17/2020 September A/P 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1871 09/30/2020 September A/P 1914 09/30/2020 September A/P sludge/grit sludge/grit sludge/grit sludge/grit sludge 82,453.12 2,246.26 2,080.10 1,159.40 1,071.36 1,084.38 84,699.38 L.H. CHANEY MATERIALS, INC. 86,779.48 L.H. CHANEY MATERIALS, INC. 87,938.88 L.H. CHANEY MATERIALS, INC. 89,010.24 L.H. CHANEY MATERIALS, INC. 90,094.62 L.H. CHANEY MATERIALS, INC. 6808 AP 6808 AP 6835 AP 6848 AP 6889 AP Account: 135-55125-020-000 Dumpster Services Totals: 7,641.50 90,094.62 ** 100,000.00 Budgeted 9,905.38 Remaining 90 % Used Account: 135-55135-020-000 Lab Analysis 1803 09/17/2020 September A/P 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1844 09/24/2020 September A/P 1871 09/30/2020 September A/P 1871 09/30/2020 September A/P 1886 09/30/2020 September A/P 1886 09/30/2020 September A/P 1915 09/30/2020 September A/P 1915 09/30/2020 September A/P Lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing 33,209.52 341.55 33,551.07 OXIDOR LABORATORIES LLC 241.50 33,792.57 OXIDOR LABORATORIES LLC 241.50 34,034.07 OXIDOR LABORATORIES LLC 341.55 34,375.62 OXIDOR LABORATORIES LLC 341.55 34,717.17 OXIDOR LABORATORIES LLC 241.50 34,958.67 OXIDOR LABORATORIES LLC 341.55 35,300.22 OXIDOR LABORATORIES LLC 241.50 35,541.72 OXIDOR LABORATORIES LLC 341.55 35,883.27 OXIDOR LABORATORIES LLC 241.50 36,124.77 OXIDOR LABORATORIES LLC 6815 AP 6815 AP 6839 AP 6839 AP 6850 AP 6850 AP 6871 AP 6871 AP 6894 AP 6894 AP Account: 135-55091-020-000 Veh Maintenance Collections Totals: .00 2,173.37 ** 8,000.00 Budgeted 5,826.63 Remaining 27 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1918 09/30/2020 September A/P Backhoe loader 1,066.21 404.40 1,470.61 RDO Equipment Co 6895 AP Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 404.40 1,470.61 ** 3,000.00 Budgeted 1,529.39 Remaining 49 % Used Account: 135-55120-020-000 Cleaning Services 1844 09/24/2020 September A/P Janitorial service -August 875.00 87.50 962.50 MEMBER'S BUILDING MAINTENANCE 6837 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 962.50 ** 1,500.00 Budgeted 537.50 Remaining 64 % Used Account: 135-55125-020-000 ' Dumpster Services 1803 09/17/2020 September A/P 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1871 09/30/2020 September A/P 1914 09/30/2020 September A/P sludge/grit sludge/grit sludge/grit sludge/grit sludge 82,453.12 2,246.26 2,080.10 1,159.40 1,071.36 1,084.38 84,699.38 L.H. CHANEY MATERIALS, INC. 86,779.48 L.H. CHANEY MATERIALS, INC. 87,938.88 L.H. CHANEY MATERIALS, INC. 89,010.24 L.H. CHANEY MATERIALS, INC. 90,094.62 L.H. CHANEY MATERIALS, INC. 6808 AP 6808 AP 6835 AP 6848 AP 6889 AP Account: 135-55125-020-000 Dumpster Services Totals: 7,641.50 90,094.62 ** 100,000.00 Budgeted 9,905.38 Remaining 90 % Used Account: 135-55135-020-000 Lab Analysis 1803 09/17/2020 September A/P 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1844 09/24/2020 September A/P 1871 09/30/2020 September A/P 1871 09/30/2020 September A/P 1886 09/30/2020 September A/P 1886 09/30/2020 September A/P 1915 09/30/2020 September A/P 1915 09/30/2020 September A/P Lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing 33,209.52 341.55 33,551.07 OXIDOR LABORATORIES LLC 241.50 33,792.57 OXIDOR LABORATORIES LLC 241.50 34,034.07 OXIDOR LABORATORIES LLC 341.55 34,375.62 OXIDOR LABORATORIES LLC 341.55 34,717.17 OXIDOR LABORATORIES LLC 241.50 34,958.67 OXIDOR LABORATORIES LLC 341.55 35,300.22 OXIDOR LABORATORIES LLC 241.50 35,541.72 OXIDOR LABORATORIES LLC 341.55 35,883.27 OXIDOR LABORATORIES LLC 241.50 36,124.77 OXIDOR LABORATORIES LLC 6815 AP 6815 AP 6839 AP 6839 AP 6850 AP 6850 AP 6871 AP 6871 AP 6894 AP 6894 AP glpdatb2 skrolczyk 14:57 10/14/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 Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 24 Check Source Number 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 P.Todd Training J.Jones training J.Jones license 475.00 475.00 111.00 3,762.80 TRAINING 4,237.80 TRAINING 4,348.80 TCEQ EPAYMENT PC PC PC Account: 135-55135-020-000 Lab Analysis Totals: 2,915.25 36,124.77 ** 40,000.00 Budgeted 3,875.23 Remaining 90 % Used Account: 135-60010-020-000 Communications/Mobiles 1803 09/17/2020 September A/P Cell phones -August 4,757.27 1803 09/17/2020 September A/P Cell phones -September 1828 09/21/2020 Reclass Verizon Exp Softw-Mobl Reclass Verizon Exp to 412.81 446.01 99.93 5,170.08 5,616.09 5,716.02 VERIZON WIRELESS VERIZON WIRELESS 6823 6823 AP AP GL Account: 135-60010-020-000 Communications/Mobiles Totals: 958.75 5,716.02 ** 5,500.00 Budgeted (216.02) Remaining 104 % Used Account: 135-60020-020-000 Electricity M' 1803 09/17/2020 September A/P electricity 07/29-8/27 120,134.05 1808 09/17/2020 September A/P Electricity 8/10-9/9 1889 09/30/2020 Town Billed Invoices 1754 AR 20200930-20200930 User: 570.83 11,681.46 (172.34) 120,704.88 132,386.34 132,214.00 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 6821 6805 AP AP AR Account: 135-60020-020-000 Electricity Totals: 12,079.95 132,214.00 ** 160,067.00 Budgeted 27,853.00 Remaining 83 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 5 Used Account: 135-60070-020-000 Dues & Memberships 216.00 .00 216.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 216.00 ** 300.00 Budgeted 84.00 Remaining 72 % Used Account: 135-60080-020-000 Schools & Training 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 F.Wolf License 3,176.80 111.00 3,287.80 TCEQ IND RENEWAL LIC PC 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 P.Todd Training J.Jones training J.Jones license 475.00 475.00 111.00 3,762.80 TRAINING 4,237.80 TRAINING 4,348.80 TCEQ EPAYMENT PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60080-020-000 Schools & Training Totals: 4,990.00 Budgeted Account: 135-60090-020-000 Safety Program Account: 135-60090-020-000 641.20 Remaining 87 % Used Safety Program Totals: 1,000.00 Budgeted Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 109.14 890.86 Remaining 11 % Used 410.72 1,172.00 4,348.80 ** .00 109.14 .00 109.14 ** .00 410.72 Travel & per diem Totals: .00 410.72 ** 1,545.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 1,134.28 Remaining 27 % Used Rent/Lease Equipment Totals: 5,000.00 Budgeted Account: 135-60125-020-000 Advertising Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 5,000.00 Remaining 0 % Used Advertising Totals: 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits Totals: 2,500.00 Remaining 0 % Used 15,000.00 Budgeted Miscellaneous Expenses 10,088.02 4,911.98 Remaining 67 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 10,088.02 .00 10,088.02 ** .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 Miscellaneous Expenses Totals: 450.00 Budgeted Account: 135-60280-020-000 Property Maintenance Account: 135-60280-020-000 Account: 135-60285-020-000 Account: 135-60285-020-000 450.00 Remaining 0 % Used .00 .00 ** 2,618.47 .00 2,618.47 Property Maintenance Totals: .00 2,618.47 ** 5,000.00 Budgeted 2,381.53 Remaining 52 % Used Lawn Equipment & Maintenance 6,524.74 .00 6,524.74 Lawn Equipment & Maintenance Totals: .00 6,524.74 ** 14,000.00 Budgeted 7,475.26 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS 114,562.91 47 % Used .00 114,562.91 Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS Totals: .00 114,562.91 ** 114,563.00 Budgeted .09 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev ISS 100 % Used 673,867.10 .00 673,867.10 Account: 135-60332-020-000 Interfund Transfer Out -Rev ISS Totals: .00 673,867.10 ** 673,867.00 Budgeted (.10) Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 46,000.00 .00 46,000.00 Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: .00 46,000.00 ** 46,000.00 Budgeted .00 Remaining Account: 135-60334-020-000 Interfund Transfer Out 100 % Used .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60334-020-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining 0 % Used .00 .00 ** Account: 135-60360-020-000 Furniture/Equipment < $5000 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 2,000.00 Budgeted 945.00 Remaining Account: 135-65005-020-000 1868 09/24/2020 Fuel- September Fuel & Lube Fuel 1,055.00 .00 1,055.00 .00 1,055.00 ** 53 % Used 7,460.65 687.18 8,147.83 US Bank Voyager Fleet Systems 6853 AP Account: 135-65005-020-000 Fuel & Lube Totals: 687.18 8,147.83 ** Account: 135-65010-020-000 1914 09/30/2020 September A/P 12,500.00 Budgeted Uniforms shirts 4,352.17 Remaining 65 % Used 3,507.93 224.20 3,732.13 Ritz Safety, LLC 6896 AP Account: 135-65010-020-000 Uniforms Totals: 224.20 3,732.13 ** 5,495.00 Budgeted 1,762.87 Remaining 68 % Used Account: 135-65030-020-000 Chemicals 1803 09/17/2020 September A/P CIP Solution and shipping 20,508.34 550.00 1803 09/17/2020 September A/P CIP Solution and shipping 30.00 1844 09/24/2020 September A/P Clarifloc C 1,966.50 21,058.34 Valley Solvent Company, INC 21,088.34 Valley Solvent Company, INC 23,054.84 POLYDYNE, INC 6822 AP 6822 AP 6840 AP Account: 135-65030-020-000 Chemicals Totals: 2,546.50 27,000.00 Budgeted 3,945.16 Remaining 85 % Used Account: 135-65031-020-000 Chemicals Collections 10,448.60 .00 10,448.60 Account: 135-65031-020-000 Chemicals Collections Totals: .00 10,448.60 ** 10,500.00 Budgeted Account: 135-65035-020-000 Small Tools 51.40 Remaining 100 % Used glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Detail .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 Page 28 Check Source Number 1844 09/24/2020 1844 09/24/2020 1891 09/30/2020 1912 09/30/2020 1912 09/30/2020 September A/P September A/P September A/P Reclass Capital with Reclass Capital with 1S access road capital outlays/share parts FOam system departmen Reclass LS Upgrades AP departmen Reclass JE 1473 321,044.55 550.00 5,022.00 2,056.25 9,125.00 450.00 321,594.55 326,616.55 328,672.80 337,797.80 338,247.80 Halff Associates, INC Dezurik Inc CP&Y/WALLACE GROUP, INC. 6832 6831 6877 AP AP AP GL GL Account: 135-69005-020-000 ' Capital Outlays Totals: 17,203.25 338,247.80 ** Account: 135-65035-020-000 Small Tools Totals: % Used .00 .00 ** 135-69008-020-000 Short Term Debt -Principal 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment .00 79,141.86 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 79,141.86 1,166.53 .00 1,166.53 (8.86) Remaining 100 % Used Account: 135-65040-020-000 Safety Equipment Totals: Account: 135-69009-020-000 .00 1,166.53 ** 1,200.00 Budgeted 33.47 Remaining 97 % Used 11,269.04 .00 11,269.04 Account: 135-65045-020-000 Lab Supplies 135-69009-020-000 Short Term Debt -Interest Totals: .00 11,269.04 ** 1844 09/24/2020 September A/P lab supplies 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 distilled water 11,277.00 Budgeted 26,292.58 100 148.84 4.95 26,441.42 26,446.37 HACH COMPANY TOM THUMB #1789 6833 AP PC Account: 135-65045-020-000 Lab Supplies Totals: 153.79 26,446.37 ** 25,000.00 Budgeted (1,446.37) Remaining 106 % Used Account: 135-69005-020-000 Capital Outlays 1844 09/24/2020 1844 09/24/2020 1891 09/30/2020 1912 09/30/2020 1912 09/30/2020 September A/P September A/P September A/P Reclass Capital with Reclass Capital with 1S access road capital outlays/share parts FOam system departmen Reclass LS Upgrades AP departmen Reclass JE 1473 321,044.55 550.00 5,022.00 2,056.25 9,125.00 450.00 321,594.55 326,616.55 328,672.80 337,797.80 338,247.80 Halff Associates, INC Dezurik Inc CP&Y/WALLACE GROUP, INC. 6832 6831 6877 AP AP AP GL GL Account: 135-69005-020-000 ' Capital Outlays Totals: 17,203.25 338,247.80 ** 602,910.00 Budgeted 264,662.20 Remaining 56 % Used Account: 135-69008-020-000 Short Term Debt -Principal 79,141.86 .00 79,141.86 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 79,141.86 ** 79,133.00 Budgeted (8.86) Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt -Interest 11,269.04 .00 11,269.04 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 11,269.04 ** 11,277.00 Budgeted 7.96 Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 1916 09/30/2020 GASB Reserve Reallication Wastewater Reserve reallocatio 130,000.00 400,899.00 530,899.00 GL Account: 135-69195-020-000 ' Gasb34/Reserve for Replacement Totals: 400,899.00 530,899.00 ** 130,000.00 Budgeted (400,899.00) Remaining 408 % Used Department 20 Totals: 2,915,314.34 ** 515,752.94 Monthly Total 3,144,482.00 Budgeted 229,167.66 Remaining 93 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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-50045-026-000 Workman's Compensation 77 09/01/2020 Insurance/Wrk Comp Expense Sep 21.89 1.96 23.85 GL Account: 135-50045-026-000 Workman's Compensation Totals: 1.96 23.85 ** Account: 135-60066-026-000 30.00 Budgeted Publications/Books/Subscripts 6.15 Remaining 80 % Used .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 Account: 135-60075-026-000 Meetings 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 virutal board meeting 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 Virtual Board meeting 75.00 Remaining 90 % Used 785.78 123.99 909.77 ZOOM.US PC 123.99 1,033.76 ZOOM.US PC Account: 135-60075-026-000 Meetings Totals: 247.98 1,033.76 ** 1,300.00 Budgeted Account: 135-60080-026-000 Schools & Training 266.24 Remaining 80 % Used .00 .00 Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 500.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 500.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 ** 500.00 Budgeted 500.00 Remaining 0 % Used Department 26 Totals: 1,732.61 ** 249.94 Monthly Total 3,730.00 Budgeted 1,997.39 Remaining 46 % Used glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 32 Check Source Number 1704 09/04/2020 MUD Payroll 9/4/2020 Retirement 1794 09/18/2020 MUD Payroll 9/18/2020 Retirement 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Retirement 1909 09/25/2020 September A/P July Adjustment made in Septem 37,254.76 1,957.99 1,961.64 10.85 588.64 39,212.75 41,174.39 41,185.24 41,773.88 TCDRS PR PR PR 6883 AP Account: 135-50020-030-000 Retirement Totals: 4,519.12 41,773.88 ** Account: 135-50005-030-000 Salaries & Wages 42,000.00 Budgeted 226.12 Remaining 99 % Used Account: 135-50026-030-000 1704 09/04/2020 MUD Payroll 9/4/2020 Salaries 1794 09/18/2020 MUD Payroll 9/18/2020 Salaries 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Salaries & Wages & Wages & Wages 383,902.51 21,140.77 21,183.92 117.18 405,043.28 426,227.20 426,344.38 PR PR PR Account: 135-50005-030-000 Salaries & Wages 9/4/2020 9/18/2020 Totals: 72,128.66 42,441.87 426,344.38 ** PR PR Account: 475,000.00 Budgeted r 48,655.62 Remaining 90 % Used 7,970.17 80,098.83 ** Account: 135-50010-030-000 Overtime 81,000.00 Budgeted 901.17 Remaining 99 % Used 1704 09/04/2020 MUD Payroll 9/4/2020 Overtime Dental Insurance 46.32 4.00 50.32 PR Account: 135-50010-030-000 Overtime 9/4/2020 Totals: 3,993.83 4.00 50.32 ** PR 2,000.00 Budgeted 1,949.68 Remaining 3 % 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 1704 09/04/2020 MUD Payroll 9/4/2020 Retirement 1794 09/18/2020 MUD Payroll 9/18/2020 Retirement 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Retirement 1909 09/25/2020 September A/P July Adjustment made in Septem 37,254.76 1,957.99 1,961.64 10.85 588.64 39,212.75 41,174.39 41,185.24 41,773.88 TCDRS PR PR PR 6883 AP Account: 135-50020-030-000 Retirement Totals: 4,519.12 41,773.88 ** 42,000.00 Budgeted 226.12 Remaining 99 % Used Account: 135-50026-030-000 Medical Insurance 1704 09/04/2020 MUD Payroll 1794 09/18/2020 MUD Payroll 9/4/2020 9/18/2020 Medical Insurance Medical Insurance 72,128.66 3,985.11 3,985.06 76,113.77 80,098.83 PR PR Account: 135-50026-030-000 r Medical Insurance Totals: 7,970.17 80,098.83 ** 81,000.00 Budgeted 901.17 Remaining 99 % Used Account: 135-50027-030-000 Dental Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Dental Insurance 3,993.83 220.99 4,214.82 PR glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1794 09/18/2020 MUD Payroll 9/18/2020 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment Dental Insurance 3,993.83 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 220.97 4,435.79 Page 33 Check Source Number PR Account: 135-50027-030-000 Dental Insurance Totals: 441.96 4,435.79 ** 4,500.00 Budgeted 64.21 Remaining 99 % Used Account: 135-50028-030-000 Vision Insurance 1704 09/04/2020 MUD Payroll 9/4/2020 Vision Insurance 1794 09/18/2020 MUD Payroll 9/18/2020 Vision Insurance 601.51 32.81 32.79 634.32 667.11 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 65.60 667.11 ** 1,035.00 Budgeted 367.89 Remaining 64 % Used Account: 135-50029-030-000 Life Insurance & Other 1684 09/01/2020 September Payroll Benefits Employee Benefits 1684 09/01/2020 September Payroll Benefits Employee LTD & 1844 09/24/2020 September A/P Caf 125 plan STD 3,857.98 209.22 207.36 16.00 4,067.20 4,274.56 4,290.56 Humana Inc METLIFE GROUP BENEFITS BenefitMall 6780 6784 6826 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 432.58 4,290.56 ** 4,500.00 Budgeted 209.44 Remaining 95 % Used Account: 135-50030-030-000 Social Security Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Social Security 1794 09/18/2020 MUD Payroll 9/18/2020 Social Security 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Social Security Taxes Taxes Taxes 22,318.08 1,214.13 1,213.06 7.27 23,532.21 24,745.27 24,752.54 PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,434.46 24,752.54 ** 26,000.00 Budgeted 1,247.46 Remaining 95 % Used Account: 135-50035-030-000 Medicare Taxes 1704 09/04/2020 MUD Payroll 9/4/2020 Medicare Taxes 1794 09/18/2020 MUD Payroll 9/18/2020 Medicare Taxes 1826 09/25/2020 MUD Payroll Anniversary9/25/20 Medicare Taxes 5,219.58 283.93 283.70 1.70 5,503.51 5,787.21 5,788.91 PR PR PR Account: 135-50035-030-000 ' Medicare Taxes Totals: 569.33 5,788.91 ** 6,200.00 Budgeted 411.09 Remaining 93 % Used Account: 135-50040-030-000 Unemployment Taxes ' 1907 09/30/2020 SUTA QTR Adjustment 1,008.00 .01 1,008.01 GL glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 9/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 34 Check Source Number 1803 09/17/2020 1828 09/21/2020 1828 09/21/2020 1844 09/24/2020 1844 09/24/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 September A/P Reclass Verizon Exp Softw-Mobl Reclass Verizon Exp Softw-Mobl September A/P September A/P Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Internet -September Reclass Verizon 06/09/2020 Reclass Verizon 07/14/2020 GIS support/development GIS asset locatiom Standard SSL Renewal Internet internet internet Adobe software 97,076.76 899.00 (49.63) (50.30) 3,945.90 12,240.00 159.98 43.01 64.52 74.52 36.78 97,975.76 97,926.13 97,875.83 101,821.73 114,061.73 114,221.71 114,264.72 114,329.24 114,403.76 114,440.54 Charter Communications Halff Associates, INC Halff Associates, INC DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS 6797 AP GL GL 6832 AP 6832 AP PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 17,363.78 114,440.54 ** 154,681.00 Budgeted 40,240.46 Remaining 74 % Used Account: 135-55070-030-000 Independent Labor Account: 135-50040-030-000 Unemployment Taxes Totals: .01 1,008.01 ** 1,440.00 Budgeted 431.99 Remaining 70 % Used Account: 135-50045-030-000 Workman's Compensation 77 09/01/2020 Insurance/Wrk Comp Expense Sep 1,073.24 104.88 1,178.12 GL Account: 135-50045-030-000 Workman's Compensation Totals: 104.88 1,178.12 ** 1,775.00 Budgeted 596.88 Remaining 66 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 L.Slaght anniversary plaque 3,078.10 61.96 3,140.06 KELLER TROPHY & AWAR PC Account: 135-50070-030-000 Employee Relations Totals: 61.96 3,140.06 ** 4,000.00 Budgeted 859.94 Remaining 79 % Used Account: 135-55030-030-000 Software & Support 1803 09/17/2020 1828 09/21/2020 1828 09/21/2020 1844 09/24/2020 1844 09/24/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 September A/P Reclass Verizon Exp Softw-Mobl Reclass Verizon Exp Softw-Mobl September A/P September A/P Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Internet -September Reclass Verizon 06/09/2020 Reclass Verizon 07/14/2020 GIS support/development GIS asset locatiom Standard SSL Renewal Internet internet internet Adobe software 97,076.76 899.00 (49.63) (50.30) 3,945.90 12,240.00 159.98 43.01 64.52 74.52 36.78 97,975.76 97,926.13 97,875.83 101,821.73 114,061.73 114,221.71 114,264.72 114,329.24 114,403.76 114,440.54 Charter Communications Halff Associates, INC Halff Associates, INC DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS 6797 AP GL GL 6832 AP 6832 AP PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 17,363.78 114,440.54 ** 154,681.00 Budgeted 40,240.46 Remaining 74 % Used Account: 135-55070-030-000 Independent Labor glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1871 09/30/2020 September A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment boardroom meetings FY 2020 -Oct 90,226.07 Program: Transaction Detail 255.00 Transaction Vendor_Name Detail (SUBTOTAL) 90,481.07 MIGUEL CRUZ Page 35 Check Source Number 6849 AP Account: 135-55070-030-000 Independent Labor Totals: 255.00 90,481.07 ** 100,000.00 Budgeted 9,518.93 Remaining 90 % Used Account: 135-55080-030-000 Maintenance & Repairs 1803 09/17/2020 1803 09/17/2020 1844 09/24/2020 1844 09/24/2020 1883 09/28/2020 1871 09/30/2020 1886 09/30/2020 1914 09/30/2020 September A/P September A/P September A/P September A/P Pcards 8/27/2020-9/28/2020 September A/P September A/P September A/P Building rekey annex front door decals office a/c office lights super glue, repair kit, lever quarterly pest control -admin b office A/C repair Boardroom upgrade 6 admin bldg 10,827.64 226.40 11,054.04 75.00 11,129.04 360.00 11,489.04 896.00 12,385.04 47.67 12,432.71 125.00 12,557.71 3,380.00 15,937.71 2,379.00 18,316.71 MICHAEL'S KEYS INC. M-KAM LTD. BRANDON R REED R & D Electric THE HOME DEPOT #6581 Exclusive Pest Control BRANDON R REED Hardys Painting 6813 AP 6810 AP 6827 AP 6841 AP PC 6846 AP 6866 AP 6887 AP Account: 135-55080-030-000 _ Maintenance & Repairs Totals: 7,489.07 18,316.71 ** 30,000.00 Budgeted 11,683.29 Remaining 61 % Used Account: 135-55085-030-000 Generator Maint. and Repair 1,169.00 .00 1,169.00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 1,169.00 ** 10,000.00 Budgeted 8,831.00 Remaining 12 % Used Account: 135-55120-030-000 Cleaning Services 1844 09/24/2020 September A/P Janitorial service -August 13,349.40 1,896.92 15,246.32 MEMBER'S BUILDING MAINTENANCE 6837 AP Account: 135-55120-030-000 Cleaning Services Totals: 1,896.92 15,246.32 ** 15,000.00 Budgeted (246.32) Remaining 102 % Used Account: 135-55160-030-000 Professional Outside Services 57,100.00 .00 57,100.00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,100.00 ** 65,600.00 Budgeted 8,500.00 Remaining 87 % Used Account: 135-55205-030-000 Utility Billing Contract 1914 09/30/2020 September A/P September water bills 6,401.28 730.91 7,132.19 DATAPROSE LLC 6885 AP glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 36 Check Source Number Account: 135-55205-030-000 Utility Billing Contract Totals: 730.91 7,132.19 ** 9,000.00 Budgeted 1,867.81 Remaining 79 % Used Account: 135-60005-030-000 Telephone 1632 09/01/2020 1803 09/17/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 September A/P September A/P Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Pcards 8/27/2020-9/28/2020 Answering service -sept Phone deployment/setup phone phone phone Answering Service Phone System, will be refunded Phone System Implementation Phone System 17,974.50 214.75 3,000.00 179.28 807.64 476.31 16.76 34.65 1,316.32 34.65 18,189.25 21,189.25 21,368.53 22,176.17 22,652.48 22,669.24 22,703.89 24,020.21 24,054.86 KEYSTONE PARK SECRETARIAL M3 Networks ATT*BILL PAYMENT ATT*BUS PHONE PMT ATT*BUS PHONE PMT RINGCENTRAL, INC 8X8, INC. 8X8, INC. 8X8, INC. 6706 AP 6811 AP PC PC PC PC PC PC PC Account: 135-60005-030-000 ■ ' Telephone Totals: . 6,080.36 24,054.86 ** 23,680.00 Budgeted (374.86) Remaining 102 % Used Account: 135-60010-030-000 MEM Communications/Mobiles 1803 09/17/2020 September A/P 1794 09/18/2020 MUD Payroll 9/18/2020 Cell phones -August Communications/Mobiles 2,590.05 (30.83) 225.00 2,559.22 2,784.22 VERIZON WIRELESS 6823 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 194.17 2,784.22 ** 3,000.00 Budgeted 215.78 Remaining 93 % Used Account: 135-60020-030-000 Electricity/Gas 1871 09/30/2020 September A/P gexa energy 7/10-8/10 5,301.07 472.51 5,773.58 TOWN OF TROPHY CLUB 6852 AP Account: 135-60020-030-000 Electricity/Gas ' Totals: 472.51 5,773.58 ** 6,879.00 Budgeted 1,105.42 Remaining 84 % Used Account: 135-60025-030-000 Water • 1886 09/30/2020 September A/P water -September 1,648.39 296.15 1,944.54 TROPHY CLUB MUD (WATER BILLS) 6873 AP Account: 135-60025-030-000 Water Totals: 296.15 1,944.54 ** 1,500.00 Budgeted (444.54) Remaining 130 % Used Account: 135-60035-030-000 Postage glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 postage 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 postage 1914 09/30/2020 September A/P September water bills Account: 135-60035-030-000 1 Account: 135-60040-030-000 1882 09/30/2020 Pace Credit Card Fees 1882 09/30/2020 Pace Credit Card Fees 1886 09/30/2020 September A/P 1917 09/30/2020 September A/P Postage 25,000.00 Budgeted Service Charges & Fees 18,587.49 124.78 18,712.27 FP MAILING SOLUTIONS PC 33.54 18,745.81 FEDEX 95319966 PC 1,655.85 20,401.66 DATAPROSE LLC 6885 AP Totals: 4,598.34 Remaining 82 % Used Dig Tess -sept Direct send fees -Sept 1,814.17 20,401.66 ** 66,122.52 7,497.54 73,620.06 GL 54.33 73,674.39 GL 239.40 73,913.79 Texas Excavation Safety System 6872 AP 50.00 73,963.79 Fisery Solutions, LLC 6886 AP Account: 135-60040-030-000 Service Charges & Fees Totals: 7,841.27 73,963.79 ** 67,000.00 Budgeted (6,963.79) Remaining 110 % Used Account: 135-60050-030-000 Bad Debt Expe 1884 09/30/2020 FY 20 Write offs UB20200930-20200930 User: 16,874.26 16,874.26 UB Account: 135-60050-030-000 Bad Debt Expense Totals: 16,874.26 16,874.26 ** 1,500.00 Budgeted (15,374.26) Remaining 1.125 % Used Account: 135-60055-030-000 Insurance 77 09/01/2020 Insurance/Wrk Comp Expense Sep 72,989.43 6,998.39 79,987.82 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 79,987.82 ** 80,419.00 Budgeted 431.18 Remaining 99 % Used Account: 135-60066-030-000 Publications/Books/Subscripts Account: 135-60066-030-000 Account: 135-60070-030-000 Account: 135-60070-030-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 875.00 Remaining Dues & Memberships Dues & Memberships 6,000.00 Budgeted Totals: 1,392.64 Remaining 125.00 4,607.36 13 6 Used 77 % Used .00 125.00 .00 125.00 ** .00 4,607.36 .00 4,607.36 ** glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 38 Check Source Number Account: 135-60075-030-000 Meetings 148.86 .00 148.86 Account: 135-60075-030-000 Meetings Totals: .00 148.86 ** 400.00 Budgeted 251.14 Remaining 37 % Used Account: 135-60079-030-000 Public Education 1912 09/30/2020 Reclass Capital with departmen Reclass from public edu to Cap 4,383.87 (2,508.78) 1,875.09 GL Account: 135-60079-030-000 Public Education Totals: (2,508.78) 1,875.09 ** 6,000.00 Budgeted 4,124.91 Remaining 31 % Used Account: 135-60080-030-000 Schools & Training 1883 09/28/2020 Pcards 1883 09/28/2020 Pcards 8/27/2020-9/28/2020 cancelled training 8/27/2020-9/28/2020 Cancelled training 3,883.20 (440.00) (425.00) 3,443.20 3,018.20 TEEX ECOMMERCE TEEX ECOMMERCE PC PC Account: 135-60080-030-000 Schools & Training Totals: (865.00) 3,018.20 ** 3,000.00 Budgeted (18.20) Remaining 101 % Used Account: 135-60100-030-000 Travel & per diem 1,204.97 .00 1,204.97 Account: 135-60100-030-000 Travel & per diem Totals: .00 1,204.97 ** 1,500.00 Budgeted 295.03 Remaining 80 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 138.04 .00 138.04 Account: 135-60115-030-000 Elections Totals: .00 138.04 ** 200.00 Budgeted 61.96 Remaining 69 % Used Account: 135-60125-030-000 Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1917 09/30/2020 September A/P Public Tax Hearing notice Account: 135-60125-030-000 Account: 135-60235-030-000 Account: 135-60235-030-000 4,111.80 2,000.00 6,111.80 Star -Telegram Media 6897 AP Advertising Totals: 2,000.00 6,111.80 ** 6,000.00 Budgeted Security (111.80) Remaining 102 % Used 264.00 .00 264.00 Security Totals: .00 264.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 Account: 135-60246-030-000 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 1,024.00 Remaining 20 % Used Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 473.01 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted Account: 135-65055-030-000 Hardware 1915 09/30/2020 September A/P SAN warranty 2,026.99 0 o Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 2,026.99 �00 81 % Used 2,050.00 Remaining 0 8 Used 2,026.99 ** .00 .00 6,578.70 3,589.00 .00 ** 10,167.70 M3 Networks 6890 AP glpdatb2 skrolczyk 14:57 10/14/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1918 09/30/2020 September A/P 1918 09/30/2020 September A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment Server replacement 1 & 2 Server replacement 1 & 2 6,578.70 Program: Transaction Detail 11,443.60 3,000.00 Transaction Vendor_Name Detail (SUBTOTAL) 21,611.30 M3 Networks 24,611.30 M3 Networks Page 40 Check Source Number 6890 AP 6890 AP Account: 135-65055-030-000 Hardware Totals: 18,032.60 24,611.30 ** 26,485.00 Budgeted 1,873.70 Remaining 93 % Used Account: 135-65085-030-000 Office Supplies 1803 09/17/2020 September A/P 1844 09/24/2020 September A/P 1886 09/30/2020 September A/P 1886 09/30/2020 September A/P 1886 09/30/2020 September A/P breakroom/office supplies office supplies office supplies office supplies office supplies 5,095.14 85.65 160.46 (85.65) 110.78 16.86 5,180.79 5,341.25 5,255.60 5,366.38 5,383.24 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 6814 6838 6870 6870 6870 AP AP AP AP AP Account: 135-65085-030-000 Office Supplies Totals: 288.10 5,383.24 ** 6,000.00 Budgeted 616.76 Remaining 90 % Used Account: 135-65095-030-000 Maintenance Supplies 1803 09/17/2020 1824 09/21/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 1883 09/28/2020 September A/P Refund Pcard Purch Aug Walmart Pcards 8/27/2020-9/28/2020 Pcards Pcards Pcards Pcards Pcards Pcards Pcards Pcards Pcards Pcards Pcards 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 8/27/2020-9/28/2020 breakroom/office supplies Refund Pcard Purc WalMt Nicole water, paper towels, pinesol, toilet paper sanitizing wipes coffee coffee creamer coffee clorox wipes, sympathy card insect repellant coffee Water, Detergent, paper towels soap and hand wipes hand towels 4,369.90 45.44 (124.69) 50.61 19.98 3.78 28.72 11.69 28.72 9.23 25.59 41.04 46.34 20.80 18.38 4,415.34 OFFICE DEPOT, INC 4,290.65 4,341.26 SAMSCLUB.COM 4,361.24 SAMS CLUB #4795 4,365.02 TARGET 00008763 4,393.74 AMAZON.COM*MU46R4RC2 4,405.43 AMAZON.COM*MU2EP8QO0 4,434.15 AMAZON.COM*MU3IE2U62 4,443.38 WM SUPERCENTER #5247 4,468.97 WALMART.COM AX 4,510.01 AMAZON.COM*MU5RH6K01 4,556.35 SAMSCLUB.COM 4,577.15 WAL-MART #0266 4,595.53 SAMSCLUB #4795 6814 AP GL PC PC PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 ■ Maintenance Supplies Totals: 225.63 4,595.53 ** 7,500.00 Budgeted 2,904.47 Remaining 61 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 41 Check Source Number Account: 135-69005-030-000 Capital Outlays 1844 09/24/2020 September A/P MUD boundary 1912 09/30/2020 Reclass Capital with departmen Reclass from public edu to Cap 1914 09/30/2020 September A/P Boardroom upgrade & admin bldg 1914 09/30/2020 September A/P Boardroom AV upgrades 53,665.06 1,107.52 2,508.78 1,630.00 41,067.37 54,772.58 Halff Associates, INC 57,281.36 58,911.36 Hardys Painting 99,978.73 VIDEOTEX SYSTEMS INC. 6832 AP GL 6887 AP 6899 AP Department 30 Totals: 191,230.79 Monthly Total 1,519,540.00 Budgeted 1,282,522.56 ** 237,017.44 Remaining 84 % Used Account: 135-69005-030-000 Capital Outlays Totals: 46,313.67 99,978.73 ** 180,000.00 Budgeted 80,021.27 Remaining 56 % Used Account: 135-69170-030-000 Copier Lease Installments 1803 09/17/2020 1917 09/30/2020 September A/P September A/P copier lease -sept New copier lease 2,635.21 165.00 226.67 2,800.21 3,026.88 TIAA COMMERCIAL FINANCE NDS Leasing 6820 6892 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 391.67 3,026.88 ** 4,000.00 Budgeted 973.12 Remaining 76 % Used Department 30 Totals: 191,230.79 Monthly Total 1,519,540.00 Budgeted 1,282,522.56 ** 237,017.44 Remaining 84 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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-55045-039-000 1886 09/30/2020 September A/P 1915 09/30/2020 September A/P ' Legal Westlake easement legal legal 103,230.39 1,367.50 1,300.00 104,597.89 WHITAKER CHALK SWINDLE 6874 AP 105,897.89 McLean & Howard, L.L.P. 6891 AP Account: 135-55045-039-000 Legal Totals: 2,667.50 105,897.89 ** 135,000.00 Budgeted 29,102.11 Remaining 78 % Used Account: 135-55055-039-000 Auditing 31,907.72 .00 31,907.72 Account: 135-55055-039-000 Auditing Totals: .00 31,907.72 ** 33,800.00 Budgeted 1,892.28 Remaining 94 % Used Account: 135-55060-039-000 Appraisal 1803 09/17/2020 September A/P 4th QTR 2020 appraisel 9,665.52 2,243.48 11,909.00 DENTON CENTRAL APPRAISAL DISTR 6802 AP Account: 135-55060-039-000 Appraisal Totals: 2,243.48 11,909.00 ** 11,761.00 Budgeted (148.00) Remaining 101 % 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 ** 4,000.00 Budgeted 244.00 Remaining 94 % Used Department 39 Totals: 153,470.61 ** 4,910.98 Monthly Total 184,561.00 Budgeted 31,090.39 Remaining 83 % Used Fund 135 Totals: (585,824.57) 623,640.93 Monthly Total (49,115.00) Budgeted 536,709.57 Remaining NNNNNNNNNN glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer -General Fund 1916 09/30/2020 GASB Reserve Reallication Water Reserve reallocation 1916 09/30/2020 GASB Reserve Reallication Wastewater Reserve reallocatio (205,000.00) (400,899.00) (605,899.00) GL (400,899.00) (1,006,798.00) GL Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: (801,798.00) (1,006,798.00) ** .00 Budgeted 1,006,798.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept Account: 137-49146-000-000 J (81,420.00) Intergov Transfer -Fire Dept Totals: .00 Budgeted 81,420.00 Remaining 0 % Used .00 (81,420.00) .00 (81,420.00) ** Department Totals: (1,088,218.00) ** (801,798.00) Monthly Total .00 Budgeted 1,088,218.00 Remaining 0 % Used Fund 137 Totals: (1,088,218.00) (801,798.00) Monthly Total .00 Budgeted 1,088,218.00 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 492,391 TOTAL ASSETS 492,391 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 689,181 TOTAL LIABILITIES 689,181 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (78,380) TOTAL FUND BALANCE (196,790) TOTAL LIABILITIES AND FUND BALANCE 492,391 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 9/2020 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 14 517-49011-000-000 Interest Income 59.66- 5,124.38- 5,124.38 Subtotal: 59.66- 5,124.38- 5,124.38 Program number: 59.66- 5,124.38- 5,124.38 Department number: Revenues 59.66- 5,124.38- 5,124.38 Revenues Subtotal 59.66- 5,124.38- 5,124.38 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 9/2020 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 15 517-69005-020-000 Capital Outlays 3,705.00 83,505.16 83,505.16 - Subtotal: 3,705.00 83,505.16 83,505.16 - Program number: 3,705.00 83,505.16 83,505.16 - Department number: Wastewater 3,705.00 83,505.16 83,505.16 - Expenditures Subtotal 3,705.00 83,505.16 83,505.16 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 3,645.34 78,380.78 78,380.78- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/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-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (5,064.72) Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 5,124.38 Remaining 0 % Used (59.66) (5,124.38) GL (59.66) (5,124.38) ** Department Totals: (5,124.38) ** (59.66) Monthly Total .00 Budgeted 5,124.38 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/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-020-000 Capital Outlays 1886 09/30/2020 September A/P crane engineering 1886 09/30/2020 September A/P WWTP legal 79,800.16 2,685.00 1,020.00 82,485.16 Wiss, Janney, Elstner Assoc 6875 AP 83,505.16 Dubois Bryant Campbell LLP 6869 AP Account: 517-69005-020-000 Capital Outlays Totals: 3,705.00 83,505.16 ** .00 Budgeted (83,505.16) Remaining 0 % Used Department 20 Totals: 83,505.16 ** 3,705.00 Monthly Total .00 Budgeted (83,505.16) Remaining 0 % Used Fund 517 Totals: 78,380.78 3,645.34 Monthly Total .00 Budgeted (78,380.78) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,967 TOTAL ASSETS 784,967 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,628 703,276 784,967 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 14:57 10/14/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49011-000-000 Interest Income 6.67- 4,628.16- 4,628.16 Subtotal: 6.67- 4,628.16- 4,628.16 Program number: 6.67- 4,628.16- 4,628.16 Department number: Revenues 6.67- 4,628.16- 4,628.16 Revenues Subtotal 6.67- 4,628.16- 4,628.16 Fund number: 519 2016 Rev Bond Const -SWIFT 6.67- 4,628.16- 4,628.16 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (4,621.49) (6.67) (4,628.16) GL Account: 519-49011-000-000 Interest Income Totals: (6.67) (4,628.16) ** .00 Budgeted 4,628.16 Remaining 0 % Used Department Totals: (4,628.16) ** (6.67) Monthly Total .00 Budgeted 4,628.16 Remaining 0 % Used Fund 519 Totals: (4,628.16) (6.67) Monthly Total .00 Budgeted 4,628.16 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET SEPTEMBER 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 269,721 INVESTMENTS 3,892,525 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,162,246 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 3,895 TOTAL LIABILITIES 3,895 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (295,939) TOTAL FUND BALANCE 4,158,351 TOTAL LIABILITIES AND FUND BALANCE 4,162,246 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 520 Revenue Bond 16" Waterline Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 9/2020 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 17 520-49011-000-000 Interest Income 66.81- 27,922.58- 27,922.58 Subtotal: 66.81- 27,922.58- 27,922.58 Program number: 66.81- 27,922.58- 27,922.58 Department number: 66.81- 27,922.58- 27,922.58 Revenues Subtotal 66.81- 27,922.58- 27,922.58 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 14:57 10/14/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Subtotal: Program number: Department number: Expenditures Capital Outlays Water Department Subtotal Fund number: 520 Revenue Bond 16" Waterline 13,258.87 323,861.49 13,258.87 323,861.49 13,258.87 323,861.49 13,258.87 323,861.49 13,258.87 323,861.49 13,192.06 295,938.91 323,861.49- 323,861.49- 323,861.49- 323,861.49- 323,861.49- 295,938.91- glpdatb2 skrolczyk 14:57 10/14/20 Fund: 520 Revenue Bond 16" waterline JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 47 Period Ending: 9/2020 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (27,855.77) 1880 09/30/2020 Bank Interest- September (33.75) (27,889.52) GL (33.06) (27,922.58) GL Account: 520-49011-000-000 Interest Income Totals: (66.81) (27,922.58) ** Department Totals: .00 Budgeted 27,922.58 Remaining 0 % Used (66.81) Monthly Total .00 Budgeted (27,922.58) ** 27,922.58 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 1844 09/24/2020 September A/P 16" water line agreement 1919 09/30/2020 September A/P 310,602.62 9,363.57 Easement Acquisition Legal 3,895.30 319,966.19 Ralff Associates, INC 6832 AP 323,861.49 Jackson Walker LLP 6888 AP Account: 520-69005-010-000 Capital Outlays Totals: 13,258.87 323,861.49 ** Department 10 Totals: Fund 520 Totals: .00 Budgeted 13,258.87 Monthly Total 13,192.06 Monthly Total (323,661.49) Remaining 0 % Used 323,861.49 ** .00 Budgeted (323,861.49) Remaining 0 % Used 295,938.91 .00 Budgeted (295,938.91) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,867 TOTAL ASSETS 893,867 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,410 893,867 893,867 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Page 19 Budget Summary with Amendment 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 11,000.00- 11,000.00- 307,049.00- 307,049.00- 200,417.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 108.26- 108.26- 7,610.35- 36,800.00- 46,000.00- 90,410.35- 108.26- 90,410.35- 108.26- 108.26- 108.26- 90,410.35- 90,410.35- 90,410.35- 69.185 11.985 22.952 17.438 3,389.65- 270,249.00- 154,417.00- 428,055.65- 17.438 428,055.65- 17.438 17.438 17.438 428,055.65- 428,055.65- 428,055.65- glpdatb2 skrolczyk 14:57 10/14/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Page 49 Detailed Accounting Trial Balance Program: Period Ending: 9/2020 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 528-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (7,502.09) Account: 528-49011-000-000 Interest Income Totals: (11,000.00) Budgeted (3,389.65) Remaining 69 % Used (108.26) (7,610.35) GL (108.26) (7,610.35) ** Account: 528-49142-000-000 Interfund transfer in -Water (36,800.00) .00 (36,800.00) Account: 528-49142-000-000 Interfund transfer in -Water Totals: .00 (36,800.00) ** (307,049.00) Budgeted (270,249.00) Remaining 12 % Used Account: 528-49143-000-000 Interfund transfer in -WW Account: 528-49143-000-000 (46,000.00) .00 (46,000.00) Interfund transfer in -WW Totals: .00 (46,000.00) ** (200,417.00) Budgeted (154,417.00) Remaining 23 % Used Department Totals: (90,410.35) ** (108.26) Monthly Total (518,466.00) Budgeted (428,055.65) Remaining 17 % Used Fund 528 Totals: (90,410.35) (108.26) Monthly Total (518,466.00) Budgeted (428,055.65) Remaining 17 % Used TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK INVESTMENTS 34,511 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,603 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 44,114 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,603 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,603 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES (48,443) TOTAL FUND BALANCE 34,511 TOTAL LIABILITIES AND FUND BALANCE 44,114 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Page 20 Budget Summary with Amendment Department: Revenues Program: Period Ending: 9/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 200.93- 103.34- 60.12- 687,823.75- 2,431.11- 3,348.82- 100.789 243.111 167.441 5,382.75 1,431.11 1,348.82 Subtotal: 685,441.00- 685,441.00- 364.39- 693,603.68- 101.191 8,162.68 533-49011-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 5,000.00- 218,004.00- 5,000.00- 218,004.00- 4.17- 4,173.61- 218,004.00- 83.472 100.000 826.39- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 114,562.91- 100.000 .09 - Subtotal: 337,567.00- 337,567.00- 4.17- 336,740.52- 99.755 826.48 - Program number: 1,023,008.00- 1,023,008.00- 368.56- 1,030,344.20- 100.717 7,336.20 Department number: Revenues 1,023,008.00- 1,023,008.00- 368.56- 1,030,344.20- 100.717 7,336.20 Revenues Subtotal 1,023,008.00- 1,023,008.00- 368.56- 1,030,344.20- 100.717 7,336.20 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 1 533-70020-051-000 1 533-70025-051-000 Paying Agent Fee Bond Issuance Bond Interest Expense -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 9/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 247,858.00 2,150.00 247,858.00 2,150.00 87,236.14 224,401.36 100.000 90.536 87,236.14- 23,456.64 Page 21 533-70035-051-000 Bond Principal Payment -Tax 765,000.00 765,000.00 765,000.00 100.000 Subtotal: 1,015,008.00 1,015,008.00 1,078,787.50 106.284 63,779.50 - Program number: 1,015,008.00 1,015,008.00 1,078,787.50 106.284 63,779.50 - Department number: Administration 1,015,008.00 1,015,008.00 1,078,787.50 106.284 63,779.50 - Expenditures Subtotal 1,015,008.00 1,015,008.00 1,078,787.50 106.284 63,779.50 - Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 368.56- 48,443.30 -605.541 56,443.30- glpdatb2 skrolczyk 14:57 10/14/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Account: 533-40000-000-000 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 50 Check Source Number Property Taxes (687,622.82) (18.50) (687,641.32) (14.51) (687,655.83) (.26) (687,656.09) (81.58) (687,737.67) (86.08) (687,823.75) GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (200.93) (687,823.75) ** Account: 533-40002-000-000 1894 09/03/2020 Property Taxes 1896 09/16/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes Account: 533-40002-000-000 (682,441.00) Budgeted Property Taxes/Delinquent 5,382.75 Remaining 101 % Used Property Taxes/Delinquent Totals: (1,000.00) Budgeted 1,431.11 Remaining (2,327.77) (10.52) (79.57) (5.84) (7.41) 243 % Used (2,338.29) (2,417.86) (2,423.70) (2,431.11) (103.34) (2,431.11) ** GL GL GL GL Account: 533-40015-000-000 1894 09/03/2020 Property Taxes 1895 09/08/2020 Property Taxes 1896 09/16/2020 Property Taxes 1897 09/21/2020 Property Taxes 1898 09/23/2020 Property Taxes 1899 09/24/2020 Property Taxes 1900 09/25/2020 Property Taxes Property Taxes/P & I (3,288.70) (2.84) (3,291.54) (3.14) (3,294.68) (16.93) (3,311.61) (.05) (3,311.66) (16.32) (3,327.98) (18.92) (3,346.90) (1.92) (3,348.82) GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (60.12) (3,348.82) ** (2,000.00) Budgeted Account: 533-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September 1,348.82 Remaining 167 9 Used (4,169.44) (4.17) (4,173.61) GL Account: 533-49011-000-000 Interest Income Totals: (4.17) (4,173.61) ** (5,000.00) Budgeted (826.39) Remaining 83 % Used Account: 533-49015-000-000 Lease/Rental Income (218,004.00) .00 (218,004.00) glpdatb2 skrolczyk 14:57 10/14/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (368.56) Monthly Total (1,030,344.20) ** (1,023,008.00) Budgeted 7,336.20 Remaining 101 % Used Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,004.00) ** (218,004.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg (114,562.91) .00 (114,562.91) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: .00 (114,562.91) ** (114,563.00) Budgeted (.09) Remaining 100 % Used Department Totals: (368.56) Monthly Total (1,030,344.20) ** (1,023,008.00) Budgeted 7,336.20 Remaining 101 % Used glpdatb2 skrolczyk 14:57 10/14/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Period Ending: 9/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 52 Check Source Number Department 51 Totals: Fund 533 Totals: 765,000.00 Budgeted .00 Monthly Total (368.56) Monthly Total .00 Remaining 100 % Used 1,078,787.50 ** 1,015,008.00 Budgeted (63,779.50) Remaining 106 % Used 48,443.30 (8,000.00) Budgeted (56,443.30) Remaining ########## Account: 533-70005-051-000 Paying Agent Fee 2,150.00 .00 2,150.00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 2,150.00 ** 2,150.00 Budgeted .00 Remaining 100 % Used Account: 533-70020-051-000 Bond Issuance 87,236.14 .00 87,236.14 Account: 533-70020-051-000 Bond Issuance Totals: .00 87,236.14 ** .00 Budgeted (87,236.14) Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 224,401.36 .00 224,401.36 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 224,401.36 ** 247,858.00 Budgeted 23,456.64 Remaining 91 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax 765,000.00 .00 765,000.00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 765,000.00 ** Department 51 Totals: Fund 533 Totals: 765,000.00 Budgeted .00 Monthly Total (368.56) Monthly Total .00 Remaining 100 % Used 1,078,787.50 ** 1,015,008.00 Budgeted (63,779.50) Remaining 106 % Used 48,443.30 (8,000.00) Budgeted (56,443.30) Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET SEPTEMBER 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 25,988 TOTAL ASSETS 25,988 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 24,518 1,470 25,988 TOTAL LIABILITIES AND FUND BALANCE 25,988 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 534 2015 Revenue Bond I&S Account 1 1 534-49011-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 9/2020 Adopted Amended Total Budget Budget Encumb. 2,500.00- 2,500.00 - Current Month 3.17 - Program: YTD Total 1,470.72- % of Remaining Budget Budget 58.829 1,029.28 - Page 22 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00- 598,637.33- 100.000 .67 - Subtotal: 601,138.00- 601,138.00- 3.17- 600,108.05- 99.829 1,029.95 - Program number: 601,138.00- 601,138.00- 3.17- 600,108.05- 99.829 1,029.95 - Department number: Revenues 601,138.00- 601,138.00- 3.17- 600,108.05- 99.829 1,029.95 - Revenues Subtotal 601,138.00- 601,138.00- 3.17- 600,108.05- 99.829 1,029.95- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 14:57 10/14/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 100.000 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 208,237.50 100.000 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 100.000 Subtotal: 598,638.00 598,638.00 598,637.50 100.000 Program number: 598,638.00 598,638.00 598,637.50 100.000 Department number: Administration 598,638.00 598,638.00 598,637.50 100.000 Expenditures Subtotal 598,638.00 598,638.00 598,637.50 100.000 Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 3.17- 1,470.55- 58.822 .50 .50 .50 .50 .50 1,029.45- glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (598,638.00) Budgeted (3.17) Monthly Total (.67) Remaining 100 % Used (600,108.05) ** (601,138.00) Budgeted (1,029.95) Remaining 100 % Used Account: 534-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (1,467.55) (3.17) (1,470.72) GL Account: 534-49011-000-000 Interest Income Totals: (3.17) (1,470.72) ** (2,500.00) Budgeted (1,029.28) Remaining 59 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales (598,637.33) .00 (598,637.33) Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (598,637.33) ** Department Totals: (598,638.00) Budgeted (3.17) Monthly Total (.67) Remaining 100 % Used (600,108.05) ** (601,138.00) Budgeted (1,029.95) Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/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 Totals: .00 Remaining 400.00 100 % Used .00 .00 400.00 400.00 ** Account: 534-70040-051-000 Revenue Bond Interest Expense 208,237.50 .00 208,237.50 Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 208,237.50 ** 208,238.00 Budgeted .50 Remaining 100 o Used Account: 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 .00 390,000.00 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 390,000.00 ** Department 51 Totals: Fund 534 Totals: 390,000.00 Budgeted .00 Remaining .00 Monthly Total 100 % Used 598,637.50 ** 598,638.00 Budgeted .50 Remaining 100 % Used (3.17) Monthly Total (2,500.00) Budgeted (1,470.55) (1,029.45) Remaining 59 % Used TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 5,625 TOTAL ASSETS 5,625 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 4,967 NET REVENUES / EXPENDITURES 658 TOTAL FUND BALANCE 5,625 TOTAL LIABILITIES AND FUND BALANCE 5,625 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 9/2020 Adopted Amended Total Budget Budget Encumb. 1,000.00- 1,000.00 - Current Month .60 - Program: YTD Total 658.10- % of Remaining Budget Budget 65.810 341.90 - Page 24 535-49142-000-000 Interfund Tran In -Water Sales 275,525.00- 275,525.00- 275,524.92- 100.000 .08 - Subtotal: 276,525.00- 276,525.00- .60- 276,183.02- 99.876 341.98 - Program number: 276,525.00- 276,525.00- .60- 276,183.02- 99.876 341.98 - Department number: Revenues 276,525.00- 276,525.00- .60- 276,183.02- 99.876 341.98 - Revenues Subtotal 276,525.00- 276,525.00- .60- 276,183.02- 99.876 341.98- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 14:57 10/14/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bond Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: Program number: Department number: Administration Expenditures Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 602,611.00 602,611.00 326,086.00 .60- 400.00 60,125.00 215,000.00 275,525.00 275,525.00 275,525.00 275,525.00 658.02- 50.000 15.544 100.000 45.722 400.00 326,686.00 327,086.00 45.722 327,086.00 45.722 327,086.00 45.722 327,086.00 -.202 326,744.02 glpdatb2 skrolczyk 14:57 10/14/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: 9/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (275,525.00) Budgeted (.60) Monthly Total (.08) Remaining 100 % Used (276,183.02) ** (276,525.00) Budgeted (341.98) Remaining 100 % Used Account: 535-49011-000-000 Interest Income 1880 09/30/2020 Bank Interest- September (657.50) (.60) (658.10) GL Account: 535-49011-000-000 Interest Income Totals: (.60) (658.10) ** (1,000.00) Budgeted (341.90) Remaining 66 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales (275,524.92) .00 (275,524.92) Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: .00 (275,524.92) ** Department Totals: (275,525.00) Budgeted (.60) Monthly Total (.08) Remaining 100 % Used (276,183.02) ** (276,525.00) Budgeted (341.98) Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 9/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 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Account: 535-70045-051-000 Account: 535-70045-051-000 Department 51 Totals: Fund 535 Totals: Rev Bond Paying Agent Fee Totals: 800.00 Budgeted 400.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 326,686.00 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted .00 Remaining 400.00 60,125.00 215,000.00 50 5 Used .00 400.00 .00 400.00 ** .00 16 % Used 60,125.00 .00 60,125.00 ** .00 215,000.00 100 % Used .00 Monthly Total 602,611.00 Budgeted (.60) Monthly Total 326,086.00 Budgeted .00 215,000.00 ** 275,525.00 ** 327,086.00 Remaining 46 % Used (658.02) 326,744.02 Remaining 0 8 Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET SEPTEMBER 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND ASSETS SERIES 2019 I&S LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 531 TOTAL FUND BALANCE 531 531 531 TOTAL LIABILITIES AND FUND BALANCE 531 glbase_tbam skrolczyk 14:57 10/14/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account 1 1 536-49011-000-000 1 536-49142-000-000 1 Description Interest Income Interfund Tran In -Water Sales Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 9/2020 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 473.37- 251,856.22- 473.37 251,856.22 Page 26 536-49143-000-000 Interfund Transfer In -WW Sales 75,229.77- 75,229.77 Subtotal: 327,559.36- 327,559.36 Program number: 327,559.36- 327,559.36 Department number: Revenues 327,559.36- 327,559.36 Revenues Subtotal 327,559.36- 327,559.36 glbase_tbam skrolczyk Trophy Club MUD No.1 14:57 10/14/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 9/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-70005-051-000 Rev Bond Paying Agent Fee 342.08 536-70040-051-000 Revenue Bond Interest Expense 326,686.18 342.08- 326,686.18 - Page 27 Subtotal: 327,028.26 327,028.26 - Program number: 327,028.26 327,028.26 - Department number: Administration 327,028.26 327,028.26 - Expenditures Subtotal 327,028.26 327,028.26 - Fund number: 536 2019 Rev Bond I&S- W&WW System 531.10- 531.10 End of Report ********* glpdatb2 skrolczyk 14:57 10/14/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 57 Check Source Number Department Totals: .00 Budgeted .00 Monthly Total 75,229.77 Remaining 0 % Used .00 Budgeted (327,559.36) ** 327,559.36 Remaining 0 % Used Account: 536-49011-000-000 Interest Income (473.37) .00 (473.37) Account: 536-49011-000-000 Interest Income Totals: .00 (473.37) ** .00 Budgeted 473.37 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales (251,856.22) .00 (251,856.22) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: .00 (251,856.22) ** .00 Budgeted 251,856.22 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales (75,229.77) .00 (75,229.77) Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (75,229.77) ** Department Totals: .00 Budgeted .00 Monthly Total 75,229.77 Remaining 0 % Used .00 Budgeted (327,559.36) ** 327,559.36 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 14:57 10/14/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond IBS- W&WW System Department: 51 Administration Program: Period Ending: 9/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 342.08 .00 342.08 Rev Bond Paying Agent Fee Totals: .00 342.08 ** .00 Budgeted (342.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 326,686.18 .00 326,686.18 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 326,686.18 ** Department 51 Totals: Fund 536 Totals: Grand Totals: .00 Budgeted (326,686.18) Remaining 0 o Used .00 Monthly Total .00 Budgeted .00 Monthly Total .00 Budgeted 327,028.26 ** (327,028.26) Remaining 0 % Used (531.10) 531.10 Remaining 0 % Used ******* End of Report (1,397,275.55) **** (118,336.22) Monthly Total (251,995.00) Budgeted 1,145,280.55 Remaining 554 % Used