Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-05 May Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 738,364 PREPAID EXPENSES 5,079 ADVALOREM PROPERTY TAXES RECEIVABLE 23,322 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 766,765 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 23,322 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 23,322 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 221,191 TOTAL FUND BALANCE 743,443 TOTAL LIABILITIES AND FUND BALANCE 766,765 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:05 06/13/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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- 8,766.26- 1,057,968.15- 100.335 3,535.15 122-40011-000-000 Property Taxes/Fire-Delinquent 318.65- 3,885.98- 3,885.98 122-40020-000-000 Property Taxes/Fire P&I 1,033.95- 4,448.81- 4,448.81 Subtotal: 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Program number: 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:05 06/13/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 10,158.96 56.439 7,841.04 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 405,940.00 66.667 202,970.00 Subtotal: 845,864.00 845,864.00 52,012.37 635,052.96 75.077 210,811.04 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 845,112.05 80.148 209,320.95 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 845,112.05 80.148 209,320.95 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 845,112.05 80.148 209,320.95 Fund number: 122 Trophy Club MUD Fire Dept. 41,893.51 221,190.89- 221,190.89 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (1,049,201.89) (104.92) (1,049,306.81) GL 1477 05/02/2018 Property Taxes (20.20) (1,049,327.01) GL 1478 05/03/2018 Property Taxes (116.90) (1,049,443.91) GL 1479 05/04/2018 Property Taxes (48.13) (1,049,492.04) GL 1480 05/07/2018 Property Taxes (1,327.10) (1,050,819.14) GL 1481 05/09/2018 Property Taxes (332.30) (1,051,151.44) GL 1482 05/10/2018 Property Taxes (55.14) (1,051,206.58) GL 1483 05/11/2018 Property Taxes (578.25) (1,051,784.83) GL 1484 05/14/2018 Property Taxes (781.17) (1,052,566.00) GL 1485 05/15/2018 Property Taxes (41.68) (1,052,607.68) GL 1486 05/16/2018 Property Taxes (1,008.61) (1,053,616.29) GL 1487 05/17/2018 Property Taxes (379.31) (1,053,995.60) GL 1488 05/18/2018 Property Taxes (52.86) (1,054,048.46) GL 1489 05/21/2018 Property Taxes (92.20) (1,054,140.66) GL 1490 05/22/2018 Property Taxes (59.27) (1,054,199.93) GL 1491 05/23/2018 Property Taxes (557.68) (1,054,757.61) GL 1492 05/24/2018 Property Taxes (1,563.43) (1,056,321.04) GL 1493 05/25/2018 Property Taxes (86.99) (1,056,408.03) GL 1495 05/29/2018 Property Taxes (312.49) (1,056,720.52) GL 1496 05/30/2018 Property Taxes (454.60) (1,057,175.12) GL 1497 05/31/2018 Property Taxes (793.03) (1,057,968.15) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (8,766.26) (1,057,968.15) ** (1,054,433.00) Budgeted 3,535.15 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1481 05/09/2018 Property Taxes (3,567.33) (17.96) (3,585.29) GL 1484 05/14/2018 Property Taxes (.01) (3,585.30) GL 1491 05/23/2018 Property Taxes 18.61 (3,566.69) GL 1495 05/29/2018 Property Taxes (319.29) (3,885.98) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (318.65) (3,885.98) ** .00 Budgeted 3,885.98 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1476 05/01/2018 Property Taxes (3,414.86) (13.24) (3,428.10) GL 1477 05/02/2018 Property Taxes (2.22) (3,430.32) GL 1478 05/03/2018 Property Taxes (12.86) (3,443.18) GL 1479 05/04/2018 Property Taxes (8.89) (3,452.07) GL 1480 05/07/2018 Property Taxes (163.89) (3,615.96) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (3,414.86) (73.17) (3,689.13) GL 1483 05/11/2018 Property Taxes (61.72) (3,750.85) GL 1484 05/14/2018 Property Taxes (48.78) (3,799.63) GL 1486 05/16/2018 Property Taxes (112.06) (3,911.69) GL 1487 05/17/2018 Property Taxes (23.97) (3,935.66) GL 1490 05/22/2018 Property Taxes (2.71) (3,938.37) GL 1491 05/23/2018 Property Taxes (21.55) (3,959.92) GL 1492 05/24/2018 Property Taxes (159.47) (4,119.39) GL 1495 05/29/2018 Property Taxes (225.10) (4,344.49) GL 1496 05/30/2018 Property Taxes (45.93) (4,390.42) GL 1497 05/31/2018 Property Taxes (58.39) (4,448.81) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,033.95) (4,448.81) ** .00 Budgeted 4,448.81 Remaining 0 % Used Department Totals: ----------------------------------- (1,066,302.94) ** (10,118.86) Monthly Total (1,054,433.00) Budgeted 11,869.94 Remaining 101 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 239 05/01/2018 Insurance/Wrk Comp Exp May 8,889.09 1,269.87 10,158.96 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 10,158.96 ** 18,000.00 Budgeted 7,841.04 Remaining 56 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1333 05/07/2018 May A/P May Fire Admin 355,197.50 50,742.50 405,940.00 TOWN OF TROPHY CLUB 4190 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 405,940.00 ** 608,910.00 Budgeted 202,970.00 Remaining 67 % 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: ----------------------------------- 845,112.05 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 209,320.95 Remaining 80 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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: ----------------------------------- (221,190.89) 41,893.51 Monthly Total .00 Budgeted 221,190.89 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,414,501 - 1,414,501 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 715,081 - 715,081 INVESTMENTS-TEXPOOL 2,501,942 596,426 3,098,368 PREPAID EXPENSES 37,383 - 37,383 ADVALOREM PROPERTY TAXES RECEIVABLE 2,559 - 2,559 UTILITY AND OTHER ACCOUNTS RECEIVABLE 975,346 - 975,346 TOTAL ASSETS 6,464,704 596,426 7,061,130 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,559 - 2,559 ACCOUNTS AND OTHER PAYABLES 681,095 - 681,095 CUSTOMER DEPOSITS 315,165 - 315,165 - TOTAL LIABILITIES 998,819 - 998,819 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 1,315,517 - 1,315,517 - TOTAL FUND BALANCE 5,465,885 596,426 6,062,311 TOTAL LIABILITIES AND FUND BALANCE 6,464,704 596,426 7,061,130 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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,005.48- 121,350.65- 100.331 400.65 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 112.85- 343.60- 171.800 143.60 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 129.27- 492.32- 246.160 292.32 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 1,247.60- 122,186.57- 40.839 177,002.43- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 498,952.46- 3,139,601.54- 48.570 3,324,417.46- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 259,749.23- 1,943,596.97- 65.264 1,034,470.03- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 7,467.82- 72,062.31- 67.805 34,216.69- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 950.00- 9,400.00- 44.028 11,950.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 200.00- 1,700.00- 113.333 200.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 600.00- 4,300.00- 95.556 200.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 10,885.60- 27,196.00- 45.327 32,804.00- Subtotal: 9,635,715.00- 9,635,715.00- 778,805.11- 5,197,856.82- 53.944 4,437,858.18- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 5,074.77- 30,645.77- 255.381 18,645.77 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 7,762.20- 71.043 3,163.80- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,666.64- 66.666 2,333.36- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,372.00- 10,806.76- 59.446 7,372.24- 135-49141-000-000 Interfund Transfer In 1,053,984.38- 1,850,129.46- 1,850,129.46 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 46,017.64- 58,775.83- 1,175.517 53,775.83 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- 1,107,032.12- 1,978,186.66- 627.747 1,663,061.66 Program number: 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 19,749.50 138,182.00 50.380 136,097.00 135-50010-010-000 Overtime 20,000.00 20,000.00 1,007.68 6,518.38 32.592 13,481.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 150.00 1,400.00 42.424 1,900.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,933.91 15,230.41 54.701 12,612.59 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 21,004.63 40.242 31,191.37 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,734.69 33.475 3,447.31 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 316.15 31.806 677.85 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 128.60 1,803.31 60.473 1,178.69 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,309.38 9,213.19 49.369 9,448.81 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 306.24 2,154.69 49.363 2,210.31 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 10.26 818.68 75.804 261.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 7,199.36 60.734 4,654.64 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 28,693.86 209,130.53 49.016 217,531.47 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 1,503.57 50,169.61 50.170 49,830.39 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 34.75 3,887.82 97.196 112.18 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 2,160.00 5,765.16 104.821 265.16- Subtotal: 391,000.00 391,000.00 3,698.32 59,822.59 15.300 331,177.41 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.18 2,492.62 53.034 2,207.38 135-60020-010-000 Electricity 175,356.00 175,356.00 9,001.73 82,161.55 46.854 93,194.45 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.00 76.700 233.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 141.00 1,536.78 55.181 1,248.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 17,410.32 31.554 37,765.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 58,261.27 1,021,013.08 36.165 1,802,156.92 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 502.70 16.757 2,497.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 6,000.00 40.678 8,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 202,242.48 72.727 75,841.52 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,068.00 32,649.00 66.636 16,347.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 526.968 853,935.08- 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 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 98,622.49 2,425,826.11 67.126 1,188,025.89 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 1,186.68 6,965.98 46.440 8,034.02 135-65010-010-000 Uniforms 4,488.00 4,488.00 1,249.14 27.833 3,238.86 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,227.07 11,958.84 59.794 8,041.16 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 391.00 583.00 58.300 417.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 5,011.00 21,102.00 42.204 28,898.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 7,815.75 90,758.96 51.659 84,929.04 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 159,996.29 525,538.34 64.880 284,473.66 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 159,996.29 708,402.72 67.581 339,828.28 Program number: 5,655,433.00 5,655,433.00 298,826.71 3,493,940.91 61.780 2,161,492.09 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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 1,200.08 60.004 799.92 Subtotal: 2,000.00 2,000.00 1,200.08 60.004 799.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,200.08 60.004 799.92 Department number: Water 5,657,433.00 5,657,433.00 298,826.71 3,495,140.99 61.780 2,162,292.01 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 25,207.65 235,318.69 57.274 175,547.31 135-50010-020-000 Overtime 30,000.00 30,000.00 3,966.19 23,600.81 78.669 6,399.19 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 5,636.00 67.095 2,764.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,763.32 26,611.46 62.996 15,631.54 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 43,493.33 69.953 18,681.67 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 3,204.18 60.789 2,066.82 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 567.26 50.921 546.74 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 172.36 3,162.18 73.865 1,118.82 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,674.11 15,650.17 55.274 12,663.83 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 391.52 3,660.11 55.272 2,961.89 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 10,784.00 59.944 7,206.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 63.00 63.00 21.000 237.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 42,235.63 380,300.19 60.693 246,300.81 135-55070-020-000 Independent Labor 20,550.00 20,550.00 2,145.00 10.438 18,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 7,926.11 44,421.37 51.593 41,678.63 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 6,353.60 79.420 1,646.40 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 4,895.51 55,077.12 91.795 4,922.88 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,186.60 22,716.02 75.720 7,283.98 Subtotal: 219,150.00 219,150.00 15,008.22 131,031.58 59.791 88,118.42 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 527.28 3,393.00 72.191 1,307.00 135-60020-020-000 Electricity 266,709.00 266,709.00 10,739.33 110,273.38 41.346 156,435.62 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 436.00 658.00 11.591 5,019.00 135-60090-020-000 Safety Program 550.00 550.00 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 90.46 5.533 1,544.54 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 19.97 19.97 .499 3,980.03 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,060.00 4,600.00 39.655 7,000.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 88,758.48 72.727 33,284.52 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 435,445.76 72.727 163,292.24 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,248.00 82,194.00 66.642 41,142.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 201,031.99 201,031.99 100.516 1,031.99- 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 1,438,938.00 289,588.10 958,851.29 66.636 480,086.71 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 925.48 6,265.67 50.125 6,234.33 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 2,760.00 8,041.23 29.241 19,458.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,149.94 114.994 149.94- 135-65040-020-000 Safety Equipment 750.00 750.00 406.53 1,157.50 154.333 407.50- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,783.23 13,483.81 96.313 516.19 Subtotal: 60,209.00 60,209.00 6,875.24 31,872.74 52.937 28,336.26 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,190.00 91,150.61 16.654 456,176.39 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 1,190.00 121,150.61 19.042 515,091.39 Program number: 2,981,140.00 2,981,140.00 354,897.19 1,623,206.41 54.449 1,357,933.59 Department number: Wastewater 2,981,140.00 2,981,140.00 354,897.19 1,623,206.41 54.449 1,357,933.59 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 19.36 64.533 10.64 Subtotal: 30.00 30.00 2.42 19.36 64.533 10.64 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 405.00 1,215.00 101.250 15.00- 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,540.00 38.500 2,460.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,255.28 62.764 744.72 Subtotal: 12,950.00 12,950.00 405.00 5,620.28 43.400 7,329.72 Program number: 12,980.00 12,980.00 407.42 5,639.64 43.449 7,340.36 Department number: Board of Directors 12,980.00 12,980.00 407.42 5,639.64 43.449 7,340.36 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 33,973.87 248,159.41 57.330 184,703.59 135-50010-030-000 Overtime 2,000.00 2,000.00 89.86 556.92 27.846 1,443.08 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 3,150.89 25,641.34 63.229 14,911.66 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 31,483.69 49.592 32,001.31 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 2,271.96 41.293 3,230.04 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 426.43 36.354 746.57 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 240.09 2,694.84 53.268 2,364.16 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,033.55 15,024.46 55.276 12,156.54 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 475.59 3,513.78 55.274 2,843.22 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 983.77 78.077 276.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 988.00 64.617 541.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 3,109.08 62.683 1,850.92 Subtotal: 595,970.00 595,970.00 44,534.62 338,526.13 56.803 257,443.87 135-55030-030-000 Software & Support 78,391.00 78,391.00 6,026.14 59,433.04 75.816 18,957.96 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,005.34 101,827.93 66.122 52,172.07 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 14.52 5,160.69 36.862 8,839.31 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 3,955.00 39.550 6,045.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 5,700.51 57.005 4,299.49 135-55160-030-000 Professional Outside Services 63,325.00 63,325.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 576.19 4,705.92 52.288 4,294.08 Subtotal: 338,916.00 338,916.00 21,491.25 240,023.09 70.821 98,892.91 135-60005-030-000 Telephone 27,300.00 27,300.00 1,849.79 11,857.33 43.433 15,442.67 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.37 2,036.80 50.920 1,963.20 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 3,852.21 23.690 12,408.79 135-60025-030-000 Water 2,500.00 2,500.00 58.32- 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 1,579.66 14,557.37 48.525 15,442.63 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,364.10 38,717.32 69.686 16,842.68 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,100.36 52,077.88 92.996 3,922.12 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 12.899 1,393.62 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,828.42 63.807 2,171.58 135-60075-030-000 Meetings 400.00 400.00 31.88 80.50 20.125 319.50 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 3,143.00 41.355 4,457.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 132.60 843.72 17.272 4,041.28 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 220.00 4.889 4,280.00 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 6.000 2,350.00 135-60235-030-000 Security 2,700.00 2,700.00 96.00 3.556 2,604.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 14,237.44 132,958.94 53.289 116,547.06 135-65010-030-000 Uniforms 700.00 700.00 273.73 39.104 426.27 135-65055-030-000 Hardware 7,420.00 7,420.00 497.74 2,006.68 27.044 5,413.32 135-65085-030-000 Office Supplies 7,000.00 7,000.00 263.84 3,586.24 51.232 3,413.76 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,048.66 102.433 48.66- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 81.70 3,267.45 81.686 732.55 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 843.28 11,326.76 45.091 13,793.24 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 8,500.00 37,327.32 287.133 24,327.32- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 266.02 1,990.55 43.273 2,609.45 Subtotal: 17,600.00 17,600.00 8,766.02 39,317.87 223.397 21,717.87- Program number: 1,227,112.00 1,227,112.00 89,872.61 762,152.79 62.109 464,959.21 Department number: Administration 1,227,112.00 1,227,112.00 89,872.61 762,152.79 62.109 464,959.21 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 16,508.38 59,261.93 43.257 77,738.07 135-55055-039-000 Auditing 24,500.00 24,500.00 150.00 25,658.70 104.729 1,158.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 8,683.92 75.869 2,762.08 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 18,670.25 96,572.95 54.639 80,173.05 Program number: 176,746.00 176,746.00 18,670.25 96,572.95 54.639 80,173.05 Department number: Non Departmental 176,746.00 176,746.00 18,670.25 96,572.95 54.639 80,173.05 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 762,674.18 5,982,712.78 59.497 4,072,698.22 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 1,124,410.65- 1,315,517.27- 675.948 1,120,899.27 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:05 06/13/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (120,345.17) (12.03) (120,357.20) GL 1477 05/02/2018 Property Taxes (2.31) (120,359.51) GL 1478 05/03/2018 Property Taxes (13.41) (120,372.92) GL 1479 05/04/2018 Property Taxes (5.52) (120,378.44) GL 1480 05/07/2018 Property Taxes (152.22) (120,530.66) GL 1481 05/09/2018 Property Taxes (38.11) (120,568.77) GL 1482 05/10/2018 Property Taxes (6.32) (120,575.09) GL 1483 05/11/2018 Property Taxes (66.33) (120,641.42) GL 1484 05/14/2018 Property Taxes (89.60) (120,731.02) GL 1485 05/15/2018 Property Taxes (4.78) (120,735.80) GL 1486 05/16/2018 Property Taxes (115.69) (120,851.49) GL 1487 05/17/2018 Property Taxes (43.51) (120,895.00) GL 1488 05/18/2018 Property Taxes (6.06) (120,901.06) GL 1489 05/21/2018 Property Taxes (10.57) (120,911.63) GL 1490 05/22/2018 Property Taxes (6.80) (120,918.43) GL 1491 05/23/2018 Property Taxes (63.97) (120,982.40) GL 1492 05/24/2018 Property Taxes (179.33) (121,161.73) GL 1493 05/25/2018 Property Taxes (9.98) (121,171.71) GL 1495 05/29/2018 Property Taxes (35.84) (121,207.55) GL 1496 05/30/2018 Property Taxes (52.14) (121,259.69) GL 1497 05/31/2018 Property Taxes (90.96) (121,350.65) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,005.48) (121,350.65) ** (120,950.00) Budgeted 400.65 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1477 05/02/2018 Property Taxes (230.75) (78.60) (309.35) GL 1481 05/09/2018 Property Taxes (1.06) (310.41) GL 1491 05/23/2018 Property Taxes 1.10 (309.31) GL 1495 05/29/2018 Property Taxes (34.29) (343.60) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (112.85) (343.60) ** (200.00) Budgeted 143.60 Remaining 172 % Used Account: 135-40015-000-000 Property Taxes/P & I 1476 05/01/2018 Property Taxes (363.05) (1.52) (364.57) GL 1477 05/02/2018 Property Taxes (12.91) (377.48) GL 1478 05/03/2018 Property Taxes (1.47) (378.95) GL 1479 05/04/2018 Property Taxes (1.02) (379.97) GL 1480 05/07/2018 Property Taxes (18.80) (398.77) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (363.05) (7.91) (406.68) GL 1483 05/11/2018 Property Taxes (7.08) (413.76) GL 1484 05/14/2018 Property Taxes (5.60) (419.36) GL 1486 05/16/2018 Property Taxes (12.85) (432.21) GL 1487 05/17/2018 Property Taxes (2.75) (434.96) GL 1490 05/22/2018 Property Taxes (.31) (435.27) GL 1491 05/23/2018 Property Taxes (2.47) (437.74) GL 1492 05/24/2018 Property Taxes (18.29) (456.03) GL 1495 05/29/2018 Property Taxes (24.32) (480.35) GL 1496 05/30/2018 Property Taxes (5.27) (485.62) GL 1497 05/31/2018 Property Taxes (6.70) (492.32) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (129.27) (492.32) ** (200.00) Budgeted 292.32 Remaining 246 % 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 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (2,640,649.08) (498,952.46) (3,139,601.54) UB _______________ Account: 135-47000-000-000 Water Totals: (498,952.46) (3,139,601.54) ** (6,464,019.00) Budgeted (3,324,417.46) Remaining 49 % Used Account: 135-47005-000-000 Sewer 1373 05/11/2018 UB 05/11/2018 Sewer refund UB20180511-20180511 User: (1,683,847.74) 925.70 (1,682,922.04) UB 1380 05/14/2018 UB 05/14/2018 WA adjustments UB20180514-20180514 User: 145.99 (1,682,776.05) UB 1408 05/21/2018 UB 05/21/2018 WA Adjustment UB20180521-20180521 User: 168.29 (1,682,607.76) UB 1418 05/22/2018 UB 05/22/2018 WA adjustment UB20180522-20180522 User: 76.18 (1,682,531.58) UB 1427 05/24/2018 UB 05/24/2018 WA adjustment UB20180524-20180524 User: 85.04 (1,682,446.54) UB 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (261,150.43) (1,943,596.97) UB _______________ Account: 135-47005-000-000 Sewer Totals: (259,749.23) (1,943,596.97) ** (2,978,067.00) Budgeted (1,034,470.03) Remaining 65 % Used Account: 135-47025-000-000 Penalties . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1351 05/09/2018 UB 05/09/2018 Penalty removal UB20180509-20180509 User: (64,594.49) 70.39 (64,524.10) UB 1420 05/22/2018 UB 05/2018 Cal/Assess Penalty UB20180522-20180522 User: (7,625.09) (72,149.19) UB 1447 05/30/2018 UB 05/30/2018 Penalty removal UB20180530-20180530 User: 86.88 (72,062.31) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,467.82) (72,062.31) ** (106,279.00) Budgeted (34,216.69) Remaining 68 % Used Account: 135-47030-000-000 Service Charges 1352 05/09/2018 UB 05/2018 Disconnect Fees UB20180509-20180509 User: (8,450.00) (850.00) (9,300.00) UB 1423 05/22/2018 UB 05/22/2018 NSF checks UB20180522-20180522 User: (25.00) (9,325.00) UB 1424 05/23/2018 UB 05/23/2018 NSF checks UB20180523-20180523 User: (75.00) (9,400.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (950.00) (9,400.00) ** (21,350.00) Budgeted (11,950.00) Remaining 44 % Used Account: 135-47035-000-000 Plumbing Inspections 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (1,500.00) (50.00) (1,550.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (50.00) (1,600.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (50.00) (1,650.00) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 50.00 (1,600.00) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 50.00 (1,550.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (50.00) (1,600.00) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (50.00) (1,650.00) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (50.00) (1,700.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (1,700.00) ** (1,500.00) Budgeted 200.00 Remaining 113 % Used Account: 135-47045-000-000 Sewer Inspections 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (3,700.00) (150.00) (3,850.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (150.00) (4,000.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (150.00) (4,150.00) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 150.00 (4,000.00) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 150.00 (3,850.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (150.00) (4,000.00) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (150.00) (4,150.00) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (150.00) (4,300.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (4,300.00) ** (4,500.00) Budgeted (200.00) Remaining 96 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (16,310.40) (10,885.60) (27,196.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (10,885.60) (27,196.00) ** (60,000.00) Budgeted (32,804.00) Remaining 45 % Used Account: 135-49010-000-000 Interest Income 1538 05/31/2018 Bank Interest- May (25,571.00) (151.80) (25,722.80) GL 1538 05/31/2018 Bank Interest- May (331.88) (26,054.68) GL 1538 05/31/2018 Bank Interest- May (4,591.09) (30,645.77) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (5,074.77) (30,645.77) ** (12,000.00) Budgeted 18,645.77 Remaining 255 % Used Account: 135-49016-000-000 Cell Tower Revenue (7,762.20) .00 (7,762.20) _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (7,762.20) ** (10,926.00) Budgeted (3,163.80) Remaining 71 % Used Account: 135-49018-000-000 Building Rent Income 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (4,083.31) (583.33) (4,666.64) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (15,400.00) .00 (15,400.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,400.00) ** (2,000.00) Budgeted 13,400.00 Remaining 770 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (9,434.76) (343.00) (9,777.76) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (343.00) (10,120.76) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (343.00) (10,463.76) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 343.00 (10,120.76) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 343.00 (9,777.76) Ashton Woods Homes CR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (9,434.76) (343.00) (10,120.76) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (343.00) (10,463.76) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (343.00) (10,806.76) Ashton Wood Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,372.00) (10,806.76) ** (18,179.00) Budgeted (7,372.24) Remaining 59 % Used Account: 135-49141-000-000 Interfund Transfer In 1519 05/31/2018 Texpool Transfers May (796,145.08) (1,053,984.38) (1,850,129.46) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (1,053,984.38) (1,850,129.46) ** .00 Budgeted 1,850,129.46 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1331 05/01/2018 JSB NSA Inv# 1639 *Reissued AR 20180501-20180501 User: (12,758.19) (45,000.00) (57,758.19) AR 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (800.00) (58,558.19) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 ASheville Lane (800.00) (59,358.19) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 ASheville Lane 800.00 (58,558.19) Ashton Woods Homes CR 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (217.64) (58,775.83) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (46,017.64) (58,775.83) ** (5,000.00) Budgeted 53,775.83 Remaining 1.176 % 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: ----------------------------------- (7,298,230.05) ** (1,887,084.83) Monthly Total (10,250,029.00) Budgeted (2,951,798.95) Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 118,432.50 9,850.28 128,282.78 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 9,899.22 138,182.00 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,749.50 138,182.00 ** 274,279.00 Budgeted 136,097.00 Remaining 50 % Used Account: 135-50010-010-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 5,510.70 654.20 6,164.90 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 353.48 6,518.38 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,007.68 6,518.38 ** 20,000.00 Budgeted 13,481.62 Remaining 33 % 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 1388 05/18/2018 MUD PR 05/18/18 Certification 1,250.00 150.00 1,400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 1,400.00 ** 3,300.00 Budgeted 1,900.00 Remaining 42 % Used Account: 135-50020-010-000 Retirement 1290 05/04/2018 MUD PR 05.04.18 Retirement 13,296.50 971.67 14,268.17 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 962.24 15,230.41 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,933.91 15,230.41 ** 27,843.00 Budgeted 12,612.59 Remaining 55 % Used Account: 135-50026-010-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 18,055.83 1,474.40 19,530.23 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 1,474.40 21,004.63 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 21,004.63 ** 52,196.00 Budgeted 31,191.37 Remaining 40 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 1,521.04 106.85 1,627.89 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 106.80 1,734.69 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,734.69 ** 5,182.00 Budgeted 3,447.31 Remaining 33 % Used Account: 135-50028-010-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 280.23 17.98 298.21 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 17.94 316.15 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 316.15 ** 994.00 Budgeted 677.85 Remaining 32 % Used Account: 135-50029-010-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 1,674.71 110.60 1,785.31 Humana Inc 4204 AP 1458 05/31/2018 May a/p Flex admin fee 18.00 1,803.31 BenefitMall 4226 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 128.60 1,803.31 ** 2,982.00 Budgeted 1,178.69 Remaining 60 % Used Account: 135-50030-010-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 7,903.81 644.87 8,548.68 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 664.51 9,213.19 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,309.38 9,213.19 ** 18,662.00 Budgeted 9,448.81 Remaining 49 % Used Account: 135-50035-010-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 1,848.45 150.84 1,999.29 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 155.40 2,154.69 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 306.24 2,154.69 ** 4,365.00 Budgeted 2,210.31 Remaining 49 % Used Account: 135-50040-010-000 Unemployment Taxes 1290 05/04/2018 MUD PR 05.04.18 Unemployment Taxes 808.42 10.26 818.68 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-010-000 Unemployment Taxes Totals: 10.26 818.68 ** 1,080.00 Budgeted 261.32 Remaining 76 % Used Account: 135-50045-010-000 Workman's Compensation 239 05/01/2018 Insurance/Wrk Comp Exp May 6,299.44 899.92 7,199.36 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 7,199.36 ** 11,854.00 Budgeted 4,654.64 Remaining 61 % 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 1413 05/21/2018 May A/P Chlorinator refill 48,666.04 666.88 49,332.92 SCOOP 4218 AP 1413 05/21/2018 May A/P Meter SPuds 240.30 49,573.22 Core & Main LP 4198 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 AMAZON.COM 11.09 49,584.31 AMAZON.COM PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ROANOKE AUTO SUPPLY LT 22.99 49,607.30 ROANOKE AUTO SUPPLY LT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 15.96 49,623.26 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 64.53 49,687.79 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 31.22 49,719.01 THE HOME DEPOT #6581 PC 1458 05/31/2018 May a/p Meter spuds 450.60 50,169.61 Core & Main LP 4231 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-010-000 Maintenance & Repairs Totals: 1,503.57 50,169.61 ** 100,000.00 Budgeted 49,830.39 Remaining 50 % Used 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DENTON COUNTY, TX SOUT 3,853.07 1.00 3,854.07 DENTON COUNTY, TX SOUT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DENTON COUNTY, TX SOUT 8.25 3,862.32 DENTON COUNTY, TX SOUT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KWIK KAR LUBE & TUNE O 25.50 3,887.82 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 34.75 3,887.82 ** 4,000.00 Budgeted 112.18 Remaining 97 % 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 1413 05/21/2018 May A/P Bio monitoring 3,605.16 1,080.00 4,685.16 HUTHER AND ASSOCIATES,INC 4206 AP 1413 05/21/2018 May A/P Bio monitoring 1,080.00 5,765.16 HUTHER AND ASSOCIATES,INC 4206 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 2,160.00 5,765.16 ** 5,500.00 Budgeted (265.16) Remaining 105 % Used Account: 135-60010-010-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 2,122.44 370.18 2,492.62 VERIZON WIRELESS 4193 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.18 2,492.62 ** 4,700.00 Budgeted 2,207.38 Remaining 53 % Used Account: 135-60020-010-000 Electricity . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1413 05/21/2018 May A/P Electricity 4/10-5/19 73,159.82 9,001.73 82,161.55 HUDSON ENERGY SERVICES, LLC 4205 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,001.73 82,161.55 ** 175,356.00 Budgeted 93,194.45 Remaining 47 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 ** 1,000.00 Budgeted 233.00 Remaining 77 % 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 360 WATER INC 1,395.78 30.00 1,425.78 360 WATER INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TCEQ EPAYMENT 111.00 1,536.78 TCEQ EPAYMENT PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 141.00 1,536.78 ** 2,785.00 Budgeted 1,248.22 Remaining 55 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 17,410.32 .00 17,410.32 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 17,410.32 ** 55,176.00 Budgeted 37,765.68 Remaining 32 % Used Account: 135-60150-010-000 Wholesale Water 1458 05/31/2018 May a/p Wholesale water 962,751.81 58,261.27 1,021,013.08 CITY OF FORT WORTH 4230 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 58,261.27 1,021,013.08 ** 2,823,170.00 Budgeted 1,802,156.92 Remaining 36 % 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 502.70 .00 502.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 502.70 ** 3,000.00 Budgeted 2,497.30 Remaining 17 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1503 05/31/2018 May A/P Mowing may 4,500.00 1,500.00 6,000.00 WATTS ELLISON LLC 4274 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 6,000.00 ** 14,750.00 Budgeted 8,750.00 Remaining 41 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1519 05/31/2018 Texpool Transfers May 176,962.17 25,280.31 202,242.48 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 202,242.48 ** 278,084.00 Budgeted 75,841.52 Remaining 73 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1519 05/31/2018 Texpool Transfers May 28,581.00 4,083.00 32,664.00 GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 (15.00) 32,649.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,068.00 32,649.00 ** 48,996.00 Budgeted 16,347.00 Remaining 67 % Used Account: 135-60334-010-000 Interfund Transfer Out 1,053,935.08 .00 1,053,935.08 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 1,053,935.08 ** 200,000.00 Budgeted (853,935.08) Remaining 527 % 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 1450 05/30/2018 May A/P Fuel 5,779.30 1,186.68 6,965.98 US Bank Voyager Fleet Systems 4269 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,186.68 6,965.98 ** 15,000.00 Budgeted 8,034.02 Remaining 46 % Used Account: 135-65010-010-000 Uniforms 1,249.14 .00 1,249.14 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,249.14 ** 4,488.00 Budgeted 3,238.86 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1458 05/31/2018 May a/p chlorine 10,731.77 884.96 11,616.73 DPC INDUSTRIES, INC 4237 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1503 05/31/2018 May A/P Testing supplies 10,731.77 342.11 11,958.84 HACH COMPANY 4243 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,227.07 11,958.84 ** 20,000.00 Budgeted 8,041.16 Remaining 60 % 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KELLER TROPHY & AWAR 192.00 391.00 583.00 KELLER TROPHY & AWAR PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 391.00 583.00 ** 1,000.00 Budgeted 417.00 Remaining 58 % Used Account: 135-65050-010-000 Meter Expense 1413 05/21/2018 May A/P Meters 16,091.00 5,011.00 21,102.00 ATLAS UTILITY SUPPLY CO. 4196 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 5,011.00 21,102.00 ** 50,000.00 Budgeted 28,898.00 Remaining 42 % 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 1413 05/21/2018 May A/P 16" water line to town center 365,542.05 576.28 366,118.33 Halff Associates, INC 4202 AP 1458 05/31/2018 May a/p Indian Creek & Phoenix Drive 153,420.01 519,538.34 Quality Excavation, LTD 4260 AP 1503 05/31/2018 May A/P Phoenix Drive 6,000.00 525,538.34 TEAGUE, NALL & PERKINS,INC 4268 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 159,996.29 525,538.34 ** 810,012.00 Budgeted 284,473.66 Remaining 65 % Used Account: 135-69008-010-000 Short Term Debt-Principal . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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 1,200.08 .00 1,200.08 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,200.08 ** 2,000.00 Budgeted 799.92 Remaining 60 % Used Department 10 Totals: ----------------------------------- 3,495,140.99 ** 298,826.71 Monthly Total 5,657,433.00 Budgeted 2,162,292.01 Remaining 62 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 210,111.04 12,604.84 222,715.88 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 12,602.81 235,318.69 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,207.65 235,318.69 ** 410,866.00 Budgeted 175,547.31 Remaining 57 % Used Account: 135-50010-020-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 19,634.62 2,244.93 21,879.55 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 1,721.26 23,600.81 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,966.19 23,600.81 ** 30,000.00 Budgeted 6,399.19 Remaining 79 % 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 1388 05/18/2018 MUD PR 05/18/18 Certification 4,936.00 700.00 5,636.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 5,636.00 ** 8,400.00 Budgeted 2,764.00 Remaining 67 % Used Account: 135-50020-020-000 Retirement 1290 05/04/2018 MUD PR 05.04.18 Retirement 23,848.14 1,373.59 25,221.73 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 1,389.73 26,611.46 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,763.32 26,611.46 ** 42,243.00 Budgeted 15,631.54 Remaining 63 % Used Account: 135-50026-020-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 37,974.64 2,759.36 40,734.00 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 2,759.33 43,493.33 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 43,493.33 ** 62,175.00 Budgeted 18,681.67 Remaining 70 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 2,832.29 185.96 3,018.25 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 185.93 3,204.18 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 3,204.18 ** 5,271.00 Budgeted 2,066.82 Remaining 61 % Used Account: 135-50028-020-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 508.36 29.46 537.82 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 29.44 567.26 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 567.26 ** 1,114.00 Budgeted 546.74 Remaining 51 % Used Account: 135-50029-020-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 2,989.82 136.36 3,126.18 Humana Inc 4204 AP 1458 05/31/2018 May a/p Flex admin fee 36.00 3,162.18 BenefitMall 4226 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 172.36 3,162.18 ** 4,281.00 Budgeted 1,118.82 Remaining 74 % Used Account: 135-50030-020-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 13,976.06 843.09 14,819.15 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 831.02 15,650.17 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,674.11 15,650.17 ** 28,314.00 Budgeted 12,663.83 Remaining 55 % Used Account: 135-50035-020-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 3,268.59 197.18 3,465.77 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 194.34 3,660.11 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 391.52 3,660.11 ** 6,622.00 Budgeted 2,961.89 Remaining 55 % Used Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 239 05/01/2018 Insurance/Wrk Comp Exp May 9,436.00 1,348.00 10,784.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 10,784.00 ** 17,990.00 Budgeted 7,206.00 Remaining 60 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1367 05/10/2018 May A/P Post accident testing 63.00 63.00 CARENOW CORPORATE 4167 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 63.00 ** 300.00 Budgeted 237.00 Remaining 21 % 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 2,145.00 .00 2,145.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 2,145.00 ** 20,550.00 Budgeted 18,405.00 Remaining 10 % Used Account: 135-55080-020-000 Maintenance & Repairs 1413 05/21/2018 May A/P Grit bags' 36,495.26 1,300.00 37,795.26 Huber Technology Inc 4203 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 46.29 37,841.55 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ROANOKE AUTO SUPPLY LT 37.72 37,879.27 ROANOKE AUTO SUPPLY LT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 48.25 37,927.52 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 6.70 37,934.22 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 FILTER ELEMENT STORE 173.65 38,107.87 FILTER ELEMENT STORE PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 32.56 38,140.43 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 44.95 38,185.38 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TRACTOR SUPPLY COMPANY 159.99 38,345.37 TRACTOR SUPPLY COMPANY PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1458 05/31/2018 May a/p VFD and bar screens 36,495.26 490.00 38,835.37 DHS AUTOMATION, INC 4236 AP 1458 05/31/2018 May a/p VFD and bar screens 5,416.00 44,251.37 DHS AUTOMATION, INC 4236 AP 1503 05/31/2018 May A/P Connect pump @ LS #9Dumpster s 170.00 44,421.37 Walker Industrial LLC 4273 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,926.11 44,421.37 ** 86,100.00 Budgeted 41,678.63 Remaining 52 % 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 6,353.60 .00 6,353.60 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 6,353.60 ** 8,000.00 Budgeted 1,646.40 Remaining 79 % 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 1413 05/21/2018 May A/P Dumpster services 50,181.61 888.10 51,069.71 L.H. CHANEY MATERIALS, INC. 4211 AP 1413 05/21/2018 May A/P Dumpster servies 2,035.18 53,104.89 L.H. CHANEY MATERIALS, INC. 4211 AP 1458 05/31/2018 May a/p Sludge haul off 1,972.23 55,077.12 L.H. CHANEY MATERIALS, INC. 4250 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,895.51 55,077.12 ** 60,000.00 Budgeted 4,922.88 Remaining 92 % Used Account: 135-55135-020-000 Lab Analysis 1333 05/07/2018 May A/P CIP soultion 20,529.42 674.60 21,204.02 Valley Solvent Company, INC 4192 AP 1362 05/10/2018 May A/P Lab Services 246.00 21,450.02 OXIDOR LABORATORIES LLC 4184 AP 1413 05/21/2018 May A/P Lab results 176.00 21,626.02 OXIDOR LABORATORIES LLC 4217 AP 1413 05/21/2018 May A/P Effluent testing 176.00 21,802.02 OXIDOR LABORATORIES LLC 4217 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1458 05/31/2018 May a/p Effluent testing 20,529.42 246.00 22,048.02 OXIDOR LABORATORIES LLC 4258 AP 1458 05/31/2018 May a/p Effluent testing 246.00 22,294.02 OXIDOR LABORATORIES LLC 4258 AP 1503 05/31/2018 May A/P lab testing 246.00 22,540.02 OXIDOR LABORATORIES LLC 4258 AP 1503 05/31/2018 May A/P Lab testing 176.00 22,716.02 OXIDOR LABORATORIES LLC 4258 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,186.60 22,716.02 ** 30,000.00 Budgeted 7,283.98 Remaining 76 % Used Account: 135-60010-020-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 2,865.72 527.28 3,393.00 VERIZON WIRELESS 4193 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 527.28 3,393.00 ** 4,700.00 Budgeted 1,307.00 Remaining 72 % Used Account: 135-60020-020-000 Electricity 1413 05/21/2018 May A/P Electricity 4/10-5/19 99,534.05 10,896.78 110,430.83 HUDSON ENERGY SERVICES, LLC 4205 AP 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (157.45) 110,273.38 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,739.33 110,273.38 ** 266,709.00 Budgeted 156,435.62 Remaining 41 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 PAYPAL *TEXASWATERW 222.00 325.00 547.00 PAYPAL *TEXASWATERW PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TCEQ EPAYMENT 111.00 658.00 TCEQ EPAYMENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 436.00 658.00 ** 5,677.00 Budgeted 5,019.00 Remaining 12 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-60090-020-000 Safety Program 351.72 .00 351.72 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 90.46 .00 90.46 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 90.46 ** 1,635.00 Budgeted 1,544.54 Remaining 6 % 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 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 19.97 19.97 THE HOME DEPOT #6581 PC _______________ Account: 135-60280-020-000 Property Maintenance Totals: 19.97 19.97 ** 4,000.00 Budgeted 3,980.03 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1503 05/31/2018 May A/P Mowing may 3,540.00 1,060.00 4,600.00 WATTS ELLISON LLC 4274 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,060.00 4,600.00 ** 11,600.00 Budgeted 7,000.00 Remaining 40 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1519 05/31/2018 Texpool Transfers May 77,663.67 11,094.81 88,758.48 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 88,758.48 ** 122,043.00 Budgeted 33,284.52 Remaining 73 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1519 05/31/2018 Texpool Transfers May 381,015.04 54,430.72 435,445.76 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 435,445.76 ** 598,738.00 Budgeted 163,292.24 Remaining 73 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1519 05/31/2018 Texpool Transfers May 71,946.00 10,278.00 82,224.00 GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 (30.00) 82,194.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,248.00 82,194.00 ** 123,336.00 Budgeted 41,142.00 Remaining 67 % Used Account: 135-60334-020-000 Interfund Transfer Out 1519 05/31/2018 Texpool Transfers May 201,031.99 201,031.99 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 201,031.99 201,031.99 ** 200,000.00 Budgeted (1,031.99) Remaining 101 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,762.00 .00 1,762.00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 1450 05/30/2018 May A/P Fuel 5,340.19 925.48 6,265.67 US Bank Voyager Fleet Systems 4269 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 925.48 6,265.67 ** 12,500.00 Budgeted 6,234.33 Remaining 50 % 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 1362 05/10/2018 May A/P Polymer 5,281.23 2,760.00 8,041.23 POLYDYNE, INC 4185 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,760.00 8,041.23 ** 27,500.00 Budgeted 19,458.77 Remaining 29 % Used Account: 135-65035-020-000 Small Tools 1,149.94 .00 1,149.94 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 1,149.94 ** 1,000.00 Budgeted (149.94) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KELLER TROPHY & AWAR 750.97 391.00 1,141.97 KELLER TROPHY & AWAR PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 15.53 1,157.50 THE HOME DEPOT #6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 406.53 1,157.50 ** 750.00 Budgeted (407.50) Remaining 154 % Used Account: 135-65045-020-000 Lab Supplies . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1413 05/21/2018 May A/P Latex gloves 10,700.58 162.00 10,862.58 LOU'S GLOVES INCORPORATED 4213 AP 1413 05/21/2018 May A/P E coli supplies 387.32 11,249.90 IDEXX DISTRIBUTION, INC 4207 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 USA BLUE BOOK 90.61 11,340.51 USA BLUE BOOK PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 BED BATH & BEYOND #341 19.99 11,360.50 BED BATH & BEYOND #341 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 BINDER INC. 2,123.31 13,483.81 BINDER INC. PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,783.23 13,483.81 ** 14,000.00 Budgeted 516.19 Remaining 96 % Used Account: 135-69005-020-000 Capital Outlays 1413 05/21/2018 May A/P Legal-WWTP 89,960.61 1,190.00 91,150.61 Dubois Bryant Campbell LLP 4200 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,190.00 91,150.61 ** 547,327.00 Budgeted 456,176.39 Remaining 17 % 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 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,623,206.41 ** 354,897.19 Monthly Total 2,981,140.00 Budgeted 1,357,933.59 Remaining 54 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 239 05/01/2018 Insurance/Wrk Comp Exp May 16.94 2.42 19.36 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 19.36 ** 30.00 Budgeted 10.64 Remaining 65 % 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 1413 05/21/2018 May A/P AWBD-Greg Wilson 810.00 405.00 1,215.00 AWBD 4197 AP _______________ Account: 135-60075-026-000 Meetings Totals: 405.00 1,215.00 ** 1,200.00 Budgeted (15.00) Remaining 101 % Used Account: 135-60080-026-000 Schools & Training 1,540.00 .00 1,540.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,540.00 ** 4,000.00 Budgeted 2,460.00 Remaining 39 % 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 30 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,255.28 .00 1,255.28 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,255.28 ** 2,000.00 Budgeted 744.72 Remaining 63 % Used Department 26 Totals: ----------------------------------- 5,639.64 ** 407.42 Monthly Total 12,980.00 Budgeted 7,340.36 Remaining 43 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 214,185.54 21,113.58 235,299.12 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 12,860.29 248,159.41 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,973.87 248,159.41 ** 432,863.00 Budgeted 184,703.59 Remaining 57 % Used Account: 135-50010-030-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 467.06 61.34 528.40 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 28.52 556.92 PR _______________ Account: 135-50010-030-000 Overtime Totals: 89.86 556.92 ** 2,000.00 Budgeted 1,443.08 Remaining 28 % 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 1290 05/04/2018 MUD PR 05.04.18 Retirement 22,490.45 1,958.67 24,449.12 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 1,192.22 25,641.34 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,150.89 25,641.34 ** 40,553.00 Budgeted 14,911.66 Remaining 63 % Used Account: 135-50026-030-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 27,338.45 2,072.63 29,411.08 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 2,072.61 31,483.69 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 31,483.69 ** 63,485.00 Budgeted 32,001.31 Remaining 50 % Used Account: 135-50027-030-000 Dental Insurance 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 2,012.44 129.78 2,142.22 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 129.74 2,271.96 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 2,271.96 ** 5,502.00 Budgeted 3,230.04 Remaining 41 % Used Account: 135-50028-030-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 383.92 21.28 405.20 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 21.23 426.43 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 426.43 ** 1,173.00 Budgeted 746.57 Remaining 36 % Used Account: 135-50029-030-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 2,454.75 145.04 2,599.79 Humana Inc 4204 AP 1257 05/31/2018 Clear Insurance Liab @ 05/2018 77.05 2,676.84 GL 1458 05/31/2018 May a/p Flex admin fee 18.00 2,694.84 BenefitMall 4226 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 240.09 2,694.84 ** 5,059.00 Budgeted 2,364.16 Remaining 53 % Used Account: 135-50030-030-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 12,990.91 1,275.09 14,266.00 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 758.46 15,024.46 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,033.55 15,024.46 ** 27,181.00 Budgeted 12,156.54 Remaining 55 % Used Account: 135-50035-030-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 3,038.19 298.20 3,336.39 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 177.39 3,513.78 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 475.59 3,513.78 ** 6,357.00 Budgeted 2,843.22 Remaining 55 % Used Account: 135-50040-030-000 Unemployment Taxes 983.77 .00 983.77 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 983.77 ** 1,260.00 Budgeted 276.23 Remaining 78 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-030-000 Workman's Compensation 239 05/01/2018 Insurance/Wrk Comp Exp May 864.50 123.50 988.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 988.00 ** 1,529.00 Budgeted 541.00 Remaining 65 % 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 3,109.08 .00 3,109.08 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 3,109.08 ** 4,960.00 Budgeted 1,850.92 Remaining 63 % Used Account: 135-55030-030-000 Software & Support 1295 05/02/2018 May A/P Internet 53,406.90 903.72 54,310.62 Charter Communications 4152 AP 1413 05/21/2018 May A/P Email, MS Office 168.00 54,478.62 M3 Networks 4214 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 FS *DIGITALWAVE 30.25 54,508.87 FS *DIGITALWAVE PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DNH*GODADDY.COM 15.17 54,524.04 DNH*GODADDY.COM PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ADOBE *CREATIVE CLOUD (239.92) 54,284.12 ADOBE *CREATIVE CLOUD PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 109.63 54,393.75 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 25.72 54,419.47 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 72.44 54,491.91 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 126.18 54,618.09 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ADOBE SYSTEMS INC 16.23 54,634.32 ADOBE SYSTEMS INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 CONWAY COMPANY CPAS 595.00 55,229.32 CONWAY COMPANY CPAS PC 1458 05/31/2018 May a/p Peak agenda software 3,300.00 58,529.32 GRANICUS, INC 4242 AP 1509 05/31/2018 May A/P Internet 903.72 59,433.04 Charter Communications 4229 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 6,026.14 59,433.04 ** 78,391.00 Budgeted 18,957.96 Remaining 76 % Used Account: 135-55070-030-000 Independent Labor 1503 05/31/2018 May A/P May GM 87,822.59 13,050.00 100,872.59 Carman Consulting LLC. 4228 AP 1503 05/31/2018 May A/P May GM 213.64 101,086.23 Carman Consulting LLC. 4228 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1503 05/31/2018 May A/P Staff account interviews 87,822.59 741.70 101,827.93 DRG ENTERPRISES 4239 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,005.34 101,827.93 ** 154,000.00 Budgeted 52,172.07 Remaining 66 % Used Account: 135-55080-030-000 Maintenance & Repairs 1458 05/31/2018 May a/p Office and maintenance supplie 5,146.17 14.52 5,160.69 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 14.52 5,160.69 ** 14,000.00 Budgeted 8,839.31 Remaining 37 % Used Account: 135-55085-030-000 Generator Maint. and Repair 3,955.00 .00 3,955.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 3,955.00 ** 10,000.00 Budgeted 6,045.00 Remaining 40 % Used Account: 135-55120-030-000 Cleaning Services 1413 05/21/2018 May A/P Janitorial services 4,831.45 869.06 5,700.51 MEMBER'S BUILDING MAINTENANCE 4215 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 5,700.51 ** 10,000.00 Budgeted 4,299.49 Remaining 57 % Used Account: 135-55160-030-000 Professional Outside Services 59,240.00 .00 59,240.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .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 1503 05/31/2018 May A/P May mailings 4,129.73 576.19 4,705.92 DATAPROSE LLC 4233 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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: 576.19 4,705.92 ** 9,000.00 Budgeted 4,294.08 Remaining 52 % Used Account: 135-60005-030-000 Telephone 1413 05/21/2018 May A/P Answering service 10,007.54 194.75 10,202.29 KEYSTONE PARK SECRETARIAL 4210 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 57.23 10,259.52 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 455.73 10,715.25 ATT*BUS PHONE PMT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 856.06 11,571.31 ATT*BUS PHONE PMT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 RINGCENTRAL, INC 13.95 11,585.26 RINGCENTRAL, INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 452.07 12,037.33 ATT*BUS PHONE PMT PC 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (180.00) 11,857.33 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,849.79 11,857.33 ** 27,300.00 Budgeted 15,442.67 Remaining 43 % Used Account: 135-60010-030-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 1,799.43 87.37 1,886.80 VERIZON WIRELESS 4193 AP 1388 05/18/2018 MUD PR 05/18/18 Communications/Mobiles 150.00 2,036.80 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.37 2,036.80 ** 4,000.00 Budgeted 1,963.20 Remaining 51 % Used Account: 135-60020-030-000 Electricity/Gas 3,852.21 .00 3,852.21 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 3,852.21 ** 16,261.00 Budgeted 12,408.79 Remaining 24 % Used Account: 135-60025-030-000 Water 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: 397.44 (58.32) 339.12 AR _______________ Account: 135-60025-030-000 Water Totals: (58.32) 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 1503 05/31/2018 May A/P May mailings 12,977.71 1,579.66 14,557.37 DATAPROSE LLC 4233 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,579.66 14,557.37 ** 30,000.00 Budgeted 15,442.63 Remaining 49 % Used Account: 135-60040-030-000 Service Charges & Fees 1296 05/04/2018 Child Support Fee 34,353.22 1.50 34,354.72 GL 1389 05/18/2018 Child Support Fee 1.50 34,356.22 GL 1443 05/31/2018 Pace Credit Card Fees 4,219.91 38,576.13 GL 1443 05/31/2018 Pace Credit Card Fees 91.19 38,667.32 GL 1503 05/31/2018 May A/P Direct send fees 50.00 38,717.32 Fiserv Solutions, LLC 4240 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,364.10 38,717.32 ** 55,560.00 Budgeted 16,842.68 Remaining 70 % 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 239 05/01/2018 Insurance/Wrk Comp Exp May 45,977.52 6,100.36 52,077.88 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 52,077.88 ** 56,000.00 Budgeted 3,922.12 Remaining 93 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 206.38 .00 206.38 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 206.38 ** 1,600.00 Budgeted 1,393.62 Remaining 13 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 3,828.42 .00 3,828.42 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,828.42 ** 6,000.00 Budgeted 2,171.58 Remaining 64 % Used Account: 135-60075-030-000 Meetings 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 PANERA BREAD #601996 48.62 31.88 80.50 PANERA BREAD #601996 PC _______________ Account: 135-60075-030-000 Meetings Totals: 31.88 80.50 ** 400.00 Budgeted 319.50 Remaining 20 % 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 3,143.00 .00 3,143.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,143.00 ** 7,600.00 Budgeted 4,457.00 Remaining 41 % Used Account: 135-60100-030-000 Travel & per diem 1290 05/04/2018 MUD PR 05.04.18 Travel & per diem 711.12 52.16 763.28 PR 1388 05/18/2018 MUD PR 05/18/18 Travel & per diem 80.44 843.72 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 132.60 843.72 ** 4,885.00 Budgeted 4,041.28 Remaining 17 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 220.00 .00 220.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising 150.00 .00 150.00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 150.00 ** 2,500.00 Budgeted 2,350.00 Remaining 6 % Used Account: 135-60235-030-000 Security 96.00 .00 96.00 _______________ Account: 135-60235-030-000 Security Totals: .00 96.00 ** 2,700.00 Budgeted 2,604.00 Remaining 4 % 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 273.73 .00 273.73 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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: .00 273.73 ** 700.00 Budgeted 426.27 Remaining 39 % Used Account: 135-65055-030-000 Hardware 1333 05/07/2018 May A/P WWTP Conference room 1,508.94 497.74 2,006.68 M3 Networks 4181 AP _______________ Account: 135-65055-030-000 Hardware Totals: 497.74 2,006.68 ** 7,420.00 Budgeted 5,413.32 Remaining 27 % Used Account: 135-65085-030-000 Office Supplies 1413 05/21/2018 May A/P office supplies 3,322.40 10.78 3,333.18 OFFICE DEPOT, INC 4216 AP 1413 05/21/2018 May A/P Office supplies 75.74 3,408.92 OFFICE DEPOT, INC 4216 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 AMER ASSOC NOTARIESWE 25.90 3,434.82 AMER ASSOC NOTARIESWE PC 1458 05/31/2018 May a/p Office supplies 115.19 3,550.01 OFFICE DEPOT, INC 4257 AP 1458 05/31/2018 May a/p Office and maintenance supplie 36.23 3,586.24 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 263.84 3,586.24 ** 7,000.00 Budgeted 3,413.76 Remaining 51 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,048.66 .00 2,048.66 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,048.66 ** 2,000.00 Budgeted (48.66) Remaining 102 % Used Account: 135-65095-030-000 Maintenance Supplies 1503 05/31/2018 May A/P 3,185.75 81.70 3,267.45 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 81.70 3,267.45 ** 4,000.00 Budgeted 732.55 Remaining 82 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-030-000 Capital Outlays 1510 05/31/2018 May A/P Comp salary survey 28,827.32 8,500.00 37,327.32 Segal Waters Consulting 4261 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 8,500.00 37,327.32 ** 13,000.00 Budgeted (24,327.32) Remaining 287 % Used Account: 135-69170-030-000 Copier Lease Installments 1413 05/21/2018 May A/P Copier Lease 1,724.53 165.00 1,889.53 EVERBANK COMMERCIAL FINANCE 4201 AP 1458 05/31/2018 May a/p Copiers/Lease 101.02 1,990.55 KYOCERA DOCUMENT SOLUTIONS 4249 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 266.02 1,990.55 ** 4,600.00 Budgeted 2,609.45 Remaining 43 % Used Department 30 Totals: ----------------------------------- 762,152.79 ** 89,872.61 Monthly Total 1,227,112.00 Budgeted 464,959.21 Remaining 62 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 1413 05/21/2018 May A/P Legal-Southlake easement 42,753.55 16,508.38 59,261.93 WHITAKER CHALK SWINDLE 4221 AP _______________ Account: 135-55045-039-000 Legal Totals: 16,508.38 59,261.93 ** 137,000.00 Budgeted 77,738.07 Remaining 43 % Used Account: 135-55055-039-000 Auditing 1503 05/31/2018 May A/P JE advice audit 25,508.70 150.00 25,658.70 LAFOLLETT & ABBOTT PLLC 4251 AP _______________ Account: 135-55055-039-000 Auditing Totals: 150.00 25,658.70 ** 24,500.00 Budgeted (1,158.70) Remaining 105 % Used Account: 135-55060-039-000 Appraisal 1503 05/31/2018 May A/P Appraisal 3rd qtr DCAD budget 6,672.05 2,011.87 8,683.92 DENTON CENTRAL APPRAISAL DISTR 4235 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 8,683.92 ** 11,446.00 Budgeted 2,762.08 Remaining 76 % 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: ----------------------------------- 96,572.95 ** 18,670.25 Monthly Total 176,746.00 Budgeted 80,173.05 Remaining 55 % Used Fund 135 Totals: ----------------------------------- (1,315,517.27) (1,124,410.65) Monthly Total (194,618.00) Budgeted 1,120,899.27 Remaining 676 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 MAY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK 155 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 155 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 803,631 TOTAL LIABILITIES 803,631 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,796,055) TOTAL FUND BALANCE (803,476) TOTAL LIABILITIES AND FUND BALANCE 155 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 154.89- 9,348.16- 9,348.16 Subtotal: 154.89- 9,348.16- 9,348.16 Program number: 154.89- 9,348.16- 9,348.16 Department number: Revenues 154.89- 9,348.16- 9,348.16 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49141-020-000 Interfund Transfers In Gen 201,031.99- 201,031.99- 201,031.99 Subtotal: 201,031.99- 201,031.99- 201,031.99 Program number: 201,031.99- 201,031.99- 201,031.99 Department number: Wastewater 201,031.99- 201,031.99- 201,031.99 Revenues Subtotal ----------- 201,186.88- 210,380.15- 210,380.15 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 406,950.82 2,006,435.35 2,006,435.35- Subtotal: 406,950.82 2,006,435.35 2,006,435.35- Program number: 406,950.82 2,006,435.35 2,006,435.35- Department number: Wastewater 406,950.82 2,006,435.35 2,006,435.35- Expenditures Subtotal ----------- 406,950.82 2,006,435.35 2,006,435.35- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 205,763.94 1,796,055.20 1,796,055.20- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (9,193.27) (154.89) (9,348.16) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (154.89) (9,348.16) ** .00 Budgeted 9,348.16 Remaining 0 % Used Department Totals: ----------------------------------- (9,348.16) ** (154.89) Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/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-49141-020-000 Interfund Transfers In Gen 1519 05/31/2018 Texpool Transfers May (201,031.99) (201,031.99) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (201,031.99) (201,031.99) ** .00 Budgeted 201,031.99 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 1366 05/10/2018 May A/P WWTP Improvement 1,599,484.53 287,017.98 1,886,502.51 WEBBER-CADAGUA PARTNERS 4194 AP 1524 05/31/2018 MAY A/P WWTP Improvements 119,932.84 2,006,435.35 WEBBER-CADAGUA PARTNERS AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 406,950.82 2,006,435.35 ** .00 Budgeted (2,006,435.35) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,805,403.36 ** 205,918.83 Monthly Total .00 Budgeted (1,805,403.36) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,796,055.20 205,763.94 Monthly Total .00 Budgeted (1,796,055.20) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET MAY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK 1,485 CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 750,870 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES (3,487,869) TOTAL FUND BALANCE 737,712 TOTAL LIABILITIES AND FUND BALANCE 750,870 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:05 06/13/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 1,484.87- 1,534.17- 1,534.17 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08 Subtotal: 1,484.87- 1,055,469.25- 1,055,469.25 Program number: 1,484.87- 1,055,469.25- 1,055,469.25 Department number: Revenues 1,484.87- 1,055,469.25- 1,055,469.25 Revenues Subtotal ----------- 1,484.87- 1,055,469.25- 1,055,469.25 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:05 06/13/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 1,053,984.38 1,850,129.46 1,850,129.46- Subtotal: 1,053,984.38 1,850,129.46 1,850,129.46- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68- Program number: 1,053,984.38 4,543,338.14 4,543,338.14- Department number: Water 1,053,984.38 4,543,338.14 4,543,338.14- Expenditures Subtotal ----------- 1,053,984.38 4,543,338.14 4,543,338.14- Fund number: 519 2016 Rev Bond Const-SWIFT 1,052,499.51 3,487,868.89 3,487,868.89- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 5/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-49010-000-000 Interest Income 1538 05/31/2018 Bank Interest- May (49.30) (1,484.87) (1,534.17) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (1,484.87) (1,534.17) ** .00 Budgeted 1,534.17 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund (1,053,935.08) .00 (1,053,935.08) _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (1,053,935.08) ** .00 Budgeted 1,053,935.08 Remaining 0 % Used Department Totals: ----------------------------------- (1,055,469.25) ** (1,484.87) Monthly Total .00 Budgeted 1,055,469.25 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 5/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-60334-010-000 Interfund Transfer Out 1519 05/31/2018 Texpool Transfers May Transfer to Gen unass cash 796,145.08 1,053,984.38 1,850,129.46 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: 1,053,984.38 1,850,129.46 ** .00 Budgeted (1,850,129.46) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2,693,208.68 .00 2,693,208.68 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 4,543,338.14 ** 1,053,984.38 Monthly Total .00 Budgeted (4,543,338.14) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,487,868.89 1,052,499.51 Monthly Total .00 Budgeted (3,487,868.89) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET MAY 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 545,786 ACCOUNTS RECEIVABLE - TOTAL ASSETS 545,786 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 119,208 TOTAL FUND BALANCE 545,786 TOTAL LIABILITIES AND FUND BALANCE 545,786 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:05 06/13/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/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- 774.10- 4,364.94- 436.494 3,364.94 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,068.00- 32,649.00- 66.636 16,347.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,248.00- 82,194.00- 66.642 41,142.00- Subtotal: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Program number: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Department number: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (3,590.84) (774.10) (4,364.94) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (774.10) (4,364.94) ** (1,000.00) Budgeted 3,364.94 Remaining 436 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1519 05/31/2018 Texpool Transfers May (28,581.00) (4,083.00) (32,664.00) GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 15.00 (32,649.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,068.00) (32,649.00) ** (48,996.00) Budgeted (16,347.00) Remaining 67 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1519 05/31/2018 Texpool Transfers May (71,946.00) (10,278.00) (82,224.00) GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 30.00 (82,194.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,248.00) (82,194.00) ** (123,336.00) Budgeted (41,142.00) Remaining 67 % Used Department Totals: ----------------------------------- (119,207.94) ** (15,090.10) Monthly Total (173,332.00) Budgeted (54,124.06) Remaining 69 % Used Fund 528 Totals: ----------------------------------- (119,207.94) (15,090.10) Monthly Total (173,332.00) Budgeted (54,124.06) Remaining 69 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 873,573 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,575 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 892,720 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,575 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 14,575 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 845,805 TOTAL FUND BALANCE 878,145 TOTAL LIABILITIES AND FUND BALANCE 892,720 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:05 06/13/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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- 5,567.33- 671,913.01- 100.336 2,253.01 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 252.30- 2,586.35- 143.686 786.35 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 594.38- 1,795.40- 89.770 204.60- Subtotal: 673,460.00- 673,460.00- 6,414.01- 676,294.76- 100.421 2,834.76 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,249.14- 5,001.05- 250.053 3,001.05 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- 88,758.48- 72.727 33,284.52- Subtotal: 342,997.00- 342,997.00- 12,343.95- 312,713.53- 91.171 30,283.47- Program number: 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- Department number: Revenues 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:05 06/13/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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 1,450.00 67.442 700.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 143,203.75 14.169 867,454.25 Program number: 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Department number: Administration 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 18,757.96- 845,804.54- ############### 840,005.54 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (666,345.68) (66.63) (666,412.31) GL 1477 05/02/2018 Property Taxes (12.82) (666,425.13) GL 1478 05/03/2018 Property Taxes (74.24) (666,499.37) GL 1479 05/04/2018 Property Taxes (30.64) (666,530.01) GL 1480 05/07/2018 Property Taxes (842.81) (667,372.82) GL 1481 05/09/2018 Property Taxes (211.04) (667,583.86) GL 1482 05/10/2018 Property Taxes (35.01) (667,618.87) GL 1483 05/11/2018 Property Taxes (367.22) (667,986.09) GL 1484 05/14/2018 Property Taxes (496.11) (668,482.20) GL 1485 05/15/2018 Property Taxes (26.47) (668,508.67) GL 1486 05/16/2018 Property Taxes (640.52) (669,149.19) GL 1487 05/17/2018 Property Taxes (240.91) (669,390.10) GL 1488 05/18/2018 Property Taxes (33.57) (669,423.67) GL 1489 05/21/2018 Property Taxes (58.56) (669,482.23) GL 1490 05/22/2018 Property Taxes (37.64) (669,519.87) GL 1491 05/23/2018 Property Taxes (354.17) (669,874.04) GL 1492 05/24/2018 Property Taxes (992.91) (670,866.95) GL 1493 05/25/2018 Property Taxes (55.25) (670,922.20) GL 1495 05/29/2018 Property Taxes (198.47) (671,120.67) GL 1496 05/30/2018 Property Taxes (288.70) (671,409.37) GL 1497 05/31/2018 Property Taxes (503.64) (671,913.01) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (5,567.33) (671,913.01) ** (669,660.00) Budgeted 2,253.01 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1477 05/02/2018 Property Taxes (2,334.05) (48.26) (2,382.31) GL 1481 05/09/2018 Property Taxes (11.67) (2,393.98) GL 1491 05/23/2018 Property Taxes 12.10 (2,381.88) GL 1495 05/29/2018 Property Taxes (204.47) (2,586.35) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (252.30) (2,586.35) ** (1,800.00) Budgeted 786.35 Remaining 144 % Used Account: 533-40015-000-000 Property Taxes/P & I 1476 05/01/2018 Property Taxes (1,201.02) (8.41) (1,209.43) GL 1477 05/02/2018 Property Taxes (9.15) (1,218.58) GL 1478 05/03/2018 Property Taxes (8.17) (1,226.75) GL 1479 05/04/2018 Property Taxes (3.98) (1,230.73) GL 1480 05/07/2018 Property Taxes (101.76) (1,332.49) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (1,201.02) (30.70) (1,363.19) GL 1483 05/11/2018 Property Taxes (39.19) (1,402.38) GL 1484 05/14/2018 Property Taxes (30.99) (1,433.37) GL 1486 05/16/2018 Property Taxes (63.04) (1,496.41) GL 1487 05/17/2018 Property Taxes (15.23) (1,511.64) GL 1490 05/22/2018 Property Taxes (1.72) (1,513.36) GL 1491 05/23/2018 Property Taxes (13.68) (1,527.04) GL 1492 05/24/2018 Property Taxes (101.27) (1,628.31) GL 1495 05/29/2018 Property Taxes (100.82) (1,729.13) GL 1496 05/30/2018 Property Taxes (29.18) (1,758.31) GL 1497 05/31/2018 Property Taxes (37.09) (1,795.40) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (594.38) (1,795.40) ** (2,000.00) Budgeted (204.60) Remaining 90 % Used Account: 533-49010-000-000 Interest Income 1538 05/31/2018 Bank Interest- May (3,751.91) (1,249.14) (5,001.05) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,249.14) (5,001.05) ** (2,000.00) Budgeted 3,001.05 Remaining 250 % 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 1519 05/31/2018 Texpool Transfers May (77,663.67) (11,094.81) (88,758.48) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (88,758.48) ** (122,043.00) Budgeted (33,284.52) Remaining 73 % Used Department Totals: ----------------------------------- (989,008.29) ** (18,757.96) Monthly Total (1,016,457.00) Budgeted (27,448.71) Remaining 97 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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 1,450.00 .00 1,450.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % 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: ----------------------------------- 143,203.75 ** .00 Monthly Total 1,010,658.00 Budgeted 867,454.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (845,804.54) (18,757.96) Monthly Total (5,799.00) Budgeted 840,005.54 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MAY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 341,398 ACCOUNTS RECEIVABLE - TOTAL ASSETS 341,398 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 325,188 TOTAL FUND BALANCE 341,398 TOTAL LIABILITIES AND FUND BALANCE 341,398 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:05 06/13/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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- 420.27- 1,611.17- 161.117 611.17 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 435,445.76- 72.727 163,292.24- Subtotal: 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Program number: 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Department number: Revenues 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 22:05 06/13/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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,850.99- 325,188.18- ############### 324,188.18 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (1,190.90) (420.27) (1,611.17) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (420.27) (1,611.17) ** (1,000.00) Budgeted 611.17 Remaining 161 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1519 05/31/2018 Texpool Transfers May (381,015.04) (54,430.72) (435,445.76) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (435,445.76) ** (598,738.00) Budgeted (163,292.24) Remaining 73 % Used Department Totals: ----------------------------------- (437,056.93) ** (54,850.99) Monthly Total (599,738.00) Budgeted (162,681.07) Remaining 73 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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: ----------------------------------- (325,188.18) (54,850.99) Monthly Total (1,000.00) Budgeted 324,188.18 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 172,430 ACCOUNTS RECEIVABLE - TOTAL ASSETS 172,430 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 171,479 TOTAL FUND BALANCE 172,430 TOTAL LIABILITIES AND FUND BALANCE 172,430 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 22:05 06/13/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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- 215.34- 777.79- 129.632 177.79 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 202,242.48- 72.727 75,841.52- Subtotal: 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Program number: 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Department number: Revenues 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 22:05 06/13/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/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,495.65- 171,478.52- ############### 170,878.52 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (562.45) (215.34) (777.79) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (215.34) (777.79) ** (600.00) Budgeted 177.79 Remaining 130 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1519 05/31/2018 Texpool Transfers May (176,962.17) (25,280.31) (202,242.48) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (202,242.48) ** (278,084.00) Budgeted (75,841.52) Remaining 73 % Used Department Totals: ----------------------------------- (203,020.27) ** (25,495.65) Monthly Total (278,684.00) Budgeted (75,663.73) Remaining 73 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/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: ----------------------------------- (171,478.52) (25,495.65) Monthly Total (600.00) Budgeted 170,878.52 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,099,116.75 **** 61,551.61 Monthly Total (375,349.00) Budgeted (2,474,465.75) Remaining ########## ******* End of Report *********