Loading...
HomeMy WebLinkAbout2019-06 Combined Financials June 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 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. 701,924 4,474 26,565 135,611 TOTAL ASSETS 868,574 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 26,571 8,327 TOTAL LIABILITIES 34,898 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 289,792 TOTAL FUND BALANCE 833,676 TOTAL LIABILITIES AND FUND BALANCE 868,574 glbase_tbam skrolczyk 16:58 07/16/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: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 1,845.95- 76.87- 209.07- 1,096,867.37- 3,371.84 4,492.26- 98.198 20,132.63- 3,371.84- 4,492.26 Subtotal: 1,117,000.00- 1,117,000.00- 2,131.89- 1,097,987.79- 98.298 19,012.21- 122-49035-000-000 1 122-49900-000-000 Prior Year Reserves Miscellaneous income 75,000.00- 75,000.00- 135,611.06- 135,611.06- 75,000.00- 135,611.06 Subtotal: 75,000.00- 75,000.00- 135,611.06- 135,611.06- 180.815 60,611.06 Program number: 1,192,000.00- 1,192,000.00- 137,742.95- 1,233,598.85- 103.490 41,598.85 Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 137,742.95- 1,233,598.85- 103.490 41,598.85 Revenues Subtotal 1,192,000.00- 1,192,000.00- 137,742.95- 1,233,598.85- 103.490 41,598.85 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 215,979.00 18,000.00 674,452.00 215,979.00 18,000.00 674,452.00 1,491.21 56,204.33 215,979.00 13,420.89 505,838.64 100.000 74.561 75.000 4,579.11 168,613.36 Page 2 Subtotal: 908,431.00 908,431.00 57,695.54 735,238.53 80.935 173,192.47 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 81,420.00 100.000 75,000.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 208,568.60 73.551 75,000.40 Program number: 1,192,000.00 1,192,000.00 57,695.54 943,807.13 79.178 248,192.87 Department number: Fire 1,192,000.00 1,192,000.00 57,695.54 943,807.13 79.178 248,192.87 Expenditures Subtotal 1,192,000.00 1,192,000.00 57,695.54 943,807.13 79.178 248,192.87 Fund number: 122 Trophy Club MUD Fire Dept. 80,047.41- 289,791.72- 289,791.72 glpdatb2 skrolczyk 16:58 07/16/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: 6/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 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1675 06/03/2019 Property Taxes 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1678 06/06/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1682 06/14/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes 1693 06/27/2019 Property Taxes 1694 06/28/2019 Property Taxes (1,095,021.42) 365.90 (1,094,655.52) (109.70) (1,094,765.22) (428.28) (1,095,193.50) (47.56) (1,095,241.06) (126.29) (1,095,367.35) (39.25) (1,095,406.60) (21.45) (1,095,428.05) (17.65) (1,095,445.70) (40.17) (1,095,485.87) (317.99) (1,095,803.86) (6.95) (1,095,810.81) (42.32) (1,095,853.13) (50.83) (1,095,903.96) (48.45) (1,095,952.41) (175.56) (1,096,127.97) (6.95) (1,096,134.92) (665.18) (1,096,800.10) 24.86 (1,096,775.24) (92.13) (1,096,867.37) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,845.95) (1,096,867.37) ** (1,117,000.00) Budgeted (20,132.63) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1689 06/21/2019 Property Taxes 3,448.71 (76.87) 3,371.84 GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (76.87) 3,371.84 ** .00 Budgeted (3,371.84) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes (4,283.19) 2.81 (3.91) (3.34) (12.59) (1.52) (2.26) (38.20) (.91) (2.96) (1.43) (4,280.38) (4,284.29) (4,287.63) (4,300.22) (4,301.74) (4,304.00) (4,342.20) (4,343.11) (4,346.07) (4,347.50) GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 16:58 07/16/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 6/2019 JE Detail Description/Comment Page 2 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (4,283.19) (39.10) (4,386.60) GL (4.97) (4,391.57) GL (.91) (4,392.48) GL (99.78) (4,492.26) GL Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: (209.07) (4,492.26) ** .00 Budgeted 4,492.26 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (75,000.00) Budgeted (75,000.00) Remaining 0 % Used .00 .00 ** Account: 122-49900-000-000 Miscellaneous Income 1542 06/10/2019 Fire FY17 & FY18 Town True -Up AR 20190610-20190610 User: (135,611.06) (135,611.06) AR Account: 122-49900-000-000 Miscellaneous Income Totals: (135,611.06) (135,611.06) ** .00 Budgeted 135,611.06 Remaining 0 % Used Department Totals: (1,233,598.85) ** (137,742.95) Monthly Total (1,192,000.00) Budgeted 41,598.85 Remaining 103 % Used glpdatb2 skrolczyk 16:58 07/16/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 6/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: 127,149.00 Budgeted 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 943,807.13 ** 248,192.87 Remaining 79 % Used Account: 122-60030-045-000 Rent And/Or Usage 215,979.00 .00 215,979.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 215,979.00 ** 215,979.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 133 06/01/2019 Insurance/Wrk Comp Expense Jun 11,929.68 1,491.21 13,420.89 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 13,420.89 ** 18,000.00 Budgeted 4,579.11 Remaining 75 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1489 06/06/2019 June A/P Fire Admin -June 449,634.31 56,204.33 505,838.64 TOWN OF TROPHY CLUB 5375 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.33 505,838.64 ** 674,452.00 Budgeted 168,613.36 Remaining 75 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % 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 ** Department 45 Totals: 127,149.00 Budgeted 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 943,807.13 ** 248,192.87 Remaining 79 % Used glpdatb2 skrolczyk 16:58 07/16/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Fund 122 Totals: Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 6/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment (80,047.41) Monthly Total .00 Budgeted (289,791.72) 289,791.72 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET JUNE 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,909,440 1,909,440 CASH IN BANK -SAVINGS -CASH RESERVE 1,192,180 1,192,180 INVESTMENTS-TEXPOOL 4,883,780 516,233 5,400,013 PREPAID EXPENSES 29,130 29,130 ADVALOREM PROPERTY TAXES RECEIVABLE 2,914 2,914 UTILITY AND OTHER ACCOUNTS RECEIVABLE 845,719 845,719 TOTAL ASSETS 8,863,764 516,233 9,379,997 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,914 2,914 ACCOUNTS AND OTHER PAYABLES 755,823 755,823 CUSTOMER DEPOSITS 292,485 292,485 TOTAL LIABILITIES 1,051,223 1,051,223 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 2,173,156 2,173,156 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT (116,613) (116,613) ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,442,543 5,442,543 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 188,356 188,356 TOTAL FUND BALANCE 7,812,541 516,233 8,328,774 TOTAL LIABILITIES AND FUND BALANCE 8,863,764 516,233 9,379,997 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 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 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges 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 Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 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 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 6/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 80,000.00- 14,146.00- 7,000.00- 55,000.00- 358,600.00- 266,613.00- 18,522.00- 7,000.00- 806,881.00- 11,343,415.00- 11,343,415.00- 11,343,415.00 - Current Month Program: YTD Total 210.16- 124,885.26- 8.37- 350.18 24.62- 497.64- 243.15- 125,032.72- 474,975.05- 2,953,606.53- 256,884.27- 2,279,027.81- 6,508.69- 72,518.99- 1,300.00- 12,350.00- 150.00- 1,100.00- 450.00- 3,300.00- 3,834.40- 5,344.80- 744,102.41- 5,327,248.13- 11,429.52- 1,178.81- 583.33- 1,029.00- 1,874.43- 16,095.09- 760,440.65- 760,440.65- 760,440.65- 98,903.07- 10,935.96- 5,249.97- 52,600.00- 266,613.00- 7,889.00- 25,000.00- 32,059.11- 4.00- 499,254.11- 5,951,534.96- 5,951,534.96- 5,951,534.96- % of Budget 94.336 -116.727 165.880 40.999 44.755 66.781 53.159 72.647 73.333 73.333 8.908 Remaining Budget 7,498.74- 650.18- 197.64 171,983.00- 179,934.28- 3,645,877.47- 1,133,637.19- 63,899.01- 4,650.00- 400.00- 1,200.00- 54,655.20- 52.067 4,904,318.87- 123.629 77.308 75.000 95.636 100.000 42.593 457.987 61.875 52.467 52.467 52.467 18,903.07 3,210.04- 1,750.03- 2,400.00- 358,600.00- 10,633.00- 25,000.00 ,210.04-1,750.03-2,400.00- 358,600.00- 10,633.00- 25,000.00 25,059.11 4.00 307,626.89- 5,391,880.04- 5,391,880.04- 5,391,880.04- Page 07,626.89-5,391,880.04-5,391,880.04- 5,391,880.04- Page 3 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Subtotal: 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Subtotal: 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Department: Adopted Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Trophy Club MUD No.1 Page 4 Budget Summary with Amendment 10 Water Period Ending: 6/2019 Amended Total Budget Encumb. 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 153,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 196,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Current Month 23,916.82 1,047.75 175.00 2,325.40 4,219.68 261.55 42.47 208.67 1,493.51 349.28 930.94 34,971.07 1,756.95 701.00 745.00 3,202.95 374.65 8,999.68 790.00 500.00 139,696.39 750.00 25,172.81 4,600.00 Program: YTD Total 222,045.52 9,234.27 3,620.00 1,675.00 22,934.48 34,164.48 2,210.25 362.58 1,924.79 14,277.38 3,339.06 46.80 8,107.86 202.45 324,144.92 108,008.42 1,906.30 3,202.10 6,897.27 120,014.09 2,857.77 75,686.85 790.00 122.00 3,595.01 678.98 16,336.53 1,000,822.45 612.00 5,090.00 226,555.29 41,400.00 % of Budget 67.955 46.171 100.000 34.896 68.864 45.663 51.199 51.723 61.475 64.835 64.836 4.333 62.876 101.225 63.175 70.594 63.543 64.042 106.112 61.165 57.155 49.082 79.000 24.400 77.295 28.954 28.166 33.211 20.400 34.508 38.714 75.010 Remaining Budget 104,709.48 10,765.73 3,125.00 10,369.52 40,653.52 2,106.75 338.42 1,206.21 7,743.62 1,810.94 1,033.20 4,787.14 2.45- 300.00 188,947.08 20,000.00 44,991.58 1,093.70 1,797.90 3,500.00 5,214.00 397.27- 76,199.91 2,142.23 78,517.15 210.00 378.00 1,055.99 400.00 1,666.02 1,500.00 41,663.47 2,012,671.55 200.00 2,388.00 9,660.00 358,653.71 13,793.00 200,000.00 glbase_tbam skrolczyk 16:58 07/16/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: 6/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 719,613.00 30,068.00 4,124.00 75,000.00 120,000.00 948,805.00 5,959,447.00 Current Month 180,883.53 805.39 1,559.54 2,364.93 69,438.02 69,438.02 290,860.50 Program: YTD Total 1,374,546.88 7,652.37 2,070.81 16,024.34 641.25 17,861.60 86,949.00 131,199.37 542,593.20 30,068.00 2,283.93 75,000.00 99,877.11 749,822.24 2,699,727.50 % of Budget 33.510 51.016 39.900 80.122 64.125 25.517 99.941 65.800 75.401 100.000 55.381 100.000 83.231 79.028 45.302 Remaining Budget 2,500.00 2,727,399.12 7,347.63 3,119.19 3,975.66 1,200.00 358.75 52,138.40 51.00 68,190.63 177,019.80 1,840.07 20,122.89 198,982.76 3,259,719.50 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund Account Description 135-55135-010-001 Subtotal: Program number: Department number: Lab Analysis for PID 1 Lab Analysis for PID Water Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 2,000.00 5,641,834.00 2,000.00 2,000.00 2,000.00 5,961,447.00 296.19 296.19 296.19 1,351.59 1,351.59 1,351.59 291,156.69 2,701,079.09 67.580 648.41 67.580 648.41 67.580 45.309 648.41 3,260,367.91 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 16:58 07/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 27,076.79 252,713.21 59.927 168,985.79 135-50010-020-000 Overtime 30,000.00 30,000.00 1,877.09 26,965.27 89.884 3,034.73 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 700.00 6,400.00 73.563 2,300.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,742.98 28,667.62 66.244 14,608.38 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 49,471.86 53.993 42,155.14 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 3,159.03 61.893 1,944.97 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 510.54 61.809 315.46 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 384.94 2,907.21 64.677 1,587.79 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,732.54 17,178.10 59.223 11,827.90 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 405.20 4,017.46 59.220 2,766.54 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 54.00 4.286 1,206.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 10,501.77 61.990 6,439.23 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 75.74 25.247 224.26 Subtotal: 667,863.00 667,863.00 42,185.69 410,180.81 61.417 257,682.19 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 2,921.00 19.473 12,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 133,000.00 4,623.63 99,552.85 74.852 33,447.15 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 330.81 4,881.63 48.816 5,118.37 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 1,676.24 20.953 6,323.76 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 7,000.00 6,803.00 97.186 197.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 4,360.62 57,045.55 76.061 17,954.45 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 7,368.28- 23,109.25 66.026 11,890.75 Subtotal: 267,714.00 318,214.00 1,946.78 195,989.52 61.590 122,224.48 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 327.19 3,809.94 76.199 1,190.06 135-60020-020-000 Electricity 174,165.00 174,165.00 12,208.61 111,326.36 63.920 62,838.64 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 191.00 63.667 109.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 1,808.23 25.272 5,346.77 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 544.55 28.736 1,350.45 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 3,491.07 69.821 1,508.93 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,545.22 55.151 13,454.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 225.18 4.504 4,774.82 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 740.74 4,159.47 35.858 7,440.53 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 98,225.10 81.818 21,827.90 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 16:58 07/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 688,330.00 125,187.00 200,000.00 3,500.00 688,330.00 125,187.00 200,000.00 3,500.00 54,203.45 10,432.00 487,831.05 93,888.00 70.872 74.998 200,498.95 31,299.00 200,000.00 3,500.00 Subtotal: 1,381,335.00 1,381,335.00 88,825.89 822,145.91 59.518 559,189.09 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 2,162.46 2,856.60 719.11 508.77 10,422.60 10,159.28 2,713.30 29,356.09 774.06 1,637.69 13,976.94 81.274 49.378 97.854 64.505 136.474 69.885 2,340.72 2,781.70 643.91 425.94 437.69- 6,023.06 Subtotal: 70,395.00 70,395.00 16,669.54 58,617.36 83.269 11,777.64 135-69005-020-000 135-69008-020-000 135-69009-020-000 1 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement 330,000.00 109,858.00 14,917.00 30,000.00 688,600.00 109,858.00 14,917.00 30,000.00 26,270.20 525,895.71 39,858.59 3,027.55 30,000.00 76.372 36.282 20.296 100.000 162,704.29 69,999.41 11,889.45 Subtotal: 484,775.00 843,375.00 26,270.20 598,781.85 70.998 244,593.15 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 1,500.00 - Subtotal: 1,500.00 1,500.00 - Program number: 2,872,082.00 3,281,182.00 175,898.10 2,087,215.45 63.612 1,193,966.55 Department number: Wastewater 2,872,082.00 3,281,182.00 175,898.10 2,087,215.45 63.612 1,193,966.55 glbase_tbam skrolczyk 16:58 07/16/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: 6/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 19.08 % of Remaining Budget Budget 63.600 10.92 Page 9 Subtotal: 30.00 30.00 2.12 19.08 63.600 10.92 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 12.99 461.49 650.00 47.37 920.00 800.06 86.667 3.644 23.000 16.001 150.00 100.00 1,252.63 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 474.48 2,417.43 18.314 10,782.57 Program number: 13,230.00 13,230.00 476.60 2,436.51 18.417 10,793.49 Department number: Board of Directors 13,230.00 13,230.00 476.60 2,436.51 18.417 10,793.49 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 16:58 07/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 29,341.67 2,714.10 5,123.40 289.83 45.48 311.42 1,715.14 401.11 106.55 19.98 272,617.23 57.98 1,832.50 26,752.16 42,930.36 2,473.50 397.76 2,715.02 16,238.05 3,797.61 59.58 919.35 141.95 3,038.49 61.817 2.899 99.973 65.014 52.421 57.644 56.742 60.401 58.876 58.878 4.729 70.992 28.390 60.770 168,388.77 1,942.02 .50 14,395.84 38,964.64 1,817.50 303.24 1,779.98 11,341.95 2,652.39 1,200.42 375.65 358.05 1,961.51 Subtotal: 619,454.00 619,454.00 40,068.68 373,971.54 60.371 245,482.46 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 4,526.16 10,431.61 435.00 575.26 51,250.99 106,248.34 4,975.00 927.52 6,952.48 61,926.50 5,226.43 65.834 60.713 24.875 9.275 69.525 93.750 58.071 26,598.01 68,751.66 15,025.00 9,072.48 3,047.52 4,128.50 3,773.57 Subtotal: 367,904.00 367,904.00 15,968.03 237,507.26 64.557 130,396.74 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60125-030-000 135-60235-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 1,425.17 237.45 383.99 53.86 1,602.26 5,379.15 6,302.73 38.65 93.52 24.00 13,132.18 2,137.47 4,811.41 499.92 16,509.18 48,691.49 55.882 53.437 55.367 24.996 55.031 87.638 56,724.57 87.269 4,269.25 133.82 1,047.00 127.07 71.154 33.455 11.698 2.925 216.00 16.770 10,367.82 1,862.53 3,878.59 1,500.08 13,490.82 6,868.51 1,500.00 8,275.43 1,000.00 1,730.75 266.18 6,000.00 7,903.00 4,217.93 200.00 25,000.00 1,072.00 glbase_tbam skrolczyk 16:58 07/16/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: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 124.49 24.898 375.51 17,000.00 2,500.00 Subtotal: 263,433.00 263,433.00 15,540.78 148,423.85 56.342 115,009.15 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 633.42 895.06 3,025.81 6,170.01 3,794.67 42.834 102.834 94.867 2,050.00 4,038.19 170.01- 3,500.00 205.33 2,500.00 Subtotal: 25,114.00 25,114.00 1,528.48 12,990.49 51.726 12,123.51 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 6,192.00 46,966.00 16.774 233,034.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 274.76 2,413.64 60.341 1,586.36 Subtotal: 284,000.00 284,000.00 6,466.76 49,379.64 17.387 234,620.36 Program number: 1,559,905.00 1,559,905.00 79,572.73 822,272.78 52.713 737,632.22 Department number: Administration 1,559,905.00 1,559,905.00 79,572.73 822,272.78 52.713 737,632.22 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 16:58 07/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 36,072.22 113,228.07 82.648 135-55055-039-000 Auditing 30,800.00 30,800.00 26,459.53 85.908 135-55060-039-000 Appraisal 11,714.00 11,714.00 6,834.32 58.343 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 3,653.00 76.104 Subtotal: 184,314.00 184,314.00 36,072.22 150,174.92 81.478 Program number: 184,314.00 184,314.00 36,072.22 150,174.92 Department number: Non Departmental 184,314.00 184,314.00 36,072.22 150,174.92 Expenditures Subtotal 10,271,365.00 11,000,078.00 583,176.34 5,763,178.75 Fund number: 135 MUD 1 General Fund 341,837.00- 343,337.00- 177,264.31- 188,356.21- 81.478 81.478 52.392 54.860 23,771.93 4,340.47 4,879.68 1,147.00 34,139.08 34,139.08 34,139.08 5,236,899.25 154,980.79- glbase_tbam skrolczyk 16:58 07/16/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: 6/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 16:58 07/16/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 137-69195-010-000 Subtotal: Program number: Department number: Expenditures GASB Replacement Water Subtotal Fund number: 137 MUD 1 Consolidated GASB 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 80,193.00 266,613.00- 266,613.00- 266,613.00- 266,613.00- 266,613.00- 80,193.00- glpdatb2 skrolczyk 16:58 07/16/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: 6/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 1 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1675 06/03/2019 Property Taxes 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1678 06/06/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1682 06/14/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes 1693 06/27/2019 Property Taxes 1694 06/28/2019 Property Taxes (124,675.10) 41.66 (12.49) (48.76) (5.42) (14.38) (4.47) (2.44) (2.01) (4.57) (36.20) (.79) (4.81) (5.79) (5.52) (19.99) (.79) (75.73) 2.83 (10.49) (124,633.44) (124,645.93) (124,694.69) (124,700.11) (124,714.49) (124,718.96) (124,721.40) (124,723.41) (124,727.98) (124,764.18) (124,764.97) (124,769.78) (124,775.57) (124,781.09) (124,801.08) (124,801.87) (124,877.60) (124,874.77) (124,885.26) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (210.16) (124,885.26) ** (132,384.00) Budgeted (7,498.74) Remaining 94 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1689 06/21/2019 Property Taxes 358.55 (8.37) 350.18 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (8.37) 350.18 ** (300.00) Budgeted (650.18) Remaining -117 % Used Account: 135-40015-000-000 Property Taxes/P & I 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes (473.02) .32 (.45) (.37) (1.43) (.17) (.26) (4.35) (.10) (.34) (.16) (472.70) (473.15) (473.52) (474.95) (475.12) (475.38) (479.73) (479.83) (480.17) (480.33) GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes 1694 06/28/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 6/2019 JE Detail Description/Comment Page 6 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (473.02) (4.56) (.56) (.10) (11.36) (.73) (484.89) (485.45) (485.55) (496.91) (497.64) GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (24.62) (497.64) ** (300.00) Budgeted 197.64 Remaining 166 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1607 06/30/2019 UB 07/01/2019 Billing UB20190630-20190630 User: (2,478,631.48) (474,975.05) (2,953,606.53) UB Account: 135-47000-000-000 Water Totals: (474,975.05) (2,953,606.53) ** (6,599,484.00) Budgeted (3,645,877.47) Remaining 45 % Used Account: 135-47005-000-000 Sewer 1512 06/11/2019 UB 1513 06/11/2019 UB 1607 06/30/2019 UB 06/11/2019 06/11/2019 07/01/2019 WA Adjustment UB20190611-20190611 User: (2,022,143.54) WA Adjustment UB20190611-20190611 User: Billing UB20190630-20190630 User: 199.29 43.31 (257,126.87) (2,021,944.25) (2,021,900.94) (2,279,027.81) UB UB UB Account: 135-47005-000-000 Sewer Totals: (256,884.27) (2,279,027.81) ** (3,412,665.00) Budgeted (1,133,637.19) Remaining 67 % Used Account: 135-47025-000-000 Penalties JIIII 1563 06/21/2019 Penalties UB20190621-20190621 User: 1582 06/26/2019 UB 06/26/2019 Penalty removal UB20190626-20190626 User: 1583 06/27/2019 UB 06/27/2019 Penalty removal UB20190627-20190627 User: 1584 06/27/2019 UB 06/27/2019 Penalty removal UB20190627-20190627 User: 1588 06/27/2019 UB 06/27/2019 Penalty removal UB20190627-20190627 User: (66,010.30) (6,672.83) 92.04 15.67 17.09 39.34 (72,683.13) (72,591.09) (72,575.42) (72,558.33) (72,518.99) UB UB UB UB UB Account: 135-47025-000-000 Penalties Totals: (6,508.69) (72,518.99) ** (136,418.00) Budgeted (63,899.01) Remaining 53 % Used glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 JE Detail Description/Comment Account: 135-47030-000-000 Service Charges 1473 06/05/2019 DB 06/05/2019 Disconnect fees UB20190605-20190605 User: 1621 06/14/2019 NSF Check UB20190614-20190614 User: 1624 06/19/2019 NSF check UB20190619-20190619 User: Account: 135-47030-000-000 Account: 135-47035-000-000 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 Page 7 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (11,050.00) Service Charges 11111 Totals: (17,000.00) Budgeted (4,650.00) Remaining Plumbing Inspections 505 Asheville lane 507 Asheville Ln 418 Abbot Lane Account: 135-47035-000-000 Plumbing Inspections (1,500.00) Budgeted Account: 135-47045-000-000 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 Account: 135-47045-000-000 Sewer Inspections 505 Asheville lane 507 Asheville Ln 418 Abbot Lane 73 % Used (1,250.00) (12,300.00) UB (25.00) (12,325.00) UB (25.00) (12,350.00) UB (1,300.00) (12,350.00) ** 1 (950.00) (50.00) (1,000.00) Ashton Woods Homes CR (50.00) (1,050.00) Ashton Woods Homes CR (50.00) (1,100.00) Ashton Woods Homes CR Totals: (150.00) (1,100.00) ** (400.00) Remaining 73 % Used (2,850.00) (150.00) (3,000.00) Ashton Woods Homes CR (150.00) (3,150.00) Ashton Woods Homes CR (150.00) (3,300.00) Ashton Woods Homes CR Sewer Inspections Totals: (4,500.00) Budgeted (1,200.00) Remaining 73 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1607 06/30/2019 UB 07/01/2019 Billing 0620190630-20190630 User: Account: 135-47070-000-000 Account: 135-49011-000-000 1674 06/30/2019 Bank Interest- June 1674 06/30/2019 Bank Interest- June 1674 06/30/2019 Bank Interest- June TCCC Effluent Charges Totals: (60,000.00) Budgeted (54,655.20) Remaining (1,510.40) 9 % Used (450.00) (3,300.00) ** (3,834.40) (5,344.80) UB (3,834.40) (5,344.80) ** Interest Income (87,473.55) (745.52) (88,219.07) GL (1,223.59) (89,442.66) GL (9,460.41) (98,903.07) GL Account: 135-49011-000-000 Interest Income Totals: (11,429.52) (98,903.07) ** (80,000.00) Budgeted 18,903.07 Remaining 124 % Used Account: 135-49016-000-000 Cell Tower Revenue glpdatb2 skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1596 06/28/2019 Cell Tower Rev AT&T June Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 6/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment (9,757.15) (1,178.81) (10,935.96) Page 8 Check Source Number GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (10,935.96) ** (14,146.00) Budgeted (3,210.04) Remaining 77 % Used Account: 135-49018-000-000 Building Rent Income 1697 06/30/2019 Town Billed Invoices 1693-1696 AR 20190630-20190630 User: (4,666.64) (583.33) (5,249.97) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (52,600.00) .00 (52,600.00) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (52,600.00) ** (55,000.00) Budgeted (2,400.00) Remaining 96 % Used Account: 135-49035-000-000 Prior Year Reserves ' ' .00 .00 Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (358,600.00) Budgeted (358,600.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (266,613.00) .00 (266,613.00) Account: 135-49036-000-000 GASH Reserves Totals: .00 (266,613.00) ** (266,613.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 505 Asheville lane (6,860.00) 507 Asheville Ln 418 Abbot Lane (343.00) (343.00) (343.00) (7,203.00) (7,546.00) (7,889.00) Ashton Woods Homes Ashton Woods Homes Ashton Woods Homes CR CR CR Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,029.00) (7,889.00) ** (18,522.00) Budgeted (10,633.00) Remaining 43 % Used Account: 135-49141-000-000 Interfund Transfer In glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 JE Detail Description/Comment Page 9 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (25,000.00) .00 (25,000.00) Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (25,000.00) ** Account: 135-49900-000-000 1613 06/27/2019 Permits -June 2019 1613 06/27/2019 Permits -June 2019 1607 06/30/2019 UB 07/01/2019 Billing .00 Budgeted 25,000.00 Remaining 0 % Used Miscellaneous Income 505 Asheville Ln 507 Asheville Ln UB20190630-20190630 User: (30,184.68) (800.00) (30,984.68) Ashton Woods Homes CR (800.00) (31,784.68) Ashton Woods Homes CR (274.43) (32,059.11) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (1,874.43) (32,059.11) ** (7,000.00) Budgeted 25,059.11 Remaining 458 5 Used Account: 135-49901-000-000 Records Management Revenue (4.00) .00 (4.00) Account: 135-49901-000-000 Records Management Revenue Totals: .00 (4.00) ** .00 Budgeted 4.00 Remaining 0 % Used Department Totals: (5,951,534.96) ** (760,440.65) Monthly Total (11,343,415.00) Budgeted (5,391,880.04) Remaining 52 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 1520 06/14/2019 MUD Payroll 06/14/2019 Salaries & Wages 1576 06/28/2019 MUD P/R 06.28.19 Salaries & Wages Account: 135-50005-010-000 198,128.70 11,973.55 11,943.27 210,102.25 PR 222,045.52 PR Salaries & Wages Totals: 23,916.82 222,045.52 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 1520 06/14/2019 MUD Payroll 06/14/2019 Overtime 1576 06/28/2019 MUD P/R 06.28.19 Overtime 104,709.48 Remaining 68 % Used 8,186.52 721.41 8,907.93 PR 326.34 9,234.27 PR Account: 135-50010-010-000 Overtime Totals: 1,047.75 9,234.27 ** 20,000.00 Budgeted 10,765.73 Remaining 46 % Used Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Account: 135-50017-010-000 1576 06/28/2019 MUD P/R 06.28.19 3,620.00 .00 3,620.00 Longevity Totals: .00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Certification Certification 1,500.00 175.00 1,675.00 PR Account: 135-50017-010-000 Certification Totals: 175.00 1,675.00 ** 4,800.00 Budgeted Account: 135-50020-010-000 Retirement 1520 06/14/2019 MUD Payroll 06/14/2019 Retirement 1576 06/28/2019 MUD P/R 06.28.19 Retirement 3,125.00 Remaining 35 % Used 20,609.08 1,174.28 21,783.36 1,151.12 22,934.48 PR PR Account: 135-50020-010-000 Retirement Totals: 2,325.40 22,934.48 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Medical Insurance 1576 06/28/2019 MUD P/R 06.28.19 Medical Insurance Account: 135-50026-010-000 10,369.52 Remaining 69 % Used 29,944.80 2,109.86 32,054.66 2,109.82 34,164.48 Medical Insurance Totals: 4,219.68 34,164.48 ** 74,818.00 Budgeted 40,653.52 Remaining 46 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Dental Insurance 1576 06/28/2019 MUD P/R 06.28.19 Dental Insurance Account: 135-50027-010-000 Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Vision Insurance 1576 06/28/2019 MUD P/R 06.28.19 Vision Insurance 1,948.70 130.80 2,079.50 PR 130.75 2,210.25 PR 2,106.75 Remaining 51 % Used 5 2,210.25 ** 320.11 21.25 341.36 PR 21.22 362.58 PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 362.58 ** 701.00 Budgeted Account: 135-50029-010-000 Life Insurance & Other 1376 06/01/2019 June Payroll Benefits Employee Benefits 1376 06/01/2019 June Payroll Benefits Employee LTD & STD 1601 06/28/2019 June A/P Caf 125 338.42 Remaining 52 % Used 1,716.12 98.56 1,814.68 Humana Inc 91.11 1,905.79 METLIFE GROUP BENEFITS 19.00 1,924.79 BenefitMall 5323 AP 5330 AP 5420 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 208.67 1,924.79 ** 3,131.00 Budgeted 1,206.21 Remaining 61 6 Used Account: 135-50030-010-000 Social Security Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Social Security Taxes 1576 06/28/2019 MUD P/R 06.28.19 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 Medicare Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Medicare Taxes 1576 06/28/2019 MUD P/R 06.28.19 Medicare Taxes 12,783.87 7,743.62 Remaining 65 6 Used 2,989.78 755.90 737.61 1,493.51 13,539.77 14,277.38 14,277.38 ** 176.77 3,166.55 172.51 3,339.06 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 349.28 3,339.06 ** 5,150.00 Budgeted 1,810.94 Remaining 65 % Used Account: 135-50040-010-000 Unemployment Taxes 46.80 .00 46.80 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-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 133 06/01/2019 Insurance/Wrk Comp Expense Jun 7,176.92 930.94 8,107.86 GL Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 8,107.86 ** 12,895.00 Budgeted Account: 135-50060-010-000 Pre-emp Physicals/Testing Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 4,787.14 Remaining 63 6 Used 202.45 .00 Pre-emp Physicals/Testing Totals: .00 200.00 Budgeted Employee Relations (2.45) Remaining 101 % Used .00 Employee Relations Totals: .00 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 Account: 135-55080-010-000 300.00 Remaining 0 % Used Engineering Totals: 20,000.00 Budgeted Maintenance & Repairs 20,000.00 Remaining 0 % Used 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 THE HOME DEPOT #6581 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 THE HOME DEPOT #6581 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ROANOKE AUTO SUPPLY LT 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 AMZN MKTP US*MN08XOWJ0 1601 06/28/2019 June A/P parts 1665 06/30/2019 June A/P Locks for sample station 1665 06/30/2019 June A/P parts 202.45 202.45 ** .00 .00 ** .00 .00 .00 ** 106,251.47 118.66 106,370.13 THE HOME DEPOT #6581 PC 13.20 106,383.33 THE HOME DEPOT #6581 PC 7.91 106,391.24 ROANOKE AUTO SUPPLY LT PC 42.83 106,434.07 AMZN MKTP US*MN08XOWJO PC 1,288.02 107,722.09 Core & Main LP 5421 AP 89.33 107,811.42 KORALEEN ENTERPRISES AP 197.00 108,008.42 Core & Main LP AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,756.95 108,008.42 ** 153,000.00 Budgeted 44,991.58 Remaining 71 6 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-55085-010-000 Generator Maint. and Repair 1,906.30 1 .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 Account: 135-55090-010-000 Vehicle Maintenance 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 DISCOUNT TIRE TXD 75 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 CLEAN STREAK AUTO SPA 64 % Used 2,501.10 671.00 3,172.10 DISCOUNT TIRE TXD 75 PC 30.00 3,202.10 CLEAN STREAK AUTO SPA PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 701.00 3,202.10 ** 5,000.00 Budgeted 1,797.90 Remaining 64 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining .00 0 % Used .00 .00 .00 ** Account: 135-55120-010-000 Cleaning Services .00 .00 Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** Account: 135-55135-010-000 1538 06/17/2019 June A/P 1665 06/30/2019 June A/P 5,214.00 Budgeted Lab Analysis water samples water samples 5,214.00 Remaining 0 % Used 6,152.27 450.00 6,602.27 TARRANT CTY PUBLIC HEALTH LAB 5415 AP 295.00 6,897.27 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-000 Lab Analysis Totals: 745.00 6,897.27 ** Account: 135-60010-010-000 1505 06/10/2019 June A/P 6,500.00 Budgeted Communications/Mobiles Cell phones -June (397.27) Remaining 106 % Used 2,483.12 374.65 2,857.77 VERIZON WIRELESS 5377 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 374.65 2,857.77 ** 5,000.00 Budgeted 2,142.23 Remaining 57 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 1601 06/28/2019 June A/P Account: 135-60020-010-000 Electricity 5/9-6/10 66,687.17 Electricity Totals: 154,204.00 Budgeted 78,517.15 Remaining 49 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1489 06/06/2019 June A/P Annual Subscription Standards Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 210.00 Remaining 8,999.68 75,686.85 HUDSON ENERGY SERVICES, LLC 5428 AP 8,999.68 75,686.85 ** 790.00 790.00 AMERICAN WATER WORKS ASSOC 79 % Used 790.00 790.00 ** 5352 AP 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 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 RENT ME FIRST 378.00 Remaining 24 9 Used 3,095.01 500.00 3,595.01 RENT ME FIRST PC Account: 135-60080-010-000 Schools & Training Totals: 500.00 3,595.01 ** 4,651.00 Budgeted 1,055.99 Remaining 77 % Used Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Safety Program 400.00 Budgeted Account: 135-60100-010-000 Travel & per diem Account: 135-60100-010-000 Travel & per diem 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Totals: 400.00 Remaining 0 8 Used 678.98 .00 .00 .00 .00 ** .00 678.98 Totals: 1,666.02 Remaining 29 % Used .00 678.98 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-010-000 .00 .00 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 1,500.00 Remaining 0 % Used 16,336.53 .00 16,336.53 TCEQ Fees & Permits Totals: .00 16,336.53 ** 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 1665 06/30/2019 June A/P Account: 135-60150-010-000 41,663.47 Remaining 28 % Used water 861,126.06 139,696.39 1,000,822.45 CITY OF FORT WORTH AP Wholesale Water Totals: 139,696.39 1,000,822.45 ** 3,013,494.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 2,012,671.55 Remaining 33 % Used .00 .00 Miscellaneous Expenses Totals: .00 .00 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance Account: 135-60280-010-000 200.00 Remaining 0 8 Used 612.00 .00 612.00 Property Maintenance Totals: .00 612.00 ** 3,000.00 Budgeted 2,388.00 Remaining 20 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1665 06/30/2019 June A/P Mowing -June 4,340.00 750.00 5,090.00 WATTS ELLISON LLC AP Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 9,660.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev 1&S 1589 06/28/2019 TexPool Transfers June TexPool O&M to 16Swift Rev I&S 750.00 5,090.00 ** 35 % Used 201,382.48 25,172.81 226,555.29 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Interfund Transfer Out -Rev I5S Totals: 585,209.00 Budgeted 358,653.71 Remaining 39 % Used 25,172.81 226,555.29 ** Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bond Resevr 36,800.00 4,600.00 41,400.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 41,400.00 ** 55,193.00 Budgeted 13,793.00 Remaining 75 6 Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used 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 1601 06/28/2019 June A/P Fuel -June 6,846.98 805.39 7,652.37 US Bank Voyager Fleet Systems 5440 AP Account: 135-65005-010-000 Fuel & Lube Totals: 805.39 7,652.37 ** 15,000.00 Budgeted 7,347.63 Remaining 51 6 Used Account: 135-65010-010-000 Uniforms 2,070.81 .00 2,070.81 Account: 135-65010-010-000 Uniforms Totals: .00 2,070.81 ** 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 1536 06/14/2019 June A/P testing supplies 1665 06/30/2019 June A/P chlorine 3,119.19 Remaining 40 8 Used 14,464.80 889.45 15,354.25 HACH COMPANY 5406 AP 670.09 16,024.34 DPC INDUSTRIES, INC AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Chemicals Totals: 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 Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Account: 135-65050-010-000 Meter Expense 1666 06/30/2019 Check made out to wrong vendor meters 1666 06/30/2019 Check made out to wrong vendor meters 1667 06/30/2019 Atlas check reissue meters 1667 06/30/2019 Atlas check reissue meters Account: 135-65050-010-000 3,975.66 Remaining 80 % Used Totals: 1,200.00 Remaining 0 % Used 641.25 Totals: 358.75 Remaining 64 % Used 1,559.54 .00 16,024.34 ** .00 .00 .00 ** .00 641.25 .00 641.25 ** 17,861.60 (2,974.00) 14,887.60 ATLAS ENTERPRISES, INC 5353 AP (6,338.50) 8,549.10 ATLAS ENTERPRISES, INC 5353 AP 2,974.00 11,523.10 ATLAS UTILITY SUPPLY CO. AP 6,338.50 17,861.60 ATLAS UTILITY SUPPLY CO. AP Meter Expense Totals: .00 17,861.60 ** 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program 1666 06/30/2019 Check made out to wrong vendor meters 1667 06/30/2019 Atlas check reissue meters Account: 135-65053-010-000 Account: 135-69005-010-000 1536 06/14/2019 June A/P 1665 06/30/2019 June A/P Account: 135-69005-010-000 52,138.40 Remaining 26 % Used 86,949.00 (43,092.00) 43,092.00 43,857.00 ATLAS ENTERPRISES, INC 86,949.00 ATLAS UTILITY SUPPLY CO. Meter Change Out Program Totals: .00 86,949.00 ** 87,000.00 Budgeted Capital Outlays VFD upgrade VFD upgrade 51.00 Remaining 100 % Used 473,155.18 2,838.02 66,600.00 5353 AP AP 475,993.20 CP&Y/WALLACE GROUP, INC. 5403 AP 542,593.20 REY-MAR CONSTRUCTION AP Capital Outlays Totals: 69,438.02 542,593.20 ** 719,613.00 Budgeted 177,019.80 Remaining 75 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-69008-010-000 Short Term Debt -Principal Account: 135-69008-010-000 30,068.00 .00 30,068.00 Short Term Debt -Principal Totals: .00 30,068.00 ** 30,068.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 2,283.93 .00 2,283.93 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 2,283.93 ** 4,124.00 Budgeted 1,840.07 Remaining 55 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 75,000.00 .00 75,000.00 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 .00 99,877.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 99,877.11 ** 120,000.00 Budgeted 20,122.89 Remaining 83 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 1536 06/14/2019 June A/P 1665 06/30/2019 June A/P TCEQ samples 1,055.40 216.19 1,271.59 LOWER COLORADO RIVER AUTHORITY 5412 AP water samples 80.00 1,351.59 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 296.19 1,351.59 ** 2,000.00 Budgeted 648.41 Remaining 68 % Used Department 10 Totals: 2,701,079.09 ** 291,156.69 Monthly Total 5,961,447.00 Budgeted 3,260,367.91 Remaining 45 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 1520 06/14/2019 MUD Payroll 06/14/2019 Salaries & Wages 1576 06/28/2019 MUD P/R 06.28.19 Salaries & Wages Account: 135-50005-020-000 225,636.42 13,483.50 239,119.92 PR 13,593.29 252,713.21 PR Salaries & Wages Totals: 27,076.79 252,713.21 ** 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 1520 06/14/2019 MUD Payroll 06/14/2019 Overtime 1576 06/28/2019 MUD P/R 06.28.19 Overtime 168,985.79 Remaining 60 % Used 25,088.18 839.13 25,927.31 PR 1,037.96 26,965.27 PR Account: 135-50010-020-000 Overtime Totals: 1,877.09 26,965.27 ** 30,000.00 Budgeted 3,034.73 Remaining 90 % Used Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Account: 135-50017-020-000 1576 06/28/2019 MUD P/R 06.28.19 7,445.00 .00 7,445.00 Longevity Totals: .00 7,445.00 ** 7,445.00 Budgeted .00 Remaining 100 % Used Certification Certification 5,700.00 700.00 6,400.00 PR Account: 135-50017-020-000 Certification Totals: 700.00 6,400.00 ** 8,700.00 Budgeted Account: 135-50020-020-000 Retirement 1520 06/14/2019 MUD Payroll 06/14/2019 Retirement 1576 06/28/2019 MUD P/R 06.28.19 Retirement 2,300.00 Remaining 74 % Used 25,924.64 1,324.85 27,249.49 1,418.13 28,667.62 PR PR Account: 135-50020-020-000 Retirement Totals: 2,742.98 28,667.62 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Medical Insurance 1576 06/28/2019 MUD P/R 06.28.19 Medical Insurance Account: 135-50026-020-000 14,608.38 Remaining 66 % Used 43,883.38 2,794.26 46,677.64 2,794.22 49,471.86 Medical Insurance Totals: 5,588.48 49,471.86 ** 91,627.00 Budgeted 42,155.14 Remaining 54 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Dental Insurance 1576 06/28/2019 MUD P/R 06.28.19 Dental Insurance Account: 135-50027-020-000 2,818.47 170.29 2,988.76 PR 170.27 3,159.03 PR Dental Insurance Totals: 340.56 3,159.03 ** 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Vision Insurance 1576 06/28/2019 MUD P/R 06.28.19 Vision Insurance 1,944.97 Remaining 62 % Used 454.90 27.83 482.73 PR 27.81 510.54 PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 826.00 Budgeted Account: 135-50029-020-000 Life Insurance & Other 1376 06/01/2019 June Payroll Benefits Employee Benefits 1376 06/01/2019 June Payroll Benefits Employee LTD & STD 1601 06/28/2019 June A/P Caf 125 315.46 Remaining 62 % Used Ammti 2,522.27 184.80 2,707.07 Humana Inc 162.14 2,869.21 METLIFE GROUP BENEFITS 38.00 2,907.21 BenefitMall 5323 AP 5330 AP 5420 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 384.94 2,907.21 4,495.00 Budgeted 1,587.79 Remaining 65 6 Used Account: 135-50030-020-000 Social Security Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Social Security Taxes 1576 06/28/2019 MUD P/R 06.28.19 Social Security Taxes Account: 135-50030-020-000 Social Security Taxes Totals: 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Medicare Taxes 1576 06/28/2019 MUD P/R 06.28.19 Medicare Taxes 15,445.56 11,827.90 Remaining 59 6 Used 3,612.26 848.25 884.29 1,732.54 16,293.81 17,178.10 17,178.10 ** 198.41 3,810.67 206.79 4,017.46 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 405.20 4,017.46 ** 6,784.00 Budgeted 2,766.54 Remaining 59 % Used Account: 135-50040-020-000 Unemployment Taxes 54.00 .00 54.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes Totals: 1,260.00 Budgeted 1,206.00 Remaining 4 % Used Account: 135-50045-020-000 Workman's Compensation 133 06/01/2019 Insurance/Wrk Comp Expense Jun 9,296.04 Account: 135-50045-020-000 Workman's Compensation Totals: 16,941.00 Budgeted Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 6,439.23 Remaining 62 6 Used Pre-emp Physicals/Testing Totals: 400.00 Budgeted 286.00 Remaining Account: 135-50070-020-000 Employee Relations 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 WWW.1800BASKETS.COM Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 114.00 29 5 Used 224.26 Remaining 25 6 Used Engineering Totals: 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 30,000.00 Remaining 0 % Used Independent Labor Totals: 15,000.00 Budgeted 2,921.00 12,079.00 Remaining 19 % Used Account: 135-55080-020-000 Maintenance & Repairs 1543 06/17/2019 June A/P Lab supplies 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ROANOKE AUTO SUPPLY LT .00 54.00 ** 1,205.73 1,205.73 .00 .00 10,501.77 10,501.77 ** 114.00 114.00 ** 75.74 75.74 WWW.1800BASKETS.COM 75.74 75.74 ** .00 .00 .00 .00 ** .00 2,921.00 .00 2,921.00 ** 94,929.22 251.30 95,180.52 Huber Technology Inc GL PC 5407 AP 172.04 95,352.56 ROANOKE AUTO SUPPLY LT PC glpdatb2 skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 1601 06/28/2019 June A/P 1601 06/28/2019 June A/P 1665 06/30/2019 June A/P 1665 06/30/2019 June A/P 1665 06/30/2019 June A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 6/2019 JE Detail Beginning Balance Description/Comment THE HOME DEPOT #6581 WAL-MART #5247 H & B INDUSTRIES LESLIES POOL SPLY 574 THE HOME DEPOT #6581 THE HOME DEPOT 6581 parts Parts UV parts Premeate pump parts UV parts 94,929.22 Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 25.98 95,378.54 6.94 95,385.48 245.00 95,630.48 68.29 95,698.77 64.84 95,763.61 83.67 95,847.28 1,950.00 97,797.28 301.24 98,098.52 362.86 98,461.38 380.00 98,841.38 711.47 99,552.85 THE HOME DEPOT #6581 WAL-MART #5247 H & B INDUSTRIES LESLIES POOL SPLY 574 THE HOME DEPOT #6581 THE HOME DEPOT 6581 Core & Main LP Core & Main LP UV DOCTOR LAMPS LLC Environmental Improvements Inc NEWMAN REGENCY GROUP, INC Page 23 Check Source Number PC PC PC PC PC PC 5421 AP 5421 AP AP AP AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,623.63 99,552.85 ** 133,000.00 Budgeted 33,447.15 Remaining Account: 135-55085-020-000 Generator Maint. and Repair 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ROANOKE AUTO SUPPLY LT Account: 135-55085-020-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 5,118.37 Remaining Account: 135-55090-020-000 Account: 135-55090-020-000 Account: 135-55105-020-000 Account: 135-55105-020-000 Vehicle Maintenance Vehicle Maintenance 8,000.00 Budgeted Totals: 6,323.76 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 7,000.00 Budgeted 197.00 Remaining 75 % Used 4,550.82 330.81 4,881.63 ROANOKE AUTO SUPPLY LT 330.81 4,881.63 ** 1,676.24 .00 1,676.24 .00 1,676.24 ** 6,803.00 .00 6,803.00 49 % Used 21 6 Used 97 % Used Account: 135-55120-020-000 Cleaning Services Account: 135-55120-020-000 Cleaning Services 5,214.00 Budgeted Totals: 5,214.00 Remaining 0 6 Used .00 6,803.00 ** .00 .00 .00 .00 ** PC glpdatb2 skrolczyk 16:58 07/16/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: 6/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 1536 06/14/2019 June A/P 1536 06/14/2019 June A/P 1601 06/28/2019 June A/P 1601 06/28/2019 June A/P sludge haul off sludge haul off sludge haul off sludge haul off 52,684.93 845.00 1,740.70 845.00 929.92 53,529.93 L.H. CHANEY MATERIALS, INC. 55,270.63 L.H. CHANEY MATERIALS, INC. 56,115.63 L.H. CHANEY MATERIALS, INC. 57,045.55 L.H. CHANEY MATERIALS, INC. 5410 AP 5410 AP 5433 AP 5433 AP Account: 135-55125-020-000 Dumpster Services Totals: 4,360.62 57,045.55 ** 75,000.00 Budgeted 17,954.45 Remaining 76 % Used Account: 135-55135-020-000 Lab Analysis 1489 06/06/2019 1489 06/06/2019 1536 06/14/2019 1538 06/17/2019 1538 1642 1601 1601 1601 06/17/2019 06/26/2019 06/28/2019 06/28/2019 06/28/2019 1601 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 1599 06/28/2019 June A/P lab testing June A/P lab testing June A/P testing supplies June A/P lab testing June A/P lab testing Pcard 05/28/19 - 06/26/19 POSTNET TX193 June A/P lab testing June A/P lab testing June A/P lab testing June A/P lab testing Correct 02 Lab Anl and Lab Sup October A/P Correct 02 Lab Anl and Lab Sup November A/P Correct 02 Lab Anl and Lab Sup December A/P Correct 02 Lab Anl and Lab Sup January A/P Correct 02 Lab Anl and Lab Sup February A/P Correct 02 Lab Anl and Lab Sup March A/P Correct 02 Lab Anl and Lab Sup April A/P Correct 02 Lab Anl and Lab Sup May A/P Correct 02 Lab Anl and Lab Sup June A/P 30,477.53 317.40 230.00 364.04 317.40 230.00 145.38 317.40 230.00 317.40 230.00 (1,477.46) (230.96) (1,595.65) (1,060.64) (1,703.47) (1,542.29) (1,841.22) (251.57) (364.04) 30,794.93 31,024.93 31,388.97 31,706.37 31,936.37 32,081.75 32,399.15 32,629.15 32,946.55 33,176.55 31,699.09 31,468.13 29,872.48 28,811.84 27,108.37 25,566.08 23,724.86 23,473.29 23,109.25 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC HACH COMPANY OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC POSTNET TX193 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC 5371 5371 5406 5414 5414 5436 5436 5436 5436 AP AP AP AP AP PC AP AP AP AP GL GL GL GL GL GL GL GL GL Account: 135-55135-020-000 Lab Analysis Totals: (7,368.28) 23,109.25 ** ' 35,000.00 Budgeted 11,890.75 Remaining 66 % Used Account: 135-60010-020-000 Communications/Mobiles 1505 06/10/2019 June A/P Cell phones -June 3,482.75 327.19 3,809.94 VERIZON WIRELESS 5377 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 327.19 3,809.94 ** 5,000.00 Budgeted 1,190.06 Remaining 76 % Used Account: 135-60020-020-000 Electricity glpdatb2 skrolczyk Trophy Club MUD No.1 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 25 1536 06/14/2019 June A/P 1601 06/28/2019 June A/P 1696 06/30/2019 June A/P Electricity 4/29-5/29 Electricity 5/9-6/10 Electricity 5/29-6/28 1697 06/30/2019 Town Billed Invoices 1693-1696 AR 20190630-20190630 User: 99,117.75 607.52 99,725.27 TRI COUNTY ELECTRIC 5418 AP 11,219.80 110,945.07 HUDSON ENERGY SERVICES, LLC 5428 AP 550.41 111,495.48 TRI COUNTY ELECTRIC AP (169.12) 111,326.36 AR Account: 135-60020-020-000 Electricity = Totals: 12,208.61 111,326.36 ** 174,165.00 Budgeted 62,838.64 Remaining 64 % Used Account: 135-60066-020-000 Publications/Books/Subscripts ' .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 191.00 .00 191.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 191.00 ** 300.00 Budgeted 109.00 Remaining 64 8 Used Account: 135-60080-020-000 Schools & Training 1,808.23 .00 1,808.23 Account: 135-60080-020-000 Schools & Training Totals: .00 1,808.23 ** 7,155.00 Budgeted 5,346.77 Remaining 25 % Used Account: 135-60090-020-000 Safety Program 100.74 .00 100.74 Account: 135-60090-020-000 Safety Program Totals: .00 100.74 ** 1,000.00 Budgeted 899.26 Remaining 10 % Used Account: 135-60100-020-000 Travel & per diem 544.55 .00 544.55 Account: 135-60100-020-000 Travel & per diem Totals: .00 544.55 ** 1,895.00 Budgeted 1,350.45 Remaining 29 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 3,491.07 Rent/Lease Equipment Totals: 5,000.00 Budgeted 1,508.93 Remaining 70 % Used Advertising Advertising Totals: 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 30,000.00 Budgeted Miscellaneous Expenses 2,500.00 Remaining 16,545.22 0 % Used .00 3,491.07 .00 3,491.07 ** .00 .00 .00 .00 ** .00 16,545.22 Totals: 13,454.78 Remaining 55 % Used .00 16,545.22 ** .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** Account: 135-60280-020-000 Account: 135-60280-020-000 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 225.18 0 % Used Totals: 4,774.82 Remaining 5 % Used .00 225.18 .00 225.18 ** Account: 135-60285-020-000 Lawn Equipment & Maintenance 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 KYLES SMALL ENGINE REP 3,418.73 93.99 3,512.72 KYLES SMALL ENGINE REP PC 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 THE HOME DEPOT 66581 56.75 3,569.47 THE HOME DEPOT #6581 PC 1665 06/30/2019 June A/P Mowing -June 590.00 4,159.47 WATTS ELLISON LLC AP Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 7,440.53 Remaining 740.74 4,159.47 ** 36 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60331-020-000 Interfund Transfer Out -Tax I&S 1589 06/28/2019 TexPool Transfers June TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 87,311.20 10,913.90 Interfund Transfer Out -Tax I&S Totals: 10,913.90 120,053.00 Budgeted 21,827.90 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bd WWTP I&S Account: 135-60332-020-000 433,627.60 82 % Used 54,203.45 Interfund Transfer Out -Rev I&S Totals: 54,203.45 688,330.00 Budgeted 200,498.95 Remaining Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 71 o Used 83,456.00 10,432.00 Interfund Transfer Out -Reserve Totals: 10,432.00 125,187.00 Budgeted 31,299.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 75 % Used .00 98,225.10 98,225.10 ** 487,831.05 487,831.05 ** 93,888.00 93,888.00 ** .00 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining Account: 135-60360-020-000 Furniture/Equipment < $5000 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 3,500.00 Budgeted 3,500.00 Remaining Account: 135-65005-020-000 Fuel & Lube 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 CHEVRON 0378633 1601 06/28/2019 June A/P Fuel -June Account: 135-65005-020-000 Fuel & Lube Totals: 12,500.00 Budgeted Account: 135-65010-020-000 Uniforms 0 % Used .00 .00 .00 .00 ** 0 6 Used GL GL GL 7,996.82 555.44 8,552.26 CHEVRON 0378633 PC 2,340.72 Remaining 81 8 Used 1,607.02 10,159.28 US Bank Voyager Fleet Systems 5440 AP 2,162.46 10,159.28 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Account: 135-65030-020-000 1665 06/30/2019 June A/P Account: 135-65030-020-000 2,713.30 .00 2,713.30 Uniforms Totals: .00 2,713.30 ** 5,495.00 Budgeted Chemicals polymer 2,781.70 Remaining 49 % Used 26,499.49 2,856.60 29,356.09 POLYDYNE, INC AP Chemicals Totals: 2,856.60 29,356.09 ** 30,000.00 Budgeted Account: 135-65035-020-000 Small Tools 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 THE HOME DEPOT 6581 Account: 135-65035-020-000 643.91 Remaining 98 % Used 54.95 719.11 774.06 THE HOME DEPOT 6581 PC Small Tools Totals: 719.11 774.06 ** 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment 1601 06/28/2019 June A/P safety equipment 1601 06/28/2019 June A/P safety equipment 1601 06/28/2019 June A/P safety equipment 1665 06/30/2019 June A/P gloves 1665 06/30/2019 June A/P gloves. Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted 425.94 Remaining 65 % Used 1,128.92 245.39 1,374.31 Ritz Safety, LLC 5437 AP 80.13 1,454.44 Ritz Safety, LLC 5437 AP 27.67 1,482.11 Ritz Safety, LLC 5437 AP 31.62 1,513.73 Ritz Safety, LLC AP 123.96 1,637.69 Ritz Safety, LLC AP Totals: (437.69) Remaining 136 % Used Account: 135-65045-020-000 Lab Supplies 1601 06/28/2019 June A/P lab supplies 1599 06/28/2019 Correct 02 Lab Anl and Lab Sup Move Lab Anlys to Lab Supplies Account: 135-65045-020-000 Account: 135-69005-020-000 1505 06/10/2019 June A/P 1665 06/30/2019 June A/P 1665 06/30/2019 June A/P Lab Supplies Totals: 20,000.00 Budgeted Capital Outlays RAS pump CIP trailer parts blower parts 508.77 1,637.69 ** 3,554.34 355.30 3,909.64 HACH COMPANY 5425 AP 10,067.30 13,976.94 GL 6,023.06 Remaining 70 9 Used 10,422.60 13,976.94 ** 499,625.51 5,524.25 505,149.76 NORTH TEXAS PUMP CO. 5368 AP 3,251.95 508,401.71 Environmental Improvements Inc AP 17,494.00 525,895.71 Environmental Improvements Inc AP glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 29 Check Source Number Department 20 Totals: .00 Budgeted 175,898.10 Monthly Total (1,500.00) Remaining 0 % Used 2,087,215.45 ** 3,281,182.00 Budgeted 1,193,966.55 Remaining 64 % Used Account: 135-69005-020-000 Capital Outlays Totals: 26,270.20 525,895.71 ** 688,600.00 Budgeted 162,704.29 Remaining 76 % Used Account: 135-69008-020-000 Short Term Debt -Principal 39,858.59 .00 39,858.59 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 39,858.59 ** 109,858.00 Budgeted 69,999.41 Remaining 36 % Used Account: 135-69009-020-000 Short Term Debt -Interest 3,027.55 .00 3,027.55 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 3,027.55 ** 14,917.00 Budgeted 11,889.45 Remaining 20 % 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: .00 Budgeted 175,898.10 Monthly Total (1,500.00) Remaining 0 % Used 2,087,215.45 ** 3,281,182.00 Budgeted 1,193,966.55 Remaining 64 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 133 06/01/2019 Insurance/Wrk Comp Expense Jun Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 16.96 2.12 19.08 GL 30.00 Budgeted 10.92 Remaining 64 5 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 2.12 19.08 ** .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 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 TOM THUMB #2580 650.00 .00 650.00 Totals: 100.00 Remaining 87 5 Used .00 650.00 ** 34.38 12.99 47.37 TOM THUMB #2580 PC Account: 135-60075-026-000 Meetings Totals: 12.99 47.37 ** 1,300.00 Budgeted 1,252.63 Remaining 4 5 Used Account: 135-60080-026-000 Schools & Training 920.00 .00 920.00 Account: 135-60080-026-000 Schools & Training Totals: .00 920.00 ** Account: 135-60100-026-000 1601 06/28/2019 June A/P 4,000.00 Budgeted Travel & per diem AWBD Conference 3,080.00 Remaining 23 8 Used 338.57 461.49 800.06 William Rose 5441 AP Account: 135-60100-026-000 Travel & per diem Totals: 461.49 800.06 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,199.94 Remaining 16 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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,436.51 ** 476.60 Monthly Total 13,230.00 Budgeted 10,793.49 Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 1520 06/14/2019 MUD Payroll 06/14/2019 Salaries & Wages 1576 06/28/2019 MUD P/R 06.28.19 Salaries & Wages 243,275.56 14,660.95 14,680.72 257,936.51 PR 272,617.23 PR Account: 135-50005-030-000 Salaries & Wages Totals: 29,341.67 272,617.23 ** 441,006.00 Budgeted 168,388.77 Remaining 62 % 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 Account: 135-50016-030-000 Longevity Totals: 1,833.00 Budgeted .50 Remaining Account: 135-50020-030-000 Retirement 1520 06/14/2019 MUD Payroll 06/14/2019 Retirement 1576 06/28/2019 MUD P/R 06.28.19 Retirement 1,832.50 .00 1,832.50 .00 100 % Used 24,038.06 1,356.13 25,394.19 PR 1,357.97 26,752.16 PR Account: 135-50020-030-000 Retirement Totals: 2,714.10 26,752.16 ** 41,148.00 Budgeted Account: 135-50026-030-000 Medical Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Medical Insurance 1576 06/28/2019 MUD P/R 06.28.19 Medical Insurance 14,395.84 Remaining 65 % Used 37,806.96 2,561.73 40,368.69 PR 2,561.67 42,930.36 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,123.40 42,930.36 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Dental Insurance 1576 06/28/2019 MUD P/R 06.28.19 Dental Insurance 38,964.64 Remaining 52 % Used 2,183.67 144.93 2,328.60 PR 144.90 2,473.50 PR Account: 135-50027-030-000 Dental Insurance Totals: 289.83 2,473.50 ** 4,291.00 Budgeted 1,817.50 Remaining 58 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 Vision Insurance 1520 06/14/2019 MUD Payroll 06/14/2019 Vision Insurance 1576 06/28/2019 MUD P/R 06.28.19 Vision Insurance Account: 135-50028-030-000 Account: 135-50029-030-000 1376 06/01/2019 June Payroll Benefits 1376 06/01/2019 June Payroll Benefits 1601 06/28/2019 June A/P 352.28 22.76 375.04 PR 22.72 397.76 PR Vision Insurance Totals: 45.48 397.76 ** 701.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 303.24 Remaining 57 % Used 2,403.60 149.52 2,553.12 Humana Inc 142.90 2,696.02 METLIFE GROUP BENEFITS 19.00 2,715.02 BenefitMall 5323 AP 5330 AP 5420 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 311.42 2,715.02 ** 4,495.00 Budgeted 1,779.98 Remaining 60 % Used Account: 135-50030-030-000 Social Security Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Social Security Taxes 1576 06/28/2019 MUD P/R 06.28.19 Social Security Taxes 14,522.91 858.52 15,381.43 856.62 16,238.05 PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 1,715.14 16,238.05 ** 27,580.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 1520 06/14/2019 MUD Payroll 06/14/2019 Medicare Taxes 1576 06/28/2019 MUD P/R 06.28.19 Medicare Taxes Account: 135-50035-030-000 Account: 135-50040-030-000 Account: 135-50040-030-000 Medicare Taxes 6,450.00 Budgeted Unemployment Taxes Unemployment Taxes 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 133 06/01/2019 Insurance/Wrk Comp Expense Jun 11,341.95 Remaining 59 % Used 3,396.50 Totals: 2,652.39 Remaining 59 % Used Totals: 1,200.42 Remaining 59.58 5 5 Used 200.77 200.34 401.11 .00 3,597.27 3,797.61 3,797.61 ** 59.58 .00 59.58 ** PR PR 812.80 106.55 919.35 GL glpdatb2 skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2019 JE Detail Beginning Balance Description/Comment Workman's Compensation Totals: 1,295.00 Budgeted 375.65 Remaining Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 500.00 Budgeted 358.05 Remaining Account: 135-50070-030-000 Employee Relations 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 TOM THUMB #1789 Account: 135-50070-030-000 Account: 135-55030-030-000 1341 06/01/2019 June A/P 1489 06/06/2019 June A/P 1536 06/14/2019 June A/P 1543 06/17/2019 June A/P 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1601 06/28/2019 June A/P Account: 135-55030-030-000 Account: 135-55070-030-000 1608 06/30/2019 June A/p 1608 06/30/2019 June A/p Account: 135-55070-030-000 Account: 135-55080-030-000 Employee Relations Totals: 5,000.00 Budgeted 1,961.51 Remaining Software & Support - 06/26/19 - 06/26/19 - 06/26/19 - 06/26/19 - 06/26/19 Microsoft exchange Annual Maintenance -Remit internet-June Microsoft exchange DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS New SCADA Computer renewal Software & Support Totals: 77,849.00 Budgeted 26,598.01 Remaining Independent Labor GM -June GM -June Independent Labor Totals: 175,000.00 Budgeted 68,751.66 Remaining Maintenance s Repairs 141.95 3,018.51 46,724.83 95,816.73 Program: Transaction Detail 71 % Used 28 % Used 61 5 Used 66 % Used 61 6 Used 106.55 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 919.35 ** 141.95 141.95 ** 19.98 3,038.49 TOM THUMB #1789 19.98 3,038.49 ** 510.00 47,234.83 1,900.00 49,134.83 899.00 50,033.83 510.00 50,543.83 42.34 50,586.17 42.02 50,628.19 53.33 50,681.52 42.02 50,723.54 32.45 50,755.99 495.00 51,250.99 4,526.16 10,400.00 M3 Networks JACK HENRY & ASSOC, INC Charter Communications M3 Networks DNH*GODADDY.COM ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS WIN -911 SOFTWARE 51,250.99 ** 106,216.73 Carman Consulting LLC. 31.61 106,248.34 Carman Consulting LLC. 10,431.61 106,248.34 ** Page 34 Check Source Number PC 5299 AP 5362 AP 5401 AP 5413 AP PC PC PC PC PC 5443 AP 5463 AP 5463 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1505 06/10/2019 June A/P 1538 06/17/2019 June A/P 1601 06/28/2019 June A/P quarterly inspection office AC pest control -quarterly 4,540.00 150.00 4,690.00 BRANDON R REED 175.00 4,865.00 BRANDON R REED 110.00 4,975.00 Exclusive Pest Control 5354 AP 5400 AP 5423 AP Account: 135-55080-030-000 Maintenance s Repairs Totals: 435.00 4,975.00 ** 20,000.00 Budgeted 15,025.00 Remaining 25 % 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 6 Used Account: 135-55120-030-000 Cleaning Services 6,952.48 .00 6,952.48 Account: 135-55120-030-000 Cleaning Services Totals: .00 6,952.48 ** 10,000.00 Budgeted 3,047.52 Remaining 70 % Used Account: 135-55160-030-000 Professional Outside Services 61,926.50 .00 61,926.50 Account: 135-55160-030-000 Professional Outside Services Totals: .00 61,926.50 ** 66,055.00 Budgeted 4,128.50 Remaining Account: 135-55205-030-000 Utility Billing Contract 1696 06/30/2019 June A/P Water billings -June 94 % Used 4,651.17 575.26 Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 3,773.57 Remaining Account: 135-60005-030-000 Telephone 1341 06/01/2019 June A/P Answering service -June 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ATT*BUS PHONE PMT 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ATT*BUS PHONE PMT 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 ATT*BILL PAYMENT 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 RINGCENTRAL, INC 1697 06/30/2019 Town Billed Invoices 1693-1696 AR 20190630-20190630 User: 58 % Used 5,226.43 DATAPROSE LLC AP 575.26 ' 5,226.43 ** 11,707.01 195.74 11,902.75 KEYSTONE PARK SECRETARIAL 5296 AP 460.43 12,363.18 ATT*BUS PHONE PMT PC 771.68 13,134.86 ATT*BUS PHONE PMT PC 162.33 13,297.19 ATT*BILL PAYMENT PC 14.99 13,312.18 RINGCENTRAL, INC PC (180.00) 13,132.18 AR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-60005-030-000 Telephone Totals: 1,425.17 13,132.18 ** 23,500.00 Budgeted 10,367.82 Remaining 56 % Used Account: 135-60010-030-000 Communications/Mobiles 1505 06/10/2019 June A/P Cell phones -June 1576 06/28/2019 MUD P/R 06.28.19 Communications/Mobiles Account: 135-60010-030-000 Account: 135-60020-030-000 1 1,900.02 87.45 1,987.47 VERIZON WIRELESS 5377 AP 150.00 2,137.47 PR Communications/Mobiles Totals: 237.45 2,137.47 ** 4,000.00 Budgeted Electricity/Gas 1,862.53 Remaining 53 % Used 1601 06/28/2019 June A/P Electricity admin 7/9-5/9 Account: 135-60020-030-000 4,427.42 383.99 4,811.41 TOWN OF TROPHY CLUB 5439 AP Electricity/Gas Totals: 383.99 4,811.41 ** 8,690.00 Budgeted Account: 135-60025-030-000 Water 3,878.59 Remaining 55 % Used 1665 06/30/2019 June A/P Water -JUNE 446.06 107.71 553.77 TROPHY CLUB MUD (WATER BILLS) AP 1697 06/30/2019 Town Billed Invoices 1693-1696 AR 20190630-20190630 User: (59.04) 494.73 AR 1699 06/30/2019 Town Billed Invoices #1697 Cor AR 20190630-20190630 User: 5.19 499.92 AR Account: 135-60025-030-000 Water Totals: 53.86 499.92 ** 2,000.00 Budgeted 1,500.08 Remaining Account: 135-60035-030-000 Postage 1696 06/30/2019 June A/P Water billings -June Account: 135-60035-030-000 25 % Used 14,906.92 1,602.26 16,509.18 DATAPROSE LLC AP Postage Totals: 1,602.26 16,509.18 ** 30,000.00 Budgeted Account: 135-60040-030-000 Service Charges & Fees 1521 06/14/2019 Child Support Fee 1577 06/28/2019 Child Support Fee 1601 06/28/2019 June A/P Direct send fees 1594 06/30/2019 Pace Credit Card Fees 1594 06/30/2019 Pace Credit Card Fees 1665 06/30/2019 June A/P Dig Tess -June 13,490.82 Remaining 55 % Used 43,312.34 1.50 43,313.84 GL 1.50 43,315.34 GL 50.00 43,365.34 Fisery Solutions, LLC 5424 AP 4,981.18 48,346.52 GL 113.17 48,459.69 GL 231.80 48,691.49 Texas Excavation Safety System AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees Totals: 5,379.15 48,691.49 ** 55,560.00 Budgeted Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 6,868.51 Remaining 88 % Used Bad Debt Expense Totals: 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 133 06/01/2019 Insurance/Wrk Comp Expense Jun 50,421.84 Account: 135-60055-030-000 Account: 135-60066-030-000 Insurance Totals: 65,000.00 Budgeted 8,275.43 Remaining 87 8 Used Publications/Books/Subscripts Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-030-000 Dues & Memberships Account: 135-60070-030-000 Dues & Memberships Totals: 6,000.00 Budgeted Account: 135-60075-030-000 Meetings 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 KIM S DONUT Account: 135-60075-030-000 0 % Used 4,269.25 1,730.75 Remaining 71 8 Used .00 .00 .00 .00 ** 6,302.73 56,724.57 GL 6,302.73 .00 56,724.57 ** .00 .00 .00 ** .00 4,269.25 .00 4,269.25 ** 95.17 38.65 133.82 KIM S DONUT PC Meetings Totals: 38.65 133.82 ** 400.00 Budgeted Account: 135-60079-030-000 Public Education 266.18 Remaining 33 8 Used .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 1,047.00 .00 1,047.00 Account: 135-60080-030-000 Schools & Training Totals: .00 1,047.00 ** Account: 135-60100-030-000 1576 06/28/2019 MUD P/R 06.28.19 1665 06/30/2019 June A/P 8,950.00 Budgeted Travel & per diem Travel & per diem Tolls to lab 7,903.00 Remaining 12 5 Used 33.55 84.37 9.15 117.92 PR 127.07 NTTA AP Account: 135-60100-030-000 Travel & per diem Totals: 93.52 127.07 ** 4,345.00 Budgeted 4,217.93 Remaining 3 5 Used Account: 135-60110-030-000 Physicals/Testing Account: 135-60110-030-000 .00 .00 Physicals/Testing Totals: - .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 o Used Account: 135-60125-030-000 Advertising .00 .00 Account: 135-60125-030-000 Account: 135-60235-030-000 1543 06/17/2019 June A/P Advertising Totals: - .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Security monitoring svc-June 192.00 24.00 216.00 Digital Air Control, Inc 5404 AP Account: 135-60235-030-000 Security Totals: 24.00 216.00 ** 1,288.00 Budgeted 1,072.00 Remaining 17 % Used Account: 135-60245-030-000 Miscellaneous Expenses 124.49 .00 124.49 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.49 ** 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 375.51 Remaining 25 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 .00 .00 ** 0 % Used .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** Account: 135-65010-030-000 Account: 135-65010-030-000 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted 0 % Used 2,050.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-65055-030-000 Hardware 3,025.81 .00 3,025.81 Account: 135-65055-030-000 Hardware Totals: .00 3,025.81 ** 7,064.00 Budgeted 4,038.19 Remaining 43 % Used Account: 135-65085-030-000 Office Supplies 1642 06/26/2019 Pcard 05/28/19 - 06/26/19 AMZN MKTP US*MN78Y9YL1 1601 06/28/2019 June A/P Office supplies 1601 06/28/2019 June A/P Office supplies 1665 06/30/2019 June A/P office supplies Account: 135-65085-030-000 5,536.59 99.56 5,636.15 AMZN MKTP US*MN78Y9YL1 PC 11.38 5,647.53 OFFICE DEPOT, INC 5435 AP 58.66 5,706.19 OFFICE DEPOT, INC 5435 AP 463.82 6,170.01 OFFICE DEPOT, INC AP Office Supplies Totals: 633.42 6,170.01 ** 6,000.00 Budgeted (170.01) Remaining 103 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance glpdatb2 skrolczyk 16:58 07/16/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-65090-030-000 Account: 135-65095-030-000 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1642 06/26/2019 Pcard 05/28/19 1665 06/30/2019 June A/P Account: 135-65095-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 6/2019 JE Detail Beginning Balance Description/Comment Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Maintenance Supplies - 06/26/19 AMZN MKTP US*M60YG96W0 - 06/26/19 - 06/26/19 06/26/19 06/26/19 - 06/26/19 - 06/26/19 - 06/26/19 - 06/26/19 - 06/26/19 AMZN MKTP US*M67VD6DF2 AMAZON.COM*M67F411V1 AMAZON.COM*M62VD2DF2 AMAZON.COM*M61VD8DF2 AMZN MKTP US*M645U01H1 SAMSCLUB.COM WAL-MART #0266 AMZN MKTP US*MNO8X0WJO AMZN MKTP US*MN2BQ8142 Coffee maker for kitchen Maintenance Supplies Totals: 4,000.00 Budgeted 205.33 Remaining 2,899.61 Program: Transaction Detail .00 O % Used 95 % Used .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 78.78 2,978.39 56.99 3,035.38 12.95 3,048.33 37.92 3,086.25 11.70 3,097.95 59.98 3,157.93 282.59 3,440.52 5.03 3,445.55 44.69 3,490.24 27.99 3,518.23 276.44 3,794.67 895.06 AMZN MKTP US*M60YG96W0 AMZN MKTP US*M67VD6DF2 AMAZON.COM*M67F411V1 AMAZON.COM*M62VD2DF2 AMAZON.COM*M61VD8DF2 AMZN MKTP US*M645U01H1 SAMSCLUB.COM WAL-MART #0266 AMZN MKTP US*MNO8X0WJO AMZN MKTP US*MN2BQ8142 OFFICE DEPOT, INC 3,794.67 ** Page 40 Check Source Number PC PC PC PC PC PC PC PC PC PC AP Account: 135-65105-030-000 Printing Account: 135-65105-030-000 Account: 135-69005-030-000 1538 06/17/2019 June A/P 1601 06/28/2019 June A/P Account: 135-69005-030-000 Account: 135-69170-030-000 1536 06/14/2019 June A/P 1601 06/28/2019 June A/P Account: 135-69170-030-000 Printing Totals: 2,500.00 Budgeted 2,500.00 Remaining Capital Outlays GIS capital outlay CMMS software Capital Outlays Totals: 280,000.00 Budgeted 233,034.00 Remaining Copier Lease Installments copier lease -June copier lease Copier Lease Installments Totals: 4,000.00 Budgeted 1,586.36 Remaining .00 O % Used .00 .00 ** 40,774.00 892.00 41,666.00 Halff Associates, INC 5405 AP 5,300.00 46,966.00 Hippo Facility Management Tech 5426 AP 6,192.00 17 % Used 46,966.00 ** 2,138.88 165.00 2,303.88 TIAA COMMERCIAL FINANCE 109.76 2,413.64 KYOCERA DOCUMENT SOLUTIONS 60 % Used 274.76 2,413.64 ** 5417 AP 5432 AP glpdatb2 skrolczyk Trophy Club MUD No.1 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) 1 Department 30 Totals: 822,272.78 ** 79,572.73 Monthly Total 1,559,905.00 Budgeted 737,632.22 Remaining 53 % Used Page 41 Check Source Number glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1538 06/17/2019 June A/P 1665 06/30/2019 June A/P 1665 06/30/2019 June A/P 1698 06/30/2019 June A/P Legal Westlake easement Legal Legal travel Westlake easement 77,155.85 16,364.56 93,520.41 WHITAKER CHALK SWINDLE 5419 AP 6,060.00 99,580.41 McLean & Howard, L.L.P. AP 1,050.00 100,630.41 McLean & Howard, L.L.P. AP 12,597.66 113,228.07 WHITAKER CHALK SWINDLE AP Account: 135-55045-039-000 Legal Totals: 36,072.22 113,228.07 ** 137,000.00 Budgeted 23,771.93 Remaining 83 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: .00 26,459.53 ** 30,800.00 Budgeted 4,340.47 Remaining 86 % Used Account: 135-55060-039-000 Appraisal 6,834.32 .00 6,834.32 Account: 135-55060-039-000 Appraisal Totals: .00 6,834.32 ** 11,714.00 Budgeted 4,879.68 Remaining 58 % Used Account: 135-55065-039-000 Tax Admin Fees 3,653.00 .00 3,653.00 Account: 135-55065-039-000 Tax Adman Fees Totals: .00 3,653.00 ** 4,800.00 Budgeted 1,147.00 Remaining 76 % Used Department 39 Totals: 150,174.92 ** 36,072.22 Monthly Total 184,314.00 Budgeted 34,139.08 Remaining 81 % Used Fund 135 Totals: (188,356.21) (177,264.31) Monthly Total (343,337.00) Budgeted (154,980.79) Remaining 55 % Used glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 43 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 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 44 Account: 137-69195-010-000 GASB Replacement 266,613.00 .00 266,613.00 Account: 137-69195-010-000 GASB Replacement Totals: .00 266,613.00 ** .00 Budgeted (266,613.00) Remaining 0 % Used Department 10 Totals: 266,613.00 ** Fund 137 Totals: .00 Monthly Total .00 Budgeted .00 Monthly Total .00 Budgeted (266,613.00) Remaining 0 % Used 80,193.00 (80,193.00) Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 738,730 TOTAL ASSETS 738,730 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 694,705 TOTAL LIABILITIES 694,705 FUND BALANCE ASSIGNED FUND BALANCE (1,479,465) NET REVENUES / EXPENDITURES 1,523,490 TOTAL FUND BALANCE 44,025 TOTAL LIABILITIES AND FUND BALANCE 738,730 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 16:58 07/16/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 3,211.42- 3,334.95- 3,334.95 517-49105-000-000 Bond Proceeds 1,743,522.00- 1,743,522.00 Subtotal: 3,211.42- 1,746,856.95- 1,746,856.95 Program number: 3,211.42- 1,746,856.95- 1,746,856.95 Department number: Revenues 3,211.42- 1,746,856.95- 1,746,856.95 Revenues Subtotal 3,211.42- 1,746,856.95- 1,746,856.95 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 16:58 07/16/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 9,742.93 223,367.02 223,367.02 - Subtotal: 9,742.93 223,367.02 223,367.02 - Program number: 9,742.93 223,367.02 223,367.02 - Department number: Wastewater 9,742.93 223,367.02 223,367.02 - Expenditures Subtotal 9,742.93 223,367.02 223,367.02 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 6,531.51 1,523,489.93- 1,523,489.93 glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 45 Check Source Number Department Totals: .00 Budgeted (3,211.42) Monthly Total 1,743,522.00 Remaining 0 % Used (1,746,856.95) ** .00 Budgeted 1,746,856.95 Remaining 0 % Used Account: 517-49011-000-000 Interest Income 1674 06/30/2019 Bank Interest- June (123.53) (3,211.42) (3,334.95) GL Account: 517-49011-000-000 Interest Income Totals: (3,211.42) (3,334.95) ** .00 Budgeted 3,334.95 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 (3,211.42) Monthly Total 1,743,522.00 Remaining 0 % Used (1,746,856.95) ** .00 Budgeted 1,746,856.95 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1601 06/28/2019 June A/P WWTP 213,624.09 9,742.93 223,367.02 Wiss, Janney, Elstner Assoc 5442 AP Account: 517-69005-020-000 Capital Outlays Totals: 9,742.93 223,367.02 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted (223,367.02) Remaining 0 6 Used 223,367.02 ** 9,742.93 Monthly Total .00 Budgeted (223,367.02) Remaining 0 % Used 6,531.51 Monthly Total (1,523,489.93) .00 Budgeted 1,523,489.93 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 767,358 TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET JUNE 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 576,508 INVESTMENTS 3,846,120 ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 4,467,628 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES 4,833,874 TOTAL FUND BALANCE 4,467,628 TOTAL LIABILITIES AND FUND BALANCE 4,467,628 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 16:58 07/16/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 2,121.76- 9,557.17- 9,557.17 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: 2,121.76- 5,218,456.98- 5,218,456.98 Program number: 2,121.76- 5,218,456.98- 5,218,456.98 Department number: 2,121.76- 5,218,456.98- 5,218,456.98 Revenues Subtotal 2,121.76- 5,218,456.98- 5,218,456.98 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 16:58 07/16/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 4,525.44 155,628.60 155,628.60 - Subtotal: 4,525.44 155,628.60 155,628.60- 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: 4,525.44 384,582.92 384,582.92 - Department number: Water Department 4,525.44 384,582.92 384,582.92 - Expenditures Subtotal 4,525.44 384,582.92 384,582.92 - Fund number: 520 Revenue Bond 16" Waterline 2,403.68 4,833,874.06- 4,833,874.06 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 6/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 1674 06/30/2019 Bank Interest- June (7,435.41) (2,121.76) (9,557.17) GL Account: 520-49011-000-000 Interest Income Totals: (2,121.76) (9,557.17) ** .00 Budgeted 9,557.17 Remaining 0 6 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 Account: 520-49110-000-000 Account: 520-49141-000-000 (4,224.10) .00 (4,224.10) Bond Premium Totals: .00 (4,224.10) ** .00 Budgeted 4,224.10 Remaining 0 % Used Interfund Transfer In -Gen Fund 25,000.00 .00 25,000.00 Account: 520-49141-000-000 Interfund Transfer In -Gen Fund Totals: .00 25,000.00 ** .00 Budgeted (25,000.00) Remaining 0 % Used Department Totals: (5,218,456.98) ** (2,121.76) Monthly Total .00 Budgeted 5,218,456.98 Remaining 0 % Used glpdatb2 skrolczyk 16:58 07/16/19 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Period Ending: 6/2019 Program: JE Detail Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 48 Check Source Number Department 10 Totals: Fund 520 Totals: .00 Budgeted 4,525.44 Monthly Total 2,403.68 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 384,582.92 ** (384,582.92) Remaining 0 % Used (4,833,874.06) .00 Budgeted 4,833,874.06 Remaining 0 % Used Account: 520-69005-010-000 Capital Outlays 1538 06/17/2019 June A/P 16" waterline 151,103.16 4,525.44 155,628.60 Halff Associates, INC 5405 AP Account: 520-69005-010-000 Capital Outlays Totals: 4,525.44 155,628.60 ** .00 Budgeted (155,628.60) Remaining 0 5 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 ** Department 10 Totals: Fund 520 Totals: .00 Budgeted 4,525.44 Monthly Total 2,403.68 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 384,582.92 ** (384,582.92) Remaining 0 % Used (4,833,874.06) .00 Budgeted 4,833,874.06 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 753,998 TOTAL ASSETS 753,998 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 147,088 753,998 753,998 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 16:58 07/16/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 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,446.48- 11,799.66- 4,600.00- 41,400.00- 10,432.00- 93,888.00- 16,478.48- 147,087.66- 16,478.48- 147,087.66- 16,478.48- 147,087.66- 16,478.48- 147,087.66- 16,478.48- 147,087.66- 235.993 75.010 74.998 79.344 79.344 79.344 79.344 79.344 6,799.66 13,793.00- 31,299.00- 38,292.34- 38,292.34- 38,292.34- 38,292.34- 38,292.34- glpdatb2 skrolczyk 16:58 07/16/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 1674 06/30/2019 Bank Interest- June Account: 528-49011-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 49 Period Ending: 6/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (10,353.18) 6,799.66 Remaining 236 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (36,800.00) (55,193.00) Budgeted (13,793.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (1,446.48) (11,799.66) GL (1,446.48) (11,799.66) ** (4,600.00) (41,400.00) GL 75 % Used (83,456.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (31,299.00) Remaining (16,478.48) Monthly Total (4,600.00) (41,400.00) ** (10,432.00) (93,888.00) GL (10,432.00) (93,888.00) ** 75 % Used (147,087.66) ** (185,380.00) Budgeted (38,292.34) Remaining 79 % Used (16,478.48) Monthly Total (185,380.00) Budgeted (147,087.66) (38,292.34) Remaining 79 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK INVESTMENTS 942,313 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 16,164 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 958,477 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 16,164 ACCOUNTS AND OTHER PAYABLES 657 TOTAL LIABILITIES 16,821 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 888,367 TOTAL FUND BALANCE 941,656 TOTAL LIABILITIES AND FUND BALANCE 958,477 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & i Trophy Club MUD No.1 Page 20 Budget Summary with Amendment Department: Revenues Program: Period Ending: 6/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 687,175.00- 1,800.00- 2,000.00- 687,175.00- 1,800.00- 2,000.00- 1,135.78- 49.25- 129.80- 674,869.98- 2,044.86 1,981.69- 98.209 -113.603 99.085 12,305.02- 3,844.86- 18.31 - Subtotal: 690,975.00- 690,975.00- 1,314.83- 674,806.81- 97.660 16,168.19- 533-49010-000-000 533-49011-000-000 533-49015-000-000 Interest Income Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 1,819.35- 6,597.93- 27,237.10- 215,979.00- 329.897 100.000 4,597.93 27,237.10 533-49141-000-000 Interfund Trans In -PID Surchq 120,053.00- 120,053.00- 10,913.90- 98,225.10- 81.818 21,827.90 - Subtotal: 338,032.00- 338,032.00- 12,733.25- 348,039.13- 102.960 10,007.13 Program number: 1,029,007.00- 1,029,007.00- 14,048.08- 1,022,845.94- 99.401 6,161.06 - Department number: Revenues 1,029,007.00- 1,029,007.00- 14,048.08- 1,022,845.94- 99.401 6,161.06 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 14,048.08- 1,022,845.94- 99.401 6,161.06- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 16:58 07/16/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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- 1,450.00 133,028.75 134,478.75 134,478.75 134,478.75 134,478.75 67.442 50.000 13.143 13.143 13.143 13.143 14,048.08- 888,367.19- ############### 700.00 133,029.25 755,000.00 888,729.25 888,729.25 888,729.25 888,729.25 882,568.19 glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 JE Detail Description/Comment Page 50 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1675 06/03/2019 Property Taxes 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1678 06/06/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1682 06/14/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes 1693 06/27/2019 Property Taxes 1694 06/28/2019 Property Taxes (673,734.20) 225.13 (67.49) (263.52) (29.26) (77.71) (24.15) (13.20) (10.86) (24.72) (195.65) (4.28) (26.03) (31.28) (29.80) (108.02) (4.28) (409.27) 15.30 (56.69) (673,509.07) (673,576.56) (673,840.08) (673,869.34) (673,947.05) (673,971.20) (673,984.40) (673,995.26) (674,019.98) (674,215.63) (674,219.91) (674,245.94) (674,277.22) (674,307.02) (674,415.04) (674,419.32) (674,828.59) (674,813.29) (674,869.98) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (1,135.78) (674,869.98) ** (687,175.00) Budgeted (12,305.02) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1689 06/21/2019 Property Taxes 2,094.11 (49.25) 2,044.86 GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (49.25) 2,044.86 ** (1,800.00) Budgeted (3,844.86) Remaining -114 % Used Account: 533-40015-000-000 Property Taxes/P & I 1701 06/01/2019 Property Taxes- Adj Shrtg A/P 1676 06/04/2019 Property Taxes 1677 06/05/2019 Property Taxes 1679 06/07/2019 Property Taxes 1680 06/10/2019 Property Taxes 1681 06/11/2019 Property Taxes 1683 06/17/2019 Property Taxes 1684 06/18/2019 Property Taxes 1685 06/19/2019 Property Taxes 1686 06/20/2019 Property Taxes (1,851.89) 1.08 (2.41) (2.04) (3.63) (.95) (1.39) (23.51) (.55) (1.82) (.88) (1,850.81) (1,853.22) (1,855.26) (1,858.89) (1,859.84) (1,861.23) (1,884.74) (1,885.29) (1,887.11) (1,887.99) GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 ISS Consolidated Department: Revenues Program: Period Ending: 6/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1689 06/21/2019 Property Taxes 1690 06/24/2019 Property Taxes 1691 06/25/2019 Property Taxes 1692 06/26/2019 Property Taxes 1694 06/28/2019 Property Taxes (1,851.89) (24.73) (1,912.72) GL (3.06) (1,915.78) GL (.55) (1,916.33) GL (61.39) (1,977.72) GL (3.97) (1,981.69) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (129.80) (1,981.69) ** (2,000.00) Budgeted (18.31) Remaining 99 % Used Account: 533-49010-000-000 Interest Income (6,597.93) .00 (6,597.93) Account: 533-49010-000-000 Interest Income Totals: .00 (6,597.93) ** (2,000.00) Budgeted 4,597.93 Remaining 330 % Used Account: 533-49011-000-000 Interest Income 1674 06/30/2019 Bank Interest- June (25,417.75) (1,819.35) (27,237.10) GL Account: 533-49011-000-000 Interest Income Totals: (1,819.35) (27,237.10) ** .00 Budgeted 27,237.10 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 1589 06/28/2019 TexPool Transfers June TexPool O&M to I&S- PID Debt (87,311.20) (10,913.90) (98,225.10) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (98,225.10) ** (120,053.00) Budgeted (21,827.90) Remaining 82 % Used Department Totals: (1,022,845.94) ** (14,048.08) Monthly Total (1,029,007.00) Budgeted (6,161.06) Remaining 99 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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 1,450.00 .00 1,450.00 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 5 Used Account: 533-70025-051-000 Bond Interest Expense -Tax 133,028.75 .00 133,028.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 133,028.75 ** 266,058.00 Budgeted 133,029.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used Department 51 Totals: 134,478.75 ** .00 Monthly Total 1,023,208.00 Budgeted 888,729.25 Remaining 13 % Used Fund 533 Totals: (888,367.19) (14,048.08) Monthly Total (5,799.00) Budgeted 882,568.19 Remaining NNNNNNNNNN TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 402,666 TOTAL ASSETS 402,666 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 19,562 383,104 402,666 402,666 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 534 2015 Revenue Bond I&S Account 534-49011-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 6/2019 Amended Total Budget Encumb. 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Program: Current YTD Month Total 691.46- 3,391.96- 54,203.45- 487,831.05- 54,894.91- 491,223.01- 54,894.91- 491,223.01- 54,894.91- 491,223.01- 54,894.91- 491,223.01- % of Budget Remaining Budget 339.196 2,391.96 81.818 108,406.95- 82.249 106,014.99- 82.249 106,014.99- 82.249 106,014.99- 82.249 106,014.99 - Page 22 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 16:58 07/16/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 200.00 107,918.75 108,118.75 108,118.75 108,118.75 108,118.75 50.000 50.000 18.133 18.133 18.133 18.133 54,894.91- 383,104.26- ############### 200.00 107,919.25 380,000.00 488,119.25 488,119.25 488,119.25 488,119.25 382,104.26 glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (596,238.00) Budgeted (54,894.91) Monthly Total (108,406.95) Remaining 82 % Used (597,238.00) Budgeted (491,223.01) ** (106,014.99) Remaining 82 % Used Account: 534-49011-000-000 Interest Income 1674 06/30/2019 Bank Interest- June (2,700.50) (691.46) (3,391.96) GL Account: 534-49011-000-000 Interest Income Totals: (691.46) (3,391.96) ** (1,000.00) Budgeted 2,391.96 Remaining 339 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1589 06/28/2019 TexPool Transfers June TexPool O&M to Rev Bd WWTP I&S (433,627.60) (54,203.45) (487,831.05) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (487,831.05) ** Department Totals: (596,238.00) Budgeted (54,894.91) Monthly Total (108,406.95) Remaining 82 % Used (597,238.00) Budgeted (491,223.01) ** (106,014.99) Remaining 82 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/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 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 107,918.75 .00 107,918.75 Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 107,918.75 ** 215,838.00 Budgeted 107,919.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 380,000.00 Budgeted 380,000.00 Remaining 0 % Used Department 51 Totals: 108,118.75 ** .00 Monthly Total 596,238.00 Budgeted 488,119.25 Remaining 18 % Used Fund 534 Totals: (383,104.26) (54,894.91) Monthly Total (1,000.00) Budgeted 382,104.26 Remaining 8888888888 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 199,814 TOTAL ASSETS 199,814 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 2,584 197,230 199,814 199,814 glbase_tbam skrolczyk 16:58 07/16/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 1 535-49011-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 6/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 346.18 - Program: YTD Total 1,625.23- % of Remaining Budget Budget 270.872 1,025.23 Page 24 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 226,555.29- 81.818 50,345.71 - Subtotal: 277,501.00- 277,501.00- 25,518.99- 228,180.52- 82.227 49,320.48 - Program number: 277,501.00- 277,501.00- 25,518.99- 228,180.52- 82.227 49,320.48 - Department number: Revenues 277,501.00- 277,501.00- 25,518.99- 228,180.52- 82.227 49,320.48 - Revenues Subtotal 277,501.00- 277,501.00- 25,518.99- 228,180.52- 82.227 49,320.48- glbase_tbam skrolczyk 16:58 07/16/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: 6/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total 200.00 % of Remaining Budget Budget 50.000 200.00 Page 25 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 50.000 30,750.50 215,000.00 Subtotal: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Program number: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Department number: Administration 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Expenditures Subtotal 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,518.99- 197,230.02- ############### 196,630.02 ******* End of Report ********* glpdatb2 skrolczyk 16:58 07/16/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: 6/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (276,901.00) Budgeted (25,518.99) Monthly Total (50,345.71) Remaining 82 % Used (277,501.00) Budgeted (228,180.52) ** (49,320.48) Remaining 82 % Used Account: 535-49011-000-000 Interest Income 1674 06/30/2019 Bank Interest- June (1,279.05) (346.18) (1,625.23) GL Account: 535-49011-000-000 Interest Income Totals: (346.18) (1,625.23) ** (600.00) Budgeted 1,025.23 Remaining 271 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1589 06/28/2019 TexPool Transfers June TexPool O&M to 16Swift Rev I&S (201,382.48) (25,172.81) (226,555.29) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (226,555.29) ** Department Totals: (276,901.00) Budgeted (25,518.99) Monthly Total (50,345.71) Remaining 82 % Used (277,501.00) Budgeted (228,180.52) ** (49,320.48) Remaining 82 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 16:58 07/16/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 6/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 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 30,750.50 .00 30,750.50 Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 30,750.50 ** 61,501.00 Budgeted 30,750.50 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** • Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used 30,950.50 ** .00 Monthly Total 276,901.00 Budgeted 245,950.50 Remaining 11 % Used (197,230.02) (25,518.99) Monthly Total (600.00) Budgeted 196,630.02 Remaining ########## ******* End of Report ********* (8,371,108.05) **** (359,316.99) Monthly Total (536,116.00) Budgeted 7,834,992.05 Remaining ##########