The URL can be used to link to this page

Home My WebLink About2018-04 April Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 778,987 PREPAID EXPENSES 6,349 ADVALOREM PROPERTY TAXES RECEIVABLE 31,335 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 816,671 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 31,335 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 31,335 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 263,084 TOTAL FUND BALANCE 785,337 TOTAL LIABILITIES AND FUND BALANCE 816,671 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 20:48 05/10/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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- 3,181.62- 1,049,201.89- 99.504 5,231.11- 122-40011-000-000 Property Taxes/Fire-Delinquent 466.42- 3,567.33- 3,567.33 122-40020-000-000 Property Taxes/Fire P&I 282.11- 3,414.86- 3,414.86 Subtotal: 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Program number: 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 20:48 05/10/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 8,889.09 49.384 9,110.91 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 355,197.50 58.333 253,712.50 Subtotal: 845,864.00 845,864.00 52,012.37 583,040.59 68.928 262,823.41 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 793,099.68 75.216 261,333.32 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 793,099.68 75.216 261,333.32 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 793,099.68 75.216 261,333.32 Fund number: 122 Trophy Club MUD Fire Dept. 48,082.22 263,084.40- 263,084.40 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (1,046,020.27) (1,330.47) (1,047,350.74) GL 1312 04/03/2018 Property Taxes (379.66) (1,047,730.40) GL 1313 04/04/2018 Property Taxes (201.02) (1,047,931.42) GL 1314 04/05/2018 Property Taxes (350.45) (1,048,281.87) GL 1315 04/06/2018 Property Taxes (243.96) (1,048,525.83) GL 1316 04/16/2018 Property Taxes (137.52) (1,048,663.35) GL 1317 04/18/2018 Property Taxes (63.88) (1,048,727.23) GL 1318 04/20/2018 Property Taxes 646.10 (1,048,081.13) GL 1319 04/23/2018 Property Taxes (204.93) (1,048,286.06) GL 1320 04/24/2018 Property Taxes (180.07) (1,048,466.13) GL 1321 04/25/2018 Property Taxes (4.21) (1,048,470.34) GL 1322 04/26/2018 Property Taxes (238.23) (1,048,708.57) GL 1323 04/27/2018 Property Taxes (189.96) (1,048,898.53) GL 1324 04/30/2018 Property Taxes (303.36) (1,049,201.89) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (1,441.26) (1,050,643.15) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 1,441.26 (1,049,201.89) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,181.62) (1,049,201.89) ** (1,054,433.00) Budgeted (5,231.11) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1311 04/02/2018 Property Taxes (3,100.91) (99.58) (3,200.49) GL 1316 04/16/2018 Property Taxes (124.70) (3,325.19) GL 1319 04/23/2018 Property Taxes (.01) (3,325.20) GL 1321 04/25/2018 Property Taxes (242.12) (3,567.32) GL 1322 04/26/2018 Property Taxes (.01) (3,567.33) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (466.42) (3,567.33) ** .00 Budgeted 3,567.33 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1311 04/02/2018 Property Taxes (3,132.75) (93.33) (3,226.08) GL 1312 04/03/2018 Property Taxes (.98) (3,227.06) GL 1313 04/04/2018 Property Taxes (1.99) (3,229.05) GL 1314 04/05/2018 Property Taxes (25.13) (3,254.18) GL 1315 04/06/2018 Property Taxes (14.45) (3,268.63) GL 1316 04/16/2018 Property Taxes (36.47) (3,305.10) GL 1317 04/18/2018 Property Taxes (9.37) (3,314.47) GL 1319 04/23/2018 Property Taxes (22.54) (3,337.01) GL 1320 04/24/2018 Property Taxes (4.20) (3,341.21) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1321 04/25/2018 Property Taxes (3,132.75) (22.25) (3,363.46) GL 1322 04/26/2018 Property Taxes (3.83) (3,367.29) GL 1323 04/27/2018 Property Taxes (20.89) (3,388.18) GL 1324 04/30/2018 Property Taxes (26.68) (3,414.86) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .57 (3,414.29) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.57) (3,414.86) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (282.11) (3,414.86) ** .00 Budgeted 3,414.86 Remaining 0 % Used Department Totals: ----------------------------------- (1,056,184.08) ** (3,930.15) Monthly Total (1,054,433.00) Budgeted 1,751.08 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 7,619.22 1,269.87 8,889.09 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 8,889.09 ** 18,000.00 Budgeted 9,110.91 Remaining 49 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1126 04/04/2018 April A/P Fire Admin April 304,455.00 50,742.50 355,197.50 TOWN OF TROPHY CLUB 4078 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 355,197.50 ** 608,910.00 Budgeted 253,712.50 Remaining 58 % 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: ----------------------------------- 793,099.68 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 261,333.32 Remaining 75 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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: ----------------------------------- (263,084.40) 48,082.22 Monthly Total .00 Budgeted 263,084.40 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 902,558 - 902,558 CASH IN BANK-SAVINGS-CASH RESERVE 781,976 - 781,976 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,929 - 714,929 INVESTMENTS-TEXPOOL 1,748,273 596,426 2,344,699 PREPAID EXPENSES 45,857 - 45,857 ADVALOREM PROPERTY TAXES RECEIVABLE 3,553 - 3,553 UTILITY AND OTHER ACCOUNTS RECEIVABLE 878,763 - 878,763 TOTAL ASSETS 5,111,824 596,426 5,708,250 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,553 - 3,553 ACCOUNTS AND OTHER PAYABLES 451,191 - 451,191 CUSTOMER DEPOSITS 315,605 - 315,605 - TOTAL LIABILITIES 770,349 - 770,349 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 191,107 - 191,107 - TOTAL FUND BALANCE 4,341,475 596,426 4,937,901 TOTAL LIABILITIES AND FUND BALANCE 5,111,824 596,426 5,708,250 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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- 364.92- 120,345.17- 99.500 604.83- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 27.70- 230.75- 115.375 30.75 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 27.89- 363.05- 181.525 163.05 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 420.51- 120,938.97- 40.422 178,250.03- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 415,533.61- 2,640,649.08- 40.852 3,823,369.92- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 261,105.47- 1,683,847.74- 56.542 1,294,219.26- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 5,090.38- 64,594.49- 60.778 41,684.51- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,250.00- 8,450.00- 39.578 12,900.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 1,500.00- 100.000 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 3,700.00- 82.222 800.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 6,337.60- 16,310.40- 27.184 43,689.60- Subtotal: 9,635,715.00- 9,635,715.00- 689,317.06- 4,419,051.71- 45.861 5,216,663.29- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 4,704.36- 25,571.00- 213.092 13,571.00 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,957.62- 7,762.20- 71.043 3,163.80- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,083.31- 58.333 2,916.69- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 9,434.76- 51.899 8,744.24- 135-49141-000-000 Interfund Transfer In 796,145.08- 796,145.08- 796,145.08 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 310.54- 12,758.19- 255.164 7,758.19 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- 819,100.93- 871,154.54- 276.447 556,029.54 Program number: 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 18,641.57 118,432.50 43.180 155,846.50 135-50010-010-000 Overtime 20,000.00 20,000.00 885.32 5,510.70 27.554 14,489.30 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 175.00 1,250.00 37.879 2,050.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,822.42 13,296.50 47.755 14,546.50 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 18,055.83 34.592 34,140.17 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,521.04 29.352 3,660.96 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 280.23 28.192 713.77 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 399.14 1,674.71 56.161 1,307.29 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,212.01 7,903.81 42.352 10,758.19 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 283.43 1,848.45 42.347 2,516.55 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 78.35 808.42 74.854 271.58 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 6,299.44 53.142 5,554.56 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 27,595.53 180,436.67 42.290 246,225.33 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 906.46 48,666.04 48.666 51,333.96 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 3,853.07 96.327 146.93 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 836.72 3,605.16 65.548 1,894.84 Subtotal: 391,000.00 391,000.00 1,743.18 56,124.27 14.354 334,875.73 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 2,122.44 45.158 2,577.56 135-60020-010-000 Electricity 175,356.00 175,356.00 9,302.54 73,159.82 41.721 102,196.18 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.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 60.00 1,395.78 50.118 1,389.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 4,602.27 17,410.32 31.554 37,765.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 241,084.44 962,751.81 34.102 1,860,418.19 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 180.00 502.70 16.757 2,497.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 4,500.00 30.508 10,250.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 176,962.17 63.636 101,121.83 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 28,581.00 58.333 20,415.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 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 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1,340,794.64 2,327,203.62 64.397 1,286,648.38 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 973.50 5,779.30 38.529 9,220.70 135-65010-010-000 Uniforms 4,488.00 4,488.00 258.57 1,249.14 27.833 3,238.86 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,208.14 10,731.77 53.659 9,268.23 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 192.00 19.200 808.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 3,691.00 16,091.00 32.182 33,909.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,131.21 82,943.21 47.211 92,744.79 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 57,671.25 365,542.05 45.128 444,469.95 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 57,671.25 548,406.43 52.317 499,824.57 Program number: 5,655,433.00 5,655,433.00 1,434,935.81 3,195,114.20 56.496 2,460,318.80 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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 296.19 1,200.08 60.004 799.92 Subtotal: 2,000.00 2,000.00 296.19 1,200.08 60.004 799.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 296.19 1,200.08 60.004 799.92 Department number: Water 5,657,433.00 5,657,433.00 1,435,232.00 3,196,314.28 56.498 2,461,118.72 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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,215.53 210,111.04 51.139 200,754.96 135-50010-020-000 Overtime 30,000.00 30,000.00 3,965.74 19,634.62 65.449 10,365.38 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 4,936.00 58.762 3,464.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,764.03 23,848.14 56.455 18,394.86 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 37,974.64 61.077 24,200.36 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 496.68 2,832.29 53.733 2,438.71 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 508.36 45.634 605.64 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 650.56 2,989.82 69.839 1,291.18 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,676.36 13,976.06 49.361 14,337.94 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 392.06 3,268.59 49.360 3,353.41 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 9,436.00 52.451 8,554.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 42,786.55 338,064.56 53.952 288,536.44 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 9,749.87 36,495.26 42.387 49,604.74 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 2,061.46 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 6,820.84 50,181.61 83.636 9,818.39 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,202.60 20,529.42 68.431 9,470.58 Subtotal: 219,150.00 219,150.00 20,834.77 116,023.36 52.942 103,126.64 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 2,865.72 60.973 1,834.28 135-60020-020-000 Electricity 266,709.00 266,709.00 13,148.89 99,534.05 37.319 167,174.95 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 222.00 3.911 5,455.00 135-60090-020-000 Safety Program 550.00 550.00 343.35 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 17.40 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 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 3,540.00 30.517 8,060.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 77,663.67 63.636 44,379.33 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 381,015.04 63.636 217,722.96 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 71,946.00 58.333 51,390.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 1,438,938.00 92,255.17 669,263.19 46.511 769,674.81 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 604.75 5,340.19 42.722 7,159.81 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 29.88 5,281.23 19.204 22,218.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 10.95 1,149.94 114.994 149.94- 135-65040-020-000 Safety Equipment 750.00 750.00 164.40 750.97 100.129 .97- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,861.12 10,700.58 76.433 3,299.42 Subtotal: 60,209.00 60,209.00 3,671.10 24,997.50 41.518 35,211.50 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 219,495.17- 89,960.61 16.436 457,366.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 219,495.17- 119,960.61 18.855 516,281.39 Program number: 2,981,140.00 2,981,140.00 59,947.58- 1,268,309.22 42.544 1,712,830.78 Department number: Wastewater 2,981,140.00 2,981,140.00 59,947.58- 1,268,309.22 42.544 1,712,830.78 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 16.94 56.467 13.06 Subtotal: 30.00 30.00 2.42 16.94 56.467 13.06 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 810.00 810.00 67.500 390.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 405.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 233.55 1,255.28 62.764 744.72 Subtotal: 12,950.00 12,950.00 1,448.55 5,215.28 40.272 7,734.72 Program number: 12,980.00 12,980.00 1,450.97 5,232.22 40.310 7,747.78 Department number: Board of Directors 12,980.00 12,980.00 1,450.97 5,232.22 40.310 7,747.78 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,557.13 214,185.54 49.481 218,677.46 135-50010-030-000 Overtime 2,000.00 2,000.00 10.39 467.06 23.353 1,532.94 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,105.00 22,490.45 55.459 18,062.55 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 27,338.45 43.063 36,146.55 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 2,012.44 36.577 3,489.56 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 383.92 32.730 789.08 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 534.46 2,454.75 48.522 2,604.25 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,002.72 12,990.91 47.794 14,190.09 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 468.38 3,038.19 47.793 3,318.81 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 81.87 983.77 78.077 276.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 864.50 56.540 664.50 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 760.82 3,109.08 62.683 1,850.92 Subtotal: 595,970.00 595,970.00 45,091.54 293,991.51 49.330 301,978.49 135-55030-030-000 Software & Support 78,391.00 78,391.00 8,920.35 53,406.90 68.129 24,984.10 135-55070-030-000 Independent Labor 154,000.00 154,000.00 13,647.83 87,822.59 57.028 66,177.41 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 2,670.44 5,146.17 36.758 8,853.83 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 3,955.00 3,955.00 39.550 6,045.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 4,831.45 48.315 5,168.55 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 177.94 4,129.73 45.886 4,870.27 Subtotal: 338,916.00 338,916.00 30,240.62 218,531.84 64.480 120,384.16 135-60005-030-000 Telephone 27,300.00 27,300.00 2,589.86 10,007.54 36.658 17,292.46 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 150.00 1,799.43 44.986 2,200.57 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 745.53 3,852.21 23.690 12,408.79 135-60025-030-000 Water 2,500.00 2,500.00 58.32 397.44 15.898 2,102.56 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 312.44 12,977.71 43.259 17,022.29 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,557.10 34,353.22 61.831 21,206.78 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 45,977.52 82.103 10,022.48 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 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 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 450.00 3,143.00 41.355 4,457.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 111.29 711.12 14.557 4,173.88 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 75.00 220.00 4.889 4,280.00 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 150.00 6.000 2,350.00 135-60235-030-000 Security 2,700.00 2,700.00 24.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 15,530.28 118,721.50 47.583 130,784.50 135-65010-030-000 Uniforms 700.00 700.00 135.99 273.73 39.104 426.27 135-65055-030-000 Hardware 7,420.00 7,420.00 910.99 1,508.94 20.336 5,911.06 135-65085-030-000 Office Supplies 7,000.00 7,000.00 446.19 3,322.40 47.463 3,677.60 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 363.36 3,185.75 79.644 814.25 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 1,856.53 10,483.48 41.734 14,636.52 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 20,986.32 28,827.32 221.749 15,827.32- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 248.39 1,724.53 37.490 2,875.47 Subtotal: 17,600.00 17,600.00 21,234.71 30,551.85 173.590 12,951.85- Program number: 1,227,112.00 1,227,112.00 113,953.68 672,280.18 54.786 554,831.82 Department number: Administration 1,227,112.00 1,227,112.00 113,953.68 672,280.18 54.786 554,831.82 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 5,940.00 42,753.55 31.207 94,246.45 135-55055-039-000 Auditing 24,500.00 24,500.00 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 6,672.05 58.292 4,773.95 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 5,940.00 77,902.70 44.076 98,843.30 Program number: 176,746.00 176,746.00 5,940.00 77,902.70 44.076 98,843.30 Department number: Non Departmental 176,746.00 176,746.00 5,940.00 77,902.70 44.076 98,843.30 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 1,496,629.07 5,220,038.60 51.913 4,835,372.40 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 12,209.43- 191,106.62- 98.196 3,511.38- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 20:48 05/10/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (119,980.25) (152.60) (120,132.85) GL 1312 04/03/2018 Property Taxes (43.55) (120,176.40) GL 1313 04/04/2018 Property Taxes (23.05) (120,199.45) GL 1314 04/05/2018 Property Taxes (40.20) (120,239.65) GL 1315 04/06/2018 Property Taxes (27.98) (120,267.63) GL 1316 04/16/2018 Property Taxes (15.77) (120,283.40) GL 1317 04/18/2018 Property Taxes (7.33) (120,290.73) GL 1318 04/20/2018 Property Taxes 74.11 (120,216.62) GL 1319 04/23/2018 Property Taxes (23.50) (120,240.12) GL 1320 04/24/2018 Property Taxes (20.65) (120,260.77) GL 1321 04/25/2018 Property Taxes (.48) (120,261.25) GL 1322 04/26/2018 Property Taxes (27.33) (120,288.58) GL 1323 04/27/2018 Property Taxes (21.79) (120,310.37) GL 1324 04/30/2018 Property Taxes (34.80) (120,345.17) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (165.31) (120,510.48) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 165.31 (120,345.17) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (364.92) (120,345.17) ** (120,950.00) Budgeted (604.83) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1311 04/02/2018 Property Taxes (203.05) (6.12) (209.17) GL 1316 04/16/2018 Property Taxes (7.34) (216.51) GL 1321 04/25/2018 Property Taxes (14.24) (230.75) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (27.70) (230.75) ** (200.00) Budgeted 30.75 Remaining 115 % Used Account: 135-40015-000-000 Property Taxes/P & I 1311 04/02/2018 Property Taxes (335.16) (9.30) (344.46) GL 1312 04/03/2018 Property Taxes (.11) (344.57) GL 1313 04/04/2018 Property Taxes (.23) (344.80) GL 1314 04/05/2018 Property Taxes (2.88) (347.68) GL 1315 04/06/2018 Property Taxes (1.66) (349.34) GL 1316 04/16/2018 Property Taxes (2.32) (351.66) GL 1317 04/18/2018 Property Taxes (1.07) (352.73) GL 1319 04/23/2018 Property Taxes (2.59) (355.32) GL 1320 04/24/2018 Property Taxes (.49) (355.81) GL 1321 04/25/2018 Property Taxes (1.34) (357.15) GL 1322 04/26/2018 Property Taxes (.44) (357.59) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1323 04/27/2018 Property Taxes (335.16) (2.40) (359.99) GL 1324 04/30/2018 Property Taxes (3.06) (363.05) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .06 (362.99) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.06) (363.05) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (27.89) (363.05) ** (200.00) Budgeted 163.05 Remaining 182 % 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 1129 04/04/2018 UB 04/04/2018 Charge removal UB20180404-20180404 User: (2,225,115.47) 26.85 (2,225,088.62) UB 1282 04/30/2018 Ashtoon Woods Water Main Repar 100,000 Gallons@ $3.96 per1000 (396.00) (2,225,484.62) GL 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (415,164.46) (2,640,649.08) UB _______________ Account: 135-47000-000-000 Water Totals: (415,533.61) (2,640,649.08) ** (6,464,019.00) Budgeted (3,823,369.92) Remaining 41 % Used Account: 135-47005-000-000 Sewer 1129 04/04/2018 UB 04/04/2018 Charge removal UB20180404-20180404 User: (1,422,742.27) 26.79 (1,422,715.48) UB 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (261,132.26) (1,683,847.74) UB _______________ Account: 135-47005-000-000 Sewer Totals: (261,105.47) (1,683,847.74) ** (2,978,067.00) Budgeted (1,294,219.26) Remaining 57 % Used Account: 135-47025-000-000 Penalties 1166 04/09/2018 UB 04/09/2018 Penalty removal UB20180409-20180409 User: (59,504.11) 72.25 (59,431.86) UB 1238 04/23/2018 UB 04/23/2018 C/A Penalties UB20180423-20180423 User: (5,252.94) (64,684.80) UB 1247 04/25/2018 UB 04/25/2018 Penalty Removal UB20180425-20180425 User: 34.23 (64,650.57) UB 1262 04/27/2018 UB 04/27/2018 Penalty Removal UB20180427-20180427 User: 28.11 (64,622.46) UB 1274 04/30/2018 UB 04/30/2018 Penalty removal UB20180430-20180430 User: 27.97 (64,594.49) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,090.38) (64,594.49) ** (106,279.00) Budgeted (41,684.51) Remaining 61 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-47030-000-000 Service Charges 1140 04/05/2018 UB 04/05/2018 Disconnect Fees UB20180405-20180405 User: (7,200.00) (1,200.00) (8,400.00) UB 1232 04/19/2018 UB 04/19/2018 NSF checks UB20180419-20180419 User: (50.00) (8,450.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,250.00) (8,450.00) ** (21,350.00) Budgeted (12,900.00) Remaining 40 % Used Account: 135-47035-000-000 Plumbing Inspections (1,500.00) .00 (1,500.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (1,500.00) ** (1,500.00) Budgeted .00 Remaining 100 % Used Account: 135-47045-000-000 Sewer Inspections (3,700.00) .00 (3,700.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (3,700.00) ** (4,500.00) Budgeted (800.00) Remaining 82 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (9,972.80) (6,337.60) (16,310.40) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (6,337.60) (16,310.40) ** (60,000.00) Budgeted (43,689.60) Remaining 27 % Used Account: 135-49010-000-000 Interest Income 1304 04/30/2018 Bank Interest- April (20,866.64) (151.77) (21,018.41) GL 1304 04/30/2018 Bank Interest- April (494.45) (21,512.86) GL 1304 04/30/2018 Bank Interest- April (4,058.14) (25,571.00) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (4,704.36) (25,571.00) ** (12,000.00) Budgeted 13,571.00 Remaining 213 % Used Account: 135-49016-000-000 Cell Tower Revenue 1280 04/23/2018 Cell Tower Rev AT&T (5,804.58) (978.81) (6,783.39) GL 1250 04/30/2018 Cell Tower Rev AT&T April (978.81) (7,762.20) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,957.62) (7,762.20) ** (10,926.00) Budgeted (3,163.80) Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-49018-000-000 Building Rent Income 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (3,499.98) (583.33) (4,083.31) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets 1251 04/23/2018 Sale of WW Trucks in Auction Sale of Assets- WW trucks (15,400.00) (15,400.00) GL _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (15,400.00) (15,400.00) ** (2,000.00) Budgeted 13,400.00 Remaining 770 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (9,434.76) .00 (9,434.76) _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (9,434.76) ** (18,179.00) Budgeted (8,744.24) Remaining 52 % Used Account: 135-49141-000-000 Interfund Transfer In 1306 04/30/2018 Swift Fund Deposit TexPool (796,145.08) (796,145.08) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (796,145.08) (796,145.08) ** .00 Budgeted 796,145.08 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1222 04/19/2018 JSB Non-Serv Agreement Inv1632 AR 20180419-20180419 User: (12,447.65) (45,000.00) (57,447.65) AR 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (310.54) (57,758.19) UB 1330 04/30/2018 Reverse JSB Invoice 1632 AR 20180430-20180430 User: 45,000.00 (12,758.19) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (310.54) (12,758.19) ** (5,000.00) Budgeted 7,758.19 Remaining 255 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-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: ----------------------------------- (5,411,145.22) ** (1,508,838.50) Monthly Total (10,250,029.00) Budgeted (4,838,883.78) Remaining 53 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 99,790.93 8,883.92 108,674.85 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 9,757.65 118,432.50 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,641.57 118,432.50 ** 274,279.00 Budgeted 155,846.50 Remaining 43 % Used Account: 135-50010-010-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 4,625.38 647.89 5,273.27 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 237.43 5,510.70 PR _______________ Account: 135-50010-010-000 Overtime Totals: 885.32 5,510.70 ** 20,000.00 Budgeted 14,489.30 Remaining 28 % 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 1212 04/20/2018 MUD PR 04.20.18 Certification 1,075.00 175.00 1,250.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 1,250.00 ** 3,300.00 Budgeted 2,050.00 Remaining 38 % Used Account: 135-50020-010-000 Retirement 1119 04/06/2018 MUD PR 04.06.18 Retirement 11,474.08 881.68 12,355.76 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 940.74 13,296.50 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,822.42 13,296.50 ** 27,843.00 Budgeted 14,546.50 Remaining 48 % Used Account: 135-50026-010-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 15,107.03 1,474.40 16,581.43 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 1,474.40 18,055.83 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 18,055.83 ** 52,196.00 Budgeted 34,140.17 Remaining 35 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 1,307.39 106.85 1,414.24 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 106.80 1,521.04 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,521.04 ** 5,182.00 Budgeted 3,660.96 Remaining 29 % Used Account: 135-50028-010-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 244.31 17.98 262.29 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 17.94 280.23 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 280.23 ** 994.00 Budgeted 713.77 Remaining 28 % Used Account: 135-50029-010-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 1,275.57 110.60 1,386.17 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 72.43 1,458.60 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 18.50 1,477.10 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 87.01 1,564.11 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 110.60 1,674.71 Humana Inc 4133 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 399.14 1,674.71 ** 2,982.00 Budgeted 1,307.29 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 6,691.80 592.73 7,284.53 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 619.28 7,903.81 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,212.01 7,903.81 ** 18,662.00 Budgeted 10,758.19 Remaining 42 % Used Account: 135-50035-010-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 1,565.02 138.63 1,703.65 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 144.80 1,848.45 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 283.43 1,848.45 ** 4,365.00 Budgeted 2,516.55 Remaining 42 % Used Account: 135-50040-010-000 Unemployment Taxes . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1119 04/06/2018 MUD PR 04.06.18 Unemployment Taxes 730.07 46.39 776.46 PR 1212 04/20/2018 MUD PR 04.20.18 Unemployment Taxes 31.96 808.42 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 78.35 808.42 ** 1,080.00 Budgeted 271.58 Remaining 75 % Used Account: 135-50045-010-000 Workman's Compensation 238 04/01/2018 Insurance/Wrk Comp Exp Apr 5,399.52 899.92 6,299.44 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 6,299.44 ** 11,854.00 Budgeted 5,554.56 Remaining 53 % 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 1193 04/13/2018 April A/P 10" valve replacement-525 Indi 47,759.58 7,519.55 55,279.13 REY-MAR CONSTRUCTION 4111 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STUART HOSE & PIPE-FT 318.00 55,597.13 STUART HOSE & PIPE-FT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 150.68 55,747.81 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 12.07 55,759.88 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SC TRACKING SOLUTIONS 65.70 55,825.58 SC TRACKING SOLUTIONS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 MACARTHUR GAUGE INC 50.00 55,875.58 MACARTHUR GAUGE INC PC 1282 04/30/2018 Ashtoon Woods Water Main Repar 609 Hogan's Drive (7,209.54) 48,666.04 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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: 906.46 48,666.04 ** 100,000.00 Budgeted 51,333.96 Remaining 49 % 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 3,853.07 .00 3,853.07 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 3,853.07 ** 4,000.00 Budgeted 146.93 Remaining 96 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1346 04/30/2018 April A/P TCEQ samples 2,768.44 476.72 3,245.16 LOWER COLORADO RIVER AUTHORITY 4180 AP 1364 04/30/2018 April A/P Water samples 360.00 3,605.16 TARRANT CTY PUBLIC HEALTH LAB 4186 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 836.72 3,605.16 ** 5,500.00 Budgeted 1,894.84 Remaining 66 % Used Account: 135-60010-010-000 Communications/Mobiles 2,122.44 .00 2,122.44 _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: .00 2,122.44 ** 4,700.00 Budgeted 2,577.56 Remaining 45 % Used Account: 135-60020-010-000 Electricity 1242 04/24/2018 April A/P Electricity 3/9-4/10 63,857.28 9,302.54 73,159.82 HUDSON ENERGY SERVICES, LLC 4134 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-010-000 Electricity Totals: 9,302.54 73,159.82 ** 175,356.00 Budgeted 102,196.18 Remaining 42 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1178 04/11/2018 April A/P AWWA Standards renewal 767.00 767.00 AMERICAN WATER WORKS ASSOC 4096 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 767.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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SUNCOAST LEARNING SYST 1,335.78 60.00 1,395.78 SUNCOAST LEARNING SYST PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 60.00 1,395.78 ** 2,785.00 Budgeted 1,389.22 Remaining 50 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1346 04/30/2018 April A/P Well water 12,808.05 4,602.27 17,410.32 North Texas Groundwater 4183 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,602.27 17,410.32 ** 55,176.00 Budgeted 37,765.68 Remaining 32 % Used Account: 135-60150-010-000 Wholesale Water 1242 04/24/2018 April A/P Fort worth water 721,667.37 241,084.44 962,751.81 CITY OF FORT WORTH 4123 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 241,084.44 962,751.81 ** 2,823,170.00 Budgeted 1,860,418.19 Remaining 34 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON SAND & GRAVEL, 322.70 72.00 394.70 DENTON SAND & GRAVEL, PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON SAND & GRAVEL, 108.00 502.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 180.00 502.70 ** 3,000.00 Budgeted 2,497.30 Remaining 17 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1294 04/30/2018 April A/P April mowing 3,000.00 1,500.00 4,500.00 WATTS ELLISON LLC 4156 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 4,500.00 ** 14,750.00 Budgeted 10,250.00 Remaining 31 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1305 04/30/2018 Texpool Transfers April 151,681.86 25,280.31 176,962.17 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 176,962.17 ** 278,084.00 Budgeted 101,121.83 Remaining 64 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1305 04/30/2018 Texpool Transfers April 24,498.00 4,083.00 28,581.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 28,581.00 ** 48,996.00 Budgeted 20,415.00 Remaining 58 % Used Account: 135-60334-010-000 Interfund Transfer Out 1306 04/30/2018 Swift Fund Deposit TexPool 1,053,935.08 1,053,935.08 GL _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: 1,053,935.08 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 1258 04/26/2018 April A/P Fuel 4,805.80 950.39 5,756.19 US Bank Voyager Fleet Systems 4147 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 7-ELEVEN 32921 23.11 5,779.30 7-ELEVEN 32921 PC _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 973.50 5,779.30 ** 15,000.00 Budgeted 9,220.70 Remaining 39 % Used Account: 135-65010-010-000 Uniforms 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WM SUPERCENTER #5247 990.57 83.44 1,074.01 WM SUPERCENTER #5247 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WW GRAINGER 181.13 1,255.14 WW GRAINGER PC 1281 04/30/2018 Employee Safety Shoe Overage Frank Isola Paid for cost diff (6.00) 1,249.14 GL _______________ Account: 135-65010-010-000 Uniforms Totals: 258.57 1,249.14 ** 4,488.00 Budgeted 3,238.86 Remaining 28 % Used Account: 135-65030-010-000 Chemicals . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1193 04/13/2018 April A/P Testing supplies 8,523.63 46.00 8,569.63 HACH COMPANY 4103 AP 1242 04/24/2018 April A/P CHlorine 663.72 9,233.35 DPC INDUSTRIES, INC 4128 AP 1332 04/30/2018 April A/P Testing supplies 1,498.42 10,731.77 HACH COMPANY 4174 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,208.14 10,731.77 ** 20,000.00 Budgeted 9,268.23 Remaining 54 % 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 192.00 .00 192.00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 192.00 ** 1,000.00 Budgeted 808.00 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 1258 04/26/2018 April A/P meters 12,400.00 3,691.00 16,091.00 ATLAS UTILITY SUPPLY CO. 4119 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 3,691.00 16,091.00 ** 50,000.00 Budgeted 33,909.00 Remaining 32 % 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 1193 04/13/2018 April A/P Phoenix Drive 307,870.80 50,421.25 358,292.05 Quality Excavation, LTD 4110 AP 1357 04/30/2018 April A/P Water line replacements 7,250.00 365,542.05 TEAGUE, NALL & PERKINS,INC 4189 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 57,671.25 365,542.05 ** 810,012.00 Budgeted 444,469.95 Remaining 45 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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 1346 04/30/2018 April A/P Water samples 903.89 80.00 983.89 TARRANT CTY PUBLIC HEALTH LAB 4186 AP 1361 04/30/2018 April A/P TCEQ Samples PID 216.19 1,200.08 LOWER COLORADO RIVER AUTHORITY 4180 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 296.19 1,200.08 ** 2,000.00 Budgeted 799.92 Remaining 60 % Used Department 10 Totals: ----------------------------------- 3,196,314.28 ** 1,435,232.00 Monthly Total 5,657,433.00 Budgeted 2,461,118.72 Remaining 56 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 184,895.51 12,582.12 197,477.63 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 12,633.41 210,111.04 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,215.53 210,111.04 ** 410,866.00 Budgeted 200,754.96 Remaining 51 % Used Account: 135-50010-020-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 15,668.88 2,588.53 18,257.41 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 1,377.21 19,634.62 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,965.74 19,634.62 ** 30,000.00 Budgeted 10,365.38 Remaining 65 % 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 1212 04/20/2018 MUD PR 04.20.18 Certification 4,236.00 700.00 4,936.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 4,936.00 ** 8,400.00 Budgeted 3,464.00 Remaining 59 % Used Account: 135-50020-020-000 Retirement 1119 04/06/2018 MUD PR 04.06.18 Retirement 21,084.11 1,403.29 22,487.40 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 1,360.74 23,848.14 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,764.03 23,848.14 ** 42,243.00 Budgeted 18,394.86 Remaining 56 % Used Account: 135-50026-020-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 32,455.95 2,759.36 35,215.31 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 2,759.33 37,974.64 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 37,974.64 ** 62,175.00 Budgeted 24,200.36 Remaining 61 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 2,335.61 177.16 2,512.77 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 319.52 2,832.29 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 496.68 2,832.29 ** 5,271.00 Budgeted 2,438.71 Remaining 54 % Used Account: 135-50028-020-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 449.46 29.46 478.92 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 29.44 508.36 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 508.36 ** 1,114.00 Budgeted 605.64 Remaining 46 % Used Account: 135-50029-020-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 2,339.26 192.36 2,531.62 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 135.13 2,666.75 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 37.00 2,703.75 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 149.71 2,853.46 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 136.36 2,989.82 Humana Inc 4133 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 650.56 2,989.82 ** 4,281.00 Budgeted 1,291.18 Remaining 70 % Used Account: 135-50030-020-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 12,299.70 863.46 13,163.16 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 812.90 13,976.06 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,676.36 13,976.06 ** 28,314.00 Budgeted 14,337.94 Remaining 49 % Used Account: 135-50035-020-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 2,876.53 201.95 3,078.48 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 190.11 3,268.59 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 392.06 3,268.59 ** 6,622.00 Budgeted 3,353.41 Remaining 49 % Used Account: 135-50040-020-000 Unemployment Taxes . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,134.00 .00 1,134.00 _______________ 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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 8,088.00 1,348.00 9,436.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 9,436.00 ** 17,990.00 Budgeted 8,554.00 Remaining 52 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 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 1193 04/13/2018 April A/P Belt press and lift stations 26,745.39 1,175.00 27,920.39 DHS AUTOMATION, INC 4100 AP 1193 04/13/2018 April A/P 6" sewer line replacement-1026 6,335.85 34,256.24 REY-MAR CONSTRUCTION 4111 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 242.74 34,498.98 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 HOMEDEPOT.COM 398.00 34,896.98 HOMEDEPOT.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 476.58 35,373.56 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 FILTER ELEMENT STORE 163.38 35,536.94 FILTER ELEMENT STORE PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 84.76 35,621.70 AMAZON.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 66.80 35,688.50 THE HOME DEPOT #6581 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 26,745.39 61.14 35,749.64 ROANOKE AUTO SUPPLY LT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 20.88 35,770.52 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 8.14 35,778.66 THE HOME DEPOT #6581 PC 1258 04/26/2018 April A/P Lift station repairs 716.60 36,495.26 DHS AUTOMATION, INC 4126 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 9,749.87 36,495.26 ** 86,100.00 Budgeted 49,604.74 Remaining 42 % 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 1242 04/24/2018 April A/P Tailgate gasket 4,292.14 504.31 4,796.45 CLS SEWER EQUIPMENT CO., INC 4124 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON COUNTY, TX SOUT 1.00 4,797.45 DENTON COUNTY, TX SOUT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON COUNTY, TX SOUT 30.25 4,827.70 DENTON COUNTY, TX SOUT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 MUSTANG ELITE CAR 63.91 4,891.61 MUSTANG ELITE CAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 8.22 4,899.83 ROANOKE AUTO SUPPLY LT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 INLAND TRUCK PARTS # 40.00 4,939.83 INLAND TRUCK PARTS # PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 17.51 4,957.34 ROANOKE AUTO SUPPLY LT PC 1332 04/30/2018 April A/P Vac truck repair 1,396.26 6,353.60 CLS SEWER EQUIPMENT CO., INC 4168 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,061.46 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 1294 04/30/2018 April A/P Sludge haul off 43,360.77 845.00 44,205.77 L.H. CHANEY MATERIALS, INC. 4153 AP 1332 04/30/2018 April A/P Sludge haul off 1,962.51 46,168.28 L.H. CHANEY MATERIALS, INC. 4179 AP 1332 04/30/2018 April A/P sludge haul off 3,146.36 49,314.64 L.H. CHANEY MATERIALS, INC. 4179 AP 1361 04/30/2018 April A/P Sludge haul off 866.97 50,181.61 L.H. CHANEY MATERIALS, INC. 4179 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-55125-020-000 Dumpster Services Totals: 6,820.84 50,181.61 ** 60,000.00 Budgeted 9,818.39 Remaining 84 % Used Account: 135-55135-020-000 Lab Analysis 1194 04/13/2018 April A/P Lab testing 18,326.82 246.00 18,572.82 OXIDOR LABORATORIES LLC 4109 AP 1194 04/13/2018 April A/P Lab tests 176.00 18,748.82 OXIDOR LABORATORIES LLC 4109 AP 1201 04/16/2018 April A/P CIP chemicals 674.60 19,423.42 Valley Solvent Company, INC 4116 AP 1201 04/16/2018 April A/P Container refund (160.00) 19,263.42 Valley Solvent Company, INC 4116 AP 1258 04/26/2018 April A/P Lab samples 246.00 19,509.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P lab samples 176.00 19,685.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P Lab samples 176.00 19,861.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P lab samples 246.00 20,107.42 OXIDOR LABORATORIES LLC 4144 AP 1294 04/30/2018 April A/P effluent sampling 176.00 20,283.42 OXIDOR LABORATORIES LLC 4154 AP 1294 04/30/2018 April A/P Effluent sampling 246.00 20,529.42 OXIDOR LABORATORIES LLC 4154 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,202.60 20,529.42 ** 30,000.00 Budgeted 9,470.58 Remaining 68 % Used Account: 135-60010-020-000 Communications/Mobiles 2,865.72 .00 2,865.72 _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: .00 2,865.72 ** 4,700.00 Budgeted 1,834.28 Remaining 61 % Used Account: 135-60020-020-000 Electricity 1242 04/24/2018 April A/P Electricity 3/9-4/10 86,385.16 12,817.74 99,202.90 HUDSON ENERGY SERVICES, LLC 4134 AP 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (156.54) 99,046.36 AR 1357 04/30/2018 April A/P Electricity 3/26-4/24 169.98 99,216.34 TRI COUNTY ELECTRIC 4191 AP 1357 04/30/2018 April A/P Electricity 3/26-4/24 289.90 99,506.24 TRI COUNTY ELECTRIC 4191 AP 1357 04/30/2018 April A/P Electricity 3/26-4/24 27.81 99,534.05 TRI COUNTY ELECTRIC 4191 AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,148.89 99,534.05 ** 266,709.00 Budgeted 167,174.95 Remaining 37 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 222.00 .00 222.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 222.00 ** 5,677.00 Budgeted 5,455.00 Remaining 4 % Used Account: 135-60090-020-000 Safety Program 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAFETY POSTER HOLDINGS 8.37 156.65 165.02 SAFETY POSTER HOLDINGS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 186.70 351.72 AMAZON.COM PC _______________ Account: 135-60090-020-000 Safety Program Totals: 343.35 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 NTTA CALL CENTER 73.06 17.40 90.46 NTTA CALL CENTER PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 17.40 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1294 04/30/2018 April A/P April mowing 2,360.00 1,180.00 3,540.00 WATTS ELLISON LLC 4156 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 3,540.00 ** 11,600.00 Budgeted 8,060.00 Remaining 31 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1305 04/30/2018 Texpool Transfers April 66,568.86 11,094.81 77,663.67 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 77,663.67 ** 122,043.00 Budgeted 44,379.33 Remaining 64 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1305 04/30/2018 Texpool Transfers April 326,584.32 54,430.72 381,015.04 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 381,015.04 ** 598,738.00 Budgeted 217,722.96 Remaining 64 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1305 04/30/2018 Texpool Transfers April 61,668.00 10,278.00 71,946.00 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 71,946.00 ** 123,336.00 Budgeted 51,390.00 Remaining 58 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 PEARCE OFFICE FURNITUR 354.00 354.00 PEARCE OFFICE FURNITUR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 PEARCE OFFICE FURNITUR 1,408.00 1,762.00 PEARCE OFFICE FURNITUR PC _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 1,762.00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 1258 04/26/2018 April A/P Fuel 4,735.44 604.75 5,340.19 US Bank Voyager Fleet Systems 4147 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 604.75 5,340.19 ** 12,500.00 Budgeted 7,159.81 Remaining 43 % 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 1146 04/05/2018 void due to incorrect amount 4 barrels of MBR chemicals 5,251.35 (684.72) 4,566.63 Valley Solvent Company, INC 4081 AP 1264 04/27/2018 April A/P MBR checmicals 874.60 5,441.23 Valley Solvent Company, INC 4148 AP 1264 04/27/2018 April A/P Container return credit (160.00) 5,281.23 Valley Solvent Company, INC 4148 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 29.88 5,281.23 ** 27,500.00 Budgeted 22,218.77 Remaining 19 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 1,138.99 10.95 1,149.94 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 10.95 1,149.94 ** 1,000.00 Budgeted (149.94) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 586.57 39.91 626.48 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TX AMERICA SAFETY 124.49 750.97 TX AMERICA SAFETY PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 164.40 750.97 ** 750.00 Budgeted (.97) Remaining 100 % Used Account: 135-65045-020-000 Lab Supplies 1193 04/13/2018 April A/P Testing supplies 7,839.46 221.81 8,061.27 HACH COMPANY 4103 AP 1242 04/24/2018 April A/P WWTP Quanti-tray sealer Care a 750.00 8,811.27 IDEXX DISTRIBUTION, INC 4135 AP 1242 04/24/2018 April A/P Lab supplies 213.87 9,025.14 HACH COMPANY 4132 AP 1242 04/24/2018 April A/P Lab supplies 1,473.56 10,498.70 IDEXX DISTRIBUTION, INC 4135 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TOM THUMB #1789 3.96 10,502.66 TOM THUMB #1789 PC 1357 04/30/2018 April A/P Coliform 197.92 10,700.58 IDEXX DISTRIBUTION, INC 4175 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,861.12 10,700.58 ** 14,000.00 Budgeted 3,299.42 Remaining 76 % Used Account: 135-69005-020-000 Capital Outlays 1174 04/04/2018 Correct Fund Cap Out- 135-517 309,455.78 (232,136.35) 77,319.43 GL 1193 04/13/2018 April A/P L.S. #2 panel 12,471.18 89,790.61 DHS AUTOMATION, INC 4100 AP 1258 04/26/2018 April A/P Legal WWTP 170.00 89,960.61 Dubois Bryant Campbell LLP 4129 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: (219,495.17) 89,960.61 ** 547,327.00 Budgeted 457,366.39 Remaining 16 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-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,268,309.22 ** (59,947.58) Monthly Total 2,981,140.00 Budgeted 1,712,830.78 Remaining 43 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 14.52 2.42 16.94 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 16.94 ** 30.00 Budgeted 13.06 Remaining 56 % 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 1258 04/26/2018 April A/P AWBD conference-Kelly Castongu 405.00 405.00 AWBD 4120 AP 1258 04/26/2018 April A/P AWBD conference-Steve Flynn 405.00 810.00 AWBD 4120 AP _______________ Account: 135-60075-026-000 Meetings Totals: 810.00 810.00 ** 1,200.00 Budgeted 390.00 Remaining 68 % Used Account: 135-60080-026-000 Schools & Training 1178 04/11/2018 April A/P AWBD Annual Conference-Rose 1,135.00 405.00 1,540.00 AWBD 4097 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 405.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 31 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 1,021.73 233.55 1,255.28 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 233.55 1,255.28 ** 2,000.00 Budgeted 744.72 Remaining 63 % Used Department 26 Totals: ----------------------------------- 5,232.22 ** 1,450.97 Monthly Total 12,980.00 Budgeted 7,747.78 Remaining 40 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 180,628.41 12,537.06 193,165.47 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 21,020.07 214,185.54 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,557.13 214,185.54 ** 432,863.00 Budgeted 218,677.46 Remaining 49 % Used Account: 135-50010-030-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 456.67 7.66 464.33 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 2.73 467.06 PR _______________ Account: 135-50010-030-000 Overtime Totals: 10.39 467.06 ** 2,000.00 Budgeted 1,532.94 Remaining 23 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1119 04/06/2018 MUD PR 04.06.18 Retirement 19,385.45 1,160.38 20,545.83 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 1,944.62 22,490.45 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,105.00 22,490.45 ** 40,553.00 Budgeted 18,062.55 Remaining 55 % Used Account: 135-50026-030-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 23,193.21 2,072.63 25,265.84 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 2,072.61 27,338.45 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 27,338.45 ** 63,485.00 Budgeted 36,146.55 Remaining 43 % Used Account: 135-50027-030-000 Dental Insurance 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 1,752.92 129.78 1,882.70 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 129.74 2,012.44 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,012.44 ** 5,502.00 Budgeted 3,489.56 Remaining 37 % Used Account: 135-50028-030-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 341.41 21.28 362.69 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 21.23 383.92 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 383.92 ** 1,173.00 Budgeted 789.08 Remaining 33 % Used Account: 135-50029-030-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 1,920.29 145.04 2,065.33 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 105.65 2,170.98 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 18.50 2,189.48 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 120.23 2,309.71 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 145.04 2,454.75 Humana Inc 4133 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 534.46 2,454.75 ** 5,059.00 Budgeted 2,604.25 Remaining 49 % Used Account: 135-50030-030-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 10,988.19 739.96 11,728.15 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 1,262.76 12,990.91 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,002.72 12,990.91 ** 27,181.00 Budgeted 14,190.09 Remaining 48 % Used Account: 135-50035-030-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 2,569.81 173.06 2,742.87 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 295.32 3,038.19 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 468.38 3,038.19 ** 6,357.00 Budgeted 3,318.81 Remaining 48 % Used Account: 135-50040-030-000 Unemployment Taxes 1119 04/06/2018 MUD PR 04.06.18 Unemployment Taxes 901.90 40.37 942.27 PR 1212 04/20/2018 MUD PR 04.20.18 Unemployment Taxes 41.50 983.77 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 81.87 983.77 ** 1,260.00 Budgeted 276.23 Remaining 78 % Used Account: 135-50045-030-000 Workman's Compensation 238 04/01/2018 Insurance/Wrk Comp Exp Apr 741.00 123.50 864.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 864.50 ** 1,529.00 Budgeted 664.50 Remaining 57 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 2,348.26 111.00 2,459.26 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 60.00 2,519.26 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TOM THUMB #1789 112.43 2,631.69 TOM THUMB #1789 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 30.00 2,661.69 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMS CLUB #6781 20.95 2,682.64 SAMS CLUB #6781 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WAYFAIR*BIRCHLANE 173.20 2,855.84 WAYFAIR*BIRCHLANE PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SUCCESSORIES 174.72 3,030.56 SUCCESSORIES PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 18.98 3,049.54 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WAYFAIR*BIRCHLANE 59.54 3,109.08 WAYFAIR*BIRCHLANE PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 760.82 3,109.08 ** 4,960.00 Budgeted 1,850.92 Remaining 63 % Used Account: 135-55030-030-000 Software & Support 1126 04/04/2018 April A/P Internet 44,486.55 903.72 45,390.27 Charter Communications 4041 AP 1126 04/04/2018 April A/P check scanner maintenance 425.00 45,815.27 TECHNIQUE DATA SYSTEMS INC 4077 AP 1126 04/04/2018 April A/P Annual license fee 600.00 46,415.27 Data Management Inc. 4044 AP 1178 04/11/2018 April A/P Internet 1,051.94 47,467.21 WHOLESALE CARRIER SERVICES INC 4118 AP 1242 04/24/2018 April A/P Office 365 license 168.00 47,635.21 M3 Networks 4141 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DNH*GODADDY.COM 239.88 47,875.09 DNH*GODADDY.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 CANVA FOR WORK MONTHLY 12.95 47,888.04 CANVA FOR WORK MONTHLY PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 63.59 47,951.63 ATT*BILL PAYMENT PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 44,486.55 85.71 48,037.34 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 49.82 48,087.16 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 102.27 48,189.43 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 118.82 48,308.25 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ADOBE SYSTEMS INC 16.23 48,324.48 ADOBE SYSTEMS INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 85.71 48,410.19 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 118.82 48,529.01 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 63.59 48,592.60 ATT*BILL PAYMENT PC 1258 04/26/2018 April A/P Software license 200.00 48,792.60 M3 Networks 4141 AP 1332 04/30/2018 April A/P Firewall hardware & 3 yrs supp 4,614.30 53,406.90 M3 Networks 4181 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 8,920.35 53,406.90 ** 78,391.00 Budgeted 24,984.10 Remaining 68 % Used Account: 135-55070-030-000 Independent Labor 1294 04/30/2018 April A/P GM-April 74,174.76 13,575.00 87,749.76 Carman Consulting LLC. 4151 AP 1294 04/30/2018 April A/P GM-April 26.16 87,775.92 Carman Consulting LLC. 4151 AP 1332 04/30/2018 April A/P April 2018 consulting 46.67 87,822.59 DRG ENTERPRISES 4172 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 13,647.83 87,822.59 ** 154,000.00 Budgeted 66,177.41 Remaining 57 % Used Account: 135-55080-030-000 Maintenance & Repairs 1242 04/24/2018 April A/P A/C work 2,475.73 2,232.00 4,707.73 BRANDON R REED 4122 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 46.27 4,754.00 STAPLES 00116533 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB #6781 314.51 5,068.51 SAMSCLUB #6781 PC 1275 04/30/2018 April A/P office supplies 42.67 5,111.18 OFFICE DEPOT, INC 4149 AP 1275 04/30/2018 April A/P Office supplies 34.99 5,146.17 OFFICE DEPOT, INC 4149 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 2,670.44 5,146.17 ** 14,000.00 Budgeted 8,853.83 Remaining 37 % Used Account: 135-55085-030-000 Generator Maint. and Repair 1242 04/24/2018 April A/P Repair to office generator 3,955.00 3,955.00 Sluder Emergency Power Service 4145 AP _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: 3,955.00 3,955.00 ** 10,000.00 Budgeted 6,045.00 Remaining 40 % Used Account: 135-55120-030-000 Cleaning Services . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1242 04/24/2018 April A/P Janitorial services 3,962.39 869.06 4,831.45 MEMBER'S BUILDING MAINTENANCE 4142 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 4,831.45 ** 10,000.00 Budgeted 5,168.55 Remaining 48 % 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 1332 04/30/2018 April A/P April mailings 3,951.79 177.94 4,129.73 DATAPROSE LLC 4171 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 177.94 4,129.73 ** 9,000.00 Budgeted 4,870.27 Remaining 46 % Used Account: 135-60005-030-000 Telephone 1242 04/24/2018 April A/P Answering service 7,417.68 216.80 7,634.48 KEYSTONE PARK SECRETARIAL 4138 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 190.78 7,825.26 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 852.62 8,677.88 ATT*BUS PHONE PMT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 851.23 9,529.11 ATT*BUS PHONE PMT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RINGCENTRAL, INC 13.96 9,543.07 RINGCENTRAL, INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 191.10 9,734.17 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 453.37 10,187.54 ATT*BUS PHONE PMT PC 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (180.00) 10,007.54 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,589.86 10,007.54 ** 27,300.00 Budgeted 17,292.46 Remaining 37 % Used Account: 135-60010-030-000 Communications/Mobiles 1212 04/20/2018 MUD PR 04.20.18 Communications/Mobiles 1,649.43 150.00 1,799.43 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60010-030-000 Communications/Mobiles Totals: 150.00 1,799.43 ** 4,000.00 Budgeted 2,200.57 Remaining 45 % Used Account: 135-60020-030-000 Electricity/Gas 1332 04/30/2018 April A/P 2/8-3/9/18 Electricity admin 3,106.68 745.53 3,852.21 TOWN OF TROPHY CLUB 4190 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 745.53 3,852.21 ** 16,261.00 Budgeted 12,408.79 Remaining 24 % Used Account: 135-60025-030-000 Water 1294 04/30/2018 April A/P April water 339.12 116.64 455.76 TROPHY CLUB MUD (WATER BILLS) 4155 AP 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (58.32) 397.44 AR _______________ Account: 135-60025-030-000 Water Totals: 58.32 397.44 ** 2,500.00 Budgeted 2,102.56 Remaining 16 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 1242 04/24/2018 April A/P Postage lease 12,665.27 97.65 12,762.92 FRANCOTYP-POSTALIA, INC. 4131 AP 1258 04/26/2018 April A/P Overnight letter-AWBD 6.53 12,769.45 FEDERAL EXPRESS CORP 4130 AP 1258 04/26/2018 April A/P Overnight letter-Compliance mo 57.50 12,826.95 FEDERAL EXPRESS CORP 4130 AP 1258 04/26/2018 April A/P Overnight letter-Scoop 19.63 12,846.58 FEDERAL EXPRESS CORP 4130 AP 1332 04/30/2018 April A/P April mailings 131.13 12,977.71 DATAPROSE LLC 4171 AP _______________ Account: 135-60035-030-000 Postage Totals: 312.44 12,977.71 ** 30,000.00 Budgeted 17,022.29 Remaining 43 % Used Account: 135-60040-030-000 Service Charges & Fees 1120 04/06/2018 Child Support Fee 29,796.12 1.50 29,797.62 GL 1213 04/20/2018 Child Support Fee 1.50 29,799.12 GL 1248 04/30/2018 Pace Credit Card Fees 4,361.87 34,160.99 GL 1248 04/30/2018 Pace Credit Card Fees 142.23 34,303.22 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1332 04/30/2018 April A/P Direct send fees 29,796.12 50.00 34,353.22 Fiserv Solutions, LLC 4173 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,557.10 34,353.22 ** 55,560.00 Budgeted 21,206.78 Remaining 62 % 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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 39,877.16 6,100.36 45,977.52 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 45,977.52 ** 56,000.00 Budgeted 10,022.48 Remaining 82 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 206.38 206.38 AMAZON.COM PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 206.38 206.38 ** 1,600.00 Budgeted 1,393.62 Remaining 13 % Used 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 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-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 1156 04/06/2018 April A/P STW training-Timi & Taylor 2,693.00 450.00 3,143.00 STW INC 4093 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 450.00 3,143.00 ** 7,600.00 Budgeted 4,457.00 Remaining 41 % Used Account: 135-60100-030-000 Travel & per diem 1119 04/06/2018 MUD PR 04.06.18 Travel & per diem 599.83 111.29 711.12 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 111.29 711.12 ** 4,885.00 Budgeted 4,173.88 Remaining 15 % 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 1332 04/30/2018 April A/P Election notice 145.00 75.00 220.00 Teneo Linquistics Company, LLC 4188 AP _______________ Account: 135-60115-030-000 Elections Totals: 75.00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 YOURMEMBER-CAREERS 150.00 150.00 YOURMEMBER-CAREERS PC _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 150.00 ** 2,500.00 Budgeted 2,350.00 Remaining 6 % Used Account: 135-60235-030-000 Security 1242 04/24/2018 April A/P Monthly monitoring fee for pan 72.00 24.00 96.00 Digital Air Control, Inc 4127 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60235-030-000 Security Totals: 24.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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 137.74 (147.21) (9.47) RED WING SHOES #652 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 147.21 137.74 RED WING SHOES #652 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 135.99 273.73 RED WING SHOES #652 PC _______________ Account: 135-65010-030-000 Uniforms Totals: 135.99 273.73 ** 700.00 Budgeted 426.27 Remaining 39 % Used Account: 135-65055-030-000 Hardware 1178 04/11/2018 April A/P Nicole's computer replacement 597.95 910.99 1,508.94 M3 Networks 4106 AP _______________ Account: 135-65055-030-000 Hardware Totals: 910.99 1,508.94 ** 7,420.00 Budgeted 5,911.06 Remaining 20 % Used Account: 135-65085-030-000 Office Supplies . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES DIRECT 2,876.21 59.99 2,936.20 STAPLES DIRECT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 56.84 2,993.04 STAPLES 00116533 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ZAPCO, INC 87.31 3,080.35 ZAPCO, INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DESKTOP SUPPLIES.COM 71.00 3,151.35 DESKTOP SUPPLIES.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 18.98 3,170.33 STAPLES 00116533 PC 1275 04/30/2018 April A/P Office supplies 152.07 3,322.40 OFFICE DEPOT, INC 4149 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 446.19 3,322.40 ** 7,000.00 Budgeted 3,677.60 Remaining 47 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WALMART.COM 2,822.39 50.22 2,872.61 WALMART.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 65.72 2,938.33 AMAZON.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB.COM 46.96 2,985.29 SAMSCLUB.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 73.58 3,058.87 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 35.85 3,094.72 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB.COM 23.48 3,118.20 SAMSCLUB.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 67.55 3,185.75 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 363.36 3,185.75 ** 4,000.00 Budgeted 814.25 Remaining 80 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 1126 04/04/2018 April A/P Security Project 7,841.00 20,986.32 28,827.32 3RD EYE SURVEILLANCE SYSTEMS 4036 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 20,986.32 28,827.32 ** 13,000.00 Budgeted (15,827.32) Remaining 222 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-69170-030-000 Copier Lease Installments 1193 04/13/2018 April A/P Copier lease 1,476.14 165.00 1,641.14 EVERBANK COMMERCIAL FINANCE 4101 AP 1242 04/24/2018 April A/P Copies/lease 83.39 1,724.53 KYOCERA DOCUMENT SOLUTIONS 4139 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 248.39 1,724.53 ** 4,600.00 Budgeted 2,875.47 Remaining 37 % Used Department 30 Totals: ----------------------------------- 672,280.18 ** 113,953.68 Monthly Total 1,227,112.00 Budgeted 554,831.82 Remaining 55 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 1358 04/30/2018 April A/P Legal 36,813.55 4,890.00 41,703.55 McLean & Howard, L.L.P. 4182 AP 1358 04/30/2018 April A/P legal 1,050.00 42,753.55 McLean & Howard, L.L.P. 4182 AP _______________ Account: 135-55045-039-000 Legal Totals: 5,940.00 42,753.55 ** 137,000.00 Budgeted 94,246.45 Remaining 31 % Used Account: 135-55055-039-000 Auditing 25,508.70 .00 25,508.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 6,672.05 .00 6,672.05 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,672.05 ** 11,446.00 Budgeted 4,773.95 Remaining 58 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 77,902.70 ** 5,940.00 Monthly Total 176,746.00 Budgeted 98,843.30 Remaining 44 % Used Fund 135 Totals: ----------------------------------- (191,106.62) (12,209.43) Monthly Total (194,618.00) Budgeted (3,511.38) Remaining 98 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 APRIL 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 109,941 ACCOUNTS RECEIVABLE - TOTAL ASSETS 109,941 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 707,654 TOTAL LIABILITIES 707,654 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,590,291) TOTAL FUND BALANCE (597,712) TOTAL LIABILITIES AND FUND BALANCE 109,941 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 20:48 05/10/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 487.43- 9,193.27- 9,193.27 Subtotal: 487.43- 9,193.27- 9,193.27 Program number: 487.43- 9,193.27- 9,193.27 Department number: Revenues 487.43- 9,193.27- 9,193.27 Revenues Subtotal ----------- 487.43- 9,193.27- 9,193.27 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 20:48 05/10/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 281,432.20 1,599,484.53 1,599,484.53- Subtotal: 281,432.20 1,599,484.53 1,599,484.53- Program number: 281,432.20 1,599,484.53 1,599,484.53- Department number: Wastewater 281,432.20 1,599,484.53 1,599,484.53- Expenditures Subtotal ----------- 281,432.20 1,599,484.53 1,599,484.53- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 280,944.77 1,590,291.26 1,590,291.26- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (8,705.84) (487.43) (9,193.27) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (487.43) (9,193.27) ** .00 Budgeted 9,193.27 Remaining 0 % Used Department Totals: ----------------------------------- (9,193.27) ** (487.43) Monthly Total .00 Budgeted 9,193.27 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1174 04/04/2018 Correct Fund Cap Out- 135-517 1,318,052.33 232,136.35 1,550,188.68 GL 1201 04/16/2018 April A/P WWTP Improvements 22,090.04 1,572,278.72 CP&Y/WALLACE GROUP, INC. 4099 AP 1265 04/30/2018 Webber App 27 Retainage Update 3,250.38 1,575,529.10 GL 1364 04/30/2018 April A/P WWTP improvements 4/1-4/30 23,955.43 1,599,484.53 CP&Y/WALLACE GROUP, INC. 4170 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 281,432.20 1,599,484.53 ** .00 Budgeted (1,599,484.53) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,599,484.53 ** 281,432.20 Monthly Total .00 Budgeted (1,599,484.53) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,590,291.26 280,944.77 Monthly Total .00 Budgeted (1,590,291.26) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET APRIL 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK 1,053,984 CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,803,369 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 (2,435,369) TOTAL FUND BALANCE 1,790,211 TOTAL LIABILITIES AND FUND BALANCE 1,803,369 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 20:48 05/10/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 49.30- 49.30- 49.30 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08- 1,053,935.08 Subtotal: 1,053,984.38- 1,053,984.38- 1,053,984.38 Program number: 1,053,984.38- 1,053,984.38- 1,053,984.38 Department number: Revenues 1,053,984.38- 1,053,984.38- 1,053,984.38 Revenues Subtotal ----------- 1,053,984.38- 1,053,984.38- 1,053,984.38 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 20:48 05/10/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 796,145.08 796,145.08 796,145.08- Subtotal: 796,145.08 796,145.08 796,145.08- 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: 796,145.08 3,489,353.76 3,489,353.76- Department number: Water 796,145.08 3,489,353.76 3,489,353.76- Expenditures Subtotal ----------- 796,145.08 3,489,353.76 3,489,353.76- Fund number: 519 2016 Rev Bond Const-SWIFT 257,839.30- 2,435,369.38 2,435,369.38- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (49.30) (49.30) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (49.30) (49.30) ** .00 Budgeted 49.30 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund 1306 04/30/2018 Swift Fund Deposit TexPool Transfer from Gen to Swift 1,053,935.08 1,053,935.08 GL 1369 04/30/2018 Correcting JE 1306 Swift Cash Reverse JE 1306 (1,053,935.08) .00 GL 1369 04/30/2018 Correcting JE 1306 Swift Cash (1,053,935.08) (1,053,935.08) GL _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: (1,053,935.08) (1,053,935.08) ** .00 Budgeted 1,053,935.08 Remaining 0 % Used Department Totals: ----------------------------------- (1,053,984.38) ** (1,053,984.38) Monthly Total .00 Budgeted 1,053,984.38 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 4/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 1306 04/30/2018 Swift Fund Deposit TexPool Wire from Escrow to Gen TexPl 796,145.08 796,145.08 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: 796,145.08 796,145.08 ** .00 Budgeted (796,145.08) 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: ----------------------------------- 3,489,353.76 ** 796,145.08 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 2,435,369.38 (257,839.30) Monthly Total .00 Budgeted (2,435,369.38) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET APRIL 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 APRIL 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 530,696 ACCOUNTS RECEIVABLE - TOTAL ASSETS 530,696 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 104,118 TOTAL FUND BALANCE 530,696 TOTAL LIABILITIES AND FUND BALANCE 530,696 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 20:48 05/10/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/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- 708.57- 3,590.84- 359.084 2,590.84 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 28,581.00- 58.333 20,415.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 71,946.00- 58.333 51,390.00- Subtotal: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Program number: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Department number: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (2,882.27) (708.57) (3,590.84) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (708.57) (3,590.84) ** (1,000.00) Budgeted 2,590.84 Remaining 359 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1305 04/30/2018 Texpool Transfers April (24,498.00) (4,083.00) (28,581.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (28,581.00) ** (48,996.00) Budgeted (20,415.00) Remaining 58 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1305 04/30/2018 Texpool Transfers April (61,668.00) (10,278.00) (71,946.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (71,946.00) ** (123,336.00) Budgeted (51,390.00) Remaining 58 % Used Department Totals: ----------------------------------- (104,117.84) ** (15,069.57) Monthly Total (173,332.00) Budgeted (69,214.16) Remaining 60 % Used Fund 528 Totals: ----------------------------------- (104,117.84) (15,069.57) Monthly Total (173,332.00) Budgeted (69,214.16) Remaining 60 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 854,815 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 19,714 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 879,101 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 19,714 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 19,714 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 827,047 TOTAL FUND BALANCE 859,387 TOTAL LIABILITIES AND FUND BALANCE 879,101 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 20:48 05/10/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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- 2,038.30- 666,345.68- 99.505 3,314.32- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 303.24- 2,334.05- 129.669 534.05 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 179.12- 1,201.02- 60.051 798.98- Subtotal: 673,460.00- 673,460.00- 2,520.66- 669,880.75- 99.469 3,579.25- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,156.06- 3,751.91- 187.596 1,751.91 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- 77,663.67- 63.636 44,379.33- Subtotal: 342,997.00- 342,997.00- 12,250.87- 300,369.58- 87.572 42,627.42- Program number: 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- Department number: Revenues 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 20:48 05/10/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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,250.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 1,250.00 143,203.75 14.169 867,454.25 Program number: 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Department number: Administration 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 13,521.53- 827,046.58- ############### 821,247.58 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (664,307.38) (844.98) (665,152.36) GL 1312 04/03/2018 Property Taxes (241.13) (665,393.49) GL 1313 04/04/2018 Property Taxes (127.66) (665,521.15) GL 1314 04/05/2018 Property Taxes (222.57) (665,743.72) GL 1315 04/06/2018 Property Taxes (154.94) (665,898.66) GL 1316 04/16/2018 Property Taxes (87.34) (665,986.00) GL 1317 04/18/2018 Property Taxes (40.57) (666,026.57) GL 1318 04/20/2018 Property Taxes 392.67 (665,633.90) GL 1319 04/23/2018 Property Taxes (130.16) (665,764.06) GL 1320 04/24/2018 Property Taxes (114.36) (665,878.42) GL 1321 04/25/2018 Property Taxes (2.67) (665,881.09) GL 1322 04/26/2018 Property Taxes (151.30) (666,032.39) GL 1323 04/27/2018 Property Taxes (120.64) (666,153.03) GL 1324 04/30/2018 Property Taxes (192.65) (666,345.68) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (915.33) (667,261.01) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 915.33 (666,345.68) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,038.30) (666,345.68) ** (669,660.00) Budgeted (3,314.32) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1311 04/02/2018 Property Taxes (2,030.81) (64.81) (2,095.62) GL 1316 04/16/2018 Property Taxes (81.06) (2,176.68) GL 1319 04/23/2018 Property Taxes (.01) (2,176.69) GL 1321 04/25/2018 Property Taxes (157.36) (2,334.05) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (303.24) (2,334.05) ** (1,800.00) Budgeted 534.05 Remaining 130 % Used Account: 533-40015-000-000 Property Taxes/P & I 1311 04/02/2018 Property Taxes (1,021.90) (58.40) (1,080.30) GL 1312 04/03/2018 Property Taxes (.63) (1,080.93) GL 1313 04/04/2018 Property Taxes (1.27) (1,082.20) GL 1314 04/05/2018 Property Taxes (15.97) (1,098.17) GL 1315 04/06/2018 Property Taxes (9.17) (1,107.34) GL 1316 04/16/2018 Property Taxes (23.64) (1,130.98) GL 1317 04/18/2018 Property Taxes (5.95) (1,136.93) GL 1319 04/23/2018 Property Taxes (14.32) (1,151.25) GL 1320 04/24/2018 Property Taxes (2.67) (1,153.92) GL 1321 04/25/2018 Property Taxes (14.46) (1,168.38) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1322 04/26/2018 Property Taxes (1,021.90) (2.42) (1,170.80) GL 1323 04/27/2018 Property Taxes (13.27) (1,184.07) GL 1324 04/30/2018 Property Taxes (16.95) (1,201.02) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .13 (1,200.89) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.13) (1,201.02) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (179.12) (1,201.02) ** (2,000.00) Budgeted (798.98) Remaining 60 % Used Account: 533-49010-000-000 Interest Income 1304 04/30/2018 Bank Interest- April (2,595.85) (1,156.06) (3,751.91) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,156.06) (3,751.91) ** (2,000.00) Budgeted 1,751.91 Remaining 188 % 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 1305 04/30/2018 Texpool Transfers April (66,568.86) (11,094.81) (77,663.67) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (77,663.67) ** (122,043.00) Budgeted (44,379.33) Remaining 64 % Used Department Totals: ----------------------------------- (970,250.33) ** (14,771.53) Monthly Total (1,016,457.00) Budgeted (46,206.67) Remaining 95 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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 1096 04/04/2018 3/1/18 Bond Paying Agent Fee TCMUD1-10 200.00 750.00 950.00 GL 1096 04/04/2018 3/1/18 Bond Paying Agent Fee TCMUD1-12 500.00 1,450.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,250.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 ** 1,250.00 Monthly Total 1,010,658.00 Budgeted 867,454.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (827,046.58) (13,521.53) Monthly Total (5,799.00) Budgeted 821,247.58 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 286,547 ACCOUNTS RECEIVABLE - TOTAL ASSETS 286,547 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 270,337 TOTAL FUND BALANCE 286,547 TOTAL LIABILITIES AND FUND BALANCE 286,547 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 20:48 05/10/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/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- 320.81- 1,190.90- 119.090 190.90 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 381,015.04- 63.636 217,722.96- Subtotal: 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Program number: 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Department number: Revenues 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 20:48 05/10/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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,751.53- 270,337.19- ############### 269,337.19 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (870.09) (320.81) (1,190.90) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (320.81) (1,190.90) ** (1,000.00) Budgeted 190.90 Remaining 119 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1305 04/30/2018 Texpool Transfers April (326,584.32) (54,430.72) (381,015.04) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (381,015.04) ** (598,738.00) Budgeted (217,722.96) Remaining 64 % Used Department Totals: ----------------------------------- (382,205.94) ** (54,751.53) Monthly Total (599,738.00) Budgeted (217,532.06) Remaining 64 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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: ----------------------------------- (270,337.19) (54,751.53) Monthly Total (1,000.00) Budgeted 269,337.19 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 146,935 ACCOUNTS RECEIVABLE - TOTAL ASSETS 146,935 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 145,983 TOTAL FUND BALANCE 146,935 TOTAL LIABILITIES AND FUND BALANCE 146,935 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 20:48 05/10/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/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- 167.99- 562.45- 93.742 37.55- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 176,962.17- 63.636 101,121.83- Subtotal: 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Program number: 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Department number: Revenues 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 20:48 05/10/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/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,448.30- 145,982.87- ############### 145,382.87 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (394.46) (167.99) (562.45) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (167.99) (562.45) ** (600.00) Budgeted (37.55) Remaining 94 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1305 04/30/2018 Texpool Transfers April (151,681.86) (25,280.31) (176,962.17) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (176,962.17) ** (278,084.00) Budgeted (101,121.83) Remaining 64 % Used Department Totals: ----------------------------------- (177,524.62) ** (25,448.30) Monthly Total (278,684.00) Budgeted (101,159.38) Remaining 64 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/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: ----------------------------------- (145,982.87) (25,448.30) Monthly Total (600.00) Budgeted 145,382.87 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,037,565.14 **** (49,812.67) Monthly Total (375,349.00) Budgeted (2,412,914.14) Remaining ########## ******* End of Report *********