Loading...
HomeMy WebLinkAbout2016-04 April Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2016 122 ASSETS FIRE DEPT. CASH IN BANK 5,178 INVESTMENTS 921,733 PREPAID EXPENSES 5,865 ADVALOREM PROPERTY TAXES RECEIVABLE 47,693 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 584 TOTAL ASSETS 981,053 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 47,693 ACCOUNTS AND OTHER PAYABLES 22,596 TOTAL LIABILITIES 70,289 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 377,267 TOTAL FUND BALANCE 910,764 TOTAL LIABILITIES AND FUND BALANCE 981,053 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:37 05/05/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 8,171.59 863,463.89- 97.022 26,499.11- 122-40011-000-000 Property Taxes/Fire-Delinquent 365.20- 2,593.58- 2,593.58 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 472.39- 3,436.72- 76.372 1,063.28- Subtotal: 1,299,559.00- 1,298,809.00- 7,334.00 1,241,130.59- 95.559 57,678.41- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 4,000.00- 80.000 1,000.00- Subtotal: 5,000.00- 5,000.00- 4,000.00- 80.000 1,000.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 850.00- 103.030 25.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,825.00- 10,825.00- 10,850.00- 100.231 25.00 122-49026-000-000 Proceeds from Sale of Assets 60,000.00- 60,000.00- 100.000 122-49900-000-000 Miscellaneous Income 50,000.00- 10,001.00- 8,500.00- 84.992 1,501.00- Subtotal: 50,000.00- 70,001.00- 68,500.00- 97.856 1,501.00- Program number: 1,365,384.00- 1,384,635.00- 7,334.00 1,324,480.59- 95.656 60,154.41- Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 7,334.00 1,324,480.59- 95.656 60,154.41- Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 7,334.00 1,324,480.59- 95.656 60,154.41- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:37 05/05/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 41,576.54 264,738.03 52.091 243,487.97 122-50010-045-000 Overtime 48,735.00 48,735.00 8,273.15 38,304.53 78.598 10,430.47 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 450.00 2,040.13 48.575 2,159.87 122-50020-045-000 Retirement 75,571.00 75,571.00 6,364.00 40,788.43 53.974 34,782.57 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,895.29 30,633.13 46.735 34,912.87 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 390.89 2,919.55 59.766 1,965.45 122-50028-045-000 Vision Insurance 859.00 859.00 74.08 594.22 69.176 264.78 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 350.20 2,146.34 46.812 2,438.66 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,911.93 18,884.07 52.264 17,247.93 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 680.82 4,415.29 52.252 4,034.71 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 50.25 1,990.21 99.511 9.79 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 54.00 21.600 196.00 Subtotal: 790,155.00 790,431.00 66,017.15 427,955.46 54.142 362,475.54 122-55030-045-000 Software & Support 6,661.00 6,661.00 10.81 2,785.81 41.823 3,875.19 122-55045-045-000 Legal 2,000.00 5,000.00 6,559.50 6,559.50 131.190 1,559.50- 122-55080-045-000 Maintenance & Repairs 16,370.00 25,218.00 1,101.43 16,920.85 67.098 8,297.15 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 1,750.61 7,449.56 74.496 2,550.44 122-55160-045-000 Professional Outside Services 2,743.80 2,743.80 2,743.80- Subtotal: 35,031.00 46,879.00 12,166.15 36,459.52 77.774 10,419.48 122-60005-045-000 Telephone 50.00 50.00 10.44 33.04 66.080 16.96 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 173.20 5,406.07 70.154 2,299.93 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 418.07 2,569.70 34.669 4,842.30 122-60025-045-000 Water 1,200.00 1,200.00 129.12 926.93 77.244 273.07 122-60026-045-000 Cable 1,920.00 1,920.00 293.23 1,346.51 70.131 573.49 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 100.000 122-60035-045-000 Postage 50.00 50.00 7.97 15.940 42.03 122-60055-045-000 Insurance 14,077.00 18,451.00 1,173.08 12,585.34 68.210 5,865.66 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 172.05 49.157 177.95 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 15,456.59 99.195 125.41 122-60080-045-000 Schools & Training 7,880.00 6,880.00 50.00 2,433.39 35.369 4,446.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 2,081.00 958.34 46.052 1,122.66 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 4,700.00 4,200.00 89.362 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 1,185.00 1,574.50 49.450 1,609.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:37 05/05/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 88.87 580.01 57.943 420.99 Subtotal: 292,019.00 298,646.00 3,521.01 263,677.12 88.291 34,968.88 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 342.79 2,537.32 16.779 12,584.68 122-65010-045-000 Uniforms 3,140.00 3,640.00 3,011.32 82.729 628.68 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 2,885.76 32.064 6,114.24 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 1,862.37 93.119 137.63 122-65055-045-000 Hardware 750.00 750.00 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 60.26 12.052 439.74 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 342.79 10,552.45 32.863 21,557.55 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 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: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,384,635.00 82,047.10 947,213.15 68.409 437,421.85 Department number: Fire 1,365,384.00 1,384,635.00 82,047.10 947,213.15 68.409 437,421.85 Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 82,047.10 947,213.15 68.409 437,421.85 Fund number: 122 Trophy Club MUD Fire Dept. 89,381.10 377,267.44- 377,267.44 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs (371,290.86) .00 (371,290.86) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (371,290.86) ** (404,346.00) Budgeted (33,055.14) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (345.54) .00 (345.54) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1449 04/01/2016 Property Taxes (871,635.48) (83.57) (871,719.05) GL 1450 04/04/2016 Property Taxes (682.20) (872,401.25) GL 1451 04/05/2016 Property Taxes (1,006.15) (873,407.40) GL 1452 04/06/2016 Property Taxes (114.51) (873,521.91) GL 1453 04/07/2016 Property Taxes (599.30) (874,121.21) GL 1454 04/08/2016 Property Taxes (66.82) (874,188.03) GL 1455 04/11/2016 Property Taxes (301.99) (874,490.02) GL 1456 04/12/2016 Property Taxes (13.25) (874,503.27) GL 1458 04/19/2016 Property Taxes (61.38) (874,564.65) GL 1459 04/21/2016 Property Taxes 304.08 (874,260.57) GL 1497 04/22/2016 Property Taxes (413.17) (874,673.74) GL 1460 04/25/2016 Property Taxes (181.31) (874,855.05) GL 1486 04/29/2016 April A/P Refund Tax Shortage 11,672.05 (863,183.00) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (280.89) (863,463.89) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: 8,171.59 (863,463.89) ** (889,963.00) Budgeted (26,499.11) Remaining 97 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1455 04/11/2016 Property Taxes (2,228.38) (175.93) (2,404.31) GL 1457 04/13/2016 Property Taxes (8.54) (2,412.85) GL 1459 04/21/2016 Property Taxes 246.31 (2,166.54) GL 1497 04/22/2016 Property Taxes 13.34 (2,153.20) GL 1486 04/29/2016 April A/P Refund Tax Shortage (207.08) (2,360.28) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (233.30) (2,593.58) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (365.20) (2,593.58) ** .00 Budgeted 2,593.58 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40020-000-000 Property Taxes/Fire P&I 1450 04/04/2016 Property Taxes (2,964.33) (2.09) (2,966.42) GL 1451 04/05/2016 Property Taxes (76.82) (3,043.24) GL 1452 04/06/2016 Property Taxes .04 (3,043.20) GL 1453 04/07/2016 Property Taxes (47.54) (3,090.74) GL 1454 04/08/2016 Property Taxes (9.66) (3,100.40) GL 1455 04/11/2016 Property Taxes (56.36) (3,156.76) GL 1457 04/13/2016 Property Taxes (22.73) (3,179.49) GL 1459 04/21/2016 Property Taxes (3.41) (3,182.90) GL 1497 04/22/2016 Property Taxes (49.08) (3,231.98) GL 1486 04/29/2016 April A/P Refund Tax Shortage (118.06) (3,350.04) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (86.68) (3,436.72) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (472.39) (3,436.72) ** (4,500.00) Budgeted (1,063.28) Remaining 76 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (4,000.00) .00 (4,000.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (4,000.00) ** (5,000.00) Budgeted (1,000.00) Remaining 80 % Used Account: 122-43400-000-000 Fire Inspections (850.00) .00 (850.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (850.00) ** (825.00) Budgeted 25.00 Remaining 103 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49026-000-000 Proceeds from Sale of Assets (60,000.00) .00 (60,000.00) _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: .00 (60,000.00) ** (60,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49900-000-000 Miscellaneous Income (8,500.00) .00 (8,500.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (8,500.00) ** (10,001.00) Budgeted (1,501.00) Remaining 85 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,324,480.59) ** (1,384,635.00) Budgeted (60,154.41) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1336 04/08/2016 Fire Dept Payroll 4/8/16 223,161.49 18,877.47 242,038.96 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 5,978.71 248,017.67 GL 1423 04/22/2016 Fire Payroll 4/22/16 16,720.36 264,738.03 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 41,576.54 264,738.03 ** 508,226.00 Budgeted 243,487.97 Remaining 52 % Used Account: 122-50010-045-000 Overtime 1336 04/08/2016 Fire Dept Payroll 4/8/16 30,031.38 4,966.01 34,997.39 GL 1423 04/22/2016 Fire Payroll 4/22/16 3,307.14 38,304.53 GL _______________ Account: 122-50010-045-000 Overtime Totals: 8,273.15 38,304.53 ** 48,735.00 Budgeted 10,430.47 Remaining 79 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,717.53 .00 14,717.53 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,717.53 ** 15,852.00 Budgeted 1,134.47 Remaining 93 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 1336 04/08/2016 Fire Dept Payroll 4/8/16 1,590.13 450.00 2,040.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 450.00 2,040.13 ** 4,200.00 Budgeted 2,159.87 Remaining 49 % Used Account: 122-50020-045-000 Retirement 1336 04/08/2016 Fire Dept Payroll 4/8/16 34,424.43 3,097.31 37,521.74 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 762.28 38,284.02 GL 1423 04/22/2016 Fire Payroll 4/22/16 2,504.41 40,788.43 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 6,364.00 40,788.43 ** 75,571.00 Budgeted 34,782.57 Remaining 54 % Used Account: 122-50026-045-000 Medical Insurance 1336 04/08/2016 Fire Dept Payroll 4/8/16 25,737.84 2,800.77 28,538.61 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 222.15 28,760.76 GL 1423 04/22/2016 Fire Payroll 4/22/16 1,872.37 30,633.13 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,895.29 30,633.13 ** 65,546.00 Budgeted 34,912.87 Remaining 47 % Used Account: 122-50027-045-000 Dental Insurance 1336 04/08/2016 Fire Dept Payroll 4/8/16 2,528.66 195.43 2,724.09 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 11.80 2,735.89 GL 1423 04/22/2016 Fire Payroll 4/22/16 183.66 2,919.55 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 390.89 2,919.55 ** 4,885.00 Budgeted 1,965.45 Remaining 60 % Used Account: 122-50028-045-000 Vision Insurance 1336 04/08/2016 Fire Dept Payroll 4/8/16 520.14 37.00 557.14 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 2.87 560.01 GL 1423 04/22/2016 Fire Payroll 4/22/16 34.21 594.22 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 74.08 594.22 ** 859.00 Budgeted 264.78 Remaining 69 % Used Account: 122-50029-045-000 Life Insurance & Other 1336 04/08/2016 Fire Dept Payroll 4/8/16 1,796.14 175.05 1,971.19 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 14.60 1,985.79 GL 1423 04/22/2016 Fire Payroll 4/22/16 160.55 2,146.34 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 350.20 2,146.34 ** 4,585.00 Budgeted 2,438.66 Remaining 47 % Used Account: 122-50030-045-000 Social Security Taxes 1336 04/08/2016 Fire Dept Payroll 4/8/16 15,972.14 1,402.86 17,375.00 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 15,972.14 357.42 17,732.42 GL 1423 04/22/2016 Fire Payroll 4/22/16 1,151.65 18,884.07 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,911.93 18,884.07 ** 36,132.00 Budgeted 17,247.93 Remaining 52 % Used Account: 122-50035-045-000 Medicare Taxes 1336 04/08/2016 Fire Dept Payroll 4/8/16 3,734.47 327.97 4,062.44 GL 1390 04/11/2016 Supplemental P/R 4/3-4/8/16 83.59 4,146.03 GL 1423 04/22/2016 Fire Payroll 4/22/16 269.26 4,415.29 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 680.82 4,415.29 ** 8,450.00 Budgeted 4,034.71 Remaining 52 % Used Account: 122-50040-045-000 Unemployment Taxes 1336 04/08/2016 Fire Dept Payroll 4/8/16 1,939.96 22.40 1,962.36 GL 1423 04/22/2016 Fire Payroll 4/22/16 27.85 1,990.21 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 50.25 1,990.21 ** 2,000.00 Budgeted 9.79 Remaining 100 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 54.00 .00 54.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 1504 04/26/2016 April A/P APL* ITUNES.COM/BILL 2,775.00 10.81 2,785.81 APL* ITUNES.COM/BILL PC _______________ Account: 122-55030-045-000 Software & Support Totals: 10.81 2,785.81 ** 6,661.00 Budgeted 3,875.19 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal 1488 04/29/2016 April A/P Fire Dept SOG Review 6,559.50 6,559.50 The Liston Law Firm, P.C. AP _______________ Account: 122-55045-045-000 Legal Totals: 6,559.50 6,559.50 ** 5,000.00 Budgeted (1,559.50) Remaining 131 % Used Account: 122-55080-045-000 Maintenance & Repairs 1439 04/26/2016 April A/P Rug Service 15,819.42 37.24 15,856.66 G & K SERVICES AP 1439 04/26/2016 April A/P Rug Service 37.24 15,893.90 G & K SERVICES AP 1504 04/26/2016 April A/P SAMSCLUB #8210 191.53 16,085.43 SAMSCLUB #8210 PC 1504 04/26/2016 April A/P ROTO-ROOTER PLUMBING & 272.50 16,357.93 ROTO-ROOTER PLUMBING & PC 1504 04/26/2016 April A/P GUINCO SERVICE 139.90 16,497.83 GUINCO SERVICE PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 93.96 16,591.79 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P FILTERS FAST 179.80 16,771.59 FILTERS FAST PC 1504 04/26/2016 April A/P BIOLOGICAL CONTROLS 186.50 16,958.09 BIOLOGICAL CONTROLS PC 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (37.24) 16,920.85 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,101.43 16,920.85 ** 25,218.00 Budgeted 8,297.15 Remaining 67 % Used Account: 122-55090-045-000 Vehicle Maintenance 1504 04/26/2016 April A/P CBA ROANOKE 044 5,698.95 1,613.74 7,312.69 CBA ROANOKE 044 PC 1504 04/26/2016 April A/P ROANOKE AUTO SUPPLY LT 43.28 7,355.97 ROANOKE AUTO SUPPLY LT PC 1504 04/26/2016 April A/P WM SUPERCENTER #5247 23.64 7,379.61 WM SUPERCENTER #5247 PC 1509 04/30/2016 April A/P Windshield repair T-681 69.95 7,449.56 SAFELITE FULFILLMENT AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,750.61 7,449.56 ** 10,000.00 Budgeted 2,550.44 Remaining 74 % Used Account: 122-55160-045-000 Professional Outside Services 1359 04/11/2016 Apr A/P Balance due Fire Assessment 2,743.80 2,743.80 EMERGENCY SERVICES CONSULTING 1790 AP _______________ Account: 122-55160-045-000 Professional Outside Services Totals: 2,743.80 2,743.80 ** .00 Budgeted (2,743.80) Remaining 0 % Used Account: 122-60005-045-000 Telephone 1504 04/26/2016 April A/P ATT*BUS PHONE PMT 22.60 5.22 27.82 ATT*BUS PHONE PMT PC 1504 04/26/2016 April A/P ATT*BUS PHONE PMT 5.22 33.04 ATT*BUS PHONE PMT PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60005-045-000 Telephone Totals: 10.44 33.04 ** 50.00 Budgeted 16.96 Remaining 66 % Used Account: 122-60010-045-000 Communications/Mobiles 1336 04/08/2016 Fire Dept Payroll 4/8/16 5,232.87 75.00 5,307.87 GL 1421 04/21/2016 Apr A/P Symonds, Verizon 98.20 5,406.07 TOWN OF TROPHY CLUB 1813 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 173.20 5,406.07 ** 7,706.00 Budgeted 2,299.93 Remaining 70 % Used Account: 122-60020-045-000 Electricity/Gas 1421 04/21/2016 Apr A/P Gas/Fire Station 3/17-4/15/16 2,151.63 90.22 2,241.85 ATMOS ENERGY 1804 AP 1509 04/30/2016 April A/P Electricity 3/10-4/11/16 745.91 2,987.76 HUDSON ENERGY SERVICES, LLC AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (418.06) 2,569.70 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 418.07 2,569.70 ** 7,412.00 Budgeted 4,842.30 Remaining 35 % Used Account: 122-60025-045-000 Water 1509 04/30/2016 April A/P April Water 797.81 258.25 1,056.06 TROPHY CLUB MUD (WATER BILLS) AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (129.13) 926.93 AR _______________ Account: 122-60025-045-000 Water Totals: 129.12 926.93 ** 1,200.00 Budgeted 273.07 Remaining 77 % Used Account: 122-60026-045-000 Cable 1504 04/26/2016 April A/P ATT*BILL PAYMENT 1,053.28 158.69 1,211.97 ATT*BILL PAYMENT PC 1504 04/26/2016 April A/P ATT*BILL PAYMENT 134.54 1,346.51 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 293.23 1,346.51 ** 1,920.00 Budgeted 573.49 Remaining 70 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,379.00 .00 214,379.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60035-045-000 Postage 7.97 .00 7.97 _______________ Account: 122-60035-045-000 Postage Totals: .00 7.97 ** 50.00 Budgeted 42.03 Remaining 16 % Used Account: 122-60055-045-000 Insurance 138 04/01/2016 Prepaid Insurance, W/C Apr 11,412.26 1,173.08 12,585.34 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.08 12,585.34 ** 18,451.00 Budgeted 5,865.66 Remaining 68 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 172.05 .00 172.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used Account: 122-60070-045-000 Dues & Memberships 15,456.59 .00 15,456.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 1504 04/26/2016 April A/P SAFE KIDS WORLDWIDE 2,383.39 50.00 2,433.39 SAFE KIDS WORLDWIDE PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 50.00 2,433.39 ** 6,880.00 Budgeted 4,446.61 Remaining 35 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 958.34 .00 958.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 958.34 ** 2,081.00 Budgeted 1,122.66 Remaining 46 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 4,200.00 .00 4,200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 4,200.00 ** 4,700.00 Budgeted 500.00 Remaining 89 % Used Account: 122-60160-045-000 Programs & Special Projects 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 1421 04/21/2016 Apr A/P Symonds, Verizon 389.50 1,185.00 1,574.50 TOWN OF TROPHY CLUB 1813 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 1,185.00 1,574.50 ** 3,184.00 Budgeted 1,609.50 Remaining 49 % Used Account: 122-60245-045-000 Miscellaneous Expense 1504 04/26/2016 April A/P HARBOR FREIGHT TOOLS 2 491.14 88.87 580.01 HARBOR FREIGHT TOOLS 2 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 88.87 580.01 ** 1,001.00 Budgeted 420.99 Remaining 58 % Used Account: 122-65005-045-000 Fuel & Lube 1439 04/26/2016 April A/P Fuel 2,194.53 342.79 2,537.32 US Bank Voyager Fleet Systems AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 342.79 2,537.32 ** 15,122.00 Budgeted 12,584.68 Remaining 17 % Used Account: 122-65010-045-000 Uniforms 3,011.32 .00 3,011.32 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 3,011.32 ** 3,640.00 Budgeted 628.68 Remaining 83 % Used Account: 122-65015-045-000 Protective Clothing 2,885.76 .00 2,885.76 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 2,885.76 ** 9,000.00 Budgeted 6,114.24 Remaining 32 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 1,862.37 .00 1,862.37 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 1,862.37 ** 2,000.00 Budgeted 137.63 Remaining 93 % Used Account: 122-65055-045-000 Hardware 195.42 .00 195.42 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies 60.26 .00 60.26 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 60.26 ** 500.00 Budgeted 439.74 Remaining 12 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 947,213.15 ** 1,384,635.00 Budgeted 437,421.85 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2016 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: ------------------------------------------------------------------------------------------------------ (377,267.44) .00 Budgeted 377,267.44 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2016 0 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 4/30/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 265,068 - - 265,068 CASH IN BANK-SAVINGS-CASH RESERVE 180,000 - - 180,000 CD-BANK OF THE WEST/THB DEPOSIT 35,000 - - 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,511,022 - - 1,511,022 INVESTMENTS-TEXPOOL 1,097,231 326,020 - 1,423,251 PREPAID EXPENSES 28,050 - - 28,050 ADVALOREM PROPERTY TAXES RECEIVABLE 1,314 - - 1,314 UTILITY AND OTHER ACCOUNTS RECEIVABLE 609,877 - - 609,877 TOTAL ASSETS 3,728,162 326,020 - 4,054,182 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,314 - - 1,314 ACCOUNTS AND OTHER PAYABLES 851,771 - - 851,771 CUSTOMER DEPOSITS 313,602 - - 313,602 - TOTAL LIABILITIES 1,166,687 - - 1,166,687 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 195,000 - 195,000 UNASSIGNED FUND BALANCE 2,070,826 - 8,032 2,078,858 COMMITTED FUND BALANCE 892,901 - - 892,901 NET REVENUES / EXPENDITURES (627,938) - (8,032) (635,970) - TOTAL FUND BALANCE 2,561,475 326,020 - 2,887,495 - TOTAL LIABILITIES AND FUND BALANCE 3,728,162 326,020 - 4,054,182 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 534.05 56,432.40- 96.995 1,748.60- 135-40002-000-000 Property Taxes/Delinquent 63.10- 339.41- 339.41 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 45.36- 283.29- 43.583 366.71- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 24,739.19 146,125.00- Subtotal: 204,956.00- 204,956.00- 25,164.78 57,055.10- 27.838 147,900.90- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 287,491.00- 1,934,489.05- 38.079 3,145,754.95- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 186,003.05- 1,195,113.82- 49.512 1,218,662.18- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 7,019.92- 61,488.04- 67.580 29,496.96- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 1,025.00- 8,950.00- 99.444 50.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 1,800.00- 90.000 200.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 5,250.00- 95.455 250.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 4,346.30- 11,746.00- 19.152 49,584.00- Subtotal: 7,662,835.00- 7,662,835.00- 486,485.27- 3,218,836.91- 42.006 4,443,998.09- 135-48005-000-000 Utility Fees 69,000.00- 55,200.00- 55,200.00- 100.000 Subtotal: 69,000.00- 55,200.00- 55,200.00- 100.000 135-49010-000-000 Interest Income 6,000.00- 10,000.00- 1,202.63- 7,135.52- 71.355 2,864.48- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 6,373.71- 58.335 4,552.29- 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 30,935.00- 30,935.00- 100.000 135-49035-000-000 Prior Year Reserves 8,020.00- 548,668.00- 548,668.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 5,196.62- 39,159.42- 248.190 23,381.42 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 74.91- 1,236.38- 1.955 62,012.62- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.40- 102.000 .40 Subtotal: 110,993.00- 686,576.00- 7,968.02- 96,978.10- 14.125 589,597.90- Program number: 8,047,784.00- 8,609,567.00- 469,288.51- 3,428,070.11- 39.817 5,181,496.89- Department number: Revenues 8,047,784.00- 8,609,567.00- 469,288.51- 3,428,070.11- 39.817 5,181,496.89- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 469,288.51- 3,428,070.11- 39.817 5,181,496.89- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 260,062.00 16,770.90 117,579.65 45.212 142,482.35 135-50010-010-000 Overtime 19,500.00 19,500.00 1,355.89 7,417.28 38.037 12,082.72 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 3,600.00 200.00 1,325.00 36.806 2,275.00 135-50020-010-000 Retirement 25,558.00 25,018.00 1,599.92 11,390.11 45.528 13,627.89 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 21,620.91 42.066 29,777.09 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 1,620.87 40.532 2,378.13 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 365.22 40.134 544.78 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 196.56 1,354.16 48.311 1,448.84 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,135.31 7,951.24 43.818 10,194.76 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 265.51 1,859.54 43.826 2,383.46 135-50040-010-000 Unemployment Taxes 1,242.00 1,026.00 83.02 847.29 82.582 178.71 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 6,290.93 42.639 8,463.07 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 75.22 25.073 224.78 Subtotal: 417,429.00 410,004.00 26,292.36 182,878.87 44.604 227,125.13 135-55005-010-000 Engineering 5,000.00 109,400.00 16,590.60 29,985.60 27.409 79,414.40 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 6,292.38 62,700.71 63.016 36,799.29 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 116.35 2,983.93 37.299 5,016.07 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 2,892.77 82.651 607.23 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 250.00 2,259.17 41.076 3,240.83 Subtotal: 107,000.00 225,900.00 23,249.33 100,822.18 44.631 125,077.82 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.99 2,531.04 46.871 2,868.96 135-60020-010-000 Electricity 166,823.00 166,823.00 10,673.85 68,764.78 41.220 98,058.22 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 11.00 2.200 489.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 163.00 1,238.00 21.445 4,535.00 135-60090-010-000 Safety Program 400.00 400.00 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 78.18 5.584 1,321.82 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 10,501.40 21.312 38,773.60 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 134,180.61 851,951.14 28.892 2,096,790.86 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 2,199.64 62.847 1,300.36 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 145,364.45 937,524.15 29.419 2,249,238.85 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 575.27 8,195.50 22.799 27,751.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 2,006.73 43.549 2,601.27 135-65030-010-000 Chemicals 12,000.00 13,000.00 1,391.35 7,838.77 60.298 5,161.23 135-65035-010-000 Small Tools 1,200.00 1,200.00 129.55 129.55 10.796 1,070.45 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 443.49 44.349 556.51 135-65050-010-000 Meter Expense 115,000.00 115,000.00 87,305.34 75.918 27,694.66 135-65053-010-000 Meter Change Out Program 50,000.00 77,325.00 77,325.00 100.000 Subtotal: 219,755.00 248,080.00 2,096.17 183,244.38 73.865 64,835.62 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 12,890.74 319,871.38 79.918 80,378.62 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,177.54 97.398 31.46 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 126,958.00 126,958.00 126,957.75 100.000 .25 Subtotal: 534,887.00 734,137.00 12,890.74 653,707.01 89.044 80,429.99 Program number: 4,465,834.00 4,804,884.00 209,893.05 2,058,176.59 42.835 2,746,707.41 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 85.00 821.55 16.431 4,178.45 Subtotal: 5,000.00 5,000.00 85.00 821.55 16.431 4,178.45 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 85.00 821.55 8.216 9,178.45 Department number: Water 4,475,834.00 4,814,884.00 209,978.05 2,058,998.14 42.763 2,755,885.86 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,892.97 196,250.43 55.805 155,420.57 135-50010-020-000 Overtime 19,500.00 29,500.00 3,470.46 19,754.25 66.964 9,745.75 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 625.00 4,225.00 58.681 2,975.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,879.87 19,936.27 59.242 13,715.73 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 36,264.69 54.956 29,724.31 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 2,206.26 52.731 1,977.74 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 500.85 51.528 471.15 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 352.03 2,338.02 63.968 1,316.98 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,855.93 12,802.90 51.907 11,862.10 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 434.05 2,994.21 51.911 2,773.79 135-50040-020-000 Unemployment Taxes 1,449.00 1,204.00 1,203.57 99.964 .43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 3,120.52 33.493 6,196.48 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 39.00 322.28 49.582 327.72 Subtotal: 535,097.00 544,852.00 45,283.67 308,282.70 56.581 236,569.30 135-55070-020-000 Independent Labor 50,000.00 50,000.00 81,943.24- 50,000.00 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 7,086.51 66,019.98 79.446 17,080.02 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 50.99 4,202.33 56.031 3,297.67 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 291.00 58.200 209.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,483.04 21,959.88 39.927 33,040.12 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,442.00 24,124.40 68.927 10,875.60 Subtotal: 218,100.00 231,100.00 70,880.70- 116,597.59 50.453 114,502.41 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 412.00 3,280.05 60.742 2,119.95 135-60020-020-000 Electricity 161,582.00 161,582.00 1,807.49 58,988.58 36.507 102,593.42 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 200.00 66.667 100.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 111.00 2,353.00 62.397 1,418.00 135-60090-020-000 Safety Program 550.00 550.00 296.67 53.940 253.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 39.00 658.70 41.169 941.30 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 3,238.50 3,238.50 35.983 5,761.50 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 100.00 34,568.74 93.052 2,581.26 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 23.24 173.24 58.330 123.76 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 19,951.00 39,902.00 33.333 79,804.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 271,956.24 61.137 172,874.76 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 30,834.00 92,502.00 75.000 30,834.00 Subtotal: 908,423.00 908,423.00 99,736.55 508,117.72 55.934 400,305.28 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 716.33 6,530.50 20.394 25,490.50 135-65010-020-000 Uniforms 4,241.00 4,241.00 2,503.53 59.032 1,737.47 135-65030-020-000 Chemicals 27,000.00 27,000.00 17,698.25 65.549 9,301.75 135-65035-020-000 Small Tools 2,000.00 2,000.00 151.39 371.89 18.595 1,628.11 135-65040-020-000 Safety Equipment 750.00 750.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 718.02 11,198.43 86.142 1,801.57 Subtotal: 79,012.00 79,012.00 1,585.74 38,879.19 49.207 40,132.81 135-69005-020-000 Capital Outlays 150,000.00 356,000.00 112,161.53 170,102.28 47.782 185,897.72 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,276.80 99.985 3.20 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 100.000 Subtotal: 171,477.00 377,477.00 112,161.53 191,576.08 50.752 185,900.92 Program number: 1,912,109.00 2,140,864.00 187,886.79 1,163,453.28 54.345 977,410.72 Department number: Wastewater 1,912,109.00 2,140,864.00 187,886.79 1,163,453.28 54.345 977,410.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 1,400.00 4,700.00 37.600 7,800.00 135-50030-026-000 Social Security Taxes 775.00 775.00 86.80 291.40 37.600 483.60 135-50035-026-000 Medicare Taxes 181.00 181.00 20.30 68.15 37.652 112.85 135-50040-026-000 Unemployment Taxes 230.00 12.00 23.40 35.70 297.500 23.70- 135-50045-026-000 Workman's Compensation 37.00 50.00 3.08 34.57 69.140 15.43 Subtotal: 13,723.00 13,518.00 1,533.58 5,129.82 37.948 8,388.18 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 21.67 1.806 1,178.33 135-60080-026-000 Schools & Training 4,000.00 4,000.00 905.00 22.625 3,095.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,602.43 32.049 3,397.57 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 2,590.56 20.160 10,259.44 Program number: 26,573.00 26,368.00 1,533.58 7,720.38 29.279 18,647.62 Department number: Board of Directors 26,573.00 26,368.00 1,533.58 7,720.38 29.279 18,647.62 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 493,633.00 37,889.79 265,173.76 53.719 228,459.24 135-50010-030-000 Overtime 1,000.00 500.00 220.04 371.80 74.360 128.20 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,652.00 3,326.98 23,730.77 54.364 19,921.23 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,310.72 35,906.51 52.652 32,289.49 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 378.79 2,462.99 51.238 2,344.01 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 87.14 568.19 51.004 545.81 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 392.51 2,718.78 50.060 2,712.22 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 2,183.85 15,558.19 49.960 15,582.81 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 510.73 3,638.59 47.390 4,039.41 135-50040-030-000 Unemployment Taxes 1,449.00 1,197.00 45.12 1,195.77 99.897 1.23 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,327.23 85.407 226.77 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 4,500.00 106.70 2,986.92 66.376 1,513.08 Subtotal: 662,006.00 667,726.00 50,600.26 359,462.00 53.834 308,264.00 135-55030-030-000 Software & Support 78,483.00 81,097.00 2,668.77 34,145.93 42.105 46,951.07 135-55070-030-000 Independent Labor 12,000.00 12,000.00 11,952.60- 1,019.38 8.495 10,980.62 135-55080-030-000 Maintenance & Repairs 29,500.00 7,000.00 5,160.00- 5,968.35 85.262 1,031.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 130.89 4,457.81 63.683 2,542.19 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 3,249.50 32.094 6,875.50 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 53,072.50 73.128 19,502.50 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 653.70 3,776.17 46.051 4,423.83 Subtotal: 206,583.00 198,197.00 13,074.49- 105,689.64 53.326 92,507.36 135-60005-030-000 Telephone 16,349.00 16,349.00 2,057.30 8,453.33 51.705 7,895.67 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 435.40 2,463.34 59.358 1,686.66 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 3,711.28 34.466 7,056.72 135-60025-030-000 Water 1,500.00 1,500.00 57.40 516.07 34.405 983.93 135-60035-030-000 Postage 28,932.00 28,932.00 1,798.10 13,990.10 48.355 14,941.90 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 3,185.67 34,246.61 61.639 21,313.39 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 2,015.35 57.581 1,484.65 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 19,593.00 37.110 33,204.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 260.00 260.00 16.250 1,340.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 5,006.25 83.438 993.75 135-60075-030-000 Meetings 400.00 400.00 29.00 7.250 371.00 135-60079-030-000 Public Education 5,000.00 5,000.00 584.11 4,230.34 84.607 769.66 135-60080-030-000 Schools & Training 9,935.00 9,935.00 19.50 3,292.00 33.135 6,643.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 230.46 2,698.46 49.971 2,701.54 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 1,054.02 1,060.02 14.134 6,439.98 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 61.74 .823 7,438.26 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 1,043.07 5,117.05 29.239 12,383.95 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 238,442.00 13,481.03 107,400.32 45.043 131,041.68 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 13,594.00 5,871.85 43.194 7,722.15 135-65085-030-000 Office Supplies 9,000.00 9,000.00 74.34 3,498.54 38.873 5,501.46 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 406.44 10.153 3,596.56 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 61.93 2,153.97 43.079 2,846.03 135-65105-030-000 Printing 4,800.00 4,800.00 1,289.00 1,348.88 28.102 3,451.12 Subtotal: 54,252.00 38,252.00 1,425.27 13,302.68 34.776 24,949.32 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 847.50 7,005.50 12.510 48,994.50 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 261.28 1,934.13 42.046 2,665.87 Subtotal: 60,600.00 60,600.00 1,108.78 8,939.63 14.752 51,660.37 Program number: 1,210,323.00 1,203,217.00 53,540.85 594,794.27 49.434 608,422.73 Department number: Administration 1,210,323.00 1,203,217.00 53,540.85 594,794.27 49.434 608,422.73 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:37 05/05/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 77,713.50 198,309.89 51.358 187,820.11 135-55055-039-000 Auditing 22,750.00 24,039.00 24,039.38 100.002 .38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 6,224.41 60.637 4,040.59 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 424,234.00 77,713.50 231,042.50 54.461 193,191.50 Program number: 422,945.00 424,234.00 77,713.50 231,042.50 54.461 193,191.50 Department number: Non Departmental 422,945.00 424,234.00 77,713.50 231,042.50 54.461 193,191.50 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 530,652.77 4,056,008.57 47.110 4,553,558.43 Fund number: 135 MUD 1 General Fund 61,364.26 627,938.46 627,938.46- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:37 05/05/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 14:37 05/05/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 14:37 05/05/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 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 1449 04/01/2016 Property Taxes (56,966.45) (5.46) (56,971.91) GL 1450 04/04/2016 Property Taxes (44.59) (57,016.50) GL 1451 04/05/2016 Property Taxes (65.76) (57,082.26) GL 1452 04/06/2016 Property Taxes (7.48) (57,089.74) GL 1453 04/07/2016 Property Taxes (39.17) (57,128.91) GL 1454 04/08/2016 Property Taxes (4.37) (57,133.28) GL 1455 04/11/2016 Property Taxes (19.74) (57,153.02) GL 1456 04/12/2016 Property Taxes (.87) (57,153.89) GL 1458 04/19/2016 Property Taxes (4.01) (57,157.90) GL 1459 04/21/2016 Property Taxes 19.87 (57,138.03) GL 1497 04/22/2016 Property Taxes (27.00) (57,165.03) GL 1460 04/25/2016 Property Taxes (11.85) (57,176.88) GL 1486 04/29/2016 April A/P Refund Tax Shortage 762.84 (56,414.04) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (18.36) (56,432.40) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: 534.05 (56,432.40) ** (58,181.00) Budgeted (1,748.60) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1455 04/11/2016 Property Taxes (276.31) (33.83) (310.14) GL 1457 04/13/2016 Property Taxes (1.71) (311.85) GL 1459 04/21/2016 Property Taxes 35.29 (276.56) GL 1497 04/22/2016 Property Taxes 2.57 (273.99) GL 1486 04/29/2016 April A/P Refund Tax Shortage (39.83) (313.82) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (25.59) (339.41) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (63.10) (339.41) ** .00 Budgeted 339.41 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1450 04/04/2016 Property Taxes (237.93) (.13) (238.06) GL 1451 04/05/2016 Property Taxes (5.02) (243.08) GL 1453 04/07/2016 Property Taxes (3.11) (246.19) GL 1454 04/08/2016 Property Taxes (.63) (246.82) GL 1455 04/11/2016 Property Taxes (4.30) (251.12) GL 1457 04/13/2016 Property Taxes (4.55) (255.67) GL 1459 04/21/2016 Property Taxes (.22) (255.89) GL 1497 04/22/2016 Property Taxes (3.22) (259.11) GL 1486 04/29/2016 April A/P Refund Tax Shortage (14.81) (273.92) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (9.37) (283.29) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (45.36) (283.29) ** (650.00) Budgeted (366.71) Remaining 44 % Used Account: 135-40025-000-000 PID Surcharges 1462 04/29/2016 Recode PID Surcharges to Liab (24,739.19) 24,739.19 .00 GL _______________ Account: 135-40025-000-000 PID Surcharges Totals: 24,739.19 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1469 04/29/2016 UB 4/29/16 Billing UB20160429-20160429 User: (1,646,998.05) (287,491.00) (1,934,489.05) UB _______________ Account: 135-47000-000-000 Water Totals: (287,491.00) (1,934,489.05) ** (5,080,244.00) Budgeted (3,145,754.95) Remaining 38 % Used Account: 135-47005-000-000 Sewer 1469 04/29/2016 UB 4/29/16 Billing UB20160429-20160429 User: (1,009,110.77) (186,003.05) (1,195,113.82) UB _______________ Account: 135-47005-000-000 Sewer Totals: (186,003.05) (1,195,113.82) ** (2,413,776.00) Budgeted (1,218,662.18) Remaining 50 % Used Account: 135-47025-000-000 Penalties 1475 04/15/2016 UB 4/15/16 Penalty removals UB20160415-20160415 User: (54,468.12) 2,094.49 (52,373.63) UB 1417 04/21/2016 UB 4/21/16 Penalties UB20160421-20160421 User: (9,304.01) (61,677.64) UB 1480 04/28/2016 UB 4/28/16 Penalty Adjustments UB20160428-20160428 User: 111.26 (61,566.38) UB 1481 04/29/2016 UB 4/29/16 Penalty adj UB20160429-20160429 User: 78.34 (61,488.04) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,019.92) (61,488.04) ** (90,985.00) Budgeted (29,496.96) Remaining 68 % Used Account: 135-47030-000-000 Service Charges 1291 04/06/2016 UB 4/6/16 Cut Off List UB20160406-20160406 User: (7,925.00) (1,000.00) (8,925.00) UB 1473 04/11/2016 UB 4/11/16 NSF Check fee UB20160411-20160411 User: (25.00) (8,950.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,025.00) (8,950.00) ** (9,000.00) Budgeted (50.00) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47035-000-000 Plumbing Inspections 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (1,650.00) (150.00) (1,800.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,800.00) ** (2,000.00) Budgeted (200.00) Remaining 90 % Used Account: 135-47045-000-000 Sewer Inspections 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (4,800.00) (450.00) (5,250.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,250.00) ** (5,500.00) Budgeted (250.00) Remaining 95 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1469 04/29/2016 UB 4/29/16 Billing UB20160429-20160429 User: (7,399.70) (4,346.30) (11,746.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (4,346.30) (11,746.00) ** (61,330.00) Budgeted (49,584.00) Remaining 19 % Used Account: 135-48005-000-000 Utility Fees (55,200.00) .00 (55,200.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (55,200.00) ** (55,200.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 1502 04/30/2016 Bank Interest/April (5,932.89) (188.87) (6,121.76) GL 1502 04/30/2016 Bank Interest/April (300.07) (6,421.83) GL 1502 04/30/2016 Bank Interest/April (713.69) (7,135.52) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,202.63) (7,135.52) ** (10,000.00) Budgeted (2,864.48) Remaining 71 % Used Account: 135-49016-000-000 Cell Tower Revenue 1489 04/01/2016 AT&T Cell Tower Revenue (5,463.18) (910.53) (6,373.71) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (6,373.71) ** (10,926.00) Budgeted (4,552.29) Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 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 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 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 (30,935.00) .00 (30,935.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (30,935.00) ** (30,935.00) Budgeted .00 Remaining 100 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (548,668.00) Budgeted (548,668.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (33,962.80) (5,196.62) (39,159.42) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,196.62) (39,159.42) ** (15,778.00) Budgeted 23,381.42 Remaining 248 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1469 04/29/2016 UB 4/29/16 Billing UB20160429-20160429 User: (1,161.47) (74.91) (1,236.38) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (74.91) (1,236.38) ** (63,249.00) Budgeted (62,012.62) Remaining 2 % Used Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (20.40) .00 (20.40) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (20.40) ** (20.00) Budgeted .40 Remaining 102 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,428,070.11) ** (8,609,567.00) Budgeted (5,181,496.89) Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 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 1282 04/08/2016 MUD Payroll 4/18/16 Salaries & Wages 100,808.75 8,385.45 109,194.20 PR 1404 04/22/2016 MUD Payroll 4/22/16 Salaries & Wages 8,385.45 117,579.65 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,770.90 117,579.65 ** 260,062.00 Budgeted 142,482.35 Remaining 45 % Used Account: 135-50010-010-000 Overtime 1282 04/08/2016 MUD Payroll 4/18/16 Overtime 6,061.39 957.98 7,019.37 PR 1404 04/22/2016 MUD Payroll 4/22/16 Overtime 397.91 7,417.28 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,355.89 7,417.28 ** 19,500.00 Budgeted 12,082.72 Remaining 38 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1404 04/22/2016 MUD Payroll 4/22/16 Certification 1,125.00 200.00 1,325.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 1,325.00 ** 3,600.00 Budgeted 2,275.00 Remaining 37 % Used Account: 135-50020-010-000 Retirement 1282 04/08/2016 MUD Payroll 4/18/16 Retirement 9,790.19 815.67 10,605.86 PR 1404 04/22/2016 MUD Payroll 4/22/16 Retirement 784.25 11,390.11 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,599.92 11,390.11 ** 25,018.00 Budgeted 13,627.89 Remaining 46 % Used Account: 135-50026-010-000 Medical Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Medical Insurance 18,459.76 1,580.60 20,040.36 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medical Insurance 1,580.55 21,620.91 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 21,620.91 ** 51,398.00 Budgeted 29,777.09 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 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 1282 04/08/2016 MUD Payroll 4/18/16 Dental Insurance 1,380.10 120.39 1,500.49 PR 1404 04/22/2016 MUD Payroll 4/22/16 Dental Insurance 120.38 1,620.87 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 1,620.87 ** 3,999.00 Budgeted 2,378.13 Remaining 41 % Used Account: 135-50028-010-000 Vision Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Vision Insurance 311.24 27.01 338.25 PR 1404 04/22/2016 MUD Payroll 4/22/16 Vision Insurance 26.97 365.22 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 365.22 ** 910.00 Budgeted 544.78 Remaining 40 % Used Account: 135-50029-010-000 Life Insurance & Other 1193 04/01/2016 Apr A/P April Dental, LTD, STD,Life, A 1,157.60 186.85 1,344.45 METLIFE GROUP BENEFITS 1699 AP 1439 04/26/2016 April A/P Café 125 Admin fee 9.71 1,354.16 BenefitMall AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 196.56 1,354.16 ** 2,803.00 Budgeted 1,448.84 Remaining 48 % Used Account: 135-50030-010-000 Social Security Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Social Security Taxes 6,815.93 576.24 7,392.17 PR 1404 04/22/2016 MUD Payroll 4/22/16 Social Security Taxes 559.07 7,951.24 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,135.31 7,951.24 ** 18,146.00 Budgeted 10,194.76 Remaining 44 % Used Account: 135-50035-010-000 Medicare Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Medicare Taxes 1,594.03 134.77 1,728.80 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medicare Taxes 130.74 1,859.54 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 265.51 1,859.54 ** 4,243.00 Budgeted 2,383.46 Remaining 44 % Used Account: 135-50040-010-000 Unemployment Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Unemployment Taxes 764.27 47.63 811.90 PR 1404 04/22/2016 MUD Payroll 4/22/16 Unemployment Taxes 35.39 847.29 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 83.02 847.29 ** 1,026.00 Budgeted 178.71 Remaining 83 % Used Account: 135-50045-010-000 Workman's Compensation 138 04/01/2016 Prepaid Insurance, W/C Apr 5,061.58 1,229.35 6,290.93 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 6,290.93 ** 14,754.00 Budgeted 8,463.07 Remaining 43 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 75.22 .00 75.22 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 75.22 ** 300.00 Budgeted 224.78 Remaining 25 % Used Account: 135-55005-010-000 Engineering 1421 04/21/2016 Apr A/P Water Study 13,395.00 4,638.00 18,033.00 CP&Y/WALLACE GROUP, INC. 1806 AP 1437 04/26/2016 Bill Maguire Solana Land AR 20160426-20160426 User: (3,810.00) 14,223.00 AR 1439 04/26/2016 April A/P Solana Easement Abandonment 3,810.00 18,033.00 CP&Y/WALLACE GROUP, INC. AP 1465 04/29/2016 Move Water Study Move Aerial WW Expense 11,952.60 29,985.60 GL 1487 04/29/2016 April A/P Town Center Development 1,560.87 31,546.47 CP&Y/WALLACE GROUP, INC. AP 1487 04/29/2016 April A/P Town Center Development 2,105.00 33,651.47 CP&Y/WALLACE GROUP, INC. AP 1513 04/29/2016 JSB Inv 1446/Town Center Devel AR 20160429-20160429 User: (3,665.87) 29,985.60 AR _______________ Account: 135-55005-010-000 Engineering Totals: 16,590.60 29,985.60 ** 109,400.00 Budgeted 79,414.40 Remaining 27 % Used Account: 135-55080-010-000 Maintenance & Repairs 1273 04/04/2016 Void A/P Ck 1483/Worldwide Pow Water plant generator mother b 56,408.33 (1,636.35) 54,771.98 WORLDWIDE POWER PRODUCTS 1483 AP 1274 04/04/2016 April A/P Water plant generator mother b 1,636.35 56,408.33 WORLDWIDE POWER PRODUCTS 1734 AP 1374 04/14/2016 April A/P Chlorine Gas detector/Chlorine 2,475.28 58,883.61 DHS AUTOMATION, INC 1793 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1439 04/26/2016 April A/P Chlorinator filters 56,408.33 140.40 59,024.01 SCOOP AP 1439 04/26/2016 April A/P Hydrant on Hershey Lane 167.66 59,191.67 HD SUPPLY WATERWORKS, LTD. AP 1504 04/26/2016 April A/P THE HOME DEPOT 6581 9.21 59,200.88 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 31.63 59,232.51 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 7.97 59,240.48 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 36.06 59,276.54 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 (78.04) 59,198.50 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 72.09 59,270.59 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 78.04 59,348.63 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 20.00 59,368.63 THE HOME DEPOT 6581 PC 1463 04/29/2016 Move Mowing Expenses Move Mowing Expenses 3,000.00 62,368.63 GL 1509 04/30/2016 April A/P Oxygen & Acetylene Supplies 332.08 62,700.71 ALLIED WELDING SUPPLY, INC AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 6,292.38 62,700.71 ** 99,500.00 Budgeted 36,799.29 Remaining 63 % Used Account: 135-55090-010-000 Vehicle Maintenance 1504 04/26/2016 April A/P AUTO RENEWAL STICK 2,867.58 2.00 2,869.58 AUTO RENEWAL STICK PC 1504 04/26/2016 April A/P DENTON CNTY VEHREG 23.00 2,892.58 DENTON CNTY VEHREG PC 1504 04/26/2016 April A/P DENTON CO TX MOTOR VEH 14.25 2,906.83 DENTON CO TX MOTOR VEH PC 1504 04/26/2016 April A/P DENTON CO TX MOTOR VEH 1.00 2,907.83 DENTON CO TX MOTOR VEH PC 1504 04/26/2016 April A/P KWIK KAR LUBE & TUNE O 76.10 2,983.93 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 116.35 2,983.93 ** 8,000.00 Budgeted 5,016.07 Remaining 37 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,892.77 .00 2,892.77 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 2,892.77 ** 3,500.00 Budgeted 607.23 Remaining 83 % Used Account: 135-55135-010-000 Lab Analysis 1374 04/14/2016 April A/P Water samples/MUD 2,009.17 250.00 2,259.17 TARRANT CTY PUBLIC HEALTH LAB 1799 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 250.00 2,259.17 ** 5,500.00 Budgeted 3,240.83 Remaining 41 % Used Account: 135-60010-010-000 Communications/Mobiles . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1356 04/11/2016 Apr A/P Cells 3/2-4/1/16 2,184.05 346.99 2,531.04 VERIZON WIRELESS 1788 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.99 2,531.04 ** 5,400.00 Budgeted 2,868.96 Remaining 47 % Used Account: 135-60020-010-000 Electricity 1488 04/29/2016 April A/P Electricity 3/10-4/11/16 58,090.93 10,673.85 68,764.78 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-010-000 Electricity Totals: 10,673.85 68,764.78 ** 166,823.00 Budgeted 98,058.22 Remaining 41 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 11.00 .00 11.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 11.00 ** 500.00 Budgeted 489.00 Remaining 2 % Used Account: 135-60080-010-000 Schools & Training 1376 04/14/2016 April A/P CDL permit and license 1,075.00 52.00 1,127.00 MATTHEW CHITTY 1801 AP 1421 04/21/2016 Apr A/P Sayre-Water D License 111.00 1,238.00 TX COMMISSION ENVIRONMENTAL QU 1815 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 163.00 1,238.00 ** 5,773.00 Budgeted 4,535.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 78.18 .00 78.18 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 78.18 ** 1,400.00 Budgeted 1,321.82 Remaining 6 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 10,501.40 .00 10,501.40 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 10,501.40 ** 49,275.00 Budgeted 38,773.60 Remaining 21 % Used Account: 135-60150-010-000 Wholesale Water 1446 04/28/2016 April A/P Wholesale Water March 717,770.53 134,180.61 851,951.14 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 134,180.61 851,951.14 ** 2,948,742.00 Budgeted 2,096,790.86 Remaining 29 % 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 2,199.64 .00 2,199.64 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 2,199.64 ** 3,500.00 Budgeted 1,300.36 Remaining 63 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 1439 04/26/2016 April A/P Fuel 7,620.23 575.27 8,195.50 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 575.27 8,195.50 ** 35,947.00 Budgeted 27,751.50 Remaining 23 % Used Account: 135-65010-010-000 Uniforms 2,006.73 .00 2,006.73 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 2,006.73 ** 4,608.00 Budgeted 2,601.27 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 1439 04/26/2016 April A/P Chlorine 6,447.42 529.71 6,977.13 DPC INDUSTRIES, INC AP 1439 04/26/2016 April A/P Testing supplies 861.64 7,838.77 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,391.35 7,838.77 ** 13,000.00 Budgeted 5,161.23 Remaining 60 % Used Account: 135-65035-010-000 Small Tools 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS 129.55 129.55 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65035-010-000 Small Tools Totals: 129.55 129.55 ** 1,200.00 Budgeted 1,070.45 Remaining 11 % Used Account: 135-65040-010-000 Safety Equipment 443.49 .00 443.49 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 443.49 ** 1,000.00 Budgeted 556.51 Remaining 44 % Used Account: 135-65050-010-000 Meter Expense 87,305.34 .00 87,305.34 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 87,305.34 ** 115,000.00 Budgeted 27,694.66 Remaining 76 % Used Account: 135-65053-010-000 Meter Change Out Program 77,325.00 .00 77,325.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 77,325.00 ** 77,325.00 Budgeted .00 Remaining 100 % Used Account: 135-69005-010-000 Capital Outlays 1421 04/21/2016 Apr A/P LAS Disinfection System 306,980.64 11,815.00 318,795.64 CP&Y/WALLACE GROUP, INC. 1806 AP 1509 04/30/2016 April A/P Waterline replacement/Pin Oak, 1,075.74 319,871.38 TEAGUE, NALL & PERKINS,INC AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 12,890.74 319,871.38 ** 400,250.00 Budgeted 80,378.62 Remaining 80 % Used Account: 135-69008-010-000 Short Term Debt-Principal 130,700.34 .00 130,700.34 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1,177.54 .00 1,177.54 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 1,177.54 ** 1,209.00 Budgeted 31.46 Remaining 97 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 1374 04/14/2016 April A/P Water samples/PID 736.55 85.00 821.55 TARRANT CTY PUBLIC HEALTH LAB 1799 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 85.00 821.55 ** 5,000.00 Budgeted 4,178.45 Remaining 16 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,058,998.14 ** 4,814,884.00 Budgeted 2,755,885.86 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 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 1282 04/08/2016 MUD Payroll 4/18/16 Salaries & Wages 167,357.46 14,421.65 181,779.11 PR 1404 04/22/2016 MUD Payroll 4/22/16 Salaries & Wages 14,471.32 196,250.43 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,892.97 196,250.43 ** 351,671.00 Budgeted 155,420.57 Remaining 56 % Used Account: 135-50010-020-000 Overtime 1282 04/08/2016 MUD Payroll 4/18/16 Overtime 16,283.79 2,090.86 18,374.65 PR 1404 04/22/2016 MUD Payroll 4/22/16 Overtime 1,379.60 19,754.25 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,470.46 19,754.25 ** 29,500.00 Budgeted 9,745.75 Remaining 67 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1404 04/22/2016 MUD Payroll 4/22/16 Certification 3,600.00 625.00 4,225.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 4,225.00 ** 7,200.00 Budgeted 2,975.00 Remaining 59 % Used Account: 135-50020-020-000 Retirement 1282 04/08/2016 MUD Payroll 4/18/16 Retirement 17,056.40 1,441.54 18,497.94 PR 1404 04/22/2016 MUD Payroll 4/22/16 Retirement 1,438.33 19,936.27 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,879.87 19,936.27 ** 33,652.00 Budgeted 13,715.73 Remaining 59 % Used Account: 135-50026-020-000 Medical Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Medical Insurance 30,732.72 2,765.99 33,498.71 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medical Insurance 2,765.98 36,264.69 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 36,264.69 ** 65,989.00 Budgeted 29,724.31 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 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 1282 04/08/2016 MUD Payroll 4/18/16 Dental Insurance 1,858.35 173.97 2,032.32 PR 1404 04/22/2016 MUD Payroll 4/22/16 Dental Insurance 173.94 2,206.26 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 2,206.26 ** 4,184.00 Budgeted 1,977.74 Remaining 53 % Used Account: 135-50028-020-000 Vision Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Vision Insurance 422.80 39.05 461.85 PR 1404 04/22/2016 MUD Payroll 4/22/16 Vision Insurance 39.00 500.85 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 500.85 ** 972.00 Budgeted 471.15 Remaining 52 % Used Account: 135-50029-020-000 Life Insurance & Other 1193 04/01/2016 Apr A/P April Dental, LTD, STD,Life, A 1,985.99 322.90 2,308.89 METLIFE GROUP BENEFITS 1699 AP 1439 04/26/2016 April A/P Café 125 Admin fee 29.13 2,338.02 BenefitMall AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 352.03 2,338.02 ** 3,655.00 Budgeted 1,316.98 Remaining 64 % Used Account: 135-50030-020-000 Social Security Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Social Security Taxes 10,946.97 932.45 11,879.42 PR 1404 04/22/2016 MUD Payroll 4/22/16 Social Security Taxes 923.48 12,802.90 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,855.93 12,802.90 ** 24,665.00 Budgeted 11,862.10 Remaining 52 % Used Account: 135-50035-020-000 Medicare Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Medicare Taxes 2,560.16 218.06 2,778.22 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medicare Taxes 215.99 2,994.21 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 434.05 2,994.21 ** 5,768.00 Budgeted 2,773.79 Remaining 52 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,203.57 ** 1,204.00 Budgeted .43 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 138 04/01/2016 Prepaid Insurance, W/C Apr 2,344.09 776.43 3,120.52 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 3,120.52 ** 9,317.00 Budgeted 6,196.48 Remaining 33 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations 1504 04/26/2016 April A/P SALAD BOWL 10 283.28 39.00 322.28 SALAD BOWL 10 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 39.00 322.28 ** 650.00 Budgeted 327.72 Remaining 50 % Used Account: 135-55070-020-000 Independent Labor 1464 04/29/2016 Move Aerial WW Expense Move Aerial WW Expense 81,943.24 (81,943.24) .00 GL _______________ Account: 135-55070-020-000 Independent Labor Totals: (81,943.24) .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 1504 04/26/2016 April A/P THE HOME DEPOT 6581 58,933.47 83.80 59,017.27 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P NORTH TEXAS SIGNS AND 450.00 59,467.27 NORTH TEXAS SIGNS AND PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 4.97 59,472.24 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 17.72 59,489.96 THE HOME DEPOT 6581 PC 1504 04/26/2016 April A/P BEST BUY 00001487 128.95 59,618.91 BEST BUY 00001487 PC 1504 04/26/2016 April A/P STAPLES 00110700 129.98 59,748.89 STAPLES 00110700 PC 1504 04/26/2016 April A/P AUTOZONE #4206 12.98 59,761.87 AUTOZONE #4206 PC 1504 04/26/2016 April A/P VERIZON WIRELESS 15160 54.11 59,815.98 VERIZON WIRELESS 15160 PC 1463 04/29/2016 Move Mowing Expenses Move Mowing Expenses 2,160.00 61,975.98 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1509 04/30/2016 April A/P 2 41' I-Beams to support 24" s 58,933.47 4,044.00 66,019.98 REY-MAR CONSTRUCTION AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,086.51 66,019.98 ** 83,100.00 Budgeted 17,080.02 Remaining 79 % Used Account: 135-55090-020-000 Vehicle Maintenance 1504 04/26/2016 April A/P AUTOZONE #4206 4,151.34 18.99 4,170.33 AUTOZONE #4206 PC 1504 04/26/2016 April A/P KYLE S BIKE&MOWER SHOP 32.00 4,202.33 KYLE S BIKE&MOWER SHOP PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 50.99 4,202.33 ** 7,500.00 Budgeted 3,297.67 Remaining 56 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 291.00 .00 291.00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 291.00 ** 500.00 Budgeted 209.00 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1374 04/14/2016 April A/P Sludge haul off 19,476.84 1,128.08 20,604.92 L.H. CHANEY MATERIALS, INC. 1796 AP 1509 04/30/2016 April A/P Sludge haul off 483.76 21,088.68 L.H. CHANEY MATERIALS, INC. AP 1509 04/30/2016 April A/P Sludge haul off 871.20 21,959.88 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,483.04 21,959.88 ** 55,000.00 Budgeted 33,040.12 Remaining 40 % Used Account: 135-55135-020-000 Lab Analysis 1327 04/07/2016 Apr A/P Testing 22,682.40 176.00 22,858.40 OXIDOR LABORATORIES LLC 1766 AP 1509 04/30/2016 April A/P Testing 246.00 23,104.40 OXIDOR LABORATORIES LLC AP 1509 04/30/2016 April A/P Testing 176.00 23,280.40 OXIDOR LABORATORIES LLC AP 1509 04/30/2016 April A/P Testing 246.00 23,526.40 OXIDOR LABORATORIES LLC AP 1509 04/30/2016 April A/P Testing 176.00 23,702.40 OXIDOR LABORATORIES LLC AP 1509 04/30/2016 April A/P Testing 246.00 23,948.40 OXIDOR LABORATORIES LLC AP 1509 04/30/2016 April A/P Testing 176.00 24,124.40 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,442.00 24,124.40 ** 35,000.00 Budgeted 10,875.60 Remaining 69 % Used Account: 135-60010-020-000 Communications/Mobiles . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1356 04/11/2016 Apr A/P Cells 3/2-4/1/16 2,868.05 412.00 3,280.05 VERIZON WIRELESS 1788 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 412.00 3,280.05 ** 5,400.00 Budgeted 2,119.95 Remaining 61 % Used Account: 135-60020-020-000 Electricity 1356 04/11/2016 Apr A/P Electricity 2/26-3/29/16 57,181.09 176.65 57,357.74 TRI COUNTY ELECTRIC 1787 AP 1356 04/11/2016 Apr A/P Electricity 2/26-3/29/16 27.85 57,385.59 TRI COUNTY ELECTRIC 1787 AP 1356 04/11/2016 Apr A/P Electricity 2/26-3/29/16 304.77 57,690.36 TRI COUNTY ELECTRIC 1787 AP 1446 04/28/2016 April A/P Electricity 3/10-4/11/16 312.66 58,003.02 MP2 ENERGY TEXAS LLC AP 1488 04/29/2016 April A/P Electricity 3/10-4/11/16 535.82 58,538.84 HUDSON ENERGY SERVICES, LLC AP 1488 04/29/2016 April A/P Electricity 3/10-4/11/16 790.16 59,329.00 HUDSON ENERGY SERVICES, LLC AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (340.42) 58,988.58 AR _______________ Account: 135-60020-020-000 Electricity Totals: 1,807.49 58,988.58 ** 161,582.00 Budgeted 102,593.42 Remaining 37 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 200.00 .00 200.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 200.00 ** 300.00 Budgeted 100.00 Remaining 67 % Used Account: 135-60080-020-000 Schools & Training 1504 04/26/2016 April A/P TCEQ EPAYMENT 2,242.00 111.00 2,353.00 TCEQ EPAYMENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 2,353.00 ** 3,771.00 Budgeted 1,418.00 Remaining 62 % Used Account: 135-60090-020-000 Safety Program 296.67 .00 296.67 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 296.67 ** 550.00 Budgeted 253.33 Remaining 54 % Used Account: 135-60100-020-000 Travel & per diem 1504 04/26/2016 April A/P CFW COMMERCE ST GARAGE 619.70 15.00 634.70 CFW COMMERCE ST GARAGE PC 1504 04/26/2016 April A/P CC G1 - BOOTH 1 12.00 646.70 CC G1 - BOOTH 1 PC 1504 04/26/2016 April A/P CC G2 - BOOTH 3 12.00 658.70 CC G2 - BOOTH 3 PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 39.00 658.70 ** 1,600.00 Budgeted 941.30 Remaining 41 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1374 04/14/2016 April A/P Rental for #1 raw influent pum 1,350.00 1,350.00 NORTH TEXAS PUMP CO. 1798 AP 1504 04/26/2016 April A/P UNITED RENTALS #15150 366.90 1,716.90 UNITED RENTALS #15150 PC 1504 04/26/2016 April A/P UNITED RENTALS 171.60 1,888.50 UNITED RENTALS PC 1509 04/30/2016 April A/P Rental of #1 WWTP influent pum 1,350.00 3,238.50 NORTH TEXAS PUMP CO. AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 3,238.50 3,238.50 ** 9,000.00 Budgeted 5,761.50 Remaining 36 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1504 04/26/2016 April A/P TCEQ EPAYMENT 34,468.74 100.00 34,568.74 TCEQ EPAYMENT PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 100.00 34,568.74 ** 37,150.00 Budgeted 2,581.26 Remaining 93 % Used Account: 135-60245-020-000 Miscellaneous Expenses 1504 04/26/2016 April A/P MICHAELS STORES 9964 150.00 23.24 173.24 MICHAELS STORES 9964 PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 23.24 173.24 ** 297.00 Budgeted 123.76 Remaining 58 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1248 04/01/2016 Texpool Transfers PID Surcharge to Debt Svc 19,951.00 19,951.00 39,902.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 39,902.00 ** 119,706.00 Budgeted 79,804.00 Remaining 33 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1248 04/01/2016 Texpool Transfers O&M to Rev Bond Debt Svc 228,735.92 43,220.32 271,956.24 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 271,956.24 ** 444,831.00 Budgeted 172,874.76 Remaining 61 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1248 04/01/2016 Texpool Transfers O&M to Rev Bond Reserve 61,668.00 30,834.00 92,502.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 30,834.00 92,502.00 ** 123,336.00 Budgeted 30,834.00 Remaining 75 % Used Account: 135-65005-020-000 Fuel & Lube 1439 04/26/2016 April A/P Fuel 5,814.17 716.33 6,530.50 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 716.33 6,530.50 ** 32,021.00 Budgeted 25,490.50 Remaining 20 % Used Account: 135-65010-020-000 Uniforms 2,503.53 .00 2,503.53 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,503.53 ** 4,241.00 Budgeted 1,737.47 Remaining 59 % Used Account: 135-65030-020-000 Chemicals 17,698.25 .00 17,698.25 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 17,698.25 ** 27,000.00 Budgeted 9,301.75 Remaining 66 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1504 04/26/2016 April A/P WHOLESALE POWER TOOLS 220.50 151.39 371.89 WHOLESALE POWER TOOLS PC _______________ Account: 135-65035-020-000 Small Tools Totals: 151.39 371.89 ** 2,000.00 Budgeted 1,628.11 Remaining 19 % Used Account: 135-65040-020-000 Safety Equipment 576.59 .00 576.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used Account: 135-65045-020-000 Lab Supplies 1504 04/26/2016 April A/P HACH COMPANY 10,480.41 718.02 11,198.43 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 718.02 11,198.43 ** 13,000.00 Budgeted 1,801.57 Remaining 86 % Used Account: 135-69005-020-000 Capital Outlays 1374 04/14/2016 April A/P Fencing for Lift stations 6 & 57,940.75 15,592.24 73,532.99 DIAMOND B FENCE & CONCRETE 1794 AP 1421 04/21/2016 Apr A/P 24" WW Aerial Crossing 14,051.01 87,584.00 CP&Y/WALLACE GROUP, INC. 1806 AP 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS 71.88 87,655.88 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS 503.16 88,159.04 AMAZON MKTPLACE PMTS PC 1464 04/29/2016 Move Aerial WW Expense Move Aerial WW Expense 81,943.24 170,102.28 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 112,161.53 170,102.28 ** 356,000.00 Budgeted 185,897.72 Remaining 48 % Used Account: 135-69008-020-000 Short Term Debt-Principal 21,276.80 .00 21,276.80 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 21,276.80 ** 21,280.00 Budgeted 3.20 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 197.00 .00 197.00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 197.00 ** 197.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,163,453.28 ** 2,140,864.00 Budgeted 977,410.72 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2016 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-026-000 Salaries & Wages 1282 04/08/2016 MUD Payroll 4/18/16 Salaries & Wages 3,300.00 900.00 4,200.00 PR 1404 04/22/2016 MUD Payroll 4/22/16 Salaries & Wages 500.00 4,700.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,400.00 4,700.00 ** 12,500.00 Budgeted 7,800.00 Remaining 38 % Used Account: 135-50030-026-000 Social Security Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Social Security Taxes 204.60 55.80 260.40 PR 1404 04/22/2016 MUD Payroll 4/22/16 Social Security Taxes 31.00 291.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 86.80 291.40 ** 775.00 Budgeted 483.60 Remaining 38 % Used Account: 135-50035-026-000 Medicare Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Medicare Taxes 47.85 13.05 60.90 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medicare Taxes 7.25 68.15 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 20.30 68.15 ** 181.00 Budgeted 112.85 Remaining 38 % Used Account: 135-50040-026-000 Unemployment Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Unemployment Taxes 12.30 40.50 52.80 PR 1404 04/22/2016 MUD Payroll 4/22/16 Unemployment Taxes (17.10) 35.70 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 23.40 35.70 ** 12.00 Budgeted (23.70) Remaining 298 % Used Account: 135-50045-026-000 Workman's Compensation 138 04/01/2016 Prepaid Insurance, W/C Apr 31.49 3.08 34.57 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 34.57 ** 50.00 Budgeted 15.43 Remaining 69 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2016 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-026-000 Dues & Memberships 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 21.67 .00 21.67 _______________ Account: 135-60075-026-000 Meetings Totals: .00 21.67 ** 1,200.00 Budgeted 1,178.33 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training 905.00 .00 905.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 905.00 ** 4,000.00 Budgeted 3,095.00 Remaining 23 % Used Account: 135-60100-026-000 Travel & per diem 1,602.43 .00 1,602.43 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,602.43 ** 5,000.00 Budgeted 3,397.57 Remaining 32 % Used Account: 135-60245-026-000 Miscellaneous Expenses 50.48 .00 50.48 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 7,720.38 ** 26,368.00 Budgeted 18,647.62 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 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 1282 04/08/2016 MUD Payroll 4/18/16 Salaries & Wages 227,283.97 19,002.08 246,286.05 PR 1404 04/22/2016 MUD Payroll 4/22/16 Salaries & Wages 18,887.71 265,173.76 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,889.79 265,173.76 ** 493,633.00 Budgeted 228,459.24 Remaining 54 % Used Account: 135-50010-030-000 Overtime 1282 04/08/2016 MUD Payroll 4/18/16 Overtime 151.76 215.82 367.58 PR 1404 04/22/2016 MUD Payroll 4/22/16 Overtime 4.22 371.80 PR _______________ Account: 135-50010-030-000 Overtime Totals: 220.04 371.80 ** 500.00 Budgeted 128.20 Remaining 74 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1282 04/08/2016 MUD Payroll 4/18/16 Retirement 20,403.79 1,677.72 22,081.51 PR 1404 04/22/2016 MUD Payroll 4/22/16 Retirement 1,649.26 23,730.77 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,326.98 23,730.77 ** 43,652.00 Budgeted 19,921.23 Remaining 54 % Used Account: 135-50026-030-000 Medical Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Medical Insurance 30,595.79 2,655.37 33,251.16 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medical Insurance 2,655.35 35,906.51 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,310.72 35,906.51 ** 68,196.00 Budgeted 32,289.49 Remaining 53 % Used Account: 135-50027-030-000 Dental Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Dental Insurance 2,084.20 189.41 2,273.61 PR 1404 04/22/2016 MUD Payroll 4/22/16 Dental Insurance 189.38 2,462.99 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 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: 378.79 2,462.99 ** 4,807.00 Budgeted 2,344.01 Remaining 51 % Used Account: 135-50028-030-000 Vision Insurance 1282 04/08/2016 MUD Payroll 4/18/16 Vision Insurance 481.05 43.60 524.65 PR 1404 04/22/2016 MUD Payroll 4/22/16 Vision Insurance 43.54 568.19 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 87.14 568.19 ** 1,114.00 Budgeted 545.81 Remaining 51 % Used Account: 135-50029-030-000 Life Insurance & Other 1193 04/01/2016 Apr A/P April Dental, LTD, STD,Life, A 2,326.27 363.39 2,689.66 METLIFE GROUP BENEFITS 1699 AP 1439 04/26/2016 April A/P Café 125 Admin fee 29.16 2,718.82 BenefitMall AP 1516 04/30/2016 Rounding adj (.04) 2,718.78 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 392.51 2,718.78 ** 5,431.00 Budgeted 2,712.22 Remaining 50 % Used Account: 135-50030-030-000 Social Security Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Social Security Taxes 13,374.34 1,104.63 14,478.97 PR 1404 04/22/2016 MUD Payroll 4/22/16 Social Security Taxes 1,079.22 15,558.19 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,183.85 15,558.19 ** 31,141.00 Budgeted 15,582.81 Remaining 50 % Used Account: 135-50035-030-000 Medicare Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Medicare Taxes 3,127.86 258.34 3,386.20 PR 1404 04/22/2016 MUD Payroll 4/22/16 Medicare Taxes 252.39 3,638.59 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 510.73 3,638.59 ** 7,678.00 Budgeted 4,039.41 Remaining 47 % Used Account: 135-50040-030-000 Unemployment Taxes 1282 04/08/2016 MUD Payroll 4/18/16 Unemployment Taxes 1,150.65 23.65 1,174.30 PR 1404 04/22/2016 MUD Payroll 4/22/16 Unemployment Taxes 21.47 1,195.77 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 45.12 1,195.77 ** 1,197.00 Budgeted 1.23 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 138 04/01/2016 Prepaid Insurance, W/C Apr 1,179.34 147.89 1,327.23 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,327.23 ** 1,554.00 Budgeted 226.77 Remaining 85 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1504 04/26/2016 April A/P SALAD BOWL 10 2,880.22 54.00 2,934.22 SALAD BOWL 10 PC 1504 04/26/2016 April A/P HOT AND CREAMY DONUTS 7.85 2,942.07 HOT AND CREAMY DONUTS PC 1504 04/26/2016 April A/P STARBUCKS #06552 TROPH 44.85 2,986.92 STARBUCKS #06552 TROPH PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 106.70 2,986.92 ** 4,500.00 Budgeted 1,513.08 Remaining 66 % Used Account: 135-55030-030-000 Software & Support 1356 04/11/2016 Apr A/P Internet 31,477.16 1,101.17 32,578.33 WHOLESALE CARRIER SERVICES INC 1789 AP 1421 04/21/2016 Apr A/P Splashtop License 60.00 32,638.33 M3 Networks 1810 AP 1439 04/26/2016 April A/P Cash Receipts 96.00 32,734.33 STW INC AP 1504 04/26/2016 April A/P ATT*BILL PAYMENT 166.46 32,900.79 ATT*BILL PAYMENT PC 1504 04/26/2016 April A/P ATT*BILL PAYMENT 150.14 33,050.93 ATT*BILL PAYMENT PC 1446 04/28/2016 April A/P Annual Renewal Software Maint 495.00 33,545.93 WIN-911 SOFTWARE AP 1509 04/30/2016 April A/P Renew Bank Rec software 600.00 34,145.93 CONWAY CONSULTING AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,668.77 34,145.93 ** 81,097.00 Budgeted 46,951.07 Remaining 42 % Used Account: 135-55070-030-000 Independent Labor 1465 04/29/2016 Move Water Study Move Water Study 12,971.98 (11,952.60) 1,019.38 GL _______________ Account: 135-55070-030-000 Independent Labor Totals: (11,952.60) 1,019.38 ** 12,000.00 Budgeted 10,980.62 Remaining 8 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1463 04/29/2016 Move Mowing Expenses Move Mowing Expenses 11,128.35 (5,160.00) 5,968.35 GL _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: (5,160.00) 5,968.35 ** 7,000.00 Budgeted 1,031.65 Remaining 85 % Used Account: 135-55100-030-000 Building Maint & Supplies 1439 04/26/2016 April A/P Rug Service 4,326.92 130.89 4,457.81 G & K SERVICES AP 1439 04/26/2016 April A/P Rug Service 130.89 4,588.70 G & K SERVICES AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (130.89) 4,457.81 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 130.89 4,457.81 ** 7,000.00 Budgeted 2,542.19 Remaining 64 % Used Account: 135-55120-030-000 Cleaning Services 1374 04/14/2016 April A/P March Janitorial service 2,664.75 843.75 3,508.50 MEMBER'S BUILDING MAINTENANCE 1797 AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (259.00) 3,249.50 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 3,249.50 ** 10,125.00 Budgeted 6,875.50 Remaining 32 % Used Account: 135-55160-030-000 Professional Outside Services 53,072.50 .00 53,072.50 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 53,072.50 ** 72,575.00 Budgeted 19,502.50 Remaining 73 % 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 1374 04/14/2016 April A/P UB billing/March, Inserts 3,122.47 653.70 3,776.17 DATAPROSE LLC 1792 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 653.70 3,776.17 ** 8,200.00 Budgeted 4,423.83 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 1236 04/01/2016 April A/P April Answering service 6,396.03 210.30 6,606.33 KEYSTONE PARK SECRETARIAL 1724 AP 1421 04/21/2016 Apr A/P Answering Service 199.30 6,805.63 KEYSTONE PARK SECRETARIAL 1809 AP 1504 04/26/2016 April A/P RINGCENTRAL, INC 10.73 6,816.36 RINGCENTRAL, INC PC 1504 04/26/2016 April A/P ATT*BUS PHONE PMT 820.31 7,636.67 ATT*BUS PHONE PMT PC 1504 04/26/2016 April A/P ATT*BUS PHONE PMT 434.91 8,071.58 ATT*BUS PHONE PMT PC 1504 04/26/2016 April A/P ATT*BUS PHONE PMT 820.63 8,892.21 ATT*BUS PHONE PMT PC 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (438.88) 8,453.33 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,057.30 8,453.33 ** 16,349.00 Budgeted 7,895.67 Remaining 52 % Used Account: 135-60010-030-000 Communications/Mobiles 1356 04/11/2016 Apr A/P Cells 3/2-4/1/16 2,027.94 37.99 2,065.93 VERIZON WIRELESS 1788 AP 1404 04/22/2016 MUD Payroll 4/22/16 Communications/Mobiles 300.00 2,365.93 PR 1504 04/26/2016 April A/P VERIZON WIRELESS 15181 97.41 2,463.34 VERIZON WIRELESS 15181 PC _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 435.40 2,463.34 ** 4,150.00 Budgeted 1,686.66 Remaining 59 % Used Account: 135-60020-030-000 Electricity/Gas 3,711.28 .00 3,711.28 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 3,711.28 ** 10,768.00 Budgeted 7,056.72 Remaining 34 % Used Account: 135-60025-030-000 Water 1509 04/30/2016 April A/P April Water 458.67 114.79 573.46 TROPHY CLUB MUD (WATER BILLS) AP 1514 04/30/2016 Bill Town April Inv AR 20160430-20160430 User: (57.39) 516.07 AR _______________ Account: 135-60025-030-000 Water Totals: 57.40 516.07 ** 1,500.00 Budgeted 983.93 Remaining 34 % Used Account: 135-60035-030-000 Postage 1374 04/14/2016 April A/P UB billing/March, Inserts 12,192.00 1,769.60 13,961.60 DATAPROSE LLC 1792 AP 1504 04/26/2016 April A/P USPS 48764506630613152 22.95 13,984.55 USPS 48764506630613152 PC 1446 04/28/2016 April A/P Overnight letter 5.55 13,990.10 FEDERAL EXPRESS CORP AP _______________ Account: 135-60035-030-000 Postage Totals: 1,798.10 13,990.10 ** 28,932.00 Budgeted 14,941.90 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 1365 04/04/2016 Credit Card fees 31,060.94 46.01 31,106.95 GL 1365 04/04/2016 Credit Card fees 3,136.66 34,243.61 GL 1285 04/08/2016 Child support fee 4/8/16 P/R 1.50 34,245.11 GL 1406 04/22/2016 Expert Pay fee/Child support 1.50 34,246.61 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,185.67 34,246.61 ** 55,560.00 Budgeted 21,313.39 Remaining 62 % Used Account: 135-60050-030-000 Bad Debt Expense 2,015.35 .00 2,015.35 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 2,015.35 ** 3,500.00 Budgeted 1,484.65 Remaining 58 % Used Account: 135-60055-030-000 Insurance 138 04/01/2016 Prepaid Insurance, W/C Apr 16,837.00 2,756.00 19,593.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 19,593.00 ** 52,797.00 Budgeted 33,204.00 Remaining 37 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1504 04/26/2016 April A/P AMER CHAMBER OF COMM 260.00 260.00 AMER CHAMBER OF COMM PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 260.00 260.00 ** 1,600.00 Budgeted 1,340.00 Remaining 16 % Used Account: 135-60070-030-000 Dues & Memberships 5,006.25 .00 5,006.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 5,006.25 ** 6,000.00 Budgeted 993.75 Remaining 83 % Used Account: 135-60075-030-000 Meetings 29.00 .00 29.00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 29.00 ** 400.00 Budgeted 371.00 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 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 1251 04/01/2016 April A/P Face Painting/Waterfest 3,646.23 180.00 3,826.23 TRACY HENRY 1733 AP 1370 04/14/2016 April A/P Tip for In & Out Burger Worker 160.00 3,986.23 KEVIN CARR 1791 AP 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS (13.74) 3,972.49 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P RANDALLS STORE00017897 250.00 4,222.49 RANDALLS STORE00017897 PC 1504 04/26/2016 April A/P WM SUPERCENTER #5247 24.26 4,246.75 WM SUPERCENTER #5247 PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS (23.98) 4,222.77 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS (23.98) 4,198.79 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P PARTY CITY 12.98 4,211.77 PARTY CITY PC 1504 04/26/2016 April A/P WALGREENS #5476 22.79 4,234.56 WALGREENS #5476 PC 1504 04/26/2016 April A/P WM SUPERCENTER #5247 19.14 4,253.70 WM SUPERCENTER #5247 PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS (54.96) 4,198.74 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS (27.48) 4,171.26 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P SIGNSONTHECHEAP.COM (40.22) 4,131.04 SIGNSONTHECHEAP.COM PC 1504 04/26/2016 April A/P WM SUPERCENTER #266 43.37 4,174.41 WM SUPERCENTER #266 PC 1509 04/30/2016 April A/P Waterfest supplies 55.93 4,230.34 COSTCO WHOLESALE AP _______________ Account: 135-60079-030-000 Public Education Totals: 584.11 4,230.34 ** 5,000.00 Budgeted 769.66 Remaining 85 % Used Account: 135-60080-030-000 Schools & Training 1504 04/26/2016 April A/P 360 WATER INC 3,272.50 19.50 3,292.00 360 WATER INC PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 19.50 3,292.00 ** 9,935.00 Budgeted 6,643.00 Remaining 33 % Used Account: 135-60100-030-000 Travel & per diem 1282 04/08/2016 MUD Payroll 4/18/16 Travel & per diem 2,468.00 156.55 2,624.55 PR 1504 04/26/2016 April A/P CFW PARKING METER 2.50 2,627.05 CFW PARKING METER PC 1504 04/26/2016 April A/P STARBUCKS OMNI FT WORT 2.00 2,629.05 STARBUCKS OMNI FT WORT PC 1504 04/26/2016 April A/P FOUR STAR CAFE DOWNTOW 23.16 2,652.21 FOUR STAR CAFE DOWNTOW PC 1504 04/26/2016 April A/P CFW COMMERCE ST GARAGE 15.00 2,667.21 CFW COMMERCE ST GARAGE PC 1504 04/26/2016 April A/P CFW COMMERCE ST GARAGE 15.00 2,682.21 CFW COMMERCE ST GARAGE PC 1504 04/26/2016 April A/P CFW COMMERCE ST GARAGE 15.00 2,697.21 CFW COMMERCE ST GARAGE PC 1504 04/26/2016 April A/P CFW PARKING METER 1.25 2,698.46 CFW PARKING METER PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 230.46 2,698.46 ** 5,400.00 Budgeted 2,701.54 Remaining 50 % Used Account: 135-60110-030-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 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-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1439 04/26/2016 April A/P Election Notice 6.00 1,054.02 1,060.02 STAR-TELEGRAM OPERATING LTD AP _______________ Account: 135-60115-030-000 Elections Totals: 1,054.02 1,060.02 ** 7,500.00 Budgeted 6,439.98 Remaining 14 % Used Account: 135-60125-030-000 Advertising 61.74 .00 61.74 _______________ Account: 135-60125-030-000 Advertising Totals: .00 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1504 04/26/2016 April A/P VCN*DENTONRECCTR 4,073.98 192.00 4,265.98 VCN*DENTONRECCTR PC 1504 04/26/2016 April A/P TARRANT CO TX CLERK GR 3.84 4,269.82 TARRANT CO TX CLERK GR PC 1504 04/26/2016 April A/P TARRANT CO TX CLERK GR 128.00 4,397.82 TARRANT CO TX CLERK GR PC 1504 04/26/2016 April A/P THE HOME DEPOT 6572 58.23 4,456.05 THE HOME DEPOT 6572 PC 1504 04/26/2016 April A/P THE HOME DEPOT 6581 661.00 5,117.05 THE HOME DEPOT 6581 PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 1,043.07 5,117.05 ** 17,501.00 Budgeted 12,383.95 Remaining 29 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65010-030-000 Uniforms 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 5,871.85 .00 5,871.85 _______________ Account: 135-65055-030-000 Hardware Totals: .00 5,871.85 ** 13,594.00 Budgeted 7,722.15 Remaining 43 % Used Account: 135-65085-030-000 Office Supplies 1439 04/26/2016 April A/P Office Supplies 3,424.20 48.42 3,472.62 OFFICE DEPOT, INC AP 1439 04/26/2016 April A/P Office Supplies 25.92 3,498.54 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 74.34 3,498.54 ** 9,000.00 Budgeted 5,501.46 Remaining 39 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 406.44 .00 406.44 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 406.44 ** 4,003.00 Budgeted 3,596.56 Remaining 10 % Used Account: 135-65095-030-000 Maintenance Supplies 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS 2,092.04 41.97 2,134.01 AMAZON MKTPLACE PMTS PC 1504 04/26/2016 April A/P AMAZON MKTPLACE PMTS 19.96 2,153.97 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 61.93 2,153.97 ** 5,000.00 Budgeted 2,846.03 Remaining 43 % Used Account: 135-65105-030-000 Printing 1374 04/14/2016 April A/P UB billing/March, Inserts 59.88 1,289.00 1,348.88 DATAPROSE LLC 1792 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,289.00 1,348.88 ** 4,800.00 Budgeted 3,451.12 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays 1421 04/21/2016 Apr A/P MUD Restroom Renovation 6,158.00 847.50 7,005.50 CP&Y/WALLACE GROUP, INC. 1806 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 847.50 7,005.50 ** 56,000.00 Budgeted 48,994.50 Remaining 13 % Used Account: 135-69170-030-000 Copier Lease Installments 1374 04/14/2016 April A/P Copier lease 1,672.85 165.00 1,837.85 EVERBANK COMMERCIAL FINANCE 1795 AP 1439 04/26/2016 April A/P Printer Copies 96.28 1,934.13 KYOCERA DOCUMENT SOLUTIONS AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 261.28 1,934.13 ** 4,600.00 Budgeted 2,665.87 Remaining 42 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 594,794.27 ** 1,203,217.00 Budgeted 608,422.73 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2016 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 1401 04/19/2016 April A/P PUC Legal Retainer 120,596.39 70,000.00 190,596.39 The Liston Law Firm, P.C. 1803 AP 1486 04/29/2016 April A/P March Legal/PUC 1,665.00 192,261.39 THE LISTON LAW FIRM, P.C. AP 1486 04/29/2016 April A/P March Legal/WWTP WCP Contract 1,710.00 193,971.39 THE LISTON LAW FIRM, P.C. AP 1486 04/29/2016 April A/P March Legal/Fort Worth Waterli 30.00 194,001.39 THE LISTON LAW FIRM, P.C. AP 1486 04/29/2016 April A/P March Legal/General 3,948.50 197,949.89 THE LISTON LAW FIRM, P.C. AP 1509 04/30/2016 April A/P April Legal 360.00 198,309.89 FREEMAN & CORBETT AP _______________ Account: 135-55045-039-000 Legal Totals: 77,713.50 198,309.89 ** 386,130.00 Budgeted 187,820.11 Remaining 51 % Used Account: 135-55055-039-000 Auditing 24,039.38 .00 24,039.38 _______________ Account: 135-55055-039-000 Auditing Totals: .00 24,039.38 ** 24,039.00 Budgeted (.38) Remaining 100 % Used Account: 135-55060-039-000 Appraisal 6,224.41 .00 6,224.41 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,224.41 ** 10,265.00 Budgeted 4,040.59 Remaining 61 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 231,042.50 ** 424,234.00 Budgeted 193,191.50 Remaining 54 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 627,938.46 .00 Budgeted (627,938.46) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2016 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 (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,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: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET APRIL 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,384,491 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,384,491 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 5,928 TOTAL FUND BALANCE 4,384,491 TOTAL LIABILITIES AND FUND BALANCE 4,384,491 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:37 05/05/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,217.54- 5,928.05- 5,928.05 Subtotal: 1,217.54- 5,928.05- 5,928.05 Program number: 1,217.54- 5,928.05- 5,928.05 Department number: Revenues 1,217.54- 5,928.05- 5,928.05 Revenues Subtotal ----------- 1,217.54- 5,928.05- 5,928.05 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,217.54- 5,928.05- 5,928.05 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2016 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 1502 04/30/2016 Bank Interest/April (4,710.51) (1,217.54) (5,928.05) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,217.54) (5,928.05) ** .00 Budgeted 5,928.05 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,928.05) ** .00 Budgeted 5,928.05 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (5,928.05) .00 Budgeted 5,928.05 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET APRIL 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 6,198,138 ACCOUNTS RECEIVABLE - TOTAL ASSETS 6,198,138 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 282,936 TOTAL LIABILITIES 282,936 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (2,418,902) TOTAL FUND BALANCE 5,915,202 TOTAL LIABILITIES AND FUND BALANCE 6,198,138 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:37 05/05/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,822.72- 10,416.49- 10,416.49 Subtotal: 1,822.72- 10,416.49- 10,416.49 Program number: 1,822.72- 10,416.49- 10,416.49 Department number: Revenues 1,822.72- 10,416.49- 10,416.49 Revenues Subtotal ----------- 1,822.72- 10,416.49- 10,416.49 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:37 05/05/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 820,339.89 2,429,318.04 2,429,318.04- Subtotal: 820,339.89 2,429,318.04 2,429,318.04- Program number: 820,339.89 2,429,318.04 2,429,318.04- Department number: Wastewater 820,339.89 2,429,318.04 2,429,318.04- Expenditures Subtotal ----------- 820,339.89 2,429,318.04 2,429,318.04- Fund number: 518 2015 Revenue Bond Const Fund 818,517.17 2,418,901.55 2,418,901.55- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 1502 04/30/2016 Bank Interest/April (8,593.77) (1,822.72) (10,416.49) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,822.72) (10,416.49) ** .00 Budgeted 10,416.49 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (10,416.49) ** .00 Budgeted 10,416.49 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 1381 04/15/2016 April A/P WWTP Improvements App #6 1,608,978.15 710,532.20 2,319,510.35 WEBBER-CADAGUA PARTNERS 1802 AP 1383 04/15/2016 Webber-Cadauga Retainage App 6 78,614.69 2,398,125.04 GL 1421 04/21/2016 Apr A/P WWTP Improvements 28,903.00 2,427,028.04 CP&Y/WALLACE GROUP, INC. 1806 AP 1421 04/21/2016 Apr A/P Plat/WWTP 2,290.00 2,429,318.04 CP&Y/WALLACE GROUP, INC. 1806 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 820,339.89 2,429,318.04 ** .00 Budgeted (2,429,318.04) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 2,429,318.04 ** .00 Budgeted (2,429,318.04) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 2,418,901.55 .00 Budgeted (2,418,901.55) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 164,650 ACCOUNTS RECEIVABLE - TOTAL ASSETS 164,650 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 92,688 TOTAL FUND BALANCE 164,650 TOTAL LIABILITIES AND FUND BALANCE 164,650 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:37 05/05/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 45.68- 186.34- 186.34 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 30,834.00- 92,502.00- 75.000 30,834.00- Subtotal: 123,336.00- 123,336.00- 30,879.68- 92,688.34- 75.151 30,647.66- Program number: 123,336.00- 123,336.00- 30,879.68- 92,688.34- 75.151 30,647.66- Department number: 123,336.00- 123,336.00- 30,879.68- 92,688.34- 75.151 30,647.66- Revenues Subtotal ----------- 123,336.00- 123,336.00- 30,879.68- 92,688.34- 75.151 30,647.66- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 30,879.68- 92,688.34- 75.151 30,647.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2016 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 1502 04/30/2016 Bank Interest/April (140.66) (45.68) (186.34) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (45.68) (186.34) ** .00 Budgeted 186.34 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1248 04/01/2016 Texpool Transfers O&M to Rev Bond Reserve (61,668.00) (30,834.00) (92,502.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (30,834.00) (92,502.00) ** (123,336.00) Budgeted (30,834.00) Remaining 75 % Used Department Totals: ------------------------------------------------------------------------------------------------ (92,688.34) ** (123,336.00) Budgeted (30,647.66) Remaining 75 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (92,688.34) (123,336.00) Budgeted (30,647.66) Remaining 75 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 773,747 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 27,882 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 806,475 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 27,882 ACCOUNTS AND OTHER PAYABLES 8,573 TOTAL LIABILITIES 36,455 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 745,848 TOTAL FUND BALANCE 770,020 TOTAL LIABILITIES AND FUND BALANCE 806,475 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:37 05/05/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 6,132.66 648,016.62- 97.023 19,881.38- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 221.81- 1,155.34- 50.232 1,144.66- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 395.03- 1,612.50- 89.583 187.50- Subtotal: 671,998.00- 671,998.00- 5,515.82 650,784.46- 96.843 21,213.54- 533-49010-000-000 Interest Income 140.00- 140.00- 214.44- 723.46- 516.757 583.46 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 19,951.00- 39,902.00- 33.333 79,804.00- Subtotal: 334,225.00- 334,225.00- 20,165.44- 255,004.46- 76.297 79,220.54- Program number: 1,006,223.00- 1,006,223.00- 14,649.62- 905,788.92- 90.019 100,434.08- Department number: Revenues 1,006,223.00- 1,006,223.00- 14,649.62- 905,788.92- 90.019 100,434.08- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 14,649.62- 905,788.92- 90.019 100,434.08- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 14:37 05/05/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 158,691.25 50.063 158,291.75 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Program number: 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Department number: Administration 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 14,649.62- 745,847.67- ############### 744,157.67 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2016 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 1449 04/01/2016 Property Taxes (654,149.28) (62.72) (654,212.00) GL 1450 04/04/2016 Property Taxes (511.97) (654,723.97) GL 1451 04/05/2016 Property Taxes (755.09) (655,479.06) GL 1452 04/06/2016 Property Taxes (85.93) (655,564.99) GL 1453 04/07/2016 Property Taxes (449.77) (656,014.76) GL 1454 04/08/2016 Property Taxes (50.16) (656,064.92) GL 1455 04/11/2016 Property Taxes (226.65) (656,291.57) GL 1456 04/12/2016 Property Taxes (9.94) (656,301.51) GL 1458 04/19/2016 Property Taxes (46.07) (656,347.58) GL 1459 04/21/2016 Property Taxes 228.21 (656,119.37) GL 1497 04/22/2016 Property Taxes (310.08) (656,429.45) GL 1460 04/25/2016 Property Taxes (136.07) (656,565.52) GL 1486 04/29/2016 April A/P Refund Tax Shortage 8,759.70 (647,805.82) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (210.80) (648,016.62) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: 6,132.66 (648,016.62) ** (667,898.00) Budgeted (19,881.38) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1455 04/11/2016 Property Taxes (933.53) (93.95) (1,027.48) GL 1457 04/13/2016 Property Taxes (41.02) (1,068.50) GL 1459 04/21/2016 Property Taxes 115.33 (953.17) GL 1497 04/22/2016 Property Taxes 7.13 (946.04) GL 1486 04/29/2016 April A/P Refund Tax Shortage (110.58) (1,056.62) DENTON COUNTY TAX OFFICE AP 1490 04/29/2016 Property Taxes (98.72) (1,155.34) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (221.81) (1,155.34) ** (2,300.00) Budgeted (1,144.66) Remaining 50 % Used Account: 533-40015-000-000 Property Taxes/P & I 1450 04/04/2016 Property Taxes (1,217.47) (1.56) (1,219.03) GL 1451 04/05/2016 Property Taxes (57.66) (1,276.69) GL 1452 04/06/2016 Property Taxes .02 (1,276.67) GL 1453 04/07/2016 Property Taxes (35.64) (1,312.31) GL 1454 04/08/2016 Property Taxes (7.23) (1,319.54) GL 1455 04/11/2016 Property Taxes (30.96) (1,350.50) GL 1457 04/13/2016 Property Taxes (109.11) (1,459.61) GL 1459 04/21/2016 Property Taxes (2.55) (1,462.16) GL 1497 04/22/2016 Property Taxes (36.82) (1,498.98) GL 1486 04/29/2016 April A/P Refund Tax Shortage (76.50) (1,575.48) DENTON COUNTY TAX OFFICE AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1490 04/29/2016 Property Taxes (1,217.47) (37.02) (1,612.50) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (395.03) (1,612.50) ** (1,800.00) Budgeted (187.50) Remaining 90 % Used Account: 533-49010-000-000 Interest Income 1502 04/30/2016 Bank Interest/April (509.02) (214.44) (723.46) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (214.44) (723.46) ** (140.00) Budgeted 583.46 Remaining 517 % Used Account: 533-49015-000-000 Lease/Rental Income (214,379.00) .00 (214,379.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,379.00) ** (214,379.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1248 04/01/2016 Texpool Transfers PID Surcharge to Debt Svc (19,951.00) (19,951.00) (39,902.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (39,902.00) ** (119,706.00) Budgeted (79,804.00) Remaining 33 % Used Department Totals: ------------------------------------------------------------------------------------------------ (905,788.92) ** (1,006,223.00) Budgeted (100,434.08) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 158,691.25 .00 158,691.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 158,691.25 ** 316,983.00 Budgeted 158,291.75 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 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 159,941.25 ** 1,004,533.00 Budgeted 844,591.75 Remaining 16 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (745,847.67) (1,690.00) Budgeted 744,157.67 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 169,528 ACCOUNTS RECEIVABLE - TOTAL ASSETS 169,528 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 154,460 TOTAL FUND BALANCE 169,528 TOTAL LIABILITIES AND FUND BALANCE 169,528 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 14:37 05/05/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 47.11- 121.81- 1,740.143 114.81 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 271,956.24- 61.137 172,874.76- Subtotal: 444,838.00- 444,838.00- 43,267.43- 272,078.05- 61.163 172,759.95- Program number: 444,838.00- 444,838.00- 43,267.43- 272,078.05- 61.163 172,759.95- Department number: Revenues 444,838.00- 444,838.00- 43,267.43- 272,078.05- 61.163 172,759.95- Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,267.43- 272,078.05- 61.163 172,759.95- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 14:37 05/05/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 117,618.75 50.085 117,219.25 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Program number: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Department number: Administration 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Expenditures Subtotal ----------- 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Fund number: 534 2015 Revenue Bond I&S 43,267.43- 154,459.30- 154,459.30 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2016 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 1502 04/30/2016 Bank Interest/April (74.70) (47.11) (121.81) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (47.11) (121.81) ** (7.00) Budgeted 114.81 Remaining 1.740 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1248 04/01/2016 Texpool Transfers O&M to Rev Bond Debt Svc (228,735.92) (43,220.32) (271,956.24) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (271,956.24) ** (444,831.00) Budgeted (172,874.76) Remaining 61 % Used Department Totals: ------------------------------------------------------------------------------------------------ (272,078.05) ** (444,838.00) Budgeted (172,759.95) Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 61 11:30 05/05/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 117,618.75 .00 117,618.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 117,618.75 ** 234,838.00 Budgeted 117,219.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 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 117,618.75 ** 444,838.00 Budgeted 327,219.25 Remaining 26 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (154,459.30) .00 Budgeted 154,459.30 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 1,522,260.80 **** (125,026.00) Budgeted (1,647,286.80) Remaining ########## ******* End of Report *********