Loading...
HomeMy WebLinkAbout2018-03 March Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 827,240 PREPAID EXPENSES 7,619 ADVALOREM PROPERTY TAXES RECEIVABLE 38,879 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 873,739 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 38,879 ACCOUNTS AND OTHER PAYABLES 1,441 TOTAL LIABILITIES 40,320 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 311,167 TOTAL FUND BALANCE 833,420 TOTAL LIABILITIES AND FUND BALANCE 873,739 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 23:00 04/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 14,274.19- 1,046,020.27- 99.202 8,412.73- 122-40011-000-000 Property Taxes/Fire-Delinquent 226.63- 3,100.91- 3,100.91 122-40020-000-000 Property Taxes/Fire P&I 728.64- 3,132.75- 3,132.75 Subtotal: 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Program number: 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 23:00 04/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 7,619.22 42.329 10,380.78 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 304,455.00 50.000 304,455.00 Subtotal: 845,864.00 845,864.00 52,012.37 531,028.22 62.779 314,835.78 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 741,087.31 70.283 313,345.69 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 741,087.31 70.283 313,345.69 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 741,087.31 70.283 313,345.69 Fund number: 122 Trophy Club MUD Fire Dept. 36,782.91 311,166.62- 311,166.62 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1097 03/01/2018 Property Taxes (1,031,746.08) (713.49) (1,032,459.57) GL 1098 03/02/2018 Property Taxes (2,023.96) (1,034,483.53) GL 1099 03/05/2018 Property Taxes (1,199.16) (1,035,682.69) GL 1100 03/06/2018 Property Taxes (486.95) (1,036,169.64) GL 1101 03/07/2018 Property Taxes (1,320.67) (1,037,490.31) GL 1103 03/09/2018 Property Taxes (301.75) (1,037,792.06) GL 1104 03/12/2018 Property Taxes (55.21) (1,037,847.27) GL 1105 03/13/2018 Property Taxes (83.86) (1,037,931.13) GL 1106 03/14/2018 Property Taxes (295.55) (1,038,226.68) GL 1107 03/16/2018 Property Taxes (397.99) (1,038,624.67) GL 1108 03/19/2018 Property Taxes (695.56) (1,039,320.23) GL 1109 03/20/2018 Property Taxes (22.95) (1,039,343.18) GL 1110 03/21/2018 Property Taxes (620.26) (1,039,963.44) GL 1111 03/22/2018 Property Taxes (5,612.82) (1,045,576.26) GL 1112 03/23/2018 Property Taxes 1,441.26 (1,044,135.00) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (1,441.26) (1,045,576.26) GL 1113 03/26/2018 Property Taxes (665.96) (1,046,242.22) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 1,441.26 (1,044,800.96) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (37.23) (1,044,838.19) GL 1115 03/28/2018 Property Taxes (923.68) (1,045,761.87) GL 1116 03/29/2018 Property Taxes (258.40) (1,046,020.27) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (14,274.19) (1,046,020.27) ** (1,054,433.00) Budgeted (8,412.73) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1097 03/01/2018 Property Taxes (2,874.28) (5.69) (2,879.97) GL 1098 03/02/2018 Property Taxes (14.93) (2,894.90) GL 1099 03/05/2018 Property Taxes (.05) (2,894.95) GL 1100 03/06/2018 Property Taxes (6.83) (2,901.78) GL 1104 03/12/2018 Property Taxes (4.34) (2,906.12) GL 1107 03/16/2018 Property Taxes (194.62) (3,100.74) GL 1114 03/27/2018 Property Taxes (.17) (3,100.91) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (226.63) (3,100.91) ** .00 Budgeted 3,100.91 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1097 03/01/2018 Property Taxes (2,404.11) (52.73) (2,456.84) GL 1098 03/02/2018 Property Taxes (132.75) (2,589.59) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1099 03/05/2018 Property Taxes (2,404.11) (103.16) (2,692.75) GL 1100 03/06/2018 Property Taxes (44.44) (2,737.19) GL 1101 03/07/2018 Property Taxes (96.20) (2,833.39) GL 1102 03/08/2018 Property Taxes (27.80) (2,861.19) GL 1103 03/09/2018 Property Taxes (32.03) (2,893.22) GL 1104 03/12/2018 Property Taxes (16.62) (2,909.84) GL 1107 03/16/2018 Property Taxes (82.10) (2,991.94) GL 1108 03/19/2018 Property Taxes (18.99) (3,010.93) GL 1110 03/21/2018 Property Taxes (12.96) (3,023.89) GL 1112 03/23/2018 Property Taxes (.57) (3,024.46) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .57 (3,023.89) GL 1113 03/26/2018 Property Taxes (20.04) (3,043.93) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.57) (3,044.50) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.19) (3,044.69) GL 1115 03/28/2018 Property Taxes (74.53) (3,119.22) GL 1116 03/29/2018 Property Taxes (13.53) (3,132.75) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (728.64) (3,132.75) ** .00 Budgeted 3,132.75 Remaining 0 % Used Department Totals: ----------------------------------- (1,052,253.93) ** (15,229.46) Monthly Total (1,054,433.00) Budgeted (2,179.07) Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 218,954.00 .00 218,954.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 237 03/01/2018 Insurance/Wrk Comp Exp Mar 6,349.35 1,269.87 7,619.22 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 7,619.22 ** 18,000.00 Budgeted 10,380.78 Remaining 42 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 923 03/07/2018 March A/P March fire admin 253,712.50 50,742.50 304,455.00 TOWN OF TROPHY CLUB 3998 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 304,455.00 ** 608,910.00 Budgeted 304,455.00 Remaining 50 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 741,087.31 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 313,345.69 Remaining 70 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2018 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: ----------------------------------- (311,166.62) 36,782.91 Monthly Total .00 Budgeted 311,166.62 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,794,534 - 1,794,534 CASH IN BANK-SAVINGS-CASH RESERVE 781,976 - 781,976 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,777 - 714,777 INVESTMENTS-TEXPOOL 1,049,126 596,426 1,645,552 PREPAID EXPENSES 54,331 - 54,331 ADVALOREM PROPERTY TAXES RECEIVABLE 4,393 - 4,393 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,035,527 - 1,035,527 TOTAL ASSETS 5,470,581 596,426 6,067,007 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,393 - 4,393 ACCOUNTS AND OTHER PAYABLES 822,263 - 822,263 CUSTOMER DEPOSITS 314,660 - 314,660 - TOTAL LIABILITIES 1,141,316 - 1,141,316 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 178,897 - 178,897 - TOTAL FUND BALANCE 4,329,265 596,426 4,925,691 TOTAL LIABILITIES AND FUND BALANCE 5,470,581 596,426 6,067,007 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 1,637.25- 119,980.25- 99.198 969.75- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 14.12- 203.05- 101.525 3.05 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 80.69- 335.16- 167.580 135.16 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 1,732.06- 120,518.46- 40.282 178,670.54- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 331,079.88- 2,225,115.47- 34.423 4,238,903.53- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 237,532.41- 1,422,742.27- 47.774 1,555,324.73- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 8,246.29- 59,504.11- 55.989 46,774.89- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,225.00- 7,200.00- 33.724 14,150.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 1,500.00- 100.000 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 3,700.00- 82.222 800.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 496.80- 9,972.80- 16.621 50,027.20- Subtotal: 9,635,715.00- 9,635,715.00- 578,980.38- 3,729,734.65- 38.707 5,905,980.35- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 4,979.61- 20,866.64- 173.889 8,866.64 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 5,804.58- 53.126 5,121.42- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 9,434.76- 51.899 8,744.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 6,594.20- 12,447.65- 248.953 7,447.65 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 13,821.95- 52,053.61- 16.518 263,071.39- Program number: 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- Department number: Revenues 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 17,800.29 99,790.93 36.383 174,488.07 135-50010-010-000 Overtime 20,000.00 20,000.00 1,407.22 4,625.38 23.127 15,374.62 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 175.00 1,075.00 32.576 2,225.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,792.89 11,474.08 41.210 16,368.92 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 15,107.03 28.943 37,088.97 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,307.39 25.229 3,874.61 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 244.31 24.578 749.69 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 249.57 1,275.57 42.776 1,706.43 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,184.03 6,691.80 35.858 11,970.20 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 276.93 1,565.02 35.854 2,799.98 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 688.99 730.07 67.599 349.93 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 5,399.52 45.550 6,454.48 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 27,673.21 152,841.14 35.823 273,820.86 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 14,880.10 47,759.58 47.760 52,240.42 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 1,035.68 3,853.07 96.327 146.93 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 675.00 2,768.44 50.335 2,731.56 Subtotal: 391,000.00 391,000.00 16,590.78 54,381.09 13.908 336,618.91 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 740.82 2,122.44 45.158 2,577.56 135-60020-010-000 Electricity 175,356.00 175,356.00 7,577.14 63,857.28 36.416 111,498.72 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 361.00 1,335.78 47.963 1,449.22 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 12,808.05 23.213 42,367.95 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 108,177.96 721,667.37 25.562 2,101,502.63 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 322.70 10.757 2,677.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 3,000.00 20.339 11,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 151,681.86 54.545 126,402.14 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 24,498.00 50.000 24,498.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 146,970.23 986,408.98 27.295 2,627,443.02 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 872.28 4,805.80 32.039 10,194.20 135-65010-010-000 Uniforms 4,488.00 4,488.00 990.57 22.072 3,497.43 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,882.24 8,523.63 42.618 11,476.37 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 192.00 192.00 19.200 808.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 12,400.00 24.800 37,600.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 58.214 35,100.00 Subtotal: 175,688.00 175,688.00 2,946.52 75,812.00 43.151 99,876.00 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 84,262.58 307,870.80 38.008 502,141.20 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 84,262.58 490,735.18 46.816 557,495.82 Program number: 5,655,433.00 5,655,433.00 278,443.32 1,760,178.39 31.124 3,895,254.61 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2018 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 160.00 903.89 45.195 1,096.11 Subtotal: 2,000.00 2,000.00 160.00 903.89 45.195 1,096.11 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 160.00 903.89 45.195 1,096.11 Department number: Water 5,657,433.00 5,657,433.00 278,603.32 1,761,082.28 31.129 3,896,350.72 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 31,482.93 184,895.51 45.001 225,970.49 135-50010-020-000 Overtime 30,000.00 30,000.00 3,281.80 15,668.88 52.230 14,331.12 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 4,236.00 50.429 4,164.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,280.48 21,084.11 49.911 21,158.89 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 6,108.45 32,455.95 52.201 29,719.05 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 387.45 2,335.61 44.311 2,935.39 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 65.49 449.46 40.346 664.54 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 379.07 2,339.26 54.643 1,941.74 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,021.49 12,299.70 43.440 16,014.30 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 472.76 2,876.53 43.439 3,745.47 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,073.12 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 8,088.00 44.958 9,902.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 50,601.04 295,278.01 47.124 331,322.99 135-55070-020-000 Independent Labor 20,550.00 20,550.00 1,075.50 2,145.00 10.438 18,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 7,567.70 26,745.39 31.063 59,354.61 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 885.73 4,292.14 53.652 3,707.86 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 289.69 57.938 210.31 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 7,657.40 43,360.77 72.268 16,639.23 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,864.00 18,326.82 61.089 11,673.18 Subtotal: 219,150.00 219,150.00 19,050.33 95,188.59 43.435 123,961.41 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 763.67 2,865.72 60.973 1,834.28 135-60020-020-000 Electricity 266,709.00 266,709.00 13,226.36 86,385.16 32.389 180,323.84 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 222.00 222.00 3.911 5,455.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 73.06 4.469 1,561.94 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 2,360.00 20.345 9,240.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 66,568.86 54.545 55,474.14 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 326,584.32 54.545 272,153.68 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 61,668.00 50.000 61,668.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 90,605.56 577,008.02 40.100 861,929.98 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 1,004.37 4,735.44 37.884 7,764.56 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,774.59 39.798 2,684.41 135-65030-020-000 Chemicals 27,500.00 27,500.00 1,359.32 5,251.35 19.096 22,248.65 135-65035-020-000 Small Tools 1,000.00 1,000.00 20.78 1,138.99 113.899 138.99- 135-65040-020-000 Safety Equipment 750.00 750.00 326.57 586.57 78.209 163.43 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,168.08 7,839.46 55.996 6,160.54 Subtotal: 60,209.00 60,209.00 4,879.12 21,326.40 35.421 38,882.60 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 294,401.35 309,455.78 56.539 237,871.22 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 294,401.35 339,455.78 53.353 296,786.22 Program number: 2,981,140.00 2,981,140.00 459,537.40 1,328,256.80 44.555 1,652,883.20 Department number: Wastewater 2,981,140.00 2,981,140.00 459,537.40 1,328,256.80 44.555 1,652,883.20 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.42 14.52 48.400 15.48 Subtotal: 30.00 30.00 2.42 14.52 48.400 15.48 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 960.00 19.200 4,040.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 3,766.73 29.087 9,183.27 Program number: 12,980.00 12,980.00 2.42 3,781.25 29.131 9,198.75 Department number: Board of Directors 12,980.00 12,980.00 2.42 3,781.25 29.131 9,198.75 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 25,193.62 180,628.41 41.729 252,234.59 135-50010-030-000 Overtime 2,000.00 2,000.00 46.02 456.67 22.834 1,543.33 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,334.67 19,385.45 47.803 21,167.55 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 23,193.21 36.533 40,291.79 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 1,752.92 31.860 3,749.08 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 341.41 29.106 831.59 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 216.39 1,920.29 37.958 3,138.71 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,486.43 10,988.19 40.426 16,192.81 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 347.65 2,569.81 40.425 3,787.19 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 847.20 901.90 71.579 358.10 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 741.00 48.463 788.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 27.47 2,348.26 47.344 2,611.74 Subtotal: 595,970.00 595,970.00 35,070.22 248,899.97 41.764 347,070.03 135-55030-030-000 Software & Support 78,391.00 78,391.00 1,357.96 44,486.55 56.750 33,904.45 135-55070-030-000 Independent Labor 154,000.00 154,000.00 11,103.92 74,174.76 48.165 79,825.24 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 194.23 2,475.73 17.684 11,524.27 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 3,962.39 39.624 6,037.61 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 2,765.00 59,240.00 93.549 4,085.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 977.54 3,951.79 43.909 5,048.21 Subtotal: 338,916.00 338,916.00 17,267.71 188,291.22 55.557 150,624.78 135-60005-030-000 Telephone 27,300.00 27,300.00 28.71 7,417.68 27.171 19,882.32 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 324.81 1,649.43 41.236 2,350.57 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,409.08 3,106.68 19.105 13,154.32 135-60025-030-000 Water 2,500.00 2,500.00 53.36 339.12 13.565 2,160.88 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 3,013.63 12,665.27 42.218 17,334.73 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,248.58 29,796.12 53.629 25,763.88 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,150.36 39,877.16 71.209 16,122.84 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 20.00 3,828.42 63.807 2,171.58 135-60075-030-000 Meetings 400.00 400.00 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 2,693.00 35.434 4,907.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 17.66 599.83 12.279 4,285.17 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 4,500.00 4,500.00 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 72.00 2.667 2,628.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 15,290.19 103,191.22 41.358 146,314.78 135-65010-030-000 Uniforms 700.00 700.00 137.74 137.74 19.677 562.26 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 263.52 2,876.21 41.089 4,123.79 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 145.61 2,048.66 102.433 48.66- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 760.53 2,822.39 70.560 1,177.61 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 1,307.40 8,626.95 34.343 16,493.05 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 247.12 1,476.14 32.090 3,123.86 Subtotal: 17,600.00 17,600.00 247.12 9,317.14 52.938 8,282.86 Program number: 1,227,112.00 1,227,112.00 69,182.64 558,326.50 45.499 668,785.50 Department number: Administration 1,227,112.00 1,227,112.00 69,182.64 558,326.50 45.499 668,785.50 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2018 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 7,470.00 36,813.55 26.871 100,186.45 135-55055-039-000 Auditing 24,500.00 24,500.00 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 6,672.05 58.292 4,773.95 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 9,481.87 71,962.70 40.715 104,783.30 Program number: 176,746.00 176,746.00 9,481.87 71,962.70 40.715 104,783.30 Department number: Non Departmental 176,746.00 176,746.00 9,481.87 71,962.70 40.715 104,783.30 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 816,807.65 3,723,409.53 37.029 6,332,001.47 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 222,273.26 178,897.19- 91.922 15,720.81- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 23:00 04/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 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 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1097 03/01/2018 Property Taxes (118,343.00) (81.84) (118,424.84) GL 1098 03/02/2018 Property Taxes (232.14) (118,656.98) GL 1099 03/05/2018 Property Taxes (137.54) (118,794.52) GL 1100 03/06/2018 Property Taxes (55.86) (118,850.38) GL 1101 03/07/2018 Property Taxes (151.48) (119,001.86) GL 1103 03/09/2018 Property Taxes (34.61) (119,036.47) GL 1104 03/12/2018 Property Taxes (6.33) (119,042.80) GL 1105 03/13/2018 Property Taxes (9.62) (119,052.42) GL 1106 03/14/2018 Property Taxes (33.90) (119,086.32) GL 1107 03/16/2018 Property Taxes (45.65) (119,131.97) GL 1108 03/19/2018 Property Taxes (79.78) (119,211.75) GL 1109 03/20/2018 Property Taxes (2.63) (119,214.38) GL 1110 03/21/2018 Property Taxes (71.14) (119,285.52) GL 1111 03/22/2018 Property Taxes (643.80) (119,929.32) GL 1112 03/23/2018 Property Taxes 165.31 (119,764.01) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (165.31) (119,929.32) GL 1113 03/26/2018 Property Taxes (76.38) (120,005.70) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 165.31 (119,840.39) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (4.27) (119,844.66) GL 1115 03/28/2018 Property Taxes (105.95) (119,950.61) GL 1116 03/29/2018 Property Taxes (29.64) (119,980.25) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,637.25) (119,980.25) ** (120,950.00) Budgeted (969.75) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1097 03/01/2018 Property Taxes (188.93) (1.09) (190.02) GL 1098 03/02/2018 Property Taxes (.88) (190.90) GL 1100 03/06/2018 Property Taxes (.40) (191.30) GL 1104 03/12/2018 Property Taxes (.28) (191.58) GL 1107 03/16/2018 Property Taxes (11.45) (203.03) GL 1114 03/27/2018 Property Taxes (.02) (203.05) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (14.12) (203.05) ** (200.00) Budgeted 3.05 Remaining 102 % Used Account: 135-40015-000-000 Property Taxes/P & I 1097 03/01/2018 Property Taxes (254.47) (6.27) (260.74) GL 1098 03/02/2018 Property Taxes (15.09) (275.83) GL 1099 03/05/2018 Property Taxes (11.84) (287.67) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1100 03/06/2018 Property Taxes (254.47) (5.07) (292.74) GL 1101 03/07/2018 Property Taxes (11.04) (303.78) GL 1102 03/08/2018 Property Taxes (3.19) (306.97) GL 1103 03/09/2018 Property Taxes (3.67) (310.64) GL 1104 03/12/2018 Property Taxes (1.78) (312.42) GL 1107 03/16/2018 Property Taxes (6.59) (319.01) GL 1108 03/19/2018 Property Taxes (2.18) (321.19) GL 1110 03/21/2018 Property Taxes (1.49) (322.68) GL 1112 03/23/2018 Property Taxes (.06) (322.74) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .06 (322.68) GL 1113 03/26/2018 Property Taxes (2.30) (324.98) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.06) (325.04) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.02) (325.06) GL 1115 03/28/2018 Property Taxes (8.55) (333.61) GL 1116 03/29/2018 Property Taxes (1.55) (335.16) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (80.69) (335.16) ** (200.00) Budgeted 135.16 Remaining 168 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1082 03/01/2018 acct adj UB20180301-20180301 User: (1,894,035.59) 17.15 (1,894,018.44) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 12.75 (1,894,005.69) UB 1090 03/29/2018 UB 03/29/2018 Adjustments UB20180329-20180329 User: 17.15 (1,893,988.54) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (331,126.93) (2,225,115.47) UB _______________ Account: 135-47000-000-000 Water Totals: (331,079.88) (2,225,115.47) ** (6,464,019.00) Budgeted (4,238,903.53) Remaining 34 % Used Account: 135-47005-000-000 Sewer 1082 03/01/2018 acct adj UB20180301-20180301 User: (1,185,209.86) 22.78 (1,185,187.08) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 20.00 (1,185,167.08) UB 1090 03/29/2018 UB 03/29/2018 Adjustments UB20180329-20180329 User: 27.02 (1,185,140.06) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (237,602.21) (1,422,742.27) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47005-000-000 Sewer Totals: (237,532.41) (1,422,742.27) ** (2,978,067.00) Budgeted (1,555,324.73) Remaining 48 % Used Account: 135-47025-000-000 Penalties 990 03/14/2018 UB 03/14/2018 Penalty removal UB20180314-20180314 User: (51,257.82) 72.98 (51,184.84) UB 1030 03/21/2018 UB 03/21/2018 Assess Penalties UB20180321-20180321 User: (11,159.83) (62,344.67) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 95.62 (62,249.05) UB 1087 03/22/2018 adj-40 rockwood UB20180322-20180322 User: 13.65 (62,235.40) UB 1046 03/26/2018 UB 03/26/2018 Penalty removal UB20180326-20180326 User: 136.04 (62,099.36) UB 1055 03/28/2018 UB 03/28/2018 Penalty removal UB20180328-20180328 User: 2,595.25 (59,504.11) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,246.29) (59,504.11) ** (106,279.00) Budgeted (46,774.89) Remaining 56 % Used Account: 135-47030-000-000 Service Charges 937 03/08/2018 UB 03/08/2018 Disconnect Fees UB20180308-20180308 User: (5,975.00) (1,350.00) (7,325.00) UB 1085 03/12/2018 Disconnect fee-58 cimarron UB20180312-20180312 User: 50.00 (7,275.00) UB 1029 03/19/2018 UB 03/19/2018 NSF check UB20180319-20180319 User: (25.00) (7,300.00) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 50.00 (7,250.00) UB 1087 03/22/2018 adj-40 rockwood UB20180322-20180322 User: 50.00 (7,200.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,225.00) (7,200.00) ** (21,350.00) Budgeted (14,150.00) Remaining 34 % Used Account: 135-47035-000-000 Plumbing Inspections 1075 03/27/2018 Permits 649 Sheldon Drive (1,400.00) (50.00) (1,450.00) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (50.00) (1,500.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,500.00) ** (1,500.00) Budgeted .00 Remaining 100 % Used Account: 135-47045-000-000 Sewer Inspections 1075 03/27/2018 Permits 649 Sheldon Drive (3,400.00) (150.00) (3,550.00) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (150.00) (3,700.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (3,700.00) ** (4,500.00) Budgeted (800.00) Remaining 82 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (9,476.00) (496.80) (9,972.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (496.80) (9,972.80) ** (60,000.00) Budgeted (50,027.20) Remaining 17 % Used Account: 135-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (15,887.03) (146.84) (16,033.87) GL 1067 03/31/2018 Bank Interest- March (446.75) (16,480.62) GL 1067 03/31/2018 Bank Interest- March (3,903.11) (20,383.73) GL 1067 03/31/2018 Bank Interest- March (482.91) (20,866.64) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (4,979.61) (20,866.64) ** (12,000.00) Budgeted 8,866.64 Remaining 174 % Used Account: 135-49016-000-000 Cell Tower Revenue 967 03/07/2018 Cell Tower Rev AT&T Mar (4,825.77) (978.81) (5,804.58) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (5,804.58) ** (10,926.00) Budgeted (5,121.42) Remaining 53 % Used Account: 135-49018-000-000 Building Rent Income 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1075 03/27/2018 Permits 649 Sheldon Drive (8,748.76) (343.00) (9,091.76) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (343.00) (9,434.76) Ashton Wood Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (9,434.76) ** (18,179.00) Budgeted (8,744.24) Remaining 52 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49900-000-000 Miscellaneous Income 1078 03/07/2018 Recycling of Scrap Metal Sell/recycle of scrap metal (5,853.45) (4,374.30) (10,227.75) GL 1079 03/16/2018 Recycling of Scrap Metal (1,883.79) (12,111.54) GL 1088 03/28/2018 credit adj UB UB20180328-20180328 User: (.22) (12,111.76) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (335.89) (12,447.65) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (6,594.20) (12,447.65) ** (5,000.00) Budgeted 7,447.65 Remaining 249 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (3,902,306.72) ** (594,534.39) Monthly Total (10,250,029.00) Budgeted (6,347,722.28) Remaining 38 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 81,990.64 8,883.92 90,874.56 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 8,916.37 99,790.93 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,800.29 99,790.93 ** 274,279.00 Budgeted 174,488.07 Remaining 36 % Used Account: 135-50010-010-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 3,218.16 316.92 3,535.08 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 1,090.30 4,625.38 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,407.22 4,625.38 ** 20,000.00 Budgeted 15,374.62 Remaining 23 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 1031 03/23/2018 MUD PR 03.23.18 Certification 900.00 175.00 1,075.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 1,075.00 ** 3,300.00 Budgeted 2,225.00 Remaining 33 % Used Account: 135-50020-010-000 Retirement 929 03/09/2018 MUD PR 03.09.18 Retirement 9,681.19 851.09 10,532.28 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 941.80 11,474.08 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,792.89 11,474.08 ** 27,843.00 Budgeted 16,368.92 Remaining 41 % Used Account: 135-50026-010-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 12,158.23 1,474.40 13,632.63 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 1,474.40 15,107.03 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 15,107.03 ** 52,196.00 Budgeted 37,088.97 Remaining 29 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,093.74 106.85 1,200.59 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 106.80 1,307.39 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,307.39 ** 5,182.00 Budgeted 3,874.61 Remaining 25 % Used Account: 135-50028-010-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 208.39 17.98 226.37 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 17.94 244.31 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 244.31 ** 994.00 Budgeted 749.69 Remaining 25 % Used Account: 135-50029-010-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,026.00 100.59 1,126.59 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 130.48 1,257.07 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 18.50 1,275.57 BenefitMall 4040 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 249.57 1,275.57 ** 2,982.00 Budgeted 1,706.43 Remaining 43 % Used Account: 135-50030-010-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 5,507.77 562.73 6,070.50 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 621.30 6,691.80 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,184.03 6,691.80 ** 18,662.00 Budgeted 11,970.20 Remaining 36 % Used Account: 135-50035-010-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 1,288.09 131.62 1,419.71 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 145.31 1,565.02 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 276.93 1,565.02 ** 4,365.00 Budgeted 2,799.98 Remaining 36 % Used Account: 135-50040-010-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 41.08 4.13 45.21 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 41.08 684.86 730.07 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 688.99 730.07 ** 1,080.00 Budgeted 349.93 Remaining 68 % Used Account: 135-50045-010-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 4,499.60 899.92 5,399.52 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 5,399.52 ** 11,854.00 Budgeted 6,454.48 Remaining 46 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 226.05 .00 226.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 226.05 ** 200.00 Budgeted (26.05) Remaining 113 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1019 03/20/2018 March A/P Hydrant for Hill Ct 32,879.48 2,304.44 35,183.92 Core & Main LP 4008 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CONOCO - STEAGALL OIL 59.75 35,243.67 CONOCO - STEAGALL OIL PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 THE HOME DEPOT #6581 31.37 35,275.04 THE HOME DEPOT #6581 PC 1128 03/31/2018 March A/P Gauge calibration 50.00 35,325.04 MACARTHUR GAUGE INC 4065 AP 1158 03/31/2018 March A/P 10" force main repair billed t 7,459.54 42,784.58 REY-MAR CONSTRUCTION 4094 AP 1158 03/31/2018 March A/P Hill Lane Water repair 4,975.00 47,759.58 REY-MAR CONSTRUCTION 4094 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 14,880.10 47,759.58 ** 100,000.00 Budgeted 52,240.42 Remaining 48 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DISCOUNT TIRE TXD 75 2,817.39 888.50 3,705.89 DISCOUNT TIRE TXD 75 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 INLAND TRUCK PARTS # 40.00 3,745.89 INLAND TRUCK PARTS # PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 KWIK KAR LUBE & TUNE O 25.50 3,771.39 KWIK KAR LUBE & TUNE O PC 1128 03/31/2018 March A/P Oil change-#109 81.68 3,853.07 Gierisch Brothers Motor Co LTD 4051 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,035.68 3,853.07 ** 4,000.00 Budgeted 146.93 Remaining 96 % 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-55135-010-000 Lab Analysis 1019 03/20/2018 March A/P Water samples 2,093.44 275.00 2,368.44 TARRANT CTY PUBLIC HEALTH LAB 4027 AP 1179 03/31/2018 March A/P Water samples 400.00 2,768.44 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 675.00 2,768.44 ** 5,500.00 Budgeted 2,731.56 Remaining 50 % Used Account: 135-60010-010-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 1,381.62 370.64 1,752.26 VERIZON WIRELESS 4031 AP 1179 03/31/2018 March A/P Cell phones 370.18 2,122.44 VERIZON WIRELESS AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 740.82 2,122.44 ** 4,700.00 Budgeted 2,577.56 Remaining 45 % Used Account: 135-60020-010-000 Electricity 1019 03/20/2018 March A/P Electricity 2/8-3/9 56,280.14 7,577.14 63,857.28 HUDSON ENERGY SERVICES, LLC 4016 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-010-000 Electricity Totals: 7,577.14 63,857.28 ** 175,356.00 Budgeted 111,498.72 Remaining 36 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SUNCOAST LEARNING SYST 974.78 250.00 1,224.78 SUNCOAST LEARNING SYST PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ EPAYMENT 111.00 1,335.78 TCEQ EPAYMENT PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 361.00 1,335.78 ** 2,785.00 Budgeted 1,449.22 Remaining 48 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 12,808.05 .00 12,808.05 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 12,808.05 ** 55,176.00 Budgeted 42,367.95 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 1040 03/23/2018 March A/P water 613,489.41 108,177.96 721,667.37 CITY OF FORT WORTH 4042 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 108,177.96 721,667.37 ** 2,823,170.00 Budgeted 2,101,502.63 Remaining 26 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 322.70 .00 322.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 322.70 ** 3,000.00 Budgeted 2,677.30 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1125 03/31/2018 March A/P March mowing 2,250.00 750.00 3,000.00 WATTS ELLISON LLC 4083 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 3,000.00 ** 14,750.00 Budgeted 11,750.00 Remaining 20 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1066 03/31/2018 Texpool Transfers March 126,401.55 25,280.31 151,681.86 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 151,681.86 ** 278,084.00 Budgeted 126,402.14 Remaining 55 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1066 03/31/2018 Texpool Transfers March 20,415.00 4,083.00 24,498.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 24,498.00 ** 48,996.00 Budgeted 24,498.00 Remaining 50 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 1058 03/28/2018 March A/P Fuel 3,933.52 872.28 4,805.80 US Bank Voyager Fleet Systems 4080 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 872.28 4,805.80 ** 15,000.00 Budgeted 10,194.20 Remaining 32 % Used Account: 135-65010-010-000 Uniforms 990.57 .00 990.57 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 990.57 ** 4,488.00 Budgeted 3,497.43 Remaining 22 % Used Account: 135-65030-010-000 Chemicals 1019 03/20/2018 March A/P sampling supplies 6,641.39 334.27 6,975.66 HACH COMPANY 4013 AP 1058 03/28/2018 March A/P Testing supplies 455.74 7,431.40 HACH COMPANY 4052 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1058 03/28/2018 March A/P Chlorine 6,641.39 442.48 7,873.88 DPC INDUSTRIES, INC 4046 AP 1125 03/31/2018 March A/P Testing supplies 649.75 8,523.63 HACH COMPANY 4052 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,882.24 8,523.63 ** 20,000.00 Budgeted 11,476.37 Remaining 43 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 192.00 192.00 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 192.00 192.00 ** 1,000.00 Budgeted 808.00 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 12,400.00 .00 12,400.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 12,400.00 ** 50,000.00 Budgeted 37,600.00 Remaining 25 % Used Account: 135-65053-010-000 Meter Change Out Program 48,900.00 .00 48,900.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,900.00 ** 84,000.00 Budgeted 35,100.00 Remaining 58 % Used Account: 135-69005-010-000 Capital Outlays 923 03/07/2018 March A/P Valve replacements 223,608.22 49,997.62 273,605.84 REY-MAR CONSTRUCTION 3994 AP 1019 03/20/2018 March A/P 16" water line 9,220.45 282,826.29 Halff Associates, INC 4012 AP 1019 03/20/2018 March A/P 16" water line 11,313.77 294,140.06 Halff Associates, INC 4012 AP 1125 03/31/2018 March A/P Water line replacement 1,650.00 295,790.06 TEAGUE, NALL & PERKINS,INC 4076 AP 1125 03/31/2018 March A/P Water line replacement 3,500.00 299,290.06 TEAGUE, NALL & PERKINS,INC 4076 AP 1179 03/31/2018 March A/P 16" water line 1,152.55 300,442.61 Halff Associates, INC AP 1179 03/31/2018 March A/P 16" water line 7,428.19 307,870.80 Halff Associates, INC AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69005-010-000 Capital Outlays Totals: 84,262.58 307,870.80 ** 810,012.00 Budgeted 502,141.20 Remaining 38 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % 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 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 1019 03/20/2018 March A/P Water samples-PID 743.89 80.00 823.89 TARRANT CTY PUBLIC HEALTH LAB 4027 AP 1179 03/31/2018 March A/P Water samples-PID 80.00 903.89 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 903.89 ** 2,000.00 Budgeted 1,096.11 Remaining 45 % Used Department 10 Totals: ----------------------------------- 1,761,082.28 ** 278,603.32 Monthly Total 5,657,433.00 Budgeted 3,896,350.72 Remaining 31 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 153,412.58 15,307.25 168,719.83 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 16,175.68 184,895.51 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 31,482.93 184,895.51 ** 410,866.00 Budgeted 225,970.49 Remaining 45 % Used Account: 135-50010-020-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 12,387.08 2,434.60 14,821.68 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 847.20 15,668.88 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,281.80 15,668.88 ** 30,000.00 Budgeted 14,331.12 Remaining 52 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1031 03/23/2018 MUD PR 03.23.18 Certification 3,536.00 700.00 4,236.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 4,236.00 ** 8,400.00 Budgeted 4,164.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 929 03/09/2018 MUD PR 03.09.18 Retirement 17,803.63 1,641.12 19,444.75 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 1,639.36 21,084.11 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,280.48 21,084.11 ** 42,243.00 Budgeted 21,158.89 Remaining 50 % Used Account: 135-50026-020-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 26,347.50 3,054.24 29,401.74 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 3,054.21 32,455.95 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,108.45 32,455.95 ** 62,175.00 Budgeted 29,719.05 Remaining 52 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,948.16 193.74 2,141.90 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 193.71 2,335.61 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 387.45 2,335.61 ** 5,271.00 Budgeted 2,935.39 Remaining 44 % Used Account: 135-50028-020-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 383.97 32.76 416.73 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 32.73 449.46 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 65.49 449.46 ** 1,114.00 Budgeted 664.54 Remaining 40 % Used Account: 135-50029-020-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,960.19 149.71 2,109.90 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 192.36 2,302.26 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 37.00 2,339.26 BenefitMall 4040 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 379.07 2,339.26 ** 4,281.00 Budgeted 1,941.74 Remaining 55 % Used Account: 135-50030-020-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 10,278.21 1,023.86 11,302.07 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 997.63 12,299.70 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,021.49 12,299.70 ** 28,314.00 Budgeted 16,014.30 Remaining 43 % Used Account: 135-50035-020-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 2,403.77 239.46 2,643.23 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 233.30 2,876.53 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 472.76 2,876.53 ** 6,622.00 Budgeted 3,745.47 Remaining 43 % Used Account: 135-50040-020-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 60.88 1.92 62.80 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 60.88 1,071.20 1,134.00 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 1,073.12 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 6,740.00 1,348.00 8,088.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 8,088.00 ** 17,990.00 Budgeted 9,902.00 Remaining 45 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 1058 03/28/2018 March A/P Sewer clean out LS #2 SSO call 1,069.50 1,075.50 2,145.00 Ace Pipe Cleaning, Inc. 4037 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,075.50 2,145.00 ** 20,550.00 Budgeted 18,405.00 Remaining 10 % Used Account: 135-55080-020-000 Maintenance & Repairs 1019 03/20/2018 March A/P Blower maintenance 19,177.69 270.84 19,448.53 AIR MAC 4004 AP 1019 03/20/2018 March A/P Blower belts 136.00 19,584.53 AIR MAC 4004 AP 1019 03/20/2018 March A/P LS 2 Emergency Maintenance 905.10 20,489.63 Walker Engineering Inc 4033 AP 1019 03/20/2018 March A/P Bar screen/Grit Bags 1,220.00 21,709.63 Huber Technology Inc 4014 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 THE HOME DEPOT #6581 4.31 21,713.94 THE HOME DEPOT #6581 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 FUSECO DALLAS 252.45 21,966.39 FUSECO DALLAS PC 1125 03/31/2018 March A/P Pump for LS #9 4,779.00 26,745.39 XYLEM WATER SOLUTIONS USA INC 4085 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,567.70 26,745.39 ** 86,100.00 Budgeted 59,354.61 Remaining 31 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 1019 03/20/2018 March A/P Crane truck repairs 3,406.41 406.02 3,812.43 MICHAEL G. WATSON 4023 AP 1020 03/20/2018 March A/P Truck graphics 250.00 4,062.43 M-KAM LTD. 4019 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON COUNTY, TX SOUT 1.00 4,063.43 DENTON COUNTY, TX SOUT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON COUNTY, TX SOUT 33.50 4,096.93 DENTON COUNTY, TX SOUT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX.GOV SERVICEFEE- 2.00 4,098.93 TX.GOV SERVICEFEE- PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON VEHREG 22.00 4,120.93 DENTON VEHREG PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON VEHREG 8.25 4,129.18 DENTON VEHREG PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX.GOV SERVICEFEE- 2.00 4,131.18 TX.GOV SERVICEFEE- PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CLASSIC CHEVROLET LT 140.00 4,271.18 CLASSIC CHEVROLET LT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ROANOKE AUTO SUPPLY LT 20.96 4,292.14 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 885.73 4,292.14 ** 8,000.00 Budgeted 3,707.86 Remaining 54 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 289.69 .00 289.69 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 289.69 ** 500.00 Budgeted 210.31 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1019 03/20/2018 March A/P Sludge haul off 35,703.37 1,699.72 37,403.09 L.H. CHANEY MATERIALS, INC. 4018 AP 1019 03/20/2018 March A/P Sludge haul off 2,103.21 39,506.30 L.H. CHANEY MATERIALS, INC. 4018 AP 1058 03/28/2018 March A/P Sludge haul off 1,948.15 41,454.45 L.H. CHANEY MATERIALS, INC. 4060 AP 1128 03/31/2018 March A/P sludge haul off 1,906.32 43,360.77 L.H. CHANEY MATERIALS, INC. 4060 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 7,657.40 43,360.77 ** 60,000.00 Budgeted 16,639.23 Remaining 72 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-020-000 Lab Analysis 1019 03/20/2018 March A/P Lab testing 16,462.82 176.00 16,638.82 OXIDOR LABORATORIES LLC 4025 AP 1019 03/20/2018 March A/P Lab testing 246.00 16,884.82 OXIDOR LABORATORIES LLC 4025 AP 1019 03/20/2018 March A/P Lab testing 176.00 17,060.82 OXIDOR LABORATORIES LLC 4025 AP 1040 03/23/2018 March A/P Lab tests 246.00 17,306.82 OXIDOR LABORATORIES LLC 4069 AP 1040 03/23/2018 March A/P Lab tests 176.00 17,482.82 OXIDOR LABORATORIES LLC 4069 AP 1058 03/28/2018 March A/P Lab tests 246.00 17,728.82 OXIDOR LABORATORIES LLC 4069 AP 1058 03/28/2018 March A/P Lab tests 176.00 17,904.82 OXIDOR LABORATORIES LLC 4069 AP 1125 03/31/2018 March A/P Lab analysis 246.00 18,150.82 OXIDOR LABORATORIES LLC 4069 AP 1132 03/31/2018 March A/P Lab analysis 176.00 18,326.82 OXIDOR LABORATORIES LLC 4069 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,864.00 18,326.82 ** 30,000.00 Budgeted 11,673.18 Remaining 61 % Used Account: 135-60010-020-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 2,102.05 382.10 2,484.15 VERIZON WIRELESS 4031 AP 1179 03/31/2018 March A/P Cell phones 381.57 2,865.72 VERIZON WIRELESS AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 763.67 2,865.72 ** 4,700.00 Budgeted 1,834.28 Remaining 61 % Used Account: 135-60020-020-000 Electricity 989 03/14/2018 March A/P Electricity 1/25-2/26 73,158.80 205.62 73,364.42 TRI COUNTY ELECTRIC 4030 AP 989 03/14/2018 March A/P Electricity 1/25-2/26 312.99 73,677.41 TRI COUNTY ELECTRIC 4030 AP 989 03/14/2018 March A/P Electricity 1/25-2/26 27.99 73,705.40 TRI COUNTY ELECTRIC 4030 AP 1019 03/20/2018 March A/P Electricity 2/8-3/9 12,496.95 86,202.35 HUDSON ENERGY SERVICES, LLC 4016 AP 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (319.19) 85,883.16 AR 1179 03/31/2018 March A/P Electricity 2/26-3/26 176.28 86,059.44 TRI COUNTY ELECTRIC AP 1179 03/31/2018 March A/P Electricity 2/26-3/26 298.04 86,357.48 TRI COUNTY ELECTRIC AP 1179 03/31/2018 March A/P Electricity 2/26-3/26 27.68 86,385.16 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,226.36 86,385.16 ** 266,709.00 Budgeted 180,323.84 Remaining 32 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ IND RENEWAL L 111.00 222.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 222.00 222.00 ** 5,677.00 Budgeted 5,455.00 Remaining 4 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 73.06 .00 73.06 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 73.06 ** 1,635.00 Budgeted 1,561.94 Remaining 4 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1125 03/31/2018 March A/P March mowing 1,770.00 590.00 2,360.00 WATTS ELLISON LLC 4083 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 2,360.00 ** 11,600.00 Budgeted 9,240.00 Remaining 20 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1066 03/31/2018 Texpool Transfers March 55,474.05 11,094.81 66,568.86 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 66,568.86 ** 122,043.00 Budgeted 55,474.14 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1066 03/31/2018 Texpool Transfers March 272,153.60 54,430.72 326,584.32 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 326,584.32 ** 598,738.00 Budgeted 272,153.68 Remaining 55 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1066 03/31/2018 Texpool Transfers March 51,390.00 10,278.00 61,668.00 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % 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 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1058 03/28/2018 March A/P Fuel 3,731.07 1,004.37 4,735.44 US Bank Voyager Fleet Systems 4080 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,004.37 4,735.44 ** 12,500.00 Budgeted 7,764.56 Remaining 38 % Used Account: 135-65010-020-000 Uniforms 1,774.59 .00 1,774.59 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,774.59 ** 4,459.00 Budgeted 2,684.41 Remaining 40 % Used Account: 135-65030-020-000 Chemicals 1040 03/23/2018 March A/P 4 barrels of MBR chemicals 3,892.03 874.60 4,766.63 Valley Solvent Company, INC AP 1059 03/23/2018 corrected inv received 4 barrels of MBR chemicals (874.60) 3,892.03 Valley Solvent Company, INC AP 1058 03/28/2018 March A/P 4 barrels of MBR chemicals 684.72 4,576.75 Valley Solvent Company, INC 4081 AP 1147 03/31/2018 March A/P 4 barrels of MBR chemicals 674.60 5,251.35 Valley Solvent Company, INC 4091 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,359.32 5,251.35 ** 27,500.00 Budgeted 22,248.65 Remaining 19 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 LOWES #00732* 1,118.21 20.78 1,138.99 LOWES #00732* PC _______________ Account: 135-65035-020-000 Small Tools Totals: 20.78 1,138.99 ** 1,000.00 Budgeted (138.99) Remaining 114 % Used Account: 135-65040-020-000 Safety Equipment 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 LOWES #00732* 260.00 54.90 314.90 LOWES #00732* PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 78.00 392.90 TX AMERICA SAFETY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 79.50 472.40 TX AMERICA SAFETY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON.COM 114.17 586.57 AMAZON.COM PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 326.57 586.57 ** 750.00 Budgeted 163.43 Remaining 78 % Used Account: 135-65045-020-000 Lab Supplies 1019 03/20/2018 March A/P sample bottles 5,671.38 1,317.75 6,989.13 IDEXX DISTRIBUTION, INC 4017 AP 1019 03/20/2018 March A/P E Coli 686.55 7,675.68 IDEXX DISTRIBUTION, INC 4017 AP 1040 03/23/2018 March A/P WOrk latex gloves 162.00 7,837.68 LOU'S GLOVES INCORPORATED 4064 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 KROGER #0512 1.78 7,839.46 KROGER #0512 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,168.08 7,839.46 ** 14,000.00 Budgeted 6,160.54 Remaining 56 % Used Account: 135-69005-020-000 Capital Outlays 989 03/14/2018 March A/P 2018 Chevrolet Silverado 15,054.43 32,225.00 47,279.43 CALDWELL COUNTRY CHEVROLET 4006 AP 989 03/14/2018 March A/P 2018 Chevy Silverado 27,915.00 75,194.43 CALDWELL COUNTRY CHEVROLET 4006 AP 1019 03/20/2018 March A/P Legal WWTP 1,062.50 76,256.93 Dubois Bryant Campbell LLP 4010 AP 1019 03/20/2018 March A/P Legal WWTP 1,062.50 77,319.43 Dubois Bryant Campbell LLP 4010 AP 1132 03/31/2018 March A/P WWTP Improvements 232,136.35 309,455.78 WEBBER-CADAGUA PARTNERS 4084 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 294,401.35 309,455.78 ** 547,327.00 Budgeted 237,871.22 Remaining 57 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % 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 Department 20 Totals: ----------------------------------- 1,328,256.80 ** 459,537.40 Monthly Total 2,981,140.00 Budgeted 1,652,883.20 Remaining 45 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2018 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 237 03/01/2018 Insurance/Wrk Comp Exp Mar 12.10 2.42 14.52 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 14.52 ** 30.00 Budgeted 15.48 Remaining 48 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1,135.00 .00 1,135.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem 960.00 .00 960.00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 960.00 ** 5,000.00 Budgeted 4,040.00 Remaining 19 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,021.73 .00 1,021.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 3,781.25 ** 2.42 Monthly Total 12,980.00 Budgeted 9,198.75 Remaining 29 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 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 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 155,434.79 12,579.56 168,014.35 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 12,614.06 180,628.41 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,193.62 180,628.41 ** 432,863.00 Budgeted 252,234.59 Remaining 42 % Used Account: 135-50010-030-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 410.65 6.93 417.58 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 39.09 456.67 PR _______________ Account: 135-50010-030-000 Overtime Totals: 46.02 456.67 ** 2,000.00 Budgeted 1,543.33 Remaining 23 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 929 03/09/2018 MUD PR 03.09.18 Retirement 17,050.78 1,164.26 18,215.04 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 1,170.41 19,385.45 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,334.67 19,385.45 ** 40,553.00 Budgeted 21,167.55 Remaining 48 % Used Account: 135-50026-030-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 19,047.97 2,072.63 21,120.60 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 2,072.61 23,193.21 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 23,193.21 ** 63,485.00 Budgeted 40,291.79 Remaining 37 % Used Account: 135-50027-030-000 Dental Insurance 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,493.40 129.78 1,623.18 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 129.74 1,752.92 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 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: 259.52 1,752.92 ** 5,502.00 Budgeted 3,749.08 Remaining 32 % Used Account: 135-50028-030-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 298.90 21.28 320.18 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 21.23 341.41 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 341.41 ** 1,173.00 Budgeted 831.59 Remaining 29 % Used Account: 135-50029-030-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,703.90 48.85 1,752.75 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 145.04 1,897.79 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 18.50 1,916.29 BenefitMall 4040 AP 1141 03/31/2018 March A/P Clean up for new Employee Add 4.00 1,920.29 Legal Shield 4090 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 216.39 1,920.29 ** 5,059.00 Budgeted 3,138.71 Remaining 38 % Used Account: 135-50030-030-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 9,501.76 742.58 10,244.34 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 743.85 10,988.19 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,486.43 10,988.19 ** 27,181.00 Budgeted 16,192.81 Remaining 40 % Used Account: 135-50035-030-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 2,222.16 173.69 2,395.85 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 173.96 2,569.81 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 347.65 2,569.81 ** 6,357.00 Budgeted 3,787.19 Remaining 40 % Used Account: 135-50040-030-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 54.70 4.28 58.98 PR 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 842.92 901.90 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 847.20 901.90 ** 1,260.00 Budgeted 358.10 Remaining 72 % Used Account: 135-50045-030-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 617.50 123.50 741.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 741.00 ** 1,529.00 Budgeted 788.00 Remaining 48 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TOM THUMB #1789 2,320.79 15.68 2,336.47 TOM THUMB #1789 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 HOT & CREAMY DONUTS 11.79 2,348.26 HOT & CREAMY DONUTS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 27.47 2,348.26 ** 4,960.00 Budgeted 2,611.74 Remaining 47 % Used Account: 135-55030-030-000 Software & Support 1019 03/20/2018 March A/P Software update 43,128.59 72.50 43,201.09 STW INC 4026 AP 1019 03/20/2018 March A/P Office 365 lease 168.00 43,369.09 M3 Networks 4020 AP 1020 03/20/2018 March A/P Internet 976.21 44,345.30 Charter Communications 4007 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CANVA FOR WORK MONTHLY 12.95 44,358.25 CANVA FOR WORK MONTHLY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ADOBE SYSTEMS INC 16.23 44,374.48 ADOBE SYSTEMS INC PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ATT*BILL PAYMENT 112.07 44,486.55 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,357.96 44,486.55 ** 78,391.00 Budgeted 33,904.45 Remaining 57 % Used Account: 135-55070-030-000 Independent Labor 1125 03/31/2018 March A/P STW consulting 63,070.84 103.34 63,174.18 DRG ENTERPRISES 4048 AP 1132 03/31/2018 March A/P GM March 2018 11,000.58 74,174.76 Carman Consulting LLC. 4035 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,103.92 74,174.76 ** 154,000.00 Budgeted 79,825.24 Remaining 48 % Used Account: 135-55080-030-000 Maintenance & Repairs 1019 03/20/2018 March A/P A/C Mud building 2,281.50 170.00 2,451.50 BRANDON R REED 4005 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 MICHAELS KEYS 24.23 2,475.73 MICHAELS KEYS PC _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 194.23 2,475.73 ** 14,000.00 Budgeted 11,524.27 Remaining 18 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 1019 03/20/2018 March A/P Janitorial services 3,093.33 869.06 3,962.39 MEMBER'S BUILDING MAINTENANCE 4022 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 3,962.39 ** 10,000.00 Budgeted 6,037.61 Remaining 40 % Used Account: 135-55160-030-000 Professional Outside Services 1040 03/23/2018 March A/P Winter average rates 56,475.00 2,765.00 59,240.00 NEW GEN STRATEGIES & SOLUTIONS 4068 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 2,765.00 59,240.00 ** 63,325.00 Budgeted 4,085.00 Remaining 94 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1155 03/31/2018 March A/P March mailings 2,974.25 977.54 3,951.79 DATAPROSE LLC 4092 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 977.54 3,951.79 ** 9,000.00 Budgeted 5,048.21 Remaining 44 % Used Account: 135-60005-030-000 Telephone 1040 03/23/2018 March A/P answering service 7,388.97 194.75 7,583.72 KEYSTONE PARK SECRETARIAL 4057 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 RINGCENTRAL, INC 13.96 7,597.68 RINGCENTRAL, INC PC 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (180.00) 7,417.68 AR _______________ Account: 135-60005-030-000 Telephone Totals: 28.71 7,417.68 ** 27,300.00 Budgeted 19,882.32 Remaining 27 % Used Account: 135-60010-030-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 1,324.62 87.44 1,412.06 VERIZON WIRELESS 4031 AP 1031 03/23/2018 MUD PR 03.23.18 Communications/Mobiles 150.00 1,562.06 PR 1179 03/31/2018 March A/P Cell phones 87.37 1,649.43 VERIZON WIRELESS AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 324.81 1,649.43 ** 4,000.00 Budgeted 2,350.57 Remaining 41 % Used Account: 135-60020-030-000 Electricity/Gas 1125 03/31/2018 March A/P 12/8-1/10 & 1/10-2/8 Electrici 1,697.60 1,409.08 3,106.68 TOWN OF TROPHY CLUB 4078 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,409.08 3,106.68 ** 16,261.00 Budgeted 13,154.32 Remaining 19 % Used Account: 135-60025-030-000 Water 1125 03/31/2018 March A/P MUD admin water 285.76 106.71 392.47 TROPHY CLUB MUD (WATER BILLS) 4079 AP 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (53.35) 339.12 AR _______________ Account: 135-60025-030-000 Water Totals: 53.36 339.12 ** 2,500.00 Budgeted 2,160.88 Remaining 14 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 1155 03/31/2018 March A/P March mailings 9,651.64 3,013.63 12,665.27 DATAPROSE LLC 4092 AP _______________ Account: 135-60035-030-000 Postage Totals: 3,013.63 12,665.27 ** 30,000.00 Budgeted 17,334.73 Remaining 42 % Used Account: 135-60040-030-000 Service Charges & Fees 930 03/09/2018 Child Support Fee 25,547.54 1.50 25,549.04 GL 1032 03/23/2018 Child Support Fee 1.50 25,550.54 GL 1001 03/31/2018 Pace Credit Card Fees 4,104.89 29,655.43 GL 1001 03/31/2018 Pace Credit Card Fees 90.69 29,746.12 GL 1125 03/31/2018 March A/P Direct Send fees 50.00 29,796.12 Fiserv Solutions, LLC 4049 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,248.58 29,796.12 ** 55,560.00 Budgeted 25,763.88 Remaining 54 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 237 03/01/2018 Insurance/Wrk Comp Exp Mar 33,726.80 6,100.36 39,827.16 GL 989 03/14/2018 March A/P Notary-D'Andria 50.00 39,877.16 VICTOR O SCHINNERER & CO, INC 4032 AP _______________ Account: 135-60055-030-000 Insurance Totals: 6,150.36 39,877.16 ** 56,000.00 Budgeted 16,122.84 Remaining 71 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 1019 03/20/2018 March A/P Toilet tablets 3,808.42 20.00 3,828.42 Texas Water Development Board 4028 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 20.00 3,828.42 ** 6,000.00 Budgeted 2,171.58 Remaining 64 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 2,693.00 .00 2,693.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,693.00 ** 7,600.00 Budgeted 4,907.00 Remaining 35 % Used Account: 135-60100-030-000 Travel & per diem 929 03/09/2018 MUD PR 03.09.18 Travel & per diem 582.17 17.66 599.83 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 17.66 599.83 ** 4,885.00 Budgeted 4,285.17 Remaining 12 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 145.00 .00 145.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60115-030-000 Elections Totals: .00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 1040 03/23/2018 March A/P monthly monitoring fee for pan 48.00 24.00 72.00 Digital Air Control, Inc 4045 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 72.00 ** 2,700.00 Budgeted 2,628.00 Remaining 3 % Used Account: 135-60245-030-000 Miscellaneous Expenses 124.50 .00 124.50 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 WM SUPERCENTER #5247 23.00 23.00 WM SUPERCENTER #5247 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 RED WING SHOES #652 114.74 137.74 RED WING SHOES #652 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: 137.74 137.74 ** 700.00 Budgeted 562.26 Remaining 20 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 1020 03/20/2018 March A/P Office supplies 2,612.69 36.36 2,649.05 OFFICE DEPOT, INC 4024 AP 1020 03/20/2018 March A/P office supplies 34.55 2,683.60 OFFICE DEPOT, INC 4024 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 STAPLES 00116533 137.14 2,820.74 STAPLES 00116533 PC 1179 03/31/2018 March A/P Office supplies 55.47 2,876.21 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 263.52 2,876.21 ** 7,000.00 Budgeted 4,123.79 Remaining 41 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1179 03/31/2018 March A/P Office supplies 1,903.05 145.61 2,048.66 OFFICE DEPOT, INC AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 145.61 2,048.66 ** 2,000.00 Budgeted (48.66) Remaining 102 % Used Account: 135-65095-030-000 Maintenance Supplies 1020 03/20/2018 March A/P coffee 2,061.86 51.86 2,113.72 OFFICE DEPOT, INC 4024 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 COFFEEICON COM 39.98 2,153.70 COFFEEICON COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SAMS CLUB #4795 99.50 2,253.20 SAMS CLUB #4795 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SAMSCLUB.COM 65.22 2,318.42 SAMSCLUB.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TOM THUMB #1789 46.93 2,365.35 TOM THUMB #1789 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON MKTPLACE PMTS 138.53 2,503.88 AMAZON MKTPLACE PMTS PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 STAPLES DIRECT 61.71 2,565.59 STAPLES DIRECT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON.COM 16.09 2,581.68 AMAZON.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 WALMART.COM 43.27 2,624.95 WALMART.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON MKTPLACE PMTS 21.36 2,646.31 AMAZON MKTPLACE PMTS PC 1179 03/31/2018 March A/P COffe supplies-breakroom 106.32 2,752.63 OFFICE DEPOT, INC AP 1179 03/31/2018 March A/P Office supplies 34.77 2,787.40 OFFICE DEPOT, INC AP 1179 03/31/2018 March A/P Breakroom 34.99 2,822.39 OFFICE DEPOT, INC AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 760.53 2,822.39 ** 4,000.00 Budgeted 1,177.61 Remaining 71 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 989 03/14/2018 March A/P Copier Lease 1,229.02 165.00 1,394.02 EVERBANK COMMERCIAL FINANCE 4011 AP 1040 03/23/2018 March A/P Copies/lease 82.12 1,476.14 KYOCERA DOCUMENT SOLUTIONS 4059 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 247.12 1,476.14 ** 4,600.00 Budgeted 3,123.86 Remaining 32 % Used Department 30 Totals: ----------------------------------- 558,326.50 ** 69,182.64 Monthly Total 1,227,112.00 Budgeted 668,785.50 Remaining 45 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2018 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 989 03/14/2018 March A/P Legal 29,343.55 3,270.00 32,613.55 McLean & Howard, L.L.P. 4021 AP 989 03/14/2018 March A/P Legal 1,050.00 33,663.55 McLean & Howard, L.L.P. 4021 AP 1179 03/31/2018 March A/P legal 2,100.00 35,763.55 McLean & Howard, L.L.P. AP 1179 03/31/2018 March A/P Legal 1,050.00 36,813.55 McLean & Howard, L.L.P. AP _______________ Account: 135-55045-039-000 Legal Totals: 7,470.00 36,813.55 ** 137,000.00 Budgeted 100,186.45 Remaining 27 % Used Account: 135-55055-039-000 Auditing 25,508.70 .00 25,508.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 923 03/07/2018 March A/P Appraisal 2nd Qtr Budget 2018 4,660.18 2,011.87 6,672.05 DENTON CENTRAL APPRAISAL DISTR 3980 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 6,672.05 ** 11,446.00 Budgeted 4,773.95 Remaining 58 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 71,962.70 ** 9,481.87 Monthly Total 176,746.00 Budgeted 104,783.30 Remaining 41 % Used Fund 135 Totals: ----------------------------------- (178,897.19) 222,273.26 Monthly Total (194,618.00) Budgeted (15,720.81) Remaining 92 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MARCH 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 363,680 ACCOUNTS RECEIVABLE - TOTAL ASSETS 363,680 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 680,448 TOTAL LIABILITIES 680,448 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,309,346) TOTAL FUND BALANCE (316,767) TOTAL LIABILITIES AND FUND BALANCE 363,680 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 23:00 04/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,507.06- 8,705.84- 8,705.84 Subtotal: 1,507.06- 8,705.84- 8,705.84 Program number: 1,507.06- 8,705.84- 8,705.84 Department number: Revenues 1,507.06- 8,705.84- 8,705.84 Revenues Subtotal ----------- 1,507.06- 8,705.84- 8,705.84 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 23:00 04/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 668,708.17 1,318,052.33 1,318,052.33- Subtotal: 668,708.17 1,318,052.33 1,318,052.33- Program number: 668,708.17 1,318,052.33 1,318,052.33- Department number: Wastewater 668,708.17 1,318,052.33 1,318,052.33- Expenditures Subtotal ----------- 668,708.17 1,318,052.33 1,318,052.33- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 667,201.11 1,309,346.49 1,309,346.49- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (7,198.78) (1,507.06) (8,705.84) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,507.06) (8,705.84) ** .00 Budgeted 8,705.84 Remaining 0 % Used Department Totals: ----------------------------------- (8,705.84) ** (1,507.06) Monthly Total .00 Budgeted 8,705.84 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 989 03/14/2018 March A/P WWTP Improvements App 26 649,344.16 634,924.19 1,284,268.35 WEBBER-CADAGUA PARTNERS 4034 AP 1019 03/20/2018 March A/P WWTP Improvements 33,783.98 1,318,052.33 CP&Y/WALLACE GROUP, INC. 4009 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 668,708.17 1,318,052.33 ** .00 Budgeted (1,318,052.33) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,318,052.33 ** 668,708.17 Monthly Total .00 Budgeted (1,318,052.33) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,309,346.49 667,201.11 Monthly Total .00 Budgeted (1,309,346.49) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET MARCH 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 1,803,320 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,803,320 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES (2,693,209) TOTAL FUND BALANCE 1,532,372 TOTAL LIABILITIES AND FUND BALANCE 1,803,320 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 23:00 04/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68 2,693,208.68- Program number: 2,693,208.68 2,693,208.68 2,693,208.68- Department number: Water 2,693,208.68 2,693,208.68 2,693,208.68- Expenditures Subtotal ----------- 2,693,208.68 2,693,208.68 2,693,208.68- Fund number: 519 2016 Rev Bond Const-SWIFT 2,693,208.68 2,693,208.68 2,693,208.68- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-69005-010-000 Capital Outlays 1183 03/16/2018 NSII Fort Worth Wire 30in Capt 2,693,208.68 2,693,208.68 GL 1184 03/16/2018 NSII Fort Worth 30in Wire 135 2,693,208.68 5,386,417.36 GL 1185 03/16/2018 REV- NSII Fort Worth Wire 30in (2,693,208.68) 2,693,208.68 GL _______________ Account: 519-69005-010-000 Capital Outlays Totals: 2,693,208.68 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 2,693,208.68 ** 2,693,208.68 Monthly Total .00 Budgeted (2,693,208.68) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 2,693,208.68 2,693,208.68 Monthly Total .00 Budgeted (2,693,208.68) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 515,627 ACCOUNTS RECEIVABLE - TOTAL ASSETS 515,627 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 89,048 TOTAL FUND BALANCE 515,627 TOTAL LIABILITIES AND FUND BALANCE 515,627 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 23:00 04/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 646.32- 2,882.27- 288.227 1,882.27 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 24,498.00- 50.000 24,498.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 61,668.00- 50.000 61,668.00- Subtotal: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Program number: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Department number: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (2,235.95) (646.32) (2,882.27) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (646.32) (2,882.27) ** (1,000.00) Budgeted 1,882.27 Remaining 288 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1066 03/31/2018 Texpool Transfers March (20,415.00) (4,083.00) (24,498.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (24,498.00) ** (48,996.00) Budgeted (24,498.00) Remaining 50 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1066 03/31/2018 Texpool Transfers March (51,390.00) (10,278.00) (61,668.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ----------------------------------- (89,048.27) ** (15,007.32) Monthly Total (173,332.00) Budgeted (84,283.73) Remaining 51 % Used Fund 528 Totals: ----------------------------------- (89,048.27) (15,007.32) Monthly Total (173,332.00) Budgeted (84,283.73) Remaining 51 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 842,208 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 24,530 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 871,311 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 24,530 ACCOUNTS AND OTHER PAYABLES 915 TOTAL LIABILITIES 25,445 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 813,525 TOTAL FUND BALANCE 845,866 TOTAL LIABILITIES AND FUND BALANCE 871,311 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 23:00 04/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 9,065.28- 664,307.38- 99.201 5,352.62- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 147.00- 2,030.81- 112.823 230.81 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 431.48- 1,021.90- 51.095 978.10- Subtotal: 673,460.00- 673,460.00- 9,643.76- 667,360.09- 99.094 6,099.91- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,061.79- 2,595.85- 129.792 595.85 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 11,094.81- 66,568.86- 54.545 55,474.14- Subtotal: 342,997.00- 342,997.00- 12,156.60- 288,118.71- 84.000 54,878.29- Program number: 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- Department number: Revenues 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 23:00 04/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 200.00 9.302 1,950.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 50.000 141,754.25 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Program number: 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Department number: Administration 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 21,800.36- 813,525.05- ############### 807,726.05 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1097 03/01/2018 Property Taxes (655,242.10) (453.14) (655,695.24) GL 1098 03/02/2018 Property Taxes (1,285.37) (656,980.61) GL 1099 03/05/2018 Property Taxes (761.56) (657,742.17) GL 1100 03/06/2018 Property Taxes (309.26) (658,051.43) GL 1101 03/07/2018 Property Taxes (838.73) (658,890.16) GL 1103 03/09/2018 Property Taxes (191.64) (659,081.80) GL 1104 03/12/2018 Property Taxes (35.06) (659,116.86) GL 1105 03/13/2018 Property Taxes (53.27) (659,170.13) GL 1106 03/14/2018 Property Taxes (187.67) (659,357.80) GL 1107 03/16/2018 Property Taxes (252.76) (659,610.56) GL 1108 03/19/2018 Property Taxes (441.73) (660,052.29) GL 1109 03/20/2018 Property Taxes (14.57) (660,066.86) GL 1110 03/21/2018 Property Taxes (393.93) (660,460.79) GL 1111 03/22/2018 Property Taxes (3,564.61) (664,025.40) GL 1112 03/23/2018 Property Taxes 915.33 (663,110.07) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (915.33) (664,025.40) GL 1113 03/26/2018 Property Taxes (422.94) (664,448.34) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 915.33 (663,533.01) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (23.65) (663,556.66) GL 1115 03/28/2018 Property Taxes (586.62) (664,143.28) GL 1116 03/29/2018 Property Taxes (164.10) (664,307.38) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (9,065.28) (664,307.38) ** (669,660.00) Budgeted (5,352.62) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1097 03/01/2018 Property Taxes (1,883.81) (3.04) (1,886.85) GL 1098 03/02/2018 Property Taxes (9.70) (1,896.55) GL 1099 03/05/2018 Property Taxes (.03) (1,896.58) GL 1100 03/06/2018 Property Taxes (4.44) (1,901.02) GL 1104 03/12/2018 Property Taxes (3.26) (1,904.28) GL 1107 03/16/2018 Property Taxes (126.50) (2,030.78) GL 1114 03/27/2018 Property Taxes (.03) (2,030.81) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (147.00) (2,030.81) ** (1,800.00) Budgeted 230.81 Remaining 113 % Used Account: 533-40015-000-000 Property Taxes/P & I 1097 03/01/2018 Property Taxes (590.42) (33.20) (623.62) GL 1098 03/02/2018 Property Taxes (84.35) (707.97) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1099 03/05/2018 Property Taxes (590.42) (65.51) (773.48) GL 1100 03/06/2018 Property Taxes (28.13) (801.61) GL 1101 03/07/2018 Property Taxes (56.67) (858.28) GL 1103 03/09/2018 Property Taxes (17.24) (875.52) GL 1104 03/12/2018 Property Taxes (4.38) (879.90) GL 1107 03/16/2018 Property Taxes (52.90) (932.80) GL 1108 03/19/2018 Property Taxes (12.08) (944.88) GL 1110 03/21/2018 Property Taxes (8.23) (953.11) GL 1112 03/23/2018 Property Taxes (.13) (953.24) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .13 (953.11) GL 1113 03/26/2018 Property Taxes (12.67) (965.78) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.13) (965.91) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.06) (965.97) GL 1115 03/28/2018 Property Taxes (47.33) (1,013.30) GL 1116 03/29/2018 Property Taxes (8.60) (1,021.90) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (431.48) (1,021.90) ** (2,000.00) Budgeted (978.10) Remaining 51 % Used Account: 533-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (1,534.06) (1,061.79) (2,595.85) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,061.79) (2,595.85) ** (2,000.00) Budgeted 595.85 Remaining 130 % Used Account: 533-49015-000-000 Lease/Rental Income (218,954.00) .00 (218,954.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1066 03/31/2018 Texpool Transfers March (55,474.05) (11,094.81) (66,568.86) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (66,568.86) ** (122,043.00) Budgeted (55,474.14) Remaining 55 % Used Department Totals: ----------------------------------- (955,478.80) ** (21,800.36) Monthly Total (1,016,457.00) Budgeted (60,978.20) Remaining 94 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2018 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 200.00 .00 200.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 200.00 ** 2,150.00 Budgeted 1,950.00 Remaining 9 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 141,753.75 .00 141,753.75 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 141,753.75 ** 283,508.00 Budgeted 141,754.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 141,953.75 ** .00 Monthly Total 1,010,658.00 Budgeted 868,704.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (813,525.05) (21,800.36) Monthly Total (5,799.00) Budgeted 807,726.05 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MARCH 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 231,796 ACCOUNTS RECEIVABLE - TOTAL ASSETS 231,796 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 215,586 TOTAL FUND BALANCE 231,796 TOTAL LIABILITIES AND FUND BALANCE 231,796 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 23:00 04/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 235.33- 870.09- 87.009 129.91- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 326,584.32- 54.545 272,153.68- Subtotal: 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Program number: 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Department number: Revenues 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 23:00 04/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2018 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 200.00 50.000 200.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 50.000 111,669.25 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Program number: 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Department number: Administration 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Expenditures Subtotal ----------- 598,738.00 598,738.00 111,868.75 18.684 486,869.25 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,666.05- 215,585.66- ############### 214,585.66 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (634.76) (235.33) (870.09) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (235.33) (870.09) ** (1,000.00) Budgeted (129.91) Remaining 87 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1066 03/31/2018 Texpool Transfers March (272,153.60) (54,430.72) (326,584.32) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (326,584.32) ** (598,738.00) Budgeted (272,153.68) Remaining 55 % Used Department Totals: ----------------------------------- (327,454.41) ** (54,666.05) Monthly Total (599,738.00) Budgeted (272,283.59) Remaining 55 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2018 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 200.00 .00 200.00 _______________ Account: 534-70005-051-000 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 111,668.75 .00 111,668.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 111,668.75 ** 223,338.00 Budgeted 111,669.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 111,868.75 ** .00 Monthly Total 598,738.00 Budgeted 486,869.25 Remaining 19 % Used Fund 534 Totals: ----------------------------------- (215,585.66) (54,666.05) Monthly Total (1,000.00) Budgeted 214,585.66 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 121,486 ACCOUNTS RECEIVABLE - TOTAL ASSETS 121,486 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 120,534 TOTAL FUND BALANCE 121,486 TOTAL LIABILITIES AND FUND BALANCE 121,486 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 23:00 04/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 600.00- 600.00- 127.12- 394.46- 65.743 205.54- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 151,681.86- 54.545 126,402.14- Subtotal: 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Program number: 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Department number: Revenues 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 23:00 04/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 50.000 31,342.25 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Program number: 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Department number: Administration 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Expenditures Subtotal ----------- 278,084.00 278,084.00 31,541.75 11.343 246,542.25 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,407.43- 120,534.57- ############### 119,934.57 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (267.34) (127.12) (394.46) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (127.12) (394.46) ** (600.00) Budgeted (205.54) Remaining 66 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1066 03/31/2018 Texpool Transfers March (126,401.55) (25,280.31) (151,681.86) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (151,681.86) ** (278,084.00) Budgeted (126,402.14) Remaining 55 % Used Department Totals: ----------------------------------- (152,076.32) ** (25,407.43) Monthly Total (278,684.00) Budgeted (126,607.68) Remaining 55 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2018 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 200.00 .00 200.00 _______________ Account: 535-70005-051-000 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 31,341.75 .00 31,341.75 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 31,341.75 ** 62,684.00 Budgeted 31,342.25 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 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 31,541.75 ** .00 Monthly Total 278,084.00 Budgeted 246,542.25 Remaining 11 % Used Fund 535 Totals: ----------------------------------- (120,534.57) (25,407.43) Monthly Total (600.00) Budgeted 119,934.57 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,087,377.81 **** 3,502,584.80 Monthly Total (375,349.00) Budgeted (2,462,726.81) Remaining ########## ******* End of Report *********