Loading...
HomeMy WebLinkAbout2019-05 Combined Financials May 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 755,990 PREPAID EXPENSES 5,965 ADVALOREM PROPERTY TAXES RECEIVABLE 28,521 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 790,476 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 28,521 8,327 TOTAL LIABILITIES 36,848 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 209,744 TOTAL FUND BALANCE 753,628 TOTAL LIABILITIES AND FUND BALANCE 790,476 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 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: 5/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 870.08- 5,308.00 255.45- 1,095,021.42- 3,448.71 4,283.19- 98.032 21,978.58- 3,448.71- 4,283.19 Subtotal: 1,117,000.00- 1,117,000.00- 4,182.47 1,095,855.90- 98.107 21,144.10- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00 - Subtotal: 75,000.00- 75,000.00- 75,000.00 - Program number: 1,192,000.00- 1,192,000.00- 4,182.47 1,095,855.90- 91.934 96,144.10 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 4,182.47 1,095,855.90- 91.934 96,144.10 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 4,182.47 1,095,855.90- 91.934 96,144.10- glbase_tbam skrolczyk 17:58 06/11/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: 5/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 11,929.68 449,634.31 100.000 66.276 66.667 6,070.32 224,817.69 Page 2 Subtotal: 908,431.00 908,431.00 57,695.54 677,542.99 74.584 230,888.01 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 886,111.59 74.338 305,888.41 Department number: Fire 1,192,000.00 1,192,000.00 57,695.54 886,111.59 74.338 305,888.41 Expenditures Subtotal 1,192,000.00 1,192,000.00 57,695.54 886,111.59 74.338 305,888.41 Fund number: 122 Trophy Club MUD Fire Dept. 61,878.01 209,744.31- 209,744.31 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 5/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 1449 05/01/2019 Property Taxes 1450 05/02/2019 Property Taxes 1451 05/03/2019 Property Taxes 1452 05/06/2019 Property Taxes 1453 05/07/2019 Property Taxes 1454 05/10/2019 Property Taxes 1455 05/13/2019 Property Taxes 1456 05/14/2019 Property Taxes 1457 05/15/2019 Property Taxes 1458 05/16/2019 Property Taxes 1459 05/17/2019 Property Taxes 1460 05/20/2019 Property Taxes 1461 05/21/2019 Property Taxes 1462 05/22/2019 Property Taxes 1463 05/23/2019 Property Taxes 1464 05/24/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1466 05/29/2019 Property Taxes 1467 05/30/2019 Property Taxes 1468 05/31/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (1,094,151.34) (85.81) (1,094,237.15) GL (448.95) (1,094,686.10) GL (12.00) (1,094,698.10) GL 605.72 (1,094,092.38) GL (9.70) (1,094,102.08) GL (104.43) (1,094,206.51) GL (213.61) (1,094,420.12) GL (64.72) (1,094,484.84) GL (790.96) (1,095,275.80) GL (140.99) (1,095,416.79) GL (280.63) (1,095,697.42) GL (311.07) (1,096,008.49) GL (54.61) (1,096,063.10) GL (197.58) (1,096,260.68) GL (185.13) (1,096,445.81) GL (510.71) (1,096,956.52) GL 3,382.82 (1,093,573.70) GL (3,382.82) (1,096,956.52) GL (365.90) (1,097,322.42) GL (455.06) (1,097,777.48) GL (260.86) (1,098,038.34) GL 3,016.92 (1,095,021.42) DENTON COUNTY TAX OFFICE 5350 AP Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (870.08) (1,095,021.42) ** (1,117,000.00) Budgeted (21,978.58) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1449 05/01/2019 Property Taxes 1451 05/03/2019 Property Taxes 1460 05/20/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1467 05/30/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (1,859.29) (1.19) (1,860.48) GL 2.11 (1,858.37) GL (.01) (1,858.38) GL 5,317.93 3,459.55 GL (5,317.93) (1,858.38) GL (10.84) (1,869.22) GL 5,317.93 3,448.71 DENTON COUNTY TAX OFFICE 5350 AP Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 5,308.00 3,448.71 ** .00 Budgeted (3,448.71) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1449 05/01/2019 Property Taxes (4,027.74) (20.96) (4,048.70) GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 2 1450 05/02/2019 Property Taxes 1451 05/03/2019 Property Taxes 1452 05/06/2019 Property Taxes 1453 05/07/2019 Property Taxes 1455 05/13/2019 Property Taxes 1456 05/14/2019 Property Taxes 1457 05/15/2019 Property Taxes 1459 05/17/2019 Property Taxes 1460 05/20/2019 Property Taxes 1461 05/21/2019 Property Taxes 1464 05/24/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1466 05/29/2019 Property Taxes 1467 05/30/2019 Property Taxes 1468 05/31/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (4,027.74) (44.78) (4,093.48) (1.56) (4,095.04) (23.89) (4,118.93) (1.02) (4,119.95) (27.76) (4,147.71) (.33) (4,148.04) (5.31) (4,153.35) (17.12) (4,170.47) (9.19) (4,179.66) (1.38) (4,181.04) (66.39) (4,247.43) (5.00) (4,252.43) 5.00 (4,247.43) (2.81) (4,250.24) (25.04) (4,275.28) (.10) (4,275.38) (7.81) (4,283.19) DENTON COUNTY TAX OFFICE GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL 5350 AP Department Totals: 4,182.47 Monthly Total (1,095,855.90) ** (1,192,000.00) Budgeted (96,144.10) Remaining 92 % Used Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: (255.45) (4,283.19) ** .00 Budgeted 4,283.19 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Department Totals: 4,182.47 Monthly Total (1,095,855.90) ** (1,192,000.00) Budgeted (96,144.10) Remaining 92 % Used glpdatb2 skrolczyk 17:58 06/11/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: 5/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 886,111.59 ** 1,192,000.00 Budgeted 305,888.41 Remaining 74 % Used Account: 122-60030-045-000 Rent And/Or Usage 215,979.00 215,979.00 .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 132 05/01/2019 Insurance/Wrk Comp Expense May 10,438.47 1,491.21 11,929.68 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 11,929.68 ** 18,000.00 Budgeted 6,070.32 Remaining 66 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1246 05/02/2019 May A/P Fire Admin -May 393,429.98 56,204.33 449,634.31 TOWN OF TROPHY CLUB 5261 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.33 449,634.31 ** 674,452.00 Budgeted 224,817.69 Remaining 67 % 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 886,111.59 ** 1,192,000.00 Budgeted 305,888.41 Remaining 74 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: (209,744.31) 61,878.01 Monthly Total .00 Budgeted 209,744.31 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET MAY 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,682,164 1,682,164 CASH IN BANK -SAVINGS -CASH RESERVE 1,190,956 1,190,956 INVESTMENTS-TEXPOOL 3,418,451 516,233 3,934,684 PREPAID EXPENSES 37,678 37,678 ADVALOREM PROPERTY TAXES RECEIVABLE 3,136 3,136 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,244,744 2,244,744 TOTAL ASSETS 8,577,731 516,233 9,093,964 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,136 3,136 ACCOUNTS AND OTHER PAYABLES 627,063 627,063 CUSTOMER DEPOSITS 312,255 312,255 TOTAL LIABILITIES 942,454 942,454 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 11,092 11,092 TOTAL FUND BALANCE 7,635,277 516,233 8,151,510 TOTAL LIABILITIES AND FUND BALANCE 8,577,731 516,233 9,093,964 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 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: 5/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 99.08- 608.91 29.04- 480.79 316,799.04- 233,979.20- 8,401.66- 800.00- 200.00- 600.00- 560,779.90- 11,850.77- 583.33- 1,372.00- 25,000.00- 296.40- 39,102.50- 599,401.61- 599,401.61- 599,401.61 - Program: YTD Total 124,675.10- 358.55 473.02- 124,789.57- 2,478,631.48- 2,022,143.54- 66,010.30- 11,050.00- 950.00- 2,850.00- 1,510.40- 4,583,145.72- 87,473.55- 9,757.15- 4,666.64- 52,600.00- 266,613.00- 6,860.00- 25,000.00- 30,184.68- 4.00- 483,159.02- 5,191,094.31- 5,191,094.31- 5,191,094.31- % of Budget 94.177 -119.517 157.673 40.919 37.558 59.254 48.388 65.000 63.333 63.333 2.517 Remaining Budget 7,708.90- 658.55- 173.02 171,983.00- 180,177.43- 4,120,852.52- 1,390,521.46- 70,407.70- 5,950.00- 550.00- 1,650.00- 58,489.60- 44.794 5,648,421.28- 109.342 68.975 66.666 95.636 100.000 37.037 431.210 59.880 45.763 45.763 45.763 7,473.55 4,388.85- 2,333.36- 2,400.00- 358,600.00- 11,662.00- 25,000.00 ,388.85-2,333.36-2,400.00- 358,600.00- 11,662.00- 25,000.00 23,184.68 4.00 323,721.98- 6,152,320.69- 6,152,320.69- 6,152,320.69- Page 23,721.98-6,152,320.69-6,152,320.69- 6,152,320.69- Page 3 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 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 Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 5/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 Current Month Program: YTD Total % of Budget 37,688.56 198,128.70 60.635 1,990.29 8,186.52 40.933 3,620.00 100.000 225.00 1,500.00 31.250 3,691.11 20,609.08 61.882 4,219.68 29,944.80 40.024 261.55 1,948.70 45.140 42.47 320.11 45.665 208.67 1,716.12 54.811 2,411.49 12,783.87 58.053 563.99 2,989.78 58.054 720.98- 46.80 4.333 930.94 7,176.92 55.657 202.45 202.45 101.225 Remaining Budget 128,626.30 11,813.48 3,300.00 12,694.92 44,873.20 2,368.30 380.89 1,414.88 9,237.13 2,160.22 1,033.20 5,718.08 2.45- 300.00 Page 4 Subtotal: 513,092.00 513,092.00 51,715.22 289,173.85 56.359 223,918.15 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 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 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 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 8,833.92 106,251.47 69.445 1,906.30 63.543 355.87 2,501.10 50.022 1,104.87 6,152.27 94.650 10,294.66 116,811.14 59.533 316.69 2,483.12 49.662 8,070.02 66,687.17 43.246 61.00 122.00 24.400 1,059.01 3,095.01 66.545 369.59 678.98 28.954 16,336.53 28.166 144,474.55 861,126.06 28.576 276.00 612.00 20.400 1,500.00 4,340.00 29.424 25,172.81 201,382.48 34.412 4,600.00 36,800.00 66.675 20,000.00 46,748.53 1,093.70 2,498.90 3,500.00 5,214.00 347.73 79,402.86 2,516.88 87,516.83 1,000.00 378.00 1,555.99 400.00 1,666.02 1,500.00 41,663.47 2,152,367.94 200.00 2,388.00 10,410.00 383,826.52 18,393.00 200,000.00 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: 135-70040-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 Bond Related Expenses 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: 5/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 185,899.67 1,103.87 653.40 1,116.81 641.25 54,687.00 58,202.33 186,430.92 Program: YTD Total 1,193,663.35 6,846.98 2,070.81 14,464.80 641.25 17,861.60 86,949.00 128,834.44 473,155.18 30,068.00 2,283.93 75,000.00 99,877.11 186,430.92 680,384.22 7,080.00- 7,080.00- 485,462.80 2,408,867.00 40.421 3,550,580.00 % of Budget 29.100 45.647 39.900 72.324 64.125 25.517 99.941 64.614 65.751 100.000 55.381 100.000 83.231 71.710 Remaining Budget 2,500.00 2,908,282.65 8,153.02 3,119.19 5,535.20 1,200.00 358.75 52,138.40 51.00 70,555.56 246,457.82 1,840.07 20,122.89 268,420.78 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,641,834.00 5,961,447.00 80.00 80.00 80.00 1,055.40 1,055.40 1,055.40 485,542.80 2,409,922.40 52.770 944.60 52.770 944.60 52.770 944.60 40.425 3,551,524.60 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 17:58 06/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 41,422.53 225,636.42 53.507 196,062.58 135-50010-020-000 Overtime 30,000.00 30,000.00 4,160.03 25,088.18 83.627 4,911.82 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 5,700.00 65.517 3,000.00 135-50020-020-000 Retirement 43,276.00 43,276.00 4,281.14 25,924.64 59.905 17,351.36 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 43,883.38 47.894 47,743.62 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 2,818.47 55.221 2,285.53 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 454.90 55.073 371.10 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 301.14 2,522.27 56.113 1,972.73 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 2,767.40 15,445.56 53.250 13,560.44 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 647.21 3,612.26 53.247 3,171.74 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 918.00- 54.00 4.286 1,206.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 9,296.04 54.873 7,644.96 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 76.00 114.00 28.500 286.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 60,627.86 367,995.12 55.100 299,867.88 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 3,815.61 94,929.22 71.375 38,070.78 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 4,550.82 45.508 5,449.18 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 225.70 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 10,370.69 52,684.93 70.247 22,315.07 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,932.37 30,477.53 87.079 4,522.47 Subtotal: 267,714.00 318,214.00 17,344.37 194,042.74 60.979 124,171.26 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 442.62 3,482.75 69.655 1,517.25 135-60020-020-000 Electricity 174,165.00 174,165.00 11,267.26 99,117.75 56.910 75,047.25 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 11.00 191.00 63.667 109.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 945.28 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 369.59 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 1,428.00 3,418.73 29.472 8,181.27 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 87,311.20 72.727 32,741.80 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Account 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Subtotal: 135-70020-020-000 Subtotal: Program number: Department number: Wastewater Description Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost Department: Adopted Budget 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 330,000.00 109,858.00 14,917.00 30,000.00 484,775.00 2,872,082.00 2,872,082.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 5/2019 Amended Total Budget Encumb. 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 688,600.00 109,858.00 14,917.00 30,000.00 843,375.00 3,281,182.00 3,281,182.00 Current Month Program: YTD Total 54,203.45 433,627.60 10,432.00 83,456.00 90,013.10 733,320.02 1,098.53 7,996.82 653.40 2,713.30 5,700.65 26,499.49 54.95 33.23 1,128.92 204.51 3,554.34 7,690.32 41,947.82 9,453.14 499,625.51 39,858.59 3,027.55 30,000.00 9,453.14 185,128.79 185,128.79 572,511.65 1,500.00 1,500.00 1,911,317.35 1,911,317.35 % of Budget Remaining Budget 62.997 254,702.40 66.665 41,731.00 200,000.00 3,500.00 53.088 648,014.98 63.975 4,503.18 49.378 2,781.70 88.332 3,500.51 4.579 1,145.05 94.077 71.08 17.772 16,445.66 59.589 28,447.18 72.557 188,974.49 36.282 69,999.41 20.296 11,889.45 100.000 67.883 58.251 58.251 270,863.35 1,500.00- 1,500.00- 1,369,864.65 1,369,864.65 Page 8 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 17:58 06/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 2.12 16.96 2.12 16.96 2.12 2.12 650.00 34.38 920.00 338.57 1,942.95 1,959.91 1,959.91 56.533 Remaining Budget 13.04 56.533 13.04 86.667 2.645 23.000 6.771 14.719 14.814 14.814 150.00 100.00 1,265.62 3,080.00 4,661.43 2,000.00 11,257.05 11,270.09 11,270.09 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 17:58 06/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 43,881.43 6.45 4,059.63 5,123.40 289.83 45.48 311.42 2,617.00 612.05 756.30- 106.55 63.45- 243,275.56 57.98 1,832.50 24,038.06 37,806.96 2,183.67 352.28 2,403.60 14,522.91 3,396.50 59.58 812.80 141.95 3,018.51 55.164 2.899 99.973 58.419 46.165 50.890 50.254 53.473 52.657 52.659 4.729 62.764 28.390 60.370 197,730.44 1,942.02 .50 17,109.94 44,088.04 2,107.33 348.72 2,091.40 13,057.09 3,053.50 1,200.42 482.20 358.05 1,981.49 Subtotal: 619,454.00 619,454.00 56,233.49 333,902.86 53.903 285,551.14 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 2,242.71 13,245.78 1,738.12 582.36 46,724.83 95,816.73 4,540.00 927.52 6,952.48 61,926.50 4,651.17 60.020 54.752 22.700 9.275 69.525 93.750 51.680 31,124.17 79,183.27 15,460.00 9,072.48 3,047.52 4,128.50 4,348.83 Subtotal: 367,904.00 367,904.00 17,808.97 221,539.23 60.217 146,364.77 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,373.60 237.45 547.78 59.05 1,730.54 4,872.12 6,302.73 160.00 912.00 24.85 24.00 11,707.01 1,900.02 4,427.42 446.06 14,906.92 43,312.34 49.817 47.501 50.948 22.303 49.690 77.956 50,421.84 77.572 4,269.25 95.17 1,047.00 33.55 71.154 23.793 11.698 .772 192.00 14.907 11,792.99 2,099.98 4,262.58 1,553.94 15,093.08 12,247.66 1,500.00 14,578.16 1,000.00 1,730.75 304.83 6,000.00 7,903.00 4,311.45 200.00 25,000.00 1,096.00 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 5/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 16,244.12 132,883.07 50.443 130,549.93 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 230.67 370.60 3,025.81 5,536.59 2,899.61 42.834 92.277 72.490 2,050.00 4,038.19 463.41 3,500.00 1,100.39 2,500.00 Subtotal: 25,114.00 25,114.00 601.27 11,462.01 45.640 13,651.99 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 40,774.00 14.562 239,226.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 249.89 2,138.88 53.472 1,861.12 Subtotal: 284,000.00 284,000.00 249.89 42,912.88 15.110 241,087.12 Program number: 1,559,905.00 1,559,905.00 91,137.74 742,700.05 47.612 817,204.95 Department number: Administration 1,559,905.00 1,559,905.00 91,137.74 742,700.05 47.612 817,204.95 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 17:58 06/11/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 5,940.00 77,155.85 56.318 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 5,940.00 114,102.70 61.907 Program number: 184,314.00 184,314.00 5,940.00 114,102.70 Department number: Non Departmental 184,314.00 184,314.00 5,940.00 114,102.70 Expenditures Subtotal 10,271,365.00 11,000,078.00 767,751.45 5,180,002.41 Fund number: 135 MUD 1 General Fund 341,837.00- 343,337.00- 168,349.84 11,091.90- 61.907 61.907 47.091 3.231 59,844.15 4,340.47 4,879.68 1,147.00 70,211.30 70,211.30 70,211.30 5,820,075.59 332,245.10- glbase_tbam skrolczyk 17:58 06/11/19 Fund: 137 MUD 1 Consolidated GASB Account 137-49145-000-000 Description Intergov Transfer -General Fund Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 5/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 17:58 06/11/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 5/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 Trophy Club MUD No.1 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 1449 05/01/2019 Property Taxes 1450 05/02/2019 Property Taxes 1451 05/03/2019 Property Taxes 1452 05/06/2019 Property Taxes 1453 05/07/2019 Property Taxes 1454 05/10/2019 Property Taxes 1455 05/13/2019 Property Taxes 1456 05/14/2019 Property Taxes 1457 05/15/2019 Property Taxes 1458 05/16/2019 Property Taxes 1459 05/17/2019 Property Taxes 1460 05/20/2019 Property Taxes 1461 05/21/2019 Property Taxes 1462 05/22/2019 Property Taxes 1463 05/23/2019 Property Taxes 1464 05/24/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1466 05/29/2019 Property Taxes 1467 05/30/2019 Property Taxes 1468 05/31/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (124,576.02) (9.77) (124,585.79) GL (51.12) (124,636.91) GL (1.37) (124,638.28) GL 68.97 (124,569.31) GL (1.10) (124,570.41) GL (11.89) (124,582.30) GL (24.32) (124,606.62) GL (7.37) (124,613.99) GL (90.06) (124,704.05) GL (16.05) (124,720.10) GL (31.95) (124,752.05) GL (35.42) (124,787.47) GL (6.22) (124,793.69) GL (22.50) (124,816.19) GL (21.08) (124,837.27) GL (58.15) (124,895.42) GL 385.15 (124,510.27) GL (385.15) (124,895.42) GL (41.66) (124,937.08) GL (51.81) (124,988.89) GL (29.70) (125,018.59) GL 343.49 (124,675.10) DENTON COUNTY TAX OFFICE 5350 AP Account: 135-40000-000-000 Property Taxes Totals: (99.08) (124,675.10) ** (132,384.00) Budgeted (7,708.90) Remaining 94 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1449 05/01/2019 Property Taxes 1451 05/03/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1467 05/30/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (250.36) (.07) (250.43) GL .24 (250.19) GL 609.98 359.79 GL (609.98) (250.19) GL (1.24) (251.43) GL 609.98 358.55 DENTON COUNTY TAX OFFICE 5350 AP Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 608.91 358.55 ** (300.00) Budgeted (658.55) Remaining -120 % Used Account: 135-40015-000-000 Property Taxes/P & I 1449 05/01/2019 Property Taxes 1450 05/02/2019 Property Taxes (443.98) (2.36) (446.34) (5.09) (451.43) GL GL glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date 1451 05/03/2019 1452 05/06/2019 1453 05/07/2019 1455 05/13/2019 1456 05/14/2019 1457 05/15/2019 1459 05/17/2019 1460 05/20/2019 1461 05/21/2019 1464 05/24/2019 1465 05/28/2019 1509 05/28/2019 1466 05/29/2019 1467 05/30/2019 1468 05/31/2019 1499 05/31/2019 JE Description Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes Property Taxes- Shortage A/P Property Taxes Property Taxes Property Taxes May A/P Tax Shortage Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2019 Beginning Balance JE Detail Description/Comment Refund Tax Shortage for May Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) (443.98) (.17) (451.60) (2.72) (454.32) (.12) (454.44) (3.16) (457.60) (.04) (457.64) (.60) (458.24) (1.95) (460.19) (1.04) (461.23) (.15) (461.38) (7.56) (468.94) (.57) (469.51) .57 (468.94) (.32) (469.26) (2.86) (472.12) (.01) (472.13) (.89) (473.02) DENTON COUNTY TAX OFFICE Page 6 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL 5350 AP Account: 135-40015-000-000 Property Taxes/P & I Totals: (29.04) (473.02) ** (300.00) Budgeted 173.02 Remaining 158 % 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 1434 05/15/2019 1413 05/21/2019 1414 05/24/2019 1415 05/28/2019 1444 05/30/2019 1428 05/31/2019 Marriot-feb billing adj OTD billing adj Billing adj-OTD billing adj-Town of TC Theft of Water- Bryon Nelson UB 05/31/2019 Billing UB20190515-20190515 User: UB20190521-20190521 User: UB20190524-20190524 User: UB20190528-20190528 User: Water Rev- Water W/O Meter UB20190531-20190531 User: (2,161,832.44) 11,233.18 1,269.47 3,836.33 2,929.66 (5,000.00) (331,067.68) (2,150,599.26) (2,149,329.79) (2,145,493.46) (2,142,563.80) (2,147,563.80) (2,478,631.48) UB UB UB UB GL UB Account: 135-47000-000-000 Water Totals: (316,799.04) (2,478,631.48) ** (6,599,484.00) Budgeted (4,120,852.52) Remaining 38 % Used Account: 135-47005-000-000 Sewer 1434 05/15/2019 Marriot-feb billing adj UB20190515-20190515 User: (1,788,164.34) 9,815.40 1412 05/20/2019 sw wtr avg-9 cypress, 305 eagl UB20190520-20190520 User: 395.61 (1,778,348.94) (1,777,953.33) UB UB glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1361 05/21/2019 UB 05/21/2019 WA adjustment 1375 05/23/2019 UB 05/23/2019 WA Adjusttment 1414 05/24/2019 Billing adj-OTD 1428 05/31/2019 UB 05/31/2019 Billing Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2019 Beginning Balance JE Detail Description/Comment UB20190521-20190521 User: UB20190523-20190523 User: UB20190524-20190524 User: UB20190531-20190531 User: (1,788,164.34) Program: Transaction Detail 72.13 241.74 4,163.81 (248,667.89) Transaction Vendor_Name Detail (SUBTOTAL) (1,777,881.20) (1,777,639.46) (1,773,475.65) (2,022,143.54) Page 7 Check Source Number UB UB UB UB Account: 135-47005-000-000 • Sewer 1 Totals: (233,979.20) (2,022,143.54) ** Account: 135-47025-000-000 1292 05/07/2019 1333 05/15/2019 1363 05/21/2019 1365 05/22/2019 1374 05/23/2019 1383 05/24/2019 1414 05/24/2019 1399 05/29/2019 1406 05/30/2019 (3,412,665.00) Budgeted (1,390,521.46) Remaining Penalties UB 05/07/2019 Penalty removal UB20190507-20190507 User: UB 05/15/2019 Penalty removal UB20190515-20190515 User: UB 05/21/2019 Penalties UB20190521-20190521 User: UB 05/22/2019 Penalty removal UB20190522-20190522 User: DB 05/23/2019 Penalty removal UB20190523-20190523 User: UB 05/24/2019 Penalty removal UB20190524-20190524 User: Billing adj-OTD UB20190524-20190524 User: UB 05/29/2019 Penalty removal UB20190529-20190529 User: UB 05/30/019 Penalty removal UB20190530-20190530 User: Account: 135-47025-000-000 Penalties (136,418.00) Budgeted 59 % Used (57,608.64) Totals: (70,407.70) Remaining 25.84 (57,582.80) 35.67 (57,547.13) (9,641.30) (67,188.43) 53.86 (67,134.57) 32.94 (67,101.63) 28.05 (67,073.58) 1,024.39 (66,049.19) 19.68 (66,029.51) 19.21 (66,010.30) 01.66) (66,010.30) ** 48 % Used UB UB UB UB UB UB UB UB UB Account: 135-47030-000-000 Service Charges 1296 05/08/2019 UB 05/08/2019 Disconnect Fees 1343 05/10/2019 UB 05/10/2019 NSF Check 1378 05/21/2019 UB 05/21/2019 NSF Check 1379 05/22/2019 UB 05/22/2019 NSF Check Account: 135-47030-000-000 Account: 135-47035-000-000 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees Account: 135-47035-000-000 UB20190508-20190508 User: UB20190510-20190510 User: UB20190521-20190521 User: UB20190522-20190522 User: Service Charges (17,000.00) Budgeted Plumbing Inspections 7 Sadie Court 15 Sadie Court 31 Katie Lane 22 Katie Lane Plumbing Inspections (1,500.00) Budgeted (10,250.00) Totals: (5,950.00) Remaining 65 % Used (750.00) (700.00) (10,950.00) (25.00) (10,975.00) (50.00) (11,025.00) (25.00) (11,050.00) (800.00) (50.00) (50.00) (50.00) (50.00) Totals: (550.00) Remaining 63 6 Used (11,050.00) ** (800.00) Drees Homes (850.00) Drees Homes (900.00) Drees Homes (950.00) Drees Homes (200.00) (950.00) ** UB UB UB UB CR CR CR CR glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2019 JE Detail Description/Comment Page 8 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 7 Sadie Court 15 Sadie Court 31 Katie Lane 22 Katie Lane (2,250.00) (150.00) (150.00) (150.00) (150.00) (2,400.00) Drees Homes (2,550.00) Drees Homes (2,700.00) Drees Homes (2,850.00) Drees Homes CR CR CR CR Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (2,850.00) ** (4,500.00) Budgeted (1,650.00) Remaining 63 % Used Account: 135-47070-000-000 TCCC Effluent Charges (1,510.40) .00 (1,510.40) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (1,510.40) ** (60,000.00) Budgeted (58,489.60) Remaining 3 % Used Account: 135-49011-000-000 Interest Income 1484 05/31/2019 Bank Interest- May 1484 05/31/2019 Bank Interest- May 1484 05/31/2019 Bank Interest- May (75,622.78) (733.10) (1,263.03) (9,854.64) (76,355.88) (77,618.91) (87,473.55) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (11,850.77) (87,473.55) ** (80,000.00) Budgeted 7,473.55 Remaining 109 % Used Account: 135-49016-000-000 Cell Tower Revenue (9,757.15) .00 (9,757.15) Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (9,757.15) ** (14,146.00) Budgeted (4,388.85) Remaining 69 % Used Account: 135-49018-000-000 Building Rent Income 1479 05/31/2019 Town Billed Invoices 1688-1691 AR 20190531-20190531 User: (4,083.31) (583.33) (4,666.64) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 5 Used Account: 135-49026-000-000 Proceeds from Sale of Assets (52,600.00) .00 (52,600.00) glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2019 JE Detail Description/Comment Page 9 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (52,600.00) ** (55,000.00) Budgeted (2,400.00) Remaining Account: 135-49035-000-000 Prior Year Reserves Account: 135-49035-000-000 Prior Year Reserves (358,600.00) Budgeted Account: 135-49036-000-000 GASB Reserves Account: 135-49036-000-000 GASB Reserves Totals: (266,613.00) Budgeted .00 Remaining 96 6 Used Totals: (358,600.00) Remaining 0 % Used (266,613.00) Account: 135-49075-000-000 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees 1408 05/01/2019 Permits -Drees Oversize Meter Reimbursement 7 Sadie Court 15 Sadie Court 31 Katie Lane 22 Katie Lane Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (18,522.00) Budgeted (11,662.00) Remaining Account: 135-49141-000-000 Interfund Transfer In 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Reimbusr GenF Account: 135-49141-000-000 Interfund Transfer In .00 Budgeted Account: 135-49900-000-000 1418 05/28/2019 Rfd OTD 1428 05/31/2019 UB 05/31/2019 Billing 100 o Used .00 .00 .00 .00 ** .00 (266,613.00) .00 (266,613.00) ** (5,488.00) (343.00) (5,831.00) Drees Homes CR (343.00) (6,174.00) Drees Homes CR (343.00) (6,517.00) Drees Homes CR (343.00) (6,860.00) Drees Homes CR (1,372.00) (6,860.00) ** 37 % Used (25,000.00) (25,000.00) GL Totals: 25,000.00 Remaining 0 % Used Miscellaneous Income UB20190528-20190528 User: UB20190531-20190531 User: (29,888.28) (25,000.00) (25,000.00) ** (24.81) (29,913.09) UB (271.59) (30,184.68) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (296.40) (30,184.68) ** (7,000.00) Budgeted 23,184.68 Remaining 431 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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-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,191,094.31) ** (599,401.61) Monthly Total (11,343,415.00) Budgeted (6,152,320.69) Remaining 46 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 11 Check Source Number Account: 135-50005-010-000 Salaries & Wages 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Salaries & Wages Salaries & Wages Salaries & Wages 160,440.14 11,973.09 12,666.20 13,049.27 172,413.23 185,079.43 198,128.70 PR PR PR Account: 135-50005-010-000 ' Salaries & Wages Totals: 37,688.56 198,128.70 ** 326,755.00 Budgeted 128,626.30 Remaining 61 % Used Account: 135-50010-010-000 Overtime 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Overtime Overtime Overtime 6,196.23 309.38 903.77 777.14 6,505.61 7,409.38 8,186.52 PR PR PR Account: 135-50010-010-000 Overtime Totals: 1,990.29 8,186.52 ** 20,000.00 Budgeted 11,813.48 Remaining 41 % Used Account: 135-50016-010-000 Longevity 3,620.00 .00 3,620.00 Account: 135-50016-010-000 Longevity Totals: .00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1326 05/17/2019 MUD Payroll 05/17/19 Certification 1,275.00 225.00 1,500.00 PR Account: 135-50017-010-000 Certification Totals: 225.00 1,500.00 ** 4,800.00 Budgeted 3,300.00 Remaining 31 % Used Account: 135-50020-010-000 Retirement 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Retirement Retirement Retirement 16,917.97 1,136.13 1,276.03 1,278.95 18,054.10 19,330.13 20,609.08 PR PR PR Account: 135-50020-010-000 Retirement Totals: 3,691.11 20,609.08 ** 33,304.00 Budgeted 12,694.92 Remaining 62 % Used Account: 135-50026-010-000 Medical Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 Medical Insurance 25,725.12 2,109.86 27,834.98 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1326 05/17/2019 MUD Payroll 05/17/19 Medical Insurance Account: 135-50026-010-000 Medical Insurance Totals: Account: 135-50027-010-000 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 Account: 135-50027-010-000 Account: 135-50028-010-000 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 74,818.00 Budgeted Dental Insurance Dental Insurance Dental Insurance 25,725.12 2,109.82 29,944.80 PR 4,219.68 29,944.80 ** 44,873.20 Remaining 40 % Used Dental Insurance Totals: 4,317.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 2,368.30 Remaining 1,687.15 130.80 277.64 130.75 45 6 Used 1,817.95 1,948.70 261.55 1,948.70 ** 21.25 298.89 21.22 320.11 PR PR PR PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 320.11 ** 701.00 Budgeted Account: 135-50029-010-000 Life Insurance & Other 1172 05/15/2019 May Payroll Benefits Employee Benefits 1172 05/15/2019 May Payroll Benefits Employee LTD & STD 1389 05/28/2019 May A/P Caf 125 380.89 Remaining 46 6 Used 1,507.45 98.56 1,606.01 Humana Inc 91.11 1,697.12 METLIFE GROUP BENEFITS 19.00 1,716.12 BenefitMall 5218 AP 5225 AP 5315 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 208.67 3,131.00 Budgeted 1,414.88 Remaining 55 % Used Account: 135-50030-010-000 Social Security Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 Social Security Taxes 1326 05/17/2019 MUD Payroll 05/17/19 Social Security Taxes 1396 05/31/2019 MUD Payroll 5/31/2019 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 ` Medicare Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 Medicare Taxes 1326 05/17/2019 MUD Payroll 05/17/19 Medicare Taxes 9,237.13 Remaining 10,372.38 731.63 11,104.01 PR 820.02 11,924.03 PR 859.84 12,783.87 PR 2,425.79 58 % Used 2,411.49 12,783.87 ** 171.11 2,596.90 191.80 2,788.70 PR PR glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1396 05/31/2019 MUD Payroll 5/31/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Medicare Taxes 2,425.79 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 201.08 2,989.78 Page 13 Check Source Number PR Account: 135-50035-010-000 ' Medicare Taxes Totals: 563.99 2,989.78 ** 5,150.00 Budgeted 2,160.22 Remaining 58 % Used Account: 135-50040-010-000 Unemployment Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 Unemployment Taxes 1326 05/17/2019 MUD Payroll 05/17/19 Unemployment Taxes 1396 05/31/2019 MUD Payroll 5/31/2019 Unemployment Taxes 767.78 (722.78) .69 1.11 45.00 45.69 46.80 PR PR PR Account: 135-50040-010-000 Unemployment Taxes Totals: (720.98) 46.80 ** 1,080.00 Budgeted 1,033.20 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 132 05/01/2019 Insurance/Wrk Comp Expense May 6,245.98 930.94 7,176.92 GL Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 7,176.92 ** 12,895.00 Budgeted 5,718.08 Remaining 56 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1488 05/31/2019 A/P Department Correction Department Corrections WT-WWT 1488 05/31/2019 A/P Department Correction Department Correction WT -ADMIN 101.00 101.45 101.00 202.45 GL GL Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 202.45 202.45 ** 200.00 Budgeted (2.45) Remaining 101 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 14 Check Source Number Account: 135-55080-010-000 Maintenance & Repairs 1308 05/09/2019 1313 05/10/2019 1334 05/15/2019 1334 05/15/2019 1340 05/16/2019 1419 05/27/2019 1419 05/27/2019 1419 05/27/2019 1419 05/27/2019 1419 05/27/2019 1410 05/30/2019 1445 05/30/2019 1481 05/31/2019 May A/P May A/P May A/P May A/P May A/P PCard 4/27/2019 - 5/27/2019 PCard 4/27/2019 - 5/27/2019 PCard 4/27/2019 - 5/27/2019 PCard 4/27/2019 - 5/27/2019 PCard 4/27/2019 - 5/27/2019 May A/P Valve Replacement- BofA May A/P Parts belt press repair valve replacement -16 Meadowbro Fire hydrant replacement sam s Parts Accident Report chain chains, blades Return Chain pump with switch SCADA repair Off Set Expenses- Damage Claim Fire Extinguisher testing 97,417.55 311.40 750.00 7,884.18 5,213.69 409.50 8.44 15.97 57.91 (14.97) 286.74 490.00 (6,775.94) 197.00 97,728.95 98,478.95 106,363.13 111,576.82 111,986.32 111,994.76 112,010.73 112,068.64 112,053.67 112,340.41 112,830.41 106,054.47 106,251.47 Core & Main LP DHS AUTOMATION, INC REY-MAR CONSTRUCTION REY-MAR CONSTRUCTION Core & Main LP TXDOT CRASH REPORT THE HOME DEPOT #6581 THE HOME DEPOT #6581 THE HOME DEPOT #6581 AMAZON.COM*MN07R2HL0 DHS AUTOMATION, INC 5284 AP 5288 AP 5305 AP 5305 AP 5284 AP PC PC PC PC PC 5341 AP GL All Test Service Solutions LLC 5351 AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 8,833.92 106,251.47 ** 153,000.00 Budgeted 46,748.53 Remaining 69 o Used Account: 135-55085-010-000 Generator Maint. and Repair 1,906.30 .00 1,906.30 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 1,906.30 ** 3,000.00 Budgeted 1,093.70 Remaining 64 % Used Account: 135-55090-010-000 Vehicle Maintenance 1419 05/27/2019 1419 05/27/2019 1419 05/27/2019 PCard PCard PCard 4/27/2019 4/27/2019 4/27/2019 - 5/27/2019 Prem AW 68 HYD FL 50 - 5/27/2019 Terra Cair Def - 5/27/2019 Fuel Filter leak & replacement 2,145.23 53.49 20.00 282.38 2,198.72 2,218.72 2,501.10 ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT GIERISCH CARE 0050292 PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 355.87 2,501.10 ** 5,000.00 Budgeted 2,498.90 Remaining 50 % Used Account: 135-55105-010-000 ' Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55120-010-000 Account: 135-55135-010-000 1334 05/15/2019 May A/P 1342 05/16/2019 May A/P 1342 05/16/2019 May A/P 1481 05/31/2019 May A/P 1495 05/31/2019 May A/P Account: 135-55135-010-000 Cleaning Services Totals: 5,214.00 Budgeted Lab Analysis water sample Lab testing lab testing water sample TCEQ samples Lab Analysis 6,500.00 Budgeted Account: 135-60010-010-000 - Communications/Mobiles 1313 05/10/2019 May A/P Cell phones -May 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Screen Protector 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 phone case .00 .00 5,214.00 Remaining 0 % Used .00 .00 ** 5,047.40 69.00 5,116.40 OXIDOR LABORATORIES LLC 5304 AP 317.40 5,433.80 OXIDOR LABORATORIES LLC 5304 AP 230.00 5,663.80 OXIDOR LABORATORIES LLC 5304 AP 57.00 5,720.80 Centralized Water & Wastewater 5357 AP 431.47 6,152.27 LOWER COLORADO RIVER AUTHORITY 5365 AP Totals: 347.73 Remaining 95 % Used 1,104.87 6,152.27 ** 2,166.43 285.29 2,451.72 VERIZON WIRELESS 5312 AP 7.95 2,459.67 AMZN MKTP US*MN7ZH3NC2 PC 23.45 2,483.12 AMAZON.COM*MN6KT2440 PC Account: 135-60010-010-000 Communications/Mobiles Totals: 316.69 2,483.12 ** 5,000.00 Budgeted 2,516.88 Remaining 50 % Used Account: 135-60020-010-000 1 Electricity 1340 05/16/2019 May A/P Electricity 4/9-5/9 58,617.15 8,070.02 Account: 135-60020-010-000 Electricity Totals: 154,204.00 Budgeted 87,516.83 Remaining 43 6 Used 8,070.02 Account: 135-60066-010-000 Publications/Books/Subscripts .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-010-000 Dues S Memberships 1410 05/30/2019 May A/P Petty cash reimbursement -Nicol 0 % Used 66,687.17 HUDSON ENERGY SERVICES, LLC 5293 AP 66,687.17 ** .00 .00 ** 61.00 61.00 122.00 TROPHY CLUB MUD PETTY CASH 5344 AP glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 16 Account: 135-60070-010-000 Dues & Memberships Totals: 61.00 122.00 ** 500.00 Budgeted 378.00 Remaining 24 % Used Account: 135-60080-010-000 Schools & Training 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Water Environment Fed- PWO Mem 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 TCEQ License Renewal- Bert C. 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 TCEQ License Renewal- Jason R. 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Mike M. WEF Registration 1410 05/30/2019 May A/P Petty cash reimbursement -Nicol 2,036.00 105.00 2,141.00 WEF MAIN 111.00 2,252.00 TCEQ IND RENEWAL LIC 111.00 2,363.00 TCEQ IND RENEWAL LIC 725.00 3,088.00 WEF REG 7.01 3,095.01 TROPHY CLUB MUD PETTY CASH PC PC PC PC 5344 AP Account: 135-60080-010-000 Schools & Training Totals: 1,059.01 3,095.01 ** 4,651.00 Budgeted 1,555.99 Remaining 67 % Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Mike M. Plane Ticket for WEF 309.39 369.59 678.98 AMERICAN AIRLINES PC Account: 135-60100-010-000 Travel & per diem Totals: 369.59 678.98 ** 2,345.00 Budgeted 1,666.02 Remaining 29 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 16,336.53 .00 16,336.53 Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 16,336.53 ** 58,000.00 Budgeted 41,663.47 Remaining 28 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-60150-010-000 Wholesale Water 1481 05/31/2019 May A/P Wholesale water Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Wholesale Water Totals: 716,651.51 144,474.55 3,013,494.00 Budgeted 2,152,367.94 Remaining 29 % Used Miscellaneous Expenses Miscellaneous Expenses Totals: 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 top soil 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 sand Account: 135-60280-010-000 200.00 Remaining Property Maintenance Totals: 3,000.00 Budgeted 861,126.06 CITY OF FORT WORTH 5358 AP 144,474.55 861,126.06 ** .00 0 % Used .00 .00 .00 ** 336.00 108.00 444.00 DENTON SAND & GRAVEL, 168.00 612.00 DENTON SAND & GRAVEL, 2,388.00 Remaining 20 % Used 276.00 612.00 ** Account: 135-60285-010-000 Lawn Equipment & Maintenance 1389 05/28/2019 May A/P Mowing -May 2,840.00 1,500.00 4,340.00 WATTS ELLISON LLC Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 10,410.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1443 05/31/2019 TexPool Transfers May TexPool O&M to 16Swift Rev I&S PC PC 5340 AP 1,500.00 4,340.00 ** 29 % Used 176,209.67 25,172.81 201,382.48 GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 383,826.52 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1443 05/31/2019 TexPool Transfers May TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 18,393.00 Remaining 25,172.81 201,382.48 ** 34 % Used 32,200.00 4,600.00 36,800.00 GL 4,600.00 36,800.00 ** 67 % Used Account: 135-60334-010-000 Interfund Transfer Out glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-60334-010-000 Account: 135-60360-010-000 .00 .00 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining Furniture/Equipment < $5000 O % Used .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** Account: 135-65005-010-000 1401 05/24/2019 Fuel Account: 135-65005-010-000 2,500.00 Budgeted 2,500.00 Remaining Fuel & Lube Fuel O % Used 5,743.11 1,103.87 6,846.98 US Bank Voyager Fleet Systems 5345 AP Fuel & Lube Totals: 1,103.87 6,846.98 ** 15,000.00 Budgeted 8,153.02 Remaining 46 % Used Account: 135-65010-010-000 Uniforms 1481 05/31/2019 May A/P safety shirts -Hi -vis Account: 135-65010-010-000 1,417.41 653.40 2,070.81 Ritz Safety, LLC 5372 AP Uniforms ' Totals: - 653.40 2,070.81 ** 3,119.19 Remaining 40 % Used 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals - 1389 05/28/2019 May A/P Chlorine 13,347.99 1,116.81 Account: 135-65030-010-000 14,464.80 DPC INDUSTRIES, INC 5319 AP Chemicals Totals: 1,116.81 14,464.80 ** 20,000.00 Budgeted Account: 135-65035-010-000 Small Tools 5,535.20 Remaining 72 % Used .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 tax (48.95) (48.95) TX AMERICA SAFETY PC glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2019 Page 19 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 vehicle kit- 93 piece kit 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 safety equip- supports, vests, 48.00 (.95) TX SAFETY TX AMERICA S 642.20 641.25 TX AMERICA SAFETY PC PC Account: 135-65040-010-000 Safety Equipment Totals: 641.25 641.25 ** 1,000.00 Budgeted 358.75 Remaining 64 % Used Account: 135-65050-010-000 Meter Expense 1447 05/30/2019 Meter Replacemens 1481 05/31/2019 May A/P 1481 05/31/2019 May A/P Bryon Nelson Replaced 3" & 6" Meter meters meters 17,861.60 (9,312.50) 2,974.00 6,338.50 8,549.10 11,523.10 17,861.60 ATLAS ENTERPRISES, INC ATLAS ENTERPRISES, INC 5353 5353 GL AP AP Account: 135-65050-010-000 Meter Expense Totals: .00 17,861.60 ** 70,000.00 Budgeted 52,138.40 Remaining 26 % Used Account: 135-65053-010-000 Meter Change Out Program 1334 05/15/2019 May A/P 1481 05/31/2019 May A/P meter change outs meters 32,262.00 11,595.00 43,092.00 43,857.00 86,949.00 ATLAS UTILITY SUPPLY CO. ATLAS ENTERPRISES, INC 5282 5353 AP AP Account: 135-65053-010-000 Meter Change Out Program Totals: 54,687.00 86,949.00 ** 87,000.00 Budgeted 51.00 Remaining 100 o Used Account: 135-69005-010-000 Capital Outlays 1334 05/15/2019 May A/P 1410 05/30/2019 May A/P 1410 05/30/2019 May A/P Valve Replacements 286,724.26 VFD upgrade Valve replacement 538 Indian C 37,999.09 144,453.60 3,978.23 324,723.35 469,176.95 473,155.18 REY-MAR CONSTRUCTION REY-MAR CONSTRUCTION REY-MAR CONSTRUCTION 5305 5343 5343 AP AP AP Account: 135-69005-010-000 Capital Outlays Totals: 186,430.92 473,155.18 ** 719,613.00 Budgeted 246,457.82 Remaining 66 % Used Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 .00 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,068.00 ** 30,068.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 2,283.93 .00 2,283.93 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 20 Check Source Number 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 75,000.00 .00 75,000.00 Account: 135-69195-010-000 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 Account: 135-70040-010-000 Bond Related Expenses 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Reimbusr GenF 7,080.00 (7,080.00) .00 GL Account: 135-70040-010-000 Bond Related Expenses Totals: (7,080.00) .00 ** .00 Budgeted .00 Remaining 0 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Page 21 Account: 135-55135-010-001 Lab Analysis for PID 1506 05/31/2019 May A/P water samples 975.40 80.00 1,055.40 TARRANT CTY PUBLIC HEALTH LAB 5373 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,055.40 ** Department 10 Totals: 2,000.00 Budgeted 485,542.80 Monthly Total 944.60 Remaining 53 % Used 2,409,922.40 ** 5,961,447.00 Budgeted 3,551,524.60 Remaining 40 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 22 Check Source Number Account: 135-50005-020-000 Salaries & Wages 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Salaries & Wages Salaries & Wages Salaries & Wages 184,213.89 14,500.06 13,475.99 13,446.48 198,713.95 212,189.94 225,636.42 PR PR PR Account: 135-50005-020-000 ' Salaries & Wages Totals: 41,422.53 225,636.42 ** 421,699.00 Budgeted 196,062.58 Remaining 54 % Used Account: 135-50010-020-000 Overtime 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Overtime Overtime Overtime 20,928.15 1,187.49 1,789.59 1,182.95 22,115.64 23,905.23 25,088.18 PR PR PR Account: 135-50010-020-000 Overtime Totals: 4,160.03 25,088.18 ** 30,000.00 Budgeted 4,911.82 Remaining 84 % Used Account: 135-50016-020-000 Longevity 7,445.00 .00 7,445.00 Account: 135-50016-020-000 Longevity Totals: .00 7,445.00 ** 7,445.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1326 05/17/2019 MUD Payroll 05/17/19 Certification 5,000.00 700.00 5,700.00 PR Account: 135-50017-020-000 Certification Totals: 700.00 5,700.00 ** 8,700.00 Budgeted 3,000.00 Remaining 66 % Used Account: 135-50020-020-000 Retirement 1202 05/03/2019 MUD Payroll 1326 05/17/2019 MUD Payroll 1396 05/31/2019 MUD Payroll 5/3/2019 05/17/19 5/31/2019 Retirement Retirement Retirement 21,643.50 1,451.09 1,476.82 1,353.23 23,094.59 24,571.41 25,924.64 PR PR PR Account: 135-50020-020-000 Retirement Totals: 4,281.14 25,924.64 ** 43,276.00 Budgeted 17,351.36 Remaining 60 % Used Account: 135-50026-020-000 Medical Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 Medical Insurance 38,294.90 2,794.26 41,089.16 PR glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1326 05/17/2019 MUD Payroll 05/17/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Medical Insurance 38,294.90 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 2,794.22 43,883.38 Page 23 Check Source Number PR 1326 05/17/2019 MUD Payroll 05/17/19 Medicare Taxes 215.98 3,399.52 PR Account: 135-50026-020-000 Medical Insurance Totals: 5,588.48 43,883.38 ** 91,627.00 Budgeted 47,743.62 Remaining 48 % Used Account: 135-50027-020-000 Dental Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 Dental Insurance Dental Insurance 2,477.91 170.29 170.27 2,648.20 2,818.47 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 340.56 2,818.47 ** 5,104.00 Budgeted 2,285.53 Remaining 55 % Used Account: 135-50028-020-000 Vision Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 Vision Insurance Vision Insurance 399.26 27.83 27.81 427.09 454.90 PR PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 454.90 ** 826.00 Budgeted 371.10 Remaining 55 % Used Account: 135-50029-020-000 Life Insurance & Other 1172 05/15/2019 May Payroll Benefits 1172 05/15/2019 May Payroll Benefits 1389 05/28/2019 May A/P Employee Benefits Employee LTD & Caf 125 STD 2,221.13 184.80 78.34 38.00 2,405.93 2,484.27 2,522.27 Humana Inc METLIFE GROUP BENEFITS BenefitMall 5218 5225 5315 AP AP AP Account: 135-50029-020-000 ' Life Insurance & Other Totals: 301.14 2,522.27 ** 4,495.00 Budgeted 1,972.73 Remaining 56 % Used Account: 135-50030-020-000 Social Security Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 1396 05/31/2019 MUD Payroll 5/31/2019 Social Security Social Security Social Security Taxes Taxes Taxes 12,678.16 934.16 923.63 909.61 13,612.32 14,535.95 15,445.56 PR PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 2,767.40 15,445.56 ** 29,006.00 Budgeted 13,560.44 Remaining 53 % Used Account: 135-50035-020-000 Medicare Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 Medicare Taxes 2,965.05 218.49 3,183.54 PR 1326 05/17/2019 MUD Payroll 05/17/19 Medicare Taxes 215.98 3,399.52 PR glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1396 05/31/2019 MUD Payroll 5/31/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Medicare Taxes 2,965.05 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 212.74 3,612.26 Page 24 Check Source Number PR 1334 05/15/2019 May A/P 1334 05/15/2019 May A/P 1481 05/31/2019 May A/P 1488 05/31/2019 A/P Department Correction Employee Drug screen-Mcclain, Employee Drug screen-Mcclain, Drug screening -D Roberts Department Corrections WT-WWT 38.00 38.00 63.00 76.00 (101.00) 76.00 CARENOW CORPORATE 139.00 CARENOW CORPORATE 215.00 CARENOW CORPORATE 114.00 5283 AP 5283 AP 5356 AP GL Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 76.00 114.00 ** 400.00 Budgeted Account: 135-50035-020-000 ' Medicare Taxes Totals: 647.21 3,612.26 ** 6,784.00 Budgeted 3,171.74 Remaining 53 % Used .00 .00 Account: 135-50040-020-000 Unemployment Taxes Employee Relations Totals: .00 .00 ** 300.00 Budgeted 1202 05/03/2019 MUD Payroll 5/3/2019 Unemployment Taxes 0 % Used 972.00 (918.00) 54.00 Engineering PR Account: 135-50040-020-000 Unemployment Taxes Totals: (918.00) 54.00 ** .00 .00 1,260.00 Budgeted 1,206.00 Remaining 4 % Used .00 .00 ** Account: 135-50045-020-000 Workman's Compensation 30,000.00 Remaining 0 % Used 132 05/01/2019 Insurance/Wrk Comp Expense May 8,090.31 1,205.73 9,296.04 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 9,296.04 ** 16,941.00 Budgeted 7,644.96 Remaining 55 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1334 05/15/2019 May A/P 1334 05/15/2019 May A/P 1481 05/31/2019 May A/P 1488 05/31/2019 A/P Department Correction Employee Drug screen-Mcclain, Employee Drug screen-Mcclain, Drug screening -D Roberts Department Corrections WT-WWT 38.00 38.00 63.00 76.00 (101.00) 76.00 CARENOW CORPORATE 139.00 CARENOW CORPORATE 215.00 CARENOW CORPORATE 114.00 5283 AP 5283 AP 5356 AP GL Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 76.00 114.00 ** 400.00 Budgeted 286.00 Remaining 29 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 25 Check Source Number Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Independent Labor 15,000.00 Budgeted Totals: 12,079.00 Remaining Account: 135-55080-020-000 Maintenance & Repairs 1308 05/09/2019 May A/P Door repair at WWTP 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 flat sewer tape 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 sprayer, filter 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Filters 1389 05/28/2019 May A/P UV bulbs/sleeves 1389 05/28/2019 May A/P rubber grommets 1389 05/28/2019 May A/P pvc parts for drains 1410 05/30/2019 May A/P Petty cash reimbursement -Nicol 1410 05/30/2019 May A/P Air scour meter on MBRS Account: 135-55080-020-000 Maintenance & Repairs 133,000.00 Budgeted 38,070.78 Remaining 2,921.00 91,113.61 19 % Used .00 .00 2,921.00 2,921.00 ** 1,995.45 93,109.06 152.95 93,262.01 29.45 93,291.46 344.66 93,636.12 406.49 94,042.61 344.46 94,387.07 169.16 94,556.23 12.99 94,569.22 360.00 94,929.22 71 % Used 3,815.61 REY-MAR CONSTRUCTION USA BLUE BOOK THE HOME DEPOT #6581 FILTER ELEMENT STORE UV DOCTOR LAMPS LLC NORTH TEXAS PUMP CO. ROANOKE WINNELSON CO. TROPHY CLUB MUD PETTY CASH DHS AUTOMATION, INC 94,929.22 ** 5305 AP PC PC PC 5338 AP 5331 AP 5335 AP 5344 AP 5341 AP Account: 135-55085-020-000 1 Generator Maint. and Repair 4,550.82 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 10,000.00 Budgeted 5,449.18 Remaining 46 % Used Account: 135-55090-020-000 Vehicle Maintenance 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Account: 135-55090-020-000 Account: 135-55105-020-000 Account: 135-55105-020-000 Oil Change Car Plugr, Terra Cair Def trailer wire connector, etc. 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 4,550.82 .00 ' 4,550.82 ** 1,450.54 76.56 1,527.10 KWIK KAR LUBE & TUNE 0 74.95 1,602.05 ROANOKE AUTO SUPPLY LT 74.19 1,676.24 ROANOKE AUTO SUPPLY LT 6,803.00 21 % Used 225.70 .00 97 % Used .00 1,676.24 ** 6,803.00 6,803.00 ** PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55120-020-000 Cleaning Services 1 .00 .00 Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 1 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 1 1313 05/10/2019 May A/P 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1481 05/31/2019 May A/P sludge to landfill sludge haul off sludge haul off sludge haul off sludge haul off sludge haul off sludge haul off 42,314.24 2,709.92 1,690.00 1,745.35 845.42 845.00 1,690.00 845.00 45,024.16 L.H. CHANEY MATERIALS, INC. 46,714.16 L.H. CHANEY MATERIALS, INC. 48,459.51 L.H. CHANEY MATERIALS, INC. 49,304.93 L.H. CHANEY MATERIALS, INC. 50,149.93 L.H. CHANEY MATERIALS, INC. 51,839.93 L.H. CHANEY MATERIALS, INC. 52,684.93 L.H. CHANEY MATERIALS, INC. 5297 AP 5327 AP 5327 AP 5327 AP 5327 AP 5327 AP 5364 AP Account: 135-55125-020-000 Dumpster Services Totals: 10,370.69 52,684.93 ** 75,000.00 Budgeted 22,315.07 Remaining 70 % Used Account: 135-55135-020-000 Lab Analysis 1313 05/10/2019 May A/P 1313 05/10/2019 May A/P 1334 05/15/2019 May A/P 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1410 05/30/2019 May A/P 1410 05/30/2019 May A/P 1481 05/31/2019 May A/P Lab testing lab testing open end bags Effluent testing effluent testing lab testing lab testing bio monitoring 27,545.16 276.00 27,821.16 OXIDOR LABORATORIES LLC 5304 AP 230.00 28,051.16 OXIDOR LABORATORIES LLC 5304 AP 251.57 28,302.73 HACH COMPANY 5291 AP 230.00 28,532.73 OXIDOR LABORATORIES LLC 5334 AP 317.40 28,850.13 OXIDOR LABORATORIES LLC 5334 AP 317.40 29,167.53 OXIDOR LABORATORIES LLC 5342 AP 230.00 29,397.53 OXIDOR LABORATORIES LLC 5342 AP 1,080.00 30,477.53 HUTHER AND ASSOCIATES,INC 5361 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,932.37 30,477.53 ** 35,000.00 Budgeted 4,522.47 Remaining 87 % Used Account: 135-60010-020-000 Communications/Mobiles 1313 05/10/2019 May A/P Cell phones -May 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Frank I. Phone Case 3,040.13 418.14 3,458.27 VERIZON WIRELESS 5312 AP 24.48 3,482.75 AMZN MKTP US*MN7XR6SV1 PC Account: 135-60010-020-000 Communications/Mobiles Totals: 442.62 3,482.75 ** 5,000.00 Budgeted 1,517.25 Remaining 70 % Used Account: 135-60020-020-000 Electricity glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment 1340 05/16/2019 May A/P Electricity 4/9-5/9 1479 05/31/2019 Town Billed Invoices 1688-1691 AR 20190531-20190531 User: Account: 135-60020-020-000 Electricity Totals: 174,165.00 Budgeted 75,047.25 Remaining 87,850.49 57 % Used Program: Transaction Detail 11,517.16 (249.90) 11,267.26 Transaction Vendor_Name Detail (SUBTOTAL) 99,367.65 HUDSON ENERGY SERVICES, LLC 99,117.75 99,117.75 ** Page 27 Check Source Number 5293 AP AR Account: 135-60066-020-000 Publications/Books/Subscripts Account: 135-60066-020-000 Account: 135-60070-020-000 1410 05/30/2019 May A/P Account: 135-60070-020-000 Account: 135-60080-020-000 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1410 05/30/2019 May A/P 1410 05/30/2019 May A/P Account: 135-60080-020-000 Account: 135-60090-020-000 Account: 135-60090-020-000 Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Dues & Memberships Petty cash reimbursement -Nicol Dues & Memberships Totals: 300.00 Budgeted 109.00 Remaining Schools & Training - 5/27/2019 Frank I. WEF Registration - 5/27/2019 Water Environment Fed- PWO mem Petty cash reimbursement -Nicol Petty cash reimbursement -Nicol Schools & Training Totals: 7,155.00 Budgeted 5,346.77 Remaining Safety Program Safety Program Totals: 1,000.00 Budgeted 899.26 Remaining Account: 135-60100-020-000 Travel & per diem 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Frank I. Plane Ticket for WEF Account: 135-60100-020-000 Travel & per diem Totals: 1,895.00 Budgeted .00 .00 0 % Used .00 .00 ** 180.00 11.00 191.00 TROPHY CLUB MUD PETTY CASH 862.95 100.74 174.96 64 % Used 25 % Used 10 % Used 11.00 725.00 105.00 60.33 54.95 945.28 .00 .00 369.59 1,350.45 Remaining 29 % Used 369.59 191.00 ** 1,587.95 1,692.95 1,753.28 1,808.23 WEF REG WEF MAIN TROPHY CLUB MUD PETTY CASH TROPHY CLUB MUD PETTY CASH 1,808.23 ** 100.74 100.74 ** 544.55 AMERICAN AIRLINES 544.55 ** 5344 AP PC PC 5344 AP 5344 AP PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 Account: 135-60285-020-000 Lawn Equipment & Maintenance 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 mower part 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 mower 1389 05/28/2019 May A/P Mowing -May Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted • .00 225.18 .00 • 225.18 ** 1,990.73 29.00 2,019.73 KYLES SMALL ENGINE REP PC 219.00 2,238.73 THE HOME DEPOT 6581 PC 1,180.00 3,418.73 WATTS ELLISON LLC 5340 AP 8,181.27 Remaining 29 % Used 1,428.00 3,418.73 ** ' glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 29 Check Source Number Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1443 05/31/2019 TexPool Transfers May TexPool O&M to I&S- PID Debt 76,397.30 10,913.90 87,311.20 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,913.90 87,311.20 ** 120,053.00 Budgeted 32,741.80 Remaining 73 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1443 05/31/2019 TexPool Transfers May TexPool O&M to Rev Bd WWTP I&S 379,424.15 54,203.45 433,627.60 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,203.45 433,627.60 ** 688,330.00 Budgeted 254,702.40 Remaining 63 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1443 05/31/2019 TexPool Transfers May TexPool O&M to Rev Bond Resevr 73,024.00 10,432.00 83,456.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 83,456.00 ** 125,187.00 Budgeted 41,731.00 Remaining 67 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1401 05/24/2019 Fuel Fuel 6,896.29 1,098.53 7,996.82 US Bank Voyager Fleet Systems 5345 AP Account: 135-65005-020-000 Fuel & Lube Totals: 1,098.53 7,996.82 ** 12,500.00 Budgeted 4,503.18 Remaining 64 o Used Account: 135-65010-020-000 Uniforms glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/31/2019 May A/P safety shirts -Hi -vis 2,059.90 653.40 2,713.30 Ritz Safety, LLC 5372 AP Account: 135-65010-020-000 Uniforms Totals: 653.40 2,713.30 ** 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals 1334 05/15/2019 May A/P Degreaser for L.S. 1389 05/28/2019 May A/P Sodium Hypo 12.5% 1389 05/28/2019 May A/P De Foamer 2,781.70 Remaining 49 % Used 20,798.84 3,456.75 569.00 1,674.90 24,255.59 MICKEY D CARSON DBA/NUSCO 24,824.59 Valley Solvent Company, INC 26,499.49 MARYLAND BIOCHEMICAL CO, INC 5302 AP 5339 AP 5329 AP Account: 135-65030-020-000 Chemicals Totals: 5,700.65 26,499.49 ** 30,000.00 Budgeted 3,500.51 Remaining 88 % Used Account: 135-65035-020-000 Small Tools 54.95 .00 54.95 Account: 135-65035-020-000 Small Tools Totals: .00 54.95 ** 1,200.00 Budgeted 1,145.05 Remaining 5 % Used Account: 135-65040-020-000 Safety Equipment 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Hard hat brim shade 1,095.69 33.23 1,128.92 USA BLUE BOOK PC Account: 135-65040-020-000 Safety Equipment Totals: 33.23 1,128.92 ** 1,200.00 Budgeted 71.08 Remaining 94 % Used Account: 135-65045-020-000 Lab Supplies 1340 05/16/2019 May A/P Lab gloves for samples 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 distilled water 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 graduated cylinder 3,349.83 160.60 3,510.43 LOU'S GLOVES INCORPORATED 5298 AP 3.96 3,514.39 TOM THUMB #1789 PC 39.95 3,554.34 USA BLUE BOOK PC Account: 135-65045-020-000 Lab Supplies Totals: 204.51 3,554.34 ** Account: 135-69005-020-000 1308 05/09/2019 May A/P 1334 05/15/2019 May A/P Account: 135-69005-020-000 20,000.00 Budgeted Capital Outlays GIR meters Pacts for WWTP 16,445.66 Remaining 18 % Used Capital Outlays Totals: 688,600.00 Budgeted 490,172.37 7,759.14 497,931.51 ENDRESS + HAUSER, INC 5289 AP 1,694.00 499,625.51 Core & Main LP 5284 AP 188,974.49 Remaining 73 % Used 9,453.14 499,625.51 ** glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 31 Check Source Number Department 20 Totals: .00 Budgeted 185,128.79 Monthly Total (1,500.00) Remaining 0 % Used 1,911,317.35 ** 3,281,182.00 Budgeted 1,369,864.65 Remaining 58 % 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 185,128.79 Monthly Total (1,500.00) Remaining 0 % Used 1,911,317.35 ** 3,281,182.00 Budgeted 1,369,864.65 Remaining 58 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 132 05/01/2019 Insurance/Wrk Comp Expense May Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 30.00 Budgeted Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 14.84 2.12 13.04 Remaining 57 % Used 16.96 GL 2.12 16.96 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 650.00 .00 650.00 Totals: 100.00 Remaining 87 % Used .00 650.00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted 34.38 Totals: 1,265.62 Remaining 3 % Used .00 34.38 .00 34.38 ** Account: 135-60080-026-000 Schools & Training Account: 135-60080-026-000 Schools & Training 4,000.00 Budgeted 920.00 Totals: 3,080.00 Remaining 23 % Used .00 920.00 .00 920.00 ** Account: 135-60100-026-000 Travel & per diem 338.57 .00 338.57 Account: 135-60100-026-000 Travel & per diem Totals: .00 338.57 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,661.43 Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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: 1,959.91 ** 2.12 Monthly Total 13,230.00 Budgeted 11,270.09 Remaining 15 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 1396 05/31/2019 MUD Payroll 5/31/2019 Salaries & Wages Salaries & Wages Salaries & Wages 199,394.13 14,624.04 214,018.17 PR 14,620.27 228,638.44 PR 14,637.12 243,275.56 PR Account: 135-50005-030-000 1 Salaries & Wages Totals: 43,881.43 243,275.56 ** 441,006.00 Budgeted 197,730.44 Remaining 55 % Used Account: 135-50010-030-000 Overtime 1202 05/03/2019 MUD Payroll 5/3/2019 Overtime 51.53 6.45 57.98 PR Account: 135-50010-030-000 Overtime Totals: 6.45 57.98 ** 2,000.00 Budgeted 1,942.02 Remaining 3 % Used Account: 135-50016-030-000 Longevity 1,832.50 .00 1,832.50 Account: 135-50016-030-000 Longevity Totals: .00 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1202 05/03/2019 MUD Payroll 5/3/2019 Retirement 1326 05/17/2019 MUD Payroll 05/17/19 Retirement 1396 05/31/2019 MUD Payroll 5/31/2019 Retirement 19,978.43 1,353.33 21,331.76 PR 1,352.38 22,684.14 PR 1,353.92 24,038.06 PR Account: 135-50020-030-000 Retirement Totals: 4,059.63 24,038.06 ** 41,148.00 Budgeted 17,109.94 Remaining 58 % Used Account: 135-50026-030-000 Medical Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 Medical Insurance 32,683.56 1326 05/17/2019 MUD Payroll 05/17/19 Medical Insurance 2,561.73 35,245.29 PR 2,561.67 37,806.96 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,123.40 37,806.96 ** 81,895.00 Budgeted 44,088.04 Remaining 46 % Used Account: 135-50027-030-000 Dental Insurance 1202 05/03/2019 MUD Payroll 5/3/2019 Dental Insurance 1326 05/17/2019 MUD Payroll 05/17/19 Dental Insurance 1,893.84 144.93 2,038.77 PR 144.90 2,183.67 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-030-000 Dental Insurance Totals: 289.83 2,183.67 ** Account: 135-50028-030-000 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 4,291.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 2,107.33 Remaining 51 % Used 306.80 22.76 329.56 22.72 352.28 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 45.48 352.28 ** Account: 135-50029-030-000 1172 05/15/2019 May Payroll Benefits 1172 05/15/2019 May Payroll Benefits 1389 05/28/2019 May A/P 701.00 Budgeted 348.72 Remaining 50 6 Used Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 2,092.18 149.52 2,241.70 Humana Inc 142.90 2,384.60 METLIFE GROUP BENEFITS 19.00 2,403.60 BenefitMall 5218 AP 5225 AP 5315 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 311.42 2,403.60 ** Account: 135-50030-030-000 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 1396 05/31/2019 MUD Payroll 5/31/2019 Account: 135-50030-030-000 Account: 135-50035-030-000 1202 05/03/2019 MUD Payroll 5/3/2019 1326 05/17/2019 MUD Payroll 05/17/19 1396 05/31/2019 MUD Payroll 5/31/2019 Account: 135-50035-030-000 4,495.00 Budgeted 2,091.40 Remaining 53 6 Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 27,580.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 11,905.91 856.63 12,762.54 PR 852.86 13,615.40 PR 907.51 14,522.91 PR Totals: 13,057.09 Remaining 53 % Used Medicare Taxes Totals: 6,450.00 Budgeted Account: 135-50040-030-000 Unemployment Taxes 1202 05/03/2019 MUD Payroll 5/3/2019 Unemployment Taxes 1326 05/17/2019 MUD Payroll 05/17/19 Unemployment Taxes 3,053.50 Remaining 2,617.00 14,522.91 ** 2,784.45 200.34 2,984.79 PR 199.46 3,184.25 PR 212.25 3,396.50 PR 815.88 53 % Used 612.05 3,396.50 ** (757.68) 58.20 1.27 59.47 PR PR glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment 1396 05/31/2019 MUD Payroll 5/31/2019 Unemployment Taxes Account: 135-50040-030-000 ' Unemployment Taxes Totals: 1,260.00 Budgeted 1,200.42 Remaining Account: 135-50045-030-000 Workman's Compensation 132 05/01/2019 Insurance/Wrk Comp Expense May Account: 135-50045-030-000 Account: 135-50060-030-000 1481 05/31/2019 May A/P 1488 05/31/2019 A/P Department Correction Workman's Compensation Totals: 1,295.00 Budgeted 482.20 Remaining Pre-emp Physicals/Testing Drug screening -G Gallagher Department Correction WT -ADMIN Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Account: 135-55030-030-000 1246 05/02/2019 May A/P 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1419 05/27/2019 PCard 4/27/2019 1392 05/28/2019 May A/P Account: 135-55030-030-000 Account: 135-55070-030-000 Pre-emp Physicals/Testing Totals: 500.00 Budgeted 358.05 Remaining Employee Relations Employee Relations Totals: 5,000.00 Budgeted 1,981.49 Remaining Software & Support Check scanner maintenance - 5/27/2019 Remove branding on website - 5/27/2019 Website - 5/27/2019 internet - 5/27/2019 Internet - 5/27/2019 phone - 5/27/2019 Adobe Software subscription - 5/27/2019 clear rec software Internet -May Software & Support Totals: 77,849.00 Budgeted 31,124.17 Remaining Independent Labor 815.88 706.25 Program: Transaction Detail .11 5 % Used (756.30) 106.55 63 6 Used 106.55 Transaction Vendor_Name Detail (SUBTOTAL) 59.58 59.58 ** 812.80 812.80 ** 205.40 38.00 243.40 CARENOW CORPORATE 3,018.51 44,482.12 (101.45) 28 % Used 60 % Used 60 6 Used (63.45) .00 nn 425.00 10.77 18.17 162.25 53.33 42.02 32.45 595.00 903.72 2,242.71 141.95 141.95 ** 3,018.51 3,018.51 ** 44,907.12 44,917.89 44,936.06 45,098.31 45,151.64 45,193.66 45,226.11 45,821.11 46,724.83 TECHNIQUE DATA SYSTEMS INC FS *DIGITALWAVE DNH*GODADDY.COM ATT*BILL PAYMENT ATT*SILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS CONWAY COMPANY CPAS Charter Communications 46124.83 ** Page 36 Check Source Number PR GL 5356 AP GL 5260 AP PC PC PC PC PC PC PC 5316 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/31/2019 May A/P 1481 05/31/2019 May A/P Account: 135-55070-030-000 Account: 135-55080-030-000 Account: 135-55080-030-000 GM May 2019 GM May 2019 Independent Labor Totals: 82,570.95 13,200.00 175,000.00 Budgeted 79,183.27 Remaining 55 % Used Maintenance s Repairs Maintenance & Repairs Totals: 20,000.00 Budgeted 15,460.00 Remaining 4,540.00 23 % Used 95,770.95 Carman Consulting LLC. 5355 AP 45.78 95,816.73 Carman Consulting LLC. 13,245.78 95,816.73 ** .00 4,540.00 .00 4,540.00 ** 5355 AP Account: 135-55085-030-000 Generator Maint. and Repair Account: 135-55085-030-000 Account: 135-55120-030-000 1334 05/15/2019 May A/P 1481 05/31/2019 May A/P Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,072.48 Remaining Cleaning Services Janitorial svc-April Janitorial svc-May 927.52 .00 927.52 9 % Used .00 927.52 ** 5,214.36 869.06 6,083.42 MEMBER'S BUILDING MAINTENANCE 5301 AP 869.06 6,952.48 MEMBER'S BUILDING MAINTENANCE 5367 AP Account: 135-55120-030-000 Cleaning Services Totals: 1,738.12 6,952.48 ** 10,000.00 Budgeted 3,047.52 Remaining 70 % Used Account: 135-55160-030-000 Professional Outside Services Account: 135-55160-030-000 Professional Outside Services Totals: 66,055.00 Budgeted 4,128.50 Remaining Account: 135-55205-030-000 Utility Billing Contract 1495 05/31/2019 May A/P Account: 135-55205-030-000 61,926.50 Water billings -May 4,068.81 Utility Billing Contract Totals: 9,000.00 Budgeted 4,348.83 Remaining .00 61,926.50 94 % Used 52 % Used .00 61,926.50 ** 582.36 4,651.17 DATAPROSE LLC 5359 AP 582.36 4,651.17 ** Account: 135-60005-030-000 Telephone glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 38 1246 05/02/2019 May A/P Answering service -May 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 phone 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 phone 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 phone 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 phone 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 answering service 1479 05/31/2019 Town Billed Invoices 1688-1691 AR 20190531-20190531 User: 10,333.41 224.75 460.43 771.68 42.02 39.73 14.99 (180.00) 10,558.16 KEYSTONE PARK SECRETARIAL 11,018.59 ATT*BUS PHONE PMT 11,790.27 ATT*BUS PHONE PMT 11,832.29 ATT*BILL PAYMENT 11,872.02 ATT*BILL PAYMENT 11,887.01 RINGCENTRAL, INC 11,707.01 5255 AP PC PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,373.60 11,707.01 ** 23,500.00 Budgeted 11,792.99 Remaining 50 % Used Account: 135-60010-030-000 Communications/Mobiles 1313 05/10/2019 May A/P 1326 05/17/2019 MUD Payroll 05/17/19 Cell phones -May Communications/Mobiles 1,662.57 87.45 150.00 1,750.02 1,900.02 VERIZON WIRELESS 5312 AP PR Account: 135-60010-030-000 Communications/Mobiles _ Totals: 237.45 1,900.02 ** 4,000.00 Budgeted 2,099.98 Remaining 48 % Used Account: 135-60020-030-000 Electricity/Gas 1391 05/28/2019 May A/P Electricity admin- 3/11-4/9 3,879.64 547.78 4,427.42 TOWN OF TROPHY CLUB 5337 AP Account: 135-60020-030-000 Electricity/Gas Totals: 547.78 4,427.42 ** 8,690.00 Budgeted 4,262.58 Remaining 51 % Used Account: 135-60025-030-000 Water 1479 05/31/2019 Town Billed 1481 05/31/2019 May A/P Invoices 1688-1691 AR 20190531-20190531 User: water -May 387.01 (59.04) 118.09 327.97 446.06 TROPHY CLUB MUD (WATER BILLS) 5376 AR AP Account: 135-60025-030-000 Water Totals: 59.05 446.06 ** 2,000.00 Budgeted 1,553.94 Remaining 22 % Used Account: 135-60035-030-000 Postage 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 postage 1495 05/31/2019 May A/P Water billings -May 13,176.38 103.50 1,627.04 13,279.88 14,906.92 FP MAILING SOLUTIONS DATAPROSE LLC 5359 PC AP Account: 135-60035-030-000 Postage Totals: 1,730.54 14,906.92 ** 30,000.00 Budgeted 15,093.08 Remaining 50 % Used Account: 135-60040-030-000 Service Charges & Fees glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1203 05/03/2019 Child Support fee 1329 05/17/2019 Child Support Fee 1389 05/28/2019 May A/P 1398 05/31/2019 Child Support Fee 1441 05/31/2019 Pace Credit Card Fees 1441 05/31/2019 Pace Credit Card Fees 1495 05/31/2019 May A/P Account: 135-60040-030-000 Direct send fees Dig Tess -May Service Charges & Fees Totals: 55,560.00 Budgeted 12,247.66 Remaining Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 Bad Debt Expense Totals: 1,500.00 Budgeted Account: 135-60055-030-000 Insurance 132 05/01/2019 Insurance/Wrk Comp Expense May Account: 135-60055-030-000 38,440.22 1.50 38,441.72 GL 1.50 38,443.22 GL 50.00 38,493.22 Fisery Solutions, LLC 5321 AP 1.50 38,494.72 GL 4,476.39 42,971.11 GL 79.98 43,051.09 GL 261.25 43,312.34 Texas Excavation Safety System 5374 AP 78 8 Used 1,500.00 Remaining 0 % Used 4,872.12 43,312.34 ** .00 .00 .00 .00 ** 44,119.11 6,302.73 50,421.84 GL Insurance Totals: 6,302.73 50,421.84 ** 65,000.00 Budgeted 14,578.16 Remaining 78 % Used Account: 135-60066-030-000 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 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 Govt Finance Officer mem renew Account: 135-60070-030-000 Account: 135-60075-030-000 Dues & Memberships Totals: 6,000.00 Budgeted Meetings .00 .00 .00 .00 ** 0 9 Used 4,109.25 160.00 4,269.25 GOVERNMENT FINANCE OFF 1,730.75 Remaining 71 9 Used 95.17 160.00 4,269.25 ** .00 95.17 PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60075-030-000 Account: 135-60079-030-000 Account: 135-60079-030-000 Meetings 400.00 Budgeted Public Education Public Education 6,000.00 Budgeted Totals: 304.83 Remaining 24 % Used Totals: 6,000.00 Remaining 0 % Used .00 95.17 ** .00 .00 .00 .00 ** Account: 135-60080-030-000 1246 05/02/2019 May A/P 1410 05/30/2019 May A/P 1410 05/30/2019 May A/P 1 Schools & Training STW conference -2 Attendees Petty cash reimbursement -Nicol Petty cash reimbursement -Nicol 135.00 900.00 1,035.00 STW INC 5.00 1,040.00 TROPHY CLUB MUD PETTY CASH 7.00 1,047.00 TROPHY CLUB MUD PETTY CASH 5259 AP 5344 AP 5344 AP Account: 135-60080-030-000 Schools & Training Totals: 912.00 1,047.00 ** 8,950.00 Budgeted 7,903.00 Remaining 12 % Used Account: 135-60100-030-000 Travel & per diem 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 parking for STW Conference 1481 05/31/2019 May A/P Tolls to lab 1481 05/31/2019 May A/P Tolls to lab Account: 135-60100-030-000 Account: 135-60110-030-000 Account: 135-60110-030-000 Account: 135-60125-030-000 Travel & per diem 4,345.00 Budgeted Physicals/Testing Physicals/Testing 200.00 Budgeted Advertising 8.70 10.00 18.70 PLAT PARKING - LOT 172 PC 7.95 26.65 NTTA 5369 AP 6.90 33.55 NTTA 5369 AP Totals: 4,311.45 Remaining 1 % Used 24.85 33.55 ** .00 .00 Totals: 200.00 Remaining 0 % Used .00 .00 ** .00 .00 Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 6 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60235-030-000 Security 1389 05/28/2019 May A/P monitoring svc-May Account: 135-60235-030-000 Security 1,288.00 Budgeted 168.00 24.00 192.00 Digital Air Control, Inc Totals: 1,096.00 Remaining 15 % Used 24.00 192.00 ** 5318 AP Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Miscellaneous Expenses Totals: 500.00 Budgeted 375.51 Remaining General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 124.49 .00 25 % Used 124.49 .00 124.49 ** .00 0 % Used .00 .00 .00 ** Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Account: 135-65055-030-000 Account: 135-65055-030-000 Account: 135-65085-030-000 Uniforms 2,050.00 Budgeted Hardware Hardware 7,064.00 Budgeted Office Supplies Totals: 2,050.00 Remaining 0 % Used 3,025.81 Totals: 4,038.19 Remaining 43 % Used .00 .00 .00 .00 ** .00 3,025.81 .00 3,025.81 ** glpdatb2 skrolczyk 17:58 06/11/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1389 05/28/2019 May A/P 1389 05/28/2019 May A/P 1481 05/31/2019 May A/P 1481 05/31/2019 May A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 5/2019 JE Detail Beginning Balance Description/Comment Office supplies office supplies Office supplies Office supplies 5,305.92 Program: Transaction Detail 69.98 87.96 40.47 32.26 Transaction Vendor_Name Detail (SUBTOTAL) 5,375.90 5,463.86 5,504.33 5,536.59 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC Page 42 Check Source Number 5332 5332 5370 5370 AP AP AP AP Account: 135-65085-030-000 Office Supplies Totals: 230.67 5,536.59 ** ** 6,000.00 Budgeted 463.41 Remaining 92 % Used 4,000.00 Budgeted 1,100.39 Remaining 72 Account: 135-65090-030-000 Printer Supplies & Maintenance Account: 135-65105-030-000 Printing .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** .00 .00 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65105-030-000 Account: 135-65095-030-000 Maintenance Supplies .00 .00 ** 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 1419 05/27/2019 PCard 4/27/2019 - 5/27/2019 sponge, baking soda, soap coffee coffee water, paper goods, etc. coffee 2,529.01 5.58 34.45 28.00 245.58 56.99 2,534.59 2,569.04 2,597.04 2,842.62 2,899.61 WAL-MART #0266 AMAZON.COM*MN3Z790X2 AMZN MKTP US*MN6M8OFJ0 SAMSCLUB.COM AMZN MKTP US*MN6899CT0 PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 370.60 2,899.61 ** 4,000.00 Budgeted 1,100.39 Remaining 72 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 9 Used Account: 135-69005-030-000 Capital Outlays 40,774.00 .00 40,774.00 Account: 135-69005-030-000 Capital Outlays Totals: .00 40,774.00 ** 280,000.00 Budgeted 239,226.00 Remaining 15 % Used Account: 135-69170-030-000 Copier Lease Installments 1334 05/15/2019 May A/P copier lease -May 1,888.99 165.00 2,053.99 TIAA COMMERCIAL FINANCE 5309 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1389 05/28/2019 May A/P Copier lease 1,888.99 84.89 2,138.88 KYOCERA DOCUMENT SOLUTIONS 5326 AP Account: 135-69170-030-000 Copier Lease Installments Totals: 249.89 2,138.88 ** 4,000.00 Budgeted 1,861.12 Remaining 53 % Used Department 30 Totals: 742,700.05 ** 91,137.74 Monthly Total 1,559,905.00 Budgeted 817,204.95 Remaining 48 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1506 05/31/2019 May A/P Legal 71,215.85 4,890.00 76,105.85 McLean 5 Howard, L.L.P. 5366 AP 1506 05/31/2019 May A/P Lega; 1,050.00 77,155.85 McLean & Howard, L.L.P. 5366 AP Account: 135-55045-039-000 Legal Totals: 5,940.00 77,155.85 ** 137,000.00 Budgeted 59,844.15 Remaining 56 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: .00 26,459 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 Admin Fees Totals: .00 3,653.00 ** 4,800.00 Budgeted 1,147.00 Remaining 76 % Used Department 39 Totals: 114,102.70 ** 5,940.00 Monthly Total 184,314.00 Budgeted 70,211.30 Remaining 62 % Used Fund 135 Totals: (11,091.90) 168,349.84 Monthly Total (343,337.00) Budgeted (332,245.10) Remaining 3 % Used glpdatb2 skrolczyk 17:58 06/11/19 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 5/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 45 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 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 5/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 46 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 MAY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 1,743,638 TOTAL ASSETS 1,743,638 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,693,081 1,693,081 (1,479,465) 1,530,021 50,557 1,743,638 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description 517-49011-000-000 Interest Income 517-49105-000-000 Bond Proceeds Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget Trophy Budget Revenues Period Amended Budget Club MUD No.1 Page 15 Summary with Amendment Ending: 5/2019 Total Encumb. Current Month 116.24- 1,743,522.00- 1,743,638.24- 1,743,638.24- 1,743,638.24- 1,743,638.24 - Program: YTD Total 123.53- 1,743,522.00- 1,743,645.53- 1,743,645.53- 1,743,645.53- 1,743,645.53- % of Budget Remaining Budget 123.53 1,743,522.00 1,743,645.53 1,743,645.53 1,743,645.53 1,743,645.53 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 17:58 06/11/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 14,219.50 213,624.09 213,624.09 - Subtotal: 14,219.50 213,624.09 213,624.09 - Program number: 14,219.50 213,624.09 213,624.09 - Department number: Wastewater 14,219.50 213,624.09 213,624.09 - Expenditures Subtotal 14,219.50 213,624.09 213,624.09 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,729,418.74- 1,530,021.44- 1,530,021.44 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2019 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 47 Check Source Number Department Totals: (1,743,638.24) Monthly Total (1,743,645.53) ** .00 Budgeted 1,743,645.53 Remaining 0 % Used Account: 517-49011-000-000 Interest Income 1484 05/31/2019 Bank Interest- May (7.29) (116.24) (123.53) GL Account: 517-49011-000-000 Interest Income Totals: (116.24) (123.53) ** .00 Budgeted 123.53 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Proceed Trnfr (1,743,522.00) (1,743,522.00) GL Account: 517-49105-000-000 Bond Proceeds Totals: (1,743,522.00) (1,743,522.00) ** .00 Budgeted 1,743,522.00 Remaining 0 % Used Department Totals: (1,743,638.24) Monthly Total (1,743,645.53) ** .00 Budgeted 1,743,645.53 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/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 1389 05/28/2019 May A/P 1481 05/31/2019 May A/P 1490 05/31/2019 May A/P Account: 517-69005-020-000 Capital Outlays 199,404.59 WWTP legal WWTP improvements 4,547.50 1,062.50 8,609.50 203,952.09 Dubois Bryant Campbell LLP 205,014.59 Dubois Bryant Campbell LLP 213,624.09 WEBBER-CADAGUA PARTNERS Capital Outlays Totals: 14,219.50 213,624.09 ** .00 Budgeted (213,624.09) Remaining 0 6 Used Department 20 Totals: 213,624.09 ** 14,219.50 Monthly Total .00 Budgeted (213,624.09) Remaining 0 6 Used Fund 517 Totals: (1,530,021.44) (1,729,418.74) Monthly Total .00 Budgeted 1,530,021.44 Remaining 0 % Used 5320 AP 5360 AP 5378 AP TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MAY 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 MAY 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 1,141,955 INVESTMENTS 3,846,120 ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 5,033,075 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 563,043 TOTAL LIABILITIES 563,043 FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES 4,836,278 TOTAL FUND BALANCE 4,470,032 TOTAL LIABILITIES AND FUND BALANCE 5,033,075 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 17:58 06/11/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 520-49105-000-000 520-49110-000-000 520-49141-000-000 Subtotal: Program number: Department number: Revenues Interest Income Bond Proceeds Bond Premium Interfund Transfer In -Gen Fund Subtotal 5,864.40- 7,435.41- 1,774,202.90 5,229,675.71- 4,224.10- 25,000.00 25,000.00 1,793,338.50 5,216,335.22- 1,793,338.50 5,216,335.22- 1,793,338.50 5,216,335.22- 1,793,338.50 5,216,335.22- 7,435.41 5,229,675.71 4,224.10 25,000.00- 5,216,335.22 5,216,335.22 5,216,335.22 5,216,335.22 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 17:58 06/11/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 2,960.65 151,103.16 151,103.16 - Subtotal: 2,960.65 151,103.16 151,103.16- 520-70005-010-000 Paying Agent Fee 800.00 800.00- 520-70020-010-000 Bond Issuance Costs 543.41 228,154.32 228,154.32 - Subtotal: 543.41 228,954.32 228,954.32 - Program number: 3,504.06 380,057.48 380,057.48 - Department number: Water Department 3,504.06 380,057.48 380,057.48 - Expenditures Subtotal 3,504.06 380,057.48 380,057.48 - Fund number: 520 Revenue Bond 16" Waterline 1,796,842.56 4,836,277.74- 4,836,277.74 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/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 1484 05/31/2019 Bank Interest- May (1,571.01) (5,864.40) (7,435.41) GL Account: 520-49011-000-000 Interest Income Totals: (5,864.40) (7,435.41) ** .00 Budgeted 7,435.41 Remaining 0 % Used Account: 520-49105-000-000 Bond Proceeds 1 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Reimbusr GenF (7,003,878.61) 1497 05/31/2019 Bond Water&WW System Clean Up Bond Accured Interest S&I Fund 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Proceed Trnfr 7,080.00 (6,996,798.61) GL 23,600.90 (6,973,197.71) GL 1,743,522.00 (5,229,675.71) GL Account: 520-49105-000-000 _ Bond Proceeds Totals: 1 1,774,202.90 (5,229,675.71) ** 00 Budgeted 5,229,675.71 Remaining 0 % Used Account: 520-49110-000-000 Bond Premium (4,224.10) .00 (4,224.10) Account: 520-49110-000-000 Bond Premium Totals: + .00 (4,224.10) ** 00 Budgeted 4,224.10 Remaining 0 % Used Account: 520-49141-000-000 Interfund Transfer In -Gen Fund 1497 05/31/2019 Bond Water&WW System Clean Up Series 2019 Bond Reimbusr GenF 25,000.00 25,000.00 GL Account: 520-49141-000-000 Interfund Transfer In -Gen Fund Totals: - 25,000.00 25,000.00 ** .00 Budgeted (25,000.00) Remaining 0 % Used Department Totals: (5,216,335.22) ** 1,793,338.50 Monthly Total .00 Budgeted 5,216,335.22 Remaining 0 % Used glpdatb2 skrolczyk 17:58 06/11/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: 5/2019 Program: JE Detail Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Description/Comment Page 50 Check Source Number Department 10 Totals: Fund 520 Totals: .00 Budgeted 3,504.06 Monthly Total 1,796,842.56 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 380,057.48 ** (380,057.48) Remaining 0 % Used (4,836,277.74) .00 Budgeted 4,836,277.74 Remaining 0 % Used Account: 520-69005-010-000 Capital Outlays 1389 05/28/2019 May A/P 16" water line 148,142.51 2,960.65 151,103.16 Halff Associates, INC 5322 AP Account: 520-69005-010-000 Capital Outlays Totals: 2,960.65 151,103.16 ** .00 Budgeted (151,103.16) Remaining 0 % Used Account: 520-70005-010-000 Paying Agent Fee 800.00 .00 800.00 Account: 520-70005-010-000 Paying Agent Fee Totals: .00 800.00 ** .00 Budgeted (800.00) Remaining 0 % Used Account: 520-70020-010-000 Bond Issuance Costs 1506 05/31/2019 May A/P Bond cost transcripts 227,610.91 543.41 228,154.32 McLean & Howard, L.L.P. 5366 AP Account: 520-70020-010-000 Bond Issuance Costs Totals: 543.41 228,154.32 ** Department 10 Totals: Fund 520 Totals: .00 Budgeted 3,504.06 Monthly Total 1,796,842.56 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 380,057.48 ** (380,057.48) Remaining 0 % Used (4,836,277.74) .00 Budgeted 4,836,277.74 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 737,519 TOTAL ASSETS 737,519 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 130,609 737,519 737,519 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 5/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 1,471.00- 4,600.00- 10,432.00- 10,353.18- 36,800.00- 83,456.00- 16,503.00- 130,609.18- 16,503.00- 130,609.18- 16,503.00- 16,503.00- 16,503.00- 130,609.18- 130,609.18- 130,609.18- 207.064 66.675 66.665 70.455 70.455 70.455 70.455 70.455 5,353.18 18,393.00- 41,731.00- 54,770.82- 54,770.82- 54,770.82- 54,770.82- 54,770.82 - Page 19 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 1484 05/31/2019 Bank Interest- May Account: 528-49011-000-000 Trophy Club MUD No.1 Page 51 Detailed Accounting Trial Balance Program: Period Ending: 5/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (8,882.18) (1,471.00) (10,353.18) GL 5,353.18 Remaining 207 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1443 05/31/2019 TexPool Transfers May TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (32,200.00) (55,193.00) Budgeted (18,393.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1443 05/31/2019 TexPool Transfers May TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (1,471.00) (10,353.18) ** (4,600.00) (36,800.00) GL 67 % Used (73,024.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (41,731.00) Remaining (4,600.00) (36,800.00) ** (10,432.00) (83,456.00) GL 67 % Used (16,503.00) Monthly Total (185,380.00) Budgeted (16,503.00) Monthly Total (185,380.00) Budgeted (10,432.00) (83,456.00) ** (130,609.18) ** (54,770.82) Remaining 70 % Used (130,609.18) (54,770.82) Remaining 70 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET MAY 2019 ASSETS CASH IN BANK INVESTMENTS 928,265 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 17,365 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 945,630 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 17,365 ACCOUNTS AND OTHER PAYABLES 657 TOTAL LIABILITIES 18,022 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 874,319 TOTAL FUND BALANCE 927,608 TOTAL LIABILITIES AND FUND BALANCE 945,630 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & i Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 5/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- 535.39- 3,370.99 149.31- 673,734.20- 2,094.11 1,851.89- 98.044 -116.339 92.595 13,440.80- 3,894.11- 148.11 - Page 20 Subtotal: 690,975.00- 690,975.00- 2,686.29 673,491.98- 97.470 17,483.02- 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- 25,417.75- 6,597.93- 25,417.75- 215,979.00- 329.897 100.000 4,597.93 25,417.75 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 10,913.90- 87,311.20- 72.727 32,741.80 - Subtotal: 338,032.00- 338,032.00- 36,331.65- 335,305.88- 99.194 2,726.12 - Program number: 1,029,007.00- 1,029,007.00- 33,645.36- 1,008,797.86- 98.036 20,209.14 - Department number: Revenues 1,029,007.00- 1,029,007.00- 33,645.36- 1,008,797.86- 98.036 20,209.14 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 33,645.36- 1,008,797.86- 98.036 20,209.14- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 17:58 06/11/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 533-70025-051-000 Bond Interest Expense -Tax 533-70035-051-000 Bond Principal Payment -Tax Subtotal: Program number: Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 2,150.00 266,058.00 755,000.00 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 1,450.00 133,028.75 134,478.75 1,023,208.00 1,023,208.00 134,478.75 1,023,208.00 1,023,208.00 5,799.00- 1,023,208.00 1,023,208.00 5,799.00- 134,478.75 134,478.75 67.442 50.000 700.00 133,029.25 755,000.00 13.143 888,729.25 13.143 888,729.25 13.143 13.143 33,645.36- 874,319.11- ############### 888,729.25 888,729.25 868,520.11 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2019 JE Detail Description/Comment Page 52 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1449 05/01/2019 Property Taxes 1450 05/02/2019 Property Taxes 1451 05/03/2019 Property Taxes 1452 05/06/2019 Property Taxes 1453 05/07/2019 Property Taxes 1454 05/10/2019 Property Taxes 1455 05/13/2019 Property Taxes 1456 05/14/2019 Property Taxes 1457 05/15/2019 Property Taxes 1458 05/16/2019 Property Taxes 1459 05/17/2019 Property Taxes 1460 05/20/2019 Property Taxes 1461 05/21/2019 Property Taxes 1462 05/22/2019 Property Taxes 1463 05/23/2019 Property Taxes 1464 05/24/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1466 05/29/2019 Property Taxes 1467 05/30/2019 Property Taxes 1468 05/31/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (673,198.81) (52.80) (673,251.61) GL (276.23) (673,527.84) GL (7.38) (673,535.22) GL 372.68 (673,162.54) GL (5.98) (673,168.52) GL (64.25) (673,232.77) GL (131.42) (673,364.19) GL (39.83) (673,404.02) GL (486.67) (673,890.69) GL (86.75) (673,977.44) GL (172.67) (674,150.11) GL (191.40) (674,341.51) GL (33.59) (674,375.10) GL (121.58) (674,496.68) GL (113.90) (674,610.58) GL (314.22) (674,924.80) GL 2,081.36 (672,843.44) GL (2,081.36) (674,924.80) GL (225.13) (675,149.93) GL (280.00) (675,429.93) GL (160.50) (675,590.43) GL 1,856.23 (673,734.20) DENTON COUNTY TAX OFFICE 5350 AP Account: 533-40000-000-000 Property Taxes Totals: (535.39) (673,734.20) ** (687,175.00) Budgeted (13,440.80) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1 1449 05/01/2019 Property Taxes 1451 05/03/2019 Property Taxes 1460 05/20/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1467 05/30/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Refund Tax Shortage for May (1,276.88) (.78) (1,277.66) GL 1.34 (1,276.32) GL (.01) (1,276.33) GL 3,377.32 2,100.99 GL (3,377.32) (1,276.33) GL (6.88) (1,283.21) GL 3,377.32 2,094.11 DENTON COUNTY TAX OFFICE 5350 AP Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 3,370.99 2,094.11 ** (1,800.00) Budgeted (3,894.11) Remaining -116 % Used Account: 533-40015-000-000 Property Taxes/P & I 1449 05/01/2019 Property Taxes (1,702.58) (6.25) (1,708.83) GL glpdatb2 skrolczyk 17:58 06/11/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description 1450 05/02/2019 Property Taxes 1451 05/03/2019 Property Taxes 1452 05/06/2019 Property Taxes 1453 05/07/2019 Property Taxes 1455 05/13/2019 Property Taxes 1456 05/14/2019 Property Taxes 1457 05/15/2019 Property Taxes 1459 05/17/2019 Property Taxes 1460 05/20/2019 Property Taxes 1461 05/21/2019 Property Taxes 1464 05/24/2019 Property Taxes 1465 05/28/2019 Property Taxes 1509 05/28/2019 Property Taxes- Shortage A/P 1466 05/29/2019 Property Taxes 1467 05/30/2019 Property Taxes 1468 05/31/2019 Property Taxes 1499 05/31/2019 May A/P Tax Shortage Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2019 JE Detail Description/Comment Refund Tax Shortage for May Page 53 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,702.58) (27.54) (1,736.37) (.97) (1,737.34) (14.70) (1,752.04) (.64) (1,752.68) (17.09) (1,769.77) (.21) (1,769.98) (3.27) (1,773.25) (10.53) (1,783.78) (5.65) (1,789.43) (.85) (1,790.28) (40.85) (1,831.13) (3.08) (1,834.21) 3.08 (1,831.13) (1.08) (1,832.21) (15.46) (1,847.67) (.06) (1,847.73) (4.16) (1,851.89) DENTON COUNTY TAX OFFICE GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL 5350 AP Account: 533-40015-000-000 Property Taxes/P & I Totals: (149.31) (1,851.89) ** (2,000.00) Budgeted (148.11) Remaining 93 % 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 1484 05/31/2019 Bank Interest- 1497 05/31/2019 Bond Water&WW May System Clean Up Bond Accured Interest S&I Fund (1,816.85) (23,600.90) (1,816.85) (25,417.75) GL GL Account: 533-49011-000-000 Interest Income Totals: (25,417.75) (25,417.75) ** .00 Budgeted 25,417.75 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 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 ISS Consolidated Department: Revenues Program: Period Ending: 5/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-49141-000-000 Interfund Trans In -PID Surchg 1443 05/31/2019 TexPool Transfers May TexPool O&M to I&S- PID Debt (76,397.30) (10,913.90) (87,311.20) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (87,311.20) ** (120,053.00) Budgeted (32,741.80) Remaining 73 % Used Department Totals: (1,008,797.86) ** (33,645.36) Monthly Total (1,029,007.00) Budgeted (20,209.14) Remaining 98 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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 Account: 533-70025-051-000 Account: 533-70025-051-000 1,450.00 Paying Agent Fee Totals: 2,150.00 Budgeted 700.00 Remaining 67 % Used Bond Interest Expense -Tax Bond Interest Expense -Tax Totals: 266,058.00 Budgeted 133,029.25 Remaining 133,028.75 .00 1,450.00 .00 1,450.00 ** .00 50 % Used 133,028.75 .00 133,028.75 ** Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Department 51 Totals: Fund 533 Totals: Bond Principal Payment -Tax Totals: 755,000.00 Budgeted 755,000.00 Remaining .00 0 % Used .00 Monthly Total 1,023,208.00 Budgeted (33,645.36) Monthly Total .00 .00 .00 ** 134,478.75 ** 888,729.25 Remaining 13 % Used (874,319.11) (5,799.00) Budgeted 868,520.11 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MAY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 347,771 TOTAL ASSETS 347,771 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 328,209 347,771 347,771 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 17:58 06/11/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 1,000.00- 1,000.00- 600.87- 2,700.50- 270.050 1,700.50 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 54,203.45- 433,627.60- 72.727 162,610.40 - Subtotal: 597,238.00- 597,238.00- 54,804.32- 436,328.10- 73.058 160,909.90 - Program number: 597,238.00- 597,238.00- 54,804.32- 436,328.10- 73.058 160,909.90 - Department number: Revenues 597,238.00- 597,238.00- 54,804.32- 436,328.10- 73.058 160,909.90 - Revenues Subtotal 597,238.00- 597,238.00- 54,804.32- 436,328.10- 73.058 160,909.90- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 17:58 06/11/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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,804.32- 328,209.35- ############### 200.00 107,919.25 380,000.00 488,119.25 488,119.25 488,119.25 488,119.25 327,209.35 glpdatb2 skrolczyk 17:58 06/11/19 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 56 Check Source Number Department Totals: (596,238.00) Budgeted (54,804.32) Monthly Total (162,610.40) Remaining 73 % Used (597,238.00) Budgeted (436,328.10) ** (160,909.90) Remaining 73 % Used Account: 534-49011-000-000 Interest Income 1484 05/31/2019 Bank Interest- May (2,099.63) (600.87) (2,700.50) GL Account: 534-49011-000-000 Interest Income Totals: (600.87) (2,700.50) ** (1,000.00) Budgeted 1,700.50 Remaining 270 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1443 05/31/2019 TexPool Transfers May TexPool O&M to Rev Bd WWTP I&S (379,424.15) (54,203.45) (433,627.60) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (433,627.60) ** Department Totals: (596,238.00) Budgeted (54,804.32) Monthly Total (162,610.40) Remaining 73 % Used (597,238.00) Budgeted (436,328.10) ** (160,909.90) Remaining 73 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 380,000.00 Budgeted 380,000.00 Remaining .00 .00 0 % Used ** Department 51 Totals: 108,118.75 ** .00 Monthly Total 596,238.00 Budgeted 488,119.25 Remaining 18 % Used Fund 534 Totals: (328,209.35) (54,804.32) Monthly Total (1,000.00) Budgeted 327,209.35 Remaining 888888)NNN TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 174,295 TOTAL ASSETS 174,295 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 171,711 174,295 174,295 glbase_tbam skrolczyk 17:58 06/11/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 5/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 305.13 - Program: YTD Total 1,279.05- % of Remaining Budget Budget 213.175 679.05 Page 24 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 201,382.48- 72.727 75,518.52 - Subtotal: 277,501.00- 277,501.00- 25,477.94- 202,661.53- 73.031 74,839.47 - Program number: 277,501.00- 277,501.00- 25,477.94- 202,661.53- 73.031 74,839.47 - Department number: Revenues 277,501.00- 277,501.00- 25,477.94- 202,661.53- 73.031 74,839.47 - Revenues Subtotal 277,501.00- 277,501.00- 25,477.94- 202,661.53- 73.031 74,839.47- glbase_tbam skrolczyk 17:58 06/11/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 5/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,477.94- 171,711.03- ############### 171,111.03 ******* End of Report ********* glpdatb2 skrolczyk 17:58 06/11/19 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 58 Check Source Number Department Totals: (276,901.00) Budgeted (25,477.94) Monthly Total (75,518.52) Remaining 73 % Used (277,501.00) Budgeted (202,661.53) ** (74,839.47) Remaining 73 % Used Account: 535-49011-000-000 Interest Income 1484 05/31/2019 Bank Interest- May (973.92) (305.13) (1,279.05) GL Account: 535-49011-000-000 Interest Income Totals: (305.13) (1,279.05) ** (600.00) Budgeted 679.05 Remaining 213 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1443 05/31/2019 TexPool Transfers May TexPool O&M to 16Swift Rev I&S (176,209.67) (25,172.81) (201,382.48) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (201,382.48) ** Department Totals: (276,901.00) Budgeted (25,477.94) Monthly Total (75,518.52) Remaining 73 % Used (277,501.00) Budgeted (202,661.53) ** (74,839.47) Remaining 73 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 59 17:58 06/11/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 5/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 .00 Monthly Total 276,901.00 Budgeted 30,950.50 ** 245,950.50 Remaining 11 % Used (171,711.03) (25,477.94) Monthly Total (600.00) Budgeted 171,111.03 Remaining NNNNNNNNNN ******* End of Report ********* (8,011,791.06) **** 167,221.05 Monthly Total (536,116.00) Budgeted 7,475,675.06 Remaining 'MUUMUU