Loading...
HomeMy WebLinkAbout2017-09 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 525,752 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 15,752 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 541,504 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,752 ACCOUNTS AND OTHER PAYABLES 3,500 TOTAL LIABILITIES 19,252 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 1,144 TOTAL FUND BALANCE 522,252 TOTAL LIABILITIES AND FUND BALANCE 541,504 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 11:05 10/09/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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- 1,738.25- 1,036,680.46- 100.084 870.46 122-40011-000-000 Property Taxes/Fire-Delinquent 308.30- 3,195.62- 3,195.62 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 310.59- 4,184.44- 92.988 315.56- Subtotal: 1,040,310.00- 1,040,310.00- 2,357.14- 1,044,172.54- 100.371 3,862.54 122-49036-000-000 GASB Reserves 23,163.91- 23,163.91 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 23,312.91- 23,312.91 Program number: 1,040,310.00- 1,040,310.00- 2,357.14- 1,067,485.45- 102.612 27,175.45 Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 2,357.14- 1,067,485.45- 102.612 27,175.45 Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 2,357.14- 1,067,485.45- 102.612 27,175.45 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 11:05 10/09/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55045-045-000 Legal 273.00 273.00 273.00- 122-55080-045-000 Maintenance & Repairs 3,500.00 26,663.91 26,663.91- Subtotal: 3,773.00 26,936.91 26,936.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 100.000 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.01 16,513.00 100.000 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 581,633.00 99.999 5.00 Subtotal: 814,905.00 814,905.00 50,350.01 814,900.00 99.999 5.00 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 15,936.00 94.654 900.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 224,504.60 99.601 900.40 Program number: 1,040,310.00 1,040,310.00 54,123.01 1,066,341.51 102.502 26,031.51- Department number: Fire 1,040,310.00 1,040,310.00 54,123.01 1,066,341.51 102.502 26,031.51- Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 54,123.01 1,066,341.51 102.502 26,031.51- Fund number: 122 Trophy Club MUD Fire Dept. 51,765.87 1,143.94- 1,143.94 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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 2447 09/01/2017 Property Taxes (1,034,942.21) (532.41) (1,035,474.62) GL 2448 09/05/2017 Property Taxes (197.60) (1,035,672.22) GL 2449 09/06/2017 Property Taxes (381.91) (1,036,054.13) GL 2450 09/07/2017 Property Taxes (97.48) (1,036,151.61) GL 2451 09/13/2017 Property Taxes (3.97) (1,036,155.58) GL 2452 09/14/2017 Property Taxes (114.95) (1,036,270.53) GL 2453 09/18/2017 Property Taxes (15.87) (1,036,286.40) GL 2454 09/19/2017 Property Taxes (47.90) (1,036,334.30) GL 2455 09/22/2017 Property Taxes (75.62) (1,036,409.92) GL 2455 09/22/2017 Property Taxes (40.29) (1,036,450.21) GL 2456 09/27/2017 Property Taxes (227.06) (1,036,677.27) GL 2457 09/29/2017 Property Taxes (3.19) (1,036,680.46) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,738.25) (1,036,680.46) ** (1,035,810.00) Budgeted 870.46 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2447 09/01/2017 Property Taxes (2,887.32) (6.53) (2,893.85) GL 2450 09/07/2017 Property Taxes (1.37) (2,895.22) GL 2451 09/13/2017 Property Taxes (19.71) (2,914.93) GL 2452 09/14/2017 Property Taxes (70.23) (2,985.16) GL 2455 09/22/2017 Property Taxes (.34) (2,985.50) GL 2456 09/27/2017 Property Taxes (210.12) (3,195.62) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (308.30) (3,195.62) ** .00 Budgeted 3,195.62 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2447 09/01/2017 Property Taxes (3,873.85) (103.78) (3,977.63) GL 2448 09/05/2017 Property Taxes (38.57) (4,016.20) GL 2449 09/06/2017 Property Taxes (72.55) (4,088.75) GL 2450 09/07/2017 Property Taxes (12.92) (4,101.67) GL 2452 09/14/2017 Property Taxes (22.98) (4,124.65) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2453 09/18/2017 Property Taxes (3,873.85) (3.17) (4,127.82) GL 2454 09/19/2017 Property Taxes (3.84) (4,131.66) GL 2455 09/22/2017 Property Taxes (6.15) (4,137.81) GL 2456 09/27/2017 Property Taxes (45.41) (4,183.22) GL 2457 09/29/2017 Property Taxes (1.22) (4,184.44) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (310.59) (4,184.44) ** (4,500.00) Budgeted (315.56) Remaining 93 % Used Account: 122-49036-000-000 GASB Reserves (23,163.91) .00 (23,163.91) _______________ Account: 122-49036-000-000 GASB Reserves Totals: .00 (23,163.91) ** .00 Budgeted 23,163.91 Remaining 0 % 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,067,485.45) ** (2,357.14) Monthly Total (1,040,310.00) Budgeted 27,175.45 Remaining 103 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-55045-045-000 Legal 2368 09/21/2017 September A/P Reimb for Julie Fort SOG Invoi 273.00 273.00 THE LISTON LAW FIRM, P.C. 3519 AP _______________ Account: 122-55045-045-000 Legal Totals: 273.00 273.00 ** .00 Budgeted (273.00) Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 2444 09/30/2017 September A/P Repair AC Vents at Fire Statio 23,163.91 3,500.00 26,663.91 ACE Heating & Air Conditioning AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 3,500.00 26,663.91 ** .00 Budgeted (26,663.91) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 216,754.00 .00 216,754.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 216,754.00 ** 216,754.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 471 09/01/2017 Insurance/Wrk Comp Exp Sep 15,136.99 1,376.08 16,513.07 GL 2467 09/30/2017 Clear PPD Ins/TML @ 9/30/17 (.07) 16,513.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.01 16,513.00 ** 16,513.00 Budgeted .00 Remaining 100 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 2335 09/15/2017 September A/P Fire Admin Services/September 532,659.00 48,974.00 581,633.00 TOWN OF TROPHY CLUB 3520 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 581,633.00 ** 581,638.00 Budgeted 5.00 Remaining 100 % Used Account: 122-69005-045-000 Capital Outlays 15,936.00 .00 15,936.00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 15,936.00 ** 16,836.00 Budgeted 900.00 Remaining 95 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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: ----------------------------------- 1,066,341.51 ** 54,123.01 Monthly Total 1,040,310.00 Budgeted (26,031.51) Remaining 103 % Used Fund 122 Totals: ----------------------------------- (1,143.94) 51,765.87 Monthly Total .00 Budgeted 1,143.94 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 804,685 - 804,685 CASH IN BANK-SAVINGS-CASH RESERVE 581,054 - 581,054 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,927 - 713,927 INVESTMENTS-TEXPOOL 1,650,864 410,006 2,060,870 PREPAID EXPENSES 8,486 - 8,486 ADVALOREM PROPERTY TAXES RECEIVABLE 1,662 - 1,662 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,327,856 - 1,327,856 TOTAL ASSETS 5,124,449 410,006 5,534,455 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,662 - 1,662 ACCOUNTS AND OTHER PAYABLES 694,572 - 694,572 CUSTOMER DEPOSITS 314,025 - 314,025 - TOTAL LIABILITIES 1,010,259 - 1,010,259 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 425,920 425,920 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 147,201 147,201 UNASSIGNED FUND BALANCE 1,959,992 - 1,959,992 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 1,724,792 - 1,724,792 - TOTAL FUND BALANCE 4,114,190 410,006 4,524,195 TOTAL LIABILITIES AND FUND BALANCE 5,124,449 410,006 5,534,455 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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- 102.26- 61,007.86- 100.051 30.86 135-40002-000-000 Property Taxes/Delinquent 20.98- 290.27- 290.27 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 90.23- 350.31- 53.894 299.69- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 213.47- 61,648.44- 29.368 148,269.56- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 635,019.98- 5,736,028.46- 89.114 700,705.54- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 235,977.07- 2,555,712.01- 97.193 73,811.99- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 14,341.99- 121,527.75- 101.902 2,267.75 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 675.00- 14,100.00- 123.684 2,700.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 50.00- 2,400.00- 120.000 400.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 150.00- 4,800.00- 87.273 700.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 15,168.80- 87,158.65- 142.444 25,970.65 Subtotal: 9,265,606.00- 9,265,606.00- 901,382.84- 8,521,726.87- 91.972 743,879.13- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 2,845.60- 18,939.60- 236.715 10,938.60 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 10,926.36- 100.003 .36 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.37- 7,000.00- 100.000 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 343.00- 20,864.02- 96.552 744.98- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 113.81- 12,451.31- 62.257 7,548.69- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 32.00- 160.000 12.00 135-49903-000-000 Recovery of Prior Year Expense 81,791.15- 81,791.15- 81,791.15 Subtotal: 69,556.00- 69,556.00- 86,587.46- 152,004.44- 218.535 82,448.44 Program number: 9,545,080.00- 9,545,080.00- 988,183.77- 8,735,379.75- 91.517 809,700.25- Department number: Revenues 9,545,080.00- 9,545,080.00- 988,183.77- 8,735,379.75- 91.517 809,700.25- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 988,183.77- 8,735,379.75- 91.517 809,700.25- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 236,143.00 19,548.80 217,345.31 92.040 18,797.69 135-50010-010-000 Overtime 19,500.00 19,500.00 1,320.93 12,562.62 64.424 6,937.38 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 3,000.00 200.00 2,600.00 86.667 400.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,948.95 21,488.80 79.146 5,662.20 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,834.65 30,037.68 53.721 25,876.32 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 280.99 2,942.22 70.743 1,216.78 135-50028-010-000 Vision Insurance 910.00 910.00 58.27 578.21 63.540 331.79 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 248.41 2,576.20 91.909 226.80 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,293.07 14,334.88 75.363 4,686.12 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 302.40 3,352.53 75.372 1,095.47 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 4.27 50.77 4.948 975.23 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.34 11,864.10 90.208 1,287.90 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 346.90 26.685 953.10 135-50070-010-000 Employee Relations 300.00 300.00 187.09 62.363 112.91 Subtotal: 428,897.00 392,097.00 29,115.08 323,537.31 82.515 68,559.69 135-55005-010-000 Engineering 5,000.00 30,000.00 28,762.16 95.874 1,237.84 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 12,874.59 87,808.40 68.333 40,691.60 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 2,459.00 81.967 541.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 2,102.75 26.284 5,897.25 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 3,748.26 68.150 1,751.74 Subtotal: 125,000.00 178,500.00 12,874.59 124,880.57 69.961 53,619.43 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 599.69 4,123.49 76.361 1,276.51 135-60020-010-000 Electricity 172,737.00 172,737.00 17,944.54 156,752.22 90.746 15,984.78 135-60066-010-000 Publications/Books/Subscripts 750.00 750.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 111.00 936.00 22.170 3,286.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 24,978.35 49.781 25,197.65 135-60150-010-000 Wholesale Water 2,998,802.00 2,498,802.00 222,900.19 1,959,436.98 78.415 539,365.02 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 102.70 51.350 97.30 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 108.00 774.60 15.492 4,225.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 8,250.00 55.932 6,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 240,822.00 240,821.65 100.000 .35 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 48,047.00 4,083.00 48,047.45 100.001 .45- 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 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,247,306.00 247,246.42 2,445,114.90 75.297 802,191.10 135-65005-010-000 Fuel & Lube 33,011.00 9,828.00 1,039.81 8,733.33 88.862 1,094.67 135-65010-010-000 Uniforms 4,608.00 4,608.00 139.93 3,063.79 66.488 1,544.21 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,383.79 24,216.86 121.084 4,216.86- 135-65035-010-000 Small Tools 1,200.00 1,200.00 867.64 72.303 332.36 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 506.50 50.650 493.50 135-65050-010-000 Meter Expense 115,000.00 31,500.00 23,999.88 76.190 7,500.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 71,160.00 87.313 10,340.00 Subtotal: 256,319.00 149,636.00 2,563.53 132,548.00 88.580 17,088.00 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 6,349.85 349,437.67 50.612 340,984.33 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 6,349.85 551,395.42 61.789 340,984.58 Program number: 5,326,780.00 4,859,919.00 298,149.47 3,577,476.20 73.612 1,282,442.80 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/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 600.00 2,103.10 42.062 2,896.90 Subtotal: 5,000.00 5,000.00 600.00 2,103.10 42.062 2,896.90 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 600.00 2,103.10 21.031 7,896.90 Department number: Water 5,336,780.00 4,869,919.00 298,749.47 3,579,579.30 73.504 1,290,339.70 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 371,102.00 30,446.74 372,898.41 100.484 1,796.41- 135-50010-020-000 Overtime 29,500.00 29,500.00 2,636.96 31,195.59 105.748 1,695.59- 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 700.00 8,275.00 106.090 475.00- 135-50020-020-000 Retirement 39,584.00 39,584.00 3,125.00 38,207.53 96.523 1,376.47 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 55,135.51 75.505 17,886.49 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 4,464.32 97.220 127.68 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 954.24 92.555 76.76 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 393.14 4,552.36 101.502 67.36- 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,961.37 24,407.53 87.526 3,478.47 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 458.70 5,708.20 87.522 813.80 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.71 14,902.96 131.338 3,555.96- 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 80.00 26.667 220.00 135-50070-020-000 Employee Relations 650.00 650.00 461.00 70.923 189.00 Subtotal: 605,653.00 585,653.00 45,842.47 567,940.65 96.976 17,712.35 135-55005-020-000 Engineering 70,000.00 1,000.00 852.48 85.248 147.52 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 99,700.00 57.94 97,047.39 97.339 2,652.61 135-55085-020-000 Generator Maint. and Repair 20,000.00 7,000.00 6,076.00 86.800 924.00 135-55090-020-000 Vehicle Maintenance 4,000.00 9,600.00 1,265.61 9,048.02 94.250 551.98 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 1,690.00 51,634.68 93.881 3,365.32 135-55135-020-000 Lab Analysis 25,000.00 31,000.00 1,223.00 31,488.06 101.574 488.06- Subtotal: 277,600.00 223,800.00 4,236.55 215,619.96 96.345 8,180.04 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 368.57 5,078.11 94.039 321.89 135-60020-020-000 Electricity 158,627.00 158,627.00 14,872.62 144,921.83 91.360 13,705.17 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 6.00 149.85 37.463 250.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 601.00 2,958.81 70.532 1,236.19 135-60090-020-000 Safety Program 550.00 550.00 291.12 52.931 258.88 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 113.77 2,599.95 108.331 199.95- 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.00 4,086.37 100.009 .37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 18,348.00 18,348.38 100.002 .38- 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 113.27 25.171 336.73 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 6,621.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 6,490.00 55.948 5,110.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 120,492.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 595,638.00 100.000 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 180,417.00 10,278.00 180,417.25 100.000 .25- 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,318,491.00 27,419.96 1,081,851.94 82.052 236,639.06 135-65005-020-000 Fuel & Lube 28,088.00 11,088.00 907.98 8,722.22 78.664 2,365.78 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 28,200.00 23,247.95 82.440 4,952.05 135-65035-020-000 Small Tools 2,000.00 2,000.00 509.00 2,191.36 109.568 191.36- 135-65040-020-000 Safety Equipment 750.00 750.00 517.03 68.937 232.97 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 162.00 13,257.59 94.697 742.41 Subtotal: 74,297.00 60,497.00 1,578.98 51,690.02 85.442 8,806.98 135-69005-020-000 Capital Outlays 485,000.00 222,000.00 19,600.00 220,503.11 99.326 1,496.89 Subtotal: 485,000.00 222,000.00 19,600.00 220,503.11 99.326 1,496.89 Program number: 2,698,015.00 2,410,441.00 98,677.96 2,137,605.68 88.681 272,835.32 Department number: Wastewater 2,698,015.00 2,410,441.00 98,677.96 2,137,605.68 88.681 272,835.32 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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.57 30.28 94.625 1.72 Subtotal: 32.00 32.00 2.57 30.28 94.625 1.72 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 145.45 12.121 1,054.55 135-60080-026-000 Schools & Training 4,000.00 4,000.00 3,557.35 88.934 442.65 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 242.91 2,689.86 53.797 2,310.14 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 75.35 75.35 3.768 1,924.65 Subtotal: 12,850.00 12,850.00 318.26 6,468.01 50.335 6,381.99 Program number: 12,882.00 12,882.00 320.83 6,498.29 50.445 6,383.71 Department number: Board of Directors 12,882.00 12,882.00 320.83 6,498.29 50.445 6,383.71 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 424,883.00 26,737.71 408,062.09 96.041 16,820.91 135-50010-030-000 Overtime 1,000.00 2,500.00 64.08 3,474.20 138.968 974.20- 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 2,479.15 37,687.05 78.896 10,080.95 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 2,877.17 44,204.05 52.443 40,084.95 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 273.84 3,937.51 65.834 2,043.49 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 57.72 842.24 64.195 469.76 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 278.48 4,426.21 75.148 1,463.79 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 1,574.42 24,485.68 74.704 8,291.32 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 368.20 5,726.47 70.837 2,357.53 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 .01- 293.72 21.471 1,074.28 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 1,796.36 100.693 12.36- 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 93.95 700.75 140.150 200.75- 135-50070-030-000 Employee Relations 4,960.00 4,960.00 51.99 2,692.33 54.281 2,267.67 Subtotal: 719,486.00 625,513.00 35,002.23 541,746.16 86.608 83,766.84 135-55030-030-000 Software & Support 67,791.00 87,791.00 2,155.77 89,361.26 101.789 1,570.26- 135-55070-030-000 Independent Labor 12,000.00 34,000.00 22,985.27 40,440.69 118.943 6,440.69- 135-55080-030-000 Maintenance & Repairs 7,000.00 2,000.00 826.00 41.300 1,174.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 6,836.22 97.660 163.78 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 6,704.66 83.808 1,295.34 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 1,675.00 63,092.64 99.633 232.36 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 6,877.89 83.877 1,322.11 Subtotal: 185,945.00 220,516.00 27,515.57 214,624.36 97.328 5,891.64 135-60005-030-000 Telephone 17,532.00 17,532.00 1,265.08 14,081.04 80.316 3,450.96 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 629.00 3,633.90 103.826 133.90- 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 8,022.75 63.516 4,608.25 135-60025-030-000 Water 1,500.00 1,500.00 61.19 1,040.70 69.380 459.30 135-60035-030-000 Postage 28,932.00 28,932.00 51.90 25,725.93 88.919 3,206.07 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,116.57 52,707.42 94.866 2,852.58 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 1,147.52 1,674.40 47.840 1,825.60 135-60055-030-000 Insurance 55,692.00 55,692.00 4,664.50 59,614.46 107.043 3,922.46- 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 769.51 48.094 830.49 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,851.25 80.854 1,148.75 135-60075-030-000 Meetings 400.00 400.00 121.69 30.423 278.31 135-60079-030-000 Public Education 8,754.00 8,754.00 4,972.32 56.801 3,781.68 135-60080-030-000 Schools & Training 7,840.00 7,840.00 2,255.00 28.763 5,585.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 7,111.81 94.824 388.19 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 9.43- 2,960.90 39.479 4,539.10 135-60125-030-000 Advertising 7,500.00 7,500.00 625.00 2,323.09 30.975 5,176.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 72.95 233.91 1.337 17,266.09 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,055.94 42.238 1,444.06 Subtotal: 246,041.00 247,491.00 13,624.28 193,156.02 78.046 54,334.98 135-65010-030-000 Uniforms 1,855.00 855.00 332.16 474.52 55.499 380.48 135-65055-030-000 Hardware 9,444.00 3,444.00 1,235.94 3,536.14 102.675 92.14- 135-65085-030-000 Office Supplies 9,000.00 9,000.00 228.70 5,353.49 59.483 3,646.51 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 754.36 37.718 1,245.64 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 300.64 3,984.65 99.616 15.35 135-65105-030-000 Printing 4,800.00 2,500.00 38.97 2,592.85 103.714 92.85- Subtotal: 32,099.00 21,799.00 2,136.41 16,696.01 76.591 5,102.99 135-69005-030-000 Capital Outlays 107,001.00 185,424.00 7,841.00 127,597.15 68.814 57,826.85 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 399.58 3,764.43 81.835 835.57 Subtotal: 111,601.00 190,024.00 8,240.58 131,361.58 69.129 58,662.42 Program number: 1,295,172.00 1,305,343.00 86,519.07 1,097,584.13 84.084 207,758.87 Department number: Administration 1,295,172.00 1,305,343.00 86,519.07 1,097,584.13 84.084 207,758.87 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 11:05 10/09/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 225,000.00 5,910.00 157,236.30 69.883 67,763.70 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 2,045.87 10,713.32 96.386 401.68 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 263,775.00 7,955.87 189,320.30 71.773 74,454.70 Program number: 188,775.00 263,775.00 7,955.87 189,320.30 71.773 74,454.70 Department number: Non Departmental 188,775.00 263,775.00 7,955.87 189,320.30 71.773 74,454.70 Expenditures Subtotal ----------- 9,531,624.00 8,862,360.00 492,223.20 7,010,587.70 79.105 1,851,772.30 Fund number: 135 MUD 1 General Fund 13,456.00- 682,720.00- 495,960.57- 1,724,792.05- 252.635 1,042,072.05 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 11:05 10/09/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/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 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 11:05 10/09/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 23,163.91 23,163.91- Subtotal: 23,163.91 23,163.91- Program number: 23,163.91 23,163.91- Department number: Fire Department 23,163.91 23,163.91- Expenditures Subtotal ----------- 23,163.91 23,163.91- Fund number: 137 MUD 1 Consolidated GASB 133,256.09- 133,256.09 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 2447 09/01/2017 Property Taxes (60,905.60) (31.32) (60,936.92) GL 2448 09/05/2017 Property Taxes (11.63) (60,948.55) GL 2449 09/06/2017 Property Taxes (22.47) (60,971.02) GL 2450 09/07/2017 Property Taxes (5.73) (60,976.75) GL 2451 09/13/2017 Property Taxes (.23) (60,976.98) GL 2452 09/14/2017 Property Taxes (6.76) (60,983.74) GL 2453 09/18/2017 Property Taxes (.93) (60,984.67) GL 2454 09/19/2017 Property Taxes (2.82) (60,987.49) GL 2455 09/22/2017 Property Taxes (4.45) (60,991.94) GL 2455 09/22/2017 Property Taxes (2.37) (60,994.31) GL 2456 09/27/2017 Property Taxes (13.36) (61,007.67) GL 2457 09/29/2017 Property Taxes (.19) (61,007.86) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (102.26) (61,007.86) ** (60,977.00) Budgeted 30.86 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2447 09/01/2017 Property Taxes (269.29) (1.26) (270.55) GL 2450 09/07/2017 Property Taxes (.09) (270.64) GL 2451 09/13/2017 Property Taxes (1.29) (271.93) GL 2452 09/14/2017 Property Taxes (4.59) (276.52) GL 2455 09/22/2017 Property Taxes (.02) (276.54) GL 2456 09/27/2017 Property Taxes (13.73) (290.27) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (20.98) (290.27) ** .00 Budgeted 290.27 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2447 09/01/2017 Property Taxes (260.08) (6.45) (266.53) GL 2448 09/05/2017 Property Taxes (2.26) (268.79) GL 2449 09/06/2017 Property Taxes (4.27) (273.06) GL 2450 09/07/2017 Property Taxes (.76) (273.82) GL 2452 09/14/2017 Property Taxes (1.35) (275.17) GL 2453 09/18/2017 Property Taxes (.19) (275.36) GL 2454 09/19/2017 Property Taxes (.22) (275.58) GL 2455 09/22/2017 Property Taxes (.36) (275.94) GL 2456 09/27/2017 Property Taxes (74.30) (350.24) GL 2457 09/29/2017 Property Taxes (.07) (350.31) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (90.23) (350.31) ** (650.00) Budgeted (299.69) Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 2435 09/20/2017 UB Water adjustment-Seay UB20170920-20170920 User: (5,101,008.48) 313.48 (5,100,695.00) UB 2441 09/29/2017 Water adj-2897 Redfern-Carlson UB20170929-20170929 User: 169.26 (5,100,525.74) UB 2419 09/30/2017 Billing-September 2017 UB20170930-20170930 User: (635,502.72) (5,736,028.46) UB _______________ Account: 135-47000-000-000 Water Totals: (635,019.98) (5,736,028.46) ** (6,436,734.00) Budgeted (700,705.54) Remaining 89 % Used Account: 135-47005-000-000 Sewer 2419 09/30/2017 Billing-September 2017 UB20170930-20170930 User: (2,319,734.94) (235,977.07) (2,555,712.01) UB _______________ Account: 135-47005-000-000 Sewer Totals: (235,977.07) (2,555,712.01) ** (2,629,524.00) Budgeted (73,811.99) Remaining 97 % Used Account: 135-47025-000-000 Penalties 2423 09/01/2017 Peanlty removal UB20170901-20170901 User: (107,185.76) 79.56 (107,106.20) UB 2425 09/11/2017 Penalty removals UB20170911-20170911 User: 123.77 (106,982.43) UB 2371 09/21/2017 Penalties 9/21/17 UB20170921-20170921 User: (17,315.80) (124,298.23) UB 2439 09/27/2017 Penalty removals UB20170927-20170927 User: 2,076.92 (122,221.31) UB 2440 09/28/2017 Penalty removals UB20170928-20170928 User: 610.08 (121,611.23) UB 2441 09/29/2017 Water adj-2897 Redfern-Carlson UB20170929-20170929 User: 83.48 (121,527.75) UB _______________ Account: 135-47025-000-000 Penalties Totals: (14,341.99) (121,527.75) ** (119,260.00) Budgeted 2,267.75 Remaining 102 % Used Account: 135-47030-000-000 Service Charges 2319 09/12/2017 Cut off list UB20170912-20170912 User: (13,425.00) (550.00) (13,975.00) UB 2426 09/13/2017 NSF Service fee UB20170913-20170913 User: (25.00) (14,000.00) UB 2428 09/14/2017 NSF Checks-Johnons & Blake UB20170914-20170914 User: (50.00) (14,050.00) UB 2434 09/20/2017 UB NSF checks UB20170920-20170920 User: (25.00) (14,075.00) UB 2437 09/21/2017 NSF Check fee UB20170921-20170921 User: (25.00) (14,100.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (675.00) (14,100.00) ** (11,400.00) Budgeted 2,700.00 Remaining 124 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-47035-000-000 Plumbing Inspections 2461 09/15/2017 Permit_508 Asheville 508 Asheville Lane (2,350.00) (50.00) (2,400.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (50.00) (2,400.00) ** (2,000.00) Budgeted 400.00 Remaining 120 % Used Account: 135-47045-000-000 Sewer Inspections 2461 09/15/2017 Permit_508 Asheville 508 Asheville Lane (4,650.00) (150.00) (4,800.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (4,800.00) ** (5,500.00) Budgeted (700.00) Remaining 87 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2419 09/30/2017 Billing-September 2017 UB20170930-20170930 User: (71,989.85) (15,168.80) (87,158.65) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (15,168.80) (87,158.65) ** (61,188.00) Budgeted 25,970.65 Remaining 142 % Used Account: 135-49010-000-000 Interest Income 2396 09/01/2017 June Bk of West CD Interest (16,094.00) (158.21) (16,252.21) GL 2460 09/30/2017 Bank Interest September (1,801.07) (18,053.28) GL 2460 09/30/2017 Bank Interest September (305.33) (18,358.61) GL 2460 09/30/2017 Bank Interest September (439.21) (18,797.82) GL 2460 09/30/2017 Bank Interest September (141.78) (18,939.60) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (2,845.60) (18,939.60) ** (8,001.00) Budgeted 10,938.60 Remaining 237 % Used Account: 135-49016-000-000 Cell Tower Revenue 2412 09/19/2017 AT&T Cell Tower Revenue (10,015.83) (910.53) (10,926.36) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,926.36) ** (10,926.00) Budgeted .36 Remaining 100 % Used Account: 135-49018-000-000 Building Rent Income 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (6,416.63) (583.37) (7,000.00) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.37) (7,000.00) ** (7,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-49075-000-000 Oversize Meter Reimbursement 2461 09/15/2017 Permit_508 Asheville 508 Asheville Lane (20,521.02) (343.00) (20,864.02) Ashton Wood Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (343.00) (20,864.02) ** (21,609.00) Budgeted (744.98) Remaining 97 % Used Account: 135-49900-000-000 Miscellaneous Income 2419 09/30/2017 Billing-September 2017 UB20170930-20170930 User: (12,337.50) (113.81) (12,451.31) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (113.81) (12,451.31) ** (20,000.00) Budgeted (7,548.69) Remaining 62 % Used Account: 135-49901-000-000 Records Management Revenue (32.00) .00 (32.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense 2415 09/22/2017 PUC Retainer Balance refunded (81,791.15) (81,791.15) GL _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: (81,791.15) (81,791.15) ** .00 Budgeted 81,791.15 Remaining 0 % Used Department Totals: ----------------------------------- (8,735,379.75) ** (988,183.77) Monthly Total (9,545,080.00) Budgeted (809,700.25) Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 2278 09/08/2017 MUD PR 09/08/17 Salaries & Wages 197,796.51 9,771.83 207,568.34 PR 2352 09/22/2017 MUD PR 09.22.17 Salaries & Wages 9,776.97 217,345.31 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,548.80 217,345.31 ** 236,143.00 Budgeted 18,797.69 Remaining 92 % Used Account: 135-50010-010-000 Overtime 2278 09/08/2017 MUD PR 09/08/17 Overtime 11,241.69 630.44 11,872.13 PR 2352 09/22/2017 MUD PR 09.22.17 Overtime 690.49 12,562.62 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,320.93 12,562.62 ** 19,500.00 Budgeted 6,937.38 Remaining 64 % 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 2352 09/22/2017 MUD PR 09.22.17 Certification 2,400.00 200.00 2,600.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 2,600.00 ** 3,000.00 Budgeted 400.00 Remaining 87 % Used Account: 135-50020-010-000 Retirement 2278 09/08/2017 MUD PR 09/08/17 Retirement 19,539.85 962.22 20,502.07 PR 2352 09/22/2017 MUD PR 09.22.17 Retirement 986.73 21,488.80 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,948.95 21,488.80 ** 27,151.00 Budgeted 5,662.20 Remaining 79 % Used Account: 135-50026-010-000 Medical Insurance 2278 09/08/2017 MUD PR 09/08/17 Medical Insurance 27,203.03 1,417.32 28,620.35 PR 2352 09/22/2017 MUD PR 09.22.17 Medical Insurance 1,417.33 30,037.68 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,834.65 30,037.68 ** 55,914.00 Budgeted 25,876.32 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 2278 09/08/2017 MUD PR 09/08/17 Dental Insurance 2,661.23 140.52 2,801.75 PR 2352 09/22/2017 MUD PR 09.22.17 Dental Insurance 140.47 2,942.22 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 280.99 2,942.22 ** 4,159.00 Budgeted 1,216.78 Remaining 71 % Used Account: 135-50028-010-000 Vision Insurance 2278 09/08/2017 MUD PR 09/08/17 Vision Insurance 519.94 29.16 549.10 PR 2352 09/22/2017 MUD PR 09.22.17 Vision Insurance 29.11 578.21 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 58.27 578.21 ** 910.00 Budgeted 331.79 Remaining 64 % Used Account: 135-50029-010-000 Life Insurance & Other 2203 09/01/2017 September A/P Dental, Vision, Life, & other 2,327.79 237.74 2,565.53 METLIFE GROUP BENEFITS 3449 AP 2394 09/27/2017 September A/P Café 125 Adm 10.67 2,576.20 BenefitMall 3527 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 248.41 2,576.20 ** 2,803.00 Budgeted 226.80 Remaining 92 % Used Account: 135-50030-010-000 Social Security Taxes 2278 09/08/2017 MUD PR 09/08/17 Social Security Taxes 13,041.81 640.91 13,682.72 PR 2352 09/22/2017 MUD PR 09.22.17 Social Security Taxes 652.16 14,334.88 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,293.07 14,334.88 ** 19,021.00 Budgeted 4,686.12 Remaining 75 % Used Account: 135-50035-010-000 Medicare Taxes 2278 09/08/2017 MUD PR 09/08/17 Medicare Taxes 3,050.13 149.87 3,200.00 PR 2352 09/22/2017 MUD PR 09.22.17 Medicare Taxes 152.53 3,352.53 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 302.40 3,352.53 ** 4,448.00 Budgeted 1,095.47 Remaining 75 % Used Account: 135-50040-010-000 Unemployment Taxes 2278 09/08/2017 MUD PR 09/08/17 Unemployment Taxes 46.50 2.10 48.60 PR 2352 09/22/2017 MUD PR 09.22.17 Unemployment Taxes 2.17 50.77 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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: 4.27 50.77 ** 1,026.00 Budgeted 975.23 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 471 09/01/2017 Insurance/Wrk Comp Exp Sep 10,789.76 1,074.34 11,864.10 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.34 11,864.10 ** 13,152.00 Budgeted 1,287.90 Remaining 90 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 346.90 .00 346.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 346.90 ** 1,300.00 Budgeted 953.10 Remaining 27 % Used Account: 135-50070-010-000 Employee Relations 187.09 .00 187.09 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 187.09 ** 300.00 Budgeted 112.91 Remaining 62 % Used Account: 135-55005-010-000 Engineering 28,762.16 .00 28,762.16 _______________ Account: 135-55005-010-000 Engineering Totals: .00 28,762.16 ** 30,000.00 Budgeted 1,237.84 Remaining 96 % Used Account: 135-55080-010-000 Maintenance & Repairs 2335 09/15/2017 September A/P Scada Computer 74,933.81 4,155.52 79,089.33 DHS AUTOMATION, INC 3495 AP 2335 09/15/2017 September A/P Pump #1 Failure 520.00 79,609.33 DHS AUTOMATION, INC 3495 AP 2368 09/21/2017 September A/P Main Break Repairs Cimarron/Na 8,285.00 87,894.33 REY-MAR CONSTRUCTION 3515 AP 2402 09/28/2017 September A/P 8" tap clamp 171.06 88,065.39 Core & Main LP 3529 AP 2464 09/30/2017 September A/P Oxygen 21.00 88,086.39 ALLIED WELDING SUPPLY, INC AP 2468 09/30/2017 MMcmahon PCard Adj Onl compone Online Components (277.99) 87,808.40 GL _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 12,874.59 87,808.40 ** 128,500.00 Budgeted 40,691.60 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-55085-010-000 Generator Maint. and Repair 2,459.00 .00 2,459.00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 2,459.00 ** 3,000.00 Budgeted 541.00 Remaining 82 % Used Account: 135-55090-010-000 Vehicle Maintenance 2,102.75 .00 2,102.75 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 2,102.75 ** 8,000.00 Budgeted 5,897.25 Remaining 26 % 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 3,748.26 .00 3,748.26 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 3,748.26 ** 5,500.00 Budgeted 1,751.74 Remaining 68 % Used Account: 135-60010-010-000 Communications/Mobiles 2335 09/15/2017 September A/P Cell Phones and Service 3,523.80 572.54 4,096.34 VERIZON WIRELESS 3523 AP 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AMAZON.COM 27.15 4,123.49 AMAZON.COM PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 599.69 4,123.49 ** 5,400.00 Budgeted 1,276.51 Remaining 76 % Used Account: 135-60020-010-000 Electricity 2335 09/15/2017 September A/P Electricity 8/9-9/11/17 138,807.68 183.58 138,991.26 HUDSON ENERGY SERVICES, LLC 3501 AP 2335 09/15/2017 September A/P Electricity 8/10-9/12/17 2,174.18 141,165.44 HUDSON ENERGY SERVICES, LLC 3501 AP 2368 09/21/2017 September A/P Electricity 8/10-9/12/17 15,586.78 156,752.22 HUDSON ENERGY SERVICES, LLC 3501 AP _______________ Account: 135-60020-010-000 Electricity Totals: 17,944.54 156,752.22 ** 172,737.00 Budgeted 15,984.78 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .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 2298 09/08/2017 September A/P C Water Test 825.00 111.00 936.00 TX COMMISSION ENVIRONMENTAL QU 3486 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 936.00 ** 4,222.00 Budgeted 3,286.00 Remaining 22 % 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 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 .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 24,978.35 .00 24,978.35 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 24,978.35 ** 50,176.00 Budgeted 25,197.65 Remaining 50 % Used Account: 135-60150-010-000 Wholesale Water 2444 09/30/2017 September A/P August Wholesale Water 1,736,536.79 222,900.19 1,959,436.98 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 222,900.19 1,959,436.98 ** 2,498,802.00 Budgeted 539,365.02 Remaining 78 % Used Account: 135-60245-010-000 Miscellaneous Expenses 102.70 .00 102.70 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 102.70 ** 200.00 Budgeted 97.30 Remaining 51 % Used Account: 135-60280-010-000 Property Maintenance 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 DENTON SAND & 00 OF 00 666.60 108.00 774.60 DENTON SAND & 00 OF 00 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 108.00 774.60 ** 5,000.00 Budgeted 4,225.40 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2444 09/30/2017 September A/P September Mowing 6,750.00 1,500.00 8,250.00 WATTS ELLISON LLC AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 8,250.00 ** 14,750.00 Budgeted 6,500.00 Remaining 56 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 240,821.65 .00 240,821.65 _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: .00 240,821.65 ** 240,822.00 Budgeted .35 Remaining 100 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 2295 09/08/2017 Texpool Transfers 43,964.45 4,083.00 48,047.45 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 48,047.45 ** 48,047.00 Budgeted (.45) Remaining 100 % 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 2394 09/27/2017 September A/P Fuel 8/25-9/24/17 7,693.52 1,039.81 8,733.33 US Bank Voyager Fleet Systems 3543 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,039.81 8,733.33 ** 9,828.00 Budgeted 1,094.67 Remaining 89 % Used Account: 135-65010-010-000 Uniforms 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AMAZON.COM 2,923.86 139.93 3,063.79 AMAZON.COM PC _______________ Account: 135-65010-010-000 Uniforms Totals: 139.93 3,063.79 ** 4,608.00 Budgeted 1,544.21 Remaining 66 % Used Account: 135-65030-010-000 Chemicals 2394 09/27/2017 September A/P Chemicals 22,833.07 642.20 23,475.27 HACH COMPANY 3533 AP 2394 09/27/2017 September A/P Chemicals 741.59 24,216.86 DPC INDUSTRIES, INC 3531 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,383.79 24,216.86 ** 20,000.00 Budgeted (4,216.86) Remaining 121 % Used Account: 135-65035-010-000 Small Tools 867.64 .00 867.64 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-65035-010-000 Small Tools Totals: .00 867.64 ** 1,200.00 Budgeted 332.36 Remaining 72 % Used Account: 135-65040-010-000 Safety Equipment 506.50 .00 506.50 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 506.50 ** 1,000.00 Budgeted 493.50 Remaining 51 % Used Account: 135-65050-010-000 Meter Expense 23,999.88 .00 23,999.88 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 23,999.88 ** 31,500.00 Budgeted 7,500.12 Remaining 76 % Used Account: 135-65053-010-000 Meter Change Out Program 71,160.00 .00 71,160.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 71,160.00 ** 81,500.00 Budgeted 10,340.00 Remaining 87 % Used Account: 135-69005-010-000 Capital Outlays 2335 09/15/2017 September A/P High Speed Pump 343,087.82 3,082.35 346,170.17 CP&Y/WALLACE GROUP, INC. 3493 AP 2335 09/15/2017 September A/P TCEQ Bond Application 3,267.50 349,437.67 CP&Y/WALLACE GROUP, INC. 3493 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 6,349.85 349,437.67 ** 690,422.00 Budgeted 340,984.33 Remaining 51 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-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 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/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 2335 09/15/2017 September A/P Lead & Copper testing 1,503.10 600.00 2,103.10 Centralized Water & Wastewater 3490 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 600.00 2,103.10 ** 5,000.00 Budgeted 2,896.90 Remaining 42 % 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: ----------------------------------- 3,579,579.30 ** 298,749.47 Monthly Total 4,869,919.00 Budgeted 1,290,339.70 Remaining 74 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 2278 09/08/2017 MUD PR 09/08/17 Salaries & Wages 342,451.67 14,989.04 357,440.71 PR 2352 09/22/2017 MUD PR 09.22.17 Salaries & Wages 14,989.04 372,429.75 PR 2355 09/22/2017 MUD PR Anniversary Chk 9.22.17 Salaries & Wages 234.33 372,664.08 PR 2397 09/27/2017 MUD PR Anniversary Check Salaries & Wages 234.33 372,898.41 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,446.74 372,898.41 ** 371,102.00 Budgeted (1,796.41) Remaining 100 % Used Account: 135-50010-020-000 Overtime 2278 09/08/2017 MUD PR 09/08/17 Overtime 28,558.63 1,209.82 29,768.45 PR 2352 09/22/2017 MUD PR 09.22.17 Overtime 1,427.14 31,195.59 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,636.96 31,195.59 ** 29,500.00 Budgeted (1,695.59) Remaining 106 % 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 2352 09/22/2017 MUD PR 09.22.17 Certification 7,575.00 700.00 8,275.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 8,275.00 ** 7,800.00 Budgeted (475.00) Remaining 106 % Used Account: 135-50020-020-000 Retirement 2278 09/08/2017 MUD PR 09/08/17 Retirement 35,082.53 1,498.39 36,580.92 PR 2352 09/22/2017 MUD PR 09.22.17 Retirement 1,583.25 38,164.17 PR 2355 09/22/2017 MUD PR Anniversary Chk 9.22.17 Retirement 21.68 38,185.85 PR 2397 09/27/2017 MUD PR Anniversary Check Retirement 21.68 38,207.53 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,125.00 38,207.53 ** 39,584.00 Budgeted 1,376.47 Remaining 97 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2278 09/08/2017 MUD PR 09/08/17 Medical Insurance 50,425.31 2,355.10 52,780.41 PR 2352 09/22/2017 MUD PR 09.22.17 Medical Insurance 2,355.10 55,135.51 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 55,135.51 ** 73,022.00 Budgeted 17,886.49 Remaining 76 % Used Account: 135-50027-020-000 Dental Insurance 2278 09/08/2017 MUD PR 09/08/17 Dental Insurance 4,065.00 199.69 4,264.69 PR 2352 09/22/2017 MUD PR 09.22.17 Dental Insurance 199.63 4,464.32 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 4,464.32 ** 4,592.00 Budgeted 127.68 Remaining 97 % Used Account: 135-50028-020-000 Vision Insurance 2278 09/08/2017 MUD PR 09/08/17 Vision Insurance 869.91 42.19 912.10 PR 2352 09/22/2017 MUD PR 09.22.17 Vision Insurance 42.14 954.24 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 954.24 ** 1,031.00 Budgeted 76.76 Remaining 93 % Used Account: 135-50029-020-000 Life Insurance & Other 2203 09/01/2017 September A/P Dental, Vision, Life, & other 4,159.22 361.15 4,520.37 METLIFE GROUP BENEFITS 3449 AP 2394 09/27/2017 September A/P Café 125 Adm 31.99 4,552.36 BenefitMall 3527 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 393.14 4,552.36 ** 4,485.00 Budgeted (67.36) Remaining 102 % Used Account: 135-50030-020-000 Social Security Taxes 2278 09/08/2017 MUD PR 09/08/17 Social Security Taxes 22,446.16 946.99 23,393.15 PR 2352 09/22/2017 MUD PR 09.22.17 Social Security Taxes 985.32 24,378.47 PR 2355 09/22/2017 MUD PR Anniversary Chk 9.22.17 Social Security Taxes 14.53 24,393.00 PR 2397 09/27/2017 MUD PR Anniversary Check Social Security Taxes 14.53 24,407.53 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,961.37 24,407.53 ** 27,886.00 Budgeted 3,478.47 Remaining 88 % Used Account: 135-50035-020-000 Medicare Taxes 2278 09/08/2017 MUD PR 09/08/17 Medicare Taxes 5,249.50 221.47 5,470.97 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2352 09/22/2017 MUD PR 09.22.17 Medicare Taxes 5,249.50 230.43 5,701.40 PR 2355 09/22/2017 MUD PR Anniversary Chk 9.22.17 Medicare Taxes 3.40 5,704.80 PR 2397 09/27/2017 MUD PR Anniversary Check Medicare Taxes 3.40 5,708.20 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 458.70 5,708.20 ** 6,522.00 Budgeted 813.80 Remaining 88 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 _______________ 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 471 09/01/2017 Insurance/Wrk Comp Exp Sep 13,976.25 926.71 14,902.96 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.71 14,902.96 ** 11,347.00 Budgeted (3,555.96) Remaining 131 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 80.00 .00 80.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 80.00 ** 300.00 Budgeted 220.00 Remaining 27 % Used Account: 135-50070-020-000 Employee Relations 461.00 .00 461.00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 461.00 ** 650.00 Budgeted 189.00 Remaining 71 % Used Account: 135-55005-020-000 Engineering 852.48 .00 852.48 _______________ Account: 135-55005-020-000 Engineering Totals: .00 852.48 ** 1,000.00 Budgeted 147.52 Remaining 85 % Used Account: 135-55070-020-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 THE HOME DEPOT #6581 96,989.45 22.46 97,011.91 THE HOME DEPOT #6581 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 THE HOME DEPOT #6581 35.48 97,047.39 THE HOME DEPOT #6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 57.94 97,047.39 ** 99,700.00 Budgeted 2,652.61 Remaining 97 % Used Account: 135-55085-020-000 Generator Maint. and Repair 6,076.00 .00 6,076.00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 6,076.00 ** 7,000.00 Budgeted 924.00 Remaining 87 % Used Account: 135-55090-020-000 Vehicle Maintenance 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 SOUTHWEST INTERNATIONA 7,782.41 1,144.68 8,927.09 SOUTHWEST INTERNATIONA PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 WAL-MART #1178 120.93 9,048.02 WAL-MART #1178 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,265.61 9,048.02 ** 9,600.00 Budgeted 551.98 Remaining 94 % 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 2368 09/21/2017 September A/P Sludge haul off 49,944.68 1,690.00 51,634.68 L.H. CHANEY MATERIALS, INC. 3505 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,690.00 51,634.68 ** 55,000.00 Budgeted 3,365.32 Remaining 94 % Used Account: 135-55135-020-000 Lab Analysis . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2301 09/08/2017 September A/P Testing 30,265.06 176.00 30,441.06 OXIDOR LABORATORIES LLC 3514 AP 2301 09/08/2017 September A/P Testing 205.50 30,646.56 OXIDOR LABORATORIES LLC 3514 AP 2301 09/08/2017 September A/P Testing 246.00 30,892.56 OXIDOR LABORATORIES LLC 3514 AP 2301 09/08/2017 September A/P Testing 113.00 31,005.56 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P Testing 205.50 31,211.06 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P Testing 246.00 31,457.06 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P TEsting 176.00 31,633.06 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P Testing 205.50 31,838.56 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P Testing 246.00 32,084.56 OXIDOR LABORATORIES LLC 3514 AP 2368 09/21/2017 September A/P Testing 176.00 32,260.56 OXIDOR LABORATORIES LLC 3514 AP 2419 09/30/2017 Billing-September 2017 UB20170930-20170930 User: (772.50) 31,488.06 UB _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,223.00 31,488.06 ** 31,000.00 Budgeted (488.06) Remaining 102 % Used Account: 135-60010-020-000 Communications/Mobiles 2335 09/15/2017 September A/P Cell Phones and Service 4,709.54 368.57 5,078.11 VERIZON WIRELESS 3523 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 368.57 5,078.11 ** 5,400.00 Budgeted 321.89 Remaining 94 % Used Account: 135-60020-020-000 Electricity 2335 09/15/2017 September A/P Electricity 8/9-9/11/17 130,049.21 35.54 130,084.75 HUDSON ENERGY SERVICES, LLC 3501 AP 2335 09/15/2017 September A/P Electricity 8/9-9/11/17 157.09 130,241.84 HUDSON ENERGY SERVICES, LLC 3501 AP 2335 09/15/2017 September A/P Electricity 8/10-9/12/17 105.92 130,347.76 HUDSON ENERGY SERVICES, LLC 3501 AP 2335 09/15/2017 September A/P Electricity 7/26-8/25/17 236.81 130,584.57 TRI COUNTY ELECTRIC 3521 AP 2335 09/15/2017 September A/P Electricity 7/26-8/25/17 27.33 130,611.90 TRI COUNTY ELECTRIC 3521 AP 2335 09/15/2017 September A/P Electricity 7/26-8/25/17 367.19 130,979.09 TRI COUNTY ELECTRIC 3521 AP 2368 09/21/2017 September A/P Electricity 8/10-9/12/17 4,592.47 135,571.56 ENGIE Resources LLC 3497 AP 2368 09/21/2017 September A/P Electricity 8/10-9/12/17 258.91 135,830.47 MP2 ENERGY TEXAS LLC 3511 AP 2368 09/21/2017 September A/P Electricity 8/10-9/12/17 8,532.46 144,362.93 HUDSON ENERGY SERVICES, LLC 3501 AP 2368 09/21/2017 September A/P Electricity 8/10-9/12/17 745.67 145,108.60 HUDSON ENERGY SERVICES, LLC 3501 AP 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (186.77) 144,921.83 AR _______________ Account: 135-60020-020-000 Electricity Totals: 14,872.62 144,921.83 ** 158,627.00 Budgeted 13,705.17 Remaining 91 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 2444 09/30/2017 September A/P Reimburse petty cash 143.85 6.00 149.85 TROPHY CLUB MUD PETTY CASH AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60066-020-000 Publications/Books/Subscripts Totals: 6.00 149.85 ** 400.00 Budgeted 250.15 Remaining 37 % 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 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 NCTCOG RTC TRAINING 2,357.81 99.00 2,456.81 NCTCOG RTC TRAINING PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 NCTCOG RTC TRAINING 120.00 2,576.81 NCTCOG RTC TRAINING PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 NCTCOG RTC TRAINING 160.00 2,736.81 NCTCOG RTC TRAINING PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 TCEQ IND RENEWAL L 111.00 2,847.81 TCEQ IND RENEWAL L PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 TCEQ IND RENEWAL L 111.00 2,958.81 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 601.00 2,958.81 ** 4,195.00 Budgeted 1,236.19 Remaining 71 % Used Account: 135-60090-020-000 Safety Program 291.12 .00 291.12 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 291.12 ** 550.00 Budgeted 258.88 Remaining 53 % Used Account: 135-60100-020-000 Travel & per diem 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 REDNECK HEAVEN ARL 2,486.18 32.62 2,518.80 REDNECK HEAVEN ARL PC 2394 09/27/2017 September A/P Tolls 81.15 2,599.95 NTTA 3539 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 113.77 2,599.95 ** 2,400.00 Budgeted (199.95) Remaining 108 % Used 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60125-020-000 Advertising 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** 4,086.00 Budgeted (.37) Remaining 100 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 18,348.38 .00 18,348.38 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 18,348.38 ** 18,348.00 Budgeted (.38) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses 113.27 .00 113.27 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 113.27 ** 450.00 Budgeted 336.73 Remaining 25 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 6,621.00 Budgeted 6,621.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2444 09/30/2017 September A/P September Mowing 5,310.00 1,180.00 6,490.00 WATTS ELLISON LLC AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 6,490.00 ** 11,600.00 Budgeted 5,110.00 Remaining 56 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 .00 120,492.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 120,492.00 ** 120,492.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 595,638.00 .00 595,638.00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 595,638.00 ** 595,638.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 2295 09/08/2017 Texpool Transfers 170,139.25 10,278.00 180,417.25 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 180,417.25 ** 180,417.00 Budgeted (.25) Remaining 100 % 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 2394 09/27/2017 September A/P Fuel 8/25-9/24/17 7,814.24 907.98 8,722.22 US Bank Voyager Fleet Systems 3543 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 907.98 8,722.22 ** 11,088.00 Budgeted 2,365.78 Remaining 79 % 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 23,247.95 .00 23,247.95 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 23,247.95 ** 28,200.00 Budgeted 4,952.05 Remaining 82 % Used Account: 135-65035-020-000 Small Tools 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 THE HOME DEPOT #6581 1,682.36 509.00 2,191.36 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-65035-020-000 Small Tools Totals: 509.00 2,191.36 ** 2,000.00 Budgeted (191.36) Remaining 110 % Used Account: 135-65040-020-000 Safety Equipment 517.03 .00 517.03 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 517.03 ** 750.00 Budgeted 232.97 Remaining 69 % Used Account: 135-65045-020-000 Lab Supplies 2368 09/21/2017 September A/P Gloves for testing 13,095.59 162.00 13,257.59 LOU'S GLOVES INCORPORATED 3507 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 162.00 13,257.59 ** 14,000.00 Budgeted 742.41 Remaining 95 % Used Account: 135-69005-020-000 Capital Outlays 2301 09/08/2017 September A/P Lift Station #6 Control Panel 200,903.11 19,600.00 220,503.11 Walker Industrial LLC 3524 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 19,600.00 220,503.11 ** 222,000.00 Budgeted 1,496.89 Remaining 99 % Used Department 20 Totals: ----------------------------------- 2,137,605.68 ** 98,677.96 Monthly Total 2,410,441.00 Budgeted 272,835.32 Remaining 89 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 471 09/01/2017 Insurance/Wrk Comp Exp Sep 27.71 2.57 30.28 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.57 30.28 ** 32.00 Budgeted 1.72 Remaining 95 % 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 145.45 .00 145.45 _______________ Account: 135-60075-026-000 Meetings Totals: .00 145.45 ** 1,200.00 Budgeted 1,054.55 Remaining 12 % Used Account: 135-60080-026-000 Schools & Training 3,557.35 .00 3,557.35 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 3,557.35 ** 4,000.00 Budgeted 442.65 Remaining 89 % Used Account: 135-60100-026-000 Travel & per diem 2335 09/15/2017 September A/P Mileage Reimb, Parking, SOAH 2,446.95 242.91 2,689.86 William Rose 3487 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 242.91 2,689.86 ** 5,000.00 Budgeted 2,310.14 Remaining 54 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 FLOWERSHOPNETWORK.COM 75.35 75.35 FLOWERSHOPNETWORK.COM PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 75.35 75.35 ** 2,000.00 Budgeted 1,924.65 Remaining 4 % Used Department 26 Totals: ----------------------------------- 6,498.29 ** 320.83 Monthly Total 12,882.00 Budgeted 6,383.71 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 2278 09/08/2017 MUD PR 09/08/17 Salaries & Wages 381,324.38 13,367.23 394,691.61 PR 2352 09/22/2017 MUD PR 09.22.17 Salaries & Wages 13,370.48 408,062.09 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 26,737.71 408,062.09 ** 424,883.00 Budgeted 16,820.91 Remaining 96 % Used Account: 135-50010-030-000 Overtime 2278 09/08/2017 MUD PR 09/08/17 Overtime 3,410.12 36.19 3,446.31 PR 2352 09/22/2017 MUD PR 09.22.17 Overtime 27.89 3,474.20 PR _______________ Account: 135-50010-030-000 Overtime Totals: 64.08 3,474.20 ** 2,500.00 Budgeted (974.20) Remaining 139 % 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 2278 09/08/2017 MUD PR 09/08/17 Retirement 35,207.90 1,239.82 36,447.72 PR 2352 09/22/2017 MUD PR 09.22.17 Retirement 1,239.33 37,687.05 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,479.15 37,687.05 ** 47,768.00 Budgeted 10,080.95 Remaining 79 % Used Account: 135-50026-030-000 Medical Insurance 2278 09/08/2017 MUD PR 09/08/17 Medical Insurance 41,326.88 1,438.58 42,765.46 PR 2352 09/22/2017 MUD PR 09.22.17 Medical Insurance 1,438.59 44,204.05 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 2,877.17 44,204.05 ** 84,289.00 Budgeted 40,084.95 Remaining 52 % Used Account: 135-50027-030-000 Dental Insurance 2278 09/08/2017 MUD PR 09/08/17 Dental Insurance 3,663.67 136.94 3,800.61 PR 2352 09/22/2017 MUD PR 09.22.17 Dental Insurance 136.90 3,937.51 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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: 273.84 3,937.51 ** 5,981.00 Budgeted 2,043.49 Remaining 66 % Used Account: 135-50028-030-000 Vision Insurance 2278 09/08/2017 MUD PR 09/08/17 Vision Insurance 784.52 28.88 813.40 PR 2352 09/22/2017 MUD PR 09.22.17 Vision Insurance 28.84 842.24 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 57.72 842.24 ** 1,312.00 Budgeted 469.76 Remaining 64 % Used Account: 135-50029-030-000 Life Insurance & Other 2203 09/01/2017 September A/P Dental, Vision, Life, & other 4,147.73 289.83 4,437.56 METLIFE GROUP BENEFITS 3449 AP 2390 09/01/2017 Adj Medical due to rounding .01 4,437.57 GL 2394 09/27/2017 September A/P Café 125 Adm 21.34 4,458.91 BenefitMall 3527 AP 2403 09/28/2017 September A/P Rounding adjustment (.02) 4,458.89 Legal Shield 3537 AP 2466 09/30/2017 Clear Insurance Liab @ 9/30/17 (32.68) 4,426.21 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 278.48 4,426.21 ** 5,890.00 Budgeted 1,463.79 Remaining 75 % Used Account: 135-50030-030-000 Social Security Taxes 2278 09/08/2017 MUD PR 09/08/17 Social Security Taxes 22,911.26 793.26 23,704.52 PR 2352 09/22/2017 MUD PR 09.22.17 Social Security Taxes 781.16 24,485.68 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,574.42 24,485.68 ** 32,777.00 Budgeted 8,291.32 Remaining 75 % Used Account: 135-50035-030-000 Medicare Taxes 2278 09/08/2017 MUD PR 09/08/17 Medicare Taxes 5,358.27 185.52 5,543.79 PR 2352 09/22/2017 MUD PR 09.22.17 Medicare Taxes 182.68 5,726.47 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 368.20 5,726.47 ** 8,084.00 Budgeted 2,357.53 Remaining 71 % Used Account: 135-50040-030-000 Unemployment Taxes 2471 09/30/2017 SUTA Qtrly 3 Adjustment 293.73 (.01) 293.72 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-030-000 Unemployment Taxes Totals: (.01) 293.72 ** 1,368.00 Budgeted 1,074.28 Remaining 21 % Used Account: 135-50045-030-000 Workman's Compensation 471 09/01/2017 Insurance/Wrk Comp Exp Sep 1,650.83 145.53 1,796.36 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,796.36 ** 1,784.00 Budgeted (12.36) Remaining 101 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 2464 09/30/2017 September A/P Pre-employment testing 606.80 55.95 662.75 FIRST CHECK APPLICANT SCREENIN AP 2469 09/30/2017 September A/P Pre-employment testing 38.00 700.75 CARENOW CORPORATE AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 93.95 700.75 ** 500.00 Budgeted (200.75) Remaining 140 % Used Account: 135-50070-030-000 Employee Relations 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 NOTHING BUNDT CAKES #0 2,640.34 37.00 2,677.34 NOTHING BUNDT CAKES #0 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 TOM THUMB STOR00017897 14.99 2,692.33 TOM THUMB STOR00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 51.99 2,692.33 ** 4,960.00 Budgeted 2,267.67 Remaining 54 % Used Account: 135-55030-030-000 Software & Support 2335 09/15/2017 September A/P Internet 87,205.49 1,036.77 88,242.26 WHOLESALE CARRIER SERVICES INC 3525 AP 2335 09/15/2017 September A/P Ofc 365 Email license 168.00 88,410.26 M3 Networks 3508 AP 2335 09/15/2017 September A/P Hardware, Cloud Controller lic 468.00 88,878.26 M3 Networks 3508 AP 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 DNH*GODADDY.COM 35.34 88,913.60 DNH*GODADDY.COM PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AT&T *PAYMENT 63.49 88,977.09 AT&T *PAYMENT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 ATT*BILL PAYMENT 102.08 89,079.17 ATT*BILL PAYMENT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 ATT*BILL PAYMENT 118.59 89,197.76 ATT*BILL PAYMENT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AT&T *PAYMENT 85.56 89,283.32 AT&T *PAYMENT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 ADOBE *IL CREATIVE CLD 19.99 89,303.31 ADOBE *IL CREATIVE CLD PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 CANVA FOR WORK MONTHLY 12.95 89,316.26 CANVA FOR WORK MONTHLY PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 CANVA 01704-2355706 10.00 89,326.26 CANVA 01704-2355706 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 FOTOLIA - WWVOEKDNIMDB 35.00 89,361.26 FOTOLIA - WWVOEKDNIMDB PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,155.77 89,361.26 ** 87,791.00 Budgeted (1,570.26) Remaining 102 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-55070-030-000 Independent Labor 2335 09/15/2017 September A/P Temp Receptionist 17,455.42 541.55 17,996.97 Onin Staffing, LLC 3513 AP 2361 09/20/2017 September A/P Temp Receptionist 540.88 18,537.85 Onin Staffing, LLC 3513 AP 2394 09/27/2017 September A/P Temp Receptionist 686.19 19,224.04 Onin Staffing, LLC 3540 AP 2431 09/30/2017 September A/P GM Hours- 136 10,200.00 29,424.04 Carman Consulting LLC. AP 2431 09/30/2017 September A/P Temp Receptionist Hours- 40 R, 681.65 30,105.69 Onin Staffing, LLC AP 2444 09/30/2017 September A/P Sept GM 10,200.00 40,305.69 Carman Consulting LLC. AP 2464 09/30/2017 September A/P Video MUD Meetings/Aug & Sept 135.00 40,440.69 MIGUEL CRUZ AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 22,985.27 40,440.69 ** 34,000.00 Budgeted (6,440.69) Remaining 119 % Used Account: 135-55080-030-000 Maintenance & Repairs 826.00 .00 826.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 826.00 ** 2,000.00 Budgeted 1,174.00 Remaining 41 % 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 2335 09/15/2017 September A/P Rug Service 6,769.75 66.47 6,836.22 G & K SERVICES 3499 AP 2395 09/27/2017 September A/P Rug Service 66.47 6,902.69 G & K SERVICES 3532 AP 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (66.47) 6,836.22 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 66.47 6,836.22 ** 7,000.00 Budgeted 163.78 Remaining 98 % Used Account: 135-55120-030-000 Cleaning Services 2372 09/21/2017 September A/P Janitorial Service/August 6,071.60 869.06 6,940.66 MEMBER'S BUILDING MAINTENANCE 3510 AP 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (236.00) 6,704.66 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 6,704.66 ** 8,000.00 Budgeted 1,295.34 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-55160-030-000 Professional Outside Services 2368 09/21/2017 September A/P Rate Projections 61,417.64 1,675.00 63,092.64 NEW GEN STRATEGIES & SOLUTIONS 3512 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 1,675.00 63,092.64 ** 63,325.00 Budgeted 232.36 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 6,877.89 .00 6,877.89 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 6,877.89 ** 8,200.00 Budgeted 1,322.11 Remaining 84 % Used Account: 135-60005-030-000 Telephone 2288 09/06/2017 September A/P 12,815.96 219.75 13,035.71 KEYSTONE PARK SECRETARIAL 3470 AP 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 ATT*BUS PHONE PMT 850.75 13,886.46 ATT*BUS PHONE PMT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 ATT*BUS PHONE PMT 451.07 14,337.53 ATT*BUS PHONE PMT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AT&T *PAYMENT 185.85 14,523.38 AT&T *PAYMENT PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 RINGCENTRAL, INC 13.94 14,537.32 RINGCENTRAL, INC PC 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (456.28) 14,081.04 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,265.08 14,081.04 ** 17,532.00 Budgeted 3,450.96 Remaining 80 % Used Account: 135-60010-030-000 Communications/Mobiles 2335 09/15/2017 September A/P Cell Phones and Service 3,004.90 404.00 3,408.90 VERIZON WIRELESS 3523 AP 2352 09/22/2017 MUD PR 09.22.17 Communications/Mobiles 225.00 3,633.90 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 629.00 3,633.90 ** 3,500.00 Budgeted (133.90) Remaining 104 % Used Account: 135-60020-030-000 Electricity/Gas 8,022.75 .00 8,022.75 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-030-000 Electricity/Gas Totals: .00 8,022.75 ** 12,631.00 Budgeted 4,608.25 Remaining 64 % Used Account: 135-60025-030-000 Water 2444 09/30/2017 September A/P September Water 979.51 122.38 1,101.89 TROPHY CLUB MUD (WATER BILLS) AP 2463 09/30/2017 Town Billed INV 1593-98 AR 20170930-20170930 User: (61.19) 1,040.70 AR _______________ Account: 135-60025-030-000 Water Totals: 61.19 1,040.70 ** 1,500.00 Budgeted 459.30 Remaining 69 % Used Account: 135-60035-030-000 Postage 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 FEDEX 787544388114 25,674.03 50.75 25,724.78 FEDEX 787544388114 PC 2444 09/30/2017 September A/P Reimburse petty cash 1.15 25,725.93 TROPHY CLUB MUD PETTY CASH AP _______________ Account: 135-60035-030-000 Postage Totals: 51.90 25,725.93 ** 28,932.00 Budgeted 3,206.07 Remaining 89 % Used Account: 135-60040-030-000 Service Charges & Fees 2279 09/08/2017 Child Support Fee 47,590.85 1.50 47,592.35 GL 2353 09/22/2017 Child Support Fee 1.50 47,593.85 GL 2444 09/30/2017 September A/P Late fee 25.00 47,618.85 KYOCERA DOCUMENT SOLUTIONS AP 2444 09/30/2017 September A/P August Direct Send Fees 50.00 47,668.85 Fiserv Solutions, LLC AP 2445 09/30/2017 Credit card fees 4,870.33 52,539.18 GL 2445 09/30/2017 Credit card fees 168.24 52,707.42 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,116.57 52,707.42 ** 55,560.00 Budgeted 2,852.58 Remaining 95 % Used Account: 135-60050-030-000 Bad Debt Expense 2443 09/29/2017 Write Offs UB20170929-20170929 User: 526.88 1,147.52 1,674.40 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 1,147.52 1,674.40 ** 3,500.00 Budgeted 1,825.60 Remaining 48 % Used Account: 135-60055-030-000 Insurance 471 09/01/2017 Insurance/Wrk Comp Exp Sep 54,949.96 4,664.50 59,614.46 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60055-030-000 Insurance Totals: 4,664.50 59,614.46 ** 55,692.00 Budgeted (3,922.46) Remaining 107 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 769.51 .00 769.51 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 769.51 ** 1,600.00 Budgeted 830.49 Remaining 48 % Used Account: 135-60070-030-000 Dues & Memberships 4,851.25 .00 4,851.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,851.25 ** 6,000.00 Budgeted 1,148.75 Remaining 81 % Used Account: 135-60075-030-000 Meetings 121.69 .00 121.69 _______________ Account: 135-60075-030-000 Meetings Totals: .00 121.69 ** 400.00 Budgeted 278.31 Remaining 30 % Used Account: 135-60079-030-000 Public Education 4,972.32 .00 4,972.32 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,972.32 ** 8,754.00 Budgeted 3,781.68 Remaining 57 % Used Account: 135-60080-030-000 Schools & Training 2,255.00 .00 2,255.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,255.00 ** 7,840.00 Budgeted 5,585.00 Remaining 29 % Used Account: 135-60100-030-000 Travel & per diem 7,111.81 .00 7,111.81 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-030-000 Travel & per diem Totals: .00 7,111.81 ** 7,500.00 Budgeted 388.19 Remaining 95 % 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 2414 09/19/2017 Tarrant County Elections Refnd 2,970.33 (9.43) 2,960.90 GL _______________ Account: 135-60115-030-000 Elections Totals: (9.43) 2,960.90 ** 7,500.00 Budgeted 4,539.10 Remaining 39 % Used Account: 135-60125-030-000 Advertising 2469 09/30/2017 September A/P AD for Tax Public Hearing 1,698.09 625.00 2,323.09 Star-Telegram Media AP _______________ Account: 135-60125-030-000 Advertising Totals: 625.00 2,323.09 ** 7,500.00 Budgeted 5,176.91 Remaining 31 % 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 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 PERSONALIZATION MALL 160.96 61.73 222.69 PERSONALIZATION MALL PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 TOM THUMB STOR00017897 5.40 228.09 TOM THUMB STOR00017897 PC 2444 09/30/2017 September A/P UB Petty cash shortage 5.82 233.91 TROPHY CLUB MUD PETTY CASH AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 72.95 233.91 ** 17,500.00 Budgeted 17,266.09 Remaining 1 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,055.94 .00 1,055.94 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,055.94 ** 2,500.00 Budgeted 1,444.06 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 2401 09/28/2017 September A/P Uniforms for Admin 142.36 332.16 474.52 RON MONTGOMERY & ASSOC INC 3541 AP _______________ Account: 135-65010-030-000 Uniforms Totals: 332.16 474.52 ** 855.00 Budgeted 380.48 Remaining 55 % Used Account: 135-65055-030-000 Hardware 2335 09/15/2017 September A/P Hardware, Cloud Controller lic 2,300.20 1,235.94 3,536.14 M3 Networks 3508 AP _______________ Account: 135-65055-030-000 Hardware Totals: 1,235.94 3,536.14 ** 3,444.00 Budgeted (92.14) Remaining 103 % Used Account: 135-65085-030-000 Office Supplies 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 STAPLES DIRECT 5,124.79 61.85 5,186.64 STAPLES DIRECT PC 2464 09/30/2017 September A/P Business cards 166.85 5,353.49 SIGMA SIGNS & PRINTING AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 228.70 5,353.49 ** 9,000.00 Budgeted 3,646.51 Remaining 59 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 754.36 .00 754.36 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 754.36 ** 2,000.00 Budgeted 1,245.64 Remaining 38 % Used Account: 135-65095-030-000 Maintenance Supplies 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 WALGREENS #6047 3,684.01 13.81 3,697.82 WALGREENS #6047 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 SAMSCLUB #4795 41.18 3,739.00 SAMSCLUB #4795 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AMAZON MKTPLACE PMTS 55.46 3,794.46 AMAZON MKTPLACE PMTS PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 OFFICE DEPOT #1079 59.53 3,853.99 OFFICE DEPOT #1079 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 OFFICE DEPOT #1079 6.99 3,860.98 OFFICE DEPOT #1079 PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 WALMART.COM 27.44 3,888.42 WALMART.COM PC 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AMAZON MKTPLACE PMTS 21.99 3,910.41 AMAZON MKTPLACE PMTS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 AMAZON MKTPLACE PMTS 3,684.01 66.25 3,976.66 AMAZON MKTPLACE PMTS PC 2444 09/30/2017 September A/P Reimburse petty cash 7.99 3,984.65 TROPHY CLUB MUD PETTY CASH AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 300.64 3,984.65 ** 4,000.00 Budgeted 15.35 Remaining 100 % Used Account: 135-65105-030-000 Printing 2446 09/26/2017 Pcard 08/29/17 - 09/26/17 STAPLES 00116533 2,553.88 38.97 2,592.85 STAPLES 00116533 PC _______________ Account: 135-65105-030-000 Printing Totals: 38.97 2,592.85 ** 2,500.00 Budgeted (92.85) Remaining 104 % Used Account: 135-69005-030-000 Capital Outlays 2394 09/27/2017 September A/P Security Project 119,756.15 7,841.00 127,597.15 3RD EYE SURVEILLANCE SYSTEMS 3526 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 7,841.00 127,597.15 ** 185,424.00 Budgeted 57,826.85 Remaining 69 % Used Account: 135-69170-030-000 Copier Lease Installments 2335 09/15/2017 September A/P Copier lease 3,364.85 165.00 3,529.85 EVERBANK COMMERCIAL FINANCE 3498 AP 2395 09/27/2017 September A/P Copies 117.14 3,646.99 KYOCERA DOCUMENT SOLUTIONS 3536 AP 2444 09/30/2017 September A/P Copies 117.44 3,764.43 KYOCERA DOCUMENT SOLUTIONS AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 399.58 3,764.43 ** 4,600.00 Budgeted 835.57 Remaining 82 % Used Department 30 Totals: ----------------------------------- 1,097,584.13 ** 86,519.07 Monthly Total 1,305,343.00 Budgeted 207,758.87 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 2469 09/30/2017 September A/P September Legal 151,326.30 4,860.00 156,186.30 McLean & Howard, L.L.P. AP 2469 09/30/2017 September A/P September legal 1,050.00 157,236.30 McLean & Howard, L.L.P. AP _______________ Account: 135-55045-039-000 Legal Totals: 5,910.00 157,236.30 ** 225,000.00 Budgeted 67,763.70 Remaining 70 % 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 2286 09/06/2017 September A/P 4th Qtr DCAD Budget 8,667.45 2,045.87 10,713.32 DENTON CENTRAL APPRAISAL DISTR 3460 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,045.87 10,713.32 ** 11,115.00 Budgeted 401.68 Remaining 96 % 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: ----------------------------------- 189,320.30 ** 7,955.87 Monthly Total 263,775.00 Budgeted 74,454.70 Remaining 72 % Used Fund 135 Totals: ----------------------------------- (1,724,792.05) (495,960.57) Monthly Total (682,720.00) Budgeted 1,042,072.05 Remaining 253 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 9/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-69195-045-000 GASB Replacement 23,163.91 .00 23,163.91 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 23,163.91 ** .00 Budgeted (23,163.91) Remaining 0 % Used Department 45 Totals: ----------------------------------- 23,163.91 ** .00 Monthly Total .00 Budgeted (23,163.91) Remaining 0 % Used Fund 137 Totals: ----------------------------------- (133,256.09) .00 Monthly Total .00 Budgeted 133,256.09 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,699,309 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,699,309 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,675,689 TOTAL LIABILITIES 1,675,689 FUND BALANCE ASSIGNED FUND BALANCE 4,433,035 NET REVENUES / EXPENDITURES (3,409,415) TOTAL FUND BALANCE 1,023,620 TOTAL LIABILITIES AND FUND BALANCE 2,699,309 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 11:05 10/09/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,301.84- 22,797.90- 22,797.90 Subtotal: 2,301.84- 22,797.90- 22,797.90 Program number: 2,301.84- 22,797.90- 22,797.90 Department number: Revenues 2,301.84- 22,797.90- 22,797.90 Revenues Subtotal ----------- 2,301.84- 22,797.90- 22,797.90 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 11:05 10/09/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 1,027,502.53 3,432,213.20 3,432,213.20- Subtotal: 1,027,502.53 3,432,213.20 3,432,213.20- Program number: 1,027,502.53 3,432,213.20 3,432,213.20- Department number: Wastewater 1,027,502.53 3,432,213.20 3,432,213.20- Expenditures Subtotal ----------- 1,027,502.53 3,432,213.20 3,432,213.20- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,025,200.69 3,409,415.30 3,409,415.30- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/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 2460 09/30/2017 Bank Interest September (20,496.06) (2,301.84) (22,797.90) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (2,301.84) (22,797.90) ** .00 Budgeted 22,797.90 Remaining 0 % Used Department Totals: ----------------------------------- (22,797.90) ** (2,301.84) Monthly Total .00 Budgeted 22,797.90 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/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 2335 09/15/2017 September A/P WWTP Improvements 2,404,710.67 43,062.55 2,447,773.22 CP&Y/WALLACE GROUP, INC. 3493 AP 2462 09/25/2017 Adj Webber Retainage @ 9/30/17 (11,431.82) 2,436,341.40 GL 2464 09/30/2017 September A/P WWTP App 23 995,871.80 3,432,213.20 WEBBER-CADAGUA PARTNERS AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 1,027,502.53 3,432,213.20 ** .00 Budgeted (3,432,213.20) Remaining 0 % Used Department 20 Totals: ----------------------------------- 3,432,213.20 ** 1,027,502.53 Monthly Total .00 Budgeted (3,432,213.20) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 3,409,415.30 1,025,200.69 Monthly Total .00 Budgeted (3,409,415.30) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET SEPTEMBER 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE (257,790) NET REVENUES / EXPENDITURES (13,158) TOTAL FUND BALANCE (270,948) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 11:05 10/09/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-010-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- 519-69005-010-000 Capital Outlays 12,615.00 12,615.00- Subtotal: 12,615.00 12,615.00- Program number: 13,157.95 13,157.95- Department number: Water 13,157.95 13,157.95- Expenditures Subtotal ----------- 13,157.95 13,157.95- Fund number: 519 2016 Rev Bond Const-SWIFT 13,157.95 13,157.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/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-010-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-010-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 12,615.00 .00 12,615.00 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 12,615.00 ** .00 Budgeted (12,615.00) Remaining 0 % Used Department 10 Totals: ----------------------------------- 13,157.95 ** .00 Monthly Total .00 Budgeted (13,157.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 13,157.95 .00 Monthly Total .00 Budgeted (13,157.95) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 426,579 ACCOUNTS RECEIVABLE - TOTAL ASSETS 426,579 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 230,817 TOTAL FUND BALANCE 426,579 TOTAL LIABILITIES AND FUND BALANCE 426,579 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 11:05 10/09/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/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- 352.81- 2,351.64- 783.880 2,051.64 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 4,083.00- 48,047.45- 74.010 16,872.55- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 10,278.00- 180,417.25- 146.096 56,925.25 Subtotal: 188,712.00- 188,712.00- 14,713.81- 230,816.34- 122.311 42,104.34 Program number: 188,712.00- 188,712.00- 14,713.81- 230,816.34- 122.311 42,104.34 Department number: 188,712.00- 188,712.00- 14,713.81- 230,816.34- 122.311 42,104.34 Revenues Subtotal ----------- 188,712.00- 188,712.00- 14,713.81- 230,816.34- 122.311 42,104.34 Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 14,713.81- 230,816.34- 122.311 42,104.34 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/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 2460 09/30/2017 Bank Interest September (1,998.83) (352.81) (2,351.64) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (352.81) (2,351.64) ** (300.00) Budgeted 2,051.64 Remaining 784 % Used Account: 528-49142-000-000 Interfund transfer in-Water 2295 09/08/2017 Texpool Transfers (43,964.45) (4,083.00) (48,047.45) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (48,047.45) ** (64,920.00) Budgeted (16,872.55) Remaining 74 % Used Account: 528-49143-000-000 Interfund transfer in-WW 2295 09/08/2017 Texpool Transfers (170,139.25) (10,278.00) (180,417.25) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (180,417.25) ** (123,492.00) Budgeted 56,925.25 Remaining 146 % Used Department Totals: ----------------------------------- (230,816.34) ** (14,713.81) Monthly Total (188,712.00) Budgeted 42,104.34 Remaining 122 % Used Fund 528 Totals: ----------------------------------- (230,816.34) (14,713.81) Monthly Total (188,712.00) Budgeted 42,104.34 Remaining 122 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 27,768 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 10,120 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 42,461 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,120 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 10,120 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 6,310 TOTAL FUND BALANCE 32,341 TOTAL LIABILITIES AND FUND BALANCE 42,461 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 11:05 10/09/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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- 1,129.83- 674,011.79- 100.100 675.79 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 229.97- 1,932.25- 55.191 1,568.75- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 248.68- 2,294.37- 114.719 294.37 Subtotal: 678,837.00- 678,837.00- 1,608.48- 678,238.41- 99.912 598.59- 533-49010-000-000 Interest Income 140.00- 140.00- 22.46- 3,557.84- 2,541.314 3,417.84 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 120,492.00- 100.000 Subtotal: 337,386.00- 337,386.00- 22.46- 340,803.84- 101.013 3,417.84 Program number: 1,016,223.00- 1,016,223.00- 1,630.94- 1,019,042.25- 100.277 2,819.25 Department number: Revenues 1,016,223.00- 1,016,223.00- 1,630.94- 1,019,042.25- 100.277 2,819.25 Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 1,630.94- 1,019,042.25- 100.277 2,819.25 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 11:05 10/09/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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,950.00 76.471 600.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 300,782.50 100.066 199.50- 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 100.000 Subtotal: 1,013,133.00 1,013,133.00 1,012,732.50 99.960 400.50 Program number: 1,013,133.00 1,013,133.00 1,012,732.50 99.960 400.50 Department number: Administration 1,013,133.00 1,013,133.00 1,012,732.50 99.960 400.50 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 1,012,732.50 99.960 400.50 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 1,630.94- 6,309.75- 204.199 3,219.75 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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 2447 09/01/2017 Property Taxes (672,881.96) (346.05) (673,228.01) GL 2448 09/05/2017 Property Taxes (128.43) (673,356.44) GL 2449 09/06/2017 Property Taxes (248.23) (673,604.67) GL 2450 09/07/2017 Property Taxes (63.35) (673,668.02) GL 2451 09/13/2017 Property Taxes (2.59) (673,670.61) GL 2452 09/14/2017 Property Taxes (74.72) (673,745.33) GL 2453 09/18/2017 Property Taxes (10.32) (673,755.65) GL 2454 09/19/2017 Property Taxes (31.14) (673,786.79) GL 2455 09/22/2017 Property Taxes (49.15) (673,835.94) GL 2455 09/22/2017 Property Taxes (26.19) (673,862.13) GL 2456 09/27/2017 Property Taxes (147.59) (674,009.72) GL 2457 09/29/2017 Property Taxes (2.07) (674,011.79) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,129.83) (674,011.79) ** (673,336.00) Budgeted 675.79 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2447 09/01/2017 Property Taxes (1,702.28) (3.49) (1,705.77) GL 2450 09/07/2017 Property Taxes (1.02) (1,706.79) GL 2451 09/13/2017 Property Taxes (14.80) (1,721.59) GL 2452 09/14/2017 Property Taxes (52.72) (1,774.31) GL 2455 09/22/2017 Property Taxes (.25) (1,774.56) GL 2456 09/27/2017 Property Taxes (157.69) (1,932.25) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (229.97) (1,932.25) ** (3,501.00) Budgeted (1,568.75) Remaining 55 % Used Account: 533-40015-000-000 Property Taxes/P & I 2447 09/01/2017 Property Taxes (2,045.69) (67.14) (2,112.83) GL 2448 09/05/2017 Property Taxes (25.07) (2,137.90) GL 2449 09/06/2017 Property Taxes (47.17) (2,185.07) GL 2450 09/07/2017 Property Taxes (5.38) (2,190.45) GL 2452 09/14/2017 Property Taxes (14.95) (2,205.40) GL 2453 09/18/2017 Property Taxes (2.07) (2,207.47) GL 2454 09/19/2017 Property Taxes (2.49) (2,209.96) GL 2455 09/22/2017 Property Taxes (4.01) (2,213.97) GL 2456 09/27/2017 Property Taxes (79.98) (2,293.95) GL 2457 09/29/2017 Property Taxes (.42) (2,294.37) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (248.68) (2,294.37) ** (2,000.00) Budgeted 294.37 Remaining 115 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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 2460 09/30/2017 Bank Interest September (3,535.38) (22.46) (3,557.84) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (22.46) (3,557.84) ** (140.00) Budgeted 3,417.84 Remaining 2.541 % Used Account: 533-49015-000-000 Lease/Rental Income (216,754.00) .00 (216,754.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (216,754.00) ** (216,754.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (120,492.00) .00 (120,492.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (120,492.00) ** (120,492.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (1,019,042.25) ** (1,630.94) Monthly Total (1,016,223.00) Budgeted 2,819.25 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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,950.00 .00 1,950.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,950.00 ** 2,550.00 Budgeted 600.00 Remaining 76 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 300,782.50 .00 300,782.50 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 300,782.50 ** 300,583.00 Budgeted (199.50) Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 .00 710,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 710,000.00 ** 710,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,012,732.50 ** .00 Monthly Total 1,013,133.00 Budgeted 400.50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (6,309.75) (1,630.94) Monthly Total (3,090.00) Budgeted 3,219.75 Remaining 204 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 16,210 ACCOUNTS RECEIVABLE - TOTAL ASSETS 16,210 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 1,113 TOTAL FUND BALANCE 16,210 TOTAL LIABILITIES AND FUND BALANCE 16,210 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 11:05 10/09/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/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- 13.52- 1,512.45- 756.225 1,312.45 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- 595,638.00- 100.000 Subtotal: 892,849.00- 892,849.00- 13.52- 597,150.45- 66.881 295,698.55- Program number: 892,849.00- 892,849.00- 13.52- 597,150.45- 66.881 295,698.55- Department number: Revenues 892,849.00- 892,849.00- 13.52- 597,150.45- 66.881 295,698.55- Revenues Subtotal ----------- 892,849.00- 892,849.00- 13.52- 597,150.45- 66.881 295,698.55- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 11:05 10/09/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00- 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 230,637.50 59.496 157,011.50 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 365,000.00 72.277 140,000.00 Subtotal: 892,649.00 892,649.00 596,037.50 66.772 296,611.50 Program number: 892,649.00 892,649.00 596,037.50 66.772 296,611.50 Department number: Administration 892,649.00 892,649.00 596,037.50 66.772 296,611.50 Expenditures Subtotal ----------- 892,649.00 892,649.00 596,037.50 66.772 296,611.50 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 13.52- 1,112.95- 556.475 912.95 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/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 2460 09/30/2017 Bank Interest September (1,498.93) (13.52) (1,512.45) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (13.52) (1,512.45) ** (200.00) Budgeted 1,312.45 Remaining 756 % 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 (595,638.00) .00 (595,638.00) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (595,638.00) ** (595,638.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (597,150.45) ** (13.52) Monthly Total (892,849.00) Budgeted (295,698.55) Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/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-70005-051-000 Rev Bond Paying Agent Fee 400.00 .00 400.00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 ** .00 Budgeted (400.00) Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 230,637.50 .00 230,637.50 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 230,637.50 ** 387,649.00 Budgeted 157,011.50 Remaining 59 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 365,000.00 .00 365,000.00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 365,000.00 ** 505,000.00 Budgeted 140,000.00 Remaining 72 % Used Department 51 Totals: ----------------------------------- 596,037.50 ** .00 Monthly Total 892,649.00 Budgeted 296,611.50 Remaining 67 % Used Fund 534 Totals: ----------------------------------- (1,112.95) (13.52) Monthly Total (200.00) Budgeted 912.95 Remaining 556 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK #NAME? INVESTMENTS 952 ACCOUNTS RECEIVABLE - TOTAL ASSETS 952 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 952 TOTAL FUND BALANCE 952 TOTAL LIABILITIES AND FUND BALANCE 952 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 11:05 10/09/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income .90- 751.74- 751.74 535-49142-000-000 Interfund Tran In-Water Sales 240,821.65- 240,821.65 Subtotal: .90- 241,573.39- 241,573.39 Program number: .90- 241,573.39- 241,573.39 Department number: Revenues .90- 241,573.39- 241,573.39 Revenues Subtotal ----------- .90- 241,573.39- 241,573.39 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 11:05 10/09/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 200.00 200.00- 535-70040-051-000 Revenue Bond Interest Expense 50,421.65 50,421.65- 535-70045-051-000 Revenue Bond Principal Expense 190,000.00 190,000.00- Subtotal: 240,621.65 240,621.65- Program number: 240,621.65 240,621.65- Department number: Administration 240,621.65 240,621.65- Expenditures Subtotal ----------- 240,621.65 240,621.65- Fund number: 535 2016 Rev Bond I&S-SWIFT .90- 951.74- 951.74 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/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 2460 09/30/2017 Bank Interest September (750.84) (.90) (751.74) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (.90) (751.74) ** .00 Budgeted 751.74 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales (240,821.65) .00 (240,821.65) _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: .00 (240,821.65) ** .00 Budgeted 240,821.65 Remaining 0 % Used Department Totals: ----------------------------------- (241,573.39) ** (.90) Monthly Total .00 Budgeted 241,573.39 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 11:07 10/09/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/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-70005-051-000 Rev Bond Paying Agent Fee 200.00 .00 200.00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 50,421.65 .00 50,421.65 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 50,421.65 ** .00 Budgeted (50,421.65) Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense 190,000.00 .00 190,000.00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 190,000.00 ** .00 Budgeted (190,000.00) Remaining 0 % Used Department 51 Totals: ----------------------------------- 240,621.65 ** .00 Monthly Total .00 Budgeted (240,621.65) Remaining 0 % Used Fund 535 Totals: ----------------------------------- (951.74) (.90) Monthly Total .00 Budgeted 951.74 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 1,324,190.39 **** 564,646.82 Monthly Total (874,722.00) Budgeted (2,198,912.39) Remaining ########## ******* End of Report *********