Loading...
HomeMy WebLinkAbout2020-07 Combined Financials July 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET JULY 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 756,590 PREPAID EXPENSES 3,282 ADVALOREM PROPERTY TAXES RECEIVABLE 19,492 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 779,364 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 19,499 TOTAL LIABILITIES 19,499 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,768 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 156,097 TOTAL FUND BALANCE 759,865 TOTAL LIABILITIES AND FUND BALANCE 779,364 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 6,625.44- 1,223,142.72- 196.74- 3,062.84- 891.49- 6,183.37- 100.734 8,912.72 3,062.84 6,183.37 Page 1 Subtotal: 1,214,230.00- 1,214,230.00- 7,713.67- 1,232,388.93- 101.496 18,158.93 Program number: 1,214,230.00- 1,214,230.00- 7,713.67- 1,232,388.93- 101.496 18,158.93 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 7,713.67- 1,232,388.93- 101.496 18,158.93 Revenues Subtotal 1,214,230.00- 1,214,230.00- 7,713.67- 1,232,388.93- 101.496 18,158.93 glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 122-60055-045-000 122-60337-045-000 11111Wtotal: 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 34,429.00 71.727 13,571.00 122-69009-045-000 Short Term Debt -Interest 9,078.48 9,078.48- 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 118,070.12 92.860 9,078.88 Rent And/Or Usage 218,004.00 218,004.00 218,004.00 100.000 Insurance 21,000.00 21,000.00 1,640.88 16,408.80 78.137 4,591.20 Transfer to Town/Fire Budget 718,657.00 718,657.00 59,888.08 598,880.80 83.333 119,776.20 957,661.00 957,661.00 61,528.96 833,293.60 124,367.40 Subtota1: 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire 1,214,230.00 1,214,230.00 Expenditures Subtotal 1,214,230.00 1,214,230.00 Fund number: 122 Trophy Club MUD Fire Dept. 61,528.9 61,528.96 61,528.96 53,815.29 Page 2 glpdatb2 skrolczyk 12:00 08/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-020- 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1583 07/09/2020 Property Taxes 1607 07/13/2020 Property Taxes 1584 07/15/2020 Property Taxes 1585 07/16/2020 Property Taxes 1586 07/17/2020 Property Taxes 1587 07/20/2020 Property Taxes 1588 07/21/2020 Property Taxes 1589 07/22/2020 Property Taxes 1590 07/23/2020 Property Taxes 1591 07/24/2020 Property Taxes 1596 07/27/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes 1602 07/30/2020 Property Taxes 1603 07/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 7/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page Check Source Number Property Taxes/MUD Fire (1,216,517.28) (594.98) (1,217,112.26) (67.32) (1,217,179.58) (226.13) (1,217,405.71) (1,526.44) (1,218,932.15) 915.80 (1,218,016.35) (44.45) (1,218,060.80) (45.24) (1,218,106.04) (101.22) (1,218,207.26) (545.61) (1,218,752.87) (2,815.06) (1,221,567.93) (416.83) (1,221,984.76) (360.23) (1,222,344.99) (92.11) (1,222,437.10) (538.40) (1,222,975.50) (279.23) (1,223,254.73) 1,326.24 (1,221,928.49) (384.69) (1,222,313.18) (151.64) (1,222,464.82) (677.90) (1,223,142.72) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000—W Property Taxes/MUD Fire Totals: (1,214,230.00) Budgeted 8,912.72 Remaining 101 % Used Property Taxes/Fire-Delinquent 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1589 07/22/2020 Property Taxes 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes Account: -171-41111 Property Taxes/Fire-Delinquent Totals: .00 Budgeted 3,062.84 Remaining Account: 122-40020-000-00 perty Taxes/Fire P&1 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1587 07/20/2020 Property Taxes 1589 07/22/2020 Property Taxes (2,866.10) (5,291.88) 0 % Used (17.89) (2,883.99) (17.38) (2,901.37) (139.59) (3,040.96) (9.64) (3,050.60) (12.24) (3,062.84) (69.10) (5,360.98) (4.33) (5,365.31) (9.56) (5,374.87) (228.95) (5,603.82) (472.91) (6,076.73) (64.72) (6,141.45) GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes Account: 122-4002 Department Totals: Property Taxes/Fire P41 Totals: .00 Budgeted 6,183.37 Remaining (7,713.67) Monthly Total (5,291.88) 0 % Used (2.75) (10.33) (28.84) (6,144.20) (6,154.53) (6,183.37) (1,232,388.93) ** (1,214,230.00) Budgeted 18,158.93 Remaining 101 % Used GL GL GL glpdatb2 skrolczyk 12:00 08/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Period Ending: 7/2020 Program: JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 3 Check Source Number Account: 122-60030-045-000 Rent And/Or Usage 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 75 07/01/2020 Insurance/Wrk Comp Expense Jul 14,767.92 1,640.88 16,408.80 GL Account: 122-60055-045-000 Insurance Totals: 1,640.88 16,408.80 ** 21,000.00 Budgeted 4,591.20 Remaining 78 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1421 07/06/2020 July A/P Fire admin -July 538,992.72 59,888.08 598,880.80 TOWN OF TROPHY CLUB 6601 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 598,880.80 ** 718,657.00 Budgeted 119,776.20 Remaining 83 % Used Account: 122-69005-045-000 Capital Outlays 34,429.00 .00 34,429.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 34,429.00 ** 48,000.00 Budgeted 13,571.00 Remaining 72 % Used Account: 122-69009-045-000 Short Term Debt -Interest 9,078.48 .00 9,078.48 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 9,078.48 ** .00 Budgeted (9,078.48) Remaining 0 5 Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Capital Leases Totals: 127,149.00 Budgeted 118,070.12 .00 118,070.12 9,078.88 Remaining 93 % Used Department 45 Totals: 1,076,291.20 ++ 61,528.96 Monthly Total 1,214,230.00 Budgeted 137,938.80 Remaining 89 % Used Fund 122 Totals: (156,097.73) 53,815.29 Monthly Total .00 Budgeted 156,097.73 Remaining 0 5 Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JULY 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,548,204 3,548,204 CASH IN BANK -SAVINGS -CASH RESERVE 1,607,167 1,607,167 INVESTMENTS-TEXPOOL 3,341,716 919,266 4,260,982 PREPAID EXPENSES 21,460 21,460 ADVALOREM PROPERTY TAXES RECEIVABLE 2,067 2,067 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,386,217 1,386,217 TOTAL ASSETS 9,907,431 919,266 10,826,697 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,067 2,067 ACCOUNTS AND OTHER PAYABLES 288,311 288,311 CUSTOMER DEPOSITS 313,265 313,265 TOTAL LIABILITIES 603,643 603,643 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 902,404 902,404 TOTAL FUND BALANCE 9,303,788 919,266 10,223,054 TOTAL LIABILITIES AND FUND BALANCE 9,907,431 919,266 10,826,697 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 12:00 08/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 Subtotal: 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- 735.49- 23.80- 99.61- 135,783.71- 320.65- 678.53- 100.677 106.883 226.177 912.71 20.65 378.53 164,253.00- 299,724.00- 299,724.00- 858.90- 136,782.89- 45.636 = 162,941.11- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 779,303.41- 4,347,465.57- 67.022 2,139,157.43- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 289,812.89- 2,626,333.70- 74.955 877,551.30- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 51,074.93- 45.356 61,533.07- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 9,900.00- 65.347 5,250.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 4,500.00- 600.000 3,750.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 2,100.00- 84.000 400.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 22,024.80- 63,837.60- 127.675 13,837.60 Subtotal: 10,171,516.00- 10,171,516.00- 1,091,141.10- 7,105,211.80- 69.854 3,066,304.20- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 3,720.29- 1,178.81- 583.33- 144.04- 74,526.15- 10,609.29- 5,833.30- 8,925.00- 13,025.28- 20,509.04- 62.105 74.999 83.333 68.654 102.634 292.986 45,473.85- 3,536.71- 1,166.70- 4,075.00- 334.28 5,473.85 -3,536.71-1,166.70- 4,075.00- 334.28 13,509.04 Subtotal: 173,837.00- 173,837.00- 5,626.47- 133,428.06- 76.755 40,408.94- Program number: 10,645,077.00- 10,645,077.00- 1,097,626.47- 7,375,422.75- 69.285 3,269,654.25 - Department number: Revenues 10,645,077.00- 10,645,077.00- 1,097,626.47- 7,375,422.75- 69.285 3,269,654.25 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 1,097,626.47- 7,375,422.75- 69.285 3,269,654.25- glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 23,589.75 135-50010-010-000 Overtime 17,000.00 17,000.00 2,156.48 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 375.00 135-50020-010-000 Retirement 34,863.00 34,863.00 2,418.84 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 4,435.04 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 278.57 135-50028-010-000 Vision Insurance 767.00 767.00 41.20 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 465.13 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 1,603.67 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 375.04 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 771.49 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 FSubtotal: ' 546,839.00 546,839.00 0.21 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 2,393.35 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,550.93 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 300.00 289,816.77 16,823.81 5,082.50 4,150.00 30,321.48 49,713.82 3,026.57 470.03 3,328.97 19,366.89 4,529.33 880.68 7,890.40 71.00 66.82 82.742 98.964 129.656 76.852 86.973 58.954 64.054 61.282 106.289 82.949 82.940 81.544 66.586 17.750 22.273 60,450.23 176.19 1,162.50- 1,250.00 4,541.52 34,612.18 1,698.43 296.97 196.97- 3,981.11 931.67 199.32 3,959.60 329.00 233.18 Page 4 435,539.07 111,299.93 33,973.44 33.973 4,128.11 1,828.19 787.50 3,851.08 82.562 52.234 78.750 51.348 20,000.00 66,026.56 3,000.00 871.89 1,671.81 212.50 3,648.92 140,000.00 140,000.00 4,331.78 44, 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-010-000 Electricity 125,677.00 125,677.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 63,000.00 63,000.00 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 422.55 12,546.56 235,099.91 47,943.74 4,481.28 104,265.51 850.00 105.00 1,547.00 20,205.04 1,294,847.81 756.00 3,750.00 479,437.40 36,800.00 89.626 82.963 85.000 21.000 20.832 32.071 47.697 25.200 25.424 90.909 66.675 518.72 21,411.49 150.00 395.00 5,879.00 400.00 2,845.00 1,500.00 42,794.96 1,419,862.19 200.00 2,244.00 11,000.00 47,943.60 18,393.00 180,000.00 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 7/2020 Program: Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 296,012.76 1,947,6.- 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 891.93 854.96 1,486.00 7,881.19 2,917.33 16,075.24 52.541 56.211 80.376 61,079.08 87.256 36,900.00 42.414 7,118.81 2,272.67 3,924.76 1,200.00 1,000.00 8,920.92 50,100.00 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 Bond Related Expenses 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 69,931.80 419,800.45 30,512.00 1,840.00 75,000.00 102,077.11 .0C11.229.56 1,220.00 61.296 100.000 56.948 100.000 85.064 265,074.55 1,391.00 17,922.89 5,504,929.00 5,504,929.00 .55 1,220.00- 1, 21,912.45 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund Account Description 135-55135-010-001 Lab Analysis for PID Subtotal: Program number: 1 Lab Analysis for PU1111111111 Department number: Water Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Period Ending: 7/2020 Program: 1 Lab Analysis for PID Adopted Amended Total Current YTD 5 of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 80.00 1,161.64 80.00 58.082 1,161.64 58.082 80.00 1,161.64 58.082 5,506,929.00 5,506,929.00 410,099.44 3,184,178.19 57.821 838.36 838.36 838.36 2,322,750.81 Page 6 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 7/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 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 135-55081-020-000 Mainten & Revairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 33,191.15 331,298.17 74.988 110,500.83 1,886.71 18,768.00 56.873 14,232.00 6,872.50 85.532 1,162.50 625.00 6,325.00 70.278 2,675.00 3,306.09 35,166.65 77.237 10,364.35 6,949.58 70,069.55 66.823 34,788.45 392.75 4,057.47 69.752 1,759.53 62.80 648.31 68.387 299.69 574.63 3,912.85 86.952 587.15 2,123.02 21,264.11 69.732 9,229.89 496.51 4,973.04 69.729 2,158.96 1,008.00 80.000 252.00 1,110.20 11,277.50 73.359 4,095.50 281.00 70.250 119.00 46.08 15.360 253.92 Page 7 50,718.44 515,968.23 = 192,478.77 30,000.00 3,000.00 20.000 12,000.00 10,374.92 63,162.24 71.775 24,837.76 70.51 18,708.44 187.084 8,708.44- 10,000.00 170.78 1,203.20 30.080 2,796.80 16.50 2,173.37 27.167 5,826.63 1,066.21 35.540 1,933.79 87.50 787.50 52.500 712.50 2,205.96 69,976.24 69.976 30,023.76 1,749.15 29,711.22 74.278 10,288.78 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-020-000 Electricity 160,067.00 160,067.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 412.81 4,757.27 95.145 242.73 12,025.56 108,256.57 67.632 51,810.43 200.00 216.00 72.000 84.00 579.00 3,121.85 62.562 1,868.15 109.14 10.914 890.86 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 2,024.53 2,609.47 52.189 2,390.53 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 Subtotal: r 135-65005-020-000 Fuel & Lube 135-65010-020-000 Uniforms 135-65030-020-000 Chemicals 135-65031-020-000 Chemicals Collections 135-65035-020-000 Small Tools 135-65040-020-000 Safety Equipment 135-65045-020-000 Lab Supplies Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 10,414.81 61,260.70 3,854.74 104,148.10 612,606.40 46,000.00 27.534 90.909 90.909 36.745 190.00 9.500 10,145.26 10,414.90 61,260.60 79,187.00 180,000.00 1,810.00 Page 8 1,310,669.00 86,717.41 896,368.28 414,300.72 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 852.63 5,454.60 4,834.53 6,467.35 3,507.93 20,508.34 10,448.60 1,166.53 24,033.06 51.739 63.839 102.542 59.706 97.211 120.165 6,032.65 1,987.07 508.34- 7,051.40 1,200.00 33.47 4,033.06 - 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtota.- Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 4,020.40 310,085.86 58.452 220,414.14 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 4,020.40 167,273.33 167,273.33 505,812.63 , 67.360 245,097.37 2,174,069.37 68.856 983,351.63 2,174,069.37 68.856 983,351.63 glbase_tbam skrolczyk 12:00 08/10/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: 7/2020 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 1.99 Program: YTD Total 19.90 % of Budget 66.333 Remaining Budget 10.10 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 Board of Directors 150.00 150.00 750.00 750.00 1,300.00 1,300.00 4,000.00 4,000.00 5,000.00 5,000.00 2,000.00 2,000.00 13,200. 0 13,200.00 — 13,230.00 — 13,230.00 13,230.00 13,230.00 123.99 675.00 661.79 375.00 125.98 1,731.69 125.98 1,731.69 90.000 50.907 9.375 1111/W12.968 13.089 13.089 150.00 75.00 638.21 3,625.00 5,000.00 2,000.00 11,488.21 11,498.31 11,498.31 glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 42,352.54 341,529.16 54.358 286,768.84 135-50010-030-000 Overtime 2,000.00 2,000.00 41.79 2.090 1,958.21 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 58,554.00 3,921.87 33,330.58 56.923 25,223.42 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 7,993.04 64,158.49 51.577 60,235.51 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 441.96 3,551.87 54.948 2,912.13 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 65.60 535.91 51.779 499.09 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 630.01 3,632.76 80.728 867.24 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 2,428.64 19,887.86 50.715 19,327.14 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 567.98 4,651.21 50.716 4,519.79 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 104.82 1,048.20 59.054 726.80 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 3,078.10 38.476 4,921.90 Page 10 58,506.46 53.930 408,892.57 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanini7 Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 2,210.93 86,391.95 64.146 48,289.05 300.00 90,226.07 66.834 44,773.93 1,855.00 12.367 13,145.00 531.00 5.310 9,469.00 1,896.92 11,452.48 114.525 1,452.48- 57,100.00 87.043 8,500.00 5,253.58 58.373 3,746.42 55 126,470 135-60005-030-000 Telephone 135-60010-030-000 Communications/Mobiles 135-60020-030-000 Electricity/Gas 135-60025-030-000 Water 135-60035-030-000 Postage 135-60040-030-000 Service Charges & Fees 135-60050-030-000 Bad Debt Expense 135-60055-030-000 Insurance 135-60066-030-000 Publications/Books/Subscripts 135-60070-030-000 Dues & Memberships 135-60075-030-000 Meetings 135-60079-030-000 Public Education 135-60080-030-000 Schools & Training 135-60100-030-000 Travel & per diem 135-60110-030-000 Physicals/Testing 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 23,680.00 23,680.00 4,000.00 4,000.00 6,879.00 6,879.00 1,500.00 1,500.00 30,000.00 30,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 84,000.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 6,850.00 3,545.00 3,545.00 200.00 200.00 1,306.06 16,066.93 67.850 7,613.07 275.30 2,365.05 59.126 1,634.95 481.10 4,853.12 70.550 2,025.88 142.27- 1,221.58 81.439 278.42 335.37 15,057.62 50.192 14,942.38 5,917.50 58,736.57 87.667 8,263.43 1,500.00 6,998.39 66,422.04 79.074 17,577.96 125.00 12.500 875.00 143.00 4,428.55 73.809 1,571.45 115.09 28.773 284.91 4,047.85 67.464 1,952.15 35.00 2,421.21 35.346 4,428.79 10.57 1,167.98 32.947 2,377.02 200.00 138.04 138.04- 150.00 4,111.80 164.472 1,611.80 - glbase_tbam skrolczyk 12:00 08/10/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: 7/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 3,500.00 4,000.00 4,000.00 2,500.00 2,500.00 195,000.00 195,000.00 4,000.00 4,000.00 ,000.00 712.00 712.00 Current Month 24.00 2,026.99 2,345.50 580.14 246.48 13,439.76 338.43 Program: YTD Total 216.00 2,026.99 6,331.70 4,518.59 3,598.16 14,448.45 41,887.60 2,416.03 % of Budget 44,303.63 - 973,745 973,745.E 16.770 81.080 68.9 23.907 75.310 89.954 Remaining Budget 1,072.00 500.00 17,000.00 473.01 2,050.00 20,153.30 1,481.41 3,500.00 401.84 2,500.00 21.481 153,112.40 60.401 1,583.97 802,966.99 802,966.99 54.806 54.806 Page 11 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 7/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 2,957.50 98,160.39 27,713.27 9,665.52 3,756.00 72.711 81.992 82.183 93.900 36,839.61 6,086.73 2,095.48 244.00 Page 12 ir Subtotal: ' 184,561.00 184,561.00 2,957.50 139,295.18 75.474 45,265.82 Program number: 184,561.00 184,561.00 2,957.50 139,295.18 75.474 45,265.82 Department number: Non Departmental 184,561.00 184,561.00 2,957.50 139,295.18 75.474 45,265.82 Expenditures Subtotal 10,638,853.00 10,638,853.00 677,881.88 6,473,019.44 60.843 4,165,833.56 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 419,744.59- 902,403.31- ############### 896,179.31 glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000- 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1583 07/09/2020 Property Taxes 1607 07/13/2020 Property Taxes 1584 07/15/2020 Property Taxes 1585 07/16/2020 Property Taxes 1586 07/17/2020 Property Taxes 1587 07/20/2020 Property Taxes 1588 07/21/2020 Property Taxes 1589 07/22/2020 Property Taxes 1590 07/23/2020 Property Taxes 1591 07/24/2020 Property Taxes 1596 07/27/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes 1602 07/30/2020 Property Taxes 1603 07/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes (135,048.22) (66.05) (135,114.27) (7.47) (135,121.74) (25.10) (135,146.84) (169.45) (135,316.29) 101.66 (135,214.63) (4.94) (135,219.57) (5.02) (135,224.59) (11.24) (135,235.83) (60.57) (135,296.40) (312.51) (135,608.91) (46.27) (135,655.18) (39.99) (135,695.17) (10.22) (135,705.39) (59.77) (135,765.16) (31.00) (135,796.16) 147.23 (135,648.93) (42.70) (135,691.63) (16.83) (135,708.46) (75.25) (135,783.71) Page 5 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000-W Property Taxes Totals: (134,871.00) Budgeted 912.71 Remaining 101 % Used Account: 135-40002-000-000- 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1589 07/22/2020 Property Taxes 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes Property Taxes/Delinquent (296.85) (3.44) (1.98) (15.89) (1.10) (1.39) (300.29) (302.27) (318.16) (319.26) (320.65) GL GL GL GL GL Account: ,191 - - - Property Taxes/Delinquent Totals: Account: 135-40015-000-009 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1587 07/20/2020 Property Taxes 1589 07/22/2020 Property Taxes (300.00) Budgeted 20.65 Remaining 107 % Ueed Property Taxee/P 5 I (578.92) (8.19) (587.11) (.50) (587.61) (1.06) (588.67) (25.42) (614.09) (52.49) (666.58) (7.27) (673.85) GL GL GL GL GL GL glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes Account: 135-40015-00 Account: 135-40025-000-000 Account: 135-40025-000-000 Account: 135-47000-000- 1554 07/31/2020 UB Account: 135-47005-000-00 1401 07/01/2020 UB 1412 07/06/2020 UB 1416 07/06/2020 UB 1445 07/08/2020 UB 1508 07/17/2020 UB 1554 07/31/2020 UB :05-000- Account: 135-47025-000-000 Account: 135-47025-000-000 Account: 135-47030-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment Property Taxes/P & I Totals: (300.00) Budgeted 378.53 Remaining PID Surcharges PID Surcharges (164,253.00) Budgeted (164,253.00) Remaining 07/31/2020 Billing (6,486,623.00) 07/01/2020 WA Adjustment 07/06/2020 WA Adjustment 07/06/2020 WA Adjustment 07/08/2020 WA Adjustment 07/17/2020 WA Adjustment 07/31/2020 Billing UB20200731-20200731 Budgeted User: (2,139,157.43) UB20200701-20200701 User: UB20200706-20200706 User: UB20200706-20200706 User: UB20200708-20200708 User: UB20200717-20200717 User: UB20200731-20200731 User: (578.92) 226 % Used (3,568,162.16) Remaining 0 % Used 67 % Used (2,336,520.81) tals: (3,503,885.00) Budgeted (877,551.30) Remaining Penalties Penalties Program: Transaction Detail .00 (779,303.41) Transaction Vendor Name Detail (SUBTOTAL) (674.16) (675.32) (678.53) .00 (4,347,465.57) 70.50 (2,336,450.31) 87.75 (2,336,362.56) 123.09 (2,336,239.47) 172.33 (2,336,067.14) 199.75 (2,335,867.39) (290,466.31) (2,626,333.70) 75 % Used (51,074.93) (112,608.00) Budgeted (61,533.07) Remaining .00 45 % Used (9,900.00) (51,074.93) .00 (9,900.00) Page Check Source Number GL GL GL UB UB UB UB UB UB UB glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 7 Check Source Number Account: 135-47030-000-000 Service Charges Totals: .00 (9,900.00) ** (15,150.00) Budgeted (5,250.00) Remaining 65 % Used Account: 135-47035-000-000 Plumbing Inspections (4,500.00) .00 (4,500.00) Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (4,500.00) ** (750.00) Budgeted 3,750.00 Remaining 600 % Used Account: 135-47045-000-000 Sewer Inspections (2,100.00) .00 (2,100.00) Account: 135-47045-000-000 Sewer Inspections Totals: .00 (2,100.00) ** (2,500.00) Budgeted (400.00) Remaining 84 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1554 07/31/2020 UR 07/31/2020 Billing UB20200731-20200731 User: (41,812.80) (22,024.80) (63,837.60) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: ilk (22,024.80) (63,837.60) ** (50,000.00) Budgeted 13,837.60 Remaining 128 % Used Account: 135-49011-000-000 1592 07/31/2020 Bank 1592 07/31/2020 Bank 1592 07/31/2020 Bank Interest- Interest- Interest- July July July (70,805.86) (1,646.92) (1,156.24) (917.13) (72,452.78) (73,609.02) (74,526.15) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (3,720.29) (74,526.15) ** (120,000.00) Budgeted (45,473.85) Remaining 62 % Used Account: 135-49016-000-000 illip Cell Tower Revenue 1593 07/24/2020 Cell Tower Rev AT&T (9,430.48) (1,178.81) (10,609.29) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (10,609.29) ** (14,146.00) Budgeted (3,536.71) Remaining 75 % Used Account: 135-49018-000-000 Building Rent Income ■ glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1606 07/31/2020 Town Billed Invoices 1746-1749 AR 20200731-20200731 User: (5,249.97) Account: 135-49018-000-000 Account: 135-49026-000-000 Account: 135-49026-000-000 Account: 135-49075-000-000 Building Rent Income Totals: (7,000.00) Budgeted (583.33) (5,833.30) (1,166.70) Remaining 83 % Used Proceeds from Sale of Assets Proceeds from Sale of Assets Tot= (13,000.00) Budgeted (4,075.00) Remaining 1 Oversize Meter Reimburseme Oversize Meter Reimburseme (12,691.00) Budgeted 334.28 Account: 135-49900-000-000 Miscellaneous Inc.. 1554 07/31/2020 UB 07/31/2020 Billing UB20200731-20200731 User: Account Department Totals: Miscellaneous Income (7,000.00) Budgeted (8,925.00) 69 (13,025.28) Remaining Used 103 % Used (20,365.00) 13,509.04 Remaining 293 % Used (583.33) .00 .00 (144.04) (5,833.30) (8,925.00) (13,025.28) (20,509.04) (7,375,422.75) ** (1,097,626.47) Monthly Total (10,645,077.00) Budgeted (3,269,654.25) Remaining 69 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1.0- Salaries & W 1423 07/10/2020 MUD Payroll 7/10/2020 Salaries & Wages 266,227.02 1525 07/24/2020 MUD Payroll 7/24/2020 Salaries & Wages Account: - Salaries & Wagesl 350,267.00 Budgeted Account: 135-50010-010-000vertime 1423 07/10/2020 MUD Payroll 7/10/2020 Overtime 1525 07/24/2020 MUD Payroll 7/24/2020 Overtime Account: 135-50010-010-000 Totals: 60,450.23 Remaining 83 % Used 14,667.33 176.19 Remaining 99 % Used 5,082.50 17,000.00 Budgeted Account: 135-50016-010 Longevit Account: 13511.11.Longevity 3,920.00 Budgeted 11,794.76 278,021.78 PR 11,794.99 289,816.77 PR 619.28 15,286.61 PR 1,537.20 16,823.81 PR .00 5,082.50 Totals: (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 1525 07/24/2020 MUD Payroll 7/24/2020 Certification 3,775.00 375.00 4,150.00 PR Account: 135- Certification 5,400.00 Budgeted Account: 135-50020-010-000 Retiremenn 1423 07/10/2020 MUD Payroll 7/10/2020 Retirement 1525 07/24/2020 MUD Payroll 7/24/2020 Retirement Account: 135-50020-010-000 Retirement 34,863.00 Budgeted 1,250.00 Remaining 77 % Used 27,902.64 1,149.55 29,052.19 PR 1,269.29 30,321.48 PR Totals: 0,321.48 ** 4,541.52 Remaining 87 % Used ical Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Medical Insurance 1485 07/13/2020 F720 Health Ins Fee 2019 Form 720- Self-insured Health 1525 07/24/2020 MUD Payroll 7/24/2020 Medical Insurance 45,278.78 2,206.11 47,484.89 PR 22.87 47,507.76 UNITED STATES TREASURY 6631 AP 2,206.06 49,713.82 PR glpdatb2 akrolczyk Trophy Club MUD No.1 Page 10 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-010-000 Medical Insurance Totals: 4,435.04 49,713.82 ** 84,326.00 Budgeted 34,612.18 Remaining 59 5 Used Account: 135-50027-010-000 Dental Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Dental Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Dental Insurance 2,748.00 139.29 2,887.29 PR 139.28 3,026.57 PR Account: 135-50027-010-000 Dental Insurance Totals: 278.57 3,026.57 ** 4,725.00 Budgeted 1,698.43 Remaining 64 % Used Account: 135-50028-010-000 Vision Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Vision Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Vision Insurance 428.83 20.61 449.44 PR 20.59 470.03 PR Account: 135-50028-010-000 Vision Insurance Totals: 41.20 470.03 ** 767.00 Budgeted 296.97 Remaining 61 5 Used Account: 135-50029-010-000 Life Insurance & Other 1331 07/01/2020 Payroll Benefits July 1377 07/01/2020 July Ap 1533 07/24/2020 July Payroll Benefits 1553 07/31/2020 July A/P Employee Benefits Employee LTD & STD Employee LTD & STD cafe 125 plan 2,863.84 176.88 3,040.72 Humana Inc 6547 AP 151.42 3,192.14 METLIFE GROUP BENEFITS 6562 AP 116.83 3,308.97 METLIFE GROUP BENEFITS 6670 AP 20.00 3,328.97 BenefitMall 6654 AP Account: 135-50029-010-000 ' Life Insurance & Other Totals: -3 3,328.97 ** 3,132.00 Budgeted (196.97) Remaining 106 % Used Account: 135-50030-010-000 Social Security Taxes 1423 07/10/2020 MUD Payroll 7/10/2020 Social Security Taxes 17,763.22 1525 07/24/2020 MUD Payroll 7/24/2020 Social Security Taxes 758.39 18,521.61 PR 845.28 19,366.89 PR Account: 135-50030-010-000 Social Security Taxes JIIIIIL Totals: 1,603.67 19,366.89 ** 23,348.00 Budgeted 3,981.11 Remaining 83 5 Used Account: 135-50035-010-000 Medicare Taxes 1423 07/10/2020 MUD Payroll 7/10/2020 1525 07/24/2020 MUD Payroll 7/24/2020 Medicare Taxes Medicare Taxes 4,154.29 177.35 4,331.64 PR 197.69 4,529.33 PR glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-50035-01t Account: 135-50040-010-000 Account: 135-50040-010-000 Account Department: 10 Water JE Detail Description/Comment Medicare Taxes 5,461.00 Budgeted Unemployment Taxes Unemployment Taxes 1,080.00 Budgeted Workman's Compensation 75 07/01/2020 Insurance/Wrk Comp Expense Jul Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 11 Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 931.67 Remaining 880.68 83 Used Totals: 199.32 Remaining 82 5 Used .00 880.68 7,118.91 771.49 Account: 135-50045-010-00 Workman's Compensation Totals: 11,850.00 Budgeted 3,959.60 Remaining 67 % Used Account: 135-50060-010-000 Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 Account: 135-55005-010-000 Account: 135-55005-010-000 Account: 135-55080-010-000 i 1489 07/14/2020 July A/P 1489 07/14/2020 July A/P Pre-emp Physicals/Testing Pre-emp Physicals/Testing 400.00 Budgeted Employee Relations Employee Relations 300.00 Budgeted Engineering ' Engineeri 20,000.00 Budgeted Maintenance & Repairs Pump #3 wiring Pump #1 Repair 71.00 329.00 Remaining 18 5 Used 66.82 233.18 Remaining 22 5 Used 20,000.00 Remaining 31,580.09 0 5 Used 7,890.40 GL .00 71.00 .00 66.82 .00 .00 490.00 32,070.09 DHS AUTOMATION, INC 866.15 32,936.24 DHS AUTOMATION, INC 6613 AP 6613 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1489 07/14/2020 July A/P 1503 07/16/2020 July A/P 1526 07/22/2020 July A/P Account: 135-55080-01 Account: 135-55085-010-000 Water plant gate Repair parts Fire extinguisher testing Maintenance & Repairs Totals: 100,000.00 Budgeted 66,026.56 Remaining aii Generator Maint. and Repair Account: 135-55085-010-000 = Generator Maint. and Repai 3,000.00 Budgeted 31,580.09 120.00 33,056.24 Alan's Gates, Inc. 6608 AP 463.20 33,519.44 Core & Main LP 6611 AP 454.00 33,973.44 All Test Service Solutions LLC 6633 AP 34 % Used 3,000.00 Remaining 0 % Used Account: 135-55090-0 ce 1421 07/06/2020 July A/P oil change 1545 07/27/2020 PCards 6/27/2020-7/27/2020 air condintioner repair 1545 07/27/2020 PCards 6/27/2020-7/27/2020 air filters Account: 135-55090-010-000 Vehicle Maintenance 5,000.00 Budgeted .00 .00 2,577.18 72.17 2,649.35 TWO WILSONS INDUSTRIES, INC 6603 AP 1,365.58 4,014.93 GRAPEVINE DODGE CHRYSL PC 113.18 4,128.11 ROANOKE AUTO SUPPLY LT PC 871.89 Remaining 83 % Used 4,128.11 ** Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader ACCti Account: 135-55120-01 1553 07/31/2020 July A/P 1,828.19 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 1,671.81 Remaining Cleaning Services _ Janitorial service -June 700.00 52 % Used .00 1,828.19 87.50 787.50 MEMBER'S BUILDING MAINTENANCE 6663 AP Account: 135-55120-010-000 Cleaning Services Totals: Account: 135-55135-010-000 1502 07/16/2020 July A/P 1,000.00 Budgeted Lab Analysis water samples Account: 135-55135-010-000 Lab Analy 7,500.00 Budgeted 212.50 Remaining 79 % Used 3,648.92 Remaining 3,551.08 300.00 3,851.08 TARRANT CTY PUBLIC HEALTH LAB 6626 AP 51 Used glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60010-010-t 1489 07/14/2020 July A/P Account: 135-600 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 7/2020 JE Detail Description/Comment Communications/Mobiles cell phones Page 13 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ■ 4,058.73 422.55 4,481.28 VERIZON WIRELESS 6632 AP Communications/Mobiles Total■ 5,000.00 Budgeted 518.72 Remaining 90 % Used Account: 135-60020-010-000 Electric' 1504 07/16/2020 July A/P Electricity 6/9-7/10 Account: Electrici' 125,677.00 Budgeted Publications/Books/Subscr 91,718.95 12,546.56 21,411.49 Remaining 83 % Ueed ipts 850.00 105.00 395.00 Remaining 21 % Used Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 150.00 Remaining Account: 135-60070-010-000 Dues & Memberships Account: 135-60070-010-000 Dues & Memberships 500.00 Budgeted Account: 135-60080-010-000 Account: 135-60080-010-000 Schools & Tr - 7,426.00 Budgeted 85 % Used 5,879.00 Remaining 1,547.00 21 Used 104,265.51 HUDSON ENERGY SERVICES, LLC 6618 AP 51 ** .00 850.00 .00 105.00 .00 1,547.00 Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem glpdatb2 ekrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 Account: 135-60135-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 7/2020 JE Detail Description/Comment Travel & per diem Totals: 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted TCEQ Fee 63,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 1526 07/22/2020 July A/P Account Account: 135-60245-010-000 Account: 135-60280-010-000 Page 14 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) .00 .00 2,845.00 Remaining 0 % Used 1,500.00 Remaining 20,205.04 0 % Used 42,794.96 Remaining 32 % Used wholesale water 1,059,747.90 Wholesale Water 2,714,710.00 Budgeted Miscellaneous Expenses 1,419,862.19 Remaining 48 % Used Miscellaneous Expenses Totals: 200.00 Budgeted Property Maintenance Account: 135-60280-010-000 Property Maintenance 3,000.00 Budgeted Account: 135-60285-010-000 .00 .00 .00 20,205.04 20,205.04 ** 235,099.91 1,294,847.81 CITY OF FORT WORTH 1,294,847.81 ** .00 .00 200.00 Remaining 0 % Ueed 756.00 .00 756.00 2,244.00 Remaining 25 % Used 3,750.00 .00 3,750.00 6636 AP glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund Account: JE JE JE Number Date Description Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 11,000.00 Remaining Interfund Transfer Out -Rev 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- W&WW SYS 1552 07/31/2020 TexPool Transfers July TexPool O&M to 16Swift Rev I&S Account: 135M5332-01011 431,493.66 25 % Used 22,896.02 454,389.68 25,047.72 479,437.40 Interfund Transfer Out -Rev 47,943.74 527,381.00 Budgeted 47,943.60 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve Account: 135-60333-010-000 r Out -Reserve Tota 55,193.00 Budgeted 18,393.00 Remaining Account: 135-60334-010-000 Account: 135-60334-010-000 Interfund Transfer Out Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Account: 135-65005-010-000 1541 07/24/2020 Fuel Account: 135-65005-010-000 Account: 135-65010-010-000 36,800.00 91 % Used .00 36,800.00 67 % Used 0 % Ueed .00 .00 .00 561.72 .00 561.72 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 1,938.28 Remaining 22 % Used GL GL 1 & L Fuel 6,989.26 891.93 7,881.19 US Bank Voyager Fleet Systeme 6669 AP 15,000.00 Budgeted 7,118.81 Remaining 53 % Used 2,917.33 .00 2,917.33 glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 16 Account: 135-65010-01t Accal Account: Account: Uniforms Totai 5,190.00 Budgeted 2,272.67 Remaining Chemicals 11 1503 07/16/2020 July A/P testing supplies Account: 135-65035-01u Account: 135-65040-010-000 Chemicals 20,000.00 Budgeted Small Tools 56 % Used 15,220.28 854.96 Totals: 3,924.76 Remaining 80 % Used Small Tools Totals: 1,200.00 Budgeted Safety Equipment Account: 135-65040-010-00 Safety Equipment 1,000.00 Budgeted Account: 135-65050-010-P 1553 07/31/2020 July A/P Ac Account: 135-65053-010-000 Meter Expense meters Meter Expense 70,000.00 Budgeted Meter Change Out Program Meter Ch 87,000.00 Budgeted Account: 135-69005-010-000 Capital Outlays 1526 07/22/2020 July A/P Meadowbrook Lane 1,200.00 Remaining 1,000.00 Remaining 59,593.08 8,920.92 Remaining 50,100.00 36,900.00 Remaining 0 % Used 0 % Used 87 % Used 42 Used .00 .00 1,486.00 .00 349,868.65 69,931.80 2,917.33 ** 16,075.24 HACH COMPANY 6615 AP 16,075.24 ** .00 .00 ++ .00 61,079.08 ATLAS UTILITY SUPPLY CO. 6653 AP 36,900.00 419,800.45 Jackson Construction, LTD 6643 AP glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-69008-010-000 Account: 135-69008-010-000 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 17 Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Capital Outlays 684,875.00 Budgeted 265,074.55 Remaining Short Term Debt -Principal imp Short Term Debt -Principal 30,512.00 Budgeted Account: 135-69009-010-000 Short Term Debt -Interest Account: 135-69009-010-000 Account: 135-69195-010-000 Account: 135-69195-010-000 Account: 135-69281-010-000 Account: 135-69281-010-000 Account: 135-70040-010-000 Account: 135-70040-010-000 Totals: _ .00 Remaining Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Tot 75,000.00 Budgeted .00 Water Tank Inspection Contract Remaining 61 % Used 30,512.00 100 % Used 1,840.00 57 % Used 75,000.00 100 102,077.11 Water Tank Inspection Contract Tota 120,000.00 Budgeted 17,922.89 Remaining Bond Related Expenses Bond Related Expenses Totals: .00 Budgeted 1,220.00 Used .00 30,512.00 .00 1,840.00 .00 75,000.00 .00 102,077.11 85 % Used .00 1,220.00 (1,220.00) Remaining 0 % Used glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 18 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 1502 07/16/2020 July A/P water samples 1,081.64 80.00 1,161.64 TARRANT CTY PUBLIC HEALTH LAB 6626 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,161.64 ** Department 10 Totals: 2,000.00 Budgeted 838.36 Remaining 58 % Used 3,184,178.19 ** 410,099.44 Monthly Total 5,506,929.00 Budgeted 2,322,750.81 Remaining 58 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-5000 020- Salaries & Wa 1423 07/10/2020 MUD Payroll 7/10/2020 Salaries & Wages 298,107.02 1525 07/24/2020 MUD Payroll 7/24/2020 Salaries & Wages Account :-'5nrelSalaries & Wages Totals: 441,799.00 Budgeted Account: 135-50010-020-000 1423 07/10/2020 MUD Payroll 7/10/2020 1525 07/24/2020 MUD Payroll 7/24/2020 Account: 135-50010-020-000 110,500.83 Remaining 75 % Used 16,631.39 314,738.41 PR 16,559.76 331,298.17 PR Overtime 16,881.29 727.21 17,608.50 PR Overtime 1,159.50 18,768.00 PR 33,000.00 Budgeted 14,232.00 Remaining 57 % Used Account: 135 - Account: 135-50016-020-000 Longevit 6,872.50 .00 6,872.50 Longevity Totals: 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 1525 07/24/2020 MUD Payroll 7/24/2020 Certification Account: 135-50017-020-000 Account: 135-50020-020-000 1423 07/10/2020 MUD Payroll 7/10/2020 1525 07/24/2020 MUD Payroll 7/24/2020 ertification 9,000.00 Budgeted Retirement Retirement Account: 135-50020-020-000 Retirement 45,531.00 Budgeted 2,675.00 Remaining 5,700.00 625.00 31,860.56 70 % Used Totals: 10,364.35 Remaining 77 % Used ,11111111111111.11.111111eical Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Medical Insurance 1485 07/13/2020 F720 Health Ine Fee 2019 Form 720- Self-insured Health 1525 07/24/2020 MUD Payroll 7/24/2020 Medical Insurance 1,607.40 1,698.69 6,325.00 PR 33,467.96 35,166.65 PR PR 63,119.97 3,463.38 66,583.35 PR 22.87 66,606.22 UNITED STATES TREASURY 6631 AP 3,463.33 70,069.55 PR glpdatb2 akrolczyk Trophy Club MUD No.1 Page 20 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-020-000 Medical Insurance Totals: 6,949.58 70,069.55 ** 104,858.00 Budgeted 34,788.45 Remaining 67 5 Used Account: 135-50027-020-000 Dental Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Dental Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Dental Insurance 3,664.72 196.39 3,861.11 PR 196.36 4,057.47 PR Account: 135-50027-020-000 Dental Insurance # Totals: 392.75 4,057.47 ** 5,817.00 Budgeted 1,759.53 Remaining 70 % Used Account: 135-50028-020-000 Vision Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Vision Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Vision Insurance 585.51 31.40 616.91 PR 31.40 648.31 PR Account: 135-50028-020-000 Vision Insurance Totals: 62.80 648.31 ** 948.00 Budgeted 299.69 Remaining 68 % Used Account: 135-50029-020-000 Life Insurance & Other 1331 07/01/2020 Payroll Benefits July 1377 07/01/2020 July Ap 1533 07/24/2020 July Payroll Benefits 1553 07/31/2020 July A/P Employee Benefits Employee LTD & STD Employee LTD & STD cafe 125 plan 3,338.22 186.78 3,525.00 Humana Inc 6547 AP 190.11 3,715.11 METLIFE GROUP BENEFITS 6562 AP 165.74 3,880.85 METLIFE GROUP BENEFITS 6670 AP 32.00 3,912.85 BenefitMall 6654 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 3,912.85 ** 4,500.00 Budgeted 587.15 Remaining 87 % Used Account: 135-50030-020-000 Social Security Taxes 1423 07/10/2020 MUD Payroll 7/10/2020 Social Security Taxes 19,141.09 1525 07/24/2020 MUD Payroll 7/24/2020 Social Security Taxes 1,043.72 20,184.81 PR 1,079.30 21,264.11 PR Account: 135-50030-020-000 Social Security Taxes ` Totals: 2,123.02 21,264.11 ** 30,494.00 Budgeted 9,229.89 Remaining 70 5 Used Account: 135-50035-020-000 Medicare Taxes 1423 07/10/2020 MUD Payroll 7/10/2020 1525 07/24/2020 MUD Payroll 7/24/2020 Medicare Taxes Medicare Taxes 4,476.53 244.10 4,720.63 PR 252.41 4,973.04 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50035-020-000 Medicare Taxes Totals: 7,132.00 Budgeted 2,158.96 Remaining Account: 135-50040-020-000 Unemployment Taxes Account: 135-50040-020-000 Account Unemployment Taxes Totals: 1,260.00 Budgeted Workman's Compensation 75 07/01/2020 Insurance/Wrk Comp Expense Jul 252.00 Remaining Account: 135-50045-020- Workman's Compensation Totals. Account: 135-50060-020-000 Account: 135-50060-020-000 Account: 135-50070-020-000 Account: 135-50070-020-000 Account: 135-55005-020-000 Account: 135-55005-020-000 Account: 135-55070-020-000 15,373.00 Budgeted Pre-emp Physicals/Testing Pre-emp Physicals/Testing 400.00 Budgeted Employee Relations Employee Relations 300.00 Budgeted Engineering ' Engineeri 30,000.00 Budgeted Independent Labor 1,006.00 70 % Used 80 % Used .00 1,008.00 10,167.30 1,110.20 4,095.50 Remaining 73 % Used 281.00 119.00 Remaining 70 % Used 46.08 253.92 Remaining 15 % Used 30,000.00 Remaining 3,000.00 0 11,277.50 GL .00 281.00 .00 46.08 .00 .00 Used .00 3,000.00 glpdatb2 ekrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 22 Check Source Number Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs i 1489 07/14/2020 1489 07/14/2020 1489 07/14/2020 1489 07/14/2020 1526 07/22/2020 1526 07/22/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 July A/P July A/P July A/P July A/P July A/P July A/P PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 MBR #6 Repairs Plant water pumps Parts for fine screens 2nd visit of service contract Sewer backup customer cleanup N-95 masks bug spray, closure plugs Calibration Round Up, fly ribbon, silicone hose turbine oil filters, sponges, cement 52,787.32 490.00 53,277.32 1,750.00 55,027.32 1,648.40 56,675.72 3,000.00 59,675.72 2,918.82 62,594.54 25.98 62,620.52 14.93 62,635.45 60.00 62,695.45 130.49 62,825.94 49.97 62,875.91 170.00 63,045.91 116.33 63,162.24 DHS AUTOMATION, INC PUMP SOLUTIONS INC Huber Technology Inc Huber Technology Inc Blackmon Mooring Company Ritz Safety, LLC THE HOME DEPOT #6581 RITZ SAFETY DALLAS THE HOME DEPOT #6581 THE HOME DEPOT #6581 H & B INDUSTRIES THE HOME DEPOT #6581 6613 AP 6625 AP 6617 AP 6617 AP 6634 AP 6650 AP PC PC PC PC PC PC Account: 135-55080-020-000 Maintenance & Repairs Totals: 10,374.92 63,162.24 ** 88,000.00 Budgeted 24,837.76 Remaining 72 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 1545 07/27/2020 PCards 6/27/2020-7/27/2020 Rainx, exhaust fluid, tape,etc 18,637.93 70.51 18,708.44 THE HOME DEPOT #6581 PC Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 70.51 18,708.44 ** 10,000.00 Budgeted (8,708.44) Remaining 187 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repaij Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 Oil Change, Brake check up OI1 change carwash 1,032.42 79.36 1,111.78 KWIK KAR LUBE & TUNE 0 84.42 1,196.20 KWIK KAR LUBE & TUNE 0 7.00 1,203.20 CARMEL CARWASH - ROANO PC PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 170.78 1,203.20 ** 4,000.00 Budgeted 2,796.80 Remaining 30 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090- eh Maintenance Collections 1545 07/27/2020 PCards 6/27/2020-7/27/2020 vehicle registration 1545 07/27/2020 PCarde 6/27/2020-7/27/2020 Vehicle Registration Fee 1545 07/27/2020 PCards 6/27/2020-7/27/2020 safety inspection Account: 135-55091-02 Veh Maintenance Collections Totals: J 8,000.00 Budgeted 5,826.63 Remaining Account: 135-55105-020-000 Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: , 3,000.00 Budgeted 1,933.79 Remaining Cle 1553 07/31/2020 July A/P Janitorial service -June Account: 135 -55120 -020 - Account: 135-55125-020-000 1489 07/14/2020 July A/P Account: 135-55125-020-000 Cleaning Services Totals: 1,500.00 Budgeted Dumpster Services sludge/grit Dumpster Services 100,000.00 Budgeted Accoua 5-55135-020-000 1489 07/14/2020 July A/P lab testing 1489 07/14/2020 July A/P lab testing 1526 07/22/2020 July A/P 1526 07/22/2020 July A/P 1553 07/31/2020 July A/P 1553 07/31/2020 July A/P Account. Lab testing lab testing Lab testing lab testing Lab Analysis 40,000.00 Budgeted Account: 135 Communications/Mobiles ■ 2,156.87 1,066.21 27 % Used 7.50 2,164.37 DENTON VEHREG PC 2.00 2,166.37 TX.GOV*SERVICEFEE-DIR PC 7.00 2,173.37 RWIR RAR LUBE & TUNE 0 PC .00 1,066.21 36 % Used 700.00 87.50 787.50 MEMBER'S BUILDING MAINTENANCE 6663 AP 712.50 Remaining 53 % Used T 30,023.76 Remaining 67,770.28 2,205.96 69,976.24 L.H. CHANEY MATERIALS, INC. 6621 AP 70 % Used 27,962.07 341.55 28,303.62 OXIDOR LABORATORIES LLC 241.50 28,545.12 OXIDOR LABORATORIES LLC 341.55 28,886.67 OXIDOR LABORATORIES LLC 241.50 29,128.17 OXIDOR LABORATORIES LLC 341.55 29,469.72 OXIDOR LABORATORIES LLC 241.50 29,711.22 OXIDOR LABORATORIES LLC 10,288.78 Remaining 74 % Used 6624 AP 6624 AP 6649 AP 6649 AP 6665 AP 6665 AP glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1489 07/14/2020 July A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 7/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment cell phones 4,344.46 412.81 4,757.27 VERIZON WIRELESS Page 24 Check Source Number 6632 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 412.81 4,757.27 ** 5,000.00 Budgeted 242.73 Remaining 95 % Used Account: 135-60020-020-000 Electricity 1489 07/14/2020 1504 07/16/2020 1606 07/31/2020 July A/P electricity 6/1-6/30 July A/P Electricity 6/9-7/10 Town Billed Invoices 1746-1749 AR 20200731-20200731 User: 96,231.01 475.94 11,710.08 (160.46) 96,706.95 108,417.03 108,256.57 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, 6630 AP LLC 6618 AP AR Account: 135-60020-020-000 Electricity Totals: 12,025.56 108,256.57 ** 160,067.00 Budgeted 51,810.43 Remaining 68 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 216.00 .00 216.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 216.00 ** 300.00 Budgeted 84.00 Remaining 72 % Used Account: 135-60080-020-000 Schools & Training 1545 07/27/2020 1545 07/27/2020 PCards PCards 6/27/2020-7/27/2020 excel course 6/27/2020-7/27/2020 Safety classes 2,542.85 104.00 475.00 2,646.85 3,121.85 SKILLPATH SUNCOAST / NATIONAL LEARNING SYST PC PC Account: 135-60080-020-000 Schools & Training i Totals: 579.00 3,121.85 ** 4,990.00 Budgeted 1,868.15 Remaining 63 % Used Account: 135-60090-020-000 T Safety Program 109.14 .00 109.14 Account: 135-60090-020-000 Safety Program Totals: .00 109.14 ** 1,000.00 Budgeted 890.86 Remaining 11 % Used glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 25 Check Source Number Account: 135-60100-020-000 Travel & per diem 410.72 .00 410.72 Account: 135-60100-020-000 Travel & per diem Totals: .00 410.72 ** 1,545.00 Budgeted 1,134.28 Remaining 27 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining O % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining O % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 ** 450.00 Budgeted 450.00 Remaining O % Used Account: 135-60280-020-000 Property Maintenance 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 paint, spraygun, rollers,epoxy paint, pail Spray gun ant killer, roller frame,paint paint, bungee cord, brushes 584.94 565.80 480.94 87.96 363.30 526.53 1,150.74 THE HOME DEPOT 6581 1,631.68 THE HOME DEPOT 587 1,719.64 LOWES #00732* 2,082.94 THE HOME DEPOT 587 2,609.47 THE HOME DEPOT 6581 PC PC PC PC PC Account: 135-60280-020-000 Property Maintenance Totals: 2,024.53 2,609.47 ** 5,000.00 Budgeted 2,390.53 Remaining 52 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-60285-020-000 Lawn Equipment & Maintenance Account: 135-60285-020-000 Lawn Equipment & Maintenan. 14,000.00 Budgeted 10,145.26 Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- PID Debt Account Interfund Transfe 114,563.00 Budgeted 10,414.90 Remaining Remaining Ac Interfund Transfer Out -Rev I' 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- W&WW SYS 1552 07/31/2020 TexPool Transfers July TexPool O&M to Rev Bd WWTP I&S Account: 135 - Account: 135-60333-020-000 Account: 135-60333-020-000 3,854.74 28 .00 Used 3,854.74 93,733.29 10,414.81 104,148.10 GL 551,345.70 Interfund Transfer Out -Rev I&S Totals: 1 673,867.00 Budgeted 61,260.60 Remaining Interfund Transfer Out -Reserve Interfund Transfer Out -Reserve Totals: , 125,187.00 Budgeted 79,187.00 Remaining 46,000.00 91 Used 91 % Used 6,839.07 54,421.63 558,184.77 612,606.40 .00 46,000.00 37 % Used GL GL Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining 0 % Ueed .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 190.00 .00 190.00 Account: 135-60360-020-000 - Furniture/Equipment < $5000 2,000.00 Budgeted 1,810.00 Remaining 10 % Used Account: 135-65005-020-000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1541 07/24/2020 Fuel Fuel 5,614.72 852.63 6,467.35 US Bank Voyager Fleet Systems 6669 AP Account: 135-65005-020-000 86,467.35 a• 12,500.00 Budgeted Account: 135-65010-020-000 Account: 135-65010-020-000 Account: 135-65030-020-000 Account: 135-65030-020-000411111 5,495.00 Budgeted Chemicals Chemicals 20,000.00 Budgeted 6,032.65 Remaining 52 % Used 3,507.93 .00 3,507.93 1,987.07 Remaining 64 % Used 20,508.34 .00 20,508.34 (508.34) Remaining 103 % Used Account: 135-65031-020-00r Chemicals Collections 1553 07/31/2020 July A/P GB Breakdown degreaser 1553 07/31/2020 July A/P defoamer Acc A Account: 135-65035-020-000 Chemicals Collections 17,500.00 Budgeted 7,051.40 Remaining 1,200.00 Remaining Totals: Account: 135-65040-020-000 Account: 135-65040-020-000 ma oo s Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 4,994.00 4,994.00 460.60 1,166.53 60 % Used 0 % Used 33.47 Remaining 97 % Used 9,988.00 MICKEY D CARSON DBA/NUSCO 6664 AP 10,448.60 POLYDYNE, INC 6666 AP .00 .00 .00 1,166.53 Account: 135-65045-020-000 Lab Supplies glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1489 07/14/2020 July A/P 1499 07/16/2020 July A/P 1499 07/16/2020 July A/P 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1545 07/27/2020 PCards 6/27/2020-7/27/2020 1553 07/31/2020 July A/P 1553 07/31/2020 July A/P 1553 07/31/2020 July A/P Account: 135-65045-020-000 Account: 135-69005-020-0 1489 07/14/2020 July A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment nitrile gloves lab organisms Lab supplies cultivator,coppertop, batterys Distilled water lab supplies lab supplies lab supplies Lab Supp 20,000.00 Budgeted (4,033.06) Capital Outlays Lift Station #20 pumps Remaining 19,198.53 Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 147.00 19,345.53 157.05 19,502.58 320.84 19,823.42 50.42 19,873.84 3.96 19,877.80 513.78 20,391.58 3,491.68 23,883.26 149.80 24,033.06 120 % Used 306,065.46 Capital Outlays Tota 530,500.00 Budgeted 220,414.14 Remaining .53 4,020.40 58 % Ueed Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 19,528.26 Remaining 59,604.74 75 % Used .00 Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Account: 135-69195-020-000 Account: 135-69195-020-000 Department 20 Totals: Short Term Debt -Interest Totals: 11,277.00 Budgeted 5,154.97 Remaining Gasb34/Reserve for Replacement 6,122.03 130,000.00 .00 54 % Used .00 _ Gasb34/Reserve for Replacement Total110 130,000.00 Budgeted .00 Remaining 100 % Used 167,273.33 Monthly Total 3,157,421.00 Budgeted Page 28 Check Source Number LOU'S GLOVES INCORPORATED 6622 AP HD SUPPLY FACILITIES MAINT LTD 6616 AP HD SUPPLY FACILITIES MAINT LTD 6616 AP THE HOME DEPOT #6581 PC TOM THUMB #1789 PC HACH COMPANY 6656 AP IDEXX DISTRIBUTION, INC 6658 AP HD SUPPLY FACILITIES MAINT LTD 6657 AP 310,085.86 DHS AUTOMATION, INC 59,604.74 6,122.03 130,000.00 130,000.00 ** 2,174,069.37 ** 983,351.63 Remaining 69 % Used 6613 AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 Account: 135-50045-026-0 Workman's Compensation i 75 07/01/2020 Insurance/Wrk Comp Expense Jul 17.91 Accll Workman's Compensation 30.00 Budgeted Totals: 10.10 Remaining 1111 66 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 0 % Used 111 Dues & Memberships AccounteMirATII Dues & Memberships Total. - 750.00 Budgeted 75.00 Remaining Account: 135-60075-026-000 Meetings 1545 07/27/2020 PCarde 6/27/2020-7/27/2020 Zoom meeting software Account: 135-60075-026-000 Meeting. 1,300.00 Budgeted 638.21 Remaining 675.00 537.80 90 % Used 51 Used 1.99 19.90 .00 .00 .00 675.00 123.99 661.79 ZOOM.US GL PC Account: 135-60080-026-000 375.00 Account: 135-60080-026-000 4,000.00 Budgeted 3,625.00 Remaining 9 % Used Account: 135-60100-026-000 Travel & per diem Account: 135-60100-026-000 Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 375.00 .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 ** Department 26 Totals: 2,000.00 Budgeted 125.98 Monthly Total 2,000.00 Remaining 0 % Used 1,731.69 •• 13,230.00 Budgeted 11,498.31 Remaining 13 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-5000 030- Salaries & 415 - 1423 07/10/2020 MUD Payroll 7/10/2020 Salaries & Wages 299,176.62 1525 07/24/2020 MUD Payroll 7/24/2020 Salaries & Wages Account :-'5nrelrSalaries & Wages Totals: Account: 135-50010-030-000 Account: 135-50010-030-000 Account: 135-50016-030-000 628,298.00 Budgeted Overtime Overtime 2,000.00 Budgeted 286,768.84 Remaining 54 % Used 41.79 1,958.21 Remaining 2 % Used Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 1423 07/10/2020 MUD Payroll 7/10/2020 Retirement 1525 07/24/2020 MUD Payroll 7/24/2020 Retirement Account: 135-50020-030-000 2,207.50 100 % Used 29,408.71 21,192.49 320,369.11 PR 21,160.05 341,529.16 PR .00 41.79 .00 2,207.50 1,962.42 31,371.13 1,959.45 33,330.58 Retirmlk 3,921.87 58,554.00 Budgeted 25,223.42 Remaining A35-50026-030-000 Medical I ce 1423 07/10/2020 MUD Payroll 7/10/2020 Medical Insurance 1485 07/13/2020 F720 Health Ins Fee 2019 Form 720- Self-insured Health 1525 07/24/2020 MUD Payroll 7/24/2020 Medical Insurance Account: 135-50026-030-000 Medical Insurance 124,394.00 Budgeted Account: 135-50027-030- tal Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Dental Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Dental Insurance 60,235.51 Remaining 57 % Used PR PR 56,165.45 3,985.11 60,150.56 PR 22.87 60,173.43 UNITED STATES TREASURY 6631 AP 3,985.06 64,158.49 PR 3,109.91 52 % Used 8.49 00 220.99 3,330.90 220.97 3,551.87 PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 32 Account: 135-50027-03 Dental Insurance Totals: 6,464.00 Budgeted Account: ion Insurance 1423 07/10/2020 MUD Payroll 7/10/2020 Vision Insurance 1525 07/24/2020 MUD Payroll 7/24/2020 Vision Insurance Account: 135-50028-030-000 Account: 135-- 1331 07/01/2020 Payroll Benefits July 1377 07/01/2020 July Ap 1533 07/24/2020 July Payroll Benefits 1553 07/31/2020 July A/P Account: 135 -50029 -030 - Vision Insurance 1,035.00 Budgeted 2,912.13 Remaining 55 5 Used Employee Benefits Employee LTD & STD Employee LTD & ETD cafe 125 plan 499.09 Remaining Life Insurance & Other Totals: 4,500.00 Budgeted 470.31 3,002.75 52 % Used 441 32.81 503.12 32.79 535.91 242.22 174.00 197.79 16.00 867.24 Remaining 81 % Used Account: 135-50030-030 ^ Social Security Taxes 1423 07/10/2020 MUD Payroll 7/10/2020 Social Security Taxes 1525 07/24/2020 MUD Payroll 7/24/2020 Social Security Taxes Social Security Taxes 39,215.00 Budgeted 1423 07/10/2020 MUD Payroll 7/10/2020 1525 07/24/2020 MUD Payroll 7/24/2020 Account: 135-50040-030-000 Account: 135-50040-030-000 Medicare Taxes Medicare Taxes Medicare Taxes 17,459.22 19,327.14 Remaining 51 % Ueed 3,244.97 3,418.97 3,616.76 3,632.76 1,217.07 18,676.29 1,211.57 19,887.86 Humana Inc METLIFE GROUP BENEFITS METLIFE GROUP BENEFITS BenefitMall PR PR 6547 AP 6562 AP 6670 AP 6654 AP PR PR 4,083.23 284.63 4,367.86 PR 283.35 4,651.21 PR Medicare Taxes i 9,171.00 Budgeted 4,519.79 Remaining 51 % Used Unemployment Taxes Unemployment Taxe411111111 Totals: 1 1,440.00 Budgeted 432.00 Remaining 1,008.00 70 % Used .00 1,008.00 glpdatb2 ekrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 33 Check Source Number 1489 07/14/2020 1499 07/16/2020 1499 07/16/2020 1526 07/22/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 July A/P July A/P July A/P July A/P PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 cell phones Microsoft exchange Microsoft exchange Internet -July website Internet internet internet Adobe Subscription 84,181.02 50.30 494.00 494.00 899.00 39.34 72.25 82.25 43.01 36.78 84,231.32 VERIZON WIRELESS 84,725.32 M3 Networks 85,219.32 M3 Networks 86,118.32 Charter Communications 86,157.66 DNB*GODADDY.COM 86,229.91 ATT*BILL PAYMENT 86,312.16 ATT*BILL PAYMENT 86,355.17 ATT*SILL PAYMENT 86,391.95 ADOBE ACROPRO SUBS 6632 6623 6623 6635 AP AP AP AP PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,210.93 86,391.95 ** Account: 135-50045-030-000 Workman's Compensation 134,681.00 Budgeted 48,289.05 Remaining 64 % Used 75 07/01/2020 Insurance/Wrk Comp Expense Jul 135-55070-030-000 943.38 104.82 1,048.20 GL Account: 135-50045-030-000 Workman's Compensation Totals: 1489 07/14/2020 July A/P Carmen June Hours • 104.82 1,048.20 ** 90,226.07 Carman Consulting LLC. 1,775.00 Budgeted 726.80 Remaining 59 % Used Independent Labor Totals: 300.00 Account: 135-50060-030-000 Pre-emp Physicals/Testing 135,000.00 Budgeted 44,773.93 Remaining 67 % Used Account: .00 .00 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 3,078.10 .00 3,078.10 Account: 135-50070-030-000 Employee Relations Totals: .00 3,078.10 ** 8,000.00 Budgeted 4,921.90 Remaining 38 % Used Account: 135-55030-030-000 Aligill Software & Support _ 1489 07/14/2020 1499 07/16/2020 1499 07/16/2020 1526 07/22/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 July A/P July A/P July A/P July A/P PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 PCards 6/27/2020-7/27/2020 cell phones Microsoft exchange Microsoft exchange Internet -July website Internet internet internet Adobe Subscription 84,181.02 50.30 494.00 494.00 899.00 39.34 72.25 82.25 43.01 36.78 84,231.32 VERIZON WIRELESS 84,725.32 M3 Networks 85,219.32 M3 Networks 86,118.32 Charter Communications 86,157.66 DNB*GODADDY.COM 86,229.91 ATT*BILL PAYMENT 86,312.16 ATT*BILL PAYMENT 86,355.17 ATT*SILL PAYMENT 86,391.95 ADOBE ACROPRO SUBS 6632 6623 6623 6635 AP AP AP AP PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,210.93 86,391.95 ** 134,681.00 Budgeted 48,289.05 Remaining 64 % Used Account: 135-55070-030-000 Independent Labor 1489 07/14/2020 July A/P Carmen June Hours 89,926.07 300.00 90,226.07 Carman Consulting LLC. 6609 AP Account: 135-55070-030-000 Independent Labor Totals: 300.00 90,226.07 ** 135,000.00 Budgeted 44,773.93 Remaining 67 % Used Account: 135-55080-030-000 Maintenance & Repairs glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,855.00 .00 1,655.00 Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 1,855.00 ** 15,000.00 Budgeted 13,145.00 Remaining 12 % Used Account: 135-55085-030-000 Generator Maint. and Repair 531.00 .00 531.00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 531.00 ** 10,000.00 Budgeted 9,469.00 Remaining 5 % Used Account: 135-55120-030-000 Cleaning Services 1553 07/31/2020 July A/P Janitorial service -June 9,555.56 1,896.92 11,452.48 MEMBER'S BUILDING MAINTENANCE 6663 AP Account: 135-55120-030-000 Cleaning Services Totals: 1,896.92 11,452.48 ** 10,000.00 Budgeted (1,452.48) Remaining 115 % Used Account: 135-55160-030-000 Professional Outside Services 57,100.00 .00 57,100.00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,100.00 ** 65,600.00 Budgeted 8,500.00 Remaining 87 % Used Account: 135-55205-030-000 Utility Billing Contract 5,253.58 .00 5,253.58 Account: 135-55205-030-000 Utility Billing Contract Totals: .00 5,253.58 ** 9,000.00 Budgeted 3,746.42 Remaining 58 % Used Account: 135-60005-030-000 Telephone 1545 07/27/2020 PCards 6/27/2020-7/27/2020 phone 1545 07/27/2020 PCards 6/27/2020-7/27/2020 phone 1545 07/27/2020 PCards 6/27/2020-7/27/2020 phone 1545 07/27/2020 PCards 6/27/2020-7/27/2020 answering service 1606 07/31/2020 Town Billed Invoices 1746-1749 AR 20200731-20200731 User: 14,760.87 478.81 15,239.68 ATT*BUS PHONE PMT PC 808.91 16,048.59 ATT*BUS PHONE PMT PC 181.58 16,230.17 ATT*BILL PAYMENT PC 16.76 16,246.93 RINGCENTRAL, INC PC (180.00) 16,066.93 AR Account: 135-60005-030-000 Telephone Totals: 1,306.06 16,066.93 ** 23,680.00 Budgeted 7,613.07 Remaining 68 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 Account: 135-60010-030- Communications/Mobiles 1489 07/14/2020 July A/P cell phones 1525 07/24/2020 MUD Payroll 7/24/2020 Communications/Mobiles Account:',1111F0-0 Communications/Mobiles Totals: 4,000.00 Budgeted 1,634.95 Remaining Account: 135-60020-030-000 1 1489 07/14/2020 July A/P Account: 135-60020-030-000 Electricity/Gas Gexa Energy 5/8-6/9 ricity/Gas 6,879.00 Budgeted 2,025.88 Remaining Account: 135-60025-030- 1606 07/31/2020 Town Billed Invoices 1746-1749 AR 20200731-20200731 User: A 1,500.00 Account: 135-60035-030-00 1526 07/22/2020 July A/P 1545 07/27/2020 PCards 6/27/2020-7/27/2020 Budgeted Postage lease postage for machine 278.42 S: Remaining 2,089.75 50.30 2,140.05 VERIZON WIRELESS 225.00 2,365.05 59 % Used 4,372.02 481.10 1,363.85 71 % Used 81 % Used (142.27) 4,853.12 TOWN OF TROPHY CLUB 1,221.58 14,722.25 107.67 14,829.92 FRANCOTYP-POSTALIA, INC. 227.70 15,057.62 FP MAILING SOLUTIONS 6632 AP PR 6629 AP 6640 AP PC Postag= Ac- 35-60040-030-000 - 1595 07/31/2020 Pace Credit Card Fees 1595 07/31/2020 Pace Credit Card Fees Account: 135-60040-030-000 30,000.00 Budgeted Service Charges & Fees 14,942.38 Remaining Mr Service Charges & Fees Totals: 67,000.00 Budgeted Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 52,819.07 50 % Used 5,897.66 58,716.73 19.84 58,736.57 8,263.43 Remaining 88 % Used Bad Debt Expense Totals: 1,500.00 Budgeted 1,500.00 Remaining 0 % Used .00 .00 GL GL glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 36 Check Source Number Account: 135-60055-030-000 Insurance 75 07/01/2020 Insurance/Wrk Comp Expense Jul 59,423.65 6,998.39 66,422.04 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 66,422.04 ** 84,000.00 Budgeted 17,577.96 Remaining 79 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 1545 07/27/2020 PCards 6/27/2020-7/27/2020 GFOAT Dues 4,285.55 143.00 4,428.55 TEXAS MUNICIPAL LEAGUE PC Account: 135-60070-030-000 Dues & Memberships Totals: 143.00 4,428.55 ** 6,000.00 Budgeted 1,571.45 Remaining 74 % Used Account: 135-60075-030-000 Meetings 115.09 .00 115.09 Account: 135-60075-030-000 Meetings Totals: .00 115.09 ** 400.00 Budgeted 284.91 Remaining 29 % Used Account: 135-60079-030-000 Public Education 4,047.85 .00 4,047.85 Account: 135-60079-030-000 Public Education ' Totals: , .00 4,047.85 *0 III 6,000.00 Budgeted 1,952.15 Remaining 67 % Used Account: 135-60080-030-000 Schools & Training 1545 07/27/2020 PCards 6/27/2020-7/27/2020 training 2,386.21 35.00 2,421.21 GUMROAD.CO* TEXAS MUNI PC Account: 135-60080-030-000 Schools & Training Totals: 35.00 2,421.21 ** 6,850.00 Budgeted 4,428.79 Remaining 35 % Used Account: 135-60100-030-000 Travel & per diem glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 37 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1526 07/22/2020 July A/P 1526 07/22/2020 July A/P Acc tolls to lab tolls to lab Travel & per diem 3,545.00 Budgeted 1,157.41 3.83 6.74 2,377.02 Remaining 33 % Used 1,161.24 NTTA 1,167.98 NTTA 10.57 1,167.98 ** Account: Physicals/Testing Account• Physicals/Testing 200.00 Budgeted 200.00 Remaining .00 0 % Used .00 6647 AP 6647 AP 111 Elections Account: actions .00 Budgeted Account: 135-60125-030-000 ertising 4 1545 07/27/2020 PCarde 6/27/2020-7/27/2020 Job Posting Account: 135-60125-030-000 Account: 135-60235-030-000 1526 07/22/2020 July A/P `Adverti. 2,500.00 Budgeted 138.04 .00 138.04 (138.04) Remaining 0 % Used 3,961.80 150.00 4,111.80 TEXAS MUNICIPAL LEAGUE (1,611.80) Remaining monitoring evc-May 164 Used 192.00 24.00 216.00 Digital Air Control, Inc PC 6637 AP Account: 135-60235-030-000 MEP Security 1,288.00 Budgeted 1,072.00 Remaining 17 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 Account: 135-60245-030-000 Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency glpdatb2 ekrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Account: 135-60360-030-000 Furniture/Equipment < $5000 1545 07/27/2020 PCarda 6/27/2020-7/27/2020 Desk, bookcase, combo file Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Furniture/Equipment < $5000 2,500.00 Budgeted Uniforms 2,050.00 Budgeted Account: 135-65055-030-000 Hardware 1526 07/22/2020 July A/P Laurie's Laptop Account Tot 473.01 .00 0 % Used Remaining 81 Used 2,050.00 Remaining 0 % Used 2,026.99 .00 .00 2,026.99 NEBRASKA FURNITURE .00 .00 .00 3,986.20 2,345.50 PC 6,331.70 M3 Networks 6645 AP Hardware A: 6,331.70 ** 26,485.00 Budgeted 20,153.30 Remaining 24 % Used AC. 5-65085-030-000 Office Supplies 1526 07/22/2020 July A/P office supplies 1545 07/27/2020 PCarda 6/27/2020-7/27/2020 ink 1545 07/27/2020 PCards 6/27/2020-7/27/2020 postcards 1553 07/31/2020 July A/P Hand sanitizer Ac,...5-65085-030-000 Account: 135-65090-030-000 Account: 135-65090-030-000 Office Supplies Totals: 6,000.00 Budgeted 3,938.45 96.03 4,034.48 OFFICE DEPOT, INC 6648 AP 115.80 4,150.28 AMZN METP US*MV9UN12Q1 PC 82.31 4,232.59 SP * DESKTOPSUPPLIES PC 286.00 4,518.59 Precision Pump Systeme 6667 AP 1,481.41 Remaining 75 % Used Printer Supplies & Maintenance Printer Supplies & Maintenance Totals: 4 3,500.00 Budgeted 3,500.00 Remaining 0 % Used .00 .00 glpdatb2 skrolczyk 12:00 08/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 39 Check Source Number Account: 135-65095-030-000 Maintenance Supplies 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 1545 07/27/2020 PCards PCards PCards PCards PCarde PCards PCards 6/27/2020-7/27/2020 6/27/2020-7/27/2020 6/27/2020-7/27/2020 6/27/2020-7/27/2020 6/27/2020-7/27/2020 6/27/2020-7/27/2020 6/27/2020-7/27/2020 papertowels coffee bleach, soap, towel coffee break room & cleaning supplies break room & cleaning supplies break room & cleaning supplies 3,351.68 45.03 41.04 12.36 42.36 8.36 15.92 81.41 3,396.71 3,437.75 3,450.11 3,492.47 3,500.83 3,516.75 3,598.16 AMAZON.COM*MV18W7VA0 AMAZON.COM*MV66M73L1 WM SUPERCENTER #5247 AMAZON.COM*MJ6OJ85X0 WALMART GROCERY WALMART GROCERY WALMART GROCERY PC PC PC PC PC PC PC 1503 07/16/2020 July A/P 1503 07/16/2020 July A/P 1526 07/22/2020 July A/P TCMUD boundary GIS development GIS Asset location 181.42 41,121.40 Halff Associates, INC 266.20 41,387.60 Halff Associates, INC 500.00 41,887.60 Halff Associates, INC 6614 AP 6614 AP 6641 AP Account: 135-69005-030-000 Account: 135-65095-030-000 Maintenance Supplies Totals: 13,439.76 41,887.60 ** 3,598.16 ** 1 195,000.00 Budgeted 153,112.40 Remaining 4,000.00 Budgeted 401.84 Remaining 90 % Used Account: 135-69170-030-000 Copier Lease Installments Account: 135-65105-030-000 Printing 1491 07/14/2020 1553 07/31/2020 July A/P July A/P copier lease -July copies 2,077.60 165.00 173.43 2,242.60 2,416.03 TIAA COMMERCIAL KYOCERA DOCUMENT FINANCE SOLUTIONS 6628 6661 AP AP Account: 135-69170-030-000 .00 .00 Lease Installments Totals: 338.43 2,416.03 Account: 135-65105-030-000 Printing Totals: 4,000.00 Budgeted 1,583.97 Remaining .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays 1489 07/14/2020 July A/P Phase III 28,447.84 12,492.14 40,939.98 3RD EYE SURVEILLANCE SYSTEMS 6607 AP 1503 07/16/2020 July A/P 1503 07/16/2020 July A/P 1526 07/22/2020 July A/P TCMUD boundary GIS development GIS Asset location 181.42 41,121.40 Halff Associates, INC 266.20 41,387.60 Halff Associates, INC 500.00 41,887.60 Halff Associates, INC 6614 AP 6614 AP 6641 AP Department 30 Totals: 97,425.63 Monthly Total 973,745.01 ** 1,776,712.00 Budgeted 802,966.99 Remaining 55 5 Used Account: 135-69005-030-000 MIWCapital Outlays Totals: 13,439.76 41,887.60 ** or 195,000.00 Budgeted 153,112.40 Remaining 21 % Used Account: 135-69170-030-000 Copier Lease Installments 1491 07/14/2020 1553 07/31/2020 July A/P July A/P copier lease -July copies 2,077.60 165.00 173.43 2,242.60 2,416.03 TIAA COMMERCIAL KYOCERA DOCUMENT FINANCE SOLUTIONS 6628 6661 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 338.43 2,416.03 ** 4,000.00 Budgeted 1,583.97 Remaining 60 % Used Department 30 Totals: 97,425.63 Monthly Total 973,745.01 ** 1,776,712.00 Budgeted 802,966.99 Remaining 55 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039- Legal 1526 07/22/2020 July A/P legal Account: 135-55045-03 Legal 135,000.00 Budgeted Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 Auditing 33,800.00 Budgeted Account: 135-55060-039-000 Appraisal Account: 135-55060-039-000 Appraisal 11,761.00 Budgeted Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 Tax Admin Fees 4,000.00 Budgeted Department 39 Totals: Fund 135 Totals: 2,957.50 Monthly Total 95,202.89 2,957.50 98,160.39 McLean & Howard, L.L.P. 36,839.61 Remaining 73 % Used 27,713.27 .00 27,713.27 6,086.73 Remaining 82 % Ueed 9,665.52 .00 9,665.52 2,095.48 Remaining 82 % Ueed 3,756.00 .00 3,756.00 244.00 Remaining 94 % Used 139,295.18 ** 184,561.00 Budgeted 45,265.82 Remaining 75 % Used (902,403.31) (419,744.59) Monthly Total (6,224.00) Budgeted 896,179.31 Remaining ########## 6646 AP glpdatb2 skrolczyk 12:00 08/10/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: 7/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 41 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 JULY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 495,029 TOTAL ASSETS 495,029 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) (72,037) TOTAL FUND BALANCE (190,447) TOTAL LIABILITIES AND FUND BALANCE 495,029 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 87.85- 4,990.39- 4,990.39 Page 14 Subtotal: Mr- 87.85- 4,990.39- 4,990.39 Program number: 87.85- 4,990.39- 4,990.39 Department number: Revenues 87.85- 4,990.39- 4,990.39 Revenues Subtotal 87.85- 4,990.39- 4,990.39 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description 517-69005-020-000 Capital Outlays Subtotal: Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 7/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,870.00 77,027.66 1,870.00 77,027.66 Department number: Wastewater Expenditures Subtotal Fund number: 517 2014 MUD 1 Tax Bond Const WWTP - - - 1,870.00 1,870.00 1,782.15 77,027.66 77,027.66 72,037.27 77,027.66- 77,027.66- 77,027.66- 77,027.6 7,027.66- 77,027.66- 77,027.66- 77,027. - 77,027.66- 72,037.2 Page 15 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/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 1592 07/31/2020 Bank Interest- July Account: 517-49011-000-000 erest Income .00 Budgeted ■ (4,902.54) (87.85) (4,990.39) GL Totals: 4,990.39 Remaining 0 % Uaed Department Totals: (4,990.39) ** (87.85) Monthly Total .00 Budgeted 4,990.39 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 43 Account: 517-69005-020-0' Capital Outlays 1526 07/22/2020 July A/P Account: 517-69005-0 Capital Outla .00 Budgeted Department 20 Totals: 1,870.00 Monthly Total (77,027.66) Remaining 75,157.66 0 % Used .00 Budgeted 1,870.00 77,027.66 Dubois Bryant Campbell LLP 77,027.66 ** (77,027.66) Remaining 0 % Used Fund 517 Totals: 72,037.27 1,782.15 Monthly Total .00 Budgeted (72,037.27) Remaining 0 % Used 6638 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JULY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,954 TOTAL ASSETS 784,954 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,615 703,263 784,954 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 6.45- 4,614.82- 4,614.82 Page 16 Subtotal: 6.45- 4,614.82- 4,614.82 Program number: 6.45- 4,614.82- 4,614.82 Department number: Revenues 6.45- 4,614.82- 4,614.82 Revenues Subtotal 6.45- 4,614.82- 4,614.82 I Fund number: 519 2016 Rev Bond Const -SWIFT 6.45- 4,614.82- 4,614.82 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 7/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 1592 07/31/2020 Bank Interest- July Account: 519-49011-000-000 Department Totals: Fund 519 Totals: erest Income .00 Budgeted ■ (4,608.37) Totals: 4,614.62 Remaining 0 % Used (6.45) Monthly Total .00 Budgeted (6.45) Monthly Total .00 Budgeted (6.45) (4,614.82) GL (6.45) (4,614.82) ** (4,614.82) ** 4,614.82 Remaining 0 5 Used (4,614.82) 4,614.82 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JULY 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 285,070 INVESTMENTS 3,892,459 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,177,529 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 (276,761) 4,177,529 4,177,529 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 520 Revenue Bond 16" Waterline Account Description 520-49011-000-000 Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Program: Period Ending: 7/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: Department number: Revenues Subtotal 92.84- 92.84- 92.84- 92.84- 92.84- 27,779.92- 27,779.92- 27,779.92- 27,779.92- 27,779.92- 27,779.92 27,779.92 27,779.92 27,779.92 27,779.92 Page 17 304,540.82 - ME 60,602.19 276,760.90 276,760.90- glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 60,695.03 304,540.82 304,540.82 - Page 18 Subtotal: 60,695.03 304,540.82 304,540.82 - Program number: 60,695.03 304,540.82 304,540.82 - Department number: Water Department 60,695.03 304,540.82 304,540.82 - Expenditures Subtotal 60,695.03 304,540.82 Fund number: 520 Revenue Bond 16" Waterline -14 glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 45 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1592 07/31/2020 Bank Interest- July (27,687.08) 1592 07/31/2020 Bank Interest- July (60.84) (27,747.92) GL (32.00) (27,779.92) GL Account: 520-490 nterest Income Totals: .00 Budgeted 27,779.92 Remaining 0 % Used Department Totals: (27,779.92) ** (92.84) Monthly Total .00 Budgeted 27,779.92 Remaining 0 % Used glpdatb2 skrolczyk 12:00 08/10/20 Fund: 520 Revenue Bond 16" Waterline ACC JE Number JE Date JE Description Dunt: 520-69005-010-0" 1421 07/06/2020 1503 07/16/2020 1526 07/22/2020 1549 07/31/2020 1550 07/31/2020 Account: 520-69005-010-000 Department 10 Totals: Fund 520 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Period Ending: 7/2020 JE Detail Beginning Balance Description/Comment Capital Outlays Parcel 3-1003 Plantation Oaks 16" water line easement acquis Easement Acquisition Legal Parcel 28 easement -Davis Blvd Parcel 2B easement -David Blvd July A/P July A/P July A/P VOID- Additional signee on chk A/P check run Capital Outlays 243,845.79 Program: Transaction Detail 50,391.00 5,568.22 4,572.41 (39,118.01) 39,281.41 Transaction Vendor Name Detail (SUBTOTAL) 294,236.79 Armore-Trophy Club, LLC 299,805.01 Halff Associates, INC 304,377.42 Jackson Walker LLP 265,259.41 Citibank, N.A. 304,540.82 Citibank, NA & Community Total .82 ** .00 Budgeted (304,540.82) Remaining 0 % Used 60,695.03 Monthly Total 60,602.19 Monthly Total .00 Budgeted .00 Budgeted 304,540.82 ** (304,540.82) Remaining 0 % Used 276,760.90 (276,760.90) Remaining 0 % Used Page 46 Check Source Number 6592 AP 6614 AP 6644 AP 6521 AP 6651 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,625 TOTAL ASSETS 893,625 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,168 893,625 893,625 glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW Program number: Department number: Revenues Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 11,000.00- 307,049.00- 200,417.00- 157.94- 7,367.90- 36,800.00- 46,000.00- 66.981 11.985 22.952 3,632.10- 270,249.00- 154,417.00- 518,466.00- 157.94- 91 428,298.10- 518,466.00- 157.94- 17.391 428,298.10- 518,466.00- 157.94- jIIIIII90- 17.391 428,298.10- 518,466.00- 157.94- - 90- 17.391 428,298.10- 518,466.00- 157.94- - 90- 17.391 428,298.10 - Page 19 glpdatb2 ekrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 47 Account: 528-49011-000-000 Interest Income 1592 07/31/2020 Bank Interest- July Account: 528-49011-000-000 Account: 528-49142-000-000 Account: 528-49142-000-000 Account: 528-49143-000-000 come 1 (11,000.00) Budgeted (3,632.10) Remaining (307,049.00) Budgeted Account: 528-49143-000-000 Interfund transfer in - (200,417.00) Budgeted Department Totals: Fund 528 Totals: (7,209.96) (157.94) (7,367.90) 67 % Used (36,800.00) .00 (36,800.00) (270,249.00) Remaining 12 % Used (46,000.00) (154,417.00) Remaining .00 23 % Used (46,000.00) (90,167.90) ** (157.94) Monthly Total (518,466.00) Budgeted (428,298.10) Remaining 17 % Used (90,167.90) (157.94) Monthly Total (518,466.00) Budgeted (428,298.10) Remaining 17 % Used GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JULY 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 888,853 11,239 900,092 11,239 11,239 82,954 805,899 888,853 900,092 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 533-49011-000-000 533-49015-000-000 533-49141-000-000 Subtot Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Program number: Department number: Revenues Revenues Subtotal 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- 0- 0- 1,023,008.00- 1,023,008.00- 5,000.00- 218,004.00- 114,563.00- 337,567.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 3,723.62- 119.59- 500.92- 155.05- 10,414.81- 14,913.99- 687,451.29- 1,979.57- 2,868.82- 692,299.68- 4,062.32- 218,004.00- 104,148.10- 14,913.99- 1,018,514.10- 14,913.99- 1,018,514.10- 100.734 197.957 143.441 101.001 81.246 100.000 90.909 5,010.29 979.57 868.82 6,858.68 937.68- 10,414.90 - 99.561 4,493.90- 99.561 4,493.90- 99.561 4,493.90- Page 20 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 533-70020-051-000 533-70025-051-000 1 533-70035-051-000 Paying Agent Fee Bond Issuance Bond Interest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 7/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 1,450.00 87,236.14 123,928.75 67.442 50.000 700.00 87,236.14- 123,929.25 765,000.00 Page 21 ir Subtotal: 1,015,008.00 1,015,008.00 212,614.89 20.947 802,393.11 Program number: 1,015,008.00 1,015,008.00 212,614.89 20.947 802,393.11 Department number: Administration 1,015,008.00 1,015,008.00 212,614.89 20.947 802,393.11 Expenditures Subtotal 1,015,008.00 1,015,008.00 212,614.89 20.947 802,393.11 Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 14,913.99- 805,899.21- ############### 797,899.21 glpdatb2 skrolczyk 12:00 08/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Accoyyyyta 533-40000-000- 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1583 07/09/2020 Property Taxes 1607 07/13/2020 Property Taxes 1584 07/15/2020 Property Taxes 1585 07/16/2020 Property Taxes 1586 07/17/2020 Property Taxes 1587 07/20/2020 Property Taxes 1588 07/21/2020 Property Taxes 1589 07/22/2020 Property Taxes 1590 07/23/2020 Property Taxes 1591 07/24/2020 Property Taxes 1596 07/27/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes 1602 07/30/2020 Property Taxes 1603 07/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 48 Check Source Number Property Taxes (683,727.67) (334.39) (684,062.06) (37.83) (684,099.89) (127.09) (684,226.98) (857.91) (685,084.89) 514.71 (684,570.18) (24.98) (684,595.16) (25.43) (684,620.59) (56.89) (684,677.48) (306.64) (684,984.12) (1,582.17) (686,566.29) (234.26) (686,800.55) (202.45) (687,003.00) (51.77) (687,054.77) (302.61) (687,357.38) (156.92) (687,514.30) 745.43 (686,768.87) (216.20) (686,985.07) (85.22) (687,070.29) (381.00) (687,451.29) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000—W Property Taxes Totals: (682,441.00) Budgeted 5,010.29 Remaining 101 % Used Account: 533-40002-000-000- 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1589 07/22/2020 Property Taxes 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes Property Taxes/Delinquent Account: - - - Account: 533-40015-000-009 1579 07/01/2020 Property Taxes 1580 07/06/2020 Property Taxes 1581 07/07/2020 Property Taxes 1582 07/08/2020 Property Taxes 1587 07/20/2020 Property Taxes 1589 07/22/2020 Property Taxes Property Taxes/Delinquent Totals: (1,000.00) Budgeted (1,859.98) 979.57 Remaining 198 % Ueed (9.55) (1,869.53) (10.69) (1,880.22) (85.89) (1,966.11) (5.93) (1,972.04) (7.53) (1,979.57) GL GL GL GL GL Property Taxee/P & I (2,367.90) (38.66) (2,406.56) (2.68) (2,409.24) (5.37) (2,414.61) (128.70) (2,543.31) (265.78) (2,809.09) (37.88) (2,846.97) GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 49 1591 07/24/2020 Property Taxes 1597 07/28/2020 Property Taxes 1598 07/29/2020 Property Taxes (2,367.90) (1.69) (3.94) (16.22) (2,848.66) (2,852.60) (2,868.82) GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (500.92) (2,868.82) ** (2,000.00) Budgeted 868.82 Remaining 143 % Used Account: 533-49011-000-000 Interest Income 1592 07/31/2020 Bank Interest- July (3,907.27) (155.05) (4,062.32) GL Account: 533-49011-000-000 Interest Income Totals: (155.05) (4,062.32) ** (5,000.00) Budgeted (937.68) Remaining 81 % 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 Trana In -PID Surchg 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- PID Debt (93,733.29) (10,414.81) (104,148.10) GL Account: 533-49141-000-000 Interfund Trana In -PID Surchg Totals: (10,414.81) (104,148.10) ** Department Totals: (114,563.00) Budgeted (14,913.99) Monthly Total (10,414.90) Remaining 91 % Used (1,018,514.10) ** (1,023,008.00) Budgeted (4,493.90) Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,450.00 .00 1,450.00 Account: 533-70005-051-000 Paying Agent Fee Totals: 2,150.00 Budgeted Account: 533-70020-051-000 Bond Issuance 700.00 Remaining 67 % Used Account: 533-70020-051-000 Bond Issuance .00 Budgeted (87,236.14) Remaining Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 87,236.14 123,928.75 Bond Interest Expense -Tax Totals: 247,858.00 Budgeted 123,929.25 Remaining .00 0 % Used 87,236.14 .00 123,928.75 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Bond Principal Payment -T 765,000.00 Budgeted Department 51 Totals: Fund 533 Totals: 765,000.00 Remaining 0 Used .00 .00 212,614.89 ** .00 Monthly Total 1,015,008.00 Budgeted 802,393.11 Remaining 21 % Used (805,899.21) (14,913.99) Monthly Total (8,000.00) Budgeted 797,899.21 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JULY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 465,824 TOTAL ASSETS 465,824 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 24,518 441,307 465,824 465,824 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 598,638.00- 598,638.00 - Sub totl 6080- 601 438.00 - Program number: 6011111100 - Department number: Revenues 6011'38.00 - Revenues Subtotal 601,138.00- 601,138.00- 601,138.00- 601,138.00- 73.02- 54,421.63- 4,494.65- 54,494.65- , 54,494.65- 1 54,494.65- 1,409.81- 56.392 1,090.19- 544,215.70- 90.909 54,422.30- 545, - 545,625.51- 545,625.51- 545,625.51- 55,512.49- 55,512.49- 55,512.49 - Page 22 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 534-70040-051-000 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 208,238.00 390,000.00 400.00 208,238.00 390,000.00 Subtotal: , 598,638.00 598,638.00 Program number: III 598,638.00 598,638.00 Department number: Administration III 598,638.00 598,638.00 Expenditures Subtotal 111 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,494.65- 200.00 50.000 200.00 104,118.75 50.000 104,119.25 390,000.00 17.426 494,319.25 1C=Plin 17.426 494,319.25 18.75 17.426 494,31 1111118.75 17.426 494,31 416.76- ############### 438,806.76 Page 23 glpdatb2 skrolczyk 12:00 08/10/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: 7/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (54,494.65) Monthly Total (545,625.51) ** (601,138.00) Budgeted (55,512.49) Remaining 91 5 Used Account: 534-49011-000-000 Interest Income 1592 07/31/2020 Bank Interest- July (1,336.79) (73.02) (1,409.81) GL Account: 534-49011-000-000 Interest Income Totals: (73.02) (1,409.81) ** (2,500.00) Budgeted (1,090.19) Remaining 56 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1552 07/31/2020 TexPool Transfers July TexPool O&M to Rev Bd WWTP I&S (489,794.07) (54,421.63) (544,215.70) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: ■ (54,421.63) (544,215.70) ** (598,638.00) Budgeted (54,422.30) Remaining 91 5 Used Department Totals: (54,494.65) Monthly Total (545,625.51) ** (601,138.00) Budgeted (55,512.49) Remaining 91 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Rev Bond Paying Agent Fee - 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 Account: 534-70045-051-000 Revenue Bond Principal Expense t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining 50 % Used .00 200.00 .00 104,118.75 50 % Used .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (441,306.76) (54,494.65) Monthly Total (2,500.00) Budgeted 438,806.76 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 225,811 TOTAL ASSETS 225,811 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,967 220,844 225,811 225,811 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Subtot Program number: Department number: Revenues Revenues Subtotal 35.64- 25,047.72- 629.79- 250,477.20- 25.00- 251,106.99- 0- 276125.00- 36- 251,106.99- 0- 276,525.00- 251,106.99- 276,525.00- 276,525.00- 251,106.99- 62.979 90.909 90.808 370.21- 25,047.80 - Page 24 glbase_tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 7/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 200.00 25.000 600.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 30,062.50 7.772 356,748.50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: ,IIIIIII02,611.00 602,611.00 5.022 572,348.50 Program number: _b02,611.00 602,611.00 II 30,262.50 5.022 572,348.50 Department number: Administration MI 602,611.00 602,611.00 II 30,262.50 5.022 572,348.50 Expenditures Subtotal 602,611.00 602,611.00 II 30,262.50 5.022 572,348.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 220,844.49- -67.726 546,930.49 Page 25 glpdatb2 skrolczyk 12:00 08/10/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.l Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (25,083.36) Monthly Total (251,106.99) ** (276,525.00) Budgeted (25,418.01) Remaining 91 % Used Account: 535-49011-000-000 Interest Income 1592 07/31/2020 Bank Interest- July (594.15) (35.64) (629.79) GL Account: 535-49011-000-000 Interest Income Totals: (35.64) (629.79) ** (1,000.00) Budgeted (370.21) Remaining 63 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1552 07/31/2020 TexPool Transfers July TexPool O&M to 16Swift Rev I&S (225,429.48) (25,047.72) (250,477.20) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (250,477.20) ** (275,525.00) Budgeted (25,047.80) Remaining 91 % Used Department Totals: (25,083.36) Monthly Total (251,106.99) ** (276,525.00) Budgeted (25,418.01) Remaining 91 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Account: 535-70045-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 200.00 30,062.50 25 % Used .00 200.00 .00 30,062.50 8 % Used .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (220,844.49) (25,083.36) Monthly Total 326,086.00 Budgeted 546,930.49 Remaining -68 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JULY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 82,779 TOTAL ASSETS 82,779 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 82,779 TOTAL FUND BALANCE 82,779 TOTAL LIABILITIES AND FUND BALANCE 82,779 glbase tbam skrolczyk Trophy Club MUD No.1 12:00 08/10/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 7/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 9.50- 462.70- 462.70 I 1536-49142-000-000 Interfund Tran In -Water Sales 22,896.02- 228,960.20- 228,960.20 I 1536-49143-000-000 Interfund Transfer In -WW Sales 6,839.07- 68,390.70- 68,390.70 I Subtotal: T 'ice, ,44.59- 297,813.60- 297,813.60 Program number: 29,744.59- 297,813.60- 297,813.60 Department number: Revenues 29,744.59- 297,813.60- 297,813.60 I Revenues Subtotal ME 29,744.59- 297,813.60- 297,813.60 glbase_tbam skrolczyk 12:00 08/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-70005-051-000 536-70040-051-000 Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 7/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - Page 27 Subtotal: Program number: 215,034.51 215,034.51 215,034.51 - 215,034.51 - Department number: Administration 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 29,744.59- 82,779.09- 82,779.09 ******* End of Report ********* glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 1592 07/31/2020 Bank Interest- July (453.20) (9.50) (462.70) GL Account: 536-49011-000-000 erest Income .00 Budgeted 462.70 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- W&WW SYS (206,064.18) (22,896.02) (228,960.20) GL Account erfund Tran In -Water Sales Totals: (22,896.02) .00 Budgeted 228,960.20 Remaining Interfund Transfer In -WW Sales 1552 07/31/2020 TexPool Transfers July TexPool O&M to I&S- W&WW SYS 0 % Ueed (61,551.63) (6,839.07) (68,390.70) GL Account: 536-49143- rfund Transfer In -WW Sales Totals: .00 Budgeted 68,390.70 Remaining 0 % Ueed Department Totals: (297,813.60) ** (29,744.59) Monthly Total .00 Budgeted 297,813.60 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 12:00 08/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 7/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Rev Bond Paying Agent Fee Account: 536-70005-051-000 Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 214,892.43 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (214,892.43) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 5 Used .00 Monthly Total .00 Budgeted (29,744.59) Monthly Total .00 Budgeted .00 142.08 .00 214,892.43 215,034.51 ** (215,034.51) Remaining 0 5 Used (82,779.09) 82,779.09 Remaining 0 % Used ******* End of Report ********* (2,641,735.14) **a* (427,945.94) Monthly Total (209,104.00) Budgeted 2,432,631.14 Remaining 0000099990