Loading...
HomeMy WebLinkAbout2020-05 Combined Financials 2020 MAYTROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET MAY 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 895,282 PREPAID EXPENSES 6,564 ADVALOREM PROPERTY TAXES RECEIVABLE 37,757 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 939,603 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 37,763 TOTAL LIABILITIES 37,763 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 298,071 TOTAL FUND BALANCE 901,840 TOTAL LIABILITIES AND FUND BALANCE 939,603 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 122-40020-000-000 Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 5,990.97- 1,212,561.75- 104.81 2,762.65- 289.88- 4,300.92- 99.863 1,668.25- 2,762.65 4,300.92 Subtotal: 1,214,230.00- 1,214,230.00- = 6,176.04- 1,219,625.32- 100.444 5,395.32 Program number: 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 I Revenues Subtotal 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 Page 1 glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 tota1: 957,661.00 957,661.00 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 Subtota1: 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire 1,214,230.00 1,214,230.00 Expenditures Subtotal 1,214,230.00 1,214,230.00 Fund number: 122 Trophy Club MUD Fire Dept. 1,640.88 59,888.08 61,528.96 61,528.96 61,528.96 61,528.96 55,352.92 218,004.00 13,127.04 479,104.64 100.000 62.510 66.667 7,872.96 239,552.36 710,235.68 247,42 2,750.00 11,958.24 81,420.00 115,190.36 921.554- 921,554 298,071.04- 5.729 100.000 90.595 45,250.00 11,958.24- 11,958.64 Page 2 82.363 75.896 75.896 75.896 292,675 292,675 298,071.04 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-020- 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 122-40010-000-000 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/MUD Fire (1,206,570.78) (73.86) (1,206,644.64) (1.77) (1,206,646.41) (8.07) (1,206,654.48) (333.59) (1,206,988.07) (1,081.52) (1,208,069.59) (44.00) (1,208,113.59) (53.23) (1,208,166.82) 227.10 (1,207,939.72) (152.61) (1,208,092.33) (733.84) (1,208,826.17) (264.16) (1,209,090.33) (182.32) (1,209,272.65) (442.61) (1,209,715.26) (596.60) (1,210,311.86) (420.83) (1,210,732.69) (203.39) (1,210,936.08) (669.13) (1,211,605.21) (416.87) (1,212,022.08) (539.67) (1,212,561.75) Property Taxes/MUD Fire Totals: .di.97) (1,212,561.75) ** (1,214,230.00) Budgeted (1,668.25) Remaining 100 % Used Property Taxes/Fire-Delinquent Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Total .00 Budgeted 2,762.65 Remaining Account: 122-40020-000-0 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes Property Taxes/Fire P&2 (2,867.46) (4,011.04) 0 % Used (14.13) (2,881.59) 194.89 (2,686.70) (20.88) (2,707.58) (32.85) (2,740.43) (9.79) (2,750.22) (12.43) (2,762.65) (1.13) (4,012.17) (.20) (4,012.37) (1.07) (4,013.44) (3.97) (4,017.41) (119.68) (4,137.09) 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 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 122-40020-000-000 Department Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/Fire P52 To .00 Budgeted 4,300.92 Remaining (6,176.04) Monthly Total (4,011.04) 0 Used (15.02) (4,152.11) (.94) (4,153.05) (65.77) (4,218.82) (5.06) (4,223.88) (.94) (4,224.82) (31.01) (4,255.83) .27 (4,255.56) (24.92) (4,280.48) (2.47) (4,282.95) (3.68) (4,286.63) (.30) (4,286.93) (13.99) (4,300.92) (4,300.92) ** (1,219,625.32) ** (1,214,230.00) Budgeted 5,395.32 Remaining 100 % Used Page 2 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Period Ending: 5/2020 Program: JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 3 Check Source Number Account: 122-60030-045-000 Rent And/Or Usage 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 73 05/01/2020 Insurance/Wrk Comp Expense May 11,486.16 1,640.88 13,127.04 GL Account: 122-60055-045-000 Insurance Totals: ' 1,640.88 13,127.04 ** 21,000.00 Budgeted 7,872.96 Remaining 63 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1178 05/11/2020 May A/P May Fire admin 419,216.56 59,888.08 479,104.64 TOWN OF TROPHY CLUB 6435 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 479,104.64 ** 718,657.00 Budgeted 239,552.36 Remaining 67 % Used Account: 122-69005-045-000 Capital Outlays 2,750.00 .00 2,750.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 2,750.00 ** 48,000.00 Budgeted 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Short Term Debt -Interest 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement A11111_ 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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: 921,554.28 •• 61,528.96 Monthly Total 1,214,230.00 Budgeted 292,675.72 Remaining 76 % Used Fund 122 Totals: (298,071.04) 55,352.92 Monthly Total .00 Budgeted 298,071.04 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MAY 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,088,104 3,088,104 CASH IN BANK -SAVINGS -CASH RESERVE 1,604,892 1,604,892 INVESTMENTS-TEXPOOL 3,577,659 919,266 4,496,925 PREPAID EXPENSES 39,434 39,434 ADVALOREM PROPERTY TAXES RECEIVABLE 4,097 4,097 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,009,838 1,009,838 TOTAL ASSETS 9,324,623 919,266 10,243,889 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,097 4,097 ACCOUNTS AND OTHER PAYABLES 499,383 499,383 CUSTOMER DEPOSITS 315,760 315,760 TOTAL LIABILITIES 819,239 819,239 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 103,999 103,999 TOTAL FUND BALANCE 8,505,384 919,266 9,424,650 TOTAL LIABILITIES AND FUND BALANCE 9,324,623 919,266 10,243,889 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 135-47000-000-000 Water 135-47005-000-000 Sewer 135-47025-000-000 Penalties 135-47030-000-000 Service Charges 135-47035-000-000 Plumbing Inspections 135-47045-000-000 Sewer Inspections 135-47070-000-000 TCCC Effluent Charges 134,871.00- 300.00- 300.00- 164,253.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 134,871.00- 300.00- 300.00- 164,253.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 665.06- 11.90 32.19- 459,563.85- 273,756.56- 57.86 25.00- 8,843.20- 134,609.11- 285.08- 468.83- 2,951,753.71- 2,053,404.14- 51,074.93- 9,825.00- 2,250.00- 1,350.00- 25,908.80- 99.806 95.027 156.277 i63 261.89- 14.92- 168.83 164,253.00- 164, 45.505 58.604 45.356 64.851 300.000 54.000 51.818 3,534,869.29- 1,450,480.86- 61,533.07- 5,325.00- 1,500.00 ,534,869.29-1,450,480.86-61,533.07- 5,325.00- 1,500.00 1,150.00- 24,091.20- 10,171,516.00- 10,171,516.00- _J11111111E0.75- 5,095,566 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 ENSubtota. Program number: Department number: Revenues Revenues Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 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- 3,764.35- 1,178.81- 583.33- 169.84- 67,382.29- 8,251.67- 4,666.64- 8,925.00- 7,730.28- 8,971.93- 99.806 7,382.29-8,251.67-4,666.64-8,925.00-7,730.28- 8,971.93- 56.152 58.332 66.666 68.654 60.912 128.170 52,617.71- 5,894.33- 2,333.36- 4,075.00- 4,960.72- 1,971.93 173,837.00- Subtotal 0- 10,645,077.00- 0- 10,645,077.00- 10- 10,645,077.00- 748 8,219.59- 19.59- 08,219.59- glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 46,318.05 135-50010-010-000 Overtime 17,000.00 17,000.00 1,562.49 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 425.00 135-50020-010-000 Retirement 34,863.00 34,863.00 4,473.10 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 5,225.04 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 316.63 135-50028-010-000 Vision Insurance 767.00 767.00 48.18 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 328.89 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 2,974.38 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 695.62 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 771.49 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 FSubtotal: ' 546,839.00 546,839.00 63,138.87 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 5,089.98 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 601.87 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 239,064.24 68.252 13,427.75 78.987 5,082.50 129.656 3,350.00 62.037 25,233.24 72.378 40,053.74 47.499 2,431.37 51.458 380.65 49.628 2,534.95 80.937 16,001.33 68.534 3,742.22 68.526 880.68 81.544 6,347.42 53.565 111,202.76 3,572.25 1,162.50- 2,050.00 9,629.76 44,272.26 2,293.63 386.35 597.05 7,346.67 1,718.78 199.32 5,502.58 400.00 300.00 Page 4 358,530.09 188,308.91 29,521.69 29.522 2,444.43 48.889 1,828.19 52.234 612.50 61.250 2,451.64 32.689 20,000.00 70,478.31 3,000.00 2,555.57 1,671.81 387.50 5,048.36 140,000.00 140,000.00 26.327 103,141.55 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 385.40 9,128.56 111.00 130,922.95 1,500.00 25,047.72 4,600.00 3,653.34 73.067 80,762.35 64.262 850.00 85.000 105.00 21.000 1,547.00 20.832 20,205.04 32.071 883,304.49 32.538 756.00 25.200 3,000.00 20.339 383,549.92 72.727 36,800.00 66.675 1,346.66 44,914.65 150.00 395.00 5,879.00 400.00 2,845.00 1,500.00 42,794.96 1,831,405.51 200.00 2,244.00 11,750.00 143,831.08 18,393.00 180,000.00 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Program: Period Ending: 5/2020 Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 1,415,094.86 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 442.13 6,175.98 41.173 8,824.02 2,917.33 56.211 2,272.67 1,789.93 13,652.18 68.261 6,347.82 1,200.00 1,000.00 59,593.08 85.133 10,406.92 36,900.00 42.414 50,100.00 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtot 135-70040-010-000 Subtot- Program number: Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 .00 5,504,929.00 5,504,929.00 59,366.70 335,891.44 49.044 30,512.00 100.000 1,840.00 56.948 75,000.00 100.000 102,077.11 85.064 59,366.70 7111,320.55 1,220.00 1,220.00 1,220.00 -171941.1. 303,432.61 2,476,262.52 44.983 348,983.56 1,391.00 17,922.89 368,297. 1,220.00- 1,220.00- 73,028,666.48 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account Description 1 1 135-55135-010-001 Lab Analysis for PID Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 1,001.64 50.082 998.36 Page 6 Subtotal: 2,000.00 2,000.00 Mr - 1,001.64 50.082 998.36 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,001.64 50.082 998.36 Department number: Water 5,506,929.00 5,506,929.00 303,432.61 2,477,264.16 44.984 3,029,664.84 glbase_tbam skrolczyk 10:08 06/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: 5/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 Engqinee ing 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 & Repairs 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 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 49,678.38 264,922.83 59.965 3,057.29 15,052.67 45.614 6,872.50 85.532 700.00 5,075.00 56.389 4,948.15 28,560.50 62.728 6,926.71 56,193.26 53.590 392.75 3,271.97 56.248 62.80 522.71 55.138 384.52 2,953.70 65.638 3,225.26 17,033.26 55.858 754.28 3,983.55 55.855 1,008.00 80.000 1,110.20 9,057.10 58.916 38.00 9.500 46.08 46.08 15.360 176,876.17 17,947.33 1,162.50 3,925.00 16,970.50 48,664.74 2,545.03 425.29 1,546.30 13,460.74 3,148.45 252.00 6,315.90 362.00 253.92 Page 7 71,286.42 414,591.13 293,855.87 3,000.00 20.000 5,867.12 48,003.48 54.549 18,113.87 181.139 824.94 20.624 8.92 2,020.80 25.260 200.00 1,032.22 34.407 87.50 612.50 40.833 10,256.66 61,872.84 61.873 2,440.24 23,816.34 59.541 407.91 3,904.09 78.082 11,132.02 84,380.01 52.715 216.00 72.000 420.00- 2,542.85 50.959 109.14 10.914 410.72 26.584 10,088.02 67.253 584.94 11.699 30,000.00 12,000.00 39,996.52 8,113.87- 10,000.00 3,175.06 5,979.20 1,967.78 887.50 38,127.16 16,183.66 150. 1,095.91 75,686.99 200.00 84.00 2,447.15 890.86 1,134.28 5,000.00 2,500.00 4,911.98 450.00 4,415.06 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 1,480.00 2,960.00 10,414.81 83,318.48 54,421.63 490,085.00 5,750.00 46,000.00 190.00 Subtotal: 1,310,669.00 83,186.37 724,789.25 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 368.08 5,106.21 40.850 7,393.79 135-65010-020-000 Uniforms 5,495.00 5,495.00 3,507.93 63.839 1,987.07 135-65030-020-000 Chemicals 20,000.00 20,000.00 2,788.92 19,928.34 99.642 71.66 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 4,994.00 28.537 12,506.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 1,166.53 97.211 33.47 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 101.88 16,534.06 82.670 3,465.94 21.143 11,040.00 72.727 31,244.52 72.727 183,782.00 36.745 79,187.00 180,000.00 9.500 1,810.00 55.299 585,879.75 Page 8 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 111,949.00 111,949.00 288,541.11 288,541.11 294,012.00 59,604.74 6,122.03 130,000.00 489,738.77 1,839,653.21 1,839,653.E 55.422 75.322 54.288 100.000 �19 236,488.00 19,528.26 5,154.97 4 1,317,767 4 1,317,767 glbase_tbam skrolczyk 10:08 06/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: 5/2020 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 1.99 Program: YTD Total 15.92 % of Budget 53.067 Remaining Budget 14.08 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 REFSubtota1: Program number: Department number: Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 150.00 750.00 750.00 1,300.00 1,300.00 4,000.00 4,000.00 5,000.00 5,000.00 2,000.00 2,000.00 123.99 675.00 413.81 90.000 31.832 150.00 75.00 886.19 4,000.00 5,000.00 2,000.00 13,200. 0 13,200.00 12,111.19 — 13,230.00 — 13,230.00 125.98 12,125.27 Board of Directors 13,230.00 13,230.00 125.98 12,125.27 glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 47,423.61 256,791.62 40.871 371,506.38 135-50010-030-000 Overtime 2,000.00 2,000.00 31.77 1.589 1,968.23 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 4,391.41 25,482.92 43.520 33,071.08 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 48,195.28 38.744 76,198.72 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 2,667.95 41.274 3,796.05 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 404.71 39.102 630.29 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 343.91 2,658.84 59.085 1,841.16 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 2,796.86 15,027.94 38.322 24,187.06 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 654.10 3,514.62 38.323 5,656.38 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 864.00 60.000 576.00 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 838.56 47.243 936.44 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 525,790.19 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 52,776.08- 13,098.66 285.00 1,896.92 54,600.00 80,570.16 59.823 54,110.84 88,810.54 65.786 46,189.46 1,560.00 10.400 13,440.00 531.00 5.310 9,469.00 7,658.64 76.586 2,341.36 57,100.00 87.043 8,500.00 4,179.68 46.441 4,820.32 138,870.98 135-60005-030-000 Telephone 23,680.00 23,680.00 2,021.79 12,195.34 51.501 11,484.66 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 99.26 1,815.12 45.378 2,184.88 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 458.22 3,907.56 56.804 2,971.44 135-60025-030-000 Water 1,500.00 1,500.00 228.42- 1,250.60 83.373 249.40 135-60035-030-000 Postage 30,000.00 30,000.00 11,725.51 39.085 18,274.49 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 4,934.27 46,836.29 69.905 20,163.71 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 6,998.39 52,425.26 62.411 31,574.74 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 125.00 12.500 875.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,285.55 71.426 1,714.45 135-60075-030-000 Meetings 400.00 400.00 115.09 28.773 284.91 135-60079-030-000 Public Education 6,000.00 6,000.00 3,971.51 66.192 2,028.49 135-60080-030-000 Schools & Training 6,850.00 6,850.00 1,452.21 21.200 5,397.79 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 77.97 1,098.61 30.990 2,446.39 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 138.04 138.04- 135-60125-030-000 Advertising 2,500.00 2,500.00 1,772.20 70.888 727.80 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 135-69005-030-000 135-69170-030-000 Program number: Description Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments Department number: Administration Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 30 Administration Period Ending: 5/2020 Amended Total Budget Encumb. 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 2,050.00 2,050.00 26,485.00 26,485.00 6,000.00 6,000.00 3,500.00 3,500.00 4,000.00 4,000.00 2,500.00 2,500.00 195,000.00 195,000.00 4,000.00 4,000.00 ,000.00 712.00 ,712.00 Current Month Program: YTD Total 168.00 % of Budget 13.043 Remaining Budget 1,120.00 500.00 17,000.00 2,500.00 361.48 2,050.00 680.97 3,916.21 14.787 22,568.79 504.14 2,935.99 48.933 3,064.01 3,500.00 2,848.53 71.213 1,151.47 2,500.00 1,438.09 28,447.84 14.589 166,552.16 178.50 1,912.60 47.815 2,087.40 30,360.44 111111111157 168,639.56 59 785,516.89 12 991,195.11 59 785,516.89 111111111112 991,195.11 Page 11 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 135-55045-039-000 Le al 135,000.00 135,000.00 1 135-55055-039-000 Auclitintq 33,800.00 33,800.00 1 135-55060-039-000 Appraisal 11,761.00 11,761.00 1 135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00 4,842.50 90,427.89 27,713.27 7,422.04 3,756.00 66.984 81.992 63.107 93.900 44,572.11 6,086.73 4,338.96 244.00 Page 12 Subtotal: 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Program number: 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Department number: Non Departmental 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Expenditures Subtotal 10,638,853.00 10,638,853.00 693,671.79 5,232,858.19 49.186 5,405,994.81 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 54,840.64- 103,999.22- 1,670.939 97,775.22 glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 L Property Taxes -11111 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes (133,944.05) (8.20) (133,952.25) (.20) (133,952.45) (.90) (133,953.35) (37.03) (133,990.38) (120.06) (134,110.44) (4.88) (134,115.32) (5.91) (134,121.23) 25.21 (134,096.02) (16.94) (134,112.96) (81.46) (134,194.42) (29.32) (134,223.74) (20.24) (134,243.98) (49.13) (134,293.11) (66.23) (134,359.34) (46.72) (134,406.06) (22.58) (134,428.64) (74.28) (134,502.92) (46.28) (134,549.20) (59.91) (134,609.11) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (665.06) (134,609.11) ** (134,871.00) Budgeted (261.69) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes (296.98) (1.61) 22.19 (2.40) (3.74) (1.12) (1.42) (298.59) (276.40) (278.80) (282.54) (283.66) (285.08) GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (285.08) (300.00) Budgeted (14.92) Remaining 95 5 Used Account: 135-40015-000-000 Property Taxes/P & I 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes (436.64) (.12) (436.76) (.02) (436.78) (.11) (436.89) (.45) (437.34) (13.29) (450.63) GL GL GL GL GL glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 135-40015-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Beginning Balance Description/Comment Property Taxes/P & I (300.00) Budgeted 168.83 Remaining (436.64) 156 % Used Program: Transaction Detail (1.67) (.10) (7.31) (.57) (.10) (3.46) .03 (2.76) (.27) (.41) (.03) (1.55) Transaction Vendor Name Detail (SUBTOTAL) (452.30) (452.40) (459.71) (460.28) (460.38) (463.84) (463.81) (466.57) (466.84) (467.25) (467.28) (468.83) Page Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (164,253.00) Budgeted (164,253.00) Remaining Account: 135-47000-000-0:- 1134 05/01/2020 UB 05/01/2020 Acct Adjustment UB20200501-20200501 User: 1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User: (2,492,189.86) 0 % Used .00 .00 71.31 (2,492,118.55) (459,635.16) (2,951,753.71) UB UB Account: (6,486,623.00) Budgeted 135-47005-000-000 1139 05/04/2020 UB 05/04/2020 WA Adjustment 1141 05/04/2020 UB 05/04/2020 WA Adjustment 1246 05/05/2020 Swr adj 1247 05/06/2020 swr adj 1195 05/19/2020 UB 05/19/2020 WA Adjustments 1196 05/19/2020 UB 05/19/2020 WA Adjustments 1200 05/20/2020 UB 05/20/2020 WA Adjustment 1233 05/28/2020 UB 05/28/2020 WA Adjustments 1243 05/31/2020 UB 05/31/2020 Billing (3,534,869.29) UB20200504-20200504 User: UB20200504-20200504 User: UB20200505-20200505 User: U820200506-20200506 User: UB20200519-20200519 User: UB20200519-20200519 User: UB20200520-20200520 User: UB20200528-20200528 User: UB20200531-20200531 User: Remaining 46 (1,779,647.58) Used 28.01 (1,779,619.57) 95.08 (1,779,524.49) 118.91 (1,779,405.58) 96.31 (1,779,309.27) 842.15 (1,778,467.12) 87.80 (1,778,379.32) 433.17 (1,777,946.15) 1,027.15 (1,776,919.00) (276,485.14) (2,053,404.14) UB UB UB UB UB UB UB UB UB glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 7 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-47005-00 Sewer (3,503,885.00) Budgeted (1,450,480.86) Remaining Account: 135-47025-000-000 Penalties 1245 05/01/2020 penalty removal UB20200501-20200501 User: 1232 05/28/2020 UB 05/28/2020 Penalty Removal UB20200528-20200528 User: Account: 135-47025-000-000 ,,Penaltie• (112,608.00) Budgeted AccotillEvice Cha 1231 05/21/2020 UB 05/21/2020 NSF Check Account: 135-47035-000-000 Account: 135-47035-000-000 Account: 135-47045-000-000 Account: 135-47045-000-000 (61,533.07) UB20200521-20200521 User: Service Charges (15,150.00) Budgeted 59 % Ueed (51,132.79) 43.45 (51,089.34) UB 14.41 (51,074.93) UB Remaining 45 % Used (9,800.00) (25.00) (9,825.00) UB (5,325.00) Remaining 65 % Used Plumbing Inspections (2,250.00) .00 (2,250.00) Plumbing Inspections Tota (750.00) Budgeted 1,500.00 Remaining 300 % Used Sewer Inspections (1,350.00) .00 (1,350.00) Sewer Inspections Totals: .00 (2,500.00) Budgeted (1,150.00) Remaining 54 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User: Account: 135-47070-000-000 TCCC Effluent Charges (50,000.00) Budgeted Account: 135-49011-00 ome (17,065.60) (8,843.20) (25,908.80) UB (24,091.20) Remaining 52 % Used 1269 05/31/2020 Bank Interest- May (63,617.94) (8,843.20) (25,908.80) ** (1,347.32) (64,965.26) GL glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1269 05/31/2020 Bank Interest- May 1269 05/31/2020 Bank Interest- May Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 Page 8 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) (63,617.94) (1,154.60) (1,262.43) (66,119.86) (67,382.29) GL GL Department Totals: (7,000.00) Budgeted (748,512.43) Monthly Total 1,971.93 Remaining 128 % Used (5,336,857.41) ** (10,645,077.00) Budgeted (5,308,219.59) Remaining 50 % Used Account: 135-49011-000-000 ■ Interest Income Totals: (3,764.35) (67,382.29) ** (120,000.00) Budgeted (52,617.71) Remaining 56 % Used Account: 135-49016-000-000 Cell Tower Revenue 1263 05/29/2020 Cell Tower Rev AT&T (7,072.86) (1,178.81) (8,251.67) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (8,251.67) ** (14,146.00) Budgeted (5,894.33) Remaining 58 % Used Account: 135-49018-000-000 Building Rent Income 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: (4,083.31) (583.33) (4,666.64) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (8,925.00) .00 (8,925.00) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (8,925.00) ** (13,000.00) Budgeted (4,075.00) Remaining 69 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (7,730.28) .00 (7,730.28) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (7,730.28) ** (12,691.00) Budgeted (4,960.72) Remaining 61 % Used Account: 135-49900-000-000 Miscellaneous Income i 1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User: (8,802.09) (169.84) (8,971.93) UB Account: 135-49900-000-000 Miscellaneous Income ■ Totals: (169.84) (8,971.93) ** Department Totals: (7,000.00) Budgeted (748,512.43) Monthly Total 1,971.93 Remaining 128 % Used (5,336,857.41) ** (10,645,077.00) Budgeted (5,308,219.59) Remaining 50 % Used glpdatb2 skrolczyk 10:08 06/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 Page 9 Detailed Accounting Trial Balance Period Ending: 5/2020 Beginning Balance Program: Transaction Transaction Vendor Name Check Source Detail Detail Number (SUBTOTAL) Account: 135-50005-010- Salaries & W 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Salaries & Wages Salaries & Wages Salaries & Wages 192,746.19 15,439.35 208,185.54 PR 15,439.35 223,624.89 PR 15,439.35 239,064.24 PR Account 350,267.00 Budgeted 111,202.76 Remaining 68 % Used ACC'until 1110 05/01/2020 MUD Payroll 5/1/2020 Overtime 1180 05/15/2020 MUD Payroll 5/15/2020 Overtime 1223 05/29/2020 MUD Payroll 5/29/2020 Overtime 11,865.26 515.40 12,380.66 PR 505.40 12,886.06 PR 541.69 13,427.75 PR Aoc 17,000.00 Budgeted 3,572.25 Remaining 79 Used Account: 135-50016-010-000 Longevity Accmmtall Longevity 3,920.00 Budgeted 5,082.50 .00 5,082.50 Totals: (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 1180 05/15/2020 MUD Payroll 5/15/2020 Certification 2,925.00 425.00 3,350.00 PR Account: 135-50017-010-001 Certification Totals: 5,400.00 Budgeted Account: 135-50020-010-000 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement 2,050.00 Remaining 62 % Ueed 20,760.14 1,477.42 22,237.56 PR 1,515.84 23,753.40 PR 1,479.84 25,233.24 PR Account: 135-50020-010-000 34,863.00 Budgeted Account: 135-50026-0 1110 05/01/2020 MUD Payroll 5/1/2020 Medical Insurance 9,629.76 Remaining 72 % Used 34,828.70 2,612.55 37,441.25 PR glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1180 05/15/2020 MUD Payroll 5/15/2020 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2020 JE Detail Description/Comment Page 10 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Medical Insurance 34,828.70 Account: 135-50026-010-8 Medical Insurance 84,326.00 Budgeted Account: 135-50027-010-000 Dental Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Account: Totals: 44,272.26 Remaining 2,114.74 2,612.49 40,053.74 47 % Used 158.32 158.31 2,273.06 2,431.37 PR PR PR 4,725.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance Account: 135-IVision Insurance 767.00 Budgeted 2,293.63 Remaining Account: 135-50029-010-00 Life Insuran 1095 05/01/2020 May A/P Employee Benefits 1122 05/01/2020 May Payroll Benefits Employee LTD & STD 1215 05/21/2020 May A/P cafe 125 plan Account: 135 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Life Insurance & Othe 3,132.00 Budgeted 51 % Used 332.47 s Totals: 386.35 Remaining 50 % Used 24.10 356.57 24.08 380.65 2,206.06 176.88 2,382.94 Humana Inc 132.01 2,514.95 METLIFE GROUP BENEFITS 20.00 2,534.95 BenefitMall 597.05 Remaining 81 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes 7,346.67 Remaining 95 ** PR PR 6414 AP 6417 AP 6441 AP 13,026.95 984.19 14,011.14 PR 999.37 15,010.51 PR 990.82 16,001.33 PR 3,046.60 69 Used 230.18 3,276.78 233.72 3,510.50 PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1223 05/29/2020 MUD Payroll 5/29/2020 Medicare Taxes Account: 135-50 I.0-000 Account: 135-50040-010-000 Account: 135-50040-010-000 3,046.60 231.72 Medicare Taxes Totals: 69 5,461.00 Budgeted 1,718.78 Remaining 69 % Used 3,742.22 PR Unemployment Taxes 880.68 .00 880.68 Unemployment Taxes 1,080.00 Budgeted 199.32 Remaining 82 % Used Account: 135-50045-010- Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May Account: 135-50045-0 kman's Compensation 11,850.00 Budgeted Account: 135-50060-010-000 Account: 135-50060-010-000 Pre-emp Physicals/Testing 5,575.93 771.49 5,502.58 Remaining 54 % Used Pre-emp Physicals/Testing Totals: 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 — Engineer 20,000.00 Budgeted Account: 13580-010-000 e & R 1215 05/21/2020 May A/P Irrigation repair 0 % Used 6,347.42 GL .00 .00 .00 .00 300.00 Remaining 0 % Ueed .00 .00 20,000.00 Remaining 0 % Used 24,431.71 257.25 24,688.96 Stephen Marxer 6463 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1215 05/21/2020 May A/P 1215 05/21/2020 May A/P 1215 05/21/2020 May A/P 1249 05/26/2020 PCards 4/28/2020-5/26/2020 1249 05/26/2020 PCards 4/28/2020-5/26/2020 1249 05/26/2020 PCards 4/28/2020-5/26/2020 1249 05/26/2020 PCards 4/28/2020-5/26/2020 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 5/2020 Beginning Balance irrigation repair Irrigation repair meter boxes 4x4 bushing valves, pressure principles torch head, propane cylinder sod 24,431.71 Program: Transaction Detail 235.74 500.00 3,931.20 3.50 76.65 41.44 44.20 Transaction Vendor Name Detail (SUBTOTAL) 24,924.70 25,424.70 29,355.90 29,359.40 29,436.05 29,477.49 29,521.69 Stephen Marxer Stephen Marxer Core & Main LP ROANOKE WINNELSON CO SC TRACKING SOLUTIONS THE HOME DEPOT #6581 TEX-TURF Page 12 Check Source Number 6463 6463 6444 AP AP AP PC PC PC PC Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,089.98 29,521.69 ** 100,000.00 Budgeted 70,478.31 Remaining 30 5 Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1249 05/26/2020 PCards 1249 05/26/2020 PCards 4/28/2020-5/26/2020 wheel bearing 4/28/2020-5/26/2020 oil change 1,842.56 517.51 84.36 2,360.07 2,444.43 GIERISCH CARE 0050292 KWIK KAR LUBE & TUNE 0 PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 601.87 2,444.43 ** 5,000.00 Budgeted 2,555.57 Remaining 49 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,828.19 .00 1,828.19 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,828.19 ** 3,500.00 Budgeted 1,671.81 Remaining 52 % Used Account: 135-55120-010-000 Cleaning Services 1215 05/21/2020 May A/P Janitorial service -April 525.00 87.50 612.50 MEMBER'S BUILDING MAINTENANCE 6458 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 612.50 ** 1,000.00 Budgeted 387.50 Remaining 61 5 Used Account: 135-55135-010-000 Lab Analysis 2,451.64 .00 2,451.64 glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 Account: 135-55135-010-000 Lab Analysis Totals: .00 2,451.64 ** 7,500.00 Budgeted 5,048.36 Remaining 33 % Used Account: 135-60010-010-000 Communications/Mobiles 1178 05/11/2020 May A/P Cell phones 3,267.94 385.40 3,653.34 VERIZON WIRELESS 6438 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 385.40 3,653.34 ** 5,000.00 Budgeted 1,346.66 Remaining 73 % Used Account: 135-60020-010-000 Electricity 1215 05/21/2020 May A/P Electricity 4/8-5/8 71,633.79 9,128.56 80,762.35 HUDSON ENERGY SERVICES, LLC 6450 AP Account: 135-60020-010-000 Electricity Totals: 9,128.56 80,762.35 ** 125,677.00 Budgeted 44,914.65 Remaining 64 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 850.00 .00 850.00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 850.00 ** 1,000.00 Budgeted 150.00 Remaining 85 % Used Account: 135-60070-010-000 Dues & Memberships 105.00 .00 105.00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 105.00 ** 500.00 Budgeted 395.00 Remaining 21 % Used Account: 135-60080-010-000 Schools & Training 1249 05/26/2020 PCards 4/28/2020-5/26/2020 license renewal J. Ramirez 1,436.00 111.00 1,547.00 TCEQ IND RENEWAL LIC PC Account: 135-60080-010-000 Schools & Training Totals: 111.00 1,547.00 ** 7,426.00 Budgeted 5,879.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program .00 .00 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 Account: 135-60135-010-00: Account: 135-60150-010-0 1251 05/31/2020 May A/P Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2020 Beginning Balance JE Detail Description/Comment Safety Program 400.00 Budgeted Travel & per diem Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) 400.00 Remaining 0 % Used Travel & per diem Totals: 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted TCEQ Fees & Permit TCEQ Fees & Permits 63,000.00 Budgeted 2,845.00 Remaining 0 % Used Totals: 1,500.00 Remaining 20,205.04 0 % Used 42,794.96 Remaining 32 % Used Wholesale Water Wholesale water 752,381.54 Wholesale Water 2,714,710.00 Budgeted Miscellaneous Expenses Miscellaneous Expenses 200.00 Budgeted Property Maintenance .00 .00 .00 .00 .00 20,205.04 130,922.95 883,304.49 CITY OF FORT WORTH 1,831,405.51 Remaining 33 % Used .00 .00 200.00 Remaining 0 % Used 756.00 .00 756.00 Page 14 Check Source Number 6470 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund ACC JE JE JE Number Date Description 1251 05/31/2020 May A/P Account: 135-60285-010-000 Account: 135 1292 05/31/2020 TexPool Transfers May Account: 135-60332-010-00 Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Property Maintenance Tota 3,000.00 Budgeted 2,244.00 Remaining 25 % Used Lawn Equipment & Maintenance Mowing -May Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 11,750.00 Remaining Interfund Transfe- TexPool O&M to 16Swift Rev I&S Interfund Transfer 527,381.00 Budgeted Account: 135-60333-010-000 1292 05/31/2020 TexPool Transfers May 143,831.08 1,500.00 1,500.00 3,000.00 WATTS ELLISON LLC 20 % Used 25,047.72 383,549.92 358,502.20 Remaining Interfund Transfer Out -Reserve TexPool O&M to Rev Bond Resevr 32,200.00 73 Used Account: 135-60333-010-000 X Interfund Transfer Out -Reserve TotlEr 55,193.00 Budgeted 18,393.00 Remaining 67 % Used Account: 135-60334-010-000 erfund Transfer Ou Account: 135-60334-010-000 Interfund Transfer Out 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 1,938.28 Remaining Account: 135-65005-010-000 Fuel & Lube 1236 05/24/2020 Fuel 561.72 Fuel -may 5,733.85 4,600.00 4,600.00 36,800.00 36,800.00 .00 .00 .00 .00 .00 561.72 22 % Used 11.11 442.13 6483 AP GL GL 6,175.98 US Bank Voyager Fleet Systems 6481 AP glpdatb2 skrolczyk 10:08 06/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: 5/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 16 Check Source Number Account: 135-65005-010-000 Fuel & Lube Totals: 442.13 6,175.98 ** 15,000.00 Budgeted 8,824.02 Remaining 41 % Used Account: 135-65010-010-000 Uniforms 2,917.33 .00 2,917.33 Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** _ 5,190.00 Budgeted 2,272.67 Remaining 56 % Used Account: 135-65030-010-000 Chemicals = 1191 05/18/2020 mAY a/p 1251 05/31/2020 May A/P testing supplies chorine 11,862.25 1,008.16 781.77 12,870.41 13,652.18 HACH DPC COMPANY INDUSTRIES, INC 6448 6471 AP AP Account: 135-65030-010-000 Chemicals Totals: 1,789.93 13,652.18 ** 20,000.00 Budgeted 6,347.82 Remaining 68 % 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 59,593.08 .00 59,593.08 Account: 135-65050-010-000 Meter Expense Totals: .00 59,593.08 ** 70,000.00 Budgeted 10,406.92 Remaining 85 % Used Account: 135-65053-010-000 Meter Change Out Program 36,900.00 .00 36,900.00 glpdatb2 skrolczyk 10:08 06/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: 5/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 17 Check Source Number 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 1084 05/01/2020 Capital 1215 05/21/2020 May A/P Asset Fund Corrections 276,524.74 20' gate valve and line stop -f (10,507.78) 69,874.48 266,016.96 335,891.44 REY-MAR CONSTRUCTION 6462 GL AP Account: 135-69005-010-000 Capital Outlays Totals: 59,366.70 335,891.44 ** 684,875.00 Budgeted 348,983.56 Remaining 49 % Used Account: 135-69008-010-000 Short Term Debt -Principal 30,512.00 .00 30,512.00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,512.00 ** 30,512.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 1,840.00 .00 1,840.00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 1,840.00 ** 3,231.00 Budgeted 1,391.00 Remaining 57 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 102,077.11 .00 102,077.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 102,077.11 ** 120,000.00 Budgeted 17,922.89 Remaining 85 % Used Account: 135-70040-010-000 Bond Related Expenses 1300 05/20/2020 AG Fee Refund Tax Series 2020 Refunding Tax Bond Series 2020 1,220.00 1,220.00 ATTORNEY GENERAL/STATE OF TX 6501 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1 Account: 135 1 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 5/2020 Beginning Balance Bond Related Expenses Totals: .00 Budgeted (1,220.00) Remaining 0 % Used Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) 1,221 1,220.00 ** Page 18 Check Source Number glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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 1,001.64 .00 1,001.64 Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,001.64 ** 2,000.00 Budgeted 998.36 Remaining 50 % Used Department 10 Totals: 2,477,264.16 ** 303,432.61 Monthly Total 5,506,929.00 Budgeted 3,029,664.84 Remaining 45 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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- Salaries & Wa 1110 05/01/2020 MUD Payroll 5/1/2020 Salaries & Wages 1180 05/15/2020 MUD Payroll 5/15/2020 Salaries & Wages 1223 05/29/2020 MUD Payroll 5/29/2020 Salaries & Wages Account Iies & Wages 441,799.00 Budgeted Account: 135-50010-020-00 1110 05/01/2020 MUD Payroll 5/1/2020 Overtime 1180 05/15/2020 MUD Payroll 5/15/2020 Overtime 1223 05/29/2020 MUD Payroll 5/29/2020 Overtime 215,244.45 16,559.46 231,803.91 PR 16,559.46 248,363.37 PR 16,559.46 264,922.83 PR 176,876.17 Remaining 60 % Used 11,995.38 329.19 12,324.57 PR 1,471.69 13,796.26 PR 1,256.41 15,052.67 PR Aoc 33,000.00 Budgeted 17,947.33 Remaining 46 Used Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity 8,035.00 Budgeted Account: 135 Certification 1110 05/01/2020 MUD Payroll 5/1/2020 Certification 1180 05/15/2020 MUD Payroll 5/15/2020 Certification Certification 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement 6,872.50 .00 6,872.50 Totals: 1,162.50 Remaining 86 % Used 4,375.00 3,925.00 Remaining 56 % Used 23,612.35 etirement Totals: 45,531.00 Budgeted Ac Medical Insurance 16,970.50 Remaining 63 % Used 75.00 4,450.00 625.00 5,075.00 PR PR 1,570.84 25,183.19 PR 1,727.55 26,910.74 PR 1,649.76 28,560.50 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1110 05/01/2020 MUD Payroll 5/1/2020 Medical Insurance 49,266.55 1180 05/15/2020 MUD Payroll 5/15/2020 Medical Insurance 3,463.38 52,729.93 3,463.33 56,193.26 PR PR Accal1111035-50026-020 Medical Insurance Totals: 104,858.00 Budgeted Account: 135-50027-020-009 Dental Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Account: 135-50027-020-000 limiEcount: 135-1028-020-00 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insur- 5,817.00 Budgeted Vision Insurance Vision Insurance 48,664.74 Remaining 54 % Used 2,545.03 Remaining 2,879.22 459.91 56 Used 196.39 196.36 3,075.61 3,271.97 31.40 491.31 31.40 522.71 PR PR PR PR Account: 135 -50028 -020 - Vision Insurance Totals: Account: 135-50029-020-000 1095 05/01/2020 May A/P 1122 05/01/2020 May Payroll Benefits 1215 05/21/2020 May A/P Account: 135-50029-020-000 Account: 135-50030-020-000 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135-50030-020-000 Account: 135-50035-0 1110 05/01/2020 MUD Payroll 5/1/2020 948.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD cafe 125 plan Life Insurance & Other 4,500.00 Budgeted 425.29 Remaining 55 % Used 2,569.18 186.78 2,755.96 Humana Inc 165.74 2,921.70 METLIFE GROUP BENEFITS 32.00 2,953.70 BenefitMall 1,546.30 Remaining 66 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 30,494.00 Budgeted Faxen ■ Medicare Taxes 13,808.00 1,026.69 1,091.37 1,107.20 13,460.74 Remaining 56 % Used 14,834.69 15,926.06 17,033.26 6414 AP 6417 AP 6441 AP PR PR PR 3,229.27 240.13 3,469.40 PR glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 22 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Medicare Taxes Medicare Taxes Acc<I Medicare Taxes 7,132.00 Budgeted Account: 135-50040-020-000 Unemployment Taxes Account Unemployment Taxes 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May 3,229.27 255.22 3,724.62 PR 258.93 3,983.55 PR Totals: 3,148.45 Remaining 56 % Used 1,008.00 .00 1,008.00 252.00 Remaining 80 % Used Account: 135-50045-020- Workman's Compensation Tot - 15,373.00 Budgeted 6,315.90 Remaining 7,946.90 1,110.20 59 % Used 9,057.10 GL Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 Pre-emp Physicals/Testing 400.00 Budgeted Account: 135-50070-020-0' 1249 05/26/2020 PCarde 4/28/2020-5/26/2020 lunch 362.00 Remaining or WWTP employees Account: 135-50070-02 Employee Relations 300.00 Budgeted 38.00 10 % Used 253.92 Remaining 15 % Used .00 38.00 46.08 46.08 MARCOS PIZZA 5143 PC Account: 135-55005-020-000 . Engineering .00 .00 Account: 135-55005-020-000 Engineering T 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 23 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 1191 05/18/2020 mAY a/p 1191 05/18/2020 mAY a/p 1191 05/18/2020 mAY a/p replace float 1191 05/18/2020 mAY a/p replace light fixtures 1191 05/18/2020 mAY a/p replace ballasts in press room 1191 05/18/2020 mAY a/p install lights under shoot 1249 05/26/2020 PCards 4/28/2020-5/26/2020 hose and accessories 42,136.36 632.00 490.00 750.00 1,460.00 774.00 1,310.00 451.12 42,768.36 DHS AUTOMATION, INC 43,258.36 DHS AUTOMATION, INC 44,008.36 DHS AUTOMATION, INC 45,468.36 DHS AUTOMATION, INC 46,242.36 DHS AUTOMATION, INC 47,552.36 DHS AUTOMATION, INC 48,003.48 IN *HOSE TECH USA 6446 AP 6446 AP 6446 AP 6446 AP 6446 AP 6446 AP PC Account: 135-55080-020-000"1111 Maintenance & Repairs Totals: 5,867.12 48,003.48 ** 88,000.00 Budgeted 39,996.52 Remaining 55 % Used Account: 135-55081-020-000 Mainten & Repairs Collections ' 18,113.87 .00 18,113.87 Account: 135-55081-020-000 Mainten & Repairs Collections Totals: .00 18,113.87 ** 10,000.00 Budgeted (8,113.87) Remaining 181 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 824.94 .00 824.94 Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 824.94 ** 4,000.00 Budgeted 3,175.06 Remaining 21 % Used Account: 135-55091-020-000 Veh Maintenance Collections 1249 05/26/2020 PCards 4/28/2020-5/26/2020 gas cap 2,011.88 8.92 2,020.80 ROANOKE AUTO SUPPLY LT PC glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC Page 24 Veh Maintenance Collections Totals: 8,000.00 Budgeted 5,979.20 Remaining Maintenance-Backhoe/SkidLoader 1251 05/31/2020 May A/P 1 yr JD -Link renewal (backhoe) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 1,967.78 Remaining Account: 135-55120-020-000 Cleaning Services 1215 05/21/2020 May A/P Janitorial service -April Account: 135-55120-020-000 Cleaning Sery cec 1,500.00 Budgeted Account: 135-55125-020-000 1178 05/11/2020 May A/P 1251 05/31/2020 May A/P 1251 05/31/2020 May A/P 1251 05/31/2020 May A/P Account: 135-55125-020-000 Dumpster Services sludge haul off sludge haul off sludge haul off sludge haul off Dumpster Services 100,000.00 Budgeted 887.50 Remaining 8_ 2,020.80 25 % Used 832.22 200.00 34 % Used 1,032.22 RIO Equipment Co 6477 AP 200.00 1,032.22 ** 525.00 87.50 612.50 MEMBER'S BUILDING MAINTENANCE 6458 AP 51,616.18 41 Used 38,127.16 Remaining 62 % Used 2,471.32 3,402.56 3,317.62 1,065.16 54,087.50 L.H. CHANEY MATERIALS, INC. 57,490.06 L.H. CHANEY MATERIALS, INC. 60,807.68 L.H. CHANEY MATERIALS, INC. 61,872.84 L.H. CHANEY MATERIALS, INC. 6428 AP 6474 AP 6474 AP 6474 AP 5-55135-020-000 ' Lab Analysis 1178 05/11/2020 May A/P lab testing 21,376.10 341.55 21,717.65 OXIDOR LABORATORIES LLC 6431 AP 1178 05/11/2020 May A/P lab testing 241.50 21,959.15 OXIDOR LABORATORIES LLC 6431 AP 1191 05/18/2020 mAY a/p lab testing 326.70 22,285.85 OXIDOR LABORATORIES LLC 6461 AP 1191 05/18/2020 mAY a/p lab testing 241.50 22,527.35 OXIDOR LABORATORIES LLC 6461 AP 1215 05/21/2020 May A/P lab testing 341.55 22,868.90 OXIDOR LABORATORIES LLC 6461 AP 1215 05/21/2020 May A/P lab testing 241.50 23,110.40 OXIDOR LABORATORIES LLC 6461 AP 1249 05/26/2020 PCards 4/28/2020-5/26/2020 shipping for lab analysis 122.89 23,233.29 POSTNET TX193 PC 1251 05/31/2020 May A/P lab testing 341.55 23,574.84 OXIDOR LABORATORIES LLC 6476 AP 1251 05/31/2020 May A/P lab testing 241.50 23,816.34 OXIDOR LABORATORIES LLC 6476 AP Lab Analysis 40,000.00 Budgeted 16,183.66 Remaining 60 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-60010-020-00 1178 05/11/2020 May A/P Account: 135-60010-02 Account: 135-60020-020-000 1191 05/18/2020 mAY a/p 1215 05/21/2020 May A/P Communications/Mobiles Cell phones 3,496.18 407.91 Communications/Mobiles Tota 5,000.00 Budgeted 1,095.91 Remaining 78 % Used Electric electricity 4/1-5/5 73,247.99 Electricity 4/8-5/8 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Account: 135-60020-020-000 Ole,, 160,067.00 Budgeted 3,904.09 VERIZON WIRELESS 6438 AP 528.61 73,776.60 TRI COUNTY ELECTRIC 6467 AP 10,912.04 84,688.64 HUDSON ENERGY SERVICES, LLC 6450 AP (308.63) 84,380.01 AR 75,686.99 Remaining 53 % Used Account: 135-60066-020-000 Publications/Books/Subscripts Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 Account: 135-60070-020-000 Dues & Memberships Dues & Memberships 300.00 Budgeted Account: 135-60080-020-000 Dols 7F aining 1249 05/26/2020 PCards 4/28/2020-5/26/2020 F.Isola Class Refund .00 .00 0 % Used 216.00 84.00 Remaining 72 % Used Account: 135-60080-020-000 iols & Training Total Account: 135-60090-020-000 4,990.00 Budgeted - Safety Program Account: 135-60090-020-000 Safety Program 1,000.00 Budgeted 2,447.15 Remaining 2,962.85 109.14 51 % Used 890.86 Remaining 11 % Used .00 216.00 2,542.85 TEEX ECOMMERCE .00 109.14 (420.00) PC glpdatb2 skrolczyk 10:08 06/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: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 Travel & per diem Totals: 1,545.00 Budgeted 410.72 1,134.28 Remaining 27 % Used .00 410.72 410.72 ** Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Rent/Lease Equipment 5,000.00 Budgeted Account: 135-60125-020-000 Advertising Account: 135-60125-020-000 Advertising 2,500.00 Budgeted Account: 135-60135-020-000 TCEQ Fees & Fermi Account: 135-60135-020-000 TCEQ Fees & Permits 15,000.00 Budgeted Account: 135-60245-020-000 xpense Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 5,000.00 Remaining 2,500.00 Remaining 10,088.02 4,911.98 Remaining 450.00 Remaining 584.94 Totals: 0 5 Used .00 .00 .00 0 % Used 67 % Used 0 % Used 4,415.06 Remaining 12 % Used 0 .00 ** .00 10,088.02 .00 .00 .00 584.94 Page 26 Check Source Number Account: 135-60285-020-000 Lawn Equipment & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1251 05/31/2020 May A/P Account: 135-6028 Account: 135-60331-020-000 1292 05/31/2020 TexPOol Transfers May Account: 135-60331-020-000 Mowing -May Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 11,040.00 Remaining Interfund Transfer Out -Tax I&S J TexPool O&M to I&S- PID Debt Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 31,244.52 Account: 135-&0332-020-000 Interfund Rev I&S 1292 05/31/2020 TexPool Transfers May Remaining TexPool O&M to Rev Bd WWTP I&S 1,480.00 72,903.67 435,663.37 -r Out -Rev I&S Tota 673,867.00 Budgeted 183,782.00 Remaining Account: 135-60333-020-000 1292 05/31/2020 TexPool Transfers May Account '0 1,480.00 1,48 21 % Used 10,414.81 73 % Used 2,960.00 WATTS ELLISON LLC 83,318.48 54,421.63 490,085.00 54,421.63 73 % Used Interfund Transfer Out -Reserve TexPool O&M to Rev Bond Resevr 40,250.00 5,750.00 46,000.00 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 79,187.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-020-000 Furniture/Equipment < $5000 Account: 135-60360-020-000 e/Equipment < $500 2,000.00 Budgeted Account: 135-65005-020-000 1236 05/24/2020 Fuel Fuel -may 1,810.00 Remaining 190.00 37 % Used .00 .00 0 % Used 10 .00 Used 190.00 6483 AP GL GL GL 4,738.13 368.08 5,106.21 US Bank Voyager Fleet Systeme 6481 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 Fuel & Lube Totals: Account: 135-65010-020-000 12,500.00 Budgeted 7,393.79 Remaining RP Uniforms Account: 135-65010-020-000 43. 3,507.93 Ueed Uniforms - Totals: 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020 Chemicals 1178 05/11/2020 May A/P Sodium Hypo 1191 05/18/2020 mAY a/p Defoamer 1251 05/31/2020 May A/P Sodium Hypo Account: 135-65030-020-00' Chemicals 20,000.00 Budgeted Account: 135-65031-020-000 Chemicals Collections Account: 135-65031-020-000 Chemicals Collections 17,500.00 Budgeted Account: 135-65035-020-000 Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 MagrrifC=3W Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 71.66 Remaining 12,506.00 Remaining 1,200.00 Remaining Totals: 17,139.42 .00 3,507.93 580.00 1,628.92 580.00 100 5 Used 4,994.00 1,166.53 29 % Used 0 % Used 33.47 Remaining 97 % Used 17,719.42 Valley Solvent Company, INC 19,348.34 MARYLAND BIOCHEMICAL CO, INC 19,928.34 Valley Solvent Company, INC .00 4,994.00 .00 .00 .00 1,166.53 6437 AP 6456 AP 6482 AP Account: 135-65045-020-000 Lab Supplies glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1249 05/26/2020 PCards 4/28/2020-5/26/2020 distilled water 16,432.18 1249 05/26/2020 PCards 4/28/2020-5/26/2020 black light Acc=5-65045-02 Lab Supplies 20,000.00 Budgeted 3.96 16,436.14 TOM THUMB #1789 97.92 16,534.06 WWW.INTERLIGHT.BIZ 101.88 16,534.06 ** 3,465.94 Remaining 83 % Used PC PC Account: 135-69005-020-000 Capital Outlays 1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517 182,063.00 (9,525.00) 172,538.00 GL 1178 05/11/2020 May A/P WWTP0 49,976.00 222,516.00 REY-MAR CONSTRUCTION 6432 AP 1178 05/11/2020 May A/P WWTP building and sound wall 71,496.00 294,012.00 REY-MAR CONSTRUCTION 6432 AP Acc 69005-020-000 Capital Outlays 530,500.00 Budgeted 236,488.00 Remaining 55 % Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 19,528.26 Remaining 59,604.74 .00 59,604.74 75 % Used Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Term Debt -Inter 11,277.00 Budgeted 5,154.97 Remaining 6,122.03 54 Used .00 6,122.03 Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining Department 20 Totals: 100 % Used .00 130,000.00 1,839,653.21 ** 288,541.11 Monthly Total 3,157,421.00 Budgeted 1,317,767.79 Remaining 58 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 26 Board of Directors Period Ending: 5/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 30 Check Source Number Account: 135-50045-026-000 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May 13.93 1.99 15.92 GL Account: 135-50045-026-000 Workman's Compensation Totals: 1.99 15.92 ** 30.00 Budgeted 14.08 Remaining 53 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 675.00 .00 675.00 Account: 135-60070-026-000 Dues & Memberships Totals: .00 675.00 ** 750.00 Budgeted 75.00 Remaining 90 % Used Account: 135-60075-026-000 Meetings 1249 05/26/2020 PCards 4/28/2020-5/26/2020 zoom meetings subscription 289.82 123.99 413.81 ZOOM.US PC Account: 135-60075-026-000 Meetings Totals: 123.99 413.81 ** 1,300.00 Budgeted 886.19 Remaining 32 % Used Account: 135-60080-026-000 Schools & Training .00 .00 Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 125.98 Monthly Total 13,230.00 Budgeted 1,104.73 ** 12,125.27 Remaining 8 % Used glpdatb2 skrolczyk 10:08 06/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: 5/2020 JE Detail Description/Comment Page 32 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ACCOunt: 135-50005-030- Salaries & W 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Salaries & Wages Salaries & Wages Salaries & Wages 209,368.01 15,807.87 225,175.88 PR 15,807.87 240,983.75 PR 15,807.87 256,791.62 PR Account 628,298.00 Budgeted 371,506.38 Remaining 41 % Used Account: 135-50010-030-000 31.77 .00 31.77 Account: 135-50010-030-000 2,000.00 Budgeted Longevit, Account: 135-50016-030-000 Longevity Totals: 2,208.00 Budgeted .50 Remaining 1,968.23 Remaining 2 % Used Account: 135-50020-030-000 irement 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement 2,207.50 .00 2,207.50 100 % Used 21,091.51 1,463.81 22,555.32 PR 1,463.82 24,019.14 PR 1,463.78 25,482.92 PR Account: 135-50020-030-000 Account: 135-50026-030-000 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Account: 135 58,554.00 Budgeted 33,071.08 Remaining 44 % Used Medical Insurance Medical Insurance 41,849.51 Medical Insurance 76,198.72 Remaining 39 % Used 2,318.20 Medical Insurance 124,394.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Dental Insurance Dental Insurance 3,172.91 45,022.42 PR 3,172.86 48,195.28 PR 174.88 2,493.08 PR 174.87 2,667.95 PR glpdatb2 skrolczyk 10:08 06/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: 5/2020 Page 33 JE Detail Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Description/Comment Dental Insurance 6,464.00 Budgeted Account: ion Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance Account: 135-50028-030-000 Vision Insurance 1,035.00 Budgeted Account: 135-50029 - 1095 05/01/2020 May A/P 1122 05/01/2020 May Payroll Benefits 1215 05/21/2020 May A/P Account: 135- 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 3,796.05 Employee Benefits Employee LTD & STD cafe 125 plan Remaining 353.03 43. Used 25.85 378.88 25.83 404.71 630.29 Remaining 39 % Used Life Insurance & Other Totals: 4,500.00 Budgeted 2,314.93 176.22 2,491.15 Humana Inc 151.69 2,642.84 METLIFE GROUP BENEFITS 16.00 2,658.84 BenefitMall 1,841.16 Remaining 59 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Account: Social Security Taxes 39,215.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 9,171.00 Budgeted Account: 135-5004 Unemployment Taxes 84 ** PR PR 6414 AP 6417 AP 6441 AP 12,231.08 909.98 13,141.06 PR 906.78 14,047.84 PR 980.10 15,027.94 PR 24,187.06 Remaining 38 % Used 2,860.52 212.82 3,073.34 PR 212.06 3,285.40 PR 229.22 3,514.62 PR 5,656.38 Remaining 38 % Used 864.00 .00 864.00 glpdatb2 ekrolczyk 10:08 06/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: 5/2020 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,440.00 Budgeted Acc410 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Ac Workman's Compensation 1,775.00 Budgeted Pre-emp Physicals/Testing Tota 576.00 Remaining 733.74 Totals: 936.44 Remaining Pre-emp Physicals/Testing To a e• 500.00 Budgeted 500.00 Remaining Employee Relations Employee Relations 8,000.00 Budgeted 1215 05/21/2020 May A/P 1249 05/26/2020 PCards 4/28/2020-5/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1309 05/31/2020 PCarde 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCarde 4/28/2020-5/26/2020 PCarde 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 Recode M3 Annual Soft & Supprt Account: 135111111111111E - Internet -may website Website internet internet Internet' adobe subscription Internet internet Internet bank rec software Recode 134,681.00 Budgeted 3,078.10 4,921.90 Remaining Program: Transaction Detail 60 % Used 47 % Used 0 % Used 38 % Used 104.82 .00 .00 Transaction Vendor Name Detail (SUBTOTAL) 838.56 .00 3,078.10 133,346.24 899.00 134,245.24 Charter Communications 10.77 134,256.01 FS *DIGITALWAVE 18.17 134,274.18 DNS*GODADDY.COM 52.37 134,326.55 ATT*BILL PAYMENT 42.37 134,368.92 ATT*SILL PAYMENT 42.37 134,411.29 ATT*BILL PAYMENT 36.78 134,448.07 ADOBE ACROPRO SUBS 42.37 134,490.44 ATT*BILL PAYMENT 42.35 134,532.79 ATT*BILL PAYMENT 42.37 134,575.16 ATT*BILL PAYMENT 595.00 135,170.16 CONWAY COMPANY CPAS (54,600.00) 80,570.16 54,110.84 Remaining 60 % Used Page 34 Check Source Number 6443 GL AP PC PC PC PC PC PC PC PC PC PC GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 1 Independent Labor 1251 05/31/2020 May A/P GM search Final invoice Account: 135-55070-03 Independent Labor 135,000.00 Budgeted Account: 135-55080-030-00r Maintenance & Repairs 1191 05/18/2020 mAY a/p Account: 75,711.88 13,098.66 88,810.54 Strategic Government Resources 6478 AP 46,189.46 Remaining 66 % Used a/c in office 1,275.00 Maintenance & Repairs Totals: 15,000.00 Budgeted 13,440.00 Remaining 10 % Used 285.00 1,560.00 BRANDON R REED 6442 AP Generator Maint. and Repair Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Account: 135-55120-030-000 1215 05/21/2020 May A/P Account: 135-55120-030-000 531.00 Cleaning Services Janitorial service -April 5,761.72 .."Lning Services 10,000.00 Budgeted Account: 135-55160-030 1309 05/31/2020 Recode M3 Annual Soft & Supprt Recode 2,341.36 Remaining Account: 135-11111Mili Professional Outside Servic 65,600.00 Budgeted 8,500.00 Remaining 2,500.00 5 % Used 77 % Used 87 % Used .00 531.00 .00 1,896.92 7,658.64 MEMBER'S BUILDING MAINTENANCE 6458 AP 1,896.92 54,600 00 57,100.00 GL Account: 135-55205-030-000 Utility Billing Contract Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 4,820.32 Remaining 4,179.68 46 % Used .00 4,179.68 Account: 135-60005-030-000 Telephone glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1090 05/01/2020 May A'P Answering service -May 10,173.55 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 answering service 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Account: 135-60005-030-00 Telephone 23,680.00 Budgeted 1178 05/11/2020 May A/P Communications/Mobiles Cell phones 1178 05/11/2020 May A/P Cell phones 1180 05/15/2020 MUD Payroll 5/15/2020 Communications/Mobiles 11,484.66 Account: 135-60010-0 Account: 135-60020-030-000 1215 05/21/2020 May A/P Account: 135-60020-030-000 Account: 135-60025-03' 1251 05/31/2020 May A/P 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Communications/Mobile 4,000.00 Budgeted 2,184.88 Electricity/Gas Gexa energy 3/10-4/08 Electricity 6,879.00 Budgeted water -May 2,971.44 Account: 13 Water 1,500.00 Budgeted Remaining Remaining Remaining 571.98 10,745.53 KEYSTONE PARK SECRETARIAL 6361 AP 466.71 11,212.24 ATT*BUS PHONE PMT PC 797.51 12,009.75 ATT*BUS PHONE PMT PC 175.30 12,185.05 ATT*BILL PAYMENT PC 14.99 12,200.04 RINGCENTRAL, INC PC 175.30 12,375.34 ATT*BILL PAYMENT PC (180.00) 12,195.34 AR 52 % Used 1,715.86 (150.00) 1,565.86 VERIZON WIRELESS 6438 AP 99.26 1,665.12 VERIZON WIRELESS 6438 AP 150.00 1,815.12 PR 3,449.34 1,479.02 45 5 Used 57 Used Totals: 249.40 Remaining 83 5 Ueed 458.22 47.45 (275.87) 3,907.56 TOWN OF TROPHY CLUB 1,526.47 1,250.60 TROPHY CLUB MUD (WATER BILLS) 6466 AP 6480 AP AR Account: 135-60035-030-000 Postage Account: 135-60035-030-000 Postag= 30,000.00 Budgeted 18,274.49 Remaining 11,725.51 39 .00 Used 11,725.51 Account: 135-60040-030-000 Service Chargee & Fees glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1268 05/31/2020 Pace Credit Card Fees 1268 05/31/2020 Pace Credit Card Fees Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 5/2020 Page 37 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 41,902.02 4,924.49 9.78 46,826.51 46,836.29 GL GL Account: 135-60040-030-000 Service Charges & Fees Totals: 4,934.27 46,836.29 ** 67,000.00 Budgeted 20,163.71 Remaining 70 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 73 05/01/2020 Insurance/Wrk Comp Expense May 45,426.87 6,998.39 52,425.26 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 52,425.26 ** 84,000.00 Budgeted 31,574.74 Remaining 62 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 125.00 .00 125.00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 125.00 ** 1,000.00 Budgeted 875.00 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 4,285.55 .00 4,285.55 Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,285.55 ** 6,000.00 Budgeted 1,714.45 Remaining 71 % Used Account: 135-60075-030-000 Meetings 115.09 .00 115.09 Account: 135-60075-030-000 Meetings Totals: .00 115.09 ** 400.00 Budgeted 284.91 Remaining 29 % Used Account: 135-60079-030-000 Public Education glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 38 Account: 135-60079-030-000 Public Education 6,000.00 Budgeted Account: 135-60080-030-000 Schools & Training Account: 135-60080-030-000 Schools & Training 6,850.00 Budgeted 3,971.51 .00 3,971.51 Totals: 2,028.49 Remaining 66 % Used 5,397.79 Remaining Account: 135-60100-030- Travel & per di 1249 05/26/2020 PCards 4/28/2020-5/26/2020 GM interview hotel stay vel & per diem 3,545.00 Budgeted Account Physicals/Testing Account Physicals/Testing 200.00 Budgeted Account: 135-60115-030-000 Elections Account: 135-60115-030-000 als: 2,446.39 Remaining Elections Totals: .00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted 1,452.21 1,020.64 .00 21 % Used 77.97 31 % Used 7 1,452.21 1,098.61 HAMPTON INN HOTELS .00 .00 138.04 .00 138.04 Totals: 200.00 Remaining 0 % Used (138.04) Remaining 0 % Ueed PC 1,772.20 .00 1,772.20 727.80 Remaining 71 % Used Account: 135-60235-030-000 168.00 .00 168.00 glpdatb2 skrolczyk 10:08 06/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: 5/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 39 Check Source Number Account: 135-60235-030-000 Security Totals: .00 168.00 ** 1,288.00 Budgeted 1,120.00 Remaining 13 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniform .00 .00 Account: 135-65010-030-000 i Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 1249 05/26/2020 PCards 1251 05/31/2020 May A/P 4/28/2020-5/26/2020 computer monitor GM monitors 3,235.24 199.99 480.98 3,435.23 3,916.21 AMZN MRTP US*M74R02PZO M3 Networks 6475 PC AP Account: 135-65055-030-000 Hardware Totals: 680.97 3,916.21 ** 26,485.00 Budgeted 22,568.79 Remaining 15 % Used Account: 135-65085-030-000 Office Supplies 1215 05/21/2020 May A/P office supplies 2,431.85 55.36 2,487.21 OFFICE DEPOT, INC 6460 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1249 05/26/2020 PCards 4/28/2020-5/26/2020 ink cartridges 2,431.85 448.78 2,935.99 AMAZON.COM*MC63U99W1 PC Account: 135-65085-030-0 Office Supplies Totals: 2,935.99 ** Account: 135-65090-030-000 6,000.00 Budgeted 3,064.01 Remaining 49 % Used Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Tot .00 3,500.00 Budgeted 3,500.00 Remaining 0 5 Used Account: 135-65095-030-000 Maintenance Supplies Account: 135-65095-030-000 Maintenance Supplies 4,000.00 Budgeted Account: 135-65105-030-000 Pri, 2,848.53 1,151.47 Remaining 71 5 Used .00 2,848.53 .00 .00 Account: 135-65105-030-000 Tota 2,500.00 Remaining 0 5 Used Account: 135-69005-030-000 1215 05/21/2020 May A/P 1266 05/31/2020 May A/P 1191 05/18/2020 mAY a/p 1251 05/31/2020 May A/P 2,500.00 Budgeted Capital Outlays TCMUD boundary TCMUD boundary Capital Outlaill Totals: 195,000.00 Budgeted 27,009.75 1,170.62 166,552.16 Remaining 15 % Used Copier Lease Installments copier lease -may copies 28,180.37 Halff Associates, INC 6447 AP 267.47 28,447.84 Halff Associates, INC 28,447.84 ** 1,734.10 165.00 1,899.10 TIAA COMMERCIAL FINANCE 13.50 1,912.60 KYOCERA DOCUMENT SOLUTIONS Account: 135-69170-030-00 ase Installments 4,000.00 Budgeted 2,087.40 Remaining 48 b Ueed 6509 AP 6465 AP 6473 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1 Department 30 Totals: 785,516.89 ** 96,729.59 Monthly Total 1,776,712.00 Budgeted 991,195.11 Remaining 44 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039- Legal Ac 1215 05/21/2020 May A/P legal Legal 135,000.00 Budgeted Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 Auditing 33,800.00 Budgeted Account: 135-55060-039-000 Appraisal Account: 135-55060-039-000 Appraisal 11,761.00 Budgeted Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 Tax Admin Fees 4,000.00 Budgeted Department 39 Totals: Fund 135 Totals: 4,842.50 Monthly Total (54,840.64) Monthly Total 85,585.39 4,842.50 90,427.89 McLean & Howard, L.L.P. 67 % Used .00 27,713.27 44,572.11 Remaining 27,713.27 6,086.73 Remaining 7,422.04 4,338.96 Remaining 244.00 3,756.00 Remaining 82 % Used .00 63 % Used 94 Used .00 7,422.04 3,756.00 129,319.20 ** 184,561.00 Budgeted 55,241.80 Remaining 70 % Used (103,999.22) (6,224.00) Budgeted 97,775.22 Remaining ########## 6457 AP glpdatb2 skrolczyk 10:08 06/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: 5/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 43 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 MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 504,533 TOTAL ASSETS 504,533 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (62,534) TOTAL FUND BALANCE (180,944) TOTAL LIABILITIES AND FUND BALANCE 504,533 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 118.15- 4,812.81- 4,812.81 Page 14 Subtotal: 118.15- 4,812.81- 4,812.81 Program number: 118.15- 4,812.81- 4,812.81 Department number: Revenues 118.15- 4,812.81- 4,812.81 Revenues Subtotal 118.15- 4,812.81- 4,812.81 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 5/2020 Adopted Amended Total Current Budget Budget Encumb. Month 15,077.50 Program: YTD Total 67,346.41 % of Remaining Budget Budget 67,346.41 - Page 15 Subtotal: 111111 15,077.50 67,346.41 67,346.41 - Program number: 15,077.50 67,346.41 67,346.41 - Department number: Wastewater 15,077.50 67,346.41 67,346.41 - Expenditures Subtotal 15,077.50 67,346.41 67,346.41 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 14,959.35 62,533.60 62,533.60- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/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 1269 05/31/2020 Bank Interest- May Interest Income (4,694.66) (118.15) (4,812.81) GL Account: 517-49011-000-000 Interest Income Totals: Department Totals: .00 Budgeted 4,812.81 Remaining 0 % Used (118.15) Monthly Total .00 Budgeted (4,812.81) ** 4,812.81 Remaining 0 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 5/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Account: 517-69005-020- Capital Outl 1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517 1215 05/21/2020 May A/P Crane review engineering 1215 05/21/2020 May A/P WWTP legal Department 20 Totals: apital Outlays .00 Budgeted 52,268.91 Totals: (67,346.41) Remaining 0 % Used 15,077.50 Monthly Total .00 Budgeted 9,525.00 4,065.00 1,487.50 61,793.91 65,858.91 Wise, Janney, Eletner Assoc 67,346.41 WHITAKER CHALK SWINDLE 67,346.41 ** (67,346.41) Remaining 0 % Used Fund 517 Totals: 62,533.60 14,959.35 Monthly Total .00 Budgeted (62,533.60) Remaining 0 % Used Page 45 Check Source Number GL 6469 AP 6468 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MAY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,940 TOTAL ASSETS 784,940 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 698,648 4,602 703,249 784,940 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 6.45- 4,601.70- 4,601.70 Page 16 Subtotal: 6.45- 4,601.70- 4,601.70 Program number: 6.45- 4,601.70- 4,601.70 Department number: Revenues 6.45- 4,601.70- 4,601.70 Revenues Subtotal 6.45- 4,601.70- 4,601.70 I Fund number: 519 2016 Rev Bond Const -SWIFT glpdatb2 skrolczyk 10:06 06/10/20 Fund: 519 2016 Rev Bond Const -SWIFT JE JE JE Number Date Description Account: 519-49011-000-000 1269 05/31/2020 Bank Interest- May Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Interest Income (4,595.25) (6.45) (4,601.70) GL Account: 519-49011-000-000 Interest Income Totals: (6.45) (4,601.70) ** Department Totals: Fund 519 Totals: .00 Budgeted 4,601.70 Remaining 0 % Used (6.45) Monthly Total .00 Budgeted (6.45) Monthly Total .00 Budgeted (4,601.70) ** 4,601.70 Remaining 0 % Used (4,601.70) 4,601.70 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MAY 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 418,569 INVESTMENTS 3,892,394 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,310,963 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 2,658 TOTAL LIABILITIES 2,658 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (145,985) TOTAL FUND BALANCE 4,308,305 TOTAL LIABILITIES AND FUND BALANCE 4,310,963 glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 132.92- 27,579.97- 27,579.97 Page 17 Subtotal: 132.92- 27,579.97- 27,579.97 Program number: 132.92- 27,579.97- 27,579.97 Department number: 132.92- 27,579.97- 27,579.97 Revenues Subtotal 132.92- 27,579.97- 27,579.97 glbase_tbam skrolczyk 10:08 06/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: 5/2020 Adopted Amended Total Current Budget Budget Encumb. Month 28,983.97 Program: YTD Total 173,564.78 % of Remaining Budget Budget 173,564.78 - Page 18 Subtotal: 111111 28,983.97 173,564.78 173,564.78 - Program number: 28,983.97 173,564.78 173,564.78 - Department number: Water Department 28,983.97 173,564.78 173,564.78 - Expenditures Subtotal 28,983.97 173,564.78 173,564.78 - Fund number: 520 Revenue Bond 16" Waterline 28,851.05 145,984.81 145,984.81- glpdatb2 ekrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/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: 520-49011-000-0 1269 05/31/2020 Bank Interest- May 1269 05/31/2020 Bank xntereat- May Interest Income (27,447.05) (100.92) (27,547.97) GL (32.00) (27,579.97) GL Account: 520-490 Interest Income Totals: .00 Budgeted 27,579.97 Remaining 0 % Used Department Totals: (27,579.97) ** (132.92) Monthly Total .00 Budgeted 27,579.97 Remaining 0 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Program: Period Ending: 5/2020 JE Detail Description/Comment Account: 520-69005-0 - Capital Outlays 1084 05/01/2020 Capital Asset Fund Corrections Halff Nov Inv# 30284 coded 135 1084 05/01/2020 Capital Asset Fund Corrections J Walker Jan Inv# 1696113 F135 1215 05/21/2020 May A/P 16" water line acquistion 1215 05/21/2020 May A/P Easement Acquistition 1266 05/31/2020 May A/P easement Account: 520-69005-010-000 Department 10 Totals: Fund 520 Totals: Page 48 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 144,580.81 3,055.78 147,636.59 GL 7,452.00 155,088.59 GL 10,690.00 165,778.59 Halff Associates, INC 6447 AP 5,128.65 170,907.24 Jackson Walker LLP 6452 AP 2,657.54 173,564.78 Halff Associates, INC 6509 AP Capital Outlays Tn� .00 Budgeted (173,564.78) Remaining 0 % Used 28,983.97 173,564 173,564.78 ** 28,983.97 Monthly Total .00 Budgeted (173,564.78) Remaining 0 % Used 145,984.81 28,851.05 Monthly Total .00 Budgeted (145,984.81) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,308 TOTAL ASSETS 893,308 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 89,851 893,308 893,308 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 528 2015 Revenue Bond Reserve Fund Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW Program number: Department number: Revenues Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Budget Summary with Amendment Department: Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 201.50- 4,600.00- 5,750.00- 10,551.50- 10,551.50- 10,551.50- 10,551.50- 10,551.50- 7,051.03- 36,800.00- 46,000.00- 03- 03- 03- 64.100 11.985 22.952 17.330 17.330 17.330 17.330 3,948.97- 270,249.00- 154,417.00- 428,614.97- 428,614.97- 428,614.97- 428,614.97 - Page 19 glpdatb2 ekrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 49 Account: 528-49011-000-000 1269 05/31/2020 Bank Interest- May Interest Income J111111 (6,849.53) Account: 528-49011-000-000 come 1 (11,000.00) Budgeted (3,948.97) Remaining Account: 528-49142-000-000 7 1292 05/31/2020 TexPool Transfers May 64 % Used TexPool O&M to Rev Bond Resevr (32,200.00) (307,049.00) Budgeted (201.50) (7,051.03) (4,600.00) (36,800.00) (46,000.00) (270,249.00) Remaining 12 % Used Interfund transfer in -WW 1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer in - (200,417.00) Budgeted (40,250.00) (154,417.00) Remaining (5,750.00) 23 % Used Department Totals: (89,851.03) ** (10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used Fund 528 Totals: (89,851.03) (10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used GL GL GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 947,761 21,518 969,279 21,518 21,518 82,954 864,807 947,761 969,279 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 3,367.17- 64.06 158.35- 681,504.50- 1,789.72- 1,823.78- 99.863 178.972 91.189 936.50- 789.72 176.22 - Page 20 Subtotal: Mr - 3,461.46- 99.953 323.00- 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 213.71- 10,414.81- 3,745.64- 218,004.00- 83,318.48- 74.913 100.000 72.727 1,254.36- 31,244.52- 1 Subtotal: 337,567.00- 337,567.00- 10,628.52- 305,068.12- 90.373 32,498.88 - Program number: 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88 - Department number: Revenues 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88- glbase_tbam skrolczyk 10:08 06/10/20 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-70005-051-000 1 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: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 1,450.00 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 12.352 889,01'5.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 14,089.98- 864,807.37- 6#88#6#6#88#6#6 856,807.37 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Accoyyyyta 533-40000-000- 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 533-40000-000-000 Account: 533-40002-000-000- 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes Account: 533-40002-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes Property Taxes Totals: (682,441.00) Budgeted Property Taxes/Delinquent (678,137.33) (41.52) (678,178.85) (1.00) (678,179.85) (4.54) (678,184.39) (187.49) (678,371.88) (607.86) (678,979.74) (24.72) (679,004.46) (29.91) (679,034.37) 127.65 (678,906.72) (85.78) (678,992.50) (412.44) (679,404.94) (148.47) (679,553.41) (102.48) (679,655.89) (248.76) (679,904.65) (335.33) (680,239.98) (236.54) (680,476.52) (114.31) (680,590.83) (376.06) (680,966.89) (234.31) (681,201.20) (303.30) (681,504.50) (936.50) Remaining 100 % Used IIIIII1Eperty Taxes/Delinquent Totals: (1,000.00) Budgeted 789.72 Remaining Account: 533-40015-000-0 Property Taxes/P & I 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes (1,853.78) 179 % Used (1,665.43) (8.70) (1,862.48) 119.90 (1,742.58) (13.26) (1,755.84) (20.20) (1,776.04) (6.03) (1,782.07) (7.65) (1,789.72) (.25) (1,665.68) (.11) (1,665.79) (.53) (1,666.32) (2.43) (1,668.75) (66.91) (1,735.66) Page 50 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.l Page 51 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 533-40015-000-000 Property Taxes/P & I (2,000.00) Budgeted (1,665.43) (176.22) Remaining 91 % Used Account: 533-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (3,531.93) Account: 533-49011-000-000 Interest Income (5,000.00) Budgeted (1,254.36) Remaining 75 % Used (3.89) (1,739.55) (.53) (1,740.08) (36.96) (1,777.04) (2.86) (1,779.90) (.53) (1,780.43) (17.85) (1,798.28) .14 (1,798.14) (13.99) (1,812.13) (1.50) (1,813.63) (2.21) (1,815.84) (.16) (1,816.00) (7.78) (1,823.78) (1,823.78) ** (213.71) (3,745.64) (213.71) GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-49015-000-000 ental Incom IL Account: 533-49015-000-000 Lease/Rental Income (218,004.00) Budgeted Account: (218,004.00) .00 Remaining 100 % Used Interfund Trans In -PID Surchg 1292 05/31/2020 TexPool Transfers May TexPool O&M to I&S- PID Debt (72,903.67) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: 1 (114,563.00) Budgeted (31,244.52) Remaining Department Totals: (14,089.98) Monthly Total .00 (218,004.00) (10,414.81) (83,318.48) 73 % Used (990,186.12) ** (1,023,008.00) Budgeted (32,821.88) Remaining 97 % Used GL Account: 533-70035-051-000 Bond Principal Payment -Tax glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,450.00 .00 1,450.00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 123,928.75 .00 123,928.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 123,928.75 ** 247,858.00 Budgeted 123,929.25 Remaining 50 % Used .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** Department 51 Totals: Fund 533 Totals: 765,000.00 Budgeted 765,000.00 Remaining 0 % Used 125,378.75 ** .00 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 5 Used (14,089.98) Monthly Total (864,807.37) (8,000.00) Budgeted 856,807.37 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 356,844 TOTAL ASSETS 356,844 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 332,326 356,844 356,844 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 598,638.00- 598,638.00- Subtot 6060- 6011.38.00 - Program number: 6011111100 - Department number: Revenues 6011138.00 - Revenues Subtotal 601,138.00- 601,138.00- 601,138.00- 601,138.00- 69.98- 54,421.63- 1,272.98- 435,372.44- 54,491.61- 43-85.42- 54,491.61- 54,491.61- 54,491.61- 436,645.42- 436,645.42- 436,645.42- 50.919 72.727 36 —636 72.636 72.636 1,227.02- 163,265.56- 164,492.58- 164,492.58- 164,492.58- 164,492.58 - Page 22 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 534-70040-051-000 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 208,238.00 390,000.00 400.00 208,238.00 390,000.00 200.00 104,118.75 50.000 50.000 200.00 104,119.25 390,000.00 Subtotal: , 598,638.00 598,638.00 17.426 494,319.25 Program number: III 598,638.00 598,638.00 1C=Pir 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 18.75 17.426 494,31 Expenditures Subtotal III 598,638.00 598,638.00 18.75 17.426 494,319.25 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,491.61- 6.67- ############### 329,826.67 Page 23 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (54,491.61) Monthly Total (436,645.42) ** (601,138.00) Budgeted (164,492.58) Remaining 73 5 Used Account: 534-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (1,203.00) (69.98) (1,272.98) GL Account: 534-49011-000-000 Interest Income Totals: (69.98) (1,272.98) ** (2,500.00) Budgeted (1,227.02) Remaining 51 5 Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1.1 1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bd WWTP I&S (380,950.81) (54,421.63) (435,372.44) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: W. (54,421.63) (435,372.44) ** (598,638.00) Budgeted (163,265.56) Remaining 73 5 Used Department Totals: (54,491.61) Monthly Total (436,645.42) ** (601,138.00) Budgeted (164,492.58) Remaining 73 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Rev Bond Paying Agent Fee - 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 Account: 534-70045-051-000 Revenue Bond Principal Expense t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining 50 % Used .00 200.00 .00 104,118.75 50 % Used .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (332,326.67) (54,491.61) Monthly Total (2,500.00) Budgeted 329,826.67 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 175,649 TOTAL ASSETS 175,649 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 170,682 175,649 175,649 glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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- 34.80- 562.78- 56.278 437.22- 25,047.72- 200,381.76- 72.727 75,143.24- 200,944.54- ' 72.66. 75,580.46- �0- 276125.00- = 25,082.52- 200,944.54- 72.6E 0- 276,525.00- II 25,082.52- 200,944.54- 72.668 75,580.46- 276,525.00- 276,525.00- ■ 25,082.52- 200,944.54- 72.668 75,580.46- 75,580.46 - Page 24 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-70005-051-000 535-70040-051-000 1 535-70045-051-000 Description Rev Bond Paying,Agent Fee Revenue Bond Interest Expense Revenue Bond Principal Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 5/2020 Adopted Amended Total Budget Budget Encumb. 800.00 386,811.00 215,000.00 800.00 386,811.00 215,000.00 Current Month Program: YTD Total % of Budget 200.00 25.000 30,062.50 7.772 Remaining Budget 600.00 356,748.50 215,000.00 Page 25 Subtotal: -ImmommlOOPk11.00 60211.00 30,262.50 5.022 572,348.50 Program number: 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Department number: Administration 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Expenditures Subtotal 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 25,082.52- 170,682.04- -52.343 496,768.04 glpdatb2 skrolczyk 10:08 06/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: 5/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (25,082.52) Monthly Total (200,944.54) ** (276,525.00) Budgeted (75,580.46) Remaining 73 5 Used Account: 535-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (527.98) (34.80) (562.78) GL Account: 535-49011-000-000 Interest Income Totals: (34.80) (562.78) ** (1,000.00) Budgeted (437.22) Remaining 56 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1292 05/31/2020 TexPool Transfers May TexPool O&M to 16Swift Rev I&S (175,334.04) (25,047.72) (200,381.76) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (200,381.76) ** (275,525.00) Budgeted (75,143.24) Remaining 73 5 Used Department Totals: (25,082.52) Monthly Total (200,944.54) ** (276,525.00) Budgeted (75,580.46) Remaining 73 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Account: 535-70045-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 200.00 30,062.50 25 % Used .00 200.00 .00 30,062.50 8 % Used .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (170,682.04) (25,082.52) Monthly Total 326,086.00 Budgeted 496,768.04 Remaining -52 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,295 TOTAL ASSETS 23,295 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,295 TOTAL FUND BALANCE 23,295 TOTAL LIABILITIES AND FUND BALANCE 23,295 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5.34- Program number: 5.34- Department number: Revenues Revenues Subtotal 5.34- 5.34- 448.86- 183,168.16- 54,712.56- 238,329.58- 238,329.58- 238,329.58- 238,329.58 - 448.86 183,168.16 54,712.56 238,329.58 238,329.58 238,329.58 238,329.58 Page 26 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account 1 1 536-70005-051-000 1 536-70040-051-000 Description Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 5/2020 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - Page 27 ******* End of Report ********* Subtotal: 215,034.51 215,034.51 - Program number: 215,034.51 215,034.51 - Department number: Administration ! 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 5.34- 23,295.07- 23,295.07 ******* End of Report ********* glpdatb2 skrolczyk 10:08 06/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 57 Check Source Number Department Totals: (5.34) Monthly Total .00 Budgeted (238,329.58) ** 238,329.58 Remaining 0 $ Used Account: 536-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (443.52) (5.34) (448.86) GL Account: 536-49011-000-000 Interest Income Totals: (5.34) (448.86) ** .00 Budgeted 448.86 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales (183,168.16) .00 (183,168.16) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: ; .00 (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 5 Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales (54,712.56) (54,712.56) .00 Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 5 Used Department Totals: (5.34) Monthly Total .00 Budgeted (238,329.58) ** 238,329.58 Remaining 0 $ Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: 51 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Rev Bond Paying Agent Fee Account: 536-70005-051-000 Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense Account: 536-70040-051-000 Department 51 Totals: Fund 536 Totals: Grand Totals: 214,892.43 .00 142.08 .00 214,892.43 Revenue Bond Interest Expense Totals: .00 .00 Budgeted (214,892.43) Remaining 0 5 Used .00 Monthly Total .00 Budgeted (5.34) Monthly Total .00 Budgeted 215,034.51 ** (215,034.51) Remaining 0 5 Used (23,295.07) 23,295.07 Remaining 0 % Used ******* End of Report ********* (1,965,535.73) **** (59,904.72) Monthly Total (209,104.00) Budgeted 1,756,431.73 Remaining 940 5 Used