Loading...
HomeMy WebLinkAbout2020-02 Combined Financials February 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,057,493 PREPAID EXPENSES 11,486 ADVALOREM PROPERTY TAXES RECEIVABLE 62,340 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,131,319 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 62,346 TOTAL LIABILITIES 62,346 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 465,205 TOTAL FUND BALANCE 1,068,973 TOTAL LIABILITIES AND FUND BALANCE 1,131,319 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P51 Program number: Department number: Fire Revenues Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- MEMII 1,214,230.00- 1,214,230.00- 112,348.95- 1,196,917.88- 1,399.74- 2,421.97- 1,184.58- 2,832.30- 98.574 114 114 17,312.12- 2,421.97 2,832.30 12,057.85- 12,057.85- 12,057.85- 12,057.85 - Page glbase_tbam skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-60030-045-000 122-60055-045-000 122-60337-045-000 11111Wtotal: 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases (Subtotal: Program number: Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Period Ending: 2/2020 Adopted Amended Total Budget Budget Encumb. 218,004.00 218,004.00 21,000.00 21,000.00 718,657.00 718,657.00 957,661.00 957,661.00 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 1,214,230.00 1,214,230.00 1,214,230.00 256,569.00 1,214,230.00 1,214,230.00 1,214,230.00 Current Month 218,004.00 1,640.88 59,888.08 279,532.96 279,532.96 279,532.96 279,532.96 164,599.69 Program: YTD Total 218,004.00 8,204.40 299,440.40 525,648.80 2,750.00 11,958.24 81,420.00 115,190.36 211,318. 736,967.40 736,967.40 736,967.40 465,204.75- % of Budget 100.000 39.069 41.667 54.889 5.729 Remaining Budget 12,795.60 419,216.60 432,012.20 45,250.00 11,958.24 - 100.000 90.595 11,958.64 82.363 45,250.40 60.694 477,262.60 60.694 477,262. 60.694 477,262. 465,204.7 Page 2 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 881 02/19/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 886 02/28/2020 property taxes Account: 122-40010-000-000 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 880 02/18/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/MUD Fire Property Taxes/MUD Fir (1,214,230.00) Budgeted Account: Account: 122-40020-000-0 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes (1,084,568.93) (17,312.12) Remaining Property Taxes/Fire-Delinquent Property Taxes/Fire-Delinquent Total= .00 Budgeted 2,421.97 Remaining Property Taxes/Fire P&2 99 (1,022.23) (1,647.72) 0 Used Used (17,604.47) (1,102,173.40) (14,414.19) (1,116,587.59) (16,288.12) (1,132,875.71) (13,003.35) (1,145,879.06) (40,269.70) (1,186,148.76) (255.96) (1,186,404.72) (16.89) (1,186,421.61) (.07) (1,186,421.68) (603.61) (1,187,025.29) (270.02) (1,187,295.31) (.03) (1,187,295.34) (319.78) (1,187,615.12) (868.20) (1,188,483.32) (2,688.22) (1,191,171.54) (474.02) (1,191,645.56) (412.69) (1,192,058.25) (2,022.18) (1,194,080.43) (2,837.45) (1,196,917.88) (91.49) (1,113.72) (6.07) (1,119.79) (1,279.39) (2,399.18) (.01) (2,399.19) .01 (2,399.18) (10.04) (2,409.22) (12.75) (2,421.97) (24.33) (1,672.05) (1.69) (1,673.74) (9.26) (1,683.00) (283.02) (1,966.02) (135.72) (2,101.74) Page Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 876 02/10/2020 property taxes 877 02/11/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account: 122-40020-000-000 Department Totals: Property Taxes/Fire P&I Totals: .00 Budgeted 2,832.30 Remaining (114,933.27) Monthly Total (1,647.72) (17.91) (2,119.65) GL (1.18) (2,120.83) GL (42.26) (2,163.09) GL (.67) (2,163.76) GL (22.39) (2,186.15) GL (60.78) (2,246.93) GL (188.15) (2,435.08) GL (28.47) (2,463.55) GL (31.10) (2,494.65) GL (147.82) (2,642.47) GL (189.83) (2,832.30) GL (1,184.58) (2,832.30) ** 0 % Used (1,202,172.15) ** (1,214,230.00) Budgeted (12,057.85) Remaining 99 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 3 Account: 122-60030-045- Rent And/Or U� 799 02/21/2020 Fire Rent Transfer 2020 Ac Rent And/Or Usage 218,004.00 Budgeted Totals: .00 Remaining 218,004.00 218,004.00 100 % Ueed GL Account: 122-60055-045-000 Insurance 70 02/01/2020 Insurance/Wrk Comp Expense Feb 6,563.52 1,640.88 8,204.40 GL Account 727 02/06/2020 February A/P Account: 122-60337-045-0 Account: 122-69005-045-000 Account: 122-69005-045-000 Account: 122-69009-045-000 Account: 122-69009-045-000 21,000.00 Budgeted 12,795.60 Remaining sfer to Town/Fire Budg Fire Admin February ^Pfansfer to 718,657.00 Budgeted Capital Outlays Capital Outlays 48,000.00 Budgeted 419,216.60 39 % Ueed 239,552.32 Remaining 45,250.00 Remaining Short Term Debt -Interest Totals: .00 Budgeted (11,958.24) Remaining 59,888.08 42 % Ueed 2,750.00 6 % Ueed 11,958.24 0 % Used 299,440.40 .00 2,750.00 .00 11,958.24 TOWN OF TROPHY CLUB 6195 AP Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 1 81,420.00 Budgeted .00 Remaining 81,420.00 100 % Used .00 81,420.00 Account: 122-69305-045-000 Capital Leases glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 115,190.36 .00 115,190.36 11,958.64 Remaining 91 % Used Department 45 Totals: 736,967.40 ++ 279,532.96 Monthly Total 1,214,230.00 Budgeted 477,262.60 Remaining 61 % Used Fund 122 Totals: (465,204.75) 164,599.69 Monthly Total .00 Budgeted 465,204.75 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET FEBRUARY 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,578,751 2,578,751 CASH IN BANK -SAVINGS -CASH RESERVE 1,601,459 1,601,459 INVESTMENTS-TEXPOOL 3,868,049 919,266 4,787,315 PREPAID EXPENSES 66,394 66,394 ADVALOREM PROPERTY TAXES RECEIVABLE 6,858 6,858 UTILITY AND OTHER ACCOUNTS RECEIVABLE 788,993 788,993 TOTAL ASSETS 8,911,105 919,266 9,830,371 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,858 6,858 ACCOUNTS AND OTHER PAYABLES 337,536 337,536 CUSTOMER DEPOSITS 318,975 318,975 TOTAL LIABILITIES 663,369 663,369 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 (153,648) (153,648) TOTAL FUND BALANCE 8,247,736 919,266 9,167,002 TOTAL LIABILITIES AND FUND BALANCE 8,911,105 919,266 9,830,371 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 12,472.09- 129.30- 121.30- 132,872.45- 246.29- 305.45- 98.518 82.097 101.817 1,998.55- 53.71- 5.45 164,253.00- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 282,378.00- 1,805,515.03- 27.834 4,681,107.97- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 255,789.09- 1,251,049.59- 35.705 2,252,835.41- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 10,829.62- 45,896.48- 40.758 66,711.52- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 2,050.00- 8,800.00- 58.086 6,350.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 100.00- 2,250.00- 300.000 1,500.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 300.00- 1,350.00- 54.000 1,150.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 15,068.00- 30.136 34,932.00- 10,171,516.00- 10,171,516.00- 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 ENSubtotaS, Program number: Department number: Revenues Revenues Subtotal 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 0- 10,645,077.00- 0- 10,645,077.00- 1:110- 10,645,077.00- 6.71- 9,871.98- 2,357.62- 583.33- 610.00- 188.22- 3,129,929.10-.772 7,041,586 13,611.15- 577,780.55- 3 577,780.5 577,780.55- 51,811.06- 5,894.05- 2,916.65- 43.176 41.666 41.666 7,730.28- 60.912 8,341.76- 119.168 68,188.94- 8,251.95- 4,083.35- 13,000.00- 4,960.72- 1,341.76 8,188.94-8,251.95-4,083.35-13,000.00- 4,960.72- 1,341.76 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 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 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 27,843.01 132,263.00 1,214.08 8,861.76 5,082.50 425.00 2,075.00 2,730.05 14,802.58 5,225.04 24,378.62 316.63 1,481.48 48.18 236.11 328.89 1,552.66 1,813.45 9,090.21 424.11 2,125.91 18.49 63.65 771.49 3,857.45 37.761 52.128 129.656 38.426 42.459 28.910 31.354 30.784 49.574 38.934 38.929 5.894 32.552 218,004.00 8,138.24 1,162.50- 3,325.00 20,060.42 59,947.38 3,243.52 530.89 1,579.34 14,257.79 3,335.09 1,016.35 7,992.55 400.00 300.00 FSubtotal: ' 546,839.00 546,839.00 41,158.42 205,870.93 340,968.07 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 2,100.46 23,276.50 23.277 76,723.50 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 286.02 727.67 14.553 4,272.33 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 920.37 26.296 2,579.63 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 350.00 35.000 650.00 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 250.00 1,597.70 21.303 5,902.30 Page 4 140,000.00 140,000.00 2,723.98 26'2.24 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 TCEQ 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 424.30 2,472.95 6,824.77 46,151.60 790.00 1,196.00 2,685.69 16,942.84 103,065.44 572,020.73 294.00 756.00 116,631.80 308,406.76 4,600.00 23,000.00 49.459 2,527.05 36.722 79,525.40 1,000.00 500.00 16.106 6,230.00 400.00 2,845.00 1,500.00 26.893 46,057.16 21.071 2,142,689.27 200.00 25.200 2,244.00 14,750.00 58.479 218,974.24 41.672 32,193.00 180,000.00 I: . glbase_tbam skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Description Furniture/Equipment < $5000 Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Period Ending: 2/2020 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 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 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 3,618.00 5,504,929.00 5, 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 945.56 4,514.91 2,917.33 1,391.35 9,016.50 765.00 16,869.78 36,900.00 10,920.00 176,710.03 30,512.00 1,840.00 75,000.00 102,077.11 30.099 56.211 45.083 24.100 42.414 25.802 100.000 56.948 100.000 85.064 10,485.09 2,272.67 10,983.50 1,200.00 1,000.00 53,130.22 50,100.00 ,1 508,164.97 1,391.00 17,922.89 42 /,478.86 57 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program: 1 Lab Analysis for PID 135-55135-010-001 Lab Analysis for PID Subtotal: Program number: 1 Lab Analysis for PU1111111111 Department number: Water 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 5,506,929.00 5,506,929.00 80.00 547.70 547.70 80.00 547.70 293,300.31 1,661,157.13 80.00 27.385 1,452.30 1,452.30 27.385 1,452.30 30.165 3,845,771.87 27.385 Page 6 glbase_tbam skrolczyk 11:28 03/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: 2/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 Meant. 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 31,660.78 150,837.93 34.142 290,961.07 1,700.03 9,765.30 29.592 23,234.70 6,872.50 85.532 1,162.50 650.00 3,200.00 35.556 5,800.00 3,149.40 17,332.99 38.069 28,198.01 7,738.24 33,790.07 32.225 71,067.93 446.90 1,985.42 34.131 3,831.58 69.74 320.43 33.801 627.57 396.07 1,786.43 39.698 2,713.57 1,963.61 9,915.32 32.516 20,578.68 459.24 2,318.90 32.514 4,813.10 24.56 59.12 4.692 1,200.88 1,110.20 5,551.00 36.109 9,822.00 38.00 38.00 9.500 362.00 300.00 30,000.00 3,000.00 20.000 12,000.00 6,728.71 35,443.88 40.277 52,556.12 2,299.33 17,677.78 176.778 7,677.78- 10,000.00 60.00 742.98 18.575 3,257.02 53.99 1,986.94 24.837 6,013.06 54.99 559.67 18.656 2,440.33 87.50 350.00 23.333 1,150.00 5,692.84 38,479.62 38.480 61,520.38 2,332.20 15,048.65 37.622 24,951.35 Page 7 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 408.87 2,679.40 53.588 2,320.60 12,969.80 60,843.27 38.011 99,223.73 200.00 111.00 37.000 189.00 521.00 2,431.85 48.734 2,558.15 109.14 10.914 890.86 360.84 23.355 1,184.16 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 584.94 11.699 4,415.06 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Subtotal: 1,310,669.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 10,414.81 81,777.91 5,750.00 112,427.33 794.60 2,856.60 22.71 14,000.00 52,074.05 45.455 62,488.95 326,820.11 48.499 347,046.89 28,750.00 22.966 96,437.00 180,000.00 190.00 9.500 1,810.00 Page 8 485,042.62 825,626.38 3,755.00 30.040 8,745.00 3,507.93 63.839 1,987.07 12,724.87 63.624 7,275.13 4,994.00 28.537 12,506.00 1,200.00 1,111.63 92.636 88.37 10,837.36 54.187 9,162.64 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 14,155.80 14,155.80 196,973.37 • 196,973.37 1, 160,027.89 30.165 370,472.11 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 395,155.34 1,922,630.00 1,922,630. glbase_tbam skrolczyk 11:28 03/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: 2/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 9.95 % of Remaining Budget Budget 33.167 20.05 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 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 675.00 176.28 90.000 13.560 150.00 75.00 1,123.72 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 851.28 6.449 12,348.72 Program number: 13,230.00 13,230.00 1.99 861.23 6.510 12,368.77 L Department number: Board of Directors 13,230.00 13,230.00 1.99 861.23 6.510 12,368.77 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 30,149.14 149,265.50 23.757 479,032.50 135-50010-030-000 Overtime 2,000.00 2,000.00 3.96 20.53 1.027 1,979.47 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 2,792.20 15,524.98 26.514 43,029.02 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 29,157.97 23.440 95,236.03 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 1,618.70 25.042 4,845.30 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 249.67 24.123 785.33 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 343.91 1,635.45 36.343 2,864.55 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,723.34 8,790.85 22.417 30,424.15 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 403.03 2,055.95 22.418 7,115.05 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 16.50 46.66 3.240 1,393.34 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 524.10 29.527 1,250.90 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 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanin7 Services Professional Outside Services Utility Billing Contract 134,681.00 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 1,568.43 126,842.65 94.180 7,838.35 240.00- 54,584.49 40.433 80,415.51 1,165.00 7.767 13,835.00 531.00 531.00 5.310 9,469.00 869.06 3,476.24 34.762 6,523.76 65,600.00 2,474.81 27.498 6,525.19 135-60005-030-000 Telephone 23,680.00 23,680.00 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 135-60025-030-000 Water 1,500.00 1,500.00 135-60035-030-000 Postage 30,000.00 30,000.00 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 135-60110-030-000 Physicals/Testing 200.00 200.00 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 1,273.96 237.75 718.11 142.72 5,403.21 6,998.39 7,399.55 31.248 1,189.56 29.739 2,000.54 29.082 383.89 25.593 6,806.80 22.689 31,422.04 46.899 31,430.09 37.417 125.00 12.500 119.00 4,285.55 71.426 61.37 15.343 3,809.69 63.495 10.50 1,163.21 16.981 695.14 19.609 3,333.49 95.03 138.04 16,280.45 2,810.44 4,878.46 1,116.11 23,193.20 35,577.96 1,500.00 52,569.91 875.00 1,714.45 338.63 2,190.31 5,686.79 2,849.86 200.00 138.04- 2,500.00 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund Account Description 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 135-65010-030-000 Uniforms 135-65055-030-000 Hardware 135-65085-030-000 Office Supplies 135-65090-030-000 Printer Supplies & Maintenance 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing Trophy Club MUD No.1 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 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 135-69005-030-000 Capital Outlays 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 Program number: Department number: Administration 195,000.00 4,000.00 ,000.00 712.00 .712.00 24.00 120.00 9.317 18,356.16 91,030.47 135.77 302.18 47.39 233.81 3,235.24 2,002.24 2,698.80 47.39 1,271.47 12.215 33.371 67.470 .024 31.787 50 1 1,168.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 3,997.76 3,500.00 1,301.20 2,500.00 194,952.61 2,728.53 1,273,176.24 5041 1,273,176.24 Page 11 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 2/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 10,666.00 56,702.39 27,713.27 5,178.56 3,756.00 42.002 81.992 44.032 93.900 78,297.61 6,086.73 6,582.44 244.00 Page 12 ir Subtotal: ' 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Program number: 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Department number: Non Departmental 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Expenditures Subtotal 10,638,853.00 10,638,853.00 565,029.57 3,493,695.34 32.839 7,145,157.66 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 12,750.98- 153,648.25 -2,468.642 159,872.25- glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 Page 13 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000- 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account: TrSnrbT6n=8 Account: 135-40002-000-00 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes Account: 135 -40002 -000 - Account: 135-40015-000-00' 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 879 02/13/2020 property taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes Property Taxes Totals: (134,871.00) Budgeted Property Taxes/Delinquent (120,400.36) (1,998.55) Remaining 99 % Used (116.99) (1,954.31) (122,354.67) (1,600.15) (123,954.82) (1,808.18) (125,763.00) (1,443.53) (127,206.53) (4,470.43) (131,676.96) (28.41) (131,705.37) (1.87) (131,707.24) (.01) (131,707.25) (67.01) (131,774.26) (29.97) (131,804.23) (35.50) (131,839.73) (96.38) (131,936.11) (298.43) (132,234.54) (52.62) (132,287.16) (45.81) (132,332.97) (224.49) (132,557.46) (314.99) (132,872.45) (9.63) (126.62) (.69) (127.31) (116.39) (243.70) (1.14) (244.84) (1.45) (246.29) Page 5 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Property Taxes/Delinquent Totals: (300.00) Budgeted Property Taxes/P & I (53.71) Remaining 82 % Used (184.15) (2.73) (186.88) (.19) (187.07) (1.03) (188.10) (21.16) (209.26) (15.06) (224.32) (1.99) (226.31) (.14) (226.45) (4.69) (231.14) GL GL GL GL GL GL GL GL glpdatb2 ekrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 880 02/18/2020 property 882 02/20/2020 property 883 02/21/2020 property 884 02/24/2020 property 885 02/25/2020 property 886 02/26/2020 property 887 02/27/2020 property 888 02/28/2020 property Account: 135-40015-000-000 Account: 135-40025-000-000 Account: 135-40025-000-000 taxes taxes taxes taxes taxes taxes taxes taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Beginning Balance Description/Comment Property Taxes/P & I (300.00) Budgeted ■ PID Surcharges JIIPID Surcharges (164,253.00) Budgeted Account: 135-47000-000-000 718 02/05/2020 UB 02/05/2020 Bill adjustment 834 02/28/2020 UB 03/02/2020 Billing 5.45 Remaining (164,253.00) Remaining UB20200205-20200205 User: UB20200228-20200228 User: (184.15) Program: Transaction Detail (.08) (2.48) (6.75) (20.88) (3.16) (3.47) (16.42) (21.07) 102 % Used (1,523,137.03) .00 0 % Used Transaction Vendor Name Detail (SUBTOTAL) (231.22) (233.70) (240.45) (261.33) (264.49) (267.96) (284.38) (305.45) .00 153.94 (1,522,983.09) (282,531.94) (1,805,515.03) Page Check Source Number GL GL GL GL GL GL GL GL UB UB Account: 135-47000-000-000 (282,378.00) (6,486,623.00) Budgeted (4,681,107.97) Remaining Account: 135-47005-000-00 718 02/05/2020 UB 02/05/2020 Bill adjustment UB20200205-20200205 User: 834 02/28/2020 UB 03/02/2020 Billing UB20200228-20200228 User: Account: 135-47 Account: 135-47025-000-000 759 02/13/2020 UB 797 02/21/2020 UB 810 02/25/2020 UB 821 02/27/2020 UB Ace (3,503,885.00) Penalties 02/13/2020 Penalty removal 02/21/2020 Penalties 02/25/2020 Penalty removal 02/27/2020 Penalty removal Budgeted 28 % Used (995,260.50) Totals: (2,252,835.41) Remaining UB20200213-20200213 User: UB20200221-20200221 User: UB20200225-20200225 User: UB20200227-20200227 User: 36 % Ueed (35,066.86) Penalties (112,608.00) Budgeted (66,711.52) Remaining Totals: 41 % Used 44.80 (995,215.70) (255,833.89) (1,251,049.59) 73.68 (11,008.51) 41.49 63.72 (1,251,049.59) ++ (34,993.18) (46,001.69) (45,960.20) (45,896.48) UB UB UB UB UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-47030-000- Service Cha 743 02/04/2020 UB 02/04/2020 NSF Check UB20200204-20200204 User: (6,750.00) (25.00) (6,775.00) UB 716 02/05/2020 UB 02/05/2020 Disconnect Fees UB20200205-20200205 User: (1,900.00) (8,675.00) UB 765 02/10/2020 UB 02/10/2020 NSF check UB20200210-20200210 User: (25.00) (8,700.00) UB 794 02/19/2020 UB 02/19/2020 NSF Check UB20200219-20200219 User: (25.00) (8,725.00) UB 793 02/20/2020 UB 02/20/2020 NSF Check UB20200220-20200220 User: (50.00) (8,775.00) UB 844 02/24/2020 UB 02/24/2020 NSF Check UB20200224-20200224 User: (25.00) (8,800.00) UB Account: 135-47030-000-00' Service Charges (15,150.00) Budgeted Account: 135-47035-000-000 848 02/03/2020 Permits -2 Sadie Court 849 02/13/2020 Permits -222 Phoenix Plumbing Inspections 2 Sadie Court 222 Phoenix Drive Account: 135-47035-000-000 Plumbing Inspections (750.00) Budgeted Account: 135-47045-000-002 Sewer Inspections 848 02/03/2020 Permits -2 Sadie Court 2 Sadie Court 849 02/13/2020 Permits -222 Phoenix 222 Phoenix Drive Account: 135-47045-000-000 Sewer Inspections (2,500.00) Budgeted Totals: (6,350.00) Remaining 58 5 Used (2,150.00) 1,500.00 Remaining 300 % Used (50.00) (2,200.00) Drees CR (50.00) (2,250.00) Dazzling Homes CR (10 (1,150.00) Remaining (1,050.00) 54 % Used (150.00) (1,200.00) Drees (150.00) (1,350.00) Dazzling Homes CR CR Account: 135-47070-000-00: uea erg Account: 135-47070-000-000 (15,068.00) TCCC Effluent Charges (50,000.00) Budgeted (34,932.00) Remaining 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February 30 % Used (41,939.08) .00 (1,117.33) (1,008.52) (7,746.13) (15,068.00) (43,056.41) (44,064.93) (51,811.06) GL GL GL (120,000.00) Budgeted (68,188.94) Remaining 43 % Used glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 8 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCO Cell Tower Revenue 859 02/28/2020 Cell Tower Rev AT&T February 860 02/28/2020 Cell Tower Rev AT&T March Account :-'19nr--0'15.1Tower Revenue Totals: (14,146.00) Budgeted (3,536.43) (1,178.81) (4,715.24) GL (1,178.81) (5,894.05) GL (8,251.95) Remaining 42 % Used Account: 135-49018-000-000 Building Rent In 896 02/29/2020 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: (2,333.32) Account: 135-49018-000-000 •Mil4ing Rent Income (7,000.00) Budgeted Account: 135-49026-000-000 (13,000.00) Account: 135-49075-000-00 848 02/03/2020 Permits -2 Sadie Court 849 02/13/2020 Permits -222 Phoenix Account: 135-49075-000-000 Budgeted (4,083.35) Remaining 42 % Used als: (13,000.00) Remaining 0 % Used Oversize Meter Reimbu 2 Sadie Court 222 Phoenix Drive Oversize Meter R (12,691.00) Budgeted (4,960.72) Remaining Account: 135-49900-000-000 1.91ffrerrriMus Income 851 02/18/2020 customer dep refund UB20200218-20200218 User: 834 02/28/2020 UB 03/02/2020 Billing UB20200228-20200228 User: Account: 135-49900-000-00u Department Totals: Miscellaneous income 11111 Totals: (7,000.00) Budgeted 1,341.76 Remaining (7,120.28) 61 % Ueed (8,153.54) 119 % Used (583.33) (2,916.65) (583.33) (2,916.65) ** .00 .00 (353.00) (257.00) (7,473.28) Drees (7,730.28) Dazzling Homes (.70) (8,154.24) (187.52) (8,341.76) (3,340,047.09) ** (577,780.55) Monthly Total (10,645,077.00) Budgeted (7,305,029.91) Remaining 31 % Used CR CR UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages 104,419.99 12,900.75 117,320.74 PR 14,942.26 132,263.00 PR Account: 135-50005-010-000 Salaries & Wages Totals: 27,843.01 132,263.00 ** 350,267.00 Budgeted 218,004.00 Remaining 38 % Used Account: 135-50010-010-000 Overtime 675 02/07/2020 MUD Payroll 02/07/2020 Overtime 7,647.68 516.39 8,164.07 PR 782 02/21/2020 MUD Payroll 02/21/2020 Overtime 697.69 8,861.76 PR Account: 135-50010-010-000 Overtime Totals: 1,214.08 8,861.76 ** 17,000.00 Budgeted 8,138.24 Remaining 52 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 782 02/21/2020 MUD Payroll 02/21/2020 Certification 1,650.00 425.00 2,075.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 2,075.00 ** 5,400.00 Budgeted 3,325.00 Remaining 38 % Used Account: 135-50020-010-000 Retirement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 12,072.53 1,242.44 13,314.97 PR 1,487.61 14,802.58 PR Account: 135-50020-010-000 Retirement Totals: 2,730.05 14,802.58 ** 34,863.00 Budgeted 20,060.42 Remaining 42 % Used Account: 135-50026-010-000 Medical Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance 19,153.58 2,612.55 21,766.13 PR 2,612.49 24,378.62 PR Account: 135-50026-010-000 Medical Insurance Totals: Immo 5,225.04 24,378.62 ** 84,326.00 Budgeted 59,947.38 Remaining 29 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOunt: 135-50027-010- ental IneuI 675 02/07/2020 MUD Payroll 02/07/2020 Dental Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Dental Insurance 1,164.85 158.32 1,323.17 PR 158.31 1,481.48 PR Account: - Dental Insuranc Totals: mEllir 4,725.00 Budgeted 3,243.52 Remaining 31 % Used Account: 135-50028-010-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: Vision Insurance Vision Insurance Vision Insurance 135-50028-01 Vision Insurance 767.00 Budgeted 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February AMP Life Insurance & Other Employee Benefits Employee LTD & STD caf 125 plan 187.93 24.10 212.03 PR 24.08 236.11 PR Totals: 530.89 Remaining 31 % Used 1,223.77 176.88 1,400.65 Humana Inc 132.01 1,532.66 METLIFE GROUP BENEFITS 20.00 1,552.66 BenefitMall 6136 AP 6145 AP 6214 AP Account: 135-50029-010-000 Life Insurance & Other Totals: ,552.66 •+ Account: 135-50030-010-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-500 Account: 3,132.00 Budgeted 1,579.34 Remaining 50 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social S- 23,348.00 Budgeted 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Medicare Taxes Medicare Taxes Medicare Taxes Account: Medicare Tax 5,461.00 Budgeted Account: 135-50- 675 02/07/2020 MUD Payroll 02/07/2020 14,257.79 Remaining Unemployment Taxes 3,335.09 Remaining 7,276.76 1,701.80 45.16 39 Used 822.02 991.43 8,098.78 9,090.21 192.26 1,894.06 231.85 2,125.91 39 % Used 10.09 55.25 PR PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 782 02/21/2020 MUD Payroll 02/21/2020 Unemployment Taxes Unemployment Taxes Totals: 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 70 02/01/2020 Insurance/Wrk Comp Expense Feb Account: 135-50045-010-00 workman's Compensation 11,850.00 Budgeted Account: 135-50060-010-000 Account: 135-50060-010-000 Pre-emp Physicals/Testing 45.16 8.40 1,016.35 Remaining 6 % Used 18 3,085.96 771.49 7,992.55 Remaining 33 % Used Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining Account: 135-50070-010-000 Employee Relations Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 ■ 63.65 PR 3,857.45 GL .00 .00 0 % Used 300.00 Remaining 0 % Used Engineering Totals: 20,000.00 Budgeted .00 .00 .00 .00 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 869 02/26/2020 PCards 1/28/20-2/26/20 grass 21,176.04 15.50 21,191.54 TEX-TURF PC 869 02/26/2020 PCards 1/28/20-2/26/20 insulation, ice melt, tape,etc 234.10 21,425.64 THE HOME DEPOT 6581 PC 869 02/26/2020 PCards 1/28/20-2/26/20 pvc cap 8.16 21,433.80 ROANOKE WINNELSON CO PC 869 02/26/2020 PCards 1/28/20-2/26/20 cutoff blade 13.94 21,447.74 THE HOME DEPOT #6581 PC 822 02/27/2020 February A?P repairs 1,175.00 22,622.74 DHS AUTOMATION, INC 6219 AP 822 02/27/2020 February A?P repiars 611.76 23,234.50 DHS AUTOMATION, INC 6219 AP 890 02/28/2020 February A/P Tank rental 42.00 23,276.50 ALLIED WELDING SUPPLY, INC AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 2/2020 JE Detail Description/Comment Maintenance & Repairs 100,000.00 Budgeted Page 12 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 76,723.50 Remaining 23 Used Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55085-010-000 Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135 Vehicle Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 oil change 869 02/26/2020 PCards 1/28/20-2/26/20 helicoil 869 02/26/2020 PCards 1/28/20-2/26/20 truck bed mat 869 02/26/2020 PCards 1/28/20-2/26/20 document holder for visor Account: 135 Vehicle Maintenancals: 5,000.00 Budgeted 4,272.33 Remaining .00 0 % Used .00 441.65 72.17 513.82 KWIK KAR LUBE & TUNE 0 PC 28.86 542.68 ROANOKE AUTO SUPPLY LT PC 124.99 667.67 TRACTOR SUPPLY COMPANY PC 60.00 727.67 AMZN MKTP US*B79M75A53 PC 15 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-001 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 2,579.63 Remaining Cleaning Services 822 02/27/2020 February AMP janitorial svc-january 920.37 A .00 26 % Used 920.37 262.50 87.50 350.00 MEMBER'S BUILDING MAINTENANCE 6230 AP Account: Cleaning Service Totals: 1,000.00 Budgeted 650.00 Remaining 35 % Used Account: 135-55135-010-000 Lab Analysis 747 02/11/2020 February A?P water samples 1,347.70 250.00 1,597.70 TARRANT CTY PUBLIC HEALTH LAB 6192 AP Account: 135-55135-010-000 Lab Analysi Tot 7,500.00 Budgeted 5,902.30 Remaining 21 Used Account: 135-60010-010-000 Commu!!ications/Mobiles glpdatb2 ekrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 13 747 02/11/2020 February A?P Cell phones -February Account: 135-60010-010-000 Account: 135-60020-010-000 822 02/27/2020 February A?P Account: 135-60020-010-000 2,048.65 424.30 Communications/Mobiles Totals: 5,000.00 Budgeted 2,527.05 Remaining 49 % Used Electricity Electricity 1/10-2/10 Electric 125,677.00 Budgeted 79,525.40 Remaining 2,472.95 VERIZON WIRELESS 6198 AP 42 2.472.95 ** 39,326.83 6,824.77 37 % Used 46,151.60 HUDSON ENERGY SERVICES, LLC 6224 AP Account: 135-60066-010-000 Publications/Books/Subscrip Account: 135-60066-010-000 Publications/Books/Subscripts Tota 1,000.00 Budgeted 1,000.00 Remaining .00 0 % Used .00 Account: 135-60070-010-00 Dues & Memberships .00 .00 Accoun Dues & Memberships in Totals: 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 869 02/26/2020 PCards 1/28/20-2/26/20 Texas Water Conference 406.00 790.00 1,196.00 TEXAS WATER Account: 135-60080-010-00 ools & Traini Totals: 7,426.00 Budgeted 6,230.00 Remaining 16 % Ueed Account: 135-60090-010-000 .00 .00 Safety Program Account: 135-60090-010-000 Safety - 400.00 Budgeted 400.00 Remaining 0 % Used PC Account: 135-60100-010-000 0 0 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Accdin Account: 135-60105-010-000 Account: 135-60135-010-000 747 02/11/2020 February A?P Account: 135-60135-010-000 Account: 135-60150-010-000 822 02/27/2020 February A?P Account: 135-60150-010-000 Account: 135-60245-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 2/2020 JE Detail Description/Comment Travel & per diem Tota 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted TCEQ Fees & Permits well water Page 14 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 2,845.00 Remaining 0 % Used .00 .00 1,500.00 Remaining 0 % Used 14,257.15 2,685.69 16,942.84 North Texas Groundwater TCEQ Fees & Permits To a e• 63,000.00 Budgeted 46,057.16 Remaining 27 % Used Wholesale Water wholesale water 468,955.29 103,065.44 572,020.73 CITY OF FORT WORTH Wholesale Water 2,714,710.00 Budgeted 2,142,689.27 Remaining Miscellaneous Expenses Account: 135-60245-010-000 Miscellaneous Expenses 200.00 Budgeted 200.00 Remaining Account: 135-60280-010-000 Property Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 top soil, sand Account: 135 Property Maintenance Totals: 3,000.00 Budgeted 21 % Used .00 .00 .00 .00 ** 0 % Used 462.00 294.00 756.00 DENTON SAND & GRAVEL, 2,244.00 Remaining 25 % Used Lawn Equipment & Maintenance 294.00 756.00 ** .00 .00 6187 AP 6216 AP PC glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 2/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 14,750.00 Remaining 0 % Used Account: Interfund Transfer Out -Rev I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to 16Swift Rev I&S 191,774.96 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S Account: 135M5332-01011 25,047.72 216,822.68 91,584.08 308,406.76 GL GL Interfund Transfer Out -Rev I&S To 527,381.00 Budgeted 218,974.24 Remaining Account: 135-60333-010-000 Iaterfund 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr 58 % Used 18,400.00 4,600.00 23,000.00 GL r Out -Reserve Tota Account: 135-60334-010-000 Account: 135-60334-010-000 55,193.00 Budgeted Interfund Transfer Out 32,193.00 Remaining Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining 42 % Used 0 % Used .00 .00 Account: 135-60360-010-000 ' Furniture/Equipment < $5000 Account: 135-60360-010-000 Account: 135-65005-010-000 811 02/24/2020 Fuel 561.72 .00 561.72 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 1,938.28 Remaining 22 % Ueed AIL AL1 & Lube Fuel -FEB 3,569.35 945.56 4,514.91 US Bank Voyager Fleet Systeme 6236 AP Account: 135-65005-010-000 15,000.00 Budgeted 10,485.09 Remaining 30 % Used Account: 135-65010-010-000 2,917.33 .00 2,917.33 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 2/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 16 Check Source Number Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** MIL 5,190.00 Budgeted 2,272.67 Remaining 56 % Used Account: 135-65030-010-000 Chemicals 822 02/27/2020 February A?P 822 02/27/2020 February A?P ammonia chlorine 7,625.15 721.26 670.09 8,346.41 9,016.50 Valley Solvent Company, DPC INDUSTRIES, INC INC 6237 6220 AP AP Account: 135-65030-010-000 Chemicals Totals: 1,391.35 9,016.50 ** 20,000.00 Budgeted 10,983.50 Remaining 45 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 727 02/06/2020 February A/P meter parts 16,104.78 765.00 16,869.78 ATLAS UTILITY SUPPLY CO. 6174 AP Account: 135-65050-010-000 Meter Expense Totals: 765.00 16,869.78 ** 70,000.00 Budgeted 53,130.22 Remaining 24 % Used Account: 135-65053-010-000 Meter Change Out Program 36,900.00 .00 36,900.00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 36,900.00 ** 87,000.00 Budgeted 50,100.00 Remaining 42 % Used Account: 135-69005-010-000 Capital Outlays 894 02/04/2020 Cashier's Chk Denton Land Purc Res 14-03488-211 Denton Sherif 165,790.03 1,000.00 166,790.03 GL glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Detailed Accounting Trial Balance Page 17 822 02/27/2020 February A?P 822 02/27/2020 February A?P 890 02/28/2020 February A/P Account: 135-69005-01 Account: 135-69008-010-000 Account: 135-69008-010-000 Account: 135-69009-010-000 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 truck decals lights for truck Truck bed for 2020 Dodge 2500 165,790.03 125.00 166,915.03 14-1(016 LTD. 6229 AP 2,245.00 169,160.03 Defender Supply 6218 AP 7,550.00 176,710.03 Fortress Resources, LLC AP Capital Outlays Totals: 684,875.00 Budgeted 508,164.97 Remaining 26 % Used Short Term Debt -Principal Short Term Debt -Principal 30,512.00 Budgeted erm Interest 30,512.00 Totals: .00 Remaining 100 % Used 1,840.00 Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining 57 % Used Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 .00 30,512.00 .00 1,840.00 .00 75,000.00 100 % Ueed Water Tank Inspection Contract 102,077.11 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.89 Remaining 85 % Ueed .00 102,077.11 glpdatb2 skrolczyk 11:28 03/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: 2/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 747 02/11/2020 February A?P water samples 467.70 80.00 547.70 TARRANT CTY PUBLIC HEALTH LAB 6192 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 547.70 ** 2,000.00 Budgeted 1,452.30 Remaining 27 % Used Department 10 Totals: 1,661,157.13 ** 293,300.31 Monthly Total 5,506,929.00 Budgeted 3,845,771.87 Remaining 30 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages 119,177.15 15,801.44 134,978.59 PR 15,859.34 150,837.93 PR Account: 135-50005-020-000 Salaries & Wages Totals: 31,660.78 150,837.93 ** 441,799.00 Budgeted 290,961.07 Remaining 34 % Used Account: 135-50010-020-000 Overtime 675 02/07/2020 MUD Payroll 02/07/2020 Overtime 8,065.27 977.08 9,042.35 PR 782 02/21/2020 MUD Payroll 02/21/2020 Overtime 722.95 9,765.30 PR Account: 135-50010-020-000 Overtime Totals: 1,700.03 9,765.30 ** 33,000.00 Budgeted 23,234.70 Remaining 30 % Used Account: 135-50016-020-000 Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity Totals: .00 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 782 02/21/2020 MUD Payroll 02/21/2020 Certification 2,550.00 650.00 3,200.00 PR Account: 135-50017-020-000 Certification Totals: 650.00 3,200.00 ** 9,000.00 Budgeted 5,800.00 Remaining 36 % Used Account: 135-50020-020-000 Retirement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 14,183.59 1,553.69 15,737.28 PR 1,595.71 17,332.99 PR Account: 135-50020-020-000 Retirement Totals: 3,149.40 17,332.99 ** 45,531.00 Budgeted 28,198.01 Remaining 38 % Used Account: 135-50026-020-000 Medical Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance 26,051.83 3,869.14 29,920.97 PR 3,869.10 33,790.07 PR Account: 135-50026-020-000 Medical Insurance Totals: 7,738.24 33,790.07 ** 104,858.00 Budgeted 71,067.93 Remaining 32 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AOOOUnt: 135-50027020- ental InsuI 675 02/07/2020 MUD Payroll 02/07/2020 Dental Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Dental Insurance Account: -1.1 Dental Insuranc Totals: 5,817.00 Budgeted 3,831.58 Remaining Account: 135-50028-020-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-50028-020-000 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February AMP Vision Insurance Vision Insurance Vision Insurance Vision Insurance 948.00 Budgeted e Insurance & Other Employee Benefits Employee LTD & STD caf 125 plan Account: 135-50029-020-000 Life Insurance & Other 4,500.00 Budgeted Account: 135-50030-020-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 1,538.52 223.47 1,761.99 PR 223.43 1,985.42 PR 250.69 34 % Used 34.87 285.56 PR 34.87 320.43 PR Totals: ' 627.57 Remaining 34 % Used 1,390.36 198.33 1,588.69 Humana Inc 165.74 1,754.43 METLIFE GROUP BENEFITS 32.00 1,786.43 BenefitMall Totals: 2,713.57 Remaining 40 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security T 30,494.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 675 02/07/2020 MUD Payroll 02/07/2020 Medicare Taxes 782 02/21/2020 MUD Payroll 02/21/2020 Medicare Taxes Account: 135-50035-020-000 Medicare Tax 7,132.00 Budgeted 20,578.68 Account: 135-50040-0 675 02/07/2020 MUD Payroll 02/07/2020 Unemployment Taxes Remaining s: 4,813.10 Remaining 7,951.71 1,859.66 33 980.70 982.91 Used 8,932.41 9,915.32 229.36 2,089.02 229.88 2,318.90 33 % Used 6136 AP 6145 AP 6214 AP PR PR PR PR 34.56 16.79 51.35 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JB JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 782 02/21/2020 MUD Payroll 02/21/2020 Unemployment Taxes 34.56 7.77 59.12 PR Unemployment Taxes Totals: 24 1,260.00 Budgeted 1,200.88 Remaining 5 % Used Account: 135-50045-020-00 Workman's Compensation 70 02/01/2020 Insurance/Wrk Comp Expense Feb 4,440.80 1,110.20 5,551.00 Account: 135-50045-020-00 workman's Compensation 15,373.00 Budgeted 9,822.00 Remaining 36 % Used Account: 135-50060-020- Pre-emp Physicals/Testing 771 02/17/2020 February A/P employee drug screen -Frank Iso 38.00 38.00 CARENOW CORPORATE Pre-emp Physicals/Testing 400.00 Budgeted 362.00 Remaining 10 % Used Account: 135-50070-020-000 Employee Relations .00 .00 GL 6201 AP Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 i Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135 771 02/17/2020 February A/P Independent Labor 15,000.00 Budgeted 12,000.00 Remaining e & Repai. pm on digester blowers 3,000.00 28,715.17 .00 3,000.00 20 % Used 605.00 29,320.17 Precision Pump Systems 6210 AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date 771 02/17/2020 771 02/17/2020 869 02/26/2020 869 02/26/2020 869 02/26/2020 822 02/27/2020 822 02/27/2020 822 02/27/2020 890 02/28/2020 JE Description February A/P February A/P PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 February A?P February A?P February A?P February A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2020 JE Detail Beginning Balance Description/Comment sludge pump rotor & stator parts for bar screen pvc cement, primer, pipe,elbow synthetic gear oil, HD Creeper coupling, pvc, drain pipe, saw longo bags for grit rollers for rotary drums pre -wraps for digester blowers change out air scada mbr Maintenance & Repairs 88,000.00 Budgeted 52,556.12 Remaining 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 822 02/27/2020 February A?P 890 02/28/2020 February A/P A' 5-55081-0a Account: 135-55085-020-000 Account: 135-55085-020-000 1 Mainten & Repairs Collections anvil, taperule concrete grade ring refund due to tax charged concrete grade ring/ no tax lopper, mop, bucket, disinfect repiars manhole parts Mainten & Repairs Collections Totals: 10,000.00 Budgeted (7,677.78) Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55090-020-000 Vehicle Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 document holder for visor Account: 135-55090-020-000 Account: 135-55091-020-000 869 02/26/2020 PCards 1/28/20-2/26/20 Vehicle Maintenance 4,000.00 Budgeted 3,257.02 Remaining Collecti Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 28,715.17 2,310.00 31,630.17 Precision Pump Systems 637.87 32,268.04 Huber Technology Inc 33.83 32,301.87 THE HOME DEPOT #6581 719.99 33,021.86 ROANOKE AUTO SUPPLY LT 37.50 33,059.36 THE HOME DEPOT #6581 665.00 33,724.36 Huber Technology Inc 1,120.32 34,844.68 Huber Technology Inc 109.20 34,953.88 Filter Element Store 490.00 35,443.88 DHS AUTOMATION, INC a 88 ** 40 % Used 15,378.45 13.72 15,392.17 THE HOME DEPOT #6581 168.16 15,560.33 FERGUSON ENT 1241 (168.16) 15,392.17 FERGUSON ENT 1241 155.34 15,547.51 FERGUSON ENT 1241 69.17 15,616.68 THE HOME DEPOT #6581 1,405.00 17,021.68 DHS AUTOMATION, INC 656.10 17,677.78 Core & Main LP 177 % Used 682.98 0 % Used .00 60.00 19 % Used • prem AW 46 HYD Fluid 5gallons 1,932.95 53.99 .00 742.98 AMZN MKTP US•B79M75A53 1,986.94 ROANOKE AUTO SUPPLY LT Page 22 Check Source Number 6210 AP 6206 AP PC PC PC 6222 AP 6222 AP 6221 AP AP PC PC PC PC PC 6219 AP AP PC PC glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 23 Check Source Number 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 822 02/27/2020 February A?P 822 02/27/2020 February A?P 828 02/28/2020 February A/P 828 02/28/2020 February A/P lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting 12,716.45 341.55 13,058.00 OXIDOR LABORATORIES LLC 241.50 13,299.50 OXIDOR LABORATORIES LLC 341.55 13,641.05 OXIDOR LABORATORIES LLC 241.50 13,882.55 OXIDOR LABORATORIES LLC 341.55 14,224.10 OXIDOR LABORATORIES LLC 241.50 14,465.60 OXIDOR LABORATORIES LLC 341.55 14,807.15 OXIDOR LABORATORIES LLC 241.50 15,048.65 OXIDOR LABORATORIES LLC 6209 AP 6209 AP 6209 AP 6209 AP 6233 AP 6233 AP 6233 AP 6233 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,332.20 15,048.65 ** 40,000.00 Budgeted 24,951.35 Remaining 38 % Used Account: 135-60010-020-000 Communications/Mobiles Account: 135-55091-020-000 Veh Maintenance Collections Totals: 53.99 1,986.94 ** 8,000.00 Budgeted 6,013.06 Remaining 25 5 Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 869 02/26/2020 PCards 1/28/20-2/26/20 Terra Cair Defrost/Right angle 504.68 54.99 559.67 ROANOKE AUTO SUPPLY LT PC Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 54.99 559.67 ** 3,000.00 Budgeted 2,440.33 Remaining 19 5 Used Account: 135-55120-020-000 Cleaning Services 822 02/27/2020 February A?P janitorial svc-january 262.50 87.50 350.00 MEMBER'S BUILDING MAINTENANCE 6230 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 350.00 ** 1,500.00 Budgeted 1,150.00 Remaining 23 % Used Account: 135-55125-020-000 i Dumpster Services mm 771 02/17/2020 828 02/28/2020 828 02/28/2020 February A/P Sludge/grit February A/P Sludge/grit February A/P Sludge/grit 32,786.78 1,079.42 2,236.96 2,376.46 33,866.20 36,103.16 38,479.62 L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. 6207 6227 6227 AP AP AP Account: 135-55125-020-000 Dempster Services Totals: 5,692.84 38,479.62 ** 100,000.00 Budgeted 61,520.38 Remaining 38 % Used Account: 135-55135-020-000 Lab Analysis 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 822 02/27/2020 February A?P 822 02/27/2020 February A?P 828 02/28/2020 February A/P 828 02/28/2020 February A/P lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting 12,716.45 341.55 13,058.00 OXIDOR LABORATORIES LLC 241.50 13,299.50 OXIDOR LABORATORIES LLC 341.55 13,641.05 OXIDOR LABORATORIES LLC 241.50 13,882.55 OXIDOR LABORATORIES LLC 341.55 14,224.10 OXIDOR LABORATORIES LLC 241.50 14,465.60 OXIDOR LABORATORIES LLC 341.55 14,807.15 OXIDOR LABORATORIES LLC 241.50 15,048.65 OXIDOR LABORATORIES LLC 6209 AP 6209 AP 6209 AP 6209 AP 6233 AP 6233 AP 6233 AP 6233 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,332.20 15,048.65 ** 40,000.00 Budgeted 24,951.35 Remaining 38 % Used Account: 135-60010-020-000 Communications/Mobiles glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 747 02/11/2020 February A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Cell phones -February 2,270.53 408.87 2,679.40 VERIZON WIRELESS Page 24 Check Source Number 6198 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 408.87 2,679.40 ** 5,000.00 Budgeted 2,320.60 Remaining 54 % Used Account: 135-60020-020-000 — Electricity 747 02/11/2020 822 02/27/2020 896 02/29/2020 February A?P electricity 1/2-2/3 February A?P Electricity 1/10-2/10 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: 47,873.47 483.78 13,152.71 (666.69) 48,357.25 61,509.96 60,843.27 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 6196 6224 AP AP AR Account: 135-60020-020-000 Electricity — Totals: 12,969.80 60,843.27 ** 160,067.00 Budgeted 99,223.73 Remaining 38 % 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 111.00 .00 111.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 111.00 ** 300.00 Budgeted 189.00 Remaining 37 % Used Account: 135-60080-020-000 Schools & Training 869 02/26/2020 869 02/26/2020 PCards 1/28/20-2/26/20 WW License Renewal PCards 1/28/20-2/26/20 groundwater class- jjones 1,910.85 111.00 410.00 2,021.85 2,431.85 TCEQ IND RENEWAL LIC TEEX ECOMMERCE PC PC Account: 135-60080-020-000 Schools & Training 1 Totals: 521.00 2,431.85 ** 4,990.00 Budgeted 2,558.15 Remaining 49 % Used Account: 135-60090-020-000 = Safety Program 109.14 .00 109.14 Account: 135-60090-020-000 Safety Program Totals: .00 109.14 ** 1,000.00 Budgeted 890.86 Remaining 11 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-60100-020-000 Travel & per diem 360.84 .00 360.84 Account: 135-60100-020-000 Travel & per diem Totals: .00 360.84 ** 1,545.00 Budgeted 1,184.16 Remaining 23 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 822 02/27/2020 February A?P WWTP heater in barn 584.94 584.94 BRANDON R REED 6215 AP Account: 135-60280-020-000 Property Maintenance Totals: 584.94 584.94 ** 5,000.00 Budgeted 4,415.06 Remaining 12 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance rfund Transfer Out -Reserve Tot 125,187.00 Budgeted 96,437.00 Remaining 23,000.00 23 Used 5,750.00 28,750.00 GL GL GL GL un. raps• glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-05 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 14,000.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 62,488.95 Remaining Account: 135-60 020- Interfund T -Rev I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bd WWTP I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S Account1332-02 - terfund Transfe 673,867.00 Budgeted 41,659.24 245,042.20 .00 .00 0 % Used 45 % Used 10,414.81 52,074.05 54,421.63 299,463.83 27,356.28 326,820.11 347,046.89 Remaining 48 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Account: 135-60334-020-000 Account: 135-60334-020-000 Account: 135-60360-020-000 Account: 135-60360-020-000 Account: 135-65005-020-000 Interfund Transfer Ou 180,000.00 Budgeted 180,000.00 Furniture/Equipment < $5000 Remaining 190.00 Furniture/Equipment < $5000 2,000.00 Budgeted 1,810.00 Remaining 0 Used 10 % Used .00 .00 .00 190.00 Fuel & Lube glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JB JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 27 811 02/24/2020 Fuel Fuel -FEB Account: 135-65005- Fuel 0. Lube 12,500.00 Budgeted Totals: 8,745.00 Remaining 2,960.40 794.60 3,755.00 US Bank Voyager Fleet Systems 6236 AP 30 % Used 793,755.00 a. Account: 135-65010-020-000 3,507.93 .00 Account: 135-65010-020-00 5,495.00 Account: 135-65030020-0 Chemicals 890 02/28/2020 February A/P ACCoun Budgeted polymer Chemicals 20,000.00 Budgeted 1,987.07 Remaining 9,868.27 64 % Used 2,856.60 7,275.13 Remaining 64 % Used 3,507.93 12,724.87 POLYDYNE, INC AP Account: 135-65031-020-000 Chemicals Collections 4,994.00 .00 4,994.00 Account: 135-65031-020-000 Chemicals Collections Totals: 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment 869 02/26/2020 PCards 1/28/20-2/26/20 phone case- lholt Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted 12,506.00 Remaining 29 % Used .00 .00 Totals: 1,200.00 Remaining 0 % Used 1,088.92 22.71 1,111.63 AMZN METP US.S952S5OF3 Totals. 88.37 Remaining 93 % Used PC Account: 135-65045-020-000 10,837.36 .00 10,837.36 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 2/2020 JE Detail Description/Comment Lab Supplies 20,000.00 Budgeted Page 28 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 9,162.64 Remaining pital Outla 754 02/13/2020 Void check per finance WWTP Sound curtain/building 771 02/17/2020 February A/P WWTP-water system 890 02/28/2020 February A/P spare pump -lift station Capital Outlays 530,500.00 Budgeted 54 % Ueed 145,872.09 (500.00) 145,372.09 TOWN OF TROPHY CLUB 6080 AP 6,119.80 151,491.89 Halff Associates, INC 6205 AP 8,536.00 160,027.89 DHS AUTOMATION, INC AP 370,472.11 Remaining 30 % Used Short Term Debt -Principal 59,604.74 Account: 135-69008-020-000 Short Term Debt -Principal 79,133.00 Budgeted 19,528.26 Remaining Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt-Inte 11,277.00 Budgeted Account: 135-69195-020-000 Account: 135-69195-020-000 Department 20 Totals: 6,122.03 5,154.97 Remaining .00 59,604.74 75 % Used 54 % Used .00 6,122.03 .eserve or .ep acemen 130,000.00 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining 100 % Used .00 130,000.00 1,234,791.00 ** 196,973.37 Monthly Total 3,157,421.00 Budgeted 1,922,630.00 Remaining 39 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-0 Workman's Compensation 70 02/01/2020 lneurance/Wrk Comp Expense Feb 7.96 1.99 Ac Workman's Compensation Total 30.00 Budgeted 20.05 Remaining 33 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 . Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 9.95 GL 1 .00 .00 0 % Ueed Account: 135-60070-026-000 Account: 135-60070-026-000 Dues & Memberships 675.00 Dues & Memberships Total= 750.00 Budgeted 75.00 Remaining .00 90 % Ueed 675.00 Account: 135-60075-026-000 Account: 135-60075-026-000 Meetings Account: 135-60080-026-000 Account: 135-60080-026-000 Account: 135-60100-026-000 Account: 135-60100-026-000 Meeting. 1,300.00 Budgeted 1,123.72 Remaining 176.28 14 Used 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 176.28 .00 .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 2,000.00 Remaining 0 % Used 1.99 Monthly Total 13,230.00 Budgeted 861.23 •• 12,368.77 Remaining 7 % Used glpdatb2 skrolczyk 11:28 03/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: 2/2020 JE Detail Beginning Balance Description/Comment A0cou t. 135-5000 030- Salaries & We 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages Account:05-0 Salaries & WagesD 628,298.00 Budgeted Account: 135-50010-030-000 782 02/21/2020 MUD Payroll 02/21/2020 Overtime Overtime Account: 135-50010-030-000 Overtime 2,000.00 Budgeted 119,116.36 _ Totals: 479,032.50 Remaining 1,979.47 Remaining 16.57 24 % Used 1 % Used Program: Transaction Detail 15,074.28 15,074.86 3.96 Transaction Vendor Name Detail (SUBTOTAL) 134,190.64 149,265.50 20.53 Page 31 Check Source Number PR PR PR Account: 135-50016-030-000 Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 2,207.50 100 % Used 12,732.78 .00 1,395.90 1,396.30 2,207.50 14,128.68 15,524.98 PR PR Account: 135-50020-030-000 15,524.98 ** 58,554.00 Budgeted 43,029.02 Remaining 27 % Used Account: 135-50026-030-000 al ce 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance Account: 135-50026-030-000 Account: Medical Insurance 124,394.00 Budgeted Dental 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Acc Dental Insurance Dental Insurance Dental Insurance Insure 6,464.00 Budgeted Totals: 95,236.03 Remaining Totals: 4,845.30 Remaining 22,812.20 1,268.95 3,172.91 3,172.86 23 % Used 25 % Used 174.88 174.87 25,985.11 29,157.97 1,443.83 1,618.70 PR PR PR PR glpdatb2 skrolczyk 11:28 03/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 Program: Period Ending: 2/2020 JE Detail Description/Comment Page 32 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ACOO 002:-030- sion Inc 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: Account: 135-50029-030-000 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February A?P Vision Insurance Vision Insurance Vision Insuranc> 1,035.00 Budgeted Life Insurance & Other' Employee Benefits Employee LTD & STD caf 125 plan 197.99 Totals: 785.33 Remaining 24 % Used Account: 135-50029-030Ter 4,500.00 Budgeted 2,864.55 Remaining Account: 135-50030-030-000 1 Security Taxes 675 02/07/2020 MUD Payroll 02/07/2020 Social Security Taxes 782 02/21/2020 MUD Payroll 02/21/2020 Social Security Taxes Account: 135-50030-0 25.85 25.83 223.84 249.67 1,291.54 176.22 1,467.76 Humana Inc 151.69 1,619.45 METLIFE GROUP BENEFITS 16.00 1,635.45 BenefitMall 11.11 PR PR 6136 AP 6145 AP 6214 AP 1,635.45 •• 36 % Used 7,067.51 864.48 7,931.99 PR 858.86 8,790.85 PR Social Security Taxes Totals: 39,215.00 Budgeted Account: 135-50035-030-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-50040-030-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-50040-030-000 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 9,171.00 Budgeted 30,424.15 Remaining 22 % Used Unemployment Taxes Unemployment Taxes Unemployment Taxes Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-03 70 02/01/2020 Insurance/Wrk Comp Expense Feb 1,652.92 202.17 1,855.09 PR 200.86 2,055.95 PR Totals: 40 7,115.05 Remaining 22 % Used 30.16 1,393.34 Remaining 9.64 39.80 6.86 46.66 3 % Used PR PR Comp 419.28 104.82 524.10 GL glpdatb2 ekrolczyk 11:28 03/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 Program: Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 33 Check Source Number 771 02/17/2020 February A/P 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Microsoft exchange internet-February Internet Internet internet Adobe subscription 125,274.22 494.00 125,768.22 M3 Networks 899.00 126,667.22 Charter Communications 42.37 126,709.59 ATT*BILL PAYMENT 53.91 126,763.50 ATT*BILL PAYMENT 42.37 126,805.87 ATT*SILL PAYMENT 36.78 126,842.65 ADOBE ACROPRO SUBS 6208 AP 6202 AP PC PC PC PC 134,681.00 Budgeted 7,838.35 Remaining 94 % Used Account: 135-55070-030-000 755 02/12/2020 revising inv 755 02/12/2020 revising inv 771 02/17/2020 February A/P 771 02/17/2020 February A/P gm consulting -January gm consulting -January GM contract January GM contract January 54,824.49 (10,780.00) (8.70) 10,540.00 8.70 44,044.49 Carman Consulting LLC. 44,035.79 Carman Consulting LLC. 54,575.79 Carman Consulting LLC. 54,584.49 Carman Consulting LLC. 6175 AP 6175 AP 6200 AP 6200 AP Account: 135-55070-030-000 Mr - Independent Labor - Totals: (240.00) 54,584.49 ** 135,000.00 Budgeted 80,415.51 Remaining 40 5 Used Account: 135-55080-030-000 Maintenance & Repairs 1,165.00 .00 1,165.00 Account: 135-50045-030-000 Workman's Compensation Totals: 104.82 524.10 ** 1,775.00 Budgeted 1,250.90 Remaining 30 5 Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 5 Used Account: 135-50070-030-000 Employee Relations 3,076.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 Software & Support 771 02/17/2020 February A/P 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Microsoft exchange internet-February Internet Internet internet Adobe subscription 125,274.22 494.00 125,768.22 M3 Networks 899.00 126,667.22 Charter Communications 42.37 126,709.59 ATT*BILL PAYMENT 53.91 126,763.50 ATT*BILL PAYMENT 42.37 126,805.87 ATT*SILL PAYMENT 36.78 126,842.65 ADOBE ACROPRO SUBS 6208 AP 6202 AP PC PC PC PC 134,681.00 Budgeted 7,838.35 Remaining 94 % Used Account: 135-55070-030-000 755 02/12/2020 revising inv 755 02/12/2020 revising inv 771 02/17/2020 February A/P 771 02/17/2020 February A/P gm consulting -January gm consulting -January GM contract January GM contract January 54,824.49 (10,780.00) (8.70) 10,540.00 8.70 44,044.49 Carman Consulting LLC. 44,035.79 Carman Consulting LLC. 54,575.79 Carman Consulting LLC. 54,584.49 Carman Consulting LLC. 6175 AP 6175 AP 6200 AP 6200 AP Account: 135-55070-030-000 Mr - Independent Labor - Totals: (240.00) 54,584.49 ** 135,000.00 Budgeted 80,415.51 Remaining 40 5 Used Account: 135-55080-030-000 Maintenance & Repairs 1,165.00 .00 1,165.00 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AC Page 34 Maintenance & Repairs 15,000.00 Budgeted 13,835.00 Remaining 8 % Used Generator Maint. and Repair 773 02/17/2020 February A/P admin generator repair Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Account: 135-55120-030-000 Cleaning Services 822 02/27/2020 February A?P janitorial svc-january Account: 135-55120-030-000 eaa na 'ery cec Account: 135-55160-030-000 Account: 135-55160-030-000 Account: 135-55205-030-000 Account: 135-55205-030-000 10,000.00 Budgeted 6,523.76 Professional Outside Services Professional Outside Servi 65,600.00 Budgeted 65,600.00 Utility Billing Contra Utility Billing Contract Remaining Remaining 9,000.00 Budgeted 6,525.19 Remaining Account: 135-60005-030-000 ephone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 answering service 896 02/29/2020 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: 23,680.00 Budgeted 531.00 531.00 Sluder Emergency Power Service 6211 AP 5 % Used 2,607.18 869.06 3,476.24 MEMBER'S BUILDING MAINTENANCE 6230 AP 2,474.81 35 0 Used Used .00 .00 .00 2,474.81 27 % Used 6,125.59 468.11 6,593.70 ATT*BUS PHONE PMT PC 789.08 7,382.78 ATT*BUS PHONE PMT PC 176.78 7,559.56 ATT*BILL PAYMENT PC 19.99 7,579.55 RINGCENTRAL, INC PC (180.00) 7,399.55 AR 16,280.45 Remaining 31 % Used glpdatb2 skrolczyk 11:28 03/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: 2/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 35 Check Source Number 747 02/11/2020 February A?P 856 02/28/2020 Pace Credit Card Fees 856 02/28/2020 Pace Credit Card Fees 890 02/28/2020 February A/P 895 02/28/2020 February A/P Dig Tess -January Dig Tess -February Direct send fees -February 26,018.83 210.90 26,229.73 Texas Excavation Safety System 4,833.54 31,063.27 106.42 31,169.69 202.35 31,372.04 Texas Excavation Safety System 50.00 31,422.04 Fisery Solutions, LLC 6194 AP GL GL AP AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,403.21 31,422.04 ** 67,000.00 Budgeted 35,577.96 Remaining 47 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60010-030-000 Communications/Mobiles 747 02/11/2020 782 02/21/2020 February A?P MUD Payroll Cell phones -February 02/21/2020 Communications/Mobiles 951.81 87.75 150.00 1,039.56 1,189.56 VERIZON WIRELESS 6198 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.75 1,189.56 ** 4,000.00 Budgeted 2,810.44 Remaining 30 % Used Account: 135-60020-030-000 Electricity/Gas 747 02/11/2020 February A?P gexa energy 12/10-1/10 1,282.43 718.11 2,000.54 TOWN OF TROPHY CLUB 6195 AP Account: 135-60020-030-000 Electricity/Gas Totals: 718.11 2,000.54 ** 6,879.00 Budgeted 4,878.46 Remaining 29 % Used Account: 135-60025-030-000 Water 890 02/28/2020 896 02/29/2020 February A/P Town Billed water-february Invoices 1726-1729 AR 20200229-20200229 User: 241.17 285.43 (142.71) 526.60 383.89 TROPHY CLUB MUD (WATER BILLS) AP AR Account: 135-60025-030-000 Water Totals: 142.72 383.89 ** 1,500.00 Budgeted 1,116.11 Remaining 26 % Used Account: 135-60035-030-000 Postage 6,806.80 .00 6,806.80 Account: 135-60035-030-000 Postage Totals: .00 6,806.80 ** 30,000.00 Budgeted 23,193.20 Remaining 23 % Used Account: 135-60040-030-000 Service Charges & Fees 747 02/11/2020 February A?P 856 02/28/2020 Pace Credit Card Fees 856 02/28/2020 Pace Credit Card Fees 890 02/28/2020 February A/P 895 02/28/2020 February A/P Dig Tess -January Dig Tess -February Direct send fees -February 26,018.83 210.90 26,229.73 Texas Excavation Safety System 4,833.54 31,063.27 106.42 31,169.69 202.35 31,372.04 Texas Excavation Safety System 50.00 31,422.04 Fisery Solutions, LLC 6194 AP GL GL AP AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,403.21 31,422.04 ** 67,000.00 Budgeted 35,577.96 Remaining 47 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC 0 Bad Debt Expense Tota 1,500.00 Budgeted Insurance 1,500.00 Remaining 0 % Ueed 70 02/01/2020 Insurance/Wrk Comp Expense Feb 24,431.70 Account: 135-60055-030-000 Insurance Totals: 84,000.00 Budgeted 52,569.91 Remaining 37 % Used Account: 135-60066-030-000 Publications/Books/Subscripts Account: 135-60066-030-000 Publications/Books/Subscripts Totals: ■ 1,000.00 Budgeted 875.00 Remaining Account: 135-60070-030-00 Dues & Memberships 869 02/26/2020 PCarde 1/28/20-2/26/20 prime membership Account: 135-60070-030-00Dues & Memberships 6,000.00 Budgeted Account: 135-60075-030-000 Account: 135-60075-030-000 Meetings 400.00 Budgeted Acc. Public Education 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 1,714.45 Remaining 125.00 4,166.55 61.37 13 % Ueed 71 % Used 6,998.39 31,430.09 GL .00 125.00 119.00 4,285.55 AMAZON PRIME*NL5IT9C73 .00 61.37 338.63 Remaining 15 % Used MUD boundary update real estate sign/frame sign holder Public Education 6,000.00 Budgeted 2,190.31 Remaining 1 Acc Schools & Training PC 476.20 2,508.78 2,984.98 Halff Associates, INC 6205 AP 595.00 3,579.98 SIGN-A-RAMA PC 229.71 3,809.69 AMZN MKTP US*XJ3GW3RP3 PC 63 % Used 69 ** glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 37 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 869 02/26/2020 PCards 1/28/20-2/26/20 SErolczyk college transcript Account: 135-60080-030-8W Schools & Training 6,850.00 Budgeted Account: 135-60100-030-000 iir Travel & per diem Account: 135-60100-030-000 Travel & per diem 3,545.00 Budgeted Account: 135-60110-030-000 Physicals/Test Account: 135-60110-030-000 Physicals/Testing 200.00 Budgeted Account: 135-60115-030-000 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Account Account: 135 -60125 -lime 1,152.71 10.50 1,163.21 COLLEGE TRANSCRIPT Totals: IIIIIIf 163.21 ** 5,686.79 Remaining 17 % Used 695.14 .00 695.14 PC 2,849.86 Remaining 20 % Used .00 .00 200.00 Remaining 0 % Used Ballot translate for may elect Ballot translate for may elect .00 Budgeted (138.04) Remaining Adver 43.01 76.13 119.14 IN *TIN -TRANSLATION IN PC 18.90 138.04 IN *TIN -TRANSLATION IN PC 0 % Used .00 .00 Advertising 2,500.00 Budgeted 2,500.00 Remaining 771 02/17/2020 February A/P 1 Account: 135-60245-030-00 Secu monitoring svc-feb 1,288.00 Budgeted 1,168.00 Remaining Miscellaneous Expenses 0 % Used 96.00 24.00 120.00 Digital Air Control, Inc 9 % Used 6203 AP glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 38 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-030-00t Account: 135-60246-030-000 .00 .00 Miscellaneous Expenses Totals: Account: 135-60246-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 500.00 Budgeted General Manager Contingency General Manager Contingen- 17,000.00 Budgeted Furniture/Equipment e Furniture/Equipme 2,500.00 Budgeted 500.00 Remaining 0 % Used 17,000.00 2,500.00 Remaining Remaining 0 % Used 0 Used .00 .00 .00 .00 Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Uniforms - 2,050.00 Budgeted 2,050.00 Remaining 0 % Ueed .00 .00 Account: 135-65055-030-000 Hardware Account: 135-65055-030-000 Hardware - 26,485.00 Budgeted 3,235.24 .00 3,235.24 Totals: 23,249.76 Remaining 12 % Ueed Account: 135-65085-030-000 Office Supplies ` 869 02/26/2020 PCarde 1/28/20-2/26/20 Noatry stamp 1,866.47 43.00 1,909.47 AMER ASSOC NOTARIES PC 869 02/26/2020 PCarde 1/28/20-2/26/20 envelopes 29.99 1,939.46 AMZN MKTP US*F09688JJ3 PC 822 02/27/2020 February A?P office supplies 60.83 2,000.29 OFFICE DEPOT, INC 6232 AP 822 02/27/2020 February A?P office supplies 1.95 2,002.24 OFFICE DEPOT, INC 6232 AP Acc Office Supplies 6,000.00 Budgeted 3,997.76 Remaining 33 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-65090-030-000 Printer Supplies & Maintenance Account: 135-65090-030-000 Printer Supplies & Maintenance Total 3,500.00 Budgeted 3,500.00 Remaining 0 % Used .00 .00 Account: 135-65095-030-000 Maintenance Supplies 869 02/26/2020 PCards 1/28/20-2/26/20 popcorn 2,396.62 44.89 2,441.51 AMAZON.COM*917RX0373 PC 869 02/26/2020 PCards 1/28/20-2/26/20 tea 11.00 2,452.51 AMAZON.COM*6E84V0UT3 PC 869 02/26/2020 PCards 1/28/20-2/26/20 tea 11.00 2,463.51 AMAZON.COM*HP6E490B3 PC 869 02/26/2020 PCards 1/28/20-2/26/20 paper prodcuts, soap, cc 133.31 2,596.82 SAMSCLUB.COM PC 869 02/26/2020 PCards 1/28/20-2/26/20 cofee 101.98 2,698.80 AMZN MKTP US*7G2DR5YT3 PC Maintenance Supplies Totals: 4,000.00 Budgeted 1,301.20 Remaining 67 % Used Account: 135-65105-030-000 Printing .00 Account: 135-65105-030-000 Printing Totals: 2,500.00 Remaining 0 % Used 2,500.00 Budgeted Account: 135-69005-030-000 Capital Outlays 771 02/17/2020 February A/P GIS development 47.39 .00 47.39 Halff Associates, INC 6205 AP Account: 135-69005-030-000 Capital Outlays Totals: 195,000.00 Budgeted 194,952.61 Remaining 0 % Ueed Account: 135-69170-030-000 Copier Lease Installments 771 02/17/2020 February A/P copier lease-feb 822 02/27/2020 February A?P copies Department 30 Totals: Copier Lease Installments Totals: 4,000.00 Budgeted 2,728.53 Remaining 1,037.66 165.00 1,202.66 TIAA COMMERCIAL FINANCE 68.81 1,271.47 KYOCERA DOCUMENT SOLUTIONS 32 % Used 503,535.76 ** 64,087.90 Monthly Total 1,776,712.00 Budgeted 1,273,176.24 Remaining 28 % Used 6212 AP 6226 AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 2/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 40 Check Source Number Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 10,666.00 Monthly Total 244.00 Remaining 94 % Used 93,350.22 ** 184,561.00 Budgeted 91,210.78 Remaining 51 % Used 153,648.25 (12,750.98) Monthly Total (6,224.00) Budgeted (159,872.25) Remaining ########## Account: 135-55045-039-000 Legal 747 02/11/2020 February A?P 749 02/12/2020 February A/p Westlake legal easement 46,036.39 5,566.00 5,100.00 51,602.39 56,702.39 WHITAKER CHALK SWINDLE McLean & Howard, L.L.P. 6199 6185 AP AP Account: 135-55045-039-000 Legal Totals: 10,666.00 56,702.39 ** 135,000.00 Budgeted 78,297.61 Remaining 42 % Used Account: 135-55055-039-000 Auditing 27,713.27 .00 27,713.27 Account: 135-55055-039-000 Auditing Totals: .00 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 5,178.56 .00 5,178.56 Account: 135-55060-039-000 Appraisal Totals: .00 5,178.56 ** 11,761.00 Budgeted 6,582.44 Remaining 44 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 10,666.00 Monthly Total 244.00 Remaining 94 % Used 93,350.22 ** 184,561.00 Budgeted 91,210.78 Remaining 51 % Used 153,648.25 (12,750.98) Monthly Total (6,224.00) Budgeted (159,872.25) Remaining ########## glpdatb2 skrolczyk 11:28 03/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: 2/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 FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 541,004 TOTAL ASSETS 541,004 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 690,547 TOTAL LIABILITIES 690,547 FUND BALANCE ASSIGNED FUND BALANCE (118,409) NET REVENUES / EXPENDITURES (31,133) TOTAL FUND BALANCE (149,543) TOTAL LIABILITIES AND FUND BALANCE 541,004 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 689.02- 4,038.13- 4,038.13 Page 14 Subtotal: 689.02- 4,038.13- 4,038.13 Program number: 689.02- 4,038.13- 4,038.13 Department number: Revenues 689.02- 4,038.13- 4,038.13 Revenues Subtotal 689.02- 4,038.13- 4,038.13 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description 517-69005-020-000 Capital Outlays Subtotal: Department number: Wastewater Expenditures Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 11,386.39 31,133.28 31,133.28 - Page 15 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/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 857 02/28/2020 Bank Interest- February (3,349.11) (689.02) (4,038.13) GL Account Interest Income Totals: .00 Budgeted 4,038.13 Remaining 0 % Used Department Totals: (4,038.13) ** (689.02) Monthly Total .00 Budgeted 4,038.13 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 747 02/11/2020 February AMP 771 02/17/2020 February A/P 830 02/28/2020 February A/P 830 02/28/2020 February A/P Accor Capital Outlays WWTP Lege WWTP legal WWTP Crane survey WWTP Improvements Capital Outlays .00 Budgeted 23,096.00 _ Totals: (35,171.41) Remaining 0 % Used 5,985.00 1,020.00 2,112.50 2,957.91 29,081.00 CP&Y/WALLACE GROUP, INC. 30,101.00 Dubois Bryant Campbell LLP 32,213.50 Wiss, Janney, Elstner Assoc 35,171.41 CP&Y/WALLACE GROUP, INC. Department 20 Totals: 35,171.41 ** 12,075.41 Monthly Total .00 Budgeted (35,171.41) Remaining 0 % Used Fund 517 Totals: 31,133.28 11,386.39 Monthly Total .00 Budgeted (31,133.28) Remaining 0 % Used 6178 AP 6204 AP 6241 AP 6236 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,091 TOTAL ASSETS 784,091 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 3,752 702,400 784,091 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 2/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 649.96- 3,751.83- 3,751.83 Page 16 Subtotal: 649.96- 3,751.83- 3,751.83 Program number: 649.96- 3,751.83- 3,751.83 Department number: Revenues mm 649.96- 3,751.83- 3,751.83 Revenues Subtotal 649.96- 3,751.83- 3,751.83 I Fund number: 519 2016 Rev Bond Const -SWIFT ! 649.96- 3,751.83- 3,751.83 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 2/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 857 02/28/2020 Bank Interest- February Account Interest Income .00 Budgeted (3,101.87) (649.96) (3,751.83) GL ) ** 3,751.83 Remaining 0 % Used Department Totals: (3,751.83) ** (649.96) Monthly Total .00 Budgeted 3,751.83 Remaining 0 % Used Fund 519 Totals: (3,751.83) (649.96) Monthly Total .00 Budgeted 3,751.83 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET FEBRUARY 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 552,653 INVESTMENTS 3,888,180 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,440,833 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 89,353 TOTAL LIABILITIES 89,353 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (102,809) TOTAL FUND BALANCE 4,351,481 TOTAL LIABILITIES AND FUND BALANCE 4,440,834 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 3,921.20- 22,629.01- 22,629.01 Page 17 Subtotal: 3,921.20- 22,629.01- 22,629.01 Program number: 3,921.20- 22,629.01- 22,629.01 Department number: 3,921.20- 22,629.01- 22,629.01 Revenues Subtotal 3,921.20- 22,629.01- 22,629.01 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 2/2020 Adopted Amended Total Current Budget Budget Encumb. Month 89,995.85 Program: YTD Total 125,438.76 % of Remaining Budget Budget 125,438.76 - Page 18 Subtotal: II 89,995.85 125,438.76 125,438.76 - Program number: II 89,995.85 125,438.76 125,438.76 - Department number: Water Department — 89,995.85 125,438.76 125,438.76 - Expenditures Subtotal 89,995.85 125,438.76 125,438.76 - Fund number: 520 Revenue Bond 16" Waterline ME 86,074.65 102,809.75 102,809.75- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-0 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February Account: 520-490 Interest Income Totals: .00 Budgeted (18,707.81) (698.14) (19,405.95) GL (3,223.06) (22,629.01) GL 22,629.01 Remaining 0 % Used Department Totals: (22,629.01) ** (3,921.20) Monthly Total .00 Budgeted 22,629.01 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 46 ACCOyit: 520-69005-010-000 i 771 02/17/2020 February A/P 830 02/28/2020 February A/P 836 02/28/2020 February A/P 836 02/28/2020 February A/P Department 10 Totals: Capital Outlays Easement acquisition Easement legal 16" water Line easement 16" Water Line easement Capital Outlaysl .00 Budgeted 35,442.91 643.29 36,086.20 Halff Associates, INC 6205 AP 20,150.56 56,236.76 Jackson Walker LLP 6239 AP 64,106.00 120,342.76 Trophy Club Economic Dev Corp 6240 AP 5,096.00 125,438.76 Trophy Club Economic Dev Corp 6240 AP Totals: (125,438.76) Remaining 0 % Used 89,995.85 125,438.76 ** 89,995.85 Monthly Total .00 Budgeted (125,438.76) Remaining 0 % Used Fund 520 Totals: 102,809.75 86,074.65 Monthly Total .00 Budgeted (102,809.75) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 860,996 TOTAL ASSETS 860,996 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 57,539 860,996 860,996 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- Subtotal: m 518,466.00- 518,466.00 - Program number: 518,466.00- 518,466.00 - Department number: 518,466.00- 518,466.00 - Revenues Subtotal 518,466.00- 518,466.00 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 1,077.76- 4,600.00- 5,750.00- 5,789.00- 23,000.00- 28,750.00- 57,539.00- 57,539.00- 57,539.00- 57,539.00- 57,539.00- 52.627 7.491 14.345 11.098 11.098 11.098 11.098 11.098 5,211.00- 284,049.00- 171,667.00- 460,927.00- 460,927.00- 460,927.00- 460,927.00- 460,927.00 - Page 19 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/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 857 02/28/2020 Bank Interest- February (4,711.24) (1,077.76) (5,789.00) GL Ac come 1 (11,000.00) Budgeted Account: 528-49142-000-000 798 02/21/2020 TexPool Transfers February (5,211.00) Remaining 53 % Used TexPool O&M to Rev Bond Resevr (18,400.00) Account Interfund transfer in -Water Totals: (307,049.00) Budgeted (284,049.00) Remaining Interfund transfer in -WW 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer i (200,417.00) Budgeted (23,000.00) (171,667.00) Remaining (4,600.00) (23,000.00) 7 % Used (5,750.00) 14 % Used (28,750.00) Department Totals: (57,539.00) ** (11,427.76) Monthly Total (518,466.00) Budgeted (460,927.00) Remaining 11 % Used Fund 528 Totals: (57,539.00) (11,427.76) Monthly Total (518,466.00) Budgeted (460,927.00) Remaining 11 % Used GL GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS 905,362 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 35,640 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 941,002 FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 35,640 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 35,640 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 822,408 TOTAL FUND BALANCE 905,362 TOTAL LIABILITIES AND FUND BALANCE 941,002 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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- 63,144.34- 946.27- 655.33- 64,745.94- 1,036.69- 218,004.00- 10,414.81- 44- 44- 44- 672,711.98- 1,579.73- 1,004.82- 2,412.40- 218,004.00- 52,074.05- 272,490. 947,786 . 947,786.98- 947,786.98- 98.574 157.973 50.241 98.520 48.248 100.000 45.455 92.647 92.647 92.647 9,729.02- 579.73 995.18- 2,587.60- 62,488.95- 75,221.02- 75,221.02- 75,221.02 - Page 20 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 2,150.00 247,858.00 247,858.00 765,000.00 765,000.00 1,450.00 123,928.75 1,450.00 123,928.75 67.442 50.000 700.00 123,929.25 765,000.00 Page 21 Subtotal: 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,615.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 168,822.69- 822,408.23- 9#99#9#9#99#9#9 814,408.23 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 48 Check Source Number Account: 533-40000-000-000 Property Taxes 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 881 02/19/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes (609,567.64) (9,894.38) (619,462.02) (8,101.32) (627,563.34) (9,154.58) (636,717.92) (7,308.34) (644,026.26) (22,633.07) (666,659.33) (143.86) (666,803.19) (9.49) (666,812.68) (.04) (666,812.72) (339.25) (667,151.97) (151.76) (667,303.73) (.01) (667,303.74) (179.72) (667,483.46) (487.96) (667,971.42) (1,510.90) (669,482.32) (266.42) (669,748.74) (231.94) (669,980.68) (1,136.55) (671,117.23) (1,594.75) (672,711.98) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (63,144.34) (672,711.98) ** (682,441.00) Budgeted (9,729.02) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 883 02/21/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes (633.46) (57.25) (3.74) (837.11) (34.15) (6.17) (7.85) (690.71) (694.45) (1,531.56) (1,565.71) (1,571.88) (1,579.73) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (946.27) (1,579.73) ** (1,000.00) Budgeted 579.73 Remaining 158 % Used Account: 533-40015-000-000 Property Taxes/P & I 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes (349.49) (11.62) (361.11) (.90) (362.01) (192.04) (554.05) (76.27) (630.32) (10.07) (640.39) (.66) (641.05) GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account: 533-40015-000-000 Ac 0 : 533 -49011 -000 - Property Taxe9/P & I (2,000.00) Budgeted 857 02/28/2020 Bank Interest- February Accountil Interest Income (5,000.00) Budgeted Account: 533-49015-000-000 Lease/Rental Income 799 02/21/2020 Fire Rent Transfer 2020 Account: 533-49015-000-000 Lease/Rental Income (218,004.00) Budgeted (995.18) Remaining (349.49) (23.74) (664.79) GL (.38) (665.17) GL (12.58) (677.75) GL (105.74) (783.49) GL (15.99) (799.48) GL (17.59) (817.07) GL (81.04) (898.11) GL (106.71) (1,004.82) GL 50 % Used (1,375.71) 3) (1,004.82) ** (1,036.69) (2,587.60) Remaining 48 % Used Totals: ' .00 Remaining Account: 533-49141-000-00 Interfund Trans In -PID Surchg 798 02/21/2020 TexPool Transfers February TexPool O&M to I&S- PID Debt 100 % Used (41,659.24) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Total.. (114,563.00) Budgeted (62,488.95) Remaining Department Totals: (2,412.40) (218,004.00) (218,004.00) (218,004.00) (10,414.81) 45 % Used (52,074.05) (947,786.98) ** (294,201.44) Monthly Total (1,023,008.00) Budgeted (75,221.02) Remaining 93 % Used GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accoaaot: 533-70005-051- Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 200.00 200.00 GL 820 02/24/2020 3/1/20 Bond Payments INTEREST TCMUD-12 500.00 700.00 GL 820 02/24/2020 3/1/20 Bond Payments INTEREST TCMUD-10 750.00 1,450.00 GL Account: Paying Agent Fee 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-00 Bond Interest Expense -Tax 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 820 02/24/2020 3/1/20 Bond Payments INTEREST BNY MELLON Unl Tax Series 2010 820 02/24/2020 3/1/20 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2012 820 02/24/2020 3/1/20 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2013 Accoun70025-051-0U Account: 533-70035-051-000 Account: 533-70035-051-000 Department 51 Totals: Fund 533 Totals: Bond Interest Expense -Tax Totals: 247,858.00 Budgeted 123,929.25 Remaining Bond Principal Payment -Tax Bond Principal Payment -T 765,000.00 Budgeted 125,378.75 Monthly Total 765,000.00 Remaining 50 % Used 0 Used 66,887.50 29,953.75 14,175.00 12,912.50 .00 66,887.50 96,841.25 111,016.25 123,928.75 .00 125,378.75 ** 1,015,008.00 Budgeted 889,629.25 Remaining 12 % Used (822,408.23) (168,822.69) Monthly Total (8,000.00) Budgeted 814,408.23 Remaining ##N####### GL GL GL GL TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 193,249 TOTAL ASSETS 193,249 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 168,732 193,249 193,249 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 534-49011-000-000 1 534-49143-000-000 Interest Income Interfund Transfer In-ww Sales 2,500.00- 598,638.00- 2,500.00- 598,638.00- 300.99- 54,421.63- 942.91- 272,107.55- 37.716 45.454 1,557.09- 326,530.45 - Page 22 Subtotal: 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Program number: 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Department number: Revenues 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Revenues Subtotal 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54- glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 23 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 200.00 50.000 200.00 I 534-70040-051-000 Revenue Bona Interest Expense 208,238.00 208,238.00 104,118.75 104,118.75 50.000 104,119.25 I 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 I Subtotal: , 598,638.00 598,638.00 . 104,318.75 17.426 494,319.25 Program number: III 598,638.00 598,638.00 104,318.75 1C 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 104,318.75 1' 17.426 494,31 Expenditures Subtotal 111 598,638.00 598,638.00 104,318.75 175 17.426 494,31 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 49,596.13 171- IIIIII49.268 166,231.71 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 534 2015 Revenue Bond I0S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (54,722.62) Monthly Total (273,050.46) ** (601,138.00) Budgeted (328,087.54) Remaining 45 5 Used Account: 534-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (641.92) (300.99) (942.91) GL Account: 534-49011-000-000 Interest Income Totals: (300.99) (942.91) ** (2,500.00) Budgeted (1,557.09) Remaining 38 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bd WWTP I&S (217,685.92) (54,421.63) (272,107.55) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (272,107.55) ** (598,638.00) Budgeted (326,530.45) Remaining 45 % Used Department Totals: (54,722.62) Monthly Total (273,050.46) ** (601,138.00) Budgeted (328,087.54) Remaining 45 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Acco lt: 534-70005-051- Rev Bond Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Acil Rev Bond Paying Agent 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Account: 0040-051-000 — Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 50 200.00 200.00 GL Used 104,118.75 104,118.75 GL 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 1111111111111145-051-000 Department 51 Totals: Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining .00 .00 0 % Used 104,318.75 ** 104,318.75 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (168,731.71) 49,596.13 Monthly Total (2,500.00) Budgeted 166,231.71 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 100,337 TOTAL ASSETS 100,337 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 95,370 100,337 100,337 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Subtot Program number: Department number: Revenues Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Revenues Subtotal 25.00- 0- 276t25.00- 0- 276,525.00- 276,525.00- 276,525.00- 135.15- 25,047.72- 111111111111111 - 1111111111112.87- 394.27- 125,238.60- 125, 125,632.87- 125,632.87- 125,632.87- 39.427 605.73- 45.455 150,286.40- 433 f50,892.13- .433 30,892.13- .433 150,892.13 - 45.433 150,892.13- 1 45.433 150,892.13- Page 24 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/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 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 Program number: _b02,611.00 602,611.00 Department number: Administration mEr 602,611.00 602,611.00 Expenditures Subtotal 602,611.00 602,611.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 200.00 200.00 25.000 600.00 30,062.50 30,062.50 7.772 356,748.50 215,000.00 30,262.50 30,26.,.55 5.022 572,348.50 ■ 30,262.50 30,262.50 5.022 572,348.50 ■ 30,262.50 30,262.50 5.022 572,348.50 • 30,262.50 30,262.50 5.022 572,348.50 ■ 5,079.63 95,370.37- -29.247 421,456.37 Page 25 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (25,182.87) Monthly Total (125,632.87) ** (276,525.00) Budgeted (150,892.13) Remaining 45 5 Used Account: 535-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (259.12) (135.15) (394.27) GL Account: 535-49011-000-000 Interest Income Totals: i (135.15) (394.27) ** (1,000.00) Budgeted (605.73) Remaining 39 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 16Swift Rev I&S (100,190.88) (25,047.72) (125,238.60) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: Mr (25,047.72) (125,238.60) ** (275,525.00) Budgeted (150,286.40) Remaining 45 5 Used Department Totals: (25,182.87) Monthly Total (125,632.87) ** (276,525.00) Budgeted (150,892.13) Remaining 45 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accojt: 535-70005-051- Rev Bond Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 200.00 Acil Rev Bond Paying Agent 800.00 Budgeted 600.00 Remaining 25 % Used Account: 535-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 30,062.50 Account: 0040-051-000 — Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining 8 % Ueed 200.00 GL 30,062.50 GL Account. 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 .00 0 % Used Department 51 Totals: 30,262.50 ** Fund 535 Totals: 30,262.50 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used (95,370.37) 5,079.63 Monthly Total 326,086.00 Budgeted 421,456.37 Remaining -29 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,261 TOTAL ASSETS 23,261 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,261 TOTAL FUND BALANCE 23,261 TOTAL LIABILITIES AND FUND BALANCE 23,261 glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 2/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 141.18- 414.96- 414.96 I 1 536-49142-000-000 Interfund Tran In -Water Sales 91,584.08- 183,168.16- 183,168.16 I 1 536-49143-000-000 Interfund Transfer In -WW Sales 27,356.28- 54,712.56- 54,712.56 I Subtotal: 119,081.54- 238,295.68- 238,295.68 Program number: me 119,081.54- 238,295.68- 238,295.68 Department number: Revenues 119,081.54- 238,295.68- 238,295.68 I Revenues Subtotal ME 119,081.54- 238,295.68- 238,295.68 glbase_tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-70005-051-000 536-70040-051-000 Subtot Program number: Department number: Administration Expenditures Subtotal Rev Bond Paying Agent Fee Revenue Bond Interest Expense Page 27 142.08 142.08 142.08- I 214,892.43 214,892.43 214,892.43- I '4 .51 Fund number: 536 2019 Rev Bond I&S- W&WW System 23,261.17- ******* End of Report ********* 2111111111111111 215. U3T T- 215,034.51- 23,261.17 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 2/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 857 02/28/2020 Bank Interest- February (273.78) (141.18) (414.96) GL Account: 536-49011-000-000 Interest Income Totals: (141.18) (414.96) ** .00 Budgeted 414.96 Remaining 0 5 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S (91,584.08) (91,584.08) (183,168.16) GL Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: (91,584.08) (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S (27,356.28) (27,356.28) (54,712.56) GL Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: (27,356.28) (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 % Used Department Totals: (238,295.68) ** (119,081.54) Monthly Total .00 Budgeted 238,295.68 Remaining 0 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accost: 536-70005-051- Rev Bond Paying Agent Fee 11111111111111111 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF REV BOND 1TROP419WSSR 142.08 Acilking Agent .00 Budgeted (142.08) Remaining 0 % Ueed Account: 536-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF REV BOND 1TROP419WSSR 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 % Used 142.08 GL 214,892.43 GL 215,034.51 ** 215,034.51 Monthly Total .00 Budgeted (215,034.51) Remaining 0 % Used 95,952.97 Monthly Total .00 Budgeted (23,261.17) 23,261.17 Remaining 0 % Used ******* End of Report ********* (1,635,095.78) **** 219,038.07 Monthly Total (209,104.00) Budgeted 1,425,991.78 Remaining 782 5 Used