Loading...
HomeMy WebLinkAbout2020-10 Combined Financials October 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 367,311 PREPAID EXPENSES 18,140 ADVALOREM PROPERTY TAXES RECEIVABLE 1,194,770 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,580,220 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,194,776 1,194,776 652,065 (266,622) 385,444 1,580,220 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 122-40020-000-000 Property Taxes/MUD Fire 1,246,877.00- 1,246,877.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 9,008.84- 2,902.88- 20.28- 9,008.84- 2,902.88- 20.28- .723 1,237,868.16- 2,902.88 20.28 Page 1 Subtotal: 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Program number: 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Department number: Fire Revenues - 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Revenues Subtotal 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00- glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 197,281.00 197,281.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 820,027.00 820,027.00 11111e2total: 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtot Program number: Expenditures Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Fund number: 122 Trophy Club MUD Fire Dept. 1,038,308.00 J11110,308.00 6,127.00 81,420.00 121,022.00 6,127.00 81,420.00 121,022.00 208,569.00 1,649.06 68,335.58 69,984.64 6,126.73 81,420.00 121,021.87 .24 .24 .24 .24 1,649.06 68,335.58 6,126.73 81,420.00 121,021.87 7.853 8.333 99.996 100.000 100.000 22.340 197,281.00 19,350.94 751,691.42 .27 .13 968,323.76 266,621.24 - Page 2 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/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- 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes Property Taxes/MUD Fire Account: 122 -40010 -u00 -.Property Taxes/MUD Fire Totals: (1,246,877.00) Budgeted (1,237,868.16) Remaining 1 % Used Account: 122-40011-000-00 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes Account: 122 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes Account: 122-40020-000-000 Department Totals: Property Taxes/Fire-Delinquent Property Taxes/Fire-Delinquent Totals: .00 Budgeted 2,902.88 Remaining Property Taxes/Fire PRI Property Taxes/Fire PRI Totals: .00 Budgeted (11,932.00) Monthly Total 0 % Used (253.00) (253.00) GL (538.30) (791.30) GL (957.15) (1,748.45) GL (511.60) (2,260.05) GL (780.25) (3,040.30) GL (349.14) (3,389.44) GL (216.73) (3,606.17) GL (544.95) (4,151.12) GL (1,004.78) (5,155.90) GL (1,218.66) (6,374.56) GL (917.00) (7,291.56) GL (525.51) (7,817.07) GL (1,191.77) (9,008.84) GL (49.32) (49.32) GL 331.81 282.49 GL (3,153.40) (2,870.91) GL (9.42) (2,880.33) GL (18.24) (2,898.57) GL (4.31) (2,902.88) GL (10.89) (2.83) (4.56) (2.00) (10.89) (13.72) (18.28) (20.28) 20.28 Remaining 0 % Used (11,932.00) ** (1,246,877.00) Budgeted (1,234,945.00) Remaining 1 % Used GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 2 Account: 122-60030-045-000 Account: 122-60030-045-000 197,281.00 Budgeted Account: 122-60055-045-000 Insurance 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: -60055-045-000 .00 .00 197,281.00 Remaining 0 % Ueed 21,000.00 Budgeted 19,350.94 Remaining efer to Town/Fire Budget 43 10/08/2020 October A/P October Fire admin Account: 122-60337-045-W Transfer to 820,027.00 Budgeted 751,691.42 Remaining Account: 122-69009-045-000 Ilk Short Term Debt -Interest 46 10/08/2020 Sep Out Int/Prin Fire Trk FY21 Seperate Interest in Cap Lease Account: 122-69009-045-000 Short Term Debt -Interest 6,127.00 Budgeted 1,649.06 8 % Ueed a 68,335.58 Used .27 Remaining 100 % Used Account: 122-69195-045-00da for Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 Fire Truck Future Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining Account: 122-69305-045-00 Capital Lease 43 10/08/2020 October A/P lease payment 46 10/08/2020 Sep Out Int/Prin Fire Trk FY21 D ladder -T681 100 % Used 6,126.73 81,420.00 1,649.06 68,335.58 TOWN OF TROPHY CLUB 6,126.73 81,420.00 81,420.00 8 127,148.60 (6,126.73) 127,148.60 121,021.87 PNC Bank, N. GL 6909 AP 6907 GL GL AP GL Account: 122-69305-045-00 Capital Lea 121,022.00 Budgeted .13 Remaining 100 Ueed glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: 278,553.24 ** 278,553.24 Monthly Total 1,246,877.00 Budgeted 968,323.76 Remaining 22 % Used Fund 122 Totals: 266,621.24 266,621.24 Monthly Total .00 Budgeted (266,621.24) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,264,084 3,264,084 CASH IN BANK -SAVINGS -CASH RESERVE 1,845,227 1,845,227 INVESTMENTS-TEXPOOL 3,479,185 2,007,484 5,486,669 PREPAID EXPENSES 102,195 102,195 ADVALOREM PROPERTY TAXES RECEIVABLE 130,720 130,720 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,186,415 1,186,415 TOTAL ASSETS 10,008,426 2,007,484 12,015,910 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 130,720 130,720 ACCOUNTS AND OTHER PAYABLES 438,438 438,438 CUSTOMER DEPOSITS 311,040 311,040 TOTAL LIABILITIES 880,198 880,198 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,404,829 2,404,829 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 6,763,058 6,763,058 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (43,144) (43,144) TOTAL FUND BALANCE 9,128,229 2,007,484 11,135,713 TOTAL LIABILITIES AND FUND BALANCE 10,008,426 2,007,484 12,015,910 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Account Description 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 136,531.00- 136,531.00- 300.00- 300.00- 300.00- 300.00- 163,725.00- 163,725.00- 135-47000-000-000 Water 5,932,489.00- 5,932,489.00- 135-47005-000-000 Sewer 3,677,146.00- 3,677,146.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 16,550.00- 16,550.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 135-49011-000-000 135-49016-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Subtot Program number: Department number: Revenues Revenues 9,792,043.00- 9,792,043.00- 100,000.00- 100,000.00- 14,146.00- 14,146.00- 5,000.00- 5,000.00- 8,232.00- 8,232.00- 7,000.00- 7,000.00- 986.32- 986.32- .722 135,544.68- 321.43- 321.43- 107.143 21.43 2.27- 2.27- .757 297.73- 163,725.00- 299,545.98- 521,135.86- 521,135.86- 8.784 5,411,353.14- 230,388.79- 230,388.79- 6.265 3,446,757.21- 7,657.60- 7,657.60- 6.800 104,950.40- 2,000.00- 2,000.00- 12.085 14,550.00- 750.00- 2,500.00- 14,039.20- 14,039.20- 28.078 35,960.80- 775,221.45- 7.917 9,016,821.55- 2,015.19- 2,015.19- 2.015 97,984.81- 1,178.81- 1,178.81- 8.333 12,967.19- 5,000.00- 8,232.00- 187.11- 187.11- 2.673 6,812.89 - Subtotal 3,381.11- 779,912. 779,912.58- 779,912.5: 9,447, 9,447,364.42- 9,447,364.42 - Page 3 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 FSubtotal: Salaries & Wages 365,309.00 365,309.00 23,007.66 23,007.66 6.298 342,301.34 Overtime 17,000.00 17,000.00 1,698.29 1,698.29 9.990 15,301.71 Longevity 5,435.00 5,435.00 5,435.00 Certification 6,000.00 6,000.00 200.00 200.00 3.333 5,800.00 Retirement 36,520.00 36,520.00 3,983.96 3,983.96 10.909 32,536.04 Medical Insurance 86,182.00 86,182.00 5,225.04 5,225.04 6.063 80,956.96 Dental Insurance 4,933.00 4,933.00 316.63 316.63 6.419 4,616.37 Vision Insurance 789.00 789.00 48.18 48.18 6.106 740.82 Life Insurance & Other 3,289.00 3,289.00 303.83 303.83 9.238 2,985.17 Social Security Taxes 24,412.00 24,412.00 1,540.62 1,540.62 6.311 22,871.38 Medicare Taxes 5,709.00 5,709.00 360.31 360.31 6.311 5,348.69 Unemployment Taxes 1,080.00 1,080.00 34.41 34.41 3.186 1,045.59 Workman's Compensation 10,877.00 10,877.00 901.29 901.29 8.286 9,975.71 Pre-emp Physicals/Testing 400.00 400.00 400.00 Employee Relations 300.00 300.00 300.00 Page 4 568,235.00 568,235.00 37,620.22 .621 530,614.78 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 124,000.00 124,000.00 4,050.86 13,284.36 17,335.22 13.980 106,664.78 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,042.09 1,042.09 20.842 3,957.91 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 1,000.00 1,000.00 100.000 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 4,066.06 433.94 4,500.00 60.000 3,000.00 1 135-60010-010-000 Communications/Mobiles 7,500.00 7,500.00 135-60020-010-000 Electricity 123,487.00 123,487.00 112,150.29 11,336.71 123,487.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 516.00 516.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,875.00 2,875.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 30,000.00 30,000.00 135-60150-010-000 Wholesale Water 2,596,295.00 2,596,295.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 565,820.00 565,820.00 51,438.13 135-60334-010-000 Interfund Transfer Out 75,000.00 75,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 54,579.12 100.000 51.600 54,579.12 2.102 750.00 5.085 51,438.13 9.091 7,500.00 484.00 500.00 7,426.00 400.00 2,875.00 1,500.00 30,000.00 2,541,715.88 200.00 3,000.00 14,000.00 514,381.87 75,000.00 2,500.00 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Period Ending: 10/2020 Account Description Adopted Amended Total 135-65005-010-000 Fuel & Lube 135-65010-010-000 Uniforms 135-65030-010-000 Chemicals 135-65035-010-000 Small Tools 135-65040-010-000 Safety Equipment 135-65050-010-000 Meter Expense 135-65053-010-000 Meter Change Out Program 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Budget Budget Encumb. 15,000.00 15,000.00 5,190.00 5,190.00 25,000.00 25,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 740,000.00 740,000.00 30,962.00 30,962.00 2,324.00 2,324.00 75,000.00 75,000.00 108,000.00 108,000.00 Current Month 118,61 Program: YTD Total 230,77 524.19 524.19 3.495 14,475.81 1,520.23 1,520.23 29.292 3,669.77 8,818.23 1,678.33 10,496.56 41.986 14,503.44 % of Remaining Budget Budget 8,818.23 3,722.75 12,540.98 7,140.40- 50,470.55 43,330.15 75,000.00 75,000.00 ,140.40- 125,470.55 118,330.15 2,945.04 300,193.87 423,138.91 6.136 5.855 100.000 12.E 1,200.00 1,000.00 70,000.00 87,000.00 696,669.85 30,962.00 2,324.00 108,000.00 Page glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/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 1,120.00 80.00 Subtotal: 2,000.00 2,000.00 1,120.00 80.00 Program number: 1 Lab Analysis for PU1111111111 2,000.00 2,000.00 1,120.00 80.00 Department number: Water 5,327,164.00 5,327,164.00 124,065.04 300,273.87 1,200.00 1,200.00 1,200.00 424,338.91 60.000 800.00 60.000 800.00 60.000 800.00 7.966 4,902,825.09 Page 6 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 135-50010-020-000 135-50016-020-000 135-50017-020-000 135-50020-020-000 135-50026-020-000 135-50027-020-000 135-50028-020-000 135-50029-020-000 135-50030-020-000 135-50035-020-000 135-50040-020-000 135-50045-020-000 135-50060-020-000 135-50070-020-000 FSubtotal: 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 108,000.00 108,000.00 786.75- 5,256.73 4,469.98 4.139 103,530.02 135-55081-020-000 Mainten & Revairs Collections 157,500.00 157,500.00 157,500.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 1,448.50 1,448.50 36.213 2,551.50 135-55091-020-000 Veh Maintenance Collections 13,000.00 13,000.00 366.50 366.50 2.819 12,633.50 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 1,500.00 1,500.00 100.000 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 94,616.54 5,383.46 100,000.00 100.000 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 31,170.85 2,829.15 34,000.00 85.000 6,000.00 28 340,215.02 Salaries & Wages 483,633.00 483,633.00 30,458.64 30,458.64 6.298 453,174.36 Overtime 33,000.00 33,000.00 1,552.50 1,552.50 4.705 31,447.50 Longevity 7,420.00 7,420.00 7,420.00 Certification 8,100.00 8,100.00 625.00 625.00 7.716 7,475.00 Retirement 49,358.00 49,358.00 5,259.20 5,259.20 10.655 44,098.80 Medical Insurance 122,035.00 122,035.00 7,739.58 7,739.58 6.342 114,295.42 Dental Insurance 6,443.00 6,443.00 430.81 430.81 6.686 6,012.19 Vision Insurance 1,098.00 1,098.00 69.78 69.78 6.355 1,028.22 Life Insurance & Other 4,725.00 4,725.00 389.04 389.04 8.234 4,335.96 Social Security Taxes 32,993.00 32,993.00 1,983.69 1,983.69 6.012 31,009.31 Medicare Taxes 7,716.00 7,716.00 463.95 463.95 6.013 7,252.05 Unemployment Taxes 1,440.00 1,440.00 36.86 36.86 2.560 1,403.14 Workman's Compensation 14,607.00 14,607.00 1,218.11 1,218.11 8.339 13,388.89 Pre-emp Physicals/Testing 400.00 400.00 400.00 Employee Relations 300.00 300.00 300.00 Page 7 773,268.00 773,268.00 = 50,227 135-60010-020-000 Communications/Mobiles 7,500.00 7,500.00 7,500.00 135-60020-020-000 Electricity 157,735.00 157,735.00 146,150.09 11,555.18 157,705.27 99.981 29.73 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 4,991.00 4,991.00 113.75 113.75 2.279 4,877.25 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,575.00 1,575.00 1,575.00 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 45,000.00 45,000.00 9,888.02 9,888.02 21.973 35,111.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 5,000.00 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out Furniture/Equipment < $5000 135-65005-020-000 Fuel & Lube 135-65010-020-000 Uniforms 135-65030-020-000 Chemicals 135-65031-020-000 Chemicals Collections 135-65035-020-000 Small Tools 135-65040-020-000 Safety EQuipment 135-65045-020-000 Lab Supplies FSubtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement FProgram number: Department number: Wastewater 14,000.00 14,000.00 114,681.00 114,681.00 688,005.00 688,005.00 75,000.00 75,000.00 2,000.00 2,000.00 1,124,937.00 1,124,937.00 12,500.00 12,500.00 6,280.00 6,280.00 25,000.00 25,000.00 17,500.00 17,500.00 1,200.00 1,200.00 1,200.00 1,200.00 28,000.00 28,000.00 1,680.00 335,000.00 335,000.00 81,273.00 81,273.00 8,532.00 8,532.00 130,000.00 130,000.00 3,026,690.00 3,026,690.00 890.00 10,425.55 62,545.87 35.90 146,150.09 .4.27 650.07 5,282.50 3,574.10 3,999.00 9,281.50 252.00 4,563.88 9,040.05 49,636.25 7,624.00 331,568.48 130,000.00 307,629.82 890.00 10,425.55 62,545.87 35.90 241,604.36 650.07 8,856.60 252.00 8,562.88 18, 57,260.25 130,000.00 639,198.30 6.357 13,110.00 9.091 104,255.45 9.091 625,459.13 75,000.00 1.795 1,964.10 21.4'W 883,332.64 5.201 11,849.93 6,280.00 35.426 16,143.40 17,500.00 1,200.00 21.000 948.00 30.582 19,437.12 19.984 17.093 277,739.75 81,273.00 8,532.00 100.000 367,544.75 2,387,491.7 21.119 2,387,491.70 Page 8 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 10/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 .79 Program: YTD Total .79 % of Remaining Budget Budget 2.633 29.21 Page 9 Subtotal: 30.00 30.00 .79 .79 2.633 29.21 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 89.50 89.50 6.885 150.00 750.00 1,210.50 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 89.50 89.50 .678 13,110.50 Program number: 13,230.00 13,230.00 90.29 90.29 .682 13,139.71 L Department number: Board of Directors 13,230.00 13,230.00 90.29 90.29 .682 13,139.71 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 626,592.00 626,592.00 34,634.24 34,634.24 5.527 591,957.76 135-50010-030-000 Overtime 2,000.00 2,000.00 2,000.00 135-50016-030-000 Longevity 2,668.00 2,668.00 2,668.00 135-50020-030-000 Retirement 58,550.00 58,550.00 5,753.10 5,753.10 9.826 52,796.90 135-50026-030-000 Medical Insurance 136,834.00 136,834.00 7,970.17 7,970.17 5.825 128,863.83 135-50027-030-000 Dental Insurance 7,109.00 7,109.00 441.96 441.96 6.217 6,667.04 135-50028-030-000 Vision Insurance 1,138.00 1,138.00 65.60 65.60 5.764 1,072.40 135-50029-030-000 Life Insurance & Other 4,730.00 4,730.00 407.01 407.01 8.605 4,322.99 135-50030-030-000 Social Security Taxes 39,138.00 39,138.00 2,093.70 2,093.70 5.350 37,044.30 135-50035-030-000 Medicare Taxes 9,153.00 9,153.00 489.64 489.64 5.350 8,663.36 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 1,440.00 135-50045-030-000 Workman's Compensation 1,573.00 1,573.00 128.50 128.50 8.169 1,444.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 78.83 78.83 .985 7,921.17 Page 10 899,425.00 899,425.00 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanini7 Services Professional Outside Services Utility Billing Contract 126,854.00 126,854.00 15,000.00 15,000.00 40,000.00 40,000.00 10,000.00 10,000.00 15,000.00 15,000.00 104,925.00 104,925.00 9,000.00 9,000.00 7,152.75- 985.00 15,000.00 7,417.73 33,166.94 26,014.19 20.507 3,561.68 4,546.68 11.367 75.00 15,075.00 100.500 57,876.00 57,876.00 55.159 582.27 8,000.00 88.889 100,839.81 15,000.00 35,453.32 10,000.00 75.00- 47,049.00 1,000.00 135-60005-030-000 Telephone 9,680.00 9,680.00 2,760.00 440.91 3,200.91 33.067 6,479.09 135-60010-030-000 Communications/Mobiles 3,000.00 3,000.00 225.00 225.00 7.500 2,775.00 135-60020-030-000 Electricity/Gas 14,512.00 14,512.00 13,978.93 533.07 14,512.00 100.000 135-60025-030-000 Water 5,000.00 5,000.00 320.10 320.10 6.402 4,679.90 135-60035-030-000 Postage 30,000.00 30,000.00 19,332.05 1,775.62 21,107.67 70.359 8,892.33 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 600.00 8,020.93 8,620.93 12.867 58,379.07 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 6,724.87 6,724.87 8.006 77,275.13 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 100.00 100.00 1.667 5,900.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 111.00 111.00 1.850 5,889.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 75.00 75.00 1.095 6,775.00 135-60100-030-000 Travel & per diem 3,575.00 3,575.00 95.34 95.34 2.667 3,479.66 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 5,000.00 5,000.00 59.43 59.43 1.189 4,940.57 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60285-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Lawn Equipment & Maintenance Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 5,000.00 5,000.00 2,500.00 2,500.00 7 272,505.00 272,505.00 36,670.98 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 20,253.00 20,253.00 1,483.60 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 138,000.00 138,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 Program number: Department number: Administration 1,483.60 1,g1111111111,669,5111p0 54,404.56 1,011111111 1,669,50 54,404.56 90.00 18,571411111 55, 693.52 183.78 46,825.00 47 175.00 90.00 1.800 1,483.60 693.52 183.78 46,825.00 175.00 7.325 11.559 4.595 33.931 4.375 1,288.00 500.00 17,000.00 4,910.00 2,500.00 2,050.00 18,769.40 5,306.48 3,816.22 2,500.00 91,175.00 3,825.00 34.23 ,334.23 Page 11 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,925.00 4,850.00 135,000.00 33,800.00 11,925.00 4,850.00 1,397.50 107.67- 1,397.50 107.67- 1.035 -.903 133,602.50 33,800.00 12,032.67 4,850.00 Page 12 ir Subtotal: ' 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Program number: 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Department number: Non Departmental 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Expenditures Subtotal 10,222,171.00 10,222,171.00 510,038.08 823,057.02 1,333,095.10 13.041 8,889,075.90 Fund number: 135 MUD 1 General Fund 5,106.00- 5,106.00- 510,038.08 43,144.44 553,182.52 ############### 558,288.52- glbase_tbam skrolczyk 17:58 11/11/20 Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 0- 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00- 286,420.00 Page 13 glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 4 Check Source Number Account: 135-40000-000-000 L Property Taxes 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes (27.70) (58.93) (104.79) (56.01) (85.42) (38.22) (23.73) (59.67) (110.01) (133.43) (100.39) (57.54) (130.48) (27.70) (86.63) (191.42) (247.43) (332.85) (371.07) (394.80) (454.47) (564.48) (697.91) (798.30) (855.84) (986.32) GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (986.32)■ (986.32) ** (136,531.00) Budgeted (135,544.68) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (5.53) (5.53) 37.78 32.25 (350.07) (317.82) (1.07) (318.89) (2.06) (320.95) (.48) (321.43) GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (321.43) (321.43) ** (300.00) Budgeted 21.43 Remaining 107 % Used Account: 135-40015-000-000 Property Taxes/P & I 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (1.22) (1.22) (.32) (1.54) (.51) (2.05) (.22) (2.27) GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (2.27) ** (300.00) Budgeted (297.73) Remaining 1 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2020 JE Detail Beginning Balance Description/Comment PID Su (163,725.00) Budgeted Program: Transaction Detail otals: (163,725.00) Remaining Nat ' 108 10/01/2020 Reversed Accrued UB JE# 1929 39 10/08/2020 UB 10/08/2020 Account reversal UB20201008-20201008 User: 72 10/16/2020 UB 10/16/2020 Trane reversal UB20201016-20201016 User: 155 10/31/2020 UB 10/31/2020 Billing UB20201031-20201031 User: Account: 135-47000-000-000 (5,932,489.00) Budgeted (5,411,353.14) Remaining Account: 135-47005-000-000 108 10/01/2020 Reversed Accrued UB JE# 1929 39 10/08/2020 UB 10/08/2020 Account reversal UB20201008-20201008 User: 72 10/16/2020 UB 10/16/2020 Trans reversal UB20201016-20201016 User: 155 10/31/2020 UB 10/31/2020 Billing UB20201031-20201031 User: Account: 135-47005-000-000 Account: 135-47025-000-000 27 10/06/2020 UB 30 10/07/2020 UB 73 10/16/2020 UB 95 10/20/2020 UB 101 10/21/2020 UB 106 10/22/2020 UB 133 10/28/2020 UB 137 10/29/2020 UB 152 10/30/2020 UB (3,677,146.00) Budgeted Penalties 10/06/2020 Penalty removal 10/07/2020 Penalty removal 10/16/2020 Penalty removal 10/20/2020 Penalty removal 10/21/2020 Penalties 10/22/2020 Penalty removal 10/28/2020 Penalty removal 10/29/2020 Penalty removal 10/30/2020 Penalty removal Totals: (3,446,757.21) Remaining UB20201006-20201006 User: U820201007-20201007 User: UB20201016-20201016 User: UB20201020-20201020 User: UB20201021-20201021 User: UB20201022-20201022 User: UB20201028-20201028 User: UB20201029-20201029 User: UB20201030-20201030 User: alta (112,608.00) Budgeted (104,950.40) Remaining Service Charges 33 10/07/2020 UB 10/07/2020 Disconnect Fees UB20201007-20201007 User: 100 10/20/2020 UB 10/20/2020 NSF Check UB20201020-20201020 User: Transaction Vendor Name Detail (SUBTOTAL) 0 Used 9 % Used 112,426.19 14.71 27.65 (633,604.41) 56,800.41 34.54 34.54 (287,258.28) 6 % Used 112,426.19 112,440.90 112,468.55 (521,135.86) 56,800.41 56,834.95 56,869.49 (230,388.79) 279.58 279.58 164.21 443.79 112.02 555.81 34.16 589.97 (9,262.81) (8,672.84) 175.32 (8,497.52) 545.95 (7,951.57) 108.67 (7,842.90) 185.30 (7,657.60) 7 % Used Page 5 Check Source Number GL UB UB UB GL UB UB UB UB UB UB UB UB UB UB UB UB (1,950.00) (1,950.00) UB (25.00) (1,975.00) UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 153 10/26/2020 UB 10/26/2020 NSF Check UB20201026-20201026 User: (25.00) (2,000.00) UB Account: 135-47030-000- Service Chargee (2,000.0 (16,550.00) Budgeted (14,550.00) Remaining 12 % Used Account: 135-47035-000-000 MirPlumbing Inspections Account: 135-47035-000-000 Account: 135-47045-000-000 Account: Plumbing Inspections (750.00) Budgeted (750.00) Remaining Sewer Inspections Sewer Inspections (2,500.00) Budgeted (2,500.00) Remaining .00 .00 0 % Used .00 .00 0 % Used Account: 135-47070-000-00t TCCC Effluent Chargee 155 10/31/2020 UB 10/31/2020 Billing 0020201031-20201031 User: (14,039.20) (14,039.20) UB Account: TCCC Effluent Charges (50,000.00) Budgeted ACC InCome Account: 1 (35,960.80) Remaining 28 % Used 239 10/31/2020 Bank Interest- October (624.95) (624.95) GL 239 10/31/2020 Bank Interest- October (695.32) (1,320.27) GL 239 10/31/2020 Bank Interest- October (694.92) (2,015.19) GL Interest Income (100,000.00) Budgeted _ Totals: (97,984.81) Remaining 2 % Used Account: 135-49016-000-000 Cell Tower Revenue 11 10/02/2020 Cell Tower Rev AT&T (1,178.81) Account: 135-49016-000-000 Tower Revenue (14,146.00) Budgeted (12,967.19) Remaining 8 Used (1,178.81) (1,178.81) GL Account: 135-49026-000-000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/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-49026-000-000 Account: 135-49075-000-000 Account: 135-49075-000-000 Proceeds from Sale of Assets Totals: (5,000.00) Budgeted (5,000.00) Remaining Oversize Meter Reimbursement Oversize Meter Reimbursem (8,232.00) Budgeted Accoyt: 135-49900-000- Miscellaneous Income (8,232.00) 155 10/31/2020 UB 10/31/2020 Billing 0020201031-20201031 User: Remaining .00 .00 0 % Used .00 0 % Used .00 (187.11) (187.11) UB Account Miscellaneous Income . Totals: . (187.11) (7,000.00) Budgeted (6,812.89) Remaining 3 % Used Department Totals: (779,912.58) ** (779,912.58) Monthly Total (10,227,277.00) Budgeted (9,447,364.42) Remaining 8 % Used glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund ACC 4 10/02/2020 113 10/02/2020 57 10/16/2020 114 10/16/2020 121 10/30/2020 JE Number JE Date JE Description ount: 135-50005-010- Salaries MUD payroll 10/2/2020 Salaries & Wages Department: 10 Water JE Detail Description/Comment Revr Accr Sept FY20 Payroll #1 MUD Payroll 10/16/2020 Salaries & Wages Revr Accr Sept FY20 Payroll #2 MUD P/R 10/30/2020 Salaries & Wages Trophy Club MUD No.1 Page 8 Detailed Accounting Trial Balance Period Ending: 10/2020 Beginning Balance Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 13,139.19 13,139.19 (13,139.19) .00 13,714.67 13,714.67 (4,268.89) 9,445.78 13,561.88 23,007.66 Check Source Number PR GL PR GL PR Account: 135-50005-010-000 23,007.66 365,309.00 Budgeted 342,301.34 Remaining 6 % Used ACCCu .111h. PR GL PR PR 4 10/02/2020 MUD payroll 10/2/2020 Overtime 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Overtime 121 10/30/2020 MUD P/R 10/30/2020 Overtime Account: 135-50010-010- Overtime 17,000.00 Budgeted Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Account: 135-50017-010-00 57 10/16/2020 MUD Payroll 10/16/2020 4 10/02/2020 MUD payroll 10/2/2020 57 10/16/2020 MUD Payroll 10/16/2020 121 10/30/2020 MUD P/R 10/30/2020 `Longevir 5,435.00 Budgeted Certification Certification 6,000.00 Budgeted rement Retirement Retirement Retirement 36,520.00 Budgeted 15,301.71 Remaining 5,435.00 Remaining 5,800.00 Remaining 32,536.04 Remaining 10 % Used 0 % Used 3 % Used 11 % Used 709.21 (709.21) 788.26 910.03 .00 200.00 1,282.36 1,361.50 1,340.10 709.21 .00 788.26 1,698.29 .00 200.00 1,282.36 2,643.86 3,983.96 PR PR PR PR glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 9 Check Source Number 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 848.69 (848.69) 893.42 (259.36) 906.56 848.69 .00 893.42 634.06 1,540.62 PR GL PR GL PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,540.62 1,540.62 ** 24,412.00 Budgeted 22,871.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes Account: 135-50026-010-000 Medical Insurance Nir 4 10/02/2020 MUD payroll 10/2/2020 Medical Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Medical Insurance 2,612.55 2,612.49 2,612.55 5,225.04 PR PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 5,225.04 ** 86,182.00 Budgeted 80,956.96 Remaining 6 % Used Account: 135-50027-010-000 Dental Insurance 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance 158.32 158.31 158.32 316.63 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 316.63 316.63 ** 4,933.00 Budgeted 4,616.37 Remaining 6 % Used Account: 135-50028-010-000 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance 24.10 24.08 24.10 48.18 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 48.18 48.18 ** 789.00 Budgeted 740.82 Remaining 6 % Used Account: 135-50029-010-000 Life Insurance & Other 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits 130.25 173.58 130.25 303.83 METLIFE Humana GROUP Inc BENEFITS 6881 6880 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 303.83 303.83 ** 3,289.00 Budgeted 2,985.17 Remaining 9 % Used Account: 135-50030-010-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 848.69 (848.69) 893.42 (259.36) 906.56 848.69 .00 893.42 634.06 1,540.62 PR GL PR GL PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,540.62 1,540.62 ** 24,412.00 Budgeted 22,871.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 10 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes Account Medicare Taxes Mr Totals: 5,709.00 Budgeted 5,348.69 Remaining Account: 135 Unemployment Taxes 4 10/02/2020 MUD payroll 10/2/2020 Unemployment Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Unemployment Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Unemployment Taxes Account: 135-50040-010- Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135-50045-010-00 Workman's Compensatio 10,877.00 Budgeted 198.48 198.46 PR (198.48) .00 GL 208.95 208.95 PR (60.66) 148.29 GL 212.02 360.31 PR 360.31 6 % Used 21.51 21.51 (21.51) .00 21.64 21.64 (6.58) 15.06 19.35 34.41 1,045.59 Remaining 3 % Used 9,975.71 Remaining 8 Used 901.29 901.29 PR GL PR GL PR GL Account: 135-50060-010-000 -re-emp -•ysaca a es in. Pre-emp Physicals/Testing Total 400.00 Budgeted 400.00 Remaining 0 % Used .00 .00 Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Engineering glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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-55005-010-000 Engineering Totals: 20,000.00 Budgeted .00 .00 20,000.00 Remaining 0 % Used Maintenance & Repairs 77 10/16/2020 October A/P TC MUD Telecommunication line 3,425.00 3,425.00 REY-MAR CONSTRUCTION 6921 AP 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 AMZN MKTP US*2T92078I0 69.99 3,494.99 AMZN MKTP US*2T92078I0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 THE HOME DEPOT #6581 32.67 3,527.66 THE HOME DEPOT #6581 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TEX-TURF 54.10 3,581.76 TEX-TURF PC 143 10/29/2020 October A/P parts 30.60 3,612.36 Core & Main LP 6940 AP 143 10/29/2020 October A/P angle stops 900.00 4,512.36 Core & Main LP 6940 AP 150 10/30/2020 October A/P Parts -meter boxes 1,014.00 5,526.36 Core & Main LP 6956 AP 150 10/30/2020 October A/P Parts -meter boxes 466.80 5,993.16 Core & Main LP 6956 AP 150 10/30/2020 October A/P Parts -meter boxes 738.00 6,731.16 Core & Main LP 6956 AP 201 10/31/2020 October A/P Gas chlorinator 85.20 6,816.36 SCOOP 6978 AP 201 10/31/2020 October A/P Gas chlorinator 6,468.00 13,284.36 SCOOP 6978 AP Account: 135-55080-010-000 Account: 135-55080-orrbll Maintenance & Repair Totals: 124,000.00 Budgeted 110,715.64 Remaining Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55085-010-000 Generator Maint. and Repai 3,000.00 Budgeted Account: 135-55090-010-000 Wrrire Maintenance 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DENTON VEHREG 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DENTON VEHREG 11 % Used 3,000.00 Remaining 0 % Used .00 .00 8.25 8.25 DENTON VEHREG PC 15.00 23.25 DENTON VEHREG PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TX.GOV*SERVICEFEE-DIR 2.00 25.25 TX.GOV*SERVICEFEE-DIR PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TX.GOV*SERVICEFEE-DIR 4.00 29.25 TX.GOV*SERVICEFEE-DIR PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 7.00 36.25 KWIK KAR LUBE & TUNE 0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 210.34 246.59 KWIK KAR LUBE & TUNE 0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 7.00 253.59 KWIK KAR LUBE & TUNE 0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 25.50 279.09 KWIK KAR LUBE & TUNE 0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 763.00 1,042.09 DISCOUNT TIRE TXD 75 PC Account: 135-55090-010-0 enance Totals: 5,000.00 Budgeted 3,957.91 Remaining 21 % Used glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 12 Check Source Number Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services .00 .00 Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 201 10/31/2020 October A/P 214 10/31/2020 October A/P TCEQ samples water samples 213.94 220.00 213.94 433.94 LOWER COLORADO RIVER AUTHORITY TARRANT CTY PUBLIC HEALTH LAB 6967 7007 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 433.94 433.94 ** 7,500.00 Budgeted 7,066.06 Remaining 6 % Used Account: 135-60010-010-000 Communications/Mobiles .00 .00 Account: 135-60010-010-000 Communications/Mobiles Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity 74 10/16/2020 October A/P Electricity -WW, Water 11,336.71 11,336.71 HUDSON ENERGY SERVICES, LLC 6915 AP Account: 135-60020-010-000 Electricity Totals: 11,336.71 11,336.71 ** 123,487.00 Budgeted 112,150.29 Remaining 9 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 141 10/26/2020 Pcard 09/29/2020 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SIGN-A-RAMA - 10/26/2020 SIGN-A-RAMA 165.00 351.00 165.00 516.00 SIGN-A-RAMA SIGN-A-RAMA PC PC Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 516.00 516.00 ** 1,000.00 Budgeted 484.00 Remaining 52 % Used glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 13 Check Source Number Account: 135-60070-010-00F Dues & Memberships Account: 135-60070-010-000 Dues & Memberships Total 500.00 Budgeted 500.00 Remaining 0 % Used .00 .00 Account: 135-60080-010-000 Schools & Training Account: 135-60080-010-000 Schools & Training Total 7,426.00 Budgeted .00 .00 7,426.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Safety Program 400.00 Budgeted Account: 135-60100-010-000 Travel & per diem Account: 135-60100-010-000 11,1 & per diem 2,875.00 Budgeted ■ .00 .00 400.00 Remaining 0 % Used 2,875.00 Remaining 0 % Used .00 .00 Account: 135-60105-010-000 qu Account: 135-60105-010-000 Rent/Lease Equipm 1,500.00 Budgeted 1,500.00 Remaining 0 Used .00 .00 Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 TCEQ Fees & Permi 30,000.00 Budgeted 30,000.00 Remaining 0 Used .00 .00 Account: 135-60150-010-000 Wholesale Water glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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 Detailed Accounting Trial Balance Page 14 214 10/31/2020 October A/P wholesale water ccoun : - -0 Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Account: 135-60280-010-000 54,579.12 2,596,295.00 Budgeted 2,541,715.88 Remaining 2 % Used Miscellaneous Expenses Miscellaneous Expense 200.00 Budgeted Property Maintenance 200.00 Remaining 0 % Used Property Maintenance 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-00 Lawn Equipment & Maintenance 201 10/31/2020 October A/P October Mowing Account: Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 14,000.00 Remaining Account: 135-60332-010-000 240 10/30/2020 TexPool Transfers October 240 10/30/2020 TexPool Transfers October TexPool O&M to 16Swift Rev I&S TexPool O&M to I&S- W&WW SYS Interfund Transfer Out -Rev I&S Totals: 565,820.00 Budgeted 514,381.87 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 75,000.00 Budgeted 75,000.00 Remaining 5 % Used 9 % Used 0 % Used 54,579 .00 .00 54,579.12 CITY OF FORT WORTH .00 .00 Mt• 6996 AP 750.00 750.00 WATTS ELLISON LLC 6982 AP 24,909.00 24,909.00 GL 26,529.13 51,438.13 GL .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65005-010-000 .00 .00 0 % Used 143 10/29/2020 October A/P fuel 524.19 524.19 US Bank Voyager Fleet Systems 6953 AP Account: 135-65005-010-000 15,000.00 Budgeted 14,475.81 Remaining 3 % Used Account: 135-6501 - 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 ANAZON.COM*2T4J20SH1 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 JUSTIN DISCOUNT BOOTS 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 ACADEMY SPORTS #141 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 ACADEMY SPORTS #141 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 Account: 135010-01 Uniforms' 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 107 10/22/2020 October A/P chemicals 107 10/22/2020 October A/P chemicals 107 10/22/2020 October A/P chemicals 107 10/22/2020 October A/P chemicals 107 10/22/2020 October A/P chemicals 143 10/29/2020 October A/P chlorine Account: 135 - Account: 135-65035-010-000 Account: 135-65035-010-000 • 1 Chemicals 25,000.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted 3,669.77 Remaining 29 % Used 23,321.67 Remaining 7 % Used 1,200.00 Remaining 0 % Used 326.20 326.20 AMAZON.COM*2T4J20SH1 PC 275.15 601.35 JUSTIN DISCOUNT BOOTS PC 161.94 763.29 ACADEMY SPORTS #141 PC 150.95 914.24 ACADEMY SPORTS #141 PC 175.00 1,089.24 RED WING SHOES 4573 PC 175.00 1,264.24 RED WING SHOES #573 PC 80.99 1,345.23 RED WING SHOES #573 PC 175.00 1,520.23 RED WING SHOES #573 PC 296.95 103.75 324.30 83.40 88.16 781.77 .00 296.95 HACH COMPANY 400.70 HACH COMPANY 725.00 HACH COMPANY 808.40 HACH COMPANY 896.56 HACH COMPANY 1,678.33 DPC INDUSTRIES, INC .00 00 6944 AP 6944 AP 6944 AP 6944 AP 6944 AP 6942 AP glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-65040-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2020 JE Detail Description/Comment Safety Equipment Account: 135-65040-010-0001 Safety Equipment 1,000.00 Budgeted Account: 135-65050-010-000 Meter Expense Account: 135-65050-010-000 Total Page 16 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 1,000.00 Remaining 0 % Used Meter Expense Totals: 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program Account: 135-65053-010-000 • Account: 135-69005-010-000 ■ 150 10/30/2020 October A/P 214 10/31/2020 October A/P 214 10/31/2020 October A/P Account: 135-69005-010-000 Account: 135-69008-010-000 .00 .00 .00 .00 70,000.00 Remaining 0 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Capital Outlays valve replacements Meadowbrook & Sundance waterline project 740,000.00 Budgeted Short Term Debt-Principa 689,529.45 .00 .00 0 % Used Remaining 7 % Used Account: 135-69008-010-000 Term Debt -Principal 30,962.00 Budgeted 30,962.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interes Account: 135-69009-010-000 Short Term Debt -Interest Totals: 2,324.00 Budgeted 2,324.00 Remaining 0 % Used 32,956.15 15,364.40 2,150.00 50,470.55 32,956.15 REY-MAR CONSTRUCTION 48,320.55 Jackson Construction, LTD 50,470.55 Halff Associates, INC .00 .00 .00 .00 .00 .00 00 6961 AP 7000 AP 6998 AP glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Detailed Accounting Trial Balance Page 17 Account: 35-6919W}0- Gasb34/Reserve for Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 Town Elevated Tank 130 10/01/2020 GASB Reserve Transfers FY 2021 Water Replacement Account:195-010-00 Account: 135-69281-010-000 Account: 135-69281-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 100 % Used 45,000.00 45,000.00 30,000.00 75,000.00 GL GL Water Tank Inspection Contract Water Tank Inspection Contract To 108,000.00 Budgeted 108,000.00 Remaining 0 Used .00 .00 glpdatb2 skrolczyk 17:58 11/11/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: 10/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 214 10/31/2020 October A/P water samples 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 7007 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 80.00 ** 2,000.00 Budgeted 1,920.00 Remaining 4 % Used Department 10 Totals: 300,273.87 ** 300,273.87 Monthly Total 5,327,164.00 Budgeted 5,026,890.13 Remaining 6 % Used glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number Account: JE Date 135-50005-020- 4 10/02/2020 113 10/02/2020 57 10/16/2020 114 10/16/2020 121 10/30/2020 Account: 135-50005-020-000 JE Description Salaries MUD payroll 10/2/2020 Salaries & Wages Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 20 Wastewater Period Ending: 10/2020 Beginning Balance JE Detail Description/Comment Revr Accr Sept FY20 Payroll #1 MUD Payroll 10/16/2020 Salaries & Wages Revr Accr Sept FY20 Payroll #2 MUD P/R 10/30/2020 Salaries & Wages Totals: 483,633.00 Budgeted 453,174.36 Remaining Account: 135-50010-020-0' 4 10/02/2020 MUD payroll 10/2/2020 Overtime 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Overtime 121 10/30/2020 MUD P/R 10/30/2020 Overtime Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 17,903.46 17,903.46 (17,903.46) .00 17,978.60 17,978.60 (5,423.42) 12,555.18 17,903.46 30,458.64 6 % Used 30,458.64 831.74 (831.74) 664.64 887.86 831.74 .00 664.64 1,552.50 Page 19 Check Source Number PR GL PR GL PR PR GL PR PR Account: 135 -50010 -020 - Account: 135-50016-020-000 Account: 135-50016-020-000 Account: 135-50017-020-00 57 10/16/2020 MUD Payroll 33,000.00 Budgeted Longevity • Longevir 7,420.00 Budgeted 10/16/2020 Certification Account: 135-50017-020-00 Certification 8,100.00 Budgeted plE?unt: 135-50020-020-00 4 10/02/2020 MUD payroll 10/2/2020 57 10/16/2020 MUD Payroll 10/16/2020 121 10/30/2020 MUD P/R 10/30/2020 rement Retirement Retirement Retirement 49,358.00 Budgeted 31,447.50 Remaining 7,420.00 Remaining 7,475.00 Remaining 1 Totals: 1 44,098.80 Remaining 5 % Used 0 % Used 8 % Used 11 % Used .00 625.00 1,734.89 1,784.24 1,740.07 .00 625.00 1,734.89 3,519.13 5,259.20 PR PR PR PR glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 20 Check Source Number 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 1,129.13 (1,129.13) 1,125.43 (316.46) 1,174.72 1,129.13 .00 1,125.43 808.97 1,983.69 PR GL PR GL PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,983.69 1,983.69 ** 32,993.00 Budgeted 31,009.31 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes Account: 135-50026-020-000 Medical Insurance Nir 4 10/02/2020 MUD payroll 10/2/2020 Medical Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Medical Insurance 3,869.82 3,869.76 3,869.82 7,739.58 PR PR Account: 135-50026-020-000 Medical Insurance Totals: 7,739.58 7,739.58 ** 122,035.00 Budgeted 114,295.42 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance 215.42 215.39 215.42 430.81 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 430.81 430.81 ** 6,443.00 Budgeted 6,012.19 Remaining 7 % Used Account: 135-50028-020-000 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance 34.89 34.89 34.89 69.78 PR PR Account: 135-50028-020-000 Vision Insurance Totals: 69.78 69.78 ** 1,098.00 Budgeted 1,028.22 Remaining 6 % Used Account: 135-50029-020-000 Life Insurance & Other 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits 179.16 209.88 179.16 389.04 METLIFE Humana GROUP Inc BENEFITS 6881 6880 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 389.04 389.04 ** 4,725.00 Budgeted 4,335.96 Remaining 8 % Used Account: 135-50030-020-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 1,129.13 (1,129.13) 1,125.43 (316.46) 1,174.72 1,129.13 .00 1,125.43 808.97 1,983.69 PR GL PR GL PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,983.69 1,983.69 ** 32,993.00 Budgeted 31,009.31 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes Account.1137T67576=611 Medicare Taxes 1 7,716.00 Budgeted Account: 135- Unemployment Taxes 4 10/02/2020 MUD payroll 10/2/2020 Unemployment Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Unemployment Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Unemployment Taxes Account: 135-50040-020- Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-020-00 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135-50045-020-00 Workman's Compensation 14,607.00 Budgeted Totals: - 7,252.05 Remaining 6 % Used 264.06 264.06 PR (264.06) .00 GL 263.20 263.20 PR (74.01) 189.19 GL 274.76 463.95 PR 21.51 21.51 (21.51) .00 21.81 21.81 (6.45) 15.36 21.50 36.86 1,403.14 Remaining 3 % Used 13,388.89 Remaining 8 % Used 1,218.11 1,218.11 PR GL PR GL PR GL Account: 135-50060-020-000 -re-emp -•ysaca a es in. Account: 135-50060-020-00' Pre-emp Physicals/Testing Total 400.00 Budgeted 400.00 Remaining 0 % Used .00 .00 Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Engineering glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-55005-020-000 JE Description Account: 135-55070-020-000 Account: 135-55070-020-000 Acc Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2020 JE Detail Beginning Balance Description/Comment Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining Independent Labor Independent Labor 15,000.00 Budgeted o.11111--A1118-t: October A/P 5-55080-020 107 10/22/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 143 10/29/2020 143 10/29/2020 143 10/29/2020 150 10/30/2020 150 10/30/2020 201 10/31/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 October October October October October October A/P A/P A/P A/P A/P A/P Maintenance & Repair= filters - 10/26/2020 ROANOKE WINNELSON CO Program: Transaction Detail .00 0 % Used 15,000.00 Remaining - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 THE HOME DEPOT #6581 PAYPAL *AQUARIUSTEC ROANOKE WINNELSON CO THE HOME DEPOT #6581 ROANOKE WINNELSON CO F B MCINTIRE EQUIPMENT THE HOME DEPOT 6581 filters and oil filters and oil filters and oil belts for bloers and wraps field labor Calibration of all Flow Meters Account: 135-55080-020-00 Maintenance & Repa otals: 108,000.00 Budgeted 102,743.27 Remaining 0 % Used 5 % Used .00 Transaction Vendor Name Detail (SUBTOTAL) .00 .00 330.00 330.00 RLC Controls 101.51 431.51 ROANOKE WINNELSON CO 48.09 479.60 THE HOME DEPOT #6581 388.60 868.20 PAYPAL *AQUARIUSTEC 27.00 895.20 ROANOKE WINNELSON CO 60.51 955.71 THE HOME DEPOT #6581 147.30 1,103.01 ROANOKE WINNELSON CO 1,024.85 2,127.86 F B MCINTIRE EQUIPMENT 81.99 2,209.85 THE HOME DEPOT 6581 270.00 2,479.85 DFW Compressor LLC 140.04 2,619.89 DFW Compressor LLC 235.00 2,854.89 DFW Compressor LLC 695.09 3,549.98 DFW Compressor LLC 920.00 4,469.98 NORTH TEXAS PUMP CO. 786.75 5,256.73 Prime Controls, LP Page 22 Check Source Number 6952 AP PC PC PC PC PC PC PC PC 6941 AP 6941 AP 6941 AP 6957 AP 6959 AP 6974 AP Account: 135-55081-020-000 Mainten & Repairs Collections Account: 135-55081-020-000 Account: 135-55085-020-000 Mainten & Repairs Collect' 157,500.00 Budgeted 157,500.00 Remaining 0 % Used .00 .00 .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 23 Account: 135-55085-020-000 Generator Maint. and Repair 10,000.00 Budgeted 10,000.00 Remaining Vehicle Maintenance 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 CLEAN STREAK AUTO SPA 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 CLEAN STREAK AUTO SPA 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SQ *CAR BODY LAB Account: 135-55090-020-000 Vehicle Maintenanc 4,000.00 Budgeted 2,551.50 Acco••^•• ' - - - .. Maintenance Collec - - 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 Account: 135-55105-020-00a Account: 135-55105-020-000 Account: 135-55120-020-000 Account: 135-55120-020-000 Remaining Veh Maintenance Collections Totals: 13,000.00 Budgeted 12,633.50 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 3,000.00 Remaining Cleaning Services Cleaning Services 1,500.00 Budgeted 0 % Used 36 Used 3 % Ueed 59.00 59.00 CLEAN STREAK AUTO SPA 485.50 544.50 DISCOUNT TIRE TXD 75 59.00 603.50 CLEAN STREAK AUTO SPA 845.00 1,448.50 SQ *CAR BODY LAB 366.50 366.50 .00 .00 0 % Used Totals: 1,500.00 Remaining 0 % Ueed .00 .00 DISCOUNT TIRE TXD 75 PC PC PC PC PC Account: 135-55125-020-000- Dempster Services 74 10/16/2020 October A/P sludge 1,187.92 1,187.92 L.H. CHANEY MATERIALS, INC. 6918 AP 143 10/29/2020 October A/P sludge 2,101.80 3,289.72 L.H. CHANEY MATERIALS, INC. 6946 AP 143 10/29/2020 October A/P Sludge haul off 1,066.40 4,356.12 L.H. CHANEY MATERIALS, INC. 6946 AP 204 10/31/2020 October A/P Sludge haul off 1,027.34 5,383.46 L.H. CHANEY MATERIALS, INC. 6966 AP Account: 135 1 Dumpster Services 100,000.00 Budgeted Totals: 94,616.54 Remaining 5 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 24 Account: 135-55135-020-000 Lab Analysis 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 201 10/31/2020 October A/P 201 10/31/2020 October A/P Lab testing lab testing lab testing lab testing lab testing lab testing Biomonitoring October 341.55 241.50 341.55 241.50 341.55 241.50 1,080.00 341.55 OXIDOR LABORATORIES LLC 583.05 OXIDOR LABORATORIES LLC 924.60 OXIDOR LABORATORIES LLC 1,166.10 OXIDOR LABORATORIES LLC 1,507.65 OXIDOR LABORATORIES LLC 1,749.15 OXIDOR LABORATORIES LLC 2,829.15 HUTHER AND ASSOCIATES,INC 6950 AP 6950 AP 6950 AP 6950 AP 6950 AP 6973 AP 6964 AP Account: 135-55135-020-000 Lab Analysis _ Totals: 2,829.15 2,829.15 ** 40,000.00 Budgeted 37,170.85 Remaining 7 % Used Account: 135-60010-020-000 Communications/Mobiles ■ .00 .00 Account: 135-60010-020-000 Communications/Mobiles Totals: .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity Electricity -WW, Water Electricity 9/29-10/28 1755 AR 20201031-20201031 User: 11,173.32 411.59 (29.73) 11,173.32 11,584.91 11,555.18 HUDSON ENERGY SERVICES, TRI COUNTY ELECTRIC LLC 6915 7009 AP AP AR 74 10/16/2020 October A/P 214 10/31/2020 October A/P 244 10/31/2020 Town Billed Invoice Account: 135-60020-020-000 Electricity = Totals: 11,555.18 11,555.18 ** 157,735.00 Budgeted 146,179.82 Remaining 7 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TCEQ EPAYMENT 113.75 113.75 TCEQ EPAYMENT PC Account: 135-60080-020-000 Schools & Training Totals: 113.75 113.75 ** 4,991.00 Budgeted 4,877.25 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,575.00 Budgeted 1,575.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 150 10/30/2020 October A/P WWTP permit FY 2021 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 6962 AP Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 9,888.02 9,888.02 ** 45,000.00 Budgeted 35,111.98 Remaining 22 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 26 Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 0 % Used 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 201 10/31/2020 October A/P October Mowing Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 13,110.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 .00 .00 890.00 890.00 WATTS ELLISON LLC 6982 AP 6 % Used 10,425.55 10,425.55 �Interfund Transfer Out -Tax I&S Tot 10,425.55 114,681.00 Budgeted 104,255.45 Remaining 9 % Used Account: 135-60332-020- erfund Tranef� Rev I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account:nterfund Transfer Out -Rev I&S Totals 688,005.00 Budgeted 625,459.13 Remaining Account: 135-60334-020-000 Interfund Transfer ouP Account: 135-60334-020-000 Interfund Transfer 75,000.00 Budgeted 75,000.00 Remaining Account: 135-60360-0 re/Equipmen 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 EPARTSFAST.COM 54,621.59 54,621.59 7,924.28 62,545.87 9 % Used .00 .00 0 % Used 35.90 35.90 EPARTSFAST.COM GL GL GL PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-60360-020-000- Furniture/Equipment o $5000 Tota 2,000.00 Budgeted 1,964.10 Remaining AC 143 10/29/2020 October A/P Account: 135-65005-020-00: Account: 135-65010-020-000 Account: 135-65010-020-000 35 2 % Ueed Fuel & Lube fuel 650.07 650.07 US Bank Voyager Fleet Systems 6953 AP Fuel & Lube Totals: 12,500.00 Budgeted Uniforms Uniforms - 6,280.00 Budgeted 11,849.93 Remaining 5 % Used Account: 135-65030-020-000 Alall Chemicals 77 10/16/2020 October A/P plymer for press 107 10/22/2020 October A/P CIP solution Account: Chemicals 25,000.00 Budgeted Chemicals Collections Account: 135-65031-020-000 Chemicals Collections 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-02 quipment 107 10/22/2020 October A/P nitrile gloves 650.07 ** .00 .00 V Totals: .00 6,280.00 Remaining 0 % Used 21,425.90 Remaining 14 % Used 2,856.60 2,856.60 POLYDYNE, INC 6919 AP 717.50 3,574.10 Valley Solvent Company, INC 3,574.10 ** .00 .00 Totals: 17,500.00 Remaining 0 % Used .00 ** .00 .00 1,200.00 Remaining 0 % Used 252.00 252.00 LOU'S GLOVES INCORPORATED 6954 AP 6948 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-65040-020-000 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 77 10/16/2020 October A/P Account: 135-65045-020-000 M. Account: -69005-, 77 10/16/2020 October A/P 77 10/16/2020 October A/P Account: 135-69005-020-00 Safety Equipment Tota 1,200.00 Budgeted 948.00 Remaining Lab Supplies • lab supplies lab supplies lab supplies lab supplies lab supplies lab supplies Lab Supplies 28,000.00 Budgeted Capital Outlays manhole rehab manhole rehab 21 Ueed 630.16 952.00 1,271.91 143.14 229.33 1,337.34 630.16 IDEXX DISTRIBUTION, INC 1,582.16 IDEXX DISTRIBUTION, INC 2,854.07 IDEXX DISTRIBUTION, INC 2,997.21 IDEXX DISTRIBUTION, INC 3,226.54 IDEXX DISTRIBUTION, INC 4,563.88 HACH COMPANY 4,563.88 ** ' 23,436.12 Remaining 16 % Used Capital Outlays - Totals: 335,000.00 Budgeted 6916 AP 6916 AP 6916 AP 6916 AP 6916 AP 6914 AP 3,812.00 3,812.00 REY-MAR CONSTRUCTION 6921 AP 3,812.00 7,624.00 REY-MAR CONSTRUCTION 6921 AP 327,376.00 Remaining 2 % Ueed 7,624.00 ** Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 81,273.00 Budgeted 81,273.00 Remaining .00 .00 0 % Ueed .00 ** . • . Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt-Intere 8,532.00 Budgeted 8,532.00 Account: 135-69195-03.221 Gasb34/Reserve for Replacement 130 10/01/2020 GASS Reserve Transfers FY 2021 Sewer Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 WWTP MBR Replacement Remaining 0 % Used .00 .00 30,000.00 30,000.00 100,000.00 130,000.00 GL GL glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 29 Check Source Number Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 307,629.82 Monthly Total 307,629.82 ** 3,026,690.00 Budgeted 2,719,060.18 Remaining 10 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/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- Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct .79 .79 GL Acil Workman's Compensation Total 30.00 Budgeted 29.21 Remaining 3 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 111 Dues & Memberships Account: - - - Dues & Memberships 'Totals: 750.00 Budgeted 0 % Used .00 .00 .00 750.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SQ *KELLER TROPHY AND Account: 135-60075-026-00 Meeting. 1,300.00 Budgeted 1,210.50 Remaining 7 Used 89.50 Account: 135-60080-026-000 Account: 135-60080-026-000 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem Account: 135-60100-026-000 Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 89.50 SQ *KELLER TROPHY AND .00 .00 .00 PC Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/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 i+ Department 26 Totals: 2,000.00 Budgeted 2,000.00 Remaining 0 % Used 90.29 Monthly Total 13,230.00 Budgeted 90.29 •• 13,139.71 Remaining 1 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 32 Account: 135-50005-030-000 Salaries & Wages 4 10/02/2020 MUD payroll 10/2/2020 Salaries & Wages 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Salaries & Wages 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Salaries & Wages 21,151.78 (21,151.78) 21,141.69 (6,342.44) 19,834.99 21,151.78 .00 21,141.69 14,799.25 34,634.24 PR GL PR GL PR Account: 135-50005-030-000 Salaries & Wages Totals: 34,634.24 W34,634.24 ** 626,592.00 Budgeted 591,957.76 Remaining 6 % Used Account: 135-50010-030-000 Overtime .00 .00 Account: 135-50010-030-000 Overtime Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 2,668.00 Budgeted 2,668.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 4 10/02/2020 MUD payroll 10/2/2020 Retirement 57 10/16/2020 MUD Payroll 10/16/2020 Retirement 121 10/30/2020 MUD P/R 10/30/2020 Retirement 1,958.66 1,957.70 1,836.74 1,958.66 3,916.36 5,753.10 PR PR PR Account: 135-50020-030-000 Retirement Totals: 5,753.10 5,753.10 ** 58,550.00 Budgeted 52,796.90 Remaining 10 % Used Account: 135-50026-030-000 Medical Insurance 4 10/02/2020 MUD payroll 57 10/16/2020 MUD Payroll 10/2/2020 Medical Insurance 10/16/2020 Medical Insurance 3,985.11 3,985.06 3,985.11 7,970.17 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 7,970.17 7,970.17 ** 136,834.00 Budgeted 128,863.83 Remaining 6 % Used Account: 135-50027-030-000 Dental Insurance glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 33 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance Account: 135-50027-03 Dental Insurance Total= 7,109.00 Budgeted 6,667.04 Remaining Account: 135-50028-030-009 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance Account: 135-50028-030-000 Vision Incur- 1,138.00 Budgeted Account :_AdiiiiiIIMIrarialrath 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits Account: 135-5002 - - 1,072.40 Remaining Life Insurance & Other Totals: 4,730.00 Budgeted 6 6 220.99 220.97 Used Used 32.81 32.79 197.79 209.22 4,322.99 Remaining 9 % Used Account: 135-50030-030-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Acer Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 220.99 441.96 32.81 65.60 197.79 METLIFE GROUP BENEFITS 407.01 Humana Inc 1,214.53 1,214.53 (1,214.53) .00 1,210.46 1,210.46 (357.68) 852.78 1,240.92 2,093.70 Account: 135-50030-030W Social Security Taxes Totals: 39,138.00 Budgeted 37,044.30 Remaining 5 % Ueed Account: 135-50035-030-000 Medicare Taxes 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes Account: 1 icare Taxes Totals: 9,153.00 Budgeted 8,663.36 Remaining 5 % Used PR PR 6881 PR PR AP 6880 AP PR GL PR GL PR 284.07 284.07 PR (284.07) .00 GL 283.07 283.07 PR (83.65) 199.42 GL 290.22 489.64 PR glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 34 Check Source Number Account: 135-50040-030-000 Unemployment Taxes Account: 135-50040-030-000 Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 50045-030-000 Workman's Compensation 1,573.00 Budgeted Total 1,440.00 Remaining Totals: 1,444.50 Remaining 0 % Used .00 128.50 8 % Used .00 128.50 GL Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: - - - Pre-emp Physicals/Testing 500.00 Budgeted Account: 135-50070-030-000 Employee Relations 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 FTD.COM Account: 135-50070-030-001 Employee Relations 8,000.00 Budgeted Account: 135-55030-03. 3 10/01/2020 20 10/05/2020 43 10/08/2020 74 10/16/2020 107 10/22/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 201 10/31/2020 214 10/31/2020 214 10/31/2020 October A?P October A/P October A/P October A/P October A/P Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 October A/P October A/P October A/P - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 500.00 Remaining 7,921.17 Remaining Annual GIS Code Red Scada licensing internet-october FS *FREEMAKE ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS Software training/help GIS support STW Annual Renewal FY 21 126,854.00 Budgeted Totals: 93,687.06 Remaining .00 0 % Used 1 % Used 26 % Used 78.83 .00 78.83 FTD.COM 484.00 484.00 7,500.00 7,984.00 3,853.50 11,837.50 495.00 12,332.50 899.00 13,231.50 1.01 13,232.51 74.52 13,307.03 225.16 13,532.19 36.78 13,568.97 253.75 13,822.72 2,544.22 16,366.94 16,800.00 33,166.94 M3 Networks Halff Associates, INC Onsolve Intermediate Holding WIN -911 SOFTWARE Charter Communications FS *FREEMAKE ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS OpenGov, Inc Halff Associates, INC OpenGov, Inc PC 6811 AP 6879 AP 6906 AP 6924 AP 6939 AP PC PC PC PC 6972 AP 6998 AP 7004 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-55070-030-009' Independent Labor Account: 135-55070-030-000 Independent Labor Totals: 15,000.00 Budgeted 15,000.00 Remaining 0 % Used .00 .00 Account: 135-55080-030-000 Maintenance & Repairs 77 10/16/2020 October A/P Lighting upgrades front entry 2,686.00 2,686.00 R & D Electric 6920 AP 107 10/22/2020 October A/P A/C 150.00 2,836.00 BRANDON R REED 6938 AP 107 10/22/2020 October A/P A/C annex bldg 340.00 3,176.00 BRANDON R REED 6938 AP 107 10/22/2020 October A/P office a/c 125.00 3,301.00 BRANDON R REED 6938 AP 143 10/29/2020 October A/P fire alarm maintenance 260.68 3,561.68 PRO FIRE & SPRINKLER LLC 6951 AP Maintenance & Repairs 40,000.00 Budgeted 36,438.32 Remaining 9 % Ueed Account: 135-55085-030-000 ' Generator Maint. and Repair Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55120-030-000 Cleaning Services 107 10/22/2020 October A/P Cleaning -admin initial cleanin Account: 135-55120-030-000 Cleaning Services 15,000.00 Budgeted .00 .00 0 % Ueed 14,925.00 Remaining 1 % Used Account: 135-55160-030-000 Professional Outside Services 2 10/01/2020 October A/P FY 21 Annual IT Contract Account: 135-55160-030-000 Professional Outside Sery 104,925.00 Budgeted 47,049.00 Remaining 55 % Used Account: 135-55205-03 - lity Billing Cont 214 10/31/2020 October A/P Water billings -October Account Utility Sill Totals: 9,000.00 Budgeted 8,417.73 Remaining 6 % Used 75.00 75.00 MEMBER'S BUILDING MAINTENANCE 6949 AP 57,876.00 57,876.00 57,876.00 M3 Networks 6811 AP 582.27 582.27 DATAPROSE LLC 6997 AP 582.27 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60005-03 2 10/01/2020 October A/P 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 44 10/31/2020 October A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 10/2020 JE Detail Description/Comment Answering SVc-Oct RINGCENTRAL, INC 8X8, INC. Answering SVc-Nov Page 36 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-b,,Telephon Totals: 9,680.00 Budgeted 9,239.09 Remaining Account: 135-60010-030-000 Communications/Mobiles 57 10/16/2020 MUD Payroll 10/16/2020 Communications/Mobiles Account: 135-60010-030-000 Account: 135-60020-030-000 74 10/16/2020 October A/P Account: 135-60020-030-000 Account: 135-60025-030-0: 201 10/31/2020 October A/P AC 143 10/29/2020 October A/P 214 10/31/2020 October A/P Account: 135-60040-030- 201 10/31/2020 October A/P 237 10/31/2020 Pace Credit Card Fees 237 10/31/2020 Pace Credit Card Fees omm , icatione/Mobil 3,000.00 Budgeted 2,775.00 Electricity admin bldg Electricity/Gas ■ 14,512.00 Budgeted 5,000.00 30,000.00 ater-October Budgeted Remaining 13,978.93 Remaining 4,679.90 Postage lease Water billings -October Budgeted Service Charges & Fees Dig Tess -Oct Remaining 5 % Used 8 Used 4 % Used 6 Used 28,224.38 Remaining 6 % Used 194.75 194.75 KEYSTONE PARK SECRETARIAL 6807 AP 16.76 211.51 RINGCENTRAL, INC PC 34.65 246.16 8X8, INC. PC 194.75 440.91 KEYSTONE PARK SECRETARIAL 6903 AP 225.00 225.00 533.07 533.07 HUDSON ENERGY SERVICES, LLC 320.10 320.10 TROPHY CLUB MUD (WATER BILLS) 107.67 107.67 FRANCOTYP-POSTALIA, INC. 1,667.95 1,775.62 DATAPROSE LLC 1 PR 6915 AP 6981 AP 6943 AP 6997 AP 265.05 265.05 Texas Excavation Safety System 6979 AP 7,699.73 7,964.78 GL 56.15 8,020.93 GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 37 Account: 135 AC Account - Service Charges & Fees 67,000.00 Budgeted 58,979.07 Remaining Bad Debt Expense Bad Debt Expense 1,500.00 Budgeted Accountlice 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135 - 12 % Used 1,500.00 Remaining 0 % Used .00 6,724.87 .00 6,724.87 GL 84,000.00 Budgeted 77,275.13 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts Account: 135-60066-030-000 Publications/Books/Subscri: 1,000.00 Budgeted 1,000.00 Remaining Accountil Dues & Memberships 214 10/31/2020 October A/P Annual membership dues Acc Dues & Memberships 6,000.00 Budgeted Meetings 0 % Used 5,900.00 Remaining 2 % Used .00 .00 100.00 100.00 NORTH CENTRAL TX COG 7003 AP .00 .00 400.00 Budgeted Account: 135 Public Education 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DEEDS.COM 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DEEDS.COM 400.00 Remaining 0 % Used 61.00 61.00 DEEDS.COM PC 50.00 111.00 DEEDS.COM PC glpdatb2 skrolczyk 17:58 11/11/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 Program: Period Ending: 10/2020 Page 38 JE Detail Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Description/Comment Account: 135-60079-03t Public Education 6,000.00 Budgeted 5,889.00 Remaining Accgi & Training 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 UNT COMMERCE MANAGER Account: 135-60080-030-00 Schools & Training Totals: Account 6,850.00 Budgeted el & per diem 57 10/16/2020 MUD Payroll 10/16/2020 Travel & per diem Account: 135- - - Travel & per diem Account: 135-60110-030-000 Account: 135-60110-030-00: Account: 135-60115-030- 2 % Ueed 6,775.00 Remaining 1 % Used Totals: 3,575.00 Budgeted 3,479.66 Remaining 3 % Used Physicals/Testing Physicals/Testing 200.00 Budgeted 200.00 Remaining 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 IN *TIN -TRANSLATION IN 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 AMEN MRTP IIS*MR83435Q0 -030- Elections I 5,000.00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted Account: 135-60235-030-000 0 % Used 111.00 ** 75.00 75.00 UNT COMMERCE MANAGER .00 ** 95.34 95.34 .00 .00 45.63 45.63 IN *TIN -TRANSLATION IN 13.80 59.43 AMEN MRTP US*MR83435Q0 r Totals: 4,940.57 Remaining 1 % Used .00 .00 2,500.00 Remaining 0 % Used .00 .00 PC PR PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-60235-03t Account: 135-60245-030-000 Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Account: 135-60285-030-000 201 10/31/2020 October A/P Account: 135-60285-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Security 1,288.00 Budgeted Miscellaneous Expenses 1,288.00 Remaining 0 % Used Miscellaneous Expenses 500.00 Budgeted General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Lawn Equipment & Maintenance October Mowing 500.00 Remaining 0 % Used Lawn Equipment & Maintenan 5,000.00 Budgeted Furniture/Equipment < 4,910.00 Remaining Furniture/Equipment < $5000 2,500.00 Budgeted 2,500.00 Remaining Uniforms= 0 % Used 2 Used .00 .00 .00 .00 90.00 90.00 WATTS ELLISON LLC .00 .00 0 % Used .00 .00 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware .00 .00 6982 AP glpdatb2 ekrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-65055-03t JE Description 150 10/30/2020 October A/P 150 10/30/2020 October A/P 204 10/31/2020 October A/P 204 10/31/2020 October A/P Account: 135-65085-030-000 Account: 135-65095-030-000 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 Account: 135-65095-030-000 Account: 135-65105-030-00 Account: 135-6510 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 pount: 135-69005-030-00 150 10/30/2020 October A/P Account: 135-69005-0 Account: 135-69170-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2020 JE Detail Beginning Balance Description/Comment Hardware 20,253.00 Budgeted Office Supplies office supplies office supplies office supplies office supplies Office Suppl 6,000.00 Budgeted - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 20,253.00 Remaining 5,306.48 TOM THUMB #1789 SAMSCLUB.COM AMZN MRTP US*2TOBS7XQ2 SAMS CLUB #6781 AMZN MKTP US*2T75F3P21 AMAZON.COM*MR34J1WI0 AMAZON.COM*MR59N5YY0 Maintenance Supp 4,000.00 Budgeted 14111111* 2,500.00 Budgeted Remaining 3,816.22 Remaining 2,500.00 Remaining Capital Outl. Elements XS annual subecriptio Capital Outlays 138,000.00 Budgeted 91,175.00 Remaining Copier Lease Installments Program: Transaction Detail 0 % Used 12 Used 5 % Used 0 % Used 34 % Used Transaction Vendor Name Detail (SUBTOTAL) 0 .00 ** 283.93 8.62 133.63 267.34 283.93 292.55 426.18 693.52 Page 40 Check Source Number OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 9.71 9.71 TOM THUMB #1789 63.10 72.81 SAMSCLUB.COM 8.99 81.80 AMZN MKTP US*2TOBS7XQ2 31.83 113.63 SAMS CLUB #6781 48.58 162.21 AMZN MKTP US*2T75F3P21 9.88 172.09 AMAZON.COM*MR34J1W10 11.69 183.78 AMAZON.COM*MX59N5YY0 00 46,825.00 46,825.00 00 46,825.00 Novotx 6960 AP 6960 AP 6971 AP 6971 AP 6958 PC PC PC PC PC PC PC AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 48 10/09/2020 October A/P New copier lease 175.00 175.00 ND5 Leasing 6905 AP Account: 135-69170-030-000 Copier Lease Installments Totals: 175.00 175.00 ** 4,000.00 Budgeted 3,825.00 Remaining 4 % Used Department 30 Totals: 213,773.21 ** 213,773.21 Monthly Total 1,669,512.00 Budgeted 1,455,738.79 Remaining 13 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/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- Legal 214 10/31/2020 October A/P legal 1,397.50 1,397.50 McLean & Howard, L.L.P. Accir Legal 135,000.00 Budgeted 133,602.50 Remaining 1 % Ueed Account: 135-55055-039-000 Auditing .00 .00 Account: 135-55055-039-000 Auditing Totals: - 33,800.00 Budgeted 33,800.00 Remaining 0 % Ueed Account: 135-55060-039-000 Appraisal 126 10/22/2020 TAD Entity Refund (107.67) (107.67) Account: 135-55060-039-00 Appraisal 11,925.00 Budgeted 12,032.67 Remaining -1 % Ueed 7001 AP GL Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 `Tax Admin Fees 4,850.00 Budgeted 4,850.00 Remaining 0 % Used .00 .00 .00 .00 ** Department 39 Totals: 1,289.83 ** 1,289.83 Monthly Total 185,575.00 Budgeted 184,285.17 Remaining 1 5 Used Fund 135 Totals: 43,144.44 43,144.44 Monthly Total (5,106.00) Budgeted (48,250.44) Remaining #888###### glpdatb2 skrolczyk 17:58 11/11/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 43 Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer -General Fund 130 10/01/2020 GASH Reserve Transfers FY 2021 Town Elevated Tank 130 10/01/2020 GASH Reserve Transfers FY 2021 Water Replacement 130 10/01/2020 GASH Reserve Transfers FY 2021 Sewer Replacement 130 10/01/2020 GASH Reserve Transfers FY 2021 WWTP MBR Replacement (45,000.00) (30,000.00) (30,000.00) (100,000.00) (45,000.00) (75,000.00) (105,000.00) (205,000.00) GL GL GL GL Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 ■ Intergov Transfer -General Fund Totals: (205,000.00) (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept 130 10/01/2020 GASH Reserve Transfers FY 2021 Fire Truck Future Replacement (81,420.00) (81,420.00) GL Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 486,413 TOTAL ASSETS 486,413 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES 56 TOTAL FUND BALANCE (199,064) TOTAL LIABILITIES AND FUND BALANCE 486,413 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 517-49011-000-000 Interest Income 55.76- 55.76- 55.76 Page 14 Subtotal: 55.76- 55.76- 55.76 Program number: 55.76- 55.76- 55.76 Department number: Revenues 55.76- 55.76- 55.76 Revenues Subtotal 55.76- 55.76- 55.76 I Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 55.76- 55.76- 55.76 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/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 239 10/31/2020 Bank Interest- October (55.76) (55.76) GL Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 55.76 Remaining 0 % Used Department Totals: (55.76) ** (55.76) Monthly Total .00 Budgeted 55.76 Remaining 0 % Used Fund 517 Totals: (55.76) (55.76) Monthly Total .00 Budgeted 55.76 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 1 OPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,973 TOTAL ASSETS 784,973 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 703,276 6 703,282 784,973 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 6.45- 6.45- 6.45 Page 15 Subtotal: 6.45- 6.45- 6.45 Program number: 6.45- 6.45- 6.45 Department number: Revenues 6.45- 6.45- 6.45 Revenues Subtotal 6.45- 6.45- 6.45 I Fund number: 519 2016 Rev Bond Const -SWIFT 6.45- 6.45- 6.45 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 10/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 239 10/31/2020 Bank Interest- October (6.45) (6.45) GL Account: 519-49011-000-000 Interest Income Totals: Department Totals: .00 Budgeted 6.45 Remaining 0 % Used (6.45) Monthly Total .00 Budgeted (6.45) ** 6.45 Remaining 0 % Used Fund 519 Totals: (6.45) (6.45) Monthly Total .00 Budgeted 6.45 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2020 MI TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 258,888 INVESTMENTS 3,892,557 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,151,445 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 2,539 TOTAL LIABILITIES 2,539 FUND BALANCE ASSIGNED FUND BALANCE 4,151,382 NET REVENUES / EXPENDITURES (2,476) TOTAL FUND BALANCE 4,148,906 TOTAL LIABILITIES AND FUND BALANCE 4,151,445 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment Account Description 520-49011-000-000 Interest Income Subtotal: Department number: Revenues Subtotal 62.51- 62.51- 62.51 62.51- 62.51- 62.51- 62.51- 62. 62.51- 62.51- 62. 62.51- 62.51- 62. Page 16 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 10/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,538.78 Program: YTD Total 2,538.78 % of Remaining Budget Budget 2,538.78 - Page 17 Subtotal: 2,538.78 2,538.78 2,538.78 - Program number: 2,538.78 2,538.78 2,538.78 - Department number: Water Department 2,538.78 2,538.78 2,538.78 - Expenditures Subtotal 2,538.78 2,538.78 2,538.78 - Fund number: 520 Revenue Bond 16" Waterline 2,476.27 2,476.27 2,476.27- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accolmt:52(1-0alialgilL Interest Income 239 10/31/2020 Bank Interest- October (30.51) (30.51) GL 239 10/31/2020 Bank Interest- October (32.00) (62.51) GL Account: 520-490 Interest Income Totals: .00 Budgeted 62.51 Remaining 0 % Used Department Totals: (62.51) ** (62.51) Monthly Total .00 Budgeted 62.51 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/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 214 10/31/2020 October A/P 16' waterline project 2,538.78 2,538.78 Halff Associates, INC 6998 AP Account: 520-69005-010-000 Capital Outlays Totals: 2,538.78 2,538.78 ** .00 Budgeted (2,538.78) Remaining 0 % Used Department 10 Totals: 2,538.78 ** 2,538.78 Monthly Total .00 Budgeted (2,538.78) Remaining 0 % Used Fund 520 Totals: 2,476.27 2,476.27 Monthly Total .00 Budgeted (2,476.27) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE NI TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,969 TOTAL ASSETS 893,969 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 893,867 101 893,969 893,969 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 Interest Income 10,000.00- 10,000.00 - Subtotal: 10,000.00- 10,000.00 - Program number: 10,000.00- 10,000.00 - Department number: = 10,000.00- 10,000.00 - Revenues Subtotal 10,000.00- 10,000.00 - Fund number: 528 2015 Revenue Bond Reserve Fund 10,000.00- 10,000.00- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 101.33- 1.013 1.013 1.013 1.013 1.013 1.013 9,898.67- 9, 9, 9,898. 9,898 9,898 Page 18 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 48 Account: 528-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (101.33) Account: 528-49011-000-000 come Total (10,000.00) Budgeted (9,898.67) Remaining 1 % Used Department Totals: Fund 528 Totals: (101.33) Monthly Total (10,000.00) Budgeted (101.33) Monthly Total (10,000.00) Budgeted (101.33) GL (101.33) ** (9,898.67) Remaining 1 % Used (101.33) (9,898.67) Remaining 1 % Used TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS 51,561 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 662,454 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 714,015 LE TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 662,454 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 662,454 FUND BALANCE ASSIGNED FUND BALANCE 34,511 NET REVENUES / EXPENDITURES 17,050 TOTAL FUND BALANCE 51,561 TOTAL LIABILITIES AND FUND BALANCE 714,015 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 691,010.00- 1,000.00- 2,000.00- 691,010.00- 1,000.00- 2,000.00- 4,992.76- 4,992.76- .723 686,017.24- 1,615.99- 1,615.99- 161.599 615.99 11.54- 11.54- .577 1,988.46 - Page 19 Subtotal: 533-49011-000-000 533-49015-000-000 533-49141-000-000 Mr - Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 197,281.00- 114,681.00- 694,010.00- 5,000.00- 197,281.00- 114,681.00- 6,620.29- 4.12- 10,425.55- 6,620.29- 4.12- 10,425.55- .082 9.091 687, 4,995.88- 197,281.00- 104,255.45 - Subtotal: 316,962.00- 316,962.00- 10,429.67- 10,429.67- 3.291 306,532.33 - Program number: 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04 - Department number: Revenues 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04 - Revenues Subtotal 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04- glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 20 533-70005-051-000 Paying Agent Fee 2,900.00 2,900.00 2,900.00 I 533-70025-051-000 Bond Interest Expense -Tax 190,073.00 190,073.00 190,073.00 I 533-70035-051-000 Bond Principal Payment -Tax 810,000.00 810,000.00 810,000.00 I Subtotal: 1,002,973.00 1,002,973.00 1,002,973.00 Program number: 1,002,973.00 1,002,973.00 1,002,973.00 Department number: Administration 1,002,973.00 1,002,973.00 1,002,973.00 Expenditures Subtotal 1,002,973.00 1,002,973.00 1,002,973.00 Fund number: 533 MUD 1 I&S Consolidated 7,999.00- 7,999.00- 17,049.96- 17,049.96- 213.151 9,050.96 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 L Property Taxes 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes (140.22) (140.22) GL (298.33) (438.55) GL (530.46) (969.01) GL (283.53) (1,252.54) GL (432.42) (1,684.96) GL (193.49) (1,878.45) GL (120.12) (1,998.57) GL (302.01) (2,300.58) GL (556.85) (2,857.43) GL (675.38) (3,532.81) GL (508.21) (4,041.02) GL (291.24) (4,332.26) GL (660.50) (4,992.76) GL Account: 533-40000-000-000 Property Taxes Totals: (4,992.76) (4,992.76) ** (691,010.00) Budgeted (686,017.24) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (28.63) 204.15 (1,772.28) (5.79) (10.89) (2.55) (28.63) 175.52 (1,596.76) (1,602.55) (1,613.44) (1,615.99) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,615.99) (1,615.99) ** (1,000.00) Budgeted 615.99 Remaining 162 % Used Account: 533-40015-000-000 Property Taxes/P & I 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (6.38) (6.38) GL (1.74) (8.12) GL (2.73) (10.85) GL (.69) (11.54) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: 4) (11.54) ** (2,000.00) Budgeted (1,988.46) Remaining 1 % Used Account: 533-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (4.12) (4.12) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49011-000-000 Interest Income (4.12) (5,000.00) Budgeted (4,995.88) Remaining 0 % Used Account: 533-49015-000-000 ` Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: (197,281.00) Budgeted (197,281.00) Remaining 0 % Used Account: 533-49141-00 d Trans In -PID Surchg 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- PID Debt (10,425.55) (10,425.55) GL Account: 533-49 Interfund Trans In -PID Surchg Totals: 7 (114,681.00) Budgeted (104,255.45) Remaining 9 % Used Department Totals: (17,049.96) ** (17,049.96) Monthly Total (1,010,972.00) Budgeted (993,922.04) Remaining 2 % Used glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 51 Check Source Number Department 51 Totals: Fund 533 Totals: .00 Monthly Total (17,049.96) Monthly Total 1,002,973.00 Budgeted 1,002,973.00 Remaining .00 ** 0 % Used (17,049.96) (7,999.00) Budgeted 9,050.96 Remaining 213 % Used Account: 533-70005-051-000 Paying Agent Fee .00 .00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,900.00 Budgeted 2,900.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax .00 .00 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 .00 ** 190,073.00 Budgeted 190,073.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 ** 810,000.00 Budgeted 810,000.00 Remaining 0 % Used Department 51 Totals: Fund 533 Totals: .00 Monthly Total (17,049.96) Monthly Total 1,002,973.00 Budgeted 1,002,973.00 Remaining .00 ** 0 % Used (17,049.96) (7,999.00) Budgeted 9,050.96 Remaining 213 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 80,613 TOTAL ASSETS 80,613 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 25,988 54,625 80,613 TOTAL LIABILITIES AND FUND BALANCE 80,613 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 534 2015 Revenue Bond I&S Account Description 534-49011-000-000 Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 600,838.00- Subtot Program number: Department number: Revenues Revenues Subtotal 6031111110- 60331110- 603.'38.00- 603,338.00- 2,500.00- 600,838.00- 60 338.00- 603,338.00- 603,338.00- 603,338.00- 3.38- 54,621.59- 3.38- 54,621.59- 54,624.97- .135 2,496.62- 9.091 546,216.41- 9.054 548,713.03- 9.054 9.054 9.054 548,713.03- 548,713.03- 548,713.03 - Page 21 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 534-70005-051-000 1 534-70040-051-000 1 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bond Interest Expense Revenue Bond Principal Expense 400.00 200,438.00 400,000.00 400.00 200,438.00 400,000.00 400.00 200,438.00 400,000.00 Page 22 Subtotal: X00,838.00 600,838.00 Program number: 600,838.00 600,838.00 600,838.00 Department number: Administration 600,838.00 600,838.00 600,838.00 Expenditures Subtotal 600,838.00 600,838.00 600,838.00 p Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,624.97- 54,624.97- 2,184.999 52,124.97 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 534 2015 Revenue Bond I8S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (54,624.97) Monthly Total (603,338.00) Budgeted (54,624.97) ** (548,713.03) Remaining 9 % Used Account: 534-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (3.38) (3.38) GL Account: 534-49011-000-000 Interest Income Totals: (3.38) (3.38) ** (2,500.00) Budgeted (2,496.62) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S (54,621.59) (54,621.59) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,621.59) (54,621.59) ** (600,838.00) Budgeted (546,216.41) Remaining 9 % Used Department Totals: (54,624.97) Monthly Total (603,338.00) Budgeted (54,624.97) ** (548,713.03) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 10/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 Account: 534-70005-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 200,438.00 Budgeted 200,438.00 Remaining Account: 534-70045-051-000 Revenue Bond Principal Expense A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 400,000.00 Budgeted 400,000.00 Remaining Department 51 Totals: .00 Monthly Total O % Used • O % Used .00 .00 .00 .00 .00 ** .00 .00 O % Used .00 ** .00 ** 600,838.00 Budgeted 600,838.00 Remaining 0 % Used Fund 534 Totals: (54,624.97) (54,624.97) Monthly Total (2,500.00) Budgeted 52,124.97 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,534 TOTAL ASSETS 30,534 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,625 24,910 30,534 TOTAL LIABILITIES AND FUND BALANCE 30,534 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account Description 535-49011-000-000 Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,000.00- 535-49142-000-000 Interfund Tran In -Water Sales 273,999.00- Subtot Program number: 0 Department number: 111=99.00 - Revenues Subtotal 274,999.00 - Revenues 1,000.00- 273,999.00- 274,999' 274,999.00- 274,999.00- 274,999.00- .80- 24,909.00- .80- .080 999.20- 24,909.00- 9.091 249,090.00- 9.80- II 9.058 9.058 24,909.80- 24,909.80- 9.058 250,089.20- 24,909.80- 24,909.80- 9.058 250,089.20- 24,909.80- 250,089.20 - Page 23 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 535-70040-051-000 535-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 58,599.00 215,000.00 400.00 58,599.00 215,000.00 Subtotal: ,IIW273,999.00 273,999.00 Program number: III 273,999.00 273,999.00 Department number: Administration mEr 273,999.00 273,999.00 Expenditures Subtotal 273,999.00 273,999.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 1,000.00- 1,000.00- 400.00 58,599.00 215,000.00 11141.44.111 273,999.00 273,999.00 23,909.80 24,909.80 - 24,909.80- 2,490.980 Page 24 glpdatb2 skrolczyk 17:58 11/11/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: 10/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (24,909.80) Monthly Total (274,999.00) Budgeted (24,909.80) ** (250,089.20) Remaining 9 % Used Account: 535-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (.80) (.80) GL Account: 535-49011-000-000 Interest Income Totals: (.80) (.80) ** (1,000.00) Budgeted (999.20) Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to 16Swift Rev I&S (24,909.00) (24,909.00) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (24,909.00) (24,909.00) ** (273,999.00) Budgeted (249,090.00) Remaining 9 % Used Department Totals: (24,909.80) Monthly Total (274,999.00) Budgeted (24,909.80) ** (250,089.20) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/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 Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 58,599.00 Budgeted 58,599.00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense Department 51 Totals: Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 Monthly Total 0 % Used .00 .00 .00 .00 .00 ** .00 .00 .00 ** 0 % Used .00 ** 273,999.00 Budgeted 273,999.00 Remaining 0 5 Used Fund 535 Totals: (24,909.80) (24,909.80) Monthly Total (1,000.00) Budgeted 23,909.80 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE EN TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 34,985 TOTAL ASSETS 34,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 34,454 TOTAL FUND BALANCE 34,985 TOTAL LIABILITIES AND FUND BALANCE 34,985 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-49011-000-000 536-49142-000-000 536-49143-000-000 Subtotal: Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Program number: Department number: Revenues Revenues Subtotal Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,000.00- 1,000.00- 291,820.00- 291,820.00- 87,168.00- 87,168.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- .26- 26,529.13- 7,924.28- .26- 26,529.13- 7,924.28- .026 9.091 9.091 7 .067 67 345,53 345,534.33- 999.74- 265,290.87- 79,243.72- 345,534.33- 345,534.33- Page 25 glbase_tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-70005-051-000 536-70040-051-000 536-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 223,588.00 155,000.00 400.00 223,588.00 155,000.00 Subtotal: , gliiiii78,988.00 378,988.00 Program number: 111111178,988.00 378,988.00 Department number: Administration X78,988.00 378,988.00 Expenditures Subtotal 378,988.00 378,988.00 Fund number: 536 2019 Rev Bond I&S- W&WW System 1,000.00- 1,000.00- ******* End of Report ********* 34,453.67- 34,453.67- 3,445.367 400.00 223,588.00 155,000.00 378,988.00 378,988.00 378,988.00 378,988.00 33,453.67 Page 26 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October Account: 536-49011-000-000 come Total (1,000.00) Budgeted (999.74) Remaining Account: 536-49142-000-000 Interfund Tran In -Water Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account Interfund Tran In -Water Sales Totals: (291,820.00) Budgeted (265,290.67) Remaining Interfund Transfer In -WW Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account: 536-49143-11terfund Transfer In -WW Sales Totals: (87,168.00) Budgeted (79,243.72) Remaining Department Totals: 1 0 (.26) (.26) GL Used (26,529.13) (26,529.13) GL 9 % Used (7,924.28) (7,924.28) GL 9 % Used (34,453.67) Monthly Total (379,988.00) Budgeted (34,453.67) ** (345,534.33) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: 51 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Rev Bond Paying Agent Fee Account: 536-70005-051-000 Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 536-70040-051-000 Revenue Bond Interest Expense Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: 223,588.00 Budgeted 223,588.00 Remaining Account: 536-70045-051-000 Revenue Bond Principal Expense Account: 536-70045-051-000 Revenue Bond Principal Expense Totals: 155,000.00 Budgeted 155,000.00 Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: .00 Monthly Total (34,453.67) Monthly Total O % Used .00 .00 .00 .00 .00 ** O % Used .00 .00 .00 ** O % Used .00 ** 378,988.00 Budgeted 378,988.00 Remaining 0 5 Used (34,453.67) (1,000.00) Budgeted 33,453.67 Remaining ########## (105,379.99) Monthly Total ******* End of Report ********* (105,379.99) **** (27,605.00) Budgeted 77,774.99 Remaining 382 5 Used