Loading...
HomeMy WebLinkAbout2019-09 Combined Financials September 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 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. 605,174 19,523 TOTAL ASSETS 624,697 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 19,529 1,400 TOTAL LIABILITIES 20,929 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 59,884 TOTAL FUND BALANCE 603,768 TOTAL LIABILITIES AND FUND BALANCE 624,697 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 864.85- 23.84- 147.04- 1,103,690.07- 3,166.24 5,125.68- 98.808 13,309.93- 3,166.24- 5,125.68 Subtotal: 1,117,000.00- 1,117,000.00- 1,035.73- 1,105,649.51- 98.984 11,350.49- 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- 1,035.73- 1,241,260.57- 104.133 49,260.57 Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 1,035.73- 1,241,260.57- 104.133 49,260.57 Revenues Subtotal 1,192,000.00- 1,192,000.00- 1,035.73- 1,241,260.57- 104.133 49,260.57 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-60030-045-000 122-60055-045-000 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: 9/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.19 56,204.70 215,979.00 17,894.50 674,452.00 100.000 99.414 100.000 105.50 Page 2 Subtotal: 908,431.00 908,431.00 57,695.89 908,325.50 99.988 105.50 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 1,400.00 64,482.00 81,420.00 85.976 100.000 10,518.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 1,400.00 273,050.60 96.291 10,518.40 Program number: 1,192,000.00 1,192,000.00 59,095.89 1,181,376.10 99.109 10,623.90 Department number: Fire 1,192,000.00 1,192,000.00 59,095.89 1,181,376.10 99.109 10,623.90 Expenditures Subtotal 1,192,000.00 1,192,000.00 59,095.89 1,181,376.10 99.109 10,623.90 Fund number: 122 Trophy Club MUD Fire Dept. 58,060.16 59,884.47- 59,884.47 glpdatb2 skrolczyk 15:36 10/11/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: 9/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 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (1,102,825.22) (30.04) (1,102,855.26) (7.39) (1,102,862.65) (1.16) (1,102,863.81) (3.50) (1,102,867.31) (10.96) (1,102,878.27) (6.92) (1,102,885.19) (9.95) (1,102,895.14) (184.77) (1,103,079.91) (365.48) (1,103,445.39) (244.68) (1,103,690.07) GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (864.85) (1,103,690.07) ** (1,117,000.00) Budgeted (13,309.93) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2150 09/10/2019 2153 09/16/2019 2157 09/30/2019 Property Property Property Taxes Taxes Taxes 3,190.08 (3.77) (6.06) (14.01) 3,186.31 3,180.25 3,166.24 GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (23.84) 3,166.24 ** .00 Budgeted (3,166.24) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (4,978.64) (2.90) (.96) (.75) (.59) (.87) (.97) (1.69) (36.96) (73.10) (28.25) (4,981.54) (4,982.50) (4,983.25) (4,983.84) (4,984.71) (4,985.68) (4,987.37) (5,024.33) (5,097.43) (5,125.68) GL GL GL GL GL GL GL GL GL GL Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (147.04) (5,125.68) ** .00 Budgeted 5,125.68 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 2 Check Source Number Department Totals: (1,035.73) Monthly Total (1,241,260.57) ** (1,192,000.00) Budgeted 49,260.57 Remaining 104 % Used 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) ** .00 Budgeted 135,611.06 Remaining 0 % Used Department Totals: (1,035.73) Monthly Total (1,241,260.57) ** (1,192,000.00) Budgeted 49,260.57 Remaining 104 % Used glpdatb2 skrolczyk 15:36 10/11/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: 9/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 136 09/01/2019 Insurance/Wrk Comp Expense Sep 215,979.00 .00 215,979.00 Totals: .00 215,979.00 ** .00 Remaining 100 % Used 16,403.31 1,491.19 17,894.50 GL Account: 122-60055-045-000 Insurance Totals: 1,491.19 17,894.50 ** 18,000.00 Budgeted Account: 122-60337-045-000 Transfer to Town/Fire Budget 2017 09/05/2019 September A/P Fire Admin Sept 105.50 Remaining 99 % Used 618,247.30 56,204.70 Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 674,452.00 Budgeted .00 Remaining 674,452.00 TOWN OF TROPHY CLUB 5699 AP 56,204.70 674,452.00 ** 100 % Used Account: 122-69005-045-000 Capital Outlays 2163 09/30/2019 September A/P Exhaust system 63,082.00 1,400.00 64,482.00 Advanced Paint Repair Service 5778 AP Account: 122-69005-045-000 Capital Outlays Totals: 1,400.00 64,482.00 ** 75,000.00 Budgeted 10,518.00 Remaining 86 % 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 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: 1,181,376.10 ** 59,095.89 Monthly Total 1,192,000.00 Budgeted 10,623.90 Remaining 99 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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: (59,884.47) 58,060.16 Monthly Total .00 Budgeted 59,884.47 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET SEPTEMBER 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,024,680 2,024,680 CASH IN BANK -SAVINGS -CASH RESERVE 1,395,947 1,395,947 INVESTMENTS-TEXPOOL 4,606,663 632,846 5,239,509 PREPAID EXPENSES 8,486 8,486 ADVALOREM PROPERTY TAXES RECEIVABLE 2,088 2,088 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,189,106 1,189,106 TOTAL ASSETS 9,227,569 632,846 9,860,415 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,088 2,088 ACCOUNTS AND OTHER PAYABLES 600,729 600,729 CUSTOMER DEPOSITS 319,159 319,159 TOTAL LIABILITIES 921,976 921,976 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 2,230,872 2,230,872 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT - ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,384,827 5,384,827 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 681,408 681,408 TOTAL FUND BALANCE 8,305,593 632,846 8,938,439 TOTAL LIABILITIES AND FUND BALANCE 9,227,569 632,846 9,860,415 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- Current Month Program: YTD Total % of Budget Remaining Budget 98.47- 125,687.21- 94.941 6,696.79- 2.73- 326.60 -108.867 626.60- 16.75- 569.53- 189.843 269.53 171,983.00- Page 3 Subtotal: 304,967.00- 304,967.00- 117.95- 125,930.14- 41.293 179,036.86- 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 - 5,070,552.00- 3,112,665.00- 106,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 8,372,635.00- 130,000.00- 14,146.00- 7,000.00- 55,000.00- 617,929.00- 150,000.00- 18,522.00- 20,500.00- 1,013,097.00- 9,690,699.00- 9,690,699.00- 9,690,699.00 - 724,849.16- 5,119,759.48- 100.970 49,207.48 268,617.92- 3,079,746.36- 98.942 32,918.64- 10,526.61- 98,968.82- 93.000 7,449.18- 1,500.00- 15,850.00- 93.235 1,150.00- 1,000.00- 2,750.00- 183.333 1,250.00 550.00- 4,150.00- 92.222 350.00- 16,410.40- 57,003.20- 95.005 2,996.80- 1,023,454.09- 8,378,227.86- 100.067 5,592.86 12,598.53- 2,357.62- 583.33- 116,613.00 29,727.30- 23,134.94 2.00- 94,479.16 929,092.88- 929,092.88- 929,092.88- 139,387.98- 107.222 9,387.98 15,651.20- 110.640 1,505.20 6,999.96- 99.999 .04- 52,600.00- 95.636 2,400.00- 617,929.00- 150,000.00- 100.000 41,295.30- 222.953 22,773.30 25,000.00- 25,000.00 14,215.94- 69.346 6,284.06- 6.00- 6.00 445,156.38- 43.940 567,940.62- 8,949,314.38- 92.350 741,384.62- 8,949,314.38- 92.350 741,384.62- 8,949,314.38- 92.350 741,384.62 - glbase_tbam skrolczyk 15:36 10/11/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 Budget Summary with Amendment 10 Water Period Ending: 9/2019 Amended Total Budget Encumb. 326,755.00 17,000.00 3,620.00 4,800.00 33,304.00 49,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 485,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 114,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 1,876,437.00 200.00 3,000.00 14,750.00 276,901.00 55,193.00 200,000.00 Current Month 28,290.73 446.50 200.00 2,873.72 751.20- 261.55 42.47 209.67 1,861.04 435.26 930.92 167.90 34,968.56 2,389.24 313.50 87.50 607.70 3,397.94 337.69 14,975.56 25.00 Program: YTD Total 298,145.28 11,434.12 3,620.00 2,125.00 30,415.85 41,852.64 2,994.90 489.99 2,553.80 19,121.65 4,472.00 46.80 10,900.66 370.35 73.59 428,616.63 134,041.47 1,906.30 4,769.63 87.50 8,104.32 148,909.22 3,770.84 113,376.94 790.00 122.00 3,581.01 227.12 906.10 21,083.63 304,036.60 1,778,367.41 1,500.00 4,600.00 612.00 8,090.00 276,901.00 55,200.00 % of Budget Remaining Budget 91.244 28,609.72 67.260 5,565.88 100.000 44.271 2,675.00 91.328 2,888.15 84.011 7,965.36 69.375 1,322.10 69.899 211.01 81.565 577.20 86.834 2,899.35 86.835 678.00 4.333 1,033.20 84.534 1,994.34 185.175 170.35- 24.530 226.41 88.358 56,475.37 20,000.00 87.609 18,958.53 63.543 1,093.70 95.393 230.37 3,500.00 1.678 5,126.50 124.682 1,604.32- 75.891 47,304.78 75.417 1,229.16 99.276 827.06 79.000 210.00 24.400 378.00 76.994 1,069.99 400.00 38.640 1,438.90 1,500.00 36.351 36,916.37 94.774 98,069.59 200.00 20.400 2,388.00 54.847 6,660.00 100.000 100.013 7.00- 200,000.00 Page 4 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Amended Total Budget Encumb. 2,500.00 2,616,581.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 805,220.00 30,068.00 4,124.00 75,000.00 120,000.00 1,034,412.00 4,531,689.00 Current Month 325,701.97 757.94 1,288.40 214.40 2,260.74 129,308.50 129,308.50 495,637.71 Program: YTD Total 2,262,800.93 10,232.41 2,218.77 22,270.42 641.25 55,003.00 86,949.00 177,314.85 1,152,484.68 30,068.00 4,124.36 75,000.00 99,877.11 1,361,554.15 4,379,195.78 % of Budget 86.479 68.216 42.751 111.352 64.125 78.576 99.941 88.929 143.127 100.000 100.009 100.000 83.231 131.626 96.635 Remaining Budget 2,500.00 353,780.07 4,767.59 2,971.23 2,270.42- 1,200.00 358.75 14,997.00 51.00 22,075.15 347,264.68- .36- 20,122.89 327,142.15- 152,493.22 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,641,834.00 4,533,689.00 367.70 367.70 367.70 1,799.29 1,799.29 1,799.29 496,005.41 4,380,995.07 89.965 200.71 89.965 200.71 89.965 200.71 96.632 152,693.93 Page 6 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 15:36 10/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 32,123.19 338,597.78 80.294 83,101.22 135-50010-020-000 Overtime 30,000.00 33,000.00 2,087.94 33,113.62 100.344 113.62- 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 8,575.00 98.563 125.00 135-50020-020-000 Retirement 43,276.00 43,276.00 3,468.03 37,618.28 86.926 5,657.72 135-50026-020-000 Medical Insurance 91,627.00 67,627.00 376.56- 60,272.26 89.125 7,354.74 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 4,180.71 81.910 923.29 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 677.46 82.017 148.54 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 375.14 4,052.23 90.150 442.77 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 2,220.03 22,862.72 78.821 6,143.28 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 519.19 5,346.92 78.817 1,437.08 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.78 14,119.01 83.342 2,821.99 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 646,863.00 42,743.94 537,104.73 83.032 109,758.27 135-55005-020-000 Engineering 30,000.00 135-55070-020-000 Independent Labor 15,000.00 5,000.00 2,921.00 58.420 2,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 133,000.00 4,537.72 122,691.32 92.249 10,308.68 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 708.23 6,159.86 61.599 3,840.14 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 1,130.33 2,894.03 36.175 5,105.97 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 7,000.00 856.24 8,781.14 125.445 1,781.14- 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 87.50 175.00 3.356 5,039.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 7,676.25 71,123.77 94.832 3,876.23 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 3,817.00 33,901.77 96.862 1,098.23 Subtotal: 267,714.00 278,214.00 18,813.27 248,647.89 89.373 29,566.11 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 372.26 4,926.72 98.534 73.28 135-60020-020-000 Electricity 174,165.00 154,165.00 12,475.83 146,763.90 95.199 7,401.10 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 136.00 1,794.23 25.077 5,360.77 135-60090-020-000 Safety Program 1,000.00 1,000.00 213.21 313.95 31.395 686.05 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 331.75 876.30 46.243 1,018.70 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 3,908.68 4,133.86 82.677 866.14 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,480.00 7,119.47 61.375 4,480.53 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 120,053.00 100.000 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund Account 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Subtotal: 135-70020-020-000 Subtotal: Program number: Department number: Wastewater Description Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost Department: Adopted Budget 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 330,000.00 109,858.00 14,917.00 30,000.00 484,775.00 2,872,082.00 2,872,082.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 9/2019 Amended Total Budget Encumb. 596,330.00 125,187.00 200,000.00 3,500.00 1,269,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 735,822.00 58,934.00 9,233.00 30,000.00 833,989.00 1,500.00 1,500.00 3,100,296.00 3,100,296.00 Current Month 10,432.00 29,349.73 390.08 569.00 139.00 105.85- 992.23 91,899.17 91,899.17 Program: YTD Total 596,238.00 125,184.00 791.00 1,028,425.72 12,103.51 2,713.30 31,632.09 1,143.27 1,637.69 16,465.98 65,695.84 572,131.16 58,933.73 9,232.74 30,000.00 670,297.63 1,500.00 1,500.00 2,551,671.81 2,551,671.81 % of Budget Remaining Budget 99.985 92.00 99.998 3.00 200,000.00 22.600 2,709.00 81.021 240,909.28 96.828 396.49 49.378 2,781.70 105.440 1,632.09- 95.273 56.73 136.474 437.69- 82.330 3,534.02 93.325 4,699.16 77.754 163,690.84 100.000 .27 99.997 .26 100.000 80.372 163,691.37 100.000 100.000 82.304 82.304 548,624.19 548,624.19 Page 8 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.09 Program: YTD Total 25.41 % of Remaining Budget Budget 84.700 4.59 Page 9 Subtotal: 30.00 30.00 2.09 25.41 84.700 4.59 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 11.96 650.00 104.83 920.00 800.06 86.667 8.064 23.000 16.001 150.00 100.00 1,195.17 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 11.96 2,474.89 18.749 10,725.11 Program number: 13,230.00 13,230.00 14.05 2,500.30 18.899 10,729.70 Department number: Board of Directors 13,230.00 13,230.00 14.05 2,500.30 18.899 10,729.70 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 15:36 10/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 441,006.00 2,000.00 2,000.00 1,833.00 1,833.00 41,148.00 41,148.00 81,895.00 61,895.00 4,291.00 4,291.00 701.00 701.00 4,495.00 4,495.00 27,580.00 27,580.00 6,450.00 6,450.00 1,260.00 1,260.00 1,295.00 1,295.00 500.00 500.00 5,000.00 5,000.00 35,223.93 364,349.81 82.618 76,656.19 57.98 2.899 1,942.02 1,832.50 99.973 .50 3,494.66 35,473.87 86.210 5,674.13 1,525.28- 51,651.88 83.451 10,243.12 356.14 3,409.30 79.452 881.70 58.65 547.37 78.084 153.63 533.83 3,873.69 86.178 621.31 2,201.20 21,734.72 78.806 5,845.28 514.81 5,083.14 78.808 1,366.86 59.58 4.729 1,200.42 106.59 1,239.04 95.679 55.96 179.95 35.990 320.05 50.00 3,165.29 63.306 1,834.71 Subtotal: 619,454.00 599,454.00 41,014.53 492,658.12 82.184 106,795.88 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 77,849.00 175,000.00 175,000.00 20,000.00 20,000.00 10,000.00 10,000.00 10,000.00 10,000.00 66,055.00 66,055.00 9,000.00 9,000.00 169.82 55,063.13 70.731 22,785.87 14,409.31 152,523.34 87.156 22,476.66 495.99 5,470.99 27.355 14,529.01 927.52 9.275 9,072.48 869.06 9,559.66 95.597 440.34 462.50 69,426.50 105.104 3,371.50- 1,172.63 6,974.47 77.494 2,025.53 Subtotal: 367,904.00 367,904.00 17,579.31 299,945.61 81.528 67,958.39 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 23,500.00 4,000.00 4,000.00 8,690.00 8,690.00 2,000.00 2,000.00 30,000.00 30,000.00 55,560.00 67,560.00 1,500.00 1,500.00 65,000.00 75,633.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 8,950.00 8,950.00 4,345.00 4,345.00 200.00 200.00 25,000.00 1,288.00 1,288.00 1,660.89 17,695.82 75.301 5,804.18 239.18 2,852.53 71.313 1,147.47 526.42 6,219.31 71.569 2,470.69 59.05 682.26 34.113 1,317.74 3,276.40 21,651.67 72.172 8,348.33 6,699.04 66,235.93 98.040 1,324.07 1,500.00 6,302.75 75,632.78 100.000 .22 1,000.00 4,269.25 71.154 1,730.75 42.65 176.47 44.118 223.53 300.00 560.99 9.350 5,439.01 1,172.00 13.095 7,778.00 68.92 217.91 5.015 4,127.09 200.00 1,221.76 1,221.76 1,221.76- 24.00 288.00 22.360 1,000.00 glbase_tbam skrolczyk 15:36 10/11/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: 9/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 1,339.00 124.49 1,578.99 24.898 63.160 375.51 17,000.00 921.01 Subtotal: 263,433.00 261,066.00 21,760.06 200,580.16 76.831 60,485.84 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 745.70 1,971.08 239.99 369.04 745.70 5,525.87 6,650.93 4,849.36 36.376 78.226 110.849 121.234 1,304.30 1,538.13 650.93- 3,500.00 849.36- 2,500.00 Subtotal: 25,114.00 25,114.00 3,325.81 17,771.86 70.765 7,342.14 135-69005-030-000 Capital Outlays 280,000.00 204,887.00 34,245.96 141,484.94 69.055 63,402.06 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 294.71 3,306.05 82.651 693.95 Subtotal: 284,000.00 208,887.00 34,540.67 144,790.99 69.315 64,096.01 Program number: 1,559,905.00 1,462,425.00 118,220.38 1,155,746.74 79.029 306,678.26 Department number: Administration 1,559,905.00 1,462,425.00 118,220.38 1,155,746.74 79.029 306,678.26 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund Account 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Description Legal Auditing,. Appraisal Tax Admin Fees Subtotal: Program number: Department number: Non Departmental Expenditures Subtotal Fund number: 135 MUD 1 General Fund Department: Adopted Budget 137,000.00 30,800.00 11,714.00 4,800.00 184,314.00 184,314.00 184,314.00 10,271,365.00 341,837.00 - Trophy Club MUD No.1 Budget Summary with Amendment 39 Non Departmental Period Ending: 9/2019 Amended Total Budget Encumb. 137,000.00 30,800.00 11,714.00 4,800.00 184,314.00 184,314.00 184,314.00 9,293,954.00 396,745.00 - Current Month 13,812.50 2,111.10 15,923.60 15,923.60 15,923.60 722,062.61 207,030.27 - Program: YTD Total 135,823.07 26,459.53 11,056.52 3,653.00 176,992.12 176,992.12 176,992.12 8,267,906.04 681,408.34- % of Budget 99.141 85.908 94.387 76.104 96.027 96.027 96.027 88.960 171.750 Remaining Budget 1,176.93 4,340.47 657.48 1,147.00 7,321.88 7,321.88 7,321.88 1,026,047.96 284,663.34 Page 12 glbase_tbam skrolczyk 15:36 10/11/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: 9/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 15:36 10/11/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 9/2019 Account Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-010-000 Subtotal: Program number: Department number: Expenditures Description GASB Replacement Water Subtotal Fund number: 137 MUD 1 Consolidated GASB 116,613.00- 116,613.00- 116,613.00- 116,613.00- 116,613.00- 116,613.00- 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 36,420.00- 150,000.00- 150,000.00- 150,000.00- 150,000.00- 150,000.00- 36,420.00 glpdatb2 skrolczyk 15:36 10/11/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: 9/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 11� 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (125,588.74) (3.42) (125,592.16) GL (.84) (125,593.00) GL (.13) (125,593.13) GL (.40) (125,593.53) GL (1.25) (125,594.78) GL (.79) (125,595.57) GL (1.13) (125,596.70) GL (21.04) (125,617.74) GL (41.61) (125,659.35) GL (27.86) (125,687.21) GL Account: 135-40000-000-000 Property Taxes Totals: (98.47) (125,687.21) ** (132,384.00) Budgeted (6,696.79) Remaining 95 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2150 09/10/2019 Property Taxes 2153 09/16/2019 Property Taxes 2157 09/30/2019 Property Taxes 329.33 (.43) 328.90 GL (.69) 328.21 GL (1.61) 326.60 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (2.73) 326.60 ** (300.00) Budgeted (626.60) Remaining -109 % Used Account: 135-40015-000-000 Property Taxes/P & I 1 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (552.78) (.33) (553.11) GL (.11) (553.22) GL (.09) (553.31) GL (.07) (553.38) GL (.10) (553.48) GL (.11) (553.59) GL (.19) (553.78) GL (4.21) (557.99) GL (8.32) (566.31) GL (3.22) (569.53) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (16.75) (569.53) ** (300.00) Budgeted 269.53 Remaining 190 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 6 Check Source Number 2055 09/16/2019 UB 09/16/2019 Penalty removal 2097 09/23/2019 UB 09/23/2019 Penalties 2104 09/25/2019 UB 09/25/2019 Penalty removal 2120 09/30/2019 GB 09/30/2019 Penalty removal 2125 09/30/2019 UB 09/30/2019 Penalty removal UB20190916-20190916 User: UB20190923-20190923 User: UB20190925-20190925 User: UB20190930-20190930 User: UB20190930-20190930 User: (88,442.21) 54.11 (10,848.12) 132.32 117.73 17.35 (88,388.10) (99,236.22) (99,103.90) (98,986.17) (98,968.82) UB UB UB UB U8 Account: 135-47025-000-000 Penalties 7 Totals: (10,526.61) (98,968.82) ** Account: 135-40025-000-000 PID Surcharges Totals: % Used .00 .00 ** Account: (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water (1,450.00) (50.00) (15,800.00) (15,850.00) UB UB Account: 2130 09/30/2019 UB 09/30/2019 Billing UB20190930-20190930 User: (4,394,910.32) 2135 09/30/2019 UB 09/30/2019 WT test credit UB20190930-20190930 User: (725,349.16) 500.00 (5,120,259.48) (5,119,759.48) ** UB UB Account: 135-47000-000-000 Water Totals: o Used (724,849.16) (5,119,759.48) ** Account: (5,070,552.00) Budgeted 49,207.48 Remaining 101 % Used Account: 135-47005-000-000 Sewer (750.00) (2,500.00) TC Town Center CR 2090 09/20/2019 UB 09/20/2019 WA credit UB20190920-20190920 User: (2,811,128.44) 2130 09/30/2019 UB 09/30/2019 Billing UB20190930-20190930 User: 213.75 (268,831.67) (2,810,914.69) (3,079,746.36) UB UB Account: 135-47005-000-000 Sewer Totals: (268,617.92) (3,079,746.36) ** (3,112,665.00) Budgeted (32,918.64) Remaining 99 % Used Account: 135-47025-000-000 Penalties 2055 09/16/2019 UB 09/16/2019 Penalty removal 2097 09/23/2019 UB 09/23/2019 Penalties 2104 09/25/2019 UB 09/25/2019 Penalty removal 2120 09/30/2019 GB 09/30/2019 Penalty removal 2125 09/30/2019 UB 09/30/2019 Penalty removal UB20190916-20190916 User: UB20190923-20190923 User: UB20190925-20190925 User: UB20190930-20190930 User: UB20190930-20190930 User: (88,442.21) 54.11 (10,848.12) 132.32 117.73 17.35 (88,388.10) (99,236.22) (99,103.90) (98,986.17) (98,968.82) UB UB UB UB U8 Account: 135-47025-000-000 Penalties 7 Totals: (10,526.61) (98,968.82) ** (106,418.00) Budgeted (7,449.18) Remaining 93 % Used Account: 135-47030-000-000 Service Charges 2013 09/05/2019 UB 09/05/2019 Disconnect Fees UB20190905-20190905 User: (14,350.00) 2054 09/09/2019 UB 09/09/2019 NSF Checks UB20190909-20190909 User: (1,450.00) (50.00) (15,800.00) (15,850.00) UB UB Account: 135-47030-000-000 Service Charges Totals: (1,500.00) (15,850.00) ** (17,000.00) Budgeted (1,150.00) Remaining 93 o Used Account: 135-47035-000-000 Plumbing Inspections 2141 09/06/2019 Permits -Trophy Club Town Cente 2210/20/30/40/50 TC Drive (1,750.00) (750.00) (2,500.00) TC Town Center CR 2141 09/06/2019 Permits -Trophy Club Town Cente 2250 TC Dr -Irrigation (150.00) (2,650.00) TC Town Center CR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 2142 09/20/2019 Permits 2142 09/20/2019 Permits Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 9/2019 JE Detail Description/Comment 15 Katie Lane 19 Katie Lane Page 7 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,750.00) (50.00) (50.00) (2,700.00) Drees Homes (2,750.00) Drees Homes CR CR Account: 135-47035-000-000 Mk • Plumbing Inspections Totals: (1,000.00) (2,750.00) ** (1,500.00) Budgeted 1,250.00 Remaining 183 % Used Account: 135-47045-000-000 ' Sewer Inspections 2141 09/06/2019 Permits -Trophy Club Town Cente 2210/20/30/40/50 TC Drive (3,600.00) 2142 09/20/2019 Permits 15 Katie Lane 2142 09/20/2019 Permits 19 Katie Lane (250.00) (150.00) (150.00) (3,850.00) (4,000.00) (4,150.00) TC Town Center Drees Homes Drees Homes CR CR CR Account: 135-47045-000-000 Sewer Inspections Totals: (550.00) (4,150.00) ** (4,500.00) Budgeted (350.00) Remaining 92 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2130 09/30/2019 UB 09/30/2019 Billing UB20190930-20190930 User: (40,592.80) (16,410.40) (57,003.20) UB Account: 135-47070-000-000 TCCC Effluent Charges ' Totals: (16,410.40) (57,003.20) ** (60,000.00) Budgeted (2,996.80) Remaining 95 % Used Account: 135-49011-000-000 Interest Income ' 2158 09/30/2019 Bank Interest- September (126,789.45) 2158 09/30/2019 Bank Interest- September 2158 09/30/2019 Bank Interest- September (906.38) (1,234.15) (10,458.00) (127,695.83) (128,929.98) (139,387.98) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (12,598.53) (139,387.98) ** (130,000.00) Budgeted 9,387.98 Remaining 107 % Used Account: 135-49016-000-000 Cell Tower Revenue 2159 09/20/2019 Cell Tower Rev AT&T September (13,293.58) 2160 09/30/2019 Cell Tower Rev AT&T October (1,178.81) (1,178.81) (14,472.39) (15,651.20) GL GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (2,357.62) (15,651.20) ** (14,146.00) Budgeted 1,505.20 Remaining 111 % Used Account: 135-49018-000-000 Building Rent Income 2164 09/30/2019 Town Billed Invoices 1706-1709 AR 20190930-20190930 User: (6,416.63) (583.33) (6,999.96) AR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-49018-000-000 Account: 135-49026-000-000 Account: 135-49026-000-000 Account: 135-49035-000-000 Account: 135-49035-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2019 Beginning Balance JE Detail Description/Comment Building Rent Income (7,000.00) Budgeted Proceeds from Sale of Assets Totals: (.04) Remaining Program: Transaction Detail 100 % Used (52,600.00) Proceeds from Sale of Assets Totals: (55,000.00) Budgeted (2,400.00) Remaining Prior Year Reserves Prior Year Reserves Totals: (617,929.00) Budgeted (617,929.00) Remaining Account: 135-49036-000-000 GASB Reserves 2173 09/30/2019 Budget Amendment #2 Acct Trsfr VFD- Reserve reallocation Account: 135-49036-000-000 Account: 135-49075-000-000 2141 09/06/2019 Permits -Trophy Club 2141 09/06/2019 Permits -Trophy Club 2141 09/06/2019 Permits -Trophy Club 2142 09/20/2019 Permits 2142 09/20/2019 Permits Account: 135-49075-000-000 Account: 135-49141-000-000 Account: 135-49141-000-000 GASB Reserves (150,000.00) Budgeted 96 % Used (266,613.00) Totals: .00 Remaining Oversize Meter Reimbursement Town Cente 2210/20/30/40/50 TC Drive Town Cente 2210/20/30/40/50 TC Drive Town Cente 2250 TC Dr -Irrigation 15 Katie Lane 19 Katie Lane 0 % Used 100 % Used (11,568.00) 1 Oversize Meter Reimbursement Totals: (18,522.00) Budgeted 22,773.30 Remaining Interfund Transfer In Interfund Transfer In Totals: (583.33) .00 .00 .00 .00 116,613.00 116,613.00 (4,349.00) (23,822.50) (869.80) (343.00) (343.00) 223 % Used (25,000.00) .00 Budgeted (29,727.30) .00 25,000.00 Remaining 0 % Used Transaction Vendor_Name Detail (SUBTOTAL) (6,999.96) ** (52,600.00) (52,600.00) ** .00 .00 ** (150,000.00) (150,000.00) ** (15,917.00) TC Town Center, LLC (39,739.50) TC Town Center (40,609.30) TC Town Center (40,952.30) Drees Homes (41,295.30) Drees Homes (41,295.30) ** (25,000.00) .00 (25,000.00) ** Page 8 Check Source Number GL CR CR CR CR CR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 9 Check Source Number Department Totals: .00 Budgeted (929,092.88) Monthly Total 6.00 Remaining 0 % Used (9,690,699.00) Budgeted (8,949,314.38) ** (741,384.62) Remaining 92 % Used Account: 135-49900-000-000 Miscellaneous Income 2142 09/20/2019 Permits 401 Abbot Ln -Fire Line only (37,350.88) 2130 09/30/2019 UB 09/30/2019 Billing UB20190930-20190930 User: 2174 09/30/2019 Budget Amend 82 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc (800.00) (208.02) 24,142.96 (38,150.88) (38,358.90) (14,215.94) Ashton Woods CR UB GL Account: 135-49900-000-000 Miscellaneous Income Totals: 23,134.94 (14,215.94) ** (20,500.00) Budgeted (6,284.06) Remaining 69 % Used Account: 135-49901-000-000 Records Management Revenue 2161 09/20/2019 Open Records Request Revenue (4.00) (2.00) (6.00) GL Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (6.00) ** Department Totals: .00 Budgeted (929,092.88) Monthly Total 6.00 Remaining 0 % Used (9,690,699.00) Budgeted (8,949,314.38) ** (741,384.62) Remaining 92 % Used glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment Account: 135-50005-010-000 Salaries & Wages 1986 09/06/2019 MUD Payroll 09/06/19 Salaries & Wages 2067 09/20/2019 MUD Payroll 09/20/2019 Salaries & Wages 2103 09/25/2019 MUD Payroll 9/25/2019 Salaries & Wages 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc Account: 135-50005-010-000 Salaries & Wages 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 1986 09/06/2019 MUD Payroll 09/06/19 Overtime 2067 09/20/2019 MUD Payroll 09/20/2019 Overtime Account: 135-50010-010-000 Account: 135-50016-010-000 Account: 135-50016-010-000 Overtime 17,000.00 Budgeted Longevity Longevity 3,620.00 Budgeted Account: 135-50017-010-000 Certification 2067 09/20/2019 MUD Payroll 09/20/2019 Certification Account: 135-50017-010-000 Account: 135-50020-010-000 1986 09/06/2019 2067 09/20/2019 2103 09/25/2019 Account: 135-50020-010-000 MUD Payroll 09/06/19 MUD Payroll 09/20/2019 MUD Payroll 9/25/2019 Certification 4,800.00 Budgeted Retirement Retirement Retirement Retirement Retirement 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Medical Insurance 269,854.55 Totals: 28,609.72 Remaining Totals: 5,565.88 Remaining Totals: .00 Remaining Totals: 2,675.00 Remaining Totals: 2,888.15 Remaining 91 % Used 10,987.62 67 % Used 3,620.00 100 % Used 1,925.00 27,542.13 44 % Used 91 % Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 11,976.88 281,831.43 13,943.85 295,775.28 4,500.00 300,275.28 (2,130.00) 298,145.28 28,290.73 198.88 247.62 446.50 .00 .00 200.00 200.00 1,126.25 1,331.22 416.25 2,873.72 298,145.28 ** 11,186.50 11,434.12 11,434.12 ** 3,620.00 3,620.00 ** 2,125.00 2,125.00 ** 28,668.38 29,999.60 30,415.85 30,415.85 ** Page 10 Check Source Number PR PR PR GL PR PR PR 1 PR PR PR 42,603.84 2,109.86 44,713.70 PR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 9/2019 Page 11 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 2067 09/20/2019 MUD Payroll 09/20/2019 Medical Insurance 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc 42,603.84 2,109.82 (4,970.88) 46,823.52 41,852.64 PR GL Account: 135-50026-010-000 Medical Insurance Totals: (751.20) 41,852.64 ** 49,818.00 Budgeted 7,965.36 Remaining 84 % Used Account: 135-50027-010-000 _ Dental Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Dental Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Dental Insurance 2,733.35 130.80 130.75 2,864.15 2,994.90 PR PR Account: 135-50027-010-000 ' Dental Insurance Totals: 261.55 2,994.90 ** 4,317.00 Budgeted 1,322.10 Remaining 69 % Used Account: 135-50028-010-000 Vision Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Vision Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Vision Insurance 447.52 21.25 21.22 468.77 489.99 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 489.99 ** 701.00 Budgeted 211.01 Remaining 70 % Used Account: 135-50029-010-000 Life Insurance & Other 1946 09/01/2019 September Payroll Benefits A/P Employee Benefits -July 1946 09/01/2019 September Payroll Benefits A/P Employee LTD & STD -July 2110 09/25/2019 September A/P Caf 125 2,344.13 98.56 91.11 20.00 2,442.69 2,533.80 2,553.80 Humana Inc METLIFE GROUP BENEFITS BenefitMall 5662 5668 5737 AP AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 209.67 2,553.80 ** 3,131.00 Budgeted 577.20 Remaining 82 % Used Account: 135-50030-010-000 Social Security Taxes 1986 09/06/2019 MUD Payroll 09/06/19 Social Security Taxes 2067 09/20/2019 MUD Payroll 09/20/2019 Social Security Taxes 2103 09/25/2019 MUD Payroll 9/25/2019 Social Security Taxes 17,260.61 725.05 856.99 279.00 17,985.66 18,842.65 19,121.65 PR PR PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,861.04 19,121.65 ** 22,021.00 Budgeted 2,899.35 Remaining 87 % Used Account: 135-50035-010-000 Medicare Taxes 1986 09/06/2019 MUD Payroll 09/06/19 Medicare Taxes 4,036.74 169.57 4,206.31 PR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 2067 09/20/2019 MUD Payroll 09/20/2019 2103 09/25/2019 MUD Payroll 9/25/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 9/2019 Page 12 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Medicare Taxes Medicare Taxes 4,036.74 200.44 65.25 4,406.75 4,472.00 PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 435.26 4,472.00 ** 5,150.00 Budgeted 678.00 Remaining 87 % Used Account: 135-50040-010-000 Unemployment Taxes 46.80 .00 46.80 Account: 135-50040-010-000 Unemployment Taxes Totals: .00 46.80 ** 1,080.00 Budgeted 1,033.20 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 136 09/01/2019 Insurance/Wrk Comp Expense Sep 9,969.74 930.92 10,900.66 GL Account: 135-50045-010-000 Workman's Compensation Totals: 930.92 10,900.66 ** 12,895.00 Budgeted 1,994.34 Remaining 85 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 2170 09/30/2019 September A?P New hire screening -Clayton & M 202.45 167.90 370.35 FIRST CHECK APPLICANT SCREENIN AP Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 167.90 370.35 ** 200.00 Budgeted (170.35) Remaining 185 % Used Account: 135-50070-010-000 Employee Relations 73.59 .00 73.59 Account: 135-50070-010-000 Employee Relations Totals: .00 73.59 ** 300.00 Budgeted 226.41 Remaining 25 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs glpdatb2 skrolczyk Trophy Club MUD No.1 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 13 2066 09/17/2019 September A/P Tank rental 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 Well Meter Calibrations 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 pvc adapter,socket cap, etc. 2163 09/30/2019 September A/P parts 131,652.23 42.00 1,000.00 55.99 1,291.25 131,694.23 ALLIED WELDING SUPPLY, INC 132,694.23 AQUA -METRIC SALES INC. 132,750.22 THE HOME DEPOT #6581 134,041.47 Core & Main LP 5707 AP PC PC 5781 AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,389.24 134,041.47 ** 153,000.00 Budgeted 18,958.53 Remaining 88 % Used Account: 135-55085-010-000 ' Generator Maint. and Repair 1,906.30 .00 1,906.30 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 1,906.30 ** 3,000.00 Budgeted 1,093.70 Remaining 64 % Used Account: 135-55090-010-000 Vehicle Maintenance 2168 09/26/2019 Pcard 8/27/19 - 8/28/19 Tires for dodge 2017 2500 4,456.13 313.50 4,769.63 DISCOUNT TIRE TXD 75 PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 313.50 4,769.63 ** 5,000.00 Budgeted 230.37 Remaining 95 % Used Account: 135-55105-010-000 ' Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services 2110 09/25/2019 September A/P janitorial svc-August 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5746 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 87.50 ** 5,214.00 Budgeted 5,126.50 Remaining 2 % Used Account: 135-55135-010-000 Lab Analysis 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2170 09/30/2019 September A?P water samples TCEQ samples water samples 7,496.62 200.00 207.70 200.00 7,696.62 7,904.32 8,104.32 TARRANT CTY PUBLIC HEALTH LAB LOWER COLORADO RIVER AUTHORITY TARRANT CTY PUBLIC HEALTH LAB 5727 5720 AP AP AP Account: 135-55135-010-000 Lab Analysis Totals: 607.70 8,104.32 ** 6,500.00 Budgeted (1,604.32) Remaining 125 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 2066 09/17/2019 September A/P Account: 135-60010-010-000 Communications/Mobiles Cell phones -Sept 3,433.15 337.69 3,770.84 VERIZON WIRELESS 5734 AP Communications/Mobiles Totals: 5,000.00 Budgeted 1,229.16 Remaining 75 % Used Account: 135-60020-010-000 Electricity 2066 09/17/2019 September A/P Electricity 8/8-9/10 Account: 135-60020-010-000 Electricity Totals: 114,204.00 Budgeted 337.69 98,401.38 14,975.56 827.06 Remaining 99 o Used 3,770.84 ** 113,376.94 HUDSON ENERGY SERVICES, LLC 5717 AP 14,975.56 113,376.94 ** 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 % Used • Account: 135-60070-010-000 Dues & Memberships 122.00 .00 122.00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 122.00 ** 500.00 Budgeted Account: 135-60080-010-000 Schools & Training 2066 09/17/2019 September A/P Petty cash-Dandria 378.00 Remaining 24 % Used 3,556.01 25.00 3,581.01 TROPHY CLUB MUD PETTY CASH 5732 AP Account: 135-60080-010-000 Schools & Training Totals: 25.00 3,581.01 ** 4,651.00 Budgeted 1,069.99 Remaining 77 % Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2163 09/30/2019 September A/P Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 Account: 135-60135-010-000 Account: 135-60150-010-000 Chicago Trip- train ticket train tickets WEFTEC Chicago triaining Travel & per diem Totals: 2,345.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 58,000.00 Budgeted Wholesale Water 2131 09/30/2019 September A/P wholesale water 1,438.90 Remaining 678.98 20.00 698.98 VENTRA VENDING 15302 PC 20.00 718.98 VENTRA VENDING 15302 PC 187.12 906.10 Mike McMahon 5782 AP 39 % Used Totals: 1,500.00 Remaining 0 % Used 21,083.63 227.12 906.10 ** .00 .00 .00 .00 21,083.63 Totals: 36,916.37 Remaining 36 % Used .00 21,083.63 ** 1,474,330.81 304,036.60 1,778,367.41 CITY OF FORT WORTH 5755 AP Account: 135-60150-010-000 Wholesale Water Totals: 304,036.60 1,778,367.41 ** 1,876,437.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses 98,069.59 Remaining 95 % Used .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 612.00 .00 612.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 612.00 ** 3,000.00 Budgeted 2,388.00 Remaining 20 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2131 09/30/2019 September A/P Mowing -September Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 6,660.00 Remaining 6,590.00 1,500.00 55 % Used 8,090.00 WATTS ELLISON LLC 5769 AP 1,500.00 8,090.00 ** Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Account: 135-60332-010-000 276,901.00 Interfund Transfer Out -Rev I&S Totals: 276,901.00 Budgeted .00 Remaining .00 276,901.00 100 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 2101 09/25/2019 TexPool Transfers September TexPool O&M to Rev Bond Resevr 50,600.00 Account: 135-60333-010-000 Account: 135-60334-010-000 Account: 135-60334-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted (7.00) Remaining Interfund Transfer Out Interfund Transfer Out1 Totals: 200,000.00 Budgeted 200,000.00 Remaining 100 % Used 0 % Used .00 276,901.00 ** 4,600.00 55,200.00 GL 4,600.00 55,200.00 ** .00 .00 .00 .00 ** Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 2116 09/24/2019 Fuel Fuel -June 9,474.47 757.94 10,232.41 US Bank Voyager Fleet Systems 5768 AP Account: 135-65005-010-000 Fuel & Lube Totals: 757.94 10,232.41 ** 15,000.00 Budgeted 4,767.59 Remaining 68 % Used Account: 135-65010-010-000 Uniforms 2,218.77 .00 2,218.77 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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: .00 2,218.77 ** 5,190.00 Budgeted 2,971.23 Remaining 43 % Used Account: 135-65030-010-000 Chemicals 2110 09/25/2019 September A/P chemicals 20,982.02 506.63 2131 09/30/2019 September A/P chlorine Account: 135-65030-010-000 21,488.65 HACH COMPANY 5740 AP 781.77 22,270.42 DPC INDUSTRIES, INC Chemicals Totals: 1,288.40 22,270.42 ** 20,000.00 Budgeted Account: 135-65035-010-000 Small Tools Account: 135-65035-010-000 Account: 135-65040-010-000 Account: 135-65040-010-000 Account: 135-65050-010-000 2066 09/17/2019 September A/P Account: 135-65050-010-000 Account: 135-65053-010-000 Account: 135-65053-010-000 (2,270.42) Remaining 111 % Used Small Tools Totals: 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Safety Equipment Safety Equipment Totals: 1,000.00 Budgeted Meter Expense meter flanges 358.75 Remaining Meter Expense Totals: 70,000.00 Budgeted Meter Change Out Program Meter Change Out Program 87,000.00 Budgeted Account: 135-69005-010-000 Capital Outlays 2066 09/17/2019 September A/P 14,997.00 Remaining 641.25 64 % Used .00 .00 .00 .00 ** .00 641.25 .00 641.25 ** 5758 AP 54,788.60 214.40 55,003.00 Core & Main LP 5709 AP 86,949.00 79 % Used Totals: 51.00 Remaining 100 % Used VFD upgrade 1,023,176.18 214.40 55,003.00 ** .00 86,949.00 .00 86,949.00 ** 547.10 1,023,723.28 CP&Y/WALLACE GROUP, INC. 5710 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2069 09/17/2019 September A/P 2110 09/25/2019 September A/P 2131 09/30/2019 September A/P 2170 09/30/2019 September A?P Account: 135-69005-010-000 Straight Creek Ct S Carnoustie Sundance court VFD Upgrade -capitol Indian Creek/Phoenix 1,023,176.18 6,598.25 1,030,321.53 Halff Associates, INC 5715 AP 47,872.80 1,078,194.33 Jackson Construction, LTD 5742 AP 69,317.10 1,147,511.43 REY-MAR CONSTRUCTION 5766 AP 4,973.25 1,152,484.68 Quality Excavation, LTD AP Capital Outlays Totals: 129,308.50 1,152,484.68 ** 805,220.00 Budgeted (347,264.68) Remaining 143 6 Used Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 .00 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,068.00 ** .00 Remaining 100 % Used 4,124.36 .00 4,124.36 Account: 135-69009-010-000 30,068.00 Budgeted Short Term Debt -Interest Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 4,124.36 ** (.36) Remaining 100 % Used Account: 135-69195-010-000 Account: 135-69195-010-000 4,124.00 Budgeted Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 20,122.89 Remaining 83 % Used .00 75,000.00 .00 75,000.00 ** .00 99,877.11 .00 99,877.11 ** glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-55135-010-001 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2170 09/30/2019 September A?P Account: 135-55135-010-001 Department 10 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lab Analysis for PID water samples TCEQ sampling water samples Lab Analysis for PID Totals: 2,000.00 Budgeted 496,005.41 Monthly Total Page 19 200.71 Remaining 1,431.59 80.00 1,511.59 TARRANT CTY PUBLIC HEALTH LAB 5727 AP 207.70 1,719.29 LOWER COLORADO RIVER AUTHORITY 5720 AP 80.00 1,799.29 TARRANT CTY PUBLIC HEALTH LAB AP 90 % Used 4,533,689.00 Budgeted 367.70 1,799.29 ** 4,380,995.07 ** 152,693.93 Remaining 97 % Used glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment Account: 135-50005-020-000 Salaries & Wages 1986 09/06/2019 MUD Payroll 09/06/19 Salaries & Wages 2067 09/20/2019 MUD Payroll 09/20/2019 Salaries & Wages 2103 09/25/2019 MUD Payroll 9/25/2019 Salaries & Wages 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc Account: 135-50005-020-000 Salaries & Wages 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 1986 09/06/2019 MUD Payroll 09/06/19 Overtime 2067 09/20/2019 MUD Payroll 09/20/2019 Overtime Account: 135-50010-020-000 Account: 135-50016-020-000 Account: 135-50016-020-000 Overtime 33,000.00 Budgeted Longevity Longevity 7,445.00 Budgeted Account: 135-50017-020-000 Certification 2067 09/20/2019 MUD Payroll 09/20/2019 Certification Account: 135-50017-020-000 Account: 135-50020-020-000 1986 09/06/2019 2067 09/20/2019 2103 09/25/2019 Account: 135-50020-020-000 MUD Payroll 09/06/19 MUD Payroll 09/20/2019 MUD Payroll 9/25/2019 Certification 8,700.00 Budgeted Retirement Retirement Retirement Retirement Retirement 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Medical Insurance 306,474.59 Totals: 83,101.22 Remaining Totals: (113.62) Remaining 80 % Used 31,025.68 100 % Used 7,445.00 Totals: .00 Remaining 100 % Used Totals: 125.00 Remaining Totals: 5,657.72 Remaining 7,850.00 34,150.25 99 % Used 87 % Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 13,513.99 319,988.58 15,915.20 335,903.78 5,250.00 341,153.78 (2,556.00) 338,597.78 32,123.19 338,597.78 ** 1,012.66 1,075.28 2,087.94 .00 .00 725.00 725.00 1,343.72 1,638.68 485.63 3,468.03 32,038.34 33,113.62 33,113.62 ** 7,445.00 7,445.00 ** 8,575.00 8,575.00 ** 35,493.97 37,132.65 37,618.28 37,618.28 ** Page 20 Check Source Number PR PR PR GL PR PR PR PR PR PR 60,648.82 2,794.26 63,443.08 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2067 09/20/2019 MUD Payroll 09/20/2019 Medical Insurance 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc Account: 135-50026-020-000 Medical Insurance Totals: 67,627.00 Budgeted Account: 135-50027-020-000 Dental Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Dental Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Dental Insurance 60,648.82 7,354.74 Remaining 89 % Used 3,840.15 2,794.22 66,237.30 (5,965.04) 60,272.26 (376.56) 60,272.26 ** 170.29 4,010.44 170.27 4,180.71 PR GL PR PR Account: 135-50027-020-000 1 Dental Insurance Totals: 340.56 4,180.71 ** 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Vision Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Vision Insurance 923.29 Remaining 82 % Used 621.82 27.83 649.65 PR 27.81 677.46 PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 677.46 ** 826.00 Budgeted 148.54 Remaining 82 % Used Account: 135-50029-020-000 — Life Insurance & Other 1946 09/01/2019 September Payroll Benefits A/P Employee Benefits -July 1946 09/01/2019 September Payroll Benefits A/P Employee LTD & STD -July 2110 09/25/2019 September A/P Caf 125 Account: 135-50029-020-000 Account: 135-50030-020-000 1986 09/06/2019 MUD Payroll 09/06/19 2067 09/20/2019 MUD Payroll 09/20/2019 2103 09/25/2019 MUD Payroll 9/25/2019 Account: 135-50030-020-000 3,677.09 175.00 3,852.09 Humana Inc 162.14 4,014.23 METLIFE GROUP BENEFITS 38.00 4,052.23 BenefitMall Life Insurance & Other Totals: 375.14 4,052.23 ** 4,495.00 Budgeted 442.77 Remaining 90 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes IIIF Social Security Taxes 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 1986 09/06/2019 MUD Payroll 09/06/19 Medicare Taxes 5662 AP 5668 AP 5737 AP 20,642.69 862.43 21,505.12 PR 1,032.10 22,537.22 PR 325.50 22,862.72 PR Totals: 6,143.28 Remaining 79 % Used 2,220.03 22,862.72 ** 4,827.73 201.69 5,029.42 PR glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 2067 09/20/2019 MUD Payroll 09/20/2019 2103 09/25/2019 MUD Payroll 9/25/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 9/2019 Page 22 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Medicare Taxes Medicare Taxes 4,827.73 241.37 76.13 5,270.79 5,346.92 PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 519.19 5,346.92 ** 6,784.00 Budgeted 1,437.08 Remaining 79 % Used Account: 135-50040-020-000 Unemployment Taxes 54.00 .00 54.00 Account: 135-50040-020-000 Unemployment Taxes Totals: .00 54.00 ** 1,260.00 Budgeted 1,206.00 Remaining 4 % Used Account: 135-50045-020-000 Workman's Compensation 136 09/01/2019 Insurance/Wrk Comp Expense Sep 12,913.23 1,205.78 14,119.01 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.78 14,119.01 ** 16,941.00 Budgeted 2,821.99 Remaining 83 % 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 ** 400.00 Budgeted 286.00 Remaining 29 % Used Account: 135-50070-020-000 Employee Relations 75.74 .00 75.74 Account: 135-50070-020-000 Employee Relations Totals: .00 75.74 ** 300.00 Budgeted 224.26 Remaining 25 % Used Account: 135-55070-020-000 Independent Labor 2,921.00 .00 2,921.00 Account: 135-55070-020-000 Independent Labor Totals: .00 2,921.00 ** 5,000.00 Budgeted 2,079.00 Remaining 58 % Used Account: 135-55080-020-000 Maintenance & Repairs glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date 2066 09/17/2019 2110 09/25/2019 2110 09/25/2019 2139 09/26/2019 2139 09/26/2019 2139 09/26/2019 2139 09/26/2019 2131 09/30/2019 2131 09/30/2019 2131 09/30/2019 2163 09/30/2019 Account: 135-55080-020-000 JE Description September A/P September A/P September A/P PCard 8/29/2019 PCard 8/29/2019 PCard 8/29/2019 PCard 8/29/2019 September A/P September A/P September A/P September A/P Account: 135-55085-020-000 2163 09/30/2019 September A/P 2170 09/30/2019 September A?P Account: 135-55085-020-000 - 9/26/2019 - 9/26/2019 - 9/26/2019 - 9/26/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment A/C repair for boardroom ceili WWTP parts WWTP parts fly ribbon, torch blade, etc 4 drums shackle, hook, steel demon Steel wool, Fly Trap, cloth rebuild rotating assembly MER 2 ras pump ram neck collectors sewer couplings Maintenance & Repairs 133,000.00 Budgeted 118,153.60 Totals: 10,308.68 Remaining Generator Maint. and Repair washers & oil Generator maintenance Generator Maint. and Repair Totals: 10,000.00 Budgeted 3,840.14 Remaining Account: 135-55090-020-000 Vehicle Maintenance 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 OI1 Change 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 Tires Account: 135-55090-020-000 Account: 135-55105-020-000 2066 09/17/2019 September A/P Account: 135-55105-020-000 Account: 135-55120-020-000 2110 09/25/2019 September A/P Vehicle Maintenance 8,000.00 Budgeted Totals: 5,105.97 Remaining Maintenance-Backhoe/SkidLoader parts/labor/travel time Maintenance-Backhoe/SkidLoader Totals: 7,000.00 Budgeted (1,781.14) Remaining Cleaning Services janitorial svc-August 5,451.63 92 % Used 62 % Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 205.00 118,358.60 174.78 118,533.38 176.65 118,710.03 62.76 118,772.79 257.50 119,030.29 114.36 119,144.65 35.44 119,180.09 2,005.28 121,185.37 1,140.00 122,325.37 300.00 122,625.37 65.95 122,691.32 4,537.72 285.00 423.23 708.23 BRANDON R REED ROANOKE WINNELSON CO. ROANOKE WINNELSON CO. THE HOME DEPOT #6581 DFW WASTE OIL SERVICE THE HOME DEPOT 6581 TRACTOR SUPPLY COMPANY Environmental Improvements DHS AUTOMATION, INC Core & Main LP ATLAS UTILITY SUPPLY CO. 122,691.32 ** 5,736.63 NORTH TEXAS PUMP CO. 6,159.86 NORTH TEXAS PUMP CO. 6,159.86 ** 1,763.70 93.83 1,857.53 GIERISCH CARE 0050292 36 % Used 7,924.90 125 % Used 1,036.50 1,130.33 856.24 856.24 2,894.03 DISCOUNT TIRE TXD 75 2,894.03 ** 8,781.14 HOLT CAT 8,781.14 ** Page 23 Check Source Number 5708 AP 5751 AP 5751 AP PC PC PC PC Inc 5759 AP 5757 AP 5756 AP 5779 AP 5783 AP AP PC PC 5716 AP 87.50 87.50 175.00 MEMBER'S BUILDING MAINTENANCE 5746 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 175.00 ** 5,214.00 Budgeted 5,039.00 Remaining 3 % Used glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 24 Check Source Number Account: 135-55125-020-000 Dumpster Services 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2131 09/30/2019 September A/P 2131 09/30/2019 September A/P sludge haul off Sludge haul off Sludge/grit sludge/grit 63,447.52 2,716.25 1,240.00 1,240.00 2,480.00 66,163.77 67,403.77 68,643.77 71,123.77 L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. 5719 AP 5719 AP 5762 AP 5762 AP Account: 135-55125-020-000 Dumpster Services Totals: 7,676.25 71,123.77 ** 75,000.00 Budgeted 3,876.23 Remaining 95 8 Used Account: 135-55135-020-000 Lab Analysis 2017 09/05/2019 2017 09/05/2019 2066 09/17/2019 2066 09/17/2019 2110 2110 2131 2131 2131 09/25/2019 09/25/2019 09/30/2019 09/30/2019 09/30/2019 2163 09/30/2019 2163 09/30/2019 September A/P September A/P September A/P September A/P September A/P September A/P September A/P September A/P September A/P September A/P September A/P Lab testing lab testing lab testing lab testing lab testing lab testing lab testing lab testing Bio monitoring Lab testing lab testing 30,084.77 317.40 230.00 230.00 317.40 317.40 230.00 317.40 230.00 1,080.00 317.40 230.00 30,402.17 30,632.17 30,862.17 31,179.57 31,496.97 31,726.97 32,044.37 32,274.37 33,354.37 33,671.77 33,901.77 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC HUTHER AND ASSOCIATES,INC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC 5698 5698 5723 5723 5749 5749 5765 5765 5761 5784 5784 AP AP AP AP AP AP AP AP AP AP AP Account: 135-55135-020-000 Lab Analysis ' Totals: 3,817.00 33,901.77 ** 35,000.00 Budgeted 1,098.23 Remaining 97 % Used Account: 135-60010-020-000 Communications/Mobiles 2066 09/17/2019 September A/P Cell phones -Sept 4,554.46 372.26 4,926.72 VERIZON WIRELESS 5734 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 372.26 4,926.72 ** 5,000.00 Budgeted 73.28 Remaining 99 % Used Account: 135-60020-020-000 Electricity 2066 09/17/2019 September A/P Electricity 8/8-9/10 134,288.07 2066 09/17/2019 September A/P Electricity 7/30-8/28 2164 09/30/2019 Town Billed Invoices 1706-1709 AR 20190930-20190930 User: 12,259.93 405.78 (189.88) 146,548.00 146,953.78 146,763.90 HUDSON ENERGY SERVICES, TRI COUNTY ELECTRIC LLC 5717 5731 AP AP AR Account: 135-60020-020-000 Electricity Totals: 12,475.83 146,763.90 ** 154,165.00 Budgeted 7,401.10 Remaining 95 % Used Account: 135-60066-020-000 Publications/Books/Subscripts glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 25 Check Source Number Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 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 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P petty cash-Krolczyk petty cash-Krolczyk 1,658.23 50.00 86.00 1,708.23 1,794.23 TROPHY CLUB MUD PETTY CASH TROPHY CLUB MUD PETTY CASH 5732 5732 AP AP Account: 135-60080-020-000 Schools & Training Totals: 136.00 1,794.23 ** 7,155.00 Budgeted 5,360.77 Remaining 25 % Used Account: 135-60090-020-000 Safety Program 2110 09/25/2019 September A/P 2110 09/25/2019 September A/P gloves safety signs 100.74 9.44 203.77 110.18 313.95 Ritz Safety, LLC Ritz Safety, LLC 5750 5750 AP AP Account: 135-60090-020-000 Safety Program Totals: 213.21 313.95 ** 1,000.00 Budgeted 686.05 Remaining 31 % Used Account: 135-60100-020-000 Travel & per diem 2131 09/30/2019 September A/P Chicago training 544.55 331.75 876.30 Frank Isola 5760 AP Account: 135-60100-020-000 Travel & per diem Totals: 331.75 876.30 ** 1,895.00 Budgeted 1,018.70 Remaining 46 % Used Account: 135-60105-020-000 Rent/Lease Equipment 3,491.07 .00 3,491.07 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 3,491.07 ** 5,000.00 Budgeted 1,508.93 Remaining 70 % Used Account: 135-60125-020-000 Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-020-000 .00 .00 Advertising Totals: .00 .00 ** 2,500.00 Budgeted Account: 135-60135-020-000 TCEQ Fees & Permits Account: 135-60135-020-000 2,500.00 Remaining 0 % Used 16,545.22 .00 16,545.22 TCEQ Fees & Permits Totals: .00 16,545.22 ** 30,000.00 Budgeted Account: 135-60245-020-000 Miscellaneous Expenses Account: 135-60245-020-000 13,454.78 Remaining 55 % Used 4.00 .00 4.00 Miscellaneous Expenses Totals: .00 4.00 ** 450.00 Budgeted Account: 135-60280-020-000 Property Maintenance 2066 09/17/2019 September A/P Door at WWTP Account: 135-60280-020-000 Account: 135-60285-020-000 446.00 Remaining 1 6 Used Property Maintenance Totals: 5,000.00 Budgeted Lawn Equipment & Maintenance 2131 09/30/2019 September A/P Mowing -September Account: 135-60285-020-000 225.18 3,908.68 866.14 Remaining 83 5 Used 4,133.86 REY-MAR CONSTRUCTION 5724 AP 3,908.68 4,133.86 ** 5,639.47 1,480.00 Lawn Equipment & Maintenance Totals: 1,480.00 11,600.00 Budgeted 4,480.53 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I6S Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS Totals: 120,053.00 Budgeted .00 Remaining 120,053.00 Account: 135-60332-020-000 Interfund Transfer Out -Rev I6S 61 % Used 100 % Used 596,238.00 7,119.47 WATTS ELLISON LLC 5769 AP 7,119.47 ** .00 120,053.00 .00 120,053.00 ** .00 596,238.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60332-020-000 Interfund Transfer Out -Rev ISS Totals: .00 596,238.00 ** 596,330.00 Budgeted 92.00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 2101 09/25/2019 TexPool Transfers September TexPool O&M to Rev Bond Resevr 114,752.00 10,432.00 125,184.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 125,184.00 ** 125,187.00 Budgeted 3.00 Remaining 100 % 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 o 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 % Used Account: 135-65005-020-000 Fuel & Lube 2116 09/24/2019 Fuel Fuel -June 11,713.43 390.08 12,103.51 US Bank Voyager Fleet Systems 5768 AP Account: 135-65005-020-000 Account: 135-65010-020-000 Account: 135-65010-020-000 Fuel & Lube Totals: 390.08 12,103.51 ** 12,500.00 Budgeted 396.49 Remaining 97 % Used Uniforms 2,713.30 .00 2,713.30 Uniforms Totals: .00 2,713.30 ** 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals 2066 09/17/2019 September A/P sodium hypo 2,781.70 Remaining 49 % Used 31,063.09 569.00 31,632.09 Valley Solvent Company, INC 5733 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-65030-020-000 Chemicals Totals: 569.00 31,632.09 ** 30,000.00 Budgeted (1,632.09) Remaining 105 % Used Account: 135-65035-020-000 Small Tools 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 grinder 1,004.27 139.00 1,143.27 THE HOME DEPOT 6581 PC Account: 135-65035-020-000 Small Tools Totals: 139.00 1,143.27 ** 1,200.00 Budgeted 56.73 Remaining 95 % Used Account: 135-65040-020-000 Safety Equipment 1,637.69 .00 1,637.69 Account: 135-65040-020-000 Safety Equipment Totals: .00 1,637.69 ** 1,200.00 Budgeted Account: 135-65045-020-000 Lab Supplies 2110 09/25/2019 September A/P chemicals 2110 09/25/2019 September A/P lab supplies 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 distilled water (437.69) Remaining 136 % Used 16,571.83 14.55 16,586.38 HACH COMPANY 5740 AP (124.36) 16,462.02 HACH COMPANY 5740 AP 3.96 16,465.98 TOM THUMB #1789 PC Account: 135-65045-020-000 Lab Supplies Totals: (105.85) 16,465.98 ** Account: 135-69005-020-000 Account: 135-69005-020-000 20,000.00 Budgeted Capital Outlays Capital Outlays 735,822.00 Budgeted 3,534.02 Remaining 572,131.16 82 % Used Totals: 163,690.84 Remaining 78 % Used Account: 135-69008-020-000 Short Term Debt -Principal 58,933.73 Account: 135-69008-020-000 Short Term Debt -Principal 58,934.00 Budgeted Totals: .27 Remaining Account: 135-69009-020-000 Short Term Debt -Interest 100 % Used .00 572,131.16 .00 572,131.16 ** .00 58,933.73 .00 58,933.73 ** glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 JE Detail Beginning Balance Description/Comment 9,232.74 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 9,232.74 Page 29 Check Source Number Department 20 Totals: 1,500.00 Budgeted 91,899.17 Monthly Total .00 Remaining 100 % Used 3,100,296.00 Budgeted 2,551,671.81 ** 548,624.19 Remaining 82 % Used Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 9,232.74 ** 9,233.00 Budgeted .26 Remaining 100 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 Account: 135-69195-020-000 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 ** Department 20 Totals: 1,500.00 Budgeted 91,899.17 Monthly Total .00 Remaining 100 % Used 3,100,296.00 Budgeted 2,551,671.81 ** 548,624.19 Remaining 82 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 136 09/01/2019 Insurance/Wrk Comp Expense Sep Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 23.32 2.09 25.41 GL 30.00 Budgeted 4.59 Remaining 85 5 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 2.09 25.41 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 Account: 135-60075-026-000 Meetings 2066 09/17/2019 September A/P Petty cash-Dandria 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 candy 650.00 .00 650.00 Totals: 100.00 Remaining 87 5 Used .00 650.00 ** 92.87 2.48 95.35 TROPHY CLUB MUD PETTY CASH 9.48 104.83 WAL-MART #5247 5732 AP PC Account: 135-60075-026-000 Meetings Totals: 11.96 104.83 ** 1,300.00 Budgeted Account: 135-60080-026-000 Schools & Training 1,195.17 Remaining 8 % Used 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 % 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 8 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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,500.30 ** 14.05 Monthly Total 13,230.00 Budgeted 10,729.70 Remaining 19 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 32 Account: 135-50005-030-000 Salaries & Wages 1986 09/06/2019 MUD Payroll 09/06/19 Salaries & Wages 2067 09/20/2019 MUD Payroll 09/20/2019 Salaries & Wages 2103 09/25/2019 MUD Payroll 9/25/2019 Salaries & Wages 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc 329,125.88 14,607.18 17,172.75 6,000.00 (2,556.00) 343,733.06 360,905.81 366,905.81 364,349.81 PR PR PR GL Account: 135-50005-030-000 Salaries & Wages Totals: 35,223.93 364,349.81 ** 441,006.00 Budgeted 76,656.19 Remaining 83 % 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 .00 1,832.50 Account: 135-50016-030-000 Longevity Totals: .00 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 o Used Account: 135-50020-030-000 Retirement 1986 09/06/2019 MUD 2067 09/20/2019 MUD 2103 09/25/2019 MUD Payroll Payroll Payroll 09/06/19 09/20/2019 9/25/2019 Retirement Retirement Retirement 31,979.21 1,351.17 1,588.47 555.02 33,330.38 34,918.85 35,473.87 PR PR PR Account: 135-50020-030-000 Retirement Totals: 3,494.66 35,473.87 ** 41,148.00 Budgeted 5,674.13 Remaining 86 % Used Account: 135-50026-030-000 Medical Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Medical Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Medical Insurance 2171 09/30/2019 MUD Contrib Adj as of 09/2019 MUD Contribution Adjustment 2174 09/30/2019 Budget Amend #2 Aetna Rev Xfer Aetna Self Fund Reimb-Misc Inc 53,177.16 2,938.23 2,744.38 (1,242.85) (5,965.04) 56,115.39 58,859.77 57,616.92 51,651.88 PR PR GL GL Account: 135-50026-030-000 Medical Insurance Totals: (1,525.28) 51,651.88 ** 61,895.00 Budgeted 10,243.12 Remaining 83 % Used Account: 135-50027-030-000 Dental Insurance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1986 09/06/2019 MUD Payroll 09/06/19 Dental Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Dental Insurance 3,053.16 202.95 3,256.11 PR 153.19 3,409.30 PR Account: 135-50027-030-000 Dental Insurance Totals: 356.14 3,409.30 ** 4,291.00 Budgeted 881.70 Remaining 79 6 Used Account: 135-50028-030-000 _ Vision Insurance 1986 09/06/2019 MUD Payroll 09/06/19 Vision Insurance 2067 09/20/2019 MUD Payroll 09/20/2019 Vision Insurance 488.72 34.28 523.00 PR 24.37 547.37 PR Account: 135-50028-030-000 1 Vision Insurance Totals: 58.65 547.37 ** 701.00 Budgeted 153.63 Remaining 78 6 Used Account: 135-50029-030-000 Life Insurance & Other 1946 09/01/2019 September Payroll Benefits A/P Employee Benefits -July 1946 09/01/2019 September Payroll Benefits A/P Employee LTD & STD -July 2110 09/25/2019 September A/P Caf 125 2171 09/30/2019 MUD Contrib Adj as of 09/2019 MUD Contribution Adjustment 3,339.86 149.52 3,489.38 Humana Inc 5662 AP 142.90 3,632.28 METLIFE GROUP BENEFITS 5668 AP 20.00 3,652.28 BenefitMall 5737 AP 221.41 3,873.69 GL Account: 135-50029-030-000 Life Insurance & Other Totals: 533.83 3,873.69 ** 4,495.00 Budgeted 621.31 Remaining 86 6 Used Account: 135-50030-030-000 Social Security Taxes 1986 09/06/2019 MUD Payroll 09/06/19 2067 09/20/2019 MUD Payroll 09/20/2019 2103 09/25/2019 MUD Payroll 9/25/2019 Social Security Taxes Social Security Taxes Social Security Taxes 19,533.52 830.01 20,363.53 PR 999.19 21,362.72 PR 372.00 21,734.72 PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,201.20 21,734.72 ** 27,580.00 Budgeted 5,845.28 Remaining 79 6 Used Account: 135-50035-030-000 Medicare Taxes 1986 09/06/2019 MUD Payroll 09/06/19 2067 09/20/2019 MUD Payroll 09/20/2019 2103 09/25/2019 MUD Payroll 9/25/2019 Medicare Taxes Medicare Taxes Medicare Taxes 4,568.33 194.12 4,762.45 PR 233.68 4,996.13 PR 87.01 5,083.14 PR Account: 135-50035-030-000 Medicare Taxes Totals: 514.81 5,083.14 ** 6,450.00 Budgeted 1,366.86 Remaining 79 % Used Account: 135-50040-030-000 Unemployment Taxes glpdatb2 skrolczyk 15:36 10/11/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 136 09/01/2019 Insurance/Wrk Comp Expense Sep Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Account: 135-50070-030-000 2066 09/17/2019 September A/P Account: 135-50070-030-000 Account: 135-55030-030-000 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 Account: 135-55030-030-000 Account: 135-55070-030-000 2110 09/25/2019 September A/P 2166 09/30/2019 September A/P 2166 09/30/2019 September A/P Account: 135-55070-030-000 Workman's Compensation 1,295.00 Budgeted Pre-emp Physicals/Testing Totals: 1,200.42 Remaining Totals: 55.96 Remaining Pre-emp Physicals/Testing Totals: 500.00 Budgeted 320.05 Remaining Employee Relations Petty cash-Dandria Employee Relations 5,000.00 Budgeted Software & Support - 9/26/2019 Internet - 9/26/2019 internet - 9/26/2019 internet - 9/26/2019 Adobe Subscription Software & Support Totals: 1,834.71 Remaining Totals: 77,849.00 Budgeted 22,785.87 Remaining Independent Labor Town/MUD appraisel gm -September gm -September Independent Labor Totals: 175,000.00 Budgeted 59.58 1,132.45 179.95 3,115.29 54,893.31 138,114.03 Program: Transaction Detail .00 5 8 Used .00 106.59 96 9 Used 36 % Used 63 % Used 106.59 .00 .00 50.00 50.00 42.02 42.02 53.33 32.45 71 % Used 22,476.66 Remaining 87 % Used 169.82 2,625.00 11,720.00 64.31 Transaction Vendor_Name Detail (SUBTOTAL) 59.58 59.58 ** 1,239.04 1,239.04 ** 179.95 179.95 ** 3,165.29 TROPHY CLUB MUD PETTY CASH 3,165.29 ** 54,935.33 54,977.35 55,030.68 55,063.13 ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 55,063.13 ** 140,739.03 TOWN OF TROPHY CLUB 152,459.03 Carman Consulting LLC. 152,523.34 Carman Consulting LLC. 152,523.34 ** Page 34 Check Source Number GL 5732 AP PC PC PC PC 5753 AP 5800 AP 5800 AP glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 35 Check Source Number 1903 09/01/2019 September A?P 2066 09/17/2019 September A/P 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 answering svc Answering service phone phone phone 16,034.93 207.75 194.75 167.29 789.28 466.83 16,242.68 16,437.43 16,604.72 17,394.00 17,860.83 KEYSTONE PARK SECRETARIAL KEYSTONE PARK SECRETARIAL ATT*BILL PAYMENT ATT*BUS PHONE PMT ATT*BUS PHONE PMT 5625 AP 5718 AP PC PC PC Account: 135-55080-030-000 Maintenance & Repairs . 2110 09/25/2019 September A/P 2170 09/30/2019 September A?P pest control -quarterly Replace breakers in office 4,975.00 110.00 385.99 5,085.00 5,470.99 Exclusive Pest Control HC I&E LLC 5739 AP AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 495.99 5,470.99 ** 20,000.00 Budgeted 14,529.01 Remaining 27 % Used Account: 135-55085-030-000 Generator Maint. and Repair 927.52 .00 927.52 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 927.52 ** 10,000.00 Budgeted 9,072.48 Remaining 9 % Used Account: 135-55120-030-000 Cleaning Services 2110 09/25/2019 September A/P janitorial svc-August 8,690.60 869.06 9,559.66 MEMBER'S BUILDING MAINTENANCE 5746 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 9,559.66 ** 10,000.00 Budgeted 440.34 Remaining 96 % Used Account: 135-55160-030-000 Professional Outside Services 2110 09/25/2019 September A/P FY 20 rate/Budget projects 68,964.00 462.50 69,426.50 NEW GEN STRATEGIES & SOLUTIONS 5747 AP Account: 135-55160-030-000 Professional Outside Services Totals: 462.50 69,426.50 ** 66,055.00 Budgeted (3,371.50) Remaining 105 o Used Account: 135-55205-030-000 Utility Billing Contract 2066 09/17/2019 September A/P 2170 09/30/2019 September A?P Water billings -Aug Water billings -September 5,801.84 586.78 585.85 6,388.62 6,974.47 DATAPROSE LLC DATAPROSE LLC 5711 AP AP Account: 135-55205-030-000 Utility Billing Contract Totals: 1,172.63 6,974.47 ** 9,000.00 Budgeted 2,025.53 Remaining 77 % Used Account: 135-60005-030-000 Telephone 1903 09/01/2019 September A?P 2066 09/17/2019 September A/P 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 answering svc Answering service phone phone phone 16,034.93 207.75 194.75 167.29 789.28 466.83 16,242.68 16,437.43 16,604.72 17,394.00 17,860.83 KEYSTONE PARK SECRETARIAL KEYSTONE PARK SECRETARIAL ATT*BILL PAYMENT ATT*BUS PHONE PMT ATT*BUS PHONE PMT 5625 AP 5718 AP PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 answering service 16,034.93 2164 09/30/2019 Town Billed Invoices 1706-1709 AR 20190930-20190930 User: 14.99 17,875.82 RINGCENTRAL, INC PC (180.00) 17,695.82 AR Account: 135-60005-030-000 Telephone Totals: 1,660.89 17,695.82 ** 23,500.00 Budgeted 5,804.18 Remaining 75 6 Used Account: 135-60010-030-000 Communications/Mobiles 2066 09/17/2019 September A/P Cell phones -Sept 2067 09/20/2019 MUD Payroll 09/20/2019 Communications/Mobiles 2,613.35 89.18 2,702.53 VERIZON WIRELESS 5734 AP 150.00 2,852.53 PR Account: 135-60010-030-000 Communications/Mobiles Totals: 239.18 2,852.53 ** 4,000.00 Budgeted 1,147.47 Remaining 71 % Used Account: 135-60020-030-000 Electricity/Gas 2066 09/17/2019 September A/P gexa energy 7/10-8/8 5,692.89 526.42 6,219.31 TOWN OF TROPHY CLUB 5730 AP Account: 135-60020-030-000 Electricity/Gas Totals: 526.42 6,219.31 ** 8,690.00 Budgeted 2,470.69 Remaining 72 % Used Account: 135-60025-030-000 Water 2163 09/30/2019 September A/P water -September 623.21 118.09 741.30 TROPHY CLUB MUD (WATER BILLS) 5785 AP 2164 09/30/2019 Town Billed Invoices 1706-1709 AR 20190930-20190930 User: (59.04) 682.26 AR Account: 135-60025-030-000 ' 2,000.00 Budgeted Totals: 1,317.74 Remaining 34 6 Used Account: 135-60035-030-000 Postage 2066 09/17/2019 September A/P Water billings -Aug 2170 09/30/2019 September A?P Water billings -September 59.05 682.26 ** 18,375.27 1,638.56 1,637.84 20,013.83 DATAPROSE LLC 21,651.67 DATAPROSE LLC 5711 AP AP Account: 135-60035-030-000 Postage Totals: 3,276.40 21,651.67 ** Account: 135-60040-030-000 1987 09/06/2019 Child Support Fee 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2072 09/20/2019 Child Support Fee 30,000.00 Budgeted 8,348.33 Remaining 72 % Used Service Charges & Fees Dig Tess -August Direct send fees 59,536.89 1.50 59,538.39 GL 220.40 59,758.79 Texas Excavation Safety System 5728 AP 50.00 59,808.79 Fisery Solutions, LLC 5714 AP 1.50 59,810.29 GL glpdatb2 skrolczyk Trophy Club MUD No.1 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 37 2129 09/30/2019 Pace Credit Card Fees 2129 09/30/2019 Pace Credit Card Fees 2170 09/30/2019 September A?P 2170 09/30/2019 September A?P Dig Tess -September Direct send fees -September 59,536.89 6,005.74 65,816.03 127.65 65,943.68 242.25 66,185.93 Texas Excavation Safety System 50.00 66,235.93 Fisery Solutions, LLC GL GL AP AP Account: 135-60040-030-000 Service Charges & Fees Totals: 6,699.04 66,235.93 ** 67,560.00 Budgeted 1,324.07 Remaining 98 % Used Account: 135-60050-030-000 Bad Debt Expense ' .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 136 09/01/2019 Insurance/Wrk Comp Expense Sep 69,330.03 6,302.75 75,632.78 GL Account: 135-60055-030-000 Insurance Totals: 6,302.75 75,632.78 ** 75,633.00 Budgeted .22 Remaining 100 % 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 % Used Account: 135-60070-030-000 Dues & Memberships 4,269.25 .00 4,269.25 Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,269.25 ** 6,000.00 Budgeted 1,730.75 Remaining 71 % Used Account: 135-60075-030-000 Meetings 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 Donuts for Safety Meeting - 9/26/2019 fruit for safety meeting 133.82 31.66 10.99 165.48 176.47 SQ *SQ *CK NDD INC TOM THUMB #1780 PC PC Account: 135-60075-030-000 Meetings Totals: 42.65 176.47 ** 400.00 Budgeted 223.53 Remaining 44 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 magnets Account: 135-60079-030-000 Account: 135-60080-030-000 Account: 135-60080-030-000 1 Account: 135-60100-030-000 1986 09/06/2019 MUD Payroll 09/06/19 2131 09/30/2019 September A/P Public Education Totals: 260.99 300.00 560.99 RICHEY COMPANY PC 6,000.00 Budgeted 5,439.01 Remaining 9 % Used Schools & Training Schools & Training Totals: 8,950.00 Budgeted Travel & per diem Travel & per diem tolls to lab 7,778.00 Remaining 1,172.00 148.99 13 % Used 300.00 .00 560.99 ** 1,172.00 .00 1,172.00 ** 61.04 7.88 210.03 217.91 NTTA PR 5763 AP Account: 135-60100-030-000 Travel & per diem Totals: 68.92 217.91 ** 4,345.00 Budgeted 4,127.09 Remaining 5 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 2066 09/17/2019 September A/P Public Tax Hearing Notice 2131 09/30/2019 September A/P Sludge haul off bid 625.00 625.00 Star -Telegram Media 5726 AP 596.76 1,221.76 Star -Telegram Media 5767 AP Account: 135-60125-030-000 Advertising Totals: 1,221.76 1,221.76 ** Account: 135-60235-030-000 2066 09/17/2019 September A/P .00 Budgeted (1,221.76) Remaining 0 % Used Security monitoring svc-sept 264.00 24.00 288.00 Digital Air Control, Inc 5712 AP Account: 135-60235-030-000 Security Totals: 24.00 288.00 ** 1,288.00 Budgeted 1,000.00 Remaining 22 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 124.49 Miscellaneous Expenses Totals: 500.00 Budgeted 375.51 Remaining 25 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Account: 135-60360-030-000 Furniture/Equipment < $5000 2139 09/26/2019 PCard 8/29/2019 - 9/26/2019 chairs for GM Office Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 921.01 Remaining Account: 135-65010-030-000 Uniforms 2066 09/17/2019 September A/P staff and directors uniform Account: 135-65010-030-000 Uniforms Totals: 2,050.00 Budgeted 1,304.30 Remaining Account: 135-65055-030-000 Hardware 2066 09/17/2019 September A/P Hardware -Desiree & taylor new .00 124.49 .00 124.49 ** .00 0 % Used .00 .00 .00 ** 239.99 1,339.00 63 % Used 1,578.99 PEARCE OFFICE FURNITUR PC 1,339.00 1,578.99 ** 745.70 745.70 RON MONTGOMERY & ASSOC INC 36 % Used 3,554.79 1,971.08 5725 AP 745.70 ** 5,525.87 M3 Networks 5721 AP Account: 135-65055-030-000 Hardware Totals: 1,971.08 5,525.87 ** Account: 135-65085-030-000 2110 09/25/2019 September A/P 2110 09/25/2019 September A/P 2131 09/30/2019 September A/P 2131 09/30/2019 September A/P Account: 135-65085-030-000 7,064.00 Budgeted Office Supplies office supplies office supplies office supplies office supplies Office Supplies 6,000.00 Budgeted 1,538.13 Remaining 78 % Used 6,410.94 169.13 9.80 16.17 44.89 Totals: (650.93) Remaining 111 % Used 239.99 6,580.07 OFFICE DEPOT, INC 6,589.87 OFFICE DEPOT, INC 6,606.04 OFFICE DEPOT, INC 6,650.93 OFFICE DEPOT, INC 6,650.93 ** 5748 AP 5748 AP 5764 AP 5764 AP glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 40 Check Source Number Account: 135-65090-030-000 Printer Supplies & Maintenance Account: 135-65090-030-000 Account: 135-65095-030-000 2066 09/17/2019 September A/P 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 2139 09/26/2019 PCard 8/29/2019 2168 09/26/2019 Pcard 8/27/19 - Account: 135-65095-030-000 Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining O % Used .00 .00 .00 .00 ** Maintenance Supplies Petty cash-Dandria break room supplies break room supplies febreeze & spoons candy - 9/26/2019 - 9/26/2019 - 9/26/2019 8/28/19 Maintenance Supplies 4,000.00 Budgeted Totals: (849.36) Remaining 4,480.32 121 % Used 62.16 159.55 120.89 22.67 3.77 369.04 4,542.48 4,702.03 4,822.92 4,845.59 4,849.36 TROPHY CLUB MUD PETTY CASH SAMSCLUB.COM SAMSCLUB.COM SAMSCLUB #4795 WM SUPERCENTER #5247 4,849.36 ** 5732 AP PC PC PC PC Account: 135-65105-030-000 1 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** Account: 135-69005-030-000 2069 09/17/2019 September A/P 2069 09/17/2019 September A/P 2,500.00 Budgeted 2,500.00 Remaining Capital Outlays Security project phase II GIS Web Map Host O % Used 107,238.98 21,725.92 128,964.90 3RD EYE SURVEILLANCE SYSTEMS 5706 AP 12,520.04 141,484.94 Halff Associates, INC 5715 AP Account: 135-69005-030-000 Capital Outlays Totals: 34,245.96 141,484.94 ** Account: 135-69170-030-000 2066 09/17/2019 September A/P 2110 09/25/2019 September A/P Account: 135-69170-030-000 Department 30 Totals: 204,887.00 Budgeted 63,402.06 Remaining Copier Lease Installments copier lease -Sept copies ' Copier Lease Installments Totals: 4,000.00 Budgeted 693.95 Remaining 118,220.38 Monthly Total 69 % Used 3,011.34 165.00 3,176.34 TIAA COMMERCIAL FINANCE 129.71 3,306.05 KYOCERA DOCUMENT SOLUTIONS 83 % Used 1,462,425.00 Budgeted 294.71 3,306.05 ** 1,155,746.74 ** 306,678.26 Remaining 79 % Used 5729 AP 5744 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2066 09/17/2019 September A/P 2170 09/30/2019 September A?P 2170 09/30/2019 September A?P Legal Westlake easement legal Legal -drive Legal Legal -Drive 122,010.57 2,622.50 124,633.07 WHITAKER CHALK SWINDLE 5735 AP 3,090.00 127,723.07 McLean & Howard, L.L.P. 5722 AP 1,050.00 128,773.07 McLean & Howard, L.L.P. 5722 AP 6,000.00 134,773.07 McLean & Howard, L.L.P. AP 1,050.00 135,823.07 McLean & Howard, L.L.P. AP Account: 135-55045-039-000 Legal Totals: 13,812.50 135,823.07 ** 137,000.00 Budgeted 1,176.93 Remaining 99 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: 26,459.53 ** 30,800.00 Budgeted 4,340.47 Remaining 86 8 Used Account: 135-55060-039-000 Appraisal 2017 09/05/2019 September A/P 4th quarter allotment 8,945.42 2,111.10 11,056.52 DENTON CENTRAL APPRAISAL DISTR 5690 AP Account: 135-55060-039-000 Appraisal Totals: 2,111.10 11,056.52 ** 11,714.00 Budgeted 657.48 Remaining 94 6 Used Account: 135-55065-039-000 1 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 5 Used Department 39 Totals: 176,992.12 ** 15,923.60 Monthly Total 184,314.00 Budgeted 7,321.88 Remaining 96 8 Used Fund 135 Totals: (681,408.34) (207,030.27) Monthly Total (396,745.00) Budgeted 284,663.34 Remaining 172 % Used glpdatb2 skrolczyk 15:36 10/11/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: 9/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 Page 43 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-010-000 GASB Replacement 2173 09/30/2019 Budget Amendment #2 Acct Trsfr VFD- Reserve reallocation 266,613.00 (116,613.00) 150,000.00 GL Account: 137-69195-010-000 GASB Replacement Totals: (116,613.00) 150,000.00 ** .00 Budgeted (150,000.00) Remaining 0 % Used Department 10 Totals: 150,000.00 ** (116,613.00) Monthly Total .00 Budgeted (150,000.00) Remaining 0 % Used Fund 137 Totals: (36,420.00) (116,613.00) Monthly Total .00 Budgeted 36,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET SEPTEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 644,683 TOTAL ASSETS 644,683 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 699,690 TOTAL LIABILITIES 699,690 FUND BALANCE ASSIGNED FUND BALANCE (1,479,465) NET REVENUES / EXPENDITURES 1,424,458 TOTAL FUND BALANCE (55,007) TOTAL LIABILITIES AND FUND BALANCE 644,683 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 15:36 10/11/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 1,253.05- 7,423.97- 7,423.97 517-49105-000-000 Bond Proceeds 1,743,522.00- 1,743,522.00 Subtotal: 1,253.05- 1,750,945.97- 1,750,945.97 Program number: 1,253.05- 1,750,945.97- 1,750,945.97 Department number: Revenues 1,253.05- 1,750,945.97- 1,750,945.97 Revenues Subtotal 1,253.05- 1,750,945.97- 1,750,945.97 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 15:36 10/11/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 34,822.56 326,487.86 326,487.86 - Subtotal: 34,822.56 326,487.86 326,487.86 - Program number: 34,822.56 326,487.86 326,487.86 - Department number: Wastewater 34,822.56 326,487.86 326,487.86 - Expenditures Subtotal 34,822.56 326,487.86 326,487.86 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 33,569.51 1,424,458.11- 1,424,458.11 glpdatb2 skrolczyk 15:36 10/11/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: 9/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,253.05) Monthly Total 1,743,522.00 Remaining 0 % Used (1,750,945.97) ** .00 Budgeted 1,750,945.97 Remaining 0 % Used Account: 517-49011-000-000 Interest Income 2158 09/30/2019 Bank Interest- September (6,170.92) (1,253.05) (7,423.97) GL Account: 517-49011-000-000 Interest Income Totals: (1,253.05) (7,423.97) ** .00 Budgeted 7,423.97 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,253.05) Monthly Total 1,743,522.00 Remaining 0 % Used (1,750,945.97) ** .00 Budgeted 1,750,945.97 Remaining 0 % Used glpdatb2 skrolczyk 15:36 10/11/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE Number JE Date Account: 517-69005-020-000 2066 09/17/2019 2066 09/17/2019 2066 09/17/2019 2110 09/25/2019 2163 09/30/2019 2163 09/30/2019 2166 09/30/2019 2170 09/30/2019 JE Description September A/P September A/P September A/P September A/P September A/P September A/P September A/P September A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 9/2019 JE Detail Beginning Balance Description/Comment Capital Outlays WWTP legal WWTP Legal WWTP Improvements WWTP crane/soil testing crane? pilar soil testing WWTP Improvements gm -September WWTP Legal 291,665.30 Program: Transaction Detail 2,252.50 5,850.00 9,353.02 2,638.75 845.00 10,152.50 220.79 3,510.00 Transaction Vendor_Name Detail (SUBTOTAL) 293,917.80 299,767.80 309,120.82 311,759.57 312,604.57 322,757.07 322,977.86 326,487.86 Dubois Bryant Campbell LLP CP&Y/WALLACE GROUP, INC. CP&Y/WALLACE GROUP, INC. Wiss, Janney, Elstner Assoc Wiss, Janney, Elstner Assoc WEBBER-CADAGUA PARTNERS Carman Consulting LLC. CP&Y/WALLACE GROUP, INC. Page 45 Check Source Number 5713 AP 5710 AP 5710 AP 5754 AP 5787 AP 5786 AP 5800 AP AP Account: 517-69005-020-000 Capital Outlays Totals: 34,822.56 326,487.86 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted (326,487.86) Remaining 34,822.56 Monthly Total 33,569.51 Monthly Total 0 % Used .00 Budgeted 326,487.86 ** (326,487.86) Remaining 0 % Used (1,424,458.11) .00 Budgeted 1,424,458.11 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET SEPTEMBER 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 780,339 TOTAL ASSETS 780,339 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 754,200 (55,552) 698,648 780,339 glbase_tbam skrolczyk 15:36 10/11/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: 9/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 Subtotal: 12,981.05- 12,981.05 Program number: 12,981.05- 12,981.05 Department number: Revenues 12,981.05- 12,981.05 Revenues Subtotal 12,981.05- 12,981.05 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 519 2016 Rev Bond Const -SWIFT Account Description Department: 10 Water Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 9/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 18 519-69005-010-000 Capital Outlays 68,533.20 68,533.20 68,533.20 - Subtotal: 68,533.20 68,533.20 68,533.20 - Program number: 68,533.20 68,533.20 68,533.20 - Department number: Water 68,533.20 68,533.20 68,533.20 - Expenditures Subtotal 68,533.20 68,533.20 68,533.20 - Fund number: 519 2016 Rev Bond Const -SWIFT 68,533.20 55,552.15 55,552.15- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 9/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 Account: 519-49011-000-000 Department Totals: (12,981.05) .00 (12,981.05) Interest Income Totals: .00 (12,981.05) ** .00 Budgeted 12,981.05 Remaining 0 6 Used .00 Monthly Total .00 Budgeted (12,981.05) ** 12,981.05 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: 10 Water Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/CommentBalance Detail Detail Number (SUBTOTAL) Page 47 Account: 519-69005-010-000 Capital Outlays 2163 09/30/2019 September A/P NS II 48" water main 68,533.20 68,533.20 CITY OF FORT WORTH 5780 AP Account: 519-69005-010-000 Capital Outlays Totals: 68,533.20 68,533.20 ** Department 10 Totals: Fund 519 Totals: .00 Budgeted (68,533.20) Remaining 0 % Used 68,533.20 Monthly Total .00 Budgeted 68,533.20 Monthly Total .00 Budgeted 68,533.20 ** (68,533.20) Remaining 0 % Used 55,552.15 (55,552.15) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET SEPTEMBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 591,594 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,461,169 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 (366,246) 4,827,415 4,461,169 4,461,169 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 15:36 10/11/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 1,021.08- 36,266.73- 36,266.73 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: 1,021.08- 5,245,166.54- 5,245,166.54 Program number: 1,021.08- 5,245,166.54- 5,245,166.54 Department number: 1,021.08- 5,245,166.54- 5,245,166.54 Revenues Subtotal 1,021.08- 5,245,166.54- 5,245,166.54 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 15:36 10/11/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 22,958.74 188,797.58 188,797.58 - Subtotal: 22,958.74 188,797.58 188,797.58- 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: 22,958.74 417,751.90 417,751.90 - Department number: Water Department 22,958.74 417,751.90 417,751.90 - Expenditures Subtotal 22,958.74 417,751.90 417,751.90 - Fund number: 520 Revenue Bond 16" Waterline 21,937.66 4,827,414.64- 4,827,414.64 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 9/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 2158 09/30/2019 Bank Interest- September (35,245.65) (1,021.08) (36,266.73) GL Account: 520-49011-000-000 Interest Income Totals: (1,021.08) (36,266.73) ** .00 Budgeted 36,266.73 Remaining 0 % Used Account: 520-49105-000-000 Bond Proceeds (5,229,675.71) .00 (5,229,675.71) Account: 520-49105-000-000 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 Interfund Transfer In -Gen Fund Account: 520-49141-000-000 Interfund Transfer In -Gen Fund Totals: .00 Budgeted (25,000.00) Remaining 25,000.00 0 % Used .00 25,000.00 .00 25,000.00 ** Department Totals: (5,245,166.54) ** (1,021.08) Monthly Total .00 Budgeted 5,245,166.54 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 2017 09/05/2019 September A/P 2069 09/17/2019 September A/P Capital Outlays 16" waterline project -easement 16" water line 165,838.84 250.00 166,088.84 ONCOR ELECTRIC DELIVERY 5697 AP 22,708.74 188,797.58 Halff Associates, INC 5715 AP Account: 520-69005-010-000 Capital Outlays Totals: 22,958.74 188,797.58 ** .00 Budgeted (188,797.58) Remaining 0 % Used Account: 520-70005-010-000 Paying Agent Fee 800.00 .00 800.00 Account: 520-70005-010-000 Paying Agent Fee Totals: .00 800.00 ** .00 Budgeted (800.00) Remaining 0 % Used Account: 520-70020-010-000 Bond Issuance Costs 228,154.32 .00 228,154.32 Account: 520-70020-010-000 Bond Issuance Costs Totals: .00 228,154.32 ** .00 Budgeted (228,154.32) Remaining 0 % Used Department 10 Totals: 417,751.90 ** 22,958.74 Monthly Total .00 Budgeted (417,751.90) Remaining 0 % Used Fund 520 Totals: (4,827,414.64) 21,937.66 Monthly Total .00 Budgeted 4,827,414.64 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 803,457 TOTAL ASSETS 803,457 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 196,547 803,457 803,457 glbase_tbam skrolczyk 15:36 10/11/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: 9/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,404.44- 16,163.13- 4,600.00- 55,200.00- 10,432.00- 125,184.00- 16,436.44- 196,547.13- 16,436.44- 196,547.13- 16,436.44- 196,547.13- 16,436.44- 196,547.13- 16,436.44- 196,547.13- 323.263 11,163.13 100.013 7.00 99.998 3.00- 106.024 11,167.13 106.024 11,167.13 106.024 11,167.13 106.024 11,167.13 106.024 11,167.13 Page 21 glpdatb2 skrolczyk 15:36 10/11/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 2158 09/30/2019 Bank Interest- September Account: 528-49011-000-000 Trophy Club MUD No.1 Page 50 Detailed Accounting Trial Balance Program: Period Ending: 9/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (14,758.69) 11,163.13 Remaining 323 % Used Account: 528-49142-000-000 Interfund transfer in -Water 2101 09/25/2019 TexPool Transfers September TexPool O&M to Rev Bond Resevr (50,600.00) Account: 528-49142-000-000 Interfund transfer in -Water Totals: (55,193.00) Budgeted 7.00 Remaining (1,404.44) (16,163.13) GL (1,404.44) (16,163.13) ** (4,600.00) (55,200.00) GL 100 % Used Account: 528-49143-000-000 Interfund transfer an -WW 2101 09/25/2019 TexPool Transfers September TexPool 0&M to Rev Bond Resevr (114,752.00) Account: 528-49143-000-000 Department Totals: Fund 528 Totals: Interfund transfer in -WW Totals: (125,187.00) Budgeted (16,436.44) Monthly Total (16,436.44) Monthly Total (4,600.00) (55,200.00) ** (10,432.00) (125,184.00) GL (3.00) Remaining 100 9 Used (10,432.00) (125,184.00) ** (196,547.13) ** (185,380.00) Budgeted 11,167.13 Remaining 106 % Used (196,547.13) (185,380.00) Budgeted 11,167.13 Remaining 106 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET SEPTEMBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 82,954 11,850 94,804 11,850 11,850 53,289 29,665 82,954 TOTAL LIABILITIES AND FUND BALANCE 94,804 glbase_tbam skrolczyk 15:36 10/11/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 Budget Summary with Amendment Department: Revenues Program: Period Ending: 9/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- 532.13- 15.14- 90.54- 679,042.65- 1,914.20 2,358.16- 98.817 -106.344 117.908 8,132.35- 3,714.20- 358.16 Page 22 Subtotal: 690,975.00- 690,975.00- 637.81- 679,486.61- 98.337 11,488.39- 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- 147.13- 37,354.19- 215,979.00- 100.000 2,000.00- 37,354.19 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 120,053.00- 100.000 Subtotal: 338,032.00- 338,032.00- 147.13- 373,386.19- 110.459 35,354.19 Program number: 1,029,007.00- 1,029,007.00- 784.94- 1,052,872.80- 102.319 23,865.80 Department number: Revenues 1,029,007.00- 1,029,007.00- 784.94- 1,052,872.80- 102.319 23,865.80 Revenues Subtotal 1,029,007.00- 1,029,007.00- 784.94- 1,052,872.80- 102.319 23,865.80 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 15:36 10/11/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense -Tax 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 Expenditures Subtotal 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 784.94- 2,150.00 266,057.50 755,000.00 1,023,207.50 1,023,207.50 1,023,207.50 1,023,207.50 29,665.30- 100.000 100.000 100.000 100.000 100.000 100.000 100.000 511.559 .50 .50 .50 .50 .50 23,866.30 glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 JE Detail Description/Comment Page 51 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (678,510.52) (18.48) (4.54) (.72) (2.15) (6.75) (4.26) (6.12) (113.69) (224.87) (150.55) (678,529.00) (678,533.54) (678,534.26) (678,536.41) (678,543.16) (678,547.42) (678,553.54) (678,667.23) (678,892.10) (679,042.65) GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (532.13) (679,042.65) ** (687,175.00) Budgeted (8,132.35) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2150 09/10/2019 Property 2153 09/16/2019 Property 2157 09/30/2019 Property Taxes Taxes Taxes 1,929.34 (2.39) (3.85) (8.90) 1,926.95 1,923.10 1,914.20 GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (15.14) 1,914.20 ** (1,800.00) Budgeted (3,714.20) Remaining -106 % Used Account: 533-40015-000-000 Property Taxes/P & I 2148 09/03/2019 Property Taxes 2149 09/06/2019 Property Taxes 2150 09/10/2019 Property Taxes 2151 09/11/2019 Property Taxes 2152 09/13/2019 Property Taxes 2153 09/16/2019 Property Taxes 2154 09/24/2019 Property Taxes 2155 09/25/2019 Property Taxes 2156 09/26/2019 Property Taxes 2157 09/30/2019 Property Taxes (2,267.62) (1.77) (.59) (.48) (.36) (.55) (.60) (1.04) (22.73) (44.98) (17.44) (2,269.39) (2,269.98) (2,270.46) (2,270.82) (2,271.37) (2,271.97) (2,273.01) (2,295.74) (2,340.72) (2,358.16) GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (90.54) (2,358.16) ** (2,000.00) Budgeted 358.16 Remaining 118 % Used Account: 533-49010-000-000 Interest Income .00 .00 glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 52 Check Source Number Department Totals: (120,053.00) Budgeted (784.94) Monthly Total .00 Remaining 100 % Used (1,052,872.80) ** (1,029,007.00) Budgeted 23,865.80 Remaining 102 % Used Account: 533-49010-000-000 Interest Income Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 533-49011-000-000 Interest Income 2158 09/30/2019 Bank Interest- September (37,207.06) (147.13) (37,354.19) GL Account: 533-49011-000-000 Interest Income Totals: (147.13) (37,354.19) ** .00 Budgeted 37,354.19 Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income (215,979.00) .00 (215,979.00) 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 (120,053.00) .00 (120,053.00) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: .00 (120,053.00) ** Department Totals: (120,053.00) Budgeted (784.94) Monthly Total .00 Remaining 100 % Used (1,052,872.80) ** (1,029,007.00) Budgeted 23,865.80 Remaining 102 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee Account: 533-70005-051-000 Paying Agent Fee 2,150.00 Budgeted Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 Bond Interest Expense -Tax 266,058.00 Budgeted Totals: .00 Remaining 2,150.00 100 % Used 266,057.50 Totals: .50 Remaining 100 o Used .00 2,150.00 .00 2,150.00 ** .00 266,057.50 .00 266,057.50 ** Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 Budgeted 755,000.00 Totals: .00 Remaining 100 % Used .00 755,000.00 .00 755,000.00 ** Department 51 Totals: 1,023,207.50 ** .00 Monthly Total 1,023,208.00 Budgeted .50 Remaining 100 % Used Fund 533 Totals: (29,665.30) (784.94) Monthly Total (5,799.00) Budgeted 23,866.30 Remaining 512 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET SEPTEMBER 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 24,518 TOTAL ASSETS 24,518 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,956 24,518 TOTAL LIABILITIES AND FUND BALANCE 24,518 glbase_tbam skrolczyk 15:36 10/11/19 Fund: 534 2015 Revenue Bond I&S Account 1 1 534-49011-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 9/2019 Adopted Amended Total Budget Budget Encumb. 1,000.00- 1,000.00 - Current Month 43.52 - Program: YTD Total 4,955.59- % of Remaining Budget Budget 495.559 3,955.59 Page 24 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 596,238.00- 100.000 Subtotal: 597,238.00- 597,238.00- 43.52- 601,193.59- 100.662 3,955.59 Program number: 597,238.00- 597,238.00- 43.52- 601,193.59- 100.662 3,955.59 Department number: Revenues 597,238.00- 597,238.00- 43.52- 601,193.59- 100.662 3,955.59 Revenues Subtotal 597,238.00- 597,238.00- 43.52- 601,193.59- 100.662 3,955.59 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 15:36 10/11/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/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 400.00 100.000 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 215,837.50 100.000 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 380,000.00 100.000 Subtotal: 596,238.00 596,238.00 596,237.50 100.000 Program number: 596,238.00 596,238.00 596,237.50 100.000 Department number: Administration 596,238.00 596,238.00 596,237.50 100.000 Expenditures Subtotal 596,238.00 596,238.00 596,237.50 100.000 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 43.52- 4,956.09- 495.609 .50 .50 .50 .50 .50 3,956.09 glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (596,238.00) Budgeted (43.52) Monthly Total .00 Remaining 100 % Used (601,193.59) ** (597,238.00) Budgeted 3,955.59 Remaining 101 % Used Account: 534-49011-000-000 Interest Income 2158 09/30/2019 Bank Interest- September (4,912.07) (43.52) (4,955.59) GL Account: 534-49011-000-000 Interest Income Totals: (43.52) (4,955.59) ** (1,000.00) Budgeted 3,955.59 Remaining 496 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales (596,238.00) .00 (596,238.00) Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (596,238.00) ** Department Totals: (596,238.00) Budgeted (43.52) Monthly Total .00 Remaining 100 % Used (601,193.59) ** (597,238.00) Budgeted 3,955.59 Remaining 101 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Account: 534-70040-051-000 Account: 534-70040-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted .00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 215,838.00 Budgeted .50 Remaining 400.00 100 % Used 215,837.50 .00 .00 .00 100 o Used 400.00 400.00 ** 215,837.50 .00 215,837.50 ** Account: 534-70045-051-000 Revenue Bond Principal Expense Account: 534-70045-051-000 Department 51 Totals: Fund 534 Totals: 380,000.00 Revenue Bond Principal Expense Totals: 380,000.00 Budgeted .00 Remaining .00 Monthly Total (43.52) Monthly Total .00 380,000.00 .00 380,000.00 ** 100 % Used 596,237.50 ** 596,238.00 Budgeted .50 Remaining 100 % Used (4,956.09) (1,000.00) Budgeted 3,956.09 Remaining 496 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 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,967 TOTAL ASSETS 4,967 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,383 4,967 TOTAL LIABILITIES AND FUND BALANCE 4,967 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 8.81 - Program: YTD Total 2,382.81- % of Remaining Budget Budget 397.135 1,782.81 Page 26 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 276,901.00- 100.000 Subtotal: 277,501.00- 277,501.00- 8.81- 279,283.81- 100.642 1,782.81 Program number: 277,501.00- 277,501.00- 8.81- 279,283.81- 100.642 1,782.81 Department number: Revenues 277,501.00- 277,501.00- 8.81- 279,283.81- 100.642 1,782.81 Revenues Subtotal 277,501.00- 277,501.00- 8.81- 279,283.81- 100.642 1,782.81 glbase_tbam skrolczyk 15:36 10/11/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: 9/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total 400.00 % of Remaining Budget Budget 100.000 Page 27 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 61,501.00 215,000.00 100.000 100.000 Subtotal: 276,901.00 276,901.00 276,901.00 100.000 Program number: 276,901.00 276,901.00 276,901.00 100.000 Department number: Administration 276,901.00 276,901.00 276,901.00 100.000 Expenditures Subtotal 276,901.00 276,901.00 276,901.00 100.000 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 8.81- 2,382.81- 397.135 1,782.81 ******* End of Report ********* glpdatb2 skrolczyk 15:36 10/11/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: 9/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 56 Check Source Number Department Totals: (276,901.00) Budgeted (8.81) Monthly Total .00 Remaining 100 o Used (279,283.81) ** (277,501.00) Budgeted 1,782.81 Remaining 101 % Used Account: 535-49011-000-000 Interest Income 2158 09/30/2019 Bank Interest- September (2,374.00) (8.81) (2,382.81) GL Account: 535-49011-000-000 Interest Income Totals: (8.81) (2,382.81) ** (600.00) Budgeted 1,782.81 Remaining 397 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales (276,901.00) .00 (276,901.00) Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: .00 (276,901.00) ** Department Totals: (276,901.00) Budgeted (8.81) Monthly Total .00 Remaining 100 o Used (279,283.81) ** (277,501.00) Budgeted 1,782.81 Remaining 101 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 15:36 10/11/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 9/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 Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted .00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 61,501.00 Budgeted .00 Remaining 400.00 100 % Used 61,501.00 .00 400.00 .00 400.00 ** .00 61,501.00 100 % Used .00 61,501.00 ** Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted .00 Remaining .00 Monthly Total (8.81) Monthly Total 100 % Used .00 215,000.00 .00 215,000.00 ** 276,901.00 ** 276,901.00 Budgeted .00 Remaining 100 % Used (2,382.81) (600.00) Budgeted 1,782.81 Remaining 397 % Used ******* End of Report ********* (7,207,584.74) **** (158,816.45) Monthly Total (589,524.00) Budgeted 6,618,060.74 Remaining ##########