Loading...
HomeMy WebLinkAbout2020-04 Combined Financials April 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,14 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 948,994 8,204 44,435 TOTAL ASSETS 1,001,634 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 44,441 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 44,441 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 353,424 TOTAL FUND BALANCE 957,193 TOTAL LIABILITIES AND FUND BALANCE 1,001,634 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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 1,897.71 36.76- 465.03- 1,206,570.78- 2,867.46- 4,011.04- 99.369 7,659.22- 2,867.46 4,011.04 Page 1 Subtotal: 1,214,230.00- 1,214,230.00- 1,395.92 1,213,449.28- 99.936 780.72 - Program number: 1,214,230.00- 1,214,230.00- 1,395.92 1,213,449.28- 99.936 780.72 - Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 1,395.92 1,213,449.28- 99.936 780.72 - Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,395.92 1,213,449.28- 99.936 780.72- glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 62,924.88 218,004.00 11,486.16 419,216.56 2,750.00 11,958.24 81,420.00 115,190.36 860,025.32 860,025.32 860,025.32 353,423.96- 100.000 54.696 58.333 5.729 100.000 90.595 82.363 70.829 70.829 70.829 9,513.84 299,440.44 308,954.28 45,250.00 11,958.24- 11,958.64 45,250.40 354,204.68 354,204.68 354,204.68 353,423.96 Page 2 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-000- 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1148 04/22/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1149 04/23/2020 Property Taxes 1153 04/29/2020 Property Taxes Account: 122-40011-000 . Account020-0-111 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1149 04/23/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes Department Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 4/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/MUD Fire (1,208,468.49) Property Taxes/MUD Fire Totals: (1,214,230.00) Budgeted (7,659.22) Remaining Property Taxes/Fire-Delinquent Property Taxes/Fire-Delinquent Tots .00 Budgeted 2,867.46 Remaining Property Taxes/Fire P&1 Property Taxes/Fire P91 Totals: .00 Budgeted 4,011.04 Remaining 1,395.92 Monthly Total (2,261.53) (1,210,730.02) (52.25) (1,210,782.27) (171.47) (1,210,953.74) (934.84) (1,211,888.58) (8.15) (1,211,896.73) 8,218.91 (1,203,677.82) (2,775.26) (1,206,453.08) (29.32) (1,206,482.40) (96.80) (1,206,579.20) 8.42 (1,206,570.78) 99 % Used (2,830.70) (3,546.01) 0 % Used 0 % Used (14.25) (2,844.95) (.09) (2,845.04) (9.88) (2,854.92) (12.54) (2,867.46) (41.79) (3,587.80) (7.50) (3,595.30) (3.24) (3,598.54) (102.84) (3,701.38) (.81) (3,702.19) (2.37) (3,704.56) (289.99) (3,994.55) (3.21) (3,997.76) (10.65) (4,008.41) (2.63) (4,011.04) (1,213,449.28) ** (1,214,230.00) Budgeted (780.72) Remaining 100 % Used 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 glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 Program: JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 2 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 72 04/01/2020 Insurance/Wrk Comp Expense Apr 9,845.28 1,640.88 11,486.16 GL Account: 122-60055-045-000 Insurance Totals: 1,640.88 11,486.16 ** 21,000.00 Budgeted 9,513.64 Remaining 55 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1059 04/13/2020 April A/P Fire admin april 359,326.48 59,888.08 419,216.56 TOWN OF TROPHY CLUB 6377 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 419,216.56 ** 718,657.00 Budgeted 299,440.44 Remaining 58 % 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 3 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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: 860,025.32 •• 61,528.96 Monthly Total 1,214,230.00 Budgeted 354,204.68 Remaining 71 % Used Fund 122 Totals: (353,423.96) 62,924.88 Monthly Total .00 Budgeted 353,423.96 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET APRIL 2020 RP TROPHY CLI MUNICIPAL UTILITY DISTRICT No.1 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,936,208 2,936,208 CASH IN BANK -SAVINGS -CASH RESERVE 1,603,738 1,603,738 INVESTMENTS-TEXPOOL 3,675,945 919,266 4,595,211 PREPAID EXPENSES 48,420 48,420 ADVALOREM PROPERTY TAXES RECEIVABLE 4,869 4,869 UTILITY AND OTHER ACCOUNTS RECEIVABLE 938,760 938,760 TOTAL ASSETS 9,208,541 919,266 10,127,807 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,869 4,869 ACCOUNTS AND OTHER PAYABLES 437,559 437,559 CUSTOMER DEPOSITS 315,570 315,570 TOTAL LIABILITIES 757,998 757,998 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 49,159 49,159 TOTAL FUND BALANCE 8,450,543 919,266 9,369,809 TOTAL LIABILITIES AND FUND BALANCE 9,208,541 919,266 10,127,807 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 210.67 4.18- 51.66- 133,944.05- 296.98- 436.64- 99.313 98.993 145.547 926.95- 3.02- 136.64 164,253.00- 299,724.00- 299,724.00- 154.83 134,677.67- 44.934 _ 165,046.33- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 390,375.29- 2,492,189.86- 38.420 3,994,433.14- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 277,887.59- 1,779,647.58- 50.791 1,724,237.42- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 984.72 51,132.79- 45.408 61,475.21- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 9,800.00- 64.686 5,350.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 2,250.00- 300.000 1,500.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 1,350.00- 54.000 1,150.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 1,997.60- 17,065.60- 34.131 32,934.40 - Subtotal: 10,171,516.00- 10,171,516.00- 669,275.76- 4,353,435.83- 42.800 5,818,080.17- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 4,510.20- 1,178.81- 583.33- 8,925.00- 205.89- 63,617.94- 7,072.86- 4,083.31- 8,925.00- 7,730.28- 8,802.09- 53.015 49.999 58.333 68.654 60.912 125.744 56,382.06- 7,073.14- 2,916.69- 4,075.00- 4,960.72- 1,802.09 6,382.06 -7,073.14-2,916.69-4,075.00- 4,960.72- 1,802.09 Subtotal: 173,837.00- 173,837.00- 15,403.23- 100,231.48- 57.658 73,605.52- Program number: 10,645,077.00- 10,645,077.00- 684,524.16- 4,588,344.98- 43.103 6,056,732.02 - Department number: Revenues 10,645,077.00- 10,645,077.00- 684,524.16- 4,588,344.98- 43.103 6,056,732.02 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 684,524.16- 4,588,344.98- 43.103 6,056,732.02- glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 FSubtotal: ' 546,839.00 546,839.00 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 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 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 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 30,384.08 1,527.92 425.00 2,994.40 5,225.04 316.63 48.18 300.51 1,979.47 462.94 771.49 192,746.19 11,865.26 5,082.50 2,925.00 20,760.14 34,828.70 2,114.74 332.47 2,206.06 13,026.95 3,046.60 880.68 5,575.93 55.028 69.796 129.656 54.167 59.548 41.302 44.756 43.347 70.436 55.795 55.788 81.544 47.054 157,520.81 5,134.74 1,162.50- 2,475.00 14,102.86 49,497.30 2,610.26 434.53 925.94 10,321.05 2,414.40 199.32 6,274.07 400.00 300.00 Page 4 44,435.66 295,391.22 716.02 87.50 420.00 24,431.71 24.432 1,842.56 1,828.19 525.00 2,451.64 36.851 52.234 52.500 32.689 20,000.00 75,568.29 3,000.00 3,157.44 1,671.81 475.00 5,048.36 140,000.00 140,000.00 1,223.52 108,920.90 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 370.69 3,267.94 6,574.02 71,633.79 850.00 850.00 105.00 105.00 1,436.00 3,262.20 20,205.04 93,912.32 752,381.54 756.00 750.00 1,500.00 25,047.72 358,502.20 4,600.00 32,200.00 65.359 56.998 85.000 21.000 19.337 32.071 27.715 25.200 10.169 67.978 58.341 1,732.06 54,043.21 150.00 395.00 5,990.00 400.00 2,845.00 1,500.00 42,794.96 1,962,328.46 200.00 2,244.00 13,250.00 168,878.80 22,993.00 180,000.00 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 _705.082 00 9.705.082 00 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 135-65010-010-000 Uniforms 5,190.00 5,190.00 135-65030-010-000 Chemicals 20,000.00 20,000.00 135-65035-010-000 Small Tools 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 135-65050-010-000 Meter Expense 70,000.00 70,000.00 135-65053-010-000 Meter Change Out Program 87,000.00 87,000.00 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 3,618.00 5,504,929.00 5, 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 561.72 22.469 1,938.28 2 461.68 Page 312.70 5,733.85 2,917.33 558.41 11,862.25 42,723.30 59,593.08 36,900.00 87,311.25 276,524.74 30,512.00 1,840.00 75,000.00 102,077.11 38.226 9,266.15 56.211 2,272.67 59.311 8,137.75 1,200.00 1,000.00 85.133 10,406.92 42.414 50,100.00 58.682 40.376 100.000 56.948 100.000 85.064 408,350.26 1,391.00 17,922.89 664.15 09 glbase_tbam skrolczyk 16:31 05/13/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: 4/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 160.00 1,001.64 50.082 998.36 Page 6 Subtotal: 2,000.00 2,000.00 r 160.00 1,001.64 50.082 998.36 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 160.00 1,001.64 50.082 998.36 Department number: Water 5,506,929.00 5,506,929.00 312,196.79 2,173,831.55 39.474 3,333,097.45 glbase_tbam skrolczyk 16:31 05/13/20 Fund: 135 MUD 1 General Fund Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 4/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 135-55081-020-000 Mainten & Revairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 32,561.92 215,244.45 48.720 226,554.55 652.95 11,995.38 36.350 21,004.62 6,872.50 85.532 1,162.50 550.00 4,375.00 48.611 4,625.00 3,126.63 23,612.35 51.860 21,918.65 7,738.24 49,266.55 46.984 55,591.45 446.90 2,879.22 49.497 2,937.78 69.74 459.91 48.514 488.09 354.68 2,569.18 57.093 1,930.82 1,937.61 13,808.00 45.281 16,686.00 453.14 3,229.27 45.279 3,902.73 12.78 1,008.00 80.000 252.00 1,110.20 7,946.90 51.694 7,426.10 38.00 9.500 362.00 300.00 Page 7 365,142.29 30,000.00 3,000.00 20.000 12,000.00 555.74 42,136.36 47.882 45,863.64 390.21 18,113.87 181.139 8,113.87- 10,000.00 30.96 824.94 20.624 3,175.06 2,011.88 25.149 5,988.12 832.22 27.741 2,167.78 87.50 525.00 35.000 975.00 8,332.80 51,616.18 51.616 48,383.82 2,332.20 21,376.10 53.440 18,623.90 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 407.91 3,496.18 69.924 1,503.82 11,957.48 73,247.99 45.761 86,819.01 200.00 216.00 72.000 84.00 2,962.85 59.376 2,027.15 109.14 10.914 890.86 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 11.699 4,415.06 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 890.00 1,480.00 10.571 12,520.00 10,414.81 72,903.67 63.636 41,659.33 54,421.63 435,663.37 64.651 238,203.63 5,750.00 40,250.00 32.152 84,937.00 180,000.00 190.00 9.500 1,810.00 2. Subtotal: 1,310,669.00 83,841.83 641,60 48.952 ,066.12 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 491.43 4,738.13 37.905 7,761.87 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,210.47 17,139.42 85.697 2,860.58 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 162.00 16,432.18 82.161 3,567.82 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 9,525.00 182,063.00 34.319 348,437.00 79,133.00 59,604.74 75.322 19,528.26 11,277.00 6,122.03 54.288 5,154.97 130,000.00 130,000.00 100.000 750,910.00 9,525.00 377,E 50.311 373,120.23 3,157,421.00 156,974.93 1,551,1 49.126 1,606,308.90 3,157,421.00 156,974.93 1,551,11 49.126 1,606,308.90 glbase_tbam skrolczyk 16:31 05/13/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: 4/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 13.93 % of Remaining Budget Budget 46.433 16.07 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 113.54 675.00 289.82 90.000 22.294 150.00 75.00 1,010.18 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 113.54 964.82 7.309 12,235.18 Program number: 13,230.00 13,230.00 115.53 978.75 7.398 12,251.25 L Department number: Board of Directors 13,230.00 13,230.00 115.53 978.75 7.398 12,251.25 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 30,878.58 209,368.01 33.323 418,929.99 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 2,859.35 21,091.51 36.021 37,462.49 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 41,849.51 33.643 82,544.49 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 2,318.20 35.863 4,145.80 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 353.03 34.109 681.97 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 319.57 2,314.93 51.443 2,185.07 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,771.06 12,231.08 31.190 26,983.92 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 414.20 2,860.52 31.191 6,310.48 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 20.17 864.00 60.000 576.00 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 733.74 41.337 1,041.26 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 43,114.95 299,301.90 x.722 588,252.10 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanini7 Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 1,669.66 133,346.24 99.009 1,334.76 18,511.86 75,711.88 56.083 59,288.12 110.00 1,275.00 8.500 13,725.00 531.00 5.310 9,469.00 1,416.42 5,761.72 57.617 4,238.28 2,500.00 3.811 63,100.00 537.64 4,179.68 46.441 4,820.32 Page 10 135-60005-030-000 Telephone 23,680.00 23,680.00 1,293.38 10,173.55 42.963 13,506.45 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 288.55 1,715.86 42.897 2,284.14 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 695.53 3,449.34 50.143 3,429.66 135-60025-030-000 Water 1,500.00 1,500.00 1,221.20 1,479.02 98.601 20.98 135-60035-030-000 Postage 30,000.00 30,000.00 1,571.94 11,725.51 39.085 18,274.49 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 5,178.84 41,902.02 62.540 25,097.98 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 45,426.87 54.080 38,573.13 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 70.00 1,452.21 21.200 5,397.79 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 306.48 1,020.64 28.791 2,524.36 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 Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Period Ending: 4/2020 Account Description Adopted Amended Total Current Budget Budget Encumb. Month 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 135-65010-030-000 Uniforms 135-65055-030-000 Hardware 135-65085-030-000 Office Supplies 135-65090-030-000 Printer Supplies & Maintenance 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing 135-69005-030-000 135-69170-030-000 Program number: Capital Outlays Copier Lease Installments Department number: Administration 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 Program: YTD % of Remaining Total Budget Budget 24.00 168.00 13.043 1,120.00 500.00 17,000.00 2,500.00 231.60 38.90 24,094.45 128, 3,235.24 12.215 2,431.85 40.531 2,848.53 71.213 27,009.75 13.851 187.77 1,734.10 56 56 43.353 2,050.00 23,249.76 3,568.15 3,500.00 1,151.47 2,500.00 167,990.25 2,265.90 1,087,92 Page 11 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 Aucitinq 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 2,620.50 85,585.39 27,713.27 7,422.04 3,756.00 63.397 81.992 63.107 93.900 49,414.61 6,086.73 4,338.96 244.00 Page 12 Subtotal. 184,561.00 184,561.00 2,620.50 124,476.70 67.445 60,084.30 Program number: 184,561.00 184,561.00 2,620.50 124,476.70 67.445 60,084.30 Department number: Non Departmental 184,561.00 184,561.00 2,620.50 124,476.70 67.445 60,084.30 Expenditures Subtotal 10,638,853.00 10,638,853.00 579,469.31 4,539,186.40 42.666 6,099,666.60 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 105,054.85- 49,158.58- 789.823 42,934.58 glbase_tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 Trophy Club MUD No.1 Page 4 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-40000-000-000 L Property Taxes 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1148 04/22/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes (134,154.72) (251.06) (134,405.78) (5.80) (134,411.58) (19.03) (134,430.61) (103.78) (134,534.39) (.91) (134,535.30) 912.40 (133,622.90) (308.09) (133,930.99) (3.25) (133,934.24) (10.75) (133,944.99) .94 (133,944.05) GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: 210.67 (133,944.05) ** (134,871.00) Budgeted (926.95) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1149 04/23/2020 Property Taxes 1153 04/29/2020 Property Taxes (292.80) (1.62) (294.42) (.01) (294.43) (1.12) (295.55) (1.43) (296.98) GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 8) (296.98) ** (300.00) Budgeted (3.02) Remaining 99 % Used Account: 135-40015-000-000 Property Taxes/P & I 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1149 04/23/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes (384.98) (4.64) (389.62) (.85) (390.47) (.37) (390.84) (11.41) (402.25) (.09) (402.34) (.27) (402.61) (32.19) (434.80) (.36) (435.16) (1.18) (436.34) (.30) (436.64) GL GL GL GL GL GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (436.64) ** (300.00) Budgeted 136.64 Remaining 146 % Used Account: 135-40025-000-000 PID Surcharges glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40025-000- (164,253.00) Account: 135-47000-000-000 1070 04/14/2020 UB 04/14/2020 Remove Charges 1129 04/30/2020 UB 04/30/2020 Billing Account Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 4/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Budgeted (164,253.00) UB20200414-20200414 User: UB20200430-20200430 User: (6,486,623.00) Budgeted Remaining (2,101,814.57) 0 .00 Used .00 18.15 (2,101,796.42) (390,393.44) (2,492,189.86) (3,994,433.14) Remaining 38 % Used 1070 04/14/2020 UB 04/14/2020 Remove Chargee UB20200414-20200414 User: 1129 04/30/2020 UB 04/30/2020 Billing UB20200430-20200430 User: 005-000-000 (1,501,759.99) 167.93 (1,501,592.06) (278,055.52) (1,779,647.58) (3,503,885.00) Budgeted (1,724,237.42) Remaining Account: 135-47025-000-00 Penaltie 1010 04/01/2020 UB 04/01/2020 Penalty removal 1013 04/01/2020 UB 04/01/2020 Penalty removal 1021 04/07/2020 UB 04/07/2020 Penalty removal 1069 04/14/2020 UB 04/14/2020 Penalty Removal Account: 135-47025-000-000 Account: 135-47030-000-000 Account: 135-47030-000-000 Account: 135-47035-000-000 Account: 135-47035-000-000 UB20200401-20200401 User: UB20200401-20200401 User: UB20200407-20200407 User: UB20200414-20200414 User: (112,608.00) Budgeted Service Charges Service Charges (15,150.00) Budgeted Plumbing Inspections (750.00) Budgeted 51 % Used (52,117.51) (61,475.21) Remaining (5,350.00) Remaining Totals: 45 % Used (9,800.00) 65 % Used (2,250.00) 1,500.00 Remaining 300 % Used 728.18 89.46 31.14 135.94 (51,389.33) (51,299.87) (51,268.73) (51,132.79) .00 (9,800.00) .00 (2,250.00) Page 5 Check Source Number UB UB UB UB UB UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-47045-000-000 Sewer Inspections Account: 135-47045-000-000 Sewer Inspections (2,500.00) Budgeted (1,350.00) .00 (1,350.00) (1,150.00) Remaining 54 % Ueed Account: 135-47070-000-00 TCCC Effluent Charges 1129 04/30/2020 UB 04/30/2020 Billing UB20200430-20200430 User: Account (15,068.00) (1,997.60) (17,065.60) UB TCCC Effluent Charges Totals: (50,000.00) Budgeted (32,934.40) Remaining Acc Income 1162 04/30/2020 Bank Interest- April 1162 04/30/2020 Bank Interest- April 1162 04/30/2020 Bank Interest- April Accoun Account: 135-49016-000-000 1168 04/16/2020 Cell Tower Rev AT&T Interest Income Totals: (120,000.00) Budgeted Cell Tower Revenue Account: 135-49016-000-000 ell Tower Revenue (14,146.00) Budgeted 34 % Ueed (59,107.74) (1,262.20) (60,369.94) GL (1,116.58) (61,486.52) GL (2,131.42) (63,617.94) GL (56,382.06) Remaining 53 % Used (5,894.05) (7,073.14) Remaining 50 % Used Account: 135-49018-000-000 Building Rent Income 1181 04/30/2020 Town Billed Invoices 1734-1737 AR 20200430-20200430 User: (3,499.98) Account: 135-49018-000-000 Building Rent Income (7,000.00) Budgeted (2,916.69) Remaining Account: 135-49026-000-0� 1169 04/16/2020 Sale of Asst Lone Star Auction Dodge Truck Bed 1169 04/16/2020 Sale of Asst Lone Star Auction Transfer Switch w/ Cabinet 1169 04/16/2020 Sale of Asst Lone Star Auction Transfer Switch W/ Cabinet 1169 04/16/2020 Sale of Asst Lone Star Auction 2012 Ford F-250 Vehicle# 102 58 % Used (1,178.81) (7,072.86) (1,178.81) (7,072.86 (583.33) (4,083.31) (525.00) (135.00) (215.00) (8,050.00) (525.00) (660.00) (875.00) (8,925.00) GL AR GL GL GL GL glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Ac Trophy Club MUD No.1 Page 7 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 4/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Description/Comment Proceeds from Sale of Asse (13,000.00) Budgeted (4,075.00) Remaining Oversize Meter Reimbursement Account• Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (4,960.72) Remaining Accoun Miscellaneous Income 1129 04/30/2020 DB 04/30/2020 Billing UB20200430-20200430 User: 69 (7,730.28) Used 61 % Used .00 (7,730.28) .00 (7,730.28) ** (8,596.20) (205.89) (8,802.09) UB Account: 13 Miscellaneous Income (8,802.09) ** (7,000.00) Budgeted 1,802.09 Remaining 126 % Used Department Totals: (4,588,344.98) ** (684,524.16) Monthly Total (10,645,077.00) Budgeted (6,056,732.02) Remaining 43 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-5000 010- Salaries & W 987 04/03/2020 MUD Payroll 4/3/2020 Salaries & Wages 162,362.11 1065 04/17/2020 Mud Payroll 4/17/2020 Salaries & Wages Account:5-05-0 Salaries & Wages ' Totals: 350,267.00 Budgeted 157,520.81 Remaining 55 % Used 14,944.73 177,306.84 PR 15,439.35 192,746.19 PR Account: 135-50010-010-000 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 •vertime Overtime 10,337.34 828.02 11,165.36 PR Overtime 699.90 11,865.26 PR Account: 17,000.00 Budgeted 5,134.74 Remaining 70 % Used Account: 135-50016-010 Longevit 5,082.50 .00 5,082.50 Account: 135-5001 Longevity 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Totals: Account: 135-50017-010-000 1065 04/17/2020 Mud Payroll 4/17/2020 Account: 135-50017-01 Certification Certification Certification 5,400.00 Budgeted 2,475.00 Remaining 2,500.00 54 Used 425.00 2,925.00 PR Account: 135-50020-010-000 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 .etireme Account: 135-50020-010-000 Account: 135 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Retirement Retirement Retirement 34,863.00 Budgeted Medical Insurance Medical Insurance Medical Insurance Acc< Medical Insurance 84,326.00 Budgeted 17,765.74 Totals: 14,102.86 Remaining 60 % Used 29,603.66 Totals: 49,497.30 Remaining 41 % Used 1,460.55 1,533.85 19,226.29 20,760.14 2,612.55 32,216.21 2,612.49 34,828.70 PR PR PR PR glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 9 Check Source Number Account: 135-50027-010-000 Dental Insurance 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Dental Insurance Mud Payroll 4/17/2020 Dental Insurance 1,798.11 158.32 158.31 1,956.43 2,114.74 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 316.63 2,114.74 ** 4,725.00 Budgeted 2,610.26 Remaining 45 % Used Account: 135-50028-010-000 Vision Insurance 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Vision Insurance Mud Payroll 4/17/2020 Vision Insurance 284.29 24.10 24.08 308.39 332.47 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 48.18 332.47 ** 767.00 Budgeted 434.53 Remaining 43 % Used Account: 135-50029-010-000 7 Life Insurance 0 Other 965 04/01/2020 965 04/01/2020 Payroll Benefits- April Employee Benefits Payroll Benefits- April Employee LTD & STD 1,905.55 168.50 132.01 2,074.05 2,206.06 Humana METLIFE Inc GROUP BENEFITS 6302 6310 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 300.51 2,206.06 ** 3,132.00 Budgeted 925.94 Remaining 70 % Used Account: 135-50030-010-000 Social Security Taxes 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Social Security Taxes Mud Payroll 4/17/2020 Social Security Taxes 11,047.48 968.05 1,011.42 12,015.53 13,026.95 PR PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,979.47 13,026.95 ** 23,348.00 Budgeted 10,321.05 Remaining 56 % Used Account: 135-50035-010-000 Medicare Taxes 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Medicare Taxes Mud Payroll 4/17/2020 Medicare Taxes 2,583.66 226.39 236.55 2,810.05 3,046.60 PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 462.94 3,046.60 ** 5,461.00 Budgeted 2,414.40 Remaining 56 % Used Account: 135-50040-010-000 Unemployment Taxes 880.68 .00 880.68 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 13 Trophy Club MUD No.1 Page 10 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 4/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Unemployment Taxes Tota 1,080.00 Budgeted 199.32 Remaining 82 % Used Account: 135-50045-010-000 Workman's Compensation 72 04/01/2020 Insurance/Wrk Comp Expense Apr 4,804.44 Account: 135-50045-010-000 Account: 135-50060-010-000 Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 Account: 135-55005-010-000 Workman's Compensation Totals: 11,850.00 Budgeted Pre-emp Physicals/Testing 6,274.07 Remaining 47 % Used Pre-emp Physicals/Testing Totals: 400.00 Budgeted 400.00 Remaining Employee Relations Employee Relations 300.00 Budgeted Engineering Account: 135-55005-010-000 IIIMILEngineering 20,000.00 Budgeted Account: 135-55080-010-000 Maintenance & Repairs 0 % Used 300.00 Remaining 0 % Used 771.49 5,575.93 GL .00 .00 .00 .00 00 ** .00 .00 20,000.00 Remaining 0 % Used 00 ** 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 SOD for repairs 23,715.69 27.28 23,742.97 TEX-TURF PC 1120 04/30/2020 April A/P oil for pumps 690.82 24,433.79 LUBRICATION ENGINEERS, INC 6394 AP 1170 04/30/2020 Refund for Taxes- Bert PCard Refund Taxes- Turf Bert PCard (2.08) 24,431.71 GL 1 Account: 135-55085-010-000 Maintenance & Repairs Totals: 100,000.00 Budgeted 75,568.29 Remaining 24 % Used Generator Maint. and Repair glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) .00 .00 Page 11 Check Source Number 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 1,842.56 .00 1,842.56 Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 1,842.56 ** 5,000.00 Budgeted 3,157.44 Remaining 37 % 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 1089 04/20/2020 April A/P Janitorial service -March 437.50 87.50 525.00 MEMBER'S BUILDING MAINTENANCE 6367 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 525.00 ** 1,000.00 Budgeted 475.00 Remaining 53 % Used Account: 135-55135-010-000 Lab Analysis 1089 04/20/2020 April A/P 1177 04/30/2020 April A/P water samples water samples 2,031.64 200.00 220.00 2,231.64 2,451.64 TARRANT CTY PUBLIC TARRANT CTY PUBLIC HEALTH LAB HEALTH LAB 6373 6433 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 420.00 2,451.64 ** 7,500.00 Budgeted 5,048.36 Remaining 33 % Used Account: 135-60010-010-000 Communications/Mobiles 1089 04/20/2020 April A/P Cell phones -April 2,897.25 370.69 3,267.94 VERIZON WIRELESS 6380 AP Account: 135-60010-010-000 ' Communications/Mobiles Totals: 370.69 3,267.94 ** ■ 5,000.00 Budgeted 1,732.06 Remaining 65 % Used Account: 135-60020-010-000 Electricity ■ glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Detailed Accounting Trial Balance Page 12 1089 04/20/2020 April A/P Electricity 3/10-4/8 Account: 135-60020-010-000 Electricity 125,677.00 Budgeted 54,043.21 Remaining Account: 135-60066-010-000 Publications/Books/Subscripts 1120 04/30/2020 April A/P Account: 135-60066-010-000 standard annual renewal Publications/Books/Subscri 1,000.00 Budgeted 150.00 Account: 135-60070-010- Dues & Membership 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Water Enviro Fed Membership Dues & Memberships 500.00 Budgeted Remaining 395.00 Remaining 65,059.77 6,574.02 57 % Used 71,633.79 HUDSON ENERGY SERVICES, LLC 6358 AP 6,57 71,633.79 ** 850.00 850.00 AMERICAN WATER WORKS ASSOC 85 % Used 105.00 21 % Used 105.00 WEF MAIN 6386 AP PC Account: 135-60080-010-000 Schools & Trainin 1,436.00 Account: 135-60080-010-000 Schools & Training 7,426.00 Budgeted 5,990.00 Remaining Account: 135-60090-010-000 Safety Program 19 % Used 0 1,436.00 .00 .00 Account: 135-60090-010-000 Safety Program Totals: Account: 135-60100-010-000 400.00 Budgeted 400.00 Remaining 0 % Used Travel & per diem AIL Account: 135-60100-010-000 Travel & per diem 2,845.00 Budgeted .00 .00 2,845.00 Remaining 0 % Used Account: 135-60105-010-000 .00 .00 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund ACC JE JE JE Number Date Description 1177 04/30/2020 April A/P Account: 135-601 A 1109 04/27/2020 April A/P Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Account: 135-60280-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 4/2020 JE Detail Description/Comment Page 13 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Rent/Lease Equipment Tota 1,500.00 Budgeted 1,500.00 Remaining TCEQ Fees & Permits well water TCEQ Fees & Permits 7 Tote 63,000.00 Budgeted 42,794.96 Remaining Wholesale Wat. wholesale Wholesale Water 2,714,710.00 Budgeted ater Miscellaneous Expenses Miscellaneous Expense 200.00 Budgeted Account: 135-60285-010-000 1177 04/30/2020 April A/P operty Maintenance 0 Used 16,942.84 3,262.20 20,205.04 North Texas Groundwater 6430 AP 658,469.22 32 % Used 93,912.32 1,962,328.46 Remaining 28 % Used 200.00 Remaining 756.00 0 Used .00 752,381.54 .00 .00 756.00 Property Maintenance 3,000.00 Budgeted 2,244.00 Remaining 25 % Ueed CITY OF FORT WORTH Lawn Equipment & Maintenance Mowing -April 750.00 750.00 1,500.00 WATTS ELLISON LLC 85-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 13,250.00 Remaining Account: 135-60332-010-00 Interfund Transfer Out -Rev I&S 1161 04/30/2020 TexPool Transfers April TexPool O&M to 16Swift Rev I&S 333,454.48 10 % Ueed 25,047.72 358,502.20 6388 AP 6439 AP GL glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 14 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 4/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-60332-01t Interfund Transfer Out -Rev I&S Tot- 527,381.00 Budgeted 168,878.80 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bond Resevr Account: 135-60333-010-00u Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 22,993.00 Remaining Account: 135-60334-010-000W Interfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 1116. Furniture/Equipment < $5000 Account: 135-60360-010-000 Account: 135-65005-010- 1111 04/24/2020 Fuel- April Account: 135-65005-0 Account: 135-65010-01 Account: 135-65030-010-000 1177 04/30/2020 April A/P `Furniture/Equipment < 3500 2,500.00 Budgeted Fuel -Apr Fuel & Lube - 15,000.00 Budgeted Unif 5,190.00 Budgeted Chemicals chlorine 1,938.28 Remaining 9,266.15 Remaining 2,272.67 Remaining 27,600.00 561.72 68 Used 58 % Used 0 % Used 22 Used 4,600.00 32,200.00 4,600.00 .00 .00 .00 561.72 GL 5,421.15 312.70 5,733.85 US Bank Voyager Fleet Systems 6398 AP 2,917.33 11,303.84 38 % Used 56 % Used 0 2,917.33 558.41 11,862.25 DPC INDUSTRIES, INC 6424 AP glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-65030-01t Account: 135-65035-010-000 Account: 135-65035-010-000 Account: 135-65040-010-000 Account: 135-65040-010-000 Department: 10 Water JE Detail Description/Comment Chemicals 20,000.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Program: Period Ending: 4/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 8,137.75 Remaining 1,200.00 Remaining Totals. 59 % Used 0 % Used 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 1109 04/27/2020 April A/P meters 1120 04/30/2020 April A/P meters 1177 04/30/2020 April A/P Fire lines for torn homes Acc A 1177 04/30/2020 April A/P Account: 135-69005-0 Meter Expense 70,000.00 Budgeted Meter ang Meter Change Out Prog 87,000.00 Budgeted Capital Outla - High se ` Capital Outlays 684,875.00 Budgeted 10,406.92 Remaining 50,100.00 Remaining ice pump statiom 16,869.78 36,900.00 189,213.49 85 % Used 42 % Used 408,350.26 Remaining 40 % Used .00 .00 .00 .00 11,010.00 17,000.00 14,713.30 00 87,311.25 87,311.25 27,879.78 ATLAS UTILITY SUPPLY CO. 44,879.78 ATLAS UTILITY SUPPLY CO. 59,593.08 Core & Main LP 9,593.08 ** 36,900.00 276,524.74 REY-MAR CONSTRUCTION 6387 AP 6387 AP 6421 AP 6432 AP Account: 135-690 Short Term Debt -Principal glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Page 16 Detailed Accounting Trial Balance Account: 135-69008-010-000 Account: 135-69009-010-000 Account: 135-69009-010-000 Account: 135-69195-010-000 Account: 135-69195-010-000 Account: 135-69281-010-000 Account: 135-69281-010-000 Short Term Debt -Principal 30,512.00 Budgeted Short Term Debt -Interest Short Term Debt-Intere L. 3,231.00 Budgeted 30,512.00 .00 30,512.00 .00 Remaining 100 % Used 1,391.00 Remaining 1,840.00 .00 57 % Used 1,840.00 Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Tota 75,000.00 Budgeted .00 Remaining 75,000.00 .00 75,000.00 100 % Used Water Tank Inspection Contract 102,077.11 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.69 Remaining 85 % Used .00 102,077.11 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-55135-010-F 1089 04/20/2020 April A/P 1177 04/30/2020 April A/P Account: Department 10 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lab Analysis water samples water samples Page 17 Lab Analysis for PID _ Totals: 2,000.00 Budgeted 998.36 Remaining 841.64 80.00 921.64 TARRANT CTY PUBLIC HEALTH LAB 6373 AP 80.00 1,001.64 TARRANT CTY PUBLIC HEALTH LAB 6433 AP • .64 50 % Used 2,173,831.55 ** 312,196.79 Monthly Total 5,506,929.00 Budgeted 3,333,097.45 Remaining 39 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-50005-020- Salaries & Wa 987 04/03/2020 MUD Payroll 4/3/2020 Salaries & Wages 182,682.53 1065 04/17/2020 Mud Payroll 4/17/2020 Salaries & Wages Account:5-05-0 Salaries & Wages ' Totals: 441,799.00 Budgeted Account: 135-50010-020-000 Overtime 987 04/03/2020 MUD Payroll 4/3/2020 Overtime 1065 04/17/2020 Mud Payroll 4/17/2020 Overtime Account: 135-50010-020-000 226,554.55 Remaining 49 % Used 16,002.46 198,684.99 PR 16,559.46 215,244.45 PR 11,342.43 452.95 11,795.38 PR 200.00 11,995.38 PR 33,000.00 Budgeted 21,004.62 Remaining 36 % Used Account: 135 - Longevity Account: 135-50016-020-000 Longevity Totals: 8,035.00 Budgeted 1,162.50 Remaining Account: 135-50017-020-000 Certification 1065 04/17/2020 Mud Payroll 4/17/2020 Certification Account: 135-50017-020-000 ertification 9,000.00 Budgeted Account: 135-50020-020-000 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Retirement Retirement Account: 135-50020-020-000 Retirement 45,531.00 Budgeted Account: 135 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Medical Insurance Medical Insurance Medical Insurance Accti Medical Insurance 104,858.00 Budgeted 4,625.00 Remaining 6,872.50 .00 6,872.50 86 % Used 3,825.00 550.00 4,375.00 20,485.72 49 % Used Totals: 21,918.65 Remaining 52 % Used 41,528.31 Totals: 55,591.45 Remaining 47 % Used 1,523.77 1,602.86 22,009.49 23,612.35 3,869.14 45,397.45 3,869.10 49,266.55 PR PR PR PR PR glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 19 Check Source Number Account: 135-50027-020-000 Dental Insurance 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Dental Insurance Mud Payroll 4/17/2020 Dental Insurance 2,432.32 223.47 223.43 2,655.79 2,879.22 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 446.90 2,879.22 ** 5,817.00 Budgeted 2,937.78 Remaining 49 % Used Account: 135-50028-020-000 Vision Insurance 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Vision Insurance Mud Payroll 4/17/2020 Vision Insurance 390.17 34.87 34.87 425.04 459.91 PR PR Account: 135-50028-020-000 Vision Insurance Totals: 69.74 459.91 ** 948.00 Budgeted 488.09 Remaining 49 % Used Account: 135-50029-020-000 7 Life Insurance & Other 965 04/01/2020 965 04/01/2020 Payroll Benefits- April Employee Benefits Payroll Benefits- April Employee LTD & STD 2,214.50 188.94 165.74 2,403.44 2,569.18 Humana METLIFE Inc GROUP BENEFITS 6302 6310 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 354.68 2,569.18 ** 4,500.00 Budgeted 1,930.82 Remaining 57 % Used Account: 135-50030-020-000 Social Security Taxes 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Social Security Taxes Mud Payroll 4/17/2020 Social Security Taxes 11,870.39 960.69 976.92 12,831.08 13,808.00 PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,937.61 13,808.00 ** 30,494.00 Budgeted 16,686.00 Remaining 45 % Used Account: 135-50035-020-000 Medicare Taxes 987 04/03/2020 1065 04/17/2020 MUD Payroll 4/3/2020 Medicare Taxes Mud Payroll 4/17/2020 Medicare Taxes 2,776.13 224.67 228.47 3,000.80 3,229.27 PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 453.14 3,229.27 ** 7,132.00 Budgeted 3,902.73 Remaining 45 % Used Account: 135-50040-020-000 Unemployment Taxes 987 04/03/2020 MUD Payroll 4/3/2020 Unemployment Taxes 995.22 12.78 1,008.00 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 13 Unemployment Taxes Tota 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 72 04/01/2020 Insurance/Wrk Comp Expense Apr Account: 135-50045-020-000 Account: 135-50060-020-000 Account: 135-50060-020-000 Account: 135-50070-020-000 Account: 135-50070-020-000 Account: 135-55005-020-000 Account: 135-55005-020-000 Account: 135-55070-020-000 Account: 135-55070-020-000 252.00 Remaining 80 % Used Workman's Compensation Totals: 15,373.00 Budgeted Pre-emp Physicals/Testing 12.1411. 6,836.70 1,110.20 7,426.10 Remaining 52 5 Used Pre-emp Physicals/Testing To a e• 400.00 Budgeted 362.00 Remaining Employee Relations Employee Relations 300.00 Budgeted 300.00 Remaining Engineering Engineering 30,000.00 Budgeted 30,000.00 Remaining Independent Labor Independent Labor Totals: 15,000.00 Budgeted Account: 135-55080-020-000 Maintenance 6 Repairs 1089 04/20/2020 April A/P oil pads/masks 1109 04/27/2020 April A/P filters 38.00 10 % Used O % Used O 5 Used 3,000.00 12,000.00 Remaining 20 % Used 41,580.62 7,946.90 GL .00 38.00 .00 .00 .00 .00 .00 3,000.00 58.40 41,639.02 Ritz Safety, LLC 236.82 41,875.84 Filter Element Store 6370 AP 6389 AP glpdatb2 skrolczyk Trophy Club MUD No.1 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 21 1109 04/27/2020 April A/P 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Account: 135-55080-02 filters for MBR light bulbs vinyl/poly tube Maintenance & Repairs Totals: 88,000.00 Budgeted 41,580.62 215.95 42,091.79 Filter Element Store 6389 AP 35.32 42,127.11 THE HOME DEPOT #6581 PC 9.25 42,136.36 THE HOME DEPOT #6581 PC 45,863.64 Remaining 48 % Used Account: 135-55081-020-000 1177 04/30/2020 April A/P 390.21 18,113.87 CLS SEWER EQUIPMENT CO., INC Account: 135-55081-020-000 Mainten & Repairs Collections Vac truck 17,723.66 6420 AP Mainten & Repairs Collecti 10,000.00 Budgeted (8,113.87) Remaining 181 Used Account: 135-55085-020-000 sura or allialrand .00 .00 Account: 135-55085-020-00' Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-00 Vehicle Maintenance 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 wiper fluid/IDI 793.98 30.96 824.94 O'REILLY AUTO PARTS 55 Vehicle Maintenance 4,000.00 Budgeted 3,175.06 Remaining 21 % Used Veh Maintenance Collections 2,011.88 .00 2,011.88 Account: 135-55091-020-000 Veh Maintenance Collections Totals: 8,000.00 Budgeted 5,988.12 Remaining 25 % Ueed PC Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 832.22 .00 832.22 Account: 135-55105-020-000 Maintenance-Backhoe/Skid 3,000.00 Budgeted 2,167.78 Remaining 28 Ueed Account: 135-55120-020-000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1089 04/20/2020 April A/P Janitorial service -March Account: 135-55120-020-000 Cleaning Services 1,500.00 Budgeted Account: 135-55125-020-000 -EMDumpster Services 1089 04/20/2020 April A/P Sludge/grit 1109 04/27/2020 April A/P Sludge/grit 1177 04/30/2020 April A/P Sludge/grit Account: 135-55125-020-000 Account: 135-55135-020-00 1089 04/20/2020 April A/P 1089 04/20/2020 April A/P 1089 04/20/2020 April A/P 1089 04/20/2020 April A/P 1109 04/27/2020 April A/P 1109 04/27/2020 April A/P 1177 04/30/2020 April A/P 1177 04/30/2020 April A/P Account: 135-55135-020-000 1089 04/20/2020 April A/P Acccuntlr Dumpster Services 100,000.00 Budgeted lab testing lab trsting lab testing lab trsting lab testing lab testing lab testing lab testing Lab Analysis 40,000.00 Budgeted Communications/Mobiles Cell phones -April 437.50 87.50 525.00 MEMBER'S BUILDING MAINTENANCE 6367 AP Totals:diL 975.00 Remaining 35 % Used 43,283.38 48,383.82 Remaining 52 % Used 8 3,510.44 3,562.52 1,259.84 46,793.82 L.H. CHANEY MATERIALS, INC. 50,356.34 L.H. CHANEY MATERIALS, INC. 51,616.18 L.H. CHANEY MATERIALS, INC. 19,043.90 341.55 19,385.45 OXIDOR LABORATORIES LLC 241.50 19,626.95 OXIDOR LABORATORIES LLC 341.55 19,968.50 OXIDOR LABORATORIES LLC 241.50 20,210.00 OXIDOR LABORATORIES LLC 341.55 20,551.55 OXIDOR LABORATORIES LLC 241.50 20,793.05 OXIDOR LABORATORIES LLC 341.55 21,134.60 OXIDOR LABORATORIES LLC 241.50 21,376.10 OXIDOR LABORATORIES LLC 18,623.90 Remaining 53 % Used 3,088.27 407.91 Communications/Mobiles Totals: 5,000.00 Budgeted 1,503.82 Remaining 70 % Used Account: 135-60020-020-000 -11.1111011 1089 04/20/2020 April A/P Electricity 3/10-4/8 1181 04/30/2020 Town Billed Invoices 1734-1737 AR 20200430-20200430 User: Electricity 160,067.00 Budgeted 61,290.51 12,281.63 86,819.01 Remaining 46 % Used 6362 AP 6392 AP 6428 AP 6368 AP 6368 AP 6368 AP 6368 AP 6395 AP 6395 AP 6431 AP 6431 AP 3,496.18 VERIZON WIRELESS 6380 AP 73,572.14 HUDSON ENERGY SERVICES, LLC 6358 AP (324.15) 73,247.99 73,247.99 AR glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 23 Check Source Number Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 11 Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 Account: 135-60070-020-000 Account: 135-60080-020-000 Account: 135-60080-020-000 Account: 135-60090-020-000 Account: 135-60090-020-000 Account: 135-60100-020-000 Account: 135-60100-020-000 Account: 135-60105-020-000 Account: 135-60105-020-000 Account: 135-60125-020-000 Dues & Memberships Dues & Memberships 300.00 Budgeted Schools & Training Schools & Training 4,990.00 Budgeted Safety Program Safety Program 1,000.00 Budgeted 84.00 Remaining 2,027.15 Remaining 890.86 Remaining 216.00 2,962.85 109.14 410.72 0 % Used .00 216.00 72 % Used .00 2,962.85 59 % Used 11 % Used ir Travel & per diem Totals: 1,545.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment Totals: 1,134.28 Remaining 27 % Used .00 109.14 .00 410.72 .00 .00 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Account: 135-60245-020-000 Account: 135-60280-020-000 .00 .00 Advertising Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 % Used TCEQ Fees & Permits AIL TCEQ Fees & Permits 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Miscellaneous Expenses Miscellaneous Expenses 450.00 Budgeted Property Maintenance 10,088.02 450.00 Remaining 0 % Used .00 10,088.02 .00 .00 584.94 .00 Account: 135-60280-020-00: Property Maintenance Totals: 5,000.00 Budgeted 4,415.06 Remaining 12 % Used Account: 135-60285-020-000 - 1177 04/30/2020 April A/P Lawn Equipment & Maintenance Mowing -April 590.00 890.00 Account: 135-6028 Lawn Equipment & Maintenance Totals: 890.00 14,000.00 Budgeted 12,520.00 Remaining 11 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1161 04/30/2020 TexPool Transfers April TexPool O&M to I&S- PID Debt 62,488.86 10,414.81 Account: 135-60331-020-000 Interfund Transfer Out -Tax 114,563.00 Budgeted 41,659.33 Remaining Account: 13Tirtransfer Out -R 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bd WWTP I&S 381,241.74 64 % Used 10,414.81 54,421.63 584.94 1,480.00 WATTS ELLISON LLC 72,903.67 435,663.37 6439 AP GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC Interfund Transfer Out -Rev I8S Tota 673,867.00 Budgeted 238,203.63 Remaining Interfund Transfer Out -Reserve 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bond Resevr Account: 135-60333-020-00u Account: 135-60334-020-000111111 Account: 135-60334-020-000 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 84,937.00 Remaining Interfund Transfer Out Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-020-000 1116. Furniture/Equipment < $5000 Account: 135-60360-020-000 Account: 135-65005-020- 1111 04/24/2020 Fuel- April Account: 135-65005-020-00611111111111 Account: 135-65010-020-000 Account: 135-65010-020-000 `Furniture/Equipment < $500 2,000.00 Budgeted Fuel -Apr Fuel & Lube - 12,500.00 Budgeted Unif Uniforms - 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals 1089 04/20/2020 April A/P Defoamer 1109 04/27/2020 April A/P sodium hypo 12.5% 1,810.00 Remaining 7,761.87 Remaining 34,500.00 190.00 65 % Used 32 % Used 0 % Used 10 Used 5,750.00 40,250.00 .00 .00 .00 190.00 GL 4,246.70 491.43 4,738.13 US Bank Voyager Fleet Systems 6398 AP 3,507 93 38 % Used 1,987.07 Remaining 64 % Used 0 3,507.93 14,928.95 1,630.47 16,559.42 MARYLAND BIOCHEMICAL CO, INC 6365 AP 580.00 17,139.42 Valley Solvent Company, INC 6399 AP glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135 Account: 135-65031-020-000 Account: 135-65031-020-000 Account: 135-65035-020-000 Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Account: 135-65045-020-000 1109 04/27/2020 April A/P Account: 135-65045-020-000 Acc.005-020-000 1177 04/30/2020 April A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 4/2020 JE Detail Description/Comment Chemicals 20,000.00 Budgeted Chemicals Collections M.Chemicals Collections 2,860.58 Page 26 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Remaining 4,994.00 Totals: 86 % Used 17,500.00 Budgeted 12,506.00 Remaining 29 % Used Small Tools Small Tools Totals: 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Safety Equipment Safety Equipment 1,200.00 Budgeted Lab Suppl =_ nitrile gloves Lab Supplies 20,000.00 Budgeted Capital Outlays WWTP foam system Capital Outlays 530,500.00 Budgeted 33.47 Remaining 1,166.53 16,270.18 97 % Used .00 4,994.00 .00 .00 .00 1,166.53 162.00 3,567.82 Remaining 82 % Used 348,437.00 Account: 135-69008-020-000 Short Term Debt -Principal 16,432.18 LOU'S GLOVES INCORPORATED 6393 AP 172,538.00 9,525.00 182,063.00 CP&Y/WALLACE GROUP, INC. 6422 AP Remaining 59,604.74 34 Used .00 59,604.74 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 Short Term Debt -Principal Totals: 79,133.00 Budgeted 19,528.26 Remaining Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 75 5 Used 6,122.03 Short Term Debt -Interest Totals: 11,277.00 Budgeted 5,154.97 Remaining 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: 54 5 Used 100 5 Used .00 6,122.03 .00 130,000.00 1,551,112.10 ** 156,974.93 Monthly Total 3,157,421.00 Budgeted 1,606,308.90 Remaining 49 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 28 Account: 135-50045-026-0 Workman's Compensation 72 04/01/2020 lneurance/Wrk Comp Expense Apr Acil Workman's Compensation 30.00 Budgeted 1 11.94 1.99 13.93 GL Totals: 1 16.07 Remaining 46 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts 111 Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining O % Ueed .00 .00 111 Dues & Memberships Account715919.111WII Dues & MembershipsmmTotal= 750.00 Budgeted 75.00 Remaining Account:,35-60075-026-000 Meetings 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Online Board Meetings 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Online Board Meetings Account: Account: 135-60080-026-000 ■ Account: 135-60100-026-000 Account: 135-60100-026-000 Meetings 1,300.00 Budgeted Schools & Training Schools & Training 4,000.00 Budgeted Travel & per diem 675.00 .00 90 % Ueed 675.00 176.28 97.55 273.83 ZOOM.US 15.99 289.82 ZOOM.US Totals: 1,010.18 Remaining 22 % Used Totals: 4,000.00 Remaining 0 % Ueed 1 Totals: 5,000.00 Budgeted 5,000.00 Remaining .00 .00 .00 .00 O % Used PC PC Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 115.53 Monthly Total 13,230.00 Budgeted 978.75 •• 12,251.25 Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-50005-030- Salaries & 415 - 987 04/03/2020 MUD Payroll 4/3/2020 Salaries & Wages 178,489.43 1065 04/17/2020 Mud Payroll 4/17/2020 Salaries & Wages Account :-'5nrelrSalaries & Wages Totals: 628,298.00 Budgeted Account: 135-50010-030-000 Overtime Account: 135-50010-030-000 Overtime� 2,000.00 Budgeted 418,929.99 Remaining 33 % Used 31.77 1,968.23 Remaining 2 % Used 15,070.71 193,560.14 PR 15,807.87 209,368.01 PR Account: 135-50016-030-000 Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 Retireme 987 04/03/2020 MUD Payroll 4/3/2020 Retirement 1065 04/17/2020 Mud Payroll 4/17/2020 Retirement Account: 135-50020-030-000 2,207.50 100 % Used 18,232.16 .00 31.77 .00 2,207.50 1,395.54 19,627.70 1,463.81 21,091.51 Retirml 2,859.35 58,554.00 Budgeted 37,462.49 Remaining Account: 135-50026-030-000edical ce 987 04/03/2020 MUD Payroll 4/3/2020 Medical Insurance 1065 04/17/2020 Mud Payroll 4/17/2020 Medical Insurance Account: 135-50026-030-000 Medical Insurance ill= Totals: 124,394.00 Budgeted 82,544.49 Remaining Account: 135 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Dental Insurance Dental Insurance Dental Insurance Acc Dental Insuraa� Totals: 6,464.00 Budgeted 4,145.80 Remaining 35,503.74 1,968.45 36 % Used 34 % Used 36 5 Used 3,172.91 3,172.86 38,676.65 41,849.51 174.88 2,143.33 174.87 2,318.20 PR PR PR PR PR PR glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Description/Comment Page 31 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) A000 -50028-030- sion Ins 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Account: Vision Insurance Vision Insurance Bion Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 965 04/01/2020 Payroll Benefits- April Employee Benefits 965 04/01/2020 Payroll Benefits- April Employee LTD & STD 301.35 Totals: 681.97 Remaining 34 % Used 1,995.36 25.85 25.83 327.20 353.03 167.88 2,163.24 Humana Inc 151.69 2,314.93 METLIFE GROUP BENEFITS 11.11 PR PR 6302 AP 6310 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Account: 135 987 04/03/2020 MUD Payroll 4/3/2020 1065 04/17/2020 Mud Payroll 4/17/2020 Account: 135-50040-030-000 987 04/03/2020 MUD Payroll 4/3/2020 4,500.00 Budgeted 2,185.07 Remaining 51 % Used Social Security Taxes Social Security Taxes Social Security Taxes L Social Security Taxes 39,215.00 Budgeted Medicare Tax= Medicare Taxes Medicare Taxes 26,983.92 Remaining edicare 9,171.00 Budgeted 6,310.48 Remaining Unemployment Taxes Unemployment Taxes 10,460.02 2,446.32 843.83 31 % Used 864.27 11,324.29 906.79 12,231.08 202.14 212.06 31 % Used 2,648.46 2,860.52 20.17 864.00 PR PR PR PR PR Account: 135-50040-030-000 Unemployment Taxes 576.00 Remaining 1,440.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 72 04/01/2020 Insurance/Wrk Comp Expense Apr 628.92 Account: 135-50045-030-00 kman's Compensation 1,775.00 Budgeted 60 % Used Totals: 1,041.26 Remaining 41 % Used 104.82 733.74 GL glpdatb2 skrolczyk Trophy Club MUD No.1 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 32 Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-50060-030-000 1 Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining 0 % Used .00 .00 Account: 135-50070-030-000 Employee Relations Account: 135-50070-030 Employee Relations 8,000.00 Budgeted Account: 135 ftware & Su 1064 04/13/2020 April A/P Internet -April 1089 04/20/2020 April A/P Microsoft exchange 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 website 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 adobe subscription 3,078.10 4,921.90 Remaining 131,676.58 Account: 135-55030-030-001Iftware & Support_ Totals: 134,681.00 Budgeted 1,334.76 Remaining Independent Labor 1120 04/30/2020 April A/P GM search .00 3,078.10 38 % Used 899.00 132,575.58 Charter Communications 494.00 133,069.58 M3 Networks 239.88 133,309.46 DNB*GODADDY.COM 36.78 133,346.24 ADOBE ACROPRO SUBS 99 % Used 6348 AP 6364 AP PC PC 57,200.02 18,511.86 75,711.88 Strategic Government Resources 6396 AP AC Independent Labor 135,000.00 Budgeted 59,288.12 Remaining 56 % Used Account: 135 Maintenance & Repairs 1177 04/30/2020 April A/P pest control -quarterly Account: 135-55080-030-000 Maintenance & Repairs 15,000.00 Budgeted 1,165.00 110.00 1,275.00 Exclusive Pest Control Totals: W ' 13,725.00 Remaining 9 % Used 6425 AP Account: 135-55085-030-000 Generator Maint. and Repair 531.00 Account: 135-55085-030-0001 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining 5 % Used .00 531.00 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 33 Check Source Number 967 04/01/2020 April A/P 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Answering service -April phone phone answering service 1181 04/30/2020 Town Billed Invoices 1734-1737 AR 20200430-20200430 User: 8,880.17 194.75 466.31 797.33 14.99 (180.00) 9,074.92 KEYSTONE PARK SECRETARIAL 9,541.23 ATT*BUS PHONE PMT 10,338.56 ATT*BUS PHONE PMT 10,353.55 RINGCENTRAL, INC 10,173.55 6306 AP PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,293.38 10,173.55 ** Account: 135-55120-030-000 23,680.00 Budgeted 13,506.45 Remaining Cleaning Services Used Account: 135-60010-030-000 1089 04/20/2020 April A/P Janitorial service -March 4,345.30 1,416.42 5,761.72 MEMBER'S BUILDING MAINTENANCE 6367 AP Account: 135-55120-030-000 Cleaning Services Totals: 1,577.31 1,715.86 VERIZON WIRELESS 1,416.42 5,761.72 ** 135-60010-030-000 Communications/Mobiles Totals: 288.55 10,000.00 Budgeted 4,238.28 Remaining 58 % Used 4,000.00 Budgeted 2,284.14 Remaining 43 % Account: 135-55160-030-000 Professional Outside Services Account: 135-60020-030-000 Electricity/Gas 2,500.00 .00 2,500.00 Gexa energy 2/10-3/10 2,753.81 695.53 Account: 135-55160-030-000 6397 Professional Outside Services Totals: .00 2,500.00 ** 65,600.00 Budgeted 63,100.00 Remaining 4 % Used Account: 135-55205-030-000 Utility Billing Contract 1177 04/30/2020 April A/P Water billings -April 3,642.04 537.64 4,179.68 DATAPROSE LLC 6423 AP Account: 135-55205-030-000 Utility Billing Contract Totals: 537.64 4,179.68 ** 9,000.00 Budgeted 4,820.32 Remaining 46 % Used Account: 135-60005-030-000 Telephone 967 04/01/2020 April A/P 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Answering service -April phone phone answering service 1181 04/30/2020 Town Billed Invoices 1734-1737 AR 20200430-20200430 User: 8,880.17 194.75 466.31 797.33 14.99 (180.00) 9,074.92 KEYSTONE PARK SECRETARIAL 9,541.23 ATT*BUS PHONE PMT 10,338.56 ATT*BUS PHONE PMT 10,353.55 RINGCENTRAL, INC 10,173.55 6306 AP PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,293.38 10,173.55 ** 23,680.00 Budgeted 13,506.45 Remaining 43 % Used Account: 135-60010-030-000 Communications/Mobiles 1065 04/17/2020 Mud Payroll 1089 04/20/2020 April A/P 4/17/2020 Communications/Mobiles Cell phones -April 1,427.31 150.00 138.55 1,577.31 1,715.86 VERIZON WIRELESS 6380 PR AP Account: 135-60010-030-000 Communications/Mobiles Totals: 288.55 1,715.86 ** 4,000.00 Budgeted 2,284.14 Remaining 43 % Used Account: 135-60020-030-000 Electricity/Gas 1120 04/30/2020 April A/P Gexa energy 2/10-3/10 2,753.81 695.53 3,449.34 TOWN OF TROPHY CLUB 6397 AP glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 34 Check Source Number 1163 04/30/2020 Pace Credit Card Fees 1163 04/30/2020 Pace Credit Card Fees 1177 04/30/2020 April A/P 1177 04/30/2020 April A/P Dig Tess -April Direct send fees -April 36,723.18 4,807.27 68.87 252.70 50.00 41,530.45 41,599.32 41,852.02 41,902.02 GL GL Texas Excavation Safety System 6434 AP 6426 AP Fisery Solutions, LLC Account: 135-60020-030-000 Electricity/Gas Totals: & Fees Totals: 695.53 3,449.34 ** 41,902.02 ■ 6,879.00 Budgeted 3,429.66 Remaining 50 % Used 63 % Used Account: 135-60025-030-000 135-60050-030-000 Bad Debt Expense 1177 04/30/2020 1177 04/30/2020 1181 04/30/2020 April A/P April A/P Town Billed Invoices 1734-1737 water -March watel-April AR 20200430-20200430 User: 257.82 504.30 1,354.70 (637.80) 762.12 2,116.82 1,479.02 TROPHY CLUB MUD (WATER BILLS) TROPHY CLUB MUD (WATER BILLS) 6436 6436 AP AP AR Account: 135-60025-030-000 135-60050-030-000 Water Totals: Expense ` Totals: 1,221.20 1,479.02 ** .00 ** 1,500.00 Budgeted 20.98 Remaining 99 % Used 0 % Used Account: 135-60035-030-000 135-60055-030-000 Postage Insurance 1109 04/27/2020 1177 04/30/2020 April A/P April A/P Insurance/Wrk Comp Postage lease Water billings -April 10,153.57 107.67 1,464.27 10,261.24 11,725.51 FRANCOTYP-POSTALIA, INC. DATAPROSE LLC 6390 6423 AP AP Account: 135-60035-030-000 135-60055-030-000 Postage Totals: Totals: 1,571.94 11,725.51 ** 45,426.87 ** 30,000.00 Budgeted 18,274.49 Remaining 39 % Used 54 % Used Account: 135-60040-030-000 Service Charges & Fees 1163 04/30/2020 Pace Credit Card Fees 1163 04/30/2020 Pace Credit Card Fees 1177 04/30/2020 April A/P 1177 04/30/2020 April A/P Dig Tess -April Direct send fees -April 36,723.18 4,807.27 68.87 252.70 50.00 41,530.45 41,599.32 41,852.02 41,902.02 GL GL Texas Excavation Safety System 6434 AP 6426 AP Fisery Solutions, LLC Account: 135-60040-030-000 Service Charges & Fees Totals: 41,902.02 ** 67,000.00 Budgeted 25,097.98 Remaining 63 % 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 72 04/01/2020 Insurance/Wrk Comp Expense Apr 38,428.48 6,998.39 45,426.87 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 45,426.87 ** 84,000.00 Budgeted 38,573.13 Remaining 54 % Used glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 35 Check Source Number Account: 135-60066-030-000 Publications/Books/Subscripts ' 125.00 .00 125.00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 1 .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 3,971.51 .00 3,971.51 Account: 135-60079-030-000 Public Education Totals: .00 3,971.51 ** 6,000.00 Budgeted 2,028.49 Remaining 66 % Used Account: 135-60080-030-000 Schools & Training 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 webinar training 1,382.21 70.00 1,452.21 GOVERNMENT FINANCE OFF PC Account: 135-60080-030-000 Schools & Training Totals: 70.00 1,452.21 ** 6,850.00 Budgeted 5,397.79 Remaining 21 % Used Account: 135-60100-030-000 Travel & per diem 1177 04/30/2020 April A/P GM Interview Travel 714.16 306.48 1,020.64 Amber Beard 6419 AP Account: 135-60100-030-000 ' Travel & per diem Totals: 306.48 1,020.64 ** 3,545.00 Budgeted 2,524.36 Remaining 29 % Used Account: 135-60110-030-000 Physicals/Testing glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60110-030-000 Account: 135-60115-030-000 Account: 135-60115-030-000 Account: 135-60125-030-000 Account: 135-60125-030-000 Account: 135-60235-030-000 1089 04/20/2020 April A/P Account: 135-60235-030-000 Account: 135 Account: 135-60245-030-000 200.00 Budgeted Elections Election - .00 Budgeted Advertie .00 .00 Totals: 200.00 Remaining 0 % Used (138.04) Remaining 138.04 1,772.20 0 Used Advertising 2,500.00 Budgeted 727.80 Remaining 71 % Used .00 138.04 .00 1,772.20 Security monitoring svc-april 144.00 24.00 168.00 Digital Air Control, Inc Security 1,288.00 Budgeted 1,120.00 Remaining 13 % Used Miscellaneous Expenses .00 .00 Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingenc 17,000.00 Budgeted 17,000.00 Remaining Account: 135-60360-030-000 500.00 Remaining 0 % Ueed .00 .00 0 % Used .00 .00 6355 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 Account: 135-65010-030-000 Account: 135-65010-030-000 Account: 135-65055-030-000 Account: 135-65055-030-000 ■ Furniture/Equipment < $5000 Tota 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms 2,050.00 Budgeted Hardware Ha. 26,485.00 Budgeted Account: 135-65085-030-000 1089 04/20/2020 April A/P 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Account: 135-65085-030-000 Hand sanitizer audio convertor Office Supplies 6,000.00 Budgeted 0 % Used .00 .00 2,050.00 Remaining 0 % Used 3,235.24 .00 3,235.24 23,249.76 Remaining 12 % Used 2,200.25 210.00 2,410.25 Precision Pump Systeme 21.60 2,431.85 FS *FREEMAKE.COM Totals: 231.60 2,431.85 ** 3,568.15 Remaining 41 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance AcCLunL: Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Account: 135-65095-030-000 Maintenance Supplies 1124 04/27/2020 Pcards 3/27/2020-4/27/2020 Lysol, Air Freshner,papertowel 2,809.63 Account: 135-65095-030-000 Maintenance Supplies 4,000.00 Budgeted Account: 135-65105-030-000 .00 0 % Used 38.90 1,151.47 Remaining 71 % Used .00 .00 2,848.53 NAL -MART #5247 .00 6369 AP PC PC glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Description/Comment 2,500.00 Budgeted Ys 1089 04/20/2020 April A/P Boundary update 1177 04/30/2020 April A/P GIS development 2,500.00 1177 04/30/2020 April A/P Board laptops upgrade 1064 04/13/2020 April A/P 1109 04/27/2020 April A/P Department 30 Totals: Page 38 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Remaining Capital Outlays * Totals: 195,000.00 Budgeted 167,990.25 Remaining Copier Lease Installments copier lease-april copies i Copier Lease Installments 4,000.00 Budgeted 2,265.90 Remaining 2,915.30 0 Used 15,558.82 3,669.08 4,866.55 14 % Used 00 ** 18,474.12 Halff Associates, INC 22,143.20 Halff Associates, INC 27,009.75 M3 Networks 1,546.33 165.00 1,711.33 TIAA COMMERCIAL FINANCE 22.77 1,734.10 KYOCERA DOCUMENT SOLUTIONS 43 % Used 10 ** 688,787.30 ** 107,561.56 Monthly Total 1,776,712.00 Budgeted 1,087,924.70 Remaining 39 % Used 6357 AP 6427 AP 6429 AP 6376 AP 6391 AP glpdatb2 skrolczyk 16:32 05/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 4/2020 Beginning Transaction Balance Detail JE Detail Description/Comment Program: Page 39 Transaction Vendor Name Check Source Detail Number (SUBTOTAL) A000 35-55045-039-0 1089 04/20/2020 April A/P Westlake easment 82,964.89 2,620.50 85,585.39 WHITAKER CHALK SWINDLE 6382 AP Ac Legal 135,000.00 Budgeted Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 Auditing 33,800.00 Budgeted Account: 135-55060-039-000 Appraisal Account: 135-55060-039-000 Appraisal 11,761.00 Budgeted Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 Tax Admin Fees 4,000.00 Budgeted Department 39 Totals: Fund 135 Totals: 2,620.50 Monthly Total (105,054.85) Monthly Total 49,414.61 Remaining 27,713.27 6,086.73 Remaining 7,422.04 4,338.96 Remaining 3,756.00 244.00 Remaining 63 % Used .00 27,713.27 82 % Used .00 7,422.04 63 % Used 94 % Used .00 3,756.00 124,476.70 ** 184,561.00 Budgeted 60,084.30 Remaining 67 % Used (49,158.58) (6,224.00) Budgeted 92,934.58 Remaining 790 9 Used glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 40 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 APRIL 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE u TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 519,492 TOTAL ASSETS 519,492 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 (47,574) TOTAL FUND BALANCE (165,984) TOTAL LIABILITIES AND FUND BALANCE 519,492 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 196.04- 4,694.66- 4,694.66 Page 14 Subtotal: • 196.04- 4,694.66- 4,694.66 Program number: 1 196.04- 4,694.66- 4,694.66 Department number: Revenues - 196.04- 4,694.66- 4,694.66 Revenues Subtotal 196.04- 4,694.66- 4,694.66 glbase_tbam skrolczyk 16:31 05/13/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description 517-69005-020-000 Capital Outlays Subtotal: Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 4/2020 Adopted Amended Total Current Budget Budget Encumb. Month 4,957.50 Program: YTD % of Remaining Total Budget Budget 52,268.91 4,957.50 52,268.91 52,268.91- 52,268.91- Department number: Wastewater Expenditures Subtotal Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 4,957.50 4,957.50 4,761.46 52,268.91 52,268.91 47,574.25 52,268.91- 52,268.91- 47,574.25 - Page 15 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A00O." 1-000-000 1162 04/30/2020 Bank Interest- April Accc.unti Interest Income (4,498.62) (196.04) (4,694.66) GL Interest Income .00 Budgeted Totals: 4,694.66 Remaining 0 % Used (196.04) (4,694.66) Department Totals: (4,694.66) ** (196.04) Monthly Total .00 Budgeted 4,694.66 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1089 04/20/2020 April A/P WWTP legal 47,311.41 4,957.50 52,268.91 CP&Y/WALLACE GROUP, INC. 6351 AP Account: 517-69005-020-000 Capital Outlays Totals: 4,957.50 52,268.91 ** .00 Budgeted (52,268.91) Remaining 0 % Used Department 20 Totals: 52,268.91 ** 4,957.50 Monthly Total .00 Budgeted (52,268.91) Remaining 0 % Used Fund 517 Totals: 47,574.25 4,761.46 Monthly Total .00 Budgeted (47,574.25) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,934 TOTAL ASSETS 784,934 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,595 703,243 784,934 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 4/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 230.95- 4,595.25- 4,595.25 Page 16 Subtotal: ✓ 230.95- 4,595.25- 4,595.25 J IM Program number: 1 230.95- 4,595.25- 4,595.25 Department number: Revenues 230.95- 4,595.25- 4,595.25 Revenues Subtotal 230.95- 4,595.25- 4,595.25 I Fund number: 519 2016 Rev Bond Const -SWIFT 230.95- 4,595.25- 4,595.25 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACcou l-000-000 Interest Income 1162 04/30/2020 Bank Interest- April Account Interest Income Totals: Department Totals: .00 Budgeted (4,364.30) (230.95) (4,595.25) GL (230.95) (4,595.25) ** 4,595.25 Remaining 0 % Used (230.95) Monthly Total .00 Budgeted (4,595.25) ** 4,595.25 Remaining 0 % Used Fund 519 Totals: (4,595.25) (230.95) Monthly Total .00 Budgeted 4,595.25 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET APRIL 2020 TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 444,794 INVESTMENTS 3,892,362 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,337,156 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,454,290 (117,134) 4,337,156 4,337,156 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 1,313.11- 27,447.05- 27,447.05 Page 17 Subtotal: 1,313.11- 27,447.05- 27,447.05 Program number: 1,313.11- 27,447.05- 27,447.05 Department number: 1,313.11- 27,447.05- 27,447.05 Revenues Subtotal 1,313.11- 27,447.05- 27,447.05 glbase_tbam skrolczyk 16:31 05/13/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: 4/2020 Adopted Amended Total Current Budget Budget Encumb. Month 4,288.10 Program: YTD Total 144,580.81 % of Remaining Budget Budget 144,580.81 - Page 18 Subtotal: • 4,288.10 144,580.81 144,580.81 - Program number: I 4,288.10 144,580.81 144,580.81 - Department number: Water Department 4,288.10 144,580.81 144,580.81 - Expenditures Subtotal 4,288.10 144,580.81 144,580.81 - Fund number: 520 Revenue Bond 16" Waterline WM= 2,974.99 117,133.76 117,133.76- glpdatb2 skrolczyk Trophy Club MUD No.1 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 44 1162 04/30/2020 Bank Interest- April (26,133.94) 1162 04/30/2020 Bank Interest- April Account: 520-490 nterest Income .00 Budgeted Totals: 27,447.05 Remaining 0 % Used (167.87) (26,301.81) GL (1,145.24) (27,447.05) GL Department Totals: (27,447.05) ** (1,313.11) Monthly Total .00 Budgeted 27,447.05 Remaining 0 % Used glpdatb2 skrolczyk 16:32 05/13/20 Fund: 520 Revenue Bond 16" Waterline JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Period Ending: 4/2020 JE Detail Beginning Balance Description/Comment Accoamitimiligijaalilialgi Capital Outlays I 1060 04/13/2020 Void and reissue check 16" water Line easement 1060 04/13/2020 Void and reissue check 16" Water Line easement 1061 04/13/2020 April A/P 1061 04/13/2020 April A/P 1089 04/20/2020 April A/P 1089 04/20/2020 April A/P 16" water Line easement 16" water line easement 16" water line easement acquis easement 16" water line 140,292.71 Program: Transaction Detail (64,106.00) (5,096.00) 64,106.00 5,096.00 3,560.00 728.10 Transaction Vendor Name Detail (SUBTOTAL) 76,186.71 71,090.71 135,196.71 140,292.71 143,852.71 144,580.81 Trophy Club Economic Dev Corp Trophy Club Economic Dev Corp Trophy Club Economic Dev Corp Town of Trophy Club, a Tx Muni Halff Associates, INC Jackson Walker LLP Page 45 Check Source Number 6240 AP 6240 AP 6385 AP 6383 AP 6357 AP 6360 AP Account: 520 Capital Outlays Totals: Department 10 Totals: Fund 520 Totals: .00 Budgeted (144,580.81) Remaining 4,288.10 Monthly Total 2,974.99 Monthly Total 0 % Used .00 Budgeted .00 Budgeted 144,580.81 ** (144,580.81) Remaining 0 % Used 117,133.76 (117,133.76) Remaining 0 5 Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 882,757 TOTAL ASSETS 882,757 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 79,300 882,757 882,757 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- Subtotal: m 518,466.00- 518,466.00 - Program number: 1 518,466.00- 518,466.00 - Department number: 518,466.00- 518,466.00 - Revenues Subtotal 518,466.00- 518,466.00 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 326.47- 4,600.00- 5,750.00- 6,849.53- 32,200.00- 40,250.00- 62.268 10.487 20.083 4,150.47- 274,849.00- 160,167.00- 10,676.47- 79, 439,166.47- 10,676.47- 95 439,166.47- 10,676.47- 95 439,166.47- 10,676.47- 79, 95 439,166.47- 10,676.47- 95 439,166.47 - Page 19 glpdatb2 skrolczyk 16:32 05/13/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description ACCOfa. l-000-000 Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 46 Period Ending: 4/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income 1162 04/30/2020 Bank Interest- April Ac 8-490 come 1 (11,000.00) Budgeted (4,150.47) Remaining Account: 528-49142-000-000 Interfund tr 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bond Resevr Account:W49142-000-000 8-49143-000-000 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bond Resevr (6,523.06) (326.47) (6,849.53) 62 % Used (27,600.00) Interfund transfer in -Water Totals: (307,049.00) Budgeted (274,849.00) Remaining Interfund transfer in -WW Account: 528-49143-11Interfund transfer in - (200,417.00) Budgeted (4,600.00) 10 % Used (34,500.00) (160,167.00) Remaining (5,750.00) 20 % Used (32,200.00) (40,250.00) Department Totals: (79,299.53) ** (10,676.47) Monthly Total (518,466.00) Budgeted (439,166.47) Remaining 15 % Used Fund 528 Totals: (79,299.53) (10,676.47) Monthly Total (518,466.00) Budgeted (439,166.47) Remaining 15 % Used GL GL GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET APRIL 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 IPA TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 933,671 25,559 959,230 25,559 25,559 82,954 850,717 933,671 959,230 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 533-49011-000-000 533-49015-000-000 533-49141-000-000 Subtot Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Program number: Department number: Revenues Revenues Subtotal 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 685,441.00- 685,441.00- 5,000.00- 218,004.00- 114,563.00- 0- 0- 1,023,008.00- 1,023,008.00- 5,000.00- 218,004.00- 114,563.00- 337,567.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,066.56 22.62- 261.85- 782.09 346.06- 10,414.81- 8- 78- 78- 678,137.33- 1,853.78- 1,665.43- 681,656.54- 3,531.93- 218,004.00- 72,903.67- 99.369 185.378 83.272 70.639 100.000 63.636 87.224 95.414 95.414 95.414 4,303.67- 853.78 334.57- 34.57- 3,784.46- 1,468.07- 41,659.33- 43, 46,911. 3,784.46-1,468.07-41,659.33-43,46,911. 46,911.8 46,91 Page Page 20 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 1,450.00 67.442 700.00 533-70025-051-000 Bond Interest Expense -Tax 247,858.00 247,858.00 123,928.75 50.000 123,929.25 533-70035-051-000 Bond Principal Payment -Tax 765,000.00 765,000.00 765,000.00 Subtotal: Program number: Department number: Administration Expenditures Subtotall Fund number: 533 MUD 1 I&S Consolidated • - 1,015,008.00 1,015,008.00 1,015,008.00 1,015,008.00 ilp15,008.00 1,015,008.00 1,015,008.00 1,015,008.00 125,378.1 12.352 125,378.7T 12.352 125,378.75 12.352 125,378.75 12.352 850,717.39- ############### 8,000.00- 8,000.00- 9,978.78- 889,629.25 889,629.25 889,629. 889,629. 842, Page 21 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 L Property Taxes 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1148 04/22/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes (679,203.89) (1,271.11) (29.36) (96.37) (525.41) (4.59) 4,619.33 (1,559.79) (16.47) (54.41) 4.74 (680,475.00) (680,504.36) (680,600.73) (681,126.14) (681,130.73) (676,511.40) (678,071.19) (678,087.66) (678,142.07) (678,137.33) GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: 1,066.56 (678,137.33) ** (682,441.00) Budgeted (4,303.67) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1149 04/23/2020 Property Taxes 1153 04/29/2020 Property Taxes (1,831.16) (8.77) (1,839.93) (.06) (1,839.99) (6.07) (1,846.06) (7.72) (1,853.78) GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,853.78) ** (1,000.00) Budgeted 853.78 Remaining 185 % Used Account: 533-40015-000-000 Property Taxes/P & I 1143 04/07/2020 Property Taxes 1144 04/08/2020 Property Taxes 1145 04/15/2020 Property Taxes 1146 04/20/2020 Property Taxes 1147 04/21/2020 Property Taxes 1149 04/23/2020 Property Taxes 1150 04/24/2020 Property Taxes 1151 04/27/2020 Property Taxes 1152 04/28/2020 Property Taxes 1153 04/29/2020 Property Taxes (1,403.58) (23.51) (1,427.09) (4.42) (1,431.51) (1.84) (1,433.35) (57.79) (1,491.14) (.45) (1,491.59) (1.46) (1,493.05) (162.96) (1,656.01) (1.82) (1,657.83) (5.98) (1,663.81) (1.62) (1,665.43) GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (261.85) (1,665.43) ** (2,000.00) Budgeted (334.57) Remaining 83 % Used Account: 533-49011-000-000 Interest Income glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1162 04/30/2020 Bank Interest- April (3,185.87) (346.06) Account: 533-49011-000-8 Interest Income Totals: _ (5,000.00) Budgeted (1,468.07) Remaining Lease/Rental Income Account: 533-49015-000-000 Account: 533-49015-000-000 Account: 533-49141-000-000 71 % Used (218,004.00) (3,531.93) GL (3 9 .00 (218,004.00) Lease/Rental Income .00 (218,004.00) ** (218,004.00) Budgeted Interfund T PID Surchg 1161 04/30/2020 TexPool Transfers April TexPool O&M to I&S- PID Debt (62,488.86) (10,414.81) (72,903.67) .00 Remaining 100 % Used Department Totals: Interfund Trans In -PID Surchg Totals: (114,563.00) Budgeted (41,659.33) Remaining 64 % Used (976,096.14) ** (9,978.78) Monthly Total (1,023,008.00) Budgeted (46,911.86) Remaining 95 % Used GL Account: 533-70035-051-000 Bond Principal Payment -Tax glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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 (9,978.78) Monthly Total (850,717.39) (8,000.00) Budgeted 842,717.39 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE NAll TROPHY CLUB i MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 302,353 TOTAL ASSETS 302,353 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 277,835 302,353 302,353 glbase_tbam skrolczyk 16:31 05/13/20 Fund: 534 2015 Revenue Bond I&S Account Description 534-49011-000-000 Interest Income 534-49143-000-000 Interfund Transfer In -WW Sales Subtot Program number: Department number: Revenues Revenues Subtotal Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 4/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,500.00- 2,500.00- 598,638.00- 598,638.00- 60f 0- 6011.38.00- 601 00- 6011'38.00- 601,138.00- 601,138.00- 601,138.00- 601,138.00 - Program: YTD % of Remaining Total Budget Budget 93.76- 1,203.00- 48.120 1,297.00- 54,421.63- 380,950.81- 63.636 217,687.19- 54,515.39- 54,515.39- 3Errr 218,984.19- 54,515.39- 382, 63.572 218,984.19- 54,515.39- 382,153.81- 63.572 218,984.19- Page 22 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 534-70040-051-000 Revenue Bona Interest Expense 208,238.00 208,238.00 104,118.75 50.000 104,119.25 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 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=Plin 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,31 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,515.39- '5.06- ############### 275,335.06 Page 23 glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 50 Check Source Number Department Totals: (54,515.39) Monthly Total (382,153.81) ** (601,138.00) Budgeted (218,984.19) Remaining 64 5 Used Account: 534-49011-000-000 Interest Income 1162 04/30/2020 Bank Interest- April (1,109.24) (93.76) (1,203.00) GL Account: 534-49011-000-000 Interest Income Totals: i (93.76) (1,203.00) ** (2,500.00) Budgeted (1,297.00) Remaining 48 5 Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1161 04/30/2020 TexPool Transfers April TexPool O&M to Rev Bd WWTP I&S (326,529.18) (54,421.63) (380,950.81) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: ; (54,421.63) (380,950.81) ** (598,638.00) Budgeted (217,687.19) Remaining 64 5 Used Department Totals: (54,515.39) Monthly Total (382,153.81) ** (601,138.00) Budgeted (218,984.19) Remaining 64 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 4/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: (277,835.06) (54,515.39) Monthly Total (2,500.00) Budgeted 275,335.06 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 NSII FTW SWIFT REVENUE BOND I&S 150,566 TOTAL ASSETS 150,566 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 145,600 150,566 150,566 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Subtot Program number: Department number: Revenues Revenues Subtotal 47.44- 25,047.72- 25.00-- 25,095.16= 0- 276125.00- 25,095.16- 0- 276,525.00- 25,095.16- 276,525.00- 276,525.00- 25,095.16- 527.98- 175,334.04- 175,862.02- 52.798 63.636 472.02- 100,190.96 - Page 24 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 200.00 25.000 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 30,062.50 7.772 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: , 502,611.00 602,611.00 5.022 Program number: _b02,611.00 602,611.00 II 30,262.50 5.022 Department number: Administration mEr 602,611.00 602,611.00 II 30,262.50 5.022 Expenditures Subtotal 602,611.00 602,611.00 II 30,262.50 5.022 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 25,095 145,599.52- -44.651 600.00 356,748.50 215,000.00 572,348.50 572,348.50 572,348.50 572,348.50 471,685.52 Page 25 glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (25,095.16) Monthly Total (175,862.02) ** (276,525.00) Budgeted (100,662.98) Remaining 64 5 Used Account: 535-49011-000-000 Interest Income 1162 04/30/2020 Bank Interest- April (480.54) (47.44) (527.98) GL Account: 535-49011-000-000 Interest Income Totals: (47.44) (527.98) ** (1,000.00) Budgeted (472.02) Remaining 53 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1161 04/30/2020 TexPool Transfers April TexPool O&M to 16Swift Rev I&S (150,286.32) (25,047.72) (175,334.04) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: r (25,047.72) (175,334.04) ** (275,525.00) Budgeted (100,190.96) Remaining 64 5 Used Department Totals: (25,095.16) Monthly Total (175,862.02) ** (276,525.00) Budgeted (100,662.98) Remaining 64 5 Used glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 53 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/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: (145,599.52) (25,095.16) Monthly Total 326,086.00 Budgeted 471,685.52 Remaining -45 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET APRIL 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 511 TROPHY CLUB MTJNICIPAL UTILITY IIISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,290 TOTAL ASSETS 23,290 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,290 TOTAL FUND BALANCE 23,290 TOTAL LIABILITIES AND FUND BALANCE 23,290 glbase tbam skrolczyk Trophy Club MUD No.1 16:31 05/13/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 4/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales 8.72- 443.52- 183,168.16- 54,712.56- 443.52 183,168.16 54,712.56 Page 26 Subtotal: r 8.72- 238,324.24- 238,324.24 Program number: 1 8.72- 238,324.24- 238,324.24 Department number: Revenues 1 8.72- 238,324.24- 238,324.24 Revenues Subtotal 8.72- 238,324.24- 238,324.24 glbase_tbam skrolczyk 16:31 05/13/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: 4/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 8.72- 23,289.73- 23,289.73 ******* End of Report ********* glpdatb2 skrolczyk 16:32 05/13/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: 4/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (8.72) Monthly Total .00 Budgeted (238,324.24) ** 238,324.24 Remaining 0 t Used Account: 536-49011-000-000 Interest Income 1162 04/30/2020 Bank Interest- April (434.80) (8.72) (443.52) GL Account: 536-49011-000-000 Interest Income Totals: (8.72) (443.52) ** .00 Budgeted 443.52 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) .00 (54,712.56) 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: (8.72) Monthly Total .00 Budgeted (238,324.24) ** 238,324.24 Remaining 0 t Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 16:32 05/13/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: 51 Administration Program: Period Ending: 4/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 (6.72) Monthly Total .00 Budgeted 215,034.51 ** (215,034.51) Remaining 0 5 Used (23,289.73) 23,289.73 Remaining 0 % Used ******* End of Report ********* (1,905,631.01) **** (134,898.99) Monthly Total (209,104.00) Budgeted 1,696,527.01 Remaining 911 5 Used