Loading...
HomeMy WebLinkAbout2017-04 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2017 122 ASSETS FIRE DEPT. CASH IN BANK 694 INVESTMENTS 972,433 PREPAID EXPENSES 6,880 ADVALOREM PROPERTY TAXES RECEIVABLE 32,628 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,012,635 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 32,628 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 32,628 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 458,899 TOTAL FUND BALANCE 980,007 TOTAL LIABILITIES AND FUND BALANCE 1,012,635 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 18:31 05/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 6,658.06- 1,019,834.47- 98.458 15,975.53- 122-40011-000-000 Property Taxes/Fire-Delinquent 7.02- 1,967.93- 1,967.93 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 439.41- 2,553.75- 56.750 1,946.25- Subtotal: 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,468.17- 98.477 15,841.83- 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 18:31 05/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 10,753.91 10,753.91- Subtotal: 10,753.91 10,753.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 9,632.63 58.334 6,880.37 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 336,763.00 57.899 244,875.00 Subtotal: 814,905.00 814,905.00 50,350.09 346,395.63 42.507 468,509.37 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.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: 225,405.00 225,405.00 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Fund number: 122 Trophy Club MUD Fire Dept. 43,245.60 458,899.03- 458,899.03 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 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 (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1417 04/03/2017 Property Taxes (1,013,176.41) (115.66) (1,013,292.07) GL 1418 04/04/2017 Property Taxes (889.43) (1,014,181.50) GL 1419 04/05/2017 Property Taxes (42.31) (1,014,223.81) GL 1420 04/06/2017 Property Taxes (69.89) (1,014,293.70) GL 1422 04/07/2017 Property Taxes (1,047.57) (1,015,341.27) GL 1423 04/10/2017 Property Taxes 1,047.57 (1,014,293.70) GL 1424 04/11/2017 Property Taxes (2,143.84) (1,016,437.54) GL 1425 04/13/2017 Property Taxes (313.00) (1,016,750.54) GL 1427 04/18/2017 Property Taxes (142.82) (1,016,893.36) GL 1428 04/20/2017 Property Taxes (509.83) (1,017,403.19) GL 1429 04/21/2017 Property Taxes (896.92) (1,018,300.11) GL 1430 04/25/2017 Property Taxes (4.98) (1,018,305.09) GL 1431 04/26/2017 Property Taxes (1,309.63) (1,019,614.72) GL 1432 04/28/2017 Property Taxes (219.75) (1,019,834.47) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (6,658.06) (1,019,834.47) ** (1,035,810.00) Budgeted (15,975.53) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1418 04/04/2017 Property Taxes (1,960.91) (.24) (1,961.15) GL 1424 04/11/2017 Property Taxes (6.78) (1,967.93) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (7.02) (1,967.93) ** .00 Budgeted 1,967.93 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1417 04/03/2017 Property Taxes (2,114.34) (6.71) (2,121.05) GL 1418 04/04/2017 Property Taxes (13.10) (2,134.15) GL 1420 04/06/2017 Property Taxes (4.89) (2,139.04) GL 1424 04/11/2017 Property Taxes (164.00) (2,303.04) GL 1425 04/13/2017 Property Taxes (34.43) (2,337.47) GL 1426 04/17/2017 Property Taxes 14.21 (2,323.26) GL 1428 04/20/2017 Property Taxes (56.09) (2,379.35) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1429 04/21/2017 Property Taxes (2,114.34) (89.89) (2,469.24) GL 1430 04/25/2017 Property Taxes (.50) (2,469.74) GL 1431 04/26/2017 Property Taxes (59.91) (2,529.65) GL 1432 04/28/2017 Property Taxes (24.10) (2,553.75) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (439.41) (2,553.75) ** (4,500.00) Budgeted (1,946.25) Remaining 57 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (1,024,617.17) ** (7,104.49) Monthly Total (1,040,310.00) Budgeted (15,692.83) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 10,753.91 .00 10,753.91 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 10,753.91 ** .00 Budgeted (10,753.91) Remaining 0 % Used Account: 122-60005-045-000 Telephone 1449 04/28/2017 Adj Town Inv 1554/Overbilled AR 20170428-20170428 User: 10.00 10.00 AR 1454 04/28/2017 Recode JE 1449 AR 20170428-20170428 User: (10.00) .00 GL _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 216,754.00 Budgeted 216,754.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 466 04/01/2017 Insurance/Wrk Comp Exp Apr 8,256.54 1,376.09 9,632.63 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 9,632.63 ** 16,513.00 Budgeted 6,880.37 Remaining 58 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1339 04/19/2017 April A/P April Fire Adm 287,789.00 48,974.00 336,763.00 TOWN OF TROPHY CLUB 3077 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 336,763.00 ** 581,638.00 Budgeted 244,875.00 Remaining 58 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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: ----------------------------------- 565,718.14 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 474,591.86 Remaining 54 % Used Fund 122 Totals: ----------------------------------- (458,899.03) 43,245.60 Monthly Total .00 Budgeted 458,899.03 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2017 GTBGT GENERAL FUND GASB 4/30/2017 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 811,345 - 811,345 CASH IN BANK-SAVINGS-CASH RESERVE 180,412 - 180,412 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,174 - 713,174 INVESTMENTS-TEXPOOL 613,214 433,170 1,046,383 PREPAID EXPENSES 37,554 - 37,554 ADVALOREM PROPERTY TAXES RECEIVABLE 2,708 - 2,708 UTILITY AND OTHER ACCOUNTS RECEIVABLE 878,198 - 878,198 TOTAL ASSETS 3,272,363 433,170 3,705,533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,708 - 2,708 ACCOUNTS AND OTHER PAYABLES 632,770 - 632,770 CUSTOMER DEPOSITS 313,060 - 313,060 - TOTAL LIABILITIES 948,538 - 948,538 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,276,319 1,276,319 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 135,000 135,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 90,000 90,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 37,805 37,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 170,365 170,365 UNASSIGNED FUND BALANCE 851,803 - 851,803 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 192,216 - 192,216 - TOTAL FUND BALANCE 2,323,825 433,170 2,756,995 TOTAL LIABILITIES AND FUND BALANCE 3,272,363 433,170 3,705,533 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 391.69- 60,016.76- 98.425 960.24- 135-40002-000-000 Property Taxes/Delinquent 1.32- 164.26- 164.26 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 26.17- 165.76- 25.502 484.24- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 419.18- 60,346.78- 28.748 149,571.22- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 399,981.59- 2,622,124.11- 40.737 3,814,609.89- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 331,916.95- 1,376,852.85- 52.361 1,252,671.15- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 9,453.20- 66,182.15- 55.494 53,077.85- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,625.00- 8,500.00- 74.561 2,900.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 950.00- 47.500 1,050.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 1,950.00- 35.455 3,550.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 752.25- 17,252.25- 28.195 43,935.75- Subtotal: 9,265,606.00- 9,265,606.00- 743,728.99- 4,093,811.36- 44.183 5,171,794.64- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,571.49- 8,818.17- 110.213 817.17 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- 3,499.98- 50.000 3,500.02- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49035-000-000 Prior Year Reserves 295,408.00- 295,408.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 2,259.00- 10,015.00- 46.346 11,594.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 206.69- 6,091.98- 30.460 13,908.02- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 5,533.04- 34,830.84- 9.544 330,133.16- Program number: 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- Department number: Revenues 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 18,123.44 126,340.32 46.595 144,802.68 135-50010-010-000 Overtime 19,500.00 19,500.00 1,733.59 7,403.32 37.966 12,096.68 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 250.00 1,700.00 35.417 3,100.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,859.90 12,510.35 46.077 14,640.65 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,922.03 19,171.51 34.287 36,742.49 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 299.27 1,799.98 43.279 2,359.02 135-50028-010-000 Vision Insurance 910.00 910.00 53.76 350.21 38.485 559.79 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 230.01 1,559.97 55.654 1,243.03 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,207.17 8,369.21 44.000 10,651.79 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 282.34 1,957.33 44.005 2,490.67 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 1.33 45.00 4.386 981.00 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 7,519.12 57.171 5,632.88 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 187.09 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 28,224.09 192,183.41 44.809 236,713.59 135-55005-010-000 Engineering 5,000.00 60,000.00 16,685.25 36,224.43 60.374 23,775.57 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 5,930.23 49,749.41 38.715 78,750.59 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 102.89 823.15 10.289 7,176.85 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 482.70 2,310.80 42.015 3,189.20 Subtotal: 125,000.00 208,500.00 23,201.07 89,107.79 42.738 119,392.21 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.75 2,119.59 39.252 3,280.41 135-60020-010-000 Electricity 172,737.00 172,737.00 14,292.26 77,102.51 44.636 95,634.49 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 767.00 767.00 102.267 17.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 265.00 6.277 3,957.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 124.46 8.297 1,375.54 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 3,876.50 21,940.45 43.727 28,235.55 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 159,459.08 858,983.95 28.644 2,139,818.05 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 102.70 102.70 51.350 97.30 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 371.40- 594.60 11.892 4,405.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 3,000.00 3,000.00 20.339 11,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 153,250.13 51.597 143,760.87 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 14,361.00 100,527.00 154.848 35,607.00- 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 217,726.77 1,218,777.39 31.902 2,601,590.61 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 1,507.03 4,907.17 19.765 19,920.83 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,329.48 28.852 3,278.52 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,523.01 8,896.34 44.482 11,103.66 135-65035-010-000 Small Tools 1,200.00 1,200.00 221.62 18.468 978.38 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 31,500.00 5,361.62 17,069.88 54.190 14,430.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 48,264.00 59.220 33,236.00 Subtotal: 256,319.00 164,636.00 8,391.66 80,688.49 49.010 83,947.51 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 90.00 288,560.69 41.795 401,861.31 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 126,958.00 126,957.75 100.000 .25 Subtotal: 696,196.00 892,380.00 90.00 490,518.44 54.967 401,861.56 Program number: 5,326,780.00 5,514,781.00 277,633.59 2,071,275.52 37.559 3,443,505.48 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2017 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 287.70 895.40 17.908 4,104.60 Subtotal: 5,000.00 5,000.00 287.70 895.40 17.908 4,104.60 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 287.70 895.40 8.954 9,104.60 Department number: Water 5,336,780.00 5,524,781.00 277,921.29 2,072,170.92 37.507 3,452,610.08 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 30,026.81 207,447.34 53.042 183,654.66 135-50010-020-000 Overtime 29,500.00 29,500.00 2,426.27 19,526.94 66.193 9,973.06 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 475.00 4,225.00 54.167 3,575.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,045.84 21,449.31 54.187 18,134.69 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 31,584.51 43.253 41,437.49 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 2,467.72 53.740 2,124.28 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 532.59 51.658 498.41 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 383.89 2,606.02 58.105 1,878.98 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,918.71 13,822.92 49.569 14,063.08 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 448.73 3,232.77 49.567 3,289.23 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 63.00 5.263 1,134.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 926.75 6,487.25 57.171 4,859.75 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 325.22 50.034 324.78 Subtotal: 605,653.00 605,653.00 44,845.85 320,405.59 52.903 285,247.41 135-55005-020-000 Engineering 70,000.00 70,000.00 70,000.00 135-55070-020-000 Independent Labor 20,000.00 20,000.00 19,449.39 97.247 550.61 135-55080-020-000 Maintenance & Repairs 83,100.00 79,700.00 5,100.72 35,474.06 44.509 44,225.94 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 20,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 1,662.14 7,057.53 106.932 457.53- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,551.48 30,402.86 55.278 24,597.14 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,708.00 16,321.00 65.284 8,679.00 Subtotal: 277,600.00 276,800.00 12,022.34 108,728.78 39.281 168,071.22 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 411.68 2,844.73 52.680 2,555.27 135-60020-020-000 Electricity 158,627.00 158,627.00 13,936.27 76,582.56 48.278 82,044.44 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 143.85 35.963 256.15 135-60070-020-000 Dues & Memberships 250.00 267.00 267.00 100.000 135-60080-020-000 Schools & Training 4,195.00 4,195.00 2,307.81 55.013 1,887.19 135-60090-020-000 Safety Program 550.00 550.00 24.99 282.15 51.300 267.85 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 115.29 2,245.50 93.563 154.50 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 14,565.97 84.933 2,584.03 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 590.00- 6,621.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 2,360.00 2,360.00 20.345 9,240.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 76,676.74 63.636 43,815.26 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 379,042.37 63.636 216,595.63 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 56,132.70 45.455 67,359.30 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,256,282.00 81,360.96 617,537.75 49.156 638,744.25 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 1,629.03 5,074.05 18.065 23,013.95 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,753.87 84.186 705.13 135-65030-020-000 Chemicals 25,000.00 21,000.00 14,942.29 71.154 6,057.71 135-65035-020-000 Small Tools 2,000.00 2,000.00 267.64 1,367.82 68.391 632.18 135-65040-020-000 Safety Equipment 750.00 750.00 252.64 33.685 497.36 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,879.52 10,668.77 76.206 3,331.23 Subtotal: 74,297.00 70,297.00 4,776.19 36,059.44 51.296 34,237.56 135-69005-020-000 Capital Outlays 485,000.00 462,000.00 196,357.40 42.502 265,642.60 Subtotal: 485,000.00 462,000.00 196,357.40 42.502 265,642.60 Program number: 2,698,015.00 2,671,032.00 143,005.34 1,279,088.96 47.887 1,391,943.04 Department number: Wastewater 2,698,015.00 2,671,032.00 143,005.34 1,279,088.96 47.887 1,391,943.04 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 2.61 18.27 57.094 13.73 Subtotal: 32.00 32.00 2.61 18.27 57.094 13.73 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,165.00 2,725.00 68.125 1,275.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,819.37 36.387 3,180.63 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 1,165.00 4,544.37 35.365 8,305.63 Program number: 12,882.00 12,882.00 1,167.61 4,562.64 35.419 8,319.36 Department number: Board of Directors 12,882.00 12,882.00 1,167.61 4,562.64 35.419 8,319.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 39,054.80 223,053.65 42.905 296,829.35 135-50010-030-000 Overtime 1,000.00 2,500.00 1,414.60 3,193.23 127.729 693.23- 135-50016-030-000 Longevity 3,890.00 3,417.00 3,417.50 100.015 .50- 135-50020-030-000 Retirement 47,768.00 47,768.00 3,743.41 20,547.77 43.016 27,220.23 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 4,551.97 25,051.23 29.721 59,237.77 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 416.81 2,169.78 36.278 3,811.22 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 88.84 464.25 35.385 847.75 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 525.18 2,420.55 41.096 3,469.45 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 2,397.57 13,481.48 41.131 19,295.52 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 560.74 3,152.92 39.002 4,931.08 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 4.98 293.73 21.471 1,074.27 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 1,018.71 57.103 765.29 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 63.00 402.35 80.470 97.65 135-50070-030-000 Employee Relations 4,960.00 4,960.00 12.00 2,583.46 52.086 2,376.54 Subtotal: 719,486.00 720,513.00 52,979.43 301,250.61 41.811 419,262.39 135-55030-030-000 Software & Support 67,791.00 77,791.00 9,157.26 65,920.45 84.740 11,870.55 135-55070-030-000 Independent Labor 12,000.00 4,000.00 932.50 23.313 3,067.50 135-55080-030-000 Maintenance & Repairs 7,000.00 2,000.00 275.00 13.750 1,725.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 485.00 4.850 9,515.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 66.47 5,805.44 82.935 1,194.56 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 3,775.36 47.192 4,224.64 135-55160-030-000 Professional Outside Services 63,325.00 60,000.00 57,332.00 95.553 2,668.00 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 1,193.50 4,412.54 53.811 3,787.46 Subtotal: 185,945.00 177,191.00 11,050.29 138,938.29 78.412 38,252.71 135-60005-030-000 Telephone 17,532.00 17,532.00 265.75 7,154.97 40.811 10,377.03 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 337.99 1,802.94 51.513 1,697.06 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 882.09 6.984 11,748.91 135-60025-030-000 Water 1,500.00 1,500.00 83.75- 650.95 43.397 849.05 135-60035-030-000 Postage 28,932.00 28,932.00 5,009.53 16,836.22 58.192 12,095.78 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 3,811.95 28,767.41 51.777 26,792.59 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 526.88 15.054 2,973.12 135-60055-030-000 Insurance 55,692.00 55,692.00 4,664.56 32,651.92 58.629 23,040.08 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 311.88 19.493 1,288.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,336.25 72.271 1,663.75 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 4,853.34 55.441 3,900.66 135-60080-030-000 Schools & Training 7,840.00 7,840.00 675.00 8.610 7,165.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 200.39 6,892.47 91.900 607.53 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 542.95 542.95 7.239 6,957.05 135-60125-030-000 Advertising 7,500.00 7,500.00 150.00 1,100.09 14.668 6,399.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 76.00 76.00 .434 17,424.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 247,491.00 14,975.37 109,101.36 44.083 138,389.64 135-65010-030-000 Uniforms 1,855.00 855.00 142.36 16.650 712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 25.00 2,264.88 23.982 7,179.12 135-65085-030-000 Office Supplies 9,000.00 9,000.00 825.15 3,792.80 42.142 5,207.20 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 478.78 478.78 23.939 1,521.22 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 139.46 1,594.32 39.858 2,405.68 135-65105-030-000 Printing 4,800.00 2,500.00 365.00 488.00 19.520 2,012.00 Subtotal: 32,099.00 27,799.00 1,833.39 8,761.14 31.516 19,037.86 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 592.50 14,445.45 5.442 250,978.55 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 300.57 2,334.08 50.741 2,265.92 Subtotal: 111,601.00 270,024.00 893.07 16,779.53 6.214 253,244.47 Program number: 1,295,172.00 1,443,018.00 81,731.55 574,830.93 39.835 868,187.07 Department number: Administration 1,295,172.00 1,443,018.00 81,731.55 574,830.93 39.835 868,187.07 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 2,160.00 38,127.01 25.418 111,872.99 135-55055-039-000 Auditing 23,860.00 23,860.00 18,808.92 78.830 5,051.08 135-55060-039-000 Appraisal 11,115.00 11,115.00 6,621.58 59.573 4,493.42 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Program number: 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Department number: Non Departmental 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 505,985.79 3,996,772.72 40.616 5,843,715.28 Fund number: 135 MUD 1 General Fund 13,456.00- 243,695.42- 192,216.26- 192,216.26 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 18:31 05/10/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2017 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 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 1417 04/03/2017 Property Taxes (59,625.07) (6.81) (59,631.88) GL 1418 04/04/2017 Property Taxes (52.32) (59,684.20) GL 1419 04/05/2017 Property Taxes (2.49) (59,686.69) GL 1420 04/06/2017 Property Taxes (4.11) (59,690.80) GL 1422 04/07/2017 Property Taxes (61.63) (59,752.43) GL 1423 04/10/2017 Property Taxes 61.63 (59,690.80) GL 1424 04/11/2017 Property Taxes (126.12) (59,816.92) GL 1425 04/13/2017 Property Taxes (18.41) (59,835.33) GL 1427 04/18/2017 Property Taxes (8.40) (59,843.73) GL 1428 04/20/2017 Property Taxes (29.99) (59,873.72) GL 1429 04/21/2017 Property Taxes (52.77) (59,926.49) GL 1430 04/25/2017 Property Taxes (.29) (59,926.78) GL 1431 04/26/2017 Property Taxes (77.05) (60,003.83) GL 1432 04/28/2017 Property Taxes (12.93) (60,016.76) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (391.69) (60,016.76) ** (60,977.00) Budgeted (960.24) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1418 04/04/2017 Property Taxes (162.94) (.02) (162.96) GL 1424 04/11/2017 Property Taxes (1.30) (164.26) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.32) (164.26) ** .00 Budgeted 164.26 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1417 04/03/2017 Property Taxes (139.59) (.39) (139.98) GL 1418 04/04/2017 Property Taxes (.77) (140.75) GL 1420 04/06/2017 Property Taxes (.29) (141.04) GL 1424 04/11/2017 Property Taxes (9.97) (151.01) GL 1425 04/13/2017 Property Taxes (2.03) (153.04) GL 1426 04/17/2017 Property Taxes .84 (152.20) GL 1428 04/20/2017 Property Taxes (3.30) (155.50) GL 1429 04/21/2017 Property Taxes (5.29) (160.79) GL 1430 04/25/2017 Property Taxes (.03) (160.82) GL 1431 04/26/2017 Property Taxes (3.52) (164.34) GL 1432 04/28/2017 Property Taxes (1.42) (165.76) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (26.17) (165.76) ** (650.00) Budgeted (484.24) Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (2,222,142.52) (399,981.59) (2,622,124.11) UB _______________ Account: 135-47000-000-000 Water Totals: (399,981.59) (2,622,124.11) ** (6,436,734.00) Budgeted (3,814,609.89) Remaining 41 % Used Account: 135-47005-000-000 Sewer 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (1,044,935.90) (331,916.95) (1,376,852.85) UB _______________ Account: 135-47005-000-000 Sewer Totals: (331,916.95) (1,376,852.85) ** (2,629,524.00) Budgeted (1,252,671.15) Remaining 52 % Used Account: 135-47025-000-000 Penalties 1389 04/11/2017 04/11/2017 UB Penalties UB20170411-20170411 User: (56,728.95) 470.98 (56,257.97) UB 1353 04/21/2017 04/21/2017 UB Penalties UB20170421-20170421 User: (10,105.81) (66,363.78) UB 1390 04/21/2017 04/21/2017 UB Penalties UB20170421-20170421 User: 23.30 (66,340.48) UB 1391 04/26/2017 04/26/2017 UB Penalties UB20170426-20170426 User: 96.40 (66,244.08) UB 1392 04/27/2017 04/27/2017 UB Penalties UB20170427-20170427 User: 61.93 (66,182.15) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,453.20) (66,182.15) ** (119,260.00) Budgeted (53,077.85) Remaining 55 % Used Account: 135-47030-000-000 Service Charges 1239 04/05/2017 04/05/2017 UB Disconnect Fees UB20170405-20170405 User: (6,875.00) (1,525.00) (8,400.00) UB 1328 04/11/2017 04/11/2017 UB NSF Fee UB20170411-20170411 User: (25.00) (8,425.00) UB 1355 04/20/2017 04/20/2017 NSF Check Fee UB20170420-20170420 User: (25.00) (8,450.00) UB 1365 04/20/2017 04/20/2017 UB NSF Fees UB20170420-20170420 User: (50.00) (8,500.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,625.00) (8,500.00) ** (11,400.00) Budgeted (2,900.00) Remaining 75 % Used Account: 135-47035-000-000 Plumbing Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (950.00) .00 (950.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (950.00) ** (2,000.00) Budgeted (1,050.00) Remaining 48 % Used Account: 135-47045-000-000 Sewer Inspections (1,950.00) .00 (1,950.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (1,950.00) ** (5,500.00) Budgeted (3,550.00) Remaining 35 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (16,500.00) (752.25) (17,252.25) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (752.25) (17,252.25) ** (61,188.00) Budgeted (43,935.75) Remaining 28 % Used Account: 135-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (7,246.68) (1,259.38) (8,506.06) GL 1440 04/30/2017 Bank Interest April 2017 (136.75) (8,642.81) GL 1440 04/30/2017 Bank Interest April 2017 (175.36) (8,818.17) GL 1440 04/30/2017 Bank Interest April 2017 (111.67) (8,929.84) GL 1475 04/30/2017 Recode Prosperity Savings int 111.67 (8,818.17) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,571.49) (8,818.17) ** (8,001.00) Budgeted 817.17 Remaining 110 % Used Account: 135-49016-000-000 Cell Tower Revenue 1447 04/17/2017 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 Account: 135-49018-000-000 Building Rent Income 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (295,408.00) Budgeted (295,408.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1345 04/18/2017 04/18/2017 UB Permits Hogans Glen HOA (7,756.00) (343.00) (8,099.00) 499A Ashville Lane-Irrig meter CR 1345 04/18/2017 04/18/2017 UB Permits Hogans Glen HOA (343.00) (8,442.00) 500A Ashville Lane-Irrig meter CR 1361 04/24/2017 04/24/2017 UB Permits 59 Meadowbrook Lane (343.00) (8,785.00) Drees Homes CR 1361 04/24/2017 04/24/2017 UB Permits 14 Katie Lane (887.00) (9,672.00) Drees Homes CR 1361 04/24/2017 04/24/2017 UB Permits 1 Sadie Court (343.00) (10,015.00) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,259.00) (10,015.00) ** (21,609.00) Budgeted (11,594.00) Remaining 46 % Used Account: 135-49900-000-000 Miscellaneous Income 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (5,885.29) (206.69) (6,091.98) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (206.69) (6,091.98) ** (20,000.00) Budgeted (13,908.02) Remaining 30 % Used Account: 135-49901-000-000 Records Management Revenue 1448 04/17/2017 ORR-Stoner (30.00) (2.00) (32.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Department Totals: ----------------------------------- (4,188,988.98) ** (749,681.21) Monthly Total (9,840,488.00) Budgeted (5,651,499.02) Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 108,216.88 9,179.60 117,396.48 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 8,943.84 126,340.32 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,123.44 126,340.32 ** 271,143.00 Budgeted 144,802.68 Remaining 47 % Used Account: 135-50010-010-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 5,669.73 1,471.78 7,141.51 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 261.81 7,403.32 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,733.59 7,403.32 ** 19,500.00 Budgeted 12,096.68 Remaining 38 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1336 04/21/2017 MUD P/R 04.21.17 Certification 1,450.00 250.00 1,700.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 250.00 1,700.00 ** 4,800.00 Budgeted 3,100.00 Remaining 35 % Used Account: 135-50020-010-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 10,650.45 985.25 11,635.70 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 874.65 12,510.35 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,859.90 12,510.35 ** 27,151.00 Budgeted 14,640.65 Remaining 46 % Used Account: 135-50026-010-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 16,249.48 1,461.01 17,710.49 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 1,461.02 19,171.51 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,922.03 19,171.51 ** 55,914.00 Budgeted 36,742.49 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 1,500.71 149.65 1,650.36 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 149.62 1,799.98 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 299.27 1,799.98 ** 4,159.00 Budgeted 2,359.02 Remaining 43 % Used Account: 135-50028-010-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 296.45 26.90 323.35 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 26.86 350.21 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.76 350.21 ** 910.00 Budgeted 559.79 Remaining 38 % Used Account: 135-50029-010-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 1,329.96 220.30 1,550.26 METLIFE GROUP BENEFITS 3042 AP 1464 04/30/2017 April A/P Café 125 Admin 9.71 1,559.97 BenefitMall AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 230.01 1,559.97 ** 2,803.00 Budgeted 1,243.03 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 7,162.04 637.46 7,799.50 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 569.71 8,369.21 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,207.17 8,369.21 ** 19,021.00 Budgeted 10,651.79 Remaining 44 % Used Account: 135-50035-010-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 1,674.99 149.10 1,824.09 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 133.24 1,957.33 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 282.34 1,957.33 ** 4,448.00 Budgeted 2,490.67 Remaining 44 % Used Account: 135-50040-010-000 Unemployment Taxes 1240 04/07/2017 MUD P/R 04.07.17 Unemployment Taxes 43.67 1.33 45.00 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 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: 1.33 45.00 ** 1,026.00 Budgeted 981.00 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 466 04/01/2017 Insurance/Wrk Comp Exp Apr 6,444.96 1,074.16 7,519.12 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 7,519.12 ** 13,152.00 Budgeted 5,632.88 Remaining 57 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 WHATABURGER 754 Q26 27.89 27.89 WHATABURGER 754 Q26 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 WHOLEFDS CLV #10523 96.03 123.92 WHOLEFDS CLV #10523 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 63.17 187.09 RANDALLS STORE00017897 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 187.09 187.09 ** 300.00 Budgeted 112.91 Remaining 62 % Used Account: 135-55005-010-000 Engineering 1249 04/06/2017 April A/P 16" WL to PD30 19,539.18 16,685.25 36,224.43 Halff Associates, INC 3024 AP _______________ Account: 135-55005-010-000 Engineering Totals: 16,685.25 36,224.43 ** 60,000.00 Budgeted 23,775.57 Remaining 60 % Used Account: 135-55080-010-000 Maintenance & Repairs 1249 04/06/2017 April A/P Repair to well #1 43,819.18 1,716.32 45,535.50 DHS AUTOMATION, INC 3018 AP 1249 04/06/2017 April A/P Tank refill 21.50 45,557.00 ALLIED WELDING SUPPLY, INC 3010 AP 1249 04/06/2017 April A/P Parts 3,501.81 49,058.81 HD SUPPLY WATERWORKS, LTD. 3025 AP 1249 04/06/2017 April A/P Meter gaskets 45.08 49,103.89 HD SUPPLY WATERWORKS, LTD. 3025 AP 1339 04/19/2017 April A/P Bolts 126.50 49,230.39 HD SUPPLY WATERWORKS, LTD. 3066 AP 1339 04/19/2017 April A/P Cones, poly 221.60 49,451.99 HD SUPPLY WATERWORKS, LTD. 3066 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 15.65 49,467.64 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 43,819.18 32.21 49,499.85 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 24.11 49,523.96 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 29.07 49,553.03 THE HOME DEPOT #6581 PC 1398 04/28/2017 April A/P Sampling valves 196.38 49,749.41 KORALEEN ENTERPRISES 3092 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,930.23 49,749.41 ** 128,500.00 Budgeted 78,750.59 Remaining 39 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ROANOKE AUTO SUPPLY LT 720.26 17.94 738.20 ROANOKE AUTO SUPPLY LT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GIERISCH CARE 0050292 84.95 823.15 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 102.89 823.15 ** 8,000.00 Budgeted 7,176.85 Remaining 10 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1339 04/19/2017 April A/P water samples 1,828.10 275.00 2,103.10 TARRANT CTY PUBLIC HEALTH LAB 3074 AP 1464 04/30/2017 April A/P TCEQ Testing 207.70 2,310.80 LOWER COLORADO RIVER AUTHORITY AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 482.70 2,310.80 ** 5,500.00 Budgeted 3,189.20 Remaining 42 % Used Account: 135-60010-010-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 1,772.84 346.75 2,119.59 VERIZON WIRELESS 3080 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM (239.92) 1,879.67 HNS*HUGHESNET.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM (239.92) 1,639.75 HNS*HUGHESNET.COM PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM 1,772.84 239.92 1,879.67 HNS*HUGHESNET.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM 239.92 2,119.59 HNS*HUGHESNET.COM PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.75 2,119.59 ** 5,400.00 Budgeted 3,280.41 Remaining 39 % Used Account: 135-60020-010-000 Electricity 1398 04/28/2017 April A/P Electricity 3/9-4/10 62,810.25 12,309.83 75,120.08 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 3/9-4/10 1,656.87 76,776.95 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 1/9-4/5 (3 mths) 325.56 77,102.51 HUDSON ENERGY SERVICES, LLC 3090 AP _______________ Account: 135-60020-010-000 Electricity Totals: 14,292.26 77,102.51 ** 172,737.00 Budgeted 95,634.49 Remaining 45 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1339 04/19/2017 April A/P 767.00 767.00 AMERICAN WATER WORKS ASSOC 3058 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 767.00 767.00 ** 750.00 Budgeted (17.00) Remaining 102 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 265.00 ** 4,222.00 Budgeted 3,957.00 Remaining 6 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-010-000 Travel & per diem 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1464 04/30/2017 April A/P Well water charge 3,876.50 3,876.50 North Texas Groundwater AP 1474 04/30/2017 Recode N TX Groundwater (3,876.50) .00 GL _______________ 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 1474 04/30/2017 Recode N TX Groundwater 18,063.95 3,876.50 21,940.45 GL _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,876.50 21,940.45 ** 50,176.00 Budgeted 28,235.55 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 1401 04/28/2017 April A/P Water-March 699,524.87 159,459.08 858,983.95 CITY OF FORT WORTH 3084 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 159,459.08 858,983.95 ** 2,998,802.00 Budgeted 2,139,818.05 Remaining 29 % Used Account: 135-60245-010-000 Miscellaneous Expenses 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TLF CRANSTONS FLOWERS 102.70 102.70 TLF CRANSTONS FLOWERS PC _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: 102.70 102.70 ** 200.00 Budgeted 97.30 Remaining 51 % Used Account: 135-60280-010-000 Property Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SC TRACKING SOLUTIONS 966.00 10.95 976.95 SC TRACKING SOLUTIONS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SC TRACKING SOLUTIONS 43.80 1,020.75 SC TRACKING SOLUTIONS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 323.85 1,344.60 THE HOME DEPOT #6581 PC 1398 04/28/2017 April A/P April mowing 1,500.00 2,844.60 WATTS ELLISON LLC 3097 AP 1471 04/28/2017 April A/P march g 750.00 3,594.60 WATTS ELLISON LLC AP 1476 04/30/2017 Recode Mowing (3,000.00) 594.60 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-010-000 Property Maintenance Totals: (371.40) 594.60 ** 5,000.00 Budgeted 4,405.40 Remaining 12 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1476 04/30/2017 Recode Mowing 3,000.00 3,000.00 GL _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 3,000.00 3,000.00 ** 14,750.00 Budgeted 11,750.00 Remaining 20 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1374 04/28/2017 Texpool Transfers 131,357.25 21,892.88 153,250.13 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 153,250.13 ** 297,011.00 Budgeted 143,760.87 Remaining 52 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1374 04/28/2017 Texpool Transfers 86,166.00 14,361.00 100,527.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 14,361.00 100,527.00 ** 64,920.00 Budgeted (35,607.00) Remaining 155 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .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 1249 04/06/2017 April A/P Fuel 3,400.14 674.08 4,074.22 US Bank Voyager Fleet Systems 3055 AP 1401 04/28/2017 April A/P Gas 832.95 4,907.17 US Bank Voyager Fleet Systems 3096 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,507.03 4,907.17 ** 24,828.00 Budgeted 19,920.83 Remaining 20 % Used Account: 135-65010-010-000 Uniforms 1,329.48 .00 1,329.48 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,329.48 ** 4,608.00 Budgeted 3,278.52 Remaining 29 % Used Account: 135-65030-010-000 Chemicals 1339 04/19/2017 April A/P LAS 7,373.33 434.64 7,807.97 Valley Solvent Company, INC 3079 AP 1398 04/28/2017 April A/P Chlorine 423.76 8,231.73 DPC INDUSTRIES, INC 3085 AP 1464 04/30/2017 April A/P chemicals 418.81 8,650.54 HACH COMPANY AP 1464 04/30/2017 April A/P chemicals 245.80 8,896.34 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,523.01 8,896.34 ** 20,000.00 Budgeted 11,103.66 Remaining 44 % Used Account: 135-65035-010-000 Small Tools 221.62 .00 221.62 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 221.62 ** 1,200.00 Budgeted 978.38 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 1398 04/28/2017 April A/P Fireline meter for new town ha 11,708.26 5,361.62 17,069.88 ATLAS ENTERPRISES, INC 3083 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 5,361.62 17,069.88 ** 31,500.00 Budgeted 14,430.12 Remaining 54 % Used Account: 135-65053-010-000 Meter Change Out Program . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 48,264.00 .00 48,264.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,264.00 ** 81,500.00 Budgeted 33,236.00 Remaining 59 % Used Account: 135-69005-010-000 Capital Outlays 1249 04/06/2017 April A/P 2.42 Bond Waterline 288,470.69 90.00 288,560.69 LanguageUSA, Inc 3033 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 90.00 288,560.69 ** 690,422.00 Budgeted 401,861.31 Remaining 42 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 1339 04/19/2017 April A/P Water samples 607.70 80.00 687.70 TARRANT CTY PUBLIC HEALTH LAB 3074 AP 1471 04/28/2017 April A/P TCEQ sampling-PID 207.70 895.40 LOWER COLORADO RIVER AUTHORITY AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 287.70 895.40 ** 5,000.00 Budgeted 4,104.60 Remaining 18 % 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,072,170.92 ** 277,921.29 Monthly Total 5,524,781.00 Budgeted 3,452,610.08 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 177,420.53 14,986.41 192,406.94 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 15,040.40 207,447.34 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,026.81 207,447.34 ** 391,102.00 Budgeted 183,654.66 Remaining 53 % Used Account: 135-50010-020-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 17,100.67 1,354.09 18,454.76 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 1,072.18 19,526.94 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,426.27 19,526.94 ** 29,500.00 Budgeted 9,973.06 Remaining 66 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1336 04/21/2017 MUD P/R 04.21.17 Certification 3,750.00 475.00 4,225.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 475.00 4,225.00 ** 7,800.00 Budgeted 3,575.00 Remaining 54 % Used Account: 135-50020-020-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 18,403.47 1,511.49 19,914.96 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 1,534.35 21,449.31 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,045.84 21,449.31 ** 39,584.00 Budgeted 18,134.69 Remaining 54 % Used Account: 135-50026-020-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 26,874.31 2,355.10 29,229.41 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 2,355.10 31,584.51 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 31,584.51 ** 73,022.00 Budgeted 41,437.49 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 2,068.40 199.69 2,268.09 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 199.63 2,467.72 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 2,467.72 ** 4,592.00 Budgeted 2,124.28 Remaining 54 % Used Account: 135-50028-020-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 448.26 42.19 490.45 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 42.14 532.59 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 532.59 ** 1,031.00 Budgeted 498.41 Remaining 52 % Used Account: 135-50029-020-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 2,222.13 356.76 2,578.89 METLIFE GROUP BENEFITS 3042 AP 1464 04/30/2017 April A/P Café 125 Admin 27.13 2,606.02 BenefitMall AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 383.89 2,606.02 ** 4,485.00 Budgeted 1,878.98 Remaining 58 % Used Account: 135-50030-020-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 11,904.21 955.76 12,859.97 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 962.95 13,822.92 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,918.71 13,822.92 ** 27,886.00 Budgeted 14,063.08 Remaining 50 % Used Account: 135-50035-020-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 2,784.04 223.52 3,007.56 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 225.21 3,232.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 448.73 3,232.77 ** 6,522.00 Budgeted 3,289.23 Remaining 50 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 63.00 ** 1,197.00 Budgeted 1,134.00 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 466 04/01/2017 Insurance/Wrk Comp Exp Apr 5,560.50 926.75 6,487.25 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 6,487.25 ** 11,347.00 Budgeted 4,859.75 Remaining 57 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 325.22 .00 325.22 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 325.22 ** 650.00 Budgeted 324.78 Remaining 50 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 19,449.39 .00 19,449.39 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 19,449.39 ** 20,000.00 Budgeted 550.61 Remaining 97 % Used Account: 135-55080-020-000 Maintenance & Repairs 1339 04/19/2017 April A/P Skid roller 30,373.34 1,060.41 31,433.75 CLS SEWER EQUIPMENT CO., INC 3059 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 3.97 31,437.72 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 30,373.34 73.47 31,511.19 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RDO EQUIPMENT CO 468.37 31,979.56 RDO EQUIPMENT CO PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SPAETH MACHINE SHOP IN 475.00 32,454.56 SPAETH MACHINE SHOP IN PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GIH*GLOBALINDUSTRIALEQ 1,519.50 33,974.06 GIH*GLOBALINDUSTRIALEQ PC 1401 04/28/2017 April A/P concrete work-WWTP 1,500.00 35,474.06 El Cala Construction 3086 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,100.72 35,474.06 ** 79,700.00 Budgeted 44,225.94 Remaining 45 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SALAD BOWL 10 5,395.39 47.76 5,443.15 SALAD BOWL 10 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TRACTOR SUPPLY COMPANY 84.95 5,528.10 TRACTOR SUPPLY COMPANY PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR 202.97 5,731.07 MUSTANG ELITE CAR PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 BLAGG TIRE & SERVICE 1,238.48 6,969.55 BLAGG TIRE & SERVICE PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR WASH 16.99 6,986.54 MUSTANG ELITE CAR WASH PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR 70.99 7,057.53 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,662.14 7,057.53 ** 6,600.00 Budgeted (457.53) Remaining 107 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 23.94 .00 23.94 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 1339 04/19/2017 April A/P Sludge haul off 27,851.38 1,690.00 29,541.38 L.H. CHANEY MATERIALS, INC. 3069 AP 1339 04/19/2017 April A/P Sludge haul off 861.48 30,402.86 L.H. CHANEY MATERIALS, INC. 3069 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,551.48 30,402.86 ** 55,000.00 Budgeted 24,597.14 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-020-000 Lab Analysis 1339 04/19/2017 April A/P Lab supplies 13,613.00 246.00 13,859.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 176.00 14,035.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab suppplies 246.00 14,281.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 176.00 14,457.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 246.00 14,703.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P Lab supplies 176.00 14,879.00 OXIDOR LABORATORIES LLC 3073 AP 1471 04/28/2017 April A/P lab supplies 246.00 15,125.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 176.00 15,301.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P Lab supplies 246.00 15,547.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P Lab supplies 176.00 15,723.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 246.00 15,969.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P labs upplies 176.00 16,145.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 176.00 16,321.00 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,708.00 16,321.00 ** 25,000.00 Budgeted 8,679.00 Remaining 65 % Used Account: 135-60010-020-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 2,433.05 411.68 2,844.73 VERIZON WIRELESS 3080 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 411.68 2,844.73 ** 5,400.00 Budgeted 2,555.27 Remaining 53 % Used Account: 135-60020-020-000 Electricity 1300 04/11/2017 April A/P Electricity 3/8-4/7/17 62,646.29 83.22 62,729.51 HUDSON ENERGY SERVICES, LLC 3026 AP 1300 04/11/2017 April A/P Electricity 3/8-4/7/17 36.12 62,765.63 HUDSON ENERGY SERVICES, LLC 3026 AP 1339 04/19/2017 April A/P Electricity 3/9-4/10 343.30 63,108.93 MP2 ENERGY TEXAS LLC 3071 AP 1339 04/19/2017 April A/P Electricity 3/8-4/7 36.12 63,145.05 HUDSON ENERGY SERVICES, LLC 3067 AP 1339 04/19/2017 April A/P Electricity 3/9-4/10 110.74 63,255.79 HUDSON ENERGY SERVICES, LLC 3067 AP 1339 04/19/2017 April A/P Electricity 3/9-4/13 4,151.75 67,407.54 ENGIE Resources LLC 3063 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24-17 37.32 67,444.86 TRI COUNTY ELECTRIC 3078 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24/17 314.63 67,759.49 TRI COUNTY ELECTRIC 3078 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24/17 27.81 67,787.30 TRI COUNTY ELECTRIC 3078 AP 1398 04/28/2017 April A/P Electricity 3/9-4/10 533.05 68,320.35 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 3/9-4/9 7,825.77 76,146.12 HUDSON ENERGY SERVICES, LLC 3090 AP 1471 04/28/2017 April A/P Electricity 3/24-425 200.50 76,346.62 TRI COUNTY ELECTRIC AP 1471 04/28/2017 April A/P Electricity 3/24-4/25 365.01 76,711.63 TRI COUNTY ELECTRIC AP 1471 04/28/2017 April A/P Electricity 3/24-4/25 27.98 76,739.61 TRI COUNTY ELECTRIC AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (157.05) 76,582.56 AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-020-000 Electricity Totals: 13,936.27 76,582.56 ** 158,627.00 Budgeted 82,044.44 Remaining 48 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 143.85 .00 143.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used Account: 135-60070-020-000 Dues & Memberships 267.00 .00 267.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 267.00 ** 267.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-020-000 Schools & Training 2,307.81 .00 2,307.81 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 2,307.81 ** 4,195.00 Budgeted 1,887.19 Remaining 55 % Used Account: 135-60090-020-000 Safety Program 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TRACTOR SUPPLY COMPANY 257.16 24.99 282.15 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-60090-020-000 Safety Program Totals: 24.99 282.15 ** 550.00 Budgeted 267.85 Remaining 51 % Used Account: 135-60100-020-000 Travel & per diem 1339 04/19/2017 April A/P Tolls 2,130.21 39.61 2,169.82 Texas Tollways/TxTag 3075 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 FORTWORTHCATERING COM 21.61 2,191.43 FORTWORTHCATERING COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RAILHEAD SMOKEHOUSE 23.39 2,214.82 RAILHEAD SMOKEHOUSE PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 FORTWORTHCATERING COM 21.61 2,236.43 FORTWORTHCATERING COM PC 1398 04/28/2017 April A/P tolls to lab 9.07 2,245.50 NTTA 3095 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 115.29 2,245.50 ** 2,400.00 Budgeted 154.50 Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 14,565.97 .00 14,565.97 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 14,565.97 ** 17,150.00 Budgeted 2,584.03 Remaining 85 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 1398 04/28/2017 April A/P April mowing 590.00 1,180.00 1,770.00 WATTS ELLISON LLC 3097 AP 1471 04/28/2017 April A/P march g 590.00 2,360.00 WATTS ELLISON LLC AP 1477 04/30/2017 Recode Mowing (2,360.00) .00 GL _______________ Account: 135-60280-020-000 Property Maintenance Totals: (590.00) .00 ** 6,621.00 Budgeted 6,621.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1477 04/30/2017 Recode Mowing 2,360.00 2,360.00 GL _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 2,360.00 2,360.00 ** 11,600.00 Budgeted 9,240.00 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 1374 04/28/2017 Texpool Transfers 65,722.92 10,953.82 76,676.74 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 76,676.74 ** 120,492.00 Budgeted 43,815.26 Remaining 64 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1374 04/28/2017 Texpool Transfers 324,893.46 54,148.91 379,042.37 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 379,042.37 ** 595,638.00 Budgeted 216,595.63 Remaining 64 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 56,132.70 .00 56,132.70 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 56,132.70 ** 123,492.00 Budgeted 67,359.30 Remaining 45 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1249 04/06/2017 April A/P Fuel 3,445.02 776.87 4,221.89 US Bank Voyager Fleet Systems 3055 AP 1401 04/28/2017 April A/P Gas 852.16 5,074.05 US Bank Voyager Fleet Systems 3096 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,629.03 5,074.05 ** 28,088.00 Budgeted 23,013.95 Remaining 18 % Used Account: 135-65010-020-000 Uniforms 3,753.87 .00 3,753.87 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 3,753.87 ** 4,459.00 Budgeted 705.13 Remaining 84 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 14,942.29 .00 14,942.29 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 14,942.29 ** 21,000.00 Budgeted 6,057.71 Remaining 71 % Used Account: 135-65035-020-000 Small Tools 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 1,100.18 181.94 1,282.12 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GREEN VALLEY COMPRESSO 85.70 1,367.82 GREEN VALLEY COMPRESSO PC _______________ Account: 135-65035-020-000 Small Tools Totals: 267.64 1,367.82 ** 2,000.00 Budgeted 632.18 Remaining 68 % Used Account: 135-65040-020-000 Safety Equipment 252.64 .00 252.64 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 252.64 ** 750.00 Budgeted 497.36 Remaining 34 % Used Account: 135-65045-020-000 Lab Supplies 1339 04/19/2017 April A/P lab supplies 7,789.25 2,019.15 9,808.40 IDEXX DISTRIBUTION, INC 3068 AP 1339 04/19/2017 April A/P Testing supplies 188.49 9,996.89 IDEXX DISTRIBUTION, INC 3068 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 5.56 10,002.45 RANDALLS STORE00017897 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HACH COMPANY 504.32 10,506.77 HACH COMPANY PC 1471 04/28/2017 April A/P gloves 162.00 10,668.77 LOU'S GLOVES INCORPORATED AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,879.52 10,668.77 ** 14,000.00 Budgeted 3,331.23 Remaining 76 % Used Account: 135-69005-020-000 Capital Outlays 196,357.40 .00 196,357.40 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 196,357.40 ** 462,000.00 Budgeted 265,642.60 Remaining 43 % Used Department 20 Totals: ----------------------------------- 1,279,088.96 ** 143,005.34 Monthly Total 2,671,032.00 Budgeted 1,391,943.04 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 466 04/01/2017 Insurance/Wrk Comp Exp Apr 15.66 2.61 18.27 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 18.27 ** 32.00 Budgeted 13.73 Remaining 57 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1249 04/06/2017 April A/P AWBD Conference 1,560.00 355.00 1,915.00 AWBD 3011 AP 1249 04/06/2017 April A/P AWBD Conference 355.00 2,270.00 AWBD 3011 AP 1464 04/30/2017 April A/P AWBD conference 405.00 2,675.00 AWBD AP 1464 04/30/2017 April A/P AWBD cancellation-Wilson 50.00 2,725.00 AWBD AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,165.00 2,725.00 ** 4,000.00 Budgeted 1,275.00 Remaining 68 % Used Account: 135-60100-026-000 Travel & per diem 1,819.37 .00 1,819.37 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,819.37 ** 5,000.00 Budgeted 3,180.63 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 4,562.64 ** 1,167.61 Monthly Total 12,882.00 Budgeted 8,319.36 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 183,998.85 19,529.83 203,528.68 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 19,524.97 223,053.65 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 39,054.80 223,053.65 ** 519,883.00 Budgeted 296,829.35 Remaining 43 % Used Account: 135-50010-030-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 1,778.63 976.92 2,755.55 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 437.68 3,193.23 PR _______________ Account: 135-50010-030-000 Overtime Totals: 1,414.60 3,193.23 ** 2,500.00 Budgeted (693.23) Remaining 128 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,417.00 Budgeted (.50) Remaining 100 % Used Account: 135-50020-030-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 16,804.36 1,896.89 18,701.25 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 1,846.52 20,547.77 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,743.41 20,547.77 ** 47,768.00 Budgeted 27,220.23 Remaining 43 % Used Account: 135-50026-030-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 20,499.26 2,275.98 22,775.24 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 2,275.99 25,051.23 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,551.97 25,051.23 ** 84,289.00 Budgeted 59,237.77 Remaining 30 % Used Account: 135-50027-030-000 Dental Insurance 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 1,752.97 208.44 1,961.41 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 208.37 2,169.78 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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: 416.81 2,169.78 ** 5,981.00 Budgeted 3,811.22 Remaining 36 % Used Account: 135-50028-030-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 375.41 44.45 419.86 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 44.39 464.25 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 88.84 464.25 ** 1,312.00 Budgeted 847.75 Remaining 35 % Used Account: 135-50029-030-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 1,895.37 492.04 2,387.41 METLIFE GROUP BENEFITS 3042 AP 1378 04/25/2017 April A/P Rounding adjustment (.02) 2,387.39 Legal Shield AP 1464 04/30/2017 April A/P Café 125 Admin 33.16 2,420.55 BenefitMall AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 525.18 2,420.55 ** 5,890.00 Budgeted 3,469.45 Remaining 41 % Used Account: 135-50030-030-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 11,083.91 1,222.11 12,306.02 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 1,175.46 13,481.48 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,397.57 13,481.48 ** 32,777.00 Budgeted 19,295.52 Remaining 41 % Used Account: 135-50035-030-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 2,592.18 285.82 2,878.00 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 274.92 3,152.92 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 560.74 3,152.92 ** 8,084.00 Budgeted 4,931.08 Remaining 39 % Used Account: 135-50040-030-000 Unemployment Taxes 1240 04/07/2017 MUD P/R 04.07.17 Unemployment Taxes 288.75 4.08 292.83 PR 1336 04/21/2017 MUD P/R 04.21.17 Unemployment Taxes .90 293.73 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 4.98 293.73 ** 1,368.00 Budgeted 1,074.27 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 466 04/01/2017 Insurance/Wrk Comp Exp Apr 873.18 145.53 1,018.71 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,018.71 ** 1,784.00 Budgeted 765.29 Remaining 57 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 1249 04/06/2017 April A/P Employee drug screen-Schlielig 339.35 63.00 402.35 CARENOW CORPORATE 3014 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 63.00 402.35 ** 500.00 Budgeted 97.65 Remaining 80 % Used Account: 135-50070-030-000 Employee Relations 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 2,571.46 12.00 2,583.46 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 12.00 2,583.46 ** 4,960.00 Budgeted 2,376.54 Remaining 52 % Used Account: 135-55030-030-000 Software & Support 1249 04/06/2017 April A/P Software support 56,763.19 658.00 57,421.19 STW INC 3048 AP 1311 04/13/2017 April A/P Final bill/document software 4,494.94 61,916.13 MCCI 3041 AP 1339 04/19/2017 April A/P Remit machine maintenance cont 425.00 62,341.13 TECHNIQUE DATA SYSTEMS INC 3076 AP 1339 04/19/2017 April A/P Email licenses 168.00 62,509.13 M3 Networks 3070 AP 1339 04/19/2017 April A/P Internet 1,036.77 63,545.90 WHOLESALE CARRIER SERVICES INC 3081 AP 1339 04/19/2017 April A/P Time clock license fee 600.00 64,145.90 Data Management Inc. 3061 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 135.88 64,281.78 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 101.18 64,382.96 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 117.50 64,500.46 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ADOBE *IL CREATIVE CLD 19.99 64,520.45 ADOBE *IL CREATIVE CLD PC 1464 04/30/2017 April A/P SUpport 1,400.00 65,920.45 STW INC AP _______________ Account: 135-55030-030-000 Software & Support Totals: 9,157.26 65,920.45 ** 77,791.00 Budgeted 11,870.55 Remaining 85 % Used Account: 135-55070-030-000 Independent Labor 932.50 .00 932.50 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 932.50 ** 4,000.00 Budgeted 3,067.50 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 275.00 .00 275.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 275.00 ** 2,000.00 Budgeted 1,725.00 Remaining 14 % Used Account: 135-55085-030-000 Generator Maint. and Repair 485.00 .00 485.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 1339 04/19/2017 April A/P Rug service 5,738.97 66.47 5,805.44 G & K SERVICES 3065 AP 1398 04/28/2017 April A/P Rug service 66.47 5,871.91 G & K SERVICES 3089 AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (66.47) 5,805.44 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 66.47 5,805.44 ** 7,000.00 Budgeted 1,194.56 Remaining 83 % Used Account: 135-55120-030-000 Cleaning Services 1398 04/28/2017 April A/P Cleaning services-March 3,142.30 869.06 4,011.36 MEMBER'S BUILDING MAINTENANCE 3094 AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (236.00) 3,775.36 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 3,775.36 ** 8,000.00 Budgeted 4,224.64 Remaining 47 % Used Account: 135-55160-030-000 Professional Outside Services 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 60,000.00 Budgeted 2,668.00 Remaining 96 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 1339 04/19/2017 April A/P March Billing 3,219.04 599.30 3,818.34 DATAPROSE LLC 3062 AP 1464 04/30/2017 April A/P April Billing 594.20 4,412.54 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,193.50 4,412.54 ** 8,200.00 Budgeted 3,787.46 Remaining 54 % Used Account: 135-60005-030-000 Telephone 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RINGCENTRAL, INC 6,889.22 13.95 6,903.17 RINGCENTRAL, INC PC 1398 04/28/2017 April A/P answering service 241.80 7,144.97 KEYSTONE PARK SECRETARIAL 3091 AP 1454 04/28/2017 Recode JE 1449 10.00 7,154.97 GL _______________ Account: 135-60005-030-000 Telephone Totals: 265.75 7,154.97 ** 17,532.00 Budgeted 10,377.03 Remaining 41 % Used Account: 135-60010-030-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 1,464.95 37.99 1,502.94 VERIZON WIRELESS 3080 AP 1336 04/21/2017 MUD P/R 04.21.17 Communications/Mobiles 300.00 1,802.94 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 1,802.94 ** 3,500.00 Budgeted 1,697.06 Remaining 52 % Used Account: 135-60020-030-000 Electricity/Gas 882.09 .00 882.09 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used Account: 135-60025-030-000 Water 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: 734.70 (83.75) 650.95 AR _______________ Account: 135-60025-030-000 Water Totals: (83.75) 650.95 ** 1,500.00 Budgeted 849.05 Remaining 43 % Used Account: 135-60035-030-000 Postage 1249 04/06/2017 April A/P Overnight letter 11,826.69 24.12 11,850.81 FEDERAL EXPRESS CORP 3019 AP 1321 04/17/2017 April A/P Postage for mail outs 1,336.90 13,187.71 U.S. POSTAL SERVICE 3057 AP 1339 04/19/2017 April A/P March Billing 1,790.17 14,977.88 DATAPROSE LLC 3062 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1398 04/28/2017 April A/P Postage machine rental3 11,826.69 93.00 15,070.88 FRANCOTYP-POSTALIA, INC. 3088 AP 1464 04/30/2017 April A/P April Billing 1,765.34 16,836.22 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 5,009.53 16,836.22 ** 28,932.00 Budgeted 12,095.78 Remaining 58 % Used Account: 135-60040-030-000 Service Charges & Fees 1410 04/04/2017 Credit Card Fees/Pace 24,955.46 112.75 25,068.21 GL 1410 04/04/2017 Credit Card Fees/Pace 3,596.20 28,664.41 GL 1249 04/06/2017 April A/P Direct send fees 50.00 28,714.41 Fiserv Solutions, LLC 3020 AP 1241 04/07/2017 Child Support Fee 1.50 28,715.91 GL 1337 04/21/2017 Child Support Fee 1.50 28,717.41 GL 1398 04/28/2017 April A/P Direct send fees 50.00 28,767.41 Fiserv Solutions, LLC 3087 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,811.95 28,767.41 ** 55,560.00 Budgeted 26,792.59 Remaining 52 % Used Account: 135-60050-030-000 Bad Debt Expense 526.88 .00 526.88 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 526.88 ** 3,500.00 Budgeted 2,973.12 Remaining 15 % Used Account: 135-60055-030-000 Insurance 466 04/01/2017 Insurance/Wrk Comp Exp Apr 27,987.36 4,664.56 32,651.92 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 32,651.92 ** 55,692.00 Budgeted 23,040.08 Remaining 59 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 311.88 .00 311.88 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 311.88 ** 1,600.00 Budgeted 1,288.12 Remaining 19 % Used Account: 135-60070-030-000 Dues & Memberships 4,336.25 .00 4,336.25 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,336.25 ** 6,000.00 Budgeted 1,663.75 Remaining 72 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 4,853.34 .00 4,853.34 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,853.34 ** 8,754.00 Budgeted 3,900.66 Remaining 55 % Used Account: 135-60080-030-000 Schools & Training 675.00 .00 675.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 675.00 ** 7,840.00 Budgeted 7,165.00 Remaining 9 % Used Account: 135-60100-030-000 Travel & per diem 1240 04/07/2017 MUD P/R 04.07.17 Travel & per diem 6,692.08 156.54 6,848.62 PR 1336 04/21/2017 MUD P/R 04.21.17 Travel & per diem 43.85 6,892.47 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 200.39 6,892.47 ** 7,500.00 Budgeted 607.53 Remaining 92 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TERIS - PHOENIX, LLC 542.95 542.95 TERIS - PHOENIX, LLC PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60115-030-000 Elections Totals: 542.95 542.95 ** 7,500.00 Budgeted 6,957.05 Remaining 7 % Used Account: 135-60125-030-000 Advertising 1249 04/06/2017 April A/P Employment Ad 950.09 150.00 1,100.09 TX MUNICIPAL LEAGUE 3054 AP _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 1,100.09 ** 7,500.00 Budgeted 6,399.91 Remaining 15 % 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 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 VCN*DENTONRECCTR 76.00 76.00 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 76.00 76.00 ** 17,500.00 Budgeted 17,424.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,040.00 .00 1,040.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 855.00 Budgeted 712.64 Remaining 17 % Used Account: 135-65055-030-000 Hardware 1249 04/06/2017 April A/P Batteries 2,239.88 25.00 2,264.88 M3 Networks 3037 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65055-030-000 Hardware Totals: 25.00 2,264.88 ** 9,444.00 Budgeted 7,179.12 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 1249 04/06/2017 April A/P Office supplies 2,967.65 104.31 3,071.96 OFFICE DEPOT, INC 3043 AP 1339 04/19/2017 April A/P Office supplies 338.13 3,410.09 OFFICE DEPOT, INC 3072 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 OFFICE DEPOT #406 36.94 3,447.03 OFFICE DEPOT #406 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 AMAZON MKTPLACE PMTS 69.73 3,516.76 AMAZON MKTPLACE PMTS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SAMSCLUB.COM 88.89 3,605.65 SAMSCLUB.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 STAPLES DIRECT 13.00 3,618.65 STAPLES DIRECT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SAMSCLUB.COM 15.92 3,634.57 SAMSCLUB.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 AMAZON MKTPLACE PMTS 50.28 3,684.85 AMAZON MKTPLACE PMTS PC 1398 04/28/2017 April A/P Ink cartridge for postage mete 107.95 3,792.80 ASI BUSINESS SOLUTIONS LTD 3082 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 825.15 3,792.80 ** 9,000.00 Budgeted 5,207.20 Remaining 42 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ZAPCO INC 87.31 87.31 ZAPCO INC PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 DESKTOP SUPPLIES.COM 94.70 182.01 DESKTOP SUPPLIES.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SHI GOVERNMENT SOLUTIO 296.77 478.78 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 478.78 478.78 ** 2,000.00 Budgeted 1,521.22 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 1464 04/30/2017 April A/P Supplies-building 1,454.86 139.46 1,594.32 COSTCO WHOLESALE AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 139.46 1,594.32 ** 4,000.00 Budgeted 2,405.68 Remaining 40 % Used Account: 135-65105-030-000 Printing 1339 04/19/2017 April A/P March Billing 123.00 117.50 240.50 DATAPROSE LLC 3062 AP 1464 04/30/2017 April A/P April Billing 247.50 488.00 DATAPROSE LLC AP _______________ Account: 135-65105-030-000 Printing Totals: 365.00 488.00 ** 2,500.00 Budgeted 2,012.00 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 1464 04/30/2017 April A/P Restroom remodel 13,852.95 592.50 14,445.45 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 592.50 14,445.45 ** 265,424.00 Budgeted 250,978.55 Remaining 5 % Used Account: 135-69170-030-000 Copier Lease Installments 1339 04/19/2017 April A/P Copier lease 2,033.51 165.00 2,198.51 EVERBANK COMMERCIAL FINANCE 3064 AP 1398 04/28/2017 April A/P Copies 135.57 2,334.08 KYOCERA DOCUMENT SOLUTIONS 3093 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 300.57 2,334.08 ** 4,600.00 Budgeted 2,265.92 Remaining 51 % Used Department 30 Totals: ----------------------------------- 574,830.93 ** 81,731.55 Monthly Total 1,443,018.00 Budgeted 868,187.07 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2017 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 1311 04/13/2017 April A/P March legal 35,967.01 2,160.00 38,127.01 McLean & Howard, L.L.P. 3039 AP _______________ Account: 135-55045-039-000 Legal Totals: 2,160.00 38,127.01 ** 150,000.00 Budgeted 111,872.99 Remaining 25 % Used Account: 135-55055-039-000 Auditing 18,808.92 .00 18,808.92 _______________ Account: 135-55055-039-000 Auditing Totals: .00 18,808.92 ** 23,860.00 Budgeted 5,051.08 Remaining 79 % Used Account: 135-55060-039-000 Appraisal 6,621.58 .00 6,621.58 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,621.58 ** 11,115.00 Budgeted 4,493.42 Remaining 60 % Used Account: 135-55065-039-000 Tax Admin Fees 2,561.76 .00 2,561.76 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used Department 39 Totals: ----------------------------------- 66,119.27 ** 2,160.00 Monthly Total 188,775.00 Budgeted 122,655.73 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (192,216.26) (243,695.42) Monthly Total .00 Budgeted 192,216.26 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2017 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 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET APRIL 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,901,402 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,901,402 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,205 NET REVENUES / EXPENDITURES (1,489,803) TOTAL FUND BALANCE 2,901,402 TOTAL LIABILITIES AND FUND BALANCE 2,901,402 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 18:31 05/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,778.99- 11,159.09- 11,159.09 Subtotal: 1,778.99- 11,159.09- 11,159.09 Program number: 1,778.99- 11,159.09- 11,159.09 Department number: Revenues 1,778.99- 11,159.09- 11,159.09 Revenues Subtotal ----------- 1,778.99- 11,159.09- 11,159.09 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 18:31 05/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 155,931.19 1,500,961.71 1,500,961.71- Subtotal: 155,931.19 1,500,961.71 1,500,961.71- Program number: 155,931.19 1,500,961.71 1,500,961.71- Department number: Wastewater 155,931.19 1,500,961.71 1,500,961.71- Expenditures Subtotal ----------- 155,931.19 1,500,961.71 1,500,961.71- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 154,152.20 1,489,802.62 1,489,802.62- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (9,380.10) (1,778.99) (11,159.09) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,778.99) (11,159.09) ** .00 Budgeted 11,159.09 Remaining 0 % Used Department Totals: ----------------------------------- (11,159.09) ** (1,778.99) Monthly Total .00 Budgeted 11,159.09 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1311 04/13/2017 April A/P WWTP improvements App 18 1,345,030.52 105,426.99 1,450,457.51 WEBBER-CADAGUA PARTNERS 3056 AP 1339 04/19/2017 April A/P WWTP Improvements 50,504.20 1,500,961.71 CP&Y/WALLACE GROUP, INC. 3060 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 155,931.19 1,500,961.71 ** .00 Budgeted (1,500,961.71) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,500,961.71 ** 155,931.19 Monthly Total .00 Budgeted (1,500,961.71) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,489,802.62 154,152.20 Monthly Total .00 Budgeted (1,489,802.62) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET APRIL 2017 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (733,080) TOTAL FUND BALANCE (691,249) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 18:31 05/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 590.72- 590.72 Subtotal: 590.72- 590.72 Program number: 590.72- 590.72 Department number: Revenues 590.72- 590.72 Revenues Subtotal ----------- 590.72- 590.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 18:31 05/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 733,670.38 733,670.38- Subtotal: 733,670.38 733,670.38- Program number: 733,670.38 733,670.38- Department number: Wastewater 733,670.38 733,670.38- Expenditures Subtotal ----------- 733,670.38 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 733,079.66 733,079.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2017 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 (590.72) .00 (590.72) _______________ Account: 518-49010-000-000 Interest Income Totals: .00 (590.72) ** .00 Budgeted 590.72 Remaining 0 % Used Department Totals: ----------------------------------- (590.72) ** .00 Monthly Total .00 Budgeted 590.72 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 733,670.38 .00 733,670.38 _______________ Account: 518-69005-020-000 Capital Outlays Totals: .00 733,670.38 ** .00 Budgeted (733,670.38) Remaining 0 % Used Department 20 Totals: ----------------------------------- 733,670.38 ** .00 Monthly Total .00 Budgeted (733,670.38) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 733,079.66 .00 Monthly Total .00 Budgeted (733,079.66) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET APRIL 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 543 TOTAL LIABILITIES 543 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES (543) TOTAL FUND BALANCE (543) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 18:31 05/10/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-020-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- Program number: 542.95 542.95- Department number: Wastewater 542.95 542.95- Expenditures Subtotal ----------- 542.95 542.95- Fund number: 519 2016 Rev Bond Const-SWIFT 542.95 542.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60245-020-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-020-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Department 20 Totals: ----------------------------------- 542.95 ** .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 542.95 .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 252,593 ACCOUNTS RECEIVABLE - TOTAL ASSETS 252,593 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 56,831 TOTAL FUND BALANCE 252,593 TOTAL LIABILITIES AND FUND BALANCE 252,593 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 18:31 05/10/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 147.75- 698.61- 232.870 398.61 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 64,920.00- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 56,132.70- 45.455 67,359.30- Subtotal: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Program number: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Department number: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Revenues Subtotal ----------- 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (550.86) (147.75) (698.61) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (147.75) (698.61) ** (300.00) Budgeted 398.61 Remaining 233 % Used Account: 528-49142-000-000 Interfund transfer in-Water .00 .00 _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: .00 .00 ** (64,920.00) Budgeted (64,920.00) Remaining 0 % Used Account: 528-49143-000-000 Interfund transfer in-WW (56,132.70) .00 (56,132.70) _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: .00 (56,132.70) ** (123,492.00) Budgeted (67,359.30) Remaining 45 % Used Department Totals: ----------------------------------- (56,831.31) ** (147.75) Monthly Total (188,712.00) Budgeted (131,880.69) Remaining 30 % Used Fund 528 Totals: ----------------------------------- (56,831.31) (147.75) Monthly Total (188,712.00) Budgeted (131,880.69) Remaining 30 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET APRIL 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 100,670 ACCOUNTS RECEIVABLE - TOTAL ASSETS 100,670 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 100,670 TOTAL FUND BALANCE 100,670 TOTAL LIABILITIES AND FUND BALANCE 100,670 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 18:31 05/10/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 51.36- 142.52- 142.52 529-49142-000-000 Interfund transfer in-Water 14,361.00- 100,527.00- 100,527.00 Subtotal: 14,412.36- 100,669.52- 100,669.52 Program number: 14,412.36- 100,669.52- 100,669.52 Department number: 14,412.36- 100,669.52- 100,669.52 Revenues Subtotal ----------- 14,412.36- 100,669.52- 100,669.52 Fund number: 529 2016 Rev Bond Reserve-SWIFT 14,412.36- 100,669.52- 100,669.52 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (91.16) (51.36) (142.52) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (51.36) (142.52) ** .00 Budgeted 142.52 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 1374 04/28/2017 Texpool Transfers (86,166.00) (14,361.00) (100,527.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (14,361.00) (100,527.00) ** .00 Budgeted 100,527.00 Remaining 0 % Used Department Totals: ----------------------------------- (100,669.52) ** (14,412.36) Monthly Total .00 Budgeted 100,669.52 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (100,669.52) (14,412.36) Monthly Total .00 Budgeted 100,669.52 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2017 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 612,934 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 20,963 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 638,743 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,963 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 20,963 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 591,749 TOTAL FUND BALANCE 617,780 TOTAL LIABILITIES AND FUND BALANCE 638,743 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 18:31 05/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 4,327.56- 663,062.52- 98.474 10,273.48- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 3.80- 1,246.65- 35.608 2,254.35- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 276.66- 1,277.23- 63.862 722.77- Subtotal: 678,837.00- 678,837.00- 4,608.02- 665,586.40- 98.048 13,250.60- 533-49010-000-000 Interest Income 140.00- 140.00- 352.57- 1,227.18- 876.557 1,087.18 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.82- 76,676.74- 63.636 43,815.26- Subtotal: 337,386.00- 337,386.00- 11,306.39- 77,903.92- 23.090 259,482.08- Program number: 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- Department number: Revenues 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 18:31 05/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2017 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 300,583.00 300,583.00 150,491.25 50.066 150,091.75 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Program number: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Department number: Administration 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 15,914.41- 591,749.07- ############### 588,659.07 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 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 1417 04/03/2017 Property Taxes (658,734.96) (75.19) (658,810.15) GL 1418 04/04/2017 Property Taxes (578.10) (659,388.25) GL 1419 04/05/2017 Property Taxes (27.50) (659,415.75) GL 1420 04/06/2017 Property Taxes (45.42) (659,461.17) GL 1422 04/07/2017 Property Taxes (680.89) (660,142.06) GL 1423 04/10/2017 Property Taxes 680.89 (659,461.17) GL 1424 04/11/2017 Property Taxes (1,393.44) (660,854.61) GL 1425 04/13/2017 Property Taxes (203.43) (661,058.04) GL 1427 04/18/2017 Property Taxes (92.83) (661,150.87) GL 1428 04/20/2017 Property Taxes (331.37) (661,482.24) GL 1429 04/21/2017 Property Taxes (582.97) (662,065.21) GL 1430 04/25/2017 Property Taxes (3.23) (662,068.44) GL 1431 04/26/2017 Property Taxes (851.24) (662,919.68) GL 1432 04/28/2017 Property Taxes (142.84) (663,062.52) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (4,327.56) (663,062.52) ** (673,336.00) Budgeted (10,273.48) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1418 04/04/2017 Property Taxes (1,242.85) (.18) (1,243.03) GL 1424 04/11/2017 Property Taxes (3.62) (1,246.65) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.80) (1,246.65) ** (3,501.00) Budgeted (2,254.35) Remaining 36 % Used Account: 533-40015-000-000 Property Taxes/P & I 1417 04/03/2017 Property Taxes (1,000.57) (4.36) (1,004.93) GL 1418 04/04/2017 Property Taxes (8.52) (1,013.45) GL 1420 04/06/2017 Property Taxes (3.18) (1,016.63) GL 1424 04/11/2017 Property Taxes (105.68) (1,122.31) GL 1425 04/13/2017 Property Taxes (22.37) (1,144.68) GL 1426 04/17/2017 Property Taxes 9.23 (1,135.45) GL 1428 04/20/2017 Property Taxes (36.45) (1,171.90) GL 1429 04/21/2017 Property Taxes (50.39) (1,222.29) GL 1430 04/25/2017 Property Taxes (.33) (1,222.62) GL 1431 04/26/2017 Property Taxes (38.94) (1,261.56) GL 1432 04/28/2017 Property Taxes (15.67) (1,277.23) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (276.66) (1,277.23) ** (2,000.00) Budgeted (722.77) Remaining 64 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (874.61) (352.57) (1,227.18) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (352.57) (1,227.18) ** (140.00) Budgeted 1,087.18 Remaining 877 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (216,754.00) Budgeted (216,754.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1374 04/28/2017 Texpool Transfers (65,722.92) (10,953.82) (76,676.74) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (76,676.74) ** (120,492.00) Budgeted (43,815.26) Remaining 64 % Used Department Totals: ----------------------------------- (743,490.32) ** (15,914.41) Monthly Total (1,016,223.00) Budgeted (272,732.68) Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2017 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 150,491.25 .00 150,491.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 150,491.25 ** 300,583.00 Budgeted 150,091.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 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 151,741.25 ** .00 Monthly Total 1,013,133.00 Budgeted 861,391.75 Remaining 15 % Used Fund 533 Totals: ----------------------------------- (591,749.07) (15,914.41) Monthly Total (3,090.00) Budgeted 588,659.07 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 279,065 ACCOUNTS RECEIVABLE - TOTAL ASSETS 279,065 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 263,968 TOTAL FUND BALANCE 279,065 TOTAL LIABILITIES AND FUND BALANCE 279,065 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 18:31 05/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 134.85- 444.20- 222.100 244.20 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 54,148.91- 379,042.37- 63.636 216,595.63- Subtotal: 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Program number: 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Department number: Revenues 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 18:31 05/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 115,518.75 29.800 272,130.25 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Program number: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Department number: Administration 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Expenditures Subtotal ----------- 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 54,283.76- 263,967.82- ############### 263,767.82 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (309.35) (134.85) (444.20) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (134.85) (444.20) ** (200.00) Budgeted 244.20 Remaining 222 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1374 04/28/2017 Texpool Transfers (324,893.46) (54,148.91) (379,042.37) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (379,042.37) ** (595,638.00) Budgeted (216,595.63) Remaining 64 % Used Department Totals: ----------------------------------- (379,486.57) ** (54,283.76) Monthly Total (892,849.00) Budgeted (513,362.43) Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2017 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 115,518.75 .00 115,518.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 115,518.75 ** 387,649.00 Budgeted 272,130.25 Remaining 30 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 115,518.75 ** .00 Monthly Total 892,649.00 Budgeted 777,130.25 Remaining 13 % Used Fund 534 Totals: ----------------------------------- (263,967.82) (54,283.76) Monthly Total (200.00) Budgeted 263,767.82 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 153,459 ACCOUNTS RECEIVABLE - TOTAL ASSETS 153,459 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 153,459 TOTAL FUND BALANCE 153,459 TOTAL LIABILITIES AND FUND BALANCE 153,459 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 25 18:31 05/10/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 78.32- 208.64- 208.64 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 153,250.13- 153,250.13 Subtotal: 21,971.20- 153,458.77- 153,458.77 Program number: 21,971.20- 153,458.77- 153,458.77 Department number: Revenues 21,971.20- 153,458.77- 153,458.77 Revenues Subtotal ----------- 21,971.20- 153,458.77- 153,458.77 Fund number: 535 2016 Rev Bond I&S-SWIFT 21,971.20- 153,458.77- 153,458.77 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (130.32) (78.32) (208.64) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (78.32) (208.64) ** .00 Budgeted 208.64 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1374 04/28/2017 Texpool Transfers (131,357.25) (21,892.88) (153,250.13) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (153,250.13) ** .00 Budgeted 153,250.13 Remaining 0 % Used Department Totals: ----------------------------------- (153,458.77) ** (21,971.20) Monthly Total .00 Budgeted 153,458.77 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (153,458.77) (21,971.20) Monthly Total .00 Budgeted 153,458.77 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 249,213.45 **** (153,027.10) Monthly Total (192,002.00) Budgeted (441,215.45) Remaining ########## ******* End of Report *********