Loading...
HomeMy WebLinkAbout2019-08 Combined Financials August 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 660,343 1,491 20,411 TOTAL ASSETS 682,246 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 20,418 TOTAL LIABILITIES 20,418 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 117,945 TOTAL FUND BALANCE 661,828 TOTAL LIABILITIES AND FUND BALANCE 682,246 glbase tbam skrolczyk 18:24 09/10/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 2,788.55- 62.08 359.69- 1,102,825.22- 3,190.08 4,978.64- 98.731 14,174.78- 3,190.08- 4,978.64 Subtotal: 1,117,000.00- 1,117,000.00- 3,086.16- 1,104,613.78- 98.891 12,386.22- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00- 122-49900-000-000 Miscellaneous Income 135,611.06- 135,611.06 Subtotal: 75,000.00- 75,000.00- 135,611.06- 180.815 60,611.06 Program number: 1,192,000.00- 1,192,000.00- 3,086.16- 1,240,224.84- 104.046 48,224.84 Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 3,086.16- 1,240,224.84- 104.046 48,224.84 Revenues Subtotal 1,192,000.00- 1,192,000.00- 3,086.16- 1,240,224.84- 104.046 48,224.84 glbase tbam skrolczyk 18:24 09/10/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 215,979.00 18,000.00 674,452.00 215,979.00 18,000.00 674,452.00 1,491.21 56,204.33 215,979.00 16,403.31 618,247.30 100.000 91.130 91.667 1,596.69 56,204.70 Page 2 Subtotal: 908,431.00 908,431.00 57,695.54 850,629.61 93.637 57,801.39 122-69005-045-000 1 122-69195-045-000 Capital Outlays GASB34/Reserve for Replacement 75,000.00 81,420.00 75,000.00 81,420.00 63,082.00 63,082.00 81,420.00 84.109 100.000 11,918.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 63,082.00 271,650.60 95.797 11,918.40 Program number: 1,192,000.00 1,192,000.00 120,777.54 1,122,280.21 94.151 69,719.79 Department number: Fire 1,192,000.00 1,192,000.00 120,777.54 1,122,280.21 94.151 69,719.79 Expenditures Subtotal 1,192,000.00 1,192,000.00 120,777.54 1,122,280.21 94.151 69,719.79 Fund number: 122 Trophy Club MUD Fire Dept. 117,691.38 117,944.63- 117,944.63 glpdatb2 skrolczyk 18:24 09/10/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 8/2019 JE Detail Description/Comment Page 1 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1997 08/07/2019 Property Taxes 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2002 08/16/2019 Property Taxes 2003 08/19/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes (1,100,036.67) (266.50) (1,100,303.17) (611.32) (1,100,914.49) (1,569.00) (1,102,483.49) (6.72) (1,102,490.21) (40.88) (1,102,531.09) (9.48) (1,102,540.57) (107.33) (1,102,647.90) (61.79) (1,102,709.69) 4.42 (1,102,705.27) 29.92 (1,102,675.35) (7.79) (1,102,683.14) (98.07) (1,102,781.21) (44.01) (1,102,825.22) GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,788.55) (1,102,825.22) ** (1,117,000.00) Budgeted (14,174.78) Remaining 99 o Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2003 08/19/2019 2005 08/27/2019 2007 08/30/2019 Property Property Property Taxes Taxes Taxes 3,128.00 73.16 (.49) (10.59) 3,201.16 3,200.67 3,190.08 GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 62.08 3,190.08 ** .00 Budgeted (3,190.08) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes 2007 08/30/2019 Property Taxes (4,618.95) (9.21) (11.64) (287.25) (.87) (1.53) (17.12) (9.87) (1.04) (1.74) (16.14) (3.28) (4,628.16) (4,639.80) (4,927.05) (4,927.92) (4,929.45) (4,946.57) (4,956.44) (4,957.48) (4,959.22) (4,975.36) (4,978.64) GL GL GL GL GL GL GL GL GL GL GL Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (359.69) (4,978.64) ** .00 Budgeted 4,978.64 Remaining 0 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Period Ending: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 2 Check Source Number Department Totals: .00 Budgeted (3,086.16) Monthly Total 135,611.06 Remaining 0 % Used (1,240,224.84) ** (1,192,000.00) Budgeted 48,224.84 Remaining 104 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income (135,611.06) .00 (135,611.06) Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (135,611.06) ** Department Totals: .00 Budgeted (3,086.16) Monthly Total 135,611.06 Remaining 0 % Used (1,240,224.84) ** (1,192,000.00) Budgeted 48,224.84 Remaining 104 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Page 3 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 8/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 122-60030-045-000 Rent And/Or Usage Account: 122-60030-045-000 Rent And/Or Usage 215,979.00 Budgeted Account: 122-60055-045-000 Insurance 135 08/01/2019 Insurance/Wrk Comp Expense Aug 215,979.00 .00 215,979.00 Totals: .00 215,979.00 ** .00 Remaining 100 % Used 14,912.10 1,491.21 16,403.31 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 16,403.31 ** 18,000.00 Budgeted 1,596.69 Remaining 91 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1864 08/07/2019 August A/P Fire Admin -August 562,042.97 56,204.33 Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 674,452.00 Budgeted 56,204.70 Remaining 618,247.30 TOWN OF TROPHY CLUB 5608 AP 56,204.33 618,247.30 ** 92 % Used Account: 122-69005-045-000 Capital Outlays 1921 08/20/2019 August A?P Exhaust system fire 63,082.00 63,082.00 Rossman Enterprises Inc 5646 AP Account: 122-69005-045-000 Capital Outlays Totals: 63,082.00 63,082.00 ** 75,000.00 Budgeted 11,918.00 Remaining 84 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining Account: 122-69305-045-000 Capital Leases Account: 122-69305-045-000 Capital Leases Totals: 127,149.00 Budgeted .40 Remaining 100 % Used 127,148.60 Department 45 Totals: 100 % Used 120,777.54 Monthly Total 1,192,000.00 Budgeted .00 127,148.60 .00 127,148.60 ** 1,122,280.21 ** 69,719.79 Remaining 94 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: (117,944.63) 117,691.38 Monthly Total .00 Budgeted 117,944.63 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET AUGUST 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,666,221 1,666,221 CASH IN BANK -SAVINGS -CASH RESERVE 1,194,713 1,194,713 INVESTMENTS-TEXPOOL 4,715,508 516,233 5,231,741 PREPAID EXPENSES 17,034 17,034 ADVALOREM PROPERTY TAXES RECEIVABLE 2,189 2,189 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,333,903 1,333,903 TOTAL ASSETS 8,930,168 516,233 9,446,401 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,189 2,189 ACCOUNTS AND OTHER PAYABLES 516,387 516,387 CUSTOMER DEPOSITS 313,029 313,029 TOTAL LIABILITIES 831,605 831,605 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 2,173,156 2,173,156 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT (116,613) (116,613) ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,442,543 5,442,543 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 474,378 474,378 TOTAL FUND BALANCE 8,098,563 516,233 8,614,796 TOTAL LIABILITIES AND FUND BALANCE 8,930,168 516,233 9,446,401 glbase tbam skrolczyk 18:24 09/10/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 132,384.00- 300.00- 300.00- 171,983.00- Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 8/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- Current Month 342.64- 6.69 40.97- Program: YTD Total 125,588.74- 329.33 552.78- % of Budget 94.867 -109.777 184.260 Remaining Budget 6,795.26- 629.33- 252.78 171,983.00- Page 3 Subtotal: 304,967.00- 304,967.00- 376.92- 125,812.19- 41.254 179,154.81- 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 Subtotal: 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49075-000-000 135-49141-000-000 135-49900-000-000 135-49901-000-000 Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In Miscellaneous income Records Management Revenue Subtotal: Program number: Department number: Revenues Revenues Subtotal 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00 - 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 80,000.00- 14,146.00- 7,000.00- 55,000.00- 358,600.00- 266,613.00- 18,522.00- 7,000.00- 806,881.00- 11,343,415.00- 11,343,415.00- 11,343,415.00 - 824,263.75- 267,933.63- 9,484.30- 1,300.00- 600.00- 150.00- 20,907.20- 1,124,638.88- 13,341.97- 1,178.81- 583.33- 3,336.00- 4,967.61- 23,407.72- 1,148,423.52- 1,148,423.52- 1,148,423.52 - 4,394,910.32- 2,811,128.44- 88,442.21- 14,350.00- 1,750.00- 3,600.00- 40,592.80- 7,354,773.77- 126,789.45- 13,293.58- 6,416.63- 52,600.00- 266,613.00- 11,568.00- 25,000.00- 37,350.88- 4.00- 539,635.54- 8,020,221.50- 8,020,221.50- 8,020,221.50- 66.595 82.373 64.832 84.412 116.667 80.000 67.655 71.883 158.487 93.974 91.666 95.636 100.000 62.455 533.584 66.879 70.704 70.704 70.704 2,204,573.68- 601,536.56- 47,975.79- 2,650.00- 250.00 900.00- 19,407.20- 2,876,793.23- 46,789.45 852.42- 583.37- 2,400.00- 358,600.00- 6,954.00- 25,000.00 52.42 -583.37-2,400.00- 358,600.00- 6,954.00- 25,000.00 30,350.88 4.00 267,245.46- 3,323,193.50- 3,323,193.50- 3,323,193.50- Page 67,245.46-3,323,193.50-3,323,193.50- 3,323,193.50- glbase tbam skrolczyk 18:24 09/10/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 Subtotal: 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 Subtotal: 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 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 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 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 Department: Adopted Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Trophy Club MUD No.1 Page 4 Budget Summary with Amendment 10 Water Period Ending: 8/2019 Amended Total Budget Encumb. 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 153,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 196,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Current Month 23,922.69 1,057.00 125.00 2,322.19 4,219.68 261.55 42.47 209.67 1,491.38 348.77 930.94 73.59 35,004.93 20,116.72 1,245.59 320.00 21,682.31 337.69 12,255.73 4,747.10 273,886.01 25,172.90 4,600.00 Program: YTD Total 269,854.55 10,987.62 3,620.00 1,925.00 27,542.13 42,603.84 2,733.35 447.52 2,344.13 17,260.61 4,036.74 46.80 9,969.74 202.45 73.59 393,648.07 131,652.23 1,906.30 4,456.13 7,496.62 145,511.28 3,433.15 98,401.38 790.00 122.00 3,556.01 678.98 21,083.63 1,474,330.81 612.00 6,590.00 276,901.00 50,600.00 % of Budget 82.586 54.938 100.000 40.104 82.699 56.943 63.316 63.840 74.868 78.382 78.383 4.333 77.315 101.225 24.530 76.721 86.047 63.543 89.123 115.333 74.159 68.663 63.812 79.000 24.400 76.457 28.954 36.351 48.924 20.400 44.678 47.317 91.678 Remaining Budget 56,900.45 9,012.38 2,875.00 5,761.87 32,214.16 1,583.65 253.48 786.87 4,760.39 1,113.26 1,033.20 2,925.26 2.45- 226.41 119,443.93 20,000.00 21,347.77 1,093.70 543.87 3,500.00 5,214.00 996.62- 50,702.72 1,566.85 55,802.62 210.00 378.00 1,094.99 400.00 1,666.02 1,500.00 36,916.37 1,539,163.19 200.00 2,388.00 8,160.00 308,308.00 4,593.00 200,000.00 glbase tbam skrolczyk 18:24 09/10/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 4,101,946.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 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 8/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.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 719,613.00 30,068.00 4,124.00 75,000.00 120,000.00 948,805.00 5,959,447.00 Current Month 320,999.43 908.45 147.96 2,427.14 36,927.00 40,410.55 398,672.28 1,840.43 400,512.71 818,609.93 Program: YTD Total 1,937,098.96 9,474.47 2,218.77 20,982.02 641.25 54,788.60 86,949.00 175,054.11 1,023,176.18 30,068.00 4,124.36 75,000.00 99,877.11 1,232,245.65 3,883,558.07 % of Budget 47.224 63.163 42.751 104.910 64.125 78.269 99.941 87.795 142.184 100.000 100.009 100.000 83.231 129.873 65.166 Remaining Budget 2,500.00 2,164,847.04 5,525.53 2,971.23 982.02- 1,200.00 358.75 15,211.40 51.00 24,335.89 303,563.18- .36- 20,122.89 283,440.65- 2,075,888.93 glbase_tbam skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund Account Description 135-55135-010-001 Subtotal: Program number: Department number: Lab Analysis for PID 1 Lab Analysis for PID Water Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 2,000.00 5,641,834.00 2,000.00 2,000.00 2,000.00 5,961,447.00 80.00 80.00 80.00 1,431.59 1,431.59 1,431.59 818,689.93 3,884,989.66 71.580 568.41 71.580 568.41 71.580 65.169 568.41 2,076,457.34 glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 18:24 09/10/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 26,780.02 306,474.59 72.676 115,224.41 135-50010-020-000 Overtime 30,000.00 30,000.00 1,423.45 31,025.68 103.419 1,025.68- 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 725.00 7,850.00 90.230 850.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,675.89 34,150.25 78.913 9,125.75 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 60,648.82 66.191 30,978.18 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 3,840.15 75.238 1,263.85 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 621.82 75.281 204.18 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 384.94 3,677.09 81.804 817.91 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,687.80 20,642.69 71.167 8,363.31 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 394.72 4,827.73 71.163 1,956.27 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 54.00 4.286 1,206.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 12,913.23 76.225 4,027.77 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 114.00 28.500 286.00 135-50070-020-000 Employee Relations 300.00 300.00 75.74 25.247 224.26 Subtotal: 667,863.00 667,863.00 41,262.23 494,360.79 74.021 173,502.21 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 2,921.00 19.473 12,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 133,000.00 7,911.87 118,153.60 88.837 14,846.40 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 5,451.63 54.516 4,548.37 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 70.96 1,763.70 22.046 6,236.30 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 7,000.00 1,121.90 7,924.90 113.213 924.90- 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 87.50 87.50 1.678 5,126.50 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 3,827.68 63,447.52 84.597 11,552.48 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,215.56 30,084.77 85.956 4,915.23 Subtotal: 267,714.00 318,214.00 15,235.47 229,834.62 72.226 88,379.38 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 372.26 4,554.46 91.089 445.54 135-60020-020-000 Electricity 174,165.00 174,165.00 11,663.09 134,288.07 77.104 39,876.93 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 191.00 63.667 109.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 1,658.23 23.176 5,496.77 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 544.55 28.736 1,350.45 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 3,491.07 69.821 1,508.93 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,545.22 55.151 13,454.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 4.00 .889 446.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 225.18 4.504 4,774.82 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 5,639.47 48.616 5,960.53 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,914.00 120,053.00 100.000 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 18:24 09/10/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 688,330.00 125,187.00 200,000.00 3,500.00 688,330.00 125,187.00 200,000.00 3,500.00 54,203.50 10,432.00 596,238.00 114,752.00 86.621 91.664 791.00 22.600 92,092.00 10,435.00 200,000.00 2,709.00 Subtotal: 1,381,335.00 1,381,335.00 87,584.85 999,075.99 72.327 382,259.01 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 937.07 1,138.00 637.99 11,713.43 2,713.30 31,063.09 1,004.27 1,637.69 16,571.83 93.707 49.378 103.544 83.689 136.474 82.859 786.57 2,781.70 1,063.09- 195.73 437.69- 3,428.17 Subtotal: 70,395.00 70,395.00 2,713.06 64,703.61 91.915 5,691.39 135-69005-020-000 135-69008-020-000 135-69009-020-000 1 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement 330,000.00 109,858.00 14,917.00 30,000.00 688,600.00 109,858.00 14,917.00 30,000.00 9,230.94- 19,075.14 6,205.19 572,131.16 58,933.73 9,232.74 30,000.00 83.086 53.645 61.894 100.000 116,468.84 50,924.27 5,684.26 Subtotal: 484,775.00 843,375.00 16,049.39 670,297.63 79.478 173,077.37 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 1,500.00 - Subtotal: 1,500.00 1,500.00 - Program number: 2,872,082.00 3,281,182.00 162,845.00 2,459,772.64 74.966 821,409.36 Department number: Wastewater 2,872,082.00 3,281,182.00 162,845.00 2,459,772.64 74.966 821,409.36 glbase tbam skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 8/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 23.32 % of Remaining Budget Budget 77.733 6.68 Page 9 Subtotal: 30.00 30.00 2.12 23.32 77.733 6.68 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem 150.00 750.00 1,300.00 4,000.00 5,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 28.53 650.00 92.87 920.00 800.06 86.667 7.144 23.000 16.001 150.00 100.00 1,207.13 3,080.00 4,199.94 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 28.53 2,462.93 18.659 10,737.07 Program number: 13,230.00 13,230.00 30.65 2,486.25 18.793 10,743.75 Department number: Board of Directors 13,230.00 13,230.00 30.65 2,486.25 18.793 10,743.75 glbase tbam skrolczyk Trophy Club MUD No.1 Page 10 18:24 09/10/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 29,046.79 329,125.88 74.631 111,880.12 57.98 2.899 1,942.02 1,832.50 99.973 .50 2,686.83 31,979.21 77.718 9,168.79 5,123.40 53,177.16 64.933 28,717.84 289.83 3,053.16 71.153 1,237.84 45.48 488.72 69.718 212.28 312.42 3,339.86 74.302 1,155.14 1,696.88 19,533.52 70.825 8,046.48 396.84 4,568.33 70.827 1,881.67 59.58 4.729 1,200.42 106.55 1,132.45 87.448 162.55 38.00 179.95 35.990 320.05 3,115.29 62.306 1,884.71 Subtotal: 619,454.00 619,454.00 39,743.02 451,643.59 72.910 167,810.41 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 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 2,024.16 54,893.31 70.513 22,955.69 18,602.80 138,114.03 78.922 36,885.97 4,975.00 24.875 15,025.00 927.52 9.275 9,072.48 869.06 8,690.60 86.906 1,309.40 7,037.50 68,964.00 104.404 2,909.00- 5,801.84 64.465 3,198.16 Subtotal: 367,904.00 367,904.00 28,533.52 282,366.30 76.750 85,537.70 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-60125-030-000 135-60235-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 Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 1,444.42 16,034.93 68.234 7,465.07 237.94 2,613.35 65.334 1,386.65 482.42 5,692.89 65.511 2,997.11 64.24 623.21 31.161 1,376.79 156.28 18,375.27 61.251 11,624.73 5,690.79 59,536.89 107.158 3,976.89- 1,500.00 6,302.73 69,330.03 106.662 4,330.03- 1,000.00 4,269.25 71.154 1,730.75 133.82 33.455 266.18 260.99 4.350 5,739.01 1,172.00 13.095 7,778.00 8.03 148.99 3.429 4,196.01 200.00 25,000.00 24.00 264.00 20.497 1,024.00 glbase tbam skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 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: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 124.49 239.99 24.898 9.600 375.51 17,000.00 2,260.01 Subtotal: 263,433.00 263,433.00 14,410.85 178,820.10 67.881 84,612.90 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 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 165.50 152.45 3,554.79 6,410.94 4,480.32 50.323 106.849 112.008 2,050.00 3,509.21 410.94- 3,500.00 480.32- 2,500.00 Subtotal: 25,114.00 25,114.00 317.95 14,446.05 57.522 10,667.95 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 37,311.84 107,238.98 38.300 172,761.02 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 287.37 3,011.34 75.284 988.66 Subtotal: 284,000.00 284,000.00 37,599.21 110,250.32 38.821 173,749.68 Program number: 1,559,905.00 1,559,905.00 120,604.55 1,037,526.36 66.512 522,378.64 Department number: Administration 1,559,905.00 1,559,905.00 120,604.55 1,037,526.36 66.512 522,378.64 glbase_tbam skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: Period Ending: 8/2019 Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 8,782.50 122,010.57 89.059 135-55055-039-000 Auditing 30,800.00 30,800.00 26,459.53 85.908 135-55060-039-000 Appraisal 11,714.00 11,714.00 8,945.42 76.365 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 3,653.00 76.104 Subtotal: 184,314.00 184,314.00 8,782.50 161,068.52 87.388 Program number: 184,314.00 184,314.00 8,782.50 161,068.52 87.388 Department number: Non Departmental 184,314.00 184,314.00 8,782.50 161,068.52 87.388 Expenditures Subtotal 10,271,365.00 11,000,078.00 1,110,952.63 7,545,843.43 68.598 Fund number: 135 MUD 1 General Fund 341,837.00- 343,337.00- 37,470.89- 474,378.07- 138.167 14,989.43 4,340.47 2,768.58 1,147.00 23,245.48 23,245.48 23,245.48 3,454,234.57 131,041.07 glbase tbam skrolczyk 18:24 09/10/19 Fund: 137 MUD 1 Consolidated GASB Account 137-49145-000-000 Description Intergov Transfer -General Fund Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 8/2019 Amended Total Current YTD Budget Encumb. Month Total 105,000.00- % of Remaining Budget Budget 105,000.00 Page 13 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 18:24 09/10/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 137-69195-010-000 Subtotal: Program number: Department number: Expenditures GASB Replacement Water Subtotal Fund number: 137 MUD 1 Consolidated GASB 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 80,193.00 266,613.00- 266,613.00- 266,613.00- 266,613.00- 266,613.00- 80,193.00- glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2019 JE Detail Description/Comment Page 5 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1997 08/07/2019 Property Taxes 2041 08/07/2019 Property Taxes- Dep Chg JE1997 Fix Denton Dep Levy not I&S 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2002 08/16/2019 Property Taxes 2003 08/19/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes (125,246.10) (30.34) (125,276.44) (69.60) (125,346.04) (178.64) (125,524.68) (.76) (125,525.44) (4.66) (125,530.10) (25.15) (125,555.25) (1.08) (125,556.33) (12.22) (125,568.55) (7.04) (125,575.59) .50 (125,575.09) 3.41 (125,571.68) (.89) (125,572.57) (11.16) (125,583.73) (5.01) (125,588.74) GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (342.64) (125,588.74) ** (132,384.00) Budgeted (6,795.26) Remaining 95 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2003 08/19/2019 Property Taxes 2005 08/27/2019 Property Taxes 2007 08/30/2019 Property Taxes 322.64 7.96 (.06) (1.21) 330.60 330.54 329.33 GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 6.69 329.33 ** (300.00) Budgeted (629.33) Remaining -110 % Used Account: 135-40015-000-000 Property Taxes/P & I 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes 2007 08/30/2019 Property Taxes (511.81) (1.05) (1.33) (32.71) (.10) (.17) (1.95) (1.12) (.12) (.20) (1.84) (.38) (512.86) (514.19) (546.90) (547.00) (547.17) (549.12) (550.24) (550.36) (550.56) (552.40) (552.78) GL GL GL GL GL GL GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (40.97) (552.78) ** (300.00) Budgeted 252.78 Remaining 184 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 6 Check Source Number 1869 08/08/2019 UB 08/08/2019 Penalty removal 1929 08/21/2019 UB 08/21/2019 Penalties 1947 08/26/2019 UB 08/26/2019 Penalty removal 1954 08/28/2019 UB 08/28/2019 Penalty removal 1962 08/30/2019 UB 08/30/2019 Penalty removal UB20190808-20190808 User: UB20190821-20190821 User: UB20190826-20190826 User: UB20190828-20190828 User: UB20190830-20190830 User: (78,957.91) 12.31 (10,017.53) 304.05 153.06 63.81 (78,945.60) (88,963.13) (88,659.08) (88,506.02) (88,442.21) UB UB UB UB UB Account: 135-47025-000-000 Penalties Totals: (9,484.30) (88,442.21) ** Account: 135-40025-000-000 PID Surcharges (136,418.00) Budgeted (47,975.79) Remaining 65 % Used .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** 1859 08/07/2019 UB 08/07/2019 Disconnect Fees UB20190807-20190807 User: (13,050.00) 1927 08/20/2019 UB 08/20/2019 NSF Checks UB20190820-20190820 User: (171,983.00) Budgeted (171,983.00) Remaining 0 % Used (14,300.00) (14,350.00) UB UB Account: 135-47000-000-000 Water (1,300.00) ' (14,350.00) ** 1975 08/31/2019 UB 08/31/2019 Billing UB20190831-20190831 User: (17,000.00) Budgeted (2,650.00) Remaining 84 % Used UB (3,570,646.57) (824,263.75) (4,394,910.32) 135-47035-000-000 Plumbing Inspections Account: 135-47000-000-000 Water Totals: (824,263.75) (4,394,910.32) ** 1978 08/02/2019 Byron APts-permits 90 TC DR-apts (1,150.00) (6,599,484.00) Budgeted (2,204,573.68) Remaining 67 % Used (1,300.00) NAP Trophy Club, LP Account: 135-47005-000-000 Sewer 1895 08/15/2019 UB 08/15/2019 WA adjustment UB20190815-20190815 User: (2,543,194.81) 1975 08/31/2019 UB 08/31/2019 Billing UB20190831-20190831 User: 256.23 (268,189.86) (2,542,938.58) (2,811,128.44) UB UB Account: 135-47005-000-000 Sewer Totals: (267,933.63) (2,811,128.44) ** (3,412,665.00) Budgeted (601,536.56) Remaining 82 % Used Account: 135-47025-000-000 Penalties 1869 08/08/2019 UB 08/08/2019 Penalty removal 1929 08/21/2019 UB 08/21/2019 Penalties 1947 08/26/2019 UB 08/26/2019 Penalty removal 1954 08/28/2019 UB 08/28/2019 Penalty removal 1962 08/30/2019 UB 08/30/2019 Penalty removal UB20190808-20190808 User: UB20190821-20190821 User: UB20190826-20190826 User: UB20190828-20190828 User: UB20190830-20190830 User: (78,957.91) 12.31 (10,017.53) 304.05 153.06 63.81 (78,945.60) (88,963.13) (88,659.08) (88,506.02) (88,442.21) UB UB UB UB UB Account: 135-47025-000-000 Penalties Totals: (9,484.30) (88,442.21) ** (136,418.00) Budgeted (47,975.79) Remaining 65 % Used Account: 135-47030-000-000 Service Charges 1 F 1859 08/07/2019 UB 08/07/2019 Disconnect Fees UB20190807-20190807 User: (13,050.00) 1927 08/20/2019 UB 08/20/2019 NSF Checks UB20190820-20190820 User: (1,250.00) (50.00) (14,300.00) (14,350.00) UB UB Account: 135-47030-000-000 Service Charges Totals: (1,300.00) ' (14,350.00) ** (17,000.00) Budgeted (2,650.00) Remaining 84 % Used Account: 135-47035-000-000 Plumbing Inspections 1978 08/02/2019 Byron APts-permits 90 TC DR-apts (1,150.00) (150.00) (1,300.00) NAP Trophy Club, LP CR glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2019 JE Detail Description/Comment 1978 08/02/2019 Byron APts-permits 90 TC Dr-apts & irrig Page 7 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,150.00) (450.00) (1,750.00) NAP Trophy Club, LP CR Account: 135-47035-000-000 Plumbing Inspections Totals: (600.00) (1,750.00) ** (1,500.00) Budgeted 250.00 Remaining 117 % Used Account: 135-47045-000-000 Sewer Inspections 1978 08/02/2019 Byron APts-permits 99 TC Drive-Apts (3,450.00) 1978 08/02/2019 Byron APts-permits 90 TC Dr-apts (50.00) (3,500.00) NAP Trophy Club, LP CR (100.00) (3,600.00) NAP Trophy Club, LP CR Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (3,600.00) ** (4,500.00) Budgeted (900.00) Remaining 80 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1975 08/31/2019 UB 08/31/2019 Billing UB20190831-20190831 User: (19,685.60) (20,907.20) (40,592.80) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (20,907.20) (40,592.80) ** (60,000.00) Budgeted (19,407.20) Remaining 68 % Used Account: 135-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August 1976 08/31/2019 Bank Interest- August 1976 08/31/2019 Bank Interest- August (113,447.48) (935.33) (114,382.81) GL (1,267.02) (115,649.83) GL (11,139.62) (126,789.45) GL Account: 135-49011-000-000 Interest Income Totals: (13,341.97) (126,789.45) ** (80,000.00) Budgeted 46,789.45 Remaining 158 % Used Account: 135-49016-000-000 Cell Tower Revenue 1967 08/29/2019 Cell Tower Rev AT&T August (12,114.77) (1,178.81) (13,293.58) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (13,293.58) ** (14,146.00) Budgeted (852.42) Remaining 94 % Used Account: 135-49018-000-000 Building Rent Income 2030 08/31/2019 Town Bllled Invoices 1702-1705 AR 20190831-20190831 User: (5,833.30) (583.33) (6,416.63) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2019 JE Detail Description/Comment Page 8 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-000 Proceeds from Sale of Assets Account: 135-49026-000-000 (52,600.00) Proceeds from Sale of Assets Totals: (55,000.00) Budgeted (2,400.00) Remaining 96 % Used IL _Mk .00 (52,600.00) .00 (52,600.00) ** Account: 135-49035-000-000 Prior Year Reserves Account: 135-49035-000-000 Account: 135-49036-000-000 Account: 135-49036-000-000 Account: 135-49075-000-000 1978 08/02/2019 Byron APts-permits 1978 08/02/2019 Byron APts-permits Prior Year Reserves Totals: (358,600.00) Budgeted GASB Reserves GASH Reserves (266,613.00) Budgeted (358,600.00) Remaining Oversize Meter Reimbursement 99 TC Drive-Apts 90 TC Dr-apts (266,613.00) Totals: .00 Remaining Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (18,522.00) Budgeted (6,954.00) Remaining Account: 135-49141-000-000 Interfund Transfer In .00 0 5 Used .00 .00 .00 ** .00 (266,613.00) 100 % Used (8,232.00) .00 (266,613.00) ** (834.00) (9,066.00) NAP Trophy Club, LP (2,502.00) (11,568.00) NAP Trophy Club, LP CR CR (3,336.00) (11,568.00) ** 62 % Used (25,000.00) .00 (25,000.00) Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (25,000.00) ** Account: 135-49900-000-000 1978 08/02/2019 Byron APts-permits 1975 08/31/2019 UB 08/31/2019 Billing .00 Budgeted 25,000.00 Remaining 0 % Used Miscellaneous Income 90 TC Dr-apts UB20190831-20190831 User: (32,383.27) (4,764.50) (37,147.77) NAP Trophy Club, LP CR (203.11) (37,350.88) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (4,967.61) (37,350.88) ** (7,000.00) Budgeted 30,350.88 Remaining 534 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 8/2019 JE Detail Description/Comment Page 9 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-49901-000-000 Records Management Revenue (4.00) .00 (4.00) Account: 135-49901-000-000 Records Management Revenue Totals: .00 (4.00) ** Department Totals: .00 Budgeted 4.00 Remaining 0 % Used (8,020,221.50) ** (1,148,423.52) Monthly Total (11,343,415.00) Budgeted (3,323,193.50) Remaining 71 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-50005-010-000 Salaries & Wages 1823 08/09/2019 MUD Payroll 08/09/19 Salaries & Wages 1918 08/23/2019 MUD Payroll 08/23/2019 Salaries & Wages Account: 135-50005-010-000 245,931.86 11,979.42 11,943.27 257,911.28 PR 269,854.55 PR Salaries & Wages Totals: 23,922.69 269,854.55 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 1823 08/09/2019 MUD Payroll 08/09/19 Overtime 1918 08/23/2019 MUD Payroll 08/23/2019 Overtime Account: 135-50010-010-000 56,900.45 Remaining 83 % Used 9,930.62 435.71 10,366.33 PR 621.29 10,987.62 PR Overtime Totals: 1,057.00 10,987.62 ** 20,000.00 Budgeted 9,012.38 Remaining 55 % Used Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Longevity Totals: 3,620.00 Budgeted .00 Remaining Account: 135-50017-010-000 _ Certification 1918 08/23/2019 MUD Payroll 08/23/2019 Certification Account: 135-50017-010-000 Certification Totals: 4,800.00 Budgeted Account: 135-50020-010-000 Retirement 1823 08/09/2019 MUD Payroll 08/09/19 Retirement 1918 08/23/2019 MUD Payroll 08/23/2019 Retirement 3,620.00 100 % Used 1,800.00 2,875.00 Remaining 40 % Used 25,219.94 .00 3,620.00 .00 3,620.00 ** 125.00 1,925.00 125.00 1,925.00 ** 1,148.41 26,368.35 1,173.78 27,542.13 PR PR PR Account: 135-50020-010-000 Retirement Totals: 2,322.19 27,542.13 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Medical Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Medical Insurance Account: 135-50026-010-000 5,761.87 Remaining 83 % Used 38,384.16 2,109.86 40,494.02 2,109.82 42,603.84 Medical Insurance Totals: 4,219.68 42,603.84 ** 74,818.00 Budgeted 32,214.16 Remaining 57 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-50027-010-000 Dental Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Dental Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Dental Insurance Account: 135-50027-010-000 Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Vision Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Vision Insurance 2,471.80 1,583.65 Remaining 63 % Used 405.05 130.80 2,602.60 130.75 2,733.35 5 2,733.35 ** 21.25 426.30 21.22 447.52 PR PR PR PR Account: 135-50028-010-000 1 Vision Insurance Totals: 42.47 447.52 ** Account: 135-50029-010-000 1765 08/01/2019 August A/P 1765 08/01/2019 August A/P 1963 08/30/2019 August A/P 701.00 Budgeted 253.48 Remaining 64 % Used Life Insurance & Other Employee Benefits -July Employee LTD & STD -July Caf 125 2,134.46 98.56 2,233.02 Humana Inc 91.11 2,324.13 METLIFE GROUP BENEFITS 20.00 2,344.13 BenefitMall 5545 AP 5552 AP 5654 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 209.67 2,344.13 ** 3,131.00 Budgeted 786.87 Remaining 75 6 Used Account: 135-50030-010-000 Social Security Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Social Security Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 Medicare Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Medicare Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Medicare Taxes 15,769.23 4,760.39 Remaining 78 6 Used 3,687.97 739.89 751.49 1,491.38 16,509.12 17,260.61 17,260.61 ** 173.03 3,861.00 175.74 4,036.74 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 348.77 4,036.74 ** 5,150.00 Budgeted 1,113.26 Remaining 78 % Used Account: 135-50040-010-000 Unemployment Taxes 46.80 .00 46.80 glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-000 Workman's Compensation 135 08/01/2019 Insurance/Wrk Comp Expense Aug Account: 135-50045-010-000 Account: 135-50060-010-000 Account: 135-50060-010-000 Workman's Compensation 12,895.00 Budgeted Pre-emp Physicals/Testing Totals: 1,033.20 Remaining Totals: 2,925.26 Remaining Pre-emp Physicals/Testing Totals: 200.00 Budgeted Account: 135-50070-010-000 Employee Relations 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 jordan jones plant Account: 135-50070-010-000 Account: 135-55005-010-000 Account: 135-55005-010-000 Account: 135-55080-010-000 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 1902 08/16/2019 August A?P 1921 08/20/2019 August A?P 2023 08/26/2019 PCard 7/27/2019 2018 08/31/2019 August A/P Account: 135-55080-010-000 Employee Relations 300.00 Budgeted Engineering Engineering 20,000.00 Budgeted (2.45) Remaining Totals: 226.41 Remaining Totals: 20,000.00 Remaining Maintenance & Repairs 6" valves oxygen for torch chlorine sensor emergency valve replacements - 8/26/2019 memory card case parts Maintenance & Repairs 153,000.00 Budgeted 9,038.80 202.45 Program: Transaction Detail 4 % Used 77 % Used 101 5 Used 111,535.51 25 % Used 0 % Used .00 930.94 930.94 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 46.80 ** 9,969.74 9,969.74 ** 202.45 202.45 ** 73.59 73.59 1-800-FLOWERS.COM,INC. 73.59 .00 .00 73.59 ** .00 .00 ** 970.00 112,505.51 37.00 112,542.51 800.00 113,342.51 17,622.13 130,964.64 7.59 130,972.23 680.00 131,652.23 Totals: 21,347.77 Remaining 86 o Used 20,116.72 ATLAS UTILITY SUPPLY CO. ALLIED WELDING SUPPLY, INC Macaulay Controls Company REY-MAR CONSTRUCTION AMEN MKTP US*M08EK71D1 Core & Main LP 131,652.23 ** Page 12 Check Source Number GL PC 5612 AP 5611 AP 5628 AP 5645 AP PC 5689 AP glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-55085-010-000 Account: 135-55085-010-000 Account: 135-55090-010-000 - 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 1963 08/30/2019 August A/P Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Account: 135-55120-010-000 Account: 135-55120-010-000 Account: 135-55135-010-000 1901 08/16/2019 August A/P Account: 135-55135-010-000 Account: 135-60010-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Generator Maint. and Repair Generator Maint. and Repair Totals: 3,000.00 Budgeted 1,093.70 Remaining _ Vehicle - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 Maintenance oil change Oil Change Oil Change Oil Change Windshield Wash and clamp Vac Truck maintenance Vehicle Maintenance 5,000.00 Budgeted Totals: 543.87 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining Cleaning Services Cleaning Services 5,214.00 Budgeted Lab Analysis water samples Lab Analysis 6,500.00 Budgeted Communications/Mobiles 1901 08/16/2019 August A/P Cell phones -August Totals: 5,214.00 Remaining Totals: (996.62) Remaining 1,906.30 3,210.54 64 % Used 89 % Used O % Used O % Used Program: Transaction Detail 1 .00 .00 69.37 81.56 74.91 69.37 44.43 905.95 1,245.59 .00 .00 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 1,906.30 1,906.30 ** 3,279.91 3,361.47 3,436.38 3,505.75 3,550.18 4,456.13 KWIK KAR LUBE & TUNE 0 KWIK KAR LUBE & TUNE 0 GIERISCH CARE 0050292 KWIK KAR LUBE & TUNE 0 ROANOKE AUTO SUPPLY LT CLS SEWER EQUIPMENT CO., INC 4,456.13 ** .00 .00 ** .00 .00 ** Page 13 Check Source Number PC PC PC PC PC 5657 AP 7,176.62 320.00 7,496.62 TARRANT CTY PUBLIC HEALTH LAB 5635 AP 320.00 115 5 Used 7,496.62 ** 3,095.46 337.69 3,433.15 VERIZON WIRELESS 5641 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60010-010-000 Communications/Mobiles Totals: 337.69 3,433.15 ** 5,000.00 Budgeted 1,566.85 Remaining 69 % Used Account: 135-60020-010-000 Electricity 1901 08/16/2019 August A/P Electricity 7/10-8/8 86,145.65 12,255.73 98,401.38 HUDSON ENERGY SERVICES, LLC 5622 AP Account: 135-60020-010-000 Electricity Totals: 12,255.73 98,401.38 ** 154,204.00 Budgeted 55,802.62 Remaining 64 6 Used Account: 135-60066-010-000 Publications/Books/Subscripts 790.00 .00 790.00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 790.00 ** 1,000.00 Budgeted 210.00 Remaining 79 o Used Account: 135-60070-010-000 Dues & Memberships Account: 135-60070-010-000 Account: 135-60080-010-000 Account: 135-60080-010-000 122.00 .00 122.00 Dues & Memberships Totals: .00 122.00 ** 500.00 Budgeted 378.00 Remaining 24 6 Used Schools & Training 3,556.01 .00 3,556.01 Schools & Training Totals: .00 3,556.01 ** 4,651.00 Budgeted 1,094.99 Remaining 76 % Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 o Used Account: 135-60100-010-000 Travel & per diem 678.98 .00 678.98 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60100-010-000 Travel & per diem Totals: .00 678.98 ** 2,345.00 Budgeted 1,666.02 Remaining 29 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1901 08/16/2019 August A/P well water 16,336.53 4,747.10 21,083.63 North Texas Groundwater 5631 AP Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,747.10 21,083.63 ** 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 1963 08/30/2019 August A/P water -July Account: 135-60150-010-000 36,916.37 Remaining 36 o Used 1,200,444.80 273,886.01 1,474,330.81 CITY OF FORT WORTH Wholesale Water Totals: 273,886.01 1,474,330.81 ** 3,013,494.00 Budgeted 1,539,163.19 Remaining 49 % Used 5656 AP Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 Miscellaneous Expenses Totals: 200.00 Budgeted 200.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60280-010-000 Property Maintenance Account: 135-60280-010-000 Property Maintenance Totals: 3,000.00 Budgeted 612.00 2,388.00 Remaining 20 % Used .00 612.00 .00 612.00 ** Account: 135-60285-010-000 Lawn Equipment & Maintenance 6,590.00 .00 6,590.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60285-010-000 Lawn Equipment & Maintenance Totals: .00 6,590.00 ** 14,750.00 Budgeted 8,160.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev IBS 1939 08/23/2019 TexPool Transfers August TexPool O&M to 16Swift Rev I&S 45 % Used 251,728.10 25,172.90 276,901.00 GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 308,308.00 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1939 08/23/2019 TexPool Transfers August TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 4,593.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 25,172.90 276,901.00 ** 47 % Used 46,000.00 4,600.00 50,600.00 GL 92 o Used 4,600.00 50,600.00 ** .00 .00 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65005-010-000 Fuel & Lube 1950 08/24/2019 Fuel Fuel -June Account: 135-65005-010-000 0 9 Used .00 .00 .00 .00 ** 0 6 Used 8,566.02 908.45 9,474.47 US Bank Voyager Fleet Systems 5673 AP Fuel & Lube Totals: 908.45 9,474.47 ** 15,000.00 Budgeted Account: 135-65010-010-000 Uniforms 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 Jeans 5,525.53 Remaining 63 % Used 2,070.81 147.96 2,218.77 CAVENDERS.COM 600 PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-65010-010-000 Uniforms Totals: 147.96 2,218.77 ** 5,190.00 Budgeted 2,971.23 Remaining 43 % Used Account: 135-65030-010-000 1 Chemicals 1963 08/30/2019 August A/P testing supplies 1963 08/30/2019 August A/P SL1000 calibration 1963 08/30/2019 August A/P chlorine 18,554.88 625.58 684.75 1,116.81 19,180.46 HACH COMPANY 19,865.21 HACH COMPANY 20,982.02 DPC INDUSTRIES, INC 5660 AP 5660 AP 5659 AP Account: 135-65030-010-000 1 Chemicals Totals: 2,427.14 20,982.02 ** 20,000.00 Budgeted (982.02) Remaining 105 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 641.25 .00 641.25 Account: 135-65040-010-000 Safety Equipment Totals: .00 641.25 ** 1,000.00 Budgeted 358.75 Remaining 64 % Used Account: 135-65050-010-000 Meter Expense 1864 08/07/2019 August A/P 1963 08/30/2019 August A/P meters 17,861.60 8,100.50 25,962.10 ATLAS UTILITY SUPPLY CO. 5589 AP meters 28,826.50 54,788.60 ATLAS UTILITY SUPPLY CO. 5653 AP Account: 135-65050-010-000 Meter Expense Totals: 36,927.00 54,788.60 ** 70,000.00 Budgeted 15,211.40 Remaining 78 % Used Account: 135-65053-010-000 Meter Change Out Program 86,949.00 .00 86,949.00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 86,949.00 ** 87,000.00 Budgeted 51.00 Remaining 100 % Used Account: 135-69005-010-000 Capital Outlays glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description 1853 08/06/2019 August A/P 1864 08/07/2019 August A/P 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 1921 08/20/2019 August A?P 1930 08/21/2019 August A/P 1963 08/30/2019 August A/P 1963 08/30/2019 August A/P 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj Account: 135-69005-010-000 Account: 135-69008-010-000 Account: 135-69008-010-000 Account: 135-69009-010-000 1736 08/01/2019 August A/P Account: 135-69009-010-000 Account: 135-69195-010-000 Account: 135-69195-010-000 Dep/Fund Clean-up Dep/Fund Clean-up Dep/Fund Clean-up Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment 1/2 draw for fence staining Carnoustie-north fence staining straight creek ct & carnoustie Waterline Replacements Sundance Ct waterline Sundance court VFD upgrade Pcard- Denton County 3/26/19 Pcard- Star Tel Bond Note 3/26 PCard Denton Rec Cho Bond 3/26 624,503.90 Capital Outlays Totals: 719,613.00 Budgeted (303,563.18) Remaining Short Term Debt -Principal Short Term Debt -Principal 30,068.00 Budgeted Short Term Debt -Interest interest Vac truck 142 % Used 30,068.00 Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 16,500.00 641,003.90 74,210.00 715,213.90 16,500.00 731,713.90 1,238.87 732,952.77 55,106.00 788,058.77 5,400.00 793,458.77 2,000.00 795,458.77 229,669.20 1,025,127.97 (1.00) 1,025,126.97 (1,874.19) 1,023,252.78 (76.60) 1,023,176.18 Alliance Fence Company REY-MAR CONSTRUCTION Alliance Fence Company Halff Associates, INC REY-MAR CONSTRUCTION Jackson Construction, LTD TEAGUE, NALL & PERKINS, INC REY-MAR CONSTRUCTION 398,672.28 1,023,176.18 ** .00 Totals: .00 Remaining 100 % Used Short Term Debt -Interest 4,124.00 Budgeted (.36) Remaining Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 2,283.93 100 % Used 75,000.00 .00 1,840.43 1,840.43 .00 100 % Used .00 30,068.00 30,068.00 ** 4,124.36 FIRST FINANCIAL BANK 4,124.36 ** 75,000.00 75,000.00 ** Page 18 Check Source Number 5588 AP 5606 AP 5610 AP 5620 AP 5645 AP 5648 AP 5672 AP 5670 AP GL GL GL 5535 AP Account: 135-69281-010-000 Water Tank Inspection Contract Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 20,122.89 Remaining 99,877.11 .00 83 % Used .00 99,877.11 99,877.11 ** glpdatb2 skrolczyk 18:24 09/10/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: 8/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 1901 08/16/2019 August A/P water samples 1,351.59 80.00 1,431.59 TARRANT CTY PUBLIC HEALTH LAB 5635 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,431.59 ** 2,000.00 Budgeted 568.41 Remaining 72 % Used Department 10 Totals: 3,884,989.66 ** 818,689.93 Monthly Total 5,961,447.00 Budgeted 2,076,457.34 Remaining 65 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50005-020-000 Salaries & Wages 1823 08/09/2019 MUD Payroll 08/09/19 Salaries & Wages 1918 08/23/2019 MUD Payroll 08/23/2019 Salaries & Wages Account: 135-50005-020-000 279,694.57 13,420.82 13,359.20 293,115.39 PR 306,474.59 PR Salaries & Wages Totals: 26,780.02 306,474.59 ** 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 1823 08/09/2019 MUD Payroll 08/09/19 Overtime 1918 08/23/2019 MUD Payroll 08/23/2019 Overtime Account: 135-50010-020-000 115,224.41 Remaining 73 % Used 29,602.23 599.55 30,201.78 PR 823.90 31,025.68 PR 11111 Overtime Totals: 1,423.45 31,025.68 ** 30,000.00 Budgeted Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity Totals: 7,445.00 Budgeted .00 Remaining (1,025.68) Remaining 103 % Used Account: 135-50017-020-000 _ Certification 1918 08/23/2019 MUD Payroll 08/23/2019 Certification Account: 135-50017-020-000 7,445.00 100 % Used 7,125.00 Certification Totals: 8,700.00 Budgeted 850.00 Remaining 90 % Used Account: 135-50020-020-000 Retirement 1823 08/09/2019 MUD Payroll 08/09/19 Retirement 1918 08/23/2019 MUD Payroll 08/23/2019 Retirement 31,474.36 .00 7,445.00 .00 7,445.00 ** 725.00 7,850.00 725.00 7,850.00 ** 1,296.90 32,771.26 1,378.99 34,150.25 PR PR PR Account: 135-50020-020-000 Retirement Totals: 2,675.89 34,150.25 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Medical Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Medical Insurance Account: 135-50026-020-000 9,125.75 Remaining 79 % Used 55,060.34 2,794.26 57,854.60 2,794.22 60,648.82 Medical Insurance Totals: 5,588.48 60,648.82 ** 91,627.00 Budgeted 30,978.18 Remaining 66 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50027-020-000 Dental Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Dental Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Dental Insurance Account: 135-50027-020-000 3,499.59 170.29 3,669.88 PR 170.27 3,840.15 PR Dental Insurance Totals: 340.56 3,840.15 ** 5,104.00 Budgeted Account: 135-50028-020-000 _ Vision Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Vision Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Vision Insurance Account: 135-50028-020-000 Account: 135-50029-020-000 1765 08/01/2019 August A/P 1765 08/01/2019 August A/P 1963 08/30/2019 August A/P 1 1,263.85 Remaining 75 % Used Vision Insurance Totals: 826.00 Budgeted 566.18 27.83 594.01 PR 27.81 621.82 PR 204.18 Remaining 75 % Used Life Insurance & Other Employee Benefits -July Employee LTD & STD -July Caf 125 55.64 621.82 ** 3,292.15 184.80 3,476.95 Humana Inc 162.14 3,639.09 METLIFE GROUP BENEFITS 38.00 3,677.09 BenefitMall 5545 AP 5552 AP 5654 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 384.94 3,677.09 ** 4,495.00 Budgeted 817.91 Remaining 82 % Used Account: 135-50030-020-000 Social Security Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Social Security Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Social Security Taxes Account: 135-50030-020-000 Social Security Taxes Totals: 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Medicare Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Medicare Taxes 18,954.89 8,363.31 Remaining 71 % Used 4,433.01 829.74 858.06 1,687.80 19,784.63 20,642.69 20,642.69 ** 194.04 4,627.05 200.68 4,827.73 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals:394.72 4,827.73 ** 6,784.00 Budgeted 1,956.27 Remaining 71 % Used Account: 135-50040-020-000 Unemployment Taxes 54.00 .00 54.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50040-020-000 Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 1,206.00 Remaining 4 % Used .00 54.00 ** 135 08/01/2019 Insurance/Wrk Comp Expense Aug 11,707.50 1,205.73 12,913.23 Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 12,913.23 ** 16,941.00 Budgeted 4,027.77 Remaining 76 5 Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 114.00 .00 114.00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 114.00 ** Account: 135-50070-020-000 Account: 135-50070-020-000 400.00 Budgeted 286.00 Remaining Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 29 5 Used 75.74 224.26 Remaining 25 % Used Engineering Totals: 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135-55080-020-000 1864 08/07/2019 August A/P 1864 08/07/2019 August A/P 30,000.00 Remaining 0 5 Used Independent Labor Totals: 15,000.00 Budgeted Maintenance & Repairs LS #9/Belt press LS #9/Belt press 2,921.00 12,079.00 Remaining 19 o Used 110,241.73 .00 75.74 .00 75.74 ** .00 .00 .00 .00 ** .00 2,921.00 .00 2,921.00 ** 620.00 110,861.73 DHS AUTOMATION, INC 620.00 111,481.73 DHS AUTOMATION, INC GL 5595 AP 5595 AP glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description 1864 08/07/2019 August A/P 1901 08/16/2019 August A/P 1902 08/16/2019 August A?P 1902 08/16/2019 August A?P 1921 08/20/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 August A?P PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 PCard 7/27/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment White oil Elelictrical work VFD for press Filters for PA & MER meter for VFD on press fan, wire connector adapters, valves memory card pipe, valves, adapters coupling and tee paints and equipment Hydrant fitting, nipple, valve pea gravel, rubber hose Steel Nipples, reducer hose clamps alcohol, selant, brush Phase monitor for L/S 9 110,241.73 Program: Transaction Detail 190.86 3,310.00 741.82 324.03 558.33 117.75 128.06 34.47 88.87 74.16 49.28 130.10 77.94 12.45 12.90 72.49 748.36 Transaction Vendor_Name Detail (SUBTOTAL) 111,672.59 114,982.59 115,724.41 116,048.44 116,606.77 116,724.52 116,852.58 116,887.05 116,975.92 117,050.08 117,099.36 117,229.46 117,307.40 117,319.85 117,332.75 117,405.24 118,153.60 LUBRICATION ENGINEERS, INC DHS AUTOMATION, INC Precision Pump Systems Filter Element Store Precision Pump Systems THE HOME DEPOT #6581 ROANOKE WINNELSON CO AMAZON.COM*MA2PX6ZH0 THE HOME DEPOT 6581 THE HOME DEPOT #6581 THE HOME DEPOT #6581 ROANOKE WINNELSON CO THE HOME DEPOT #6581 ROANOKE WINNELSON CO ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 XYLEM WTR SOLN USA INC Page 23 Check Source Number 5601 5616 5632 5619 5644 AP AP AP AP AP PC PC PC PC PC PC PC PC PC PC PC PC Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,911.87 118,153.60 ** 133,000.00 Budgeted 14,846.40 Remaining 89 % Used Account: 135-55085-020-000 Generator Maint. and Repair 5,451.63 .00 5,451.63 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 5,451.63 ** 10,000.00 Budgeted 4,548.37 Remaining 55 o Used Account: 135-55090-020-000 Vehicle Maintenance 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 Blue Def - 8/26/2019 car wash supplies 1,692.74 24.94 46.02 1,717.68 1,763.70 THE HOME DEPOT #6581 THE HOME DEPOT #6581 PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 70.96 1,763.70 ** 8,000.00 Budgeted 6,236.30 Remaining 22 o Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1901 08/16/2019 August A/P 2023 08/26/2019 PCard 7/27/2019 parts/Labor track hoe repairs - 8/26/2019 tire 6,803.00 856.24 265.66 7,659.24 7,924.90 HOLT CAT BLAGGS TIRE WHOLESALE 5621 AP PC Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 1,121.90 7,924.90 ** 7,000.00 Budgeted (924.90) Remaining 113 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-55120-020-000 Cleaning Services 1932 08/22/2019 August A/P Janitorial svcs 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5649 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 87.50 ** 5,214.00 Budgeted 5,126.50 Remaining 2 % Used Account: 135-55125-020-000 Dumpster Services 1901 08/16/2019 August A/P contractor materials 1901 08/16/2019 August A/P sludge haul off 1921 08/20/2019 August A?P sludge/grit 2016 08/31/2019 August A/P sludge/grit 59,619.84 1,250.00 845.00 864.86 867.82 60,869.84 L.H. CHANEY MATERIALS, INC. 61,714.84 L.H. CHANEY MATERIALS, INC. 62,579.70 L.H. CHANEY MATERIALS, INC. 63,447.52 L.H. CHANEY MATERIALS, INC. 5626 AP 5626 AP 5643 AP 5693 AP Account: 135-55125-020-000 Dumpster Services Totals: 3,827.68 63,447.52 ** 75,000.00 Budgeted 11,552.48 Remaining 85 6 Used Account: 135-55135-020-000 Lab Analysis 1864 08/07/2019 August A/P lab testing 1864 08/07/2019 August A/P lab testing 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 fish in contact basin 1963 08/30/2019 August A/P lab testing 1963 08/30/2019 August A/P lab testing 1963 08/30/2019 August A/P lab testing 1963 08/30/2019 August A/P lab testing 1963 08/30/2019 August A/P lab testing 1963 08/30/2019 August A/P lab testing 27,869.21 317.40 28,186.61 OXIDOR LABORATORIES LLC 5605 AP 230.00 28,416.61 OXIDOR LABORATORIES LLC 5605 AP 25.96 28,442.57 PETSMART #3023 PC 317.40 28,759.97 OXIDOR LABORATORIES LLC 5669 AP 230.00 28,989.97 OXIDOR LABORATORIES LLC 5669 AP 317.40 29,307.37 OXIDOR LABORATORIES LLC 5669 AP 230.00 29,537.37 OXIDOR LABORATORIES LLC 5669 AP 317.40 29,854.77 OXIDOR LABORATORIES LLC 5669 AP 230.00 30,084.77 OXIDOR LABORATORIES LLC 5669 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,215.56 30,084.77 ** 35,000.00 Budgeted 4,915.23 Remaining 86 % Used Account: 135-60010-020-000 Communications/Mobiles 1901 08/16/2019 August A/P Cell phones -August 4,182.20 372.26 4,554.46 VERIZON WIRELESS 5641 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 372.26 4,554.46 ** 5,000.00 Budgeted 445.54 Remaining 91 6 Used Account: 135-60020-020-000 Electricity 1901 08/16/2019 August A/P Electricity 7/10-8/8 1901 08/16/2019 August A/P electricity 6/28-7/30 2030 08/31/2019 Town Bllled Invoices 1702-1705 AR 20190831-20190831 User: 122,624.98 11,331.34 133,956.32 HUDSON ENERGY SERVICES, LLC 5622 AP 511.08 134,467.40 TRI COUNTY ELECTRIC 5639 AP (179.33) 134,288.07 AR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60020-020-000 Electricity Totals: 11,663.09 134,288.07 ** 174,165.00 Budgeted 39,876.93 Remaining 77 % 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 6 Used Account: 135-60070-020-000 Dues & Memberships 191.00 .00 191.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 191.00 ** 300.00 Budgeted 109.00 Remaining 64 % Used Account: 135-60080-020-000 Schools & Training 1,658.23 .00 1,658.23 Totals: .00 1,658.23 5,496.77 Remaining 23 % Used 100.74 .00 100.74 Account: 135-60090-020-000 Safety Program Totals: .00 Account: 135-60080-020-000 Schools & Training ** 7,155.00 Budgeted Account: 135-60090-020-000 Safety Program 1,000.00 Budgeted Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 899.26 Remaining 10 6 Used 544.55 .00 Travel & per diem Totals: .00 1,895.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment 1,350.45 Remaining 29 % Used 3,491.07 100.74 ** 544.55 544.55 ** .00 3,491.07 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60105-020-000 Rent/Lease Equipment Totals: 5,000.00 Budgeted Account: 135-60125-020-000 Advertising Account: 135-60125-020-000 1,508.93 Remaining 70 % Used Advertising Totals: 2,500.00 Budgeted Account: 135-60135-020-000 TCEQ Fees & Permits Account: 135-60135-020-000 2,500.00 Remaining 0 % Used TCEQ Fees & Permits Totals: 30,000.00 Budgeted Account: 135-60245-020-000 Miscellaneous Expenses Account: 135-60245-020-000 16,545.22 13,454.78 Remaining 55 o Used .00 3,491.07 ** .00 .00 .00 .00 ** .00 16,545.22 .00 16,545.22 ** 4.00 .00 4.00 Miscellaneous Expenses Totals: .00 4.00 ** 450.00 Budgeted Account: 135-60280-020-000 Property Maintenance Account: 135-60280-020-000 446.00 Remaining 1 % Used 225.18 .00 225.18 Property Maintenance Totals: .00 225.18 ** 5,000.00 Budgeted 4,774.82 Remaining 5 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 5,639.47 .00 5,639.47 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 5,639.47 ** 11,600.00 Budgeted 5,960.53 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1939 08/23/2019 TexPool Transfers August TexPool O&M to I&S- PID Debt 49 % Used 109,139.00 10,914.00 120,053.00 GL glpdatb2 skrolczyk 18:24 09/10/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: 8/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 27 Check Source Number Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS Totals: 10,914.00 120,053.00 ** 120,053.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev ISS 1939 08/23/2019 TexPool Transfers August TexPool O&M to Rev Bd WWTP ISS 542,034.50 54,203.50 596,238.00 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev ISS Totals: 54,203.50 596,238.00 ** 688,330.00 Budgeted 92,092.00 Remaining 87 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1939 08/23/2019 TexPool Transfers August TexPool O&M to Rev Bond Resevr 104,320.00 10,432.00 114,752.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 114,752.00 ** 125,187.00 Budgeted 10,435.00 Remaining 92 o Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 791.00 .00 791.00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 791.00 ** 3,500.00 Budgeted 2,709.00 Remaining 23 5 Used Account: 135-65005-020-000 Fuel & Lube 1950 08/24/2019 Fuel Fuel -June 10,776.36 937.07 11,713.43 US Bank Voyager Fleet Systems 5673 AP Account: 135-65005-020-000 Fuel & Lube Totals: 937.07 11,713.43 ** 12,500.00 Budgeted 786.57 Remaining 94 5 Used Account: 135-65010-020-000 Uniforms 2,713.30 .00 2,713.30 glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 28 Check Source Number Account: 135-65010-020-000 Uniforms Totals: .00 2,713.30 ** Account: 135-65030-020-000 1901 08/16/2019 August A/P 1964 08/30/2019 August A/P 5,495.00 Budgeted 2,781.70 Remaining Chemicals sodium hypo 12.5% CIP chemicals 49 % Used 29,925.09 569.00 30,494.09 Valley Solvent Company, INC 569.00 31,063.09 Valley Solvent Company, INC 5640 AP 5674 AP Account: 135-65030-020-000 Chemicals Totals: 1,138.00 31,063.09 ** Account: 135-65035-020-000 Account: 135-65035-020-000 30,000.00 Budgeted (1,063.09) Remaining Small Tools Small Tools Totals: Account: 135-65040-020-000 Account: 135-65040-020-000 Account: 135-65045-020-000 1963 08/30/2019 August A/P 2016 08/31/2019 August A/P 2018 08/31/2019 August A/P Account: 135-65045-020-000 Account: 135-69005-020-000 1901 08/16/2019 August A/P 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj 2038 08/31/2019 Capital Proj 1,200.00 Budgeted Safety Equipment Safety Equipment Totals: 1,200.00 Budgeted (437.69) Remaining 195.73 Remaining Lab Supplies Dipper for lab samples Dipper for lab samples checmicals Lab Supplies Totals: 20,000.00 Budgeted 3,428.17 Remaining Capital Outlays generator for lift station Dep/Fund Clean-up Dubois Bryant Cambell 10/31/19 Dep/Fund Clean-up Dubois Bryant Cambell 11/30/18 Dep/Fund Clean-up Dubois Bryant Cambell 1/18/19 Dep/Fund Clean-up Dubois Bryant Cambell 4/18/19 Dep/Fund Clean-up 3rd Eye Sec Proj WWTP 3/31/19 104 % Used 1,004.27 84 % Used 1 1,637.69 136 % Used .00 .00 .00 .00 1,004.27 1,004.27 ** 1,637.69 1,637.69 ** 15,933.84 138.95 16,072.79 HD SUPPLY WATERWORKS, LTD. 138.95 16,211.74 HD SUPPLY FACILITIES MAINT LTD 360.09 16,571.83 HACH COMPANY 581,362.10 83 % Used 637.99 16,571.83 ** 74,999.00 656,361.10 (1,615.00) 654,746.10 (1,530.00) 653,216.10 (1,190.00) 652,026.10 (1,530.00) 650,496.10 (11,772.51) 638,723.59 5661 AP 5692 AP 5691 AP Sluder Emergency Power Service 5633 AP GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2038 08/31/2019 Capital Proj Dep/Fund Clean-up 3rd Eye Sec Proj WWTP 3/31/19 581,362.10 (17,842.00) 620,881.59 GL 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 1/18/19 (807.50) 620,074.09 GL 2039 08/31/2019 WWTP Foam Syst Cap 135 to 517 Move Cap 135 to 517 07/30/2019 (47,942.93) 572,131.16 GL Account: 135-69005-020-000 Capital Outlays Totals: (9,230.94) 572,131.16 ** 688,600.00 Budgeted 116,468.84 Remaining 83 % Used Account: 135-69008-020-000 Short Term Debt -Principal 1736 08/01/2019 August A/P Camera van 39,858.59 19,075.14 58,933.73 FIRST FINANCIAL BANK 5535 AP Account: 135-69008-020-000 Short Term Debt -Principal Totals: 19,075.14 58,933.73 ** Account: 135-69009-020-000 1736 08/01/2019 August A/P 1736 08/01/2019 August A/P Account: 135-69009-020-000 109,858.00 Budgeted 50,924.27 Remaining Short Term Debt -Interest interest Vac truck Camera van Short Term Debt -Interest Totals: 14,917.00 Budgeted 5,684.26 Remaining 54 % Used 3,027.55 2,439.63 3,765.56 62 % Used 5,467.18 FIRST FINANCIAL BANK 5535 AP 9,232.74 FIRST FINANCIAL BANK 5535 AP 6,205.19 9,232.74 ** Account: 135-69195-020-000 Gasb34/Reserve for Replacement Account: 135-69195-020-000 30,000.00 .00 30,000.00 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 .00 1,500.00 Account: 135-70020-020-000 Capital Lease Issuance Cost Totals: .00 1,500.00 ** .00 Budgeted (1,500.00) Remaining 0 % Used Department 20 Totals: 2,459,772.64 ** 162,845.00 Monthly Total 3,281,182.00 Budgeted 821,409.36 Remaining 75 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 135 08/01/2019 Insurance/Wrk Comp Expense Aug Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 Account: 135-60070-026-000 Account: 135-60075-026-000 1 Workman's Compensation Totals: 21.20 2.12 23.32 GL 30.00 Budgeted 6.68 Remaining 78 6 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Dues & Memberships Totals: 750.00 Budgeted ' Meetings 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 Board meeting snacks Account: 135-60075-026-000 1 Meetings 1,300.00 Budgeted 650.00 2.12 23.32 ** .00 0 % Used .00 .00 .00 ** .00 650.00 100.00 Remaining 87 6 Used .00 650.00 ** 64.34 28.53 Totals: 1,207.13 Remaining 7 6 Used 92.87 TOM THUMB #1780 PC 28.53 92.87 ** Account: 135-60080-026-000 Schools & Training 920.00 .00 920.00 Account: 135-60080-026-000 Schools & Training Totals: .00 920.00 ** 4,000.00 Budgeted 3,080.00 Remaining 23 6 Used Account: 135-60100-026-000 Travel & per diem 800.06 .00 800.06 Account: 135-60100-026-000 Travel & per diem Totals: .00 800.06 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,199.94 Remaining 16 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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: 2,486.25 ** 30.65 Monthly Total 13,230.00 Budgeted 10,743.75 Remaining 19 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-50005-030-000 Salaries & Wages 1823 08/09/2019 MUD Payroll 08/09/19 Salaries & Wages 1918 08/23/2019 MUD Payroll 08/23/2019 Salaries & Wages 300,079.09 14,426.52 314,505.61 PR 14,620.27 329,125.88 PR Account: 135-50005-030-000 Salaries & Wages Totals: 29,046.79 329,125.88 ** 441,006.00 Budgeted 111,880.12 Remaining 75 % Used Account: 135-50010-030-000 Overtime 57.98 .00 57.98 Account: 135-50010-030-000 Overtime Totals: .00 57.98 ** 2,000.00 Budgeted 1,942.02 Remaining 3 % Used Account: 135-50016-030-000 Longevity 1,832.50 Account: 135-50016-030-000 Longevity Totals: 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 ■ Retirement 1823 08/09/2019 MUD Payroll 08/09/19 Retirement 1918 08/23/2019 MUD Payroll 08/23/2019 Retirement .00 1,832.50 1,8 29,292.38 1,334.46 30,626.84 PR 1,352.37 31,979.21 PR Account: 135-50020-030-000 IM Retirement Totals: 2,686.83 31,979.21 ** 41,148.00 Budgeted Account: 135-50026-030-000 Medical Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Medical Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Medical Insurance 9,168.79 Remaining 78 % Used 48,053.76 2,561.73 50,615.49 PR 2,561.67 53,177.16 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,123.40 53,177.16 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Dental Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Dental Insurance 28,717.84 Remaining 65 % Used 2,763.33 144.93 2,908.26 PR 144.90 3,053.16 PR Account: 135-50027-030-000 Dental Insurance Totals: 289.83 3,053.16 ** 4,291.00 Budgeted 1,237.84 Remaining 71 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-50028-030-000 Vision Insurance 1823 08/09/2019 MUD Payroll 08/09/19 Vision Insurance 1918 08/23/2019 MUD Payroll 08/23/2019 Vision Insurance 443.24 22.76 466.00 PR 22.72 488.72 PR Account: 135-50028-030-000 Vision Insurance Totals: 45.48 488.72 ** Account: 135-50029-030-000 1765 08/01/2019 August A/P 1765 08/01/2019 August A/P 1963 08/30/2019 August A/P 701.00 Budgeted 212.28 Remaining 70 % Used Life Insurance & Other Employee Benefits -July Employee LTD & STD -July Caf 125 3,027.44 149.52 3,176.96 Humana Inc 142.90 3,319.86 METLIFE GROUP BENEFITS 20.00 3,339.86 BenefitMall 5545 AP 5552 AP 5654 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 312.42 3,339.86 ** 4,495.00 Budgeted 1,155.14 Remaining 74 % Used Account: 135-50030-030-000 Social Security Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Social Security Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Social Security Taxes Account: 135-50030-030-000 17,836.64 844.02 18,680.66 852.86 19,533.52 PR PR Social Security Taxes Totals: 1,696.88 19,533.52 ** 27,580.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 1823 08/09/2019 MUD Payroll 08/09/19 Medicare Taxes 1918 08/23/2019 MUD Payroll 08/23/2019 Medicare Taxes Account: 135-50035-030-000 Account: 135-50040-030-000 Account: 135-50040-030-000 8,046.48 Remaining 71 6 Used Medicare Taxes Totals: 4,171.49 6,450.00 Budgeted 1,881.67 Remaining 71 5 Used Unemployment Taxes Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 135 08/01/2019 Insurance/Wrk Comp Expense Aug 1,200.42 Remaining 59.58 5 5 Used 197.38 199.46 396.84 .00 4,368.87 4,568.33 4,568.33 ** 59.58 .00 59.58 ** PR PR 1,025.90 106.55 1,132.45 GL glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 34 Check Source Number 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 support-G.L. Microsoft exchange internet-July domain renewal domain renewal internet internet internet adobe subscription 52,869.15 406.00 510.00 899.00 21.17 18.17 42.02 42.02 53.33 32.45 53,275.15 53,785.15 54,684.15 54,705.32 54,723.49 54,765.51 54,807.53 54,860.86 54,893.31 STW INC M3 Networks Charter Communications DNH*GODADDY.COM DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 5634 5627 5614 AP AP AP PC PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,024.16 54,893.31 ** 77,849.00 Budgeted 22,955.69 Remaining 71 % Used Account: 135-55070-030-000 Independent Labor 1932 08/22/2019 August A/P 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 1963 08/30/2019 August A/P 1963 08/30/2019 August A/P 2016 08/31/2019 August A/P Board meeting taping 10/18-8/1 Nicoles Mother Funeral GM -August GM -August GM recruitment 119,511.23 573.75 100.94 12,888.87 39.24 5,000.00 120,084.98 120,185.92 133,074.79 133,114.03 138,114.03 MIGUEL CRUZ TRIBUTE STORE Carman Consulting LLC. Carman Consulting LLC. Mercer Personnel Management 5650 AP PC 5655 AP 5655 AP 5694 AP Account: 135-55070-030-000 Independent Labor Totals: 18,602.80 138,114.03 ** 175,000.00 Budgeted 36,885.97 Remaining 79 % Used Account: 135-50045-030-000 Workman's Compensation Totals: 106.55 1,132.45 ** 1,295.00 Budgeted 162.55 Remaining 87 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 1901 08/16/2019 August A/P drug screening -J Ramirez 141.95 38.00 179.95 CARENOW CORPORATE 5613 AP Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 38.00 179.95 ** 500.00 Budgeted 320.05 Remaining 36 % Used Account: 135-50070-030-000 Employee Relations 3,115.29 .00 3,115.29 Account: 135-50070-030-000 Employee Relations Totals: .00 3,115.29 ** 5,000.00 Budgeted 1,884.71 Remaining 62 o Used Account: 135-55030-030-000 Software & Support 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 - 8/26/2019 support-G.L. Microsoft exchange internet-July domain renewal domain renewal internet internet internet adobe subscription 52,869.15 406.00 510.00 899.00 21.17 18.17 42.02 42.02 53.33 32.45 53,275.15 53,785.15 54,684.15 54,705.32 54,723.49 54,765.51 54,807.53 54,860.86 54,893.31 STW INC M3 Networks Charter Communications DNH*GODADDY.COM DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 5634 5627 5614 AP AP AP PC PC PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,024.16 54,893.31 ** 77,849.00 Budgeted 22,955.69 Remaining 71 % Used Account: 135-55070-030-000 Independent Labor 1932 08/22/2019 August A/P 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 1963 08/30/2019 August A/P 1963 08/30/2019 August A/P 2016 08/31/2019 August A/P Board meeting taping 10/18-8/1 Nicoles Mother Funeral GM -August GM -August GM recruitment 119,511.23 573.75 100.94 12,888.87 39.24 5,000.00 120,084.98 120,185.92 133,074.79 133,114.03 138,114.03 MIGUEL CRUZ TRIBUTE STORE Carman Consulting LLC. Carman Consulting LLC. Mercer Personnel Management 5650 AP PC 5655 AP 5655 AP 5694 AP Account: 135-55070-030-000 Independent Labor Totals: 18,602.80 138,114.03 ** 175,000.00 Budgeted 36,885.97 Remaining 79 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 35 Check Source Number Account: 135-55080-030-000 Maintenance & Repairs Account: 135-55080-030-000 Maintenance & Repairs 20,000.00 Budgeted Totals: 15,025.00 Remaining 4,975.00 25 5 Used .00 .00 4,975.00 4,975.00 ** Account: 135-55085-030-000 Generator Maint. and Repair Account: 135-55085-030-000 Account: 135-55120-030-000 1932 08/22/2019 August A/P Account: 135-55120-030-000 Account: 135-55160-030-000 1901 08/16/2019 August A/P 1930 08/21/2019 August A/P Account: 135-55160-030-000 Account: 135-55205-030-000 Account: 135-55205-030-000 Account: 135-60005-030-000 1725 08/01/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2023 08/26/2019 2030 08/31/2019 1 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,072.48 Remaining Cleaning Services Janitorial svcs Cleaning Services 10,000.00 Budgeted Totals: 1,309.40 Remaining Professional Outside Services FY20 rate calculations FY 20 rate projections Professional Outside Services Totals: 66,055.00 Budgeted (2,909.00) Remaining Utility Billing Contract Utility Billing Contract Totals: 9,000.00 Budgeted 3,198.16 Remaining Telephone Aug A/P Answering service PCard 7/27/2019 - 8/26/2019 phone PCard 7/27/2019 - 8/26/2019 phone PCard 7/27/2019 - 8/26/2019 phone PCard 7/27/2019 - 8/26/2019 answering service Town Bllled Invoices 1702-1705 AR 20190831-20190831 User: 927.52 .00 9 % Used .00 927.52 927.52 ** 7,821.54 869.06 8,690.60 MEMBER'S BUILDING MAINTENANCE 5649 AP 869.06 87 5 Used 8,690.60 ** 61,926.50 2,305.00 64,231.50 NEW GEN STRATEGIES & SOLUTIONS 5630 AP 4,732.50 68,964.00 NEW GEN STRATEGIES & SOLUTIONS 5651 AP 104 % Used 5,801.84 14,590.51 7,037.50 .00 64 8 Used .00 194.75 468.16 779.23 167.29 14.99 (180.00) 68,964.00 ** 5,801.84 5,801.84 ** 14,785.26 15,253.42 16,032.65 16,199.94 16,214.93 16,034.93 KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 5522 AP PC PC PC PC AR glpdatb2 skrolczyk 18:24 09/10/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: 8/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 36 Check Source Number 1824 08/05/2019 Child Support Fee 1853 08/06/2019 August A/P 1920 08/23/2019 Child Support Fee 1966 08/31/2019 Pace Credit Card Fees 1966 08/31/2019 Pace Credit Card Fees Direct send fees 53,846.10 1.50 50.00 1.50 5,504.30 133.49 53,847.60 53,897.60 Fisery Solutions, LLC 53,899.10 59,403.40 59,536.89 GL 5596 AP GL GL GL Account: 135-60005-030-000 Telephone Totals: 1,444.42 16,034.93 ** 23,500.00 Budgeted 7,465.07 Remaining 68 % Used Account: 135-60010-030-000 Communications/Mobiles 1901 08/16/2019 August A/P Cell phones -August 1918 08/23/2019 MUD Payroll 08/23/2019 Communications/Mobiles 2,375.41 87.94 150.00 2,463.35 2,613.35 VERIZON WIRELESS 5641 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.94 2,613.35 ** 4,000.00 Budgeted 1,386.65 Remaining 65 % Used Account: 135-60020-030-000 Electricity/Gas 1901 08/16/2019 August A/P Gexa energy 6/10-7/10 5,210.47 482.42 5,692.89 TOWN OF TROPHY CLUB 5638 AP Account: 135-60020-030-000 Electricity/Gas Totals: 482.42 5,692.89 ** 8,690.00 Budgeted 2,997.11 Remaining 66 % Used Account: 135-60025-030-000 ter 2016 08/31/2019 August A/P water-july 2030 08/31/2019 Town Billed Invoices 1702-1705 AR 20190831-20190831 User: 558.97 128.48 (64.24) 687.45 623.21 TROPHY CLUB MUD (WATER BILLS) 5700 AP AR Account: 135-60025-030-000 Water Totals: 64.24 623.21 ** 2,000.00 Budgeted 1,376.79 Remaining 31 % Used Account: 135-60035-030-000 Postage 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 express services 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 ink cartridge 18,218.99 46.33 109.95 18,265.32 18,375.27 FEDEX 33182118 POSTAGEINK COM PC PC Account: 135-60035-030-000 Postage Totals: 156.28 18,375.27 ** 30,000.00 Budgeted 11,624.73 Remaining 61 % Used Account: 135-60040-030-000 Service Charges & Fees 1824 08/05/2019 Child Support Fee 1853 08/06/2019 August A/P 1920 08/23/2019 Child Support Fee 1966 08/31/2019 Pace Credit Card Fees 1966 08/31/2019 Pace Credit Card Fees Direct send fees 53,846.10 1.50 50.00 1.50 5,504.30 133.49 53,847.60 53,897.60 Fisery Solutions, LLC 53,899.10 59,403.40 59,536.89 GL 5596 AP GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60040-030-000 Service Charges & Fees Totals: 5,690.79 59,536.89 ** 55,560.00 Budgeted Account: 135-60050-030-000 Bad Debt Expense (3,976.89) Remaining 107 % Used .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 135 08/01/2019 Insurance/Wrk Comp Expense Aug 63,027.30 6,302.73 69,330.03 GL Account: 135-60055-030-000 Insurance Totals: 6,302.73 69,330.03 ** 65,000.00 Budgeted (4,330.03) Remaining 107 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 5 Used Account: 135-60070-030-000 Dues & Memberships 4,269.25 .00 4,269.25 Account: 135-60070-030-000 Account: 135-60075-030-000 Account: 135-60075-030-000 Dues & Memberships Totals: .00 4,269.25 ** 6,000.00 Budgeted 1,730.75 Remaining 71 6 Used Meetings 133.82 .00 133.82 Meetings Totals: .00 133.82 ** 400.00 Budgeted Account: 135-60079-030-000 Public Education 266.18 Remaining 33 5 Used 260.99 .00 260.99 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60079-030-000 Public Education Totals: .00 260.99 ** 6,000.00 Budgeted Account: 135-60080-030-000 Schools & Training Account: 135-60080-030-000 5,739.01 Remaining 4 % Used 1,172.00 .00 1,172.00 Schools & Training Totals: .00 1,172.00 ** 8,950.00 Budgeted Account: 135-60100-030-000 Travel & per diem 2016 08/31/2019 August A/P tolls to lab Account: 135-60100-030-000 Account: 135-60110-030-000 Account: 135-60110-030-000 7,778.00 Remaining 13 % Used 140.96 8.03 148.99 NTTA 5695 AP Travel & per diem Totals: 8.03 148.99 ** 4,345.00 Budgeted 4,196.01 Remaining 3 5 Used Physicals/Testing Physicals/Testing Totals: 200.00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 200.00 Remaining 0 % Used Advertising Totals: 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security 1901 08/16/2019 August A/P monitoring svc-Aug Account: 135-60235-030-000 Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 .00 .00 ** .00 .00 .00 .00 ** 240.00 24.00 264.00 Digital Air Control, Inc 1,024.00 Remaining 20 5 Used 124.49 24.00 264.00 ** .00 124.49 5617 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60245-030-000 Miscellaneous Expenses Totals: .00 124.49 ** 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 375.51 Remaining 25 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,260.01 Remaining .00 .00 .00 .00 ** 0 % Used 239.99 .00 239.99 .00 239.99 ** 10 % Used Account: 135-65010-030-000 Uniforms .00 .00 Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 3,554.79 .00 3,554.79 Account: 135-65055-030-000 Hardware Totals: .00 3,554.79 ** 7,064.00 Budgeted 3,509.21 Remaining 50 % Used Account: 135-65085-030-000 Office Supplies 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 door hanger paper 6,245.44 39.26 6,284.70 ZAPCO PC 2016 08/31/2019 August A/P Office supplies 70.88 6,355.58 OFFICE DEPOT, INC 5696 AP 2016 08/31/2019 August A/P Office supplies 55.36 6,410.94 OFFICE DEPOT, INC 5696 AP Account: 135-65085-030-000 Office Supplies Totals: 165.50 6,410.94 ** 6,000.00 Budgeted (410.94) Remaining 107 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 40 .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 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 coffee 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 batteries 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 urinal screen and mat 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 candy 4,327.87 34.19 4,362.06 AMAZON.COM*MA7G88161 13.97 4,376.03 AMAZON.COM*MAOTR4VA0 94.33 4,470.36 AMZN MKTP US*MA05N9MC0 9.96 4,480.32 WAL-MART #5247 PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 152.45 4,480.32 ** 4,000.00 Budgeted (480.32) Remaining 112 % Used Capital Outlays Totals: 37,311.84 107,238.98 ** Account: 135-65105-030-000 Printing % Used Account: 135-69170-030-000 I Copier Lease Installments .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,723.97 2,500.00 Budgeted 2,500.00 Remaining 0 % Used 5637 5665 AP AP Account: Account: 135-69005-030-000 Capital Outlays 287.37 3,011.34 ** 1901 08/16/2019 August A/P GIS database development 2023 08/26/2019 PCard 7/27/2019 - 8/26/2019 aerial photos for GIS 2038 08/31/2019 Capital Proj Dep/Fund Clean-up 3rd Eye Sec Proj WWTP 3/31/19 2038 08/31/2019 Capital Proj Dep/Fund Clean-up 3rd Eye Sec Proj WWTP 3/31/19 69,927.14 5,450.33 2,247.00 11,772.51 17,842.00 75,377.47 Halff Associates, INC 77,624.47 NCTCOG ONLINE SERVICES 89,396.98 107,238.98 5620 AP PC GL GL Department 30 Totals: 120,604.55 Monthly Total 1,559,905.00 Budgeted 1,037,526.36 ** 522,378.64 Remaining 67 % Used Account: 135-69005-030-000 Capital Outlays Totals: 37,311.84 107,238.98 ** 280,000.00 Budgeted 172,761.02 Remaining 38 % Used Account: 135-69170-030-000 I Copier Lease Installments 1901 08/16/2019 August A/P 1963 08/30/2019 August A/P copier lease -August copies 2,723.97 165.00 122.37 2,888.97 3,011.34 TIAA COMMERCIAL FINANCE KYOCERA MITA AMERICA, INC. 5637 5665 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 287.37 3,011.34 ** 4,000.00 Budgeted 988.66 Remaining 75 % Used Department 30 Totals: 120,604.55 Monthly Total 1,559,905.00 Budgeted 1,037,526.36 ** 522,378.64 Remaining 67 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 1901 08/16/2019 August A/P 1901 08/16/2019 August A/P 1904 08/16/2019 August A/P Account: 135-55045-039-000 Legal legal legal -travel Westlake easement 113,228.07 3,090.00 1,050.00 4,642.50 116,318.07 McLean & Howard, L.L.P. 117,368.07 McLean & Howard, L.L.P. 122,010.57 WHITAKER CHALK SWINDLE Legal Totals: 8,782.50 122,010.57 ** 137,000.00 Budgeted Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 14,989.43 Remaining 89 % Used 26,459.53 .00 Auditing Totals: .00 30,800.00 Budgeted Account: 135-55060-039-000 Appraisal 4,340.47 Remaining 86 % Used 26,459.53 26,459.53 ** 8,945.42 .00 8,945.42 Account: 135-55060-039-000 Appraisal Totals: .00 8,945.42 ** 11,714.00 Budgeted 2,768.58 Remaining 76 % Used Account: 135-55065-039-000 Tax Admin Fees 3,653.00 .00 3,653.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,653.00 ** 4,800.00 Budgeted 1,147.00 Remaining 76 9 Used Department 39 Totals: 161,068.52 ** 8,782.50 Monthly Total 184,314.00 Budgeted 23,245.48 Remaining 87 % Used Fund 135 Totals: (474,378.07) (37,470.89) Monthly Total (343,337.00) Budgeted 131,041.07 Remaining 138 % Used 5629 AP 5629 AP 5642 AP glpdatb2 skrolczyk 18:24 09/10/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: 8/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 42 Check Source Number Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (105,000.00) .00 (105,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,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) ** Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 43 Account: 137-69195-010-000 GASB Replacement 266,613.00 .00 266,613.00 Account: 137-69195-010-000 GASB Replacement Totals: .00 266,613.00 ** .00 Budgeted (266,613.00) Remaining 0 % Used Department 10 Totals: 266,613.00 ** Fund 137 Totals: .00 Monthly Total .00 Budgeted .00 Monthly Total .00 Budgeted (266,613.00) Remaining 0 % Used 80,193.00 (80,193.00) Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET AUGUST 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 718,140 TOTAL ASSETS 718,140 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 739,577 TOTAL LIABILITIES 739,577 FUND BALANCE ASSIGNED FUND BALANCE (1,479,465) NET REVENUES / EXPENDITURES 1,458,028 TOTAL FUND BALANCE (21,437) TOTAL LIABILITIES AND FUND BALANCE 718,140 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 18:24 09/10/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 1,338.86- 6,170.92- 6,170.92 517-49105-000-000 Bond Proceeds 1,743,522.00- 1,743,522.00 Subtotal: 1,338.86- 1,749,692.92- 1,749,692.92 Program number: 1,338.86- 1,749,692.92- 1,749,692.92 Department number: Revenues 1,338.86- 1,749,692.92- 1,749,692.92 Revenues Subtotal 1,338.86- 1,749,692.92- 1,749,692.92 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 18:24 09/10/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 64,413.28 291,665.30 291,665.30 - Subtotal: 64,413.28 291,665.30 291,665.30 - Program number: 64,413.28 291,665.30 291,665.30 - Department number: Wastewater 64,413.28 291,665.30 291,665.30 - Expenditures Subtotal 64,413.28 291,665.30 291,665.30 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 63,074.42 1,458,027.62- 1,458,027.62 glpdatb2 skrolczyk 18:24 09/10/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 44 Check Source Number Department Totals: .00 Budgeted (1,338.86) Monthly Total 1,743,522.00 Remaining 0 o Used (1,749,692.92) ** .00 Budgeted 1,749,692.92 Remaining 0 % Used Account: 517-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August (4,832.06) (1,338.86) (6,170.92) GL Account: 517-49011-000-000 Interest Income Totals: (1,338.86) (6,170.92) ** .00 Budgeted 6,170.92 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (1,743,522.00) .00 (1,743,522.00) Account: 517-49105-000-000 Bond Proceeds Totals: .00 (1,743,522.00) ** Department Totals: .00 Budgeted (1,338.86) Monthly Total 1,743,522.00 Remaining 0 o Used (1,749,692.92) ** .00 Budgeted 1,749,692.92 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/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 1902 08/16/2019 August A?P Geo services mapping 1930 08/21/2019 August A/P WWTP lega 1963 08/30/2019 August A/P soil testing 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 10/31/19 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 11/30/18 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 1/18/19 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 4/18/19 2038 08/31/2019 Capital Proj Dep/Fund Clean-up Dubois Bryant Cambell 1/18/19 2039 08/31/2019 WWTP Foam Syst Cap 135 to 517 Move Cap 135 to 517 07/30/2019 227,252.02 3,050.00 230,302.02 ECS Southwest, LLP 5618 AP 2,252.50 232,554.52 Dubois Bryant Campbell LLP 5647 AP 4,495.35 237,049.87 Wiss, Janney, Elstner Assoc 5675 AP 1,615.00 238,664.87 GL 1,530.00 240,194.87 GL 1,190.00 241,384.87 GL 1,530.00 242,914.87 GL 807.50 243,722.37 GL 47,942.93 291,665.30 GL Account: 517-69005-020-000 Capital Outlays Totals: 64,413.28 291,665.30 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted (291,665.30) Remaining 0 % Used 291,665.30 ** 64,413.28 Monthly Total .00 Budgeted (291,665.30) Remaining 0 % Used 63,074.42 Monthly Total (1,458,027.62) .00 Budgeted 1,458,027.62 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET AUGUST 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 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES 12,981 TOTAL FUND BALANCE 767,181 TOTAL LIABILITIES AND FUND BALANCE 780,339 glbase tbam skrolczyk 18:24 09/10/19 Fund: 519 2016 Rev Bond Const -SWIFT Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 8/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 17 519-49011-000-000 Interest Income 12,981.05- 12,981.05- 12,981.05 Subtotal: 12,981.05- 12,981.05- 12,981.05 Program number: 12,981.05- 12,981.05- 12,981.05 Department number: Revenues 12,981.05- 12,981.05- 12,981.05 Revenues Subtotal 12,981.05- 12,981.05- 12,981.05 Fund number: 519 2016 Rev Bond Const -SWIFT 12,981.05- 12,981.05- 12,981.05 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Oct 2018 Interest (872.68) (872.68) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Nov 2018 Interest (1,010.40) (1,883.08) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Dec 2018 Interest (1,012.36) (2,895.44) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Jan 2019 Interest (1,103.54) (3,998.98) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Feb 2019 Interest (1,172.61) (5,171.59) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Mar 2019 Interest (1,056.37) (6,227.96) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Apr 2019 Interest (1,181.28) (7,409.24) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int May 2019 Interest (1,152.42) (8,561.66) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int June 2019 Interest (1,172.46) (9,734.12) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int July 2019 Interest (1,111.21) (10,845.33) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Aug 2019 Interest (1,137.40) (11,982.73) GL 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Sept 2019 Interest (998.32) (12,981.05) GL Account: 519-49011-000-000 Interest Income Totals: (12,981.05) (12,981.05) ** .00 Budgeted 12,981.05 Remaining 0 % Used Department Totals: (12,981.05) ** (12,981.05) Monthly Total .00 Budgeted 12,981.05 Remaining 0 % Used Fund 519 Totals: (12,981.05) (12,981.05) Monthly Total .00 Budgeted 12,981.05 Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET AUGUST 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 570,483 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 4,485,058 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 1,952 1,952 (366,246) 4,849,352 4,483,107 4,485,058 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 18:24 09/10/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 24,519.46- 35,245.65- 35,245.65 520-49105-000-000 Bond Proceeds 5,229,675.71- 5,229,675.71 520-49110-000-000 Bond Premium 4,224.10- 4,224.10 520-49141-000-000 Interfund Transfer In -Gen Fund 25,000.00 25,000.00 - Subtotal: 24,519.46- 5,244,145.46- 5,244,145.46 Program number: 24,519.46- 5,244,145.46- 5,244,145.46 Department number: 24,519.46- 5,244,145.46- 5,244,145.46 Revenues Subtotal 24,519.46- 5,244,145.46- 5,244,145.46 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 18:24 09/10/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 2,308.41 165,838.84 165,838.84 - Subtotal: 2,308.41 165,838.84 165,838.84- 520-70005-010-000 Paying Agent Fee 800.00 800.00- 520-70020-010-000 Bond Issuance Costs 228,154.32 228,154.32 - Subtotal: 228,954.32 228,954.32 - Program number: 2,308.41 394,793.16 394,793.16 - Department number: Water Department 2,308.41 394,793.16 394,793.16 - Expenditures Subtotal 2,308.41 394,793.16 394,793.16 - Fund number: 520 Revenue Bond 16" Waterline 22,211.05- 4,849,352.30- 4,849,352.30 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 8/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-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August 2031 08/31/2019 Swift & Sers19 Bond Escrow Int May 2019 Interest 2031 08/31/2019 Swift & Sers19 Bond Escrow Int June 2019 Interest 2031 08/31/2019 Swift & Sers19 Bond Escrow Int July 2019 Interest 2031 08/31/2019 Swift & Sers19 Bond Escrow Int August 2019 Interest 2031 08/31/2019 Swift & Sers19 Bond Escrow Int Sept 2019 Interest (10,726.19) (1,064.38) (11,790.57) GL (1,540.07) (13,330.64) GL (5,814.04) (19,144.68) GL (5,510.30) (24,654.98) GL (5,640.17) (30,295.15) GL (4,950.50) (35,245.65) GL Account: 520-49011-000-000 Interest Income Totals: (24,519.46) (35,245.65) ** .00 Budgeted 35,245.65 Remaining 0 6 Used Account: 520-49105-000-000 Bond Proceeds Account: 520-49105-000-000 (5,229,675.71) .00 (5,229,675.71) Bond Proceeds Totals: .00 (5,229,675.71) ** .00 Budgeted 5,229,675.71 Remaining 0 % Used Account: 520-49110-000-000 Bond Premium (4,224.10) .00 (4,224.10) Account: 520-49110-000-000 Bond Premium Totals: .00 (4,224.10) ** .00 Budgeted 4,224.10 Remaining 0 % Used Account: 520-49141-000-000 Account: 520-49141-000-000 Interfund Transfer In -Gen Fund 25,000.00 .00 25,000.00 Interfund Transfer In -Gen Fund Totals: .00 25,000.00 ** .00 Budgeted (25,000.00) Remaining 0 % Used Department Totals: (5,244,145.46) ** (24,519.46) Monthly Total .00 Budgeted 5,244,145.46 Remaining 0 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 520 Revenue Bond 16" Waterline JE Number JE JE Date Description Account: 520-69005-010-000 1901 08/16/2019 August A/P 2038 08/31/2019 Capital Proj Dep/Fund 2038 08/31/2019 Capital Proj Dep/Fund 2038 08/31/2019 Capital Proj Dep/Fund Account: 520-69005-010-000 Account: 520-70005-010-000 Account: 520-70005-010-000 Account: 520-70020-010-000 Account: 520-70020-010-000 Department 10 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Capital Outlays 16" waterline phase II Clean-up Pcard- Denton County 3/26/19 Clean-up Pcard- Star Tel Bond Notc 3/26 Clean-up PCard Denton Rec Cho Bond 3/26 163,530.43 Capital Outlays Totals: .00 Budgeted (165,838.84) Remaining Paying Agent Fee Paying Agent Fee Totals: .00 Budgeted (800.00) Remaining Bond Issuance Costs 800.00 228,154.32 Bond Issuance Costs Totals: .00 Budgeted (228,154.32) Remaining 2,308.41 Monthly Total O % Used O % Used O % Used .00 Budgeted Program: Transaction Detail 356.62 1.00 1,874.19 76.60 2,308.41 .00 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 163,887.05 Halff Associates, INC 163,888.05 165,762.24 165,838.84 165,838.84 ** 800.00 800.00 ** 228,154.32 .00 228,154.32 ** 394,793.16 ** (394,793.16) Remaining 0 % Used Fund 520 Totals: (4,849,352.30) (22,211.05) Monthly Total .00 Budgeted 4,849,352.30 Remaining 0 % Used Page 48 Check Source Number 5620 AP GL GL GL TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 787,021 TOTAL ASSETS 787,021 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 606,910 180,111 787,021 787,021 glbase_tbam skrolczyk 18:24 09/10/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 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 Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 1,429.05- 4,600.00- 10,432.00- 14,758.69- 50,600.00- 114,752.00- 16,461.05- 180,110.69- 16,461.05- 180,110.69- 16,461.05- 16,461.05- 16,461.05- 180,110.69- 180,110.69- 180,110.69- 295.174 91.678 91.664 97.158 97.158 97.158 97.158 97.158 9,758.69 4,593.00- 10,435.00- 5,269.31- 5,269.31- 5,269.31- 5,269.31- 5,269.31 - Page 20 glpdatb2 skrolczyk 18:24 09/10/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 1976 08/31/2019 Bank Interest- August Account: 528-49011-000-000 Trophy Club MUD No.1 Page 49 Detailed Accounting Trial Balance Program: Period Ending: 8/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (13,329.64) 9,758.69 Remaining 295 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1939 08/23/2019 TexPool Transfers August TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (46,000.00) (55,193.00) Budgeted (4,593.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1939 08/23/2019 TexPool Transfers August TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (1,429.05) (14,758.69) GL (1,429.05) (14,758.69) ** (4,600.00) (50,600.00) GL 92 % Used (104,320.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (10,435.00) Remaining (4,600.00) (50,600.00) ** (10,432.00) (114,752.00) GL 92 9 Used (16,461.05) Monthly Total (185,380.00) Budgeted (16,461.05) Monthly Total (185,380.00) Budgeted (10,432.00) (114,752.00) ** (180,110.69) ** (5,269.31) Remaining 97 % Used (180,110.69) (5,269.31) Remaining 97 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET AUGUST 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 82,826 12,397 95,223 LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,397 ACCOUNTS AND OTHER PAYABLES 657 TOTAL LIABILITIES 13,054 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 53,289 28,880 82,169 TOTAL LIABILITIES AND FUND BALANCE 95,223 glbase tbam skrolczyk 18:24 09/10/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 21 Budget Summary with Amendment Department: Revenues Program: Period Ending: 8/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 687,175.00- 1,800.00- 2,000.00- 687,175.00- 1,800.00- 2,000.00- 1,690.53- 39.83 213.31- 678,510.52- 1,929.34 2,267.62- 98.739 -107.186 113.381 8,664.48- 3,729.34- 267.62 Subtotal: 690,975.00- 690,975.00- 1,864.01- 678,848.80- 98.245 12,126.20- 533-49010-000-000 533-49011-000-000 533-49015-000-000 Interest Income Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 1,459.40- 37,207.06- 215,979.00- 100.000 2,000.00- 37,207.06 533-49141-000-000 Interfund Trans In -PID Surchq 120,053.00- 120,053.00- 10,914.00- 120,053.00- 100.000 Subtotal: 338,032.00- 338,032.00- 12,373.40- 373,239.06- 110.415 35,207.06 Program number: 1,029,007.00- 1,029,007.00- 14,237.41- 1,052,087.86- 102.243 23,080.86 Department number: Revenues 1,029,007.00- 1,029,007.00- 14,237.41- 1,052,087.86- 102.243 23,080.86 Revenues Subtotal 1,029,007.00- 1,029,007.00- 14,237.41- 1,052,087.86- 102.243 23,080.86 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 18:24 09/10/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 533-70025-051-000 Bond Interest Expense -Tax 533-70035-051-000 Bond Principal Payment -Tax Subtotal: Program number: Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 2,150.00 266,058.00 755,000.00 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 700.00 133,028.75 755,000.00 2,150.00 266,057.50 755,000.00 888,728.75 1,023,207.50 1,023,208.00 1,023,208.00 888,728.75 1,023,207.50 1,023,208.00 1,023,208.00 5,799.00- 1,023,208.00 1,023,208.00 5,799.00- 888,728.75 888,728.75 874,491.34 1,023,207.50 1,023,207.50 28,880.36- 100.000 100.000 100.000 100.000 .50 .50 100.000 .50 100.000 100.000 498.023 .50 .50 23,081.36 glpdatb2 skrolczyk 18:24 09/10/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 Program: Period Ending: 8/2019 JE Detail Description/Comment Page 50 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1997 08/07/2019 Property Taxes 2041 08/07/2019 Property Taxes- Dep Chg JE1997 Fix Denton Dep Levy not I&S 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2002 08/16/2019 Property Taxes 2003 08/19/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes (676,819.99) (163.96) (376.12) (965.35) (4.13) (25.15) 25.15 (5.84) (66.04) (38.02) 2.73 18.40 (4.79) (60.33) (27.08) (676,983.95) (677,360.07) (678,325.42) (678,329.55) (678,354.70) (678,329.55) (678,335.39) (678,401.43) (678,439.45) (678,436.72) (678,418.32) (678,423.11) (678,483.44) (678,510.52) GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (1,690.53) (678,510.52) ** (687,175.00) Budgeted (8,664.48) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2003 08/19/2019 2005 08/27/2019 2007 08/30/2019 Property Taxes Property Taxes Property Taxes 1,889.51 46.87 (.31) (6.73) 1,936.38 1,936.07 1,929.34 GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 39.83 1,929.34 ** (1,800.00) Budgeted (3,729.34) Remaining -107 % Used Account: 533-40015-000-000 Property Taxes/P & I J 1993 08/01/2019 Property Taxes 1994 08/02/2019 Property Taxes 1995 08/05/2019 Property Taxes 1996 08/06/2019 Property Taxes 1999 08/09/2019 Property Taxes 2000 08/12/2019 Property Taxes 2001 08/15/2019 Property Taxes 2004 08/22/2019 Property Taxes 2005 08/27/2019 Property Taxes 2006 08/28/2019 Property Taxes 2007 08/30/2019 Property Taxes (2,054.31) (5.67) (4.39) (176.74) (.54) (.92) (10.02) (6.07) (.65) (1.07) (5.15) (2.09) (2,059.98) (2,064.37) (2,241.11) (2,241.65) (2,242.57) (2,252.59) (2,258.66) (2,259.31) (2,260.38) (2,265.53) (2,267.62) GL GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (213.31) (2,267.62) ** (2,000.00) Budgeted 267.62 Remaining 113 % Used glpdatb2 skrolczyk 18:24 09/10/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 Program: Period Ending: 8/2019 JE Detail Description/Comment Page 51 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income .00 .00 Account: 533-49010-000-000 Interest Income Totals: .00 .00 ** (2,000.00) Budgeted Account: 533-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August (2,000.00) Remaining 0 % Used (35,747.66) (1,459.40) (37,207.06) GL Account: 533-49011-000-000 Interest Income Totals: (1,459.40) (37,207.06) ** • .00 Budgeted 37,207.06 Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (215,979.00) ** (215,979.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1939 08/23/2019 TexPool Transfers August TexPool O&M to I6S- PID Debt Account: 533-49141-000-000 (215,979.00) (109,139.00) Interfund Trans In -PID Surchg Totals: (120,053.00) Budgeted .00 Remaining 100 % Used .00 (215,979.00) (10,914.00) (120,053.00) GL (10,914.00) (120,053.00) ** Department Totals: (1,052,087.86) ** (14,237.41) Monthly Total (1,029,007.00) Budgeted 23,080.86 Remaining 102 % Used glpdatb2 skrolczyk 18:24 09/10/19 Fund: 533 MUD 1 I&S Consolidated JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Period Ending: 8/2019 JE Detail Beginning Balance Description/Comment Account: 533-70005-051-000 Paying Agent Fee 2037 08/26/2019 9/1/19 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 2037 08/26/2019 9/1/19 Bond Payments TCMUD1-13 Paying Agent Fee Account: 533-70005-051-000 Account: 533-70025-051-000 2037 08/26/2019 9/1/19 2037 08/26/2019 9/1/19 2037 08/26/2019 9/1/19 2037 08/26/2019 9/1/19 Account: 533-70025-051-000 Paying Agent Fee 2,150.00 Budgeted Totals: .00 Remaining Bond Interest Expense -Tax Bond Payments Bond Payments Bond Payments Bond Payments Account: 533-70035-051-000 2037 08/26/2019 9/1/19 Bond Payments 2037 08/26/2019 9/1/19 Bond Payments 2037 08/26/2019 9/1/19 Bond Payments 2037 08/26/2019 9/1/19 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT BNY MELLON Unl Tax Series 2010 BNYMELLON Unl Tax Ref Ser 2012 BNYMELLON Unl Tax Ref Ser 2013 Bond Interest Expense -Tax 266,058.00 Budgeted 1,450.00 100 % Used 133,028.75 Totals: .50 Remaining 100 % Used Program: Transaction Detail 200.00 500.00 700.00 Transaction Vendor_Name Detail (SUBTOTAL) 1,650.00 2,150.00 Page 52 Check Source Number GL GL 68,762.50 201,791.25 31,441.25 233,232.50 16,987.50 250,220.00 15,837.50 266,057.50 133,028.75 266,057.50 ** GL GL GL GL Bond Principal Payment -Tax BOKF Unl Tax Bond, 1TROP1214UT BNY MELLON Unl Tax Series 2010 BNYMELLON Unl Tax Ref Ser 2012 BNYMELLON Unl Tax Ref Ser 2013 250,000.00 250,000.00 85,000.00 335,000.00 225,000.00 560,000.00 195,000.00 755,000.00 GL GL GL GL Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: 755,000.00 755,000.00 ** Department 51 Totals: Fund 533 Totals: 755,000.00 Budgeted .00 Remaining 100 % Used 888,728.75 Monthly Total 1,023,208.00 Budgeted 874,491.34 Monthly Total 1,023,207.50 ** .50 Remaining 100 % Used (28,880.36) (5,799.00) Budgeted 23,081.36 Remaining 498 9 Used TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET AUGUST 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 24,474 TOTAL ASSETS 24,474 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 19,562 4,912 24,474 TOTAL LIABILITIES AND FUND BALANCE 24,474 glbase tbam skrolczyk 18:24 09/10/19 Fund: 534 2015 Revenue Bond I&S Account 534-49011-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 8/2019 Amended Total Budget Encumb. 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Program: Current YTD Month Total 700.02- 4,912.07- 54,203.50- 596,238.00- 54,903.52- 601,150.07- 54,903.52- 601,150.07- 54,903.52- 601,150.07- 54,903.52- 601,150.07- % of Budget 491.207 100.000 100.655 100.655 100.655 100.655 Remaining Budget 3,912.07 3,912.07 3,912.07 3,912.07 3,912.07 Page 23 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 18:24 09/10/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 Subtotal: Program number: Department number: Administration Expenditures Subtotal Fund number: 534 2015 Revenue Bond I&S 596,238.00 596,238.00 596,238.00 596,238.00 596,238.00 596,238.00 1,000.00- 596,238.00 596,238.00 1,000.00- 200.00 107,918.75 380,000.00 400.00 215,837.50 380,000.00 488,118.75 596,237.50 488,118.75 596,237.50 488,118.75 488,118.75 433,215.23 596,237.50 596,237.50 4,912.57- 100.000 100.000 100.000 100.000 .50 .50 100.000 .50 100.000 100.000 491.257 .50 .50 3,912.57 glpdatb2 skrolczyk 18:24 09/10/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: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (596,238.00) Budgeted (54,903.52) Monthly Total .00 Remaining 100 % Used (601,150.07) ** (597,238.00) Budgeted 3,912.07 Remaining 101 % Used Account: 534-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August (4,212.05) (700.02) (4,912.07) GL Account: 534-49011-000-000 Interest Income Totals: (700.02) (4,912.07) ** (1,000.00) Budgeted 3,912.07 Remaining 491 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1939 08/23/2019 TexPool Transfers August TexPool O&M to Rev Bd WWTP I&S (542,034.50) (54,203.50) (596,238.00) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.50) (596,238.00) ** Department Totals: (596,238.00) Budgeted (54,903.52) Monthly Total .00 Remaining 100 % Used (601,150.07) ** (597,238.00) Budgeted 3,912.07 Remaining 101 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 2037 08/26/2019 9/1/19 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS Account: 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 Budgeted Totals: .00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense 2037 08/26/2019 9/1/19 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 200.00 100 % Used 107,918.75 215,838.00 Budgeted .50 Remaining Account: 534-70045-051-000 Revenue Bond Principal Expense 2037 08/26/2019 9/1/19 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS Account: 534-70045-051-000 Department 51 Totals: Fund 534 Totals: Revenue Bond Principal Expense Totals: 380,000.00 Budgeted .00 Remaining 488,118.75 Monthly Total 433,215.23 Monthly Total 200.00 200.00 107,918.75 100 % Used 107,918.75 380,000.00 380,000.00 100 % Used 400.00 400.00 ** 215,837.50 215,837.50 ** 380,000.00 380,000.00 ** 596,237.50 ** 596,238.00 Budgeted .50 Remaining 100 % Used (4,912.57) (1,000.00) Budgeted 3,912.57 Remaining 491 % Used GL GL GL TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 4,958 TOTAL ASSETS 4,958 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 2,584 2,374 4,958 TOTAL LIABILITIES AND FUND BALANCE 4,958 glbase tbam skrolczyk 18:24 09/10/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 8/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 341.95 - Program: YTD Total 2,374.00- % of Remaining Budget Budget 395.667 1,774.00 Page 25 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.90- 276,901.00- 100.000 Subtotal: 277,501.00- 277,501.00- 25,514.85- 279,275.00- 100.639 1,774.00 Program number: 277,501.00- 277,501.00- 25,514.85- 279,275.00- 100.639 1,774.00 Department number: Revenues 277,501.00- 277,501.00- 25,514.85- 279,275.00- 100.639 1,774.00 Revenues Subtotal 277,501.00- 277,501.00- 25,514.85- 279,275.00- 100.639 1,774.00 glbase tbam skrolczyk 18:24 09/10/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 8/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month 200.00 Program: YTD Total 400.00 % of Remaining Budget Budget 100.000 Page 26 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 215,000.00 61,501.00 215,000.00 100.000 100.000 Subtotal: 276,901.00 276,901.00 245,950.50 276,901.00 100.000 Program number: 276,901.00 276,901.00 245,950.50 276,901.00 100.000 Department number: Administration 276,901.00 276,901.00 245,950.50 276,901.00 100.000 Expenditures Subtotal 276,901.00 276,901.00 245,950.50 276,901.00 100.000 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 220,435.65 2,374.00- 395.667 1,774.00 ******* End of Report ********* glpdatb2 skrolczyk 18:24 09/10/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: 8/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (276,901.00) Budgeted (25,514.85) Monthly Total .00 Remaining 100 % Used (279,275.00) ** (277,501.00) Budgeted 1,774.00 Remaining 101 % Used Account: 535-49011-000-000 Interest Income 1976 08/31/2019 Bank Interest- August (2,032.05) (341.95) (2,374.00) GL Account: 535-49011-000-000 Interest Income Totals: (341.95) (2,374.00) ** (600.00) Budgeted 1,774.00 Remaining 396 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1939 08/23/2019 TexPool Transfers August TexPool O&M to 16Swift Rev I&S (251,728.10) (25,172.90) (276,901.00) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.90) (276,901.00) ** Department Totals: (276,901.00) Budgeted (25,514.85) Monthly Total .00 Remaining 100 % Used (279,275.00) ** (277,501.00) Budgeted 1,774.00 Remaining 101 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 18:24 09/10/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 8/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee 2037 08/26/2019 9/1/19 Bond Payments BOKF SWIFT 1TROP1116WSS Account: 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 Budgeted Account: 535-70040-051-000 Revenue Bond Interest Expense 2037 08/26/2019 9/1/19 Bond Payments BOKF SWIFT 1TROP1116WSS Account: 535-70040-051-000 Totals: .00 Remaining Revenue Bond Interest Expense Totals: 61,501.00 Budgeted .00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense 2037 08/26/2019 9/1/19 Bond Payments BOKF SWIFT 1TROP1116WSS Account: 535-70045-051-000 Department 51 Totals: Fund 535 Totals: Grand Totals: Revenue Bond Principal Expense Totals: 215,000.00 Budgeted .00 Remaining 245,950.50 Monthly Total 220,435.65 Monthly Total 200.00 200.00 400.00 GL 200.00 100 % Used 400.00 ** 30,750.50 30,750.50 61,501.00 GL 100 % Used 30,750.50 61,501.00 ** 215,000.00 215,000.00 GL 215,000.00 215,000.00 ** 100 9 Used 276,901.00 ** 276,901.00 Budgeted .00 Remaining 100 % Used (2,374.00) (600.00) Budgeted 1,774.00 Remaining 396 8 Used ******* End of Report ********* (7,048,768.29) **** 1,619,783.98 Monthly Total (536,116.00) Budgeted 6,512,652.29 Remaining 9888888888