Loading...
HomeMy WebLinkAbout2019-11 Combined Financials November 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 329,248 PREPAID EXPENSES 16,409 ADVALOREM PROPERTY TAXES RECEIVABLE 1,187,888 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,533,547 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,187,895 1,187,895 603,769 (258,117) 345,652 1,533,547 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 16:37 12/09/19 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 122-40011-000-000 Property Taxes/Fire-Delinquent 122-40020-000-000 Property Taxes/Fire P&i Subtotal: Program number: Department number: Revenues Fire Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 60,041.08- 75,563.94- 914.94- 452.79 1,079.94- 1,148.41- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 6.223 6.280 6.280 6.280 6.280 1,138,666.06- 452.79- 1,148.41 1,137,970.44- 1,137,970.44- 1,137,970.44- 1,137,970.44- glbase_tbam skrolczyk 16:37 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment 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 Subtotal: 957,661.00 957,661.00 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtotal: Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 1,640.88 59,888.08 61,528.96 2,750.00 3,281.76 119,776.16 123,057.92 2,750.00 11,958.24 81,420.00 115,190.36 2,750.00 211,318.60 64,278.96 334,376.52 64,278.96 64,278.96 2,243.00 334,376.52 334,376.52 258,116.96 15.627 16.667 12.850 5.729 100.000 90.595 82.363 27.538 27.538 27.538 218,004.00 17,718.24 598,880.84 834,603.08 45,250.00 11,958.24- 11,958.64 45,250.40 879,853.48 879,853.48 879,853.48 258,116.96 - Page 2 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Account: 122-40010-000-000 Property Taxes/MUD Fire 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (15,522.86) (1,541.19) (3,618.25) (6,659.43) (2,600.62) (3,105.87) (5,666.45) (1,442.44) (6,701.27) (3,596.12) (1,484.48) (838.39) (3,442.24) (8,699.42) (1,935.40) (177.09) (3,646.78) (3,604.20) (1,281.44) (17,064.05) (20,682.30) (27,341.73) (29,942.35) (33,048.22) (38,714.67) (40,157.11) (46,858.38) (50,454.50) (51,938.98) (52,777.37) (56,219.61) (64,919.03) (66,854.43) (67,031.52) (70,678.30) (74,282.50) (75,563.94) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (60,041.08) (75,563.94) ** (1,214,230.00) Budgeted (1,138,666.06) Remaining 6 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 1,367.73 (212.72) (282.07) (3.44) 16.80 (433.51) 1,155.01 872.94 869.50 886.30 452.79 GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (914.94) 452.79 ** .00 Budgeted (452.79) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 363 11/01/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 372 11/15/2019 Property Taxes 374 11/19/2019 Property Taxes (68.47) (46.79) (1.13) (17.04) (1.12) (.08) (.97) (.65) (115.26) (116.39) (133.43) (134.55) (134.63) (135.60) (136.25) GL GL GL GL GL GL GL glpdatb2 skrolczyk 16:38 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 375 11/20/2019 Property Taxes 380 11/27/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 11/2019 JE Detail Beginning Transaction Transaction Vendor_Name Description/Comment Balance Detail Detail (SUBTOTAL) (68.47) (917.10) (95.06) (1,053.35) (1,148.41) Page 2 Check Source Number GL GL Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: (1,079.94) (1,148.41) ** .00 Budgeted 1,148.41 Remaining 0 % Used Department Totals: (62,035.96) Monthly Total (76,259.56) ** (1,214,230.00) Budgeted (1,137,970.44) Remaining 6 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 122 Trophy Club HUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2019 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 3 Detailed Accounting Trial Balance Account: 122-60030-045-000 Rent And/Or Usage Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 67 11/01/2019 Insurance/Wrk Comp Expense Nov Account: 122-60055-045-000 Account: 122-60337-045-000 225 11/06/2019 November A?P Account: 122-60337-045-000 Account: 122-69005-045-000 254 11/14/2019 November A/P 254 11/14/2019 November A/P Insurance 21,000.00 Budgeted 218,004.00 Remaining 0 % Used Totals: 17,718.24 Remaining Transfer to Town/Fire Budget Fire admin november Transfer to Town/Fire Budget Totals: 718,657.00 Budgeted 598,880.84 Remaining Capital Outlays exhaust silencer -capital exhaust silencer -capital .00 .00 .00 .00 ** 1,640.88 1,640.88 3,281.76 GL 1,640.88 3,281.76 ** 16 % Used 59,888.08 59,888.08 119,776.16 TOWN OF TROPHY CLUB 5901 AP 17 % Used 59,888.08 119,776.16 ** 1,700.00 1,700.00 ACE Heating s Air Conditioning 5904 AP 1,050.00 2,750.00 Rossman Enterprises Inc 5915 AP Account: 122-69005-045-000 Capital Outlays Totals: 2,750.00 2,750.00 ** Account: 122-69009-045-000 48,000.00 Budgeted Short Term Debt -Interest 45,250.00 Remaining 6 % Used 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 Account: 122-69195-045-000 81,420.00 .00 81,420.00 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 16:38 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment 115,190.36 .00 115,190.36 Account: 122-69305-045-000 Capital Leases Totals: .00 115,190.36 ** Department 45 Totals: Fund 122 Totals: 127,149.00 Budgeted 11,958.64 Remaining 91 % Used 64,278.96 Monthly Total 1,214,230.00 Budgeted 334,376.52 ** 879,853.48 Remaining 28 % Used 258,116.96 2,243.00 Monthly Total .00 Budgeted (258,116.96) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET NOVEMBER 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,983,393 2,983,393 CASH IN BANK -SAVINGS -CASH RESERVE 1,398,315 1,398,315 INVESTMENTS-TEXPOOL 4,202,332 919,266 5,121,598 PREPAID EXPENSES 93,355 93,355 ADVALOREM PROPERTY TAXES RECEIVABLE 131,786 131,786 UTILITY AND OTHER ACCOUNTS RECEIVABLE 845,820 845,820 TOTAL ASSETS 9,655,601 919,266 10,574,867 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 131,786 131,786 ACCOUNTS AND OTHER PAYABLES 843,081 843,081 CUSTOMER DEPOSITS 320,304 320,304 TOTAL LIABILITIES 1,295,171 1,295,171 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 (40,954) (40,954) TOTAL FUND BALANCE 8,360,430 919,266 9,279,696 TOTAL LIABILITIES AND FUND BALANCE 9,655,601 919,266 10,574,867 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Department: Adopted Budget 134,871.00- 300.00- 300.00- 164,253.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00 - Current Month 6,665.28- 104.26- 120.35 - Program: YTD Total 8,388.52- 51.40 128.17- % of Budget 6.220 -17.133 42.723 Remaining Budget 126,482.48- 351.40- 171.83- 164,253.00 - Page 3 Subtotal: 299,724.00- 299,724.00- 6,889.89- 8,465.29- 2.824 291,258.71- 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 330,533.22- 255,418.37- 10,521.29- 2,150.00- 12.80- 866,912.50- 477,378.73- 20,502.72- 3,225.00- 1,800.00- 400.00- 15,048.80- 13.365 13.624 18.207 21.287 240.000 16.000 30.098 5,619,710.50- 3,026,506.27- 92,105.28- 11,925.00- 1,050.00 ,619,710.50-3,026,506.27-92,105.28- 11,925.00- 1,050.00 2,100.00- 34,951.20 - Subtotal: 10,171,516.00- 10,171,516.00- 598,635.68- 1,385,267.75- 13.619 8,786,248.25- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 Interest Income Cell Tower Revenue Buildir}p Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 9,712.65- 1,178.81- 583.33- 21,478.43- 1,178.81- 1,166.66- 5,355.28- 17.899 8.333 16.667 42.197 98,521.57- 12,967.19- 5,833.34- 13,000.00- 7,335.72- 135-49900-000-000 Miscellaneous Income 7,000.00- 7,000.00- 228.85- 7,601.14- 108.588 601.14 Subtotal: 173,837.00- 173,837.00- 11,703.64- 36,780.32- 21.158 137,056.68 - Program number: 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64 - Department number: Revenues 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64- glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2019 Total Encumb. Amended Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Current Month Program: YTD Total % of Budget 41,130.51 51,358.19 14.663 3,378.93 4,200.82 24.711 5,082.50 5,082.50 129.656 450.00 800.00 14.815 4,628.88 6,764.00 19.402 5,229.85 9,050.89 10.733 310.26 554.23 11.730 52.07 90.97 11.860 269.10 458.77 14.648 3,079.60 3,772.88 16.159 720.23 882.37 16.158 9.34 10.14 .939 771.49 1,542.98 13.021 Remaining Budget 298,908.81 12,799.18 1,162.50- 4,600.00 28,099.00 75,275.11 4,170.77 676.03 2,673.23 19,575.12 4,578.63 1,069.86 10,307.02 400.00 300.00 Page 4 Subtotal: 546,839.00 546,839.00 65,112.76 84,568.74 15.465 462,270.26 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 10,190.54 13,117.37 13.117 207.88 4.158 87.50 8.750 740.00 740.00 9.867 20,000.00 86,882.63 3,000.00 4,792.12 3,500.00 912.50 6,760.00 Subtotal: 140,000.00 140,000.00 10,930.54 14,152.75 10.109 125,847.25 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 875.01 1,239.17 24.783 11,423.51 26,144.51 20.803 14,207.15 220,912.63 47,943.74 4,600.00 295.00 3.973 14,207.15 22.551 220,912.63 8.138 462.00 15.400 95,887.48 18.182 9,200.00 16.669 3,760.83 99,532.49 1,000.00 500.00 7,131.00 400.00 2,845.00 1,500.00 48,792.85 2,493,797.37 200.00 2,538.00 14,750.00 431,493.52 45,993.00 180,000.00 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Program number: Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Department: Adopted Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 10 Water Trophy Club MUD No.1 Page 5 Budget Summary with Amendment Period Ending: 11/2019 Total Encumb. Amended Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 Current Month 100.57 300,062.61 970.35 909.36 1,642.32 3,522.03 11,152.78 57,932.73 69,085.51 448,713.45 Program: YTD Total 100.57 368,448.51 1,743.83 1,729.35 3,331.56 8,875.28 15,680.02 29,804.38 75,000.00 57,932.73 162,737.11 645,587.13 % of Budget 4.023 9.944 11.626 33.321 16.658 12.679 7.864 4.352 100.000 48.277 17.812 11.727 Remaining Budget 2,399.43 3,336,633.49 13,256.17 3,460.65 16,668.44 1,200.00 1,000.00 61,124.72 87,000.00 183,709.98 655,070.62 30,512.00 3,231.00 62,067.27 750,880.89 4,859,341.87 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,506,929.00 80.00 80.00 80.00 448,793.45 80.00 4.000 80.00 4.000 80.00 645,667.13 4.000 11.725 1,920.00 1,920.00 1,920.00 4,861,261.87 Page 6 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 Account Description 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 43,724.72 56,681.48 12.830 385,117.52 135-50010-020-000 Overtime 33,000.00 33,000.00 3,538.90 4,187.98 12.691 28,812.02 135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 6,872.50 85.532 1,162.50 135-50017-020-000 Certification 9,000.00 9,000.00 625.00 1,250.00 13.889 7,750.00 135-50020-020-000 Retirement 45,531.00 45,531.00 5,065.41 7,920.39 17.396 37,610.61 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 5,987.13 11,974.26 11.420 92,883.74 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 358.15 716.30 12.314 5,100.70 135-50028-020-000 Vision Insurance 948.00 948.00 59.22 118.44 12.494 829.56 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 341.99 679.13 15.092 3,820.87 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 3,251.71 4,055.67 13.300 26,438.33 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 760.48 948.49 13.299 6,183.51 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 2,220.40 14.444 13,152.60 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 708,447.00 708,447.00 71,695.41 97,625.04 13.780 610,821.96 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 3,000.00 20.000 12,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 2,982.28 6,686.82 7.599 81,313.18 135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 6,351.91 14,277.16 142.772 4,277.16- 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 115.46 162.48 4.062 3,837.52 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 1,837.08 1,837.08 22.964 6,162.92 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 856.24- -28.541 3,856.24 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 5.833 1,412.50 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 7,433.18 12,239.42 12.239 87,760.58 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,019.60 4,409.20 11.023 35,590.80 Subtotal: 309,500.00 309,500.00 23,739.51 41,843.42 13.520 267,656.58 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 801.99 1,174.83 23.497 3,825.17 135-60020-020-000 Electricity 160,067.00 160,067.00 10,925.83 22,687.12 14.174 137,379.88 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 333.53 1,173.53 23.518 3,816.47 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 356.71 356.71 23.088 1,188.29 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 9,888.02 65.920 5,111.98 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 5,000.00 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Description 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 Fuel & Lube Uniforms Chemicals Chemicals Collections Small Tools Safety E uipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,310,669.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 11/2019 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,310,669.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 Current Month 10,414.81 61,260.10 5,750.00 190.00 90,032.97 906.43 2,111.52 569.00 4,994.00 995.32 9,576.27 84,803.30 84,803.30 279,847.46 279,847.46 Program: YTD Total % of Budget 20,829.62 18.182 122,520.80 18.182 11,500.00 9.186 190.00 9.500 190,320.63 14.521 1,830.04 14.640 3,003.93 54.667 3,394.96 16.975 4,994.00 28.537 3,978.33 19.892 17,201.26 22.083 90,592.30 17.077 130,000.00 100.000 220,592.30 29.377 567,582.65 17.976 567,582.65 17.976 Remaining Budget 14,000.00 93,733.38 551,346.20 113,687.00 180,000.00 1,810.00 1,120,348.37 10,669.96 2,491.07 16,605.04 12,506.00 1,200.00 1,200.00 16,021.67 60,693.74 439,907.70 79,133.00 11,277.00 530,317.70 2,589,838.35 2,589,838.35 Page 8 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 1.99 3.98 1.99 3.98 675.00 156.36 831.36 833.35 833.35 675.00 156.36 13.267 Remaining Budget 26.02 13.267 26.02 90.000 12.028 831.36 6.298 835.34 835.34 6.314 6.314 150.00 75.00 1,143.64 4,000.00 5,000.00 2,000.00 12,368.64 12,394.66 12,394.66 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 628,298.00 628,298.00 2,000.00 2,000.00 2,208.00 2,208.00 58,554.00 58,554.00 124,394.00 124,394.00 6,464.00 6,464.00 1,035.00 1,035.00 4,500.00 4,500.00 39,215.00 39,215.00 9,171.00 9,171.00 1,440.00 1,440.00 1,775.00 1,775.00 500.00 500.00 8,000.00 8,000.00 45,241.82 3.11 2,207.50 4,389.34 5,488.81 306.40 48.77 330.00 2,814.13 658.13 104.82 107.37 58,807.67 9.360 569,490.33 3.11 .156 1,996.89 2,207.50 99.977 .50 7,149.98 12.211 51,404.02 10,977.62 8.825 113,416.38 612.80 9.480 5,851.20 97.54 9.424 937.46 622.42 13.832 3,877.58 3,596.13 9.170 35,618.87 841.04 9.171 8,329.96 1,440.00 209.64 11.811 1,565.36 500.00 286.22 3.578 7,713.78 Subtotal: 887,554.00 887,554.00 61,700.20 85,411.67 9.623 802,142.33 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 Cleaning Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 2,671.60 23,380.71 68,197.45 23,380.71 515.00 869.06 582.15 50.636 17.319 3.433 8.691 6.468 66,483.55 111,619.29 14,485.00 10,000.00 9,130.94 65,600.00 8,417.85 Subtotal: 379,281.00 379,281.00 26,052.31 93,544.37 24.664 285,736.63 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections 23,680.00 23,680.00 4,000.00 4,000.00 6,879.00 6,879.00 1,500.00 1,500.00 30,000.00 30,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 84,000.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 6,850.00 3,545.00 3,545.00 200.00 200.00 Advertising 2,500.00 2,500.00 1,487.98 238.02 56.40 49.43 7,222.85 6,998.39 35.18 126.45 195.00 36.30 2,967.78 476.04 123.18 1,776.04 14,270.78 12.533 11.901 8.212 5.920 21.300 13,996.78 16.663 200.00 35.18 476.20 972.71 128.08 43.01 43.01 3.333 8.795 7.937 14.200 3.613 20,712.22 3,523.96 6,879.00 1,376.82 28,223.96 52,729.22 1,500.00 70,003.22 1,000.00 5,800.00 364.82 5,523.80 5,877.29 3,416.92 200.00 43.01- 2,500.00 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account Description 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,288.00 500.00 17,000.00 2,500.00 1,288.00 500.00 17,000.00 2,500.00 24.00 48.00 3.727 1,240.00 500.00 17,000.00 2,500.00 Subtotal: 266,342.00 266,342.00 16,513.01 35,513.78 13.334 230,828.22 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 538.29 249.72 1,099.62 677.72 18.327 16.943 2,050.00 26,485.00 4,900.38 3,500.00 3,322.28 2,500.00 Subtotal: 44,535.00 44,535.00 788.01 1,777.34 3.991 42,757.66 135-69005-030-000 Capital Outlays 195,000.00 195,000.00 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 239.52 493.36 12.334 3,506.64 Subtotal: 199,000.00 199,000.00 239.52 493.36 .248 198,506.64 Program number: 1,776,712.00 1,776,712.00 105,293.05 216,740.52 12.199 1,559,971.48 Department number: Administration 1,776,712.00 1,776,712.00 105,293.05 216,740.52 12.199 1,559,971.48 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Description Legal Auditing,. Appraisal Tax Admin Fees Subtotal: Program number: Department number: Non Departmental Expenditures Subtotal Fund number: 135 MUD 1 General Fund Department: Adopted Budget 135,000.00 33,800.00 11,761.00 4,000.00 Trophy Club MUD No.1 Budget Summary with Amendment 39 Non Departmental Period Ending: 11/2019 Amended Total Budget Encumb. 135,000.00 33,800.00 11,761.00 4,000.00 184,561.00 184,561.00 184,561.00 184,561.00 184,561.00 184,561.00 10,638,853.00 10,638,853.00 6,224.00- 6,224.00 - Current Month 25,504.93 10,150.00 35,654.93 35,654.93 35,654.93 870,422.24 253,193.03 Program: YTD Total 25,504.93 15,150.00 13.35- 40,641.58 40,641.58 40,641.58 1,471,467.22 40,953.86 % of Budget 18.893 44.822 -.114 22.021 22.021 22.021 13.831 -657.999 Remaining Budget 109,495.07 18,650.00 11,774.35 4,000.00 143,919.42 143,919.42 143,919.42 9,167,385.78 47,177.86 - Page 12 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 16:37 12/09/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2019 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 Subtotal: 286,420.00- 286,420.00 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 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (1,723.24) (171.09) (401.67) (739.28) (288.70) (344.79) (629.04) (160.13) (743.92) (399.21) (164.79) (93.07) (382.13) (965.74) (214.85) (19.66) (404.84) (400.11) (142.26) (1,894.33) (2,296.00) (3,035.28) (3,323.98) (3,668.77) (4,297.81) (4,457.94) (5,201.86) (5,601.07) (5,765.86) (5,858.93) (6,241.06) (7,206.80) (7,421.65) (7,441.31) (7,846.15) (8,246.26) (8,388.52) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (6,665.28) (8,388.52) ** (134,871.00) Budgeted (126,482.48) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 155.66 (24.22) (32.20) (.39) 1.91 (49.36) 131.44 99.24 98.85 100.76 51.40 GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (104.26) 51.40 ** (300.00) Budgeted (351.40) Remaining -17 % Used Account: 135-40015-000-000 Property Taxes/P & I 363 11/01/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 372 11/15/2019 Property Taxes 374 11/19/2019 Property Taxes (7.82) (5.33) (.12) (1.95) (.12) (.01) (.11) (.08) (13.15) (13.27) (15.22) (15.34) (15.35) (15.46) (15.54) GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 375 11/20/2019 Property Taxes 380 11/27/2019 Property Taxes (7.82) (101.81) (117.35) GL (10.82) (128.17) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (120.35) (128.17) ** (300.00) Budgeted (171.83) Remaining 43 6 Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (164,253.00) Budgeted (164,253.00) Remaining 0 % Used Account: 135-47000-000-000 Water 240 11/11/2019 UB 11/11/2019 Adjustments 331 11/14/2019 RFD-Miniates incorrect read 312 11/30/2019 UB 11/30/2019 Billing UB20191111-20191111 User: UB20191114-20191114 User: UB20191130-20191130 User: (536,379.28) 20.38 (536,358.90) UB 111.60 (536,247.30) UB (330,665.20) (866,912.50) UB Account: 135-47000-000-000 Water Totals: 1 (330,533.22) (866,912.50) ** (6,486,623.00) Budgeted (5,619,710.50) Remaining 13 % Used Account: 135-47005-000-000 Sewer 240 11/11/2019 UB 11/11/2019 Adjustments UE20191111-20191111 User: (221,960.36) 312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: 34.15 (221,926.21) UB (255,452.52) (477,378.73) UB Account: 135-47005-000-000 Sewer Totals: 1 (255,418.37) (477,378.73) ** (3,503,885.00) Budgeted (3,026,506.27) Remaining 14 % Used Account: 135-47025-000-000 Penalties 246 11/12/2019 UB 11/12/2019 Penalty removal UB20191112-20191112 User: 283 11/20/2019 UB 11/20/2019 Penalty removal UB20191120-20191120 User: 288 11/21/2019 UB 11/21/2019 Penalties UE20191121-20191121 User: 293 11/25/2019 UB 11/25/2019 Penalty removal UB20191125-20191125 User: 302 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User: 305 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User: (9,981.43) 182.03 (9,799.40) UB 480.33 (9,319.07) UB (11,403.51) (20,722.58) UB 68.63 (20,653.95) UB 125.39 (20,528.56) UB 25.84 (20,502.72) UB Account: 135-47025-000-000 1 Penalties Totals: (10,521.29) (20,502.72) ** (112,608.00) Budgeted (92,105.28) Remaining 18 8 Used Account: 135-47030-000-000 Service Charges glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 247 11/01/2019 UB 11/01/2019 NSF Check 222 11/06/2019 Cut Offs -November 2019 282 11/18/2019 UB 11/18/2019 NSF check UB20191101-20191101 User: UB20191106-20191106 User: UB20191118-20191118 User: (1,075.00) (25.00) (1,100.00) UB (2,050.00) (3,150.00) UB (75.00) (3,225.00) UB Account: 135-47030-000-000 Service Charges Totals: (3,225.00) ** (15,150.00) Budgeted Account: 135-47035-000-000 Account: 135-47035-000-000 (11,925.00) Remaining 21 % Used Plumbing Inspections (1,800.00) .00 (1,800.00) Plumbing Inspections .00 (1,800.00) ** (750.00) Budgeted 1,050.00 Remaining 240 % Used Account: 135-47045-000-000 Sewer Inspections (400.00) .00 (400.00) Account: 135-47045-000-000 Sewer Inspections .00 (400.00) ** (2,500.00) Budgeted (2,100.00) Remaining 16 % Used Account: 135-47070-000-000 TCCC Effluent Charges 312 11/30/2019 UB 11/30/2019 Billing U820191130-20191130 User: (15,036.00) Account: 135-47070-000-000 TCCC Effluent Charges Totals: (50,000.00) Budgeted (34,951.20) Remaining Account: 135-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November 348 11/30/2019 Bank Interest- November 348 11/30/2019 Bank Interest- November 384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking 384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking Account: 135-49011-000-000 (12.80) (15,048.80) UB 30 % Used (11,765.78) (12.80) (15,048.80) ** (1,064.21) (12,829.99) GL (1,075.00) (13,904.99) GL (7,573.44) (21,478.43) GL (10.79) (21,489.22) GL 10.79 (21,478.43) GL Interest Income Totals: (9,712.65) (21,478.43) ** (120,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue 347 11/12/2019 Cell Tower Rev AT&T November (98,521.57) Remaining 18 % Used (1,178.81) (1,178.81) GL glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 8 Check Source Number Department Totals: (7,000.00) Budgeted (617,229.21) Monthly Total 601.14 Remaining 109 5 Used (1,430,513.36) ** (10,645,077.00) Budgeted (9,214,563.64) Remaining 13 8 Used Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (1,178.81) ** (14,146.00) Budgeted (12,967.19) Remaining 8 5 Used Account: 135-49018-000-000 Building Rent Income 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: (583.33) (583.33) (1,166.66) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (13,000.00) Budgeted (13,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (5,355.28) .00 (5,355.28) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (5,355.28) ** (12,691.00) Budgeted (7,335.72) Remaining 42 % Used Account: 135-49900-000-000 Miscellaneous Income 312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: (7,372.29) (228.85) (7,601.14) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (228.85) (7,601.14) ** Department Totals: (7,000.00) Budgeted (617,229.21) Monthly Total 601.14 Remaining 109 5 Used (1,430,513.36) ** (10,645,077.00) Budgeted (9,214,563.64) Remaining 13 8 Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 9 Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,135.12 1,260.61 1,423.21 470.14 1,474.92 3,395.73 4,818.94 5,289.08 6,764.00 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 4,628.88 6,764.00 ** 34,863.00 Budgeted 28,099.00 Remaining 19 % Used Account: 135-50026-010-000 Medical Insurance Account: 135-50005-010-000 Salaries & Wages 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Salaries 11/15/2019 Salaries 11/27/19 Salaries & Wages & Wages & Wages 10,227.68 12,896.59 13,915.33 14,318.59 23,124.27 37,039.60 51,358.19 PR PR PR Account: 135-50005-010-000 Salaries & Wages Totals: 41,130.51 51,358.19 ** 350,267.00 Budgeted 298,908.81 Remaining 15 % Used Account: 135-50010-010-000 ' Overtime 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Overtime 11/15/2019 Overtime 11/27/19 Overtime 821.89 731.69 1,020.71 1,626.53 1,553.58 2,574.29 4,200.82 PR PR PR Account: 135-50010-010-000 ' Overtime Totals: 3,378.93 4,200.82 ** 17,000.00 Budgeted 12,799.18 Remaining 25 % Used Account: 135-50016-010-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 5,082.50 5,082.50 PR Account: 135-50016-010-000 Longevity Totals: 5,082.50 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 241 11/15/2019 MUD Payroll 11/15/2019 Certification 350.00 450.00 800.00 PR Account: 135-50017-010-000 Certification Totals: 450.00 800.00 ** 5,400.00 Budgeted 4,600.00 Remaining 15 % Used Account: 135-50020-010-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,135.12 1,260.61 1,423.21 470.14 1,474.92 3,395.73 4,818.94 5,289.08 6,764.00 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 4,628.88 6,764.00 ** 34,863.00 Budgeted 28,099.00 Remaining 19 % Used Account: 135-50026-010-000 Medical Insurance glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 11/2019 Page 10 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Medical Insurance Medical Insurance 3,821.04 2,614.96 2,614.89 6,436.00 9,050.89 PR PR 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 693.28 834.35 940.23 315.11 989.91 1,527.63 2,467.86 2,782.97 3,772.88 PR PR PR PR Account: 135-50030-010-000 Social Security Taxes Totals: 3,079.60 3,772.88 ** 23,348.00 Budgeted 19,575.12 Remaining 16 % Used Account: 135-50035-010-000 Medicare Taxes Account: 135-50026-010-000 Medical Insurance Totals: 5,229.85 9,050.89 ** 84,326.00 Budgeted 75,275.11 Remaining 11 % Used Account: 135-50027-010-000 ' Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance 243.97 155.16 155.10 399.13 554.23 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 310.26 554.23 ** 4,725.00 Budgeted 4,170.77 Remaining 12 % Used Account: 135-50028-010-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 38.90 26.06 26.01 64.96 90.97 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 52.07 90.97 ** 767.00 Budgeted 676.03 Remaining 12 % Used Account: 135-50029-010-000 Life Insurance & Other 216 11/01/2019 Payroll Benefits November Employee LTD & STD 216 11/01/2019 Payroll Benefits November Employee Benefits 318 11/30/2019 November A/P caf 125 -October 189.67 123.66 125.44 20.00 313.33 438.77 458.77 METLIFE GROUP BENEFITS Humana Inc BenefitMall 5896 5891 5923 AP AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 269.10 458.77 ** 3,132.00 Budgeted 2,673.23 Remaining 15 % Used Account: 135-50030-010-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 693.28 834.35 940.23 315.11 989.91 1,527.63 2,467.86 2,782.97 3,772.88 PR PR PR PR Account: 135-50030-010-000 Social Security Taxes Totals: 3,079.60 3,772.88 ** 23,348.00 Budgeted 19,575.12 Remaining 16 % Used Account: 135-50035-010-000 Medicare Taxes glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 11 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 162.14 195.12 219.90 73.69 231.52 357.26 577.16 650.85 882.37 PR PR PR PR Account: 135-50035-010-000 - Medicare Taxes Totals: 720.23 882.37 ** 5,461.00 Budgeted 4,578.63 Remaining 16 % Used Account: 135-50040-010-000 ' Unemployment Taxes 134 11/01/2019 MUD Payroll 11/01/19 Unemployment Taxes 241 11/15/2019 MUD Payroll 11/15/2019 Unemployment Taxes 298 11/27/2019 MUD Payroll 11/27/19 Unemployment Taxes .80 2.28 3.19 3.87 3.08 6.27 10.14 PR PR PR Account: 135-50040-010-000 ' Unemployment Taxes Totals: 9.34 10.14 ** 1,080.00 Budgeted 1,069.86 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov 771.49 771.49 1,542.98 GL Account: 135-50045-010-000 Workman's Compensation Totals: 771.49 1,542.98 ** 11,850.00 Budgeted 10,307.02 Remaining 13 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-55080-010-000 231 11/07/2019 November A/P 231 11/07/2019 November A/P 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 12 Check Source Number Maintenance & Repairs water plant gate parts Sprinkler Check/Repair Multch for Customer Repiar Sprinkler Check/Repair Turf Customer Repair Sharkbite Elbow and Adapter Well 61 emergency repair meter boxes hydrant parts parts 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P Account: 135-55080-010-000 Account: 135-55085-010-000 Account: 135-55085-010-000 Account: 135-55090-010-000 Account: 135-55090-010-000 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Maintenance & Repairs Totals: 100,000.00 Budgeted 86,882.63 Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Vehicle Maintenance Vehicle Maintenance Totals: 5,000.00 Budgeted 4,792.12 Remaining 2,926.83 207.88 13 % Used 0 % Used 4 % Used 1,178.00 4,104.83 257.50 4,362.33 490.50 4,852.83 3.75 4,856.58 490.50 5,347.08 29.25 5,376.33 75.74 5,452.07 5,946.00 11,398.07 1,477.80 12,875.87 37.50 12,913.37 204.00 13,117.37 10,190.54 .00 .00 .00 .00 Alan's Gates, Inc. Core & Main LP ARS RR FT WORTH 9127 THE HOME DEPOT 66581 ARS RR FT WORTH 9127 TEX-TURF THE HOME DEPOT 66581 DHS AUTOMATION, INC Core & Main LP Core & Main LP Core & Main LP 13,117.37 ** .00 .00 ** 207.88 207.88 ** 5881 AP 5884 AP PC PC PC PC PC 5930 AP 5928 AP 5928 AP 5928 AP Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-55120-010-000 Cleaning Services 87.50 .00 87.50 Account: 135-55120-010-000 Cleaning Services Totals: .00 87.50 ** 1,000.00 Budgeted 912.50 Remaining 9 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Lab Analysis water samples Lead & copper sampling 140.00 140.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP 600.00 740.00 Centralized Water & Wastewater 5925 AP Account: 135-55135-010-000 Lab Analysis Totals: 740.00 740.00 ** 7,500.00 Budgeted 6,760.00 Remaining 10 % Used Account: 135-60010-010-000 Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 359 11/26/2019 PCards 10/29/19 - 11/26/19 screen protectors 364.16 865.02 1,229.18 VERIZON WIRELESS 5920 AP 9.99 1,239.17 AMZN MKTP US*J16PNOT63 PC Account: 135-60010-010-000 Communications/Mobiles Totals: 875.01 1,239.17 ** Account: 135-60020-010-000 318 11/30/2019 November A/P Account: 135-60020-010-000 Account: 135-60066-010-000 5,000.00 Budgeted 3,760.83 Remaining 25 % Used Electricity electricity 10/10-11/8 14,721.00 11,423.51 26,144.51 HUDSON ENERGY SERVICES, LLC 5936 AP Electricity Totals: 11,423.51 26,144.51 ** 125,677.00 Budgeted 99,532.49 Remaining 21 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 6 Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 295.00 .00 295.00 Account: 135-60080-010-000 Schools & Training Totals: .00 295.00 ** 7,426.00 Budgeted 7,131.00 Remaining 4 6 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Safety Program 400.00 Budgeted Travel & per diem Travel & per diem 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted Account: 135-60135-010-000 Account: 135-60150-010-000 318 11/30/2019 November A/P Totals: 400.00 Remaining 0 6 Used Totals: 2,845.00 Remaining .00 .00 .00 .00 ** .00 0 % Used .00 .00 n= .00 .00 Totals: 1,500.00 Remaining 0 6 Used TCEQ Fees & Permits well water Water system Fee TCEQ .00 5,752.20 5,752.20 North Texas Groundwater 5913 AP 8,454.95 14,207.15 TX COMMISSION ENVIRONMENTAL QU 5951 AP TCEQ Fees & Permits Totals: 14,207.15 14,207.E 63,000.00 Budgeted Wholesale Water wholesale water 48,792.85 Remaining 23 % Used 220,912.63 220,912.63 CITY OF FORT WORTH 5926 AP Account: 135-60150-010-000 Wholesale Water Totals: 220,912.63 220,912.63 ** 2,714,710.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses 2,493,797.37 Remaining 8 6 Used .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 6 Used Account: 135-60280-010-000 Property Maintenance glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment 462.00 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 462.00 Page 15 Check Source Number Account: 135-60280-010-000 Property Maintenance Totals: .00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 5 Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S 47,943.74 25,047.72 22,896.02 72,991.46 95,887.48 GL GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 47,943.74 95,887.48 ** 527,381.00 Budgeted 431,493.52 Remaining 18 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr 4,600.00 4,600.00 9,200.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 9,200.00 ** 55,193.00 Budgeted 45,993.00 Remaining 17 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 359 11/26/2019 PCards 10/29/19 - 11/26/19 hanging clamps 100.57 100.57 AMZN MKTP US*PK4EH4DP3 PC Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 100.57 100.57 ** 2,500.00 Budgeted 2,399.43 Remaining 4 % Used Account: 135-65005-010-000 Fuel & Lube glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 352 11/24/2019 Fuel -November Fuel -Nov 773.48 970.35 1,743.83 US Bank Voyager Fleet Systems 5985 AP Account: 135-65005-010-000 Fuel & Lube Totals: 970.35 1,743.83 ** 15,000.00 Budgeted 13,256.17 Remaining 12 % Used Account: 135-65010-010-000 Uniforms 359 11/26/2019 PCards 10/29/19 - 11/26/19 shoes 359 11/26/2019 PCards 10/29/19 - 11/26/19 pants 359 11/26/2019 PCards 10/29/19 - 11/26/19 pants 359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water 359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water 819.99 166.49 986.48 RED WING SHOES #573 PC 291.97 1,278.45 AMAZON.COM*AX75E74Y3 PC 160.93 1,439.38 AMAZON.COM*SOODX8NS3 PC 179.98 1,619.36 TRACTOR SUPPLY COMPANY PC 109.99 1,729.35 TRACTOR SUPPLY COMPANY PC Account: 135-65010-010-000 Uniforms Totals: 909.36 1,729.35 ** 5,190.00 Budgeted 3,460.65 Remaining 33 o Used Account: 135-65030-010-000 Chemicals 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P 356 11/30/2019 November A/P testing supplies testing supplies chlorine ammonia 1,689.24 287.77 1,977.01 HACH COMPANY 539.90 2,516.91 HACH COMPANY 335.05 2,851.96 DPC INDUSTRIES, INC 479.60 3,331.56 Valley Solvent Company, INC 5933 AP 5933 AP 5931 AP 5986 AP Account: 135-65030-010-000 Chemicals Totals: 1,642.32 3,331.56 ** 20,000.00 Budgeted 16,668.44 Remaining 17 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 9 Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 8,875.28 .00 8,875.28 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Account: 135-65053-010-000 Account: 135-65053-010-000 Account: 135-69005-010-000 231 11/07/2019 November A/P 254 11/14/2019 November A/P 318 11/30/2019 November A/P 356 11/30/2019 November A/P Meter Expense Totals: 70,000.00 Budgeted Meter Change Out Program 61,124.72 Remaining 13 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Capital Outlays beacon software 16" water line Sundance & meadowbrook meadowbrook s sundance Account: 135-69005-010-000 Capital Outlays 684,875.00 Budgeted 18,651.60 O % Used .00 8,875.28 ** .00 .00 .00 .00 ** 5,472.00 3,055.78 2,025.00 600.00 24,123.60 BADGER METER, INC 27,179.38 Halff Associates, INC 29,204.38 Jackson Construction, LTD 29,804.38 TEAGUE, NALL 4 PERKINS,INC 5883 AP 5908 AP 5938 AP 5982 AP 11,152.78 29,804.38 ** 655,070.62 Remaining 4 6 Used Account: 135-69008-010-000 Short Term Debt -Principal Account: 135-69008-010-000 .00 .00 Short Term Debt -Principal Totals: .00 .00 ** 30,512.00 Budgeted 30,512.00 Remaining O % Used Account: 135-69009-010-000 Short Term Debt -Interest .00 .00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: 3,231.00 Budgeted 3,231.00 Remaining Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining O % Used 75,000.00 100 % Used .00 75,000.00 Account: 135-69281-010-000 Water Tank Inspection Contract glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 231 11/07/2019 November A/P Tank contract 57,932.73 57,932.73 UTILITY SERVICE CO, INC. 5903 AP Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 57,932.73 57,932.73 120,000.00 Budgeted 62,067.27 Remaining 48 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 254 11/14/2019 November A/P water samples 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 80.00 ** 2,000.00 Budgeted 1,920.00 Remaining 4 % Used Department 10 Totals: 645,667.13 ** 448,793.45 Monthly Total 5,506,929.00 Budgeted 4,861,261.87 Remaining 12 % Used glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 20 Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,854.98 1,510.53 1,486.46 635.72 1,432.70 4,365.51 5,851.97 6,487.69 7,920.39 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 5,065.41 7,920.39 ** 45,531.00 Budgeted 37,610.61 Remaining 17 % Used Account: 135-50026-020-000 Medical Insurance Account: 135-50005-020-000 Salaries & Wages 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Salaries 11/15/2019 Salaries 11/27/19 Salaries & Wages & Wages & Wages 12,956.76 14,635.56 14,544.58 14,544.58 27,592.32 42,136.90 56,681.48 PR PR PR Account: 135-50005-020-000 Salaries & Wages Totals: 43,724.72 56,681.48 ** 441,799.00 Budgeted 385,117.52 Remaining 13 % Used Account: 135-50010-020-000 ' Overtime 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Overtime 11/15/2019 Overtime 11/27/19 Overtime 649.08 1,694.42 900.40 944.08 2,343.50 3,243.90 4,187.98 PR PR PR Account: 135-50010-020-000 ' Overtime Totals: 3,538.90 4,187.98 ** 33,000.00 Budgeted 28,812.02 Remaining 13 % Used Account: 135-50016-020-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 6,872.50 6,872.50 PR Account: 135-50016-020-000 Longevity Totals: 6,872.50 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 241 11/15/2019 MUD Payroll 11/15/2019 Certification 625.00 625.00 1,250.00 PR Account: 135-50017-020-000 Certification Totals: 625.00 1,250.00 ** 9,000.00 Budgeted 7,750.00 Remaining 14 % Used Account: 135-50020-020-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,854.98 1,510.53 1,486.46 635.72 1,432.70 4,365.51 5,851.97 6,487.69 7,920.39 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 5,065.41 7,920.39 ** 45,531.00 Budgeted 37,610.61 Remaining 17 % Used Account: 135-50026-020-000 Medical Insurance glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 11/2019 Page 21 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Medical Insurance Medical Insurance 5,987.13 2,993.58 2,993.55 8,980.71 11,974.26 PR PR 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 803.96 952.88 909.83 426.08 962.92 1,756.84 2,666.67 3,092.75 4,055.67 PR PR PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 3,251.71 4,055.67 ** 30,494.00 Budgeted 26,438.33 Remaining 13 % Used Account: 135-50035-020-000 Medicare Taxes Account: 135-50026-020-000 Medical Insurance Totals: 5,987.13 11,974.26 ** 104,858.00 Budgeted 92,883.74 Remaining 11 % Used Account: 135-50027-020-000 ' Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance 358.15 179.09 179.06 537.24 716.30 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 358.15 716.30 ** 5,817.00 Budgeted 5,100.70 Remaining 12 % Used Account: 135-50028-020-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 59.22 29.62 29.60 88.84 118.44 PR PR Account: 135-50028-020-000 11111 Vision Insurance Totals: 59.22 118.44 ** 948.00 Budgeted 829.56 Remaining 12 8 Used Account: 135-50029-020-000 Life Insurance & Other 216 11/01/2019 Payroll Benefits November Employee LTD & STD 216 11/01/2019 Payroll Benefits November Employee Benefits 318 11/30/2019 November A/P caf 125 -October 337.14 157.87 148.12 36.00 495.01 643.13 679.13 METLIFE GROUP BENEFITS Humana Inc BenefitMall 5896 5891 5923 AP AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 341.99 679.13 ** 4,500.00 Budgeted 3,820.87 Remaining 15 % Used Account: 135-50030-020-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 803.96 952.88 909.83 426.08 962.92 1,756.84 2,666.67 3,092.75 4,055.67 PR PR PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 3,251.71 4,055.67 ** 30,494.00 Budgeted 26,438.33 Remaining 13 % Used Account: 135-50035-020-000 Medicare Taxes glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 22 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 188.01 222.85 212.77 99.65 225.21 410.86 623.63 723.28 948.49 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 760.48 948.49 ** 7,132.00 Budgeted 6,183.51 Remaining 13 % Used Account: 135-50040-020-000 Unemployment Taxes ' .00 .00 Account: 135-50040-020-000 Unemployment Taxes Totals: 1111=.00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-041 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov 1,110.20 1,110.20 2,220.40 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,110.20 2,220.40 ** 15,373.00 Budgeted 13,152.60 Remaining 14 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 23 Check Source Number Account: 135-55070-020-000 Independent Labor 318 11/30/2019 November A/P Huber contract 3,000.00 3,000.00 Huber Technology Inc 5935 AP Account: 135-55070-020-000 Independent Labor Totals: 3,000.00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 318 11/30/2019 318 11/30/2019 356 11/30/2019 356 11/30/2019 PCards PCards PCards PCards PCards PCards PCards 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 PCards 10/29/19 November A/P November A/P November A/P November A/P - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Misc Parts Hose Misc Parts nozzle brass bushing belt dressing bucket thermostats in barn & WWTP thermostats in barn & WWTP permeate #6 fix parts 3,704.54 138.94 79.97 140.17 126.28 35.44 374.94 10.58 13.75 215.00 450.00 490.00 907.21 3,843.48 3,923.45 4,063.62 4,189.90 4,225.34 4,600.28 4,610.86 4,624.61 4,839.61 5,289.61 5,779.61 6,686.82 ACADEMY SPORTS #81 THE HOME DEPOT 6581 GRAINGER STUART HOSE & PIPE - F ROANOKE WINNELSON CO ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 BRANDON R REED BRANDON R REED DHS AUTOMATION, INC Huber Technology Inc PC PC PC PC PC PC PC PC 5924 AP 5924 AP 5968 AP 5971 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,982.28 6,686.82 ** 88,000.00 Budgeted 81,313.18 Remaining 8 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 359 11/26/2019 318 11/30/2019 318 11/30/2019 318 11/30/2019 356 11/30/2019 356 11/30/2019 PCards 10/29/19 November A/P November A/P November A/P November A/P November A/P 11/26/19 concrete grade ring LS #4 repair manhole lids gasketa LS #20 pump and floats pump for Ave 20 L/S 7,925.25 22.25 2,391.74 1,745.00 130.92 812.00 1,250.00 7,947.50 10,339.24 12,084.24 12,215.16 13,027.16 14,277.16 FERGUSON ENT 1241 DHS AUTOMATION, INC Core & Main LP SMITH PUMP COMPANY, INC. DHS AUTOMATION, INC NORTH TEXAS PUMP CO. PC 5930 AP 5928 AP 5948 AP 5968 AP 5976 AP Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 6,351.91 14,277.16 ** 10,000.00 Budgeted (4,277.16) Remaining 143 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 = Vehicle Maintenance 359 11/26/2019 PCards 10/29/19 - 11/26/19 Washer Fluid 47.02 6.94 53.96 THE HOME DEPOT 6581 PC 359 11/26/2019 PCards 10/29/19 - 11/26/19 car wash 7.00 60.96 CARMEL CARWASH - ROANO PC 359 11/26/2019 PCards 10/29/19 - 11/26/19 truck maintenance 40.00 100.96 INLAND TRUCK PARTS # PC 359 11/26/2019 PCards 10/29/19 - 11/26/19 oil change 61.52 162.48 KWIK KAR LUBE & TUNE 0 PC Account: 135-55090-020-000 icle Maintenance Totals: 115.46 162.48 ** 4,000.00 Budgeted 3,837.52 Remaining 4 % Used Account: 135-55091-020-000 Veh Maintenance Collections 318 11/30/2019 November A/P Vac truck service Account: 135-55091-020-000 Veh Maintenance Collections Totals: 8,000.00 Budgeted 6,162.92 Remaining 1,837.08 1,837.08 CLS SEWER EQUIPMENT CO., INC 5927 AP 1,837.08 1,837.08 ** 23 6 Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader (856.24) .00 (856.24) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 (856.24) ** 3,000.00 Budgeted 3,856.24 Remaining -29 % Used Account: 135-55120-020-000 Cleaning Services Account: 135-55120-020-000 Cleaning Services 1,500.00 Budgeted Account: 135-55125-020-000 Dumpster Services 254 11/14/2019 November A/P sludge/grit 318 11/30/2019 November A/P Sludge grit 356 11/30/2019 November A/P sludge haul off 356 11/30/2019 November A/P sludge haul off Account: 135-55125-020-000 Dumpster Services 100,000.00 Budgeted Account: 135-55135-020-000 Lab Analysis 228 11/07/2019 November A/P lab testing 87.50 Totals: - 1,412.50 Remaining 6 % Used 4,806.24 Totals: 87,760.58 Remaining 12 6 Used .00 87.50 .00 87.50 ** 1,233.18 2,520.30 2,523.40 1,156.30 7,433.18 6,039.42 L.H. CHANEY MATERIALS, INC. 8,559.72 L.H. CHANEY MATERIALS, INC. 11,083.12 L.H. CHANEY MATERIALS, INC. 12,239.42 L.H. CHANEY MATERIALS, INC. 12,239.42 ** 2,389.60 317.40 2,707.00 OXIDOR LABORATORIES LLC 5910 AP 5941 AP 5974 AP 5974 AP 5898 AP glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 25 228 11/07/2019 November A/P lab testing 359 11/26/2019 PCards 10/29/19 - 11/26/19 Calibration Gas Monitor 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 356 11/30/2019 November A/P lab testing 2,389.60 230.00 2,937.00 OXIDOR LABORATORIES LLC 60.00 2,997.00 RITZ SAFETY DALLAS 317.40 3,314.40 OXIDOR LABORATORIES LLC 230.00 3,544.40 OXIDOR LABORATORIES LLC 317.40 3,861.80 OXIDOR LABORATORIES LLC 230.00 4,091.80 OXIDOR LABORATORIES LLC 317.40 4,409.20 OXIDOR LABORATORIES LLC 5898 AP PC 5946 AP 5946 AP 5946 AP 5946 AP 5978 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,019.60 4,409.20 ** 40,000.00 Budgeted 35,590.80 Remaining 11 % Used Account: 135-60010-020-000 I Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 359 11/26/2019 PCards 10/29/19 - 11/26/19 Tablet cases 372.84 769.01 32.98 1,141.85 1,174.83 VERIZON WIRELESS AMZN MKTP US*IM2T03FT3 5920 AP PC Account: 135-60010-020-000 ' Communications/Mobiles _ Totals: 801.99 1,174.83 ** 5,000.00 Budgeted 3,825.17 Remaining 23 % Used Account: 135-60020-020-000 Electricity 254 11/14/2019 November A/P electricity 9/27-10/29 318 11/30/2019 November A/P electricity 10/10-11/8 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 11,761.29 500.86 10,861.33 (436.36) 12,262.15 23,123.48 22,687.12 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 5918 5936 AP AP AR Account: 135-60020-020-000 Electricity Totals: 10,925.83 22,687.12 ** 160,067.00 Budgeted 137,379.88 Remaining 14 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 359 11/26/2019 PCards 10/29/19 - 11/26/19 management training 840.00 333.53 1,173.53 SKILLPATH / NATIONAL PC Account: 135-60080-020-000 Schools & Training Totals: 333.53 1,173.53 ** 4,990.00 Budgeted 3,816.47 Remaining 24 8 Used Account: 135-60090-020-000 Safety Program .00 .00 Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 avel & per diem 241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem 359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training 359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training Account: 135-60100-020-000 Travel & per diem Totals: 297.57 297.57 PR 28.53 326.10 DIETER BROS RESTAURANT PC 30.61 356.71 THE SMOKEHOUSE LINDSAY PC 1,545.00 Budgeted 1,188.29 Remaining 23 % Used 356.71 356.71 ** Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 .00 .00 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising .00 .00 ** .00 .00 Advertising Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 % Used .00 .00 ** Account: 135-60135-020-000 TCEQ Fees & Permits 9,888.02 Account: 135-60135-020-000 Account: 135-60245-020-000 TCEQ Fees & Permits Totals: 15,000.00 Budgeted 5,111.98 Remaining 66 % Used Miscellaneous Expenses .00 9,888.02 .00 9,888.02 ** glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 27 Check Source Number Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,000.00 Budgeted 14,000.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt 10,414.81 10,414.81 20,829.62 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 20,829.62 ** 114,563.00 Budgeted 93,733.38 Remaining 18 % Used Account: 135-60332-020-000 ' Interfund Transfer Out -Rev I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S 389 11/15/2019 Adjust TexPool Tnfr Dep JE346 61,260.70 54,421.63 6,839.07 (.60) 115,682.33 122,521.40 122,520.80 GL GL GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 61,260.10 122,520.80 ** 673,867.00 Budgeted 551,346.20 Remaining 18 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr 5,750.00 5,750.00 11,500.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 5,750.00 11,500.00 ** 125,187.00 Budgeted 113,687.00 Remaining 9 5 Used Account: 135-60334-020-000 Interfund Transfer Out glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60334-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-020-000 Furniture/Equipment < $5000 359 11/26/2019 PCards 10/29/19 - 11/26/19 Washer WWTP Account: 135-60360-020-000 Account: 135-65005-020-000 352 11/24/2019 Fuel -November Account: 135-65005-020-000 Account: 135-65010-020-000 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 318 11/30/2019 November A/P ■ Account: 135-65010-020-000 Account: 135-65030-020-000 254 11/14/2019 November A/P Account: 135-65030-020-000 Account: 135-65031-020-000 254 11/14/2019 November A/P Furniture/Equipment < $5000 Totals: 2,000.00 Budgeted 1,810.00 Remaining Fuel & Lube Fuel -Nov Fuel & Lube 12,500.00 Budgeted Uniforms - 11/26/19 Orly- Uniforms - 11/26/19 Richey Uniforms - 11/26/19 Lnace Uniforms - 11/26/19 pants - 11/26/19 boots - 11/26/19 pants uniforms Uniforms 5,495.00 Budgeted Totals: 10,669.96 Remaining Totals: 2,491.07 Remaining Chemicals 4 drums -sodium hypo Chemicals 20,000.00 Budgeted Totals: 16,605.04 Remaining Chemicals Collections chemical for collections Program: Transaction Detail .00 0 % Used .00 190.00 190.00 10 6 Used Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 190.00 AAAA KELLER APPLIANCE 190.00 ** Page 28 Check Source Number PC 923.61 906.43 1,830.04 US Bank Voyager Fleet Systems 5985 AP 892.41 15 6 Used 55 6 Used 906.43 136.88 114.94 110.95 96.46 170.00 154.95 1,327.34 2,111.52 1,830.04 ** 1,029.29 1,144.23 1,255.18 1,351.64 1,521.64 1,676.59 3,003.93 THE HOME DEPOT #6581 ACADEMY SPORTS #81 ACADEMY SPORTS #81 WAL-MART #5247 RITZ SAFETY DALLAS DICKIES OUTLET FW RON MONTGOMERY & ASSOC INC 3,003.93 ** 2,825.96 569.00 3,394.96 Valley Solvent Company, INC 17 % Used 569.00 4,994.00 3,394.96 ** 4,994.00 MICKEY D CARSON DBA/NUSCO PC PC PC PC PC PC 5947 AP 5919 AP 5912 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65031-020-000 Chemicals Collections Totals: 4,994.00 4,994.00 ** 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 12,506.00 Remaining 29 % Used Totals: 1,200.00 Remaining 0 % Used Totals: 1,200.00 Remaining 0 % Used Account: 135-65045-020-000 ` Lab Supplies 254 11/14/2019 November A/P lab supplies 359 11/26/2019 PCards 10/29/19 - 11/26/19 Batteries 359 11/26/2019 PCards 10/29/19 - 11/26/19 thermometer 318 11/30/2019 November A/P lab supplies 318 11/30/2019 November A/P sensor COP replacement 356 11/30/2019 November A/P lab supplies Account: 135-65045-020-000 Lab Supplies Totals: 20,000.00 Budgeted .00 .00 .00 .00 ** .00 .00 .00 .00 ** 2,983.01 298.43 3,281.44 HACH COMPANY 5909 AP 21.95 3,303.39 TOM THUMB 91789 PC 177.46 3,480.85 GRAINGER PC 113.94 3,594.79 HD SUPPLY FACILITIES MAINT LTD 5934 AP 153.06 3,747.85 HACH COMPANY 5933 AP 230.48 3,978.33 HACH COMPANY 5970 AP 16,021.67 Remaining 20 % Used Account: 135-69005-020-000 Capital Outlays 359 11/26/2019 PCards 10/29/19 - 11/26/19 hoses 356 11/30/2019 November A/P plant water system Account: 135-69005-020-000 Capital Outlays Totals: 530,500.00 Budgeted 995.32 3,978.33 ** 5,789.00 476.00 6,265.00 STUART HOSE S PIPE - F 439,907.70 Remaining 17 6 Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 PC 84,327.30 90,592.30 REY-MAR CONSTRUCTION 5979 AP 84,803.30 90,592.30 ** .00 .00 Short Term Debt -Principal Totals: .00 .00 ** 79,133.00 Budgeted 79,133.00 Remaining 0 % Used glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 30 Check Source Number Department 20 Totals: 130,000.00 Budgeted 279,847.46 Monthly Total .00 Remaining 100 % Used 567,582.65 ** 3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used Account: 135-69009-020-000 Short Term Debt -Interest .00 .00 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 .00 ** 11,277.00 Budgeted 11,277.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 .00 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 130,000.00 ** Department 20 Totals: 130,000.00 Budgeted 279,847.46 Monthly Total .00 Remaining 100 % Used 567,582.65 ** 3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov 1.99 Account: 135-50045-026-000 Workman's Compensation Totals: 30.00 Budgeted Account: 135-60066-026-000 Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 26.02 Remaining 13 5 Used Account: 135-60070-026-000 Dues & Memberships 318 11/30/2019 November A/P Board annual membership dues F Account: 135-60070-026-000 Dues & Memberships Totals: 750.00 Budgeted Account: 135-60075-026-000 Meetings 359 11/26/2019 PCards 10/29/19 - 11/26/19 Food Board Meeting 359 11/26/2019 PCards 10/29/19 - 11/26/19 board meeting Account: 135-60075-026-000 1.99 3.98 GL 1.99 3.98 ** .00 0 5 Used .00 .00 .00 ** 675.00 675.00 AWBD 75.00 Remaining 90 6 Used Meetings Totals: 1,300.00 Budgeted Account: 135-60080-026-000 Schools S Training Account: 135-60080-026-000 675.00 675.00 ** 118.43 118.43 VINNYS ITALIAN RESTAUR 37.93 1,143.64 Remaining 12 % Used Schools 6 Training Totals: 4,000.00 Budgeted Account: 135-60100-026-000 Travel & per diem Account: 135-60100-026-000 156.36 .00 4,000.00 Remaining 0 % Used Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 8 Used 156.36 TOM THUMB #1789 156.36 ** .00 .00 .00 ** .00 .00 .00 .00 ** 5922 AP PC PC Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 835.34 ** 833.35 Monthly Total 13,230.00 Budgeted 12,394.66 Remaining 6 % Used glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 33 Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,760.64 1,395.32 1,393.86 204.18 1,395.98 4,155.96 5,549.82 5,754.00 7,149.98 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,389.34 7,149.98 ** Account: 135-50005-030-000 12 5 Salaries & Wages Account: 135-50026-030-000 I Medical Insurance 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 11/15/2019 11/27/19 Salaries Salaries Salaries & Wages & Wages & Wages 13,565.85 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 15,084.65 15,068.62 15,088.55 28,650.50 43,719.12 58,807.67 PR PR PR Account: 135-50005-030-000 Salaries & Wages Account: Totals: Medical Insurance Totals: 45,241.82 58,807.67 ** 10,977.62 ** 628,298.00 Budgeted 569,490.33 Remaining 9 % Used Used Account: 135-50010-030-000 135-50027-030-000 Overtime 134 11/01/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/27/19 Overtime 153.21 459.61 3.11 3.11 PR Account: 135-50010-030-000 Overtime Totals: 11.111M3.11 ** 2,000.00 Budgeted 1,996.89 Remaining 0 % Used Account: 135-50016-030-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 2,207.50 2,207.50 PR Account: 135-50016-030-000 Longevity Totals: 2,207.50 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 8 Used Account: 135-50020-030-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,760.64 1,395.32 1,393.86 204.18 1,395.98 4,155.96 5,549.82 5,754.00 7,149.98 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,389.34 7,149.98 ** 58,554.00 Budgeted 51,404.02 Remaining 12 5 Used Account: 135-50026-030-000 I Medical Insurance 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 11/01/19 Medical Insurance 11/15/2019 Medical Insurance 5,488.81 2,744.43 2,744.38 8,233.24 10,977.62 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 5,488.81 10,977.62 ** 124,394.00 Budgeted 113,416.38 Remaining 9 % Used Account: 135-50027-030-000 Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 306.40 153.21 459.61 PR glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 241 11/15/2019 MUD Payroll 11/15/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Dental Insurance 306.40 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 153.19 612.80 Page 34 Check Source Number PR 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 782.00 872.87 868.73 136.86 935.67 1,654.87 2,523.60 2,660.46 3,596.13 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,814.13 3,596.13 ** 39,215.00 Budgeted 35,618.87 Remaining 9 % Used Account: 135-50035-030-000 Medicare Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 182.91 204.12 203.17 32.02 218.82 387.03 590.20 622.22 841.04 PR PR PR PR Account: 135-50040-030-000 9,171.00 Budgeted 8,329.96 Remaining 9 6 Used Unemployment Taxes Account: 135-50027-030-000 Dental Insurance Totals: 306.40 612.80 ** 6,464.00 Budgeted 5,851.20 Remaining 9 % Used Account: 135-50028-030-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 48.77 24.40 24.37 73.17 97.54 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 97.54 ** 1,035.00 Budgeted 937.46 Remaining 9 % Used Account: 135-50029-030-000 Life Insurance & Other 216 11/01/2019 Payroll Benefits November Employee LTD & STD 216 11/01/2019 Payroll Benefits November Employee Benefits 318 11/30/2019 November A/P caf 125 -October 292.42 160.48 149.52 20.00 452.90 602.42 622.42 METLIFE GROUP BENEFITS Humana Inc BenefitMall 5896 5891 5923 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 330.00 622.42 ** 4,500.00 Budgeted 3,877.58 Remaining 14 % Used Account: 135-50030-030-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 782.00 872.87 868.73 136.86 935.67 1,654.87 2,523.60 2,660.46 3,596.13 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,814.13 3,596.13 ** 39,215.00 Budgeted 35,618.87 Remaining 9 % Used Account: 135-50035-030-000 Medicare Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 182.91 204.12 203.17 32.02 218.82 387.03 590.20 622.22 841.04 PR PR PR PR Account: 135-50040-030-000 9,171.00 Budgeted 8,329.96 Remaining 9 6 Used Unemployment Taxes glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes Totals: 1,440.00 Budgeted 1,440.00 Remaining Account: 135-50045-030-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 1 Workman's Compensation Totals: 1,775.00 Budgeted 1,565.36 Remaining Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining Account: 135-50070-030-000 Employee Relations 359 11/26/2019 PCards 10/29/19 - 11/26/19 Lunch Staff- Audit 359 11/26/2019 PCards 10/29/19 - 11/26/19 Steven Get Well Basket Account: 135-50070-030-000 Account: 135-55030-030-000 145 11/01/2019 November A/P 255 11/14/2019 November A/P 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 318 11/30/2019 November A/P 318 11/30/2019 November A/P 360 11/30/2019 November A/P Account: 135-55030-030-000 Account: 135-55070-030-000 Employee Relations Totals: 8,000.00 Budgeted 7,713.78 Remaining Software & Support Microsoft exchang internet-November Phone Bill Phone Bill Phone Bill Monthly Fee support -P Card Microsoft exchange UB & Fixed Assets support - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Software & Support Totals: 134,681.00 Budgeted 66,483.55 Remaining Independent Labor 104.82 178.85 65,525.85 Program: Transaction Detail .00 O % Used .00 104.82 12 % Used O % Used 4 % Used 51 % Used 104.82 .00 .00 37.02 Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 209.64 209.64 ** .00 .00 ** 215.87 PIZZA HUT 24623 70.35 286.22 HAD*HARRY & DAVID 107.37 484.00 899.00 53.91 42.37 42.37 32.45 116.00 494.00 507.50 2,671.60 286.22 ** 66,009.85 66,908.85 66,962.76 67,005.13 67,047.50 67,079.95 67,195.95 67,689.95 68,197.45 M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*SILL PAYMENT ADOBE ACROPRO SUBS STW INC M3 Networks STW INC 68,197.45 ** Page 35 Check Source Number GL PC PC 5862 AP 5906 AP PC PC PC PC 5949 AP 5945 AP 5980 AP glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 36 225 11/06/2019 November A?P 254 11/14/2019 November A/P 254 11/14/2019 November A/P 254 11/14/2019 November A/P 356 11/30/2019 November A/P 356 11/30/2019 November A/P 356 11/30/2019 November A/P Backflow Annual fee -FY 2020 GM -October GM -October GM -October GM -November 2019 GM -November 2019 GM -November 2019 595.00 32.48 11,680.00 4.15 11,040.00 26.68 2.40 595.00 SC TRACKING SOLUTIONS LLC 627.48 Carman Consulting LLC. 12,307.48 Carman Consulting LLC. 12,311.63 Carman Consulting LLC. 23,351.63 Carman Consulting LLC. 23,378.31 Carman Consulting LLC. 23,380.71 Carman Consulting LLC. 5899 AP 5905 AP 5905 AP 5905 AP 5967 AP 5967 AP 5967 AP Account: 135-55070-030-000 Independent Labor Totals: 23,380.71 23,380.71 ** 135,000.00 Budgeted 111,619.29 Remaining 17 % Used Account: 135-55080-030-000 Maintenance & Repairs ' 515.00 .00 515.00 Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 515.00 ** 15,000.00 Budgeted 14,485.00 Remaining 3 o Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 5 Used Account: 135-55120-030-000 Cleaning Services 869.06 .00 869.06 Account: 135-55120-030-000 Cleaning Services Totals: .00 869.06 ** 10,000.00 Budgeted 9,130.94 Remaining 9 5 Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining 0 5 Used Account: 135-55205-030-000 Utility Billing Contract 582.15 .00 582.15 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 37 Account: 135-55205-030-000 Utility Billing Contract Totals: .00 582.15 ** 9,000.00 Budgeted 8,417.85 Remaining 6 8 Used Account: 135-60005-030-000 Telephone 225 11/06/2019 November A?P Answering service -November 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Monthly Fee 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 1,479.80 207.75 471.71 793.33 180.20 14.99 (180.00) 1,687.55 KEYSTONE PARK SECRETARIAL 2,159.26 ATT*BUS PHONE PMT 2,952.59 ATT*BUS PHONE PMT 3,132.79 ATT*BILL PAYMENT 3,147.78 RINGCENTRAL, INC 2,967.78 5893 AP PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,487.98 2,967.78 ** 23,680.00 Budgeted 20,712.22 Remaining 13 % Used Account: 135-60010-030-000 Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 241 11/15/2019 MUD Payroll 11/15/2019 Communications/Mobiles 238.02 88.02 150.00 326.04 476.04 VERIZON WIRELESS 5920 AP PR Account: 135-60010-030-000 ■ Communications/Mobiles Totals: 238.02 476.04 ** 4,000.00 Budgeted 3,523.96 Remaining 12 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 6,879.00 Budgeted 6,879.00 Remaining 0 % Used Account: 135-60025-030-000 Water 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 356 11/30/2019 November A/P water -October 66.78 (56.39) 112.79 10.39 123.18 TROPHY CLUB MUD (WATER BILLS) 5984 AR AP Account: 135-60025-030-000 Water Totals: 56.40 123.18 ** 1,500.00 Budgeted 1,376.82 Remaining 8 % Used Account: 135-60035-030-000 Postage 359 11/26/2019 PCards 10/29/19 - 11/26/19 Mailing Fees 1,726.61 49.43 1,776.04 FEDEX 99710126 PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Account: 135-60040-030-000 345 11/30/2019 Pace Credit Card Fees 345 11/30/2019 Pace Credit Card Fees 356 11/30/2019 November A/P 360 11/30/2019 November A/P Account: 135-60040-030-000 Postage Totals: 30,000.00 Budgeted Service Charges & Fees 28,223.96 Remaining 6 % Used Direct send fees -November Dig Tess -October Service Charges & Fees Totals: 67,000.00 Budgeted 52,729.22 Remaining 49.43 1,776.04 ** 7,047.93 6,725.10 13,773.03 GL 195.05 13,968.08 GL 50.00 14,018.08 Fisery Solutions, LLC 5969 AP 252.70 14,270.78 Texas Excavation Safety System 5981 AP 21 % Used 7,222.85 14,270.78 ** 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 Account: 135-60055-030-000 Insurance 67 11/01/2019 Insurance/Wrk Comp Expense Nov 1,500.00 Remaining 0 % Used 6,998.39 6,998.39 13,996.78 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 13,996.78 ** Account: 135-60066-030-000 Account: 135-60066-030-000 84,000.00 Budgeted 70,003.22 Remaining 17 % Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-030-000 Dues & Memberships 200.00 .00 .00 0 % Used .00 .00 ** .00 200.00 Account: 135-60070-030-000 Dues & Memberships Totals: .00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 359 11/26/2019 PCards 10/29/19 - 11/26/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment safety meeting Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 35.18 35.18 SQ *SQ *HOT & CREAMY D Page 39 Check Source Number PC Account: 135-60075-030-000 Meetings Totals: 35.18 35.18 ** 400.00 Budgeted 364.82 Remaining 9 % Used Account: 135-60079-030-000 Public Education 359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing 359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing 349.75 1.25 125.20 351.00 476.20 CFW PARKING METER NCOURT *TXTARRANTCOSWP PC PC Account: 135-60079-030-000 Public Education Totals: 126.45 476.20 ** 6,000.00 Budgeted 5,523.80 Remaining 8 % Used Account: 135-60080-030-000 Schools & Training 359 11/26/2019 PCards 10/29/19 - 11/26/19 Training GFOA 777.71 195.00 972.71 GOVERNMENT FINANCE OFF PC Account: 135-60080-030-000 Schools & Training Totals: 195.00 972.71 ** 6,850.00 Budgeted 5,877.29 Remaining 14 % Used Account: 135-60100-030-000 Travel & per diem 241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem 91.78 36.30 128.08 PR Account: 135-60100-030-000 Travel & per diem Totals: 36.30 128.08 ** 3,545.00 Budgeted 3,416.92 Remaining 4 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 359 11/26/2019 PCards 10/29/19 - 11/26/19 Pizza for Election Staff 43.01 43.01 MARCOS PIZZA - 5143 PC Account: 135-60115-030-000 Elections Totals: 43.01 43.01 ** .00 Budgeted (43.01) Remaining 0 % Used Account: 135-60125-030-000 Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 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-030-000 Account: 135-60235-030-000 255 11/14/2019 November A/P Account: 135-60235-030-000 .00 .00 Advertising Totals: .00 .00 ** 2,500.00 Budgeted Security monitoring svc-nov 2,500.00 Remaining 0 % Used 24.00 24.00 48.00 Digital Air Control, Inc Security Totals: 24.00 48.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Account: 135-65055-030-000 1,240.00 Remaining 4 % Used Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted Hardware 0 o Used 0 % Used 2,050.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 5907 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 26,485.00 Budgeted 26,485.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies 254 11/14/2019 November A/P office supplies 359 11/26/2019 PCards 10/29/19 - 11/26/19 clipboards 359 11/26/2019 PCards 10/29/19 - 11/26/19 monitor 359 11/26/2019 PCards 10/29/19 - 11/26/19 ink 359 11/26/2019 PCards 10/29/19 - 11/26/19 clock 356 11/30/2019 November A/P office supplies 356 11/30/2019 November A/P office supplies 356 11/30/2019 November A/P office supplies 356 11/30/2019 November A/P office supplies 561.33 112.18 673.51 OFFICE DEPOT, INC 5914 AP 9.95 683.46 AMAZON.COM*WP17E7D13 PC 249.99 933.45 AMAZON.COM*EI1DV6713 PC 12.83 946.28 AMZN MKTP US*2O42M75S3 PC 15.59 961.87 AMZN MKTP US*ZG9FP0XN3 PC 63.50 1,025.37 OFFICE DEPOT, INC 5977 AP 46.91 1,072.28 OFFICE DEPOT, INC 5977 AP 11.19 1,083.47 OFFICE DEPOT, INC 5977 AP 16.15 1,099.62 OFFICE DEPOT, INC 5977 AP Account: 135-65085-030-000 Office Supplies Totals: 538.29 1,099.62 ** 6,000.00 Budgeted 4,900.38 Remaining 18 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 359 11/26/2019 PCards 10/29/19 - 11/26/19 forks,water, cups, creamer,etc 428.00 359 11/26/2019 PCards 10/29/19 - 11/26/19 cups 359 11/26/2019 PCards 10/29/19 - 11/26/19 batteries 359 11/26/2019 PCards 10/29/19 - 11/26/19 refund for coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 refund for coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 refund for tea 359 11/26/2019 PCards 10/29/19 - 11/26/19 refund for coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 tea 359 11/26/2019 PCards 10/29/19 - 11/26/19 tea 359 11/26/2019 PCards 10/29/19 - 11/26/19 coffee 359 11/26/2019 PCards 10/29/19 - 11/26/19 coffee 111.67 539.67 SAMSCLUB.COM PC 15.67 555.34 SAMSCLUB #4795 PC 10.99 566.33 AMAZON.COM*1X6R423D3 PC (29.28) 537.05 AMAZON.COM PC (12.01) 525.04 AMAZON.COM PC (12.88) 512.16 AMAZON.COM PC (29.11) 483.05 AMAZON.COM PC 50.99 534.04 AMZN MKTP US*8R9KH2VM3 PC 32.95 566.99 AMAZON.COM*WU4PB61V3 PC 29.11 596.10 AMAZON.COM*E09VG5QH3 PC 12.01 608.11 AMAZON.COM*TM8QL2DH3 PC 12.88 620.99 AMAZON.COM*6530M29J3 PC 27.45 648.44 AMAZON.COM*B25AT9BG3 PC 29.28 677.72 AMAZON.COM*6W79C8WN3 PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies Totals: 249.72 677.72 ** 4,000.00 Budgeted 3,322.28 Remaining 17 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** Account: 135-69170-030-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Account: 135-69170-030-000 Department 30 Totals: 195,000.00 Budgeted 195,000.00 Remaining 0 o Used Copier Lease Installments copier lease-nov copies Copier Lease Installments Totals: 4,000.00 Budgeted 3,506.64 Remaining 105,293.05 Monthly Total 253.84 165.00 418.84 TIAA COMMERCIAL FINANCE 74.52 493.36 KYOCERA DOCUMENT SOLUTIONS 239.52 12 % Used 493.36 ** 216,740.52 ** 1,776,712.00 Budgeted 1,559,971.48 Remaining 12 % Used 5917 AP 5940 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 254 11/14/2019 November A/P legal 3,570.00 3,570.00 McLean & Howard, L.L.P. 5911 AP 254 11/14/2019 November A/P legal -travel 1,050.00 4,620.00 McLean & Howard, L.L.P. 5911 AP 318 11/30/2019 November A/P Southlake easement 20,884.93 25,504.93 WHITAKER CHALK SWINDLE 5952 AP Account: 135-55045-039-000 Legal Totals: 3 25,504.93 ** Account: 135-55055-039-000 318 11/30/2019 November A/P 135,000.00 Budgeted 109,495.07 Remaining 19 % Used Auditing FYE 2019 Audit 5,000.00 10,150.00 15,150.00 LAFOLLETT & COMPANY, PLLC 5943 AP Account: 135-55055-039-000 Auditing Totals: 10,150.00 15,150.00 ** 33,800.00 Budgeted Account: 135-55060-039-000 Account: 135-55060-039-000 Appraisal 18,650.00 Remaining 45 % Used (13.35) .00 (13.35) Appraisal Totals: .00 (13.35) ** 11,761.00 Budgeted 11,774.35 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Department 39 Totals: 40,641.58 ** Fund 135 Totals: 35,654.93 Monthly Total 184,561.00 Budgeted 253,193.03 Monthly Total 143,919.42 Remaining 22 % Used 40,953.86 (6,224.00) Budgeted (47,177.86) Remaining ####*9#### glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 44 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 #1 - WWTP TAX BOND CONST BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL / UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 568,889 TOTAL ASSETS 568,889 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 691,868 691,868 (118,410) (4,569) (122,979) 568,889 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 14 517-49011-000-000 Interest Income 783.24- 1,822.08- 1,822.08 Subtotal: 783.24- 1,822.08- 1,822.08 Program number: 783.24- 1,822.08- 1,822.08 Department number: Revenues 783.24- 1,822.08- 1,822.08 Revenues Subtotal 783.24- 1,822.08- 1,822.08 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 15 517-69005-020-000 Capital Outlays 6,391.00 6,391.00 6,391.00 - Subtotal: 6,391.00 6,391.00 6,391.00 - Program number: 6,391.00 6,391.00 6,391.00 - Department number: Wastewater 6,391.00 6,391.00 6,391.00 - Expenditures Subtotal 6,391.00 6,391.00 6,391.00 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 5,607.76 4,568.92 4,568.92- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (1,038.84) Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 1,822.08 Remaining 0 % Used (783.24) (783.24) (1,822.08) (1,822.08) ** Department Totals: (1,822.08) ** (783.24) Monthly Total .00 Budgeted 1,822.08 Remaining 0 % Used GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/2019 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 318 11/30/2019 November A/P WWTP Crane survey 318 11/30/2019 November A/P WWTP legal 2,056.00 2,056.00 Wiss, Janney, Elstner Assoc 5953 AP 4,335.00 6,391.00 Dubois Bryant Campbell LLP 5932 AP Account: 517-69005-020-000 Capital Outlays Totals: 6,391.00 6,391.00 ** .00 Budgeted (6,391.00) Remaining 0 % Used Department 20 Totals: 6,391.00 ** 6,391.00 Monthly Total .00 Budgeted (6,391.00) Remaining 0 % Used Fund 517 Totals: 4,568.92 5,607.76 Monthly Total .00 Budgeted (4,568.92) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 780,339 TOTAL ASSETS 780,339 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 698,648 780,339 TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET NOVEMBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 586,482 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,456,058 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 6,004 TOTAL LIABILITIES 6,004 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (4,236) TOTAL FUND BALANCE 4,450,054 TOTAL LIABILITIES AND FUND BALANCE 4,456,058 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 520 Revenue Bond 16" Waterline Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 16 520-49011-000-000 Interest Income 807.46- 1,767.21- 1,767.21 Subtotal: 807.46- 1,767.21- 1,767.21 Program number: 807.46- 1,767.21- 1,767.21 Department number: 807.46- 1,767.21- 1,767.21 Revenues Subtotal 807.46- 1,767.21- 1,767.21 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 520 Revenue Bond 16" Waterline Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 17 520-69005-010-000 Capital Outlays 6,003.50 6,003.50 6,003.50 - Subtotal: 6,003.50 6,003.50 6,003.50 - Program number: 6,003.50 6,003.50 6,003.50 - Department number: Water Department 6,003.50 6,003.50 6,003.50 - Expenditures Subtotal 6,003.50 6,003.50 6,003.50 - Fund number: 520 Revenue Bond 16" Waterline 5,196.04 4,236.29 4,236.29- glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 47 Account: 520-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (959.75) Account: 520-49011-000-000 Department Totals: Interest Income Totals: .00 Budgeted 1,767.21 Remaining 0 % Used (807.46) Monthly Total .00 Budgeted (807.46) (1,767.21) GL (807.46) (1,767.21) ** (1,767.21) ** 1,767.21 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 318 11/30/2019 November A/P 318 11/30/2019 November A/P Account: 520-69005-010-000 Capital Outlays Easement -Lake Cities Church of 16" waterline easement acquisi 4,424.00 4,424.00 Lake Cities Church of Christ 5942 AP 1,579.50 6,003.50 Jackson Walker LLP 5939 AP Capital Outlays Totals: 6,003.50 6,003.50 ** .00 Budgeted (6,003.50) Remaining 0 % Used Department 10 Totals: 6,003.50 ** 6,003.50 Monthly Total .00 Budgeted (6,003.50) Remaining 0 % Used Fund 520 Totals: 4,236.29 5,196.04 Monthly Total .00 Budgeted (4,236.29) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 826,594 TOTAL ASSETS 826,594 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 23,137 826,594 826,594 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 16:37 12/09/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/2019 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 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 11,000.00- 11,000.00- 307,049.00- 307,049.00- 200,417.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 1,131.32- 2,436.79- 4,600.00- 9,200.00- 5,750.00- 11,500.00- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 22.153 2.996 5.738 4.463 4.463 4.463 4.463 4.463 8,563.21- 297,849.00- 188,917.00- 495,329.21- 495,329.21- 495,329.21- 495,329.21- 495,329.21- glpdatb2 skrolczyk 16:38 12/09/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November Account: 528-49011-000-000 Trophy Club MUD No.1 Page 49 Detailed Accounting Trial Balance Program: Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (11,000.00) Budgeted (1,305.47) (1,131.32) (2,436.79) GL (1,131.32) (2,436.79) ** (8,563.21) Remaining 22 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (307,049.00) Budgeted (297,849.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 346 11/15/2019 TexPool Transfers November TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: Interfund transfer in -WW Totals: (200,417.00) Budgeted (188,917.00) Remaining (11,481.32) Monthly Total (4,600.00) (4,600.00) (9,200.00) GL (4,600.00) (9,200.00) ** 3 % Used (5,750.00) (5,750.00) (11,500.00) GL 6 % Used (518,466.00) Budgeted (11,481.32) Monthly Total (518,466.00) Budgeted (5,750.00) (11,500.00) ** (23,136.79) ** (495,329.21) Remaining 4 % Used (23,136.79) (495,329.21) Remaining 4 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS 146,424 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 668,429 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 814,853 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 668,429 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 668,429 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 63,470 TOTAL FUND BALANCE 146,424 TOTAL LIABILITIES AND FUND BALANCE 814,853 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Page 19 Budget Summary with Amendment Department: Revenues Program: Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 33,745.30- 565.22- 98.36- 42,469.72- 274.56 141.16- 6.223 -27.456 7.058 639,971.28- 1,274.56- 1,858.84 - Subtotal: 685,441.00- 685,441.00- 34,408.88- 42,336.32- 6.177 643,104.68- 533-49011-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 5,000.00- 218,004.00- 5,000.00- 218,004.00- 166.99- 303.85- 6.077 4,696.15- 218,004.00- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 10,414.81- 20,829.62- 18.182 93,733.38 - Subtotal: 337,567.00- 337,567.00- 10,581.80- 21,133.47- 6.261 316,433.53 - Program number: 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21 - Department number: Revenues 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21- glbase_tbam skrolczyk 16:37 12/09/19 Fund: 533 MUD 1 I&S Consolidated Account 1 533-70005-051-000 Description Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. 2,150.00 2,150.00 Current Month Program: YTD Total % of Remaining Budget Budget 2,150.00 Page 20 533-70025-051-000 Bond Interest Expense -Tax 1 533-70035-051-000 Bond Principal Payment -Tax 266,058.00 755,000.00 266,058.00 755,000.00 266,058.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 1,023,208.00 Expenditures Subtotal 1,023,208.00 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 200.00 200.00 44,990.68- 63,469.79- ############### 63,669.79 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 50 Check Source Number Account: 533-40000-000-000 Property Taxes 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (8,724.42) (866.20) (2,033.58) (3,742.83) (1,461.62) (1,745.61) (3,184.72) (810.70) (3,766.35) (2,021.15) (834.34) (471.21) (1,934.66) (4,889.40) (1,087.78) (99.53) (2,049.66) (2,025.74) (720.22) (9,590.62) (11,624.20) (15,367.03) (16,828.65) (18,574.26) (21,758.98) (22,569.68) (26,336.03) (28,357.18) (29,191.52) (29,662.73) (31,597.39) (36,486.79) (37,574.57) (37,674.10) (39,723.76) (41,749.50) (42,469.72) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (33,745.30) (42,469.72) ** (682,441.00) Budgeted (639,971.28) Remaining 6 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 839.78 (130.88) (175.84) (2.11) 10.33 (266.72) 708.90 533.06 530.95 541.28 274.56 GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (565.22) 274.56 ** (1,000.00) Budgeted (1,274.56) Remaining -27 % Used Account: 533-40015-000-000 Property Taxes/P & I 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 380 11/27/2019 Property Taxes (42.80) (28.80) (71.60) (10.66) (82.26) (.40) (82.66) (58.50) (141.16) GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (98.36) (141.16) ** (2,000.00) Budgeted (1,858.84) Remaining 7 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (114,563.00) Budgeted (44,990.68) Monthly Total (93,733.38) Remaining 18 % Used (1,023,008.00) Budgeted (63,469.79) ** (959,538.21) Remaining 6 % Used Account: 533-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (136.86) (166.99) (303.85) GL Account: 533-49011-000-000 Interest Income Totals: (166.99) (303.85) ** (5,000.00) Budgeted (4,696.15) Remaining 6 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,004.00) Budgeted (218,004.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt (10,414.81) (10,414.81) (20,829.62) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (20,829.62) ** Department Totals: (114,563.00) Budgeted (44,990.68) Monthly Total (93,733.38) Remaining 18 % Used (1,023,008.00) Budgeted (63,469.79) ** (959,538.21) Remaining 6 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2019 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 Account: 533-70005-051-000 Paying Agent Fee Totals: 2,150.00 Budgeted 2,150.00 Remaining 0 6 Used .00 .00 .00 .00 ** Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 Account: 533-70035-051-000 Department 51 Totals: .00 .00 Bond Interest Expense -Tax Totals: .00 .00 ** 266,058.00 Budgeted 266,058.00 Remaining .00 .00 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 6 Used .00 ** Account: 533-70035-051-000 Bond Principal Payment -Tax 0 % Used .00 Monthly Total 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used Fund 533 Totals: (63,469.79) (44,990.68) Monthly Total 200.00 Budgeted 63,669.79 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 133,554 TOTAL ASSETS 133,554 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 109,037 133,554 133,554 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 16:37 12/09/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 148.62- 193.89- 7.756 2,306.11- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00- 54,421.03- 108,842.66- 18.182 489,795.34 - Subtotal: 601,138.00- 601,138.00- 54,569.65- 109,036.55- 18.138 492,101.45 - Program number: 601,138.00- 601,138.00- 54,569.65- 109,036.55- 18.138 492,101.45 - Department number: Revenues 601,138.00- 601,138.00- 54,569.65- 109,036.55- 18.138 492,101.45 - Revenues Subtotal 601,138.00- 601,138.00- 54,569.65- 109,036.55- 18.138 492,101.45- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 16:37 12/09/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2019 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 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 Subtotal: Program number: Department number: Administration Expenditures Subtotal Fund number: 534 2015 Revenue Bond I&S 598,638.00 598,638.00 598,638.00 598,638.00 598,638.00 598,638.00 598,638.00 598,638.00 2,500.00- 2,500.00- 54,569.65- 109,036.55- 4,361.462 400.00 208,238.00 390,000.00 598,638.00 598,638.00 598,638.00 598,638.00 106,536.55 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (598,638.00) Budgeted (54,569.65) Monthly Total (489,795.34) Remaining 18 % Used (601,138.00) Budgeted (109,036.55) ** (492,101.45) Remaining 18 % Used Account: 534-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (45.27) (148.62) (193.89) GL Account: 534-49011-000-000 Interest Income Totals: (148.62) (193.89) ** (2,500.00) Budgeted (2,306.11) Remaining 8 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S (54,421.63) 389 11/15/2019 Adjust TexPool Tnfr Dep JE346 (54,421.63) .60 (108,843.26) (108,842.66) GL GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.03) (108,842.66) ** Department Totals: (598,638.00) Budgeted (54,569.65) Monthly Total (489,795.34) Remaining 18 % Used (601,138.00) Budgeted (109,036.55) ** (492,101.45) Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2019 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 Totals: 400.00 Budgeted 400.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 208,238.00 Remaining O 6 Used .00 .00 .00 .00 ** .00 O % Used .00 .00 .00 ** Account: 534-70045-051-000 Revenue Bond Principal Expense Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining Department 51 Totals: Fund 534 Totals: .00 .00 O % Used .00 Monthly Total 598,638.00 Budgeted (54,569.65) Monthly Total .00 .00 ** .00 ** 598,638.00 Remaining 0 % Used (109,036.55) (2,500.00) Budgeted 106,536.55 Remaining 8888888888 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 55,132 TOTAL ASSETS 55,132 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4,967 50,165 55,132 TOTAL LIABILITIES AND FUND BALANCE 55,132 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00 - Program: Current YTD Month Total 59.67- 70.21- 25,047.72- 50,095.44- 25,107.39- 50,165.65- 25,107.39- 50,165.65- 25,107.39- 50,165.65- 25,107.39- 50,165.65- % of Budget Remaining Budget 7.021 929.79- 18.182 225,429.56- 18.141 226,359.35- 18.141 226,359.35- 18.141 226,359.35- 18.141 226,359.35 - Page 23 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 16:37 12/09/19 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bond Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: 602,611.00 602,611.00 Program number: 602,611.00 Department number: Administration Expenditures Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 326,086.00 25,107.39- 50,165.65- -15.384 602,611.00 602,611.00 376,251.65 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (275,525.00) Budgeted (25,107.39) Monthly Total (225,429.56) Remaining 18 % Used (276,525.00) Budgeted (50,165.65) ** (226,359.35) Remaining 18 % Used Account: 535-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (10.54) (59.67) (70.21) GL Account: 535-49011-000-000 Interest Income Totals: (59.67) (70.21) ** (1,000.00) Budgeted (929.79) Remaining 7 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S (25,047.72) (25,047.72) (50,095.44) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (50,095.44) ** Department Totals: (275,525.00) Budgeted (25,107.39) Monthly Total (225,429.56) Remaining 18 % Used (276,525.00) Budgeted (50,165.65) ** (226,359.35) Remaining 18 % Used Page 56 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance DetailDetail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 800.00 Budgeted 800.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining O % Used .00 .00 .00 .00 ** .00 O % Used Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining Department 51 Totals: O % Used .00 Monthly Total 602,611.00 Budgeted .00 .00 .00 ** .00 .00 .00 .00 ** .00 ** 602,611.00 Remaining 0 % Used Fund 535 Totals: (50,165.65) (25,107.39) Monthly Total 326,086.00 Budgeted 376,251.65 Remaining -15 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 59,536 TOTAL ASSETS 59,536 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 59,536 TOTAL FUND BALANCE 59,536 TOTAL LIABILITIES AND FUND BALANCE 59,536 glbase_tbam skrolczyk Trophy Club MUD No.1 16:37 12/09/19 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 11/2019 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 62.71- 65.69- 22,896.02- 45,792.04- 6,839.07- 13,678.14- 65.69 45,792.04 13,678.14 Page 25 Subtotal: 29,797.80- 59,535.87 - 59,535.87 Program number: 29,797.80 - Department number: Revenues Revenues Subtotal Fund number: 536 2019 Rev Bond I&S- W&WW System End of Report ********* 59,535.87- 59,535.87 29,797.80- 59,535.87- 29,797.80- 59,535.87- 29,797.80- 59,535.87- 59,535.87 59,535.87 59,535.87 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (2.98) Account: 536-49011-000-000 Interest Income Totals: .00 Budgeted 65.69 Remaining 0 6 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S (22,896.02) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: .00 Budgeted 45,792.04 Remaining Account: 536-49143-000-000 Interfund Transfer In -WW Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 Budgeted 13,678.14 Remaining (62.71) (65.69) GL (62.71) (65.69) ** (22,896.02) (45,792.04) GL (22,896.02) (45,792.04) ** 0 % Used (6,839.07) (6,839.07) (13,678.14) GL 0 % Used (6,839.07) (13,678.14) ** Department Totals: (59,535.87) ** (29,797.80) Monthly Total .00 Budgeted 59,535.87 Remaining 0 % Used Fund 536 Totals: (59,535.87) (29,797.80) Monthly Total .00 Budgeted 59,535.87 Remaining 0 % Used Grand Totals: (283,888.62) **** 100,292.99 Monthly Total ******* End of Report ********* (200,904.00) Budgeted 82,984.62 Remaining 141 % Used