Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016-09 September Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2016 122 ASSETS FIRE DEPT. CASH IN BANK 50,408 INVESTMENTS 518,865 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,935 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,572 TOTAL ASSETS 587,780 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 14,935 ACCOUNTS AND OTHER PAYABLES 38,308 TOTAL LIABILITIES 53,243 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 1,040 TOTAL FUND BALANCE 534,537 TOTAL LIABILITIES AND FUND BALANCE 587,780 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 18:01 10/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 32,546.70- 403,837.56- 99.874 508.44- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 976.09- 875,978.41- 98.429 13,984.59- 122-40011-000-000 Property Taxes/Fire-Delinquent 164.22- 18,076.34- 18,076.34 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 267.04- 7,621.19- 169.360 3,121.19 Subtotal: 1,299,559.00- 1,298,809.00- 33,954.05- 1,305,859.04- 100.543 7,050.04 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 5,200.00- 104.000 200.00 Subtotal: 5,000.00- 5,000.00- 5,200.00- 104.000 200.00 122-43400-000-000 Fire Inspections 825.00- 825.00- 1,075.00- 130.303 250.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,825.00- 10,825.00- 11,075.00- 102.309 250.00 122-49026-000-000 Proceeds from Sale of Assets 60,000.00- 60,000.00- 100.000 122-49900-000-000 Miscellaneous Income 50,000.00- 10,001.00- 11,100.00- 110.989 1,099.00 Subtotal: 50,000.00- 70,001.00- 71,100.00- 101.570 1,099.00 Program number: 1,365,384.00- 1,384,635.00- 33,954.05- 1,393,234.04- 100.621 8,599.04 Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 33,954.05- 1,393,234.04- 100.621 8,599.04 Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 33,954.05- 1,393,234.04- 100.621 8,599.04 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 18:01 10/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 56,245.68 503,369.59 99.044 4,856.41 122-50010-045-000 Overtime 48,735.00 48,735.00 3,111.11 58,951.61 120.964 10,216.61- 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 900.00 4,740.13 112.860 540.13- 122-50020-045-000 Retirement 75,571.00 75,571.00 7,678.88 71,887.54 95.126 3,683.46 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 7,571.06 56,876.29 86.773 8,669.71 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 569.15 5,016.47 102.691 131.47- 122-50028-045-000 Vision Insurance 859.00 859.00 90.07 967.58 112.640 108.58- 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 520.09 4,016.38 87.598 568.62 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 3,437.61 32,992.52 91.311 3,139.48 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 803.69 7,713.89 91.289 736.11 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 2,125.24 106.262 125.24- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 781.58 9,379.00 100.000 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 54.00 21.600 196.00 Subtotal: 790,155.00 790,431.00 81,708.92 778,537.77 98.495 11,893.23 122-55030-045-000 Software & Support 6,661.00 6,661.00 5,098.31 76.540 1,562.69 122-55045-045-000 Legal 2,000.00 5,000.00 6,559.50 131.190 1,559.50- 122-55080-045-000 Maintenance & Repairs 16,370.00 25,218.00 9,418.32 53,448.82 211.947 28,230.82- 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 1,367.64 14,165.81 141.658 4,165.81- 122-55160-045-000 Professional Outside Services 2,743.80 2,743.80- Subtotal: 35,031.00 46,879.00 10,785.96 82,016.24 174.953 35,137.24- 122-60005-045-000 Telephone 50.00 50.00 5.21 59.47 118.940 9.47- 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 150.00 6,526.80 84.698 1,179.20 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 934.37 5,658.21 76.339 1,753.79 122-60025-045-000 Water 1,200.00 1,200.00 201.10 2,027.05 168.921 827.05- 122-60026-045-000 Cable 1,920.00 1,920.00 219.51 1,920.14 100.007 .14- 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 100.000 122-60035-045-000 Postage 50.00 50.00 46.47 92.940 3.53 122-60055-045-000 Insurance 14,077.00 18,451.00 391.50 9,071.74 49.167 9,379.26 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 172.05 49.157 177.95 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 15,456.59 99.195 125.41 122-60080-045-000 Schools & Training 7,880.00 6,880.00 175.00 3,513.39 51.067 3,366.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 2,081.00 1,147.34 55.134 933.66 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 6,804.00 144.766 2,104.00- 122-60125-045-000 Advertising 500.00 4,700.00 4,200.00 89.362 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 245.35 3,670.60 48.941 3,829.40 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 2,355.34 73.974 828.66 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 18:01 10/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 12.74 850.75 84.990 150.25 Subtotal: 292,019.00 298,646.00 2,334.78 278,218.23 93.160 20,427.77 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 523.86 4,622.59 30.569 10,499.41 122-65010-045-000 Uniforms 3,140.00 3,640.00 75.00- 9,126.19 250.720 5,486.19- 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 7,110.00 11,675.93 129.733 2,675.93- 122-65030-045-000 Chemicals 600.00 600.00 1,191.00 198.500 591.00- 122-65035-045-000 Small Tools 2,000.00 2,000.00 7,918.00 9,780.37 489.019 7,780.37- 122-65055-045-000 Hardware 750.00 750.00 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 327.54 65.508 172.46 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 15,476.86 36,919.04 114.977 4,809.04- 122-69050-045-000 Radios 8,000.00 8,000.00 7,933.89 99.174 66.11 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 216,502.49 99.969 66.51 Program number: 1,365,384.00 1,384,635.00 110,306.52 1,392,193.77 100.546 7,558.77- Department number: Fire 1,365,384.00 1,384,635.00 110,306.52 1,392,193.77 100.546 7,558.77- Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 110,306.52 1,392,193.77 100.546 7,558.77- Fund number: 122 Trophy Club MUD Fire Dept. 76,352.47 1,040.27- 1,040.27 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 2416 09/29/2016 Town/PID Fire Assessment (371,290.86) (32,546.70) (403,837.56) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (32,546.70) (403,837.56) ** (404,346.00) Budgeted (508.44) Remaining 100 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (345.54) .00 (345.54) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2421 09/06/2016 Property Taxes (875,002.32) (131.54) (875,133.86) GL 2423 09/08/2016 Property Taxes (37.38) (875,171.24) GL 2424 09/09/2016 Property Taxes (16.67) (875,187.91) GL 2425 09/12/2016 Property Taxes (32.61) (875,220.52) GL 2426 09/15/2016 Property Taxes (.43) (875,220.95) GL 2427 09/20/2016 Property Taxes (341.60) (875,562.55) GL 2428 09/21/2016 Property Taxes (67.00) (875,629.55) GL 2429 09/22/2016 Property Taxes (98.47) (875,728.02) GL 2430 09/23/2016 Property Taxes (34.45) (875,762.47) GL 2431 09/28/2016 Property Taxes (215.28) (875,977.75) GL 2432 09/29/2016 Property Taxes (.66) (875,978.41) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (976.09) (875,978.41) ** (889,963.00) Budgeted (13,984.59) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2420 09/01/2016 Property Taxes (17,912.12) (7.15) (17,919.27) GL 2422 09/07/2016 Property Taxes (157.07) (18,076.34) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (164.22) (18,076.34) ** .00 Budgeted 18,076.34 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2420 09/01/2016 Property Taxes (7,354.15) (2.00) (7,356.15) GL 2421 09/06/2016 Property Taxes (5.00) (7,361.15) GL 2422 09/07/2016 Property Taxes (156.34) (7,517.49) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2423 09/08/2016 Property Taxes (7,354.15) (2.99) (7,520.48) GL 2424 09/09/2016 Property Taxes (2.10) (7,522.58) GL 2425 09/12/2016 Property Taxes (2.60) (7,525.18) GL 2426 09/15/2016 Property Taxes (.04) (7,525.22) GL 2427 09/20/2016 Property Taxes (43.88) (7,569.10) GL 2428 09/21/2016 Property Taxes (3.79) (7,572.89) GL 2429 09/22/2016 Property Taxes (5.24) (7,578.13) GL 2431 09/28/2016 Property Taxes (43.06) (7,621.19) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (267.04) (7,621.19) ** (4,500.00) Budgeted 3,121.19 Remaining 169 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (5,200.00) .00 (5,200.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (5,200.00) ** (5,000.00) Budgeted 200.00 Remaining 104 % Used Account: 122-43400-000-000 Fire Inspections (1,075.00) .00 (1,075.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (1,075.00) ** (825.00) Budgeted 250.00 Remaining 130 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49026-000-000 Proceeds from Sale of Assets (60,000.00) .00 (60,000.00) _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: .00 (60,000.00) ** (60,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income (11,100.00) .00 (11,100.00) . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (11,100.00) ** (10,001.00) Budgeted 1,099.00 Remaining 111 % Used Department Totals: ----------------------------------- (1,393,234.04) ** (33,954.05) Monthly Total (1,384,635.00) Budgeted 8,599.04 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 2374 09/09/2016 Fire P/R 9/9/16 447,123.91 18,700.43 465,824.34 GL 2376 09/23/2016 Fire Payroll 9/23/16 18,137.89 483,962.23 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 19,407.36 503,369.59 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 56,245.68 503,369.59 ** 508,226.00 Budgeted 4,856.41 Remaining 99 % Used Account: 122-50010-045-000 Overtime 2376 09/23/2016 Fire Payroll 9/23/16 55,840.50 3,111.11 58,951.61 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,111.11 58,951.61 ** 48,735.00 Budgeted (10,216.61) Remaining 121 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,717.53 .00 14,717.53 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,717.53 ** 15,852.00 Budgeted 1,134.47 Remaining 93 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 2374 09/09/2016 Fire P/R 9/9/16 3,840.13 450.00 4,290.13 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 450.00 4,740.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 900.00 4,740.13 ** 4,200.00 Budgeted (540.13) Remaining 113 % Used Account: 122-50020-045-000 Retirement 2374 09/09/2016 Fire P/R 9/9/16 64,208.66 2,441.56 66,650.22 GL 2376 09/23/2016 Fire Payroll 9/23/16 2,709.08 69,359.30 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 2,528.24 71,887.54 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 7,678.88 71,887.54 ** 75,571.00 Budgeted 3,683.46 Remaining 95 % Used Account: 122-50026-045-000 Medical Insurance 2374 09/09/2016 Fire P/R 9/9/16 49,305.23 2,903.56 52,208.79 GL 2376 09/23/2016 Fire Payroll 9/23/16 2,065.86 54,274.65 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 2,601.64 56,876.29 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 7,571.06 56,876.29 ** 65,546.00 Budgeted 8,669.71 Remaining 87 % Used Account: 122-50027-045-000 Dental Insurance 2374 09/09/2016 Fire P/R 9/9/16 4,447.32 192.70 4,640.02 GL 2376 09/23/2016 Fire Payroll 9/23/16 192.68 4,832.70 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 183.77 5,016.47 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 569.15 5,016.47 ** 4,885.00 Budgeted (131.47) Remaining 103 % Used Account: 122-50028-045-000 Vision Insurance 2374 09/09/2016 Fire P/R 9/9/16 877.51 35.84 913.35 GL 2376 09/23/2016 Fire Payroll 9/23/16 35.81 949.16 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 18.42 967.58 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 90.07 967.58 ** 859.00 Budgeted (108.58) Remaining 113 % Used Account: 122-50029-045-000 Life Insurance & Other 2374 09/09/2016 Fire P/R 9/9/16 3,496.29 226.52 3,722.81 GL 2376 09/23/2016 Fire Payroll 9/23/16 176.59 3,899.40 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 116.98 4,016.38 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 520.09 4,016.38 ** 4,585.00 Budgeted 568.62 Remaining 88 % Used Account: 122-50030-045-000 Social Security Taxes 2374 09/09/2016 Fire P/R 9/9/16 29,554.91 1,087.85 30,642.76 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2376 09/23/2016 Fire Payroll 9/23/16 29,554.91 1,220.43 31,863.19 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 1,129.33 32,992.52 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,437.61 32,992.52 ** 36,132.00 Budgeted 3,139.48 Remaining 91 % Used Account: 122-50035-045-000 Medicare Taxes 2374 09/09/2016 Fire P/R 9/9/16 6,910.20 254.35 7,164.55 GL 2376 09/23/2016 Fire Payroll 9/23/16 285.30 7,449.85 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 264.04 7,713.89 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 803.69 7,713.89 ** 8,450.00 Budgeted 736.11 Remaining 91 % Used Account: 122-50040-045-000 Unemployment Taxes 2,125.24 .00 2,125.24 _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .00 2,125.24 ** 2,000.00 Budgeted (125.24) Remaining 106 % Used Account: 122-50045-045-000 Workman's Compensation 1764 09/01/2016 Breakout Fire W/C from Ins 8,597.42 781.58 9,379.00 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 781.58 9,379.00 ** 9,379.00 Budgeted .00 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 54.00 .00 54.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 5,098.31 .00 5,098.31 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 5,098.31 ** 6,661.00 Budgeted 1,562.69 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal 6,559.50 .00 6,559.50 _______________ Account: 122-55045-045-000 Legal Totals: .00 6,559.50 ** 5,000.00 Budgeted (1,559.50) Remaining 131 % Used Account: 122-55080-045-000 Maintenance & Repairs 2319 09/16/2016 September A/P NFPA Air Testing & repairs 44,030.50 299.25 44,329.75 AUGUST INDUSTRIES, INC 2339 AP 2418 09/27/2016 September A/P LONE STAR SAFETY & SUP 87.00 44,416.75 LONE STAR SAFETY & SUP PC 2418 09/27/2016 September A/P BULBS.COM INC 324.75 44,741.50 BULBS.COM INC PC 2418 09/27/2016 September A/P OVERHEAD DOOR CO-FT WR 140.00 44,881.50 OVERHEAD DOOR CO-FT WR PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 4.69 44,886.19 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 232.05 45,118.24 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE FLOWER RANCH 199.00 45,317.24 THE FLOWER RANCH PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 43.97 45,361.21 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 240.00 45,601.21 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P MICHAELS KEYS 110.00 45,711.21 MICHAELS KEYS PC 2418 09/27/2016 September A/P OVERHEAD DOOR CO-FT WR 170.00 45,881.21 OVERHEAD DOOR CO-FT WR PC 2418 09/27/2016 September A/P ULINE *SHIP SUPPLIES 279.58 46,160.79 ULINE *SHIP SUPPLIES PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 198.03 46,358.82 THE HOME DEPOT #6581 PC 2382 09/29/2016 September A/P Main/repairs 1,839.00 48,197.82 GEARGRID CORPORATION 2347 AP 2382 09/29/2016 September A/P Security Film for training roo 1,425.00 49,622.82 Impact Window Systems, Inc 2352 AP 2386 09/30/2016 September A/P R19 Blown Insulation FD Attic 3,826.00 53,448.82 Garland Insulating 2380 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 9,418.32 53,448.82 ** 25,218.00 Budgeted (28,230.82) Remaining 212 % Used Account: 122-55090-045-000 Vehicle Maintenance 2319 09/16/2016 September A/P Repairs to Brush 681 12,798.17 614.32 13,412.49 WILDFIRE TRUCK & EQUIPMENT 2378 AP 2382 09/29/2016 September A/P Repairs to E-681 753.32 14,165.81 SIDDONS-MARTIN EMERGENCY GROUP 2367 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,367.64 14,165.81 ** 10,000.00 Budgeted (4,165.81) Remaining 142 % Used Account: 122-55160-045-000 Professional Outside Services 2,743.80 .00 2,743.80 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 2,743.80 ** .00 Budgeted (2,743.80) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60005-045-000 Telephone 2418 09/27/2016 September A/P ATT*BUS PHONE PMT 54.26 5.21 59.47 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 5.21 59.47 ** 50.00 Budgeted (9.47) Remaining 119 % Used Account: 122-60010-045-000 Communications/Mobiles 2374 09/09/2016 Fire P/R 9/9/16 6,376.80 75.00 6,451.80 GL 2438 09/30/2016 FD Payroll 9/18-9/30 accrual 75.00 6,526.80 GL _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 150.00 6,526.80 ** 7,706.00 Budgeted 1,179.20 Remaining 85 % Used Account: 122-60020-045-000 Electricity/Gas 2319 09/16/2016 September A/P Electricity 8/9-9/9 4,723.84 1,126.82 5,850.66 HUDSON ENERGY SERVICES, LLC 2350 AP 2382 09/29/2016 September A/P Gas 8/16-9/19 71.46 5,922.12 ATMOS ENERGY 2338 AP 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (934.37) 4,987.75 AR 2437 09/30/2016 Sept A/P Electricity 9/9-9/30/16 670.46 5,658.21 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 934.37 5,658.21 ** 7,412.00 Budgeted 1,753.79 Remaining 76 % Used Account: 122-60025-045-000 Water 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: 1,825.95 (201.09) 1,624.86 AR 2437 09/30/2016 Sept A/P September water 402.19 2,027.05 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 122-60025-045-000 Water Totals: 201.10 2,027.05 ** 1,200.00 Budgeted (827.05) Remaining 169 % Used Account: 122-60026-045-000 Cable 2418 09/27/2016 September A/P ATT*BILL PAYMENT 1,700.63 139.78 1,840.41 ATT*BILL PAYMENT PC 2418 09/27/2016 September A/P ATT*BILL PAYMENT 219.51 2,059.92 ATT*BILL PAYMENT PC 2414 09/29/2016 Firefighter Assoc/Cable (139.78) 1,920.14 GL _______________ Account: 122-60026-045-000 Cable Totals: 219.51 1,920.14 ** 1,920.00 Budgeted (.14) Remaining 100 % Used Account: 122-60030-045-000 Rent And/Or Usage . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 214,379.00 .00 214,379.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 46.47 .00 46.47 _______________ Account: 122-60035-045-000 Postage Totals: .00 46.47 ** 50.00 Budgeted 3.53 Remaining 93 % Used Account: 122-60055-045-000 Insurance 143 09/01/2016 Prepaid Insurance, W/C Sep 8,680.24 1,173.08 9,853.32 GL 1764 09/01/2016 Breakout Fire W/C from Ins (781.58) 9,071.74 GL _______________ Account: 122-60055-045-000 Insurance Totals: 391.50 9,071.74 ** 18,451.00 Budgeted 9,379.26 Remaining 49 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 172.05 .00 172.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used Account: 122-60070-045-000 Dues & Memberships 15,456.59 .00 15,456.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 2418 09/27/2016 September A/P BT TIX18THANNUALTE 3,338.39 175.00 3,513.39 BT TIX18THANNUALTE PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 175.00 3,513.39 ** 6,880.00 Budgeted 3,366.61 Remaining 51 % Used Account: 122-60096-045-000 Emergency Management . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 1,147.34 .00 1,147.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,147.34 ** 2,081.00 Budgeted 933.66 Remaining 55 % Used Account: 122-60110-045-000 Physicals/Testing 6,804.00 .00 6,804.00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 6,804.00 ** 4,700.00 Budgeted (2,104.00) Remaining 145 % Used Account: 122-60125-045-000 Advertising 4,200.00 .00 4,200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 4,200.00 ** 4,700.00 Budgeted 500.00 Remaining 89 % Used Account: 122-60160-045-000 Programs & Special Projects 2418 09/27/2016 September A/P THE HOME DEPOT #6581 3,425.25 61.99 3,487.24 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P HOBBY-LOBBY #256 65.41 3,552.65 HOBBY-LOBBY #256 PC 2418 09/27/2016 September A/P NFPA NATL FIRE PROTECT 117.95 3,670.60 NFPA NATL FIRE PROTECT PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 245.35 3,670.60 ** 7,500.00 Budgeted 3,829.40 Remaining 49 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,355.34 .00 2,355.34 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 2,355.34 ** 3,184.00 Budgeted 828.66 Remaining 74 % Used Account: 122-60245-045-000 Miscellaneous Expense 2418 09/27/2016 September A/P WAL-MART #5247 838.01 12.74 850.75 WAL-MART #5247 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 12.74 850.75 ** 1,001.00 Budgeted 150.25 Remaining 85 % Used Account: 122-65005-045-000 Fuel & Lube 2410 09/30/2016 September A/P Fuel-September 4,098.73 523.86 4,622.59 US Bank Voyager Fleet Systems 2408 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 523.86 4,622.59 ** 15,122.00 Budgeted 10,499.41 Remaining 31 % Used Account: 122-65010-045-000 Uniforms 2415 09/29/2016 Nushoe Inc/Return credit 9,201.19 (75.00) 9,126.19 GL _______________ Account: 122-65010-045-000 Uniforms Totals: (75.00) 9,126.19 ** 3,640.00 Budgeted (5,486.19) Remaining 251 % Used Account: 122-65015-045-000 Protective Clothing 2410 09/30/2016 September A/P PPE-fire 4,565.93 7,110.00 11,675.93 CASCO INDUSTRIES INC 2384 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 7,110.00 11,675.93 ** 9,000.00 Budgeted (2,675.93) Remaining 130 % Used Account: 122-65030-045-000 Chemicals 1,191.00 .00 1,191.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 1,191.00 ** 600.00 Budgeted (591.00) Remaining 199 % Used Account: 122-65035-045-000 Small Tools 2382 09/29/2016 September A/P Thermal imager for E-681 1,862.37 7,918.00 9,780.37 METRO FIRE APPARATUS 2359 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65035-045-000 Small Tools Totals: 7,918.00 9,780.37 ** 2,000.00 Budgeted (7,780.37) Remaining 489 % Used Account: 122-65055-045-000 Hardware 195.42 .00 195.42 _______________ Account: 122-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies 327.54 .00 327.54 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 327.54 ** 500.00 Budgeted 172.46 Remaining 66 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios 7,933.89 .00 7,933.89 _______________ Account: 122-69050-045-000 Radios Totals: .00 7,933.89 ** 8,000.00 Budgeted 66.11 Remaining 99 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 1,392,193.77 ** 110,306.52 Monthly Total 1,384,635.00 Budgeted (7,558.77) Remaining 101 % Used Fund 122 Totals: ----------------------------------- (1,040.27) 76,352.47 Monthly Total .00 Budgeted 1,040.27 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2016 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 9/30/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 330,089 - - 330,089 CASH IN BANK-SAVINGS-CASH RESERVE 180,187 - - 180,187 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 712,189 - - 712,189 INVESTMENTS-TEXPOOL 1,129,585 326,020 - 1,455,605 PREPAID EXPENSES 3,486 - - 3,486 ADVALOREM PROPERTY TAXES RECEIVABLE 1,743 - - 1,743 UTILITY AND OTHER ACCOUNTS RECEIVABLE 852,355 - - 852,355 TOTAL ASSETS 3,245,393 326,020 - 3,571,413 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,743 - - 1,743 ACCOUNTS AND OTHER PAYABLES 898,113 - - 898,113 CUSTOMER DEPOSITS 321,355 - - 321,355 - TOTAL LIABILITIES 1,221,211 - - 1,221,211 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 13,311 13,311 ASSIGNED FUND BALANCE 202,390 - 202,390 UNASSIGNED FUND BALANCE 2,889,665 - 8,032 2,897,697 COMMITTED FUND BALANCE 40,000 - - 40,000 NET REVENUES / EXPENDITURES (1,121,184) - (8,032) (1,129,216) - TOTAL FUND BALANCE 2,024,182 326,020 - 2,350,202 - TOTAL LIABILITIES AND FUND BALANCE 3,245,393 326,020 - 3,571,413 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 63.80- 57,250.32- 98.400 930.68- 135-40002-000-000 Property Taxes/Delinquent 14.92- 2,192.43- 2,192.43 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 20.92- 745.90- 114.754 95.90 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 146,125.00- Subtotal: 204,956.00- 204,956.00- 99.64- 60,188.65- 29.367 144,767.35- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 476,048.39- 4,130,792.18- 81.311 949,451.82- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 237,081.69- 2,321,618.27- 96.182 92,157.73- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 12,816.88- 101,583.85- 111.649 10,598.85 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 875.00- 12,850.00- 142.778 3,850.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 2,600.00- 130.000 600.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 300.00- 7,650.00- 139.091 2,150.00 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 5,489.25- 45,510.95- 74.207 15,819.05- Subtotal: 7,662,835.00- 7,662,835.00- 732,711.21- 6,622,605.25- 86.425 1,040,229.75- 135-48005-000-000 Utility Fees 69,000.00- 55,200.00- 55,200.00- 100.000 Subtotal: 69,000.00- 55,200.00- 55,200.00- 100.000 135-49010-000-000 Interest Income 6,000.00- 10,000.00- 1,070.46- 12,652.42- 126.524 2,652.42 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 30,935.00- 30,935.00- 100.000 135-49035-000-000 Prior Year Reserves 8,020.00- 548,668.00- 548,668.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 686.00- 51,653.72- 327.378 35,875.72 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 35.27- 28,818.16- 45.563 34,430.84- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 44.40- 222.000 24.40 Subtotal: 110,993.00- 686,576.00- 3,285.63- 150,064.42- 21.857 536,511.58- Program number: 8,047,784.00- 8,609,567.00- 736,096.48- 6,888,058.32- 80.005 1,721,508.68- Department number: Revenues 8,047,784.00- 8,609,567.00- 736,096.48- 6,888,058.32- 80.005 1,721,508.68- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 736,096.48- 6,888,058.32- 80.005 1,721,508.68- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 260,062.00 25,676.35 219,076.96 84.240 40,985.04 135-50010-010-000 Overtime 19,500.00 19,500.00 1,484.36 13,385.45 68.643 6,114.55 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 3,600.00 225.00 2,400.00 66.667 1,200.00 135-50020-010-000 Retirement 25,558.00 25,018.00 2,390.77 20,865.68 83.403 4,152.32 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 4,724.74 38,990.20 75.859 12,407.80 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 360.18 2,944.12 73.621 1,054.88 135-50028-010-000 Vision Insurance 910.00 910.00 80.75 661.85 72.731 248.15 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 200.95 2,361.42 84.246 441.58 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,679.58 14,626.77 80.606 3,519.23 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 392.80 3,420.75 80.621 822.25 135-50040-010-000 Unemployment Taxes 1,242.00 1,026.00 859.06 83.729 166.94 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.34 12,437.67 84.300 2,316.33 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 112.04 37.347 187.96 Subtotal: 417,429.00 410,004.00 38,444.82 335,323.42 81.785 74,680.58 135-55005-010-000 Engineering 5,000.00 109,400.00 7,632.66 109,669.74 100.247 269.74- 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 2,604.40 79,630.54 80.031 19,869.46 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 1,750.59 6,220.28 77.754 1,779.72 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 2,892.77 82.651 607.23 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 579.78 4,829.22 87.804 670.78 Subtotal: 107,000.00 225,900.00 12,567.43 203,242.55 89.970 22,657.45 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.75 4,716.60 87.344 683.40 135-60020-010-000 Electricity 166,823.00 166,823.00 25,039.79 144,530.37 86.637 22,292.63 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 716.00 143.200 216.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 11.00 2.200 489.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 1,545.00 26.763 4,228.00 135-60090-010-000 Safety Program 400.00 400.00 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 87.09 6.221 1,312.91 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 378.54 25.236 1,121.46 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 17,788.20 36.100 31,486.80 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 255,286.46 1,878,737.23 63.713 1,070,004.77 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 182.40 2,643.03 75.515 856.97 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 280,855.40 2,051,402.03 64.373 1,135,360.97 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 827.13 12,487.83 34.740 23,459.17 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 163.66 2,170.39 47.100 2,437.61 135-65030-010-000 Chemicals 12,000.00 13,000.00 787.33 13,070.00 100.538 70.00- 135-65035-010-000 Small Tools 1,200.00 1,200.00 158.63 868.02 72.335 331.98 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 275.00 718.49 71.849 281.51 135-65050-010-000 Meter Expense 115,000.00 115,000.00 4,330.20- 93,318.72 81.147 21,681.28 135-65053-010-000 Meter Change Out Program 50,000.00 77,325.00 77,325.00 100.000 Subtotal: 219,755.00 248,080.00 2,118.45- 199,958.45 80.602 48,121.55 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 36,059.40 1,516,862.81 378.979 1,116,612.81- 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,177.54 97.398 31.46 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 126,958.00 126,958.00 126,957.75 100.000 .25 Subtotal: 534,887.00 734,137.00 36,059.40 1,850,698.44 252.092 1,116,561.44- Program number: 4,465,834.00 4,804,884.00 365,808.60 4,640,624.89 96.581 164,259.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 160.00 1,725.44 34.509 3,274.56 Subtotal: 5,000.00 5,000.00 160.00 1,725.44 34.509 3,274.56 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 160.00 1,725.44 17.254 8,274.56 Department number: Water 4,475,834.00 4,814,884.00 365,968.60 4,642,350.33 96.417 172,533.67 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 43,416.36 369,461.64 105.059 17,790.64- 135-50010-020-000 Overtime 19,500.00 29,500.00 2,932.31 35,175.16 119.238 5,675.16- 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 736.00 7,611.00 105.708 411.00- 135-50020-020-000 Retirement 33,652.00 33,652.00 4,105.18 36,694.16 109.040 3,042.16- 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 8,286.11 66,678.67 101.045 689.67- 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 521.20 4,119.07 98.448 64.93 135-50028-020-000 Vision Insurance 972.00 972.00 116.93 929.93 95.672 42.07 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 354.95 4,115.69 112.604 460.69- 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 2,607.34 23,597.14 95.671 1,067.86 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 609.79 5,518.66 95.677 249.34 135-50040-020-000 Unemployment Taxes 1,449.00 1,204.00 1,203.57 99.964 .43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.42 7,002.66 75.160 2,314.34 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 48.00 722.35 111.131 72.35- Subtotal: 535,097.00 544,852.00 64,510.59 569,193.15 104.467 24,341.15- 135-55070-020-000 Independent Labor 50,000.00 50,000.00 1,193.76 7,109.21 14.218 42,890.79 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 2,820.34 105,640.75 127.125 22,540.75- 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 189.99 7,165.14 95.535 334.86 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 738.62 147.724 238.62- 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 6,084.00 41,800.91 76.002 13,199.09 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,934.00 37,393.40 106.838 2,393.40- Subtotal: 218,100.00 231,100.00 12,222.09 199,848.03 86.477 31,251.97 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 411.68 5,887.78 109.033 487.78- 135-60020-020-000 Electricity 161,582.00 161,582.00 12,670.34 123,849.76 76.648 37,732.24 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 100.000 135-60080-020-000 Schools & Training 3,771.00 3,771.00 3,361.00 89.128 410.00 135-60090-020-000 Safety Program 550.00 550.00 340.67 61.940 209.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 8.12 965.13 60.321 634.87 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 8,638.50 95.983 361.50 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 3,038.50 18,527.24 49.871 18,622.76 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 423.24 142.505 126.24- 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 119,706.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 444,837.52 100.001 6.52- 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 123,336.00 100.000 Subtotal: 908,423.00 908,423.00 16,128.64 850,172.84 93.588 58,250.16 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 572.25 10,001.23 31.233 22,019.77 135-65010-020-000 Uniforms 4,241.00 4,241.00 1,192.48 4,141.65 97.657 99.35 135-65030-020-000 Chemicals 27,000.00 27,000.00 28,882.09 106.971 1,882.09- 135-65035-020-000 Small Tools 2,000.00 2,000.00 919.81 1,787.22 89.361 212.78 135-65040-020-000 Safety Equipment 750.00 750.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 2,577.52 17,168.88 132.068 4,168.88- Subtotal: 79,012.00 79,012.00 5,262.06 62,557.66 79.175 16,454.34 135-69005-020-000 Capital Outlays 150,000.00 356,000.00 6,556.00 276,003.28 77.529 79,996.72 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,276.80 99.985 3.20 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 100.000 Subtotal: 171,477.00 377,477.00 6,556.00 297,477.08 78.807 79,999.92 Program number: 1,912,109.00 2,140,864.00 104,679.38 1,979,248.76 92.451 161,615.24 Department number: Wastewater 1,912,109.00 2,140,864.00 104,679.38 1,979,248.76 92.451 161,615.24 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 1,300.00 9,100.00 72.800 3,400.00 135-50030-026-000 Social Security Taxes 775.00 775.00 80.60 564.20 72.800 210.80 135-50035-026-000 Medicare Taxes 181.00 181.00 18.85 131.95 72.901 49.05 135-50040-026-000 Unemployment Taxes 230.00 12.00 1.50 12.500 10.50 135-50045-026-000 Workman's Compensation 37.00 50.00 3.11 50.00 100.000 Subtotal: 13,723.00 13,518.00 1,402.56 9,847.65 72.848 3,670.35 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 473.95 39.496 726.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,875.00 46.875 2,125.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 3,313.67 66.273 1,686.33 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 259.88 12.994 1,740.12 Subtotal: 12,850.00 12,850.00 5,933.48 46.175 6,916.52 Program number: 26,573.00 26,368.00 1,402.56 15,781.13 59.850 10,586.87 Department number: Board of Directors 26,573.00 26,368.00 1,402.56 15,781.13 59.850 10,586.87 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 493,633.00 48,900.39 484,727.66 98.196 8,905.34 135-50010-030-000 Overtime 1,000.00 500.00 325.03 901.11 180.222 401.11- 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,652.00 4,029.19 42,642.32 97.687 1,009.68 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,073.63 61,243.00 89.804 6,953.00 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 361.16 4,207.30 87.524 599.70 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 80.99 975.33 87.552 138.67 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 361.09 4,677.52 86.126 753.48 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 2,757.22 28,226.84 90.642 2,914.16 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 644.85 6,601.44 85.979 1,076.56 135-50040-030-000 Unemployment Taxes 1,449.00 1,197.00 115.25 1,349.10 112.707 152.10- 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.88 2,066.67 132.990 512.67- 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 147.45 29.490 352.55 135-50070-030-000 Employee Relations 5,000.00 4,500.00 19.40 3,420.57 76.013 1,079.43 Subtotal: 662,006.00 667,726.00 62,816.08 645,008.81 96.598 22,717.19 135-55005-030-000 Engineering 4,365.00 4,365.00 4,365.00- 135-55030-030-000 Software & Support 78,483.00 81,097.00 4,559.59 47,871.00 59.029 33,226.00 135-55070-030-000 Independent Labor 12,000.00 12,000.00 37.08 1,325.71 11.048 10,674.29 135-55080-030-000 Maintenance & Repairs 29,500.00 7,000.00 6,284.35 89.776 715.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 168.06 6,889.98 98.428 110.02 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 6,173.25 60.970 3,951.75 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 2,570.38 69,683.26 96.016 2,891.74 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 597.90 8,515.51 103.848 315.51- Subtotal: 206,583.00 198,197.00 12,882.76 151,108.06 76.241 47,088.94 135-60005-030-000 Telephone 16,349.00 16,349.00 1,101.41 13,723.34 83.940 2,625.66 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 187.99 4,041.28 97.380 108.72 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 5,287.80 49.107 5,480.20 135-60025-030-000 Water 1,500.00 1,500.00 142.54 934.00 62.267 566.00 135-60035-030-000 Postage 28,932.00 28,932.00 1,742.66 27,202.87 94.023 1,729.13 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 4,323.18 51,500.31 92.693 4,059.69 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 436.24 3,458.86 98.825 41.14 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 33,573.00 63.589 19,224.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 260.00 16.250 1,340.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 190.00 5,656.25 94.271 343.75 135-60075-030-000 Meetings 400.00 400.00 163.36 40.840 236.64 135-60079-030-000 Public Education 5,000.00 5,000.00 4,230.34 84.607 769.66 135-60080-030-000 Schools & Training 9,935.00 9,935.00 3,382.00 34.041 6,553.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 174.91 3,561.52 65.954 1,838.48 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 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 400.00 3,610.41 48.139 3,889.59 135-60125-030-000 Advertising 7,500.00 7,500.00 368.50 1,398.86 18.651 6,101.14 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 144.00 5,446.48 31.121 12,054.52 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 238,442.00 11,967.43 168,087.06 70.494 70,354.94 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 13,594.00 7,238.41 53.247 6,355.59 135-65085-030-000 Office Supplies 9,000.00 9,000.00 384.38 5,592.88 62.143 3,407.12 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 297.29 1,301.92 32.524 2,701.08 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 218.91 3,631.79 72.636 1,368.21 135-65105-030-000 Printing 4,800.00 4,800.00 3,187.99 66.416 1,612.01 Subtotal: 54,252.00 38,252.00 900.58 20,975.99 54.836 17,276.01 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 24,907.03 44.477 31,092.97 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 292.26 3,582.41 77.878 1,017.59 Subtotal: 60,600.00 60,600.00 292.26 28,489.44 47.012 32,110.56 Program number: 1,210,323.00 1,203,217.00 88,859.11 1,013,669.36 84.247 189,547.64 Department number: Administration 1,210,323.00 1,203,217.00 88,859.11 1,013,669.36 84.247 189,547.64 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 18:01 10/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 150.00 316,596.79 81.992 69,533.21 135-55055-039-000 Auditing 22,750.00 24,039.00 5,000.00 29,039.38 120.801 5,000.38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 1,994.51 10,088.17 98.277 176.83 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 424,234.00 7,144.51 358,193.16 84.433 66,040.84 Program number: 422,945.00 424,234.00 7,144.51 358,193.16 84.433 66,040.84 Department number: Non Departmental 422,945.00 424,234.00 7,144.51 358,193.16 84.433 66,040.84 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 568,054.16 8,009,242.74 93.027 600,324.26 Fund number: 135 MUD 1 General Fund 168,042.32- 1,121,184.42 1,121,184.42- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 18:01 10/13/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 18:01 10/13/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 18:01 10/13/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 2421 09/06/2016 Property Taxes (57,186.52) (8.60) (57,195.12) GL 2423 09/08/2016 Property Taxes (2.44) (57,197.56) GL 2424 09/09/2016 Property Taxes (1.09) (57,198.65) GL 2425 09/12/2016 Property Taxes (2.13) (57,200.78) GL 2426 09/15/2016 Property Taxes (.03) (57,200.81) GL 2427 09/20/2016 Property Taxes (22.33) (57,223.14) GL 2428 09/21/2016 Property Taxes (4.38) (57,227.52) GL 2429 09/22/2016 Property Taxes (6.44) (57,233.96) GL 2430 09/23/2016 Property Taxes (2.25) (57,236.21) GL 2431 09/28/2016 Property Taxes (14.07) (57,250.28) GL 2432 09/29/2016 Property Taxes (.04) (57,250.32) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (63.80) (57,250.32) ** (58,181.00) Budgeted (930.68) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2420 09/01/2016 Property Taxes (2,177.51) (1.37) (2,178.88) GL 2422 09/07/2016 Property Taxes (13.55) (2,192.43) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (14.92) (2,192.43) ** .00 Budgeted 2,192.43 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2420 09/01/2016 Property Taxes (724.98) (.39) (725.37) GL 2421 09/06/2016 Property Taxes (.32) (725.69) GL 2422 09/07/2016 Property Taxes (13.44) (739.13) GL 2423 09/08/2016 Property Taxes (.20) (739.33) GL 2424 09/09/2016 Property Taxes (.14) (739.47) GL 2425 09/12/2016 Property Taxes (.17) (739.64) GL 2427 09/20/2016 Property Taxes (2.86) (742.50) GL 2428 09/21/2016 Property Taxes (.25) (742.75) GL 2429 09/22/2016 Property Taxes (.34) (743.09) GL 2431 09/28/2016 Property Taxes (2.81) (745.90) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.92) (745.90) ** (650.00) Budgeted 95.90 Remaining 115 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 2393 09/13/2016 UB 9/13/16 adj UB20160913-20160913 User: (3,654,743.79) 30.04 (3,654,713.75) UB 2404 09/30/2016 UB 9/30/16 Billing Sept UB20160930-20160930 User: (476,078.43) (4,130,792.18) UB _______________ Account: 135-47000-000-000 Water Totals: (476,048.39) (4,130,792.18) ** (5,080,244.00) Budgeted (949,451.82) Remaining 81 % Used Account: 135-47005-000-000 Sewer 2393 09/13/2016 UB 9/13/16 adj UB20160913-20160913 User: (2,084,536.58) 28.58 (2,084,508.00) UB 2404 09/30/2016 UB 9/30/16 Billing Sept UB20160930-20160930 User: (237,110.27) (2,321,618.27) UB _______________ Account: 135-47005-000-000 Sewer Totals: (237,081.69) (2,321,618.27) ** (2,413,776.00) Budgeted (92,157.73) Remaining 96 % Used Account: 135-47025-000-000 Penalties 2394 09/20/2016 UB 9/20/16 Adj penalty UB20160920-20160920 User: (88,766.97) 55.96 (88,711.01) UB 2344 09/21/2016 09/21/2016 Penalties UB UB20160921-20160921 User: (13,445.69) (102,156.70) UB 2395 09/29/2016 UB 9/29/16 Penalty adj UB20160929-20160929 User: 572.85 (101,583.85) UB _______________ Account: 135-47025-000-000 Penalties Totals: (12,816.88) (101,583.85) ** (90,985.00) Budgeted 10,598.85 Remaining 112 % Used Account: 135-47030-000-000 Service Charges 2237 09/07/2016 UB 09/07/16 Disconnect Fees UB20160907-20160907 User: (11,975.00) (850.00) (12,825.00) UB 2391 09/13/2016 UB 9/13/16 NSF Check Fee UB20160913-20160913 User: (25.00) (12,850.00) UB 2405 09/26/2016 UB 9/26/16 NSF Check fee UB20160926-20160926 User: (25.00) (12,875.00) UB 2395 09/29/2016 UB 9/29/16 Penalty adj UB20160929-20160929 User: 25.00 (12,850.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (875.00) (12,850.00) ** (9,000.00) Budgeted 3,850.00 Remaining 143 % Used Account: 135-47035-000-000 Plumbing Inspections 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (2,500.00) (100.00) (2,600.00) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (2,600.00) ** (2,000.00) Budgeted 600.00 Remaining 130 % Used Account: 135-47045-000-000 Sewer Inspections 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (7,350.00) (300.00) (7,650.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (7,650.00) ** (5,500.00) Budgeted 2,150.00 Remaining 139 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2404 09/30/2016 UB 9/30/16 Billing Sept UB20160930-20160930 User: (40,021.70) (5,489.25) (45,510.95) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,489.25) (45,510.95) ** (61,330.00) Budgeted (15,819.05) Remaining 74 % Used Account: 135-48005-000-000 Utility Fees (55,200.00) .00 (55,200.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (55,200.00) ** (55,200.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 2434 09/30/2016 Sept Bank Interest (11,581.96) (113.20) (11,695.16) GL 2434 09/30/2016 Sept Bank Interest (146.31) (11,841.47) GL 2434 09/30/2016 Sept Bank Interest (420.19) (12,261.66) GL 2435 09/30/2016 Rev Bank Int/Prosp savings acc 113.20 (12,148.46) GL 2435 09/30/2016 Rev Bank Int/Prosp savings acc (113.20) (12,261.66) GL 2435 09/30/2016 Rev Bank Int/Prosp savings acc (390.76) (12,652.42) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,070.46) (12,652.42) ** (10,000.00) Budgeted 2,652.42 Remaining 127 % Used Account: 135-49016-000-000 Cell Tower Revenue 2413 09/13/2016 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 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 Account: 135-49026-000-000 Proceeds from Sale of Assets (30,935.00) .00 (30,935.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (30,935.00) ** (30,935.00) Budgeted .00 Remaining 100 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (548,668.00) Budgeted (548,668.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (50,967.72) (686.00) (51,653.72) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (51,653.72) ** (15,778.00) Budgeted 35,875.72 Remaining 327 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 2389 09/07/2016 UB 9/7/16 UB20160907-20160907 User: (28,782.89) (.52) (28,783.41) UB 2404 09/30/2016 UB 9/30/16 Billing Sept UB20160930-20160930 User: (34.75) (28,818.16) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (35.27) (28,818.16) ** (63,249.00) Budgeted (34,430.84) Remaining 46 % Used Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (44.40) .00 (44.40) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (44.40) ** (20.00) Budgeted 24.40 Remaining 222 % Used Department Totals: ----------------------------------- (6,888,058.32) ** (736,096.48) Monthly Total (8,609,567.00) Budgeted (1,721,508.68) Remaining 80 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 2238 09/09/2016 MUD Payroll 9/9/16 Salaries & Wages 193,400.61 8,425.45 201,826.06 PR 2336 09/23/2016 MUD P/R 9/23/16 Salaries & Wages 8,425.45 210,251.51 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 8,825.45 219,076.96 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 25,676.35 219,076.96 ** 260,062.00 Budgeted 40,985.04 Remaining 84 % Used Account: 135-50010-010-000 Overtime 2238 09/09/2016 MUD Payroll 9/9/16 Overtime 11,901.09 341.86 12,242.95 PR 2336 09/23/2016 MUD P/R 9/23/16 Overtime 734.80 12,977.75 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 407.70 13,385.45 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,484.36 13,385.45 ** 19,500.00 Budgeted 6,114.55 Remaining 69 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 2336 09/23/2016 MUD P/R 9/23/16 Certification 2,175.00 225.00 2,400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 2,400.00 ** 3,600.00 Budgeted 1,200.00 Remaining 67 % Used Account: 135-50020-010-000 Retirement 2238 09/09/2016 MUD Payroll 9/9/16 Retirement 18,474.91 765.40 19,240.31 PR 2336 09/23/2016 MUD P/R 9/23/16 Retirement 819.32 20,059.63 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 806.05 20,865.68 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,390.77 20,865.68 ** 25,018.00 Budgeted 4,152.32 Remaining 83 % Used Account: 135-50026-010-000 Medical Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Medical Insurance 34,265.46 1,580.60 35,846.06 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2336 09/23/2016 MUD P/R 9/23/16 Medical Insurance 34,265.46 1,580.55 37,426.61 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 1,563.59 38,990.20 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 4,724.74 38,990.20 ** 51,398.00 Budgeted 12,407.80 Remaining 76 % Used Account: 135-50027-010-000 Dental Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Dental Insurance 2,583.94 120.39 2,704.33 PR 2336 09/23/2016 MUD P/R 9/23/16 Dental Insurance 120.38 2,824.71 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 119.41 2,944.12 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 360.18 2,944.12 ** 3,999.00 Budgeted 1,054.88 Remaining 74 % Used Account: 135-50028-010-000 Vision Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Vision Insurance 581.10 27.01 608.11 PR 2336 09/23/2016 MUD P/R 9/23/16 Vision Insurance 26.97 635.08 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 26.77 661.85 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 80.75 661.85 ** 910.00 Budgeted 248.15 Remaining 73 % Used Account: 135-50029-010-000 Life Insurance & Other 2138 09/01/2016 Sept A/P Sept. Dental, Vision, Life & O 2,160.47 191.24 2,351.71 METLIFE GROUP BENEFITS 2242 AP 2332 09/20/2016 September A/P Café 125 adm. fees 9.71 2,361.42 BenefitMall 2340 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 200.95 2,361.42 ** 2,803.00 Budgeted 441.58 Remaining 84 % Used Account: 135-50030-010-000 Social Security Taxes 2238 09/09/2016 MUD Payroll 9/9/16 Social Security Taxes 12,947.19 540.54 13,487.73 PR 2336 09/23/2016 MUD P/R 9/23/16 Social Security Taxes 574.87 14,062.60 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 564.17 14,626.77 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,679.58 14,626.77 ** 18,146.00 Budgeted 3,519.23 Remaining 81 % Used Account: 135-50035-010-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2238 09/09/2016 MUD Payroll 9/9/16 Medicare Taxes 3,027.95 126.41 3,154.36 PR 2336 09/23/2016 MUD P/R 9/23/16 Medicare Taxes 134.46 3,288.82 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 131.93 3,420.75 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 392.80 3,420.75 ** 4,243.00 Budgeted 822.25 Remaining 81 % Used Account: 135-50040-010-000 Unemployment Taxes 859.06 .00 859.06 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 859.06 ** 1,026.00 Budgeted 166.94 Remaining 84 % Used Account: 135-50045-010-000 Workman's Compensation 143 09/01/2016 Prepaid Insurance, W/C Sep 11,208.33 1,229.34 12,437.67 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.34 12,437.67 ** 14,754.00 Budgeted 2,316.33 Remaining 84 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 112.04 .00 112.04 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 112.04 ** 300.00 Budgeted 187.96 Remaining 37 % Used Account: 135-55005-010-000 Engineering 2319 09/16/2016 September A/P Utility Mapping Trophy Club 102,037.08 1,938.75 103,975.83 CP&Y/WALLACE GROUP, INC. 2341 AP 2319 09/16/2016 September A/P TC MUD Water Study 3,950.16 107,925.99 CP&Y/WALLACE GROUP, INC. 2341 AP 2440 09/30/2016 Sept A/P Utility Mapping 1,398.75 109,324.74 CP&Y/WALLACE GROUP, INC. AP 2440 09/30/2016 Sept A/P Nitrification Action Plan 345.00 109,669.74 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-55005-010-000 Engineering Totals: 7,632.66 109,669.74 ** 109,400.00 Budgeted (269.74) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 2418 09/27/2016 September A/P THE HOME DEPOT #6581 77,026.14 41.10 77,067.24 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 89.61 77,156.85 THE HOME DEPOT #6581 PC 2382 09/29/2016 September A/P September mowing 1,500.00 78,656.85 WATTS ELLISON LLC 2376 AP 2382 09/29/2016 September A/P Metal Gaskets 36.00 78,692.85 HD SUPPLY WATERWORKS, LTD. 2349 AP 2386 09/30/2016 September A/P Meter gaskets 60.00 78,752.85 ATLAS UTILITY SUPPLY CO. 2379 AP 2410 09/30/2016 September A/P Valve Curb Markers 877.69 79,630.54 DAS MANUFACTURING INC 2388 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,604.40 79,630.54 ** 99,500.00 Budgeted 19,869.46 Remaining 80 % Used Account: 135-55090-010-000 Vehicle Maintenance 2418 09/27/2016 September A/P SQ *GLASS REPAIR GUYS, 4,469.69 230.00 4,699.69 SQ *GLASS REPAIR GUYS, PC 2418 09/27/2016 September A/P KWIK KAR LUBE & TUNE O 109.95 4,809.64 KWIK KAR LUBE & TUNE O PC 2418 09/27/2016 September A/P ROANOKE AUTO SUPPLY LT 5.71 4,815.35 ROANOKE AUTO SUPPLY LT PC 2418 09/27/2016 September A/P INLAND TRUCK PARTS # 1,404.93 6,220.28 INLAND TRUCK PARTS # PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,750.59 6,220.28 ** 8,000.00 Budgeted 1,779.72 Remaining 78 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,892.77 .00 2,892.77 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 2,892.77 ** 3,500.00 Budgeted 607.23 Remaining 83 % Used Account: 135-55135-010-000 Lab Analysis 2319 09/16/2016 September A/P Water Samples-MUD 4,249.44 275.00 4,524.44 TARRANT CTY PUBLIC HEALTH LAB 2370 AP 2410 09/30/2016 September A/P Petty cash reimbursement Septe 4.78 4,529.22 TROPHY CLUB MUD PETTY CASH 2405 AP 2411 09/30/2016 September A/P Water Samples-MUD 300.00 4,829.22 TARRANT CTY PUBLIC HEALTH LAB 2401 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 579.78 4,829.22 ** 5,500.00 Budgeted 670.78 Remaining 88 % Used Account: 135-60010-010-000 Communications/Mobiles 2437 09/30/2016 Sept A/P September cell phones 4,369.85 346.75 4,716.60 VERIZON WIRELESS AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.75 4,716.60 ** 5,400.00 Budgeted 683.40 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 2319 09/16/2016 September A/P Electricity 8/8-9/8 119,490.58 98.41 119,588.99 HUDSON ENERGY SERVICES, LLC 2350 AP 2319 09/16/2016 September A/P Electricity 7/9-9/9 10,238.90 129,827.89 HUDSON ENERGY SERVICES, LLC 2350 AP 2382 09/29/2016 September A/P Electricity 8/9-9/9 11,341.00 141,168.89 HUDSON ENERGY SERVICES, LLC 2350 AP 2437 09/30/2016 Sept A/P Electricity 9/9-9/30/16 3,361.48 144,530.37 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-010-000 Electricity Totals: 25,039.79 144,530.37 ** 166,823.00 Budgeted 22,292.63 Remaining 87 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 716.00 .00 716.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 716.00 ** 500.00 Budgeted (216.00) Remaining 143 % Used Account: 135-60070-010-000 Dues & Memberships 11.00 .00 11.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 11.00 ** 500.00 Budgeted 489.00 Remaining 2 % Used Account: 135-60080-010-000 Schools & Training 1,545.00 .00 1,545.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,545.00 ** 5,773.00 Budgeted 4,228.00 Remaining 27 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem 87.09 .00 87.09 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.09 ** 1,400.00 Budgeted 1,312.91 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-010-000 Rent/Lease Equipment 378.54 .00 378.54 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 378.54 ** 1,500.00 Budgeted 1,121.46 Remaining 25 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 17,788.20 .00 17,788.20 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 17,788.20 ** 49,275.00 Budgeted 31,486.80 Remaining 36 % Used Account: 135-60150-010-000 Wholesale Water 2410 09/30/2016 September A/P Wholesale Water- August 1,623,450.77 255,286.46 1,878,737.23 CITY OF FORT WORTH 2385 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 255,286.46 1,878,737.23 ** 2,948,742.00 Budgeted 1,070,004.77 Remaining 64 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 2418 09/27/2016 September A/P DENTON SAND & GRAVEL, 2,460.63 108.00 2,568.63 DENTON SAND & GRAVEL, PC 2418 09/27/2016 September A/P TEX-TURF 74.40 2,643.03 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 182.40 2,643.03 ** 3,500.00 Budgeted 856.97 Remaining 76 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 2410 09/30/2016 September A/P Fuel-September 11,660.70 827.13 12,487.83 US Bank Voyager Fleet Systems 2408 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 827.13 12,487.83 ** 35,947.00 Budgeted 23,459.17 Remaining 35 % Used Account: 135-65010-010-000 Uniforms 2418 09/27/2016 September A/P RON MONTGOMERY & ASSOC 2,006.73 163.66 2,170.39 RON MONTGOMERY & ASSOC PC _______________ Account: 135-65010-010-000 Uniforms Totals: 163.66 2,170.39 ** 4,608.00 Budgeted 2,437.61 Remaining 47 % Used Account: 135-65030-010-000 Chemicals 2319 09/16/2016 September A/P Nitrite Standard 12,282.67 45.74 12,328.41 HACH COMPANY 2348 AP 2382 09/29/2016 September A/P Chlorine 741.59 13,070.00 DPC INDUSTRIES, INC 2342 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 787.33 13,070.00 ** 13,000.00 Budgeted (70.00) Remaining 101 % Used Account: 135-65035-010-000 Small Tools 2418 09/27/2016 September A/P THE HOME DEPOT #6581 709.39 78.29 787.68 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P AMAZON MKTPLACE PMTS 17.71 805.39 AMAZON MKTPLACE PMTS PC 2418 09/27/2016 September A/P AMAZON.COM 62.63 868.02 AMAZON.COM PC _______________ Account: 135-65035-010-000 Small Tools Totals: 158.63 868.02 ** 1,200.00 Budgeted 331.98 Remaining 72 % Used Account: 135-65040-010-000 Safety Equipment 2418 09/27/2016 September A/P BUYERS BARRICADES INC 443.49 275.00 718.49 BUYERS BARRICADES INC PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 275.00 718.49 ** 1,000.00 Budgeted 281.51 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 2412 09/13/2016 OTD Fire Line Meter 97,648.92 (4,330.20) 93,318.72 GL _______________ Account: 135-65050-010-000 Meter Expense Totals: (4,330.20) 93,318.72 ** 115,000.00 Budgeted 21,681.28 Remaining 81 % Used Account: 135-65053-010-000 Meter Change Out Program 77,325.00 .00 77,325.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 77,325.00 ** 77,325.00 Budgeted .00 Remaining 100 % Used Account: 135-69005-010-000 Capital Outlays 2319 09/16/2016 September A/P LAS Building 1,480,803.41 4,500.00 1,485,303.41 FRYER CONSTRUCTION COMPANY 2345 AP 2410 09/30/2016 September A/P New LAS Building 31,559.40 1,516,862.81 FRYER CONSTRUCTION COMPANY 2393 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 36,059.40 1,516,862.81 ** 400,250.00 Budgeted (1,116,612.81) Remaining 379 % Used Account: 135-69008-010-000 Short Term Debt-Principal 130,700.34 .00 130,700.34 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1,177.54 .00 1,177.54 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 1,177.54 ** 1,209.00 Budgeted 31.46 Remaining 97 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 2319 09/16/2016 September A/P Water Samples-PID 1,565.44 80.00 1,645.44 TARRANT CTY PUBLIC HEALTH LAB 2371 AP 2411 09/30/2016 September A/P Water Samples-PID 80.00 1,725.44 TARRANT CTY PUBLIC HEALTH LAB 2402 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 1,725.44 ** 5,000.00 Budgeted 3,274.56 Remaining 35 % 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: ----------------------------------- 4,642,350.33 ** 365,968.60 Monthly Total 4,814,884.00 Budgeted 172,533.67 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 2238 09/09/2016 MUD Payroll 9/9/16 Salaries & Wages 326,045.28 14,517.17 340,562.45 PR 2336 09/23/2016 MUD P/R 9/23/16 Salaries & Wages 14,417.45 354,979.90 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 14,481.74 369,461.64 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 43,416.36 369,461.64 ** 351,671.00 Budgeted (17,790.64) Remaining 105 % Used Account: 135-50010-020-000 Overtime 2238 09/09/2016 MUD Payroll 9/9/16 Overtime 32,242.85 1,258.82 33,501.67 PR 2336 09/23/2016 MUD P/R 9/23/16 Overtime 1,093.62 34,595.29 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 579.87 35,175.16 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,932.31 35,175.16 ** 29,500.00 Budgeted (5,675.16) Remaining 119 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 2336 09/23/2016 MUD P/R 9/23/16 Certification 6,875.00 675.00 7,550.00 PR 2418 09/27/2016 September A/P TX DPS DL OFFICE 61.00 7,611.00 TX DPS DL OFFICE PC _______________ Account: 135-50017-020-000 Certification Totals: 736.00 7,611.00 ** 7,200.00 Budgeted (411.00) Remaining 106 % Used Account: 135-50020-020-000 Retirement 2238 09/09/2016 MUD Payroll 9/9/16 Retirement 32,588.98 1,377.25 33,966.23 PR 2336 09/23/2016 MUD P/R 9/23/16 Retirement 1,413.04 35,379.27 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 1,314.89 36,694.16 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,105.18 36,694.16 ** 33,652.00 Budgeted (3,042.16) Remaining 109 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2238 09/09/2016 MUD Payroll 9/9/16 Medical Insurance 58,392.56 2,765.99 61,158.55 PR 2336 09/23/2016 MUD P/R 9/23/16 Medical Insurance 2,765.98 63,924.53 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 2,754.14 66,678.67 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 8,286.11 66,678.67 ** 65,989.00 Budgeted (689.67) Remaining 101 % Used Account: 135-50027-020-000 Dental Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Dental Insurance 3,597.87 173.97 3,771.84 PR 2336 09/23/2016 MUD P/R 9/23/16 Dental Insurance 173.94 3,945.78 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 173.29 4,119.07 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 521.20 4,119.07 ** 4,184.00 Budgeted 64.93 Remaining 98 % Used Account: 135-50028-020-000 Vision Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Vision Insurance 813.00 39.05 852.05 PR 2336 09/23/2016 MUD P/R 9/23/16 Vision Insurance 39.00 891.05 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 38.88 929.93 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 116.93 929.93 ** 972.00 Budgeted 42.07 Remaining 96 % Used Account: 135-50029-020-000 Life Insurance & Other 2138 09/01/2016 Sept A/P Sept. Dental, Vision, Life & O 3,760.74 325.82 4,086.56 METLIFE GROUP BENEFITS 2242 AP 2332 09/20/2016 September A/P Café 125 adm. fees 29.13 4,115.69 BenefitMall 2340 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 354.95 4,115.69 ** 3,655.00 Budgeted (460.69) Remaining 113 % Used Account: 135-50030-020-000 Social Security Taxes 2238 09/09/2016 MUD Payroll 9/9/16 Social Security Taxes 20,989.80 889.41 21,879.21 PR 2336 09/23/2016 MUD P/R 9/23/16 Social Security Taxes 893.76 22,772.97 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 824.17 23,597.14 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,607.34 23,597.14 ** 24,665.00 Budgeted 1,067.86 Remaining 96 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2238 09/09/2016 MUD Payroll 9/9/16 Medicare Taxes 4,908.87 208.01 5,116.88 PR 2336 09/23/2016 MUD P/R 9/23/16 Medicare Taxes 209.01 5,325.89 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 192.77 5,518.66 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 609.79 5,518.66 ** 5,768.00 Budgeted 249.34 Remaining 96 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,203.57 ** 1,204.00 Budgeted .43 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 143 09/01/2016 Prepaid Insurance, W/C Sep 6,226.24 776.42 7,002.66 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.42 7,002.66 ** 9,317.00 Budgeted 2,314.34 Remaining 75 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations 2418 09/27/2016 September A/P MEAT U ANYWHERE TR 674.35 48.00 722.35 MEAT U ANYWHERE TR PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 48.00 722.35 ** 650.00 Budgeted (72.35) Remaining 111 % Used Account: 135-55070-020-000 Independent Labor 2272 09/09/2016 September A/P Weld and Rework Aluminum Ladde 5,915.45 520.00 6,435.45 Panya Fabricate Welding & Mach 2311 AP 2382 09/29/2016 September A/P Repair of front WWTP gate 673.76 7,109.21 Alan's Gates, Inc. 2337 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,193.76 7,109.21 ** 50,000.00 Budgeted 42,890.79 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 2418 09/27/2016 September A/P THE HOME DEPOT #6581 102,820.41 516.33 103,336.74 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 9.65 103,346.39 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 70.00 103,416.39 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 12.01 103,428.40 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P WW GRAINGER 80.54 103,508.94 WW GRAINGER PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 159.87 103,668.81 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P WW GRAINGER 679.50 104,348.31 WW GRAINGER PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 28.91 104,377.22 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 39.88 104,417.10 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 22.50 104,439.60 THE HOME DEPOT #6581 PC 2418 09/27/2016 September A/P THE HOME DEPOT #6581 21.15 104,460.75 THE HOME DEPOT #6581 PC 2382 09/29/2016 September A/P September mowing 1,180.00 105,640.75 WATTS ELLISON LLC 2376 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,820.34 105,640.75 ** 83,100.00 Budgeted (22,540.75) Remaining 127 % Used Account: 135-55090-020-000 Vehicle Maintenance 2418 09/27/2016 September A/P ROANOKE AUTO SUPPLY LT 6,975.15 179.00 7,154.15 ROANOKE AUTO SUPPLY LT PC 2418 09/27/2016 September A/P MUSTANG ELITE CAR WASH 10.99 7,165.14 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 189.99 7,165.14 ** 7,500.00 Budgeted 334.86 Remaining 96 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 738.62 .00 738.62 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 738.62 ** 500.00 Budgeted (238.62) Remaining 148 % Used Account: 135-55125-020-000 Dumpster Services 2382 09/29/2016 September A/P Sludge haul off 35,716.91 2,028.00 37,744.91 L.H. CHANEY MATERIALS, INC. 2354 AP 2411 09/30/2016 September A/P Sludge hual off 2,028.00 39,772.91 L.H. CHANEY MATERIALS, INC. 2395 AP 2411 09/30/2016 September A/P Sludge Haul off 2,028.00 41,800.91 L.H. CHANEY MATERIALS, INC. 2395 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 6,084.00 41,800.91 ** 55,000.00 Budgeted 13,199.09 Remaining 76 % Used Account: 135-55135-020-000 Lab Analysis . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2272 09/09/2016 September A/P Testing 35,459.40 246.00 35,705.40 OXIDOR LABORATORIES LLC 2310 AP 2272 09/09/2016 September A/P Testing 176.00 35,881.40 OXIDOR LABORATORIES LLC 2310 AP 2319 09/16/2016 September A/P Testing 246.00 36,127.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P Testing 246.00 36,373.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P Testing 176.00 36,549.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P Testing 221.00 36,770.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P Testing 201.00 36,971.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P testing 246.00 37,217.40 OXIDOR LABORATORIES LLC 2364 AP 2382 09/29/2016 September A/P Testing 176.00 37,393.40 OXIDOR LABORATORIES LLC 2364 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,934.00 37,393.40 ** 35,000.00 Budgeted (2,393.40) Remaining 107 % Used Account: 135-60010-020-000 Communications/Mobiles 2437 09/30/2016 Sept A/P September cell phones 5,476.10 411.68 5,887.78 VERIZON WIRELESS AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 411.68 5,887.78 ** 5,400.00 Budgeted (487.78) Remaining 109 % Used Account: 135-60020-020-000 Electricity 2319 09/16/2016 September A/P Electricity 8/8-9/8 111,179.42 61.43 111,240.85 HUDSON ENERGY SERVICES, LLC 2350 AP 2319 09/16/2016 September A/P Electricity 8/8-9/8 74.45 111,315.30 HUDSON ENERGY SERVICES, LLC 2350 AP 2319 09/16/2016 September A/P Electricity 8/9-9/9 106.68 111,421.98 HUDSON ENERGY SERVICES, LLC 2350 AP 2319 09/16/2016 September A/P Electricity 7/216-8/25 230.23 111,652.21 TRI COUNTY ELECTRIC 2374 AP 2319 09/16/2016 September A/P Electricity 7/26-8/25 320.61 111,972.82 TRI COUNTY ELECTRIC 2374 AP 2319 09/16/2016 September A/P Electricity 7/26-8/25 27.44 112,000.26 TRI COUNTY ELECTRIC 2374 AP 2332 09/20/2016 September A/P Electricity 8/9-9/9/16 346.21 112,346.47 ENGIE Resources LLC 2343 AP 2382 09/29/2016 September A/P Electricity 8/9-9/9 379.15 112,725.62 MP2 ENERGY TEXAS LLC 2360 AP 2382 09/29/2016 September A/P Electricity 8/9-9/9 10,084.57 122,810.19 HUDSON ENERGY SERVICES, LLC 2350 AP 2382 09/29/2016 September A/P Electricity 8/9-9/9 524.30 123,334.49 HUDSON ENERGY SERVICES, LLC 2350 AP 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (218.66) 123,115.83 AR 2437 09/30/2016 Sept A/P Electricity 9/8-9/30/16 46.39 123,162.22 HUDSON ENERGY SERVICES, LLC AP 2437 09/30/2016 Sept A/P Electricity 9/8-9/30/16 50.03 123,212.25 HUDSON ENERGY SERVICES, LLC AP 2437 09/30/2016 Sept A/P Electricity 9/9-9/30/16 70.25 123,282.50 HUDSON ENERGY SERVICES, LLC AP 2437 09/30/2016 Sept A/P Electricity 8/25-9/26/16 255.94 123,538.44 TRI COUNTY ELECTRIC AP 2437 09/30/2016 Sept A/P Electricity 8/25-9/26/16 28.91 123,567.35 TRI COUNTY ELECTRIC AP 2437 09/30/2016 Sept A/P Electricity 8/25-9/26/16 282.41 123,849.76 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-020-000 Electricity Totals: 12,670.34 123,849.76 ** 161,582.00 Budgeted 37,732.24 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 300.00 .00 300.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 300.00 ** 300.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-020-000 Schools & Training 3,361.00 .00 3,361.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 3,361.00 ** 3,771.00 Budgeted 410.00 Remaining 89 % Used Account: 135-60090-020-000 Safety Program 340.67 .00 340.67 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 340.67 ** 550.00 Budgeted 209.33 Remaining 62 % Used Account: 135-60100-020-000 Travel & per diem 2382 09/29/2016 September A/P Tolls for travel to lab 957.01 8.12 965.13 NTTA 2362 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 8.12 965.13 ** 1,600.00 Budgeted 634.87 Remaining 60 % Used Account: 135-60105-020-000 Rent/Lease Equipment 8,638.50 .00 8,638.50 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 8,638.50 ** 9,000.00 Budgeted 361.50 Remaining 96 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2319 09/16/2016 September A/P WWTP Permit Renewal Applicatio 15,488.74 2,635.00 18,123.74 CP&Y/WALLACE GROUP, INC. 2341 AP 2418 09/27/2016 September A/P TCEQ IND RENEWAL L 111.00 18,234.74 TCEQ IND RENEWAL L PC 2440 09/30/2016 Sept A/P WWTP Permit Renewal Applicatio 292.50 18,527.24 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 3,038.50 18,527.24 ** 37,150.00 Budgeted 18,622.76 Remaining 50 % Used Account: 135-60245-020-000 Miscellaneous Expenses 423.24 .00 423.24 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 423.24 ** 297.00 Budgeted (126.24) Remaining 143 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 .00 119,706.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 119,706.00 ** 119,706.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,837.52 .00 444,837.52 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 444,837.52 ** 444,831.00 Budgeted (6.52) Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 .00 123,336.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 123,336.00 ** 123,336.00 Budgeted .00 Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2410 09/30/2016 September A/P Fuel-September 9,428.98 572.25 10,001.23 US Bank Voyager Fleet Systems 2408 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 572.25 10,001.23 ** 32,021.00 Budgeted 22,019.77 Remaining 31 % Used Account: 135-65010-020-000 Uniforms 2319 09/16/2016 September A/P Coats-Wastewater treatment Emp 2,949.17 989.00 3,938.17 PANDA EMBROIDERY 2365 AP 2319 09/16/2016 September A/P Caps 157.50 4,095.67 PANDA EMBROIDERY 2365 AP 2418 09/27/2016 September A/P ACADEMY SPORTS #141 45.98 4,141.65 ACADEMY SPORTS #141 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 1,192.48 4,141.65 ** 4,241.00 Budgeted 99.35 Remaining 98 % Used Account: 135-65030-020-000 Chemicals 28,882.09 .00 28,882.09 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 28,882.09 ** 27,000.00 Budgeted (1,882.09) Remaining 107 % Used Account: 135-65035-020-000 Small Tools 2418 09/27/2016 September A/P USA BLUE BOOK 867.41 829.83 1,697.24 USA BLUE BOOK PC 2418 09/27/2016 September A/P BEST BUY 00001487 89.98 1,787.22 BEST BUY 00001487 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 919.81 1,787.22 ** 2,000.00 Budgeted 212.78 Remaining 89 % Used Account: 135-65040-020-000 Safety Equipment 576.59 .00 576.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used Account: 135-65045-020-000 Lab Supplies 2382 09/29/2016 September A/P Gloves-WWTP 14,591.36 162.00 14,753.36 LOU'S GLOVES INCORPORATED 2357 AP 2382 09/29/2016 September A/P NH3 537.25 15,290.61 HACH COMPANY 2348 AP 2382 09/29/2016 September A/P E Coli trays 1,878.27 17,168.88 IDEXX DISTRIBUTION, INC 2351 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,577.52 17,168.88 ** 13,000.00 Budgeted (4,168.88) Remaining 132 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-020-000 Capital Outlays 2319 09/16/2016 September A/P Wastewater Aerial Crossing 269,447.28 6,556.00 276,003.28 CP&Y/WALLACE GROUP, INC. 2341 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 6,556.00 276,003.28 ** 356,000.00 Budgeted 79,996.72 Remaining 78 % Used Account: 135-69008-020-000 Short Term Debt-Principal 21,276.80 .00 21,276.80 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 21,276.80 ** 21,280.00 Budgeted 3.20 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 197.00 .00 197.00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 197.00 ** 197.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 1,979,248.76 ** 104,679.38 Monthly Total 2,140,864.00 Budgeted 161,615.24 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 2409 09/30/2016 Accrued Payroll @ 9/30/16 7,800.00 1,300.00 9,100.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,300.00 9,100.00 ** 12,500.00 Budgeted 3,400.00 Remaining 73 % Used Account: 135-50030-026-000 Social Security Taxes 2409 09/30/2016 Accrued Payroll @ 9/30/16 483.60 80.60 564.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 80.60 564.20 ** 775.00 Budgeted 210.80 Remaining 73 % Used Account: 135-50035-026-000 Medicare Taxes 2409 09/30/2016 Accrued Payroll @ 9/30/16 113.10 18.85 131.95 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 18.85 131.95 ** 181.00 Budgeted 49.05 Remaining 73 % Used Account: 135-50040-026-000 Unemployment Taxes 1.50 .00 1.50 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 1.50 ** 12.00 Budgeted 10.50 Remaining 13 % Used Account: 135-50045-026-000 Workman's Compensation 143 09/01/2016 Prepaid Insurance, W/C Sep 46.89 3.11 50.00 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.11 50.00 ** 50.00 Budgeted .00 Remaining 100 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 473.95 .00 473.95 _______________ Account: 135-60075-026-000 Meetings Totals: .00 473.95 ** 1,200.00 Budgeted 726.05 Remaining 39 % Used Account: 135-60080-026-000 Schools & Training 1,875.00 .00 1,875.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,875.00 ** 4,000.00 Budgeted 2,125.00 Remaining 47 % Used Account: 135-60100-026-000 Travel & per diem 3,313.67 .00 3,313.67 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 3,313.67 ** 5,000.00 Budgeted 1,686.33 Remaining 66 % Used Account: 135-60245-026-000 Miscellaneous Expenses 259.88 .00 259.88 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 259.88 ** 2,000.00 Budgeted 1,740.12 Remaining 13 % Used Department 26 Totals: ----------------------------------- 15,781.13 ** 1,402.56 Monthly Total 26,368.00 Budgeted 10,586.87 Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 2238 09/09/2016 MUD Payroll 9/9/16 Salaries & Wages 435,827.27 22,932.21 458,759.48 PR 2272 09/09/2016 September A/P Temp-front desk 640.00 459,399.48 TRINITY EMPLOYMENT SOLUTIONS 2321 AP 2332 09/20/2016 September A/P Front Desk Temp 512.00 459,911.48 TRINITY EMPLOYMENT SOLUTIONS 2375 AP 2336 09/23/2016 MUD P/R 9/23/16 Salaries & Wages 11,398.98 471,310.46 PR 2382 09/29/2016 September A/P Temp Receptionist 640.00 471,950.46 TRINITY EMPLOYMENT SOLUTIONS 2375 AP 2382 09/29/2016 September A/P Temp-Receptionist 640.00 472,590.46 TRINITY EMPLOYMENT SOLUTIONS 2375 AP 2409 09/30/2016 Accrued Payroll @ 9/30/16 11,497.20 484,087.66 PR 2410 09/30/2016 September A/P Temp Receptionist/September 640.00 484,727.66 TRINITY EMPLOYMENT SOLUTIONS 2404 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 48,900.39 484,727.66 ** 493,633.00 Budgeted 8,905.34 Remaining 98 % Used Account: 135-50010-030-000 Overtime 2238 09/09/2016 MUD Payroll 9/9/16 Overtime 576.08 35.05 611.13 PR 2336 09/23/2016 MUD P/R 9/23/16 Overtime 115.35 726.48 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 174.63 901.11 PR _______________ Account: 135-50010-030-000 Overtime Totals: 325.03 901.11 ** 500.00 Budgeted (401.11) Remaining 180 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 2238 09/09/2016 MUD Payroll 9/9/16 Retirement 38,613.13 2,005.04 40,618.17 PR 2336 09/23/2016 MUD P/R 9/23/16 Retirement 1,005.21 41,623.38 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 1,018.94 42,642.32 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,029.19 42,642.32 ** 43,652.00 Budgeted 1,009.68 Remaining 98 % Used Account: 135-50026-030-000 Medical Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Medical Insurance 56,169.37 2,544.73 58,714.10 PR 2240 09/09/2016 Supplemental P/R 9/9/16 Medical Insurance (426.75) 58,287.35 PR 2281 09/09/2016 Supplemental P/R run Medical Insurance (426.76) 57,860.59 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2336 09/23/2016 MUD P/R 9/23/16 Medical Insurance 56,169.37 1,691.19 59,551.78 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 1,691.22 61,243.00 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,073.63 61,243.00 ** 68,196.00 Budgeted 6,953.00 Remaining 90 % Used Account: 135-50027-030-000 Dental Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Dental Insurance 3,846.14 170.45 4,016.59 PR 2240 09/09/2016 Supplemental P/R 9/9/16 Dental Insurance (25.03) 3,991.56 PR 2281 09/09/2016 Supplemental P/R run Dental Insurance (25.03) 3,966.53 PR 2336 09/23/2016 MUD P/R 9/23/16 Dental Insurance 120.38 4,086.91 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 120.39 4,207.30 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 361.16 4,207.30 ** 4,807.00 Budgeted 599.70 Remaining 88 % Used Account: 135-50028-030-000 Vision Insurance 2238 09/09/2016 MUD Payroll 9/9/16 Vision Insurance 894.34 40.63 934.97 PR 2240 09/09/2016 Supplemental P/R 9/9/16 Vision Insurance (7.50) 927.47 PR 2281 09/09/2016 Supplemental P/R run Vision Insurance (6.12) 921.35 PR 2336 09/23/2016 MUD P/R 9/23/16 Vision Insurance 26.97 948.32 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 27.01 975.33 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 80.99 975.33 ** 1,114.00 Budgeted 138.67 Remaining 88 % Used Account: 135-50029-030-000 Life Insurance & Other 2138 09/01/2016 Sept A/P Sept. Dental, Vision, Life & O 4,316.43 331.95 4,648.38 METLIFE GROUP BENEFITS 2242 AP 2332 09/20/2016 September A/P Café 125 adm. fees 29.16 4,677.54 BenefitMall 2340 AP 2360 09/25/2016 Sept A/P Rounding adjustment (.02) 4,677.52 Legal Shield 2356 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 361.09 4,677.52 ** 5,431.00 Budgeted 753.48 Remaining 86 % Used Account: 135-50030-030-000 Social Security Taxes 2238 09/09/2016 MUD Payroll 9/9/16 Social Security Taxes 25,469.62 1,358.71 26,828.33 PR 2240 09/09/2016 Supplemental P/R 9/9/16 Social Security Taxes 29.05 26,857.38 PR 2281 09/09/2016 Supplemental P/R run Social Security Taxes 13.70 26,871.08 PR 2336 09/23/2016 MUD P/R 9/23/16 Social Security Taxes 672.75 27,543.83 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2409 09/30/2016 Accrued Payroll @ 9/30/16 25,469.62 683.01 28,226.84 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,757.22 28,226.84 ** 31,141.00 Budgeted 2,914.16 Remaining 91 % Used Account: 135-50035-030-000 Medicare Taxes 2238 09/09/2016 MUD Payroll 9/9/16 Medicare Taxes 5,956.59 317.76 6,274.35 PR 2240 09/09/2016 Supplemental P/R 9/9/16 Medicare Taxes 6.80 6,281.15 PR 2281 09/09/2016 Supplemental P/R run Medicare Taxes 3.21 6,284.36 PR 2336 09/23/2016 MUD P/R 9/23/16 Medicare Taxes 157.34 6,441.70 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 159.74 6,601.44 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 644.85 6,601.44 ** 7,678.00 Budgeted 1,076.56 Remaining 86 % Used Account: 135-50040-030-000 Unemployment Taxes 2238 09/09/2016 MUD Payroll 9/9/16 Unemployment Taxes 1,233.85 36.99 1,270.84 PR 2336 09/23/2016 MUD P/R 9/23/16 Unemployment Taxes 38.48 1,309.32 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 39.78 1,349.10 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 115.25 1,349.10 ** 1,197.00 Budgeted (152.10) Remaining 113 % Used Account: 135-50045-030-000 Workman's Compensation 143 09/01/2016 Prepaid Insurance, W/C Sep 1,918.79 147.88 2,066.67 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.88 2,066.67 ** 1,554.00 Budgeted (512.67) Remaining 133 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 147.45 .00 147.45 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 147.45 ** 500.00 Budgeted 352.55 Remaining 29 % Used Account: 135-50070-030-000 Employee Relations 2418 09/27/2016 September A/P HOT AND CREAMY DONUTS 3,401.17 19.40 3,420.57 HOT AND CREAMY DONUTS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50070-030-000 Employee Relations Totals: 19.40 3,420.57 ** 4,500.00 Budgeted 1,079.43 Remaining 76 % Used Account: 135-55005-030-000 Engineering 2332 09/20/2016 September A/P Bond Election 4,365.00 4,365.00 CP&Y/WALLACE GROUP, INC. 2341 AP _______________ Account: 135-55005-030-000 Engineering Totals: 4,365.00 4,365.00 ** .00 Budgeted (4,365.00) Remaining 0 % Used Account: 135-55030-030-000 Software & Support 2319 09/16/2016 September A/P Internet 43,311.41 1,120.77 44,432.18 WHOLESALE CARRIER SERVICES INC 2377 AP 2332 09/20/2016 September A/P Software & Support through 8/3 2,415.60 46,847.78 STW INC 2368 AP 2418 09/27/2016 September A/P ATT*BILL PAYMENT 150.14 46,997.92 ATT*BILL PAYMENT PC 2418 09/27/2016 September A/P ATT*BILL PAYMENT 166.46 47,164.38 ATT*BILL PAYMENT PC 2418 09/27/2016 September A/P WWW.ISTOCK.COM 12.99 47,177.37 WWW.ISTOCK.COM PC 2418 09/27/2016 September A/P ADOBE *IL CREATIVECLD 21.64 47,199.01 ADOBE *IL CREATIVECLD PC 2418 09/27/2016 September A/P WWW.ISTOCK.COM 12.99 47,212.00 WWW.ISTOCK.COM PC 2418 09/27/2016 September A/P CANVA.COM 11.00 47,223.00 CANVA.COM PC 2437 09/30/2016 Sept A/P Support 648.00 47,871.00 STW INC AP _______________ Account: 135-55030-030-000 Software & Support Totals: 4,559.59 47,871.00 ** 81,097.00 Budgeted 33,226.00 Remaining 59 % Used Account: 135-55070-030-000 Independent Labor 2410 09/30/2016 September A/P Petty cash reimbursement Septe 1,288.63 37.08 1,325.71 TROPHY CLUB MUD PETTY CASH 2405 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 37.08 1,325.71 ** 12,000.00 Budgeted 10,674.29 Remaining 11 % Used Account: 135-55080-030-000 Maintenance & Repairs 6,284.35 .00 6,284.35 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 6,284.35 ** 7,000.00 Budgeted 715.65 Remaining 90 % Used Account: 135-55100-030-000 Building Maint & Supplies 2418 09/27/2016 September A/P ROANOKE WINNELSON CO 6,721.92 37.17 6,759.09 ROANOKE WINNELSON CO PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2382 09/29/2016 September A/P Rug Service-MUD & PS Bldgs 6,721.92 130.89 6,889.98 G & K SERVICES 2346 AP 2382 09/29/2016 September A/P Rug Service-MUD & PS Bldgs 130.89 7,020.87 G & K SERVICES 2346 AP 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (130.89) 6,889.98 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 168.06 6,889.98 ** 7,000.00 Budgeted 110.02 Remaining 98 % Used Account: 135-55120-030-000 Cleaning Services 2332 09/20/2016 September A/P Aug Janitorial Svcs. 5,588.50 843.75 6,432.25 MEMBER'S BUILDING MAINTENANCE 2358 AP 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (259.00) 6,173.25 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 6,173.25 ** 10,125.00 Budgeted 3,951.75 Remaining 61 % Used Account: 135-55160-030-000 Professional Outside Services 2272 09/09/2016 September A/P Auditor Retainer 67,112.88 112.50 67,225.38 LAFOLLETT & ABBOTT PLLC 2295 AP 2382 09/29/2016 September A/P 2,457.88 69,683.26 NEW GEN STRATEGIES & SOLUTIONS 2361 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 2,570.38 69,683.26 ** 72,575.00 Budgeted 2,891.74 Remaining 96 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 2410 09/30/2016 September A/P Utility Billing-September 7,917.61 597.90 8,515.51 DP2 BILLING SOLUTIONS, LLC 2389 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 597.90 8,515.51 ** 8,200.00 Budgeted (315.51) Remaining 104 % Used Account: 135-60005-030-000 Telephone 2272 09/09/2016 September A/P Answering service 12,621.93 225.32 12,847.25 KEYSTONE PARK SECRETARIAL 2292 AP 2418 09/27/2016 September A/P ATT*BUS PHONE PMT 823.24 13,670.49 ATT*BUS PHONE PMT PC 2418 09/27/2016 September A/P ATT*BUS PHONE PMT 439.14 14,109.63 ATT*BUS PHONE PMT PC 2418 09/27/2016 September A/P RINGCENTRAL, INC 10.73 14,120.36 RINGCENTRAL, INC PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2382 09/29/2016 September A/P Cover for L Holt phone 12,621.93 43.29 14,163.65 LANCE HOLT 2355 AP 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: (440.31) 13,723.34 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,101.41 13,723.34 ** 16,349.00 Budgeted 2,625.66 Remaining 84 % Used Account: 135-60010-030-000 Communications/Mobiles 2336 09/23/2016 MUD P/R 9/23/16 Communications/Mobiles 3,853.29 150.00 4,003.29 PR 2437 09/30/2016 Sept A/P September cell phones 37.99 4,041.28 VERIZON WIRELESS AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 187.99 4,041.28 ** 4,150.00 Budgeted 108.72 Remaining 97 % Used Account: 135-60020-030-000 Electricity/Gas 5,287.80 .00 5,287.80 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 5,287.80 ** 10,768.00 Budgeted 5,480.20 Remaining 49 % Used Account: 135-60025-030-000 Water 2436 09/30/2016 Town A/R Billing/September AR 20160930-20160930 User: 791.46 (142.55) 648.91 AR 2437 09/30/2016 Sept A/P September water 285.09 934.00 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 135-60025-030-000 Water Totals: 142.54 934.00 ** 1,500.00 Budgeted 566.00 Remaining 62 % Used Account: 135-60035-030-000 Postage 2410 09/30/2016 September A/P Utility Billing-September 25,460.21 1,742.66 27,202.87 DP2 BILLING SOLUTIONS, LLC 2389 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,742.66 27,202.87 ** 28,932.00 Budgeted 1,729.13 Remaining 94 % Used Account: 135-60040-030-000 Service Charges & Fees 2304 09/02/2016 Credit Card Fees 47,177.13 4,180.41 51,357.54 GL 2304 09/02/2016 Credit Card Fees 89.77 51,447.31 GL 2239 09/09/2016 Child support fee 1.50 51,448.81 GL 2345 09/23/2016 Child support fee 9/23/16 P/R 1.50 51,450.31 GL 2410 09/30/2016 September A/P Direct Send Fees 50.00 51,500.31 Fiserv Solutions, LLC 2391 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,323.18 51,500.31 ** 55,560.00 Budgeted 4,059.69 Remaining 93 % Used Account: 135-60050-030-000 Bad Debt Expense 2403 09/30/2016 UB 9/30/16 Write Offs UB20160930-20160930 User: 3,022.62 436.24 3,458.86 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 436.24 3,458.86 ** 3,500.00 Budgeted 41.14 Remaining 99 % Used Account: 135-60055-030-000 Insurance 143 09/01/2016 Prepaid Insurance, W/C Sep 30,817.00 2,756.00 33,573.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 33,573.00 ** 52,797.00 Budgeted 19,224.00 Remaining 64 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 260.00 .00 260.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 260.00 ** 1,600.00 Budgeted 1,340.00 Remaining 16 % Used Account: 135-60070-030-000 Dues & Memberships 2418 09/27/2016 September A/P SAMS CLUB #4795 5,466.25 45.00 5,511.25 SAMS CLUB #4795 PC 2418 09/27/2016 September A/P SAMSCLUB #4795 45.00 5,556.25 SAMSCLUB #4795 PC 2410 09/30/2016 September A/P Texas Co-op 100.00 5,656.25 TX COMPTROLLER 2406 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 190.00 5,656.25 ** 6,000.00 Budgeted 343.75 Remaining 94 % Used Account: 135-60075-030-000 Meetings 163.36 .00 163.36 _______________ Account: 135-60075-030-000 Meetings Totals: .00 163.36 ** 400.00 Budgeted 236.64 Remaining 41 % Used Account: 135-60079-030-000 Public Education . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4,230.34 .00 4,230.34 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,230.34 ** 5,000.00 Budgeted 769.66 Remaining 85 % Used Account: 135-60080-030-000 Schools & Training 3,382.00 .00 3,382.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,382.00 ** 9,935.00 Budgeted 6,553.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 2238 09/09/2016 MUD Payroll 9/9/16 Travel & per diem 3,386.61 71.88 3,458.49 PR 2336 09/23/2016 MUD P/R 9/23/16 Travel & per diem 14.58 3,473.07 PR 2409 09/30/2016 Accrued Payroll @ 9/30/16 88.45 3,561.52 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 174.91 3,561.52 ** 5,400.00 Budgeted 1,838.48 Remaining 66 % 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 2382 09/29/2016 September A/P Elections 3,210.41 400.00 3,610.41 TARRANT COUNTY ELECTIONS ADMIN 2369 AP _______________ Account: 135-60115-030-000 Elections Totals: 400.00 3,610.41 ** 7,500.00 Budgeted 3,889.59 Remaining 48 % Used Account: 135-60125-030-000 Advertising 2410 09/30/2016 September A/P Employment ad 1,030.36 368.50 1,398.86 TX WATER UTILITIES ASSOC 2407 AP _______________ Account: 135-60125-030-000 Advertising Totals: 368.50 1,398.86 ** 7,500.00 Budgeted 6,101.14 Remaining 19 % Used Account: 135-60235-030-000 Security . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 2418 09/27/2016 September A/P VCN*DENTONRECCTR 5,302.48 144.00 5,446.48 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 144.00 5,446.48 ** 17,501.00 Budgeted 12,054.52 Remaining 31 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 7,238.41 .00 7,238.41 _______________ Account: 135-65055-030-000 Hardware Totals: .00 7,238.41 ** 13,594.00 Budgeted 6,355.59 Remaining 53 % Used Account: 135-65085-030-000 Office Supplies 2332 09/20/2016 September A/P office supplies 5,208.50 107.40 5,315.90 OFFICE DEPOT, INC 2363 AP 2332 09/20/2016 September A/P office supplies 8.19 5,324.09 OFFICE DEPOT, INC 2363 AP 2332 09/20/2016 September A/P office supplies 33.73 5,357.82 OFFICE DEPOT, INC 2363 AP 2332 09/20/2016 September A/P Office supplies 31.27 5,389.09 OFFICE DEPOT, INC 2363 AP 2418 09/27/2016 September A/P KELLER TROPHY AND AWAR 10.00 5,399.09 KELLER TROPHY AND AWAR PC 2418 09/27/2016 September A/P OFFICE DEPOT #406 75.97 5,475.06 OFFICE DEPOT #406 PC 2437 09/30/2016 Sept A/P Office Supplies 58.98 5,534.04 OFFICE DEPOT, INC AP 2437 09/30/2016 Sept A/P Office Supplies 5.09 5,539.13 OFFICE DEPOT, INC AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2437 09/30/2016 Sept A/P Office Supplies 5,208.50 53.75 5,592.88 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 384.38 5,592.88 ** 9,000.00 Budgeted 3,407.12 Remaining 62 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2384 09/29/2016 September A/P Printer toner 1,004.63 297.29 1,301.92 SHI GOVERNMENT SOLUTIONS,INC 2366 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 297.29 1,301.92 ** 4,003.00 Budgeted 2,701.08 Remaining 33 % Used Account: 135-65095-030-000 Maintenance Supplies 2418 09/27/2016 September A/P SAMSCLUB #4795 3,412.88 107.87 3,520.75 SAMSCLUB #4795 PC 2418 09/27/2016 September A/P SAMSCLUB #4795 46.00 3,566.75 SAMSCLUB #4795 PC 2410 09/30/2016 September A/P Meeting Snacks 65.04 3,631.79 COSTCO WHOLESALE 2387 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 218.91 3,631.79 ** 5,000.00 Budgeted 1,368.21 Remaining 73 % Used Account: 135-65105-030-000 Printing 3,187.99 .00 3,187.99 _______________ Account: 135-65105-030-000 Printing Totals: .00 3,187.99 ** 4,800.00 Budgeted 1,612.01 Remaining 66 % Used Account: 135-69005-030-000 Capital Outlays 24,907.03 .00 24,907.03 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 24,907.03 ** 56,000.00 Budgeted 31,092.97 Remaining 44 % Used Account: 135-69170-030-000 Copier Lease Installments 2319 09/16/2016 September A/P Copier Lease 3,290.15 165.00 3,455.15 EVERBANK COMMERCIAL FINANCE 2344 AP 2382 09/29/2016 September A/P Copy Charges 127.26 3,582.41 KYOCERA MITA AMERICA, INC. 2353 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 292.26 3,582.41 ** 4,600.00 Budgeted 1,017.59 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ----------------------------------- 1,013,669.36 ** 88,859.11 Monthly Total 1,203,217.00 Budgeted 189,547.64 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 2410 09/30/2016 September A/P September Legal 316,446.79 150.00 316,596.79 FREEMAN & CORBETT 2392 AP _______________ Account: 135-55045-039-000 Legal Totals: 150.00 316,596.79 ** 386,130.00 Budgeted 69,533.21 Remaining 82 % Used Account: 135-55055-039-000 Auditing 2272 09/09/2016 September A/P Auditor Retainer 24,039.38 5,000.00 29,039.38 LAFOLLETT & ABBOTT PLLC 2295 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 29,039.38 ** 24,039.00 Budgeted (5,000.38) Remaining 121 % Used Account: 135-55060-039-000 Appraisal 2272 09/09/2016 September A/P 4th qtr DCAD budget 8,093.66 1,994.51 10,088.17 DENTON CENTRAL APPRAISAL DISTR 2276 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,994.51 10,088.17 ** 10,265.00 Budgeted 176.83 Remaining 98 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ----------------------------------- 358,193.16 ** 7,144.51 Monthly Total 424,234.00 Budgeted 66,040.84 Remaining 84 % Used Fund 135 Totals: ----------------------------------- 1,121,184.42 (168,042.32) Monthly Total .00 Budgeted (1,121,184.42) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (156,420.00) ** .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ----------------------------------- (2.77) ** .00 Monthly Total .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ----------------------------------- 8,034.36 ** .00 Monthly Total .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ----------------------------------- 8,031.59 .00 Monthly Total .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,391,204 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,391,204 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 12,641 TOTAL FUND BALANCE 4,391,204 TOTAL LIABILITIES AND FUND BALANCE 4,391,204 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 18:01 10/13/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,370.79- 12,641.60- 12,641.60 Subtotal: 1,370.79- 12,641.60- 12,641.60 Program number: 1,370.79- 12,641.60- 12,641.60 Department number: Revenues 1,370.79- 12,641.60- 12,641.60 Revenues Subtotal ----------- 1,370.79- 12,641.60- 12,641.60 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,370.79- 12,641.60- 12,641.60 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 2434 09/30/2016 Sept Bank Interest (11,270.81) (1,370.79) (12,641.60) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,370.79) (12,641.60) ** .00 Budgeted 12,641.60 Remaining 0 % Used Department Totals: ----------------------------------- (12,641.60) ** (1,370.79) Monthly Total .00 Budgeted 12,641.60 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (12,641.60) (1,370.79) Monthly Total .00 Budgeted 12,641.60 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 1,461,353 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,461,353 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,302,621 TOTAL LIABILITIES 1,302,621 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (8,175,372) TOTAL FUND BALANCE 158,732 TOTAL LIABILITIES AND FUND BALANCE 1,461,353 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 18:01 10/13/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 585.78- 16,254.51- 16,254.51 Subtotal: 585.78- 16,254.51- 16,254.51 Program number: 585.78- 16,254.51- 16,254.51 Department number: Revenues 585.78- 16,254.51- 16,254.51 Revenues Subtotal ----------- 585.78- 16,254.51- 16,254.51 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 18:01 10/13/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 719,092.77 8,243,652.79 8,243,652.79- Subtotal: 719,092.77 8,243,652.79 8,243,652.79- Program number: 719,092.77 8,243,652.79 8,243,652.79- Department number: Wastewater 719,092.77 8,243,652.79 8,243,652.79- Expenditures Subtotal ----------- 719,092.77 8,243,652.79 8,243,652.79- Fund number: 518 2015 Revenue Bond Const Fund 718,506.99 8,227,398.28 8,227,398.28- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 2434 09/30/2016 Sept Bank Interest (15,668.73) (585.78) (16,254.51) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (585.78) (16,254.51) ** .00 Budgeted 16,254.51 Remaining 0 % Used Department Totals: ----------------------------------- (16,254.51) ** (585.78) Monthly Total .00 Budgeted 16,254.51 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 2319 09/16/2016 September A/P Trophy Club MUD WWTP Improveme 7,524,560.02 55,694.50 7,580,254.52 CP&Y/WALLACE GROUP, INC. 2341 AP 2410 09/30/2016 September A/P WWTP App 12 611,371.79 8,191,626.31 WEBBER-CADAGUA PARTNERS 2410 AP 2440 09/30/2016 Sept A/P WWTP Improvements 52,026.48 8,243,652.79 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 719,092.77 8,243,652.79 ** .00 Budgeted (8,243,652.79) Remaining 0 % Used Department 20 Totals: ----------------------------------- 8,243,652.79 ** 719,092.77 Monthly Total .00 Budgeted (8,243,652.79) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 8,227,398.28 718,506.99 Monthly Total .00 Budgeted (8,227,398.28) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 195,762 ACCOUNTS RECEIVABLE - TOTAL ASSETS 195,762 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 123,800 TOTAL FUND BALANCE 195,762 TOTAL LIABILITIES AND FUND BALANCE 195,762 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 18:01 10/13/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 61.11- 464.13- 464.13 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 123,336.00- 100.000 Subtotal: 123,336.00- 123,336.00- 61.11- 123,800.13- 100.376 464.13 Program number: 123,336.00- 123,336.00- 61.11- 123,800.13- 100.376 464.13 Department number: 123,336.00- 123,336.00- 61.11- 123,800.13- 100.376 464.13 Revenues Subtotal ----------- 123,336.00- 123,336.00- 61.11- 123,800.13- 100.376 464.13 Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 61.11- 123,800.13- 100.376 464.13 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 2434 09/30/2016 Sept Bank Interest (403.02) (61.11) (464.13) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (61.11) (464.13) ** .00 Budgeted 464.13 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (123,336.00) .00 (123,336.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (123,336.00) ** (123,336.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (123,800.13) ** (61.11) Monthly Total (123,336.00) Budgeted 464.13 Remaining 100 % Used Fund 528 Totals: ----------------------------------- (123,800.13) (61.11) Monthly Total (123,336.00) Budgeted 464.13 Remaining 100 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 21,185 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,508 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 35,539 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,508 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,508 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 1,858 TOTAL FUND BALANCE 26,031 TOTAL LIABILITIES AND FUND BALANCE 35,539 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 18:01 10/13/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 732.54- 657,408.57- 98.429 10,489.43- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 99.62- 8,816.28- 383.317 6,516.28 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 153.70- 4,009.65- 222.758 2,209.65 Subtotal: 671,998.00- 671,998.00- 985.86- 670,234.50- 99.738 1,763.50- 533-49010-000-000 Interest Income 140.00- 140.00- 6.50- 1,671.28- 1,193.771 1,531.28 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- 100.000 Subtotal: 334,225.00- 334,225.00- 6.50- 335,756.28- 100.458 1,531.28 Program number: 1,006,223.00- 1,006,223.00- 992.36- 1,005,990.78- 99.977 232.22- Department number: Revenues 1,006,223.00- 1,006,223.00- 992.36- 1,005,990.78- 99.977 232.22- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 992.36- 1,005,990.78- 99.977 232.22- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 18:01 10/13/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,950.00 76.471 600.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 317,182.50 100.063 199.50- 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 100.000 Subtotal: 1,004,533.00 1,004,533.00 1,004,132.50 99.960 400.50 Program number: 1,004,533.00 1,004,533.00 1,004,132.50 99.960 400.50 Department number: Administration 1,004,533.00 1,004,533.00 1,004,132.50 99.960 400.50 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,004,132.50 99.960 400.50 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 992.36- 1,858.28- 109.957 168.28 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 2421 09/06/2016 Property Taxes (656,676.03) (98.71) (656,774.74) GL 2423 09/08/2016 Property Taxes (28.05) (656,802.79) GL 2424 09/09/2016 Property Taxes (12.51) (656,815.30) GL 2425 09/12/2016 Property Taxes (24.47) (656,839.77) GL 2426 09/15/2016 Property Taxes (.32) (656,840.09) GL 2427 09/20/2016 Property Taxes (256.37) (657,096.46) GL 2428 09/21/2016 Property Taxes (50.28) (657,146.74) GL 2429 09/22/2016 Property Taxes (73.91) (657,220.65) GL 2430 09/23/2016 Property Taxes (25.86) (657,246.51) GL 2431 09/28/2016 Property Taxes (161.57) (657,408.08) GL 2432 09/29/2016 Property Taxes (.49) (657,408.57) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (732.54) (657,408.57) ** (667,898.00) Budgeted (10,489.43) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2420 09/01/2016 Property Taxes (8,716.66) (3.82) (8,720.48) GL 2422 09/07/2016 Property Taxes (95.80) (8,816.28) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (99.62) (8,816.28) ** (2,300.00) Budgeted 6,516.28 Remaining 383 % Used Account: 533-40015-000-000 Property Taxes/P & I 2420 09/01/2016 Property Taxes (3,855.95) (1.06) (3,857.01) GL 2421 09/06/2016 Property Taxes (3.76) (3,860.77) GL 2422 09/07/2016 Property Taxes (71.05) (3,931.82) GL 2423 09/08/2016 Property Taxes (2.24) (3,934.06) GL 2424 09/09/2016 Property Taxes (1.59) (3,935.65) GL 2425 09/12/2016 Property Taxes (1.96) (3,937.61) GL 2426 09/15/2016 Property Taxes (.03) (3,937.64) GL 2427 09/20/2016 Property Taxes (32.92) (3,970.56) GL 2428 09/21/2016 Property Taxes (2.84) (3,973.40) GL 2429 09/22/2016 Property Taxes (3.93) (3,977.33) GL 2431 09/28/2016 Property Taxes (32.32) (4,009.65) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (153.70) (4,009.65) ** (1,800.00) Budgeted 2,209.65 Remaining 223 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2434 09/30/2016 Sept Bank Interest (1,664.78) (6.50) (1,671.28) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (6.50) (1,671.28) ** (140.00) Budgeted 1,531.28 Remaining 1.194 % Used Account: 533-49015-000-000 Lease/Rental Income (214,379.00) .00 (214,379.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,379.00) ** (214,379.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (119,706.00) .00 (119,706.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (119,706.00) ** (119,706.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (1,005,990.78) ** (992.36) Monthly Total (1,006,223.00) Budgeted (232.22) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,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 317,182.50 .00 317,182.50 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 317,182.50 ** 316,983.00 Budgeted (199.50) Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 .00 685,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 685,000.00 ** 685,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,004,132.50 ** .00 Monthly Total 1,004,533.00 Budgeted 400.50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (1,858.28) (992.36) Monthly Total (1,690.00) Budgeted 168.28 Remaining 110 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,097 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,097 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 29 TOTAL FUND BALANCE 15,097 TOTAL LIABILITIES AND FUND BALANCE 15,097 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 18:01 10/13/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 4.78- 428.88- 6,126.857 421.88 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 444,837.52- 100.001 6.52 Subtotal: 444,838.00- 444,838.00- 4.78- 445,266.40- 100.096 428.40 Program number: 444,838.00- 444,838.00- 4.78- 445,266.40- 100.096 428.40 Department number: Revenues 444,838.00- 444,838.00- 4.78- 445,266.40- 100.096 428.40 Revenues Subtotal ----------- 444,838.00- 444,838.00- 4.78- 445,266.40- 100.096 428.40 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 18:01 10/13/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2016 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 200.00 200.00- 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 235,037.50 100.085 199.50- 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 100.000 Subtotal: 444,838.00 444,838.00 445,237.50 100.090 399.50- Program number: 444,838.00 444,838.00 445,237.50 100.090 399.50- Department number: Administration 444,838.00 444,838.00 445,237.50 100.090 399.50- Expenditures Subtotal ----------- 444,838.00 444,838.00 445,237.50 100.090 399.50- Fund number: 534 2015 Revenue Bond I&S 4.78- 28.90- 28.90 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 61 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 2434 09/30/2016 Sept Bank Interest (424.10) (4.78) (428.88) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (4.78) (428.88) ** (7.00) Budgeted 421.88 Remaining 6.127 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales (444,837.52) .00 (444,837.52) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (444,837.52) ** (444,831.00) Budgeted 6.52 Remaining 100 % Used Department Totals: ----------------------------------- (445,266.40) ** (4.78) Monthly Total (444,838.00) Budgeted 428.40 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 62 18:01 10/13/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee 200.00 .00 200.00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 235,037.50 .00 235,037.50 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 235,037.50 ** 234,838.00 Budgeted (199.50) Remaining 100 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 .00 210,000.00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 210,000.00 ** 210,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 445,237.50 ** .00 Monthly Total 444,838.00 Budgeted (399.50) Remaining 100 % Used Fund 534 Totals: ----------------------------------- (28.90) (4.78) Monthly Total .00 Budgeted 28.90 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 9,060,825.11 **** 624,388.10 Monthly Total (125,026.00) Budgeted (9,185,851.11) Remaining ########## ******* End of Report *********