Loading...
HomeMy WebLinkAbout2016-08 August Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2016 122 ASSETS FIRE DEPT. CASH IN BANK 48,529 INVESTMENTS 567,458 PREPAID EXPENSES 5,925 ADVALOREM PROPERTY TAXES RECEIVABLE 16,092 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,436 TOTAL ASSETS 640,440 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 16,092 ACCOUNTS AND OTHER PAYABLES 13,459 TOTAL LIABILITIES 29,551 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 77,392 TOTAL FUND BALANCE 610,889 TOTAL LIABILITIES AND FUND BALANCE 640,440 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 13:20 09/15/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 2,758.74- 875,002.32- 98.319 14,960.68- 122-40011-000-000 Property Taxes/Fire-Delinquent 853.69- 17,912.12- 17,912.12 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- 658.61- 7,354.15- 163.426 2,854.15 Subtotal: 1,299,559.00- 1,298,809.00- 4,271.04- 1,271,904.99- 97.929 26,904.01- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 400.00- 5,200.00- 104.000 200.00 Subtotal: 5,000.00- 5,000.00- 400.00- 5,200.00- 104.000 200.00 122-43400-000-000 Fire Inspections 825.00- 825.00- 75.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- 75.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- 900.00- 11,100.00- 110.989 1,099.00 Subtotal: 50,000.00- 70,001.00- 900.00- 71,100.00- 101.570 1,099.00 Program number: 1,365,384.00- 1,384,635.00- 5,646.04- 1,359,279.99- 98.169 25,355.01- Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 5,646.04- 1,359,279.99- 98.169 25,355.01- Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 5,646.04- 1,359,279.99- 98.169 25,355.01- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 13:20 09/15/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 39,585.98 447,123.91 87.977 61,102.09 122-50010-045-000 Overtime 48,735.00 48,735.00 2,055.01 55,840.50 114.580 7,105.50- 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 450.00 3,840.13 91.432 359.87 122-50020-045-000 Retirement 75,571.00 75,571.00 4,970.11 64,208.66 84.965 11,362.34 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,707.69 49,305.23 75.222 16,240.77 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 385.39 4,447.32 91.040 437.68 122-50028-045-000 Vision Insurance 859.00 859.00 71.70 877.51 102.155 18.51- 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 343.35 3,496.29 76.255 1,088.71 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,242.62 29,554.91 81.797 6,577.09 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 524.35 6,910.20 81.778 1,539.80 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 4.49 2,125.24 106.262 125.24- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 781.58 8,597.42 91.667 781.58 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 56,122.27 696,828.85 88.158 93,602.15 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 8,546.77 44,030.50 174.599 18,812.50- 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 80.08 12,798.17 127.982 2,798.17- 122-55160-045-000 Professional Outside Services 2,743.80 2,743.80- Subtotal: 35,031.00 46,879.00 8,626.85 71,230.28 151.945 24,351.28- 122-60005-045-000 Telephone 50.00 50.00 15.71 54.26 108.520 4.26- 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 75.00 6,376.80 82.751 1,329.20 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 623.23 4,723.84 63.732 2,688.16 122-60025-045-000 Water 1,200.00 1,200.00 260.39 1,825.95 152.163 625.95- 122-60026-045-000 Cable 1,920.00 1,920.00 152.91 1,700.63 88.574 219.37 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 3.70 46.47 92.940 3.53 122-60055-045-000 Insurance 14,077.00 18,451.00 391.50 8,680.24 47.045 9,770.76 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 3,338.39 48.523 3,541.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 189.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 352.00 3,425.25 45.670 4,074.75 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 13:20 09/15/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 838.01 83.717 162.99 Subtotal: 292,019.00 298,646.00 2,063.44 275,883.45 92.378 22,762.55 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 400.31 4,098.73 27.104 11,023.27 122-65010-045-000 Uniforms 3,140.00 3,640.00 2,754.50 9,201.19 252.780 5,561.19- 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 4,565.93 50.733 4,434.07 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 1,862.37 93.119 137.63 122-65055-045-000 Hardware 750.00 750.00 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 327.54 65.508 172.46 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 3,154.81 21,442.18 66.777 10,667.82 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 69,967.37 1,281,887.25 92.579 102,747.75 Department number: Fire 1,365,384.00 1,384,635.00 69,967.37 1,281,887.25 92.579 102,747.75 Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 69,967.37 1,281,887.25 92.579 102,747.75 Fund number: 122 Trophy Club MUD Fire Dept. 64,321.33 77,392.74- 77,392.74 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs (371,290.86) .00 (371,290.86) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (371,290.86) ** (404,346.00) Budgeted (33,055.14) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (345.54) .00 (345.54) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2253 08/01/2016 Property Taxes (872,243.58) (332.05) (872,575.63) GL 2255 08/02/2016 Property Taxes (542.30) (873,117.93) GL 2256 08/03/2016 Property Taxes (23.62) (873,141.55) GL 2258 08/04/2016 Property Taxes (142.50) (873,284.05) GL 2259 08/08/2016 Property Taxes (72.22) (873,356.27) GL 2260 08/09/2016 Property Taxes (1,259.35) (874,615.62) GL 2261 08/12/2016 Property Taxes (39.59) (874,655.21) GL 2262 08/18/2016 Property Taxes (33.37) (874,688.58) GL 2287 08/22/2016 Property Taxes (146.58) (874,835.16) GL 2288 08/23/2016 Property Taxes (185.21) (875,020.37) GL 2290 08/26/2016 Property Taxes 18.05 (875,002.32) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,758.74) (875,002.32) ** (889,963.00) Budgeted (14,960.68) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2253 08/01/2016 Property Taxes (17,058.43) (7.20) (17,065.63) GL 2255 08/02/2016 Property Taxes (677.38) (17,743.01) GL 2260 08/09/2016 Property Taxes (163.71) (17,906.72) GL 2289 08/25/2016 Property Taxes (5.40) (17,912.12) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (853.69) (17,912.12) ** .00 Budgeted 17,912.12 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2253 08/01/2016 Property Taxes (6,695.54) (2.13) (6,697.67) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2255 08/02/2016 Property Taxes (6,695.54) (147.91) (6,845.58) GL 2258 08/04/2016 Property Taxes (54.27) (6,899.85) GL 2259 08/08/2016 Property Taxes (6.15) (6,906.00) GL 2260 08/09/2016 Property Taxes (422.19) (7,328.19) GL 2261 08/12/2016 Property Taxes (2.77) (7,330.96) GL 2262 08/18/2016 Property Taxes (2.35) (7,333.31) GL 2287 08/22/2016 Property Taxes (11.71) (7,345.02) GL 2288 08/23/2016 Property Taxes (9.13) (7,354.15) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (658.61) (7,354.15) ** (4,500.00) Budgeted 2,854.15 Remaining 163 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (4,800.00) (400.00) (5,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (5,200.00) ** (5,000.00) Budgeted 200.00 Remaining 104 % Used Account: 122-43400-000-000 Fire Inspections 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (1,000.00) (75.00) (1,075.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.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 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (10,200.00) (900.00) (11,100.00) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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: (900.00) (11,100.00) ** (10,001.00) Budgeted 1,099.00 Remaining 111 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,359,279.99) ** (1,384,635.00) Budgeted (25,355.01) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 2147 08/12/2016 Fire Dept P/R 8/12/16 407,537.93 18,644.86 426,182.79 GL 2187 08/26/2016 Fire Payroll 8/26/16 18,069.29 444,252.08 GL 2268 08/31/2016 August A/P Gexa, Interim Fire Chief 2,871.83 447,123.91 TOWN OF TROPHY CLUB 2319 AP _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 39,585.98 447,123.91 ** 508,226.00 Budgeted 61,102.09 Remaining 88 % Used Account: 122-50010-045-000 Overtime 2187 08/26/2016 Fire Payroll 8/26/16 53,785.49 2,055.01 55,840.50 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,055.01 55,840.50 ** 48,735.00 Budgeted (7,105.50) Remaining 115 % 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 2147 08/12/2016 Fire Dept P/R 8/12/16 3,390.13 450.00 3,840.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 450.00 3,840.13 ** 4,200.00 Budgeted 359.87 Remaining 91 % Used Account: 122-50020-045-000 Retirement 2147 08/12/2016 Fire Dept P/R 8/12/16 59,238.55 2,427.34 61,665.89 GL 2187 08/26/2016 Fire Payroll 8/26/16 2,542.77 64,208.66 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,970.11 64,208.66 ** 75,571.00 Budgeted 11,362.34 Remaining 85 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50026-045-000 Medical Insurance 2147 08/12/2016 Fire Dept P/R 8/12/16 44,597.54 2,712.31 47,309.85 GL 2187 08/26/2016 Fire Payroll 8/26/16 1,995.38 49,305.23 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,707.69 49,305.23 ** 65,546.00 Budgeted 16,240.77 Remaining 75 % Used Account: 122-50027-045-000 Dental Insurance 2147 08/12/2016 Fire Dept P/R 8/12/16 4,061.93 192.69 4,254.62 GL 2187 08/26/2016 Fire Payroll 8/26/16 192.70 4,447.32 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 385.39 4,447.32 ** 4,885.00 Budgeted 437.68 Remaining 91 % Used Account: 122-50028-045-000 Vision Insurance 2147 08/12/2016 Fire Dept P/R 8/12/16 805.81 35.84 841.65 GL 2187 08/26/2016 Fire Payroll 8/26/16 35.86 877.51 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 71.70 877.51 ** 859.00 Budgeted (18.51) Remaining 102 % Used Account: 122-50029-045-000 Life Insurance & Other 2147 08/12/2016 Fire Dept P/R 8/12/16 3,152.94 171.67 3,324.61 GL 2187 08/26/2016 Fire Payroll 8/26/16 171.68 3,496.29 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 343.35 3,496.29 ** 4,585.00 Budgeted 1,088.71 Remaining 76 % Used Account: 122-50030-045-000 Social Security Taxes 2147 08/12/2016 Fire Dept P/R 8/12/16 27,312.29 1,089.38 28,401.67 GL 2187 08/26/2016 Fire Payroll 8/26/16 1,153.24 29,554.91 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,242.62 29,554.91 ** 36,132.00 Budgeted 6,577.09 Remaining 82 % Used Account: 122-50035-045-000 Medicare Taxes 2147 08/12/2016 Fire Dept P/R 8/12/16 6,385.85 254.72 6,640.57 GL 2187 08/26/2016 Fire Payroll 8/26/16 269.63 6,910.20 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50035-045-000 Medicare Taxes Totals: 524.35 6,910.20 ** 8,450.00 Budgeted 1,539.80 Remaining 82 % Used Account: 122-50040-045-000 Unemployment Taxes 2147 08/12/2016 Fire Dept P/R 8/12/16 2,120.75 1.07 2,121.82 GL 2187 08/26/2016 Fire Payroll 8/26/16 3.42 2,125.24 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 4.49 2,125.24 ** 2,000.00 Budgeted (125.24) Remaining 106 % Used Account: 122-50045-045-000 Workman's Compensation 1763 08/01/2016 Breakout Fire W/C from Ins 7,815.84 781.58 8,597.42 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 781.58 8,597.42 ** 9,379.00 Budgeted 781.58 Remaining 92 % 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 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 2090 08/08/2016 August A/P Roof repairs @ Fire station 35,483.73 4,580.00 40,063.73 TK CONTRACTORS LLC 2215 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2269 08/26/2016 August A/P THE HOME DEPOT #6581 35,483.73 117.32 40,181.05 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P ALPINE MATERIALS, 335.00 40,516.05 ALPINE MATERIALS, PC 2269 08/26/2016 August A/P AUTOZONE #4206 7.98 40,524.03 AUTOZONE #4206 PC 2269 08/26/2016 August A/P SAMS CLUB #4795 221.03 40,745.06 SAMS CLUB #4795 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 56.17 40,801.23 THE HOME DEPOT #6581 PC 2268 08/31/2016 August A/P Fire Station AC repairs 392.70 41,193.93 BRANDON R REED 2267 AP 2268 08/31/2016 August A/P Building Maint-GASB 2,780.71 43,974.64 Service Time Electric 2315 AP 2277 08/31/2016 August A/P Rug Service 37.24 44,011.88 G & K SERVICES 2330 AP 2277 08/31/2016 August A/P Rug Service 37.24 44,049.12 G & K SERVICES 2330 AP 2277 08/31/2016 August A/P Rug Service 37.24 44,086.36 G & K SERVICES 2330 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (55.86) 44,030.50 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 8,546.77 44,030.50 ** 25,218.00 Budgeted (18,812.50) Remaining 175 % Used Account: 122-55090-045-000 Vehicle Maintenance 2269 08/26/2016 August A/P FOXTAILLIGHTS 12,718.09 80.08 12,798.17 FOXTAILLIGHTS PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 80.08 12,798.17 ** 10,000.00 Budgeted (2,798.17) Remaining 128 % 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 Account: 122-60005-045-000 Telephone 2139 08/17/2016 Reverse Inv 1493, 1494 AR 20160812-20160817 User: 38.55 10.50 49.05 AR 2269 08/26/2016 August A/P ATT*BUS PHONE PMT 5.21 54.26 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 15.71 54.26 ** 50.00 Budgeted (4.26) Remaining 109 % Used Account: 122-60010-045-000 Communications/Mobiles 2147 08/12/2016 Fire Dept P/R 8/12/16 6,301.80 75.00 6,376.80 GL _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 75.00 6,376.80 ** 7,706.00 Budgeted 1,329.20 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-60020-045-000 Electricity/Gas 2144 08/18/2016 August A/P Electricity 7/11-8/9/16 4,100.61 1,172.28 5,272.89 HUDSON ENERGY SERVICES, LLC 2240 AP 2151 08/19/2016 August A/P Gas/Fire Station 74.17 5,347.06 ATMOS ENERGY 2234 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (623.22) 4,723.84 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 623.23 4,723.84 ** 7,412.00 Budgeted 2,688.16 Remaining 64 % Used Account: 122-60025-045-000 Water 2268 08/31/2016 August A/P Water-Fire Station 1,565.56 225.76 1,791.32 TROPHY CLUB MUD (WATER BILLS) 2322 AP 2268 08/31/2016 August A/P Water-Fire Station Irrigation 295.01 2,086.33 TROPHY CLUB MUD (WATER BILLS) 2322 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (260.38) 1,825.95 AR _______________ Account: 122-60025-045-000 Water Totals: 260.39 1,825.95 ** 1,200.00 Budgeted (625.95) Remaining 152 % Used Account: 122-60026-045-000 Cable 2284 08/24/2016 Fire Cable 1,547.72 (128.76) 1,418.96 GL 2269 08/26/2016 August A/P ATT*BILL PAYMENT 128.76 1,547.72 ATT*BILL PAYMENT PC 2269 08/26/2016 August A/P ATT*BILL PAYMENT 152.91 1,700.63 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 152.91 1,700.63 ** 1,920.00 Budgeted 219.37 Remaining 89 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,379.00 .00 214,379.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 2268 08/31/2016 August A/P overnight shipping 42.77 3.70 46.47 FEDERAL EXPRESS CORP 2283 AP _______________ Account: 122-60035-045-000 Postage Totals: 3.70 46.47 ** 50.00 Budgeted 3.53 Remaining 93 % Used Account: 122-60055-045-000 Insurance 142 08/01/2016 Prepaid Insurance, W/C Aug 8,288.74 1,173.08 9,461.82 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1763 08/01/2016 Breakout Fire W/C from Ins 8,288.74 (781.58) 8,680.24 GL _______________ Account: 122-60055-045-000 Insurance Totals: 391.50 8,680.24 ** 18,451.00 Budgeted 9,770.76 Remaining 47 % 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 3,338.39 .00 3,338.39 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 3,338.39 ** 6,880.00 Budgeted 3,541.61 Remaining 49 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 2147 08/12/2016 Fire Dept P/R 8/12/16 958.34 189.00 1,147.34 GL _______________ Account: 122-60100-045-000 Travel & per diem Totals: 189.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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-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 2269 08/26/2016 August A/P ADVISION 3,073.25 352.00 3,425.25 ADVISION PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 352.00 3,425.25 ** 7,500.00 Budgeted 4,074.75 Remaining 46 % 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 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 838.01 .00 838.01 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 838.01 ** 1,001.00 Budgeted 162.99 Remaining 84 % Used Account: 122-65005-045-000 Fuel & Lube 2269 08/26/2016 August A/P RANDALLS FUEL 10017895 3,698.42 46.27 3,744.69 RANDALLS FUEL 10017895 PC 2269 08/26/2016 August A/P ROANOKE QUICK STOP 34.89 3,779.58 ROANOKE QUICK STOP PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2269 08/26/2016 August A/P ROANOKE QUICK STOP 3,698.42 31.54 3,811.12 ROANOKE QUICK STOP PC 2268 08/31/2016 August A/P 287.61 4,098.73 US Bank Voyager Fleet Systems 2325 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 400.31 4,098.73 ** 15,122.00 Budgeted 11,023.27 Remaining 27 % Used Account: 122-65010-045-000 Uniforms 2139 08/17/2016 Reverse Inv 1493, 1494 AR 20160812-20160817 User: 6,446.69 2,632.50 9,079.19 AR 2144 08/18/2016 August A/P Uniforms 75.00 9,154.19 RED THE UNIFORM TAILOR 2249 AP 2268 08/31/2016 August A/P Uniforms 169.00 9,323.19 RED THE UNIFORM TAILOR 2313 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (122.00) 9,201.19 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 2,754.50 9,201.19 ** 3,640.00 Budgeted (5,561.19) Remaining 253 % Used Account: 122-65015-045-000 Protective Clothing 4,565.93 .00 4,565.93 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 4,565.93 ** 9,000.00 Budgeted 4,434.07 Remaining 51 % 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 1,862.37 .00 1,862.37 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 1,862.37 ** 2,000.00 Budgeted 137.63 Remaining 93 % Used Account: 122-65055-045-000 Hardware 195.42 .00 195.42 _______________ Account: 122-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-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 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,281,887.25 ** 1,384,635.00 Budgeted 102,747.75 Remaining 93 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (77,392.74) .00 Budgeted 77,392.74 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 2016 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 8/31/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 789,836 - - 789,836 CASH IN BANK-SAVINGS-CASH RESERVE 180,074 - - 180,074 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 712,043 - - 712,043 INVESTMENTS-TEXPOOL 429,065 326,020 - 755,085 PREPAID EXPENSES 8,399 - - 8,399 ADVALOREM PROPERTY TAXES RECEIVABLE 1,823 - - 1,823 UTILITY AND OTHER ACCOUNTS RECEIVABLE 973,283 - - 973,283 TOTAL ASSETS 3,130,281 326,020 - 3,456,301 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,823 - - 1,823 ACCOUNTS AND OTHER PAYABLES 950,008 - - 950,008 CUSTOMER DEPOSITS 322,310 - - 322,310 - TOTAL LIABILITIES 1,274,141 - - 1,274,141 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,289,227) - (8,032) (1,297,258) - TOTAL FUND BALANCE 1,856,140 326,020 - 2,182,160 - TOTAL LIABILITIES AND FUND BALANCE 3,130,281 326,020 - 3,456,301 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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- 180.29- 57,186.52- 98.291 994.48- 135-40002-000-000 Property Taxes/Delinquent 111.72- 2,177.51- 2,177.51 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 71.36- 724.98- 111.535 74.98 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 146,125.00- Subtotal: 204,956.00- 204,956.00- 363.37- 60,089.01- 29.318 144,866.99- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 565,383.56- 3,654,743.79- 71.940 1,425,500.21- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 259,269.85- 2,084,536.58- 86.360 329,239.42- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 8,357.51- 88,766.97- 97.562 2,218.03- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 775.00- 11,975.00- 133.056 2,975.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 2,500.00- 125.000 500.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 7,350.00- 133.636 1,850.00 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 15,211.50- 40,021.70- 65.256 21,308.30- Subtotal: 7,662,835.00- 7,662,835.00- 849,597.42- 5,889,894.04- 76.863 1,772,940.96- 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,026.71- 11,581.96- 115.820 1,581.96 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 10,015.83- 91.670 910.17- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 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- 1,372.00- 50,967.72- 323.030 35,189.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- 2.40 28,782.89- 45.507 34,466.11- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 16.00- 44.40- 222.000 24.40 Subtotal: 110,993.00- 686,576.00- 3,906.17- 146,778.79- 21.378 539,797.21- Program number: 8,047,784.00- 8,609,567.00- 853,866.96- 6,151,961.84- 71.455 2,457,605.16- Department number: Revenues 8,047,784.00- 8,609,567.00- 853,866.96- 6,151,961.84- 71.455 2,457,605.16- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 853,866.96- 6,151,961.84- 71.455 2,457,605.16- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 260,062.00 16,850.90 193,400.61 74.367 66,661.39 135-50010-010-000 Overtime 19,500.00 19,500.00 595.21 11,901.09 61.031 7,598.91 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 25.00 2,175.00 60.417 1,425.00 135-50020-010-000 Retirement 25,558.00 25,018.00 1,525.22 18,474.91 73.846 6,543.09 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 34,265.46 66.667 17,132.54 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 2,583.94 64.615 1,415.06 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 581.10 63.857 328.90 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 200.95 2,160.47 77.077 642.53 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,071.86 12,947.19 71.350 5,198.81 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 250.67 3,027.95 71.363 1,215.05 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.35 11,208.33 75.968 3,545.67 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 25,205.06 296,878.60 72.409 113,125.40 135-55005-010-000 Engineering 5,000.00 109,400.00 3,820.00 102,037.08 93.270 7,362.92 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 3,978.03 77,026.14 77.413 22,473.86 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 419.00 4,469.69 55.871 3,530.31 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 207.70 4,249.44 77.263 1,250.56 Subtotal: 107,000.00 225,900.00 8,424.73 190,675.12 84.407 35,224.88 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 347.11 4,369.85 80.923 1,030.15 135-60020-010-000 Electricity 166,823.00 166,823.00 13,423.23 119,490.58 71.627 47,332.42 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 286,592.97 1,623,450.77 55.056 1,325,291.23 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 180.00 2,460.63 70.304 1,039.37 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 300,543.31 1,770,546.63 55.559 1,416,216.37 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 717.00 11,660.70 32.439 24,286.30 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 2,006.73 43.549 2,601.27 135-65030-010-000 Chemicals 12,000.00 13,000.00 1,059.40 12,282.67 94.482 717.33 135-65035-010-000 Small Tools 1,200.00 1,200.00 579.84 709.39 59.116 490.61 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 443.49 44.349 556.51 135-65050-010-000 Meter Expense 115,000.00 115,000.00 97,648.92 84.912 17,351.08 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,356.24 202,076.90 81.456 46,003.10 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 44,684.20 1,480,803.41 369.970 1,080,553.41- 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 44,684.20 1,814,639.04 247.180 1,080,502.04- Program number: 4,465,834.00 4,804,884.00 381,213.54 4,274,816.29 88.968 530,067.71 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/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 207.70 1,565.44 31.309 3,434.56 Subtotal: 5,000.00 5,000.00 207.70 1,565.44 31.309 3,434.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 207.70 1,565.44 15.654 8,434.56 Department number: Water 4,475,834.00 4,814,884.00 381,421.24 4,276,381.73 88.816 538,502.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,843.30 326,045.28 92.713 25,625.72 135-50010-020-000 Overtime 19,500.00 29,500.00 2,209.45 32,242.85 109.298 2,742.85- 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 6,875.00 95.486 325.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,710.91 32,588.98 96.841 1,063.02 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 58,392.56 88.488 7,596.44 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 3,597.87 85.991 586.13 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 813.00 83.642 159.00 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 354.95 3,760.74 102.893 105.74- 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,728.09 20,989.80 85.100 3,675.20 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 404.14 4,908.87 85.105 859.13 135-50040-020-000 Unemployment Taxes 1,449.00 1,204.00 1,203.57 99.964 .43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 6,226.24 66.827 3,090.76 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 176.54 674.35 103.746 24.35- Subtotal: 535,097.00 544,852.00 43,161.74 504,682.56 92.627 40,169.44 135-55070-020-000 Independent Labor 50,000.00 50,000.00 18,573.00- 5,915.45 11.831 44,084.55 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 3,664.00 102,820.41 123.731 19,720.41- 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 29.97 6,975.15 93.002 524.85 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 447.62 738.62 147.724 238.62- 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 1,731.41 35,716.91 64.940 19,283.09 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,700.00 35,459.40 101.313 459.40- Subtotal: 218,100.00 231,100.00 10,000.00- 187,625.94 81.188 43,474.06 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 412.16 5,476.10 101.409 76.10- 135-60020-020-000 Electricity 161,582.00 161,582.00 19,424.48 111,179.42 68.807 50,402.58 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 100.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 43.74 957.01 59.813 642.99 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 2,700.00 8,638.50 95.983 361.50 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 910.00 15,488.74 41.692 21,661.26 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 19,951.00 119,706.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 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 86,761.70 834,044.20 91.812 74,378.80 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 656.66 9,428.98 29.446 22,592.02 135-65010-020-000 Uniforms 4,241.00 4,241.00 94.49 2,949.17 69.539 1,291.83 135-65030-020-000 Chemicals 27,000.00 27,000.00 1,778.84 28,882.09 106.971 1,882.09- 135-65035-020-000 Small Tools 2,000.00 2,000.00 867.41 43.371 1,132.59 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 256.07 14,591.36 112.241 1,591.36- Subtotal: 79,012.00 79,012.00 2,786.06 57,295.60 72.515 21,716.40 135-69005-020-000 Capital Outlays 150,000.00 356,000.00 269,447.28 75.687 86,552.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 290,921.08 77.070 86,555.92 Program number: 1,912,109.00 2,140,864.00 122,709.50 1,874,569.38 87.561 266,294.62 Department number: Wastewater 1,912,109.00 2,140,864.00 122,709.50 1,874,569.38 87.561 266,294.62 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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,100.00 7,800.00 62.400 4,700.00 135-50030-026-000 Social Security Taxes 775.00 775.00 68.20 483.60 62.400 291.40 135-50035-026-000 Medicare Taxes 181.00 181.00 15.95 113.10 62.486 67.90 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.08 46.89 93.780 3.11 Subtotal: 13,723.00 13,518.00 1,187.23 8,445.09 62.473 5,072.91 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 76.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 76.00 5,933.48 46.175 6,916.52 Program number: 26,573.00 26,368.00 1,263.23 14,378.57 54.530 11,989.43 Department number: Board of Directors 26,573.00 26,368.00 1,263.23 14,378.57 54.530 11,989.43 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 38,228.38 435,827.27 88.290 57,805.73 135-50010-030-000 Overtime 1,000.00 500.00 54.07 576.08 115.216 76.08- 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,652.00 3,308.53 38,613.13 88.457 5,038.87 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 4,773.31 56,169.37 82.365 12,026.63 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 322.65 3,846.14 80.011 960.86 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 76.67 894.34 80.282 219.66 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 401.18 4,316.43 79.478 1,114.57 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 2,193.52 25,469.62 81.788 5,671.38 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 513.00 5,956.59 77.580 1,721.41 135-50040-030-000 Unemployment Taxes 1,449.00 1,197.00 36.85 1,233.85 103.079 36.85- 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,918.79 123.474 364.79- 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 147.45 147.45 29.490 352.55 135-50070-030-000 Employee Relations 5,000.00 4,500.00 300.22 3,401.17 75.582 1,098.83 Subtotal: 662,006.00 667,726.00 50,503.72 582,192.73 87.190 85,533.27 135-55030-030-000 Software & Support 78,483.00 81,097.00 1,437.37 43,311.41 53.407 37,785.59 135-55070-030-000 Independent Labor 12,000.00 12,000.00 1,288.63 10.739 10,711.37 135-55080-030-000 Maintenance & Repairs 29,500.00 7,000.00 196.00 6,284.35 89.776 715.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 196.33 6,721.92 96.027 278.08 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 5,588.50 55.195 4,536.50 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 4,065.00 67,112.88 92.474 5,462.12 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 1,206.30 7,917.61 96.556 282.39 Subtotal: 206,583.00 198,197.00 7,685.75 138,225.30 69.741 59,971.70 135-60005-030-000 Telephone 16,349.00 16,349.00 1,039.02 12,621.93 77.203 3,727.07 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 37.99 3,853.29 92.850 296.71 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 425.53 5,287.80 49.107 5,480.20 135-60025-030-000 Water 1,500.00 1,500.00 135.13 791.46 52.764 708.54 135-60035-030-000 Postage 28,932.00 28,932.00 3,491.33 25,460.21 88.000 3,471.79 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 3,472.29 47,177.13 84.912 8,382.87 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,022.62 86.361 477.38 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 30,817.00 58.369 21,980.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 5,466.25 91.104 533.75 135-60075-030-000 Meetings 400.00 400.00 58.25 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 28.30 3,386.61 62.715 2,013.39 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 3,210.41 42.805 4,289.59 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 818.62 1,030.36 13.738 6,469.64 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 5,302.48 30.298 12,198.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 12,262.46 156,119.63 65.475 82,322.37 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 1,366.56 7,238.41 53.247 6,355.59 135-65085-030-000 Office Supplies 9,000.00 9,000.00 404.54 5,208.50 57.872 3,791.50 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 1,004.63 25.097 2,998.37 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 3,412.88 68.258 1,587.12 135-65105-030-000 Printing 4,800.00 4,800.00 93.73 3,187.99 66.416 1,612.01 Subtotal: 54,252.00 38,252.00 1,864.83 20,075.41 52.482 18,176.59 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 2,590.63 24,907.03 44.477 31,092.97 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 376.74 3,290.15 71.525 1,309.85 Subtotal: 60,600.00 60,600.00 2,967.37 28,197.18 46.530 32,402.82 Program number: 1,210,323.00 1,203,217.00 75,284.13 924,810.25 76.861 278,406.75 Department number: Administration 1,210,323.00 1,203,217.00 75,284.13 924,810.25 76.861 278,406.75 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 13:20 09/15/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 82,269.23 316,446.79 81.953 69,683.21 135-55055-039-000 Auditing 22,750.00 24,039.00 24,039.38 100.002 .38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 8,093.66 78.847 2,171.34 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 82,269.23 351,048.65 82.749 73,185.35 Program number: 422,945.00 424,234.00 82,269.23 351,048.65 82.749 73,185.35 Department number: Non Departmental 422,945.00 424,234.00 82,269.23 351,048.65 82.749 73,185.35 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 662,947.33 7,441,188.58 86.429 1,168,378.42 Fund number: 135 MUD 1 General Fund 190,919.63- 1,289,226.74 1,289,226.74- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 13:20 09/15/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/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 13:20 09/15/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/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 13:20 09/15/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 8/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 13 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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 2253 08/01/2016 Property Taxes (57,006.23) (21.70) (57,027.93) GL 2255 08/02/2016 Property Taxes (35.44) (57,063.37) GL 2256 08/03/2016 Property Taxes (1.54) (57,064.91) GL 2258 08/04/2016 Property Taxes (9.31) (57,074.22) GL 2259 08/08/2016 Property Taxes (4.72) (57,078.94) GL 2260 08/09/2016 Property Taxes (82.31) (57,161.25) GL 2261 08/12/2016 Property Taxes (2.59) (57,163.84) GL 2262 08/18/2016 Property Taxes (2.18) (57,166.02) GL 2287 08/22/2016 Property Taxes (9.58) (57,175.60) GL 2288 08/23/2016 Property Taxes (12.10) (57,187.70) GL 2290 08/26/2016 Property Taxes 1.18 (57,186.52) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (180.29) (57,186.52) ** (58,181.00) Budgeted (994.48) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2253 08/01/2016 Property Taxes (2,065.79) (1.39) (2,067.18) GL 2255 08/02/2016 Property Taxes (78.85) (2,146.03) GL 2260 08/09/2016 Property Taxes (30.44) (2,176.47) GL 2289 08/25/2016 Property Taxes (1.04) (2,177.51) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (111.72) (2,177.51) ** .00 Budgeted 2,177.51 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2253 08/01/2016 Property Taxes (653.62) (.38) (654.00) GL 2255 08/02/2016 Property Taxes (15.32) (669.32) GL 2258 08/04/2016 Property Taxes (3.55) (672.87) GL 2259 08/08/2016 Property Taxes (.40) (673.27) GL 2260 08/09/2016 Property Taxes (50.01) (723.28) GL 2261 08/12/2016 Property Taxes (.18) (723.46) GL 2262 08/18/2016 Property Taxes (.15) (723.61) GL 2287 08/22/2016 Property Taxes (.77) (724.38) GL 2288 08/23/2016 Property Taxes (.60) (724.98) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (71.36) (724.98) ** (650.00) Budgeted 74.98 Remaining 112 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-40025-000-000 PID Surcharges Totals: .00 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 2225 08/25/2016 UB 8/25/16 Adj UB20160825-20160825 User: (3,089,360.23) 30.82 (3,089,329.41) UB 2227 08/26/2016 UB 8/26/16 Adj UB20160826-20160826 User: 27.16 (3,089,302.25) UB 2201 08/31/2016 UB 8/31/2006 Billing UB20160831-20160831 User: (565,441.54) (3,654,743.79) UB _______________ Account: 135-47000-000-000 Water Totals: (565,383.56) (3,654,743.79) ** (5,080,244.00) Budgeted (1,425,500.21) Remaining 72 % Used Account: 135-47005-000-000 Sewer 2225 08/25/2016 UB 8/25/16 Adj UB20160825-20160825 User: (1,825,266.73) 25.60 (1,825,241.13) UB 2227 08/26/2016 UB 8/26/16 Adj UB20160826-20160826 User: 20.34 (1,825,220.79) UB 2201 08/31/2016 UB 8/31/2006 Billing UB20160831-20160831 User: (259,315.79) (2,084,536.58) UB _______________ Account: 135-47005-000-000 Sewer Totals: (259,269.85) (2,084,536.58) ** (2,413,776.00) Budgeted (329,239.42) Remaining 86 % Used Account: 135-47025-000-000 Penalties 2161 08/23/2016 UB 8/23/16 Penalties UB20160823-20160823 User: (80,409.46) (8,800.16) (89,209.62) UB 2221 08/23/2016 UB 8/23/16 Penalty removal UB20160823-20160823 User: 99.94 (89,109.68) UB 2229 08/31/2016 UB 8/31/16 Penalty adj UB20160831-20160831 User: 342.71 (88,766.97) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,357.51) (88,766.97) ** (90,985.00) Budgeted (2,218.03) Remaining 98 % Used Account: 135-47030-000-000 Service Charges 2097 08/09/2016 UB 8/9/16 Cut Off Fees UB20160809-20160809 User: (11,200.00) (700.00) (11,900.00) UB 2215 08/12/2016 UB 8/12/16 NSF Check fee UB20160812-20160812 User: (25.00) (11,925.00) UB 2220 08/22/2016 UB 8/22/16 penalty removal UB20160822-20160822 User: (25.00) (11,950.00) UB 2222 08/23/2016 UB 8/23/16 NSF Check fe UB20160823-20160823 User: (25.00) (11,975.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (775.00) (11,975.00) ** (9,000.00) Budgeted 2,975.00 Remaining 133 % Used Account: 135-47035-000-000 Plumbing Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (2,350.00) (150.00) (2,500.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,500.00) ** (2,000.00) Budgeted 500.00 Remaining 125 % Used Account: 135-47045-000-000 Sewer Inspections 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (6,900.00) (450.00) (7,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (7,350.00) ** (5,500.00) Budgeted 1,850.00 Remaining 134 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2201 08/31/2016 UB 8/31/2006 Billing UB20160831-20160831 User: (24,810.20) (15,211.50) (40,021.70) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (15,211.50) (40,021.70) ** (61,330.00) Budgeted (21,308.30) Remaining 65 % 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 2300 08/31/2016 August Bank Interest (10,555.25) (396.69) (10,951.94) GL 2300 08/31/2016 August Bank Interest (160.90) (11,112.84) GL 2300 08/31/2016 August Bank Interest Texpool/General Fund (469.12) (11,581.96) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,026.71) (11,581.96) ** (10,000.00) Budgeted 1,581.96 Remaining 116 % Used Account: 135-49016-000-000 Cell Tower Revenue 2059 08/02/2016 AT&T Cell Tower Revenue (9,105.30) (910.53) (10,015.83) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,015.83) ** (10,926.00) Budgeted (910.17) Remaining 92 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % 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 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (49,595.72) (1,372.00) (50,967.72) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,372.00) (50,967.72) ** (15,778.00) Budgeted 35,189.72 Remaining 323 % 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 2220 08/22/2016 UB 8/22/16 penalty removal UB20160822-20160822 User: (28,785.29) 53.54 (28,731.75) UB 2201 08/31/2016 UB 8/31/2006 Billing UB20160831-20160831 User: (51.14) (28,782.89) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: 2.40 (28,782.89) ** (63,249.00) Budgeted (34,466.11) Remaining 46 % Used Account: 135-49901-000-000 Records Management Revenue . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2286 08/30/2016 Open Records/Lynch (28.40) (16.00) (44.40) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (16.00) (44.40) ** (20.00) Budgeted 24.40 Remaining 222 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,151,961.84) ** (8,609,567.00) Budgeted (2,457,605.16) Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 2104 08/12/2016 MUD Payroll 8/12/16 Salaries & Wages 176,549.71 8,425.45 184,975.16 PR 2174 08/26/2016 MUD Payroll 8/26/16 Salaries & Wages 8,425.45 193,400.61 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,850.90 193,400.61 ** 260,062.00 Budgeted 66,661.39 Remaining 74 % Used Account: 135-50010-010-000 Overtime 2104 08/12/2016 MUD Payroll 8/12/16 Overtime 11,305.88 379.63 11,685.51 PR 2174 08/26/2016 MUD Payroll 8/26/16 Overtime 215.58 11,901.09 PR _______________ Account: 135-50010-010-000 Overtime Totals: 595.21 11,901.09 ** 19,500.00 Budgeted 7,598.91 Remaining 61 % 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 2174 08/26/2016 MUD Payroll 8/26/16 Certification 2,150.00 25.00 2,175.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 25.00 2,175.00 ** 3,600.00 Budgeted 1,425.00 Remaining 60 % Used Account: 135-50020-010-000 Retirement 2104 08/12/2016 MUD Payroll 8/12/16 Retirement 16,949.69 768.68 17,718.37 PR 2174 08/26/2016 MUD Payroll 8/26/16 Retirement 756.54 18,474.91 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,525.22 18,474.91 ** 25,018.00 Budgeted 6,543.09 Remaining 74 % Used Account: 135-50026-010-000 Medical Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Medical Insurance 31,104.31 1,580.60 32,684.91 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medical Insurance 1,580.55 34,265.46 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 34,265.46 ** 51,398.00 Budgeted 17,132.54 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Dental Insurance 2,343.17 120.39 2,463.56 PR 2174 08/26/2016 MUD Payroll 8/26/16 Dental Insurance 120.38 2,583.94 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 2,583.94 ** 3,999.00 Budgeted 1,415.06 Remaining 65 % Used Account: 135-50028-010-000 Vision Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Vision Insurance 527.12 27.01 554.13 PR 2174 08/26/2016 MUD Payroll 8/26/16 Vision Insurance 26.97 581.10 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 581.10 ** 910.00 Budgeted 328.90 Remaining 64 % Used Account: 135-50029-010-000 Life Insurance & Other 2090 08/08/2016 August A/P Dental, Vision, STD, LTD, Vol 1,959.52 191.24 2,150.76 METLIFE GROUP BENEFITS 2194 AP 2144 08/18/2016 August A/P Café 125 Admin 9.71 2,160.47 BenefitMall 2235 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 200.95 2,160.47 ** 2,803.00 Budgeted 642.53 Remaining 77 % Used Account: 135-50030-010-000 Social Security Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Social Security Taxes 11,875.33 542.88 12,418.21 PR 2174 08/26/2016 MUD Payroll 8/26/16 Social Security Taxes 528.98 12,947.19 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,071.86 12,947.19 ** 18,146.00 Budgeted 5,198.81 Remaining 71 % Used Account: 135-50035-010-000 Medicare Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Medicare Taxes 2,777.28 126.97 2,904.25 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medicare Taxes 123.70 3,027.95 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 250.67 3,027.95 ** 4,243.00 Budgeted 1,215.05 Remaining 71 % Used Account: 135-50040-010-000 Unemployment Taxes 859.06 .00 859.06 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 859.06 ** 1,026.00 Budgeted 166.94 Remaining 84 % Used Account: 135-50045-010-000 Workman's Compensation 142 08/01/2016 Prepaid Insurance, W/C Aug 9,978.98 1,229.35 11,208.33 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 11,208.33 ** 14,754.00 Budgeted 3,545.67 Remaining 76 % 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 2144 08/18/2016 August A/P Town Hall Plan Review 98,217.08 213.75 98,430.83 CP&Y/WALLACE GROUP, INC. 2236 AP 2144 08/18/2016 August A/P TCMUD Rate Case/PUC 390.00 98,820.83 CP&Y/WALLACE GROUP, INC. 2236 AP 2144 08/18/2016 August A/P Utility Mapping 3,216.25 102,037.08 CP&Y/WALLACE GROUP, INC. 2236 AP _______________ Account: 135-55005-010-000 Engineering Totals: 3,820.00 102,037.08 ** 109,400.00 Budgeted 7,362.92 Remaining 93 % Used Account: 135-55080-010-000 Maintenance & Repairs 2269 08/26/2016 August A/P THE HOME DEPOT #6581 73,048.11 29.28 73,077.39 THE HOME DEPOT #6581 PC 2268 08/31/2016 August A/P mowing-august 750.00 73,827.39 WATTS ELLISON LLC 2327 AP 2268 08/31/2016 August A/P 3 Glendale Driveway 3,156.75 76,984.14 REY-MAR CONSTRUCTION 2314 AP 2268 08/31/2016 August A/P Tank rental 42.00 77,026.14 ALLIED WELDING SUPPLY, INC 2264 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,978.03 77,026.14 ** 99,500.00 Budgeted 22,473.86 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-55090-010-000 Vehicle Maintenance 2269 08/26/2016 August A/P DISCOUNT TIRE TXD 75 4,050.69 419.00 4,469.69 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 419.00 4,469.69 ** 8,000.00 Budgeted 3,530.31 Remaining 56 % 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 2268 08/31/2016 August A/P TCEQ samples-MUD 4,041.74 207.70 4,249.44 LOWER COLORADO RIVER AUTHORITY 2300 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 207.70 4,249.44 ** 5,500.00 Budgeted 1,250.56 Remaining 77 % Used Account: 135-60010-010-000 Communications/Mobiles 2273 08/31/2016 August A/P August Cell phones 4,022.74 347.11 4,369.85 VERIZON WIRELESS 2326 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 347.11 4,369.85 ** 5,400.00 Budgeted 1,030.15 Remaining 81 % Used Account: 135-60020-010-000 Electricity 2144 08/18/2016 August A/P Electricity 7/8-8/8/16 106,067.35 95.75 106,163.10 HUDSON ENERGY SERVICES, LLC 2240 AP 2268 08/31/2016 August A/P Electricity 7/11-8/9/16 13,327.48 119,490.58 HUDSON ENERGY SERVICES, LLC 2287 AP _______________ Account: 135-60020-010-000 Electricity Totals: 13,423.23 119,490.58 ** 166,823.00 Budgeted 47,332.42 Remaining 72 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 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 2268 08/31/2016 August A/P wholesale watering 1,336,857.80 286,592.97 1,623,450.77 CITY OF FORT WORTH 2271 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60150-010-000 Wholesale Water Totals: 286,592.97 1,623,450.77 ** 2,948,742.00 Budgeted 1,325,291.23 Remaining 55 % 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 2269 08/26/2016 August A/P DENTON SAND & GRAVEL, 2,280.63 72.00 2,352.63 DENTON SAND & GRAVEL, PC 2269 08/26/2016 August A/P DENTON SAND & GRAVEL, 108.00 2,460.63 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 180.00 2,460.63 ** 3,500.00 Budgeted 1,039.37 Remaining 70 % 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 .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 2268 08/31/2016 August A/P 10,943.70 717.00 11,660.70 US Bank Voyager Fleet Systems 2325 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 717.00 11,660.70 ** 35,947.00 Budgeted 24,286.30 Remaining 32 % Used Account: 135-65010-010-000 Uniforms 2,006.73 .00 2,006.73 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-010-000 Uniforms Totals: .00 2,006.73 ** 4,608.00 Budgeted 2,601.27 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 2268 08/31/2016 August A/P chlorine 11,223.27 1,059.40 12,282.67 DPC INDUSTRIES, INC 2278 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,059.40 12,282.67 ** 13,000.00 Budgeted 717.33 Remaining 94 % Used Account: 135-65035-010-000 Small Tools 2269 08/26/2016 August A/P THE HOME DEPOT #6581 129.55 579.84 709.39 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 579.84 709.39 ** 1,200.00 Budgeted 490.61 Remaining 59 % Used Account: 135-65040-010-000 Safety Equipment 443.49 .00 443.49 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 443.49 ** 1,000.00 Budgeted 556.51 Remaining 44 % Used Account: 135-65050-010-000 Meter Expense 97,648.92 .00 97,648.92 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 97,648.92 ** 115,000.00 Budgeted 17,351.08 Remaining 85 % 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 2151 08/19/2016 August A/P Refurbish pump housing 1,436,119.21 5,256.53 1,441,375.74 SMITH PUMP COMPANY, INC. 2250 AP 2268 08/31/2016 August A/P Replace Meter Valve 8,572.40 1,449,948.14 REY-MAR CONSTRUCTION 2314 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2274 08/31/2016 August A/P Pebble Beach, Pin Oak Ct, Timb 1,436,119.21 30,855.27 1,480,803.41 MCCLENDON CONSTRUCTION CO INC 2304 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 44,684.20 1,480,803.41 ** 400,250.00 Budgeted (1,080,553.41) Remaining 370 % 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 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 2268 08/31/2016 August A/P TCEQ samples-PID 1,357.74 207.70 1,565.44 LOWER COLORADO RIVER AUTHORITY 2301 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 207.70 1,565.44 ** 5,000.00 Budgeted 3,434.56 Remaining 31 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/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-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,276,381.73 ** 4,814,884.00 Budgeted 538,502.27 Remaining 89 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 2104 08/12/2016 MUD Payroll 8/12/16 Salaries & Wages 297,201.98 14,421.65 311,623.63 PR 2174 08/26/2016 MUD Payroll 8/26/16 Salaries & Wages 14,421.65 326,045.28 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,843.30 326,045.28 ** 351,671.00 Budgeted 25,625.72 Remaining 93 % Used Account: 135-50010-020-000 Overtime 2104 08/12/2016 MUD Payroll 8/12/16 Overtime 30,033.40 867.77 30,901.17 PR 2174 08/26/2016 MUD Payroll 8/26/16 Overtime 1,341.68 32,242.85 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,209.45 32,242.85 ** 29,500.00 Budgeted (2,742.85) Remaining 109 % 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 6,875.00 .00 6,875.00 _______________ Account: 135-50017-020-000 Certification Totals: .00 6,875.00 ** 7,200.00 Budgeted 325.00 Remaining 95 % Used Account: 135-50020-020-000 Retirement 2104 08/12/2016 MUD Payroll 8/12/16 Retirement 29,878.07 1,334.76 31,212.83 PR 2174 08/26/2016 MUD Payroll 8/26/16 Retirement 1,376.15 32,588.98 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,710.91 32,588.98 ** 33,652.00 Budgeted 1,063.02 Remaining 97 % Used Account: 135-50026-020-000 Medical Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Medical Insurance 52,860.59 2,765.99 55,626.58 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medical Insurance 2,765.98 58,392.56 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 58,392.56 ** 65,989.00 Budgeted 7,596.44 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Dental Insurance 3,249.96 173.97 3,423.93 PR 2174 08/26/2016 MUD Payroll 8/26/16 Dental Insurance 173.94 3,597.87 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 3,597.87 ** 4,184.00 Budgeted 586.13 Remaining 86 % Used Account: 135-50028-020-000 Vision Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Vision Insurance 734.95 39.05 774.00 PR 2174 08/26/2016 MUD Payroll 8/26/16 Vision Insurance 39.00 813.00 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 813.00 ** 972.00 Budgeted 159.00 Remaining 84 % Used Account: 135-50029-020-000 Life Insurance & Other 2090 08/08/2016 August A/P Dental, Vision, STD, LTD, Vol 3,405.79 325.82 3,731.61 METLIFE GROUP BENEFITS 2194 AP 2144 08/18/2016 August A/P Café 125 Admin 29.13 3,760.74 BenefitMall 2235 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 354.95 3,760.74 ** 3,655.00 Budgeted (105.74) Remaining 103 % Used Account: 135-50030-020-000 Social Security Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Social Security Taxes 19,261.71 859.21 20,120.92 PR 2174 08/26/2016 MUD Payroll 8/26/16 Social Security Taxes 868.88 20,989.80 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,728.09 20,989.80 ** 24,665.00 Budgeted 3,675.20 Remaining 85 % Used Account: 135-50035-020-000 Medicare Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Medicare Taxes 4,504.73 200.94 4,705.67 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medicare Taxes 203.20 4,908.87 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 404.14 4,908.87 ** 5,768.00 Budgeted 859.13 Remaining 85 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,203.57 ** 1,204.00 Budgeted .43 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 142 08/01/2016 Prepaid Insurance, W/C Aug 5,449.81 776.43 6,226.24 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 6,226.24 ** 9,317.00 Budgeted 3,090.76 Remaining 67 % 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 2269 08/26/2016 August A/P DONUT HAVEN 497.81 9.75 507.56 DONUT HAVEN PC 2269 08/26/2016 August A/P SALAD BOWL 10 45.50 553.06 SALAD BOWL 10 PC 2269 08/26/2016 August A/P BABE'S- ROANOKE LLC 88.33 641.39 BABE'S- ROANOKE LLC PC 2269 08/26/2016 August A/P SAMSCLUB #4795 32.96 674.35 SAMSCLUB #4795 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 176.54 674.35 ** 650.00 Budgeted (24.35) Remaining 104 % Used Account: 135-55070-020-000 Independent Labor 2105 08/04/2016 TAS/Refund overpmt Sewer spill 24,488.45 (20,000.00) 4,488.45 GL 2269 08/26/2016 August A/P GREEN EQUIPMENT CO 1,427.00 5,915.45 GREEN EQUIPMENT CO PC _______________ Account: 135-55070-020-000 Independent Labor Totals: (18,573.00) 5,915.45 ** 50,000.00 Budgeted 44,084.55 Remaining 12 % Used Account: 135-55080-020-000 Maintenance & Repairs 2144 08/18/2016 August A/P Hydromatic Pump Repair 99,156.41 1,405.00 100,561.41 NORTH TEXAS PUMP CO. 2244 AP 2269 08/26/2016 August A/P ACTIVEDATAS 54.43 100,615.84 ACTIVEDATAS PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 207.28 100,823.12 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 (2.85) 100,820.27 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 33.65 100,853.92 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2269 08/26/2016 August A/P THE HOME DEPOT #6581 99,156.41 300.66 101,154.58 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 277.62 101,432.20 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 134.02 101,566.22 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 134.85 101,701.07 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 331.21 102,032.28 THE HOME DEPOT #6581 PC 2269 08/26/2016 August A/P THE HOME DEPOT #6581 198.13 102,230.41 THE HOME DEPOT #6581 PC 2268 08/31/2016 August A/P mowing-august 590.00 102,820.41 WATTS ELLISON LLC 2327 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,664.00 102,820.41 ** 83,100.00 Budgeted (19,720.41) Remaining 124 % Used Account: 135-55090-020-000 Vehicle Maintenance 2269 08/26/2016 August A/P AUTOZONE #4206 6,945.18 29.97 6,975.15 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 29.97 6,975.15 ** 7,500.00 Budgeted 524.85 Remaining 93 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2269 08/26/2016 August A/P STUART HOSE & PIPE-FT 291.00 101.12 392.12 STUART HOSE & PIPE-FT PC 2269 08/26/2016 August A/P DISCOUNT-TIRE-CO TXD-0 176.50 568.62 DISCOUNT-TIRE-CO TXD-0 PC 2268 08/31/2016 August A/P flat repairs-backhoe 170.00 738.62 BLAGG TIRE & SERVICE 2265 AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 447.62 738.62 ** 500.00 Budgeted (238.62) Remaining 148 % Used Account: 135-55125-020-000 Dumpster Services 2144 08/18/2016 August A/P Sludge haul off 33,985.50 845.00 34,830.50 L.H. CHANEY MATERIALS, INC. 2241 AP 2268 08/31/2016 August A/P sludge haul off 886.41 35,716.91 L.H. CHANEY MATERIALS, INC. 2294 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,731.41 35,716.91 ** 55,000.00 Budgeted 19,283.09 Remaining 65 % Used Account: 135-55135-020-000 Lab Analysis 2090 08/08/2016 August A/P Testing 32,759.40 246.00 33,005.40 OXIDOR LABORATORIES LLC 2200 AP 2090 08/08/2016 August A/P Testing 176.00 33,181.40 OXIDOR LABORATORIES LLC 2200 AP 2144 08/18/2016 August A/P Testing 246.00 33,427.40 OXIDOR LABORATORIES LLC 2247 AP 2144 08/18/2016 August A/P Testing 176.00 33,603.40 OXIDOR LABORATORIES LLC 2247 AP 2268 08/31/2016 August A/P Testing 246.00 33,849.40 OXIDOR LABORATORIES LLC 2310 AP 2268 08/31/2016 August A/P Testing 176.00 34,025.40 OXIDOR LABORATORIES LLC 2310 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2268 08/31/2016 August A/P Testing 32,759.40 246.00 34,271.40 OXIDOR LABORATORIES LLC 2310 AP 2268 08/31/2016 August A/P Testing 176.00 34,447.40 OXIDOR LABORATORIES LLC 2310 AP 2268 08/31/2016 August A/P Testing 246.00 34,693.40 OXIDOR LABORATORIES LLC 2310 AP 2268 08/31/2016 August A/P Testing 176.00 34,869.40 OXIDOR LABORATORIES LLC 2310 AP 2268 08/31/2016 August A/P Bio-Monitoring 590.00 35,459.40 HUTHER AND ASSOCIATES,INC 2288 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,700.00 35,459.40 ** 35,000.00 Budgeted (459.40) Remaining 101 % Used Account: 135-60010-020-000 Communications/Mobiles 2273 08/31/2016 August A/P August Cell phones 5,063.94 412.16 5,476.10 VERIZON WIRELESS 2326 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 412.16 5,476.10 ** 5,400.00 Budgeted (76.10) Remaining 101 % Used Account: 135-60020-020-000 Electricity 2144 08/18/2016 August A/P Electricity 7/11-8/9/16 91,754.94 494.69 92,249.63 MP2 ENERGY TEXAS LLC 2243 AP 2144 08/18/2016 August A/P Electricity 7/8-8/8/16 50.33 92,299.96 HUDSON ENERGY SERVICES, LLC 2240 AP 2144 08/18/2016 August A/P Electricity 7/8-8/8/16 64.68 92,364.64 HUDSON ENERGY SERVICES, LLC 2240 AP 2144 08/18/2016 August A/P Electricity 7/11-8/9/16 92.03 92,456.67 HUDSON ENERGY SERVICES, LLC 2240 AP 2144 08/18/2016 August A/P Electricity WWTP 19.27 92,475.94 ENGIE Resources LLC 2238 AP 2268 08/31/2016 August A/P Electricity 7/11-8/9/16 416.26 92,892.20 HUDSON ENERGY SERVICES, LLC 2287 AP 2268 08/31/2016 August A/P Electricity 7/11-8/9/16 18,498.51 111,390.71 HUDSON ENERGY SERVICES, LLC 2287 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (211.29) 111,179.42 AR _______________ Account: 135-60020-020-000 Electricity Totals: 19,424.48 111,179.42 ** 161,582.00 Budgeted 50,402.58 Remaining 69 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 2269 08/26/2016 August A/P SAMSCLUB #4795 200.00 100.00 300.00 SAMSCLUB #4795 PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 100.00 300.00 ** 300.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-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 2148 08/18/2016 August A/P Tolls to take samples 913.27 23.74 937.01 NTTA 2245 AP 2269 08/26/2016 August A/P PARKING COMPANY OF AME 5.00 942.01 PARKING COMPANY OF AME PC 2269 08/26/2016 August A/P PARKING COMPANY OF AME 5.00 947.01 PARKING COMPANY OF AME PC 2269 08/26/2016 August A/P PARKING COMPANY OF AME 10.00 957.01 PARKING COMPANY OF AME PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 43.74 957.01 ** 1,600.00 Budgeted 642.99 Remaining 60 % Used Account: 135-60105-020-000 Rent/Lease Equipment 2144 08/18/2016 August A/P WWTP Rental Flygt 5,938.50 1,350.00 7,288.50 NORTH TEXAS PUMP CO. 2244 AP 2268 08/31/2016 August A/P Rental influent Pump #1 1,350.00 8,638.50 NORTH TEXAS PUMP CO. 2308 AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 2,700.00 8,638.50 ** 9,000.00 Budgeted 361.50 Remaining 96 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 2144 08/18/2016 August A/P WWTP Permit Renewal 14,578.74 810.00 15,388.74 CP&Y/WALLACE GROUP, INC. 2236 AP 2269 08/26/2016 August A/P TCEQ EPAYMENT 100.00 15,488.74 TCEQ EPAYMENT PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 910.00 15,488.74 ** 37,150.00 Budgeted 21,661.26 Remaining 42 % Used Account: 135-60245-020-000 Miscellaneous Expenses 423.24 .00 423.24 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-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 2103 08/10/2016 Texpool Transfers 99,755.00 19,951.00 119,706.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 119,706.00 ** 119,706.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 2103 08/10/2016 Texpool Transfers 401,617.20 43,220.32 444,837.52 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 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 2268 08/31/2016 August A/P 8,772.32 656.66 9,428.98 US Bank Voyager Fleet Systems 2325 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 656.66 9,428.98 ** 32,021.00 Budgeted 22,592.02 Remaining 29 % Used Account: 135-65010-020-000 Uniforms 2269 08/26/2016 August A/P CAVENDERS BOOT #7 2,854.68 94.49 2,949.17 CAVENDERS BOOT #7 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-020-000 Uniforms Totals: 94.49 2,949.17 ** 4,241.00 Budgeted 1,291.83 Remaining 70 % Used Account: 135-65030-020-000 Chemicals 2144 08/18/2016 August A/P Clarifloc 27,103.25 1,080.00 28,183.25 POLYDYNE, INC 2248 AP 2269 08/26/2016 August A/P IN *AQUAFIX, INC. 698.84 28,882.09 IN *AQUAFIX, INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 1,778.84 28,882.09 ** 27,000.00 Budgeted (1,882.09) Remaining 107 % Used Account: 135-65035-020-000 Small Tools 867.41 .00 867.41 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 867.41 ** 2,000.00 Budgeted 1,132.59 Remaining 43 % 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 2268 08/31/2016 August A/P lab dessicator 14,335.29 256.07 14,591.36 HACH COMPANY 2286 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 256.07 14,591.36 ** 13,000.00 Budgeted (1,591.36) Remaining 112 % Used Account: 135-69005-020-000 Capital Outlays 269,447.28 .00 269,447.28 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 269,447.28 ** 356,000.00 Budgeted 86,552.72 Remaining 76 % Used Account: 135-69008-020-000 Short Term Debt-Principal 21,276.80 .00 21,276.80 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-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,874,569.38 ** 2,140,864.00 Budgeted 266,294.62 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 2104 08/12/2016 MUD Payroll 8/12/16 Salaries & Wages 6,700.00 500.00 7,200.00 PR 2174 08/26/2016 MUD Payroll 8/26/16 Salaries & Wages 600.00 7,800.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,100.00 7,800.00 ** 12,500.00 Budgeted 4,700.00 Remaining 62 % Used Account: 135-50030-026-000 Social Security Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Social Security Taxes 415.40 31.00 446.40 PR 2174 08/26/2016 MUD Payroll 8/26/16 Social Security Taxes 37.20 483.60 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 68.20 483.60 ** 775.00 Budgeted 291.40 Remaining 62 % Used Account: 135-50035-026-000 Medicare Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Medicare Taxes 97.15 7.25 104.40 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medicare Taxes 8.70 113.10 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 15.95 113.10 ** 181.00 Budgeted 67.90 Remaining 62 % 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 142 08/01/2016 Prepaid Insurance, W/C Aug 43.81 3.08 46.89 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 46.89 ** 50.00 Budgeted 3.11 Remaining 94 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 2269 08/26/2016 August A/P SUBWAY 03217791 397.95 76.00 473.95 SUBWAY 03217791 PC _______________ Account: 135-60075-026-000 Meetings Totals: 76.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: ------------------------------------------------------------------------------------------------ 14,378.57 ** 26,368.00 Budgeted 11,989.43 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 2104 08/12/2016 MUD Payroll 8/12/16 Salaries & Wages 397,598.89 18,724.36 416,323.25 PR 2174 08/26/2016 MUD Payroll 8/26/16 Salaries & Wages 19,120.02 435,443.27 PR 2268 08/31/2016 August A/P Temp-front desk 384.00 435,827.27 TRINITY EMPLOYMENT SOLUTIONS 2321 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 38,228.38 435,827.27 ** 493,633.00 Budgeted 57,805.73 Remaining 88 % Used Account: 135-50010-030-000 Overtime 2104 08/12/2016 MUD Payroll 8/12/16 Overtime 522.01 2.74 524.75 PR 2174 08/26/2016 MUD Payroll 8/26/16 Overtime 51.33 576.08 PR _______________ Account: 135-50010-030-000 Overtime Totals: 54.07 576.08 ** 500.00 Budgeted (76.08) Remaining 115 % 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 2104 08/12/2016 MUD Payroll 8/12/16 Retirement 35,304.60 1,634.88 36,939.48 PR 2174 08/26/2016 MUD Payroll 8/26/16 Retirement 1,673.65 38,613.13 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,308.53 38,613.13 ** 43,652.00 Budgeted 5,038.87 Remaining 88 % Used Account: 135-50026-030-000 Medical Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Medical Insurance 51,396.06 2,228.61 53,624.67 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medical Insurance 2,544.70 56,169.37 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,773.31 56,169.37 ** 68,196.00 Budgeted 12,026.63 Remaining 82 % Used Account: 135-50027-030-000 Dental Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Dental Insurance 3,523.49 152.23 3,675.72 PR 2174 08/26/2016 MUD Payroll 8/26/16 Dental Insurance 170.42 3,846.14 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 322.65 3,846.14 ** 4,807.00 Budgeted 960.86 Remaining 80 % Used Account: 135-50028-030-000 Vision Insurance 2104 08/12/2016 MUD Payroll 8/12/16 Vision Insurance 817.67 36.10 853.77 PR 2174 08/26/2016 MUD Payroll 8/26/16 Vision Insurance 40.57 894.34 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 76.67 894.34 ** 1,114.00 Budgeted 219.66 Remaining 80 % Used Account: 135-50029-030-000 Life Insurance & Other 2090 08/08/2016 August A/P Dental, Vision, STD, LTD, Vol 3,915.25 368.04 4,283.29 METLIFE GROUP BENEFITS 2194 AP 2144 08/18/2016 August A/P Café 125 Admin 33.16 4,316.45 BenefitMall 2235 AP 2248 08/26/2016 August A/P Rounding adjustment (.02) 4,316.43 Legal Shield 2296 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 401.18 4,316.43 ** 5,431.00 Budgeted 1,114.57 Remaining 79 % Used Account: 135-50030-030-000 Social Security Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Social Security Taxes 23,276.10 1,088.81 24,364.91 PR 2174 08/26/2016 MUD Payroll 8/26/16 Social Security Taxes 1,104.71 25,469.62 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,193.52 25,469.62 ** 31,141.00 Budgeted 5,671.38 Remaining 82 % Used Account: 135-50035-030-000 Medicare Taxes 2104 08/12/2016 MUD Payroll 8/12/16 Medicare Taxes 5,443.59 254.64 5,698.23 PR 2174 08/26/2016 MUD Payroll 8/26/16 Medicare Taxes 258.36 5,956.59 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 513.00 5,956.59 ** 7,678.00 Budgeted 1,721.41 Remaining 78 % Used Account: 135-50040-030-000 Unemployment Taxes 2174 08/26/2016 MUD Payroll 8/26/16 Unemployment Taxes 1,197.00 36.85 1,233.85 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 36.85 1,233.85 ** 1,197.00 Budgeted (36.85) Remaining 103 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 142 08/01/2016 Prepaid Insurance, W/C Aug 1,770.90 147.89 1,918.79 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,918.79 ** 1,554.00 Budgeted (364.79) Remaining 123 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 2090 08/08/2016 August A/P Pre-employment testing/William 38.00 38.00 CARENOW CORPORATE 2159 AP 2268 08/31/2016 August A/P pre-employment physicals/testi 109.45 147.45 FIRST CHECK APPLICANT SCREENIN 2284 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 147.45 147.45 ** 500.00 Budgeted 352.55 Remaining 29 % Used Account: 135-50070-030-000 Employee Relations 2269 08/26/2016 August A/P OAK ST PIE AND CANDY C 3,100.95 79.00 3,179.95 OAK ST PIE AND CANDY C PC 2269 08/26/2016 August A/P DONUT HAVEN 7.55 3,187.50 DONUT HAVEN PC 2269 08/26/2016 August A/P SALAD BOWL 10 77.94 3,265.44 SALAD BOWL 10 PC 2269 08/26/2016 August A/P OAK ST PIE AND CANDY C 28.00 3,293.44 OAK ST PIE AND CANDY C PC 2269 08/26/2016 August A/P DONUT HAVEN 48.07 3,341.51 DONUT HAVEN PC 2269 08/26/2016 August A/P AMYS HALLMARK 369 37.31 3,378.82 AMYS HALLMARK 369 PC 2269 08/26/2016 August A/P RANDALLS STORE00017897 5.19 3,384.01 RANDALLS STORE00017897 PC 2269 08/26/2016 August A/P WALGREENS #6047 9.18 3,393.19 WALGREENS #6047 PC 2269 08/26/2016 August A/P RANDALLS STORE00017897 7.98 3,401.17 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 300.22 3,401.17 ** 4,500.00 Budgeted 1,098.83 Remaining 76 % Used Account: 135-55030-030-000 Software & Support 2144 08/18/2016 August A/P Internet 41,874.04 1,120.77 42,994.81 WHOLESALE CARRIER SERVICES INC 2257 AP 2269 08/26/2016 August A/P ATT*BILL PAYMENT 150.14 43,144.95 ATT*BILL PAYMENT PC 2269 08/26/2016 August A/P ATT*BILL PAYMENT 166.46 43,311.41 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,437.37 43,311.41 ** 81,097.00 Budgeted 37,785.59 Remaining 53 % Used Account: 135-55070-030-000 Independent Labor 1,288.63 .00 1,288.63 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 1,288.63 ** 12,000.00 Budgeted 10,711.37 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-030-000 Maintenance & Repairs 2268 08/31/2016 August A/P MUD building ac 6,088.35 196.00 6,284.35 BRANDON R REED 2267 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 196.00 6,284.35 ** 7,000.00 Budgeted 715.65 Remaining 90 % Used Account: 135-55100-030-000 Building Maint & Supplies 2277 08/31/2016 August A/P Rug Service 6,525.59 130.89 6,656.48 G & K SERVICES 2330 AP 2277 08/31/2016 August A/P Rug Service 130.89 6,787.37 G & K SERVICES 2330 AP 2277 08/31/2016 August A/P Rug Service 130.89 6,918.26 G & K SERVICES 2330 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (196.34) 6,721.92 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 196.33 6,721.92 ** 7,000.00 Budgeted 278.08 Remaining 96 % Used Account: 135-55120-030-000 Cleaning Services 2268 08/31/2016 August A/P July Janitorial service 5,003.75 843.75 5,847.50 MEMBER'S BUILDING MAINTENANCE 2306 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (259.00) 5,588.50 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 5,588.50 ** 10,125.00 Budgeted 4,536.50 Remaining 55 % Used Account: 135-55160-030-000 Professional Outside Services 2268 08/31/2016 August A/P Rate assistance 63,047.88 4,065.00 67,112.88 NEW GEN STRATEGIES & SOLUTIONS 2307 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 4,065.00 67,112.88 ** 72,575.00 Budgeted 5,462.12 Remaining 92 % 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 2144 08/18/2016 August A/P Utility billing 6,711.31 616.90 7,328.21 DATAPROSE LLC 2237 AP 2268 08/31/2016 August A/P Aug utility billing 589.40 7,917.61 DATAPROSE LLC 2275 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-55205-030-000 Utility Billing Contract Totals: 1,206.30 7,917.61 ** 8,200.00 Budgeted 282.39 Remaining 97 % Used Account: 135-60005-030-000 Telephone 2269 08/26/2016 August A/P ATT*BUS PHONE PMT 11,582.91 823.24 12,406.15 ATT*BUS PHONE PMT PC 2269 08/26/2016 August A/P ATT*BUS PHONE PMT 445.04 12,851.19 ATT*BUS PHONE PMT PC 2269 08/26/2016 August A/P RINGCENTRAL, INC 10.73 12,861.92 RINGCENTRAL, INC PC 2268 08/31/2016 August A/P Answering service 200.32 13,062.24 KEYSTONE PARK SECRETARIAL 2292 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (440.31) 12,621.93 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,039.02 12,621.93 ** 16,349.00 Budgeted 3,727.07 Remaining 77 % Used Account: 135-60010-030-000 Communications/Mobiles 2273 08/31/2016 August A/P August Cell phones 3,815.30 37.99 3,853.29 VERIZON WIRELESS 2326 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 37.99 3,853.29 ** 4,150.00 Budgeted 296.71 Remaining 93 % Used Account: 135-60020-030-000 Electricity/Gas 2268 08/31/2016 August A/P Gexa, Interim Fire Chief 4,862.27 425.53 5,287.80 TOWN OF TROPHY CLUB 2319 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 425.53 5,287.80 ** 10,768.00 Budgeted 5,480.20 Remaining 49 % Used Account: 135-60025-030-000 Water 2268 08/31/2016 August A/P Water-MUD/PS Bldgs 656.33 270.26 926.59 TROPHY CLUB MUD (WATER BILLS) 2322 AP 2310 08/31/2016 Town Billing/August AR 20160831-20160831 User: (135.13) 791.46 AR _______________ Account: 135-60025-030-000 Water Totals: 135.13 791.46 ** 1,500.00 Budgeted 708.54 Remaining 53 % Used Account: 135-60035-030-000 Postage 2144 08/18/2016 August A/P Utility billing 21,968.88 1,725.35 23,694.23 DATAPROSE LLC 2237 AP 2269 08/26/2016 August A/P FEDEX 783657979547 59.50 23,753.73 FEDEX 783657979547 PC 2268 08/31/2016 August A/P overnight letter 19.53 23,773.26 FEDERAL EXPRESS CORP 2283 AP 2268 08/31/2016 August A/P Aug utility billing 1,686.95 25,460.21 DATAPROSE LLC 2275 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60035-030-000 Postage Totals: 3,491.33 25,460.21 ** 28,932.00 Budgeted 3,471.79 Remaining 88 % Used Account: 135-60040-030-000 Service Charges & Fees 2291 08/02/2016 Credit card fees 43,704.84 3,386.45 47,091.29 GL 2291 08/02/2016 Credit card fees 82.84 47,174.13 GL 2306 08/02/2016 Rev Credit card fees/duplicate (3,386.45) 43,787.68 GL 2306 08/02/2016 Rev Credit card fees/duplicate (82.84) 43,704.84 GL 2106 08/03/2016 Credit card fees 82.84 43,787.68 GL 2106 08/03/2016 Credit card fees 3,386.45 47,174.13 GL 2110 08/12/2016 Child support fee 1.50 47,175.63 GL 2175 08/26/2016 Child support fee 1.50 47,177.13 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,472.29 47,177.13 ** 55,560.00 Budgeted 8,382.87 Remaining 85 % Used Account: 135-60050-030-000 Bad Debt Expense 3,022.62 .00 3,022.62 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 3,022.62 ** 3,500.00 Budgeted 477.38 Remaining 86 % Used Account: 135-60055-030-000 Insurance 142 08/01/2016 Prepaid Insurance, W/C Aug 28,061.00 2,756.00 30,817.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 30,817.00 ** 52,797.00 Budgeted 21,980.00 Remaining 58 % 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 5,466.25 .00 5,466.25 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 5,466.25 ** 6,000.00 Budgeted 533.75 Remaining 91 % Used Account: 135-60075-030-000 Meetings 2269 08/26/2016 August A/P RANDALLS STORE00017897 105.11 40.55 145.66 RANDALLS STORE00017897 PC 2269 08/26/2016 August A/P DONUT HAVEN 17.70 163.36 DONUT HAVEN PC _______________ Account: 135-60075-030-000 Meetings Totals: 58.25 163.36 ** 400.00 Budgeted 236.64 Remaining 41 % Used Account: 135-60079-030-000 Public Education 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 2104 08/12/2016 MUD Payroll 8/12/16 Travel & per diem 3,358.31 28.30 3,386.61 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 28.30 3,386.61 ** 5,400.00 Budgeted 2,013.39 Remaining 63 % 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 3,210.41 .00 3,210.41 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60115-030-000 Elections Totals: .00 3,210.41 ** 7,500.00 Budgeted 4,289.59 Remaining 43 % Used Account: 135-60125-030-000 Advertising 2269 08/26/2016 August A/P TRWA 211.74 55.00 266.74 TRWA PC 2268 08/31/2016 August A/P Employment ad 150.00 416.74 TX MUNICIPAL LEAGUE 2324 AP 2268 08/31/2016 August A/P 2016 Tax Rate 613.62 1,030.36 ALLIANCE REGIONAL NEWSPAPERS 2263 AP _______________ Account: 135-60125-030-000 Advertising Totals: 818.62 1,030.36 ** 7,500.00 Budgeted 6,469.64 Remaining 14 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 5,302.48 .00 5,302.48 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 5,302.48 ** 17,501.00 Budgeted 12,198.52 Remaining 30 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2090 08/08/2016 August A/P Dell laptop 5,871.85 1,226.59 7,098.44 M3 Networks 2191 AP 2268 08/31/2016 August A/P Kristin's computer upgrade 139.97 7,238.41 M3 Networks 2302 AP _______________ Account: 135-65055-030-000 Hardware Totals: 1,366.56 7,238.41 ** 13,594.00 Budgeted 6,355.59 Remaining 53 % Used Account: 135-65085-030-000 Office Supplies 2144 08/18/2016 August A/P Office supplies 4,803.96 88.73 4,892.69 OFFICE DEPOT, INC 2246 AP 2269 08/26/2016 August A/P OFFICE DEPOT #406 21.49 4,914.18 OFFICE DEPOT #406 PC 2269 08/26/2016 August A/P OFFICE DEPOT #406 22.38 4,936.56 OFFICE DEPOT #406 PC 2268 08/31/2016 August A/P Office supplies 100.74 5,037.30 OFFICE DEPOT, INC 2309 AP 2268 08/31/2016 August A/P Office supplies 24.34 5,061.64 OFFICE DEPOT, INC 2309 AP 2268 08/31/2016 August A/P Office supplies 146.86 5,208.50 OFFICE DEPOT, INC 2309 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 404.54 5,208.50 ** 9,000.00 Budgeted 3,791.50 Remaining 58 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,004.63 .00 1,004.63 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,004.63 ** 4,003.00 Budgeted 2,998.37 Remaining 25 % Used Account: 135-65095-030-000 Maintenance Supplies 3,412.88 .00 3,412.88 _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: .00 3,412.88 ** 5,000.00 Budgeted 1,587.12 Remaining 68 % Used Account: 135-65105-030-000 Printing 2144 08/18/2016 August A/P Utility billing 3,094.26 35.23 3,129.49 DATAPROSE LLC 2237 AP 2268 08/31/2016 August A/P Aug utility billing 58.50 3,187.99 DATAPROSE LLC 2275 AP _______________ Account: 135-65105-030-000 Printing Totals: 93.73 3,187.99 ** 4,800.00 Budgeted 1,612.01 Remaining 66 % Used Account: 135-69005-030-000 Capital Outlays 2144 08/18/2016 August A/P Restroom Renovation 22,316.40 1,192.07 23,508.47 CP&Y/WALLACE GROUP, INC. 2236 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2268 08/31/2016 August A/P Restroom renovation 22,316.40 57.00 23,565.47 TX DEPT OF STATE HEALTH SVCS 2323 AP 2268 08/31/2016 August A/P Restroom Renovation Bids 1,081.56 24,647.03 STAR-TELEGRAM OPERATING LTD 2317 AP 2273 08/31/2016 August A/P Restroom renovation 260.00 24,907.03 CP&Y/WALLACE GROUP, INC. 2273 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 2,590.63 24,907.03 ** 56,000.00 Budgeted 31,092.97 Remaining 44 % Used Account: 135-69170-030-000 Copier Lease Installments 2144 08/18/2016 August A/P Copier lease payment 2,913.41 165.00 3,078.41 EVERBANK COMMERCIAL FINANCE 2239 AP 2268 08/31/2016 August A/P Copier Charges 211.74 3,290.15 KYOCERA DOCUMENT SOLUTIONS 2293 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 376.74 3,290.15 ** 4,600.00 Budgeted 1,309.85 Remaining 72 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 924,810.25 ** 1,203,217.00 Budgeted 278,406.75 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 2144 08/18/2016 August A/P PUC Legal Retainer 234,177.56 50,000.00 284,177.56 The Liston Law Firm, P.C. 2252 AP 2268 08/31/2016 August A/P july legal 4,530.00 288,707.56 FREEMAN & CORBETT 2285 AP 2268 08/31/2016 August A/P August legal 47.50 288,755.06 FREEMAN & CORBETT 2285 AP 2280 08/31/2016 August A/P Legal/August 17,870.75 306,625.81 THE LISTON LAW FIRM, P.C. AP 2280 08/31/2016 August A/P Legal/August 7,650.50 314,276.31 THE LISTON LAW FIRM, P.C. AP 2280 08/31/2016 August A/P Legal/August 1,111.25 315,387.56 THE LISTON LAW FIRM, P.C. AP 2280 08/31/2016 August A/P Legal/August 756.48 316,144.04 THE LISTON LAW FIRM, P.C. AP 2280 08/31/2016 August A/P Legal/WWTP WCP 302.75 316,446.79 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-000 Legal Totals: 82,269.23 316,446.79 ** 386,130.00 Budgeted 69,683.21 Remaining 82 % Used Account: 135-55055-039-000 Auditing 24,039.38 .00 24,039.38 _______________ Account: 135-55055-039-000 Auditing Totals: .00 24,039.38 ** 24,039.00 Budgeted (.38) Remaining 100 % Used Account: 135-55060-039-000 Appraisal 8,093.66 .00 8,093.66 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,093.66 ** 10,265.00 Budgeted 2,171.34 Remaining 79 % 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: ------------------------------------------------------------------------------------------------ 351,048.65 ** 424,234.00 Budgeted 73,185.35 Remaining 83 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 1,289,226.74 .00 Budgeted (1,289,226.74) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET AUGUST 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,389,834 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,389,834 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 11,271 TOTAL FUND BALANCE 4,389,834 TOTAL LIABILITIES AND FUND BALANCE 4,389,834 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 13:20 09/15/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,392.93- 11,270.81- 11,270.81 Subtotal: 1,392.93- 11,270.81- 11,270.81 Program number: 1,392.93- 11,270.81- 11,270.81 Department number: Revenues 1,392.93- 11,270.81- 11,270.81 Revenues Subtotal ----------- 1,392.93- 11,270.81- 11,270.81 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,392.93- 11,270.81- 11,270.81 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/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 2300 08/31/2016 August Bank Interest Texpool/Tax Bond Const WWTP (9,877.88) (1,392.93) (11,270.81) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,392.93) (11,270.81) ** .00 Budgeted 11,270.81 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (11,270.81) ** .00 Budgeted 11,270.81 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (11,270.81) .00 Budgeted 11,270.81 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET AUGUST 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK (49,265) INVESTMENTS 2,429,892 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,380,627 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,555,414 TOTAL LIABILITIES 1,555,414 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (7,508,891) TOTAL FUND BALANCE 825,213 TOTAL LIABILITIES AND FUND BALANCE 2,380,627 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 13:20 09/15/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 866.44- 15,668.73- 15,668.73 Subtotal: 866.44- 15,668.73- 15,668.73 Program number: 866.44- 15,668.73- 15,668.73 Department number: Revenues 866.44- 15,668.73- 15,668.73 Revenues Subtotal ----------- 866.44- 15,668.73- 15,668.73 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 13:20 09/15/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 913,430.17 7,524,560.02 7,524,560.02- Subtotal: 913,430.17 7,524,560.02 7,524,560.02- Program number: 913,430.17 7,524,560.02 7,524,560.02- Department number: Wastewater 913,430.17 7,524,560.02 7,524,560.02- Expenditures Subtotal ----------- 913,430.17 7,524,560.02 7,524,560.02- Fund number: 518 2015 Revenue Bond Const Fund 912,563.73 7,508,891.29 7,508,891.29- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 8/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 2300 08/31/2016 August Bank Interest Texpool/Rev Bond Const WWTP (14,802.29) (866.44) (15,668.73) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (866.44) (15,668.73) ** .00 Budgeted 15,668.73 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (15,668.73) ** .00 Budgeted 15,668.73 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 8/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 2144 08/18/2016 August A/P WWTP Improvements 6,611,129.85 49,265.30 6,660,395.15 CP&Y/WALLACE GROUP, INC. 2236 AP 2268 08/31/2016 August A/P WWTP Expansion 864,164.87 7,524,560.02 WEBBER-CADAGUA PARTNERS 2328 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 913,430.17 7,524,560.02 ** .00 Budgeted (7,524,560.02) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 7,524,560.02 ** .00 Budgeted (7,524,560.02) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 7,508,891.29 .00 Budgeted (7,508,891.29) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 195,701 ACCOUNTS RECEIVABLE - TOTAL ASSETS 195,701 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 123,739 TOTAL FUND BALANCE 195,701 TOTAL LIABILITIES AND FUND BALANCE 195,701 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 13:20 09/15/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 62.06- 403.02- 403.02 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- 62.06- 123,739.02- 100.327 403.02 Program number: 123,336.00- 123,336.00- 62.06- 123,739.02- 100.327 403.02 Department number: 123,336.00- 123,336.00- 62.06- 123,739.02- 100.327 403.02 Revenues Subtotal ----------- 123,336.00- 123,336.00- 62.06- 123,739.02- 100.327 403.02 Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 62.06- 123,739.02- 100.327 403.02 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/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 2300 08/31/2016 August Bank Interest Texpool/Rev Bond Reserve WWTP (340.96) (62.06) (403.02) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (62.06) (403.02) ** .00 Budgeted 403.02 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,739.02) ** (123,336.00) Budgeted 403.02 Remaining 100 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (123,739.02) (123,336.00) Budgeted 403.02 Remaining 100 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 20,192 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 10,353 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 35,391 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,353 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 10,353 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 865 TOTAL FUND BALANCE 25,038 TOTAL LIABILITIES AND FUND BALANCE 35,391 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 13:20 09/15/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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- 2,070.40- 656,676.03- 98.320 11,221.97- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 400.00- 8,716.66- 378.985 6,416.66 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 423.12- 3,855.95- 214.219 2,055.95 Subtotal: 671,998.00- 671,998.00- 2,893.52- 669,248.64- 99.591 2,749.36- 533-49010-000-000 Interest Income 140.00- 140.00- 212.81- 1,664.78- 1,189.129 1,524.78 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 19,951.00- 119,706.00- 100.000 Subtotal: 334,225.00- 334,225.00- 20,163.81- 335,749.78- 100.456 1,524.78 Program number: 1,006,223.00- 1,006,223.00- 23,057.33- 1,004,998.42- 99.878 1,224.58- Department number: Revenues 1,006,223.00- 1,006,223.00- 23,057.33- 1,004,998.42- 99.878 1,224.58- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 23,057.33- 1,004,998.42- 99.878 1,224.58- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 13:20 09/15/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 700.00 1,950.00 76.471 600.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 158,491.25 317,182.50 100.063 199.50- 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 685,000.00 100.000 Subtotal: 1,004,533.00 1,004,533.00 844,191.25 1,004,132.50 99.960 400.50 Program number: 1,004,533.00 1,004,533.00 844,191.25 1,004,132.50 99.960 400.50 Department number: Administration 1,004,533.00 1,004,533.00 844,191.25 1,004,132.50 99.960 400.50 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 844,191.25 1,004,132.50 99.960 400.50 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 821,133.92 865.92- 51.238 824.08- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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 2253 08/01/2016 Property Taxes (654,605.63) (249.22) (654,854.85) GL 2255 08/02/2016 Property Taxes (406.96) (655,261.81) GL 2256 08/03/2016 Property Taxes (17.73) (655,279.54) GL 2258 08/04/2016 Property Taxes (106.93) (655,386.47) GL 2259 08/08/2016 Property Taxes (54.21) (655,440.68) GL 2260 08/09/2016 Property Taxes (945.11) (656,385.79) GL 2261 08/12/2016 Property Taxes (29.72) (656,415.51) GL 2262 08/18/2016 Property Taxes (25.05) (656,440.56) GL 2287 08/22/2016 Property Taxes (110.01) (656,550.57) GL 2288 08/23/2016 Property Taxes (139.01) (656,689.58) GL 2290 08/26/2016 Property Taxes 13.55 (656,676.03) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,070.40) (656,676.03) ** (667,898.00) Budgeted (11,221.97) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2253 08/01/2016 Property Taxes (8,316.66) (3.84) (8,320.50) GL 2255 08/02/2016 Property Taxes (274.75) (8,595.25) GL 2260 08/09/2016 Property Taxes (118.53) (8,713.78) GL 2289 08/25/2016 Property Taxes (2.88) (8,716.66) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (400.00) (8,716.66) ** (2,300.00) Budgeted 6,416.66 Remaining 379 % Used Account: 533-40015-000-000 Property Taxes/P & I 2253 08/01/2016 Property Taxes (3,432.83) (1.18) (3,434.01) GL 2255 08/02/2016 Property Taxes (60.03) (3,494.04) GL 2258 08/04/2016 Property Taxes (40.74) (3,534.78) GL 2259 08/08/2016 Property Taxes (4.61) (3,539.39) GL 2260 08/09/2016 Property Taxes (297.08) (3,836.47) GL 2261 08/12/2016 Property Taxes (2.08) (3,838.55) GL 2262 08/18/2016 Property Taxes (1.75) (3,840.30) GL 2287 08/22/2016 Property Taxes (8.80) (3,849.10) GL 2288 08/23/2016 Property Taxes (6.85) (3,855.95) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (423.12) (3,855.95) ** (1,800.00) Budgeted 2,055.95 Remaining 214 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2300 08/31/2016 August Bank Interest Texpool/MUD 1 I&S (1,451.97) (212.81) (1,664.78) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (212.81) (1,664.78) ** (140.00) Budgeted 1,524.78 Remaining 1.189 % 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 2103 08/10/2016 Texpool Transfers (99,755.00) (19,951.00) (119,706.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (119,706.00) ** (119,706.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,004,998.42) ** (1,006,223.00) Budgeted (1,224.58) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 2307 08/25/2016 Bond Payments TCMUD1-13 Paying Agent Fee 1,250.00 500.00 1,750.00 GL 2307 08/25/2016 Bond Payments TCMUD Tax Bond Series 2014 200.00 1,950.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 700.00 1,950.00 ** 2,550.00 Budgeted 600.00 Remaining 76 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 2307 08/25/2016 Bond Payments TCMUD1 Series 2013 158,691.25 24,012.50 182,703.75 GL 2307 08/25/2016 Bond Payments TCMUD Tax Bond Series 2014 74,162.50 256,866.25 GL 2307 08/25/2016 Bond Payments TCMUD 1 Series 2010 35,641.25 292,507.50 GL 2307 08/25/2016 Bond Payments TCMUD1 Series 2012 24,675.00 317,182.50 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 158,491.25 317,182.50 ** 316,983.00 Budgeted (199.50) Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 2307 08/25/2016 Bond Payments TCMUD1 Series 2013 175,000.00 175,000.00 GL 2307 08/25/2016 Bond Payments TCMUD Tax Bond Series 2014 235,000.00 410,000.00 GL 2307 08/25/2016 Bond Payments TCMUD 1 Series 2010 75,000.00 485,000.00 GL 2307 08/25/2016 Bond Payments TCMUD1 Series 2012 200,000.00 685,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: 685,000.00 685,000.00 ** 685,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 1,004,132.50 ** 1,004,533.00 Budgeted 400.50 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (865.92) (1,690.00) Budgeted (824.08) Remaining 51 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET AUGUST 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,092 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,092 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 24 TOTAL FUND BALANCE 15,092 TOTAL LIABILITIES AND FUND BALANCE 15,092 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 13:20 09/15/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/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- 81.68- 424.10- 6,058.571 417.10 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 444,837.52- 100.001 6.52 Subtotal: 444,838.00- 444,838.00- 43,302.00- 445,261.62- 100.095 423.62 Program number: 444,838.00- 444,838.00- 43,302.00- 445,261.62- 100.095 423.62 Department number: Revenues 444,838.00- 444,838.00- 43,302.00- 445,261.62- 100.095 423.62 Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,302.00- 445,261.62- 100.095 423.62 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 13:20 09/15/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 200.00- 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 117,418.75 235,037.50 100.085 199.50- 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 210,000.00 100.000 Subtotal: 444,838.00 444,838.00 327,618.75 445,237.50 100.090 399.50- Program number: 444,838.00 444,838.00 327,618.75 445,237.50 100.090 399.50- Department number: Administration 444,838.00 444,838.00 327,618.75 445,237.50 100.090 399.50- Expenditures Subtotal ----------- 444,838.00 444,838.00 327,618.75 445,237.50 100.090 399.50- Fund number: 534 2015 Revenue Bond I&S 284,316.75 24.12- 24.12 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/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 2300 08/31/2016 August Bank Interest Texpool/Rev Bond I&S WWTP (342.42) (81.68) (424.10) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (81.68) (424.10) ** (7.00) Budgeted 417.10 Remaining 6.059 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 2103 08/10/2016 Texpool Transfers (401,617.20) (43,220.32) (444,837.52) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (444,837.52) ** (444,831.00) Budgeted 6.52 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,261.62) ** (444,838.00) Budgeted 423.62 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 13:21 09/15/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 2307 08/25/2016 Bond Payments Rev Bonds WWTP Series 2015 200.00 200.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 2307 08/25/2016 Bond Payments Rev Bonds WWTP Series 2015 117,618.75 117,418.75 235,037.50 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 117,418.75 235,037.50 ** 234,838.00 Budgeted (199.50) Remaining 100 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 2307 08/25/2016 Bond Payments Rev Bonds WWTP Series 2015 210,000.00 210,000.00 GL _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 210,000.00 210,000.00 ** 210,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 445,237.50 ** 444,838.00 Budgeted (399.50) Remaining 100 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (24.12) .00 Budgeted 24.12 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 8,436,437.01 **** (125,026.00) Budgeted (8,561,463.01) Remaining ########## ******* End of Report *********