Loading...
HomeMy WebLinkAbout2020-08 Combined Financials August 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 693,902 PREPAID EXPENSES 1,641 ADVALOREM PROPERTY TAXES RECEIVABLE 17,234 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 712,777 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 17,240 TOTAL LIABILITIES 17,240 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,768 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 91,768 TOTAL FUND BALANCE 695,537 TOTAL LIABILITIES AND FUND BALANCE 712,777 glbase tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 122-40020-000-000 Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 305.21- 1,223,447.93- 508.75- 3,571.59- 585.77- 6,769.14- 100.759 9,217.93 3,571.59 6,769.14 Page Subtotal: 1,214,230.00- 1,214,230.00- = 1,399.73- 1,233,788.66- 101.611 19,558.66 Program number: 1,214,230.00- 1,214,230.00- 1,399.73- 1,233,788.66- 101.611 19,558.66 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 1,399.73- 1,233,788.66- 101.611 19,558.66 I Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,399.73- 1,233,788.66- 101.611 19,558.66 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 4,200.00 4,200.00 4,200.00- 4,200.00 4,200.00- 218,004.00 100.000 1,640.88 18,049.68 85.951 2,950.32 59,888.08 658,768.88 91.667 59,888.12 Page 2 52 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 SubtotaI 256,569.00 256,569.00 Program number: — ' 1,214,230.00 1,214,230.00 Department number: Fire — 1,214,230.00 1,214,230.00 Expenditures Subtotal 1,214,230.00 1,214,230.00 Fund number: 122 Trophy Club MUD Fire Dept. 34,429.00 71.727 13,571.00 9,078.48 9,078.48- 81,420.00 100.000 118,070.12 92.860 9,078.88 242,997.60 13,571.40 65,728.96 1,142,020.16 3 72,209.84 65,728.96 1,142,020. 53 72,209.84 65,728.96 1,142,020. 1IIIIP53 72,209. 64,329.23 91,768.5 91,768. glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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- Property Taxes/MUD Fire 1755 08/03/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1758 08/06/2020 Property Taxes 1759 08/07/2020 Property Taxes 1760 08/10/2020 Property Taxes 1761 08/11/2020 Property Taxes 1762 08/17/2020 Property Taxes 1763 08/21/2020 Property Taxes 1764 08/25/2020 Property Taxes 1692 08/26/2020 August A/P Tax Shortage Denton Refund Tax Shortage 1766 08/28/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1765 08/27/2020 Property Taxes 1766 08/28/2020 Property Taxes 1767 08/31/2020 Property Taxes Property Taxes/MUD Fire IMP (1,223,142.72) (594.03) (441.32) (312.44) 211.86 (95.35) (60.16) (.05) (6.29) (43.69) (6.32) 1,140.54 (97.96) Tota105.21) (1,214,230.00) Budgeted 9,217.93 Remaining Property Taxes/Fire-Delinquent Property Taxes/Fire-Delinquent Totals: .00 Budgeted 3,571.59 Remaining Property Taxes/Fire P01 1755 08/03/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1758 08/06/2020 Property Taxes 1759 08/07/2020 Property Taxes 1760 08/10/2020 Property Taxes 1763 08/21/2020 Property Taxes 1764 08/25/2020 Property Taxes 1692 08/26/2020 August A/P Tax Shortage Denton Refund Tax Shortage 1765 08/27/2020 Property Taxes 1766 08/28/2020 Property Taxes 1767 08/31/2020 Property Taxes 101 % Used (3,062.84) (1,223,736.75) (1,224,178.07) (1,224,490.51) (1,224,278.65) (1,224,374.00) (1,224,434.16) (1,224,434.21) (1,224,440.50) (1,224,484.19) (1,224,490.51) (1,223,349.97) DENTON COUNTY TAX OFFICE (1,223,447.93) (1,223,447.93) ** (44.42) (3,107.26) (17.24) (3,124.50) (12.13) (3,136.63) (425.39) (3,562.02) (9.57) (3,571.59) 0 % Used 1 GL GL GL GL GL GL GL GL GL GL 6753 AP GL GL GL GL GL GL (6,183.37) (5.25) (6,188.62) GL (8.83) (6,197.45) GL (70.57) (6,268.02) GL 29.08 (6,238.94) GL (9.48) (6,248.42) GL (14.23) (6,262.65) GL (3.09) (6,265.74) GL (2.28) (6,268.02) GL (29.08) (6,297.10) DENTON COUNTY TAX OFFICE 6753 AP (3.03) (6,300.13) GL (466.33) (6,766.46) GL (2.68) (6,769.14) GL glpdatb2 skrolczyk 11:58 09/16/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance Fire Revenues Program: Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 2 Check Source Number Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (585.77)+ (6,769.14) ** .00 Budgeted 6,769.14 Remaining 0 % Used Department Totals: (1,399.73) Monthly Total (1,233,788.66) ** (1,214,230.00) Budgeted 19,558.66 Remaining 102 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1677 08/25/2020 August A/P Acal Maintenance & Repairs • Roof maintenance and repairs f 4,200.00 Maintenance & Repairs .00 Budgeted IMML 4,200.00 (4,200.00) Remaining 0 % Used 4,200.00 Discount Roofing 6738 AP Account: 122-60030-045-000 Rent And/Or Usage Account Rent And/Or Usage 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 76 08/01/2020 Insurance/Wrk Comp Expense Aug Account: 122-60055-045-009 Insurance 21,000.00 Budgeted 218,004.00 .00 Remaining 100 % Used .00 218,004.00 .00 214.00 ** 16,408.80 1,640.88 2,950.32 Remaining 86 % Used 18,049.68 GL Account: 122-60337-045-000 Transfer to Town/Fire Budget 1631 08/13/2020 August A/P Fire admin -August Account: 122-60337-045-000 Account: 122-69005-045-000 .sfer to Town/Fire Budg 598,880.80 59,888.08 718,657.00 Budgeted 59,888.12 Remaining api a u Account: 122-69005-045-000 Capital Outlays 48,000.00 Budgeted 92 % Used 34,429.00 13,571.00 Remaining 72 % Used 658,768.88 TOWN OF TROPHY CLUB 6726 AP 658,768.88 .00 34,429.00 Account: 122-69009-045-000 Short Term Debt -Interest Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 Budgeted (9,078.48) Remaining 9,078.48 0 % Used .00 9,078.48 Account: 122-69195-045-000 GASB34/Reserve for Replacement glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-69195-045-00 GASB34/Reserve for Replaium ag Totals: 81,420.00 Budgeted .00 Remaining Account: 122-69305-045-000 Account: 122-69305-045-000 Capital Leases Capital Leasee 127,149.00 Budgeted 81,420.00 .00 81,420.00 100 % Used 118,070.12 9,078.88 Remaining 93 % Used .00 81,420.00 ** .00 .00 118,070.12 118,070.12 Department 45 Totals. 1,142,020.16 ** Fund 122 Totals: 65,728.96 Monthly Total 64,329.23 Monthly Total 1,214,230.00 Budgeted 72,209.84 Remaining 94 % Used .00 Budgeted (91,768.50) 91,768.50 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET AUGUST 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,306,880 3,306,880 CASH IN BANK -SAVINGS -CASH RESERVE 1,768,368 1,768,368 INVESTMENTS-TEXPOOL 4,223,172 919,266 5,142,438 PREPAID EXPENSES 12,473 12,473 ADVALOREM PROPERTY TAXES RECEIVABLE 1,810 1,810 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,405,151 1,405,151 TOTAL ASSETS 10,718,455 919,266 11,637,721 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,810 1,810 ACCOUNTS AND OTHER PAYABLES 793,645 793,645 CUSTOMER DEPOSITS 312,150 312,150 TOTAL LIABILITIES 1,107,605 1,107,605 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 1,209,466 1,209,466 TOTAL FUND BALANCE 9,610,850 919,266 10,530,116 TOTAL LIABILITIES AND FUND BALANCE 10,718,455 919,266 11,637,721 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 33.87- 135,817.58- 100.702 946.58 62.79- 383.44- 127.813 83.44 75.81- 754.34- 251.447 454.34 164,253.00- 135-47000-000-000 Water 6,486,623.00- 6,000,000.00- 750,197.20- 5,097,662.77- 84.961 902,337.23- 135-47005-000-000 Sewer 3,503,885.00- 3,200,000.00- 287,835.02- 2,914,168.72- 91.068 285,831.28- 135-47025-000-000 Penalties 112,608.00- 60,000.00- 18.50 51,056.43- 85.094 8,943.57- 135-47030-000-000 Service Charges 15,150.00- 10,000.00- 9,900.00- 99.000 100.00- 135-47035-000-000 Plumbing Inspections 750.00- 4,500.00- 950.00- 5,450.00- 121.111 950.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 2,850.00- 4,950.00- 198.000 2,450.00 135-47070-000-000 TCCC Effluent Charges 50,000.00- 80,000.00- 18,928.00- 82,765.60- 103.457 2,765.60 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves Oversize Meter Reimbursement Miscellaneous Income Program number: Department number: Revenues HRevenues Subtotal 10,171,516.00- 9,357,000.00- 1,060,74 1- 8,165,953 87.271 1,191,046.48- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 80,000.00- 14,146.00- 7,000.00- 13,000.00- 160,011.00- 12,691.00- 21,000.00- 0- 307148.00- 0- 9,964,572.00- 0- 9,964,572.00- 10,645,077.00- 9,964,572.00- 3,653.16- 78,179.31- 97.724 1,820.69- 1,178.81- 11,788.10- 83.332 2,357.90- 5,833.30- 83.333 1,166.70- 8,925.00- 68.654 4,075.00- 160,011.00- 6,707.00- 19,732.28- 155.482 7,041.28 15,892.48- 36,401.52- 173.341 15,401.52 1,088,345.64- 8,463,768.39- 84.939 1,500,803.61- 1,088,345.64- 8,463,768.39- 84.939 1,500,803.61- 1,088,345.64- 8,463,768.39- 84.939 1,500,803.61- glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 24,933.75 314,750.52 89.860 35,516.48 135-50010-010-000 Overtime 17,000.00 20,000.00 1,506.12 18,329.93 91.650 1,670.07 135-50016-010-000 Longevity 3,920.00 5,083.00 5,082.50 99.990 .50 135-50017-010-000 Certification 5,400.00 5,400.00 375.00 4,525.00 83.796 875.00 135-50020-010-000 Retirement 34,863.00 34,863.00 2,483.06 32,804.54 94.096 2,058.46 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 4,818.60 54,532.42 64.669 29,793.58 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 297.60 3,324.17 70.353 1,400.83 135-50028-010-000 Vision Insurance 767.00 767.00 44.69 514.72 67.108 252.28 135-50029-010-000 Life Insurance & Other 3,132.00 4,132.00 144.08 3,473.05 84.053 658.95 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 1,635.71 21,002.60 89.955 2,345.40 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 382.55 4,911.88 89.945 549.12 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 21.50 902.18 83.535 177.82 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 184.28 8,074.68 68.141 3,775.32 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 163.90 234.90 58.725 165.10 135-50070-010-000 Employee Relations 300.00 300.00 66.82 22.273 233.18 FSubtotal: ' 546,839.00 552,002.00 36,990.84 472, 135-55005-010-000 Engineering 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 75,000.00 372.30 10,899.67 45,245.41 60.327 29,754.59 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 847.00 847.00 28.233 2,153.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,569.22 5,697.33 113.947 697.33- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 1,828.19 52.234 1,671.81 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 875.00 87.500 125.00 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 250.00 4,101.08 54.681 3,398.92 Page 4 1 39 135-60010-010-000 Communications/Mobiles 5,000.00 5,500.00 36.41 4,517.69 82.140 982.31 135-60020-010-000 Electricity 125,677.00 125,677.00 14,443.56 118,709.07 94.456 6,967.93 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 850.00 85.000 150.00 135-60070-010-000 Dues & Memberships 500.00 500.00 105.00 21.000 395.00 135-60080-010-000 Schools & Training 7,426.00 2,500.00 912.00 2,459.00 98.360 41.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 500.00 500.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 63,000.00 30,000.00 5,500.70 25,705.74 85.686 4,294.26 135-60150-010-000 Wholesale Water 2,714,710.00 2,299,249.00 297,112.74 1,591,960.55 69.238 707,288.45 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 756.00 25.200 2,244.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 2,250.00 6,000.00 40.678 8,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 47,943.74 527,381.14 100.000 .14- 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 36,800.00 36,800.00 100.000 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 180,000.00 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 _705.052 00 1.231.457 00 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 996.03 135-65010-010-000 Uniforms 5,190.00 5,190.00 508.10 135-65030-010-000 Chemicals 20,000.00 20,000.00 3,847.78 135-65035-010-000 Small Tools 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 135-65050-010-000 Meter Expense 70,000.00 70,000.00 135-65053-010-000 Meter Change Out Program 87,000.00 87,000.00 561.72 22.469 1,938.28 Page 915.65 8,877.22 3,425.43 19,923.02 59.181 66.001 99.615 61,079.08 87.256 36,900.00 42.414 6,122.78 1,764.57 76.98 1,200.00 1,000.00 8,920.92 50,100.00 2 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtot 135-70040-010-000 Subtot- Program number: Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 684,875.00 772,475.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 102,077.00 3,350.00 1,390.00 423,150.45 30,512.00 3,230.00 75,000.00 102,077.11 54.779 349,324.55 100.000 99.969 1.00 100.000 100.000 .11- 969.56 Bond Related Expenses 1,220.00 14 1,220.00- 00- 86 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PU1111111111 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,063,144.00 293.94 1,455.58 72.779 544.42 1,455.58 72.779 544.42 1 `55.58 72.779 544.42 372. 72 71.374 1,449,364.28 Page 6 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 135 MUD 1 General Fund Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 135-50010-020-000 Overtime 33,000.00 30,000.00 135-50016-020-000 Longevity 8,035.00 6,873.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 704,285.00 135-55005-020-000 Engineering 135-55070-020-000 Independent Labor 135-55080-020-000 Maintenance & Repairs 135-55081-020-000 Mainten & Revairs Collections 135-55085-020-000 Generator Maint. and Repair 135-55090-020-000 Vehicle Maintenance 135-55091-020-000 Veh Maintenance Collections 135-55105-020-000 Maintenance-Backhoe/SkidLoader 135-55120-020-000 Cleaning Services 135-55125-020-000 Dumpster Services 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 15,000.00 15,000.00 88,000.00 73,000.00 10,000.00 25,000.00 10,000.00 2,500.00 4,000.00 4,000.00 8,000.00 8,000.00 3,000.00 3,000.00 1,500.00 1,500.00 100,000.00 100,000.00 40,000.00 40,000.00 34,583.99 365,882.16 82.816 75,916.84 1,205.91 19,973.91 66.580 10,026.09 6,872.50 99.993 .50 625.00 6,950.00 77.222 2,050.00 3,372.01 38,538.66 84.643 6,992.34 7,333.14 77,402.69 73.817 27,455.31 411.78 4,469.25 76.831 1,347.75 66.29 714.60 75.380 233.40 218.78 4,131.63 91.814 368.37 2,156.01 23,420.12 76.802 7,073.88 504.21 5,477.25 76.798 1,654.75 21.50 1,029.50 81.706 230.50 265.19 11,542.69 75.084 3,830.31 76.00 357.00 89.250 43.00 46.08 15.360 253.92 Page 7 50,839.81 566,808.04 80.480 23,200.00 23,200.00 77.333 6,800.00 3,000.00 20.000 12,000.00 6,053.31 69,215.55 94.816 3,784.45 91.05 18,799.49 75.198 6,200.51 3,197.60 3,197.60 127.904 697.60- 1,203.20 30.080 2,796.80 2,173.37 27.167 5,826.63 1,066.21 35.540 1,933.79 87.50 875.00 58.333 625.00 12,476.88 82,453.12 82.453 17,546.88 3,498.30 33,209.52 83.024 6,790.48 8 135-60010-020-000 Communications/Mobiles 135-60020-020-000 Electricity 135-60066-020-000 Publications/Books/Subscripts 135-60070-020-000 Dues & Memberships 135-60080-020-000 Schools & Training 135-60090-020-000 Safety Program 135-60100-020-000 Travel & per diem 135-60105-020-000 Rent/Lease Equipment 135-60125-020-000 Advertising 135-60135-020-000 TCEQ Fees & Permits 135-60245-020-000 Miscellaneous Expenses 135-60280-020-000 Property Maintenance 5,000.00 5,500.00 160,067.00 160,067.00 200.00 200.00 300.00 300.00 4,990.00 4,990.00 1,000.00 1,000.00 1,545.00 1,545.00 5,000.00 5,000.00 2,500.00 2,500.00 15,000.00 15,000.00 450.00 450.00 5,000.00 5,000.00 4,757.27 86.496 742.73 11,877.48 120,134.05 75.052 39,932.95 200.00 216.00 72.000 84.00 54.95 3,176.80 63.663 1,813.20 109.14 10.914 890.86 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 9.00 2,618.47 52.369 2,381.53 glbase tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 46,000.00 180,000.00 2,000.00 Subtotal: 1,231,982.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 27,000.00 135-65031-020-000 Chemicals Collections 17,500.00 10,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 25,000.00 148.84 148.84 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtota.- Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 602,910.00 79,133.00 11,277.00 130,000.00 823,320.00 3,144,482.00 3,144,482.00 148.84 148.84 2,670.00 10,414.81 61,260.70 865.00 87,151.94 993.30 6,524.74 114,562.91 673,867.10 46,000.00 46.605 100.000 100.000 100.000 1,055.00 52.750 7,475.26 .09 .10- 180,000.00 945.00 Page 8 983,520.22 248,461.78 2,259.52 10,958.69 19,537.12 5,147.01 35,642.82 225,492.03 225,492.03 7,460.65 3,507.93 20,508.34 10,448.60 1,166.53 26,441.42 59.685 63.839 75.957 99.510 97.211 105.766 5,039.35 1,987.07 6,491.66 51.40 1,200.00 33.47 1,441.42 - 321,044.55 79,141.86 11,269.04 130,000.00 53.249 100.011 99.929 100.000 541,455.45 2,399,710.24 2,399,710.111111111111111R 15 281,865.45 8.86- 7.96 281,864.55 744,771.76 744,771.76 glbase_tbam skrolczyk 11:57 09/16/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: 8/2020 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 1.99 Program: YTD Total 21.89 % of Budget 72.967 Remaining Budget 8.11 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 WMFSubtota1: Program number: Department number: Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 500.00 500.00 500.00 123.99 375.00 - 675.00 785.78 13,200.00 ,/00.00 Board of Directors 13,230.00 13,230.00 3,730.00 3,730.00 90.000 60.445 111,1q81 39.750 39.750 150.00 75.00 514.22 500.00 500.00 500.00 2,247.33 2,247.33 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 475,000.00 42,373.35 383,902.51 80.822 91,097.49 135-50010-030-000 Overtime 2,000.00 2,000.00 4.53 46.32 2.316 1,953.68 135-50016-030-000 Longevity 2,208.00 2,208.00 2,207.50 99.977 .50 135-50020-030-000 Retirement 58,554.00 42,000.00 3,924.18 37,254.76 88.702 4,745.24 135-50026-030-000 Medical Insurance 124,394.00 81,000.00 7,970.17 72,128.66 89.048 8,871.34 135-50027-030-000 Dental Insurance 6,464.00 4,500.00 441.96 3,993.83 88.752 506.17 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 65.60 601.51 58.117 433.49 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 225.22 3,857.98 85.733 642.02 135-50030-030-000 Social Security Taxes 39,215.00 26,000.00 2,430.22 22,318.08 85.839 3,681.92 135-50035-030-000 Medicare Taxes 9,171.00 6,200.00 568.37 5,219.58 84.187 980.42 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 1,008.00 70.000 432.00 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 25.04 1,073.24 60.464 701.76 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 4,000.00 3,078.10 76.953 921.90 Page 10 652,158.00 58,028.64 536,690.07 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 Cleanin7 Services Professional Outside Services Utility Billing Contract 134,681.00 154,681.00 135,000.00 100,000.00 15,000.00 30,000.00 10,000.00 10,000.00 10,000.00 15,000.00 65,600.00 65,600.00 9,000.00 9,000.00 10,684.81 97,076.76 62.759 90,226.07 90.226 8,972.64 10,827.64 36.092 638.00 1,169.00 11.690 1,896.92 13,349.40 88.996 57,100.00 87.043 1,147.70 6,401.28 71.125 57,604.24 9,773.93 19,172.36 8,831.00 1,650.60 8,500.00 2,598.72 10in 135-60005-030-000 Telephone 23,680.00 23,680.00 1,907.57 17,974.50 75.906 5,705.50 135-60010-030-000 Communications/Mobiles 4,000.00 3,000.00 225.00 2,590.05 86.335 409.95 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 447.95 5,301.07 77.062 1,577.93 135-60025-030-000 Water 1,500.00 1,500.00 426.81 1,648.39 109.893 148.39- 135-60035-030-000 Postage 30,000.00 25,000.00 3,529.87 18,587.49 74.350 6,412.51 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 7,385.95 66,122.52 98.690 877.48 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 80,419.00 6,567.39 72,989.43 90.761 7,429.57 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 125.00 12.500 875.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 178.81 4,607.36 76.789 1,392.64 135-60075-030-000 Meetings 400.00 400.00 33.77 148.86 37.215 251.14 135-60079-030-000 Public Education 6,000.00 6,000.00 336.02 4,383.87 73.065 1,616.13 135-60080-030-000 Schools & Training 6,850.00 3,000.00 1,461.99 3,883.20 129.440 883.20- 135-60100-030-000 Travel & per diem 3,545.00 1,500.00 36.99 1,204.97 80.331 295.03 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 200.00 138.04 69.020 61.96 135-60125-030-000 Advertising 2,500.00 6,000.00 4,111.80 68.530 1,888.20 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 135 MUD 1 General Fund Account 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 135-69005-030-000 135-69170-030-000 Program number: Description Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments Department number: Administration Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 30 Administration Period Ending: 8/2020 Amended Total Budget Encumb. 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 2,050.00 2,050.00 26,485.00 26,485.00 6,000.00 6,000.00 3,500.00 4,000.00 7,500.00 2,500.00 2,500.00 195,000.00 180,000.00 4,000.00 4,000.00 184,000.00 1,519,540.00 1,519,540.00 Current Month 48.00 247.00 576.55 771.74 97,193.34 11,777.46 219.18 97,193.34 11,996.64 97,193.34 117,546.E 97,193.34 117,546.76 Program: YTD Total 264.00 2,026.99 07.54 6,578.70 5,095.14 4,369.90 150,858.40 2,635.21 1,188,485. % of Budget 20.497 81.080 Remaining Budget 1,024.00 500.00 17,000.00 473.01 80.9 2,050.00 24.839 19,906.30 84.919 904.86 58.265 3,130.10 2,500.00 83.810 29,141.60 65.880 1,364.79 Page 11 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 5,070.00 4,194.45 103,230.39 31,907.72 9,665.52 3,756.00 76.467 94.402 82.183 93.900 31,769.61 1,892.28 2,095.48 244.00 Page 12 ir Subtotal: ' 184,561.00 184,561.00 9,264.45 148,559.63 80.494 36,001.37 Program number: 184,561.00 184,561.00 9,264.45 148,559.63 80.494 36,001.37 Department number: Non Departmental 184,561.00 184,561.00 9,264.45 148,559.63 80.494 36,001.37 Expenditures Subtotal 10,638,853.00 9,915,457.00 97,714.48 781,283.45 7,352,017.37 74.147 2,563,439.63 Fund number: 135 MUD 1 General Fund 6,224.00- 49,115.00- 97,714.48 307,062.19- 1,111,751.02- 2,263.567 1,062,636.02 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 Page 13 glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 JE Detail Beginning Balance Description/Comment Account: 135-40000-000- Property Taxes 1755 08/03/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1758 08/06/2020 Property Taxes 1759 08/07/2020 Property Taxes 1760 08/10/2020 Property Taxes 1762 08/17/2020 Property Taxes 1763 08/21/2020 Property Taxes 1764 08/25/2020 Property Taxes 1692 08/26/2020 August A/P Tax Shortage Denton Refund Tax Shortage 1766 08/28/2020 Property Taxes Account: 135-40000-000-000 (135,783.71) Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) (65.94) (135,849.65) (48.99) (135,898.64) (34.68) (135,933.32) 23.52 (135,909.80) (10.59) (135,920.39) (6.68) (135,927.07) (.70) (135,927.77) (4.85) (135,932.62) (.70) (135,933.32) 126.61 (135,806.71) DENTON COUNTY TAX OFFICE (10.87) (135,817.58) Page 5 Check Source Number GL GL GL GL GL GL GL GL GL 6753 AP GL roper 7) (135,817.58) ** (134,871.00) Budgeted 735-40002-000-000 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1765 08/27/2020 Property Taxes 1766 08/28/2020 Property Taxes 1767 08/31/2020 Property Taxes Account: 135-40002-000-000 Property Taxes/Delinquent (300.00) Budgeted Account: 135-1E015-0 1755 08/03/2020 0 Property Taxes 1756 08/04/2020 1757 08/05/2020 1758 08/06/2020 1759 08/07/2020 1760 08/10/2020 1763 08/21/2020 1764 08/25/2020 1692 08/26/2020 1765 08/27/2020 1766 08/28/2020 1767 08/31/2020 Account: 135-40015-000-000 Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes August A/P Tax Shortage Denton Refund Tax Shortage Property Taxes Property Taxes Property Taxes 946.58 Remaining 101 % Used 83.44 Remaining Property Taxes/P & I Totals: (300.00) Budgeted 454.34 Remaining (320.65) 128 % Used (5.06) (1.96) (1.38) (53.30) (1.09) (325.71) (327.67) (329.05) (382.35) (383.44) (678.53) (.59) (679.12) (1.01) (680.13) (7.85) (687.98) 3.23 (684.75) (1.05) (685.80) (1.58) (687.38) (.34) (687.72) (.26) (687.98) (3.23) (691.21) DENTON COUNTY TAX OFFICE (.35) (691.56) (62.48) (754.04) (.30) (754.34) 251 % Used GL GL GL GL GL GL GL GL GL GL GL GL GL 6753 AP GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-40025-000-000 PID Surcharges Account: 135-40025-000-000 • PID Surcharges Totals: (164,253.00) Remaining 0 % Used (164,253.00) Budgeted Account: 135-47000-000-00 ter 1714 08/13/2020 ADj to 2708 Trophy Club Dr UB20200813-20200813 User: 1680 08/25/2020 UB 08/25/2020 Bill Adjustment UB20200825-20200825 User: 1720 08/31/2020 UB 08/31/2020 Billing UB20200831-20200831 User: (4,347,465.57) .00 .00 325.13 (4,347,140.44) UB 127.05 (4,347,013.39) UB (750,649.38) (5,097,662.77) UB Acc (6,000,000.00) Budgeted (902,337.23) Remaining 1662 08/20/2020 UB 08/20/2020 WA Adjustment UB20200820-20200820 User: 1680 08/25/2020 UB 08/25/2020 Bill Adjustment UB20200825-20200825 User: 1688 08/27/2020 08/27/2020 WA Adjustment UB20200827-20200827 User: 1720 08/31/2020 UB 08/31/2020 Billing UB20200831-20200831 User: 85 % Used (2,626,333.70) 83.84 (2,626,249.86) UB 150.40 (2,626,099.46) UB 350.25 (2,625,749.21) UB (288,419.51) (2,914,168.72) UB Account: 135-47005-000-000 (287,835.02) (2,914,168.72) •• (3,200,000.00) Budgeted (285,831.28) Remaining 91 % Used Account: 135-47025-000- Penalti 1663 08/20/2020 UB 08/20/2020 Penalty removal UB20200820-20200820 User: (51,074.93) L Penaltie� (60,000.00) Budgeted 18.50 (51,056.43) UB (8,943.57) Remaining 85 % Used Account: 135-47030-000-000 ice Charges Account: 135-47030-000-000 Service Charges (10,000.00) Budgeted Account: 135-47035-00 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits Plumbing Inspections 114 Claire Drive 126 Claire Drive (9,900.00) .00 (9,900.00) Totals: (100.00) Remaining 99 % Used (4,500.00) (50.00) (4,550.00) CB Jeni CR (50.00) (4,600.00) CB Jeni CR glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) 124 Claire Drive 122 Claire Drive 120 Claire Drive 118 Claire Drive 116 Claire Drive 115 Claire Drive 126 Claire Drive 123 CLaire Drive 121 Claire Drive 119 Claire Drive 117 Claire Drive 101 Claire Drive 109 Claire Drive 109 Claire Drive 107 Claire drive 105 Claire drive 103 Claire Drive (4,500.00) Account: 135-47035-000-000 Totals: (4,500.00) Budgeted Account: 135-47045-000-00 Sewer Inspections 1709 08/04/2020 CB Jeni permits 114 Claire Drive 1709 08/04/2020 CB Jeni permits 126 Claire Drive 1709 08/04/2020 CB Jeni permits 124 Claire Drive 1709 08/04/2020 CB Jeni permits 122 Claire Drive 1709 08/04/2020 CB Jeni permits 120 Claire Drive 1709 08/04/2020 CB Jeni permits 118 Claire Drive 1709 08/04/2020 CB Jeni permits 116 Claire Drive 1710 08/05/2020 CB Jeni permits 115 Claire Drive 1710 08/05/2020 CB Jeni permits 126 Claire Drive 1710 08/05/2020 CB Jeni permits 123 CLaire Drive 1710 08/05/2020 CB Jeni permits 121 Claire Drive 1710 08/05/2020 CB Jeni permits 119 Claire Drive 1710 08/05/2020 CB Jeni permits 117 Claire Drive 1712 08/11/2020 CB Jeni permits 101 Claire Drive 1712 08/11/2020 CB Jeni permits 109 Claire Drive 1712 08/11/2020 CB Jeni permits 109 Claire Drive 1712 08/11/2020 CB Jeni permits 107 Claire drive 1712 08/11/2020 CB Jeni permits 105 Claire drive 1712 08/11/2020 CB Jeni permits 103 Claire Drive 950.00 Remaining 121 % Used (2,100.00) (50.00) (4,650.00) CB Jeni (50.00) (4,700.00) CB Jeni (50.00) (4,750.00) CB Jeni (50.00) (4,800.00) CB Jeni (50.00) (4,850.00) CB Jeni (50.00) (4,900.00) CB Jeni (50.00) (4,950.00) CB Jeni (50.00) (5,000.00) CB Jeni (50.00) (5,050.00) CB Jeni (50.00) (5,100.00) CB Jeni (50.00) (5,150.00) CB Jeni (50.00) (5,200.00) CB Jeni (50.00) (5,250.00) CB Jeni (50.00) (5,300.00) CB Jeni (50.00) (5,350.00) CB Jeni (50.00) (5,400.00) CB Jeni (50.00) (5,450.00) CB Jeni (150.00) (2,250.00) CB Jeni (150.00) (2,400.00) CB Jeni (150.00) (2,550.00) CB Jeni (150.00) (2,700.00) CB Jeni (150.00) (2,850.00) CB Jeni (150.00) (3,000.00) CB Jeni (150.00) (3,150.00) CB Jeni (150.00) (3,300.00) CB Jeni (150.00) (3,450.00) CB Jeni (150.00) (3,600.00) CB Jeni (150.00) (3,750.00) CB Jeni (150.00) (3,900.00) CB Jeni (150.00) (4,050.00) CB Jeni (150.00) (4,200.00) CB Jeni (150.00) (4,350.00) CB Jeni (150.00) (4,500.00) CB Jeni (150.00) (4,650.00) CB Jeni (150.00) (4,800.00) CB Jeni (150.00) (4,950.00) CB Jeni Page 7 Check Source Number CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC Page 8 Sewer Inspections Tota (2,500.00) Budgeted 2,450.00 Remaining TCCC Effluent Charges 1720 08/31/2020 UB 08/31/2020 Billing UB20200831-20200831 User: 198 (63,837.60) Account: 135 TCCC Effluent Chargee Totals: (80,000.00) Budgeted 2,765.60 Remaining Account: 135-49011-000-000 1751 08/31/2020 Bank Interest- August 1751 08/31/2020 Bank Interest- August 1751 08/31/2020 Bank Interest- August Interest Income • Used 103 % Used (74,526.15) Account: 135-49011-000-000 Interest Income (80,000.00) Budgeted (1,820.69) Remaining Account: 135-49016-000-000 1728 08/21/2020 Cell Tower Rev AT&T Account: 135-49016-000-000 (18,928.00) (82,765.60) (1,672.42) (1,201.66) (779.08) 98 % Used (76,198.57) (77,400.23) (78,179.31) UB GL GL GL Cell Tower Revenu Tower Revenue (14,146.00) Budgeted (10,609.29) (2,357.90) Remaining 83 % Used (1,178.81) (11,788.10) GL Account: 135-49018-000-000 =u1 •ang .en Account: 135-49018-000-000 lding Rent Income (7,000.00) Budgeted Account: 135-49026-000-000 a from (1,166.70) Remaining (5,833.30) 83 % Used .00 (5,833.30) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (13,000.00) Budgeted (4,075.00) Remaining (8,925.00) 69 % Used .00 (8,925.00) Account: 135-49035-000-000 Prior Year Reserves glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-49035-000-0 JE Description Account: 135-49075-000-00 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits 1712 08/11/2020 CB Jeni permits ACCOunt: 135 Account: 135-49900-000-000 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1709 08/04/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits 1710 08/05/2020 CB Jeni permits (160,011.00) Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance Revenues Period Ending: 8/2020 Beginning Balance JE Detail Description/Comment Budgeted (160,011.00) Remaining Oversize Meter Reimbursemen 114 Claire 126 Claire 124 Claire 122 Claire 120 Claire 118 Claire 116 Claire 115 Claire 126 Claire 123 CLaire 121 Claire 119 Claire 117 Claire 101 Claire 109 Claire 109 Claire 107 Claire 105 Claire 103 Claire Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive Drive drive drive Drive Oversize Meter Reimburs (12,691.00) Budgeted Miscellaneous Income 114 CLaire Drive 126 Claire Drive 124 Claire Drive 122 Claire Drive 120 Claire Drive 118 Claire Drive 116 Claire Drive 115 Claire drive 125 Claire Drive 123 Caire Drive 121 Claire Drive (13,025.28) 7,041.28 Remaining Program: Transaction Detail .00 0 % Used 155 % Used (20,509.04) Transaction Vendor Name Detail (SUBTOTAL) .00 00 ** (353.00) (13,378.28) CB Jeni (353.00) (13,731.28) CB Jeni (353.00) (14,084.28) CB Jeni (353.00) (14,437.28) CB Jeni (353.00) (14,790.28) CB Jeni (353.00) (15,143.28) CB Jeni (353.00) (15,496.28) CB Jeni (353.00) (15,849.28) CB Jeni (353.00) (16,202.28) CB Jeni (353.00) (16,555.28) CB Jeni (353.00) (16,908.28) CB Jeni (353.00) (17,261.28) CB Jeni (353.00) (17,614.28) CB Jeni (353.00) (17,967.28) CB Jeni (353.00) (18,320.28) CB Jeni (353.00) (18,673.28) CB Jeni (353.00) (19,026.28) CB Jeni (353.00) (19,379.28) CB Jeni (353.00) (19,732.28) CB Jeni (800.00) (21,309.04) CB Jeni (800.00) (22,109.04) CB Jeni (800.00) (22,909.04) CB Jeni (800.00) (23,709.04) CB Jeni (800.00) (24,509.04) CB Jeni (800.00) (25,309.04) CCB Jeni (800.00) (26,109.04) CB Jeni (800.00) (26,909.04) CB Jeni (800.00) (27,709.04) CB Jeni (800.00) (28,509.04) CB Jeni (800.00) (29,309.04) CB Jeni Page 9 Check Source Number CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1710 08/05/2020 CB Jeni permits 119 Claire drive 1710 08/05/2020 CB Jeni permits 117 Claire Drive 1712 08/11/2020 CB Jeni permits 101 Claire drive 1712 08/11/2020 CB Jeni permits 111 claire drive 1712 08/11/2020 CB Jeni permits 109 Claire drive 1712 08/11/2020 CB Jeni permits 107 claire drive 1712 08/11/2020 CB Jeni permits 105 claire drive 1712 08/11/2020 CB Jeni permits 103 Claire drive 1730 08/21/2020 Scrap Metal Recycle- 08/06/20 Recycle Scrap Metal 1731 08/21/2020 Scrap Metal Recycle- 08/07/20 Recycle Scrap Metal 1732 08/21/2020 Scrap Metal Recycle- 08/14/20 Recycle Scrap Metal 1715 08/28/2020 Adj to 2708 Trophy Club Drive UB20200828-20200828 User: 1720 08/31/2020 UB 08/31/2020 Billing UB20200831-20200831 User: (20,509.04) (800.00) (30,109.04) CB Jeni CR (800.00) (30,909.04) CB Jeni CR (800.00) (31,709.04) CB Jeni CR (800.00) (32,509.04) CB Jeni CR (800.00) (33,309.04) CB Jeni CR (800.00) (34,109.04) CB Jeni CR (800.00) (34,909.04) CB Jeni CR (800.00) (35,709.04) CB Jeni CR (257.40) (35,966.44) GL (405.90) (36,372.34) GL (108.00) (36,480.34) GL 260.00 (36,220.34) UB (181.18) (36,401.52) UB Miscellaneous Income 7 Totals: (21,000.00) Budgeted 15,401.52 Remaining 173 % Used Department Totals: (8,463,768.39) ** (1,088,345.64) Monthly Total (9,964,572.00) Budgeted (1,500,803.61) Remaining 85 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 1574 08/07/2020 MUD Payroll 8/7/2020 Salaries & Wages 289,816.77 1648 08/21/2020 MUD Payroll 8/21/2020 Salaries & Wages 11,794.99 301,611.76 PR 13,138.76 314,750.52 PR Account: 135-50005-010-000 Salaries & Wages Totals: 24,933.75 314,750.52 ** 350,267.00 Budgeted 35,516.48 Remaining 90 % Used Account: 135-50010-010-000 Overtime 1574 08/07/2020 MUD Payroll 8/7/2020 Overtime 16,823.81 766.45 17,590.26 PR 1648 08/21/2020 MUD Payroll 8/21/2020 Overtime 739.67 18,329.93 PR Account: 135-50010-010-000 Overtime Totals: 1,506.12 18,329.93 ** 20,000.00 Budgeted 1,670.07 Remaining 92 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 5,083.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-010-000 Certification 1648 08/21/2020 MUD Payroll 8/21/2020 Certification 4,150.00 375.00 4,525.00 PR Account: 135-50017-010-000 Certification Totals: 375.00 4,525.00 ** 5,400.00 Budgeted 875.00 Remaining 84 % Used Account: 135-50020-010-000 Retirement 1574 08/07/2020 MUD Payroll 8/7/2020 1648 08/21/2020 MUD Payroll 8/21/2020 Retirement Retirement 30,321.48 1,163.19 31,484.67 PR 1,319.87 32,804.54 PR Account: 135-50020-010-000 Retirement Totals: 2,483.06 32,804.54 ** 34,863.00 Budgeted 2,058.46 Remaining 94 % Used Account: 135-50026-010-000 Medical Insurance 1574 08/07/2020 MUD Payroll 8/7/2020 Medical Insurance 49,713.82 1648 08/21/2020 MUD Payroll 8/21/2020 Medical Insurance 2,206.11 51,919.93 PR 2,612.49 54,532.42 PR Account: 135-50026-010-000 Medical Insurance Totals: Immo 4,818.60 54,532.42 ** 84,326.00 Budgeted 29,793.58 Remaining 65 % Used glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 12 Check Source Number Account: 135-50027-010-000 Dental Insurance 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Dental Insurance MUD Payroll 8/21/2020 Dental Insurance 3,026.57 139.29 158.31 3,165.86 3,324.17 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 297.60 3,324.17 ** 4,725.00 Budgeted 1,400.83 Remaining 70 5 Used Account: 135-50028-010-000 Vision Insurance 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Vision Insurance MUD Payroll 8/21/2020 Vision Insurance 470.03 20.61 24.08 490.64 514.72 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 44.69 514.72 ** 767.00 Budgeted 252.28 Remaining 67 % Used Account: 135-50029-010-000 Life Insurance & Other 1507 08/01/2020 1677 08/25/2020 August Payroll Benefits Employee Benefits August A/P cafe 125 plan 3,328.97 124.08 20.00 3,453.05 3,473.05 Humana Inc BenefitMall 6642 6733 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 144.08 3,473.05 ** 4,132.00 Budgeted 658.95 Remaining 84 % Used Account: 135-50030-010-000 Social Security Taxes 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Social Security Taxes MUD Payroll 8/21/2020 Social Security Taxes 19,366.89 767.53 868.18 20,134.42 21,002.60 PR PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,635.71 21,002.60 ** 23,348.00 Budgeted 2,345.40 Remaining 90 % Used Account: 135-50035-010-000 Medicare Taxes 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Medicare Taxes MUD Payroll 8/21/2020 Medicare Taxes 4,529.33 179.51 203.04 4,708.84 4,911.88 PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 382.55 4,911.88 ** 5,461.00 Budgeted 549.12 Remaining 90 % Used Account: 135-50040-010-000 Unemployment Taxes 1648 08/21/2020 MUD Payroll 8/21/2020 Unemployment Taxes 880.68 21.50 902.18 PR glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund Account: JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 8/2020 JE Detail Description/Comment Page 13 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Unemployment Taxes Tota 1,080.00 Budgeted 177.82 Remaining Workman's Compensation 76 08/01/2020 Insurance/Wrk Comp Expense Aug 1729 08/21/2020 TML WC & Liab Refund Water Portion of WC Equity Ref Account: 135-50045-010-000 11,850.00 Budgeted Account: 135-50060-010-0 Pre-emp Physicals/Testing 1631 08/13/2020 August A/P ACCOun Account: 135-50070-010-00' 3,775.32 Remaining New hire screening -Preston & N Pre-emp Physicals/Testing 400.00 Budgeted Employee Relations 7,890.40 84 68 Used 771.49 (587.21) Used 8,661.89 8,074.68 GL GL 71.00 163.90 234.90 FIRST CHECK APPLICANT SCREENIN 6700 AP 165.10 Remaining 59 % Ueed 66.82 Employee Relations Totals: 300.00 Budgeted 233.18 Remaining 22 % Ueed .00 66.82 Ac.'80-010-00 Maintenance & Repairs 1631 08/13/2020 August A/P main break repair at 601 Perky 33,973.44 7,851.59 41,825.03 REY-MAR CONSTRUCTION 6718 AP 1631 08/13/2020 August A/P parts 475.50 42,300.53 Core & Main LP 6693 AP 1631 08/13/2020 August A/P FlagsOlocates 100.00 42,400.53 Core & Main LP 6693 AP 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FASTSIGNS OF SOUTHLAKE 192.06 42,592.59 FASTSIGNB OF SOUTHLAKE PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FASTSIGNS OF SOUTHLAKE 831.68 43,424.27 FASTSIGNS OF SOUTHLAKE PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 U.S. PLASTIC CORPORATI 108.59 43,532.86 U.S. PLASTIC CORPORATI PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FERGUSON ENT LLC #2806 112.61 43,645.47 FERGUSON ENT LLC #2806 PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FERGUSON ENT 1241 83.79 43,729.26 FERGUSON ENT 1241 PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FERGUSON ENT 1241(83.79) 43,645.47 FERGUSON ENT 1241 PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FERGUSON ENT 1241 77.41 43,722.88 FERGUSON ENT 1241 PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FERGUSON ENT LLC #2806 9.81 43,732.69 FERGUSON ENT LLC #2806 PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 SQ *METROPLEX OIL RECO (75.00) 43,657.69 SQ *METROPLEX OIL RECO PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 SQ *METROPLEX OIL RECO 75.00 43,732.69 SQ *METROPLEX OIL RECO PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 SQ *METROPLEX OIL RECO 75.00 43,807.69 SQ *METROPLEX OIL RECO PC 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 SQ *METROPLEX OIL RECO (75.00) 43,732.69 SQ *METROPLEX OIL RECO PC glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1717 08/31/2020 Aufgust A/P 1717 08/31/2020 Aufgust A/P 1793 08/31/2020 August A/P Account: 135-55080-010-000 Account: 135-55085-010-08 Ac 1640 08/17/2020 August A/P Department: 10 Water JE Detail Description/Comment SQ *METROPLEX OIL RECO ROANOKE WINNELSON CO THE HOME DEPOT #6581 CHlorine parts Chlorine parts Tank rental Maintenance & Repairs 75,000.00 Budgeted Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 8/2020 Beginning Balance 30,126.89 Remaining Generator Maint. and Repai Generator yearly maintenance Generator Maint. and Repair 3,000.00 Budgeted 2,153.00 Remaining Vehicle Maintenance 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 DISCOUNT TIRE TXD 75 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 DISCOUNT TIRE TXD 75 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ROANOKE AUTO SUPPLY LT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 KWIK KAR LUSE & TUNE 0 Account: 135 - Account: 135-55105-010-0 1631 08/13/2020 August A/P Vehicle Maintenance 5,000.00 Budgeted Totals: (697.33) Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 1,671.81 Remaining 33,973.44 60 % Used 28 % Used Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 75.00 43,807.69 50.46 43,858.15 128.75 43,986.90 195.00 44,181.90 649.21 44,831.11 42.00 44,873.11 10,899.67 SQ *METROPLEX OIL RECO ROANOKE WINNELSON CO THE HOME DEPOT #6581 SCOOP SCOOP ALLIED WELDING SUPPLY, INC Page 14 Check Source Number PC PC PC 6789 AP 6789 AP AP 847.00 847.00 Sluder Emergency Power Service 6720 AP 4,128.11 (20.00) 4,108.11 ROANOKE AUTO SUPPLY LT 20.00 4,128.11 ROANOKE AUTO SUPPLY LT 20.00 4,148.11 ROANOKE AUTO SUPPLY LT (20.00) 4,128.11 ROANOKE AUTO SUPPLY LT 20.00 4,148.11 ROANOKE AUTO SUPPLY LT 471.50 4,619.61 DISCOUNT TIRE TXD 75 859.06 5,478.67 DISCOUNT TIRE TXD 75 141.08 5,619.75 ROANOKE AUTO SUPPLY LT 77.58 5,697.33 KWIK KAR LUBE & TUNE 0 114 % Used 1,828.19 Cleaning Service Janitorial service -July 787.50 52 % Used 1,569.22 .00 1,828.19 • PC PC PC PC PC PC PC PC PC 87.50 875.00 MEMBER'S BUILDING MAINTENANCE 6710 AP glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 15 Cleaning Services Tota 87 875.00 ** ACC 1,000.00 Budgeted 125.00 Remaining 88 % Ueed Lab Analysis 1631 08/13/2020 August A/P water samples Account: 135-551 Account: 135 3,851.08 250.00 4,101.08 TARRANT CTY PUBLIC HEALTH LAB 6721 AP Lab Analysis Totals: 0.00 4,101.08 ** 7,500.00 Budgeted Communications/Mobiles 3,398.92 Remaining 55 5 Used 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 AMAZON.COM*MFOA33HM0 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 AMZN MKTP US*MV7V23102 Account: 135010-01 Communications/Mobiles 5,500.00 Budgeted Account: 135-60020-010-000 1 1677 08/25/2020 August A/P Account: 135-60020-010-000 4,481.28 29.42 4,510.70 AMAZON.COM*MFOA33HMO PC 6.99 4,517.69 AMZN MKTP US*MV7V23102 PC Total 4,517.69 ** 982.31 Remaining 82 5 Used Electricity Electricity 7/10-8/10 125,677.00 Budgeted 6,967.93 104,265.51 14,443.56 118,709.07 HUDSON ENERGY SERVICES, LLC 6741 AP Remaining 94 5 Used Account: 135-60066-010-000 Publications/Books/Subscripts Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 150.00 Remaining Account: 135-60070-010-000 Account: 135-60070-010-000 Account: 135-60080-010-000 Dues & Memberships Dues & Memberships 500.00 Budgeted aining 850.00 105.00 .00 850.00 85 b Ueed .00 105.00 395.00 Remaining 21 5 Used 1677 08/25/2020 August A/P pett cash reimbursement 1,547.00 11.00 1,558.00 TROPHY CLUB MUD PETTY CASH 6750 AP glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1677 08/25/2020 August A/P 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 Account • Account: 135-60090-010-000 Account: 135-60090-010-000 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-0001 Account: 135-60105-010-000 • Account: 135-60135-010-000 1640 08/17/2020 August A/P Account: 135-60135-010-000 Account: 135-60150-010-0 1717 08/31/2020 Aufguet A/P Ace'unt Trophy Club MUD No.1 Page 16 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment CDL license renewal -Orlando SUNCOAST LEARNING SYST SUNCOAST LEARNING SYST TX DPS DL OFFICE Totals: 1,547.00 96.00 1,654.00 TROPHY CLUB MUD PETTY CASH 6750 AP 350.00 2,004.00 SUNCOAST LEARNING SYST PC 350.00 2,354.00 SUNCOAST LEARNING SYST PC 105.00 2,459.00 TX DPS DL OFFICE PC 2,500.00 Budgeted 41.00 Remaining 98 % Used Safety Program .00 .00 Safety Program Totals: 400.00 Budgeted 400.00 Remaining 0 % Used Travel & per diem .00 .00 Travel & per diem Totals: 500.00 Budgeted 500.00 Remaining 0 % Used Rent/Lease Equipment .00 .00 Rent/Lease Equipment .00 1,500.00 Budgeted 1,500.00 Remaining 0 % Used TCEQ Fees & Permits well water 20,205.04 5,500.70 25,705.74 North Texas Groundwater TCEQ Fees & Permits Totals: . 5,500.70 30,000.00 Budgeted 4,294.26 Remaining 86 % Used Wholesale Water Wholesale water 1,294,847.81 297,112.74 1,591,960.55 CITY OF FORT WORTH Wholesale Water 2,299,249.00 Budgeted 707,288.45 Remaining 69 % Used 6713 AP 6774 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Account: 135-60280-010-000 1 Miscellaneous Expenses Miscellaneous Expenses Totals: 200.00 Budgeted 200.00 Remaining Property Maintenance Property Maintenance 3,000.00 Budgeted 756.00 • 0 % Used .00 .00 .00 756.00 2,244.00 Remaining 25 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1631 08/13/2020 August A/P mowing -July 1746 08/31/2020 August A/P Mowing -August Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 8,750.00 Remaining Interfund TransIL 1664 08/20/2020 TexPool Transfers August 3,750.00 1,500.00 750.00 TexPool O&M to I&S- W&WW SYS 479,437.40 1664 08/20/2020 TexPool Transfers August TexPool O&M to 16Swift Rev I&S 32-010-000 Account: 135-60333-010-000 fund TransfeMt-Rev I&S Totals: 527,381.00 Budgeted (.14) Remaining Interfund Transfer Out -Reserve 41 % Used 100 % Used 5,250.00 WATTS ELLISON LLC 6730 AP 6,000.00 WATTS ELLISON LLC 6794 AP 22,896.02 502,333.42 GL 25,047.72 527,381.14 GL 36,800.00 .00 36,800.00 Account: 135-60333-01 terfund Transfer Out -Reserve Totals: 36,800.00 36,800.00 Budgeted .00 Remaining Account :-'B.rOMIreTi6,6terfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining 100 % Used 0 % Used .00 .00 00 ** glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-60360-010-000 JE Description Account: 135-60360-010-000 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 8/2020 Beginning Balance Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 18 Check Source Number Furniture/Equipment < $5000 RP Furniture/Equipment < 05000 Totals: 2,500.00 Budgeted 1,938.28 Remaining Account: 135-65005-010-000 1683 08/24/2020 Fuel -August Fuel & Lube Fuel 561.72 .00 22 % Used 561.72 7,881.19 996.03 8,877.22 US Bank Voyager Fleet Systems 6792 AP Account: 135-65005-010-000 ACC 15,000.00 Budgeted 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1717 08/31/2020 Aufgust A/P CAVENDERS.COM 600 CAVENDERS.COM 600 Shirts-Noelan Account: 1 Account: 135 -65030 -010 -000M- 1631 35 -65030-010-000M1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1717 08/31/2020 Aufgust A/P 1746 08/31/2020 August A/P 1746 08/31/2020 August A/P Account: 135-65030-010-000 5,190.00 Budgeted Chemicals tsting supplies chlorine CHlorine testing supplies Testing supplies Chemicals 20,000.00 Budgeted 6,122.78 Remaining Totals: 1,764.57 Remaining Totals: 76.98 Remaining 59 % Used 2,917.33 (12.21) 2,905.12 CAVENDERS.COM 600 160.17 3,065.29 CAVENDERS.COM 600 360.14 3,425.43 RON MONTGOMERY & ASSOC INC 66 % Used 16,075.24 100 % Used 529.95 893.45 893.45 1,370.48 160.45 16,605.19 17,498.64 18,392.09 19,762.57 19,923.02 HACH COMPANY DPC INDUSTRIES, INC DPC INDUSTRIES, INC HACH COMPANY HACH COMPANY PC PC 6788 AP 6703 AP 6697 AP 6777 AP 6779 AP 6779 AP Account: 135-65035-010-000 Small Tools Account: 135-65035-010-000 Small Tools 1,200.00 Budgeted 1,200.00 Remaining 0 % Used .00 .00 Account: 135-65040-010-000 .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Safety Equipment Tota ACC Account: 135-65050-010-000 Account: 135-65053-010-000 Account: 135-65053-010-000 Account:■5-69005-010-000 .1 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1,000.00 Budgeted Meter Expense 1,000.00 Remaining 0 % Ueed Meter Expense Totals: 70,000.00 Budgeted Meter Change Out Program 61,079.08 8,920.92 Remaining 87 % Used Meter Change Out Program Totals. 87,000.00 Budgeted 50,100.00 Remaining 36,900.00 42 % Ueed .00 61,079.08 61,079.08 ** .00 36,900.00 36,900.00 Cap 71 Chimney Rock & Carnouetie meadowbrook Capital Outlays 772,475.00 Budgeted 419,800.45 1,350.00 2,000.00 349,324.55 Remaining 55 % Ueed Short Term Debt -Principal 421,150.45 Raiff Associates, INC 6701 AP 423,150.45 TEAGUE, NALL & PERKINS,INC 6724 AP 30,512.00 .00 30,512.00 Account: 135-69008-010- Short Term Debt -Principal Totals: 30,512.00 Budgeted .00 Remaining 100 % Ueed Account: 135-69009-010-000 Short Term Debt -Interest 1527 08/01/2020 August A/P Vac truck Interest 1,840.00 1,390.00 3,230.00 FIRST FINANCIAL BANK Account: 135-69009-010-000 Short Term Debt -Interest Totals: 3,231.00 Budgeted 1.00 Remaining 100 % Used Account: 135-6919Replacement 75,000.00 .00 75,000.00 6639 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-69281-010-000 Gasb34/Reserve for Replacement Totals: mem 75,000. 75,000.00 Budgeted .00 Remaining Water Tank Inspection Contract 100 % Used 102,077.11 .00 102,077.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 102,077.11 ** 102,077.00 Budgeted (.11) Remaining Account: 135-70040-010-000 Bond Related Expenses 100 % Used 1,220.00 .00 1,220.00 Account: 135-70040-010-000 Bond Related Expenses Totals: .00 1,220.00 ** .00 Budgeted (1,220.00) Remaining 0 % Used glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Ac0ount: 135-55135-010- 1631 08/13/2020 August A/P 1717 08/31/2020 Aufguet A/P Account: Department 10 Totals: Trophy Club MUD No.1 Page 21 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lab Analysis for PID water samples TCEQ samples Lab Analysis for PID Totals: 2,000.00 Budgeted 1,161.64 80.00 1,241.64 TARRANT CTY PUBLIC HEALTH LAB 6721 AP 213.94 1,455.58 LOWER COLORADO RIVER AUTHORITY 6782 AP 544.42 Remaining 73 % Used 3,613,407.42 ** 429,229.23 Monthly Total 5,063,144.00 Budgeted 1,449,736.58 Remaining 71 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 1574 08/07/2020 MUD Payroll 8/7/2020 Salaries & Wages 331,298.17 1648 08/21/2020 MUD Payroll 8/21/2020 Salaries & Wages 16,680.52 347,978.69 PR 17,903.47 365,882.16 PR Account: 135-50005-020-000 Salaries & Wages Totals: 34,583.99 365,882.16 ** 441,799.00 Budgeted 75,916.84 Remaining 83 % Used Account: 135-50010-020-000 Overtime 1574 08/07/2020 MUD Payroll 8/7/2020 Overtime 18,768.00 582.07 19,350.07 PR 1648 08/21/2020 MUD Payroll 8/21/2020 Overtime 623.84 19,973.91 PR Account: 135-50010-020-000 Overtime Totals: 1,205.91 19,973.91 ** 30,000.00 Budgeted 10,026.09 Remaining 67 % Used Account: 135-50016-020-000 Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity Totals: .00 6,872.50 ** 6,873.00 Budgeted .50 Remaining 100 5 Used Account: 135-50017-020-000 Certification 1648 08/21/2020 MUD Payroll 8/21/2020 Certification 6,325.00 625.00 6,950.00 PR Account: 135-50017-020-000 Certification Totals: 625.00 6,950.00 ** 9,000.00 Budgeted 2,050.00 Remaining 77 5 Used Account: 135-50020-020-000 Retirement 1574 08/07/2020 MUD Payroll 8/7/2020 1648 08/21/2020 MUD Payroll 8/21/2020 Retirement Retirement 35,166.65 1,598.51 36,765.16 PR 1,773.50 38,538.66 PR Account: 135-50020-020-000 Retirement Totals: 3,372.01 38,538.66 ** 45,531.00 Budgeted 6,992.34 Remaining 85 % Used Account: 135-50026-020-000 Medical Insurance 1574 08/07/2020 MUD Payroll 8/7/2020 Medical Insurance 70,069.55 1648 08/21/2020 MUD Payroll 8/21/2020 Medical Insurance 3,463.38 73,532.93 PR 3,869.76 77,402.69 PR Account: 135-50026-020-000 Medical Insurance Totals: 7,333.14 77,402.69 ** 104,858.00 Budgeted 27,455.31 Remaining 74 5 Used glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 23 Check Source Number Account: 135-50027-020-000 Dental Insurance 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Dental Insurance MUD Payroll 8/21/2020 Dental Insurance 4,057.47 196.39 215.39 4,253.86 4,469.25 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 411.78 4,469.25 ** 5,817.00 Budgeted 1,347.75 Remaining 77 % Used Account: 135-50028-020-000 Vision Insurance 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Vision Insurance MUD Payroll 8/21/2020 Vision Insurance 648.31 31.40 34.89 679.71 714.60 PR PR Account: 135-50028-020-000 Vision Insurance Totals: 66.29 714.60 ** 948.00 Budgeted 233.40 Remaining 75 % Used Account: 135-50029-020-000 Life Insurance & Other 1507 08/01/2020 1677 08/25/2020 August Payroll Benefits Employee Benefits August A/P cafe 125 plan 3,912.85 186.78 32.00 4,099.63 4,131.63 Humana Inc BenefitMall 6642 6733 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 218.78 4,131.63 ** 4,500.00 Budgeted 368.37 Remaining 92 % Used Account: 135-50030-020-000 Social Security Taxes 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Social Security Taxes MUD Payroll 8/21/2020 Social Security Taxes 21,264.11 1,037.77 1,118.24 22,301.88 23,420.12 PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 2,156.01 23,420.12 ** 30,494.00 Budgeted 7,073.88 Remaining 77 % Used Account: 135-50035-020-000 Medicare Taxes 1574 08/07/2020 1648 08/21/2020 MUD Payroll 8/7/2020 Medicare Taxes MUD Payroll 8/21/2020 Medicare Taxes 4,973.04 242.70 261.51 5,215.74 5,477.25 PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 504.21 5,477.25 ** 7,132.00 Budgeted 1,654.75 Remaining 77 % Used Account: 135-50040-020-000 Unemployment Taxes 1648 08/21/2020 MUD Payroll 8/21/2020 Unemployment Taxes 1,008.00 21.50 1,029.50 PR glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 24 Check Source Number Account: 135-50040-020-000 Unemployment Taxes Totals: ii 21.50 1,029.50 ** 1,260.00 Budgeted 230.50 Remaining 82 % Used Account: 135-50045-020-000 Workman's Compensation 76 08/01/2020 Insurance/Wrk 1729 08/21/2020 TEL WC & Liab Comp Expense Aug Refund WW Portion of WC Equity Ref 11,277.50 1,110.20 (845.01) 12,387.70 11,542.69 GL GL Account: 135-50045-020-000 Workman's Compensation ` Totals: 11,542.69 ** 15,373.00 Budgeted 3,830.31 Remaining 75 5 Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1640 08/17/2020 August A/P new employee drug screen -P. To 281.00 76.00 357.00 CARENOW CORPORATE 6691 AP Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 76.00 357.00 ** 400.00 Budgeted 43.00 Remaining 89 % Used Account: 135-50070-020-000 Employee Relations 46.08 .00 46.08 Account: 135-50070-020-000 Employee Relations Totals: .00 46.08 ** 300.00 Budgeted 253.92 Remaining 15 5 Used Account: 135-55005-020-000 Engineering 1640 08/17/2020 August A/P SSOI Plan 23,200.00 23,200.00 Halff Associates, INC 6701 AP Account: 135-55005-020-000 Engineering Totals: 23,200.00 23,200.00 ** 30,000.00 Budgeted 6,800.00 Remaining 77 5 Used Account: 135-55070-020-000 Independent Labor 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 1631 08/13/2020 August A/P Parts for UV 63,162.24 323.51 63,485.75 NEWMAN REGENCY GROUP, INC 6712 AP glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1640 08/17/2020 August A/P 1677 08/25/2020 August A/P 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1746 08/31/2020 August A/P 1746 08/31/2020 August A/P Account: 135-55081-020-00 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 8/2020 JE Detail Beginning Balance Description/Comment uv BULBS AND SLEEVES repair actuators/Influent A/C repiars pest control -WW plant overhead crane inspect/load to Longo Bags for grit ROANOKE WINNELSON CO THE HOME DEPOT #6581 THE HOME DEPOT #6581 SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO THE HOME DEPOT #6581 parts for break on Lake B line RAS pump #3 Maintenance & Repairs MEM Totals: 73,000.00 Budgeted 3,784.45 Remaining Mainten & Repairs, 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 THE HOME DEPOT 6581 Mainten & Repairs Collections Totals: 25,000.00 Budgeted 6,200.51 Remaining Account: 135-55085-020-00 1640 08/17/2020 August A/P Account: 135-55085-020-6 Generator Maint. and Repair i Generator yearly maintenance Generator Maint. and Repair Totals: 2,500.00 Budgeted (697.60) Remaining 63,162.24 18,708.44 95 % Used Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 593.06 64,078.81 892.00 64,970.81 175.00 65,145.81 110.00 65,255.81 1,495.00 66,750.81 708.00 67,458.81 74.32 67,533.13 25.51 67,558.64 25.65 67,584.29 (135.00) 67,449.29 135.00 67,584.29 135.00 67,719.29 (135.00) 67,584.29 135.00 67,719.29 37.35 67,756.64 1,063.91 68,820.55 395.00 69,215.55 5.55 UV DOCTOR LAMPS LLC Municipal Valve & Equipment Co BRANDON R REED Exclusive Pest Control Handling Systems & Conveyors Huber Technology Inc ROANOKE WINNELSON CO THE HOME DEPOT #6581 THE HOME DEPOT #6581 SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO SQ *METROPLEX OIL RECO THE HOME DEPOT #6581 ATLAS UTILITY SUPPLY CO. NORTH TEXAS PUMP CO. 91.05 18,799.49 THE HOME DEPOT 6581 75 % Used 128 % Ueed Page 25 Check Source Number 6729 AP 6711 AP 6690 AP 6698 AP 6702 AP 6740 AP PC PC PC PC PC PC PC PC PC 6772 AP 6785 AP PC 3,197.60 3,197.60 Sluder Emergency Power Service 6720 AP Account: 135-55090-020-000 Vehicle Maintenance aft 1,203.20 .00 1,203.20 Account: 135-55090-020-000 Vehicle Maintenance 4,000.00 Budgeted 2,796.80 Remaining 30 % Ueed Account: 135-55091-020-000 Veh Maintenance Collections glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-55091-020-05 Veh Maintenance Collections Totals: 8,000.00 Budgeted 5,826.63 Remaining Account: 135-55105-020-000 Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Tot 3,000.00 Budgeted 1,933.79 Account: 135-55120-020- Cleaning Se 1631 08/13/2020 August A/P Acc'until Janitorial service -July Cleaning Services 1,500.00 Budgeted Remaining 2,173.37 .00 2,173.37 1,066.21 27 % Used .00 36 % Used 1,066.21 787.50 87.50 875.00 MEMBER'S BUILDING MAINTENANCE 6710 AP 625.00 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1631 08/13/2020 August A/P sludge/grit 69,976.24 979.60 70,955.84 L.H. CHANEY MATERIALS, INC. 6707 AP 1631 08/13/2020 August A/P sludge/grit 1,129.02 72,084.86 L.H. CHANEY MATERIALS, INC. 6707 AP 1640 08/17/2020 August A/P sludge/grit 1,350.36 73,435.22 L.H. CHANEY MATERIALS, INC. 6707 AP 1717 08/31/2020 Aufgust A/P sludge/grit 2,258.66 75,693.88 L.H. CHANEY MATERIALS, INC. 6781 AP 1746 08/31/2020 August A/P sludge/grit 2,339.88 78,033.76 L.H. CHANEY MATERIALS, INC. 6781 AP 1746 08/31/2020 August A/P sludge/grit 2,268.58 80,302.34 L.H. CHANEY MATERIALS, INC. 6781 AP 1746 08/31/2020 August A/P sludge/grit 2,150.78 82,453.12 L.H. CHANEY MATERIALS, INC. 6781 AP Account: 135-55135-020-000 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1640 08/17/2020 August A/P 1640 08/17/2020 August A/P 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P 1717 08/31/2020 Aufgust A/P Dumpster Services 100,000.00 Budgeted Lab Analysis lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing 17,546.88 Remaining 82 % Used 29,711.22 341.55 30,052.77 OXIDOR LABORATORIES LLC 241.50 30,294.27 OXIDOR LABORATORIES LLC 341.55 30,635.82 OXIDOR LABORATORIES LLC 241.50 30,877.32 OXIDOR LABORATORIES LLC 341.55 31,218.87 OXIDOR LABORATORIES LLC 241.50 31,460.37 OXIDOR LABORATORIES LLC 341.55 31,801.92 OXIDOR LABORATORIES LLC 241.50 32,043.42 OXIDOR LABORATORIES LLC 341.55 32,384.97 OXIDOR LABORATORIES LLC 6716 AP 6716 AP 6716 AP 6716 AP 6716 AP 6716 AP 6748 AP 6748 AP 6787 AP glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 27 1717 08/31/2020 August A/P 1793 08/31/2020 August A/P 1793 08/31/2020 August A/P lab testing 29,711.22 241.50 32,626.47 OXIDOR LABORATORIES LLC 6787 AP lab testing 341.55 32,968.02 OXIDOR LABORATORIES LLC AP lab testing 241.50 33,209.52 OXIDOR LABORATORIES LLC AP Account: 135-55135-020-000 Lab Analysis Totals: 3,498.30 40,000.00 Budgeted 6,790.48 Remaining 83 % Used Account: 135-60010-020-000 Communications/Mobiles Account: 135-60010-020-000 Communications/Mobiles 5,500.00 Budgeted 742.73 Remaining Account: 135-60020-020-00: 1631 08/13/2020 August A/P electricity 6/30-7/29 1677 08/25/2020 August A/P Electricity 7/10-8/10 1745 08/31/2020 Town Billed Invoices 1750-1752 AR 20200831-20200831 User: Account: 135-60020-020-000 Account: 135-60066-020-000 Account: 135-60066-020-000 Account: 135-60070-020-000 Account: 135-60070-020-000 Account: 135-60080-020-000 - 1677 08/25/2020 August A/P 4,757.27 86 % Used .00 4,757.27 108,256.57 265.75 108,522.32 TRI COUNTY ELECTRIC 11,786.46 120,308.78 HUDSON ENERGY SERVICES, LLC (174.73) 120,134.05 city 160,067.00 Budgeted 39,932.95 Remaining Publications/Books/Subscrip Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Dues & Memberships Dues & Memberships 300.00 Budgeted Scho 216.00 75 % Used 0 % Used 0 .00 .00 216.00 Totals: 84.00 Remaining 72 % Used pett cash reimbursement 3,121.85 54.95 3,176.80 TROPHY CLUB MUD PETTY CASH 6727 AP 6741 AP AR 6750 AP Account: 135-1111INT-0000 4,990.00 Budgeted 1,813.20 Remaining 64 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60090-020-000 ' Safety Program Account: 135-60090-020-0001 1,000.00 Budgeted Account: 135-60100-020-000 Travel 6 per diem 109.14 .00 109.14 Safety Program Totals: 890.86 Remaining 11 % Used 109.14 ** Account: 135-60100-020-000 Travel & per diem Totals: 1,545.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Rent/Lease Equipment 5,000.00 Budgeted 410.72 1,134.28 Remaining 27 % Used 5,000.00 Remaining 0 % Used .00 410.72 410.72 ** .00 .00 0� .00 ** Account: 135-60125-020-000 Advertising Account: 135-60125-020-000 Adverti= 2,500.00 Budgeted Account: 135-60135-020-000 Account: 135-60135-020-000 TCEQ Fees & Permits 15,000.00 Budgeted Account: 135-60245-020-000 Miscellaneous Expenses 2,500.00 Remaining 10,088.02 0 Used 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses Totals: 450.00 Budgeted 450.00 Remaining 0 % Used .00 .00 .00 10,088.02 .00 .00 .00 .00 ** Account: 135-60280-020-000 Property Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 29 1677 08/25/2020 August A/P pett cash reimbursement Account: 135 -60280 -020 - Account: 135-60285-020-000 1631 08/13/2020 August A/P 1746 08/31/2020 August A/P Property Maintenance Totals: 5,000.00 Budgeted 2,609.47 9.00 2,618.47 TROPHY CLUB MUD PETTY CASH 2,381.53 Remaining 52 % Used Lawn Equipment & Maintenance mowing-july Mowing -August Account: Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 7,475.26 Remaining Interfund Transfer Out -Tax I&S 1664 08/20/2020 TexPool Transfers August TexPool O&M to I&S- PID Debt Account: 135-60331-020-00 Interfund Transfer Out -Tax 114,563.00 Budgeted .09 3,854.74 1,780.00 890.00 104,148.10 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1664 08/20/2020 TexPool Transfers August TexPool O&M to I&S- W&WW SYS 1664 08/20/2020 TexPool Transfers August TexPool O&M to Rev Bd WWTP I&S 47 % Used 10,414.81 100 % Used 612,606.40 Interfund Transfer Out -Rev I&S 673,867.00 Budgeted (.10) Remaining Interfund Transfer Out -Reserve Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 46,000.00 Budgeted .00 Remaining Account: 135-60334-020-000 Account: 135-60334-020-000 Interfund Transfer Out nterfund Transfer Out Totals: 180,000.00 Budgeted 6750 AP 5,634.74 WATTS ELLISON LLC 6730 AP 6,524.74 WATTS ELLISON LLC 6794 AP 114,562.91 6,839.07 619,445.47 54,421.63 673,867.10 100 % Used 46,000.00 100 % Used .00 46,000.00 .00 .00 180,000.00 Remaining 0 % Used GL GL GL Account: 135-60360-020-000 Furniture/Equipment < $5000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 PEARCE OFFICE FURNITUR Account- - - urmiture/Equipment < $5000 Totals: 2,000.00 Budgeted 945.00 Remaining 190.00 865.00 1,055.00 PEARCE OFFICE FURNITUR 53 % Used 8 PC Account: 135-65005-020-000 Fuel & Lube 1683 08/24/2020 Fuel -August Fuel 6,467.35 988.30 7,455.65 US Bank Voyager Fleet Systems 6792 AP 1677 08/25/2020 August A/P pett cash reimbursement 5.00 7,460.65 TROPHY CLUB MUD PETTY CASH 6750 AP Account: Fuel & Lube 12,500.00 Budgeted Uniforms Account: 135-65010-020-000 Uniforms 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals Account: 135-65030-020-000 Chemical 27,000.00 Budgeted 5,039.35 Remaining 3,507.93 1,987.07 Remaining 20,508.34 6,491.66 Remaining 60 % Used .00 3,507.93 64 % Used 76 % Used Account: 135-65031-020-000 = Charm a�i�oifctions Account: 135-65031-020-000 Chemicals Collections ir Totals: 10,500.00 Budgeted 51.40 Remaining Account: 135-65035-020-000 Small TooM. Account: 135-65035-020-000 1,200.00 Budgeted 10,448.60 100 % Used .00 20,508.34 .00 10,448.60 00 .00 Totals: .00 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-00 Safety Equipment IM Totals: 1,200.00 Budgeted 33.47 Remaining Account: 135-65045-020-000 Lab Supplies 1631 08/13/2020 August A/P MLSS/Dipping sticks 1746 08/31/2020 August A/P LAB Incubator Account: Lab Supplies 25,000.00 Budgeted (1,292.58) Remaining 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1793 08/31/2020 August A/P Account: 135-59005-020-000 Account: 135-69008-020-000M 1527 08/01/2020 August A/P Account: 135-69008-020-000 Capital Outlays Lift station #1 access door Anti foaming system spare parts 1,166.53 .00 1,166.53 97 % Used 24,033.06 459.52 24,492.58 HD SUPPLY FACILITIES MAINT LTD 6704 AP 1,800.00 26,292.58 VWR International 6793 AP 105 % Used 310,085.86 1,300.00 311,385.86 Halff Associates, INC 6701 AP 1,505.00 312,890.86 CP&Y/WALLACE GROUP, INC. 6695 AP 8,153.69 321,044.55 DHS AUTOMATION, INC AP Capital Outlays T Totals: 602,910.00 Budgeted 281,865.45 Remaining Short Term Debt -Principal Camera Van P&I Term Debt -Principal 79,133.00 Budgeted Account: 35-69009-020-000 erm Debt -Interest 1527 08/01/2020 August A/P Vac truck Interest 1527 08/01/2020 August A/P Camera Van P&I Account: 135-69009-020-000 Account: 135-69195-020-000 Short Term Debt -Interest 11,277.00 Budgeted (8.86) Remaining Gasb34/Reserve for Replacement 53 % Used 59,604.74 19,537.12 100 % Used 19,537.12 79,141.86 FIRST FINANCIAL BANK 6639 AP 6,122.03 1,843.43 7,965.46 FIRST FINANCIAL BANK 6639 AP 3,303.58 11,269.04 FIRST FINANCIAL BANK 6639 AP Totals: 7.96 Remaining 100 % Used 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining 100 % Used 11,269.04 ** .00 130,000.00 0.00 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: 2,399,561.40 ** 225,492.03 Monthly Total 3,144,482.00 Budgeted 744,920.60 Remaining 76 % Used glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 26 Board of Directors Period Ending: 8/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 33 Check Source Number Account: 135-50045-026-000 Workman's Compensation 76 08/01/2020 Insurance/Wrk Comp Expense Aug 19.90 1.99 21.89 GL Account: 135-50045-026-000 Workman's Compensation Totals: 1.99 21.89 ** 30.00 Budgeted 8.11 Remaining 73 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 675.00 .00 675.00 Account: 135-60070-026-000 Dues & Memberships Totals: .00 675.00 ** 750.00 Budgeted 75.00 Remaining 90 5 Used Account: 135-60075-026-000 Meetings 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ZOOM.US 661.79 123.99 785.78 ZOOM.US PC Account: 135-60075-026-000 Meetings Totals: 123.99 785.78 ** 1,300.00 Budgeted 514.22 Remaining 60 % Used Account: 135-60080-026-000 Schools & Training 1727 08/21/2020 AWBD Refund Meeting- Chapman Refund Pcard Purc AWED Meeting 375.00 (375.00) .00 GL Account: 135-60080-026-000 Schools & Training Totals: (375.00) .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Department 26 Totals: 1,482.67 ** (249.02) Monthly Total 3,730.00 Budgeted 2,247.33 Remaining 40 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 35 A000Unt: 135-5000 030- Salaries & We 1574 08/07/2020 MUD Payroll 8/7/2020 Salaries & Wages 341,529.16 1648 08/21/2020 MUD Payroll 8/21/2020 Salaries & Wages Account: 05-0 Salaries & Wages-1111r—Totals: 475,000.00 Budgeted 91,097.49 Remaining Account: 135-50010-030-000 1648 08/21/2020 MUD Payroll 8/21/2020 Overtime Overtime 41.79 81 % Used 21,192.49 362,721.65 21,180.86 383,902.51 4.53 46.32 PR PR PR Account: 135-50010-030-00 Overtime 2,000.00 Budgeted 1,953.68 Remaining 2 % Used Account: 135-50016-030-000 Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 1574 08/07/2020 MUD Payroll 8/7/2020 Retirement 1648 08/21/2020 MUD Payroll 8/21/2020 Retirement 2,207.50 100 % Used 33,330.58 .00 2,207.50 1,962.40 1,961.78 35,292.98 37,254.76 PR PR Account: 135-50020-030-000 Retire 42,000.00 Budgeted Account: 135-50026-030-000 1111PErgrigliffErce 1 1574 08/07/2020 MUD Payroll 8/7/2020 Medical Insurance 1648 08/21/2020 MUD Payroll 8/21/2020 Medical Insurance 4,745.24 Remaining 64,158.49 89 % Used 3,985.11 68,143.60 3,985.06 72,128.66 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 1574 08/07/2020 MUD Payroll 8/7/2020 1648 08/21/2020 MUD Payroll 8/21/2020 81,000.00 Budgeted Dental Insurance Dental Insurance Dental Insurance 8,871.34 Remaining 89 % Used Acc< Dental Insur" Totals: 4,500.00 Budgeted 3,551.87 506.17 Remaining 89 % Used 220.99 3,772.86 PR 220.97 3,993.83 PR glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 JE Detail Description/Comment Page 36 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ACCO 002: -030 - sion Ins 1574 08/07/2020 MUD Payroll 8/7/2020 1648 08/21/2020 MUD Payroll 8/21/2020 Account: Vision Insurance Vision Insurance ision Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 1507 08/01/2020 August Payroll Benefits Employee Benefits 1677 08/25/2020 August A/P cafe 125 plan Account: 135-50029-030-000 Life Insurance & Other 4,500.00 Budgeted 1574 08/07/2020 MUD Payroll 8/7/2020 1648 08/21/2020 MUD Payroll 8/21/2020 Account: 135 535.91 Totals: 433.49 Remaining 58 5 Used 32.81 568.72 32.79 601.51 3,632.76 209.22 16.00 642.02 Remaining 86 b Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 26,000.00 Budgeted A Medicare Tax= 1574 08/07/2020 MUD Payroll 8/7/2020 Medicare Taxes 1648 08/21/2020 MUD Payroll 8/21/2020 Medicare Taxes ccou edicare 6,200.00 Budgeted 3,681.92 Remaining 19,887.86 4,651.21 86 5 Used 11.11 PR PR 3,841.98 Humana Inc 6642 AP 3,857.98 BenefitMall 6733 AP 1,217.09 21,104.95 1,213.13 22,318.08 284.65 283.72 980.42 Remaining 84 5 Used 4,935.86 5,219.58 PR PR PR PR Account: 135-50040-030-000 Unemployment Taxes Account: 135-50040-030-000 Unemployment Taxes 1,440.00 Budgeted 1,008.00 432.00 Remaining 70 5 Used Account: 135-50045-030-000 Workman's Compensatio 76 08/01/2020 Insurance/Wrk Comp Expense Aug 1729 08/21/2020 TML WC & Liab Refund Admin Portion of WC Equity Ref .00 1,008.00 1,048.20 104.82 1,153.02 GL (79.78) 1,073.24 GL glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 37 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: Account: 135-50060-030-000 Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Workman's Compensatio 25.1111 1,775.00 Budgeted 701.76 Remaining 60 % Ueed Pre-emp Physicals/Testing Pre-emp Physicals/Testing 500.00 Budgeted Employee Relations Employee Relations 4,000.00 Budgeted 500.00 Remaining 0 % Ueed 3,078.10 921.90 Remaining 77 % Ueed Account: 135-55030-030-000 Software & Support 1631 08/13/2020 August A/P Internet -August 1631 08/13/2020 August A/P Software support 1677 08/25/2020 August A/P Microsoft exchange 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 DNH*GODADDY.COM 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ATT*BILL PAYMENT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ATT*BILL PAYMENT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ATT*BILL PAYMENT 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 ADOBE ACROPRO SUBS 1746 08/31/2020 August A/P Extra employee license 1801 08/31/2020 Reclass Exp Capital- Software Halff G1S Asset Relo Cap 07/23 1801 08/31/2020 Reclass Exp Capital- Software Halff GIS Asset Relo Cap 08/25 1801 08/31/2020 Reclass Exp Capital- Software Halff G1S Deployment Cap 02/17 1801 08/31/2020 Reclass Exp Capital- Software Halff GIS Deployment Cap 05/11 1801 08/31/2020 Reclass Exp Capital- Software Halff GIS Deployment Cap 07/16 1801 08/31/2020 Reclass Exp Capital- Software Halff GIS Deployment Cap 08/17 1801 08/31/2020 Reclass Exp Capital- Software Halff GIS Deployment Cap 08/17 1801 08/31/2020 Reclass Exp Capital- Software Mercury Phone System Cap 08/25 Software & Su. 154,681.00 Budgeted 1 Account: 135-55070-030-000 MEM Independent Labor 57,604.24 Remaining .00 .00 .00 3,078.10 86,391.95 899.00 87,290.95 Charter Communications 6692 AP 145.00 87,435.95 OpenGov, Inc 6715 AP 484.00 87,919.95 M3 Networks 6745 AP 39.34 87,959.29 DNH*GODADDY.COM PC 74.52 88,033.81 ATT*SILL PAYMENT PC 64.52 88,098.33 ATT*BILL PAYMENT PC 43.01 88,141.34 ATT*SILL PAYMENT PC 36.78 88,178.12 ADOBE ACROPRO SUBS PC 52.00 88,230.12 Data Management Inc. 6776 AP 500.00 88,730.12 GL 2,260.00 90,990.12 GL 47.39 91,037.51 GL 3,669.08 94,706.59 GL 266.20 94,972.79 GL 1,054.10 96,026.89 GL 443.67 96,470.56 GL 606.20 97,076.76 GL 63 Used glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 38 Account: 135-55070-030-05 Account: 135-55080-030-000 1640 08/17/2020 August A/P 1640 08/17/2020 August A/P 1640 08/17/2020 August A/P 1677 08/25/2020 August A/P 1746 08/31/2020 August A/P Account: 135-55080-030-000 Independent Labor Totals: 100,000.00 Budgeted 90,226.07 .00 90,226.07 9,773.93 Remaining 90 % Used Maintenance & Repairs office A/C Building maintenance Building maintenance office A/C A/C annex bldg Maintenance & Repairs To Account: 135-55085-030-000 - 1640 08/17/2020 August A/P Account: 135-55085-030-000 MIK 30,000.00 Budgeted 19,172.36 Generator Maint. and Repair Generator yearly maintenance Remaining Generator Maint. and Repair Tot= 10,000.00 Budgeted 8,831.00 Remaining Account: 135-55120-030-0 aning Service. 1631 08/13/2020 August A/P Janitorial service -July AC Cleaning Services 15,000.00 Budgeted 1,855.00 36 Used 260.00 1,992.00 6,310.64 285.00 125.00 2,115.00 BRANDON R REED 4,107.00 R & D Electric 10,417.64 Servpro of Crowley 10,702.64 BRANDON R REED 10,827.64 BRANDON R REED 6690 AP 6717 AP 6719 AP 6734 AP 6773 AP 531.00 638.00 1,169.00 Sluder Emergency Power Service 6720 AP 12 Used 11,452.48 1,896.92 13,349.40 MEMBER'S BUILDING MAINTENANCE 1,650.60 Remaining 89 % Used 6710 AP Account: 135-55160-0_ Professional Outside Services Account: 135-55160-030-000 Professional Outside Services Totals: 65,600.00 Budgeted 8,500.00 Remaining Account: 135-55205-030-000 Utility Billing Contract 1631 08/13/2020 August A/P Water billings -July 1793 08/31/2020 August A/P Billing -August Acc Utility Billing C. Totals: 9,000.00 Budgeted 2,598.72 Remaining 57,100.00 .00 57,100.00 87 % Used 5,253.58 562.52 585.18 71 % Used 5,816.10 DATAPROSE LLC 6696 AP 6,401.28 DATAPROSE LLC AP glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number ACCO JE Date 30 - JE Description 1490 08/01/2020 August A/P 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1745 08/31/2020 Town Billed Invoices 1750-1752 1746 08/31/2020 August A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2020 Beginning Balance JE Detail Description/Comment Answering service -August ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC AR 20200831-20200831 User: Phone repair Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 16,066.93 215.58 16,282.51 476.31 16,758.82 807.64 17,566.46 181.58 17,748.04 16.76 17,764.80 (180.00) 17,584.80 389.70 17,974.50 MERCURY COMMUNICATION SERVICES KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*SILL PAYMENT RINGCENTRAL, INC Page 39 Check Source Number 6620 AP PC PC PC PC AR 6783 AP Account: 135-60005-030-000 7,974.50 ** Account: 135-60010-030- 1648 08/21/2020 MUD Payroll 8/21/2020 Account: 135-60020-030-00' 1631 08/13/2020 August A/P ACC ACC 23,680.00 Budgeted 5,705.50 unicati. Communications/Mobiles Remaining Communications/Mobilesr Totals: 3,000.00 Budgeted 409.95 Remaining Electricity/ Gexa Energy 6/9-7/10 6,879.00 Budgeted 1,577.93 1631 08/13/2020 August A/P water July 1745 08/31/2020 Town Billed Invoices 1750-1752 AR 20200831-20200831 User: 1746 08/31/2020 August A/P water -August Account: 135-50025-030-0., Water Remaining Totals: 1,500.00 Budgeted (148.39) Remaining Account: 135-60035-030-000 ., . 1631 08/13/2020 August A/P Water billings -July 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 FP MAILING SOLUTIONS 1793 08/31/2020 August A/P Billing -August 25,000.00 Budgeted 6,412.51 Remaining 76 % Used 2,365.05 225.00 2,590.05 PR 2,590.05 4,853.12 86 % Used 77 % Used 447.95 5,301.07 TOWN OF TROPHY CLUB 1,221.58 284.54 1,506.12 (142.27) 1,363.85 284.54 1,648.39 TROPHY CLUB MUD (WATER BILLS) 110 % Ueed 15,057.62 74 % Ueed TROPHY CLUB MUD (WATER BILLS) 1,425.25 414.00 1,690.62 16,482.87 DATAPROSE LLC 16,896.87 FP MAILING SOLUTIONS 18,587.49 DATAPROSE LLC 6726 AP 6728 AP AR 6791 AP 6696 AP PC AP glpdatb2 skrolczyk Trophy Club MUD No.1 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 40 Account: 135-60040-030-000 Service Charges & Fees 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1726 08/31/2020 Pace Credit Card Fees 1726 08/31/2020 Pace Credit Card Fees 1746 08/31/2020 August A/P 1793 08/31/2020 August A/P Dig Tess -July Direct send fees -July Direct send fees -Aug Dig Tess -Aug 58,736.57 277.05 59,013.62 Texas Excavation Safety System 6723 AP 50.00 59,063.62 Fisery Solutions, LLC 6699 AP 6,791.55 65,855.17 GL 35.55 65,890.72 GL 50.00 65,940.72 Fisery Solutions, LLC 6778 AP 181.80 66,122.52 Texas Excavation Safety System AP Account: 135-60040-030-000 Service Charges & Fees Totals: 7,385.95 66,122.52 ** 67,000.00 Budgeted 877.48 Remaining 99 5 Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 76 08/01/2020 1729 08/21/2020 Insurance/Wrk Comp Expense Aug TEL WC & Liab Refund Liability Equity Refund 66,422.04 6,998.39 (431.00) 73,420.43 72,989.43 GL GL Account: 135-60055-030-000 Insurance Totals: 6,567.39 72,989.43 ** 80,419.00 Budgeted 7,429.57 Remaining 91 5 Used Account: 135-60066-030-000 Publications/Books/Subscripts 125.00 .00 125.00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 125.00 ** 1,000.00 Budgeted 875.00 Remaining 13 5 Used Account: 135-60070-030-000 Dues & Memberships 1749 08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 GOVERNMENT FINANCE OFF Pcard 07/28/2020-08/26/2020 SAMS CLUB RENEWAL 4,428.55 160.00 18.81 4,588.55 4,607.36 GOVERNMENT SAMS CLUB FINANCE RENEWAL OFF PC PC Account: 135-60070-030-000 Dues & Memberships Totals: 178.81 4,607.36 ** 6,000.00 Budgeted 1,392.64 Remaining 77 % Used Account: 135-60075-030-000 Meetings glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2020 JE Detail Beginning Balance Description/Comment pett cash reimbursement pett cash reimbursement pett cash reimbursement Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 115.09 6.00 121.09 TROPHY CLUB MUD PETTY CASH 21.29 142.38 TROPHY CLUB MUD PETTY CASH 6.48 148.86 TROPHY CLUB MUD PETTY CASH Page 41 Check Source Number 6750 AP 6750 AP 6750 AP Account: 135-60075-030-000 Meetings Totals: 33.77 148.86 ** 1,461.99 3,883.20 ** ' 400.00 Budgeted 251.14 Remaining 37 % Used 3,000.00 Budgeted Account: 135-60079-030-000 % Used Public Education Account: 135-60100-030-000 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 Pcard Pcard Pcard 07/28/2020-08/26/2020 07/28/2020-08/26/2020 07/28/2020-08/26/2020 DEEDS.COM CFW PARKING METER NCOURT *TXTARRANTCOSWP 4,047.85 177.00 1.25 157.77 4,224.85 4,226.10 4,383.87 DEEDS.COM CFW PARKING METER NCOURT *TXTARRANTCOSWP PC PC PC Account: 135-60079-030-000 1648 1648 08/21/2020 1717 08/31/2020 Public Education Totals: Travel & tolls to per lab 336.02 4,383.87 ** 33.76 3.23 1,201.74 1,204.97 NTTA 6,000.00 Budgeted 1,616.13 Remaining 73 5 Used Travel & per diem Account: 135-60080-030-000 Schools & Training_ 1,204.97 ** Mr 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 GOVERNMENT FINANCE OFF TEXAS MUNICIPAL LEAGUE TEEX ECOMMERCE TEEX ECOMMERCE TEXAS FLOODPLAIN MANAG AMERICAN WATER COLLEGE 2,421.21 220.00 (48.00) 425.00 440.00 125.00 299.99 2,641.21 2,593.21 3,018.21 3,458.21 3,583.21 3,883.20 GOVERNMENT FINANCE OFF TEXAS MUNICIPAL LEAGUE TEEX ECOMMERCE TEEX ECOMMERCE TEXAS FLOODPLAIN MANAG AMERICAN WATER COLLEGE PC PC PC PC PC PC Account: 135-60080-030-000 Schools & Training Totals: 1,461.99 3,883.20 ** ' 3,000.00 Budgeted (883.20) Remaining 129 % Used Account: 135-60100-030-000 Travel & per diem L IL - 1648 1648 08/21/2020 1717 08/31/2020 MUD Payroll Aufgust A/P 8/21/2020 Travel & tolls to per lab diem 1,167.98 33.76 3.23 1,201.74 1,204.97 NTTA 6786 PR AP Account: 135-60100-030-000 Travel & per diem Totals: 36.99 1,204.97 ** 1,500.00 Budgeted 295.03 Remaining 80 s Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60115-030-000 Elections 138.04 Account: 135-60115-030-000 Elections Totals: 200.00 Budgeted Advertising Advertising Totals: 6,000.00 Budgeted 1,888.20 Remaining Account: 135-60125-030-000 Account: 135-60125-030-000 ACC • 61.96 Remaining 69 % Used 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P II235-030-000 .00 138.04 4,111.80 .00 4,111.80 monitoring evc-july 216.00 monitoring svc-Aug Security 1,288.00 Budgeted 69 % Ueed 24.00 240.00 Digital Air Control, Inc 6737 AP 24.00 264.00 Digital Air Control, Inc 6737 AP Totals: 48.00 1,024.00 Remaining 20 % Used Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 Miscellaneous Expenses 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 Account: 135-60360-030-000 A_ .00 Totals: 500.00 Remaining 0 % Used General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Account: 135-60360-030-000 Furniture/Equipment < $5000 To 2,500.00 Budgeted 473.01 Remaining 2,026.99 0 % Ueed 81 .00 .00 .00 .00 Used 2,026.99 Account: 135-65010-030-000 glpdatb2 ekrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-65010-030-05 JE Description Account: 135-65055-030-000 1746 08/31/2020 August A/P Account: 135-65055-030-000 Account: 135- 1631 08/13/2020 1677 08/25/2020 1677 08/25/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 Account: Account: 65085-030- August A/P 135-65085- Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2020 JE Detail Beginning Balance Description/Comment Uniforms 2,050.00 Budgeted Hardware Badge cards Hardware 26,485.00 Budgeted Totals: 2,050.00 Remaining 19,906.30 Remaining Program: Transaction Detail .00 0 % Used Transaction Vendor Name Detail (SUBTOTAL) .00 6,331.70 247.00 6,578.70 3RD EYE SURVEILLANCE SYSTEMS 25 % Used Page 43 Check Source Number 6771 AP Office Supplies office supplies office supplies office supplies AMZN MKTP US*MF7KW3XI2 AMZN MKTP US*MF2OM96R1 AMAZON.COM*MM9AJ13K2 August A/P August A/P Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 135-65095-030-000 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 1749 08/26/2020 Pcard 07/28/2020-08/26/2020 AMZN MKTP AMZN MKTP AMZN MKTP AMZN MKTP AMZN MKTP AMZN MKTP AMZN MKTP 6,000.00 Budgeted US*MM2YN6FY1 US*MM2YN6FY1 US*MM2YN6FY1 US*MM2YN6FY1 US*MM2YN6FY1 US*MF9062HJ2 US*MF9BH5A42 Maintenance Supplies hand sanitizer pett cash reimbursement pett cash reimbursement AMAZON.COM*MF8T248W0 AMAZON.COM*MF5T26830 AMAZON.COM*MF3VF9800 AMAZON.COM*MF66G1800 AMAZON.COM*MF6C75YL1 AMAZON.COM*MF1YUO8Y2 AMAZON.COM*MF9ZF1WD1 904.86 Remaining 4,518.59 3,598.16 85 89.18 4,607.77 119.06 4,726.83 7.92 4,734.75 20.01 4,754.76 32.48 4,787.24 179.90 4,967.14 (53.99) 4,913.15 53.99 4,967.14 53.99 5,021.13 (53.99) 4,967.14 53.99 5,021.13 21.84 5,042.97 52.17 5,095.14 Ueed 29.94 3,628.10 23.88 3,651.98 7.47 3,659.45 11.83 3,671.28 11.83 3,683.11 11.04 3,694.15 25.70 3,719.85 27.45 3,747.30 25.70 3,773.00 41.04 3,814.04 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC AMZN MKTP US*MF7KW3XI2 AMZN MKTP US*MF20M96R1 AMAZON.COM*MM9AJ13K2 AMZN MKTP US*MM2YN6FY1 AMZN MKTP US*MM2YN6FY1 AMZN MKTP US*MM2YN6FY1 AMZN MKTP US*MM2YN6FY1 AMZN MKTP US*MM2YN6FY1 AMZN MKTP US*MF9062HJ2 AMZN MKTP US*MF9BH5A42 1 OFFICE DEPOT, INC TROPHY CLUB MUD PETTY CASH TROPHY CLUB MUD PETTY CASH AMAZON. COM*MF8T248W0 AMAZON.COM*MF5T26830 AMAZON. COM*MF3VF9800 AMAZON.COM*MF66G1800 AMAZON.COM*MF6C75YL1 AMAZON. COM*MF1YUO8Y2 AMAZON.COM*MF9ZF1WD1 6714 AP 6747 AP 6747 AP PC PC PC PC PC PC PC PC PC PC 6747 AP 6750 AP 6750 AP PC PC PC PC PC PC PC glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund JE Number JE Date 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 1749 08/26/2020 JE Description Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Pcard 07/28/2020-08/26/2020 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2020 JE Detail Beginning Balance Description/Comment AMAZON.COM*MF38R2IZ1 pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim pcard used in err-ck#1622 reim WALMART.COM AS BRANDLESS.COM SAMSCLUB.COM WAL-MART #0266 WALMART GROCERY Maintenance Supplies 7,500.00 Budgeted Totals: 3,130.10 Remaining 3,598.16 58 % Used Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 45.03 3,859.07 (1.42) 3,857.65 (2.56) 3,855.09 40.51 3,895.60 15.67 3,911.27 31.57 3,942.84 1.42 3,944.26 39.50 3,983.76 54.06 4,037.82 30.00 4,067.82 224.19 4,292.01 12.86 4,304.87 65.03 4,369.90 AMAZON.COM*MF38R2IZ1 WALMART GROCERY WALMART GROCERY WALMART GROCERY WALMART GROCERY WALMART GROCERY WALMART GROCERY WALMART GROCERY WALMART.COM AS BRANDLESS.COM SAMSCLUB.COM WAL-MART #0266 WALMART GROCERY Page 44 Check Source Number PC PC PC PC PC PC PC PC PC PC PC PC PC Printing .00 .00 Account: 135-65105-030-000 Printing Totals: Account: 135-69005-030-000 1631 08/13/2020 August A/P 1631 08/13/2020 August A/P 1640 08/17/2020 August A/P 1677 08/25/2020 August A/P 1677 08/25/2020 August A/P 1746 08/31/2020 August A/P 1801 08/31/2020 Reclass Exp Capital - 2,500.00 Budgeted 2,500.00 Remaining Capital Outlays GIS support GIS Database development Building maintenance Asset locater phone system repair Phase III Security project Software Capital to Software & Support 41,887.60 0 % Used 1,054.10 443.67 3,768.00 2,260.00 606.20 12,492.13 (8,846.64) 42,941.70 43,385.37 47,153.37 49,413.37 50,019.57 62,511.70 53,665.06 Halff Associates, INC Halff Associates, INC R & D Electric Halff Associates, INC MERCURY COMMUNICATION SERVICES 3RD EYE SURVEILLANCE SYSTEMS 6701 AP 6701 AP 6717 AP 6739 AP 6746 AP 6771 AP GL Account: 135-69005-030-000 Capital Outlays Totals: 1631 08/13/2020 August A/P 1677 08/25/2020 August A/P 180,000.00 Budgeted 126,334.94 Remaining Copier Lease Installments copier lease-jaug copies AccEl Copier Lease Installments Totals: 4,000.00 Budgeted 1,364.79 Remaining 30 % Used 2,416.03 165.00 2,581.03 TIAA COMMERCIAL FINANCE 54.18 2,635.21 KYOCERA DOCUMENT SOLUTIONS 6725 AP 6743 AP 21 66 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1 Department 30 Totals: 1,091,291.77 ** 117,546.76 Monthly Total 1,519,540.00 Budgeted 428,248.23 Remaining 72 % Used glpdatb2 skrolczyk 11:58 09/16/20 Fund: 135 MUD 1 General Fund ACCO JE JE JE Number Date Description 5-55045-039-0 1631 08/13/2020 August A/P 1793 08/31/2020 August A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Program: Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment legal 98,160.39 2,957.50 legal Account:45-039-0 Totals: 135,000.00 Budgeted 31,769.61 Remaining Account: 135-55055-039-000 1631 08/13/2020 August A/P 1746 08/31/2020 August A/P Account: 135-55055-039-000 Auditing auditor to auditor communicati FY 20 Audit preperatioa 2,112.50 76 % Used Page 46 Check Source Number 101,117.89 McLean & Howard, L.L.P. 6709 AP 103,230.39 McLean & Howard, L.L.P. 27,713.27 195.00 27,908.27 LAFOLLETT & COMPANY, PLLC 3,999.45 31,907.72 CliftonLarsonAllen 33,800.00 Budgeted 1,892.28 Remaining 94 % Used Account: 135 - Account: 135-55060-039-000 Account: 135-55065-039-000 1 4,194.45 31,907.72 ** Appraisal 9,665.52 .00 9,665.52 Appraisal - Totals: 11,761.00 Budgeted 2,095.48 Remaining 82 % Used Tax Admin Fees 3,756.00 .00 3,756.00 AP 6708 AP 6775 AP Account: 135-55065-039-000 Tax Admin Fees Totals: Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 244.00 Remaining 94 % Used 148,559.63 ** 9,264.45 Monthly Total 184,561.00 Budgeted 36,001.37 Remaining 80 % Used (1,209,465.50) (307,062.19) Monthly Total (49,115.00) Budgeted 1,160,350.50 Remaining ########## glpdatb2 skrolczyk 11:58 09/16/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 8/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 47 Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET AUGUST 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 492,331 TOTAL ASSETS 492,331 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (118,410) (74,735) TOTAL FUND BALANCE (193,145) TOTAL LIABILITIES AND FUND BALANCE 492,331 glbase tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 74.33- 5,064.72- 5,064.72 Page 14 Subtotal: Mr- 74.33- 5,064.72- 5,064.72 Program number: 74.33- 5,064.72- 5,064.72 Department number: Revenues 74.33- 5,064.72- 5,064.72 Revenues Subtotal 74.33- 5,064.72- 5,064.72 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 8/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,772.50 Program: YTD Total 79,800.16 % of Remaining Budget Budget 79,800.16 - Page 15 Subtotal: 2,772.50 79,800.16 79,800.16 - Program number: M 2,772.50 79,800.16 79,800.16 - Department number: Wastewater 2,772.50 79,800.16 79,800.16 - Expenditures Subtotal 2,772.50 79,800.16 79,800.16 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 2,698.17 74,735.44 74,735.44- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/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 1751 08/31/2020 Bank Interest- August Accoun Department Totals: (4,990.39) Interest Income Totals: .00 Budgeted 5,064.72 Remaining 0 % Used (74.33) Monthly Total .00 Budgeted (74.33) (5,064.72) GL (74.33) (5,064.72) (5,064.72) •e 5,064.72 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOunt: 517-69005-020-0 1677 08/25/2020 August A/P 1696 08/31/2020 August A/P Capital Outlays WWTP legal WWTP legal Account: - Capital Outlays .00 Budgeted 77,027.66 817.50 77,845.16 Wiss, Janney, Elstner Assoc Totals: (79,800.16) Remaining 0 % Used 6751 AP 1,955.00 79,800.16 Dubois Bryant Campbell LLP 6752 AP Department 20 Totals: 79,800.16 ** 2,772.50 Monthly Total .00 Budgeted (79,800.16) Remaining 0 % Used Fund 517 Totals: 74,735.44 2,698.17 Monthly Total .00 Budgeted (74,735.44) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET AUGUST 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,960 TOTAL ASSETS 784,960 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 698,648 4,621 703,269 784,960 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 519 2016 Rev Bond Const -SWIFT Account Description 519-49011-000-000 Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: Department number: Revue Revenues Subtotal Fund number: 519 2016 Rev Bond Const -SWIFT 6.67- 6.67- 6.67- 6.67- 6.67- 6.67- 4,621.49- 4,621.49- 4,621.49- 4,621.49- 4,621.49- 4,621.49 - 4,621.49 4,621.49 4,621.49 4,621.49 4,621.49 4,621.49 Page 16 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 8/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 1751 08/31/2020 Bank Interest- August (4,614.82) (6.67) (4,621.49) GL Accountil Interest Income Totals: (6.67) (4,621.49) ** .00 Budgeted 4,621.49 Remaining 0 % Uaed Department Totals: (4,621.49) ** (6.67) Monthly Total .00 Budgeted 4,621.49 Remaining 0 % Used Fund 519 Totals: (4,621.49) (6.67) Monthly Total .00 Budgeted 4,621.49 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET AUGUST 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 279,051 INVESTMENTS 3,892,492 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,171,543 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,454,290 (282,747) 4,171,543 4,171, 543 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 75.85- 27,855.77- 27,855.77 Page 17 Subtotal: 75.85- 27,855.77- 27,855.77 Program number: 75.85- 27,855.77- 27,855.77 Department number: 75.85- 27,855.77- 27,855.77 Revenues Subtotal 75.85- 27,855.77- 27,855.77 glbase_tbam skrolczyk 11:57 09/16/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: 8/2020 Adopted Amended Total Current Budget Budget Encumb. Month 6,061.80 Program: YTD Total 310,602.62 % of Remaining Budget Budget 310,602.62 - Page 18 Subtotal: 6,061.80 310,602.62 310,602.62 - Program number: M 6,061.80 310,602.62 310,602.62 - Department number: Water Department 7. 6,061.80 310,602.62 310,602.62 - Expenditures Subtotal 6,061.80 310,602.62 310,602.62 - Fund number: 520 Revenue Bond 16" Waterline MINIM 5,985.95 282,746.85 282,746.85- glpdatb2 skrolczyk 11:58 09/16/20 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.l Detailed Accounting Trial Balance Program: Page 51 Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 1751 08/31/2020 Bank Interest- August (27,779.92) 1751 08/31/2020 Bank Interest- August Account: 520-490 Department Totals: Interest Income Totals: .00 Budgeted 27,855.77 Remaining 0 % Used (75.65) Monthly Total .00 Budgeted (42.79) (27,822.71) GL (33.06) (27,855.77) GL (27,855.77) ** 27,855.77 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACno t: 520-6900 010- 1631 08/13/2020 August A/P 1644 08/17/2020 August A/P 1677 08/25/2020 August A/P Capital Outlays 16" water line Easement acquisition 16" water Easement acquisition Closing F Capital 0'ys .00 Budgeted 304,540.82 4,800.00 309,340.82 Halff Associates, INC 40.33 309,381.15 Jackson Walker LLP 1,221.47 310,602.62 Community National Title LLC (310,602.62) Remaining 0 % Ueed Department 10 Totals: 310,602.62 •• 6,061.80 Monthly Total .00 Budgeted (310,602.62) Remaining 0 % Used Fund 520 Totals: 282,746.85 5,985.95 Monthly Total .00 Budgeted (282,746.85) Remaining 0 % Used 6701 AP 6731 AP 6735 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,759 TOTAL ASSETS 893,759 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 803,457 90,302 893,759 893,759 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 528 2015 Revenue Bond Reserve Fund Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 8/2020 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 19 528-49011-000-000 528-49142-000-000 1 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- 134.19- 7,502.09- 36,800.00- 46,000.00- 68.201 11.985 22.952 3,497.91- 270,249.00- 154,417.00- Subtota1: = 518,466.00- 518,466.00- = 134.19- 90,1t2.09- 17.417 428,163.91 - Program number: 518,466.00- 518,466.00- 134.19- 90,302.09- 17.417 428,163.91 - Department number: 518,466.00- 518,466.00- 134.19- 90,302.09- 17.417 428,163.91 - Revenues Subtotal 518,466.00- 518,466.00- 134.19- 90,302.09- 17.417 428,163.91- 1 Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 134.19- 90,302.09- 17.417 428,163.91- glpdatb2 skrolczyk 11:58 09/16/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 8/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: Fund 528 Totals: (134.19) Monthly Total (90,302.09) ** (518,466.00) Budgeted (428,163.91) Remaining 17 % Used (90,302.09) (134.19) Monthly Total (518,466.00) Budgeted (428,163.91) Remaining 17 % Used Account: 528-49011-000-000 Interest Income 1751 08/31/2020 Bank Interest- August (7,367.90) (134.19) (7,502.09) GL Account: 528-49011-000-000 Interest Income Totals: (134.19) (7,502.09) ** (11,000.00) Budgeted (3,497.91) Remaining 68 % Used Account: 528-49142-000-000 Interfund transfer in -Water (36,800.00) .00 (36,800.00) Account: 528-49142-000-000 Interfund transfer in -Water Totals: .00 (36,800.00) ** (307,049.00) Budgeted (270,249.00) Remaining 12 % Used Account: 528-49143-000-000 Interfund transfer in -WW (46,000.00) .00 (46,000.00) Account: 528-49143-000-000 Interfund transfer in -WW Totals: _ .00 (46,000.00) ** (200,417.00) Budgeted (154,417.00) Remaining 23 % Used Department Totals: Fund 528 Totals: (134.19) Monthly Total (90,302.09) ** (518,466.00) Budgeted (428,163.91) Remaining 17 % Used (90,302.09) (134.19) Monthly Total (518,466.00) Budgeted (428,163.91) Remaining 17 % Used TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET AUGUST 2020 ASSETS CASH IN BANK INVESTMENTS 34,142 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,907 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 44,049 FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,907 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,907 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES (48,812) TOTAL FUND BALANCE 34,142 TOTAL LIABILITIES AND FUND BALANCE 44,049 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-40000-000-000 533-40002-000-000 533-40015-000-000 533-49011-000-000 533-49015-000-000 533-49141-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Subtotel Program number: Department number: Revenues Revenues Subtotal Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 8/2020 Adopted Amended Total Current Budget Budget Encumb. Month 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 685,441.00- 685,441.00- 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 0- 337,567.00- 0- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 171.53- 348.20- 419.88 - Program: YTD % of Remaining Total Budget Budget 687,622.82- 2,327.77- 3,288.70- 100.759 232.777 164.435 5,181.82 1,327.77 1,288.70 693,239.29- 7 107.12- 4,169.44- 83.389 218,004.00- 100.000 10,414.81- 114,562.91- 100.000 10,521.93- I99.754 11,461.54- 1,029, 100.681 11,461.54- 1,029,975.64- 100.681 11,461.54- 1,029,975.64- 100.681 830.56- .09- .3137 6,9 6,96 6,961 Page 20 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 533-70020-051-000 533-70025-051-000 533-70035-051-000 Paying Agent Fee Bond Issuance Bond Interest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 700.00 100,472.61 765,000.00 2,150.00 87,236.14 224,401.36 765,000.00 100.000 90.536 100.000 87,236.14- 23,456.64 Page 21 ir Subtotal: 1,015,008.00 1,015,008.00 866,172.61 1,078,787.50 106.284 63,779.50 - Program number: 1,015,008.00 1,015,008.00 866,172.61 1,078,787.50 106.284 63,779.50 - Department number: Administration 1,015,008.00 1,015,008.00 866,172.61 1,078,787.50 106.284 63,779.50 - Expenditures Subtotal 1,015,008.00 1,015,008.00 866,172.61 1,078,787.50 106.284 63,779.50 - Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 854,711.07 48,811.86 -610.148 56,811.86- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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 ■. Property Taxes 1755 08/03/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1758 08/06/2020 Property Taxes 1759 08/07/2020 Property Taxes 1760 08/10/2020 Property Taxes 1761 08/11/2020 Property Taxes 1762 08/17/2020 Property Taxes 1763 08/21/2020 Property Taxes 1764 08/25/2020 Property Taxes 1692 08/26/2020 August A/P Tax Shortage Denton Refund Tax Shortage 1766 08/28/2020 Property Taxes (687,451.29) (333.87) (687,785.16) GL (248.03) (688,033.19) GL (175.59) (688,208.78) GL 119.06 (688,089.72) GL (53.59) (688,143.31) GL (33.81) (688,177.12) GL (.02) (688,177.14) GL (3.53) (688,180.67) GL (24.56) (688,205.23) GL (3.55) (688,208.78) GL 641.01 (687,567.77) DENTON COUNTY TAX OFFICE 6753 AP (55.05) (687,622.82) GL Account: 533-40000-000-000 Property Taxes Totals: (171.53) (687,622.82) ** 1 (682,441.00) Budgeted 5,181.82 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1765 08/27/2020 Property Taxes 1766 08/28/2020 Property Taxes 1767 08/31/2020 Property Taxes (1,979.57) (27.32) (2,006.89) GL (10.61) (2,017.50) GL (7.47) (2,024.97) GL (296.91) (2,321.88) GL (5.89) (2,327.77) GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (348.20) (2,327.77) ** (1,000.00) Budgeted 1,327.77 Remaining 233 % Used Account: 533-40015-000-000 Property Taxes/P & I 1755 08/03/2020 Property Taxes 1756 08/04/2020 Property Taxes 1757 08/05/2020 Property Taxes 1758 08/06/2020 Property Taxes 1759 08/07/2020 Property Taxes 1760 08/10/2020 Property Taxes 1763 08/21/2020 Property Taxes 1764 08/25/2020 Property Taxes 1692 08/26/2020 August A/P Tax Shortage Denton Refund Tax Shortage 1765 08/27/2020 Property Taxes 1766 08/28/2020 Property Taxes 1767 08/31/2020 Property Taxes (2,868.82) (2.96) (2,871.78) GL (5.43) (2,877.21) GL (35.89) (2,913.10) GL 14.07 (2,899.03) GL (5.32) (2,904.35) GL (6.33) (2,910.68) GL (1.74) (2,912.42) GL (.68) (2,913.10) GL (14.07) (2,927.17) DENTON COUNTY TAX OFFICE 6753 AP (1.87) (2,929.04) GL (358.01) (3,287.05) GL (1.65) (3,288.70) GL glpdatb2 skrolczyk 11:58 09/16/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 55 Check Source Number Department Totals: (114,563.00) Budgeted (11,461.54) Monthly Total (.09) Remaining 100 % Used (1,029,975.64) ** (1,023,008.00) Budgeted 6,967.64 Remaining 101 % Used Account: 533-40015-000-000 * Property Taxes/P & I Totals: (419.88) (3,288.70) ** (2,000.00) Budgeted 1,288.70 Remaining 164 % Used Account: 533-49011-000-000 Interest Income 1751 08/31/2020 Bank Interest- August (4,062.32) (107.12) (4,169.44) GL Account: 533-49011-000-000 Interest Income Totals: (107.12) (4,169.44) ** (5,000.00) Budgeted (830.56) Remaining 83 % Used Account: 533-49015-000-000 Lease/Rental Income (218,004.00) .00 (218,004.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,004.00) ** (218,004.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1664 08/20/2020 TexPool Transfers August TexPool O&M to I&S- PID Debt (104,148.10) (10,414.81) (114,562.91) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (114,562.91) ** Department Totals: (114,563.00) Budgeted (11,461.54) Monthly Total (.09) Remaining 100 % Used (1,029,975.64) ** (1,023,008.00) Budgeted 6,967.64 Remaining 101 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACnompt: 533-70005-0 - Paying Agent Fe il 1701 08/25/2020 9/1/20 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 1,450.00 1701 08/25/2020 9/1/20 Bond Payments TCMUD1-13 Paying Agent Fee Account:5-0 aying Agent Fee 2,150.00 Budgeted Account: 533-70020-051-000 Bond Issuance Account: 533-70020-051-000 Bond Issuance .00 Budgeted • Totals: .00 Remaining 100 % Used 87,236.14 (87,236.14) Remaining 0 % Used Account: 533-70025-05 Bond Interest Expense - 1701 08/25/2020 9/1/20 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 1701 08/25/2020 9/1/20 Bond Payments BNY MELLON Unl Tax Series 2010 1701 08/25/2020 9/1/20 Bond Payments BNYMELLON Unl Tax Ref Ser 2012 1701 08/25/2020 9/1/20 Bond Payments BNYMELLON Unl Tax Ref Ser 2013 1701 08/25/2020 9/1/20 Bond Payments JPMorgan Unl Tax Bond 20, 7009 Account: 533-70025-051-000 123,928.75 Bond Interest Expense -Tax 247,858.00 Budgeted 23,456.64 Remaining Account: 533-70035-051- d Principal Payment -T. 1701 08/25/2020 9/1/20 Bond Payments BORF Unl Tax Bond, 1TROP1214UT 1701 08/25/2020 9/1/20 Bond Payments 1701 08/25/2020 9/1/20 Bond Payments 1701 08/25/2020 9/1/20 Bond Payments BNY MELLON Unl Tax Series 2010 BNYMELLON Unl Tax Ref Ser 2012 BNYMELLON Unl Tax Ref Ser 2013 Account:=613717571MAI Bond Principal Payment -Tax T Totals: 765,000.00 Budgeted .00 Remaining Department 51 Totals: Fund 533 Totals: 91 % Used 100 % Used 200.00 1,650.00 GL 500.00 2,150.00 GL .00 87,236.14 66,887.50 190,816.25 3,237.50 194,053.75 14,175.00 208,228.75 12,912.50 221,141.25 3,260.11 224,401.36 100,472.61 224,401.36 255,000.00 90,000.00 225,000.00 195,000.00 255,000.00 345,000.00 570,000.00 765,000.00 1,078,787.50 ** 866,172.61 Monthly Total 1,015,008.00 Budgeted (63,779.50) Remaining 106 % Used 854,711.07 Monthly Total 48,811.86 (8,000.00) Budgeted (56,811.86) Remaining ########## GL GL GL GL GL GL GL GL GL TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET AUGUST 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 25,985 TOTAL ASSETS 25,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 24,518 1,467 25,985 TOTAL LIABILITIES AND FUND BALANCE 25,985 glbase_tbam skrolczyk 11:57 09/16/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: 8/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 598,638.00- Subtot Program number: Department number: Revenues Revenues Subtotal 60I�0- 601 00- 6011'38.00- 601,138.00- 2,500.00- 598,638.00- 6011.38.00- 601,138.00- 601,138.00- 601,138.00- 57.74- 54,421.63- 1,467.55- 598,637.33- 58.702 1,032.45- 100.000 .67- 1,033.12- 1,033.12- 1,033.12- 1,033.12- 99 67 -1,033.12-1,033.12-1,033.12- 1,033.12- 104.88- 99 99.828 Page 22 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 534 2015 Revenue Bond I&S Account Description 534-70005-051-000 534-70040-051-000 534-70045-051-000 Subtotal: Program number: Department number: Expenditures Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Rev Bond Paying Agent Fee 400.00 400.00 200.00 400.00 100.000 Revenue Bona Interest Expense 208,238.00 208,238.00 104,118.75 208,237.50 100.000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 390,000.00 100.000 598,638.00 598,638.00 494,318.75 598,637.50 1 100.000 - 598,638.00 598,638.00 — 494,318.75 598,637.50 1 100.000 - 598,638.00 598,638.00 494,318.75 598,637. 100.000 Subtotal 111 598,638.00 598,638.00 494,318.75 598,637. 100.000 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 439,839.38 1,467. 58.695 Administration 1 .50 .50 Page 23 .50 .50 1,032. glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 57 Check Source Number Department Totals: (54,479.37) Monthly Total (600,104.88) ** (601,138.00) Budgeted (1,033.12) Remaining 100 % Used Account: 534-49011-000-000 Interest Income 1751 08/31/2020 Bank Interest- August (1,409.81) (57.74) (1,467.55) GL Account: 534-49011-000-000 Interest Income Totals: (57.74) (1,467.55) ** (2,500.00) Budgeted (1,032.45) Remaining 59 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1664 08/20/2020 TexPool Transfers August TexPool O&M to Rev Bd WWTP I&S (544,215.70) (54,421.63) (598,637.33) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (598,637.33) ** (598,638.00) Budgeted (.67) Remaining 100 % Used Department Totals: (54,479.37) Monthly Total (600,104.88) ** (601,138.00) Budgeted (1,033.12) Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I8S Department: 51 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCoy�t: 534-70005-0 - Rev Bond Paying Agent Fee 1701 08/25/2020 9/1/20 Bond Payments Ac Account: 534-70040-051-000 1701 08/25/2020 9/1/20 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS HOKF Rev Bond WWTP 1TROP215WSS Rev Bond Paying Agent 400.00 Budgeted Revenue Bond Interest Expense .00 Remaining Account: 534-70045-051-000 Revenue Bond Principal Expense 1701 08/25/2020 9/1/20 Bond Payments HOKF Rev Bond WWTP 1TROP215WSS -70045-051- Revenue Bond Principal Expense Totals: Department 51 Totals: Fund 534 Totals: 200.00 200.00 400.00 GL 100 Ueed 104,118.75 104,118.75 208,237.50 GL 390,000.00 390,000.00 GL 598,637.50 ** 598,638.00 Budgeted .50 Remaining 100 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted .50 Remaining 390,000.00 Budgeted .00 Remaining 494,318.75 Monthly Total 439,839.38 Monthly Total 100 % Used 100 % Used (1,467.38) (2,500.00) Budgeted (1,032.62) Remaining 59 s Used TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 5,624 TOTAL ASSETS 5,624 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 4,967 NET REVENUES / EXPENDITURES 657 TOTAL FUND BALANCE 5,624 TOTAL LIABILITIES AND FUND BALANCE 5,624 glbase tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 Interest Income 1,000.00- 1,000.00- 27.71- 657.50- 65.750 342.50- 535-49142-000-000 Interfund Tran In -Water Sales 275,525.00- 275,525.00- 25,047.72- 275,524.92- 100.000 .08 - Sub tot 08-Subtot 25.00- RP7S.43- 276,182.42- =13 -.1376 -342.58 - Program number: 0- 276125.00- * 25,075.43- 276,182.42- 111199.876 342.58 - Department number: Revenues 0- 276,525.00- , 25,075.43- 276,182.42- i 342.58 - Revenues Subtotal 276,525.00- 276,525.00- , 25,075.43- 276,182.42- 342.58 - Page 24 glbase_tbam skrolczyk 11:57 09/16/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account Description 535-70005-051-000 535-70040-051-000 535-70045-051-000 Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 8/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Rev Bond Paying Agent Fee 800.00 800.00 Revenue Bona Interest Expense 386,811.00 386,811.00 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: Program number: Department number: Administration Expenditures 1 Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 02,611.00 602,611.00 ilimb02,611.00 602,611.00 mEr 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 326,086.00 200.00 30,062.50 215,000.00 245,262.50 245,262.50 245,262.50 245,262.50 220,187.07 400.00 50.000 400.00 60,125.00 15.544 326,686.00 215,000.00 100.000 274 45.722 327,086.00 275, 45.722 327,086.00 275, 45.722 327,086.00 45.722 327,086.00 fa- -.202 326,743.42 Page 25 glpdatb2 skrolczyk 11:58 09/16/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: 8/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 59 Check Source Number Department Totals: (25,075.43) Monthly Total (276,182.42) ** (276,525.00) Budgeted (342.58) Remaining 100 % Used Account: 535-49011-000-000 Interest Income 1751 08/31/2020 Bank Interest- August (629.79) (27.71) (657.50) GL Account: 535-49011-000-000 Interest Income Totals: (27.71) (657.50) ** (1,000.00) Budgeted (342.50) Remaining 66 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1664 08/20/2020 TexPool Transfers August TexPool O&M to 16Swift Rev I&S (250,477.20) (25,047.72) (275,524.92) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: Mr (25,047.72) (275,524.92) ** (275,525.00) Budgeted (.08) Remaining 100 % Used Department Totals: (25,075.43) Monthly Total (276,182.42) ** (276,525.00) Budgeted (342.58) Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 60 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accost: 535-70005-0 - Rev Bond Paying Agent Fee 1701 08/25/2020 9/1/20 Bond Payments BOKF SWIFT 1TROP1116WSS Ac Rev Bond Paying Agent 800.00 Budgeted 200.00 200.00 400.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 1701 08/25/2020 9/1/20 Bond Payments BOKF SWIFT 1TROP1116WSS Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 326,686.00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense 1701 08/25/2020 9/1/20 Bond Payments BOKF SWIFT 1TROP1116WSS Accomill Revenue Bond Principal Expense Totals: 215,000.00 Budgeted .00 Remaining Department 51 Totals: Fund 535 Totals: 30,062.50 30,062.50 16 % Used 100 % Used 400.00 GL 60,125.00 GL 215,000.00 215,000.00 GL 275,525.00 ** 245,262.50 Monthly Total 602,611.00 Budgeted 327,086.00 Remaining 46 % Used 220,187.07 Monthly Total 326,086.00 Budgeted (657.42) 326,743.42 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET AUGUST 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND ASSETS SERIES 2019 I&S LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 531 TOTAL FUND BALANCE 531 531 531 TOTAL LIABILITIES AND FUND BALANCE 531 glbase tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 26 1 536-49011-000-000 Interest Income 10.67- 473.37- 473.37 I 1 536-49142-000-000 Interfund Tran In -Water Sales 22,896.02- 251,856.22- 251,856.22 I 1 536-49143-000-000 Interfund Transfer In -WW Sales 6,839.07- 75,229.77- 75,229.77 I Subtotal: T 'ice, ,45.76- 3277115-8.36- 327,559.36 Program number: 29,745.76- 327,559.36- 327,559.36 Department number: Revenues 29,745.76- 327,559.36- 327,559.36 I Revenues Subtotal ME 29,745.76- 327,559.36- 327,559.36 glbase_tbam skrolczyk Trophy Club MUD No.1 11:57 09/16/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 8/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 27 536-70005-051-000 Rev Bond Paying Agent Fee 200.00 342.08 342.08- I 536-70040-051-000 Revenue Bond Interest Expense 111,793.75 326,686.18 326,686.18- I Subtot 111,993.75 327,028.26 11111 327, Program number: 111,993.75 327,028.26 327,028.26 - Department number: Administration 111,993.75 327,028.26 327,028.26 - Expenditures Subtotal 111,993.75 327,028.26 327,028.26 - Fund number: 536 2019 Rev Bond I&S- W&WW System 82,247.99 531.10- 531.10 ******* End of Report ********* glpdatb2 skrolczyk Trophy Club MUD No.l Page 61 11:58 09/16/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: Revenues Program: Period Ending: 8/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Interest Income 1751 08/31/2020 Bank Interest- August Ac Interest Income .00 Budgeted (462.70) (10.67) 473.37 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 1664 08/20/2020 TexPool Transfers August TexPool O&M to I&S- W&WW SYS (228,960.20) (473.37) GL (22,896.02) (251,856.22) GL Interfund Tran In -Water Sales Totals: .00 Budgeted 251,856.22 Remaining (22,896.02) Interfund Transfer In -WW Sales 1664 08/20/2020 TexPool Transfers August TexPool O&M to I&S- W&WW SYS 0 % Used (68,390.70) (6,839.07) (75,229.77) GL Account: 536-49143- rfund Transfer In -WW Sales Totals: .00 Budgeted 75,229.77 Remaining 0 % Used Department Totals: (327,559.36) ** (29,745.76) Monthly Total .00 Budgeted 327,559.36 Remaining 0 % Used glpdatb2 skrolczyk 11:58 09/16/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Program: Period Ending: 8/2020 JE Detail Description/Comment Accoaiii70005-01161 Rev Bond Paying Agent Fe 1701 08/25/2020 9/1/20 Bond Payments Ac Page 62 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) BOKF REV BOND 1TROP419WSSR Rev Bond Paying Agent .00 Budgeted (342.08) Remaining Account: 536-70040-051-000 Revenue Bond Interest Expense 1701 08/25/2020 9/1/20 Bond Payments BOKF REV BOND 1TROP419WSSR 142.08 200.00 342.08 GL 0 % Ueed 214,892.43 111,793.75 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (326,686.18) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 % Used 326,686.18 GL 326,686.18 ** 327,028.26 ** 111,993.75 Monthly Total .00 Budgeted (327,028.26) Remaining 0 % Used 82,247.99 Monthly Total .00 Budgeted (531.10) 531.10 Remaining 0 % Used ******* End of Report ********* (1,278,939.33) **** 1,362,795.81 Monthly Total (251,995.00) Budgeted 1,026,944.33 Remaining 508 % Used